Free fuel recording spreadsheets.

Submitted: Monday, Apr 02, 2007 at 04:37
ThreadID: 123452 Views:4446 Replies:1 FollowUps:1
This Thread has been Archived
Free fuel recording spreadsheets.

Using my recording system and inputting litres used, distance travelled and cost of fill,
you will record these values for the trip, PLUS you will automatically calculate

miles travelled
gallons used
miles per gallon
Km/L
L/100km

(A) for each fill up of fuel
(B) accumulated totals and averages of the above

PLUS because our odometers are never completely accurate you can correct the calculations when you have an opportunity to check your odometer against a known correct distance.

***************************************************
How do I get it???
type www.animal-acupuncture.com/fuelcalcs.zip
into your browser and save the file to your hard drive.
You must have winzip or winrar on your computer to extract the 3 files it contains.
One is this file readme.txt.

Instructions for fuel calculations spreadsheets.

(1) You must have Microsoft EXCEL installed on your computer
(2) Two excel files are provided in this zipfile
(a) Myfuel.xls which is a demo with my actual figures for a period
(b) Bogfuel.xls which is an empty excel spreadsheet for you to make a clean start.
(3) Before a new start open bogfuel.xls and then save it with a name to suit yourself
eg: PerthTrip.xls or January07.xls or whatever suits your purpose. This then leaves the base spreadsheet empty for renaming as many times as you might want in the future.

You enter the date in the format dd/mm/20xx....ie 01/04/2007.
tab to the next field and enter the place where you are buying the fuel...eg NorsemanBP.
tab to the next field and enter the number of litres purchased.
tab to the next field and enter the cost in dollars and cents.
tab to the next field and enter the reading on your trip-meter in km eg 354.6

That is all you need to enter.

Make sure you reset your trip meter after writing down the amounts and before you leave the gas station. I keep a normal logbook for this purpose and fill in the spreadsheet later when convenient.

Note you must either completely fill that tank at each visit to the bowser or you will need to keep a running tally until such time as you do a complete fill. I have long range tanks and often only put in 150L at a time to take advantage of Woollies fuel dockets.However when I leave town I fill up completely and close off the running tally.
Thus you can now understand how I managed to get 404L of fuel in "one" fill. Actually it was the sum of several part fills and one topup, covering 1966km.

When you come across a measured distance on the road, say 5km (it can be any figure), record what your odometer says for the distance.

For example if your measured 5km is shown as 4.9km on your odometer, this shows as an error of -0.2% in distance travelled and changes my average mpg from 13.8 to 14.07.
Conversely if the correct 5km reads as 5.1km, this is an error of +0.2% in distance travelled and will change my average mpg from 13.8 to 13.52.

Of course all the other variables change too. This error can be inherent in your vehicle OR it can be caused by oversize/undersize rubber, or tyre wear.

NOTE that the first 25 lines of entry are fixed and that lines 26 to 2450+ scroll leaving the top section visible at all times. This is just for ease of use.

Remember to SAVE your input every time.

I hope that this will be as useful to you as it has been to me.
Complaints or thanks may be sent to
davidgilchrist@austarnet.com.au

Back Expand Un-Read 0 Moderator

Reply By: NIK `N` OFF - Monday, Apr 02, 2007 at 06:31

Monday, Apr 02, 2007 at 06:31
Thanks David i will give it a go but i'm not sure i want to scare myself seeing the actual economy figures :-))

AnswerID: 570974

Follow Up By: David & Franki - Tuesday, Apr 03, 2007 at 02:35

Tuesday, Apr 03, 2007 at 02:35
Hi All,
it appears that you need to have the ANALYSIS TOOLPAK installed in your version of EXCEL for the calculations to work.
I have it installed on my computer, when I uninstall it I get the errors complained of.
Therefore to make this software work you need to install this toolpak.

To do this, have your excel installation CD handy and then open EXCEL.
Go to TOOLS/ADDINS and choose AnALYSIS TOOLPAK by ticking the box, then follow the prompts to insert your CD.
Once you have this done, you can use the inbuilt EXCEL feature which does all the calculations of MPG, etc etc.

Any further problems please contact me direct on
davidgilchrist@austarnet.com.au

Cheers,
David
0
FollowupID: 847446

Our Sponsors