Ejuice calculator (added quantity calculations)

[Scubabatdan]

Hey Dan
how do you figure out how to go up in nic levels.
for example
I have 60 mg of unflavored nic
i have liquid 12mg and want it to about 30 mg how much 60mg drops would i add.
also
I have liquid 24mg and want to make it about 30 mg how much 60 mg drops would i add?.

Is there a calculator for this how much to add going up nic levels.
Thanks and Happy New year

Cos

Hi Cos,
Section 4 of the calculator can do that, it calculates adding dissimilar quantities and mg strengths. Just keep plugging number in until you get the appropriate mg strength. I always start with 10ml of the highest strength, and adjust the ml needed of the lower strength until I arrive at the appropriate mg strength.

For 60mg + 12mg to = 30mg it would be 1:1.66 ratio or 10ml 60mg + 16.6ml 12 mg = 26.6ml 30mg

For 60mg + 24mg to = 30mg it would be 1:5 ratio or 10ml 60mg + 50ml 24 mg = 60ml 30mg

To figure drops just times the ratios by the number of drops you want to make i.e. if you use 10 drops as a base, (10 * 1 = 10) + (10 * 1.66 = 16.6) = 26.6 drops of 30mg
Hope this helps
Dan

 

[Debbie]

Thanks much! I didn't think it would work on my Apple but it does!

Debbie

 

[cos]

Dan wow thanks for answering my post on New Years Day. ande thanks for the explanation. so which calc should i download for this
is this the one? Download my Excel v9 ejuice calculator
Thanks again Dan happy New Year

 

[Scubabatdan]

Dan wow thanks for answering my post on New Years Day. ande thanks for the explanation. so which calc should i download for this
is this the one? Download my Excel v9 ejuice calculator
Thanks again Dan happy New Year

Yes the one in my sig is always the newest version. Download it.
And Happy New Year!
Dan

 

[gointomexico]

THank you very much. That sheet is incredible.

 

[mwa102464]

Trying to download the 9 version and the link isnt working how else or where can I go to download Dan

 

[Scubabatdan]

Trying to download the 9 version and the link isnt working how else or where can I go to download Dan

I have attached it to this message, see below.
Dan

 

[mwa102464]

Hey Dan,

Thanks this really comes in handy for me since I mix all my own formulas from scratch, also just got some of that Nic from Levy, It is very good as far as im concerned what are your thoughts on his product, I would like to know what you think about his Nic

 

[Scubabatdan]

Hey Dan,

Thanks this really comes in handy for me since I mix all my own formulas from scratch, also just got some of that Nic from Levy, It is very good as far as im concerned what are your thoughts on his product, I would like to know what you think about his Nic

I Have ordered 730ml from him and it is quite GOOD!
Will be ordering soon when my 1 1/2 gallons are gone.... So, soon
Dan

 

[nicotime]

Hey Dan, I love your calculator but I am working on one that calculates what I am adding as I do it...if that makes any sense. I want it to work out the formula as I am adding stuff...like say I put 10mls at 60mg of this and 5mls at 11mg of that and then it shows me the amounts and percentages automatically. The only user input is column A,B and C, the rest calculates as you go. It works OK so far except the nicotine total percentage doesn't come out right. I am not real good with Excel...used to use Quattro Pro, so I don't know all the formulas. Can you look at this screen shot and tell me the correct formula for F19? The numbers are there but should be 14.3%. I appreciate any help you or anyone else could give me.

http://i534.photobucket.com/albums/ee345/larryis3/ECIG/ejuicecalc.jpg

 

[Scubabatdan]

Hey Dan, I love your calculator but I am working on one that calculates what I am adding as I do it...if that makes any sense. I want it to work out the formula as I am adding stuff...like say I put 10mls at 60mg of this and 5mls at 11mg of that and then it shows me the amounts and percentages automatically. The only user input is column A,B and C, the rest calculates as you go. It works OK so far except the nicotine total percentage doesn't come out right. I am not real good with Excel...used to use Quattro Pro, so I don't know all the formulas. Can you look at this screen shot and tell me the correct formula for F19? The numbers are there but should be 14.3%. I appreciate any help you or anyone else could give me.

http://i534.photobucket.com/albums/ee345/larryis3/ECIG/ejuicecalc.jpg

Hi,
We tried to make it as simple as possible. I can see the value in doing it the way you suggest. But to answer your question:

