So I input what I believe is the correct information in the excel sheet and it says it is unbalanced. Have I entered the information into the spreadsheet incorrectly.
You may have made a data entry error but you have also been given bad data. Bad in the sense that not a single one of those numbers is exactly correct. There are a variety of ways in which this can happen:
1. The data comes from a lab:
1a. No laboratory measurement method produces exact results.
1b. The lab does not test for every element. For example most wouldn't test for strontium and some waters in the US have a fair amount of it.
1c. A particular test may be subject to interference. For example, the traditional way to test for calcium and magnesium responds to strontium. Thus if strontium is present the calcium and magnesium numbers will be in error.
1d. The lab may do its math wrong. For example, Ward labs calculates carbonate and bicarbonate using an old approximate method which does not return actual carbonate and bicarbonate levels.
2. The data comes from a water supplier
2a. They have a lab and all the comments from 1 apply in addition to which
2b. They usually report averages over some time period e.g. month or year.
2c. Water authorities often test for one parameter on say, Monday and
another on Thursday.
A single water sample should balance. Averages and data on samples taken at different times cannot be expected to balance.
I have recently finished a blue moon clone and it has a little bit of an off flavor, but I can pinpoint what it is. Will the high alkalinity cause certain off flavors.
High alkalinity, if not neutralized with acid, results in high mash pH. This dulls all flavors.