Dear DIYers, I have been diligently working on my own Ejuice Excel sheet. Would anyone be interested in this? I am also trying to figure out the VG/PG calculations. Maybe someone could help?

submitted over 11 years ago by sevenfacedsin

Comments

2 points

by 7by12over 11 years ago

Is your nicotine base in "100%" pg? You might want incorporate plain PG and desired PG/VG ratio into the calculations.

Edit: Where can I order Gooby and Pls? I'm imagining they taste like mushy banana and moldy strawberry.

Edit: It looks like great work!

Edit I am an idiot. Sorry.

2 points

by aqbleover 11 years ago

If you import this into Google Docs you can share it very easily by posting the link or publishing the spreadsheet.

2 points

by tekhawkover 11 years ago

Second this I'd be willing to help with it if you want to put it on Google doc. Used to be a software engineer so if I can't figure out the ratio part for you I'd be greatly disappointed in my self lol

1 points

by sevenfacedsinover 11 years ago

I do accounting all day everyday and can't figure out the ratio calculations, don't feel bad.

Can I do this using Skydrive instead? I don't have a Google account.

2 points

by tekhawkover 11 years ago

That works just shoot me a link and I'll check it out

2 points

by sevenfacedsinover 11 years ago

So for everyone interested, I have pretty much wrapped up what I would be using. It is published here:

https://onedrive.live.com/redir?resid=1A8BD05A345A17C9%212426

Feel free to grab a copy and fork it however you like.

Sheet 1 = Master calculator, includes bottle sizes 30ml, 15ml, and 10ml.

Sheet 2 = Worksheet for calculating premix flavor bases, and the calculations for adding your base to the premix flavors.

Sheet 3 = Cost analysis. Break down of nicotine base, glycerin and up to 5 flavors. Helps you decide what to buy, how much to spend, breaks down cost per bottle sizes, and allows you to maintain optimal money savings.

Sheet 4 = Blank sheet for your favorite recipes.

PS: This is what I use, since I vape max VG, there is no PG/VG ratio calculation.

1 points

by sevenfacedsinover 11 years ago

I vape max VG, but I am trying to make this so that anyone can use it. I want to add calculations for dilution based on what kind of a base you buy, and what people's desired PG/VG ratios are, and then do the math from there.

I just finished up adding a portion for price per bottle depending on the bottle size you make, so that you can see how much it would cost you and decide the optimal money saving.

That's the accountant in me.

Gooby and pls were just random that I threw in for testing. I rarely use five flavors.

Right now, it suits MY needs, but again, I am trying to make this for others as well.

1 points

by 7by12over 11 years ago

See my edited original post, sorry. I'd definitely be interested in using this once I start DIY.

1 points

by sevenfacedsinover 11 years ago

Bring forth the downvotes!

1 points

by lunaticfringe80over 11 years ago

Brilliant idea! I'm just starting out and beginning to build a recipe list. It didn't take me very long to set this up, considering I'm horrible at spreadsheet formulas.

I've exported mine to google drive and shared it here. It assumes nic base is VG and flavorings are PG, since that what I use. If someone knows how to add that variable, please feel free.

1 points

by ThisPinoyKiDdover 11 years ago

Yes! Would love this!

1 points

by dr00minover 11 years ago

24mg is 2.4% not 24%. That would be dangerous bro.

1 points

by isdnproover 11 years ago

He's saying it's 24% of the liquid in the recipe, not the nicotine strength itself

1 points

by sevenfacedsinover 11 years ago

This spreadsheet is saying you need 24% of your nicotine base, added to 56% VG dilutant, and then 20% flavoring.