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 10/10/2019
234 Cells >2000mAh, >80% Rem. Cap., 14 day resting voltage >4.12V
191 Cells of Everything Else
68 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 10/10/2019
234 Cells >2000mAh, >80% Rem. Cap., 14 day resting voltage >4.12V
191 Cells of Everything Else
68 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 10/10/2019
234 Cells >2000mAh, >80% Rem. Cap., 14 day resting voltage >4.12V
191 Cells of Everything Else
68 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
#17
Wow, could not have come across this at a better time! I've been numbering and cataloging all of my cells in Excel for the past year as I test them. I'm finally at the point where I'm ready to start building 14s packs. I was thinking how I could use repackr with only cell capacity to go by. I was trying to imagine how I would find a "2641 mAh" cell among 2000+ cells arranged by the cell number. I figured I'd have to either reorganize the entire collection by capacity or brush up on my Excel skills. Now I don't have to do either!

Thank you so much for extending the repackr functionality and sharing it with all of us. Very much appreciated!
Nemo likes this post
Reply
#18
I just compared the results you get from the xls to repackr using some random generated cells mha between 2000 and 2700, no IR info and used the same list in repackr and they are no the same output, the xls gives packs with a lot of difference in mha, where as the website doesent, xls different in pack is 1145mha, online 1mha so unsure whats happening, i kinda assumed you were posting to an api but im guessing you are trying to use excel to do all of it but not sure the job is good enough to be usable although really like the idea.
Reply
#19
(10-17-2019, 11:18 AM)boysie Wrote: I just compared the results you get from the xls to repackr using some random generated cells mha between 2000 and 2700, no IR info and used the same list in repackr and they are no the same output, the xls gives packs with a lot of difference in mha, where as the website doesent, xls different in pack is 1145mha, online 1mha so unsure whats happening, i kinda assumed you were posting to an api but im guessing you are trying to use excel to do all of it but not sure the job is good enough to be usable although really like the idea.

Weird. Working perfectly for me.

Reply
#20
(10-17-2019, 11:18 AM)boysie Wrote: I just compared the results you get from the xls to repackr using some random generated cells mha between 2000 and 2700, no IR info and used the same list in repackr and they are no the same output, the xls gives packs with a lot of difference in mha, where as the website doesent, xls different in pack is 1145mha, online 1mha so unsure whats happening, i kinda assumed you were posting to an api but im guessing you are trying to use excel to do all of it but not sure the job is good enough to be usable although really like the idea.

Yeah, I'm using excel to do the whole thing.  I don't know how the original repackr works, so I came up with my own method that appeared to give me balanced results within 1mAh when I ran it.  Not sure what's happening for you.  Can you post a screenshot of your xls results?
Mobilis in Mobili
 
Cell count as of 10/10/2019
234 Cells >2000mAh, >80% Rem. Cap., 14 day resting voltage >4.12V
191 Cells of Everything Else
68 In progress
 
Aiming for 8 cells tested a day
More info on my Google Drive
Reply


