Research and analysis

Spreadsheet tools for users

As a complement to the Household Electricity Survey we have developed three interactive spreadsheets that allow users to work with the data.

• From: Department of Energy & Climate Change
• Published: 9 July 2014

Documents

Model Tester Tool

MS Excel Spreadsheet, 594 KB

This file may not be suitable for users of assistive technology.

Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email [email protected]. Please tell us what format you need. It will help us if you say what assistive technology you use.

Lighting Tool

MS Excel Spreadsheet, 573 KB

This file may not be suitable for users of assistive technology.

Request an accessible format.

If you use assistive technology (such as a screen reader) and need a version of this document in a more accessible format, please email [email protected]. Please tell us what format you need. It will help us if you say what assistive technology you use.

Details

As a complement to the Household Electricity Survey we have developed three interactive spreadsheets that allow users to work with the data themselves:

• Daily load profiles for different households selected from the sample of 250 households. This spreasdheet can be downloaded from this hightail link. **Please note this spreadsheet is .xlsm format and functions with excel 2007 and subsequent versions. Select “enable macros”.
• Comparison of modelled and actual electricity use for different dwellings (Cambridge Housing Model)
• Lighting use by different types of dwellings.

Published 9 July 2014