Import Keg Punk Data into Excel

Updated: Apr 15

NOTE: The Keg Punk Dashboard is only compatible with Keg Punk 2.0 or later.


Keg Punk by itself is awesome. Keg Punk and a specially built Excel workbook is even better. With the Keg Punk Dashboard workbook you can import your taproom data and automatically generate some kick-ass visuals to take your brewery to the next level.


Check out the guide below on how to import data into the Keg Punk Dashboard workbook.


JUMP TO SECTION:

FIND KEG PUNK LOG FILE

TRANSFER TO PC

IMPORT TO WORKBOOK

DASHBOARD

HELP!




FIND THE KEG PUNK LOG FILE


On the Raspberry Pi running Keg Punk, open File Manager from the menu. The file you're looking for is called "Log.csv". Unless you've changed things around, the file will be at:


/home/pi/Arithmech/KegPunk/Inventory


The Inventory folder is where your data files are stored
The Log file captures data whenever you "Empty" a keg through the Taproom tab or Allocation

Once you've found the file, copy it from the Raspberry Pi to your PC. You can either copy/paste the file onto a flash drive or email the file to yourself and retrieve it on your PC.



Back to Top

IMPORT TO WORKBOOK


Open up the Keg Punk Dashboard workbook and click "IMPORT"



SELECT THE LOG FILE


Navigate to wherever you saved the Log file, select it and click "Open"


The import process will take a few seconds. You should get a confirmation message if everything went smooth.

Each row of data represents an emptied keg or tank. The data you see is everything you've emptied through the Taproom tab, or allocated through the Cellar tab.

Back to Top

DASHBOARD


The Dashboard tab sums up the imported data.


Use the INPUT YEAR slicer in the top left to narrow down the data to a specific year, or view multiple years worth of data.




PRINT


If you prefer to print up a hardcopy, head to the Dashboard (printable) sheet and hit ctrl+p to get a preview and print.


Back to Top

HELP!


Go to our HELP post for problems and FAQ's


CONTACT US

Go to Contact Page

Email directly: patrick@arithmech.com

If you like Keg Punk let us know and spread the word! If you hate Keg Punk, then for Punk's sake, LET US KNOW!

Cheers Y'all!



Recent Posts

See All

Arithmech Analytics

New Orleans, LA

  • YouTube
  • Facebook Social Icon
  • Instagram Social Icon