Super ECIG tracker

[puff-puff-pass]

This is a revision of the spreadsheet created by Catanonia http://www.e-cigarette-forum.com/forum/general-e-smoking-discussion/11642-nice-little-spreadsheet-workout-real-savings.html#post179813
I decided to take that and "kick it up a notch" *BAM*. From following that thread, there was a great add-on added to it by BOOBOO for tracking inventory.

I also included the HACK-O-MATIC that JAAXX (hope you don't mind )
I hope to get in touch with the person that created the ANALOGUE TO ecig CALCULATOR so that I can get their unlock code to add it to the NEW SUPER ECIG TRACKER!!

I cleaned up alot of the "white space" and added some color . It is Extremely simple to use thanx to some very easy-to-follow formulas by Catanonia and JAAXX.

Only enter data into the fields that have a light blue/grey background. Almost all the rest is automated!

If you have any questions, please post them here. If you have any ideas that would be a usefull addition, please post those ideas I hope to soon have a "SUPER DUPER ecig TRACKER" (yes...i suck at picking names)

Download it HERE

****UPDATE****
Version 2.0 is HERE
Includes better tracking of liquids, including DIY inventory. Added a TIPS N TRICKS page
Verified all links work
Included link to ECF

For first time user, please enter all critical info on the MAIN SHEET and the ml/carts info on the LIQUIDS INVENTORY sheet.
All data is only as accurate as the info you put into it.

Version 2 download

Here is the GOOGLE DOCS version. Some features may not work (such as hyperlinks). I strongly recommend downloading the ZIP file...but for Google lovers CLICK HERE

 

[booboo]

That's pretty cool! Is there any way you could incorporate something for the price change in cigs? Like for it to calculate the first 4 months at $4.30 a pack and after that at $6 or whatever a pack? That has been boggling my mind (along with actually tracking how much juice I use a day or vapes I take--which is way over my head, lol)!

 

[puff-puff-pass]

That's pretty cool! Is there any way you could incorporate something for the price change in cigs? Like for it to calculate the first 4 months at $4.30 a pack and after that at $6 or whatever a pack? That has been boggling my mind (along with actually tracking how much juice I use a day or vapes I take--which is way over my head, lol)!

Dynamic pricing...too much work for the end user to maintain.
Tracking juice...umm....maybe in a much futeure revision...but will think about it

 

[wv2win]

puff, thank you for improving an already great idea for those of us who are a little excel challanged. I especially like including Jaaxx's formula for DIY liquid.

Great Job!!

 

[puff-puff-pass]

Just realized that some of the hyperlinks are not working properly. I will fix that problem and re-upload a better version when I get home. (about 8 hours from now)

If you find any bugs in the worksheet, please let me know.

 

[Catanonia]

Nice work mate, you obviously spent some time playing

Love the last Hack o matic calculator, very very nice.

Could have done with that myself today

 

[puff-puff-pass]

Nice work mate, you obviously spent some time playing

Love the last Hack o matic calculator, very very nice.

Could have done with that myself today

Hack-o-matic credit belongs to JAAXX....I just Hijacked-o-matic it into my workbook!

 

[Cellmeister]

GREAT GOING!!!

THANK YOU!!!

Keep Vapin!

 

[MaxPower]

I also did a revision to the spreadsheet. It's got some functions on the inventory page you might want to consider for the super duper edition.
Check it out and let me know what you think.

I posted it in the original thread which you can link to from the first post in this thread. I would provide another link, but apparently I can't until I reach 15 posts.

 

[f7eleven]

My only suggestion... publish it in google docs so we don't have to download it.

 

[jac1599]

WOW! That is awesome. Thanks for updating the form. It is really cool to see how much money I am going to save over the course of a year. If only the startup price of vaping wasn't so much...or if I weren't worried about stocking up now due to bans coming down the pike. I've spent a whole lot of money in the last month!

 

[dbtabasco]

that's pretty awesome

 

[puff-puff-pass]

My only suggestion... publish it in google docs so we don't have to download it.

Good idea
I will post it there when I do the revisions.

 

[puff-puff-pass]

I also did a revision to the spreadsheet. It's got some functions on the inventory page you might want to consider for the super duper edition.
Check it out and let me know what you think.

I posted it in the original thread which you can link to from the first post in this thread. I would provide another link, but apparently I can't until I reach 15 posts.

I will look at your revisions and see what I can do

 

[puff-puff-pass]

revision added
http://www.e-cigarette-forum.com/forum/general-e-smoking-discussion/11966-super-ecig-tracker.html
You will find the new link at the bottom of the original message I posted.

 

[dbtabasco]

the link did not work for the edited version. looking forward to playing with it.

 

[puff-puff-pass]

the link did not work for the edited version. looking forward to playing with it.

For some reason it disappeared from my attachment list I will have to look at a better wqay to post it. Google docs is sounding like a really good idea right now....

 

[mace bewley]

hey puff, link still not working for rev. 2.0. if its cool will you e-mail it to me??
thanks,

mace

 

[puff-puff-pass]

My only suggestion... publish it in google docs so we don't have to download it.

Published in Google docs...but not tested in there. I already know that some hyperlinks do not work through GooDocs.

ZIP file is now uploaded and ready (again)...please revert back to the original post for the link.

 

[puff-puff-pass]

hey puff, link still not working for rev. 2.0. if its cool will you e-mail it to me??
thanks,

mace

PM me your address if ya wants.

BTW...Happy Birthday!