%OP%WRN %OP%PL65 %OP%AMM %OP%RCR %OP%DP3 %OP%LM5 %OP%DE%H1%%H2%ANALYSIS.SPR %CO:A,17,107%%H2%GLAZE:80/16 potash feldspar ---------------------------------------------- %H2%RECIPE |AMOUNT| %PC% unity ---------------------------------------------- %R%potash feldspar %R%Whiting %R% %R% %R% %R% %R% %R% %R% %R% ALUMINA/SILICA RATIO 1: @D84@ FLUX :AMPHOTERIC:GLASS 1 : @A84@ : @B84@ %P0% %H2%INGREDIENT NAME ALBANY SLIP ALKALINE FRIT BALL CLAY TWVA BALL CLAY WWB BALL CLAY KENTUCKY BARIUM CARBONATE BARNARD CLAY BASALT BENTONITE BONE ASH BORAX FRIT CALCIUM BORATE FRIT CHINA CLAY CHINA CLAY EPK COLEMANITE CORNISH STONE CORNWALL STONE CUSTER FELDSPAR DOLOMITE FLINT IRON OXIDE KONA A3 KONA F4 KINGMAN FELDSPAR LEAD BISILICATE LEAD SEQUISILICATE LITHIUM CARBONATE MAGNESIUM CARB MOLOCHITE NEPHELINE SYENITE POTASH FELDSPAR QUARTZ RUTILE SODA ASH SODA FELDSPAR TALC TITANIUM DIOXIDE WHITING WOLLASTONITE WOOD ASH WOOD ASH SUB ZINC OXIDE %V%%R%lookup($A5,$A$24$A$71,A$24A$71) %V%%R%lookup($A6,$A$24$A$71,A$24A$71) %V%%R%lookup($A7,$A$24$A$71,A$24A$71) %V%%R%lookup($A8,$A$24$A$71,A$24A$71) %V%%R%lookup($A9,$A$24$A$71,A$24A$71) %V%%R%lookup($A10,$A$24$A$71,A$24A$71) %V%%R%lookup($A11,$A$24$A$71,A$24A$71) %V%%R%lookup($A12,$A$24$A$71,A$24A$71) %V%%R%lookup($A13,$A$24$A$71,A$24A$71) SUM OF OXIDES %PC% OXIDES MOLES UNITY %V%%R%sum(M83N83) This Pipedream program was devised by Jerry Fryman, Hollybush Pottery, Ledbury HR8 1ET Simply enter your minerals in column A and check percentage in column M. Print out the analysis to percentage and unity using the CLI. (po.cli) The list of ingredients column A 22-65. calculations from rows 69-82. returned via @fields@. Good luck. %CO:B,6,90% %V%%R%80 %V%%R%16 %V%%R%0 %V%%R%0 %V%%R%0 %V%%R%0 %V%%R%0 %V%%R%0 %V%%R%lookup($A5,$A$24$A$71,B$24B$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,B$24B$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,B$24B$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,B$24B$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,B$24B$71)*$B9/100 %V%%R%sum(D80Q80) %V%%R%sum(D81Q81) %V%%R%sum(D82L82) %V%%R%sum(O83Q83) %CO:C,1,0% | | | | | | | | | | | | | | | | | %CO:D,6,84% %H2%Lio2 %H2%K2%H5%O%H5% %H2%NaO %H2%BaO %H2%CaO %H2%MgO %H2%PbO %H2%ZnO %H2%FeO %H2%TiO%H5%2%H5% %H2%Al%H5%2%H5%O %H2%B%H5%2%H5%O%H5%3%H5% %H2%SiO%H5%2%H5% %H2%P%H5%2%H5%O%H5%5%H5% %V%%R%29.8 %H2%LiO %V%%R%39.9 %V%%R%0 %V%%R%lookup($A5,$A$24$A$71,D$24D$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,D$24D$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,D$24D$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,D$24D$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,D$24D$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,D$24D$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,D$24D$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,D$24D$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,D$24D$71)*$B13/100 %V%%R%sum(D71D79) %V%%R%D80/$B81*100 %V%%R%D81/D23 %V%%R%D82/$B83 %V%%R%B84/A84 %CO:E,8,79% %R%@D81@ %R%@E81@ %R%@F81@ %R%@G81@ %R%@H81@ %R%@I81@ %R%@J81@ %R%@K81@ %R%@L81@ %R%@M81@ %R%@N81@ %R%@O81@ %R%@P81@ %R%@Q81@ %V%%R%94.2 %H2%K20 %V%%R%3.2 %V%%R%15 %V%%R%2.2 %V%%R%1.9 %V%%R%1 %V%%R%1 %V%%R%2.4 %V%%R%4.7 %V%%R%1.84 %V%%R%0.22 %V%%R%4.4 %V%%R%6.57 %V%%R%10.4 %V%%R%3.7 %V%%R%7 %V%%R%12 %V%%R%8.9 %V%%R%9 %V%%R%2.5 %V%%R%1.21 %V%%R%1.6 %V%%R%lookup($A5,$A$24$A$71,E$24E$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,E$24E$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,E$24E$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,E$24E$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,E$24E$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,E$24E$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,E$24E$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,E$24E$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,E$24E$71)*$B13/100 %V%%R%sum(E71E79) %V%%R%E80/$B81*100 %V%%R%E81/E23 %V%%R%E82/$B83 %CO:F,8,73% %R%%H2%@D83@%H2% %R%%H2%@E83@%H2% %R%%H2%@F83@%H2% %R%%H2%@G83@%H2% %R%%H2%@H83@%H2% %R%%H2%@I83@%H2% %R%%H2%@J83@%H2% %R%%H2%@K83@%H2% %R%%H2%@L83@%H2% | %R%%H2%@M83@%H2% %R%%H2%@N83@%H2% | %R%%H2%@O83@%H2% %R%%H2%@P83@%H2% %R%%H2%@Q83@%H2% %V%%R%62 %H2%NaO %V%%R%0.8 %V%%R%17.5 %V%%R%0.3 %V%%R%0.3 %V%%R%0.3 %V%%R%0.5 %V%%R%0.6 %V%%R%7.1 %V%%R%0.08 %V%%R%0.04 %V%%R%3.6 %V%%R%2.29 %V%%R%3 %V%%R%7.8 %V%%R%4.5 %V%%R%2.8 %V%%R%7.9 %V%%R%3 %V%%R%50 %V%%R%8.2 %V%%R%0.4 %V%%R%0.5 %V%%R%lookup($A5,$A$24$A$71,F$24F$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,F$24F$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,F$24F$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,F$24F$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,F$24F$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,F$24F$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,F$24F$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,F$24F$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,F$24F$71)*$B13/100 %V%%R%sum(F71F79) %V%%R%F80/$B81*100 %V%%R%F81/F23 %V%%R%F82/$B83 %CO:G,2,68%| | | | | | | | | | | | | | | | | | | %V%%R%153.3 %H2%BaO %V%%R%98 %V%%R%lookup($A5,$A$24$A$71,G$24G$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,G$24G$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,G$24G$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,G$24G$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,G$24G$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,G$24G$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,G$24G$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,G$24G$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,G$24G$71)*$B13/100 %V%%R%sum(G71G79) %V%%R%G80/$B81*100 %V%%R%G81/G23 %V%%R%G82/$B83 %CO:H,6,62% %H4%RATIO'S 1:@D84@ 1:@A84@:@B84@ %V%%R%56.1 %H2%CaO %V%%R%5.8 %V%%R%6.3 %V%%R%0.2 %V%%R%0.2 %V%%R%0.4 %V%%R%0.5 %V%%R%7.9 %V%%R%54 %V%%R%12.1 %V%%R%0.1 %V%%R%0.09 %V%%R%25.7 %V%%R%1.7 %V%%R%1.6 %V%%R%0.3 %V%%R%33 %V%%R%0.4 %V%%R%1.8 %V%%R%0.1 %V%%R%1.8 %V%%R%55.2 %V%%R%48 %V%%R%0.49 %V%%R%48 %V%%R%lookup($A5,$A$24$A$71,H$24H$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,H$24H$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,H$24H$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,H$24H$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,H$24H$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,H$24H$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,H$24H$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,H$24H$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,H$24H$71)*$B13/100 %V%%R%sum(H71H79) %V%%R%H80/$B81*100 %V%%R%H81/H23 %V%%R%H82/$B83 %CO:I,6,56% %V%%R%40.3 %H2%MgO %V%%R%2.5 %V%%R%0.3 %V%%R%0.3 %V%%R%0.3 %V%%R%0.6 %V%%R%10.3 %V%%R%1.3 %V%%R%0.25 %V%%R%0.12 %V%%R%0.05 %V%%R%0.01 %V%%R%19 %V%%R%42.3 %V%%R%32 %V%%R%1.3 %V%%R%4.5 %V%%R%3.3 %V%%R%lookup($A5,$A$24$A$71,I$24I$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,I$24I$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,I$24I$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,I$24I$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,I$24I$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,I$24I$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,I$24I$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,I$24I$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,I$24I$71)*$B13/100 %V%%R%sum(I71I79) %V%%R%I80/$B81*100 %V%%R%I81/I23 %V%%R%I82/$B83 %CO:J,3,50% %V%%R%223.2 %H2%PbO %V%%R%65 %V%%R%68 %V%%R%lookup($A5,$A$24$A$71,J$24J$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,J$24J$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,J$24J$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,J$24J$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,J$24J$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,J$24J$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,J$24J$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,J$24J$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,J$24J$71)*$B13/100 %V%%R%sum(J71J79) %V%%R%J80/$B81*100 %V%%R%J81/J23 %V%%R%J82/$B83 %CO:K,6,44% %H4%%H1%TOTALS @A5@ @A6@ @A7@ @A8@ @A9@ @A10@ @A11@ @A12@ @A13@ @A14@ %V%%R%81.4 %H2%ZnO %V%%R%99.7 %V%%R%lookup($A5,$A$24$A$71,K$24K$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,K$24K$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,K$24K$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,K$24K$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,K$24K$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,K$24K$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,K$24K$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,K$24K$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,K$24K$71)*$B13/100 %V%%R%sum(K71K79) %V%%R%K80/$B81*100 %V%%R%K81/K23 %V%%R%K82/$B83 %CO:L,6,38% %V%%R%71.8 %H2%FeO %V%%R%5.2 %V%%R%1 %V%%R%0.8 %V%%R%0.8 %V%%R%29.9 %V%%R%11.2 %V%%R%0.6 %V%%R%0.42 %V%%R%0.16 %V%%R%0.08 %V%%R%98.4 %V%%R%0.07 %V%%R%0.04 %V%%R%0.1 %V%%R%0.5 %V%%R%0.5 %V%%R%0.2 %V%%R%lookup($A5,$A$24$A$71,L$24L$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,L$24L$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,L$24L$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,L$24L$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,L$24L$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,L$24L$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,L$24L$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,L$24L$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,L$24L$71)*$B13/100 %V%%R%sum(L71L79) %V%%R%L80/$B81*100 %V%%R%L81/L23 %V%%R%L82/$B83 %CO:M,6,32% %V%%R%79.9 %H2%TiO %V%%R%0.4 %V%%R%1 %V%%R%1.5 %V%%R%1.6 %V%%R%0.2 %V%%R%0.6 %V%%R%0.03 %V%%R%0.34 %V%%R%98 %V%%R%99.7 %V%%R%0.2 %V%%R%lookup($A5,$A$24$A$71,M$24M$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,M$24M$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,M$24M$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,M$24M$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,M$24M$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,M$24M$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,M$24M$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,M$24M$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,M$24M$71)*$B13/100 %V%%R%sum(M71M79) %V%%R%M80/$B81*100 %V%%R%M81/M23 %V%%R%M82/$B83 %CO:N,6,26% %V%%R%SUM(B5B14) %V%%R%B5/$N$4*100 %V%%R%B6/$N$4*100 %V%%R%B7/$N$4*100 %V%%R%B8/$N$4*100 %V%%R%B9/$N$4*100 %V%%R%B10/$N$4*100 %V%%R%B11/$N$4*100 %V%%R%B12/$N$4*100 %V%%R%B13/$N$4*100 %V%%R%B14/$N$4*100 %V%%R%SUM(N5N14) %V%%R%102 %H2%Al2O %V%%R%14.6 %V%%R%5.7 %V%%R%32.8 %V%%R%18.8 %V%%R%31.2 %V%%R%6.7 %V%%R%14.1 %V%%R%36 %V%%R%9.6 %V%%R%37.2 %V%%R%38.71 %V%%R%16.4 %V%%R%16.8 %V%%R%17.5 %V%%R%16.3 %V%%R%19.7 %V%%R%18.7 %V%%R%2.6 %V%%R%2.8 %V%%R%42.5 %V%%R%24.7 %V%%R%18 %V%%R%20.4 %V%%R%26 %V%%R%11 %V%%R%13.2 %V%%R%lookup($A5,$A$24$A$71,N$24N$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,N$24N$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,N$24N$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,N$24N$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,N$24N$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,N$24N$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,N$24N$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,N$24N$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,N$24N$71)*$B13/100 %V%%R%sum(N71N79) %V%%R%N80/$B81*100 %V%%R%N81/N23 %V%%R%N82/$B83 %CO:O,6,20% %V%%R%69.6 %H2%B2o3 %V%%R%3.9 %V%%R%13.4 %V%%R%43.4 %V%%R%lookup($A5,$A$24$A$71,O$24O$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,O$24O$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,O$24O$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,O$24O$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,O$24O$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,O$24O$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,O$24O$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,O$24O$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,O$24O$71)*$B13/100 %V%%R%sum(O71O79) %V%%R%O80/$B81*100 %V%%R%O81/O23 %V%%R%O82/$B83 %CO:P,6,14% %V%%R%60.1 %H2%SiO2 %V%%R%57.6 %V%%R%50.5 %V%%R%71.3 %V%%R%51.1 %V%%R%41.4 %V%%R%48.6 %V%%R%48.6 %V%%R%47.7 %V%%R%45.91 %V%%R%4.6 %V%%R%72.1 %V%%R%71.1 %V%%R%68.5 %V%%R%2.9 %V%%R%100 %V%%R%71.6 %V%%R%66.8 %V%%R%66 %V%%R%32 %V%%R%68.7 %V%%R%54.5 %V%%R%54.8 %V%%R%70 %V%%R%100 %V%%R%1.5 %V%%R%66 %V%%R%58.8 %V%%R%50.5 %V%%R%30.49 %V%%R%30.2 %V%%R%lookup($A5,$A$24$A$71,P$24P$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,P$24P$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,P$24P$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,P$24P$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,P$24P$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,P$24P$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,P$24P$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,P$24P$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,P$24P$71)*$B13/100 %V%%R%sum(P71P79) %V%%R%P80/$B81*100 %V%%R%P81/P23 %V%%R%P82/$B83 %CO:Q,6,8% %V%%R%142 %H2%P2O5 %V%%R%0.3 %V%%R%41 %V%%R%2.76 %V%%R%2.7 %V%%R%0.52 %V%%R%lookup($A5,$A$24$A$71,Q$24Q$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,Q$24Q$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,Q$24Q$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,Q$24Q$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,Q$24Q$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,Q$24Q$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,Q$24Q$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,Q$24Q$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,Q$24Q$71)*$B13/100 %V%%R%sum(Q71Q79) %V%%R%Q80/$B81*100 %V%%R%Q81/Q23 %V%%R%Q82/$B83 %CO:R,6,2% %H2%PRICE%H2% %V%%R%lookup($A5,$A$24$A$71,R$24R$71)*$B5/100 %V%%R%lookup($A6,$A$24$A$71,R$24R$71)*$B6/100 %V%%R%lookup($A7,$A$24$A$71,R$24R$71)*$B7/100 %V%%R%lookup($A8,$A$24$A$71,R$24R$71)*$B8/100 %V%%R%lookup($A9,$A$24$A$71,R$24R$71)*$B9/100 %V%%R%lookup($A10,$A$24$A$71,R$24R$71)*$B10/100 %V%%R%lookup($A11,$A$24$A$71,R$24R$71)*$B11/100 %V%%R%lookup($A12,$A$24$A$71,R$24R$71)*$B12/100 %V%%R%lookup($A13,$A$24$A$71,R$24R$71)*$B13/100 %V%%R%sum(R71R79) %V%%R%R82/$B83