Simple calculator - feedback

[Switched]

Hi folks,

With 119 downloads of My simple DIY Calculator (link in signature below) I would of thought more feedback would have been provided

 

[Orion]

I just downloaded it this morning, I'm getting a shipment of PA in today, so I'll give it some real use then and give some feedback.

 

[Switched]

Cool, any problems please post. I will be creating a tutorial... for it for download as well.

 

[Orion]

Sorry for the delay in feedback. I ended up being busier than I had anticipated.

But I tried the calculator, and here are my findings:

It does exactly what it says it does. It's a stripped down simplified calculator that shows ml, drops & % conversions, perfect for those who need it broken down that way.

I am math dumb and I figured it out So that has to be good right?

 

[Orion]

I should add that I may have used it at an unfair advantage because I have my formulas for my basic 10ml blueberry cinnamon recipe memorized, but I will play around with it further and see. Maybe plug in some other people recipes and see...but I'm pretty sure I'll still be able to use it ,lol.

 

[Nikhil]

Your Q13 calculation for distilled water doesn't take into account the calculations you did in columns G through P.

 

[rtbob]

Yours is my second favorite juice program.

I guess I'm old fashioned. While your program is much less intimidating and has a much shorter learning curve than another more "famous" one out there, I do my calculations with a calculator and write my receipes in a spiral notebook.

Some time ago their was an actual program written for windows that was posted on ECF that I have and it works great. I'm at work now so I can't tell you the name of it. I think it was "Easy E-juice." It is very simple and is not a spread sheet but an actual computer program. It would be my favorite. If interested in looking at it let me know and I'll email it to ya.

Thank you for the great, pretty easy to use program!

 

[Switched]

Yep, you are right. That's why G--->O are hidden, as they would only clutter the sheet.

That being said If you wish not to have simple calc to ratio H2O and PGA for you change the formula in Q13 to read G13+J13+M13 and the formula in R13 to H13+K13+N13

With the aforementioned changes all inputs will hence be automatic. e.g you can enter the exact amount of VG, H2O or PGA that you wish, in either %, ml or drops. (remember only one value per line.

Hope that helps

 

[Switched]

Yours is my second favorite juice program.

I guess I'm old fashioned. While your program is much less intimidating and has a much shorter learning curve than another more "famous" one out there, I do my calculations with a calculator and write my receipes in a spiral notebook.

Some time ago their was an actual program written for windows that was posted on ECF that I have and it works great. I'm at work now so I can't tell you the name of it. I think it was "Easy E-Juice." It is very simple and is not a spread sheet but an actual computer program. It would be my favorite. If interested in looking at it let me know and I'll email it to ya.

Thank you for the great, pretty easy to use program!

Thanks. Yes I have that one and it is a Access data base. I plan on heading there with this. Easy juice had the same problem most of them have in that: you could only input "givens" IIRC, and whole numbers.

Simple Calc allows us to enter any value from someone's recipe. I have seen some that have all 3 values. It gets confusing. But with simple calc providing you only enter one value per line (%, ml or drops) it does the converstion for you. Once the recipe created, you can always check the final percentages in column S and use those % to enter future data for that recipe.

I appreciate the feedback, as long as folks wish to maintain it "simple" all ideas will be given due consideration for future versions, to include but not limited to a database type calculator.

 

[Switched]

VP what would you like to see?

 

[Nikhil]

I was thinking it should say Q13*0.2+G13+J13+M13 so that you could manually add to it in case you are using VG nicotine. Not sure if I'm VP or not, though .

 

[Switched]

I was thinking it should say Q13*0.2+G13+J13+M13 so that you could manually add to it in case you are using VG nicotine. Not sure if I'm VP or not, though .

Let me think about that.

 

[Switched]

Sorry for the long delay, I was headed out to dinner last night. I have given it some thought and can't fathom why you would want to do it that way? What are you trying to accomplish? I understand you are using straight VG, by changing the formula back to (non auto) as I posted will allow you to manipulate your own ratios

 

[Nikhil]

Maybe my formula was wrong, I just took a cursory glance at the calculation columns. What I wanted was to let people do the automatic if they only use the no-nic VG, but if they wanted to manually add Water they could do that instead, and if they used both no-nic and nic VG it would auto-calc for the no-nic and still allow you to add water manually for the nic VG into the ml/drops columns.

 

[Switched]

PV,

I am sort of following you. In order to better see where you are headed can you post a simple recipe for me to see where you are going? I use PG nic so that is not a problem for folks that use PG nic, as the consensus from what I have gathered to date was a H2O dilution of 20% for VG added, and hence why the formula.

Not knowing the viscosity of the nic VG is the one that has me puzzled. I have played this morning with an auto formula (similar to where your heading) that would dilute all VG to 20% including the nic liquid, but then again that would not be accurate because the nic liquid is already reduced in viscosity by X% because of the nic.

Are we making progress?

 

[Nikhil]

If you really want to compensate for the nicotine reducing viscosity, it has about the same density as water. You could use the mg/ml to calculate % of the nic VG that is, for dilution purposes, already 'water' and then subtract that from the 20% calculation. For example, 100mg/ml VG is 90% VG and 10% nicotine, so for a 20% dilution of 5ml of it, you'd already have .5ml nicotine and 4.5ml VG, and you'd need 4.5x0.2-.5 ml of extra water (0.4ml).

 

[Scubabatdan]

PV,

I am sort of following you. In order to better see where you are headed can you post a simple recipe for me to see where you are going? I use PG nic so that is not a problem for folks that use PG nic, as the consensus from what I have gathered to date was a H2O dilution of 20% for VG added, and hence why the formula.

Not knowing the viscosity of the nic VG is the one that has me puzzled. I have played this morning with an auto formula (similar to where your heading) that would dilute all VG to 20% including the nic liquid, but then again that would not be accurate because the nic liquid is already reduced in viscosity by X% because of the nic.

Are we making progress?

The additional problem is not all VG is the same viscosity, some is thicker than others. A static .2 in you formula should be removed and let the user decide on the % of water based on the VG if used. Some people have told me their PG mixes are thicker and would like to figure in water too. So currently your formulas does not afford a person the ability to do that. That is why I went to a seperate sheets, one for PG, one for VG and one for no-nic PG/VG. I have been where you are and it is a pain when you want to add 10% water but can't because the program wont let you.
Just my observation but IF statements would allow you to calculate off the VG being used or not.
Dan

 

[Nikhil]

Yeah, I said the same thing as Dan in the initial thread, to let people manually enter either at what % they want to dilute with water or just let them put in the water % of the final solution manually. Just noticed it was a different thread.

 

[Switched]

New calculator has been created, for all users. Just check the tabs on the bottom for PG or VG. The PG calc still defaults, the VG required manual input of everything. The VG tab can be used by all users that do not wish auto dilution.

This is a win win situation, because it still keeps the calc relatively simple. Hope you enjoy the new and improved V2.

Simple Calc V2

 

[tazzmann]

Hey switched, I like the calculator, though I am pre-mixing my VG/PG, so don't really need the calculator at this point since I don't use any nic juice either. Pretty nice though!

tazz