Who read this thread?
98 User(s) read this thread:
ajw22 (06-10-2019, 02:22 AM), mskip (06-09-2019, 01:34 AM), intra (10-17-2019, 12:44 AM), Lucan (08-12-2019, 07:55 PM), Havskum (06-12-2019, 02:06 PM), Omalik (08-15-2019, 06:30 AM), ironzap2 (09-13-2019, 03:36 PM), Rubert (06-08-2019, 01:55 PM), 100kwh-hunter (09-24-2019, 04:32 PM), Owen96 (08-19-2019, 04:30 PM), adriandobre (08-18-2019, 01:03 PM), ma3006he (10-19-2019, 01:02 PM), Iker138 (10-17-2019, 06:08 PM), RikH (06-08-2019, 09:57 AM), newone972 (Yesterday, 02:10 PM), wilf06 (08-16-2019, 01:34 AM), TimBelgium (06-09-2019, 06:39 PM), kevinjaye (08-21-2019, 12:37 AM), mart1nn (06-09-2019, 09:06 PM), jferrerd (06-24-2019, 12:53 AM), zoookii (06-07-2019, 07:25 PM), Earlonics (08-10-2019, 02:59 PM), japarral (08-12-2019, 01:35 AM), foamovercast (10-17-2019, 11:08 PM), Nemo (10-18-2019, 05:25 PM), vaporburner (06-22-2019, 02:34 AM), v1nc3nt (09-04-2019, 05:09 PM), Meesen0743 (09-11-2019, 01:14 PM), boysie (10-18-2019, 10:41 AM), krlenjuska (11-10-2019, 12:19 AM), GOTMLK (10-17-2019, 07:34 AM), xyoung347x (11-05-2019, 05:38 PM), barry (11-03-2019, 06:24 PM), MachiattoNZ (10-20-2019, 06:12 AM), bbu2005 (10-31-2019, 07:32 PM), jzriddler (11-02-2019, 03:44 PM), diib (08-24-2019, 08:10 AM), niels (09-12-2019, 03:06 PM), Goblintacts (06-10-2019, 11:13 AM), Saiya (06-12-2019, 09:45 PM), metalorn (08-20-2019, 01:14 AM), sanik46 (07-22-2019, 11:19 AM), 3xtr3m3 (11-05-2019, 09:14 AM), drnickriviera (08-11-2019, 10:14 PM), robovind (10-21-2019, 08:43 PM), berthfield (08-11-2019, 11:19 AM), Blackbusa59 (10-09-2019, 04:56 PM), wiliamz (08-12-2019, 07:17 AM), mairu (11-10-2019, 04:17 AM), hbpowerwall (06-10-2019, 10:17 PM), Geek (08-12-2019, 01:09 AM), Herbi (08-11-2019, 08:46 AM), stiplanet (10-19-2019, 08:26 PM), lucimct (11-04-2019, 09:24 PM), Tentious (11-06-2019, 05:48 AM), Oz18650 (10-18-2019, 05:33 AM), CarelHassink (06-11-2019, 08:10 PM), AndyMc1970 (09-17-2019, 12:45 AM), bogptrsn (10-18-2019, 12:42 PM), modido (08-11-2019, 12:00 PM), Mazlem (06-08-2019, 05:12 PM), tremors (06-08-2019, 04:51 AM), daromer (10-16-2019, 09:28 PM), mike (06-09-2019, 01:06 AM), Majorphill (07-22-2019, 02:44 AM), Korishan (10-17-2019, 07:00 PM), A + A (06-08-2019, 07:24 PM), PAF (10-18-2019, 08:21 AM), jdeadman (10-18-2019, 07:23 PM), wim (06-09-2019, 06:12 AM), watts-on (06-12-2019, 09:18 AM), Stefaan De Ridder (06-09-2019, 12:32 PM), djuro (08-11-2019, 08:44 PM), jm1 (08-14-2019, 10:21 PM), drchips (06-08-2019, 11:17 AM), Chass90 (09-20-2019, 06:08 PM), Beholder (10-21-2019, 04:05 AM), jaeger-audiodesign (06-11-2019, 08:15 AM), cowpen (10-24-2019, 04:37 PM), singlecell (08-28-2019, 12:44 AM), Wolf (10-19-2019, 11:59 AM), Bastler_Ro (10-18-2019, 06:46 PM), Lekr (06-26-2019, 07:49 PM), Scottietheyoung (06-08-2019, 01:56 AM), Generic (06-11-2019, 01:17 PM), emuland-metroman (06-12-2019, 10:55 AM), chuckp (08-11-2019, 03:28 PM), Crimp Daddy (08-20-2019, 07:27 PM), jonyjoe505 (10-18-2019, 02:17 AM), Ibiza (10-18-2019, 06:05 PM), Oliman (06-11-2019, 09:33 PM), whisperbot (10-20-2019, 10:06 AM), cadric (10-27-2019, 06:53 PM), Bubba (10-18-2019, 09:30 PM), Riplash (08-11-2019, 06:01 PM), mishok (08-14-2019, 05:26 PM), HikingGuy42 (06-12-2019, 04:57 PM), madmike (08-27-2019, 10:03 AM)

Forum Jump:


Users browsing this thread: 1 Guest(s)