Spreedsheet for working MPG`s

Unless I have misunderstood your question this is extremely simple to do. Enter gallons consumed in cell A1, distance covered in cell A2. Then in A3 enter '=A2/A1' without the quotes.

Cheers,

Andy

Ok using column A for l of fuel and B for miles travelled on row 4 it would look something like this:

=B4/(A4/4.54609)

Why? Are you incapable of working out the formula for yourself?

F*ck me, I'm a stupid truck driver and I can work it out OTTOM.

Absolute basic example (alter as needed) In A1 put the number of litres. In B1 put the number of miles done.

In A2 put:

=(B1/(A1/4.5461))

Job done. Did you actually do maths at school?

Hi.

It's quite simple.

The column headings you want are miles, litres, and MPG.

Fill your tank to the brim, reset the trip meter, then drive it until the fuel is low. Then fill it to the brim again, preferably using exactly the same pump at the same petrol station, to the same number of clicks.

Put the number of miles in the miles column, the number of litres the tank took in the second column, and then the following formula in the MPG column:

=MILES/(LITRES/4.546),

replacing MILES and LITRES with the relevant cell references.

Or you could do it quite easily on the calculator on your phone, at the petrol station.

Punch in the no. of miles, multiply by 4.546, then divide by no. of litres. Bingo.

Peter

Have you considered he may still be at school?

He posted a perfectly polite question, asking for a little help, no need whatsoever for a reply like that.

This is usenet. It's a bit like the real world, except through a computer screen. Just like the real world, you can't expect to be wrapped up in cotton wool.

Working out MPG isn't exactly rocket science, and it wouldn't have taken much guesswork for someone who's obviously got the ability to use a computer to just work it out for themselves. Miles per gallon. Erm, let me think - that'll be, erm, miles, divided by, , gallons. A quick google search should quite easily give a conversion figure from litres to gallons (4.546 litres = 1 gallon). Not difficult.

Peter

Yeah I have one on my website in Excel format. Drop by

Aha found it.

Yes but can you rewire a plug?

Usenet or not, there's no need to come out with this sort of reaction. The regulars in here or those who work with vehicles may know what to use, but those people who have just driven because they need to get to work and have never had any other use for a spreadsheet.

I may know a little about cars and similar stuff and I can just about rewire a plug, but I don't know jack about a lot of stuff and I'd be asking the same questions.

Ok, so if someone came up to you on a garage forecourt in the 'real world', and asked you how to calculate MPG, you think it would be acceptable to start swearing and cursing at them and calling them an idiot?

No, but it wouldn't surprise me if that's the response they might have got from some people. That's what I was saying.

I'd tell them to divide the number of miles by the number of gallons used.

Peter

That depends on if the garage has Google.

This should help you a little

- DJ Crazy Frog

I'd make it plainly obvious that I thought they were a fool.

Yep and properly including tinning the bared ends so they don't fray.

Oh come on, why the hell should I give anyone who obviously cannot be arsed/capable to think for themselves the time of day?

Its not bloody rocket science. Miles driven divided by fuel used. Help file in Exel shows you how to stick in a formula.

Well that's currently considered dubious practice , due to the solder cold flowing, bootlace ferrules are the way to protect fine stranded cable.

Isn't it now considered bad practice to rewire a plug full stop. Soon you will need to get a qualified electrician in to sign off building regs every time you change a bulb.

Update: try this,

You can download it too.

It is virus free Norton Internet Security - Virus definition file 03-06-2005 but as ever, it's at your risk.

- DJ Crazy Frog

Not only bad practice, it's illegal if your not qualified. No one will know until some-one gets hurt or killed Then chances are you'll do some time. Big company's have all electrical leads PAT tested annually to make sure they not liable.

Fitting a plug is OK. Fitting a light bulb is OK. Replacing a light fitting is dubious, installing a new one where there is no pre-existing one is not.

Oddly enough of course you don't need a qualification to work on a public building, so I can legally kill hundreds of people in a school from an electrical fire but not myself at home.

Add to the fact that you need no qualifications to work on your own gas installation then the whole thing is even more stupid.