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
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.
If you'd like to support the forum please feel free to use my affiliate links to purchase all kinds of stuff for your projects 
Amazon - https://amzn.to/2qURmH2
eBay - https://goo.gl/6mrQHH 
Aliexpress - http://s.click.aliexpress.com/e/bNLW537E
Banggood -  https://goo.gl/FF2v6W
Battery Hookup - http://bit.ly/2Oe9PLW 
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


Who read this thread?
24 User(s) read this thread:
hbpowerwall (09-13-2019, 11:09 PM), Beholder (09-13-2019, 07:42 PM), Wolf (09-14-2019, 11:35 AM), kevinjaye (09-13-2019, 04:40 PM), OffGridInTheCity (09-13-2019, 03:53 PM), intra (09-13-2019, 11:56 PM), ben teker (Yesterday, 08:04 PM), Nemo (Today, 01:33 AM), Jonisingt35r (09-13-2019, 06:56 PM), rakso (Yesterday, 08:01 PM), Eduardo Kang (09-13-2019, 04:27 PM), chuckp (09-13-2019, 01:58 PM), Bubba (09-14-2019, 03:26 PM), daromer (09-13-2019, 07:17 PM), owitte (09-13-2019, 07:59 AM), Korishan (09-13-2019, 11:37 PM), jdeadman (09-14-2019, 03:03 AM), The-J-Man (09-14-2019, 11:18 AM), Geek (Today, 04:38 AM), SWEwall (09-13-2019, 07:08 PM), Oz18650 (09-13-2019, 10:56 PM), completelycharged (09-12-2019, 08:41 PM), Ibiza (09-13-2019, 12:48 AM), iNeedMoarProtection! (Yesterday, 09:05 PM)

Forum Jump:


Users browsing this thread: 1 Guest(s)