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

How Dakota County Built a More Structured Fleet Operation
Kevin Schlangen shares how Dakota County’s fleet moved from reactive repairs and limited oversight to a more structured approach built around planning, training, and long-term cost control.
Read More →
Is Your Fleet Ready Before the Storm Hits? | GovCast Cheat Sheet
Could better preparation before a storm and new vehicle technology help fleets recover faster while improving safety?
Read More →
New York City Orders Safety Technology for Municipal Fleet
New York City is expanding the use of pedestrian alerts and intelligent speed assistance across its non-emergency fleet. The executive order establishes new technology requirements for future vehicle purchases while accelerating retrofits on thousands of existing municipal trucks.
Read More →
The Network Behind Better Government Fleet Decisions
A discussion on why relationships across the government fleet community have played such an important role and what shapes the leadership response.
Read More →
Ford, BlackRock, Google and Carhartt Form Skilled Trades Workforce Alliance
The alliance plans to develop a stronger pipeline between training programs and available jobs while examining workforce efforts already underway across the country.
Read More →
The Network Behind Better Government Fleet Decisions
A discussion on why relationships across the government fleet community have played such an important role and what shapes the leadership response.
Read More →
What Makes Fleet Technicians Stay? | GovCast Cheat Sheet
The technician hiring and retention discussion is not new, but the way fleets respond to it continues to matter.
Read More →
On the Road with Government Fleet: Essential Podcasts for Professionals
Let's celebrate listening! Check out a GovCast podcast and discover the insights and strategies that can transform your fleet management approach.
Read More →
How Real-World Vehicle Use Guides Replacement And Budgets
Three public fleet leaders explain how they use real-world vehicle data and long-term planning to keep aging assets in service and make more informed replacement and budgeting decisions in a high-cost environment.
Read More →


