Electronics Lab

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]



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]

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 3 years 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!