Rainbow Meadow Inc

Document Sample
Rainbow Meadow Inc Powered By Docstoc
					     Nom de la recette       Recette de savon liquide
           Measurements:        Metric                                                                                          Ration de gras/eau:       1.33
        Valeur INS Estimé        160                                                                                          Type de soda castuqiue Hydroxyde de Potassium

                                          Oil                                                     KOH
Huile                        Poids (gm)      Vol (ml)         %          INS         SAP       Poids (gm)          Huile de sur-graissage                Poids (gm)
Olive                                800.0        871.5           53%          109     0.188         150.39        Glycérine, végétale                            50.0   0
Noix de coco                         600.0        649.4           40%          258     0.267         159.92
Jojoba                                50.0         57.9            3%           11     0.097           4.84
Ricin                                 50.0         51.8            3%           95     0.180           9.02




                    Total:          1500.0       1630.6           100%         165                   324.17                                     Total:            50.0

       Réduction de soude 0.0%                                                                                                    Total Sur-graissage            0.0%

                        Total Grams             MMS       Kilos          Grams                 Notes:
Huiles                            1500.0                             1     500.0
Autre ingrédients                   50.0                             0      50.0
Potasse caustique (KOH)            324.1                             0     324.1
Eau                               1127.8                             1     127.8
Total                             3001.9                             3       1.9
    Après sechage (4.3% water)    1958.4                             1     958.4
                                                                                               À ajouté au trace
Volume Total                        3082.5
                           Cost Oils Cost SF Oil Sum of Oils Sum of SF Oil
0    87200   800   0   0       0.0000    0.0000         800           0
    154800   600       0       0.0000                   600           0
       550    50       0       0.0000                    50           0
      4750    50       0       0.0000                    50           0
               0       0                                  0           0
               0       0                                  0           0
               0       0                                  0           0
               0       0                                  0           0
               0       0                                  0           0
               0       0                                  0           0
               0       0                                  0           0
               0       0                                  0           0
               0       0                                  0           0
0                              0.0000    0.0000       1500            0
       Nom de la recette Recette de savon liquide

        Échelle de la recette 2.00

Huile                          Poids (gm)    Vol (ml) %               SAP       Poids (gm)               Huile de sur-graissage            Poids (gm)
Olive                                 1600.0   1742.9           53%      0.1880     300.77               Glycérine, végétale                       100
Noix de coco                          1200.0   1298.7           40%      0.2665     319.85
Jojoba                                 100.0     115.9           3%      0.0968        9.68
Ricin                                  100.0     103.6           3%      0.1804      18.04




                      Total:         3000.0    3261.1       100%                    648.34                                        Total:          100

         Réduction de soude 0.0%                                                   Total Sur-graissage                             0.0%

                               Total Grams              Kilos         Grams                   Notes:
Huiles                                3000.0                      3          0.0
Autre ingrédients                      100.0                      0        100.0
Potasse caustique (KOH)                648.3                      0        648.3
Eau                                   2255.6                      2        255.6
Total                                 6003.9                      6          3.9
Après sechage (4.3% water)            3916.9                      3        916.9

Volume Total                         6165.0
0.0000   0




         0
                        Gras / Huile                       Hydroxyde de Sodium           Hydroxyde de Potassium        INS       Gravité     Idoine Value          INS Computation
                                                                    NaOH                           KOH                          Spécifique       Bas        High     Dr. Bob's INS   Est. INS
