Home Cosmetic Science Talk Formulating Formula Calculator

Tagged: 

  • Formula Calculator

    Posted by David08848 on April 21, 2016 at 4:55 pm

    Is there a calculator (online or APP or anything else) that assists in calculating 100% formulations and helps to recalculate for additional ingredients?

    DavidW replied 7 years, 12 months ago 5 Members · 13 Replies
  • 13 Replies
  • Bobzchemist

    Member
    April 21, 2016 at 6:04 pm

    I think we’ve posted them on here on a few occasions. It’s not really that hard to set up on excel. What specific functions are you looking for?

  • David08848

    Member
    April 21, 2016 at 6:09 pm

    Excel and I aren’t the best of friends! I just want to change a few “recipes” into proper formulas without having to use a calculator and be able to add more ingredients to a formula and recalculate the percentages properly without doing the old “Oh just take it out of the water phase” which is not the best way to do things! Other than that not much else! I’ll check for a calculator here in previous posts.! Thanks, Bob!

  • DragoN

    Member
    April 22, 2016 at 4:37 pm

    There is…but you want one to work in reverse for you by the sounds of it…You have the formula but you haven’t worked the %,,,,,

    Make one for you ….but I want http://shop.stonecottagesoapworks.com/Spiced-Myrrh-Premium-Shaving-Cream.html

    …the scent….250 mls to start…life time deal for both…lol…as am not a greedy person.,

    I don’t want the secret of how you made it….just the sniffly stuff for personal use..when I run low….you resupply… B)

    ….to sweeten the deal…can add a cost calculator to that for you…but…what will you offer me?

    Deal?

  • David08848

    Member
    April 23, 2016 at 1:26 pm

    So I’m not looking for an HLB calculator but I did find this:

    http://www.ingredientstodiefor.com/item/Amount_to_Percentage_Calculator/873?category=115

  • DragoN

    Member
    April 23, 2016 at 5:46 pm

    Google is a wonder, isn’t it?

  • David08848

    Member
    April 23, 2016 at 6:34 pm

    Any search on the Internet for a calculator should work if you know the specific name of the thing you are seeking. This many mean trying many combinations of words you think will give you what you are seeking. In this instance I could only describe the functions of the calculator I seek and fortunately came up with “recipe to formula calculator” and I found this one right away. Further search should produce an Excel version and one that can recalculate the addition of ingredients into a formula to recalculate it back to 100%!

  • DragoN

    Member
    April 23, 2016 at 8:07 pm

    Whatever works best for you. I am far too particular to rely on anyone else to run my numbers.

    .so ..now I have another one ..

    “recipe to formula calculator”
    That makes zero sense…but if it works…lol…might work in the meta data taggie thingie madoodies or whatever the heck they are. Thanks for the suggestion.

  • Bobzchemist

    Member
    April 23, 2016 at 11:27 pm

    @Perry? Do you know where they are?

  • OldPerry

    Member
    April 25, 2016 at 2:51 pm

    Here is a spreadsheet and a video with instructions on how to use it.

    https://chemistscorner.com/cosmetic-formula-spreadsheet-template/

    Cosmetic Formula Spreadsheet Template

  • David08848

    Member
    April 26, 2016 at 2:07 am

    Perry, thanks so much for posting this! I think I can work with this Excel sheet! It looks friendly!

  • DavidW

    Member
    April 26, 2016 at 11:06 pm

    @David08848 I think you should still send DragoN some of the product she requested. Go ahead, make her day. I dare you :)

  • David08848

    Member
    April 26, 2016 at 11:47 pm

    DavidW,

    This is a board that Perry created to share his and other people’s knowledge with those who need help. Someone will ask a question and another person will answer to the best of his or her ability. The person who has answered that question may at some time come back and pose a question him or herself and be helped by someone else and thus the world goes ’round and everyone shares with each other. It’s all about sharing knowledge…

  • DavidW

    Member
    April 28, 2016 at 2:11 am

    @David08848 I guess you couldn’t tell I was trying to be funny.  I am well aware of the purpose of the board.  If you check you’ll see I have been on here for 2 1/2 years have have tried to help more than my share of people.

    By the way, I still think you should send DragoN a jar of your product.

Log in to reply.