Welcome to the Municipal Facilities Assessment Tool

Once you’ve completed the Fleet Planning Tool and taken the time to understand the benefits of electrifying your fleet(s), you may want to use the Facilities Assessment Tool to develop an understanding of how much charging infrastructure you need to support the vehicle electrification opportunities you have identified, which of your facilities would be best suited to accommodate new EV Service Equipment (EVSE), and/or Distributed Energy Resources (DER) such as PV arrays for generating energy on-site and batteries to manage your demand peaks.

You’ll notice that it’s set up quite similarly to the Fleet Planning Tool. We’ve again prepared a “Facility Data Template” for you to input relevant information, and we even added a new sheet to the Fleet Planning Tool that will help you automatically organize some of the EV-related data inputs like expected charging load per facility. The “Data Input” sheet groups info into five categories which take information about the current and planned states of your facility to perform a preliminary feasibility analysis.

The Facilities Assessment Tool will guide you through the following steps:

  • Description: A series of questions to set the context and framework around your facilities assessment.
  • Result: An understanding of the scope of your facilities assessment.
  • Estimated Time: ~1 hour
  • Description: Guidance on finding and gathering data necessary to complete a facilities assessment.
  • Result: A clean, organized database that can be input to complete the remaining steps of the facilities assessment and/or turned over to a consultant to streamline a future project.
  • Estimated Time: ~3-6 weeks
  • Description: A preliminary ranking of the EVSE/DER potential of all your sites.
  • Result: Sites are ranked on a scale from “A” to “C”, with sites ranked “A” being sites with high potential for incorporating these resources and sites ranked “C” being sites that will likely take more effort and investment to incorporate EVSE/DER. 
  • Estimated Time: Automatically calculated from data input.
  • Description: Preliminary calculations on cost and equipment to give you a starting point from which to do further analysis.
  • Result: Estimated available power (kW) before having to change electrical panel, comparison of managed vs unmanaged EV charging strategies, tenching costs of EVSE, PV production potential (kWh).
  • Estimated Time: Automatically calculated from data input.

PS: Thanks for trying out the Municipal Facilities Assessment Tool! This tool is still in Beta and will be updated throughout 2023/24.

List of Data Fields

You can find definitions for these data fields in the Fleet Data Template

Required Data Optional Data
Equipment ID Expected Service Life (yrs)
Make Fuel Usage
Model FHWA Vehicle Class
Model Year Gross Vehicle Weight Rating
Purchase Price  
Aux. Eq. Cost  
Current Life-to-Date (LTD) Maintenance Cost  
Fuel Type  
Powertrain  
Department  
Domicile Location  
Meter Type  
Beginning Meter Read  
Ending Meter Read  
Body Class  

We've got you covered

We made a set of dummy data in case you need more help filling out your data template. This Excel file will be identical to the Fleet Database Template, but all of our dummy data will be filled in to give you a better idea of what yours might look like. Maybe it will be shorter, maybe it will be longer, but the format will be the same.

You may want telematics...

Telematics can help you make smart decisions about your fleet to help you minimize cost and maximize impact. We have compiled some resources that might help convince you to get telematics.

Great!

We will come back to telematics later in the process.