Basenotes › Basenotes Forums › Fragrance Discussion › Fragrance Industry and General Fragrance Discussion › Do you have a spreadsheet/Database detailing your collection?
New Posts  All Forums:Forum Nav:

Do you have a spreadsheet/Database detailing your collection?

post #1 of 39
Thread Starter 
I have to say, I am a geek when it comes to this. I have an excel spreadsheet with all of my Frags/Houses/Ratings/frequency of wearing and various other stuff. Anybody else do this? Would be interesting to see how others record their collections.
post #2 of 39
No, I only keep track of my fragrances via the online wardrobe here and fragrantica
post #3 of 39
Yes, I do this. For samples (I have almost a thousand of them!)
post #4 of 39
Hi Dailey. I have handwrtitten notes in notebooks. Not of wears but of impressions, scores, wishes, wants, to try's/buys etc, sometimes brief, sometimes stuff that might to go on to become a review. I want to get them tidied up and onto an elctronic format but what I really want is a nice Alphabeticised Journal and I can't find what I am looking forward. Any ideas?
post #5 of 39
I don't do this as my time is limited but it would be a great idea to have a list for insurance purposes.
post #6 of 39
Thread Starter 
Quote:
Originally Posted by Foustie View Post

Hi Dailey. I have handwrtitten notes in notebooks. Not of wears but of impressions, scores, wishes, wants, to try's/buys etc, sometimes brief, sometimes stuff that might to go on to become a review. I want to get them tidied up and onto an elctronic format but what I really want is a nice Alphabeticised Journal and I can't find what I am looking forward. Any ideas?

Can't really help with the Journal, but I'm sure there is something that will suit what you want. Could be quite a job transfering all that info though
post #7 of 39
Yes. Only way I can keep track.
post #8 of 39
I just about keep my BN wardrobe up to date, though I rarely look at it.
Spreadsheets make my head spin.
post #9 of 39
I've neither the patience or the inclination.
post #10 of 39
No, I just use the wardrobe function on here, Fragrantica and Parfumo.
post #11 of 39
Thread Starter 
Quote:
Originally Posted by hednic View Post

Yes. Only way I can keep track.

You probably need a seperate server!!!
post #12 of 39
Quote:
Originally Posted by jasonx View Post

No, I only keep track of my fragrances via the online wardrobe here and fragrantica

Quote:
Originally Posted by gandhajala View Post

I just about keep my BN wardrobe up to date, though I rarely look at it.
Spreadsheets make my head spin.

Quote:
Originally Posted by Hayven View Post

No, I just use the wardrobe function on here, Fragrantica and Parfumo.

Quote:
Originally Posted by Dailey View Post

You probably need a seperate server!!!

Me too, which is why I miss this feature now that BN has had to take it off line!!
post #13 of 39
Not yet, but I do have some experience with issuing spreadsheets/even database-like overview documents for professional uses, why not try it for recreational/hobby-related uses too?
post #14 of 39
No. Just the BN wardrobe.
post #15 of 39
yes for my hundreds of samples...
post #16 of 39
A simple spreadsheet with perfume name, brief comment, grade (good/bad etc), and whether I own it, to buy, or don't buy.

cacio
post #17 of 39
Yes.

I've recently given up on using the Basenotes wardrobe, as I am unable to breakdown and organise my wardrobe the way I would like. Furthermore, waiting for something to be added to the directory can often be a pain.

