Petrol Savings Chart

[feng125]

Hi all, here's an excel file that calculates petrol savings everytime you pump at GP Esso. Some of you might remember me posting this file a while back, i refined it to make it more user friendly with more updated information on petrol prices.

 

This chart includes:

 

1. Toll charges for Singapore side to and fro

2. Toll for M'sian highway

3. Petrol consumption every time you travel to GP Esso.

 

 

To use this chart you need to key in 3 pieces of information; your bike petrol consumption in km per litre of petrol, your fuel tank capacity, and the total distance from where you are to GP Esso and back (remember to include the 11km of U'turn from GP Esso to Bandar Nuasajaya exit and back to M'sian customs.)

 

 

Hope this benefits some riders here, especially those who frequently pump through 2nd link. There have been cases where there is actually a deficit instead of a saving due to the long travelling distance.

 

 

Also do let me know what else should be fine tuned. I'll work on it.

[feng125]

[Hong-U]

You did a great favor to all of us here, Ricky.

 

 

Thumbs up for ya.

[xb84]

i think cell C37 = B16 * B22

instead of C37 = B30 * B22

resulting in more savings as we do not have to travel xx km to gp esso.

 

and your toll calculation is wrong, it shld be..

rm1.30 + rm1.30 + rm1.39(sg0.60) + rm1.39(sg0.60) = rm5.38/sg2.32

 

exchange rate conversion for toll is also wrong (wrong * to convert to ringgit instead of divide)

 

 

 

 

 

 

 

uploaded my version, any errors let me know petrol savings

(fill up the yellow boxes)

[dkwok]

actually u can u turn b4 gp esso,

maybe a bit shorter distance,

[MiCmAsTa]

I'm using a program for Sybiam phone. Which will calculte your fuel consumption and cost.

[feng125]

Originally posted by onefour02@Aug 20 2006, 07:23 PM

 

 

 

 

 

 

 

 

 

uploaded my version, any errors let me know petrol savings

(fill up the yellow boxes)

i think cell C37 = B16 * B22

instead of C37 = B30 * B22

resulting in more savings as we do not have to travel xx km to gp esso.

 

i dun agree.

 

 

and your toll calculation is wrong, it shld be..

rm1.30 + rm1.30 + rm1.39(sg0.60) + rm1.39(sg0.60) = rm5.38/sg2.32

 

exchange rate conversion for toll is also wrong (wrong * to convert to ringgit instead of divide)

 

changes done. thank u. file updated.

[xb84]

Originally posted by feng125@Aug 20 2006, 11:55 PM

i dun agree.

maybe you shld double check.

 

using ur spreadsheet:

petrol pumped is calculated both at (eg. 13litres)

 

when it shld be:

(eg. 15litres) in singapore and (eg. 13litres) in malaysia

i believe u did not offset the cost of travelling.

(as in singapore petrol kiosk are mostly just along the way home)

 

 

 

 

 

 

correct?

 

 

my petrol savings spreadsheet

[feng125]

Originally posted by onefour02@Aug 21 2006, 08:41 AM

maybe you shld double check.

 

i already double checked.

 

thank you for your feedback, i have my reasons for my calculations. i shall not go into details.

[xb84]

:cheeky:

[ericgoh79]

well done

 

its a great excel sheet thanks alot

:cheeky:

 

cheers

[shiroibai]

can someone kind enuff to send me the excel file to my email? [email protected]

 

