Cell testing spreadsheet

M

Mark Lex

Member
Joined
Jun 25, 2017
Messages
30
I know a lot of people here test their cells and then write the capacity on the cell. Someone else did it a bit differently and gave each cell an ID#, then recorded the cell info in a spreadsheet. I can't remember whose YouTube video it was. Anyone know? I'd like to do something similar. cheers.
 
LOL. Is that called... erm... a typewriter or a pen? ;)
If so, I'll put it on my "List Of Things I Want To Buy"
Note: it'll be well after Charge Controller and 3d Printer...
 
1958greyhound said:
Then you can get the machine that prints heatshrink .
Click to expand...

Don't be so quick to sarcasm.

I was reading this thread before. Perhaps OP was referring to an access database. Was considering this myself.

Excel has some cell ID function but it has been some time since I used it.

Mark if I build such a database, I shall give it a friendly interface and email you the blank
 
Geek said:
1958greyhound said:
Then you can get the machine that prints heatshrink .
Click to expand...

Don't be so quick to sarcasm.

I was reading this thread before. Perhaps OP was referring to an access database. Was considering this myself.

Excel has some cell ID function but it has been some time since I used it.

Mark if I build such a database, I shall give it a friendly interface and email you the blank
Click to expand...

It is a great start to buils well balanced packs.
Not a bad idee, just more work.
I have seen sombody who used labels with a bar-code to give the cells a ID. ( maybe a bit overkill but great looking ) :)
 
Geek said:
1958greyhound said:
Then you can get the machine that prints heatshrink .
Click to expand...

Don't be so quick to sarcasm.

I was reading this thread before. Perhaps OP was referring to an access database. Was considering this myself.

Excel has some cell ID function but it has been some time since I used it.

Mark if I build such a database, I shall give it a friendly interface and email you the blank
Click to expand...

Sorry, not sarcasm, just humour.
 
@1958.
Wow! I didn't know such a device existed. Thanks for enlightening me.
I re-read my post. It does sound sarcastic. Apologies. my sense of humour, doesn't "type" very well.

Still looking for that spreadsheet.
may need to make my own.
 
I was thinking (mildly) about using rfid tagging each cell. This would be built as well into the bms so each cell would be exactly monitored throughout the whole process and life cycle. If a problem arose, it'd be very easy to determine which cell was the problem and locate it easily.
Though, I doubt I'll go through with 'that' level of detail :p rows/columns will be good enough
 
MarkLex said:
@1958.
Wow! I didn't know such a device existed. Thanks for enlightening me.
I re-read my post. It does sound sarcastic. Apologies. my sense of humour, doesn't "type" very well.

Still looking for that spreadsheet.
may need to make my own.
Click to expand...

Well. Now I guess I am compelled to create such a database
 
I'm a MySQL DBA, I could build a basic website, with a database backed for a tracking system. It then could assign ID's for reach battery.
 
Actualy it's not that bad an idea. I've just recently started harvesting cells too and I immediately started indexing the cells. I write a serial number on the cell, and the measured initial voltage.
All this info goes into an excel database. As such I also can choose the best 16 cells to be charged initialy to 4.2V. I also add extra info to this database, all the way going to indexing all battery packs I'll build and consigning the index to the cells...

Perhaps overkill, but I guess if I were ever to try and sell the packs, being able to provide detailed test data on each cell could be interesting to show the customer I mean business :)
 
@Ivo. That's exactly what I had in mind. Yes, it's prolly overkill, but I like it.

I'm still harvesting cells, haven't even begun to test them yet, but this is what I'm thinking: I give each cell a unique ID number, which I write on the cell once it's been freed from its pack. I also peel off the label on the laptop battery pack and write the ID numbers on the label and keep it, so I can cross-reference. Lots of info on the labels: Make, model, Voltage, Wh, Ah, Serial number (maybe even date code?)
I'll record: Date opened, initial voltage, Make and Model of cell (which I can cross-reference to the cell database on this forum) and then continue capturing info as it goes through the testing process (which I haven't started yet) Things like date charged/discharged, capacity, Voltage after 4 weeks, etc, etc.
What are you capturing/recording?

