Battery Sizing Calculation Record (Excel)
Free download · Excel (.xlsx)
Record battery and UPS sizing calculations with this Excel template. Captures system voltage, load profiles (continuous/momentary/non-continuous), design margin, ageing factor, temperature correction, cell selection, capacity required vs selected, autonomy time, and charger rating. Follows IEEE 485 duty cycle methodology. Essential for emergency power, UPS, and DC system design documentation.
What's Included
How to Print
- ●Open in Microsoft Excel 2016+, Google Sheets, or LibreOffice Calc
- ●Add your company logo and project details to the header
- ●Copy data rows to add more circuits or equipment
- ●Print on A4 or A3 landscape for site records
- ●Keep completed records for design verification and audit trail
Try the Interactive Calculator
Need precise calculations beyond quick reference? Try our free online calculator with full clause references and professional report output.
Open CalculatorRelated Downloads
UPS/Battery Commissioning
Free UPS and battery system commissioning checklist PDF. 11 sections covering cell checks, discharge test, static switch, EPO per IEEE 1188 and IEC 62040. No signup required.
Load Schedule
Download a free electrical load schedule template Excel per IEC 60364 and NEC Art 220. Columns for equipment tag, rated power, phases, demand factor, feeder ref, and annual energy. No signup required.
Max Demand Record
Download a free maximum demand assessment record template Excel per AS/NZS 3000, BS 7671, and NEC Art 220. Columns for load groups, demand factors, diversity, phase assignment, and transformer sizing. No signup required.
Frequently Asked Questions
What is a battery sizing calculation record?
A battery sizing calculation record documents the methodology for selecting battery capacity to support DC loads during emergency or standby operation. It follows IEEE 485 duty cycle analysis and IEC 60896 performance requirements to ensure adequate autonomy time.
What should a battery sizing record include?
Key fields include system voltage, each load with power and duration, load category (continuous/momentary/non-continuous), design margin, ageing factor (typically 1.25), temperature correction factor, cell type, number of cells in series, required and selected capacity in Ah, and charger rating.
What is the IEEE 485 duty cycle method?
IEEE 485 sizes batteries by defining a duty cycle of time periods with different loads. Each period is analysed for the worst-case cell voltage, and the required capacity is the maximum Ah needed across all periods. Ageing factor (1.25) and temperature correction are applied to the result.