{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Introduction","Dropdowns","Template Instructions_Systems","Template Instructions_State","Classifying SLs","PWS Information","Inventory Methods","Inventory Summary","Detailed Inventory","Public Accessibility Doc.","State Checklist","Building Conditionals","Form Lists"],"not_rendered":{"images":13,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"merged":[[5,1,5,3],[7,1,7,3],[8,1,8,2],[10,1,10,3],[12,1,14,1],[15,1,19,1]]}
[]
[]
[null,null,"Service Line Inventory Template"]
[null,null,"Date last updated: July 27, 2022"]
[]
[null,"What is the purpose of this template? \nThe purpose of this draft template is to help water systems and states comply with the service line inventory requirements of the January 15, 2021 Lead and Copper Rule Revisions (LCRR). This template supplements the draft EPA document, Guidance for Developing and Maintaining a Service Line Inventory (2022) by providing fillable forms and tables that water systems can use to document their methods, organize their inventory, submit the initial inventory and inventory updates to the state, and document how they are making the inventory publicly available. This template also provides a checklist for state review. Note that EPA does NOT require systems use this template for their inventory. Refer to EPA's 2022 Inventory Guidance for minimum LCRR inventory requirements, recommendations, and disclaimers. \n"]
[]
[null,"How is the template organized?"]
[null,"The worksheets in this template are color coded: \n          Yellow sheets are instructions and background.\n          Dark blue sheets are templates for systems.\n          The dark green sheet is a template for states.\n\nSee the table below for a description of each worksheet.\n ",null,"The cells in this template are also color coded:\n         Gray cells are background or instructions.\n         Light blue cells are fillable cells for systems.\n         Aqua cells are the required fields in the Detailed Inventory worksheet.\n         Light green cells are fillable cells for states."]
[]
[null,"Template Organization"]
[null,"Worksheet Type","Worksheet Name","Description"]
[null,"Background","Template Instructions_System","Contains detailed instructions for systems. "]
[null,null,"Template Instructions_States","Contains detailed instructions for states. "]
[null,null,"Classifying SLs","Summarizes requirements for classifying the entire service line when ownership is split (i.e., when the system owns a portion and the customer owns a portion)."]
[null,"Templates for Water Systems","PWS Information","For systems to document basic system information."]
[null,null,"Inventory Methods","For systems to document the methods and resources they used to develop and update their inventory."]
[null,null,"Inventory Summary","For systems to provide a summary of their service line inventory, including information on ownership, inventory format, and the number of service lines for each of the four required materials classifications. Systems can enter the totals into this worksheet or automatically generate totals based on information in the Detailed Inventory worksheet."]
[null,null,"Detailed Inventory","Provides a customizable format water systems can use to track materials for each service line in their distribution system. Each row equals one service line connecting the water main to the customer's plumbing. Separate columns track location information, the system-owned portion, the customer-owned portion, other possible sources of lead, information for assigning a tap sample tiering classification, and information for lead service line replacement (LSLR). Systems can customize the worksheet by adding or deleting columns."]
[null,null,"Public Accessibility  Doc.","For systems to provide documentation to states on how they met the public accessibility requirements of the LCRR. "]
[null,"Templates for States","State Checklist","Provides a checklist that states can use to determine and document if water systems met all of the January 15, 2021 LCRR requirements for their Initial Inventory including timely submission, required elements, use of information sources, public accessibility, and public notification of service line materials."]

{"sheet":"Dropdowns","index":1,"n_rows":26,"n_cols":4,"rows_kept":26,"hidden":true}
[]
[null,"Drop down lists (Internal, DO NOT MODIFY)"]
[]
[null,"Ownership","Basis of materials classification","Field Verification Methods"]
[null,"Select Ownership Type","Previous Materials Evaluation","Customer self-identification"]
[null,"The entire service line is owned by the water system","Installation record (e.g., tap card)","CCTV investigation at curb stop - internal"]
[null,"The entire service line is owned by the customer","Installation date after lead ban","CCTV investigation at curb stop - external"]
[null,"Ownership is split, meaning that the system owns and portion and the customer owns a portion","Service line diameter is > 2 inches","Water quality sampling"]
[null,"Other","Service line repair or replacement record","Mechanical excavation at one location"]
[null,null,"Predictive model","Mechanical excavation at multiple locations"]
[null,null,"Water sampling only with no records","Visual inspection at the meter pit"]
[null,null,"Field inspection only with no records","Other"]
[null,null,"Other"]
[]
[null,"State review of customer notification of service line material"]
[null,"Select \"Yes\", \"No\", or \"N/A\""]
[null,"Yes"]
[null,"No"]
[null,"N/A"]
[]
[null,"Sensitive subpopulations"]
[null,"No"]
[null,"Yes - School"]
[null,"Yes - Day Care"]
[null,"Yes - Multifamily Home"]
[null,"Yes - Other"]

{"sheet":"Template Instructions_Systems","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Template Instructions_State","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Classifying SLs","index":4,"n_rows":30,"n_cols":4,"rows_kept":30,"merged":[[1,1,1,3],[3,1,3,3],[5,1,5,3],[6,1,6,3],[8,1,8,3],[9,1,11,3],[12,1,12,3],[14,1,14,3],[29,1,29,3]]}
[]
[null,"Classifying the Entire Service Line When Ownership Is Split"]
[]
[null,"Purpose of this worksheet: To summarize EPA's requirements for classifying the entire service line when ownership is split."]
[]
[null,"Introduction"]
[null,"In many cases, service line ownership is split meaning that the system owns a portion and the customer owns a portion of the service line. Exhibit 1 below is a diagram of a possible division in service line ownership between the water system and customer. While the LCRR requires the inventory to categorize each service line or portions of the service line where ownership is split, a single classification per service line is also needed to support various LCRR requirements, such as lead service line replacement (LSLR), tap sampling, and risk mitigation. Table 1 below indicates how to classify the material for the entire service line when ownership is split between the water system and customer. For more information, see EPA's, Guidance for Developing and Maintaining a Service Line Inventory (2022)."]
[]
[null,"Exhibit 1. Example of Service Line Ownership Distinction between the Water System and Customer"]
[]
[]
[]
[null,"Source: Exhibit 2-2 of Guidance for Developing and Maintaining a Lead Service Line Inventory (USEPA, 2022)."]
[]
[null,"Table 1: Classification of Entire Service Line When Ownership is Split"]
[null,"System-Owned Portion","Customer-Owned Portion","Classification for Entire Service Line "]
[null,"Lead","Lead","Lead"]
[null,"Lead","Galvanized Requiring Replacement","Lead"]
[null,"Lead","Non-lead","Lead"]
[null,"Lead","Lead Status Unknown","Lead"]
[null,"Non-lead","Lead","Lead"]
[null,"Non-lead and never previously lead","Non-lead, specifically galvanized pipe material","Non-lead"]
[null,"Non-lead","Non-lead, material other than galvanized","Non-lead"]
[null,"Non-lead","Lead Status Unknown","Lead Status Unknown"]
[null,"Non-lead, but system is unable to demonstrate it was not previously Lead","Galvanized Requiring Replacement","Galvanized Requiring Replacement"]
[null,"Lead Status Unknown","Lead","Lead"]
[null,"Lead Status Unknown","Galvanized Requiring Replacement","Galvanized Requiring Replacement"]
[null,"Lead Status Unknown","Non-lead","Lead Status Unknown"]
[null,"Lead Status Unknown","Lead Status Unknown","Lead Status Unknown"]
[null,"Source: Exhibit 2-3 of Guidance for Developing and Maintaining a Service Line Inventory (USEPA, 2022)."]

{"sheet":"PWS Information","index":5,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[10,1,10,3],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,2],[15,1,15,2],[16,1,16,4],[17,1,17,2],[18,1,18,2],[18,3,18,4],[19,1,19,2],[20,1,20,2],[20,3,20,4],[21,1,21,4],[22,1,22,2],[23,1,23,2],[23,3,23,4],[24,1,24,2],[25,1,25,2],[25,3,25,4]]}
[]
[null,"PWS Information"]
[]
[null,"Purpose of this worksheet:  For water systems to document basic system information."]
[]
[null,"Facility Information"]
[null,"Water System Name:"]
[]
[null,"PWSID:","Population Served (number of people):","Number of Service Connections:","PWS Type:"]
[{"$nulls":4},"                CWS                    NTNCWS"]
[null,"If you are a CWS, do multi-family residences comprise at least 20% of the structures you serve?",null,null,"Select \"Yes\" or \"No\""]
[null,"Mailing Address"]
[null,"Street or P.O. Box:"]
[]
[null,"City or Town:",null,"State:","Zip Code:"]
[]
[null,"System Contact Person"]
[null,"Name:",null,"Title:"]
[]
[null,"Telephone:",null,"Email:"]
[]
[null,"Person Who Prepared Inventory (if different from above)"]
[null,"Name:",null,"Title/Affiliation:"]
[]
[null,"Telephone:",null,"Email:"]

