battery pack design calculator excel

[radad]

Updated version may 15

just a simple spreadsheet for battery pack design


has some current prices from fasttech
other info obtained from dampfakkus



https://www.dropbox.com/s/339ijuebhemd4sk/battery%20pack%20calc.xls

 

[radad]

updated 5/18
fixed Ah Wh mistake

 

[TheBeastie]

Looks good, should put it in googledocs in read only mode so I people can conveniently/safely read it.
Looks like Chrome/Dropbox tries to interpret the XLS with out needing MS Excel or OpenOffice etc but it comes up all messed up for me.
If in googledocs wouldn't be a problem.
I did one here looking at the viability of supercaps in an ebike for helping preserve long term battery cycles by minimizing high discharge of lithium pack etc.
https://docs.google.com/spreadsheets/d/1sLe0sqyq33GyAzIIoaE8JWZOhbOO28GxlnNDwWlad3w/edit#gid=0

Most people are dubious of loading an anonymous XLS file in MS Excel as they have been known to contain viruses/trojans that get deep inside peoples computers and rob them blind.

 

[Netlu52]

I really like this! Thanks for sharing.

The currency is USD? Sorry if I missed something, havent had time to look at it in detail. With or without vat? (I don't know what "ea" means.) Links to suppliers would be great if possible.

Edit: should have read your post properly. Prices from fasttech.