22Likes
LinkBack URL
About LinkBacks:-)Originally Posted by Scubabatdan
I must have had an originally v7 - downloaded it again and there they are! :-) I like the drop down...
Way to go Dan - thanks a bunch!
:-)
I must have had an originally v7 - downloaded it again and there they are! :-) I like the drop down...
Way to go Dan - thanks a bunch!
OK no problems will hold off :P
What I meant was the flavor page worked, but the pull downs on the caculator page for the manufactures and flavors did not. Havent had time to work em yet.
Dan
Do you work in Excel or Open Office? They worked fine in Excel... I guess I'll go download OO and try to figure it out before I perfect this recipe thing. Argh.
Ok it does work, the manufactures celss were greyed out so I didnt try to use them, I heve recolored it and re organized it some. I will wait for the updated recipe list before posting the update.
This is the third time I have tried to post this today. With the server being busy continuosly.
Dan
Ok update to V7, Scottes and I have teamed up and he has added a nice drop down list when selecting flavors for your recipes. First select the manufacturer, then the flavor. Once you have the recipe the way you like it, you can record it on the recipe page that Dale.S created. The recipe page now has 46 recipes on it. And we will continue to add recipes to it as people send them to us or we add our own. Some already listed in this are from combing the different post looking for recipes that users have created (credits given on recipe page). I would like to eventually record them all in one location. These are ONLY recipes that use unflavored nic juice and one of the 6 flavor vendors listed, yes SIX... Scottes has been busy adding in the remaining 3, so we have all of the popular vendor flavors listed.
Bickford
Capella
Faeries_Finest
FlavourArt
LorAnn
Tasty_Puff
Ok what else.... hmmmm
Oh yeah ENJOY!
Download link in my signature!
Dan & Scottes
S W E E T !!!!!
One question though, unless this has been answered:
The recipes list the correct ratio of flavorings, but shouldn't they also include an "overall" ratio or percentage of the total bottle of juice? You can adjust the amount of flavoring in the top section (5%, 10%, etc) but this number obviously affects the strength of the flavoring in the vape. While this can be subjective, it would seem to me that this might be a good thing to have automatically changed per recipe.
Only downside is it should also be overrideable. IE: When the recipe is chosen, this cell can be based off a cell on the recipe sheet (using a formula in cell F10) but if the user wants it stronger they can just change it. But if a user overrides it, it would break the formula.
If anyone agrees with this, does anyone know if you can change a cell's value using a formula in another cell? If not, it could easily be done with VBA code, which I happen to be familar with having created Excel sheets for work using extensive VBA code (I've been writing software in VB for many years). Only problem is that macros would need to be enabled in order for it to work, and also I don't know if OpenOffice utilizes VBA code which would cause problems for those who use it.
Maybe this is what Dale meant here unless I misunderstand him: http://www.e-cigarette-forum.com/for...tml#post593060
Edit: Or am I over-thinking this and the ratio of overall flavorings to nic/pg/vg shouldn't change much per recipe?
Any thoughts?
Last edited by KevinD872; 09-29-2009 at 07:05 PM. Reason: Afterthought
Hmmm I see your point, since the flavors are percent based off of the total make up of flavors the base % going into the mix would be subjective to the individual. I would leave it and recommend 5% as a base for flavor. You can always add to flavor, but can not take away. But it is based on the % flavoring in F10 based off the number of drops per ml in F14. If any of those change then so do the recommended drops. Running multiple fields for recommended and what the user likes could be way off. One user might like 5% and another might like 15%, so I would let the user decide.
But the ratio of how much per flavor is set in the recipe section. That is the ratio of flavors to equal 100% of total flavoring to add. And then this amount is based on the # of drops per ml and the % to add. So to many moving parts to stick another wrench into LOL
Anyone elses thoughts?
Dan
I don't totally understand your question - but that's probably because I am thinking differently. So perhaps I can explain my reasoning for liking how this works.
When I concoct a recipe, I find that certain flavors work well together, but rarely in equal amounts. So I might find that coffee works when enhanced slightly with a little toasted almond, and a hint of chocolate. So I may end up making a tiny test batch with something like 10 drops of coffee to 2 drops of toasted almond and a single drop of chocolate.
I'll vape 3-5 drops of this, and then adjust the flavoring. Maybe another drops of toasted almond, and 2 more drops of chocolate.
That, to me, is the recipe - the mix of tastes that coordinate to make a final product.
Now I tend to like this flavor to be very strong in my juice, so I go up top in the spreadsheet and make the flavor percentage to be 25% of the final mix. I like the final product to be 10mg nicotine from a 40mg base, and 15% VG to give good vapor. The rest is PG, and the calculator figures everything out to make me a 10ml bottle full of this.
My wife likes this flavor, too, but not as strong, so for her I set the flavor strength to 20%. She also likes 24mg nicotine, but no VG because it gives her a headache. I change those settings - 24mg and 0 VG - the calculator changes all the amounts to make her bottle.
Both of us end up with the same flavor, but our batches are wildly different in all of the ingredient amounts.
Alas, I haven't played with the new recipe database part of this spreadsheet yet, so I'm not sure how it works. But with my example above, I'd probably end up with 2 entries in the recipes sheet - one for me, and one for my wife.
Last edited by Scottes; 09-29-2009 at 09:08 PM.
I agree, to make F10 dynamically change with the recipe definitely complicates things. Again, the overall strength of flavor in the vape is subjective. My thought was just that recipes with several stronger flavorings would probably require a less overall ratio of flavorings compared to a combination of weaker flavorings. It's really probably best to leave it. I wondered if people adjust the overall flavor percentage with each recipe, but if they did, that info is not listed in the recipes.
So, you usually do about 5% flavorings on all of your recipes Dan? I am still yet to make my own juice (have everything I need, just using up my pre-mixed juice first), but I was thinking more like 20% flavorings...... eeek. Maybe too much!
Last edited by KevinD872; 09-29-2009 at 09:37 PM.
LOL good explanation, I have already rewritten and added fields in to take into account the recommended %, BUT I would have to use the =IF(F11>F10, Use recommended, else use users) the problem is if the recommended is 25% the user can not run it at say 7% because F11 the new recommended % field is > than F10 the users input. Most users know the strengths they like. Me I prefer 5-10% After 100+ days my taste buds have come back and I dont need it that strong anymore.
But I think we should leave it as is, and allow the user to decide on the % strength for themselves. The flavor is decided on by the recipe as Scottes discussed and the strength of the flavor (how strong it is) is decided on the % of flavoring added.
I concur with Scottes here.
Dan
Posting Permissions
Reply With Quote
Bookmarks