Using examples from a new Wine Cellar Management Tool, this report describes the many spreadsheet-based analyses in this tool that can assist an individual, restaurant, or bar to manage a wine cellar. If one is disciplined about recording the inflows and outflows to and from the cellar, the spreadsheet tool will provide several cellar analyses. In addition to providing insight into the key questions of what to consume and what to promote, the tool shows such interesting and informative analyses as appellations, vintages, and types of wine. In the tool described in this report, the spreadsheet itself incorporates form-based sets of data entry fields. The Wine Cellar Management Tool, which is available at no charge from The Center for Hospitality Research at Cornell University, does not require actual knowledge of how to construct a spreadsheet. It does require diligent data entry regarding wine purchases and withdrawals.
Thompson, G. M. (2009). Managing a wine cellar using a spreadsheet 2.0 [Electronic article]. Cornell Hospitality Report, 9(9), 6-23.