Post Reply 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Spreadsheet for mixing & cost
Author Message
stev32k Offline

Posts: 90
Likes Given: 27
Likes Received: 51 in 29 posts
Joined: May 2016
Reputation: 1
Post: #1
Spreadsheet for mixing & cost
I'm considering getting set up to mix my own juice and made a spreadsheet to do the calcs and cost. It assumes the nic and flavor is dissolved in PG and only one flavor is used. The cost data came from and

I would appreciate some of you guys with more experience looking over the spreadsheet to see if there are errors. Sorry, I just saw a gross error and will revise the sheet and post it later. OK, maybe I got it right this time - trying to do things too fast gets me sometimes.
(This post was last modified: 15-05-2016 06:59 PM by stev32k.)
15-05-2016 06:34 PM
Find all posts by this user Like Post Quote this message in a reply
Don Offline
Squonk and Toodle Club Member
Senior Staff

Posts: 14,397
Likes Given: 12,460
Likes Received: 20,032 in 9,643 posts
Joined: Dec 2013
Reputation: 227
Post: #2
RE: Spreadsheet for mixing & cost
The VG to add figure is wrong. It should be 15ml. The list of ingredients gives you 38.4ml

TVF tested battery info to be found here

[Image: 24291313393_16615b20b2_m.jpg]
15-05-2016 06:43 PM
Find all posts by this user Like Post Quote this message in a reply
Michael Offline
Oh, where have I gone off to...

Posts: 6,756
Likes Given: 17,353
Likes Received: 7,442 in 3,870 posts
Joined: Sep 2014
Reputation: 60
Post: #3
RE: Spreadsheet for mixing & cost
I made a similar spreadsheet myself, you can take a look over on my blog section where I posted it (under the sub-forum "Michael's Vaping Journey"). 

For some reason I can't pull up your spreadsheet on my phone so I can't give specific advice. The main important thing is to triple check every possible equation to make sure your math is 100% correct or else it's useless. Have a "total" section that adds up the ingredients so you're sure it equals out to the desired total amount of juice. Also make sure the price calculations are correct and it all adds up right, when I first made mine I had trouble getting the cost right. 

Like I said, I've made one and posted it here so you're more than welcome to use it yourself or use it as a reference for making your sheet. 
16-05-2016 01:31 AM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Post Reply