Design of solar panel / battery bank and inverter
Important Steps for Load Analysis
The load is calculated by enumerating all appliances together with their power ratings and operational hours, thereafter adding these values to derive the total average energy demand in watt-hours or kilowatt-hours. It is preferable to enumerate both AC and DC loads individually, as inverter sizing is necessary solely for AC requirements. Utilize inverter efficiency to calculate the DC energy need for AC loads.
Modify for direct current and alternating current loads by utilizing an adjustment factor. This results in the ‘Adjusted Watts‘. The ‘Average Daily Load‘ is calculated by multiplying the Adjusted Watts by the daily usage hours.
Factors Affecting Battery Sizing
Batteries for autonomous systems are dimensioned to store energy generated by the array for utilization by the system loads as needed. The overall rated battery capacity required is dependent upon the following factors:
- The number of storage days needed to fulfill system loads without a PV recharge
- Maximum permissible depth of discharge
- Thermal conditions and flow rates
- System inefficiencies and losses
- The system voltage determines the quantity of series-connected battery cells necessary.
- The overall capacity required determines the quantity of parallel battery strings necessary.
Duration of Storage or Autonomy (in days)
Autonomy refers to the duration, in days, that a fully charged battery can sustain system loads without recharging from the photovoltaic array. Extended autonomy periods are employed for more essential applications, enhancing system availability, albeit at a higher cost due to the necessity of a larger battery.
Batteries must fulfill both the power and energy demands of the system. The minimum autonomy should generally be maintained at three days for standard loads. For important loads, autonomy should exceed three days, depending upon the specific weather circumstances of the region.
Parameters Influencing Battery Sizing
The designated autonomy and maximum permissible depth of discharge (DOD) determine the overall battery capacity necessary for a specific system load. Extended periods of autonomy increase battery capacity, enhance availability, and reduce average daily depth of discharge.
A higher permissible depth of discharge enhances system availability, although to the detriment of battery health. The rated capacity of a battery is influenced by temperature, discharge rate, and the battery’s age.
MS Excel spreadsheet
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
| Software: | MS Excel Spreadsheet // Calculate Size of Solar Panel, Battery Bank and Inverter |
| Version: | 22.8.2012  |
| Developer: | Jignesh Parmar |
| Size: | 59.5 Kb |
| Price: | Free |
| Download: | Right here | Video Courses | Membership | Download Updates |
Very good and educative topic. need the software
Am impressive and self explained Software
thank you
please I need fl pdf book on calculation of solar panel, battery capacity calculation, inverter calculation,number of panels wire size
hello sir
im looking a software calculating size of battery banak and solar panel with unit consumptions .
Software to calculate panal, battery and hour
I am looking for MS excel spreadsheet for calculating solar panel & inverter size software.
One available is “Read only”
Kindly do the needful
Did you ever find a calculator?
I can do a customized version for your if you give me exactly what you are looking for
I have a load of 26.57kwh. I need 6,hour of backup. My peak sun hours are 5.45. how much battery bank and PV panels do I need to run it for 6hours
I am looking for software to calculate number of the solar panels & size of the inverter
Hi Vilas,
I can suggest you a good one called “SOLERGO” by Electrographics (available in english, italian and portuguese).
I have been usin it from many years (example an 11 MW installation in Manzano Solar Park (Udine – north east Italy)
https://www.electrographics.it/en/products/solergo.php
Google sheets access would be better.
i need access to calculation guide
I want to understand more about solar power
I need soft to be used for sizing inverter, panel and battery.
Are Excel sheet passwords available for premium members
They are locked
Thanks in advance
Dears,
please i need the passwords for excel sheets.
Thanks.
I’m a premium member, I need the Excel Password. Thanks
None of the spreadsheets in this section were developed by EEP. We do not have password or any of files here.
Hi Edvard,
I just downloaded the spreadsheet. There appears to be errors in the spreadsheet but can not check as the formulas have been hidden. As a paying member of EEP, it is a little disappointing that the spreadsheet appears to be published on your website without anyone validating it is correct and secondly that the spreadsheet is locked so no-one can see the formulas used.
hello, i need password for excel sheet please provide the password to me…Thankyou
Have a nice day.
Please, if You can, I need password to download the sheet
PV energy is future way of obtain cover demand of electrical power needs.
Please provide the password. And thank you for sharing the file.
It is a great work.
It has helped to improve the quality of my work.
I want to understand more on solar
Is it possible to get the password? Need to make changes but overall great worksheet
The Excel sheet… indeed Great Work
I can not down load the sheet
Please.
I think that there are some factors that must be included in the calculations, such as the solar radiation coefficient according to the installation location, the characteristics of the voltage and current of the solar panels, the Types of batteries, the type of base of the panels (moving / fixed ), Due to the protecting of cells that specified for choosing the type of panels connection, I was not able to know the existence of parallel-parallel connection options .But in genral This paper is useful, and thanks for the efforts made in preparing it
its really amazing way to calculate that but please if u can send me the password so i can open the excel sheet ?
Thank u
The excel sheet is goo for me
thank you
Hopefully this is not a hoax.
I need password for the excel sheet please.
Thank you
Hi
i need help to understand the PV Sizing capacity to be built.
The requirement is for rural electrical project, for 185 houses 15w each with an autonomy of 2 days. The radiation is 4.93. The PV module is 340WP, Battery is 12V, 200AH.
Can you please help in calculating PV Sizing, Battery sizing and Invertor sizing.
please email me your details at [email protected]
I need the solar off grid sizing software
please add comments to the variable cells and send us the password
Would like the password to unlock the cells please
It looks promising, but I would need the password to unlock the cells
.
This looks good and promises to be of help to me. How can I get the password for the locked cells
I have 247 watts solar panels I would like to the size of the battery 🔋 to use in a freezer, TV, 8 balbs and charging phones
i humbly request for the password please
Anyway we get password please
Can i used this software…really helpful to me.
Please i need help with password to unlock the protected cells
can i ask password?
best regards.
This is great work,since it helps on designing an off grid system with a battery bank i thought it should also include the charge controller section.Most PV system builders struggle a lot when it comes to choosing the correct charge controller which works perfect for the system being built.
I don’t see that the calculation for battery bank size is related to the solar array? Shouldn’t the size of the battery bank reflect how much energy is collected by the solar array daily?
We need to understand the operation of solar panel calculation . Also requesting you to provide us the password
Your quick support will help us for proper configuration of Inverter Solar Systems
Thanks
Q1) Down loaded sheet, but asks for password. Can You please share the password?
Q2) Need to size batteries for a 50 KVA Hybrid Inverter / 360 VDC. Daily average load is 35 KW (AC Loads) for 8 hrs running per day (factory). Backup required for 6 hrs. during grid fail. Inverter efficiency 80%. Required EXIDE SOLAR BATTERIES.
please help with password and for (Q2)
Dear Saibal
As per my calculation & estimate you will require approx. 360 V 1100 Ah battery. We can provide. Please contact offline.
Dear SAIBA:
Did U get an answer to your 2 requests?
Vp
+258 82 604 5012
Consolidated Total Energy ( WH /day) – 28184
1- Battery Qty. =
2-Solar penal Qty. =
3-PCU Kwp. =
Can I ask for password?
can i have the password
Kindly assist I can’t edit as it is saying protected and need password.
I am searching for Protection system also solar.
I need software to calculate the solar system!
Thanhks! Best regards!
sir; I’m unable to understand MS (Excel Spreadsheet // Calculate Size of Solar Panel, Battery Bank and Inverter) please guide me
This tool is of immense help Thank you for your effort. Could there be a mistake in the sizing of the inverter The calculation is given in kw thereby making the inverter very large. Can you please comment on this. Thank you.
Disregard the KW the size of the inverter is in watts
Really, I thought inverters are in KVA
For sure, this is an error. guess it must be in Wattage.
I have seen the excel sheet, you have prepared for design of solar panel, inverter and battery bank and it is awesome.
Here, my application is little different on solar water heater.
I want to maintain the 70 C temperature of 50 liters (approx) water using 500 W DC heater for 24×7.
I want to size the solar panel, battery bank, solar charge controller.
Please kindly support.
Excellent initiative and great work by Jignesh Parmar.
Can I have your contact nos, as i have to discuss a project where I find the no of batteries and Panels required is very large.
Hi Sir can you plz provide the calculation formulas for this excel.
Hi Sir can you please provide the calculation formulas of this excel.
i can’t download this…plz help me…
send your mail ID, will send
i glad to you, its very useful, i will try it as soon as
In considering a stand alone system where the battery is supplying all of the energy as the sun goes down; then consider solar PV as the recharger. It need to be addressed in the order Load + losses => Battery; then charger & PV solar; then consider days without sunlight and multiply accordingly.
The issues are further complicated by considering the battery banks maximum charge current.
Do that with lead acid and it gets truly massive!
excellent work
Hi! I cant downlod the sheet link for calculator sixe of Solar pannel, Battery bank and Inverter.
Please help me.
Cosmas
Hi ,
Nice work still few things I would like to explain .
Consider the power factor of Not only UPS but also for batteries .example.
1000 va output will be 700 watts
700 watts/.85 = x ▶ invt eff.
X/.65= Y▶ batt. Eff.
Y/Vdc = Z ▶ vdc is no. Of batteries x volt of battery.ex 12 volt x 3 battery= 36 vdc
So Z x (Backup time needed ) say 3 hrs
So for example it comes 15
Multiply by 3 hrs
So backup is 45 Ah
HENCE , 3 BATTERIES ARE NEEDED FOR A 700 WATT LOAD ON A 3 BATTERY SYSTEM (36 VDC) for 3 hrs backup.
Mail me at : [email protected]
http://www.elnova.com
,
Nice work still few things I would like to explain .
Consider the power factor of Not only UPS but also for batteries .example.
1000 va output will be 700 watts
700 watts/.85 = x ▶ invt eff.
X/.65= Y▶ batt. Eff.
Y/Vdc = Z ▶ vdc is no. Of batteries x volt of battery.ex 12 volt x 3 battery= 36 vdc
So Z x (Backup time needed ) say 3 hrs
So for example it comes 15
Multiply by 3 hrs
So backup is 45 Ah
HENCE , 3 BATTERIES ARE NEEDED FOR A 700 WATT LOAD ON A 3 BATTERY SYSTEM (36 VDC) for 3 hrs backup.
Mail me at : [email protected]
http://www.elnova.com
Hi i cant download the excel sheet. link takes me to https://app.box.com/s/jgvhc07ssbap7x6udgwq and there’s nothing there. please help
To calculate the size and power backup solution Batterybhai.com provides Power Calculator.
solar technology is the the best power savings at our time.
It is a very good site, to enhance our expertise and ability and be more professional.
i like this site
Nice spreadsheet. This will definitely come in handy when calculating the size of your battery bank.
Hi,
I observed that a corresponding increase in the battery backup time (autonomy) doesn’t affect the sizing of the solar arrays. In essence, a 24kW solar power (200W by 48V panels) is not affected despite increasing the number of days of backup power. The number of batteries increase but not the panels. I was expecting the solar panel side to flag an error but it remained green (ok) despite varying days of backup. Increase in batteries should automatically result into more panels to ensure batteries are adequately charged.
Can you comment on my observation please?
Regards,
Tunji
Very true, there’s no way you can add the batteries to cater for the days of autonomy and you fail to add solar panels. If only you add batteries, the system will not be getting enough charges therefore it is a must for solar panels to be added to the system.
dear sir,
I am new in this field, and i want to learn how this calculator works for calculating the load. when i am using it, it ask for the password. i am having some knowlege of it but wish to know the way that how to calculate the size of solar panel, battery and inverter.
please help
thank you for your lessons and your calculations. i know how size now
useful calculator…should include DC load option…
dear
this tool design on AC load but i need a tool that design for DC load.
or any one can tell me that relation between DC and AC load.
how i convert 1500W DC load to AC load to use this design tool
DC….?…=AC…?…
Hello Everyone and Technical members,
I have a project of Installing Solar Power System on a Terris of a building having an area of 3000 sq ft. It is a 10 storey building having three flats/apartments on each floor with each flat/apartment has a load of 18420 watt hours or 18.42 kWh.
It’s my project so I am facing problem to calculate what types of panels I should use to produce that much voltage by panels with installing batteries..
Please help with this with the appropriate solar panel strategy or planning.
You can also email me for further details if you want for this purpose.
Thank you
Interested in solar calculator
I am yet to try your calculator.
Thanks!
Great tool!
I tried to use this calculator for sizing solar panels in hybrid system for micro GSM BTS, but size of invertor is too big for total load of 500 W. For total load of 500 W with operational time 24 h per day, calculator gives size of invertor about 555 KW. I do not understand why. I guess there is mistake in cell which shows KW.
Regards,
I think there is some mistake….
This is the great site for EE in the web i have ever seen! Thanks to all the developers for sharing their great works.
it goes on this link https://www.box.com/s/jgvhc07ssbap7x6udgwq
the link doesnt work so cant download, ????
You will see ‘Download’ button on top-right.
cant download ??
Very useful, Thank’s
Great tool!
I tried to use this calculator for sizing solar panels in hybrid system for micro GSM BTS, but size of invertor is too big for total load of 500 W. For total load of 500 W with operational time 24 h per day, calculator gives size of invertor about 555 KW. I do not understand why. I guess there is mistake in cell which shows KW.
Regards!
Azra
it’s free tool but password protected !!!! … delicious food but in the showcase !!!
Fabulous work.. This surely is a time saver..
Regards
Nick
Really excellent job u r doing for the electrical engineers
Thanks alot
Very useful, Thank’s
can tell u after using the tool
Great Work! Thanks a lot
You’re welcome! All credits goes to mr. Jignesh Parmar!
Please help with password to unlock the protected cells