Spreadsheet: 0e1e4345-1c7d-47f1-bc0d-cbc23382557b
Sheet: Calcs

 | Please read cell comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Burner Calculations |  |  |  |  |  | Cooler Calculations |  |  |  | [NAME] Preparation
 | Legend |  |  |  |  |  |  |  | Material Balance/Equilib Calculations |  |  |  |  |  |  | Heat Balance Calculations |  |  |  |  | Heat Balance Calculations |  |  |  | Material Balance/Equilib Calculations
 |  | Values Entered on MainEntry
 |  |  |  |  | Natural Gas/Fuel Properties |  |  |  |  | Burner temp, °C |  |  | Amount of H2: |  |  |  | NatGas temp |  |  |  | Dew point temp, °C |  |  |  | [NAME] furnace temp, °C
 |  | Species | Cp | Mol. mass | Vol % | Mass, g | Mass % |  |  | Vol. % O2 in oxidant gas |  |  | Amount of H2O: |  |  |  | Oxidant temp |  |  |  | pH2O at dpt |  |  |  | Amount of H2: |  |  | Amount of H2:
 | Methane | CH4 | 36 | 16.043 |  |  |  |  |  | Stoichiometric oxidant |  |  | Amount of CO2: |  |  |  | Bring NatGas to 25°C |  |  |  | Amount of H2O condensing |  |  |  | Amount of H2O: |  |  | Amount of H2O:
 | [NAME] | C2H4 | 43 | 28.054 |  |  |  |  |  | % stoichiometric oxidant |  |  | Amount of CO: |  |  |  | Bring oxidant to 25°C |  |  |  | Cool CO to dpt |  |  |  | Amount of CO2: |  |  | Amount of CO2:
 | [NAME] | [NAME] | 54 | 30.07 |  |  |  |  |  | Amount of oxidant |  |  | Amount of hot gas: |  |  |  | Formation of CO |  |  |  | Cool CO2 to dpt |  |  |  | Amount of CO: |  |  | Amount of CO:
 | Propane | C3H8 | 75 | 44.097 |  |  |  |  |  | Carbon in, C: |  |  | % H2 |  |  |  | formation of CO2 |  |  |  | Cool H2O to dpt |  |  |  | Amount of N2 |  |  | Amount of N2
 | Butanes & higher | C4H10 + | 103 | 58.124 |  |  |  |  |  | Hydrogen in, as H2: |  |  | % H2O |  |  |  | Formation of H2O |  |  |  | [NAME] to dpt |  |  |  | Amount of Ingas |  |  | Amount of Ingas
 | Hydrogen | H2 | 29 | 2.016 |  |  |  |  |  | [NAME] in, as O: |  |  | % CO2 |  |  |  | Formation of NG |  |  |  | [NAME] to dpt |  |  |  | % H2 |  |  | % H2
 | Carbon monoxide | CO | 30 | 28.011 |  |  |  |  |  | Nitrogen in, as N2: |  |  | % CO |  |  |  | Sum of Rx heat |  |  |  | DH°condensation of water vapor |  |  |  | % H2O |  |  | % H2O
 | Carbon dioxide | CO2 | 38 | 44.011 |  |  |  |  |  | Krx, WGS: |  |  | % N2 |  |  |  |  |  |  |  | Heat removed in cooler |  |  |  | % CO2 |  |  | % CO2
 | Water vapor | H2O | 33.6 | 18.016 |  |  |  |  |  | QF parameter a: |  |  | Dew point, °C |  |  |  | Heat CO |  |  |  |  |  |  |  | % CO |  |  | % CO
 | Nitrogen (by diff.) | N2 | 29.1 | 28.014 |  |  |  |  |  | QF parameter b: |  |  | [NAME] in hot gas |  |  |  | Heat CO2 |  |  |  |  |  |  |  | % N2 |  |  | % N2
 |  | O2 | 29.4 | 32 |  |  |  |  |  | QF parameter c: |  |  | log pO2 for Fe/wust. |  |  |  | Heat H2O |  |  |  |  |  |  |  | Carbon in, C:
 |  |  | Molecular mass of NG |  |  |  |  |  |  |  |  |  | Activity of C |  |  |  | Heat H2 |  |  |  |  |  |  |  | Hydrogen in, as H2: |  |  | [NAME] in exogas
 |  |  |  |  |  |  |  |  |  |  |  |  | pCH4 |  |  |  | Heat N2 |  |  |  |  |  |  |  | [NAME] in, as O: |  |  | log pO2 for Fe/wust.
 |  |  |  |  |  | moles |  |  |  |  |  |  |  |  |  |  | Sum of product heat |  |  |  |  |  |  |  | Krx, WGS: |  |  | Activity of C
 |  |  |  |  | CO2 + CO produced by combustion |  |  |  |  |  |  |  | Volume of hot gas at hot gas temp, m3 |  |  |  | Heat loss |  |  |  |  |  |  |  | QF parameter a: |  |  | pCH4
 |  |  |  |  | CO2 + CO in hot gas |  |  |  |  |  |  |  |  |  |  |  | Heat surplus/deficiency |  |  |  |  |  |  |  | QF parameter b: |  |  | %C
 |  |  |  |  | H2O + H2 produced by combustion |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QF parameter c:
 |  |  |  |  | H2O + H2 in hot gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volume of furnace gas at furnace temp, m3
 | Table I.  Molar DH°form at 25 °C |  |  |  |  |  | Table IX.  [NAME] parameters, =  A/T + B |  |  |  |  |  |  | Table X.  Heat content eq'n. parameters, J/g-mol =  A + BT + CT2
 |  |  | J/g-mol |  | pH2O, 273 - 333 K |  |  | pO2, 1100 - 1700 K |  |  | N2, 750 - 1450°C |  |  |  | CO, 750 - 1450°C
 |  | CH4 | -74810 |  | A | B |  | A | B |  | A | B | C |  | A | B | C
 |  | C2H4 | 52467 |  | -2295 | 6.187 |  | -29365 | 8.95 |  | -1508 | 30.28 | 0.001823 |  | -1803 | 31.08 | 0.001673
 | NatGas0reactant | [NAME] | -84684
 | reactant | C3H8 | -103847 |  | aC, 1100 - 1700 K |  |  | pCH4, 1100 - 1700 K |  |  | H2O(g), 750 - 1450°C |  |  |  | CO2, 750 - 1450°C
 | species | C4H10 | -126148 |  | A | B |  | A | B |  | A | B | C |  | A | B | C
 |  | H2 | 0 |  | 8715 | -8.98 |  | 13520 | -14.79 |  | -1463 | 33.87 | 0.005294 |  | -4845 | 50.15 | 0.003331
 |  | CO | -110529
 |  |  |  |  | pO2, Fe/Wust |  |  | [NAME], 1100 - 1700 K |  |  | H2, 750 - 1450°C |  |  |  | Cp of NG
 |  | CO2 | -393509 |  | A | B |  | A | B |  | A | B | C |  | Cp of oxidant
 | Combustion | CO | -110530 |  | -27615 | 6.771 |  | -1654 | 1.513 |  | -166 | 27.18 | 0.002073
 | products | H2O(g) | -241814
 |  | H2O(liq) | -285830
 | Table II.  Heat Content Data for Gas Species
 | T (C) | N2 | H2O | H2 | CO | CO2
 | 800.0000000000001 | 23889.77339986804 | 29051.28007811352 | 22902.00837653425 | 24138.1827144124 | 37416.78136147137
 | 860.0000000000001 | 25882.64167871822 | 31602.98364105543 | 24740.30610930263 | 26162.37316754697 | 40740.95702002001
 | 920.0000000000001 | 27891.89161938194 | 34196.88914908469 | 26592.64750442493 | 28202.91569744763 | 44098.90301482044
 | 980.0000000000001 | 29916.62882429544 | 36832.08145239428 | 28459.43492065764 | 30258.5416582778 | 47487.60273761231
 | 1040 | 31956.00560542311 | 39507.58544401974 | 30340.96598767932 | 32328.09141838654 | 50904.38123896726
 | 1100 | 34009.21756581498 | 42222.37606086649 | 32237.44637255447 | 34410.50598471157 | 54346.85743475276
 | 1160 | 36075.50003244714 | 44975.38623243476 | 34149.00084073956 | 36504.81843890368 | 57812.9043322583
 | 1220 | 38154.12456669049 | 47765.5132702884 | 36075.68281635676 | 38610.1456579611 | 61300.61575020748
 | 1280 | 40244.39566909985 | 50591.62405706341 | 38017.48264236168 | 40725.68055571114 | 64808.27832133634
 | 1400 | 44457.2422571331 | 56347.13704793766 | 41946.12371742745 | 44984.48305453148 | 71877.42900252261
 | Table III.  Water-Gas Shift Rx
 |  | CO2 + H2 ==> CO + H2O
 | T (C) | 1/T (1/K) | [NAME]
 | 1073 | 0.0009318361884987903 | -0.03392764196642908
 | 1173 | 0.0008524059201318441 | 0.1053174754488707
 | 1273 | 0.0007854534067423533 | 0.2193376557843082
 | 1373 | 0.0007282525612241203 | 0.3139821608391697
 | 1473 | 0.0006788175027276064 | 0.3934674979134811
 | 1573 | 0.0006356672942057688 | 0.4609027530703899
 | 1673 | 0.0005976750462588046 | 0.5186255188578232
 | Table IV.  Dew Point Calculation
 | Temp., °C | pH2O, atm | 1/T, K | log pH2O
 | 0 | 0.00603 | 0.003660992128866923
 | 8 | 0.01058 | 0.003556820202738752
 | 16 | 0.01793 | 0.003458412588621823
 | 24 | 0.0294 | 0.003365303718660609
 | 32 | 0.0469 | 0.003277076847452073
 | 40 | 0.0728 | 0.003193357815743254
 | 48 | 0.1101 | 0.003113809746224506
 | 56 | 0.1629 | 0.003038128512836093
 | 60 | 0.1966 | 0.0030016509079994
 |  | (Chart equation gives dpt in °C)
 | Table V.  pO2 in Hot Gas
 |  | 2CO2 ==> 2CO + O2
 | T, K | 1/T, K | [NAME]
 | 1100 | 0.0009090909090909091 | -17.75164864668382
 | 1200 | 0.0008333333333333334 | -15.51964069162876
 | 1300 | 0.0007692307692307692 | -13.63389429125368
 | 1400 | 0.0007142857142857143 | -12.0201344792628
 | 1500 | 0.0006666666666666666 | -10.6238822208381
 | 1600 | 0.000625 | -9.404273547140162
 | 1700 | 0.000588235294117647 | -8.330058135569633
 | Table VI.  aC in Hot Gas
 |  | 2CO ==> CO2 + C
 | T (K) | 1/T (1/K) | [NAME]
 | 1100 | 0.0009090909090909091 | -1.049752795190057
 | 1200 | 0.0008333333333333334 | -1.719136992223056
 | 1300 | 0.0007692307692307692 | -2.281943091024552
 | 1400 | 0.0007142857142857143 | -2.761131570222287
 | 1500 | 0.0006666666666666666 | -3.17354517676188
 | 1600 | 0.000625 | -3.531815321104517
 | 1700 | 0.000588235294117647 | -3.845597854761424
 | Table VII.  pO2 for Fe/Wust
 | 2Fe.947O ==> 1.894Fe(aust) + O2
 | T (K) | 1/T (1/K) | [NAME]
 | 1100 | 0.0009090909090909091 | -18.34379985753342
 | 1185 | 0.0008438818565400836 | -16.53137491118866
 | 1200 | 0.0008333333333333334 | -16.23868831943436
 | 1300 | 0.0007692307692307692 | -14.46311408006025
 | 1400 | 0.0007142857142857143 | -12.94591230883281
 | 1500 | 0.0006666666666666666 | -11.63519220232532
 | 1600 | 0.000625 | -10.49210867444659
 | 1652 | 0.0006053268765133168 | -9.953962313823343
 | Table VIII.  pCH4 in Hot Gas
 |  | 2CO + 2H2 ==> CO2 + CH4
 | 1100 | 0.0009090909090909091 | -2.494485751703327
 | 1200 | 0.0008333333333333334 | -3.524118019868325
 | 1300 | 0.0007692307692307692 | -4.393772472637906
 | 1400 | 0.0007142857142857143 | -5.137227633684013
 | 1500 | 0.0006666666666666662 | -5.779402137335564
 | 1600 | 0.000625 | -6.339164846656884
 | 1700 | 0.000588235294117647 | -6.830945237337993