tracking ROE

7 replies [Last post]
CJATE's picture
Offline
Joined: 01/25/2012

so, i just got a car, have not put a kit in it yet. Have my filter built, but not 100% put together yet. start collecting oil Monday.

I want to start tracking my ROE,

anyone have a spread sheet or ideas? I can't decided if I want to keep track my miles on WVO and subtract the going rate of diesel from investment, or just track dollars spent at the pump? In my mind this will reflect savings as i am ~430 miles a tank of Dino diesel, and on WVO this might stretch to ~1000 a tank of Dino diesel.

for my use, I'm comparing My ROE with this car on WVO vs the truck I've quite commuting in; but I want to track my mileage between now and when I have my kit.  truck gets 20, car gets 30, so I saved $30 already on my first tank of fuel... that's no mortgage payment, but it's a start.

not sure I've been clear at all. but what all are you doing to keep up with your ROE?

__________________

96 Benz
Cold Up Flow filter
04 Duramax, 525Hp, not converting.

slatemd's picture
Offline
Joined: 11/26/2007

 
CJATE:
 
I use a Lotus spreadsheet on my vehicle with the following page setups:
 
Fuel consumption page: Date / Money saved using WVO (mpg X’s current price of diesel) / what the reason for the trip was / and a 35% increase column.  This is to show me both pre and post tax savings on WVO usage.  In other words;  I need to earn $155 that gets taxed @ 35% in order to clear $100 in order to buy $100 worth of diesel at the pump.  This becomes a very large number as time and WVO usage marches on.
 
Work done page:  Date / What was done / Cost of repairs to the vehicle.
 
WVO page:  Date / What was purchased or sold relating to WVO equipment (filters, hoses, pumps, storage vessels, etc.)
 
Running tab page:  Purchase price of the vehicle plus work done on the vehicle plus WVO expenditures less fuel savings to date.  This page automatically updates the finances as data entries get plugged in the various other spreadsheets.
 
This page gives me the number I would need to sell the truck for in order to break even (if I were to sell the vehicle.)
 
 
Several notes:  As I see it, my WVO usage is subsidizing the repairs / maintenance on my truck.
 
Education is not cheap:  If I were to sell my truck for less than my “buy back” number, I still consider myself to be ahead of the game only due to the fact that I gained a considerable amount of knowledge as it relates to WVO.
 
The discipline is to ALWAYS input data in my spreadsheets no matter how trivial the financial entry may be.  This also gives me an accurate timeline as to what was done to the vehicle / when it was done to the vehicle /  as well as sort of a diary I can look back on to see where my travels led me at that juncture in time.
 
I hope this helps you.
 
Good luck.

__________________

The future of America is easy to perceive;  Just visit Mexico or South Africa!

Nick Scheuer's picture
Offline
Joined: 12/24/2010

I don't get anal about it.  I keep track of how manny gallons of WVO I burn in the truck annually.  The cost for WVO is ZERO.  The cost of an quivalent amount of Diesel fuel is easily calculated (I can rmember variations throughout the year).  Subtract ZERO from that, and the result is what I saved not burning Diesel fuel.  Then I subtract anything spent for filter equip/supplies, which last year was ZERO, and it will probably be the same this year, because I bought a s--tload of filters two years ago and my pump system won't be wearing out anytime soon.
The cost of the truck is a wash, as I'd need an equivalent-size gasoline-powered truck to tow my boat, anyway.  The bonus is that my Dodge Diesel has a lot more balls for towing over the Alleghenies that my Gasoline V-8 Silverado had.
The cost of the Greaecar Kit was covered a couple of years ago in savings from not buying Diesel fuel.
I'm in my fourth year of WVO.

__________________

Nick

slatemd's picture
Offline
Joined: 11/26/2007

Oh sure, burst my bubble why dont-cha.........
 
Hi Nick!  I hope all is welll with you.
 
Ciao.
 
Slate

__________________

The future of America is easy to perceive;  Just visit Mexico or South Africa!

danalinscott's picture
Offline
Joined: 12/13/2004

 

"so, i just got a car, have not put a kit in it yet. Have my filter built, but not 100% put together yet. start collecting oil Monday.

 

I want to start tracking my ROE,

 

anyone have a spread sheet or ideas? I can't decided if I want to keep track my miles on WVO and subtract the going rate of diesel from investment, or just track dollars spent at the pump? In my mind this will reflect savings as i am ~430 miles a tank of Dino diesel, and on WVO this might stretch to ~1000 a tank of Dino diesel.

 

for my use, I'm comparing My ROE with this car on WVO vs the truck I've quite commuting in; but I want to track my mileage between now and when I have my kit.  truck gets 20, car gets 30, so I saved $30 already on my first tank of fuel... that's no mortgage payment, but it's a start.

 

not sure I've been clear at all. but what all are you doing to keep up with your ROE?"

 

I am pretty sure you mean ROI (Return On Investment).

 

To be accurate you need to compare the cost of operating the car you now have on wvo compared to wat it would cost if you chose to just run it on diesel fuel. Your choice to buy a 30 mpg car to communte in (compared to your 20mpg truck) is a seperate issue unless you want to calculate the cost of that car in as well. That will make the calculation quite a bit more complex so I suggest considering the decision to buy a higher MPG vehicle a seperate issue.

 

 Hopefully you have kept track of the MPG the car you are converting gets on diesel fuel.  You will need this if you want to ESTIMATE how many miles it will take to break even on your investment so far. If you know the actual MPG of this vehcle on diesel it will make estimating ROI much simpler and more accurate.  You need this to estimate what it costs to operate your car on diesel fuel in order to determine how long it will theoretically)  take to "break even" by substituting wvo for diesel fuel. You will also need this to determine when you catually reach that point.

 

Do you know what your actual avg. MPG is?

Nick Scheuer's picture
Offline
Joined: 12/24/2010

All is very well here, slatemd.  Are you still planning to trade trucks?  The diamond-plate trim on your Dodge is priceless!
 
We did trade boats here.  The sailboat has been replaced by an old Sweedish Diesel Motor Cruiser which has a GVW (boat + trailer) 1500 lbs greater than the sailboat.  No worries, the Dodge up for it.

__________________

Nick

Phil's picture
Offline
Joined: 05/28/2004

And does that Sweede run on WVO?

slatemd's picture
Offline
Joined: 11/26/2007

Hey Nick:
 
I had a 2003 F-250 Lariate Super Duty Crew Cab shipped in from Texas several months ago.  That 7.3 is a nice strong motor boy!
 
I am getting the things I need to convert it with Miller if I ever get the time. 
 
The Dodge is still being used on road trips and I have been burning WVO with great sucess for the past year.
 
I sent you some info about your ingection pump on your other post.
 
Ciao.
 
 
Hi Phil......

__________________

The future of America is easy to perceive;  Just visit Mexico or South Africa!