Wine Business Consulting, Forecasting and Analysis Services
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. DOWNLOAD THE TOOL HERE: download link. If you'd like to be added have this emailed to you each year or if you have trouble downloading it, 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, nothing else).
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.
Full Tutorial Presented to California Association of Winegrowers
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