Derek1985 Brewing Spreadsheet

After some revision and corrections, as well as expansions of the functionality of the user inputs, I am going to post a version of my personal brewing spreadsheet here.

My version that I have on my computer incorporates some stuff not found here including a popular water chemistry spreadsheet and Homebrew Dad's yeast calculator. They were removed from this posted version because for obvious reasons but it should be noted that I incorporated them into my personal sheet to have a complete brewing calculation system at my disposal.

Critique and improvements welcome.

https://docs.google.com/spreadsheets/d/1J_YzNX2EifzvfDhwPHbDzIpAk6I_BgUlCehzCCXfp2k/edit?usp=sharing

Looks pretty good, went through the calculations and they seem accurate but I'll look a bit more in depth later on.

UI improvement I would suggest would be to get rid of some of the gap spacing, and there's no reason to spread stuff out that much. Try and get each tab to fit on one screen.

The malt input could be done a little cleaner with data validation, which if you do you'll want to unmerge the coloumn of "Malt" in Malt Analysis Data sheet. This would let you type "Pils" and should show the matching possible malt types.

Put units in the coloum headers rather than a seperate coloumn. Ie "Original" becomes "Original (lb)" etc etc Add units to recipe scaling batch size.

Not sure what "r" is?

Oh yeah, Protect your data tables and non input cells!

pricelessbrewing said:

UI improvement I would suggest would be to get rid of some of the gap spacing, and there's no reason to spread stuff out that much. Try and get each tab to fit on one screen.

Click to expand...

Absolutely. That continues to be a work in progress.

pricelessbrewing said:

The malt input could be done a little cleaner with data validation, which if you do you'll want to unmerge the coloumn of "Malt" in Malt Analysis Data sheet. This would let you type "Pils" and should show the matching possible malt types.

Click to expand...

Interesting. I was trying to shy away from dropdowns because I thought they required macros. Will check it out.

pricelessbrewing said:

Put units in the coloum headers rather than a seperate coloumn. Ie "Original" becomes "Original (lb)" etc etc Add units to recipe scaling batch size.

Click to expand...

Good call. This would free up space as well.

pricelessbrewing said:

Not sure what "r" is?

Click to expand...

r is the water to grist ratio. I have been meaning to change that and just got used to it.

pricelessbrewing said:

Oh yeah, Protect your data tables and non input cells!

Click to expand...

Good point but i'm not terribly concerned about that. This is a duplicate, modified copy of my personal sheet. I put it up mainly for others.

Here is a revised version of the sheet. Per Priceless's advice, cleaned up some of the formatting and labeling.

I'll be working on simplifying both the Malt Analysis and IBU Analysis data sheets by incorporating Data Validation and possibly drop down menus.

*Note: All values entered as of now are for my system. You would need to adjust the losses section to account for your system.

https://docs.google.com/spreadsheets/d/1_nBevaVXAADtH6910gu3-VcgbQ6Wz05vDKJovsCEsTc/edit?usp=sharing

Added dropdown menus for the IBU Analysis and MAlt Analysis sheets.

Fixed a few calculation errors I found floating around.

Fixed the Pre-sparge topoff value in the "Equal Runnings" section

Thanks for sharing. I will attempt to put it through it's paces on a future batch and see how it works for my process.

stpug said:

Thanks for sharing. I will attempt to put it through it's paces on a future batch and see how it works for my process.

Click to expand...

I'd appreciate it.

This is really just for me and for public consumption. I just thought it had a fair amount of depth and maybe it would help people out.

I've used in now for 4 test mashes and 1 AG batch and it has been reasonably accurate.

Link is not working for me