Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel based RePackr
#1
Hi All,

I've noticed a few people talking about the difficulty using Repackr with large amounts of cells, so I put together an excel based version that you can download at my google drive here: 

https://drive.google.com/drive/folders/1...sp=sharing

This was a scratch-build so it may not handle available cells the same way as the real Repackr (because I don't know how it works), but it will balance very closely.  I have also added the ability to set a target mAh for each pack for those of you looking to expand your walls, but wanting to match your existing packs.  Lastly, if you put in your cell IR information it will calculate the pack IR and give you the total IR of the build.

Thanks to Wolf for sharing your Database and reviewing functionality as the build progressed!
Wolf and cadric like this post
Mobilis in Mobili
Reply
#2
That Nemo is a work of art.
Big Grin Big Grin Big Grin

Wolf
Nemo likes this post
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       
            Cool



Reply
#3
Does not work in OpenOffice, LibreOffice or GoogleSheets. Wont run macros.
Reply
#4
(06-08-2019, 05:56 PM)Herbi Wrote: Does not work in OpenOffice, LibreOffice or GoogleSheets. Wont run macros.

No it does not hence it is called an Excel based RePackr.

Mabe there are some OO, LO, or GS gurus out there that can modify those versions to work.


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 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       
            Cool



Reply
#5
(06-08-2019, 05:56 PM)Herbi Wrote: Does not work in OpenOffice, LibreOffice or GoogleSheets. Wont run macros.

Yeah, unfortunately it does require running Microsoft Office.  As Wolf said if there's anyone out there that can transfer it to other platforms have at it.  There's always the genuine RePackr too.
Mobilis in Mobili
Reply
#6
Well, it is not running on MS Office 2016 or MS 365 either. If anything I get run time error "6".
Reply
#7
That is interesting. Just double checked by downloading the copy I posted and found a couple of bugs that might have causing the problem. Should be fixed now. Thank you for the feedback, doesn't help anyone if it doesn't work.

Can someone please confirm the new file works for them?
Mobilis in Mobili
Reply
#8
(06-10-2019, 02:02 AM)Nemo Wrote: That is interesting.  Just double checked by downloading the copy I posted and found a couple of bugs that might have causing the problem.  Should be fixed now.  Thank you for the feedback, doesn't help anyone if it doesn't work.

Can someone please confirm the new file works for them?

Re-downloaded and found that there is still a problem.
Reply
#9
(06-10-2019, 08:41 PM)Bubba Wrote:
(06-10-2019, 02:02 AM)Nemo Wrote: That is interesting.  Just double checked by downloading the copy I posted and found a couple of bugs that might have causing the problem.  Should be fixed now.  Thank you for the feedback, doesn't help anyone if it doesn't work.

Can someone please confirm the new file works for them?

Re-downloaded and found that there is still a problem.

Error Description would help.  Ran some more checks and found another bug, but don't know if its the one you got.  Clearly I need to beef up my error checking.  I did all my initial checks with IR included and never really tested without IR data in place.  Lesson Learned.

File's been updated again, any other alpha testers out there willing to download and tell me if its working or not?
Mobilis in Mobili
Reply
#10
Nemo,

I works great for me with or without the IR Info plugged in.
If I take out the Cell Number I then get "Run-time error 6"
But then again the Sheet was designed to have cell numbers correlated with mAh tested results.

Works great for me.


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 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       
            Cool



Reply


Who read this thread?
45 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, Dallski, ajw22, RikH, TimBelgium, kevinjaye, mart1nn, zoookii, ma3006he, mskip, Havskum, Rubert, 100kwh-hunter, Nemo, vaporburner, Goblintacts, Saiya

Forum Jump:


Users browsing this thread: 1 Guest(s)