Pence Per Mile Calculator

[ms51ves3]

I was bored, so made one this morning in Excel.

Simply input the price of your consumables and how many miles you get from them into the pale blue area, and the sheet will do the rest. The guestimated figures in there currently are for my ER5.

The sheet will show you your current PPM and also show you a projected PPM as petrol prices rise, which can also be seen as a graph under the PPM Forecast Graph tab.

Enjoy.

[pinkyfloyd]

Too scared to. The beastie is heart attack causing if you worked out how many gallons it takes you to go each mile.
____________________
illuminateTHEmind wrote: I am just more evolved than most of you guys... this allows me to pick of things quickly which would have normally taken the common man years to master
Hockeystorm65:.well there are childish arguments...there are very childish arguments.....there are really stupid childish arguments and now there are......Pinkfloyd arguments!
Teflon-Mike:I think I agree with just about all Pinky has said.

[T0MMY]

Either your ER5 is PHENOMENALLY cheap to run or you're a couple of orders of magnitude out

You've got the figures in £ per mile rather than pence.

[ms51ves3]

[edeaton]

Cool, thanks for this post

Sorry to be a nooooob but whats c&s? chain & sprockets?
____________________
Current: 1997 Triumph Daytona T595 (new engine)
Past: 1989 Honda VFR400 NC30 & 2001 Honda CG125

[ajbsmirnoff]

[pinkyfloyd]

Aj, The storm is far from economical. Gives me around 35mpg average but she is good fun.
____________________
illuminateTHEmind wrote: I am just more evolved than most of you guys... this allows me to pick of things quickly which would have normally taken the common man years to master
Hockeystorm65:.well there are childish arguments...there are very childish arguments.....there are really stupid childish arguments and now there are......Pinkfloyd arguments!
Teflon-Mike:I think I agree with just about all Pinky has said.

[crowe]

For those unable to download the file (work restrictions?) here is a website that calculates similiar figures...for fuel usage at least:

https://www.torquecars.com/tools/uk-mpg-calculator.php



____________________
Kawasaki ER-5

[ms51ves3]

[cb1rocket]

do i detect a flaw?

The £ per Mile under the forecast doesn't appear to update itself and worksheet appears to be locked, ie only you fiddle in the blue boxes.........?

everything else appears to work fine

[Pussy Magnet]

Nice you should actally code this in VB ( coder ) you may be onto something here x

[ms51ves3]

[ms51ves3]

Now a pence per mile calculator like it should have always been

If anyone has any consumable items they would like to suggest to put in the spreadsheet to make it more accurate, please post them up.

[cb1rocket]

[ms51ves3]

[cb1rocket]

no worries, I just learnt something new on how to get excel to fill a cell without changing the sodding cell reference, ie everytime i fill for the remaining cells it just carried over to G5, G6, G7 (sigh!)

Good work, have modified to include my car running costs!

[ms51ves3]

[cb1rocket]

sorry should be =J4*4.55/$E$4

oh ya mum? cool just learnt that off the web

[cb1rocket]

Here's the modified excel sheet for my car running costs!

No wonder I stick with bikes!

[ms51ves3]

£500 repairs every 1000 miles

[cb1rocket]

a little exgaggerated but the last 4 of 6 cars I owned all blew their headgaskets!

[T0MMY]

Will number 7 be another Rover or are you considering a change of marque?

[Stowelly]

this seems a little wrong

Item Cost (£) Miles Pence Per Mile
Petrol 16.00 130 56.00
Tyres 180.00 6000 3.00
C&S 94.00 15000 0.63
Oil & Filter25.00 4000 0.63
Brake pads55.00 10000 0.55



why is the pence per mile = cost * 4.55 / miles;

the pence per mile should literally be cost / miles surely? where does the 4.55 come from?

[blurredman]

I cannot open it
____________________
CBT: 12/06/10, Theory: 22/09/10, Module 1: 09/11/10, Module 2: 19/01/11
Past: 1991 Honda CG125BR-J, 1992 (1980) Honda XL125S, 1996 Kawasaki GPZ500S, 1979 MZ TS150.
Current: 1973 MZ ES250/2 - 18k, 1979 Suzuki TS185ER - 10k, 1981 Honda CX500B - 91k, 1987 MZ ETZ250 (295cc) - 40k, 1989 MZ ETZ251 - 51k.

[AngelGrinder]

21 PPM, damn the poor fuel consumption of a litre twin.

Oh well, the noise makes up for it
____________________
Currently Riding - 2002 Aprilia RSV1000 Mille