Fordmods Logo

Petrol-LPG conversion calculator MkII **UPDATED** now MKIII 

 

Page 1 of 2 [ 25 posts ] Go to page 1, 2  Next

 
 Post subject: Petrol-LPG conversion calculator MkII **UPDATED** now MKIII
Posted: Mon Jul 04, 2005 11:54 am 
Getting Side Ways
Offline
User avatar

Age: 45

Posts: 829

Joined: 5th Nov 2004

Ride: 2004 Mazda Tribute

OK!
Here is an updated utility written for Excel that will calculate how long it will take to pay off an LPG installation, and the cost saving associated with it.

The fields that need filling in are blank, so add in whatever is appropriate for your area, (prices, and KM travelled) and it will calc the rest!

Enjoy!

****UPDATED 5-7-05. See below

 

 

Attachments:
petrol-V-gas-calculator.xls [17.5 KiB]
Downloaded 341 times

Last edited by 96ghia on Tue Jul 05, 2005 6:33 pm, edited 1 time in total.

Top
 Profile  
 
 
Posted: Mon Jul 04, 2005 12:59 pm 
Getting Side Ways
Offline
User avatar

Age: 51

Posts: 1751

Joined: 5th Nov 2004

Gallery: 1 images

Ride: BA ute, FG XR6T

Location: Quakers Hill
NSW, Australia

Thank you

 

_________________

Image

Top
 Profile  
 
 
Posted: Tue Jul 05, 2005 6:32 pm 
Getting Side Ways
Offline
User avatar

Age: 45

Posts: 829

Joined: 5th Nov 2004

Ride: 2004 Mazda Tribute

Updated. Now shows how many Km you need to drive until the conversion pays off. Calculated from price of fuels and usage rates

 

 

Attachments:
petrol-V-gas-calculator.xls [19 KiB]
Downloaded 351 times
Top
 Profile  
 
 
Posted: Sun Jul 10, 2005 10:36 am 
Getting Side Ways
Offline

Posts: 625

Joined: 6th Nov 2004

Ride: R32 GTR

Location: Brackistan
VIC, Australia

Does the "Savings per litre" need to be in yellow as its not a field that would intentionally be modified...?

Or am I missing something?

Otherwise, great work!

Now it needs a bit more maths, with a variable interest rate of paying off a home loan at 7.23%pa, how much will be lost to compound interest by spending the extra $2000-ish to install LPG and how long will it take to break even?? :) :) :)

j/k!
Top
 Profile  
 
 
Posted: Sun Jul 10, 2005 12:45 pm 
Getting Side Ways
Offline
User avatar

Age: 45

Posts: 829

Joined: 5th Nov 2004

Ride: 2004 Mazda Tribute

Bozz wrote:
Does the "Savings per litre" need to be in yellow as its not a field that would intentionally be modified...?

No. Saving per litre is worked out when you put in the cost of the LPG and the cost of the petrol. The difference is what you save per litre.
Bozz wrote:
Now it needs a bit more maths, with a variable interest rate of paying off a home loan at 7.23%pa, how much will be lost to compound interest by spending the extra $2000-ish to install LPG and how long will it take to break even?? :) :) :)
j/k!

Now thats one I'd like to knopw myself!
Next version ;-)
Top
 Profile  
 
 
Posted: Tue Sep 06, 2005 11:26 am 
Technical Contributor
Offline

Age: 37

Posts: 6047

Joined: 12th Nov 2004

Ride: Ford Ef Futura

Location: Perth
WA, Australia

Very nice spreadsheet
Top
 Profile  
 
 
Posted: Tue Sep 06, 2005 1:12 pm 
Stock as a Rock
Offline
User avatar

Age: 59

Posts: 156

Joined: 21st Jul 2005

Gallery: 12 images

Ride: AU Falcon

Location: Adelaide
SA, Australia

very good workon the spreadsheet, at least now I have an easy way to convince the missus to change the other car to gas

 

_________________

98 AU Falcon Futura I6 ABS & Cruise stock (The Wifes car

99 AU Falcon Duel Fuel - Xcab

Top
 Profile  
 
 
Posted: Tue Sep 06, 2005 1:17 pm 
Getting Side Ways
Offline
User avatar

Age: 45

Posts: 829

Joined: 5th Nov 2004

Ride: 2004 Mazda Tribute

Talk about Thread mining!
I'd almost forgotten all about this!

I've not changed the spreadsheet since, but its pretty well sorted out now!
Top
 Profile  
 
 
Posted: Tue Sep 06, 2005 1:27 pm 
Stock as a Rock
Offline
User avatar

Age: 59

Posts: 156

Joined: 21st Jul 2005

Gallery: 12 images

Ride: AU Falcon

Location: Adelaide
SA, Australia

:)

 

_________________

98 AU Falcon Futura I6 ABS & Cruise stock (The Wifes car

99 AU Falcon Duel Fuel - Xcab

Top
 Profile  
 
 
Posted: Tue Sep 06, 2005 1:33 pm 
Technical Contributor
Offline
User avatar

Age: 39

Posts: 5855

Joined: 5th Nov 2004

Gallery: 8 images

Ride: '95 EF's

Location: Leederville
WA, Australia

jesus those petrol figures are depressing :? LPG conversion looks a pretty healthy option!

 

_________________

R.I.P. Scotty

Top
 Profile  
 
 
Posted: Tue Sep 06, 2005 2:08 pm 
Getting Side Ways
Offline

Age: 43

Posts: 2215

Joined: 5th Nov 2004

Gallery: 17 images

Ride: Oettinger Golf GTI

Location: Sydney
NSW, Australia

Think will be doing mels shortly too! most definately worth it as it'll cost under $1k to install!
Top
 Profile  
 
 
Posted: Tue Sep 06, 2005 2:13 pm 
Getting Side Ways
Offline
User avatar

Age: 45

Posts: 829

Joined: 5th Nov 2004

Ride: 2004 Mazda Tribute

How did you manage it for that price??
Top
 Profile  
 
 
Posted: Tue Sep 06, 2005 2:18 pm 
Getting Side Ways
Offline

Age: 43

Posts: 2215

Joined: 5th Nov 2004

Gallery: 17 images

Ride: Oettinger Golf GTI

Location: Sydney
NSW, Australia

96ghia wrote:
How did you manage it for that price??


lol, few second hand parts and people u know! labour for install is the most! not too hard to do yourself!
Top
 Profile  
 
 
Posted: Tue Sep 06, 2005 2:20 pm 
Getting Side Ways
Offline
User avatar

Age: 45

Posts: 829

Joined: 5th Nov 2004

Ride: 2004 Mazda Tribute

Well, $1000 as opposed to $2500 plus is makes the equations work out much nicer!
Top
 Profile  
 
 
Posted: Tue Sep 06, 2005 2:23 pm 
Getting Side Ways
Offline

Age: 43

Posts: 2215

Joined: 5th Nov 2004

Gallery: 17 images

Ride: Oettinger Golf GTI

Location: Sydney
NSW, Australia

yeah, but for $2500 thts brand new parts and high quality bits and tuning and so on .. its a bit of work involved and the mixer/converter new + tank is most of the cost.
Top
 Profile  
 
Display posts from previous:
Sort by  
 Page 1 of 2  [ 25 posts ]  Go to page 1, 2  Next

Who is online

Users browsing this forum: No registered users and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

 

 

It is currently Sat Apr 27, 2024 11:03 am All times are UTC + 11 hours

 

 

(c)2014 Total Web Solutions Australia - Australian Web Hosting and Domain Names