Guest guest Posted August 11, 2003 Report Share Posted August 11, 2003 >I do wish there was a little more detail to the spreadsheet. It's >pretty bare bones - or - perhaps I just need more eduation ??? LOL You are correct. I should've put some directions down. The next revision will have directions. All you have to do is put the percentages of oil/waxes/butters in column C, starting in cell C3, and put the corresponding required HLB in column D, starting in cell D3. There is enough room for 20 different oils, waxes or butters. Next enter the names of the emulsifiers used in cells C26 and C27. Enter the HLBs of the emulsifiers in C29 and C30 and enter the amount of emulsifer in cell C32. And if all goes according to plan, the results will appear in column G. Maurice -------------------------------------------------------- Maurice O. Hevey Convergent Cosmetics, Inc. http://www.ConvergentCosmetics.com ------------------------------------------------------- Quote Link to comment Share on other sites More sharing options...
Guest guest Posted August 11, 2003 Report Share Posted August 11, 2003 At 05:40 PM 8/11/03 +0000, you wrote: >Try the one I uploaded this morning and let me know. the advantage of being on digest and too busy to get to it earlier... by Monday nite it's downloading beautifully...thank you!!! Your source for superb Essential Oils, Aromatherapy Accessories, Information, Books and more! Visit us at: <http://www.naturesgift.com> Quote Link to comment Share on other sites More sharing options...
Guest guest Posted August 13, 2003 Report Share Posted August 13, 2003 HLB & RHLB Calc Rev 4 has been added to HLB_System folder in the CosmeticInfo files area http://groups.yahoo.com/group/Cosmeticinfo/files/HLB_System/HLB_ & _RHLB_Calc_Rev_\ 4.xls Try it out and let me know if you have any problems. This version requires less data entry and I think it is easier to use. Thanks Maurice -------------------------------------------------------- Maurice O. Hevey Convergent Cosmetics, Inc. http://www.ConvergentCosmetics.com ------------------------------------------------------- Quote Link to comment Share on other sites More sharing options...
Guest guest Posted August 15, 2003 Report Share Posted August 15, 2003 >In your HLB Calculator (which is da bomb!) field H6 is >requiring a number in response to the question: How much >emulsifier do you want to use? This was discussed earlier this week. > > >>how do I determine how much total emulsifiers to use? Is there a >>specific formula for this? > >The amount of emulsifier to used is a guesstimate based on experience and experiments. I usually start with 2% to 3%. >This is where Tri-Chemistry comes into play. You should start with 5% total >emulsifier in the first set of experiments and also go + & - 5% from your >calculated ideal ratio. Make this first set of three experiments and look to >see which one looks best. It may not be the idea that you calculated. >Remember, the HLB system is only a tool and is not exact. If none of them >look good then go back and again expand the ratio of the emulsifiers used >and do the experiment again. When you find the optimum ratio from this 5% >total emulsifier level then make another experiment using 2.5% emulsifier >and look at the results. If it looks good then you may be able to reduce the >level again; if it looks bad then you may have to increase the amount. The >purpose of this is to find the ideal amount needed to make a stable >emulsion. You want to use the least amount necessary to make your product >and QS the water. >Is the correct response to this query in the form of a >percentage? or the weight-amount? or some other logical >response that I am not considering? Everything is expressed in terms of percenatge. Maurice -------------------------------------------------------- Maurice O. Hevey Convergent Cosmetics, Inc. http://www.ConvergentCosmetics.com ------------------------------------------------------- Quote Link to comment Share on other sites More sharing options...
Guest guest Posted August 15, 2003 Report Share Posted August 15, 2003 On Thu, 14 Aug 2003 18:43:08 -0500 (CDT), a CosmeticInfo member wrote: >Can you add kokum butter to the spreadsheet, please? If >you can find a more accurate value than <around 2> per the >tech at Biochemica.com, that would be great. If you are using HLB_ & _RHLB_Calc_Rev_4.xls, then you can add any oils, waxes or butters that you need or want. Just go to the list of oils, waxes and buuters and add " kokum butter " in cell B60. I would use 8 as the required HLB. The RHLB ID for kokum butter will be 2058. When you type in " 2058 " in column A, kokum butter and it's required HLB will show up in the display. HLB_ & _RHLB_Calc_Rev_4.xls will accept over 40 additional oils, waxes or butters. You can also add additional emulsifiers. >And how about room for 3 emulsifiers on that side of the >equation? I'll take a look at it. -------------------------------------------------------- Maurice O. Hevey Convergent Cosmetics, Inc. http://www.ConvergentCosmetics.com ------------------------------------------------------- Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.