FlyerTalk Forums - View Single Post - AS Status Calculator Tool
View Single Post
Old Jul 18, 2017, 4:01 pm
  #14  
Voldoo
 
Join Date: Dec 2016
Location: Saipan, MP
Programs: Marriott Ambassador, Hyatt Globalist, Hilton Diamond, Alaska 75K, United Platinum
Posts: 203
Originally Posted by 91foxbody
That helps a bit, but I think I'm still missing something. All of my flights will be on Alaska metal, so why would I need to meet the 25k instead of 20k threshold?
HI FoxBody,

You weren't doing anything wrong, I just hadn't created a way to calculate status based on AS flights only. The new version allows you to track your qualifications using either method now (AS vs. AS + partner flights).

Column I (Next Year Status) now calculates by calculating total EQM miles vs. total EQM AS-only miles and updates status level based on which threshold-level is reached first.

Please note Row 3 (Starting EQM Balances). Use Cells B3 & E3 to differentiate betwen starting EQM miles and starting AS EQM miles. Hope that makes sense!


EDIT: Thanks Rich!
Attached Images  

Last edited by Voldoo; Jul 18, 2017 at 4:32 pm Reason: Forget to add info
Voldoo is offline