As the title says, I made an excel sheet that you can edit to calculate your recipes by weight for you. All you have to do is enter your desired total volume, your desired nicotine content, the strength of nicotine that you are using, the names of the flavours you're using, and the percentages of each of these ingredients, and it gives you the amounts of each ingredient in both ml and g.
This is particularly useful for me, as I constantly make different size batches of existing recipes. With this spreadsheet, if I want to make 50ml instead of 10, all I have to do is alter the total volume
Right now it only gives accurate g readings for TFA flavours (as that was the only information available), but if you know the g/ml of a specific flavour you can add it to the database (sheet 2) and it should read fine.
As well as this, if the flavour name you enter doesn't match a flavour name in the database it just assumes that the flavour weighs 1g/ml.
Here it is! I wasn't sure where to host the file, so if anyone has a suggestion for something more reputable than filetea just let me know and I can throw it up there.
https://filetea.me/t1sSuQAfAM7Sf2p7pm3uxupFg
Edit: Looks like the filetea link isn't working, so here it is on google drive! https://drive.google.com/file/d/0B4rgNLAO2na0WEtiOXhUVXp4UGc/view?pli=1
Edit2: /r/excel helped me out a bunch with this too, so hats off to those guys.
I currently use the Liquix calc for Android but downloaded yours out of curiosity. The first thing I noticed was the pg/vg ratio did not calculate correctly. Tried 30/70 and vice versa but the result was always 50%. Maybe I'm doing something wrong. I dunno.
Oh right, I should have mentioned! The VG/PG ratio is something you have to adjust yourself, I just added it in for the sake of documentation so that I know which recipes are which ratios.
On second thoughts though, the way I have it set up won't give you a proper % of PG... I usually mix max VG, so the VG % line autocalculates by adding together all of the other ingredients and subtracting the result from 100%...
This means that if you want to make say, 50/50 juice, you have to add all of the % for your flavors, and then manually adjust the PG so that you see 50% VG.
I'll have to make a proper VG/PG ratio cell once I get the time, thanks for pointing that out.