Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
spreadsheet for cell info?
#1
hello
im just beginning collecting cells have a couple of hundred now just starting to test them does anybody have a good spreadsheet to jot down each cells data
thanks
Battery is li iron using 18650s, 14s, 0p, and growing cell so far 1000ish, untesteded.
Bms chinese bluetooth
No solar yet, very soon, looking to buy panels if anyone has any?
Reply
#2
I write capacity on the cell in 100mah Range or just put them into such bin Smile
The Ultimate DIY Solar and build place
YouTube / Forum system setup / My webpage  Diy Tech & Repairs

Current: 10kW Mpp Hybrid | 4kW PIP4048 | 2x PCM60x | 100kWh LiFePo4 | 20kWh 14s 18650 |  66*260W Poly | ABB S3 and S5 Trip breakers
Upcoming: 14S 18650~30kWh
Reply
#3
Try these:
https://drive.google.com/open?id=1OxLFxp...5Mt3cNsFXx

https://drive.google.com/open?id=1W8CQa6...YUU1V-6Nsj

Those will be a good start.

Wolf
For Info Google Drive

Great ABB shunt breaker seller River City Industrial
Great prices and superb service.
 [Image: em2566%20(1)__19172.1521541365.jpg?c=2]

Not your average Wolf       
            Cool
Reply
#4
I write the capacity on the cell then recharge it. Once it sits for Over a Month or 2 I check the voltage and then just open a blank excel worksheet and start entering the cells into a list that are over 4.1V. Then organize it into bins of 50mAh separation.

I do write the Exact cell capacity into excel but now that I have gone through more than 4000 cells looking for the exact one that repackr shows I have now started to just count the number of the specific bin I need and dont worry about the exact number Make for much faster building
******Hi My name is Jason and I have SOCD (Solar Obsessive Compulsive Disorder)*******
Current Powerwall - 1400 Cells 7s200p (modular 40p packs) ~ 12kWh of storage     4x 315W Canadian Solar Panels

Working on the next 7s40p packs     ~2.5kWh

Waiting on 2000 Cells of unused Sony vt4 (2000mah 30A) ~ 15kWh      hehehehehe  More Power
Reply
#5
thanks i plan to take random checks over a period, and see how much they degenerate
Battery is li iron using 18650s, 14s, 0p, and growing cell so far 1000ish, untesteded.
Bms chinese bluetooth
No solar yet, very soon, looking to buy panels if anyone has any?
Reply
#6
I use a sharpie to write down the mah onto the cell, then into a box fully charged for a month or two - then retest & sort into 100mah groups for larger packs or use repacker for smaller battery builds.
Second Life Storage Cell Finder
Get up to 10% off with coupon code 'Powerwalls'
Lithium Power Australia http://bit.ly/lithium_power
Battery Hookup USA http://bit.ly/batteryhookup 
BigBattery USA  https://bit.ly/Bigbattery
Tim De Groot NL https://ebay.to/2OX9koS
Power 2 Spare USA  https://ebay.to/2SuJWsr
Pro-LOX Netherlands  https://ebay.to/2HsyPKr
Paolo Italy https://ebay.to/38xPUhT
Reply
#7
Here is what I have been working on.

https://drive.google.com/file/d/1OxDgq43...QGIjvhDlRU


Left most of my data in there for you to check out.

Ctrl+S to enter cell data  ... it's easy for me to use Smile

Ctrl+D to enter date information.  I know there are bugs but it's what I could figure out so far.


The field to the right of the "Clone" and "New Cell" button determines how many ..... new or clones
Nice thing about Excel is it easy to manipulate vs web forms.

I decided to not worry so much about exact initial voltage so made some quick click buttons.

I like the ability to click on "Cell #" and using the up/down arrows.  It actually moves you up and down the excel sheet. so up is a lowering of the number (kinda counter intuitive) but logical.

Enjoy
Reply
#8
Wolf already posted a link to the sheet I'm using, Daromer has posted his harvesting flow chart several times across the forum which , if you haven't read yet, is a great place to start.  

I've found it absolutely necessary to work out a system in order to quickly and accurately log cell information (I have minimal free time at home).  This has led to a couple pieces of kit to facilitate an orderly process.  If you check out my google drive (link in signature) I've got photos of my resting setup, and a box to maintain cell order, both are based on the cheap and available cell holders.  

My process is:
I use a YR1030 to measure the voltage and IR of each cell, write that on the cell, and then put the cell into the "inbox".  Then, when the cell is going to be charged, I put four cells into the charger (Opus) and enter the voltage, IR, and cell model for each cell into the spreadsheet.  I always work from left to right on the charger. Once the cells are done charging I write down the capacity measurement on the cell and log it in the spreadsheet, then put the cells in the resting setup.  The resting setup has 24 columns, two for each day of the week in a 2 week (14 day) cycle, one column each day for the morning charge, and one for the evening charge.  Working from left to right on the charger I pull the cell and place it from top to bottom in the resting setup in the column corresponding to the correct test slot (day of the week/time of day).   If I miss a charging time I just skip a column in the resting set-up.  I progress through the resting setup each day of the week, measuring the resting voltage of the cell that is 14 days old, and placing new cells in t rest.  When I measure the 14-day resting voltage I enter that value in the spreadsheet.  The spreadsheet is set up to flag if the cell passes all criteria or not.  Pass conditions are >2000mah, >80% remaining capacity, and 14 day resting voltage >4.12V.  If the cell passes, I assign it a project cell number, and then place that cell in the next position in the current order box.  The order box is a 10x10 grid of cell holders so I can store 100 cells at a time and easily locate a cell within the grid (I number the 10's and 1's columns).

It's taken a bit for me to refine my process to this point, but now I can process 8 cells a day while logging all the data I'm interesting in, in less than 10 minutes and keep those cells in an exact, easily searchable, order for later use.  If I can keep up the pace of 8 cells a day for at least 300 days in a year I will have tested 2400 cells, and while I'm not currently screening cells based on IR, if I had the supply to do so and still keep up, you'd likely have nearly 100% cell pass rate, easily enough for a 14s150p wall.
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
#9
8 cell per day isnt much but perhaps enough. I do 80 per day in under 10 minutes in terms of pure testing. Then it takes me around 15 minutes to crack open and clean 80 cells so a total of 25 min per day at most when doing 80 cells per day is my current pace.
The Ultimate DIY Solar and build place
YouTube / Forum system setup / My webpage  Diy Tech & Repairs

Current: 10kW Mpp Hybrid | 4kW PIP4048 | 2x PCM60x | 100kWh LiFePo4 | 20kWh 14s 18650 |  66*260W Poly | ABB S3 and S5 Trip breakers
Upcoming: 14S 18650~30kWh
Reply
#10
(09-16-2019, 03:52 PM)daromer Wrote: 8 cell per day isnt much but perhaps enough. I do 80 per day in under 10 minutes in terms of pure testing. Then it takes me around 15 minutes to crack open and clean 80 cells so a total of 25 min per day at most when doing 80 cells per day is my current pace.

pure testing doesn't take up the time, recording the data and keeping the cells in order once uniquely identified is what takes the time.  I think you've shown that unique ID is not necessary for functional walls, binning and building on a 100mAH resolution will result in a completely acceptable product.  I'm choosing to go the extra distance for tighter pack balancing and it adds to the processing time.
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


Forum Jump:


Users browsing this thread: 1 Guest(s)