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 |