Download Here:
http://forum.northernbrewer.com/viewtopic.php?f=1&t=107231&p=946373#p946373
I am unable to attach an excel or .zip file to this website, so the spreadsheet is available from this link.
EZ Brew 1.95 is now available
It is an Excel spreadsheet that you can use to create beer recipes. The spreadsheet is an upgraded version of the spreadsheet MullerBrau uses.
The main difference between the original spreadsheet is the addition of EZ Water 3.0 to the mix. I have built EZ Water 3.0 right into the brewing spreadsheet to assist in water calculations and save you time while doing it. The spreadsheet also has updated lists of Malts, Sugars, Hops, & Yeast, including descriptions of each item.
Just enter your recipe information into the highlighted cells and the spreadsheet does the rest.
This spreadsheet also includes detailed information on over 200+ yeast strains, 150+ ingredients, 130+ hops and more.
Hope you enjoy.
Version 1.95 is here and includes corrections to the formulas in the Pre-boil Liquid Volume, L66 and Total Water Needed, D67 cells to provide more accurate water amounts.
Thank you, BraceH for noticing the incorrect formulas.
Also included are 37 new yeast / sour strains from East Coast Yeast and The Yeast Bay
EZ Brew 1.95
Added Danstar Abbaye Yeast to yeast strains sheet and drop down list.
Added 14 yeast / sour strains from The Yeast Bay to yeast strains sheet and drop down list.
Added 23 yeast / sour strains from East Coast Yeast to yeast strains sheet and drop down list.
Added El Dorado to the hops sheet and drop down list.
Corrected the formula in cell L66, Pre-boil Liquid Volume.
Deleted Grain Inventory tab.
Please let me know if you find anything wrong with the spreadsheet so I can update it.
Thank you,
Gregscsu
http://forum.northernbrewer.com/viewtopic.php?f=1&t=107231&p=946373#p946373
I am unable to attach an excel or .zip file to this website, so the spreadsheet is available from this link.
EZ Brew 1.95 is now available
It is an Excel spreadsheet that you can use to create beer recipes. The spreadsheet is an upgraded version of the spreadsheet MullerBrau uses.
The main difference between the original spreadsheet is the addition of EZ Water 3.0 to the mix. I have built EZ Water 3.0 right into the brewing spreadsheet to assist in water calculations and save you time while doing it. The spreadsheet also has updated lists of Malts, Sugars, Hops, & Yeast, including descriptions of each item.
Just enter your recipe information into the highlighted cells and the spreadsheet does the rest.
This spreadsheet also includes detailed information on over 200+ yeast strains, 150+ ingredients, 130+ hops and more.
Hope you enjoy.
Version 1.95 is here and includes corrections to the formulas in the Pre-boil Liquid Volume, L66 and Total Water Needed, D67 cells to provide more accurate water amounts.
Thank you, BraceH for noticing the incorrect formulas.
Also included are 37 new yeast / sour strains from East Coast Yeast and The Yeast Bay
EZ Brew 1.95
Added Danstar Abbaye Yeast to yeast strains sheet and drop down list.
Added 14 yeast / sour strains from The Yeast Bay to yeast strains sheet and drop down list.
Added 23 yeast / sour strains from East Coast Yeast to yeast strains sheet and drop down list.
Added El Dorado to the hops sheet and drop down list.
Corrected the formula in cell L66, Pre-boil Liquid Volume.
- New formula =IF(I29=1,0,ROUND((D9+L11+L14)/(1-D12/100)/(1-D11/100*D10/60),2))
Previous formula =IF(I29=1,0,ROUND((D9+L11+L14)*(1+D12/100)*(1+D11/100*D10/60),1))
- New formula =IF(I29=1,0,ROUND((D9+L11+L14)/(1-D12/100)/(1-D11/100*D10/60)+L12+L13+L62,2))
Previous formula =IF(I29=1,0,ROUND((D9+L11+L14)*(1+D12/100)*(1+D11/100*D10/60)+L12+L13+L62,2))
- New formula =ROUND(((1/60*D65)*(1-'EZ Water 3.0'!D9)),2)
Previous formula =ROUND(1/60*D65,2)
- New formula =ROUND(((1/15*D6^)*(1-'EZ Water 3.0'!E9)),2)
Previous formula =ROUND(1/15*D66,2)
Deleted Grain Inventory tab.
Please let me know if you find anything wrong with the spreadsheet so I can update it.
Thank you,
Gregscsu