{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["0. Instructions","1. Water Report Input","2. Sparge Acidification","3. Grain Bill Input","4. Water Adjustment","5. Adjustment Summary","Water Knowledge"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":35,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"0. Instructions","index":0,"n_rows":161,"n_cols":11,"rows_kept":161,"cut":false,"hidden":false,"merged":[[108,0,108,10],[15,1,15,10],[21,0,21,10],[98,0,98,10],[2,0,2,10],[101,0,101,10],[100,0,100,10],[74,0,74,10],[66,0,66,10],[16,1,16,10],[17,1,17,10],[18,1,18,10],[14,1,14,10],[13,0,13,10],[104,0,104,10],[106,0,106,10],[107,0,107,10],[105,0,105,10],[28,0,28,10],[29,0,29,10],[92,0,92,10],[93,0,93,10],[94,0,94,10],[1,0,1,10],[6,0,6,10],[26,0,26,10],[24,0,24,10],[11,0,11,10],[4,0,4,10],[3,0,3,10],[7,0,7,10],[23,0,23,10],[22,0,22,10],[9,0,9,10],[10,0,10,10],[5,0,5,10],[12,0,12,10],[20,1,20,10],[75,0,75,10],[64,0,64,10],[68,0,68,10],[67,0,67,10],[69,0,69,10],[36,0,36,10],[50,0,50,10],[160,0,160,1],[159,0,159,10],[158,0,158,10],[153,0,153,10],[152,0,152,10],[146,0,146,10],[151,0,151,10],[157,0,157,10],[156,0,156,10],[155,0,155,10],[154,0,154,10],[148,0,148,10],[35,0,35,10],[25,0,25,10],[27,0,27,10],[138,0,138,10],[150,0,150,10],[147,0,147,10],[144,0,144,10],[143,0,143,10],[141,0,141,10],[149,0,149,10],[140,0,140,10],[137,0,137,10],[139,0,139,10],[136,0,136,10],[142,0,142,10],[145,0,145,10],[95,0,95,10],[51,0,51,10],[60,0,60,10],[62,0,62,10],[57,0,57,10],[97,0,97,10],[65,0,65,10],[58,0,58,10],[0,0,0,1],[0,2,0,10],[8,0,8,10],[43,0,43,10],[52,0,52,10],[55,0,55,10],[53,0,53,10],[31,0,31,10],[42,0,42,10],[54,0,54,10],[47,0,47,10],[49,0,49,10],[46,0,46,10],[38,0,38,10],[45,0,45,10],[40,0,40,10],[48,0,48,10],[30,0,30,10],[34,0,34,10],[32,0,32,10],[37,0,37,10],[19,1,19,10],[39,0,39,10],[33,0,33,10],[135,0,135,10],[134,0,134,10],[76,0,76,10],[77,0,77,10],[78,0,78,10],[79,0,79,10],[80,0,80,10],[111,0,111,10],[96,0,96,10],[132,0,132,10],[131,0,131,10],[133,0,133,10],[99,0,99,10],[110,0,110,10],[116,0,116,10],[122,0,122,10],[109,0,109,10],[102,0,102,10],[103,0,103,10],[112,0,112,10],[84,0,84,10],[85,0,85,10],[127,0,127,10],[130,0,130,10],[41,0,41,10],[59,0,59,10],[72,0,72,10],[71,0,71,10],[73,0,73,10],[70,0,70,10],[56,0,56,10],[61,0,61,10],[63,0,63,10],[44,0,44,10],[87,0,87,10],[88,0,88,10],[89,0,89,10],[90,0,90,10],[91,0,91,10],[81,0,81,10],[82,0,82,10],[83,0,83,10],[86,0,86,10],[124,0,124,10],[129,0,129,10],[123,0,123,10],[113,0,113,10],[128,0,128,10],[117,0,117,10],[118,0,118,10],[126,0,126,10],[120,0,120,10],[115,0,115,10],[125,0,125,10],[121,0,121,10],[119,0,119,10],[114,0,114,10]]}
["Bru'n Water",null,"Copyright © 2016 Martin Brungard. All rights reserved. Reproduction in whole or in part in any form or medium without the express written permission of Martin Brungard, is prohibited. Bru'n Water is not Freeware or Shareware and it is illegal to distribute or transfer this program in any form except by Martin Brungard."]
["Instructions"]
["Created by Martin Brungard, P.E. D.WRE  (mabrungard@hotmail.com)"]
["            Most water sources that have an acceptable taste can be used to brew beer.  But to brew great beer across a wide variety of styles, adjustment of brewing water is probably needed.   Bru'n Water is a brewing water analysis program that enables a brewer to successfully evaluate and modify their water supply to improve their beer.  The program steps through the evaluation of a brewer's water supply, adjustment to a desired water profile, evaluation of potential mash pH, and adjustments to produce desirable mash pH. "]
["Homebrewing and Craftbrewing are unique in their need to frequently assess and adjust their brewing water to better suit their upcoming beer.  This differs from the needs of production breweries that brew thousands of barrels of the same beer every year.  Consistency is the key for production brewers and they have little need to evaluate or change their brewing water.  Through trial and error and advanced laboratory analyses, production breweries typically know exactly what adjustments they need for their brewing water.  Homebrewers and Craftbrewers rarely have the tools at their disposal to perfect their water and since they often change what beer they brew, a capable tool is helpful.  This brewing tool is intended to aid those who want to get great results out of every batch."]
["Getting Started"]
["            The first thing needed for brewing water analysis is to know your water supply characteristics and ion concentrations.  Of course, you want a water supply that is safe to drink and tastes good.  Water that leaves black, brown, or red water staining may be an indication that the water will need additional treatment to be suitable for brewing.  Water that has been softened by typical salt-based water softeners (ion exchange) is not typically desirable for brewing due to several factors including:  elevated sodium or potassium content, low calcium and magnesium content, while still containing excessive alkalinity.   Brewers with softened water may find that obtaining their brewing water from a point upstream of their softener unit will produce better brewing results.  An exception is if the raw water has iron or manganese at perceptible levels.  Hard water is not typically an obstacle to brewing good beer.  However, alkalinity is a problem typical to many brewers.  Ion-exchange water softeners do not affect alkalinity significantly and the resulting water is often poorly suited to brewing."]
["A comprehensive instruction on brewing water knowledge is included in this program to assist the brewer in understanding brewing water chemistry.  Select the Water Knowledge tab to view.  A link to the on-line version of the Water Knowledge is provided below.  The on-line version is more up to date and should be the preferred resource."]
["Bru'n Water Knowledge"]
["Here are a few program setup recommendations to aid your use of Bru'n Water. "]
["1. Go to Excel Options and its Formulas subdirectory and be sure that Automatic calculation is selected and Enable Iterative Calculation is also check-marked. These ensure that the changes to your inputs are instantly incorporated in the answers. The iterative calculation feature is necessary since the program uses the results of the calculations to refine its answers and this creates a circular reference warning in Excel. Enabling the iterative calculation gets rid of the warning and allows the program to function properly."]
["This program steps the brewer through a set of spreadsheets to complete the water analysis and adjustment.  If a brewer's water source is relatively stable and its characteristics do not change, then it is likely that the brewer will only visit sheets 1 and 2 (Water Report Input and Sparge Acidification) once.  Sheets 3 and 4 (Grain Bill Input and Water Adjustment) will be used for each new brewing session.  The brewer should work sequentially through sheets 1 through 4 to define and assess their brewing water chemistry.  If the mash acidification results indicate that the water adjustments will not produce a desirable result, the brewer may need to revisit the Water Adjustment page (Sheet 4) and adjust the dilution, mineral, or acid additions to achieve their desired mash pH.  Be sure to input your water's Bicarbonate content on the Water Report Input sheet to get proper output on the Grain Bill Input and Adjustment Summary sheets. If the Sparging Water is diluted with RO or Distilled water, that information must be input on the Sparge Acidification sheet.  "]
["Set the units desired for the brewing calculations at the top of the Water Report Input sheet.  Homebrewers may select either Gallons or Liters.The units for grain amounts switch to pounds when the water volume is set to either gallons or Barrels and to kilograms when the water volume is set to liters or hectoliters. "]
["How to Use Bru'n Water"]
[null,"1. Knowing your Existing Water is a key requirement for assessing how to adjust it.  Input the ion content of the existing water source on the Water Report Input sheet.  "]
[null,"2. Water reports can be difficult to understand and they sometimes have errors.  A warning will display on the Water Report Input sheet if the ion inputs are out of balance.  If the warning is displayed, double check the reporting units from the water report and convert any quantities that are not reported in actual ppm or mg/L units for each ion. Sometimes, water reports provide information in units other than ppm or mg/L and those values need to be converted. For example: (not as ppm as CaCO3, or not as Sulfate as Sulfur (SO4-S), or not as Nitrate as Nitrogen (N03-N)  ). There is a Conversion tool at the bottom of the Water Report Input sheet to aid the brewer in converting reported values to their actual ionic concentrations. For accurate results, the ionic content of your water must be known and entered properly. The ion balance warning will disappear when the input is reasonably balanced. Be sure to dechlorinate your brewing water if you get your water from a municipal supply!"]
[null,"3. All sparging Water must have low alkalinity. If your water source has moderate to high alkalinity, that water must be acidified to reduce its alkalinity.  The alkalinity of the tap water is calculated from the information input on the Water Report Input sheet and it is copied to the Sparge Acidification sheet.  It is used to calculate the amount of acid needed to bring the Sparging Water pH and Alkalinity down to a proper level.  "]
[null,"4. The water profile used for brewing should be adjusted to produce a proper mash pH and produce desirable beer taste.  Select a target brewing water profile on the Water Adjustment sheet and experiment with mineral and acid additions and/or water dilution to produce that desired water profile.  An exact match is NOT required between your adjusted water and the suggested water profiles.  Getting within +/-10 ppm of the target should be OK.  DO NOT TARGET the bicarbonate value shown in water profiles. The bicarbonate content shown for the water profile is only a FIRST-GUESS.  You don't need to achieve that exact value, but it is likely to be close.  The bicarbonate content of your mashing water may be higher or lower than the value shown in the water profile.  Adjust the bicarbonate value as needed to produce your desired mash pH.  The final bicarbonate content of the mashing water may vary based on the acidity of your grain bill.  "]
[null,"5. Bru'n Water assesses the acidity of the brewer's grain bill to predict mash pH.  Input the mashing grain bill on the Grain Bill Input sheet.  "]
[null,"6. Because the water profiles on the Water Adjustment sheet may not always produce a good mash pH, minor adjustment of the bicarbonate content of those water profiles may be needed.  Check the resulting Estimated Mash pH on either the Grain Bill Input or Water Adjustment sheets.  If the pH is lower than desired, increase the bicarbonate content of the mashing water on the Water Adjustment sheet.  If the pH is higher than desired, reduce the bicarbonate content.  Adjust the mashing water ion concentrations until the desired mash pH is predicted."]
[null,"7. A listing of the recommended Water Adjustments for mashing and sparging water is presented on the Adjustment Summary sheet.  That sheet is configured for printing and presents all the water adjustment information needed for that brew.  "]
["If Reverse Osmosis (RO) or Distilled Water is the brewer's primary water source, then you must input appropriate ion concentrations on the Water Report Input sheet so that the Sparge Acidification calculations are correct. The water adjustments can then be properly entered to create the desired water profile. In the Supporter's version of Bru'n Water, this task is easily accomplished by setting the Dilution Water setting to either RO or Distilled and setting the sparging and mashing Dilution values to 100%."]
["This program is unique in that it enables the evaluation of both brewing water alkalinity and mash acidity to more closely estimate and assess the mash water adjustments needed.  The mash acidity is calculated from the actual grain bill used for each brewing session.   "]
["The program is set up with color-coded cells to aid and direct the brewer.  Blue colored cells accept brewer input.  Yellow colored cells present calculated data and results.  Pink cells contain drop-down selection boxes. Many cells within each sheet contain informational comments that help the brewer understand the inputs and results.  Cells with comments have a small red mark in their right upper corner.  Hover the cursor over cells to see the informational comments.  When using Excel to run Bru'n Water, some cells will change their color to Green when inputs are within recommended tolerance and some cells will turn Red if potentially incorrect or problematic input or result is provided.  If the sheet does not show comments or red corner marks, select the REVIEW tab in the Excel program menu and click the SHOW ALL COMMENTS button twice."]
["This program should not require the use of Macros to operate effectively. If a security message from the spreadsheet software is displayed regarding macros, you should not have to enable macros to gain full use of this program's features. NOTE: Some software versions of Excel, OpenOffice, or LibreOffice may operate the Bru'n Water program successfully without enabling the Macros. Mac users report that saving the program in the .xlsm format does retain the program's capabilities. "]
["When opening the program for the first time, the zoom on each of the sheets is set low (small) so that most users can see the full extent of the working area when they open the program.  Increase the zoom setting on each sheet so that each sheet is enlarged and visible on your monitor.  When the program is saved, your preferred zoom settings on each sheet will be saved.  If text in some cells does not appear correctly, increasing the zoom may improve the appearance."]
["The minimum water information needed to properly use Bru'n Water includes the following:  The most important data are the water's Calcium, Magnesium, Sodium, Alkalinity or Bicarbonate, Sulfate, and Chloride concentrations.  These are sometimes known as Secondary Water Quality parameters or Inorganic parameters.  If the water pH is not known, it can generally be estimated as 8.0 without much error.  If you obtain water from a municipal water supply, you may be able to obtain this information from the water company's water quality testing report.  If that information is not readily available or if the water is from a private source, you may need to have the water tested for those parameters.  A suite of tests such as the Household Mineral Test from Ward Labs (wardlab.com) is suitable. ( Sodium, Calcium, Magnesium, Potassium, Carbonate, Bicarbonate, Chloride, Sulfate, Nitrate, pH, Total Hardness, and Total Alkalinity).  Ward Labs is easily accessible to US brewers.  Brewers in other countries may find a suitable water quality testing laboratory locally.  UK brewers may find Murphy (murphyhomebrew.com) useful excepting that they do not report the water's sodium content.  If only the sodium content is missing from a report, it may be possible to assume that the sodium content is at a level that produces a balanced cation and anion total. Typically, only a small water sample 4 to 8 oz (100 to 200 ml) is required for the testing.  "]
["Measurements"]
["Mineral and acid additions must be measured and added accurately to achieve good brewing results.  Homebrewers should obtain a scale with an accuracy of at least 0.1 grams to more accurately measure mineral and acid additions for typical homebrew sized batches.  Craftbrewers brewing larger batches should have a scale with an accuracy of at least 1 gram to accurately measure their additions.  Scales may be mechanical or digital, but their resolution should meet the recommendations above.  An internet search for \"digital scale 0.1\" should reveal there are scales available for under $30US.  A scale that can weigh at least 500 grams is recommended so the scale can be used for multiple uses including weighing hop additions.  Higher scale capacity typically increases the cost of the scale, but the durability may also be improved.       "]
["Liquid acid additions should also be measured accurately.  An inexpensive measurement option for typical homebrew sized batches is to obtain and use a graduated medicine dropper from a drug store.  A craftbrewer could consider obtaining a graduated cylinder or pipette for larger acid additions.   "]
["Some municipal water supplies get their water from several sources and the ionic content of the water may vary over time.  That may require additional testing or analysis to ascertain.  Contact the water utility to find out the water source variability.  Water test kits may be used to provide the brewer with a quick assessment of the primary water quality parameters and are discussed below.  Water test kits are recommended if the source and/or quality of the water supply varies."]
["Aquarium test kits can provide reasonably accurate assessment of the primary brewing water quality parameters of calcium content (or hardness) and alkalinity (which is also termed 'carbonate hardness').  Aquarium test kits from manufacturers such as Aquarium Pharaceuticals, Elos, Salifert, and Red Sea are available and can determine the concentration of these components.   If better accuracy is desired, water testing kits from suppliers such as Hach and Lamotte are suggested.  The hardness and alkalinity concentrations are the primary components that influence mash pH.  The calcium kits may have names such as Calcium Test or General Hardness.  The Alkalinity kits may have names such as Alkalinity/pH Test or Carbonate Hardness.   Search the web for 'Aquarium Test Kits'.    Colorimetric kits that you add drops to are recommended since they are generally more sensitive than kits that use Test Strips."]
["Aquarium test kits may report their results in terms of German degrees of Hardness, American Grains per Gallon, milliequivalents per liter, milligrams per liter, or parts per million.  Results must converted to milligrams per liter (mg/L) or parts per million (ppm) for use in Bru'n Water.  Note that ppm and mg/L are generally equivalent.  Conversion factors are provided below and some are included in the Conversion Calculator on the Water Report Input sheet.  "]
["          1 German degree Hardness = 17.85 ppm as CaCO3 = 7.14 ppm Ca\n          1 German degree Carbonate Hardness = 17.85 ppm Alkalinity as CaCO3 = 21.8 ppm HCO3   \n          1 American degree Hardness = 1 grain per gallon = 17.1 ppm as CaCO3 = 6.86 ppm Ca \n          1 American degree Alkalinity = 1 grain per gallon = 17.1 ppm as CaCO3 = 20.8 ppm HCO3\n          1 mEq/L Hardness = 50 ppm Hardness as CaCO3 = 20 ppm Ca \n          1 mEq/L Alkalinity = 50 ppm Alkalinity as CaCO3 = 61 ppm HCO3  \n     "]
["Water Report Input"]
["            Water testing results are entered on the Water Report Input sheet.  The concentrations for each ion are entered in the blue cells.  Yellow cells display calculated results.  Water reports typically present the ion concentrations as milligrams per liter (mg/L) or parts per million (ppm).  These units are roughly equivalent and are used interchangeably.  This program includes helpful pop-up informational comments in some cells.  Cells with a red mark in the upper right cell corner will display the comment when the mouse cursor is hovered over that cell.   If the sheet does not show comments or red corner marks, select the REVIEW tab in the Excel program menu and click the SHOW ALL COMMENTS button twice.  This should coax the software to display the comments."]
["Select the volume units used in the brewery for Bru'n Water.  The Pink drop-down box is used to select the volume units used throughout the program.  Both U.S. and S.I. units are available in homebrewing sizes. (Gallons and Barrels, or Liters and Hectoliters). Note: Barrels and Hectoliters are available in the Supporter's version of Bru'n Water."]
["If the brewer's water report does not include information on minor ions such as potassium, fluoride, iron, nitrate, or nitrite, enter Zero for those concentrations.  The concentration of these ions is typically low and should only produce a minor error in the cation/anion difference if they are entered as Zero.   In the case of Murphy's water reports which don't report sodium, input all the other reported ions (be sure to convert the Alkalinity value to mg/L of HCO3) into the Water Report Input area and input increasing sodium concentrations until the cation and anions are balanced.  That can serve as an estimate of the water's sodium content."]
["Metallic taste can be discerned in water by most people when the iron concentration exceeds 0.3 ppm or when manganese concentration exceeds 0.1 ppm. When metallic tastes are detected in beer or water, testing for these ions is recommended.  Special water treatment may be required if these ions exceed the taste thresholds indicated above.   "]
["Water testing reports can contain testing and reporting errors.  Therefore, a review of the ionic balance between the positively-charged ions (Cations) and negatively-charged ions (Anions) is helpful.  The Water Report Input sheet includes an Ion Balance calculation that warns you when the cation and anion totals are more than 0.5 meq/L apart (they should be equal). There can be some difference in the totals if there were errors in the testing or reporting or if there are other ions in the water that were not reported.  If no ion balance warning is displayed, the water report inputs should be close enough to operate the program."]
["The ion concentrations that were entered on the Water Report Input sheet are automatically entered in the Water Adjustment sheet.  If the water source is fairly stable, the brewer may not need to adjust the Water Report Input page in the future.  Saving the program with those values on the Water Report Input sheet will speed the future use of the program.  "]
["Some laboratory test reports provide information on Total Dissolved Solids (TDS).  The Water Report Input sheet shows the TDS calculated from the input water parameters for comparison to the laboratory test report.  This comparison may be useful in finding errors in the water report or inputs.  In most cases, the TDS value calculated on the Water Report Input sheet will be a little lower than the value reported in a lab test report since the water report may include more ion species in their calculation.  WARNING: TDS measurements from a TDS meter are not highly accurate and they may not agree closely with the calculated values. A TDS meter should only be used as a qualitative measurement to determine if the TDS is higher or lower than previous measurements. "]
["Proceed to the Sparge Acidification sheet to calculate the quantity of acid needed to properly adjust water alkalinity for sparging."]
["**Things to Check when your Water Report does not balance**"]
["When the reported water testing results do not indicate balanced ion concentrations, there are things the brewer can check to evaluate what the potential errors are.  "]
["The first thing to check is the units used to report the ion concentrations.  All units are input into Bru'n Water in ppm or mg/L (milligrams per liter) units, but sometimes water reports present some concentrations in parts per billion (ppb) or µg/L (micrograms per liter) units.  If a concentration is reported in the ppb or µg/L units, that value must be divided by 1000 to convert it to ppm or mg/L units.  For instance, 200 ppb is equal to 0.2 ppm."]
["Some water reports may display ion concentrations in standard units such as (as CaCO3, as NO3-N, or as SO4-S).  In these cases, the reported concentration must be adjusted to the true ion concentration in ppm or mg/L.  Conversion factors for these ions are presented below.   A Calculator with these Unit Conversions is provided at the bottom of the Water Report Input sheet."]
["                        Ion                                                        Conversion \n                        Calcium as CaCO3 (ppm):                   multiply by 0.401 to convert to (ppm) Calcium\n                        Magnesium as CaCO3 (ppm):              multiply by 0.243 to convert to (ppm) Magnesium                                                            \n                        Bicarbonate as CaCO3(ppm):              multiply by 1.22 to convert to (ppm) Bicarbonate\n                        Carbonate as CaCO3(ppm):                multiply by 0.60 to convert to (ppm) Carbonate\n                        Sulfate as Sulfur (ppm as SO4-S):        multiply by 3.0 to convert to (ppm) Sulfate\n                        Nitrate as Nitrogen (ppm as NO3-N):     multiply by 4.43 to convert to (ppm) Nitrate"]
["If the water report includes Total Alkalinity or Temporary Hardness but does not report the Bicarbonate or Carbonate concentrations, a calculator is included on the Water Report Input sheet to estimate those concentrations.  Water pH does influence the relative amount of these ions, so the water pH must be entered.  If the water report does not provide the pH, use a typical pH of 8.0 for the calculation."]
["If the calculated Alkalinity value does not agree with the Alkalinity presented in the Water Report, adjust the Bicarbonate content on the Water Report Input sheet to better match the reported value.  "]
["Potassium, iron, nitrate, nitrite, and fluoride are typically present in low concentration, so their values should be small (frequently less than 10 ppm).  Verify if they were reported in parts per billion (ppb) units if their concentration values are significantly greater than 10.  Use the conversion tool in Bru'n Water to convert from ppb to ppm.  "]
["If any of these corrections produce a better ion balance, then the brewer may elect to use these revised concentrations for their water profile instead of having another water test performed or asking for additional water testing information."]
["Sparge Water Acidification"]
["           WARNING!  Acids can seriously injure persons.  All acid usage should be made with great care and proper storage, dosing, and protective equipment must be used.  Hydrochloric and Sulfuric Acids produce fumes that will attack eyes, skin, membranes, etc."]
["Acidification of brewing water to reduce alkalinity can be difficult to perform accurately without a good tool.  The adjustment of sparging water alkalinity is important for producing good brewing results.   Proper pH and temperature of sparging water will help reduce tannin extraction.   The recommended maximums for pH and temperature of sparging water to reduce tannin and silicate extraction are 6.0 and 170F (76C), respectively."]
["Hot water added to the mash (Infusions) to raise the temperature of the mash should be considered to be a portion of the brewer's Sparging Water volume.  Acidify and treat the Water Infusions as recommended for Sparging Water on the Sparge Acidification sheet. "]
["If only RO or Distilled Water is used for brewing, it may not be necessary to acidify the sparge water since RO and Distilled water already have low alkalinity.  Acidification of sparge water is only needed when water supply alkalinity is moderate or high.  pH targets for acidification only serve as indicators of low alkalinity.  Sparging water alkalinity reduction is the real goal of acidification, not pH adjustment.  When the starting water alkalinity is less than about 25 ppm, then further acidification should not be necessary."]
["With the alkalinity information for the Existing Water entered in the Water Report Input sheet, the proper amount of acid can be calculated for that water without significant trial and error.   The Sparge Acidification sheet is intended only for sparge water adjustments and should not be used for mashing water adjustment.  A separate mashing acidification (alkalinity adjustment) tool is provided at the bottom of the Water Adjustment sheet for mashing water adjustment."]
["The Water Report Input sheet calculates and displays the Alkalinity of the existing water.   That Alkalinity value is transferred to the Sparge Acidification sheet.  Enter the Starting Water pH in the Sparge Acidification sheet.  The Starting Water pH may be provided in the laboratory report.  "]
["If the Starting Water pH is not known, you can assume a relatively neutral pH between 7 and 8 without much impact to the acidification results.  The Target Water pH is also entered here.  Although the pH of sparging water is not the primary concern, it is the parameter used to adjust the sparging water acidification. The Target Water pH for sparge water generally ranges between 5.5 and 6.0.  "]
["If the brewer will be diluting the existing tap water with distilled or RO water, you will have to manually calculate the resulting alkalinity for your sparging water. That calculation is included in the Supporter's version of Bru'n Water.  "]
["If the Existing or Diluted Water Alkalinity is less than 25 ppm, then it may not be necessary to acidify the diluted sparging water.  "]
["The Final Water Alkalinity of the sparging water is the criteria used to guide the degree of acidification.  Reduce sparging water alkalinity to 25 ppm or less (as CaCO3) for best results.  "]
["To adjust the Final Alkalinity, vary the Target Water pH value until a desirable low Final Alkalinity result is produced.  The Set the Target Water pH value is the primary way to adjust the level of sparging water acidification."]
["Under most conditions, the brewer should leave the Water Volume to Treat set to 1.0.  Setting the water volume to either One (1) Gallon or Liter and the program will automatically scale the acid addition to correspond to the sparging water volume that is entered on the Water Adjustment sheet.  The Water Volume on the Sparge Acidificaton sheet can be reset to an actual volume (other than 1) if the brewer wants to perform a quick acid addition calculation instead of working through the rest of the program.  For normal brewing usage, set the water volume to 1. "]
["Use drop-down box to select the type of acid used for sparging acidification.  The Supporter's version of Bru'n Water includes the capability to use 2 acids for your sparging water and another 2 acids in your mashing water.  Typical solid and liquid acids used in brewing and wine-making are provided in the selection boxes.  If the acid is a liquid, enter the numerical strength reported for the acid and select the strength parameter   (% = Percentage, N = Normality, M = Molarity).  When entering acid percentage, enter as a whole number.  For example: enter 88% as 88 and not 0.88.  When using solid acids, the strength parameter setting is not used and has no effect on the calculations."]
["The following acids: Citric, Malic, and Tartaric can only be used in their SOLID form in Bru'n Water. The program is set up to employ those acids only in their solid form. Do not attempt to calculate additions for those acids in Bru'n Water if those acids are in their liquid forms since the result will not be accurate."]
["To increase the program's versatility, Bru'n Water allows brewers to use 2 different acids in both the sparging and mashing water treatment (up to 4 different acid additions). This feature may be useful for brewers with high alkalinity water that may incur excessive anion concentrations if only one type of acid is used. Using multiple acids may help keep those anions, such as lactate or sulfate, under their taste thresholds. The brewer must set the acid type and strength on both the Sparge Acidification and Water Adjustment sheets since each acid entry is separate."]
["The Outputs section on the Sparge Acidification sheet reports the quantity of the specified acid needed to bring the water to the desired pH and alkalinity.  If the specified acid is in solid form, the acid amount is provided as a mass.  If the specified acid is in liquid form, the acid amount is provided as a volume.  A conversion from milliliters (mL) to teaspoons (tsp) is provided for user convenience. If the Water Volume setting is 1, the acid amounts shown on the Sparge Acidificaton sheet are for 1 unit (gallon or liter) of water. The total acid additions for the total sparging water volume are correctly adjusted on the Water Adjustment and Adjustment Summary sheets for the water volumes entered there. "]
["The Sparge Acidification sheet also reports the concentrations of the anions from those acids. Chloride and sulfate concentrations from hydrochloric and sulfuric acids are reported. The Supporter's version of Bru'n Water includes CRS acid as a selection.  In addition, the various anions from lactic, acetic, phosphoric, tartaric, malic, and citric acids are also reported. While concentrations of the ions are reported on the Sparge Acidification and Water Adjustment sheets, refer to the Adjustment Summary sheet to find what the averaged concentrations of those anions are in the kettle and if they may be over their taste threshold. Anions over their taste threshold may affect beer flavor.  "]
["An accurate scale should be used for measuring solid acid additions and an accurate volume measure such as a graduated cylinder, pipette, or graduated dropper should be used for liquid additions.  Care and proper protective gear must be used when working with acid since it can cause serious physical harm.  Measure carefully and use instruments such as graduated pipettes or droppers to transfer acid.  If the brewer has a calibrated pH meter or test strips available, add about 3/4 of the calculated acid amount and mix the water thoroughly prior to checking the pH.  Add the remainder of the acid incrementally while checking the water pH to make sure the pH isn't overshot.  Once the performance of the Existing Water and the acid are confirmed to hit the Target pH, acid additions for future brewing sessions can typically be added all at once.  Use caution when using pH strips since there is evidence that the typical strips used by homebrewers measure about 0.2 to 0.3 units LOWER than actually present in the mash.  pH measurement with a calibrated meter is recommended.  If using pH strips, a pH reading that is about 0.2 units BELOW your targeted pH should be considered good.  Plastic (ColorpHast brand) pH strips are preferred since paper pH strips are known to be unsuitable for brewery use. Measurements from a properly calibrated pH meter will always be more accurate than strips. "]
["Variation in the water source pH or alkalinity can cause the pH target to be missed.  Heating or boiling water with moderate to high Temporary Hardness will Decarbonate the water.  This reduces the hardness and alkalinity of that water which will result in the overdosing of acid additions.   Since acid additions are calculated based on the unboiled alkalinity, Add acid before heating water to avoid decarbonation and dropping water pH too low.  The brewer should be aware of this possibility and measure their actual pH's when possible. "]
["When Sulfuric acid or CRS acid-blend is used, the concentration of added sulfate ions is provided in the Outputs.  When Hydrochloric acid or CRS acid-blend is used, the concentration of added chloride ions is provided in the Outputs.  These ion concentrations are averaged into the overall ionic profile of the finished water profile.     "]
["All acids used for acidification in the brewery should be sourced as Food-Grade chemicals.  The brewer should use acids with the designation: Food Chemical Codex (FCC) or United States Pharmacopeia (USP).  This is particularly important for the acids since they can easily dissolve and contaminated with heavy metals that are hazardous to health.  Although the highest purity classification for chemicals in the U.S. is Reagent ACS grade as designated by the American Chemical Society (ACS), it does not guarantee that hazardous or deleterious substances have not been introduced into the acid.  The FCC grade should be preferentially sourced for brewery use.  Reagent ACS or Reagent grade acids might be considered if food-grade acids cannot be obtained."]
["Proceed to the Grain Bill Input sheet to enter the grains in the mash.  "]
["Grain Bill Input"]
["The Grain Bill Input sheet is where the brewer enters the actual types and quantities of grains used in the mash."]
["In the past, rough correlations between beer color and appropriate Residual Alkalinity (RA) had been proposed.  Due to the non-linear relationships between grain color and its acidity, a good correlation cannot definitively be made between RA and beer color.  This Grain Bill Input sheet was developed to provide brewers with a more accurate assessment of beer color, alkalinity, and the resulting Net Acidity that drives the mash pH. "]
["Grain Color Setting: Enter the Color System used for the malts at the bottom of the Grain Bill Input sheet.  Click the cell and a drop-down box will display Lovibond or EBC selections for grain color systems."]
["Enter each grain used in the mash grist in the spreadsheet.  The grain names can be entered to help identify each component, but the grain names are not necessary.  Enter the Mass of each grain in either pounds and ounces or kilograms and grams.  Enter the Color of each grain in the proper units.  "]
["Grain Type: For each grain, use the Pink drop-down boxes to signify what type of grain is on that line (Base Malt, Crystal Malt, Roast Malt, or Acid Malt).  This selection is important since each category of malt has differing acidity versus grain color characteristics.  Grains with color greater than about 180 Lovibond should be entered as Roast Malts.  Be aware that these rules are not always true and some grains may be better represented with another grain-type setting. Grains with color lower than 478 EBC (180 Lovibond) should typically be entered as Base or Crystal Malts.  Acid Malt is also referred to as Saurermalt."]
["The color of the cells in the Grain Color column change to help signal the brewer what grain type is selected and if a color rating greater than 478 EBC (180 Lovibond) is used for a non-roasted grain or if a low color rating is used for a roasted grain.  When using Excel to run Bru'n Water, the cells are BLUE for Base Grains, LIGHT TAN for Crystal Malts, DARK TAN for Roast Malts, and GREEN for Acid Malt.  The cells turn RED when the color rating and roast malt settings do not agree with each other. "]
["Special Note: It appears that base malts from Rahr Malting may be pre-acidified by that company and they may provide more acidity than expected for similar base malts.   Other maltsters may also produce base malts that can be more acidic than typical. This may produce a mash pH lower than expected or calculated by this program.  A work-around for this problem is to set the color rating of the malt about 3 Lovibond higher than reported by the maltster to allow the program to calculate the correct acidity.   "]
["After the grain information is entered, the Total Weight of the grist and its Water to Grist Ratio are provided at the bottom of the sheet.  Compare the calculated total weight to your recipe total to verify the grain entries are correct.   A listing of the relative percentage of each grain in the grist is provided for confirmation with any other brewing recipe software the brewer uses. "]
["Water to Grist Ratio is an indication of how thick the mash is.  A thick grist may have a water to grist ratio of around 1 quarts per pound of grain while a thin grist may be up to 2 quarts per pound (2 to 4 L/kg).   The typical range is 1.25 to 1.5 quarts per pound (2.5 to 3 L/kg) although thinner grists may have advantages.  Since the water used for mashing typically contains alkalinity, a thinner grist will have more milliequivalents (mEq) of alkalinity than a thick grist.  More alkalinity consumes more of the grain acidity and the mash pH will likely be higher with a thin mash than a thick mash.  Therefore, it may be necessary to further reduce the water alkalinity to provide appropriate mash pH when the mash is thinned.  Adjusting the Water to Grist Ratio can be used to adjust the mash pH."]
["The Estimated Color of the beer (in EBC and SRM units) is provided at the bottom of the sheet for comparison with the brewer's brewing calculations or software results (Promash, Beersmith, etc.).  Note that the batch volume (entered on the Water Adjustment sheet) affects this calculation and must be the same as the brewing calculation's or software's input in order to see agreement.  The Morey equation is used for the color calculation. "]
["Water Source Setting: At the bottom of the Grain Bill Input sheet, a drop-down box allows the brewer to toggle between the brewer's Existing Water (unadjusted) and the Adjusted Water (Finished) calculated on the Water  Adjustment sheet.  Typically, the box should be left on the Adjusted Water setting, but the brewer can use the other setting to see what the mash pH would be without water adjustment.  Select the cell and the drop-down selection box will appear."]
["The Supporter's version of Bru'n Water includes the ability to reserve crystal malts or roasted grains from the mash to improve the mashing pH. That version also includes the ability to adjust the strength setting of Acid Malt so that it better reflects the pH adjustment it creates.  "]
["The results of the analyses are summarized as the Mash pH. If the mash pH falls well outside the preferred range,  BE SURE THAT ALL THE CORRECT GRAIN TYPE SELECTIONS ARE MADE FOR EACH GRAIN LISTING.  IT MAKES A BIG DIFFERENCE IN THE RESULTS!  When using Excel to run Bru'n Water, the Estimated Mash pH cell color changes from RED to ORANGE to GREEN to indicate to the brewer the deviation in the result from the suggested range. "]
["Mash pH may be checked about 5 minutes after combining the water and grist.  But for more accurate results, the mash pH should be checked at around 10 to 15 minutes after combining the water and grist.   Note: pH strips reportedly indicate the mash pH is about 0.2 to 0.3 units lower than actual.  Therefore, accept a LOWER pH when measuring with strips.  A calibrated pH meter is the recommended and preferred measurement device.  Always check wort pH in room-temperature samples."]
["In a typical mash, the mash pH tends to trend toward a pH of about 5.4. If the pH is initially lower than 5.4, it tends to rise during the course of the mash. If the pH is initially above 5.4, it tends to fall during the mash.  Bru'n Water pH prediction tends to present the pH during the early stage of mashing when most enzymatic activity and starch conversion occurs.  "]
["The Bru'n Water mash pH estimation should only be considered a good approximation.  Variation in water, mineral, and grain quality can easily alter the actual mash pH.  The brewer can expect that the estimated mash pH should typically be within 0.2 units from the room-temperature mash pH reading.  The algorithm used to estimate the mash pH was produced through the evaluation of actual mashs and resulting pH.  That algorithm will be modified based on the results of brewer's reports.  A copy of this program that includes the brewer's input data along with their measured room-temperature mash pH can be sent to the program author for inclusion in this study and refinement.  "]
["Characteristics of wort from the mash can be altered slightly through adjustment of the mash pH.  The Extract and Fermentability of the wort can be enhanced by adjusting the wort pH toward the low end of the range.  Conversely, the Body and Mouthfeel of the wort can be enhanced by adjusting the wort pH toward the high end of the range (from Malting and Brewing Science, 1981).  The brewer should consider these results when adjusting the mashing water alkalinity and the resulting mash pH. "]
["Remember: \n              Lower mash pH = higher fermentability and less body\n              Higher mash pH = lower fermentability and more body\n                                   \nKeep mash pH within the desired pH range to help produce your desired result."]
["The overall pH of the pre-boil wort can also alter the flavor perception of the beer.  The pre-boil wort pH is a product of the mash pH and sparging water pH.  Lower pre-boil wort pH can produce a sharper and tarter flavor perception.  Lower pre-boil wort pH can also reduce hop and bittering expression in the finished beer.  Higher pre-boil wort pH can produce a rounder and fuller flavor perception.   In the mash, higher pH helps to extract flavor and color from roast malts, but recognize that excessive mash pH (>5.8) may lead to excessive tannin and silicate extraction."]
["To produce the mash pH effects mentioned above, the brewer should generally target a room-temperature pH range of between 5.3 and 5.5.  Target a mash pH of 5.3 for the lower mash pH perceptions and target a mash pH of 5.5 for the higher mash pH perceptions."]
["Adjust the acid malt content of the grain bill or revisit the Water Adjustment sheet if the Predicted Mash pH does not fall within the brewer's target pH range. The Water Adjustment sheet provides tools to adjust the mash pH.  The mash pH prediction from the Grain Bill Input sheet is also shown on the Water Adjustment sheet so that the brewer can fine-tune the mineral and acid additions without switching to the Grain Bill Input sheet.  Be aware that the mash pH predictions are not valid until the mash grist and water volume are properly entered on the Grain Bill Input sheet."]
["If more acidity is needed, a recommended alternative is to decrease the water alkalinity by reducing the water's bicarbonate content by adding more acid or reducing any Baking Soda, Chalk, or Pickling Lime additions.  If less acidity is needed, decrease any acid addition or increase the bicarbonate content to the mash water to consume more grain acidity.  If dilution was used to produce the Adjusted Water, reducing the dilution percentage can typically increase the bicarbonate content since most drinking water has alkalinity."]
["The Mash Acidification analysis provides a better assessment of what mash pH will be produced.  This enables the brewer to better adjust their water or mashing conditions to produce the beer characteristics they prefer or require.  "]
["Proceed to the Water Adjustment sheet to calculate the mineral and acid additions to create the desired mashing water profile.  "]
["Water Adjustment"]
["            After entering the Water Report information, water adjustment can be properly estimated for the Existing Water.  The Existing Water Profile is automatically entered into the Water Adjustment sheet from the Water Report Input sheet.  If the Existing Water Profile is not shown or is not correct on the Water Adjustment sheet, correct the entries on the Water Report Input sheet."]
["If the Brewery has a consistent source water quality, its likely that the Water Report Input and Sparge Acidification sheets will not need to be updated for subsequent brews.  Only the Water Adjustment and Grain Bill Input sheets will have to be updated for each brew.  "]
["A Desired Water Profile can be selected in the Water Adjustment sheet from either a selection of profiles that generally fit the intended beer style.  The Water Adjustment sheet includes typical minerals and acids that can be used to adjust the water ion content."]
["A wide range of target water profiles are available in the Pink drop-down selector box to suit a variety of beer styles.  These water profiles have been thoroughly researched and represent accurate and balanced ion concentrations for either the brewing center location or the beer style.  Unfortunately, water profiles previously published in both print and electronic resources have had serious errors in ion content and ionic balance and cannot always be considered accurate or appropriate.  The water profiles presented in this program provide the brewer with the best information available.  "]
["Brewers should use caution in the use of historical water profiles.  Although the water profiles are accurate, that does not mean that the brewers in those locations used that water without modification.  For example, brewers performed operations such as Decarbonation by Boiling to reduce hardness and alkalinity and used acid rests and saurermalt (acid malt) or saurergut (soured wort) to reduce high alkalinity.  Profiles with high bicarbonate concentrations are likely to have been treated by those means prior to mashing when light-colored beers were brewed.  Brewers should approach these profiles with a focus on the mash pH they produce with their proposed grain bill and be ready to adjust the mashing water alkalinity if the water does not produce a desirable mash pH. "]
["Some historical water profiles that are suitable for Decarbonation by Boiling are provided in the water choices with their estimated post-boiling ionic content (for example: (Munich boiled)).  These profiles may be useful for brewing lighter-colored beers that may have been brewed in those cities.  Boiling a water with high Temporary Hardness will reduce the bicarbonate content to between 60 and 80 ppm.  For the purpose of these estimates, the upper end of the bicarbonate range (80 ppm)(indicating less effective decarbonation) was used to estimate the post-boiling water that those historic brewers might have been able to attain.  The decarbonation process causes calcium carbonate to precipitate from the water, reducing the concentrations of both calcium and bicarbonate.  The concentrations of the other water profile ions remain as in the original water profiles.  See the Water Knowledge sheet for more information on Decarbonation. "]
["The Bru'n Water water profiles include recommendations based on the color of the beer to be produced.  These profiles were devised to provide relatively low mineralization while providing minimum recommended calcium concentration and modest levels of magnesium, sodium, chloride, and sulfate.  For the brewer's convenience, a description of the color range for the color descriptors used in the provided water profiles is provided below and on the Water Adjustment sheet.  "]
["                                                        Beer Color Descriptors\n                                                       Yellow:              SRM < 6\n                                                       Amber:              SRM between 7 and 17\n                                                       Brown:              SRM between 18 and 30\n                                                       Black:               SRM > 31"]
["The brewer should typically start with a water profile that agrees with their intended beer color.  If brewing a lighter colored beer and the brewer wants to use a historic water profile, select the \"boiled\" version of the historic profile to avoid excessive alkalinity.  Water profiles should be considered approximate.  Variation of the water profile to meet the brewer's taste is acceptable and recommended.   It may be necessary to revise the selected mineral profile if the proposed grain bill and water profile do not produce a desirable mash pH.  WHEN THE MASH pH DOES NOT FALL WITHIN A DESIRABLE RANGE, ADJUST THE PROFILE'S ALKALINITY AWAY FROM THE TARGET VALUE. In most cases, it is also acceptable to let the calcium content vary from the profile's target value. The only recommendation for calcium content is to have at least 40 ppm in the mash to precipitate oxalate. Since the water profiles do not consider what the actual grist used was or what the brewers in that historic brewing location had to do to use their water (acid rest, boiling, etc.), the brewer should rely more on the pH result rather than the ionic content recommended by the water profile.   An appropriate mash pH result is the brewer's primary goal."]
["Entering or Revising Water Profiles: Any of the water profiles included in Bru'n Water can be altered to fit the brewer's taste. Go to the table at the bottom of the Water Adjustment sheet and revise the existing data and names, as desired. The profiles for Distilled and RO water can also be adjusted as desired."]
["Add Minerals in the Water Additions section of the Water Adjustment sheet to increase the appropriate ion concentrations.  The YELLOW cells in the Mineral Table show which ions each mineral will increase.  For instance, adding Gypsum will add Calcium and Sulfate.  Review the Target Water Adjustment and Actual Water Adjustment cells for each ion.  If cells in the Target Water Adjustment row are RED, see the Dilution instructions below.  "]
["If the Existing Water Profile has ion concentrations that are higher than the Desired Water Profile, then dilution with distilled water (DI) or reverse osmosis (RO) water can be used to reduce those ion concentrations.  To help identify when ion concentrations in the Existing Water Profile are higher than the Desired Water Profile, cells within the Target Water Adjustment line will be colored RED.  If the difference between the Existing and Desired ion concentrations are small, the brewer may decide to ignore the need to dilute the existing water to reduce the Existing concentrations.  The brewer should avoid adding minerals that increase over-Target ion concentrations.  "]
["Dilution: If dilution is desired, select the type of dilution water from the drop-down box and dial up the percentage of dilution water added to the existing water until the RED cells in the Target Water Adjustment line return to YELLOW color.  Dilution water must have low ionic content in order to be effective. Water such Distilled and RO water are potential resources. Distilled water is typically available in bottles or jugs and it typically contains virtually no ionic content.  RO is produced by specialized apparatus that is available in residential and industrial sizes. Commercial water vending machines such as those in grocery stores typically provide RO water.  RO water does contain low concentrations of ions.  A typical RO water profile is included in Bru'n Water.  That RO profile can be adjusted to reflect the brewer's RO water quality at the bottom of the water profile table.   "]
["If only the bicarbonate (HCO3) concentration of the water supply is too high and the other ions are not too high, then acidification may be preferred for bicarbonate reduction instead of dilution.  An Acid Addition calculator is provided at the bottom of the Water Additions section that shows the bicarbonate reduction provided by acid addition.  An acid can be selected on the Water Adjustment sheet. The acid type, form, and strength parameters are entered on the Water Adjustment sheet. The Supporter's version of Bru'n Water enables you to use 2 different acids in the mash.  The Acid Addition calculator indicates the bicarbonate consumed (-HCO3) by the acid addition.  It also indicates the sulfate added when using Sulfuric Acid or the chloride added when using Hydrochloric Acid.  These ion additions are included in the Actual Water Adjustment.  "]
["The Supporter's version of Bru'n Water includes reporting on the concentration of acid anions that you add to your water. These can be important since many acid anions add flavor to the beer and can be detrimental at excessive concentrations.  The concentrations of anions such as lactate, phosphate, malate, citrate, tartarate, and acetate are calculated and displayed alongside the acid calculations. Text displays alert the brewer if the concentrations are above or below the typical taste thresholds for each ion. If an anion is reported to be above its taste threshold, the brewer may elect to alter the amount of the excessive acid.  "]
["Safety: Care must be exercised when working with acid since they can cause serious physical harm.  Measure carefully and use instruments such as graduated pipettes or droppers to transfer acid."]
["Water Volumes: Enter the water volumes to be used in the brewing and production in the BLUE cells at the top of the Water Additions area.  Enter the total volume of water that will be added to the mash tun as the Mash Water Volume.  Enter the total volume of water that will be added for mash out and sparging as the Sparge Water Volume.  Enter the total finished volume of the batch as the Total Batch Volume.  The Total Batch Volume is only used to estimate the beer color (SRM) on the Grain Bill Input sheet.  Note that the Total Batch Volume will be less than the mash plus sparge volume due to grain adsorption, evaporation, etc.  "]
["Estimated Mash pH is provided on both the Water Adjustment and Grain Bill Input sheets to allow the brewer to quickly assess the effect of the water adjustments on the mash.  The estimated pH value is identical on both sheets. This pH estimate is not valid until the grain additions are properly entered on the Grain Bill Input sheet.  When using Excel to run Bru'n Water, the color of the pH estimate cell changes color from RED to ORANGE to GREEN to help alert the brewer if their pH result is in range.  "]
["Using the minerals and acids the brewer has on hand, add quantities of those minerals and acids on a trial and error basis in the BLUE cells under the Water Additions area until acceptable agreement between the Target and Actual Water adjustments is achieved.    "]
["A very useful feature of the Supporter's version of Bru'n Water, is its ability to estimate the overall concentrations of ions in the final wort. Those concentrations can be quite different from the mashing water concentrations. In addition, that version includes the ability to tell the program that you are considering techniques such as adding all the mashing and sparging mineral additions to the mash or reserving the mineral additions for the kettle. "]
["Alkalinity is adjusted by increasing or decreasing the bicarbonate (HCO3-) or hydroxyl (OH-) concentration.  Add chalk, baking soda, or pickling lime (aka: slaked lime) to increase alkalinity.  Add acid or dilute with distilled or RO water to reduce alkalinity."]
["Warning: Pickling Lime is a strong caustic and can cause burns.  Pickling Lime is typically available as a fine powder and can easily be blown onto skin, eyes, nose, and mouth.  Use great care when using Pickling Lime and measure carefully.  ADD PICKLING LIME ONLY TO THE MASH.  AVOID ADDING LIME TO ONLY THE WATER OR THE WATER pH MAY INCREASE EXCESSIVELY AND MAY PRECIPITATE CALCIUM CARBONATE.   Most alkalinity adjustment requires very small Pickling Lime additions.  If the brewer does not have a scale that can measure down to 0.1 gram accuracy, creating a Lime Water solution may be an acceptable alternative.  For instance, a solution can be created by adding 1 gram of Pickling Lime to 1 liter of water.  Add tenths of the liter of solution to the mash corresponding to the tenths of a gram of Pickling Lime indicated on the Water Adjustment sheet.  Craftbrewer batch sizes are typically large enough to reduce the need to dose lime at tenth of a gram accuracy."]
["Customizing Water Profiles: If the brewer desires to adjust the ion concentrations or names of the supplied water profiles, the water profile table is located at the bottom of the Water Adjustment sheet (scroll down) and the water profiles can be adjusted by the brewer.  The Distilled and RO water profiles can also be renamed and their concentrations changed. Be sure to verify that the Cation and Anion totals match when adjustments to a water profile are entered.  The Cation and Anion cells in the table will turn GREEN when the ion totals are within 0.1 of each other to alert the brewer that the ion totals are appropriate."]
["The variation of Dry, Balanced, and Full water profiles generally reflect the relative content of sulfate (SO4) and chloride (Cl) in the water profile.  Select the water profile that generally meets your taste goal.  As an example, a hoppy American style may benefit from a bitter water profile while a sweeter German style may benefit from a malty water profile.  The concept of this sulfate/chloride ratio was modified from the Handbook of Brewing, Priest & Stewart, 2006 and the water chapter by David Taylor.  This concept assumes that chloride accentuates malt and sweetness and sulfate accentuates dryness and bitterness.   Therefore, the ratio of these ions is used as an indicator of the sweetness or bitterness perception of the finished beer.   "]
["Minerals for sparging water can be added to the sparging water prior to sparging or can be added directly to the kettle prior to the boil.  DO NOT ADD MINERALS AND ACIDS TO THE GRAIN OR MASH SINCE IT IS VERY DIFFICULT TO DISTRIBUTE THOSE ADDITIONS EVENLY THROUGHOUT THE MASH BY MIXING OR STIRRING. Add the minerals and acids to the water prior to adding the grain in order to assure those additions are evenly distributed.  "]
["Acids and Bases (Baking Soda, Chalk, and Pickling Lime) should not both be added to water since they counteract each other.  Add either an acid or a base as needed to control mash pH, not both.  If both an acid and base are entered on the Water Adjustment sheet, warnings will be displayed on the Water Adjustment sheet (red cells) to alert the brewer of this error. This warning is also displayed if acid malt is included in the grain bill and a base is added to the mashing water."]
["The bicarbonate contributions shown for Baking Soda, Chalk, and Pickling Lime in the Water Additions area represent their equivalent bicarbonate alkalinity contributions.  Baking Soda and Pickling Lime will easily dissolve in water or the mash.  Since Chalk has limited solubility in water or in the mash, special measures will be required to dissolve the Chalk and produce its expected bicarbonate and alkalinity contribution.  Adding Chalk powder directly to the mash has been proven to be ineffective in adding alkalinity to the mash."]
["To effectively use Chalk, the Chalk has to be fully dissolved by mixing it with water in a sealed container and then pressurizing with Carbon Dioxide (CO2).  The CO2 dissolves the Chalk in the water, changing the water from cloudy to clear.   This process is not quick and requires planning and preparation.  Therefore, using Chalk to add alkalinity to mash water is not recommended unless the brewer is going to perform these measures.   "]
["If the Desired Water Profile has a significantly lower than desired bicarbonate (HCO3) concentration (Alkalinity), then a preferred method to add bicarbonate to mashing water is to add Pickling Lime or Baking Soda since Chalk is difficult to dissolve in water or the mash.  When alkalinity needs to be added to the mash water, Pickling Lime or Baking Soda will provide more certain results.  Care should be exercised when adding Baking Soda since the Sodium concentration should typically not exceed 100 ppm for good brewing results.  ONLY MASHING WATER SHOULD HAVE ITS BICARBONATE CONCENTRATION INCREASED.  SPARGING WATER NEVER NEEDS ADDED ALKALINITY."]
["A variety of minerals used for water chemistry adjustment are referenced in the spreadsheet.  Vary the mineral amounts and compare the Target Water Adjustment and Actual Water Adjustment results to find the combination of minerals that best approximate the Desired Water Profile.  When using Excel to run Bru'n Water, the Target and Actual adjustment cells will turn GREEN when the values are within 10 ppm of each other.  You should not be too concerned with a difference greater than 10 ppm, but that is a reasonable target range.  In general, you should use a lower than targeted concentration when they have difficulty in finding the correct combination of minerals to add to meet the targeted concentrations.  "]
["The Water Adjustment sheet reports the ion concentrations for both Mashing and Finished worts. The Mashing Water Profile enables separate monitoring of calcium, magnesium, and bicarbonate levels in the mash that are important for pH and oxalate reduction. To estimate the Finished Water Profile which reports overall ion concentrations in the kettle that are important for yeast flocculation and beer flavor, you should upgrade to the Supporter's version of Bru'n Water.  "]
["All minerals and acids used for water adjustment should be identified as Food-Grade chemicals.  This is particularly important for the acids used for water adjustment since acids can easily dissolve and contain heavy metals that are hazardous to health. "]
["Homebrewers are encouraged to use a scale with an accuracy of at least 0.1 gram to measure mineral additions.  Craftbrewers can use scales with 1 gram accuracy since their batch size is typically larger.  Volume measures such as teaspoon or tablespoon can be significantly less accurate than weight measures for dry mineral additions.  Inexpensive scales with good accuracy are available and recommended."]
["Working with Calcium Chloride: Calcium chloride can easily absorb moisture from the air and alter the density of the solid calcium chloride mineral. In addition, calcium chloride is commonly available in anhydrous (no water) and dihydrate (2 water molecule) forms. This version of Bru'n Water assumes your calcium chloride is in the anhydrous form which helps you avoid overdosing with calcium or chloride.  Since the mineral can easily pick up moisture and alter its density, which subsequently changes how much calcium chloride is actually added to the water, an alternative is to use a calcium chloride solution. Calcium chloride solution strength is more consistent when it is stored in an air-tight container. The Supporter's version of Bru'n Water includes the capability to select anhydrous, dihydrate, and liquid forms of calcium chloride as inputs for your additions."]
["All Mash Water mineral and acid additions are typically added to the mash in order to create the desired water profile and produce the desired mash pH.  These additions are not typically added directly to the boil kettle except when the hardening the mash water will increase the need for alkalinity in the mash water.  If the mash pH calculations indicate that additional alkalinity is required, the brewer may consider adding hardening minerals such as gypsum, calcium chloride, and epsom salt directly to the kettle to avoid hardening the water and reducing mash pH. "]
["Mineral and acid additions to Mash and Sparge Water are calculated for their water volumes and shown on the Water Adjustment sheet.  Sparge additions should not include the alkalinity increasing minerals (Baking Soda, Chalk, & Pickling Lime) since alkalinity is not needed or desirable in the sparge water. When using Excel to run Bru'n Water, the cells for acids and alkalinity increasing minerals will turn Red if both acids and bases are both entered for the mash. Since those materials counteract each other, the brewer should avoid adding both. Remove one of the materials and reduce the quantity of the other to avoid adding both materials. If the grain bill includes Acid malt and an alkalinity increasing mineral is added to the mashing water, the cells will also turn Red to warn the brewer. "]
["Sparging Water mineral additions can be added directly to the Sparging Water or can be reserved and added directly to the boil kettle.  Acid additions calculated for the Sparging Water must be added to the Sparging Water to reduce its alkalinity prior to use.  If CRS, Hydrochloric, or Sulfuric acids are used to acidify the sparging water, their chloride or sulfate ion contributions are included in the overall ionic concentrations computed by Bru'n Water."]
["Proceed to the Adjustment Summary sheet to review the final water adjustment results."]
["Special Considerations for Extract Brewers:"]
["Brewers using Malt Extract for their brewing can still benefit from Water Adjustments.  This is particularly true when using either highly mineralized or alkaline water or when using RO or Distilled Water.  Best results for Extract Brewers will typically be achieved by using water with very low mineralization.  If desired for flavor purposes, small additions of either gypsum or calcium chloride can be added to the water for flavor purposes.  Its recommended that no more than 50 ppm chloride be added to low mineralized water when creating malty styles and no more than about 150 ppm sulfate be added to low mineralized water when brewing hoppy styles since the extract typically provides some mineralization to the water."]
["When using highly mineralized or alkaline water, the water can impart poor flavor to the beer.  Using highly alkaline water may increase the pH of the resulting wort and create a coarser and rougher flavored beer.  If the water has high ion concentrations, dilution with RO or Distilled Water may be appropriate.  The brewer should know what is in their tap water prior to contemplating mineral additions.  The Dilution Calculator on the Water Adjustment sheet can help the brewer assess how much dilution will be needed to produce a desirable water profile.  If the water has high alkalinity, the Sparge Water Acidification Calculator can be used to reduce water alkalinity to under 50 ppm which should allow the wort and resulting beer to reach desirable pH.  The Water Profiles on the Water Adjustment sheet are appropriate goals for Extract Brewers."]
["When brewing with RO or Distilled Water and Malt Extracts, the extract should provide most of the minerals needed for proper fermentation performance.  Although the ion content in the Malt Extract is typically low to moderate, some extract products may have high content.  Be aware that Briess malt extracts have high sodium content (about 100 ppm Na in a wort reconstituted to 1.045 gravity, 200 ppm @ 1.089).  If the brewer desires a specific flavor profile, additional sodium-, sulfate- or chloride-containing minerals can be added to the brewing water.  The Water Adjustment sheet can help the brewer assess how much of these minerals should be added to the brewing water.   "]
["Adjustment Summary"]
["The Adjustment Summary sheet provides the brewer with a concise report of the Existing, Mashing, and Finished Water characteristics and the Mineral and Acid adjustments recommended to produce the Finished Water.  It is intended to provide a single sheet that can be used as a quick reference during brewing."]
["Note to previous Bru'n Water users: References to Residual Alkalinity and the SO4/Cl ratio have been largely erased from the new version. Those concepts have done a great disservice to brewing water chemistry and removing them from this version is your first step to ridding them from your brewing practice. We extend our apologies if you felt they were useful. "]
["Recommended ranges for the various ions are shown on the sheet to provide the brewer with a quick check of their proposed brewing water profile.  The brewer's identifier or batch name is shown at the top of the sheet.  The Water Profile name selected on the Water Adjustment sheet is shown on the summary sheet for reference.  All of the information shown on the Adjustment Summary is input or calculated on the other sheets within Bru'n Water.  No inputs are performed on the Adjustment Summary sheet.  Be sure that water volumes are properly entered on the Sparge Acidification and Water Adjustment sheets.  The water volume input on the Sparge Acidification sheet can be entered as either the unit (1) volume or the total sparge volume.  The water volumes input on the Water Adjustment sheet should reflect the total volumes of water to be used for mashing and for sparging. "]
["The volumes of dilution water for both the mashing and sparging are shown on the Adjustment Summary sheet.  The Dilution Water volume is calculated from the dilution percentages input for the mashing water adjustments and the total mashing and sparging water volumes.  The Supporter's version of Bru'n Water includes information on Sparging water dilution volume. The Total Water volumes are equal to Dilution Water volume plus Tap Water volume.  A suggested approach is to add the Dilution Water volume to the vessel and then add Tap Water to reach the desired Total Water volume."]
["The sheet includes information on the total mineral and acid quantities needed for both the mashing and sparging water.  The estimated mash pH is also shown.  The mash pH cell changes color to signal how the estimated pH compares to the optimum range (5.3 to 5.5).  When using Excel to run Bru'n Water, the cell is GREEN when the estimated pH is within that range and ORANGE when just outside that range.  The cell turns RED when the estimated pH falls outside the recommended range of 5.2 to 5.8.   "]
["The acids used for both sparging and mashing are shown on the Adjustment Summary. The cells may be blank if no acids were selected or used on the Sparge Acidification and Water Adjustment sheets. "]
["The Supporter's version of Bru'n Water includes a Raw Text Summary sheet that is provided to enable the brewer to convey their brewing water information to others.  By copying the information in the cells highlighted in GRAY cells on the Raw Text Summary sheet, the brewer can easily paste that information in emails, webpages, brewing logs, or into notes in typical brewing software such as ProMash or Beersmith.  The formatting of the information on that sheet will typically produce uniform columns when pasted as TEXT.  The Supporter's version also includes the capability to save 100 Bru'n Water sessions in the program so that they can be recalled and reused the next time you brew that beer. "]
["Acknowledgements"]
["            The Author thanks A.J. DeLange for producing and publishing outstanding resources on mash chemistry and acidification and serving as a continuing resource to the brewing community.  The Author also thanks Kai Troester for the grain acidity information used in this program and his service to the brewing community.  Thanks to James Marsh for pointing out programming enhancements for the program."]
["About the Author "]
["           Martin Brungard is a civil and environmental engineer with over 30 years of professional experience.  His practice area focuses on water resources engineering and he has been named a Diplomate of Water Resources Engineering by the American Academy of Water Resources Engineers.  His engineering practice includes providing engineering consulting services to municipalities and major and craft brewers across the United States.  Martin provides consulting services to brewery clients through his Bru'n Solutions company which is found at www.Brunsolutions.com.  He has been homebrewing since 1999, is a member of the American Homebrewers Association, and has attained the rank of National Judge from the Beer Judge Certification Program (BJCP).  Comments and concerns regarding this program may be sent to the author at the link below"]
["mabrungard@hotmail.com"]
["Support the development of Bru'n Water"]
["The Supporter's version of Bru'n Water includes a significant number of enhancements that aid brewers in improving their beers. Donating at least $10 will get you the latest Supporter's version and keep you in the upgrade loop.  Users that value the use and development of Bru'n Water can support the continued development and show support by donating through their PayPal account.    To assist the team in continuing the improvement of this program and to indicate your approval and support, donations through PayPal are welcome.  A few dollars are truly welcome from those that find this program and water knowledge useful.  Use the email address mabrungard@hotmail.com to forward comments about the program and to direct donations to the development team.  For those with a PayPal account, a link to the Bru'n Water website is provided below.  The website has links to Paypal to support Bru'n Water.  Use the SEND MONEY tool and select the PERSONAL tab to direct a GIFT amount to the developers.                                                                                                                        "]
["https://sites.google.com/site/brunwater/"]
["THE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OF THIRD PARTY RIGHTS. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR HOLDERS INCLUDED IN THIS NOTICE BE LIABLE FOR ANY CLAIM, OR ANY SPECIAL INDIRECT OR CONSEQUENTIAL DAMAGES, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE."]
["Bru'n Water v. 1.18",null,null,null,null,null,null,null,null,null,"2016-12-10"]

{"sheet":"1. Water Report Input","index":1,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,2,3,3],[4,1,4,2],[0,1,0,3],[17,0,17,3],[9,0,9,1],[21,0,21,3],[36,0,36,3],[13,0,13,3],[12,0,12,3],[16,0,16,3],[14,2,14,4],[15,0,15,3]]}
["Bru'n Water","Link to Bru'n Water website for updates and to donate"]
["Enter data into Light Blue cells, Yellow cells display calculated results, Pink cells contain selection boxes"]
["Program Volume Setting","Gallons","< Select",null,null,null,null,1,"Gallons"]
["Water Report Input ",null,"Hover cursor over cells w/ red corner marks to display information",null,null,null,null,2,"Liters"]
["Cations","Enter Ion Concentrations from Water Report     (mg/L or ppm)",null,"Anions"]
["Calcium (Ca)",30.97,108.8,"Bicarbonate (HCO3)"]
["Magnesium (Mg)",7.88,0.5,"Carbonate (CO3)",null,null,null,{"$f":"INDEX(H3:H6, MATCH(B3, I3:I6,0))","v":1}]
["Sodium (Na)",14.57,24.15,"Sulfate (SO4)","multiply lab result by 3 if lab reports as SO4-S"]
[null,null,27,"Chloride (Cl)"]
["Optional Inputs (not required, but may improve ion balance)",null,1.2,"Nitrate (NO3)","multiply lab result by 4.43 if lab reports as NO3-N"]
["Potassium (K)",1.5,0,"Nitrite (NO2)"]
["Iron (Fe)",0.02,0.12,"Fluoride (F)"]
[{"$f":"IF((ABS(I14-I15)>0.5), \"Water Report is unbalanced. Check your inputs\",\"\")","v":""}]
["Calculated Alkalinity",null,null,null,null,null,null,null,{"$f":"(N(B6)/20.05)+(N(B7)/12.15)+(N(B8)/23)+(N(B11)/39.1)+(N(B12)/28)","v":2.8657537927112675},{"$f":"ABS(I14-I15)","v":0.22495116670903936}]
["Alkalinity (ppm as CaCO3)",{"$f":"50*((N(C6)/61)+(2*(N(C7)/60)))","v":90.013661202185787},"<-- This value is automatically entered on the Sparge Acidification sheet",null,null,null,null,null,{"$f":"(N(C6)/61)+(N(C7)/30)+(N(C8)/48)+(N(C9)/35.45)+(N(C10)/62)+(N(C11)/46)+(N(C12)/19)","v":3.0907049594203069}]
["Use the calculators below, only if your water report does not balance and you need to convert some values."]
["Alkalinity Conversion Calculator"]
["If water report provides only Total Alkalinity or Temporary Hardness (as CaCO3), use this calculator to estimate the Bicarbonate and Carbonate concentrations.  Insert the estimated Bicarbonate and Carbonate results in the Water Report table above."]
["Reported Total Alkalinity or Temporary Hardness (as CaCO3) (mg/L or ppm)","Reported or Measured Water pH","Estimated Bicarbonate Concentration (ppm)","Estimated Carbonate                   Concentration (ppm)"]
[90,8.01,{"$f":"((N(A20)/50)/(1+(2*10^(N(B20)-10.33))))*61","v":108.75889440658536},{"$f":"((N(A20)/50)/(1+(2*(10^(N(B20)-10.33))))*(10^(N(B20)-10.33)))*60","v":0.51201914430228168}]
[]
["Ion Concentration Conversion Calculator"]
["Input Reporting Unit  ","Input","Output","Output Reporting Unit"]
["Calcium (ppm as CaCO3)",0,{"$f":"0.401*B24","v":0},"Calcium (ppm)"]
["Magnesium (ppm as CaCO3)",0,{"$f":"0.243*B25","v":0},"Magnesium (ppm)"]
["Bicarbonate (ppm as CaCO3)",0,{"$f":"1.22*B26","v":0},"Bicarbonate (ppm)"]
["Carbonate (ppm as CaCO3)",0,{"$f":"0.6*B27","v":0},"Carbonate (ppm)"]
["Sulfate (ppm as SO4-S)",0,{"$f":"3*B28","v":0},"Sulfate (ppm)"]
["Nitrate (ppm as NO3-N)",0,{"$f":"4.43*B29","v":0},"Nitrate (ppm)"]
["US Hardness (grains/gallon)",0,{"$f":"6.86*B30","v":0},"Calcium (ppm)"]
["English (Clark) Hardness (grains/Imp gal)",0,{"$f":"5.71*B31","v":0},"Calcium (ppm)"]
["German Hardness (GH) (degrees)",0,{"$f":"7.14*B32","v":0},"Calcium (ppm)"]
["Karbonate Hardness (KH) (degrees)",0,{"$f":"21.8*B33","v":0},"Bicarbonate (ppm)"]
["Calcium Hardness (meq/L) or (mval)",0,{"$f":"20*B34","v":0},"Calcium (ppm)"]
["Alkalinity (meq/L) or (mval)",0,{"$f":"61*B35","v":0},"Bicarbonate (ppm)"]
["Convert (ug/L or ppb) to (mg/L or ppm)",0,{"$f":"B36/1000","v":0},"(ppm)"]
["Copyright © 2016 Martin Brungard. All rights reserved. Reproduction in whole or in part in any form or medium without the express written permission of Martin Brungard, is prohibited.  Any transfer or exchange of this program via any method to anyone other than the original licensee is prohibited.  Transferring, exchanging, or posting images (screen shots) of the program and of the Raw Text Summary sheet is permitted for the purpose of conveying program results to other individuals. The user of this program assumes all responsibility for the operation and results of the program. "]
[]
["Bru'n Water v. 1.18"]
["If the sheet does not show comments or red corner marks, select the REVIEW tab in the Excel program menu and click the SHOW ALL COMMENTS button twice."]

