Zone melting calculations: an ideal spreadsheet application

摘要

A simple Excel or Quattro Pro spreadsheet method for the accurate and rapid determination of concentration distributions in zone refined and zone leveled ingots is described and illustrated. Only a fundamental understanding of the solidification process is needed with no requirement for complex mathematical equations or techniques. The spreadsheet method is applicable for any zone length, any value of distribution coefficient, and any number of zone passes. The assumption of an initial uniform concentration distribution is not necessary and therefore any initial concentration distribution can be used. Further, the effect of an initial transient on the concentration distribution is easily accommodated. The graphical capabilities of the spreadsheets provide the means for rapid and simple visual presentation of the results.