FlyerTalk Forums - View Single Post - An answer to "Which program should I credit a flight to?"
Old Jun 21, 2011 | 6:04 pm
  #1  
sbm12
A FlyerTalk Posting Legend
10 Countries Visited20 Countries Visited30 Countries Visited20 Years on Site
 
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:
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
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.
sbm12 is offline