Difficulty:
This just requires a quick read and downloading of the Excel file or creating your own. What you do from here is up to you. You’ll be able to download my file at the end of this post.
Affiliate Links
Background:
I really love Gantt charts and how they can help you to be organized. Microsoft Project is either a really good or really bad tool to use (depending on who you ask). I actually like it for projects that I manage at work, but I don’t get into the fine details. I just use it for basic timelines, since it really helps me see the big picture. I started looking at using it for my fermentation schedules, but in brewing, your yeast are on a 24/7 schedule and I was finding all sorts of roadblocks in using 24 hour schedules in Project.
I ultimately decided to go back to my old trusted Excel spreadsheets for this task. This format has served me well for the last two years. I don’t claim that this is the ultimate way to do it, but it might at least serve as inspiration for someone else to create something grander.
Hover or click on each section to learn how I use this sheet.
Sorry, image map is currently out of order. Please use the descriptions below to see how each section is used.
[imagemap id=”1206″]
Conclusions:
Like I said, I hope that this helps a fellow brewer out for mapping out their schedule or inspires another to build on this or create their own. Happy Brewing!!
Download the spreadsheet by subscribing:
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
By clicking on the download, you agree to the terms of this license and to be added to the awesome fermware.com subscriber list. Don’t worry, you won’t receive a bunch of trub in your inbox.
All info below is a repeat for those whose browsers or mobile devices don’t like the image map format.
Beer Description and Basics:
Yeast Color Codes:
I heard on one of the brewing podcasts that you can actually go 8+ generations with really healthy yeast, but since I’m not in any kind of production capacity, I’m usually at the third generation before I’ve reached the end of my step ups.
Dates:
Very Top Row:
Gantt Chart:
Conclusions:
Like I said, I hope that this helps a fellow brewer out for mapping out their schedule or inspires another to build on this or create their own. Happy Brewing!!