Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pack Builder (Repackr)
#11
(01-02-2019, 05:26 PM)benhamel Wrote: The paste in spreadsheet is nice but can this be saved in my account? Can I / you give packs name / code to easily associate bin to pack while sorting batteries.

Thanks for this tool

I have plans for the repackr. Plans that will address this along with adding several new features. It's still a few months away though.
LEDSchlucker, Korishan, hbpowerwall And 1 others like this post
Reply
#12
I record my cells into a spread sheet, from the time I open the original battery pack, recording the initial voltage, first charge voltage, test voltage after 3-4 week, capacity charge, last charge voltage,  each cell has it own ID so I can reference it back to my spreadsheet for information about that cell if need be,
what I would like is that when the cells are entered into repacakr,  that I can enter the ID and Capacity,
and it spits out the ID in the groupings, so I can then easily find the cell I need for each pack / bank.
can this be done ?  or have I missed somewhere it's already doing this,
thank you for your time,

Nigel
(01-03-2019, 02:41 AM)mike Wrote:
(01-02-2019, 05:26 PM)benhamel Wrote: The paste in spreadsheet is nice but can this be saved in my account? Can I / you give packs name / code to easily associate bin to pack while sorting batteries.

Thanks for this tool

I have plans for the repackr. Plans that will address this along with adding several new features. It's still a few months away though.
Reply
#13
Yes, but repackr isn't programmed that way. Take a look at Brett Watty's build: https://secondlifestorage.com/t-Arduino-...ery-Tester

He has a system that id's each cell with barcodes and pull the data from the cell database.
Proceed with caution. Knowledge is Power! Literally! Cool 
Knowledge is Power; Absolute Knowledge is Absolutely Shocking!
Certified 18650 Cell Reclamation Technician

