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.
https://genstat.kb.vsni.co.uk/knowledge-base/append-data-from-excel/
Hope this helps...

 

[Hangover68]

You are looking to import and append into the excel sheet.
https://genstat.kb.vsni.co.uk/knowledge-base/append-data-from-excel/
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.

 

[Hefty]

Ianh, if you're still attending to this thread:
I haven't brewed for a while, but I was using this spreadsheet regularly when I last brewed. Thanks for all your hard work! I'm getting back into it and I'm about to brew a NEIPA recipe that uses whirlpool hops and dry hopping, in grams per litre, which I haven't done before. The spreadsheet is working in terms of calculated IBU on grams per litre, but the little red dot isn't showing up on the graph. I know it's not hugely important to my brewing but is there any way I can get the red dot to work from the calculated IBU cell? (where does it plot from currently?)
Cheers,
Jono.

 

[ianh]

Hi Hefty

The red dot should be =SERIES("RECIPE",MAIN!$Z$30,MAIN!$AA$30,8)
then cell z30 =k14 the ibu value and AA30 is =K11 the OG

It may be easier to download the Excel file again.

Hope that helps.
cheers
Ian

 

[Hefty]

Thank Ian, but what I mean is: the g/l is working for "calculated IBU" in cell K21, but not "IBU" in K14 because there are no boiling hops in this brew, so the red dot has nothing to plot. (I re-downloaded, just to make sure).

EDIT: Nevermind, I re-read the comment in the g/l column and added a bittering hop entry to match the grams per litre calculated IBU, like I was supposed to in the first place.