A simple ground transport vehicle model in a Microsoft Excel spreadsheet. This works from the basic forces and equations of motion to calculate acceleration, steady state power / energy consumption through to drive cycle requirements.
The vehicle model has a very simple interface. Modify values where they have a white background, eg Mass and you instantly see the impact on the power demand and drive cycle energy requirement.
The model allows you to compare two vehicles side by side.
or the same vehicle and with different battery arrangements/chemistry.
The idea was to make something that can give you a directional result very simply.
The basics of the calculations are given in our pages on the Road Vehicle Model.
Over time we will use this simple model in case studies to explore different vehicle and battery pack designs. Also, we will explore every element of how this works in posts within the system design pages.
Updates: the price has been kept very low as a single one off purchase at $15. The all access Download Pass is just $40 will give you the option to download any file and any update of the file for 1 year from purchase date. Both these options are for individual access and personal use.
| Version | Description |
| 0.14 | This is a very early draft and hence limitations and initially a lack of notes |
| 0.16 | Battery Pack Voltage, Current and Heating vs Time |
| 0.18 | Derate range limits from Temperature, Current and Voltage |
| 0.19 | Artemis Urban and Road repeated for 2 hours as cycle options for duration test |
| 0.24 | Vehicle 1 is now a selectable option from a number of vehicles including Maeving RM1s, Tesla Model 3 and Tesla Semi. |
| 0.25 | Added in a criteria to spot the failed to solve issue with the battery quadratic, this will be due to the battery pack voltage collapsing rapidly at some point. |
Business Users
If you want to use the downloads in a business then we ask that you purchase the pass appropriate to your company size. This pass will give you corporate access to all of the downloadable files for 1 year. That includes the Cell and Battery Pack database as well as the Calculations Workbook and all of their updates for 1 year.
Use does not include resale or making the data available to users outside of the company/corporation.