How to Scale ANY Formulation + How to Convert Any Formulation to Percentages // Humblebee & Me
Vložit
- čas přidán 27. 06. 2024
- Partner blog post: www.humblebeeandme.com/how-to...
Formulating and DIYing with Spreadsheets blog: www.humblebeeandme.com/formul...
Formulating and DIYing with Spreadsheets video: • Formulating and DIYing...
CHAPTERS
00:00 Intro
00:55 Important details
02:51 Spreadsheet setup
04:03 Weighing things that were measured by volume
05:39 Converting to percentages
08:23 Number polishing
10:15 Scaling
12:09 Sign-off
Background music composed by Chris: / @acousticmotorcycle (THANK YOU!!!)
Sign up for my FREE DIY SKIN CARE FOR BEGINNERS COURSE:
humblebeeandme.com/free-diy-s...
My book!
Make it Up: The Essential Guide to DIY Makeup and Skin Care
humblebeeandme.com/make-it-up...
Blog: humblebeeandme.com
Patreon: / marierayma
Instagram: / marierayma
Facebook: / humblebeeandme
Twitter: / marierayma
Pinterest: www.pinterest.ca/marierayma/
#humblebeeandme #stubbornlyDIY #formulationskills
Humblebee & Me is an Amazon Associate and earns from qualifying purchases. - Jak na to + styl
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 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!!
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 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
Yes!!! Thank You Sweet Humble Bee 🐝!!!
❤️
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 ❤️
Awesome video! This was an excellent presentation and explanation! Thank you so much for your willingness to share your knowledge and expertise 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!
Just amazing. Thank you for this 😊.
Thank you so much for making this for us!!!❤️
❤️ Thanks for watching!
What a great video....exactly what I was looking for!!! Thanks 🙏
Glad it was helpful! ❤️
Thanks for watching!
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! ❤️
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! ❤️
Owesome explication! Thank you 🙏
Glad it was helpful!
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! ❤️
This is so helpful!
I'm so glad!
Thank you so much! You are so helpful ❤️
Glad it was helpful!
Thank you so much for this!!!
Thanks for watching!
ver helpful! Thank you so much!
You're welcome! ❤️
Thanks so much for this, it's a HUGE help 😄
I'm so glad! :)
I learn something. Thank for sharing it spreadsheet 😊
You are so welcome!
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 :)
OMG Thank you!
I'm so glad you found this helpful! :)
Beauty and brains!!!
🐝😊
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 : )
My Goooooood!!!!!! I just can't comprehend those freaking percentages :( I guess I'm stuck with grams.
1st to go ... ❤️
🏆
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
can you make the BB CREAM WATERPROOF formulation
I'll keep it in mind :)
Amazing woman thank you?.
Thanks for watching!
How can you use excel to calculate the cost of your diy?
I want rearrange formulation on basis of any ingredient not by final volume! any solution?
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. 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/) :)
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.
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
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 need your e-book pls
present😂😂😂💄💄
😄
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!
I am here
😄
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.
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 hate maths but love you its so easy marry
I'm glad it was helpful ❤️
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 ;)