{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","MW-1 Benzene"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":54,"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":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Instructions for completing Mann-Kendall Calculations"]
["1. Enter desired chart title and units in the Rows 1 and 2. These values will automatically populate chart labels"]
["2. Enter event dates in column B formatted as a date"]
["3. Enter values for MK calculations in column C"]
["4. Press \"ctrl+shift+Z\" to update the calculations and outputs"]
["5. Check \"n\" value after update. It should match the number of data points in the set, not the number of events.  (code will skip blank cells in calculation)"]
["6. create copies of the calculation worksheet for each data set as required"]

{"sheet":"MW-1 Benzene","index":1,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8],[1,9,1,11],[1,12,1,14],[0,1,0,2],[0,4,0,5],[0,7,0,8],[0,9,0,11],[0,12,0,14],[2,7,2,8],[2,9,2,11],[2,12,2,14],[3,7,3,8],[3,9,3,11],[3,12,3,14],[4,7,4,8],[4,9,4,11],[4,12,4,14],[5,7,5,8],[5,9,5,11],[5,12,5,14]]}
["Data Set ID:","MW-1 Benzene",null,{"$f":"B1 & \" Mann-Kendall Trend\"","v":"MW-1 Benzene Mann-Kendall Trend"}," Mann-Kendall Results",null,null,"Mann-Kendall Statistic",null,"Statistical Confidence",null,null,"Trend Conclusion"]
["Units:","µg/L",null,{"$f":"\"Concentration (\" &B2&\")\"","v":"Concentration (µg/L)"},"n:",7,null,"S > 0",null,{"$f":"\"≥ \"&TEXT(F11,\"00%\")","v":"≥ 90%"},null,null,"Increasing"]
["Event #","Date","Value",{"$f":"TODAY()","v":"2021-03-29"},"S:",-17,null,"S > 0",null,{"$f":"\"< \" & TEXT(F11,\"00%\")","v":"< 90%"},null,null,"More Data Needed"]
[1,"2017-10-01",1723,null,"SES:",6.6583281184793934,null,"S ≤ 0",null,{"$f":"\"< \" & TEXT(F11,\"00%\") & \" and COV ≥ 1\"","v":"< 90% and COV ≥ 1"},null,null,"More Data Needed"]
[{"$f":"IF(B5=\"\",\"\",A4+1)","v":2},"2018-01-01",1372,null,"Z:",-2.4030056367444423,null,"S ≤ 0",null,{"$f":"\"< \" & TEXT(F11,\"00%\") & \" COV < 1\"","v":"< 90% COV < 1"},null,null,"Stable"]
[{"$f":"IF(B6=\"\",\"\",A5+1)","v":3},"2018-05-01",801,null,"Confidence Factor:",0.99460000000000004,null,"S < 0",null,{"$f":"\"≥ \" & TEXT(F11,\"00%\")","v":"≥ 90%"},null,null,"Decreasing"]
[4,"2018-09-01",1042,null,"Coefficient of Variation:",0.51152960699055305]
[5,"2018-12-01",895,null,"Conclusion:","Decreasing Trend"]
[6,"2019-03-01",661]
[7,"2019-08-01",210]
["",null,null,null,"Trend Threshold:",0.9]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]