Measurement, Mathematics and Records

1. Using BIABacus in Chrome Web browser.

   1 Replies 7404 Views

   First post by bundy, 9 years ago

   First post

   ---

   

   Guys, I just tried using BIABacus with Google's new Add-in for Chrome Office Editing for Docs
   
   and lo and behold BIABacas seems to work perfectly.
   
   My testing wasn't thorough but I tried changing a few things such as;
   
   Desired VIF
   Hop AA%
   Desired Gravity
   Changed Evap Rate
   Desired IBU's
   
   Each time the BIABacus Spreadsheet Recalculated and did what it was supposed to. :thumbs:
   
   This may be a very handy add-in for those living in the Apple or I-Pad worlds (Yet to test it on those platforms,...

   Last post

   ---

   

   There's always something bundy :roll:.
   
   LibreOffice works well on any platform and stays protected as long as users always save the file as an .xls. The only change that occurs is in the colours but that is not much to worry about.
   
   (See you Saturday :drink:)
   1 Replies
   7404 Views
   Last post by PistolPatch
   9 years ago
2. pre-pitching volumes and other measurements recap

   6 Replies 10129 Views

   First post by gnmrc, 9 years ago

   First post

   ---

   

   Hi!
   I'll brew my first beer in two days. I have a few questions about the measurement I will take in order to fill the BIABacus.
   I searched the forum for these answers but I really couldn't find everything I need.
   I know this is a lot but, even if I don't fully understand the meaning and the impact of every measure the BIABacus accepts, I'd like to keep track of all the things in the BIABacus.
   
   I'll start with the measurements for which I couldn't exactly understand the right measuring moment:...

   Last post

   ---

   

   I've tried to answer them as well using your original post hopefully to allow you to better understand.
   
   Thank you Lumpy! Now I have everything ready!
   
   Thanks everybody!
   6 Replies
   10129 Views
   Last post by gnmrc
   9 years ago
3. Mash Gravity Figures Needed for BIABacus.

   65 Replies 80438 Views

   • 1
   • 2
   • 3

   First post by BIABrewer, 11 years ago

   First post

   ---

   

   On your next brew, if you are a pure BIAB'er and do a mash-out , I'm wondering if you could take two gravity readings and record them here for us.
   
   What is a Pure BIAB?
   
   A pure BIAB is when all the water required in a brew is added to the mash. In other words, there is no active sparging involved.
   
   What is A Mash-Out ?
   
   When BIAB'ing, you can either pull the bag at the end of the mash and then bring this 'sweet liquor' to the boil or you can allow the bag to remain in the sweet liquor and...

   Last post

   ---

   

   Thanks cwier60 and the many others who have been contributing here. I know just how much effort it takes to do this.
   
   :thumbs:
   
   One thing I thought of the other day is that I should have asked people to record their base malt/s as this might explain the difference in some of the more extreme results. If you can remember what base malts you used and have time to edit your posts above, that might help us even more paint a picture.
   
   For now, I have given up on the idea of writing in a logarithmic...
   65 Replies
   80438 Views
   Last post by Pat
   9 years ago
4. BIABacus - estimated OG based on grain entered?

   14 Replies 18008 Views

   First post by madmatt, 10 years ago

   First post

   ---

   

   So let me start by saying as a new member that the BIABacus looks very powerful, great job! I will be using on my next batch. But my question is in regards to how I currently use brewing software for new recipes.
   
   Entering in a known recipe into BIABacus looks very straight forward. However, many times I do not have a recipe and start from scratch. So I start by adding in x amount of grain into the software. The software then shows me what my estimated OG is. I increase said grain until I reach...

   Last post

   ---

   

   The smell of the rose might vary but it will still smell like a rose.
   
   Exactly!
   
   I feel like I've accepted this as a grey area, as I do not even feel compelled to track every bit of the hop contributions. Something tells me that I would just unlock more questions than I gained in answers. Perhaps one day I'll dive into that rabbit hole, for now I'll go on experience.
   
   My believies tell me to handle bittering and aroma somewhat independently, just to ensure that I don't short my aroma. I'll...
   14 Replies
   18008 Views
   Last post by Rick
   9 years ago
5. What is your evaporation rate?

   30 Replies 38124 Views

   • 1
   • 2

   First post by BIABrewer, 12 years ago

   First post

   ---

   

   I was hoping to collect some more figures on kettle evaporation rates to see if the exisitng evaporation formula used in The Calculator needs any improvement.
   
   If possible, can you please post the following in this thread...
   
   1. Your average internal kettle diameter and type. (For keg users, see picture below and estimate.)
   2. How much wort you evaporated off during the boil. (Start of boil volume minus end of boil volume.)
   3. The duration of your boil. (eg 60 minutes, 90 minutes etc.)
   4. Any...

   Last post

   ---

   

   Nice stuff bundy! Let's do some maths...
   
   BIABacus on your kettle estimates 4.93 litres/hour or 1.3 gal/hour.
   
   Your actual is about 3.5 litres/hour or 0.925 gal/hr
   
   The formula you have linked to would give us with a 2.4kW element...
   
   2400/2256.4*60*60/1000=1.06364*60*60/1000=3.83 litres/hour or 1.01 gal/hour.
   
   That's not a bad match for you.
   
   If you had a 3.0kW element then...
   
   3000/2256.4*60*60/1000=1.06364*60*60/1000=4.78 litres/hour or 1.263 gal/hour.
   
   That's not a bad match for the...
   30 Replies
   38124 Views
   Last post by PistolPatch
   9 years ago
6. BIABicus and priming sugar calculation

   6 Replies 8882 Views

   First post by bundy, 10 years ago

   First post

   ---

   

   Gents, I just want to see if I am using BIABIcus correctly when it comes to priming calculations.
   
   I put in my CO2 volume into section H as well as my Fermentation temp. With that in Section Q it shows the amount of corn Sugar / dextrose to use per bottle. As well as bottles needed etc.
   
   In my case I have 21.5 litres going into 500ml bottles. I want a CO2 volume of 3.0, BIABIcus tells me I need 43 bottles and 3.6grams per bottle (Using 500ml Bottles) Now I bulk prime so 43 x 3.6 is 155grams (or...

   Last post

   ---

   

   Bumping this thread to ask...
   
   If you have feedback on what priming sugar rates are working for you, can you please post them in this thread even if you have already done so above? This would really help to finalise the BIABacus priming formula.
   
   Please note your height above sea level as well if you can. Much appreciated :peace:.
   6 Replies
   8882 Views
   Last post by PistolPatch
   9 years ago
7. VFO when jusing a Hop sock

   6 Replies 7865 Views

   First post by bundy, 9 years ago

   First post

   ---

   

   Guys, Qstn for the gurus. (Probably one only Pat can answer but we will see)
   
   First time I have used a Hopsock today (Must say I ask myself why I haven't before)
   
   Anyway, when using a hopsock does BIABacus expect you to take measurements with the hopsock still in the Kettle? Or do you remove and measure your EOBV?
   
   When removing the hopsock I had maybe 0.5L of Trub in my sock which I guess without a sock would normally be there??
   
   Anyway just clearing up as to what others do

   Last post

   ---

   

   Thanks Mally, good pickup. I obviously have an old biabicus version and just glanced at the fields to be sure I was talking about the right fields. I'll have to make sure I am using the latest one next time though so as to avoid confusion.
   
   Cheers
   6 Replies
   7865 Views
   Last post by bundy
   9 years ago
8. Thermometer.

   9 Replies 12196 Views

   First post by fongasbrew, 10 years ago

   First post

   ---

   

   What thermometer do people use,add pics aswell.
   
   Thanks.

   Last post

   ---

   

   I just this one for my next brew tomorrow.
   
   It has an extra dec point so hopfully more accurate. Did a test with some water from the kettle. A degree difference with my other thermometer.
   
   Sent from my GT-I9505 using Tapatalk
   9 Replies
   12196 Views
   Last post by nosco
   10 years ago
9. weighing hops.

   18 Replies 19006 Views

   First post by fongasbrew, 10 years ago

   First post

   ---

   

   Hello,
   How do people weigh there hops.
   I need 10 and 20 grams.
   
   Thanks for your help.

   Last post

   ---

   

   nuff said!! I'll let him know !! Yep he's just born ugly. :lol: :lol:
   18 Replies
   19006 Views
   Last post by jhough
   10 years ago
10. Unit conversion

    4 Replies 6646 Views

    First post by monkeyman, 10 years ago

    First post

    ---

    

    Not sure if this was already mentioned but I tried using the unit conversion page for gallons to liters and it was giving me a wrong value. I entered 3.57 gallons and it gave me 16.23 Liters. It was supposed to be 13.51 Liters. Not sure if this is an actual error or an operator error.

    Last post

    ---

    

    NP :)
    
    I know how that feels, i love the Edit post function, have helped me no end :)
    4 Replies
    6646 Views
    Last post by Yettiman
    10 years ago
11. GIB estimate question

    6 Replies 8255 Views

    First post by wstehling, 10 years ago

    First post

    ---

    

    What does the '/#' in the GIB estimate cell in Section M mean? When i enter my actual GIB it auto inserts a '/0'.
    
    Just curious.

    Last post

    ---

    

    Don't worry Yeasty, sometimes I forget stuff like that as well :). Got it, i wish my eyes were good enough to discern .004 though. :roll: :lol:
    
    Actually, the idea here is not really about entering measured gravity figures to three decimal places but mind you if you can't decide between 1.052 and 1.053, then sure, just type in 1.0525. The real purpose though is education. For example...
    
    Sometimes people might wonder why if they make a dilution, their post boil doesn't change. With only two...
    6 Replies
    8255 Views
    Last post by PistolPatch
    10 years ago
12. BIABacus -Acct for fermentables added near end of boil?

    5 Replies 7628 Views

    First post by wstehling, 10 years ago

    First post

    ---

    

    How do I acct for fermentables, in this case candi syrup, added with 15 min left in the boil in BIABacus?
    
    I brewed this yesterday and as I was plugging in my actuals to BIABacus as I brewed, my Gravity into Boil was 1.029. I had the candi syrup listed as part of the grain bill, but that appears to cause BIABacus to calculate as if it was there for the full 90 minutes, it calculated a 1.040 estimated GIB. This really caused me great confusion until i realized that I didn't add my candi syrup...

    Last post

    ---

    

    Well I checked out the new version and sure enough, there it is, I can now set my candi syrup to be a boil addition.
    
    Great job on 1.3T and especially the inclusion of the ability to separate the fermentables that are added during the boil! :clap: :thumbs: :party:
    5 Replies
    7628 Views
    Last post by wstehling
    10 years ago
13. Biabacus - Boil off question

    5 Replies 7056 Views

    First post by wstehling, 10 years ago

    First post

    ---

    

    So, I got my shiny new 10 tip natural gas burner in the mail and my shiny new 60qt Stainless Concord pot and decided I needed to test the Evaporation rate with just a straight water boil test, no grains.
    
    Here are my numbers for a 60 min boil on my 41.9cm x 41.9cm pot:
    
    --5Gal of water, which measured 5.375 in my pot, slightly less than the 5.41 that Biabacus predicts; probably a neglible difference
    --Volume at beginning of boil was still 5.375
    --Volume measured hot at Flame-out (VFO)was 3.75...

    Last post

    ---

    

    Something is wrong here, 60 quarts vs. 15.26 gallons.
    
    Lol, you noticed that too, those are the actual dimensions, measured 3x, 41.9cm x 41.9cm and the pot is stamped 60Qt and is also sold online as 60qt.
    
    Didn't really think it was worth worrying about, especially since the diameter (most important dimension in my mind) is dead on exactly 41.9cm.
    5 Replies
    7056 Views
    Last post by wstehling
    10 years ago
14. Switch from US gals to UK Gals?

    6 Replies 7441 Views

    First post by Yettiman, 10 years ago

    First post

    ---

    

    Hi,
    
    As far as I can see when I enter an amount is litres it is automatically converted to Gals, so I can see it in both units. This is great and extremely useful.
    
    However, it appears to be US gals, is there a way to set it to convert to UK gals?
    
    A check box somewhere I have missed?
    
    Nearly all of the auto claculations have an adjustment field but I cannot find one to change this setting.
    
    Thanks for all responses
    
    Yettiman

    Last post

    ---

    

    Thanks PP, I thought it might have been the compatibility issue, I know you (and the team) have put literally thousands of hours into BIABacus.
    
    At my level, I use it more as a teaching tool than a recipe database, and know it has much much more to teach me :)
    
    Thank you again PP
    6 Replies
    7441 Views
    Last post by Yettiman
    10 years ago
