How to Use a Pottery Worksheet for Glaze Calculations
A Pottery Worksheet is a structured template used by potters to track glaze recipes, calculate batch sizes, and manage material weights before mixing. I have been making glazes for roughly twelve years, and I still rely on one for every new recipe I develop. The concept is straightforward. You write down your raw materials, their percentages, and the molecular formula targets you are aiming for. From there, you can scale batches up or down without recalculating everything from scratch. The first thing you need is a base recipe format. Most potters use a standard sheet with columns for material name, batch weight percentage, and molecular substitution values. Some people build these in spreadsheets. I prefer a printed format because it forces me to slow down and think through each step before committing numbers to paper. If you are working digitally, at least print a copy before you go to the studio. Screens introduce errors. Paper does not.
Pottery Worksheet Essentials
Here is what a basic Pottery Worksheet should include on the front side. Material names in the first column. Batch weight percentages in the second. Molecular oxide contributions in the third. Total batch weight at the bottom. These four data points cover roughly eighty percent of what most studio potters need day to day. The remaining twenty percent involves flux ratios and silica-alumina balance, which you calculate after the base numbers are locked in. I used to skip the molecular column entirely. That lasted about three glaze fires. My first mistake was assuming that a recipe that worked at cone 6 would work identically at cone 10. It did not. The same batch produced a running, glassy mess that stuck to my kiln shelves. After that, I started filling out the molecular portion of the worksheet before testing anything. It took me longer initially, but it saved me three weeks of trial and error on a single glaze that ended up being a flux imbalance problem. Let me walk through the actual process. You start by selecting your base materials. Silica, feldspar, dolomite, calcia, alumina sources. Write each one down with its chemical composition. Most suppliers provide a data sheet. If they do not, look it up. Do not guess. Input the target oxide percentages you want the final glaze to hit. A typical mid-fire glaze runs around sixty percent silica, twenty percent alumina, and the rest distributed across fluxes like potassium, sodium, calcium, and magnesium. Enter those targets into your worksheet. Now you solve for the material weights that produce those oxide percentages.
The solving part is where people get stuck. There are two approaches. The long way involves setting up a system of linear equations and solving them by hand or with a calculator. The short way uses a spreadsheet solver add-in or an online glaze calculator. I recommend learning the long way at least once. It teaches you how the materials actually interact. After that, use whichever method gets you the result faster. Speed matters when you are running a production studio. One edge case that trips people up regularly is when your target flux ratio requires a material that contains multiple oxides. For example, feldspar provides both potassium and silica. Dolomite provides calcium and magnesium along with some CO2 that burns off. Your worksheet needs a column for these dual-contributing materials so you do not double-count or miss an oxide entirely. I lost an entire batch once because I forgot that Custer feldspar carries roughly ten percent silica by weight. The glaze came out under-silicated and crawling all over the ware. Took me four hours to clean it off. After you have the batch weights calculated, you scale to your desired batch size. Multiply each material weight by your scaling factor. Weigh everything. Mix with water. Sieve if necessary. Fire a test tile. Record the results on the back of your worksheet. That recording step is non-negotiable. Your future self will thank you when you try to recreate a glaze six months later and remember almost nothing about how it behaved.
Get the Full Details

There are limitations to this method that nobody talks about enough. A Pottery Worksheet gives you theoretical accuracy. It does not account for raw material variability between suppliers. Two batches of the same named material from different vendors can produce noticeably different results. The worksheet cannot fix that. You will always need physical test tiles to validate calculations. Also, the system breaks down when you work with unconventional materials like bone ash, whiting, or locally gathered clays with unknown compositions. In those cases, the worksheet becomes a starting point rather than a reliable guide. If you are just getting started, do not buy an expensive software package. Build a simple spreadsheet or print a blank template and use a pen. The structure matters more than the tool. Fill it out consistently. Keep old worksheets in a binder. You will build a reference library that is worth more than any commercial product on the market. The file I use personally is stored as a PDF template that I print and refill each time I develop a new glaze. It has space for the calculation, the test results, and a notes section for observations like surface texture, color shifts between firings, and any defects I noticed. I do not share the exact file publicly, but finding a similar format online is easy. Search for ceramic glaze calculation worksheet PDF and you will find several community-shared versions. Pick one, modify it to fit your workflow, and stick with it.
One counter-intuitive thing I learned the hard way is that over-precision in your worksheet can actually hurt your results. Writing glaze percentages to four decimal places gives a false sense of accuracy. Your batch scale probably reads to two decimal places at best. Focusing on the fourth decimal is wasted effort. Round your percentages reasonably. Focus on the materials that actually move the needle: silica content, alumina content, and the primary flux ratio. Those three variables control ninety percent of your glaze behavior. Everything else is fine-tuning. Another thing beginners miss is the drying time factor. When you mix a glaze according to your worksheet weights, the slurry consistency matters. Too thin and it runs off the ware. Too thick and it cracks during drying. Adjust your water ratio based on the material composition, not arbitrarily. High-silica glazes need more water to stay suspended. High-alumina glazes thicken quickly and may need a deflocculant. Write down your water-to-glaze ratio on the worksheet alongside the dry weights. That single data point saves you from guessing next time you remix the same batch. I do not recommend relying solely on a worksheet if you are firing at extreme temperatures above cone 12 or using non-standard kiln atmospheres. The chemistry changes significantly in those conditions, and the theoretical calculations diverge from actual results. In those cases, treat the worksheet as a rough guide and plan for extensive testing. There is no shortcut around physical experimentation when you push the boundaries of traditional glaze chemistry.