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
Price:Free
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).

31 Comments


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


  2. mayank tanwar
    Jun 13, 2015

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


  3. Sergio B. Diasana
    Mar 09, 2015

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


  4. Sergio B. Diasana
    Mar 09, 2015

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


  5. oladayo
    Jan 22, 2015

    i like this site

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


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


  8. abaho emma
    Oct 12, 2014

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


  9. Pranav
    Sep 23, 2014

    useful calculator…should include DC load option…


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


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


  12. Ivan Mugabi
    Apr 22, 2014

    Interested in solar calculator


  13. Ebenezer Koranteng
    Nov 18, 2013

    I am yet to try your calculator.
    Thanks!


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


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


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


  17. prashantrider
    Jul 17, 2013

    cant download ??


  18. sajancq
    May 03, 2013

    Very useful, Thank’s


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


  20. gsrsharma
    Dec 13, 2012

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


  21. etradz
    Nov 18, 2012

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


  22. veerugvs
    May 03, 2012

    Really excellent job u r doing for the electrical engineers


  23. Mostafa Sharifi
    Apr 04, 2012

    Thanks alot


  24. sephirothn
    Mar 26, 2012

    Very useful, Thank’s


  25. zeeshan541
    Feb 05, 2012

    can tell u after using the tool


  26. projects416
    Jun 29, 2011

    Great Work! Thanks a lot


    • Edvard
      Jun 29, 2011

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

  27. […] requirement.This tool is developed by mr. Jignesh Parmar, and available for FREE download:Download: Right Here Tags: batteries, battery, calculate, download, energy, solar, solar panel Category: News, Solar […]

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!

× six = thirty

CONNECT //