Templates in this section are designed to aid data collection and promote good data keeping practices. In most cases, you will find a form to be used during data collection, and a tab for historical data storage in a wide format that will facilitate analysis and can aid integration with other software. If batches in your brewery are unique, the unique ID column in each template can be used to combine datasets.
Fermentation
These fermentation templates are designed to be an aid for tracking active fermentations for a single brand. Up to three current fermentations can be plotted and tracked at a time. Export data to the historical tab to compare to future fermentations with the goal of identifying atypical fermentations.
R Resources
The ASBC Craft Beer Subcommittee has been working on ways to simplify data collection in a way that is both brewer and computer friendly. First, by creating basic forms to facilitate fast and easy data collection of common brewing processes with the ability to easily build a historian dataset for your brewery. Second, the committee has worked to create a R-based template which can be downloaded and used to easily visualize current fermentations and brewhouse data. The posted scripts are fully functional as-is, but also are meant to be a starting point. You are free to edit as necessary to meet your own needs. R software is open source and free.
Sensory
The Sensory Evaluation Ballot contains three methods of data collection. The first two forms are designed to be printed and distributed to collect free-form responses, as well as True To Brand ratings of existing brands. These forms can be easily transferred to a historian tab to keep a record of your brands sensory history.
Beer
Brew Sheet Workbook
-
The Brew Sheet workbook is intended to provide a template for brewhouse data collection and maintain a simple historical log.
VDK Calculator
Yeast
The Yeast Counting template is intended to be used along with the Microscopic Yeast Cell Counting Method (Microbiology Yeast – 4) and the Dead Yeast Cell Stain method (Microbiology Yeast - 3A). The Microscopic Yeast Cell Counting Method is a procedure for determining yeast cell concentration using a hemocytometer and a microscope. This template provides areas to enter counted cells and will perform calculations to determine total cell concentration and viability.