15. Attempted the Biabicus

    4 Replies 6859 Views

    First post by Weisseguy, 10 years ago

    First post

    ---

    

    So I tried the Biabicus for the first time. To create this recipe I have used the ingredients from a lagunitas clone. Then I used the same measurements and volumes from the last beer I brewed Which was a dead guy clone That mad scientist had all ready brewed. For example I had about 8 pounds of grains and Un fermentables. So I just kept this same weight measurement , I did the same with the hops. Then I simply divided the grain bill weight by the three new grains proportionally In my mind this...

    Last post

    ---

    

    Success! After applying your suggestions I have managed to convert a Low Integrity recipe to match my equipment. My problem was that i didnt understand that the the original grain bill design was the LI recipe. Kinda of a DuH moment for me :scratch: Anyhow I am feeling more confident now with the Biabicus. I think my next brew will be an original design instead of a clone.Thanks to all for helping me again.PP,MS and Yeasty. I will update you guys on this LLSS clone recipe when its complete.
    4 Replies
    6859 Views
    Last post by Weisseguy
    10 years ago
16. All measurements for brew day

    2 Replies 8692 Views

    First post by phytenphyre, 10 years ago

    First post

    ---

    

    Happy New Year, everyone!!
    
    I cannot seem to find what I am looking for and that is simply all the measurements I need during my brew day. Water level, hydrometer readings, temperature, etc. Is there more that I need to do/less? This would be a great help to know all the measurements I need to take. I will be putting all of these measurements into my comments section so I don't forget during my brew day...
    
    Are these the measurement's I need?
    1. Measure water level with initial water.
    2....

    Last post

    ---

    

    OH WOW!!!! Thank you so much, PP!!!! Exactly what I was looking for.
    2 Replies
    8692 Views
    Last post by phytenphyre
    10 years ago
