I’ve made an excel sheet for mixing. It has room for 10 pheros you want to mix. It will tell you how much in mL you need to add, how much mcg/spray you are actually going to get, and how many sprays you will need to achieve the mcg/spray you want for the final solution.
Keep in mind that if you want a 10mcg/spray and have a 5mcg/spray solution, it will NOT work. You cannot increase the concentration from 5mcg/spray into 10mcg/spray for the FINAL solution. You NEED to have either the SAME concentration or HIGHER than the FINAL solution. I will explain what I mean.
2.5mcg/spray x2 is NOT equal to 5mcg/spray in terms of CONCENTRATION. The TOTAL pheromones APPLIED IS THE SAME but the CONCENTRATION is not. I will put it this way. You have a solution that is 100 gallons. 50 gallons is water, 50 is oil. To get 100 oil, you need 2 times the solution so you will have 200 gallons, 100 water, 100 oil. But the CONCETRATION is still 50% oil, 50% water. Same goes for the pheros. You cannot INCREASE the concentration of the phero UNLESS you have another source that is HIGHER in concentration or IF you have the pheros in PURE form. If you do not believe me and don’t want to heed this, go for it, but you WILL fuck up.
THAT being said, DO NOT change any of the formulas. ESPECIALLY the ones in ROW D. It has an IF statement that I put in that will prevent an error if you do not use all 10 rows. All you have to do is put in what you want to add, what YOU want the FINAL MCG/SPRAY to be, and what mcg/spray YOU HAVE ON HAND. Again, if you have a lower mcg/spray then what you want for the final concentration, it won’t work when you apply it. The spreadsheet will still give you a result, but it won’t be right. I assume this is what people are asking for. If not, oh well, I tried. I have no idea how to post my spreadsheet on here but if you PM me that you want it, with your email, I will send it to you.
EDIT
Here is a link to see a preview of what it looks like.
Google Docs - mixing
The #div/0 will disappear once you start entering the numbers.
/endEDIT