Mathmatical formulae help please

[PeteXXX]

Good morning clever people.
I need formulae to convert fuel consumption figures. An equation, ordinary calculation and an Excel formula will suffice..

How do I (you) convert Litres per 100km to kilometers per litre.

The reason I ask is that my truck display gives me l/100km, my company report is in kpl

Oh, by lunchtime today please

 

[Markymark]

100 divided by your figure.

For example, if you did 5 litlres per 100km, 100/5 = 20kpl

Or in Excel, if A1 is your figure, cell B1 would be '=100/A1'

 

[Falco Frank]

Calcs and more....

http://www.cleavebooks.co.uk/scol/ccfuel.htm

 

[HertzvanRental]

Whatever your reading for l per 100k, move the decimal point two places to the left to give l per km.

 

[Markymark]

Whatever your reading for l per 100k, move the decimal point two places to the left to give l per km.

....except he (?) wants km per l not l per km

 

[PeteXXX]

Yes I (he) do.

It is not as simple as moving a decimal point, sadly.

 

[PeteXXX]

100 divided by your figure.

For example, if you did 5 litlres per 100km, 100/5 = 20kpl

Or in Excel, if A1 is your figure, cell B1 would be '=100/A1'

That works for me.. thanks

Edit: what about convertion in the opposite direction?

 

[HertzvanRental]

....except he (?) wants km per l not l per km

Sorry, wrong glasses

 

[Markymark]

Yes I (he) do. .

Are you yodelling now?

 

[Markymark]

That works for me.. thanks

Edit: what about convertion in the opposite direction?

Same formula.
If 20 km/l then 100/20 = 5 l/km

 

[PeteXXX]

Are you yodelling now?

Incessantly...

Same formula.
If 20 km/l then 100/20 = 5 l/km

Simples. Thanks again

 

[PeteXXX]

[QUOTE 3739937, member: 9609"]So what type of truck is it and how many mpg is it getting ? (divide 284.1 by your litres per 100km figure)

(my 284.1 comes from 100 x 5 / 8 x 4.54545)[/QUOTE]
It's a horrible DAF CF automatic.
My yearly average to date, grossing up to 44tons is 10.8 mpg. On a lighter load and good route, I can exceed 12.5 mpg. A double decker trailer fully loaded on a hilly A road is often down to7 or 8MPG

Thanks for that calc.

 

[Tim Hall]

Same formula.
If 20 km/l then 100/20 = 5 l/km

Keen students will notice that litres per kilometre can be expressed in units of area.

So away with these newfangled litres and kilometres. Report your fuel use in acres.

 

[Markymark]

Keen students will notice that litres per kilometre can be expressed in units of area.

So away with these newfangled litres and kilometres. Report your fuel use in acres.

Ah, yes, litres being distance^3 and km being distance^1 leaving distance^2 or area.

 

[winjim]

Same formula.
If 20 km/l then 100/20 = 5 l/km

You've mislaid a couple of powers of ten.