Un-Official 2011 Grand Slam Tracking Spreadsheet (v1.0)
Below find a link to the un-official 2011 Grand Slam Tracking Spreadsheet. I distributed this last year and a lot of people found it helpful so I updated it and am posting it again for everyone to use. Please report any bugs or issues in this thread and I will do my best to correct them ASAP.
8/24/11 - v1.1: Fixed calculation in G10:19 doesn't capture all of the cells F10:19, changed Radisson Gold Points Plus to Club Carlson (N.B.: DM terms are not consistent with this. Stated differently between "Convert hotel points to miles" section and "Here's how you can earn hits: Item 5" section).
8/29/11 - v1.2: Added Changelog tab, Added La Quinta Inns & Suites to Hotels, Added LQ RewardsŪ (La Quinta Inns & Suites) to Hotel Point Conversion, Renamed Radisson to Club Carlson, Removed ADT Security, Added RealEstate.com, Renamed ShareBuilder to ING Direct - ShareBuilder, Added "Important Restrictions" section, Added comments to "subscription partner" hits, Added misc. comments to single hit partners, and Performed general cleanup.
9/12/11 - v1.3: Added Twitter hit.
9/14/11 - v1.4: Added back the auto-populate function for hits, removed LQ Rewards.
9/15/11 - v1.5: CPM is now Cost Per Mile, Clarified bonus miles list.
Just a couple of bugs and changes I might suggest;
The calculation in G10:19 doesn't capture all of the cells F10:19
Raddison Gold Points Plus is now Club Carlson
As a suggestion if you have lots of time on your hands you could possibly code in the minimum earning criteria for hotel stays and points transfers, but as I'm not able to offer to do for you, I can hardly request it either!
Thanks for the effort - I used it last year to great success, and hopefully the same again this year.
Just a couple of bugs and changes I might suggest;
The calculation in G10:19 doesn't capture all of the cells F10:19
Raddison Gold Points Plus is now Club Carlson
As a suggestion if you have lots of time on your hands you could possibly code in the minimum earning criteria for hotel stays and points transfers, but as I'm not able to offer to do for you, I can hardly request it either!
Thanks for the effort - I used it last year to great success, and hopefully the same again this year.
Thank you for reporting the bug and your kind words. A new version has been uploaded and a changelog added to the first post. I don't have time right now to code the earning criteria in but I like the concept.
Programs: True Blue Marriott Rewards-Platinum, Priority Club-Platinum StarWood-Gold and Most of the Others
Posts: 307
Quote:
Originally Posted by silverhalide
Below find a link to the un-official 2011 Grand Slam Tracking Spreadsheet. I distributed this last year and a lot of people found it helpful so I updated it and am posting it again for everyone to use. Please report any bugs or issues in this thread and I will do my best to correct them ASAP.
Changelog:
8/24/11 - v1.0: Initial Release
8/24/11 - v.1.1: Fixed calculation in G10:19 doesn't capture all of the cells F10:19, changed Radisson Gold Points Plus to Club Carlson (N.B.: DM terms are not consistent with this. Stated differently between "Convert hotel points to miles" section and "Here's how you can earn hits: Item 5" section).
sH
You provide a great service for everyone participating in Grans Slam. Thank You.
bug fixed, comments noted
