Worksheet For Soap Making Simple

Getting Your Soap Math Right Without Losing Your Mind

Most people who start making soap at home get tripped up by the spreadsheet part, not the actual pouring and cutting. I spent about three years batching recipes incorrectly before I finally accepted that a proper worksheet matters more than anything else. The problem isn't that the math is hard. It's that everyone does it slightly differently and you end up with two versions of the same calculation that somehow give different results. A

Worksheet For Soap Making Simple

version is basically a structured table where you list every oil, note its SAP value, calculate lye weight, and track water percentage all in one place. That's it. Nothing fancy. I've seen people spend an hour customizing elaborate Google Sheets with conditional formatting and formulas that auto-convert to metric. None of that helps if you don't know what SAP means or why your lye discount changed from batch to batch. Here's what I actually do. I keep a single sheet with columns for oils, percentages, total batch weight, SAP value per oil, lye amount, water amount, and superfat. I use a standard SAP table from SoapCalc or the Lye Calculator at Canadian Homemade Soap Supplies. The numbers come from empirical testing done by the National Soap and Toiletry Foundation in the 1990s, so they're pretty reliable for most common oils. Coconut oil is 0.190, olive oil is 0.135, castor is 0.128. You multiply each oil's weight by its SAP to get the exact sodium hydroxide needed, then apply your superfat percentage to the total.

The tricky part nobody talks about is that SAP values shift when you change water concentration. Most people assume the water-to-lye ratio doesn't affect the saponification math. It doesn't directly, but it changes how fast the reaction runs and whether you hit trace before or after you expect it. I once made a batch where my worksheet said everything was fine, but the soap thickened in twelve minutes instead of forty-five. Turned out I'd miscalculated the water because I was using the lye solution weight instead of just the pure water weight in my formula. I had been adding the dissolved lye mass into the water column. That added about eighty grams of extra liquid to a two-kilogram batch and thrown off my entire trace window. Workaround was simple: I stopped calculating water as a percentage of total oils and started using a fixed 33 percent water-to-lye ratio for everything, which cut down the variables I had to track. Another thing that catches people is the difference between weight percent and volume percent when you're working with additives. Honey, milk, purees, essential oils. If your worksheet doesn't have a separate column for additives and you treat them as part of the base oil weight, your superfat calculation will be wrong and your soap will be softer than expected. I run a dedicated additives row now. Anything over fifty grams goes into its own line with a note about how it affects trace and scent retention. Essential oils are the worst offenders here. Lavender can accelerate trace significantly in cold process, and if your worksheet doesn't flag that, you'll be scrambling to pour before it sets up. There's also the issue of tropical oils. Coconut oil at sixty percent or higher in your recipe will make a hard bar, but it also pulls moisture from skin. Most beginners don't realize that the SAP value for coconut oil changes depending on whether you're using fractionated or virgin grade. I switched to tracking both separately after I got inconsistent hardness readings. Fractionated coconut runs slightly softer because the lauric acid content is lower, and your worksheet should reflect that distinction if you care about bar quality.

The real limitation of any soap making worksheet is that it can't predict your environment. If you're working in a cold garage in January versus a humid kitchen in July, the same formula will behave differently. Cold temperatures slow trace and can cause soda ash on the surface. High humidity makes lye water absorb moisture from the air before you even mix it with oils. I keep a small thermometer and hygrometer next to my mixing station and adjust water percentages by plus or minus five percent based on conditions. The worksheet becomes less useful once you start making environmental corrections because you're constantly modifying the base numbers. If you want something actually simple, here's my current setup. Column A lists each oil with its percentage of total recipe weight. Column B is the weight in grams for a two-kilogram batch. Column C is the SAP value. Column D is the lye needed. Column E is the lye water amount at 33 percent water-to-lye. Column F is superfat percentage, usually five percent for cold process. Column G tracks any additives with notes. That's it. No conditional formatting. No macros. Just seven columns and a printed copy in a binder next to my scale. For people who want a downloadable version, I use a basic Excel template I modified from one originally shared on the Soapmaking Forum around 2018. You can find similar versions by searching "soap making worksheet Excel" and picking one that has fixed SAP cells you can't accidentally overwrite. The worst thing that can happen is someone builds a template with locked cells in the wrong places and spends twenty minutes trying to figure out why their numbers won't edit.

Don't bother building a complex system. Build one that works for your typical batch size and stick with it. I've watched people redesign their spreadsheets every six months chasing some optimization that never actually improved their soap. The numbers are the numbers. The skill is in reading trace and knowing when to stop mixing.