Ejuice calculator (added quantity calculations)

[tolip]

Where is the editbutton?

On the DIY cost calculator page, in the 'Cost to make a 30 ml bottle' area,
shouldn't that read
'Final E-juice @ 6mg'
instead of
'Final E-juice @ 6ml'
???

tolip

 

[The_janty_Misfit]

I.... I think I've got it.

By George! I think Iv'e got it. I found myself pounding away on that formula trying to figure it out and getting part of it (x+y)/2 and then slamming head first into the "mandoIsuckatmath" wall.

Thanks for the equation. I'll plug some numbers in and get nicked to the gills in your name!

 

[The_janty_Misfit]

Now, can anyone tell me how I get my juices sweeter to the taste? I'd love to know what on earth they do to RY4 so I could stop using it as the base for things I'm working on.

Thanks in advance.

 

[Scubabatdan]

Where is the editbutton?

On the DIY cost calculator page, in the 'Cost to make a 30 ml bottle' area,
shouldn't that read
'Final E-juice @ 6mg'
instead of
'Final E-Juice @ 6ml'
???

tolip

You are correct, good catch, I will fix it now.
Thanks!
Dan

Added:
It has been corrected and replaced.
Thanks again!

 

[Scubabatdan]

I.... I think I've got it.

By George! I think Iv'e got it. I found myself pounding away on that formula trying to figure it out and getting part of it (x+y)/2 and then slamming head first into the "mandoIsuckatmath" wall.

Thanks for the equation. I'll plug some numbers in and get nicked to the gills in your name!

Your welcome!

Now, can anyone tell me how I get my juices sweeter to the taste? I'd love to know what on earth they do to RY4 so I could stop using it as the base for things I'm working on.

Thanks in advance.

Try adding marshmallow I heard it sweetens juices up with out adding alot of flavor.
Dan

 

[Scubabatdan]

Hey everyone,
I have added a new sheet entitled "Additional Help with Mixing" This sheet contains how to make menthol drops from menthol crystals and how use tobacco absolute as well as using seedmans flavorings. I added links to the web sites for the materials you will need to make your own.
Hope this helps.
Dan

As always the download link is in my sig.

 

[Scubabatdan]

Ok I was bored so I added a button beside the recipe inprogress list. Once you are happy with the your final recipe, click the button and it will look for the first open line in the A column on the recipe sheet, it will then copy the name and all of the flavors and percents to the recipe sheet and prompt you to enter your name.

Here is the link to it:
ejuice calculator v8

I know a couple have asked for it so here it is. V7 will be available for a couple more days and then I will be changing my sig to reflect v8.
Dan

 

[Scottes]

Did you do this with an Excel macro, a Ooo macro, or somehow manage to get both to work on a single button???

 

[Scubabatdan]

Did you do this with an Excel macro, a Ooo macro, or somehow manage to get both to work on a single button???

I used a macro/vba, here is the code:

Sub AddRecipe()
'
' AddRecipe Macro
'
'
Dim cell
cell = 45

Repeat:
cell = cell + 1
cella = "A" & cell
cellc = "C" & cell
celld = "D" & cell
celle = "E" & cell
cellf = "F" & cell
cellg = "G" & cell
cellh = "H" & cell
celli = "I" & cell
cellj = "J" & cell
cellk = "K" & cell
celll = "L" & cell
cellm = "M" & cell
Sheets("Recipes").Select
Range(cella).Select

If IsEmpty(Range(cella).Value) Then
Sheets("Calculator").Select
Range("E35").Select
Selection.Copy
Sheets("Recipes").Select
Range(cella).Select
ActiveSheet.Paste

Sheets("Calculator").Select
Range("E37").Select
Selection.Copy
Sheets("Recipes").Select
Range(cellc).Select
ActiveSheet.Paste

Sheets("Calculator").Select
Range("I37").Copy
Sheets("Recipes").Select
Range(celld).PasteSpecial xlPasteValues

Sheets("Calculator").Select
Range("E38").Select
Selection.Copy
Sheets("Recipes").Select
Range(celle).Select
ActiveSheet.Paste

Sheets("Calculator").Select
Range("I38").Copy
Sheets("Recipes").Select
Range(cellf).PasteSpecial xlPasteValues

