1
of 6— Set Up Your Input Section
What you'll need
- Microsoft 365 subscription with Copilot enabled
- Excel desktop app (2302 or later) or Excel for the web
- Typical transient forecast data for your property (average occupancy %, ADR by day of week or season)
- Understanding of your hotel's basic cost structure (commission rates, F&B capture per attendee)
Use Excel Copilot to Build a Reusable Group Displacement Model
Step 1: Set Up Your Input Section
Create a new Excel workbook. In rows 1–15, set up a labeled input section where you'll enter group quote details each time you use the template:
| Row | Label | Value |
|---|---|---|
| 2 | Group Name | [enter each time] |
| 3 | Arrival Date | [enter each time] |
| 4 | Departure Date | [enter each time] |
| 5 | Number of Rooms | [enter each time] |
| 6 | Number of Nights | [enter each time] |
| 7 | Group Room Rate (ADR) | [enter each time] |
| 8 | Transient Forecast ADR | [enter each time] |
| 9 | Transient Forecast Occupancy % | [enter each time] |
| 10 | Hotel Total Rooms | [your hotel's constant] |
| 11 | F&B Revenue Per Attendee | [enter each time] |
| 12 | Attendees per Room | [enter each time] |
| 13 | OTA Commission Rate | [your hotel's constant] |
| 14 | Direct Booking Premium | [your hotel's constant] |
Format as an Excel Table (Ctrl+T).
Tools:Microsoft ExcelMicrosoft Copilot