Tuesday, January 29, 2019

Design of Solar Panel Excel Spreadsheet





What is solar PV system?
Solar photovoltaic system or Solar power system is one of renewable energy system which uses PV modules to convert sunlight into electricity. The electricity generated can be either stored or used directly, fed back into grid line or combined with one or more other electricity generators or more renewable energy source. Solar PV system is very reliable and clean source of electricity that can suit a wide range of applications such as residence, industry, agriculture, livestock, etc.

Major system components :-
Solar PV system includes different components that should be selected according to your system type, site location and applications. The major components for solar PV system are solar charge controller, inverter, battery bank, auxiliary energy sources and loads (appliances).

  1. PV module converts sunlight into DC electricity.
  2. Solar charge controller  regulates the voltage and current coming from the PV panels going to battery and prevents battery overcharging and prolongs the battery life.
  3. Inverter  converts DC output of PV panels or wind turbine into a clean AC current for AC appliances or fed back into grid line.
  4. Battery  stores energy for supplying to electrical appliances when there is a demand.
  5. Load  is electrical appliances that connected to solar PV system such as lights, radio, TV, computer, refrigerator, etc.
  6.  Auxiliary energy sources - is diesel generator or other renewable energy sources.



File Size: 98 Kb

Download Design of Solar Panel / Battery Bank / Invertor Excel SpredSheet For Free
With These Excel Calculator we can calculate the Following Parameter 
1. Solar Panel Details
2. Battery Bank Details
3. Solar Panel
4. Battery Bank
5. Size of Invertor

First of we have to enter the  Electrical Load Detail in Electrical Load Sheet .The following are input values we have to enter in the Columns :-
  • Solar System Voltage
  • Losses in Wire,Connection,Battery
  • Daily Sunshine Hours
  • In Winter
  • In Summer
  • In Monsoon
  • Average Daily Sunshine Hours  
  • Total Solar Power need 
  • Total Solar Power after Correction Factor
  • Solar Array Size after Calculating Sun Hour
  • Select Size of Solar Panel .                    ______Watts / _______Volts 
  • Solar Panel Connection .    Series/Parallel/Series-Parallel.
Output :-
  • Type of Connection For Solar Panel -----
  • Selection of Solar Panel Connection:                  Ok or Not Ok
  • Selection of Each Solar Panel Voltage                Ok or Not Ok
  • Number of String for Solar Panel
  • Total Watt of Each Solar Panel String
  • Total No of Solar Panel in Each String
  • Total Watts of Solar Panel
  • Total Nos of Solar Panels

Input Details we have to enter about about Battery Bank :-

  • Battery Bank's Voltage
  • Reaserve Day: (How many days of capacity you want your batteries to Give you Current)
  • Loose Connection/Wire Loss Factor:
  • Battery Efficiency
  • Battery Aging:
  • Depth of Discharge:(DOD)
  • Battery Operating Temp:
  • The Battery Bank Required:
  • Enter Each Battery Rating  _______Amp.Hr @    _______volts
  • Batteries connection for Battery Bank

Output Results :-

  • Type of Connection For Batteries
  • Selection of Batteries Connection:                  Ok or Not Ok
  • Selection of Each Battery Voltage                 Ok or Not Ok
  • Number of String for Batteries
  • Total Amp.Hr of Each String
  • Total No of Battery in Each String
  • Total Battery Bank Amp.Hr
  • Total Nos of Batteries in Battery Bank




Download Drive-1







You Ma Also Like These E-Books:-

1 comment:

  1. I'm  here to share my testimony of what a good trusted loan company did for me. My name is Nikita Tanya, from Russian and I’m a lovely mother of 3 kids I lost my funds on trying to get a loan it was so hard for me and my children, I went online to seek for a loan assistance  all hope was lost until one faithful day when I met this friend of mine who recently secured a loan from Le_Meridian Funding Service She introduced me to this honest loan company who helped me get a loan in within 5 working days, I will forever be grateful to Mr Benjamin, for helping me get back on feet again. You can contact Mr Benjamin via email: lfdsloans@outlook.com lfdsloans@lemeridianfds.com, they do not know I’m doing this for them, but i just have to do it because a lot of people are out there who are in need of a loan assistance  please come to this company and be saved.WhatsApp:(+1 989-394-3740)

    ReplyDelete