Any way to get this in a file I can use? My Macs Excel will not open xls files properly. I have tried to find an actually functioning conversion program, but alas, to no avail.. Any tips? Much appreciated Jaaxx.
Hack-O-Matic E-Liquid Calculator
- Thread starter Jaaxx
- Start date
- th_trl_thread_readers 0
- Status
I only got an old copy of MS Word on this computer. I don't let that trial crap install cause then you got to pay. Tomorrow I might check out open office. Thanks Smo and Jaxx.
Looks like Google Documents is working fine, it lets me edit the spreadsheet and all the formulas are giving proper results. An image of a really simple test is attached.
In the meanwhile you can just check your email and open the attachment with Google Documents, as i stated it works just fine. Getting OpenOffice is a better option for sure anyway.
Hey cekte, I've got no problem at all in emailing you this file on a gmail account to use this workaround. Other than that, I'm no good with macs =/
Attachments
Last edited:
Cekte, just open the file with NeoOffice, it´s free, and it´s way better that MS-Office. Just Google it, select if you have a PPC Mac or an Intel one, and get it.
Without a moment of hesitation I highly recommend getting OpenOffice regardless of what OS you use (Mac, Windows, Linux, Unix, etc.) Unless you are a MS Office guru, you will have no problem transitioning.
Also, I've neglected a few threads about not being able to enter values in parts of the spreadsheet. Sorry I've been busy
.
I protected the cells that do not need user input.
In other words, If you can't alter the value in a cell then it is a static and/or calculated cell.
Ummmm..... ok, I'm a geek.
In real terms, I didn't include instructions, but I made it so you can't break it by playing with it. PM me if you need help!
Also, I've neglected a few threads about not being able to enter values in parts of the spreadsheet. Sorry I've been busy
. I protected the cells that do not need user input.
In other words, If you can't alter the value in a cell then it is a static and/or calculated cell.
Ummmm..... ok, I'm a geek.
In real terms, I didn't include instructions, but I made it so you can't break it by playing with it. PM me if you need help!
Thanks, I wrote it down because my computer wouldn't let me save it. I wanted to email you but your profile wouldn't open, so I guess I'll just mention it here.
When I opened it I thought it had transferred some of your pictures to my computer because it had the "my documents" title exactly like mine. It seems to give access to your files . I am not sure if your computer could be harmed or files lost. I am wondering if it would better to just copy the amounts into a post to protect your privacy. I am not particularly computer savy so it may be something else.
When I opened it I thought it had transferred some of your pictures to my computer because it had the "my documents" title exactly like mine. It seems to give access to your files . I am not sure if your computer could be harmed or files lost. I am wondering if it would better to just copy the amounts into a post to protect your privacy. I am not particularly computer savy so it may be something else.
Man that spreadsheet looks nice.
In fact I was putting something together to do the same thing.
The only thing I see, being new, is it seems to me that trying to figure out the % might be wierd.
Like, I want to make 3 ML of product, starting with 24 MG. So is 4 drops of flavoring what percentage??
Anyway here is the spreadsheet that I was playing with to do similar.
It's based upon quantity of the materials, and not percentage.
In fact I was putting something together to do the same thing.
The only thing I see, being new, is it seems to me that trying to figure out the % might be wierd.
Like, I want to make 3 ML of product, starting with 24 MG. So is 4 drops of flavoring what percentage??
Anyway here is the spreadsheet that I was playing with to do similar.
It's based upon quantity of the materials, and not percentage.
Wow, just had a revisit to my baby. The excel version acts up if it's not unlocked. I don't remember how to unlock the sheet in Excel (I've been off MS products for over 4 years.)
Then you just need to put "3" in Desired batch size, and "24" in Strength of e-liquid. You then can play with values for the percentages until you get the Resulting Strength you want. The columns to the right will give you the amounts in drops.
Oh also the %cell next to desired batch size cell should equal %100 when you're done tweaking. If you unlock the sheet you'll get better instructions. Evidently in Excel you don't get the description popups if the sheet is locked but you do in OpenOffice (which is what I use.)
Jaaxx
Yeah I had made a copy of your original sheet, and saved it, after that I could unlock everything.
BTW, you would want to select the entire sheet, and then go into tools, there should be an UNPROTECT. That should unlock everything.
I have just placed my very first order for an e-cig (yeah the wife, and I are puffer virgins), anyway I wanted to start looking at what liquids were available, and what I would have to do to mix up various strengths.
Eye towards weaning us off the nic.
Plus this way I can cut, and paste into a permanent copy, and make notes on the mixtures.
The reason for all this. I LOVE CLOVES. Been smoking Djarum Blacks for years. Problem is Clove liquid is rather difficult to find.
Figured I would end up having to experiment to get a mix I like.
Of course I will post when I finally get one.
Hope you had a chance to look an my version of the sheet.
Jaax;
First I gotta tell you I swiped your sheet, and added it to mine.
If that is an issue then kill the spreadsheets off that are attached.
I also made changes to my stuff.
I made 2 tabs.
Tab 1 is based upon volume. How many ML, or drops. It calcs the strength, volume, and % of the final mix.
I figure this should be usable if you are experimenting to "find the right" taste.
Tab 2. This is Jaax's original sheet.
It is based upon &, and strength of the mix.
I think between the 2 tabs you have the calculations to do small batches until you get what you want.
Then use tab 2 (Thanks Jaax) to calc what you need to make a larger batch.
Please let me know what you think.
First I gotta tell you I swiped your sheet, and added it to mine.
If that is an issue then kill the spreadsheets off that are attached.
I also made changes to my stuff.
I made 2 tabs.
Tab 1 is based upon volume. How many ML, or drops. It calcs the strength, volume, and % of the final mix.
I figure this should be usable if you are experimenting to "find the right" taste.
Tab 2. This is Jaax's original sheet.
It is based upon &, and strength of the mix.
I think between the 2 tabs you have the calculations to do small batches until you get what you want.
Then use tab 2 (Thanks Jaax) to calc what you need to make a larger batch.
Please let me know what you think.
I got this to work using Stuffit. A new zip file is attached that should work.
Here is a working version to download. SuperECIG tracker v2. It has the hack-o-matic (awesome tool JAAXX) and a few other great ecig calculator tools. (plus its damn colorful)
(plus its damn colorful)Here is a working version to download. ... It has the hack-o-matic (awesome tool JAAXX) and a few other great ecig calculator tools.
Thanks, that's really nice!
Can a moderator make this a sticky? This is the type of information we look for and can’t find when we need them. It always seems to get buried in the threads. Ice199
Last edited:
- Status
Similar threads
