I thought it'd be good to have on thread for brewing spread sheets that people are working on.
It's work in progress and I'm sure there's errors. It'd be good if anyone lets me know what they are.
One error I think I had was in the mash effieciency formula.
It's in cell (model) E17 and I think it should be.
=(((E17-1000)*E15/C15)/(C17-1000)*C16)
The more run off I was getting at specified OG the lower the efficiency. I should be the other way. so I swap C15/E15 to E15/C15 and it seems to of corrected it.
It's work in progress and I'm sure there's errors. It'd be good if anyone lets me know what they are.
One error I think I had was in the mash effieciency formula.
It's in cell (model) E17 and I think it should be.
=(((E17-1000)*E15/C15)/(C17-1000)*C16)
The more run off I was getting at specified OG the lower the efficiency. I should be the other way. so I swap C15/E15 to E15/C15 and it seems to of corrected it.