Ssscrudddy
Postman
- Joined
- Nov 3, 2012
- Messages
- 750
Every mixing calculator I have found so far has been a pain in the arse to use. When I want to mix I want to know how many ml of each ingredient I am putting in. I dont want to be swapping betweeen drops & percents & ml etc. So I wrote my own spreadsheet
You fill in the strength of the nic base (cell A2), & then play around with the ratios of the other ingredients (row 5 cells B to G).
Once you have got the ratios to your satisfaction there is another area (rows 9 to 15) where you can fill in your desired target.
eg you want to make 30 ml of juice so you fill that in & it gives you the amount you need of the other ingredients (based on your original ratios).
Or Maybe you only have x amount of nic left, so you fill that in (instead) & it gives you the amount you need of the other ingredients (based on your original ratios).
Or perhaps you only have y amount of your favourite flavouring left, so you fill that in & it gives you the amount of the other ingredients (based on your original ratios)
You can tweak your ratios, you can make a note of your end result to be used again next time.
You cant accidently wipe out any of the formulae (unless you unlock the sheet).
There are 2 pages, 1 for PG based nic, & the other for VG based nic (results shows you the different % of each ingredient)
You can add 3 different flavours in the same mix, you can have PG & VG in the same mix.
You type your values into the yellow cells. I have some values filled in, purely as a bit of an example of how to use the sheet (you can happily delete all of the entries in the yellow cells, nothing bad will happen)
Starting at line 18 is where you would make your notes, these aren't used in any calculations (you can happily delete what I have filled in here again it's just for an example)
The spreadsheet was made using Open Office, so it is in .ods format, & you can downlad it & save to your PC at the following link
https://dl.dropboxusercontent.com/u/79154525/Vape mixing.ods
Here is a screen shot
You fill in the strength of the nic base (cell A2), & then play around with the ratios of the other ingredients (row 5 cells B to G).
Once you have got the ratios to your satisfaction there is another area (rows 9 to 15) where you can fill in your desired target.
eg you want to make 30 ml of juice so you fill that in & it gives you the amount you need of the other ingredients (based on your original ratios).
Or Maybe you only have x amount of nic left, so you fill that in (instead) & it gives you the amount you need of the other ingredients (based on your original ratios).
Or perhaps you only have y amount of your favourite flavouring left, so you fill that in & it gives you the amount of the other ingredients (based on your original ratios)
You can tweak your ratios, you can make a note of your end result to be used again next time.
You cant accidently wipe out any of the formulae (unless you unlock the sheet).
There are 2 pages, 1 for PG based nic, & the other for VG based nic (results shows you the different % of each ingredient)
You can add 3 different flavours in the same mix, you can have PG & VG in the same mix.
You type your values into the yellow cells. I have some values filled in, purely as a bit of an example of how to use the sheet (you can happily delete all of the entries in the yellow cells, nothing bad will happen)
Starting at line 18 is where you would make your notes, these aren't used in any calculations (you can happily delete what I have filled in here again it's just for an example)
The spreadsheet was made using Open Office, so it is in .ods format, & you can downlad it & save to your PC at the following link
https://dl.dropboxusercontent.com/u/79154525/Vape mixing.ods
Here is a screen shot
