Fleet maintenance tracker

[aachoudh]

Hi i need help building a Simple work sheet for 6 fleet vehicles, its needs to set up in a way, where i can update oil level on a daily basis and when it comes below 2 bars, it highlights in a different colour, please help in building this sheet, i have seen it done , i just cant figure out how to make one.

 

[mole999]

what have you got so far, its very useful to see the layout and values you need to work with, rather than you adapting something that is offered

 

[aachoudh]

Well basically 6 Vehicles, they need to maintain 4 bars for oil level in the trucks, everyday the driver gives me a pre trip sheet where they inspect the truck, in that pretrip sheet there is a section where they write in how many bars the oil level is showing, i then take the sheet and need to record oil levels, right now i have a manual hand written system set up, i am very beginner at excel and i want to set up a sheet where i can have the trucks in one coloumn and then a daily log where i type in how many bars are showing so the numerical numbers could be 1-4,the moment i record 2 bars or less for any truck i would like for me to highlight it red, this way it shows me how often im having to fill and what my trend is, PLEASE SOMEONE HELP ME BUILD THIS SHEET, you can help me save my job!

 

[mole999]

If that is your only check, I would have each vehicle in their own column B to G. In A I would have the date. I would use a custom format over B to G from 4 to 700 (2 years worth) the format is easy to apply and would be between 0.01 and 2

Excel Workbook
	A	B	C	D	E	F	G
1		Oil Check
2		Truck 1	Truck 2	Truck 3	Truck 4	Truck 5	Truck 6
3	Date
4	20/08/2016	4
5	21/08/2016	4
6	22/08/2016	3
7	23/08/2016	2
8	24/08/2016	4
9	25/08/2016	4
10	26/08/2016	4
11	27/08/2016	3
12	28/08/2016
13	29/08/2016
14	30/08/2016
15	31/08/2016
16	01/09/2016
17	02/09/2016
18	03/09/2016
19	04/09/2016
20	05/09/2016
21	06/09/2016
Sheet1

 

[aachoudh]

Thank you mole999, is it possible i can download that worksheet you created? its actually perfect, very simple and to the point. I appreciate the help

 

[mole999]

you could pick that image up and place on a worksheet, all you then have to do, is select the area for the oil level, open conditional format and set as
BETWEEN 0.01 AND 2, and add a colur

 

[aachoudh]

done and done, Thanks again, i will be posting for more help in future threads as my job is becoming more and more reliant on me making spread sheets