Welcome to the Straightbourbon.com Forums.
Results 1 to 10 of 10
  1. #1
    Connoisseur
    Join Date
    Nov 2011
    Location
    Cincinnati
    Posts
    794

    Tracking Spreadsheet/Log

    I am looking to start a spreadsheet for myself. This file will contain distilleries, their different products, mashbills, proof, age, my tasting notes, ect. I was wondering if anyone had something I could leverage? I don't want to step on any toes or take advantage of someones labor of love, just wanted to get a starting point. I will end up putting current products and non-production products. Being new, The non-production stuff will give me starting points on doing some history reviews of these products to learn more about all things bourbon. Any help will be appreciated, but if not no worries.


    Sent from my iPhone using Tapatalk
    Last edited by fishnbowljoe; 12-09-2011 at 19:56.

  2. #2
    Disciple
    Join Date
    Jun 2010
    Location
    Northern Indiana
    Posts
    1,661

    Re: Tracking Spreadsheet/Log

    Won't help with the format, but this thread will give a lot of the info you might wish to log:

    http://straightbourbon.com/forums/sh...t=whiskey+tree

  3. #3
    Moderator
    Join Date
    Mar 2008
    Location
    Illinois
    Posts
    4,329

    Re: Tracking Spreadsheet/Log

    Quote Originally Posted by Ejmharris View Post
    I am looking to start a spreadsheet for myself. This file will contain distilleries, their different products, mashbills, proof, age, my tasting notes, ect. I was wondering if anyone had something I could leverage? I don't want to step on any toes or take advantage of someones labor of love, just wanted to get a starting point. I will end up putting current products and non-production products. Being new, The non-production stuff will give me starting points on doing some history reviews of these products to learn more about all things bourbon. Any help will be appreciated, but if not no worries.


    Sent from my iPhone using Tapatalk
    There are two or three older threads about that. Try using the search function.

    Here's one to get you started. http://www.straightbourbon.com/forum...el+spreadsheet

    Cheers! Joe
    " I never met a Weller I didn't like"

  4. #4
    Connoisseur
    Join Date
    Dec 2011
    Posts
    948

    Re: Tracking Spreadsheet/Log

    If anyone needs help creating a relational database 'o bourbon, I can certainly help. It would be cool to query bourbons based on year, proof, distillery, mashbill, etc. Say I wanted to see all wheaters that are barrel proof...

  5. #5
    Connoisseur
    Join Date
    Jul 2009
    Location
    Arlington, TX
    Posts
    746

    Re: Tracking Spreadsheet/Log

    Quote Originally Posted by Ejmharris View Post
    I am looking to start a spreadsheet for myself. This file will contain distilleries, their different products, mashbills, proof, age, my tasting notes, ect.
    A database would be a lot more maintainable than a spreadsheet, and much more effective to search.
    Mark Edwards - Proof of Sanity Forged Upon Request

  6. #6
    Apprentice
    Join Date
    May 2007
    Posts
    49

    Re: Tracking Spreadsheet/Log

    I use the template on Bento that Adam from LA Whiskey Society created, as Fishnbowljoe mentioned. It is easy to use, is customizable, and works on iOS devices. It also exports to Excel. I use it on my Mac and I really like it. Here's a direct link.
    http://www.lawhiskeysociety.com/page.php?id=45

  7. #7
    Connoisseur
    Join Date
    Nov 2011
    Location
    Cincinnati
    Posts
    794
    Thanks to everyone for the info. Will put it to good use.


    Sent from my iPhone using Tapatalk

  8. #8
    Guru
    Join Date
    May 2005
    Location
    Eastern Pennsylvania
    Posts
    2,783

    Re: Tracking Spreadsheet/Log

    Microsoft Access creates a killer database for Bourbon.
    Joe
    Colonel Joseph B. "Bourbon Joe" Koch

    "Bourbon.....It's cheaper than therapy!!"

  9. #9
    Connoisseur
    Join Date
    Dec 2011
    Posts
    948

    Re: Tracking Spreadsheet/Log

    I agree, Access would be preferable to Excel. That said, I could throw something together in SQL Server. The benefit to this would be the mods could get the bourbon database area up and running if they can integrate this into the site. The files would also be stored in a central location so there would not be outdated/incorrect versions of a database floating around out there.

  10. #10
    Enthusiast
    Join Date
    Nov 2011
    Location
    Chicago
    Posts
    321

    Re: Tracking Spreadsheet/Log

    Quote Originally Posted by LostBottle View Post
    I agree, Access would be preferable to Excel. That said, I could throw something together in SQL Server. The benefit to this would be the mods could get the bourbon database area up and running if they can integrate this into the site. The files would also be stored in a central location so there would not be outdated/incorrect versions of a database floating around out there.
    LostBottle, if you need that SQL database replicated to Postgres, you just let me know.

 

 

Similar Threads

  1. Tracking New Releases
    By DreamTheater in forum General Bourbon Discussion
    Replies: 3
    Last Post: 11-21-2011, 08:34

Posting Permissions

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