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 40
2/7/13 at 6:47am
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.
Reply
Reply

Features on Basenotes

Greatest Hits: Annick Menardo
Basenotes Reader Awards 2013 - Finalists Announced.
Petals Falling From The Sky - A Report From The Cote d'Azur's Bataille De Fleurs
post #2 of 40
2/7/13 at 7:01am
No, I only keep track of my fragrances via the online wardrobe here and fragrantica
Reply
Reply
post #3 of 40
2/7/13 at 7:04am
Yes, I do this. For samples (I have almost a thousand of them!)
Reply
Reply
post #4 of 40
2/7/13 at 7:04am
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?
Reply
Reply
post #5 of 40
2/7/13 at 7:07am
I don't do this as my time is limited but it would be a great idea to have a list for insurance purposes.
Reply
Reply
post #6 of 40
2/7/13 at 7:07am
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
Reply
Reply
post #7 of 40
2/7/13 at 7:24am
Yes. Only way I can keep track.
Reply
Reply
post #8 of 40
2/7/13 at 7:27am
I just about keep my BN wardrobe up to date, though I rarely look at it.
Spreadsheets make my head spin.
Reply
Reply
post #9 of 40
2/7/13 at 7:52am
I've neither the patience or the inclination.
Reply
Reply
post #10 of 40
2/7/13 at 7:57am
No, I just use the wardrobe function on here, Fragrantica and Parfumo.
Reply
Reply
post #11 of 40
2/7/13 at 8:02am
Thread Starter 
Quote:
Originally Posted by hednic View Post

Yes. Only way I can keep track.

You probably need a seperate server!!!
Reply
Reply
post #12 of 40
2/7/13 at 8:20am
  • rum
  • offline
  • Gender:
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!!
Reply
Reply
post #13 of 40
2/7/13 at 8:21am
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?
Reply
Reply
post #14 of 40
2/7/13 at 9:14am
No. Just the BN wardrobe.
Reply
Reply
post #15 of 40
2/7/13 at 10:00am
yes for my hundreds of samples...
Reply
Reply
post #16 of 40
2/7/13 at 10:10am
A simple spreadsheet with perfume name, brief comment, grade (good/bad etc), and whether I own it, to buy, or don't buy.

cacio
Reply
Reply
post #17 of 40
2/7/13 at 12:34pm
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.
Reply
Reply
post #18 of 40
2/7/13 at 1:13pm
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
Reply
Reply
post #19 of 40
2/7/13 at 2:42pm
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..
Reply
Reply
post #20 of 40
2/7/13 at 2:43pm
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.
Reply
Reply
post #21 of 40
2/7/13 at 3:54pm
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!!!
Reply
Reply
post #22 of 40
2/7/13 at 5:10pm
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.
Reply
Reply
post #23 of 40
2/9/13 at 5:07pm
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.
Reply
Reply
post #24 of 40
2/9/13 at 5:40pm
I want to do something like this but i suck at spreed sheets
Reply
Reply
post #25 of 40
2/10/13 at 8:02am
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
Reply
Reply
post #26 of 40
2/10/13 at 2:48pm
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.
Reply
Reply
post #27 of 40
2/10/13 at 2:53pm
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?
Reply
Reply
post #28 of 40
2/10/13 at 4:29pm
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
Reply
Reply
post #29 of 40
2/10/13 at 7:49pm
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.
Reply
Reply
post #30 of 40
2/10/13 at 8:25pm
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!
Reply
Reply
post #31 of 40
2/11/13 at 5:24am
Just using the Fragrantica wardrobe thingy and only for the scents I dislike, though I usually remember what I've tried before/own, etc.
Reply
Reply
post #32 of 40
2/11/13 at 9:29am
I've thought about it before. I just don't find 'data entry' fun.
Reply
Reply
post #33 of 40
2/11/13 at 10:28am
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)
Reply
Reply
post #34 of 40
2/23/13 at 2:20pm
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!
Reply
Reply
post #35 of 40
5/17/13 at 9:41am
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! 

Reply
Reply
post #36 of 40
5/17/13 at 9:52am

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.

Reply
Reply
post #37 of 40
5/17/13 at 11:33am

A Microsoft Access database template has worked well for me.

Reply
Reply
post #38 of 40
5/17/13 at 11:17pm
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
Reply
Reply
post #39 of 40
5/19/13 at 7:44pm
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.
Reply
Reply
post #40 of 40
5/19/13 at 8:17pm

Fortunately not.

 

I used to make a hell of a lot of lists of things I wanted to buy, though. I'd fill up both sides of the page with at least a hundred fragrances on each side. I had stacks of those lists. I'd make a new one every few days. That was a long time ago. I bought most of them. I sold a hell of a lot of them, too. I still keep a list, but it's a lot shorter. :-)

Reply
Reply
New Posts  All Forums:Forum Nav:
  Return Home

Features on Basenotes

Greatest Hits: Annick Menardo
Basenotes Reader Awards 2013 - Finalists Announced.
Petals Falling From The Sky - A Report From The Cote d'Azur's Bataille De Fleurs
Basenotes › Basenotes Forums › Fragrance Discussion › Fragrance Industry and General Fragrance Discussion › Do you have a spreadsheet/Database detailing your collection?