Omg I super misunderstood your first comment, I'm sorry about that!

Ah I totally see what your saying, everyone just rounds because why bother, the differences are rather minimal of course.

I guess I'm just weird like that then lol, I prefer to be precise. I'm a passionate chemist so that kind of stuff is routine for me anyway

>How many recipes have you followed where the creator revealed the SG of the individual flavors?

This is automatic an ATF and ELR. The recipe usually starts with % and the calculator figures out ml and g. SG is embedded with each flavor. The few flavors that are listed 1:1 are ones where they don't know the SG.

good advice certainly, I truly intended this post strictly for people like me mixing by density, to use a reference for their flavours, since its really hard to find elsewhere and even their MSDS are hit and miss for density (many say "not available" under density/specific gravity)

I liked it lol. Been mixing way too long, unfortunately the Canadian government pretty much crippled my life saving hobby. I deleted my other comment because i didn’t want to argue with strangers on the internet and get shit on your post. Every bit helps imo.

If they are recommending FA Honey to be used at 5% in juice.....no. Just no

Interesting. I didn't realize it was common to just round the density for every flavour. Ive never really used inline calculators, AFT/ELR just for recipes and percentage data. Only ever saw that ELR sometimes has the density in a flavours notes but often it is missing.

Anyway, im the type of person that enjoys making a spread sheet and referencing data I found, verifying the results on my own, etc.

Sure it might be the hard way but I get bored if things are too easy sometimes. I derive satisfaction from having my own spreadsheet running smooth.

Edit: thought of another thing, what if you accidentally over pour? In my sheet its trivial to update how much I actually dispensed and the cumulative weight for each addition after that is updated automatically. Unless your using a calculator manually to add the weights you need to dispense, as your mixing? Or you tare the scale after each addition?

Alright, here it is, let me know if you have any questions:

https://docs.google.com/spreadsheets/d/1ZNeQFaXq5_-3I9axn7Jghi5DJvTLqVoN5cbPkhD7aZQ/edit?usp=sharing

I almost always use that colour scheme so my sheets are easier on the eyes at night, but I use excel with a dark theme, apparently it doesnt work too well with google docs it appears... I will share a link to the original excel file too:

https://drive.google.com/file/d/1oOFooV3SaqQ0UbjzHOvIccYN35DfmUKv/view?usp=sharing

Some tips:

On the left is a list of flavours with corresponding densities and percentage data gathered from ELR, on the right is the actual mix calculator.

in the other tab, there are two lists of flavours with densities that others have posted to reddit, one for TPA and one for CAP, I just keep it there for reference as its easier than looking up flavours.

I do not vape nicotine anymore, strictly for flavour, so unfortunately it doesnt include a nicotine calculator, but if anyone will really use this I would be happy to add it in because its pretty simple to be honest.

When you want to mix:

First make sure the flavours you want to use in the recipe and their corresponding densities are in the table on the left (in the calculator tab). You may want to take note of what row each one is in (eg cap super sweet is row 6, cap yellow peach is row 18) the column does not matter though. *see below

In the calculator, input the total volume you want to mix under final volume, and the vg percentage you want in your final mix.

Input the flavour names and the percentage of each you want in the recipe, and the volume of each is calculated already in the 'mL to add' column. Since were mixing by weight though its irrelevant.

You will notice the weight of each flavour needed has been calculated already, in the 'g to add' column, but it is using the wrong densities and should be ignored until updated (if your super precise/anal like me haha).

Heres where the row numbers you noted from earlier come into play. For each flavour in the recipe, under the 'g to add' column, you must edit the last digit or two digits of the formula. Its easier than it sounds, especially if your armed with a list of the row numbers already as I advised.

• Simply click the cell in the 'g to add' column for the first flavour
• press F2 on your keyboard to edit the formula
• press backspace once or twice to erase only the numbers from the cell reference
• example: if the formula is =K4*C6 you only press backspace once to erase the "6" but keep the "C"
• then type the correct row number for that flavour
• example: CAP sweet guava is row 7, so I erased "6" and typed "7"
• hit enter to move to the next cell for the next flavour in the recipe
• repeat the steps above for each flavour in the recipe, changing the last number to match the flavour in the 'flavour name' column each time

Sounds tricky but its not, its way harder to explain over reddit than it is to do it on the sheet lol, try it and you will see (I hope).

Then you are ready to mix. The needed weight in grams for each flavour is calculated automatically in the 'g to add column'. So put your bottle on the scale, tare, add the first flavour to the weight, press tare, and continue, down.

PG and VG weights are calculated automatically too at the bottom of the calulator.

Total flavour percentage for your recipe is also calculated automatically at the bottom.

Two more features:

If you dont like pressing tare after each flavour (like me) then you can use the 'cumulative weight' column instead, which calculates what the scale should read after the addition of each flavour/PG/VG if you do not press tare after each step.

If you use the cumulative weight feature, you can also take advantage of the 'overpour' column. If you accidentally add too much of any flavour, just replace the number in the 'overpour' column for that flavour with the weight that the scale says, and all the flavours after it will be updated so that you still add the exact weight needed for the rest of the flavours/PG/VG. This way, you dont have to switch over to the tare method if you over pour and/or you can be sure your adding the right amounts of the other flavours still so one mistake doesnt throw the whole recipe out of whack.

example: the calculator shows 0.07g needed for CAP super sweet (in all three columns), but I accidentally pour too much and my scale says I poured 0.10g. So I change the value in the 'overpour' column for CAP super sweet (cell N4) from "0.07" to "0.10", and the cells below it are updated to show what the scale should read after I add the correct amount of each flavour that comes after CAP super sweet in the recipe.

*I have been recording that column number when formulating my recipes to save time, so my recipe tables in my mix log (which I generate before I mix) have three columns: flavour name + manuf., percentage, and row number. Then when I want to mix one of these recipes I can input the row number along with the flavour name and percentage.