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.

1.
Burmeister, L. C., 1983, Convective Heat Transfer, John Wiley & Sons, New York, pp. 484–486.
2.
Carslaw, H. S., and Jaeger, J. C., 1959, Conduction of Heat in Solids, Oxford University Press, 2nd ed., pp. 285–291.
3.
Hills
A. W. D.
,
1969
, “
The Generalized Integral Profile Method for the Analysis of Unidirectional Heat Flow during Solidification
,”
Trans. TMS-AIME
, Vol.
245
, p.
1471
1471
.
4.
Ho, B., 1992, “Characterization of Interfacial Heat Transfer in the Continuous Slab Casting Process,” Masters Thesis, University of Illinois, Urbana, IL.
5.
Jenkins, M. S., Thomas, B. G., Chen, W. C., and Mahapatra, R. B., 1994, “Investigation of Strand Surface Defects Using Mold Instrumentation and Modelling,” Steelmaking Conference Proceedings, Vol. 77, Iron and Steel Society, Warrendale, PA.
6.
Lait, J. E., Brimacombe, J. K., and Weinberg, F., 1974, “Mathematical Modeling of Heat Flow in the Continuous Casting of Steel,” Ironmaking and Steelmaking, No. 2, pp. 90–97.
7.
Mahapatra
R. B.
,
Brimacombe
J. K.
,
Samarasekera
I. V.
,
Walker
N.
,
Paterson
E. A.
, and
Young
J. D.
,
1991
, “
Mold Behavior and Its Influence on Quality in the Continuous Casting of Steel Slabs: Part I. Industrial Trials, Mold Temperature Measurements, and Mathematical Modeling
,”
Metallurgical Transactions
, Vol.
22B
, pp.
861
874
.
8.
Minkowycz, W. J., Sparrow, E. M., Schneider, G. E., and Pletcher, R. H., 1988, Handbook of Numerical Heat Transfer, John Wiley & Sons, Inc., New York, pp. 69–71.
9.
Szekely, J., Evans, J., and Brimacombe, J. K., 1988, The Mathematical and Physical Modeling of Primary Metals Processing Operations, John Wiley & Sons, New York, pp. 203–216.
10.
Thomas
B. G.
,
1989
, “
Application of Mathematical Models to the Continuous Slab Casting Mold
,”
Iron and Steel Society Transactions
, Vol.
16
, No.
12
, pp.
53
66
.
This content is only available via PDF.
You do not currently have access to this content.