ࡱ> ma  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklnopqrstuvwxyz{|}~Root EntryFoo{u |Workbook(_VBA_PROJECT_CUR""* 0" |u |Ctls !,T L\pKathleen K Koch Ba= ThisWorkbook=I;v8@"1Arial1Arial1Arial1Arial1Arial1.Times New Roman1Arial1& Courier New1.@Times New Roman1.Times New Roman1Arial1.Times New Roman1.Times New Roman1Arial1Arial1QTahoma1QTahoma1& Courier New1.Times New Roman1.>Times New Roman1Arial1.Times New Roman1Arial1.Times New Roman1. Times New Roman1.?Times New Roman1.>Times New Roman1>Arial1. Times New Roman1hArial1Arial1Arial1>Arial1.>Times New Roman1>Arial1.Times New Roman1QTahoma1QTahoma1Arial1Arial1Arial1&  Courier New1&  Courier New1&  Courier New1& Courier New1 Arial1 Arial1 Arial1.Times New Roman1Arial1&  Courier New1.>Times New Roman1 Arial1.Times New Roman"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.00000.0 0.0% 0.000 "$"#,##0.00 0.00000"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\) #,##0.0000 0.000000 0.00000000 0.0000000                + )  , *      0   "8   0  4  4  8  4  !<    <  <  ( "<     "8 "4 "8 "  "    " "   0 "<  " "8  < "  (  #  4       @ @    @   @     #                            @  "      "   # "  #    !     # # #     "      #  ! # #       "  "  "  " !  "@ @  "@  "@ @  "  "@  "@  "@  "@  "@  "  "  "@ @  "  "@  "@  "@ @  "@  "@  "@ @  "@  "@  "  "  " @  " "  "  "  "  "@ @  "  "@ "  "  "  "  " "   '" ( ("  " )" $"@ # #   "  "  "-  "      # #  !   "       #   " " $"@ " ."  /"  "  " " ." . " ." "  " " " " ." "  " "      "  "@ @ )  "  "  "  "  @ @   "@ @  "@  "@  "@ @  "@    @ @ )  "    "     "@ @ + "@ @ + "@ @ + "@ @+  @ @ + "@ @ + "@ @ +  "@ @ +  "@ @ + 4# ,0" ,0"  @ @ +   @ @   @   @ $"@ @  "@  ,"@ @  ,"@  ,"@     @  5  5 5 ( 5 h  "  " "  @@  5"8@ @ 6 6# 6"@ @ "< "8 "  @    @ @ +   @ + "*@@ + ""@ + #" @ + "@@ + " @ +  #  "    "3  1" 2"  @ @    # #  Comma0 Currency0 Date Fixed Heading 1 Heading 2 Total`B SAP ValuesTablesRecipe Worksheet|BScaled Version AutoScaledFAQ & Release Notes About ! Bar_Size_Wt:!% Conversions; ) ConversionTable; # ConvertSystem:! ConvertUnit:CostCol$Decimal_Places: INSCol LengthConv:Lye:  LyeOffCol# Mold_Type;" MoldType; MoldVolume:Msystem: # NormalizeCost:! OilList;~" OilList2;~ Pi!<8" @  ;&   ;%   ;& % Type_Of_Lye;+ Type_Of_Lye_table;UnitsS+Vol_Conversion_Factor: "x87 ,)"Lbjk:M@=Lbjk:M !6}xڭVOSAږ*(GiM1AC$H/ԃGPh @bϞ0z@9x@%&*53f[j&t_~ٙٝ}}BD4~&@jA>?UBސZiA &8#Z$KHmP E{ ?7!*$CpF% sD}]MRfވ\ JZ^DZ2Pruu͵^'ꐮn-GM8`%:PO JVf5$䓨 Z%*F0"%S\,NOA3?+Az^N91S@Zn} -\f)Tn1Mg F/~!- R1NRN?ehB|yժ].wσ1,h| 1gG?C7\(^Mnj`e휪#Ρr;UTšZFGj˚o+WU;9r58|eUʕ|msb޹y\85z*؟M[uf޹+\8xqԚd(ێ8߿֣ij{l1/_^=u"I* Y)Gp=v NeϾ$i 4ʈ5CZ:E߸o'FMD(L-nf՞Bldo0AZ,}\Oy.-^%J-"YDs~ٯűtlCڸYTyK˳t#7%q.vŵ6)3  @@ @[[OilSodium HydroxidePotassium Hydroxide Almond, SweetArachisAvocadoBabassu, brazil nut Beef Hoof Brazil NutButterfat, CowButterfat, GoatCanolaCastor Chicken Fat Chinese Bean Cocoa Butter Cod-liverColzaCorn CottonseedEarthnutFlaxseed Goose Fat GrapeseedHazelnut Hemp Seed Java CottonKapokKarite Butter (Shea)Katchung Kukui NutLanolinLardLinseed MacadamiaMaizeMangoMinkMustard Neat's footNeem Nutmeg Butter Palm Butter Palm KernelPalm Palm, StearicPeanutPerilla Poppyseed PumpkinseedRamicRapeRapeseed Rice BranRicinus Safflower Sesame Seed Shea ButterShortening (veg.)SoybeanSunflower Seed Sweet Oil Tallow, bear Tallow, beefTallow, chinese vegetable Tallow, deer Tallow, goat Tallow, sheep TheobromaTungWalnut % of OilsSAPTotal:OilsLyeWaterTotalPoundsOunces Lye discount:Notes:Number of Bars Recipe Name: Scale Factor:FatSuper-fatting OilTotal Effective Lye Discount:EmuBorageBeeswaxEvening PrimroseAvocado Butter Pistachio Nut Rose Hip Seed Illipe Butter Mango Butter MeadowfoamApricot KernelCamelina Kokum ButterTamanuCamelliaOstrichINSkapokpeanutrapeseedsoybean neat's foot Peach Kernelcastor Iodine ValueHighLow Dr. Bob's INSEst. INScornCandelilla Wax Carnauba Wax Sal Butter cocoa butteroliveEstimated INS Value: ConversionsGramsOzgmMetricNaOH Measurements:Kilosml%KOH Type Of Lye Fluid unitsintraConv FactoroffsetformulaRecipe Fat/Water ratio: Type of Lye: StandardlinseedDecimal Places Conv factorMeasurement SystemCostBatchBarCoconut,refinedOliveCoconutManoi WheatgermConversion FactorsConvert to SystemConvert to Unit unit,small unit,Spelled unit, BigMiscellaneous TablesSodium HydroxidePotassium Hydroxide  INS Computation GravitySpecificCost perFO, Cucumber Melon FO, PlumeriaFO, Rose Petals EO, Anise EO, OrangeEO, EucalyptusGlycerin GlycerineNamesOther Sum of Oils Sum of SF OilOther Ingredients Cost Oils Cost SF Oil Tallow, sealLaurelTallow, rabbit Depot fat Human FatPig Fat Bear GreaseTallow Chaulmoogra BayTo StdPricePredicted YieldProfitper FO,Ocean FreshMargincentsWeight after yield & cure#bar price rounded up to the nearestPigment (candle) FO,Sea FreshEO, Cinnamon (leaf)EO, Cedarwood (Virginia) FO, Chocolate FO, Magnolia Stearic AcidStearin Bar Size(Oz)Mold DimensionsVol Conversion Factor Rectangular Cu Inch to OzRectangular moldCylindrical mold Width/Dia Mold Type Cylindrical Vol to Wt cnvIncmLengthtype: cm to grams In. to cm Len UnitsDepthEst Bar Hardness: EO, LemonEO, LimeEO, Peppermint EO, Tea Tree EO, Lavender, 40/40 Citric Acid Lactic Acid Box, PillOz/Unit Coconut Milk Coconut CreamBar Size(Oz) (post cure) Fragrances:Bar Size(Oz) (before cure)DWCP %:o 0.3 oz/lb for cinnamon leaf, clove, peppermint, spices, or possible irritants, and up to 0.7 oz/lb for citrus. .930-.937 .913-.919.91-.94.96-.97 .910-.929Usage rate for EOs, it's usually 0.5 oz/lb for EOs like lavender, geranium, tea tree, or other medium-strong ones. (Best recommendation is for 2% of total weight of recipe) ^was .3780 v was .6818;use instead: 133.376 oz water divided into 231 cubic inches0This is the volume conversion for standard TOTALp(adjustment for true volume of oils rather than just weight as used in the conversion factor for 'vol to wt cnv' Weight in lbs Jojoba (Wax)Resulting Water/Lye factor: q2 2T33E4[44S555366Q#77#7u888.8sL99E::R-;;1 ; Q< < v= = ?> >P ?; @>cc L $Ec*SV  dMbP?_*+%MN\\SNP5HRTS\SMASTER2pcXXLetter 9''''""XX??cU} } $.} I.} } m 6} m %}  ,} $ !} I!} } } $                                    U * * -h 5 0 / p  7 8 89 : = ; <r <q  >s  >t  rh?eb3k? $A@L L@QC@@X@-A@#L  , ,B7\Y?! Q)@Z@D;Nё\?@W@@Z@@X@  W@ [ QL A&L A&B$&LLLA B b~ +@k<=? V@4@W@W@[@V@  V@   rh?eb3k? X@q?sh|?? j@W@@W@X@  X@  /$?ev|N? X@x>@V@T@V@X@  @Y@  \kw#?8>y2 ? @Y@~ ?!rh?T@W@  @Y@  I +?y? l@NbX9?$@4@l@  m@  V-?D.? _@@V@ Q@T@  _@   a+e? |g"g?  _@  CQuV? m R@R@_@  ]@   Z Dl? oQ!Ǹ?  U@ ~ C@ 4??  "@&@U@  U@   Y ^? ͱ]?  I@ ~ o@ I&†?  @`@b@  I@   ~ 1@ NӁl?  l@   NbX9?  $@4@l@  l@    w#? |Q?  g@   x&?  B@B@g@  h@    Af? ? i@ ~ V@ 9@B@  i@  c9EGr?V-? B@~ ? a@d@  B@  fho?u-t? @[@@@V@S@V@  @[@  vׁ?mҝ]? B@~ HB@rh|?.@4@  B@   m{?F>? L@~ @{F^?[@_@L@  Q@  w*:H?yI]? R@$U|?DCl?"@,@  R@   .!u?= C? W@5&u`VD?^Q?\(\?D~  X@T@V@W@  X@  7A`?be? R@tV?@`@a@  R@    y?BbL ? @`@ rh?P@R@@`@  _@  ~ +@k<=? N@?Dl? l_@`@N@  O@  ʡE?g?6镲 ? ffffff@Q)@Z ~ d@ K7?Y*? c@~ ?`"?@@F@c@ g @c@QD A&D A&B$&DDDA B ~ 3@ƥ?  p@5Hi7?~@B@@XD rh?$@$@ p@ g p@QD A&D A&B$&DDDA B   ~k ?xVp? =@rvZ?d@d@=@  6@ [1 QL A&L A&B$&LLLA B X9v? ʟD? L@ ;)JV?~ V@ k@Z@^@L@  O@   rh?eb3k? @Q@~ @/$?^@^@@Q@  @Q@  D l@pp( ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?   v? Q5??  @V@~ ? MbX?  Y@[@@V@  V@   !!R'?! ?! ! `@ !!K7A`? !!h@h@! ! `@! ! "" rh?"eb3k?" "X@!"q?"sh|?? "j"@W@@W@X@ " X@" " #X#a+e?#|g"g?# #`@"~ #0a@ ###D@T@`@ # ``@# # $[$^?$ͱ]?$ $E@#~ $?$sh|??$$@a@c@$ $ E@$ $ %%^?%ͱ]?% %$*%gtV?%fffff-@ D%~ %V@ %%i@i@ % .% % &&gDio?&-t^?& &@`@%&&/폸?&&M@P@@`@ & @`@& & ''x&1?'4?' 'P@&5'8?)\(@\(\? D''y%?''W@`@P@ ' O@' ' ((z6>W[?(EXY?( (Z@'$(Ln?(D((ˌ%|f?((U@U@( ( Z@( ( ))K7?)n@&?) )C@(~ )?)y%?)) b@ d@C@ ) B@) ) *_*|?5^?*V?* *@b@)~ *Q@ ***E@K@* * @b@* * ++l g?+ 'N%?,zG?\(\?D4~ 4 W@ 44@@`a@ 4 `@43 4 5!5^?5ͱ]?5 54*5gtV?5fffff-@ D5~ 5V@55g@`h@ 5 53 5 6"6n?6>UH?6 6]@5~ 6? 666@R@S@6 6 ]@63 6 7#7 rh?7eb3k?7 7@Q@6~ 7@7/$? 7u7^@^@@Q@ 7 @Q@73 7 8$8Mb?8[{?8 8^@78 888K@@P@8 8 ^@83 8 9`9x $(~?9=?K?9 9@b@8~ 9PI@ 999E@I@9 9 @b@93 9 :~ :3@:ƥ?: : p@9~ :k@: rh? ::$@$@ p@ : p@:3 : ;a;.1?; 4Wi?; ;S@:~ ;a@ ;;;W@W@; ; S@;3 ; <%~ <,@< ?#?< <a@;< <<<F@@P@< < a@<3 < =&=ioſ?=0kH?= =L@<= ;)JV?~ =V@ =k=@Z@^@L@ = O@=3 = >'>a+e?>|g"g?> >_@=>>CQuV?>>R@R@_@ > ]@>3 > ?(?C??K?? ?_@>~ ?PU@?MbX???U@W@_@ ? Z@?3 ? Dlx(@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _  @)@V-?@)[?@ @@Y@?@@jz~?@@N@@P@@ @ @Y@@3 @ AAx&?A4sE?A A@[@@5Al~?4(\#@\(\?eDAAK7A`?AAS@W@@[@ A @Y@A3 A BgBn?B>UH?B B$Bi(L L@QC@B`@AB-Bi(#L  , ,BB BBBV@Y@`@ B X@B3 B C,C?5^I ?C6Q?C BC b@BB5Cja/?@B@@XDC~ CV@CCF@L@ b@ C `b@C3 C D*D+?D~?D BDf@CBD~ DU@DD$@2@f@ D i@D3 D E+Ex?Efv0?E BEf@DBE"@U@EE$@2@f@ E m@E3 E F-F?5^I ?F6Q?F BFc@EBF FFFB@F@F F c@F3 F GnGK7?GY*?G BGX@FBG GGGW@Y@X@ G @X@G3 G H.H rh?Heb3k?H BHX@GB5H=?AGz@?DHHsh|??HH@W@@W@X@ H X@H3 H I/IgDio?I-t^?I BIHBI~ I@W@ II g@i@I I I3 I J]JSt$?Jof?J BJW@IB~ JU@JK7? JJ@W@X@J J W@J3 J K0Kݵ|г?K`u?K BKK@JBK~ K W@KKa@a@K K K@K3 K L1Lp_Q?Ls ?L BLS@KBLL rh?LL@^@@`@L L S@L3 L M2MX9v?M ʟD?M BML@LBM ;)JV?~ MV@ MkM@Z@^@L@ M O@M3 M N3NX9v?N ʟD?N BNL@MBN ;)JV?~ NV@ NkN@Z@^@L@ N O@N3 N O4OX9v?O ʟD?O BOL@NBO ;)JV?~ OV@OO@Z@^@L@ O O@O3 O P5PMb?P[{?P BPQ@OB~ PF@PK7A`?PP[@[@P P Q@P3 P Q6Q.!u?Q= C?Q BQW@PBQ2@ X@ QoQT@V@W@ Q X@Q3 Q R^R3ı.n?Rxy?R BR@QB#Rfffff?R fffff%@~ RW@RR`g@`g@R R @R3 R S7SK7?SY*?S BSG@RB5S]B.?H@? DSSrvZ?SS b@ b@G@ S H@S3 S TxTm4?T۶0s?T BT b@SB~ TPR@ TTTA@E@T T b@T3 T U8U/$?Uev|N?U BU@T@TB;Upb:#?S%p= ף??@DUU%Fv?UUY@@]@@T@ U @S@U3 U V9VMb?V[{?V BV]@UB~ V>@ VVVK@Q@]@ V @]@V3 V W:W rh?Web3k?W BW\@VB5W#P9?Uףp= ??0DW~ WW@WWV@W@\@ W X@W3 W X;~ X+@Xk<=?X BXN@WBX?XDl?XX_@`@N@ X O@X3 X YYPs?YZ?Y BYq@XBYY&1?YY@@q@ Y h@Y3 Y ZZb=?Z~/?Z BZq@YB ZZ@@q@ Z `g@Z3 Z [<[x&?[4sE?[ B[O@ZB5[ػMDq?Wp= ף?\(\?D[[K7?[[`_@`_@O@ [ O@[3 [ \=\x&?\4sE?\ B\@[@[B=\?\'#@Q)@ZD\\K7A`? \z\@T@@T@@[@ \ Z@\3 \ ]>]n?]>UH?\B]$ Q]B] ] ] ] ] ( Q]3 ] ^?^Cl?^L :?^ B^`b@] BE^g Z?C/(\?{Gz? ?D^^=C#? ^^E@I@`b@ ^ b@^3 ^ _@_|?5^?_V?_ B_@g@^B_~ _W@__@@@_ _ @g@_3 _ Dl ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~   `A`' ?`s}kU?` B`d@_B`~ ` X@ ``:@B@d@ ` `d@`3 ` aBaݵ|г?a`u?`Bac@aBa a a~ a c@a , Qa3 a bby):?bd,?b Bb\@a Bb~ b`W@bbQ@Y@b b \@b3 b ccO1hm?c r?c BcI@bBc~ cW@cc@`@c@c c I@c3 c dCdݵ|г?d`u?d Bdc@cBd~ dW@ddD@I@c@ d b@d3 d eee^?eͱ]?e BeT@dBex@V@ ee[@[@e e T@e3 e fDfK7?fY*?f Bfc@eB~ f?f`"? fyf@@F@c@ f @c@f3 f gEg`TR'?g|m?g Bg:@fBgggu/?gg`d@e@g g :@g3 g hFh Q?hK?h BhF@gB~ h?hrvZ?hha@b@h h F@h3 h iiS㥛?i֍`?i BiM@hBi? W@ii\@a@M@ i L@i3 i j j#jfffff?i fffff"@j k k6kZd;O?j '@Q)@Zk l l6l¨N@?k @Q)@Zl m m#mL?l L @m n nn@mn o o#o\(\?n \(\(@o p p#p?o @p q q#qffffff?p ffffff@q r rr?qr s s#s?r #@s t t6te;O@s @Q)@Zt u uu?t u v v0vkt@uQ)@Zv w ww?vw x x#x?w %@x y y#y@x  @y z z)z>*@y333333@Q?z {~ {@){K@{ףp= ??{!{}?5^I?z D{D{{ | |#|?{ ?| } }(} ףp= ?|\(\?}MbX9? }} ~ ~#~ffffff?} ffffff!@@~MbX9? ~~ 22%+Dl]pp]W]]]W]pWjW]]c]~y122%+122%+122%+122%+122%+122%+122%+122%+#1LR %B 22%+122%+122%+122%+122%+122%+122%+122%+122%+122%+122%+122%+122%+122%+0EA0 2 RW[ B . ( |!    BW{ XPP?i]4 @W{8 %@mgJ^m? <Avocado Butter - Refined Main Elements Extremes Actual Appearance . Soft pale green fat Iodine Value (Wijs) . 66.9 Saponification Value . 197.5 Peroxide Value (meq/kg) 5.0 Max Meets Refractive Index 40C . 1.466 Specific Gravity @ 30C . 0.904 Fatty Acid Profile Palmitic C16:0 21.3 Palmitoleic C16:1 7.9 Stearic C18:0 9.5 Oleic C18:1 53.4 Linoleic C18:2 6.1 Linolenic C18:3 0.1 <7    BW{ XPP? i@#K]4 @W{h8 ?9@ڎ7 <http://botanical.com/products/learn/oilprofile/borage.html Borage Oil Profile Botanical Name- Borago officinalis Origin- USA Extraction- Cold Pressed Shelf life- 3-6 months Notes- This particular oil should be kept refrigerated. No additives, preservatives, antioxidants, or other foreign agents have been used or included in the manufacturing of this oil. Specifications Color- Yellow with green tints Odor- Characteristic Free Fatty Acids- Heavy Metals- None Detected Pesticides- None Detected Peroxide Value- 0.6% Non-Saponifiables- 0.80 Saponification Value- 189.3 Iodine Value- Specific Gravity- 0.9227 Fatty Acids Docosenoic- 2.5% Icosenoic- 3.9% Gamma Linolenic- 22.3% Linoleic- 37.2 Oleic- 16.7% Palmitic- 10% < ~~  <PX{XPP?  i ]4@PX{8 lubA@:锤@81 <http://botanical.com/products/learn/oilprofile/rosehiporganic.html Rosehip Seed Oil Profile (organic) Rosehip Seed Oil Profile (organic) Botanical Name- Rosa rubiginosa Origin- Chile Extraction- Expeller/Cold Pressed Shelf life- 12-18 months Notes- This particular oil is imported from Chile and is commonly referred to as "Rosa Mosquita". Because of its delicate nature and the cold pressed method of extraction, it should be kept refrigerated. Specifications Color- Red Odor- Characteristic Free Fatty Acids- Peroxide Value- <0.05% Non-Saponifiables- Saponification Value- 193 Iodine Value- 187 Specific Gravity- 0.92 Fatty Acids Oleic- 13.7% Palmitic- 3.8% Linoleic- 44.6% Linolenic- 35.5% <    BDZ{ XPP?Sifi]4@DZ{8 :A?f"E~m G<Hhttp://botanical.com/products/learn/oilprofile/sal.html Sal Butter Profile Botanical Name- Shorea robusta Origin- India Extraction- Expeller pressed/Refined Shelf life- 1 year optimal Notes- Store in a dark, cool location. Specifications Color- White/Light Yellow Odor- None Free Fatty Acids- 0.25% Peroxide Value- Less then 4.0 Non-Saponifiables- 0.6-2.2% Saponification Value- 178-192 Iodine Value- 35-43 Total Saturated- 48-63 Total Monounsaturated- 37-43 Total Polyunsaturated- 0-4 Fatty Acids Oleic- 37-43% Palmitic- 4-7% Linoleic- 0-4% Stearic- 41-47% <W G   BZ{ XPP?di|<]4@Z{8  ׭!L}! <Product:(05-5511) TAMANU OIL calophyllum tacanahaca seed oil Description: The Oil of Tamanu is extracted by a cold pressed method from the nut of the Polynesian Tamanu tree. The oil 100% pure virgin Tamanu Nut Oil is non-refined and non-deodorized A sacred part of an ancient Polynesian culture. The pressed oil from the nut of this tree has been successfully used for the treatment of a wide range skin disorders and injuries. ANALYSIS SPECIFICATION APPEARANCE DARK SEMI-VISCOUS OIL, WITH A NUTTY ODOR CONGEALING POINT/TITRE 6-8C FFA 3.0% MAX. IODINE VALUE 108 MOISTURE/%VOLITILES 0.5% MAX. PEROXIDE VALUE 6.0 REFRACTIVE INDEX 1.460-1.50 SAPONIFACTION VALUE 192 SPECIFIC GRAVITY 0.910-0.929 UNSAPONIFIABLE MATTER 0.6 MAX. FATTY ACID PROFILE FATTY ACID PERCENTAGE C14 Myristic <0.1 C16 Palmitic 12 C18 Stearic 13 C18:1 Oleic 34 C18:2 Linoleic 38 C18:3 Linolenic 0.3 C20 Arachidic 0.7 C20:1 Gadoleic 0.3 C22 Behenic 0.2 <    B [{ XPP?hiy]4@ [{8 luDR4p <Wheat Germ Oil, RBD (Cold Processed, GMO-Free) Free Fatty Acids, % : < 0.1 Acid Value, mg KOH/g : 0.2 Specific Gravity : 0.925 Iodine Value, g I2/100g : 120 - 130 Saponification Value, mg KOH/g : 180 - 195 Peroxide Value, meq O2/kg : < 5.0 Residual Solvents, ppm : < 5 Tocopherols (Vitamin E), IU/g : > 2.0 Color, Lovibond (Typical) : 26 Yellow, 2.2 Red Refractive Index at 20 C : 1.473 Chill Test : Pass Clarity, NTU : < 1.0 C-16 Palmitic content, % : 16.90 (typical) C-18 Stearic content, % : 0.75 (typical) C 18'1 Oleic content, % : 17.14 (typical) C 18'2 Linoleic content, % : 55.44 (typical) C 18'3 Linolenic content, % : 6.57 (typical) Heavy Metals, ppm : < 10 Halogenated Hydrocarbons, ppm : < 0.2 Malathion, ppm : < 3.0 < ~~  <p[{ XPP? iiyj]4@p[{X8 bu"?FyO <Other Ingredients <X   Kathleen K Kochb Kathleen K KochbKathleen K KochbKathleen K KochbIKathleen K KochbIKathleen K KochbRKathleen K KochbTKathleen K KochbeKathleen K KochbiKathleen K KochbjGlenn Edward Murray?P>@A  7eeyK  .910-.929yK http://www.conaloe.com/product9_specification_sheet.htmyX;H,]ą'c% Sheet2ggD L   dMbP?_*+%MTEPSON Stylus C62 Seriespv odhh-RL*** xhhDLLName32=E_DU16CE.DLL d 2EPSON Stylus C62 Series  ***"dXX??cU} } }  }  } $ } $ } $                               " ' '! )Q Cost/Oz Cost/Oz    $  ~ #@!!Q?  DD<@I@  $  ~ #@!!? DD??   !!6 {? 1R ZZZ Z       "| ' ' ( ( ) ) ) )  ) ~  `<@    } @@X@ ~  o@   g G ? D  ~  ~ O N~ 0@#  y? y&1`@  L&d2? D   !!    " &  !!      !!    "~ #?  !!   !!  ' ' ( ! "+3g G ? Z#Bf+40@ Z#Bfa@? K#BMetric Metric#Bf@B+3L&d2? Z# Bf "34@!  ' '!! "y?C ףp= ? D!!  !! B A ~ @ ~ @   8'  t4L4>V>d`     fr    PH 0( !k P>@ 7  !? 0( !k DdDddD?0( !k  LA+ #  Sheet6ggD L +f.6  dMbP?_*+%'RQ?)RQ?MEPSON Stylus CX4600 Series od5RL**** xDLLName32=E_FUIC9AA.DLL $d $2EPSON Stylus CX4600 Series @ **** "aX??cU} O} O} I O} I N} I P}  Q} I O} O} I O} X} X} $ X} $ O+`@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@J S WQC Standard$%%  e~  @ {Wf@o%Z % B%A&7% %B%% BA B%%%    ! WQ#D |C Z  LiquidVDd  Soft6D  hard avg hardness"""Bhardaaaa   &'''''/ Q!D ;BfNaOHj S < Q&Weight (C#Bf)BP Weight (Oz)94 Q#Vol (C#Bf)BP Vol (Oz) uMj Q7DGrams D, DBPBPounds, Ounces h H<h Q &Weight (C#Bf)BP Weight (Oz)  V< Q$ &Weight (C#Bf)BP Weight (Oz)      ~ @@yCłPA@ {D fD JD#Bf  DD#Bf""BUUUUUU?F <L@@ L B%LL@BQ DGrams xD DZAB lb, D DZA'AB oz BPB 2 lb, 0 oz G p@ 1D D##BfBW{RQ?AD ,D#C ## BfBfBRQ@X NL@@ A&L@@ @A&B$LL B  W Dİ QAD  ,D #C ##BfBfBd DĴ Q ND @@ A&D @@ @A&B$D D  By D @cD ND##Bf D##BfBDBX@@( 8 .L L B% ,ByY QcD  ND ##Bf D ##BfBD BDX.D D B% $ BHi7@ sD ^D##Bf 2D##BfD#B"B Q sD  ^D ##Bf 2D ##BfD #B"BX@@(8 .L L B% ,BDX .D  D  B% $ B ,~ @@}Rc|A@{D fD JD#Bf  DD#Bf""BUUUUUU? 0Q DGrams xD DZAB lb, D DZA'AB oz BPB 2 lb, 0 oz Gz b@ 1D D##BfBW~?5^I ?AD ,D#C ## BfBfB?5^I @   D Q K AL ,L#C ##BfBfB D Q  X NL@@ A&L@@ @A&B$LL By D @cD ND##Bf D##BfBDBX@@(Y Q m cL NL##Bf L##BfBLBX8 .L L B% ,Bja/@( } sL ^L##Bf 2L##BfL#B"B Q( } sL ^L##Bf 2L##BfL#B"BX@@( X 8 .L L B% ,B ?~ @@ } @@   {L fL  !"#$%&'()*+,./012345678:;=>?@ABCDEFGHIJKMNOPQRSTUVWXYZ[]^_`abcdefghijkmnopqrstuvwxyz{}~@2iw[@#:D %%D$p= ף?BGLMJl Y[DCl $lt4$$=,2Kk @!@"@#@$@%@(@*W T o n  S l D!8 Q. Bar Size (D; Bf)BP Bar Size (Oz)~ !@ !oJ!_6?4D" D" B%D"D#BP!@:D# %CD#D%AD%B=!(f?'D! D!D!B!l "SRD"?@.D A&DD!B B "p"8eP0@D" ~DD XDDD 2C ##BfD#BB "B="8ePP@"'D" D"D$B="TИH@#'D" D"D"B"l C#ST Q#-After D$d% overhead lossBPAfter 5% overhead lossD#W;@!.D A&DD!B B1#o QC#Bf BPOz Q# v?#;D D" B%D"D$DBD#Q?!.D" D"DAB=#PY/?!'D# D#D#B # l $~ $W@ $~ $@$J $|$0QfDGrams 'DCA gramsBP,D?A ozBPB3 oz$ 0Q$DGrams 7 (Based on CA gms per kg oils)6 (Based on CA oz ppo oils)B(Based on 0.5 oz ppo oils)$  % %~ %@ % %h (** XqH     Gr  ( C  A  pe )! sed" $  0~(    TA ?@CommandButton1 "]` 4#81 6$|{,^Forms.CommandButton.1T U H{ XP?"`ww]4U@{$8 >Z= @wn  E0<FWhen using "DWCP %", it disables the "Recipe Fat/Water ratio:" input.<0%; &=%I$&>%E$ k HD{ X)P?"`U ]4k@D{H%8 \WAJ K<LQuick reference for those who use scales that measure in pounds and ounces.<K kKathleen K Koch URon Koch P>@dd:$$ "   7?  pounds and ounces. LALA.#"#!#?"#!#pounds and ounces. LA****!?**!#pounds and ounces.DdDddD((((!?((!#pounds and ounces.DdDddD?pounds and ounces. LA?pounds and ounces. ?pounds and ounces. LA+ # + # I Use dropdown list to select Oil#nda 7Clear field and use dropdown list to select Oil# Sheet1ggD L 'E  dMbP?_*+%'zG?)Q?MTEPSON Stylus C62 Seriespv odhhRL*** xhhDLLName32=E_DU16CE.DLL d 2EPSON Stylus C62 Series  ***"dXX??cU} O} O} I O} I N} I P}  Q} I O} O} I O} O} $ O'`@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@J ^S;( Q%Z :B(((()`aaaaaaWW eT~ ?aaaaa  WW ebaaaaa`aaaaaaj Sj QZ Weight (Oz)t QZ Vol (Oz) tGMj Q7DGrams D, DBPBPounds, Ouncest HXv Q BZ; Bf@ Z ;BfBP Oz NaOH  VB j0Q, Weight in Z; BfBP Weight in Oz kRaa;CLQ%Z :B CoconutGy@@1Z ZDABGyq= ףPA@1Z ZDABEUUUUUU?/D@@ DD@BQDGrams xD DZAB lb, D DZA'AB oz BPB 2 lb, 0 oz WRQ?AD ,D#C ## BfBfBRQ@X NL@@ A&L@@ @A&B$LL B; tQ %Z  : BG xQ 1Z  Z DABW Z|QAD  ,D #C ## BfBfBd DĀQ ND @@ A&D @@ @A&B$D D  B  rs;EQ%Z :BPalmG}@@ 1Z ZDABG}\(|A@1Z ZDABUUUUUU? 9 /L@@ LL@BlQ DGrams xD DZAB lb, D DZA'AB oz BPB 2 lb, 0 oz W?5^I ?AD ,D#C ## BfBfB?5^I @ ; Q %Z  : BG Q 1Z  Z DAB ZQ  K AL ,L#C ## BfBfB DQ  X NL@@ A&L@@ @A&B$LL B  rs; EQ %Z  : B Tallow, beefG }@@ 1Z  Z DABG }= ףp@@1Z  Z DAB UUUUUU?  Q DGrams xD  D ZAB lb, D  D ZA'AB oz BPB 2 lb, 0 oz   Cl?  K  AL ,L#C ## BfBfB Cl@ ; Q %Z  : BG Q 1Z  Z DAB ZQ   DQ  rs; EQ %Z  : BG }Q 1Z  Z DABG }=Q 1Z  Z DAB Q  Q DGrams xD  D ZAB lb, D  D ZA'AB oz BPB lb, oz   C Q   c$Q ; (Q %Z  : BG ,Q 1Z  Z DAB Z0Q   D4Q  rs; E8Q %Z  : BG }<Q 1Z  Z DABG }@Q 1Z  Z DAB DQ  Q DGrams xD  D ZAB lb, D  D ZA'AB oz BPB lb, oz   C\Q   `Q ; dQ %Z  : BG hQ 1Z  Z DAB ZlQ   DpQ  rs; EtQ %Z  : BG }xQ 1Z  Z DABG } |Q 1Z  Z DAB Q   Q DGrams xD  D ZAB lb, D  D ZA'AB oz BPB lb, oz   CQ   Q ; Q %Z  : BG Q 1Z  Z DAB ZQ   DQ  rs; EQ %Z  : BG }Q1Z  Z DABG } Q 1Z  Z DAB 'Q HQDGrams xD  D ZAB lb, D  D ZA'AB oz BPB lb, oz   CQ   CQ; Q %Z  : BG Q 1Z  Z DAB ZQ   DQ  rs;EQ%Z :BG}Q1Z ZDABG}Q 1Z ZDABLQQDGrams xD DZAB lb, D DZA'AB oz BPB lb, oz CQ Q; Q %Z  : BG Q 1Z  Z DAB Z Q   D$Q   rs;E(Q%Z :BG},Q1Z ZDABG} 0Q1Z ZDABq4Q QDGrams xD DZAB lb, D DZA'AB oz BPB lb, oz CLQ PQ; TQ %Z  : BG XQ 1Z  Z DAB Z\Q  d D`Q ND @@ A&D @@ @A&B$D D  B  rs;EdQ%Z :BG}hQ1Z ZDABG}lQ1Z ZDABpQ QDGrams xD DZAB lb, D DZA'AB oz BPB lb, oz CQ |Q; Q %Z  : BG Q 1Z  Z DAB ZQ  d DQND @@ A&D @@ @A&B$D D  B  rs;EQ%Z :BG}Q1Z ZDABG}Q1Z ZDABQ 8QDGrams xD DZAB lb, D DZA'AB oz BPB lb, oz CQ Q; Q %Z  : BG Q 1Z  Z DAB ZQ  d DQND @@ A&D @@ @A&B$D D  B  rs;EQ%Z :BG}Q1Z ZDABG}Q1Z ZDABQtQDGrams xD DZAB lb, D DZA'AB oz BPB lb, oz CQ MQ; Q %Z  : BG  Q 1Z  Z DAB ZQ   DQ   rs;FQ%Z :BGQ1Z ZDABG Q1Z ZDAB$QQDGrams xD DZAB lb, D DZA'AB oz BPB lb, oz WC<QAD ,D#C ## BfBfB@Q; DQ %Z  : BG HQ 1Z  Z DAB ZLQ   DPQ   rs ?I#X@$ %:#QY@ %::#?! %::\QDGrams xD DZAB lb, D DZA'AB oz BPB 6 lb, 0 oz #|V-.@ %  ?I# ! % : H# D %  XIJKLLM ?Pw?ZwulQZ DWCP %:w?ZL "W ++ ^ @ G&}?HD  $1DDDADD B W ?Z>SQ (Total Z; BfBP Total Ounces1 QZ; Bf Pounds1 Q$ Z; Bf Ounces jQ SJIyX@3Z ZDCABTR@<D@@  @DZ@ABQy;D@@  @DZ@A'B;*Q!%Z :B *** SI}3Z ZDCABRz<D@@  @DZ@ABQ};D@@  @DZ@A'B**** SKd},@ND@@  @-DDD@@C@ABTRz4R<D@@  @DZ@ABQ},@;D@@  @DZ@A'B**** ULI5@3Z ZDCABTR?<D@@  @DZ@ABQ@;D@@  @DZ@A'B**** UMOy`@%9D@@  @%@SUBVP @:D@@  @DC@ABOfffff@9D@@  @DC@A'BJ**** dQZAfter Cure (11.4% water)Ifffff&_@&3Z ZDCABGP@:D@@  @DC@ABO033333)@9D@@  @DC@A'BJ**** JKLG**** D{9l a>%2 9_="&R  @! @" @# @$ @% @& @ Tm n T **** E!SQ/ Bar Size(Z; Bf)BP Bar Size(Oz)!@"Z! !o!_6?"Z!!W**** "SRH"?@2D A&DD!B@B "pC"8eP0@-Z" Z"ZB"W**** #W $xR~ $$ $|$hQfDGrams 'DCA gramsBP,D?A ozBPB3 oz$ ,QDGrams 7 (Based on CA gms per kg oils)6 (Based on CA oz ppo oils)B(Based on 0.5 oz ppo oils)$ , %'%ffffDD$A %h &q'& DD$Aax8I       ( C[ A$  pe  ) sed$ $$  & ilsPH@,0(  ,>@""  $$ 7? $$ (  , LA&&%&?%&  , LA Sheet3ggD L '͊B  dMbP?_*+%MTEPSON Stylus C62 Seriespv odhhRL*** xhhDLLName32=E_DU16CE.DLL d 2EPSON Stylus C62 Series  ***"bXX??cU} ]} ]} I ]}  ]} I ]} ]} I ]} ]} $ ]' ` @ @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@@@@@@@@@@@O ^S;(PQ%Z :B(((()@_TQ  * Length ( in C# Bf)BPLength ( in In)  _  _O`aa cd -.@@? O ^Ta vwu? KZ 4C@#@@BfCZBa f  - . @,@ O^bafWeghJJ O`aiaqh@ [D DD D 8D  D D D C"B)i@D# BfjOOOO O SjtQ !Z Weight (Oz)tQ Z Vol (Oz) uGMjQ 7DGrams D, DBPBPounds, Ouncesu HXQ  BZ; Bf@ Z ;BfBP Oz NaOH  VB Q , Weight in Z; BfBP Weight in Oz  kR O;CQ%Z :B CoconutGy(\u9@ 1Z ZDABGy̌;@ 1Z ZDABEVUUUUU? /D@@ DD@BQ DGrams xD DZAB lb, D DZA'AB oz BPB 1 lb, 9.5 oz {RQ?K AL ,L#C ## BfBfB~bY@(X NL@@ A&L@@ @A&B$LL B; Q %Z  : BG =Q  1Z  Z DABW Z Q AD  ,D #C ## BfBfBd D$$Q  ND @@ A&D @@ @A&B$D D  BO;E(Q%Z :BPalmG}(\u9@ 1Z ZDABG}Gz;@ 1Z ZDABVUUUUU?(9 /L@@ LL@B4Q DGrams xD DZAB lb, D DZA'AB oz BPB 1 lb, 9.5 oz ~?5^I ?   @( ; PQ %Z  : BG TQ  1Z  Z DAB ZXQ  K AL ,L#C ## BfBfB D\Q(  X NL@@ A&L@@ @A&B$LL B O; E`Q %Z  : B Tallow, beefG }(\u9@ 1Z  Z DABG }Hz;@ 1Z  Z DAB VUUUUU?(  Q DGrams xD  D ZAB lb, D  D ZA'AB oz BPB 1 lb, 9.5 oz   ~Cl? R\U @(; Q %Z  : BG Q 1Z  Z DAB ZQ   DQ(   O; EQ %Z  : BG }3Q 1Z  Z DABG }pQ 1Z  Z DAB DQ( (Q DGrams xD  D ZAB lb, D  D ZA'AB oz BPB lb, oz   ~CQ  dQ( ; Q %Z  : BG Q 1Z  Z DAB ZQ   DQ(   O; EQ %Z  : BG }pQ 1Z  Z DABG }GQ 1Z  Z DAB FQ(  TQ DGrams xD  D ZAB lb, D  D ZA'AB oz BPB lb, oz   ~CQ  P Q( ; Q %Z  : BG Q 1Z  Z DAB ZQ   DQ(   O; E Q %Z  : BG }=$Q 1Z  Z DABG }p(Q 1Z  Z DAB ,Q(  Q DGrams xD  D ZAB lb, D  D ZA'AB oz BPB lb, oz   ~CDQ  IHQ( ; LQ %Z  : BG PQ 1Z  Z DAB ZTQ   DXQ(   O; E\Q %Z  : BG } `Q 1Z  Z DABG }dQ 1Z  Z DAB hQ( Q DGrams xD  D ZAB lb, D  D ZA'AB oz BPB lb, oz   ~CQ  AQ(; Q %Z  : BG Q 1Z  Z DAB ZQ   DQ(  O;EQ%Z :BG}לQ 1Z ZDABG} Q 1Z ZDABQ(0Q DGrams xD DZAB lb, D DZA'AB oz BPB lb, oz ~CQ:Q(; Q %Z  : BG Q  1Z  Z DAB ZQ   DQ(  O;EQ%Z :BG}Q 1Z ZDABG}Q 1Z ZDABQ(lQ DGrams xD DZAB lb, D DZA'AB oz BPB lb, oz ~CQQ(; Q %Z  : BG Q  1Z  Z DAB ZQ   D Q(  O;EQ%Z :BG}Q 1Z ZDABG} Q 1Z ZDABjQ(Q DGrams xD DZAB lb, D DZA'AB oz BPB lb, oz ~C4Q8Q(; <Q %Z  : BG @Q  1Z  Z DAB ZDQ   DHQ(  O;ELQ%Z :BG}GPQ 1Z ZDABG}TQ 1Z ZDABEXQ(Q DGrams xD DZAB lb, D DZA'AB oz BPB lb, oz ~CpQtQ(; xQ %Z  : BG |Q  1Z  Z DAB ZQ   DQ(  O;EQ%Z :BG}Q 1Z ZDABG}3Q 1Z ZDABQ( Q DGrams xD DZAB lb, D DZA'AB oz BPB lb, oz ~CQQ(; Q %Z  : BG Q  1Z  Z DAB ZQ   DQ(  O;FQ%Z :BG=Q 1Z ZDABGGQ 1Z ZDABQ(\Q DGrams xD DZAB lb, D DZA'AB oz BPB lb, oz CQIQ( ; Q %Z  : BG Q  1Z  Z DAB ZQ   DQ(  O ?I#QS@ $ %:# ףp=T@  %::#?  %::\<Q DGrams xD DZAB lb, D DZA'AB oz BPB4 lb, 12.4 oz #|g?(@  %  ?I#  % : H# D ! %  OIJKLLMOOOOOO O ?Pw?Zwu QZ DWCP %:w?ZL "W ++ ^ / "ǩ? HD  $1DDDADD B  WOO OOO ? ZOOOOOO OO>SQ (Total Z; BfBP Total OuncesN1Q Z; Bf Pounds1 Q $ Z; Bf OuncesO jQOOOO O SJIyS@ 3Z ZDCABTR@ <D@@  @DZ@ABQy(@ ;D@@  @DZ@A'BO;*lQ %Z :B***O O SI} 3Z ZDCABNRz |S<D@@  @DZ@ABQ} ;D@@  @DZ@A'BO****O O SKd}&@ ND@@  @-DDD@@C@ABTRz <D@@  @DZ@ABQ}&@ ;D@@  @DZ@A'BO****O O ULI1@ 3Z ZDCABR? "<D@@  @DZ@ABQ? ;D@@  @DZ@A'BO****O O UMO9Z@ %9D@@  @%@SUB- ףp=[@ DDDDP@ :D@@  @DC@ABO!@ 9D@@  @DC@A'BJ****O OdpQ ZAfter Cure (11.4% water)IfffffX@ &3Z ZDCABGP@ :D@@  @DC@ABO@ 9D@@  @DC@A'BJ****O OOJKLGO****O D:l ^ 6$+Wu0K0Y^ @! @" @# @$ @% @& @ OOTm n TO****O !O !S!@  Z! !o!_6? Z!!W****O "O "SRH"8@ 2D A&DD!B@B "pA"*6zQ*@ "+Z" Z"DB"W****O # $xR~ $$ $|$Q fDGrams 'DCA gramsBP,D?A ozBPB 2.3 oz$ ,Q DGrams 7 (Based on CA gms per kg oils)6 (Based on CA oz ppo oils)B(Based on 0.5 oz ppo oils)$ , %'%3333 DD$A % &q'&ffff DD$A+x8I f    ( C~ A  pe$ ) sed !  $ ils$  sPHP+ 0( 3f3333  >@2$$ "  7&&%&?%&f3333  LA?f3333  LA?f3333  LA+ #  Sheet7ggD L   dMbP?_*+%MTEPSON Stylus C62 Seriespv odhh     # !"$,%&'()*+HOZ/01234@6789:;<=>?.ABCDEFGIJKLMNPYQRSTUVWX[_y\]^`gabhdef|qjklmnopcrstuvwxz{}~RL*** xhhDLLName32=E_DU16CE.DLL d 2EPSON Stylus C62 Series  ***"dXX??cU` ( NwQEw l  s *h{  @ ]`h{ .8 A4< 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. Notes in blue were added by Kathleen Koch January 2005. Installation ------------ (These instructions are based on installing the template for use by versions as early as MSExcel97, on a machine running MSWindows95/98/ME/NT/XP.) 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 - DWCP % (Experienced Soapmakers only) - Bar Size (Oz) - Oil to Water ratio - Water (if water is overridden, then auto calc will cease for water field)(With the addition of the DWCP % field, this field is disabled) - 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. The AutoScaled sheet allows you to enter a mold size and get the recipe scaled to your mold. All fields titled in dark blue are for enterable values. For easier viewing of these areas, they have been highlighted in yellow. 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 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