EV helper spreadsheet

Electric cars, trucks, ATVs, NEVs - things bigger than a motorcycle.
Post Reply
User avatar
hallkbrdz   100 W

100 W
Posts: 141
Joined: Mar 24 2018 1:47pm
Location: Edmond, OK USA

EV helper spreadsheet

Post by hallkbrdz » Jun 17 2020 8:48pm

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- ... sp=sharing

User avatar
hallkbrdz   100 W

100 W
Posts: 141
Joined: Mar 24 2018 1:47pm
Location: Edmond, OK USA

Re: EV helper spreadsheet

Post by hallkbrdz » Jun 23 2020 1:59pm

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/1WJ3svD ... sp=sharing

User avatar
hallkbrdz   100 W

100 W
Posts: 141
Joined: Mar 24 2018 1:47pm
Location: Edmond, OK USA

Re: EV helper spreadsheet

Post by hallkbrdz » Jun 27 2020 4:45pm

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/1qBYzZQ ... sp=sharing

User avatar
hallkbrdz   100 W

100 W
Posts: 141
Joined: Mar 24 2018 1:47pm
Location: Edmond, OK USA

Re: EV helper spreadsheet

Post by hallkbrdz » Jul 03 2020 11:52am

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-9xh ... sp=sharing

User avatar
hallkbrdz   100 W

100 W
Posts: 141
Joined: Mar 24 2018 1:47pm
Location: Edmond, OK USA

Re: EV helper spreadsheet

Post by hallkbrdz » Sep 10 2020 6:20pm

Version 20200909

Added / Changed:

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

https://drive.google.com/file/d/17zbJZl ... sp=sharing

User avatar
hallkbrdz   100 W

100 W
Posts: 141
Joined: Mar 24 2018 1:47pm
Location: Edmond, OK USA

Re: EV helper spreadsheet

Post by hallkbrdz » Sep 29 2020 7:24pm

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/17zbJZl ... sp=sharing

Post Reply