{"sheet":"Inventory Methods","index":6,"n_rows":46,"n_cols":4,"rows_kept":46,"merged":[[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,2,4,3],[6,1,6,3],[8,1,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[17,1,17,3],[18,1,18,3],[24,1,24,3],[25,1,25,3],[26,1,26,2],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[36,5,37,13],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3]]}
[]
[null,"Inventory Methodology"]
[null,{"$f":"IF('PWS Information'!$B$8=\"\",\"PWS Name:\", \"PWS Name: \"&'PWS Information'!B8)","v":"PWS Name:"}]
[null,{"$f":"IF('PWS Information'!$B$10=\"\",\"PWSID:\",\"PWSID: \"&'PWS Information'!$B$10)","v":"PWSID:"}]
[null,"Enter Date Last Updated:"]
[]
[null,"Purpose of this worksheet: For water systems to document the methods and resources they used to develop and update their inventory."]
[]
[null,"Part 1: Historical Records Review "]
[null,"Type of Record","Describe the Records Reviewed for Your Inventory and Indicate Your Level of Confidence (e.g., Low, Medium, or High) "]
[null,"1. Previous Materials Evaluation\nExample: Locations of Tier 1 lead tap sampling locations that are served by a lead service line."]
[null,"2. Construction Records and Plumbing Codes\nExamples: Local ordinance adopting an international plumbing code. Permits for replacing lead service lines."]
[null,"3. Water System Records\nExamples: Capital improvement plans. Standard operating procedures. Engineering standards."]
[null,"4. Distribution System Inspections and Records\nExamples: Distribution system maps. Tap cards. Service line repair/replacement records. Inspection records. Meter installation records. "]
[null,"5. Additional Records Required by Your State"]
[null,"6. Other Records"]
[]
[null,"Part 2: Identifying Service Line Material During Normal Operations"]
[null,"1. During which normal operating activities are you collecting information on service line material? Check all that apply. "]
[]
[null,"          Water meter reading","          Water main repair or replacement"]
[null,"          Water meter repair or replacement","          Backflow prevention device inspection"]
[null,"          Service line repair or replacement","          Other"]
[]
[null,"If \"Other\", please explain:"]
[]
[null,"2. Did you develop or revise standard operating procedures to collect service line material information \n    during normal operation?",null,"Select \"Yes\" or \"No\""]
[null,"    If \"Yes\", please describe:"]
[]
[]
[null,"Part 3:  Service Line Investigations"]
[null,"1. Identify the service line investigation methods your system used to prepare the inventory (check all that apply). If a water system chooses an investigation method not specified by the state under 40 CFR §141.84(a)(3)(iv), state approval is required. Note that investigations are not required by the LCRR but can be used by systems to assess accuracy of historical records and gather information when service line material is unknown. "]
[]
[null,"          Visual Inspection at the Meter Pit","          Water Quality Sampling - Other"]
[null,"          Customer Self-Identification","          Mechanical Excavation"]
[null,"          CCTV Inspection at Curb Box - External","          Vacuum Excavation"]
[null,"          CCTV Inspection at Curb Box - Internal","          Predictive Modeling"]
[null,"          Water Quality Sampling - Targeted","          Other"]
[null,"          Water Quality Sampling - Flushed"]
[null,"          Water Quality sampling - Sequential"]
[]
[null,"If \"Other\", please explain:"]
[]
[null,"2. If \"Predictive Modeling\", please briefly describe the model and inputs used:"]
[]
[null,"3. How did you prioritize locations for service line materials investigations? For example, did you consider environmental justice and/or sensitive populations, did you use predictive modeling, and/or did you target areas with high number of unknowns?"]