Abricot, noix                                                       0.1350                        0.1894               100        0.940            92        108          91           100
Amande, douce                                                       0.1360                        0.1908                99        0.949            93        105          97            99
Arachide                                                            0.1360                        0.1904                93        0.900            93         93          99            93
Argan                                                               0.1360                        0.1920                99        0.908            99         99                        99
Avocat                                                              0.1330                        0.1866                99        0.915            82         90          99            86
Babassu, noix de brésil                                             0.1750                        0.2450               230        0.900            10         20         230            15
Beurre de cacao                                                     0.1370                        0.1922               157        0.968            33         44         157            39
Beurre de karité                                                    0.1280                        0.1796               116        0.912            55         71         116            63
Beurre de Kokum                                                     0.1357                        0.1900               154        0.890            32         40         154            36
Beurre de mangue                                                    0.1371                        0.1923               120        0.910            43         50         120            47
Beurre de muscade                                                   0.1160                        0.1624                46        0.995            40         52                        46
Beurre de sal                                                       0.1306                        0.1832               145        0.900            35         43         145            39
Beurre d'Illipe                                                     0.1385                        0.1940               145        0.890            43         55         145            49
Bourrache                                                           0.1357                        0.1900                50        0.900           130        150                       140
Camelina                                                            0.1333                        0.1870                37        0.970           140        160         37            150
Camellia (Huile de grain thé vert)                                  0.1362                        0.1910               108        0.910            78         88                        83
Canola                                                              0.1324                        0.1856                56        0.916           110        126         56            118
Carthame                                                            0.1360                        0.1904                47        0.919           150        150         47            150
Cire d'abeille                                                      0.0690                        0.0968                84        0.966             8         11         84             10
Cire de candelilla                                                  0.0381                        0.0535                32        0.982            19         24                        22
Cire de carnauba                                                    0.0611                        0.0856                76        0.982             7         14                        11
Colza                                                               0.1240                        0.1736               113        0.915           105        120          56           113
Ému                                                                 0.1359                        0.1906               128        0.921            40         80         128            60
Germe de blé                                                        0.1310                        0.1834                58        0.915           115        140          58           128
Glycérine, végétale                                                 0.0000                        0.0000                 0        1.263             0          0           0             0
Grain de chanvre                                                    0.1345                        0.1883                39        0.927           160        170          39           165
Grain de citrouille                                                 0.1331                        0.1863                67        0.915           110        130          67           120
Grain de coton                                                      0.1386                        0.1940                89        0.915           112        112          89           112
Grain de lin                                                        0.1357                        0.1899                -6        0.915           205        205          -6           205
Grain de pavot                                                      0.1383                        0.1936                54        0.900           140        140                       140
Grain de sésame                                                     0.1330                        0.1866                81        0.921           105        115                       110
Grain de tournesol                                                  0.1340                        0.1876                63        0.923           136        136          63           136
Gras de beurre, Chèvre                                              0.1672                        0.2340               204        0.900            30         30         204            30
Gras de beurre, Vache                                               0.1619                        0.2266               191        0.900            30         30         191            30
Grenoble                                                            0.1353                        0.1894                45        0.924           140        150          45           145
Jojoba                                                              0.0690                        0.0968                11        0.863            80         85          11            83
Kapok                                                               0.1461                        0.2049               108        0.910            85        110         108            98
Kukui                                                               0.1350                        0.1890                24        0.900           160        175          24           168
Lanoline                                                            0.0741                        0.1040                83        0.938            17         29          83            23
Limanthes                                                           0.1207                        0.1690                77        0.900            92         92          77            92
Macadamia                                                           0.1390                        0.1946               119        0.900            73         79         119            76
Mais                                                                0.1360                        0.1904                69        0.900           103        130          69           117
Neem                                                                0.1380                        0.1940               124        0.900            84         94         124            89
Noisette                                                            0.1356                        0.1898                94        0.900            90        103                        97
Noix de brésil                                                      0.1750                        0.2450               230        0.900            10         20         230            15
Noix de coco                                                        0.1900                        0.2665               258        0.924            10         10         258            10
Noix de Pistache                                                    0.1328                        0.1863                92        0.900            93         96          92            95
Noyau d'abricot                                                     0.1350                        0.1890                91        0.900            92        108          91           100
Noyau de pêche                                                      0.1370                        0.1920               113        0.900           108        118          96           113
Olive                                                               0.1340                        0.1880               109        0.918            79         95         109            87
Onagre bisannuelle                                                  0.1357                        0.1900                30        0.900           150        170          30           160
Palme                                                               0.1410                        0.1978                51        0.915            45         57         145            51
Palme, beurre (hydrogéné)                                           0.1560                        0.2184               183        0.915            37         45         183            41
Palme, noyau (palmiste)                                             0.1560                        0.2184               183        0.915            37         45         183            41
Palme, Stéarique                                                    0.1410                        0.1978               157        0.915            37         45         157            41
Pépin de raisin                                                     0.1265                        0.1775                66        0.927           125        137          66           131
Perilla                                                             0.1369                        0.1916                -5        0.900           185        208          -5           197
Ricin                                                               0.1286                        0.1804                95        0.965            82         90          95            86
Rose musquée                                                        0.1378                        0.1930                16        0.900           170        185          16           178
Sésame                                                              0.1330                        0.1862                81        0.921           105        115          81           110
Shortening (vég.)                                                   0.1360                        0.1904               115        0.900            90         95         115            93
Son de riz                                                          0.1280                        0.1792                70        0.900           110        110          70           110
Soya                                                                0.1350                        0.1890                61        0.900           124        132          61           128
Tamanu                                                              0.1357                        0.1900                82        0.900           108        108          82           108
Si vous ne retrouver pas une huile sur cette liste vous aimerait qu'on la rajoute, veuillez nous faire signe. http://www.savonpopulaire.ca
HUILES ESSENTIELLES
Anis                                                                0.0000                        0.0000
Basilic doux                                                        0.0000                        0.0000
Bergamote                                                           0.0000                        0.0000
Benjoin, Teinture de                                                0.0000                        0.0000
Bois de cèdre                                                       0.0000                        0.0000
Bois de rose                                                        0.0000                        0.0000
Cannelle, feuille                                                   0.0000                        0.0000
Camomille, 10%                                                      0.0000                        0.0000
Camphre blanc                                                       0.0000                        0.0000
Citron (essence)                                                    0.0000                        0.0000
Citronnelle                                                         0.0000                        0.0000
Clous de girofle                                                    0.0000                        0.0000
Carotte, grains                                                     0.0000                        0.0000
Eucalyptus                                                          0.0000                        0.0000
Eucalyptus citronné                                                 0.0000                        0.0000
Géranium                                                            0.0000                        0.0000
Gingembre                                                           0.0000                        0.0000
Lavande 40/42                                                       0.0000                        0.0000
Lavande (vraie)                                                     0.0000                        0.0000
Lime, distillé                                                      0.0000                        0.0000
Menthe douce                                                        0.0000                        0.0000
Menthe poivrée                                                      0.0000                        0.0000
Myrte                                                               0.0000                        0.0000
Orange, douce (essence)                                             0.0000                        0.0000
Palmarosa                                                           0.0000                        0.0000
Pamplemousse rose (essence)                                         0.0000                        0.0000
Patchouli                                                           0.0000                        0.0000
Petit grain                                                         0.0000                        0.0000
Pin sylvestre                                                       0.0000                        0.0000
Poivre noir                                                         0.0000                        0.0000
Romarin                                                             0.0000                        0.0000
Sapin (aiguilles)                                                   0.0000                        0.0000
Sauge                                                               0.0000                        0.0000
Sauge Sclarée                                                       0.0000                        0.0000
Tangerine                                                           0.0000                        0.0000
Tea tree                                                            0.0000                        0.0000
Thé des bois                                                        0.0000                        0.0000
Vétiver                                                             0.0000                        0.0000
Verveine des Indes                                                  0.0000                        0.0000
Ylang ylang III                                                     0.0000                        0.0000
Vous pouvez rajouter les huiles essentielles en écrivant dans les lignes vides.
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000
                                                                    0.0000                        0.0000

