Skill · Engineering and energy

Electricity consumption and cost per occupied room

Is the change in electricity cost accompanied by consumption intensity or by the effective unit price?

Type
Skill
Department
Engineering and energy
Input
kWh, electricity cost and occupied room nights for the same meter scope
Output
Formula-based Excel analysis and a one-page Word summary
License
CC BY 4.0
Raw text
SKILL.md

Download skill package

enerji-yogunlugu/
├─ SKILL.md
├─ assets/
│  └─ ornek-girdi.xlsx
└─ ornekler/
   ├─ analiz.xlsx
   └─ yonetim-ozeti.docx
Download skill package .zip

SKILL.md instructions and sample files in one package

How to use

  1. Download the package.
  2. In an assistant that supports skills (e.g. Claude), upload the package as a skill. In other assistants, paste the SKILL.md text into the chat.
  3. Attach your own Excel export and send the message below. The assistant prepares the formula-based workbook and the Word summary.

Try it with the sample

Before using your own data you can try the sample input in the package. Send this message to the assistant together with the file:

message
Analyze the files I attached for electricity consumption and cost per occupied room. Is the change in electricity cost accompanied by consumption intensity or by the effective unit price? Prepare the result as a formula-based Excel file and a one-page Word report we can use in our meeting.
Expected result on the sample data

On 18 November, total consumption was lower than the previous day, yet consumption per occupied room rose from 42 to 50 kWh.

Sample files

The sample files are in Turkish.

Instructions (SKILL.md)

SKILL.md

Is the change in electricity cost accompanied by consumption intensity or by the effective unit price?

Input and scope

kWh, electricity cost and occupied room nights for the same meter scope.

Use the attached Excel/CSV files as the source. Read each one without modifying it. Identify the sheets, report scope, periods, units and required fields. Map synonymous column headers against the sample. If a missing field affects only a specific metric, still produce the other metrics. If a critical definition can be read in more than one way, ask one focused question. Trace subtotals and duplicates back to the source row. Remove fields containing personal data from the outputs. Use the sample only when the user wants to try it with the sample data.

Analysis

  1. If the meter provides a cumulative index, use the difference between consecutive readings. Flag resets/replacements, missing days and overlaps between sub-meters and the main meter for checking.
  2. Match cost, consumption and occupied room nights for the same date range. Do not derive daily costs from a monthly invoice without verification. State the scope of taxes and fixed charges.
  3. Calculate kWh per occupied room, effective TL per kWh and TL per occupied room. Leave the ratio blank when the denominator is zero. Do not present weather, banquets or technical faults as causes without evidence.

Delivery and checks

On the first sheet of Analiz.xlsx, show the rows that answer the question and the calculated indicators. Keep the sources on a separate sheet with anonymised fields. Write Excel formulas for derived measures. On the Checks sheet, add the date range, column mapping, scope, missing/unmatched records and the reconciliation result. Create the Word file named Yonetim-Ozeti.docx. On one page, write the period, the main result, at most three evidence-backed findings and the follow-up the responsible team will check. Reopen both files; independently check the numbers, the denominators of ratios and the source totals. Do not present unverifiable causes as findings. Deliver both files as downloads.

Visible fields in the Excel analysis: Date, kWh / occupied room, Effective TL / kWh, TL / occupied room.

Try it with the sample

Use the file assets/ornek-girdi.xlsx. The expected Excel and Word examples are in the ornekler/ folder. Sample-specific check: On 18 November, total consumption was lower than the previous day, yet consumption per occupied room rose from 42 to 50 kWh.

Let Talkwo run this work for you

Talkwo brings your PMS, messaging and review data into one place and prepares these reports for you every morning.

Meet Talkwo

License: The prompts and skills in this library are licensed under CC BY 4.0. You may copy, adapt and use them freely, including commercially, as long as you credit Talkwo. CC BY 4.0

Sample files use fictional hotel data.

© 2026 Talkwo Contact Privacy Terms