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

[satish_appasani]

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]

Good one, Satish! Let me try this out.

[GTO]

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]

Thank You satish and GTO.

Will use this certainly.

[normally_crazy]

Thanks Satish. This is good.

[abhibh]

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]

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]

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]

Great job, Satish !

[Mugen_Power]

Satish,

Thats really useful.
Thanks for sharing.

[abhibh]

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.

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]

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]

<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]

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]

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