17. Final Gravity reading

    2 Replies 4851 Views

    First post by porchfiddler, 10 years ago

    First post

    ---

    

    I just took a gravity reading from my latest beer to see if it was finished, as I generally do. I filled the test jar up and put in the hydrometer and took the reading 1.014, not finished, I need to give it some more time. Why do I need to take another one, can I not leave the beer in the test jar with the hydrometer in it, at the same temp as my fermenter and watch it until it is finished?

    Last post

    ---

    

    Thanks, PP. I kind of stopped taking final gravity readings too but some of my beers lately (the bottled ones) have seemed a bit overcarbonated and I wanted to squeeze all the gravity points I could out of this one. Also I've been doing cask ales and want to try racking to the pin a couple of points early instead of priming. As usual you have the answers!
    2 Replies
    4851 Views
    Last post by porchfiddler
    10 years ago
18. BIABacus Pre-Release - Your First Impressions

    414 Replies 580938 Views

    • 1
    • …
    • 13
    • 14
    • 15
    • 16
    • 17

    First post by BIABrewer, 11 years ago

    First post

    ---

    

    Here is a pre-release glimpse of the BIABacus for you whilst we re-write the site and finalise the release of the BIABacus.
    
    BIABacus PR1.3U - Blank Style - Blank Name - Batch A0.xls
    
    BIABacus PR1.3U - American Pale Ale - NRB's All Amarillo APA - Batch A0.xls
    
    Above files uploaded on 18th May 2018. Corrects WYWU error in Section F.
    
    Your first thought will most likely be...
    
    This looks way too hard :dunno:.
    
    Your second thought will most likely be...
    
    This is actually quite...

    Last post

    ---

    

    As always on liquids your mileage may vary some. Also, grind will change the absorption rate. Always try to grind the same setting for consistancy. Boil rate will change if you use a propane burner also.
    As far as To squeeze or not to squeeze , that is the question I personally have never had off flavors {tannins} due to squeezing the bag. I do also let it drain over a collender not the pot. Only change in flavor profile has been due to I brew outside and will pick up wild yeast due to spring...
    414 Replies
    580938 Views
    Last post by ShorePoints
    1 year ago
