{"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":37,"n_cols":43,"rows_kept":37,"cut":false,"hidden":false,"merged":[[23,0,33,0],[34,0,36,0],[0,0,0,1]]}
["Statistical analysis of water quality data for Kyalla 117 Anthony Lagoon Beds monitoring",null,"Alkalinity (Bicarbonate) as CaCO3","Alkalinity (Total) as CaCO3","Anions Total","Bicarbonate","Calcium (Filtered)","Carbonate","Cations Total","Chloride","Electrical Conductivity (Lab)","Fluoride","Ionic Balance","Magnesium (Filtered)","Methane","Nitrate (as N)","Nitrite + Nitrate (as N)","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)","Iron","Iron (Filtered)","Lithium","Lithium (Filtered)","Manganese","Manganese (Filtered)","Nickel","Strontium","Strontium (Filtered)","Zinc","Zinc (Filtered)","Gross alpha","Gross beta activity - 40K"]
[null,null,"mg/L","mg/L","meq/L","mg/L","mg/L","mg/L","meq/L","mg/L","µS/cm","mg/L","%","mg/L","mg/L","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","Bq/L","Bq/L"]
["EQL",null,1,1,0.01,null,1,null,0.01,1,1,0.1,0.01,1,0.01,0.01,0.01,0.01,1,0.05,1,1,10,1E-3,1E-3,1E-3,1E-3,0.05,0.05,0.05,0.05,1E-3,1E-3,1E-3,1E-3,1E-3,1E-3,1E-3,5.0000000000000001E-3,5.0000000000000001E-3,0.05,0.1]
["Location_Code","Sampled_Date_Time"]
["RN40896 (BET-MB021)","2019-02-01T15:50:00",292,292,13.1,356.24,81,0.6,12.5,157,1090,1,2.11,41,"<0.01",7.0000000000000007E-2,7.0000000000000007E-2,7.31,13,9.73,110,135,787,2E-3,2E-3,0.06,5.0999999999999997E-2,0.25,0.22,0.68,0.4,5.6000000000000001E-2,5.1999999999999998E-2,2.3E-2,1.7000000000000001E-2,2E-3,0.69399999999999995,0.61099999999999999,1.7999999999999999E-2,8.0000000000000002E-3,0.46,0.42]
["RN40896 (BET-MB021)","2019-02-23T13:30:00","259 - 261","259 - 261","13.9 - 14.1","315.98 - 318.42","79 - 82",0.6,"12 - 12.3","190 - 192","1180 - 1190","0.9 - 1","6.84 - 7.35",40,"<0.01",0.02,0.02,"7.39 - 7.43",12,"10 - 10.1","104 - 106","164 - 167","712 - 738","0.007 - 0.008",4.0000000000000001E-3,"0.122 - 0.127","0.104 - 0.105","0.2 - 0.21","0.19 - 0.2","2.56 - 2.8","<0.05","0.066 - 0.068","0.056 - 0.058","0.119 - 0.124","0.076 - 0.078","0.001 - 0.003","0.673 - 0.686","0.564 - 0.59","0.011 - 0.012","<0.005","0.32 - 0.34","0.28 - 0.34"]
["RN40896 (BET-MB021)","2019-03-20T14:10:00",268,268,12.9,326.95999999999998,88,0.6,13.6,168,1150,1,2.57,45,"<0.01",0.04,0.04,7.51,14,11.6,119,137,716,3.0000000000000001E-3,3.0000000000000001E-3,0.08,8.6999999999999994E-2,0.22,0.23,0.53,0.6,5.1999999999999998E-2,5.5E-2,4.7E-2,0.05,1.6E-2,0.73599999999999999,0.71799999999999997,2.5999999999999999E-2,7.0000000000000001E-3,0.39,0.19]
["RN40896 (BET-MB021)","2019-05-03T12:30:00","246 - 248","246 - 248","11.9 - 12.1","300.12 - 302.56","70 - 71",0.6,"11.7 - 11.8",174,"1180 - 1190",1.1000000000000001,"0.96 - 1.03",40,"0.03 - 0.042","0.04 - 0.05","0.04 - 0.05","7.43 - 7.46",12,"9.16 - 9.25","106 - 108","102 - 106","701 - 704","0.006 - 0.007",6.0000000000000001E-3,"0.085 - 0.089","0.081 - 0.082",0.2,0.2,"0.6 - 0.65","0.52 - 0.57","0.05 - 0.051","0.048 - 0.05","0.045 - 0.047","0.04 - 0.042","<0.001","0.624 - 0.631","0.594 - 0.611","<0.005","<0.005","0.29 - 0.36","0.16 - 0.23"]
["RN40896 (BET-MB021)","2019-06-03T13:45:00",249,249,12.6,303.77999999999997,82,0.6,12.9,164,1340,1,1.03,42,4.2000000000000003E-2,"<0.01","<0.01",7.68,13,10.1,115,145,682,6.0000000000000001E-3,5.0000000000000001E-3,8.4000000000000005E-2,7.6999999999999999E-2,0.21,0.21,1.66,1.55,5.0999999999999997E-2,5.0999999999999997E-2,6.7000000000000004E-2,6.3E-2,1.7999999999999999E-2,0.70699999999999996,0.629,9.8000000000000004E-2,1.4999999999999999E-2,0.32,0.18]
["RN40896 (BET-MB021)","2019-07-04T04:35:00",245,245,12,298.89999999999998,83,0.6,12.6,167,1370,1.1000000000000001,2.2999999999999998,41,2.9000000000000001E-2,0.01,0.01,7.72,12,9.84,110,117,698,5.0000000000000001E-3,4.0000000000000001E-3,7.9000000000000001E-2,7.4999999999999997E-2,0.23,0.22,0.69,0.55000000000000004,5.0999999999999997E-2,5.2999999999999999E-2,4.2999999999999997E-2,4.1000000000000002E-2,1E-3,0.67900000000000005,0.65700000000000003,1.2E-2,"<0.005",0.32,0.12]
["RN40896 (BET-MB021)","2019-08-17T03:15:00",224,224,13,273.27999999999997,83,0.6,13,181,1200,1,0.03,45,2.1000000000000001E-2,0.02,0.02,7.47,13,10.1,110,162,750,3.0000000000000001E-3,3.0000000000000001E-3,6.7000000000000004E-2,6.4000000000000001E-2,0.18,0.21,1.0900000000000001,0.89,5.8999999999999997E-2,6.3E-2,5.1999999999999998E-2,4.5999999999999999E-2,3.0000000000000001E-3,0.65,0.65,1.6E-2,"<0.005"," - "," - "]
["RN40896 (BET-MB021)","2019-09-14T14:00:00",244,244,13.1,297.68,76,0.6,11.9,172,1250,1.1000000000000001,4.91,41,4.2999999999999997E-2,0.02,0.02,7.59,12,9.51,102,164,754,2E-3,2E-3,6.3E-2,0.06,0.2,0.21,0.69,0.78,5.6000000000000001E-2,6.3E-2,4.1000000000000002E-2,4.2999999999999997E-2,1E-3,0.627,0.61799999999999999,0.01,8.9999999999999993E-3," - "," - "]
["RN40896 (BET-MB021)","2019-10-16T12:33:00",256,256,13,312.32,78,0.6,12.1,175,1270,1.1000000000000001,3.26,41,"<0.01",0.05,0.05,7.85,14,9.4700000000000006,104,140,664,1E-3,1E-3,6.2E-2,5.8999999999999997E-2,0.22,0.21,0.57999999999999996,0.45,5.1999999999999998E-2,4.3999999999999997E-2,3.4000000000000002E-2,0.03,"<0.001",0.63,0.60299999999999998,9.4E-2,7.3999999999999996E-2,0.26,0.15]
["RN40896 (BET-MB021)","2019-10-16T12:45:00",264,264,13.2,322.08,78,0.6,12.2,177,1270,1.1000000000000001,3.72,41,"<0.01",0.04,0.04,7.89,14,9.32,106,140,692,1E-3,1E-3,6.4000000000000001E-2,0.06,0.23,0.2,0.54,0.4,5.2999999999999999E-2,4.4999999999999998E-2,3.3000000000000002E-2,2.9000000000000001E-2,"<0.001",0.65100000000000002,0.61,0.08,7.2999999999999995E-2,0.27,0.13]
["RN40896 (BET-MB021)","2019-11-26T13:30:00",276,276,13,336.72,74,0.6,12.2,169,1190,1,3.08,42,"<0.01",0.03,0.03,7.64,15,10.3,108,131,672,1E-3,1E-3,6.5000000000000002E-2,6.4000000000000001E-2,0.21,0.2,1.25,0.88,4.4999999999999998E-2,4.2999999999999997E-2,3.7999999999999999E-2,3.6999999999999998E-2,"<0.001",0.64200000000000002,0.65500000000000003,0.155,0.13500000000000001,0.36,0.32]
["RN40896 (BET-MB021)","2019-12-17T13:30:00",292,292,13.6,356.24,72,0.6,11.8,165,1220,1,6.94,38,"<0.01",0.03,0.03,7.88,16,10.8,108,149,685,"<0.001","<0.001",6.0999999999999999E-2,5.2999999999999999E-2,0.21,0.22,0.25,0.17,4.4999999999999998E-2,4.2000000000000003E-2,1.4E-2,0.01,"<0.001",0.63400000000000001,0.59,2.5000000000000001E-2,1.7000000000000001E-2,0.32,0.23]
["RN40896 (BET-MB021)","2020-03-25T13:30:00",288,288,13.6,351.36,78,0.6,11.7,179,1190,1,7.37,38,"<0.01",0.03,0.03,7.65,15,10.6,99,133,696,"<0.001","<0.001",5.7000000000000002E-2,5.7000000000000002E-2,0.19,0.27,1.39,0.32,4.2000000000000003E-2,4.5999999999999999E-2,1.7000000000000001E-2,1.0999999999999999E-2,"<0.001",0.626,0.61399999999999999,7.0000000000000001E-3,6.0000000000000001E-3," - "," - "]
["RN40896 (BET-MB021)","2020-05-24",294,294,13.3,358.68,75,0.6,11.8,169,1170,1.1000000000000001,6.13,38,"<0.01",0.02,0.02,7.87,12,11.4,106,129,667,"<0.001","<0.001",5.7000000000000002E-2,5.6000000000000001E-2,0.21,0.21,0.93,0.66,4.3999999999999997E-2,4.2999999999999997E-2,2.7E-2,2.8000000000000001E-2,"<0.001",0.64300000000000002,0.61299999999999999,3.7999999999999999E-2,3.7999999999999999E-2,0.27,"<0.1"]
["RN40896 (BET-MB021)","2020-08-05",302,302,13.2,368.44,81,0.6,12.6,163,1380,1.2,2.0299999999999998,41,0.03,"<0.01","<0.01",7.53,15,"-",111,121,699,"<0.001","<0.001",5.8000000000000003E-2,0.05,0.2,0.2,1.01,0.39,4.4999999999999998E-2,0.04,2.7E-2,2.4E-2,"<0.001",0.68700000000000006,0.56899999999999995,1.7999999999999999E-2,0.01,"-","-"]
["RN40896 (BET-MB021)","2020-10-10",null,null,13.3,357.46,92,0.6,12.5,172,1240,1,3.21,37,7.2000000000000008E-2,"<0.01","<0.01",7.51,15,9.43,103,126,657,"<0.001","<0.001",6.2E-2,5.6000000000000001E-2,0.25,0.2,1.26,1.1499999999999999,5.1999999999999998E-2,4.2999999999999997E-2,3.5999999999999997E-2,3.7999999999999999E-2,1E-3,0.69499999999999995,0.63600000000000001,6.2E-2,5.6000000000000001E-2,0.3,0.17]
["RN40896 (BET-MB021)","2020-11-06",null,null,13.2,367.21999999999997,82,0.6,11.9,166,1150,1,4.9400000000000004,37,1.4999999999999999E-2,0.02,0.02,7.48,15,10.8,101,118,692,"<0.001","<0.001",5.8000000000000003E-2,5.7000000000000002E-2,0.21,0.2,0.56999999999999995,0.48,4.5999999999999999E-2,4.5999999999999999E-2,2.4E-2,2.4E-2,"<0.001",0.66100000000000003,0.65700000000000003,0.03,2.8000000000000001E-2,0.28000000000000003,0.18]
["RN40896 (BET-MB021)","2021-01-19",null,null,13.3,363.56,80,0.6,12.3,177,1160,1.1000000000000001,3.9,40,5.2000000000000005E-2,0.01,0.01,7.57,14,10.1,108,115,710,"<0.001","<0.001",5.8999999999999997E-2,5.7000000000000002E-2,0.24,0.17,1.45,0.9,4.8000000000000001E-2,4.2999999999999997E-2,3.4000000000000002E-2,2.7E-2,"<0.001",0.65200000000000002,0.59599999999999997,5.1999999999999998E-2,6.9000000000000006E-2,"-",0.21]
["RN40896 (BET-MB021)","2021-04-26",298,298,13,348.92,91,0.6,12.8,135,1180,1.2,0.87,40,"<0.01",0.04,0.04,7.74,15,10.6,105,139,650,"<0.001","<0.001",5.5E-2,5.5E-2,0.21,0.24,0.49,0.45,4.2999999999999997E-2,4.7E-2,0.02,1.7999999999999999E-2,"<0.001",0.64300000000000002,0.624,3.9E-2,4.1000000000000002E-2,"-",0.19]
["Statistical Analysis of Anthony Lagoon Beds baseline water quality","Number of Results",{"$f":" ESDAT_CountValues(C5:C23)","v":16},16,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,16,16]
[null,"Number of Detects",{"$f":" ESDAT_CountDetects(C5:C23)","v":16},16,19,19,19,19,19,19,19,19,19,19,9,16,16,19,19,19,19,19,19,11,11,19,19,19,19,19,18,19,19,19,19,8,19,19,18,15,16,15]
[null,"Minimum Concentration",{"$f":" ESDAT_MinValue(C5:C23)","v":224},224,11.9,273.27999999999997,70,0.6,11.7,135,1090,0.9,0.03,37,"<0.01","<0.01","<0.01",7.31,12,9.16,99,102,650,"<0.001","<0.001",5.5E-2,0.05,0.18,0.17,0.25,"<0.05",4.2000000000000003E-2,0.04,1.4E-2,0.01,"<0.001",0.624,0.56399999999999995,"<0.005","<0.005",0.26,"<0.1"]
[null,"Minimum Detect",{"$f":" ESDAT_MinDetect(C5:C23)","v":224},224,11.9,273.27999999999997,70,0.6,11.7,135,1090,0.9,0.03,37,1.4999999999999999E-2,0.01,0.01,7.31,12,9.16,99,102,650,1E-3,1E-3,5.5E-2,0.05,0.18,0.17,0.25,0.17,4.2000000000000003E-2,0.04,1.4E-2,0.01,1E-3,0.624,0.56399999999999995,7.0000000000000001E-3,6.0000000000000001E-3,0.26,0.12]
[null,"Maximum Concentration",{"$f":" ESDAT_MaxValue(C5:C23)","v":302},302,14.1,368.44,92,0.6,13.6,192,1380,1.2,7.37,45,7.1999999999999995E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.89,16,11.6,119,167,787,8.0000000000000002E-3,6.0000000000000001E-3,0.127,0.105,0.25,0.27,2.8,1.55,6.8000000000000005E-2,6.3E-2,0.124,7.8E-2,1.7999999999999999E-2,0.73599999999999999,0.71799999999999997,0.155,0.13500000000000001,0.46,0.42]
[null,"Maximum Detect",{"$f":" ESDAT_MaxDetect(C5:C23)","v":302},302,14.1,368.44,92,0.6,13.6,192,1380,1.2,7.37,45,7.1999999999999995E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.89,16,11.6,119,167,787,8.0000000000000002E-3,6.0000000000000001E-3,0.127,0.105,0.25,0.27,2.8,1.55,6.8000000000000005E-2,6.3E-2,0.124,7.8E-2,1.7999999999999999E-2,0.73599999999999999,0.71799999999999997,0.155,0.13500000000000001,0.46,0.42]
[null,"Average Concentration",{"$f":" ESDAT_AvgValue(C5:C23,0.5)","v":269},269,13,333,80,0.6,12,170,1221,1.1000000000000001,3.5,40,2.1000000000000001E-2,2.7E-2,2.7E-2,7.6,14,10,107,135,700,2.2000000000000001E-3,1.9E-3,6.9000000000000006E-2,6.4000000000000001E-2,0.21,0.21,0.97,0.61,0.05,4.9000000000000002E-2,3.9E-2,3.4000000000000002E-2,2.5999999999999999E-3,0.66,0.62,4.2000000000000003E-2,3.1E-2,0.32,0.2]
[null,"Median Concentration",{"$f":" ESDAT_MedianValue(C5:C23,0.5)","v":266},266,13.1,336.72,80.5,0.6,12.2,169,1190,1,3.21,41,5.0000000000000001E-3,0.02,0.02,7.59,14,10.1,107,135,696,1E-3,1E-3,6.2E-2,5.8999999999999997E-2,0.21,0.21,0.69,0.54500000000000004,5.0999999999999997E-2,4.5999999999999999E-2,3.4000000000000002E-2,0.03,5.0000000000000001E-4,0.65100000000000002,0.61399999999999999,2.5999999999999999E-2,1.4999999999999999E-2,0.32,0.19]
[null,"Standard Deviation",{"$f":" ESDAT_StdDev(C5:C23,0.5)","v":24},24,0.48,29,5.8,0,0.51,11,77,7.1999999999999995E-2,2.2000000000000002,2.2000000000000002,0.02,1.7000000000000001E-2,1.7000000000000001E-2,0.17,1.3,0.69,4.8,17,35,2.3E-3,1.8E-3,1.7000000000000001E-2,1.4E-2,1.9E-2,2.1000000000000001E-2,0.56999999999999995,0.36,6.3E-3,6.8999999999999999E-3,2.4E-2,1.7000000000000001E-2,5.1000000000000004E-3,3.1E-2,3.5000000000000003E-2,0.04,3.5999999999999997E-2,5.5E-2,0.09]
[null,"50th percentile",{"$f":"PERCENTILE(C5:C23,0.5)","v":272},272,13.1,348.92,81,0.6,12.3,169,1200,1.05,3.21,41,3.6000000000000004E-2,0.03,0.03,7.64,14,10.1,108,135,692,2E-3,3.0000000000000001E-3,6.2E-2,5.7000000000000002E-2,0.21,0.21,0.69,0.55000000000000004,5.0999999999999997E-2,4.5999999999999999E-2,3.4000000000000002E-2,2.9000000000000001E-2,2E-3,0.65100000000000002,0.61799999999999999,0.03,2.8000000000000001E-2,0.32,0.185]
[null,"75th percentile",{"$f":"PERCENTILE(C5:C23,0.75)","v":292},292,13.3,357.46,83,0.6,12.6,174.75,1270,1.1000000000000001,4.91,41,4.5249999999999999E-2,0.04,0.04,7.74,15,10.65,110,140,710,3.0000000000000001E-3,4.0000000000000001E-3,6.5000000000000002E-2,6.4000000000000001E-2,0.22750000000000001,0.22,1.25,0.88,5.1999999999999998E-2,5.1999999999999998E-2,4.1000000000000002E-2,4.1000000000000002E-2,9.5000000000000015E-3,0.68700000000000006,0.65,6.2E-2,6.25E-2,0.33999999999999997,0.215]
["RN41137 (BET-MB023)","2021-07-10",284,284,11.6,346.48,78,"-",10.9,134,1080,1,3.17,37,1.0999999999999999E-2,0.01,0.01,7.6,14,10.3,83,104,640,1.2E-2,8.0000000000000002E-3,8.5000000000000006E-2,6.3E-2,0.22,0.22,5.88,1.56,4.7E-2,4.3999999999999997E-2,7.6999999999999999E-2,6.6000000000000003E-2,"<0.001",0.56499999999999995,0.68200000000000005,7.0000000000000001E-3,"<0.005",0.19,0.47]
[null,"Ratio",{"$f":"C35/C34","v":0.9726027397260274},0.9726027397260274,{"$f":"E35/E34","v":0.8721804511278195},{"$f":"F35/F34","v":0.96928327645051204},0.93975903614457834,"NA",0.86507936507936511,0.76680972818311877,0.85039370078740162,0.90909090909090906,0.64562118126272905,0.90243902439024393,0.24309392265193369,0.25,0.25,0.98191214470284227,0.93333333333333335,0.96713615023474186,0.75454545454545452,0.74285714285714288,0.90140845070422537,4,2,1.3076923076923077,0.984375,0.96703296703296704,1,4.7039999999999997,1.7727272727272727,0.90384615384615385,0.84615384615384615,1.8780487804878048,1.6097560975609757,0.105,0.82241630276564759,1.0492307692307692,0.11290322580645161,0.08,0.55882352941176472,2.1860465116279069]
[null,"75th percentile exceedance",{"$f":"IF(C36>1,TRUE)","v":false},false,{"$f":"IF(E36>1,TRUE)","v":false},{"$f":"IF(F36>1,TRUE)","v":false},false,"NA",false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,true,true,true,false,false,false,true,true,false,false,true,true,false,false,true,false,false,false,true,{"$f":"COUNTIF(C37:AP37, TRUE)","v":9}]