How-to Video 5: Present Forecast Modeling Data in a Combination Chart
TEMPE, AZ – The final video of Aaron Alvarado’s how-to video series on presenting fleet data goes through how to present forecast modeling data in an eye-appealing format.
TEMPE, AZ – Video 5 of Aaron Alvarado’s how-to video series on presenting fleet data goes through how to present the forecast modeling data from Video 4 in an eye-appealing format. This allows the fleet manager to take a large quantity of data and create a clear and concise data summary in a graph format.
This is the last video in a five-part How-to video series on presenting data for fleet benchmarking, presented by Alvarado, fleet manager for the City of Tempe, Ariz. Alvarado has covered how to graphically depict idle time, how to embed this idle time graph into Excel, how to combine and separate data fields in Excel using the concatenate/de-concatenate function, and how to create a forecast model by cost center.
More Operations

NCDOT Adds Dash Cam Imagery to Statewide Traffic Monitoring
North Carolina transportation officials are adding another set of eyes to roads that aren't covered by fixed traffic cameras. A statewide deployment gives NCDOT access to on-vehicle imagery to verify conditions during work zones, severe weather, emergencies, and other traffic events.
Read More →
Turning a Bottleneck Into a Blueprint: How Tallahassee Rethought Police Fleet Readiness
For Tallahassee, finally receiving 87 delayed police cruisers created a new problem: how to get them on the road without creating a massive backlog. The solution would change more than the upfit process.
Read More →
AI, Police Fleet Readiness and Fire Apparatus News
See how AI, a reworked police-vehicle upfitting process, and a fire apparatus acquisition could affect public fleet operations.
Read More →
Stay ready, set and safer with verified fleet inspections.
When fleet inspections aren’t verifiable, missed defects can quickly become downtime, safety risks, and service delays. This white paper shows government and municipal fleet leaders how digital inspections can improve accountability, catch issues earlier, and keep vehicles ready when they’re needed most.
Read More →
How AI and Automation Work Together to Reduce Government Fleet Downtime
As their assets age and their budgets’ purchasing power shrinks, government fleet managers are facing growing pressure to do more with less.
Read More →
Police Fleet Innovation, EV Strategy and AI
See how public fleets are rethinking police vehicle readiness, electrification, workplace culture, and driver workflows.
Read More →
From What He Inherited to What He’ll Leave Behind: David Renschler’s Lessons in Leadership
David Renschler walked into Fairfield with plenty to learn and no idea what awaited him. Twenty years later, the lessons from what came next are still shaping his approach to fleet.
Read More →
Have Fleets Changed Enough to Solve the Technician Shortage?
Are government fleets finally closing the gap on the technician shortage, or are critical challenges still holding them back?
Read More →
How Public Fleets Are Rethinking Vehicles, EVs, and Culture
From mission-specific vehicles to EV planning and culture change, this week’s stories show how public fleets are rethinking the way they operate.
Read More →
How Salem, Oregon, Turned Culture Change Into a No. 1 Fleet Ranking
Fleet availability reached 98.95% after Salem empowered employees and used performance data to guide years of steady improvement.
Read More →

