An occupied room-night is one room occupied for one night. A guest-night is one person for one night. Two people in one room are one occupied room-night and two guest-nights. Choose one denominator. Write the ratio yourself only when the numerator is a measured finite number, the denominator is a positive whole count, and the dates and rooms match. A missing, mixed or zero denominator leaves the ratio blank. A measured zero numerator with a matching positive denominator may be a valid zero ratio.

The general KPI guide lists a hospitality example and does not define it. Return to the hospitality overview for the per-cover line. SECR intensity stays on the SECR guide. Laundry quantities stay on the linen count.

Which denominator you are using

No-shows are not occupied rooms. A complimentary room that was occupied is included. Room-night and guest-night counts are positive whole counts when they are used. Do not mix people and rooms on the same row. Occupied room-nights must not exceed the rooms available for that hotel and period. This 20-room hotel has 20 available room-nights on one date. The file has no capacity column; write the check yourself.

The occupied-room definition is taken from the Hotel Carbon Measurement Initiative introduction. The Alliance resource page says the method calculates a carbon footprint per occupied room on a daily basis. This worksheet does not implement that method, does not store an emission factor, and does not supply a benchmark. Guest-night is this sheet’s label for a count of people, not the Alliance occupied-room metric.

Fill in one metric at a time

Download both files. Save a copy of the blank file and type into that copy.

The files are plain CSV. They do not divide.

When the row is allowed, divide the numerator by the denominator. Write ratio_value and ratio_unit. Round to the nearest 0.1 when the result is not a whole number. 1,000 kWh divided by 100 occupied room-nights is 10 kWh per occupied room-night. Fill numerator_evidence_reference and denominator_evidence_reference. written_by_reader is allowed only when the numerator is measured and finite, including a genuine zero, the denominator is a positive whole count, and coverage_match is yes.

Worked example: 10 kWh per occupied room-night, a valid zero, and two blanks

The rows are a fictional week at Northgate Rooms, 1 to 7 March 2026, and later one-day checks. The hotel is invented.

Row What was written Ratio
Electricity, 1 to 7 March 1,000 kWh measured, all 20 rooms, bill B-031. 100 occupied room-nights, occupancy sheet O-031. Coverage matches. 10 kWh per occupied room-night. 1,000 divided by 100 is 10. This week's arithmetic, not a benchmark.
Electricity, 8 March 0 kWh measured, 20 occupied room-nights in the 20-room hotel, matching coverage. 0 kWh per occupied room-night. A genuine measured zero with a positive denominator that does not exceed available rooms.
Guest electricity 1,000 kWh measured. Guest-night denominator blank. Blank. not_calculated.
Electricity, 15 March 50 kWh measured. Occupied room-nights 0. Blank. A zero denominator does not become a ratio of zero.
Mixed coverage 1,000 kWh with occupied room-nights mixed with guest-nights. Blank. People and rooms stay apart.
Electricity, 16 March 10 kWh measured. 40 occupied room-nights on one day in the 20-room hotel. Blank. 40 exceeds 20 available room-nights, so the ratio stays empty.

If the reader later has 333 kWh and 100 occupied room-nights with matching coverage, the written ratio is 3.3 kWh per occupied room-night.

Limits

The 10 kWh figure is not a carbon result and not an industry benchmark. The Alliance method’s emission factors, its laundry estimate from occupied rooms, and its meeting-space hour are not used. Before a public intensity claim, use the green-claims guide.

Sources