Teaching Process Simulation in Eleven Easy Lessons Using Excel and Its Tools

  • Arthur E. Morris
Conference paper


The primary market driver for improving process technology is innovation, which requires a skilled and educated workforce. However, many Materials Science and Engineering departments have eliminated extractive metallurgy and chemical thermodynamics from their curricula, yet these topics contain the necessary fundamentals for process innovation. As a result, most MS&E students are ill-prepared for careers in processing. The dearth of process-oriented MS&E curricula has prompted some Universities to develop a “shared” effort to offer distance education between multiple institutions [1]. A target audience for a shared process simulation course would not only benefit students, but also be a basis for an on-line course for practicing engineers faced with new or changing career choices. To fill the gap, the basics of a process simulation course was developed in an abbreviated form as series of eleven articles and Excel workbooks published in Industrial Heating magazine between July 2012 and July 2013.


Processing Energy Education Combustion Software Simulation Flowsheet 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    CourseShare, September 2013.
  2. 2.
    Wikipedia contributors, “Massive open online course”. Wikipedia, the Free Encyclopedia, (September 2013). Scholar
  3. 3.
    AboutEdu, “Directory of free Massively Open Online Courses providers”, (September 2013).Google Scholar
  4. 4. (September 2013).
  5. 5.
    Arthur Morris and Semih Perdahcioglu, “Software for Energy Education”, Energy Technologies and Carbon Dioxide Management, TMS Annual Meeting & Exhibition, (2013).Google Scholar
  6. 6.
    Arthur Morris, Gordon Geiger, and H. Alan Fine, “Handbook on Material and Energy Balance Calculations in Materials Processing”, TMS/Wiley, (2011).CrossRefGoogle Scholar
  7. 7.
    Eric Grimsey, “Basic Flow sheeting Principles with Examples”,, (September, 2011).Google Scholar
  8. 8., “Combustion calculations” (September 2013).
  9. 9.
    Arthur Morris, “Standard Temperature and Pressure”, VolCalc.xlsx,, (July 2012), 22.Google Scholar
  10. 10.
    Arthur Morris, “Combustion Management”, StoichCalc.xlsx,, (August 2012), 24.Google Scholar
  11. 11.
    Arthur Morris, “Calculating the Heat of Combustion for Natural Gas”, HeatCalc.xlsx,, (September 2012), 28.Google Scholar
  12. 12.
    Wikipedia contributors, “Combustion”. Wikipedia, the Free Encyclopedia, (September 2013). Scholar
  13. 13.
    Arthur Morris, “Making a Material Balance”, MatBalCalc.xlsx,, (Nov. 2012), 20.Google Scholar
  14. 14.
    Arthur Morris, “Making a Heat Balance”, HeatBalCalc.xlsx,, (December 2012), 22.Google Scholar
  15. 15.
    FREED database, (September 2013)
  16. 16.
    Arthur Morris, “Making a System Balance (Part 1)”, SysBalBalCalc.xlsx,, (February 2013), 22.Google Scholar
  17. 17.
    Arthur Morris, “Making a System Balance (Part 2)”, SysBalBalCalc2.xlsx,, (March 2013), 24.Google Scholar
  18. 18.
    Arthur Morris, “Available Combustion Heat”, AvailHeatCalc.xlsx,, (April 2013), 22.Google Scholar
  19. 19. (May 2012).
  20. 20.
    Arthur Morris, “Adiabatic Flame Temperature”, AFT-Calc.xlsx,, (May 2013), 20.Google Scholar
  21. 21.
    Arthur Morris, “Exothermic Atmospheres”, ExoCalc.xlsx,, (June 2013), 22.Google Scholar
  22. 22.
    ASM Committee on Furnace Atmospheres, Furnace Atmospheres and Carbon Control, Metals Park, OH (1964).Google Scholar
  23. 23.
    Arthur Morris, “Burner Analysis”, BurnerCalc.xlsx,, (July 2013), 20.Google Scholar
  24. 24., “Software”. (September 2013).

Copyright information

© TMS (The Minerals, Metals & Materials Society) 2014

Authors and Affiliations

  • Arthur E. Morris
    • 1
  1. 1.Thermart SoftwareSan DiegoUSA

Personalised recommendations