In Excel create a template that shows our stock by age
- or -
Post a project like this1604
£79(approx. $98)
- Posted:
- Proposals: 10
- Remote
- #2593573
- Awarded
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
Creative Graphics Designer & Full stack Developer| Shopify expert| Data entry |PDF Editing
Toronto
13575931406416164581517115862207687290062730753103076930309484584880
Description
Experience Level: Entry
The report you see on sheet 1 shows the age of our stock on a given day.
By using the attached report, create a template that will produce a sheet that looks like Sheet 2.
What I would like to be able to do is put the data in sheet 1 on to a template without having to edit it, so that it produces a graphic portrayal of the stock position on sheet 2.
In its current format I am able to view this in print one page wide on A4 in landscape and want to be able to continue to. It wont matter if it extends to 2 pages downwards.
You will see that the reg no is combined with the vehicle description on sheet 2 (this is important).
The box is coloured green if the vehicle is under 30 days old
The box is amber if the vehicle is 30 to 60days old
The box is red if the vehicle is 60 to 90 days old
The box is white, and the text is bright red if the vehicle is over 90 days old
The hierarchy from the top should be, green, amber, red and white with red text.
Variables are the number of vehicles
We sell vehicles they are categorised into 8 groups.
Currently Corsa, Fiesta, Focus, Astra, Qashqai, Kuga, Mokka and Other.
From time to time another vehicle becomes more popular from the ‘Other’ group if so we would want to show that in our 1 to 7 cars and demote another vehicle to the ‘Other’ group.
In the format on sheet 2 we are all able to see the age of each item of stock in a model group and it hierarchy by age.
By using the attached report, create a template that will produce a sheet that looks like Sheet 2.
What I would like to be able to do is put the data in sheet 1 on to a template without having to edit it, so that it produces a graphic portrayal of the stock position on sheet 2.
In its current format I am able to view this in print one page wide on A4 in landscape and want to be able to continue to. It wont matter if it extends to 2 pages downwards.
You will see that the reg no is combined with the vehicle description on sheet 2 (this is important).
The box is coloured green if the vehicle is under 30 days old
The box is amber if the vehicle is 30 to 60days old
The box is red if the vehicle is 60 to 90 days old
The box is white, and the text is bright red if the vehicle is over 90 days old
The hierarchy from the top should be, green, amber, red and white with red text.
Variables are the number of vehicles
We sell vehicles they are categorised into 8 groups.
Currently Corsa, Fiesta, Focus, Astra, Qashqai, Kuga, Mokka and Other.
From time to time another vehicle becomes more popular from the ‘Other’ group if so we would want to show that in our 1 to 7 cars and demote another vehicle to the ‘Other’ group.
In the format on sheet 2 we are all able to see the age of each item of stock in a model group and it hierarchy by age.
Karl W.
100% (1)Projects Completed
4
Freelancers worked with
3
Projects awarded
57%
Last project
30 Oct 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Do you have the exact dates the coloured boxes are based on. It would be useful to help create what you want.
861055
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies