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.
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.
