These may need to be modified, depending on the metric presented in the water report. This can help you make adjustments accordingly throughout the year.īe careful to follow the instructions in the spreadsheet, especially when inputting Sulfate and Nitrate concentrations. I also recommend testing at least once a year, but more often if your water is seasonably variable. Wards Labs has made a few changes in their procedures recently increasing the accuracy of their carbonate and bicarbonate measurements, however, you should also look at the Total Alkalinity calculator and see if the results help to better balance your report (more later). If your Cations/Anions delta is larger than 0.50, you should contact the lab for a retest. Typically the analysis is specific to the sample that you draw, and usually will adequately ‘balance’. I highly recommend getting a brewer’s specific report. As mentioned, I have my Ward Labs Report and will put in the pertinent information from my report in this example. If you make changes in a later brew – re-save with a new version number in the title.Ĭlick on the worksheet tab at the bottom of the screen named Water Report Input and get your water report handy. Save a copy of the spreadsheet with your beer name, revision number and date to allow you to return to the spreadsheet and make any necessary comments or adjustments for a future brew.This allows you to return to a known good state for a new recipe.
Save a master version of this spreadsheet with your water report input.
At the end of the spreadsheet, you can also find a Water Knowledge tab, which contains much of the contents you will find online at the Bru’n Water website. You probably won’t be able to use the program instantly without reading the instructions. PLEASE READ! Bru’n Water looks complicated, but it’s not that difficult to use once you enter the basic data and learn how the program works. Instructions” which provides details on water chemistry, as well as information on using the following worksheets. This allows for a more natural input approach and step order.Īt the bottom of the spreadsheet you will see a variety of colored tabs. If you are familiar with the previous versions of BWS, then you will notice the order of the tabs has changed.
#WATER TOOLS BEERSMITH FULL#
Note: Clicking on the images below will open a full sized and more legible version in your browser.
#WATER TOOLS BEERSMITH SOFTWARE#
A computer with supported spreadsheet software and basic familiarity with spreadsheets.My Ward Labs report will be used in this tutorial. Ward Labs is an independent testing facility, and provides a brewing specific report. You can build a list from the spreadsheet. Your water report with the variables important for brewing.The subscriber version will be emailed to you. This will not only give you access to some key advanced features, but also ensure this tool continues to be supported and updated as required. Please donate and get the subscriber version!
#WATER TOOLS BEERSMITH UPDATE#
Fortunately, while the update is significant, familiarity with either the Free versions or the Version 2.0 Subscriber spreadsheet will give you a head start! Below, we will walk through the Subscriber version 3.2 of the spreadsheet with specific examples, and point out the areas that give you new and improved options. Martin Brungard’s Bru’n Water spreadsheet is an excellent modelling tool for managing your brewing water. If you have not yet received your 3.0 version, I suggest another small donation which will trigger the release to you within a few hours. This walk through supercedes the 2.0 version which will remain up if you choose not to upgrade.
In March 2015, Martin Brungard released the Bru’n Water Spreadsheet 3.2 to subscribers with major improvements to UI and functionality.
0 kommentar(er)
