Calculating fuel consumption ???

Submitted: Thursday, Aug 12, 2004 at 20:50
ThreadID: 15514 Views:7938 Replies:13 FollowUps:33
This Thread has been Archived
Ok so I was not good at maths and I am still not, I leaned more towards science. Ok to get litres per 100Km what is the calculation. Total Km's travelled and dividing by the litres used you get a figure - then what ?
Also how do you covert this to mpg also.
Back Expand Un-Read 0 Moderator

Reply By: Moneypit - Thursday, Aug 12, 2004 at 21:13

Thursday, Aug 12, 2004 at 21:13
Beddo

I have an Excel Spreadsheet that will do all the working out for you. Youy put in the K's travelled between fills, litres used [put in at the fill] and the cost of the lot. It then works out K/per litre, Litres per 100K's and MPG.

Not my handywork, someone on here or Overlander gave it to me ages ago and very useful.

Give me an email address and I'll flog it off to you.

Put your email as eg: - dog at cat dot com dot au to avoid the knobs with there address vacuums picking your address up though.

Dave B
AnswerID: 72385

Follow Up By: Member - Jack - Thursday, Aug 12, 2004 at 21:16

Thursday, Aug 12, 2004 at 21:16
Hi Moneypit:

I am similarly "mathematically challenged". I'd like a copy if you'd be good enough to send one to me, please.
jeller @ bigpond dot net dot au

Thanks.
Jack
The hurrieder I go, the behinder I get. (Lewis Carroll-Alice In Wonderland)

Member
My Profile  My Position  Send Message

0
FollowupID: 332567

Follow Up By: Voxson (Adelaide) - Thursday, Aug 12, 2004 at 21:30

Thursday, Aug 12, 2004 at 21:30
ditto if you dont mind

gqpatrol@bigpond dot net dot au
0
FollowupID: 332571

Follow Up By: Member - Ivan (ACT) - Thursday, Aug 12, 2004 at 21:37

Thursday, Aug 12, 2004 at 21:37
and again ;-)

isanders at ozemail dot com dot au

thanks mate
Cheers,

Ivan
2008 D4D Prado

Member
My Profile  Send Message

0
FollowupID: 332574

Follow Up By: Moneypit - Thursday, Aug 12, 2004 at 21:40

Thursday, Aug 12, 2004 at 21:40
3 asked so far, 3 sent

DRB
0
FollowupID: 332575

Follow Up By: 4by4 - Thursday, Aug 12, 2004 at 22:51

Thursday, Aug 12, 2004 at 22:51
any chance of sending one more.........muchly appreciated......

rb332211 at hotkey dot net dot au

cheers...........
0
FollowupID: 332582

Follow Up By: XS Challenger - Thursday, Aug 12, 2004 at 23:01

Thursday, Aug 12, 2004 at 23:01
Please could I have the spreadsheet as well. I did make one up once but lost it when I had to reload Windows.

Thankyou in advance

richardrose at itconnect dot net dot au
0
FollowupID: 332584

Follow Up By: Member - Ken - Thursday, Aug 12, 2004 at 23:21

Thursday, Aug 12, 2004 at 23:21
Dave B

Could you please include me on your distribution list.

email: krobbo@optusnet.com.au

Thanks

Ken Robinson
0
FollowupID: 332587

Follow Up By: Member - Mungo Explorer (NSW) - Friday, Aug 13, 2004 at 01:22

Friday, Aug 13, 2004 at 01:22
Me too please :-)
g dot minnerup dot at unsw dot edu dot au
0
FollowupID: 332597

Follow Up By: Moneypit - Friday, Aug 13, 2004 at 01:49

