heating costs-hydro vs propane - Canadian TV, Computing and Home Theatre Forums

Jim418 · 2012-06-03, 03:08 PM

I've been working through the same issue as OP: Propane vs Ground Source Heat Pump, since I won't have access to NG for my new home in Kingston.

As others have noted, the answer is always dependent on your variables so I created a spreadsheet to work them through. It has many of the variables "57" noted above.

Here are the worksheets I've developed to compare the long-term costs of different systems.

https://docs.google.com/spreadsheet/...VJQb013TlBrRGc

The first tab (Cost by Energy Source) has data on energy use and the current energy/operating cost by equipment type.

The second tab (Long Term cost per year) calculates the discounted cost of equipment and operating cost over the life of the equipment. It then divides that total number by the life of the equipment by the number of years and compares the results.

Anybody care to look for logic errors? If anyone would like the Excel version emailed to them, just PM me your email address.

The main result that I am struggling with is the annual heating cost of geothermal. Seems crazy low, but is consistent with this website's result when I change the energy use to their value and the COP to 3 (it doesn't say what COP it used).

Thanks in advance for your help.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

2012-06-03, 03:08 PM	#34
Jim418 Rookie Join Date: Jun 2012 Posts: 1	I've been working through the same issue as OP: Propane vs Ground Source Heat Pump, since I won't have access to NG for my new home in Kingston. As others have noted, the answer is always dependent on your variables so I created a spreadsheet to work them through. It has many of the variables "57" noted above. Here are the worksheets I've developed to compare the long-term costs of different systems. https://docs.google.com/spreadsheet/...VJQb013TlBrRGc The first tab (Cost by Energy Source) has data on energy use and the current energy/operating cost by equipment type. The second tab (Long Term cost per year) calculates the discounted cost of equipment and operating cost over the life of the equipment. It then divides that total number by the life of the equipment by the number of years and compares the results. Anybody care to look for logic errors? If anyone would like the Excel version emailed to them, just PM me your email address. The main result that I am struggling with is the annual heating cost of geothermal. Seems crazy low, but is consistent with this website's result when I change the energy use to their value and the COP to 3 (it doesn't say what COP it used). Thanks in advance for your help.