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

Brilliant. Thank you.

Thanks

Thank you!

Thanks!

Sweet! Thanks.

Another Thank You!

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.

Thanks for the original :) ^

bug fixed, comments noted
 

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

You, you, you are very good, you!! ^

You provide a great service for everyone participating in Grans Slam. Thank You.

adding my heartfelt +1^

THANKS silverhalide

This is awesome and way more elegant than what I was going to do. Thanks!!

Thanks!
 

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