Hi all, I've made a simple but informative e-calculator, here's what my spreadsheet will do after you enter a few bits of information....
INFORMATION GIVEN
Recipe
Like all e-liquid calculators you will be told exactly how many mls or drops you need to use to achieve the strength and flavour you have selected.
Ingredients
Not many e-liquid calculators tell you this, the exact quantities of individual chemicals in your liquid. The maths and formulas I have used take advantage of the densities and proportions of each ingredient within your recipe (i.e in your recipe the base nicotine is one liquid but it is made up of pure nicotine and either VG, PG or PEG. If you use 40% Vodka then it is one ingredient in your recipe list but in the ingredients section of the spreadsheet the ethanol (alcohol) is separated out and the other 60% goes down as water) so you know exactly what is in your e-liquid by individual chemical.
It is not perfect, firstly with the alcohol example, the 60% of a 40% Vodka that isn't ethanol won't be pure water which it is counted as in the ingredients list as there would be trace elements of flavourings (especially if you used Gin instead of Vodka) and secondly the ingredients of the flavourings aren't listed as, obviously, every flavour from every manufacturer has different ingredients and quantities thereof.
Density
Another useful stat is the density (or thickness) of the proposed juice. Pure VG which is generally regarded as too thick to vape (hence why vendors that sell it always water it down first) has a density of 1.261 g/cc (which means there are 1261 milligrams in 1ml of liquid) whereas water has a density of 1 g/cc (or 1000 milligrams in 1ml). This calculator will add every element of your liquid up using the density of each on to give you a total density for your eliquid and a text description of it's thickness so you know when you'll need to water down (or thicken up) before you make your liquid.
HOW TO INPUT
Yellow Cells = Input your information into these.
Blue Cells = Contain Formulas, do not overtype in these cells. Two of these (Flavour 1 and PG &) appear, logically, to be editable input cells but are there to help ensure the total flavours/base liquid add up to 100%, so if you are only using PG as your base then simply make sure the VG and PEG-400 boxes have 0 in them.
Quantities
Simply enter the amount of liquid you want to make and also how many drops are equal to 1 ml if you plan on using a dropper.
Nicotine Base
Enter the strenth of the eLiquid you want to create (in milligrams), the strength of the base nicotine solution you are using (in milligrams) and the type of base liquid you are using (PG, VG or PEG-400 based).
Thinners
If you are using water and/or alcohol to thin your juice or improve throat hit with ethanol then enter the ABV% of the alcohol (half the Proof if your in the US) and what percentage of the total eLiquid you want the alcoholic liquid to make up, do the same for any water you are adding/
Flavouring
Firstly input the total percentage you want all the flavouring you use to make up in the total eLiquid(In some cases this may be as low as 5% and in others as high as 30%), and then use the boxes below to mix up the flavours if you are using more than one. You can mix up to 6 flavours but remember that the total of them all must equal 100%.
Base Liquid
If you are using any VG then firstly input it's purity %; if you buy VG from e-liquid vendors such as Totally Wicked or Liberty Flights for example you will probably have a "aqueous glycerin" that is a pure glycerin watered down for mixing. This is usually in a 90/10 or 85/15 ratio and will state on the bottle. Then simply choose your ratio of PG,VG and PEG-400 for the rest of you base; like above the total must be 100%.
Physical Properties
These are the density levels of the chemicals involved with e-liquid manufacturer. You shouldn't have to change these ever unless the scientific nature of them changes (eek!).
And that's it!
This is v1 of the sheet and there probably won't be a v2 as I'm now building a program version using my computer programming skills. I just wanted to get the basic maths down in excel first. In my application version I will give users the ability to print ingredient stickers off and use "stock control" so you can plan your recipes as well as to ability to save recipes for future reference.
Anyway hope this helps people and that my program sounds even more useful
download .xls
http://www.sendspace.com/file/7asgko
INFORMATION GIVEN
Recipe
Like all e-liquid calculators you will be told exactly how many mls or drops you need to use to achieve the strength and flavour you have selected.
Ingredients
Not many e-liquid calculators tell you this, the exact quantities of individual chemicals in your liquid. The maths and formulas I have used take advantage of the densities and proportions of each ingredient within your recipe (i.e in your recipe the base nicotine is one liquid but it is made up of pure nicotine and either VG, PG or PEG. If you use 40% Vodka then it is one ingredient in your recipe list but in the ingredients section of the spreadsheet the ethanol (alcohol) is separated out and the other 60% goes down as water) so you know exactly what is in your e-liquid by individual chemical.
It is not perfect, firstly with the alcohol example, the 60% of a 40% Vodka that isn't ethanol won't be pure water which it is counted as in the ingredients list as there would be trace elements of flavourings (especially if you used Gin instead of Vodka) and secondly the ingredients of the flavourings aren't listed as, obviously, every flavour from every manufacturer has different ingredients and quantities thereof.
Density
Another useful stat is the density (or thickness) of the proposed juice. Pure VG which is generally regarded as too thick to vape (hence why vendors that sell it always water it down first) has a density of 1.261 g/cc (which means there are 1261 milligrams in 1ml of liquid) whereas water has a density of 1 g/cc (or 1000 milligrams in 1ml). This calculator will add every element of your liquid up using the density of each on to give you a total density for your eliquid and a text description of it's thickness so you know when you'll need to water down (or thicken up) before you make your liquid.
HOW TO INPUT
Yellow Cells = Input your information into these.
Blue Cells = Contain Formulas, do not overtype in these cells. Two of these (Flavour 1 and PG &) appear, logically, to be editable input cells but are there to help ensure the total flavours/base liquid add up to 100%, so if you are only using PG as your base then simply make sure the VG and PEG-400 boxes have 0 in them.
Quantities
Simply enter the amount of liquid you want to make and also how many drops are equal to 1 ml if you plan on using a dropper.
Nicotine Base
Enter the strenth of the eLiquid you want to create (in milligrams), the strength of the base nicotine solution you are using (in milligrams) and the type of base liquid you are using (PG, VG or PEG-400 based).
Thinners
If you are using water and/or alcohol to thin your juice or improve throat hit with ethanol then enter the ABV% of the alcohol (half the Proof if your in the US) and what percentage of the total eLiquid you want the alcoholic liquid to make up, do the same for any water you are adding/
Flavouring
Firstly input the total percentage you want all the flavouring you use to make up in the total eLiquid(In some cases this may be as low as 5% and in others as high as 30%), and then use the boxes below to mix up the flavours if you are using more than one. You can mix up to 6 flavours but remember that the total of them all must equal 100%.
Base Liquid
If you are using any VG then firstly input it's purity %; if you buy VG from e-liquid vendors such as Totally Wicked or Liberty Flights for example you will probably have a "aqueous glycerin" that is a pure glycerin watered down for mixing. This is usually in a 90/10 or 85/15 ratio and will state on the bottle. Then simply choose your ratio of PG,VG and PEG-400 for the rest of you base; like above the total must be 100%.
Physical Properties
These are the density levels of the chemicals involved with e-liquid manufacturer. You shouldn't have to change these ever unless the scientific nature of them changes (eek!).
And that's it!
This is v1 of the sheet and there probably won't be a v2 as I'm now building a program version using my computer programming skills. I just wanted to get the basic maths down in excel first. In my application version I will give users the ability to print ingredient stickers off and use "stock control" so you can plan your recipes as well as to ability to save recipes for future reference.
Anyway hope this helps people and that my program sounds even more useful
download .xls
http://www.sendspace.com/file/7asgko
Last edited:
