The Fleet Procurement Analysis Tool equips users with decision-relevant information on the financial viability and environmental impact of light-, medium-, and heavy-duty vehicle fleet procurements. The Microsoft Excel-based tool can evaluate a variety of procurement ownership structures, vehicle types, and procurement scenarios. The tool compares procurements side-by-side on a cost-per-mile basis and provides an analysis of cash flows and location-specific lifecycle emissions. The tool is highly flexible, supports customizable sensitivity variables, and produces user-friendly results summaries.

This tool was originally created with funding from the U.S. Department of Energy.

Excel Tool with Canadian Market Defaults

Canadian metrics supported by

User Guide

Let us know if you need help!

Training Video

Release Notes

Found what’s new and download previous versions of the tool.

Version	Date	Author	Organization	Revisions
1.33	4/12/2024	Nick Nigro, Spencer Burget	Atlas Public Policy	Temporarily disable state incentives. Change federal incentives to a manual input following tax credit changes from Inflation Reduction Act. Resolve bugs with optimized rate calculation.
1.32	3/5/2024	James Di Filippo, Nick Nigro	Atlas Public Policy	Updated maintenance costs with results from 2021 Argonne National Laboratory study. Updates to depreciation calculation for BEVs using new used vehicle data. Updates to fuel prices for 2023. Added more new vehicle models for model year 2023 and 2024.
1.31	5/2/2023	James Di Filippo, Nick Nigro	Atlas Public Policy	Resolved issues with custom rates in billing model module. Correct error with User-Defined Custom Rate Structure when the Workbook structure is protected.
1.30	3/16/2023	James Di Filippo, Josh Rosenberg, Nick Nigro	Atlas Public Policy	Added in Billing Model to calculate electricity price based on custom charging billing setup. Added in LCFS Model to include inputs for Utility Value income and carbon fuel credits. Updated data for multiple sources. Resolved error in calculation of Canadian maintenance prices.
1.26	2/28/2023	Nick Nigro	Atlas Public Policy	Resolve issue with emissions calculations.
1.25	10/7/2022	Nick Nigro	Atlas Public Policy	Fixed formula for loan calculation. Previous calculation was attempting to do monthly accrual of principle and interest payments. This was inaccurate since the model is annual. This change affected loan calculations for vehicles and infrastructure. Also, updated data for 2022.
1.24	11/30/2021	Nick Nigro	Atlas Public Policy	Resolved another regression with Save/Load settings.
1.23	11/16/2021	Nick Nigro	Atlas Public Policy	Resolved regression with Save/Load settings.
1.22	11/10/2021	Nick Nigro	Atlas Public Policy	Corrected error in calculation of electricity prices from EIA.
1.21	9/14/2021	Josh Rosenberg	Atlas Public Policy	Updated vehicle availability and state incentives. Resolved issue where users were unable to select a charging level. Added license.
1.20	4/9/2021	Nick Nigro, Josh Rosenberg	Atlas Public Policy	Resolved issue related to incorrect emissions modeled for Canadian provinces.
1.19	4/7/2021	Nick Nigro, Josh Rosenberg	Atlas Public Policy	Updated data for U.S. and Canadian market for fuel prices, vehicles available, incentives, and inflation.
1.18	11/30/2020	Nick Nigro	Atlas Public Policy	Improved descriptions in tool. Corrected emissions factor for NOx emissions for heavy-duty vehicles. Added many more vehicles to vehicle database from fueleconomy.gov and Atlas database of medium- and heavy-duty vehicles. Updated light-duty vehicle depreciation calculation for BEVs to reflect resale data from 2015-2019. Updated light-duty vehicle insurance costs and charging infrastructure costs. Updated medium- and heavy-duty vehicle maintenance costs using the 2019 version of AFLEET.
1.17	2/12/2020	Nick Nigro	Atlas Public Policy	Updated fuel prices for 2019, vehicle availability through February 2020, and eGrid for 2018. Fixed bugs with cash flow chart and Load/Save feature.
1.16	12/11/2019	Nick Nigro	Atlas Public Policy	Fixed bug with vehicle selection.
1.15	11/20/2019	Nick Nigro	Atlas Public Policy	Fixed bug with custom vehicle selection.
1.14	9/17/2019	Nick Nigro	Atlas Public Policy	Upgrade to support medium- and heavy-duty vehicles. Fixed bug with calculating maintenance costs for Canadian market. Updated vehicle incentives for light-duty vehicles to remove federal incentive for Tesla and General Motors. Added vehicles for model years 2019 and 2020.
1.13	6/17/2019	Nick Nigro	Atlas Public Policy	Fixed bug with calculating costs for Purchased (loan) when lease year is set to a non-zero value.
1.12	4/12/2019	Nick Nigro	Atlas Public Policy	Update data through 2018 for U.S. and Canadian markets.
1.11	1/18/2018	Nick Nigro	Atlas Public Policy	Add significantly more U.S.-based light-duty vehicles (over 2,000). Updated fuel price data for 2017.
1.10	12/4/2017	Philip Quebe	The Cadmus Group, Inc.	Backend code improvements
1.09	11/17/2017	Philip Quebe	The Cadmus Group, Inc.	Improvements to sensitivity analysis functionality. Added ability to model both baseline and comparison scenarios in a single sensitivity chart. Simplified and organized sensitivity selection options.
1.08	10/20/2017	Nick Nigro	Atlas Public Policy	Added support for Canadian market (metric system, Canadian province-specific data, etc.). Moved remaining hardcoded defaults to Data tab to make it easier for users to customize them. Speed up user experience when editing inputs. Updated GREET figures for gasoline emissions. Updated U.S. insurance costs. Argument files created with previous version of the tool will not work correctly.
1.07	9/5/2017	Nick Nigro	Atlas Public Policy	Fix to allow users to add custom vehicles to “DB_Vehicles” table.
1.06	7/3/2017	Nick Nigro	Atlas Public Policy	Added support for U.S. average emissions and fuel prices. Use ZIP Code 00000 to set to U.S. average. Added support for more comprehensive vehicle selection and vehicle incentives. Improved robustness of some table lookup calculations. Added link to vehicle details on fueleconomy.gov.
1.05	6/1/2017	Philip Quebe	The Cadmus Group, Inc.	Minor bug fixes: sensitivity analysis and EV infrastructure inputs
1.00	5/30/2017	Philip Quebe	The Cadmus Group, Inc.	First launch

User License

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.