# OccupancySensorLightSwitchTool

Document Sample

```					                            Occupancy Light Switch Installation
Notice:
Before starting the worksheet make sure that the macro setting in excel is enabled. Follow these instructions
below.
7 simple steps
1. Click the office button
2. When office menu is showing click on "Excel Options"
3. Click on "Trust Center" in dialog box
4. Click "Trust Center Settings"
5. Click "Macro Settings" then click on "Enable all macros"
6. Click OK
7. Click OK

Questions:
Matt Schultze
Phone: 406-587-6959

What room will switch be installed?

How many lights are in this room?
(Count each florescent light as one and each recessed can light as one)

How many "screw in sockets" have incandescent bulbs?

How many "screw in sockets" have compact florescent bulbs (CFL)?

How many lights are long fluorescent bulbs?

If long florescent bulbs are used are they T12 (old) or T8 (new upgrade) or unknown enter unknown
or if no long florescent bulbs are used enter N/A?

What is the cost per kWh? (average is around \$0.115/ kWh)

What is the cost of the occupancy that is proposed? (Average cost \$25-\$45)

What is the labor cost to install one switch? (\$25-\$75)

Total watts per hour= 160                                              0.16 kilowatts per hour (kWh)

Total power used if lights are on for:
Time (hr)            kWh/Day          Cost/day     kWh/Month*         Cost /Month        kWh/Yr**
8           1.28 \$        0.19                 28    \$           4.16        332.9
10            1.6 \$        0.24                 35    \$           5.20        416.1
16           2.56 \$        0.38                 55    \$           8.32        665.7
24           3.84 \$        0.58                 83    \$          12.48        998.6
*Average work days in one month is 21.67 days
**Average work days in one year is 260 days

Total Reductions with installation of occupancy light switch
Estimated                                          Greenhouse
Reduction             Reduction                           Savings per
Reduction                                          Gas Reduction
(kWh/Day)             (kWh/Yr)                               Year
(Hours per Day)                                    (MTCO2e/Yr)
1.00             0.16           42                0.1   \$           6.24
3.00             0.48          125                0.1   \$          18.72
5.00             0.80          208                0.1   \$          31.20
7.00             1.12          291                0.2   \$          43.68
12.00             1.92          499                0.3   \$          74.88
14.00             2.24          582                0.3   \$          87.36
18.00             2.88          749                0.5   \$         112.32
allation
hese instructions

Break room

4

Energy and cost saving results for propos
0
Yearly estimated energy
reduction
0
Results          208.00 kWh

* Calculations based on a five hour reduction
4

T12

\$     0.150

\$     25.00

\$     25.00

kilowatts per hour (kWh)
Cost/Yr
\$    49.93
\$    62.41
\$    99.86
\$   149.78
d cost saving results for proposed switch installation in Break room

Greenhouse Gas                           Number of years to
Savings per Year (\$)
Reduction                               recover cost

0.13 MTCO2e   \$      31.20                 1.6 Years

sed on a five hour reduction
Electricity Purchased

Average
(kWh)
Bulb List            Average watts
T12                                  40       100                 0.07308
T8                                   32       200                 0.12308
Unknown                              36       300                 0.18846
N/A                                   0       400                 0.24615
Incandescent                         60       500                 0.30000
Compact Florescent                   16       600                 0.35385
700                 0.45000
800                 0.49231
900                 0.56154
1000                 0.61538
1500                 0.93846
2000                 1.24231
2500                 1.55000
3000                 1.86154
3500                 2.18846
4000                 2.50769
4500                 2.81154
5000                 3.11538
5500                 3.42308
6000                 3.74615
Data come from EPA Climate action tool
it is the average of all power sources in the US

```
DOCUMENT INFO
Categories:
Tags:
Stats:
 views: 8 posted: 3/12/2012 language: pages: 7