BrewCipher 6

Discussion in 'Homebrewing' started by VikeMan, Dec 17, 2019.

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

    deadwolfbones Pundit (795) Jun 21, 2014 Oregon

    All! I use most of them on a regular basis.
     
  2. VikeMan

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

    I'll look into it.
     
    deadwolfbones likes this.
  3. deadwolfbones

    deadwolfbones Pundit (795) Jun 21, 2014 Oregon

    Much appreciated!
     
  4. riptorn

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

  5. VikeMan

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

    It's more or less generic. Looking at Weyermann's current specs, You might want to change the PPG to 34 if that's what you're using.
     
    riptorn likes this.
  6. riptorn

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

    Thank you, sir!
     
  7. menvert

    menvert Initiate (0) Mar 21, 2020

    Thank you so much VikeMan for Brewcipher
    I have been using it for about 4 years

    I have been using V4.23 for ages, and moved to 6 today.
    It seems to be wildly different (and incorrect for me) in calculating my mash pH
    recipe is - 7.5kg (75%) wayerman pils, 1kg (10%) vienna, 1kg(10%) Wayerman pale wheat .5kg carapils for 46L batch 30L strike water
    Adding 10g cacl2 12g caso4 to highly filtered basically distilled water (I have it set to 100% distilled in water tab)

    V4.23 says to add 5ml 88% Phosphoric to reach 5.28, which I did last time
    V6 says ph 5.24 with no other additions other than salts
    So I tried no additions, thinking maybe PH was why my last batch of the same recipe wasn't quite right. however PH measured was around 5.5

    Any ideas what could be amiss?

    I also though what if I add acid malt instead and see it's effect , on 4.23 100g drops ph by .08 on V6 it drops it 3.92

    I checked all my brew-house values and as far as I can tell they are all the same

    Thanks
     
    riptorn likes this.
  8. VikeMan

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

    @menvert Version 6 uses the most recent version of @utahbeerdude's MpH model. One change is that there are many malts whose pH contribution characteristics were individually measured and modeled. For your recipe, I suspect the main difference between the old and new predictions was due to the wheat malt, which has a lower buffering capacity, so it's "easier" (than thought by the old model) to reduce the pH through acid additions when wheat malt is in the grist.

    As to why your measured pH was different than predicted (5.5 vs 5.24), a few possibilities come to mind...
    - Natural variation in malt lots
    - pH meter calibration
    - water filter: is it an RO filter? And how effective? Perhaps there was some alkalinity left?
    - some combination of the above, stacking up

    All of the above conjecture is off the top of my head, without running actual numbers through anything. But I'd be happy to take a look at your workbook just to make sure nothing got grunged (e.g. data on the Grain Lookup tab).
     
  9. menvert

    menvert Initiate (0) Mar 21, 2020

    Thanks for the prompt reply @VikeMan
    -I use organic weyerman pils and wheat, so that's likely different (though the old version was pretty good at estimating the ph)
    -I did a calibration of the PH meter during my tests and it was still calibrated, it's a designed for home-brew meter with ATC, so should be pretty close.
    -I have Tank water with a very fine (.1 micron) filter, my TDS is about the same as when I had an actual RO system, so it should be very low on minerals, just whatever comes off the concrete tiles and gets past the filter.
    My files are here - https://1drv.ms/u/s!AsCPyct93gKOg84vzXnmujB_bxzPBA?e=IQs6L8
    I am wondering if there is some imperial/metric translation not working properly? as it behaves so differently.

    I'll probably stay on the old one for now, or both till I work it out, but thought this feed back might reveal a bug in the code.

    IMO brewcipher is just so much better than any of the other programs out there, love your [teams] work. I have 69 batches done so far
     
  10. CShell1234

    CShell1234 Initiate (0) Oct 25, 2018 New York

    Hey @VikeMan i just had a random thought this morning and now I have to ask... is brewcipher infinitely scalable? Could a professional brewery use your software to build say a 30 BBL recipe, or do formulas get somehow skewed? Is there anything in professional brewing software that isn’t in your software or vice versa, either out of convenience of necessity?
    Thanks!
     
  11. VikeMan

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

    Yes, it can be used for large batches, as long as the Brewhouse parameters are set accordingly. I know of at least one 15 barrel brewery that uses it. There may be larger breweries using it, but I don't know. There's no reason they couldn't.


    BrewCipher doesn't track ingredient inventories, which some pros might need/want. But I have to say that the breweries I've worked with (some of whom use BeerSmith, which I believe does do inventories) don't track their inventories in their brewing software anyway. One thing missing from "professional" software is considering the makeup of the grain bill when predicting attenuation, which to me is a high crime, or at least a misdemeanor.
     
    Applecrew135 likes this.
  12. CShell1234

    CShell1234 Initiate (0) Oct 25, 2018 New York

    Ha, good to know... and yes, I have yet to stop having my mind blown by how accurate your FG estimate is every time.

    Also, I meant no slight by not calling brewcipher professional software, as it is the best thing I have ever used!
     
    VikeMan likes this.
  13. VikeMan

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

    Well I'll be damned. In metric (starting with a clean sheet), I get a prediction of 5.24, just like you did. But in U.S., I get 5.31. Looks like I have some troubleshooting ahead of me. Thanks for the catch!
     
    menvert likes this.
  14. VikeMan

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

    BrewCipher 6.1 spreadsheet, Quarantine Edition, is now up for download.

    Changed/New in Version 6.1:

    - Reduced validation for minimum pitch rate(s) allowed (validated) to accommodate the crazy low pitch rates some folks are using with Kveik strains

    - Added Mecca Grade malt specs

    - Added a "User Scratch" sheet (in addition to the old NotePad sheet) that can be used for whatever the user wants, i.e. user formulae and whatnot.

    - Fixed a bug affecting pH calculations when the Brewhouse is Metric.

    BrewCipher runs in Excel, Apache Open Office, Google Sheets App, and the iOS Excel App. Download it from -> Google Drive <- or -> DropBox <-. Go ahead. Don't cost nothin'.
     
  15. riptorn

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

    Thanks for the update, especially the scratch pad and unlocking Excel tools in that tab. :slight_smile: :+1:
     
  16. menvert

    menvert Initiate (0) Mar 21, 2020

    Thanks for the update @VikeMan
    The PH seems improved (I use metric)
    I'll be very careful and confirm my ph next brew day, in about 2 weeks time. I guess the unknown variables are my water and my Organic version of the Weyermann grains. Probably the easiest thing would be if I buy some RO water for my next brew to be sure of that variable.

    Is there any simple way I can do a test for my grain to see how it compares to your values for the non-organic version?

    The Acidified malt in the water tab seems to be out still 100g lowers my ph by 0.08 in v4.23 but v6.1 lowers it by 3.43
    Acid malt has never been that effective at lowering ph! (200g was usually enough in this recipe to drop ~ 0.2 into my preferred range, v6.1 says 6g is enough)

    I have added my example and even converted 6.1 to imperial if that helps (the numbers seem to behave the same whether metric or imperial with 6.1)
    https://1drv.ms/u/s!AsCPyct93gKOg84vzXnmujB_bxzPBA?e=XBdyid

    Thanks
     
  17. VikeMan

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

    I don't think there's a really simple way. You can download a white paper from this link that describes a way to do it.
    http://homebrewingphysics.blogspot.com/2018/05/

    Dang it. There was a conversion issue. Version 6.2 is now up, which fixes.
     
    menvert likes this.
  18. menvert

    menvert Initiate (0) Mar 21, 2020

    Gday @VikeMan, Thanks again for looking into bugs.
    I have put my data into v6.2 and it looks a lot closer to what I'd expect for the PH and Acid malt
    I did notice another error, possibly only a display error. (in 6.1 and 6.2)
    In the water tab it's not showing the same grain weights as the recipe tab

    The recipe is 7.5kg, 1kg, 1kg, 0.5kg (it's multiplied all except for the 1st grain by 2.2)
    Water tab table is showing;
    Grain Color Deg L Type Kilograms Grist Fraction (f)
    Weyermann Pilsner 2 B 7.50 0.75
    Weyermann Pale Wheat 2 W 2.20 0.10
    Vienna (generic) 3.5 B 2.20 0.10
    Briess Carapils 2 C 1.10 0.05

    Example is here - https://1drv.ms/u/s!AsCPyct93gKOg84vzXnmujB_bxzPBA?e=3bbqMf

    Thanks
     
  19. VikeMan

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

    Thanks. Yes, that's a (metric) display issue that fortunately doesn't affect the calcs. It's now fixed, in V6.3, available in the usual places.
     
    menvert and riptorn like this.
  20. menvert

    menvert Initiate (0) Mar 21, 2020

    Thanks @VikeMan My brew on the weekend went well, the PH calculations for my similar recipe but using only salts, malts and acid malt came in at 5.25 my actual readings at 10 minutes and a few other points during the mash were between 5.22 to 5.26 mostly 5.23 - so in terms of grain differences, measurement variance and volume errors I think that's spot-on now.

    Thanks
     
    utahbeerdude and VikeMan like this.
Thread Status:
Not open for further replies.