ARGILES
Argile blanche                                                    0.0000                       0.0000
Argile Ghassoul (du Maroc)                                        0.0000                       0.0000
Argile verte                                                      0.0000                       0.0000
Argile rose                                                       0.0000                       0.0000
Argile rouge                                                      0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
AGENTS DE CONSERVATIONS
Extrait de pépins de pamplemousse                                 0.0000                       0.0000
Vitamine E MT-50                                                  0.0000                       0.0000
Oléorésine de romarin                                             0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
COLORANTS
Curcuma                                                           0.0000                       0.0000
Poudre de graines de moutarde                                     0.0000                       0.0000
Orange de mars                                                    0.0000                       0.0000
Oxyde jaune                                                       0.0000                       0.0000
Oxyde jaune de Naples (clair)                                     0.0000                       0.0000
Oxyde de fer noir                                                 0.0000                       0.0000
Oxyde rouge clair                                                 0.0000                       0.0000
Oxyde rouge foncé                                                 0.0000                       0.0000
Oxyde vert                                                        0.0000                       0.0000
Paprika                                                           0.0000                       0.0000
Poudre de cannelle                                                0.0000                       0.0000
Poudre de stévia                                                  0.0000                       0.0000
Terre de Sienne brulée                                            0.0000                       0.0000
Ultramarine Bleu                                                  0.0000                       0.0000
Ultramarine violet                                                0.0000                       0.0000
Violet de Mars                                                    0.0000                       0.0000
Dioxyde de titane                                                 0.0000                       0.0000
Oxyde de zinc                                                     0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
HERBES
Avoine                                                            0.0000                       0.0000
Cacao en poudre, BIO                                              0.0000                       0.0000
Calendula, fleurs BIO                                             0.0000                       0.0000
Camomille, fleurs BIO                                             0.0000                       0.0000
Grains de pavot BIO                                               0.0000                       0.0000
Hibiscus (pétales) BIO                                            0.0000                       0.0000
Lait de chèvre, en poudre                                         0.0000                       0.0000
Lait de noix de coco, en poudre BIO                               0.0000                       0.0000
Lavande, fleurs BIO                                               0.0000                       0.0000
Menthe douce feuilles BIO                                         0.0000                       0.0000
Millepertuis BIO                                                  0.0000                       0.0000
Ortie, feuilles BIO                                               0.0000                       0.0000
Pelure d'orange BIO                                               0.0000                       0.0000
Prêle, herbe BIO                                                  0.0000                       0.0000
Romarin, feuilles BIO                                             0.0000                       0.0000
Rose musquée (pétales) BIO                                        0.0000                       0.0000
Thym, feuilles BIO                                                0.0000                       0.0000
The vert BIO                                                      0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
AUTRE
Acide citrique                                                    0.0000                       0.0000
Acide citrique                                                    0.0000                       0.0000
Aloès gel, BIO                                                    0.0000                       0.0000
Aloès jus, sans agents de conservation BIO                        0.0000                       0.0000
Bicarbonate de soude                                              0.0000                       0.0000
Borax                                                             0.0000                       0.0000
Carbonate de calcium                                              0.0000                       0.0000
Cristaux de soude                                                 0.0000                       0.0000
Sel de la mer morte, FIN #1                                       0.0000                       0.0000
Sel de la mer morte, GRANULEUX #3                                 0.0000                       0.0000
Sel de la mer morte, LARGE #2                                     0.0000                       0.0000
Sel de mer GRANULEUX #4                                           0.0000                       0.0000
Sel de mer, #1 FIN                                                0.0000                       0.0000
Sel d'Epsom, GROS #3                                              0.0000                       0.0000
Sel rouge de Saskatchewan #2                                      0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
                                                                  0.0000                       0.0000