19. Why does using hop sock affect grain quantity in BIABacus?

    3 Replies 5652 Views

    First post by the-erl, 10 years ago

    First post

    ---

    

    I just finished my 3rd BIAB and so am still getting used to the BIABacus. I think its an amazing tool and really appreciate all the hard work that must have gone into it!
    The more I use it I'm sure the more questions I'll have and hopefully there'll be someone on here to give me some answers or point me in the right direction.
    So, the first of many questions; I was recently playing with BIABacus whilst putting together my 3rd BIAB and noticed that when I enter a 'N' into the 'hop sock used' it...

    Last post

    ---

    

    Awesome, thanks guys :thumbs:
    
    The link was very useful, cheers MS!
    
    I've not used any other brewing software, only the BIABacus, so I'm obviously bias but it's a bloody good tool I'm sure you'll agree :clap:
    
    I think all those involved in developing it need a big pat on the back and a beer :salute:. Hopefully as I gain more and more experience I'll be able to contribute to the forum to help others!
    
    Cheers,
    
    erl
    3 Replies
    5652 Views
    Last post by the-erl
    10 years ago
20. How to get larger batches?

    5 Replies 7255 Views

    First post by Cederbusch, 10 years ago

    First post

    ---

    

    Hi there. A beer brewing and loving Swede here. Hence the Swinglish .
    
    I am fairly sure that this information is in here somewhere but it is a vast place to look trough. Searching demands knowledge on what key words to search for. So I beg your forgiveness och hope for some help on my issues.
    
    Quite new to brewing. Did my 11th batch two days ago. And that was also my first BIAB batch. I am intrigued by the, supposedly, simpleness. But, and that is a very large dito, it makes to small batches....

    Last post

    ---

    

    Maybe I should tell you how my first BIAB really went. I made a recepie with BrewMate, a Kölsch (my wife is German and I lived i Cologne for a time and got to enjoy this beer).
    
    The theory
    Boil volume: 28 liters (7.4 gal)
    Post boil and chill volume 23 liters (6 gal)
    Grain: 4.9 kg (10.8 lbs)
    Est OG: 1.049
    
    Reality
    23 liters (6 gal) of mash water for 90 min
    Sparged 7 liters (1.8 gal) over the grains and pressed the bag. This gave aprox. 28 liters boil volume.
    Into the fermenter I finally had...
    5 Replies
    7255 Views
    Last post by Cederbusch
    10 years ago