Friday, Aug 13, 2004 at 01:49
Done to here. Mungo I think your addie might be srong [one dot to many at the end of minnerup so I sent it to twice, once with the dot and one without. Let me know if it gets through.

DB
0
FollowupID: 332600

Follow Up By: marklynn - Friday, Aug 13, 2004 at 01:54

Friday, Aug 13, 2004 at 01:54
And another copy if you would please to:

marklynnatswiftdsldotcomdotau

Thanks heaps

Mark
0
FollowupID: 332601

Follow Up By: Gajm (VIC) - Friday, Aug 13, 2004 at 02:33

Friday, Aug 13, 2004 at 02:33
Can I trouble you for one of those as well please.

gajm_oz at yahoo dot com

Thanks
Glenn
0
FollowupID: 332603

Follow Up By: Member - Michael- Friday, Aug 13, 2004 at 07:53

Friday, Aug 13, 2004 at 07:53
Dave
Could you email me one also
mjpratt at iinet dot net dot au

Many thanks
Mike
May the fleas of a thousand afghan camels infect the crutch of your enemy and may their arms be too short to scratch.

Lifetime Member
My Profile  Send Message

0
FollowupID: 332608

Follow Up By: DaveNJude - Friday, Aug 13, 2004 at 08:32

Friday, Aug 13, 2004 at 08:32
Me too......

sdavo at yahoo dot com

Thanks

Dave
0
FollowupID: 332612

Follow Up By: Member - Spook (SA) - Friday, Aug 13, 2004 at 08:51

Friday, Aug 13, 2004 at 08:51
G'day Dave
could i also have a copy??
bradden AT bigpond DOT com
Cheers
Brad
0
FollowupID: 332616

Follow Up By: Bill n Di - Friday, Aug 13, 2004 at 11:16

Friday, Aug 13, 2004 at 11:16
Me too please - sounds fantastic - I am always impressed by thoise people who can actually find a use for Excel formulas!!

maneyd at iinet dot net dot au

Dian
0
FollowupID: 332630

Follow Up By: Member - Geoff & Karen - Friday, Aug 13, 2004 at 11:34

Friday, Aug 13, 2004 at 11:34
Moneypit, you should be selling these excel spreadsheets........can you please email me one too, would be much appreciated.......
Thanks
gckmpiper@bigpond.com.au
0
FollowupID: 332633

Follow Up By: Bill n Di - Friday, Aug 13, 2004 at 22:34

Friday, Aug 13, 2004 at 22:34
Can you send me a copy too please

maneyd at iinet dot net dot au

Dian

0
FollowupID: 332717

Follow Up By: Moneypit - Friday, Aug 13, 2004 at 23:09

Friday, Aug 13, 2004 at 23:09
Sent to everyone from the last one to this last one. If it did not get to you let me know.

Dave
0
FollowupID: 332729

Follow Up By: Member - John R. W (NSW) - Saturday, Aug 14, 2004 at 11:07

Saturday, Aug 14, 2004 at 11:07
Dave,
Would you please send me the details. Many thanks.
JRW
0
FollowupID: 332755

Follow Up By: Jeff (Beddo) - Saturday, Aug 14, 2004 at 17:08

Saturday, Aug 14, 2004 at 17:08
Thanks Moneypit, I feel better now that there are other mathamatically challenged persons out there. Yes I would love the XL spreadsheet send to jed at integritynet dot com dot au
0
FollowupID: 332792

Follow Up By: Member - Clive G (Int) - Saturday, Aug 14, 2004 at 19:01

Saturday, Aug 14, 2004 at 19:01
Dave.
I would love a copy of that spreadsheet.
Cheers. Clive G.

clivegroom@xtra.co.nz
0
FollowupID: 332795

Follow Up By: carazy - Saturday, Aug 14, 2004 at 22:29

Saturday, Aug 14, 2004 at 22:29
Dave B,
Could you please send me one of those spread sheets as well. We just got back from a 3 week trip up the central road to Ayres rock, Alice springs, coober pedy, streaky bay, across the nullarbor & back home to W.A. The thing is I was trying to keep track of my fuel consumption but totaly ballsed it up i.e. I started from home using the trip meter, then when the sub tank ran out of fuel I switched over to the main & reset the trip meter-oops. No I didn't record the odometer reading to start with. As the trip progressed, I had all sorts of scribble written down on tissue boxes. When I got back home it took nearly a week to work it all out. I only just said yesterday to the other half that we should make up some sort of chart on the PC. Any way if you could send me the email on how to do it, we would very much appreciate it.
Thanks, carazy.
0
FollowupID: 332805

Follow Up By: carazy - Saturday, Aug 14, 2004 at 22:34

Saturday, Aug 14, 2004 at 22:34
Dave B,
Sorry I forgot the email address. It is neryswilkins @ bigpond dot com dot au
Cheers-carazy.
0
FollowupID: 332806

Follow Up By: Moneypit - Sunday, Aug 15, 2004 at 02:25

Sunday, Aug 15, 2004 at 02:25
Sent to everyone except JRW. Not that I don't like JRW its just that JRW is keeping his addy a secret. Does not make it easy.

Dave
0
FollowupID: 332812

Follow Up By: XS Challenger - Monday, Aug 16, 2004 at 22:12

Monday, Aug 16, 2004 at 22:12
Hi Money Pitt,
Sorry mate but my copy never made it so I'll give you my address again

richardrose@itconnect.net.au

Thanks again it is going to be a big help.

Richard
0
FollowupID: 332983

Follow Up By: Member - John R. W (NSW) - Tuesday, Aug 24, 2004 at 08:39

Tuesday, Aug 24, 2004 at 08:39
Hi there Dave,
sorry for delay in getting back to you. My address is
njwardatbigponddotnetdotau

Would very much appreciate your sending the xl fuel calculator to the above address.

Many thanks
JRW
0
FollowupID: 333845

Reply By: mcgra - Thursday, Aug 12, 2004 at 21:20

Thursday, Aug 12, 2004 at 21:20
if you have a full tank and zero the reading drive to nearly empty and take the reading.

90lts reading on odometer 500klm divide 90 into 500 that gives yr ks per lt.

if u want mpg

5 lts =1gallon.
10ks about 6 miles

so divide ks by 1.6 for miles

divide lts by 5 to get gallons

gra
AnswerID: 72387

Follow Up By: ross - Saturday, Aug 14, 2004 at 00:54

Saturday, Aug 14, 2004 at 00:54
"5 lts =1gallon.
10ks about 6 miles

so divide ks by 1.6 for miles

divide lts by 5 to get gallons"

Its actually closer to 4.5 lts= 1 imperial gallon
0
FollowupID: 332737

Reply By: andysgu - Thursday, Aug 12, 2004 at 21:37

Thursday, Aug 12, 2004 at 21:37
Hi Jeff.
Join the club pocket calculators make it easy these days its even easier if you have a slide calculator that Castrol put out about 20 years ago.
l divide the litres by the kilometres eg.
100litres divided by 700 kilometres = 0.1428 = 14 litres per kilometre = 20 mpg
80 litres divided by 650 kilometres = 0.1230 = 12 litrse per kilometre = 23.5 mpg
dont ask me how to convert litres per 100 to mpg wouldn't have a clue but anything bellow 20litres/ 100ks your getting 14mpg.
Andy.
AnswerID: 72391

Follow Up By: Member - Ken - Thursday, Aug 12, 2004 at 23:19

Thursday, Aug 12, 2004 at 23:19
Evening Andy

Maaaaaaaaaaaaaaate! My best friend from school days father used to work for Castrol in WA. He had a sh$t load of those calculators in 1968 and I still have one.

It is the best thing since pop top canned p$ss. Nobody but myself gets to look at it, let alone use it.

Just thought I would share that little annecdote with you.

Just wish they would issue an updated version of it.

Regards

Ken Robinson
0
FollowupID: 332586

Follow Up By: Moose - Friday, Aug 13, 2004 at 13:22

Friday, Aug 13, 2004 at 13:22
Mate you have stuffed it up. If you were using 14 litres to travel one kilomotre you most certainly wouldn't be covering 700 kms with 100 ltrs.
You need to divide the kms by the ltrs and that gives you how many kliks per litre used or alternatively divide the ltrs by kms and multiply by 100 to get the ltrs per 100 kms. The latter is the official measure.
And to convert from ltrs per 100 kms to MPG just divide the amount into 283.
0
FollowupID: 332646

Reply By: Member - Sparkie (QLD) - Friday, Aug 13, 2004 at 07:53

Friday, Aug 13, 2004 at 07:53
The best way for me to remember the equation is to divide the little number by the big number and then multiply by one hundred.

I only ever work out litres per hundred but if you used gallons per 100 miles it should work the same.

Probably sound patronising but it is the way I remember the equation.

Sparkie(IE not Y) ;-)
AnswerID: 72418

