Ejuice calculator (added quantity calculations)

[VA Slim]

Dan....great interview. Thank you for your voice on our behalf. Yes, you made us proud to be fellow vaperers.

[yourgems510]

Are bickford's flavorings the same as loran's? Is there a problem when you mix the oil base flavors? I also noticed that bickford has some flavors that are soy oil base. Can anyone please tell me if bickford is good to use?

[Scottes]

Dan,

Thanks for doing all the work on this calculator! It's extremely useful when my wife and I are experimenting with our juices.


Both of us have found that we tend to invent mixes, and we do this by making up a very small batch with 2 or 3 different flavorings. We will usually make a wild-ass guess about how many drops of each flavor to use, and we test that. Invariably we will find that the balance is off - perhaps one flavor is not prominent enough, or another is too strong. So we will add a drop or two of a weaker flavor.

In the end, after a lot of tweaking, we will have our "flavor recipe" which will have different amounts of drops for each flavor. This "flavor recipe" might be something like 7 drops of #1, 3 drops of #2, and 1 drop of #3. We then go to your E-Jucie Calculator to make a larger batch.


This is where the pain comes in, since your calculator currently requires me to enter the percentages for each flavor. But I have the counts for the drops for each flavor. If recipe calls for something easy - if it contains a total of 10 drops of flavoring for instance - then it's easy to calculate the percentages. But if the recipe contains 4 flavors totaling 17 drops then it's a mild form of torture to figure out the percentages.


So I edited your spreadsheet, and added a section that will calculate the flavoring by ratios.

One simply enters the number of drops used for each flavor in the small test batch. The formulas figure out the Total number of drops, and for each flavor it figures out the percentage for that flavor, and multiplies that by the total number of drops or milliliters required for the batch. In psuedo-English, the formula is simple: (Drops / TotalDrops) * BatchDrops.


In the example below, my recipe calls for 3 flavorings with a total of 7 drops in a 4:2:1 ratio. The batch calls for 2.5ml, or 50 drops, of flavorings in order to make my desired 10ml of final product. This new section calculates how many drops of each flavor is required, based on the ratio after all my tweaking.




I think this sort of calculation might be convenient for others to use, so I was hoping that you could add it to your Excel spreadsheet. I made these edits in Microsoft Works, but you should be able to open it in Excel and cut & paste it into your spreadsheet. The file can be found here:
http://www.itsanadventure.com/postim...ator_Ratio.xlr


Again, thanks for all the work on this. I hope you find my edits to be useful.

[Dale.s]

Ive made a few changes to your wonderfull sheet and i wanted to share! Section 5 is now a total juice recipie solution! Goto sheet called "recipies" and input the data for the juices you have made in this format:

Flavor name | Total Flavor % in final mix | Flavor 1 | % of flavor | Flavor 2...

for example:

Jolly Rancher | 30% | Watermelon (Loranns) | 100%

This would give you a juice name of "Jolly rancher" using 30% of final mix of Loranns watermelon flavoring.

Now goto section 5, at the top of this section is a dropdown, pick your juice. This section now fills in with total flavor % to the right (this is the same % you would enter in section 1). Each flavor name, % of that flavor, and ML required of flavor per mix you picked in section 1. - Note, % Flavor in section 1 is not auto filled so you can do this by hand when working on new mixes.
ejuce_calculatorv6.5.xls

[Scottes]

Dale, I was working on something very similar but ran into a couple problems because I don't know Excel all that well.

My plan had been to add a button that would copy all the fields onto the "Recipes" sheet, recording the quantities for different size batches. So I was going to output something like this:



This way I'd (probably) never have to type into the Calculator sheet again. I was also thinking about adding another cell so it could be pasted here using those [ code ] tags that keep formatting pretty.


What do you think about my output?

[Dale.s]

Thats awesome, keep working on it for sure!

[Scottes]

Thats awesome, keep working on it for sure!

I will - though I might have to steal some of your code. I know VB very well, but not the Excel-specific VB commands, so it's sometimes frustrating to figure out to do things like "go to the first available blank row". I would normally type "ctrl-home, end, down-arrow, down-arrow" to do this by hand, but what the heck is the macro command to do the equivalent? I even recorded a macro, and typed "end down-arrow down-arrow" but when I use those in a macro it always take me to A65536, not the first available blank row!

