Go Back   Team-BHP > Around the Corner > Shifting gears


Reply
 
Thread Tools Search this Thread
Old 30th October 2006, 17:09   #1
Senior - BHPian
 
satish_appasani's Avatar
 
Join Date: Jun 2004
Location: Hyderabad
Posts: 1,029
Thanked: 42 Times
Default Simple calculator to compute your car's mileage, Cost / KM, Distance between fills...

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.
Attached Files
File Type: xls Car fuel calculator.XLS (25.5 KB, 26775 views)
File Type: xls Car fuel calculator - V2.XLS (34.0 KB, 14422 views)
File Type: xls Car Maintenance History.xls (63.5 KB, 7961 views)

Last edited by GTO : 30th January 2008 at 10:56.
satish_appasani is online now   Reply With Quote
Old 30th October 2006, 17:52   #2
Senior - BHPian
 
hydrashok's Avatar
 
Join Date: Aug 2006
Location: In my Office
Posts: 2,528
Thanked: 14 Times
Default

Good one, Satish! Let me try this out.
hydrashok is offline   Reply With Quote
Old 30th October 2006, 18:16   #3
GTO
Team-BHP Support
 
GTO's Avatar
 
Join Date: Feb 2004
Location: Bombay
Posts: 46,577
Thanked: 80,479 Times
Default

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 is offline   Reply With Quote
Old 30th October 2006, 21:15   #4
Senior - BHPian
 
rahul_intlad's Avatar
 
Join Date: Aug 2006
Location: Pune
Posts: 1,577
Thanked: 2 Times
Default

Thank You satish and GTO.

Will use this certainly.
rahul_intlad is offline   Reply With Quote
Old 30th October 2006, 21:30   #5
Senior - BHPian
 
normally_crazy's Avatar
 
Join Date: Feb 2004
Location: Mumbai
Posts: 4,368
Thanked: 383 Times
Default

Thanks Satish. This is good.
normally_crazy is offline   Reply With Quote
Old 30th October 2006, 21:50   #6
Senior - BHPian
 
abhibh's Avatar
 
Join Date: Sep 2005
Location: Back in the HOOD near you!
Posts: 2,767
Thanked: 33 Times
Default

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 ??
abhibh is offline   Reply With Quote
Old 30th October 2006, 22:40   #7
Senior - BHPian
 
satish_appasani's Avatar
 
Join Date: Jun 2004
Location: Hyderabad
Posts: 1,029
Thanked: 42 Times
Default

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.
satish_appasani is online now   Reply With Quote
Old 30th October 2006, 22:44   #8
BHPian
 
nikkibike's Avatar
 
Join Date: May 2006
Location: QoAS
Posts: 523
Thanked: 2 Times
Default

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!!!
nikkibike is offline   Reply With Quote
Old 30th October 2006, 23:01   #9
Team-BHP Support
 
theMAG's Avatar
 
Join Date: May 2006
Location: Long Island, NY
Posts: 6,994
Thanked: 1,421 Times
Default

Great job, Satish !
theMAG is offline   Reply With Quote
Old 30th October 2006, 23:06   #10
Senior - BHPian
 
Join Date: Oct 2005
Location: Gujarat 03
Posts: 1,302
Thanked: 10 Times
Default

Satish,

Thats really useful.
Thanks for sharing.
Mugen_Power is offline   Reply With Quote
Old 30th October 2006, 23:24   #11
Senior - BHPian
 
abhibh's Avatar
 
Join Date: Sep 2005
Location: Back in the HOOD near you!
Posts: 2,767
Thanked: 33 Times
Default

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.
abhibh is offline   Reply With Quote
Old 30th October 2006, 23:40   #12
BHPian
 
kailashnj's Avatar
 
Join Date: Oct 2006
Location: Mumbai
Posts: 885
Thanked: 273 Times
Default

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
kailashnj is offline   Reply With Quote
Old 10th January 2008, 02:01   #13
Team-BHP Support
 
Eddy's Avatar
 
Join Date: Apr 2007
Location: Delhi
Posts: 7,269
Thanked: 4,424 Times
Default

<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.
Eddy is online now   Reply With Quote
Old 10th January 2008, 07:35   #14
BANNED
 
sfilinto's Avatar
 
Join Date: May 2006
Location: mostlly bangalore
Posts: 102
Thanked: Once
Default

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.
sfilinto is offline   Reply With Quote
Old 10th January 2008, 18:47   #15
BHPian
 
sreenivass's Avatar
 
Join Date: Oct 2006
Location: Bangalore India
Posts: 872
Thanked: 6 Times
Default

I have been using a variant of this without knowing the original author. Thanks for a very useful one.
sreenivass 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
Ford's new service cost calculator for its entire range of vehicles S2!!! The Indian Car Scene 31 8th August 2017 19:57
Skoda: Steps towards Transparency - Online Service Cost Calculator & Owners Manual sarthakgupta The Indian Car Scene 64 7th March 2017 21:40
Mileage labels on cars soon; 10L fine for violation of mileage standards coolclouds The Indian Car Scene 22 14th June 2012 15:13
*Attached* : Fuel cost calculator, including a comparison between Petrol & Diesel Delta Wing The Indian Car Scene 131 1st March 2012 13:33


All times are GMT +5.5. The time now is 23:17.

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