1. #1
    Senior Member stickles's Avatar
    Join Date
    Jan 2007
    Location
    Singapore
    Posts
    214

    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

    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
    931

    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

    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
    619

    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

    Re: A Look into an Addict's Stash Stats






  7. #7
    Senior Member nunu's Avatar
    Join Date
    Feb 2007
    Location
    UK
    Posts
    17,779

    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
    11,298

    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,832

    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
    wow that is a lot yo

  11. #11
    Senior Member ThePowderPuff's Avatar
    Join Date
    Oct 2009
    Location
    Copenhagen, Denmark
    Posts
    1,021
    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
    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

  14. #14
    Member AngieM's Avatar
    Join Date
    Aug 2012
    Location
    Sydney
    Posts
    64
    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

  16. #16
    Senior Member Naughtyp's Avatar
    Join Date
    Sep 2012
    Location
    CALI
    Posts
    3,167
    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
    Wow, I think it's neat that you thought to do that and take the time to keep it up to date.

Posting Permissions

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