FlyerTalk Forums - View Single Post - List of Hotels at 10,000 Points a Night
View Single Post
Old May 8, 2016 | 8:37 am
  #18  
scubaccr
10 Years on Site
 
Join Date: Sep 2012
Location: Amsterdam, Asia, UK
Programs: IHG RA (Spire), HH Diamond, MR Platinum, SQ Gold, KLM Gold, BAEC Gold
Posts: 5,072
Originally Posted by Yokdoc
genius! could you provide the modified spreadsheet for download?! thanks for sharing!
Loyaltylobby own the spreadsheet as it was their work to put it together, specfically at the time to show which hotels went up+down in points (thus 2 colums wih before/after points with colour coded lines to show which hotels stayed-same/cost-more/cost-less). You are invited to download from LL for your personal use. That was PDF only but update in April 2014 has excel version
The 2014 excel file already has headers that you need to sort columns on.

http://loyaltylobby.com/wp-content/u...l-16-2014.xlsx

As such I can't publish my personal unlocked and modified , sortable copy

Scripts to remove excel sheet locking are free and available via simple google search. It took me less than 10minutes to unlock the LL sheet, add headers and sort for my needs.

Actually, easier to just download and use freeware openoffice
(rather than use microsoft-office product and have to hack the sheet protection !)
a)Download
b)open with free software "OpenOffice"
c)remove sheet protection Tools->Protect Document->Sheet (untick sheets tick)
NO
d)Sort as desired Data->Sort
eg points, country, city
THEN
e)File->Save As
(input folder pather/file name xxxx.ods)

Last edited by scubaccr; May 8, 2016 at 10:10 am
scubaccr is offline