{"sheet":"Inventory Summary","index":7,"n_rows":37,"n_cols":5,"rows_kept":37,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,2,4,4],[6,1,6,4],[8,1,8,4],[9,1,9,2],[9,3,9,4],[10,1,10,2],[10,3,10,4],[11,1,11,4],[12,1,12,2],[12,3,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,2],[18,3,18,4],[19,1,19,4],[20,1,20,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[26,1,26,4],[27,1,27,4],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,1,33,3],[35,1,35,4],[36,1,36,4]]}
[]
[null,"Inventory Summary"]
[null,{"$f":"IF('PWS Information'!$B$8=\"\",\"PWS Name:\", \"PWS Name: \"&'PWS Information'!B8)","v":"PWS Name:"}]
[null,{"$f":"IF('PWS Information'!$B$10=\"\",\"PWSID:\",\"PWSID: \"&'PWS Information'!$B$10)","v":"PWSID:"}]
[null,"Enter Date Last Updated:"]
[]
[null,"Purpose of this worksheet:  For water systems to provide a summary of their service line inventory, including information on ownership, inventory format, and the number of service lines for each of the four required materials classifications."]
[]
[null,"Part 1.  General Information"]
[null,"1. Is this the Initial Inventory or an Inventory Update?",null,"Select One"]
[null,"2a. Who owns the service lines in your system?  If other, please explain below.",null,"Select Ownership Type"]
[]
[null,"2b. Is there documentation that defines service line ownership in your system, such as a local ordinance? If yes, please describe below and explain where ownership is split (e.g., property line, curb stop).",null,"Select \"Yes\" or \"No\" "]
[]
[null,"3a. Describe when lead service lines were generally installed in your system."]
[]
[null,"3b. When were lead service lines banned in your system? Reference the state or local ordinance that banned the use of lead in your system."]
[]
[null,"4. Do you have lead goosenecks, pigtails or connectors in your system?",null,"Select \"Yes\" or \"No\" or \"Don't Know\" "]
[null,"5. What is your overall level of confidence in the inventory (i.e., \"Low\", \"Medium\", or \"High.\") Please explain your rationale below. "]
[]
[]
[null,"Part 2.  Inventory Format"]
[null,"Describe your inventory format in the space provided below (e.g., the Detailed Inventory worksheet, custom spreadsheet, GIS map). Provide the filename and/or web address if applicable. Note that the state may require you to submit your detailed inventory of each service line in your distribution system."]
[]
[]
[null,"Part 3.  Inventory Summary Table 1 "]
[null,"If you are using the Detailed Inventory worksheet, the classifications you select in the Column \"Entire Service Line Material Classification\" (Column X) will be used to calculate the total number of service lines for each of the four material classifications below. Otherwise, enter the number of service lines in the aqua-colored cells. Remember this is the classification for the entire service line. "]
[null,"Service Line Material Classification","Definition",null,"Total Number of Service Lines\n(REQUIRED to be reported under the LCRR)"]
[null,"Lead","Any portion of the service line is known to be made of lead.2",null,{"$f":"COUNTIF('Detailed Inventory'!$X$13:$X$10012,\"lead\")","v":1}]
[null,"Galvanized Requiring Replacement (GRR)","The service line is not made of lead, but a portion is galvanized and the system is unable to demonstrate that the galvanized line was never downstream of a lead service line.",null,{"$f":"COUNTIF('Detailed Inventory'!$X$13:$X$10012,\"galvanized requiring replacement\")","v":3}]
[null,"Non-Lead","All portions of the service line are known NOT to be lead or GRR through an evidence-based record, method, or technique.",null,{"$f":"COUNTIF('Detailed Inventory'!$X$13:$X$10012,\"non-lead\")","v":2}]
[null,"Lead Status Unknown","The service line material is not known to be lead or GRR. For the entire service line or a portion of it (in cases of split ownership), there is not enough evidence to support material classification.",null,{"$f":"COUNTIF('Detailed Inventory'!$X$13:$X$10012,\"unknown\")","v":2}]
[null,"TOTAL",null,null,{"$f":"SUM(E30:E33)","v":8}]
[null,"Notes"]
[null,"1 This summary table is for reporting material for the entire service line connecting the water main to the customer's plumbing. See the Classifying SLs worksheet for additional guidance on assigning a materials classification to the entire service line when ownership is split. Remember that systems must track the system-owned and customer-owned portions separately in their inventory."]
[null,"2 A lead-lined galvanized service line is consistent with the definition of an LSL under the LCRR (“a portion of pipe that is made of lead, which connects the water main to the building inlet”) (40 CFR §141.2) and must therefore be classified in the inventory as an LSL. Do NOT, however, count non-lead service lines with a lead gooseneck or pigtail as lead service lines unless required by your state."]

