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

satish_appasani · 30th October 2006, 17: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, 17:52

Good one, Satish! Let me try this out.

GTO · 30th October 2006, 18: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, 21:15

Thank You satish and GTO.

Will use this certainly.

normally_crazy · 30th October 2006, 21:30

Thanks Satish. This is good.

abhibh · 30th October 2006, 21: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, 22: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, 22: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, 23:01

Great job, Satish !

Mugen_Power · 30th October 2006, 23:06

Satish,

Thats really useful.
Thanks for sharing.

abhibh · 30th October 2006, 23: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, 23: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, 02: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, 07: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, 18:47

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

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

30th October 2006, 18:16	#3 (permalink)
GTO Team-BHP Support Join Date: Feb 2004 Location: Bombay Posts: 18,479 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 Work backward from your imagination, not forward from the past! 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, 21:30	#5 (permalink)
normally_crazy Distinguished - BHPian Join Date: Feb 2004 Location: Mumbai Posts: 3,766 View My Garage	Thanks Satish. This is good. __________________ In the end there are 3 things that last: faith, hope and love; and the greatest of these is love.

30th October 2006, 21:50	#6 (permalink)
abhibh Senior - BHPian Join Date: Sep 2005 Location: Back in the HOOD near you! Posts: 2,285 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 ?? __________________ Tyres will screech & Engines will roar - WOM

30th October 2006, 22:40	#7 (permalink)
satish_appasani BHPian Join Date: Jun 2004 Location: Hyderabad Posts: 925 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 22:47.

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

30th October 2006, 23:01	#9 (permalink)
theMAG Team-BHP Support Join Date: May 2006 Location: Bengalooru Posts: 4,526 View My Garage	Great job, Satish ! __________________ If I hold a hammer, everything looks like a nail.

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

30th October 2006, 23:40	#12 (permalink)
kailashnj BHPian Join Date: Oct 2006 Location: Mumbai Posts: 328 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, 02:01	#13 (permalink)
Eddy Team-BHP Support Join Date: Apr 2007 Location: Delhi Posts: 2,082	<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. Swift VDI(ABS) Sep 07 - 53K Kms Ford Ikon Flair Sep 04 - 70K Kms

10th January 2008, 07:35	#14 (permalink)
sfilinto BHPian Join Date: May 2006 Location: mostlly bangalore Posts: 84	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, 18:47	#15 (permalink)
sreenivass BHPian Join Date: Oct 2006 Location: Hyderabad, India Posts: 811 View My Garage	I have been using a variant of this without knowing the original author. Thanks for a very useful one.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
BP Petrol bunk fills 45.3 Litres in my 42L tank	iwant2go	Street Experiences	24	28th January 2009 14:44
Cost of Parts: 19 Cents; Cost of Shipping: $998,798!!!	iraghava	Shifting gears	4	18th August 2007 11:16