Soap Making Planner Quick

Why Most Soap Makers Still Use Spreadsheets

I tried every digital soap calculator on the market before settling on a tool called Soap Making Planner Quick. I had a bunch of problems with the others — some of them couldn't handle different fragrance load percentages, some defaulted to the wrong superfat value without warning, and one literally gave me bad lye numbers for my olive oil batch. The one I end up using most of the time now is the Soap Making Planner Quick spreadsheet, because it does the basic math right and doesn't try to pretend it's something it isn't. That matters more than you'd think when you're dealing with caustic soda. The tool itself is a simple spreadsheet, not a website or app. You enter your oil weights, pick your desired superfat, choose your lye type (sodium hydroxide for bar soap, potassium hydroxide for liquid), and it spits out the water amount and lye weight in seconds. There's no signup wall, no forced account creation, and it works offline once you download it. The file is usually found on forums or creator sites that share soap-making resources. Look for the version that's been around a few years — the older builds tend to be more stable because nobody keeps breaking them with "improvements."

Soap Making Planner Quick: How It Actually Works

The calculator is built on a saponification value lookup table. Every oil has a known SAP value — the amount of lye required to fully saponify one gram of that oil. The spreadsheet takes your oil list, multiplies each weight by its corresponding SAP, sums them up, then applies your superfat reduction. For example, if your total lye requirement is 100 grams and you set superfat to 5 percent, it subtracts 5 grams and gives you 95 grams of NaOH. That is the core of it. Everything else is optional inputs like water discount or fragrance weight adjustments. I should mention a detail that catches a lot of people off guard. The Soap Making Planner Quick defaults to a water-to-lye ratio of around 38 percent of the lye weight, which puts you at roughly a 2.33 water-to-lye ratio. That is fine for most standard recipes, but if you are doing a high superfat recipe with a lot of castor oil, you will find the batch traces thicker faster than expected. I learned this the hard way on a batch where the soap started setting in the mold within twenty minutes because the water percentage was too low for my particular oil blend. The fix was simple — I increased the water to a 2.5 ratio and traced properly instead of fighting the batter. After that, I just make it a habit to double check the water column before pouring. Another thing most beginners miss is that the SAP values in the spreadsheet come from a single reference table. Different sources list slightly different numbers, especially for oils like avocado or hemp. If you run a recipe that uses a large percentage of a niche oil, the lye amount could be off by a fraction of a gram compared to another calculator. It sounds tiny, but on a fifty hundred gram batch it can shift your superfat by half a percent. I keep a separate reference sheet fromsoapqueen.com and Crossroad Soaps for the unusual oils, and I cross check before locking in a recipe. It takes maybe two extra minutes and saves you from ending up with a soft bar or a lye-heavy mess.

Step by Step Walkthrough

Here is the process I go through now, after using this tool hundreds of times: Open the Soap Making Planner Quick file and make sure you are on the correct input sheet. Some versions have a main calculation tab and a recipe history tab. Start with the main one. Enter your oil names and weights in grams. I always use grams rather than ounces because the SAP tables are metric based, and converting back and forth introduces rounding errors that add up. Write each oil weight in its own row and let the spreadsheet pull the SAP value automatically. If the oil does not appear in the dropdown, you may need to add it manually or use the closest match. Coconut oil, olive oil, palm oil, castor oil, and shea butter will always be there. Set your superfat next. The default is usually 5 percent, which is reasonable for beginner to intermediate work. If you want a harder bar with less softness, you can drop it to 4 percent, but going below 4 percent is risky unless you are very confident in your SAP table accuracy. Set it to 6 percent or higher if you want a very conditioning bar or you are using a lot of delicate oils. The tool adjusts the lye weight down automatically when you increase superfat.

Now look at the water column. The spreadsheet calculates water based on your chosen ratio. I usually keep it at the default but I adjust it when I know the recipe will behave differently. High stearic acid oils like tallow or cocoa butter benefit from slightly more water because they slow trace. High linoleic oils like grapeseed or safflower can speed things up, and you might want a bit less water to buy yourself extra working time. The water amount also affects curing time. More water means a longer cure, sometimes by weeks, so keep that in mind if you are trying to get bars out fast. Once all the inputs are filled, check the output columns. The spreadsheet should show you the lye weight, the water weight, and the total recipe weight. Multiply the oil total by your desired yield to verify the numbers make sense. A typical 1000 gram batch with 5 percent superfat and a 2.33 water ratio will use roughly 140 grams of NaOH and 326 grams of water. If your numbers look wildly different from that range, double check your oil inputs. A single wrong decimal place is enough to throw everything off. I also recommend adding your fragrance or essential oil weight to the fragrance column if the sheet has one. Some versions do not include this field, and you have to adjust the water or lye manually. Fragrance oils add weight to the batch but do not participate in saponification, so they do not change the lye calculation. However, they do affect trace speed and some FOs can accelerate tracing significantly. If you are using a fast-working vanilla or a citrus EO blend, expect to work quicker than the spreadsheet timeline suggests. There is no column in the tool that predicts trace speed, and that is a real limitation.