{"sheet":"Detailed Inventory","index":8,"n_rows":20,"n_cols":33,"rows_kept":20,"merged":[[1,1,1,10],[2,1,2,10],[3,1,3,10],[4,1,4,4],[4,5,4,10],[4,16,4,18],[6,1,6,10],[8,1,8,5],[8,6,8,14],[8,15,8,22],[8,23,10,23],[8,24,8,26],[8,27,8,30],[8,31,8,32],[9,1,10,1],[9,2,9,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,11,10,11],[9,12,9,13],[9,14,10,14],[9,15,10,15],[9,16,10,16],[9,17,10,17],[9,18,10,18],[9,19,10,19],[9,20,9,21],[9,22,10,22],[9,24,10,24],[9,25,10,25],[9,26,10,26],[9,27,10,27],[9,28,10,28],[9,29,10,29],[9,30,10,30],[9,31,10,31],[9,32,10,32],[11,2,11,3],[11,27,11,30]]}
[]
[null,"Detailed Inventory"]
[null,{"$f":"IF('PWS Information'!$B$8=\"\",\"PWS Name:\", \"PWS Name: \"&'PWS Information'!B8)","v":"PWS Name:"}]
[null,{"$f":"IF('PWS Information'!$B$10=\"\",\"PWSID:\",\"PWSID: \"&'PWS Information'!$B$10)","v":"PWSID:"}]
[null,"Date Last Updated:"]
[]
[null,"Purpose of this worksheet: To provide a customizable format water systems can use to track materials for each service line in their distribution system. \n\nGeneral Instructions: Each row in this worksheet represents one service line connecting the water main to the customer's plumbing. The worksheet includes required and recommended elements; the columns with the aqua shading are required by the LCRR. Systems can customize by adding or deleting columns. Important notes for each column are in Row 12; also see the Template Instructions worksheet for detailed instructions. Note that users can freeze panes to enable them to see the headings and notes when entering data. The worksheet includes examples in rows 13 - 20 and is formatted for approximately 10,000 entries. ",{"$nulls":10}," ",{"$nulls":7}," "]
[]
[null,"Location Information",{"$nulls":4},"System-Owned Portion",{"$nulls":8},"Customer-Owned Portion",{"$nulls":7},"Entire Service Line\nMaterial Classification","Other Potential Sources of Lead",null,null,"Additional Information to Assign Tap Monitoring Tiering",{"$nulls":3},"Lead Service Line Replacement (LSLR)"]
[null,"Unique Service Line ID","Location Identifier ",null,"Sensitive Population? (Yes/No)","Disadvantaged Neighborhood? (Yes/No)","System-Owned Portion \nService Line Material Classification ","If Non-Lead in Column G,\nWas Material Ever Previously Lead?","Service Line Installation Date","Service Line Size","Basis of Material Classification","Was the Service Line Material Field Verified?","If \"Yes\" Service Line Material Was Field Verified:",null,"Notes","Customer-Owned Portion\nService Line Material Classification","Service Line Installation Date","Service Line Size","Basis of Material Classification","Was the Service Line Material Field Verified?","If \"Yes\" Service Line Material Was Field Verified:",null,"Notes",null,"Is there a Lead Connector?","Is there Lead Solder in the Service Line?","Describe Other Fittings and Equipment Connected to the Service Line that Contain Lead","Building Type Connected to Service Line","Point-of-Entry or Point-of-Use Treatment Present?","Does the Interior Building Plumbing Contain Copper Pipes with Lead Solder Installed Before Your State's Lead Ban (Generally 1986 - 1988)?"," Current LCR Sampling Site?","Date of System-owned LSLR","Date of Customer-owned LSLR"]
[null,null,"Street Address","Other Location Identifier",{"$nulls":8},"Describe the Field Verification Method","Enter the Date of Field Verification",{"$nulls":6},"Describe the Field Verification Method","Enter the Date of Field Verification"]
[null,"A Unique ID is recommended for each service line.","Water systems must track addresses of all service lines in their internal inventory. For the publicly accessible version, location identifiers are required for lead and galvanized requiring replacement. If the system does not use addresses for their location identifier, other options could include GPS coordinates, landmark, intersection, block, or other details to specify service line locations.",null,"Select Yes if sensitive subpopulation, e.g., day care, school, multifamily home. If Yes-Other, describe in the Notes field.","Does location meet state affordability guidelines or other measures?","Dropdown list includes recommended subclassifications. If \"Non-Lead Other\", describe in Notes field","Select Yes, No, or Don't know. Important for determining if downstream/ customer-owned galvanized service line requires replacement","Date, year, or estimated date range when the service line was installed or replaced","Diameter in inches","Select option from drop down list. If \"Other,\" describe in the Notes field","Select Yes or No","Select option from drop down list. If \"Other,\" describe in the Notes field","Enter approximate date of field verification or date that the record was updated","Can use this field for documenting additional relevant information, including when classification changes.","Dropdown list includes recommended subclassifications. If non-lead other, describe in Notes field.","Date, year, or estimated date range when the service line was installed or replaced","Diameter in inches","Select option from drop down list. If \"Other,\" describe in the Notes field","Select Yes or No","Select option from drop down list. If \"Other,\" describe in the Notes field","Enter approximate date of field verification or date that record was updated","Can use this field for documenting additional relevant information, including when classification changes.","Dropdown list includes four required service line classifications of Lead, Non-lead, Galvanized Requiring Replacement, or Unknown","For example, lead gooseneck or pigtail where the water main is connected to the service line","Select Yes, No, or Don't Know","For example, backflow preventer or meter containing lead","Note: This information may be helpful for identifying lead tap monitoring locations."]
[null,"Example 1","1234 Test St., City, State, Zip Code"," Intersection of Test and Elm St.","No","No","Non-Lead - Plastic","Yes",1997,2,"Installation date after lead ban","Yes","Visual inspection at the meter pit","2019-05-01",null,"Non-Lead - Plastic",2012,2,"Installation date after lead ban","No",{"$nulls":3},"Non-Lead","No","No",null,"Single Family Residence","Yes"," No","No"]
[null,"Example 2","4321 Test St., City, State, Zip Code","Intersection of Test and Main St.","No","No","Non-Lead - Plastic","No","Fall 1980",2,"Installation record (e.g., tap card)","Yes","Mechanical excavation at one location","2020-09-10",null,"Galvanized","Fall 1980",2,"Installation record (e.g., tap card)","Yes","Mechanical excavation at one location","2020-09-10",null,"Non-Lead","No","No",null,"Single Family Residence"," No","No","No"]
[null,"Example 3","16 Capital St., City, State, Zip Code",null,"No","No","Non-Lead - Copper","Don't know",1985,"1 1/2","Service line repair or replacement record","No",{"$nulls":3},"Galvanized",1908,"1 1/2","Installation record (e.g., tap card)","No",{"$nulls":3},"Galvanized Requiring Replacement","Don't Know","Don't Know",null,"Other","Unknown","Unknown","No"]
[null,"Example 4","1 Water Avenue, City, State, Zip Code",null,"No","No","Unknown - Likely Lead",null,"1940's",2,null,"No",{"$nulls":3},"Galvanized","1940's",2,null,"Yes","Customer self-identification","2020-08-08",null,"Galvanized Requiring Replacement","Don't Know","Yes",null,"Single Family Residence"," No","Unknown","Yes"]
[null,"Example 5","67 Children's Place, City, State, Zip Code",null,"Yes - Day Care","No","Unknown - Material Unknown",null,"1950-1960","3/4",null,"No",{"$nulls":3},"Unknown - Material Unknown","1950-1960","3/4",null,"No",{"$nulls":3},"Unknown","Don't Know","Yes",null,"Single Family Residence"," No","Yes","No"]
[null,"Example 6","30 Price Street, City, State, Zip Code",null,"No","No","Lead-lined galvanized",null,1955,2,"Installation record (e.g., tap card)","Yes","CCTV investigation at curb stop - internal","2020-08-08",null,"Lead-lined galvanized",1955,2,"Installation record (e.g., tap card)","No",{"$nulls":3},"Lead","Yes","No",null,"Single Family Residence"," No","Yes","Yes"]
[null,"Example 7","123 System Ave., City, State, Zip Code","Building A","No","Yes","Non-Lead - Copper","Yes",2015,2,"Service line repair or replacement record","No",{"$nulls":3},"Galvanized","1950 - 1955",2,"Installation record (e.g., tap card)","Yes","Customer self-identification","2020-01-15",null,"Galvanized Requiring Replacement","No","Don't Know","Backflow preventer","Single Family Residence"," No","Unknown","No"]
[null,"Example 8","123 System Ave., City, State, Zip Code","Building B","No","No","Non-Lead - Copper","Don't know",2015,2,"Service line repair or replacement record","No",{"$nulls":3},"Unknown - Material Unknown","1940's",2,null,"No",{"$nulls":3},"Unknown","No","Yes",null,"Single Family Residence"," No","Unknown","No"]

