{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["more breakdownsJuly6th","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"more breakdownsJuly6th","index":0,"n_rows":80,"n_cols":9,"rows_kept":80,"cut":false,"hidden":false,"merged":[[45,4,45,5],[45,6,45,7],[8,0,9,0],[8,1,9,1],[8,2,9,2],[22,0,23,0],[22,1,23,1],[22,2,23,2],[8,3,8,8],[43,4,43,5],[43,6,43,7],[44,4,44,5],[44,6,44,7],[22,3,22,8],[36,0,36,8],[61,6,61,7],[62,4,62,5],[62,6,62,7],[54,6,54,7],[49,4,49,5],[49,6,49,7],[50,4,50,5],[50,6,50,7],[51,4,51,5],[51,6,51,7],[52,4,52,5],[52,6,52,7],[53,4,53,5],[53,6,53,7],[54,4,54,5],[3,0,3,8],[78,0,78,8],[55,4,55,5],[55,6,55,7],[56,4,56,5],[56,6,56,7],[57,4,57,5],[57,6,57,7],[69,0,69,7],[58,4,58,5],[58,6,58,7],[59,4,59,5],[59,6,59,7],[60,4,60,5],[60,6,60,7],[61,4,61,5]]}
[]
[null,null,"Nitrate Testing for Private Wells"]
[]
["The Minnesota Department of Agriculture (MDA) has designed a Township Testing Program to determine current nitrate-nitrogen concentrations in private wells. The initial criteria used to select townships for testing is 30% of the township is vulnerable to groundwater contamination and 20% in row crop production. The MDA uses the final results to determine if additional action is needed to minimize potential sources of nitrate pollution in the state's groundwater. "]
["Program testing and the summarizing of results are ongoing. Tables were created with current data, July 5, 2017."]
[]
["Table 1: Final Township Testing Results*"]
[]
["County","Number of Townships Tested","Final Well Dataset","Number of Townships with Wells Over the\nHealth Risk Limit (>10 mg/L Nitrate-N)\n(Listed by percentage of wells exceeding the health risk limit.)"]
[null,null,null,"<5%","5-9%","10-19%","20-29%","30-39%",">40%**"]
["Benton",3,472,1,1,1,0,0,0]
["Dakota",15,1179,4,3,2,3,2,1]
["Morrison",11,1104,3,4,3,0,0,1]
["Olmsted",11,923,10,0,1,0,0,0]
["Pope",6,283,6,0,0,0,0,0]
["Sherburne ",6,1992,0,4,2,0,0,0]
["Stearns",14,1788,8,5,1,0,0,0]
["Wadena",4,224,1,2,1,0,0,0]
["Washington ",2,441,0,1,0,1,0,0]
[]
["Table 2: Initial Township Testing Results-Final Township Testing Results are Not Yet Available*"]
[]
["County","Number of Townships Tested","Number of Wells","Number of Townships with Wells Over the\nHealth Risk Limit (>10 mg/L Nitrate-N)\n(Listed by percentage of wells exceeding the health risk limit.)"]
[null,null,null,"<5%","5-9%","10-19%","20-29%","30-39%",">40%**"]
["Becker",3,200,0,1,2,0,0,0]
["Benton",1,321,0,1,0,0,0,0]
["Dodge",7,654,3,1,3,0,0,0]
["Douglas",9,1864,7,2,0,0,0,0]
["Hubbard",6,1106,1,2,3,0,0,0]
["Kandiyohi",4,313,1,3,0,0,0,0]
["Nobles",4,45,0,0,0,0,0,4]
["Ottertail",32,4536,18,7,7,0,0,0]
["Rock",7,171,0,0,0,0,0,7]
["Todd",9,797,4,5,0,0,0,0]
["Winona",13,940,2,2,5,1,1,2]
[]
["* The initial township testing results include data from all wells initially tested. An optional follow-up testing and well survey is offered to homeowners that have a presence of nitrate in their initial sample. Wells with nitrate-nitrogen results over 5 mg/L and a nearby non-fertilizer source or identified well problem are removed. The remaining wells form the final township testing well dataset."]
["** Additional information for these townships is available in Table 3. See back page."]
[]
[]
["Table 3: Townships with > 40% of Wells Exceeding the Health Risk Limit  (> 10 mg/L Nitrate-N)"]
[]
["Final Township Testing Results"]
["County","Township","Years\nSampled\n(initial,\nfollow-up)","Total\nWells","Number of Wells \n> 10 mg/L Nitrate-N",null,"Percentage of Wells \n> 10 mg/L Nitrate-N"]
["Dakota","Marshan"," 2013, 2015",95,41,null,0.43157899999999999]
["Morrison","Agram"," 2013, 2015",93,44,null,0.47311799999999998]
[]
[]
["Initial Township Testing Results"]
["County","Township","Year\nSampled","Total\nWells","Number of Wells \n> 10 mg/L Nitrate-N",null,"Percentage of Wells \n> 10 mg/L Nitrate-N"]
["Nobles","Grand Prairie",2016,14,13,null,0.9285714285714286]
["Nobles","Westside",2016,15,13,null,0.8666666666666667]
["Nobles","Lismore",2016,7,5,null,0.7142857142857143]
["Nobles","Olney",2016,9,4,null,0.44444444444444442]
["Rock","Clinton",2016,10,8,null,0.8]
["Rock","Battle Plain",2016,23,15,null,0.65217391304347827]
["Rock","Mound",2016,28,16,null,0.5714285714285714]
["Rock","Vienna",2016,23,11,null,0.47826086956521741]
["Rock","Magnolia",2016,20,9,null,0.45]
["Rock","Rose Dell",2016,30,13,null,0.43333333333333335]
["Rock","Luverne",2016,37,15,null,0.40540540540540543]
["Winona","Fremont",2016,42,23,null,0.54761904761904767]
["Winona","Utica",2016,86,40,null,0.46511627906976744]
[]
[]
["Additional Information"]
[]
["Township Testing Program:  www.mda.state.mn.us/townshiptesting"]
[]
["Minnesota Nitrogen Fertilizer Management Plan (NFMP): To learn more about the NFMP, the state's blueprint for preventing or minimizing impacts of nitrogen fertilizer on groundwater, visit www.mda.state.mn.us/nfmp."]
[]
[]
[]
[]
[]
["Funding Acknowledgement"]
["Funding for this project is provided by the Clean Water, Land and Legacy Amendment"]
[]
["In accordance with the Americans with Disabilities Act, this information is available in alternative forms of communication upon request by calling 651-201-6000. TTY users can call the Minnesota Relay Service at 711. The MDA is an equal opportunity employer and provider."]
[{"$nulls":8},"July 2017"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}