Ejuice calculator (added quantity calculations)
- Thread starter Scubabatdan
- Start date
- th_trl_thread_readers 0
- Status
Your measurements are in the 1st column of section two. Yes, you need to be sure you accurately measure each as specified to reach the 3mg at 30ML (e.g. 0.9ml of nic.) - I think that's what you were asking....
I normally start with Target Nic and adjust everything from there to reach the required quantity. I'm mixing 500ml at a time so I don't actually need to go back in and design new flavor combinations very often. When I try new flavors, I usually experiment with percentages added to small samples of my standard mix then establish the percentages for larger batches... I haven't actually switched to other flavors, but you get the idea - seat of the pants type of mixing.
The biggest concern is to carefully monitor the amount of nic... it's hard to OD on it if you start with your basic juice level then make small batches to try the new flavors. You may also want to try getting the flavor proportions without the nic... no mater what you do, it boils down to your taste and what you like.
Thank you so much for the spreadsheet. I am a bit confused though, as in the recipes sheet there are a lot of lorann's flavors listed that the color coded lorann's page in a different thread (I'm sure y'all know the one) say are unsafe. Which one should I go off of?
Well seeing how the list in this spreadsheet was updated over a year ago. As with anything company formulas can change, I would always go with the current lorann website information on all flavors. If it says not soluble in water do not use it.
Tedious stuff for Linux/LibreOffice users.
I've been using V13 with Linux/LibreOffice 4.0 for a year and fixing problems as I go.
I've just switched to LibreOffice 4.4 with ejuice calculator V14 (as at 01-May-2015) and it works darn well pretty much out of the box (4 hours testing so far).
One small thing is that the (PG or VG Calculator) "Make a New recipe" section failed.
Drop down cells K9:K13 showed a [HASHTAG]#REF[/HASHTAG]! error even when a manufacturer was selected in the corresponding J cells.
Reason: Source for the drop down was strangely corrupt. (Will happen elsewhere I guess; haven't checked.)
To fix:
Select sheet "PG Calculator". (Unprotect the sheet if necessary. Tools->Protect Document->Sheet
Select cell K9.
Data->Validity->Criteria Tab->Source
Change from INDIRECT('PG Calculator'.JF9)
to INDIRECT('PG Calculator'.J9)
ie. remove that rogue "F".
Repeat for VG Calculator sheet.
Other notes:
The add recipe button works fine in V14; I had to hack it in V13. I think that's down to the new LibreOffice.
Some cell backgrounds are too dark to read (eg: "PG Calculator".M14 is dark green). They don't respond to having the colour changed even if unprotected. The fix is: Select cell(s) then Format->Clear Direct Formatting.
There are other oddities I've noticed but nothing to bore people with.
Big, make that HUGE, thanks to Scubabatdan for this excellent bunch of sheets. It's the only juice mixer worth its salt that runs natively on Linux I can find.
I've been using V13 with Linux/LibreOffice 4.0 for a year and fixing problems as I go.
I've just switched to LibreOffice 4.4 with ejuice calculator V14 (as at 01-May-2015) and it works darn well pretty much out of the box (4 hours testing so far).
One small thing is that the (PG or VG Calculator) "Make a New recipe" section failed.
Drop down cells K9:K13 showed a [HASHTAG]#REF[/HASHTAG]! error even when a manufacturer was selected in the corresponding J cells.
Reason: Source for the drop down was strangely corrupt. (Will happen elsewhere I guess; haven't checked.)
To fix:
Select sheet "PG Calculator". (Unprotect the sheet if necessary. Tools->Protect Document->Sheet
Select cell K9.
Data->Validity->Criteria Tab->Source
Change from INDIRECT('PG Calculator'.JF9)
to INDIRECT('PG Calculator'.J9)
ie. remove that rogue "F".
Repeat for VG Calculator sheet.
Other notes:
The add recipe button works fine in V14; I had to hack it in V13. I think that's down to the new LibreOffice.
Some cell backgrounds are too dark to read (eg: "PG Calculator".M14 is dark green). They don't respond to having the colour changed even if unprotected. The fix is: Select cell(s) then Format->Clear Direct Formatting.
There are other oddities I've noticed but nothing to bore people with.
Big, make that HUGE, thanks to Scubabatdan for this excellent bunch of sheets. It's the only juice mixer worth its salt that runs natively on Linux I can find.
Nice to have a linux guy around
Please feel free to share a link to your linux friendly version here so others can benefit from your corrections.
Thanks!
Dan
Thanks for the thanks Dan. I'm very happy to share my version - just as soon as I find somewhere to upload it to. Seems I can't attach it to this post.Nice to have a linux guy around
Please feel free to share a link to your linux friendly version here so others can benefit from your corrections.
Thanks!
Dan
@Scubabatdan I've put my LibreOffice version of ejuce_calculatorv14.xls here ejuce_calculatorv14-rob.ods Edit: link changed
The functionality is unchanged, I have just fixed a few minor errors in drop down lists and cosmetics. Oh, and probably put some test code in for LO's crazy VB emulator. Nothing malicious though!
I hope it may be of use to someone.
The functionality is unchanged, I have just fixed a few minor errors in drop down lists and cosmetics. Oh, and probably put some test code in for LO's crazy VB emulator. Nothing malicious though!
I hope it may be of use to someone.
Last edited:
Anyone know of a good calc for android... Preferably free.
Thanks alot for adding gram meassurements and adjustable densities Puffaway and of course to Scubabatdan for the original sheets! Much appreciated guys!
I was beginning to be somewhat annoyed with e-liquid-recipes hardcoded values of 0.93g/mL for water and 1.26g/mL for all vg nicbases no matter potency, and so was beginning to just using a manual calculator instead, but then I just stumbled upon this v14, which is perfect for me after I changed a little thing of letting the water percentage be dependant on the total mixing amount and not the vg amount, since water isn't solely about thinning vg, but just as much about lowering the boiling-point/upping the evaporation-effeciency, and enhancing the flavor/smoothness of the total mix.
I was beginning to be somewhat annoyed with e-liquid-recipes hardcoded values of 0.93g/mL for water and 1.26g/mL for all vg nicbases no matter potency, and so was beginning to just using a manual calculator instead, but then I just stumbled upon this v14, which is perfect for me after I changed a little thing of letting the water percentage be dependant on the total mixing amount and not the vg amount, since water isn't solely about thinning vg, but just as much about lowering the boiling-point/upping the evaporation-effeciency, and enhancing the flavor/smoothness of the total mix.
Last edited:
^^^ Thanks are due entirely to Scubabatdan!
(But I'm happy to bask in the reflected glory. )
(But I'm happy to bask in the reflected glory.
)
E-Liquid Calculator, look for a penguin icon.
By Alessandro Boggiano
Thanks for all your hard work on this Scubabatdan, as you must have spent countless hours on this spreadsheet. I just bought a digital scale and was wondering if the g/ml is the total (grams) weight?
e.g.,
PG with Nicotine 0.90 ml | 36 drops | 0.91 g/ml
e.g.,
PG with Nicotine 0.90 ml | 36 drops | 0.91 g/ml
- Status
Similar threads
- Locked
