|2012-06-03, 04:08 PM||#34|
Join Date: Jun 2012
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.
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.