Mixing spreadsheet

[zeph]

I’ve decided to make a spreadsheet in excel that will help those who want to mix, but are not sure how much to add. This is from the topic: When Mixing Your Pheromones - #45 by zeph

If there’s a way I can upload it or something to the site or some way where I don’t have to check PMs and Email everyone on the list, that would be great.

My post from the link above. Read it before you ask me for the sheet cause if you ask me something I already went over here, I’ll just send you back here. If you don’t understand what I mean by concentration vs actual product, I am not sure how to explain it any further. I am not good at explaining this stuff so if someone who understands it can break it down easier, go for it.

I’m fairly certain the math is right. I used data according to the site meaning 200 sprays in a bottle, about 0.15ml per spray. Yes, it is complicated, its very similar to molar concentrations in chemistry.

EDIT
Here’s a link. This is what the set up looks like and it’s a sample mix. Just enter what you want your final mcg/spray to be, what you have on hand and it will tell you what to add and more than likely you will have to spray multiple times. The last row is the amount of sprays you need to get the mcg/spray you wanted for each of the components in Row B.
Google Docs - mixing
/end EDIT

@zeph

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.

[zeph]

oh and if this isn’t what you wanted let me know. If you want it by sprays by togo or full size or both, I can make one too. Let me know how you are “mixing” or “layering” things, what equipment you are using, etc, so I kinda know what people are looking for. This doesn’t really take me too long to do so I tend to do it when I’m procrastinating. xD

[Rattlesnake]

Good work I’ve constructed my own but it still relies on me doing half the calculations in my head.

Rep points to ya

[zeph]

Anyone have any feedback? Thanks to Rattle and Bond for the input. Anything from the more experienced? Gegogi, SteveO, Tate, visionary? I get bored easy and do random stuff like this so if anyone has any creative criticism it would be much appreciated.

The “random data” is just data that is part of a computation I did. The number below that column is also “random data” as is the number to the right of it. the 140 and the 0.069…

[galydrum]

Wow, cool. Reps to ya man.

[nbully79]

Hey zeph, good job on the spreadsheet! Rep points coming your way!