Brewing Spreadsheet Version 5: Overview, Deep Dive, & Recipe Design Example
Вставка
- Опубліковано 4 лип 2024
- 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 beernbbqbylarry.com/ 🌟
Links References in Video:
Download Spreadsheet: beernbbqbylarry.com/downloads/
Brewing Software Article: beernbbqbylarry.com/2019/10/3...
EasyWater: ezwatercalculator.com
Hydrometer Testing & Calibration: • Hydrometer Testing & C...
Drafting System Balancing: • Draft System Balancing...
How to Dial In Your Brew System & Process: • How To Dial In Your Br...
Grain Absorption Rates: • Grain Absorption Rates...
Hop Absorption Rates: • Determining Hops Absor...
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 - Навчання та стиль
Thank you very much Larry, I am a brewer in Shenzhen China. Best wishes
Great tutorial, and thanks for gifting all of us this spreadsheet!
One suggestion - Calculations for adding a yeast starter. This would affect volume and gravity.
I considered that idea years ago before I settled on some general rules for yeast pitching and never saw a need for one since.
When I did try counting/estimating yeast rates in the earlier years, I’ve seen no difference between that and the general rules followed later.
Thanks Larry! I've been using your spreadsheet for 8 years now and I appreciate the updates from time to time.
Excellent. Glad you like using it.
@@BEERNBBQBYLARRY Just bought a t-shirt as a thanks for the years of contributions to the brewing community. Thanks!
Thank you Larry for providing these resources to us! I haven't brewed a single batch of beer.....yet. But I plan to start when I return to the US after working overseas. Your videos have been entertaining and enlightening for me. Keep Brewing!
Glad you liked them!
Wow! Larry this is such a great tool! I've always been confused by all the intricacies of brewing, but your video really helped me understand how each component (water, grain, hops, temp etc.) affects and improves or detracts from the final product. Kudos to your efforts and, just so you know, I am spending the rest of today setting up my default spreadsheet. Thanks!!!!
Great to hear! You're very welcome!
Thanks Larry! Great channel, btw!
Thank you!
Thank you so much!!!
Hi Larry, a huge thankyou! for your great work on this..! I have started recommending your spreadsheet at my local homebrew club as, what I also think, is a better alternative to apps and software out there. Its great to be able to have full control and visuals on all the working parts.. I'm a metric user (Australia).. and I have to say, after checking all the 'equipment profiles', and 'equipment set up & calcs', it works great. In my opinion, your strengths as a 'brewtuber' really are your engineering perspective, your do-it-yourself equipment vids, and equipment reviews. Your the first UA-cam brewer I came across when I started, and you have helped me a heap.... so again, big thanks....
You’re welcome. I’m glad the metric values are good. I don’t always have time to recheck them after making updates. There are way too many scenarios to go through them all.
Thanks for the update video Larry! Love this spreadsheet. I have an Import/Export module I created for your spreadsheet that makes saving recipes and importing saved recipes a breeze, if you'd like it?
Absolutely. Been thinking about a way to do that although at a very low priority.
@@BEERNBBQBYLARRY Not a problem. I will clean up the code and make it easier for you to add to your spreadsheet and shoot you an email.
Getting ready for a brew day maybe Sunday. In your spreadsheet, which I am trying to use, and since I haven't used Excel in about 10 years I am stumbling all over myself LOL, I noticed your BrewEasy volume numbers are off. A 10 gallon Blicmann kettle should be 40 quarts, not 60. Cheers Bud.
Hi Harold. That equipment profile is correct for my 10 gal BrewEasy. It comes with a 15 gallon mashtun which is 60 quarts.
@@BEERNBBQBYLARRY Gotcha, I thought it was a 10 gallon pot. When I saw 60 qts. I thought it could have been an oversight. Cheers Bud.
Is there a Metric version?
It does metric and US Customary units I demo that earlier in the video.
Just wondering but have you ever thought about building a UI/app in front of this?
For clarity, a UI/solution could still be open source on git hub and open to public for contribution. I have not used the spreadsheet but have contemplated building something like this as I am a software developer by trade.
The thought has occurred over the years but creating such a custom app or website would do away with most of the advantages of using a standalone spreadsheet that I mention in the video.
@@BEERNBBQBYLARRYthis is true. Transitioning to an app forces people to download said app. Only gripe I have with excel, is that complex solutions like this tend to get confusing quickly. Apps/interfaces allow for things to be a bit more intuitive and self guiding. Props to you on building this document and capturing this valuable information in a centralized place.
@@brewinfusedyeti3798 oh yes. Very complicated and frustrating to do this in Excel especially as it gets more complicated over the years. I think I’m near the end of development though. I don’t know if I’ll even get to a version 6.
@@BEERNBBQBYLARRY one of the nice parts about abstracting this into software is the ability to keep all of the formulas for calculations in a single place. That way you can quickly review the without cracking into cells and following the trail of values. If I ever pursue building a free/opensource app, would be great to collaborate with you to ensure the values and formulas line up.
No more refractometer option?
Refraction option still exists.
@@BEERNBBQBYLARRY oops. duh...i looked in the hydrometer profiles for a refractometer. i see where it is now lol.
You have invested a great deal into this BroFessor Larry. There is only 1 tab missing from this spreadsheet. I suppose it's because no one but me uses it. LOL. Krausen /Gyle Calculator. That is the only reason I used Brewers Friend. Brewer's friend was the only place I could find an operable Krausen /Gyle calculator. As a rule, I carb by Krausen with the occasional Gyle depending on how active I am with my brew rig.
Wow. You do that?! That's pretty advanced. I've never considered reusing wort or krausen from another batch for bottling when I used to bottle. I had a hard enough time as it was estimating how much measurable sugar/extract to add when priming a batch.
@@BEERNBBQBYLARRY It's really very easy. There is nothing to it. Measure what the bottling vessel ( bottling bucket) holds, and add the appropriate amount of Krausen or Gyle to provide the prescribed amount of C02 volumes. I have never had a single bottle bomb. I did have a bottle get infected once. It is really simple. I sometimes scale up enough to have extra wort for the process and freeze it. for a 5 gallon batch I usually would require around 1.25 -1.5 quarts of Krausen. It pretty simple and fool proof.
I use mac and it looks very different from yours. for one no drop down menus
I think that was a reason why Numbers can’t be used to author recipes with it; only for viewing and entering measurements on brew day.
degF, lbs, ounces, psi ???
What is going on here Larry?
You cant live like this mate
Right?! Good thing there’s a metric option to use instead.
@@BEERNBBQBYLARRY
The USA is only joined by Liberia and Myanmar as the 3 countries that still use Imperial.
This is only a theory Larry, but I think Imperial beer tastes different from SI or Metric beer.
Actually, the US doesn’t use Imperial units. It uses “US Customary” units which is different than Imperial. We also use a mixture of US Customary and Metric, so that just makes my life as an engineer pretty hellacious.
@@BEERNBBQBYLARRY I am a chemical Engineer myself - big headache converting units (during my studies and also in industry and academia)
More complicated than ever😂😂😂😂
Yep. That’s mostly due to all the enhancement requests from viewers that use it. Also, from the explosion of so many different brewing processes and systems over the years.
I miss the simplicity of the old days of brewing.