Spreadsheet: 119a7feb-a78c-4681-86d1-26b806f6e8aa
Sheet: Heat Balance Calcs

Note:  text box appearance may vary with different Windows and Excel versions.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DH°comb, kJ/g-mol NG | -805.04393 |  | kJ/kg-mol | -805040 | Üuse this value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heat Content Data, kJ/mol =  A + BT + CT2.  T = °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N2, 600 - 2200 °C |  |  |  | O2, 600 - 2200 °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C |  | A | B | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -2077 | 31.4 | 0.001317 |  | -2265 | 33.41 | 0.001255
 |  |  | Str-name | Nat Gas | Burnr Air | CmbstGas | StackGas | Leak Air | Cold Al | Hot Al |  |  |  |  | H2O(g), 600 - 2200 °C |  |  |  | CO2, 600 - 2200 °C
 |  |  | Streams | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  |  | A | B | C |  | A | B | C
 |  |  | Flow | 1307.96354414675 | 14739.11418810369 | 16066.69718541264 | 16391.29568050346 | 324.5984950908248 | 29649.94533291329 | 29649.94533291329 |  |  |  | -2563 | 36.04 | 0.004323 |  | -6014 | 52.48 | 0.002257
 |  |  | Al, (c) | 0 | 0 | 0 | 0 | 0 | 29649.94533291329 | 29649.94533291329
 |  |  | CH4, (g) | 1242.565366939412 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | (note [NAME] heat units)
 |  |  | [NAME], (g) | 39.23890632440249 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Air, 5 - 550 °C |  |  |  | Solid aluminum, kJ/kg
 |  |  | CO2, (g) | 0 | 0 | 1321.043179588217 | 1321.043179588217 | 0 | 0 | 0 |  |  |  | A | B | C |  | A | B | C
 |  |  | H2O, (g) | 0 | 0 | 2602.847452852032 | 2602.847452852032 | 0 | 0 | 0 |  |  |  | -713 | 28.43 | 0.00339 |  | -21.08902231117041 | 0.8745741605514789 | 0.0002543087984582314
 |  |  | N2, (g) | 26.15927088293502 | 11643.90020860191 | 11670.05947948485 | 11926.4922906066 | 256.4328111217516 | 0 | 0
 |  |  | O2, (g) | 0 | 3095.213979501774 | 472.747073487541 | 540.9127574566141 | 68.1656839690732 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Operation.  Enter/edit value in cell AI33 only.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.  Cool incoming burner gas to 25 °C (stream #3) |  |  |  |  |  |  |  | Sum of furnace heat effects
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.  Heat content of incoming aluminum (stream #6) |  |  |  |  | 0 |  |  | Stack gas temperature | 788 | 775 | 750 | 725
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.  Heat content of incoming leak air (stream #5) |  |  |  |  | 0 |  |  | [NAME] Aluminum | 813.508064601436 | 828 | 856 | 884
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.  Heat product aluminum to 550 °C (stream #7)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5a.  Heat stack gas CO2 to 800 °C (stream #4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.  Heat content of incoming natural gas (stream #1) |  |  |  |  | 0 |  |  |  |  |  | 5b.  Heat stack gas H2O to 800 °C (stream #4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.  Heat content of incoming combustion air (stream #2) |  |  |  |  | 0 |  |  |  |  |  | 5c.  Heat stack gas N2 to 800 °C (stream #4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.  Heat of combustion of natural gas (stream #1) |  |  |  |  |  |  |  |  |  |  | 5d.  Heat stack gas O2 to 800 °C (stream #4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4a.  Heat burner gas CO2 to 1800 °C (stream #3) |  |  |  |  |  |  |  |  |  |  | 6.  Heat loss from furnace, kJ/min
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4b.  Heat combustion gas H2O to 1800 °C  (stream #3) |  |  |  |  |  |  |  |  |  |  | 7.  Sum of heat effects for furnace
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4c.  Heat combustion gas N2 to 1800 °C (stream #3)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4d.  Heat combustion gas O2 to 1800 °C (stream #3)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.  Heat loss from burner, kJ/min
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.  Cool incoming burner gas to 25 °C (stream #3)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.  Heat content of incoming aluminum (stream #6) |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.  Heat content of incoming leak air (stream #5) |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.  Heat product aluminum to 550 °C (stream #7)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5a.  Heat stack gas CO2 to 800 °C (stream #4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5b.  Heat stack gas H2O to 800 °C (stream #4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5c.  Heat stack gas N2 to 800 °C (stream #4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5d.  Heat stack gas O2 to 800 °C (stream #4)
 | References |  |  |  |  |  |  |  |  |  |  |  |  | 6.  Heat loss from furnace, kJ/min
 | 1.  Wikipedia contributors, “Enthalpy”, “Thermodynamic Databases for Pure Substances”.
 | 2.  Fact-Web programs, http://www.crct.polymtl.ca/factweb.php.  Use Reaction-Web. | Wikipedia, the Free Encyclopedia, July 2012.  http://en.wikipedia.org/wiki/Main_Page.
 | 3.  NIST Chemistry WebBook, http://webbook.nist.gov/chemistry/
 | 4.  NIST-JANAF Tables, http://kinetics.nist.gov/janaf/ |  |  |  |  |  |  |  |  |  |  |  |  |  | Factor |  |  | Value | % of available
 | 5.  Thermart Software, http://www.thermart.net/ |  |  |  |  |  |  |  |  |  |  |  |  | Heat available from combustion of NatGas
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Heat carried out by stack gas
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Heat carried out by aluminum ingots
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Heat loss