Updated: Mar 19
Note: The Keg Punk Dashboard is only compatible with Keg Punk 2.0 or later.
Keg Punk 2.0 is on the way and it's got a nerdy sidekick. The Keg Punk Dashboard is a Microsoft Excel workbook that allows you to import your taproom data and analyze the hell out of it. Open the workbook on a PC, import a single data file from Keg Punk, and BAM! Out pops a data-driven dashboard showing you stats about your brewery.
The Keg Punk Dashboard workbook will be available as an add-on for any Keg Punk package.
Get it HERE!
JUMP TO A SECTION:
HOW DOES IT WORK?
Each time you empty a keg through the Taproom tab (or allocate them through the Cellar tab) a row of data is generated and stored in a Log file.
The Dashboard workbook uses some VBA programming to look through the file, import the data, and spit out charts.
Transfer the log file to your PC via a thumb drive or email, open the workbook, then simply click IMPORT. Yeah, it's that easy.
Check out this guide for all the details.
WHAT DOES IT SHOW?
All the images below show our real Keg Punk data from brewing and serving at our partner project, Danger Shed Ales & Mead. No fake numbers here!
On the left side of the Dashboard is a year "slicer". Click a single or multiple years to view the data you want.
Minimum, average and maximum %ABV for all batches. I find this useful to see if what I'm putting through the taps has some balance. For example, if your min = 7%, average = 8.5%, and max is 11% - it's pretty clear that you brew and serve some pretty heavy stuff (and maybe that's what you're going for). But if you want balance in your draft line-up, seeing a more even spread might be what you're looking for.
# OF BATCHES INPUT
Quickly see how many batches you have added to your cellar each month.
# OF GALLONS INPUT
Quickly see the volume (in gallons) you added to your cellar each month.
What types of beer are you brewing most? For us, we seem to like our blondes, wheats, and pale ales. This chart is great for getting an unbiased view of your brewery. Do you claim to be a brewery that focuses on Belgian-style beers? Take a look at this chart to really see if that's true for your brewery.
What types of tanks or kegs are you serving from? Is it mostly half-bbl kegs? Brite tanks? Or a combination? As a home-brewery, we use 5-gallon corney kegs, so 100% of our beer is served from those. But many breweries use various types and sizes of tanks and kegs to serve their beer. This chart gives you an overview of how you are serving or distributing your beer.
AVERAGE DAYS FROM ON TAP TO EMPTY, PER KEG, BY BEER
Whoa. That's a lot going on. But stick with me because this is probably the coolest and most useful chart on the Dashboard. This shows you the life span of a keg while it's on tap. For example, a keg of High Times spent an average of 11 days on tap before it was empty. Yikes...maybe we better rethink this beer. Would it sell faster at a different time of year? Is it a high ABV beer that just naturally won't sell quickly?
Alternatively, look at Cold Summer. A keg of this beer was on tap for an average of only 3 days before it was empty. Maybe we got a winner with this one?
KEG LIFE CYCLE
How do kegs move through your brewery? This chart shows you min, average, and max times a keg spends in various states in your brewery.
Answer questions like:
How many days from brew day to when a keg is empty in the taproom? (We averaged 33 days)
How many days after we keg until the keg gets put on tap? (We averaged 9 days)
What's the average time the beer spend in the keg before it's consumed? (We averaged 15 days)
The Dashboard shows a lot of great stuff - but we know that you might want to see other metrics, different visuals, or have other options when viewing the data. We got you covered.
Almost anything about the Dashboard can be customized to your needs. We can add pages that calculate tax values for your book keeping, we can make the workbook generate official reports. You want to be able to predict your taproom sales for the next year? We can do that too.
We've been doing custom Excel contract work on the side since starting Arithmech, so we're pretty damn good at this stuff. Tell us what you want and there's a good chance we can do it.
Customization is normally billed hourly - however, for bigger projects we can talk about a flat fee. And we make payments simple with digital invoicing directly to your email.
Keg Punk is a great tool for any brewer - Home or Pro.
Check out this post to see some of the changes and improvements we've added.