FlyerTalk Forums - View Single Post - AS Status Calculator Tool
View Single Post
Old Jul 18, 2017, 3:18 pm
  #10  
Rich Boykin
 
Join Date: Nov 2014
Programs: AS MVP Gold 75K
Posts: 102
Originally Posted by rune87
Is there a way to edit the sheet to change the EQM assumption? Right now it assumes you meet based on partners and Alaska. What if all you fly is Alaska metal and no partners? Otherwise very nice work.
Edit the level values in the calculated field in cell I10 - the value for each status after the ">" character. This should cascade down the rest of the table and update the rest of the fields in column I.

20k, 40k, 75k for AS only
25k, 50k, 90k for AS + partners
Rich Boykin is offline