ChrisDavis said:
I'm a MySQL DBA, I could build a basic website, with a database backed for a tracking system. It then could assign ID's for reach battery.
Click to expand...

Chris, are you talking of a public, community wide database for each individual cell? Whoa!
 
A4 label stock is quite cheap - the kind you can feed your ordinary home printer.Most label printers are thermal, so these would be no good anyway.

As for a bar code scanner, just get a smartphone, and a bar code scanning app.

Bar code scanners are also cheap. I have used a couple of $20 eBay Chinese specials - aside of getting software for some of them, most just act like ordinary keyboards. Programming themis a little difficult, as the instructions are usually in Chinese, or so badly translated, that they may as well be in Chinese.

ChrisDavis said:
I'm a MySQL DBA, I could build a basic website, with a database backed for a tracking system. It then could assign ID's for reach battery.
Click to expand...

That would be awesome. Depending how much time people contributing were going to spend, it would be great to get an idea of what to expect from a cell. Save a lot of time testing cells that may prove fruitless.
 
Mark Lex said:
@Ivo. That's exactly what I had in mind. Yes, it's prolly overkill, but I like it.

I'm still harvesting cells, haven't even begun to test them yet, but this is what I'm thinking: I give each cell a unique ID number, which I write on the cell once it's been freed from its pack. I also peel off the label on the laptop battery pack and write the ID numbers on the label and keep it, so I can cross-reference. Lots of info on the labels: Make, model, Voltage, Wh, Ah, Serial number (maybe even date code?)
I'll record: Date opened, initial voltage, Make and Model of cell (which I can cross-reference to the cell database on this forum) and then continue capturing info as it goes through the testing process (which I haven't started yet) Things like date charged/discharged, capacity, Voltage after 4 weeks, etc, etc.
What are you capturing/recording?

ChrisDavis said:
I'm a MySQL DBA, I could build a basic website, with a database backed for a tracking system. It then could assign ID's for reach battery.
Click to expand...

Chris, are you talking of a public, community wide database for each individual cell? Whoa!
Click to expand...
Yea why not. :) we are all a big team right :)
 
I'm not indexing cells or recording brand/model info. I am using a spreadsheet to build packs of the same capacity though with cells in a range of 1800-2400mah. Each pack is saved in a sheet with a pack number and I know where the cells are based on where they are in the grid on the spreadsheet.

Eg if I wanted to sample cells that were 1800mah as the pack was built, I can easily locate them and pull them for testing in 12 months etc. Not sure if I'll ever actually do that sort of thing though. I'll probably just swap out packs if they exhibit problems (heat, blown fuses, difficulty maintaining balance etc)
 
MarkLex said:
I know a lot of people here test their cells and then write the capacity on the cell. Someone else did it a bit differently and gave each cell an ID#, then recorded the cell info in a spreadsheet. I can't remember whose YouTube video it was. Anyone know? I'd like to do something similar. cheers.
Click to expand...

Don't know if I'm the guy you're looking for, butI've been putting individual IDs on my cells and adding them to a spreadsheet. Its kind of useful, especially when I rub the sharpie ink off the cells. I'm also using the spreadsheet to calculate how much I've paid per cell, and other calculations to help me design the batteries I want to make. Lets see if I can match a text explanation with the pictures...

Cell data (any attributes you want, really) Cells gone bad (and why) Resistance calcs Battery and cell cost calcs

image_wzvgge.jpg


Calcs to determine how many series and parallel cells I need to cover requirements of whatever I'm powering:

image_dbkfgi.jpg


Putting the capacities together for the actual battery. I use the Pack Builder here to determine the arrangement.
You can see here, the E-bike battery is still being designed.

image_zlecdi.jpg


I hope this is interesting and what you're looking for. :)
 
Yii2 and some simple draws on the db in mysql and login module and you got all needed for a basic online indexer of cells :) Would be cool to do but i would not personally use it.

Lets see if I find a late night where i got nothing to do unless someone else already done it.
 
You must log in or register to reply here.
Back
Top