77   Limanthes   0.1207   0.1690   77   Limanthes   0.1207   0.1690   77   Limanthes   0.1207   0.1690   77
                 Miscellaneous Tables

Type de soda caustique   formula              offset                         Coût/Oz
Hydroxyde de Sodium      NaOH                               2                   1.00000
Hydroxyde de Potassium   KOH                                3                   1.00000


Conversions              Conv factor        Unites fluids       unit,petit   unit,éppler   unit, gros
Metric                             28.3750 ml                   gm           Grams         Kilos
Standard                             0.0352 Oz                  Oz           Ounces        Pounds

System de Measure        Metric

Decimal Places                            1

                         Convert to System Convert to Unit To Std
Conversion Factors                28.37500     1000            0.03524
intraConv Factor
        1000
          16
Hi, just a few notes about this template, how to use the workbooks created from
it, and the methods used for certain operations. There's a short FAQ at the
very end of this document.

Installation
------------
(These instructions are based on installing the template for use by MSExcel97,
on a machine running MSWindows95/98/ME/NT.)

The best place to keep this template is in your Templates folder. Your
Templates folder should be in the folder in which you installed Microsoft Office
or Microsoft Excel. For example: on my machine the Templates folder is
'C:\Program Files\Microsoft Office\Templates'.

Basic usage
-----------
Once you have saved the template to your Templates folder, here's how to create
new workbooks from it:
1) Start Excel
2) Click 'New' on the 'File' menu, which opens up the 'New' dialog box.
3) On the 'General' tab of the 'New' dialog, pick 'soapsheet.xlt'.
4) Click the OK button.
5) A new workbook called soapsheet1 should appear in Excel.

