Quantcast

Biab Beer Designer Spreadsheet

Aussie Home Brewer

Help Support Aussie Home Brewer:

ianh

Well-Known Member
Joined
24/10/08
Messages
691
Reaction score
100
Location
Wynyard Tassie
Hi. The mash temp and time are only manually set. The strike temp can be increased by increasing the value in the Factor for grain absorbtion cell.
 

NicolasZA

Member
Joined
27/5/20
Messages
6
Reaction score
1
Location
South Africa
Hi Ian

Just read through the whole thread to make sure I haven't missed anything. On my BREWS sheet, I have no formula in the T and U columns. Can you let me know what it should be? I have downloaded the spreadsheet a couple of times. Still blank.
 

ianh

Well-Known Member
Joined
24/10/08
Messages
691
Reaction score
100
Location
Wynyard Tassie
=IF(AND(ISNUMBER(R2),ISNUMBER(S2)),IF(ISNUMBER(AC2),(R2-S2)/7.45,(R2-S2)/7.45+0.4),"") in Cell T2
=IF(AND(ISNUMBER(R2),ISNUMBER(S2)),100*(R2-S2)/R2,"") in Cell U2
These Cells are copied down the Worksheet
Only get values if using hydrometer ie inputs in Cols R and S

Cheers

Ian
 

Latest posts

Top