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


Reply
 
Thread Tools Search this Thread
Old 14th December 2011, 17:00   #1
BHPian
 
Gandhi's Avatar
 
Join Date: Jul 2009
Location: Bay Area, CA
Posts: 980
Thanked: 199 Times
Default Car Expense Tracker Tool

All of us have cars and we like to track lot of details about or cars (like Petrol bills, servicing costs, accessories cost etc etc).

I like to track lot of details about stuff I love, so I use an excel sheet to track such things about my car. Slowly, this excel sheet has evolved into a great tool for me to see patterns about my usage of car and its behavior.

I'd like to share this excel sheet with all you folks, so that you can use it and also add to it.

Car Expense Tracker.xlsx

Please share more such tools (iOS apps, Android apps, more such excel sheets etc) in this thread, so that all BHPians who like to track things have a single thread to look for.

Here are two screenshots that show what kind of information this excel sheet provides -

Car Expense Tracker Tool-dashboard.png

Car Expense Tracker Tool-petrol-data.png
Gandhi is offline   Reply With Quote
Old 14th December 2011, 17:01   #2
Senior - BHPian
 
mayankk's Avatar
 
Join Date: Apr 2010
Location: New Delhi
Posts: 4,056
Thanked: 3,246 Times
Default Re: Car Expense Tracker Tool

aCar on android.
it is awesomeness!
mayankk is offline   Reply With Quote
Old 15th December 2011, 14:31   #3
BHPian
 
akas_chauhan's Avatar
 
Join Date: Dec 2008
Location: San Antonio
Posts: 595
Thanked: 22 Times
Default Re: Car Expense Tracker Tool

I was using mycar monitor.
You can download them from here.
Car Care Automotive Maintenance Software - Free Mycar-Monitor - Bug tracker - InfraBugTracker - Health Care - HealthFix+ - ePPAP-Magic - Deadline Manager
akas_chauhan is offline   Reply With Quote
Old 15th December 2011, 14:43   #4
Senior - BHPian
 
thoma's Avatar
 
Join Date: Oct 2011
Location: Kerala
Posts: 1,748
Thanked: 1,067 Times
Default Re: Car Expense Tracker Tool

Idea! Why not Team-BHP build one so that users can use it for tracking their expenses and Team-BHP can do a market research/calculation on usage/expenses of different brands/cars? It also adds diversification to Team-BHP.

May be

BTW, you are getting good FE figures on your Ritz petrol.

Quote:
Originally Posted by Gandhi View Post
I'd like to share this excel sheet with all you folks, so that you can use it and also add to it.

Here are two screenshots that show what kind of information this excel sheet provides -

Last edited by thoma : 15th December 2011 at 14:49.
thoma is offline   Reply With Quote
Old 16th December 2011, 11:06   #5
BHPian
 
Deep Blue's Avatar
 
Join Date: Sep 2009
Location: Udupi
Posts: 590
Thanked: 225 Times
Default Re: Car Expense Tracker Tool

Anything for Iphone?
Deep Blue is offline   Reply With Quote
Old 16th December 2011, 11:58   #6
BHPian
 
Gandhi's Avatar
 
Join Date: Jul 2009
Location: Bay Area, CA
Posts: 980
Thanked: 199 Times
Default Re: Car Expense Tracker Tool

Wow, I didn't know about the Windows app for car expense tracking (mostly because I've been away from Windows for past 4 years).