There are only two worksheets in this workbook that you need to be concerned
with when you play with your soap recipes. They are the sheets labeled "Recipe
Worksheet" (the one you're on by default when you create a new workbook from the
template) and "Scaled Version". The fields that may be changed on the Recipe
worksheet are:

-   Recipe Name
-   fields under the "Oil" heading
-   fields under the "Super-fatting Oil" heading
-   fields under the "Weight in Oz" headings for oils and super-fatting oils
-   Lye discount
-   Bar Size (Oz)
-   Oil to Water ratio
-   Water (if water is overridden, then auto calc will cease for water field)
-   Notes

Entering a recipe is as easy as picking oils from the drop-down list attached to
the Oil fields and entering the amount of each you want to use. Then, if you
want, enter super-fatting oils the same way, enter a lye discount, and perhaps
change the bar size. That's it. Everything else will be calculated for you.

The Scaled Version sheet allows you to take the recipe entered on the Recipe
sheet and scale it to whatever batch size you want. It shows everything from
the Recipe sheet except INS values, and includes the additional field "Scale
Factor". Scale Factor is the only field that may be changed on the Scaled
Version sheet, and is used as follows: to scale a recipe down to one half of its
original size, enter a Scale Factor of .5. To double a recipe, enter a Scale
Factor of 2. Enter whatever factor you want, 2 and .5 are just examples. You
get the idea.

Fluid Measurements
------------------
------------------
This spreadsheet will automatically compute the number of fluid ounces (or
milliliters) from the oil weights entered, assuming the specific gravity is
available for that oil.

Be aware, the same care must be taken measuring using liquid measurements.
If you normally measure weights to within a tenth of an ounce and want to
measure by volume, then the same precision is necessary (to the tenth of a
fluid ounce). The gradations of a normal measuring cup would not be
sufficiently accurate.

It is important to note that natural materials, such as oils and fats vary
greatly, depending on source and refinement methods. As such, the specific
gravity of your batch may differ from the table values. This will result
in inaccurate amounts even with accurate measuring. Make certain you have
at lease 3% superfatting in your recipes, to ensure an inaccuracy doesn't
result in lye heavy soap.

Measurement System
------------------
The measurement system (metric vs standard) can be changed by clicking the
"convert measurements" button. This can be done at anytime and will convert
all values from one system to the other. This allows you to enter metric or
standard (english) recipes then converting to your desired system. Conversion
is done via an Excel macro, so if you do not enable macros (some people don't
for fear of viruses) then conversion will not work. Conversion is the only
thing using the macros, so if you don't convert measurements, disabling
the macros will have no effect on your use of this spreadsheet.

SAP Values
----------
The SAP values used in calculating the lye are looked up from the SAP Values
worksheet. If you disagree with any of the values, please feel free to change
them. You may also change the names of any of the oils, just make sure you
change any references on the Recipe worksheet from the old name to the new name.
You may also add new oils, as long as you don't change the format of the SAP
Values worksheet (this is very important, as the lookup from the Recipe
worksheet depends upon the oil names and SAP values being in specific columns,
and within a certain range of rows). If you do add new oils, you can either
insert them into the list where you want or put them at the end; order is not
important, just don't go past row 200 or so. Note too that the oils in the drop
down list on the Recipe sheet appear in the same order as on the SAP Values
sheet, so if you don't insert new oils in alphabetical order, they won't appear
that way in the list either. To save any changes/additions you make to the SAP
Values worksheet, so that any new workbooks you create will include them, see
"Changing the template" below. Any additions need to include a price, even zero,
to prevent unexpected and inaccurate results from costing and change measurements
interaction.

Costing
-------
The spreadsheet will attempt to computer the cost of the soap you make by batch
and bar. It does this based on the Cost/Oz column in 'SAP Values' Oil table.
This is an example of how I would add a value: I bought a gallon of Coconut oil
for $9.90, so I entered '=9.90/128' into the cell E24 (in Coconut oil row of the
Oil table). The 9.90 is the price and the 128 is the ounces per gallon. In truth
the oil probably would actually weigh about 118 ounces, but this was a quick and
dirty estimate of cost. If you do this for a living, then you might want to factor
dirty estimate of cost. If you do this for a living, then you might want to factor
in specific gravity to convert liquid measurements to weights. eg: '=9.9/(128*F24)'.
F24, in this case, is the specific gravity of Coconut oil.

