Electrical Load Calculator _Requires Excel_ - NDP Software_ Andrew - Excel

Document Sample
Electrical Load Calculator _Requires Excel_ - NDP Software_ Andrew - Excel Powered By Docstoc
					NDP Software Confidential

Loads

Page 1

Avg. Phantomload Hours per Day

Phantom-Load Watts

Hours per Day

Avg. Run Hours per Day

Avg. W-hr per day

5 2 2 4 2 1 3 1 2 4 1 1 3 2 1 1 1 1 1 1 1 1 1 1 1 1 0 0 2 1 6 1 1 3 5 3 1 1

75 75 150 30 60 10 75 350 100 50 100 100 10

3.00 1.00 1.00 0.25 0.25 0.25 0.25 0.01 2.00 1.00 0.10 0.10 2.00

7.00 7.00 2.00 1.00 1.00 1.00 7.00 7.00 4.00 7.00 7.00 7.00 7.00 7.00 5.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 1.00 7.00

120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120

0 0 0 0 0 0 0 0 0 0 0 0 4 5 4 4 4 5 5 4 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 14

3 1 0.2857 0.0357 0.0357 0.0357 0.25 0.01 1.1429 1 0.1 0.1 2 24 2.1429 2 2 24 24 0.05 0.1 0.1 1 0.1 0.01 0.0357 0 0 0.25 0.375 3 4 0.75 6 1.7143 2 4 2

21 23 23.7143 23.9643 23.9643 23.9643 23.75 23.99 22.8571 23 23.9 23.9 22 0 21.8571 22 22 0 0 23.95 23.9 23.9 23 23.9 23.99 23.9643 24 24 23.75 23.625 21 20 23.25 18 22.2857 22 20 22

1125.0 150.0 85.7 4.3 4.3 0.4 56.3 3.5 228.6 200.0 10.0 10.0 324.0 240.0 226.7 108.0 108.0 96.0 96.0 140.8 120.0 100.0 75.0 30.0 4.5 4.3 0.0 0.0 45.0 658.1 1080.0 300.0 1755.0 1350.0 642.9 450.0 400.0 348.0

6.00% 0.80% 0.46% 0.02% 0.02% 0.00% 0.30% 0.02% 1.22% 1.07% 0.05% 0.05% 1.73% 1.28% 1.21% 0.58% 0.58% 0.51% 0.51% 0.75% 0.64% 0.53% 0.40% 0.16% 0.02% 0.02% 0.00% 0.00% 0.24% 3.51% 5.76% 1.60% 9.35% 7.20% 3.43% 2.40% 2.13% 1.85%

3.13 1.25 2.50 0.00 0.00 0.00 1.88 0.00 1.67 1.67 0.00 0.00 0.25 0.08 0.54 0.08 0.08 0.03 0.03 0.00 0.00 0.00 0.63 0.00 0.00 0.00 0.00 0.00 1.50 14.63 3.00 0.63 19.50 1.88 3.13 1.88 0.83 0.17

410.906 54.788 31.307 1.565 1.565 0.130 20.545 1.278 83.486 73.050 3.653 3.653 118.341 87.660 82.807 39.447 39.447 35.064 35.064 51.427 43.830 36.525 27.394 10.958 1.644 1.565 0.000 0.000 16.436 240.380 394.470 109.575 641.014 493.088 234.804 164.363 146.100 127.107

5 24.00 65 10 10 3.00 2.00 2.00

4 24.00 4 24.00 900 1200 1000 75 300 450 120 0.05 0.10 0.10 1.00 0.10 0.01 0.25

1500 90 1755 60 75 2340 75 75 75 100 20 0.25 0.75 3.00 4.00 0.75 6.00 4.00 2.00 4.00 2.00

7.00 7.00 3.50 7.00 7.00 7.00 7.00 3.00 7.00 7.00 7.00

11/16/2009

88570b2e-dd66-470d-8fb6-7f62ffc0e4b0.xls

