Spreadsheets

Friends, this page brings together links to spreadsheets that I have written to accompany various blog articles.

Warning: All the spreadsheets are Good for Nothing™ i.e. they are not professional software, and they are free. Keep your expectations low.

Request: If you spot an error, please let me know. Thanks

Heat Pump Calculator

Description: A spreadsheet designed to help someone considering changing from gas central heating to using a heat pump. It allows for a quick estimate of likely heat pump size and the effect of radiators on the likely heat pump.

Accompanying Article: Link updated to version 6.01 on 3/3/23

Download:Link

Tariff Comparison Spreadsheet

Description: A spreadsheet designed to help someone compare the likely annual costs of Octopus Energy’s GO, FLUX and COSY tariffs with the equivalent standard variable tariff. It includes hour-by-hour simulations for a year with different solar and battery possibilities. Note: this spreadsheet contains VB macros and will be disabled on most Windows™ computers. Read the accompanying article to find out how to run the file.

Accompanying Article: Link

Download: Link

Qooker versus Kettle Spreadsheet

Description: A spreadsheet comparing the costs and efficiency of a boiling water tap with the use of a conventional kettle.

Accompanying Article: Link

Download: Link

Setback Calculator

Description: A spreadsheet looking at the pros and cons of using a lower overnight temperature when using a heat pump.

Accompanying Article: Link

Download: Link

Reading Energy Meter Spreadsheets

Description: A spreadsheet to help users record their energy consumption by reading their meters once a week..

Accompanying Article: Link

Download:

• Spreadsheet including example data: Electricity and Gas Consumption Spreadsheet EXAMPLE
• Empty Spreadsheet for conventional or smart meters where you are reading off the face of the meter itself. Electricity and Gas Consumption Spreadsheet (Regular)
• Empty Spreadsheet for reading from the hand-held readout units that accompany most smart meters. Electricity and Gas Consumption Spreadsheet (For handheld smart meters)

Coldest Day Calculator

Description: A spreadsheet designed to help someone currently using a gas boiler to estimate the size of heat pump they would require in their dwelling by measuring gas consumption on very cold days.

Accompanying Article: Link

Download: Link

Geothermal Energy Calculator

Description: A spreadsheet designed to help calculate how much heat could be sustainably extracted from a large volume – on the order of a cubic kilometre – of rock .

Accompanying Article: Link

Download: Link

Dishwashing Calculator

Description: A spreadsheet designed to help decide whether it is cheaper and/or greener to use a dishwasher or to hand wash.

Accompanying Article: Link

Download: Link