Parallel and Series Circuits Worksheets - Excel

Document Sample
Parallel and Series Circuits Worksheets - Excel Powered By Docstoc
					Worksheet 1: Daily System Energy Requirement
Use this worksheet to calculate the energy which must be supplied by the
array each day to power all of the lights and appliances in your system
1. Calculate the total daily load energy demand using the table below



Column A                         Column B       Column C        Column D        Column E
Lamp or Appliance                Voltage        Power           Daily Use       Daily Energy
                                                                                Use (DC)
list below                       volts          watts           hours           watt hours

DC Appliances

                                                                                               0
                                                                                               0

                                                                                               0
                                                                                               0
                                                                                               0
                                                                                               0
                                                                                               0
                                                                                               0
                                                                                               0
                                                                                               0
AC Appliances
Centrifuge                                240           200             0.5
HIV Testing                               240           300             1.5
Laptop computer                           240            30               8
Printer                                   240              20           0.5
Copier                                    240           600             0.5
Refrigerator                              240              60               6
Video/TV                                  240           120                 2
Admin block lights (8 * 10W)              240              80               4
Maternity lights (4 * 15W)                240              60               2
Ward lights (4 * 8W)                      240              32               3
Security (4 * 15W)                        240              60               6
Cell phone recharging                     240              40               8



                                BOX G: Total Daily DC Energy Demand                            0
                                  BOX H: Total Daily AC Energy Demand

2. Estimate system energy losses                            Box I: DC losses                  0
Energy is always lost due to inefficiencies in cables       Box J: AC losses
modules, batteries, charge controllers and inverters.
The extra amount of energy lost must be estimated
and added to the daily energy demand.                         3. Add AC & DC Demand and AC & DC Losses
                                                                          Box K: Total Daily
For DC power multiply Box G by               0.20              System Energy Requirement
For AC power multiplyBox H by                0.35


4. Select System Voltage
        Box L: System Voltage                  24 volts
                                                                 5. Calculate Daily System Charge Require
                                                                 Divide Box K by the system voltage in Box L
                                                                              Box M




                                    NB              The following shades indicate how cells should be used

                                                                 Enter data in this cell
                                                                 See text for a description of this cell
                                                                 This cell contains a calculation and is locked
                   Worksheet 2: Sizing and Choosing the Modules
                   Use this worhsheet to calculate the size of array in your
                   system
                   Step 1: Obtain your site's insolation value
                                                                          Estimated annua
                        Do you have
Column F             meteorological data?                                      insolation psh
Daily Energy
                                                      NO
Use (AC)
watt hours

                                            YES




                   Box 2A Solar Records
                   Mean insolation data should be Select the lowest
                   filled below.                montly insolation figure
                          Month Peak Sun Hours
                             Jan           4.87
                            Feb             4.82                          Design Month ps
                            Mar             5.19
                            Apr             5.43
               0            May             5.42
             100            Jun             5.23
             450             Jul            5.19
             240            Aug             5.13
              10            Sep             5.07
             300            Oct             4.71
             360            Nov             6.03
             240            Dec             5.22
             320           AVG              5.19
             120
              96                   Box 2C                      Box 2D
             360
             320
                                   164.025                           5

                                Daily System                   Design Solar
Watt-hours                   Charge Requirement              Insolation Value
                         2916 Wh                 Amp-hours              Peak sun hours
                                              From Worksheet 1
             Wh                                    BOX M
                     1020.6 Wh
                                   Step 4: Select enough modules        Details of Selected Module
                                   to produce the design charging current.Company
mand and AC & DC Losses            Use the manufacture's data           Peak watts
otal Daily                         (I-V curve & temperature data).      Rated voltage
                     3936.6 Wh                                          Rated current
                                   Step 5: Draw the configuration of    Current at NOCT
                                   the module array                     Number of modules required



y System Charge Requirement
e system voltage in Box L
                   164.025 Ah


                                   Insolation in kWh/m2/day/month



w cells should be used


ription of this cell
 calculation and is locked
