Excel form for tracking & predicting total miles

Discussion in 'United Airlines | MileagePlus' started by trobb49, May 25, 2015.  |  Print Topic

  1. trobb49

    trobb49 Silver Member

    Messages:
    106
    Likes Received:
    117
    Status Points:
    395
    This information was buried in another thread where some people might not have noticed it, so I'm posting it here.

    I've created a "quick 'n dirty" Excel spreadsheet that you can use to enter your future trips in order to see how many miles, PQMs, etc. you will end up with by yearend.

    Unfortunately, XLS files can't be uploaded to Milepoint, so I've placed it at the following URL.

    http://tomrobb.com/UA_Mileage_tracker.xls

    If I've missed some important factor required for accurate calculation, please post your comments here.
     
    iolaire, edekba, uggboy and 1 other person like this.
  2. edekba

    edekba Gold Member

    Messages:
    3,462
    Likes Received:
    3,783
    Status Points:
    2,145
    google sheets would work :)
     
  3. trobb49

    trobb49 Silver Member

    Messages:
    106
    Likes Received:
    117
    Status Points:
    395
    Would it? In this case, we are only sharing the template. Individuals need to input their own data, non-publicly.
     
  4. iolaire
    Original Member

    iolaire Gold Member

    Messages:
    3,510
    Likes Received:
    5,767
    Status Points:
    4,170
    trobb49 likes this.
  5. trobb49

    trobb49 Silver Member

    Messages:
    106
    Likes Received:
    117
    Status Points:
    395
    Thanks for looking into the Google templates. I'll try to create one and post the result here.
     
    iolaire likes this.
  6. edekba

    edekba Gold Member

    Messages:
    3,462
    Likes Received:
    3,783
    Status Points:
    2,145
    iolaire likes this.
  7. Dublin_rfk

    Dublin_rfk Gold Member

    Messages:
    4,220
    Likes Received:
    6,040
    Status Points:
    4,770
    Was working on similar sheet this AM. Yours has more features and less manual labor
     
  8. trobb49

    trobb49 Silver Member

    Messages:
    106
    Likes Received:
    117
    Status Points:
    395
    Here is the Google Drive template. Enjoy! http://tinyurl.com/UA-mile-calc
     
    iolaire likes this.

Share This Page