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 300, untesteded.
Bms is a diy open source by stuartpittaway.
No solar yet, 
Building wind turbine, 48v im after a 48v motor if anybody has one for sale.
Cells 2000 to 2500ma.
Cells 1500 to 2000ma.
Cells 1000 to 1500ma.
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 | 83kWh LiFePo4 | 10kWh 14s 18650 |  66*260W Poly
Upcoming: 14S 18650~30kWh | Automatic trip breakers, and alot more
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
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
#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 300, untesteded.
Bms is a diy open source by stuartpittaway.
No solar yet, 
Building wind turbine, 48v im after a 48v motor if anybody has one for sale.
Cells 2000 to 2500ma.
Cells 1500 to 2000ma.
Cells 1000 to 1500ma.
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.
Save 10% at Battery Hookup with code 'Powerwalls' Just enter it in checkout www.batteryhookup.com
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 | 83kWh LiFePo4 | 10kWh 14s 18650 |  66*260W Poly
Upcoming: 14S 18650~30kWh | Automatic trip breakers, and alot more
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


Who read this thread?
39 User(s) read this thread:
hbpowerwall (09-13-2019, 11:09 PM), kevinjaye (09-13-2019, 04:40 PM), OffGridInTheCity (09-13-2019, 03:53 PM), intra (09-27-2019, 07:37 AM), winny (10-12-2019, 02:03 PM), ben teker (09-15-2019, 08:04 PM), Marrcin (09-24-2019, 09:41 PM), Nemo (10-16-2019, 03:56 PM), Jarry (10-04-2019, 05:11 AM), Jonisingt35r (09-28-2019, 07:05 AM), rakso (09-15-2019, 08:01 PM), Rabbithacker921 (09-18-2019, 07:47 PM), Eduardo Kang (09-13-2019, 04:27 PM), iNeedMoarProtection! (09-15-2019, 09:05 PM), BatteryMooch (09-27-2019, 11:46 AM), nick81 (10-10-2019, 12:46 PM), Pilotfromdk (10-14-2019, 07:06 PM), Victor8 (10-17-2019, 06:44 PM), rewyred (09-21-2019, 09:24 AM), Wolf (09-27-2019, 11:28 AM), clupton (09-16-2019, 06:45 PM), daromer (09-16-2019, 03:52 PM), owitte (09-13-2019, 07:59 AM), Korishan (09-17-2019, 04:42 PM), jdeadman (09-27-2019, 12:56 AM), The-J-Man (09-14-2019, 11:18 AM), Geek (09-30-2019, 02:37 AM), SWEwall (09-13-2019, 07:08 PM), ChrisD5710 (09-17-2019, 08:57 AM), Oz18650 (09-27-2019, 02:37 AM), rev0 (09-26-2019, 10:28 PM), completelycharged (09-12-2019, 08:41 PM), Ibiza (09-27-2019, 03:03 AM), Bubba (09-27-2019, 01:38 AM), Riplash (09-18-2019, 01:33 AM), HikingGuy42 (10-09-2019, 02:22 AM), chuckp (09-17-2019, 09:39 PM), Beholder (09-27-2019, 09:11 PM), morrieken (11-10-2019, 09:35 AM)

Forum Jump:


Users browsing this thread: 2 Guest(s)