As a scientist (food/cosmetic ingredient R&D) working with formulas and spreadsheets most days, I forget that there are DIYers who have forgotten their 6th grade math, yet decide they want to make personal care products and cosmetics. You are their hero. I hope they buy your book, too - I did and it is superb!! And thank u for constantly reminding your audience to not DIY SPF, and that preservatives are necessary.
@@HumblebeeAndMe Hello. I'm following step by step, but when I try to add the Average on the F Column, all of the numbers turn into the 1st number. Same thing happens with the A (weights ), also C (Percentages). It will not allow me to select the all in said Column so that I can average/percentage/sum it all up together, without doing it one by one. Please help 😥
THANK YOU! THANK YOU! After many searches, you have demonstrated exactly what I've been in search for. Iam truly blessed to have found your channel. May Heaven continue to smile upon you!❤
Anytime you want to make more videos on this subject, I am sure there are many like me that would appreciate it so much. I am working on it and trying to get it all down. Repetition is the key to learning, so I am trying to get a little time with this daily. As much computer work as I have done, I have never, ever used a spreadsheet! Some things carry over, but I am just in the dark about most of it, lol. I appreciate you. This is a very interesting subject and can't wait to work out percentages on every recipe I have. I am having a little bit of trouble with the scaling...and that probably should be the easiest part! Kudos, Marie! My request is for more, much more like this! I think it is vital to help us understand formulations in percentages and how to scale to precision ♥. Thanks for all you do!
I'm so glad you enjoyed this, Pamela! Have you watched the other one on formulating with spreadsheets? It's also really helpful and covers similar but slightly different material :) Happy making!
I asked in a previously viewed video about measuring drops from an eye dropper rather than from a bottle. Nevermind!!! This video answered my question...
Thank you so much for this video!!! I am a newbie into the world of formulations with fragrances and recipes. I could not find anything that would help me with percentages and scaling my trial size formulations. You are an angel for sharing!!
Awesome video! This was an excellent presentation and explanation! Thank you so much for your willingness to share your knowledge and expertise with us. ❤
I bought your book, I loved it so much that I bought another copy for my friend’s Christmas present! It arrived this morning ☺️ Thanks for this upload, scaling takes up much of my thoughts these days. Love this new diy life. X
Wow you just blew my mind 🤯 I am horrible at math and I would have never figured that out. Thank you for always sharing a piece of your brain with us 😁
This is just so helpful. I was going to try and do it all by using a calculator. I don't know spreadsheets well, but you simplified this and are a really good teacher. I am commenting here, but like you said before, it would be better to comment on your blog. Thank you again!
I use an online percentage calculator at WSP but it is really nice to know there are resources out there to use that are also easy to calculate percentages for formulating. Another awesome upload! Thanks Marie ❤️Jen
I just tried this spreadsheet method for a new formulation I am considering and it worked like a dream! Thank you so much once again Marie. Timesaver for sure!
Awesome! My favourite thing about this method is the ability to save the formulations for super-easy search-ability. I also use the spreadsheets to store different iterations of formulations + notes about each version. I find it makes formulation evolution-both within a single formulation and as I work on developing new versions of older formulations-much faster and easier ❤️ Thanks for DIYing with me, and happy making :)
You are amazing!!thank you so much, you dont have idea how your videos and your book are teaching me, for you i discovered my passion thank you Marie!!❣
I totally LOVE this!! I found your video about this years ago and have been using this for all my formulations! Once I know how much of a final product weighs, just plug in the multiple of how many I want to make and none to very little waste! Thank you soooo much!!!
Thank you so much for this video. This is so helpful♥️. Please, I have a question to ask and it would be highly appreciated if you could help me out🙏. How best do you advice to convert skincare ingredients that are in liquid and powdered form to percentage as compared to chucked ingredients like the beewax used in the video. Especially when the initial measurements are given in tablespoons, teaspoons, cups and ml. For example, if a recipe formulation says (NOTE: this recipe isn't a real formulation for any DIY product, it was only written for better illustration): ½ cup of glycerin 5 tsp of aloe vera gel 2 tbsp of glutathione powder 10ml of Papaya extract THANK YOU, ma'am.
Thank you so much for explaining this topic! I just made a new batch of my sugar scrub using the percentage method you described but it didn't turn out exactly like my old recipe. How do I add more of a specific ingredient (in my case I need to add more oil) to my finished scrub and figure out how that will affect my percentage calculation? Example, I am currently using 77% sugar, 13% oil & 9% herbal extracts, 1% preservative. But my finished scrub is too dry, so I need to add more oil which means my percentage will change and that means all the other percentages will shift too, so how do I adjust my recipe for next time based on how much more oil I need to add this time? I hope this makes sense. Any help is appreciated!! Thank you : )
How do you decide how much water to add to a formula? Can I pick my oil % (10-30%), my emulsifier (2-6%) my preservative (0.5-2%) can I make the remaining percentage water+ glycerin +etc) this is just a rough draft but can my remaining percentage be water?
HI unfortunately I am old and my eyes have just gone cross with all these formulas, my google sheet looks totally different, is there a link to use so I font have to do all this?
This may be a dumb/simple question but I was able to understand all that you put into this video until you got to changing the batch number at the end 😅 What exactly is a batch number and what is it based upon? Right now I am telling myself that the batch number is dependent upon the size of the bottle we'll be using to put the product into, wanted to reach out and see if that is correct or not? (I may just be overthinking all of this)
Your batch size is based on how much you want to make-which is very often dictated by what size of container you're planning on using. It'll also vary with WHAT you're making; 100g (3.5oz) of lotion isn't a lot, but it's a lifetime supply of lip balm!
@@HumblebeeAndMe wow, 3yr old video and getting an active response within 24hrs. Tossing you a sub (no Jimmy Johns) for that, keep up the good work! Will continue to utilize ya channel for my personal projects.
How do I figure out how to scale down the batch without the spreadsheet? Like how do I do the math? I’m super bad at math to begin with and really want to be able to make trip batches
Hello mam your videos are so motivative ...to try but some ingredients won't get easily.. can you give any alternative for liquid germal plus..which I can get easily in india and preserve ..lots of love 😘,😘 to you sending from India
Thanks for watching! You'll find the answers you're looking for in the Humblebee & Me Encyclopedia at www.humblebeeandme.com/diy-encyclopedia. Simply look up Liquid Germall™ Plus to learn about substitutions and more. Happy making!
OMG. I've been wondering if there's a way to change grams to their percentage! I've been guessing this WHOLE time ("3.5%? no. 3.54%? too high. 3.53%? ahh there. That takes me to the grams I need")
As a scientist (food/cosmetic ingredient R&D) working with formulas and spreadsheets most days, I forget that there are DIYers who have forgotten their 6th grade math, yet decide they want to make personal care products and cosmetics. You are their hero. I hope they buy your book, too - I did and it is superb!! And thank u for constantly reminding your audience to not DIY SPF, and that preservatives are necessary.
Thank you so much, Kristen! You've put a massive smile on my face 😊
@@HumblebeeAndMe Hello. I'm following step by step, but when I try to add the Average on the F Column, all of the numbers turn into the 1st number. Same thing happens with the A (weights ), also C (Percentages). It will not allow me to select the all in said Column so that I can average/percentage/sum it all up together, without doing it one by one. Please help 😥
THANK YOU! THANK YOU! After many searches, you have demonstrated exactly what I've been in search for. Iam truly blessed to have found your channel. May Heaven continue to smile upon you!❤
Anytime you want to make more videos on this subject, I am sure there are many like me that would appreciate it so much. I am working on it and trying to get it all down. Repetition is the key to learning, so I am trying to get a little time with this daily. As much computer work as I have done, I have never, ever used a spreadsheet! Some things carry over, but I am just in the dark about most of it, lol. I appreciate you. This is a very interesting subject and can't wait to work out percentages on every recipe I have. I am having a little bit of trouble with the scaling...and that probably should be the easiest part! Kudos, Marie! My request is for more, much more like this! I think it is vital to help us understand formulations in percentages and how to scale to precision ♥. Thanks for all you do!
I'm so glad you enjoyed this, Pamela! Have you watched the other one on formulating with spreadsheets? It's also really helpful and covers similar but slightly different material :) Happy making!
I asked in a previously viewed video about measuring drops from an eye dropper rather than from a bottle. Nevermind!!! This video answered my question...
Thank you so much for this video!!! I am a newbie into the world of formulations with fragrances and recipes. I could not find anything that would help me with percentages and scaling my trial size formulations. You are an angel for sharing!!
Awesome video! This was an excellent presentation and explanation! Thank you so much for your willingness to share your knowledge and expertise with us. ❤
I bought your book, I loved it so much that I bought another copy for my friend’s Christmas present! It arrived this morning ☺️ Thanks for this upload, scaling takes up much of my thoughts these days. Love this new diy life. X
Wow you just blew my mind 🤯 I am horrible at math and I would have never figured that out. Thank you for always sharing a piece of your brain with us 😁
I'm so glad you found it helpful! ❤️
Thank you so much for sharing this spreadsheet. This has taken the stress out of making sure I have the right percentage all the time.
I'm so thrilled to hear it! ❤️
This is just so helpful. I was going to try and do it all by using a calculator. I don't know spreadsheets well, but you simplified this and are a really good teacher. I am commenting here, but like you said before, it would be better to comment on your blog. Thank you again!
I use an online percentage calculator at WSP but it is really nice to know there are resources out there to use that are also easy to calculate percentages for formulating. Another awesome upload! Thanks Marie ❤️Jen
I just tried this spreadsheet method for a new formulation I am considering and it worked like a dream! Thank you so much once again Marie. Timesaver for sure!
Awesome! My favourite thing about this method is the ability to save the formulations for super-easy search-ability. I also use the spreadsheets to store different iterations of formulations + notes about each version. I find it makes formulation evolution-both within a single formulation and as I work on developing new versions of older formulations-much faster and easier ❤️ Thanks for DIYing with me, and happy making :)
you are a life saver !! thank you ! ♥
I learn something. Thank for sharing it spreadsheet 😊
You are so welcome!
Thank you, you're the best!!!!! ❤️
What a great video....exactly what I was looking for!!! Thanks 🙏
Glad it was helpful! ❤️
Thanks for watching!
You are amazing!!thank you so much, you dont have idea how your videos and your book are teaching me, for you i discovered my passion thank you Marie!!❣
I'm thrilled to hear it! ❤️
Just amazing. Thank you for this 😊.
I totally LOVE this!! I found your video about this years ago and have been using this for all my formulations! Once I know how much of a final product weighs, just plug in the multiple of how many I want to make and none to very little waste! Thank you soooo much!!!
Hooray! I'm so glad you are loving it and finding it so helpful ❤️
Yes!!! Thank You Sweet Humble Bee 🐝!!!
❤️
Thank you so much for making this for us!!!❤️
❤️ Thanks for watching!
Owesome explication! Thank you 🙏
Glad it was helpful!
This is so helpful!
I'm so glad!
Thank you so much for this video. This is so helpful♥️. Please, I have a question to ask and it would be highly appreciated if you could help me out🙏. How best do you advice to convert skincare ingredients that are in liquid and powdered form to percentage as compared to chucked ingredients like the beewax used in the video. Especially when the initial measurements are given in tablespoons, teaspoons, cups and ml. For example, if a recipe formulation says (NOTE: this recipe isn't a real formulation for any DIY product, it was only written for better illustration):
½ cup of glycerin
5 tsp of aloe vera gel
2 tbsp of glutathione powder
10ml of Papaya extract
THANK YOU, ma'am.
It's exactly the same-measure and weigh.
Thank you so much for explaining this topic! I just made a new batch of my sugar scrub using the percentage method you described but it didn't turn out exactly like my old recipe. How do I add more of a specific ingredient (in my case I need to add more oil) to my finished scrub and figure out how that will affect my percentage calculation? Example, I am currently using 77% sugar, 13% oil & 9% herbal extracts, 1% preservative. But my finished scrub is too dry, so I need to add more oil which means my percentage will change and that means all the other percentages will shift too, so how do I adjust my recipe for next time based on how much more oil I need to add this time? I hope this makes sense. Any help is appreciated!! Thank you : )
Thanks so much for this, it's a HUGE help 😄
I'm so glad! :)
Thank you so much for this!!!
Thanks for watching!
How do you decide how much water to add to a formula? Can I pick my oil % (10-30%), my emulsifier (2-6%) my preservative (0.5-2%) can I make the remaining percentage water+ glycerin +etc) this is just a rough draft but can my remaining percentage be water?
So your template with 400-100-25g batches are those percentages? I entered my g in for one single bottle but I’m confused now after I did the % lol
Thank you so much! You are so helpful ❤️
Glad it was helpful!
ver helpful! Thank you so much!
You're welcome! ❤️
Hi. What brand of scale would you reccomend to purchase for weighing products for diy formulations?
Please visit the "Equipment" section of the Humblebee & Me DIY Encyclopedia (www.humblebeeandme.com/diy-encyclopedia/) :)
OMG Thank you!
I'm so glad you found this helpful! :)
HI unfortunately I am old and my eyes have just gone cross with all these formulas, my google sheet looks totally different, is there a link to use so I font have to do all this?
I want rearrange formulation on basis of any ingredient not by final volume! any solution?
My Goooooood!!!!!! I just can't comprehend those freaking percentages :( I guess I'm stuck with grams.
This may be a dumb/simple question but I was able to understand all that you put into this video until you got to changing the batch number at the end 😅 What exactly is a batch number and what is it based upon?
Right now I am telling myself that the batch number is dependent upon the size of the bottle we'll be using to put the product into, wanted to reach out and see if that is correct or not? (I may just be overthinking all of this)
Your batch size is based on how much you want to make-which is very often dictated by what size of container you're planning on using. It'll also vary with WHAT you're making; 100g (3.5oz) of lotion isn't a lot, but it's a lifetime supply of lip balm!
@@HumblebeeAndMe wow, 3yr old video and getting an active response within 24hrs. Tossing you a sub (no Jimmy Johns) for that, keep up the good work! Will continue to utilize ya channel for my personal projects.
How can you use excel to calculate the cost of your diy?
can you make the BB CREAM WATERPROOF formulation
I'll keep it in mind :)
How do I figure out how to scale down the batch without the spreadsheet? Like how do I do the math? I’m super bad at math to begin with and really want to be able to make trip batches
Beauty and brains!!!
🐝😊
Hello mam your videos are so motivative ...to try but some ingredients won't get easily.. can you give any alternative for liquid germal plus..which I can get easily in india and preserve ..lots of love 😘,😘 to you sending from India
Thanks for watching! You'll find the answers you're looking for in the Humblebee & Me Encyclopedia at www.humblebeeandme.com/diy-encyclopedia. Simply look up Liquid Germall™ Plus to learn about substitutions and more. Happy making!
Amazing woman thank you?.
Thanks for watching!
OMG. I've been wondering if there's a way to change grams to their percentage! I've been guessing this WHOLE time ("3.5%? no. 3.54%? too high. 3.53%? ahh there. That takes me to the grams I need")
HOORAY! 😄
I need your e-book pls
PLEASE HELP! My BODY BUTTER KEEPS GETTING HARD AND GRESY NO MATTER HOW MANY TIMES I HAVE TRIED
Hey there, no need to yell. Have you watched my body butter FAQ video? There's TONS of info in there ;)
1st to go ... ❤️
🏆
I am here
😄
I hate maths but love you its so easy marry
I'm glad it was helpful ❤️
present😂😂😂💄💄
😄