{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Instructions","Develop PCCM","PCCM","Rev. Sum.","Recs","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":14,"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":"Introduction","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,2,13,3],[7,2,7,5],[8,2,8,5],[10,2,10,5],[1,2,2,7],[4,2,4,5]]}
["Welcome to the post-construction compliance monitoring (PCCM) checklist! Use the tab key to navigate the checklist and the enter key to toggle navigation buttons. Stay here to listen to a description of the checklist.\n\nEPA created this checklist to help combined sewer overflow (CSO) permittees and National Pollutant Discharge Elimination System (NPDES) authorities develop and evaluate PCCM programs to meet the requirements of the CSO Control Policy. The checklist is based on existing EPA guidance such as the Post-Construction Compliance Monitoring Guidance. The checklist also provides a list of recommendations that can be used to improve the PCCM portion of a long-term control plan (LTCP). Due to the site-specific nature of CSOs and LTCPs, the checklist includes additional fields for the user to fully document their specific situation.\n\nClick the Microsoft Excel buttons or options to \"Enable Content\" or \"Enable Macros\" if prompted to, as the checklist uses macros to function. Press tab to continue.\n\n"]
[null,null,"Post-Construction Compliance Monitoring (PCCM) Checklist"]
["Disclaimer: The statements in this document are intended solely as suggestion. This document is not intended, nor can it be relied on, to create any rights enforceable by any party in litigation with the United States. Long-term CSO control plans are site-specific in nature. EPA, state officials and CSO permittees may decide to follow the suggestion provided in this document, or to act at variance with the suggestion, based on an analysis of site-specific circumstances."]
["Button: Get Started"]
[null,null,"Welcome to the post-construction compliance monitoring (PCCM) checklist! EPA created this checklist to help combined sewer overflow (CSO) permittees and National Pollutant Discharge Elimination System (NPDES) authorities develop and evaluate PCCM programs to meet the requirements of the CSO Control Policy. The checklist is based on existing EPA guidance such as the Post-Construction Compliance Monitoring Guidance. The checklist also provides a list of recommendations that can be used to improve the PCCM portion of long-term control plans (LTCPs). Due to the site-specific nature of CSOs and LTCPs, the checklist includes additional fields for the user to fully document their specific situation."]
[]
[]
[null,null,"Click on the \"Get Started\" button below to begin:"]
[null,null,"(If prompted by Microsoft Excel (there may be a yellow ribbon at the top of your screen) click the button to \"Enable Content\" or \"Enable Macros.\")"]
[]
[null,null,"Disclaimer: The statements in this document are intended solely as suggestions. This document is not intended, nor can it be relied on, to create any rights enforceable by any party in litigation with the United States. Long-term CSO control plans are site-specific in nature. EPA, state officials, and CSO permittees may decide to follow a suggestion provided in this document, or to act at variance with the suggestion, based on an analysis of site-specific circumstances."]
[]
[null,null,"https://www.epa.gov/npdes/contact-us-combined-sewer-overflows-csos "]

{"sheet":"Instructions","index":1,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[[12,2,12,3],[13,2,13,8],[14,2,14,8],[15,2,15,8],[1,2,2,7],[17,2,17,8],[18,2,18,8],[19,2,19,8],[20,2,20,8],[21,2,21,8],[22,2,22,8],[35,2,35,4],[24,2,24,3],[31,2,31,6],[25,3,25,6],[26,3,26,6],[27,3,27,6],[28,3,28,6],[29,3,29,6]]}
["Welcome to the Getting Started page. On this page are instructions for how to use the checklist, as well as a navigation menu that can be used to navigate to other pages of the checklist at any time. The same navigation menu is available on all pages. Use the tab key to move through the page and the enter key to go to other pages when that page's button is selected."]
["Instructions:\n1. Fill out the User Information section that follows these instructions.\n2. After entering you User Information, toggle through the user options to select the approach that was used for the LTCP. Options include presumption approaches one through three, demonstration approach, separation approach or other. Selecting a specific option will bring you to a specific set of questions designed for that approach.\n3. If you are pursuing different approaches in different parts of your sewershed, use a separate copy of the checklist for each approach.\n4. Enter required information throughout the checklist where prompted. Note any relevant supporting documentation in the space provided after each question. Be sure to include details like title, date and version where applicable.\n5. Navigate to different pages using the tab key to toggle across navigation buttons.\n6. In many cases, helpful resources are identified for specific questions after data input cells. Click the links or use the description of the resource document and specific page number to access these helpful resources, which include sections from EPA's CSO Post-Construction Compliance Monitoring Guidance.\n7. Use the Additional Considerations cell at the bottom of each page to provide additional details specific to the PCCM under review.\n8. Once you answer all questions, go to the 3. Addressed Items page to see a summary of the documents reviewed as part of the PCCM review.\n9. Finally, go to the 4. Recommendations page to see a list of suggested improvements for the PCCM program.\n10. To clear all information and start over, click Control + r to reset the entire form or click individual page reset buttons that are at the end of each page.",null,"Post-Construction Compliance Monitoring (PCCM) Checklist"]
[]
["Button: Go to the 1. Developing a PCCM Plan page"]
["Button: Go to the 2. PCCM Implementation page"]
["Button: Go to the 3. Addressed Items page"]
["Button: Go to the 4. Recommendations page"]
["Button: Full Reset"]
["Button: Go back to the Introduction page"]
[]
[]
[]
[null,null,"Instructions:"]
[null,null,"1. Fill out the \"User Information\" section below."]
[null,null,"2. Click the appropriate button under \"Select your LTCP approach!\""]
[null,null,"3. If you are pursuing different approaches in different parts of your sewershed, use a separate copy of the checklist for each approach."]
[null,null,"4. Enter the required information in red cells throughout the checklist. Note the specific supporting documentation (include title, date, version)."]
[null,null,"5. Navigate to a different section using the tabs at the top of each page or the \"Next\" or \"Previous\" buttons at the bottom of each page."]
[null,null,"6. Click the i button to the right of each question to access helpful resources, including EPA's CSO Post-Construction Compliance Monitoring Guidance. Where applicable, a specific page is noted to point to a relevant section of the suggested guidance document."]
[null,null,"7. Use the \"Additional Considerations\" box at the bottom on each page to provide additional details specific to the PCCM program under review."]
[null,null,"8. Once you answer all questions, go to the \"3. Addressed Items\" page to see a summary of the documents reviewed for PCCM program review."]
[null,null,"9. Finally, go to the \"4. Recommendations\" page to see a list of suggested improvements for the PCCM program."]
[null,null,"10. To clear all information and start over, click the \"Full Reset\" button in the top right corner or \"Reset All Entries\" button at the bottom of each page."]
[]
[null,null,"User Information:"]
[null,null,"Reviewer:"]
[null,null,"Permittee Name(s):"]
[null,null,"Permit Number(s):"]
[null,null,"PCCM Plan Name, Date and Version:"]
[null,null,"Date:"]
["Button: Press enter if the LTCP is based on the Presumption Approach Criterion 1."]
["Button: Press enter if the LTCP is based on the Presumption Approach Criterion 2.",null,"Select your LTCP approach! *"]
["Button: Press enter if the LTCP is based on the Presumption Approach Criterion 3."]
["Button: Press enter if the LTCP is based on the Demonstration Approach."]
["Button: Press enter if the LTCP is based on the Separation Approach."]
["Button: Press enter if the LTCP is based on an Other Approach.",null,"*Criterion i is based on the frequency of CSO events\n Criterion ii is based on the flow and volume of CSO events\n Criterion iii is based on average pollutant load\n Other may include previous CSO control efforts undertaken prior to the CSO Control Policy"]
["Button: Go back to the Introduction page"]
[]
["a\na"]
["a\na"]

{"sheet":"Develop PCCM","index":2,"n_rows":85,"n_cols":9,"rows_kept":85,"cut":false,"hidden":false,"merged":[[81,2,81,6],[80,2,80,7],[1,2,1,7],[9,5,9,6],[10,2,10,6],[11,2,11,6],[79,2,79,6]]}
["1. Developing a PCCM Plan. This page includes questions about PCCM plan development. Use the tab key to move through the page and the enter key to go to other pages when that page's button is selected."]
[null,null,"Post-Construction Compliance Monitoring (PCCM) Checklist"]
["Button: Go to the Getting Started page"]
[]
["Button: Go to the 2. PCCM Implementation page"]
["Button: Go to the 3. Addressed Items page"]
["Button: Go to the 4. Recommendations page"]
[]
[]
["applies to","number","Answer the following questions regarding PCCM plan development.","Yes or No?","If Yes, note the specific document that was used to support this answer, including title, date, and version, as applicable. If No, what still needs to be done?","Helpful Resources",null,"Predication","Filter"]
["all",null,"Developing a PCCM Plan"]
["P, D, O",null,"General"]
["P, D, O",21,"Did the permittee monitor receiving water(s) to assess impacts under different CSO loads and conditions, discern background conditions and other sources, and demonstrate water quality standards attainment or the need for a total maximum daily load or a use attainability analysis?",null,null,"i\nChapter 8"]
["P, D, O",22,"Has the permittee developed quality assurance project plans that clearly describe, e.g., environmental data collection, quality objectives and key project personnel?",null,null,"i\nPage 29"]
["P, D, O",23,"Has the permittee developed plans for assessing the effectiveness of CSO controls as part of the PCCM plan?",null,null,"i\nPage 31"]
["P, D, O",24,"Has the permittee developed field sampling plans as part of the PCCM plan?",null,null,"i\nPage 35"]
["P, D, O","24b","Has the permittee developed a pre-construction sampling plan?"]
["P, D, O",25,"Did the permittee develop the PCCM field sampling plan based on the pre-construction sampling plan?",null,null,null,null,12]
["P, D, O",26,"Does the permittee use the same field sampling locations identified during pre-construction monitoring and modeling?",null,null,null,null,13]
["P, D, O",27,"Does the permittee address the sensitive areas identified during pre-construction monitoring and modeling?",null,null,null,null,"15h"]
["P, D, O",28,"Did the permittee address any bottlenecks in the CSS identified during pre-construction monitoring and modeling?",null,null,null,null,"15f"]
["P, D, O",30,"Has the permittee developed standard operating procedures as part of the PCCM plan?",null,null,"i\nPage 38"]
["P, D, O",31,"What initial, or baseline, monitoring has the permittee conducted:"]
["P, D, O","31a","        Flows/volume during CSO events?",null,null,"i\nPage 26","i"]
["P, D, O","31b","        Frequency of CSO events?",null,null,"i\nPage 26","i"]
["P, D, O","31c","        Duration of CSO events?",null,null,"i\nPage 26","i"]
["P, D, O","31d","        Basic ambient water quality assessments?",null,null,"i\nPage 26","i"]
["P, D, O","31e","        Basic stormwater quality assessments?",null,null,"i\nPage 26","i"]
["P, D, O","31f","        Basic water quality assessments of CSOs?",null,null,"i\nPage 26","i"]
["P, D, O","31g","        Other - provide explanation?",null,null,"i\nPage 26","i"]
["P, D, O",null,"PCCM Plan Relationship to NMC and LTCPs (3.1)",null,null,"i"]
["PC1",32,"Does the PCCM plan include monitoring for the number of CSO events?",null,null,"i\nPage 27"]
["PC2",33,"Does the PCCM plan include monitoring for the CSO volume discharged?"]
["PC3",34,"Does the PCCM plan include monitoring for the mass of pollutants identified as potentially causing water quality impairments?"]
["P, D, O",35,"Does the permittee use the same methods used for pre-construction characterization of the CSS in the PCCM plan for:"]
["P, D, O","35a","        Monitoring locations?",null,null,"i\nPage 28"]
["P, D, O","35b","        Parameters monitored?",null,null,"i\nPage 28"]
["P, D, O","35c","        Frequency of monitoring?",null,null,"i\nPage 28"]
["P, D, O","35d","        Frequency of dry vs wet weather monitoring?",null,null,"i\nPage 28"]
["P, D, O",36,"Does the permittee analyze the same parameters that were identified as causing water quality impacts during the receiving water characterization phase of the LTCP?",null,null,"i\nPage 29"]
["P, D, O",37,"Is the PCCM plan based on typical year or pre-construction baseline data?",null,null,"i\nPage 29"]
["P, D, O",null,"Data Quality Considerations (3.2)",null,null,"i"]
["P, D, O",38,"Does the permittee determine data quality objectives and criteria that describe quality specifications regarding the level of the decision or study question and the level of the measurements to support the decision or study question?",null,null,"i\nPage 30",null,22,{"$f":"IF(VLOOKUP(H43,B:D,3,FALSE)=\"No\",\"hide\",\"\")","v":""}]
["P, D, O",39,"Does the permittee minimize type I and type II decision errors (false positives and negatives)?",null,null,"i\nPage 30",null,22,""]
["P, D, O",40,"Does the permittee describe the types of environmental data that will be collected and the name(s) of the organizations responsible for their collection?",null,null,"i\nPage 31",null,22,""]
["P, D, O",null,"CSO Control Assessment Plan (3.3)",null,null,"i"]
["P, D, O",41,"Does the CSO control assessment plan include a discussion of the basic approach (i.e., Presumption Approach or Demonstration Approach) selected by the permittee in the LTCP to verify the effectiveness of CSO controls?",null,null,"i\nPage 31",null,23,""]
["P, D, O",42,"Is the CSO control assessment plan approved by the NPDES authority?",null,null,"i\nPage 31",null,23,""]
[{"$f":"IF(VLOOKUP(H49,'Develop PCCM'!B:H,3,FALSE)=\"No\",\"hide\",\"P\")","v":"P"},43,"Does the permittee define system-wide and annual average conditions?",null,null,"i\nPage 31",null,23,""]
[{"$f":"IF(VLOOKUP(H50,'Develop PCCM'!B:H,3,FALSE)=\"No\",\"hide\",\"P\")","v":"P"},44,"Does the permittee describe how CSOs will be evaluated through direct monitoring?",null,null,"i\nPage 32",null,23,""]
[{"$f":"IF(VLOOKUP(H51,'Develop PCCM'!B:H,3,FALSE)=\"No\",\"hide\",\"P\")","v":"P"},47,"Does the permittee discuss how monitored data will be evaluated on an average annual basis to verify whether the CSO controls are meeting the goals of the selected approach?",null,null,"i\nPage 32",null,23,""]
[{"$f":"IF(VLOOKUP(H52,'Develop PCCM'!B:H,3,FALSE)=\"No\",\"hide\",\"PC2\")","v":"PC2"},48,"Does the permittee describe how flows to the CSS (e.g., flows from satellite communities that contribute to the CSS, infiltration and inflow in separate sanitary areas that contribute flow to the CSS) will be identified?",null,null,"i\nPage 32",null,23,""]
[{"$f":"IF(VLOOKUP(H53,'Develop PCCM'!B:H,3,FALSE)=\"No\",\"hide\",\"PC2\")","v":"PC2"},49,"If additional flows need to be identified, does the permittee describe what tools will be used to identify these flows, including additional monitoring to determine flow contributions from different parts of the system?",null,null,"i\nPage 32",null,23,""]
[{"$f":"IF(VLOOKUP(H54,'Develop PCCM'!B:H,3,FALSE)=\"No\",\"hide\",\"PC2\")","v":"PC2"},50,"Does the permittee describe the location(s) at which flow will be measured and the flow monitoring equipment?",null,null,"i\nPage 32",null,23,""]
[{"$f":"IF(VLOOKUP(H55,'Develop PCCM'!B:H,3,FALSE)=\"No\",\"hide\",\"PC2\")","v":"PC2"},51,"Does the permittee describe how many years of data they will use for the percent capture analysis?",null,null,"i\nPage 32",null,23,""]
[{"$f":"IF(VLOOKUP(H56,'Develop PCCM'!B:H,3,FALSE)=\"No\",\"hide\",\"PC3\")","v":"PC3"},52,"Does the permittee describe how the mass of pollutants identified as causing water quality impairment for the volumes that would be eliminated or captured for treatment under criterion iii of the presumption approach will be eliminated or removed?",null,null,"i\nPage 33",null,23,""]
[{"$f":"IF(VLOOKUP(H57,'Develop PCCM'!B:H,3,FALSE)=\"No\",\"hide\",\"PC3\")","v":"PC3"},53,"Does the permittee describe how average pollutant loads will be calculated (using a mass balance approach) to evaluate the elimination or removal of pollutants?",null,null,"i\nPage 33",null,23,""]
[{"$f":"IF(VLOOKUP(H58,'Develop PCCM'!B:H,3,FALSE)=\"No\",\"hide\",\"PC3\")","v":"PC3"},54,"If average pollutant loads have not been previously determined, does the permittee describe what information will be used to assign them, such as historical data from the CSS, treatment plant optimization studies, and facility plans and designs?",null,null,"i\nPage 33",null,23,""]
["P, D, O",null,"Field Sampling Plan (3.4)",null,null,"i"]
["P, D, O",57,"Is the field sampling plan approved by the NPDES authority?",null,null,"i\nPage 35",null,24,""]
["P, D, O",58,"Does the field sampling plan address assessment of the CSO controls and both effluent and ambient monitoring?",null,null,"i\nPage 35",null,24,""]
["P, D, O",59,"Is ambient  monitoring done at CSO outfalls and outside the area of CSO impact, including areas upstream of CSOs?",null,null,"i\nPage 35",null,24,""]
["P, D, O",60,"Does the field sampling plan provide detailed monitoring protocols and associated schedules (including the duration of different monitoring activities)?",null,null,"i\nPage 35",null,24,""]
["P, D, O",61,"Do the monitoring protocols include the necessary effluent and ambient monitoring, and, where appropriate, biological assessments, whole effluent toxicity testing, and sediment sampling?",null,null,"i\nPage 35",null,24,""]
["P, D, O",62,"Does the PCCM plan identify the types of pollutants and parameters to be analyzed for effluent and ambient monitoring?",null,null,"i\nPage 36",null,24,""]
["P, D, O",63,"Does the field sampling plan address the following major elements:",null,null,null,null,24,""]
["P, D, O","63a","Duration of monitoring program?",null,null,"i\nPage 36",null,24,""]
["P, D, O","63b","Monitoring locations?",null,null,"i\nPage 36",null,24,""]
["P, D, O","63c","Frequency of sampling and number of wet-weather events to be sampled?",null,null,"i\nPage 36",null,24,""]
["P, D, O","63d","Criteria for when samples will be collected (e.g., criteria for both wet weather events and ambient conditions, i.e., x days/hours from the previous precipitation events, greater than x days between events, rainfall events greater than 0.4 inch to be sampled)?",null,null,"i\nPage 36",null,24,""]
["P, D, O","63e","Strategy for determining when to initiate wet-weather monitoring?",null,null,"i\nPage 36",null,24,""]
["P, D, O","63f","Sampling protocols (e.g., sample types, sample containers, preservation methods)?",null,null,"i\nPage 36",null,24,""]
["P, D, O","63g","Flow measurement protocols?",null,null,"i\nPage 36",null,24,""]
["P, D, O","63h","Pollutants or parameters to be analyzed or measured?",null,null,"i\nPage 36",null,24,""]
["P, D, O","63i","Sampling and safety equipment and personnel?",null,null,"i\nPage 36",null,24,""]
["P, D, O","63j","Quality assurance/quality control procedures for sampling and analysis?",null,null,"i\nPage 36",null,24,""]
["P, D, O","63k","Procedures for validating, tracking and reporting sampling results?",null,null,"i\nPage 36",null,24,""]
["P, D, O",null,"Standard Operating Procedures (3.5)",null,null,"i"]
["P, D, O",64,"Are all applicable standard operating procedures included as attachments to the quality assurance project plan or PCCM plan?",null,null,"i\nPage 38",null,22,""]
["all",null,"Additional Considerations - Developing a PCCM Plan"]
[null,null,"If there are other considerations not noted above and related to PCCM plan development, note them here."]
[]
["Botton: Go to the previous page."]
["Button: Reset all entries on this page."]
["Botton: Go to the next page."]

