Spread Sheet Model of Continuous Casting

Abstract

Spreadsheet programs, such as Microsoft Excel, Informix WINGZ, and Lotus 123, provide a framework for very fast and easy development of simple engineering models. The present paper describes a model of the continuous casting process that has been developed using a spreadsheet program, Microsoft Excel, running on a Macintosh II personal computer. The model consists of two-dimensional (2-D) steady-state finite-difference heat conduction calculations within a continuous casting mold coupled to a one-dimensional (1-D) transient solidification heat transfer model of the solidifying shell. The model structure and equations are described and the model predictions are compared with previous solutions. Practical examples using the model are discussed and sample results are provided. Spreadsheet programs running on personal computers are capable of relatively complex calculations that would require extensive effort using conventional programming languages.