The Total Cost of Ownership Spreadsheet Tool (TCOST) is a Microsoft Excel-based calculator that simplifies and integrates the main functions, data, and outputs of pre-existing models (MOVES-Matrix and the GREET Model) and other external sources of economic data. The tool accommodates twenty-one user-input variables to produce comparative total cost of ownership figures for diesel and battery-electric trucks within any use case, broken down by cost type (capital, operation, and maintenance), both as a gross number and on a per-mile basis. The tool also provides a series of visualizations comparing cost breakdowns, breakeven points, and expected tailpipe and fuel-cycle emissions for both technologies.
