Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[UPDATE][Tools]Battery Pack Calculator in Excel & Android - 11/24/2018
#11
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 likes this post
Reply
#12
(11-09-2017, 09:19 AM)jek10 Wrote: 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.




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.
ANY FOR IOS OR IMAC PLS OR MACBOOK THANKS
jek10 likes this post
Reply
#13
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.
Reply
#14
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.
Reply
#15
(10-07-2018, 06:31 AM)nilobualoy Wrote:
(11-09-2017, 09:19 AM)jek10 Wrote: 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.




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.
ANY FOR IOS OR IMAC PLS OR MACBOOK THANKS

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

(10-08-2018, 02:48 PM)Mazlem Wrote: 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.

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 Ah aka 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.
Reply
#16
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.
Reply


Who read this thread?
100 User(s) read this thread:
hbpowerwall (09-03-2018, 10:40 AM), Sean (10-09-2018, 09:26 AM), mike (10-19-2018, 02:59 PM), Majorphill (10-08-2018, 04:35 AM), ruby2 (11-10-2017, 03:52 AM), Korishan (10-18-2018, 12:24 PM), PAF (10-18-2018, 06:46 AM), Wattsup (11-25-2017, 12:03 PM), BobinTN (12-01-2017, 04:57 PM), Frnandu Martiński (11-09-2017, 12:00 PM), skyfridge (11-25-2017, 03:52 PM), Mike C (10-07-2018, 10:29 AM), jdeadman (11-24-2018, 02:01 PM), camils (11-25-2017, 10:38 AM), 2146 (11-10-2017, 04:33 PM), wim (10-08-2018, 02:51 PM), HandyAndy (03-08-2018, 03:04 AM), watts-on (11-24-2018, 10:28 AM), Dan Lim (10-07-2018, 11:28 AM), jesusangel (10-08-2018, 04:38 PM), Gimpy_AK (10-05-2018, 05:46 AM), Hanssing (11-10-2017, 05:05 AM), SeptimoJunio (12-27-2017, 08:35 AM), Stefaan De Ridder (11-24-2018, 04:40 PM), Igor Maliszewski (10-07-2018, 12:00 PM), BlueSwordM (11-26-2017, 08:49 PM), Piotr Dziel (11-25-2017, 08:23 AM), al4sound (04-16-2018, 01:44 AM), paraskevas (11-25-2017, 06:27 AM), Mazlem (11-26-2018, 05:21 PM), Geek (10-18-2018, 06:47 AM), Rad (11-09-2017, 10:50 PM), Longbush Powerwall (01-04-2018, 09:51 AM), SWEwall (11-18-2017, 09:35 PM), Jon (08-21-2018, 06:31 AM), jose215 (11-16-2017, 02:31 PM), jamesk9 (12-09-2017, 04:36 AM), floydR (11-24-2018, 10:24 PM), Menno (11-29-2018, 11:06 PM), AlexCPU (10-16-2018, 01:24 PM), DarkRaven (08-20-2018, 01:52 PM), Grumplestiltskin (11-14-2018, 11:57 PM), TimFr (12-10-2017, 07:50 AM), Lucian Macota (08-29-2018, 09:27 AM), emerca (11-09-2017, 10:12 AM), ChrisD5710 (11-24-2018, 03:31 PM), jesse.rizzo (12-01-2017, 07:24 PM), howiegrapek (11-27-2017, 09:37 PM), cristof (11-09-2017, 10:32 PM), Oderus420 (11-09-2017, 10:40 PM), accoelho (11-09-2017, 11:42 AM), neurocis (11-10-2017, 07:42 AM), Bryn (11-10-2017, 04:02 PM), Panda (10-20-2018, 11:18 AM), bres55 (12-07-2017, 08:08 PM), Mallusone (10-31-2018, 08:40 PM), josh35 (08-14-2018, 07:39 PM), nbolsen (11-09-2017, 05:24 PM), ad8mustanggt (11-26-2017, 10:33 PM), jek10 (12-08-2018, 10:49 AM), Pavel Razzorenov (11-30-2017, 04:54 PM), bogptrsn (11-11-2017, 07:39 PM), Ptjeff (11-09-2017, 10:31 AM), AmDD (11-09-2017, 05:36 PM), PowerLio (11-25-2017, 11:17 PM), vlmendezjr (11-10-2017, 08:25 PM), Filip (11-09-2017, 03:49 PM), cubo (01-04-2018, 02:53 PM), karmi27 (11-12-2017, 07:51 AM), modido (11-03-2018, 07:31 AM), Rudra Nath Ghosh (01-02-2018, 02:54 PM), GabiCj (11-09-2017, 10:04 AM), rjizzle (11-09-2017, 12:56 PM), Cody2o0 (11-10-2017, 07:00 AM), FLeFou (12-16-2017, 12:25 AM), dseidl (11-11-2017, 04:55 PM), m70ppn (11-12-2017, 09:10 AM), deptic (11-13-2017, 04:50 PM), qserv (11-23-2017, 02:28 AM), kristianyonuel (11-16-2017, 07:59 PM), Solexx X (10-24-2018, 09:03 PM), Ste Collister (10-13-2018, 01:54 PM), ahmadyushairy (11-21-2017, 08:34 PM), andre_rez (12-03-2017, 08:29 PM), yayaya (11-28-2017, 12:28 PM), redman333 (11-21-2017, 04:03 PM), Matt Kulik (11-22-2017, 12:32 AM), Charly144 (01-21-2018, 02:44 AM), Bean Si (11-25-2017, 03:17 AM), djuro (12-10-2018, 03:07 PM), autoguru21 (12-16-2017, 11:21 AM), paranco (11-27-2017, 01:15 PM), Kevin O'brien (11-27-2017, 12:04 PM), SecondHandPower (12-04-2017, 05:29 AM), jckenney (12-30-2017, 07:59 PM), Benjuca (12-06-2017, 10:43 PM), jm1 (09-23-2018, 03:54 AM), DH63 (12-16-2017, 10:21 AM), acidice333 (03-01-2018, 08:20 AM), Bpmarmstrong (12-30-2017, 12:09 AM)

Forum Jump:


Users browsing this thread: Tito, 1 Guest(s)