Morning all

I am looking to put togther a small fleet truck mileage tracking spreadsheet, new, but manually backfitted with data from an old, really ugly, spreadsheet. The current person doing the entry is not detail oriented so I would like to lock down most information except for the data entry. The ones that maintained the old sheet would just copy and paste the info and bring all the baggage and formatting and extracting the information is like pulling teeth. There a couple dozen sheets (not in the same format) roughly based on date.

The current daily entries would be truck, driver, odometer start, odometer end, date, date, and hours but most of the older the data (a year to two years old) contains just dates and miles periodically. There are about 40+ trucks in the fleet and they come and go depending on age, mileage, and condition.

What would be the best way to arrange the data to be able to provide the most useable information to satisfy a PR hungry manager? ...minimize or ease data entry?

They seem to like things like -- "the fleet has reached the 7 million miles" or this truck has put in 100,000 miles this year, or this one has 160,000 miles and is ready for a rebuild, or this truck averages 200 miles/day. Each truck runs an average of 60,000 miles per year depending on work load. I'm not used to working with running or accumulating data and dates and I am not sure of the best way to present the information (i.e. pivottable, dashboard, or basic report).