Good to see your brain is still doing a heap of RPM Pete :icon_cheers:
Updated BIAB Volumes Spreadsheet
View attachment BIAB_Equipment_Set_Up_Volumes_130909A.xls
Changes
Average: Have changed the average column so as it stays blank if no figures have been entered. Once the brewer begins to add figures, the Average column displays the average of the figures that have been entered. (Thanks for the formula help benny and benrs44!)
Evaporation Per Hour: Changed units to lts/hr as suggested by Benny. Donya!
Special Note
I have been uploading the spreadsheet using the same filename each time which I think is a mistake as I think it affects all prior posts. I will keep changing the name from now on and hope this hasn't caused any problems to date.
Explanantions
Thanks again for the feedback randyrob, Lloydie, Bribie, Scruffy, DK, benrs44 and nikgr. Much appreciated. Here are some explanations...
I have used the beginning of your formulas Ben/s but changed the latter so as it gives the average of figures provided not the average of all 5 columns. Otherewise if someone just puts in a few figures, it would divide them by 5. Make sense?
I haven't changed the grain absorption to litres per gram as it is actually just a litre figure.
Still haven't come up with an idea for a reliable trub formula but getting the feedback on what people are scoring is very helpful. If we get enough figures, I suppose we could always add a drop-down box for people to select their kettle type and then have a formula based on this.
Finally I haven't included benrs44's temperature co-efficient. I want to chat more to him about this but will do it off-forum.
Thanks a heap guys!
Pat