soapcalc


go to the
front page
  or  
close this
window

in addition to calculating the lye and water requirements for regular bar soap, this "online calculator" displays the requirements for liquid, cream, transparent (m&p), and whipped soap. it also display the ins and iodine contents as well as the soap properties derived from the fatty acids used (e.g. bar hardness; cleansing; conditioning; lather fluffiness and stability).
 
(for the complete calculator with graphical property analysis and formulation tables for the additional processes required by liquid, cream, and transparent (m&p) soaps, see the "offline calculator" below.)
 
offline calculator
i'd always done my own calculations when formulating soap recipes. i use microsoft's excel spreadsheet to do this. it just wasn't practical to include all of those features, (i.e. the various formulations table, etc.), with this online calculator. however, it occurred to me i could make the spreadsheet itself available. granted, to use it you must have access to excel v7.0 or later (or a free spreadsheet program like "openoffice" that reads excel documents). in any event, i'm making it available to anyone who wishes to use it.
 
the spreadsheet version of the calculator features a separate sheet for each of the different soap processes (bar soap, cream soap, and liquid soap) ...as of may '07, it's been updated to include a sheet for transparent soap. (note: there is no sheet for "whipped soap" since the calculations are the same as for regular "bar soap" ...only the process is different.)
note: this excel spreadsheet was written on a mac. although i have a pc, i don't have a pc version of excel, so i'm using "openoffice" to view the calculator on my pc ...to see if what is being displayed is what i intended. not quite. even though the calculator uses verdana, a font that is common to both platforms, the pc handles things a bit differently. some of the text overflows the intended cells. the best way to deal with this is to "select" the entire sheet and change the font to "microsoft san serif" -- (see "document protection" on the "help" page [of the calculator] regarding locking and unlocking the calculator.)
 
online calculator

about this calculator: this calculator dynamically updates with each oil selection or data entry. i've tested it on both mac and pc platforms with the current versions of explorer, firefox, netscape, and safari. (see help/tips for note on explorer compatibility with mac osx.) the automatic calculation is instantaneous, but could be a bit sluggish with safari (mac) v1.3 or earlier.
see "help / tips" for more tips on using the calculator ...although, it's all pretty straightforward.
oilquantity%
analysis
ins
iodine
hardness%
cleansing%
conditioning%
fluffy%
stable%
total oils soap typenaohkohwater
discount
lye water
regular bar soap
liquid soap
cream soap
transparent soap
whipped soap
© skinesscentuals 2008

if you would prefer to access this calculator from your desktop (instead of having to go online),
you can download your own personal copy. i've compacted all the relevant files into an archive.
click  or  for the appropriate download.
noteif you run windows xp or vista, and your browser is internet explorer,
read the doc "using internet explorer
".
usage tips

•  this calculator makes no designation between grams and ounces. the calculations are based on whatever you put in ...grams in, grams out, etc.
•  enter the oil amounts (and the discounts, if desired) in the red-colored entry cells. a blank is the same as a zero ("0") ...a blank blank cell will not generate a NaN (not-a-number) error.
•  after you enter the amount, hit the return or entry key to trigger the calculation. in some browsers (explorer and safari), however, hitting either of these keys instead re-loads the page. in this case, simply click the mouse anywhere outside the entry cell (after you've entered the amount), and it will trigger the calculation. this method works with any browser.
•  for the adjustment discount cells, simply enter the integer, not the % sign. if, as in the case of liquid soap, you want to enter a minus discount (i.e. an increase), simply enter the amount with a minus sign (e.g. "-10") -- no quotes. you can enter these amounts at any time -- before, during, or after the oil entries. the display will always reflect any discount selected.
•  the table [bottom portion of the calculator] displays lye and water results specific to the different soap types, (in accordance with those respective pages of this site).
•  the reset button clears all the entries. you could zero out the display by manually deleting all the oil quantities, but this button clears all the data, even the residual data in the "hidden cells".
•  the first 10 pull down buttons each contains a list of 39 oils. these oil are the ones represented on the "lye table" and "oil properties chart" ...and are consistent with the oils listed on the "downloadable spreadsheet" available above.
•  it was requested that i add some of the newer oils to the list. this is what prompted the re-working of the calculator ...hence the new layout. to facility the adding of these new oils and the possible inclusion of others, i listed these new oils in the last three pull down buttons.
•  also included [in each of these last three buttons] are three custom options for listing any oil that's not one the list(s). with these custom listings, however, you can only calculate for the lye [and water] amounts. the analysis table is disabled, since the calculation won't be taking into account the fatty acid content of the custom listing(s). for each custom listing, it is imperative that you supply the sap value ...to be entered in the "data entry table", which will be displayed if a custom entry is selected. if you should fail to supply the sap value, the calculator will alert you. if you also include the [optional) iodine value for the custom listing, the analysis table will display a value for the ins [and iodine].
•  microsoft has stopped supporting explorer for the mac osx ...the last version was v5.2.3. this still works with osx (panther and tiger ...i've not tested it with leopard), but it behaves irratically, so even though when i tested the calculator, it worked okay, i'd recommend against using explorer with mac osx (or earlier mac systems ...e.g. 8.1 thru 9.2), since you could never be completely sure of the results.