27-03-2012, 06:14 PM
Right i'm a massive nerd and built an Excel spread sheet that tracks mpg and fuel costs.
I have an app that records the data and then that data can be imported into excel.
The winner is the person with the highest average MPG
If you need any help with the spread sheet use this thread for help!
I'm attaching both an MPG calcualtor and a spread sheet that calculates how much you would save if you used veg oil
The yellow columns are where you need to add the data into.
Delete the data i have already put in as an example and add yours in.
the other columns all have formulas so if you want the spread sheet to work dont mess with them.
Also the charts will need updating when you add new data but thats just a case of adding a number to the series.
I have an app that records the data and then that data can be imported into excel.
The winner is the person with the highest average MPG
If you need any help with the spread sheet use this thread for help!
I'm attaching both an MPG calcualtor and a spread sheet that calculates how much you would save if you used veg oil
The yellow columns are where you need to add the data into.
Delete the data i have already put in as an example and add yours in.
the other columns all have formulas so if you want the spread sheet to work dont mess with them.
Also the charts will need updating when you add new data but thats just a case of adding a number to the series.
Quote:(15:06:27) Toms306: Wd40d it and had a good tug, came straight off