Excel form for tracking & predicting total miles

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.

 

google sheets would work

 

Would it? In this case, we are only sharing the template. Individuals need to input their own data, non-publicly.

 

I think you have to create a template?
https://support.google.com/drive/answer/148817?hl=en

I don't know off the top of my head if you can create a copy only version of a file without making a template?
Thanks for sharing.

 

Thanks for looking into the Google templates. I'll try to create one and post the result here.

 

just create/share the template. then individuals will copy the file into their own "drive" account to input their info.

http://frequentmiler.boardingarea.com/fair-trading-prices/
https://docs.google.com/spreadsheets/d/1IzvG7c-oGydu35K0P_wTsxibsiM5vDrCkdOX1TddvZc/edit?usp=sharing

 

Was working on similar sheet this AM. Yours has more features and less manual labor

 

Here is the Google Drive template. Enjoy! http://tinyurl.com/UA-mile-calc