---
name: grup-kontenjan
description: "Use when a group allotment and option tracking analysis is requested from group block, rooming list and option dates in the contract. Produce a formula-based Excel file and a Word summary."
---

# Group allotment and option tracking

As option dates approach, how many rooms in which group have not yet been named?

## Input and scope

Group block, rooming list and option dates in the contract.

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 group and stay night. When converting the number of people on the rooming list into rooms, count shared rooms once. Label multi-night totals as room nights.

2. Subtract the report date from the release/option date in the contract. Unnamed rooms = blocked − named rooms. Flag negative differences for a data check. Leave blank if the date is missing.

3. Prioritise groups whose option has expired and that still have unnamed rooms. Verify guarantee, release and tiered allotment clauses. Leave any block release to a human decision independent of the report.

## 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: Group, Stay, Blocked rooms, Named rooms, Unnamed rooms, Days to option.

## 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: Meeting C's option expired one day ago. Names are still pending for eight rooms.
