# Soap Calcs - OpenDrive by niusheng11

VIEWS: 0 PAGES: 8

• pg 1
21    oz fat                               70% lard
15% beef tallow
15% olive oil

Input total amount of fat a
SAP value                            contributing fat. It's set up to
14.7   oz lard              0.138
calculates the amount of each
3.15   oz beef tallow      0.1405
the second tab, depending o
3.15   oz olive oil         0.134
0    oz
0    oz                                                        The spreadsheet calculates th
based on the 6/16 ratio that
to change it to something
7.875   oz water             0.98      cups water
formula in cell A13. It also c
cups, since volume can be ea
2.89   oz NaOH                                                                         mass.
9.5%   Lye discount
needed, either NaOH or KOH, d
you enter into cell B15 and
2.62   oz NaOH (actual)     4.75      Tablespoons lye         discount. Only use the lye conv
=                                    tablespoons if you have th
4       Tablespoons +
2.25      Teaspoons

Conversion for our powdered NaOH
0.551 ounces per T NaOH
1.814 T per ounce NaOH
KEY:
Input
Calculation Output

ut total amount of fat and percentage and type of each
buting fat. It's set up to take up to five types, but you can
dd more by inserting more rows. The spreadsheet then
ates the amount of each oil and looks up the SAP value in
second tab, depending on what you entered into cell B15.

spreadsheet calculates the amount of water
on the 6/16 ratio that we like. If you want
change it to something else, just edit the
ula in cell A13. It also converts the water to
since volume can be easier to measure than
mass.
eadsheet also calculates the amount of lye
either NaOH or KOH, depending on what
enter into cell B15 and A17 for the lye
Only use the lye conversions from oz to
espoons if you have the same ratio!
Table shamelessly imported from: http://www.thesoapkitchen.co.uk/guide_to_sap_values.htm

SAP values given in oz NaOH or oz KOH per oz oil (or g NaOH--or KOH--per g oil).
NaOH       KOH
Almond (Sweet)           0.136     0.191
Apricot kernel           0.135     0.189
Arachis                  0.136     0.191
Babassu                  0.175     0.245
Beef Tallow              0.1405    0.197
Borage Oil               0.136     0.191
Brazil Nut Oil           0.175     0.245
Butterfat (cow)          0.1619    0.227
Butterfat )goat)         0.1672    0.235
Camelia oil              0.136     0.191
Castor                   0.1286    0.180
Chicken fat              0.1389    0.195
Chinese Bean             0.135     0.189
Cocoa Butter             0.137     0.192
Coconut (refined)         0.19     0.267
Coconut (virgin)         0.1946    0.273
Cod Liver Oil            0.1326    0.186
Coffee Seed Oil           0.13     0.182
Colza                    0.124     0.174
Corn (Maize)             0.136     0.191
Cottonseed               0.1386    0.194
Deer Tallow              0.1379    0.193
Earthnut                 0.136     0.191
Emu oil                  0.135     0.189
Evening Primrose         0.136     0.191
Flaxseed                 0.1357    0.190
Gigely Tree              0.133     0.187
Goat Tallow              0.1383    0.194
Goose Fat                0.1369    0.192
Grapeseed                0.1265    0.177
Grapefruit Seed Oil      0.129     0.181 range: 0.123-0.135
Hazelnut                 0.1356    0.190
Hemp Seed                0.1345    0.189
Herring Oil              0.136     0.191
Illippe Butter           0.136     0.191
Jojoba                   0.069     0.097
Kapok                    0.137     0.192
Katchung                 0.136     0.191
Kokum Butter             0.134     0.188
Kukui Nut                0.135     0.189
Lard                     0.138     0.194
Linseed                  0.1357    0.190
Loccu                    0.134     0.188
Mango Butter             0.135     0.189
Mink Oil                0.14    0.196
Moringa                0.136    0.191
Mustard Seed Oil       0.1241   0.174
Myrtle oil             0.069    0.097
Neat's Foot Oil        0.1359   0.191
Neem                   0.1387   0.195
Niger Seed Oil         0.1355   0.190
Nutmeg Butter          0.116    0.163
Olive Oil              0.134    0.188
Olive Butter           0.185    0.260
Palm Kernel            0.156    0.219
Palm                   0.141    0.198
Peanut                 0.136    0.191
Perilla                0.1369   0.192
Pistachio Oil          0.135    0.189
Poppy Seed Oil         0.1383   0.194
Pork Tallow            0.138    0.194
Pumpkin Seed           0.1331   0.187
Ramic                  0.124    0.174
Rape Seed (Canola)     0.124    0.174
Rice Bran              0.128    0.180
Ricinus                0.1286   0.180
Safflower              0.136    0.191
Sardine Oil            0.135    0.189
Sesame Seed            0.133    0.187
Sunflower              0.134    0.188
Shea (Karite) Butter   0.128    0.180
Sheeps Tallow          0.1383   0.194
Soybean                0.135    0.189
Sunflower              0.134    0.188
Tung                   0.1377   0.193
Vegetable Shortening   0.136    0.191
Venison Fat            0.139    0.195
Walnut                 0.1353   0.190
Wheatgerm              0.131    0.184
Beeswax                0.069    0.097
Carnauba Wax           0.069    0.097
Lanolin                0.0741   0.104
e_to_sap_values.htm

g oil).
Olive Oil Fatty Acid Composition from: http://www.chempro.in/fattyacid.htm
Myristic               Palmitic              Stearic
C14:0                  C16:0                 C18:0
min percentage                            0.1                       7                   1
max percentage                            1.2                      16                   3
typical?                    0.8                      10                   3
C (12.011)                     14                      16                  18
H (1.0079)                     26                      30                  34
O (15.9994)                       2                       2                   2
Fatty Acid MW                  226.358                 254.412             282.465
Glyceride                  41.073                  41.073              41.073
NaOH MW                     39.997
KOH MW                    56.105
Olive Oil "MW"         mol/1 g
typical?                          873.1898128             0.001145226

Mol NaOH                                   3
Mol KOH                                    3
SAP (mg NaOH/g oil)                    137.4
SAP (mg KOH/g oil)                     192.8
SAP (oz NaOH/oz oil)                   0.137      It's in the
SAP (oz KOH/oz oil)                    0.193     range! Yay!
Listed SAP Value                     187-196
pro.in/fattyacid.htm
(Eicosanoic)         20:0 means 20-
Oleic               Linolenic             Linoleic             Arachidic             carbon chain
length with zero
(C18:1)             (C18:3)               (C18:2)              (C20:0)
double bonds
65 ----                                   4                 0.1
80 ----                                  10                 0.3
78                  0                    8                 0.2   100
18                 18                   18                  20
32                 28                   30                  38   Used values
2                  2                    2                   2   in range to
280.450            276.418              278.434             310.519     sum to
41.073             41.073               41.073              41.073      100%
:0 means 20-
arbon chain
gth with zero
ouble bonds

To top