Quantcast

BrewCipher 6.0

HomeBrewTalk.com - Beer, Wine, Mead, & Cider Brewing Discussion Community.

Help Support Homebrew Talk:

VikeMan

It ain't all burritos and strippers, my friend.
Joined
Aug 24, 2010
Messages
2,613
Reaction score
1,600
I don't know how many HomeBrewTalk users use BrewCipher, but I know there are some, so...

BrewCipher 6.0 spreadsheet, Hoppy Holihaze Edition, is now up for download.

New in Version 6.0:

- Updated MpH Water Models
-------- courtesy of utahbeerdude, from the soon to be released MpH v4
-------- uses malt(ster) specific pH data for many malts/grains
-------- more accurate than other models, per real life mash data

- Fruit Addition Calculator
-------- predicts effective combined OG, FG, Attenuation, and ABV
-------- doesn't ignore the water content of the particular fruit/puree/juice (just sayin')


- pH Target Picker Tool
-------- helps you decide the mash pH you want, based on desired finished beer characteristics


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'.
 
OP
VikeMan

VikeMan

It ain't all burritos and strippers, my friend.
Joined
Aug 24, 2010
Messages
2,613
Reaction score
1,600
Version 6.4 is up for download. It includes an update to the Fruit Calc sheet and some minor housekeeping. If you use the fruit calculations, I recommend downloading V6.4. If you don't use the fruit calculations, and already have V6.3, it's probably not worth downloading.

The change to the Fruit Calc sheet is this:
Previously, all fruit carbohydrates were included in the effective OG and (where estimated not fermentable) FG.
In V6.4, an estimate of non-soluble fiber (e.g. cellulose) is excluded from the effective OG and FG.
In most cases, this does not affect the predicted ABV (to one decimal). But in the case of fruits with large proportions of insoluble fiber, the ABV prediction may change slightly, due to a resulting change in effective volume of the fruit water/carbs.

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'.
 
OP
VikeMan

VikeMan

It ain't all burritos and strippers, my friend.
Joined
Aug 24, 2010
Messages
2,613
Reaction score
1,600
Thanks for your work! I'll definitely give it a go
Let me know if you have any questions/issues. The help desk is open pretty much all the time.
 
OP
VikeMan

VikeMan

It ain't all burritos and strippers, my friend.
Joined
Aug 24, 2010
Messages
2,613
Reaction score
1,600
Version 6.5 is up. Corrects a bug in 6.4's fruit calc. I hate when that happens. Apologies to anyone who downloaded 6.4 earlier today.
 
OP
VikeMan

VikeMan

It ain't all burritos and strippers, my friend.
Joined
Aug 24, 2010
Messages
2,613
Reaction score
1,600
Version 6.6 is up for download at the usual places (linked at beginning of this thread).

V6.6 tweaks the fruit calculations, improves fruit data, and adds a couple of advanced user selectable parameters on the FruitCalc tab. It also fixes a bug in the pH tab that is (was) unique to OpenOffice users.

If you use the fruit calculations or are running in OpenOffice, this update is probably worth the download.
 

andrew.dd.clark

ClarkBar
Joined
Jan 16, 2020
Messages
4
Reaction score
3
Minor request but can the grain bill percentages as well as the AA% for hops be displayed on the Brew Day Print Me tab? I print these out each brew day and keep em in a 3 ring binder. Would be easier to have that info right there when I'm referring to the recipe later.
 
OP
VikeMan

VikeMan

It ain't all burritos and strippers, my friend.
Joined
Aug 24, 2010
Messages
2,613
Reaction score
1,600
Minor request but can the grain bill percentages as well as the AA% for hops be displayed on the Brew Day Print Me tab?
I think there's room for it. I put it on the V6.7 punch list. Thanks for the suggestion!
 

Kickass

Well-Known Member
Joined
Jan 25, 2009
Messages
611
Reaction score
241
Location
Wichita, KS
@VikeMan, I'd like to give brewcipher a try but am getting a message that the file is corrupted when i try to open it in excel. Any ideas why this is happening?
 
OP
VikeMan

VikeMan

It ain't all burritos and strippers, my friend.
Joined
Aug 24, 2010
Messages
2,613
Reaction score
1,600
^ Let me know if you have any questions/issues. The help desk is available most of the time.
 

Kickass

Well-Known Member
Joined
Jan 25, 2009
Messages
611
Reaction score
241
Location
Wichita, KS
Yes, thank you. I’ve already run a couple of preexisting recipes through it to see how it compares to other software I’ve used and it looks really well thought out. I’m excited to test it on my next couple of batches.
 
OP
VikeMan

VikeMan

It ain't all burritos and strippers, my friend.
Joined
Aug 24, 2010
Messages
2,613
Reaction score
1,600
Version 6.7 (minor update) is up for download.

- added Metabisulfite calculations for LODO
- Fruit Data Enhancements
- Ingredient Data tweaks
- added Grain Bill %s and Hop AA %s to BrewDay Print Me sheet (@andrew.dd.clark)

Download it from -> Google Drive <- or -> DropBox <-.
Or from -> Library <-
 

ChiknNutz

Well-Known Member
Joined
May 3, 2020
Messages
279
Reaction score
133
Location
Advance, NC
Thanks for this! I have a question for you. At least one of the online calcs I've used so far also accounts for "Packaging Losses" or similar which are from the Fermenter to the bottle, keg, etc. Do you have a similar factor in yours? I've just downloaded and started messing around with it, but don't yet see this.

Also, since I am solely doing BIAB, should the mash tun dead space be zero?
 
OP
VikeMan

VikeMan

It ain't all burritos and strippers, my friend.
Joined
Aug 24, 2010
Messages
2,613
Reaction score
1,600
At least one of the online calcs I've used so far also accounts for "Packaging Losses" or similar which are from the Fermenter to the bottle, keg, etc. Do you have a similar factor in yours? I've just downloaded and started messing around with it, but don't yet see this.
BrewCipher's volume calculations get you "into the fermenter," i.e. they don't account for losses after that. (The "Batch Size" on the Recipe Tab is "into the fermenter.") However, if you have a constant "packaging loss" (say, a gallon or whatever), you could simply add that to the amount you want to package and enter that as the Batch Size.

Also, since I am solely doing BIAB, should the mash tun dead space be zero?
Yep, if you have no volume losses associated with your mash vessel (such as a BIAB kettle with no false bottom), enter 0.
 
Top