Spreadsheet Ecig VS. Analog Challenge

[enadrown]

As soon as I put the baby down for a nap I am going to try this on my own, but I was wondering if any one had made an expense spreadsheet to see how much they are actually saving by vaping.

I am thinking it should add how much analogs are costing the individual per day/week/month, and then have a section for purchases for your ecig, including startup price, liquid, and hardware.

I love spreadsheets (I am a little weird, always preferred pens and paper for christmas rather than toys) and would love to see what other people that are weird like me have come up with or could come up with if challenged.

I will post what I have when it's done. May not be great, but we'll see if it works and if I can figure a good place to upload it for a download by others!

 

[DJKahoona]

Looking forward to this. Make sure you say if your drip/dip or carting =D

 

[bearscreek]

Someone already made a huge spreadsheet program and posted it a few months back. It's called something like the Superecigtracker, but I can't find a link for it right now. I'm sure someone has that and will come through soon.

 

[Scubabatdan]

Someone already made a huge spreadsheet program and posted it a few months back. It's called something like the Superecigtracker, but I can't find a link for it right now. I'm sure someone has that and will come through soon.

Ask and ye shall recieve

http://www.e-cigarette-forum.com/fo...-year-spending-comparision-ecigs-vs-cigs.html

Dan

 

[bearscreek]

Also, this will get you started.

 

[Wellner]

Never thought of using a spread sheet. I myself have just used a counter for keeping track of how much I haven't spent on analogs, and keep the price of all my invoices combined written somewhere and I haven't quite broken even yet. As I'm still new and there are too many variables to keep on a spreadsheet(at least with my knowledge), I'm not spending a set amount yet on PVs or accessories yet. I have taken the thought as most of my work includes Excel, and anything I can think of to do in my personal life, I try to incorporate Excel.

 

[enadrown]

My little project is coming along well, it's not pretty by any means, but is going to be good and get the job done NICELY for me at least, but I have hit a snag. If there is any one in here that is quite proficient in Excel could you email me at enadrown@att.net as I have a question of how I should get a formula in here that will make everything actually work on the e-cig side of my sheet. I WOULD TOTALLY APPRECIATE IT!

 

[enadrown]

While still trying to solve my spreadsheet issues I ran across the superecigtracker that bear was talking about. THe link to it is http://esmokersmag.com/2009/04/07/super-ecig-tracker/ down load link at the bottom of the page, this is exactly where my spread sheet is headed, except theirs is better and works right now. When i get mine figured out I will still post, till then, this is a great one to use also. I LOVE THESE THINGS!

 

[Reboot]

While still trying to solve my spreadsheet issues I ran across the superecigtracker that bear was talking about. THe link to it is [LINK REMOVED] download link at the bottom of the page, this is exactly where my spread sheet is headed, except theirs is better and works right now. When i get mine figured out I will still post, till then, this is a great one to use also. I LOVE THESE THINGS!

I guess you must just really want to make your own? Why not just use the one that is already available that works and is better? lol.

 

[bearscreek]

If you use the superecigtracker, pay close attention to exactly what is being calculated and why because there may be a couple of things that calculate a tad differently than you expect them to.

 

[enadrown]

LOL, trust me, I am not having much luck solving my problems and am using the ecigtracker available, but I'm laid off and don't have much else to do to pass the time but my little "boredom projects" so it doesn't hurt to try because I do like my formatting better if I could get a certain section to work.

and bears, I totally understand what you are saying about the calculations, it looks like I am in the hole way more than I actually am because of adding the analog vs ecig prices and savings up by day instead of by the carton/week the way I actually buy them. Same concept but it breaks down WAY

 

[bearscreek]

To be honest with you, I'd have to look back at it, but what I meant was that, for instance, I'm thinking the price of your nic juice used for calculating your daily usage and savings versus analogs takes into account whether or not you dilute the juice (and make it cheaper per true mL), but the days' worth of juice stock doesn't really take into account the dilution (the way I use it anyway). That's just 1 example, and there's nothing wrong with it, but you need to know what exactly you're dealing with in order to understand what it's showing you.

 

[enadrown]

To be honest with you, I'd have to look back at it, but what I meant was that, for instance, I'm thinking the price of your nic juice used for calculating your daily usage and savings versus analogs takes into account whether or not you dilute the juice (and make it cheaper per true mL), but the days' worth of juice stock doesn't really take into account the dilution (the way I use it anyway). That's just 1 example, and there's nothing wrong with it, but you need to know what exactly you're dealing with in order to understand what it's showing you.

I saw that when I was putting in my info and cut the price of the carts that was preprogrammed in at .55 down to .25 figuring that would be a little closer, give room for vg, and dripping methods. it'll do for me. i wasnt as concerned with that part when I am working on my own, mainly how much money was spend on e-cigs, added to how much NOT spent on analogs. but i still can't get mine figured out the way i like it, so I gave up.. gr!