PDA

View Full Version : Tracking Spreadsheet/Log



Ejmharris
12-09-2011, 19:49
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

Bourbon Boiler
12-09-2011, 20:49
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/showthread.php?t=15005&highlight=whiskey+tree

fishnbowljoe
12-09-2011, 20:56
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/forums/showthread.php?t=14258&highlight=excel+spreadsheet

Cheers! Joe

LostBottle
12-10-2011, 01:12
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...

MarkEdwards
12-10-2011, 04:30
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.

Khari
12-11-2011, 20:09
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

Ejmharris
12-11-2011, 20:43
Thanks to everyone for the info. Will put it to good use.


Sent from my iPhone using Tapatalk

BourbonJoe
12-14-2011, 21:26
Microsoft Access creates a killer database for Bourbon.
Joe :usflag:

LostBottle
12-14-2011, 22:11
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.

luther.r
12-14-2011, 22:52
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. :toast: