Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel based RePackr
Ha! there's another example of me just not fully imagining how the sheet could be used.  I think I can tweak it so that it doesn't depend on cell numbers, but realistically I think if people are going to try balancing this number of cells, this tightly, the cells need to be numbered and kept in an order so that each individual cell can be easily found later.  Otherwise the time spent hunting and picking a particular mAh cell will be painful.

For those reading, there's a file on my google drive called "Order Box".  This is my mock-up at a relatively cheap way to keep numbered cells in an order.  I use cell holders to make a 10x10 grid box so each column corresponds to a multiple of one, and each row to a multiple of ten, and the whole box is for a particular run of 100 cells.  Its more work on the front end, but should save lots when it comes to balancing the pack because you can quickly find the exact cell number.  Dividers could be made from cardboard to be cheaper, but takes more time.  Cell ordering boxes could probably also be purchased, never really looked.

I also should point out that I don't believe balancing a pack this tightly is a requirement for a build.  Lots of existing powerwalls are functioning just fine balanced by dividing cells into bins covering a 100mAh range and putting equal number of cells from each bin.  This tool is for those that want to go the extra distance and tightly balance, but couldn't.
Mobilis in Mobili
Alright, file has been updated with yet another wrinkle ironed out. Tested it with and without cell numbers, with and without IR values, for both No Target and Target scenarios. Should work? Someone give it a try and let me know.
Mobilis in Mobili
Works for me just fine with all 3 columns  or just the mAh columb.

Looks like the ironing worked Smile

If 18 X 650 = 2200+mAh then we have power! 
May all your Cells have an IR of 75mΩ or less Smile
Last count as of 6/10/2019
Total Number of Cells                          5940
Cells  >80% of Capacity                      4334
Cells <80% of Capacity                       1605
Cells ≥2200mAh & ≥ 80% & ≤75mΩ    2800 +236
For Info Google Drive
Not your average Wolf       

Initially work with just Capacity. Then tried it again with capacity and cell Number. Worked ok.
when I added in the IR it crashed Error 11.
I re-ran without IR. and it ran ok.
replaced IR and it ran ok. So not sure why it failed the first time.

Thanks for the hard work.
Nemo likes this post
(06-11-2019, 09:32 PM)Bubba Wrote: Initially work with just Capacity.  Then tried it again with capacity and cell Number.  Worked ok.
when I added in the IR it crashed Error 11.
I re-ran without IR.  and it ran ok.
replaced IR and it ran ok.  So not sure why it failed the first time.

Thanks for the hard work.


Hope it helps.  If you run into any constant bugs please let me know and I'll update as needed.  I'm also open to feedback on additional functionality (now that I seem to have the basics functioning...)
Mobilis in Mobili

Who read this thread?
46 User(s) read this thread:
hbpowerwall, mike, Korishan, A + A, PAF, jdeadman, wim, watts-on, Stefaan De Ridder, tremors, Mazlem, Geek, Herbi, Oz18650, CarelHassink, bogptrsn, drchips, jonyjoe505, Oliman, cadric, Bubba, Riplash, HikingGuy42, emuland-metroman, Beholder, jaeger-audiodesign, Wolf, Bastler_Ro, Scottietheyoung, Generic, ajw22, RikH, TimBelgium, kevinjaye, mart1nn, jferrerd, zoookii, ma3006he, mskip, Havskum, Rubert, 100kwh-hunter, Nemo, vaporburner, Goblintacts, Saiya

Forum Jump:

Users browsing this thread: 1 Guest(s)