Brewery stock.ods

This allows you to keep tabs on what stock you hold and how many brews you could make.

To use it you should:

Start by filling in column C rows 2 to 17 with quantities of your existing stock; you can see the stock which I held on the 21st of February 2019. This automatically updates column B with the current stock.

Then, each time you do a brew fill in the next empty cell on row 1 with the date and the name of your brew. You can see how this should be if you look at column D which is for an Amarillo brew. As soon as you do this the formulae in the rows below fill in the recipe requirements for the appropriate brew and subtract them from the Current stock shown in column B. You must type the name of the brew exactly as it is in row 20 columns B, D, F, H, etc. so that the spread-sheet knows the quantities for that recipe.

When you need to replenish your stock put the date in the next empty column in row 1 and type a number in each row below that. You must type 0 in rows for which you have enough and so are not buying more. This is to remove the formulae in those cells. Have a look at column C as an example.

Brew day.ods

This provides a schedule for the brew day's activity.

To use this spread sheet fill in cell A1 with the time at which you are actually starting and all of the times for the rest of the day will be updated automatically.

Column B is a list of times corresponding to three minutes before the event which prevails on that row. I use this to ask Google Home to set an alarm to wake me up in time for the event.

Brewing Log.ods

This provides a log of the details of each brew that you do.

To use this you should:

Copy the last three rows, up to column T, into the next empty row. For example in the case of the starter spread-sheet copy rows 2, 3 and 4 to fill rows 5, 6 and 7.

Type the brew date in column A of the first of the three copied rows and the two dates below it will update automatically.

Make sure that columns G, H, I, J and K in the first of the copied rows are cleared ready for the values you need to fill in for this brew.

You will also need to clear column M in the last of the copied rows ready for the value of the specific gravity which you will read on the last day of the fermentation.

On the brew day as the brew proceeds fill in the grain temperature, the starting temperature of the mash liquor (tap water) when it's up to temperature (this should, of course, be 72^oC) and the other values as the brew proceeds.

When the fermentation is complete measure the final gravity and type it in column M on the last row and two cells will update automatically:

1. Column K will automatically show the original gravity which you measured on brew day.

2. Column N will automatically show the ABV of your beer.