In case anyone was interested, here is a nice google docs spreadsheet to track your spending, break-even date, and more. (Now with lots of magic!)
(Click to embiggen)
View attachment 177674
Once you open it you can make your own copy (in the File menu.)
It is easy to use. Just open the "Settings" tab (at the bottom) and fill in the quit date, number of cigs per day (a number or a formula - for example, 8 packs a week is "=8*20/7") and the average cost per pack.
Back on the first tab, fill in a row for each expense. (Description goes in A, vendor in B, order date in C, cost in D.) The running total will automatically update. Wishlist items can go in with no order date and they will just sit there. Update: It will also resort the page whenever you update the order date.
If you sell off something, fill it in as an order with a negative amount (eg "-40" dollars.)
The last tab is Vendors. This lists all the vendors you have shopped with (including wishlist items.) Simply open that tab and press ctrl-shift-E to update the list. You can ignore any warnings about overwriting values.
Let me know what you think!
(Click to embiggen)
View attachment 177674
Once you open it you can make your own copy (in the File menu.)
It is easy to use. Just open the "Settings" tab (at the bottom) and fill in the quit date, number of cigs per day (a number or a formula - for example, 8 packs a week is "=8*20/7") and the average cost per pack.
Back on the first tab, fill in a row for each expense. (Description goes in A, vendor in B, order date in C, cost in D.) The running total will automatically update. Wishlist items can go in with no order date and they will just sit there. Update: It will also resort the page whenever you update the order date.
If you sell off something, fill it in as an order with a negative amount (eg "-40" dollars.)
The last tab is Vendors. This lists all the vendors you have shopped with (including wishlist items.) Simply open that tab and press ctrl-shift-E to update the list. You can ignore any warnings about overwriting values.
Let me know what you think!
