Grape Data Tool, Examples and Tutorials

The Grape Data Tool is my most popular public resources.  It distills nearly every Acreage and Crush Report since 1991 into a single Excel workbook with a quick and easy interface.  I have also added a variety of tools to make it easy to pull out a great deal of derivative data.  It saves me hundreds of hours of work every year.  I hope it does the same for you and increases the use of USDA data in our industry.  I am also, very intermittently, creating various video case study tutorials to show how to best use this tool. 

 

Its use is governed by the Free Software Foundation's General Public License.  The most recent, fully-enabled, 2017 version is available.  The 2018 version does not yet have its macro capabilities updated with the newest data, but does have the basic functionalities for data through 2018.  For technical reasons, I am no longer making the tool available for direct download from this site.  Instead, please e-mail me and I will send you the latest version and also add you to my mailing list for new releases (I will only e-mail you with Grape Data Tool updates - if you want to subscribe to this site, you have to do that through the site's subscription app).

Note that these are big files and may take a bit to download.  If you run into glitches with the tool please let me know

Below are the links to all of my video tutorials for the Grape Data Tool.  Just right click the links below and select "download link."  I will, now and again, be adding more.

Episode 1 - Basics

Episode 2 - Using a Macro to Pull Data for Every District at Once

Episode 3 - Using a Macro to Pull All Percentile Price Levels for a District (Nominal and Real)

Interactive Charts Easily Made Using the GDT:

Interactive Chart of the Last 27 Years of Napa Cabernet Prices by Percentile

Interactive Chart of the Last 27 Years of Sonoma County Pinot Noir Prices by Percentile