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

Weekly Download Updates //

Once per week, we are releasing download update in following sections: MS Excel calculation spreadsheets, electrical software and guides and various engineering books.

Be first to get this download update!

Subscribe Now!

Page edited by E.C. (Google).


  1. Sergio B. Diasana
    Mar 09, 2015

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

  2. Sergio B. Diasana
    Mar 09, 2015

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

  3. oladayo
    Jan 22, 2015

    i like this site

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

  5. Tunji Iromini
    Nov 14, 2014


    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?


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!

2 − = zero

Electrical Engineering Daily Dose
Daily dose of knowledge and news from
Electrical Engineering World

Support our work //

Feel free to donate and support our work and contribution to the #EE society.