Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel based RePackr
#11
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

 
Cell count as of 8/14/2019
106 Cells >2000mAh, >80% Rem. Cap., 14 day resting voltage >4.12V
104 Cells of Everything Else
0 In progress
 
Aiming for 8 cells tested a day
More info on my Google Drive
Reply
#12
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

 
Cell count as of 8/14/2019
106 Cells >2000mAh, >80% Rem. Cap., 14 day resting voltage >4.12V
104 Cells of Everything Else
0 In progress
 
Aiming for 8 cells tested a day
More info on my Google Drive
Reply
#13
Works for me just fine with all 3 columns  or just the mAh columb.

Looks like the ironing worked Smile

Wolf
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 8/7/2019
Total Number of Cells Recorded and processed                 6149
Total Cells required for PowIRwall                                   2856
Total Cells ≥2200mAh, ≥80%, ≥35mΩ, ≤75mΩ, ≥4.12V   2760
For Info Google Drive
Not your average Wolf       
            Cool
Reply
#14
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
Reply
#15
(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.

Thanks!

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

 
Cell count as of 8/14/2019
106 Cells >2000mAh, >80% Rem. Cap., 14 day resting voltage >4.12V
104 Cells of Everything Else
0 In progress
 
Aiming for 8 cells tested a day
More info on my Google Drive
Reply
#16
Does not run on MS Excel 2003. Macros still not running on OpenOffice, LibreOffice or GoogleSheets.

Runs like a charm on MS Excel 2016.

Many thanks to Nemo. Hurra!
Nemo likes this post
Reply


Who read this thread?
71 User(s) read this thread:
diib (08-24-2019, 08:10 AM), Lucan (08-12-2019, 07:55 PM), mskip (06-09-2019, 01:34 AM), ma3006he (06-11-2019, 01:36 PM), japarral (08-12-2019, 01:35 AM), Earlonics (08-10-2019, 02:59 PM), zoookii (06-07-2019, 07:25 PM), jferrerd (06-24-2019, 12:53 AM), mart1nn (06-09-2019, 09:06 PM), kevinjaye (08-21-2019, 12:37 AM), TimBelgium (06-09-2019, 06:39 PM), wilf06 (08-16-2019, 01:34 AM), RikH (06-08-2019, 09:57 AM), ajw22 (06-10-2019, 02:22 AM), Generic (06-11-2019, 01:17 PM), Scottietheyoung (06-08-2019, 01:56 AM), Havskum (06-12-2019, 02:06 PM), Omalik (08-15-2019, 06:30 AM), ironzap2 (07-19-2019, 07:39 PM), wiliamz (08-12-2019, 07:17 AM), berthfield (08-11-2019, 11:19 AM), drnickriviera (08-11-2019, 10:14 PM), 3xtr3m3 (08-17-2019, 07:12 PM), sanik46 (07-22-2019, 11:19 AM), metalorn (08-20-2019, 01:14 AM), Saiya (06-12-2019, 09:45 PM), Goblintacts (06-10-2019, 11:13 AM), vaporburner (06-22-2019, 02:34 AM), Nemo (08-15-2019, 03:37 AM), foamovercast (07-24-2019, 09:49 PM), adriandobre (08-18-2019, 01:03 PM), Owen96 (08-19-2019, 04:30 PM), 100kwh-hunter (06-15-2019, 08:38 PM), Rubert (06-08-2019, 01:55 PM), Lekr (06-26-2019, 07:49 PM), Bastler_Ro (06-27-2019, 05:29 AM), Wolf (08-11-2019, 01:07 PM), CarelHassink (06-11-2019, 08:10 PM), Oz18650 (06-10-2019, 02:06 AM), Herbi (08-11-2019, 08:46 AM), Geek (08-12-2019, 01:09 AM), Mazlem (06-08-2019, 05:12 PM), tremors (06-08-2019, 04:51 AM), Stefaan De Ridder (06-09-2019, 12:32 PM), watts-on (06-12-2019, 09:18 AM), wim (06-09-2019, 06:12 AM), jdeadman (06-12-2019, 04:11 AM), PAF (06-09-2019, 11:12 AM), A + A (06-08-2019, 07:24 PM), Korishan (08-11-2019, 11:47 AM), Majorphill (07-22-2019, 02:44 AM), mike (06-09-2019, 01:06 AM), bogptrsn (06-11-2019, 10:00 PM), modido (08-11-2019, 12:00 PM), djuro (08-11-2019, 08:44 PM), jaeger-audiodesign (06-11-2019, 08:15 AM), Beholder (08-11-2019, 09:55 PM), emuland-metroman (06-12-2019, 10:55 AM), chuckp (08-11-2019, 03:28 PM), HikingGuy42 (06-12-2019, 04:57 PM), mishok (08-14-2019, 05:26 PM), Riplash (08-11-2019, 06:01 PM), Bubba (08-12-2019, 11:55 PM), cadric (06-26-2019, 06:49 AM), Oliman (06-11-2019, 09:33 PM), Ibiza (08-11-2019, 03:50 PM), jonyjoe505 (06-08-2019, 05:22 PM), Crimp Daddy (08-20-2019, 07:27 PM), drchips (06-08-2019, 11:17 AM), jm1 (08-14-2019, 10:21 PM), hbpowerwall (06-10-2019, 10:17 PM)

Forum Jump:


Users browsing this thread: 1 Guest(s)