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 using this Excel Sheet.

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

Calculate Size of Solar Panel, Battery Bank and Inverter (MS Excel Spreadsheet) – [XLS]

Please follow and like us:
Pin Share
About mixos

Mike is the founder and editor of Electronics-Lab.com, an electronics engineering community/news and project sharing platform. He studied Electronics and Physics and enjoys everything that has moving electrons and fun. His interests lying on solar cells, microcontrollers and switchmode power supplies. Feel free to reach him for feedback, random tips or just to say hello :-)

view all posts by admin
Subscribe
Notify of
guest

11 Comments
Inline Feedbacks
View all comments
Cyprian

please share download link for your solar pv design software. i require it for an under graduate research project. thanks

Matthew Foster

hi mike,

how have you implemented battery depth of discharge and solar efficiency. I am designing a similar project for school and cant get my head around how to implement these formulas using excel solver?

any help would be greatly appreciated

syed yasir

hey could you give me the password to unprotect sheet

San San

We can’t add any load data 🙁

San San

Hello We need a passport to add some load data. Could you provide it?

Last edited 1 year ago by San San
Jay

This sheet is gold. Thanks I am always looking for excel sheets that make my job easier.

Adnan Ahmad

Dear Author,

I dont see a link to download the file. Could you please provide it? Highly appreciated!

Get new posts by email:
Get new posts by email:

Join 97,426 other subscribers

Archives