AA Elite Status Qualification 2013

So to keep things organized, I started a chaotic spreadsheet back in 2012 to keep track of all my flights to make sure I was on track for Platinum and also help me calculate CPM and evaluate options between different marathons in different states. I streamlined this spreadsheet for 2013 and helped me keep track of total miles flown and RDM to make sure everything posted properly:

Most of my trips only required 4 legs so that’s how i broke them down. Sometimes, there are separate EQM or EQP earning ratios on the different legs so I had to break them out separately.

Here is my chart for 2013:

Leg 1 Leg 2 Leg 3 Leg 4 Miles Flown EQM RDM EQP Cost CPM Total Flown Total EQM
Trip 1 BOS-NRT-PVG-LAX-JFK 6701 1118 6485 2475 16779 16,444 36,130 17,909 16779 16443.6
Trip 2 PVG-HKG-BKK-HKG-PVG 779 1049 1049 779 3656 3,656 7,312 5,484 20435 20099.6
Trip 3 JFK-LHR-JNB-LHR-JFK 3451 5621 5621 3451 18144 18,144 36,288 18,144 980 5.40 38579 38243.6
Points BOS-SJU-STT-MIA-BOS 1674 68 1107 1258 4107
Trip 4 JFK-DFW-SCL-MIA-JFK 1391 4869 4118 1090 11468 11,468 26,423 14,955 951 8.29 54154 49711.6
Trip 5 BOS-MIA-GIG 2258 4163 4163 2367 12951 12,951 25,902 6,476 642 4.96 67105 62662.6
Jetblue BOS-IAD 413 413
Points IAD-LAX-PPT-HNL-SAN-BOS 2288 4095 4344 2588 13315
Trip 6 BOS-DFW-SEA-ANC 1562 3108 3108 1562 9340 9,340 18680 4,670 428 4.58 90173 72002.6
Trip 7 BDL-LAX-SFO 2527 500 500 2527 6054 6,054 17162 3,027 302 4.99 96227 78056.6
Trip 8 BDL-LAX 2527 2527 5054 5054 15162 2,527 278 5.50 116568 83110.6
Trip 9 BOS-ORD 867 867 1734 1,734 3468 867 190 10.96 103015 84844.6
Trip 10 BOS-DFW-PDX-LAX-BOS 1562 1616 834 2611 6623 6,623 13246 3,312 280 4.23 116568 91467.6
Points BOS-CDG 3448 3448
Trip CDG-DUB 489 489 90
Points DUB-BOS 2993 2993
Trip 11 JFK-HEL-MAD-HEL-JFK 4117 1833 1833 4117 11900 11,900 23800 5,950 631 5.30 128468 103367.6
Total 128,468 103,368 215,578 83,320
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s