ࡱ> 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 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 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. DWCP % (Experienced Soapmakers only) ------------------- DWCP %: For Discounted Water Cold Process, enter a value from 33% to 50% (the maximum percentage range for disounting water; below 32 results in a "wet" batch and above 50 results in unreacted sodium hydroxide.) The water calculation of "Recipe Fat/Water ratio:" is disabled when using the DWCP %. 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 ratio 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' 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.<3 -Q,e-,---, S-,- ,d @ - H6-L-#-p*p-  - ""-<"'(-WE*0k*-F-H-*-+,-*,-+-*.+,.* ..-l000-~B11-A4ll   s *lh{  @0  Xi] `lh{l.8 0<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). Auto Scaling An auto scaled worksheet is provided so you can just enter a recipe you like then go to the auto scaled sheet and enter the dimensions of the mold (and the mold type you want to use). The correctly scaled recipe will be produced to the size / type of mold you enter. It will also produce a scaling factor, for those interested. When using DWCP%, the computed weight of the oils will increase as the water is decreased to ensure the mold is filled to the specified dimensions. If you have a specific mold you always use, then putting it's dimensions into the worksheet template, then saving in the template directory should save time when scaling the recipe. The volume to weight conversion factors are located on the 'Tables' worksheet as "Volume Conversion Factor" and correspond to a 4/3 ratio of total weight to oil weight times the avg oils specific gravity, then inverted. This will multiply times the volume (in Fl Oz or milliters) to yeild the weight of oil (in Oz or gms). The ratio of the computed weight to the weight on the 'Recipe Worksheet' is displayed and used to compute the displayed ingredients amounts.<0a; `G X  3(pll   s *h{  @   ] `h{|/8 c(<d 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. <( @c>@7 Sheet4ggD L "  dMbP?_*+%MBQMS magicolor 2+d odXLetterPRIV''''e Letter"dX??c Up (   l  s *\q{  @   <]`\q{08 7@<8 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 tweaking or otherwise playing with recipes. Additionally, I was dissatisfied with the inconvenience and lack of utility of the available on-line lye calculators, so I decided to put 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.xlt is released, or when the new stand-alone application version is done (many, many new features), send me an email and I will put you on the list. I should also mention that the new, 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. media and/or postage). 3) Blah, blah, blah, blah. Now go make some soap! Happy Soaping, Chris <@  n 5`6 7>@7 Sheet5 VBA l |C |Sheet1 __SRP_2 -__SRP_39P[LSSs6"L<<N0{00020820-0000-0000-C000-000000000046}0 @` T `XxkX% %*8H@@ %P%(0@` @x ``@@h `P@XX @@pH p@8 PP@( ``@ PP@ P`@ @`@ P@ @`@0 P0@H @` @@@x @ P@x ``@h ``@X @H @8 @ ( @8 @P @h @ @ @ @ @ @ @ @x @(H\H*\R8003*#5d$*\Rffff*0@460e5205*\R1*#d74<"  "(0HXConvert B@oX@Convert B@o0(%Attribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2ControlCommandButton1, 15, 0, MSForms, P+' Which measurement system is being usedOilList'@+ List of Ingredients, except LyeOilList2'B++ Table of Ingredient properties, except Lye Type_Of_Lye'D+ List of types of LyeType_Of_Lye_table'F, Table of Lye properties LengthConv'H+ length Measurement conversion'J N.L Get conversion factor 0 !R%T!V.P H !R%T!V.X : !R%T!V!^$\'ZRecipe Worksheet$`B@b > !R%T!V!^'d? Get curr measurement sys value@ Compute new conversion factor and decide new measurement system dMetricStandard'f Z 'Zd dStandardMetric'f Z 'Zd'Jkk JTables$`B@h- Worksheets("Recipe Worksheet").Unprotect9 Set new values for Sig digits and the measurement system Z : !R%T!V(^ f > !R%T!V(^lnpTables$`B@j Convert the Oil weightsC8:C20$t PAr9 Change expressed significant digits for oil wts & volume/ Call cvFormat(Range("C8:D21"), sigDigits)0 Change expressed significant digits for lye wts\ Call cvFormat(Range("H8:H21"), sigDigits + 1) ' always has an extra significant digit$Convert the Superfatting Oil weightsK8:K20$t PAr< Change expressed significant digits for superfatting oil wt/ Call cvFormat(Range("K8:K21"), sigDigits) Convert the Bar weights 4 !R%T!^$t PAr6 Change expressed significant digits for total weights0 Call cvFormat(Range("c26:f32"), sigDigits) No sig digits for Lbs/KgsI Call cvFormat(Range("e26:e32"), 0) ' Always no decimal places here- Convert prices to reflect new units for Oils( Worksheets("SAP Values").UnprotectU Call cvCell(Range(Application.Names.Item(Cost_Ingredients).Value), 1 / cvValue)\ Worksheets("SAP Values").Protect DrawingObjects:=True, Contents:=True, Scenarios:=True- Convert prices to reflect new units for LyesM Call cvCell(Range(Application.Names.Item(Cost_Lye).Value), 1 / cvValue)M ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True AutoScaled$`B@h AutoScaled$`B@HI3:K3$t XArj4:k4$t XArlnp AutoScaled$`B@jRecipe Worksheet$`B@bk8 LB@bo H cvCell subroutine' Macro recorded 3/20/02 by Glenn Murray9 This macro converts individual selections by multiplying$ against a stored conversion factor. ( Y'QxME(> LLL<,<0<4<8<<<0 *H`@XkyyC 14 r` kzIv ard Ix ent -Macro recorded 3/20/02 by Glenn Edward MurrayC 14 |` H!!Iv hotecI~  Wor 14Hd ou(%`x0(p@,l @H\ @.L @0< @2x, @4 @6 0@8 H@:  `@< x@> @@ @B8 @D @F @HP| @Jhl N\`tr@Xh @LX @T @D @@ @0 @P @X@ @ @ @ @Z @ @d @f @ @ @ @x @h @X h@Tl @\ @X 0 @@T X @P @ @Lo h @< @, z@(`@ ta.Vhunc = $*\Rffff*0A460e5206*\R1*#2ac*\R1*#e8*\R1*#d7*\R1*#228*\R1*#229*\R1*#1c8*\R0*#10*\R1*#dc*\R0*#13 "   ( .0 8` 6  H J  Lp   6 N N hJ @ " H@ pT * > 86 xB 0 8 (6 `     XX  $y  18DgX  F  (  @ P`  hpx   1 4  @h h8 (EX   ,  @ 6  68 bp  * ,  B( 6p   &  < 60 h P 4 . \@ b  4 T@   T 1 1 ,0,P ,Ep 1     "     . @@ *    D 0 @ H  X `h p"      . @ H0 .x       J8       Convert Macro' Macro recorded 3/20/02 by Glenn Murray2 This Macro will convert the entire worksheet from0 Standard (English) to Metric measurement units.B ** Programmer note: Currently the significant digit correction isC commented out, due to a bug. When it is run, the initial unprotectE of the Recipe Worksheet fails. I haven't found out why. > Loop thru each item in the selection and convert (if numeric) T v T!^ T$z T5^ x9^qkk Tox cvFormat subroutine' Macro recorded 3/20/02 by Glenn Murray: This macro changes number format of individual selectionsB based on the parameter sigDigits. DecimalPlaces is used to change( the number of decimal places displayed. Compute new format String ~'    'k  ' 0.00000000 $'D Loop thru each item in the selection and change format (if numeric) T v T!^ T$z T 9q( k k To Attribute VB_Name = "Module1" Sub Convert() P.nProcDataInvoke_FuncAC\n14' ' Macro & recorded 3/20/02 by Glenn @Murray)This: will c the entire workshee@t from4Standard (English) to Mec measurem units.** igrammer note: CD ly8significant digitGrbtion is"$contjou@t, due=a bug. Wh et run,)iAialE$pr9ct"of Recipe Wpails. I haven'Axound 5 why. sts - }+ts0nsnX"' List @& P@systemNTxablB' ExTfactorJtSBG*/*A0  forng betwe@b/tUAH _Bar_Size_Wt@ s in (c)^wei gh@eCost_LyYJCn,m C#BIngredi[> h 'i(excep\t a DTmal_Place +' Numb k>opti@jdisplay5ed (in?ive A'/ 'lich l# bei>usedCMc>! D O]aw OilbcD %h), )CD2aeW h `pies Type_OfeF }tsN.ch_te|}"dF|`Lengtha'  G{c FsCell!PTrueSxv= ActIACEG' Gg $a `cvVal p,pl@a.©.I @(#).RefersToRangH`C= " @D!ҡ (A+s|. 6Ggs("i").bat c47!@O:z=; @3 Impqnew]_ qEde  "")` Then% If IsNc .With A  D =*C?!I!A%Q Next$ P!@mat(, D^malPla`LQE8G +GcWGWsGhs!5ber ofsI!@B basconQB?part sigDig.  Tu!c XtheE` d#$ BpB$ dis y edPPComp/x ǁS {ng6@-Plcsm.bG(> 0KG=B+ 1?="Left("0.0"@ cajIB555gT55157@15.@9#)=t r#1X05  9iIy1q )Ad :\l :\L :\< :\, :\ :\ :\ :\ :\ :\ :\ :\ :\ :\ :\| c\lh$ (QhXX< @Th$ h TD@@a0 )hT@6D0X| @Th$ h TD@@a0)hT@6D0y @Th$ h TD@@a0  a k/)hT@ 6D01T:\%h$ h dT)hTg @Th$ h TD@@a0  a)hT@ 6D0:\]3 :\(\D:\]3 :\(\D f\l lQ1T:\%h$ h dT)hTh @ @Th$ h TD@@a0  ,)hT@ 6D0h @ @Th$ h TD@@a0  ,)hT@ 6D0Ec%c%cx%T:\%h$ h dT  )hT,h'%:\!%$  QhoD "5D,h'%:\#%$  QhoD "5D @Th$ h TD@@a0 '%0`F%$  Q oX ")hT@6D0X1T:\$%h$ h dT)hT1T:\$%h$ h dT%)hT,h'%:\&%$ QhoD "5D,h'%:\'%$ QhoD "5DEc%c%cx%T:\$%h$ h dT  )hT1T:\%h$ h dT)hT X$d|d| XL,ll <0 hT@ D0X \lLzlA<(:\)]@5<m l *klq( l(A<(\,%l(C(5< q( lL:\ d0LXl<,0   arU $`,`1//,`//n'Q#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}@(%H@0xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Module2Module3 lModule4Module5$+QxMExpx"Attribute VB_Name = "Module2" WQjxMEx |`@I  14h "    4( @`      D0x       cvFormat Macro. Macro recorded 3/20/02 by Glenn Edward Murray: This macro changes number format of individual selections Keyboard Shortcut:ent 'Z Z Gl Z 'Zrak Z 'Z 0.00000000 Z$'> Loop thru each item in the selection and convert (if numeric) T  T!^ T$z T 9q8k0k( To Attribute VB_Name = "Module3" Sub cvF@ormat( actor) :.ProcDataInvoke_Func \n14'  ' Macro recorded 3/20/02 by Glenn Edward Murray0This m> changes number f of individual selections<? KeyboRShortcut: sigDi0gits[x ! If (> 0) Then #+ 1End If=6pisWALeft("0.0",Ā<' Loop thru each` iteme  aCconvert (ifM0ericy EIIn SM@.Value <> ""A IsNum(A N With .@qÜ?B THX@HNextA$+QvxMExpx"Attribute VB_Name = "Module4" $+Q}xMExpx"Attribute VB_Name = "Module5" $+QxMEModule6Sheet6 ~__SRP_6 __SRP_7B      !"#$%&'()*+,-./1235789:;<=>?@ABCDEFHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~xpx"Attribute VB_Name = "Module6" <jxQV#<woNfi F7IB / x7IB / woNfiME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@HH0$*\Rffff*0B460e52064xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU Y 4a`rU @n<jxQ#<Bd\ A۵'S FSheet7~__SRP_80__SRP_94B_VBA_PROJECTi;f~2Es4.3x;f~2Es4.3Bd\ A۵'SME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@HH0$*\Rffff*0C460e52074xAttribute VB_Name = "She@et7" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU XY 4a`rU @n0* pHd VBAProject4@j = r  J< rstdole>stdole f%\*\G Bar_Size_WtGCost_LyeQCost_Ingredients~sDecimal_PlacesVLye@MsystemIOilList=OilList2; Type_Of_Lye Type_Of_Lye_table LengthConvp` processCellsxval ActiveCellcvValue{NamesοItemz RefersToRange LenCvValue sigDigits<ValValueK WorksheetsActivate|cval measureSystem  Unprotect?ProtectfDrawingObjectsߺContents= Scenariosk(cvCell<Range RngeNcvValp IsNumeric$*hcvFormatg DecimalPlaces[DecPlcs formatStre NumberFormatR ThisWorkbook| Module2c Module3dcvFactor precision SelectionZ Module4e Module5f Module6g Sheet6 Sheet7CommandButton1|Workbookk WorksheetClick_B_var_Conversionsg_B_var_ConversionTableX_B_var_ConvertSystem9_B_var_ConvertUnits_B_var_Bar_Size_Wt9_B_var_Cost_Lyeڏ_B_var_Cost_Ingredientsx_B_var_Decimal_Places _B_var_LyeQm_B_var_MsystemͿ_B_var_OilList_B_var_OilList2W_B_var_Type_Of_Lye_B_var_Type_Of_Lye_table_B_var_LengthConv_B_var_processCells _B_var_xval__B_var_cvValue_B_var_LenCvValuel_B_var_sigDigits_Defaultj _B_var_cval.H_B_var_measureSystem _B_var_ItemC$      !# %!'")# ( (Module1dir6__SRP_0G __SRP_1wPROJECTwmL{00020430-C 0046}#2.0#0#C:\WINNT\System32\c2.tlb#OLE Automation#^MSForms>!SFEr ms3DD452EE1-E08F-101A-8-02608C4D0BB4 DDOWSEFM20.DLL#Microso(ft : ] Ob Library/;D1t00}t#0#k04AF9A2F334-629A-45A3-820C-A24396C283BA6DOCUME~1\Kat\@LOCALSTemp\Exce l8.0\T.exd K3'F[!׹MKp#jxhGvW%Yڅ`m+N~ygYA$)U8s=+G-btK)Vşlۓ1I,ı/E]{ !@C=(+fKl)J;ͅ97ESSrl8Mz/41L.,\MQ4[3ij4 Excel+ VBAWin16~Win32MacVBA6# VBAProjectstdole`MSFormsCOfficeu Sheet1 _EvaluateConvertor_Clickʒ Application*Run_CommandButton1_Click Sheet2 Sheet3 Sheet4 Sheet5 Module1b(Convert Conversions6ConversionTableŘ ConvertSystem ConvertUnitsih@-e1UH2NHB1ї B,W"B+BU2222R - Z 3 3 3 3 X 4 4 4 V4 ^ 5 5 5 5 \ oduleFouAF2 8_'8!FAThisWorkbookGT`Ui Wbkbok2?K|+Y@Y-!Y/!Y g+! ZoAZZ] ݭjZ[ [/,qv-M-W-G__}_M.6G,6%W*665_{rX@+wX!}<QXVX7}C7 77 9K*y    rU~~~~~~~~~~~~~~O ̓Y+SIU eS_  a      1 Ia  y a ya a 1  VBAProjectSheet1Sheet2Sheet3Sheet4Sheet5Module1 ThisWorkbookModule2Module3Module4Module5Module6Sheet6Sheet7F /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA I q0F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel Ai@0FC:\WINNT\System32\stdole2.tlbstdole aP.E .`M C:\WINDOWS\System32\FM20.DLLMSForms AAi`4bE Cƒ 2C:\DOCUME~1\Kat\LOCALS~1\Temp\Excel8.0\MSForms.exd !AIpL-[DR *C:\Program Files\MSOffice\Office\mso97.dllOffice 9FvAGk4{  F# ETw<DF Worksheet{lFWJOCommandButton1@2iwTimes New Roman1Arial1Times New Roman1Arial1Times New Roman1 Times New Roman1?Times New Roman1>Times New Roman1>Arial1 Times New Roman1hArial1Arial1Arial1>Arial1>Times New Roman1>Arial1Times New Roman1QTahoma1QTahoma1Arial1Arial1Arial1  Courier New1  Courier New1  Courier New1 Courier New1 Arial1 Arial1 Arial1Times New Roman1Arial1  Courier New1>Times New Roman1 Arial1Times New Roman"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.00000.00.0%0.000 "$"#,##0.00 0.00000"Yes";"Yes";"No""True";"True";"False""On";"On";"Off" #,##0.0000 0.000000 0.00000000 0.0000000                + )  , *      0   "8   0  4  4  8  4  !<    <  <  ( "<  @  @ "8 "4 "8 @ "  "    " "   0 "<  " "8 @  < "  (  #  4       I@    H@   @H@     #                         @   @ "      "   # "  #    !     # # #     "      #  ! # #       "  "  "  " !  " I@  " H@  " I@  "  " H@  " H@  " @H@  " @H@  "  "  "  " I@  "  " H@  " @H@  " I@  " H@  " @H@  " I@  " H@  " @H@  "  "  " @A  " "  "  "  "  " I@  "  " @H@ "  "  "  "  " "   '" ( ("  " )" $" H@ # #   "  "  "-  "      # #  !   "       #   " " $" @H@ " ."  /" @  @" @ " " ." . " @ ." "  " " " @ " @." @" @@  " "      "  ") AI@  "  "  "  "   AI@  " I@  " H@  " @H@  " I@  " @H@    ) AI@  "    "     "+ AI@ "+ AI@ "+ AI@ "+ I@  + AI@ "+ AI@ "+ AI@  "+ AI@  "+ AI@ 4# ,0" ,0" @ + AI@   I@   H@   @H@ $" @I@  " H@  ," I@  ," H@  ," @H@     @ 5  5 5 ( 5 h  "  " "  A @5"8 @I@ 6 6# 6" @I@ &< &8 &   @   + AI@  + AA ".+ A @"&+ A#&+ AA &+ A @&+ AA  #  &    &3  1& 2&   @I@    # #  Comma0  Currency0DateFixed  Heading 1  Heading 2  HyperlinkTotal83ffff̙3f3fff3f3f33333f33333@( SAP Values ӱTables0Recipe Worksheet-!Scaled Version;o AutoScaledOFAQ & Release Notes AboutModule1Module2Module3fModule4Module5BModule6 #  l*Igf  dMbP?_*+%M\\SNP5HRTS\SMASTER2pcXXLetter 0l 0txXU0 9''''""XX??Recipe WorksheetScaled Version AutoScaledcU} ed} $.ed} I.ed} ed} m 6ed} m %ed}  ,ed} $ !ed} I!ed} ed} ed} $ ed                                   Fat*Sodium Hydroxide"*Potassium Hydroxide   -INS5Cost per0Specific/Other  Iodine Value INS Computation 7 8NaOH 8KOH9:Oz/Unit= Gravity ;Names <Low <High > Dr. Bob's INS >Est. INS Almond, Sweet rh?eb3k? #A@L L@QC@@X@)A@L , ,B6\Y?  Q)@Z@D;Nё\?@W@@Z@@X@  W@ S IL A&L A&B$#LLLA B Apricot Kernel~ +@k<=? V@4@W@W@[@V@  V@  Arachis rh?eb3k? X@q?sh|??peanut@W@@W@X@  X@  Avocado/$?ev|N? X@x>@V@T@V@X@  @Y@  Avocado Butterkw#?8>y2 ? @Y@~ ?!rh?T@W@  @Y@  Babassu, brazil nutI +?y? l@NbX9?$@4@l@  m@   BayV-?D.? _@@V@LaurelQ@T@  _@   Beef Hoof a+e? |g"g?  _@  CQuV?  neat's foot R@R@_@  ]@    Beeswax Dl? oQ!Ǹ?  U@ ~ C@ 4??  "@&@U@  U@    Borage ^? ͱ]?  I@ ~ o@ I&†?  @`@b@  I@    Brazil Nut~ 1@ NӁl?  l@   NbX9?  $@4@l@  l@    Butterfat, Cow w#? |Q?  g@   x&?  B@B@g@  h@   Butterfat, GoatAf? ? i@ ~ V@.91-.949@B@  i@  Camelina9EGr?V-? B@~ ?a@d@  B@  Camelliaho?u-t? @[@@@V@S@V@  @[@  Candelilla Waxׁ?mҝ]? B@~ HB@rh|?.@4@  B@  Canolam{?F>? L@~ @{F^?[@_@L@  Q@   Carnauba Wax*:H?yI]? R@#U|? DCl?"@,@  R@  Castor.!u?= C? W@4&u`VD?^Q?\(\?D~  X@T@V@W@  X@   Chaulmoogra 7A`?be? R@tV?@`@a@  R@   Chicken Fat y?BbL ? @`@ rh?P@R@@`@  _@   Chinese Bean~ +@k<=? N@?Dl?soybean_@`@N@  O@   Citric AcidʡE?g?6镲 ? ffffff@Q)@Z ~ d@  Cocoa ButterK7?Y*? c@~ ?`"?@@F@c@ _ @c@ID A&D A&B$#DDDA B Coconut~ 3@ƥ?  p@4Hi7?~@B@@XD rh?$@$@ p@ _ p@ID A&D A&B$#DDDA B  Coconut Cream  Coconut Milk  Cod-liver~k ?xVp? =@rvZ?d@d@=@  6@ S1 IL A&L A&B$#LLLA B  ColzaX9v? ʟD? L@ ;)JV?~ V@rapeseed@Z@^@L@  O@   Corn rh?eb3k? @Q@~ @/$?^@^@@Q@  @Q@  Dll<{z' ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  Cottonseed v? Q5??  @V@~ ? MbX?  Y@[@@V@  V@   ! Depot fat!R'?! ?! ! `@ !!K7A`?! Human Fat!h@h@! ! `@! ! "Earthnut" rh?"eb3k?" "X@!"q?"sh|??"peanut"@W@@W@X@ " X@" "  #Emu#a+e?#|g"g?# #`@"~ #0a@###D@T@`@ # ``@# # $Evening Primrose$^?$ͱ]?$ $E@#~ $?$sh|??$$@a@c@$ $ E@$ $ %Flaxseed%^?%ͱ]?% %$)%gtV?%fffff-@ D%~ %V@%linseed%i@i@ % .% % & Goose Fat&gDio?&-t^?& &@`@%&&/폸?&&M@P@@`@ & @`@& & ' Grapeseed'x&1?'4?' 'P@&4'8?)\(@\(\? D''y%?''W@`@P@ ' O@' ' (Hazelnut(z6>W[?(EXY?( (Z@'#(Ln?( D((ˌ%|f?((U@U@( ( Z@( ( ) Hemp Seed)K7?)n@&?) )C@(~ )?)y%?)) b@ d@C@ ) B@) ) * Illipe Butter*|?5^?*V?* *@b@)~ *Q@***E@K@* * @b@* * + Java Cotton+l g?+ 'N%?,zG?\(\?D4~ 4 W@4Pig Fat4@@`a@ 4 `@43 4 5Linseed5^?5ͱ]?5 54)5gtV?5fffff-@ D5~ 5V@55g@`h@ 5 53 5 6 Macadamia6n?6>UH?6 6]@5~ 6?666@R@S@6 6 ]@63 6  7Maize7 rh?7eb3k?7 7@Q@6~ 7@7/$? 7corn7^@^@@Q@ 7 @Q@73 7  8Mango8Mb?8[{?8 8^@78888K@@P@8 8 ^@83 8 9 Mango Butter9x $(~?9=?K?9 9@b@8~ 9PI@999E@I@9 9 @b@93 9  :Manoi~ :3@:ƥ?: : p@9~ :k@: rh?:Coconut,refined:$@$@ p@ : p@:3 : ; Meadowfoam;.1?; 4Wi?; ;S@:~ ;a@;;;W@W@; ; S@;3 ;  <Mink~ <,@< ?#?< <a@;<<<<F@@P@< < a@<3 < =Mustard=ioſ?=0kH?= =L@<= ;)JV?~ =V@=rapeseed=@Z@^@L@ = O@=3 = > Neat's foot>a+e?>|g"g?> >_@=>>CQuV?>>R@R@_@ > ]@>3 >  ?Neem?C??K?? ?_@>~ ?PU@?MbX???U@W@_@ ? Z@?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 [ \ ] ^ _ @ Nutmeg Butter@V-?@)[?@ @@Y@?@@jz~?@@N@@P@@ @ @Y@@3 @  AOliveAx&?A4sE?A A@[@@4Al~?4(\#@\(\?eDAAK7A`?AAS@W@@[@ A @Y@A3 A BOstrichBn?B>UH?B B#Bi(L L@QC@B`@AB)Bi(L , ,BBBBBV@Y@`@ B X@B3 B  CPalmC?5^I ?C6Q?C BC b@BB4Cja/?@B@@XDC~ CV@CCF@L@ b@ C `b@C3 C D Palm ButterD+?D~?D BDf@CBD~ DU@DD$@2@f@ D i@D3 D E Palm KernelEx?Efv0?E BEf@DBE"@U@EE$@2@f@ E m@E3 E F Palm, StearicF?5^I ?F6Q?F BFc@EBFFFFB@F@F F c@F3 F G Peach KernelGK7?GY*?G BGX@FBGGGGW@Y@X@ G @X@G3 G HPeanutH rh?Heb3k?H BHX@GB4H=?AGz@?DHHsh|??HH@W@@W@X@ H X@H3 H IPerillaIgDio?I-t^?I BIHBI~ I@W@I .930-.937I g@i@I I I3 I J Pistachio NutJSt$?Jof?J BJW@IB~ JU@JK7?J .913-.919J@W@X@J J W@J3 J K PoppyseedKݵ|г?K`u?K BKK@JBK~ K W@KKa@a@K K K@K3 K L PumpkinseedLp_Q?Ls ?L BLS@KBLL rh?LL@^@@`@L L S@L3 L  MRamicMX9v?M ʟD?M BML@LBM ;)JV?~ MV@MrapeseedM@Z@^@L@ M O@M3 M  NRapeNX9v?N ʟD?N BNL@MBN ;)JV?~ NV@NrapeseedN@Z@^@L@ N O@N3 N ORapeseedOX9v?O ʟD?O BOL@NBO ;)JV?~ OV@OO@Z@^@L@ O O@O3 O P Rice BranPMb?P[{?P BPQ@OB~ PF@PK7A`?PP[@[@P P Q@P3 P QRicinusQ.!u?Q= C?Q BQW@PBQ2@ X@QcastorQT@V@W@ Q X@Q3 Q R Rose Hip SeedR3ı.n?Rxy?R BR@QB#Rfffff?R fffff%@~ RW@RR`g@`g@R R @R3 R S SafflowerSK7?SY*?S BSG@RB4S]B.?H@? DSSrvZ?SS b@ b@G@ S H@S3 S T Sal ButterTm4?T۶0s?T BT b@SB~ TPR@TTTA@E@T T b@T3 T U Sesame SeedU/$?Uev|N?U BU@T@TB:Upb:#?S$p= ף??@DUU%Fv?UUY@@]@@T@ U @S@U3 U V Shea ButterVMb?V[{?V BV]@UB~ V>@VVVK@Q@]@ V @]@V3 V WShortening (veg.)W rh?Web3k?W BW\@VB4W#P9?Uףp= ??0DW~ WW@WWV@W@\@ W X@W3 W XSoybean~ X+@Xk<=?X BXN@WBX?XDl?XX_@`@N@ X O@X3 X Y Stearic AcidYPs?YZ?Y BYq@XBYY&1?YY@@q@ Y h@Y3 Y ZStearinZb=?Z~/?Z BZq@YB ZZ@@q@ Z `g@Z3 Z [Sunflower Seed[x&?[4sE?[ B[O@ZB4[ػMDq?Wp= ף?\(\?D[[K7?[[`_@`_@O@ [ O@[3 [ \ Sweet Oil\x&?\4sE?\ B\@[@[B<\?\&#@Q)@ZD\\K7A`? \olive\@T@@T@@[@ \ Z@\3 \ ] Tallow, bear]n?]>UH?\B]$ Q]B]]] Bear Grease ] ] ( Q]3 ] ^ Tallow, beef^Cl?^L :?^ B^`b@] BD^g Z?C.(\?{Gz? ?D^^=C#?^Tallow^E@I@`b@ ^ b@^3 ^ !_Tallow, chinese vegetable_|?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 { | } ~  ` Tallow, deer`' ?`s}kU?` B`d@_B`~ ` X@`.96-.97`:@B@d@ ` `d@`3 ` a Tallow, goataݵ|г?a`u?`Bac@aBaa a~ a c@a , Qa3 a bTallow, rabbitby):?bd,?b Bb\@a Bb~ b`W@bbQ@Y@b b \@b3 b c Tallow, sealcO1hm?c r?c BcI@bBc~ cW@cc@`@c@c c I@c3 c d Tallow, sheepdݵ|г?d`u?d Bdc@cBd~ dW@ddD@I@c@ d b@d3 d eTamanue^?eͱ]?e BeT@dBex@V@e .910-.929e[@[@e e T@e3 e f TheobromafK7?fY*?f Bfc@eB~ f?f`"?f cocoa butterf@@F@c@ f @c@f3 f  gTungg`TR'?g|m?g Bg:@fBgggu/?gg`d@e@g g :@g3 g hWalnuth Q?hK?h BhF@gB~ h?hrvZ?hha@b@h h F@h3 h i WheatgermiS㥛?i֍`?i BiM@hBi? W@ii\@a@M@ i L@i3 i j EO, Anise j#jfffff?i fffff"@j kEO, Cinnamon (leaf) k6kZd;O?j '@Q)@Zk  lEO, Cedarwood (Virginia) l6l¨N@?k @Q)@Zl mEO, Eucalyptus m#mL?l L @m nEO, Lavender, 40/40 nn@mn o EO, Lemon o#o\(\?n \(\(@o pEO, Lime p#p?o @p q EO, Orange q#qffffff?p ffffff@q rEO, Peppermint rr?qr s EO, Tea Tree s#s?r #@s t FO, Chocolate t6te;O@s @Q)@Zt uFO, Cucumber Melon uu?t u v FO, Magnolia v0vkt@uQ)@Zv w FO, Plumeria ww?vw xFO, Rose Petals x#x?w %@x y FO,Sea Fresh y#y@x  @y zFO,Ocean Fresh z)z>*@y333333@Q?z { Box, Pill~ {@){K@{ףp= ??{{}?5^I?z D{D{{ |Pigment (candle) |#|?{ ?| }Glycerin }(} ףp= ?|\(\?}MbX9?} Glycerine} ~Glycerin ~#~ffffff?} ffffff!@@~MbX9?~ Glycerine~ 22%+Dldihdcech{gtajgok122%+122%+122%+122%+122%+122%+122%+122%+!1LR %B 22%+122%+122%+122%+122%+122%+122%+122%+122%+122%+122%+122%+122%+122%+0C?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  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% was listed as 30was listed as 30Iwas listed as 195Iwas listed as 195Rhttp://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% MTGhttp://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% eProduct:(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 iWheat 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 jOther Ingredients P=I;v8> A " #   dMbP?_*+%MEPSON Stylus C62 Series(Cold Prpv odhh : < 0.1 Acid Value, mg KOH/g RL*** xhhDLLName32=E_DU16CE.DLL d 2EPSON Stylus C62 Series  ***"dXX??Recipe WorksheetScaled Version AutoScaledcU} ed} ed}  ed}  ed} $ ed} $ ed} $ ed                            Miscellaneous Tables  " Type Of Lye'formula'offset!)Q Cost/Oz Cost/Oz Price Weight in lbs  $Sodium Hydroxide  NaOH~ #@!Q?  DD<@I@  $Potassium Hydroxide  KOH~ #@!? DD??   !!b {? 1RLZZZ% Z8 x p(adjustment for true volume of oils rather than just weight as used in the conversion factor for 'vol to wt cnv'    v was .6818" Conversions' Conv factor' Fluid units( unit,small( unit,Spelled) unit, Big)intraConv Factor) Vol to Wt cnv) Len Units )LengthMetric~  `<@  ml  gm Grams Kilos@@X@ cm~  o@ Standard  g G ?D  Oz  Oz Ounces Pounds~ 0@#  y? y&1`@ In L&d2?D   !!   ^was .3780   "Measurement System &Standard  !!C  ;use instead: 133.376 oz water divided into 231 cubic inches    !!8  0This is the volume conversion for standard TOTAL   "Decimal Places~ #?  !!   !! 'Convert to System'Convert to Unit(To Std! In. to cm "Conversion Factors@3g G ? *Z#3{Bf@40@ *Z#3{Bf^w@? a#`8{BMetric (Metric#:3{Bf@B@3L&d2? *Z#3{ Bf "34@! ' Cu Inch to Oz' cm to grams!! "Vol Conversion Factor%y?Cx={ ףp= ? D!!  !! B Mold TypeAoffset Rectangular~ @ Cylindrical~ @Usage 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) wo 0.3 oz/lb for cinnamon leaf, clove, peppermint, spices, or possible irritants, and up to 0.7 oz/lb for citrus. 8. <bJ}R'%%P=I;v8> " #^ +f  dMbP?_*+%'RQ?)RQ?MEPSON Stylus CX4600 Seriesnnamo odossible irritants, and up to 0.5RL**** xDLLName32=E_FUIC9AA.DLL $d $2EPSON Stylus CX4600 Series @ **** "aX??TablesScaled Version AutoScaledcU} Oed} Oed} I Oed} I Ned} I Ped}  Qed} I Oed} Oed} I Oed} Xed} Xed} $ Xed} $ Oed +`@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@J Recipe Name: Measurements:%WQC`8{ Standard$%%  eRecipe Fat/Water ratio: ~  @Estimated INS Value:xWf@b%Z % B%A&/% %B%% BA B%%% Type of Lye:  Sodium Hydroxide !Est Bar Hardness:WQ#D C 0{Z!  LiquidQDd  Soft3D  hard avg hardness"""Bhardaaaa    &Oil'''''8 Q!"D ;BfNaOHj S OilN Q8Weight (C`8{#3{Bf)BP Weight (Oz)K4 Q5Vol (C `8{#3{Bf)BP Vol (Oz) u%Gj Q1DGrams D, DBPBPounds, Ounces INS SAPNh Q 8Weight (C`8{#3{Bf)BP Weight (Oz) Super-fatting OilN Q$ 8Weight (C`8{#3{Bf)BP Weight (Oz)   Cost Oils Cost SF Oil Sum of Oils Sum of SF OilCoconut~ @@yCłPA@ D rD YD#+:{Bf (DD#X:{Bf""BUUUUUU?@ 6L@@ L B%LL@BQ DGrams D !DZ,AB lb, D &DZfA'AB oz BPB 2 lb, 0 oz W p@ AD /D#:{#)d5{BfB{{RQ?eD SD#:{C )0{#8<{# G6{BfBfBRQ@Q GL@@ A&L@@ @A&B$ LL B  { Dİ QeD  SD #:{C )0{#8<{#G8={BfBfB] DĴ Q GD @@ A&D @@ @A&B$ D D  B D @D rD#:{#)d5{Bf /D#P:{#_d5{BfBDBX@@( 4 *L L B% ,BY QD  rD #:{#)d5{Bf /D #P:{#_d5{BfBD B@X*D D B% $ BHi7@ D D#:{#)p4{Bf ND#P:{#_p4{BfD#y5{B"B Q D  D #:{#)p4{Bf ND #P:{#_p4{BfD #y5{B"BX@@(4 *L L B% ,B@X *D  D  B% $ B Palm~ @@}Rc|A@D rD YD#+:{Bf (DD#X:{Bf""BUUUUUU? 0Q DGrams D !DZ,AB lb, D &DZfA'AB oz BPB 2 lb, 0 oz Wz b@ AD /D#:{#)d5{BfB{~?5^I ?eD SD#:{C )0{#8<{# G6{BfBfB?5^I @   D Q o eL SL#:{C )0{#8<{#G8={BfBfB D Q  Q GL@@ A&L@@ @A&B$ LL B D @D rD#:{#)d5{Bf /D#P:{#_d5{BfBDBX@@(Y Q  L rL#:{#)d5{Bf /L#P:{#_d5{BfBLBX4 *L L B% ,Bja/@(  L L#:{#)p4{Bf NL#P:{#_p4{BfL#y5{B"B Q(  L L#:{#)p4{Bf NL#P:{#_p4{BfL#y5{B"BX@@( X 4 *L L B% ,B  Tallow, beef~ @@ } @@   L rL YL#+:{Bf (LL#X:{Bf""B UUUUUU? Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB 2 lb, 0 oz W z`b@ AD  /D #:{#)d5{BfB{ ~Cl? eD  SD #:{C )0{#8<{# G6{BfBfB Cl@   D Q   D Q   D`@    L rL#:{#)d5{Bf /L#P:{#_d5{BfBLB X@@(  Y Q  X g Z@(   Q D  D #:{#)p4{Bf ND #P:{#_p4{BfD #y5{B"B X@@(  X   }5 Q    Q  Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz W z, Q AD  /D #:{#)d5{BfB ~C0 Q  o  eL SL#:{C )0{#8<{# G6{BfBfB 4 Q   D8 Q   D< Q   D@ Q   X  YD Q  X  H Q(  ~L Q(  X  X   }P Q   T Q   Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz  zl Q  K AL /L#:{#)d5{BfB ~Cp Q   t Q   Dx Q   D| Q   D Q   X  Y Q  X   Q(  ~ Q(  X  X   } Q    Q   Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz  z Q   ~C Q    Q   D Q   D Q   D Q   X  Y Q  X   Q(  ~ Q(  X  X   } Q  ' Q  X QDGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz  z Q  ~C Q   C Q   D Q   D Q   D Q   X Y Q X   Q( ~ Q( X X  } Q L Q  QDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz z, Q ~C0 Q 4 Q   D8 Q  D< Q   D@ Q  XYD QX H Q(~L Q(XX  }9P Q qT Q QDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz zl Q ~Cp Q t Q   Dx Q  D| Q   D Q  XY QX Q(~ Q(XX  } Q  Q QDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz z Q ~C Q | Q   D Q  D Q   D Q  XY QX Q(~ Q(XX  } Q  QX QDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz z Q ~C Q  Q   D Q  D Q   D Q  XY QX Q(~ Q(XX  }d Q  Q QDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz z Q       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`bcdefghijklmnopqrstuvwxyz{|}~~C Q M Q   DQ  DQ   D0 Q  XY4 QX8 Q(~< Q(XX  @ Q D Q QDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz W\ Q AD /D#:{#)d5{BfB{C` QeD SD#:{C )0{#8<{# G6{BfBfBd Q   Dh Q  Dl Q   Dp Q XYt Q Xx Q(~| Q(?Total:!X@ %h!s7a @Y@ %!?" %::\tQDGrams D !DZ,AB lb, D &DZfA'AB oz BPB 6 lb, 0 oz jf@T%w % B%A&!% F8%C8A B!|V-.@ % ?Total:!  % h D! D %  D!ZW !@  %!Z " %!XX@  %!X %IJKLM Lye discount:~ @QDWCP %:~ D@M%"Total Effective Lye Discount: #b @ G&}?LD $8DDDC*4{ADD B#Resulting Water/Lye factor:? DD ^TotalD Q. C`8{#3{BfBP  OuncesFjQ0Z; BfPoundsFj Q0Z; BfOuncesNotes: SOilsTyX@>DD B$"DDC)4{ABY@#CD@@  @%DZ"@ABXyBD@@  @$DZ"@A'Bl hSOther IngredientsO}9D 'DD DC$4{ABYzCD@@  @%DZ"@ABX}BD@@  @$DZ"@A'Bl  SLyei},@SD@@  @4DDD@@C:4{@ABYzCD@@  @%DZ"@ABX},@BD@@  @$DZ"@A'Bl  SWater43333s5@ pD "DdDddDAD 'DD CS4{A"BY?CD@@  @%DZ"@ABX@BD@@  @$DZ"@A'Bl hfSQPTotal D +(dDDA% water)BTotal (16.2% water)!x`@ %&0ja@D%V @R@D@@  @"DC&3{@ABU@?D@@  @!DC&3{@A'Bl ~ X*@u Q"_ After Cure (D  Dd-dDDDDDAB% water)After Cure (11.4% water)efffff&_@OD@@ D B% @&DDDDABGV@@D@@  @"DC&3{@ABU033333)@?D@@  @!DC&3{@A'BJl Y[8Gz]@"D DD$B!^Weight after yield & cureJlV}>[@#4D "%D$p= ף?BGLMJl Y[DKl .}&@BT$AS_~ @!@"@#@$@%@(@*W T oper  nCost Price SProfit l K!8 Q5 Bar Size (D; Bf)BP Bar Size (Oz)~ !@ !oBarC!_6?-D" D" B%D"D#BT!@>D# ,C0{D#D%AD%B8!(f?"D! D!D!B!l "SNumber of Bars?"?@)D A&DD!B B "pBatch"8eP0@D" DD {DDD YC C0{#R<{#ap4{BfD#{5{BB "B8"8ePP@""D" D"D$B8"TИH@#"D" D"D"B"l @#ST Q#*After D$d% overhead lossBPAfter 5% overhead loss?#W;@!)D A&DD!B BD#o Q.C`8{#3{Bf BPOz I# v?#3D D" B%D"D$DB?#Q?!)D" D"DAB8#PY/?!"D# D#D#B # l $Predicted Yield~ $W@$Margin~ $@$J$ Fragrances:$0QjDGrams /DCl3{A gramsBP*D?A ozBPB3 oz$ 0Q$DGrams ? (Based on C!l3{A gms per kg oils)> (Based on C`l3{A oz ppo oils)B(Based on 0.5 oz ppo oils)$  %+%#bar price rounded up to the nearest~ %@ %cents %h (** cpl ]L " @9FR1CommandButton1JBq )  qod- ! !- ! !- ! !- ! !- !- !  .@MS Sans Serifww 0wf- )2 %Convert Measurements    'QKQuick reference for those who use scales that measure in pounds and ounces.KEWhen using "DWCP %", it disables the "Recipe Fat/Water ratio:" input.P=I;v8> " #^ 'o$xin  dMbP?_*+%'zG?)Q?MEPSON Stylus C62 Series it disapv odhht.unces.- !RL*** xhhDLLName32=E_DU16CE.DLL d 2EPSON Stylus C62 Series  ***"dXX??TablesRecipe Worksheet AutoScaledcU} Oed} Oed} I Oed} I Ned} I Ped}  Qed} I Oed} Oed} I Oed} Oed} $ Oed '`@@@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@J^ Recipe Name:O( Q9Z : B(((()`aaaaaaWW e Scale Factor:~ ?aaaaa  WW ebaaaaa`aaaaaaj SOil(j QZ Weight (Oz)(t QZ Vol (Oz)t % of OilsGj Q1DGrams D, DBPBPounds, Ouncest SAPv Q kZ; Bf@ Z8 ;JBfBP Oz NaOH Super-fatting OilV j0Q@ Weight in Z ; BfBP Weight in Oz kRaaOCLQ9Z : B CoconutZy@@DZ $Z DABZyq= ףPA@DZ $Z DAB@UUUUUU?*D@@ DD@BQDGrams D !DZ,AB lb, D &DZfA'AB oz BPB 2 lb, 0 oz {RQ?eD SD#:{C )0{#8<{# G6{BfBfBRQ@Q GL@@ A&L@@ @A&B$ LL BO tQ 9Z  :  BZ xQ DZ  $Z  DAB{ Z|QeD  SD #:{C )0{#8<{# G6{BfBfB] DĀQ GD @@ A&D @@ @A&B$ D D  B  rsOEQ9Z : BPalmZ}@@ DZ $Z DABZ}\(|A@DZ $Z DABUUUUUU? 4 *L@@ LL@BlQ DGrams D !DZ,AB lb, D &DZfA'AB oz BPB 2 lb, 0 oz {?5^I ?eD SD#:{C )0{#8<{# G6{BfBfB?5^I @ O Q 9Z  :  BZ Q DZ  $Z  DAB ZQ  o eL SL#:{C )0{#8<{# G6{BfBfB DQ  Q GL@@ A&L@@ @A&B$ LL B  rsO EQ 9Z  :  B Tallow, beefZ }@@ DZ  $Z  DABZ }= ףp@@DZ  $Z  DAB UUUUUU?  Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB 2 lb, 0 oz   Cl?  o  eL SL#:{C )0{#8<{# G6{BfBfB Cl@ O Q 9Z  :  BZ Q DZ  $Z  DAB ZQ   DQ   rsO EQ 9Z  :  BZ }Q DZ  $Z  DABZ }=Q DZ  $Z  DAB Q  Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz   C Q   c$Q O (Q 9Z  :  BZ ,Q DZ  $Z  DAB Z0Q   D4Q   rsO E8Q 9Z  :  BZ }<Q DZ  $Z  DABZ }@Q DZ  $Z  DAB DQ  Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz   C\Q   `Q O dQ 9Z  :  BZ hQ DZ  $Z  DAB ZlQ   DpQ   rsO EtQ 9Z  :  BZ }xQ DZ  $Z  DABZ } |Q DZ  $Z  DAB Q   Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz   CQ   Q O Q 9Z  :  BZ Q DZ  $Z  DAB ZQ   DQ   rsO EQ 9Z  :  BZ }QDZ  $Z  DABZ } Q DZ  $Z  DAB 'Q HQDGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz   CQ   CQO Q 9Z  :  BZ Q DZ  $Z  DAB ZQ   DQ   rsOEQ9Z : BZ}QDZ $Z DABZ}Q DZ $Z DABLQQDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz CQ QO Q 9Z  :  BZ Q DZ  $Z  DAB Z Q   D$Q    rsOE(Q9Z : BZ},QDZ $Z DABZ} 0QDZ $Z DABq4Q QDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz CLQ PQO TQ 9Z  :  BZ XQ DZ  $Z  DAB Z\Q  ] D`Q GD @@ A&D @@ @A&B$ D D  B  rsOEdQ9Z : BZ}hQDZ $Z DABZ}lQDZ $Z DABpQ QDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz CQ |QO Q 9Z  :  BZ Q DZ  $Z  DAB ZQ  ] DQGD @@ A&D @@ @A&B$ D D  B  rsOEQ9Z : BZ}QDZ $Z DABZ}QDZ $Z DABQ 8QDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz CQ QO Q 9Z  :  BZ Q DZ  $Z  DAB ZQ  ] DQGD @@ A&D @@ @A&B$ D D  B  rsOEQ9Z : BZ}QDZ $Z DABZ}QDZ $Z DABQtQDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz CQ MQO Q 9Z  :  BZ Q DZ  $Z  DAB ZQ   DQ    rsOFQ9Z : BZQDZ $Z DABZ QDZ $Z DAB$QQDGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz {C<QeD SD#:{C )0{#8<{# G6{BfBfB@QO DQ 9Z  :  BZ HQ DZ  $Z  DAB ZLQ   DPQ    rs?Total:!X@$ %:!QY@ %::!?! %::\QDGrams D !DZ,AB lb, D &DZfA'AB oz BPB 6 lb, 0 oz !|V-.@ % ?Total:! ! % : H! D %  XIJKLLM? Lye discount:(w?Zw(ulQZ DWCP %:(w?ZL%"Total Effective Lye Discount: ++ V @ G&}?@D $,DDDADD B W#Resulting Water/Lye factor:(?ZRSQ <Total Z ; BfBP Total OuncesF Q0Z; BfPoundsF Q$ 0Z; BfOuncesjNotes: SOilsfyX@PZ 0Z DC;4{ABTY@CD@@  @%DZ"@ABXyBD@@  @$DZ"@A'BO*Q!9Z : B *** SOther Ingredientsf}PZ 0Z DC;4{ABYzCD@@  @%DZ"@ABX}BD@@  @$DZ"@A'B****  SLyei},@SD@@  @4DDD@@C:4{@ABTYz4RCD@@  @%DZ"@ABX},@BD@@  @$DZ"@A'B****  UWaterf5@PZ 0Z DC;4{ABTY?CD@@  @%DZ"@ABX@BD@@  @$DZ"@A'B****  UTotalJy`@%4D@@  @%@SUBVV @@D@@  @"DC&3{@ABUfffff@?D@@  @!DC&3{@A'BJ**** (dQZAfter Cure (11.4% water)ffffff&_@&PZ 0Z DC;4{ABGV@@D@@  @"DC&3{@ABU033333)@?D@@  @!DC&3{@A'BJ**** JKLG**** DEDl I@ssssssY]&RQP0  @! @" @# @$ @% @& @ Tm nCost T **** X!SQB Bar Size(Z ; Bf)BP Bar Size(Oz)(!@"Z! !oBar(!_6?"Z!!W**** "SNumber of BarsC"?@-D A&DD!B @B "pBatchb"8eP0@LZ" ,Z "Z2B"W**** #W$xNumber of Bars~ $$$ Fragrances:$hQjDGrams /DCl3{A gramsBP*D?A ozBPB3 oz$ ,QDGrams ? (Based on C!l3{A gms per kg oils)> (Based on C`l3{A oz ppo oils)B(Based on 0.5 oz ppo oils)$ ,"%Bar Size(Oz) (before cure)%%ffffDD$A %h  &qBar Size(Oz) (post cure)%& DD$Ax:_=I;v8> " #^ 'irָؽ  dMbP?_*+%MEPSON Stylus C62 SeriesDD$pv odhhA gms per kg oils)>RL*** xhhDLLName32=E_DU16CE.DLL d 2EPSON Stylus C62 Series  ***"bXX??TablesRecipe WorksheetScaled VersioncU} ]er} ]er} I ]er}  ]er} I ]er} ]er} I ]er} ]er} $ ]er ' ` @ @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@@@@@@@@@@@O^ Recipe Name:O(PQ9Z : B(((()R_TQ  < Length ( in C`8{#"3{ Bf)BPLength ( in In) _ Width/Dia  _DepthO`aacMold Dimensionsd-Rectangular mold.@@? O^ Scale Factor: vwu? }Z ]C$`8{@#73{@@BfCW7{ZcBa ftype: Rectangular-Cylindrical mold . @,@ O^bafWeghJJ O`aiash@ ]D DD D >D 'D D D CB:{"B2i@D# 6{BfjOOOO O SOil(jtQ !Z Weight (Oz)(tQ Z Vol (Oz)u % of OilsGjQ 1DGrams D, DBPBPounds, Ouncesu SAPQ  kZ; Bf@ Z8 ;JBfBP Oz NaOH Super-fatting OilV Q @ Weight in Z ; BfBP Weight in Oz  kR OOCQ9Z : B CoconutZy(\u9@ DZ $Z DABZy̌;@ DZ $Z DAB@VUUUUU? *D@@ DD@BQ DGrams D !DZ,AB lb, D &DZfA'AB oz BPB 1 lb, 9.5 oz {RQ?o eL SL#:{C )0{#8<{# G6{BfBfB~bY@(Q GL@@ A&L@@ @A&B$ LL BO Q 9Z  :  BZ =Q  DZ  $Z  DAB{ Z Q eD  SD #:{C )0{#8<{# G6{BfBfB] D$$Q  GD @@ A&D @@ @A&B$ D D  BOOE(Q9Z : BPalmZ}(\u9@ DZ $Z DABZ}Gz;@ DZ $Z DABVUUUUU?(4 *L@@ LL@B4Q DGrams D !DZ,AB lb, D &DZfA'AB oz BPB 1 lb, 9.5 oz ~?5^I ?   @( O PQ 9Z  :  BZ TQ  DZ  $Z  DAB ZXQ  o eL SL#:{C )0{#8<{# G6{BfBfB D\Q(  Q GL@@ A&L@@ @A&B$ LL B OO E`Q 9Z  :  B Tallow, beefZ }(\u9@ DZ  $Z  DABZ }Hz;@ DZ  $Z  DAB VUUUUU?(  Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB 1 lb, 9.5 oz   ~Cl? R\U @(O Q 9Z  :  BZ Q DZ  $Z  DAB ZQ   DQ(   OO EQ 9Z  :  BZ }3Q DZ  $Z  DABZ }pQ DZ  $Z  DAB DQ( (Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz   ~CQ  dQ( O Q 9Z  :  BZ Q DZ  $Z  DAB ZQ   DQ(   OO EQ 9Z  :  BZ }pQ DZ  $Z  DABZ }GQ DZ  $Z  DAB FQ(  TQ DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz   ~CQ  P Q( O Q 9Z  :  BZ Q DZ  $Z  DAB ZQ   DQ(   OO E Q 9Z  :  BZ }=$Q DZ  $Z  DABZ }p(Q DZ  $Z  DAB ,Q(  Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz   ~CDQ  IHQ( O LQ 9Z  :  BZ PQ DZ  $Z  DAB ZTQ   DXQ(   OO E\Q 9Z  :  BZ } `Q DZ  $Z  DABZ }dQ DZ  $Z  DAB hQ( Q DGrams D  !D Z,AB lb, D  &D ZfA'AB oz BPB lb, oz   ~CQ  AQ(O Q 9Z  :  BZ Q DZ  $Z  DAB ZQ   DQ(  OOEQ9Z : BZ}לQ DZ $Z DABZ} Q DZ $Z DABQ(0Q DGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz ~CQ:Q(O Q 9Z  :  BZ Q  DZ  $Z  DAB ZQ   DQ(  OOEQ9Z : BZ}Q DZ $Z DABZ}Q DZ $Z DABQ(lQ DGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz ~CQQ(O Q 9Z  :  BZ Q  DZ  $Z  DAB ZQ   D Q(  OOEQ9Z : BZ}Q DZ $Z DABZ} Q DZ $Z DABjQ(Q DGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz ~C4Q8Q(O <Q 9Z  :  BZ @Q  DZ  $Z  DAB ZDQ   DHQ(  OOELQ9Z : BZ}GPQ DZ $Z DABZ}TQ DZ $Z DABEXQ(Q DGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz ~CpQtQ(O xQ 9Z  :  BZ |Q  DZ  $Z  DAB ZQ   DQ(  OOEQ9Z : BZ}Q DZ $Z DABZ}3Q DZ $Z DABQ( Q DGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz ~CQQ(O Q 9Z  :  BZ Q  DZ  $Z  DAB ZQ   DQ(  OOFQ9Z : BZ=Q DZ $Z DABZGQ DZ $Z DABQ(\Q DGrams D !DZ,AB lb, D &DZfA'AB oz BPB lb, oz CQIQ( O Q 9Z  :  BZ Q  DZ  $Z  DAB ZQ   DQ(  O?Total:!QS@ $ %:! ףp=T@  %::!?  %::\<Q DGrams D !DZ,AB lb, D &DZfA'AB oz BPB4 lb, 12.4 oz !|g?(@  % ?Total:!  % : H! D ! %  OIJKLLMOOOOOO O? Lye discount:(w?Zw(u QZ DWCP %:(w?ZL%"Total Effective Lye Discount: ++ V / "ǩ? @D $,DDDADD B  WOO OOO#Resulting Water/Lye factor:(? ZOOOOOO OORSQ <Total Z ; BfBP Total OuncesNFQ 0Z; BfPoundsF Q $ 0Z; BfOuncesOjNotes:OOOO O SOilsfyS@ PZ 0Z DC;4{ABTY@ CD@@  @%DZ"@ABXy(@ BD@@  @$DZ"@A'BOO*lQ 9Z : B***O OSOther Ingredientsf} PZ 0Z DC;4{ABNYz |SCD@@  @%DZ"@ABX} BD@@  @$DZ"@A'BO****O O SLyei}&@ SD@@  @4DDD@@C:4{@ABTYz CD@@  @%DZ"@ABX}&@ BD@@  @$DZ"@A'BO****O O UWaterf1@ PZ 0Z DC;4{ABY? "CD@@  @%DZ"@ABX? BD@@  @$DZ"@A'BO****O O UTotalJ9Z@ %4D@@  @%@SUB) ףp=[@ DDDDV@ @D@@  @"DC&3{@ABU!@ ?D@@  @!DC&3{@A'BJ****O O(dpQ ZAfter Cure (11.4% water)ffffffX@ &PZ 0Z DC;4{ABGV@ @D@@  @"DC&3{@ABU@ ?D@@  @!DC&3{@A'BJ****O OOJKLGO****O DEl y, FYaoooooooooo$i{Zj_^_ @! @" @# @$ @% @& @ OOTm nCost TO****O !O!S Bar Size(Oz)(!@  Z! !oBar(!_6? Z!!W****O "O"SNumber of BarsC"8@ -D A&DD!B @B "pBatchT"*6zQ*@ ">Z" Z "DB"W****O #$xNumber of Bars~ $$$ Fragrances:$Q jDGrams /DCl3{A gramsBP*D?A ozBPB2.3 oz$ ,Q DGrams ? (Based on C!l3{A gms per kg oils)> (Based on C`l3{A oz ppo oils)B(Based on 0.5 oz ppo oils)$ ,"%Bar Size(Oz) (before cure)%%3333 DD$A %  &qBar Size(Oz) (post cure)%&ffff DD$Ax:_=I;v8> " #^  s  dMbP?_*+%MEPSON Stylus C62 SeriesDD$pv odhhA gms per kg oils)>RL*** xhhDLLName32=E_DU16CE.DLL d 2EPSON Stylus C62 Series  ***"dXX??Recipe WorksheetScaled Version AutoScaledcU ]   @A4Hi, 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 3 -Q,e-,---, S-,- ,d @ - H6-L-#-p*p-  - ""-<"'(-WE*0k*-F-H-*-+,-*,-+-*.+,.* ..-l000-~B11-A4< 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 w< ith 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 int< eraction. 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 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 va< lue 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 than that of canola, no, not really. It just means you're building an additional lye discount into any soap that uses canol< a. 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. DWCP % (Experienced Soapmakers only) ------------------- DWCP %: For Discounted Water Cold Process, enter a value from 33% to 50% (the maximum percentage range for disounting water; below 32 results in a "wet" batch and above 50 results in unreacted sodium hydroxide.) The water calculation of "Recipe Fat/Water ratio:" is disabled when using the DWCP %. After Cure calculation ---------------------- The After Cure weight is an es<Gtimate 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 ratio 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' 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.]  0  Xi @0!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.a; `G X  3(p<  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). Auto Scaling An auto scaled worksheet is provided so you can just enter a recipe you like then go to the auto scaled sheet and enter the dimensions of the mold (and the mold type you want to use). The correctly scaled recipe will be produced to the size / type of mold you enter. It will also produce a scaling factor, for those interested. When using DWCP%, the computed weight of the oils will increase as the water is decreased to ensure the mold is filled to the specified dimensions. If you have a specific mold you always use, then putting it's dimensions into the worksheet template, then saving in the template directory should save time when scaling the recipe. The volume to weight conversion factors are located on the 'Tables' worksheet as "Volume Conversion Factor" and correspond to a 4/3 ratio of total weight to oil weight times the avg oils specific gravity, then inverted. This will< multiply times the volume (in Fl Oz or milliters) to yeild the weight of oil (in Oz or gms). The ratio of the computed weight to the weight on the 'Recipe Worksheet' is displayed and used to compute the displayed ingredients amounts.]     @c(0 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. @c=I;v8>  #^    dMbP?_*+%MQMS magicolor 2+ d odXLetterf Information -----------PRIV''''e Letter"dX??Recipe WorksheetScaled Version AutoScaledc U ]   < @7@pj 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 tweaking or otherwise playing with recipes. Additionally, I was dissatisfied with the inconvenience and lack of utility of the available on-line lye calculators, so I decided to put 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.xlt is released, or when the new stand-alone application version is done (many, many new features), send me an email and I will put you on the list. I should also mention that the new, 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. media and/or postage). 3) Blah, blah, blah, blah. Now go make some soap! Happy Soaping, Chris r  n 5`6 7=I;v8>  #"`ceDk of??av=I;v8> I;v8 #"I??av=I;v8> I;v8 #"I??av=I;v8> I;v8 #"I??av=I;v8> I;v8 #"I??av=I;v8> I;v8 #"I??av=I;v8> I;v8 2449ec685#&4449ec6856449ec685%(8449ec685a449ec685')c449ec685SummaryInformation(+DocumentSummaryInformation8LengthConv'+ length Measurement conversion2'e . Get conversion factor j !*%4!@. !*%4!@.J !*%4!@!j$`'TRecipe Worksheet$tB@ !*%4!@!j' Get curr measurement sys value@ Compute new conversion factor and decide new measurement system2 MetricStandard' T 'Te` StandardfMetric'e T 'T`'gg Tables$tB@by- Worksheets("Recipe Worksheet").Unprotect9 Set new values for Sig digits and the measurement system T !*%4!@(j  !*%4!@(j6Tables$tB@ Convert the Oil weightsfC8:C20$ A9 Change expressed significant digits for oil wts & volume/ Call cvFormat(Range("C8:D21"), sigDigits)0 Change expressed significant digits for lye wts3\ Call cvFormat(Range("H8:H21"), sigDigits + 1) ' always has an extra significant digit6$Convert the Superfatting Oil weights6K8:K20$ Ae< Change expressed significant digits for superfatting oil wt/ Call cvFormat(Range("K8:K21"), sigDigits) Convert the Bar weightsf !*%4!j$ Af6 Change expressed significant digits for total weights0 Call cvFormat(Range("c26:f32"), sigDigits) No sig digits for Lbs/KgsI Call cvFormat(Range("e26:e32"), 0) ' Always no decimal places here- Convert prices to reflect new units for Oils( Worksheets("SAP Values").UnprotectU Call cvCell(Range(Application.Names.Item(Cost_Ingredients).Value), 1 / cvValue)\ Worksheets("SAP Values").Protect DrawingObjects:=True, Contents:=True, Scenarios:=True<- Convert prices to reflect new units for LyesM Call cvCell(Range(Application.Names.Item(Cost_Lye).Value), 1 / cvValue)M ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True AutoScaled$tB@ s AutoScaled$tB@6I3:K3$ JAemj4:k4$ JA: AutoScaled$tB@Recipe Worksheet$tB@g B@1k,5 cvCell subroutine T' Macro recorded 3/20/02 by Glenn Murray39 This macro converts individual selections by multiplying$ against a stored conversion factor.203> Loop thru each item in the selection and convert (if numeric) 4  4!j8 4$  4f5j 9jemgg 43k cvFormat subroutine' Macro recorded 3/20/02 by Glenn Murray9: This macro changes number format of individual selectionsB based on the parameter sigDigits. DecimalPlaces is used to change( the number of decimal places displayed.e8 Compute new format String '* * 1 * '*>g * '* 0.00000000 *$@'4D Loop thru each item in the selection and change format (if numeric)f 4 3 4!j 4$  4 49Jmgg 4knits't+/ Conversion factor for converting between units? Bar_Size_Wt'+& Bar size in (current) units of weightCost_LyAN7NN,J y C lLe,ɂ \ueɂ te5Macro recorded 3/20/02 by Glenn Edward Murray C eci!tɂ _Oɂ   ME"  .(8X6HJLd6NNXJ@"4@XT*>6XB086<t | $ D Fd     (,084P@(,L@h66b *|  B 6 @ &` < 6  P 4l . \ b, 4 T T l    ,  ( ,8"<@H`.h@* D Xd x   ".@HT. $(8JT     j Convert Macro' Macro recorded 3/20/02 by Glenn MurrayX2 This Macro will convert the entire worksheet from0 Standard (English) to Metric measurement units.25llB ** Programmer note: Currently the significant digit correction isC commented out, due to a bug. When it is run, the initial unprotectE of the Recipe Worksheet fails. I haven't found out why. Glenn Murray Constants - Names Conversions'T+ List of measurement systemsConversionTable'`+0 Table of measurement systems convertion factors ConvertSystem'j+1 Conversion factor for converting between systems ConvertUnits't+/ Conversion factor for converting between units? Bar_Size_Wt'+& Bar size in (current) units of weightCost_Lye'+ Cost of Lye6Cost_Ingredients'+! Cost of Ingredients (except Lye)Decimal_Places'+8 Number of optimally displayed decimal places (inactive)Lye'+ Which lye is being usedMsystem'+' Which measurement system is being used3OilList'+ List of Ingredients, except LyefOilList2'++ Table of Ingredient properties, except Lye8 Type_Of_Lye'+ List of types of LyeType_Of_Lye_table' Table of Lye properties ME1NgNN<0 ɂj l  ME " 4$@XD `l     cvFormat Macrots. Macro recorded 3/20/02 by Glenn Edward Murray: This macro changes number format of individual selections Keyboard Shortcut: j'T T  T 'T@g T 'T 0.00000000 T$@'t> Loop thru each item in the selection and convert (if numeric) 4 lu 4!jva 4$  4ys t9Jmgg 4ink1N+CNNME1N+CNNMEN+CNNMEa] m*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#C:\WINDOWS\System32\VBAEN32.OLB#Visual Basic For Applicationsoma>*\G{00020813-0000-0000-C000-000000000046}#1.0#409#xl5en32.olb#\*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automation~*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.0#0#C:\Program Files\MSOffice\Office\mso97.dll#Microsoft Office 8.0 Object LibraryQ  2449ec685 1449ec685*D4 4449ec685 3449ec685*DT 6449ec685 5449ec685*D` 8449ec685 7449ec685*D a449ec685 9449ec685*D c449ec685 b449ec685*D*@ TT4T`4 @ j tjt J`J4` j@tJ+ `u b(0:6BŘN`inG|Q~sV@Ie=;* p`{ **(ο4z:@N<ZdKhn|z ?fߺ=k< Np$*g[e{$R*c8d@HRZ\effn(gvVBAExcelVBAProjectstdoleOfficeModule1_EvaluateConvertConversionsConversionTableConvertSystemConvertUnitsBar_Size_WtCost_LyeCost_IngredientssDecimal_PlacesxLyeMsystemOilListOilList2Type_Of_LyeType_Of_Lye_tableLengthConvprocessCellsxvalActiveCellcvValueApplicationNamesItemRefersToRangeLenCvValuesigDigitsValValueWorksheetsActivatecvalOmeasureSystemUnprotectProtectDrawingObjectsContentsScenarioscvCellRangeSelectRngecvValIsNumericcvFormatDecimalPlacesDecPlcsformatStrLeftNumberFormatModule2Module3cvFactorprecisionSelectionModule4Module5Module6 5Ua*   lOh+'0 PXt Rainbow Meadow Inc.Chris MathesKathleen K KochMicrosoft Excel@.Ʋ@6olJ@ |    ՜.+,08@ `h p hDepartment Of Defense  SAP ValuesTablesRecipe WorksheetScaled Version AutoScaledFAQ & Release NotesAbout Bar_Size_Wt ConversionsConversionTableConvertSystem ConvertUnitDecimal_Places LengthConvLye Mold_Type MoldType MoldVolumeMsystemNormalizeCostOilList OilList2AutoScaled!Print_Area'Recipe Worksheet'!Print_Area'Scaled Version'!Print_Area Type_Of_LyeType_Of_Lye_tableVol_Conversion_Factor  Worksheets Named Ranges F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89qCompObj m