Brewcipher 5

Discussion in 'Homebrewing' started by VikeMan, Dec 30, 2017.

Thread Status:
Not open for further replies.
  1. VikeMan

    VikeMan Grand Pooh-Bah (3,067) Jul 12, 2009 Pennsylvania
    Pooh-Bah

    Since row 149 has no data/comments in it in the clean download version(s), the only way for that comment to have got into D149 (since you didn't type it) would have been if you at some point copied stuff to there from another row. But as long as the data in the cells is right, you're good to go. If you want, you can delete that comment. It doesn't do anything.
     
  2. KeyWestGator

    KeyWestGator Savant (1,159) Jan 21, 2013 Florida
    Trader

    Hey @VikeMan, I'm using hop extract for the first time since you updated Brewcipher to include it. What should I input for the weight? I thought I had read somewhere that I could put it in ml, but that's not right and now can't find where I might have read that (probably because I didn't). In any case, does anybody have an idea what 3ml of extract weighs? Not sure how to get an accurate value with it in the syringe and don't have an empty syringe to weigh. Thanks for all you do vike.
     
  3. VikeMan

    VikeMan Grand Pooh-Bah (3,067) Jul 12, 2009 Pennsylvania
    Pooh-Bah

    I think the density almost certainly varies by brand/type of extract, but here's one conversion that pops up repeatedly on the internet:

    @60C: 1.05 grams / milliliter, or 0.037 ounces / milliliter


    Note that would be a little denser at room temp (21C). Cheating a little and using a density/temp conversion for water, you'd get:

    @21C: ~1.066 grams / milliliter or 0.0376 ounces / milliliter

    I should also add...pay attention to the "CO2 Hop Extract Bonus Factor" on the Brewhouse Parameters tab. Lore varies considerably regarding how much more efficiently hop extract is utilized vs. traditional hops. (This is aside from the higher AAs of the extract itself.) The default in BrewCipher is 1.40, or a 40% bonus over leaf. This is a big YMMV.
     
    KeyWestGator likes this.
  4. Layerup

    Layerup Initiate (0) Aug 28, 2015 Oregon

    Greetings Vikeman, as previously stated, thanks for the tool, it's a pretty neat little piece of work. I think I have been using version, I dunno, 2 or 3 for a long time now, it's build date is June, 2013. Looks like the newer version has quite a few new features that are fun to explore. The water salts tab in particular I will need to spend some time on and evaluate.

    One comment I'd like to discuss, is about the carbonation sheet, particularly the line length calculator. I am curious how you are performing the Colebrook iterative analysis, kinematic viscosity evaluation, and temperature density adjustment (this all assumes you are following an energy balance approach...). I ask because I worked out a solution last year, and my values vary quite a bit from yours. In general, I am calculating more length of beer line required than what your sheet is suggesting.
     
  5. VikeMan

    VikeMan Grand Pooh-Bah (3,067) Jul 12, 2009 Pennsylvania
    Pooh-Bah

    Not really. BrewCipher uses a pretty simple "gravity and line resistance" approach. Regardless of the approach, I think the biggest (and unknowable to the designer) variable is going to be the true resistance of any given sample of beer line, which is why the model in BrewCipher also has a "Keg Line Resistance Multiplier" on the Brewhouse Parameters tab for the the user to tweak if needed/desired.
     
  6. Layerup

    Layerup Initiate (0) Aug 28, 2015 Oregon

    I have to disagree with you here. Trustworthy sourcing of beer line friction factor is fairly easy to come across. Even if you don't have an exact value, all you need to do is use a value in the rough order of magnitude. Why? Because for 10' of line, the line resistance doesn't play a very large part of the calculation. Minor losses due to fittings play just as significant of a role, but they seem to go missed more often than not.
     
  7. VikeMan

    VikeMan Grand Pooh-Bah (3,067) Jul 12, 2009 Pennsylvania
    Pooh-Bah

    If you have a model that is demonstrably (not just theoretically) more accurate on average, and can be configured by the average brewer, I'd probably use it.
     
  8. Layerup

    Layerup Initiate (0) Aug 28, 2015 Oregon

    Sent you a PM.
     
  9. CShell1234

    CShell1234 Initiate (0) Oct 25, 2018 New York

    Hey @VikeMan, I use BIAB but I also do a small sparge, so the biab indicator doesn’t exactly work for my situation. I have an “HLT” with only a 3 gallon capacity, but sometimes brewcipher will will say something like, 5 gallon mash and 4 gallon sparge... is there a way to tell it what my max sparge is? Or should I just take those 2 numbers, add them together and then subtract say 2 gallons for a sparge? Thanks!
     
  10. VikeMan

    VikeMan Grand Pooh-Bah (3,067) Jul 12, 2009 Pennsylvania
    Pooh-Bah

    In your case, I would tweak the Strike Water to Grain Ratio value upward, so that more of the total water goes to the strike and less to the sparge. Even if you want to hit 2 gallons exactly for the sparge, it should only take about 30 seconds max of tweaking.
     
    CShell1234 likes this.
  11. KeyWestGator

    KeyWestGator Savant (1,159) Jan 21, 2013 Florida
    Trader

    This is exactly what I do.
     
    CShell1234 likes this.
  12. CShell1234

    CShell1234 Initiate (0) Oct 25, 2018 New York

    Awesome, thank you!
     
  13. riptorn

    riptorn Pooh-Bah (1,776) Apr 26, 2018 Georgia
    BA4LYFE Society Pooh-Bah Trader

    When adding this malt to the GRAINLOOKUP there are descriptions that I’m not sure how (or if) they relate to the column headers:

    Extract FG: 78.6%
    Protein: 11.6%
    S/T Ratio: 52.1
    Alpha Amylase: 30.2
    DP: 82
    Color: 6.8 SRM

    Is that enough info to fill all, or at least the most important, fields? Should I contact Riverbend for more spec's?

    Riverbend Malt House (Heritage Malt is about half-way down the web page)
    "Notes of caramel and toasted bread are prominently featured in this product. We've developed the color and aroma of this malt to perform like a light Munich/Vienna style malt. This versatile malt packs enough diastatic power to perform as a base malt in a Belgian Dubbel recipe or can be used at lower percentages in an Ordinary Bitter."
     
  14. VikeMan

    VikeMan Grand Pooh-Bah (3,067) Jul 12, 2009 Pennsylvania
    Pooh-Bah

    Here's what I'd put in each column:
    Grain: Riverbend Heritage
    PPG: 36 <78.6% x 46 PPG, i.e. the maltster's "extract FG" times 46 PPG (sucrose reference)>
    Extract affected by... : y <because it's a grain>
    Basic Attenuation: 0.78 <copied from Munich 6L, close enough>
    Attenuation Affected by... : y <because it's a grain>
    Lovibond: 6.8 <from maltster's "SRM" spec>
    DP: 82 <maltster's spec>
    pH Type: B <because it's a base malt>
    Dissolved Gallons per...: NA <because it's a mashed ingredient>
     
    riptorn likes this.
  15. riptorn

    riptorn Pooh-Bah (1,776) Apr 26, 2018 Georgia
    BA4LYFE Society Pooh-Bah Trader

    Thanks.
    I hit them all except the lovibond. The few online conversion tools I found come in at around 5.5 (+/- 0.1), and one returned 6.0.
     
  16. VikeMan

    VikeMan Grand Pooh-Bah (3,067) Jul 12, 2009 Pennsylvania
    Pooh-Bah

    Those conversion tools apply to finished beer.
     
    riptorn likes this.
  17. Granitebeard

    Granitebeard Zealot (549) Aug 24, 2016 Maine

    @VikeMan I have a question as this came up when talking about homebrew con with a buddy.

    I was talking about how I was cold crashing my beers to keg them and was worried that one of my fridges was too cold and might freeze the beer. My buddy thought it was kind of funny and was picturing beer slushies. I said it would have sucked because I wouldn't know how to keg it, and I would have no way of knowing the true ABV of it, or so I think. Then we started to talk about Eisbocks which made it more of a question...

    So the question is: If one freezes a beer and removes the ice or just kegs what is liquid, what is the best way to determine ABV?

    I would think just using SG for the reduced volume, but how would you account for that when making a recipe? Is it something that can be predicted in Brewcipher? Perhaps I am making this too complicated....
     
  18. VikeMan

    VikeMan Grand Pooh-Bah (3,067) Jul 12, 2009 Pennsylvania
    Pooh-Bah

    The calculation is pretty straight forward. The only assumption you have to sort of take on faith is that the ice contains only water (no alcohol). With that in mind...

    Distilled ABV = Undistilled ABV x (Undistilled Volume / Distilled Volume)

    Undistilled is your original beer.
    Distilled is the beer you're left with after removing the ice.
     
    Granitebeard likes this.
  19. HogFan07

    HogFan07 Initiate (0) Aug 16, 2019 Arkansas

    I've been using Brewcipher for a while (very much still new to brewing though) and I have to say it is pretty awesome. Thank you @VikeMan. It's like when the iPad came out, capable of so much yet so simple, it just works. I was wondering about the same button issue. I and running 5.0 on google docs but I have tried it on excel and I can't get a button to work. I have always just followed what the recipe said but I have a lot of stuff sitting around and I wanted to play with some number and noticed this either wasn't working on my set up or I didn't know how to use it correctly. Thanks once again!
     
  20. VikeMan

    VikeMan Grand Pooh-Bah (3,067) Jul 12, 2009 Pennsylvania
    Pooh-Bah

    Some additional info needed...
    To which (macro) button do you refer?
    And what happens when you click on it?
    What kind of computer are you using?
    Are you using the .xls version of the sheet?

    Brewcipher Macros don't work in google docs, or at least they didn't last time I looked at google docs. But they should work in excel, as long as you have macros enabled.
     
Thread Status:
Not open for further replies.