I posted this in another thread but thought it might be helpful to post a dedicated thread. I've seen this question fairly often and a dedicated thread will help more people find it (I think).
In many threads here, I've seen people say that they have 2 different e-juices of different strengths, but the strength they really want is somewhere in between. That is, if you have 36mg juice and 12mg juice, but want to make a bottle of 22mg. Figuring that out in your head can be a little complex.
So I wrote an Excel macro that will get the answer.
Mix 2 Strengths Excel Macro
You enter 4 items:
- Strength of the first Nicotine Juice
- Strength of the second Nicotine Juice
- The desired strength
- Amount you wish to make
Then click the Calculate button.
A box will pop up telling you how much to mix of each juice. It will also tell you how much this will make, and what the actual strength is. It comes very close to the correct answers, but it's rarely perfect. That is, you may say you want 5ml of 22mg, but this macro may calculate 4.9ml of 21.7mg. I don't think you'll notice a difference.
Also note that the solution to this problem of mixing 2 strengths has an infinite number of solutions. This just finds one recipe. It's not the *only* possible recipe.
This spreadsheet and macro require Microsoft Excel, and will not work in OpenOffice Calc. But if enough people ask, I can probably make it work for OpenOffice Calc.
NOTE:
If you're doing DIY from scratch - using 2 unflavored nic-juices - then you're better off using Scubabatdan's EJuice Calculator. This little macro is better suited for those people who want to mix 2 pre-made juices.
In many threads here, I've seen people say that they have 2 different e-juices of different strengths, but the strength they really want is somewhere in between. That is, if you have 36mg juice and 12mg juice, but want to make a bottle of 22mg. Figuring that out in your head can be a little complex.
So I wrote an Excel macro that will get the answer.
Mix 2 Strengths Excel Macro
You enter 4 items:
- Strength of the first Nicotine Juice
- Strength of the second Nicotine Juice
- The desired strength
- Amount you wish to make
Then click the Calculate button.
A box will pop up telling you how much to mix of each juice. It will also tell you how much this will make, and what the actual strength is. It comes very close to the correct answers, but it's rarely perfect. That is, you may say you want 5ml of 22mg, but this macro may calculate 4.9ml of 21.7mg. I don't think you'll notice a difference.
Also note that the solution to this problem of mixing 2 strengths has an infinite number of solutions. This just finds one recipe. It's not the *only* possible recipe.
This spreadsheet and macro require Microsoft Excel, and will not work in OpenOffice Calc. But if enough people ask, I can probably make it work for OpenOffice Calc.
NOTE:
If you're doing DIY from scratch - using 2 unflavored nic-juices - then you're better off using Scubabatdan's EJuice Calculator. This little macro is better suited for those people who want to mix 2 pre-made juices.
