Code of Conduct
Results 1 to 10 of 10
  1. #1
    Dependent danieq's Avatar
    Join Date
    Jul 2013
    Location
    Southeastern Arizona
    Posts
    2,138

    Default Keeping Track of Notes Tests

    As I find myself most comfortable testing by way of notes, I've decided I'd like to begin to record what I've tested. I'm no Excel expert by any means but this seems the best method.

    I am wondering whether anyone has a good method for doing this effectively and can offer any tips or techniques, or even a template.

  2. #2

    Default Re: Keeping Track of Notes Tests

    Call me old fashioned but when I was training I used post cards to record my notes. Placed in a box in alphabetical order I would record my odour description, the official description, how long it lasted, how strong it appeared to be, and stability information and interesting chemistry etc. This was for the learning of individual Aroma Chemicals and Essential Oils, but I'm sure it could be adapted for Accords, Bases, and even Fine Fragrances. Mind you, when I started there was no Excel; imagine!
    Last edited by David Ruskin; 5th December 2013 at 10:06 AM.

  3. #3
    teardrop's Avatar
    Join Date
    Sep 2010
    Location
    The south of England
    Posts
    5,855
    Blog Entries
    3

    Default Re: Keeping Track of Notes Tests

    l didn't even own a computer when l started, so l wrote everything down in a notebook, & still do! l don't quite trust computers not to crash or something & lose all that important information.
    "What is this secret connection between the soul, and sea, clouds and perfumes? The soul itself appears to be sea, cloud and perfume..." - from Zorba the Greek by Nikos Kazantzakis.

  4. #4

    Default Re: Keeping Track of Notes Tests

    My list was done by hand. It got huge, and I gave up eventually. Now I simply refer to my reviews here.
    A spreadsheet would be great.
    Take a look at this one and tell me if it's any good:

    http://www.perfumersworld.com/page.php?id=18

  5. #5
    Basenotes Plus
    CapriDog's Avatar
    Join Date
    Mar 2012
    Location
    Sai Gon, Vietnam
    Posts
    2,980

    Default Re: Keeping Track of Notes Tests

    I am thinking of creating an excel spreadsheet to store my scent info. The below are probably my categories of interests.

    1. Fragrance Name
    2. Perfumer (Nose)
    3. Company
    4. Launched Year
    5. Reproduction (Yes/No)
    6. Size
    7. Family
    8. Top notes
    9. Mid notes
    10. Base notes
    11. Dominant note
    12. Longevity
    13. Projection
    14. Sillage
    15. Purchased Price
    16. Like or Dislike
    17. Purchased Place
    18. Purchased Year

    So let say if someone needs a suggestion for a dominant vanilla scent with good longevity and projection and reasonable price, I just filter the columns accordingly and voila. Or if I want to know how many oriental scents I have, I just filer column 7. How many bottles I bought in France? How much did I spend in 2011? Excel will provide me those info quickly when needed. A simple excel spreadsheet would be sufficient.

    I would not only save the info in my C drive but also in an external hard drive. Well, I can also save a copy in my yahoo account just in case.

    I understand the above is not what you are looking for but Excel is probably a way to go in the long run.
    Last edited by CapriDog; 4th December 2013 at 08:04 PM.

  6. #6
    hednic's Avatar
    Join Date
    Oct 2007
    Location
    McLean, NYC, & B˙zios
    Posts
    79,316

    Default Re: Keeping Track of Notes Tests

    Quote Originally Posted by CapriDog View Post
    I am thinking of creating an excel spreadsheet to store my scent info. The below are probably my categories of interests.

    1. Fragrance Name
    2. Perfumer (Nose)
    3. Company
    4. Launched Year
    5. Reproduction (Yes/No)
    6. Size
    7. Family
    8. Top notes
    9. Mid notes
    10. Base notes
    11. Dominant note
    12. Longevity
    13. Projection
    14. Sillage
    15. Purchased Price
    16. Like or Dislike
    17. Purchased Place
    18. Purchased Year

    So let say if someone needs a suggestion for a dominant vanilla scent with good longevity and projection and reasonable price, I just filter the columns accordingly and voila. Or if I want to know how many oriental scents I have, I just filer column 7. How many bottles I bought in France? How much did I spend in 2011? Excel will provide me those info quickly when needed. A simple excel spreadsheet would be sufficient.

    I would not only save the info in my C drive but also in an external hard drive. Well, I can also save a copy in my yahoo account just in case.

    I understand the above is not what you are looking for but Excel is probably a way to go in the long run.
    I wish I would have started a database with criteria as detailed as you outline above. I just have #1, #3, #6, and have added Country and Concentration. Too late for me to redo mine.
    (1152)
    Remember that while it is perfectly acceptable to criticize the content of a post - criticizing the poster is not.
    Mean spirited, nasty, snide, sarcastic, hateful, and rude individuals don't warrant or deserve other individuals' acknowledgement or respect.

  7. #7
    Dependent danieq's Avatar
    Join Date
    Jul 2013
    Location
    Southeastern Arizona
    Posts
    2,138

    Default Re: Keeping Track of Notes Tests

    Quote Originally Posted by purplebird7 View Post
    My list was done by hand. It got huge, and I gave up eventually. Now I simply refer to my reviews here.
    A spreadsheet would be great.
    Take a look at this one and tell me if it's any good:

    http://www.perfumersworld.com/page.php?id=18
    This looks like it's for a perfumer. Though I suppose anyone might use it. I get paranoid downloading stuff though.

    - - - Updated - - -

    Quote Originally Posted by CapriDog View Post
    I am thinking of creating an excel spreadsheet to store my scent info. The below are probably my categories of interests.

    1. Fragrance Name
    2. Perfumer (Nose)
    3. Company
    4. Launched Year
    5. Reproduction (Yes/No)
    6. Size
    7. Family
    8. Top notes
    9. Mid notes
    10. Base notes
    11. Dominant note
    12. Longevity
    13. Projection
    14. Sillage
    15. Purchased Price
    16. Like or Dislike
    17. Purchased Place
    18. Purchased Year

    So let say if someone needs a suggestion for a dominant vanilla scent with good longevity and projection and reasonable price, I just filter the columns accordingly and voila. Or if I want to know how many oriental scents I have, I just filer column 7. How many bottles I bought in France? How much did I spend in 2011? Excel will provide me those info quickly when needed. A simple excel spreadsheet would be sufficient.

    I would not only save the info in my C drive but also in an external hard drive. Well, I can also save a copy in my yahoo account just in case.

    I understand the above is not what you are looking for but Excel is probably a way to go in the long run.
    This looks great, except I'm not sure I want to know what I spent, just saying.

  8. #8

    Default Re: Keeping Track of Notes Tests

    Danieq, a beautiful leather bound journal, coloured inks and fountain pen are my tools of choice, I don't do it often and only when inspiration grabs me. I find the head hand connection much more organic and personal when writing verses typing. I also tend to draw and sketch impressions of the scent which makes the pages much more visually appealing than a spreadsheet.
    We live only to discover beauty. All else is a form of waiting. ~Kahlil Gibran

  9. #9
    Basenotes Plus
    CapriDog's Avatar
    Join Date
    Mar 2012
    Location
    Sai Gon, Vietnam
    Posts
    2,980

    Default Re: Keeping Track of Notes Tests

    Hednic - Yes, a concentration criteria is indeed necessary.

    Danieq - haha.. I hear ya. I sometimes don't really want to know what I have spent either. So, I don't have to filter out that criteria if I don't want to. However, the $price criteria might be useful just in case someone needs a recommendation for a scent within a certain budget.


    If someone ever gives me a bottle of his/her scents, it's fascinating to me to know a bit of the history behind it. Whether they like the scent? Did they buy it when on vacation somewhere? Yeah, I am odd, I know :-)

  10. #10
    Dependent danieq's Avatar
    Join Date
    Jul 2013
    Location
    Southeastern Arizona
    Posts
    2,138

    Default Re: Keeping Track of Notes Tests

    Quote Originally Posted by CapriDog View Post
    If someone ever gives me a bottle of his/her scents, it's fascinating to me to know a bit of the history behind it. Whether they like the scent? Did they buy it when on vacation somewhere? Yeah, I am odd, I know :-)

    Hmmm, this sounds very appealing indeed! I am very visual girl myself.

Similar Threads

  1. Replies: 13
    Last Post: 10th May 2012, 02:05 PM
  2. Wardrobe - Not Keeping Track & Not Counting Properly
    By AnthonyDG in forum Community Centre Archive
    Replies: 0
    Last Post: 10th April 2012, 09:26 AM
  3. Keeping Records and Notes?
    By Asha in forum Female Fragrance Discussion
    Replies: 22
    Last Post: 26th May 2008, 07:33 PM
  4. Keeping Track of Scent
    By steelyglint in forum Male Fragrance Discussion
    Replies: 2
    Last Post: 13th July 2006, 10:19 PM

Posting Permissions

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