Free UPS fleet battery tracker
What does this UPS battery tracker do?
It is a free Excel workbook for sysadmins and homelabbers. Pick each UPS from a dropdown of all 43 models on this site, enter its install date, and the sheet fills in the cartridge SKU, the bare cells, the DC amps, the replacement date and a link to that model's page.
No sign-up. It opens in Excel and other spreadsheet apps, and the dropdown and formulas are built on standard functions.
| Column | Where it comes from |
|---|---|
| Asset, model, serial, install date | You fill these in. The model is a dropdown |
| OEM cartridge and bare cell spec | Looked up, for example 4 x 12V 9Ah F2 |
| Max DC amps | Solver, at the model's watt rating and 82% efficiency |
| LiFePO4 ceiling at a 12 A BMS | Solver, shown only where a verified pack fits |
| 36-month due date and status | Install date plus 36 months, compared with today |
| Order and model page links | Open that model's page on this site, with its parts list |
How is the replacement date worked out?
The sheet adds 36 months to the install date you enter, then marks the row OK, due within 90 days, or overdue against today. Thirty-six months is a planning interval rather than a manufacturer figure, so shorten it for hot rooms, or for sites with frequent outages and deep discharges.
Where do the numbers in the spreadsheet come from?
They come from the same spec ledger and solver as the pages on this site, and the file is rebuilt with every release. A model with no published cell data says so instead of guessing, and a LiFePO4 ceiling appears only where we can show that a pack actually fits.
See the spec ledger and the method.
Why does a bigger fleet need a log at all?
A rackmount cartridge can hold four cells and list for several hundred dollars, and every unit ages on its own clock. Logging install dates lets you replace batteries on a schedule rather than after a failed self-test, and lets you order the right cell count for each unit up front.
| UPS | Cartridge | Inside | List price | Saving |
|---|---|---|---|---|
| SMT1500RM2UC | APCRBC159 | 4 x 12V 9Ah | $524 | ~73% |
| SMT1000RM2UC | APCRBC157 | 4 x 12V 7.2Ah | $596 | ~77% |
| PR2200LCDRT2U | RB1290X4F | 4 x 12V 9Ah | $352 | ~60% |
| PR1500LCDRTXL2U | RB1290X4F | 4 x 12V 9Ah | $352 | ~60% |
| PR1500LCDRT2U | RB1270X4F | 4 x 12V 7Ah | $281 | ~50% |
| PR1500LCD | RB12170X2A | 2 x 12V 17Ah | $248 | ~51% |
| OL1500RTXL2U | RB1290X3L | 3 x 12V 9Ah | $220 | ~52% |
| 5P1500R | EBP-0807 | 6 x 6V 9Ah | $437 | ~73% |
Savings use a non-Amazon single-unit bare-cell reference, and each page names its source.