How To Make Worksheet For Pottery

The basics of what a pottery worksheet actually is

A pottery worksheet is just a structured tracking sheet that records your batch recipes, firing schedules, glaze measurements, and test results so you stop relearning everything every time you fire. Most potters I know end up reinventing the same formulas because they never wrote them down properly. I spent three years doing that before I bothered building a real system. The problem is that pottery workflows aren't linear. You mix a glaze, test it, adjust the percentage, fire, check the results, tweak again. A good worksheet captures all of that, not just the final recipe. If you're only tracking the end result, you're going to lose the intermediate adjustments that actually mattered.

How To Make Worksheet For Pottery

Start with the columns that actually matter. I use these headers: Batch ID, Material, Weight (grams), Percentage, Mix Water (ml), Application Method, Bisque Fire (Cone), Glaze Fire (Cone), Kiln Type, Duration, Result Notes, Defect Tags, and Revised Formula (if any). The last column is the one beginners skip and regret later. Here is the practical part. Open a blank spreadsheet. Put your headers in row one. Freeze the top row so they stay visible when you scroll. Column A gets a unique Batch ID format like POT-2026-001 where the year prevents confusion when you're looking at sheets from multiple years. You do not want to guess which batch is from 2024 or 2025 when the results are ambiguous. For the material columns, break it down by component. If a glaze has ten ingredients, that is ten rows under one Batch ID. The percentage column should add up to 100 percent across those rows. This makes scaling easy. If your test used 100 grams total but you need 500 grams for production, you multiply every material weight by five. That is the whole point of tracking both grams and percentages.

Application method matters more than people realize. Same glaze on porous bisque absorbs differently than the same glaze on glazed porcelain. I started logging whether I dipped, poured, sprayed, or brushed, and the kiln shelf position too. Shelf position sounds trivial until you realize your top shelf runs 30 degrees hotter than the bottom and you're blaming the recipe when it was just bad positioning.

The firing schedule section

This is where most worksheets fail. They note the cone temperature but ignore the rate of climb, the hold time, and the cooling phase. A glaze that fires to Cone 6 in three hours looks nothing like the same glaze fired in six hours. The difference shows up as crawling, settling, color shifts, or pinholing, and without recording the rate, you cannot distinguish between a recipe problem and a schedule problem. I add a separate tab or section for firing logs. Date, kiln model, element condition (new, worn, one replaced), thermocouple age, atmosphere (oxidation or reduction), soak duration, ramp rate, and cooling method. This is excessive for casual studio work. It is necessary if you run a production line or teach classes where consistency matters. I once spent two weeks troubleshooting a celadon glaze that kept coming out speckled and dull. The formula had not changed. The kiln elements had degraded by about eighteen percent between firings, which shifted the actual temperature enough to throw off the iron reduction balance. Without a firing log column, I would have kept adjusting the recipe endlessly. The worksheet made the real problem obvious in about ten minutes.

Building the test design section

Before you fill in results, you need a way to plan your tests. I keep a separate tab called Test Matrix where I map out variables. If I am testing three variations of a base glaze across four application thicknesses on three different clay bodies, that is thirty-six data points. Writing that out in a matrix before you fire prevents the common mistake of testing too many variables at once and not knowing which one caused the change. The matrix works best when you change only one variable per column. Base formula, thickness, clay body, firing schedule. Rotate one thing at a time. If you change the formula and the thickness and the firing all at once, you get messy data that leads nowhere useful. Result Notes should be specific. Not "looked good" or "too dark." Write the actual observations: glossy with minor crawing at edges, matte with slight orange peel texture, color shifted from blue to green in reduction, settled after second coat. Defect Tags are checkbox columns for common issues: crawling, shivering, pinholing, blisters, settling, color deviation, fit failure, crazing. Checkboxes are faster to fill than typing every time and make filtering by defect type much easier later.

The revised formula workflow

When a test does not work, do not overwrite the original row. Add a new row underneath with the same Batch ID prefix plus a version number like POT-2026-001-V2. Keep the original data intact. This saves you from accidentally losing a working formula while chasing a better one, which happens more often than you would think. The Revised Formula column should show exactly what changed. Not "tweaked it" but "reduced whiting from 15g to 10g, added 5g bone ash." Specificity here is what separates a usable worksheet from a messy one.

Setup and maintenance

Keep the master file in cloud storage with version history enabled. Google Sheets or Excel Online both work. The version history saved me when I accidentally overwrote a three-year-old working recipe and deleted the only record of it. Recovery took about forty seconds from the revision history. Add data validation to the application method and defect tag columns. Dropdown menus prevent typos from cluttering your filters. "Dipped" and "dip" and "dippd" should all be the same value, not three separate entries that break your summary reports. The whole setup takes about twenty minutes for a first version. Once configured, each batch entry takes roughly three minutes to fill in. The time investment pays off within the third or fourth batch when you stop wasting materials on failed tests because you can look up what you already tried.

When worksheets break down

This system does not help if you fire irregularly or keep changing your studio setup. Kiln swaps, different glaze lines, seasonal humidity changes, and rotating assistants all introduce variables that a single spreadsheet cannot fully capture. In those cases, I supplement the worksheet with a simple physical binder containing sample tiles from each batch. The spreadsheet tells you what you did. The tile tells you what it actually looked like. If you are only making one or two pots a month, the worksheet overhead might feel unnecessary. That is fair. But even then, the Batch ID and Result Notes columns alone prevent the recurring mistake of remaking a successful glaze without remembering the exact conditions it required.