A while ago I posted about a battery tracking spreadsheet. Its been a bit enhanced since then, thought I would share it around. Sample images of it are in this post, to get a copy PM me!
You start off adding your cells to an inventory, and setting up some thresholds for them:
Then you add records as you do stuff with your batteries (all the formatting here is automatic):
A Summary page is fully automatically generated and formatted with all sort of stats. You can add records by selecting one or more cells in the summary and then clicking on the buttons to add the records (to save you having to type them in):
The summary automatically highlights cells that are a) due for a charge or b) have been cycled too many times without a discharge, c) have been too long between deep discharges, d) have been too long between refresh&analyses or breakins. You can customise the thresholds for these, per battery and per device, in the Setup sheet. The setup sheet also allows you to vary the per-battery settings based on what state the battery is in, and set thresholds for yellow (action coming up), purple (action due), and red (action overdue). Its not as complicated as it sounds its pretty neat.
The summary also shows how many cycles, deep cycles, and Ah the cell has been through, and also shows the most recent R&A/BI capacity and how much the cell has degraded since its first R&A/BI.
The summary also shows overall statistics totally up all your cells for statistics junkies:
The summary also has the "device grid" which automatically shows which devices are loaded with cells at the moment (devices highlighted means they are loaded with cells). Its handy when you have some "lost" cells to see the device you loaded them into and forgot about not highlighted in the device grid. Also, selecting a device, and one or more batteries by holding down "control", and clicking on the "Use" button painlessly adds a record that you have just used that battery in that device.
There is extensive help, an excerpt of which is here:
The wording I've used is all related to the Maha C9000 but there are equivalent cycles on many chargers. If you have a charger that doesn't have an LCD display for capacities etc, you can still use the spreadsheet, it will track cycles and dates and where cells are etc, it just won't do the capacity side of things - you could always hide those columns.
It currently supports up to 500 cells, and over a million historical records (although with that many historical records, analysing the stats might take a while. Luckily the spreadsheet uses a cache so it doesn't need to analyse all the stats every time you update the Summary, only new stuff you've added).
You can name cells whatever you like as long as the names are
-2 or more characters in length; and
-the last character (rightmost) is a digit 0-9
The characters to the left of the last digit form a prefix. All cells with the same prefix are displayed together as a group, and you can add records for them together.
Disclaimer: You need a form of OCD (at least a mild case) to want to track your cells over time I know some people (me included) do it. This spreadsheet is designed to make that as easy/painless as possible. And be pretty oo:
You start off adding your cells to an inventory, and setting up some thresholds for them:
Then you add records as you do stuff with your batteries (all the formatting here is automatic):
A Summary page is fully automatically generated and formatted with all sort of stats. You can add records by selecting one or more cells in the summary and then clicking on the buttons to add the records (to save you having to type them in):
The summary automatically highlights cells that are a) due for a charge or b) have been cycled too many times without a discharge, c) have been too long between deep discharges, d) have been too long between refresh&analyses or breakins. You can customise the thresholds for these, per battery and per device, in the Setup sheet. The setup sheet also allows you to vary the per-battery settings based on what state the battery is in, and set thresholds for yellow (action coming up), purple (action due), and red (action overdue). Its not as complicated as it sounds its pretty neat.
The summary also shows how many cycles, deep cycles, and Ah the cell has been through, and also shows the most recent R&A/BI capacity and how much the cell has degraded since its first R&A/BI.
The summary also shows overall statistics totally up all your cells for statistics junkies:
The summary also has the "device grid" which automatically shows which devices are loaded with cells at the moment (devices highlighted means they are loaded with cells). Its handy when you have some "lost" cells to see the device you loaded them into and forgot about not highlighted in the device grid. Also, selecting a device, and one or more batteries by holding down "control", and clicking on the "Use" button painlessly adds a record that you have just used that battery in that device.
There is extensive help, an excerpt of which is here:
The wording I've used is all related to the Maha C9000 but there are equivalent cycles on many chargers. If you have a charger that doesn't have an LCD display for capacities etc, you can still use the spreadsheet, it will track cycles and dates and where cells are etc, it just won't do the capacity side of things - you could always hide those columns.
It currently supports up to 500 cells, and over a million historical records (although with that many historical records, analysing the stats might take a while. Luckily the spreadsheet uses a cache so it doesn't need to analyse all the stats every time you update the Summary, only new stuff you've added).
You can name cells whatever you like as long as the names are
-2 or more characters in length; and
-the last character (rightmost) is a digit 0-9
The characters to the left of the last digit form a prefix. All cells with the same prefix are displayed together as a group, and you can add records for them together.
Disclaimer: You need a form of OCD (at least a mild case) to want to track your cells over time I know some people (me included) do it. This spreadsheet is designed to make that as easy/painless as possible. And be pretty oo: