Simple calculator to compute your car's mileage, Cost / KM, Distance between fills... - Team-BHP

satish_appasani · 30th October 2006, 16:09

I have created a simple Excel sheet to store and analyze my car's fuel records. I am sharing it with fellow tbhp members.

I created this for my Pocket PC, so the sheet has less frills and the formulae and charts are simple. Also i wanted to make entering of data as little as possible to quicky enter the details when filling. Right now, the formulae are limited to 20 rows but they can copied and pasted to any number of rows. The charts also will require modification to accept new data range after adding new rows in the data sheet. Use one file for each vehicle.

For each record, just enter the odometer reading, date and quantity and rest of the values will be updated automatically. If the price of the fuel changes, just change the value in the Rate column for that record. All the new records below the changed row will use the new value to compute total price and other values.

I am posting this file for free and it is open for you to customize it for your requirements and sharing it with others. You will find the file as an attachment with this post itself.

EDIT from Team-BHP Support : Thanks to "Narasimha Raju" for sharing his excel sheet on car maintenance records. It has been added to the attachment list.

hydrashok · 30th October 2006, 16:52

Good one, Satish! Let me try this out.

GTO · 30th October 2006, 17:16

Satish, Thanks for sharing this. For convenience, I have uploaded the Excel sheet to your original post itself. Users can download directly from Team-BHP.

rahul_intlad · 30th October 2006, 20:15

Thank You satish and GTO.

Will use this certainly.

normally_crazy · 30th October 2006, 20:30

Thanks Satish. This is good.

abhibh · 30th October 2006, 20:50

Wow this is nice i can even open this up in my n70

BTW can you tell how did ya freezed the cells. I mean those Odometer, date, quantity, rate rs etc. stays on top and other figures scroll ??

satish_appasani · 30th October 2006, 21:40

Select the cell in the column to the right of column to be freezed and row below the one that is to be feezed. In windows menu, click "Freeze panes".

For example to freeze 1st row and 1st column, select cell B2 and click on Windows > Freeze panes.

nikkibike · 30th October 2006, 21:44

Quote:

Originally Posted by satish_appasani

Select the cell in the column to the right of column to be freezed and row below the one that is to be feezed. In windows menu, click "Freeze panes".

For example to choose 1st row and 1st column, select cell B2 and click on Windows > Freeze panes.

good one satish!! Lemme try it out!!!

theMAG · 30th October 2006, 22:01

Great job, Satish !

Mugen_Power · 30th October 2006, 22:06

Satish,

Thats really useful.
Thanks for sharing.

abhibh · 30th October 2006, 22:24

Hi,

Thanks a lot. Actually why i asked is that i have some excel sheets in which i have accidently freezed the panes 2 days ago. Posted it on some forum no reply from there and then saw yer excel sheet.

Thanks again.

Quote:

Originally Posted by satish_appasani

Select the cell in the column to the right of column to be freezed and row below the one that is to be feezed. In windows menu, click "Freeze panes".

For example to freeze 1st row and 1st column, select cell B2 and click on Windows > Freeze panes.

kailashnj · 30th October 2006, 22:40

This is a really nice tool to check the FE of my car. I am in luv with the tool. Man you are a genuis --- Excel Guru should be the name given

Eddy · 10th January 2008, 01:01

<bump>

Nice tool guys, You can track your fuel expenses through this. Pity i discovered it a little late; i have already made an excel sheet for me.

sfilinto · 10th January 2008, 06:35

this is great. i was attempting to do the same manually. i.e. paper and pencil and it was a pain. this excel file is just the thing for me.

sreenivass · 10th January 2008, 17:47

I have been using a variant of this without knowing the original author. Thanks for a very useful one.

30th October 2006, 16:52	#2 (permalink)
hydrashok Senior - BHPian Join Date: Aug 2006 Location: In my Office Posts: 2,149 View My Garage	Good one, Satish! Let me try this out. __________________ Alpine 9887 \| TRU Tech S44 \| Image Dynamics XS65 \| Image Dynamics IDQ12 D2V2 \| Connection Audison

30th October 2006, 17:16	#3 (permalink)
GTO Team-BHP Support Join Date: Feb 2004 Location: Bombay Posts: 13,146 View My Garage	Satish, Thanks for sharing this. For convenience, I have uploaded the Excel sheet to your original post itself. Users can download directly from Team-BHP. __________________ GTO Change the way you think, and watch the world change around you. Please don't PM for support. Use the Contact Form instead. Please read the NEW Team-BHP FAQ section for all your queries.

30th October 2006, 20:50	#6 (permalink)
abhibh Senior - BHPian Join Date: Sep 2005 Location: In the Hood Near You Posts: 1,535 View My Garage	Wow this is nice i can even open this up in my n70 BTW can you tell how did ya freezed the cells. I mean those Odometer, date, quantity, rate rs etc. stays on top and other figures scroll ?? __________________ tinypic.com/player.php?v=35mo01l&s=4

30th October 2006, 21:40	#7 (permalink)
satish_appasani BHPian Join Date: Jun 2004 Location: Hyderabad Posts: 918 View My Garage	Select the cell in the column to the right of column to be freezed and row below the one that is to be feezed. In windows menu, click "Freeze panes". For example to freeze 1st row and 1st column, select cell B2 and click on Windows > Freeze panes. Last edited by satish_appasani : 30th October 2006 at 21:47.

30th October 2006, 22:01	#9 (permalink)
theMAG Team-BHP Support Join Date: May 2006 Location: Bengalooru Posts: 3,756 View My Garage	Great job, Satish ! __________________ If you lose your temper, you’ve lost the argument

30th October 2006, 20:15	#4 (permalink)
rahul_intlad Senior - BHPian Join Date: Aug 2006 Location: Pune Posts: 1,569	Thank You satish and GTO. Will use this certainly.

30th October 2006, 20:30	#5 (permalink)
normally_crazy Team-BHP Support Join Date: Feb 2004 Location: Mumbai Posts: 3,841 View My Garage	Thanks Satish. This is good.

30th October 2006, 22:06	#10 (permalink)
Mugen_Power Senior - BHPian Join Date: Oct 2005 Location: Morbi - Gujarat Posts: 1,246	Satish, Thats really useful. Thanks for sharing.

30th October 2006, 22:40	#12 (permalink)
kailashnj BHPian Join Date: Oct 2006 Location: Mumbai Posts: 188 View My Garage	This is a really nice tool to check the FE of my car. I am in luv with the tool. Man you are a genuis --- Excel Guru should be the name given

10th January 2008, 01:01	#13 (permalink)
Eddy Senior - BHPian Join Date: Apr 2007 Location: Delhi Posts: 1,099	<bump> Nice tool guys, You can track your fuel expenses through this. Pity i discovered it a little late; i have already made an excel sheet for me. __________________ Car is no longer a luxury; parking space is.

10th January 2008, 06:35	#14 (permalink)
sfilinto BHPian Join Date: May 2006 Location: mostlly bangalore Posts: 67	this is great. i was attempting to do the same manually. i.e. paper and pencil and it was a pain. this excel file is just the thing for me.

10th January 2008, 17:47	#15 (permalink)
sreenivass BHPian Join Date: Oct 2006 Location: Hyderabad, India Posts: 745 View My Garage	I have been using a variant of this without knowing the original author. Thanks for a very useful one. __________________ I have one dream, Fiat with great A.S.S.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tyre Size Calculator!	SirAlec	Technical Stuff	1	13th April 2008 21:29
Speed calculator from ratios etc	BunnyPunia	Technical Stuff	4	19th November 2007 13:44
Cost of Parts: 19 Cents; Cost of Shipping: $998,798!!!	iraghava	Shifting gears	4	18th August 2007 10:16
Quater Mile Time Calculator	Ford Rocam	Motor-Sports!!	9	9th December 2005 23:43