Bri's Water Treatment 2021. (going to be messy! my 🧠is slow!)

Help Support The HomeBrew Forum:

Clint

Forum jester...πŸ…πŸ†
Supporting Member
Joined
Jun 29, 2016
Messages
13,332
Reaction score
8,827
Location
North Wales
IMG_20210212_103148.jpg
IMG_20210212_103122.jpg

Mornin Bri
This is the basic info I work to... obviously you need to start with your water profile not mine..
Then look on the forum for Strange Steve's water calculator (someone please post a link coz I don't know how to!)then just punch in your numbers,any roast grains and it'll give you what you need to add. It's really easy!
 

Clint

Forum jester...πŸ…πŸ†
Supporting Member
Joined
Jun 29, 2016
Messages
13,332
Reaction score
8,827
Location
North Wales
If the profiles aren't that clear in the picture they are also on a link somewhere in Steve's post..
 

foxbat

Landlord.
Joined
Nov 24, 2013
Messages
2,739
Reaction score
1,742
Location
Essex, UK
Thx Clint...........05:30AM ffs cant get the auto alarm clock oot my heed.aheadbutt
Annyhoo the day started great....
Thought i'd tackle beersmith3 n the water profile.
How wrong was i.............half way through 🧠 went hay wire..
heres my progress ( @foxbat havent forgot your good work ref the help, and @Clint help we the water profile etc.)
Clint i fire my email...(if it not in my profile?) if you send your water report thingy to help me)
Here it is:

off to look at @foxbat help doonloading a app/program thingy.
Bri
Calcium: Yes you entered that from your own measurements: 40

Alkalinity: Again, from your own measurements: 80.55

Magnesium: It's not on your water report (you picked Manganese which is different). It's not particularly important anyway so just leave it at zero in your Beersmith box.

The other values should come from the "Mean" (average) column. Here's my take on your Beersmith Profile:

 

Manxnorton

Senior Member
Supporting Member
Joined
Jul 11, 2013
Messages
2,153
Reaction score
625
Location
Newcastle
just boot to add that i'm faffing on with your help bru'n water thingy.
got so far....
 

Manxnorton

Senior Member
Supporting Member
Joined
Jul 11, 2013
Messages
2,153
Reaction score
625
Location
Newcastle
getting help on @foxbat
 

Manxnorton

Senior Member
Supporting Member
Joined
Jul 11, 2013
Messages
2,153
Reaction score
625
Location
Newcastle
View attachment 41360View attachment 41361
Mornin Bri
This is the basic info I work to... obviously you need to start with your water profile not mine..
Then look on the forum for Strange Steve's water calculator (someone please post a link coz I don't know how to!)then just punch in your numbers,any roast grains and it'll give you what you need to add. It's really easy!
thx Clint.
I'm looking at it.πŸ€•
Calcium: Yes you entered that from your own measurements: 40

Alkalinity: Again, from your own measurements: 80.55

Magnesium: It's not on your water report (you picked Manganese which is different). It's not particularly important anyway so just leave it at zero in your Beersmith box.

The other values should come from the "Mean" (average) column. Here's my take on your Beersmith Profile:

ohhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh yhat looking better...i think pal
1. Ca 40ppm (from my test)
2. Sodium 21 (mean from the report)
3. Sulfate (report)
4. cloride 17 (report)
5. could find the Alk....but found my test result in bicarb 80.55
is this right???

so i need (apart from a new brain)
with the help of the reading youve just helped me....1-5
Think my pH meter coming today...
so maybe i can practice we noth beersmith and Bru'n water.
Found Gash's titorial for Brewfather......πŸ˜πŸ˜πŸ˜‚πŸ˜‚ but my meds kicked in..

Bri
 

Clint

Forum jester...πŸ…πŸ†
Supporting Member
Joined
Jun 29, 2016
Messages
13,332
Reaction score
8,827
Location
North Wales
You get the alk/Kh with your test kit..
You'll get there..
 

foxbat

Landlord.
Joined
Nov 24, 2013
Messages
2,739
Reaction score
1,742
Location
Essex, UK
Here's a copy of the spreadsheet with your brew in it.

What I did:

1. Entered your water profile on Sheet (1). You don't need to come back to this sheet again now it's done.

2. Entered your grain bill on sheet (3). I changed the colour units from Lovibond in your screenshot to EBC. I also corrected where you'd entered 0.5, 0.4, 0.3 etc. in the Quantity (g) column to what I think you meant: 500g, 400g, 300g etc.

3. On the Water Adjustment (4) sheet I fiddled around with the lactic acid amount in cell B29 until the Estimated Mash pH dropped to 5.39 which is a good figure for a brown beer. I'm making the assumption here that you have a bottle of 80% lactic acid in your cupboard! I did not add minerals on that sheet because your water is really quite good already.