{"sheet":"Public Accessibility Doc.","index":9,"n_rows":31,"n_cols":4,"rows_kept":31,"merged":[[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,2,4,3],[6,1,6,3],[8,1,8,3],[16,1,16,3],[17,1,17,3],[18,1,18,2],[19,1,19,3],[20,1,20,3],[21,1,21,3],[30,1,30,3],[31,1,31,3]]}
[]
[null,"Public Accessibility Documentation"]
[null,{"$f":"IF('PWS Information'!$B$8=\"\",\"PWS Name: \",\"PWS Name: \"&'PWS Information'!B8)","v":"PWS Name: "}]
[null,{"$f":"IF('PWS Information'!$B$10=\"\",\"PWSID:\",\"PWSID: \"&'PWS Information'!$B$10)","v":"PWSID:"}]
[null,"Enter Date Last Updated:"]
[]
[null,"Purpose of this worksheet: For systems to provide documentation to states on how they met the public accessibility requirements of the LCRR. "]
[]
[null,"1. Select the location identifiers that you use for your service line inventory. Check all that apply."]
[null,"            Address"]
[null,"            Street"]
[null,"            Block"]
[null,"            Intersection"]
[null,"            Landmark"]
[null,"            GPS Coordinates"]
[null,"            Other"]
[null,"If \"Other\", please describe:"]
[]
[null,"2.  Does every service line have a location identifier?",null,"Select \"Yes\" or \"No\""]
[null,"     If \"No\", explain. Remember that location identifiers are required for service lines that are lead and galvanized requiring replacement."]
[]
[null,"3. How are you making your inventory publicly accessible? Check all that apply. Remember that if your system serves > 50,000 people, you must provide the inventory online."]
[null,"          Interactive online map"]
[null,"          Static online map"]
[null,"          Online spreadsheet"]
[null,"          Printed service line map"]
[null,"          Printed tabular data"]
[null,"          Information on water utility mailings or newsletter"]
[null,"          Hard copy information available in water system office"]
[null,"          Other"]
[null,"If \"Other\", please describe:"]

