Looking for Gas Mileage Template

I am new to numbers, and spread sheets in general. Is there a template for tracking gas mileage? The only one that I found (via Google) was:

Template: Fuel Milage Tracker for Apple iWork Numbers ’08

The problem is that the version of Numbers that I have (3.2) says "This spreadsheet can’t be opened because it’s too old. To open it, save it with Numbers '09 first.

I don't have Numbers '09. Any other template suggestions are humbly requested. Thank you!

Posted on Jul 15, 2014 3:53 PM

Reply
11 replies

Jul 16, 2014 8:29 AM in response to rjp49

I cant look at the list of travel expense calculators, but i did a search on google for MPG XL gas calculators and found that most (MS's own website sample specifically) says "You must fill up every time".


I did a quickie table in numbers that accounts for this, you simply check a box next to if you filled up the tank, and it has more columns that track "Miles since last fill up" or "Gallons since last fill up" and uses those for the calc over time.


Let me know if you want the file (I can post a screenshot later tonight if necessary)


Jason

Jul 16, 2014 12:55 PM in response to rjp49

we can't attach files to these posts, so I turned on email on my profile for today, Click my name above and you will have my email, send me a note and i will send you the file from my ipad.


I included a form for the ipad version which makes data entry easier, i think. When opened on OSX I dont think it shows up, so you will add rows to the table and make sure the formulas fill down.


I indicate which columns are formulas and which is data you enter as well so you don't have to hunt for which is which.


Thanks,

Jason

Jul 17, 2014 8:25 AM in response to jaxjason

(note for anyone visiting and looking for an explanation of my solution)


basically i added a chek box column for if you filled up the tank that stop or not.

I also added two other columns to track total mileage since fill up and total gallongs since fill up.

These two just look at the previous rows Check box, if it is checked (last time you filled up) it just uses the value from that row. Otherwise it takes the value from right above it (mileage looks at previous rows mileage since fillup) and adds the current rows numbers.


The MPG calculation only happens if the check box is true (checked) and then uses the Two extra column of "since fill up" to calc your MPG.


Jason

May 9, 2016 9:50 AM in response to srcamps

You're lucky i was looking over the support site and noticed you posted here.


Just for your information, you would have been better served to make a new posting, with a link to this one asking if anyone had the old file. A new unanswered question would get more views than a two year old post marked as answered.


I don't know if i still have that file or not from back then. I will look later, but need you to send me an email (click on my JaxJason name and click the email listed) so i can have your email to send to. We cannot attach files to these posts like this.


Thanks

Jason

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Looking for Gas Mileage Template

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.