Spreadsheet: 0f9972c4-f758-4ac5-94d2-b660e54b7a05
Sheet: Calcs

 | Please read cell comments
 |  |  |  |  |  |  |  |  |  |  |  |  | Material Balance Calculations
 | Legend
 |  | Values Entered on MainEntry |  |  |  |  |  |  |  |  | Vol. % O2 in oxidant gas
 |  |  |  |  | Natural Gas/Fuel Properties |  |  |  |  |  | % XS oxidant | 0
 |  | Species | Cp | Mol. mass | Vol % | Mass, g | Mass % | DH°comb
 | Methane | CH4 | 36 | 16.043 |  |  |  |  |  |  | Combustion products |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vol. % O2 in oxidant gas
 | [NAME] | C2H4 | 43 | 28.054 |  |  |  |  |  |  | Stoichiometric oxidant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired %O2 in comb. flame | 0 |  |  |  | 0.05
 | [NAME] | [NAME] | 54 | 30.07 |  |  |  |  |  |  | Stoichiometric oxidant inerts
 | Propane | C3H8 | 75 | 44.097 |  |  |  |  |  |  | Oxidant gas required |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Combustion products
 | Butanes & higher | C4H10 + | 103 | 58.124 |  |  |  |  |  |  | Excess oxidant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stoichiometric oxidant
 | Hydrogen | H2 | 29 | 2.016 |  |  |  |  |  |  | %O2 in offgas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stoichiometric oxidant inerts
 | Carbon monoxide | CO | 30 | 28.011 |  |  |  |  |  |  | Offgas amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Excess oxidant
 | Carbon dioxide | CO2 | 38 | 44.011 |  |  |  | 0 |  |  | Dry stack gas amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % stoichiometric oxidant gas
 | Water vapor | H2O | 33.6 | 18.016 |  |  |  | 0 |  |  | %O2 in dry offgas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % excess oxidant gas
 | Nitrogen (by diff.) | N2 | 29.1 | 28.014 |  |  |  | 0 |  |  | Oxidant mass |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Required oxidant
 | Graphite | C | 10 | 12.011 |  |  |  |  |  |  | Oxidant/Fuel mass ratio |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Combustion water
 |  | O2 | 29.4 | 32 | --- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stack gas volume
 |  |  |  |  |  |  | DH°comb of Fuel, kJ/g-mol |  |  |  | Offgas H2O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dry stack gas volume
 |  |  | Molecular mass of NG |  |  |  |  |  |  | Amount, | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %O2 in dry stack gas
 |  |  |  |  |  |  |  |  |  | g-mol | Offgas N2
 |  |  |  |  |  | moles | mass |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oxidant mass
 |  |  |  |  | CO2 produced by combustion |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ox/NG mass ratio
 |  |  |  |  | H2O produced by combustion |  |  |  |  |  | Offgas H2O
 |  |  |  |  | Stoich. O2 required for combustion |  |  |  |  | Composition, | [NAME]
 |  |  |  |  |  |  |  |  |  | vol. % | Offgas N2
 |  |  |  |  | Table IV.  Heat content eq'n. parameters, J/g-mol =  A + BT + CT2 |  |  |  |  |  | [NAME]
 |  | N2, 900 - 2100°C |  |  |  | O2, 900 - 2100°C
 |  | A | B | C |  | A | B | C
 |  | -2420 | 31.77 | 0.001229 |  | -2510 | 33.7 | 0.001173 |  |  | Heat Balance Calculations
 |  | H2O(g), 900 - 2100°C |  |  |  | CO2, 900 - 2100°C |  |  |  |  | % XS oxidant
 |  | A | B | C |  | A | B | C |  |  | A
 |  | -3120 | 36.61 | 0.004204 |  | -6850 | 53.43 | 0.002006 |  | Offgas H2O | B
 |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  |  | [NAME] | B
 |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  | Heat loss, J |  |  |  | A
 |  |  |  |  |  |  | Oxidant temperature, °C |  |  | Offgas N2 | B
 |  |  |  |  |  |  | Fuel temperature, °C |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  |  | [NAME] | B
 |  |  |  |  |  |  |  |  |  |  | C
 |  | Step 1.  Bring reactants to 25°C. |  |  |  |  |  |  |  |  | c
 |  | Step 2.  Burn fuel at 25°C.  Cell I20 |  |  |  |  |  |  |  | Values for Quadratic Formula | b
 |  | Step 3.  Heat products to AFT. |  |  |  |  |  |  |  |  | a
 |  | Step 4.  Sum of all heats = 0.  M47:S47 |  |  |  |  |  |  |  | HT-H25 for oxidant & fuel
 |  | S(HT-H25 of reactants + HT-H25 of products + Hloss + DH°comb) = 0
 |  | Step 5.  Calculate AFT using quadratic formula (M52:S52). |  |  |  |  |  |  |  |  | AFT