[UPDATE][Tools]Battery Pack Calculator in Excel & Android - 11/24/2018

jek10

jek10

New member
Joined
Oct 22, 2017
Messages
18
Hi,

I've created a simple battery pack calculator on Excel. It calculates the capacity, how many series and parallel just input how many cells you have, voltage and amp.

Thank you.

--------------------------------------------------------------------------------------------------------
UPDATE!
*Fix unit of measurements.
*Added Custom voltage and number of parallel pack.

--------------------------------------------------------------------------------------------------------
11/25/2017
*Now available on Android.
[size=large]*Just extract the zip file and install.[/size]

--------------------------------------------------------------------------------------------------------
11/24/2018


image_fahqld.jpg


*Redesign Interface.
*Just extract the zip file and install.

-More feature soon(History, Different Battery Specs, Tips, Etc).
-Feel free to request additional feature, let's make this app a all-in-one DIY Battery Pack Calculator.
 

Attachments

  • Battery Pack Calculator - Updated - 11-9-17.xlsx
    21.2 KB · Views: 2,418
  • com.jek10.batterypack-BatteryPack Calculator-1-1.0.zip
    1.3 MB · Views: 1,016
  • (New)(11-24-2018)Battery Pack Calculator.zip
    631.4 KB · Views: 1,115
Well done! Accuracy is spot on. The only thing I added was a 20 percent loss as I won't be fully charging or discharging.
 
Geek said:
Well done! Accuracy is spot on. The only thing I added was a 20 percent loss as I won't be fully charging or discharging.
Click to expand...

Thanks! What will I do? Just add 20% less in the capacity?
 
jek10 said:
Geek said:
Well done! Accuracy is spot on. The only thing I added was a 20 percent loss as I won't be fully charging or discharging.
Click to expand...

Thanks! What will I do? Just add 20% less in the capacity?
Click to expand...

Doesn't apply to most. You have create an excellent tool for beginners. The only thing I can suggest is top and bottom voltage
 
Geek said:
jek10 said:
Geek said:
Well done! Accuracy is spot on. The only thing I added was a 20 percent loss as I won't be fully charging or discharging.
Click to expand...

Thanks! What will I do? Just add 20% less in the capacity?
Click to expand...

Doesn't apply to most. You have create an excellent tool for beginners. The only thing I can suggest is top and bottom voltage
Click to expand...


I don't quite understand, can you give me a formula or computations for that?
 
Some corrections:
A8 should be Amphour, or Ah/mAh, not Amp
B14/15/16 is a bit mixed up, B14 is the capacity of the battery, B15 is the energy of a single parallel pack and B16 is the energy of the entire battery in Wh, not the capacity.
C16 is kWh, not kW (and definitely not Kw ;))
Same with B21

If you want to take 20% loss into account then reduce the figures by 20%.
Example:
7s40p, 2Ah cells, 80Ah total capacity and 2072Wh total energy, 64Ah usable capacity and 1657.6Wh usable energy

I think what Geek means is that this doesn't apply for most beginners as it is more of an advanced thing to run the cell in a certain voltage range instead of their full voltage range.
 
DarkRaven said:
Some corrections:
A8 should be Amphour, or Ah/mAh, not Amp
B14/15/16 is a bit mixed up, B14 is the capacity of the battery, B15 is the energy of a single parallel pack and B16 is the energy of the entire battery in Wh, not the capacity.
C16 is kWh, not kW (and definitely not Kw ;))
Same with B21

If you want to take 20% loss into account then reduce the figures by 20%.
Example:
7s40p, 2Ah cells, 80Ah total capacity and 2072Wh total energy, 64Ah usable capacity and 1657.6Wh usable energy

I think what Geek means is that this doesn't apply for most beginners as it is more of an advanced thing to run the cell in a certain voltage range instead of their full voltage range.
Click to expand...

Okay. I understand. I'll fix the unit and some formula. Sorry for the wrong unit.

I know it's kinda advance but it's better to add more feature and computations into it since the beginners will soon to ask those advance stuff, that's why I'm asking if theres something more I can add, you can all tell me and I'll put it together.
 
DarkRaven said:
Some corrections:
A8 should be Amphour, or Ah/mAh, not Amp
B14/15/16 is a bit mixed up, B14 is the capacity of the battery, B15 is the energy of a single parallel pack and B16 is the energy of the entire battery in Wh, not the capacity.
C16 is kWh, not kW (and definitely not Kw ;))
Same with B21

