Could any of y'all who have these ginormous MAC collections and have catalogued them on spread sheets show me an example of how you've done it? I'd like to actually see some of your spreadsheets.

My collection is getting HUGE, and I really need to list it all out somewhere.

TIA!!!

seriously! and if somebody could whip up a macro or an easy-inventory program that'd be awesome too. LOL.

(i myself just have a janky word document in columns. lol.)

I just keep a little notebook. Categorizing the pages as "Eyeshadows" "Lipsticks" "Limited Edition Collection items" "Brushes" You get the idea

I keep a list on my PDA, otherwise I'm likely to accidently pick up doubles.

__________________

• If you're a Sydney resident with retail experience who wants to work in a high energy city-central cosmetics concept store over the holiday season, please PM me!
• A short guide to the swatch forum
• make-up swatches

i want a pda i have a excel spreadsheet on disk

__________________
6° 46'N 58° 10'W

i have a spread sheet. i mark if i have them, if it's a reg e/s, LE, D/C, or pro. then if i can/know the texture, i'll put that, and if i know the collection it was in and when it was d/c'd.

so the spreadsheet calculates how many e/s i have, how many LE e/s, etc.

That is such a great idea.Thank god I pretty much know everything I have so I don't go out and buy doubles because I'm sure a lot of girls do that.I think I need a PDA now hah!

Anne, PM me your email, and I'll send you what i've started...I think I did one basket of stuff so far...

I have an Excel spreadsheet where I just put the name of the color, the product type (eyeshadow, Pigment, CCB, etc.), and the price. I sort it first by product type alphabetically, and then all the things in each product type are alphabetized. I used to have one where I also put the color family and the intended use (eyes, lips, multipurpose) so that I could run analyses of my collection in SPSS to see what kinds of colors in what kinds of products I buy the most (because I am a big dork), but I kind of gave up on that.

I have a monstrously huge-antic, ginormous collection, so I made an Access database. It tracks products and their stats (LE, DC, if I own it or not, collection launched with, etc), collections, and other misc info. Next step is to add the graphics of all the collections and pics of products.

I did this to keep track of my MAC, so I don't buy the same thing twice and to keep my Access skills sharp. Durrrr, I am a fucking geek! I am like the Napolean Dynomite of MAC, "I have MAC and Access skillllz". I am still tweaking it, but it is looking good so far.

__________________

I have a spreadsheet too in excel but mine has separate tabs at the bottom for different things.. i have one tab for 15 pan palletes, one for blush palettes, one for when i buy items - i put what i bought and how much i spent, that way i can keep track of my spending on certain things. I have a looks tab where I put down favorite eye and lip combos. Hmm..I have a wants list tab where I put down what Im looking to buy and any items im waiting for in the mail. And then i have a tab for my inventory separated by lipstick, lipglass, pigments, etc. wow...im a loser..lmao..heres a screenshot of it
sorry it came out shitty but u get the idea - im linking to it cause for some reason it didnt paste right either..grrrrr

hope this helps!

http://i9.photobucket.com/albums/a62/lola336/MAC.jpg

__________________
"Maybe some women aren't meant to be tamed. Maybe they're supposed to run wild until they find someone -- just as wild -- to run with."
-Carrie, Sex & the City

http://www.myspace.com/lola336

I used to just have a plain, old document in Word where I would list things under category by year etc., but my computer crashed recently & I lost all of it! Of course I never thought I'd need to back it up so I'll just have to do it again. *sigh* But this time I'm going to do it in Excel for better organization. We'll see....

__________________

I don't have a huge collection, but I do keep my organized on a spreadsheet. I also have a seperate word document for my wishlist. I just organized under colour with a ^ if its LE and than have a seperate column to list all my LE & Dicontinued stuff.

http://img.photobucket.com/albums/v1.../macscreen.jpg

for the people that put the prices down, do you change them when there are price changes??

I heard Access is a pretty great help with keeping an eye on larger collections!

I have an Excel spreadsheet with... a growing number of tabs. First is overall Lip stuff, listing just color by product (lipstick, lipglass, chromeglass, etc.) Second is overall Eye stuff, listing just color by product (eyeshadow, powerpoints, glitter liners, etc.) Then there's a Face/Multipurpose page, with colors listed by products (blushes, CCBs, pearlizers, pigments, etc.)

Then there's the detail pages, of which I've only done 3 so far. The Eyeshadow Detail page lists the color name, finish, whether I have pan, pot, or both, collection name, size, and top type (flip or screw). The Lipstick detail has color name, finish, and collection name. The Lipglass/Lustreglass detail just has color name and collection.

There's also a page for postcards/promos, but I'm still looking into a better way to organize that.

This is a listing only of what I have, not the whole product line and what I have of it. I haven't marked limited or permanent, or discontinued, but I think that's pretty easy to figure out with printouts of the Specktra color stories pages.

Mare

well u can infer that from the prices u pay...like i have one spreadsheet for cost. one column is the item name, next column is the price. the third column is the total from that particular transaction. so i group them by when i got it...that way i keep track of what i pay for when i get things either from mac, ebay, spectra...etc. That way i ca