For costing, add any non-oil ingredient (except Lye) to the bottom of the
Oil table. There is no need to put in any values except the name and price.
Add specific gravity would help in computing volume measurements (useful
with glycerin), but wouldn't be used for most fragrances.

The price for Lye is set up the same way, in the 'Tables' Type_of_Lye table,
in the 'E' column. Eg: For a $3.79, 18 Oz bottle of Lye, click cell
E103, type '=3.79/18'.

Many of the price values enter were based on prices I looked up on the web. Some may
differ dramatically for you, depending on the amount and source of ingredients you
buy. If you want accuracy, modify the prices based on your purchases.

IMPORTANT: If pricing values are missing for an Oil you use, then that cost will
not be reflected in the reported cost. No warning will appear.

INS Values of Recipes
---------------------
The concept of INS values is borrowed from Dr Robert McDaniel's book,
"Essentially Soap." He in turn borrowed it from an unattributed source. In any
event, what he says is that an oil's INS value is based on its SAP value and
iodine value, and that a soap's INS is the weighted average of the INS values of
its constituent oils. What does that mean to you? Probably not much. The
important thing is that (as related by Dr Bob) the 'ideal' INS value to shoot
for when formulating a soap recipe is 160. Now remember: 160 is only the ideal.
Most recipes, even really excellent ones, won't be at an INS of 160. The
majority of the ones I've looked at are in the mid 140's or low 150's. The INS
value's real utility is as a sort of rough gauge of how well your recipe is
balanced. In other words, if your recipe's INS is much above or way below 160,
you might want to take another look at things.

INS Values of Individual Oils
-----------------------------
Many of the INS values for individual oils are borrowed from Dr Bob.
Specifically, the sheet calculates its own INS values based on the best SAP and
iodine values I could find, but where Dr Bob had a value, I defer to him. You
may note that a few of the oils listed have no INS. That's because Dr Bob
didn't list them, and I couldn't find iodine value numbers for them either. You
can still use those oils in your recipes, but they will be ignored in the INS
calculation for the recipe as a whole.

Canola versus Rapeseed oil
--------------------------
All canola oil is rapeseed oil, but not all rapeseed oil is canola. The reason
for this is that rapeseed oil normally has an erucic acid content of up to fifty
percent, while in order for an oil to be called canola, it may have an erucic
acid content of no more than two percent. In other words, canola is low erucic
acid rapeseed oil. What does this mean to you? Well, the erucic acid of
regular rapeseed is largely replaced by oleic and linoleic acids in canola,
which CHANGES THE SAP VALUE. I have yet to see a saponification chart, either
published or on the web, which takes this into account. Every one of them
treats rape and canola interchangeably, and lists the SAP of regular rape, even
though the availability of regular rapeseed oil to the average North American
consumer is limited at best. Is this dangerous? Since the SAP of rape is lower
though the availability of regular rapeseed oil to the average North American
consumer is limited at best. Is this dangerous? Since the SAP of rape is lower
than that of canola, no, not really. It just means you're building an
additional lye discount into any soap that uses canola. Which isn't much of a
problem unless your recipe is already at the extreme of superfatting, or you're
trying to make transparent soap. Bottom line: use canola for canola, and any
of the other names (ramic/rape/rapeseed) for regular rapeseed oil.

