[natebriscoe]

So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk

As for malt pH, you need to remove all pH altering substances, set the malt to 100% of the grain bill and then enter an override value that gives you the distilled water pH of the malt.

So this override is adjusting the L to get to the predicted mash ph? Or is the ph entered somewhere?

You are manually inputting this number to manipulate the estimated pH. It's a hot labor intensive but essentially identical to the way you do it in BW, except that beer color isn't subsequently affected.

The next revision of the spreadsheet that I  am working on is an attempt to divorce the base Malts from the DeLange/Kai color type calcs.

As I increase the L(ph) my predicted mash ph actually goes up.

Right. Increasing the value makes your pH more basic, decreasing more acidic.

Say you have Weyermann Pils with 5.9 pH. You want to increase the malt override. That way you need more acid to get to your desired pH.

You have to remember that BW assumes 5.75 pH as a baseline. Anything above or below that requires some adjustment.

So a ph of 5.9 would need to be adjusted to 8.5? What about a low ph say 5.5? Can't seem adjust it out.

You want to go negative for more acidic pH.

Bryan and I use a custom version of the sheet that was designed for his use in The Beerery. I also have a streamlined version that I call the "BLAM" edition specifically for Trappist beers.

I believe what I'm going to do is revise a stripped down version for general use that keeps all the really good Low Oxygen stuff and integrated water stuff but removes some of the unnecessary bits and makes it easier to use.

How about setting the targeted gravity? It seems to only want to calculate by efficiency.

That's correct. PBG is set by mash η and OG by Brewhouse η.

Blue-ish cells are user inputs. Pinkish cells are calculated. Maroon are dropdowns.

Think I figured it out. Didn't see the grain total input.
Thanks for answering

[natebriscoe]

Is there a way to input my water mineral content on the full spreadsheet?

[Big Monk]

Is there a way to input my water mineral content on the full spreadsheet?

Right click "Main" -> unhide -> "water"

There should be a user custom profile.

[natebriscoe]

Is there a way to input my water mineral content on the full spreadsheet?

Right click "Main" -> unhide -> "water"

There should be a user custom profile.

Looks like it needs to be unlocked? How?

[Big Monk]

Is there a way to input my water mineral content on the full spreadsheet?

Right click "Main" -> unhide -> "water"

There should be a user custom profile.

Looks like it needs to be unlocked? How?

Right click "water" -> unprotect.

[natebriscoe]

Is there a way to input my water mineral content on the full spreadsheet?

Right click "Main" -> unhide -> "water"

There should be a user custom profile.

Looks like it needs to be unlocked? How?

Right click "water" -> unprotect.

Think I am going to have to work on that part on a pc, it's not cooperating on a tablet.
 Many thanks 

[natebriscoe]

There seems to be an issue with the kettle ph adjustment, adds points without any mineral additions.

[Big Monk]

There seems to be an issue with the kettle ph adjustment, adds points without any mineral additions.

Screenshot?

[natebriscoe]

There seems to be an issue with the kettle ph adjustment, adds points without any mineral additions.

Screenshot?

[Big Monk]

There seems to be an issue with the kettle ph adjustment, adds points without any mineral additions.

Screenshot?

Try zero'ing out the initial kettle pH cell.

[natebriscoe]

There seems to be an issue with the kettle ph adjustment, adds points without any mineral additions.

Screenshot?

Try zero'ing out the initial kettle pH cell.

It matches the mash ph then.

[Big Monk]

There seems to be an issue with the kettle ph adjustment, adds points without any mineral additions.

Screenshot?

Try zero'ing out the initial kettle pH cell.

It matches the mash ph then.

I'll look into it in the morning. That doesn't seem right. What version are you using?

[natebriscoe]

5.2 think I downloaded this copy a few days ago. Seems to work properly on the just water sheet.

[Big Monk]

5.2 think I downloaded this copy a few days ago. Seems to work properly on the just water sheet.

I'll take a look. We use water with low/no alkalinity so you may have just exposed a latent error we never encounter. I'll figure it out tomorrow.

[Big Monk]

5.2 think I downloaded this copy a few days ago. Seems to work properly on the just water sheet.

Try downloading again with the fixes I made and see if you are good to go.

Let me know how it works.