Reply By: Baz (NSW) - Friday, Aug 13, 2004 at 08:54

Friday, Aug 13, 2004 at 08:54
Hey Jeff try this site.

Fuel calculator

Baz.
AnswerID: 72426

Reply By: Member - Rick (S.A.) - Friday, Aug 13, 2004 at 09:16

Friday, Aug 13, 2004 at 09:16
Jeff,

I am also challenged by these things, but here goes:

Let's say you travelled 450km from full.

That is, you drove 4.5 lots of 100km.

Continuing the example, when you topped up the tank it took 66 litres of fuel.

So, by dividing 66 (litres) by 4.5 (the number of HUNDREDS of kilometres, as above) you get

14.66 litres per 100 km

Easy..............!!!!!!!!!

To convert to mpg, well who cares? Train your mind to drop that antiquated crap
(I am over 50 y.o, so any one can do this). Another way of saying that is to begin a new habit today: calculate & think only in litres/100km. You'll soon get used to it, and all comparisons are done in the metric system. Then you'll be comapring apples with apples.

have fun
AnswerID: 72431

Reply By: Steve - Friday, Aug 13, 2004 at 10:07

Friday, Aug 13, 2004 at 10:07
could i also have a copy please.

snburtonatoptusnet.com.au
AnswerID: 72439

