­¦ý°±·>œ œÄ›¼À  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrt†uvwxyz{|}~ÅRoot Entry ¿F  ù‘Ǧ¡ƒ¾¹ Ÿ–¡sdÄWorkbookÝ```p0 &P Ä f`_VBA_PROJECT_CUR0 `P Ä"%P©ïŸŸ–¡0iŽŸ–¡ ð0 Ctlse5P Ä ÝÝ` (p0 TÄœ  !"#$%&'()*+,-./01234567œ9:;<=>?@ABCDEFœHIœKLMNOPQRSTUVWXYZ[\œ^_`œœcdefghijklmnopqrstuvwxyœ{|}œœÄ¿ ý ¨@¿ ý€ ¨@¿ ý€ ¨@ ¿ ý€ ¨ ¿ ý!¿ ý"ò¿ ý ¨@ ¿ ý ¨@ ¿ ý ¨@¿ ý ¨@ @¿ ý ( ¿ ý"X- ý #¿ ý€ ¨@ ¿ ý§!<¿ ý€ ¨@@¿ ý€ ,¿ ý€ ¨@ ¿ ý ¿ ý ( ¿ ý§ ¿ ý"½¿ ý¶ ¿ ý ¿ ý ¨¿ ý ¨ ¿ ý ® @¿ ý ® ¿ ý ® ¿ ý (@ ¿ ý ®@¿ ýß ¨@ @¿ ýß ¨@ ¿ ýß ¨@ ¿ ý€ ¨@@¿ ý ¨¿ ý ¨@@ ¿ ý Ý¿ ý à¿ ý¶#¿ ý ¨@ ¿ ý  ¨ @¿ ý  ¨ ¿ ý  ¨ ¿ ý  ¨@¿ ýß §¿ ý§ <¿ ý <¿ ý (¿ ý¶#¿ ý#¿ ý!8 ¿ ý® ,@ @¿ ý® ,@ ¿ ý€ ¨@ @¿ ý€ ¨@ ¿ ý §"<¿ ý§ ¥¿ ý§ , ¿ ý!8¿ ý© §¿ ý Ý ¿ ý  ¿ ý "8¿ ý§"4¿ ý"8 ¿ ý0 ¿ ý§"4 ¿ ý  ¿ ýß § ¿ ý  ¿ ý§"º¿ ý ƒ¿ ý§"¥¿ ý© ú¿ ý"ò¿ ý¶"< ¿ ý€ ,@ ¿ ý ¿ ý¿ ý#4¿ ý §"º¿ ý§ §¿ ý§ § ¿ ý§#¥¿ ý ÚÊ`·ƒ¡’\pGlenn Edward Murray Bƒa= ²† ThisWorkbookúغ=K 5ð"8œ@ç"…Ž1»êArial1»êArial1»êArial1»êArial1»ºArial1.»êTimes New Roman1.»ºTimes New Roman1.» êTimes New Roman1»ºArial1&»ê Courier New1.@êTimes New Roman1.êTimes New Roman1.•ºTimes New Roman1»êArial1.ÝêTimes New Roman1.ݺTimes New Roman1.»êTimes New Roman1»êArial1ݺArial1ÝQêTahoma1ÝQºTahoma1.» ºTimes New Roman1»êArial1&»ê Courier New"$"#,##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.0000€0.0 ¶0.0% ß0.000® "$"#,##0.00 ©0.00000ýž ¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ýž Ù¿ ý ¿ ý+ž ¯¿ ý)ž ¯¿ ý,ž ¯¿ ý*ž ¯¿ ý ž ¯¿ ý"8¿ ý ¿ ý 0¿ ý§ 4¿ ý0¿ ý ¿ ý¶ ¿ ý§ ¿ ý ¿ ý#¿ ý ò¿ ý ( ¿ ý ¿ ý¶ ¿ ý§ ¿ ý#8@¿ ý#8¿ ý (¿ ý¶ ,¿ ý§ ,¿ ý ,¿ ý#8¿ ý¶!º¿ ý€ ¿ ý€ å¿ ý#¿ ý ¿ ý!ú¿ ý¿ ý ®@ @¿ ý ®@ ¿ ý ®@ ¿ ý ¨¿ ý ¨@ @¿ ý§ ¨@ ¿ ý ¨@ ¿ ý ¨@ ¿ ý§ ¨@¿ ý ¨@¿ ý€ ¨@ @¿ ý€ ¨@ ¿ ý€ ¨@ @ ¿ ý å¿ ý ¨@@¿ ý€ ¨ @¿ ý ¨@¿ ý€ ¨ ¿ ý¶ ¨¿ ý à¿ ý#½@¿ ý#½¿ ý ®¿ ý§ ¨¿ ý#½¿ ý¶!º¿ ý¶ å¿ ý§ å¿ ý å¿ ý à¿ ý§ å¿ ý€ ¨@¿ ý€ å¿ ý½¿ ý§ ¨@¿ ý ¨¿ ý¶ ¨¿ ý ®@ @¿ ý ®@ ¿ ý ®@ ¿ ý 4¿ ý  8¿ ý ò¿ ý (¿ ý€ ¨¿ ý€ ¨@ ¿ ý€ ¨@¿ ý 4¿ ý §#4¿ ýß#¥¿ ýß#4¿ ý 0 ¿ ý§"< ¿ ý ¿ ý §"º ¿ ý "8 ¿ ý  < ¿ ý§"º ¿ ý  ( ¿ ý§"t ý ` ý ¨¿ ý§ ¿ ý ¿ ý (¿ ý à¿ ý§ ¨¿ ý#½¿ ý€ ¨ @ ¿ ý ® ¿ ý#¿ ý ¨@ ¿ ý§ $¿ ý© 4¿ ý§ ¿ ý ,¿ ý ú¿ ý"<¿ ý "8¿ ý "¿ ý(ÿ¿ ý ÿ¿ ý ÿ¿ ý"¿ ý½@@¿ ý½@¿ ý0 @¿ ý½@¿ ý½¿ ý0 ¿ ý½@ ¿ ý½ ¿ ý0 ¿ ý#¿ ý#¿ ý ò¿ ý ¿ ý"ÿ3 ý ê¿ ý½ @¿ ý½ ¿ ý½ ¿ ìÄìÄìÄìÄìÄìÄ`Öj3 SAP ValuesÖÔïTablesÖ´ÝRecipe WorksheetÖ8“Scaled VersionÖ FAQ & Release NotesÖ 8ZAboutåÆ! Bar_Size_Wt:!% Conversions; ) ConversionTable;c# ConvertSystem:! ConvertUnit:CostCol$Decimal_Places: INSColLye:  LyeOffColMsystem: # NormalizeCost:! OilList;k" OilList2;k% Type_Of_Lye;+ Type_Of_Lye_table;UnitsSÎo•g•H  <  /•ð•$U"•©2›˜3ö¦+JNp–oÖU@=•}2›˜3ö¦+JNp–oî ü N—ËÇKœxúµUÕOSAüðW^·âàµR-E5®G`¯0Dõ´@£ˆÅí¥ÖÁ¡Ÿw•hbb<(¸ ûçÈÅ51·Ón6r!5©3šv™M Í6øvfÁ{fw+ý1Ñk1d•sÁ>[ÈôÃ,ÄÄ7¿8Ó¤­¥"ŒõM"4Ñy 0ç½3=7Ö*>È‘}IÚ+í zU¯Ú² YH#rêᢢ\(¿",ód}ž÷¦‰N?O$ûÓ‰ý¿IN|¯¯²¸•Ì½’?‡ç'Ê—b ºÉ’»Kø;ÚLo§{Î’»izó_W‹ïõ„ÖƒÛæëþUæPw~Tž®k¹“æë^7 íOÝ<ø\è'H«ð蛄*Q_UèÁO‡Ï7™›±ÉËÅ`FØÁÅþƒ_… ,ãCpvËŽzè‘ ÕØÑòÇeú¿Í~ ÁêA*áYAÞÖ%D—ãÍ*ŽÑà«ÿ… yT«4mH>Ρ#R“:QÓ3M#×Ù§ÔBx6©ó @êýV@‡ZÄT@ZÄV@¿X@  @Y@  › ]£köwú¢#¡?£8>éy2 »?@Y@~ µ”?› êó‡ZT@Z¿W@ @Y@ › £†I +á?£Þ yö¦?¿l@êNbX9¥Ï?‡Z$@Z4@¿l@  m@  › ¬£ìV-¬?£®D.›äŠ? Ä_@ ‡µ¯@êV@› °†‡„Q@„T@ „ „Ä_@ ›  £aˆ²+e¡?D:¿ £¹ð|g"g»?  º$ ( L¿ÕÃÃÃà L@ÖÎQ½œC@ _@ êCQu VÌ?› °n‡ ZR@ZR@_@  ¿]@  › [ £DãlÁš©±? £oQ!´«½?  U@ ~ µC@ êâ4Ç?ËÓ?‡ Z"@Z&@U@  ¿U@  › Z £öû^¡? £þÕ±¦•]»?   ÄI@ ~ µÝo@› êó‡ Z@`@Z¿b@ ÄI@ › ~ £Ä1@ £Né²Ål¦?   ¿l@  êNbX9¥Ï?uD¿‡ Z$@Z4@¿l@  ýl@  ›   £öwú¢#¼Ÿ? £Œ¯ö|QÕ?   ýg@  êÙ›ŒxÈ&Ì?‡ ZB@ZB@ýg@  h@  ›  £×ÚA¦f‰?£‘ „Û‘?  Ýi@ › êó‡Z>@Z>@ Ýi@  › d£9EGr˜¡?£V-¾ùÔ«? ÄB@~ µÄ”?› êó‡ZÄa@Zd@ ÄB@  › g£¨ã¤ho¡?£u-ÀÏt»? @[@‡…@@¼ýV@‡ZÄS@ZV@ @[@  › w£›áÙ¤×Å£?£©Çm³ù]´? B@d~ µHB@êƒrhëÌ|Ô?‡Z.@Z4@ B@  ›  £m‰œ¾{Ú¿?£ÇFá>«? L@~ µÄ@ê{¯F^Ì?‡ZÄ[@ZÄ_@L@  Q@  › x£*:íÀHØ?£yßI]Òµ? ¿R@d …»?1êÅïCãlÁÔ?‡Z"@Z,@ ¿R@ ›  £.!›–u¿?£= Cê«? ¿W@‡µº2@ê X@‡ZT@ZÄV@¿W@  X@  › ¡£7âA`­¬?£¾²­be ?  R@êºtìVÓ?‡Z@`@ZÄa@ R@ ›  £ µ¶y«¡?£BÕbL Ò»? @`@› êó~  @`@ \µ  › ~ £+@£k<ˆ=»? ÄN@µãدäØò?àDãlÁš©Ì?DT¿› °m‡Z_@ZÄ`@ÄN@  O@  › £•ßK7â¡?£ÝµY*„ô»? Ýc@~ µ‘?ê`­"¤˜Ó?‡ZÄ@@ZF@Ýc@  @c@  › ö~ £3@£ù€‹?  p@6~ µ•@ê‰ ƒrhëÌ?‡Z$@Z$@ p@  p@6  › £~å¼k ˜¿?£xVÊp¦«? =@ê±rvøZƒÌ?‡ZÝd@ZÝd@=@  6@  › £X9¥»væø?£ ® üD? L@µó ;)JºV?àH·zÆGÌ?9DK¿› °l‡Z@Z@Z^@L@  O@  › £úŸ ƒrh¡?£‹eb3ªk»? @Q@~ µÄ@ê/ð$ÅÌ?‡ZÄ^@Z¿^@@Q@  @Q@  › £výú€‡¡?£Q5¾Ë?“»? @V@~ µˆ?êÚ³MbXÌ?‡Z¿Y@Z¿[@@V@  V@  › º£R'Ý⃷¡?£ è´­Š?   `@¼«K7âA`Ì?› °‡‡Zh†@Zh†@ Z Z `@ › £úŸ ƒrh¡?£‹eb3ªk»? ¿X@µðqäé”ÚØ?àshëÌ|?Ì?DD¿› °k‡Z@W@Z@W@¿X@  ÄX@  ×Dšlííq´ÿØØ´¡Ó¼Ø¥´°Ø©„¼Ø€ôŒ¼µ´ÿ¼¼‡ T0! " # h(ç$ š% & ' ( ) P* ., + , ¾w - T0. BUBE/ 0 1 Â2 3 ù04 5 6 Â7 o@8 9 m: ; ‰0«< = Â> ? › Y £aˆ²+e¡? £¹ð|g"g»?  `@~ …0a@› ¼ó‡ ZD@ZT@`@  ``@  › !\!£öû^¡?!£þÕ±¦•]»?  !ÄE@ ~ !…“?!¼shëÌ|?Ì?‡!Z@a@Z¿c@! ÄE@  › ""£öû^¡?"£þÕ±¦•]»?! "¿!"º-"5#L¿  ,¿ ,¿B"…fffffÊð?ND1¿~ "¼ýV@› "°ê‡"ZÝi@ZÝi@¿ " .¿! " º["5 QL›¿ A&Lœ¿ A&B$&L¯¿ËL›¿Lœ¿AŒ B› ##£gDio•Ö¡?#£§-t^ï»?" #@`@""#¼Í/Ìè½Ì?‡#ZM@Z¿P@@`@ # @`@" " › $$£œŒxÈ&1¿?$£€Ô4â…?# $ÄP@#"~ $…ˆ?$¼yµÍë%®Ì?‡$ZÄW@Zý`@ÄP@ $ ÄO@# " › %%£z6´>W[¡?%£”EÃXY»?$ %Z@$"%…”?"%¼¥Àå%|fÌ?‡%Z¿U@Z¿U@% Z@$ " › &&£ûÔßK7¡?&£nÔ@«&»?% &ÄC@%"~ &…ð?&¼yµÍë%®Ì?‡&Z b@Z d@ÄC@ & B@% " › '`'£Ó|?5^†¡?'£V‚ÃßÞ»?& '@b@&"~ '…êQ@› '¼ó‡'ZÄE@ZÄK@' @b@& " › ((£l ˜Ýg„¬?(£þ Ò§< ?' ([@'"(† е%D*¿› (°j(Z@U@6D*¿(ZÄ[@(D*¿( [@' " › ))£DãlÁš©±?)£oQ!´«½?()º$)H L¿ÕÃÃÃà L@ÖÎQ½œC@)&@("~ )…úK@› )¼ó‡)ZT@Z@U@&@ ) .@( " › **£l ˜Ýg„¬?*£þ Ò§< ?))*[@)"› *¼ó‡*Z@U@ZÄ[@* [@) " › ++£¸©Ò³Mb¿?+£[Áß{šš?*)+]@*"~ +…0A@› +¼ó‡+ZÄK@Z¿Q@]@ + @]@* " › ,,£úŸ ƒrh¡?,£‹eb3ªk»?+),¿X@+",½ðqäé”ÚØ?(DD¿,†shëÌ|?Ì?,DD¿› ,°k,Z@W@(DD¿,Z@W@,DD¿~ , ¿X@, ÄX@+ " › -e-£öû^¡?-£þÕ±¦•]»?,)-`c@,"~ -…Á?› -¼ó‡-Z@@ZD@- `c@, " › .~ .£+@.£k<ˆ=»?-).8@-"~ .…ú]@› .¼ó‡.Zd@Zýe@8@ . 6@- " › / /£ú3¢¥7¯¾?/£w3‰^åú†?.)/¿T@."/¼jºtìÓ?‡/Z1@Z=@¿T@ / @T@. " › 0!0£DãlÁš©¡?0£oQ!´«»?/)0`a@/"~ 0¼ W@› 0°æ‡0Z”@Z”@`a@ 0 ý`@/ " › 1"1£öû^¡?1£þÕ±¦•]»?0)1¿0"#1…fffffÊð?, fffffÊ-@ ~ 1¼ýV@‡1ZÄg@Z`h@¿ 1 ¿0 " › 2#2£ònÉ¿ ¡?2£>UH£ž»?1)2¿]@1"~ 2µÄ­?› 2¼ó‡2Z@R@Z¿S@2 ¿]@1 " › 3$3£úŸ ƒrh¡?3£‹eb3ªk»?2)3@Q@2"~ 3…Ä@3¼/ð$ÅÌ? D¿› 3°v3ZÄ^@,D¿3Z¿^@3D¿~ 3 @Q@3 @Q@2 " › 4%4£¸©Ò³Mb¿?4£[Áß{šš?3)4^@3"› 4¼ó‡4ZÄK@Z@P@4 ^@3 " › 5a5£x $(~å¡?5£õ=?–Kû»?4)5@b@4"~ 5µPI@› 5¼ó‡5ZÄE@ZI@5 @b@4 " › 6õ6£R½ÖÎQ»?6D¿6£ù€‹?5)6a p@ D¿~ 6ú¯k@6¼‰ ƒrhëÌ?3D¿› 6°ò6Z$@3D¿6Z$@6D¿6 a p@D ¿6 ap@6 D ¿› 7b7£.êݯ1Êæ?7£ˆ 4Wi¨‰?6)7ÄS@57º-7Y##L¿  ,¿ ,¿B~ 7µ®a@› 7¼ó‡7ZW@ZW@7 ÄS@5 7 º[7d -QL›¿ A&Lœ¿ A&B$&L¯¿ËL›¿Lœ¿AŒ B› 8&~ 8£,@8£ €?õ#Š?7)8¿a@77› 8êó‡8ZÄF@Z@P@8 ¿a@7 7 › 9'9£ioʼnø?9£0ƒk¥H?8)9L@879µó ;)JºV?9êH·zÆGÌ?DK¿› 9°l9Z@Z@6DK¿9Z^@9DK¿~ 9 L@9 O@8 7 › :(:£aˆ²+e¡?:£¹ð|g"g»?9):_@97:êCQu VÌ?‡:ZR@ZR@_@ : ¿]@9 7 › ;);£œC™Ìο¡?;£K‡ó¥ÿÁ»?:);_@:7~ ;µPU@;êÚ³MbXÌ?‡;ZU@ZÄW@_@ ; ÄZ@: 7 › <*<£V-¾‡?<£´)Ë[ŒŸ?;)<@Y@;7<êj¯zì~Ô?‡<ZN@Z@P@< @Y@; 7 › =ô=£Ù›ŒxÈ&¡?=£4sEÀ»?<)=@[@<7~ =µ•@=ê«K7âA`Ì?‡=Z¿S@Z¿W@@[@ = @Y@< 7 › >h>£ònÉ¿ ¡?>£>UH£ž»?=)>`@=7› >êó‡>ZÄV@Z¿Y@`@ > ¿X@= 7 › ?-?£?5^†I ¬??£ŽÙ6ìQŠ?>)? b@>7‡?µ„?êýV@‡?ZÄF@ZÄL@ b@ ? `b@> 7 ×D‡lµ„d´¼¼ØËð°µر´µ‘Ø°Ø"?ù´¼€¼ß@ T0A B C h(çD šE F G H I PJ ., K L ¾w M T0N BUBEO P Q ÂR S ù0T U V ÂW o@X Y mZ [ ‰0«\ ] Â^ _ › @+@£+á‘—ˆ?@£—°¥~Ã?9)@ýf@@7~ @¼¿U@‡@Z$@Z2@ýf@ @ Ýi@? 7 › A,A£Û›ŒxÈ?A£‰fv×0­?@)Aýf@A7‡A…"@¼¿U@‡AZ$@Z2@ýf@ A ¿m@@ 7 › B.B£?5^†I ¬?B£ŽÙ6ìQŠ?B )BÝc@A7› B¼ó‡BZÄB@ZÄF@B Ýc@B7 › CoC£•ßK7â¡?C£ÝµY*„ô»?B)CX@C7› C¼ó‡CZW@ZY@X@ C @X@A 7 › D/D£úŸ ƒrh¡?D£‹eb3ªk»?C)D¿X@D7D…ðqäé”ÚØ?D¼shëÌ|?Ì?‡DZ@W@Z@W@¿X@ D ÄX@C 7 › E0E£gDio•Ö¡?E£§-t^ï»?E )E¿D7› E¼ó‡EZ`h@Z`h@E ¿E7 › F^F£èSt$ó¿?F£of±°ÿ«?F )FW@E7~ F…U@› F¼ó‡FZ@W@ZX@F W@F7 › G1G£ðµÑ|­„¡?G£`ùÖu¹»?G )GÄK@F7~ G¼ W@‡GZÄa@ZÄa@G ÄK@G7 › H2H£p_‘Q¬?H£s ¿¾Š?H )HS@G7H¼‰ ƒrhëÌ?‡HZ@^@Z@`@H S@H7 › I3I£X9¥»væø?IDK¿0I£ ® üD?HDI¿ÕÃÃÃà L@ÖÎQ½œC@IL@I7I…ó ;)JºV?IDK¿I¼H·zÆGÌ?IDK¿› I°lIZ@Z@IDK¿IZ^@IDK¿~ I L@I O@D 7 › J4J£X9¥»væø?JDK¿0J£ ® üD?IDJ¿ÕÃÃÃà L@ÖÎQ½œC@JL@J7J…ó ;)JºV?JDK¿J¼H·zÆGÌ?JDK¿› J°lJZ@Z@JDK¿JZ^@JDK¿~ J L@J O@I 7 › K5K£X9¥»væø?0K£ ® üD?JDK¿ÕÃÃÃà L@ÖÎQ½œC@KL@K7K…ó ;)JºV?~ K¼ýV@‡KZ@Z@Z^@L@ K O@J 7 › L6L£¸©Ò³Mb¿?L£[Áß{šš?L Lº$LaL¿ÕÃÃÃà L@ÖÎQ½œC@LÄQ@K7~ L…•F@› L¼ó‡LZÄ[@ZÄ[@L ÄQ@L7 › M7M£.!›–u¿?MD¿M£= Cê«?LLM¿W@M7M½{ÆG·™«?MD¿M¼·zÆG·Ó?MD¿› M°pMZT@MD¿MZÄV@MD¿~ M ¿W@M X@K 7 › N_N£3Ÿ±.n£¡?N£xžÖâyæ»?MLNlµN7#N…fffffÊž?a fffffÊ%@› N¼óN 4#µN7 › O8O£•ßK7â¡?O£ÝµY*„ô»?N LOÄG@O7~ O…ˆ?O¼±rvøZƒÌ?‡OZ b@Z b@ÄG@ O H@M 7 › PyP£÷‰m4Ä…¿?P£¤—0Äs«?P LP b@O7~ P…PR@› P¼ó‡PZÄA@ZÄE@P  b@P7 › Q9Q£Ý/ð$¡?Q£ev|N²·«?PLQ@T@Q7~ Q…Ä­?Q¼%F§ÄÊvÌ?‡QZ¿Y@Z@]@@T@ Q @S@O 7 › R:R£¸©Ò³Mb¿?R£[Áß{šš?QLR]@R7~ R…•>@› R¼ó‡RZÄK@Z¿Q@]@ R @]@Q 7 › S;S£úŸ ƒrh¡?S£‹eb3ªk»?RLS¿\@S7S…8gDioƒ?› S¼ó‡SZÄV@Z¿W@¿\@ S ¿X@R 7 › T<~ T£+@T£k<ˆ=»?SLTÄN@T7T…™äدäØò?T¼DãlÁš©Ì?‡TZ_@ZÄ`@ÄN@ T O@S 7 › U=U£Ù›ŒxÈ&¡?U£4sEÀ»?TLUÄO@U7U…Ž@ß tŽÝ?U¼•ßK7âÌ?‡UZ`_@Z`_@ÄO@ U ÄO@T 7 › V>V£Ù›ŒxÈ&¡?VD=¿V£4sEÀ»?ULV@[@V7V½ÕÃÃÃÃÄ?VD=¿V†«K7âA`Ì?VD=¿› V°{‡VZ@T@Z@T@@[@ V ¿Z@U 7 › WŸW£È&1¨¬?W£¡ú¾èhŠ?LW¿P@W œ7æ W½†‡WZÄ^@Z¿a@gW ¿P@WQDW¿ A&DW¿ A&B$&DW¿ËDW¿DW¿AŒ B› X?X£ònÉ¿ ¡?X£>UH£ž»?VLXºµX7› X¼ó› X°øX ½OµX7 › Y@Y£ñCãlÁš¡?Y£ÙLª ó:Š?X LY`b@Y7"Y…öôôôôôô?Y 2Y¼»À=C#Ó?› Y°¿‡YZÄE@ZI@`b@ Y ýb@V 7 › ZAZ£Ó|?5^†¡?Z£V‚ÃßÞ»?Z LXZ@g@YBDZ ¿ (DZ ¿ A& $Z ¿ " $Z ¿B~ Z¼W@‡ZZ@ä@ZÄã@Z @g@Z7 › [B[£ª' µ¶¡?[£s}kUˆ»?ZL[¿d@[[º-[d #L¿  ,¿ ,¿B› [¼ó~ [ ¿d@[ µY 7 › \C\£ðµÑ|­„¡?\£`ùÖu¹»?[L\Äc@\[› \¼ó~ \ Äc@\ µ[ 7 › ]ª]£µ¶y«):¬?]£ïdŸ,ÓëŠ?] L]¿\@\[~ ]¼`W@‡]ZÄQ@ZY@] ¿\@]7 › ^D^£ðµÑ|­„¡?0^£`ùÖu¹»?]D^¿ÕÃÃÃà L@ÖÎQ½œC@^Äc@^[~ ^¼ÝW@‡^ZD@ZI@Äc@ ^ ¿b@\ 7 › _¼_£Oѧ1hm¡?0_£¶õŸ ƒr»?_ D_¿ÕÃÃÃà L@ÖÎQ½œC@_I@^[~ _¼W@‡_Z@`@Zc@_ I@_7 ×Dlßذ߇°Ø°€77‘×"¾¼Ø¼µ¼¼‡ÚÌôþÞ ô°º` T0a b c h(çd še f g h i Pj ., k l ¾w m T0n BUBEo pqÂrsù0tuvÂwo@xymz{‰0«|}Â~› `f`£öû^¡?`£þÕ±¦•]»?` L`¿T@_[~ `…xû@› `¼ó‡`Z[@Z[@` ¿T@`7 › aEa£•ßK7â¡?aD¿a£ÝµY*„ô»?`LaÝc@a[a½‘?aD¿a†`­"¤˜Ó?aD¿› a°zaZÄ@@aD¿aZF@aD¿~ a Ýc@a @c@^ 7 › bFb£`TR'Ý¡?0b£|m݇ý¼»??Db¿ÕÃÃÃà L@ÖÎQ½œC@b:@?[bêìg€u/‹Ì?‡bZ`d@ZÝe@b :@a 7 › cGc£· ì©ÇQ¡?0c£Ù‚ÝçK»?bDc¿ÕÃÃÃà L@ÖÎQ½œC@cÄF@b[~ cµ‰?cê±rvøZƒÌ?‡cZÄa@Z¿b@c ÄF@b 7 › d€úd¶¯S“€õŸ¿?0d¶»÷ç`“Ö«?cDd¿ÕÃÃÃà L@ÖÎQ½œC@dßM@c[~ d×?› d®ód©‡dZ¿\@ZÄa@M@ d ÄL@c 7 › e‚æ eˆˆŸ#eµfffffÊ’?d fffffÊ"@eê› fØæ fˆˆŸ#fµ333333¤?e 333333@fê› gÆæ gˆˆŸ#gµ333333‹?f 333333@gê› hæ hˆˆŸhµÙ?g › i´æ iˆˆŸiµÙ?h› j¨æ jˆˆŸjµÚ?i › kƒæ kˆˆŸ#kµffffff¡?j ffffff!@@kà²MbX9Ù?› k°±æl´¨¨àlÝæm´¨¨àmÝæn´¨¨ànÝæo´¨¨àoÝæp´¨¨àpÝæq´¨¨àqÝær´¨¨àrÝæs´¨¨àsÝæt´¨¨àtÝ#u´k %q¿¿Bæ u¨¨àuÝæv´¨¨àvÝæw´¨¨àwÝæx´¨¨àxÝæy´¨¨àyÝæz´¨¨àzÝæ{´¨¨à{Ýæ|´¨¨à|Ýæ}´¨¨à}Ýæ~´¨¨à~Ýæ´¨¨àÝ×D lØ"†»ŒOOO???eAÄT0ÅÇæÄ´¨¨àÄÝæÅ´¨¨àÅÝæÇ´¨¨àÇÝ× ê(Ï‘•‘• ••( •Ä|”!ôÿ¿ ••~¢ •  £ •<ÄéeÖø XÅPÉPø?ø •àdZreó•]4 @éeŒßU bu"?F÷¶y¿O¬‘Ï •<Other Ingredients <e °e Glenn Edward Murray?P>O@ ¾† Sheet2 ÚÊ òíü  d¸©Ò³MbP?_*+ÇÄ%Å¡ÉÑMN\\SNP5HRTS\SMASTER2ÐpcXXLetter 9''''°"dXý?ý?ðcU} ¤} } í } í } $   ,T0@    š¦     : U U E  U  U UE› ×£æ ××› [à› ëå› ëãZ ìp3µ Cost/Oz Cost/Ozæ æ  › q› Ç~ a@Z#üÈì>Èì>Š? ffffff @æ æ  › q› á~ a@Z~ ü­?æ æ  æ ZZà › [}› ëí› ëâ› íÝ› í°› 좛 ìäæìà › Å~ `<@› Ö› Ä› ~› Ñ~ @è@æ­à › è ¿g G ¢? › D¿› › › P› O~ 0@æ à æ ZZ › [ì› âèæ ZZ æ ZZ › [ë~ a•?æ ZZ æ ZZ › ëû› ëü› íˆæZ › [ù+‚¿g G ¢?Z#Bf+Æ0@ Z#Bfa‹•?œK# BMetric Metric#Bf@BæZ æ ZZ æ ZZ æ ZZ ×(Tà}d$xxç$<$<$PÌ$$ÏP•H ••0•( •Ä!k •P>@ ¾æ+ # † Sheet6 ÚÊ $¢ôð:ý  d¸©Ò³MbP?_*+ÇÄ%Å¡ÉÑ&–(\謞ÿ?'R½ÖÎQý?(Ë?)R½ÖÎQË?MN\\SNP5HRTS\SMASTER2ÐpcXXLetter 9''''°"dXý?ý?ðcU} } m} í } m}  } } }  } ¤ } } } } ¤} $ $  ;T0    š¦           U  E  U  U BUE  ù0 EE EE EUBE o@ ¾G  ¾wT Ä   T  › oTæÿŽ› Éhºµ C  StandardæÁËËb›  ç~  x@› |ÖhLµo%¿¿Z %¿¿ B%A&7% ¿ ¿%¿¿B%¿¿% ¿ ¿BA BæËËË›  é›  ¤ ¤æ\æbbbbbbbbbb› ÈæÍÍÍÍÍ/nTLµ!D ;BfNaOHæ2 !bbbbbbbbbbbbbbbbbbbbb› ]<uH0µ&Weight (C #Bf)BP Weight (Oz)9v`0µ#Vol (C #Bf)BP Vol (Oz)› ØÜ› ùi› wI<v 3µ&Weight (C #Bf)BP Weight (Oz)›  ]W< u83µ&Weight (C #Bf)BP Weight (Oz)æ ³±bbbb› »…› »½› »¥› »µæ»bbbbbbbbbbæ 2Öë<î­µ{D¿ fD¿ JD¿#Bf  D¿D¿#Bf""BRçôõ<D¿@@ D¿ B%D¿D@BG㟵 1D¿ D¿##BfBWǽºµœAD¿ ,D¿#C ## BfBfB{f¿µºX NLš¿@@ A&L¿@@ @A&B$Lš¿L¿ Bæ Ä}ô W UßݵAD ¿ ,D ¿#C ##BfBfBd Uš¿µ ND ¿@@ A&D ¿@@ @A&B$D ¿D ¿ By U»µ cD¿ ND¿##Bf D¿##BfBD¿BŠº8 .L¿ L¿ B% ,Ù¿By‰ µ cD ¿ ND ¿##Bf D ¿##BfBD ¿BDŠ.D¿ D¿ B% $ ¿B⌵sD¿ ^D¿##Bf 2D¿##BfD¿# B"B⨵sD ¿ ^D ¿##Bf 2D ¿##BfD ¿# B"BDb.D¿ D¿ B% $¿BDb .D ¿ D ¿ B% $ ¿Bæbbbbbbbbbbbæ 3dë=Hµ{D¿ fD¿ JD¿#Bf  D¿D¿#Bf""BRçDµ <D¿@@ D¿ B%D¿D@BGã¥"µ1D¿ D¿##BfBWÉ›Œ!µAD¿ ,D¿#C ## BfBfB{=ÿ!µæ Ä~p  U8µ ºK ALœ¿ ,Lœ¿#C ##BfBfB U©dµ  ºX NLœ¿@@ A&L¿@@ @A&B$Lœ¿L¿ By U½"µcD¿ ND¿##Bf D¿##BfBD¿BŠ ‰LFµºm cL™¿ NL™¿##Bf L™¿##BfBLš¿BŠº8 .L¿ L¿ B% ,™¿Bƒ"µº} sL•¿ ^L•¿##Bf 2L•¿##BfLÒ¿# B"B~d*µº} sL—¿ ^L—¿##Bf 2L—¿##BfL¯¿# B"Bb º8 .LÙ¿ LÙ¿ B% ,Ô¿Bb º8 .L—¿ L—¿ B% ,–¿Bæbbbbbbbbbbbæ 3d =m,Jµ ºÖ  {Lœ¿ fL¿ JLœ¿#Bf  L¿Lœ¿#Bf""BR çWÑFµ <D ¿@@ D ¿ B%D ¿D@BG ãåFµ1D ¿ D ¿##BfBW É5XFµ AD ¿ ,D ¿#C ## BfBfB {Q`Fµ æ Ä~p  UÐIµ   U,Fµ   U4Fµ  ºm  cLÙ¿ NLÙ¿##Bf LÙ¿##BfBLž¿B Š  ‰8Iµ Š  %¿¿sPá›:D¿@@  @D¿C@ABOf9D¿@@  @D¿C@A'Bæþýýý·S ‘®µi After Cure (D¿  333333@2dD¿D¿D¿D¿D¿A¹B% water)After Cure (4.3% water)gQâýµ"QD¿@@ D¿ B% @#D¿D¿D¿½ÖÎQ½•?BsPc`µ:D¿@@  @D¿C@ABO^I\µ9D¿@@  @D¿C@A'Bæmýýýý·S æ Ü^æu^s()mýýýý·S æ Ü^æ ,ä› ñîæ þýýý·S ×D¢9l$j¦4ñ–TTŒNw_H ²,A'¸“0! T0" # D!!ÿµ. Bar Size (D; Bf)BP Bar Size (Oz)~ !-@› !îñJ!óXµ4D"¿ D"¿ B%D"¿D"¿Bæ!þýýý·S › "!SH"?”µ 2D¿ A&D¿D!¿B‰@B› "ïï©"òTµ!ìD"¿ ~D¿D¿ XD¿D¿D¿ 2C ##BfD¿# BB @2×i‘Õßwð@Â2 "  ¾Öæ+ #  æ+ #  æI Use dropdown list to select Oil# Coæa 7Clear field and use dropdown list to select Oil# † Sheet1 ÚÊ "åÂã®  d¸©Ò³MbP?_*+ÇÄ%Å¡ÉÑ&×£p= ד?'·zÆG·’?()\謞(Ï?)ÖÎQ½ÖÎ?MN\\SNP5HRTS\SMASTER2ÐpcXXLetter 9''''°"dXý?ý?ðcU} } }  } } m}  } $ } $} $ ";T0š¦  E e U EUUUEù0Uo@UUz0T  › oT;Œå$µ!%Z¿ :¿B挌ŒŒËæ./////› U~ 0•?æ////æ./////› !uÙµZ¿ Weight (Oz)yTµZ¿ Vol (Oz)› yH› ùIXz”KµBZ; Bf@ Z ;BfBP Oz NaOH›  WB ! µ, Weight in Z; BfBP Weight in Ozæ "#// ;Wÿµ%Z¿ :¿BGråµ1Z¿ Z¿DABG<f­!µ1Z¿ Z¿DABEåîµ/D¿@@ D¿D@BW7½»!µAD¿ ,D¿#C ## BfBfBlfÃ!µºX NL¸¿@@ A&L¿@@ @A&B$L¸¿L¿ B;W` µ %Z ¿ : ¿BG 6h µ 1Z ¿ Z ¿DABW TߧµAD¿ ,D¿#C ## BfBfBd Uš®µ ND ¿@@ A&D ¿@@ @A&B$D ¿D ¿ Bæ  ¾1 ;Åpµ%Z¿ :¿BG=xµ1Z¿ Z¿DABGCôLµ1Z¿ Z¿DABçô|µº9 /Lœ¿@@ Lœ¿Lœ@BW7›@µAD¿ ,D¿#C ## BfBfBi=Dµ;Xƒµ %Z ¿ : ¿BG 8¥µ 1Z ¿ Z ¿DAB T½$µ ºK ALœ¿ ,Lœ¿#C ## BfBfB U©t!µ  ºX NLœ¿@@ A&L¿@@ @A&B$Lœ¿L¿ Bæ  ¾1 ;X$µ%Z ¿ : ¿BG` $µ1Z ¿ Z ¿DABG=ft"µ1Z ¿ Z ¿DABçWx"µ 75|"µºK AL¸¿ ,L¸¿#C ## BfBfBiQ4 µ ;X¨ µ %Z ¿ : ¿BG 8@"µ 1Z ¿ Z ¿DAB T½¸!µ  U(µ  æ  ¾1 ; X,µ %Z ¿ : ¿BG `0µ 1Z ¿ Z ¿DABG =\4µ1Z ¿ Z ¿DAB çÿ8µ  7›<µ  i|@µ ; XDµ %Z ¿ : ¿BG 8Hµ 1Z ¿ Z ¿DAB T½Lµ  UPµ  æ ¾1 ; XTµ %Z ¿ : ¿BG `Xµ 1Z ¿ Z ¿DABG =\µ 1Z ¿ Z ¿DAB çm`µ  7dµ  i~hµ ; Xlµ %Z ¿ : ¿BG 8pµ 1Z ¿ Z ¿DAB T½tµ   Uxµ  æ ¾1 ; X|µ %Z ¿ : ¿B›ÇÉÑÖÜáàâäãåçéèêëíìîïñóòôöõúùûüÝ°¢£§€¶ß®©´¨‚Æ؃±¾„¥µ…½œˆªº‡æø¿¡¬Ÿ ‰«»ŠÃ‹Õ‘¦­¯²ý¹÷×ÿŽ¤ÐðÞþ³·’“”ÂÊÁËÈÍÎÏÌÓÔ•ÒÚÛÙž–—œ˜™š¸›œG `ĵ 1Z ¿ Z ¿DABG =pѵ 1Z ¿ Z ¿DAB çൠ 7ãåµ  iãêµ ; Xîµ %Z ¿ : ¿BG 8òµ 1Z ¿ Z ¿DAB T½úµ   Uݵ  æ ¾1 ; X§µ %Z ¿ : ¿BG `®µ 1Z ¿ Z ¿DABG =¨µ 1Z ¿ Z ¿DAB 烵  7ßhFµ  ißlFµ ; XpFµ %Z ¿ : ¿BG 8tFµ 1Z ¿ Z ¿DAB T½xFµ   UJµ  æ ¾1 ; X§Oµ %Z¿ :¿BG `®Oµ 1Z¿ Z¿DABG =pѵ 1Z¿ Z¿DAB çൠ7·åµ  iêµ; XdOµ %Z ¿ : ¿BG 8hOµ 1Z ¿ Z ¿DAB T½,Oµ   U0Oµ  æ ¾1 ;X4Oµ%Z¿ :¿BG`8Oµ1Z¿ Z¿DABG=!ൠ(Total Z; BfBP Total OuncesL1P¸µZ; Bf Pounds1P§µZ; Bf Ounces› !R› OKI<˵3Z¿ Z¿DCABRR@d µ<D¿@@  @D¿Z@ABQAºµ;D¿@@  @D¿Z@A'B;Ð¥µ %Z¿ :¿Bæ ððÎ › !I=(µ3Z¿ Z¿DCABRB½µ<D¿@@  @D¿Z@ABQC¥µ;D¿@@  @D¿Z@A'BæþýýÏ › OLd=fHµND¿@@  @-D¿D¿D¿@@C@A¹BRRBtµ›<D¿@@  @D¿Z@ABQCfdµ;D¿@@  @D¿Z@A'BæþýýÏ › ÕMI=fêµ3Z¿ Z¿DCABRR¦úµ<D¿@@  @D¿Z@ABQffòµ;D¿@@  @D¿Z@A'BæþýýÏ › ÕNOÃÙKµ9D¿@@  @%¿¿@SUB`P¦ƒµ:D¿@@  @D¿C@ABOf¨µ9D¿@@  @D¿C@A'BæmýýýÏ À˵Z¿After Cure (4.3% water)IQlµœ3Z¿ Z¿DCAB^PÜ`µ:D¿@@  @D¿C@ABO^\µ9D¿@@  @D¿C@A'BæmýýýÏ æ&'(^æþýýÏ æ ERä› ûîRæþýýÏ E O$µ/ Bar Size(Z; Bf)BP Bar Size(Oz) R@Z!¿› îñ óTµ!Z!¿ Næ þýýÏ ×DW.la.pO,WQQQD$¼š_="&Q$:! T0› !OSH!?Pµ2D¿ A&D¿D ¿B‰@B› !ïïC!òXµ-Z"¿ Z"¿ZBæ!’““Ì ×¹>@Â! ¾† Sheet3 ÚÊ <  d¸©Ò³MbP?_*+ÇÄ%Å¡ÉÑMN\\SNP5HRTS\SMASTER2ÐpcXXLetter 9''''°"dXXý?ý?ðcUϺ•§@• •å•( •N–wòQEŸÌw ••l¢ • s •*ÄÙ»eÖø Å ø¿@ø• ý¸•]`Ù»e”UÏ •F1< Hi, just a few notes about this template, how to use the workbooks created from it, and the methods used for certain operations. There's a short FAQ at the very end of this document. Installation ------------ (These instructions are based on installing the template for use by MSExcel97, on a machine running MSWindows95/98/ME/NT.) The best place to keep this template is in your Templates folder. Your Templates folder should be in the folder in which you installed Microsoft Office or Microsoft Excel. For example: on my machine the Templates folder is 'C:\Program Files\Microsoft Office\Templates'. Basic usage ----------- Once you have saved the template to your Templates folder, here's how to create new workbooks from it: 1) Start Excel 2) Click 'New' on the 'File' menu, which opens up the 'New' dialog box. 3) On the 'General' tab of the 'New' dialog, pick 'soapsheet.xlt'. 4) Click the OK button. 5) A new workbook called soapsheet1 should appear in Excel. There are only two worksheets in this workbook that you need to be concerned with when you play with your soap recipes. They are the sheets labeled "Recipe Worksheet" (the one you're on by default when you create a new workbook from the template) and "Scaled Version". The fields that may be changed on the Recipe worksheet are: - Recipe Name - fields under the "Oil" heading - fields under the "Super-fatting Oil" heading - fields under the "Weight in Oz" headings for oils and super-fatting oils - Lye discount - Bar Size (Oz) - Oil to Water ratio - Water (if water is overridden, then auto calc will cease for water field) - Notes Entering a recipe is as easy as picking oils from the drop-down list attached to the Oil fields and entering the amount of each you want to use. Then, if you want, enter super-fatting oils the same way, enter a lye discount, and perhaps change the bar size. That's it. Everything else will be calculated for you. The Scaled Version sheet allows you to take the recipe entered on the Recipe sheet and scale it to whatever batch size you want. It shows everything from the Recipe sheet except INS values, and includes the additional field "Scale Factor". Scale Factor is the only field that may be changed on the Scaled Version sheet, and is used as follows: to scale a recipe down to one half of its original size, enter a Scale Factor of .5. To double a recipe, enter a Scale Factor of 2. Enter whatever factor you want, 2 and .5 are just examples. You get the idea. Fluid Measurements ------------------ This spreadsheet will automatically compute the number of fluid ounces (or milliliters) from the oil weights entered, assuming the specific gravity is available for that oil. Be aware, the same care must be taken measuring using liquid measurements. If you normally measure weights to within a tenth of an ounce and want to measure by volume, then the same precision is necessary (to the tenth of a fluid ounce). The gradations of a normal measuring cup would not be sufficiently accurate. It is important to note that natural materials, such as oils and fats vary greatly, depending on source and refinement methods. As such, the specific gravity of your batch may differ from the table values. This will result in inaccurate amounts even with accurate measuring. Make certain you have at lease 3% superfatting in your recipes, to ensure an inaccuracy doesn't result in lye heavy soap. Measurement System ------------------ The measurement system (metric vs standard) can be changed by clicking the "convert measurements" button. This can be done at anytime and will convert all values from one system to the other. This allows you to enter metric or standard (english) recipes then converting to your desired system. Conversion is done via an Excel macro, so if you do not enable macros (some people don't for fear of viruses) then conversion will not work. Conversion is the only thing using the macros, so if you don't convert measurements, disabling the macros will have no effect on your use of this spreadsheet. SAP Values ---------- The SAP values used in calculating the lye are looked up from the SAP Values worksheet. If you disagree with any of the values, please feel free to change them. You may also change the names of any of the oils, just make sure you change any references on the Recipe worksheet from the old name to the new name. You may also add new oils, as long as you don't change the format of the SAP Values worksheet (this is very important, as the lookup from the Recipe worksheet depends upon the oil names and SAP values being in specific columns, and within a certain range of rows). If you do add new oils, you can either insert them into the list where you want or put them at the end; order is not important, just don't go past row 200 or so. Note too that the oils in the drop down list on the Recipe sheet appear in the same order as on the SAP Values sheet, so if you don't insert new oils in alphabetical order, they won't appear that way in the list either. To save any changes/additions you make to the SAP Values worksheet, so that any new workbooks you create will include them, see "Changing the template" below. Any additions need to include a price, even zero, to prevent unexpected and inaccurate results from costing and change measurements interaction. Costing ------- The spreadsheet will attempt to computer the cost of the soap you make by batch and bar. It does this based on the Cost/Oz column in 'SAP Values' Oil table. This is an example of how I would add a value: I bought a gallon of Coconut oil for $9.90, so I entered '=9.90/128' into the cell E24 (in Coconut oil row of the Oil table). The 9.90 is the price and the 128 is the ounces per gallon. In truth the oil probably would actually weigh about 118 ounces, but this was a quick and dirty estimate of cost. If you do this for a living, then you might want to factor 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. After Cure calculation ---------------------- The After Cure weight is an estimate of the total yield of soap after most of the water has cured out of your bars. It is based on the rule of thumb that when your soap is done curing it will contain about 4% water, by weight. The actual water percent will be calculated and appear in the After Cure line. Default values -------------- Every new soapsheet workbook will have a default lye discount of 0%, bar size of 4 ounces, Oil-Water ration of 3, scale factor of 1, and a oil & lye pricing info. Any of these may be changed. To save your changes for future workbooks, see "Changing the template" below. Changing the template --------------------- Here's how to change the template: 1) Create a new soapsheet workbook. 2) Make your changes/additions to SAP Values, bar size, lye discount, and/or scale factor. 3) From the File menu, click Save As. 4) In the 'Save as type' drop-down list box on the 'Save As' dialog, choose 'Template (*.xlt)'. This choice should automatically change the 'Save in' 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äF1Ïl•l¢ •  s •*ÄàmeÖø Å ø¿@ø•  A•] `àme¥©UÏ •9 <: 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).< »a9 Ïl•l¢ •  s •*ÄÿmeÖø Å ø¿@ø• › ••] `ÿme kUÏ •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>@† Sheet4 ÚÊ N_  d¸©Ò³MbP?_*+ÇÄ%Å¡ÉÑMBQMS magicolor 2+ÐdþÍ odXLetterPRIVýê''''·e Letter°"dXý?ý?ðc ŸUϺ•ºP• •§•( • • •l¢ • s •*Ä»€eÖø Å ø¿@ø•   <•]`»€epmUÏ •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>@† Sheet5 VBA\MSOffice\Templates\EFB7FCD0@döŸŸ–¡p¢¨Ÿ–¡Sheet1!e __SRP_28é__SRP_3G±P[LSSîc6"Lî<N0{00020820-0000-0000-C000-000000000046}·±(œœœ¯›Ë›ÿ›»›½›®›ò›à›x›XH8(¯œËœÿœ»œ½œ®œòœàœxœhœXœHœ8œý$ å xXH8(¯œËœÿœ»œ½œ®œòœàœxœhœXœHœ8œ(œœœ¯›Ë›ÿ›»›½›®›ò›à›x›4 8<rUÄÄÄ H$°`$·` â4@±4p</1¨º.8÷¶t¿O¬‘ ¿F.1¨º.8÷¶t¿O¬‘x™í8QZ#à.1¨º.8÷¶t¿O¬‘/1¨º.8÷¶t¿O¬‘ÆÚÚ4þSheet2ffice\Templates\soapshee ïñóòôJÝÝ__SRP_6€¶ß®©´¨‚Æ؃µ…œ¬]Ž¿__SRP_7‰«»À­ÃÕ‘¦—¹÷×ÿa@ýSheet3ÂÊÁËÈÍÎÏÌÓÔ•ž–œ¯˜b­(SLSSî6"N0{00020820-0000-0000-C000-000000000046}·± êÅ6 XÅB ýÅ0 ­Å8 Ä Ä Å Å Ý Ä Ä Ä Å[ÿÄ Å$ÅPÄ Å 4 ÅDjàÄ Ä F`Åÿ Å ( Å•Å Å(Å  ®Å ÅHÅ  êÅ@Åà Ä ÅòÄ Å4Ä 0ê Ä Ä @ÅkýÄ ÅkÝÄ Å(H@Ä Ä Ä Å3HÄ Ä @8Ä 6­Ä Ä 6ƒÄ bHÄ Ä *0Å3hÄ Ä BËÄ 6ÄÄ Ä `Å&á8Ä Ä <½Ä 6xÄ Ä ½Ä PƒÄ Ä Ä 4¯Ä .0Ä \`Ä b¿Ä Ä 4½Ä T(xÞž“Qß÷÷%@þ@ LLLîLî Loop thru each item in the selection and convert (if numeric)h — 6– våB@ 9”ÿ( the number of decimal places displayed.ÿ: This macro changes number format of individual selections § ï a § 'si § 'ÿ cvFormat subroutineÆ 0.00000000 $Þ'ÂÆD3ÆRecipe Worksheet$ö%T.Æ 6!<ÆïaX 6$@ï˜ 6Ìn(h h— 6–¿l ˧ 'ËP Ø'Ú ÆÆStandardïha  ,!@%6!B!<$œ'ËÆA1 ­%TB@JØ'Ú ÚïhHÆMetric'–e(ÿ No sig digits for Lbs/Kgs§ Aûx ˧ 'ËitØŠÿØŠŽØŠÐÆRecipe Worksheet$öB@÷ÆRe§ AûËØŠÿØŠŽØŠÐÆRecipe Worksheet$öB@÷P Valuÿpr – ( ,!@%6!B(<ÆI3:I94 ­%TB@JP Valu Ë  ,!@%6!B(<TÆLye'$ÿ+ Which lye is being usedý­Xÿ) Worksheets("Recipe Worksheet").UnprotectÄÆa1 ­%TB@Jÿ' Macro recorded 3/20/02 by Glenn Murrayitÿ# look odd when you go back to sheetÿ Convert the Oil weightsÿ9 Change expressed significant digits for oil wts & volumeÿ0 Call cvFormat(Range("c26:f32"), sigDigits)llÿ0 Change expressed significant digits for lye wtsÿ< Change expressed significant digits for superfatting oil wtgnificÿ$Convert the Superfatting Oil weightsÿ Convert the Bar weightsicÿ/ Call cvFormat(Range("K8:K21"), sigDigits)ttÿ6 Change expressed significant digits for total weightsÿ- Convert prices to reflect new units for Oils(ÿ6 at the bottom of the screen when you go back to sheet youÿ< Select upper left hand corner, just so it doesn't leave you for Oÿ- Convert prices to reflect new units for LyesÿB ** Programmer note: Currently the significant digit correction isÿC commented out, due to a bug. When it is run, the initial unprotectÿE of the Recipe Worksheet fails. I haven't found out why. Glenn MurrayÿB based on the parameter sigDigits. DecimalPlaces is used to changeÿD Loop thru each item in the selection and change format (if numeric)Pÿ Constants - NamesÆMsystem'(ÿ+' Which measurement system is being usedacÆ Type_Of_Lye'8ÿ+ List of types of LyeÆType_Of_Lye_table'<ÿ, Table of Lye propertiesØŠÿØŠŽØŠÐÆTables$öB@÷ÆTables$öB@³l(h( fïÿ Exit iff ®ÆCost_Lye'Rÿ+ Cost of Lye.Æ Conversions'ÿ+ List of measurement systemsÆConversionTable'tÿ+0 Table of measurement systems convertion factorsÆOilList',ÿ+ List of Ingredients, except LyeveÆ ConvertSystem'Hÿ+1 Conversion factor for converting between systemsÆOilList2'0ÿ++ Table of Ingredient properties, except LyeÆDecimal_Places' ÿ+8 Number of optimally displayed decimal places (inactive)Æ ConvertUnits'Lÿ+/ Conversion factor for converting between units8 H ,!@%6!B.ÆCost_Ingredients'Vÿ+! Cost of Ingredients (except Lye) r ,!@%6!<$T Aûÿ@ Compute new conversion factor and decide new measurement systemÿ, Worksheets("Recipe Worksheet").UnprotectntentsX ­òÆ Bar_Size_Wt'rÿ+& Bar size in (current) units of weightP ÆC8:C20$T AûÆK8:K20$T Aû ( ,!@%6!B!<'Æÿ? Get curr measurement sys valueelecÿ/ Call cvFormat(Range("C8:D21"), sigDigits)ÿ9 Set new values for Sig digits and the measurement systemÿ\ Call cvFormat(Range("H8:H21"), sigDigits + 1) ' always has an extra significant digitalue).ÿI Call cvFormat(Range("e26:e32"), 0) ' Always no decimal places here¿!8 ÆTables$öB@³ ÿ( Worksheets("SAP Values").UnprotectÿU Call cvCell(Range(Application.Names.Item(Cost_Ingredients).Value), 1 / cvValue)ÿ\ Worksheets("SAP Values").Protect DrawingObjects:=True, Contents:=True, Scenarios:=TrueÿM Call cvCell(Range(Application.Names.Item(Cost_Lye).Value), 1 / cvValue)»`!ÿ) Worksheets("Recipe Worksheet").UnprotectÿIActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=Trueà  …Attribute VB_Name = "Module1" Sub Conve¿rt() ¥P.ŒProcDataInvok@e_FuncêC\n14å' 'é Macro & recorded 3/20/02 by Glenn Murray)This: will cï the entire worksheet from4Standard (English) to MeÛc measuremÄ units.#Å** Äigrammer no`te: CDly8significant di(gitGrÄbti on is"co Äntjout, due=a bÄug. WheÄÇt run,Ç)"iAialEprI9ctÅ"ofÇ RÄecipe Wpails. I @haven'Äxound 5 whŸy.çû ÉŸsåts - ؘ¿+ÅÉtsÄ0s¬nXÇ"ʼn' L0ist @& PsystemNTabûlÇîÇB' ÉìExÅTfactoÚrJtSBG** úA0  forÜng betwÊe@b/tUAÑH¬9 ®ó_Bar_Size_W>t¡àà@ sÅ in (cü)É©Å^weigh@àeCost_LœyÑYˆJCn,ˆm¿ C#BIngredœiÄ[Ÿ> h 'i(except Ý Éa DÝTmal¿_PlaceÇ +ÅÑ' Numb kaý>opti@¿jd@isplayýedçˆ ¿¡(inÝ?¯ive§ ý A'¿” ˆ‚'Älich Fl# ábei>uËsedCMc>! D¾ €O]awç Oil?bc@®Dî %hË), —Á)CD2ae• ®h« `àpÄies Type_OfØeF»  }ts¡NgÄ.ch_te|é"ÝdF|`®¡C £ýAÄ=sCell!GT(rueS¿¼xv¡ý¢= Act¿@AèCE>££' GɈ(Éa cvValı¿ ppl@½a³.¬Ý.I@ò(#ï§â).Refers@ToRangD ;£ Ä¿Daø·` (A—Û k` .Ç$[·C ‡s("mø").È!atŸc§#²§[øÚ¿3¢%ýEŽpƒ1 @'%3 Q@mpëÇne.wTT¼Uêv °;de‘ 3cIf•L ¬"Éx") T•p“0î—]U|ÄÑ!0©…+ 1CEls˜€ ñ, ^ÔŸ f oŒ-eöS•l-Faô E{Iœf$ ½q È) . Åp"Ç6s­!Un˜`teÑ¡dÔ$ós‰' Ò2±¾ së³sSigès ‹óîrîSU161ø(610Ov¹_ny;è.;Ê™- v0ÝAQ Draw¿cODbj0s:=±I, ‹¨t1sžScen•ariožQ47’¥rù`] £|¥ç TCa¡‚vQN(2G("C8:C20"½), ŸK–BXh‹·0dpresPn¿É,AÛoil wêü&@ volum`2'B"uFormatÒòD21ë÷æJ&œCþþƒó¡x­ë‚RCŸKH8:HL Ý=)ÅalwayésPØ·'­traü=U ÑZÄD]BSu·êqfattÅ¿("K8:K! ðxD¬sÈ“I¬O˯­¡£o%0²i%¦9¬9ƒ)wˆ3'w ü‚‹St ""¿) ThenE@¿If IsNˆB ÉN With ÅSÄ Ñ=*áã AíAHÅE¢ ¬ HNextDAáÝÖÝ;mat(Å8, Decima•lPla¿uÄ!D@cWü@ Qì@hazsA.båer¡ý ofìB!`; bas@?onQb8par Ät sÝigDig@à.ÎŽ ýMu!¿çcÇ ÅXtheE` d Bp" dis y ed»IÂIComp/¡q!ñ`ïÅS@tngˆ"/ &Plcsýfj'ãbÝ@(Â> 0k@ç=ÅB+ 1¬?7ó"ˆÝ¿LeÄft("0.0œ"¢9 ÉZøcbå¢c"'‰3ddd,zdÝkš¿G$S=”@!’¬hÅa)ød£…„d ¡©Ò¼i°Q°¡Ò!° ¼ ˜ ‹ a ôi© ¡¡ ¡)ô 1y©©qÈA YÅ p :\›l :\›L :\›< :\›, :\› :\› :\›¸œ :\›Ïœ :\›Ðœ :\ ›Ãœ :\ ›ºœ :\ ›¨œ :\ ›úœ :\ ›åœ c\¸–|œxœ"$ (Qxœ¸¸hœ[<›ì @dœxœ"$ xœ údœœ¢Tœ›ÛPœPœa@œà›Û¸¸0œ)xœdœPœ6Tœ@œÅÏœ›ì @dœxœ"$ xœ údœœ¢Tœ›ÛPœPœa@œà›Û,œ,œaœ¸ãœ`#œ ›k\¸–œ/œ)xœdœPœ,œ6Tœ@œœ4dœ:\%xœ"$ ÿxœ ddœœò)xœdœjÃœ›ì @dœxœ"$ xœ údœœ¢Tœ›ÛPœPœa@œà›Û,œ,œaœ¸–¯›)xœdœPœ,œ6Tœ@œ¯›:\]š/Tœ\k :\›Ë›œ(\šîTœ¸–œ‚¯›:\]š/Tœ\ü :\›Ë›œ(\šúTœ¸–œ´ ¸f\¸–|œ|œ\]4dœ:\%xœ"$ ÿxœ ddœœò)xœdœ4dœ:\%xœ"$ ÿxœ ddœœò)xœdœkœ›ì @Ïœ›ì @dœxœ"$ xœ údœœ¢Tœ›ÛPœPœa@œà›Û,œ,œ,)xœdœPœ,œ6Tœ@œkË››ì @Ãœ›ì @dœxœ"$ xœ údœœ¢Tœ›ÛPœPœa@œà›Û,œ,œ,)xœdœPœ,œ6Tœ@œHcÿ›%c»›%c½›%dœ:\%xœ"$ ÿxœ ddœœ¶ )xœdœ3xœ'Tœ%:\!%"$ Ý0œQxœ›o@œ 6Tœ@œ3xœ'Tœ%:\"%"$ Ý0œQxœ›o@œ 6Tœ@œá›ì @dœxœ"$ xœ údœœ¢Tœ›ÛPœPœa@œ¸ã,œ'®›%@œ`Fœ%"$ Ý0œQ,œ›oò› )xœdœPœ6 Tœ@œœ®›ò›3c\%cÿ›%c»›%xœ"$ @xœœ¶ xœ hœ›üœò”pt\Ðœ¯› hœåœL,l|œÃœË›0œ<œºœúœ¨œÏœ¸œ4 œxœdœPœ,œTœ@œœ®›ò›ÃÑ› \lœâLÄl›üW<#:\$]š<,5<\s l %q l¸4¸¯((W<#›\š¥,%(œõ#5< ž¸¯( lœåL TÑ4sLX(l<,0 ¸à   arUÄÄÄ $Å`›ë!,©`›¼!I¡//,‹`›I//p<´±0<úE÷¶y¿O¬‘¿F±0<úE÷¶y¿O¬‘x™¿6Qá#à±0<úE÷¶y¿O¬‘´±0<úE÷¶y¿O¬‘ÐÚÚ04þ(SLSSî6"N0{00020819-0000-0000-C000-000000000046}·±œœ__SRP_a!      œÊ  __SRP_b%&'()*+œ0/œ56789Î@œModule2Ï$Module3ìcrUÄÄÄ @pxÞÃQ¹Õ2÷÷œþ(6 << <·±?@ABCDEFGHIJKœMNOœœRSTUVWXYZ[\]^œ`abcdefghijœlmnoœqrstuvwxyz{|}~œlhÿÿ Pprot Macroÿ. Macro recorded 3/25/02 by Glenn Edward Murrayÿÿÿÿ Macro3 Macroç}ÿ. Macro recorded 3/25/02 by Glenn Edward Murray©ÿÿÆ0 8(”†Ä"ƒAttribute VB_Name = "Module2" rUÄÄÄÄ~}  kxÞ rUÄÄÄ (Å __SRP_9ry ¿FT__SRP_8 nModule4JECT_CUR ðModule5"ð`›9/ppxÞ×€QvÕÛ÷÷…þ(<<< <·± Loop thru each item in the selection and convert (if numeric)ý— 6– 8å 6!<Æï 6$@ï˜ 6Ì5< Æ9<n­h»h¿— 6–¿ l®èhÿÿ cvFormat Macroÿ. Macro recorded 3/20/02 by Glenn Edward Murray¿ÿ: This macro changes number format of individual selectionsÿÿ Keyboard Shortcut:ÿ Ê'Ë Ë§ ï ˧ 'Ëh® ˧ 'ËÆ 0.00000000 Ë$Þ'Ï¥ÿ> Loop thru each item in the selection and convert (if numeric)Ë— 6– 8å 6!<Æï 6$@ﯘ 6Ì Ï9”nýhÿh­— 6–¿‰l½­·±Attribute VB_Name = "Module3" Sub cvF@ormat( actor) '` Macro" recorded 3/20/02 by Glenn Edward Murray`This m> changes number fs of individual selec`tions<?KeyboRSho@rtcut: sigDigòits³½ If (> 0¿) ThenÇ å+ 1Endÿ If=6epÄÑisWÄALeft("0.0y",á®Ä<' Loop thru each ƒitemÅÄe aÄCconve@rt (iföeòric$× EŬIÅIn Sõ15ÅÅ.ValuÄe <> ""ãAA IsNum(A N With ÔÖ¿Ç.@¿qÉé¿?B T¡H»X@·HNextŸA¿¶Å®ˆ0``$8`®ýx@ Ñ`•É Ý$PxMEœ àlpÿÿ Unprotect Macro ÿ. Macro recorded 3/26/02 by Glenn Edward MurrayÝÓÓ ÿÿ ­B@³xx"ƒAttribute VB_Name = "Module6" <Bu"?F÷¶y¿O¬‘ ¿FAu"?F÷¶y¿O¬‘x™ä8QVÿ#àAu"?F÷¶y¿O¬‘Bu"?F÷¶y¿O¬‘¶ÚÚ™4þ(SLSSî6"N0{00020820-0000-0000-C000-000000000046}·±stdoÄle f%\*\G{00Ä020430-C 0046}#2.0#0#C:\WINNT\System32\c2.tlb#OLE Automation#^ÄMSForms>!SFErÄms/zÄ pÄFB814A4E3-5374-11D4-A637FC04FC`21ECEF3.TWD#Micr@osoft = ` Obƒ Liýbrary9Ph0çoÄP19C4AC6F-(1F2P6P73PTEMP\ExÄcel8.0\‰'EXÁ'·.E èýÖ.`åM ¥çÉwOfficÑwOÄtfiTcÇwà+~,2_VBA_PROJECTœœ "$ú(dir+œ0/œ1œ5678Qn__SRP_0#4__SRP_1___–e|Ó ÄxlMinimized2¯ÄTop5Ž ÄxlMaximizedZpÄSheets ÄWindows£dÄActivateó|ÄxlNormalLùÄRangeŽ  ÄActiveCell‡… ÄFormulaR1C1SÄActiveWorkbook¢ÄSaveAsf;ÄFileNamejˆ ÄFileFormatü÷ ÄxlTemplateé)Password•‘WriteResPassword:ÄReadOnlyRecommendedÌü ÄCreateBackupçÄVLookupé£ÄWorksheetFunctionÛ&C3…\ÄSaveí­ConversionTable‰òzapE¯UnitÅü ÄClearContents{ÐWorkbookk¨(Convertž¯Ñtest1–c Ä_B_var_C3_ÒÄ_B_var_ConversionTableXÇzqÄ_B_var_VLookupßÄEvaluate†TEvaluatìHÄ_B_var_EvaluatLÄ_B_var_FunctionôOÄ_B_var_WorksheetÖ¯ Ä_B_var_SetêsRangeÃÂmyRange·- ÄWorksheetsº¯Ä_Defaultj¬¨(cvCell<cZc5¼\d3Ð\ Ä_B_var_d3ÑÒÑMacro4ÿNÑMacro5NÑMacro6ŽNcval“ Ä_B_var_cval.HÑConvertE wÄRun_­ÑMacro8ÐN _B_var_String²äStrinT` Ä_B_var_StrinA$ ConvertAll¾(xvalÛ Ä_B_var_xval_Convertor_Click íÄClickä“CommandButton1|ŒCommandButton1_Click”¡ Module2cÑprotn ÄActiveSheet%N ÑUnprotect?ÑPprotÿîÄProtect×fÄDrawingObjectsþ†Contentsÿ= ÄScenariosk Ä_B_var_call…¸hcvFormatgÑMacro3×N ÄNumberFormat¹RcvFactor†œ sigDigits<Ä_B_var_sigDigitsÅø precisionÁ Ä_B_var_precision,Œ _B_var_LeftQ· processCellsôÞÄ_B_var_processCells measureSystem ¤Ä_B_var_measureSystem®Æ Ä_B_var_Longß Ä_B_var_TypeseValð’Ä_B_var_Contentsa ÄWorkbooksBÏ Module3d Module4e Structure«„ Module5f Module6gcvValp·cvValue{Ä_B_var_cvValueÄ4K DecimalPlaces·[DecPlcs€ô formatStreß Conversions6ÖÄÅÇÉÑœÜáàâäãåçœèœ_B_var_ConversionsgDecimal_PlaceséVÄ_B_var_Decimal_Placesû›Lye@ƒ Ä_B_var_LyeQmMsystemIºÄ_B_var_MsystemÕøOilList=óÄ_B_var_OilList¡öOilList2‘;Ä_B_var_OilList2W System_tableáÄ_B_var_System_tableþ¦ Type_Of_Lyeœ Ä_B_var_Type_Of_LyeüœType_Of_Lye_tableµ»Ä_B_var_Type_Of_Lye_tableÄNames‘ø ÄRefersToRangeá—ÄmeasurementSystemÄ_B_var_measurementSystem$ ConvertSystemõ¨Ä_B_var_ConvertSystem9Ä ConvertUnitsiÄ_B_var_ConvertUnits£ Sheet6ÌCost_LyeQ½Ä_B_var_Cost_LyeŽèCost_Ingredients~sÄ_B_var_Cost_IngredientsxSheet7Ócomplete  incomplete¾Ùemd®â Ä_B_var_emd¼F NotEverthingþ. EndOnBlanksŒSAdd—rAd~\ÄProtectContents¹À Bar_Size_Oz…FÄ_B_var_Bar_Size_Oz8 Bar_Size_Wt¥GÄ_B_var_Bar_Size_Wt9RngeN” Q    !Ãa^  ”*\G{000204EF-0000-0000-C000-000000000046}#3.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.dll#Visual Basic For Applications¸*\G{00020813-0000-0000-C000-000000000046}#1.2#0#C:\Program Files\MSOffice\Office\EXCEL8.OLB#Microsoft Excel 8.0 Object Library½*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automationý*\G{B814A4E3-5374-11D4-A637-00C04FC21ECE}#2.0#0#C:\WINNT\System32\MSForms.TWD#Microsoft Forms 2.0 Object LibraryÞ*\G{19C4AC6F-1F24-11D6-A673-00C04FC21ECE}#2.0#0#C:\TEMP\Excel8.0\MSForms.EXD#Microsoft Forms 2.0 Object Library·.E èýÖ.`åM ¥¸*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.0#0#C:\Program Files\MSOffice\Office\mso97.dll#Microsoft Office 8.0 Object Library ·±u"?F÷¶y¿O¬‘¶y¿O¬‘ĪŠ4A ÄAsÄCallCÄEachDÄElseSÄFalseUÄFor_ÄGoto`ÄIfcÄInyÄLong€ÄSet„ÄThenµÄTrue ExcelÄ+ VBA—’Win16¡~Win32Mac„¾ soapsheet(‚ stdoleì`MSFormsC VBAProjectæø Officeu Sheet1Ë Ä_Evaluate ToggleButton1Gº ÑWorksheet¡œ Sheet2È Sheet3Í Sheet4Î Sheet5Ï Convertoró Module1bÑzapMM7 ThisWorkbook|“ ÄApplication€* ÄCommandBars ÄVisible² Reference—e Ä_B_var_ForjLItem×z ÄSelectionZÆ Ä_B_var_ItemCýÄValue”K Ä_B_var_ifPÚ IsNumeric$* ÄActiveWindowˆ+ ÄWindowStat#  ' + Õ &Í DF8D04C-5BFA-101@B-BDE5,AjAÄv4¿2HT°gram Files,\Ñmso¿97.dllàWÉ ¿7³WǼ ¬QǶShePet1»2Ç©Sh@0e´1Q@0HB1†J-¿½B,BWZ"B+BH2H2µM2PÄÁMZU3H3M3P2ýzU‚ Xµ 4® 4‚ 4Uƒ Wp^µ 5® 5m‚ 5ø ’.\¨ ¬|oƒdule¿:à2d~Žo¿èu¬è1;%ýù‚#ß!*;úThisWorkbooåk"F)2 *T`Hi ãWbåk¢býok•0p2¸áÎIGJàÔqJÚœ0 ¹ÕÎá ÄJà¤/ ÒJ4@-'j6 K' K“±g3qK…™- v6 ÄK' ÝK- ÀÒK1 }6 6c ÇM*6Ø$60=«pì€Î0AÊ’í gÌc± ™)ƒ VÿÈHí,rUÄÄÄ~~~~~~s book Conversions ConversionTable Decimal_Places Lye Msystem OilList OilList2 System_table Type_Of_Lye Type_Of_Lye_table¼¿F A1 ConvertSystem ConvertUnitsSheet6Sheet7 Cost_Lye Cost_Ingredients E3:E94 Tables E4:E5Bu"?F÷¶y¿O¬‘Au"?F÷¶y¿O¬‘Uu"?F÷¶y¿O¬‘Tu"?F÷¶y¿O¬‘Wu"?F÷¶y¿O¬‘Vu"?F÷¶y¿O¬‘ProtectContents Bar_Size_Wt©Éäa Å ¡Éäa Å  Ò A ȽÒÈ A‹Éäa Å ˜à ÈA˜ÅôÉäa Å       ˜Š Q Convertor y( -Macro recorded 3/19/02 by Glenn Edward MurrayU 14UnitW 14Q 14 -Macro recorded 3/20/02 by Glenn Edward MurrayC 14 14E 14 È8CommandButton1 H -Macro recorded 3/25/02 by Glenn Edward MurraycvFactor -Macro recorded 3/26/02 by Glenn Edward MurraycvVal DecimalPlaces ˜yX EndOnBlanksRnget‘CSheet1Sheet1Sheet2Sheet2Sheet3Sheet3Sheet4Sheet4Sheet5Sheet5Module1Module1ThisWorkbookThisWorkbookModule2Module2Module3Module3Module4Module4Module5Module5Module6Module6Sheet6Sheet6Office PROJECTwm!     œk7 PROJECT%&'()*+œ0/œ$56789pÂœSummaryInformation('ÄDocumentSummaryInformation8Ö ID="{BCAC3126-382E-11D6-A674-00C04FC21ECE}" Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 Module=Module1 Document=ThisWorkbook/&H00000000 Module=Module2 Module=Module3 Module=Module4 Module=Module5 Module=Module6 Document=Sheet6/&H00000000 HelpFile="" Name="VBAProject" HelpContextID="0" CMG="595BB838BC38BC38BC38BC" DPB="2022C102C202C202" GC="E7E506010A0FD010D0102F" [Host Extender Info] &H00000001=ìK)^   rUÄÄ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~& !Pu"?F÷¶y¿O¬‘  ” Éäa qÒ9©Éäa Å ¡Éäa Å  Ò A ȽÒÈ A‹Éäa Å ˜à ÈA˜ÅôÉäa Å 9˜ È‹Sheet1Sheet2Sheet3Sheet4Sheet5 VBAProjectÔ¿F=C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.dllVBA A iÒ(¿F +C:\Program Files\MSOffice\Office\EXCEL8.OLBExcel YÅ·80¿FC:\WINNT\System32\stdole2.tlbstdole Worksheetzap Qy¡H“§½tSŒ¶7¿O¬‘C:\WINNT\System32\MSForms.TWDMSForms aAâ‹X·.E èýÖ.`åM ¥o¨Ÿ$÷¶s¿O¬‘C:\TEMP\Excel8.0\MSForms.EXD iAë‹hL­¯-™[‡ÂDÞR *C:\Program Files\MSOffice\Office\mso97.dllOffice 1Y¼xÿ¿F1¨º.8÷¶t¿O¬‘ ¿F1¨º.8÷¶t¿O¬‘D¿Fb³ãBÏ‘û `Û Convertor`³ãBÏ‘û `Ûc³ãBÏ‘û `Û H88Module1  ThisWorkbookzapmzapMconverttest1¿Fë X¿Fë ‹ ItemValue VBA332.DLL a 1 ÄVLookup¹¿F A99:A100 SAP Values׿FRangeF¿F/1¨º.8÷¶t¿O¬‘.1¨º.8÷¶t¿O¬‘ @ 'SAP Values'cvCellMacro4Macro5Macro6 D3ConvertEMacro8 C3 Metric English C8:D20 soapsheet.xlt!cvCell H8:H20 K8:K20 C26:C29Text Recipe WorksheetActivateConvert cvCell C32  C8:C20ë1¨º.8÷¶t¿O¬‘ê1¨º.8÷¶t¿O¬‘Convertor_Click Convert®1¨º.8÷¶t¿O¬‘ß1¨º.8÷¶t¿O¬‘¡{lØ‘üFWJOCommandButton1@2×i‘Õßwð _PID_GUID”AN{EA68B8C1-B65F-11D4-8BB0-00A024003913}œ ¿FMicrosoft Excel WorksheetBiff8Excel.Sheet.8Ù9¾qCompObjfice\Templates\2E16FCD0éf Sheet1-&'()*+,œ/2œB?89e @__SRP_28é__SRP_3G±