Excel Based E-Liquid Calculator - With Cost Component

e-liquid calculator v4.2: View attachment 260894

Old versions:
e-liquid calculator v4.0: View attachment 260380
e-liquid calculator v3.0: View attachment 260895

v4.2 Changelog:
  • removed cell protection from flavor name cells.
  • added cost component to help calculate the cost of each bottle mixed
  • included some examples of a few of my favorite mixes. (see other tabs)

v4.0 Changelog:
  • added data validation rules to prevent errors in output cells
  • added cell protection to prevent errors in output cells (NOTE: to unprotect sheet, go to review tab and click the "unprotect sheet" button. No password required.)

I created this for several reasons:
1) I have several different nicotine bases which include various PG/VG ratios and nicotine mg levels. I wanted to use these up.
2) I wanted to mess with the flavors and nic mg percentages of liquids I've bought.
3) I wanted the ability to increase or decrease the nicotine mg content of batches I've already mixed or bought.
4) I wanted the ability to to increase or decrease the flavor % of batches I've already mixed or bought.
5) I wanted an excel version of a simple calculator that was easy to tweak.

Note: The "flavors" include a nicotine level option. These can be used with either no flavor as a secondary nicotine base, purely flavor, or a combination of the two.


All formulas are open source. Feel free to use and modify as desired.

If you can think of any improvements, I would love to hear them and add them.

Comments

Blog entry information

Author
Targaryen
Views
2,075
Comments
4
Last update

More entries in ECF Blogs