Design of solar panel / battery bank and inverter

This MS Excel spreadsheet has possibilities to calculate following:

  • Calculate Total Demand Load
  • Calculate Size of Solar Panel
  • Select Type of Connection of Solar Panel
  • Select Rating of Each Solar Panel
  • Calculate Energy from Solar Panel as per Daily Sun lights
  • Calculate Size Battery Bank
  • Select Type of connection of Batteries in Battery Bank
  • Calculate size of Inverter
Software:Calculate Size of Solar Panel, Battery Bank and Inverter
Version:22.8.2012 New
Developer:Jignesh Parmar
Size:59.5 Kb
Download:Right here | Get Download Updates | Get Technical articles

Calculate Size of Solar Panel, Battery Bank and Inverter

Recommended EE articles

Weekly Download Updates

Get EEP's updates without having to keep checking up on the portal to see if there is anything new.

Page edited by E.C. (Google).


  1. abaho emma
    Oct 12, 2014

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

  2. Pranav
    Sep 23, 2014

    useful calculator…should include DC load option…

  3. Ata Ur Rahman
    Sep 01, 2014

    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


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

  5. Ivan Mugabi
    Apr 22, 2014

    Interested in solar calculator

  6. Ebenezer Koranteng
    Nov 18, 2013

    I am yet to try your calculator.

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

    • Femnas
      Apr 22, 2014

      I think there is some mistake….

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

  9. prashantrider
    Jul 17, 2013

    it goes on this link
    the link doesnt work so cant download, ????

    • Edvard
      Jul 17, 2013

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

  10. prashantrider
    Jul 17, 2013

    cant download ??

Leave a Comment

Tell us what you're thinking... we care about your opinion!
and oh, not to forget - if you want a picture to show with your comment, go get a free Gravatar!

seven + = 15


Subscribe to Weekly Download Updates: (free electrical software, spreadsheets and EE guides)


EEP's Android Application
Electrical Engineering Daily Dose
Daily dose of knowledge and news from
Electrical Engineering World