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:
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:
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. 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.
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.
Quote:
You also have Premier Executive outranking 1K on UA.
I did consider creating ain interface where you could enter all your status levels and then it would only show those. I decided against it due to complexities in storing the profile info, plus I really don't want that info in my systems if I can avoid it from a privacy perspective. I like the idea of splitting it by airline; I'll look into making that happen. Originally Posted by mahasamatman
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.
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!
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!
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?
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.
Quote:
25% bonus = 8300.
This is an LH flight (the only non-stop carrier on that route). That is where the 25% across the board comes from.Originally Posted by IluvSQ
If the flight was on LH, then all three levels who selected the bonus miles would get25% bonus = 8300.
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.
Quote:
No, I'm not. Is anyone else?? Originally Posted by Jasper2009
Btw are you sure COS bonus on AC is only RDM, not EQM?
Quote:
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)Originally Posted by sbm12
No, I'm not. Is anyone else??
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)
Ah man this is awesome
^^^
^^^
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.
Quote:
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.
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.Originally Posted by Markie
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.
Quote:
Understand! Perhaps a key saying what red means would be sufficient?Originally Posted by sbm12
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.
Quote:
I guess I can move the "Notes" to above the table from below it. Originally Posted by Markie
Understand! Perhaps a key saying what red means would be sufficient?