Sheets("Calculator").Select
Range("E39").Select
Selection.Copy
Sheets("Recipes").Select
Range(cellg).Select
ActiveSheet.Paste

Sheets("Calculator").Select
Range("I39").Copy
Sheets("Recipes").Select
Range(cellh).PasteSpecial xlPasteValues

Sheets("Calculator").Select
Range("E40").Select
Selection.Copy
Sheets("Recipes").Select
Range(celli).Select
ActiveSheet.Paste

Sheets("Calculator").Select
Range("I40").Copy
Sheets("Recipes").Select
Range(cellj).PasteSpecial xlPasteValues

Sheets("Calculator").Select
Range("E41").Select
Selection.Copy
Sheets("Recipes").Select
Range(cellk).Select
ActiveSheet.Paste

Sheets("Calculator").Select
Range("I41").Copy
Sheets("Recipes").Select
Range(celll).PasteSpecial xlPasteValues

Sheets("Recipes").Select
Range(cellm).Select

MsgBox "Enter your name in the highlighted contributers field and claim your recipe"

Else: GoTo Repeat

End If

End Sub

If you know a better way so the screen does not flip back and forth I would love to see it. I know there is, I was just lazy I guess hehehehe
Hey at least it works LOL
The hard part was getting the formulas to paste as values and not as formulas, but I figured that one out.
Dan

 

[Scottes]

If you know a better way so the screen does not flip back and forth I would love to see it.

Application.ScreenUpdating = False

will suppress screen activity. Set it back to True at the end.

 

[Scubabatdan]

Application.ScreenUpdating = False

will suppress screen activity. Set it back to True at the end.

Excellent!
Done, and updated.
Thanks Scottes!
Dan

 

[plinker704]

I have to say I absolutely love this calculator !!!!!

 

[VapoRize]

agreed its great!

 

[them0nk]

awesome work... i shot you a pm with an idea i had... that i think would be awesome...

putting something of a checklist in there on another tab to check off the flavors that someone has and see what recipes they could try...

 

[Scubabatdan]

awesome work... i shot you a pm with an idea i had... that i think would be awesome...

putting something of a checklist in there on another tab to check off the flavors that someone has and see what recipes they could try...

I got it, just have been swamped lately. That would work, or should I say it would be easiyer in a database format. But in a spread sheet enviroment it would be difficult at best to do. Unfortunantly I do not have the time to attempt it. If anyone else want to attempt it I will have a look and incorporate it if possible.
Great Idea though!
Dan

 

[ChuckDragon]

Thank you very much for this. I just started vaping 3 weeks ago and I am mixing my own juice. This makes it easy

 

[vapn]

Thanks again Dan... I have been using this almost every day for a while now... I would think that I would know how many drops of each to add by now but I still open this up to be sure.... Thanks for doing such a fine job of compiling all this information and then sharing with the world.... Awesome, Helpful, and User Friendly....

 

[them0nk]

I got it, just have been swamped lately. That would work, or should I say it would be easiyer in a database format. But in a spread sheet enviroment it would be difficult at best to do. Unfortunantly I do not have the time to attempt it. If anyone else want to attempt it I will have a look and incorporate it if possible.
Great Idea though!
Dan

i know that it would be a HUGE undertaking though, i'm pretty familiar with excel but i'm sure this idea is out of my league, at least done in a way that would be to the extreme i have in my head...

i'll think it over and see if there is a way i can add a column where the list of ingredients is, then add another sheet with the right functions to at least say "yes" or be blank to the field next to the recipe name...

 

[bockafer]

I'm currently working on a web app to duplicate the spread sheet functionality. Currently only have the basic functionality for mg mix down and % dilution and flavoring. Once I have time to get the other stuff in I'll start working on the ajax/db backend for recipes. After that it should be somewhat trivial to do a by recipe list by flavors.

It is quite ugly and basic (use at your own risk), but here you go: http://intelligent-junglist.com/pv/recipe.php

 

[bockafer]

Added flavor calculations. Just an FYI, I am not a web dev so bear with me. No validation, quite ugly, etc etc. Once I get all of the functionality working I'll see about making it look nicer. I'm also only testing this in FF at the moment.