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


Forum Jump:


Users browsing this thread: 2 Guest(s)