Built tool · Revenue management

Revenue dashboard

Live rate shopping and comp set analysis using OTA price grid exports. Daily workflow in under two minutes.

Type
Excel + HTML dashboard
Data source
Expedia Price Grid exports
Comp set
11 properties tracked
Daily workflow
Under 2 minutes
The problem

Most independent and boutique hotels do not have a dedicated revenue manager — the GM or DOS is making rate decisions based on intuition, sporadic OTA checks, or expensive third-party tools that require setup and training. Real comp set visibility, updated daily, should not require a specialist or a subscription. This dashboard was built for The Lafayette Hotel to solve exactly that.

How it works
Export
Pull the daily Expedia Price Grid export — one file, takes seconds.
Paste
Drop the data into a new Raw tab in the workbook. No reformatting required.
Update two cells
Set current and prior sheet names in the Settings tab. Everything else is automatic.
Read the dashboard
Live variance comparison against the full comp set, color-coded by position.
Built with
ExcelGoogle SheetsINDIRECT / INDEX / MATCHHTMLJavaScript