Hi Howard,
Do you have a sample Excel template for keeping track of: a. miles driven, b. miles pulling 5er, c. MPG truck only, d. MPG towing, ETC, ETC.
Thanks for any info,
Ken Pace
Howard said
10:25 AM Jul 7, 2007
Ken,
I do have a spreadsheet for miles driven - towing, not towing, and total. I wouldn't exactly call it a "template" in that it is not just something anyone could just plug numbers into. Folks would have to know just a little bit about formulas.
But I'll be happy to send it to anyone that wants it.
I don't have a spreadsheet for MPG towing and not towing. I just get thay info from the truck's computer on each trip. I do calculate the total average MPG at the end of the year using my mileage spreadsheet and my fuel purchases spreadsheet.
I am tracking fuel purchases and average price per gallon for each year and for our entire travels. I'll send thatspreadsheet to anyone that wants it as well.
Digitog41 said
10:30 AM Jul 8, 2007
Howard, That would be great. I can figure out the formulas but I'd like to see how you set up the sheet. (Catagories, line items, etc.) Thanks, Ken
digitoh41@insightbb.com
-- Edited by Digitog41 at 11:33, 2007-07-08
Fordiesel250 said
06:31 PM Jan 7, 2008
Howard I sure would like the spreadsheet on tracking mileage and towing mpg. Thanks and keep up the good work. I have learned more from your forum and journal than almost any other website.
pierreandcolleen said
01:50 PM Jan 8, 2008
Howard,
I would like that excel file as well.
Thanks a bunch!
Colleen
mail@colleenandpierre.com
Howard said
06:55 AM Jan 10, 2008
Ford & Colleen,
I'll get those out to you soon. Sorry for the delay.
ahoweth said
08:41 AM Jan 10, 2008
I was at a local Sam's club the other day and I stopped to play a little on one of the desk top computers they had there on display. It had the Microsoft Vista system on it and also had the Microsoft Works software. As a part of the Works software there is a spread sheet program that has a number of templates to chose from when opening a new file. One of those it a spread sheet template for tracking mileage, mpg, etc. I really liked it. I think Howard has a new machine with Vista and Microsoft works on it if I remember. It wouldn't do you any good if you don't have Vista or Works on your machine but if you stop by a store and check out the template you might get some good ideas on how to set one up for yourself in Excel or what ever spread sheet software you might be using. I got some good ideas from it.
bjoyce said
11:05 AM Jan 10, 2008
ahoweth: Thanks for pointing that out. I have a new Dell Vostro 1500 running Windows XP and it came with Works, so you don't need Vista to run Works. I hadn't looked at Works until you said it had templates since I have installed Office 2003. Looks like useful templates come with Works.
jcw said
05:30 PM Jan 21, 2008
Howard wrote:
Ken,
I do have a spreadsheet for miles driven - towing, not towing, and total. I wouldn't exactly call it a "template" in that it is not just something anyone could just plug numbers into. Folks would have to know just a little bit about formulas.
But I'll be happy to send it to anyone that wants it.
I am tracking fuel purchases and average price per gallon for each year and for our entire travels. I'll send thatspreadsheet to anyone that wants it as well.
I do have a spreadsheet for miles driven - towing, not towing, and total. I wouldn't exactly call it a "template" in that it is not just something anyone could just plug numbers into. Folks would have to know just a little bit about formulas.
But I'll be happy to send it to anyone that wants it.
I don't have a spreadsheet for MPG towing and not towing. I just get thay info from the truck's computer on each trip. I do calculate the total average MPG at the end of the year using my mileage spreadsheet and my fuel purchases spreadsheet.
I am tracking fuel purchases and average price per gallon for each year and for our entire travels. I'll send thatspreadsheet to anyone that wants it as well.
That would be great. I can figure out the formulas but I'd like to see how you set up the sheet. (Catagories, line items, etc.)
Thanks,
Ken
digitoh41@insightbb.com
-- Edited by Digitog41 at 11:33, 2007-07-08
I would like that excel file as well.
Thanks a bunch!
Colleen
mail@colleenandpierre.com
Ford & Colleen,
I'll get those out to you soon. Sorry for the delay.
Howard,
Please send those my way, if you don't mind.
thx...
jcw3rd@mac.com