Parts Catalog Accessories Catalog How To Articles Tech Forums
Call Pelican Parts at 888-280-7799
Shopping Cart Cart | Project List | Order Status | Help




Go Back   PeachParts Mercedes-Benz Forum > Mercedes-Benz Tech Information and Support > Diesel Discussion > Alternative Fuels

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-27-2004, 01:35 AM
phidauex's Avatar
BioDiesel Hopeful
 
Join Date: Oct 2004
Location: St. Louis, MO
Posts: 806
Post Biodiesel-Friendly Excel spreadsheet

Our recent discussion of geeky diesel-love things we do got me working on my Excel spreadsheet some more. I sent copies out to a few people, but then I got thinking about it, and as I ease into biodiesel use on this vehicle, I wanted a better way to track what my car is burning. So I continued to tweak on the spreadsheet, and it now has the following features:

Basic fuel mileage tracking, including lifetime average, average of last three fillups, and last mileage, miles per day and gallons per day calculations, lifetime cost per gallon, etc. Along with a printable report page and everything.

And for the biodiesel blenders, thats where I really played around. You enter how many gallons of petrol you added and how many gallons of biofuel (could be biodiesel or WVO or whatever), and it calculates the blend you just added, the overall blend in the tank at the moment, your lifetime blend level, and (my favorite) how much biofuel you'll need to add at your next fillup to maintain your desired blend level.

What with winter coming on and people experimenting with different blends, its nice to know just how much biodiesel to add to hold the blend of your choice. Unless you are a fancy-pants with your own big tank to blend in, you need to 'blend on the fly' by dumping in some biodiesel, then topping up with petrol. This helps you figure out what the hell is in your tank.

And really, it makes you feel like a big ole geek, which is good fun. Just don't let your mate see it...

Its easy to use, just fill in the green spaces with your information, and modify the model of your car and tank capacity and stuff. There are a few sample entries in there just to show you the idea.

Also, please suggest more features, I'm enjoying this whole spreadsheet business, so if anyone has something they'd want it to calculate or help them determine, speak up and I'll see if I can do it.

The spreadsheet: http://www.flexistentialist.org/projects/gasmileage.xls

peace,
Sam
__________________
"That f***in' biodiesel is makin' me hungry."

1982 300TD Astral Silver w/ 250k (BIO BNZ)
2001 Aprilia SR50 Corsa Red w/ 5.5k (>100 MPG)

Reply With Quote
  #2  
Old 11-28-2004, 06:33 PM
rg2098's Avatar
Detailing Moderator
 
Join Date: Jun 2004
Location: Rochester Hills, MI
Posts: 2,415
When I change the tank capacity section to the sedans, all of the bio calcs get corrupted and stay that way when I put it back to the value you entered. Whats going on here?
__________________
Adam Lumsden
(83) 300D
Vice-President of the MBCA International Stars Section
Reply With Quote
  #3  
Old 11-28-2004, 10:24 PM
phidauex's Avatar
BioDiesel Hopeful
 
Join Date: Oct 2004
Location: St. Louis, MO
Posts: 806
Oo... I'm not sure what that problem is, and I can't seem to reproduce it on my system. Out of curiosity, what version of Excel are you using?

peace,
sam
__________________
"That f***in' biodiesel is makin' me hungry."

1982 300TD Astral Silver w/ 250k (BIO BNZ)
2001 Aprilia SR50 Corsa Red w/ 5.5k (>100 MPG)

Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT -4. The time now is 05:12 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0
Copyright 2018 Pelican Parts, LLC - Posts may be archived for display on the Peach Parts or Pelican Parts Website -    DMCA Registered Agent Contact Page