It should be =(((B3*C3)+(B4*C4)+(B5*C5)+(B6*C6)+(B7*C7)+(B8*C8)+(B9*C9)+(B10*C10)+(B11*C11)+(B12*C12))/SUM(B3:B12))

You must multipy the ml*mg for each liquid then divide by the sum of the total ml's of liquid to get the total mg. In this case it would be 23.05126mg or (763/33.1)

Keepworking those numbers!
Does this clarify things, see attached file?
Dan

 

[nicotime]

Excellent Dan, thanks. The only thing is I had to add /100 at the end of the formula to get 23.05% instead of 2305.%. I see I was forgetting to take in to account the quantity of each fluid for the calculation also, but it works great now. I also run the formulas down to row 20 for really crazy concoctions if necessary...even though at that point I would probably be throwing up or have created a biohazard. You could probably do one much nicer for those mad scientist like me that just start throwing stuff together then wonder what the hell I got when it starts melting the glass...lol.

 

[nicotime]

Actually I will just list all of my available ingredients and just plug in the numbers per recipe...kind of like a check list.

 

[JoeMcPlumber]

I AM PLEASED!

I just made my first recipe to fit into an 8ml bottle w/ low nic for evening usage, and it came out perfectly and fit precisely into the bottle!

Thanks, Dan!

- joe

EDIT: Oh but i wanted to tell you, i got a bit confused because there's a cell where i can put in VG or PG and a cell where i can put in VG and since i only have VG it took my brain a while to figure out i need to add those two cells and put that much VG.

Not complaining, just saying it's easy to confuse a n00b.

 

[JoeMcPlumber]

I usually run 20% PGA/Water to any amout of VG I add to the mix, I seem to have success with that.

That's sorta what i was getting at, and how i got confused.
Because all i had was VG and i was adding VG to it,
and i was already cutting it with 12% PGA and didn't want to put any more than that.

So, would it confuse things, or/and would it even be possible,
to have one of the cells be a "toggle" sort of thing
in the event you only have VG and you want 20% of it to be water,
expressed in drops?

Knowhatimean?

- joe

 

[boochips]

Merry Christmas and a hearty thank you too Scubabatdan.

Wish I had you expertise or the time to learn VBA.
But as long as you keep updating your calculator I guess I don't need to.
It has become my go-to for all my mixes. I don't even use my notebook anymore. Wish it could print out a 3x5 recipe to take into the kitchen. Hummm

Next time you are driving down to PCB let me know. I live on 231 just south of Cottondale, FL. We can do lunch and trade some home-brew.

Take care my good man,
Donley

Nice to know there are other vapers nearby! And a DIYer like I am too....
I live near Altha Donley.

 

[Janetda]

Thanks Dan, this is EXCELlent!

 

[Scubabatdan]

That's sorta what i was getting at, and how i got confused.
Because all i had was VG and i was adding VG to it,
and i was already cutting it with 12% PGA and didn't want to put any more than that.

So, would it confuse things, or/and would it even be possible,
to have one of the cells be a "toggle" sort of thing
in the event you only have VG and you want 20% of it to be water,
expressed in drops?

Knowhatimean?

- joe

Sorry I missed your Question,
If you are using ALL VG then you do not need to put anything in the VG cell. Just use flavor and the water/vodka/PGA cells, since the water should be based on the total amount to be made.

To actually base the water on only the VG and not the flavoring added, then we would need to change the Water/Vodka/PGA cell in section two to the following formula:
=((F8-((F8*F11)/100))*F9)/100
This might be an advantageous change as it does not factor in the flavoring.
Hmmmmm Let me think on this one.
Dan

 

[Scubabatdan]

Ok, I have updated the ejuice calculator based on JoeMcPlumers insight, I agree that Water/Vodka/PGA cell should be based on the total amount of VG/PG emix with out factoring in the flavor. So as such I have revamped the formula in the Water/Vodka/PGA cell in section two to the following formula:
=((F8-((F8*F11)/100))*F9)/100
This will calculate the needed Water/Vodka/PGA for the ejuice minus the flavoring.
I also took this time to add to section 4 two additional nic sources so you can now add up to 4 dissimilare nic juice % and quantities and it will calculate what the total quantity and mg% based on those 4 nic juice sources. I also added drop fields and percentage fileds for section 4. And updated the macro to reflect the changes to the additional rows added to the calculator.

New link is the same, as always it is in my sig line.
Props to JoeMcPlumer for identifying this!
Dan

For those that can not download from filesanywhere, here is the file:

 

[Guineahill]

It just keeps getting better and better!!! Thanks Scubabatdan!!!