An answer to "Which program should I credit a flight to?"
Jun 21, 2011 | 6:04 pm
#1
Original Poster
A FlyerTalk Posting Legend
Join Date: Apr 2001
Location: PSM
Posts: 69,232
An answer to "Which program should I credit a flight to?"
Right now it is just an answer, not the answer, but I'm working on that. 
I've got a whole ton of data about earning rates for 6 of the 27ish carriers in *A right now. Today's project was to create an interface where any particular route/fare/operating carrier combination could be input and it would calculate the various earning permutations. Especially at the very high and very low fares the earning rates can vary wildly so being able to compare them was something I thought was useful. Here's an example of an F fare from FRA-MCO:
Right now I've got data from AC, A3, BD, US, UA and CO in there and I'm working on adding more. Give it a look and let me know if you see anything wonky or if you think it is a complete waste of time. 
http://www.wandr.me/Tools/Frequent_F...g_Options.aspx
Sorry the "export" formatting sucks; I guess I'll add that to the bug list for now.
I've got a whole ton of data about earning rates for 6 of the 27ish carriers in *A right now. Today's project was to create an interface where any particular route/fare/operating carrier combination could be input and it would calculate the various earning permutations. Especially at the very high and very low fares the earning rates can vary wildly so being able to compare them was something I thought was useful. Here's an example of an F fare from FRA-MCO:
Code:
Carrier Status Base EQMs RDMs A3 Gold 4743 14229 14229 A3 Blue 4743 14229 14229 A3 General Member 4743 14229 14229 AC Super Elite 4743 7114 8300 AC Elite 4743 7114 8300 AC Prestige 4743 7114 8300 AC General Member 4743 7114 8300 BD Blue 4743 14229 14229 BD Gold 4743 14229 15415 BD Silver 4743 14229 15415 CO General Member 4743 7114 7114 CO General Member+PresPlusCC 4743 7114 7114 CO Silver Elite 4743 7114 8300 CO Silver Elite+PresPlusCC 4743 7114 8300 CO Platinum Elite+PresPlusCC 4743 7114 11858 CO Pres. Platinum+PresPlusCC 4743 7114 11858 CO Gold Elite+PresPlusCC 4743 7114 11858 CO Presidential Platinum 4743 7114 11858 CO Platinum Elite 4743 7114 11858 CO Gold Elite 4743 7114 11858 UA General Member 4743 7114 7114 UA Premier 4743 7114 8300 UA 1K 4743 7114 11858 UA Premier Executive 4743 7114 11858 US Chairmans Preferred 4743 7114 7114 US Platinum Elite 4743 7114 7114 US Gold Elite 4743 7114 7114 US Silver Elite 4743 7114 7114 US General Member 4743 7114 7114
http://www.wandr.me/Tools/Frequent_F...g_Options.aspx
Sorry the "export" formatting sucks; I guess I'll add that to the bug list for now.
Jun 21, 2011 | 6:53 pm
#2
A FlyerTalk Posting Legend
Join Date: Apr 2004
Location: GVA (Greater Vancouver Area)
Programs: D.R.E.A.D. Gold card holder
Posts: 53,184
Looks pretty good, but it might be a case of information overload. Most people only care about one status per airline (if they even care about that airline), though that would greatly complicate the interface. Adding a separator between the airlines would help to process the information, as would merging the cells using ROWSPAN.
You also have Premier Executive outranking 1K on UA.
You also have Premier Executive outranking 1K on UA.
Jun 21, 2011 | 7:47 pm
#3
Original Poster
A FlyerTalk Posting Legend
Join Date: Apr 2001
Location: PSM
Posts: 69,232
Looks pretty good, but it might be a case of information overload. Most people only care about one status per airline (if they even care about that airline), though that would greatly complicate the interface. Adding a separator between the airlines would help to process the information, as would merging the cells using ROWSPAN.
You also have Premier Executive outranking 1K on UA.
You also have Premier Executive outranking 1K on UA.
As for the "rankings" they are not purposefully sorted by status levels within each program; that's just how they happen to be in the database. I can try to address that, though bad data is my primary focus right now.
Thanks for the feedback!
Jun 21, 2011 | 10:45 pm
#4
Moderator: Hyatt Gold Passport & Star Alliance
Join Date: May 1998
Location: London, UK
Programs: UA-1K 3MM/HY- LT Globalist/BA-GGLfL
Posts: 12,761
sbm12 never ceases to amaze me with his solutions to help fellow FT's. I will be happy to make this a sticky at the appropriate time!
Jun 22, 2011 | 2:30 am
#5
In Memoriam
Join Date: May 2009
Location: FRA / YEG
Programs: AC Super Elite, Radisson Platinum, Accor Platinum
Posts: 11,873
Great work! ^
This tool will be particularly helpful to determine where to credit the so-called "discounted economy" booking classes as more and more booking classes only earn 50% miles or even 0 miles.
Btw are you sure COS bonus on AC is only RDM, not EQM?
This tool will be particularly helpful to determine where to credit the so-called "discounted economy" booking classes as more and more booking classes only earn 50% miles or even 0 miles.
Btw are you sure COS bonus on AC is only RDM, not EQM?
Last edited by Jasper2009; Jun 22, 2011 at 8:42 am
Jun 22, 2011 | 7:36 am
#6
Join Date: Sep 2005
Programs: AC MM E50 , Former SPG, now Marriott LT Plat
Posts: 6,698
Yes, your AC numbers look a bit wonky.
All AC members would earn the base mileage 4743, plus 50% COS for F =7114.
I don't see where you are getting the 8300 number from.
Depending on the airline flown, and the status of the member, and the options
selected, an AC member MIGHT get additional miles.
For example, a SE member who selected bonus miles option would get another 4743
( for a total of 11857) if the flight was on UA. An E member who selected the bonus miles
would get bonus 2371 miles, for total of 9485. A P member who selected the bonus
would get bonus 1186, for total of 8300 ( Ah - that is where the 8300 is coming from!)
If the flight was on LH, then all three levels who selected the bonus miles would get
25% bonus = 8300.
All AC members would earn the base mileage 4743, plus 50% COS for F =7114.
I don't see where you are getting the 8300 number from.
Depending on the airline flown, and the status of the member, and the options
selected, an AC member MIGHT get additional miles.
For example, a SE member who selected bonus miles option would get another 4743
( for a total of 11857) if the flight was on UA. An E member who selected the bonus miles
would get bonus 2371 miles, for total of 9485. A P member who selected the bonus
would get bonus 1186, for total of 8300 ( Ah - that is where the 8300 is coming from!)
If the flight was on LH, then all three levels who selected the bonus miles would get
25% bonus = 8300.
Jun 22, 2011 | 9:54 am
#7
Original Poster
A FlyerTalk Posting Legend
Join Date: Apr 2001
Location: PSM
Posts: 69,232
I also just added LH earning rates though I know there are some problems with the fixed earning rates within Europe not reflecting the 25% elite bonuses on LH group operated flights. I'm trying to figure that out.
No, I'm not. Is anyone else??
Jun 22, 2011 | 10:46 am
#8
In Memoriam
Join Date: May 2009
Location: FRA / YEG
Programs: AC Super Elite, Radisson Platinum, Accor Platinum
Posts: 11,873
Im almost certain the COS bonus is both EQM and RDM when the flight is credited to AC/AE (at least my last Z flight seems to have earnt 125% EQM and RDM)
E.g.
FRA-YYZ in AC J - booking class Z would earn 125% EQM and RDM = 4925 miles
FRA-YYZ in AC J - booking class J would earn 150% EQM and RDM = 5910 miles
Prestige/Elite/Super Elite bonus miles are only RDM and are based on the base miles (so + 0.25/0.5/1.0 x 3940 RDM miles)
FRA-YYZ in LH F - booking class A/F would earn 150% EQM and RDM = 5910 miles
(+ 25% RDM bonus based on base miles)
E.g.
FRA-YYZ in AC J - booking class Z would earn 125% EQM and RDM = 4925 miles
FRA-YYZ in AC J - booking class J would earn 150% EQM and RDM = 5910 miles
Prestige/Elite/Super Elite bonus miles are only RDM and are based on the base miles (so + 0.25/0.5/1.0 x 3940 RDM miles)
FRA-YYZ in LH F - booking class A/F would earn 150% EQM and RDM = 5910 miles
(+ 25% RDM bonus based on base miles)
Jun 23, 2011 | 10:55 pm
#11
Moderator: Hyatt Gold Passport & Star Alliance
Join Date: May 1998
Location: London, UK
Programs: UA-1K 3MM/HY- LT Globalist/BA-GGLfL
Posts: 12,761
Just a note on earning UA miles with LH within Europe:
Mileage accrual in T and L class on flights within Europe is only valid when in conjunction with a Lufthansa intercontinental flight. For flights only within Europe on Lufthansa, T and L class will not earn any mileage credit.
I don't know how you handle this but currently the system shows miles earned when they would not be.
Mileage accrual in T and L class on flights within Europe is only valid when in conjunction with a Lufthansa intercontinental flight. For flights only within Europe on Lufthansa, T and L class will not earn any mileage credit.
I don't know how you handle this but currently the system shows miles earned when they would not be.
Jun 24, 2011 | 7:12 am
#13
Original Poster
A FlyerTalk Posting Legend
Join Date: Apr 2001
Location: PSM
Posts: 69,232
Just a note on earning UA miles with LH within Europe:
Mileage accrual in T and L class on flights within Europe is only valid when in conjunction with a Lufthansa intercontinental flight. For flights only within Europe on Lufthansa, T and L class will not earn any mileage credit.
I don't know how you handle this but currently the system shows miles earned when they would not be.
Mileage accrual in T and L class on flights within Europe is only valid when in conjunction with a Lufthansa intercontinental flight. For flights only within Europe on Lufthansa, T and L class will not earn any mileage credit.
I don't know how you handle this but currently the system shows miles earned when they would not be.
Jun 24, 2011 | 8:34 pm
#14
Moderator: Hyatt Gold Passport & Star Alliance
Join Date: May 1998
Location: London, UK
Programs: UA-1K 3MM/HY- LT Globalist/BA-GGLfL
Posts: 12,761
The text should be red and if you hover over it you should see the fine print "Tickets wholly within Europe will earn no credit on this fare." I could display it as a 0 and add the fine print to say that it will earn 100% in conjunction with an intercontinental flight instead if folks think that's more accurate or a better way to see the data.