Return to TheElectricBrewery.com
  [ Shop ]   [ Building ]   [ Using ]   [ Recipes ]   [ Testimonials ]   [ Gallery ]   [ FAQ ]   [ About Us ]   [ Contact Us ]   [ Newsletter ]

Log inLog in   RegisterRegister   User Control PanelUser Control Panel   Private MessagesPrivate Messages   MembershipClub Memberships   SearchSearch   MemberlistMemberlist   Photo AlbumsPhoto Albums   Forum FAQForum FAQ


Water Adjustment

 
Post new topic   Reply to topic   Printer-friendly view    TheElectricBrewery.com Forum Index -> Brewing Science
View previous topic :: View next topic  
Author Message
kal
Forum Administrator



Joined: 12 Dec 2010
Posts: 11116
Location: Ottawa, Canada

Drinking: Pub Ale, Electric Creamsicle, Mild, Pliny the Younger, Belgian Dark Strong, Weizen, Russian Imperial Stout, Black Butte Porter


PostLink    Posted: Tue May 16, 2017 4:37 pm    Post subject: Water Adjustment Reply with quote


        Register to remove this ad. It's free!


Proper control of water is an important step to brewing any style of beer consistently and successfully. It's yet another aspect in brewing that can take a beer from 'good' to 'great'.

The guides and books I've come across I find are overly confusing or gloss over the actual "how to" parts and only present complex theory. My guide attempts to fix all that. No Chemistry at all, no complex math. Just what to do when, and why, to correctly adjust your water to target any style of beer imaginable.

Want to brew a delicate Kölsch, a hoppy American IPA, a British Bitter, or the latest New England IPA? This guide will give you the target numbers and show you step by step how to get there with the water you have today.

See: https://shop.theelectricbrewery.com/pages/water-adjustment

Comments welcome!

Cheers!

Kal

_________________
Our new shop with over 150 new products: shop.TheElectricBrewery.com
We ship worldwide and support our products and customers for life.
Purchasing through our affiliate links helps support our site at no extra cost to you. We thank you!
My basement/bar/brewery build 2.0
Back to top
View user's photo album (21 photos)
JSB




Joined: 17 Oct 2016
Posts: 125
Location: NE Ohio


PostLink    Posted: Fri Sep 24, 2021 9:04 pm    Post subject: Reply with quote

What I have done is save a copy of the EZ water calc as "EZ water ... HOPPY" .
Now insert a few rows at row 55 (below the blue box "results". )

Add a row of the 'Target Numbers":

Code:
TARGET   100   18   16   200   100



the next row, OVERAGE, will do a simple calculation. In cell D56 enter this:
Code:
=D51-D55

Do this same for the rest of the cells below your TARGET:

    TARGET 100 18 16 200 100
    OVERAGE 45 4 1 9 7


SO now as I change the additions, I can see the results

Now just use that version for Hoppy beers. Make sure to change the "Mash Water" and sparge water per your grist and batch size.

I have another Excel tab for that:

Batch size 5.5 Gallons
Post Boil 6 Gallons
Grist: 9.35 Pounds
"Mash thickness" 1.25 Inches
boil time 60 minutes
Strike Water 3.7 gallons
Boil Wort 7.9 gallons
Sparge Water 5.4 gallons

The values that are underline are calculated
For Strike enter:
Code:
=ROUNDUP((B4*B3/4)+0.22+0.5,1)

For Sparge enter :
Code:
=ROUNDUP(B7+B8-B6,1)


I hope this makes sense...

Jeff
Back to top
kal
Forum Administrator



Joined: 12 Dec 2010
Posts: 11116
Location: Ottawa, Canada

Drinking: Pub Ale, Electric Creamsicle, Mild, Pliny the Younger, Belgian Dark Strong, Weizen, Russian Imperial Stout, Black Butte Porter


PostLink    Posted: Fri Sep 24, 2021 9:10 pm    Post subject: Reply with quote

Hi Jeff,

I'm not entirely sure what you're getting at exactly, but if you've found a way to make the spreadsheet easier for you to use then go for it! Happy brewing!

Kal

_________________
Our new shop with over 150 new products: shop.TheElectricBrewery.com
We ship worldwide and support our products and customers for life.
Purchasing through our affiliate links helps support our site at no extra cost to you. We thank you!
My basement/bar/brewery build 2.0
Back to top
View user's photo album (21 photos)
JSB




Joined: 17 Oct 2016
Posts: 125
Location: NE Ohio


PostLink    Posted: Sun Sep 26, 2021 12:28 am    Post subject: Reply with quote

OK... now with pictures:



The Target row is "hard coded" values for theis version of the EZ water: Hoppy

The Overage Row is a simple calculation to show the overage over the RESULTS. Very handle to see the change as you dial in different amounts of minerals.

And the other tab calculates STRIKE and SPARGE amounts (do this first):



And those values are utilized back on the EZ Water tab:


Jeff
Back to top
kal
Forum Administrator



Joined: 12 Dec 2010
Posts: 11116
Location: Ottawa, Canada

Drinking: Pub Ale, Electric Creamsicle, Mild, Pliny the Younger, Belgian Dark Strong, Weizen, Russian Imperial Stout, Black Butte Porter


PostLink    Posted: Sun Sep 26, 2021 1:34 pm    Post subject: Reply with quote

Ah! Gotcha. Thanks for explaining.

FYI - the profile you have there is actually our "Hoppy New England" profile (not "Hoppy" which is different). You can of course call it anything you like.

Cheers,

Kal

_________________
Our new shop with over 150 new products: shop.TheElectricBrewery.com
We ship worldwide and support our products and customers for life.
Purchasing through our affiliate links helps support our site at no extra cost to you. We thank you!
My basement/bar/brewery build 2.0
Back to top
View user's photo album (21 photos)
Display posts from previous:   
Post new topic   Reply to topic   Printer-friendly view    TheElectricBrewery.com Forum Index -> Brewing Science All times are GMT
Page 1 of 1
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum



Forum powered by phpBB © phpBB Group