I got problem getting into the link shown above. =((((

[Guest nE0]

Good work.

 

But you did not include another cost of the round trip.

 

For example, for a typical 1000cc machine with sporty tyres, one set would last perhaps 10,000kms with mixed riding (highway, town, occasional trackday). At $450 a pair, thats $0.045 cents per km, or for my case, a round trip of 80km, thats $3.60.

 

Then theres engine oil, 4 bottles of semi synthetic engine oil costs $60, changed every 5000km, thats $0.012cents per km, or $0.96 per 80km round trip.

 

So thats an additional $4.56. Not including other wear and tear parts, chain n sprocket, regular servicing like oil filter, air filter, wheel bearings, brake pads, valve clearance etc, it all adds up.

 

I know this sounds very calculative, but it all adds up. Of course, wear and tear, servicing intervals and costs vary from bike to bike, and varys according to riding style.

[YEN96]

Originally posted by nE0@Sep 5 2006, 04:24 PM

Good work.

 

But you did not include another cost of the round trip.

 

For example, for a typical 1000cc machine with sporty tyres, one set would last perhaps 10,000kms with mixed riding (highway, town, occasional trackday). At $450 a pair, thats $0.045 cents per km, or for my case, a round trip of 80km, thats $3.60.

 

Then theres engine oil, 4 bottles of semi synthetic engine oil costs $60, changed every 5000km, thats $0.012cents per km, or $0.96 per 80km round trip.

 

So thats an additional $4.56. Not including other wear and tear parts, chain n sprocket, regular servicing like oil filter, air filter, wheel bearings, brake pads, valve clearance etc, it all adds up.

 

I know this sounds very calculative, but it all adds up. Of course, wear and tear, servicing intervals and costs vary from bike to bike, and varys according to riding style.

yes ! very precise indeed !

 

This is the right way to calculate if wanna go fine into details !

 

Not forgetting the time to travel ??how much opportunity cost u incur per hr??

 

Take ur pay divided into per hr etc etc ........................

[flykite]

anyone will do a chart for JB petrol station? gp esso is from 2nd link.... those go by causeway will have different pricing i figure

[Guest quizesilver]

haha

aiya... i give up riding liao... if i have to go into details.

 

let juz enjoy the ride. do it safe and fun!

 

cheers

[Cool79]

Originally posted by nE0@Sep 5 2006, 04:24 PM

Good work.

 

But you did not include another cost of the round trip.

 

For example, for a typical 1000cc machine with sporty tyres, one set would last perhaps 10,000kms with mixed riding (highway, town, occasional trackday). At $450 a pair, thats $0.045 cents per km, or for my case, a round trip of 80km, thats $3.60.

 

Then theres engine oil, 4 bottles of semi synthetic engine oil costs $60, changed every 5000km, thats $0.012cents per km, or $0.96 per 80km round trip.

 

So thats an additional $4.56. Not including other wear and tear parts, chain n sprocket, regular servicing like oil filter, air filter, wheel bearings, brake pads, valve clearance etc, it all adds up.

 

I know this sounds very calculative, but it all adds up. Of course, wear and tear, servicing intervals and costs vary from bike to bike, and varys according to riding style.

semi oil cost 60 bucks for 4 bottle....

what oil is it????

normally onli cost abt 12 per bottle le

[Guest nE0]

Originally posted by Cool79@Oct 1 2006, 03:17 AM

semi oil cost 60 bucks for 4 bottle....

what oil is it????

normally onli cost abt 12 per bottle le

Well, oil prices can range from $5/litre gear oil to $25/litre high quality fully synthetic engine oil.

 

$60 per oil change is a suggested price only. You can insert your own price here, no worries

[Fufu26]

Originally posted by nE0@Sep 5 2006, 04:24 PM

Good work.

 

But you did not include another cost of the round trip.

 

For example, for a typical 1000cc machine with sporty tyres, one set would last perhaps 10,000kms with mixed riding (highway, town, occasional trackday). At $450 a pair, thats $0.045 cents per km, or for my case, a round trip of 80km, thats $3.60.

 

Then theres engine oil, 4 bottles of semi synthetic engine oil costs $60, changed every 5000km, thats $0.012cents per km, or $0.96 per 80km round trip.

 

So thats an additional $4.56. Not including other wear and tear parts, chain n sprocket, regular servicing like oil filter, air filter, wheel bearings, brake pads, valve clearance etc, it all adds up.

 

I know this sounds very calculative, but it all adds up. Of course, wear and tear, servicing intervals and costs vary from bike to bike, and varys according to riding style.

lol.. need to count until like that.. park ur bike at carpark dun move save the most $$ ba

[ulysses_sc]

Originally posted by Fufu26@Oct 2 2006, 05:36 PM

lol.. need to count until like that.. park ur bike at carpark dun move save the most $$ ba

I think nE0 is trying to point out the futility of counting petrol savings by travelling all the way to Malaysia, as it adds up to a zero sum game.

 

People tend to look only at absolute figures, and rarely look into all the other hidden (but real) costs.

[Guest nE0]

Thanks ulysses_sc..

 

Yes, running costs of a bike, a regularly properly serviced one that is, is much higher than it seems, especially for bigger bikes.

 

But thats cost per mileage. A bike sitting there costs money too.

 

For example, for a fairly new litre bike,

 

Insurance - $1000/year, or $2.739 per day

Road Tax - $320/year, or $0.876 per day

Parking - $15/month, or $0.50 per day

 

So thats erm, $4.12 per day, sitting there doing nothing.

[LastDance]

just enjoy your ride

[feng125]

Originally posted by nE0@Oct 3 2006, 11:26 PM

Thanks ulysses_sc..

 

Yes, running costs of a bike, a regularly properly serviced one that is, is much higher than it seems, especially for bigger bikes.

 

But thats cost per mileage. A bike sitting there costs money too.

 

For example, for a fairly new litre bike,

 

Insurance - $1000/year, or $2.739 per day

Road Tax - $320/year, or $0.876 per day

Parking - $15/month, or $0.50 per day

 

So thats erm, $4.12 per day, sitting there doing nothing.

actually i DID take the tires and engine oil into consideration before. i even took time calculations into effect by taking my monthly wages divided into hourly proportions.

 

 

unfortunately those apply only to me, bcos i myself know how long i use my tires and how often i change engine oil. everyone else has their own parameters. thus its rather pointless to add that into a general calculation meant for the masses.

 

 

as for the futility of the calculation presented; i should state that this file was done to enlighten the riders who frenquently do petrol-runs into GP esso, thinking that they are saving a large amount every month, when in fact they are not. Some have shown that they are losing money instead since they travel from Bedok to GP Esso on a 1200cc petrol guzzler.

 

 

so our aims are the same: we want to pass the message that we are not benefitting as much as we think we are by going to 2nd link for petrol.

[okl]

i didnt know that we werent benefitting as much as pumping at m'sia.

 

i havent pumped a single time in m'sia though, i just dont wanna waste time to and fro thats all.

[ramen71]

agree with quizesilver,dun really so details on saving petrol,

as long gov dun block bikers fr top up in jb can ready,always waiting 4 my bike petrol

tank to turn reserve and go jb to top up and enjoy the riding with unlimited

speed..he he he.. can be done only at 2nd link..1st link cannot speed a lot vehicle and

everytime face traffic jamm..hate 1st link..