Biab Beer Designer Spreadsheet

[ianh]

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.

 

[Hangover68]

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.

Thanks Ian, i knew it would be something i did or needed to adjust.

 

[NicolasZA]

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]

=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

 

[NicolasZA]

Thank you very much!

 

[Hendog]

Yep, appreciate your hard work

 

[Hangover68]

Anyone know if its possible to merge 2 copies of the spreadsheet, i have a copy on my PC and a cop on a flash drive and would like to merge them.

 

[ianh]

All I can suggest is to Google "compare two excel files" and follow the Microsoft answer.

 

[Hangover68]

All I can suggest is to Google "compare two excel files" and follow the Microsoft answer.

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.

 

[ScoAussie]

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.

Appending Data from Excel • Genstat Knowledge Base

Sometimes data for separate categories or trials will have been entered on separate pages within a workbook. If the sheets are identically structured (same column names, same column types of factor/text, etc.) then these can be combined into a single spreadsheet. Even if columns have been named...

genstat.kb.vsni.co.uk

Hope this helps...

 

[Hangover68]

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

Appending Data from Excel • Genstat Knowledge Base

Sometimes data for separate categories or trials will have been entered on separate pages within a workbook. If the sheets are identically structured (same column names, same column types of factor/text, etc.) then these can be combined into a single spreadsheet. Even if columns have been named...

genstat.kb.vsni.co.uk

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.