My spreadsheet is pretty simple, featuring basic information, preferred photos of the fragrances owned, quantity in possession, and an annual log of what was acquired and sold off. Gradings and number of wearings are a no-no, as I find that a waste of time (if a fragrance falls out of favour, I'll instinctively know). Commercial fragrances are kept on one tab, and absolutes, essential oils, etc. are kept on another.

Using a spreadsheet gives me more freedom.
post #18 of 39
Thread Starter 
Quote:
Originally Posted by Trebor View Post

Yes.

I've recently given up on using the Basenotes wardrobe, as I am unable to breakdown and organise my wardrobe the way I would like. Furthermore, waiting for something to be added to the directory can often be a pain.

My spreadsheet is pretty simple, featuring basic information, preferred photos of the fragrances owned, quantity in possession, and an annual log of what was acquired and sold off. Gradings and number of wearings are a no-no, as I find that a waste of time (if a fragrance falls out of favour, I'll instinctively know). Commercial fragrances are kept on one tab, and absolutes, essential oils, etc. are kept on another.

Using a spreadsheet gives me more freedom.

A man after my own heart lol
post #19 of 39
I generally use the wardrobe function to monitor but the way its been failing lately, i think I'll need to compile a database for myself..
post #20 of 39
Thread Starter 
Quote:
Originally Posted by hedonist222 View Post

I generally use the wardrobe function to monitor but the way its been failing lately, i think I'll need to compile a database for myself..

When I created my spreadsheet, I cut and paste the main data from my wardrobe on here.
post #21 of 39
I have not done this yet, but I've thought about doing it. I've done it before with other hobbies and ended up spending so much time initially entering all the information into the database that I think I really upset my wife. I'm already walking on thin ice with my fragrance addiction, so I haven't decided to go there with the database yet!!!
post #22 of 39
My electronic record consists of a simple inventory list, and then a journal where I log what I'm wearing, when and my impressions and rating of it on that day. I stay away from any costings list. ha ha.
post #23 of 39
I, too, tend to be geeky in that way. But also quite busy and usually a little overwhelmed. So I created a very nicely organized Excel spreadsheet to track my sampling and purchases....and have totally failed to keep up with it in any kind of consistent way.
post #24 of 39
I want to do something like this but i suck at spreed sheets
post #25 of 39
Yes. I've been growing one for maybe 5 years. It's currently 16MB.

I've got tabs for:
Inventory / Samples & Decants / Oud Oil / Wish List / My Own Mixes / Ideas / Cigars
Tea / Scotch / Soy Candles / Supplies / Glossary / Abbreviations / Conversions

In Inventory, I populate the following colums for each bottle:
HouseName / CologneName / YearMade / MyRating / SourceStore / Class / TopNotes/Mid/BaseNotes / TotalCost / Size / CostPerOz / 10WordReview / BNScore / Concentration / LayeringIdeas
post #26 of 39
I have an index card somewhere in my drawer of what i have (what to keep, what to sell), what to try and what to buy. that's it though - no spreadsheet or anything.
post #27 of 39
I've never resorted to a spreadsheet but I keep all my frags and ingredients in alphabetical order and keep records on index cards. Anyone care to point me in the direction of an easy one for a numpty to use?
post #28 of 39
I have a sheet for EdT/EdP full bottles, one for samples and one for AS Splashes.

House / Name / Family / Top / Middle / Base / Size / Notes
post #29 of 39
I have been using the "notes" app on my ipad to track my samples. It's very elementary though. I like the in-depth spreadsheets that some of you use though. Somebody go create an app for us non-creative types.
post #30 of 39
Here is my spreadsheet as it stands...

Fragrances Spreadsheet on DropBox

Please feel free to use it as a basis for your own, laugh at it, tickle it or otherwise abuse it

In addition, any comments, tips or suggestions on how to improve it would be gratefully received (although this is a .xls export of the master .numbers file so some some things don't render exactly the same).

Finally any comments on my wardrobe are equally welcome (and yes, I'm well aware I have no Creed - yet!)

Enjoy folks!
post #31 of 39
Just using the Fragrantica wardrobe thingy and only for the scents I dislike, though I usually remember what I've tried before/own, etc.
post #32 of 39
I've thought about it before. I just don't find 'data entry' fun.
post #33 of 39
I did, but it just seemed to weigh me down and got tiresome to update.


Now I just gaze at my collection...no real need for a spreadsheet.


(Oh, also I used to put the price I paid in there...but that just got depressing)
post #34 of 39
I do this for my collection, samples and decants. It started as an index to keep track of my samples (each has a number) and it grew from there. It now includes name; house; index number (for samples); fragrance family, group, and sub-group (Michael Edwards); perfumer; rating from The Guide and brief description from The Guide (Turin & Sanchez); my rating; ratings from various perfume blogs; note breakdown; bottle designer; year launched; years major reformulations occurred; and batch number. That's all I can remember off the top of my head. I get really stoked about stuff like this; also, the spreadsheet format is great for sorting and grouping data!
post #35 of 39
Thread Starter 
Quote:
Originally Posted by dlegros View Post

Here is my spreadsheet as it stands...

Fragrances Spreadsheet on DropBox

Please feel free to use it as a basis for your own, laugh at it, tickle it or otherwise abuse it

In addition, any comments, tips or suggestions on how to improve it would be gratefully received (although this is a .xls export of the master .numbers file so some some things don't render exactly the same).

Finally any comments on my wardrobe are equally welcome (and yes, I'm well aware I have no Creed - yet!)

Enjoy folks!

Nice sheet mate, thanks for posting. Mine has got more and more in depth, I know it's geeky, but I actually get a buzz out of it! 

post #36 of 39

Old school, I have a perfumes notebook covers 44 years and 3 small handmade journals with recipes of my diy perfume, toiletries, grooming vinegars...

 

I think for on the pc you could maybe copy what the old perfumery books in the factories looked like where they used to write their formulas as a sort of page background if you like a vintage/antique look.

post #37 of 39

A Microsoft Access database template has worked well for me.

post #38 of 39
That would require me to confront the amount I have. That's one dirty little secret I'd prefer to keep sweeping under the carpet lol
post #39 of 39
No, but my collection is not large. I have more samples and decants than I do FBs. I'm not really inclined toward maintaining a spreadsheet for any reason to be honest.
New Posts  All Forums:Forum Nav:
Basenotes › Basenotes Forums › Fragrance Discussion › Fragrance Industry and General Fragrance Discussion › Do you have a spreadsheet/Database detailing your collection?