I forgot to mention about this app available for Samsung bada smartphones. It's called CarCon. It's not as good as aCar on Android but does the job well. I use it along with my excel sheet (I note down the figures in the app so that I don't forget).

Here's a video of this app -



Quote:
Originally Posted by thoma View Post
BTW, you are getting good FE figures on your Ritz petrol.
Thanks thoma. Ritz petrol has a gem of an engine.
Gandhi is offline   Reply With Quote
Old 16th December 2011, 14:42   #7
BHPian
 
90BHP's Avatar
 
Join Date: Sep 2011
Location: Mumbai
Posts: 233
Thanked: 38 Times
Default Re: Car Expense Tracker Tool

How about adding some functionality of the sheet to compare the amount you spent to buy the car against savings over the years & point where you would extracted everything from the car & you break even !!!
90BHP is offline   Reply With Quote
Old 16th December 2011, 14:56   #8
BHPian
 
Gandhi's Avatar
 
Join Date: Jul 2009
Location: Bay Area, CA
Posts: 980
Thanked: 199 Times
Default Re: Car Expense Tracker Tool

Quote:
Originally Posted by 90BHP View Post
How about adding some functionality of the sheet to compare the amount you spent to buy the car against savings over the years & point where you would extracted everything from the car & you break even !!!
Can you elaborate more?

How do you define the savings here? Break even comes into picture when you are comparing expenses for a petrol car vs a diesel car. Here we don't have anything to compare with.
Gandhi is offline   Reply With Quote
Old 16th December 2011, 15:00   #9
Senior - BHPian
 
mayankjha1806's Avatar
 
Join Date: Jan 2011
Location: BLR/Gurgaon
Posts: 2,133
Thanked: 817 Times
Default Re: Car Expense Tracker Tool

Quote:
Originally Posted by 90BHP View Post
How about adding some functionality of the sheet to compare the amount you spent to buy the car against savings over the years & point where you would extracted everything from the car & you break even !!!
^^^ Or if alternatively the car was running as Taxi then finding break even would make sense, i.e. when the earnings from the car cross the expenses on the car.

break-even point (BEP) is the point at which cost or expenses and revenue are equal: there is no net loss or gain.
(Break-even - Wikipedia, the free encyclopedia)

Last edited by mayankjha1806 : 16th December 2011 at 15:03.
mayankjha1806 is offline   Reply With Quote
Old 16th December 2011, 15:13   #10
BHPian
 
90BHP's Avatar
 
Join Date: Sep 2011
Location: Mumbai
Posts: 233
Thanked: 38 Times
Default Re: Car Expense Tracker Tool

Quote:
Originally Posted by Gandhi View Post
Can you elaborate more?

How do you define the savings here? Break even comes into picture when you are comparing expenses for a petrol car vs a diesel car. Here we don't have anything to compare with.
The purchase cost of the car was "x"
Post adding all fuel, accessories & servicing the cost became "x + y"

Cost of commute per km using taxis or autos is "a"
Multiply this with the total distance travelled by the car "b"

Subtract "a + b" from "x + y", this will eventually reach zero & then start going positive after one point. Determine the distance "b" using the equation "x + y/a" to see what's your break even point.

I am doing this from a perspective that, if I don't have my car, I will use a taxi or auto to commute. Obiviously using public transport would be far cheaper but, I am sure not a lot of us, use this option if their vehicle is not available.
90BHP is offline   Reply With Quote
Old 16th December 2011, 15:25   #11
Senior - BHPian
 
shankar.balan's Avatar
 
Join Date: Apr 2008
Location: BLR
Posts: 8,053
Thanked: 5,304 Times
Default Re: Car Expense Tracker Tool

Thanks a lot for this. It is a first class initiative!


Quote:
Originally Posted by Gandhi View Post
All of us have cars and we like to track lot of details about or cars (like Petrol bills, servicing costs, accessories cost etc etc).

I like to track lot of details about stuff I love, so I use an excel sheet to track such things about my car. Slowly, this excel sheet has evolved into a great tool for me to see patterns about my usage of car and its behavior.

I'd like to share this excel sheet with all you folks, so that you can use it and also add to it.

Attachment 856062

Please share more such tools (iOS apps, Android apps, more such excel sheets etc) in this thread, so that all BHPians who like to track things have a single thread to look for.

Here are two screenshots that show what kind of information this excel sheet provides -

Attachment 856061

Attachment 856060
shankar.balan is offline   Reply With Quote
Old 16th December 2011, 21:39   #12
BHPian
 
Gandhi's Avatar
 
Join Date: Jul 2009
Location: Bay Area, CA
Posts: 980
Thanked: 199 Times
Default Re: Car Expense Tracker Tool

Quote:
Originally Posted by 90BHP View Post
I am doing this from a perspective that, if I don't have my car, I will use a taxi or auto to commute. Obiviously using public transport would be far cheaper but, I am sure not a lot of us, use this option if their vehicle is not available.
That's a very good idea but won't be possible in the scope of an excel sheet. We will need systems that can track even changes in taxi/auto/bus fairs over time and considers that also in calculations.
Gandhi is offline   Reply With Quote
Old 16th December 2011, 22:30   #13
Distinguished - BHPian
 
CrAzY dRiVeR's Avatar
 
Join Date: Jun 2006
Location: Bangalore / TVM
Posts: 8,422
Thanked: 14,213 Times
Default Re: Car Expense Tracker Tool

Quote:
Originally Posted by mayankk View Post
aCar on android.
it is awesomeness!
I use fuellogic pro on android. Very good app, which takes into consideration fuel costs, service costs etc, and provides all sorts of values and graphs.
CrAzY dRiVeR is offline   Reply With Quote
Old 20th January 2012, 16:38   #14
BHPian
 
Gandhi's Avatar
 
Join Date: Jul 2009
Location: Bay Area, CA
Posts: 980
Thanked: 199 Times
Default Re: Car Expense Tracker Tool

Quote:
Originally Posted by mayankk View Post
aCar on android.
it is awesomeness!
Yes it is. I recently moved to Android and checked this app out. Donated to them and got the Pro version of the app. It's simply awesome.

It imported all the data from my Excel sheet with breeze. Hats off to developer.
Gandhi is offline   Reply With Quote
Old 20th January 2012, 17:21   #15
Senior - BHPian
 
R2D2's Avatar
 
Join Date: Oct 2008
Location: Punya Nagari
Posts: 1,669
Thanked: 789 Times
Default Re: Car Expense Tracker Tool

Quote:
Originally Posted by Deep Blue View Post
Anything for Iphone?
I use ACar for the 'droid and Road Trip on iPhone. Both are excellent apps.

Regards,

PS - here's the developer's site www.darrensoft.ca

Last edited by R2D2 : 20th January 2012 at 17:24.
R2D2 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
Spied! 2016 Triumph Street Tracker and Tracker R jkdas Superbikes & Imports 0 20th December 2014 15:44
Major expense in a brand new Fiat Punto SankalpDesai Technical Stuff 45 12th September 2011 12:42
City Fares dropped to economy class at the expense of jazz music sidindica The Indian Car Scene 33 17th January 2010 20:06
Dont care about traffic laws any more, then weekend expense will be more!!! mjothi Shifting gears 8 16th March 2009 16:43


All times are GMT +5.5. The time now is 06:37.

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