Wine Cellar Management Excel

It s also perfect if you are running a bar or restaurant where you need to keep track of even more data such as prices.

Wine cellar management excel.

They have even provided a template based on an excel spreadsheet for wine cellar management. Ct has disadvantages in usage when you want to have an overview over big parts of your cellar wheras excel enables you to see huge 2 dimensional grids at one glimpse. This is a great way to see how the uncorked cellar works with your inventory. Preview of the wine cellar inventory with excel.

Esommelier has been the world s leading wine cellar management system since 2003. Wine cellar inventory spreadsheet wine pricing sheet jpg wine cellar inventory spreadsheet bulkfaq clip image032 jpg wine cellar inventory spreadsheet screen shot 2015 02 03 at 4 24 24 pm png. As usual these templates are available as xlsx and xltx files as well as zip. A simple cellar book is adequate for keeping track of your collection.

Note the acquisition price and if applicable the wine s rating or score. Wine management made simple. List the location of the wine the name of the winery or producer the vintage and the number of bottles in storage leaving a blank column to adjust for depletions. Once programmed excel is easier and much quicker to use but that s only my personal view.

Used by over 5 000 private collectors around the world esommelier has been helping sophisticated wine collectors keep track of what wine they have where it is stored and when they should drink it. Cellar is a harmless app that does the absolute bare minimum when it comes to wine management. If one is disciplined about recording the inflows and outflows to and from the cellar the spreadsheet tool will provide several cellar analyses. Excel is great whether you have a small wine rack or an entire cellar.

1 thought on wine cellar inventory management paul. Excel offers enough room for good location tracking and drinking windows. The cornell center of hospitality research uses excel. Winecellar inventory with excel free download of the excel winecellar inventory list.

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.