Spreadsheet: 236456d1368799029-make-peak-values-move-to-low-value-region-peak-lopping-help-finalenergycalc
Sheet: Main Calculation

 | HOME ENERGY CONSUMPTION CALCULATION
 | Appliance | Load (Watts) | No. of Appliances (Qty.) | Age Factor of Appliance       (1 = New, 1.5 = 10 yrs, 2 = 20+ yrs) | Hours of usage/day (Hrs) | TOU (Start) | TOU (Finish) | Total Energy Usage (kWh)
Lighting |  | 40 | 8 | 1 | 4 | 06:30:00 | 10:30:00
 | Incandescent Light | 60 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 |  | 80 | 8 | 1 | 4 | 18:00:00 | 22:00:00
 |  | 100 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 |  | 10 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | Compact fluorescent lamp (CFL) | 15 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 |  | 20 | 8 | 1 | 5 | 19:00:00 | 1900-01-01 00:00:00
 | Fluorescent Tube | 40 | 2 | 1 | 2 | 18:30:00 | 20:30:00
 | LED Light | 8 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 |  | 16 | 24 | 1 | 6 | 17:30:00 | 23:30:00
Large Appliances | Refridgerator   - 250L | 50 | 0 | 1 |  | 00:00:00 | 1900-01-01 00:00:00
 | - 500L | 75 | 1 | 2 |  | 00:00:00 | 1900-01-01 00:00:00
 | - 750L | 100 | 1 | 1.5 |  | 00:00:00 | 1900-01-01 00:00:00
 | Freezer             - Upright | 150 | 1 | 1 | 12 | 09:00:00 | 21:00:00
 | - Chest | 250 | 0 | 1 | 12 | 09:00:00 | 21:00:00
 | [NAME] | 3400 | 1 | 1.5 | 1 | 19:00:00 | 20:00:00
 | Oven | 2300 | 1 | 1 | 0.75 | 18:45:00 | 19:30:00
 | Dishwasher | 1800 | 1 | 1.5 | 1 | 20:30:00 | 21:30:00
 | Electric Cooktop | 1000 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | Washing Machine | 425 | 1 | 1.5 | 1.5 | 19:15:00 | 20:45:00
Heating & Cooling Appliances | Central Air Conditioner | 3000 | 1 | 1.5 | 3 | 17:00:00 | 20:00:00
 | Reverse Cycle Air Conditioner | 1200 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | Electric Hot Water Heater | 2000 | 1 | 1 | 1 | 01:00:00 | 02:00:00
 | Ceiling fan | 80 | 2 | 1 | 2 | 17:30:00 | 21:30:00
 | Table Fan | 40 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | Radient Floor Heating | 4000 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | Portable [NAME] | 1000 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | - 2 kW | 2000 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | Electric Blanket | 200 | 1 | 1 | 1.5 | 22:30:00 | 1900-01-01 00:00:00
 | Electric Furnace Heating | 4000 | 0 | 1 | 0 | 00:00:00 | 00:00:00
Entertainment Appliances | Television         - LCD | 180 | 2 | 1 | 2 | 19:00:00 | 21:00:00
 | - Plasma TV | 340 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | - Standard | 200 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | Stereo System | 60 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | [NAME] PC | 120 | 1 | 1 | 1 | 20:30:00 | 21:30:00
 | Monitor | 150 | 1 | 1 | 1 | 20:30:00 | 21:30:00
 | Laptop Charger | 50 | 1 | 1 | 4 | 18:00:00 | 22:00:00
 | Other Computer Appliances | 20 | 4 | 1 | 1 | 20:30:00 | 21:30:00
 | DVD Player | 20 | 1 | 1 | 0.5 | 19:30:00 | 20:00:00
 | Gaming Console | 180 | 1 | 1 | 4 | 19:00:00 | 23:00:00
