Ejuice calculator (added quantity calculations)

[CloudBurst]

Dan, about that Double Chocolate, I couldn't wait to get home to copy and paste it for you but...it wasn't there. I swear it was on one of the versions I downloaded last night, oh well! Anyway, thanks for the tips for the macros, I just installed the 2007 and I'm not too familiar with it. Big differences in the versions. Thanks again.

In 2007, click on the windows circle in the upper left corner, select excel options, click trust center on the left, now click the trust center settings button on the right. Click macro settings, click enable macros. This will enable the macros for PG and VG.
Double chocolate is not on the recipe sheet, the recipe cards pulls the name from column A of the recipe sheet. Where are you seeing Double Chocolate?
Dan

[Scubabatdan]

Dan, about that Double Chocolate, I couldn't wait to get home to copy and paste it for you but...it wasn't there. I swear it was on one of the versions I downloaded last night, oh well! Anyway, thanks for the tips for the macros, I just installed the 2007 and I'm not too familiar with it. Big differences in the versions. Thanks again.

I added my version of peanut butter cup in there, and it used 2 different chocolates from cappelas, one of them was double chocolate. Look for Peanut Butter Cup 2. That was it.
Dan

[CloudBurst]

LOL, ya I bet you're right!!

[kissang]

I have a very basic question here.
In PG mode, when I put a number in water/vodka/PGA % cell, there is no output in formula(section.2), it only works in VG mode.
Does this mean with PG you don't have to add water/vodka/PGA? or is PG itself so thin that you cann't use water/vodka/PGA since it can water down PG?

I was planning to add vodka to PG nicotine but I am wondering if I am on the right track.

[JLeigh]

Just a quick question. The calculator won't include the VG percentage (in a PG-based recipe) that I put in section 1 in the section 2 end-result calculations. I'm not sure what I'm doing wrong....

[Scubabatdan]

I have a very basic question here.
In PG mode, when I put a number in water/vodka/PGA % cell, there is no output in formula(section.2), it only works in VG mode.
Does this mean with PG you don't have to add water/vodka/PGA? or is PG itself so thin that you cann't use water/vodka/PGA since it can water down PG?

I was planning to add vodka to PG nicotine but I am wondering if I am on the right track.

Just a quick question. The calculator won't include the VG percentage (in a PG-based recipe) that I put in section 1 in the section 2 end-result calculations. I'm not sure what I'm doing wrong....

Ok IF you use VG, then you MUST enter a % in the water/vodka/PGA field or it will remain 0.

IF you add a % in the water/vodka/PGA field then you MUST add VG.

The water/vodka/PGA % is only based off how much VG you add to a PG based mix. If you dont add VG then you do not need water, as PG is thin enough and even thinner when you add flavoring.

Both fields in sec 2 remain 0 uless you add a % in both the VG and water/vodka/PGA field.
I did put a nag screen in when you clicked the PG radio button

You can fool it, say you want 5% water or VG but not both. The add 4.5 for VG and .5 for water. Then total section 2's VG and water and put in which ever you want.

Does this help?
Dan

[JLeigh]

Ahhhh. Thank you! That worked.

[kissang]

Ok IF you use VG, then you MUST enter a % in the water/vodka/PGA field or it will remain 0.

IF you add a % in the water/vodka/PGA field then you MUST add VG.

The water/vodka/PGA % is only based off how much VG you add to a PG based mix. If you dont add VG then you do not need water, as PG is thin enough and even thinner when you add flavoring.

Both fields in sec 2 remain 0 uless you add a % in both the VG and water/vodka/PGA field.
I did put a nag screen in when you clicked the PG radio button

You can fool it, say you want 5% water or VG but not both. The add 4.5 for VG and .5 for water. Then total section 2's VG and water and put in which ever you want.

Does this help?
Dan

Thanks Dan, it was a great help...

[I Stelfer I]

Seeing as I use 99% pure nicotine and dilute from there my number one fear has always been messing up a decimal place or hitting 5 instead of 2 or something along those lines. This calculator definitely takes alot of stress off my end since a miscalculation means more than just throwing out the batch. Great great product man. I honestly don't think I could say that enough in one post.

On a side note what are the advantages of VG compared to PG? I only ever mess with PG on account of the fact that I acquired it for free.

[Scubabatdan]

Seeing as I use 99% pure nicotine and dilute from there my number one fear has always been messing up a decimal place or hitting 5 instead of 2 or something along those lines. This calculator definitely takes alot of stress off my end since a miscalculation means more than just throwing out the batch. Great great product man. I honestly don't think I could say that enough in one post.

On a side note what are the advantages of VG compared to PG? I only ever mess with PG on account of the fact that I acquired it for free.

Well first thanks for the accolades
Second, while I DO NOT recommend the use of pure nic nor do I recommend anyone try what you are doing. I am glad it is helping you, please be careful, and I hope you are getting you nic from a certified source .990+ and not .980.
Third, VG gives much more vapor than PG does, the downside is that it mask the flavor so you have to use more. That is why I use a 20/80 mix of VG/PG. Helps the vapor with out diminishing the flavor.

Please do not post your methods here on using pure nic, all it takes is one novice to mishandle it and the FDA would have a field day. Practice safety in everything you do, and be responsible when posting such information. In the wrong hands it could prove deadly.
Thanks
Dan