Gas - Diesel Comparison - Diesel Forum

Crodad · 11-06-2007, 10:27 AM

This is a spreedsheet I put together to see the difference in the fuel expense between the V-10 and the 6.4. Enter the numbers in the yellow boxes. Enter the gas and diesel prices in your area and then enter the miles per gallon you think the V-10 will make and the miles per gallon you think the 6.4 will make. From what I have gathered from this board I think the V-10 avg. MPG would be 11 unloaded and 16 for the 6.4 unloaded. If you dissagree with me enter what you think is correct.

http://spreadsheets.google.com/ccc?k...hl=en_US&pli=1

Texrob1 · 11-06-2007, 10:38 AM

Sounds cool,but the link is not working,not for me anyway..

doczenith1 · 11-06-2007, 03:00 PM

Crodad, with your spreadsheet open you need to go to the "Share" tab for the spreadsheet and under "Advanced Options" click the box by "Anyone can view this document at:". There will be a link there that you can paste to this thread.

Al

Crodad · 11-06-2007, 07:38 PM

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: doczenith1</div><div class="ubbcode-body">Crodad, with your spreadsheet open you need to go to the "Share" tab for the spreadsheet and under "Advanced Options" click the box by "Anyone can view this document at:". There will be a link there that you can paste to this thread.

Al</div></div>

Thanks Doc. I think I have it now. Give it a try.

Crodad · 11-07-2007, 07:38 AM

http://spreadsheets.google.com/ccc?k...y_BRQ&hl=en_US

Try this link

loft306 · 11-07-2007, 10:24 AM

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: Crodad</div><div class="ubbcode-body">http://spreadsheets.google.com/ccc?k...y_BRQ&hl=en_US

Try this link </div></div>Still nogo [img]/forums/images/%%GRAEMLIN_URL%%/frown.gif[/img]

Crodad · 11-07-2007, 10:57 AM

If any wants to see it email at mbienve@bellsouth.net and I will send you the excel file.

doczenith1 · 11-07-2007, 02:14 PM

Crodad, my instructions were partially correct. You actually need to "Publish" the spreadsheet so those without Google accounts can view it.

loft306 · 11-07-2007, 04:18 PM

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: doczenith1</div><div class="ubbcode-body">Crodad, my instructions were partially correct. You actually need to "Publish" the spreadsheet so those without Google accounts can view it. </div></div>yeah logged into google it dose work
[img]/forums/images/%%GRAEMLIN_URL%%/smile.gif[/img]

brada · 11-07-2007, 05:27 PM

Where i live, "oregon", Diesel is 60 cents more than gas. Also, I believe we pay more for the diesel engine up front. Should'nt we consider that in the pay back?

bnmccoy · 11-07-2007, 10:51 PM

Crodad, I sent you an Excel file for Ford dealers from a few years ago that creates graph showing how many miles are required to break even with gas vs. diesel. You enter engine upcharge costs and costs of oil changes and frequency too.

Bob

Crodad · 11-08-2007, 09:39 AM

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: Bob_McCoy</div><div class="ubbcode-body">Crodad, I sent you an Excel file for Ford dealers from a few years ago that creates graph showing how many miles are required to break even with gas vs. diesel. You enter engine upcharge costs and costs of oil changes and frequency too.

Bob</div></div>

Thanks Bob,

I got it. Much better than mine since it takes into account the difference in price of the engine and the oil changes in addition to the fuel.

NSF250 · 11-08-2007, 09:51 AM

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: Crodad</div><div class="ubbcode-body"><div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: Bob_McCoy</div><div class="ubbcode-body">Crodad, I sent you an Excel file for Ford dealers from a few years ago that creates graph showing how many miles are required to break even with gas vs. diesel. You enter engine upcharge costs and costs of oil changes and frequency too.

Bob</div></div>

Thanks Bob,

I got it. Much better than mine since it takes into account the difference in price of the engine and the oil changes in addition to the fuel. </div></div>

So, whats the verdict? How many miles for payback do you come up with? Last time I did the calculations, it came out to well over 100,000 miles. Don't forget resale value though. You won't make up the entire cost of the diesel option, but you should be able to recover a good chunk of it. These calculations make my head hurt because there are two very big wild cards that are hard to pin down. Fuel economy and diesel fuel vs. gasoline prices.

Crodad · 11-08-2007, 09:59 AM

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: NSF250</div><div class="ubbcode-body"><div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: Crodad</div><div class="ubbcode-body"><div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: Bob_McCoy</div><div class="ubbcode-body">Crodad, I sent you an Excel file for Ford dealers from a few years ago that creates graph showing how many miles are required to break even with gas vs. diesel. You enter engine upcharge costs and costs of oil changes and frequency too.

Bob</div></div>

Thanks Bob,

I got it. Much better than mine since it takes into account the difference in price of the engine and the oil changes in addition to the fuel. </div></div>

So, whats the verdict? How many miles for payback do you come up with? Last time I did the calculations, it came out to well over 100,000 miles. Don't forget resale value though. You won't make up the entire cost of the diesel option, but you should be able to recover a good chunk of it. These calculations make my head hurt because there are two very big wild cards that are hard to pin down. Fuel economy and diesel fuel vs. gasoline prices. </div></div>

Using the file That I got from Bob, It comes up to about 65,000 miles to break even. Using 17 mpg for diesel and 10 for gas.

Solo2puller · 11-08-2007, 01:25 PM

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: Crodad</div><div class="ubbcode-body">Using the file That I got from Bob, It comes up to about 65,000 miles to break even. Using 17 mpg for diesel and 10 for gas. </div></div>

When I bought my truck I went through this calculation ad nauseum. No matter what I did it showed a payback in excess of 180K miles, and that was when the prices were a lot closer together. Fluctuations in price made a bigger difference then because they were a higher percentage of the fuel cost. Today an increase (either fuel) makes less of an impact - a $0.10 increase on $2.79 is a smaller percentage than a $0.10 increase on $1.59.

I'm getting a bit better than 12 mpg avg in 60K miles of V10 ownership. I've logged every drop of fuel put into this truck since it was new, so I've got a great source of reliable mpg data. At that rate and the reported 14-16 of the 6.4's it will never payback at current fuel prices. Use 12 instead of 10 and you'll see a very different breakeven point.

I don't know if the new V10's are doing as well as mine with fuel consumption. I think 17 avg for a 6.4 is a bit of a stretch. I'd believe 15, maybe could be talked into 16...

The days of justifying a diesel with fuel savings are over until the prices of the engines come down or the mpg's go up. Raw torque, machismo or too much money in your wallet can justify it, but cost savings won't cut it.

Resale is a slippery slope, too. Anyone want to gamble and buy a used 6.0 ? Not me. There's so many factors in the resale calculation that it's really tough to come up with anything meaningful. If the 6.4's stay as reliable as they've been so far it may be an easier call, but the biggest factors are condition and configuration of the truck.