BTU Cost Formula

Boiler_Hog

I have misplaced a formula that I once had that would allow you to calculate the cost per BTU for equipment.  I can't remember all the variables but I believe Unit size, type of fuel, and equipment efficiency were all taken into consideration.  This formula was a great tool when a customer was considering chaging fuels as well as upgrading equipment. It allows you to compair oranges to apples.  If anyone knows the formula I am looking for I would greatly appreciate the information.  Thank You.

meplumber

Is this what you are looking for?

Is this the info you are looking for?



http://pro.usboiler.burnham.com/new-contractors/toolbox.php

Boiler_Hog

Thanks, but no.

These are btu per fuel unit comparisons which are a part of the formula I'm looking for.  The formula I'm looking for takes into account the fuel's btu content, efficiency of the equipment and the current cost of the fuel and I believe the btu output of the equipment. 

carl_nh

Excel Sheet

I used this one from PSU to do my calculations.

carl_nh

Calc Again

I thought I made an attachment but not so..trying again with this link - see the bottom of the page for the spreadsheet

http://energy.cas.psu.edu/costcomparator.html 

STEVEusaPA

If that's not it....

I know i have something in my office, will post it tomorrow.

EDIT EDIT...

I found 2 sources.  The Manual J has a whole chapter on it.  Siggy's HYDRONIC DESIGN STUDIO, after you put in your numbers, will spit out estimated annual cost for each fuel type.

Boiler_Hog

Getting warmer

All the variables are taken into consideration but what button do you push after you enter the fuel cost?  I'm not that familliar with spread sheets.  Is the spread sheet supposed to conduct the equation for you?  I don't see a formula anywhere.  Do I mutiply or divide?  Help?

van_8

BTU cost formual

here is a chart we use