I'll keep hacking away though.



Let me pass on another idea I had, and see if people think it's useful:

Most of my bottles have built in droppers. For the others, I use pipettes. This means that every drop is a different size.

For experimenting with very small batches this is easy since I'll just drop each ingredient until I get to 2 or 3 ml. But when I want to make 30ml I want to use milliliters - I'm not going to count out 600 hundred drops! But the ratios are wrong since the drop sizes differ.

Dan conveniently made a "drops per ml" configuration item, but this assumes that every drop is exactly the same size.

Would it be useful to have a "drops per ml" for each and every ingredient? This way one can configure 17 drops per ml for pipettes, 25 drops per ml for LorAnn's tiny droppers, etc.

If nobody wants to use this one could set them all to "20" but it does give greater accuracy for those of us who care.



By the way, Dan, I hope that you don't think that I am trying to steal any thunder with such ideas. Heck NO! I'm just hoping to add some features, and to do it in a way that lets you copy & paste code into your spreadsheet. I'm just trying to help.

[vapn]

THANKS DAN>>> I have been looking for something like this to help me with this 54mg TW Platinum Ice I got today. I wanted to bump up some 12mg juice I have but was unsure how to do the ratio... This spreadsheet is on my desktop where it will be used many times.. Until I know it in my head anyway...
Thanks for sharing this with us...
Until I got this I found this on the forum also
e-juice calculator....

Thanks again Dan...

[Dale.s]

Scottes, I was looking at it the same way as you, using macros. But take a look at the function i used in section 5 (i forgot what it was, im sleepy!) and lookup the help file on that, there a few variations on the same function that can look for certain items, match sections (like you could like every lorann flavor you use for example) and find the row number of blank lines. Its SO easy to think "MACRO!" but i found its a lot easier to use what excel already has to offer, if you cant find the right function lemmie know what your trying to do and ill go a hunting for you!

[Scubabatdan]

Dan,

Thanks for doing all the work on this calculator! It's extremely useful when my wife and I are experimenting with our juices.


Both of us have found that we tend to invent mixes, and we do this by making up a very small batch with 2 or 3 different flavorings. We will usually make a wild-ass guess about how many drops of each flavor to use, and we test that. Invariably we will find that the balance is off - perhaps one flavor is not prominent enough, or another is too strong. So we will add a drop or two of a weaker flavor.

In the end, after a lot of tweaking, we will have our "flavor recipe" which will have different amounts of drops for each flavor. This "flavor recipe" might be something like 7 drops of #1, 3 drops of #2, and 1 drop of #3. We then go to your E-Jucie Calculator to make a larger batch.


This is where the pain comes in, since your calculator currently requires me to enter the percentages for each flavor. But I have the counts for the drops for each flavor. If recipe calls for something easy - if it contains a total of 10 drops of flavoring for instance - then it's easy to calculate the percentages. But if the recipe contains 4 flavors totaling 17 drops then it's a mild form of torture to figure out the percentages.


So I edited your spreadsheet, and added a section that will calculate the flavoring by ratios.

One simply enters the number of drops used for each flavor in the small test batch. The formulas figure out the Total number of drops, and for each flavor it figures out the percentage for that flavor, and multiplies that by the total number of drops or milliliters required for the batch. In psuedo-English, the formula is simple: (Drops / TotalDrops) * BatchDrops.


In the example below, my recipe calls for 3 flavorings with a total of 7 drops in a 4:2:1 ratio. The batch calls for 2.5ml, or 50 drops, of flavorings in order to make my desired 10ml of final product. This new section calculates how many drops of each flavor is required, based on the ratio after all my tweaking.




I think this sort of calculation might be convenient for others to use, so I was hoping that you could add it to your Excel spreadsheet. I made these edits in Microsoft Works, but you should be able to open it in Excel and cut & paste it into your spreadsheet. The file can be found here:
http://www.itsanadventure.com/postim...ator_Ratio.xlr


Again, thanks for all the work on this. I hope you find my edits to be useful.

Love it will add it in, I like the drops method also I think we can satisfy both sides with percent and a ratio section. Great work!

I have been busy with my BS degree and havent been on much lately. I will post V7 with your additions.

I do not care it anyone want to upload their version of this calculator, that is why I left it un passworded so people can tailor it to their needs. I am just glad it is helping folks!

Dan