Sometimes I like doing manual data entry, so I decided why not create a list of Indian Hotels with Reward Points.
This is what it looks like -
(Disclaimer - Points and prices are dynamic in nature - so consider the list as reference only)
Google Spreadsheet Link - https://docs.google.com/spreadsheets/d/1I5U6y-LTB8CIP7G5sxyIsjYMTU5wMJ6duMp_AA-0Eh8/edit?usp=sharing
Notes -
Edit (22/06/23 11.48) - Fixed issue in ratio column format
This is what it looks like -
(Disclaimer - Points and prices are dynamic in nature - so consider the list as reference only)
City | Hotel | Chain | Price | Points | OTA Price | Price/Points Ratio | Booking Date | Enquiry Date |
Bengaluru | JW Marriott | Marriott | 15694 | 22000 | 0.71 | 22/07/2023 | 12/06/2023 | |
Bengaluru | ITC Gardenia | Marriott | 13339 | 30000 | 0.44 | 22/07/2023 | 12/06/2023 | |
Bengaluru | Ritz-Carlton | Marriott | 16189 | 39000 | 0.42 | 22/07/2023 | 12/06/2023 | |
Bengaluru | Renaissance | Marriott | 11210 | 16000 | 0.70 | 22/07/2023 | 12/06/2023 | |
Bengaluru | ITC Windsor | Marriott | 10929 | 20000 | 0.55 | 22/07/2023 | 12/06/2023 | |
Bengaluru | Farifield Rajajinagar | Marriott | 5532 | 10000 | 0.55 | 22/07/2023 | 12/06/2023 | |
Bengaluru | Sheraton Grand Brigade Gateway | Marriott | 15357 | 28000 | 0.55 | 22/07/2023 | 12/06/2023 |
Google Spreadsheet Link - https://docs.google.com/spreadsheets/d/1I5U6y-LTB8CIP7G5sxyIsjYMTU5wMJ6duMp_AA-0Eh8/edit?usp=sharing
Notes -
- This is just a starting point - I will keep updating the list whenever possible
- I have tried to take base points & price - but that may not be the case always.
- General observation for Marriott (sample size - 8-10 hotels) is that if the revenue price increases, points also increase proportionately (approx). So the ratio remains more or less same. But that's not the rule, I have seen a lot of exceptions too.
- This can be done better via collaboration - I just don't want to make the spreadsheet publicly editable. Suggestions for collaboration are welcome
Edit (22/06/23 11.48) - Fixed issue in ratio column format
Last edited: