Spreadsheet: 0f9972c4-f758-4ac5-94d2-b660e54b7a05
Sheet: MainEntry&Data

 | Note:  text box appearance may vary with different Windows and Excel versions.
 |  |  | Please read cell comments
 |  |  |  |  |  |  |  |  | Heat loss, J | 0
 |  | Natural Gas/Fuel Properties |  |  |  |  |  |  | Oxidant Properties
 |  |  | Species | [NAME] |  |  |  |  | % O2 in Oxidant | 0.21
 |  | Methane | CH4 | 0.964 |  |  |  |  | Upper limit on % excess oxidant | 1
 |  | [NAME] | C2H4 | 0.0015 |  |  |  |  | Oxidant temperature, °C | 25
 |  | [NAME] | [NAME] | 0.003 |  |  |  |  | Stoichiometric amount of oxidant
 |  | Propane | C3H8 | 0.0025
 |  | Butanes & higher | C4H10 + | 0.001 |  |  |  |  | Fuel temperature, °C | 25
 |  | Hydrogen | H2 | 0.002 |  |  |  | Element Balance of Fuel
 |  | Carbon monoxide | CO | 0.0015 |  |  | Element | moles | mass |  |  | Figure 1.  Relationship between the AFT and the % excess oxidant used for combustion.
 |  | Carbon dioxide | CO2 | 0.002 |  |  | C |  |  |  |  | Chart and table will reconfigure when any blue-cell entry value is changed.
 |  | Water vapor | H2O | 0 |  |  | H |  |  |  |  | Excel's Trendline tool can be used to give a quadratic equation fit to the results.  For x, use %/100.
 |  | Nitrogen (by diff.) | N2 |  |  |  | O
 |  |  |  |  |  |  | N |  |  |  |  |  |  |  |  | Summary of Results
 |  | Graphite | C | 0 |  |  | Sum
 |  |  |  |  |  |  |  |  |  |  |  | AFT, °C
 |  |  |  | Table I. Molar DH°form at 25 °C |  |  |  | Table II. Molar DH°reax at 25 °C
 |  |  |  | J/g-mol |  |  | Reaction to form H2O(g) |  |  | J/g-mol
 |  |  | CH4 | -74810 |  | 2O2 + CH4 → CO2 + 2H2O(g)
 |  |  | C2H4 | 52467 |  | 3O2 + C2H4 → 2CO2 + 2H2O(g)
 |  |  | [NAME] | -84684 |  | 3½O2 + C2H6 → 2CO2 + 3H2O(g)
 |  | NG reactant species | C3H8 | -103847 |  | 5O2 + C3H8 → 3CO2 + 4H2O(g)
 |  |  | C4H10 | -126148 |  | 6½O2 + C4H10 → 4CO2 + 5H2O(g)
 |  |  | H2 | 0 |  | [NAME] → H2O(g)
 |  |  | CO | -110529 |  | [NAME]
 |  | Combustion | CO2 | -393509 |  | C + O2 → CO2 |  |  |  | -393510
 |  | products | H2O(g) | -241814
 |  |  | H2O(liq) | -285830 |  | H2O(g) → H2O(liq) |  |  |  | -44020
 |  | Table III. Heat Content Above 25 °C, J/g-mol
 |  | T, °C | O2, (g) | N2, (g) | H2O, (g) | CO2, (g)
 |  | 1000 | 32370.92667079878 | 30594.83504495163 | 37719.48671621815 | 48623.53225874677
 |  | 1100 | 35977.31974243365 | 34009.21756581498 | 42222.37606086649 | 54346.85743475276
 |  | 1200 | 39613.78834423995 | 37459.92195635979 | 46831.41619766533 | 60135.74756299771
 |  | 1300 | 43277.72287355394 | 40943.62497996388 | 51541.45768615618 | 65981.66139481943
 |  | 1400 | 46967.10297591461 | 44457.2422571331 | 56347.13704793766 | 71877.42900252261
 |  | 1500 | 50680.39218517525 | 47997.8924751279 | 61242.92271254577 | 77816.98996993096
 |  | 1600 | 54416.45474955128 | 51562.86705915795 | 66223.14898647158 | 83795.19169515236
 |  | 1700 | 58174.4894558684 | 55149.60476046221 | 71282.04165838279 | 89807.63199091275
 |  | 1800 | 61953.97654217341 | 58755.67045092459 | 76413.73763096696 | 95850.53478340697
 |  | 2000 | 69576.38635117782 | 66016.57264010054 | 86871.73111534076 | 108015.1778589254
 |  | Data from FREED database program.
 |  | Excel's Trendline tool used to fit data to quadratic equation.
 |  | Chart equations valid between 900° - 2100 °C.