Spreadsheet to calculate % capacity

wattwenger said:

I have created a spread sheet lookupthat if you put in the cell part# in it gives you some info on the cell and also an entry box to where you can input the cells measured capacity and compares it to the rated capacity and gives you the percentage of original to present capacity.
Its pretty rudimentary right now but I think it may be useful.

Let me know what you think and if it is something you would use.

I have added the xlsx file.

Wolf

Click to expand...

Cherry67 said:

wattwenger said:

I have created a spread sheet lookupthat if you put in the cell part# in it gives you some info on the cell and also an entry box to where you can input the cells measured capacity and compares it to the rated capacity and gives you the percentage of original to present capacity.
Its pretty rudimentary right now but I think it may be useful.

Let me know what you think and if it is something you would use.

I have added the xlsx file.

Wolf

Click to expand...

Nice chart. I just figured out changes for the OpenOffice german. Database Index is different.

Formula of percentage loss seems to be wrong, i guess (G4-F4)/F4) is correct.

Click to expand...

wattwenger said:

Cherry67 said:

wattwenger said:

I have created a spread sheet lookupthat if you put in the cell part# in it gives you some info on the cell and also an entry box to where you can input the cells measured capacity and compares it to the rated capacity and gives you the percentage of original to present capacity.
Its pretty rudimentary right now but I think it may be useful.

Let me know what you think and if it is something you would use.

I have added the xlsx file.

Wolf

Click to expand...

Nice chart. I just figured out changes for the OpenOffice german. Database Index is different.

Formula of percentage loss seems to be wrong, i guess (G4-F4)/F4) is correct.

Click to expand...

Updatedthe spreadsheet with the changed formula. Also I have to add the Samsung ICR ******* numbers to the database.
Or someone can do this themselves. Obviously you can also shortcut it by just putting in the mAh rating and the tested capacity.

Wolf

Click to expand...

Cherry67 said:

wattwenger said:

Cherry67 said:

wattwenger said:

I have created a spread sheet lookupthat if you put in the cell part# in it gives you some info on the cell and also an entry box to where you can input the cells measured capacity and compares it to the rated capacity and gives you the percentage of original to present capacity.
Its pretty rudimentary right now but I think it may be useful.

Let me know what you think and if it is something you would use.

I have added the xlsx file.

Wolf

Click to expand...

Nice chart. I just figured out changes for the OpenOffice german. Database Index is different.

Formula of percentage loss seems to be wrong, i guess (G4-F4)/F4) is correct.

Click to expand...

Updatedthe spreadsheet with the changed formula. Also I have to add the Samsung ICR ******* numbers to the database.
Or someone can do this themselves. Obviously you can also shortcut it by just putting in the mAh rating and the tested capacity.

Wolf

Click to expand...

Nice work all in all.
I found a few entries in the database, look at CGR18650EA, having a space in the beginning. They must be removed.
(Update: I just found those entries spread all over the database)
Sorry for me playing Hiob, i dont want to critisize, but help to improve.

if Someone needs it - my openoffice whats to have the database reference like
WENN($A4="";"";SVERWEIS($A4;$Database.A$2:K$206;2;0))

At moment it is abit difficult to extend the Database, snice the reference limits are fixed in the datasheets formula. Can that be done indirectly ?

Click to expand...

wattwenger said:

Yes I know about the spaces and am slowelyresolvingthem as I said it is a work in progress and pretty rudementery right now but can be expanded upon.
I'm also working on an access version of this that will have a dashboard to enter cells in with simular calculations. But that is a way off as I am not an expert in excel nor access.

Wolf

Click to expand...

Cherry67 said:

wattwenger said:

Yes I know about the spaces and am slowelyresolvingthem as I said it is a work in progress and pretty rudementery right now but can be expanded upon.
I'm also working on an access version of this that will have a dashboard to enter cells in with simular calculations. But that is a way off as I am not an expert in excel nor access.

Wolf

Click to expand...

Contains .ods Database syntax and updated database without spaces in the beginning.

The values are newly measured, using kelvin Clip at 1.3 Amps (3 Ohm Load) on 2 cells, if not otherwise noted.
The cells come from the bin with cells, which have been suspicious for SD sometimes but did show up "nearly good" in the second check.

Some unknown cells.

More values to come.

Click to expand...