Hello My name Asad Sultan and I am fragrance Reviwer Your video is good and Help full Grate work keep it up your video help me a lot I love perfumes and I love to read perfumery
This is perfect, my problem is actually dillution since i have no idea how strong every fragrance concentrate could affect other materials badly. Now when accessing to the formulation, i think i hit the jackpot. Imagine i have been watching videos, asking dillution formula still i can not have the full infos of how much should i use, the recommendation per se of those especially common raw materials that are mostly used in perfume making. Hands off sir!!!! ❤❤❤
Hello, I did stick it through. So glad I did. We all appreciate the time you spent on this, there is so much useful information on this spreadsheet. It gives us hope to design our own fragrance. Can’t thank you enough.
Going from a buyer to a maker and just started expanding on the Excel sheet. While watching some of your formula videos, ran across this. YES, YES, YES!!! Awesome, thank you so much. Saved me a night of work to sort this out and I like your layout.
Even a lot of people already say to you, I'm not going to be original: THANKS A LOT for sharing, a very useful tool for perfumer apprentice like me. Also, thanks for your videos, I'm understanding a lot of things that I was not sure about. Great channel!
BK, this probably the most useful calculator ive seen and used. I stuck out the 30 mins...and the time and energy you put I to this is absolutely incredible! Thank you for being so selfless and giving new perfumers great tools to work with. It is very very much appreciated
This is the best discovery in the perfume journey. This is awesome for me as beginner. Cant thank you enough. May god bless you more and more. Thanks for the hardwork🥰🥰🥰
Thank you for putting this video out there!! Also, THANK YOU for realizing (for long videos) that background music is more distracting than it is pleasant. It is incredibly difficult to listen to the same song/jam for over 40min straight. Wish there was a way to filter background music on youtube. Great are the creators who catch on to that when trying to educate others. I stopped watching several YT uploaders because it's just unbearable to me beyond 5min. Anyone else identify with this, or, is it just me?
I was eagerly searching for this data and it seems that God has answered my plea through you bro. Thankyou so much for gifting us the wonderful spreadsheet. No one does anything so generously as you did for us novices out here. Thankyou very much again and again. May God bless you 👍🏻✌🏼
Finally downloaded and tried using the other day, and gave up after not seeing Siberian for. My attention always wandered off at the end of the video and didn’t see the add new materials feature! Lol. I’ll add in all my materials and give it another shot.
Thank you for sharing your perfume fragrance formula worksheet with us. This is an excellent tool and it will save me a lot of time calculating the safe amounts of essential oils and natural ingredients I want to use to create my perfumes.
This is a wonderful tool you've created. I can't thank you enough. I'm horrible at spreadsheets for the most part. I have a dilemma though. How do I incorporate a pre made accord into the formula so that the individual component calculations are then auto tallied into the working formula?
I'm not sure how to either...but my take, when I use my accords or add them to the data base I don't worry about it. Reason being is that 99% of my accords are also diluted with dpg, PA,ipm, or bb, so the amount t from the "drops" added are in such a small trace individually that it wouldn't register in the final product.
WOW! Thank you. I have only one I guess, major concern; what if you don't happen to have or utilize all or any of the materials in this database? In other words if you only use organic essential oils, and don't necessarily want to delete the materials pre-listed, how do make them 'unavailable', hide or grey them out so that only the materials _you_ use show up. In that case as well rather than a chemical name you might need to use the brand or manufacturer name to distinguish one version or type of the same material from another. Thanks.
Thank you so much for sharing this, it's exactly what I've been looking for! Just a question though, what's the best way to add a pre-blended accord to the 'My Materials' section, so that the % of a material included in that accord, is calculated with any materials from that accord that are also used separately in the final formula? Im thinking this could be important for IFFRA restricted materials! Thanks!
I thanks and appreciate you very much This is a wonderful spreadsheet you hit the nail on the head perfectly. The information just right for beginners and professionals. I have a question to you I hope you answer it in details. What criteria you use to make your dilution? For example Materials X suppose you dilute for 10% but material B you diluted to 1% how you decide that?
The only way to know how to dilute something appropriately is just by playing with it for a bit. I usually use Linalool as a baseline for a "normal" odor strength, and then ill just start diluting the other said material so a single drop of it is equal to a single drop of linalool in terms of odor strength. Plus, the good scents company also has write ups on each material available and they list starting points for evaluation dilutions
This is extremely generous, thank you very much! One question: perfumer's alcoholes range from 92 to 98%, what does the excel assume? Also what about adding tiny amounts of distilled water to perfumes, seems you are not doing it, as it isn't provided for in the excel. Any comments? Merci beaucoup!
WOW!!!! Thank you sooo much for sharing. Truly inspiring. Excited to get my materials and start creating. Awesome, Awesome organisation and presentation 👏🏾👏🏾👏🏾🙏🏾✨💙
Thank you for the formula worksheet great resource. I started using it today but when I copied it to google sheets on my iPad none of the auto function work. I put in the drop and the name of the oils and none of the percentages works or the dilution work. Don’t know what I did wrong. Please help me with suggestions
Hey I've been using this spreadsheet and its fantastic. Is there a way to adjust the final weight and have the formula scale accordingly. Or a way to scale all the material amounts such that the concentration is changed without needing to manually recalculate everything?
I know this question might sound silly but lets say Im looking at the spreadsheet and the formula is finished. I got each base note already diluted and the diluton column is filled out to match it. My final perfume is at 20 percent based on the spreadsheet. Does this mean I put weigh all my ingredients using the AMOUNT column?? Sorry just a little confused at this final step.
Man I really appreciate this ! Very informal and thought out. I have one question... how do I calculate my finished formula in this sheet, to get how much I need to fill up a 5ml , 10ml, etc...bottle of finished product? Thank you !
How much final product including dillutants did this example make? Are the values under the 1000 column converting a smaller batch of say 10ml from the drops total column to a larger batch size of drops in the 1000 column values? For instance test of 10ml for musk was 5 drops. Conversion has been done to 180 drops?
This is such a great tool you've developed! Thank you so much for sharing this tool. I have a few questions though, in the "percentages" columns you have the % of the raw ingredients in finished perfume, in concentrate, and lastly in a total of perfume. To my understanding, you mean the 3rd column basically shows the total % of that specific added ingredient in the total finished product (raw material + dilutant). Which is why it doesn't mathematically co-relate with the first column in the "percentages" section? I'm editing this sheet for my development needs so I can use it for my production of INCIs for finished products. I understand this sheet doesn't take into consideration what dilutants/solvents used, but that the first column in the "percentages" section shows % of concentrate, and taking that minus finished product (100%) would give you % of all types of other ingredients (solvents/dilutants) used? Have I understood the built-up of your sheet correctly then? :) Also, do you have any tips for calculating the finished product's % of ethanol in volume? Considerating the density relation w/v. Thanks again! You make a great channel with much helpful information.
Column K is the % of just the raw material alone in the total finished perfume, after any “additional” final post-dilutants from cell H140 have been added. Column J is the % of just the raw material alone, in the relationship of just all the total concentrate raw materials combined (minus any pre or post dilutants). Column L is the % of material including any pre dilutants from column D, in the total finished perfume (after any post dilutants)
Hi! This may be a silly question but I’m mainly used to using natural perfume materials and I notice that according to this worksheet (which you have very kindly shared!) you don’t seem to separate the top middle and base notes by percentages. For instance if I wanted to design my perfume based on 25 percent top 35 mid 40 base. Do you not think it’s valuable to use the fragrance pyramid percentages as a consideration when making perfume? Many Thanks! ☺️
Nope. The fragrance pyramid rules are a myth. You shouldn't pigeon hole yourself into such rules and force yourself to those kinds of things. The materials you use (in conjunction with other materials) will dictate how much falls into which pyramid structure. Plus....certain fragrance themes have different structures where some rely more on base heavy notes (winter fall frags) versus some rely more on top heavy notes (summer frags). There is no reason to force yourself into thinking you need to follow a percentage rule for each part of the pyramid. It will limit your true abilities and potential if anything
I am TRYING to use this on my phone (and I have installed the sheets app) and I do not see ANY of the File, Edit, View, Insert, Format, Data, Tools, Add-ons, Help - going across the top???
I”m sure your materials ( organ ) has grown somewhat since you posted this , but was wondering do you have mandarin aldehyde yet .. be cool if we could keep up to date with your buys 😁
@@bkscents7050 its a really interesting one , i “ve got it at a 1% dilution and its so powerful., Citrus-mandarin, spicy-coriander, fatty, metallic. , it really ramps up the citrus has a lot of scope , i highly recommend it
Hi BK Thank you so much for the Spreadsheet best I’ve seen. Question. Guaiacwood Paraguay and that intro Fishy Bacony Intro smell.... please what are your thoughts on the Odor Profile please and how would you use it..
Glad you like the spreadsheet 😀 For guiacwood, I don’t get anything fishy from it, but I do get a gummy, resin, dirtyness from it which I can understand you thinking “bacon”. I don’t use this wood that often on its own, but I like to combine it with other cleaner woods like cedar to kinda warm them up. To do this you would have to predilute the Guiac down a bit so it can be easily dosed low. Keep it lower in your perfume formula like maybe 10 parts per thousand, and work your way up from there.
hi actually this is A GREAT JOB and all respect for your helpful effort , but am wondering and ask you if you could update the excel sheet to have the molecule weight of each material and based on it it will be automatically sorted as (TOP ,Middle or BASE NOTE ) that everything again thanks for effort