Track Your Blind Tastings With This Google Sheet

Hi folks,

I had been struggling with developing a way of tracking my blind tasting and just paper and pen didn't seem to be adequate.   I was using a Google Sheet to track my tastings, but the raw data, unanalyzed, was a crime to my organized mind; I didn't have any overall view of how well I was doing.  I wanted a tool that would automatically analyze my tastings and tell me where I was doing well and help me identify my blind spots, so I spend a few hours a month ago to create something to do exactly that.

The final result can be found here: Blind Tasting Tracking BLANK.  Please make a copy for yourself to use and give it a try.  If you're looking for an example of how to fill it out, check out this example: Blind Tasting Tracking EXAMPLE.  It seems more complicated than it is, but all you really have to do is fill out the Tasting Log sheet and the rest will take care of itself.  The document has three sheets:

  • Overall Scores
    • Raw - Takes total scores from the Analysis sheet for whites/reds and sums them up
    • Including Non-Classic Examples - Rolls up the instances where you passed/failed non-classic examples into the appropriate category
    • Omitting Non-Classic Examples - Excludes non-classic examples.  This is the best indicator of how you are tasting.
  • Analysis
    • Rolls up the data from the Tasting Log sheet
    • To match between the Tasting Log sheet and the Analysis sheet you need to make sure that you are using the country code and varietal code consistently.  So Gruner from Austria becomes GV from AT.  (To add a new varietal, just insert it into the sheet and update the order so you can sort appropriately)
    • Note that varietals listed on this sheet are solely based on what I've been tasting lately for my own studies and you can modify it as you see fit by inserting a row into the sheet and adding the varietal code and country code - just make sure to use the same varietal code and country code whenever you enter anything in the Tasting Log sheet.
    • Columns
      • Ord - Order for sorting
      • Var - Varietal
      • Co - Country
      • Tasted - Sum of number tasted from the Tasting Log sheet
      • Classic - Sum of number classic examples from the Tasting Log sheet
      • P% and P Adj - Raw pass percentage and adjusted percentage based solely on classic examples
      • F% and F Adj - Raw fail percentage and adjusted percentage based solely on classic examples
      • Alm% and Alm Adj - Almost pass percentage and adjusted percentage based solely on classic examples
      • Pass, NC - Pass, but not a classic example
      • Fail, NC - Fail, but not a classic example
  • Tasting Log
    • Here's where I keep the raw data from my tastings.  The color codings are manually added after the tastings.
    •  Columns
      • Ord - Order for sorting 
      • Sc - Score
        • 1 - Pass, got country and varietal correct (my methodology does not go down to appellation to score a wine as correct, as I feel that, for my purposes, that country is sufficient)
        • 2 - Fail, missed both
        • 3 - Almost, got close enough or initialed the correct wine
        • 4 - Pass, but not a classic example
        • 5 - Fail, but not a classic example
      • Date and Loc - Day and what tasting I was at
      • First set of wine information - What you called
        • Var - Varietal for what you called, using the two digit varietal code
        • O/N - Old World, New World
        • CO - Country, using the same consistent codes (two digits for everything except USA)
        • Appellation
        • Vintage
        • Objective Factors - Notes for why you called that wine
      • Second set of wine information - What the wine was
        • Var - Varietal, using the two digit varietal code
        • Producer
        • Bottling
        • CO - Country, using the same consistent codes (two digits for everything except USA)
        • Appellation
        • Vintage
        • Objective Factors Missed - Notes for what you missed in the wine that should have lead you to the correct answer
        • Objective Factors Added - Notes for what you mentally added to the wine to make you go astray
        • Notes - Any other notes