{"sheet":"2. Sparge Acidification","index":2,"n_rows":63,"n_cols":21,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,1,0,4],[17,0,17,3],[9,0,9,3],[2,0,2,3],[1,0,1,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[15,0,15,3],[16,0,16,3]]}
["Bru'n Water","Link to Bru'n Water website for updates and to donate"]
["Sparging Water Acidification Calculator"]
["INPUTS"]
["Starting Water Alkalinity =",{"$f":"'1. Water Report Input'!$B$15","v":90.013661202185787},"ppm as CaCO3"]
["Starting Water pH =",8,"Standard Units"]
["Set the Target Water pH =",5.5,"Standard Units"]
["Water Volume to Treat=",1,{"$f":"I57","v":"Gallons"},"Input 1.0 for the volume to have the program automatically calculate acid additions for the sparging volume input on the Water Adjustment sheet."]
["Acid Type =","Lactic","Acid type used in sparging water"]
["Acid Strength =",88,"%","< Select"]
["OUTPUTS",null,null,null,null,{"$f":"IF(N(B9)=0,1,N(B9))","v":88}]
["Final Water Alkalinity =",{"$f":"B4-(((Acid_Required+Acid_Required2))*50)","v":9.5122062504379272},"ppm as CaCO3"]
[{"$f":"VLOOKUP($A$40,table,11,FALSE)","v":"Lactic Acid Required ="},{"$f":"VLOOKUP($A$40,table,13,FALSE)","v":0.52901775689439934},{"$f":"VLOOKUP($A$40,table,8,FALSE)","v":"(ml)"},{"$f":"VLOOKUP($A$40,table,14,FALSE)","v":0.10733770287387362},{"$f":"VLOOKUP($A$40,table,9,FALSE)","v":"(tsp)"}]
["Sulfate Added to Water =",{"$f":"IF(A40=5,VLOOKUP(A52,strtable,4,FALSE),0)","v":0},"ppm"]
["Chloride Added to Water =",{"$f":"IF(A40=2,VLOOKUP(A52,strtable,5,FALSE),0)","v":0},"ppm"]
["Hover cursor over cells w/ red corner mark to display helpful information"]
["Recommendations for Sparging Water:  Low to moderate alkalinity is desirable for Sparging Water.                            DO NOT add minerals such as chalk, baking soda, or pickling lime to sparging water since these minerals increase water alkalinity.  Sparging water is acidified to reduce pH and alkalinity.                                                                 An alternative to adding these alkalinity increasing minerals is to increase the addition of calcium- or sodium-containing minerals (gypsum, calcium chloride, table salt) to compensate for the deletion of chalk, baking soda, or pickling lime from the sparging water mineral additions.  Another option to avoid adding these alkalinity producing minerals to the sparging water is to reserve these minerals additions from the sparging water and add them directly to the kettle.",null,null,null,null,{"$f":"IF(A40=9,(C53*64)/(J57*B7),IF(A40=2,VLOOKUP(A52,strtable,5,FALSE),0))","v":0},{"$f":"IF(A67=9,(C80*88.57)/(J57*B7),IF(A67=5,VLOOKUP(A79,strtable2,4,FALSE),0))","v":0}]
["Copyright © 2016 Martin Brungard. All rights reserved. Reproduction in whole or in part in any form or medium without the express written permission of Martin Brungard, is prohibited.  Any transfer or exchange of this program via any method to anyone other than the original licensee is prohibited.  Transferring, exchanging, or posting images (screen shots) of the program and of the Raw Text Summary sheet is permitted for the purpose of conveying program results to other individuals. The user of this program assumes all responsibility for the operation and results of the program. ",null,null,null,null,null,{"$f":"IF(A67=9,(C80*64)/(J57*B7),IF(A67=2,VLOOKUP(A79,strtable2,5,FALSE),0))","v":0}]
["Bru'n Water v. 1.18"]
["If the sheet does not show comments or red corner marks, select the REVIEW tab in the Excel program menu and click the SHOW ALL COMMENTS button twice."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r1o=",{"$f":"10^(N(B5)-6.38)","v":41.686938347033561}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r2o=",{"$f":"10^(N(B5)-10.33)","v":4.6773514128719777E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"do=",{"$f":"1+T22+(T22*T23)","v":42.881922807009367}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f1o=",{"$f":"1/T24","v":2.3319849823444545E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f20=",{"$f":"T22/T24","v":0.97213314185201416}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f3o=",{"$f":"(T22*T23)/T24","v":4.5470083245411934E-3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pHb=",4.3,"SU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r1b=",{"$f":"10^(T29-6.38)","v":8.3176377110267055E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r2b=",{"$f":"10^(T29-10.33)","v":9.3325430079699009E-7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"db=",{"$f":"1+T30+(T30*T31)","v":1.0083176454734979}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f1b=",{"$f":"1/T32","v":0.9917509670580128}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f2b=",{"$f":"T30/T32","v":8.2490252435489311E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f3b=",{"$f":"(T30*T31)/T32","v":7.6984382859249789E-9}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ct=",{"$f":"(N(B4)/50)/((T33-T25)+(T27-T35))","v":1.8502710297350304}]
[]
[]
[{"$f":"INDEX($A$41:$A$49, MATCH($B$8,$B$41:$B$49,0))","v":3},"acid","pK1","pK2","pK3","Mol. Wt.","SG","ml/mg","gm/tsp","dose",null,null,null,null,null,null,null,null,"r1c=",{"$f":"10^(N(B6)-6.38)","v":0.1318256738556407}]
[1,"Acetic",4.75,20,20,60.05,{"$f":"1000*((-7.575*10^(-10)*(F10^4))+(7.01*10^(-8)*(F10^3))+(-9.254*10^(-6)*(F10^2))+(1.575*10^(-3)*F10)+0.9979)","v":1067.18128768},"(ml)","(tsp)","Addition        (mL/gal)","Acetic Acid Required =","Total Acid Addition (ml)",{"$f":"VLOOKUP(A52,strtable,3,FALSE)","v":0.52901775689439934},{"$f":"$B$12*0.2029","v":0.10733770287387362},"Acetate Added to Water =",59,"(ppm) Acetate added to water",null,"r2c=",{"$f":"10^(N(B6)-10.33)","v":1.4791083881682046E-5}]
[2,"Hydrochloric",-7,20,20,36.46,{"$f":"1000*((-3.1666*10^(-7)*($F$10^3))+(1.8499*10^(-5)*($F$10^2))+(4.7666*10^(-3)*$F$10)+0.998)","v":1344.9221324800001},"(ml)","(tsp)","Addition        (mL/gal)","Hydrochloric Acid Required =","Total Acid Addition (ml)",{"$f":"VLOOKUP(A52,strtable,3,FALSE)","v":0.52901775689439934},{"$f":"$B$12*0.2029","v":0.10733770287387362},"-",null,"-",null,"dc=",{"$f":"1+T40+(T40*T41)","v":1.1318276237002405}]
[3,"Lactic",3.86,20,20,90.08,{"$f":"1000*((-5.6193*10^(-10)*($F$10^4))+(5.115*10^(-8)*($F$10^3))+(-1.1408*10^(-6)*($F$10^2))+(2.4529*10^(-3)*$F$10)+0.998)","v":1206.1794562355199},"(ml)","(tsp)","Addition        (mL/gal)","Lactic Acid Required =","Total Acid Addition (ml)",{"$f":"VLOOKUP(A52,strtable,3,FALSE)","v":0.52901775689439934},{"$f":"$B$12*0.2029","v":0.10733770287387362},"Lactate Added to Water =",89,"(ppm) Lactate added to water",null,"f1c=",{"$f":"1/T42","v":0.88352676596701052}]
[4,"Phosphoric",2.12,7.2,12.44,98,{"$f":"1000*((-3.9523*10^(-9)*($F$10^4))+(6.8571*10^(-7)*($F$10^3))+(5.4475*10^(-7)*($F$10^2))+(5.51368*10^(-3)*$F$10)+0.99778)","v":1717.4769519872},"(ml)","(tsp)","Addition        (mL/gal)","Phosphoric Acid Required =","Total Acid Addition (ml)",{"$f":"VLOOKUP(A52,strtable,3,FALSE)","v":0.52901775689439934},{"$f":"$B$12*0.2029","v":0.10733770287387362},"Phosphate Added to Water =",95,"(ppm) Phosphate added to water",null,"f2c=",{"$f":"T40/T42","v":0.11647151129309612}]
[5,"Sulfuric",-1,1.92,20,98.07,{"$f":"1000*((-2.0911*10^(-8)*($F$10^4))+(3.4312*10^(-6)*($F$10^3))+(-1.3954*10^(-4)*($F$10^2))+(9.0885*10^(-3)*$F$10)+0.9947)","v":1798.1339991039999},"(ml)","(tsp)","Addition        (mL/gal)","Sulfuric Acid Required =","Total Acid Addition (ml)",{"$f":"VLOOKUP(A52,strtable,3,FALSE)","v":0.52901775689439934},{"$f":"$B$12*0.2029","v":0.10733770287387362},"-",null,"-",null,"f3c=",{"$f":"(T40*T41)/T42","v":1.7227398933624626E-6}]
[6,"Citric",3.14,4.7699999999999996,6.39,192.13,1480,"(grams)","(kg)","Addition        (gram/gal)","Citric Acid Required =","Total Acid Addition (gram)",{"$f":"(mM_required*F50*N(B7)*J57)/1000","v":0.56151950830784247},{"$f":"$B$12/1000","v":5.2901775689439938E-4},"Citrate Added to Water =",189,"(ppm) Citrate added to water"]
[7,"Tartaric",2.98,4.34,20,150.09,1000,"(grams)","(kg)","Addition        (gram/gal)","Tartaric Acid Required =","Total Acid Addition (gram)",{"$f":"(mM_required*F50*N(B7)*J57)/1000","v":0.56151950830784247},{"$f":"$B$12/1000","v":5.2901775689439938E-4},"Tartarate Added to Water =",148,"(ppm) Tartarate added to water",null,"Acid Required=",{"$f":"T37*((T43-T25)+(T27-T45))+10^(-N(B6))-10^(-N(B5))+0.01","v":1.6100290990349571}]
[8,"Malic",3.4,5.2,20,134.09,1609,"(grams)","(kg)","Addition        (gram/gal)","Malic Acid Required =","Total Acid Addition (gram)",{"$f":"(mM_required*F50*N(B7)*J57)/1000","v":0.56151950830784247},{"$f":"$B$12/1000","v":5.2901775689439938E-4},"Malate Added to Water =",132,"(ppm) Malate added to water"]
[]
[null,{"$f":"VLOOKUP($A$40,table,2,FALSE)","v":"Lactic"},{"$f":"VLOOKUP($A$40,table,3,FALSE)","v":3.86},{"$f":"VLOOKUP($A$40,table,4,FALSE)","v":20},{"$f":"VLOOKUP($A$40,table,5,FALSE)","v":20},{"$f":"VLOOKUP($A$40,table,6,FALSE)","v":90.08},{"$f":"VLOOKUP($A$40,table,7,FALSE)","v":1206.1794562355199},{"$f":"VLOOKUP($A$40,table,8,FALSE)","v":"(ml)"},{"$f":"VLOOKUP($A$40,table,9,FALSE)","v":"(tsp)"},{"$f":"VLOOKUP($A$40,table,10,FALSE)","v":"Addition        (mL/gal)"},{"$f":"VLOOKUP($A$40,table,11,FALSE)","v":"Lactic Acid Required ="},{"$f":"VLOOKUP($A$40,table,12,FALSE)","v":"Total Acid Addition (ml)"},{"$f":"VLOOKUP($A$40,table,13,FALSE)","v":0.52901775689439934},{"$f":"VLOOKUP($A$40,table,14,FALSE)","v":0.10733770287387362},{"$f":"VLOOKUP($A$40,table,15,FALSE)","v":"Lactate Added to Water ="},{"$f":"VLOOKUP($A$40,table,16,FALSE)","v":89},{"$f":"VLOOKUP($A$40,table,17,FALSE)","v":"(ppm) Lactate added to water"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"mM_required*$F$50*N($B$7)*J57","v":561.51950830784244},"mg"]
[{"$f":"INDEX($A$53:$A$56, MATCH(C9,$B$53:$B$56,0))","v":1},null,null,"so4","cl"]
[1,"%",{"$f":"IF($A$40=9,(Acid_Required/3.657)*J57*N(B7),(((O51)/((N(F10)/100)*((VLOOKUP($A$40,table,7,FALSE)))))))","v":0.52901775689439934},{"$f":"IF($A$40=9,(C53*88.57)/($J$57*$B$7),mM_required*96)","v":158.1036225470296},{"$f":"IF($A$40=9,(C53*64)/($J$57*$B$7),mM_required*35.5)","v":58.465402087703659},null,null,1,"Gallons",3.7850000000000001,null,null,null,null,null,null,null,null,"r1d=",{"$f":"10^(N(B6)-C50)","v":43.651583224016633}]
[2,"N",{"$f":"IF($A$40=9,(Acid_Required/3.657)*J57*N(B7),(Acid_Required/F10)*(N(B7)*J57))","v":6.9249547043719453E-2},{"$f":"IF($A$40=9,(C54*88.57)/($J$57*$B$7),mM_required*96)","v":158.1036225470296},{"$f":"IF($A$40=9,(C54*64)/($J$57*$B$7),mM_required*35.5)","v":58.465402087703659},null,null,2,"Liters",1,null,null,null,null,null,null,null,null,"r2d=",{"$f":"10^(N(B6)-D50)","v":3.162277660168368E-15}]
[3,"M",{"$f":"IF($A$40=9,(Acid_Required/3.657)*J57*N(B7),(Acid_Required/F10)*(N(B7)*J57)/frac)","v":7.0835962516631976E-2},{"$f":"IF($A$40=9,(C55*88.57)/($J$57*$B$7),mM_required*96)","v":158.1036225470296},{"$f":"IF($A$40=9,(C55*64)/($J$57*$B$7),mM_required*35.5)","v":58.465402087703659},null,null,null,null,null,null,null,null,null,null,null,null,null,"r3d=",{"$f":"10^(N(B6)-E50)","v":3.162277660168368E-15}]
[4,"Solid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dd=",{"$f":"1/(1+T53+(T53*T54)+(T53*T54*T55))","v":2.2395622457170333E-2}]
[null,{"$f":"VLOOKUP($A$52,strtable,2,FALSE)","v":"%"},null,null,null,null,null,{"$f":"VLOOKUP('1. Water Report Input'!$H$7,sprgvaritable,1,FALSE)","v":1},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,sprgvaritable,2,FALSE)","v":"Gallons"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,sprgvaritable,3,FALSE)","v":3.7850000000000001},null,null,null,null,null,null,null,null,"f1d=",{"$f":"T56","v":2.2395622457170333E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f2d=",{"$f":"T56*T53","v":0.9776043775428267}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f3d=",{"$f":"T53*T54*T56","v":3.0914564835864837E-15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f4d=",{"$f":"T53*T54*T55*T56","v":9.7760437754281962E-30}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"frac=",{"$f":"T58+(2*T59)+(3*T60)","v":0.97760437754283291},"meq/mM"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mM required=",{"$f":"Acid_Required/frac","v":1.6469127348648918},"mM/L"]

{"sheet":"3. Grain Bill Input","index":3,"n_rows":35,"n_cols":24,"rows_kept":35,"cut":false,"hidden":false,"merged":[[28,0,28,5],[29,0,29,5],[22,0,22,5],[0,1,0,5],[25,2,25,5],[26,2,26,5],[25,1,27,1],[2,0,2,1],[2,2,2,5],[27,2,27,5],[19,2,19,4],[20,2,20,4],[3,0,3,5]]}
["Bru'n Water","Link to Bru'n Water website for updates and to donate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Base Malt"]
["Grain Bill Input ",null," Hover cursor over cells w/ red corner marks to display helpful information",null,null,null,null,null,null,null,null,null,null,null,null,2,"Crystal Malt"]
["Enter data into Light Blue cells, Yellow cells display calculated results, Pink cells contain selection boxes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Roast Malt"]
["Grains","Grain Type",{"$f":"O35","v":"Quantity (lb)"},{"$f":"P35","v":"Quantity (oz)"},{"$f":"IF(B20=\"Lovibond\",R28,R29)","v":"Color (L)"},"Percentage of         Grain Bill",null,null,null,null,1,2,3,4,null,4,"Acid Malt"]
["2 Row Pale Malt","Base Malt",19.850000000000001,0,1.75,{"$f":"100*(N(C6)+(N(D6)/$V$35))/$C$18","v":81.855670103092777},null,{"$f":"((N(C6)+(N(D6)/$V$35))*$U$35*IF(B$20=\"Lovibond\",N(E6),(0.375*N(E6))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":2.8947916666666669},{"$f":"HLOOKUP(N(J6),aciditytable,2,FALSE)","v":0.25697490092470282},{"$f":"INDEX($P$2:$P$5, MATCH(B6,$Q$2:$Q$5,0))","v":1},{"$f":"(N(C6)+(N(D6)/$V$35))*$U$35*((0.28*R6))/($N$35*'4. Water Adjustment'!$T$17)","v":0.25697490092470282},{"$f":"(N(C6)+(N(D6)/$V$35))*$U$35*((0.21*R6)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":1.5038276089828271},{"$f":"((N(C6)+(N(D6)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":19.92866578599736},{"$f":"((N(C6)+(N(D6)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":49.821664464993397},{"$f":"IF($J6=1,$I6,0)","v":0.25697490092470282},{"$f":"IF($J6=2,$I6,0)","v":0},{"$f":"IF($J6=3,$I6,0)","v":0},{"$f":"IF($B$20=\"lovibond\",N(E6),(0.375*N(E6))+0.561)","v":1.75}]
["Victory","Base Malt",2.2000000000000002,0,28,9.072164948453608,null,{"$f":"((N(C7)+(N(D7)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E7),(0.375*N(E7))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":5.1333333333333337},{"$f":"HLOOKUP(J7,aciditytable,3,FALSE)","v":0.45569352708058136},{"$f":"INDEX($P$2:$P$5, MATCH(B7,$Q$2:$Q$5,0))","v":1},{"$f":"(N(C7)+(N(D7)/$V$35))*$U$35*((0.28*R7))/($N$35*'4. Water Adjustment'!$T$17)","v":0.45569352708058136},{"$f":"(N(C7)+(N(D7)/$V$35))*$U$35*((0.21*R7)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":0.48708058124174369},{"$f":"((N(C7)+(N(D7)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":2.2087186261558784},{"$f":"((N(C7)+(N(D7)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":5.521796565389697},{"$f":"IF($J7=1,$I7,0)","v":0.45569352708058136},{"$f":"IF($J7=2,$I7,0)","v":0},{"$f":"IF($J7=3,$I7,0)","v":0},28]
["Crystal 40L","Crystal Malt",1.1000000000000001,0,40,4.536082474226804,null,{"$f":"((N(C8)+(N(D8)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E8),(0.375*N(E8))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":3.6666666666666665},{"$f":"HLOOKUP(J8,aciditytable,4,FALSE)","v":0.31677675033025104},2,{"$f":"(N(C8)+(N(D8)/$V$35))*$U$35*((0.28*R8))/($N$35*'4. Water Adjustment'!$T$17)","v":0.32549537648612947},{"$f":"(N(C8)+(N(D8)/$V$35))*$U$35*((0.21*R8)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":0.31677675033025104},{"$f":"((N(C8)+(N(D8)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":1.1043593130779392},{"$f":"((N(C8)+(N(D8)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":2.7608982826948485},0,0.31677675033025104,0,40]
["Flaked Wheat","Base Malt",1.1000000000000001,0,2,4.536082474226804,null,{"$f":"((N(C9)+(N(D9)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E9),(0.375*N(E9))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":0.18333333333333335},{"$f":"HLOOKUP(J9,aciditytable,5,FALSE)","v":1.6274768824306476E-2},1,{"$f":"(N(C9)+(N(D9)/$V$35))*$U$35*((0.28*R9))/($N$35*'4. Water Adjustment'!$T$17)","v":1.6274768824306476E-2},{"$f":"(N(C9)+(N(D9)/$V$35))*$U$35*((0.21*R9)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":8.4861294583883751E-2},{"$f":"((N(C9)+(N(D9)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":1.1043593130779392},{"$f":"((N(C9)+(N(D9)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":2.7608982826948485},1.6274768824306476E-2,0,0,2]
["Carafa","Roast Malt",0,0,400,0,null,{"$f":"((N(C10)+(N(D10)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E10),(0.375*N(E10))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":0},{"$f":"HLOOKUP(J10,aciditytable,6,FALSE)","v":0},3,{"$f":"(N(C10)+(N(D10)/$V$35))*$U$35*((0.28*R10))/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"(N(C10)+(N(D10)/$V$35))*$U$35*((0.21*R10)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C10)+(N(D10)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C10)+(N(D10)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":0},0,0,0,400]
["Chocolate","Roast Malt",0,0,300,0,null,{"$f":"((N(C11)+(N(D11)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E11),(0.375*N(E11))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":0},{"$f":"HLOOKUP(J11,aciditytable,7,FALSE)","v":0},3,{"$f":"(N(C11)+(N(D11)/$V$35))*$U$35*((0.28*R11))/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"(N(C11)+(N(D11)/$V$35))*$U$35*((0.21*R11)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C11)+(N(D11)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C11)+(N(D11)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":0},0,0,0,300]
[null,"Base Malt",0,0,0,0,null,{"$f":"((N(C12)+(N(D12)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E12),(0.375*N(E12))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":0},{"$f":"HLOOKUP(J12,aciditytable,8,FALSE)","v":0},1,{"$f":"(N(C12)+(N(D12)/$V$35))*$U$35*((0.28*R12))/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"(N(C12)+(N(D12)/$V$35))*$U$35*((0.21*R12)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C12)+(N(D12)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C12)+(N(D12)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":0},0,0,0,0]
[null,"Base Malt",0,0,0,0,null,{"$f":"((N(C13)+(N(D13)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E13),(0.375*N(E13))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":0},{"$f":"HLOOKUP(J13,aciditytable,9,FALSE)","v":0},1,{"$f":"(N(C13)+(N(D13)/$V$35))*$U$35*((0.28*R13))/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"(N(C13)+(N(D13)/$V$35))*$U$35*((0.21*R13)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C13)+(N(D13)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C13)+(N(D13)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":0},0,0,0,0]
[null,"Base Malt",0,0,0,0,null,{"$f":"((N(C14)+(N(D14)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E14),(0.375*N(E14))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":0},{"$f":"HLOOKUP(J14,aciditytable,10,FALSE)","v":0},1,{"$f":"(N(C14)+(N(D14)/$V$35))*$U$35*((0.28*R14))/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"(N(C14)+(N(D14)/$V$35))*$U$35*((0.21*R14)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C14)+(N(D14)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C14)+(N(D14)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":0},0,0,0,0]
[null,"Base Malt",0,0,0,0,null,{"$f":"((N(C15)+(N(D15)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E15),(0.375*N(E15))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":0},{"$f":"HLOOKUP(J15,aciditytable,11,FALSE)","v":0},1,{"$f":"(N(C15)+(N(D15)/$V$35))*$U$35*((0.28*R15))/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"(N(C15)+(N(D15)/$V$35))*$U$35*((0.21*R15)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C15)+(N(D15)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C15)+(N(D15)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":0},0,0,0,0]
["Enter grain names above to help ","Base Malt",0,0,0,0,null,{"$f":"((N(C16)+(N(D16)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E16),(0.375*N(E16))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":0},{"$f":"HLOOKUP(J16,aciditytable,12,FALSE)","v":0},1,{"$f":"(N(C16)+(N(D16)/$V$35))*$U$35*((0.28*R16))/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"(N(C16)+(N(D16)/$V$35))*$U$35*((0.21*R16)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C16)+(N(D16)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C16)+(N(D16)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":0},0,0,0,0]
["verify that all the grist is entered","Base Malt",0,0,0,0,null,{"$f":"((N(C17)+(N(D17)/$V$35))*$U$35*IF(B$20=\"lovibond\",N(E17),(0.375*N(E17))+0.561))/('4. Water Adjustment'!$V$17*$X$35)","v":0},{"$f":"HLOOKUP(J17,aciditytable,13,FALSE)","v":0},{"$f":"INDEX($P$2:$P$5, MATCH(B17,$Q$2:$Q$5,0))","v":1},{"$f":"(N(C17)+(N(D17)/$V$35))*$U$35*((0.28*R17))/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"(N(C17)+(N(D17)/$V$35))*$U$35*((0.21*R17)+2.5)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C17)+(N(D17)/$V$35))*$U$35*38)/($N$35*'4. Water Adjustment'!$T$17)","v":0},{"$f":"((N(C17)+(N(D17)/$V$35))*$U$35*1*95)/($N$35*'4. Water Adjustment'!$T$17)","v":0},0,0,0,0]
[null,{"$f":"Q35","v":"Total Grist Weight (lbs)"},{"$f":"SUM(C6:C17)+SUM(D6:D17)/$V$35","v":24.250000000000004},null,"Est. Beer Color (EBC)",{"$f":"1.97*F19","v":16.050409724384281},null,null,{"$f":"IF(SUM(H6:H17)>167,167,SUM(H6:H17))","v":11.878125000000001},null,null,null,null,null,{"$f":"SUM(O6:O17)","v":0.72894319682959063},{"$f":"SUM(P6:P17)","v":0.31677675033025104},{"$f":"SUM(Q6:Q17)","v":0}]
[null,{"$f":"T35","v":"Water to Grist Ratio (Qts/Lb)"},{"$f":"'4. Water Adjustment'!$T$17*$W$35/C18","v":1.6494845360824739},null,"Est. Beer Color (SRM)",{"$f":"1.49228*I18^0.6859","v":8.1474161037483661}]
["Malt Color Setting","Lovibond"]
["Water used for Mash","Adjusted Water",null,null,null,null,null,null,{"$f":"OR(J6=4,J7=4,J8=4,J9=4,J10=4,J11=4,J12=4,J13=4,J14=4,J15=4,J16=4,J17=4)","v":false},null,null,null,null,null,"Yes"]
[{"$f":"IF(B21=\"existing water\",\"Unadjusted Existing Water is selected\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["Mash pH Result"]
[null,null,null,null,"Estimated Room-Temperature Mash pH",{"$f":"IF(5.75-0.17*I26<0,0.1,5.75-0.17*I26)","v":5.3755025858001408},null,null,{"$f":"IF(B21=\"existing water\",O28,O29)","v":-1.1572060187216808},null,{"$f":"IF(OR($J6=4,$J7=4,$J8=4,$J9=4,$J10=4,$J11=4,$J12=4,$J13=4,$J14=4,$J15=4,$J16=4,$J17=4),93*(IF($J6=4,$N6,0)+IF($J7=4,$N7,0)+IF($J8=4,$N8,0)+IF($J9=4,$N9,0)+IF($J10=4,$N10,0)+IF($J11=4,$N11,0)+IF($J12=4,$N12,0)+IF($J13=4,$N13,0)+IF($J14=4,$N14,0)+IF($J15=4,$N15,0)+IF($J16=4,$N16,0)+IF($J17=4,$N17,0)),0)","v":0}]
[null,null,null,null,null,{"$f":"IF(F24<5.15,\"More Mash Water Alkalinity is Needed\",IF(F24>5.75,\"Less Mash Water Alkalinity is Needed\",\"\"))","v":""},null,null,{"$f":"SUM(I6:I17)","v":1.0457199471598417}]
[null,"Mash pH Guidance","Suggested mash pH range for lighter colored beers is 5.3 to 5.4",null,null,null,null,null,{"$f":"I25-I24","v":2.2029259658815228}]
[null,null,"Suggested mash pH range for darker colored beers is 5.4 to 5.6"]
["Bru'n Water v. 1.18",null,"Tart or crisp beer styles may benefit from a mash pH range of 5.2 to 5.3",null,null,null,null,null,null,null,null,null,1,"Existing Water",{"$f":"'4. Water Adjustment'!V8/50","v":1.2820237850597886},1,"Lovibond","Color (L)"]
["Copyright © 2016 Martin Brungard. All rights reserved. Reproduction in whole or in part in any form or medium without the express written permission of Martin Brungard, is prohibited.  Any transfer or exchange of this program via any method to anyone other than the original licensee is prohibited.  Transferring, exchanging, or posting images (screen shots) of the program and of the Raw Text Summary sheet is permitted for the purpose of conveying program results to other individuals.  The user of this program assumes all responsibility for the operation and results of the program. ",null,null,null,null,null,null,null,null,null,null,null,2,"Adjusted Water",{"$f":"'4. Water Adjustment'!U16/50","v":-1.1572060187216808},2,"EBC","Color (EBC)"]
["If the sheet does not show comments or red corner marks, select the REVIEW tab in the Excel program menu and click the SHOW ALL COMMENTS button twice."]
[null,null,null,null,null,null,null,null,null,null,null,1,"Gallons",3.7850000000000001,"Quantity (lb)","Quantity (oz)","Total Grist Weight (lbs)","Mash Water Volume (gallons)--->","Batch Water Volume (gallons) --->","Water to Grist Ratio (Qts/Lb)",1,16,4,1]
[null,null,null,null,null,null,null,null,null,null,null,2,"Liters",1,"Quantity (kg)","Quantity (g)","Total Grist Weight (kg)","Mash Water Volume (Liters)--->","Batch Water Volume (Liters)--->","Water to Grist Ratio (L/Kg)",2.2050000000000001,1000,1,0.26420080000000001]
[null,null,null,null,null,null,null,null,null,null,null,3,"Barrels",117.33499999999999,"Quantity (lb)","Quantity (oz)","Total Grist Weight (lbs)","Mash Water Volume (Barrels)--->","Batch Water Volume (Barrels)--->","Water to Grist Ratio (Qts/Lb)",1,16,124,31]
[null,null,null,null,null,null,null,null,null,null,null,4,"Hectoliters",100,"Quantity (kg)","Quantity (g)","Total Grist Weight (kg)","Mash Water Volume (Hectoliters)--->","Batch Water Volume (Hectoliters)--->","Water to Grist Ratio (L/Kg)",2.2050000000000001,1000,100,{"$f":"100/3.785","v":26.420079260237781}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,1,FALSE)","v":1},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,2,FALSE)","v":"Gallons"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,3,FALSE)","v":3.7850000000000001},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,4,FALSE)","v":"Quantity (lb)"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,5,FALSE)","v":"Quantity (oz)"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,6,FALSE)","v":"Total Grist Weight (lbs)"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,7,FALSE)","v":"Mash Water Volume (gallons)--->"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,8,FALSE)","v":"Batch Water Volume (gallons) --->"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,9,FALSE)","v":"Water to Grist Ratio (Qts/Lb)"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,10,FALSE)","v":1},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,11,FALSE)","v":16},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,12,FALSE)","v":4},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,mashvaritable,13,FALSE)","v":1}]

{"sheet":"4. Water Adjustment","index":4,"n_rows":109,"n_cols":36,"rows_kept":109,"cut":false,"hidden":false,"merged":[[0,0,0,1],[23,8,23,9],[14,8,14,11],[21,8,21,9],[20,10,20,11],[20,8,20,9],[6,0,6,1],[0,2,0,10],[3,8,3,10],[2,0,2,4],[2,5,2,12],[26,2,26,4],[26,10,26,11],[29,9,29,11],[11,0,11,1],[24,8,24,9],[18,10,18,11],[25,8,25,9],[25,10,25,11],[15,2,15,7],[3,0,3,1],[30,8,30,9],[27,7,27,10],[26,8,26,9],[14,15,15,15],[5,0,5,1],[28,8,28,9],[5,8,5,10],[6,8,6,10],[7,8,7,10],[23,10,23,11],[41,14,41,18],[32,13,32,15],[30,10,30,11],[15,8,15,9],[8,14,9,15],[10,15,11,15],[10,14,11,14],[10,0,10,1],[9,0,9,1],[12,0,12,1],[21,10,21,11],[15,10,15,11],[27,2,27,6],[22,8,22,9],[24,10,24,11],[22,10,22,11],[29,2,29,8],[33,0,33,11],[32,0,32,11],[50,14,50,18],[51,14,51,18],[52,14,52,18],[53,14,53,18],[54,14,54,18],[55,14,55,18],[44,14,44,18],[45,14,45,18],[46,14,46,18],[47,14,47,18],[48,14,48,18],[49,14,49,18],[42,14,42,18],[43,14,43,18],[36,14,36,18],[37,14,37,18],[38,14,38,18],[35,0,35,11],[34,0,34,11],[39,14,39,18],[34,13,34,15],[40,14,40,18],[62,14,62,18],[63,14,63,18],[64,14,64,18],[65,14,65,18],[66,14,66,18],[67,14,67,18],[56,14,56,18],[57,14,57,18],[58,14,58,18],[59,14,59,18],[60,14,60,18],[61,14,61,18],[85,14,85,18],[86,14,86,18],[93,14,93,18],[87,14,87,18],[108,14,108,18],[4,0,4,1],[7,0,7,1],[14,12,15,13],[17,8,17,9],[19,10,19,11],[19,8,19,9],[17,10,17,11],[14,14,15,14],[18,8,18,9],[28,10,28,11],[84,14,84,18],[68,14,68,18],[69,14,69,18],[74,14,74,18],[75,14,75,18],[80,14,80,18],[70,14,70,18],[76,14,76,18],[4,8,4,10],[71,14,71,18],[72,14,72,18],[73,14,73,18],[107,14,107,18],[77,14,77,18],[94,14,94,18],[95,14,95,18],[102,14,102,18],[96,14,96,18],[97,14,97,18],[98,14,98,18],[99,14,99,18],[100,14,100,18],[101,14,101,18],[78,14,78,18],[79,14,79,18],[88,14,88,18],[89,14,89,18],[90,14,90,18],[91,14,91,18],[92,14,92,18],[81,14,81,18],[82,14,82,18],[83,14,83,18]]}
["Bru'n Water",null,"Link to Bru'n Water website for updates and to donate"]
["Enter data into Light Blue cells, Yellow cells display calculated results, Pink cells contain selection boxes"]
["Water Profile Adjustment Calculator                           ",null,null,null,null,"Hover cursor over cells w/ red corner marks to display helpful information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hco3","so4","cl"]
["Desired Water Profile",null,"Calcium      (ppm)","Magnesium (ppm)","Sodium        (ppm)","Sulfate        (ppm)","Chloride      (ppm)","Bicarbonate (ppm)","Approximate Color Descriptors for Water Profiles",null,null,null,null,null,null,null,null,null,null,1,"%",{"$f":"IF(AF11=9,(N(B29)/V14)*(-182.85/0.8254),-(((N(B29)/V14)*(D29/100)*(((VLOOKUP(AF11,acidtable,7,FALSE))*V49*61)/(VLOOKUP(AF11,acidtable,6,FALSE))))))","v":-147.75812745653121},{"$f":"IF(AF11=9,(B29/V14)*(88.57),-V4*96/122)","v":116.26869045759832},{"$f":"IF(AF11=9,(B29/V14)*(64),-V4*35.5/61)","v":85.990385650932097}]
["Yellow Dry",null,{"$f":"VLOOKUP($AF$10,profiles,3,FALSE)","v":50},{"$f":"VLOOKUP($AF$10,profiles,4,FALSE)","v":10},{"$f":"VLOOKUP($AF$10,profiles,5,FALSE)","v":5},{"$f":"VLOOKUP($AF$10,profiles,6,FALSE)","v":105},{"$f":"VLOOKUP($AF$10,profiles,7,FALSE)","v":45},{"$f":"VLOOKUP($AF$10,profiles,8,FALSE)","v":0},"Yellow: under 6 SRM",null,null,null,null,null,null,null,null,null,null,2,"N",{"$f":"IF(AF11=9,(N(B29)/V14)*(-182.85/0.8254),-(N(B29)/V14)*N(D29)*61)","v":-1134.5838837516512},{"$f":"IF(AF11=9,(N(B29)/V14)*(88.57),-V5*96/122)","v":892.78731836195504},{"$f":"IF(AF11=9,(N(B29)/V14)*(64),-V5*35.5/61)","v":660.29062087186264}]
["Existing Water Profile",null,{"$f":"'1. Water Report Input'!$B$6","v":30.97},{"$f":"'1. Water Report Input'!$B$7","v":7.88},{"$f":"'1. Water Report Input'!$B$8","v":14.57},{"$f":"'1. Water Report Input'!$C$8","v":24.15},{"$f":"'1. Water Report Input'!$C$9","v":27},{"$f":"'1. Water Report Input'!$B$15*61/50","v":109.81666666666666},"Amber: 7 to 17 SRM",null,null,null,null,null,null,null,null,null,null,3,"M",{"$f":"IF(AF11=9,(N(B29)/V14)*(-182.85/0.8254),-(N(B29)/V14)*N(D29)*V49*61)","v":-1102.779379049872},{"$f":"IF(AF11=9,(N(B29)/V14)*(88.57),-V6*96/122)","v":867.76082285891573},{"$f":"IF(AF11=9,(N(B29)/V14)*(64),-V6*35.5/61)","v":641.78144190607304},null,null,null,{"$f":"IF(AND($AF$11>=6,$AF$11<=8),\"(gram/gal)\",\"(mL/gal)\")","v":"(mL/gal)"}]
["Dilution Water Profile",null,null,null,null,null,null,null,"Brown: 18 to 30 SRM",null,null,null,null,null,null,null,null,null,null,4,"Solid",{"$f":"IF(AF11=9,(N(B29)/V14)*(-182.85/0.8254),-((N(B29)*1000/V14)*61*V49)/Y35)","v":-139.11616177663691},{"$f":"IF(AF11=9,(N(B29)/V14)*(88.57),0)","v":0},{"$f":"IF(AF11=9,(N(B29)/V14)*(64),0)","v":0},null,null,null,{"$f":"IF(AND($AF$11>=6,$AF$11<=8),\"(gram/L)\",\"(mL/L)\")","v":"(mL/L)"}]
["RO Water",null,{"$f":"VLOOKUP($AG$10,dilution,3,FALSE)","v":1},{"$f":"VLOOKUP($AG$10,dilution,4,FALSE)","v":0},{"$f":"VLOOKUP($AG$10,dilution,5,FALSE)","v":8},{"$f":"VLOOKUP($AG$10,dilution,6,FALSE)","v":1},{"$f":"VLOOKUP($AG$10,dilution,7,FALSE)","v":4},{"$f":"VLOOKUP($AG$10,dilution,8,FALSE)","v":16},"Black: over 31 SRM",null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($AF$12,strengthtable,2,FALSE)","v":"%"},{"$f":"((H6*(50/61)*(1+(2*10^-2.33)))-(($C$6*0.7143)+($D$6*0.5879)))","v":64.101189252989428}]
["Percent Dilution Water",0,{"$f":"(N(B9)/100)*W14","v":0},{"$f":"X14","v":"oz/gal"},{"$f":"(N(B9)/100)*Y14","v":0},{"$f":"Z14","v":"pt/gal"},"< These conversions are provided for your convenience"]
["Diluted Water Profile",null,{"$f":"(C8*(N($B$9)/100)+(C6*(1-(N($B$9)/100))))","v":30.97},7.88,14.57,24.15,27,109.81666666666666,null,null,null,null,null,null,null,null,null,null,null,1,"Gallons",3.7850000000000001,128,"oz/gal",8,"pt/gal","Addition   (gram/gal)",{"$f":"AB6","v":"(mL/gal)"},"Water Volume   (gal)",null,null,{"$f":"INDEX($A$38:$A$103, MATCH($A$5,$B$38:$B$103,0))","v":52},{"$f":"INDEX($A$108:$A$109, MATCH($A$8,$B$108:$B$109,0))","v":2}]
["Target Finished Water Adjustment (ppm)",null,{"$f":"C5-C10","v":19.03},2.12,-9.57,80.849999999999994,18,-109.81666666666666,null,null,null,null,null,null,null,null,null,null,null,2,"Liters",1,1000,"mL/L",100,"L/HL","Addition   (gram/L)",{"$f":"AB7","v":"(mL/L)"},"Water Volume   (L)",null,null,{"$f":"INDEX($T$26:$T$34, MATCH($A$29,$U$26:$U$34,0))","v":3}]
["Actual Finished Water Adjustment (ppm)",2,{"$f":"AB41","v":0},{"$f":"AB42","v":0},{"$f":"AB43","v":0},{"$f":"AB44","v":0},{"$f":"AB45","v":0},{"$f":"AB46","v":-147.75812745653121},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($T$4:$T$7, MATCH($E$29,$U$4:$U$7,0))","v":1}]
["Mashing Water Profile",null,{"$f":"C10+AB41","v":30.97},{"$f":"D10+AB42","v":7.88},{"$f":"E10+AB43","v":14.57},{"$f":"F10+AB44","v":24.15},{"$f":"N(G10)+AB45","v":27},{"$f":"H10+AB46","v":-37.94146078986455}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('1. Water Report Input'!$H$7,watervaritable,1,FALSE)","v":1},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,watervaritable,2,FALSE)","v":"Gallons"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,watervaritable,3,FALSE)","v":3.7850000000000001},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,watervaritable,4,FALSE)","v":128},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,watervaritable,5,FALSE)","v":"oz/gal"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,watervaritable,6,FALSE)","v":8},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,watervaritable,7,FALSE)","v":"pt/gal"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,watervaritable,8,FALSE)","v":"Addition   (gram/gal)"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,watervaritable,9,FALSE)","v":"(mL/gal)"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,watervaritable,10,FALSE)","v":"Water Volume   (gal)"}]
[null,null,null,null,null,null,null,null,"Total Water Additions",null,null,null,"Total Batch Volume"]
["Estimated Mash pH",{"$f":"'3. Grain Bill Input'!F24","v":5.3755025858001408},"This pH value is NOT VALID until the grain information is properly entered for the beer on the Grain Bill Input sheet.  ",null,null,null,null,null,"Mash  ",null,"Sparge  ",null,null,null,null,null,null,null,null,null,{"$f":"V16-(($C$13*0.7143)+($D$13*0.5879))","v":-57.860300936084037},{"$f":"$H$13*(50/61)*(1+(2*10^-4))","v":-31.105777936084035}]
["Water Additions",null,null,null,null,null,null,null,{"$f":"AC14","v":"Water Volume   (gal)"},10,{"$f":"AC14","v":"Water Volume   (gal)"},4,{"$f":"AC14","v":"Water Volume   (gal)"},12,null,null,null,null,null,{"$f":"IF(N(J17)=0,0.00001,N(J17))","v":10},{"$f":"IF(N(L17)=0,0.00001,N(L17))","v":4},{"$f":"IF(N(N17)=0,0.00001,N(N17))","v":12},{"$f":"'3. Grain Bill Input'!I21","v":false}]
["Minerals ",{"$f":"AA14","v":"Addition   (gram/gal)"},"Calcium      (ppm)","Magnesium (ppm)","Sodium        (ppm)","Sulfate        (ppm)","Chloride      (ppm)","Bicarbonate (ppm)","Total Mineral Additions (grams)",null,"Total Mineral Additions (grams)"]
["Gypsum (CaSO4 x 2H2O) ",0,{"$f":"61.5*(3.785/V14)*N(B19)","v":0},null,null,{"$f":"147.43*(3.785/V14)*N(B19)","v":0},null,null,{"$f":"N(B19)*$T$17","v":0},null,{"$f":"N(B19)*U17","v":0}]
["Calcium Chloride (CaCl2) ",0,{"$f":"95.4*(3.785/V14)*N(B20)","v":0},null,null,null,{"$f":"168.79*(3.785/V14)*N(B20)","v":0},null,{"$f":"N(B20)*$T$17","v":0},null,{"$f":"N(B20)*U17","v":0}]
["Epsom Salt (MgSO4 x 7H2O)",0,null,{"$f":"26.05*(3.785/V14)*N(B21)","v":0},null,{"$f":"102.96*(3.785/V14)*N(B21)","v":0},null,null,{"$f":"N(B21)*$T$17","v":0},null,{"$f":"N(B21)*U$17","v":0},null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Magnesium Chloride (MgCl2 x 6H2O)",0,null,{"$f":"31.57*(3.785/V14)*N(B22)","v":0},null,null,{"$f":"92.12*(3.785/V14)*N(B22)","v":0},null,{"$f":"N(B22)*$T$17","v":0},null,{"$f":"N(B22)*U$17","v":0},null,null,null,null,null,null,null,null,null,null,null,"No"]
["Canning Salt (NaCl)",0,null,null,{"$f":"103.94*(3.785/V14)*N(B23)","v":0},null,{"$f":"160.26*(3.785/V14)*N(B23)","v":0},null,{"$f":"N(B23)*$T$17","v":0},null,{"$f":"N(B23)*U$17","v":0}]
["Baking Soda (NaHCO3)",0,null,null,{"$f":"72.31*(3.785/V14)*N(B24)","v":0},null,null,{"$f":"191.88*(3.785/V14)*N(B24)","v":0},{"$f":"N(B24)*T$17","v":0},null,"Not Recommended"]
["Chalk (CaCO3)",0,{"$f":"105.8*(3.785/V14)*N(B25)","v":0},null,null,null,null,{"$f":"322.27*(3.785/V14)*N(B25)","v":0},{"$f":"N(B25)*T$17","v":0},null,"Not Recommended",null,null,null,null,null,null,null,null,null,"acid","pK1","pK2","pK3","Mol. Wt.","SG","n","ml/mg","gm/tsp","dose"]
["Pickling Lime (Ca(OH)2)",0,{"$f":"142.93*(3.785/V14)*N(B26)","v":0},null,null,null,null,{"$f":"434.75*(3.785/V14)*N(B26)","v":0},{"$f":"N(B26)*T$17","v":0},null,"Not Recommended",null,null,null,null,null,null,null,null,1,"Acetic",4.75,20,20,60.05,{"$f":"1000*((-7.575*10^(-10)*($D$29^4))+(7.01*10^(-8)*($D$29^3))+(-9.254*10^(-6)*($D$29^2))+(1.575*10^(-3)*$D$29)+0.9979)","v":1067.18128768},1,"(ml)","(tsp)","Addition        (mL/gal)","Acetic Acid Required =","Total Acid Addition (ml)",{"$f":"VLOOKUP($AF$12,strengthtable,3,FALSE)","v":-147.75812745653121},null,"(ppm) Acetate added to water",59]
["Acids","Addition",null,null,null,"Sulfate        (ppm)","Chloride      (ppm)","Bicarbonate (ppm)",null,null,null,null,null,null,null,null,null,null,null,2,"Hydrochloric",-7,20,20,36.46,{"$f":"1000*((-3.1666*10^(-7)*($D$29^3))+(1.8499*10^(-5)*($D$29^2))+(4.7666*10^(-3)*$D$29)+0.998)","v":1344.9221324800001},1,"(ml)","(tsp)","Addition        (mL/gal)","Hydrochloric Acid Required =","Total Acid Addition (ml)",-147.75812745653121]
["Mash",{"$f":"AB14","v":"(mL/gal)"},"  Mash Acid Strength parameters are entered below",null,null,null,null,{"$f":"AF35","v":"Total Acid Addition (ml)"},null,null,null,null,null,null,null,null,null,null,null,3,"Lactic",3.86,20,20,90.08,{"$f":"1000*((-5.311*10^(-8)*($D$29^3))+(5.1587*10^(-6)*($D$29^2))+(2.32499*10^(-3)*$D$29)+0.9986)","v":1206.9551148799999},1,"(ml)","(tsp)","Addition        (mL/gal)","Lactic Acid Required =","Total Acid Addition (ml)",-147.75812745653121,null,"(ppm) Lactate added to water",89]
["Lactic",0.8,"Strength",88,"%",{"$f":"IF(AF11=9,W4,IF(AF11=5,VLOOKUP(AF$12,strengthtable,4,FALSE),0))","v":0},{"$f":"IF(AF11=9,X4,IF(AF11=2,VLOOKUP(AF$12,strengthtable,5,FALSE),0))","v":0},{"$f":"VLOOKUP($AF$12,strengthtable,3,FALSE)","v":-147.75812745653121},{"$f":"N(B29)*T$17","v":8},null,null,null,null,null,null,null,null,null,null,4,"Phosphoric",2.12,7.2,12.44,98,{"$f":"1000*((-8.333*10^(-10)*($D$29^4))+(2.6448*10^(-7)*($D$29^3))+(1.4442*10^(-5)*($D$29^2))+(5.4705*10^(-3)*$D$29)+0.9958)","v":1719.3059482112001},1,"(ml)","(tsp)","Addition        (mL/gal)","Phosphoric Acid Required =","Total Acid Addition (ml)",-147.75812745653121,null,"(ppm) Phosphate added to water",95]
["Sparge",null,"  Sparge Acid Strength parameters are entered on the Sparge Acidication sheet",null,null,null,null,null,null,{"$f":"'2. Sparge Acidification'!L50","v":"Total Acid Addition (ml)"},null,null,null,null,null,null,null,null,null,5,"Sulfuric",-1,1.92,20,98.07,{"$f":"1000*((-2.0911*10^(-8)*($D$29^4))+(3.4312*10^(-6)*($D$29^3))+(-1.3954*10^(-4)*($D$29^2))+(9.0885*10^(-3)*$D$29)+0.9947)","v":1798.1339991039999},2,"(ml)","(tsp)","Addition        (mL/gal)","Sulfuric Acid Required =","Total Acid Addition (ml)",-147.75812745653121]
[{"$f":"'2. Sparge Acidification'!B50","v":"Lactic"},null,"Strength",{"$f":"'2. Sparge Acidification'!B9","v":88},{"$f":"'2. Sparge Acidification'!B57","v":"%"},{"$f":"'2. Sparge Acidification'!F15","v":0},{"$f":"'2. Sparge Acidification'!F16","v":0},null,null,null,{"$f":"IF('2. Sparge Acidification'!B$7=1,'4. Water Adjustment'!U$17*'2. Sparge Acidification'!B$12,'2. Sparge Acidification'!B$12)","v":2.1160710275775974},null,null,null,null,null,null,null,null,6,"Citric",3.14,4.7699999999999996,6.39,192.13,1480,1,"(grams)","(kg)","Addition        (gram/gal)","Citric Acid Required =","Total Acid Addition (gram)",-147.75812745653121,null,"(ppm) Citrate added to water",189]
["Bru'n Water v 1.18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Tartaric",2.98,4.34,20,150.09,1000,1,"(grams)","(kg)","Addition        (gram/gal)","Tartaric Acid Required =","Total Acid Addition (gram)",-147.75812745653121,null,"(ppm) Tartarate added to water",148]
["Most mineral additions should be added to both the mash water and sparge water.  DO NOT add alkalinity producing minerals such as chalk, baking soda, or pickling lime to sparge water since that counteracts the desired sparge water acidification.  Either reserve those minerals from the sparge water and add directly to the kettle, or delete them and substitute other calcium or sodium containing minerals to make up for their contributions.  Do not use the acid amount calculated for Mash Adjustment from this sheet for the Sparge Water adjustment.  Use the acid amount calculated on the Sparge Acidification sheet for Sparge Water.  For best result, add acids prior to heating the water since heating can drive off a portion of the alkalinity that the acid addition was calculated to remove.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Malic",3.4,5.2,20,134.09,1609,1,"(grams)","(kg)","Addition        (gram/gal)","Malic Acid Required =","Total Acid Addition (gram)",-147.75812745653121,null,"(ppm) Malate added to water",132]
["Copyright © 2016 Martin Brungard. All rights reserved. Reproduction in whole or in part in any form or medium without the express written permission of Martin Brungard, is prohibited.  Any transfer or exchange of this program via any method to anyone other than the original licensee is prohibited.  Transferring, exchanging, or posting images (screen shots) of the program and of the Raw Text Summary sheet is permitted for the purpose of conveying program results to other individuals.  The user of this program assumes all responsibility for the operation and results of the program. "]
["Input Custom Water Profiles at the bottom of the Table below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($AF$11,acidtable,1,FALSE)","v":3},{"$f":"VLOOKUP($AF$11,acidtable,2,FALSE)","v":"Lactic"},{"$f":"VLOOKUP($AF$11,acidtable,3,FALSE)","v":3.86},{"$f":"VLOOKUP($AF$11,acidtable,4,FALSE)","v":20},{"$f":"VLOOKUP($AF$11,acidtable,5,FALSE)","v":20},{"$f":"VLOOKUP($AF$11,acidtable,6,FALSE)","v":90.08},{"$f":"VLOOKUP($AF$11,acidtable,7,FALSE)","v":1206.9551148799999},{"$f":"VLOOKUP($AF$11,acidtable,8,FALSE)","v":1},{"$f":"VLOOKUP($AF$11,acidtable,9,FALSE)","v":"(ml)"},{"$f":"VLOOKUP($AF$11,acidtable,10,FALSE)","v":"(tsp)"},{"$f":"VLOOKUP($AF$11,acidtable,11,FALSE)","v":"Addition        (mL/gal)"},{"$f":"VLOOKUP($AF$11,acidtable,12,FALSE)","v":"Lactic Acid Required ="},{"$f":"VLOOKUP($AF$11,acidtable,13,FALSE)","v":"Total Acid Addition (ml)"},{"$f":"VLOOKUP($AF$11,acidtable,14,FALSE)","v":-147.75812745653121},{"$f":"VLOOKUP($AF$11,acidtable,15,FALSE)","v":0},{"$f":"VLOOKUP($AF$11,acidtable,16,FALSE)","v":"(ppm) Lactate added to water"},{"$f":"VLOOKUP($AF$11,acidtable,17,FALSE)","v":89}]
["All Water Profiles are User customizable "]
[null,"Water Profile","Calcium      (ppm)","Magnesium (ppm)","Sodium        (ppm)","Sulfate        (ppm)","Chloride      (ppm)","Bicarbonate (ppm)","Cations (meq/L)","Anions (meq/L)","Total Hardness","Alkalinity","RA","SO4/Cl Ratio","Comments"]
[1,"Burton",275,40,25,610,35,270,{"$f":"(C38/20.05)+(D38/12.15)+(E38/23)","v":18.094848314889997},{"$f":"(H38/61)+(F38/48)+(G38/35.45)","v":18.121868906410167},{"$f":"((C38/20)+(D38/12.15))*50","v":852.10905349794234},{"$f":"H38*(50/61)*(1+(2*10^-4))","v":221.35573770491803},{"$f":"(L38-((C38*0.7143)+(D38*0.5879)))","v":1.4072377049180318},{"$f":"IF(G38<=0,0,F38/G38)","v":17.428571428571427},"from UK Env Agency records"]
[2,"Dortmund",230,15,40,330,130,235,14.445020031777775,14.39459582880529,{"$f":"((C39/20)+(D39/12.15))*50","v":636.72839506172841},192.66147540983604,{"$f":"(L39-((C39*0.7143)+(D39*0.5879)))","v":19.553975409836028},2.5384615384615383]
[3,"Dublin",120,4,12,55,19,315,6.8359946439144572,6.845733909069188,{"$f":"((C40/20)+(D40/12.15))*50","v":316.46090534979425},258.24836065573771,{"$f":"(L40-((C40*0.7143)+(D40*0.5879)))","v":170.18076065573769},2.8947368421052633,"from north and west Dublin",null,null,null,null,null,null,5.4]
[4,"Dublin (boiled)",43,4,12,55,19,80,2.9955956414206923,2.9932748926757458,{"$f":"((C41/20)+(D41/12.15))*50","v":123.96090534979423},65.586885245901641,{"$f":"(L41-((C41*0.7143)+(D41*0.5879)))","v":32.520385245901636},2.8947368421052633,"resulting profile after boiling and decanting",null,null,null,null,null,"r1d=",{"$f":"10^(V40-V35)","v":34.673685045253208},{"$f":"(N($I$19)+N($K$19))/($T$17+$U$17)*61.5*3.785/$V$14","v":0},{"$f":"(N($I$19)+N($K$19))/($T$17+$U$17)*147.43*3.785/$V$14","v":0},{"$f":"W41+W45+W46+W47","v":0},{"$f":"(N($I$19))/($T$17)*61.5*3.785/$V$14","v":0},{"$f":"(N($I$19))/($T$17)*147.43*3.785/$V$14","v":0},{"$f":"Z41+Z45+Z46+Z47","v":0},"ca",null,null,"r1d=",{"$f":"10^(V40-AP34)","v":251188.64315095844}]
[5,"Edinburgh",100,20,55,140,50,285,9.0249260548753369,8.9992350497506681,332.30452674897117,233.65327868852461,150.46527868852462,2.8,"from Edinburgh water company",null,null,null,null,null,"r2d=",{"$f":"10^(V40-W35)","v":2.5118864315095734E-15},{"$f":"(N($I$21)+N($K$21))/($T$17+$U$17)*26.05*3.785/$V$14","v":0},{"$f":"(N($I$21)+N($K$21))/($T$17+$U$17)*102.96*3.785/$V$14","v":0},{"$f":"W42+W48","v":0},{"$f":"(N($I$21))/($T$17)*26.05*3.785/$V$14","v":0},{"$f":"(N($I$21))/($T$17)*102.96*3.785/$V$14","v":0},{"$f":"Z42+Z48","v":0},"mg",null,null,"r2d=",{"$f":"10^(V40-AQ34)","v":251188.64315095844}]
[6,"Edinburgh (boiled)",33,20,55,140,50,80,5.6832801695885529,5.6385793120457501,164.8045267489712,65.586885245901641,30.256985245901639,2.8,"resulting profile after boiling and decanting",null,null,null,null,null,"r3d=",{"$f":"10^(V40-X35)","v":2.5118864315095734E-15},{"$f":"(N($I$23)+N($K$23))/($T$17+$U$17)*103.94*3.785/$V$14","v":0},{"$f":"(N($I$23)+N($K$23))/($T$17+$U$17)*160.26*3.785/$V$14","v":0},{"$f":"W43+W44","v":0},{"$f":"(N($I$23))/($T$17)*103.94*3.785/$V$14","v":0},{"$f":"(N($I$23))/($T$17)*160.26*3.785/$V$14","v":0},{"$f":"Z43+Z44","v":0},"na",null,null,"r3d=",{"$f":"10^(V40-AR34)","v":251188.64315095844}]
[7,"London",70,6,15,40,38,166,4.6372728939861831,4.6265771077558631,199.69135802469137,136.09278688524589,82.564386885245881,1.0526315789473684,"compilation of London water company reports",null,null,null,null,null,"dd=",{"$f":"1/(1+V41+(V41*V42)+(V41*V42*V43))","v":2.8031867151696432E-2},{"$f":"(N($I$26))/($T$17+$U$17)*72.31*3.785/$V$14","v":0},{"$f":"(N($I$26))/($T$17+$U$17)*191.88*3.785/$V$14","v":0},{"$f":"((((X41+X42+$F$29)*V14*T17)+(('2. Sparge Acidification'!B13)*V14*U17))/((T17+U17)*V14))","v":0},{"$f":"(N($I$24))/($T$17)*72.31*3.785/$V$14","v":0},{"$f":"(N($I$24))/($T$17)*191.88*3.785/$V$14","v":0},{"$f":"(AA41+AA42+$F$29)","v":0},"so4",null,null,"dd=",{"$f":"1/(1+AG41+(AG41*AG42)+(AG41*AG42*AG43))","v":6.3095483259375853E-17}]
[8,"London (boiled)",42,6,15,40,38,80,3.240764165806632,3.2167410421820923,129.69135802469137,65.586885245901641,32.058885245901635,1.0526315789473684,"resulting profile after boiling and decanting",null,null,null,null,null,"f1d=",{"$f":"V44","v":2.8031867151696432E-2},{"$f":"((N($I$20)+N($K$20))/($T$17+$U$17))*95.4*(3.785/$V$14)","v":0},{"$f":"((N($I$20)+N($K$20))/($T$17+$U$17))*168.79*(3.785/$V$14)","v":0},{"$f":"((((X43+X45+X48+$G$29)*V14*T17)+(('2. Sparge Acidification'!B14)*V14*U17))/((T17+U17)*V14))","v":0},{"$f":"(N($I$20)/($T$17))*95.4*(3.785/$V$14)","v":0},{"$f":"((N($I$20))/($T$17))*168.79*(3.785/$V$14)","v":0},{"$f":"(AA43+AA45+AA48+$G$29)","v":0},"cl",null,null,"f1d=",{"$f":"AG44","v":6.3095483259375853E-17}]
[9,"Munich",77,17,4,18,8,295,5.4134890007045362,5.4367355314573746,262.4588477366255,241.85163934426228,176.85623934426229,2.25,"from Munich water company",null,null,null,null,null,"f2d=",{"$f":"V44*V41","v":0.97196813284830119},{"$f":"(N($I$24))/($T$17+$U$17)*105.8*3.785/$V$14","v":0},{"$f":"(N($I$24))/($T$17+$U$17)*322.27*3.785/$V$14","v":0},{"$f":"X44+X46+X47","v":0},{"$f":"(N($I$25))/($T$17)*105.8*3.785/$V$14","v":0},{"$f":"(N($I$25))/($T$17)*322.27*3.785/$V$14","v":0},{"$f":"AA44+AA46+AA47+$H$29","v":-147.75812745653121},"hco3",null,null,"f2d=",{"$f":"AG44*AG41","v":1.5848868828876631E-11}]
[10,"Munich (boiled)",12,17,4,18,8,100,2.17159373885915,2.240014219981965,99.958847736625515,81.983606557377058,63.417706557377059,2.25,"resulting profile after boiling and decanting",null,null,null,null,null,"f3d=",{"$f":"V41*V42*V44","v":2.4414735647613423E-15},{"$f":"(N($I$25))/($T$17+$U$17)*142.93*3.785/$V$14","v":0},{"$f":"(N($I$25))/($T$17+$U$17)*434.75*3.785/$V$14","v":0},null,{"$f":"(N($I$26))/($T$17)*142.93*3.785/$V$14","v":0},{"$f":"(N($I$26))/($T$17)*434.75*3.785/$V$14","v":0},null,null,null,null,"f3d=",{"$f":"AG41*AG42*AG44","v":3.9810558566030416E-6}]
[11,"Pilsen",7,2,2,8,6,16,0.60069275728196048,0.59821421689904197,25.730452674897119,13.117377049180329,6.9414770491803282,1.3333333333333333,"from Pilsen water company",null,null,null,null,null,"f4d=",{"$f":"V41*V42*V43*V44","v":6.1327043202133262E-30},{"$f":"(N($I$22)+N($K$22))/($T$17+$U$17)*31.57*3.785/$V$14","v":0},{"$f":"(N($I$22)+N($K$22))/($T$17+$U$17)*92.12*3.785/$V$14","v":0},null,{"$f":"(N($I$22))/($T$17)*31.57*3.785/$V$14","v":0},{"$f":"(N($I$22))/($T$17)*92.12*3.785/$V$14","v":0},null,null,null,null,"f4d=",{"$f":"AG41*AG42*AG43*AG44","v":0.99999601892829448}]
[12,"Vienna",75,15,10,60,15,225,5.4099988889825887,5.3616557608268405,249.22839506172841,184.46311475409834,122.07211475409834,4,"from Vienna water company",null,null,null,null,null,"frac=",{"$f":"V46+(2*V47)+(3*V48)","v":0.97196813284830608},null,null,null,null,null,null,null,null,null,"frac=",{"$f":"AG46+(2*AG47)+(3*AG48)","v":2.9999960189124457}]
[13,"Vienna (boiled)",27,15,10,60,15,80,3.0159839263890733,2.9846065804989705,129.22839506172838,65.586885245901641,37.482285245901636,4,"resulting profile after boiling and decanting"]
[14,"Dusseldorf",40,15,25,80,45,81,4.3165368918016283,4.2639290311143991,161.72839506172841,66.406721311475408,29.016221311475405,1.7777777777777777,"from Dusseldorf water company"]
[15,"Dusseldorf (boiled)",39,15,25,80,45,80,4.26666158008093,4.2475355884914485,159.22839506172838,65.586885245901641,28.910685245901639,1.7777777777777777,"resulting profile after boiling and decanting"]
[16,"Beerse",73,13,52,125,80,128,6.9717261685649881,6.9592268992732009,235.99794238683128,104.93901639344263,45.152416393442628,1.5625]
[17,"Beerse (boiled)",57,13,52,125,80,80,6.1737211810338168,6.1723416533715607,195.99794238683128,65.586885245901641,17.229085245901643,1.5625,"resulting profile after boiling and decanting"]
[18,"Brugse",132,13,20,99,38,326,8.5230652122600983,8.4786945940946605,383.49794238683126,267.26655737704914,165.33625737704912,2.6052631578947367]
[19,"Brugse (boiled)",51,13,20,99,38,80,4.4831649628835413,4.4459077088487593,180.99794238683126,65.586885245901641,21.514885245901638,2.6052631578947367,"resulting profile after boiling and decanting"]
[20,"Brussels",100,11,18,70,41,250,6.6754896619606825,6.7132525222163126,295.26748971193416,204.95901639344262,127.06211639344262,1.7073170731707317]
[21,"Brussels (boiled)",44,11,18,70,41,80,3.8824722056015801,3.9263672763146737,155.26748971193416,65.586885245901641,27.690785245901637,1.7073170731707317,"resulting profile after boiling and decanting"]
[22,"Hoegaarden",90,11,16,82,53,171,6.0897800230145691,6.0066754915335228,270.26748971193416,140.19196721311474,69.438067213114735,1.5471698113207548]
[23,"Hoegaarden (boiled)",60,11,16,82,53,80,4.5935206713936214,4.5148722128449981,195.26748971193416,65.586885245901641,16.261985245901634,1.5471698113207548,"resulting profile after boiling and decanting"]
[24,"Willebroek",68,8,33,70,60,143,5.484740019694903,5.4951203110669224,202.92181069958849,117.23655737704918,63.960957377049176,1.1666666666666667]
[25,"Willebroek (boiled)",48,8,33,70,60,80,4.4872337852809379,4.4623334258210203,152.92181069958849,65.586885245901641,26.597285245901638,1.1666666666666667,"resulting profile after boiling and decanting"]
[26,"Antwerpen/Anvers",65,7,16,48,30,159,4.5136791230012285,4.4528197183749914,191.30658436213992,130.35393442622953,79.809134426229519,1.6]
[27,"Antwerpen/Anvers (boiled)",39,7,16,48,30,80,3.2169210182630734,3.1577377511618763,126.3065843621399,65.586885245901641,33.613885245901642,1.6,"resulting profile after boiling and decanting"]
[28,"Brabant",111,12,14,74,40,270,7.1325095741590738,7.096245963297803,326.88271604938268,221.35573770491803,135.01363770491804,1.85]
[29,"Brabant (boiled)",49,12,14,74,40,80,4.0402402474757819,3.9814918649371469,171.88271604938274,65.586885245901641,23.531385245901639,1.85,"resulting profile after boiling and decanting"]
[30,"Henegouwen/Hainaut",113,17,15,65,41,315,7.6872610922148912,7.6746596260414499,352.45884773662556,258.24836065573771,167.53816065573773,1.5853658536585367]
[31,"Henegouwen/Hainaut (boiled)",36,17,15,65,41,80,3.8468620897211254,3.8222006096480072,159.95884773662553,65.586885245901641,29.877785245901642,1.5853658536585367,"resulting profile after boiling and decanting"]
[32,"Achouffe",29,4,12,12,35,70,2.2973412773309168,2.38484704848667,88.960905349794245,57.388524590163939,34.322224590163941,0.34285714285714286]
[33,"Orval",96,4,5,25,13,270,5.3346393365307438,5.3137765227712395,256.46090534979425,221.35573770491803,150.43133770491801,1.9230769230769231]
[34,"Orval (boiled)",34,4,5,25,13,80,2.2423700098474515,2.1990224244105834,101.46090534979425,65.586885245901641,38.949085245901642,1.9230769230769231,"resulting profile after boiling and decanting"]
[35,"Rochefort",82,10,6,32,17,245,5.1736903938043604,5.162608769374244,246.15226337448556,200.85983606557377,136.40823606557376,1.8823529411764706]
[36,"Rochefort (boiled)",28,10,6,32,17,80,2.4804235608866541,2.4576907365873586,111.1522633744856,65.586885245901641,39.707485245901637,1.8823529411764706,"resulting profile after boiling and decanting"]
[37,"Chimay",70,7,7,21,21,205,4.3717513337786329,4.3905393766329857,203.80658436213989,168.06639344262297,113.95009344262297,1]
[38,"Chimay (boiled)",29,7,7,21,21,80,2.3268635532300039,2.3413590487641329,101.3065843621399,65.586885245901641,40.756885245901643,1,"resulting profile after boiling and decanting"]
[39,"Luik/Liege",60,15,11,28,24,210,4.7053474740416803,4.7029661572136536,211.72839506172841,172.16557377049182,120.48907377049181,1.1666666666666667]
[40,"Luik/Liege (boiled)",18,15,11,28,24,80,2.6105843817723535,2.5718186162300474,106.72839506172839,65.586885245901641,43.910985245901642,1.1666666666666667,"resulting profile after boiling and decanting"]
[41,"East Flanders",134,22,52,76,47,475,10.754860924268323,10.69602958064541,425.53497942386838,389.42213114754099,280.77213114754102,1.6170212765957446]
[42,"East Flanders (boiled)",4,22,52,76,47,80,4.2710704005775497,4.2206197445798361,100.53497942386831,65.586885245901641,49.795885245901644,1.6170212765957446,"resulting profile after boiling and decanting"]
[43,"West Flanders",114,10,125,145,139,305,11.943613412344964,11.941848848142925,326.15226337448559,250.04999999999998,162.74079999999998,1.0431654676258992]
[44,"West Flanders (boiled)",40,10,125,145,139,80,8.2528403450132934,8.2533242579789903,141.15226337448559,65.586885245901641,31.13588524590164,1.0431654676258992,"resulting profile after boiling and decanting"]
[45,"Ardennes",60,13,11,25,24,200,4.5407384205437387,4.4765317309841466,203.49794238683128,163.96721311475412,113.46651311475412,1.0416666666666667]
[46,"Ardennes (boiled)",20,13,11,25,24,80,2.545725951715808,2.5093186162300474,103.49794238683128,65.586885245901641,43.658185245901642,1.0416666666666667,"resulting profile after boiling and decanting"]
[47,"Pale Ale Profile",140,18,25,300,55,110,9.5509816441183677,9.6047596476219113,424.07407407407402,90.18196721311476,-20.40223278688525,5.4545454545454541,"for hoppy beers"]
[48,"Mild Ale Profile",50,0,20,40,65,45,3.363330803426217,3.4046066575720442,125,36.892622950819671,1.1776229508196678,0.61538461538461542,"for malty English ales"]
[49,"American Lager",13,6,8,37,13,20,1.4900322998194262,1.4654158670335344,57.191358024691354,16.39672131147541,3.5834213114754103,2.8461538461538463,"from an American megabrewery"]
[50,"Yellow Full",50,5,5,55,70,0,3.1226795241275949,3.1204454630935587,145.57613168724279,0,-38.654500000000006,0.7857142857142857]
[51,"Yellow Balanced",50,7,5,75,60,0,3.2872885776255374,3.255024682651622,153.80658436213992,0,-39.830300000000001,1.25]
[52,"Yellow Dry",50,10,5,105,45,0,3.5342021578724507,3.4568935119887163,166.15226337448559,0,-41.594000000000001,2.3333333333333335]
[53,"Amber Full",50,5,15,55,65,35,3.5574621328232467,3.5531722313425353,145.57613168724279,28.69426229508197,-9.9602377049180362,0.84615384615384615]
[54,"Amber Balanced",50,10,15,75,63,40,3.9689847665681031,3.9953886217022356,166.15226337448559,32.79344262295082,-8.8005573770491807,1.1904761904761905]
[55,"Amber Dry",50,15,15,110,50,45,4.3805074003129594,4.4398088202424715,186.72839506172841,36.892622950819671,-7.6408770491803324,2.2000000000000002]
[56,"Brown Full",50,5,27,50,60,85,4.0792012632580299,4.1276339722691082,145.57613168724279,69.686065573770492,31.031565573770486,0.83333333333333337]
[57,"Brown Balanced",50,10,27,70,55,90,4.4907238970028853,4.4852241284962275,166.15226337448559,73.785245901639342,32.191245901639341,1.2727272727272727]
[58,"Brown Dry",50,15,27,99,45,95,4.9022465307477416,4.8892705611690443,186.72839506172841,77.884426229508193,33.35092622950819,2.2000000000000002]
[59,"Black Full",50,5,33,35,45,140,4.3400708284754206,4.2936421458684979,145.57613168724279,114.77704918032788,76.122549180327866,0.77777777777777779]
[60,"Black Balanced",50,10,33,57,44,142,4.7515934622202769,4.7565536197368719,166.15226337448559,116.41672131147541,74.822721311475419,1.2954545454545454]
[61,"Black Dry",50,15,33,84,39,145,5.1631160959651332,5.2271902240514239,186.72839506172841,118.87622950819672,74.342729508196712,2.1538461538461537]
[62,"PseudoBohPils",20,0,8,15,35,0,1.3453323213704866,1.2998060648801126,{"$f":"((C99/20)+(D99/12.15))*50","v":50},0,{"$f":"(L99-((C99*0.7143)+(D99*0.5879)))","v":-14.286000000000001},{"$f":"IF(G99<=0,0,F99/G99)","v":0.42857142857142855},"keeps Ca, Cl, and SO4 low"]
[63,"Jever (boiled)",46,5,15,75,30,60,3.3579608859404537,3.3923688987028604,{"$f":"((C100/20)+(D100/12.15))*50","v":135.57613168724279},49.190163934426231,{"$f":"(L100-((C100*0.7143)+(D100*0.5879)))","v":13.392863934426224},{"$f":"IF(G100<=0,0,F100/G100)","v":2.5},"from Jever, Germany water company, after boiling"]
[64,"Wicklow Mtn",18,2,13,22,20,35,1.6275820557748588,1.596278719353819,{"$f":"((C101/20)+(D101/12.15))*50","v":53.230452674897123},28.69426229508197,{"$f":"(L101-((C101*0.7143)+(D101*0.5879)))","v":14.661062295081969},{"$f":"IF(G101<=0,0,F101/G101)","v":1.1000000000000001},"Dublin water source used by Guinness"]
[65,"User Custom",0,0,0,0,0,0,{"$f":"(C102/20.05)+(D102/12.15)+(E102/23)","v":0},{"$f":"(H102/61)+(F102/48)+(G102/35.45)","v":0},{"$f":"((C102/20)+(D102/12.15))*50","v":0},{"$f":"H102*(50/61)*(1+(2*10^-4))","v":0},{"$f":"(L102-((C102*0.7143)+(D102*0.5879)))","v":0},{"$f":"IF(G102<=0,0,F102/G102)","v":0}]
[66,"Burton (boiled)",255,40,25,610,35,210,{"$f":"(C103/20.05)+(D103/12.15)+(E103/23)","v":17.097342080476032},{"$f":"(H103/61)+(F103/48)+(G103/35.45)","v":17.138262349033116},{"$f":"((C103/20)+(D103/12.15))*50","v":802.10905349794234},{"$f":"H103*(50/61)*(1+(2*10^-4))","v":172.16557377049182},{"$f":"(L103-((C103*0.7143)+(D103*0.5879)))","v":-33.496926229508176},{"$f":"IF(G103<=0,0,F103/G103)","v":17.428571428571427},"resulting profile after boiling and decanting"]
[null,"When inputing Custom water profiles, make sure the cation and anion columns are green indicating that they are balanced.  Adjust the various ion concentrations to achieve balance."]
[]
[null,"Dilution Water Profiles"]
[null,"Water Profile","Calcium      (ppm)","Magnesium (ppm)","Sodium        (ppm)","Sulfate        (ppm)","Chloride      (ppm)","Bicarbonate (ppm)","Cations (meq/L)","Anions (meq/L)","Total Hardness","Alkalinity","RA","SO4/Cl Ratio"]
[1,"Distilled Water",0,0,0,0,0,0,{"$f":"(C108/20.05)+(D108/12.15)+(E108/23)","v":0},{"$f":"(H108/61)+(F108/48)+(G108/35.45)","v":0},{"$f":"((C108/20)+(D108/12.15))*50","v":0},{"$f":"H108*(50/61)*(1+(2*10^-4))","v":0},{"$f":"(L108-((C108*0.7143)+(D108*0.5879)))","v":0},{"$f":"IF(F108<=0,0,F108/G108)","v":0}]
[2,"RO Water",1,0,8,1,4,16,{"$f":"(C109/20.05)+(D109/12.15)+(E109/23)","v":0.39770139867721999},{"$f":"(H109/61)+(F109/48)+(G109/35.45)","v":0.3959633941439879},{"$f":"((C109/20)+(D109/12.15))*50","v":2.5},{"$f":"H109*(50/61)*(1+(2*10^-4))","v":13.117377049180329},{"$f":"(L109-((C109*0.7143)+(D109*0.5879)))","v":12.403077049180329},{"$f":"IF(F109<=0,0,F109/G109)","v":0.25}]

{"sheet":"5. Adjustment Summary","index":5,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,0,28,8],[16,0,16,2],[14,3,14,5],[23,0,23,2],[25,6,25,8],[24,0,24,2],[24,6,24,8],[24,3,24,5],[17,6,17,8],[23,3,23,5],[9,0,9,1],[12,0,14,2],[22,3,22,5],[22,6,22,8],[23,6,23,8],[10,3,10,4],[15,3,15,5],[12,3,12,4],[13,6,13,7],[14,6,14,8],[12,6,12,7],[19,6,19,8],[18,6,18,8],[19,3,19,5],[17,0,17,1],[17,3,17,5],[0,3,0,8],[0,0,0,2],[1,0,1,1],[1,2,1,8],[2,0,2,3],[2,4,2,8],[10,0,10,1],[13,3,13,4],[4,0,4,2],[19,0,19,2],[5,0,5,2],[8,0,8,2],[9,6,9,7],[6,0,6,2],[26,3,26,5],[10,6,10,7],[16,3,16,5],[18,3,18,5],[9,3,9,4],[15,0,15,2],[18,0,18,2],[21,6,21,8],[21,3,21,5],[20,0,20,2],[21,0,21,2],[22,0,22,2],[15,6,15,8],[16,6,16,8]]}
["Bru'n Water ",null,null,"Link to Bru'n Water website for updates and to donate"]
[]
["Water Adjustment Summary",null,null,null," Hover cursor over cells w/ red corner marks to display helpful information"]
[{"$f":"'4. Water Adjustment'!$A$5","v":"Yellow Dry"},null,null,"Calcium (ppm)","Magnesium (ppm)","Sodium (ppm)","Sulfate (ppm)","Chloride (ppm)","Bicarbonate (ppm)"]
["Existing Water Profile",null,null,{"$f":"'4. Water Adjustment'!C6","v":30.97},{"$f":"'4. Water Adjustment'!D6","v":7.88},{"$f":"'4. Water Adjustment'!E6","v":14.57},{"$f":"'4. Water Adjustment'!F6","v":24.15},{"$f":"'4. Water Adjustment'!G6","v":27},{"$f":"'4. Water Adjustment'!H6","v":109.81666666666666}]
["Mashing Water Profile",null,null,{"$f":"'4. Water Adjustment'!C13","v":30.97},{"$f":"'4. Water Adjustment'!D13","v":7.88},{"$f":"'4. Water Adjustment'!E13","v":14.57},{"$f":"'4. Water Adjustment'!F13","v":24.15},{"$f":"'4. Water Adjustment'!G13","v":27},{"$f":"'4. Water Adjustment'!H13","v":-37.94146078986455}]
["Recommended Ranges",null,null,"40 to 150","0 to 30","0 to 150","0 to 350","0 to 100","as needed"]
[]
["Mash Parameters"]
[{"$f":"N22","v":"Batch Volume (gallons)"},null,{"$f":"'4. Water Adjustment'!V17","v":12},"Hardness (ppm as CaCO3)",null,{"$f":"(('4. Water Adjustment'!C13/20)+('4. Water Adjustment'!D13/12.15))*50","v":109.85298353909465}]
["Estimated Mash pH",null,{"$f":"'3. Grain Bill Input'!F24","v":5.3755025858001408},"Alkalinity (ppm as CaCO3)",null,{"$f":"'4. Water Adjustment'!V16","v":-31.105777936084035}]
[]
["Additions",null,null,{"$f":"O22","v":"Total Mash Water Vol (gal)"},null,{"$f":"'4. Water Adjustment'!T17","v":10},{"$f":"P22","v":"Total Sparge Water Vol (gal)"},null,{"$f":"'4. Water Adjustment'!U17","v":4},"Total Volume = Tap Volume + Dilution Volume"]
[null,null,null,{"$f":"Q22","v":"Mash Dilution Vol (gal)"},null,{"$f":"'4. Water Adjustment'!B9/100*F13","v":0}]
[null,null,null,"Mash Water Additions",null,null,"Sparge Water Additions"]
["Minerals ",null,null,"(grams)",null,null,"(grams)"]
["Gypsum (CaSO4 x 2H2O) ",null,null,{"$f":"'4. Water Adjustment'!I19","v":0},null,null,{"$f":"'4. Water Adjustment'!K19","v":0},null,null,null,null,1,"Gallons","Batch Volume (gallons)","Total Mash Water Vol (gal)","Total Sparge Water Vol (gal)","Mash Dilution Vol (gal)","Sparge Dilution Vol (gal)"]
["Calcium Chloride (CaCl2)",null,null,{"$f":"'4. Water Adjustment'!I20","v":0},null,null,{"$f":"'4. Water Adjustment'!K20","v":0}]
["Epsom Salt (MgSO4 x 7H2O)",null,null,{"$f":"'4. Water Adjustment'!I21","v":0},null,null,{"$f":"'4. Water Adjustment'!K21","v":0},null,null,null,null,2,"Liters","Batch Volume (liters)","Total Mash Water Vol (L)","Total Sparge Water Vol (L)","Mash Dilution Vol (L)","Sparge Dilution Vol (L)"]
["Magnesium Chloride (MgCl2)",null,null,{"$f":"'4. Water Adjustment'!I22","v":0},null,null,{"$f":"'4. Water Adjustment'!K22","v":0}]
["Canning Salt (NaCl)",null,null,null,{"$f":"'4. Water Adjustment'!I23","v":0},null,null,{"$f":"'4. Water Adjustment'!K23","v":0}]
["Baking Soda (NaHCO3)",null,null,{"$f":"'4. Water Adjustment'!I24","v":0},null,null,"Not Recommended ",null,null,null,null,{"$f":"VLOOKUP('1. Water Report Input'!$H$7,Adjvaritable,1,FALSE)","v":1},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,Adjvaritable,2,FALSE)","v":"Gallons"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,Adjvaritable,3,FALSE)","v":"Batch Volume (gallons)"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,Adjvaritable,4,FALSE)","v":"Total Mash Water Vol (gal)"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,Adjvaritable,5,FALSE)","v":"Total Sparge Water Vol (gal)"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,Adjvaritable,6,FALSE)","v":"Mash Dilution Vol (gal)"},{"$f":"VLOOKUP('1. Water Report Input'!$H$7,Adjvaritable,7,FALSE)","v":"Sparge Dilution Vol (gal)"}]
["Chalk (CaCO3)",null,null,{"$f":"'4. Water Adjustment'!I25","v":0},null,null,"Not Recommended "]
["Pickling Lime (Ca(OH)2)",null,null,{"$f":"'4. Water Adjustment'!I26","v":0},null,null,"Not Recommended "]
["Acids"]
[{"$f":"IF('4. Water Adjustment'!T$35=0,\" \",'4. Water Adjustment'!U35)","v":"Lactic"},{"$f":"IF('4. Water Adjustment'!T35=0,\" \",'4. Water Adjustment'!D29)","v":88},{"$f":"IF('4. Water Adjustment'!T35=0,\" \",'4. Water Adjustment'!U8)","v":"%"},null,{"$f":"'4. Water Adjustment'!I29","v":8},{"$f":"IF('4. Water Adjustment'!H28=\"total acid addition (ml)\",\"(ml)\",\"(grams)\")","v":"(ml)"}]
[{"$f":"'2. Sparge Acidification'!B50","v":"Lactic"},{"$f":"'2. Sparge Acidification'!B9","v":88},{"$f":"'2. Sparge Acidification'!B57","v":"%"},null,null,null,null,{"$f":"IF('2. Sparge Acidification'!B7=1,'5. Adjustment Summary'!I13*'2. Sparge Acidification'!B12,'2. Sparge Acidification'!B12)","v":2.1160710275775974},{"$f":"IF('4. Water Adjustment'!J30=\"total acid addition (ml)\",\"(ml)\",\"(grams)\")","v":"(ml)"},null,null,null,null,null,null,null,null,"No"]
[]
["Copyright © 2016 Martin Brungard. All rights reserved. Reproduction in whole or in part in any form or medium without the express written permission of Martin Brungard, is prohibited.  Any transfer or exchange of this program via any method to anyone other than the original licensee is prohibited.  Transferring, exchanging, or posting images (screen shots) of the program and of the Raw Text Summary sheet is permitted for the purpose of conveying program results to other individuals.  The user of this program assumes all responsibility for the operation and results of the program. "]
["Bru'n Water v. 1.18"]
["If the sheet does not show comments or red corner marks, select the REVIEW tab in the Excel program menu and click the SHOW ALL COMMENTS button twice."]

{"sheet":"Water Knowledge","index":6,"n_rows":148,"n_cols":11,"rows_kept":148,"cut":false,"hidden":false,"merged":[[144,0,144,10],[145,0,145,10],[147,0,147,10],[138,0,138,10],[139,0,139,10],[140,0,140,10],[141,0,141,10],[142,0,142,10],[143,0,143,10],[125,9,125,10],[133,0,133,10],[134,0,134,10],[135,0,135,10],[136,0,136,10],[137,0,137,10],[119,0,119,10],[120,0,120,10],[121,0,121,10],[122,0,122,10],[123,0,123,10],[124,2,124,7],[124,9,124,10],[113,0,113,10],[114,0,114,10],[115,0,115,10],[116,0,116,10],[117,0,117,10],[118,0,118,10],[107,0,107,10],[108,0,108,10],[109,0,109,10],[110,0,110,10],[111,0,111,10],[112,0,112,10],[101,0,101,10],[102,0,102,10],[103,0,103,10],[104,0,104,10],[105,0,105,10],[106,0,106,10],[95,0,95,10],[96,0,96,10],[97,0,97,10],[98,0,98,10],[99,0,99,10],[100,0,100,10],[89,0,89,10],[90,0,90,10],[91,0,91,10],[92,0,92,10],[93,0,93,10],[94,0,94,10],[83,0,83,10],[84,0,84,10],[85,0,85,10],[86,0,86,10],[87,0,87,10],[88,0,88,10],[77,0,77,10],[78,0,78,10],[79,0,79,10],[80,0,80,10],[81,0,81,10],[82,0,82,10],[71,0,71,10],[72,0,72,10],[73,0,73,10],[74,0,74,10],[75,0,75,10],[76,0,76,10],[65,9,65,10],[66,9,66,10],[67,0,67,10],[68,0,68,10],[69,0,69,10],[70,0,70,10],[59,9,59,10],[60,9,60,10],[61,9,61,10],[62,9,62,10],[63,9,63,10],[64,9,64,10],[54,0,54,10],[55,0,55,10],[56,0,56,10],[57,2,57,7],[57,9,57,10],[58,9,58,10],[48,0,48,10],[49,0,49,10],[50,0,50,10],[51,0,51,10],[52,0,52,10],[53,0,53,10],[42,0,42,10],[43,0,43,10],[44,0,44,10],[45,0,45,10],[46,0,46,10],[47,0,47,10],[36,0,36,10],[37,0,37,10],[38,0,38,10],[39,0,39,10],[40,0,40,10],[41,0,41,10],[30,0,30,10],[31,0,31,10],[32,0,32,10],[33,0,33,10],[34,0,34,10],[35,0,35,10],[24,0,24,10],[25,0,25,10],[26,0,26,10],[27,0,27,10],[28,0,28,10],[29,0,29,10],[18,0,18,10],[19,0,19,10],[20,0,20,10],[21,0,21,10],[22,0,22,10],[23,0,23,10],[12,0,12,10],[13,0,13,10],[14,0,14,10],[15,0,15,10],[16,0,16,10],[17,0,17,10],[6,0,6,10],[7,0,7,10],[8,0,8,10],[9,0,9,10],[10,0,10,10],[11,0,11,10],[0,0,0,2],[0,5,0,10],[1,0,1,4],[3,0,3,10],[4,0,4,10],[5,0,5,10]]}
["Bru'n Water"]
["Link to the On-Line Version of Water Knowledge"]
["Water Knowledge",null,null,null,null,null,null,null,null,null,"by Martin Brungard"]
["This section provides the user with basic knowledge that is useful for understanding brewing water chemistry.  Water is the most basic building block in brewing.  Beer can contain up to 97 percent water, so it’s by far the largest component in beer.  A variety of ions and chemicals can be dissolved in water.  Water is seemingly simple, yet its ionic components can drastically affect a finished beer’s quality and perception.  Those effects may range from dramatic to barely perceptible.  The following sections discuss how water affects the brewing process and the quality and perception of beer.   "]
["Water Sources "]
["Many brewers rely on municipal water supplies for their water.  Other brewers may have private wells, springs, rain barrels, or other local sources for their brewing water. The source of water can have a substantial effect on its quality and variability. "]
["Municipal sources in the U.S. typically treat and verify that their water is safe to drink. Municipal water companies typically rely on surface water sources (rivers, lakes, and reservoirs) and/or groundwater sources (springs and wells) for their water source. A variety of processes can affect the quantity and quality of water from these sources through the year.  For instance, large volumes of snow melt or rainfall can provide softer water to a surface water source while that surface water can become more mineralized from groundwater inflow at other times of the year.  Differing ionic content of brewing water can affect mashing performance and flavor perceptions. "]
["Ions in water come primarily from the soil and rock minerals that the water contacts as it flows through the environment. In areas where the soil and rock are less soluble, the degree of mineralization of the water may be lower. But when the soil and rock are more soluble, the water may dissolve significant concentrations of ions.  The effect of these dissolved ions is presented in the following sections. "]
["Rivers, lakes, and reservoirs may have additional variability in their water quality when natural algae and microbes create strong taste and odor in water during warm weather.  These taste and odor components can make it past typical municipal water treatment methods and leave the water with an undesirable taste and aroma that may persist in the finished beer. "]
["Wells draw groundwater from underground aquifers.  Where these aquifers are isolated from lakes, rivers, marshes, and salt water, their groundwater quality tends to be more consistent throughout the year. Wells that are not isolated from lakes and rivers may be subject to the same water quality variability of the lake or river. Like surface water sources, the mineralization of groundwater is affected by the type of soil or rock that the groundwater flows through. Groundwater flowing through limestone and gypsum typically has more hardness minerals than groundwater flowing through granite or sandstone. "]
["Springs provide another source of groundwater. As with the sources listed above, understanding the quality of spring water is still important. The taste and ion content of the water must be suitable for brewing and the water should be free of chemical and microbe contamination. A spring water source is not a guarantee that the water is safe to drink or suitable for brewing. "]
["When presented with a water source with poor brewing qualities, additional water treatment may help correct the water’s faults.  Water treatment alternatives such as water distillation, reverse osmosis, carbon filtration, lime softening, water boiling, mineral addition, or acid addition may improve the brewing quality of a water source. Understanding the source of water and its limitations and variability can help maintain the quality and consistency of a brewer’s product. "]
["Minerals and Brewing Chemistry "]
["Minerals dissolved in brewing water produce an important effect on the overall chemistry of the brewing process.  The ions from these minerals alter the water’s pH, Hardness, Alkalinity, Residual Alkalinity, and Mineral Content. These interrelated components are the most important factors in defining the suitability of water for brewing. Adjustments to any one factor can have an effect on the others.  A discussion of each factor is presented below. "]
["pH  "]
["pH is a measure of the acidity or alkalinity of water.  It is related to the concentration of hydrogen (H+) ions in a solution. A very small percentage of the water molecules (H2O) naturally split into hydrogen (H+) and hydroxyl (-OH) ions.  A neutral pH of 7.0 indicates a balanced population of those ions (at 25°C).  Acidic solutions have a pH of between 0 and 7 while Basic solutions have a pH between 7 and 14.  The pH of typical municipal water supplies generally lies between 6.5 and 8.5.  "]
["The pH of the mash varies with temperature.  The mash pH reading is about 0.2 to 0.3 units lower at 150°F than at room temperature. Therefore, it is important to standardize the temperature at which the pH is measured. All pH readings presented here assume measurement at room-temperature. Brewers should note that Automatic Temperature Compensating (ATC) pH meters only compensate for the response of the pH meter's electrode at varying temperature.  It does not compensate for the actual pH shift produced in the mash by the increased temperature.  All mash pH measurement should be performed at room-temperature.  ATC pH meters are not absolutely necessary for brewing use."]
["pH influences a number of factors in brewing. The pH of the mash influences the fermentability, color, clarity, and taste of the wort.  The enzymatic processes during mashing are enhanced at a slightly acidic pH between 5.2 and 5.6.  The lower end of that range produces more fermentable wort and thinner body that has better extraction efficiency, lighter color, better hot break formation, and is less prone to form haze.  A mash pH greater than 6.0 can leach harsh-tasting silicates, tannins, and polyphenols from the grain into the wort. To avoid increasing the mash pH during sparging, sparge water alkalinity should be adjusted to less than 25 ppm (as CaCO3), which typically results in the water's pH being less than 6.0.  "]
["SPECIAL NOTE:  Five Star 5.2 Stabilizer is indicated by its manufacturer to \"lock in your mash and kettle water at a pH of 5.2 regardless of the starting pH of your water\".  Evidence by brewers indicates that this product does not produce a mash pH in the preferred room-temperature range of 5.3 to 5.5.   That evidence shows this product does produce some pH moderation in waters with high Residual Alkalinity.  But, the mash pH tends to center around 5.8 (room-temperature measurement).  While 5.8 pH is acceptable, it is at the upper end of the desirable range.  The evidence also shows that in waters with low Residual Alkalinity, this product shows no improvement in mashing pH.  Since Five Star 5.2 Stabilizer is a compound with high sodium content, its use will elevate the sodium concentration in the brewing water.  High sodium content is undesirable from a taste standpoint in beer.  Proper acidification of mashing and sparging water will produce more acceptable brewing results for most brewers than the use of 5.2 Stabilizer."]
["SPECIAL NOTE:  pH strips typically used by homebrewers are reported to mis-report mash pH by about 0.2 to 0.3 units lower than actual.  Brewers should use caution when using pH strips.  Without another means of pH verification, brewers are advised to accept a pH strip reading that is about 0.2 units above their targeted pH to avoid undershooting the mash pH.  pH measurement by a calibrated pH meter is preferred."]
["Hardness  "]
["Hardness in water is primarily due to the calcium and magnesium content of drinking water. High concentration of calcium or magnesium ions produces hard water and low concentration of those ions produce soft water. Water Hardness can be either Temporary or Permanent. Total Hardness is the sum of Temporary and Permanent Hardness."]
["Hardness is not a detriment to good brewing.  Soft water is not always desirable.  Excessive Alkalinity is the primary detriment to good brewing!"]
["Temporary Hardness results when calcium and magnesium are paired with carbonate and bicarbonate in the water.  Most of Temporary Hardness can be driven off by boiling the water. "]
["Permanent Hardness results when calcium and magnesium are paired with anions such as chloride and sulfate that cannot be driven off by boiling the water. The hardness of brewing water does not indicate its suitability for brewing.  As illustrated below, both very soft water and very hard water can be utilized for brewing as long as the appropriate alkalinity is produced. "]
["Alkalinity  "]
["Alkalinity is related to pH, but is not a direct measure of it.  Alkalinity is a direct measure of the \"buffering\" capacity and carbonate content of a solution and its ability to neutralize strong acid and resist pH change.  Alkalinity is defined as the amount of strong acid required to lower the pH of a sample of the water to a specified pH (typically 4.3 to 4.5).  Alkalinity is generally due to the carbonate (CO3-2), bicarbonate (HCO3 -1), and hydroxyl (OH-1) content of the water. Higher alkalinity water requires more acid to produce a pH change.  Alkalinity is best evaluated for its effect on brewing through the concept of Residual Alkalinity. "]
["Residual Alkalinity  "]
["Residual Alkalinity (RA) is a result of both Water Hardness and Alkalinity that affects mashing pH. In the mash, calcium and magnesium in the brewing water react with phosphates in the malt which produce acids that neutralize the water’s alkalinity. This interaction between the brewing water’s hardness and alkalinity is expressed by RA.  RA is a value that is specific to brewing and is an important factor in establishing the pH of wort.  RA is calculated with the following equation.  This equation uses the actual calcium and magnesium concentrations instead of \"as CaCO3\" concentrations."]
[]
["With RA, a brewer can better understand the interplay of alkalinity and water hardness and its effect on mashing chemistry and performance.  A simplified chart depicting Alkalinity, Effective Hardness, and RA is presented on the RA Chart sheet included in this program.  Lines of constant RA cross the chart diagonally.  That chart is based on work by AJ Delange. "]
[]
["RA can be adjusted by either hardness adjustment or alkalinity adjustment as shown by the equation. For instance, Burtonizing water by adding Gypsum and/or Epsom Salt is an example of reducing RA by increasing the water hardness. Adding acid to the water is an example of reducing RA by reducing alkalinity. Decarbonating water by boiling can be used to reduce RA in water with high Temporary Hardness.  Adding Chalk, Pickling Lime, or Baking Soda are examples of increasing RA by increasing alkalinity.  Diluting a water with distilled or RO water does not affect RA since both hardness and alkalinity are reduced equally by the dilution."]
["RA provides a rough indicator of where the mash pH will end up and if there is a need for water chemistry adjustment.  Although the RA Chart suggests that beer color influences what RA value is appropriate for the beer, the relationship is more complicated than that.  The acidity provided by various malt types is not proportional to the color they impart to the beer.  So a direct relationship between beer color and RA is not possible. Therefore, targeting a specific RA value for brewing water is not appropriate. The more appropriate target is mashing pH."]
["Even though a direct relationship cannot be made, a general relationship between beer color and RA is apparent.  The success in brewing dark beers in places such as Dublin, Edinburgh, Munich, and London that have high Residual Alkalinity water (RA greater than 50), is due to the more acidic dark grain used in their grist. Without the dark grain acidity to consume the high alkalinity, the mash pH would not drop into the desired range for good enzyme performance and the resulting beer may also present a harsh character because of the leaching of silicates, tannins, and polyphenols into the wort during mashing. The high alkalinity moderates the dark grain acidity to produce a smoother dark beer. "]
["The success in brewing pale beer in Pilsen is due to the soft and low alkalinity water there (RA is near 0). Likewise, the success of brewing pale beer in Burton-on-Trent is due to the very high hardness and high alkalinity that still produce a low RA. Low RA waters are well suited to brewing pale beers since the mash pH will naturally fall into the desired pH range. Low RA waters are less suitable for brewing dark beers since the acidic dark grains can drive the wort pH lower than desirable which reduces the effectiveness of mash enzymes and possibly produces a sharp, acidic, or tart beer. "]
["Coordinating the acidity of the malt bill and the alkalinity of the water is important for producing a mash pH that falls within the preferred range of 5.2 and 5.6.  The enzymatic processes of the mash are hindered when the mash pH falls outside that range.  "]
["Mineral Content  "]
["Dissolved minerals are present in all natural waters. The type and concentration of those dissolved minerals can have a profound effect on the suitability of water for brewing use, its mashing performance, and the flavor perception of beer.  A discussion of dissolved minerals that are a concern to brewers is presented below. "]
["The first consideration is that brewing water should have high quality and be safe to drink.  This requires that the water have no pollutants and have little or no iron, manganese, nitrites, or nitrates. Iron can be tasted at concentrations of greater than 0.3 parts per million (ppm) and manganese can be tasted at concentrations of greater than 0.05 ppm. These minerals have a very metallic taste that is easily conveyed into the finished beer. Nitrates are not a great concern in brewing, but should generally be less than 10 ppm in the water source.  High Nitrate concentration in the water can be converted to Nitrite in the mash.  Nitrite is poisonous to yeast.  Sulfurous compounds such as sulfur or rotten-egg aromas should not be perceptible in the water. "]
["Minerals form ions when they dissolve in water. These ions are positively-charged (Cations) and negatively-charged (Anions). The major ions of interest to brewers are shown in the table below. These ions have the greatest effect on the quality and perception of the finished beer. "]
[]
["These ions can also be grouped in another way.  Calcium, magnesium, and bicarbonate produce hardness and alkalinity that affect the mash pH. Sodium, chloride, and sulfate ions affect flavor which adds important nuances to beer perception. "]
[]
["A discussion of the effect of each of the ions is presented below."]
["Calcium is typically the principal mineral creating hardness in water.  Calcium is beneficial for mashing and enzyme action and is essential for yeast cell composition. Typical malt imparts all the calcium into the wort that the yeast need for their health, so additional calcium is not required in the brewing water. In the mash, calcium reacts with the malt phosphates to lower the mash pH by precipitating calcium phosphate.  Calcium improves the flocculation of trub and yeast and limits the extraction of grain husk astringency.  It also reduces haze and gushing potential, improves wort runoff from the lauter tun, and improves hop flavors.  The typical range for brewing water calcium ion concentration is 50 to 100 ppm for ale brewing. Lager brewing can benefit from brewing with water with less than 50 ppm calcium. Since oxalates are also precipitated through complexing with calcium, low calcium concentration may contribute to beerstone formation.  A minimum of 40 ppm calcium is recommended for that reason.  Calcium content has little effect on beer flavor. Excessive calcium content in brewing water can be detrimental to yeast health."]
["Magnesium is typically the secondary mineral creating hardness in water.  It accentuates flavor when present at low concentrations, but can be astringent at high concentrations.  Magnesium is a yeast nutrient and an important cofactor for certain enzymes.  Like calcium, magnesium reacts with the malt to lower the mash pH, but with a reduced effect compared to calcium.  The preferred range for magnesium concentration is 10 to 30 ppm.  A minimum of 5 ppm magnesium has been found to be desirable for good yeast floculation. Typical malt provides all the magnesium needed in the wort for yeast health and brewing with water that has zero magnesium content is acceptable. The primary reason to add magnesium to brewing water is for its effect on beer flavor."]
["Sodium – The sour, salty taste of sodium accentuates beer's flavor when found at moderate concentrations.  It is poisonous to yeast and harsh tasting when present at excessive concentrations. It accentuates flavor when used with chloride and imparts roundness to the beer flavor. The preferred sodium concentration range is 0 to 150 ppm, but the upper limit should be reduced in water with high sulfate concentration to avoid harshness.  A practical maximum concentration of 100 ppm is recommended."]
["Chloride – The Chloride ion is not the same as the disinfectant, Chlorine and should not be confused with it.  Chloride accentuates fullness and sweetness and improves beer stability and clarity. The ideal range is 10 to 100 ppm, but the upper limit should be reduced in water with high sulfate concentration to avoid harshness and minerally flavor. "]
["Sulfate – Sulfate provides a sharper and dryer edge to highly hopped beers.  The ideal concentration range is 0 to 350 ppm, although the concentration should not exceed 150 ppm unless the beer is highly hopped.  Sulfate is often kept relatively low when brewing malt-focused beers, although elevated sulfate content can help dry the finish of malty beers to help them avoid being perceived as cloying."]
["Bicarbonate – Bicarbonate is a strongly alkaline buffer that is typically responsible for the alkalinity in most drinking water. Malt acids produced during mashing can consume some of the bicarbonate in the brewing water.  When the malt acid content is insufficient to neutralize most bicarbonate, the mash pH is not likely to fall into the optimum range which can reduce enzyme action and make hop flavors more harsh. When brewing lighter colored beers, bicarbonate is generally undesirable in brewing water and is best kept below 50 ppm or should be balanced with additional calcium to reduce the Residual Alkalinity of the brewing water. When brewing darker colored beers, elevated bicarbonate concentration may be needed in the mash water to balance the acidity added by the dark colored malts. "]
["Acids - Acids can be an important component in brewing water adjustment.  Acids come in solid and liquid forms and all add hydronium (H+) ions to the water and move pH lower.  Acids also add their unique anion to the water.  Frequently, the anions have distinctive flavor which may either compliment or degrade beer flavor when they are present in the beer at levels near or above their taste threshold.  Some acids are more perceivable in beer than others, phosphoric is more difficult to perceive in beer since beer contains similar phosphatic compounds.  Acids such as hydrochloric and sulfuric can add chloride or sulfate ions that may be desirable in the flavor profile.  Acids such as citric, malic, and tartaric can add fruity or estery perceptions to the beer.  Lactic and acetic acids can impart their unique flavor, lactic is smooth while acetic is pungent.  "]
["Minerals and Beer Styles"]
["Historic beer styles that have developed around the world were sometimes the result of the water conditions present in that area.  Prior to the understanding, measurement, and ability to adjust water chemistry, beer styles developed to suit the local water.  Dark-colored beers developed in areas with high RA water and light-colored beers developed in areas with low RA water.  "]
["Additionally, ions affecting beer flavor perception in the local water also influenced beer styles.  For instance, malty styles tended to be found in areas with low sulfate concentrations while hoppy styles tend to be found in areas with elevated sulfate concentrations. "]
["Examples of the ionic concentrations of water from various major brewing centers are shown in the table below.  There are a variety of literary sources that provide differing estimates of the appropriate ionic concentrations for these various brewing waters.  For some of those literary sources, the quoted ionic concentrations are not correct since the indicated ionic balance could not exist at reasonable pH levels and they are not supported with factual laboratory data.  The concentrations shown in this table have been resolved with historic and current references and are corrected to provide an appropriate ionic balance.  The RA calculated for each of the water profiles is provided in the table for reference."]
["Ionic Profiles for Major Brewing Centers (in ppm) "]
[null,"Brewing","Ion Concentrations",null,null,null,null,null,"Residual"]
[null,"Center","Calcium","Magnesium","Sodium","Sulfate","Chloride","Bicarbonate","Alkalinity"]
[null,"Burton",275,40,25,610,35,270,5]
[null,"Dortmund",230,15,40,330,130,235,20]
[null,"Dublin",120,4,12,55,19,315,170]
[null,"Edinburgh",100,20,55,140,50,285,150]
[null,"London",70,6,15,40,38,166,85]
[null,"Munich",77,17,4,18,8,295,180]
[null,"Pilsen",7,2,2,8,6,16,5]
[null,"Vienna",75,15,10,60,15,225,125]
[]
["Although the historic water profiles above are accurate, it does not mean that the brewers from those areas did not treat or alter their water to brew.  Of particular interest is the use of decarbonation and softening of water by boiling.  Another treatment option was to use saurermalt (acidified malt) or saurergut (soured wort) to reduce alkalinity.    "]
["For example, the groundwater in Burton on Trent is the result of upwelling from the Mercia Mudstone (a gypsum-bearing formation) into the surficial Sand and Gravel aquifer where it mixes with groundwater from rainfall infiltration and from Trent River inflow. The more the brewers of the region utilized that water source, the more the sulfate-laden upwelling was diluted by the other less-mineralized water sources. The amount of rainfall and the river level also affect the groundwater quality."]
["The location of the water supply well also has an influence. At Marston Brewery, the sulfate content of their groundwater is up to 800 ppm. While at Coors Brewery, the sulfate content of their groundwater was only about 200 ppm. These were sampled at the same time and come from the same Sand and Gravel aquifer. So, defining a 'true' Burton water profile is impossible."]
["The balanced Burton water profile in Bru'n Water was estimated based on the relative concentrations of ions observed from the Sand and Gravel aquifer, but those concentrations could be higher or lower depending upon time of year and location.  At over 600 ppm sulfate, the provided profile is not as extreme as that groundwater gets, but it is highly mineralized. Brewing with that Burton profile may be extreme and an alternative would be to brew with the Pale Ale profile that is also included in Bru'n Water as a first try for brewing a good hoppy beer (300 ppm sulfate).  "]
["Decarbonation by Boiling is discussed in the Alkalinity section below.  A selection of estimated Decarbonated Water Profiles is provided in that section to illustrate the difference that boiling can create in the water profiles."]
["Water Treatment"]
["Every water resource may not provide ideal conditions or results for brewing.  Water treatment may be needed for a number of reasons including:"]
[]
["     · Chlorine Removal"]
["     · Hardness Adjustment"]
["     · Alkalinity Adjustment"]
["     · Mineral Profile Adjustment"]
["Chlorine Removal "]
["\nChlorine is typically found in municipal water supplies to assure the water’s disinfection from disease-causing organisms.  Chlorine removal from brewing water is critical for good brewing results.  Although the term chlorine is used generically here, chloramine and chlorine dioxide are other disinfection agents commonly used in municipal water supplies.  If these compounds are not removed, they combine with the organic compounds naturally found in wort to create chlorophenols.  Even at part per billion concentrations, Chlorophenols can be detected in beer and they have a distinctive mediciny, band-aid flavor that is objectionable in both flavor and aroma.  "]
["The use of bleach as a sanitizing agent can leave chlorine on brewing equipment and in the brewing water.  Sanitizers such as iodophor and acid-type cleaners can be more effective and require no rinsing.  Switching from bleach to these sanitizers can produce a substantial improvement in the quality of a finished beer."]
["Several options are available for removing chlorine from brewing water.  "]
[]
["     · Boiling"]
["     · Metabisulfite addition"]
["     · Activated Carbon filtration"]
["     · Aeration"]
["Boiling is effective for chlorine removal, but requires time and energy to conduct the boil.  Boiling is less effective for chloramine removal, but additional boiling time will remove it.  A by-product of boiling is that Temporary Hardness can be removed from the water as described below."]
["Metabisulfite (Campden Tablet) addition is effective for chlorine and chloramine removal.  The tablets are either potassium metabisulfite or sodium metabisulfite.  Both are effective in the disinfectant removal. When sodium content in the brewing water is a concern, potassium metabisulfite is preferred.  Moderate potassium content in brewing water generally has little effect on brewing performance or taste."]
["Filtering brewing water through activated carbon is an effective chlorine removal alternative.  Both chlorine and chloramine are removed from the water while leaving the other water minerals.  Filtering with activated carbon can also remove other water contaminants such as organic compounds that degrade water taste and odor.  The flow rate through the filter affects the removal performance.  Low flow rate through an activated carbon filter is required to provide acceptable chlorine and contaminant removal performance. The flow rate through a standard under-sink (10\") activated carbon filter should be no greater than 1 gallon per minute to achieve good chlorine removal. The flow rate needs to be reduced to about 0.1 gallon per minute when chloramines must be removed from the water with that filter size. Inserting a restrictor in the water supply line with a 1/16-inch diameter hole will reduce the flow rate to about 1 gallon per minute.  The flow rate through smaller-sized carbon filters should be further reduced to produce adequate removal."]
["Aeration of tap water can be used to dechlorinate, but its removal rate is low.  Water can also be dechlorinated when the water is left out in an open container or air is bubbled through it.  Boiling can be considered to be a form of accelerated aeration.  As with boiling, chlorine is removed more quickly than chloramines.  A day of aeration is typically sufficient for chlorine removal whereas it may take days to remove chloramine. "]
["Chlorine Removal Verification"]
["Chlorine and Chloramine removal can be verified through testing with a chlorine test kit, such as those found in swimming pool stores.  If the water system does not use chloramine, then a readily-available \"Free Chlorine\" test kit is sufficient for detecting chlorine residual in the treated water.  If chloramine is used by the water supplier, then a slightly more expensive \"Total Chlorine\" or \"Combined Chlorine\" test kit is required for testing the treated water.  Liquid test kits are recommended over test strips since they tend to be more sensitive.    "]
["Hardness Adjustment  "]
["Increasing water hardness is fairly easy.  Gypsum (calcium sulfate), Epsom Salt (magnesium sulfate), Calcium Chloride, Chalk (calcium carbonate), or Pickling Lime (calcium hydroxide) are used to increase the hardness.  "]
["Reducing hardness is much more difficult.  Dilution with distilled water or Reverse Osmosis (RO) water is a quick, yet more costly option.  Distilled water is free of all hardness and alkalinity ions while RO water is nearly free of those ions.  Both sources are very soft water that reduce the hardness and alkalinity of the brewing water in proportion to the amount of purified water added.  The ion concentrations of these purified waters are typically too low to promote good mashing and fermentation conditions.  Therefore, minerals should be added to these purified waters or the purified water should be blended with the original source water to provide an adequate ionic content. "]
["Temporary hardness can be removed by boiling the water to drive off dissolved carbon dioxide which causes calcium carbonate and magnesium carbonate to precipitate out of the water.  After the water clears, the water is immediately decanted off the sediment and used for brewing.  This treatment does not remove permanent hardness.  Like chlorine removal, this method requires time and energy to complete.  An extended discussion of this method is presented in the Alkalinity section below."]
["Lime Softening is another option for hardness reduction. Pickling Lime is added to the water to elevate its pH to about 11.  Calcium and magnesium compounds will precipitate out of the water at that high pH. After the water clears, the water is immediately decanted off the sediment. Since the water pH is high, the pH must then be reduced prior to brewing usage. Aeration (to dissolve CO2 in the water) and/or the addition of acid are suitable for reducing the pH of the lime-treated water.  This method requires time, special chemicals, and a pH meter to conduct successfully. When properly performed, lime softened water provides moderately-hard water with typical concentrations of about 30 ppm calcium and 10 ppm magnesium in water with a high Temporary Hardness (low chloride or sulfate concentrations).  When the water also contains Permanent Hardness, Lime Softening is not as effective and the calcium and magnesium concentrations will be higher than indicated here."]
["When the starting water has high Temporary Hardness and low magnesium concentration, the lime-softening procedure above can be modified to require the pH be raised to about 10 instead of 11.  This will still cause the calcium to precipitate without affecting the magnesium content.  The resulting treated water pH will be easier to neutralize through aeration or acidification with this approach.  This approach is better suited than the pH 11 procedure above, when the water's magnesium content is already less than about 15 ppm."]
["Water softeners that use salts (sodium chloride or potassium chloride) to soften water may not be suited for treating brewing water since the hardness ions (Ca and Mg) are replaced with elevated levels of sodium or potassium which can impart undesirable flavor and potentially harm the yeast. However if the water has little calcium and magnesium and iron or manganese are present in the water, then salt-based water softening may be used to remove the iron and manganese without adding too much sodium or potassium to the water. That water may be suited for brewing use."]
["Alkalinity Adjustment "]
["Alkalinity affects the performance of the mash through RA.  Alkalinity is produced by bicarbonate, carbonate, and hydroxyl in the water.  Bicarbonate is the predominant species in the typical municipal water system pH range of 6.5 to 8.5.  There are several reasons why bicarbonate is the predominant species in tap water.  Carbonate does not exist in significant concentration in that typical water pH range since it is preferentially transformed to bicarbonate.  Hydroxyl is a strong base that reacts easily with impurities in the water.  Since there are typically impurities in the water, hydroxyl does not exist in significant concentration in water supplies. "]
["Excessive alkalinity can reduce the quality and perception of pale colored beers.  Alkalinity can also have a detrimental effect on beers made with Malt Extract since excessive alkalinity can drive up the pH of the resulting wort and finished beer made with that extract.  Water used for beers made with Malt Extract should have alkalinity under 50 ppm as CaCO3.  The alkalinity of mashing water should be based on the acidity of the mash grist. "]
["Alkalinity can be reduced in a number of ways.  Dilution with distilled water or RO water is effective in reducing alkalinity.  Acid addition is also a simple way to neutralize alkalinity."]
["Alkalinity may be desirable in mashing water when acidic grists (significant roast and/or crystal malt content) are mashed.  Alkalinity helps buffer the pH and helps keep the mash pH in the proper range.  Chalk (calcium carbonate), Pickling Lime (calcium hydroxide), or Baking Soda (sodium bicarbonate) can be used to increase alkalinity.  Low alkalinity is always desirable in sparge water and alkalinity-increasing minerals should not be added to sparge water."]
["Because Chalk does not dissolve easily in plain water or in the mash, chalk should not be used in brewing. The acids in the mash are weak and have difficulty dissolving the chalk.  Evidence has shown that even in the mash, chalk does not dissolve in significant quantity and the intended amount of alkalinity may not be produced in the mash.  Other alkalinity sources are recommended below."]
["Pickling Lime is readily soluble in water, but must be handled with care since it can burn skin and significantly raise the mash pH if not dosed properly.  Since Pickling Lime can cause calcium and magnesium to precipitate from water's with high concentrations of those ions, it may not be appropriate to add lime directly to those waters. However, in most cases where raising mashing water alkalinity is needed, those waters typically have little calcium or magnesium and the precipitation reaction is not likely to occur.  Pickling Lime can be found where home canning supplies are sold.  It is also available at salt-water aquarium shops and may be found under the names: Lime or Slaked Lime."]
["Baking Soda usage should be limited if the sodium content of the brewing water is a concern.  Sodium at a concentration of 100 ppm or more can affect flavor and can produce harshness in the beer flavor when the sulfate content is also high. "]
["Excessive alkalinity can reduce the quality and perception of pale colored beers.  Alkalinity can be reduced in a number of ways.  Dilution with distilled water or RO water is effective in reducing alkalinity.  Acid addition is also a simple way to neutralize alkalinity.  "]
["Lactic Acid is readily available for brewing use, but it can produce a distinctive “tang” in the flavor profile at high concentration.  Phosphoric Acid can also be used and it has little flavor effect since this acid is similar to the malt acids produced through mashing.  Phosphoric acid does not cause excessive precipitation of calcium in the mash and can be used freely in brewing.  Hydrochloric and Sulfuric acids are strong acids that also contribute chloride or sulfate ions, respectively.  "]
["The disadvantage with acids is that they can be hazardous to handle and they require knowledge or experience to determine how much should be dosed. Accurate measurement for acid addition is needed.  Acidulated malt can also be used to neutralize alkalinity.  Acidulated malt is similar to an acid addition since the malt has been infused with lactic acid. "]
["An additional option for alkalinity reduction is to harden the water to create more malt acids through the malt phosphate reaction with the calcium or magnesium ions.  This approach is directly from the concept of Residual Alkalinity presented above.  "]
["Decarbonation by Boiling is a practice that was employed historically and it does reduce alkalinity and calcium (hardness) in water with high Temporary Hardness.  The boiling process drives off carbon dioxide (CO2) that helps keep chalk (CaCO3) soluble in water.  When the CO2 is driven off, the CaCO3 will precipitate out of the water.  "]
["This process provides results that can be somewhat similar to performing Lime-Softening.  Lime-softening is a less energy intensive and less expensive way to reduce temporary hardness, but it may not reduce alkalinity to the degree that the boiling method can."]
["In this method, the water is heated to boiling or near-boiling and stirred, splashed, or aerated to help get the CO2 out of the water.  As CO2 leaves the water, CaCO3 precipitates and causes the water to become cloudy.  The heating is ended and the precipitate is allowed to settle quietly to the bottom of the vessel.  The water is then immediately decanted off the sediment and used for brewing.  The water cannot be allowed to sit too long on the sediment or CO2 will again diffuse from the atmosphere into the cooled water and redissolve the CaCO3.  "]
["This process does not reduce the magnesium content since Mg(OH)2 is much more soluble than CaCO3 in water and the CaCO3 precipitates first, leaving the magnesium with the remaining bicarbonate in the water.  "]
["Boiling reduces both bicarbonate and calcium content of the water when performed properly.  The practical limit for the process reduces the bicarbonate content to between 60 and 80 ppm.  Therefore, the quantity of CaCO3 that can be precipitated will be based on the difference between the starting and ending (60 to 80ppm) bicarbonate content.  A reasonable assumption is to use the upper bicarbonate limit for the ending bicarbonate concentration since that allows for more error in the process.  The ending calcium content for the water can be calulated using the following formula:  "]
[]
["The equation above assumes that the water has a high enough calcium concentration to execute the reaction to volatilize the CO2 and precipitate the CaCO3.  An ending calcium concentration that is negative indicates that additional calcium would be required.  The lowest practical ending calcium concentration is about 12 ppm.  If the calcium concentration is not high enough, it will be neccessary to add calcium in the form of Gypsum or Calcium Chloride to achieve the ending 80 ppm bicarbonate concentration.  The decision as to which of these supplemental calcium sources to use should be based on the desire for more sulfate or more chloride in the water.  "]
["A technique to help encourage and speed the precipitation of CaCO3 from the boiled water is to add more Chalk to the water.  The Chalk provides nucleation sites for the precipitating CaCO3 to agglomerate with and form larger flocs that will settle faster.  A teaspoon of Chalk per 5 gallons should be sufficient to improve the settling.  The added Chalk does not dissolve and add to the calcium concentration since it is not soluble in water without CO2.  "]
["Examples of the effect of Decarbonation by Boiling are presented in the water profiles below.  The bicarbonate content was assumed to be reduced to 80 ppm and the calcium corresponding to the quantity of removed bicarbonate was also removed.  All other ion concentrations remain as for the original water.  In the case of the Burton and Dortmund profiles, the low original RA and significant reduction in RA with boiling, indicates that those profiles do not need to be treated in this way for brewing.  Typically, water profiles such as Dublin, Edinburgh, London, Munich, and Vienna are suitable for boiling treatment."]
["Ionic Profiles for Major Brewing Centers after Boiling (in ppm) "]
[null,"Brewing","Ion Concentrations",null,null,null,null,null,"Residual"]
[null,"Center","Calcium","Magnesium","Sodium","Sulfate","Chloride","Bicarbonate","Alkalinity"]
[null,"Burton",213,40,25,610,35,80,-109]
[null,"Dortmund",179,15,40,330,130,80,-70]
[null,"Dublin",43,4,12,55,19,80,33]
[null,"Edinburgh",33,20,55,140,50,80,31]
[null,"London",42,6,15,40,38,80,33]
[null,"Munich",12,17,4,18,8,95,60]
[null,"Vienna",27,15,10,60,15,80,38]
["These profiles present the theoretical precipitation of calcium that will occur as the water is decarbonated by boiling.  The really low Ca result for the Munich profile is questionable, but the chemistry indicates it is possible. Note that the bicarbonate concentration cannot be reduced to the 80 ppm level in the Munich profile due to the practical lower limit of 12 ppm for calcium when using lime softening or boiling."]
["Although the effect of boiling on Temporary Hardness is well documented and understood, the effect of minor water heating is less understood.  Since the solubility of CO2 is inversely proportional to the water's temperature, it follows that minor heating will produce some of the effects of boiling.  Bubbles can often been seen on the side of the kettle as the water heats.  Therefore, a partial reduction in alkalinity and calcium content may occur when heating water with high Temporary Hardness to mashing or sparging temperature if the water is stirred and the bubbles are forced into the atmosphere   Since precipitation and decanting is not typically performed for mashing and sparge water preparation, the effectiveness of heating on the alkalinity and calcium reduction is probably limited.  As already known for chalk, the precipitated CaCO3 in the water does not readily redissolve in the mash and therefore the heating may provide some minor alkalinity and calcium reduction.   "]
["Mineral Profile Adjustment  "]
["\nMineral additions are sometimes desirable for RA adjustment and for creating certain flavor contributions in the finished beer.  Common mineral salts are typically used to provide the mineral additions.  The following mineral salts are commonly used in brewing water adjustment.  Only food-grade minerals should be used for water adjustment."]
["Gypsum provides calcium and sulfate ions and is readily soluble in water."]
["Epsom Salt provides magnesium and sulfate ions and is readily soluble in water."]
["Calcium Chloride provides calcium and chloride ions and is readily soluble in water."]
["Table Salt provides sodium and chloride ions and is readily soluble in water.  Only non-iodized salt should be used since iodine is poisonous to yeast."]
["Baking Soda provides sodium and bicarbonate ions and is readily soluble in water."]
["Chalk provides calcium and carbonate ions.  Chalk is not readily soluble in water and the acidic conditions of the mash are required to dissolve the chalk.  The carbonate ions generally transform into bicarbonate ions in the mash."]
["Pickling Lime provides calcium and hydroxide ions.  The hydroxide ions are strong consumers of acidity and can significantly increase pH if over dosed.  Consuming acidity is the definition of Alkalinity.  Therefore, an equivalent bicarbonate alkalinity contribution can be calculated.  Pickling Lime is readily soluble in water and must be used with care."]
["Magnesium Chloride provides magnesium and chloride ions and is readily soluble in water.  "]
[]
[]
["Copyright © 2016 Martin Brungard. All rights reserved. Reproduction in whole or in part in any form or medium without the express written permission of Martin Brungard, is prohibited.  Any transfer or exchange of this program via any method to anyone other than the original licensee is prohibited.  Transferring, exchanging, or posting images (screen shots) of the program and of the Raw Text Summary sheet is permitted for the purpose of conveying program results to other individuals. "]