Go Back   Team-BHP > Under the Hood > Technical Stuff


Reply
 
Thread Tools Search this Thread
Old 24th June 2008, 18:02   #1
BHPian
 
TractionAvant's Avatar
 
Join Date: Jun 2008
Location: pune
Posts: 189
Thanked: 90 Times
Default How to maintain a log book for a car

Hello All,

I cannot find a more appropriate place for this topic (moderators, please move the thread if it is out of place, thank you).

I would like to know what details should one enter in a log book for a car. Here's what I can think of;
1) Date & quantity of fuel filled.
2) Details of periodic servicing & repairs carried out.
2) Long trips could be logged with daily running, places visited with distance & time taken

My question is, should one also put in details of the daily commute? It would be rather tedious and the log book would run into shelves . Your thoughts would be appreciated.
Thanks in advance

Kind regards

Aditya
TractionAvant is offline   Reply With Quote
Old 24th June 2008, 19:27   #2
Senior - BHPian
 
abhinav.gupta88's Avatar
 
Join Date: Sep 2007
Location: Delhi , India
Posts: 4,087
Thanked: 308 Times
Default

Well you can take a look at the chart prepared by mahadev for his palio from this post and make one in excel according to what all you want to keep and what not to.

http://www.team-bhp.com/forum/long-t...ip-report.html (FIAT Palio 1.6 Sports - 20000 Kms ownership report)
abhinav.gupta88 is offline   Reply With Quote
Old 24th June 2008, 19:30   #3
BHPian
 
Join Date: Jan 2007
Location: Shillong
Posts: 925
Thanked: 83 Times
Default

You should PM HVKumar and Ramkya for their advice. If possible, invite them to pen their advice on this thread for the benefit of others. Their log keeping is really excellent.
SumitB is offline   Reply With Quote
Old 24th June 2008, 19:59   #4
Senior - BHPian
 
rjstyles69's Avatar
 
Join Date: Sep 2006
Location: Bengalooru..
Posts: 4,345
Thanked: 789 Times
Default

PM akroy on the forum, he has a wonderful excel sheet which he uses. Its been posted somewhere on the forum , cant seem to find it.
rjstyles69 is offline   Reply With Quote
Old 24th June 2008, 21:17   #5
BHPian
 
narasimha raju's Avatar
 
Join Date: Sep 2005
Location: Hyderabad
Posts: 121
Thanked: 40 Times
Default

You can download Car Maintainence History excel sheet from the following link.

http://www.team-bhp.com/forum/shifti...een-fills.html

Last edited by narasimha raju : 24th June 2008 at 21:21.
narasimha raju is offline   Reply With Quote
Old 24th June 2008, 21:29   #6
BHPian
 
Join Date: Aug 2007
Location: Bangalore
Posts: 967
Thanked: 235 Times
Default

I guess hvkumar and ramky haven't seen this thread yet.
Torqy is offline   Reply With Quote
Old 24th June 2008, 21:37   #7
Senior - BHPian
 
hvkumar's Avatar
 
Join Date: Nov 2006
Location: Mumbai
Posts: 7,369
Thanked: 3,354 Times
Default

I maintain all the log books you mention.

Daily Log:

- A small diary in the car to record daily kms run
- The same diary also records the fuel fillings (km, cost, odo reading, reserve reading)

Periodically, I transcribe all to a Excel file so I can keep dettailed reports on my mileage, kms run, etc.

Maintenance History:

- I keep all bills of workshops
- keep track of all tyre punctures in my daily diary
- write out in excel files (with classifications of tyypes of repair), and generate reports
- my log helps me track maintenance schedules (wizard file)

Trip Logs

- Write out in kachcha diaries/ scribbling pads/ note books during trip
- type it out in excel files after trip
- keep track of distances, ttimings, odo readings, fuel fillings, landmarks, and expenses
hvkumar is offline   Reply With Quote
Old 24th June 2008, 22:34   #8
Senior - BHPian
 
PatienceWins's Avatar
 
