Calculating fuel consumption ???
Submitted: Thursday, Aug 12, 2004 at 20:50
ThreadID:
15514
Views:
8526
Replies:
13
FollowUps:
33
This Thread has been Archived
Jeff (Beddo)
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.
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
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
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
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
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...........
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
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
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
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
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
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
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 |
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
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
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
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
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
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
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
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
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
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.
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.
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
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
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
FollowupID:
333845
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
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.
FollowupID:
332646
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: 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.
FollowupID:
332793