justajesuschick Posted August 21, 2013 Share Posted August 21, 2013 (edited) A sweet poster here (I will let her self identify if she chooses-I do not want to name her if she does not wish) asked if I had anything like this and I did not. She detailed out the ratios for 1 pound on graph paper, shared with me, I entered her data into a spreadsheet and my Excel whiz husband entered the formulas and did the math out to 6 pounds. I keep my percentages simpler than this and typically do not make more than 1 pound of any fragrance at a time but she does and likely most everyone else does, too. Unfortunately, I cannot post the actual Excel doc here but I made it an image so that I could share.Still cannot get the image larger. Will work on it again later! Edited August 21, 2013 by justajesuschick Need to make image larger! Quote Link to comment Share on other sites More sharing options...
justajesuschick Posted August 21, 2013 Author Share Posted August 21, 2013 (edited) Edited August 21, 2013 by justajesuschick Quote Link to comment Share on other sites More sharing options...
QTsmum Posted August 22, 2013 Share Posted August 22, 2013 This is awesome, thank you!! Quote Link to comment Share on other sites More sharing options...
Carrylh Posted August 22, 2013 Share Posted August 22, 2013 Wow,that is awesome...You are very nice to have put this together and share...Thanks. Quote Link to comment Share on other sites More sharing options...
barbaranj Posted August 22, 2013 Share Posted August 22, 2013 Fabulous!! Thanks to you, the "sweet poster" and your excel wizard hubby! Quote Link to comment Share on other sites More sharing options...
craftsbychris Posted August 22, 2013 Share Posted August 22, 2013 Thank you!!!! Quote Link to comment Share on other sites More sharing options...
doglvr Posted August 22, 2013 Share Posted August 22, 2013 I can now throw away about a thousand sticky notes. Thank you so much! Quote Link to comment Share on other sites More sharing options...
Terry Posted August 23, 2013 Share Posted August 23, 2013 Thank you very much!! Quote Link to comment Share on other sites More sharing options...
SliverOfWax Posted August 23, 2013 Share Posted August 23, 2013 And if you're using grams, which for accuracy, you should be, 1 ounce = 28.350 grams.Example: 1.28 ounces = 36.287 grams. Quote Link to comment Share on other sites More sharing options...
cynthia3030 Posted August 23, 2013 Share Posted August 23, 2013 Thanks. Great job. I printed three copies. Quote Link to comment Share on other sites More sharing options...
deisel Posted August 25, 2013 Share Posted August 25, 2013 Thanks_wonjderful help!!kris Quote Link to comment Share on other sites More sharing options...
rjdaines Posted August 25, 2013 Share Posted August 25, 2013 And if you're using grams, which for accuracy, you should be, 1 ounce = 28.350 grams.Example: 1.28 ounces = 36.287 grams.I find that working in grams is so much easier than ounces. Quote Link to comment Share on other sites More sharing options...
justajesuschick Posted August 25, 2013 Author Share Posted August 25, 2013 I have the spreadsheet with all of the formulas and tabs for data in each of the fields. Will be happy to email it (cannot post Excel doc here) to anyone who wishes to convert this to grams for the good of others who work in grams. Quote Link to comment Share on other sites More sharing options...
bsones Posted August 26, 2013 Share Posted August 26, 2013 So here's a random question that has probably been asked before: When figuring fragrance oil percentages (and dealing with maximum recommended percentages), do you aim for a percentage of the total weight of wax + FO, or for a percentage of the weight of the wax alone? For example, in the chart upthread, it suggests that 10% FO for a pound of wax is 1.6 ounces. But if you were to add 1.6 ounces of FO to 16 ounces of wax, the FO would only make up about 9% of the total weight (which is actually 17.6 ounces once the FO is added). If you wanted 1.6 ounces of FO to be 10% of the total weight, you'd need to add it to 14.4 ounces of wax. So which is the "officially right" way to do it? If you have a wax that maxes out at 10%, which of the above methods (add 1.6 oz. of FO to 14.4 oz. of wax, or add 1.6 oz. of FO to 16 oz. of wax) would you use? Quote Link to comment Share on other sites More sharing options...
Michdj Posted August 27, 2013 Share Posted August 27, 2013 So here's a random question that has probably been asked before: When figuring fragrance oil percentages (and dealing with maximum recommended percentages), do you aim for a percentage of the total weight of wax + FO, or for a percentage of the weight of the wax alone? For example, in the chart upthread, it suggests that 10% FO for a pound of wax is 1.6 ounces. But if you were to add 1.6 ounces of FO to 16 ounces of wax, the FO would only make up about 9% of the total weight (which is actually 17.6 ounces once the FO is added). If you wanted 1.6 ounces of FO to be 10% of the total weight, you'd need to add it to 14.4 ounces of wax. So which is the "officially right" way to do it? If you have a wax that maxes out at 10%, which of the above methods (add 1.6 oz. of FO to 14.4 oz. of wax, or add 1.6 oz. of FO to 16 oz. of wax) would you use?There is some debate to the "correct" method. Personally I use the percentage of total weight once the whole batch is together, which is your second example. I believe you'll find different people do different things, but in my research from this forum I found the percentage of total weight was what manufacturers were suggesting. But that's JMHO, not gospel. Testing is the best answer! Quote Link to comment Share on other sites More sharing options...
e911 Posted September 1, 2013 Share Posted September 1, 2013 super handy! Thanks! I usually only make about a pound per scent, but it's nice to see what's needed to do more! Quote Link to comment Share on other sites More sharing options...
MissKasey Posted September 5, 2013 Share Posted September 5, 2013 Thanks so much! Saved a copy to my iPad for super quick reference! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.