{"sheet":"State Checklist","index":10,"n_rows":75,"n_cols":5,"rows_kept":75,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,2],[4,3,4,4],[6,1,6,4],[8,1,8,4],[9,1,9,2],[10,1,10,2],[10,3,10,4],[11,1,11,2],[12,1,12,2],[12,3,12,4],[14,1,14,4],[15,1,15,3],[16,1,16,4],[18,1,18,4],[19,1,19,3],[20,1,20,4],[21,1,21,3],[22,1,22,4],[23,1,23,3],[24,1,24,4],[25,1,25,4],[26,1,26,4],[28,1,28,4],[29,1,29,3],[30,1,30,4],[31,1,31,3],[32,1,32,4],[33,1,33,3],[34,1,34,4],[35,1,35,4],[36,1,36,4],[38,1,38,4],[39,1,39,3],[40,1,40,4],[41,1,41,3],[42,1,42,4],[43,1,43,4],[44,1,44,4],[46,1,46,4],[47,0,48,0],[47,1,47,3],[47,4,48,4],[47,5,48,5],[48,1,48,3],[49,1,49,3],[50,1,50,3],[51,1,51,4],[52,0,59,0],[52,1,52,3],[52,4,59,4],[52,5,59,5],[53,1,53,3],[54,1,54,3],[55,1,55,3],[56,1,56,3],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,4],[61,0,65,0],[61,1,61,3],[61,4,65,4],[61,5,65,5],[62,1,62,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[66,1,66,4],[67,0,71,0],[67,1,67,3],[67,4,71,4],[67,5,71,5],[68,1,68,3],[69,1,69,3],[70,1,70,3],[71,1,71,3],[72,1,72,4],[73,1,73,3],[74,1,74,4],[75,1,75,4]]}
[]
[null,"State Checklist for Initial Inventory Submittal"]
[null,{"$f":"IF('PWS Information'!$B$8=\"\",\"PWS Name:\",\"PWS Name: \"&'PWS Information'!$B$8)","v":"PWS Name:"}]
[null,{"$f":"IF('PWS Information'!$B$10=\"\",\"PWSID: \",\"PWSID: \"&'PWS Information'!$B$10)","v":"PWSID: "}]
[null,"Enter Date Last Updated:"]
[]
[null,"Purpose of this worksheet: For states to determine and document if water systems met all of the January 15, 2021 Lead and Copper Rule (LCRR) requirements for their Initial Inventory including timely submission, required elements, use of information sources, public accessibility, and public notification of service line materials."]
[]
[null,"Part 1:  Person Completing This Checklist"]
[null,"Name:",null,"Title:"]
[]
[null,"Telephone:",null,"Email:"]
[]
[]
[null,"Part 2: Review for Timely Submission"]
[null,"1. Was the initial inventory submitted by the deadline of October 16, 2024?",null,null,"Select \"Yes\" or \"No\" "]
[null,"    Consider post-mark or date sent via email or reported into a state data system."]
[]
[null,"Part 3: Review for Required Elements"]
[null,"1. Does the inventory include all service lines connected to the distribution system?",null,null,"Select \"Yes\" or \"No\" "]
[null,"Consider if the total number of service lines in the Inventory Summary worksheet, Part 3, matches sanitary survey and monitoring data in the state’s database (e.g., SDWIS/State) based on population served, number of service connections (including those for non-potable use), number of accounts, census data, or other information. \n"]
[null,"2. Does the inventory include portions owned by the water system and the customer?",null,null,"Select \"Yes\" or \"No\" "]
[null,"    Check the service line ownership type selected in the Inventory Summary worksheet, Part 1, Question 2a. If the system selected \"Ownership is Split\" check that their inventory includes information for both the system-owned and customer-owned portions. "]
[null,"3. Did the system classify all service lines as either Lead, Galvanized Requiring Replacement (GRR), Non-Lead, or Lead Status Unknown?",null,null,"Select \"Yes\" or \"No\" "]
[null,"    Consider if the system completed each row of the inventory summary table in the Inventory Summary worksheet, Part 3. \n    Some rows may be zero."]
[null,"4.  In the space below, provide additional comments/documentation related to required elements of the system's initial inventory."]
[]
[]
[null,"Part 4: Review for Information Sources"]
[null,"1. Did the system use the following historical records to prepare their initial inventory: previous materials evaluation, construction and plumbing codes/records, water system records, distribution system inspections and records.",null,null,"Select \"Yes\" or \"No\" "]
[null,"    Consider if the system identified historical records in each row of the Inventory Methods worksheet, Part 1, Rows 1 through 4.\n    Consider if the system completed Row 5 if additional records are required in your state. "]
[null,"2. Is the system collecting service line material information during normal operations?\n ",null,null,"Select \"Yes\" or \"No\" "]
[null,"    Consider if the system checked one or more normal operations activities in the Inventory Methods worksheet, Part 2. \n    Consider asking the systems to submit updated or new standard operating procedures documenting service line material information                  collection."]
[null,"3. Has the system conducted investigations to verify service line material? ",null,null,"Select \"Yes\" or \"No\" "]
[null,"This is not required by the LCRR but recommended by EPA to verify historical records and gather information where records do not exist to reduce the number of unknowns in the system as quickly as possible. Consider:\n  • \tIf the system checked one or more of the investigative methods on the Inventory Methods worksheet, Part 3. \n  • \tIf in their inventory, the system indicated that the materials classification was based on investigations. \n  • \tThe number of unknowns - EPA strongly discourages systems from submitting inventories with all unknowns. If all service line materials are lead status unknown, consider asking the water system to conduct investigations. "]
[null,"4.  In the space below, provide additional comments related to information sources used to develop the system's initial inventory."]
[]
[]
[null,"Part 5: Review for Public Accessibility"]
[null,"1. Does the inventory include location identifiers for each service line that is lead or galvanized requiring replacement?",null,null,"Select \"Yes\" or \"No\" "]
[null,"Consider checking the inventory for location identifiers and reviewing the system's answers in the Public Accessibility Doc. worksheet, Questions 1 and 2."]
[null,"2. Did the system make its inventory publicly accessible?",null,null,"Select \"Yes\" or \"No\" "]
[null," Consider reviewing the method by which the water system is making its inventory publicly accessible as identified in the Public Accessibility Doc. worksheet, Question 3. Check that systems serving more than 50,000 people have posted their service line inventories online.  "]
[null,"3.  In the space below, provide additional comments/documentation related to public accessibility of the system's initial inventory."]
[]
[]
[null,"Part 6: Review of Customer Notification of Service Line Material "]
[null,"1. Does the water system's inventory consist of all Non-Lead Service lines?",null,null,"Select \"Yes\" or \"No\" "]
[null,"     If No, complete questions 2 through 5. If Yes, stop here."]
[null,"2. Did the water system deliver the notification to people served by a lead service line (LSL), GRR, or lead status unknown service line within 30 days of completing the initial inventory?",null,null,"Select \"Yes\" or \"No\" "]
[null,"3. Did the water system demonstrate that they delivered the notification and provide a copy of the notification to the state by July 1 for the previous calendar year?",null,null,"Select \"Yes\" or \"No\" "]
[null,"4. Did the notification include the required content?"]
[null,"   a. For confirmed LSLs, does the notification include:",null,null,"Select \"Yes\" or \"No\" or \"N/A\""]
[null,"·  A statement that the service line material is lead,"]
[null,"·  Information on lead health effects including mandatory health effects language of 40 CFR §141.85(a)(ii),"]
[null,"·  Steps to minimize exposure to lead in drinking water,"]
[null,"·  Opportunities for service line replacement,"]
[null,"·  Available financing programs, and"]
[null,"·  A statement that the system must replace its portion if the property owners notify the system that"]
[null,"    they are replacing their portion?"]
[]
[null,"   b. For GRRs, does the notification include:",null,null,"Select \"Yes\" or \"No\" or \"N/A\""]
[null,"·  A statement that the service line material is GRR,"]
[null,"·  Information on lead health effects including mandatory health effects language of 40 CFR §141.85(a)(ii),"]
[null,"· Steps to minimize exposure to lead in drinking water, and"]
[null,"·  Opportunities for service line replacement?"]
[]
[null,"   c. For Unknowns, does the notification include:",null,null,"Select \"Yes\" or \"No\" or \"N/A\""]
[null,"·  A statement that the service line material is lead status unknown,"]
[null,"·  Information on lead health effects including mandatory health effects language of 40 CFR §141.85(a)(ii),"]
[null,"·  Steps to minimize exposure to lead in drinking water, and   "]
[null,"·  Opportunities to verify the service line material?"]
[]
[null,"5. If the water system serves communities with a large proportion of non-English speaking consumers, as determined by the state, did they provide public education materials, including those in 40 CFR §141.85(e), in the appropriate language(s) or containing a telephone number or address where persons served may contact the water system to obtain a translated copy of the materials or to request assistance in the appropriate language? ",null,null,"Select \"Yes\" or \"No\" "]
[null,"6.  In the space below, provide additional comments/documentation related to customer notification for people served by an LSL, GRR, or lead status unknown service line. "]

