Here is a link to a somewhat redacted version of mine:
https://docs.google.com/spreadsheets...it?usp=sharing
It has two sheets: 2018 and 2017. 2018 references the MM total from 2017 in order to keep that tally. 2017 has a hard-coded 200,000 in it for the starting MM balance.
It's had upgrades over the years, so I'm only going to explain 2018.
Column A is the AQS count. It determines what is an AQS by the existence of a value in the date field (column E). There are complicated reasons why I couldn't do it based on flight number that don't apply to most people.
Column B is the flight number. AC 739.
Column C is the route. YYZ-SFO
Column D is the upgrade. "No", "Advance", "Gate", "Operational", "Waitlisted". Column X has stats on these.
Column E is the date. The cell turns green when the date is in the past.
Column F is the description. I generally put the booking reference(s) here, as well as a description on what the trip is for.
Column G is the base AQM. Adam's spreadsheet is very handy for determining this. This counts for MM.
Column H is the non-COS bonus. This year, Comfort fares had a 100% AQM bonus. That goes in this column. This does not count for MM.
Column I is the COS bonus. The formula is "=ROUND(G5*0.5)" for a 50% bonus (the rounding matches how they credit it). This counts for MM.
Column J is a rolling AQM sum, showing your AQM total after taking this flight. It's useful for determining when you'll hit thresholds.
Column K is a rolling MM sum. This is generally less important unless you're right on the cusp.
Column L is the redeemable mile count for the flight. This is a formula like "=G24*2+H24+I24", meaning twice the base miles (because I'm SE and chose that privilege), plus the bonus, plus the COS. You'd need to adjust the *2 if you don't have the SE select privilege.
Column M is what's been credited to me. I put in "M" for miles and "M+B" for bonus. The color changes if it's not "M+B" to help me keep track. See the bottom of 2018 for an example.
Column N is the cost. I use USD for my information. This is purely for my own tracking purposes, and is independent of AQD.
Column O is the AQD. I generally just copy from the Altitude dashboard here once it posts, but I can also enter it ahead of time to get an idea of whether I'll hit the requirement (though I've never been concerned about that).
Column P is my CP(AQ)M. This requires the cost. I have color thresholds from back when I was much more into MRing. Under 5 US cpm gets me yellow, under 3 gets me green.
Column Q is my CP(Aeroplan)M. This also requires the cost. The thresholds are under 3 for yellow and under 2 for green.
Column R is the eUpgrade cost for that row. Positive number means I've spent that many, negative means I've earned that many.
Column S is my remaining eUpgrade credits. Very useful to determine if I'll be able to upgrade a flight later in the year.
Column T is a blank spacer.
Columns U-Y are just statistics from the sheet. How many AQS/AQM I am from each status level, upgrade stats, and AQM earned on different airlines.
Row 1 is a header, and row 2 is basically sums of the columns. Everything below that is data.
File -> Make a copy
Happy for feedback. This was never meant to apply to the masses, but I don't think it would be too difficult to allow specifying your bonus miles percentage, etc.