Soap Calcs - OpenDrive by niusheng11

VIEWS: 0 PAGES: 8

									   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
                                                                      add more by inserting mo
  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.
                                                                The spreadsheet also calculates
  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
Avocado                  0.133     0.187
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
Macadamia Nut            0.139     0.195
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
                         (Tetradecanoic)        (Hexadecanoic)        (n-Octadecanoic)
                         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