kW-hr per year

Surge-Watts

Max. Amps

Run Watts

% of Total Watt-hrs

Days per Week

Volts

Qty

NDP Software Confidential 1 1 1 1 2 0 7 3 1 1 1 3 1 2 1 1 0 1 5 10 1 6 4 4 1 2 1 1 1 1 2 1 1 500 110 35 20 75 150 40 75 50 8 35 90 700 40 60 10 4.00 4.00 2.00 0.25 0.10 0.25 0.50 0.25 0.25 0.25 0.50 2.00 0.50 1.00 1.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 5.00 5.00 7.00 7.00 7.00 1.00 4.00 4.00 4.00 7.00 7.00 3.00 3.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 5.00 5.00 7.00 1.00 7.00 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 220 12 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 4 4 8 8 0 4 0 0 4 6 4 0 0 0 0 0 0 0 0 0 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Loads

Page 2

0.5 2 0.5 1 1 0 4 2.8571 1.4286 35 0.25 0.1 0.25 0.0714 0.1429 0.1429 0.1429 24 0.25 0.4286 0.8571 0.5 5 1 2 0.15 0.5 0.25 0.1 0.3571 0.7143 1 0.0357 0.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0

23.5 22 23.5 23 23 24 20 21.1429 22.5714 23.75 23.9 23.75 23.9286 23.8571 23.8571 23.8571 0 23.75 23.5714 23.1429 23.5 19 23 22 23.85 23.5 23.75 23.9 23.6429 23.2857 23 23.9643 23.9 24 24 24 24 24 24 24 24 24 24 24 24 24 24

344.0 308.0 205.5 204.0 150.0 0.0 1120.0 642.9 161.7 144.5 99.1 67.5 50.0 11.4 8.6 1.4 0.0 22.5 214.3 171.4 1205.0 1500.0 300.0 280.0 150.0 75.0 2.5 10.0 321.4 285.7 80.0 35.7 10.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

1.83% 1.64% 1.10% 1.09% 0.80% 0.00% 5.97% 3.43% 0.86% 0.77% 0.53% 0.36% 0.27% 0.06% 0.05% 0.01% 0.00% 0.12% 1.14% 0.91% 6.42% 7.99% 1.60% 1.49% 0.80% 0.40% 0.01% 0.05% 1.71% 1.52% 0.43% 0.19% 0.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

4.17 0.92 0.29 0.17 1.25 0.00 2.33 1.88 0.42 0.07 0.00 2.25 0.00 0.67 0.50 0.08 0.00 0.75 4.17 1.67 4.55 25.00 2.50 1.17 8.33 1.25 0.08 0.00 7.50 3.33 0.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

125.646 112.497 75.059 74.511 54.788 0.000 409.080 234.804 59.066 52.779 36.196 24.654 18.263 4.174 3.131 0.522 0.000 8.218 78.268 62.614 440.126 547.875 109.575 102.270 54.788 27.394 0.913 3.653 117.402 104.357 29.220 13.045 3.653 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

75 24.00 90 100 20 1000 50 75 35 1000 75 10 100 900 400 40 1000 100 0.25 1.00 2.00 0.50 5.00 1.00 2.00 0.15 0.50 0.25 0.10 0.50 1.00 1.00 0.25 0.10

11/16/2009

88570b2e-dd66-470d-8fb6-7f62ffc0e4b0.xls

NDP Software Confidential

Loads

Page 3

11/16/2009

88570b2e-dd66-470d-8fb6-7f62ffc0e4b0.xls

NDP Software Confidential

Loads

Page 4

11/16/2009

88570b2e-dd66-470d-8fb6-7f62ffc0e4b0.xls

Sum of Max. Amps Circuit basement

Electrical Loads2 Group1 Bedroom 1 Lights Garage Door Opener Garage Lights Basement Appliances

Total

basement Total kitchen

