Dan....great interview. Thank you for your voice on our behalf. Yes, you made us proud to be fellow vaperers.
Flavor name | Total Flavor % in final mix | Flavor 1 | % of flavor | Flavor 2...
Jolly Rancher | 30% | Watermelon (Loranns) | 100%
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!Thats awesome, keep working on it for sure!
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-... 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/postimages/E-Juicie_Calculator_Ratio.xlr
Again, thanks for all the work on this. I hope you find my edits to be useful.
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:
Code:Flavor name | Total Flavor % in final mix | Flavor 1 | % of flavor | Flavor 2...
for example:
Code: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.
View attachment 4471
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.
My thoughts had been about having this option for every ingredient. My nic-juice bottle is different from my PG bottle, which are different from the pipettes used for LorAnn, which is different from the Capella dropper bottles. Some of these differences might be slight - though your comment about 40/ml for LorAnn is wildly different from the generalized 20 or 25 drops per ml that most people quote around here.I suppose I could play around with the drops per ml per flavor, but then if someone uses a different dropper thean you then the point is mute.
I think you should continue to work on your BS, which is far more important than this. I'll play with it if I get time, or maybe I won't and the idea can be re-visited in the future.Hmmm let me think about it.
though your comment about 40/ml for LorAnn is wildly different from the generalized 20 or 25 drops per ml that most people quote around here.
Awesome work dan! just one note about my addition, the "Total flavor %" was the amount of flavor per batch like in section one, one recipie might use 20%, another 30% for example, not the total of all flavors added. Might need to find a way to make that clearer. great work btw!