Brewcipher 5

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

  1. VikeMan

    VikeMan Meyvn (1,439) Jul 12, 2009 Pennsylvania

    BrewCipher 5.0 spreadsheet, the Hoppy New Year Edition, is now up for download.

    New in Version 5.0:
    - Support for Cryo and CO2 Extract Hops
    - Added Water Temperature Warnings (if required temp exceeds boiling)
    - Some minor tweaks, display fixes, and housekeeping

    Feature Recap...
    - Predicts attenuation based not only on yeast strain, but also on mash conditions and grain bill composition
    - Understands that simple sugars are 100% fermentable, and that they are not subject to mash efficiency or yeast strain factors
    - Understands that some gravity contributors are not fermentable at all
    - Accounts explicitly for wort and water losses, and adjusts total water (and related calculations) accordingly
    - Uses a correct Tinseth formula with Avg Boil Gravity in the 'bigness' factor rather than the pre-boil OG (which is both popular and wrong)
    - Incorporates optional Modified Tinseth and Rager Formulas…
    ------ Limits IBUs to 110 (solubility limit)
    ------ Splices new utilization curve to Tinseth and Rager curves above 65 IBUs, to more closely agree with actual vs theoretical IBUs measured
    ------ Adds bitterness contributions for post boil hop additions, modeled and extrapolated from the work of Mark G. Malowicki
    - Hop Utilization Multiplier parameter to fine tune hop utilization to your system
    - First Wort Hopping
    - User adjustable Pellet/Leaf/Cryo/CO2 Extract Hop Bonuses/Penalties
    - Single infusion batches with single batch sparge, or mashout and lauter, or Brew-In-A-Bag
    - Wort Oxygenation Recommendations
    - Lagering Days Recommendations
    - Highlights any Gravities, ABVs, IBUs, and SRMs that are not within BJCP style guidelines, for 2008 and 2015 guidelines
    - Computes Diastatic Power for the Mash, and warns when grist's DP is marginal or poor
    - Scales Grain Bill to any desired Original Gravity
    - Scales Hop Bills to any desired IBUs
    - Calculates Mash pH and results of acid and Brewing Salt Additions, including Sparge Water acidification
    - Predicts Mash Efficiency based on known Efficiency and change in grain weight and/or sparge to no-sparge or vice versa
    - Automatically computes Yeast Starter Volumes, including stepped starters. Supports harvested yeast slurries.
    - Includes an optional, alternate ABV calculation
    - Inputs for Post Boil/Post Fermentation gravity and volume data, to compute actual mash efficiency, attenuation, and ABV
    - Converts Refractometer readings Specific Gravity Values
    - Choice of U.S. standard measurements or Metric
    - Choice of Plato or SG gravity measurements
    - Carbonation Calculations
    - Hydrometer Specify Gravity Temperature Correction
    - Mash Tun Overload and Required Temperature Exceeding Boiling Warnings
    - Kegging Beer Line Length calculations
    - CO2 Hop Extract and Cryo Hop Support
    - More user selectable Brewhouse Parameters than you can shake a stick at (but the defaults will work pretty well for most people too)

    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'.
  2. SFACRKnight

    SFACRKnight Meyvn (1,188) Jan 20, 2012 Colorado

    Thanks again @VikeMan for the work you do.
    Mothergoose03 likes this.
  3. Granitebeard

    Granitebeard Initiate (93) Aug 24, 2016 Maine

    O.O now I just have to go find the malts I added from the local Maine Malters and update the spread sheet again. Thanks.
  4. VikeMan

    VikeMan Meyvn (1,439) Jul 12, 2009 Pennsylvania

    A tip from the user guide to make that easier next time...

    Add your grains in a different font color to make it easier to copy them into later versions of the spreadsheet when released. You can sort by color in your old version, then copy your own block of ingredients into the new version, and finally re-sort by name or whatever column you want.
  5. OldBrewer

    OldBrewer Aspirant (239) Jan 13, 2016 Ontario (Canada)

  6. Granitebeard

    Granitebeard Initiate (93) Aug 24, 2016 Maine

    Yea thought about that this time... Fortunately the LHBS posts the rough colors on their site.
  7. TooHopTooHandle

    TooHopTooHandle Initiate (83) Dec 20, 2016 New York

    Thanks for all your hard work @VikeMan!
  8. GetMeAnIPA

    GetMeAnIPA Zealot (533) Mar 28, 2009 California

    You're awesome! Thanks.
  9. BoardwalkBock

    BoardwalkBock Devotee (455) Aug 18, 2012 New York

    I downloaded the new version (thanks for all your work! @VikeMan) this morning on a Windows computer and the spreadsheet worked as smooth as butter. I then emailed myself the German Pils recipe I put together and tried to open it on my Mac but it says the file is password protected. Since the recipe is fresh in my mind I just tried to download the spreadsheet again and when I downloaded it from both Google Docs and DropBox it said the file is still password protected. Is this no longer compatible with Mac OSX?
  10. VikeMan

    VikeMan Meyvn (1,439) Jul 12, 2009 Pennsylvania

    Well that sucks. The file itself (i.e. just opening the file) is definitely not password protected. Cross-platform issues can be a pain, and can arise from differences in the basic OS, the OS version, the spreadsheet Application, etc. And I don't know that I've ever claimed OSX compatibility. (The user guide even says that it's unknown.) That said, I did go and recompile the .xls this morning under an older windows version and excel version... (a sheet saved in "Excel 97-2003" format in Excel 2013 is not bit for bit the same as a plain Excel 2003 sheet....go figure)... so I went older and uploaded a recompiled .xls to both locations this morning. Let me know if the new build works for you. If not, I fear OSX (at least some versions of it) may be SOL.
  11. videofrog

    videofrog Devotee (493) Nov 13, 2010 Texas

    I'm guessing the issue might be more related to your version of Office. I'm having no issues with BrewCipher saved as a Macro-Enabled Workbook in Office 2016. OS is 10.12.6.
  12. redgorillabreath

    redgorillabreath Initiate (124) Mar 29, 2015 Pennsylvania

    Looking forward to giving this a test drive. Several years ago, BC had become a central part of my routine...Thanks!!!
  13. Curmudgeon

    Curmudgeon Disciple (302) May 29, 2014 Massachusetts

    @VikeMan I know you said it "doesn't cost nothin'" but is there a supporter's version? Or do you have.....uhhhh, what do the kids call it..Patreon? Or something/somewhere I can donate for your work?
    Mothergoose03 likes this.
  14. VikeMan

    VikeMan Meyvn (1,439) Jul 12, 2009 Pennsylvania

    Nah. Thank You for asking though.
    Mothergoose03 likes this.
  15. BoardwalkBock

    BoardwalkBock Devotee (455) Aug 18, 2012 New York

    It works now. Thank you very much. I've been using V3 and V4 for quite awhile on Mac now so the compatibility has never been an issue until now. I think it definitely is an issue with the version of Office I have on my desktop.

    VikeMan likes this.
  16. downhillonwater

    downhillonwater Initiate (0) Jan 17, 2018

    @VikeMan, Thanks very much for BrewCipher -- it's excellent. I've been brewing about a year and have used it from the beginning. I'm a chemist and so appreciate the breadth and depth of the work rooted in the science of brewing that you've pulled into one place. For example, your approach to modeling the heat capacity of the mash tun as an equivalent mass of water is great work.

    I like the way you've laid out the recipe page when I'm designing a new calculates everything you need (e.g. sparge water amount) with other fixed values (e.g. boil off rate and batch size). When I'm instead following someone else's recipe I find it's easier to determine values like sparge water and boil off by working from the SG of the first runnings toward the desired OG. With your permission, I'd like to take a crack at a modified math flow through the recipe page. I very much respect the work you've done and don't want infringe the "intellectual property" you have invested.

    Happy to discuss more if you like or drop the topic all together.
    Thanks. Steve (downhillonwater)
  17. VikeMan

    VikeMan Meyvn (1,439) Jul 12, 2009 Pennsylvania

    @downhillonwater, Sorry, but BrewCipher is going to remain protected. It's not just that it's intellectual property (mine and others' used by permission) and therefore copyrighted, but my experience from my professional programming days was that opening up freeware/shareware sometimes results in alternate versions being hung on the net that appear to be, but aren't, the original. I'm not saying that you would do that, but I'm not taking chances with this.
  18. VikeMan

    VikeMan Meyvn (1,439) Jul 12, 2009 Pennsylvania

    Version 5.1 is now up. By popular demand, meaning a couple people have asked for it, 5.1 adds Multi-Step Infusion Mash functionality.

    Please note: If you are a METRIC user and upgrade from version 5.0 or older, please see the popup note for the "Mash Tun Initial Heat Absorption Value" parameter on the Brewhouse Tab. You'll need to change this parameter. (U.S. Standards users will not have to change what they were using. If U.S. Standards users had tweaked it, simply re-input the value you had tweaked it to. If U.S. Standards users were successfully using the default, jut leave the default as is.)

    BrewCipher runs in Excel, Apache Open Office, Gnumeric, LibreOffice, Google Sheets App, and the iOS Excel App. Download it from -> Google Drive <- or -> DropBox <-. Go ahead. Double your money back if you don't like it.
  19. TooHopTooHandle

    TooHopTooHandle Initiate (83) Dec 20, 2016 New York

    Thanks for all your hard work and efforts with this! I love this spread sheet and its highly accurate! Cheers!
  20. riptorn

    riptorn Initiate (56) Apr 26, 2018 North Carolina

    What's the chances of modifying protection in a future version to allow adding (but not deleting) sheets to saved copies, or maybe adding an unprotected sheet or two for end user customization?
    jbakajust1 likes this.
  21. VikeMan

    VikeMan Meyvn (1,439) Jul 12, 2009 Pennsylvania

    I can do the latter on the next version. Thanks for the suggestion.
  22. riptorn

    riptorn Initiate (56) Apr 26, 2018 North Carolina

    Thanks. I'm guessing it would allow copying content from another workbook and pasting the content to the new sheets in BC? Don't see why it wouldn't.
    Awesome compilation, btw. I appreciate the time you put into building and updating it.
  23. hopb4fg

    hopb4fg Initiate (53) Nov 8, 2016 Minnesota

  24. neolithicman996

    neolithicman996 Initiate (15) Thursday Washington

    Trouble using it. I enter all my data on the recipe tab and hit the scale button(tried all three) and it just deletes my weights for grains and hops. I have tried enabling macros, leaving compatibility mode...what else could be going on?
  25. VikeMan

    VikeMan Meyvn (1,439) Jul 12, 2009 Pennsylvania

    I'm not at home but PM me the details...operating system, spreadsheet program, and an email address. I'll see it in a few days.
    neolithicman996 likes this.
  26. VikeMan

    VikeMan Meyvn (1,439) Jul 12, 2009 Pennsylvania

    @neolithicman996 also, please let me know which sheet you are using, i.e. the .xls or the .ods.