Ejuice calculator (added quantity calculations)

[MacDiver]

Dan,

Can you add a dropdown selection for Vodka as a flavor on your next update? This is needed for Guineahill's PA Tangerine recipe for example. It only takes Tangerine and vodka to make but we can't choose vodka as a flavor.

Thanks!

 

[Ast_Isis]

Holy Hell, Dan! I finally got around to downloading Version 11 (have been using version 7 ) and I must say it is really nice. I like the improvements!

 

[Scubabatdan]

Hey dan, first off, thanks for a great tool. Comes in very handy.

But,
I'm not sure if I'm the only one experiencing this problem. I'm using Windows 7 and since I don't have Excel, I'm using OpenOffice. When I click to add recipe, this is what I get:



Also, in the flavor list, it shows a TPA white chocolate, but it does not appear as a choice on calculator. When I've tried to add flavors to this list (unprotect sheet first), they don't show up in drop down list either. Any ideas?

When openoffice first starts up it asks if I want to enable macros or not. I click to enable. Don't know what else to try. I've tried opening the calculator, and saving in .ods format and reopening, with no change.

Is it just not fully functional using OpenOffice???

Thanks again, and looking forward to getting my bugs worked out.
Kyle

Sorry was out of town, will have a look, and fix the white chocolate problem.
Dan

 

[Scubabatdan]

Dan,

Can you add a dropdown selection for Vodka as a flavor on your next update? This is needed for Guineahill's PA Tangerine recipe for example. It only takes Tangerine and vodka to make but we can't choose vodka as a flavor.

Thanks!

Will do....
Dan

 

[MacDiver]

Dan,

Since I am a noob at all this but have finally figured out some things about how to use your calculator I'd like to make a couple suggestions about how it may be more noob friendly. I finally realized today what Secton 3 was telling me about cutting so I'm a little slow it seems

I couldn't figure out how to use the Make a New Recipe section at all and still don't really know how to apply it. The ratio part is what is confusing as recipes aren't stated in ratios that I've seen.

The way I use the calc is to use the recipe selector below it after inputting my recipe on the Recipe page. Guineahill showed me how to do it. I had PM'd her about how to use one of her recipes in the calc and she showed me how to unprotect the Recipe sheet and add the one I wanted to make using percentages and then I could understand how it worked and see the result on the main page under the recipe dropdown. Now that is what I do to make all of mine and am having good success doing it like that. I also moved one of the tabs to the right end so that when I changed a recipe I didn't have to arrow back to the left to get back to the main page to see the result.

I had asked on another post how to convert parts to drops and ml and you gave Switched and me the little spreadsheets that made the conversion table with the modifier. I'm still working on understanding how it works and how to adapt it for future recipes given in parts. Could that be incorporated into the sheet too?

Maybe the top section Make a New Recipe, could have spaces for whatever is called for eg percent, ratio, drops or parts and be able to show the results in each of the formats in the second box like is done when a recipe is added on the Recipe page. Then when the recipe is ready to be saved the add recipe button would add it to the recipe list in the second box from the top box. I guess you see what I'm getting at.

Some basic instructions on how to get started, maybe under the main page under the mfg drops per mil area, would help peeps get off to a good start I think. I spent a lot of time and fustration playing with ratios with the top recipe box before Guineahill got me on the right path.

You've done a great thing with the current one and we appreciate it a lot.

 

[Guineahill]

I'm glad it is working better for you now! The calculator is a great tool... I use it almost every day!

 

[MacDiver]

Guyz,

I am trying to add TPA flavor White Chocolate and all of Linda's new flavors to the spreadsheet under the tab Flavor List for Drop-Downs so it will show up on the dropdown in the Make a New Recipe section for maker TPA. I'm also trying to add Happy Vapor as a maker - not really a maker but as an experiment to be able to add a maker if needed- but they won't show up once added to the sheet.

Eg, if I go to the far upper left on the Flavor List for Drop-Down tab and click the dropdown above column A I can choose TPA and press enter. The column under Flavors will show all the TPA flavors highlighted in blue.

That tells me that I have to somehow add additional flavors to the highlighed area. I then inserted a row under the last TPA entry and copied and pasted the last item in the TPA row to that new row and changed the wording to White Chocolate. I figured it would add it because it would bring over all the settings for that line but that didn't work. It will insert the line but it won't add it to the blue area.

