Created an easy to use DIY ejuice calculator for everyone here to use

submitted almost 12 years ago by notremiss

I created this calculator using Microsoft Excel 2013. For anyone without Excel, I have also tested it on OpenOffice Calc and it works just as well.

Calculator features basic ejuice calculation, PG/VG ratio calculation, and calculation for multiple flavors. I have checked and rechecked the math and it has proven to give accurate measurements.

User inserted values are marked in a black border while calculated measurements are highlighted yellow. There are notes next to cells to help better understand how they work.

Hope you guys like this and any feedback would be greatly appreciated.

Google Drive link to calculator

Edit: I thought of a new feature that for each of the flavoring name cell there is a drop down list with all TFA flavors. If I missed any, let me know. I also plan on doing the same for Capella and FlavorArt sometime soon.

Calculator with TFA flavor addition

Comments

2 points

by HempsterGenesalmost 12 years ago

Thank you for sharing this!

2 points

by notremissalmost 12 years ago

You're welcome, I made this in mind for everyone to use. My idea is that using readily available software, we can easily make recipe books for ourselves and also to share with others.

0 points

by zengargoylealmost 12 years ago

I have an almost completely opposite take on the same general idea - readily available software, easy to share, recipes useable with or without the software. It's vaper-tools. There are some examples from the Juice Talk show here like the evidently tasty Fuzzy Custard. It has output plugins for a couple of text formats and a nice-ish HTML page, and it can also read/write eJuice Me Up files.

There's also a quickmix frontend for off the cuff usage:

$ quickmix n 'Fuzzy Custard' f 'Vanilla Custard (TFA)' 13 \
  f 'Juicy Peach (TFA)' 3 f 'Butterscotch' 1 nic 13 100 pg 50 vg 50 \
  r vg 30 pg 100 s 10

.-----------------------------------------------.
|      Fuzzy Custard 13 mg/ml (70/30 PG/VG)     |
+--------------------------------+------+-------+
| Flavor                         |   ml | Total |
+--------------------------------+------+-------+
| PG                             | 4.65 |  4.65 |
+--------------------------------+------+-------+
| VG                             | 2.35 |  7.00 |
+--------------------------------+------+-------+
| 100 mg/ml Nicotine 50/50 PG/VG | 1.30 |  8.30 |
+--------------------------------+------+-------+
| Vanilla Custard (TFA) PG       | 1.30 |  9.60 |
+--------------------------------+------+-------+
| Juicy Peach (TFA) PG           | 0.30 |  9.90 |
+--------------------------------+------+-------+
| Butterscotch PG                | 0.10 | 10.00 |
'--------------------------------+------+-------'

Sadly there's a new juice calculator / recipe website / whatnot of some sort almost every week and none seem to gain a lot of traction. :(

1 points

by onions_can_be_sweetalmost 12 years agoMixologist

Thank you for doing an OpenOffice version!

Edit: Tested it just now in OpenOffice 3.x. Seems to work well.

2 points

by notremissalmost 12 years ago

Glad to hear that it is working. If you have any questions, comments, or recommendations for other features, let me know.

1 points

by onions_can_be_sweetalmost 12 years agoMixologist

I know drops are frowned upon... but for quick mixes and experiments, they are sometimes handy. Could you add a column which does a ml/drops conversion, and have one drops/ml calibration entry (example: 30 drops/ml)?

2 points

by notremissalmost 12 years ago

I added a drops column as well as a drops/ml calibration. It is now under the same link as the last file.

Also, this goes without saying but be careful with drops, especially with high nicotine concentrations.

1 points

by accidental_snotalmost 12 years ago

Thanks, Bro.