DEV Community

Ken Deng
Ken Deng

Posted on

The End of Manual Math: AI-Powered Recipe Scaling for Any Batch Size

You know the feeling: you’ve spent hours perfecting a glaze, only to botch the math when scaling it down for a test tile. One misplaced decimal, one forgotten conversion, and your precious batch is ruined. Manual scaling isn’t just tedious—it’s the leading cause of inconsistent results in small-batch ceramics.

The “No-Math” Scaling Prompt Framework

The core principle is simple: stop doing arithmetic and start defining rules. Instead of calculating every ingredient by hand, you create a single prompt or spreadsheet that handles the math and automatically flags dangerous edge cases. This framework works whether you prefer an AI chat tool or a custom spreadsheet.

How it works in practice: When you scale a glaze from 1,000g to 1,500g, the system recalculates every ingredient. But more importantly, it applies two intelligent rules:

  • If the total weight deviates from your target by more than 0.5g, the total is highlighted in red—catching formula errors instantly.
  • If any ingredient weight drops below 1g, the cell turns yellow, warning you that measuring such a tiny amount (e.g., Manganese Dioxide at 2.2g, Red Iron Oxide at 4.4g) is impractical without a precision scale.

For example, scaling a cone-6 base glaze: Kaolin 220.0g, Potash Feldspar 946.0g, Silica 660.0g, Whiting 374.0g. The AI handles unit conversion between grams and ounces seamlessly, so you can work with whatever materials you have on hand.

Two Pathways to Automation

Pathway A: The Adapted AI Math Solver – Use a prompt-based AI tool (like ChatGPT or Claude) to act as your scaling assistant. You provide the base recipe and target batch size; the AI applies your rules and returns a clean, verified result. This is the quickest start, requiring no spreadsheet setup.

Pathway B: Your Own Custom Spreadsheet AI – Build a dedicated “Scaler” tab with built-in conditional formatting and formulas. Once configured, it becomes a set-and-forget solution that works offline and gives you full control.

Implementation in Three Steps

  1. Choose Your Pathway. If you’re unsure, start with Pathway A (the AI Math Solver). It takes minutes to test and costs nothing.
  2. Select One Master Recipe. Pick your most-used glaze—the one you scale most often. This becomes your pilot.
  3. Add One Intelligent Rule. Implement just one conditional format or prompt instruction. The “<1g warning” (yellow highlight) is a great first rule because it prevents measurement errors before they happen. Then build or format the rest.

That’s it. No complex macros, no advanced math. The goal is to eliminate manual calculation and let the system catch the tiny errors that ruin batches.

Key Takeaways

  • Manual math is the weakest link in glaze consistency. Replace it with a rule-based scaling framework.
  • Use conditional warnings (red for >0.5g deviation, yellow for <1g) to error-proof your process.
  • Start small: one recipe, one rule, one pathway. Scale from there.

Your glazes deserve precision. Let the AI handle the arithmetic so you can focus on the art.

Top comments (0)