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, which was not shown here.
Click on the separate links above to see the different years.