e Modules                                                   Worksheet 3: Battery Sizing and Selection
                                                            Use this worksheet to select your battery and charge
                                                            controller
            BOX 2C                                          Step 1: What type of battery will you use?
       Estimated annual                                     Shop around to get an idea of the batteries available
                                                            Type of Battery  Voltage
         insolation psh
                                                            Modified SLI
                                                            (Portable)
                                                            Traction Battery

                                                            Lead Calcium
                                                            Maintenance Free
                                                            Captive Electrolyte Gel
                                                            Cells
                                                            Absorbed Glass Mat
                                                            Tubular Plate Batteries


                            Step 2: Select Design Solar     Other

                            Insolation Value                Step 2: Calculate the capacity required capacity
                                                            of your battery in amp hours.
               BOX 2B                                       Box 3A
       Design Month psh
                                                               164.025
                        5
                                                             Daily System                  Reserve Days
                                                          Charge Requirement
                                                                Amp-hours
                                                            From Worksheet 1 BOX M
                                                            Step 3: Determine the
                                                            battery configuration




          Step 3: Calculate the design                      Step 4: Does battery
          charging current                                  require special
                            Box 2E                          charge control setting?

                             32.81                          Step 5: Determine your
                                                            battery cycle life and
sign Solar               System Design                      maintenance needs.
lation Value            Charging Current
ak sun hours                 Amps         Maintenence needs
                                          Topping up        YES
                                          Cleaning corrosionYES
                                          Equalizing       YES
etails of Selected Modules                Check SoC        YES
               BP 790   BP Solar
                                    90
 ted voltage                        24
 ted current                         5    Expected
 rrent at NOCT                      5.3   Life Cycle
umber of modules required       6.19
attery Sizing and Selection                                                        Worksheet 4: Charge
o select your battery and charge                                                   Use this worksheet to size a
                                                                                   controller and inverter
 of battery will you use?                                                          Charge Controller Sizing
an idea of the batteries available (see Tabe 4.3)                                  Step 1: Select Charge Co
            Capacity       Recommended Recommended     Price        Cycle Life @
                           Daily DoD (%) Max DoD (%)                25% DoD        Array Input Rating

                                                                                   Box 4A
                                        50%                                           63.60
                                                                                   Maximum Array

                                                                                   Short Circuit Current
                                                                                      Amps



                                                                                   Step 2: Select Desired CC
the capacity required capacity                                                     Shop around to get an idea
amp hours.                                                                         Controller Specification
            Box 3B                      Box 3C                      Box 3D         Rated Voltage
                                                                                   Maximum Array ISC Input
                 2                         0.5                        656.1
                                                                                   Maximum Load Output
           Reserve Days               Maximum DoD              Required System     Self Consumption
             Minimum 1               Express as decimal        Battery Capacity    Feature
            Maximum 4                (ex. 30% is 0.30)              Amp-hours      High voltage disconnect
                                                                                   Low voltage disconnect
                          Make a drawing of battery configuration/voltage          Temperature compensation
                          Indicate the voltage and parallel/series connections     Load timer



                                                                                   Displays
                                                                                   Solar charge indicator
            YES √                                                                  SoC indicator (LED)
            NO ☐                                                                   LCD display
                                                                                   Amp hour meter

                                                                                   Inverter Sizing and Selec

                                        Details of Selected Battery                Step 1: Is an Inverter N
How often   Company                         Trojan   Step 2: Inverter/Charge
Monthly     Model                        L16RE-2V    Step 3: Inverter & Charg
Monthly     Type                           Flooded   Box 4E
Quarterly   C20 Capacity Ah               1200 Ah      1602
Weekly      Individual Battery Voltage         2V
            Battery Bank Voltage              12V    Watts
            Number in series                    6
            Number in parallel                  1    Rated Charge Current
Cycles      Total number of batteries           6    For battery charging (A)
(Days)      Total battery capacity           1200    Accepts power from:
            Rated cycle life @ 25% DoD
 orksheet 4: Charge Controller/Inverter Sizing and Selection
e this worksheet to size and select your charge
ntroller and inverter
harge Controller Sizing and Selection
 ep 1: Select Charge Controller Size

 ray Input Rating                                     DC Load Output Current Rating

                           Box 4B                     Box 4C                       Box 4D
               x 1.25 =      79.5                         0.0        x 1.25 =            0.0