Please come join in general chit-chat and randomness at Discord Chat (channels: general, 3d-printing, linux&coding, 18650, humor, ...)
(this chat is not directly affiliated with SecondLifeStorage; VALID email req'd)
Reply
#14
(06-27-2019, 11:07 AM)Korishan Wrote: Yes, but repackr isn't programmed that way. Take a look at Brett Watty's build: https://secondlifestorage.com/t-Arduino-...ery-Tester

He has a system that id's each cell with barcodes and pull the data from the cell database.

In the end I wrote some code to do what I needed ( using the repackr output )
i'll put it here in case anyone is interested, it's written in AutoIT,  it's rough,  but works for my needs,,

example of the data I used,


-- MyData --   ( has battery ID and Capacity )
B1,5385
B2,5293
B3,4500
B4,4756
B5,4499
B6,4736
B7,4148
B8,5299
B9,4216
B10,4242
B11,4203
B12,4080
B13,4112
B14,4432

-- Data entered into rePackr ---
5385
5293
4500
4756
4499
4736
4148
5299
4216
4242
4203
4080
4112
4432

--- output from rePackr --  put this into a spreadsheet and saved as a .csv file
4756    5293    4500    4432    4736    5299    5385
4216    4112    4499    4242    4203    4148    4080

--- Run it through my code, and the output ---
B4,B2,B3,B10,B6,B7,B1
B9,B13,B5,B14,B11,B8,B12

--- and the code I wrote  ---

Code:
#include <MsgBoxConstants.au3>
#include <Array.au3>
#include <File.au3>


$BatteryPreFix = InputBox("ID Prefix","If you use a letter Prefix in your battery numbering, enter it here","B")

$sMessage = "Select your .csv file"
$BaseFile = _OpenMyFile($sMessage)
Dim $BaseFileArray

$sMessage = "Select your rePackr .csv file"
$RePackrFile = _OpenMyFile($sMessage)
Dim $rePackerArray

_FileReadToArray ($RePackrFile,$rePackerArray,0,",")
_FileReadToArray ($BaseFile,$BaseFileArray,0,",")

$Series = ubound($rePackerArray,2)
$Parallel = ubound($rePackerArray,1)
$PackSize = $Series * $Parallel
$BaseSize = ubound($BaseFileArray)
if $BaseSize < $PackSize Then
    MsgBox(0,"","rePackr and Base '.csv' files are not the same size" & @crlf & "rePackr file is " & $PackSize  & ", baseArray is " & $BaseSize)
    Exit
EndIf

ConsoleWrite("$Series " & $Series & ",   $Parallel " & $Parallel & @CRLF)
TrayTip("Building Pack Data","S" & $Series & ",   P" & $Parallel, 10)
_ArraySort($BaseFileArray,1,default ,default ,1)

For $loopSerial = 0 to $Series -1
    for $loopParallel = 0 to $Parallel-1
        For $loopBase = 0 to $BaseSize -1
            if $rePackerArray[$loopParallel][$loopSerial] = $BaseFileArray [$loopBase][1] then
                $rePackerArray[$loopParallel][$loopSerial] =  Number(StringReplace($BaseFileArray [$loopBase][0],$BatteryPreFix,""))
                $BaseFileArray [$loopBase][1] = ""
                ExitLoop
            EndIf
        Next
    Next
Next


For $loopSerial = 0 to $Series -1
    Dim $tempHoldArray [$Parallel]
    for $loopParallel = 0 to $Parallel-1
        $tempHoldArray[$loopParallel] = Number($rePackerArray [$loopParallel][$loopSerial])
    Next
    _ArraySort($tempHoldArray)
    for $loopParallel = 0 to $Parallel-1
        $rePackerArray [$loopParallel][$loopSerial] = $BatteryPreFix & $tempHoldArray[$loopParallel]
    Next
;    _ArrayDisplay($rePackerArray)
Next

_ArrayDisplay($rePackerArray)
$sFilePath = "MyPackFile.csv"
_FileWriteFromArray($sFilePath, $rePackerArray, 0, Default , ",")
MsgBox(0,"","Exported Data to file:" & @crlf & @ScriptDir & "\" & $sFilePath)
ShellExecute(@ScriptDir)

Exit


Func _OpenMyFile($sMessage)
    Local $sFileOpenDialog = FileOpenDialog($sMessage, @ScriptDir & "\", "csv (*.csv)", BitOR($FD_FILEMUSTEXIST, $FD_MULTISELECT))
    If @error Then
        MsgBox($MB_SYSTEMMODAL, "", "No file(s) were selected.")
        Exit
    Else
        $sFileOpenDialog = StringReplace($sFileOpenDialog, "|", @CRLF)
        return $sFileOpenDialog
    EndIf
EndFunc
Reply
#15
(06-27-2019, 02:07 AM)noddle Wrote: I record my cells into a spread sheet, from the time I open the original battery pack, recording the initial voltage, first charge voltage, test voltage after 3-4 week, capacity charge, last charge voltage,  each cell has it own ID so I can reference it back to my spreadsheet for information about that cell if need be,
what I would like is that when the cells are entered into repacakr,  that I can enter the ID and Capacity,
and it spits out the ID in the groupings, so I can then easily find the cell I need for each pack / bank.
can this be done ?  or have I missed somewhere it's already doing this,
thank you for your time,

Nigel
I built an excel based repackr that does this.  
Here's the thread: https://secondlifestorage.com/t-Excel-based-RePackr
Find the file on My google Drive: https://drive.google.com/drive/folders/1...49m5V34Ug6
Mobilis in Mobili
Reply


Who read this thread?
100 User(s) read this thread:
hbpowerwall, Minx, daromer, Sean, mike, 18650Shrink, goodnowm, Lux_Gamer, owitte, RudyLiPower, Majorphill, ruby2, Korishan, A + A, PAF, FERCSA, Tamz Rod, Scepterr, Tristan Timmer, egam, Alec_J, Droid126, HogensHero, jdeadman, Rechargedwalls, monsted, 2146, wim, wimpie007, coconut2k13, frnandu, piscore, typ49, HandyAndy, Jeremy Choy, 1958 greyhound, Abarth595, gaz, watts-on, Dan Lim, jesusangel, Daggerzz, Dietmar Rheeder-Kleist, silverse2m6, Larry Tipton, Stefaan De Ridder, Quebec_PW, rbrett, Chiptosser, Power Up, BlueSwordM, Dennis Van Hoek, alildabldo, Al's Shed, Erik Smith, Terry, N00bPwr, esterne, John Bender, miu, Shade, Robert Crawley, stuartornum, Daveyboy, al4sound, Paparaxxl, Shane McArdle, iofosho, Chris Davis, Geek, jrandomb, Ivo Staelens, Bloater, jamesk9, p0lar, floydR, Menno, Wado, SimonW, Jimlun, David West, brol, Matthew Nagy, mdmpec, karibe, DarkRaven, Grumplestiltskin, osweld, DCkiwi, zag2me, NicZa, priba83, Bert, technojunkie, Perfa76, Matthew Oliver, tocan, teslar, highvoltagedriver, Chris Crum

Forum Jump:


Users browsing this thread: 1 Guest(s)