Who else is Type A?... or "A Braumeister Checklist"

How to get most out of brewing with your Braumeister? Help others and share your tips/best practices.

Who else is Type A?... or "A Braumeister Checklist"

Unread postby Nesto » Fri May 30, 2014 5:50 am

I promised I might do this, but I don't think Niels has enabled direct pdf or Word upload, so here is a link to my brew day check list:
http://www.slideshare.net/erniecostello/brewing-procedures-bm-v4

Who flies by the seat of their pants, and who, like me, needs to be reminded of every last step? (Including reminders to drink a beer every once in a while.)

I actually have this document (it's a Word doc, but I published a PDF to make it easier to format and print) linked to an Excel sheet where I store all the key variables (date, grains, hops, volumes, etc.) as well as store the actuals I record during brew day and while fermenting. It sounds a little complicated, but it's pretty straightforward. I do my recipe design in Beersmith. While Beersmith has timers for mash and boil, you can't really integrate it with a full checklist. So I transfer the relevant variables from Beersmith and EZ Water Calculator into my Excel sheet, which is linked so that the variables are populated into the Word doc. During the boil, I set alarms on my phone for all the additions and depth readings.

EDIT Niels: Upload of almost any file type is allowed, so I added the PDF to this post for future reference.

Brewing Procedures Braumeister-v4.pdf
(226.39 KiB) Downloaded 243 times
___________________________
Check out my brewing blog... http://www.sycamorecreekbrewing.com/
User avatar
Nesto
 
Posts: 789
Joined: Tue Jan 21, 2014 8:03 pm
Location: Northern California
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby jervell » Fri May 30, 2014 6:32 am

Wow, you've put a lot of effort into this. Thanks a lot for sharing. I'll be giving this one a good study. :-)

Edit: I also keep a custom excel sheet where I record all essentials during the brewing session. In this sheet I also duplicate much of what beersmith already is doing for me, just because I'm a control freak and need to keep all my data and processes in check.
jervell
 
Posts: 16
Joined: Wed Apr 23, 2014 1:50 pm
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby Cervantes » Fri May 30, 2014 6:55 am

Did either of you want to share your spreadsheets?

I've been considering doing something similar as I think that it will be easier to interrogate the information later and gain some useful statistics etc. from the data. It would much easier to crib from someone else hard work than to start from scratch.
Cheers :cheers:
Andy
User avatar
Cervantes
 
Posts: 475
Joined: Thu Feb 27, 2014 11:54 am
Location: Cervantes, Western Australia
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby whitegoose » Fri May 30, 2014 7:20 am

Holy shit!!! That's one epic checklist!!

I don't use any kind of checklist, but I really wouldn't call it flying by the seat of my pants either- I just know what to do! I still occasionally forget things and have to run around in a panic but that's rare.

While I am very impressed by your checklist that even with the best intentions I would stop using it after about page 2. I think I must be type B :)
User avatar
whitegoose
 
Posts: 34
Joined: Sun Jan 26, 2014 3:39 am
Location: Perth AUS
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby niels » Fri May 30, 2014 7:22 am

Wow Nesto, that's almost a manual on its own :) Thanks for sharing!

I added the PDF file to your post so other members are not forced to register at SlideShare to download.

Niels
User avatar
niels
Site Admin
 
Posts: 1054
Joined: Mon Dec 02, 2013 8:08 pm
Location: Belgium
Model: 50 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby jervell » Fri May 30, 2014 7:34 am

Cervantes wrote:Did either of you want to share your spreadsheets?


Absolutely. It's currently in Norwegian, but I can translate and post during the week end.
jervell
 
Posts: 16
Joined: Wed Apr 23, 2014 1:50 pm
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby Cervantes » Fri May 30, 2014 7:48 am

Many thanks for that.

My Norwegian is a little rusty :)
Cheers :cheers:
Andy
User avatar
Cervantes
 
Posts: 475
Joined: Thu Feb 27, 2014 11:54 am
Location: Cervantes, Western Australia
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby Cervantes » Fri May 30, 2014 7:55 am

EDIT Niels: Upload of almost any file type is allowed, so I added the PDF to this post for future reference.


Thanks Niels,

That gets me nicely around the "Net Nanny" at work.
Cheers :cheers:
Andy
User avatar
Cervantes
 
Posts: 475
Joined: Thu Feb 27, 2014 11:54 am
Location: Cervantes, Western Australia
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby Cervantes » Fri May 30, 2014 8:11 am

Nesto,

I thought that I was bad............................

I think that you may have CDO.............. It's a more severe version of OCD where the letters are in alphabetic order "As they should be" :D

Are you an engineer by any chance?
Cheers :cheers:
Andy
User avatar
Cervantes
 
Posts: 475
Joined: Thu Feb 27, 2014 11:54 am
Location: Cervantes, Western Australia
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby Dicko » Fri May 30, 2014 10:15 am

Nesto wrote:I promised I might do this, but I don't think Niels has enabled direct pdf or Word upload, so here is a link to my brew day check list:
http://www.slideshare.net/erniecostello/brewing-procedures-bm-v4

Who flies by the seat of their pants, and who, like me, needs to be reminded of every last step? (Including reminders to drink a beer every once in a while.)

