Every hotel's answer, side by side. Nothing re-keyed, nothing guessed.
Turn a folder of hotel Excel response files into the comparison workbook an event planner hands their client.
From a folder to a workbook.
The team brings individual responses together in the client workbook, with one hotel tab and a side-by-side Summary.
Collect the responses
Put the hotels' Excel response files (.xlsx) in one folder.
Set up your template
Map your client workbook once.
Run the checks
Run the mapped responses through the workbook rules.
Review the workbook and report
Get a Summary, one tab per hotel, and a report showing each flagged cell, its source, and why it needs review.
Start with one past program.
Use one completed program's hotel response files and the workbook you gave your client. Set up the map, then run the tool on that format. Real client files are used only after a pilot is agreed and stay in a local folder on the machine running the tool.
- Choose one program Use the hotel .xlsx response files from a completed program.
- Map the workbook Set up the field map for the client workbook you used.
- Review every flag Trace values and flagged blanks in the workbook and parse report before sharing results.
Hotel RFP workflow
Exact hotel labels
Type, date and range checks
Trace values to source cells
When it cannot verify, it leaves a flag.
Map each hotel label exactly. Check every value for type, date, and range. When a result is unclear, leave it blank and give the review team a reason.
Source cell example
$189 + tax
Flagged, not filled
It is not a plain amount. The raw cell is kept with the flag; it is never reduced to 189.
Source cell example
0.13
Flagged, not guessed
It could mean 0.13% or 13%. The value stays blank until a person resolves the ambiguity.
A comparison and its trail.
Review the completed comparison alongside the values that need a person's attention.
Summary
Every hotel, field by field.
The Summary lists each field in column A and one hotel in each column. Every written value can be traced back to its source cell.
Hotel tabs + flagged cells
Values, flags and source notes.
Each hotel gets its own tab: Value, Flag and Notes for every field, with the source cell and raw content in Notes.
Set up your format once.
Set up a map for each new client workbook. The tool is not set up for every template out of the box.
Workbook map
Match hotel labels to workbook fields.
Tell the tool which workbook field each hotel label belongs to. An unmatched label is flagged instead of guessed.
Program details
Set the program dates and currency.
Enter the program name, issue date, arrival and departure window, and currency.