{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Setup_Charts","TimeSeries","BarChartData","FilesUsed"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Setup_Charts","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[12,0,12,6],[13,2,15,2],[13,0,15,0],[13,4,15,4],[13,1,14,1],[13,3,14,3],[13,5,14,5]]}
["Timestamp"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["INPUT VARIABLES"]
["Site name:","ABC","Averaging interval (minutes):",15,"Number of monitors",3]
[]
[null,"Timestamp"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cutoff levels for Dylos small"]
["Very Poor",3000]
["Poor",1050,3000]
["Fair",300,1050]
["Good",150,300]
["Very Good",75,150]
["Excellent",0,75]

{"sheet":"TimeSeries","index":1,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Timestamp"," - Small"," - Small"," - Small"," - Large"," - Large"," - Large"]

{"sheet":"BarChartData","index":2,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Number of readings",null,0]
[null,{"$f":"\"TimeSeries!B2:B\"&$C$1+1","v":"TimeSeries!B2:B1"},{"$f":"\"TimeSeries!c2:c\"&$C$1+1","v":"TimeSeries!c2:c1"},{"$f":"\"TimeSeries!d2:d\"&$C$1+1","v":"TimeSeries!d2:d1"},{"$f":"\"TimeSeries!e2:e\"&$C$1+1","v":"TimeSeries!e2:e1"},{"$f":"\"TimeSeries!f2:f\"&$C$1+1","v":"TimeSeries!f2:f1"},{"$f":"\"TimeSeries!g2:g\"&$C$1+1","v":"TimeSeries!g2:g1"},{"$f":"\"TimeSeries!h2:h\"&$C$1+1","v":"TimeSeries!h2:h1"},{"$f":"\"TimeSeries!i2:i\"&$C$1+1","v":"TimeSeries!i2:i1"},{"$f":"\"TimeSeries!j2:j\"&$C$1+1","v":"TimeSeries!j2:j1"},{"$f":"\"TimeSeries!k2:k\"&$C$1+1","v":"TimeSeries!k2:k1"}]
[null,{"$f":"TimeSeries!B1","v":" - Small"},{"$f":"TimeSeries!C1","v":" - Small"},{"$f":"TimeSeries!D1","v":" - Small"},{"$f":"TimeSeries!E1","v":" - Large"},{"$f":"TimeSeries!F1","v":" - Large"},{"$f":"TimeSeries!G1","v":" - Large"},{"$f":"TimeSeries!H1","v":0},{"$f":"TimeSeries!I1","v":0},{"$f":"TimeSeries!J1","v":0},{"$f":"TimeSeries!K1","v":0}]
["Very Poor",{"$f":"COUNTIF(INDIRECT(B2),\">\"&Setup_Charts!$B$40)","v":0},{"$f":"COUNTIF(INDIRECT(C2),\">\"&Setup_Charts!$B$40)","v":0},{"$f":"COUNTIF(INDIRECT(D2),\">\"&Setup_Charts!$B$40)","v":0},{"$f":"COUNTIF(INDIRECT(E2),\">\"&Setup_Charts!$B$40)","v":0},{"$f":"COUNTIF(INDIRECT(F2),\">\"&Setup_Charts!$B$40)","v":0},{"$f":"COUNTIF(INDIRECT(G2),\">\"&Setup_Charts!$B$40)","v":0},{"$f":"COUNTIF(INDIRECT(H2),\">\"&Setup_Charts!$B$40)","v":0},{"$f":"COUNTIF(INDIRECT(I2),\">\"&Setup_Charts!$B$40)","v":0},{"$f":"COUNTIF(INDIRECT(J2),\">\"&Setup_Charts!$B$40)","v":0},{"$f":"COUNTIF(INDIRECT(K2),\">\"&Setup_Charts!$B$40)","v":0}]
["Poor",{"$f":"COUNTIFS(INDIRECT(B2),\">\"&Setup_Charts!$B41,INDIRECT(B2),\"<=\"&Setup_Charts!$C41)","v":0},{"$f":"COUNTIFS(INDIRECT(C2),\">\"&Setup_Charts!$B41,INDIRECT(C2),\"<=\"&Setup_Charts!$C41)","v":0},{"$f":"COUNTIFS(INDIRECT(D2),\">\"&Setup_Charts!$B41,INDIRECT(D2),\"<=\"&Setup_Charts!$C41)","v":0},{"$f":"COUNTIFS(INDIRECT(E2),\">\"&Setup_Charts!$B41,INDIRECT(E2),\"<=\"&Setup_Charts!$C41)","v":0},{"$f":"COUNTIFS(INDIRECT(F2),\">\"&Setup_Charts!$B41,INDIRECT(F2),\"<=\"&Setup_Charts!$C41)","v":0},{"$f":"COUNTIFS(INDIRECT(G2),\">\"&Setup_Charts!$B41,INDIRECT(G2),\"<=\"&Setup_Charts!$C41)","v":0},{"$f":"COUNTIFS(INDIRECT(H2),\">\"&Setup_Charts!$B41,INDIRECT(H2),\"<=\"&Setup_Charts!$C41)","v":0},{"$f":"COUNTIFS(INDIRECT(I2),\">\"&Setup_Charts!$B41,INDIRECT(I2),\"<=\"&Setup_Charts!$C41)","v":0},{"$f":"COUNTIFS(INDIRECT(J2),\">\"&Setup_Charts!$B41,INDIRECT(J2),\"<=\"&Setup_Charts!$C41)","v":0},{"$f":"COUNTIFS(INDIRECT(K2),\">\"&Setup_Charts!$B41,INDIRECT(K2),\"<=\"&Setup_Charts!$C41)","v":0}]
["Fair",{"$f":"COUNTIFS(INDIRECT(B2),\">\"&Setup_Charts!$B42,INDIRECT(B2),\"<=\"&Setup_Charts!$C42)","v":0},{"$f":"COUNTIFS(INDIRECT(C2),\">\"&Setup_Charts!$B42,INDIRECT(C2),\"<=\"&Setup_Charts!$C42)","v":0},{"$f":"COUNTIFS(INDIRECT(D2),\">\"&Setup_Charts!$B42,INDIRECT(D2),\"<=\"&Setup_Charts!$C42)","v":0},{"$f":"COUNTIFS(INDIRECT(E2),\">\"&Setup_Charts!$B42,INDIRECT(E2),\"<=\"&Setup_Charts!$C42)","v":0},{"$f":"COUNTIFS(INDIRECT(F2),\">\"&Setup_Charts!$B42,INDIRECT(F2),\"<=\"&Setup_Charts!$C42)","v":0},{"$f":"COUNTIFS(INDIRECT(G2),\">\"&Setup_Charts!$B42,INDIRECT(G2),\"<=\"&Setup_Charts!$C42)","v":0},{"$f":"COUNTIFS(INDIRECT(H2),\">\"&Setup_Charts!$B42,INDIRECT(H2),\"<=\"&Setup_Charts!$C42)","v":0},{"$f":"COUNTIFS(INDIRECT(I2),\">\"&Setup_Charts!$B42,INDIRECT(I2),\"<=\"&Setup_Charts!$C42)","v":0},{"$f":"COUNTIFS(INDIRECT(J2),\">\"&Setup_Charts!$B42,INDIRECT(J2),\"<=\"&Setup_Charts!$C42)","v":0},{"$f":"COUNTIFS(INDIRECT(K2),\">\"&Setup_Charts!$B42,INDIRECT(K2),\"<=\"&Setup_Charts!$C42)","v":0}]
["Good",{"$f":"COUNTIFS(INDIRECT(B2),\">\"&Setup_Charts!$B43,INDIRECT(B2),\"<=\"&Setup_Charts!$C43)","v":0},{"$f":"COUNTIFS(INDIRECT(C2),\">\"&Setup_Charts!$B43,INDIRECT(C2),\"<=\"&Setup_Charts!$C43)","v":0},{"$f":"COUNTIFS(INDIRECT(D2),\">\"&Setup_Charts!$B43,INDIRECT(D2),\"<=\"&Setup_Charts!$C43)","v":0},{"$f":"COUNTIFS(INDIRECT(E2),\">\"&Setup_Charts!$B43,INDIRECT(E2),\"<=\"&Setup_Charts!$C43)","v":0},{"$f":"COUNTIFS(INDIRECT(F2),\">\"&Setup_Charts!$B43,INDIRECT(F2),\"<=\"&Setup_Charts!$C43)","v":0},{"$f":"COUNTIFS(INDIRECT(G2),\">\"&Setup_Charts!$B43,INDIRECT(G2),\"<=\"&Setup_Charts!$C43)","v":0},{"$f":"COUNTIFS(INDIRECT(H2),\">\"&Setup_Charts!$B43,INDIRECT(H2),\"<=\"&Setup_Charts!$C43)","v":0},{"$f":"COUNTIFS(INDIRECT(I2),\">\"&Setup_Charts!$B43,INDIRECT(I2),\"<=\"&Setup_Charts!$C43)","v":0},{"$f":"COUNTIFS(INDIRECT(J2),\">\"&Setup_Charts!$B43,INDIRECT(J2),\"<=\"&Setup_Charts!$C43)","v":0},{"$f":"COUNTIFS(INDIRECT(K2),\">\"&Setup_Charts!$B43,INDIRECT(K2),\"<=\"&Setup_Charts!$C43)","v":0}]
["Very Good",{"$f":"COUNTIFS(INDIRECT(B2),\">\"&Setup_Charts!$B44,INDIRECT(B2),\"<=\"&Setup_Charts!$C44)","v":0},{"$f":"COUNTIFS(INDIRECT(C2),\">\"&Setup_Charts!$B44,INDIRECT(C2),\"<=\"&Setup_Charts!$C44)","v":0},{"$f":"COUNTIFS(INDIRECT(D2),\">\"&Setup_Charts!$B44,INDIRECT(D2),\"<=\"&Setup_Charts!$C44)","v":0},{"$f":"COUNTIFS(INDIRECT(E2),\">\"&Setup_Charts!$B44,INDIRECT(E2),\"<=\"&Setup_Charts!$C44)","v":0},{"$f":"COUNTIFS(INDIRECT(F2),\">\"&Setup_Charts!$B44,INDIRECT(F2),\"<=\"&Setup_Charts!$C44)","v":0},{"$f":"COUNTIFS(INDIRECT(G2),\">\"&Setup_Charts!$B44,INDIRECT(G2),\"<=\"&Setup_Charts!$C44)","v":0},{"$f":"COUNTIFS(INDIRECT(H2),\">\"&Setup_Charts!$B44,INDIRECT(H2),\"<=\"&Setup_Charts!$C44)","v":0},{"$f":"COUNTIFS(INDIRECT(I2),\">\"&Setup_Charts!$B44,INDIRECT(I2),\"<=\"&Setup_Charts!$C44)","v":0},{"$f":"COUNTIFS(INDIRECT(J2),\">\"&Setup_Charts!$B44,INDIRECT(J2),\"<=\"&Setup_Charts!$C44)","v":0},{"$f":"COUNTIFS(INDIRECT(K2),\">\"&Setup_Charts!$B44,INDIRECT(K2),\"<=\"&Setup_Charts!$C44)","v":0}]
["Excellent",{"$f":"COUNTIFS(INDIRECT(B2),\">\"&Setup_Charts!$B45,INDIRECT(B2),\"<=\"&Setup_Charts!$C$45)","v":0},{"$f":"COUNTIFS(INDIRECT(C2),\">\"&Setup_Charts!$B45,INDIRECT(C2),\"<=\"&Setup_Charts!$C$45)","v":0},{"$f":"COUNTIFS(INDIRECT(D2),\">\"&Setup_Charts!$B45,INDIRECT(D2),\"<=\"&Setup_Charts!$C$45)","v":0},{"$f":"COUNTIFS(INDIRECT(E2),\">\"&Setup_Charts!$B45,INDIRECT(E2),\"<=\"&Setup_Charts!$C$45)","v":0},{"$f":"COUNTIFS(INDIRECT(F2),\">\"&Setup_Charts!$B45,INDIRECT(F2),\"<=\"&Setup_Charts!$C$45)","v":0},{"$f":"COUNTIFS(INDIRECT(G2),\">\"&Setup_Charts!$B45,INDIRECT(G2),\"<=\"&Setup_Charts!$C$45)","v":0},{"$f":"COUNTIFS(INDIRECT(H2),\">\"&Setup_Charts!$B45,INDIRECT(H2),\"<=\"&Setup_Charts!$C$45)","v":0},{"$f":"COUNTIFS(INDIRECT(I2),\">\"&Setup_Charts!$B45,INDIRECT(I2),\"<=\"&Setup_Charts!$C$45)","v":0},{"$f":"COUNTIFS(INDIRECT(J2),\">\"&Setup_Charts!$B45,INDIRECT(J2),\"<=\"&Setup_Charts!$C$45)","v":0},{"$f":"COUNTIFS(INDIRECT(K2),\">\"&Setup_Charts!$B45,INDIRECT(K2),\"<=\"&Setup_Charts!$C$45)","v":0}]
[null,{"$f":"SUM(B4:B9)","v":0},{"$f":"SUM(C4:C9)","v":0},0,0,0,0,0,0,0,0]

{"sheet":"FilesUsed","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Raw data files used:"]