GM Dashboard
One guided update. A preserved history. A smarter daily GM view.
Everyone with this link sees the same saved figures. Saving changes requires the editor code. Data refreshes every 30 seconds when no unsaved inputs are open.
Know where the hotel is going — and why.
The shared report date determines the update. Completed actuals and future bookings are tracked separately.
What is happening with my hotel?
Attention List
Observed booking patterns
Potential compression
Today's Forecast Update
The system will walk Alex through only what is due today. Yesterday's snapshot is never overwritten.
Read Report Run Date at the upper right of PEP Occupancy Forecast. This is the snapshot date, not the stay date range. Final actuals are due through the previous hotel day. The saved date stays fixed until an editor starts a new update.
Yesterday’s Final Results
Source: PEP Hotel Statistics, ROOM SOLD — Today. Cross-check the same completed date in Occupancy Forecast, Total Sold Rooms (column I in the supplied Excel export). Never use the monthly Totals row here. For September 12: 73 rooms.
Source: PEP Final Audit, Room Revenue section, Totals row, Net Today column. Exclude Other Room Revenue, taxes, M-T-D and Y-T-D. For September 12: $7,228.34.
B. Month-to-date reconciliation
Enter both fields when establishing or reconciling this month's actuals. The month-to-date checkpoint replaces accumulated actuals through this date; it is never added on top of them. Leave both blank only when saved daily actuals already cover the month.
Source: PEP Hotel Statistics, ROOM SOLD — MTD. This is completed stays since the first of the month. It excludes future reservations. September 1–12: 634, reconstructed from the daily rows supplied; verify against Hotel Statistics when available.
Source: PEP Final Audit, Room Revenue / Totals / M-T-D. On the September 12 audit: $65,443.93. This already includes $7,228.34 for September 12.
Paste Future OTB
Source: PEP Occupancy Forecast. Run a separate full-month report for the current month and each future month. Read the column names; letters below refer to the supplied export. Copy Date through Projected Occupancy (B–N), with one row per stay date. Headers and Totals rows are ignored. Dates match automatically.
Total Sold Rooms → OTB rooms. Total Revenue → OTB room revenue. Past dates remain visible for review and are excluded from this OTB save; enter actuals through Final Audit. Paste each month before saving. Missing dates remain missing; same-day dates already saved are retained.
Copy the future-date values in Excel column I (Total Sold Rooms). Click the matching starting date under I below and press Ctrl+V. Repeat with column G (Total Revenue). Dollar signs, commas and cents are preserved. Select the data cells, excluding the monthly total.
Paste the full PEP report or Date / Total Sold Rooms / Total Revenue
Also accepts three tab-separated columns in exactly this order: Date, Total Sold Rooms, Total Revenue. With column-only paste, click the correct first date in the grid. Column I is rooms; column G is revenue. ADR is optional and calculated from revenue ÷ rooms.
| Stay Date | Stay DOW | Prior OTB | Today OTB | Pickup | Pickup % | Booking DOW | Days Since Snapshot | OTB Rev |
|---|
Daily Forecast Review
Today's forecast update is ready.
Actuals, OTB, pickup and today's required review are preserved. The dashboard and forecast have been refreshed.
October Excel copy-and-paste files
From the current shared snapshot, all 31 October dates must be present. For the supplied workbook, paste rooms into Daily Forecast G35:G65 and revenue into I35:I65. Do not overwrite H (pickup).
Download October rooms column · Download October revenue column
| Stay Date | DOW | Days Out | Prior OTB | Current OTB | Pickup | Suggested Pickup | Final RN | ADR | Revenue | Status |
|---|
Number → Driver → Impact → Action
Latest recommendation
Dates that still need action
Flags future dates materially below model expectation across the rolling forecast horizon.
| Date | DOW | Current OTB | Forecast | Gap | Pickup | Recommended Focus |
|---|
Add Known Demand Event
Internet-discovered events should never change the forecast automatically. Alex reviews them first.
Demand Watch
This prototype shows the review workflow. Production can check major demand generators across Irving/Las Colinas, DFW Airport, Dallas, Arlington, Grapevine and Fort Worth, then ask Alex to Add / Watch / Ignore.
Forecast Accuracy
Mean absolute daily revenue error (MAE) compares saved daily forecasts with final daily actuals. Monthly checkpoints are not used as daily actuals. No score is shown until matching observations exist.
Booking Behavior
Pickup is measured only on stay dates present in both reports. The snapshot day is not the actual booking day when multiple days passed between reports.
Daily OTB Snapshots
Each As-of Date is preserved. A new day never deletes yesterday.
Backup / Restore
Data is shared across computers in the cloud database. Every successful save keeps the previous version. Export a portable backup before major changes. Restoring a backup replaces the shared state for everyone and requires editor access.
Restore a Previous Shared Version
Editor access required. Every save archives the prior version in the database.
Activity History
Model assumptions and calculation
Monthly Budget & Targets
Source: the approved HIA monthly budget, not PEP Occupancy Forecast. Use the same month for room nights, ADR, revenue and occupancy. Unknown budgets stay blank.
| Month | Budget RN | Budget ADR | Budget Revenue | Budget OCC |
|---|
Save Weekly GRO Snapshot
Source: the GRO recommendation for the selected month, refreshed during Monday review. Enter the monthly recommended rooms, ADR, room revenue and occupancy. This is a comparison benchmark, not the PEP OTB total or the rolling forecast.
Model Setup
The calculation follows the supplied Excel workbook. See the assumptions and report guide below.