Guest guest Posted October 30, 2003 Report Share Posted October 30, 2003 The usual rules apply; List Owners/Moderators are not responsible for the outcome of this sale. For beautiful lotions and creams!!!! This HLB (Hydrophile-Lipophile Balance System) Calculator requires very little input and will save many precious hours for those who do HLB calculations by hand. The following describes the basic use of the HLB Calculator. The Calculator is made up of four parts. All ingredients are added to the phases by using convenient drop down menus. There are four separate tabs (Water Phase, Oils & Waxes, Emulsifiers and Miscellaneous) that have many ingredients already in them. Any ingredients not found will need to be entered into the respective tab for that phase. When you leave the tab it will automatically put the items in alphabetical order. Water Phase – Enter all ingredients that go into the water phase excluding water. Since water percentage is automatically calculated, the total of the formula will always equal 100%. Oil & Waxes Phase – Enter all ingredients that would be included in this phase. HLB is automatically added. Enter the percentage of total for that oil/wax and the overall portion of HLB that the oil contributes to the mix will be calculated. Emulsifying Phase – HLB is achieved by balancing the two emulsifiers to achieve the weighted HLB of the oils from the oil phase. The program will not allow the use of emulsifiers that would produce an incorrect balance. First enter the percentage of total for the emulsifiers. The actual percentage of each emulsifier will be calculated based on the weighted HLB of the oils and waxes. The first emulsifier should have an HLB lower than the weighted HLB of the oils and waxes. The second emulsifier should have an HLB higher than the weighted HLB of the oils and waxes. There are normally wide ranges of emulsifiers that meet those requirements. Misc. Phase – This phase is for Fragrance, Essential Oils and preservatives. A bonus with this calculator is the Formulary tab. All the values from the calculator are carried over into the Formulary tab. By entering the size of the batch and the units, i.e. 16 oz, the weight of each ingredient for the recipe will be calculated. Next, print out the page and the recipe is ready! The HLB Calculator is to be used by people that already know the HLB System or are in the process of learning it. The HLB System is not a foolproof system. It's a tool. There are a number of ingredients that have different required HLB values and HLB values. For example: Lecithin has an HLB value of 4-9 depending on the manufacturer. You will need to know the HLB of your Lecithin according to the manufacturer it was purchased. A large list of required HLB and HLB values is included in this calculator. The user will have to change any values that may differ from the ones in the calculator to reflect the values of the ingredients the formulator is using. Detailed instructions are included with the calculator. This calculator is a Microsoft Excel workbook and has been tested with Excel 97/2000. It should also work with Excel XP and Excel 2003, but has not been tested. For anyone that is interested please email me (Diana Ard) off list at diana34@s... for more information or you can go directly to the Online Merchant website to purchase calculator. COMPANY CREATOR: Forever After Bath & Body URL: http://www.soapsupplies.net/calculator.html HLBTalk Group: HLBTalk/ COST: $14.00 ONLINE MERCHANT: www.soapsupplies.net PAYMENT FORMS: Paypal, Check, Credit Cards, Money Order 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.