MS Excel – Calculate size of battery bank and inverter

Calculate size of battery bank and inverter
Calculate size of battery bank and inverter

How to Calculate the Size of UPS & Inverter with battery Bank by using Excel

This spreadsheet calculates the necessary size of a battery bank and inverter for an electrical load. It details the load details, including one device using 100 watts for 1 hour per day, for a total daily load of 100 watt-hours. It then calculates that a 60 amp-hour battery bank is required to power this 2.5 day reserve load, accounting for losses. The battery bank will use two 12-volt, 50 amp-hour batteries connected in series-parallel. A 150 kW inverter is calculated to be the appropriate size.

Inverter-UPS Size with Battery Bank Calculator:

  • Calculate Total Demand Load
  • Calculate Size of Battery Bank in Amp.Hr.
  • Select Type of Connection of Batteries in Battery Bank
  • Select Rating of Each Battery in Battery Bank
  • Calculate Size of Inverter/UPS.
  • ups battery calculation formula
  • how to calculate battery capacity for inverter
  • battery backup time calculation formula
  • 150ah battery backup time calculator
  • how to calculate battery capacity for inverter pdf
  • 200ah battery backup time calculator
  • 220ah battery backup time calculator
  • inverter load calculation spreadsheet

Title : Inverter-UPS Size with Battery Bank

Type : Microsoft Excel Spreadsheet (xlsx)

Size : 129 KB 


Download Now

FAQ:

You can calculate the battery size for inverters using the formula B = P × t / Vdc, where B is the battery capacity in ampere-hour, P is the inverter’s power rating, t is the duration of power supply in hours, and Vdc is the DC voltage of the inverter.

To determine a battery size one has to first calculate the load current of the UPS and then multiply it by the runtime factor. Load Current for x hours = Answer multiplied by x hours = closed battery size in Ah. Once this is derived the closest battery size for the power can be easily determined.

The formula is Backup Time = C*V/W, where C represents the battery capacity in Ah, V is the battery’s input voltage, and W is the total load in watts. For instance, consider an inverter with a 200Ah battery and 12V input voltage.

Battery bank capacity: Take the watt-hours per day and multiply them by the number you decided upon in 3. This should represent a 50% depth of discharge on your batteries. Therefore multiply by 2 and convert the kwh result into amp hours (AH). This is done by dividing by the battery voltage.

Leave a Reply