{"sheet":"PCCM","index":3,"n_rows":90,"n_cols":9,"rows_kept":90,"cut":false,"hidden":false,"merged":[[85,2,85,8],[1,2,1,7],[9,5,9,6],[84,2,84,6],[86,2,86,6],[10,2,10,6]]}
["2. PCCM Implementation. This page includes questions about PCCM Implementation. Use the tab key to move through the page and the enter key to go to other pages when that page's button is selected."]
[null,null,"Post-Construction Compliance Monitoring (PCCM) Checklist"]
["Button: Go to the Getting Started page"]
["Button: Go to the 1. Developing a PCCM Plan page"]
[]
["Button: Go to the 3. Addressed Items page"]
["Button: Go to the 4. Recommendations page"]
[]
[]
["applies to","number","Answer the following questions regarding PCCM implementation.","Yes or No?","If Yes, note the specific document that was used to support this answer, including title, date, and version, as applicable. If No, what still needs to be done?","Helpful Resources",null,"Predication","Filter"]
["all",null,"PCCM Implementation"]
["all",null,"Monitoring to Verify the Effectiveness of CSO Controls (4.1)",null,null,"i"]
["PC1",67,"Are the overflow data presented so that they can be evaluated on an average annual basis?",null,null,"i\nPage 43"]
["PC1",68,"Does the permittee provide data on the number of overflows from the CSS that meet the overflow definition provided in the CSO Control Policy?",null,null,"i\nPage 43"]
["PC1",69,"Has the permittee developed a plan that summarizes:"]
["PC1","69a","What method or combination of methods they will use to determine if CSO discharges have occurred in the CSS?",null,null,"i\nPage 44"]
["PC1","69b","Which CSOs they will monitor within the system?",null,null,"i\nPage 44"]
["PC1","69c","When and how often they will monitor them?",null,null,"i\nPage 44"]
["PC1","69d","What type of data they will collect from an event?",null,null,"i\nPage 44"]
["PC1","69e","How that data should be used to determine if a CSO event has occurred?",null,null,"i\nPage 44"]
["PC1","69f","How their data are representative of all the CSOs in the system?",null,null,"i\nPage 44"]
["PC2",73,"Does the permittee ensure that the flow values used to evaluate compliance with CSO volume control targets include contributions of the various parts of the collection system and that the remaining CSO volumes are calculated accurately?",null,null,"i\nPage 49"]
["PC2,PC3",74,"Does the permittee provide supporting data and calculations for the volume of combined sewage in the CSS during precipitation events?",null,null,"i\nPage 49"]
["PC2,PC3",76,"Does the determination of combined sewage \"during precipitation events\" include the time frame of the precipitation event that is producing runoff, plus some additional time period for the CSS to drain?",null,null,"i\nPage 51"]
["PC2",77,"Does the permittee present several years' worth of data on percent capture to allow an evaluation of compliance with criterion ii of the presumption approach?",null,null,"i\nPage 56"]
["P, D, O",78,"Does the permittee include monitoring to collect data for performance or treatment requirements for specific control technologies?",null,null,"i\nPage 60"]
["S",80,"Has the permittee implemented any program to identify the following:"]
["S","80a","Illicit discharge from the collection system?"]
["S","80b","Basement backups?"]
["S","80c","Discharge from former outfall locations?"]
["S","80d","Effectiveness of the sewer separation?"]
["O",81,"Did the permittee complete the relevant components of the LTCP that might not have been addressed by the permittee's previous efforts or that represent ongoing commitments, including development of an operations and maintenance program and PCCM plan?",null,null,"i\nPage 62"]
["P, D, O",null,"Ambient Monitoring for Assessing Compliance with WQS (4.2)",null,null,"i"]
["P, D, O",82,"Does the permittee coordinate with other state and local monitoring efforts?",null,null,"i\nPage 63"]
["P, D, O",83,"Does the PCCM plan detail the monitoring protocols to be followed, including the necessary effluent and ambient monitoring and, where appropriate, other monitoring protocols such as biological assessments, whole effluent toxicity testing, and sediment sampling?",null,null,"i\nPage 63"]
["P, D, O",84,"Does the permittee make sure the secondary data used from other sources are quality data?",null,null,"i\nPage 63"]
["P, D, O",85,"Does the permitting authority apply the NPDES Watershed Framework, where all interested parties are involved in designing and implementing watershed goals?",null,null,"i\nPage 63"]
["P, D, O",86,"Did the permittee select the pollutants to be included in the PCCM program in consultation with the NPDES authority?",null,null,"i\nPage 66"]
["P, D, O",87,"Does the permittee monitor for:"]
["P, D, O","87a","Pollutants of concern?",null,null,"i\nPage 66"]
["P, D, O","87b","Pollutants discharged to sensitive areas?",null,null,"i\nPage 66"]
["P, D, O","87c","Pollutants causing impairment of receiving waterbody designated uses?",null,null,"i\nPage 66"]
["P, D, O","87d","Pollutants causing exceedances of receiving water quality standards?",null,null,"i\nPage 66"]
["P, D, O","87e","Pollutants discharged by industrial users in quantities that are expected to adversely affect receiving water quality?",null,null,"i\nPage 66"]
["P, D, O",88,"Does the permittee, in consultation with the NPDES authority, determine what EPA, state, and local water quality criteria or standards are applicable to the specific designated use(s) of the receiving water are available for these pollutants?",null,null,"i\nPage 66","i"]
["P, D, O",89,"Does the permittee consult with the NPDES authority to determine whether CSOs are discharging into sensitive areas when determining the specific designated use(s) of the receiving water?",null,null,"i\nPage 66"]
["P, D, O",90,"Did the permittee discuss with the NPDES authority the sampling protocols and analytical methods acceptable for analysis of pollutants in receiving water?",null,null,"i\nPage 66"]
["P, D, O",91,"Does the permittee's field sampling plan follow the sampling and analytical procedures in Title 40 of the CFR Part 136 (Appendix E), including the use of appropriate sample containers, sample preservation methods, maximum allowable holding times, described in Table II of Part 136.3, and analytical methods approved for NPDES compliance monitoring detailed in Tables IA - IH of Part 136.3?",null,null,"i\nPage 67"]
["P, D, O",92,"Does the permittee, in consultation with the NPDES authority, determine whether any additional parameters or field monitoring should be selected for PCCM?",null,null,"i\nPage 71"]
["P, D, O",93,"Does the permittee consider the following receiving water characteristics when choosing sampling locations?"]
["P, D, O","93a","Locations of sensitive areas?",null,null,"i\nPage 73"]
["P, D, O","93b","Upstream and downstream of CSO outfalls?",null,null,"i\nPage 73"]
["P, D, O","93c","Location and impacts of other sources of pollutant loadings; when possible, does the permittee select monitoring locations that have limited or known effects from other pollutant sources?",null,null,"i\nPage 73"]
["P, D, O","93d","Location of historical monitoring locations used to initially characterize CSO impacts?",null,null,"i\nPage 73"]
["P, D, O","93e","Size of the waterbody?",null,null,"i\nPage 73"]
["P, D, O","93f","Horizontal and vertical variability in the waterbody?",null,null,"i\nPage 73"]
["P, D, O","93g","Degree of resolution necessary to assess attainment of water quality standards?",null,null,"i\nPage 73"]
["P, D, O","93i","Physical logistics (accessibility, whether water is navigable, if bridges are available from which to sample)?",null,null,"i\nPage 73"]
["P, D, O","93j","Crew safety?",null,null,"i\nPage 73"]
["P, D, O",94,"Are samples obtained at mid-depth (avoiding collection of sediment from the bottom and any scum at the top) at the midpoint of the waterbody to obtain a sample from a well-mixed portion of the river or stream?",null,null,"i\nPage 74"]
["P, D, O",95,"Does the permittee choose sampling locations that represent the worst-case scenario (areas that receive overflows most frequently or have the largest pollutant loading or flow volume, sensitive areas) if only a few locations can be monitored?",null,null,"i\nPage 75"]
["P, D, O",96,"Does the permittee coordinate CSO receiving water monitoring for primary and secondary contact recreation areas with existing water quality monitoring performed under the BEACH Act?",null,null,"i\nPage 75"]
["P, D, O",97,"Are CSO discharges to waters designated for public water supply evaluated adjacent to intakes to ensure that any potential pollutants posing human health risk do not exceed treatment capacity of the distribution system?",null,null,"i\nPage 76"]
["P, D, O",98,"Is rainfall measured using rain gauges throughout the CSS drainage area to evaluate local rainfall conditions and the impact of CSOs on receiving water?",null,null,"i\nPage 76"]
["P, D, O",99,"Does the PCCM plan provide locations of stream gauge stations?",null,null,"i\nPage 77"]
["P, D, O",100,"Does the permitting community ensure that most receiving water monitoring is performed during those seasons, flow regimes, and other critical conditions during which it is expected that CSOs would have the greatest potential for effects?",null,null,"i\nPage 78"]
["P, D, O",101,"Does the permittee collect samples during dry-weather events, wet-weather events during which a CSO is not expected to occur, and wet-weather events during which a CSO is expected to occur?",null,null,"i\nPage 79"]
["P, D, O",102,"Does the permittee monitor storms of varying intensity with a variety of pre-storm conditions (e.g., varying number of days since the last storm, varying intensity of the previous storms) and preceding dry days to represent a range of conditions experienced by the CSS?",null,null,"i\nPage 79"]
["P, D, O",null,"Assessing Compliance with the Nine Minimum Controls"]
["P, D, O",103,"Did the permittee verify the proper operation and regular maintenance programs for the sewer system and CSOs?"]
["P, D, O",104,"Did the permittee verify they maximize use of the collection system for storage?"]
["P, D, O",105,"Did the permittee verify the pretreatment requirements to assure CSO impacts are minimized?"]
["P, D, O",106,"Did the permittee verify they maximize the flow to the POTW treatment plant?"]
["P, D, O",107,"Did the permittee verify the prohibition of CSOs during dry weather?"]
["P, D, O",108,"Did the permittee verify the monitoring program effectively characterizes the CSO impacts and the efficacy of CSO controls?"]
["P, D, O",null,"Additional CSO Controls",null,null,null,null,17]
["P, D, O",109,"Is the permittee achieving the expected runoff control volume using green infrastructure?",null,null,null,null,17]
["P, D, O",110,"Is the permittee achieving the expected volume of retention controls using green infrastructure?",null,null,null,null,17]
["all",null,"LTCP Approach Requirements"]
["PC1",111,"Did the permittee verify no more than an average of four to six overflow events per year system-wide?",null,null,"i\nPage 6"]
["PC2",112,"Did the permittee verify the elimination or capture for treatment of no less than 85% by volume of the combined sewage collected in the CSS during precipitation events on a system-wide annual average basis?",null,null,"i\nPage 6"]
["PC3",113,"Did the permittee verify the elimination or removal of no less than the mass of the pollutants identified as causing water quality impairment through the sewer system characterization, monitoring, and modeling effort, for the volumes that would be eliminated or captured for treatment?",null,null,"i\nPage 6"]
["D",114,"Did the permittee demonstrate that the selected CSO control program can meet the water quality-based requirements of the Clean Water Act?"]
["O",115,"Did the permittee verify that the CSO Control Plan will attain water quality standards and meet the requirements of the CSO Control Policy?",null,null,"i\nPage 5"]
[null,null,"Additional Considerations - PCCM Implementation"]
[null,null,"If there are other considerations not noted above and related to PCCM implementation, note them here."]
[]
["Botton: Go to the previous page."]
["Button: Reset all entries on this page."]
["Botton: Go to the next page."]

