Formulating and DIYing with Spreadsheets
Вставка
- Опубліковано 22 сер 2024
- THE BLOG POST
www.humblebeea...
Sign up for my FREE DIY SKIN CARE FOR BEGINNERS COURSE:
humblebeeandme...
My book!
Make it Up: The Essential Guide to DIY Makeup and Skin Care
humblebeeandme...
Blog: humblebeeandme.com
Patreon: / marierayma
Instagram: / marierayma
Facebook: / humblebeeandme
Twitter: / marierayma
Pinterest: www.pinterest....
THE FAQ
www.humblebeea...
THE ENCYCLOPEDIA
www.humblebeea...
Humblebee & Me is an Amazon Associate and earns from qualifying purchases.
Mind Blown, Runs to cry in the bathroom for all the time wasted before.
Spreadsheets have always baffled me as I have never worked in an industry that needed them (clothing/food) but Marie, you just made them seem so easy. Thank you!!
You are so welcome, and YAY! ❤️
Wow this has opened an entire new world to me! I have been stumped about how to add ingredients not in your recipes that I love, not sure what ingredients quantities must be changed if I want change viscosity or if I want a bigger oil phase or more surfactant in a face cleanser. But I feel like the little tips in here not about spreadsheets per se (like emulsifiers should generally be included at a ratio of 1:3 or 1:4 of the oil phase) and this led me to other internet corners to learn the ranges of active surfactant matter in different types of cleansers... I am excited to tweak your recipes and really make them work for my skin! THANK YOU so much for sharing your extensive knowledge and excel formulas, lol!
HOORAY! This is exactly what I was hoping people would feel/experience when I made this video ❤️ I am so glad you're feeling excited and inspired! ❤️ Thanks for DIYing with me, and happy making :)
You changed my life... I don't have words how to thank you.. you can't imagine how much respect i have for you...i always get benefited from your videos
Formulating on spreadsheets has been very important in developing any and every product I make... I also use it to calculate the cost to make the product and retail cost... very good information Marie... I love this post... very very useful
Excellent! I have used them to calculate cost per gram as well, but since selling isn't a huge focal point for me I rarely bother these days. It's definitely a total must for anybody with a business, though! Knowledge/ math/ spreadsheets are power 😝
Can you share how you use your spreadsheet for cost. I've been told I under charge, but I thought they were good prices 🤔
Thanks!
What I did in the past was make a spreadsheet where one tab was a list of my ingredients with the cost/g (divide price paid by grams received). My formulas would be in another tab, and I could call in the cost per gram value from the other tab and multiply cost per gram by number of grams, and then sum that up and divide by the number of units. Don't forget to take the costs of packaging, labelling, ingredient shipping (to yourself!), insurance, your accountant, and all that into your prices as well-you don't want to end up in a place where your business is costing you money! Best of luck & happy making!
@@HumblebeeAndMe thanks so much, that was a lot but I think I can figure it out... unless you want to make a video😉😉😊
I'm a little intimidated by this topic but if I watch this a few dozen more times, I might scratch the surface of understanding it.
I'm sure you will! It is so useful and once you've got the hang of it I think you'll be hooked ❤️
Carol Hanson I feel the same way right now lol
Is tgere a way to do this with good old math for those of is that would prefer to do it that way? Please?
Thanks so much Marie. I don’t know much about spreadsheets but love to play with them. Your explanations were clear and succinct. Saying that, I still got a bit lost as the video progressed. I know I’ll have no problems once I’m actually working with it. I have to say I’m blown away with your latest additions to your blog. You work so hard to get out a ton of information and you have to know it doesn’t go unappreciated.
Have a very Merry Christmas!
Thank you so much! ❤️ The written part of the blog might also help clear things up-some things were easier to communicate in writing!
I'm so glad you've been noticing & appreciating all the work I put into my blog 😊 I love to share but it's always nice to know it is well received!
So with you there! Spreadsheets are amazing. Nobody gets it when I start talking with enjoyment regarding excel.
Right?! Spreadsheets FTW!
I wanted to thank you for your videos. I have been reviewing a couple of them (and your encyclopedia) because I wanted to dupe an expensive cream. It was one of those moments when seeing the price tag where I figured it couldn’t hurt to try and make it myself. After several learning opportunities, I made it today! When I saw the final product I couldn’t help but victory dance around. Totally felt empowered, smart, and successful- and wanted to let you know how you helped me.
I saw this post like 4 years ago, i was -10 at spreadsheets, watch a couple seconds and said "fu ck that!" . now, that i am more confident about using them, just a little bit, now i watch the entire video and apply everything you demonstrated. i wont stop from still doing this the old fashion way, with paper and pen, but i begin to using this spreadsheets for save time.
thank you very much Marie, greetings from Chile.
I never thought of using a spreadsheet... Thank you!
They are the BEST! The searchable part is amazeballs, too-can't do that with my handwritten notes (which I remember every time I have to search through them LOL).
Almost all my recipes are in a spreadsheet. I make a lot bread, charcuterie and sausage. The spreadsheets are based on the percentage of ingredients So great job on using spreadsheets Humblebee
OMGoodness. I sure hope people have told you that you are absolutely brilliant!! Love, love, LOVE your content. SUPER helpful!!! Thank you so much for all of your posts!! This one is really helpful, as always. Keep up the incredible work! xo
Thank you so much, Kirsten! I'm so stoked you found this helpful ❤️ Thanks for DIYing with me, and happy making :)
Thank you for the spreadsheet I really appreciate. Your follower from Zambia 🇿🇲
Glad it was helpful! ❤️
I love me some Marie❤❤❤. You have transformed me to being a spreadsheet fanatic. I used to hate it as I found it too hard for me to comprehend. But you Marie, are more than college tutor❤❤❤❤❤❤❤
Omg that was pretty cool to watch and yeah intimidating. Yep maths is not my best subject and spreadsheets use to be an action you do with sheets such as spreading sheets on a flat surface...just kiddin!! You made it look really easy and normally my brain shuts down when it comes to mathematical, technical jargon. But watching this video showed that formulating can be easy in a spreadsheet. So thanks for sharing this knowledge.
Woohoo, I'm so thrilled you found it useful! I definitely find it's worth the effort to set up the spreadsheet so it does the bulk of the work :) Happy making!
I am learning so much from you saving up to take Formula botanical classes I watch them daily I can’t wait
Marie, thank you so much for this video! I have been wanting to transfer my recipe notes from my scribbled notebook into the computer for so long now, but just didn't know how. My life is so much easier now when it comes to searching recipes, resizing, experimenting, etc. I think my favorite aspect is being able to convert my recipe from ounces (the size of the product container) to grams (for easy and precise measuring) without having to constantly pull out my phone to do the math for me. That alone saves me so much time when I'm prepping my ingredients. Again, thank you for showing us your format and formulas to get us started!
I am so thrilled you have found this to be so helpful! Over the past few years I've started doing everything in spreadsheets and I cannot understate how much it has helped me learn and grow as a formulator. Spreadsheets FTW! ❤️
@Brooklyn Turner Hello. I'd like to know how you were able to switch between ounces and grams. When I tried the spreadsheet thing, I had so much trouble with just trying to get the percentage right, even when I had the right percentage there, which is 100%. It would always change to 199.00%. I really felt like crying when I could not get it. Also, the batch amount has thousands and numbers behind the decimals. This makes it confusing for me to find out exactly how many grams in or Oz whichever it shows because I'm not sure. I want to use spreadsheet because I don't like the fact of having thousands of tabs open on my computer. And the fear of losing that data if anything goes wrong with my PC. Yet, I'm getting very frustrated and want to give up2
@@diagrier9963 I understand the confusion. UA-cam tutorials on spreadsheets are super helpful for this. It helps you understand cells and formulas. Make sure also that each column is of the right type of input, percentages, etc.
Thank you Marie. I always like to automate stuff. They really make life easier. But I've always been struggling to have people do stuff like these. From now on HANDS OOON YIHUUUUU😘😘😘😘😘😘😘❤️❤️❤️❤️❤️
Thank you so much for showing us how to make spreadsheets. This will really help taking me to the next level of formulations. The emulsifying formular is a bit tricky but im sure ill get there eventually
Oh Marie! Thank you so much for this video & blog post. I watched the video and read the blog in December when you first posted it but my lack of knowledge with spreadsheets was frustrating. I tried made some progress but muddled my way around. I left it alone and then came back and really picked each sentence apart and compared the samples to my own and I had an Ah-Ha! Moment. I got the cost per batch and basic spreadsheet down but until this morning I finally understood the scaling part where you have the percentages and just change the batch size and the grams compute. I FEEL SO SMART AND WELL EQUIPPED! I appreciate your willingness to teach others and the work involved to present it!
Hello, would you mind sharing how to add the overall cost per batch of the formulations please. I'm trying to learn how to do it, yet I'm really bad at math and trying my best to learn spreadsheets.
Hello, may you please share the process on how you do the cost per batch on the formulations. I'm very bad at math, and trying my best to learn the spreadsheet thing. May you please help
@@diagrier9963 I’m not the person you asked, and I’m betting you’ve already sorted it out since yours is an older comment… But I just saw Marie’s response to this question on another comment, and as someone who is really not great at math - I get the struggle - I thought I’d post her reply; Marie suggests:
1. Make a spreadsheet tab where you list all ingredients for a given formula;
2. List the cost per gram for each ingredient by dividing price paid for that ingredient (including tax and shipping to you) by the number of grams purchased;
3. Sum those itemized costs per gram up for the whole recipe and divide that total sum by the total number of units (bottles of lotion or tubs of body butter or whatever) for that formula’s recipe. That gives you your raw materials cost per package for each item you just made, but now you have to…
4. Add in the itemized costs of packaging, labeling, lab testing, ingredient shipping to yourself, insurance, your accountant, other related business expenses like utilities, storage fees, etc., [and, ideally, your hourly wage rate?] - add those costs into your per item pricing and divide it by item, as well. That gives you a starting price point per item.
As Marie points out, you don’t want to end up in a situation where your business is costing you money to do or it is not sustainable. All these costs are why many do this as a hobby vs. a business, because the costs involved often can make the per item price too high to justify it. But others can make it work somehow if the passion, drive, and logistics are in place.
Good luck! 🍀
Just came across this after months of tearing my hair out and many, many sheets of paper with scribbled notes on! Thank you so much for this, it's incredibly helpful and so much simpler for keeping track of recipes and formulation changes! Thank You!
Glad it was helpful + welcome to the spreadsheet fan club ❤️ Thanks for DIYing with me, and happy making :)
I’ve been doing this before launching omg! Yay! More validation!
Woohoo! Spreadsheet buddies!
Bloody marvelous!! I’m using spreadsheets but learnt more about ratios which is not easy to find online.
This is absolutely fabulous. Thanks, Marie. My spreadsheet for dummies LOL.
wow this was a total lifesaver. i just reformulated my stuff because of it :)! thanks a ton
Happy to help, and happy making!
Dang, now I may not make products anymore, I'll be too busy making spreadsheets! 😄 it's a toss-up which one my nerdy self would rather be doing. I need to make pretty tables that automatically look up all the details I could possibly want for my recipes...
Omg, need to watch while doing it to remember the cool formulas you used. I am so out of practice with excellent, that I now see it as a new thing to relearn.
I bet you'll catch right on in no time and be back at it like a champ 😄
I'm still almost as confused. However will copy a couple of your sample formulas so I could see what's going on. Then we'll start making up some of my own until I get a feel for it. This is going to take a while but I really appreciate this video. I never could get anybody to explain to me how a spreadsheet worked. They kept saying just use this. Not my style to use something without knowing what I'm doing totally. I think I'm going to be able to get this. Thank you, so many times over, thank you for this video.
No more feeling like I'm missing a big chunk of the whole picture
I'm confident you'll get the hang of it! Once you start making and manipulating the spreadsheets yourself I think it will seem much clearer :) Make sure you check out the blog post, too!
I think is a great topic, especially for newbee to learn from get go to formulate correctly. I recently used calc to formulate and took me for ever to balance the formula.
Thank you! I hope you can adopt some of the tips & tricks I've shared into your creative process!
Thank you for all the info you give. It is really appreciated. 😘
You are so welcome! ❤️
I am new to spreadsheets but I have always respected their power and usefulness. I have been timid around them though. I set up a practice one while watching and was able to follow along pretty well. Thank you for the work you put into this. I am off to read the blog post now.
I hope you fall madly in love with them! I bet you'll be a pro in no time 😉
This is brilliant as always. Pretty validating for me that I'd just finished doing this for all my formulations a couple of days ago, then happened upon this video! Yay! Learned plenty too, thank you so much.
Something I do in addition, because I work with slightly larger batch sizes, is enter how much packaging I'm wanting the batch size to fill and use that to calculate the total from that. The rest...basically the same but I'm not quite as organised or logical as you are (the benefits of experience, eh?). Having formulae throughout means it's gone from 20 minutes of scratching my head (screw ratio formulations lol) to 5 seconds of plugging in how many jars I want.
I wonder if a modern extension of calculating your active surfactants et al would be to have a tab set aside just for an index of those relevant figures, then throwing VLOOKUP at it so you don't need the calcs off to the side. But realistically that's just a bit of a flex, or for spreadsheets that are multiplayer...slight overkill for a behind the scenes sheet!
Never thought i could use spreadsheet for formulating products 😱!! Thank you Marie.
Spreadsheets are amazing! Hopefully you picked up some useful tips 😊
Marie ! thank you so much for this valuable information ! I love the way of your presentation.. it's simple, well explained and straight-forward !
Regarding minute 7:00 please share us how to calculate the amount of emulsifiers needed to make our lotion regarding different oils ! I've been looking everywhere for this specific info and I couldn't use anything in practice ! this will be a very valuable and precious vlog in youtube !
hope you'll read my comment and help me
Watch 9:04 :)
Hey there, would you possibly be able to show us how to include essential oils in the overall formulation not just in your oil mixture? Btw love love your channel. you are really a God send. Thank for all of this wonderful free information.
Súper helpful video! Thank you Marie 🤗💙
Thank you, I've been attempting to put my personal spreadsheet together as a newbee to soaping, but was running into some difficulty with the formulas, you help clear that up for me. For me the beginning of the video was very informative so I can correct my mistakes. The rest of the video will be better appreciated when I get further into body wash and face cleansers 😄. I want to thank you for sharing.
I'm so glad you found it useful! Happy formulating 😄
@@HumblebeeAndMe I sat up last night and funnily completed my spreadsheet, from soap formulation to final cost per batch. Thank you again this video was most appreciated
@Roxanne Oliver Hello, how did you learn the cost per batch part? I'm still trying to learn spreadsheets. Praying it's a way to get both formula, percentage, batch size ounces, and/or grams (learning how to switch between), also cost per batch all on one spreadsheet. Please help
Great Marie! Thanks
I'm so glad you found this helpful 😄
I'm excited you did this video, thank you, well needed
You are amazing!!! I really needed this to have an easier and more organized way to keep up with how much ingredients I use to make each product. New subbie!!!
Hooray! Don't forget to check out my blog (humblebeeandme.com)-I've been blogging since 2011 while I’ve only been on UA-cam since about 2016, so there is TONS more content on the blog! ❤️
Thank you for all the useful information, Marie. Everything is so nice structured.
I'm so glad you found it helpful!
You're amazing! Thanks!
Happy to help! Make sure you check out the partner blog post as well :)
Hi I'm a new subscriber, I have been binge watching your channel! Im in love! I was wondering if you had a video explaining pH? Thank you!
I don't, but Skin Chakra has some great posts on pH! Start with this one: skinchakra.eu/blog/archives/497-How-to-adjust-the-pH-of-your-cosmetic-products.html 😊
After a year. I find this very very helpful and insightful. Thanks Marie!
Glad it was helpful!
@@HumblebeeAndMe Pls Marie,I will like to know what I can use as a moisturizer while making a Handwash? I pray you reply.
This video is so valuable. Thank you very much.
Thanks so much, Janice ❤️
Thank you Marie for sharing. I wonder if anyone uses spreadsheets for inventory. If they are not a good tool for inventory, what suggestion you have, please? Thank you again.
I can't say I do, but I don't really maintain an inventory as I'm pretty haphazard with that sort of thing 😝 I loosely track things on Snupps (www.snupps.com/marierayma) but that's about it ha. Hopefully somebody else will have some more interesting tips for you!
Thank you so much Marie! You have been a wonderful guide in getting me started on my formulator path which eventually will lead me onto creating a business! This particular vlog has tackled something I have always wanted to use but never bothered to learn how to use! Pesky spreadsheets, I read your blog which breaks everything down perfectly. Maybe you could check out my blog when it is up and running. Once again Thankyou!
Thank you so much! All the best on your formulation & blogging journey 😊
Marie, I finally saw this video, and please know that it was VERY USEFUL for me, I really appreciate it.. I have a question about Active Matter Surfactants, which I never really understood, therefore just placed it in the back of my mind for later discovery.. hopefully you can help me better understand it. What is it exactly? How does it work? What is the best range to stay within? I am mainly interested in solid shampoo bars.. Thank you for all you do and your knowledge. Ana
Your God bless .Thanks so much I really appreciate you for this.needed this
I'm so glad you found it so helpful ❤️ There's also a free partner blog post linked in the description box if you want a quicker written reference. Happy formulating!
@@HumblebeeAndMe thanks so much
You're awesome!
❤️
Hello can you share more videos for Baby diaper rash balm and baby friendly moisturizing oils??
Neat! I've never thought of using spreadsheets.
They are SO useful! Hopefully you give 'em a try and fall in love ha.
@@HumblebeeAndMe I'll play with it ☺️
Thanks so much Marie
Thanks for watching!
Marie, Very lovely tool to learn. Very well explained and covered so many situations. May be I'll try to add how much the formula costs.
Glad it was helpful!
Super helpful, thanks a mill for this!
Thanks for watching!
Thank you Marie
Thanks for watching!
When we got to calculating the active surfactants spreadsheet does the space affect the calculation? For instance if we are calculating the percentage of distilled water needed and we do the =1-(sum(b2:b8)) how do we account for the empty rows? Does it matter? And I also notice that in the active surfactant part the distilled water is in the B2 coloum which I should think will affect the formula for the calculation of the percentage of distilled h20? This is an amazing video and I'm so excited to try it out! Thank you
No, it doesn't-empty spaces are just that-empty-and do not factor in at all. I don't understand the second part of your question? I'd recommend reading the blog post and giving it a try for yourself; I suspect you'll find it makes sense when you do it for yourself!
@@HumblebeeAndMe I did!! And you're completely right!
Brilliant! Thanks for sharing.
Thanks so much for watching!
Greta video. What if I'm making an "oil-free" moisturizer and my oil phase only consists of Emulsifying Wax NF and Cetyl alcohol? At what percentage should I be using the e-wax NF with no oils? My goal is a light/low viscous lotion. I've tried using as low as 2% e-wax NF and 1% Cetyl alcohol (or no Cetyl alcohol), but find the lotion is still thicker than I desire after a day or so.
I recommend checking out my Summer Solstice Body Milk to see how I formulated a low viscosity oil free moisturizer :) Happy making!
Very helpful. Thanks!🌻
Thanks for watching!
This is so helpful!! Thank you so much
I'm so glad! Happy making 😊
A bit off topic but I have looked over past posts and was wandering about if you have any recipes for diy toothpastes? Thanks, Dee Dee
I do have one (search "tooth powder" on the blog) but I can't say I'm a big fan anymore. I'm happy with my Sensodyne these days, and so is my dentist.
Thank you! Good to know!
Thanks Marie x
Thanks for watching!
Hi! I absolutely love this idea but I'm a bit confused, cell A1 is the batch size for example 50 containers, but the rest of the A column is in what unit? How will that help me to measure? I'm not sure if its 25 grams, 15 grams and 10 grams or is it another unit? (see video at 3:52)
50 is 50 of whatever unit you want-50 grams, 50 pounds, 50 barrels. Column A is in whatever unit you decide the 50 (or whatever number) is.
This help me a lot! Thanxs!!
I'm so glad! Thanks for DIYing with me, and happy making :)
Thanks so much for this video.
Thanks for watching!
Quick question: How do we know how much of a product to put into the batch? I am understanding your very detailed and easy to grasp breakdown of how to turn the weights into %s, and how to get the %s into weight by multiplying into the batch size.
But I am having trouble understanding how do you know the exact percentages (or weights) to put in into the spreadsheet?
Check out her most recent video that discusses her course she just designed that helps us formulate without using general recipes and instead custom tailoring our own. It sounds really cool.
Thank you for your explanation but I got lost along the way but I’m not tech savvy
You are awesome!!
Thank you so much!
Very helpful!
I'm so glad!
Thank you so much! I’ve been looking for something like this for some time now since I didn’t know how to do the formulas. Does this work for solid shampoo recipes too?
It works for literally any formula!
Hi Marie! I know this is an old video but I had a question about adding a way to convert the same formula from oz to grams is there a way to make it a drop down or something to convert easily? Say I get a formula that was made for grams but I want to make 80 oz instead? Is there a way to make it convert in a click or do I just need to convert the oz to grams and enter that instead? I hope that makes sense. Thank you.
% are %-the precise unit doesn't matter. Get the formulation into % and then go from there :)
@Humblebee & Me May you please elaborate a bit more on that, as I'm having a hard time trying to figure out what's you meaning of your comment. Thank you 😊
@@diagrier9963 What she is saying is, if you want to make 80 oz and your formula contains Olive Oil at 50%, then you will use 40 oz of olive oil. The issue may be taking a formula that only gives ounces or grams and changing it into percents. I guess we can all say we wished we had paid more attention in math class. 😁
Hello, I am trying to follow your guide in creating mine. I got confused, did you use the spreadsheet to calculate both the batch size and percentage. Please, help me!!! Thank you
Brilliant
Thanks for watching!
Are you using Excel or Numbers ( Windows or Apple) to make your blank spreadsheet?
Hi Marie... I have an awesome spreadsheet that was done by somebody else a long time ago, that I would love to share with other makers. Although I can no longer credit the original author since I've long since forgotten where it came from. But it is a bit more intricate, and was originally shared for use by others. I have the original version, as well as one I've been working on that has an ingredient list people can add to. Then in the ingredients list of the recipe, you just select the ingredients and add your percentages to them. It was intended for lip balms, but I'm pretty sure it might be useful for other items as well - or one can figure out how to make it so it does. It was also intended for selling, but I only make for myself - so the selling portions of it have remained either wholly or mostly untouched by my revisions (I'm not even sure if it still works, to be honest 🙂).
However, I don't know how to get this out to the maker community so others might benefit from it.
Nice of you to want to share. I’m not sure the best way to post it, but maybe you could make a Reddit post in the DIY formulators subreddits?
@@_Ag- Thanks for the suggestion. Sorry it took a while to make this answer. I ended up deciding to practically redo the entire original spreadsheet, so now it barely resembles the original whatsoever. In comparison, the original one seems so incredibly rudimentary now - though I thank the OP for giving me a direction to go in the first place, many years ago. But it took some more focused learning of LibreOffice Calc to try and get it to where it is now. What is currently in it, is what I wanted to do for quite a long while but wasn't sure how I wanted to do it. I'm still not sure, but it is what it is so far. However, I'm still working on identifying and fixing any new bugs that have been introduced by my recent major rework.
The current incarnation of the spreadsheet now allows for making up to 4 adjustments to an already made lip balm (or any product, I imagine). It has spaces to enter in the current weights after you empty the contents of the current container(s) into a tared measuring beaker - and then add new ingredients to it, all while accounting for the percentages and amounts of what was remaining when you decided to remelt the previous experiment (EDIT: AND the previous experiment, AND the previous experiment, AND the previous experiment). Yes, I really *REALLY* like this part! 😁 I just hope it's working correctly.
^^ *I believe such a feature as this might be desired by many, since I've certainly desperately craved for it for WAY MORE than a good long while myself. 😊*
The selling portions are entirely removed now. The only remaining cost info is the dynamically allocated cost of *ALL* the added ingredients themselves... I took out all the cost items related to the tubes and labels and whatnot.
I'll have to try and find that formulating subreddit forum soon, especially if they allow for uploading a spreadsheet file! I feel that this spreadsheet could greatly help out other new formulators (ESPECIALLY the multi-adjustment parts that I've been working on lately!!!), and I'd love to pay it forward.
@@enigmaticmf Ooh, sounds amazing! Sounds like your persistence and focus definitely paid off! 👏 I’d love to have something like that at my disposal. Very kind of you to want to pay it forward!
I decided to put it on a Google Drive. I'm just putting my version up, as it's far more advanced at this point. My brain has turned to mush trying to keep everything working throughout all my changes. There are now 9 Adjustment columns! 😁
Link: drive.google.com/drive/folders/1VdI2uQM-krLWtPqxw8QS1lXsd6z8fdT3?usp=sharing
I hope enough people might see this and try it out. Later I might try finding that forum.. Does Reddit tend to be the active forum for this sort of thing? Or are there other popular forums as well?
I just hope everything is working correctly. It seems to be.
@@_Ag- In case you only have mention notifications on... The spreadsheet is pretty much ready for prime time I think, after discovering a fairly hefty bug last night. :) If you can, let me know how intuitive it might be. I've been working on it for so long now, I'm afraid I would have lost touch with any ease-of-use issues that others might have with it. After all, I had never intended on releasing it - until I finally cracked into one way of doing adjustments. I could always add more instructions to the 'readme' file for any areas that might not be clear. Link is in the other post.
Hey Marie. I got everything up until the emulsifying wax. I'm lost. I've tired to understand fully what your saying but I have failed on my own. Can you please explain it to me in more details?
Have you read the blog post? :)
Could you try to recreate Mac's lipstick in shade Diva?
I will keep it in mind :)
Can you explain why it is important to work out the active surfactant ratio. Since the ingredient amount has already broken down. Just wondering if there’s needs to be an absolutely important reason why you’re teach teaching this part.
It's because surfactants can vary in strength a lot, so by calculating the ASM you are comparing apples to apples, as it were :)
I love your work and thank you for it. I have been trying to download the spreadsheet and have had no luck. I keep get add to chrome and extensions stuff. I'm not good with excel spreadsheets. Would you PLEASE provide more info for a beginner .
Hey Janet! I'm afraid I'm genuinely not sure what exactly you're having trouble with 🤔 Do you have a friend or family member with more Excel experience that you might be able to ask? It would be much easier to troubleshoot if the person could see/use your computer :) Best of luck!
I didn't give up. I am doing better. Thanks for responding. @@HumblebeeAndMe
I've added up my %'s for my formulation, and they add up to 100. I followed every instruction you have displayed, yet Spreadsheet is giving 199.00%. I've started over so many times and get the same results... I am just about to give up. Please help
It sounds like a "1" in the sheet isn't a %, so it's being read as 100%. Double check all the "1" values to ensure they are formatted as percentages. Good luck!
Hi, i'm having a bit of trouble. When i do the sum it doesn't decrease the weight in each row. Can you help with where i am going wrong?!
I can't help with so little information about what you are doing-have you read the blog post to see the formulations written out?
I have just found your spreadsheet video and thought you said you have a downloadable spreadsheet. I would love to get it if it is still available. Please let me know where to go to get it. Thanks.
I've never offered such a spreadsheet.
The formula in excel isn't working for me in batch size column, may be I'm putting wrong percentages. How to select that, kindly guide
I cannot provide tech support via UA-cam comments-I recommend starting over and reading the partner blog post as well. Good luck!
Pls help those who have never did spread sheet
I am really having a problem with your *1-(sum(B3:B9)) formula for quantity sufficient. I can’t place the formula in B2 without getting an error message.
It should be =1-(sum(B3:B9)), not *1-(sum(B3:B9)) :)
None of the pages on your website are currently working. I'm getting an apache internal server error on everything but the main page.
Same here! Wanted to check out the blog post but can't. :(
It is fixed now! That was quite the roller coaster of emotions there for a while 😄
Hello. Does batch size mean the number of ounces you're making?
Yes :) You're making an 8oz batch or a 100g (3.5oz) batch or... whatever size you're making!
Is there a way to do this using good okd math? Please this is all im stuck on is taking a recipe that is written in ounces and transferring it to % so i can scale it and switch it to grams. Someone please help!!
I've shared a tutorial on how to convert formulations written in grams/ounces into % here:
Video: ua-cam.com/video/rXWaTO_JIag/v-deo.html
Blog: www.humblebeeandme.com/how-to-scale-any-recipe/
You can obviously skip the step where you have to determine the weights since you have them already :)
After that it's a simple bit of addition and then division.
Happy math'ing!
I input your Lemon Chiffon Body and Hand lotion recipe that I frequently use and love. My question is, how do I know the percentages? Only the amount to use is listed and I have no idea what to put in the % column so that everything can be scaled up or down. Sometimes I need something to fit in my pretty 4 oz bottle in the bathroom, sometimes 12 oz in the kitchen and sometimes 8 oz in my dressing area. That percentages thing is something not addressed in the recipes. Can you help?
Check out the video I shared earlier this month on scaling + converting any formulation to % :)
@@HumblebeeAndMe Oh, my gosh! I am sorry I missed that one! For some reason I though this was the same video and passed it by. My apologies and thank you for not making me feel like the idiot I am ;)
What do I do if I’m following a recipe from online and they only have it in cup sizes?
You'll have to convert it into weights first; I've explained how to do that here:
How to convert any formulation to %: ua-cam.com/video/rXWaTO_JIag/v-deo.html
www.humblebeeandme.com/how-to-scale-any-recipe/
Happy mathing :)
What is the best way to add a title/name of the formulation in the spreadsheet?
Honestly, whatever works for you is the best way :)
This may seem like a really stupid question, but how do you figure out the precent of each ingredent? I know the precent is how much of your total recipe that ingredent is, but I'm just not sure how to know how much of a body butter recipe show be mango butter for example.
same
I'm not sure if you're asking about formulation development, or determining percentages in formulations provided in grams/ounces/etc.
If it's the second one, I've covered that here: www.humblebeeandme.com/how-to-scale-any-recipe/
If it's the first one-it's experimentation, taking notes, learning, and trying over and over again. Think of it a bit like cooking without a recipe-how do you know how much onion to use? How do you know which flavours will work together? Experience, experimentation, and time :) Happy making!
Humblebee & Me if it’s the first one....then do you start by using the suggested rates on the individual items ?
I got stuck on the 100% = sum and range
😻😻😻😻😻😻😻😻😻😻😻😻
Lost me with the pola wax. You were saying it is at 25% of something. It says 2% on the spreadsheet. What am I not getting? I think you are saying now that I watched it again the oil phase is 25% of the formula because there are 4 ingredients in the oil phase and that is 25% of 100?
Hi, does anyone know what the main difference is between candelilla wax and beeswax? Besides from it being vegan? Can I use beeswax instead?
Isabel Orozco main difference is the melting point.
@@chrisr9764 thank you Chris
Chris is right-melting point is a big part of it! I find beeswax makes products feel creamier/tackier while candelilla and carnauba waxes create much thinner, glossier feeling products. I've done some experiments with different waxes you can review here: www.humblebeeandme.com/faqs/can-use-_______-wax-instead-wax-called-recipe/ :)
@@HumblebeeAndMe thank you soooo much you are inspiring big time
I really enjoy your videos. Thanks for sharing! I tried to link to your site but it's sending me an error code. FYI.
I had a bit of temporary down time but it's all back now!
Good video, but I'm laughing....because I STILL use notebooks. And I don't mean a computer LOL I write absolutely everything down as that is how my brain works best when formulating. Formulations glow out of me like water when writing by hand. Calculating each ingredient isn't that hard. I also simply CANNOT tolerate having my laptop or a stinking tablet on my work surface.. Notebook & pen, along with my scale/s my ingredient vessels & my ingredients.
Old school is best for some people.
For invoicing people, yes, I use spreadsheets. But formulating is an art to me, and my play, which I want a computer, tablet or phone nowhere near.