Go Back   > > >
 
 
Thread Tools Search this Thread
Old Jan 1, 06, 9:36 am   #1
FlyerTalk Evangelist
Original Poster
  
Join Date: Dec 2003
Location: Miami, FL
Programs: AA EXP/Marriott Plat/Hertz PC
Posts: 12,725
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
whirledtraveler is offline  
Old Jan 1, 06, 9:44 am   #2
Moderator, OneWorld
  
Join Date: Feb 2002
Location: SEA
Programs: RAA RIP; AA ExEXP
Posts: 8,897
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.
Gardyloo is offline  
Old Jan 1, 06, 10:05 am   #3
  
Join Date: Apr 2001
Location: DFW - AA EXP, SPG PLT, Hilton DIA, Hyatt - PLT, Hertz Prez
Posts: 779
Quote:
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.
You mean bring about World Peace?
ratnamg is offline  
Old Jan 1, 06, 11:02 am   #4
Moderator: American AAdvantage, Mexico, Technical Support and Feedback, The Suggestion Box and Talkboard Topics
  
Join Date: May 2000
Location: NorCal - SMF area
Programs: AA EXP / 5.5 MM; HH <>; SPG Gold; Maître-plongeur des Muccis
Posts: 56,001
You're confusing the posters - this one specializes in whirled peas.

Quote:
Originally Posted by ratnamg
You mean bring about World Peace?
JDiver is offline  
Old Jan 1, 06, 11:09 am   #5
  
Join Date: Jun 2005
Programs: AA EXP (3MM), MR Lifetime PLT, Avis First
Posts: 97
You forgot to list all of the co-authors!

http://www.improbable.com/airchives/..._rotation.html
patrick75248 is offline  
Old Jan 1, 06, 1:38 pm   #6
  
Join Date: Jan 2001
Location: Cambridge, MA - AA EXP 2MM
Posts: 2,569
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.
bedelman is offline  
Old Jan 1, 06, 2:03 pm   #7
uck
  
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??

Quote:
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.

Last edited by uck; Jan 1, 06 at 2:06 pm
uck is offline  
Old Jan 1, 06, 2:05 pm   #8
FlyerTalk Evangelist
  
Join Date: May 2000
Location: أمريكا
Posts: 25,202
You might want to change the text to year-to-day "miles" instead of "flights."
Doppy is offline  
Old Jan 1, 06, 2:17 pm   #9
  
Join Date: Jan 2001
Location: Cambridge, MA - AA EXP 2MM
Posts: 2,569
Good point. Thanks. Fixed.
bedelman is offline  
Old Jan 1, 06, 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
clacko is offline  
Old Jan 1, 06, 7:58 pm   #11
FlyerTalk Evangelist
Original Poster
  
Join Date: Dec 2003
Location: Miami, FL
Programs: AA EXP/Marriott Plat/Hertz PC
Posts: 12,725
Quote:
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.
Thanks! I've coded it in Excel also. The true value of the formula is when you use it to project forward. For instance, I have three international flights lined up for this year and a few domestics that I've planned in advance. When I put all of the flights that I'm aware of in the spreadsheet, I see that the last time that G(D) goes positive is in April. My first flight is Friday, and I'll be in negative territory until the return flight the next day. Then I go further into positive terrority with a transcon I'm taking next week.

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
whirledtraveler is offline  
Old Jan 2, 06, 12:04 am   #12
FlyerTalk Evangelist
  
Join Date: May 2004
Location: TPA/PIE
Programs: AA Lifetime PLT, HH Gold, DL/UA/AS Elite
Posts: 17,064
Quote:
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
This formula is for miles, correct. It doesn't seem to reflect the new 100 segment method.
mvoight is offline  
Old Jan 2, 06, 12:55 am   #13
  
Join Date: Jan 2001
Location: Cambridge, MA - AA EXP 2MM
Posts: 2,569
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.
bedelman is offline  
 


Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Forum Jump
Contact Us - FlyerTalk - Archive - Top