Anyone have any experience with Palmer's Spreadsheet?
The way it was described to me and the way I read and understand it now states that for the water volume in Step 4 you just put the amount of water for the initial mash strike. So for my purposes right now only put 3 gallons, even though I will eventually have 6.25 gallons in my kettle pre-boil once the mash and sparge are complete.
Then adjust my salts and minerals for the 3 gallons until I reach the desired water profile. I was told to then split the total salt/minerals additions into two parts. Put one part into the mash and the other addition into the boil kettle once all the wort is collected.
Can anyone explain why you would only calculate for 3 gallons and not 6.5 gallons? Is the spreadsheet accounting for this? I feel like you would need to calculate for 6.25 gallons since that is what you would be boiling in the kettle.
I've read a lot of posts of other people saying they just put the total pre boil volume in there and not the mash sacchrifaction volume and it's starting to confuse me.
Listening to Brew Strong, Palmer states that you put only the initial 3 gallons for mash and then you have to calculate an additional salt/mineral addition for the other 4 gallons that would top off your kettle for say a 7 gallon pre boil volume. So thinking it over, was what my friend trying to tell me when he said split it into two additions, he didn't literally mean split it in half, but to do two separate additions of the equal value, since your mash & sparge volumes are almost equal?