BrewCipher 3.41

Discussion in 'Homebrewing' started by VikeMan, Jul 10, 2014.

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

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

    BrewCipher 3.41 spreadsheet is now up for download. This is a very minor update.

    New in Version 3.41:
    - Enhanced the display of water volumes on the Recipe Tab. If you are using a Hot Liquor Tank with a Deadspace, the Recipe tab will now (in one place) show both the 'net' water required and how much you'll put in your HLT (including applicable Deadspace)
    - Added some ingredients (mostly Hops and a few grains)


    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 Formula…
    - Limits IBUs to 110 (solubility limit)
    - Splices new utilization curve to Tinseth utilization curve above 65 IBUs, to more closely agree with actual vs theoretical IBUs measured
    - Adds bitterness contributions for post boil hop additions
    - Hop Utilization Multiplier parameter to fine tune hop utilization to your system​
    - 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 guidlelines
    - Computes Diastatic Power for the Mash, and warns when grist's DP is marginal or poor
    - Scales Grain Bill to any desired Original Gravity
    - Calculates Mash pH and results of acid and Brewing Salt Additions, including Sparge Water acidification
    - User Storable Water Profile Input (feature works in Excel, but not Apache Open Office)
    - 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, improved 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
    - More user selectable Brewhouse Parameters than you can shake a stick at (but the defaults will work pretty well for most people too)

    BrewCipher V3.41
     
    Thorpe429, Wanda, ChrisMyhre and 5 others like this.
  2. jae

    jae Initiate (0) Feb 21, 2010 Washington

  3. VikeMan

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

    Excel.
     
    CurtFromHershey likes this.
  4. jae

    jae Initiate (0) Feb 21, 2010 Washington

    No, "word?" like "for real?". You're from western PA, huh?
     
  5. VikeMan

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

    [/sarcasm] I know. And no.
     
  6. wspscott

    wspscott Pooh-Bah (1,934) May 25, 2006 Kentucky
    Pooh-Bah Society

    Thanks again for your work on this and for sharing.

    One request, can the brewday print sheet show the actual water results after any salts? Right now, it just shows what is added, but doesn't say what the final result of the additions are. Or maybe something with % distilled for the mash and sparge. In the end, this wouldn't matter if I could always have enough distilled water on hand, but that requires a lot more foresight than I am capable of :slight_smile:
     
  7. cmmcdonn

    cmmcdonn Initiate (0) Jun 21, 2009 Virginia

    I'm a tech nerd so I took a look at the hidden sheets to see the "back end" of it all and it makes BrewCipher look even more impressive. +100 internets

    I may make the switch from Beersmith. I can't get over their Extract/Partial mash error (error to me anyway).
     
  8. VikeMan

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

    I'll take a look at that, at least the % distilled part. Maybe the final water results too if they'll fit. Will have to make the displays of water tab info on the BrewDay sheet optional, since not everyone uses the water tab.
     
  9. VikeMan

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

    If you could actually see those sheets (and not just the list of them), you are indeed a tech nerd.

    I started making BrewCipher because of shortcomings in some other software/websites. Plus, I like being my own help desk. I get much faster response that way.
     
    ChrisMyhre, jbakajust1 and cmmcdonn like this.
  10. cmmcdonn

    cmmcdonn Initiate (0) Jun 21, 2009 Virginia

    I'm a computer forensics guy and Excel sheet protection is extremely weak.

    It actually gave me some afternoon reading material. I'll be checking out the hombrewing physics blog you linked to (mash_chem) during my down time. :slight_smile:
     
  11. atomeyes

    atomeyes Initiate (0) Jul 13, 2011 Canada (ON)

    yeah, i am scared to leave BeerSmith just because I've finally tweaked it to where it should kind of sort of be. and i also have a mac w/o MS Office, so i can't use this spreadsheet.

    fuck, do i need to buy a laptop just to brew?
     
  12. jbakajust1

    jbakajust1 Pooh-Bah (2,528) Aug 25, 2009 Oregon
    Pooh-Bah Society

    I think you can use it on Google Drive too?
     
  13. VikeMan

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

    Google drive doesn't support some of what the sheet does, so I don't publish it in google docs format.
     
    atomeyes and jbakajust1 like this.
  14. Wanda

    Wanda Crusader (494) Nov 23, 2006 Tennessee

    If you have iWork you should be able to download it from Drive, then drag it to Numbers. I should open it from there.

    Thanks for the work VikeMan. Learning to homebrew has been a lot more in depth than I would have imagined but it's a helluvalota fun!
     
    atomeyes likes this.
  15. Thorpe429

    Thorpe429 Grand Pooh-Bah (3,655) Aug 18, 2008 Illinois
    Pooh-Bah

    Amazing as always. I've now fully converted over from BeerSmith. Just need to set up a separate inventory in another Excel file. I always liked the idea of having that in BeerSmith, even though I never actually used it :slight_smile:

    Thanks again as well for taking in so many water suggestions. One thing that would be amazing (though I have no idea how complex this would be for you and/or Utahbeerdude) would be to make it possible to calculate pH changes for adding lactic acid pre-boil and post-boil based on a "current pH" input so that adjustments could be made there as well.

    Cheers!
     
  16. utahbeerdude

    utahbeerdude Maven (1,374) May 2, 2006 Utah

    This is an interesting idea, and it is something that could in principle be done, if one knew the nature of the buffers in wort or there were some data out there that directly measured pH changes to wort upon acid addition. On the other hand, I believe that if one hits the correct mash pH, then pH downstream tends to take care of itself pretty well.
     
  17. Thorpe429

    Thorpe429 Grand Pooh-Bah (3,655) Aug 18, 2008 Illinois
    Pooh-Bah

    Thanks for the response. Thinking about several different scenarios, the most basic of which could be if someone were doing a few day "sour wort" and wanted to get initial pH down to X (4.5 maybe?) to avoid any potential nasties. I would need to look back at notes/things I've saved, but I've certainly come across a few things mentioning getting boil pH or post-boil pH down to X to achieve X, and wanted to check whether that was something all that difficult to determine.
     
  18. jivex5k

    jivex5k Initiate (0) Apr 13, 2011 Florida

    So I downloaded this just now...Wow man! That's some serious work you put in. Thanks for sharing this with the community.
     
  19. jmich24

    jmich24 Initiate (0) Jan 28, 2010 Michigan

    Another suggestion, it would be nice to have a space to enter length(days) and temp of the dryhop additions.
    Example: Citra, Pellet, 1 oz, 5 days, 65 degrees.
     
  20. scurvy311

    scurvy311 Savant (1,111) Dec 3, 2005 Louisiana

    Used BC side by side with ibrewmaster for recipe/predictions and EZ water for water/pH calcs. BC beats ibrewmaster in terms of more accurately predicting OG/FG and ingredient contributions. I find it is more accurate at predicting pH than ezwater, at least my last 2 batches where I took readings.
     
Thread Status:
Not open for further replies.