Compare the running cost of the same heat, three ways
Enter how much useful heat your home needs over a period, in kilowatt-hours, plus your own energy prices and seasonal efficiencies. The worksheet works out how much energy each system must buy to deliver that same heat — heat pump, electric resistance, and combustion (gas, oil or similar) — and what that energy costs. Pre-filled numbers are an example only.
Worked example (the pre-filled numbers)
Useful heat 10,000 kWh, COP 3, electricity 0.30 per kWh, fuel 0.08 per input kWh, combustion efficiency 90%. Heat pump electricity: 10,000 ÷ 3 = 3,333.3 kWh, costing 1,000.00. Resistance: 10,000 kWh costing 3,000.00. Combustion fuel: 10,000 ÷ 0.9 = 11,111.1 input kWh, costing 888.89. These are example assumptions, not prices or performance figures for anywhere in particular.
Method
The U.S. Department of Energy defines COP as useful heating or cooling output divided by energy input, with both in the same units. This worksheet uses that ratio for heating.
Energy you buy = useful heat ÷ efficiency-like factor: heat pump Q ÷ COP, resistance Q (factor 1 at the point of use), combustion Q ÷ η. Usage cost = energy bought × its price per kWh. The electricity price may be a signed retail rate: entered negative (a per-kWh credit your retail tariff would actually apply — not an assumed wholesale pass-through), the electric usage costs are negative bill components, not cash-payment promises; the combustion fuel price stays at or above zero. Break-even COP against combustion = electricity price × η ÷ fuel price per input kWh, shown only when both prices are positive; with a negative electricity rate or a fuel price of 0 there is no meaningful positive COP threshold, so compare the signed costs directly instead. Unit conversions follow the NIST Guide to the SI, Appendix B.8 (therm (U.S.) = 1.054804×108 J; 1 kWh = 3.6×106 J), the BIPM SI definitions, and the U.S. EIA explainer on measuring electricity. How unit rates and standing charges appear on a bill is described by Ofgem (UK); your own supplier documents govern your bill.
What this cannot tell you
It compares usage-cost arithmetic for an equal amount of useful heat. It does not size equipment, judge whether a system suits a building, or account for installation, maintenance, lifespan, comfort, defrost or backup heat, distribution losses, or prices changing over time. Seasonal COP and efficiency are averages: actual performance varies with weather, emitter temperatures, controls and installation quality. Nothing here is investment or purchase advice, and no saving is guaranteed. Anything involving fixed wiring, fuel lines or flues belongs to qualified installers under your local rules.