Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel based RePackr
#21
Photo 
(10-18-2019, 01:24 AM)Nemo Wrote:
(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?

here you go, interestingly each time i run it i get different results

list i generated to test with is below

2641
2205
2470
2573
2377
2525
2024
2212
2446
2032
2502
2665
2162
2274
2629
2379
2102
2499
2677
2609
2651
2490
2264
2536
2422
2317
2282
2589
2434
2633
2015
2650
2300
2182
2639
2341
2393
2247
2283
2445
2263
2198
2212
2635
2634
2534
2397
2693
2382
2228
2687
2496
2015
2003
2237
2342
2513
2221
2645
2012
2602
2241
2408
2504
2207
2147
2025
2389
2364
2280
2019
2657
2295
2667
2416
2688
2418
2341
2582
2477
2187
2004
2341
2358
2066
2345
2331
2161
2348
2370
2081
2196
2345
2384
2214
2188
Reply
#22
I've run your cell numbers and get repeatable results.  They are closer in deviation that what you show, but they do not approach 1, like the real repackr.  Here is what I get for 7s12p 

I can't account for the difference between my program and the real repackr.  Based on the method I use, I believe my version has smaller deviation between packs with larger numbers of cells.  So in this case of 96 cells the accuracy is lower, but for 1000 cells the difference between programs is negligible.  Admittedly I never did small sample testing because I was building a solution for large collections where the cells were uniquely identified.

Based on these results I would suggest that if people are using a smaller numbers of cells, use the original repackr.  If you're using large numbers of cells, particularly if they are uniquely identified, then my version will be suitable.

Thanks for the heads up and pointing out the weakness.  Perhaps I will be able to address it one day.
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?
97 User(s) read this thread:
ajw22 (06-10-2019, 02:22 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), foamovercast (10-17-2019, 11:08 PM), mskip (06-09-2019, 01:34 AM), ma3006he (10-19-2019, 01:02 PM), RikH (06-08-2019, 09:57 AM), 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), Iker138 (10-17-2019, 06: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), madmike (08-27-2019, 10:03 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), emuland-metroman (06-12-2019, 10:55 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), chuckp (08-11-2019, 03:28 PM), HikingGuy42 (06-12-2019, 04:57 PM), drchips (06-08-2019, 11:17 AM), 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), Generic (06-11-2019, 01:17 PM)

Forum Jump:


Users browsing this thread: 1 Guest(s)