Biab Beer Designer Spreadsheet

Australia & New Zealand Homebrewing Forum

Help Support Australia & New Zealand Homebrewing Forum:

ianh

Well-Known Member
Joined
24/10/08
Messages
694
Reaction score
106
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
694
Reaction score
106
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
 

ianh

Well-Known Member
Joined
24/10/08
Messages
694
Reaction score
106
Location
Wynyard Tassie
All I can suggest is to Google "compare two excel files" and follow the Microsoft answer.
 

ScoAussie

Member
Joined
1/8/22
Messages
7
Reaction score
5
Location
Broken Hill / Orange
I did a search yesterday and the results were mostly for simple single tab worksheets, we have an excel guru at work so i might ask her when i'm next in the office.

You are looking to import and append into the excel sheet.

Hope this helps...
 

Hangover68

Well-Known Member
Joined
12/7/17
Messages
544
Reaction score
188
Location
St Helena, Melbourne NE.
You are looking to import and append into the excel sheet.

Hope this helps...

When i looked at both side by side it was just easier to to copy the data across as there wasn't much difference.
 

Latest posts

Top