Ejuice calculator (added quantity calculations)

[AlexTM]

As tempting as pure nicotine is in terms of price and storage, I'd never touch that stuff. Far, far too dangerous.

It would seem a good idea to me, for those who did get hold of it (and don't try, please), to immediately dilute the stuff down to a managable level, 1:10 at least (giving you 100mg/ml), but even better, to something like 36mg, or if you actually mix liquids with higher nic in them, 72mg/ml juice. Easier to calculate than 100mg.

Because if you do that, you don't have to worry about things like getting a drop on your skin, which is all it takes to make you quite sick if it's pure nic. And when you do handle that stuff in pure form, do remember to wear protective gear. Nicotine is absorbed through the skin easily.

 

[DonleyDoRight]

Greetings Scubabatdan,
Since no-one I know, knows as much about excel as you do.
Is there a way or better put, would you please, add a way, to input different flavor suppliers ie: Perfumers Apprentice, Seedmans, ect to the "Flavor Lists For Drop-Downs" page as well as the ability to add the flavors to the bottom of the list of flavors that these suppliers carry?

Without a doubt, your calculator is the daily go to tool that I and most all of us use to make and create our juices. But every time I try to modify and add these suppliers I mess up the book and thus can'
t save it as it has become corrupt.

I hate to ask as you have done so much already, but you are the logicail choice to be sure.

Thank you ever so much for your fine work.
Donley

 

[fllinton]

Thank you the e-juice calculator is Great!!!!!!!

 

[Interstink]

Ive been working on the Math for the dual nic (x2) calculator for the iPhone app. Basically trying to remove the requirement for volume entries allowing the calc to spit out those values based on final value requested. When im done, Ill post the Math here for your spreadsheet.

 

[magus7091]

Excellent calculator, but I have one request. Don't know if this has been asked or not, but one thing I would like to see added is a special place for increasing/decreasing nic in a juice. For example I have 30 ml of 11 mg, and I want to drop it down to 9 mg, how much PG/VG would I need to add to acheive this. Any plans to add this function?

 

[Interstink]

Excellent calculator, but I have one request. Don't know if this has been asked or not, but one thing I would like to see added is a special place for increasing/decreasing nic in a juice. For example I have 30 ml of 11 mg, and I want to drop it down to 9 mg, how much PG/VG would I need to add to acheive this. Any plans to add this function?

That can be done currently. You can certainly leave all the other fields (Flavor etc.) blank.

 

[magus7091]

Sorry, wasn't too clear, bad example. I know that dropping can be done currently, but what if I wanted to raise the content. Taking the same 11mg juice and wanting to raise it to say 18 using 100mg/ml unflavored.

 

[Interstink]

Sorry, wasn't too clear, bad example. I know that dropping can be done currently, but what if I wanted to raise the content. Taking the same 11mg juice and wanting to raise it to say 18 using 100mg/ml unflavored.

So you are still lowering 100mg down to 18mg. but thats why I created the x2 calculator in the app. Using a dual nic calculator (x2 calc in iphone app) will do this. If its not in the spreadsheet, it should be added for sure.

You can take your 100mg source(1) and enter your 11mg source(2) and adjust the ml volumes to get your final value.

1ml of 100mg nic + 11ml of 11mg nic = 12ml of 18mg nicotine eJuice. (Aprox Values)

 

[Scubabatdan]

Sorry, wasn't too clear, bad example. I know that dropping can be done currently, but what if I wanted to raise the content. Taking the same 11mg juice and wanting to raise it to say 18 using 100mg/ml unflavored.

Simple use section 4, you can add up to 4 different nic quantites and mg strengths together, then adjust the quantity of the nic you are adding until you arrive at your optimum.

Dan

i.e.

 

[Scubabatdan]

Ive been working on the Math for the dual nic (x2) calculator for the iPhone app. Basically trying to remove the requirement for volume entries allowing the calc to spit out those values based on final value requested. When im done, Ill post the Math here for your spreadsheet.

So basically if I want 25mg juice and no quantity entered for final, and enter mg% of both liquid it tells you how much of each you need to add together and gives you the mg% and total quantity. Or are you specifiying the mg% and quantity for total and just providing mg% to be combined and then it tells you the quantites required?

Sounds like a linear equation i.e.

You want 20ml of 25mg juice and have 100mg and 18mg liquids, solve for x(quantity of 100mg) and y(quantity of 18mg)
((100 * x) + (18 * y)) / (x + y) = 25 * 20

So....
x=1.7074ml
y=18.2926ml
Roughly

Something like this?
Dan

 

[Interstink]

So basically if I want 25mg juice and no quantity entered for final, and enter mg% of both liquid it tells you how much of each you need to add together and gives you the mg% and total quantity. Or are you specifiying the mg% and quantity for total and just providing mg% to be combined and then it tells you the quantites required?

Sounds like a linear equation i.e.

You want 20ml of 25mg juice and have 100mg and 18mg liquids, solve for x(quantity of 100mg) and y(quantity of 18mg)
((100 * x) + (18 * y)) / (x + y) = 25 * 20

So....
x=1.7074ml
y=18.2926ml
Roughly

Something like this?
Dan

Thats what I have so far, but im using float value conversion.

Im specifying MG of the two sources, and the MG & ML of the final result I want achieved. (rounded)

 

[magus7091]

Simple use section 4, you can add up to 4 different nic quantites and mg strengths together, then adjust the quantity of the nic you are adding until you arrive at your optimum.

Dan

Yea I've played around with that, but for a nic + no nic solution, you input your first liquid strength, your desired strength and desired qty, and it provides the rest. What I would like to do is that. The only spot for it on the existing sheet makes you have to guess at qtys to reach your desired strength. X-ml of Y-mg liquid plus A-ml of B-mg liquid= what strength. What I need is to input the desired amount and strength, plus the base strength of my liquids and have it tell me how many mls/drops/what-have-you of each...
Does this make sense?

 

[Scubabatdan]

Yea I've played around with that, but for a nic + no nic solution, you input your first liquid strength, your desired strength and desired qty, and it provides the rest. What I would like to do is that. The only spot for it on the existing sheet makes you have to guess at qtys to reach your desired strength. X-ml of Y-mg liquid plus A-ml of B-mg liquid= what strength. What I need is to input the desired amount and strength, plus the base strength of my liquids and have it tell me how many mls/drops/what-have-you of each...
Does this make sense?

Yes I understand, the problem is in excel the fomula I posted is solved using the addin called solver, it is used for solving complex x y floating variables. I am working on a macro that once you enter your #'s you click the solve button and it runs the algorithims based on your input. Not an easy task in excel. I am working on it. Of course each person that runs it this way will have to add the addin solver to their excel. I am looking for a way around that through hard coding (the long way).
Dan

 

[magus7091]

I see, that kinda makes sense. I don't know excel all that well, and it's a bit complicated for me to try to learn... Have tried, and just don't grasp it. Is there any way you could tell me the formula to use to mix 11mg juice with 100mg juice for a target of 24mg?
I don't have an ipod or iphone to use the app that was spoke of... Or does anyone know an online calc with this capability?

 

[Scubabatdan]

I see, that kinda makes sense. I don't know excel all that well, and it's a bit complicated for me to try to learn... Have tried, and just don't grasp it. Is there any way you could tell me the formula to use to mix 11mg juice with 100mg juice for a target of 24mg?
I don't have an ipod or iphone to use the app that was spoke of... Or does anyone know an online calc with this capability?

Is this what you are looking for?
See attached...
The white areas are entered fields, the blue areas are info and the results.
Just enter you target amount to be made i.e. 24mg of 100ml
Then enter the mg% of the first nic liquid i.e. 100, then enter the mg% of the second nic liquid, can be 0, but I put your number in i.e. 11.
It will then tell you the amount of each liquid to add together to make the desire ejuice amount.
That it?
LOL and no macros involved, just good old math!
BTW the second screen shot is what happens when you are out of limits, the fields will turn red.
Dan

 

[magus7091]

Simple, but effective... Exactly what I was hoping for. Thanks.

 

[Scubabatdan]

Simple, but effective... Exactly what I was hoping for. Thanks.

Glad that is what you were looking for.
I will be adding this to the excel ejuice calculator in version 11, but for those who want it now can download the quickie version of this procedure above.
Dan

 

[Scubabatdan]

Thats what I have so far, but im using float value conversion.

Im specifying MG of the two sources, and the MG & ML of the final result I want achieved. (rounded)

That is one way, but if you use Cramer's rules, it allows you to find the equation solution using determinants of matrices that are comprised from the equation coefficients, which is much easier.
Dan

 

[Hoosier]

Dan,

Huge thank you for the v10 ejuice calculator!!!

I have just one request, I would really like if I could more easily add flavors. I have some new ones from Capella and my homemade menthol, plus some of Perfumer's Apprentice stuff. I am going to un-protect the file today to add what I need, but I know that my Excel skills are lacking compared to yours.

I thought v3 was really useful. v10 is just amazing!

 

[Scubabatdan]

Dan,

Huge thank you for the v10 ejuice calculator!!!

I have just one request, I would really like if I could more easily add flavors. I have some new ones from Capella and my homemade menthol, plus some of Perfumer's Apprentice stuff. I am going to un-protect the file today to add what I need, but I know that my Excel skills are lacking compared to yours.

I thought v3 was really useful. v10 is just amazing!

Hey, no probelm, your welcome.
The easiest way is to unprotect the sheet and right mouse click on the row and select insert. Then just add the new flavor you want.
Dan