SSSVEDA Day 27: Calculating Wine Bottles, Glasses, Ounces & Milliliters

Download the workbook here: http://datascopic.net/wine-calc

This video is the result of someone at a wine restaurant who said he had transaction data by the glass and bottle but wanted a final calculation of “number of bottles” at the end of the week.

Here’s high-speed footage of my actual development. I had no idea how I’d approach this until I turned the camera on.

Please subscribe to my channel and let me know your real-world needs with Excel. Maybe it’ll turn into a video.

Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336

My blog: http://datascopic.net/blog2-2