# Calculate Size of Solar Panel, Battery Bank and Inverter

Home / Download Center / Electrical Software / Calculate Size of Solar Panel, Battery Bank and Inverter

## Design of solar panel / battery bank and inverter

This MS Excel spreadsheet calculates the following:

• 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 | Get Download Updates | Get Technical articles

### SEARCH: Articles, software & guides

1. Foluso Omolewa
Jun 08, 2016

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.

2. Nirav
Jun 08, 2016

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.

Jun 05, 2016

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.

4. herry
Apr 19, 2016

Hi Sir can you plz provide the calculation formulas for this excel.

5. herry
Apr 19, 2016

Hi Sir can you please provide the calculation formulas of this excel.

6. Parveen Kumar
Apr 01, 2016

Mar 26, 2016

i glad to you, its very useful, i will try it as soon as

8. Edward Gilmour
Mar 26, 2016

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!

9. kamel shahpo
Feb 01, 2016

excellent work

10. Cosmas Byela
Oct 27, 2015

Hi! I cant downlod the sheet link for calculator sixe of Solar pannel, Battery bank and Inverter.
Cosmas

11. Amit
Aug 27, 2015

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 : amit@elnova.com
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 : amit@elnova.com
http://www.elnova.com

12. Albert Allotey
Jul 06, 2015

13. mayank tanwar
Jun 13, 2015

To calculate the size and power backup solution Batterybhai.com provides Power Calculator.

14. Sergio B. Diasana
Mar 09, 2015

solar technology is the the best power savings at our time.

15. Sergio B. Diasana
Mar 09, 2015

It is a very good site, to enhance our expertise and ability and be more professional.

Jan 22, 2015

i like this site

17. Nice spreadsheet. This will definitely come in handy when calculating the size of your battery bank.

18. Tunji Iromini
Nov 14, 2014

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

• solar magics firm
May 30, 2015

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.

• Ajay Prakash Singh
Feb 07, 2016

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.

19. abaho emma
Oct 12, 2014

thank you for your lessons and your calculations. i know how size now

20. Pranav
Sep 23, 2014

useful calculator…should include DC load option…

21. Ata Ur Rahman
Sep 01, 2014

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…?…

22. Taif
Aug 06, 2014

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..

You can also email me for further details if you want for this purpose.

Thank you

23. Ivan Mugabi
Apr 22, 2014

Interested in solar calculator

24. Ebenezer Koranteng
Nov 18, 2013

I am yet to try your calculator.
Thanks!

Sep 18, 2013

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,

• Femnas
Apr 22, 2014

I think there is some mistake….

26. bath
Aug 11, 2013

This is the great site for EE in the web i have ever seen! Thanks to all the developers for sharing their great works.

27. prashantrider
Jul 17, 2013

it goes on this link https://www.box.com/s/jgvhc07ssbap7x6udgwq

• Edvard
Jul 17, 2013

28. prashantrider
Jul 17, 2013

29. sajancq
May 03, 2013

Very useful, Thank’s

30. Azra
Mar 23, 2013

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

31. gsrsharma
Dec 13, 2012

it’s free tool but password protected !!!! … delicious food but in the showcase !!!

Nov 18, 2012

Fabulous work.. This surely is a time saver..
Regards
Nick

33. veerugvs
May 03, 2012

Really excellent job u r doing for the electrical engineers

34. Mostafa Sharifi
Apr 04, 2012

Thanks alot

35. sephirothn
Mar 26, 2012

Very useful, Thank’s

36. zeeshan541
Feb 05, 2012

can tell u after using the tool

37. projects416
Jun 29, 2011

Great Work! Thanks a lot

• Edvard
Jun 29, 2011

You’re welcome! All credits goes to mr. Jignesh Parmar!