battery sizing calculation excel sheet

While I agree using the end voltage is ultra conservative, the method of using the nominal voltage is incorrect and results in undersized batteries for true use. Anti-lock braking system (ABS) modeling and simulation (Xcos), Types of Mild Hybrid Electric Vehicles (MHEV), How to calculate the internal resistance of a battery cell, How to calculate road slope (gradient) force, average energy consumption of the vehicle on a driving cycle. 8 ! EE-Tools, Instruments, Devices, Components & Measurements, battery only store DC power instead of AC power. The following Excel sheets will help you calculate the maximum/minimum number of modules per series string while designing your PV system. & Load LoadDuration (Mins. Also, you want to ensure the battery has the capacity to support the load and trip per IEEE 450 (e.g. Premium Membership This calculation method is more appropriate for cylindrical cell, since the volume occupied by a cylindrical cell must take into account the air gap between cells. For this example we are going to consider that the battery pack is made up only from several strings connected in parallel. Performance & security by Cloudflare. Ive updated the XLS link above, please check. 06 v difference. Note: Since battery cells manufacturers come up with newer models continuously, it might be the case that the data used in this example is obsolete. Battery Calculations Take the total standby current and multiply by 24 (hours for standby) Take the total alarm current and multiply by (.083 for 5 minutes or .249 for 15 minutes of alarm) Add the total of (standby current x 24) to (alarm current x .083 or .249) Multiply the total of above by a safety factor of 1.2. [[ retSilent(doc, ['result', 'Ncell_min', '_val']) ]], [[ retSilent(doc, ['result', 'Ncell_max', '_val']) ]], [[ retSilent(doc, ['result', 'Ncell', '_val']) ]], [[ retSilent(doc, ['result', 'Vmax_attained', '_val']) ]], [[ retSilent(doc, ['result', 'Vmin_attained', '_val']) ]], [[ retSilent(doc, ['result', 'Veod', '_val']) ]], [[ retSilent(doc, ['result', 'strings', '_val']) ]], [[ retSilent(doc, ['result', 'Fs_max', '_val']) ]], [[ retSilent(doc, ['result', 'Fs_random', '_val']) ]], [[ retSilent(doc, ['result', 'Fs_uncorrected', '_val']) ]], Cell Section Size (Corrected for Design Margin and Aging Factor), [[ retSilent(doc, ['result', 'Fs_corrected', '_val']) ]], [[ retSilent(doc, ['result', 'cell_selected', '_val']) ]]. This document was uploaded by user and they confirmed that they have the permission to share it. not just cells. The size and mass of the high voltage battery are very important parameter to consider when designing a battery electric vehicle (BEV). The changes in temperature affect the efficiency and life of batteries. There are various configuration limits you need to consider while inverter sizing. Therefore, the recommended circuit breaker in this example=700A, 65VDC, 15,000 AIC. Hello Sir, I find your article very useful and relevant to my work as a maintenance personnel in a distribution Utilities. This is less important since the aim or the article is to explain how the calculation is done. Yes, all batteries have an internal resistance, and the cell voltage decreases as it depletes. 1amp = 1000ma. It actually captures the reduction in battery performance because of the age factor. @ @ " x! For Monthly kWh, check your monthly kilowatt-hour usage printed on your electric bills. Example of UPS battery sizing. VDC. hbbd``b`$^ Fv $AN System Sizing Worksheets: Everyone is welcome to use our home PV solar electric system sizing worksheets - Version 1. In our example, the number of days of autonomy is 2 days. x@ @ 0 This standard is a method for defining DC loads and sizing lead-acid batteries. Find your perfect solar solution! "@type": "BreadcrumbList", Save my name, email, and website in this browser for the next time I comment. The more discharging of a battery, the fewer cycles will be completed. @ @ l! The input parameters of the battery cells are summarised in table below. The load profile for this case is demonstrated in the figure right and the following parameters were computed: Total Design Energy Demand = Ede = 3,245 Vah. All we have to do is find the current through the controller by using power = voltage x current. Although the 12V system is more common, you may use a 24V or 48V system for solar panel installation systems depending on the system configuration requirement. You will have to connect 10 batteries each of 100Ah in parallel to run a 900Wh load (minimum for 3 hours) per day with 2 autonomy days. ${{k}_{af}}$, Battery Aging Factor (%)if(typeof ez_ad_units != 'undefined'){ez_ad_units.push([[250,250],'electricalacademia_com-leader-1','ezslot_6',112,'0','0'])};__ez_fad_position('div-gpt-ad-electricalacademia_com-leader-1-0'); ${{k}_{tcf}}$, Temperature Correction Factor (%), ${{k}_{crt}}$, Capacity Rating Factor (%), ${{k}_{mdod}}$, Maximum depth of Discharge (%). 1) In our 20 MVA Substation, we are going to replace our 48 VDC Batteries (4-12 VDC batteries, 100AH into 2Volts, 200AH batteries (24pcs.). DoD is represented in percent (%) of total capacity of the battery. The number of strings must be an integer. Testing and Monitoring Methods for Stator Insulation Systems. The comment form collects your name, email and content to allow us keep track of the comments placed on the website. Procedia Manufacturing. Technological solutions aiming at recovering metro braking energy: a multi-criteria analysis case study. Spam Comments Will Be Deleted. Battery Bank Sizing Calculator Let's determine the size of the battery bank for your system. For this example well design the high voltage battery pack for a vehicle range of 250 km. Size: 1.3MB. If we divide it to the length of the WLTC driving cycle (23.266 km), we get an average energy consumption for the auxiliary loads Eaux of 9.241 Wh/km. For more accurate sizing, including using your location . "position": 2, Insert all figures in decimal, eg 2 or 1.5. Secondary Containment Calculation Worksheets. Our battery will have a minimum rating of 200Ah at an 8-hour rate, or C8. If it is based on RV mobile or boat etc., you will have to add and calculate the wattage rating of all the required appliances. Is Engineering Worth It? So lets take a look at a schematic diagram to better understand the magic of substation batteries. "name": "Battery Sizing Calculation | Solved Example" Its crucial the battery charger applies the appropriate voltage to a fully charged battery to prevent overcharging and avoid any potential damage. Calculate Size of Solar Panel, Battery Bank and Inverter (MS Excel Spreadsheet). All you need is your trusty load information. High temperature will shorten the battery life while cold temperature tends to reduce the overall capacity of the battery bank. " X H l! If the efficiency is lets say 80% (0.8), this means that you have to provision 20% extra energy in the battery. "url": "https://electricalacademia.com/category/batteries/", Generally speaking, with substations you want a short duration high dischargebattery. I was wondering if the 8 hour rate of discharge is discussed in IEEE standards as a typical rate to use in substations or this is just an industry practice? @ @ l! The volume of each cell is calculated as: where: Dbc [m] battery cell diameter Lbc [m] battery cell length, where: Hbc [m] battery cell height Wbc [m] battery cell width Tbc [m] battery cell thickness. How to find the total weight of the battery? The 125% multiplier accounts for this voltage drop to ensure the battery is not undersized. Please Whitelist Our Website by Allowing Ads, How to Calculate the Right Size Battery? hey could you give me the password to unprotect sheet, There is no password to open the XLS file. Losses in Wire,Connection,Battery. Download UPS Sizing Calculation Excel Sheet Power Requirements Every battery has a maximum charge and discharge capacity. Sizing battery banks for switchgear and control applications is commonly performed using software designed specifically for that purpose. LOAD CALCULATION: For more information, please contact Alpha technical service at 1-800-667-8743 or email sales@alpha.ca. All high voltage battery packs are made up from battery cells arranged in strings and modules. 301 Expected Total Load Operating Time per Day (hours) We also get your email address to automatically create an account for you in our website. Step 1 Your Energy Usage Watt-Hours/Day For Watt-Hours/Day, please use our kWh Calculator. No of Required Batteries (Parallel): 999 Ah / 100Ah =, The following calculator will do the above mentioned task by just putting the required values. First of we have to enter the Electrical Load Detail in Electrical Load Sheet .The following are input values we have to enter in the Columns :-. For automotive applications there are different types of cells used [1]: Image: Different shapes of Lithium-ion battery cellsCredit: [1]. The following schematic is similar to the previous one. They convert voltage from high to low and vice versa, keeping the lights on and the electricity flowing. How to Determine the Right Size Capacity of a Subpanel? Select your wattage, dc conversion and inverter efficiencies, then click Step 1. This volume is only used to estimate the final volume of the battery pack, since it does not take into account the auxiliary components/systems of the battery. It has 2 zones and each zone can equip maximum 25 detectors. This gives operators an 8-hour window to fix any AC power supply issues before things start going haywire. This step-by-step Solar Power Calculator offers a guideline for typical appliance ratings and sizing of solar systems. The battery with only 60% of its capacity at -18C (0 F) can be brought up to 85% to 90% capacity by burying it. These easy to follow worksheets use the MS Excel application and allow you to perform a cost/payback/profit analysis of a proposed system, an energy audit, and/or calculations to help you decide on an array size, modules and an inverter, wire gauges, etc. Add an optional factor of safety (20% or more) to determine the final battery-set size. %%EOF Battery Bank Sizing This calculator will help you size the battery bank for your system. This MS Excel spreadsheet calculates the following: Total Demand Load Size of Solar Panel Select Type of Connection of Solar Panel Select Rating of Each Solar Panel Energy from Solar Panel as per Daily Sun lights Size Battery Bank Select Type of connection of Batteries in Battery Bank Size of Inverter x@ @ l! The primary cell characteristics that should be considered are: Batterys Ampere-Hour capacities are provided by the battery manufacturer on the basis of various EODVs. and Excel sheets. Battery sizing and stand data sheet including all images automatically integrated End of confusing customers with multiple files: Output of offer as single ALL-IN-ONE-document containing everything (offer details, data sheets, charts, price lists, links, .) The voltage of each cell is 3.7 V and the total voltage of the battery pack 330 V. Image: Battery pack (modules and cells)Credit: Mitsubishi. How to Size a Single Phase and Three Phase Transformer in kVA? By doing so, youll never have to worry about dreaded downtimes, which could potentially cost you a fortune. (c) The End Cell Voltage (ECV) is considered as 1.85 V/cell in the battery (d) Battery is sized for maximum one (1) hour of duty as per specification 5. In Summer. The results of the equations (7) to (20) are summarised in the table below. Examples in Imperial & Metric System, How to Reduce Your Electric Power Bill? The battery circuit breaker sizing current=1.25charging current=1.25533A=666A. Additionally if you use any large battery manufacturer sizing programs, you will find that they as well utilize the end voltage to convert VA(W) to Amps. While noting, as the voltage drops on a DC system, the current drops as well (assuming a constant resistance). Therefore, the result of the calculation is rounded to the higher integer. You have masked that by adding all of your % increases but ultimately it will not be sized sufficiently for the full life cycle. { In order to have a better overview of the cells parameters and to compare them easier, the mainparameters are displayed as bar graphs in the images below. In short, you want ample backup power allowance for operators to restore AC power or make any necessary control decisions. If you are the owner or operator of a Spill Prevention, Control, and Countermeasure (SPCC) qualified facility, you need to ensure that you have adequate secondary containment to prevent oil spills from reaching navigable water. (b) Plante type Lead Acid station batteries are considered. The batteryparameters have a significant influence on other components and attributes of the vehicle, like: Pretty much all major aspects of a pure electric vehicle (EV) depend on the parameters of the highvoltage battery. x! Battery Depth of Discharge (DOD) Input Total. The total number of strings of the battery pack Nsb [-] is calculated by dividing the battery pack total energyEbp [Wh] to theenergy content of a string Ebs [Wh]. Battery Voltage. For our application we are going to consider a nominal voltage of 400 V. In the articleEV design energy consumption we have calculated the average energy consumption for propulsion Ep as being137.8 Wh/km on WLTC drive cycle. derating factor for lead acid designs in sizing calculations. 125% x 30.79 amps = 38.49 Amps. %PDF-1.5 % The string peak current Ispc [A] is the product between the peak C-rate of the battery cell C-ratebcp [h-1] and the battery cell capacity Cbc [Ah]. )Time to End (Mins)Capacity (Kt) vs Time to EndTD (Temperature Derating)Required Size (Kt *TD*Load)+-If A2 is greater than A1 proceed 1 kWh = 1000 Wh Step 2 Days Without Sunlight When you login first time using a Social Login button, we collect your account public profile information shared by Social Login provider, based on your privacy settings. Example and blank worksheets used to calculate secondary containment . The 125% youre referencing, accounts for the slack with the voltage drop. = 1.5 x 2 x 1.5. And 1.2 comes from 2-0.8. Batteries are the lifeline to substations, providing backup power. Because of the low capacity for the cylindrical cells, compared to the pouch cells, the number ofcells required for the battery pack is significant higher. Ill guide you through each step and highlight the key factors to keep in mind for all your different substation loads. x@ @ The type of elements contained within a battery and the chemical reactions during discharging-charging events define the chemistry of a battery. For this example we are going to focus only on Lithium-ion cells. { And inverter sizing consists of two parts, voltage and current sizing. that mentions how long the rate of discharge should be? The following step is the selection of the type of battery (e.g. The action you just performed triggered the security solution. Choose the required number of cells within these two limits (although choosing cell numbers in the middle of minimum and maximum values would be most suited). Did you manage to work it out? How to Determine the Number of Circuit Breakers in a Panelboard? Only enter data into the PALE ORANGE columns. This conversion is taking place with an associated loss. Unsuitable sizing of the battery can pose many serious problems such as permanent battery damage because of over-discharge, low voltages to the load, insufficient backup times. Keep in mind that, First of all, you will have to calculate the total amount of loads in watts which is needed to run directly or later on the storage energy in the batteries. This is the minimum battery bank capacity size you need to run a 900Wh load daily for 3 hours. Thanks I am always looking for excel sheets that make my job easier. If you know which batteries have been supplied, you can enter the battery size into the bottom box. "@id": "https://electricalacademia.com", If it is home based, you may easily get annual power usage data from the energy meter or electricity bill. To also point out, the VAs are not constant, as each device is based on a range of voltages. All the parameters, equations, results and plots are implemented in a Scilab (*.sce) file. If you are not OK with the manual calculations, you may use the battery bank size calculator right after the solved example for battery size calculations. "@type": "ListItem", The total number of cells of the battery pack Ncb [-] is calculated as the product between the number of stringsNsb [-] and the number of cells in a stringNcs [-]. Cloudflare Ray ID: 7a1638403ecb3f64 Get Free Android App | Download Electrical Technology App Now! The energy content of a string Ebs [Wh] is equal with the product between the number of battery cells connected in seriesNcs [-] and the energy of a battery cell Ebc [Wh]. We can now recalculate the battery pack total energy E bp [Wh] as the product between number of strings N sb [-] and the energy content of each string E bs [Wh]. Step 4: For each appliance, determine . Also, we have to consider the efficiency of the powertrain p[-] during the conversion from electrical energy to mechanical energy. If it is home based, you may easily get annual power usage data from the energy meter or, Keep in mind that if the number of days of autonomy increases, you will have to add more batteries, even more power sources like, This is the rating of DC voltage of the battery (generally, 12V, 24V, 36V, 48V, 72V etc). How to Find the Number of Outlets on a Single Circuit Breaker? Load (ampere): If the load type is ampere . The battery pack continuous current Ibpc [A] is the product between the string continuous current Iscc [A]and the number of strings of the battery pack Nsb [-]. You will get the number of batteries which need to be connected in parallel. This needs to be considered as well. The values on our Solar Sizing Worksheet assumes typical power output is based on 6 hours charging per day and will vary at different times of the year, by location, and with varying weather conditions. Over 100 Powerful Engineering Resume Buzzwords, Homeowners Guide For a Structural Engineer Inspection, 12 Essential Portable Generator Maintenance Tips. And if the AC power supply suddenly goes out, the battery will take over without skipping a beat. Power generated by the solar panels is used by the fridge etc with any surplus fed to the battery until the battery is 100% charged. In this particular example, we will apply the same loads and load curve provided in the Load Profile Calculation Example. He has been working in the engineering and tech industry in California for over 15 years now and is a licensed professional electrical engineer, and also has various entrepreneurial pursuits. Important Note: The main breaker trip coil and breaker close coil shouldnt both be included in the peak load calculation. In this example we are going to caclulate the volume of the battery pack considering only the battery cells. Image: Ragone diagram cell level adapted from Van Den Bossche 2009Credit: [2]. Other than storage purposes, batteries are extensively utilized in order to provide voltage support for weaker electric power systems such as very long transmission lines. But now, the battery charger feeds a 125V DC panel, which in turn powers allthe critical DC loads. Cable size calculator AS/NZS 3008; Maximum demand calculator AS/NZS 3000; Arc flash calculator IEEE 1584; Parameters. NiCd-KtBattery Sizing Calculation for Nickel Cadmium Battery (IEEE 1115) (Kt Capacity Factor, Based on 5 Hours AH)Lowest Electrolyte Temp0C32FEnd of Discharge Voltage1.10VPeriodPeriod No. @ @ l! Koosha started Engineer Calcs in 2020 to help people better understand the engineering and construction industry, and to discuss various science and engineering-related topics to make people think. Step by Step Procedure with Calculation & Diagrams. x@ @ h @ The battery pack continuous powerPbpc [W] is the product between battery pack continuous current Ibpc [A]and the battery pack voltage Ubp [V]. This is the amount of hours per day where we need to run the appliances on storage power batteries. The DoD (Depth of Discharge) is the charging and recharging (single) cycle of the battery i.e. The prolonged electrical loads(headlights, multimedia, etc.) To calculate the battery size for a varying load which requires I1 in the interval t1 and I2 in the remaining time: Estimate the average load current Iav = (I1 t1 / t) + (I2 [t - t1 / t]). All calculations are done automatically. Additionally, specify the battery discharge rate, also known as the C rating. Step 3: For each appliance listed, determine how many there are of that appliance (Quantity). In terms of mass and volume there is no clear distinction between cylindrical and pouch cells. Video - How to size solar system and battery size RENOGY are fast becoming the preferred source for solar panels, kits, batteries and solar control accessories. The Battery Sizing module determines the number of strings, number of cells, and cell size of a battery for a designated duty cycle and also compensates for real-life variables such as temperatures, aging, and initial capacity that apply to these type of critical electrical systems. 8 @ (@ @ ,@ @ " 8@ @ 8 @ 8@ @ @ @ @ @ 8@ @ ,@ @ ,@ @ ,@ @ Z x 8 @ 8 " @ @ Step 7 No of Required Batteries (Parallel): No of Required Batteries (Parallel): 999 Ah / 100Ah = 10 No of batteries. Daily Sunshine Hours. Battery life will shorten if the temperature goes too much higher. This is the rating of DC voltage of the battery (generally, 12V, 24V, 36V, 48V, 72V etc). "item": The battery acts as a backup power source if the AC power supply fails, so it must always be fully charged and ready to go. Can you please mention the source for all equations. i require it for an under graduate research project. The battery is always on standby, ready to power your system. Author: Shrikant Kajale. why does it have (2-n) in it? document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); Get daily articles and news delivered to your email inbox, 8 Fascinating Things About Rocket Structure Analysis, The Truth About Leaving a Legacy After Death, 7 Must Know Mechanical Engineering Design Tips. We can now recalculate the battery pack total energyEbp [Wh] as the product between number of stringsNsb [-] and the energy content of each stringEbs [Wh]. The following calculations are going to be performed for each cell type. To calculate the exact size of battery capacity, follow the following simple steps (Solved Example). "$"#,##0_);[Red]\("$"#,##0\)" "$"#,##0.00_);\("$"#,##0.00\)' " "$"#,##0.00_);[Red]\("$"#,##0.00\)7 * 2 _("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_). ) This website is using a security service to protect itself from online attacks. For single level charging max chargin voltage is typically 1.43-1.5V/cell. Design of solar panel/battery bank and inverter using this Excel Sheet. TV, Fridge, Lights, etc..). how can i view those as they are? },{ As for energy and capacity, the pouch type cells have higher peak (continuous) current and powerthan cylindrical cells. 10.6092/2284-4732/2929. The spreadsheet calculates cable size according to length, amperage, temper. Image: Battery pack total number of cells. For our electric vehicle battery design we are going to start from 4 core input parameters: A battery consists of one or more electrochemical cells (battery cells) which are converting chemical energy into electrical energy (during discharging) and electrical energy into chemical energy (during charging). Each module contains 4 prismatic cells. "position": 3, When youre connected to the AC power supply, the following two things happen: If you need an extra boost of power, the batterys got you covered. Follow, Copyright 2023, All Rights Reserved 2012-2023 by, Looks Like You're Using an Ad Blocker. But the protection loads are all powered by 48V DC. "item": Think about it, every critical component in a machine needs a backup plan, right? As you can see in the datasheet. The string continuous current Iscc [A] is the product between the continuous C-rate of the battery cell C-ratebcc[h-1] and the battery cell capacity Cbc [Ah]. If you are author or own the copyright of this book, please report to us by using this DMCA report form.