[Franky.EV]

Back from Paris for 15 days and I've been working on the spreadsheet.

Now I take into account :
- max motor voltage
- max motor amp
- max battery pack voltage
- max battery pack amp
- C rating setting

UI has been modified to have every thing in logical blocks

That's still a simulation, based upon what I've understand about EV. But i'm not a specialist. Just doing that for the fun.

Use at your own risk

 

[gor]

hi, Franky
what the reason - it didn't show values?

does anyone have such problem?
thank you

 

[Franky.EV]

I'm using OOOCalc 3.2.0 at home and OOOCalc 3.2.1 at work.

I don't understand the problem, as you should'nt have any value in the cell "Power" for "v=0". I have deleted the formula in this cell, as you can see in the image in my post.

Try to download again, and check your Open Office version.

Regards.

 

[Franky.EV]

I've noticed I don't check validity of the "coeff of rolling resistance", and if you enter a text value for exemple, you have the problem, but it also mess up the corresponding calculated force "Fr".

I will post a newer version with all data entry checks verified.

 

[gor]

I'm using OOOCalc 3.2.0 at home and OOOCalc 3.2.1 at work.

I don't understand the problem, as you should'nt have any value in the cell "Power" for "v=0". I have deleted the formula in this cell, as you can see in the image in my post.

Try to download again, and check your Open Office version.

Regards.

hmm - same thing in other computer and with all earlier versions of calc
ooo 3.2.1; build 9502; oo update says - up to date
can be bug in macros, file path name,etc? what is your build?

 

[Franky.EV]

Hey Gor, I got it !!!

You have to enable macros in "Tools - Option - Security".

 

[gor]

Hey Gor, I got it !!!

You have to enable macros in "Tools - Option - Security".

yea - perfect, it works! thanks, Franky : )))))

menu: tools-options - macro security- mid or low

in mid. settings it would ask to enable macros, in low - run all
thanks again

 

[Franky.EV]

I think the simulation is correct when pack_amp >= Motor_Max_Amp.

If you set the C rating two low or choose a battery with low amperage then motor_power can be more than pack_power.

Something is wrong.

Still working on it.

 

[Franky.EV]

New version soon, with better handle of max pack power.

 

[Franky.EV]

As promised, new version taking care of battery pack max deliverable power.

I now see another problem . Uptime, Range and Mileage calculations, are based on minimal power demand. They don't match with the acceleration time which uses max power.

Looking for some graph to show that out.

Comments welcome.

 

[Franky.EV]

Some new works :
- Bug corrected : macros won't initialize when spreadsheet has been previously saved with activesheet <> "EV"
- Better handling of "low amp torque"
- added : sport mode : you floor the pedal to reach max speed and hope everything goes well (no ESP yet)

See new graphs in the first post.

 

[spdas]

Some new works :
- Bug corrected : macros won't initialize when spreadsheet has been previously saved with activesheet <> "EV"
- Better handling of "low amp torque"
- added : sport mode : you floor the pedal to reach max speed and hope everything goes well (no ABS yet)

See new graphs in the first post.

Aloha, I tried to D/L the openoffice Program to make use of the this neat Calculator. (from ooodocs.org) and managed to get a virus. Any recommended sites to get the OO program? thanks
Francis

 

[Amberwolf]

http://openoffice.org

The original and best site, should be safe. If there's a virus there, I'd be surprised.

 

[Bellistner]

What Amberwolf said. If you've got a Torrent program, use that instead of regular downloading, as it saves some of their bandwidth.

 

[golden boy]

Thanks very much for sharing.

Is there a way to changing the battery parameters?

It mentions the cells are protected.

 

[Franky.EV]

Sorry, Golden Boy, battery sheet was protected by error.

File corrected in posts #1 and #51.

 

[ZX-E]

Wow, this is an extensive spreadsheet! Hats off to you Franky .

 

[spdas]

I got a good virus-free version of OO, but the spreadsheet contents have a lot of ### and values for motors

Cannot change from AC55 in the ev sheet.

chart in EV is also filled with #value! in the uptime to 3rd gear column

What am I doing wrong?

thanks
Francis

 

[Franky.EV]

Thanks' a lot ZX-E

Spdas, you have to enable macros.

 

[spdas]

Thanks' a lot ZX-E

Spdas, you have to enable macros.

Ok thanks that works now. BTW is CALB not 3.2 v and not 3.4v as listed? thanks
Francis