1. If you cannot verify your email address or recover your password, you need to call your ISP and tell them to stop blocking your email from this site.
    Dismiss Notice

My tobacco spreadsheet

Discussion in 'Pipe Tobacco' started by iSiv, Mar 15, 2012.

Thread Status:
Not open for further replies.
  1. iSiv

    iSiv Member

    Joined:
    Mar 9, 2012
    Messages:
    152
    Since I started buying pipe tobacco in serious quantities about 3 years, I put all my purchases into a spreadsheet so that I can track what I have. A side-effect is that I can do some analysis of my spending pattern and tobacco prices. Here is some analysis.

    Highest bulk price paid $4.98 per Oz in 2012 for SG SL
    Lowest bulk price paid $1.25 per Oz in 2009 for Butternut Burley
    Most expensive 50g tin $12.99 in 2012 for SG SL
    Cheapest 50g tin $5.99 in 2009 for SG SL
    Total stored: 486 Oz
    Average price increase from 2009 to 2012 = 20%
    Average price increase from 2009 to 2012 excluding SG baccy = 7%

    The average price increase in baccy is not really all that bad but my picture of it is skewed because 30% of what I smoke and store is Sam Gawith.

    I have come to two conclusions:
    1. Stop storing baccy and start smoking it
    2. Never show my wife this spreadsheet!
     
  2. Old Ted

    Old Ted Active Member

    Joined:
    Oct 1, 2010
    Messages:
    4,883
    .....my wife says I need a 'spread sheet' (or maybe a bed sheet! ) 'cos after I've cut up my plugs - she has to sweep the kitchen floor! :p:
     
    dwaugh likes this.
  3. TRAVIS

    TRAVIS Member

    Joined:
    Nov 26, 2010
    Messages:
    665
    The wife sees the spreadsheet and number 1 shouldn't be an issue. :)
     
  4. dwaugh

    dwaugh Moderator Moderator

    Joined:
    Mar 2, 2011
    Messages:
    7,854
    Ted, you can use my kitchen (just take the QE2 over), with three dogs that play out in the backyard, I could rebuild a motorcycle in the kitchen and no one notice the mess :)
     
    Old Ted likes this.
  5. jdto

    jdto Well-Known Member

    Joined:
    Feb 22, 2012
    Messages:
    6,103
    I've just started a little spreadsheet to catalogue stuff (in conjunction with my iPad Pipe Tool), but I keep the dollar figures far away from that.
     
  6. Old Ted

    Old Ted Active Member

    Joined:
    Oct 1, 2010
    Messages:
    4,883
    Yeah, but do those dogs chew twist?:confused:....(sorry for h/jacking!)
     
    dwaugh likes this.
  7. iSiv

    iSiv Member

    Joined:
    Mar 9, 2012
    Messages:
    152
    At least you can play with your baccy in the kitchen. I'm ousted to the balcony!
     
    TRAVIS likes this.
  8. BigJ

    BigJ Active Member

    Joined:
    Mar 20, 2010
    Messages:
    1,907
    I thought pope tool was only for PC. Thanks for the heads up, downloaded it for my iPhone. Amazing!
     
    jdto likes this.
  9. gunsmoke

    gunsmoke Member

    Joined:
    Feb 26, 2010
    Messages:
    969
    I've got my cellar in a spreadsheet. Don't keep track of $ though, I don't want to know.
     
    dwaugh and jdto like this.
  10. dwaugh

    dwaugh Moderator Moderator

    Joined:
    Mar 2, 2011
    Messages:
    7,854
    Some things are best left unknown:)
     
  11. JuJu McMojo

    JuJu McMojo Member

    Joined:
    Jan 14, 2011
    Messages:
    310
    Amen to #2. I only keep 10-12 lbs, but I feel like I'm gonna get busted any second.......
     
  12. jdto

    jdto Well-Known Member

    Joined:
    Feb 22, 2012
    Messages:
    6,103
    A PSF app?
     
  13. jdto

    jdto Well-Known Member

    Joined:
    Feb 22, 2012
    Messages:
    6,103
    Where can I get that software?
     
  14. woody

    woody Aloha! Admin

    Joined:
    May 4, 2009
    Messages:
    10,039
  15. dhintonca

    dhintonca Member

    Joined:
    Jan 5, 2012
    Messages:
    343
    jdto likes this.
  16. jdto

    jdto Well-Known Member

    Joined:
    Feb 22, 2012
    Messages:
    6,103
    Yeah, I have Pipe Tool on my iPad, but the one for PC might be nice to have at home. Thanks guys!
     
Thread Status:
Not open for further replies.