Lye calculation and rounding
----------------------------
Because most people don't have a way to accurately measure amounts smaller than
.1 ounces (well, I don't), the calculated amounts for lye and water are rounded
DOWN to the nearest .1 ounce. If you must round, rounding down is the only safe
way to go for lye, and unless you are making very small batches, a difference of
less than one tenth of an ounce should have very little effect. Note that you
may still enter amounts of oil to any level of precision you want, you just
won't ever get more than one decimal place of precision for the lye and water.

Water calculation
-----------------
The amount of water required is calculated based on the rule of thumb of one
pound of water for every three pounds of oils. There are other rules of thumb
out there, e.g. six ounces of water per pound of oils, ala the MMS calculator,
but I prefer the 1:3 rule.

To change the Oil to Water ratio enter the number of pounds of oil per pound of
water in the oil into the water ratio entry field (upper left hand of Recipe
worksheet).

The water value can be overridden (typed in manually), the rest of the calculations
will adjust, but this will prevent automatic calculation of water on this
sheet. If you always create a new worksheet from the template for each new
recipe, it will only effect the recipe you manually overrode.

After Cure calculation
----------------------
The After Cure weight is an estimate of the total yield of soap after most of
the water has cured out of your bars. It is based on the rule of thumb that
when your soap is done curing it will contain about 4% water, by weight.
The actual water percent will be calculated and appear in the After Cure line.

Default values
--------------
Every new soapsheet workbook will have a default lye discount of 0%, bar size of
4 ounces, Oil-Water ration of 3, scale factor of 1, and a oil & lye pricing info.
Any of these may be changed. To save your changes for future workbooks, see
"Changing the template" below.

Changing the template
---------------------
Here's how to change the template:

1) Create a new soapsheet workbook.
2) Make your changes/additions to SAP Values, bar size, lye discount, and/or
scale factor.
3) From the File menu, click Save As.
4) In the 'Save as type' drop-down list box on the 'Save As' dialog, choose
'Template (*.xlt)'. This choice should automatically change the 'Save in'
'Template (*.xlt)'. This choice should automatically change the 'Save in'
directory to your Templates directory.
5) In the 'File name' box of the 'Save As' dialog enter 'soapsheet' (the
original name), or whatever name you would like to use for the new version of
the template.
6) If you are replacing the template you started with in step one, you will be
prompted whether or not to overwrite the original. Click 'Yes'.
7) You're done.




Source of Information
---------------------

Information, such as missing Iodine values and Specific Gravities comes from the
38'th and 50'th Revisions of The Chemical Rubber Company Handbook of Chemistry
and Physics. The CRC handbooks has been considered the most authoritative
reference source for Chemistry or Physics to be found in a single book.
reference source for Chemistry or Physics to be found in a single book.




FAQ's
-----

1) What the heck is a '.xlt' file?

The .xlt, versus .xls, indicates that it is an Excel spreadsheet _template_, not
actually a spreadsheet. Every time you open it, it will create a new workbook in
Excel that you will be asked to name when you save (i.e. it's hitting the `New'
button to create a new workbook, but instead of being blank, it's got all of
this stuff from the template in it already). Normally templates are kept in the
Templates directory under the directory where Microsoft Office was installed.
For me, under WindowsNT 4.0, that defaults to c:\program files\microsoft
office\templates. Once the template is installed in the templates directory,
picking File>New off of Excel's menu will pop up a dialog for choosing a
template or wizard for the new workbook. Just pick 'soapsheet.xlt' from the
General tab, and you are good to go.

2) Why is the total effective lye discount greater than my lye discount, even
though I specified no superfatting oils?

3) Why is the total effective lye discount different for the scaled version of
my recipe?

The answer to these two questions has to do with the fact that lye amounts are
rounded down to the nearest tenth of an ounce, as detailed in "Lye calculation
and rounding" above. To answer the first question, by way of example: if you
specify a lye discount of 5%, which puts the lye amount at, for example, 7.39
ounces, the number 7.39 will be rounded down to 7.3, giving you a total
effective lye discount of almost 6.2%. That's a 1.2% higher discount, all
because you lost .09 ounces of lye to rounding. Are you with me so far? Now on
to question two... The reason why the total effective lye discount may be a
different value on the scaled version worksheet than the recipe worksheet is
that the amount being rounded off of the lye amount will almost certainly
change, and it will be a different proportion to the lye amount than in the
unscaled version. For example: say I have a recipe with a 5% lye discount,
which puts the lye amount at 8.66 ounces, which rounds down to 8.6, giving me a
total effective lye discount of around 5.7%. Then I go to the scaled version
worksheet and double the batch size. Now my 5% discount puts the lye amount at
17.32 ounces, which rounds down to 17.3, giving me a total effective lye
discount of only about 5.2%. This effect can work the opposite way too, with
the total effective lye discount going up when you change the batch size. It is
even more pronounced when you scale down to smaller batch sizes, because even a
small amount rounded off is a proportionately larger change than in a large
batch. I hope that makes sense to everyone. There's no way around this without
taking a smaller lye discount than what you originally entered. Using metric
measures will drop the roundoff difference, making the entered and effective
lye discounts closer.

Using Metric measurements will show a smaller than expected difference in
effective lye discount. It is assumed that by measuring in grams higher
accuracy will be attained (a gram is equal to 1/20 of an ounce).
oks created from
rt FAQ at the




