Scuba, one more question, in section 6, how do I add more manufacturers, I want to add Flavor West and Vaping Zone Flavors. I added a Flavor West flavor to the "Flavor List for Drop Downs" page but it doesn't show up in the manufacturers drop-down list in Section 6. Sorry for being such a pest but I really love the this spreadsheet and want to use it more with the flavors that I have. Thanks in advance.
I know this is a bit late, but it was never answered so here goes:
Instructions for adding your own flavors to the ejuice_calculator.
Program being used: Excel 2010
1. In the rows between 13-16 insert the name in one of the Empty4, Empty5, Empty6
2. In rows at the end of the page (currently Cell A1135) is where you add your flavors. Add your manfacture in column A, flavor in column B (note these cells you will need to know where they are), and Usage/Info in column C.
3. Now comes the fun part: While you're on the "Flavor Lists For Drop-Downs" tab, at the top of the program right below the name of your file click on the word "Formulas". You should see an icon in the list named "Name Manager". Click the icon and you should get a pop-up window called Name Manager. Look for one in the list that says "Manufactures" Select it and select the Edit... button. You need to change the cell range to include the additional cells that are not currently included by adding the cells. There are two ways this can be done either edit the end of the Referes to: line and change the last number to include one or more additional cell(s) by incrementing the number from 12 to 13(or more) or click the icon at the end of Refers to: to drag on the cells you want to include and hit enter. Click on the "New" button which will let you create a new Name Manager with the following information: Name = Manufacture, Scope = Workbook, What ever comments you want to add this is for you and will not be visible, Refers to = (the location in column B where your flavors are) $B$1135:$B$1136 or you can select the little graphic icon at the end of that line and it will allow you to select the range. Keep in mind it's pulling from column B, not A, and not C so do not highlight all of the cells just the ones in column B. Once you select the range hit enter and it will return you to the New Name window. Select OK. Then select close.
Now when you go to your PG or VG Calculator page you should be able to select your manufacture and your newly added flavors will be in their own drop-down from that manufacture. If you notice that something has happened and your selected manufacture has some other manufactures flavor name there, somehow that name manager for that manufacture is pulling from the incorrect location and with the above instructions you should be able to go in and edit the cells and correct this.
What if you have 100% base Nicotine? For example you want 70% PG/30% VG plus flavoring.
