Hotel Energy & Utilities Cost Control Toolkit: Hotel Energy Saving Workbook

Full description

This toolkit is for chief engineers, general managers, finance controllers and owners who want to see where a hotel's electricity, water and gas go and what to do about it. It gives you a workbook to log meters and track use per occupied room, a guide with 64 energy and water saving measures, and printable forms for audits and monthly checks. Every figure that depends on your building, tariff or local rules is an editable input. The workbook ships with a 120-room example property, so every tab shows numbers on first open.

Save with a bundle: this template is also in the Hotel Engineering, Safety & Compliance Bundle, 11 templates for $35 instead of $83. All 141 templates are in the All-Access Hospitality Template Library for $79.

What is inside

• Energy_Workbook.xlsx: 13 tabs, 4,894 formulas, 4 charts.
• Start Here, Settings, Meter_Register, Meter_Log, Monthly_Summary, Target_vs_Actual, Savings_Projects, Invoice_Checker, Leak_Anomaly_Log, Night_Flow_Test, Setpoint_Policy, Dashboard, Lists.
• Sample data: 130 meter readings on 10 meters, 14 savings projects, 36 invoices, 10 leak and anomaly entries, 25 setpoint lines.
• Energy_Saving_Guide.docx and .pdf: 29 pages. 64 measures in 9 areas, each with an effort level, capex level, owner and check method. Also the energy audit method, setpoint policy, project business case, invoice and leak procedures, and a 12-week staff awareness plan with 5 toolbox talks.
• Energy_Audit_Checklists.docx and .pdf: 17 pages, 16 printable forms: audit cover sheet, data request, plant, rooms, public areas, night walk, kitchen and laundry, pool and spa, water and leaks, meter reading, setpoints, invoice check, project proposal, leak report, training attendance, action plan.
• README.txt and LICENSE-and-Terms.txt.

How it works

1. Enter your rooms, floor area, tariffs and thresholds on Settings, then list your meters.
2. Add meter readings and occupied room nights each month. The workbook calculates use, cost and intensity per occupied room and per sqm.
3. Set monthly targets. Flags show OK, WATCH or OVER. The dashboard shows totals, a monthly snapshot and four charts.
4. Log invoices, leaks, night flow tests and setpoint checks. Rank savings projects by payback and NPV.
5. Use the guide and forms for audits, staff briefings and the monthly energy review.

Details

• Formats: XLSX, DOCX and PDF. A4 print layout.
• Language: English. Currency is an editable label with no symbol.
• Software: Microsoft Excel 2016 or later for the workbook. Any word processor for the DOCX files. Any PDF reader for the PDFs.
• Delivery: digital download. No physical item is shipped.

Good to know

• Sample data, rates, targets and setpoints are illustrative examples. They are not benchmarks or official rates.
• The guide does not state saving percentages. You enter your own, taken from your audit, a trial or a supplier quote.
• Rates, limits, water temperatures and tax items depend on local rules. Verify local requirements.
• This is general information, not engineering, legal or tax advice.
• Single-user license. Do not redistribute.

FAQ

What software do I need? Excel 2016 or later for the workbook. Word files open in any word processor. PDFs open in any reader.

Does it work in Google Sheets? You can upload the workbook to Google Sheets. Formulas, drop-downs and most formatting carry over, but charts and some conditional formatting may look different. Excel is the tested format.

Can I edit it? Yes. The workbook and the Word files are fully editable. Blue cells in the workbook are inputs. Clear the sample rows and enter your own data.

Are there refunds? This is a digital download and nothing is shipped. Refund terms follow the store policy. Check the sample pages in the preview before you buy.

Who is it for? Hotels of any size that have meters and invoices: chief engineers, general managers, finance controllers and owners. It also suits serviced apartments and resorts.

Does it tell me how much each measure saves? No. It lists the measures with effort and capex levels, and the workbook calculates payback from your own inputs.