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

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