%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