Why I started tracking everything instead of just guessing
I spent about four years making soap without any kind of record system. I wrote recipes on scraps of paper, in notebooks, sometimes just memorized them. Then I'd make the same batch three months later and get completely different results because I forgot whether I used palm oil or coconut at 30% or 35%. That was frustrating. So I built a tracker. Not a fancy one. Just a spreadsheet that forces me to log everything before I can hit "calculate." It's a google sheets template I've been iterating on since late 2024. The core idea is simple: every recipe gets a row, every oil goes in its own column with percentage and weight, and lye/water are auto-calculated based on your target superfat. What makes it actually useful is the history tab, which records each batch with date, room temp, trace time, curing start, and the final hardness/sudsing scores from my sensory panel. After about 30 batches, you can see patterns nobody tells you about. Here's the thing nobody mentions when they talk about soap calculators: they solve for lye but they don't solve for your environment. The tracker has a column for ambient temperature and humidity on batch day. I didn't think that mattered much at first. Then I noticed that my shea butter batches consistently stuck at medium trace in October but barely moved toward trace in July, even though the lye solution was the same temperature. It wasn't the oils. It was the humidity. High humidity slows evaporation during gel phase, which delays hardening. Now I adjust my water discount and stick blend time accordingly.
One edge case that almost ruined a whole batch: I had a recipe with 40% castor oil and 20% tallow. The calculator said trace in about twelve minutes. It actually took forty-five. I thought I'd messed up the lye concentration and nearly dumped the whole pot. Turns out castor oil behaves differently when it's a high percentage relative to the total fat load. The tracker flagged it after I logged three similar high-castor batches with the same issue. The workaround is to pre-mix the castor with a portion of the heated oils and add it last, right before pouring. It cuts actual trace time from 45 minutes down to roughly 18. I wish I'd known that before I lost three hours and a full kitchen to stirring. The tracker also has a built-in SAP value table that pulls from the CosmeCalc database. Most free calculators use old or rounded SAP values, which can throw your lye calculation off by up to 0.5% of the total oil weight. That 0.5% is the difference between a mildly conditioning bar and one that dries out your hands. I learned that the hard way with a batch of 70% olive oil soap that felt like sandpaper until I recalculated with updated values and added 2% extra superfat. There are downsides to this approach. The spreadsheet gets slow after about 60 rows. You hit a point where manually entering data for every batch becomes tedious, and the formula recalculation takes five to eight seconds on a decent laptop. I switched to a lighter version that only keeps the last 30 batches in the main sheet and archives the rest to a separate tab. That cuts load time to under two seconds. Also, the tracker assumes you're working in grams. If you measure in ounces, everything shifts and the formulas break unless you add a conversion layer, which I haven't built yet.
If you want it, the link is docs.google.com/spreadsheets/d/1xK9mV2sT4pLqR7nE8wY — I'll keep it public. The password-protected version with the advanced batch comparison charts and the predictive trace-time estimator based on your past data is in the comments if you want it. No gatekeeping there, just a way to track who's actually using it versus downloading and abandoning it like half the people do. The most valuable feature isn't the calculation part. It's the column where you log what went wrong. "Too soft after 4 weeks," "seized at 8 minutes," "discolored to tan." That column is where you build your own personal reference library. After a year of honest entries, you'll know exactly how your specific kitchen, your water source, and your scale behave. No textbook can give you that. It's the only reason I keep coming back to this instead of switching to some app that promises to do it all.
Get the Full Details
