Energy consumption on excel
hazard7
FuelConsumptionclass.xlsxHeating
| -5 | 65 | x | Nashville | |||||||||||||||||
| 65000 | 0 | y | ||||||||||||||||||
| point 1 | point 2 | |||||||||||||||||||
| 0.4 | 30322.4 | |||||||||||||||||||
| Cost of natural gas | $8.25 | per 1000 cu ft | ||||||||||||||||||
| Procedure | Temp Bins | -5 to 5 | 5 to 15 | 15 to 25 | 25 to 35 | 35 to 45 | 45 to 55 | 55 to 65 | ||||||||||||
| Ave Bin Temp (T) | 0.00 | 10.00 | 20.00 | 30.00 | 40.00 | 50.00 | 60.00 | Deg F | ||||||||||||
| Line 1 | 4.00 | 27.00 | 132.00 | 685.00 | 1,205.00 | 1,245.00 | 1,565.00 | Hours per year | ||||||||||||
| Line 2 | BTUh | 60,357.00 | 51,071.30 | 41,785.60 | 32,499.90 | 23,214.20 | 13,928.50 | 4,642.80 | BTU/hr | |||||||||||
| Line 3 | 241,428.00 | 1,378,925.10 | 5,515,699.20 | 22,262,431.50 | 27,973,111.00 | 17,340,982.50 | 7,265,982.00 | BTU per year /bin | ||||||||||||
| Yearly Heating BTU | 81,978,559.30 | BTU per year | ||||||||||||||||||
| Natural Gas Consumption | 123,044.74 | cu ft/year | ||||||||||||||||||
| Cost | $1,015.12 | dollars/year | ||||||||||||||||||
Load = -928.57*Temperature + 60357
-5 65 65000 0
Cooling
| 95 | 70 | 21386.6 | ||||||||||||||||
| 17777 | 0 | 15147983.96 | ||||||||||||||||
| 0.4 | 30322.4 | |||||||||||||||||
| Cost of electricity KWh | $0.10 | per KWh | ||||||||||||||||
| Procedure | Temp Bins | 70 to 75 | 75 to 80 | 80 to 85 | 85 to 90 | 90 to 95 | ||||||||||||
| Ave Bin Temp (T) | 72.50 | 77.50 | 82.50 | 87.50 | 92.50 | Deg F | ||||||||||||
| Line 1 | 919 | 804 | 583 | 404 | 220 | Hours per year | ||||||||||||
| Line 2 | BTUh | 1,777.30 | 5,332.70 | 8,888.10 | 12,443.50 | 15,998.90 | BTU/hr | |||||||||||
| Line 3 | 1,633,338.70 | 4,287,490.80 | 5,181,762.30 | 5,027,174.00 | 3,519,758.00 | BTU per year /bin | ||||||||||||
| Yearly Heating BTU | 19,649,523.80 | BTU per year | ||||||||||||||||
| Fuel consumption | 2,456.19 | KWh/yr | ||||||||||||||||
| Cost | $252.01 | dollars/year | ||||||||||||||||
Cooling Load = 711.08*Temperature - 49776
95 70 17777 0
