{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Chemistry Output Table"],"not_rendered":{"charts":0,"images":3,"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":31,"n_cols":41,"rows_kept":31,"cut":false,"hidden":false,"merged":[[17,0,27,0],[28,0,30,0],[0,0,0,1]]}
["Statistical analysis of water quality data for Kyalla 117 Gum Ridge Formation monitoring",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","Zinc (filtered)","Gross alpha","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","mg/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,5.0000000000000001E-3,0.05,0.1]
["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,5.0000000000000001E-3,4.0000000000000001E-3,7.6999999999999999E-2,6.2E-2,0.22,0.25,7.0000000000000001E-3,0.69,0.89,4.8000000000000001E-2,4.9000000000000002E-2,2.1000000000000001E-2,7.1999999999999995E-2,"<0.01",0.01,2.7E-2,2.7E-2,0.8,0.80500000000000005,7.3999999999999996E-2,4.3999999999999997E-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.7000000000000004E-2,0.06,0.2,0.2,"<0.001",2.54,0.47,4.3999999999999997E-2,0.04,7.4999999999999997E-2,2.4E-2,"<0.01","<0.01",5.0000000000000001E-3,6.0000000000000001E-3,0.77600000000000002,0.75900000000000001,0.02,8.9999999999999993E-3," - "," - "]
["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,4.0000000000000001E-3,4.0000000000000001E-3,6.4000000000000001E-2,6.2E-2,0.21,0.21,"<0.001",0.5,0.6,4.1000000000000002E-2,0.04,2.4E-2,1.7000000000000001E-2,"<0.01","<0.01",4.0000000000000001E-3,3.0000000000000001E-3,0.77800000000000002,0.72,1.0999999999999999E-2,"<0.005",1.1200000000000001,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,6.3E-2,0.06,0.22,0.2,1E-3,0.67,0.53,4.2999999999999997E-2,3.7999999999999999E-2,1.9E-2,1.6E-2,"<0.01",0.03,8.0000000000000002E-3,4.0000000000000001E-3,0.92400000000000004,0.69399999999999995,2.5999999999999999E-2,0.02,1.1599999999999999,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,6.0000000000000001E-3,1.7,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,"<0.005",1.43,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,1.0999999999999999E-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,6.0000000000000001E-3,1.44,0.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,5.0000000000000001E-3," - ","-"]
["RN41132 (BET-MB022)","2020-10-10T14:00:00",305,305,13.5,104,169,1270,1.3,2.77,37,7.47,16,9.64,95,127,718,4.0000000000000001E-3,4.0000000000000001E-3,6.2E-2,5.8999999999999997E-2,0.24,0.19,"<0.001",2.2999999999999998,2.2599999999999998,4.7E-2,0.04,0.03,2.9000000000000001E-2,1.4E-2,"<0.01",1E-3,"<0.001",0.80800000000000005,0.745,"<0.005","<0.005",1.47,0.52]
["RN41132 (BET-MB022)","2020-11-06T16:00:00",341,341,13.7,88,160,1180,1.3,7.13,36,7.62,15,10.5,96,116,688,4.0000000000000001E-3,4.0000000000000001E-3,6.0999999999999999E-2,6.2E-2,0.21,0.2,"<0.001",2.3199999999999998,1.85,4.3999999999999997E-2,4.2999999999999997E-2,2.4E-2,2.1999999999999999E-2,2.1999999999999999E-2,"<0.01",1E-3,"<0.001",0.79,0.79600000000000004,"<0.005","<0.005",1.29,0.42]
["RN41132 (BET-MB022)","2021-01-19",324,324,14,88,180,1190,1.4,5.75,40,7.61,15,10.1,102,119,736,4.0000000000000001E-3,4.0000000000000001E-3,6.0999999999999999E-2,0.06,0.22,0.18,1E-3,2.48,2.23,4.3999999999999997E-2,0.04,2.8000000000000001E-2,2.7E-2,2.5000000000000001E-2,"<0.01","<0.001","<0.001",0.79200000000000004,0.73799999999999999,"<0.005","<0.005",1.24,0.51]
["RN41132 (BET-MB022)","2021-04-26T14:00:00",301,301,13.2,98,157,1190,1.5,0.88,40,7.7,16,10.1,100,131,684,4.0000000000000001E-3,4.0000000000000001E-3,6.3E-2,6.0999999999999999E-2,0.21,0.23,"<0.001",2.44,2.17,0.04,4.2999999999999997E-2,2.5000000000000001E-2,2.3E-2,3.7999999999999999E-2,0.01,1E-3,"<0.001",0.76600000000000001,0.745,1.2E-2,"<0.005",1.64,0.7]
["Statistical Analysis of Gum Ridge Formation baseline water quality","Number of Results",{"$f":" ESDAT_CountValues(C5:C17)","v":13},13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,{"$f":" ESDAT_CountValues(X5:X17)","v":13},13,13,13,13,13,13,{"$f":" ESDAT_CountValues(AE5:AE17)","v":13},{"$f":" ESDAT_CountValues(AF5:AF17)","v":13},13,13,13,13,13,{"$f":" ESDAT_CountValues(AL5:AL17)","v":13},9,11]
[null,"Number of Detects",{"$f":" ESDAT_CountDetects(C5:C17)","v":13},13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,{"$f":" ESDAT_CountDetects(X5:X17)","v":5},13,13,13,13,13,13,{"$f":" ESDAT_CountDetects(AE5:AE17)","v":7},{"$f":" ESDAT_CountDetects(AF5:AF17)","v":3},11,7,13,13,10,{"$f":" ESDAT_CountDetects(AL5:AL17)","v":7},9,11]
[null,"Minimum Concentration",{"$f":" ESDAT_MinValue(C5:C17)","v":271},271,13,82,151,1170,1.3,0.88,36,7.36,13,8.68,92,116,630,4.0000000000000001E-3,3.0000000000000001E-3,5.8000000000000003E-2,4.5999999999999999E-2,0.18,0.18,{"$f":" ESDAT_MinValue(X5:X17)","v":"<0.001"},0.5,0.47,3.9E-2,3.6999999999999998E-2,1.7000000000000001E-2,1.4999999999999999E-2,{"$f":" ESDAT_MinValue(AE5:AE17)","v":"<0.01"},{"$f":" ESDAT_MinValue(AF5:AF17)","v":"<0.01"},"<0.001","<0.001",0.73699999999999999,0.63400000000000001,"<0.005",{"$f":" ESDAT_MinValue(AL5:AL17)","v":"<0.005"},1.1200000000000001,0.35]
[null,"Minimum Detect",{"$f":" ESDAT_MinDetect(C5:C17)","v":271},271,13,82,151,1170,1.3,0.88,36,7.36,13,8.68,92,116,630,4.0000000000000001E-3,3.0000000000000001E-3,5.8000000000000003E-2,4.5999999999999999E-2,0.18,0.18,{"$f":" ESDAT_MinDetect(X5:X17)","v":1E-3},0.5,0.47,3.9E-2,3.6999999999999998E-2,1.7000000000000001E-2,1.4999999999999999E-2,{"$f":" ESDAT_MinDetect(AE5:AE17)","v":0.01},{"$f":" ESDAT_MinDetect(AF5:AF17)","v":0.01},1E-3,2E-3,0.73699999999999999,0.63400000000000001,8.0000000000000002E-3,{"$f":" ESDAT_MinDetect(AL5:AL17)","v":5.0000000000000001E-3},1.1200000000000001,0.35]
[null,"Maximum Concentration",{"$f":" ESDAT_MaxValue(C5:C17)","v":341},341,14.3,109,180,1380,1.6,7.94,49,7.82,16,10.5,107,183,762,6.0000000000000001E-3,5.0000000000000001E-3,7.6999999999999999E-2,6.4000000000000001E-2,0.24,0.25,{"$f":" ESDAT_MaxValue(X5:X17)","v":7.0000000000000001E-3},3.11,2.72,4.8000000000000001E-2,4.9000000000000002E-2,7.4999999999999997E-2,7.1999999999999995E-2,{"$f":" ESDAT_MaxValue(AE5:AE17)","v":3.9E-2},{"$f":" ESDAT_MaxValue(AF5:AF17)","v":0.03},2.7E-2,2.7E-2,0.92400000000000004,0.80500000000000005,7.3999999999999996E-2,{"$f":" ESDAT_MaxValue(AL5:AL17)","v":4.3999999999999997E-2},1.7,0.7]
[null,"Maximum Detect",{"$f":" ESDAT_MaxDetect(C5:C17)","v":341},341,14.3,109,180,1380,1.6,7.94,49,7.82,16,10.5,107,183,762,6.0000000000000001E-3,5.0000000000000001E-3,7.6999999999999999E-2,6.4000000000000001E-2,0.24,0.25,{"$f":" ESDAT_MaxDetect(X5:X17)","v":7.0000000000000001E-3},3.11,2.72,4.8000000000000001E-2,4.9000000000000002E-2,7.4999999999999997E-2,7.1999999999999995E-2,{"$f":" ESDAT_MaxDetect(AE5:AE17)","v":3.9E-2},{"$f":" ESDAT_MaxDetect(AF5:AF17)","v":0.03},2.7E-2,2.7E-2,0.92400000000000004,0.80500000000000005,7.3999999999999996E-2,{"$f":" ESDAT_MaxDetect(AL5:AL17)","v":4.3999999999999997E-2},1.7,0.7]
[null,"Average Concentration",{"$f":" ESDAT_AvgValue(C5:C17,0.5)","v":305},305,14,91,163,1240,1.4,4.2,40,7.6,15,9.8000000000000007,98,137,699,4.7000000000000002E-3,4.3E-3,6.4000000000000001E-2,0.06,0.21,0.21,{"$f":" ESDAT_AvgValue(X5:X17,0.5)","v":1.2999999999999999E-3},1.9,1.5,4.2999999999999997E-2,4.2000000000000003E-2,2.8000000000000001E-2,2.5999999999999999E-2,{"$f":" ESDAT_AvgValue(AE5:AE17,0.5)","v":1.4999999999999999E-2},{"$f":" ESDAT_AvgValue(AF5:AF17,0.5)","v":7.7000000000000002E-3},5.3E-3,4.1000000000000003E-3,0.8,0.75,1.9E-2,{"$f":" ESDAT_AvgValue(AL5:AL17,0.5)","v":8.8999999999999999E-3},1.4,0.5]
[null,"Median Concentration",{"$f":" ESDAT_MedianValue(C5:C17,0.5)","v":305},305,13.5,88,164,1250,1.4,4.12,40,7.56,15,9.870000000000001,96,131,688,4.0000000000000001E-3,4.0000000000000001E-3,6.2E-2,6.2E-2,0.21,0.2,{"$f":" ESDAT_MedianValue(X5:X17,0.5)","v":5.0000000000000001E-4},2.2999999999999998,1.59,4.2999999999999997E-2,0.04,2.4E-2,2.3E-2,{"$f":" ESDAT_MedianValue(AE5:AE17,0.5)","v":0.01},{"$f":" ESDAT_MedianValue(AF5:AF17,0.5)","v":5.0000000000000001E-3},4.0000000000000001E-3,2E-3,0.79,0.745,1.2E-2,{"$f":" ESDAT_MedianValue(AL5:AL17,0.5)","v":5.0000000000000001E-3},1.43,0.51]
[null,"Standard Deviation",{"$f":" ESDAT_StdDev(C5:C17,0.5)","v":19},19,0.35,8.1,7.8,58,9.0999999999999998E-2,2.4,3.2,0.13,0.91,0.52,4.7,20,46,8.4999999999999995E-4,6.3000000000000003E-4,4.5999999999999999E-3,4.4999999999999997E-3,1.4E-2,0.02,{"$f":" ESDAT_StdDev(X5:X17,0.5)","v":1.8E-3},0.87,0.83,2.5999999999999999E-3,3.2000000000000002E-3,1.4999999999999999E-2,1.4E-2,{"$f":" ESDAT_StdDev(AE5:AE17,0.5)","v":1.2999999999999999E-2},{"$f":" ESDAT_StdDev(AF5:AF17,0.5)","v":7.0000000000000001E-3},7.1000000000000004E-3,7.1999999999999998E-3,4.4999999999999998E-2,4.9000000000000002E-2,1.9E-2,{"$f":" ESDAT_StdDev(AL5:AL17,0.5)","v":1.2E-2},0.2,0.13]
[null,"50th percentile",{"$f":"PERCENTILE(C5:C17,0.5)","v":305},305,13.5,88,164,1250,1.4,4.12,40,7.56,15,9.870000000000001,96,131,688,4.0000000000000001E-3,4.0000000000000001E-3,6.2E-2,6.2E-2,0.21,0.2,{"$f":"PERCENTILE(X5:X17,0.5)","v":2E-3},2.2999999999999998,1.59,4.2999999999999997E-2,0.04,2.4E-2,2.3E-2,{"$f":"PERCENTILE(AE5:AE17,0.5)","v":2.1999999999999999E-2},{"$f":"PERCENTILE(AF5:AF17,0.5)","v":0.01},5.0000000000000001E-3,4.0000000000000001E-3,0.79,0.745,2.0500000000000001E-2,{"$f":"PERCENTILE(AL5:AL17,0.5)","v":8.9999999999999993E-3},1.43,0.51]
[null,"75th percentile",{"$f":"PERCENTILE(C5:C17,0.75)","v":320},320,13.7,94,166,1260,1.4,6.22,41,7.62,16,10.199999999999999,102,138,744,5.0000000000000001E-3,5.0000000000000001E-3,6.4000000000000001E-2,6.2E-2,0.22,0.22,{"$f":"PERCENTILE(X5:X17,0.75)","v":2E-3},2.48,2.23,4.3999999999999997E-2,4.2999999999999997E-2,2.9000000000000001E-2,2.7E-2,{"$f":"PERCENTILE(AE5:AE17,0.75)","v":3.15E-2},{"$f":"PERCENTILE(AF5:AF17,0.75)","v":1.9999999999999997E-2},7.0000000000000001E-3,6.0000000000000001E-3,0.80800000000000005,0.79200000000000004,2.5999999999999999E-2,{"$f":"PERCENTILE(AL5:AL17,0.75)","v":1.55E-2},1.47,0.52]
["RN41136 (BET-MB024)","2021-07-10T14:30:00",284,284,12.4,90,153,1160,1.2,0.46,38,7.57,16,10.1,99,118,720,5.0000000000000001E-3,4.0000000000000001E-3,5.2999999999999999E-2,6.8000000000000005E-2,0.24,0.26,"<0.001",2.13,1.31,4.8000000000000001E-2,4.7E-2,2.5999999999999999E-2,2.4E-2,1.9E-2,"<0.01",6.0000000000000001E-3,"<0.001",0.79800000000000004,0.73899999999999999,"<0.005","<0.005",1.55,1.56]
[null,"Ratio",{"$f":"C29/C28","v":0.88749999999999996},{"$f":"D29/D28","v":0.88749999999999996},0.90510948905109501,0.95744680851063835,0.92168674698795183,0.92063492063492058,0.85714285714285721,7.3954983922829592E-2,0.92682926829268297,0.9934383202099738,1,0.99019607843137258,0.97058823529411764,0.85507246376811596,0.967741935483871,1,0.8,0.828125,1.0967741935483872,1.0909090909090908,1.1818181818181819,0.5,0.8588709677419355,0.58744394618834084,1.0909090909090911,1.0930232558139537,0.89655172413793094,0.88888888888888895,{"$f":"AE29/AE28","v":0.60317460317460314},0.5,0.8571428571428571,0.16669999999999999,0.98762376237623761,0.93308080808080807,0.1923,0.3226,1.0544217687074831,3]
[null,"75th percentile exceedance",{"$f":"IF(C30>1,TRUE)","v":false},{"$f":"IF(D30>1,TRUE)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,true,true,true,{"$f":"IF(X30>1,TRUE)","v":false},false,false,true,true,false,false,{"$f":"IF(AE30>1,TRUE)","v":false},{"$f":"IF(AF30>1,TRUE)","v":false},false,false,false,false,false,false,true,true,{"$f":"COUNTIF(C31:AN31, TRUE)","v":7}]