{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Service Line Repl Annual Report"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Service Line Repl Annual Report","index":0,"n_rows":57,"n_cols":15,"rows_kept":57,"cut":false,"hidden":false,"merged":[[11,9,11,13],[9,2,9,4],[10,9,10,13],[31,13,31,14],[9,9,9,13],[10,2,10,4],[15,1,15,2],[16,1,16,2],[17,1,17,2],[15,11,15,13],[15,6,15,8],[16,6,16,8],[17,6,17,8],[18,6,18,8],[20,6,20,8],[19,1,19,2],[0,5,0,13],[1,5,1,13],[2,5,2,13],[8,2,8,4],[8,9,8,13],[7,6,7,11],[3,8,3,11],[20,1,20,2],[21,1,21,2],[22,1,22,2],[27,3,27,5],[27,1,27,2],[37,1,37,2],[35,13,35,14],[26,1,26,2],[23,1,23,2],[24,1,24,2],[33,12,34,12],[36,12,40,12],[18,1,18,2],[52,7,52,8],[52,10,52,12],[43,2,43,5],[43,7,43,8],[43,10,43,12],[52,2,52,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[49,7,49,8],[49,10,49,12],[50,7,50,8],[50,10,50,12],[51,7,51,8],[51,10,51,12],[21,6,21,8],[22,6,22,8],[23,6,23,8],[24,6,24,8],[16,11,16,13],[17,11,17,13],[18,11,18,13],[19,11,19,13],[20,11,20,13],[21,11,21,13],[22,11,22,13],[23,11,23,13],[24,11,24,13],[19,6,19,8]]}
[null,"DEP_10-S_00027.2",null,null,null,"Annual Lead Service Line Progress Report"]
[null,"04/2024",null,null,null,"New Jersey Department of Environmental Protection"]
[null,null,null,null,null,"Division of Water Supply and Geoscience - Water System Operations Element"]
[null,null,null,null,null,null,null,null,"watersupply@dep.nj.gov"]
[null,null,null,null,null,null,"Forms must be submitted to the Water Supply Mailbox with a subject line that includes Water System Name, PWSID and Form Number."]
[]
[]
[null,"I. System Information",null,null,null,null,"II. Contact Information for Owner/ Licensed Operator of Record Completing the Form"]
[null,"Water System Name:",null,null,null,null,"Contact Name:"]
[null,"PWSID Number:",null,null,null,null,"Contact Title: "]
[null,"Accurate as of:",null,null,null,null,"Contact Phone: "]
[null,null,null,null,null,null,"Contact Email: "]
[null,null,null,null,null," "]
[null,"III. Inventory Information "]
[null,null,null,"Lead ","Galvanized","Lead Gooseneck only",null,null,null,"# of unknown found as lead or galvanized","# unknown found as non-lead"]
[null,"# of LSLs replaced 07/22/2021-06/30/2022:",null,null,null,null,"# of Unknowns identified 07/22/2021-06/30/2022:",null,null,null,null,"# of non-lead service lines later identified to be lead 07/22/2021-06/30/2022:"]
[null,"# of LSLs replaced 07/01/2022-06/30/2023:",null,null,null,null,"# of Unknowns identified 07/01/2022-06/30/2023:",null,null,null,null,"# of non-lead service lines later identified to be lead 07/01/2022-06/30/2023:"]
[null,"# of LSLs replaced 07/01/2023-06/30/2024:",null,null,null,null,"# of Unknowns identified 07/01/2023-06/30/2024:",null,null,null,null,"# of non-lead service lines later identified to be lead 07/01/2023-06/30/2024:"]
[null,"# of LSLs replaced 07/01/2024-06/30/2025:",null,null,null,null,"# of Unknowns identified 07/01/2024-06/30/2025:",null,null,null,null,"# of non-lead service lines later identified to be lead 07/01/2024-06/30/2025:"]
[null,"# of LSLs replaced 07/01/2025-06/30/2026:",null,null,null,null,"# of Unknowns identified 07/01/2025-06/30/2026:",null,null,null,null,"# of non-lead service lines later identified to be lead 07/01/2025-06/30/2026:"]
[null,"# of LSLs replaced 07/01/2026-06/30/2027:",null,null,null,null,"# of Unknowns identified 07/01/2026-06/30/2027:",null,null,null,null,"# of non-lead service lines later identified to be lead 07/01/2026-06/30/2027:"]
[null,"# of LSLs replaced 07/01/2027-06/30/2028:",null,null,null,null,"# of Unknowns identified 07/01/2027-06/30/2028:",null,null,null,null,"# of non-lead service lines later identified to be lead 07/01/2027-06/30/2028:"]
[null,"# of LSLs replaced 07/01/2028-06/30/2029:",null,null,null,null,"# of Unknowns identified 07/01/2028-06/30/2029:",null,null,null,null,"# of non-lead service lines later identified to be lead 07/01/2028-06/30/2029:"]
[null,"# of LSLs replaced 07/01/2029-06/30/2030:",null,null,null,null,"# of Unknowns identified 07/01/2029-06/30/2030:",null,null,null,null,"# of non-lead service lines later identified to be lead 07/01/2029-06/30/2030:"]
[null,"# of LSLs replaced 07/01/2030-06/30/2031:",null,null,null,null,"# of Unknowns identified 07/01/2030-06/30/2031:",null,null,null,null,"# of non-lead service lines later identified to be lead 07/01/2030-06/30/2031:"]
[]
[null,"Total # of service lines replaced by material type: ",null,{"$f":"SUM(D16:D26)","v":0},{"$f":"SUM(E16:E26)","v":0},{"$f":"SUM(F16:F26)","v":0},"Total# of Unknowns identified: ",null,null,{"$f":"SUM(J16:J25)","v":0},{"$f":"SUM(K16:K25)","v":0},"Total# of Unknowns identified: ",null,null,{"$f":"SUM(O16:O25)","v":0}]
[null,"Total # of service lines replaced: ",null,{"$f":"SUM(D27:F27)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Partial replacements?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"If yes, how many?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Optional Questions"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Filter and instruction distribution program?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"If yes, how many distributed?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"If yes, what is/are the manufacturer(s) and model number(s)","Manufacturer","Model #"]
[null,"Customer Contact to Offer Replacement",null,null,"Replacement Rate Statement"]
[null,"# of refusals",null,null,"               We met the replacement rate specified in our lead service line replacement plan"]
[null,"# of non-responses",null,null,"               We did not meet the replacement rate specified in our lead service line replacement plan"]
[null,"total # of communication attempts"]
[]
[]
[null,"IV. Certifications"]
[]
[null,"By submitting this form, I have verified and certify the information listed in this form is true and accurate to the best of my knowledge and belief, as well as the following:"]
[null,null,"1) We have implemented a lead service line replacement program in accordance with N.J.S.A. § 58:12A-44,"]
[null,null,"2) We submitted all lead analytical results from samples collected in accordance with N.J.S.A. § 58:12A-12.9. "]
[]
[]
[null,null,"Water System Owner or Licensed Operator Name",null,null,null,null,"Date",null,null,"Title (if WS Owner)"]
[]
[null,null,"Email",null,null,null,null,"Phone Number",null,null,"License Number (if LO)"]
[]
[]
[]
[null,"*This form must be submitted by the Water System Owner or its Licensed Operator of Record.*"]