{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Test Results"],"read":"whole","date_system":"1900"}

{"sheet":"Test Results","index":0,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[0,0,0,1],[0,2,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[7,0,7,7],[8,0,8,7],[9,0,9,7]]}
["Lead in Water Test Results Summary:",null,"[enter building name]"]
["Notes:"]
["• The lead in water Action Level is 15 parts per billion (ppb)."]
["Any fixture testing at or above the action level of 15 ppb is immediately removed from service and cannot be returned to service until it has been remediated and passed follow-up testing."]
["• A \"ND\" or \"non-detect\" test result indicates the sample measured below the minimum detection limit of [#] ppb."]
["Legend:"]
["• Test results greater than or equal to the Action Level of 15 ppb are highlighted in red and precede an \"Action Req.\" (Action Required) value in the \"Initial Level\" or \"Final Level\" column."]
["• Test results from 12 ppb to 14.99 ppb (near the Action Level) are highlighted in orange and precede a \"High\" value in the \"Initial Level\" or \"Final Level\" column."]
["• Test results from 5 ppb to 11.99 ppb are highlighted in yellow and precede a \"Moderate\" value in the \"Initial Level\" or \"Final Level\" column."]
["• Test results less than 5 ppb are not highlighted and precede a \"Low\" value in the \"Initial Level\" or \"Final Level\" column."]
["Fixture Location Description","Fixture ID #","Initial \nTest Date","Initial Test Result (ppb)","Initial \nLevel","Final \nRetest Date","Final Test Result (ppb)","Final \nLevel"]
["[enter description]","[enter ID #]","[enter date]","[enter result]",{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":"[autofill]"},"[enter date]","[enter result]",{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":"[autofill]"}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Initial Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""},null,null,{"$f":"IFERROR(IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"\",\"\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"ND\",\"Non-Detect\",IF(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]]=\"[enter result]\",\"[autofill]\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=15,\"Action Req.\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>=10,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<15),\"High\",IF(AND(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])>5,VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<10),\"Moderate\",IF(VALUE(Test_Results_Summary[[#This Row],[Final Test Result (ppb)]])<=5,\"Low\",\"-\"))))))),\"-\")","v":""}]