I also added Happy_Vapor to the Drop-Down Master List but it won't show up as a maker under the list for Make a New Recipe section either.

Anyone know how I can make the modifications? Am I dealing with a hidden pivot table or something?

Thanks!

 

[Hoosier]

Adding flavors, the Hoosier way... well, Dan gave me this method:

Make sure macros are enabled, instructions in this thread.

Highlight a row
Right click
Click on Insert
Makes a new row that will become part of the drop down in the first sheet.

The TPA White Chocolate wasn't showing up and I did an insert row above it, cut the existing flavor, and then pasted it in my new row and now it works. Just left the row the flavor was in blank.

It works if you stay inside the range of the maker pretty easy. It can get a little glitchy when you add your own drop down range, but it does work. (I have a maker called HomeMade for the flavors I make and at first I could only get 3 flavors to work in the drop down, but re-did it and now it works.)

 

[MacDiver]

Yep, worked like a champ!

Thanks Hoosier!!

*hope he wasn't too disappointed when those Duke boyz beat Butler*

 

[Hoosier]

Yep, worked like a champ!

Thanks Hoosier!!

*hope he wasn't too disappointed when those Duke boyz beat Butler*

Glad it worked.

Yes, I was quite disappointed. I always root for the underdog if it is not a Big 10 team playing and a little school from a campus where I got to meet Robert Palmer too... Gotta' admire the teamwork both teams displayed and the great game that was played though. (Though Big 10 teams are usually underdogs too... sigh.)

 

[riche]

Brilliant ... thanks

 

[Tasteles]

Scubabatdan,
Something I changed on your calculator that maybe you might consider for your next version. I added 2 decimal points to the recipe ratios, it lets you fine tune your recipes better. Thought I'd throw this out there and see what you think.

 

[Tasteles]

Dan,

I couldn't figure out how to use the Make a New Recipe section at all and still don't really know how to apply it. The ratio part is what is confusing as recipes aren't stated in ratios that I've seen.

This change that I made in the above post directly coralates to the percentages. 23.9% would be 2.39 ratio, 20% would be 2.00 ratio. The way it's currently written, ratios are numbers from 1 to 10 which goes from 10% to 100%. Hope this helps you figure it out.

Might be easier if Scubabatdan changed that to percentages insead of ratios. in his next release.

 

[MacDiver]

You must enter a number in the Water/Vodka/PGA field for the calculator to work properly too. Otherwise it won't show amount of PG or VG you need to add to get the 70/30 or 80/20 PG/VG percent that most peeps use. I use 0.01 if I'm not using Water/Vodka/PGA to make it work. The comment cell needs to give a stern warning about that issue.

 

[brianwhynot]

Sorry to be a nudge but I was wondering if you solved the problem that Southern-Vapor had with Open Office running macros. I'm having the same problem too. I'd be more than willing to test it out for you as well.

Also, I think you can add zero as part of your number range so it doesn't give a null amount when one doesn't use water/PGA/whatever in their mix. Been a while since I've done a spreadsheet so I couldn't say for sure.

 

[Burto1945]

First things first, THANK YOU Scub, this is an amazing tool for figuring out DIY ratios. I really appreciate all the work.

After using it, there's one thing I noticed: the percent you put in for Water/Vodka/PGA is actually a percent of the VG, not of the total mix. So if you put in 20% for water and 20% for VG, if you look at the final totals in section 2, it will show 4% for water, which is, obviously, 20% of 20% (.20 x .20), and not 20% of the total mix, which is how I originally set up my calculations. I was confused for quite awhile with that until I realized my mistake. Maybe add an explanation to the next iteration of the calculator.

One suggestion, if I may: I'd like to see the amount of drops per ml be set per ingredient (or by vendor, possibly). There have been times where I am using flavors or ingredients from all types of different vendors, and each bottle has different droppers. It's not a huge deal, I just have to remember to switch out that global setting to see exactly how many drops I need from this bottle, then this bottle, etc. Just a thought.


Oh, and I should say, if all that I have written here is common knowledge, forgive me, I'm new to the whole DIY thing. Thanks again Scub, much, much appreciation.

