# Parallel and Series Circuits Worksheets - Excel by ept16172

VIEWS: 187 PAGES: 14

Parallel and Series Circuits Worksheets document sample

• pg 1
```									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

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

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!

```
To top