EV helper spreadsheet

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

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

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

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

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

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