I actually have this document (it's a Word doc, but I published a PDF to make it easier to format and print) linked to an Excel sheet where I store all the key variables (date, grains, hops, volumes, etc.) as well as store the actuals I record during brew day and while fermenting. It sounds a little complicated, but it's pretty straightforward. I do my recipe design in Beersmith. While Beersmith has timers for mash and boil, you can't really integrate it with a full checklist. So I transfer the relevant variables from Beersmith and EZ Water Calculator into my Excel sheet, which is linked so that the variables are populated into the Word doc. During the boil, I set alarms on my phone for all the additions and depth readings.

EDIT Niels: Upload of almost any file type is allowed, so I added the PDF to this post for future reference.

Brewing Procedures Braumeister-v4.pdf


That is one hell of a brew sheet mate....

the metric conversion on page 16 really only relates to the USA, all of us others need to use a different set of figures. :lol:

Jokes aside..very well done :cheers: :beer:
The worst thing that can happen if I die is that my wife will sell all my brewing equipment for what I told her I paid for it
User avatar
Dicko
 
Posts: 1178
Joined: Tue Jan 21, 2014 8:25 pm
Location: Port Lincoln South Oz
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby Nesto » Fri May 30, 2014 3:57 pm

I'll figure out how to upload here and put my actual Word and Excel docs up (thanks Niels for posting the PDF for me!). If you have any desire to do the cross document linking, you'll have to setup the links. I took them all out - Microsoft has implemented them so they don't move from computer to computer well.

Yes, I am an engineer :)

And yes, being in the US means I don't speak metric as my first language. Once I found out the BM display used Celsius, I figured, "why not go all metric for brewing?" I've gotten so I no longer remember what my typical saccrification rest is in Fahrenheit. But there is one kitchen instant read thermometer that I use that I can't switch easily, so I have to remind myself sparge water temp... maybe I should switch my whole kitchen to Celsius!
___________________________
Check out my brewing blog... http://www.sycamorecreekbrewing.com/
User avatar
Nesto
 
Posts: 789
Joined: Tue Jan 21, 2014 8:03 pm
Location: Northern California
Model: 20 litres

Re: Who else is Type A?... or

Unread postby Cervantes » Fri May 30, 2014 10:06 pm

Nesto wrote:I'll figure out how to upload here and put my actual Word and Excel docs up


That would be fantastic. I'd be really keen to see this. :cheers:

Nesto wrote:Yes, I am an engineer :)


:D I recognise the traits......................
Cheers :cheers:
Andy
User avatar
Cervantes
 
Posts: 475
Joined: Thu Feb 27, 2014 11:54 am
Location: Cervantes, Western Australia
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby Nesto » Fri May 30, 2014 10:09 pm

Ok, here is my full set of procedures:
- Yeast Starter (yeah, I can mess that up when I don't have my checklist)
- Brewing Procedures
- Kegging and Bottling Procedures
- Excel spreadsheet for linking to Brewing Procedure Word doc and to record brew day data

I any of you are crazy enough to actually read these, here are a few notes:
- I highlight in pink things that I tend to skip or are safety things I want to make sure my assistant pay attention to
- I highlight in light green things that I fill in data that will eventually get copied back into my Excel sheet or Beersmith
- I highlighted in dark green the fields that I link from Excel to the Word docs (date, volumes, boil additions, etc.)

Have fun ;)

Kegging and Bottling Procedures v2BM_no_links.docx
(170.89 KiB) Downloaded 88 times

Yeast Starter Procedures v3BM_no_links.docx
(33.98 KiB) Downloaded 84 times

Beer_Making_Current v2BM_share.xlsx
Excel spreadsheet with data and for recording actuals from brew day
(26.6 KiB) Downloaded 85 times

Brewing_Procedures_BM v4_no_links.docx
Main brewing procedure document
(83.53 KiB) Downloaded 90 times
___________________________
Check out my brewing blog... http://www.sycamorecreekbrewing.com/
User avatar
Nesto
 
Posts: 789
Joined: Tue Jan 21, 2014 8:03 pm
Location: Northern California
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby Cervantes » Sat May 31, 2014 2:41 am

In an attempt to return the favour I have attached my Brewing Bits & Pieces Spreadsheet.

This is a collection of brewing related references that I find handy.

Brewing Bits and Pieces.xlsx
Brewing Bit and Pieces
(330.27 KiB) Downloaded 117 times


I don't take credit for any of the information on the sheet. It's been cribbed from various sources on the internet, I merely consolidated the information into one spreadsheet.
Cheers :cheers:
Andy
User avatar
Cervantes
 
Posts: 475
Joined: Thu Feb 27, 2014 11:54 am
Location: Cervantes, Western Australia
Model: 20 litres

Re: Who else is Type A?... or "A Braumeister Checklist"

Unread postby Nesto » Sat May 31, 2014 5:04 am

Cervantes wrote:In an attempt to return the favour I have attached my Brewing Bits & Pieces Spreadsheet.

This is a collection of brewing related references that I find handy.

Brewing Bits and Pieces.xlsx


I don't take credit for any of the information on the sheet. It's been cribbed from various sources on the internet, I merely consolidated the information into one spreadsheet.


That's a nice collection of bits - already into my Evernote!
___________________________
Check out my brewing blog... http://www.sycamorecreekbrewing.com/
User avatar
Nesto
 
Posts: 789
Joined: Tue Jan 21, 2014 8:03 pm
Location: Northern California
Model: 20 litres

Next

Return to General / Tips and Tricks

Who is online

Users browsing this forum: No registered users and 2 guests