{"sheet":"Building Conditionals","index":11,"n_rows":40,"n_cols":23,"rows_kept":40,"hidden":true}
["DRAFT",{"$nulls":8},"Form Option For Customer Side","Classification",{"$nulls":4},"System-Owned Portion","Was Previously Lead?","Customer-Owned Portion","Classification for Entire Service Line ",null,null,"Single-Owned Portion","Classification for Entire Service Line "]
[null,"Note to EPA: This is a background sheet to be hidden or deleted",{"$nulls":7},"Lead","Lead",{"$nulls":4},"Lead",null,"Lead","Lead",null,null,"Lead","Lead"]
[{"$nulls":9},"Lead-lined galvanized","Lead",{"$nulls":4},"Lead",null,"Galvanized","Lead",null,null,"Galvanized","Non-Lead"]
[{"$nulls":9},"Galvanized","Galvanized",{"$nulls":4},"Lead",null,"Non-Lead","Lead",null,null,"Non-Lead","Non-Lead"]
[{"$nulls":9},"Non-Lead - Copper","Non-Lead",{"$nulls":4},"Lead",null,"Material Unknown","Lead",null,null,"Material Unknown","Lead Status Unknown"]
[{"$nulls":9},"Non-Lead - Plastic","Non-Lead",{"$nulls":4},"Galvanized",null,"Lead","Lead"]
[{"$nulls":9},"Non-Lead - Other","Non-Lead",{"$nulls":4},"Galvanized",null,"Galvanized","Non-Lead"]
[{"$nulls":9},"Unknown - Likely Lead","Material Unknown",{"$nulls":4},"Galvanized",null,"Non-Lead","Non-Lead"]
[{"$nulls":9},"Unknown - Unlikely Lead","Material Unknown",{"$nulls":4},"Galvanized",null,"Material Unknown","Lead Status Unknown"]
[{"$nulls":9},"Unknown - Material Unknown","Material Unknown",{"$nulls":4},"Non-Lead",null,"Lead","Lead"]
[{"$nulls":15},"Non-Lead","Y","Galvanized","Galvanized Requiring Replacement"]
[{"$nulls":9},"Form Option For System Side","Classification",{"$nulls":4},"Non-Lead","N","Galvanized","Non-Lead"]
[{"$nulls":9},"Lead","Lead",{"$nulls":4},"Non-Lead","DN","Galvanized","Galvanized Requiring Replacement"]
[{"$nulls":9},"Lead-lined galvanized","Lead",{"$nulls":4},"Non-Lead",null,"Non-Lead","Non-Lead"]
[{"$nulls":9},"Galvanized","Galvanized",{"$nulls":4},"Non-Lead",null,"Material Unknown","Lead Status Unknown"]
[{"$nulls":9},"Non-Lead - Copper","Non-Lead",{"$nulls":4},"Material Unknown",null,"Lead","Lead"]
[{"$nulls":9},"Non-Lead - Plastic","Non-Lead",{"$nulls":4},"Material Unknown",null,"Galvanized","Galvanized Requiring Replacement"]
[{"$nulls":9},"Non-Lead - Other","Non-Lead",{"$nulls":4},"Material Unknown",null,"Non-Lead","Lead Status Unknown"]
[{"$nulls":9},"Unknown - Likely Lead","Material Unknown",{"$nulls":4},"Material Unknown",null,"Material Unknown","Lead Status Unknown"]
[{"$nulls":9},"Unknown - Unlikely Lead","Material Unknown"]
[null,"system_owned_portion",null,"customer_owned_portion","service_line_classification",{"$nulls":4},"Unknown - Material Unknown","Material Unknown"]
[null,"System-Owned Portion","Was Previously Lead?","Customer-Owned Portion","Classification for Entire Service Line ",null,"IF(",") AND ("," THEN\n"]
[null,"Lead",null,"Lead","Lead",null,{"$f":"_xlfn.CONCAT($G$22,$B$21,\"=\",B23,$H$22,$D$21,\"=\",D23,$I$22,$E$21,\"=\",E23)","v":"IF(system_owned_portion=Lead) AND (customer_owned_portion=Lead THEN\nservice_line_classification=Lead"},{"$f":"_xlfn.CONCAT(F23,G23)","v":"IF(system_owned_portion=Lead) AND (customer_owned_portion=Lead THEN\nservice_line_classification=Lead"},"IF(system_owned_portion=\"Lead\") AND (customer_owned_portion=\"Lead\" THEN\nservice_line_classification=\"Lead\""]
[null,"Lead",null,"Galvanized","Lead","ELSE","IF(system_owned_portion=Lead) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=Lead) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=\"Lead\") AND (customer_owned_portion=\"Galvanized Requiring Replacement\" THEN\nservice_line_classification=\"Lead\""]
[null,"Lead",null,"Non-Lead","Lead","ELSE","IF(system_owned_portion=Lead) AND (customer_owned_portion=Non-Lead THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=Lead) AND (customer_owned_portion=Non-Lead THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=\"Lead\") AND (customer_owned_portion=\"Non-Lead\" THEN\nservice_line_classification=\"Lead\""]
[null,"Lead",null,"Material Unknown","Lead","ELSE","IF(system_owned_portion=Lead) AND (customer_owned_portion=Material Unknown THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=Lead) AND (customer_owned_portion=Material Unknown THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=\"Lead\") AND (customer_owned_portion=Lead Status Unknown THEN\nservice_line_classification=\"Lead\""]
[null,"Galvanized",null,"Lead","Lead","ELSE","IF(system_owned_portion=Galvanized) AND (customer_owned_portion=Lead THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=Galvanized) AND (customer_owned_portion=Lead THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=\"Galvanized1\") AND (customer_owned_portion=Lead THEN\nservice_line_classification=\"Lead\""]
[null,"Galvanized",null,"Galvanized","Non-Lead","ELSE","IF(system_owned_portion=Galvanized) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Non-Lead","ELSEIF(system_owned_portion=Galvanized) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Non-Lead","ELSEIF(system_owned_portion=\"Galvanized1\") AND (customer_owned_portion=\"Galvanized2\" THEN\nservice_line_classification=\"Non-Lead\""]
[null,"Galvanized",null,"Non-Lead","Non-Lead","ELSE","IF(system_owned_portion=Galvanized) AND (customer_owned_portion=Non-Lead THEN\nservice_line_classification=Non-Lead","ELSEIF(system_owned_portion=Galvanized) AND (customer_owned_portion=Non-Lead THEN\nservice_line_classification=Non-Lead","ELSEIF(system_owned_portion=\"Galvanized1\") AND (customer_owned_portion=\"Non-Lead\" THEN\nservice_line_classification=\"Non-Lead\""]
[null,"Galvanized",null,"Material Unknown","Lead Status Unknown","ELSE","IF(system_owned_portion=Galvanized) AND (customer_owned_portion=Material Unknown THEN\nservice_line_classification=Lead Status Unknown","ELSEIF(system_owned_portion=Galvanized) AND (customer_owned_portion=Material Unknown THEN\nservice_line_classification=Lead Status Unknown","ELSEIF(system_owned_portion=\"Galvanized1\") AND (customer_owned_portion=\"Lead Status Unknown\" THEN\nservice_line_classification=\"Lead Status Unknown\""]
[null,"Non-Lead",null,"Lead","Lead","ELSE","IF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Lead THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Lead THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=\"Non-Lead\") AND (customer_owned_portion=\"Lead\" THEN\nservice_line_classification=\"Lead\""]
[null,"Non-Lead",null,"Galvanized","Galvanized Requiring Replacement","ELSE","IF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Galvanized Requiring Replacement","ELSEIF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Galvanized Requiring Replacement","ELSEIF(system_owned_portion=\"Non-Lead\") AND (customer_owned_portion=\"Galvanized2\" THEN\nservice_line_classification=\"Non-Lead\""]
[null,"Non-Lead",null,"Galvanized","Non-Lead","ELSE","IF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Non-Lead","ELSEIF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Non-Lead","ELSEIF(system_owned_portion=\"Non-Lead\") AND (customer_owned_portion=\"Non-Lead\" THEN\nservice_line_classification=\"Non-Lead\""]
[null,"Non-Lead",null,"Galvanized","Galvanized Requiring Replacement","ELSE","IF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Galvanized Requiring Replacement","ELSEIF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Galvanized Requiring Replacement","ELSEIF(system_owned_portion=\"Non-Lead\") AND (customer_owned_portion=\"Lead Status Unknown\" THEN\nservice_line_classification=\"Lead Status Unknown\""]
[null,"Non-Lead",null,"Non-Lead","Non-Lead","ELSE","IF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Non-Lead THEN\nservice_line_classification=Non-Lead","ELSEIF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Non-Lead THEN\nservice_line_classification=Non-Lead","ELSEIF(system_owned_portion=\"Non-Lead, but system is unable to demonstrate it was not previously Lead\") AND (customer_owned_portion=\"Galvanized Requiring Replacement\" THEN\nservice_line_classification=\"Galvanized Requiring Replacement\""]
[null,"Non-Lead",null,"Material Unknown","Lead Status Unknown","ELSE","IF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Material Unknown THEN\nservice_line_classification=Lead Status Unknown","ELSEIF(system_owned_portion=Non-Lead) AND (customer_owned_portion=Material Unknown THEN\nservice_line_classification=Lead Status Unknown","ELSEIF(system_owned_portion=\"Lead Status Unknown\") AND (customer_owned_portion=\"Lead\" THEN\nservice_line_classification=\"Lead\""]
[null,"Material Unknown",null,"Lead","Lead","ELSE","IF(system_owned_portion=Material Unknown) AND (customer_owned_portion=Lead THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=Material Unknown) AND (customer_owned_portion=Lead THEN\nservice_line_classification=Lead","ELSEIF(system_owned_portion=\"Lead Status Unknown\") AND (customer_owned_portion=\"Galvanized Requiring Replacement\" THEN\nservice_line_classification=\"Galvanized Requiring Replacement\""]
[null,"Material Unknown",null,"Galvanized","Galvanized Requiring Replacement","ELSE","IF(system_owned_portion=Material Unknown) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Galvanized Requiring Replacement","ELSEIF(system_owned_portion=Material Unknown) AND (customer_owned_portion=Galvanized THEN\nservice_line_classification=Galvanized Requiring Replacement","ELSEIF(system_owned_portion=\"Lead Status Unknown\") AND (customer_owned_portion=\"Non-Lead\" THEN\nservice_line_classification=\"Lead Status Unknown\""]
[null,"Material Unknown",null,"Non-Lead","Lead Status Unknown","ELSE","IF(system_owned_portion=Material Unknown) AND (customer_owned_portion=Non-Lead THEN\nservice_line_classification=Lead Status Unknown","ELSEIF(system_owned_portion=Material Unknown) AND (customer_owned_portion=Non-Lead THEN\nservice_line_classification=Lead Status Unknown","ELSEIF(system_owned_portion=\"Lead Status Unknown\") AND (customer_owned_portion=\"Lead Status Unknown\" THEN\nservice_line_classification=\"Lead Status Unknown\""]
[null,"Material Unknown",null,"Material Unknown","Lead Status Unknown",null,null,"ELSE service_line_classification = \"CLASSIFICATION ERROR\"","ELSE \"CLASSIFICATION ERROR\""]

