I should probably remove the SRM estimate from the Water Adjustment sheet since its just a holdover from the bad old days when water adjustments were based on the beer SRM. That has been completely superceded by the Mash Acidification calculation. You will see a note to that effect if you hover the cursor over the SRM Needed heading on the Water Adjustment sheet.
I do see your confusion regarding the program indicating that the Target and Actual Adjustment cells for bicarbonate are going green and yet the pH is not in a proper range. If you hover over the bicarbonate cell in the Finished Water row, you will see the message that there is not an Ideal bicarbonate level and that cell will not turn green. I have to say that I need to adjust the Target and Actual Adjustment cells for the bicarbonate to also not turn green since its misleading.
The desired bicarbonate content in the mash water SHOULD NOT be based on the starting water profile, but SHOULD be based on the results of the mash acidification analysis. Leaving those cells in their normal yellow color should help avoid misleading the brewer into thinking that they have adjusted their bicarbonate properly.
In fact, the Target bicarbonate content is the "first cut" at the proper bicarbonate content for the mash water. The Brewer should try and adjust their initial bicarbonate content to that level. The Mash Acidifcation analysis will then determine if that level of bicarbonate is apprpriate, then the Brewer will need to revist the bicarbonate content or hardness to dial in the desired mash pH.
So, based on this very valid comment, the SRM information will be dropped and the green cell indicators for bicarbonate will be dropped in future versions. That should help avoid this confusion on a very critical aspect of Bru'n Water.
Thanks for the comment.