This is an overview, deep dive, and recipe design walk though for Version 5 of my Brewing Spreadsheet. See chapters below for topics covered.
???? Support my work by buying from my affiliate links, becoming a member, buy merch, or donating money via https://beernbbqbylarry.com/ ????
Links References in Video:
Brewing Spreadsheet:
Brewing Software Article
EasyWater
Hydrometer Testing & Calibration
Drafting System Balancing
How to Dial In Your Brew System & Process
Grain Absorption Rates
Hop Absorption Rates
Chapters:
00:00 – Why Use My Brewing Spreadsheet Over Other Software
04:39 – Topics to Cover
05:23 – Instructions Overview
06:32 – Recipe Sheet Overview
07:21 – Brewhouse Setup Overview
08:04 – Equipment Profiles Overview
08:37 – Grain & Sugar Calcs Overview
09:16 – Hop Calcs Overview
09:44 – Water Overview
10:33 – Grain & Sugar List Overview
11:06 – Hops List Overview
11:17 – Yeast List Overview
11:37 – Hydrometer Testing & Correction Overview
12:19 – Beer Line Length Overview
13:16 – Malt Sheet PPG Overview
13:51 – Conversion Tables Overview
14:31 – BJCP Guidelines Overview
14:54 – Thermal Volume of Expansion Coefficient Overview
16:32 – Units Conversion & Common Variables Overview
17:17 – Instructions Deep Dive
21:55 – Recipe Sheet Deep Dive
26:56 – Brewhouse Setup Deep Dive
41:34 – Equipment Profiles Deep Dive
49:06 – Grain & Sugar Calcs Deep Dive
51:00 – Hop Calcs Deep Dive
56:00 – Water Deep Dive
59:47 – Grain & Sugar List Deep Dive
01:04:10 – Hops List Deep Dive
01:05:06 – Yeast List Deep Dive
01:06:56 – Recipe Design Example