Goal Deviation: A Key Metric in Measuring EXP Progress
Jan 1, 2006, 9:36 am
#1
FlyerTalk Evangelist
Original Poster
Join Date: Dec 2003
Location: Miami, FL
Programs: AA EXP/Marriott Plat/Hertz PC
Posts: 12,724
Goal Deviation: A Key Metric in Measuring EXP Progress
Abstract
Executive Platinum (EXP) status is desired by many frequent flyers. This paper will outline a metric, 'goal deviation', which can be used to assess and measure progress toward EXP status on a continual basis.
Body
Let P be the daily progress constant. We shall define P as 100,000 [1] divided by the number of days in a year (365). We can define our metric as follows. For any current number of miles M and a date D, the 'goal deviation' G is:
GD(D) = M - (P * E(D))
where E(D) is the number of days elapsed since the beginning of the year [2].
GD(D) reflects the number of miles needed to be "on track" with one's goal of meeting EXP status at the end of the year. When GD(D) is negative for a value of D, one must "catch up." If the value of GD(D) is positive, one has a "cushion" which indicates that one is above goal at that point in time.
Future Work
We have made a grant request to pursue the implementation of this formula as an Excel Macro. Our patent on this formula is pending. Interested parties should contact the authors for royalty terms.
References
[1] Russell and Whitehead, Principia Mathematica
[2] The Sumerian Calendar
Executive Platinum (EXP) status is desired by many frequent flyers. This paper will outline a metric, 'goal deviation', which can be used to assess and measure progress toward EXP status on a continual basis.
Body
Let P be the daily progress constant. We shall define P as 100,000 [1] divided by the number of days in a year (365). We can define our metric as follows. For any current number of miles M and a date D, the 'goal deviation' G is:
GD(D) = M - (P * E(D))
where E(D) is the number of days elapsed since the beginning of the year [2].
GD(D) reflects the number of miles needed to be "on track" with one's goal of meeting EXP status at the end of the year. When GD(D) is negative for a value of D, one must "catch up." If the value of GD(D) is positive, one has a "cushion" which indicates that one is above goal at that point in time.
Future Work
We have made a grant request to pursue the implementation of this formula as an Excel Macro. Our patent on this formula is pending. Interested parties should contact the authors for royalty terms.
References
[1] Russell and Whitehead, Principia Mathematica
[2] The Sumerian Calendar
Jan 1, 2006, 9:44 am
#2
Moderator, OneWorld
Join Date: Feb 2002
Location: SEA
Programs: RAA RIP; AA ExEXP
Posts: 11,802
While you're at it, could you figure out how to construct a wormhole that will accommodate an MD-80 and that will allow one to travel 100,000 miles instantaneously without having to transit Dallas? I'm sure there must be some experts in the field of quantum teleportation out there in FT land.
Jan 1, 2006, 10:05 am
#3
Join Date: Apr 2001
Location: DFW - AA EXP, SPG PLT, Hilton DIA, Hyatt - PLT, Hertz Prez
Posts: 787
Originally Posted by Gardyloo
While you're at it, could you figure out how to construct a wormhole that will accommodate an MD-80 and that will allow one to travel 100,000 miles instantaneously without having to transit Dallas? I'm sure there must be some experts in the field of quantum teleportation out there in FT land.
Jan 1, 2006, 11:02 am
#4
Moderator: American AAdvantage
Join Date: May 2000
Location: NorCal - SMF area
Programs: AA LT Plat; HH LT Diamond, Maître-plongeur des Muccis
Posts: 62,948
You're confusing the posters - this one specializes in whirled peas. 
Originally Posted by ratnamg
You mean bring about World Peace?
Jan 1, 2006, 11:09 am
#5
Join Date: Jun 2005
Programs: AA EXP (3MM), MR Lifetime PLT, Avis First
Posts: 97
Jan 1, 2006, 1:38 pm
#6
Join Date: Jan 2001
Location: Bellevue, WA - AA EXP 3MM
Posts: 2,756
Implemented!
Even better than an Excel macro, I think, is a web script. Nothing to download, nothing to install, no security risks.
So I implemented whirledtraveler's idea in a quick script.
Frequent Flier Goal Deviation Calculator
Comments welcome. Bug submissions are particularly helpful. (Email, via link on my page, may be more useful than numerous posts here.) I'm also happy to add more calculations -- just tell me what you'd like.
So I implemented whirledtraveler's idea in a quick script.
Frequent Flier Goal Deviation Calculator
Comments welcome. Bug submissions are particularly helpful. (Email, via link on my page, may be more useful than numerous posts here.) I'm also happy to add more calculations -- just tell me what you'd like.
Jan 1, 2006, 2:03 pm
#7
Join Date: Aug 2004
Location: Midwest
Posts: 65
That was quick!
Wow, thanks for the site!
By "Year-to-date flights" you actually mean "year-to-date miles", right??
By "Year-to-date flights" you actually mean "year-to-date miles", right??
Originally Posted by bedelman
Even better than an Excel macro, I think, is a web script. Nothing to download, nothing to install, no security risks.
So I implemented whirledtraveler's idea in a quick script.
Frequent Flier Goal Deviation Calculator
Comments welcome. Bug submissions are particularly helpful. (Email, via link on my page, may be more useful than numerous posts here.) I'm also happy to add more calculations -- just tell me what you'd like.
So I implemented whirledtraveler's idea in a quick script.
Frequent Flier Goal Deviation Calculator
Comments welcome. Bug submissions are particularly helpful. (Email, via link on my page, may be more useful than numerous posts here.) I'm also happy to add more calculations -- just tell me what you'd like.
Last edited by uck; Jan 1, 2006 at 2:06 pm
Jan 1, 2006, 2:05 pm
#8
FlyerTalk Evangelist
Join Date: May 2000
Location: أمريكا
Posts: 26,763
You might want to change the text to year-to-day "miles" instead of "flights."
Jan 1, 2006, 2:17 pm
#9
Join Date: Jan 2001
Location: Bellevue, WA - AA EXP 3MM
Posts: 2,756
Good point. Thanks. Fixed.
Jan 1, 2006, 2:30 pm
#10
In Memoriam
Join Date: Apr 2001
Location: dallas texas usa
Programs: aa plt 4.9MM LTAC
Posts: 14,828
i use a different method....
1 look at aadvantage summary on aa.com
2 determine the ytd mi/pt/segs
3 subtract from required minimums
4 figure out where to go, get ticket, fly, repeat
note, no calculator or differential equations needed.
happy new year
1 look at aadvantage summary on aa.com
2 determine the ytd mi/pt/segs
3 subtract from required minimums
4 figure out where to go, get ticket, fly, repeat
note, no calculator or differential equations needed.
happy new year
Jan 1, 2006, 7:58 pm
#11
FlyerTalk Evangelist
Original Poster
Join Date: Dec 2003
Location: Miami, FL
Programs: AA EXP/Marriott Plat/Hertz PC
Posts: 12,724
Originally Posted by bedelman
Even better than an Excel macro, I think, is a web script. Nothing to download, nothing to install, no security risks.
So I implemented whirledtraveler's idea in a quick script.
Frequent Flier Goal Deviation Calculator
Comments welcome. Bug submissions are particularly helpful. (Email, via link on my page, may be more useful than numerous posts here.) I'm also happy to add more calculations -- just tell me what you'd like.
So I implemented whirledtraveler's idea in a quick script.
Frequent Flier Goal Deviation Calculator
Comments welcome. Bug submissions are particularly helpful. (Email, via link on my page, may be more useful than numerous posts here.) I'm also happy to add more calculations -- just tell me what you'd like.
As the year goes on, I'll schedule more and more trips. I'll add them and be able to see just how far ahead (or behind) I am as time goes on.
My G(D) values look like this so far for the upcoming year:
0.00
-172.86
750.16
2818.19
3790.33
3118.63
4638.71
-5105.05
-3615.95
-1656.70
1946.38
617.96
4221.04
-6532.42
-3313.29
-10305.44
-10448.27
-30998.95
-29357.84
Jan 2, 2006, 12:04 am
#12
FlyerTalk Evangelist
Join Date: May 2004
Location: DFW/DAL
Programs: AA Lifetime PLT, AS MVPG, HH Diamond, NCL Platinum Plus, MSC Diamond
Posts: 21,422
Originally Posted by whirledtraveler
Abstract
Executive Platinum (EXP) status is desired by many frequent flyers. This paper will outline a metric, 'goal deviation', which can be used to assess and measure progress toward EXP status on a continual basis.
Body
Let P be the daily progress constant. We shall define P as 100,000 [1] divided by the number of days in a year (365). We can define our metric as follows. For any current number of miles M and a date D, the 'goal deviation' G is:
GD(D) = M - (P * E(D))
where E(D) is the number of days elapsed since the beginning of the year [2].
r
Executive Platinum (EXP) status is desired by many frequent flyers. This paper will outline a metric, 'goal deviation', which can be used to assess and measure progress toward EXP status on a continual basis.
Body
Let P be the daily progress constant. We shall define P as 100,000 [1] divided by the number of days in a year (365). We can define our metric as follows. For any current number of miles M and a date D, the 'goal deviation' G is:
GD(D) = M - (P * E(D))
where E(D) is the number of days elapsed since the beginning of the year [2].
r
Jan 2, 2006, 12:55 am
#13
Join Date: Jan 2001
Location: Bellevue, WA - AA EXP 3MM
Posts: 2,756
You can use my site to track your progress vis-a-vis the 100 segment qualification. Choose 100,000 as your end-of-year goal. Then, in the box labeled "Year-to-date miles", enter your year-to-date segments times 1000. So if you've flown seven segments year-to-date, enter 7000.
In the resulting analysis, replace "miles" with segments, and divide all numbers by 1000. So if the program reports "you are 2,254 miles ahead of your goal", that means "you are 2.25 segments ahead of your goal."
That should address your needs in the short run. If demand warrants, I can revise the system to include a more intuitive segment analysis.
In the resulting analysis, replace "miles" with segments, and divide all numbers by 1000. So if the program reports "you are 2,254 miles ahead of your goal", that means "you are 2.25 segments ahead of your goal."
That should address your needs in the short run. If demand warrants, I can revise the system to include a more intuitive segment analysis.