[yarross]

I'm publishing a spreadsheet that was prepared for my planned conversion.

This spreadsheet was originally downloaded from Cameron Software site:
http://www.cameronsoftware.com/ev/data/EVDrivePower.xls
It has been stripped from all stuff related to choosing motor and controller.

This version is focused on battery nad range performance.

It employs a simplified but useful model od vehicle dynamics and energy consumption, battery model with Peukert effect and voltage sag addressed and finally range and DoD calculations.
The Batteries sheet contains calulated battery Peukert exponent and Peukert capacity estimations from linearized discharge curve points. Some popular batteries specs are calculated, but I often could not get data for high current points that are best for EV battery performance estimations.

Fields with orange background are input parameters. Play with them to see the effect.

Feel free to use and improve this spreadsheet. Also feel free to correct my English (I'm not a native speaker).

http://www.yarross.net.pl/users/jaros/EV/EVDrivePower.xls
http://www.yarross.net.pl/users/jaros/EV/EVDrivePower.ods

 

[GTWCMT]

In your spreadsheet you have put a total power required. what is this total for as in relation to? I don’t see a distance (miles/KM)

thanks

I see that this is very general, I took a look at the RPM and the total power, obviously there are many factors, but in general if a motor is running at higher RPM its generally more efficient, but the chart did not change to reflect this possibility

 

[yarross]

In your spreadsheet you have put a total power required. what is this total for as in relation to? I don’t see a distance (miles/KM)

Total power is a value of power required for traction (to keep constant speed) plus extra loads like lights, wipers etc, minus onboard APU power (range extender). This is power, not mileage.
Mileage is under "energy consumption" in Wh/km.

I see that this is very general, I took a look at the RPM and the total power, obviously there are many factors, but in general if a motor is running at higher RPM its generally more efficient, but the chart did not change to reflect this possibility

I focused myself on battery performance. RPM and torque numbers are at wheels. If you need to calculate powertrain parameters just add gearbox reduction and efficiency and you will obtain motor rpm and power requirements. Then you can use efficiency curves of motor.
If more powertrain analysis is needed, download original version. The author made some calcs for Siemens and Solectria motors and few inverters.