aximum Array            Array Input Rating            Maximum DC Load             Load Output

hort Circuit Current       Amps                                                           Rating
                                                                                          Amps



 ep 2: Select Desired CC Features
 op around to get an idea of the charge regulators available (see Table [])
ontroller Specification                 Rating        Protection                   YES/NO
 ted Voltage                    V       See Box L     Short circuit protection (array)
aximum Array ISC Input          A       See Box 4B Short circuit protection (load)
aximum Load Output              A       See Box 4D Reverse polarity (array)
 lf Consumption                mA                     Reverse polarity (load & battery)
                           YES/NO                     Lightning protection
gh voltage disconnect                                 Open circuit battery
w voltage disconnect                                  Sealed battery charge settings
mperature compensation




                           YES/NO                     Desired Charging Type        YES/NO
 lar charge indicator                                 Pulse Width Modulation
 C indicator (LED)                                    Equalization
                                                      MPPT
mp hour meter                                         Other

 verter Sizing and Selection
                                        YES/NO
ep 1: Is an Inverter Needed?            YES           Only if 230/110 VAC appliances are used.
ep 2: Inverter/Charger?                  YES    Only if a charging source is available
ep 3: Inverter & Charger Rating                 Step 4: Select Desired Inverter Features
                      Box 4F                    Details of Desired Inverter
           x 1.25          2002.5               Continuous Power (W)
                     Inverter Rating            Peak Surge Power (W)
                                 Watts          Input DC Volts
                                                Output AC Volts
ated Charge Current      Box 4G                 Wave shape
r battery charging (A)                          Efficiency
cepts power from:    Genset/wind/solar          Self-Consumption (A)
                    Select appropriate choice   Low Voltage Disconnect (V)
Worksheet 5: Wiring, Voltage Drop and Fuses
Use this worksheet to size and select your electrical
accessories
Step 1: Map the Site and
Estimated Cable Runs
Draw a scale map of the site and
estimate the distance of all cable runs,
including from the modules to the
control, the control to battery and the
circuits. Note the locations of each
lamp, socket, switch, junction box, and
fuses. Note the voltage of major
circuits.




Step 2: Determine the proper cable sizes to avoid voltage drop
See Chapter 7 for instructions on the use of the table below.

         Column A             Column B      Column C      Column D      Column E          Column F
 Cable Run (List Circuits)    Distance of    Maximum      K Value of      Total          Voltage Drop
                              Cable (m)     Current (A)      wire       Resistance            (V)
                                                          (ohms/m)       (ohms)

                                                                                     0               0
                                                                                     0               0
                                                                                     0               0
                                                                                     0               0
                                                                                     0               0
                                                                                     0               0
                                                                                     0               0


                                                                                     0               0
                                                                                     0               0


                                              Make sure all voltage drops are less than 2%!
Step 3: Sizing Fuses and Circuit Breakers                              Step 4. List all electrical
See Chapter 7 for detailed instructions on sizing fuses                accessies required.
• List circuits to be protected in Column A                            • Cables (all sizes & types)
• Write each circuit's maximum power drawn (W) in Column B             • Conduit
• Calculate each circuits' maximum current (A) in Column C             • Switches
• Increase the figure by 20% in Column D                                    • Sockets
 This is the minimum size of the fuse required.                             • Fuses
        Column A             Column B      Column C          Column D       • Junction boxes
 Cable Run (List Circuits)   Max Rated     Maximum          Fuse Size (A)
                             Power (W)    Current (A)
                                                                            • Connector strips
                                                                            • Lightening protection
                                                        0              0    • Grounding/earthing
                                                        0              0    • Bolts, screws, nuts, etc.
                                                        0              0
                                                        0              0    Use the list of electrical accessories to
                                                        0              0    make sure you have everything you
                                                                            need before going to site!
                                                        0              0
                                                        0              0
              Column G
             Voltage Drop
                 (%)


                0%
                0%
                0%
                0%
                0%
                0%
                0%

                0%
                0%

than 2%!
electrical
 ectrical accessories to
have everything you
ng to site!

				
DOCUMENT INFO
Description: Parallel and Series Circuits Worksheets document sample