{"sheet":"Rev. Sum.","index":4,"n_rows":150,"n_cols":9,"rows_kept":150,"cut":false,"hidden":false,"merged":[[146,2,146,5],[147,2,147,5],[76,2,76,5],[1,2,1,6],[11,4,11,5],[12,2,12,5],[75,2,75,5],[77,2,77,5]]}
["a"]
[null,null,"Post-Construction Compliance Monitoring (PCCM) Checklist"]
["Button: Go to the Getting Started page"]
["Button: Go to the 1. Developing a PCCM Plan page"]
["Button: Go to the 2. PCCM Implementation page"]
[]
["Button: Go to the 6. Recommendations page"]
["Button: Press enter to see Addressed Items"]
[]
[]
[]
["addressed?",null,"Items identified by the reviewer as addressed and documented (i.e., questions were answered with a \"Yes\").","Documentation used to support the items to the left.","Helpful Resources",null,"dependency","scenario filter","question filter"]
["Yes",null,"Developing a PCCM Plan"]
[{"$f":"VLOOKUP(B14,'Develop PCCM'!B:I,3,FALSE)","v":0},21,"Did the permittee monitor receiving water(s) to assess impacts under different CSO loads and conditions, discern background conditions and other sources, and demonstrate water quality standards attainment or the need for a total maximum daily load or a use attainability analysis?",{"$f":"IF(ISBLANK(VLOOKUP(B14,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B14,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nChapter 8",null,null,{"$f":"_xlfn.XLOOKUP(B14,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B15,'Develop PCCM'!B:I,3,FALSE)","v":0},22,"Has the permittee developed quality assurance project plans as part of the PCCM plan?",{"$f":"IF(ISBLANK(VLOOKUP(B15,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B15,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 29",null,null,{"$f":"_xlfn.XLOOKUP(B15,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B16,'Develop PCCM'!B:I,3,FALSE)","v":0},23,"Has the permittee developed plans for assessing the effectiveness of CSO controls as part of the PCCM plan?",{"$f":"IF(ISBLANK(VLOOKUP(B16,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B16,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 31",null,null,{"$f":"_xlfn.XLOOKUP(B16,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B17,'Develop PCCM'!B:I,3,FALSE)","v":0},24,"Has the permittee developed field sampling plans as part of the PCCM plan?",{"$f":"IF(ISBLANK(VLOOKUP(B17,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B17,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,null,{"$f":"_xlfn.XLOOKUP(B17,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B18,'Develop PCCM'!B:I,3,FALSE)","v":0},"24b","Has the permittee developed a pre-construction sampling plan?",{"$f":"IF(ISBLANK(VLOOKUP(B18,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B18,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B18,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B19,'Develop PCCM'!B:I,3,FALSE)","v":0},25,"Did the permittee develop the PCCM field sampling plan based on the pre-construction sampling plan?",{"$f":"IF(ISBLANK(VLOOKUP(B19,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B19,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B19,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B20,'Develop PCCM'!B:I,3,FALSE)","v":0},26,"Does the permittee use the same field sampling locations identified during pre-construction monitoring and modeling?",{"$f":"IF(ISBLANK(VLOOKUP(B20,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B20,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B20,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B21,'Develop PCCM'!B:I,3,FALSE)","v":0},27,"Does the permittee address the sensitive areas identified during pre-construction monitoring and modeling?",{"$f":"IF(ISBLANK(VLOOKUP(B21,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B21,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B21,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B22,'Develop PCCM'!B:I,3,FALSE)","v":0},28,"Did the permittee address any bottlenecks in the CSS identified during pre-construction monitoring and modeling?",{"$f":"IF(ISBLANK(VLOOKUP(B22,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B22,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B22,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B23,'Develop PCCM'!B:I,3,FALSE)","v":0},30,"Has the permittee developed standard operating procedures as part of the PCCM plan?",{"$f":"IF(ISBLANK(VLOOKUP(B23,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B23,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 38",null,null,{"$f":"_xlfn.XLOOKUP(B23,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"IF(OR(A25=\"yes\",A26=\"yes\",A27=\"yes\",A28=\"yes\",A29=\"yes\",A30=\"yes\",A31=\"yes\"),\"yes\",\"no\")","v":"no"},31,"What initial, or baseline, monitoring has the permittee conducted:",null,null,null,null,{"$f":"_xlfn.XLOOKUP(B24,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B25,'Develop PCCM'!B:I,3,FALSE)","v":0},"31a","Flows/volume during CSO events?",{"$f":"IF(ISBLANK(VLOOKUP(B25,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B25,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B25,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B26,'Develop PCCM'!B:I,3,FALSE)","v":0},"31b","Frequency of CSO events?",{"$f":"IF(ISBLANK(VLOOKUP(B26,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B26,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B26,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B27,'Develop PCCM'!B:I,3,FALSE)","v":0},"31c","Duration of CSO events?",{"$f":"IF(ISBLANK(VLOOKUP(B27,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B27,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B27,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B28,'Develop PCCM'!B:I,3,FALSE)","v":0},"31d","Basic ambient water quality assessments?",{"$f":"IF(ISBLANK(VLOOKUP(B28,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B28,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B28,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B29,'Develop PCCM'!B:I,3,FALSE)","v":0},"31e","Basic stormwater quality assessments?",{"$f":"IF(ISBLANK(VLOOKUP(B29,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B29,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B29,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B30,'Develop PCCM'!B:I,3,FALSE)","v":0},"31f","Basic water quality assessments of CSOs?",{"$f":"IF(ISBLANK(VLOOKUP(B30,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B30,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B30,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B31,'Develop PCCM'!B:I,3,FALSE)","v":0},"31g","Other - provide explanation?",{"$f":"IF(ISBLANK(VLOOKUP(B31,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B31,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B31,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B32,'Develop PCCM'!B:I,3,FALSE)","v":0},32,"Does the PCCM plan include monitoring for the number of CSO events?",{"$f":"IF(ISBLANK(VLOOKUP(B32,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B32,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 27",null,null,{"$f":"_xlfn.XLOOKUP(B32,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC1"}]
[{"$f":"VLOOKUP(B33,'Develop PCCM'!B:I,3,FALSE)","v":0},33,"Does the PCCM plan include monitoring for the CSO volume discharged?",{"$f":"IF(ISBLANK(VLOOKUP(B33,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B33,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B33,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC2"}]
[{"$f":"VLOOKUP(B34,'Develop PCCM'!B:I,3,FALSE)","v":0},34,"Does the PCCM plan include monitoring for the mass of pollutants identified as potentially causing water quality impairments?",{"$f":"IF(ISBLANK(VLOOKUP(B34,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B34,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B34,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC3"}]
[{"$f":"IF(OR(A36=\"yes\",A37=\"yes\",A38=\"yes\",A39=\"yes\"),\"yes\",\"no\")","v":"no"},35,"Does the permittee use the same methods used for pre-construction characterization of the CSS in the PCCM plan for:",null,null,null,null,{"$f":"_xlfn.XLOOKUP(B35,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B36,'Develop PCCM'!B:I,3,FALSE)","v":0},"35a","Monitoring locations?",{"$f":"IF(ISBLANK(VLOOKUP(B36,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B36,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 28",null,null,{"$f":"_xlfn.XLOOKUP(B36,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B37,'Develop PCCM'!B:I,3,FALSE)","v":0},"35b","Parameters monitored?",{"$f":"IF(ISBLANK(VLOOKUP(B37,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B37,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 28",null,null,{"$f":"_xlfn.XLOOKUP(B37,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B38,'Develop PCCM'!B:I,3,FALSE)","v":0},"35c","Frequency of monitoring?",{"$f":"IF(ISBLANK(VLOOKUP(B38,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B38,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 28",null,null,{"$f":"_xlfn.XLOOKUP(B38,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B39,'Develop PCCM'!B:I,3,FALSE)","v":0},"35d","Frequency of dry vs wet weather monitoring?",{"$f":"IF(ISBLANK(VLOOKUP(B39,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B39,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 28",null,null,{"$f":"_xlfn.XLOOKUP(B39,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B40,'Develop PCCM'!B:I,3,FALSE)","v":0},36,"Does the permittee analyze the same parameters that were identified as causing water quality impacts during the receiving water characterization phase of the LTCP?",{"$f":"IF(ISBLANK(VLOOKUP(B40,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B40,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 29",null,null,{"$f":"_xlfn.XLOOKUP(B40,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B41,'Develop PCCM'!B:I,3,FALSE)","v":0},37,"Is the PCCM plan based on typical year or pre-construction baseline data?",{"$f":"IF(ISBLANK(VLOOKUP(B41,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B41,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 29",null,null,{"$f":"_xlfn.XLOOKUP(B41,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B42,'Develop PCCM'!B:I,3,FALSE)","v":0},38,"Does the permittee determine data quality objectives and criteria that describe quality specifications regarding the level of the decision or study question and the level of the measurements to support the decision or study question?",{"$f":"IF(ISBLANK(VLOOKUP(B42,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B42,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 30",null,22,{"$f":"_xlfn.XLOOKUP(B42,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentytwo=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"VLOOKUP(B43,'Develop PCCM'!B:I,3,FALSE)","v":0},39,"Does the permittee minimize type I and type II decision errors (false positives and negatives)?",{"$f":"IF(ISBLANK(VLOOKUP(B43,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B43,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 30",null,22,{"$f":"_xlfn.XLOOKUP(B43,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentytwo=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"VLOOKUP(B44,'Develop PCCM'!B:I,3,FALSE)","v":0},40,"Does the permittee describe the types of environmental data that will be collected and the name(s) of the organizations responsible for their collection?",{"$f":"IF(ISBLANK(VLOOKUP(B44,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B44,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 31",null,22,{"$f":"_xlfn.XLOOKUP(B44,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentytwo=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"VLOOKUP(B45,'Develop PCCM'!B:I,3,FALSE)","v":0},41,"Does the CSO control assessment plan include a discussion of the basic approach (i.e., Presumption Approach or Demonstration Approach) selected by the permittee in the LTCP to verify the effectiveness of CSO controls?",{"$f":"IF(ISBLANK(VLOOKUP(B45,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B45,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 31",null,23,{"$f":"_xlfn.XLOOKUP(B45,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentythree=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"VLOOKUP(B46,'Develop PCCM'!B:I,3,FALSE)","v":0},42,"Is the CSO control assessment plan approved by the NPDES authority?",{"$f":"IF(ISBLANK(VLOOKUP(B46,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B46,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 31",null,23,{"$f":"_xlfn.XLOOKUP(B46,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B47,'Develop PCCM'!B:I,3,FALSE)","v":0},43,"Does the permittee define system-wide and annual average conditions?",{"$f":"IF(ISBLANK(VLOOKUP(B47,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B47,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 31",null,23,{"$f":"_xlfn.XLOOKUP(B47,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P"},""]
[{"$f":"VLOOKUP(B48,'Develop PCCM'!B:I,3,FALSE)","v":0},44,"Does the permittee describe how CSOs will be evaluated through direct monitoring?",{"$f":"IF(ISBLANK(VLOOKUP(B48,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B48,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B48,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P"},""]
[{"$f":"VLOOKUP(B49,'Develop PCCM'!B:I,3,FALSE)","v":0},47,"Does the permittee discuss how monitored data will be evaluated on an average annual basis to verify whether the CSO controls are meeting the goals of the selected approach?",{"$f":"IF(ISBLANK(VLOOKUP(B49,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B49,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B49,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P"},""]
[{"$f":"VLOOKUP(B50,'Develop PCCM'!B:I,3,FALSE)","v":0},48,"Does the permittee describe how flows to the CSS (e.g., flows from satellite communities that contribute to the CSS, infiltration and inflow in separate sanitary areas that contribute flow to the CSS) will be identified?",{"$f":"IF(ISBLANK(VLOOKUP(B50,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B50,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B50,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC2"},""]
[{"$f":"VLOOKUP(B51,'Develop PCCM'!B:I,3,FALSE)","v":0},49,"If additional flows need to be identified, does the permittee describe what tools will be used to identify these flows, including additional monitoring to determine flow contributions from different parts of the system?",{"$f":"IF(ISBLANK(VLOOKUP(B51,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B51,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B51,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC2"},""]
[{"$f":"VLOOKUP(B52,'Develop PCCM'!B:I,3,FALSE)","v":0},50,"Does the permittee describe the location(s) at which flow will be measured and the flow monitoring equipment?",{"$f":"IF(ISBLANK(VLOOKUP(B52,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B52,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B52,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC2"},""]
[{"$f":"VLOOKUP(B53,'Develop PCCM'!B:I,3,FALSE)","v":0},51,"Does the permittee describe how many years of data they will use for the percent capture analysis?",{"$f":"IF(ISBLANK(VLOOKUP(B53,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B53,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B53,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC2"},""]
[{"$f":"VLOOKUP(B54,'Develop PCCM'!B:I,3,FALSE)","v":0},52,"Does the permittee describe how the mass of pollutants identified as causing water quality impairment for the volumes that would be eliminated or captured for treatment under criterion iii of the presumption approach will be eliminated or removed?",{"$f":"IF(ISBLANK(VLOOKUP(B54,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B54,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 33",null,23,{"$f":"_xlfn.XLOOKUP(B54,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC3"},""]
[{"$f":"VLOOKUP(B55,'Develop PCCM'!B:I,3,FALSE)","v":0},53,"Does the permittee describe how average pollutant loads will be calculated (using a mass balance approach) to evaluate the elimination or removal of pollutants?",{"$f":"IF(ISBLANK(VLOOKUP(B55,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B55,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 33",null,23,{"$f":"_xlfn.XLOOKUP(B55,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC3"},""]
[{"$f":"VLOOKUP(B56,'Develop PCCM'!B:I,3,FALSE)","v":0},54,"If average pollutant loads have not been previously determined, does the permittee describe what information will be used to assign them, such as historical data from the CSS, treatment plant optimization studies, and facility plans and designs?",{"$f":"IF(ISBLANK(VLOOKUP(B56,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B56,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 33",null,23,{"$f":"_xlfn.XLOOKUP(B56,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC3"},""]
[{"$f":"VLOOKUP(B57,'Develop PCCM'!B:I,3,FALSE)","v":0},57,"Is the field sampling plan approved by the NPDES authority?",{"$f":"IF(ISBLANK(VLOOKUP(B57,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B57,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,24,{"$f":"_xlfn.XLOOKUP(B57,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentyfour=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"VLOOKUP(B58,'Develop PCCM'!B:I,3,FALSE)","v":0},58,"Does the field sampling plan address assessment of the CSO controls and both effluent and ambient monitoring?",{"$f":"IF(ISBLANK(VLOOKUP(B58,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B58,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,24,{"$f":"_xlfn.XLOOKUP(B58,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B59,'Develop PCCM'!B:I,3,FALSE)","v":0},59,"Is ambient  monitoring done at CSO outfalls and outside the area of CSO impact, including areas upstream of CSOs?",{"$f":"IF(ISBLANK(VLOOKUP(B59,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B59,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,24,{"$f":"_xlfn.XLOOKUP(B59,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B60,'Develop PCCM'!B:I,3,FALSE)","v":0},60,"Does the field sampling plan provide detailed monitoring protocols and associated schedules (including the duration of different monitoring activities)?",{"$f":"IF(ISBLANK(VLOOKUP(B60,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B60,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,24,{"$f":"_xlfn.XLOOKUP(B60,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B61,'Develop PCCM'!B:I,3,FALSE)","v":0},61,"Do the monitoring protocols include the necessary effluent and ambient monitoring, and, where appropriate, biological assessments, whole effluent toxicity testing, and sediment sampling?",{"$f":"IF(ISBLANK(VLOOKUP(B61,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B61,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,24,{"$f":"_xlfn.XLOOKUP(B61,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B62,'Develop PCCM'!B:I,3,FALSE)","v":0},62,"Does the PCCM plan identify the types of pollutants and parameters to be analyzed for effluent and ambient monitoring?",{"$f":"IF(ISBLANK(VLOOKUP(B62,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B62,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B62,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"IF(OR(A64=\"yes\",A65=\"yes\",A66=\"yes\",A67=\"yes\",A68=\"yes\",A69=\"yes\",A70=\"yes\",A71=\"yes\",A72=\"yes\",A73=\"yes\",A74=\"yes\"),\"yes\",\"no\")","v":"no"},63,"Does the field sampling plan address the following major elements:",null,null,null,24,{"$f":"_xlfn.XLOOKUP(B63,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B64,'Develop PCCM'!B:I,3,FALSE)","v":0},"63a","Duration of monitoring program?",{"$f":"IF(ISBLANK(VLOOKUP(B64,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B64,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B64,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B65,'Develop PCCM'!B:I,3,FALSE)","v":0},"63b","Monitoring locations?",{"$f":"IF(ISBLANK(VLOOKUP(B65,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B65,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B65,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B66,'Develop PCCM'!B:I,3,FALSE)","v":0},"63c","Frequency of sampling and number of wet-weather events to be sampled?",{"$f":"IF(ISBLANK(VLOOKUP(B66,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B66,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B66,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B67,'Develop PCCM'!B:I,3,FALSE)","v":0},"63d","Criteria for when samples will be collected (e.g., criteria for both wet weather events and ambient conditions, i.e., x days/hours from the previous precipitation events, greater than x days between events, rainfall events greater than 0.4 inch to be sampled)?",{"$f":"IF(ISBLANK(VLOOKUP(B67,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B67,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B67,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B68,'Develop PCCM'!B:I,3,FALSE)","v":0},"63e","Strategy for determining when to initiate wet-weather monitoring?",{"$f":"IF(ISBLANK(VLOOKUP(B68,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B68,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B68,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B69,'Develop PCCM'!B:I,3,FALSE)","v":0},"63f","Sampling protocols (e.g., sample types, sample containers, preservation methods)?",{"$f":"IF(ISBLANK(VLOOKUP(B69,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B69,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B69,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B70,'Develop PCCM'!B:I,3,FALSE)","v":0},"63g","Flow measurement protocols?",{"$f":"IF(ISBLANK(VLOOKUP(B70,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B70,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B70,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B71,'Develop PCCM'!B:I,3,FALSE)","v":0},"63h","Pollutants or parameters to be analyzed or measured?",{"$f":"IF(ISBLANK(VLOOKUP(B71,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B71,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B71,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B72,'Develop PCCM'!B:I,3,FALSE)","v":0},"63i","Sampling and safety equipment and personnel?",{"$f":"IF(ISBLANK(VLOOKUP(B72,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B72,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B72,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B73,'Develop PCCM'!B:I,3,FALSE)","v":0},"63j","Quality assurance/quality control procedures for sampling and analysis?",{"$f":"IF(ISBLANK(VLOOKUP(B73,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B73,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B73,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B74,'Develop PCCM'!B:I,3,FALSE)","v":0},"63k","Procedures for validating, tracking and reporting sampling results?",{"$f":"IF(ISBLANK(VLOOKUP(B74,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B74,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B74,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B75,'Develop PCCM'!B:I,3,FALSE)","v":0},64,"Are all applicable standard operating procedures included as attachments to the quality assurance project plan or PCCM plan?",{"$f":"IF(ISBLANK(VLOOKUP(B75,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B75,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 38",null,22,{"$f":"_xlfn.XLOOKUP(B75,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentytwo=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"IF(ISBLANK('Develop PCCM'!C82),\"No\",\"Yes\")","v":"No"},null,"Additional Considerations - Developing a PCCM Plan",null,null,null,null,{"$f":"_xlfn.XLOOKUP(B76,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"all"}]
[{"$f":"IF(ISBLANK('Develop PCCM'!C82),\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(ISBLANK('Develop PCCM'!C82),\"\",'Develop PCCM'!C82)","v":""},null,null,null,null,{"$f":"_xlfn.XLOOKUP(B77,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"all"}]
["Yes",null,"PCCM Implementation",null,null,null,null,{"$f":"_xlfn.XLOOKUP(B78,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"all"}]
[{"$f":"VLOOKUP(B79,PCCM!B:I,3,FALSE)","v":0},67,"Are the overflow data presented so that they can be evaluated on an average annual basis?",{"$f":"IF(ISBLANK(VLOOKUP(B79,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B79,PCCM!B:I,4,FALSE))","v":""},"i\nPage 43",null,null,{"$f":"_xlfn.XLOOKUP(B79,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B80,PCCM!B:I,3,FALSE)","v":0},68,"Does the permittee provide data on the number of overflows from the CSS that meet the overflow definition provided in the CSO Control Policy?",{"$f":"IF(ISBLANK(VLOOKUP(B80,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B80,PCCM!B:I,4,FALSE))","v":""},"i\nPage 43",null,null,{"$f":"_xlfn.XLOOKUP(B80,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"IF(OR(A82=\"yes\",A83=\"yes\",A84=\"yes\",A85=\"yes\",A86=\"yes\",A87=\"yes\"),\"yes\",\"no\")","v":"no"},69,"Has the permittee developed a plan that summarizes:",null,null,null,null,{"$f":"_xlfn.XLOOKUP(B81,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B82,PCCM!B:I,3,FALSE)","v":0},"69a","What method or combination of methods they will use to determine if CSO discharges have occurred in the CSS?",{"$f":"IF(ISBLANK(VLOOKUP(B82,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B82,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B82,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B83,PCCM!B:I,3,FALSE)","v":0},"69b","Which CSOs they will monitor within the system?",{"$f":"IF(ISBLANK(VLOOKUP(B83,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B83,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B83,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B84,PCCM!B:I,3,FALSE)","v":0},"69c","When and how often they will monitor them?",{"$f":"IF(ISBLANK(VLOOKUP(B84,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B84,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B84,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B85,PCCM!B:I,3,FALSE)","v":0},"69d","What type of data they will collect from an event?",{"$f":"IF(ISBLANK(VLOOKUP(B85,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B85,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B85,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B86,PCCM!B:I,3,FALSE)","v":0},"69e","How that data should be used to determine if a CSO event has occurred?",{"$f":"IF(ISBLANK(VLOOKUP(B86,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B86,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B86,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B87,PCCM!B:I,3,FALSE)","v":0},"69f","How their data are representative of all the CSOs in the system?",{"$f":"IF(ISBLANK(VLOOKUP(B87,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B87,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B87,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B88,PCCM!B:I,3,FALSE)","v":0},73,"Does the permittee ensure that the flow values used to evaluate compliance with CSO volume control targets include contributions of the various parts of the collection system and that the remaining CSO volumes are calculated accurately?",{"$f":"IF(ISBLANK(VLOOKUP(B88,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B88,PCCM!B:I,4,FALSE))","v":""},"i\nPage 49",null,null,{"$f":"_xlfn.XLOOKUP(B88,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC2"}]
[{"$f":"VLOOKUP(B89,PCCM!B:I,3,FALSE)","v":0},74,"Does the permittee provide supporting data and calculations for the volume of combined sewage in the CSS during precipitation events?",{"$f":"IF(ISBLANK(VLOOKUP(B89,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B89,PCCM!B:I,4,FALSE))","v":""},"i\nPage 49",null,null,{"$f":"_xlfn.XLOOKUP(B89,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC2,PC3"}]
[{"$f":"VLOOKUP(B90,PCCM!B:I,3,FALSE)","v":0},76,"Does the determination of combined sewage \"during precipitation events\" include the time frame of the precipitation event that is producing runoff, plus some additional time period for the CSS to drain?",{"$f":"IF(ISBLANK(VLOOKUP(B90,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B90,PCCM!B:I,4,FALSE))","v":""},"i\nPage 51",null,null,{"$f":"_xlfn.XLOOKUP(B90,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC2,PC3"}]
[{"$f":"VLOOKUP(B91,PCCM!B:I,3,FALSE)","v":0},77,"Does the permittee present several years' worth of data on percent capture to allow an evaluation of compliance with criterion ii of the presumption approach?",{"$f":"IF(ISBLANK(VLOOKUP(B91,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B91,PCCM!B:I,4,FALSE))","v":""},"i\nPage 56",null,null,{"$f":"_xlfn.XLOOKUP(B91,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC2"}]
[{"$f":"VLOOKUP(B92,PCCM!B:I,3,FALSE)","v":0},78,"Does the permittee include monitoring to collect data for performance or treatment requirements for specific control technologies?",{"$f":"IF(ISBLANK(VLOOKUP(B92,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B92,PCCM!B:I,4,FALSE))","v":""},"i\nPage 60",null,null,{"$f":"_xlfn.XLOOKUP(B92,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"IF(OR(A94=\"yes\",A95=\"yes\",A96=\"yes\",A97=\"yes\"),\"yes\",\"no\")","v":"no"},80,"Has the permittee implemented any program to identify the following:",null,null,null,null,{"$f":"_xlfn.XLOOKUP(B93,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"S"}]
[{"$f":"VLOOKUP(B94,PCCM!B:I,3,FALSE)","v":0},"80a","Illicit discharge from the collection system?",{"$f":"IF(ISBLANK(VLOOKUP(B94,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B94,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B94,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"S"}]
[{"$f":"VLOOKUP(B95,PCCM!B:I,3,FALSE)","v":0},"80b","Basement backups?",{"$f":"IF(ISBLANK(VLOOKUP(B95,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B95,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B95,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"S"}]
[{"$f":"VLOOKUP(B96,PCCM!B:I,3,FALSE)","v":0},"80c","Discharge from former outfall locations?",{"$f":"IF(ISBLANK(VLOOKUP(B96,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B96,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B96,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"S"}]
[{"$f":"VLOOKUP(B97,PCCM!B:I,3,FALSE)","v":0},"80d","Effectiveness of the sewer separation?",{"$f":"IF(ISBLANK(VLOOKUP(B97,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B97,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B97,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"S"}]
[{"$f":"VLOOKUP(B98,PCCM!B:I,3,FALSE)","v":0},81,"Did the permittee complete the relevant components of the LTCP that might not have been addressed by the permittee's previous efforts or that represent ongoing commitments, including development of an operations and maintenance program and PCCM plan?",{"$f":"IF(ISBLANK(VLOOKUP(B98,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B98,PCCM!B:I,4,FALSE))","v":""},"i\nPage 62",null,null,{"$f":"_xlfn.XLOOKUP(B98,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"O"}]
[{"$f":"VLOOKUP(B99,PCCM!B:I,3,FALSE)","v":0},82,"Does the permittee coordinate with other state and local monitoring efforts?",{"$f":"IF(ISBLANK(VLOOKUP(B99,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B99,PCCM!B:I,4,FALSE))","v":""},"i\nPage 63",null,null,{"$f":"_xlfn.XLOOKUP(B99,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B100,PCCM!B:I,3,FALSE)","v":0},83,"Does the PCCM plan detail the monitoring protocols to be followed, including the necessary effluent and ambient monitoring and, where appropriate, other monitoring protocols such as biological assessments, whole effluent toxicity testing, and sediment sampling?",{"$f":"IF(ISBLANK(VLOOKUP(B100,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B100,PCCM!B:I,4,FALSE))","v":""},"i\nPage 63",null,null,{"$f":"_xlfn.XLOOKUP(B100,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B101,PCCM!B:I,3,FALSE)","v":0},84,"Does the permittee make sure the secondary data used from other sources are quality data?",{"$f":"IF(ISBLANK(VLOOKUP(B101,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B101,PCCM!B:I,4,FALSE))","v":""},"i\nPage 63",null,null,{"$f":"_xlfn.XLOOKUP(B101,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B102,PCCM!B:I,3,FALSE)","v":0},85,"Does the permitting authority apply the NPDES Watershed Framework, where all interested parties are involved in designing and implementing watershed goals?",{"$f":"IF(ISBLANK(VLOOKUP(B102,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B102,PCCM!B:I,4,FALSE))","v":""},"i\nPage 63",null,null,{"$f":"_xlfn.XLOOKUP(B102,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B103,PCCM!B:I,3,FALSE)","v":0},86,"Did the permittee select the pollutants to be included in the PCCM program in consultation with the NPDES authority?",{"$f":"IF(ISBLANK(VLOOKUP(B103,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B103,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B103,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"IF(OR(A105=\"yes\",A106=\"yes\",A107=\"yes\",A108=\"yes\",A109=\"yes\"),\"yes\",\"no\")","v":"no"},87,"Does the permittee monitor for:",null,null,null,null,{"$f":"_xlfn.XLOOKUP(B104,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B105,PCCM!B:I,3,FALSE)","v":0},"87a","Pollutants of concern?",{"$f":"IF(ISBLANK(VLOOKUP(B105,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B105,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B105,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B106,PCCM!B:I,3,FALSE)","v":0},"87b","Pollutants discharged to sensitive areas?",{"$f":"IF(ISBLANK(VLOOKUP(B106,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B106,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B106,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B107,PCCM!B:I,3,FALSE)","v":0},"87c","Pollutants causing impairment of receiving waterbody designated uses?",{"$f":"IF(ISBLANK(VLOOKUP(B107,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B107,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B107,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B108,PCCM!B:I,3,FALSE)","v":0},"87d","Pollutants causing exceedances of receiving water quality standards?",{"$f":"IF(ISBLANK(VLOOKUP(B108,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B108,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B108,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B109,PCCM!B:I,3,FALSE)","v":0},"87e","Pollutants discharged by industrial users in quantities that are expected to adversely affect receiving water quality?",{"$f":"IF(ISBLANK(VLOOKUP(B109,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B109,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B109,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B110,PCCM!B:I,3,FALSE)","v":0},88,"Does the permittee, in consultation with the NPDES authority, determine what EPA, state, and local water quality criteria or standards are applicable to the specific designated use(s) of the receiving water are available for these pollutants?",{"$f":"IF(ISBLANK(VLOOKUP(B110,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B110,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66","i",null,{"$f":"_xlfn.XLOOKUP(B110,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B111,PCCM!B:I,3,FALSE)","v":0},89,"Does the permittee consult with the NPDES authority to determine whether CSOs are discharging into sensitive areas when determining the specific designated use(s) of the receiving water?",{"$f":"IF(ISBLANK(VLOOKUP(B111,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B111,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B111,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B112,PCCM!B:I,3,FALSE)","v":0},90,"Did the permittee discuss with the NPDES authority the sampling protocols and analytical methods acceptable for analysis of pollutants in receiving water?",{"$f":"IF(ISBLANK(VLOOKUP(B112,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B112,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B112,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B113,PCCM!B:I,3,FALSE)","v":0},91,"Does the permittee's field sampling plan follow the sampling and analytical procedures in Title 40 of the CFR Part 136 (Appendix E), including the use of appropriate sample containers, sample preservation methods, maximum allowable holding times, described in Table II of Part 136.3, and analytical methods approved for NPDES compliance monitoring detailed in Tables IA - IH of Part 136.3?",{"$f":"IF(ISBLANK(VLOOKUP(B113,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B113,PCCM!B:I,4,FALSE))","v":""},"i\nPage 67",null,null,{"$f":"_xlfn.XLOOKUP(B113,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B114,PCCM!B:I,3,FALSE)","v":0},92,"Does the permittee, in consultation with the NPDES authority, determine whether any additional parameters or field monitoring should be selected for PCCM?",{"$f":"IF(ISBLANK(VLOOKUP(B114,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B114,PCCM!B:I,4,FALSE))","v":""},"i\nPage 71",null,null,{"$f":"_xlfn.XLOOKUP(B114,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"IF(OR(A116=\"yes\",A117=\"yes\",A118=\"yes\",A119=\"yes\",A120=\"yes\",A121=\"yes\",A122=\"yes\",#REF!=\"yes\",A123=\"yes\",A124=\"yes\"),\"yes\",\"no\")","v":{"$error":"#REF!"}},93,"Does the permittee consider the following receiving water characteristics when choosing sampling locations?",null,null,null,null,{"$f":"_xlfn.XLOOKUP(B115,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B116,PCCM!B:I,3,FALSE)","v":0},"93a","Locations of sensitive areas?",{"$f":"IF(ISBLANK(VLOOKUP(B116,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B116,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B116,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B117,PCCM!B:I,3,FALSE)","v":0},"93b","Upstream and downstream of CSO outfalls?",{"$f":"IF(ISBLANK(VLOOKUP(B117,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B117,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B117,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B118,PCCM!B:I,3,FALSE)","v":0},"93c","Location and impacts of other sources of pollutant loadings; when possible, does the permittee select monitoring locations that have limited or known effects from other pollutant sources?",{"$f":"IF(ISBLANK(VLOOKUP(B118,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B118,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B118,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B119,PCCM!B:I,3,FALSE)","v":0},"93d","Location of historical monitoring locations used to initially characterize CSO impacts?",{"$f":"IF(ISBLANK(VLOOKUP(B119,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B119,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B119,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B120,PCCM!B:I,3,FALSE)","v":0},"93e","Size of the waterbody?",{"$f":"IF(ISBLANK(VLOOKUP(B120,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B120,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B120,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B121,PCCM!B:I,3,FALSE)","v":0},"93f","Horizontal and vertical variability in the waterbody?",{"$f":"IF(ISBLANK(VLOOKUP(B121,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B121,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B121,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B122,PCCM!B:I,3,FALSE)","v":0},"93g","Degree of resolution necessary to assess attainment of water quality standards?",{"$f":"IF(ISBLANK(VLOOKUP(B122,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B122,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B122,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B123,PCCM!B:I,3,FALSE)","v":0},"93i","Physical logistics (accessibility, whether water is navigable, if bridges are available from which to sample)?",{"$f":"IF(ISBLANK(VLOOKUP(B123,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B123,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B123,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B124,PCCM!B:I,3,FALSE)","v":0},"93j","Crew safety?",{"$f":"IF(ISBLANK(VLOOKUP(B124,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B124,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B124,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B125,PCCM!B:I,3,FALSE)","v":0},94,"Are samples obtained at mid-depth (avoiding collection of sediment from the bottom and any scum at the top) at the midpoint of the waterbody to obtain a sample from a well-mixed portion of the river or stream?",{"$f":"IF(ISBLANK(VLOOKUP(B125,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B125,PCCM!B:I,4,FALSE))","v":""},"i\nPage 74",null,null,{"$f":"_xlfn.XLOOKUP(B125,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B126,PCCM!B:I,3,FALSE)","v":0},95,"Does the permittee choose sampling locations that represent the worst-case scenario (areas that receive overflows most frequently or have the largest pollutant loading or flow volume, sensitive areas) if only a few locations can be monitored?",{"$f":"IF(ISBLANK(VLOOKUP(B126,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B126,PCCM!B:I,4,FALSE))","v":""},"i\nPage 75",null,null,{"$f":"_xlfn.XLOOKUP(B126,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B127,PCCM!B:I,3,FALSE)","v":0},96,"Does the permittee coordinate CSO receiving water monitoring for primary and secondary contact recreation areas with existing water quality monitoring performed under the BEACH Act?",{"$f":"IF(ISBLANK(VLOOKUP(B127,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B127,PCCM!B:I,4,FALSE))","v":""},"i\nPage 75",null,null,{"$f":"_xlfn.XLOOKUP(B127,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B128,PCCM!B:I,3,FALSE)","v":0},97,"Are CSO discharges to waters designated for public water supply evaluated adjacent to intakes to ensure that any potential pollutants posing human health risk do not exceed treatment capacity of the distribution system?",{"$f":"IF(ISBLANK(VLOOKUP(B128,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B128,PCCM!B:I,4,FALSE))","v":""},"i\nPage 76",null,null,{"$f":"_xlfn.XLOOKUP(B128,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B129,PCCM!B:I,3,FALSE)","v":0},98,"Is rainfall measured using rain gauges throughout the CSS drainage area to evaluate local rainfall conditions and the impact of CSOs on receiving water?",{"$f":"IF(ISBLANK(VLOOKUP(B129,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B129,PCCM!B:I,4,FALSE))","v":""},"i\nPage 76",null,null,{"$f":"_xlfn.XLOOKUP(B129,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B130,PCCM!B:I,3,FALSE)","v":0},99,"Does the PCCM plan provide locations of stream gauge stations?",{"$f":"IF(ISBLANK(VLOOKUP(B130,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B130,PCCM!B:I,4,FALSE))","v":""},"i\nPage 77",null,null,{"$f":"_xlfn.XLOOKUP(B130,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B131,PCCM!B:I,3,FALSE)","v":0},100,"Does the permitting community ensure that most receiving water monitoring is performed during those seasons, flow regimes, and other critical conditions during which it is expected that CSOs would have the greatest potential for effects?",{"$f":"IF(ISBLANK(VLOOKUP(B131,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B131,PCCM!B:I,4,FALSE))","v":""},"i\nPage 78",null,null,{"$f":"_xlfn.XLOOKUP(B131,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B132,PCCM!B:I,3,FALSE)","v":0},101,"Does the permittee collect samples during dry-weather events, wet-weather events during which a CSO is not expected to occur, and wet-weather events during which a CSO is expected to occur?",{"$f":"IF(ISBLANK(VLOOKUP(B132,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B132,PCCM!B:I,4,FALSE))","v":""},"i\nPage 79",null,null,{"$f":"_xlfn.XLOOKUP(B132,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B133,PCCM!B:I,3,FALSE)","v":0},102,"Does the permittee monitor storms of varying intensity with a variety of pre-storm conditions (e.g., varying number of days since the last storm, varying intensity of the previous storms) and preceding dry days to represent a range of conditions experienced by the CSS?",{"$f":"IF(ISBLANK(VLOOKUP(B133,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B133,PCCM!B:I,4,FALSE))","v":""},"i\nPage 79",null,null,{"$f":"_xlfn.XLOOKUP(B133,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B134,PCCM!B:I,3,FALSE)","v":0},103,"Did the permittee verify the proper operation and regular maintenance programs for the sewer system and CSOs?",{"$f":"IF(ISBLANK(VLOOKUP(B134,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B134,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B134,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B135,PCCM!B:I,3,FALSE)","v":0},104,"Did the permittee verify they maximize use of the collection system for storage?",{"$f":"IF(ISBLANK(VLOOKUP(B135,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B135,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B135,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B136,PCCM!B:I,3,FALSE)","v":0},105,"Did the permittee verify the pretreatment requirements to assure CSO impacts are minimized?",{"$f":"IF(ISBLANK(VLOOKUP(B136,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B136,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B136,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B137,PCCM!B:I,3,FALSE)","v":0},106,"Did the permittee verify they maximize the flow to the POTW treatment plant?",{"$f":"IF(ISBLANK(VLOOKUP(B137,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B137,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B137,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B138,PCCM!B:I,3,FALSE)","v":0},107,"Did the permittee verify the prohibition of CSOs during dry weather?",{"$f":"IF(ISBLANK(VLOOKUP(B138,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B138,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B138,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B139,PCCM!B:I,3,FALSE)","v":0},108,"Did the permittee verify the monitoring program effectively characterizes the CSO impacts and the efficacy of CSO controls?",{"$f":"IF(ISBLANK(VLOOKUP(B139,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B139,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B139,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B140,PCCM!B:I,3,FALSE)","v":0},109,"Is the permittee achieving the expected runoff control volume using green infrastructure?",{"$f":"IF(ISBLANK(VLOOKUP(B140,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B140,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B140,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B141,PCCM!B:I,3,FALSE)","v":0},110,"Is the permittee achieving the expected volume of retention controls using green infrastructure?",{"$f":"IF(ISBLANK(VLOOKUP(B141,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B141,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B141,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B142,PCCM!B:I,3,FALSE)","v":0},111,"Did the permittee verify no more than an average of four to six overflow events per year system-wide?",{"$f":"IF(ISBLANK(VLOOKUP(B142,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B142,PCCM!B:I,4,FALSE))","v":""},"i\nPage 6",null,null,{"$f":"_xlfn.XLOOKUP(B142,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B143,PCCM!B:I,3,FALSE)","v":0},112,"Did the permittee verify the elimination or capture for treatment of no less than 85% by volume of the combined sewage collected in the CSS during precipitation events on a system-wide annual average basis?",{"$f":"IF(ISBLANK(VLOOKUP(B143,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B143,PCCM!B:I,4,FALSE))","v":""},"i\nPage 6",null,null,{"$f":"_xlfn.XLOOKUP(B143,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC2"}]
[{"$f":"VLOOKUP(B144,PCCM!B:I,3,FALSE)","v":0},113,"Did the permittee verify the elimination or removal of no less than the mass of the pollutants identified as causing water quality impairment through the sewer system characterization, monitoring, and modeling effort, for the volumes that would be eliminated or captured for treatment?",{"$f":"IF(ISBLANK(VLOOKUP(B144,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B144,PCCM!B:I,4,FALSE))","v":""},"i\nPage 6",null,null,{"$f":"_xlfn.XLOOKUP(B144,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC3"}]
[{"$f":"VLOOKUP(B145,PCCM!B:I,3,FALSE)","v":0},114,"Did the permittee demonstrate that the selected CSO control program can meet the water quality-based requirements of the Clean Water Act?",{"$f":"IF(ISBLANK(VLOOKUP(B145,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B145,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B145,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"D"}]
[{"$f":"VLOOKUP(B146,PCCM!B:I,3,FALSE)","v":0},115,"Did the permittee verify that the CSO Control Plan will attain water quality standards and meet the requirements of the CSO Control Policy?",{"$f":"IF(ISBLANK(VLOOKUP(B146,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B146,PCCM!B:I,4,FALSE))","v":""},"i\nPage 5",null,null,{"$f":"_xlfn.XLOOKUP(B146,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"O"}]
[{"$f":"IF(ISBLANK(PCCM!C87),\"No\",\"Yes\")","v":"No"},null,"Additional Considerations - PCCM Implementation"]
[{"$f":"IF(ISBLANK(PCCM!C87),\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(ISBLANK(PCCM!C87),\"\",PCCM!C87)","v":""}]
["Botton: Go to the previous page."]
["Botton: Go to the next page."]

{"sheet":"Recs","index":5,"n_rows":142,"n_cols":9,"rows_kept":142,"cut":false,"hidden":false,"merged":[[1,2,1,6],[11,4,11,5],[12,2,12,5],[139,2,139,5],[140,2,140,5],[73,2,73,5],[72,2,72,5],[74,2,74,5]]}
["4. Recommendations. This page includes a summary of all items that are missing or could be improved within the LTCP. Use the tab key to move through the page and the enter key to go to other pages when that page's button is selected. When prompted, press enter to see the recommendations. This action will filter the full list of questions down to only those for which the reviewer answered \"no\"."]
[null,null,"Post-Construction Compliance Monitoring (PCCM) Checklist"]
["Button: Go to the Getting Started page"]
["Button: Go to the 1. Developing a PCCM Plan page"]
["Button: Go to the 2. PCCM Implementation page"]
["Button: Go to the 3. Addressed Items page"]
[]
["Button: Press enter to see Recommendations"]
[]
[]
[]
["addressed?",null,"List of recommendations to improve PCCM. The recommendations are generated based on questions responded to with a \"No.\"","Additional notes provided here.","Helpful Resources",null,"dependency","scenario filter","question filter"]
["No",null,"Developing a PCCM Plan"]
[{"$f":"VLOOKUP(B14,'Develop PCCM'!B:H,3,FALSE)","v":0},21,"Monitor receiving water(s) to assess impacts under different CSO loads and conditions, discern background conditions and other sources, and demonstrate water quality standards attainment or the need for a total maximum daily load or use attainability analysis.",{"$f":"IF(ISBLANK(VLOOKUP(B14,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B14,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nChapter 8",null,null,{"$f":"_xlfn.XLOOKUP(B14,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B15,'Develop PCCM'!B:H,3,FALSE)","v":0},22,"Use EPA's Quality Assurance Project Plan guidance and all applicable state or local guidance to develop a Quality Assurance Project Plan for PCCM. ",{"$f":"IF(ISBLANK(VLOOKUP(B15,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B15,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 29",null,null,{"$f":"_xlfn.XLOOKUP(B15,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B16,'Develop PCCM'!B:H,3,FALSE)","v":0},23,"Develop a CSO control assessment plan that includes a discussion of the basic approach selected by the permittee in the LTCP to verify the effectiveness of CSO controls. In addition, the CSO control assessment plan should be submitted to the NPDES authority for review and approval before implementation.",{"$f":"IF(ISBLANK(VLOOKUP(B16,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B16,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 31",null,null,{"$f":"_xlfn.XLOOKUP(B16,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B17,'Develop PCCM'!B:H,3,FALSE)","v":0},24,"Develop a field sampling plan that documents duration of monitoring program, monitoring locations, frequency of sampling, number of event samples, parameters analyzed, sampling protocols, equipment used, and analytical methods.",{"$f":"IF(ISBLANK(VLOOKUP(B17,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B17,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,null,{"$f":"_xlfn.XLOOKUP(B17,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B18,'Develop PCCM'!B:H,3,FALSE)","v":0},"24b","Consider developing a pre-construction sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B18,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B18,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B18,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B19,'Develop PCCM'!B:H,3,FALSE)","v":0},25,"Consider developing the PCCM sampling plan based on the pre-construction sampling plan. ",{"$f":"IF(ISBLANK(VLOOKUP(B19,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B19,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,12,{"$f":"_xlfn.XLOOKUP(B19,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B20,'Develop PCCM'!B:H,3,FALSE)","v":0},26,"Use the same field sampling locations identified during pre-construction monitoring and modeling.",{"$f":"IF(ISBLANK(VLOOKUP(B20,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B20,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,13,{"$f":"_xlfn.XLOOKUP(B20,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B21,'Develop PCCM'!B:H,3,FALSE)","v":0},27,"Address sensitive areas identified during pre-construction monitoring and modeling.",{"$f":"IF(ISBLANK(VLOOKUP(B21,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B21,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,"15h",{"$f":"_xlfn.XLOOKUP(B21,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B22,'Develop PCCM'!B:H,3,FALSE)","v":0},28,"Address any bottlenecks in the CSS identified during pre-construction monitoring an modeling.",{"$f":"IF(ISBLANK(VLOOKUP(B22,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B22,'Develop PCCM'!B:H,4,FALSE))","v":""},null,null,"15f",{"$f":"_xlfn.XLOOKUP(B22,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B23,'Develop PCCM'!B:H,3,FALSE)","v":0},30,"Prepare standard operating procedures for field, laboratory, and database management activities that need to be performed in the same way every time. The permittee should prepare standard operating procedures for activities such as calibration, use, and maintenance of a flow meter; collecting grab samples from surface waters; collecting field blanks; and measuring turbidity. For detailed information on developing standard operating procedures, the permittee should see EPA's Guidance for Preparing Standard Operating Procedures. ",{"$f":"IF(ISBLANK(VLOOKUP(B23,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B23,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 38",null,null,{"$f":"_xlfn.XLOOKUP(B23,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B24,'Develop PCCM'!B:H,3,FALSE)","v":0},"31a","Depending on a variety of factors including the LTCP approach, permit requirements, and waterbody designated use, the permittee should have monitored for CSO flow/volume. Identify what has been done and ensure monitoring adequately characterizes the impact of CSOs discharged.",{"$f":"IF(ISBLANK(VLOOKUP(B24,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B24,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B24,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B25,'Develop PCCM'!B:H,3,FALSE)","v":0},"31b","Depending on a variety of factors including the LTCP approach, permit requirements, and waterbody designated use, the permittee should have monitored for CSO frequency. Identify what has been done and ensure monitoring adequately characterizes the impact of CSOs discharged.",{"$f":"IF(ISBLANK(VLOOKUP(B25,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B25,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B25,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B26,'Develop PCCM'!B:H,3,FALSE)","v":0},"31c","Depending on a variety of factors including the LTCP approach, permit requirements, and waterbody designated use, the permittee should have monitored for CSO duration. Identify what has been done and ensure monitoring adequately characterizes the impact of CSOs discharged.",{"$f":"IF(ISBLANK(VLOOKUP(B26,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B26,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B26,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B27,'Develop PCCM'!B:H,3,FALSE)","v":0},"31d","Depending on a variety of factors including the LTCP approach, permit requirements, and waterbody designated use, the permittee should have performed basic assessments of ambient water quality. Conduct basic ambient water quality assessments and check sources of existing information including USGS streamflow and water quality data, applicable state water quality standards, EPA STORET and BASINS Programs, State 305(b) Water Quality Assessment Reports, State 303(d) lists of impaired waters, and other local water quality assessments. Identify what has been done and ensure monitoring adequately characterizes the impact of CSOs discharged.",{"$f":"IF(ISBLANK(VLOOKUP(B27,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B27,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B27,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B28,'Develop PCCM'!B:H,3,FALSE)","v":0},"31e","Depending on a variety of factors including the LTCP approach, permit requirements, and waterbody designated use, the permittee should have performed basic assessments of stormwater. Identify what has been done and ensure monitoring adequately characterizes the impact of CSOs discharged.",{"$f":"IF(ISBLANK(VLOOKUP(B28,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B28,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B28,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B29,'Develop PCCM'!B:H,3,FALSE)","v":0},"31f","Depending on a variety of factors including the LTCP approach, permit requirements, and waterbody designated use, the permittee should have performed basic assessments of CSO discharges. Identify what has been done and ensure monitoring adequately characterizes the impact of CSOs discharged.",{"$f":"IF(ISBLANK(VLOOKUP(B29,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B29,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B29,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B30,'Develop PCCM'!B:H,3,FALSE)","v":0},"31g","Other - see additional notes for explanation.",{"$f":"IF(ISBLANK(VLOOKUP(B30,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B30,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 26","i",null,{"$f":"_xlfn.XLOOKUP(B30,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B31,'Develop PCCM'!B:H,3,FALSE)","v":0},32,"Include monitoring for metrics based on the LTCP approach in the PCCM plan.",{"$f":"IF(ISBLANK(VLOOKUP(B31,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B31,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 27",null,null,{"$f":"_xlfn.XLOOKUP(B31,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC1"}]
[{"$f":"VLOOKUP(B32,'Develop PCCM'!B:H,3,FALSE)","v":0},33,"Include monitoring for metrics based on the LTCP approach in the PCCM plan.",{"$f":"IF(ISBLANK(VLOOKUP(B32,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B32,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 27",null,null,{"$f":"_xlfn.XLOOKUP(B32,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC2"}]
[{"$f":"VLOOKUP(B33,'Develop PCCM'!B:H,3,FALSE)","v":0},34,"Include monitoring for metrics based on the LTCP approach in the PCCM plan.",{"$f":"IF(ISBLANK(VLOOKUP(B33,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B33,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 27",null,null,{"$f":"_xlfn.XLOOKUP(B33,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC3"}]
[{"$f":"VLOOKUP(B34,'Develop PCCM'!B:H,3,FALSE)","v":0},"35a","Use the same monitoring locations used for pre-construction characterization of the CSS in the PCCM plan.",{"$f":"IF(ISBLANK(VLOOKUP(B34,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B34,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 28",null,null,{"$f":"_xlfn.XLOOKUP(B34,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B35,'Develop PCCM'!B:H,3,FALSE)","v":0},"35b","Use the same parameters monitored used for pre-construction characterization of the CSS in the PCCM plan.",{"$f":"IF(ISBLANK(VLOOKUP(B35,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B35,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 28",null,null,{"$f":"_xlfn.XLOOKUP(B35,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B36,'Develop PCCM'!B:H,3,FALSE)","v":0},"35c","Use the same frequency of monitoring used for pre-construction characterization of the CSS in the PCCM plan.",{"$f":"IF(ISBLANK(VLOOKUP(B36,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B36,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 28",null,null,{"$f":"_xlfn.XLOOKUP(B36,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B37,'Develop PCCM'!B:H,3,FALSE)","v":0},"35d","Use the same frequency of dry vs wet weather monitoring used for pre-construction characterization of the CSS in the PCCM plan.",{"$f":"IF(ISBLANK(VLOOKUP(B37,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B37,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 28",null,null,{"$f":"_xlfn.XLOOKUP(B37,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B38,'Develop PCCM'!B:H,3,FALSE)","v":0},36,"Analyze the same parameters that were identified as causing water quality impacts during the receiving water characterization phase of the LTCP.",{"$f":"IF(ISBLANK(VLOOKUP(B38,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B38,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 29",null,null,{"$f":"_xlfn.XLOOKUP(B38,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B39,'Develop PCCM'!B:H,3,FALSE)","v":0},37,"Base the PCCM plan on typical year or pre-construction baseline data.",{"$f":"IF(ISBLANK(VLOOKUP(B39,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B39,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 29",null,null,{"$f":"_xlfn.XLOOKUP(B39,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B40,'Develop PCCM'!B:H,3,FALSE)","v":0},38,"Determine data quality objectives and criteria that describe quality specifications regarding the level of the decision or study question and the level of the measurements to support the decision or study question.",{"$f":"IF(ISBLANK(VLOOKUP(B40,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B40,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 30",null,22,{"$f":"_xlfn.XLOOKUP(B40,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentytwo=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"VLOOKUP(B41,'Develop PCCM'!B:H,3,FALSE)","v":0},39,"Minimize Type I and Type II decision errors (false positives and negatives). A false positive means a problem is found to exist when it in fact does not. A false negative means a problem is not found when in fact it does exist. Sources of error or uncertainty include collecting, handling, storing, and analyzing  samples.",{"$f":"IF(ISBLANK(VLOOKUP(B41,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B41,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 30",null,22,{"$f":"_xlfn.XLOOKUP(B41,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentytwo=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"VLOOKUP(B42,'Develop PCCM'!B:H,3,FALSE)","v":0},40,"Describe the types of environmental data that will be collected and the name(s) of the organizations responsible for their collection.",{"$f":"IF(ISBLANK(VLOOKUP(B42,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B42,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 31",null,22,{"$f":"_xlfn.XLOOKUP(B42,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentytwo=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"VLOOKUP(B43,'Develop PCCM'!B:H,3,FALSE)","v":0},41,"Discuss the basic approach (i.e., Presumption Approach or Demonstration Approach) selected in the LTCP to verify the effectiveness of CSO controls.",{"$f":"IF(ISBLANK(VLOOKUP(B43,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B43,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 31",null,23,{"$f":"_xlfn.XLOOKUP(B43,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentythree=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"VLOOKUP(B44,'Develop PCCM'!B:H,3,FALSE)","v":0},42,"Submit the CSO control assessment plan to be approved by the NPDES authority.",{"$f":"IF(ISBLANK(VLOOKUP(B44,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B44,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 31",null,23,{"$f":"_xlfn.XLOOKUP(B44,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B45,'Develop PCCM'!B:H,3,FALSE)","v":0},43,"Define system-wide and annual average conditions. System-wide is defined as the baseline condition for the entire CSS. The annual average has both sewage and runoff components. The annual average sewage volume can be determined by modeling or metering records. The annual average rainfall component should include ranking annual rainfall, assessing month-to-month variations, assessing rainfall intensity, and assessing return frequency.",{"$f":"IF(ISBLANK(VLOOKUP(B45,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B45,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 31",null,23,{"$f":"_xlfn.XLOOKUP(B45,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P"},""]
[{"$f":"VLOOKUP(B46,'Develop PCCM'!B:H,3,FALSE)","v":0},44,"Describe how CSOs will be evaluated through direct monitoring.",{"$f":"IF(ISBLANK(VLOOKUP(B46,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B46,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B46,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P"},""]
[{"$f":"VLOOKUP(B47,'Develop PCCM'!B:H,3,FALSE)","v":0},47,"Discuss how monitored data will be evaluated on an average annual basis to verify whether the CSO controls are meeting the goals of the selected approach.",{"$f":"IF(ISBLANK(VLOOKUP(B47,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B47,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B47,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P"},""]
[{"$f":"VLOOKUP(B48,'Develop PCCM'!B:H,3,FALSE)","v":0},48,"Describe how flows to the CSS (e.g., flows from satellite communities that contribute to the CSS, inflow and infiltration in separate sanitary areas that contribute flow to the CSS) will be identified. Permittees should have a good idea of the various flows in their system and what they represent from the system characterization phase of the LTCP. ",{"$f":"IF(ISBLANK(VLOOKUP(B48,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B48,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B48,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC2"},""]
[{"$f":"VLOOKUP(B49,'Develop PCCM'!B:H,3,FALSE)","v":0},49,"Describe what tools will be used to identify these flows, including additional monitoring to determine flow contributions from different parts of the system.",{"$f":"IF(ISBLANK(VLOOKUP(B49,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B49,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B49,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC2"},""]
[{"$f":"VLOOKUP(B50,'Develop PCCM'!B:H,3,FALSE)","v":0},50,"Describe the location(s) at which flow will be measured and the flow monitoring equipment.",{"$f":"IF(ISBLANK(VLOOKUP(B50,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B50,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B50,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC2"},""]
[{"$f":"VLOOKUP(B51,'Develop PCCM'!B:H,3,FALSE)","v":0},51,"Describe how many years of data the permittee will use for the percent capture analysis.",{"$f":"IF(ISBLANK(VLOOKUP(B51,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B51,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 32",null,23,{"$f":"_xlfn.XLOOKUP(B51,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC2"},""]
[{"$f":"VLOOKUP(B52,'Develop PCCM'!B:H,3,FALSE)","v":0},52,"Describe how the mass of pollutants permittee criterion iii of the presumption approach will be eliminated or removed.",{"$f":"IF(ISBLANK(VLOOKUP(B52,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B52,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 33",null,23,{"$f":"_xlfn.XLOOKUP(B52,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC3"},""]
[{"$f":"VLOOKUP(B53,'Develop PCCM'!B:H,3,FALSE)","v":0},53,"Describe how average pollutant loads will be calculated (using a mass balance approach) to evaluate the elimination or removal of pollutants.",{"$f":"IF(ISBLANK(VLOOKUP(B53,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B53,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 33",null,23,{"$f":"_xlfn.XLOOKUP(B53,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC3"},""]
[{"$f":"VLOOKUP(B54,'Develop PCCM'!B:H,3,FALSE)","v":0},54,"Describe what information will be used to assign pollutant loads, such as historical data from the CSS, treatment plant optimization studies, and facility plans and designs.",{"$f":"IF(ISBLANK(VLOOKUP(B54,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B54,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 33",null,23,{"$f":"_xlfn.XLOOKUP(B54,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"PC3"},""]
[{"$f":"VLOOKUP(B55,'Develop PCCM'!B:H,3,FALSE)","v":0},57,"Submit the field sampling plan to be approved by the NPDES authority. Field sampling plans should generally be included as appendices to quality assurance project plans, as the quality assurance project plan is incomplete without sampling details.",{"$f":"IF(ISBLANK(VLOOKUP(B55,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B55,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,24,{"$f":"_xlfn.XLOOKUP(B55,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},{"$f":"IF(Twentyfour=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"VLOOKUP(B56,'Develop PCCM'!B:H,3,FALSE)","v":0},58,"Assess CSO controls and both effluent and ambient monitoring.",{"$f":"IF(ISBLANK(VLOOKUP(B56,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B56,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,24,{"$f":"_xlfn.XLOOKUP(B56,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B57,'Develop PCCM'!B:H,3,FALSE)","v":0},59,"Conduct ambient monitoring at CSO outfalls and outside the area of CSO impact, including areas upstream of CSOs in order to determine the full range of CSO impacts to the waterbody.",{"$f":"IF(ISBLANK(VLOOKUP(B57,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B57,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,24,{"$f":"_xlfn.XLOOKUP(B57,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B58,'Develop PCCM'!B:H,3,FALSE)","v":0},60,"Provide detailed monitoring protocols and associated schedules (including the duration of different monitoring activities).",{"$f":"IF(ISBLANK(VLOOKUP(B58,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B58,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,24,{"$f":"_xlfn.XLOOKUP(B58,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B59,'Develop PCCM'!B:H,3,FALSE)","v":0},61,"Include the necessary effluent and ambient monitoring, and, where appropriate, biological assessments, whole effluent toxicity testing, and sediment sampling. These types of monitoring may be appropriate depending on the WQS in the receiving water. For example, ambient toxicity testing, using samples collected up and downstream of the CSO outfall during wet weather events might be useful in smaller streams and rivers to determine compliance with narrative toxicity standards. Alternatively, direct whole effluent toxicity testing of CSO outfall samples during wet weather events can be used to evaluate compliance with the narrative toxicity standard.",{"$f":"IF(ISBLANK(VLOOKUP(B59,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B59,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 35",null,24,{"$f":"_xlfn.XLOOKUP(B59,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B60,'Develop PCCM'!B:H,3,FALSE)","v":0},62,"Identify the types of pollutants and parameters to be analyzed for effluent and ambient monitoring. Monitoring may include chemical, physical, or biological parameters. The permittee should base the decision on what parameters to monitor on site-specific factors, including the water quality criteria for the specific designated use(s) of the receiving water, pollutants key to the attainment of designated use(s), and pollutants affected by the CSO controls.",{"$f":"IF(ISBLANK(VLOOKUP(B60,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B60,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B60,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B61,'Develop PCCM'!B:H,3,FALSE)","v":0},"63a","Include monitoring duration in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B61,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B61,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B61,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B62,'Develop PCCM'!B:H,3,FALSE)","v":0},"63b","Include monitoring locations in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B62,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B62,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B62,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B63,'Develop PCCM'!B:H,3,FALSE)","v":0},"63c","Include sampling frequency in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B63,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B63,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B63,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B64,'Develop PCCM'!B:H,3,FALSE)","v":0},"63d","Include sampling criteria (e.g., criteria for both wet weather events and ambient conditions, i.e., x days/hours from the previous precipitation events, greater than x days between events, rainfall events greater than 0.4 inch to be sampled) in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B64,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B64,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B64,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B65,'Develop PCCM'!B:H,3,FALSE)","v":0},"63e","Include strategy for determining when to initiate wet-weather monitoring in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B65,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B65,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B65,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B66,'Develop PCCM'!B:H,3,FALSE)","v":0},"63f","Include sampling protocols (e.g., sample types, sample containers, preservation methods) in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B66,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B66,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B66,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B67,'Develop PCCM'!B:H,3,FALSE)","v":0},"63g","Include flow measurement protocols in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B67,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B67,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B67,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B68,'Develop PCCM'!B:H,3,FALSE)","v":0},"63h","Include pollutants or parameters to be analyzed or measured in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B68,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B68,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B68,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B69,'Develop PCCM'!B:H,3,FALSE)","v":0},"63i","Include sampling and safety equipment and personnel in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B69,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B69,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B69,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B70,'Develop PCCM'!B:H,3,FALSE)","v":0},"63j","Include quality assurance/quality control procedures for sampling and analysis in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B70,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B70,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B70,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B71,'Develop PCCM'!B:H,3,FALSE)","v":0},"63k","Include quality assurance/quality control procedures for sampling and analysis, and procedures for validating, tracking and reporting sampling results in the field sampling plan.",{"$f":"IF(ISBLANK(VLOOKUP(B71,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B71,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 36",null,24,{"$f":"_xlfn.XLOOKUP(B71,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"VLOOKUP(B72,'Develop PCCM'!B:H,3,FALSE)","v":0},64,"Include all applicable standard operating procedures as attachments to the project quality assurance project plan or PCCM plan. Standard operating procedures should be prepared for field, laboratory, and database management activities that need to be performed the same way every time. The permittee should prepare standard operating procedures for activities such as calibration, use, and maintenance of a flow meter; collecting grab samples from surface waters; collecting field blanks; and measuring turbidity. ",{"$f":"IF(ISBLANK(VLOOKUP(B72,'Develop PCCM'!B:H,4,FALSE)),\"\",VLOOKUP(B72,'Develop PCCM'!B:H,4,FALSE))","v":""},"i\nPage 38",null,22,{"$f":"_xlfn.XLOOKUP(B72,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"P, D, O"},""]
[{"$f":"IF(ISBLANK('Develop PCCM'!C82),\"Yes\",\"No\")","v":"Yes"},null,"Additional Considerations - Developing a PCCM Plan",null,null,null,null,{"$f":"_xlfn.XLOOKUP(B73,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"all"},{"$f":"IF(Twentytwo=\"No\",\"hide\",\"\")","v":""}]
[{"$f":"IF(ISBLANK('Develop PCCM'!C82),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(ISBLANK('Develop PCCM'!C82),\"\",'Develop PCCM'!C82)","v":""},null,null,null,null,{"$f":"_xlfn.XLOOKUP(B74,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"all"}]
["No",null,"PCCM Implementation",null,null,null,null,{"$f":"_xlfn.XLOOKUP(B75,'Develop PCCM'!$B$11:$B$79,'Develop PCCM'!$A$11:$A$79)","v":"all"}]
[{"$f":"VLOOKUP(B76,PCCM!B:I,3,FALSE)","v":0},67,"Present overflow data so that they can be evaluated on an average annual basis. Each permittee should discuss the appropriate time frames for evaluating the success of CSO frequency targets with their NPDES authority to ensure agreement that adequate data are collected.",{"$f":"IF(ISBLANK(VLOOKUP(B76,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B76,PCCM!B:I,4,FALSE))","v":""},"i\nPage 43",null,null,{"$f":"_xlfn.XLOOKUP(B76,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B77,PCCM!B:I,3,FALSE)","v":0},68,"Provide data on the number of overflows from the CSS that meet the overflow definition provided in the CSO Control Policy.",{"$f":"IF(ISBLANK(VLOOKUP(B77,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B77,PCCM!B:I,4,FALSE))","v":""},"i\nPage 43",null,null,{"$f":"_xlfn.XLOOKUP(B77,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B78,PCCM!B:I,3,FALSE)","v":0},"69a","Summarize what method or combination of methods the permittee will use to determine if CSO discharges have occurred in the CSS (e.g., block method, direct measurement)",{"$f":"IF(ISBLANK(VLOOKUP(B78,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B78,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B78,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B79,PCCM!B:I,3,FALSE)","v":0},"69b","Summarize which CSOs the permittee will monitor within the system (e.g., every outfall; outfalls discharging the most frequently on the basis of previous observations; outfalls in sensitive areas).",{"$f":"IF(ISBLANK(VLOOKUP(B79,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B79,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B79,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B80,PCCM!B:I,3,FALSE)","v":0},"69c","Summarize when and how the permittee will monitor CSOs (e.g., after every precipitation event delivering a measurable amount of precipitation; after every precipitation event reaching a certain threshold level of precipitation).",{"$f":"IF(ISBLANK(VLOOKUP(B80,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B80,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B80,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B81,PCCM!B:I,3,FALSE)","v":0},"69d","Summarize what type of data the permittee will collect from an event (e.g., block present or absent, meter reading).",{"$f":"IF(ISBLANK(VLOOKUP(B81,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B81,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B81,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B82,PCCM!B:I,3,FALSE)","v":0},"69e","Summarize how the data collected should be used to determine if a CSO event has occurred (e.g., CSO event has occurred if the block is absent from the weir or CSO event has occurred if the meter has registered flow).",{"$f":"IF(ISBLANK(VLOOKUP(B82,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B82,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B82,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B83,PCCM!B:I,3,FALSE)","v":0},"69f","Summarize how the data are suitably representative of all the CSOs in the system.",{"$f":"IF(ISBLANK(VLOOKUP(B83,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B83,PCCM!B:I,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"_xlfn.XLOOKUP(B83,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B84,PCCM!B:I,3,FALSE)","v":0},73,"Ensure that the flow values used to evaluate compliance with CSO volume control targets include appropriate contributions of the various parts of the CSS and that the remaining CSO volumes are calculated correctly. For example, permittees should be sure to account for flows from upstream from separated areas, plus any infiltration and inflow that can be expected during critical periods (e.g., during rainfall events).",{"$f":"IF(ISBLANK(VLOOKUP(B84,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B84,PCCM!B:I,4,FALSE))","v":""},"i\nPage 49",null,null,{"$f":"_xlfn.XLOOKUP(B84,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC2"}]
[{"$f":"VLOOKUP(B85,PCCM!B:I,3,FALSE)","v":0},74,"Provide supporting data and calculations for the volume of combined sewage in the CSS during precipitation events.",{"$f":"IF(ISBLANK(VLOOKUP(B85,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B85,PCCM!B:I,4,FALSE))","v":""},"i\nPage 49",null,null,{"$f":"_xlfn.XLOOKUP(B85,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC2,PC3"}]
[{"$f":"VLOOKUP(B86,PCCM!B:I,3,FALSE)","v":0},76,"Include the time frame of the precipitation event that is producing runoff, plus some additional time period for the CSS to drain in the determination of combined sewage \"during precipitation events.\" Options for determining the period required for the CSS to drain might include the observed time for runoff to pass through the CSS or the time until flow in the sewer returns to normal (i.e., time required until the CSS reaches approximately 110 to 120 percent of dry-weather flow).",{"$f":"IF(ISBLANK(VLOOKUP(B86,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B86,PCCM!B:I,4,FALSE))","v":""},"i\nPage 51",null,null,{"$f":"_xlfn.XLOOKUP(B86,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC2,PC3"}]
[{"$f":"VLOOKUP(B87,PCCM!B:I,3,FALSE)","v":0},77,"Present several years' worth of data on percent capture to allow an evaluation of compliance with criterion ii of the presumption approach. The permittee has calculated an annual percent capture for several years' worth of data, calculated the annual average over a several-year period for use in evaluating criterion ii of the presumption approach, and then would average these annual flow volumes to produce an annual average of flow in the CSS during precipitation events.",{"$f":"IF(ISBLANK(VLOOKUP(B87,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B87,PCCM!B:I,4,FALSE))","v":""},"i\nPage 56",null,null,{"$f":"_xlfn.XLOOKUP(B87,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC2"}]
[{"$f":"VLOOKUP(B88,PCCM!B:I,3,FALSE)","v":0},78,"Include monitoring to collect data for performance or treatment requirements for specific control technologies.",{"$f":"IF(ISBLANK(VLOOKUP(B88,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B88,PCCM!B:I,4,FALSE))","v":""},"i\nPage 60",null,null,{"$f":"_xlfn.XLOOKUP(B88,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B89,PCCM!B:I,3,FALSE)","v":0},"80a","Implement a program to identify illicit discharges from the collection system.",{"$f":"IF(ISBLANK(VLOOKUP(B89,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B89,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B89,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"S"}]
[{"$f":"VLOOKUP(B90,PCCM!B:I,3,FALSE)","v":0},"80b","Implement a program to identify basement backups.",{"$f":"IF(ISBLANK(VLOOKUP(B90,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B90,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B90,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"S"}]
[{"$f":"VLOOKUP(B91,PCCM!B:I,3,FALSE)","v":0},"80c","Implement a program to identify discharge from former outfall locations.",{"$f":"IF(ISBLANK(VLOOKUP(B91,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B91,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B91,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"S"}]
[{"$f":"VLOOKUP(B92,PCCM!B:I,3,FALSE)","v":0},"80d","Implement a program to characterize the effectiveness of the sewer separation.",{"$f":"IF(ISBLANK(VLOOKUP(B92,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B92,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B92,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"S"}]
[{"$f":"VLOOKUP(B93,PCCM!B:I,3,FALSE)","v":0},81,"Complete the relevant components of the LTCP that might not have been addressed by the permittee's previous efforts or that represent ongoing commitments, including development of an operations and maintenance program and PCCM plan.",{"$f":"IF(ISBLANK(VLOOKUP(B93,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B93,PCCM!B:I,4,FALSE))","v":""},"i\nPage 62",null,null,{"$f":"_xlfn.XLOOKUP(B93,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"O"}]
[{"$f":"VLOOKUP(B94,PCCM!B:I,3,FALSE)","v":0},82,"Coordinate with other state and local monitoring efforts.",{"$f":"IF(ISBLANK(VLOOKUP(B94,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B94,PCCM!B:I,4,FALSE))","v":""},"i\nPage 63",null,null,{"$f":"_xlfn.XLOOKUP(B94,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B95,PCCM!B:I,3,FALSE)","v":0},83,"Detail the monitoring protocols to be followed, including the necessary effluent and ambient monitoring, and, where appropriate, other monitoring protocols such as biological assessments, whole effluent toxicity testing, and sediment sampling. To support their PCCM program the permittee may collect their own data, or if available, use monitoring data from other sources (e.g. federal and/or state agencies).",{"$f":"IF(ISBLANK(VLOOKUP(B95,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B95,PCCM!B:I,4,FALSE))","v":""},"i\nPage 63",null,null,{"$f":"_xlfn.XLOOKUP(B95,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B96,PCCM!B:I,3,FALSE)","v":0},84,"Make sure the secondary data used from other sources are quality data.",{"$f":"IF(ISBLANK(VLOOKUP(B96,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B96,PCCM!B:I,4,FALSE))","v":""},"i\nPage 63",null,null,{"$f":"_xlfn.XLOOKUP(B96,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B97,PCCM!B:I,3,FALSE)","v":0},85,"Apply the NPDES Watershed Framework, where all interested parties are involved in designing and implementing watershed. It is important to note that eliminating CSO discharges will not always ensure the WQS will be met because other pollution sources (e.g., SSOs, stormwater, pollution from upstream sources, CAFOs) can affect the receiving waterbody. It is often necessary to limit all sources of pollutants to the watershed to ensure that WQS will be met.",{"$f":"IF(ISBLANK(VLOOKUP(B97,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B97,PCCM!B:I,4,FALSE))","v":""},"i\nPage 63",null,null,{"$f":"_xlfn.XLOOKUP(B97,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B98,PCCM!B:I,3,FALSE)","v":0},86,"Select the pollutants to be included in the PCCM program in consultation with the NPDES authority. The permittee should document these pollutants and the rationale for their selection in the facility's field sampling plan. ",{"$f":"IF(ISBLANK(VLOOKUP(B98,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B98,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B98,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B99,PCCM!B:I,3,FALSE)","v":0},"87a","Monitor for pollutants of concern.",{"$f":"IF(ISBLANK(VLOOKUP(B99,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B99,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B99,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B100,PCCM!B:I,3,FALSE)","v":0},"87b","Monitor for pollutants discharged to sensitive areas.",{"$f":"IF(ISBLANK(VLOOKUP(B100,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B100,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B100,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B101,PCCM!B:I,3,FALSE)","v":0},"87c","Monitor for pollutants causing impairment of receiving waterbody designated uses.",{"$f":"IF(ISBLANK(VLOOKUP(B101,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B101,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B101,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B102,PCCM!B:I,3,FALSE)","v":0},"87d","Monitor for pollutants causing exceedances of receiving water quality standards.",{"$f":"IF(ISBLANK(VLOOKUP(B102,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B102,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B102,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B103,PCCM!B:I,3,FALSE)","v":0},"87e","Monitor for pollutants discharged by industrial users in quantities that are expected to adversely affect receiving water quality.",{"$f":"IF(ISBLANK(VLOOKUP(B103,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B103,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B103,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B104,PCCM!B:I,3,FALSE)","v":0},88,"Determine what EPA, state, and local water quality criteria or standards are applicable to the specific designated use(s) of the receiving water are available for these pollutants. Information on designated uses and use attainability analyses is available from EPA's Designated Uses website. In addition, links to state, tribal, and territorial WQS.",{"$f":"IF(ISBLANK(VLOOKUP(B104,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B104,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66","i",null,{"$f":"_xlfn.XLOOKUP(B104,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B105,PCCM!B:I,3,FALSE)","v":0},89,"Consult with the NPDES authority to determine whether CSOs are discharging into sensitive areas when determining the specific designated uses(s) of the receiving water. Sensitive areas are determined by the NPDES authority in coordination with state and federal agencies. As described in EPA's CSO Control Policy, sensitive areas include Outstanding National Resource Waters, National Marine Sanctuaries, waters with threatened or endangered species and their designated critical habitat, waters with primary contact recreation, public drinking water intakes, or their designated protection areas and shellfish beds.",{"$f":"IF(ISBLANK(VLOOKUP(B105,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B105,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B105,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B106,PCCM!B:I,3,FALSE)","v":0},90,"Discuss with the NPDES authority the sampling protocols and analytical methods acceptable for analysis of pollutants in receiving water.",{"$f":"IF(ISBLANK(VLOOKUP(B106,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B106,PCCM!B:I,4,FALSE))","v":""},"i\nPage 66",null,null,{"$f":"_xlfn.XLOOKUP(B106,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B107,PCCM!B:I,3,FALSE)","v":0},91,"Follow the sampling and analytical procedures in Title 40 of the CFR Part 136 (Appendix E), including the use of appropriate sample containers, sample preservation methods, maximum allowable holding times, described in Table II of Part 136.3, and analytical methods approved for NPDES compliance monitoring detailed in Tables IA-IH of Part 136.3.",{"$f":"IF(ISBLANK(VLOOKUP(B107,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B107,PCCM!B:I,4,FALSE))","v":""},"i\nPage 67",null,null,{"$f":"_xlfn.XLOOKUP(B107,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B108,PCCM!B:I,3,FALSE)","v":0},92,"Determine whether any additional parameters or field monitoring should be selected for PCCM. These parameters could include any anticipated CSO parameter subject to a TMDL wasteload allocation for CSOs or under a CWA 303(d) listing or any other parameter that could affect public health or aquatic life. Additional assessments could include biological assessments, sediment monitoring and whole effluent toxicity testing.",{"$f":"IF(ISBLANK(VLOOKUP(B108,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B108,PCCM!B:I,4,FALSE))","v":""},"i\nPage 71",null,null,{"$f":"_xlfn.XLOOKUP(B108,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B109,PCCM!B:I,3,FALSE)","v":0},"93a","When choosing sample locations, consider sampling around sensitive areas.",{"$f":"IF(ISBLANK(VLOOKUP(B109,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B109,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B109,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B110,PCCM!B:I,3,FALSE)","v":0},"93b","When choosing sample locations, consider sampling upstream and downstream of CSO outfalls.",{"$f":"IF(ISBLANK(VLOOKUP(B110,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B110,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B110,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B111,PCCM!B:I,3,FALSE)","v":0},"93c","When choosing sample locations, consider location and impacts of other sources of pollutant loadings including monitoring locations that have limited or known effects from other pollutant sources.",{"$f":"IF(ISBLANK(VLOOKUP(B111,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B111,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B111,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B112,PCCM!B:I,3,FALSE)","v":0},"93d","When choosing sample locations, consider historical monitoring locations used to initially characterize CSO impacts.",{"$f":"IF(ISBLANK(VLOOKUP(B112,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B112,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B112,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B113,PCCM!B:I,3,FALSE)","v":0},"93e","When choosing sample locations, consider waterbody size.",{"$f":"IF(ISBLANK(VLOOKUP(B113,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B113,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B113,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B114,PCCM!B:I,3,FALSE)","v":0},"93f","When choosing sample locations, consider horizontal and vertical variability in the waterbody.",{"$f":"IF(ISBLANK(VLOOKUP(B114,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B114,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B114,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B115,PCCM!B:I,3,FALSE)","v":0},"93g","When choosing sample locations, consider degree of resolution necessary to assess attainment of water quality standards.",{"$f":"IF(ISBLANK(VLOOKUP(B115,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B115,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B115,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B116,PCCM!B:I,3,FALSE)","v":0},"93i","When choosing sample locations, consider physical logistics (accessibility, whether water is navigable, if bridges are available from which to sample).",{"$f":"IF(ISBLANK(VLOOKUP(B116,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B116,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B116,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B117,PCCM!B:I,3,FALSE)","v":0},"93j","When choosing sample locations, consider crew safety.",{"$f":"IF(ISBLANK(VLOOKUP(B117,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B117,PCCM!B:I,4,FALSE))","v":""},"i\nPage 73",null,null,{"$f":"_xlfn.XLOOKUP(B117,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B118,PCCM!B:I,3,FALSE)","v":0},94,"Obtain samples at mid-depth (avoiding collection of sediment from the bottom and any scum at the top) at the midpoint of the waterbody to obtain a sample from a well-mixed portion of the river or stream.",{"$f":"IF(ISBLANK(VLOOKUP(B118,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B118,PCCM!B:I,4,FALSE))","v":""},"i\nPage 74",null,null,{"$f":"_xlfn.XLOOKUP(B118,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B119,PCCM!B:I,3,FALSE)","v":0},95,"Choose sampling locations that represent the worst-case scenario (areas that receive overflows most frequently or have the largest pollutant loading or flow volume, sensitive areas) if only a few locations can be monitored.",{"$f":"IF(ISBLANK(VLOOKUP(B119,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B119,PCCM!B:I,4,FALSE))","v":""},"i\nPage 75",null,null,{"$f":"_xlfn.XLOOKUP(B119,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B120,PCCM!B:I,3,FALSE)","v":0},96,"Coordinate CSO receiving water monitoring for primary and secondary contact recreation areas with existing water quality monitoring performed under the BEACH act. When selecting monitoring locations at recreational waters, the permitting community should, at a minimum, consider selecting monitoring locations near the CSO outfall and typical bathing areas.",{"$f":"IF(ISBLANK(VLOOKUP(B120,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B120,PCCM!B:I,4,FALSE))","v":""},"i\nPage 75",null,null,{"$f":"_xlfn.XLOOKUP(B120,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B121,PCCM!B:I,3,FALSE)","v":0},97,"Evaluate CSO discharges to waters designated for public water supply adjacent to intakes to ensure that any potential pollutants posing human health risk do not exceed treatment capacity of the distribution system. Discharges in such sensitive waters require exhaustive monitoring because of the potential for residential and agricultural pesticides and fertilizers in stormwater runoff. Further, heavy metals and trace organics might be present in runoff from roads and parking lots, which could require more advanced treatment than routine disinfection of sanitary discharges.",{"$f":"IF(ISBLANK(VLOOKUP(B121,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B121,PCCM!B:I,4,FALSE))","v":""},"i\nPage 76",null,null,{"$f":"_xlfn.XLOOKUP(B121,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B122,PCCM!B:I,3,FALSE)","v":0},98,"Measure rainfall using rain gauges throughout the CSS drainage area to evaluate local rainfall conditions and the impact of CSOs on receiving water. The PCCM plan should identify locations where rain gauges will be placed to provide data representative of the entire CSS drainage area. The permittee should space gauges closely enough to reduce variation in storm tracking and storm intensity measurements within the CSS area. As described in EPA's CSO Guidance for Monitoring and Modeling, rain gauges are often spaced 6 to 8 kilometers apart; however, gauges might need to be spaced more closely than that to provide sufficient data for analysis.",{"$f":"IF(ISBLANK(VLOOKUP(B122,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B122,PCCM!B:I,4,FALSE))","v":""},"i\nPage 76",null,null,{"$f":"_xlfn.XLOOKUP(B122,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B123,PCCM!B:I,3,FALSE)","v":0},99,"Provide locations of stream gauge stations. Historical stream flow data is very useful in planning when samples should be collected. Also, stream flow data collected during receiving water sample collection can be used to evaluate CSO controls and receiving water quality.",{"$f":"IF(ISBLANK(VLOOKUP(B123,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B123,PCCM!B:I,4,FALSE))","v":""},"i\nPage 77",null,null,{"$f":"_xlfn.XLOOKUP(B123,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B124,PCCM!B:I,3,FALSE)","v":0},100,"Ensure that most receiving water monitoring is performed during those seasons, flow regimes, and other critical conditions during which it is expected that CSOs would have the greatest potential for effects.",{"$f":"IF(ISBLANK(VLOOKUP(B124,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B124,PCCM!B:I,4,FALSE))","v":""},"i\nPage 78",null,null,{"$f":"_xlfn.XLOOKUP(B124,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B125,PCCM!B:I,3,FALSE)","v":0},101,"Collect samples during dry-weather events, wet-weather events during which a CSO is not expected to occur, and wet-weather events during which a CSO is expected to occur. Monitoring during both dry-weather events as well as wet-weather events during which a CSO is not expected to occur should provide background data on conditions in the receiving waters and help the permitting community determine whether water quality criteria are being met or exceeded during dry-weather and wet-weather non CSO events, respectively.",{"$f":"IF(ISBLANK(VLOOKUP(B125,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B125,PCCM!B:I,4,FALSE))","v":""},"i\nPage 79",null,null,{"$f":"_xlfn.XLOOKUP(B125,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B126,PCCM!B:I,3,FALSE)","v":0},102,"Monitor storms of varying intensity with a variety of pre-storm conditions (e.g., varying number of days since the last storm, varying intensity of the previous storms) and preceding dry days to represent a range of conditions experienced by the CSS.",{"$f":"IF(ISBLANK(VLOOKUP(B126,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B126,PCCM!B:I,4,FALSE))","v":""},"i\nPage 79",null,null,{"$f":"_xlfn.XLOOKUP(B126,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B127,PCCM!B:I,3,FALSE)","v":0},103,"Verify proper operation and regular maintenance programs for the sewer system and CSOs.",{"$f":"IF(ISBLANK(VLOOKUP(B127,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B127,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B127,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B128,PCCM!B:I,3,FALSE)","v":0},104,"Verify maximized use of the collection system for storage.",{"$f":"IF(ISBLANK(VLOOKUP(B128,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B128,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B128,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B129,PCCM!B:I,3,FALSE)","v":0},105,"Verify pretreatment requirements to assure CSO impacts are minimized.",{"$f":"IF(ISBLANK(VLOOKUP(B129,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B129,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B129,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B130,PCCM!B:I,3,FALSE)","v":0},106,"Verify maximized flow to the POTW treatment plant.",{"$f":"IF(ISBLANK(VLOOKUP(B130,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B130,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B130,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B131,PCCM!B:I,3,FALSE)","v":0},107,"Verify the prohibition of CSOs during dry weather.",{"$f":"IF(ISBLANK(VLOOKUP(B131,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B131,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B131,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B132,PCCM!B:I,3,FALSE)","v":0},108,"Verify the monitoring program effectively characterizes the CSO impacts and the efficacy of CSO controls.",{"$f":"IF(ISBLANK(VLOOKUP(B132,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B132,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B132,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B133,PCCM!B:I,3,FALSE)","v":0},109,"Continue to monitor green infrastructure performance. Consider additional projects.",{"$f":"IF(ISBLANK(VLOOKUP(B133,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B133,PCCM!B:I,4,FALSE))","v":""},null,null,17,{"$f":"_xlfn.XLOOKUP(B133,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B134,PCCM!B:I,3,FALSE)","v":0},110,"Continue to monitor green infrastructure performance. Consider additional projects.",{"$f":"IF(ISBLANK(VLOOKUP(B134,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B134,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B134,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"P, D, O"}]
[{"$f":"VLOOKUP(B135,PCCM!B:I,3,FALSE)","v":0},111,"Verify no more than an average of four to six overflow events per year system-wide.",{"$f":"IF(ISBLANK(VLOOKUP(B135,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B135,PCCM!B:I,4,FALSE))","v":""},"i\nPage 6",null,null,{"$f":"_xlfn.XLOOKUP(B135,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC1"}]
[{"$f":"VLOOKUP(B136,PCCM!B:I,3,FALSE)","v":0},112,"Verify the elimination or capture for treatment of no less than 85% by volume of the combined sewage collected in the CSS during precipitation events on a system-wide annual average basis.",{"$f":"IF(ISBLANK(VLOOKUP(B136,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B136,PCCM!B:I,4,FALSE))","v":""},"i\nPage 6",null,null,{"$f":"_xlfn.XLOOKUP(B136,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC2"}]
[{"$f":"VLOOKUP(B137,PCCM!B:I,3,FALSE)","v":0},113,"Verify the elimination or removal of no less than the mass of pollutants identified as causing water quality impairment through the sewer system characterization, monitoring, and modeling effort, for the volumes that would be eliminated or captured for treatment.",{"$f":"IF(ISBLANK(VLOOKUP(B137,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B137,PCCM!B:I,4,FALSE))","v":""},"i\nPage 6",null,null,{"$f":"_xlfn.XLOOKUP(B137,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"PC3"}]
[{"$f":"VLOOKUP(B138,PCCM!B:I,3,FALSE)","v":0},114,"Demonstrate that the selected control program is adequate to meet the water quality-based requirements of the Clean Water Act.",{"$f":"IF(ISBLANK(VLOOKUP(B138,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B138,PCCM!B:I,4,FALSE))","v":""},null,null,null,{"$f":"_xlfn.XLOOKUP(B138,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"D"}]
[{"$f":"VLOOKUP(B139,PCCM!B:I,3,FALSE)","v":0},115,"Verify that the CSO Control Plan will attain water quality standards and meet the requirements of the CSO Control Policy.",{"$f":"IF(ISBLANK(VLOOKUP(B139,PCCM!B:I,4,FALSE)),\"\",VLOOKUP(B139,PCCM!B:I,4,FALSE))","v":""},"i\nPage 5",null,null,{"$f":"_xlfn.XLOOKUP(B139,PCCM!$B$13:$B$84,PCCM!$A$13:$A$84)","v":"O"}]
[{"$f":"IF(ISBLANK(PCCM!C87),\"Yes\",\"No\")","v":"Yes"},null,"Additional Considerations - PCCM Implementation"]
[{"$f":"IF(ISBLANK(PCCM!C87),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(ISBLANK(PCCM!C87),\"\",PCCM!C87)","v":""}]
["Botton: Go to the previous page."]

{"sheet":"Lists","index":6,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"blank, yes, no"]
[]
[null,"Yes"]
[null,"No"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"a","a","a"]
[null,null,null,null,null,null,null,"b","b","b"]
[null,null,null,null,null,null,null,"c","c","c"]
[null,null,null,null,null,null,null,"d","d","d"]
[null,null,null,null,null,null,null,"e","e","e"]
[null,null,null,null,null,null,null,"f","f","f"]
[null,null,null,null,null,null,null,"g","g","g"]
[null,null,null,null,null,null,null,"h","h","h"]
[null,null,null,null,null,null,null,"i","i","i"]
[null,null,null,null,null,null,null,"j","j","j"]
[null,null,null,null,null,null,null,"k","k","k"]
[null,null,null,null,null,null,null,"l","l","l"]
[null,null,null,null,null,null,null,"m","m","m"]
[null,null,null,null,null,null,null,"n","n","n"]
[null,null,null,null,null,null,null,"o","o","o"]
[null,null,null,null,null,null,null,"p","p","p"]
[null,null,null,null,null,null,null,"q","q","q"]
[null,null,null,null,null,null,null,"r","r","r"]
[null,null,null,null,null,null,null,"a","s","a"]
[null,null,null,null,null,null,null,"t","t","t"]
[null,null,null,null,null,null,null,"u","u","u"]
[null,null,null,null,null,null,null,"v","v","v"]
[null,null,null,null,null,null,null,"w","v","w"]
[null,null,null,null,null,null,null,"x",1,"x"]
[null,null,null,null,null,null,null,"y",2,"y"]
[null,null,null,null,null,null,null,"z",3,"z"]
[null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,3]