Spreadsheet: 197562d1354445895-formula-value-lookup-but-return-value-from-x-columns-left-and-y-rows-down-armitage2k-offset-sample-rev1-
Sheet: Sep12

 |  |  | Previous Month | Reporting Period |  |  | 3 Months Rolling |  |  | 12 Months Rolling |  |  | YTD
 | Guest Loyalty & Behavior
 | Are you an Ambassador Member?
 | Yes |  | 4.35 % | 0.0962 |  | ⇧ | 0.0845 |  | ⇩ | 0.1632 |  | ⇩ | 0.1197 | ⇩
 | No |  | 95.65 % | 0.9038 |  | ⇩ | 0.9155 |  | ⇧ | 0.7376 |  | ⇧ | 0.8085 | ⇧
 | Were you asked to join the Ambassador Programme?
 | Yes |  | 36.36 % | 0.3778 |  | ⇧ | 0.3858 |  | ⇩ | 0.2662 |  | ⇧ | 0.2918 | ⇧
 | No |  | 38.64 % | 0.4444 |  | ⇧ | 0.4173 |  | ⇧ | 0.4453 |  | ⇧ | 0.4438 | ⇩
 | Not sure/Do Not Remember |  | 25.00 % | 0.1778 |  | ⇩ | 0.1969 |  | ⇩ | 0.2886 |  | ⇩ | 0.2644 | ⇧
 | How would you rate your overall satisfaction with the Ambassador benefits at this hotel?
 | Completely Satisfied |  | 100.00 % | 0.4 |  | ⇩ | 0.4167 |  | ⇧ | 0.2278 |  | ⇧ | 0.2667 | ⇧
 | Very Satisfied |  | - | 0.4 |  |  | 0.25 |  | ⇩ | 0.2532 |  | ⇩ | 0.3111 | ⇩
 | Satisfied |  | - | 0 |  |  | 0.0833 |  | ⇩ | 0.2658 |  | ⇩ | 0.1778 | ⇩
 | Somewhat Satisfied |  | - | 0.2 |  |  | 0.25 |  | ⇧ | 0.1899 |  | ⇧ | 0.2 | ⇧
 | Not At All Satisfied |  | - | 0 |  |  | - |  |  | 0.0127 |  | ⇩ | -
 | Not Sure |  | - | 0 |  |  | - |  |  | 0.0506 |  | ⇧ | 0.0444
 | Were you greeted as an Ambassador member at check-in?
 | Yes |  | 50.00 % | 0.6 |  | ⇧ | 0.5 |  | ⇩ | 0.7302 |  | ⇩ | 0.75 | =
 | No |  | 50.00 % | 0.4 |  | ⇩ | 0.5 |  | ⇧ | 0.2698 |  | ⇧ | 0.25 | =
 | Did you receive a room upgrade?
 | Yes |  | 50.00 % | 1 |  | ⇧ | 0.8333 |  | ⇧ | 0.5696 |  | ⇧ | 0.6222 | ⇧
 | No |  | - | 0 |  |  | - |  |  | 0.2405 |  | ⇩ | 0.1778 | ⇩
 | Not Sure |  | 50.00 % | 0 |  |  | 0.1667 |  | ⇩ | 0.1899 |  | ⇧ | 0.2
 | Did you receive complimentary fruit and mineral water?
 | Yes |  | 100.00 % | 1 |  | = | 1 |  | = | 0.8333 |  | ⇧ | 0.8636 | ⇧
 | No |  | - | 0 |  |  | - |  |  | 0.1282 |  | ⇩ | 0.0909 | ⇩
 | Did you receive a personalized welcome letter?
 | Yes |  | 50.00 % | 0.8 |  | ⇧ | 0.6667 |  | ⇧ | 0.6329 |  | ⇧ | 0.6667 | ⇧
 | No |  | 50.00 % | 0.2 |  | ⇩ | 0.3333 |  | ⇩ | 0.2405 |  | ⇩ | 0.2667 | ⇩
 | Not Sure |  | - | 0 |  |  | - |  |  | 0.1266 |  | ⇩ | 0.0667 | ⇩
 | Did you receive a complimentary daily newspaper at your room?
 | Yes |  | 100.00 % | 0.8 |  | ⇩ | 0.75 |  | ⇧ | 0.5823 |  | ⇧ | 0.5778 | ⇩
 | No |  | - | 0.2 |  |  | 0.25 |  | ⇧ | 0.2911 |  | ⇩ | 0.2889 | ⇧
 | Not Sure |  | - | 0 |  |  | - |  |  | 0.1266 |  | ⇧ | 0.1333
 | Opt-in to answer a few additional questions about Ambassador membership?
 | Yes |  | 50.00 % | 1 |  | ⇧ | 0.9167 |  | ⇩ | 0.7848 |  | ⇧ | 0.8444 | ⇩
 | No |  | 50.00 % | 0 |  |  | 0.0833 |  | ⇧ | 0.2152 |  | ⇩ | 0.1556 | ⇧
 | Overall Satisfaction with the Ambassador Programme?
 | Completely Satisfied |  | - | 0.6 |  |  | 0.3636 |  | ⇧ | 0.1452 |  | ⇧ | 0.2105 | ⇧
 | Very Satisfied |  | - | 0.2 |  |  | 0.0909 |  | ⇩ | 0.2581 |  | ⇧ | 0.2895 | ⇧
 | Satisfied |  | 100.00 % | 0 |  |  | 0.2727 |  | ⇩ | 0.3226 |  | ⇩ | 0.2368 | ⇩
 | Somewhat Satisfied |  | - | 0.2 |  |  | 0.1818 |  | ⇧ | 0.1935 |  | ⇩ | 0.1579 | ⇩
 | Not At All Satisfied |  | - | 0 |  |  | 0.0909 |  | ⇧ | 0.0323 |  | ⇧ | 0.0526
 | Not Sure |  | - | 0 |  |  | - |  |  | 0.0484 |  | ⇩ | 0.0526 | =
 | Likelihood to Recommend the Ambassador Programme
 | Definitely Would |  | - | 0.6 |  |  | 0.3636 |  | ⇧ | 0.3934 |  | ⇧ | 0.3684 | ⇧
 | Probably Would |  | 100.00 % | 0.4 |  | ⇩ | 0.3636 |  | ⇩ | 0.3115 |  | ⇩ | 0.3421 | ⇩
 | Might or Might Not |  | - | 0 |  |  | 0.1818 |  | ⇧ | 0.1803 |  | ⇧ | 0.1316 | ⇩
 | Probably Would Not |  | - | 0 |  |  | 0.0909 |  | ⇧ | 0.0492 |  | ⇧ | 0.0789
 | Definitely Would Not |  | - | 0 |  |  | - |  |  | - |  |  | -
 | Not Sure |  | - | 0 |  |  | - |  |  | 0.0656 |  | ⇩ | 0.0789 | ⇩
 | Likelihood to Renew the Ambassador Programme
 | Definitely Would |  | - | 0.8 |  |  | 0.4545 |  | ⇧ | 0.3115 |  | ⇧ | 0.3421 | ⇧
 | Probably Would |  | - | 0.2 |  |  | 0.1818 |  | ⇩ | 0.2951 |  | ⇧ | 0.2632 | =
 | Might or Might Not |  | 100.00 % | 0 |  |  | 0.1818 |  | ⇩ | 0.2295 |  | ⇩ | 0.1579 | ⇩
 | Probably Would Not |  | - | 0 |  |  | 0.1818 |  | ⇧ | 0.0656 |  | ⇧ | 0.1053 | ⇩
 | Definitely Would Not |  | - | 0 |  |  | - |  |  | 0.0164 |  | ⇧ | 0.0263
 | Not Sure |  | - | 0 |  |  | - |  |  | 0.082 |  | ⇩ | 0.1053 | =
 | Value for the money
 | Much more than you paid |  | - | 0.4 |  |  | 0.2727 |  | ⇧ | 0.1475 |  | ⇧ | 0.1316 | ⇩
 | Somewhat more than you paid |  | - | 0.6 |  |  | 0.2727 |  | ⇧ | 0.3443 |  | ⇧ | 0.3684 | ⇧
 | About what you paid |  | - | 0 |  |  | 0.1818 |  | ⇩ | 0.2295 |  | ⇩ | 0.1842 | ⇩
 | Somewhat less than you paid |  | 100.00 % | 0 |  |  | 0.0909 |  | ⇩ | 0.1148 |  | ⇧ | 0.1316 | ⇧
 | Much less than you paid |  | - | 0 |  |  | 0.0909 |  | ⇧ | 0.0328 |  | ⇧ | 0.0526
 | Not Sure |  | - | 0 |  |  | 0.0909 |  | ⇩ | 0.1311 |  | ⇩ | 0.1316 | ⇧
 | Member of PCR?
 | Yes |  | 100.00 % | 1 |  | = | 1 |  | = | 0.9959 |  | ⇧ | 0.9947 | ⇧
 | No |  | - | 0 |  |  | - |  |  | 0.0041 |  | ⇩ | 0.0053 | ⇩
 | Not Sure |  | - | 0 |  |  | - |  |  | - |  |  | -
 | Asked to join PCR?
 | Yes |  | - | 0 |  |  | - |  |  | 0.5 |  | ⇧ | 50.00 % * | =
 | No |  | - | 0 |  |  | - |  |  | 0.5 |  | ⇩ | 50.00 % * | =
 | Not sure/Do Not Remember |  | - | 0 |  |  | - |  |  | - |  |  | - *
 | Greeted as PCR member at check-in?
 | Yes |  | 60.87 % | 0.8182 |  | ⇧ | 0.7326 |  | ⇧ | 0.7112 |  | ⇧ | 0.7489 | ⇧
 | No |  | 39.13 % | 0.1818 |  | ⇩ | 0.2674 |  | ⇩ | 0.2888 |  | ⇩ | 0.2511 | ⇩
 | Are you a PCR Gold or Platinum member?
 | Yes - Platinum |  | 4.00 % | 0.2121 |  | ⇧ | 0.1613 |  | ⇧ | 0.1779 |  | ⇧ | 0.161 | ⇩
 | Yes - Gold |  | 20.00 % | 0.303 |  | ⇧ | 0.1935 |  | ⇧ | 0.2248 |  | ⇧ | 0.2246 | ⇩
 | No |  | 76.00 % | 0.4848 |  | ⇩ | 0.6452 |  | ⇩ | 0.5973 |  | ⇩ | 0.6144 | ⇧
 | Not Sure |  | - | 0 |  |  | - |  |  | - |  |  | -
 | Acknowledged as a statused member by front desk team member
 | Yes |  | 83.33 % | 0.75 |  | ⇩ | 0.8125 |  | ⇧ | 0.7203 |  | ⇩ | 0.7191 | ⇧
 | No |  | - | 0.125 |  |  | 0.0938 |  | ⇩ | 0.1864 |  | ⇩ | 0.1685 | ⇩
 | Not Sure |  | 16.67 % | 0.125 |  | ⇩ | 0.0938 |  | ⇧ | 0.0932 |  | ⇧ | 0.1124 | ⇧
 | Had the hotel prepared for your arrival with a pre-assigned room and registration form?
 | Yes |  | 66.67 % | 0.4118 |  | ⇩ | 0.5152 |  | ⇩ | 0.5462 |  | ⇩ | 0.5778 | ⇩
 | No |  | - | 0.3529 |  |  | 0.303 |  | ⇧ | 0.2941 |  | ⇧ | 0.2556 | ⇧
 | Not Sure |  | 33.33 % | 0.2353 |  | ⇩ | 0.1818 |  | ⇧ | 0.1597 |  | ⇧ | 0.1667 | ⇧