Hi Everyone. Well, after 15 years the RV-Dreams Community Forum is coming to an end. Since it began in August 2005, we've had 58 Million page views, 124,000 posts, and we've spent about $15,000 to keep this valuable resource for RVers free and open. But since we are now off the road and have settled down for the next chapter of our lives, we are taking the Forum down effective June 30, 2021. It has been a tough decision, but it is now time.


We want to thank all of our members for their participation and input over the years, and we want to especially thank those that have acted as Moderators for us during our amazing journey living and traveling in our RV and growing the RV-Dreams Family. We will be forever proud to have been founders of this Forum and to have been supported by such a wonderful community. Thank you all!!

Members Login
Username 
 
Password 
    Remember Me  
RV-Dreams.com Home -> RV-Dreams Community Forum -> Ask Howard -> Excel template for tracking mileage
Post Info TOPIC: Excel template for tracking mileage
Digitog41


RV-Dreams Community Member

Status: Offline
Posts: 14
Date:
Excel template for tracking mileage
Permalink  

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

__________________
Ken & Barb Pace
Howard


Host

Status: Offline
Posts: 1224
Date:
Permalink  

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


RV-Dreams Community Member

Status: Offline
Posts: 14
Date:
Permalink  

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

__________________
Ken & Barb Pace
Fordiesel250


RV-Dreams Family Member

Status: Offline
Posts: 31
Date:
Permalink  

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


RV-Dreams Family Member

Status: Offline
Posts: 285
Date:
Permalink  

Howard,

I would like that excel file as well.

Thanks a bunch!

Colleen

mail@colleenandpierre.com

__________________

Are we there yet?
http://www.colleenandpierre.wordpress.com/
Howard


Host

Status: Offline
Posts: 1224
Date:
Permalink  

Ford & Colleen,

I'll get those out to you soon.  Sorry for the delay.  smile



__________________
ahoweth


RV-Dreams Family Member

Status: Offline
Posts: 319
Date:
Permalink  

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.

__________________
Full timing since 1/1/2005
American Tradition & Jeep Wrangler
www.howethsjournal.blogspot.com
bjoyce


RV-Dreams Family Member

Status: Offline
Posts: 3721
Date:
Permalink  

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.


__________________

Bill Joyce,
40' 2004 Dutch Star DP towing an AWD 2020 Ford Escape Hybrid
Journal at http://www.sacnoth.com
Full-timing since July 2003
jcw


RV-Dreams Family Member

Status: Offline
Posts: 89
Date:
Permalink  

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.





Howard,

Please send those my way, if you don't mind.

thx...
jcw3rd@mac.com

__________________

JC and Beverly Webber III
SKP# 97125
2006 Country Coach 40' Inspire 360 DP
2008 Ford Escape Hybrid toad
2008 Honda Goldwing
Our Blog
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
RV-Dreams.com Home -> RV-Dreams Community Forum -> Ask Howard -> Excel template for tracking mileage
Tweet this page Post to Digg Post to Del.icio.us