Ejuice calculator (added quantity calculations)

[dmall]

Dan,
I am going to start working on a list of all the flavors and manufacturers that I can find. I will put them on an open office spreadsheet and send the spreadsheet to you so all you have to do is copy and paste the list. It might take a week or so to be done, this way you are not doing all of the work. I would love to know, however, how the relationship to that list is set up cause I am somewhat used to working on excel and cannot figure out your formulas.

 

[Scubabatdan]

Okay Dan,
I opened up the updated list. In cell 10A I changed empty1 to Flavor West. Then went down column A to cell 594 Emply1 and changed to Flavor West then to column B and changed flavor to Vanilla Custard. Went to VG page, Section 6 and select drop-down for manufacturers and was able to select Flavor West great right. But when I went to drop-down for flavor it still gives error code 502. I give up. I don't want to continue to bother you. Thanks for trying to help

Was afraid of that, will change Empty1 to flavor west.
Dan

 

[Scubabatdan]

Dan,
I am going to start working on a list of all the flavors and manufacturers that I can find. I will put them on an open office spreadsheet and send the spreadsheet to you so all you have to do is copy and paste the list. It might take a week or so to be done, this way you are not doing all of the work. I would love to know, however, how the relationship to that list is set up cause I am somewhat used to working on excel and cannot figure out your formulas.

Ok sounds good!
Thanks,
Dan

 

[Scubabatdan]

Changed Empty1 to Flavor_West, also I updated the flavors for Lorann, TPA, and Tasty_Puff.
Newest is always in my sig as a download link.
The reason the name change did not work, is it has to changed in the names manager. Does not auto change when you change the name Thought it did, sorry...

Dan

 

[Scubabatdan]

Ok, I have added in all the flavors for the following Manufacturers,

Flavor West
vaping Zone

Enjoy...
Link is in my sig....
Dan

 

[dmall]

Ok, I have added in all the flavors for the following Manufacturers,

Flavor West
vaping Zone

Enjoy...


Link is in my sig....
Dan

Dan, Did you include the VZ-SC Gourmet flavors in the vaping zone? I want to separate the concentrated flavors from the gourmet flavors because they are really different.

 

[Scubabatdan]

Dan, Did you include the VZ-SC Gourmet flavors in the vaping zone? I want to separate the concentrated flavors from the gourmet flavors because they are really different.

No, I did not add the gourmet flavors but will when I get a chance.
Dan

 

[Scubabatdan]

Ok, that took me 10 minutes to do

Added VZ_Gourmet and all associated flavors...

Anything else
Download link in my sig...
Dan

 

[dmall]

No, I did not add the gourmet flavors but will when I get a chance.
Dan

Dan, I'll put them on my spreadsheet then send them to you with the others I'm doing.

 

[Scubabatdan]

Dan, I'll put them on my spreadsheet then send them to you with the others I'm doing.

Ok, that took me 10 minutes to do

Added VZ_Gourmet and all associated flavors...

Anything else
Download link in my sig...
Dan

Did you miss the post above, VZ_Gourmet already done
Dan

 

[dmall]

Did you miss the post above, VZ_Gourmet already done
Dan

Oh, I guess I did, sorry. Mother's Day Cocktails

 

[Scubabatdan]

Updated Bickfords flavors,
Link in my sig,
Dan

 

[Scubabatdan]

Updated Faeries Finest Flavors.
Dan

 

[Justin Proctor]

I use spreadsheets for everything and can appreciate the amount of work that went into this but i just cant wrap my head around it Thought i would give your a go because even the simple ones confuse me...needless to say i was blown away by the whole thing To late for me to try and figure yours out will try again in the morning

 

[Scubabatdan]

I use spreadsheets for everything and can appreciate the amount of work that went into this but i just cant wrap my head around it Thought i would give your a go because even the simple ones confuse me...needless to say i was blown away by the whole thing To late for me to try and figure yours out will try again in the morning

LOL no problem, read the instruction page, it may help
Dan

 

[Barto]

Updated Bickfords flavors,
Link in my sig,

Dan

Great stuff, thanks man!

 

[FinallyQuit]

Dan, thanks for a fabulous calculator! Works very well with Linux, which can sometimes be a bear. Love that the cells are large enough for these old eyes, too!

 

[renatortb]

My hero! Great job!

 

[Roobs]

Please excuse my ignorance but I am a greenhorn . On your calculator why am I getting a -.20ml. in Sec. 2 line 2 ,the PG no-nic line . I'm trying to make a 60/40 pg/vg mix in a 10ml size. How do you handle negative ml.'s

 

[Hoosier]

Your requirements have made your PG/VG ratio impossible. So if your flavoring, almost always a source of PG, and your nicotine, probably PG, add up to more than 6ml's of your 10ml mix, the formula is showing that PG has to come out. If you were to change your ratio to 62/38, I'll bet the negative PG amount would disappear. (I'm betting your flavoring and PG nicotine add up to 6.2ml..)