Ejuice calculator (added quantity calculations)

[Scubabatdan]

Ok update,
with the addition of the recipe page, I find it a mute point to continue work on the "Recipe Data Base" as all the recipes can be contained in this one file that does it all. I have updated the V7 file with more recipes from my database and added a contributor field. There are now 38 recipes that use only unflavored nic juice and Lorann, Cappela or Bickford flavors. So download and enjoy! As always the download link is now in my sig line.

If you want to help me find recipes that are not on this list and add them to the recipe page, then shoot me the file in email, then I can cut and paste them, sort them and post the update.

Thanks everyone!
Dan

[Scottes]

Dan, I must have screwed up when I sent you the Ratios formulas spreadsheet. The formulas in E37 through E41 are wrong. If you change E8 to anything another than 10, the percentages do not total 100%.

E37 should be: =E37/(SUM(E37:E41))
E38 should be: =E38/(SUM(E37:E41))
E39 should be: =E39/(SUM(E37:E41))
E40 should be: =E40/(SUM(E37:E41))
E41 should be: =E41/(SUM(E37:E41))

[Scubabatdan]

Dan, I must have screwed up when I sent you the Ratios formulas spreadsheet. The formulas in E37 through E41 are wrong. If you change E8 to anything another than 10, the percentages do not total 100%.

E37 should be: =E37/(SUM(E37:E41))
E38 should be: =E38/(SUM(E37:E41))
E39 should be: =E39/(SUM(E37:E41))
E40 should be: =E40/(SUM(E37:E41))
E41 should be: =E41/(SUM(E37:E41))

E37 - E41 are manual entry cells??? in the current V7 and in the one you sent me E37 - E41 are the Flavor names???

PM me
Dan

[Scottes]

Oops.

In the current v7 linked in your sig:

H37 should be: =E37/(SUM(E37:E41))
H38 should be: =E38/(SUM(E37:E41))
H39 should be: =E39/(SUM(E37:E41))
H40 should be: =E40/(SUM(E37:E41))
H41 should be: =E41/(SUM(E37:E41))

[Scubabatdan]

Oops.

In the current v7 linked in your sig:

H37 should be: =E37/(SUM(E37:E41))
H38 should be: =E38/(SUM(E37:E41))
H39 should be: =E39/(SUM(E37:E41))
H40 should be: =E40/(SUM(E37:E41))
H41 should be: =E41/(SUM(E37:E41))

LOL Ok, Now I understand, it has been corrected! Thanks for keeping me in line
Dan

[Scottes]

Ok, Now I understand

It helps when I tell you the correct cell.

[Scubabatdan]

It helps when I tell you the correct cell.

Too true! I would like to add your second feature in the pull down manufactures list and flavor list, but we need to get it working correctly on the first page.
Dan

[Crankyfuzz]

I just wanted to say thank you for all the work you took the guess work out of mixing.

[Scottes]

Too true! I would like to add your second feature in the pull down manufactures list and flavor list, but we need to get it working correctly on the first page.
Dan

What's not working?? Wasn't it working when I gave it to you?


Anyway, you might want to hold off on that. I added Tasty Puffs, and I'm working on my version of saving recipes.

[brownbrown4]

I just wanted to say thank you for all the work you took the guess work out of mixing.

super ditto.
thanks A LOT Dan!!