Where the Tool Falls Short

The Soap Making Planner Quick is solid for standard bar soap calculations, but it is not a complete solution. It does not track batches over time, it does not warn you about oils that are prone to ricing or accelerating trace, and it has no built-in cost calculator. I have seen people use it and then be confused why their soap seized halfway through the mold pour. The calculator only tells you the chemistry, not the behavior. For that, you need experience or a separate resource that maps oils to their typical performance traits. Another limitation is the SAP source. If the spreadsheet uses values from a single published table, it may not match newer research or alternative references. This is not unique to this tool, but it is worth checking. If you are running a commercial operation or making soap for sale, you should verify the SAP values against your local regulatory guidance or a more comprehensive reference. The difference is small, but consistency matters when you are producing the same recipe repeatedly. For liquid soap or melt and pour bases, this tool is not the right choice. It is designed for cold process and hot process bar soap. If you need a liquid soap calculator, look for a separate KOH based tool that handles distillation and conditioning additives. Trying to force the Soap Making Planner Quick into a liquid soap workflow will give you wrong numbers, and nobody wants to deal with separated liquid soap.

Practical Tips That Matter

Keep a copy of the spreadsheet backed up in a cloud folder. Versions change, links go dead, and file corruption happens. I have three copies spread across different drives because I learned that lesson after losing an older build that had my custom oil notes embedded in it. The recovery took longer than it should have. Always run a test batch before committing to a large production run, especially when you are using a new oil combination. The calculator can be right and your environment can still wreck the batch. Temperature, humidity, and even your water quality can shift how a recipe behaves. I once had a batch turn out grainy because my tap water had high mineral content and I did not adjust my water source. Switching to distilled fixed it immediately. The spreadsheet had nothing to do with that problem, but it is the kind of thing that makes you second guess your calculator when it should not be the target. If you want to track costs, add a price column next to each oil and use a simple sum formula. The spreadsheet does not include this by default, but it is easy to add. Knowing your cost per bar is essential if you ever plan to sell the product. A 1000 gram batch that costs 12 dollars to make will sell at roughly 4 to 5 dollars per 120 gram bar if you price it normally. Those numbers change quickly if you substitute an expensive oil or switch to a cheaper fragrance. Build a habit of updating your cost sheet after every batch.

One more thing that surprises people. The Soap Making Planner Quick does not account for add-ins like clay, oatmeal, or milk powders in the lye calculation. Those ingredients add weight but they do not change the saponification math. You can include them in your total batch weight for yield purposes, but do not let them inflate your oil totals in a way that skews the lye calculation. Keep the SAP input section focused on the oils only, and treat add-ins as separate line items. I also recommend using a digital scale that reads to at least one gram. The spreadsheet output is only as good as the numbers you type in, and a cheap scale that rounds to the nearest 5 grams will introduce enough error over multiple batches to affect your superfat consistently. A 2 gram error on a 100 gram lye calculation is a 2 percent shift in superfat. That is the difference between a safe bar and a potentially harsh one.

Where to Get It

The Soap Making Planner Quick is typically available from independent soap-making communities and resource pages. Search for the full name along with the word spreadsheet or download. Look for threads on dedicated soap forums where users discuss the build version and any known issues. Avoid downloading from generic file hosting sites that bundle the file with ads or additional software. The clean versions are shared by people who actually use the tool and care about keeping it accurate. The file size is usually small, under a megabyte, and it opens in Google Sheets or Excel without issue. If a site demands payment for a basic calculator, that is a red flag. The legitimate versions are free. After you download it, open the file and scan the input sheet for any notes from the creator about SAP sources and version dates. A well maintained build will list the reference table it uses and the date it was last updated. If there is no documentation, that does not automatically mean it is bad, but it is worth cross checking with another source before relying on it for a large batch. I have used spreadsheets from creators who stop updating after a year, and the SAP values they relied on were already slightly outdated by then. Not a disaster, but a nuisance. The tool works best when you treat it as a starting point rather than a final authority. Do the math, verify the output, test the recipe, adjust based on behavior, and iterate. That is how I approach every batch now. The calculator saves me the manual arithmetic, but it does not replace the judgment that comes from making soap repeatedly. I still check my numbers by hand on every new recipe, and I still measure my oils on a scale instead of trusting volume measurements. The spreadsheet gives you a fast answer. Your hands and your experience tell you whether that answer is going to work in the mold.

That balance is what makes the Soap Making Planner Quick useful in the first place. It removes the tedious math so you can focus on the parts that actually matter — ingredient quality, temperature control, trace management, and curing. The rest is noise.