21. BIABacus Bugs (PR 1.3)

    50 Replies 40830 Views

    • 1
    • 2
    • 3

    First post by PistolPatch, 11 years ago

    First post

    ---

    

    A few bugs have been reported on the BIABacus Pre-Release 1.3 but they are scattered over several threads. Can you do us a favour and re-post them here if I have missed them below?
    
    Many thanks,
    PP
    
    PS Normally this would not be a problem but some unforeseen things have chewed up a lot of time and we have been hoping for a major improvement in 1.4.
    
    List of Current Errors / Possible Mods (Will Keep Updated)
    
    All of the below are fixed in PR 1.3G which is posted here .
    
    1. Section M - spelling...

    Last post

    ---

    

    Hi PP,
    
    I just thought it would be a lot harder to find errors, if the base formulas had not been changed in error,
    
    Something we have all done, on a lot less complicated spreadsheets that this one, I know I have :)
    
    Thanks for your help
    50 Replies
    40830 Views
    Last post by Yettiman
    10 years ago
22. Switch from BrewMate to BeerSmith - Volume problems

    11 Replies 12188 Views

    First post by CptFrederickson, 10 years ago

    First post

    ---

    

    Hello all,
    
    I've recently switched software as stated but having some difficulties with the setup.
    I've always used software in sync with The Calculator, but am having a little difficulty matching the values.
    I've followed the equipment setup and I'm happy with the values from this; near perfect match.
    However, when I plug a recipe in, the water volume is either too high or too low, by a good few litres!
    How can I get this to calculate the volume matched with The Calculator, or should I just...

    Last post

    ---

    

    That's some clever stuff PP! Once again I'll defer to your knowledge on this, as I was getting good efficiency in my Calculator days so given what you've said I don't expect any problems.
    Perhaps I was just craving the joy of old when I overshot my efficiency :whistle:
    
    I can see you've spent a lot of time working on this, so I can understand why you'd be a little peeved that programs like BeerSmith still have taken on your sage advice!
    
    Once I get this brew under my belt I'll post the recipe...
    11 Replies
    12188 Views
    Last post by CptFrederickson
    10 years ago
