A Look into an Addict's Stash Stats

User Tag List

Thanks Thanks:  0
Likes Likes:  0

Thread: A Look into an Addict's Stash Stats

  1. #1
    Senior Member stickles's Avatar
    Join Date
    Jan 2007
    Location
    Singapore
    Posts
    214
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    A Look into an Addict's Stash Stats

    First a background, I maintain a huge Excel file that tracks everything about my makeup spending habits. Price, date, weight, description, where I bought it etc etc. I feed all this "raw data" into a pivot table that gives me some interesting stats about my stash I thought you might enjoy:

    Total weight of actual makeup product excluding packaging: 17.5lbs
    Most expensive item I've purchased: #131 brush
    Number of makeup brands I've purchased from: 99

    Amount spent on makeup in US$ (yikes!):
    '05: $45 (ah those were the days)
    '06: $400 (after my sister in law got me addicted to lipglasses)
    '07: $2.4K (the addiction begins)
    '08: $3.5K (it worsens)
    '09: $4K (holy crap I spend too much on makeup)

    Value of makeup I've used up/given away/lost/shattered: $1.9K (sigh!)

    My favorite MAC items and what I've spent on them....(double yikes!)
    Eye shadows: $1,374
    Blushes: $794
    MSFs: $632
    Lipglass: $494

    Breakdown of the kind of makeup I own:
    Eye shadows: 23%
    Skincare/Raw Ingredients: 16%
    Tools (like brushes): 15%
    Lip products: 13%
    Nail polish: 12%
    Eye Liners/Mascara: 11%
    Face products: 10%

    Fragranced makeup: 69% of my makeup is unscented, followed by vanilla, tropical, rose, and floral scents. I also have a few items that unwittingly smell like butter, BBQ sauce, dust, and pickles (and this is when I bought them brand-new, not due to spoilage).

    Where I buy make up:
    24% from department store counters
    14% from freestanding stores
    14% from drugstores
    11% from online purchases
    9% from warehouse sales
    7% from multi-brand cosmetics stores like Sephora
    5% from airport duty-free

    Brand origins of my makeup:
    North America: 66% (mostly MAC!)
    Japan: 11%
    Europe: 9%
    Local Singapore brands: 7%

    How I've slowly expanded beyond my love of MAC, as evidenced by the percentage I spend on it:
    '05: 100%
    '06: 86%
    '07: 75%
    '08: 30%
    '09: 22%

    Texture of my makeup items:
    Pressed powders: 23%
    Creams: 14%
    Loose powders: 12%
    Liquids: 10%
    Glosses: 9%
    Gels: 7%
    Solids: 6%
    Baked powders: 6%

    There's more, but I'll stop boring you now

  2. #2
    Senior Member blondemafia76's Avatar
    Join Date
    Oct 2008
    Location
    The Woodlands, Texas
    Posts
    211
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: A Look into an Addict's Stash Stats

    ho.
    ly.
    sm.
    okes.

  3. #3
    Senior Member Nicala's Avatar
    Join Date
    Nov 2008
    Location
    Northridge, CA
    Posts
    880
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: A Look into an Addict's Stash Stats

    !!!!

  4. #4
    Senior Member malaviKat's Avatar
    Join Date
    Jan 2008
    Location
    (I'm a misplaced Trinidadian!)
    Posts
    684
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: A Look into an Addict's Stash Stats

    Okay so... let me just say that the OC(D) in me is in love with you.
    MUFE 173/NC43/45
    My makeup vanity !
    Blog contribution: Polish or Perish !
    Personal: The Edge of Insanity !

  5. #5
    Senior Member Vixxan's Avatar
    Join Date
    Feb 2009
    Location
    Florida
    Posts
    518
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: A Look into an Addict's Stash Stats

    I can relate. I keep mine in Access database. I would love to know how to do it in Excel.

  6. #6
    Senior Member n_c's Avatar
    Join Date
    Jul 2006
    Posts
    7,260
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: A Look into an Addict's Stash Stats






  7. #7
    Senior Member nunu's Avatar
    Join Date
    Feb 2007
    Location
    UK
    Posts
    17,344
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: A Look into an Addict's Stash Stats

    Wow..!
    NC42/Black hair/Dark brown eyes

  8. #8
    Senior Member coachkitten's Avatar
    Join Date
    Mar 2006
    Location
    Redmond, WA
    Posts
    10,566
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: A Look into an Addict's Stash Stats

    Wow! I am impressed with how oraganized you are!

  9. #9
    Senior Member Boasorte's Avatar
    Join Date
    May 2009
    Location
    In one of the original 13 colonies
    Posts
    1,802
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: A Look into an Addict's Stash Stats

    I can't even keep my room clean for more than a week, let alone keep an Excess file on makeup!
    Well done

  10. #10
    Senior Member Diva4eva122's Avatar
    Join Date
    Feb 2011
    Posts
    142
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    wow that is a lot yo

  11. #11
    Senior Member ThePowderPuff's Avatar
    Join Date
    Oct 2009
    Location
    Copenhagen, Denmark
    Posts
    982
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I know this is an old thread but I freaking love it! And my husband is an excell geek and if I tell him this he will want to marry you instead!

  12. #12
    Senior Member eyebrowless's Avatar
    Join Date
    Jun 2007
    Location
    Vancouver, BC - Canada EH
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Vixxan View Post
    I can relate. I keep mine in Access database. I would love to know how to do it in Excel.
    omg are you kidding!? if you have no problem with access and making a database, excel is a piece of cake!!!! picture tables, just tables.. no ID's, no relationships, no switching back and forth to design view.... and more...
    Have YOU gone to MAC today?

  13. #13
    Senior Member RaizinnthaSun's Avatar
    Join Date
    Apr 2008
    Posts
    201
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wow! Being able to see that data is amazing!

  14. #14
    Member AngieM's Avatar
    Join Date
    Aug 2012
    Location
    Sydney
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    My gosh!! That excel file of yours gets quite a workout with all the editing you must do! I don't think i'd ever have the patience to input all that data everytime i made a purchase!! Nice work!!
    “Everything has beauty, but not everyone sees it.”

  15. #15
    Senior Member Ivonne383's Avatar
    Join Date
    Jul 2012
    Posts
    243
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)


  16. #16
    Senior Member Naughtyp's Avatar
    Join Date
    Sep 2012
    Location
    CALI
    Posts
    3,160
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'd be too scared to see how much $$$ I spend on it lol. I was kinda figuring out how much I'll spend in the next 2-3 months and its too much. way too much!! ;(

  17. #17
    Member maggers071511's Avatar
    Join Date
    Dec 2012
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wow, I think it's neat that you thought to do that and take the time to keep it up to date.

Display all images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •