%OP%TM2
%OP%BM2
%OP%LM5
%OP%HE/ %H2%%H1%Analyse.spr a PIPEDREAM Spreadsheet for calculating ceramic glazes// by Jerry Fryman (0810)
%OP%FO%H2%Z88 Users' Club Software Library%H2%/Z116A/@P@/
%CO:A,72,72%This PIPEDREAM program was devised as an aid to calculating ceramic
glazes to the unity formula and percentage analysis. If you are
familiar with the unity formula and the calculations of Seger then the
reasoning will require little explanation. If you are not then I
recommend the following books as explanation.
Understanding Pottery Glazes. David Green. Faber 1963
The Potters Dictionary of Materials and Techniques. Frank Hamer. Pitman
For the more advanced and as a very good aid to using computer programs
in helping to formulate ceramic glazes I heartily recommend; Stoneware
Glazes a Systematic Approach. Ian Currie. Bootstrap Press.
To use this program, you enter the name of the ingredient in column A
the appropriate amount in column B, then calculate. PIPEDREAM will
LOOKUP the ingredients and return the values to the bottom columns and
then divide the sum of the oxides found by their molecular weight. the
values are returned to the screen via @fields@.
To calculate in reverse when you have a formula and want to find the
recipe is rather more difficult. There are programs that will do this
for you (eg Dr C Hogg's on the BBC) but I find it quite convenient to
keep trying trial and error until I get the correct result on the
screen.
You can add and subtract the various amounts from column B they do not
have to add up to 100 the checksum in the right hand corner will
automatically give you the percentage recipe. If the checksum returns
black error codes then check that you have spelt the ingredient
correctly. Print out column A (23-65) for the complete list of
ingredients. Most of the Data about the ceramic ingredients is from
"FERRO".
You can of course add your own ingredients and add prices. I suggest
you fix row 22 first and make sure it is number mode on the Options
page. Check the bottom row to make sure that you have not corrupted the
calculation!
Save this CLI as Plain text and use it to print out the chart.
~I~E~Ccgsa1~E~Cz~Ccgsf21~E~Cz~Cpo~E~Cq
I have found this very useful for using fairly pure ingredients. Ashes
and natural minerals are much too variable for this kind of theoretical
approach
Good luck, I hope you find the spreadsheet useful; if you have any
problems or comments feel free to contact me.
Jerry Fryman (no 810) Sunday 8th April 1990
%LCR%//%H1%The Cottage, Hollybush, Ledbury, Herefordshire, HR8 1ET