e by MSExcel97,


r. Your
 Microsoft Office
older is




's how to create




 be concerned
 labeled "Recipe
workbook from the
 on the Recipe




atting oils



water field)


 list attached to
  Then, if you
nt, and perhaps
lated for you.

on the Recipe
verything from
 field "Scale
 the Scaled
o one half of its
 enter a Scale
 examples. You
 ounces (or
c gravity is


asurements.
nd want to
 tenth of a



d fats vary
he specific
ll result
n you have
cy doesn't




licking the
will convert
er metric or
em. Conversion
e people don't
is the only
isabling




he SAP Values
 free to change
ake sure you
 to the new name.
at of the SAP
e Recipe
ecific columns,
ou can either
; order is not
 oils in the drop
e SAP Values
hey won't appear
 make to the SAP
lude them, see
price, even zero,
hange measurements




ou make by batch
s' Oil table.
n of Coconut oil
ut oil row of the
 gallon. In truth
s was a quick and
ight want to factor
ight want to factor
eg: '=9.9/(128*F24)'.


tom of the
e and price.
s (useful


of_Lye table,



 on the web. Some may
 of ingredients you


hen that cost will




d source. In any
SAP value and
the INS values of
t much. The
value to shoot
s only the ideal.
 160. The
 150's. The INS
ur recipe is
r way below 160,




the best SAP and
er to him. You
ause Dr Bob
them either. You
red in the INS




ola. The reason
nt of up to fifty
have an erucic
la is low erucic
ic acid of
s in canola,
n chart, either
one of them
gular rape, even
North American
 of rape is lower
North American
 of rape is lower

isn't much of a
tting, or you're
canola, and any




nts smaller than
ater are rounded
 is the only safe
, a difference of
  Note that you
nt, you just
 lye and water.



 thumb of one
 rules of thumb
MMS calculator,


oil per pound of
and of Recipe


 of the calculations
er on this
or each new




 after most of
of thumb that
y weight.
fter Cure line.



f 0%, bar size of
 lye pricing info.
orkbooks, see




count, and/or


alog, choose
e 'Save in'
e 'Save in'

eet' (the
new version of

ne, you will be




es comes from the
ok of Chemistry
horitative
t _template_, not
a new workbook in
itting the `New'
's got all of
 are kept in the
was installed.
microsoft
tes directory,
hoosing a
xlt' from the


discount, even


aled version of


lye amounts are
Lye calculation
xample: if you
 example, 7.39
 a total
scount, all
e so far? Now on
ount may be a
 worksheet is
 certainly
 than in the
ye discount,
8.6, giving me a
scaled version
he lye amount at
ctive lye
 way too, with
atch size. It is
, because even a
n in a large
ound this without
 Using metric
and effective


ference in
s higher
                                                                   Soapsheet.xlt
                                                  A soap recipe spreadsheet template, written for Excel97.

                                                      Author: Chris Mathes (navig8rs@hotmail.com)
                                                                      Version: 1.3

  I wrote soapsheet.xlt because doing lye calculations by hand is cumbersome, time consuming, error prone, and not conducive to
 playing with recipes. Additionally, I was dissatisfied with the inconvenience and lack of utility of the available on-line lye
                          together my own tool that was portable, easy to use, and did what I wanted. I sincerely hope you like it.

I welcome any feedback you have at the email address above. If you would like to be notified when a new version of soapsheet
new stand-alone application version is done (many, many new features), send me an email and I will put you on the list. I shoul
                                          as yet unnamed application will also be free, and freely redistributable.

                                                                         Notice:
                     This template is an original work of Chris Mathes, but may be freely redistributed under the following conditions:

                                                  1) This notice must remain attached and unchanged.
     2) You may not charge people for soapsheet.xlt, other than to recoup no more than your costs for physical distribution (e.g.
                                                   3) Blah, blah, blah, blah. Now go make some soap!

                                                                      Happy Soaping,

                                                                           Chris
prone, and not conducive to tweaking or otherwise
             -line lye calculators, so I decided to put
 sincerely hope you like it.

new version of soapsheet.xlt is released, or when the
 t you on the list. I should also mention that the new,




under the following conditions:


 hysical distribution (e.g. media and/or postage).

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:9/11/2012
language:French
pages:26