Hotel Points A List of Indian Hotels with Reward Points & Revenue Price (Work In Progress)

[sleepysurya]

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)

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 -

1. This is just a starting point - I will keep updating the list whenever possible
2. I have tried to take base points & price - but that may not be the case always.
3. 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.
4. This can be done better via collaboration - I just don't want to make the spreadsheet publicly editable. Suggestions for collaboration are welcome

If people think this is helpful and have suggestions to improve this, I'm all ears.
Edit (22/06/23 11.48) - Fixed issue in ratio column format

 

[NikhilTravelLover]

Thats a big list. Must have been hard to compile.

Only thing I didn't understood here is Ratio column. Can you elobarate?

 

[phildunphy]

Thats a big list. Must have been hard to compile.

Only thing I didn't understood here is Ratio column. Can you elobarate?

The ratio column has formatting issues where Google sheets assumes data format, make a copy and change to Number format it works well.

 

[sleepysurya]

Thats a big list. Must have been hard to compile.

Only thing I didn't understood here is Ratio column. Can you elobarate?

What @phildunphy mentioned - I had copied from other sheet and totally missed it. Corrected it now

 

[CMG]

Are you doing this manually or using a scraper?

 

[sleepysurya]

Are you doing this manually or using a scraper?

Currently manually, was planning to have a scraper in the future to keep things up to date - similar to what you shared in other thread ( https://maxmypoint.com/)

 

[CMG]

Currently manually, was planning to have a scraper in the future to keep things up to date - similar to what you shared in other thread ( https://maxmypoint.com/)

Do you have scraper development experience?

 

[sleepysurya]

Do you have scraper development experience?

I had done very basic thing a lot of years ago.

 

[sam609619]

Superb

 

[codenerd]

This is an amazing initiative. Really helpful! Thanks a lot.
Please just cinfirm if we use points, then do we still need to pay taxes extra ?

 

[saurabhduasd]

This is an amazing initiative. Really helpful! Thanks a lot.
Please just cinfirm if we use points, then do we still need to pay taxes extra ?

On some hotels like Accor taxes are payable via points

 

[Deleted member 9785]

Indonesia bali marriot is VFM

 

[Deleted member 9785]

please suggest some marriot hotels in Bali which have good Value per point

 

[CMG]

please suggest some marriot hotels in Bali which have good Value per point

Name	Value in cents (USD)	Median points
Mandapa, a Ritz-Carlton Reserve	0.9¢	114,000​
Four Points by Sheraton Bali, Ungasan	0.8¢	6,000​
Element Bali Ubud	0.7¢	12,500​
The Westin Resort & Spa Ubud, Bali	0.7¢	29,000​
The Laguna, a Luxury Collection Resort & Spa, Nusa Dua, Bali	0.7¢	37,000​
The St. Regis Bali Resort	0.7¢	95,500​
W Bali - Seminyak	0.7¢	57,600​
Fairfield by Marriott Bali Legian	0.7¢	7,500​
The Ritz-Carlton, Bali	0.6¢	53,000​
Courtyard Bali Seminyak Resort	0.5¢	27,000​
The Stones Hotel - Legian Bali, Autograph Collection	0.5¢	28,000​
Four Points by Sheraton Bali, Seminyak	0.5¢	16,500​
Sthala, a Tribute Portfolio Hotel, Ubud Bali	0.5¢	17,500​
Le Méridien Bali Jimbaran	0.5¢	24,000​
Courtyard Bali Nusa Dua Resort	0.4¢	27,000​
Fairfield by Marriott Bali Kuta Sunset Road	0.4¢	12,000​
Aloft Bali Kuta	0.4¢	18,000​
Sheraton Senggigi Beach Resort	0.4¢	17,000​
Four Points by Sheraton Bali, Kuta	0.4¢	18,500​
Aloft Bali Seminyak	0.4¢	17,500​
Sheraton Bali Kuta Resort	0.4¢	38,000​
The Westin Resort Nusa Dua, Bali	0.4¢	34,000​

Taken from maxmypoint