If you want to take 20% loss into account then reduce the figures by 20%.
Example:
7s40p, 2Ah cells, 80Ah total capacity and 2072Wh total energy, 64Ah usable capacity and 1657.6Wh usable energy

I think what Geek means is that this doesn't apply for most beginners as it is more of an advanced thing to run the cell in a certain voltage range instead of their full voltage range.
Click to expand...

Well spotted. I just had a quick glance over. Excellent idea for the FAQ - To the FAQ Mr Raven :D
 
Geek said:
DarkRaven said:
Some corrections:
A8 should be Amphour, or Ah/mAh, not Amp
B14/15/16 is a bit mixed up, B14 is the capacity of the battery, B15 is the energy of a single parallel pack and B16 is the energy of the entire battery in Wh, not the capacity.
C16 is kWh, not kW (and definitely not Kw ;))
Same with B21

If you want to take 20% loss into account then reduce the figures by 20%.
Example:
7s40p, 2Ah cells, 80Ah total capacity and 2072Wh total energy, 64Ah usable capacity and 1657.6Wh usable energy

I think what Geek means is that this doesn't apply for most beginners as it is more of an advanced thing to run the cell in a certain voltage range instead of their full voltage range.
Click to expand...

Well spotted. I just had a quick glance over. Excellent idea for the FAQ - To the FAQ Mr Raven :D
Click to expand...

I updated the file now.:)
 
11/25/2017 - Update
*Now available on the Android phone.
*Just extract the zip file and install.
 
Thanks for the File, Building my first major pack, 48v we'll see what i come up with after using the calc, thanks again
 
jek10 said:
Hi,

I've created a simple battery pack calculator on Excel. It calculates the capacity, how many series and parallel just input how many cells you have, voltage and amp.

Correct me if my calculations are off and also I have notes inside the excel file. You can all contribute to make this simple but useful tool for us specially beginners.

If you want to add something on it or tell me I'm wrong with this just send me your PM so I can correct or add it.

Thank you.


image_hewfvf.jpg


image_bvfjgh.jpg


UPDATE!

*Fix unit of measurements.
*Added Custom voltage and number of parallel pack.

11/25/2017
*Now available on the Android phone.
*Just extract the zip file and install.
Click to expand...
ANY FOR IOS OR IMAC PLS OR MACBOOK THANKS
 
thank for your swift reply do you have a excel or spreadsheet for 18650 with different capacity in building a battery pack?

any from the side have excel or spreadsheet regarding building pack of 18650 with different capacity, thanks for the reply.
 
B12 should be the average of B9 and B10, yea? =((SUM(B9:B10))/2)/1000

Also you might set the cells with Capacity / Ah / Wh figures to only go to two decimal places.
 
nilobualoy said:
jek10 said:
Hi,

I've created a simple battery pack calculator on Excel. It calculates the capacity, how many series and parallel just input how many cells you have, voltage and amp.

Correct me if my calculations are off and also I have notes inside the excel file. You can all contribute to make this simple but useful tool for us specially beginners.

If you want to add something on it or tell me I'm wrong with this just send me your PM so I can correct or add it.

Thank you.


image_hewfvf.jpg


image_bvfjgh.jpg


UPDATE!

*Fix unit of measurements.
*Added Custom voltage and number of parallel pack.

11/25/2017
*Now available on the Android phone.
*Just extract the zip file and install.
Click to expand...
ANY FOR IOS OR IMAC PLS OR MACBOOK THANKS
Click to expand...

You can use the excel file instead. I don't have ios developer tools, it's not free develop ios app.

Mazlem said:
B12 should be the average of B9 and B10, yea? =((SUM(B9:B10))/2)/1000

Also you might set the cells with Capacity / Ah / Wh figures to only go to two decimal places.
Click to expand...

B12 is not the average of B9 & B10. B12 is up to you what capacity of the each cell you have, I just choose "2 is Ahaka 2000mah" being conservative.

Unfortunately I loose the project file for the app that is why I can't adjust the decimal places on the app. In the excel file though you can, just adjust the "truncate" on the formula.
 
UPDATE - 11/24/2018


  • Redesign Interface.
  • Just extract the zip file and install.
------------------------------------------------------------------------------------
  • More feature soon(History, Different Battery Specs, Tips, Etc).
  • Feel free to request additional feature, let's make this app a all-in-one DIY Battery Pack Calculator.
 
You must log in or register to reply here.
Back
Top