Search

Premium Membership ♕

Limited Time Offer: Save 15% on PRO Plan with discount code: LRN15 and study specialized LV/MV/HV technical articles and studies.

Home / Download Center / Electrical Software and MS Excel Spreadsheets (Calculations of cables, voltage drop etc.) / Calculate Size of Solar Panel, Battery Bank and Inverter (MS Excel Spreadsheet)
Calculate Size of Solar Panel, Battery Bank and Inverter (MS Excel Spreadsheet)
Calculate Size of Solar Panel, Battery Bank and Inverter (MS Excel Spreadsheet)

Design of solar panel / battery bank and inverter

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 New
Developer:Jignesh Parmar
Size:59.5 Kb
Price:Free
Download:Right here | Video Courses | Membership | Download Updates
MS Excel Spreadsheet // Calculate Size of Solar Panel, Battery Bank and Inverter
MS Excel Spreadsheet // Calculate Size of Solar Panel, Battery Bank and Inverter

Premium Membership

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.
50% Discount 💥 - Save 50% on all 90+ video courses with Enterprise Membership plan.

More Information

107 Comments


  1. yahya
    Nov 08, 2023

    thank you


  2. Adetola Erejuwa
    Sep 20, 2023

    please I need fl pdf book on calculation of solar panel, battery capacity calculation, inverter calculation,number of panels wire size


  3. KUMAR PK
    Sep 17, 2023

    hello sir
    im looking a software calculating size of battery banak and solar panel with unit consumptions .


  4. Salifu Nurideen
    Aug 30, 2023

    Software to calculate panal, battery and hour


  5. Vilas Nargund
    May 31, 2023

    I am looking for MS excel spreadsheet for calculating solar panel & inverter size software.
    One available is “Read only”
    Kindly do the needful


    • Laurie Poe
      Aug 14, 2023

      Did you ever find a calculator?


    • Kuda
      Aug 28, 2023

      I can do a customized version for your if you give me exactly what you are looking for


    • Jonathan Ebhota
      Oct 11, 2023

      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


  6. Vilas Nargund
    May 28, 2023

    I am looking for software to calculate number of the solar panels & size of the inverter


    • Stefano Comuzzi
      Jan 11, 2024

      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


  7. Derek Marshall
    Oct 13, 2022

    Google sheets access would be better.


  8. Moinuddin Ikramuddin
    Oct 09, 2022

    i need access to calculation guide


  9. Kingsley
    Aug 11, 2022

    I want to understand more about solar power


  10. Mr. Isaac Umezurike
    Jul 29, 2022

    I need soft to be used for sizing inverter, panel and battery.


  11. Mohamed Sidow
    Jul 17, 2022

    Are Excel sheet passwords available for premium members
    They are locked
    Thanks in advance


  12. Assaad abdul ahad
    Jul 11, 2022

    Dears,
    please i need the passwords for excel sheets.

    Thanks.


    • [email protected]
      Jul 18, 2022

      I’m a premium member, I need the Excel Password. Thanks


      • Edvard
        Jul 19, 2022

        None of the spreadsheets in this section were developed by EEP. We do not have password or any of files here.


        • SimonK
          Nov 08, 2023

          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.


  13. Nirmal musale
    Jul 05, 2022

    hello, i need password for excel sheet please provide the password to me…Thankyou


  14. Mussaui H
    Jun 14, 2022

    Have a nice day.
    Please, if You can, I need password to download the sheet


  15. Andres Loriente
    May 10, 2022

    PV energy is future way of obtain cover demand of electrical power needs.


  16. Bishal Bhasima
    Apr 29, 2022

    Please provide the password. And thank you for sharing the file.


  17. Matthew Matimbwi
    Apr 12, 2022

    It is a great work.

    It has helped to improve the quality of my work.


  18. Sharad Tayshetye
    Apr 07, 2022

    I want to understand more on solar


  19. Richard S
    Mar 23, 2022

    Is it possible to get the password? Need to make changes but overall great worksheet


  20. Parantap K Raha
    Mar 22, 2022

    The Excel sheet… indeed Great Work


  21. Muawia
    Mar 10, 2022

    I can not down load the sheet
    Please.


  22. Salah Sallam
    Jan 12, 2022

    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


  23. Elias H. Helou
    Dec 10, 2021

    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


  24. the sheet is good for me
    Nov 16, 2021

    The excel sheet is goo for me


  25. alaaddin sarac
    Oct 28, 2021

    thank you


  26. Hennie van Niekerk
    Oct 01, 2021

    Hopefully this is not a hoax.


  27. Bernard Magangi
    Sep 17, 2021

    I need password for the excel sheet please.
    Thank you


  28. Sridhar
    Aug 17, 2021

    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.


  29. Dixon Abincha
    Jul 17, 2021

    I need the solar off grid sizing software


  30. martins
    Jul 13, 2021

    please add comments to the variable cells and send us the password


  31. Mezo Kevin
    Jul 13, 2021

    Would like the password to unlock the cells please


  32. Biosio Oboho
    Jul 07, 2021

    It looks promising, but I would need the password to unlock the cells
    .


  33. Sylvanus Ihuefo
    May 06, 2021

    This looks good and promises to be of help to me. How can I get the password for the locked cells


  34. Paulo Maitano
    Feb 28, 2021

    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


  35. Ade
    Feb 17, 2021

    i humbly request for the password please


  36. Gibson
    Feb 11, 2021

    Anyway we get password please


  37. simione bituwaqa
    Feb 02, 2021

    Can i used this software…really helpful to me.


  38. olusegun adepoju
    Jan 07, 2021

    Please i need help with password to unlock the protected cells


  39. azadeh sh
    Jul 25, 2020

    can i ask password?
    best regards.


  40. Shame Mutefura
    Jul 05, 2020

    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.


  41. Craig Schultz
    Jun 28, 2020

    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?


  42. Rajesh Madnani
    May 27, 2020

    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


  43. SAIBA;L CHAKRABORTY
    Apr 23, 2020

    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)


    • ASHOK TOSHNIWAL
      May 15, 2020

      Dear Saibal

      As per my calculation & estimate you will require approx. 360 V 1100 Ah battery. We can provide. Please contact offline.


    • Valeriano Pedro
      Jul 18, 2020

      Dear SAIBA:
      Did U get an answer to your 2 requests?
      Vp
      +258 82 604 5012


  44. satyanarayan
    Apr 16, 2020

    Consolidated Total Energy ( WH /day) – 28184

    1- Battery Qty. =
    2-Solar penal Qty. =
    3-PCU Kwp. =


  45. Dhan Diolanto
    Mar 17, 2020

    Can I ask for password?


  46. shylock
    Jan 13, 2020

    can i have the password


  47. TOWETT
    Aug 12, 2019

    Kindly assist I can’t edit as it is saying protected and need password.


  48. Farid Mominzadah
    Jan 16, 2019

    I am searching for Protection system also solar.


  49. Dang Hoang Anh
    Sep 30, 2018

    I need software to calculate the solar system!
    Thanhks! Best regards!


  50. Zaheer
    Apr 18, 2018

    sir; I’m unable to understand MS (Excel Spreadsheet // Calculate Size of Solar Panel, Battery Bank and Inverter) please guide me


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


    • Gaston
      Apr 22, 2019

      Disregard the KW the size of the inverter is in watts


      • Kings
        Mar 09, 2020

        Really, I thought inverters are in KVA


    • Evariste.N
      Aug 19, 2019

      For sure, this is an error. guess it must be in Wattage.


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

    Please kindly support.


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


  54. herry
    Apr 19, 2016

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


  55. herry
    Apr 19, 2016

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


  56. Parveen Kumar
    Apr 01, 2016

    i can’t download this…plz help me…


    • DHARMARAJ
      Aug 06, 2019

      send your mail ID, will send


  57. Adem Ay
    Mar 26, 2016

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


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


  59. kamel shahpo
    Feb 01, 2016

    excellent work


  60. Cosmas Byela
    Oct 27, 2015

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


  61. 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 : [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


  62. Albert Allotey
    Jul 06, 2015

    Hi i cant download the excel sheet. link takes me to https://app.box.com/s/jgvhc07ssbap7x6udgwq and there’s nothing there. please help


  63. mayank tanwar
    Jun 13, 2015

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


  64. Sergio B. Diasana
    Mar 09, 2015

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


  65. Sergio B. Diasana
    Mar 09, 2015

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


  66. oladayo
    Jan 22, 2015

    i like this site


  67. Steven | PSE Battery warehouse
    Nov 27, 2014

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


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

        please help


  69. abaho emma
    Oct 12, 2014

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


  70. Pranav
    Sep 23, 2014

    useful calculator…should include DC load option…


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


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

    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


  73. Ivan Mugabi
    Apr 22, 2014

    Interested in solar calculator


  74. Ebenezer Koranteng
    Nov 18, 2013

    I am yet to try your calculator.
    Thanks!


  75. Faruque Ahmad
    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….


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


  77. prashantrider
    Jul 17, 2013

    it goes on this link https://www.box.com/s/jgvhc07ssbap7x6udgwq
    the link doesnt work so cant download, ????


    • Edvard
      Jul 17, 2013

      You will see ‘Download’ button on top-right.


  78. prashantrider
    Jul 17, 2013

    cant download ??


  79. sajancq
    May 03, 2013

    Very useful, Thank’s


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


  81. gsrsharma
    Dec 13, 2012

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


  82. etradz
    Nov 18, 2012

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


  83. veerugvs
    May 03, 2012

    Really excellent job u r doing for the electrical engineers


  84. Mostafa Sharifi
    Apr 04, 2012

    Thanks alot


  85. sephirothn
    Mar 26, 2012

    Very useful, Thank’s


  86. zeeshan541
    Feb 05, 2012

    can tell u after using the tool


  87. projects416
    Jun 29, 2011

    Great Work! Thanks a lot


    • Edvard
      Jun 29, 2011

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


      • Ager Terungwa
        Aug 30, 2019

        Please help with password to unlock the protected cells

Leave a Reply to bath

Tell us what you're thinking. We care about your opinion! Please keep in mind that comments are moderated and rel="nofollow" is in use. So, please do not use a spammy keyword or a domain as your name, or it will be deleted. Let's have a professional and meaningful conversation instead. Thanks for dropping by!

40  ⁄    =  four

Learn How to Design Power Systems

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Enjoy learning!

Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).
EEP Academy Courses - A hand crafted cutting-edge electrical engineering knowledge