Electronic mileage log .. - BMW Luxury Touring Community
 
LinkBack Thread Tools Display Modes
post #1 of 4 Old Apr 17th, 2008, 11:30 am Thread Starter
Senior Member
 
BallsCasten's Avatar
 
Join Date: May 2006
Location: Johnston, Iowa, USA
Posts: 187
Electronic mileage log ..

Does anyone have a mileage log in excel? Or any electronic version for that matter.
Would like to track total mles, day left in mileage contest, etc etc

Doug
'05 K1200LT,
My dog is very selective where he will pee, yet he will poop anywhere. In that regard; we couldnít be more different.
BallsCasten is offline  
Sponsored Links
Advertisement
 
post #2 of 4 Old Apr 17th, 2008, 2:31 pm Thread Starter
Senior Member
 
BallsCasten's Avatar
 
Join Date: May 2006
Location: Johnston, Iowa, USA
Posts: 187
Re: Electronic mileage log ..

Ok I imagine this is easy for the computer folks. It took all of 1 minute for our computer guys to type. But challenged as I am with spreadsheets, I think this is kind of cool.

http://www.partydocks.com/bmw/mileage%20contest1.5.xls

This excel spreadsheet is setup to track my mileage for the mileage contest.
Hit ctrl+; to insert the date in the first cell, any comments about the ride. Then enter starting and ending mileage for your trip.

Then you automatically get trip miles, total mileage from the start of the contest, mileage to goal, % of your target left, days remaining in the contest and the daily average per day you need to ride to reach you goal.

You would just need to change the formulas a bit to reflect your starting mileage and your goal.

Doug
'05 K1200LT,
My dog is very selective where he will pee, yet he will poop anywhere. In that regard; we couldnít be more different.
BallsCasten is offline  
post #3 of 4 Old Apr 17th, 2008, 5:28 pm
Senior Member
 
cfell's Avatar
 
Join Date: Apr 2004
Location: Round Rock, TX, USA
Posts: 7,794
Re: Electronic mileage log ..

Doug..
Since you created this, maybe you want to post it in the Gallery.. under "Files"?

...............
J.M.J...
Dcn Channing

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
cfell is offline  
 
post #4 of 4 Old Apr 18th, 2008, 9:34 am Thread Starter
Senior Member
 
BallsCasten's Avatar
 
Join Date: May 2006
Location: Johnston, Iowa, USA
Posts: 187
Re: Electronic mileage log ..

Thanks to Graham (sorry Graham I didnít catch your screen name) for the help making this work right. It is now in the files section. http://www.bmwlt.com/files/displayimage.php?pos=-166

If you open the Excel file.
At the top of the page you enter a start and finish date. (Iím using the mileage contest dates) Then add your target mileage and your starting mileage.

In the lower section enter the trip date, description, starting and ending mileage.
You then get your trip miles, total mileage, remaining mileage to your target, % of target, days remaining in contest.

Doug
'05 K1200LT,
My dog is very selective where he will pee, yet he will poop anywhere. In that regard; we couldnít be more different.

Last edited by BallsCasten; Apr 18th, 2008 at 10:57 am.
BallsCasten is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the BMW Luxury Touring Community forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in











Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Similar Threads
Thread Thread Starter Forum Replies Last Post
Fuel mileage on 2003 vs. 2000 LT JohnR K1200LT 33 May 9th, 2011 9:23 am
STC- Bring your MOA mileage cards BamaLT South East 10 Apr 15th, 2007 5:12 pm
Gas Mileage - again JOHNF K1200LT 26 Jun 29th, 2006 9:07 pm
'05 LT gas mileage? ajs K1200LT 15 Apr 17th, 2006 11:23 pm
BMWMOA mileage error bob_menton Chit Chat 7 Jan 13th, 2006 4:36 am

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome