EV helper spreadsheet

[hallkbrdz]

Here is what I think is a reasonably correct and complete motor / controller / battery spreadsheet for people interested in building an electric racing kart (or something similar in size) using PMSM motors to help understand how various choices of components effect the overall package. You will need to activate the macros to use the pull-down lists. I am US based so prices are from US suppliers, but most items are labeled in both metric and standard units.

If you find any errors or obvious omissions, please let me know so I can correct this in the next revision.

https://drive.google.com/file/d/12zzOV-7sqUpvYe8b3BMkESu22b226cNz/view?usp=sharing

 

[hallkbrdz]

Version 1.4

Added / Changed:
Split-up Setup from battery choices
More battery choices
More motor choices
More controller choices

Fixed:
Ah ratings

https://drive.google.com/file/d/1WJ3svDG1oYfitmYFvyqyKtUe1LF1YwYU/view?usp=sharing

 

[hallkbrdz]

Version 1.5

Added / Changed:
LiPo load ratings to better match kart measured values under load
Parallel calculations to fix low C rate battery amounts (high kWh low C rate)

https://drive.google.com/file/d/1qBYzZQ6ao90OmtStwTe7BvnWxUziidox/view?usp=sharing

 

[hallkbrdz]

Version 1.8

Added / Changed:
Separated cells by packaging type
Added percent remaining of battery charge for time and load specified
Added more motors

https://drive.google.com/file/d/16D-9xhCXHusG5DgeGXXMVu3DraE7minm/view?usp=sharing

 

[hallkbrdz]

Version 20200909

Added / Changed:

Added more motors
Added more controllers
Added current configurations for various ekart battery packs

https://drive.google.com/file/d/17zbJZlLocxkfjNDHHixH1WDFVqIe6gAd/view?usp=sharing

 

[hallkbrdz]

Added my best estimate for the new Tesla 4680 cell based on the slides to the cylindrical tab. Enjoy!

https://drive.google.com/file/d/17zbJZlLocxkfjNDHHixH1WDFVqIe6gAd/view?usp=sharing