Kitchen Appliances | Toaster | 1100 | 1 | 1 | 0.25 | 07:45:00 | 08:00:00
 | Electric Frying Pan | 1200 | 1 | 1 | 0.25 | 19:00:00 | 19:15:00
 | Coffee Machine | 1500 | 1 | 1 | 0.25 | 07:00:00 | 07:15:00
 | Microwave | 1200 | 1 | 1 | 0.25 | 19:30:00 | 19:45:00
 | Blender | 300 | 0 | 1 | 0 | 00:00:00 | 00:00:00
 | Kettle | 2000 | 1 | 1 | 0.25 | 07:30:00 | 07:45:00
 | Other Kitchen Appliances | 20 | 1 | 1 | 0.5 | 07:30:00 | 08:00:00
Various Household Appliances | Garage Door | 150 | 1 | 1 | 0.25 | 08:30:00 | 08:45:00
 | [NAME] | 1500 | 1 | 1 | 0.25 | 07:45:00 | 08:00:00
 | Iron | 1100 | 1 | 1 | 0.5 | 23:00:00 | 23:30:00
 | Satellite Dish | 15 | 1 | 1 | 24 | 00:00:00 | 1900-01-01 00:00:00
 | Clock Radio | 12 | 1 | 1 | 24 | 00:00:00 | 1900-01-01 00:00:00
 | [NAME] | 1300 | 1 | 1 | 0.5 | 19:30:00 | 20:00:00
 | [NAME] | 80 | 1 | 1 | 0.25 | 08:00:00 | 08:15:00
 | Pool Pump | 400 | 1 | 1 | 2 | 02:30:00 | 04:30:00
 | TOTAL ENERGY CONSUMPTION
 |  |  | HOURS | LOAD (kWh) | Demand Per Hour (kW) | Demand/15 Min (kW) | Start Time |  |  |  |  | 00:00:00 | 00:15:00 | 00:30:00 | 00:45:00 | 01:00:00 | 01:15:00 | 01:30:00 | 01:45:00 | 02:00:00 | 02:15:00 | 02:30:00 | 02:45:00 | 03:00:00 | 03:15:00 | 03:30:00 | 03:45:00 | 04:00:00 | 04:15:00 | 04:30:00 | 04:45:00 | 05:00:00 | 05:15:00 | 05:30:00 | 05:45:00 | 06:00:00 | 06:15:00 | 06:30:00 | 06:45:00 | 07:00:00 | 07:15:00 | 07:30:00 | 07:45:00 | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00 | 18:30:00 | 18:45:00 | 19:00:00 | 19:15:00 | 19:30:00 | 19:45:00 | 20:00:00 | 20:15:00 | 20:30:00 | 20:45:00 | 21:00:00 | 21:15:00 | 21:30:00 | 21:45:00 | 22:00:00 | 22:15:00 | 22:30:00 | 22:45:00 | 23:00:00 | 23:15:00 | 23:30:00 | 23:45:00 | 1900-01-01 00:00:00
 |  | 40 |  |  |  |  |  |  |  |  | 40
 | Incandescent Light | 60 |  |  |  |  |  |  |  | Incandescent Light | 60
 |  | 80 |  |  |  |  |  |  |  |  | 80
 |  | 100 |  |  |  |  |  |  |  |  | 100
 |  | 10 |  |  |  |  |  |  |  |  | 10
 | Compact fluorescent lamp (CFL) | 15 |  |  |  |  |  |  |  | Compact fluorescent lamp (CFL) | 15
 |  | 20 |  |  |  |  |  |  |  |  | 20
 | Fluorescent Tube | 40 |  |  |  |  |  |  |  | Fluorescent Tube | 40
 | LED Light | 8 |  |  |  |  |  |  |  | LED Light | 8
 |  | 16 |  |  |  |  |  |  |  |  | 16
 | Refridgerator   - 250L | 100 |  |  |  |  |  |  |  | Refridgerator   - 250L | 100
 | - 500L | 150 |  |  |  |  |  |  |  | - 500L | 150
 | - 750L | 200 |  |  |  |  |  |  |  | - 750L | 200
 | Freezer             - Upright | 150 |  |  |  |  |  |  |  | Freezer             - Upright | 150
 | - Chest | 250 |  |  |  |  |  |  |  | - Chest | 250
 | [NAME] | 3400 |  |  |  |  |  |  |  | [NAME] | 3400
 | Oven | 2300 |  |  |  |  |  |  |  | Oven | 2300
 | Dishwasher | 1800 |  |  |  |  |  |  |  | Dishwasher | 1800
 | Electric Cooktop | 1000 |  |  |  |  |  |  |  | Electric Cooktop | 1000
 | Washing Machine | 425 |  |  |  |  |  |  |  | Washing Machine | 425
 | Central Air Conditioner | 5000 |  |  |  |  |  |  |  | Central Air Conditioner | 5000
 | Reverse Cycle Air Conditioner | 1200 |  |  |  |  |  |  |  | Reverse Cycle Air Conditioner | 1200
 | Electric Hot Water Heater | 2000 |  |  |  |  |  |  |  | Electric Hot Water Heater | 2000
 | Ceiling fan | 80 |  |  |  |  |  |  |  | Ceiling fan | 80
 | Table Fan | 40 |  |  |  |  |  |  |  | Table Fan | 40
 | Radient Floor Heating | 4000 |  |  |  |  |  |  |  | Radient Floor Heating | 4000
 | Portable [NAME] | 1000 |  |  |  |  |  |  |  | Portable [NAME] | 1000
 | - 2 kW | 2000 |  |  |  |  |  |  |  | - 2 kW | 2000
 | Electric Blanket | 200 |  |  |  |  |  |  |  | Electric Blanket | 200
 | Electric Furnace Heating | 4000 |  |  |  |  |  |  |  | Electric Furnace Heating | 4000
 | Television         - LCD | 180 |  |  |  |  |  |  |  | Television         - LCD | 180
 | - Plasma TV | 340 |  |  |  |  |  |  |  | - Plasma TV | 340
 | - Standard | 200 |  |  |  |  |  |  |  | - Standard | 200
 | Stereo System | 60 |  |  |  |  |  |  |  | Stereo System | 60
 | [NAME] PC | 120 |  |  |  |  |  |  |  | [NAME] PC | 120
 | Monitor | 150 |  |  |  |  |  |  |  | Monitor | 150
 | Laptop Charger | 50 |  |  |  |  |  |  |  | Laptop Charger | 50
 | Other Computer Appliances | 20 |  |  |  |  |  |  |  | Other Computer Appliances | 20
 | DVD Player | 20 |  |  |  |  |  |  |  | DVD Player | 20
 | Gaming Console | 180 |  |  |  |  |  |  |  | Gaming Console | 180
 | Toaster | 1100 |  |  |  |  |  |  |  | Toaster | 1100
 | Electric Frying Pan | 1200 |  |  |  |  |  |  |  | Electric Frying Pan | 1200
 | Coffee Machine | 1500 |  |  |  |  |  |  |  | Coffee Machine | 1500
 | Microwave | 1200 |  |  |  |  |  |  |  | Microwave | 1200
 | Blender | 300 |  |  |  |  |  |  |  | Blender | 300
 | Kettle | 2000 |  |  |  |  |  |  |  | Kettle | 2000
 | Other Kitchen Appliances | 20 |  |  |  |  |  |  |  | Other Kitchen Appliances | 20
 | Electric Blanket | 100 |  |  |  |  |  |  |  | Electric Blanket | 100
 | [NAME] | 1500 |  |  |  |  |  |  |  | [NAME] | 1500
 | Iron | 1100 |  |  |  |  |  |  |  | Iron | 1100
 | Satellite Dish | 15 |  |  |  |  |  |  |  | Satellite Dish | 15
 | Clock Radio | 12 |  |  |  |  |  |  |  | Clock Radio | 12
 | [NAME] | 1300 |  |  |  |  |  |  |  | [NAME] | 1300
 | [NAME] | 80 |  |  |  |  |  |  |  | [NAME] | 80
 | Pool Pump | 400 |  |  |  |  |  |  |  | Pool Pump | 400