{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Chemistry Output Table","Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":10,"comments":0,"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":"Chemistry Output Table","index":0,"n_rows":27,"n_cols":41,"rows_kept":27,"cut":false,"hidden":false,"merged":[[13,0,23,0],[24,0,26,0]]}
[null,null,"Alkalinity (Bicarbonate) as CaCO3","Alkalinity (Total) as CaCO3","Anions Total","Calcium (Filtered)","Chloride","Electrical Conductivity (Lab)","Fluoride","Ionic Balance","Magnesium (Filtered)","pH (Lab)","Potassium (Filtered)","Silicon as Si (Filtered)","Sodium (Filtered)","Sulphate as SO4 (Filtered)","Total Dissolved Solids","Arsenic","Arsenic (Filtered)","Barium","Barium (Filtered)","Boron","Boron (Filtered)","Copper","Iron","Iron (Filtered)","Lithium","Lithium (Filtered)","Manganese","Manganese (Filtered)","Methane","Nitrate (as N)","Nickel","Nickel (Filtered)","Strontium","Strontium (Filtered)","Zinc","Gross alpha","Gross beta activity - 40K","Gross beta activity - 40K"]
[null,null,"mg/L","mg/L","meq/L","mg/L","mg/L","µS/cm","mg/L","%","mg/L","pH_Units","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","Bq/L","Bq/L","Bq/L"]
["EQL",null,1,1,0.01,1,1,1,0.1,0.01,1,0.01,1,0.05,1,1,10,1E-3,1E-3,1E-3,1E-3,0.05,0.05,1E-3,0.05,0.05,1E-3,1E-3,1E-3,1E-3,0.01,0.01,1E-3,1E-3,1E-3,1E-3,5.0000000000000001E-3,0.05,0.1,1.1000000000000001]
["Location_Code","Sampled_Date_Time"]
["RN41132 (BET-MB022)","2019-08-17T14:30:00",271,271,13.7,109,159,1290,1.6,1.1599999999999999,49,7.36,15,8.68,96,183,762,4.0000000000000001E-3,4.0000000000000001E-3,6.7000000000000004E-2,6.2E-2,0.2,0.25,7.0000000000000001E-3,2.54,0.89,4.3999999999999997E-2,4.9000000000000002E-2,7.4999999999999997E-2,7.1999999999999995E-2,"<0.01",0.01,2.7E-2,2.7E-2,0.8,0.80500000000000005,7.3999999999999996E-2," - "," - "," - "]
["RN41132 (BET-MB022)","2019-09-14T12:00:00",298,298,13.6,94,151,1260,1.5,4.12,41,7.56,14,9.42,94,162,746,4.0000000000000001E-3,5.0000000000000001E-3,6.4000000000000001E-2,0.06,0.21,0.2,"<0.001",0.5,0.47,4.1000000000000002E-2,0.04,2.4E-2,2.4E-2,"<0.01","<0.01",5.0000000000000001E-3,6.0000000000000001E-3,0.77600000000000002,0.75900000000000001,0.02," - "," - "," - "]
["RN41132 (BET-MB022)","2019-10-16T14:20:00",292,292,13.4,86,166,1260,1.4,5.35,40,7.5,14,9.6199999999999992,94,138,638,5.0000000000000001E-3,4.0000000000000001E-3,6.3E-2,6.2E-2,0.22,0.21,"<0.001",0.67,0.6,4.2999999999999997E-2,0.04,1.9E-2,1.7000000000000001E-2,"<0.01","<0.01",4.0000000000000001E-3,3.0000000000000001E-3,0.77800000000000002,0.72,1.0999999999999999E-2,1.1200000000000001,0.35,0.35]
["RN41132 (BET-MB022)","2019-10-16T14:26:00",292,292,13.3,84,164,1260,1.4,6.22,39,7.48,13,9.52,92,136,630,5.0000000000000001E-3,4.0000000000000001E-3,7.6999999999999999E-2,0.06,0.22,0.2,1E-3,0.69,0.53,4.8000000000000001E-2,3.7999999999999999E-2,2.1000000000000001E-2,1.6E-2,"<0.01",0.03,8.0000000000000002E-3,4.0000000000000001E-3,0.92400000000000004,0.69399999999999995,2.5999999999999999E-2,1.1599999999999999,0.37,0.37]
["RN41132 (BET-MB022)","2019-11-26T13:30:00",284,284,13,84,164,1220,1.4,2.37,42,7.58,15,10.199999999999999,101,131,746,6.0000000000000001E-3,5.0000000000000001E-3,6.6000000000000003E-2,6.3E-2,0.21,0.22,2E-3,1.74,1.59,4.2999999999999997E-2,4.4999999999999998E-2,2.4E-2,2.4E-2,"<0.01","<0.01",8.0000000000000002E-3,2E-3,0.81499999999999995,0.80200000000000005,2.5999999999999999E-2,1.7,0.68,0.68]
["RN41132 (BET-MB022)","2019-12-17T13:30:00",328,328,14.3,82,158,1250,1.4,7.94,38,7.82,16,10.4,105,158,744,4.0000000000000001E-3,3.0000000000000001E-3,5.8000000000000003E-2,4.5999999999999999E-2,0.22,0.23,"<0.001",1.97,0.6,4.2000000000000003E-2,3.6999999999999998E-2,2.9000000000000001E-2,2.1000000000000001E-2,0.01,"<0.01",5.0000000000000001E-3,2E-3,0.752,0.63400000000000001,2.1000000000000001E-2,1.43,0.52,0.52]
["RN41132 (BET-MB022)","2020-03-25T13:30:00",307,307,13.8,87,174,1170,1.4,7,38,7.36,15,10.199999999999999,95,132,683,6.0000000000000001E-3,5.0000000000000001E-3,6.0999999999999999E-2,6.2E-2,0.18,0.2,2E-3,1.07,1.02,3.9E-2,4.3999999999999997E-2,1.7000000000000001E-2,1.4999999999999999E-2,"<0.01","<0.01",6.0000000000000001E-3,6.0000000000000001E-3,0.73699999999999999,0.73599999999999999,2.7E-2," - "," - "," - "]
["RN41132 (BET-MB022)","2020-05-24",305,305,13.4,89,165,1200,1.3,1.98,41,7.63,15,9.51,107,126,648,5.0000000000000001E-3,5.0000000000000001E-3,6.2E-2,6.2E-2,0.21,0.2,"<0.001",3.11,2.72,4.2000000000000003E-2,0.04,3.1E-2,0.03,2.1999999999999999E-2,"<0.01","<0.001","<0.001",0.80900000000000005,0.77800000000000002,8.0000000000000002E-3,1.44,0.41,1.41]
["RN41132 (BET-MB022)","2020-08-05T14:30:00",320,320,13.3,89,157,1380,1.3,2.46,41,7.51,16," - ",102,119,666,6.0000000000000001E-3,5.0000000000000001E-3,6.2E-2,6.4000000000000001E-2,0.2,0.19,"<0.001",2.63,2.41,4.1000000000000002E-2,4.1000000000000002E-2,2.3E-2,2.3E-2,3.9E-2,"<0.01",2E-3,"<0.001",0.78800000000000003,0.79200000000000004,1.2E-2," - "," - "," - "]
["Statistical Analysis of Gum Ridge Formation baseline water quality","Number of Results",{"$f":" ESDAT_CountValues(C5:C13)","v":9},9,9,9,9,9,9,9,9,9,9,8,9,9,9,9,9,9,9,9,9,{"$f":" ESDAT_CountValues(X5:X13)","v":9},9,9,9,9,9,9,{"$f":" ESDAT_CountValues(AE5:AE13)","v":9},{"$f":" ESDAT_CountValues(AF5:AF13)","v":9},9,9,9,9,9,5,5,{"$f":" ESDAT_CountValues(AN5:AN13)","v":5}]
[null,"Number of Detects",{"$f":" ESDAT_CountDetects(C5:C13)","v":9},9,9,9,9,9,9,9,9,9,9,8,9,9,9,9,9,9,9,9,9,{"$f":" ESDAT_CountDetects(X5:X13)","v":4},9,9,9,9,9,9,{"$f":" ESDAT_CountDetects(AE5:AE13)","v":3},{"$f":" ESDAT_CountDetects(AF5:AF13)","v":2},8,7,9,9,9,5,5,{"$f":" ESDAT_CountDetects(AN5:AN13)","v":5}]
[null,"Minimum Concentration",{"$f":" ESDAT_MinValue(C5:C13)","v":271},271,13,82,151,1170,1.3,1.1599999999999999,38,7.36,13,8.68,92,119,630,4.0000000000000001E-3,3.0000000000000001E-3,5.8000000000000003E-2,4.5999999999999999E-2,0.18,0.19,{"$f":" ESDAT_MinValue(X5:X13)","v":"<0.001"},0.5,0.47,3.9E-2,3.6999999999999998E-2,1.7000000000000001E-2,1.4999999999999999E-2,{"$f":" ESDAT_MinValue(AE5:AE13)","v":"<0.01"},{"$f":" ESDAT_MinValue(AF5:AF13)","v":"<0.01"},"<0.001","<0.001",0.73699999999999999,0.63400000000000001,8.0000000000000002E-3,1.1200000000000001,0.35,{"$f":" ESDAT_MinValue(AN5:AN13)","v":0.35}]
[null,"Minimum Detect",{"$f":" ESDAT_MinDetect(C5:C13)","v":271},271,13,82,151,1170,1.3,1.1599999999999999,38,7.36,13,8.68,92,119,630,4.0000000000000001E-3,3.0000000000000001E-3,5.8000000000000003E-2,4.5999999999999999E-2,0.18,0.19,{"$f":" ESDAT_MinDetect(X5:X13)","v":1E-3},0.5,0.47,3.9E-2,3.6999999999999998E-2,1.7000000000000001E-2,1.4999999999999999E-2,{"$f":" ESDAT_MinDetect(AE5:AE13)","v":0.01},{"$f":" ESDAT_MinDetect(AF5:AF13)","v":0.01},2E-3,2E-3,0.73699999999999999,0.63400000000000001,8.0000000000000002E-3,1.1200000000000001,0.35,{"$f":" ESDAT_MinDetect(AN5:AN13)","v":0.35}]
[null,"Maximum Concentration",{"$f":" ESDAT_MaxValue(C5:C13)","v":328},328,14.3,109,174,1380,1.6,7.94,49,7.82,16,10.4,107,183,762,6.0000000000000001E-3,5.0000000000000001E-3,7.6999999999999999E-2,6.4000000000000001E-2,0.22,0.25,{"$f":" ESDAT_MaxValue(X5:X13)","v":7.0000000000000001E-3},3.11,2.72,4.8000000000000001E-2,4.9000000000000002E-2,7.4999999999999997E-2,7.1999999999999995E-2,{"$f":" ESDAT_MaxValue(AE5:AE13)","v":3.9E-2},{"$f":" ESDAT_MaxValue(AF5:AF13)","v":0.03},2.7E-2,2.7E-2,0.92400000000000004,0.80500000000000005,7.3999999999999996E-2,1.7,0.68,{"$f":" ESDAT_MaxValue(AN5:AN13)","v":1.41}]
[null,"Maximum Detect",{"$f":" ESDAT_MaxDetect(C5:C13)","v":328},328,14.3,109,174,1380,1.6,7.94,49,7.82,16,10.4,107,183,762,6.0000000000000001E-3,5.0000000000000001E-3,7.6999999999999999E-2,6.4000000000000001E-2,0.22,0.25,{"$f":" ESDAT_MaxDetect(X5:X13)","v":7.0000000000000001E-3},3.11,2.72,4.8000000000000001E-2,4.9000000000000002E-2,7.4999999999999997E-2,7.1999999999999995E-2,{"$f":" ESDAT_MaxDetect(AE5:AE13)","v":3.9E-2},{"$f":" ESDAT_MaxDetect(AF5:AF13)","v":0.03},2.7E-2,2.7E-2,0.92400000000000004,0.80500000000000005,7.3999999999999996E-2,1.7,0.68,{"$f":" ESDAT_MaxDetect(AN5:AN13)","v":1.41}]
[null,"Average Concentration",{"$f":" ESDAT_AvgValue(C5:C13,0.5)","v":300},300,14,89,162,1254,1.4,4.3,41,7.5,15,9.6999999999999993,98,143,696,5.0000000000000001E-3,4.4000000000000003E-3,6.4000000000000001E-2,0.06,0.21,0.21,{"$f":" ESDAT_AvgValue(X5:X13,0.5)","v":1.6000000000000001E-3},1.7,1.2,4.2999999999999997E-2,4.2000000000000003E-2,2.9000000000000001E-2,2.7E-2,{"$f":" ESDAT_AvgValue(AE5:AE13,0.5)","v":1.0999999999999999E-2},{"$f":" ESDAT_AvgValue(AF5:AF13,0.5)","v":8.3000000000000001E-3},7.3000000000000001E-3,5.7000000000000002E-3,0.8,0.75,2.5000000000000001E-2,1.4,0.47,{"$f":" ESDAT_AvgValue(AN5:AN13,0.5)","v":0.67}]
[null,"Median Concentration",{"$f":" ESDAT_MedianValue(C5:C13,0.5)","v":298},298,13.4,87,164,1260,1.4,4.12,41,7.51,15,9.57,96,136,683,5.0000000000000001E-3,5.0000000000000001E-3,6.3E-2,6.2E-2,0.21,0.2,{"$f":" ESDAT_MedianValue(X5:X13,0.5)","v":5.0000000000000001E-4},1.74,0.89,4.2000000000000003E-2,0.04,2.4E-2,2.3E-2,{"$f":" ESDAT_MedianValue(AE5:AE13,0.5)","v":5.0000000000000001E-3},{"$f":" ESDAT_MedianValue(AF5:AF13,0.5)","v":5.0000000000000001E-3},5.0000000000000001E-3,3.0000000000000001E-3,0.78800000000000003,0.75900000000000001,2.1000000000000001E-2,1.43,0.41,{"$f":" ESDAT_MedianValue(AN5:AN13,0.5)","v":0.52}]
[null,"Standard Deviation",{"$f":" ESDAT_StdDev(C5:C13,0.5)","v":18},18,0.37,8.1999999999999993,6.6,60,9.2999999999999999E-2,2.4,3.3,0.14000000000000001,0.97,0.56000000000000005,5.4,21,53,8.7000000000000001E-4,7.2999999999999996E-4,5.4000000000000003E-3,5.4000000000000003E-3,1.2999999999999999E-2,1.9E-2,{"$f":" ESDAT_StdDev(X5:X13,0.5)","v":2.0999999999999999E-3},0.97,0.85,2.5000000000000001E-3,3.8E-3,1.7999999999999999E-2,1.7999999999999999E-2,{"$f":" ESDAT_StdDev(AE5:AE13,0.5)","v":1.2E-2},{"$f":" ESDAT_StdDev(AF5:AF13,0.5)","v":8.3000000000000001E-3},7.7999999999999996E-3,8.3000000000000001E-3,5.3999999999999999E-2,5.7000000000000002E-2,0.02,0.24,0.14000000000000001,{"$f":" ESDAT_StdDev(AN5:AN13,0.5)","v":0.44}]
[null,"50th percentile",{"$f":"PERCENTILE(C5:C13,0.5)","v":298},298,13.4,87,164,1260,1.4,4.12,41,7.51,15,9.57,96,136,683,5.0000000000000001E-3,5.0000000000000001E-3,6.3E-2,6.2E-2,0.21,0.2,{"$f":"PERCENTILE(X5:X13,0.5)","v":2E-3},1.74,0.89,4.2000000000000003E-2,0.04,2.4E-2,2.3E-2,{"$f":"PERCENTILE(AE5:AE13,0.5)","v":2.1999999999999999E-2},{"$f":"PERCENTILE(AF5:AF13,0.5)","v":1.9999999999999997E-2},5.4999999999999997E-3,4.0000000000000001E-3,0.78800000000000003,0.75900000000000001,2.1000000000000001E-2,1.43,0.41,{"$f":"PERCENTILE(AN5:AN13,0.5)","v":0.52}]
[null,"75th percentile",{"$f":"PERCENTILE(C5:C13,0.75)","v":307},307,13.7,89,165,1260,1.4,6.22,41,7.58,15,10.199999999999999,102,158,746,6.0000000000000001E-3,5.0000000000000001E-3,6.6000000000000003E-2,6.2E-2,0.22,0.22,{"$f":"PERCENTILE(X5:X13,0.75)","v":3.2500000000000003E-3},2.54,1.59,4.2999999999999997E-2,4.3999999999999997E-2,2.9000000000000001E-2,2.4E-2,{"$f":"PERCENTILE(AE5:AE13,0.75)","v":3.0499999999999999E-2},{"$f":"PERCENTILE(AF5:AF13,0.75)","v":2.4999999999999998E-2},8.0000000000000002E-3,6.0000000000000001E-3,0.80900000000000005,0.79200000000000004,2.5999999999999999E-2,1.44,0.52,{"$f":"PERCENTILE(AN5:AN13,0.75)","v":0.68}]
["RN41136 (BET-MB024)","2021-04-26T14:00:00",299,299,13.4,99,162,1230,1.4,1.02,40,7.74,17,10.1,103,138,698,4.0000000000000001E-3,3.0000000000000001E-3,0.06,5.8000000000000003E-2,0.22,0.24,8.9999999999999993E-3,3.31,2.14,4.2999999999999997E-2,4.3999999999999997E-2,3.1E-2,3.1E-2,1.9E-2,0.02,6.0000000000000001E-3,"<0.001",0.79800000000000004,0.75800000000000001,2.7E-2,"-",1.56,0.56000000000000005]
[null,"Ratio",{"$f":"C25/C24","v":0.97394136807817588},{"$f":"D25/D24","v":0.97394136807817588},0.97810218978102192,1.1123595505617978,0.98181818181818181,0.97619047619047616,1,0.16398713826366559,0.97560975609756095,1.0211081794195251,1.1333333333333333,0.99019607843137258,1.0098039215686274,0.87341772151898733,0.93565683646112596,0.66666666666666663,0.6,0.90909090909090906,0.93548387096774199,1,1.0909090909090908,{"$f":"X25/X24","v":2.7692307692307687},1.3031496062992125,1.3459119496855345,1,1,1.0689655172413792,1.2916666666666667,{"$f":"AE25/AE24","v":0.62295081967213117},{"$f":"AF25/AF24","v":0.8},0.75,{"$error":"#VALUE!"},0.98640296662546356,0.95707070707070707,1.0384615384615385,{"$error":"#VALUE!"},3,{"$f":"AN25/AN24","v":0.82352941176470595}]
[null,"75th percentile exceedance",{"$f":"IF(C26>1,TRUE)","v":false},{"$f":"IF(D26>1,TRUE)","v":false},false,true,false,false,false,false,false,true,true,false,true,false,false,false,false,false,false,false,true,{"$f":"IF(X26>1,TRUE)","v":true},true,true,false,false,true,true,{"$f":"IF(AE26>1,TRUE)","v":false},{"$f":"IF(AF26>1,TRUE)","v":false},false,{"$error":"#VALUE!"},false,false,true,{"$error":"#VALUE!"},true,{"$f":"IF(AN26>1,TRUE)","v":false},{"$f":"COUNTIF(C27:AN27, TRUE)","v":12}]

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

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

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