Follow Up By: harry5 - Friday, Aug 13, 2004 at 13:44

Friday, Aug 13, 2004 at 13:44
Baz sooo easy thank you
0
FollowupID: 332650

Reply By: ianmc - Friday, Aug 13, 2004 at 15:06

Friday, Aug 13, 2004 at 15:06
A gallon is NOT 5 litres, its 4.56 litres!

I am constantly amazed how many people still tell U they get so many miles per gallon, yet cannot tell U how many kms/litre they get & this is the first step as the put litres in the tank & do kilometres not miles. Lotsa guesswork or thinktheydos
here!

Get used to it mate, its litres & kms nowadays. Just get yourself straight on how many mpg 10km/l is & divide up or down from there if U must.
AnswerID: 72468

Reply By: ginga - Friday, Aug 13, 2004 at 18:11

Friday, Aug 13, 2004 at 18:11
All I do is:
1. calculate the number of litres per hundred kilometers (that's fuel used in litres divided by distance travelled times 100); then
2. divide the litres per hundred kilometers into 283.

Interestingly, this formula works BOTH ways. In other words, if you know the miles per gallon, divide that into 283 to get litres per hundred.

Hope this helps.
AnswerID: 72491

Follow Up By: Jeff (Beddo) - Saturday, Aug 14, 2004 at 17:13

Saturday, Aug 14, 2004 at 17:13
Ginga thanks for that, very helpful.
0
FollowupID: 332793

Reply By: Bros - Friday, Aug 13, 2004 at 19:27

Friday, Aug 13, 2004 at 19:27
Moneypit,
Yes please.
lex.smithatbigponddotcom
Work is the curse of the down and out bludger.

Lifetime Member
My Profile  Send Message

AnswerID: 72517

Follow Up By: Moneypit - Friday, Aug 13, 2004 at 23:10

Friday, Aug 13, 2004 at 23:10
Sent to all the names that appear above here

Dave B
0
FollowupID: 332731

Reply By: Snatchem - Saturday, Aug 14, 2004 at 12:21

Saturday, Aug 14, 2004 at 12:21
Sorry to ask moneypit could you please send one to the name below thanks

Snatchem

vpeat@tpg.com.au
AnswerID: 72592

Reply By: Member - Blue (VIC) - Sunday, Aug 15, 2004 at 00:19

Sunday, Aug 15, 2004 at 00:19
G'day moneypit

thinking a a good business venture for you... go out and buy 1000 blank discs, put your spready on then and flog them off for $5 each... You will soon have a nice accessory fund going...

Blue
AnswerID: 72651

Reply By: Moneypit - Sunday, Aug 15, 2004 at 02:20

Sunday, Aug 15, 2004 at 02:20
All to here have been sent. Getting RSI from it

Hope its what your actually after

Dave
AnswerID: 72652

Follow Up By: Harry - Sunday, Aug 15, 2004 at 21:10

Sunday, Aug 15, 2004 at 21:10
Hey CARAZY,
You need one of those Outback Trip log books that HEMA make.
Been using one for a while now and it 's very easy to use, especially when someone asks you , where did you get fuel at such & such and how much a litre was it.
Suggestion though , if you find one, make up an index page for the 1st page so you can number the pages in relation to what trip.
I Emailed HEMA about an index so maybe they have already done that, they said they would.
Have a good 1
0
FollowupID: 332850

Sponsored Links

Popular Products (13)