Fleet Tracking

Can any1 help in creating excel sheets with below tabulation. as i am working with a transport company and i need to keep track of my fleet which goes through below cycle on the movement from different locations.


Truck Details & Driver
No. Truck no. Trailor no. Make Driver Name Mobile No.


Empty from A- B
No. Date left Truck no. Trailor No. Current Location Arrival @B information No.of days


Departures from B. To A - Loaded
No. Date left Truck no. Trailor No. Product Client Destination Current Location Date of arrived Information No.of days


Departures from A to up countries
No. Date left Truck no. Trailor No. Product Client Destination Current Location Date of arrived Information No.of days


Returning Trucks from up countries to location A
No. Date left Truck no. Trailor No. Status -Loaded/Empty (L/E) Product Current Location Current Location Information Current Location



Returned Loaded heading to Location B
No. Date left Truck no. Trailor No. Product Current Location Current Location Information Current Location