Ms. Excel dashboard for truck daily monitoring
Budget: $30 – $250 USD
I want to make realtime excel dashboard about truck monitoring that can be monitored by ms excel app on my phone (considering some formula wont work when opened from Ms. excel mobile)
Input:
1. I have a new sheet everyday that contain truck used that day, their type, route and delivery date.
2. I have an excel price matrix database to calculate trucking cost (must be flexible if i want to update price).
3. I have an excel each route delivery time database (how long it takes to deliver to certain route).
Output :
Combine those data to create a real-time dashboard that shows:
1. Each truck latest delivery route and date.
2. Availability of truck for today and tomorrow (by considering their latest delivery and delivery time).
3. Data for each truck delivery route till the latest delivery,
4. and cost on each delivery and total cost till latest delivery.
5. Real-time dashboard that shows total truck delivered today that can be categorized by certain type.
Input:
1. I have a new sheet everyday that contain truck used that day, their type, route and delivery date.
2. I have an excel price matrix database to calculate trucking cost (must be flexible if i want to update price).
3. I have an excel each route delivery time database (how long it takes to deliver to certain route).
Output :
Combine those data to create a real-time dashboard that shows:
1. Each truck latest delivery route and date.
2. Availability of truck for today and tomorrow (by considering their latest delivery and delivery time).
3. Data for each truck delivery route till the latest delivery,
4. and cost on each delivery and total cost till latest delivery.
5. Real-time dashboard that shows total truck delivered today that can be categorized by certain type.