Diesel Place banner

1 - 9 of 9 Posts

·
Registered
Joined
·
2,393 Posts
Discussion Starter #1
I have been bored lately and though that my milage log needed revised. Getting all the calculators setup took some more time than I thought it would, but in the end I got about everything that I could think of on here. I though that I would post it for anyone else that might want to use it. Even if you don't use you vehicle for bussiness purposes, it could be handy, or scary to see what you actually spend with the operation of your vehicle. I'm no computer wiz, so I'm sure that there is some mistakes in it let me know what they are and I will get them fixed. When you print it off each month will fit on a standard sheet of paper.

Adam
 

·
Registered
Joined
·
2,393 Posts
Discussion Starter #2
Just noticed that the file did not attatch, couldn't upload it because it was a XLS file. I'll try to post some examples of it and if you would like me to send it to you you can email me a TurnLeftBeagles at floodcity dot net, replace at with @ and dot with .

Month: January Year: 2006 Vehicle: 2005 Chevrolet Silverado 2500HD CC/SB 4x4 Fuel: Diesel Color : Black
Date Departed Arrived OD Start OD End Personal Bussiness Total Fuel Gals. Fuel Cost Bussiness Reason
1-Jan Boswell, PA Boswell, PA 14865 14885 10 10 20 Dog Training
2-Jan Boswell, PA Stoystown, PA 14885 14905 20 20 Dog Training
3-Jan Boswell, PA Acosta, PA 14905 14925 20 20 Dog Training
4-Jan Boswell, PA Johnstown, PA 14925 14955 30 0 30 Personal Use
5-Jan 0 0
6-Jan Boswell, PA Stoystown, PA 14955 14980 5 20 25 Dog Training
7-Jan 0 0
8-Jan Boswell, PA Johnstown, PA 14980 15020 40 40 19 50.14 Purchase Supplies
9-Jan Boswell, PA Logansport, IN 15020 15670 650 650 34 85.99 Pick Dog Boxes
10-Jan Logansport, IN Boswell, PA 15670 16100 430 430 21 53.13 Pick Dog Boxes
11-Jan 0 0
12-Jan 0 0
13-Jan Boswell, PA Stoystown, PA 16100 16120 20 20 Dog Training
14-Jan 0 0
15-Jan Boswell, PA Grantsville, MD 16120 16205 85 85 22 57.18 meet for Field Trial
16-Jan Boswell, PA Boswell, PA 16205 16220 15 15 mail letter
17-Jan Boswell, PA Jennerstown, PA 16220 16235 5 10 15 Bank & Post Office
18-Jan 0 0
19-Jan Boswell, PA Johnstown, PA 16235 16265 30 0 30 Personal Use
20-Jan 0 0
21-Jan Boswell, PA Acosta, PA 16265 16280 15 15 Dog Training
22-Jan Boswell, PA Boswell, PA 16280 16290 10 10 Bank & Post Office
23-Jan 0 0
24-Jan Boswell, PA Somerset, PA 16290 16320 30 30 Price Products
25-Jan Boswell, PA Boswell, PA 16320 16330 10 10 Post Office
26-Jan 0 0
27-Jan Boswell, PA Johnstown, PA 16330 16370 10 30 40 18 46.06 Purchase Supplies
28-Jan Boswell, PA Hollsopple, PA 16370 16390 20 20 Dog Training
29-Jan 0 0
30-Jan 0 0
31-Jan 0 0
Fed. Op. 695.975 Fuel Milage: 13.37719298 m.p.g. Totals 90 1435 1525 114 292.5
Maintenance: Oil, Oil Filter, Fuel Filter changed, and tires rotated at 14,950 miles


Repairs: New Stainless Steel front pipe installed $200



Accessories: New Computer Tuning product for fuel milage enhancement $455


Category January February March April May June July August September October November December Total
MILES
Bussiness 1435 0 0 0 0 0 0 0 0 0 0 0 1435
Personal 90 0 0 0 0 0 0 0 0 0 0 0 90
Total 1525 0 0 0 0 0 0 0 0 0 0 0 1525
FUEL
Gallons 114 0 0 0 0 0 0 0 0 0 0 0 114
Cost 292.5 0 0 0 0 0 0 0 0 0 0 0 292.5
Avg. $ gal. 2.565789474 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 2.565789474
TOLLS 9.75 9.75
M.P.G. 13.37719298 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 13.37719298
Maint. $ 0
Repiar $ $200 200
Acces. $ $455.00 455
Fed Op $ 695.975 0 0 0 0 0 0 0 0 0 0 0 695.975
My OP $ 962.75 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Difference -266.775 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
PA State Vehicle Registration Cost: $183 Vehicle Insurance cost: Total: 183
Cost per mile to operate this vehicle: 0.741311475
 

·
Registered
Joined
·
2,393 Posts
Discussion Starter #3
That didn't work either, you can kinda get the general idea though if you want to take a look at it email me. If anyone knows how to upload the document on here also that is fine and dandy also.
 

·
Registered
Joined
·
2,612 Posts
I used a little application on my Palm called TotalCar for a while. I tracked all of my fuel and expenses with it. It also had trip logging functionality that I did not use. Can be set up for multiple vehicles and will export to an access database. Not a bad little utility for something like $20.

Sent you an email, I'd like to take a look at your spreadsheet.
 

·
Registered
Joined
·
1,444 Posts
I don't do it by trip, but I have an Excel workbook for everything (fuel, maintenance, accessories, insurance, taxes, etc.) since my truck had 7 miles on it. Been sad to watch that fuel cost per mile chart climb the last 8 months...

Minisub, I had a program similar to that for my old Palm, but I never did like how it output the data. I wish it had exported it to Access, that would be a nice feature. Once upon a time I had an Access database set up that imported the data from my Excel workbook and created reports and such, but I never really added much additional functionality to it and eventually scrapped it.
 

·
Registered
Joined
·
2,612 Posts
habanero, TotalCar output to access. I then linked the data to reports I built in excel. Basically the reverse of what you were doing....

I recently got a new Palm, maybe I'll email the guy that makes it and get him to resend my key, or maybe an upgraded application - I have 3 years of fuel and maintenance receipts to enter.....

Hey Adam, empty your email inbox, my message bounced. Or send the file to me at joseph_k at ameritech dot net
 

·
Registered
Joined
·
2,393 Posts
Discussion Starter #7
My e-mail is acting stupid for some reason, you have an inbound e-mail.
 

·
Registered
Joined
·
2,393 Posts
Discussion Starter #8
My e-mail is workin agian, so if you would like me to send it to you I can succesfully now.
 

·
Registered
Joined
·
12 Posts
Auto Expense Tracking

For those with Palm Pilots, TealAuto is a good expense traking program. Has features to export to excel and shows graphs on the palm.

Paul
 
1 - 9 of 9 Posts
Top