Ejuice calculator (added quantity calculations)

Status
Not open for further replies.

Dusty Colvard

Unresolved Status
Jan 12, 2016
0
0
48
  • Deleted by retired1
  • Reason: Unregistered Supplier

JimScotty0

Super Member
ECF Veteran
Verified Member
Feb 10, 2014
961
1,258
Garden Grove, CA, USA
www.facebook.com
got some questions
how can I find out which version I got ?
download the newest version ..will that update or do I have to remove the older version first ?
which version is the one with mg weight calculation?
would like to try that mixing with a small digital scale .
otherwise PERFECT.
On the help just select Help, About and it will state the version.
 

JimScotty0

Super Member
ECF Veteran
Verified Member
Feb 10, 2014
961
1,258
Garden Grove, CA, USA
www.facebook.com
thanks jimscotty
my program does not show anything for help .
it has grams colum in there but shows all zeros !
it did not calculate in that collum .
like to download the newest version ..is it nessesary to remove the older version first ?
Sorry @rolf wrong program I was commenting on.
 

Scubabatdan

Vaping Master
ECF Veteran
Verified Member
Jul 14, 2009
4,749
6,733
60
Dothan, AL
thanks jimscotty
my program does not show anything for help .
it has grams colum in there but shows all zeros !
it did not calculate in that collum .
like to download the newest version ..is it nessesary to remove the older version first ?

Not necessary to remove, as the file names are different. V14 is the latest.
Just click the link in my signature.
Dan
 

Sugar_and_Spice

ECF Guru
ECF Veteran
Verified Member
Sep 11, 2010
13,663
35,223
between here and there
Hey Dan,
I have noticed you have Bickford flavoring incorporated in your program. Have or do you use these products or are they a left over from before the explosion of the ejuice industry and the developments of finding out about some potential harmful ingredients?

Btw, I have been using your calculator since forever. Thank you. You save me from confusing myself with all the calculations to be done.
tia
:)
 

Mackan1

Senior Member
May 27, 2016
85
126
Scotland, UK
Hello Could you make a sheet with Ingredient/Flavor with 8 slots.

I have managed to add the extra flavors in in VG/PG Calculator and on the Recipes but cannot get the button "Click here to add your recipe to recipe sheet" to work. as when i get to colon N (% of Ingredient 6 (colon M) does not pull the information over to the Recipes tab.
also when i do Colom O (Ingredient 7) i get a de-bug error. that reads " Run-time error "1004" Method Range of object ' _Global" Failed"


Sheets("VG Calculator").Select
Range("K14").Select
Selection.Copy
Sheets("Recipes").Select
Range(Cellm).Select
ActiveSheet.Paste

Sheets("VG Calculator").Select
Range("P14").Copy
Sheets("Recipes").Select
Range(celln).PasteSpecial xlPasteValues

Sheets("VG Calculator").Select
Range("K15").Select
Selection.Copy
Sheets("Recipes").Select
Range(Cello).Select
ActiveSheet.Paste

Sheets("VG Calculator").Select
Range("P15").Copy
Sheets("Recipes").Select
Range(cellp).PasteSpecial xlPasteValues




If i fill in the recipes in the recipes tab and pull it up in the VG/PG page it works and shows all.
 
Last edited:

Mackan1

Senior Member
May 27, 2016
85
126
Scotland, UK
Thought I would give an update, Managed to get it all up and working. Apart from the Contributed by(original column M (i think)). I can move it around columns (E.G Column M,N,O,P,Q,R and T) but cannot get it to show in Columns "S"
comes up with an error message saying
"run time error '1004'
the cell or chart you're to change is on a protected sheet."
Even with the PG/VG Calculator + Recipes pages unprotected.
 

Scubabatdan

Vaping Master
ECF Veteran
Verified Member
Jul 14, 2009
4,749
6,733
60
Dothan, AL
Thought I would give an update, Managed to get it all up and working. Apart from the Contributed by(original column M (i think)). I can move it around columns (E.G Column M,N,O,P,Q,R and T) but cannot get it to show in Columns "S"
comes up with an error message saying
"run time error '1004'
the cell or chart you're to change is on a protected sheet."
Even with the PG/VG Calculator + Recipes pages unprotected.

Sorry been away awhile, will add for up to 8ish [emoji1360]
 
  • Like
Reactions: Teach

Scubabatdan

Vaping Master
ECF Veteran
Verified Member
Jul 14, 2009
4,749
6,733
60
Dothan, AL
Scubabatdan its been a good while since i came to forum but i remember you from back then when your tank came out and there was a long thread about it.
Great to see you and hope things are going well these days.

Like a world away, so long ago. LOL
Well I have updated v14 to v14a, it now includes the ability to add 10 flavors per recipe.
Just click the link below.
Enjoy.
Dan
 

Scubabatdan

Vaping Master
ECF Veteran
Verified Member
Jul 14, 2009
4,749
6,733
60
Dothan, AL
Ok, had a suggestion to update the DIY Cost Calculator page to today's usage. While I was at it, I added in a user defined field so you can define your own mg number to see how much it would cost you to make at your defined nic level. v14b Enjoy. Same link in my signature.
Dan
 

Tommy-Chi

Ultra Member
Supporting Member
ECF Veteran
    Ok, had a suggestion to update the DIY Cost Calculator page to today's usage. While I was at it, I added in a user defined field so you can define your own mg number to see how much it would cost you to make at your defined nic level. v14b Enjoy. Same link in my signature.
    Dan

    First time that I have download your xls spreadsheet application.

    Very comprehensive. Going to take a few days to look over it.

    I'm on the most recent version (1607) of Win 10 Pro using LibreOffice 5.2 and everything looks like it works fine.

    Thank you for the effort!
     
    • Like
    Reactions: Scubabatdan
    Status
    Not open for further replies.

    Users who are viewing this thread