Hi Guys,
I'm new in excel, can you help me to make this all registration put in a group the compute the consumption and kilometer, and total fuel issued. is this possible to get it automated.
Company Description Registration ODO Meter Fuel Issued Date Consumption per 100 KM
EURO LOG Tipper Truck Volvo *C3DT0018-AJI685 9000 150 09/03/2014
EURO LOG Tipper Truck Volvo *C3DT0018-AJI685 925 150 09/04/2014
EURO LOG Tipper Truck Volvo *C3DT0018-AJI685 9050 150 09/05/14
EURO LOG Tipper Truck Volvo *C3DT0018-AJI685 10000 150 09/06/14
EURO LOG Tipper Truck Volvo *C3DT0018-AJI685 11000 150 09/08/14
Total 2000 600 30
EURO LOG CAT 160G Grader *C3GR0001/AGM747 8795 450 09/03/2014
EURO LOG CAT 160G Grader *C3GR0001/AGM747 8801.7 350 09/04/2014
EURO LOG CAT 160G Grader *C3GR0001/AGM747 8820.3 315 09/05/14
EURO LOG CAT 160G Grader *C3GR0001/AGM747 350 09/06/14
EURO LOG CAT 160G Grader *C3GR0001/AGM747 8825.8 250 09/08/14
Total 30.8 1465 4756.493506
Bookmarks