Looking for Gas Mileage Template

Then see this search result: travel expense spreadsheet templates most of which are free for use in Excel. They should be importable into Numbers.

Also, you can check out Templates for Numbers 1.8 and Suite for Numbers 1.1.

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

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

(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

Jason

I would also like to get this template. I've never used Numbers before and my RV navigator (wife) is looking for something for traveling. I like that you've added the since last fill-up option.

Thanks

Steve

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

Gas mileage is just miles traveled/gal. of gas used. One hardly needs a template for that.

But, the template that came with Numbers for the iPad a year or two ago was what the OP asked for and more. It was great. Not just a simple calculation.