kitchen Total living room

living room Total main

main Total upstairs

upstairs Total kitchen refrigerator kitchen refrigerator Total kitchen dishwasher kitchen dishwasher Total outside outside Total outside tub outside tub Total (blank)

0 2.5 0 1.875 1.666666667 6.041666667 Celing Fan 1.5 Kitchen Appliances 0 Kitchen Blender 0 Kitchen Coffee Pot 0 Kitchen Garbage Disposal 0 Kitchen Microwave - small 0 Kitchen Microwave- large 0 Kitchen Mixer 0 Kitchen Toaster 0 Kitchen Nook Ceiling Fan 0.625 2.125 Dinning Room Lights 1.875 Entertainment CD Player 0.291666667 Entertainment Stereo 4.166666667 Entertainment TV 19" 0.916666667 Entertainment TV 25" 0 Entertainment TV DVD Player 0.166666667 Entertainment TV VCR 0.166666667 Living Room Lights 3.125 Parlor Lights 1.875 Porch lights 0.833333333 Entryway Lights 1.25 14.66666667 Group1 1.25 Bedroom 2 Lights 1.875 Celing Fan 2.25 Computer Printer 0 Computers 0.416666667 Entertainment Boom box (example)0.066666667 Stair Lights 2.333333333 Vacuum 0 8.191666667 Bathroom Hair Dryer 8.333333333 Master Bath Fan 0.083333333 Master Bath Lights 2.416666667 Master Bedroom Lights 27.5 38.33333333 Kitchen Refrigerator 19.5 19.5 Kitchen Dishwasher 14.625 14.625 Outdoor Lights 4.166666667 Outdoor Lights Low Voltage 1.666666667 5.833333333 Outdoor Hot Tub 4.545454545 4.545454545 (blank) 0

(blank) Total none none Total upstairs laundry

75 watt bulb (test) Laundry Clothes Dryer Laundry Clothes Washer Laundry Iron Laundry Lighting Attic Lights Attic Misc Kitchen Lights Kitchen Nook Lights Cell Phones Computer Laptop Phone Answering Machine Phone, Cellular Phone, Cordless Digital Camera PDA Celing Fan

upstairs laundry Total attic attic Total kitchen lights kitchen lights Total charging

charging Total office office Total

0 0 0 3.333333333 7.5 0 0.666666667 11.5 3.125 1.25 4.375 3 0.625 3.625 0.083333333 0.541666667 0.033333333 0.083333333 0.033333333 0.25 0.083333333 1.108333333 0.75 0.75

Qty

(Show All)

Sum of Max. Amps Circuit Total basement 7.708333333 kitchen 2.125 living room 14.66666667 main 8.191666667 upstairs 38.33333333 kitchen refrigerator 19.5 kitchen dishwasher 14.625 outside 5.833333333 outside tub 4.545454545 (blank) 0 none 0 upstairs laundry 11.5 attic 4.375 kitchen lights 3.625 charging 1.108333333 office 0.75 Grand Total 136.8871212

References Information about Phantom Loads can be found: http://www.homepower.com/files/phantom.pdf http://www.earthinstitute.columbia.edu/library/earthmatters/spring2000/pages/page25.html History of this Document Andrew J. ###### Peterson John F. Robbins ######

Benjamin Root

?

Phantom Loads can be found: ower.com/files/phantom.pdf stitute.columbia.edu/library/earthmatters/spring2000/pages/page25.html

Sample data, Amps, and circuit calculations; nicer formatting John's improvement in accounting for phantom loads is to actually ask for the phantom wattage, then include it in the column which gives the daily Watt-hours. This increases the daily energy consumption total accordingly. Phantom loads are appliances that are actually "on" and using power, even though they appear to be off or not in use. We recommend putting these items on switchable plug strips to avoid power comsumption while not in use, or find appliances that actually go "off" when turned off. Original


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:78
posted:11/17/2009
language:English
pages:9