The Bru'n Water spreadsheet treats the sparge water the same as the mash water, as far as mineral content is concerned.
An exception to that rule for the spreadsheet is a comment provided in the sparge cell that reads:
Bru'n Water v 1.18 said:
If your boil kettle produces evaporation loss of more than about 10 percent of the beginning volume, you can consider entering a smaller than actual volume for the sparging water to help reduce the added mineral quantity to your water and avoid excessive mineralization to the wort.
No guidance on how much to reduce the volume by is given.
(a little context: the spreadsheet calculates salt additions per gallon of water, then multiplies by the number of gallons specified for the mash water and for the sparge water)
I assume that all of the provided profiles per style in the spreadsheet are mash targets.
@mabrungard please correct me if I am wrong.
With no sparge, the sparge water field is 0 gallons, so all the additions go in the mash water.
The spreadsheet includes this concept in its guidance, regardless of evaporation rate.
The mineral content in the finished wort/beer will end up higher than the mash content, because of evaporation.
I guess if you're aiming for a beer mineral content, evaporation must be taken into account.
Boil durations will then affect the mash additions, and subsequently acid additions.
(The acid content is completely independent between mash and sparge in the spreadsheet; target and additions.)
My plan is to brew a few batches with the profiles provided as mash targets, no sparge.
I will adjust to taste per recipe in future batches.
Maybe I will see the light and be able to tweak profiles on new recipes after gaining some experience.
Lots of brewing and drinking ahead!