Join Date: May 2007
Location: Bangalore
Posts: 2,158
Thanked: 261 Times
Default

Quote:
Originally Posted by hvkumar View Post
I maintain all the log books you mention.

Daily Log:

- A small diary in the car to record daily kms run
- The same diary also records the fuel fillings (km, cost, odo reading, reserve reading)

Periodically, I transcribe all to a Excel file so I can keep dettailed reports on my mileage, kms run, etc.

Maintenance History:

- I keep all bills of workshops
- keep track of all tyre punctures in my daily diary
- write out in excel files (with classifications of tyypes of repair), and generate reports
- my log helps me track maintenance schedules (wizard file)

Trip Logs

- Write out in kachcha diaries/ scribbling pads/ note books during trip
- type it out in excel files after trip
- keep track of distances, ttimings, odo readings, fuel fillings, landmarks, and expenses
It cannot get better than this.
PatienceWins is offline   Reply With Quote
Old 24th June 2008, 23:23   #9
Team-BHP Support
 
tsk1979's Avatar
 
Join Date: Feb 2005
Location: New Delhi
Posts: 22,955
Thanked: 15,648 Times
Default

The best is to maintain an online XLS on google spreadsheets.
I maintain that and enter every penny spent on fuel, repair and accessories.
This way I have an up to date counter of cost/km as well as repair/km and fuel cost/km etc.,
Have been doing so since 80K kms
Car is at 104000 now.
tsk1979 is offline   Reply With Quote
Old 25th June 2008, 00:55   #10
Senior - BHPian
 
hvkumar's Avatar
 
Join Date: Nov 2006
Location: Mumbai
Posts: 7,369
Thanked: 3,354 Times
Default

Quote:
Originally Posted by mjothi View Post
One question.
The milage can be calculated only when we keep filling the tank full for every fill right? What if we fill say 500rs in between and then tank full sometimes? In this case, how should we calculate the milage? Any idea?
I scrupulously measure mileage, full tank-to-full tank. Round off filling to the nearest round figure after the first air block on the nozzle. Gives me consistent results.


Am attaching the following:

- My Scorpio Daily Log Book: from Day 1, all day-end odo readings, diesel fillings, distance/fuel monthly summaries

- My Scorpio Maintenance Log Book: Bill-wise, Category-wise cost analysis
Attached Files
File Type: xls Scorpio-LogBook.xls (162.5 KB, 1435 views)
File Type: xls Copy of Scorpio-MaintenanceLog.xls (160.5 KB, 959 views)

Last edited by Rehaan : 25th June 2008 at 03:07. Reason: Posts Merged. Please use the EDIT button to add to an existing post within 20 minutes instead of postnig another consecutive post.
hvkumar is offline   (1) Thanks Reply With Quote
Old 25th June 2008, 09:38   #11
BHPian
 
TractionAvant's Avatar
 
Join Date: Jun 2008
Location: pune
Posts: 189
Thanked: 90 Times
Default

WOW,

What a response!!!!!! Thank you everyone for your help. All the excel sheets are very helpful (and inspiring, might I add ). I have done about 700 Km in my new Chevrolet spark, most of it on the daily commute. I suppose it is not too late to start a detailed log.

Once again, a big THANK YOU to everyone for helping out

Kind regards

Aditya
TractionAvant is offline   Reply With Quote
Old 25th June 2008, 09:42   #12
Senior - BHPian
 
rkbharat's Avatar
 
Join Date: Sep 2006
Location: Gurgaon/New Delhi
Posts: 1,590
Thanked: 608 Times
Default

Putting in excel/google spreadsheet etc etc should not be a problem for most computer known people. Lots of templates are already there in this thread.

Actual problem is gathering the data while you are on the move. Like Fuel fill, Travel logs etc etc.

And I think the only best way is as suggested by Kumar Saab, scribe on some note pad or small diary and than consolidate at some frequency.

Believe me, no PDA, Laptop, and other gadgets works on the move, than a simple small diary and a pen.
rkbharat is offline   Reply With Quote
Old 25th June 2008, 09:50   #13
Senior - BHPian
 
