Brewing Spreadsheet Version 5: Overview, Deep Dive, & Recipe Design Example

1 year ago
312

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:
Download Spreadsheet: https://beernbbqbylarry.com/downloads/
Brewing Software Article: https://beernbbqbylarry.com/2019/10/31/why-various-brewing-recipe-calculators-give-different-results/
EasyWater: https://ezwatercalculator.com
Hydrometer Testing & Calibration: https://youtu.be/fLtXcBTff8k
Drafting System Balancing: https://youtu.be/w6whE1jrVQ4
How to Dial In Your Brew System & Process: https://youtu.be/tugkC1GUEkQ
Grain Absorption Rates: https://youtu.be/oqdtgrQSC_s
Hop Absorption Rates: https://youtu.be/PDQeRuBlAvA

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

Loading comments...