The Real Problem With Candle Making Calculations

Most people try to scale candle recipes by guessing. They figure one batch of soy wax in a four-ounce tin uses about eight ounces of wax, so a twelve-ounce jar must use twenty-four ounces. It works until it doesn't. The fragrance load shifts. The pour temperature changes. The wick size needs adjustment based on vessel diameter rather than total wax weight. You end up with tunneling, sooting, or a weak throw. I stopped trying to remember these relationships after a bad batch last spring. I was making thirteen-ounce coconut coir candles for a small wholesale order, and the fragrance dropout was brutal. Twenty percent scent load by weight, and the wax couldn't hold it. The tops came out weepy and oily. What actually fixed it was realizing I had been calculating fragrance based on total container weight instead of net wax weight, and the blend of 5150 wax with a small amount of stearic acid was fighting the load at room temperature.

Building a Comprehensive Candle Making Worksheet

The core of this is figuring out how much wax actually fits in your vessel. Most online calculators assume you're filling to the brim. Nobody does that in practice. You need to account for the wick volume, the space below the rim, and sometimes the difference between packed and poured wax density. Here's how I set it up. I track vessel dimensions, target fill height, wax type, fragrance load percentage, and dye amount. Then I calculate actual wax volume needed and work backward from there. The formula for wax weight goes like this: Vessel volume in cubic centimeters multiplied by the wax density factor gives you raw weight in grams. Soy wax runs about 0.85 to 0.90 grams per cubic centimeter depending on the blend. Paraffin is closer to 0.90. Beeswax sits around 0.96. Coconut blends vary widely by manufacturer. From there, fragrance is added as a percentage of the wax weight, not the total weight. A ten percent load on eight hundred grams of wax means eighty grams of fragrance oil. Not eighty grams out of eight hundred total. That distinction matters when you're formulating and it trips people up constantly. Wick selection is where everything falls apart if you skip the testing step. I size wicks based on vessel inner diameter and wax type, not the other way around. A two-inch diameter soy candle typically needs a CD-12 or CD-14 wick. A three-inch jar usually lands on a CD-18 to CD-25 range. But those are starting points. The actual test melt determines whether you move up or down. A practical note on wick testing: I run three candles per wick size at minimum. One shows the flame pattern, one reveals the melt pool width after two hours, and one demonstrates whether the soot level is acceptable. If you're only burning one test candle, you'll miss something. I keep a log sheet next to my pouring station. Vessel name, inner diameter, wax blend lot number, fragrance oil name and supplier, scent load percentage, dye amount, wick type and size, melt temperature at pour, room temperature that day, and the test burn results. It looks overkill until you're chasing down why batch four hundred and twelve burned differently than batch four hundred and eleven and you don't know which variable changed.

Where This Actually Breaks Down

A worksheet like this assumes you're working with consistent materials. That assumption fails hard when you're sourcing from multiple suppliers or buying in small quantities where you can't verify lot consistency. Fragrance oils from different batches can have different flash points and rates. Wax from a different supplier might pour at a different temperature and settle differently. My worksheet includes a column for supplier and lot number specifically because of this. The bigger limitation is that no worksheet replaces testing new combinations. You can calculate everything perfectly and still get a poor burn if the room temperature during curing is forty degrees different from your test environment. Humidity affects how some soy blends cool and set. Wind drafts during the test burn skew results. The worksheet captures the variables you control. It doesn't capture the ones you don't. If you're making custom orders where every vessel is different, the spreadsheet approach starts to slow down. I found that after about twenty unique vessel sizes in a single order run, I was spending more time calculating than actually making candles. At that point I switched to a pre-sized wick chart mapped to common vessel diameters and just verified each new size with one test burn before committing to a full order.

What to Track Beyond the Basics

The standard columns cover wax weight, fragrance weight, wick size, and melt temperature. But the things that actually predict problems are the ones people leave out. Cure time matters more than most makers admit. Soy candles need at least forty-eight hours, usually seventy-two to ninety-six, for the fragrance to fully bind. Testing a candle on day one gives you artificially weak throw data. I started noting cure start date and test burn date on every entry. It took me three weeks to realize my entire early portfolio was based on under-cured test results, which meant I had been recommending wicks that looked fine but would perform differently once properly cured. Pour temperature range is another one. Soy typically pours between one hundred seventy and one hundred eighty-five degrees Fahrenheit. Below that and you get sinking and poor adhesion to the container. Above that and you risk overheating the fragrance or causing wet spots. Paraffin pours hotter, usually in the one hundred ninety-five to two hundred fifteen range. Recording what temperature you actually poured at, not just what you aimed for, helps you spot patterns when tops crack or shrink. Curing environment temperature should be tracked too. I stopped noticing this until a customer complained about poor throw on winter orders compared to summer ones. The candles were identical in formula and wick selection. The only difference was the curing room was about fifteen degrees colder in January. Cold curing slows fragrance release significantly. Not a dealbreaker, but enough to matter for a client who expected consistent performance year-round.

File Format and Setup

I built mine as a Google Sheet because I can access it from the pour bench and update it between batches without transferring files. You could absolutely do this in Excel or Numbers. The structure is simple enough that any spreadsheet app works. The columns I use: date, order or batch number, vessel type, vessel inner diameter in inches, vessel height in inches, target fill percentage, calculated wax weight in ounces, wax blend lot, fragrance oil name and SKU, fragrance load percentage, fragrance weight in ounces, dye amount, wick type, wick size, melt temperature at pour, pour temperature, room temperature, cure start date, test burn date, melt pool diameter after two hours, flame height, soot observation, and notes. That's sixteen columns. It looks long until you've filled in a hundred rows and realize you can sort and filter by any of those variables to find patterns. Need to know what fragrance load your CD-16 wicks handled across all your recent tests? Filter by wick size. Want to compare pour temperatures across batches that had top cracking? Filter by that defect. I've seen people strip this down to five columns and call it a worksheet. You can do that. You just won't have the data when something goes wrong and you need to figure out why.