🌐
MEP WORK
mepwork.com › home › excel sheet › ups sizing calculation excel sheet xls
MEP WORK: UPS Sizing Calculation Excel Sheet xls
November 23, 2023 - Ups battery and inverter calculation excel sheet xls. Sizing of uninteruptable power source.
🌐
Engineers Edge
engineersedge.com › excel_calculators › Electrical_Electronics_Excel_Calculators › ups_requirements_calculator_spreadsheet_14915.htm
UPS Requirements Calculator Spreadsheet
Ensure that you verify units utilized in excel application meet your requirements before downloading. Electronics, Instrumentation & Electrical Database · Uninterrupted Power Supply (UPS) Requirements Calculator Spreadsheet · Note: Accessing this resource requires an active Premium Membership with Engineers Edge · Download: Uninterrupted Power Supply (UPS) Requirements Calculator Spreadsheet · Inverter / UPS Details Total Load Total Starting Load Inverter efficiency Size of Inverter / UPS
Discussions

Calculate UPS size
UPS capacity for how many VA/watts it can handle and how long it will run are completely unrelated. A lot of UPS models in the same line will all use exactly the same battery packs. A typical setup is 2 to 4 7Ah sealed lead acid 12v batteries. If you have a 2-cell battery pack, that's 2*12v*8A == ~170 Watt/hours. Assuming the inverter is 90% efficient, and your 380 watts of power need, expect about a 20 minute runtime. More on reddit.com
🌐 r/homelab
14
14
October 21, 2023
UPS Capacity Calculation Formula - Anyone has an easy to understand one to follow for those calculations required every once in a while

If you want detailed information you have to rely on the data given by the manufacturer. Batteries behave differently depending on the load. The only thing that applies pretty much every time is: Try not to go over 80% load. Always leave some headroom, the more the better obviously, but 80% max load is a typical recommendation.

Generally, Watts = Voltage * Ampere. Capacity is often specified in AH, or Ampere Hours (Ampere * Hours). If a battery has a capacity of 9AH, that means: 9 = Ampere * Hours. Fill in ampere, which is what your devices draw, and you'll get to the hours. We assume the battery is designed for usage in 110V scenarios.

If your equipment runs at 110 volts and it has a power rating of 500 watts, that gives you: 500w = 110v * A. Divide 500 by 110 and you get approximately 4.5 amps. If you go back to the battery you'll see it has a capacity of 9AH, which means it can supply 9 ampere for 1 hour. Since you only need 4.5 amps, that would give you a runtime of 2 hours.

Here's the thing though: Batteries are limited in how many amps they can supply. You cannot just draw 1000 amps, batteries have a rated output current as well. This is the number you need to determine how much load you will put on the battery. If the battery is rated for 9 amps output current then drawing 4.5 amps would put it at 50% load. And this is where the charts from the manufacturer come in: The efficiency of a battery depends on the load. The basic math holds up, drawing 4.5 amps from a 9Ah rated battery will give you a runtime of 2 hours. But when you factor in the heat generated by the load, the power factor of the battery/UPS, a bit of loss from the cabling etc. then your results can vary quite a bit. This is why the "half-load runtime" isn't twice as long as the "full-load runtime", even though that should be the case. The UPS you linked to mentions a "half-load runtime" of 9.5 minutes; Doubling the amps drawn (to get to full load) should reduce this to 4.75 minutes; half the time. However, with all other factors in play you get a specified full-load runtime of just 2.5 minutes. That is barely more than a quarter of 9.5 and nowhere near half of 9.5 as you would expect.

Ultimately, even though calculating the runtime is fairly easy if everything was working with an efficiency of a 100%, that unfortunately is never the case. Efficiency varies greatly between manufacturers and the load put on the batteries so the only thing you can do is consult the runtime charts of the manufacturer.

In the end what you should do is: See how much current (ampere) you need for your equipment, look at the output rating of the UPS to determine how much load your equipment will put on the battery, then consult the chart to see what runtime you will get. Always leave some headroom, a) because if you do things like shutting down servers once you know the UPS has kicked in those servers might draw more current during shutdown than they would if they were running regularly. The battery needs to be able to handle that load as well, even if it's just for a minute. Also, b) batteries will deteriorate over time. You will get a minute or two less runtime at some point, you need to accommodate for that as well.

To sum it all up:

Q1: How long can I run in minutes my equipment which needs 500 Watts?

Look at the UPS/batteries to see how much load 500 watts would be (calculate your current draw by dividing Watts / Voltage) by checking your current draw against the power current rating. Then check the charts to see how much runtime a load of X% will give you.

Q2: What is the maximum watt usage I can permit if i want to get X minutes of uptime/runtime?

That is pretty much the same question as above. Check the charts of much runtime you will get with 80% load, then multiply the current at 80% with your voltage and you get watts.

Q3: How can i include in my calculation the presence of an extended battery (for models where it is a possibility)?

Just add up the ampere hours of all batteries included.

