Excel Engine Service Tracker for Transport Company
Budget: $10 – $30 USD
I am looking for a skilled Excel developer to create a service tracker for our transport company. The tracker should have the following features:
- Service history tracking: The tracker should allow us to keep track of the service history for each vehicle in our fleet.
- Vehicle maintenance schedule: It should include a schedule for vehicle maintenance, reminding us of when each vehicle is due for service.
- Expense tracking: We need the tracker to track expenses related to vehicle maintenance and repairs.
Layout:
- As I don't have a specific layout in mind, I would like the developer to provide recommendations based on their expertise and experience.
Number of vehicles:
- We have a large fleet of vehicles, so the tracker should be able to handle tracking more than 50 vehicles.
Skills and experience:
- Proficiency in Excel and experience in creating complex spreadsheets with data tracking and scheduling features.
- Knowledge of vehicle maintenance and service tracking would be a plus.
- Strong attention to detail and the ability to create a user-friendly and intuitive interface for easy data input and tracking.
We are a transport company with a fleet of 150 trucks, and we need an Excel sheet to track engine service schedules based on the odometer reading. Some of our trucks require engine oil service after 10,000 km, while others require it after 7,000 km. We are looking for an Excel expert to create a basic engine service tracker that will allow us to:
Key Requirements:
Odometer-Based Service Tracking: The Excel sheet should calculate and display the next service due for each truck based on its current odometer reading.
Different Service Intervals: The sheet should accommodate two different service intervals (10,000 km and 7,000 km) for different trucks in our fleet.
Easy Data Entry: We should be able to easily enter the odometer readings for each truck and have the sheet automatically calculate and display the next service due date.
Deliverables:
A basic Excel sheet that meets the above requirements.
Timeline:
We need this project to be completed within 2 days from the date of hiring.
Please provide examples of previous Excel projects you have worked on and any relevant experience in the transport industry.
- Service history tracking: The tracker should allow us to keep track of the service history for each vehicle in our fleet.
- Vehicle maintenance schedule: It should include a schedule for vehicle maintenance, reminding us of when each vehicle is due for service.
- Expense tracking: We need the tracker to track expenses related to vehicle maintenance and repairs.
Layout:
- As I don't have a specific layout in mind, I would like the developer to provide recommendations based on their expertise and experience.
Number of vehicles:
- We have a large fleet of vehicles, so the tracker should be able to handle tracking more than 50 vehicles.
Skills and experience:
- Proficiency in Excel and experience in creating complex spreadsheets with data tracking and scheduling features.
- Knowledge of vehicle maintenance and service tracking would be a plus.
- Strong attention to detail and the ability to create a user-friendly and intuitive interface for easy data input and tracking.
We are a transport company with a fleet of 150 trucks, and we need an Excel sheet to track engine service schedules based on the odometer reading. Some of our trucks require engine oil service after 10,000 km, while others require it after 7,000 km. We are looking for an Excel expert to create a basic engine service tracker that will allow us to:
Key Requirements:
Odometer-Based Service Tracking: The Excel sheet should calculate and display the next service due for each truck based on its current odometer reading.
Different Service Intervals: The sheet should accommodate two different service intervals (10,000 km and 7,000 km) for different trucks in our fleet.
Easy Data Entry: We should be able to easily enter the odometer readings for each truck and have the sheet automatically calculate and display the next service due date.
Deliverables:
A basic Excel sheet that meets the above requirements.
Timeline:
We need this project to be completed within 2 days from the date of hiring.
Please provide examples of previous Excel projects you have worked on and any relevant experience in the transport industry.