Formula for mixing two concentrations for specific target volume and concentration

[priestie]

I needed to mix two concentrations of e-liquid to a new and higher concentration. Or actually, I wanted to add strength to an existing e-liquid, and wanted to know the mixing ratio for a specific target volume. I couldn't find any existing calculator online, so I made this formula, and have made it into a spread sheet also.

The formula for calculating part of highest concentration(Ph) e-liquid to use is this:

Ph = (Ct-Cl)/(Ch-Cl)

Where:
Ct = target nicotine concentration
Cl = concentration of lowest strength
Ch = concentration of highest strength

Example:
You have a 3mg/ml e-liguid and a 18mg/ml e-liquid, and want to mix 10ml of 12mg/ml.
The ratio (Ph) would be: (12-3)/(18-3) = 0.6

So, for mixing 10ml, you should use 0.6*10 = 6ml of the 18mg/ml strength e-liquid, and the rest should be the 3mg/ml strength (4ml).

Here is a link to the spread sheet:
EDIT: REMOVED LINK TO SHEET
To make it useful, I had to make it editable for every one. That doesn't work nowadays I'm afraid.
You will have to use the formula "manually", or download the tool referenced by IDJoel.


Hope it helps some one in the same situation.

 

[IDJoel]

I wanted to add strength to an existing e-liquid, and wanted to know the mixing ratio for a specific target volume. I couldn't find any existing calculator online,

Nice job @priestie; thanks for sharing.

Just as an FYI, for you or anyone else looking for similar "adjustment" calculators, @HotRod19579 has a Windows e-liquid calculator called Juice Calculator that offers several secondary calculators he calls "simple calculators." Here's the list:

Note that the highlighted one performs the function you desired. This is the result using your example:

Anyone interested in this free calculator, for their Windows platform, can find it here on ECF at this thread: New Calculator to try
The first post has a link to the most current version, and the rest of this active thread provides a forum for discussion and help regarding the calculator.

 

[stols001]

Thanks for posting that PR, very informative.

Anna

 

[priestie]

Nice job @priestie; thanks for sharing.

Just as an FYI, for you or anyone else looking for similar "adjustment" calculators, @HotRod19579 has a Windows e-liquid calculator called Juice Calculator that offers several secondary calculators he calls "simple calculators." Here's the list:
View attachment 702911

Note that the highlighted one performs the function you desired. This is the result using your example:
View attachment 702913

Anyone interested in this free calculator, for their Windows platform, can find it here on ECF at this thread: New Calculator to try
The first post has a link to the most current version, and the rest of this active thread provides a forum for discussion and help regarding the calculator.

Nice
Didn't find that in my search for a usable calculator.
But now I got the added benefit from exercising my problem solving and algebra skills

 

[priestie]

Thanks for posting that PR, very informative.

Anna

Thanks Anna. Hope some one finds it useful, and nobody screws up the google sheet