FlyerTalk Forums - View Single Post - Any way to calculate spend from this MP data?
Old Nov 12, 2023 | 12:41 pm
  #1  
avi8tir
10 Countries Visited
20 Countries Visited
30 Countries Visited
20 Years on Site
 
Join Date: Mar 2004
Location: LAX IAH AMS
Programs: UA GS 2MM
Posts: 1,431
Any way to calculate spend from this MP data?

I contacted MP today to get as much history as they had from my MP account. I already have everything back to 2013 -- with only 2019 missing. I contacted them via the chat function (first time using this) and they were able to help and I had the files in about 10 minutes to my email.

So, going through and trying to incorporate the 2019 file into my master excel file and I am a bit stumped. I cant remember what the rules/metrics were back in 2019. The columns that are in the file are: date, description, award miles base miles (yes, this is grouped as 1 column), bonus miles, total miles, premier qualification miles, segments.

I am trying to get the spend data.... for 2019, were any of these columns a calculation based on spend? For examples, are PQMs base fare multiplied by 11.... or something like this.

FYI, I was GS in 2019 which should be a factor in any calculation.
avi8tir is offline