My tobacco spreadsheet

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

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

    Siv Flame+Wood=Bad Idea

    Joined:
    Mar 9, 2012
    Messages:
    510
    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,584
    .....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:
    6,778
    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 Active Member

    Joined:
    Feb 22, 2012
    Messages:
    4,337
    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,584
    Yeah, but do those dogs chew twist?:confused:....(sorry for h/jacking!)
     
    dwaugh likes this.
  7. Siv

    Siv Flame+Wood=Bad Idea

    Joined:
    Mar 9, 2012
    Messages:
    510
    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,646
    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:
    948
    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:
    6,778
    Some things are best left unknown:)
     
  11. JuJu McMojo

    JuJu McMojo Member

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

    jdto Active Member

    Joined:
    Feb 22, 2012
    Messages:
    4,337
    A PSF app?
     
  13. jdto

    jdto Active Member

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

    woody Admin Admin

    Joined:
    May 4, 2009
    Messages:
    11,355
  15. dhintonca

    dhintonca Member

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

    jdto Active Member

    Joined:
    Feb 22, 2012
    Messages:
    4,337
    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.