{"sheet":"Form Lists","index":12,"n_rows":13,"n_cols":19,"rows_kept":13,"hidden":true}
["Tab","Form Control Lists"]
["Detailed Inventory","Sensitive Population? (Y/N)","Service Line Material Classification*","If Non-Lead,\nWas Material Ever Previously Lead?","Basis of Material Classification","Was the Service Line Material Field Verified?","Select the Field Verification Method","Building Type Connected to Service Line","For CWSs, do Multi-family Residences (MFRs) Comprise at Least 20% of the Structures You Serve?","Is there a Lead Connector Present?","Point-of-Entry or Point-of-Use Treatment Present?","Does the Interior Building Plumbing Contain Copper Pipes with Lead Solder Installed before your State's Lead Ban (Generally 1986 - 1988)"," Current LCR Sampling Site?","Building Type Connected to Service Line","For CWSs, do Multi-family Residences (MFRs) Comprise at Least 20% of the Structures You Serve?","Is there a Lead Connector Present?","Point-of-Entry or Point-of-Use Treatment Present?","Does the Interior Building Plumbing Contain Copper Pipes with Lead Solder Installed before your State's Lead Ban (Generally 1986 - 1988)"," Current LCR Sampling Site?"]
[null,"No","Lead","Yes","Previous materials evaluation","Yes","Visual inspection at meter pit","Single Family Residence","Yes","Yes","Yes","Yes","Yes","Single Family Residence","Yes","Yes","Yes","Yes","Yes"]
[null,"Yes - School","Lead-lined galvanized","No","Installation record (e.g., tap card)","No","Customer self-identification","Multiple Family Residence"," No","Known"," No"," No","No","Multiple Family Residence"," No","Known"," No"," No","No"]
[null,"Yes - Day Care","Galvanized","Don't know","Installation date is after the lead ban",null,"CCTV Inspection at Curb Box - Internal","Building","N/A","Unknown","Unknown","Unknown",null,"Building","N/A","Unknown","Unknown","Unknown"]
[null,"Yes - Other","Non-Lead - Copper",null,"Service line diameter is greater than 2 inches",null,"CCTV inspection at Curb Box - External","Other",{"$nulls":5},"Other"]
[null,null,"Non-Lead - Plastic",null,"Service line repair or replacement record",null,"Water Quality Sampling - Targeted"]
[null,null,"Non-Lead - Other",null,"Statistical analysis",null,"Water Quality Sampling - Flushed"]
[null,null,"Unknown - Likely Lead",null,"Field inspection only with no records",null,"Water Quality Sampling - Sequential"]
[null,null,"Unknown - Unlikely Lead",null,"Water sampling only with no records",null,"Water Quality Sampling - Other"]
[null,null,"Unknown - Material Unknown",null,"Other",null,"Mechanical Excavation at 1 location"]
[{"$nulls":6},"Mechanical Excavation at multiple locations"]
[null,"Note to EPA: this is a background sheet to be hidden or deleted",{"$nulls":3},"Other"]