So you want to make soap and you need a starting point.
I've been doing cold process for about six years now, and honestly the biggest bottleneck isn't the chemistry — it's having a consistent template to work from every time. Without one, you're guessing weights, tracking lye solution percentages in your head, and wondering why batch #14 smelled different than batch #3. Here's the simple template I use, what it actually looks like on paper, and where it falls apart if you're not careful. The core structure is always the same four columns, nothing fancy. You list each oil or butter, note its weight in grams, look up its SAP value (sodium hydroxide requirement), and multiply to get the lye needed for that ingredient. Then you add up the lye, decide your superfat percentage, adjust the NaOH weight accordingly, and calculate your water amount. That's it. Four columns, one total, a few adjustments at the bottom. I use a spreadsheet myself, but the same thing works on a piece of notebook paper. The template doesn't care about the medium. What matters is that you have a place to write down your numbers so you can reproduce the batch or change one variable and see exactly what shifted.
How the template actually works in practice
Start by picking your oils. Let's say I'm doing a basic bar that's 40 percent olive oil, 30 percent coconut oil, 20 percent palm oil, and 10 percent castor oil. That's a fifty-fifty gram batch, so olive oil is 200g, coconut is 150g, palm is 100g, castor is 50g. The SAP values from the Lortscher table are roughly 0.134 for olive, 0.190 for coconut, 0.141 for palm, and 0.129 for castor. Multiply each: olive needs 26.8g NaOH, coconut needs 28.5g, palm needs 14.1g, castor needs 6.45g. Total lye before superfat is 75.85g. Now the superfat. Most home soap makers run 5 percent, which means you reduce the NaOH by 5 percent rather than adding extra oil. So 75.85 times 0.95 gives you 72.06g of sodium hydroxide. Some people confuse this direction — they add oil instead of subtracting lye — and the result is a soft, under-saponified mess that won't harden. Don't do that. Subtract from the lye, not from the oils. Water comes next. The standard starting point is 38 percent of the total oil weight, so 500g of oils times 0.38 is 190g of water. I usually run a bit higher at 35 to 40 percent depending on climate and how fast I want trace. In humid weather I drop toward 35 because the extra water takes longer to evaporate and the bar stays soft. In dry winter I go 40 or even 42 to keep the mix fluid long enough to pour.
That's the full template in one batch. Write it down. Change one thing — swap the castor for shea butter, for example — and the numbers tell you exactly what to adjust instead of you guessing. The whole calculation takes about three minutes if you know your SAP values by heart, or ten minutes the first few times while you're looking them up.
Get the Full Details
Where the simple template breaks down
The basic four-column format assumes you're using pure oils and solid NaOH. It does not handle lye discounts per ingredient, superoat calculations with potassium hydroxide, or additives that absorb lye like honey, milk, or clay. If you're doing a recipe with oat milk replaced for water, the water percentage shifts because the milk solids absorb lye differently than pure water. The template will still give you a number, but that number will be slightly off, usually producing a bar that's a touch harsher than expected. Another edge case I ran into recently: I was making a batch with a high percentage of castor oil — about 25 percent of the total — and the trace snapped faster than usual. The template said everything was fine chemically, but the viscosity behavior was completely different. Castor oil accelerates trace in cold process, sometimes within thirty seconds of mixing. I learned to mix the lye solution and oils separately, then combine slowly while watching the clock, rather than pouring everything at once like I would with a standard olive-coconut blend. This isn't in the template. It's the kind of thing you only learn from blowing up a batch or nearly losing your arms to a pot of instant gel-phase soap. The template also doesn't account for fragrance load. If you're using 3 percent fragrance oil relative to total oil weight, that's 15g in a 500g oil batch. Some fragrances accelerate trace, some cause separation, and vanilla-containing ones discolor the bar dark. The math stays the same, but your technique changes. Fast-accelerating fragrances mean you work quicker or use a stick mixer sparingly. Separating fragrances mean you might need to overblend or add a thickener like starch. None of that lives in the spreadsheet.
A better alternative if you want to skip the math
If the SAP table and manual multiplication feel like too much friction, there are online calculators — SoapCalc, Bramble Berry's calculator, the BBCo soap calculator — that do the same thing. They're built on the same template, just automated. The disadvantage is you lose visibility into individual ingredient contributions, which is exactly what the manual template forces you to see. I'd recommend using a calculator to double-check your work, but keeping a manual copy for recipes you modify frequently. When something goes wrong, the spreadsheet tells you what changed. The calculator just gives you a new number and moves on. Beyond the four columns, I always add a notes section at the bottom with the date, the batch number, the cure length I planned (usually six weeks for a 500g batch at 38 percent water), and any deviations from the standard procedure. Did I use a water discount? Did I switch from distills to tap water? Did the room temperature deviate from normal? These details don't affect the math but they explain the outcome when you're comparing batch 22 to batch 47 and wondering why one is harder than the other. I also write down the mold dimensions. A 500g batch in a 9-by-3-inch loaf mold gives different slice thickness than the same amount in a silicone bun pan. The template doesn't calculate volume, but knowing your mold size helps you scale the recipe up or down without redoing the SAP math from scratch. Double the oils, double everything. Halve them, halve everything. The template scales linearly, which is one of its real strengths.
A note on safety and reproducibility
Never skip the gloves and goggles because the template says your numbers are small. Sodium hydroxide is sodium hydroxide whether you're using 72 grams or 7 kilograms. The template helps you avoid mistakes, but it doesn't replace PPE. I keep a bottle of white vinegar nearby — not to neutralize burns, because that's a myth and it generates heat — but to rinse my hands after handling dry lye. Water and soap is the proper first aid for NaOH exposure. Reproducibility is the whole point of the template. Six months from now when you find that one perfect batch and want to make it again, you shouldn't have to reverse-engineer the recipe from memory. Write everything down. The four columns plus your notes section will save you from starting over or, worse, repeating a mistake you already made.