More on reddit.com
🌐 r/sysadmin
7
1
January 20, 2021
APC UPS Battery Backup - How to Calculate the power input in all my devices to choose the right Battery Backup?
I'd measure the total consumption over a period of time with a meter, or smart plug. Laptop has a battery, consumption will depend on usage and if its charging or not. In case of a long outage it may be acceptable to power down a screen for a bit? More on reddit.com
🌐 r/homeassistant
35
12
January 6, 2024
How to calculate runtime on a UPS
It all comes down to energy. Energy is stored in batteries, and used up by devices doing work. The way that energy is transferred is by pushing electrons. Current, measured in amps, is how many electrons are flowing through in a given time. Voltage, measured in volts, is how hard the electrons are being pushed. Power, measured in watts, is the amount of energy transferred in a given time. kilowatt-hours (kWh) is a measure of energy, in more convenient units. So to calculate runtime, you start by measuring the power input into all of your devices. You can get that a couple of different ways. measure the number of kWh used over a time period, and then divide by the number of hours in the time period to get kilowatts. measure the current and multiply by the voltage (power = voltage * current) Once you've got that, you know how fast the energy is draining out of the battery. Now you need to know how much energy is in the battery. According to the specs of the UPS you posted, it has "Battery Volt-Amp-Hour Capacity 845". A volt-amp is the same as a watt (sort of, the difference exsts but isn't important here) so that means the battery has a capacity of 0.845 kilowatt-hours. If the load was 0.845 kilowatts, the battery would last exactly one hour from full charge. If the load is 2.535 kilowatts, the battery will last 20 minutes from full charge. Your power draw in that screenshot is 207.5 volts at 8.6 amps, which is 1.7845 kilowatts. So your battery runtime will be 0.47 hours, or about 28 minutes. There are two caveats for this! The first is that the calculation gives you the theoretical maximum runtime. In reality, it will be less - batteries don't like discharging to zero, and there's always losses in the system. The second is that the calculation is crucially based on that current figure, which will vary from second to second. Device power consumption is never constant, it varies with different computing loads, environmental conditions, which devices are in use and other factors. The most accurate way to get runtime is to measure your total energy consumption over a long period, and then divide by that time period to get an average power consumption. I suspect that the 19 minute runtime remaining is because the UPS is averaging the measured power consumption and that figure is higher than the consumption at the time the screenshot was taken. For your new site calculations, is the site up and running already or do you have to calculate consumption theoretically? More on reddit.com
🌐 r/sysadmin
8
0
April 19, 2024
🌐
Scribd
scribd.com › document › 364581823 › UPS-Load-Calculator-Spreadsheet
UPS Load Calculation Guide | PDF
UPS Load Calculator Spreadsheet - Free download as Excel Spreadsheet (.xls), PDF File (.pdf), Text File (.txt) or read online for free. This document provides typical power consumption information in watts for various networking devices that operate at 24 volts, including rockets, GPS units, ...
🌐
Eaton
upsselector.eaton.com › Load
UPS Load Calculator, How Much Power Will Your UPS Use? - Eaton
How Much Power Will Your UPS Use? Choose the right UPS, uninterruptible power supply, based on your total power consumption, Eaton UPS Selector
🌐
Facebook
facebook.com › MEPwork1 › posts › ups-battery-sizing-calculation-excel-sheet-xls › 2235977006547402
UPS Battery Sizing Calculation Excel Sheet xls
MEP WORK. 35,667 likes · 1 talking about this · 54 were here. MEP Calculation sheets, CAD & Revit Drawings, PDF Notes & Tutorial Videos for HVAC, Firefighting, Plumbing & Electrical Works.
🌐
iBall
mspwebstore.com › blog-detail › Guide-to-UPS-Sizing-Finding-the-Right-Fit-for-Your-Needs
UPS Sizing Made Easy: Choose the Perfect Power Backup
November 23, 2024 - To perform a battery calculation for ups, consider factors such as: Battery sizing: Determine the appropriate battery size based on your load and desired runtime. UPS battery size: Choose a battery that matches your UPS capacity and provides the necessary backup time. Battery backup formula: Use the formula: Backup Time = (Battery Capacity × Battery Voltage) ÷ (Load in Watts)
🌐
Prostar New Energy
prostarsolar.net › article › how-to-calculate-the-required-ups-load-capacity.html
How to calculate the required ups load capacity?
January 2, 2025 - For example, if your total load is 2150 W and you assume a power factor of 0.8: ... To ensure future expansion, add an additional safety margin of about 20-30%, we usually calculate it using 1.25: Final UPS Capacity = Required UPS Capacity×1.25 = ...
🌐
Fujielectric
india.fujielectric.com › resources › technical-guide › ups-sizing-calculation
Fuji Electric | UPS Sizing Calculation
The cross section of cables required for the input of the UPS can be derived using the same formula like output cables, but the input power in KVA needs to be derived based on the ... Battery Charging Power = 2.2VX No of Cells X Charging Current The charging current is typically 10% of AH Capacity ...
Find elsewhere
🌐
Scribd
scribd.com › document › 477535393 › UPS-Battery-Sizing
UPS Battery Sizing Calculation Guide | PDF
Watts/Battery [With Factor] = 3289.47 Need Constant Power Discharge Characteristics BATTERY OFFERED: - 1 Sets of 150 Ah, 35 blocks for 30 min back up- UNDERSIZED Idc = KVA x 1000 x P.F [Link] Cells X ECV X Inverter Efficiencyx No.
Rating: 4.4 ​ - ​ 7 votes
🌐
Mepengineersclub
mepengineersclub.com › home › excel sheet › ups sizing calculation excel sheet
UPS Sizing Calculation Excel Sheet
June 1, 2022 - Sizing a proper UPS is critical when designing such emergency backup systems to avoid any loss or accident in case of power failure. Below is an excel sheet which can be used to properly size a UPS for your home, office or construction project. ... With this excel sheet calculator you will be able to make sizing and selection for UPS battery and the inverter.
🌐
Scribd
scribd.com › document › 660827292 › UPS-SIZING-CALCULATION
Ups Sizing Calculation | PDF | Technology & Engineering
UPS SIZING CALCULATION - Free download as Excel Spreadsheet (.xls / .xlsx), PDF File (.pdf), Text File (.txt) or read online for free. This document calculates the sizing requirements for an uninterruptible power supply (UPS) system for a project. It determines that the total connected load will be approximately 11.75 kW from 50 workstations at 150W each, 5 additional workstations at 200W each, 5 peripheral devices at 150W each, and 1 server at 2.5kW.
Rating: 3 ​ - ​ 2 votes
🌐
Facilitygateway
facilitygateway.com › how-do-i-calculate-what-size-ups-i-need
How Do I Calculate What Size UPS I Need?
To convert watts to volt-amperes, use the formula: VoltAmps = Watts / Power Factor. You can also calculate the Power Factor (efficiency) of your equipment by dividing True Power (measured in Kilowatts) ...
🌐
Lento India
lentoindia.com › blog › ups-battery-backup-time-calculation-formula.html
UPS Battery Backup Time Calculation Formula
Here’s the simplest and most widely used formula: ... Battery Capacity (Ah) = 100Ah, 150Ah, 200Ah etc. Battery Voltage (V) = usually 12V for a single battery · Battery Efficiency = Typically between 0.7 to 0.85 (70%–85%) Load (Watts) = Total watts connected to UPS ...
🌐
Lbl
datacenters.lbl.gov › sites › default › files › Power Chain Tool_v2.1.xlsx xlsx
Download the XLS Tool
Get the latest news from the Center of Expertise for Data Center Energy delivered to your inbox. We won't share your information and you can unsubscribe at any time
🌐
Eaton
eaton.com › content › dam › eaton › products › backup-power-ups-surge-it-power-distribution › au-products › blade-ups › BladeUPS_Runtime_Calculator_v3_0P.xls xls
BladeUPS Battery Runtime Calculator
Download document () of 20 · Clear selection · Send email · Download selection · Please enter valid email address · Email not sent, please try again · Email sent successfully · Download · You have exceeded the download limit
🌐
Server Room Environments
serverroomenvironments.co.uk › ups-sizing-calculations
How To Size UPS Systems | Server Room Environments
May 8, 2022 - A UPS battery size can be be calculated using the formula: Battery Load (kW) = (UPS kVA x Power Factor) / UPS Efficiency
Address   St. Andrews Business Centre, Bromfield Industrial Estate, Queen's Lane, CH7 1XB, Mold
🌐
Pinterest
pinterest.com › pin › 821977369488032620
UPS Sizing Calculation Excel Sheet xls
UPS Sizing Calculation Excel Sheet xls | Diy electrical, Excel, Ups · Skip to content · When autocomplete results are available use up and down arrows to review and enter to select. Touch device users, explore by touch or with swipe gestures · Log in · Sign up
🌐
Electrical Engineering Portal
electrical-engineering-portal.com › home › download center › electrical software and ms excel spreadsheets (calculations of cables, voltage drop etc.) › calculate size of battery bank and inverter
Calculate size of battery bank and inverter
November 9, 2023 - This MS Excel spreadsheet calculates the following parameters: ... Size of Battery Bank in Amp.Hr. Select Type of Connection of Batteries in Battery Bank ... Size/Type/Tripping setting of Main MCCB. Get access to premium HV/MV/LV technical articles, advanced electrical engineering guides, papers, and much more! It will help you to shape up your technical skills in your everyday life as an electrical engineer.
🌐
Eaton Website
blog.tripplite.com › products › load-runtime-tools
UPS Load and Runtime Calculator | Eaton
Find the perfect UPS system in two easy steps! Calculate the total power consumption of connected devices then choose a runtime so get your recommendations.
🌐
ElectronicsHub
electronicshub.org › home › how to calculate ups runtime calculation
How To Calculate UPS Runtime Calculation
July 3, 2024 - Here is a practical example of the Cyberpower CP1500PFCLCD UPS. Start by calculating the total load from all the devices in watts. You can refer to the formula Wt = W1 + W2 + W3…