Battery Charger Wizard - Check it out

[Boston Bob]

I put this together on a lunch break at work, thought I would share it.

All you need to do is enter the pack capacity and cell count, as well as your charger's wattage and amperage (the calculations assume that for the values entered you have a power supply capable of delivering the input required for your charger to output these values)

After entering the info in the boxes, the three tables auto populate. You really only need to look at the one to the right to see what combinations of parallel packs and charge rate you are capable of running.

I'm pretty good with excel if you want any additional functions I may be able to add them. This is my thank you to everyone on this forum who contributes to helping us all in this hobby!

[Boston Bob]

Updated calculation from nominal voltage to full pack of 4.2 V per cell.

[redbird300]

Nice work Bob, but I'm afraid that a part of the spreadsheet is wrong.

That charger is limited to 1344W or 40A, whichever comes first.
In case of 6S packs, it will be the 40A limit that comes first.
Charging in parallel doesn't change a thing for that matter.
Meaning you can't exceed 1000W with it on 6S.
1344W is only possible with 8S packs: 8cellsX4,2Vx40A=1344W

You need to review the numbers > 1000W, and take the 40A limit in account.

No offense, this is the case with all chargers, you always need to consider all the restrictions.
Keep up the good work.

[Kozmyk]

Nice work Bob.

My questions are:
1) Does the charge time refer to packs that are 100% discharged pack/s or 80% discharged as per normal usage following the 80% rule?
2) Does it allow for balancing time

[Boston Bob]

Thanks for the feedback so far, perhaps I wasn't clear - the chart to the right is the final say on if the charger can handle the setup - it checks to see if you are over on amperage or wattage, the charts to the left are just showing the raw numbers that go into it, and if you get a no on the right, you can look to the two charts to the left to see why ie too high of amperage. All that said, is something still incorrect?

Kozmyk - yes, the time takes into account the 80% rule.

Originally Posted by redbird300

Nice work Bob, but I'm afraid that a part of the spreadsheet is wrong.

That charger is limited to 1344W or 40A, whichever comes first.
In case of 6S packs, it will be the 40A limit that comes first.
Charging in parallel doesn't change a thing for that matter.
Meaning you can't exceed 1000W with it on 6S.
1344W is only possible with 8S packs: 8cellsX4,2Vx40A=1344W

You need to review the numbers > 1000W, and take the 40A limit in account.

No offense, this is the case with all chargers, you always need to consider all the restrictions.
Keep up the good work.

[Boston Bob]

And no, the time to charge does not include balancing as this is dependent on things like the health/IR of the pack, and the balance lead power capability.

[Boston Bob]

Bump to share

Sent from my ADR6350 using Tapatalk