Join Date: Mar 2007
Location: Delhi
Posts: 2,175
Thanked: 128 Times
Default

I travel around 350 km a week, and fill fuel every Sat/Sun., regardless of distance travelled in the week. For my new car, I have maintained this since buying the car, and so far have clocked 25K.

I mantain an excel record of fuel filled (auto lock full), cost, Rs./litre.
Service costs
Denting/painting costs
Toll charges
Dry cleaning costs.

The first 2 costs are directly related to the car. Even the 3rd one is (bigger car=higher cost) but also dependent on my own driving.
Do not maintain trivial costs such as PUC, bi-monthly or occasional washing or polishing, tyre fill charges, etc.
vasudeva is offline   Reply With Quote
Old 25th June 2008, 10:50   #14
Distinguished - BHPian
 
supremeBaleno's Avatar
 
Join Date: Dec 2005
Location: Weekdays@Chennai, Weekends@Kerala
Posts: 5,164
Thanked: 1,638 Times
Default

For my bike, I maintain an excel sheet (snapshot attached), which tracks every litre of fuel I put in the bike for the past 13 years, the mileage for every fuel-up, the total cost on fuel etc. The 'remarks' section is used to make note of services, oil changes, minor repairs, punctures etc.

Name:  BikeMaintRecord.JPG
Views: 49444
Size:  103.4 KB

For the car, we use a diary which is kept in the car itself. It also has a tabular column in the same format as that of the bikeRecord for keeping a tab on the fuel. Apart from this, it has a section for recording maintenance expenditure (services, other repairs etc). Another section for keeping track of expense on accessories.

There is also a section for long-distance trips done - this section is used to note down distances, time taken, other important info about the place visited or places enroute etc.

We maintain a similar diary for each of the cars.

P.S : When I bought the bike in '95, a litre of fuel was just 20bucks. Good old days.

Last edited by supremeBaleno : 25th June 2008 at 10:54.
supremeBaleno is offline   Reply With Quote
Old 1st July 2008, 12:02   #15
BHPian
 
Join Date: Jun 2008
Location: Bangalore
Posts: 33
Thanked: 0 Times
Default

Quote:
Originally Posted by supremeBaleno View Post
For my bike, I maintain an excel sheet (snapshot attached), which tracks every litre of fuel I put in the bike for the past 13 years, the mileage for every fuel-up, the total cost on fuel etc. The 'remarks' section is used to make note of services, oil changes, minor repairs, punctures etc.

Attachment 23943

For the car, we use a diary which is kept in the car itself. It also has a tabular column in the same format as that of the bikeRecord for keeping a tab on the fuel. Apart from this, it has a section for recording maintenance expenditure (services, other repairs etc). Another section for keeping track of expense on accessories.

There is also a section for long-distance trips done - this section is used to note down distances, time taken, other important info about the place visited or places enroute etc.

We maintain a similar diary for each of the cars.

P.S : When I bought the bike in '95, a litre of fuel was just 20bucks. Good old days.
I had an almost exactly identical one for my bike. I just had 1 extra column to denote how much i'd driven in reserve. This allowed me to adjust the FE values correctly.
paranoidAndroid is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintain the car yourself. A service checklist GTO Technical Stuff 356 29th November 2017 12:58
Best Practices : Maintain your Car in Top Shape GTO Technical Stuff 114 14th October 2017 20:23
Need help with economics book and Baron's GMAT/GRE English book Nikhilb2008 Shifting gears 2 30th June 2008 11:05
Buying car without a blue book(RC Book). Safe? vrooooooom The Indian Car Scene 19 7th May 2008 17:25
New to 4 Wheelers and hope to learn good tips and tricks to maintain my car. tango6996 Introduce yourself 3 24th March 2007 12:27


All times are GMT +5.5. The time now is 16:25.

Copyright 2000 - 2017, Team-BHP.com
Proudly powered by E2E Networks