{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Remediation Template","Example","Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Remediation Template","index":0,"n_rows":5,"n_cols":19,"rows_kept":5,"merged":[[0,0,0,16],[0,17,1,17],[0,18,1,18],[1,0,1,16],[2,0,4,0],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,4,4],[2,5,3,6],[2,7,2,18],[2,20,2,21],[3,11,3,16]]}
["[ INSERT SCHOOL BUILDING NAME ]",{"$nulls":16},"Date Last Updated: "]
["Lead in School Drinking Water Remedial Action Plan"]
["School Outlet ID (Should match Sampling Plan)","Laboratory Sample ID","Outlet Location","Outlet Description","Was the outlet deemed 'Applicable' or 'Not Applicable' for sampling?           *if not applicable place criteria in Notes/Comments","Sample Results (ppb or mcg/L) *if not applicable mark \"N/A\"",null,"Remedial Actions (Please mark \"x\" for all that apply)"]
[{"$nulls":11},"Actions Requiring Maintenance Schedule [Link to Maintenance Schedule Here]  [Link to Maintenance Documentation Here]"]
[{"$nulls":5},"Initial","Post          Remediation","Date Taken out of Service","Date Returned to Service","Outlet / Plumbing Replacement","Permanent Removal","Filter Installed and Maintained","Signage","Supervision","Continuing Education","Systematic Flushing","Engineering Controls","Date(s) Remedial Action Taken","Notes/Comments"]

{"sheet":"Example","index":1,"n_rows":13,"n_cols":19,"rows_kept":13,"merged":[[0,0,0,16],[0,17,1,17],[0,18,1,18],[1,0,1,16],[2,0,4,0],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,4,4],[2,5,3,6],[2,7,2,18],[3,11,3,16]]}
["DOH Test School 1",{"$nulls":16},"Date Last Updated: ","2024-06-15"]
["Lead in School Drinking Water Remedial Action Plan"]
["School Outlet ID","Laboratory Sample ID","Outlet Location","Outlet Description","Was the outlet deemed 'Applicable' or 'Not Applicable' for sampling?                     *if not applicable place criteria in Notes/Comments","Sample Results (ppb or mcg/L) *if not applicable mark \"N/A\"",null,"Remedial Actions (Please mark \"x\" for all that apply)"]
[{"$nulls":11},"Actions Requiring Maintenance Schedule [Link to Maintenance Schedule Here]  [Link to Maintenance Documentation Here]"]
[{"$nulls":5},"Initial","Post          Remediation","Date Taken out of Service","Date Returned to Service","Outlet / Plumbing Replacement","Permanent Removal","Filter Installed and Maintained","Signage","Supervision","Continuing Education","Systematic Flushing","Engineering Controls","Date(s) Remedial Action Taken","Notes/Comments"]
["HW001","ABC123","Math Wing Hallway","Water Fountain","Applicable",5.8,"N/A","2024-05-10",null,null,"X",{"$nulls":6},"2024-06-12","Water fountain permanently removed and supply line was capped. Plan to replace after plumbing project Summer 2025"]
["KIT123","ABC345","Kitchen Rear Corner","Pot Filler Sink","Applicable","6.3 ppb",null,"2024-05-10",{"$nulls":4},"X","X","X",{"$nulls":3},"Plan for piping replacement during Summer 2025"]
["TL001","ABC789","Teacher's Lounge","Sink","Applicable","5.2 ppb","0.2 ppb","2024-05-10","2024-06-15",null,null,"X",{"$nulls":5},"2024-06-12","Filter installed, maintenance schedule planned, re-tested and confirmed below action level of 5 pbb"]
["OS500","ABC500","Outdoor ","Water Tree","Applicable","10.8 ppb","0.1 ppb","2024-05-10","2024-06-15","X",{"$nulls":7},"2024-06-10","Piping replaced with certified \"lead free\" plumbing material. Re-tested and confirmed below action level of 5 ppb"]
["LR321","N/A","Locker Room","Shower","Not Applicable","N/A","N/A",{"$nulls":5},"X","X","X",null,null,"2024-05-01","Locker room shower with clear \"Do Not Drink\" signage. Staff and students educated to not use for consumption"]
["CR101","N/A","Room 101","Classroom Sink","Not Applicable","N/A","N/A",{"$nulls":5},"X","X","X",null,null,"2024-05-01","Classroom sink with clear \"Do Not Drink\" signage. Staff and students educated to not use for consumption"]
["OS100","N/A","Baseball Field","Outside Hose","Not Applicable","N/A","N/A",{"$nulls":9},"X","2024-05-01","Outdoor hose with a hose bib that is locked at all times with a key. Consumption is not possible. "]
["BR300","N/A","2nd Floor Womens Bathroom","Bathroom Sink","Not Applicable","N/A","N/A",{"$nulls":5},"X","X","X",null,null,"2024-05-01","Tempered bathroom sink with clear \"Do Not Drink\" signage. Staff and students educated to not use for consumption"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}