Part 3: Useful Templates
Contents
Useful Templates
3.1 Leaner & Greener Worksheet 1: Annual Units & Costs
What is this template for?
This template is available in Excel format and allows you to convert all energy sources to a common currency, kWh (kilowatt hours).
Why should you use it?
Once you have all energy sources in the same currency, kWh, you can calculate the Average Unit Price (AUP) for
each unit of energy. This allows you to compare prices of different energy sources. This template also allows
you calculate a benchmark against which you can measure performance over time.
How do you fill it out?
You only need to complete the shaded fields in green. The columns in white are then automatically calculated.
- Annual Units and Annual Costs: You will find these on your bills or you can request them from your supplier.
- Benchmark: select a relevant unit of activity for your business e.g. number of customers/covers/tickets/transactions/rooms/square metre that your business handles in a year.Use it to track performance over
time. (The first one is completed as an example.)
Tab 1 of spreadsheet - Energy Annual Use and Costs
3.1 Leaner & Greener Worksheet 1: Annual Units & Costs
3.2 Leaner & Greener Worksheet 2: Energy Equipment Audit
What is this template for?
This template is available in Excel format and allows you to log the energy use of all energy-using equipment in your business.
Why should you use it?
It allows you to identify the biggest users and prioritise areas for action.
How do you fill it out?
You only need to complete the fields in green. The columns in white are then automatically calculated.
- Rating (kW): Enter the Energy Rating for that piece of equipment
- Hours On/Week: Estimate how many hours per week that item of equipment is switched on.
- Average Unit Price: Enter the Average Unit Price which you calculated in Worksheet 1 Annual Use and Costs (The first line is completed as an example)
Tab 2 of Spreadsheet - Energy Equipment Audit
3.2 Leaner & Greener Worksheet 2: Energy Equipment Audit
3.3 Leaner & Greener Energy Savings Action Plan Template
What is this template for?
This template, which you can re-create yourself, allows you to document a practical Action Plan to reduce energy consumption and reduce costs.
Why should you use it?
This creates a single document where all actions that you can commit to are listed. It establishes priorities and responsibilities within the team, as well as timelines for action.
How do you fill it out?
Action: State the Action you will take
- Responsibility: Clearly identify who is responsible for delivering on this action.
- Deadline: Set a specific date when this action is targeted for completion.
- Notes: Add any information here that is relevant to the particular action e.g. additional resources required.
(The first line is filled in as an example)
Tab 3 of spreadsheet - Energy Savings Action Plan