What you need to do:

Enter your mash and sparge water volumes in cells J17 and L17 on sheet 4 (Water Adjustment).

Now you can click on sheet 5 (Adjustment Summary) and read the amount of lactic acid to add to your mash in cell E26 (it reads 3.8 ml at the moment).
 

Attachments

Manxnorton

Senior Member
Supporting Member
Joined
Jul 11, 2013
Messages
2,153
Reaction score
625
Location
Newcastle
Think so far Brewfather is getting there..
For all i still need the pH meter....tbh my water if i remember is was boot 7.8.

is the numbers ok?
BTW bri's online shopping went Pete Tong again...
was trying to order a small packet gypsum......look at what i got...ffs im a menace i tell you.
 

Manxnorton

Senior Member
Supporting Member
Joined
Jul 11, 2013
Messages
2,153
Reaction score
625
Location
Newcastle
brewfather.
Sorted the equipment profile-mash-fermentation etc. for G30 GF (24l batch)
quickly added grains.

already done water profile...to Newcastle.

then AUTO to get the salts...strike and sparge.
it'll time to get used yo using brewfather lol.
have i got there??

playing again on BS3.

Forgot what i ordered,,,,
 

foxbat

Landlord.
Joined
Nov 24, 2013
Messages
2,739
Reaction score
1,742
Location
Essex, UK
You've ordered enough mineral salts to supply the entire North East of England! :laugh8: athumb..
 
Last edited:

Manxnorton

Senior Member
Supporting Member
Joined
Jul 11, 2013
Messages
2,153
Reaction score
625
Location
Newcastle
Mind using beersmith there some odd things with working out the salts that confused the hell oot me..
Where as brewfather looks Brian (user friendly )
Now armed with all that n my tests CRS calculations after the Alk n Ca tests now I need is my pH meter to arrive...
My kit is ready to get pick up for @BeardedMag for his brewday.
Thank all for the support
1613166544238.png
 

Manxnorton

Senior Member
Supporting Member
Joined
Jul 11, 2013
Messages
2,153
Reaction score
625
Location
Newcastle
Here's a copy of the spreadsheet with your brew in it.

What I did:

1. Entered your water profile on Sheet (1). You don't need to come back to this sheet again now it's done.

2. Entered your grain bill on sheet (3). I changed the colour units from Lovibond in your screenshot to EBC. I also corrected where you'd entered 0.5, 0.4, 0.3 etc. in the Quantity (g) column to what I think you meant: 500g, 400g, 300g etc.

3. On the Water Adjustment (4) sheet I fiddled around with the lactic acid amount in cell B29 until the Estimated Mash pH dropped to 5.39 which is a good figure for a brown beer. I'm making the assumption here that you have a bottle of 80% lactic acid in your cupboard! I did not add minerals on that sheet because your water is really quite good already.

What you need to do:

Enter your mash and sparge water volumes in cells J17 and L17 on sheet 4 (Water Adjustment).

Now you can click on sheet 5 (Adjustment Summary) and read the amount of lactic acid to add to your mash in cell E26 (it reads 3.8 ml at the moment).
get on pal...........
something to get my teeth into..
Now i had one o best nites kip, (flat packed meds) to stop my mine racing & waking up crazy times then my mind goes into pH, PPM, Ca, Alk blah blah blah!!
@BeardedMag just picked up the brewing kit and P'd himsel how much water treament i boughtashock1:laugh8::laugh8:
Thank so much @foxbat off to play...🀞🀞🀞🀞🀞🀞😁😁Bri
 

Manxnorton

Senior Member
Supporting Member
Joined
Jul 11, 2013
Messages
2,153
Reaction score
625
Location
Newcastle
Here's a copy of the spreadsheet with your brew in it.

What I did:

1. Entered your water profile on Sheet (1). You don't need to come back to this sheet again now it's done.


2. Entered your grain bill on sheet (3). I changed the colour units from Lovibond in your screenshot to EBC. I also corrected where you'd entered 0.5, 0.4, 0.3 etc. in the Quantity (g) column to what I think you meant: 500g, 400g, 300g etc.


3. On the Water Adjustment (4) sheet I fiddled around with the lactic acid amount in cell B29 until the Estimated Mash pH dropped to 5.39 which is a good figure for a brown beer. I'm making the assumption here that you have a bottle of 80% lactic acid in your cupboard! I did not add minerals on that sheet because your water is really quite good already.

What you need to do:

Enter your mash and sparge water volumes in cells J17 and L17 on sheet 4 (Water Adjustment).


Now you can click on sheet 5 (Adjustment Summary) and read the amount of lactic acid to add to your mash in cell E26 (it reads 3.8 ml at the moment).


am i getting there.......lol
 
Top