23. Specific Gravity to Plato conversion for dummies

    2 Replies 6217 Views

    First post by porchfiddler, 10 years ago

    First post

    ---

    

    I needed to convert Plato to Specific Gravity today so I found this converter online with the formula and table. Looking at a few minutes I realized that if you take the specific gravity say 1.048 and divide the 48 by four you get plato 12 which is correct. Likewise 10 Plato * 4 = 1.040. I did not know that' did all y'all? I'm sure this is not new but it's nice to be able to do things quickly in your noggin. :headhit: Seems easier than the complicated formula below and works in the normal...

    Last post

    ---

    

    I haven't used plato, but this would be handy printed off and stuck to the brew fridge for a quick reference.
    
    :thumbs:
    
    Yeasty
    2 Replies
    6217 Views
    Last post by Yeasty
    10 years ago
24. Gravity Measurement Anomalies?

    32 Replies 25726 Views

    • 1
    • 2

    First post by mally, 11 years ago

    First post

    ---

    

    I have a question that has been bugging me for some time now, and i wondered if anybody else has encountered something similar?
    for my last few brews i have noticed a trend when carrying out the procedure (below). Where the post boil but pre-chill gravity appears higher
    than the chilled gravity.
    
    1) After mash but pre-mashout; take a 5ml sample for the refractometer ALLOW TO COOL. Take reading.
    2) After mashout but pre-boil; take a 5ml sample for the refractometer ALLOW TO COOL. Take reading....

    Last post

    ---

    

    Yes, with such small samples, it doesn't take much to through it off.. That's the best my mind can do w/o being there :)
    32 Replies
    25726 Views
    Last post by HbgBill
    11 years ago
25. Chasing Numbers.

    10 Replies 11057 Views

    First post by johns, 11 years ago

    First post

    ---

    

    So I am perplexed as to why my efficiency is lacking and I am hoping someone here can give me some advice as to what I am doing wrong. The following is the basic recipe used.
    
    I crushed the grains from 030, and 028 and double crushed at 028(030 was the first batch and 028 was the second batch). Did a 90 minute mash stirred at the doe-in until there was no doe balls. Preheated oven to 155 f, but the pot inside the oven and stirred again at 45, and 90 minute mark. After that I did a rest at...

    Last post

    ---

    

    Looks like the guys have got a lot of your questions sorted johns. Good on 'em!
    
    I've tidied up your BIABAcus file and for the reasons GR explained above, I have posted it in this post of the thread he linked. You'll also find a lot more info on the BeerSmith side of things in a link I have included in the other post.
    
    Have fun!
    10 Replies
    11057 Views
    Last post by PistolPatch
    11 years ago