I've been using a Numbers spreadsheet on my Mac to organize my recipes and mix them up for some time. It automatically calculates amounts for mixing by weight or by volume, and it's been quite helpful for me.
I figured there are other Mac users who could use this, so I made some adjustments, allowing you to globally set your nicotine base strength, mixed nicotine strength, VG/PG ratio, and batch size, and have it automatically applied to every recipe.
I'm releasing it under the Creative Commons Attribution-NonCommercial-Sharealike 4.0 (CC BY-NC-SA 4.0) license, so you're free to use and modify it in any way for your own personal use.
It's in a GitHub repository. Instructions are in both the README file on GitHub, as well as the "Instructions" sheet inside the spreadsheet itself. Or you can just use this direct link to download the most recent version. A few sample recipes are included so you can see how it works.
If you have any questions, suggestions, or have found any bugs or errors, please let me know.
Good initiative!
However - "404 page not found" :(
Have been simultaneously dreading and excitedly anticipating the impending drying up of my pre-made e-juice rations and I have to finally dive into the realm of DIY, but this may prove to give me a huge edge! Whether I end up utilizing it or not, huge thank you for both the time and effort that went into this!
This is exactly why I decided to release this. I had been meaning to make the changes needed for a public release for some time, but with the current situation, many more people are starting to mix their own juice. So I figured now would be when it is most helpful to the largest number of people.
And there's nothing to dread or be scared about. Yes, you will buy flavors which sit unused. Yes, you will make a lot of juice that is just straight garbage. But even throwing away 75% of what you make, it's still cheaper than buying most commercial juice. If you vape with a high nicotine concentration, then when you are developing a recipe, mix it with zero nic, because in that case, nicotine is the single most expensive ingredient of a batch.
And don't bother with mixing by volume. It's slower, messier, and more difficult than mixing by weight. Just get an AWS LB-501 scale. And buy lots of bottles, plastics are fine for the vast majority of flavors and recipes.
I was very scared of mixing my own ejuice too. Finally after buying my fourth juice in a row that I felt was just trash I was ready to try it. That's besides the drawer full off disappointing ejuices I'd already bought over the year. Mixing by weight is very easy. The diy mixing community is very helpful and very welcoming. They answer every question you could have. Have any of my ejuices been masterpieces? Nope. Have any of them been trash? Nope. I learn from each one what I like and dislike. I vape them all. At around $0.65 a bottle for a mediocre ejuice I'm still better off than when I was paying $15-$20 a bottle for disappointing "premium" juice.
This is great. And super generous of you. Many thanks. 👍✌️
Thanks, man. I mix pretty infrequently (~once a month) and I’m always scared that I’ll try to log in to e-liquid-recipes and it will be shut off/abandoned. Having an at-home resource and catalog will be a life savor if that day ever does come.
Edit: I did just realize that there's no way to change the PG/VG percentage of the base nic solution. I usually buy 50/50 nic since I primarily mix for pod devices (makes it easier than mixing mass amounts of highly viscous VG in the total blend). Maybe consider adding that as an option in a future release?
If this was a web app or MacOS app, this would be a trivial addition, but for a Numbers spreadsheet, it is going to be pretty complicated to add this in. I'll take a look and see if it is feasible.
In the meantime, you can get around this by setting the proper density for your 50/50 nic base (should be around 1.15 g/mL for 100 mg/mL base) in the "Ingredient Densities" table, and subtracting half of the percentage of the "Mixed Nicotine Strength" from the "Mixed VG Percentage" setting. This is assuming you are using 100 mg/mL nicotine base. If not, then use: 100 / (base nicotine strength in mg/mL) * (mixed nicotine strength in mg/mL) * 0.5 to get the value to subtract from the "Mixed VG Percentage" setting.
Examples, with juice mixed at 3 mg/mL nicotine and 70% VG:
100 mg/mL nicotine base: Enter in 68.5% for "Mixed VG Percentage". 70 - (3 * 0.5).
48 mg/mL nicotine base: Enter in 66.9% for "Mixed VG Percentage". 70 - (100 / 48 * 3 * 0.5)
In both of those examples, you'll get the calculations for 70% VG, since half of the percentage of the nic base in the mix (the amount of VG in the amount of the 50/50 nic base you are using) is being subtracted from the VG calculation to compensate.