Hack-O-Matic E-Liquid Calculator - Page 3 - e-cigarette-forum.com • The place for electronic cigarette reviews, news and chat

cekte · 03-11-2009, 04:07 AM

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.

MrsJaaxx · 03-11-2009, 04:22 AM

Jaaxx says please PM him with your email address.
(I am playing secretary)

MonkeyMonk · 03-11-2009, 06:06 AM

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.

Smo · 03-11-2009, 08:31 PM

Quote:

Originally Posted by Jaaxx

Please report back if it works for you. Also I might suggest OpenOffice.org? Free office suite. Rocks all over MS office.

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.

Quote:

Originally Posted by MonkeyMonk

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.

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.

Quote:

Originally Posted by cekte

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.

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 =/

lachirris · 03-12-2009, 07:47 AM

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.

Jaaxx · 03-12-2009, 08:03 AM

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!

Gofo2 · 03-22-2009, 05:56 PM

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.

ichaya · 04-06-2009, 08:19 PM

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.

Jaaxx · 04-06-2009, 08:44 PM

Quote:

Originally Posted by ichaya

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.

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

ichaya · 04-07-2009, 12:13 AM

Quote:

Originally Posted by Jaaxx

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.

03-11-2009, 04:07 AM	#21
cekte Super Member Join Date: Feb 2009 Location: Oregon Posts: 449 Blog Entries: 2	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. __________________ Looking for a review? -www.youtube.com/VaporViews- 'E-Cigarette'/Personal Vaporizer related reviews.

03-11-2009, 06:06 AM	#23
MonkeyMonk Adrian's Quirky Sister Join Date: Feb 2009 Posts: 715	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. __________________ How strange is the lot of us mortals! Each of us is here for a brief sojourn; for what purpose he knows not, though he senses it. But without deeper reflection one knows from daily life that one exists for other people. Albert Einstein

03-12-2009, 08:03 AM	#26
Jaaxx USA Supplier Forum Sponsor Join Date: Oct 2008 Location: Atlanta, GA Posts: 494	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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

03-11-2009, 04:22 AM	#22
MrsJaaxx USA Supplier Join Date: Feb 2009 Location: Atlanta, GA Posts: 342	Jaaxx says please PM him with your email address. (I am playing secretary)

03-12-2009, 07:47 AM	#25
lachirris Full Member Join Date: Feb 2009 Location: Cancun Mexico Posts: 43	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.

03-22-2009, 05:56 PM	#27
Gofo2 Full Member Join Date: Mar 2009 Location: St. Louis, Missouri Posts: 68	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.