Go Back   FlyerTalk Forums > Miles&Points > Discontinued Programs/Partners > US Airways 2011 Grand Slam Promotion
Sign in using an external account

Reply
 
Thread Tools Search this Thread
Old Aug 24, 11, 11:53 am   #1
 
Join Date: May 2008
Location: Pittsburgh, PA
Programs: US-CP, UA-PremSilver, DL-Silver, Marriott-Plat, SPG-Gold, Hilton-Gold, IC-Plat
Posts: 99
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.

Grand Slam Tracking Spreadsheet v1.6

Grand Slam Tracking Spreadsheet v1.3+++ by Spiffster (big thank you to Spiffster for making some great updates)

Changelog:
8/24/11 - v1.0: Initial Release

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.

9/18/11 - v1.6: Removed WORLDHOTELS comment that referenced Starwood, Fixed cells cells F31-F37 (hotel hits logic).

sH

Last edited by silverhalide; Oct 12, 11 at 9:13 pm. Reason: added Spiffster's link
silverhalide is offline   Reply With Quote
Old Aug 24, 11, 12:29 pm   #2
 
Join Date: Sep 1999
Location: Charlotte, NC USA
Programs: USAir CP, SPG Plat
Posts: 4,510
Brilliant. Thank you.
__________________
Dingo
dingo is offline   Reply With Quote
Old Aug 24, 11, 12:56 pm   #3
 
Join Date: Oct 2009
Location: IAH
Posts: 189
Thanks
udaykiran82 is offline   Reply With Quote
Old Aug 24, 11, 12:56 pm   #4
 
Join Date: Aug 2011
Location: New Jersey
Programs: Marriott Platinum, UA Silver, Hertz FS
Posts: 830
Thank you!
maksimfa is offline   Reply With Quote
Old Aug 24, 11, 1:59 pm   #5
 
Join Date: Jan 2011
Posts: 539
Thanks!
Yinzer is offline   Reply With Quote
Old Aug 24, 11, 3:05 pm   #6
 
Join Date: Nov 2010
Posts: 439
Sweet! Thanks.
NewArrival is offline   Reply With Quote
Old Aug 24, 11, 3:23 pm   #7
 
Join Date: Mar 1999
Location: San Diego, CA
Posts: 26
Another Thank You!
Megcom is offline   Reply With Quote
Old Aug 24, 11, 3:53 pm   #8
 
Join Date: May 2006
Programs: AA EXP, Priority Club Platinum
Posts: 83
Bugs

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.
Franklybrit is offline   Reply With Quote
Old Aug 24, 11, 4:07 pm   #9
 
Join Date: Sep 2010
Location: HAJ, Germany
Programs: HHonors Diamond, Priority Club Platin, Club Carlson Gold, LH SEN, A3*G, FB Gold
Posts: 288
Thanks for the original
maxbluebrosche is offline   Reply With Quote
Old Aug 24, 11, 4:31 pm   #10
 
Join Date: May 2008
Location: Pittsburgh, PA
Programs: US-CP, UA-PremSilver, DL-Silver, Marriott-Plat, SPG-Gold, Hilton-Gold, IC-Plat
Posts: 99
Thumbs up bug fixed, comments noted

Quote:
Originally Posted by Franklybrit View Post
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.

sH
silverhalide is offline   Reply With Quote
Old Aug 24, 11, 5:28 pm   #11
 
Join Date: Sep 2006
Location: PHL
Programs: US Gold
Posts: 4,879
You, you, you are very good, you!!
__________________
My incredible photo trip report in OZ/TG/LX F: The departure and the return.
tommyleo is offline   Reply With Quote
Old Aug 24, 11, 5:32 pm   #12
 
Join Date: Jul 2009
Location: Connecticut
Programs: Marriott Rewards-Platinum, Priority Club-Platinum StarWood-Gold, United-Silver
Posts: 368
Quote:
Originally Posted by silverhalide View Post
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.

Grand Slam Tracking Spreadsheet v1.1


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.
nickfromct is offline   Reply With Quote
Old Aug 24, 11, 5:36 pm   #13
 
Join Date: Oct 2006
Programs: UA, bmi, AA, CO, DL, B6, AMEX, Hertz, Most Hotels
Posts: 2,783
Quote:
Originally Posted by nickfromct View Post
You provide a great service for everyone participating in Grans Slam. Thank You.
adding my heartfelt +1

THANKS silverhalide
bk3day is offline   Reply With Quote
Old Aug 24, 11, 6:25 pm   #14
 
Join Date: Aug 2011
Location: Pittsburgh
Posts: 71
This is awesome and way more elegant than what I was going to do. Thanks!!
marshlight is offline   Reply With Quote
Old Aug 24, 11, 6:36 pm   #15
 
Join Date: Dec 2009
Location: Chicagoland
Programs: AA EXP
Posts: 242
Thanks!

Having one of these last year was sooo incredibly helpful. Thanks!
CubsGirl is offline   Reply With Quote
 
 
Reply

Bookmarks


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off
Forum Jump


All times are GMT -6. The time now is 10:04 pm.