Main BIABacus Help Testing Thread

Some drafting and testing of new site structure and BIABacus help.
User avatar

Rick
Gold
Gold
United States of America
Posts: 759
Joined: 4 years ago
Location: Pennsylvania
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City: East Greenville

Post by Rick » 1 year ago

Primavera wrote:Apologies if this has been answered elsewhere...

I have access to locally malted 2-row. I have brewed two batches so far and my GIB has been 10 points lower than expected.

My LHBS confirmed that this was typical for this malt and suggested to use 10% more grain for this malt to make up for the lower efficiency.

How should this be handled in BIABacus?

Thanks

Chris
Assuming he is correct, and 10% will work ...

Write down your original base malt quantity.

1. enter or convert your grain bill to grams (read: not percentages).
2. add 10% to base malt only
3. increase the OG on the right side of section C. "OG override" (leaving the left side the same), keep making it greater until all the grains match on both sides.

you can use more decimal places than are shown, like ... 1.07359

I've never actually done that, but that'll allow the biabacus to account for his instructions. Be sure to write a note in Section I as to why you did this.
Last edited by Rick on 04 Nov 2015, 02:05, edited 1 time in total.


goulaigan
Gold
Gold
Canada
Posts: 578
Joined: 3 years ago
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City: Goulais River

Post by goulaigan » 1 year ago

I am guessing we are in the wrong forum for these types of questions, but could you not also just put a 70 beside the grain name in section Y under fgdb? Also have to put a 4 under MC it seems to make the base grain amount change, which is default. The default fgdb is %80. I could be wrong here tho...

User avatar

Rick
Gold
Gold
United States of America
Posts: 759
Joined: 4 years ago
Location: Pennsylvania
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City: East Greenville

Post by Rick » 1 year ago

goulaigan wrote:I am guessing we are in the wrong forum for these types of questions, but could you not also just put a 70 beside the grain name in section Y under fgdb? Also have to put a 4 under MC it seems to make the base grain amount change, which is default. The default fgdb is %80. I could be wrong here tho...
I tried doing this first, and it changes all of the other grains to satisfy the ratio established on the left side of section C.
Last edited by Rick on 04 Nov 2015, 02:49, edited 1 time in total.


goulaigan
Gold
Gold
Canada
Posts: 578
Joined: 3 years ago
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City: Goulais River

Post by goulaigan » 1 year ago

Ah, I hadn't noticed that even though I tried it. Looks like your original answer would be the way to go then.

Edit: If you put it in the bottom 'Actual Fermentable Bill' of section y it doesn't change the others...

User avatar

Rick
Gold
Gold
United States of America
Posts: 759
Joined: 4 years ago
Location: Pennsylvania
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City: East Greenville

Post by Rick » 1 year ago

goulaigan wrote:Ah, I hadn't noticed that even though I tried it. Looks like your original answer would be the way to go then.

Edit: If you put it in the bottom 'Actual Fermentable Bill' of section y it doesn't change the others...
There you go, works for me, too. I like this method better for record keeping sake.
Last edited by Rick on 04 Nov 2015, 04:25, edited 1 time in total.


Primavera
Gold
Gold
United States of America
Posts: 83
Joined: 2 years ago
Location: North of NYC
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City:

Post by Primavera » 1 year ago

Thanks, Rick

Running the numbers as you suggested seems to agree with my observations.

I'm keeping it simple for the next batch - went back to Rahr 2-row until I can experiment with smaller batches of the local grain.


Primavera
Gold
Gold
United States of America
Posts: 83
Joined: 2 years ago
Location: North of NYC
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City:

Odd Recipe report behavior

Post by Primavera » 5 months ago

Not sure what I am doing wrong - the hop section of the recipe report is not showing the correct values.
You do not have the required permissions to view the files attached to this post.

User avatar

Mad_Scientist
Gold
Gold
United States of America
Posts: 1680
Joined: 6 years ago
Location: Panhandle of Florida, USA
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City:

Re: Main BIABacus Help Testing Thread

Post by Mad_Scientist » 5 months ago

Remove one or the other values on the first or second line. (21.50 or 99)

User avatar

Mad_Scientist
Gold
Gold
United States of America
Posts: 1680
Joined: 6 years ago
Location: Panhandle of Florida, USA
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City:

Re: Main BIABacus Help Testing Thread

Post by Mad_Scientist » 5 months ago

I removed the 99 then entered 23.86 for VAW as shown in Section K


Primavera
Gold
Gold
United States of America
Posts: 83
Joined: 2 years ago
Location: North of NYC
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City:

Re: Main BIABacus Help Testing Thread

Post by Primavera » 5 months ago

Nothing was working so I started with a clean version and everything is correct now.

Thanks for the help.


chrislee100
Draft
Draft
Christmas Island
Posts: 2
Joined: 5 months ago
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City: Kenwood, CA

Re: Main BIABacus Help Testing Thread

Post by chrislee100 » 5 months ago

Maybe the simpler way for me to figure this out is for me to ask, is there a way to unlock the hidden cells or otherwise expose the formulae so I can follow all the calcs myself?

chris

I'm new around here, and I really have tried to find the right place to ask this question about BIABacus. That said, it might be the wrong place.

I'm trying to eliminate the unwanted conversion going on between "Original Fermentation Bill Design" and "What You Will Use" in section C. I have nothing entered under "substitutions" and I am not trying to alter the batch size of the recipe. Yet unless I enter a really screwy target OG, I end up with a grain bill that is maybe 2/3 of what's listed on the "original" side. I could just ignore "What You Will Use," but I imagine those cells inform some calcs downstream. Anybody know how to do this? Otherwise...what a great spreadsheet! Thanks.

Thanks, Chris Lee, Kenwood, CA
Last edited by chrislee100 on 23 Apr 2017, 02:05, edited 1 time in total.

User avatar

Mad_Scientist
Gold
Gold
United States of America
Posts: 1680
Joined: 6 years ago
Location: Panhandle of Florida, USA
Region: USA & Canada
Preferred Brewing Method: Single-Vessel All-Grain (SVA)
City:

Re: Main BIABacus Help Testing Thread

Post by Mad_Scientist » 5 months ago

Please post the file, we'll take a look at it.

Post Reply

Return to “BIABAcus Help - Testing”

Brewers Online

Brewers browsing this forum: No members and 1 guest