---
name: oda-hazirlik
description: "Use when an arrival room readiness times analysis is requested from arrival room list, room-specific committed time, ready notification and report time. Produce a formula-based Excel file and a Word summary."
---

# Arrival room readiness times

Which arrival rooms were made ready after the committed time, and which are still pending?

## Input and scope

Arrival room list, room-specific committed time, ready notification and report time.

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. Match by room code and arrival date. ¹ The sample input uses minutes after midnight (840 = 14:00). In a real report, compare date-time values in the hotel's local time.

2. If an early check-in commitment was given for the room, use it. Take the definition of ready from the hotel's operating rule. If the planned time is missing, do not calculate the delay.

3. Calculate ready − committed for completed rooms and report time − committed for open rooms, and floor the delay at zero. Do not include rooms that are still open in the completion average. Remove guest identities from the outputs.

## 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: Room code, Delay (min), Status.

## 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: As of 15:30, O-307 is still open and 30 minutes late.
