Given the complete opacity of Marriott spend and point tracking, I was thinking we can start a shared thread for tracking methods and templates. To that end, attached is a tracker spreadsheet I put together. Please feel free to comment/extend/criticize/help as you see fit.

Tab 1 : Dashboard - This is a running count of points (including a spot to include starting balance and redemptions) as well as spend towards Ambassador
Tab 2 : Data - This is where the data is entered

1. Yellow tabs are for informational tracking only
2. Orange tabs are used for calculation
   1. Status - Based on selection, the point bonus is applied
   2. Brand - This lookup will determine the point multiplier (eg. 10 for Marriott vs 5 for Residence Inn)
   3. Base Spend - Sum of room rate
   4. Ancillary Spend - F&B etc.
   5. MAGC - Number of days of Make a Green Choice selected
   6. Bonus (Y/N) - For Platinum and up, this is the 1000 point welcome benefit.
3. Gray tabs are calculated/tracked
   1. Tax Rate is informational. It turns red on > 20% to assist as a data entry validation check/prevent miskeys.

Your thoughts and/or other tracking methods are appreciated!