BrewCipher 3.5

Discussion in 'Homebrewing' started by VikeMan, Dec 26, 2014.

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

    psnydez86 Initiate (0) Jan 4, 2012 Pennsylvania

    @FATC1TY did you get this working on the iPad?? If so what excel app will I need to download??
     
  2. FATC1TY

    FATC1TY Pooh-Bah (2,564) Feb 12, 2012 Georgia
    Pooh-Bah


    I got it worked just fine. The macro button to scale doesn't work, but not really needed.

    Just download the normal microsoft excel app in the app store. It's free. Sign up for a microsoft acct if you don't have one, and it's all ready to go.

    Takes a little bit to learn it, especially if you are familiar with normal excel, but it was nice having the iPad fired up and mobile while out brewing in the back.
     
    psnydez86 likes this.
  3. jbakajust1

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

    I can't get the scale to even show up on Google Sheets.
     
  4. VikeMan

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

    Google Sheets = evil not supported platform. :slight_smile:
     
    jbakajust1 likes this.
  5. jbakajust1

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

    Yeah, but it makes it much easier to move across work comp, 4 home comps, and my Android phone and tablet w/o emailing and then re-emailing with any changes.
     
  6. jbakajust1

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

  7. FATC1TY

    FATC1TY Pooh-Bah (2,564) Feb 12, 2012 Georgia
    Pooh-Bah

    Speaking of that.. what about mash hops?


    I've been known to do it, and I KNOW I get some bitterness from it, and aroma. While that might boil off, I can taste the wort from the mash tun and it's bitter and aromatic. Even with the older hops I liked to use up.
     
  8. VikeMan

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

    There isn't (explicitly). I just consider them to be full boil hops. I suppose I could look into what data is out there about IBUs/utilization for FWH. I'll be pretty surprised if it's much different from full boil. I'm pretty sure it's not going to be equivalent to a 20 minute addition! :grimacing:
     
    jbakajust1 likes this.
  9. psnydez86

    psnydez86 Initiate (0) Jan 4, 2012 Pennsylvania

    Got Brewcipher3.5 on my I phone and iPad now via Google Sheets!!!!

    Can't wait to start using it rather than I brewmaster. Thanks @VikeMan !!
     
  10. VikeMan

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

    Not sure what you mean by "via" google sheets, but the spreadsheet doesn't run in google sheets/docs/drive, unless they changed something. But if you downloaded it and if your iphone/ipad supports excel, you should be good to go (except perhaps for the grain bill scaling macro, which isn't strictly necessary).
     
  11. psnydez86

    psnydez86 Initiate (0) Jan 4, 2012 Pennsylvania

    Hmmm. Yea I have google sheets(free app) on my phone and I pad and it seems to be working just fine.
     
  12. jbakajust1

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

    I use it all on Google Sheets, only thing I have found that doesn't work on it is the upscale feature. I will have to switch it over to standard Excel and move my recipes to it when I open the brewery so I can upscale the grain bills (sucks that it doesn't do it automatically for hops too).
     
    ChrisMyhre likes this.
  13. VikeMan

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

    @psnydez86 86 and @jbakajust1, thanks. I didn't realize it was working in google sheets. @jbakajust1, IBU scaling unfortunately is a bitch (based only on thought experiment so far), because of interactions between changing wort volume and hop/wort concentration as you change the hop amount. i.e. it's not a linear problem. Plus, 3.6 is also going to support Rager, which acts differently from Tinseth...haven't thought about Rager's scaling implications. But I'm planning to look into it, and hopefully haven't painted myself into a corner. It won't be in 3.6 though, which will be hung in the next day or so.
     
    #33 VikeMan, Feb 23, 2015
    Last edited by a moderator: Feb 23, 2015
    jbakajust1, Thorpe429 and ChrisMyhre like this.
  14. pweis909

    pweis909 Grand Pooh-Bah (3,250) Aug 13, 2005 Wisconsin
    Pooh-Bah

    You are taking it to the next level?
     
  15. jbakajust1

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

    Hoping to in the next few years. Met with the Brewmaster at one of our 2 biggest local breweries, told him my plan, sampled some of my beers, and got a great response from him. Meeting with a couple other locals the next few weeks who have their fingers on the pulse of the beer scene to get there thoughts. I have relegated the year to basically brewing the same recipes over and over to get my beer recipes in order, also limited myself to 7 hops and 7 grains to think more like a pro than a home brewer (can't just go get a pound of this malt and oz of that malt). Name, logo, tagline, beer names/styles are done, ethos pretty much done, working on background info for business plan. Just realized a huge snag this morning, so trying to think around that one.

    And I'm taking @VikeMan BrewCipher with me!
     
    Thorpe429, ChrisMyhre and DrewBrew87 like this.
  16. pweis909

    pweis909 Grand Pooh-Bah (3,250) Aug 13, 2005 Wisconsin
    Pooh-Bah

    If you really want to think like a pro, develop a recipe that you can brew over and over, and then figure out how you will adapt that recipe when you can't source the same hops in subsequent years due to shortages, contract issues, etc.

    Edit: didn't mean to sound like a big shot (as if I really know what it is like to be a pro). I've just sometimes been fascinated by how pros try to develop consistency with agricultural products whose quality and availability change from one year to the next.
     
    jbakajust1 likes this.
  17. jbakajust1

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

    Definitely. I'm actually developing my recipes using hops that no one is really clamoring for in the market, staying away from the newer and bolder hops. I've got a couple recipes in the stable that are designed as evolving recipes, changing each time, and those ones are for the fun new hops that come out and I can get just enough for a single 10 barrel batch.

    I'm also revamping some of my brewhouse processes right now to dial in repeatability more. Using a digital thermometer with alarm so that I can know exactly when I am at temp, and monitor the temp through the mash. Stopped doing overnight mashing. Filling the kettle through the pickup tube instead of splashing it down from the top. Just built a CFC, going to be moving towards fly sparging, stuff that pros do (Whether from necessity or belief that one is better than the other is superfluous). Paying better attention to yeast management. Etc.
     
  18. RashyGrillCook

    RashyGrillCook Initiate (0) Apr 30, 2011 Florida

    So, maybe someone already asked this, but I couldn't find anything definitive.

    I'm doing a no boil Berliner and for the Hops addition I was thinking about mash hops. For predicting the IBU's, would setting the "Boil Time" to zero and utilizing the "Flameout/Whirlpool" section be appropriate?
     
  19. VikeMan

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

    I wish I knew. My guess is that the IBUs you'd get would be something a little higher than just what's due to the mash time and temp, because some alpha acids will probably be extracted in the mash and then isomerized during the boil. But that's just an educated guess.
     
  20. RashyGrillCook

    RashyGrillCook Initiate (0) Apr 30, 2011 Florida

    I meant No-Boil Berliner.
     
Thread Status:
Not open for further replies.