Go Back  FlyerTalk Forums > Miles&Points > Discontinued Programs/Partners > US Airways 2011 Grand Slam Promotion
Reload this Page >

Un-Official 2011 Grand Slam Tracking Spreadsheet (v1.0)

Un-Official 2011 Grand Slam Tracking Spreadsheet (v1.0)

Old Aug 24, 11, 11:53 am
  #1  
Original Poster
 
Join Date: May 2008
Location: Pittsburgh, PA
Programs: AA-P, DL-Silver, Marriott-Plat, SPG-Plat, Hilton-Gold
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  
Old Aug 24, 11, 12:29 pm
  #2  
 
Join Date: Sep 1999
Location: Charlotte, NC USA
Programs: AA EXP; Marriott Lifetime / Annual Titanium; Massively Missing Starwood
Posts: 5,046
Brilliant. Thank you.
dingo is offline  
Old Aug 24, 11, 12:56 pm
  #3  
 
Join Date: Oct 2009
Location: IAH
Posts: 207
Thanks
udaykiran82 is offline  
Old Aug 24, 11, 12:56 pm
  #4  
 
Join Date: Aug 2011
Location: New Jersey
Programs: Delta P, SPG G, Marriott S, Hertz PC
Posts: 1,005
Thank you!
maksimfa is offline  
Old Aug 24, 11, 1:59 pm
  #5  
 
Join Date: Jan 2011
Posts: 539
Thanks!
Yinzer is offline  
Old Aug 24, 11, 3:05 pm
  #6  
 
Join Date: Nov 2010
Posts: 441
Sweet! Thanks.
NewArrival is offline  
Old Aug 24, 11, 3:23 pm
  #7  
 
Join Date: Mar 1999
Location: San Diego, CA
Posts: 30
Another Thank You!
Megcom is offline  
Old Aug 24, 11, 3:53 pm
  #8  
 
Join Date: May 2006
Programs: AA EXP, Priority Club Platinum
Posts: 89
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  
Old Aug 24, 11, 4:07 pm
  #9  
 
Join Date: Sep 2010
Location: HAJ, Germany
Programs: Honors Diamond, IHG Platinum Ambassador, Club Carlson Gold, LH SEN, TB Emerald
Posts: 309
Thanks for the original
maxbluebrosche is offline  
Old Aug 24, 11, 4:31 pm
  #10  
Original Poster
 
Join Date: May 2008
Location: Pittsburgh, PA
Programs: AA-P, DL-Silver, Marriott-Plat, SPG-Plat, Hilton-Gold
Posts: 99
Thumbs up bug fixed, comments noted

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  
Old Aug 24, 11, 5:28 pm
  #11  
 
Join Date: Sep 2006
Location: PHL
Programs: Former long-time US GP; now AA dirt
Posts: 4,903
You, you, you are very good, you!!
tommyleo is offline  
Old Aug 24, 11, 5:32 pm
  #12  
 
Join Date: Jul 2009
Location: Florida
Programs: Marriott Rewards-Platinum, Priority Club-Platinum StarWood-Platinum, Hilton-Gold, United-Silver
Posts: 392
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  
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,921
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  
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  
Old Aug 24, 11, 6:36 pm
  #15  
 
Join Date: Dec 2009
Location: Chicagoland
Programs: AA 1MM, Hyatt Diamond
Posts: 265
Thanks!

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

Thread Tools
Search this Thread