(There are also some new flavors from Perfumer's Apprentice not on the drop-down, but I can add those myself, I think).

 

[Scubabatdan]

First things first, THANK YOU Scub, this is an amazing tool for figuring out DIY ratios. I really appreciate all the work.

After using it, there's one thing I noticed: the percent you put in for Water/Vodka/PGA is actually a percent of the VG, not of the total mix. So if you put in 20% for water and 20% for VG, if you look at the final totals in section 2, it will show 4% for water, which is, obviously, 20% of 20% (.20 x .20), and not 20% of the total mix, which is how I originally set up my calculations. I was confused for quite awhile with that until I realized my mistake. Maybe add an explanation to the next iteration of the calculator.

One suggestion, if I may: I'd like to see the amount of drops per ml be set per ingredient (or by vendor, possibly). There have been times where I am using flavors or ingredients from all types of different vendors, and each bottle has different droppers. It's not a huge deal, I just have to remember to switch out that global setting to see exactly how many drops I need from this bottle, then this bottle, etc. Just a thought.


Oh, and I should say, if all that I have written here is common knowledge, forgive me, I'm new to the whole DIY thing. Thanks again Scub, much, much appreciation.

(There are also some new flavors from Perfumer's Apprentice not on the drop-down, but I can add those myself, I think).

No problem, yes the water value is based on the amount of VG you add, since only the VG really needs to be thinned. I talked with others on the forum and concluded that if you use the total mix to calculate water it thins the final product out to much and reduces the amount of vapor and can cause flooding of the atty. This is why the water is only based on the VG you add.

As for the drops, I have debated over this issue for along time. the main reason drops are included is for extremely small batches when you can count the drops easily. When doing larger batches ml should be used. You will note that only the drops are affected when the drops = 1ml field is changed. it has no affect on the ml fields. The other problem with drops is that depending on viscosity it will scew the actual drops = 1 ml and the different droppers obviously will change the drops = 1ml, so it is almost impossible to calculate every concivable vendor/droppers/viscosity or a combination of these factors to reliably add in additional fileds. That is why the drops are an approximation for small quantities.

As soon as I am done with my BS degree at the end of Jul, I will be making some revisions and release v12 with more of the flavors from PA etc..
Hope this helps answer some questions.
Dan

 

[Scubabatdan]

Sorry to be a nudge but I was wondering if you solved the problem that Southern-Vapor had with Open Office running macros. I'm having the same problem too. I'd be more than willing to test it out for you as well.

Also, I think you can add zero as part of your number range so it doesn't give a null amount when one doesn't use water/PGA/whatever in their mix. Been a while since I've done a spreadsheet so I couldn't say for sure.

Problem is still there, and it is really a pain...
Adding zero will result in a zero field since the calculation is based off of
=IF(E10=0,0,IF(E11=0,0,E9*E11/100))
If either Water or VG is 0 then then both will be zero.
This forces the person to add water if they add VG but you can add a .1 and it will the calculated the amounts.

And the NAG screen does state this in excel:

But I do not think it displays in open office.

Hope this helps.
Dan

 

[Hoosier]

I use PG and VG mixes, but never put VG or Water entrys in Dan's spreadsheet.

First I take my VG & thin it to how I like it.

Next I make 3 bottles up. One with 90/10 PG/VG, one with 70/30 PG/VG, and another at 60/40. I use the mix out of these bottles as my "PG"

For a hint of VG, I use the first. For close to 20% VG the second and for close to 30% VG the third.

The exact ratio of PG to VG just has not been that critical in my recipes. VG adds some sweetness and vapor production and can help meld some flavors. But being off 5% is just not a big deal so I don't worry about it.

So, while my recipe uses VG, I never enter anything about it. I make a note of what mix I used to get the best effect/flavor in the notes section along with the flavor % and save it off.

Hopefully this could work for one other person out there.

 

[Scubabatdan]

I use PG and VG mixes, but never put VG or Water entrys in Dan's spreadsheet.

First I take my VG & thin it to how I like it.

Next I make 3 bottles up. One with 90/10 PG/VG, one with 70/30 PG/VG, and another at 60/40. I use the mix out of these bottles as my "PG"

For a hint of VG, I use the first. For close to 20% VG the second and for close to 30% VG the third.

The exact ratio of PG to VG just has not been that critical in my recipes. VG adds some sweetness and vapor production and can help meld some flavors. But being off 5% is just not a big deal so I don't worry about it.

So, while my recipe uses VG, I never enter anything about it. I make a note of what mix I used to get the best effect/flavor in the notes section along with the flavor % and save it off.

Hopefully this could work for one other person out there.

Good point, I do the same thing but I premix 20/80 VG/PG and the just use that mix for the PG field.
Dan