{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Template"],"not_rendered":{"charts":1,"images":13,"macros":1,"external_links":0,"defined_names":58,"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":"Instructions","index":0,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
["Summary Table Options"]
[]
[null,null,null,null,null,"<-- Set Highlight Color"]
[null,null,null,null,null,"<-- Set Highlight Color"]
[]
[]
[]
[]
[]
["WSP Mann-Kendall Tool Instructions"]
["1. Rename \"Template\" Sheet per data set (e.g. \"MW-1 Benzene\")"]
["2. Enter Data Set ID in row 2(e.g. \"MW-1 Bezene\")"]
["3. Enter Units in row 3"]
["4. Enter sample dates in column B"]
["5. Enter data values in column C"]
["   5.1  Enter Non-Detects as \"< detection limit\"  (e.g. \"<5\")"]
["6. Enter \"ctrl+shift+z\" to update Mann-Kendal Results"]
["7. Create additional Mann-Kendall Calcalations by creating copies of the \"Template\""]
["8. Use option buttons to the right of the data set to adjust ND values"]
["    8.1 Logic ND values per flow chart (still needs to be updated)"]
["9. Apply a screening value to the chart by checking the \"Show screening level\" box"]
["    9.1 Change the legend entry for the screening value by enter the desired value in the textbox. Update chart with \"ctrl+shift+Z\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© Copyright WSP USA Inc 2024"]

{"sheet":"Template","index":1,"n_rows":48,"n_cols":28,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,8,6,10],[6,11,6,13],[6,14,6,16],[4,8,4,10],[4,11,4,13],[4,14,4,16],[5,8,5,10],[5,11,5,13],[5,14,5,16],[2,8,2,10],[2,11,2,13],[2,14,2,16],[3,8,3,10],[3,11,3,13],[3,14,3,16],[0,1,0,3],[0,5,0,6],[0,8,0,16],[0,25,0,27],[1,1,1,3],[1,8,1,10],[1,11,1,13],[1,14,1,16]]}
["Data Set ID:",null,null,null,{"$f":"B1 & \" Mann-Kendall Trend\"","v":" Mann-Kendall Trend"}," Mann-Kendall Results",null,null,"Mann-Kendall Interpretation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Options"]
["Units:",null,null,null,{"$f":"\"Concentration (\" &B2&\")\"","v":"Concentration ()"},"n:",0,null,"Mann-Kendall Statistic",null,null,"Statistical Confidence",null,null,"Trend Conclusion"]
["Event #","Date","Value","MK Value",{"$f":"TODAY()","v":"2024-12-09"},"S:","NA",null,"S > 0",null,null,{"$f":"\"≥ \"&TEXT(G11,\"00%\")","v":"≥ 90%"},null,null,"Increasing",null,null,null,null,null,null,null,"Detects","MK Numbers","Plot Values",false]
[1,null,null,null,55,"SES:","NA",null,"S > 0",null,null,{"$f":"\"< \" & TEXT(G11,\"00%\")","v":"< 90%"},null,null,"No Trend",null,null,null,null,null,10,null,null,null,null,false]
[{"$f":"IF(B5=\"\",\"\",A4+1)","v":""},null,null,null,55,"Z:","NA",null,"S ≤ 0",null,null,{"$f":"\"< \" & TEXT(G11,\"00%\") & \" and COV ≥ 1\"","v":"< 90% and COV ≥ 1"},null,null,"No Trend",null,null,null,null,null,10,null,null,null,null,false]
[{"$f":"IF(B6=\"\",\"\",A5+1)","v":""},null,null,null,55,"Confidence Factor:","NA",null,"S ≤ 0",null,null,{"$f":"\"< \" & TEXT(G11,\"00%\") & \" COV < 1\"","v":"< 90% COV < 1"},null,null,"Stable",null,null,null,null,null,10,null,null,null,null,false]
["",null,null,null,55,"Coefficient of Variation:","NA",null,"S < 0",null,null,{"$f":"\"≥ \" & TEXT(G11,\"00%\")","v":"≥ 90%"},null,null,"Decreasing",null,null,null,null,null,10,null,null,null,null,true]
["",null,null,null,55,"Conclusion:","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,"10"]
["",null,null,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,false,"Cleanup Goal"]
["",null,null,null,55,"Trend Threshold:",0.9,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,"© Copyright WSP USA Inc, 2024"]