The costs of running this huge site are paid for by ads. Please consider registering and becoming a Supporting Member for an ad-free experience. Thanks, ECF team.

Ejuice calculator (added quantity calculations)

Discussion in 'DIY E-Liquid' started by Scubabatdan, Aug 14, 2009.

Image has been removed.
URL has been removed.
Email address has been removed.
Media has been removed.
  1. swatc1h

    swatc1h Full Member

    Nov 14, 2014
    cali
    hello . using vg base 80/20 mix . im using tpa flavors . amount to be made 30ml but its over . does it need to be exactmundo . v14
     

    Attached Files:

  2. Teach

    Teach Ultra Member Verified Member ECF Veteran

    Aug 3, 2010
    Florida
    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....

    upload_2015-4-26_9-6-35.png
     
  3. swatc1h

    swatc1h Full Member

    Nov 14, 2014
    cali
    thank you . one more question . on make a new recipe, how do i find "parts" ratio drops ? that value never changes or i just suck @ math .
     
  4. Teach

    Teach Ultra Member Verified Member ECF Veteran

    Aug 3, 2010
    Florida
    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.
     
  5. ArgusMcJohnsten

    ArgusMcJohnsten Senior Member Verified Member

    Mar 24, 2015
    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?
     
  6. Scubabatdan

    Scubabatdan Vaping Master Verified Member ECF Veteran

    Jul 14, 2009
    Dothan, AL
    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.
     
  7. Puffaway

    Puffaway Senior Member

    May 4, 2014
    Dorset, UK
    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.
     
  8. Scubabatdan

    Scubabatdan Vaping Master Verified Member ECF Veteran

    Jul 14, 2009
    Dothan, AL
    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
     
    • Like Like x 1
  9. jdoebean

    jdoebean Full Member

    Oct 25, 2014
    Chicago, Il
    Thank you, been toiling away on my own...
     
  10. Puffaway

    Puffaway Senior Member

    May 4, 2014
    Dorset, UK
    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.
     
  11. Scubabatdan

    Scubabatdan Vaping Master Verified Member ECF Veteran

    Jul 14, 2009
    Dothan, AL
    You can use files anywhere or drop box and just post a link to the file.
    Thanks,
    Dan
     
  12. jdoebean

    jdoebean Full Member

    Oct 25, 2014
    Chicago, Il
    Thank you, been toiling away on my own...
     
  13. Puffaway

    Puffaway Senior Member

    May 4, 2014
    Dorset, UK
    @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.
     
    • Like Like x 3
  14. RDP

    RDP Full Member

    Jun 10, 2015
    Oklahoma
    Anyone know of a good calc for android... Preferably free.
     
    • Like Like x 1
  15. mhertz

    mhertz Ultra Member ECF Veteran

    Feb 7, 2014
    Denmark
    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.
     
    • Like Like x 2
  16. Puffaway

    Puffaway Senior Member

    May 4, 2014
    Dorset, UK
    ^^^ Thanks are due entirely to Scubabatdan!
    (But I'm happy to bask in the reflected glory. :) )
     
    • Like Like x 1
  17. ShowerHead

    ShowerHead Super Member Verified Member ECF Veteran

    Feb 23, 2014
    Massachusetts
    E-Liquid Calculator, look for a penguin icon.
    By Alessandro Boggiano
     
  18. demitrix

    demitrix Full Member

    May 27, 2015
  19. RDP

    RDP Full Member

    Jun 10, 2015
    Oklahoma
  20. Waddle

    Waddle Super Member Verified Member ECF Veteran

    Jul 1, 2014
    Korea
    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
     

Share This Page