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.
Korishan, Dietmar Rheeder-Kleist, 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
 
Cell count as of 9/16/2019
128 Cells >2000mAh, >80% Rem. Cap., 14 day resting voltage >4.12V
146 Cells of Everything Else
83 In progress
 
Aiming for 8 cells tested a day
More info on my Google Drive
Reply


Who read this thread?
100 User(s) read this thread:
hbpowerwall (07-02-2019, 02:53 AM), Minx (05-29-2018, 12:31 PM), daromer (08-17-2019, 05:19 PM), Sean (08-17-2019, 06:06 PM), mike (09-02-2019, 01:18 AM), 18650Shrink (06-22-2017, 08:14 PM), goodnowm (07-31-2018, 09:36 PM), Lux_Gamer (06-21-2017, 11:28 AM), owitte (05-29-2018, 11:43 AM), RudyLiPower (07-03-2017, 01:37 PM), Majorphill (01-03-2019, 10:59 PM), ruby2 (10-27-2017, 02:48 AM), Korishan (08-24-2019, 04:44 PM), A + A (05-29-2018, 12:52 PM), PAF (06-28-2019, 09:23 AM), FERCSA (06-25-2017, 11:31 AM), Tamz Rod (06-25-2017, 08:23 AM), Scepterr (06-21-2017, 05:29 AM), Tristan Timmer (06-21-2017, 06:08 AM), egam (06-20-2017, 01:18 PM), Alec_J (06-21-2017, 07:03 PM), Droid126 (06-22-2017, 05:14 PM), HogensHero (06-21-2017, 10:46 PM), jdeadman (08-18-2019, 06:05 PM), Rechargedwalls (06-22-2017, 01:04 AM), monsted (07-08-2017, 09:41 AM), 2146 (06-20-2017, 03:14 PM), wim (08-17-2019, 05:48 PM), wimpie007 (01-18-2019, 11:32 AM), coconut2k13 (06-22-2017, 05:16 AM), frnandu (06-20-2017, 01:28 PM), piscore (06-22-2017, 08:49 PM), typ49 (06-21-2017, 07:11 PM), HandyAndy (06-21-2017, 07:13 PM), Jeremy Choy (06-21-2017, 03:40 AM), 1958 greyhound (01-08-2019, 11:01 AM), Abarth595 (08-20-2017, 01:05 PM), gaz (06-23-2017, 10:44 AM), watts-on (08-18-2019, 09:27 AM), Jack Daniels (08-31-2019, 05:48 PM), Dan Lim (08-04-2017, 01:54 AM), jesusangel (07-21-2019, 05:59 PM), Daggerzz (06-20-2017, 07:53 PM), Dietmar Rheeder-Kleist (01-10-2019, 08:23 PM), silverse2m6 (07-16-2017, 03:47 AM), Larry Tipton (08-06-2017, 09:18 PM), Stefaan De Ridder (07-19-2017, 02:18 PM), Quebec_PW (06-28-2017, 12:55 AM), rbrett (06-28-2017, 12:40 PM), Chiptosser (01-04-2019, 04:05 PM), Power Up (07-08-2017, 11:01 AM), BlueSwordM (02-16-2018, 03:44 PM), Dennis Van Hoek (07-09-2017, 09:53 PM), alildabldo (07-10-2017, 12:10 PM), Al's Shed (07-16-2017, 07:07 PM), Erik Smith (09-07-2017, 04:48 PM), Terry (07-18-2017, 12:54 PM), N00bPwr (07-26-2017, 01:52 PM), esterne (08-14-2017, 02:15 PM), John Bender (08-29-2017, 01:30 AM), miu (08-27-2017, 07:40 PM), Shade (01-14-2018, 03:25 PM), Robert Crawley (07-30-2017, 10:06 PM), stuartornum (08-02-2017, 01:44 PM), Daveyboy (03-26-2018, 10:02 AM), al4sound (08-07-2017, 02:25 AM), Paparaxxl (09-21-2017, 01:54 AM), Shane McArdle (08-11-2017, 12:47 AM), iofosho (10-21-2017, 04:24 AM), Chris Davis (08-11-2017, 11:15 PM), Geek (08-18-2019, 10:46 PM), mike98 (09-07-2019, 04:07 PM), jrandomb (08-20-2017, 09:34 PM), Ivo Staelens (08-10-2019, 09:48 AM), Bloater (10-14-2018, 09:49 PM), jamesk9 (08-24-2017, 05:25 PM), p0lar (08-23-2017, 06:10 PM), floydR (01-03-2019, 11:45 PM), Menno (09-03-2017, 09:33 AM), Wado (08-28-2017, 09:21 AM), SimonW (09-05-2017, 03:30 PM), Jimlun (11-13-2017, 04:44 PM), David West (08-27-2017, 08:57 PM), brol (11-01-2017, 06:10 AM), Matthew Nagy (08-29-2017, 11:59 PM), mdmpec (09-01-2017, 10:37 AM), karibe (10-24-2017, 04:39 PM), DarkRaven (01-06-2019, 11:52 AM), stiplanet (Today, 12:40 AM), Grumplestiltskin (09-05-2017, 11:45 PM), osweld (09-12-2017, 10:38 AM), DCkiwi (01-23-2019, 09:24 PM), zag2me (09-14-2017, 11:42 AM), NicZa (09-12-2017, 02:47 PM), priba83 (09-13-2017, 01:48 PM), Bert (09-26-2017, 09:14 PM), technojunkie (09-14-2017, 10:15 PM), Perfa76 (09-18-2017, 09:54 PM), Matthew Oliver (09-21-2017, 01:33 PM), tocan (09-24-2017, 12:39 PM)

Forum Jump:


Users browsing this thread: 1 Guest(s)