{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Intro","Getting Started","NMC","SystChar","Alternatives","Implementation","Rev. Sum.","O. Items","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":8,"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":"Intro","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,3,4,10],[6,3,6,10],[1,2,2,11],[7,2,7,11],[11,3,11,10]]}
[]
[null,null,"Long-Term Control Plan (LTCP) Review Checklist "]
[null,"Color_B_Intro_GetStarted"]
[]
[null,null,null,"Welcome to the long-term control plan (LTCP) review checklist! EPA created this checklist to support combined sewer overflow (CSO) LTCP development and review. The checklist is based on existing EPA guidance such as the Combined Sewer Overflows Guidance for Long-Term Control Plan and Guidance for Nine Minimum Controls. EPA designed the checklist to help CSO permittees and National Pollutant Discharge Elimination System (NPDES) authorities determine if the LTCPs meet the requirements of the CSO Control Policy and conform with EPA guidance on developing LTCPs. The checklist also provides a list of recommendations that can be used to improve 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,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,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."]

{"sheet":"Getting Started","index":1,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,2,2,8],[9,2,9,3],[10,2,10,8],[11,2,11,8],[22,3,22,5],[18,2,18,8],[20,3,20,5],[21,3,21,5],[12,2,12,8],[13,2,13,8],[14,2,14,8],[17,2,17,8],[16,2,16,8],[15,2,15,8],[24,3,24,5],[19,2,19,3],[23,3,23,5]]}
["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, select either the Small System or Large System option depending on the size of your system. Small systems serve less than 75,000 people, while large systems serve greater than 75,000 people. Selecting either option will bring you to the applicable review questions.\n3. 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.\n4. Navigate to different pages using the tab key to toggle across navigation buttons.\n5. 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 Combined Sewer Overflow Guidance for Long-Term Control Plan or Guidance for Nine Minimum Controls.\n6. Use the Additional Considerations cell at the bottom of each page to provide additional details specific to the LTCP under review.\n7. Once you answer all questions, go to the 5. Addressed Items page to see a summary of the documents reviewed as part of the LTCP review.\n8. Finally, go to the 6. Recommendations page to see a list of suggested improvements for the LTCP.\n9. 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,"Long-Term Control Plan (LTCP) Review Checklist "]
[null,"Nav_AddressedItems"]
["Button: Go to the 1. Nine Minimum Controls page"]
["Button: Go to the 2. System Characterization page"]
["Button: Go to the 3. Alternatives Evaluation page"]
["Button: Go to the 4. LTCP Implementation page"]
["Button: Go to the 5. Addressed Items page"]
["Button: Go to the 6. Recommendations page"]
["Button: Full Reset",null,"Instructions:"]
["Button: Go back to the Introduction page",null,"1. Fill out the \"User Information\" section below."]
["a\na",null,"2. Click the appropriate button under \"Select your role!\"."]
["a\na",null,"3. Enter required information in red cells throughout this checklist. Note the specific supporting documentation (include title, date, version)."]
["a\na",null,"4. 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,"5. Click the i button to the right of each question to access helpful resources, including EPA's Combined Sewer Overflows Guidance for Long-Term Control Plan or Guidance for Nine Minimum Controls. Where applicable, a specific page is noted to point to a relevant section of the suggested guidance document."]
[null,null,"6. Use the “Additional Considerations” box at the bottom on each page to provide additional details specific to the LTCP under review."]
[null,null,"7. Once you answer all questions, go the \"5. Addressed Items\" page to see a summary of the documents reviewed as part of the LTCP review."]
[null,null,"8. Finally, go to the \"6. Recommendations\" page to see a list of suggested improvements for the LTCP."]
[null,null,"9. To clear all information and start over, click the \"Full Reset\" button in the top right corner or \"Reset All Entries\" button in the bottom of the of each page. "]
[null,null,"User Information:"]
["a\na",null,"Reviewer:"]
["a\na",null,"Permittee Name(s):"]
["a\na",null,"Permit Number(s):"]
[null,null,"LTCP Name, Date and Version:"]
["a\na",null,"Date:"]
[]
["a\na",null,null,null,"Select your role! - Who are you?*"]
["a\na"]
["Button: Press enter if you are a Small System Permittee or NPDES Authority"]
["Button: Press enter if you are a Large System Permittee or NPDES Authority"]
["Button: Go back to the Introduction page",null,null,null,"*Small systems serve populations under 75,000"]
[]
["a\na"]
["a\na"]

{"sheet":"NMC","index":2,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[22,2,22,6],[1,2,1,6],[21,2,21,7],[9,5,9,6],[10,2,10,6],[20,2,20,6]]}
["1. Nine Minimum Controls. This page includes questions about the permittee's implementation of the nine minimum controls. 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,"Long-Term Control Plan (LTCP) Review Checklist"]
["Button: Go to the Getting Started page"]
[]
["Button: Go to the 2. System Characterization page"]
["Button: Go to the 3. Alternatives Evaluation page"]
["Button: Go to the 4. LTCP Implementation page"]
["Button: Go to the 5. Addressed Items page"]
["Button: Go to the 6. Recommendations page"]
[null,null,"Has the permittee implemented the following nine minimum controls (NMC)?","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\nResources"]
[null,null,"NMC"]
["a\na",1,"1. Proper operation and regular maintenance programs for the sewer system and CSO outfalls",null,null,"i\nPage 18","i"]
["a\na",{"$f":"B12+1","v":2},"2. Maximum use of the collection system for storage",null,null,"i\nPage 24","i"]
["a\na",{"$f":"B13+1","v":3},"3. Review and modification of pretreatment requirements to ensure that CSO impacts are minimized",null,null,"i\nPage 28","i"]
["a\na",4,"4. Maximization of flow to the POTW",null,null,"i\nPage 32","i"]
["a\na",5,"5. Elimination of CSOs during dry weather",null,null,"i\nPage 35","i"]
["a\na",6,"6. Control of solid and floatable materials in CSOs",null,null,"i\nPage 40","i"]
["a\na",7,"7. Pollution prevention programs to reduce containments in CSOs",null,null,"i\nPage 54","i"]
["a\na",8,"8. Public notification to ensure that the public receives adequate notification of CSO occurrences and CSO impacts",null,null,"i\nPage 60","i"]
["a\na",9,"9. Monitoring to effectively characterize CSO impacts and the efficacy of CSO controls",null,null,"i\nPage 63","i"]
[null,null,"Additional Considerations"]
[null,null,"If there are other considerations not noted above and related to Nine Minimum Controls, note them here."]
[]
["Button: Go to the previous page"]
["Button: Reset all entries on this page"]
["Button: Go to the next page"]

{"sheet":"SystChar","index":3,"n_rows":75,"n_cols":7,"rows_kept":75,"cut":false,"hidden":false,"merged":[[70,2,70,7],[71,2,71,6],[1,2,1,6],[10,2,10,6],[40,2,40,6],[56,2,56,6],[69,2,69,6],[9,5,9,6]]}
["2. System Characterization. This page includes questions about the System Characterization performed by the permittee. 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,"Long-Term Control Plan (LTCP) Review Checklist"]
["Button: Go to the Getting Started page"]
["Button: Go to the 1. Nine Minimum Controls page"]
[]
["Button: Go to the 3. Alternatives Evaluation page"]
["Button: Go to the 4. LTCP Implementation page"]
["Button: Go to the 5. Addressed Items page"]
["Button: Go to the 6. Recommendations page"]
[null,null,"Answer the following questions regarding system characterization.","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\nResources"]
["sm",null,"General System Characterization"]
["sm\nall","MC1","Major Question: Has the permittee collected and presented existing information and data on the CSS and receiving waters in a format that is understandable and consistent with the CSO Control Policy and guidance? If no, briefly describe what the permittee can do to improve the quality of their submittal.",null,null,"i\nPage 34"]
["sm",null,"Combined Sewer System"]
["sm\nall",{"$f":"NMC!B20+1","v":10},"Is the location provided for the major interceptors and each CSO outfall (latitude/longitude or street address) and identified on a map?"]
["sm\nall",{"$f":"B14+1","v":11},"Are the identified CSO outfalls consistent with the existing permit?"]
["a\na",{"$f":"B15+1","v":12},"Have the CSS area and its sewersheds been delineated?",null,null,"i\nPage 40"]
["a\na",13,"Have land use and estimated impervious cover been provided for each sewershed? If only land use or impervious cover is missing, please provide additional detail in the notes column to the right.",null,null,"i\nPage 40"]
["sm\nall",14,"Are the principal hydraulic control structures identified on a map (e.g., interceptors; regulators; pump stations; storage and controls facilities; POTW)?  If no, indicate which items are missing in the notes column to the right.",null,null,"i\nPage 42"]
["a\na",15,"Are POTW capacities (e.g., primary and secondary; average and peak) specified?",null,null,"i\nPage 42","i\nPage 33"]
["sm\nall",16,"Are dry weather sanitary flow (baseflow) estimates or patterns presented?",null,null,"i\nPage 42","i\nPage 33"]
["a\na",17,"Are wastewater flows to the CSS from neighboring or satellite communities identified and quantified, if present? If no neighboring or satellite communities are present, indicate this in the notes column to the right.",null,null,"i\nPage 42"]
["a\na",18,"Are any existing flow metering or SCADA records described? If there is no flow metering or SCADA system in place, indicate this in the notes column to the right.",null,null,"i\nPage 42"]
["sm\nall",19,"Are chronic problem areas or bottlenecks within the CSS described? If the CSS has been well characterized and there are no known problem areas, indicate this in the notes column to the right.",null,null,"i\nPage 42"]
["a\na",20,"Did the permittee identify significant industrial users within the CSS service area? If there are no significant industrial users within the CSS service area, indicate this in the notes column to the right.",null,null,"i\nPage 42"]
["sm",null,"Receiving Water(s)"]
["a\na",{"$f":"B24+1","v":21},"Are all of the CSO-impacted waters identified?",null,null,"i\nPage 44"]
["a\na",{"$f":"B26+1","v":22},"Is the available information on stream flow or tidal conditions, water quality and sediment in the receiving water(s) summarized and presented?",null,null,"i\nPage 44"]
["a\na",{"$f":"B27+1","v":23},"Are the pollutants of concern identified for each receiving water?",null,null,"i\nPage 44"]
["a\na",24,"Does the characterization provide information on the known effects of the CSOs on water quality during wet weather events?",null,null,"i\nPage 44"]
["sm\nall",25,"Are the current water quality standards and existing and designated uses of each receiving water identified?",null,null,"i\nPage 44"]
["sm\nall",26,"Is there information on whether the designated uses are currently being met?",null,null,"i\nPage 44"]
["a\na",27,"Are any known impairments attributable to CSOs identified for the receiving waters (303(d) list, 305(b) list, fish kills, beach closures, etc.)?",null,null,"i\nPage 44"]
["a\na",28,"If a TMDL has been or will be developed, does the permittee consider the TMDL in the LTCP?",null,null,"i\nPage 44"]
["sm\nall",29,"Is the presence or absence of sensitive areas determined and documented?",null,null,"i\nPage 44","i\nPage 30"]
["sm/\nsn",30,"Are sensitive areas present (see helpful resources to the right for definition of sensitive areas)?",null,null,"i\nPage 30","i\nPage 125"]
["sm/\nsn",31,{"$f":"IF(OR($D$35=\"Yes\",$D$35=\"\"),\"Have CSO outfalls located in sensitive areas been identified?\",\"Sensitive Areas Question - Not Applicable\")","v":"Have CSO outfalls located in sensitive areas been identified?"},null,null,"i\nPage 44","i\nPage 30"]
["a\na",32,"Was the available information on pollutant loadings, from other point and nonpoint sources in the watershed, identified and compiled? If there are known sources of information on pollutant loadings that are missing, describe these in the notes column to the right.",null,null,"i\nPage 44"]
["sm",null,"Rainfall"]
["a\na",{"$f":"B37+1","v":33},"Are long-term rainfall records and annual average conditions identified and evaluated? If incomplete, describe how evaluation of rainfall conditions could be improved in the notes column to the right.",null,null,"i\nPage 59"]
["sm\nall",{"$f":"B39+1","v":34},"Does the permittee demonstrate an adequate understanding of the rainfall conditions that cause CSO events at each outfall? If not, describe how they can improve their understanding of conditions that cause CSO events in the notes column to the right.",null,null,"i\nPage 59"]
["sm",null,"Characterization of Collection System and Receiving Waters Monitoring"]
["sm\nall","MC2","Major Question: Does the monitoring program document the frequency and magnitude of CSO events and associated impacts to inform the evaluation and selection of CSO controls?",null,null,"i\nPage 53"]
[null,null,"Collection System"]
["a\na",{"$f":"B40+1","v":35},"Are data available for a range of storms to characterize the hydraulic response of the CSS, including frequency, volume and flow rate, and pollutant loads from CSOs at major or representative outfalls?",null,null,"i\nPage 57"]
["a\na",{"$f":"B44+1","v":36},"Does the LTCP present estimated concentrations of the pollutants discharged and justification (compiled through sampling, from literature values, or with values from other CSO studies)? ",null,null,"i\nPage 58"]
["a\na",{"$f":"B45+1","v":37},"Was rainfall data collected within the CSS during the flow monitoring periods?",null,null,"i\nPage 59"]
["a\na",38,"Does the flow monitoring data portray the hydraulic response of the CSS to rainfall? If no, describe any deficiencies in the notes column to the right.",null,null,"i\nPage 60"]
["a\na",39,"Is the monitoring program able to evaluate the effectiveness of any control measures implemented as part of the NMC? If no, describe any specific improvements that can be made in the notes column to the right.",null,null,"i\nPage 62"]
["a\na",{"$f":"B48+1","v":40},"If one CSO outfall is selected to represent a subset of CSO outfalls, did the LTCP provide a justification for that selection?",null,null,"i\nPage 74"]
["sm",null,"Receiving Water(s)"]
["a\na",{"$f":"B49+1","v":41},"Does the monitoring program take into account the type (e.g., free flowing, tidal) and physical characteristics of the receiving water? ",null,null,"i\nPage 65"]
["a\na",{"$f":"B51+1","v":42},"Is there information on the impact of CSO pollutant loadings on the receiving waters for the water quality parameters of concern? (Typically bacteria, BOD and TSS)",null,null,"i\nPage 65"]
["a\na",{"$f":"B52+1","v":43},"Does the monitoring document pre-control baseline conditions, to allow the permittee to demonstrate the long-term benefits of CSO controls? If no, describe any specific improvements that can be made to the monitoring program in the notes column to the right.",null,null,"i\nPage 62"]
["a\na",44,"Does the monitoring program include adequate spatial and temporal coverage during wet weather conditions to support an evaluation of the impacts associated with CSOs? If no, describe any specific improvements that can be made to the monitoring program in the notes column to the right.",null,null,"i\nPage 55"]
["sm\nall",45,"Do monitoring results show that water quality standards and designated uses are not met in part because of other sources of pollutants, such as stormwater and upstream sources? Provide documentation for the assessment of other sources and associated monitoring results.",null,null,"i\nPage 55"]
["sm\nall",46,"Does the monitoring consider the appropriate range of possible CSO impacts on receiving waters based on the concerns of the local community? (Typically bacteria and floatables; sometimes dissolved oxygen, metals, or nutrients)",null,null,"i\nPage 65"]
["sm",null,"Characterization of Collection System and Receiving Waters Modeling"]
[null,"MC3","Major Question: Has the permittee developed, calibrated, and verified a model of the collection system and/or receiving water, as appropriate, that is able to support the evaluation and selection of CSO controls given the complexity of the CSS?",null,null,"i\nPage 81"]
[null,null,"Collection System"]
["a\na",{"$f":"B56+1","v":47},"Has some type of model (e.g., spreadsheet, SWMM, HydroWorks, etc.) been developed to assess the response of the CSS to different rainfall conditions with respect to CSO volume, frequency and peak overflow rate?",null,null,"i\nPage 81"]
["a\na",{"$f":"B60+1","v":48},"Does the selected CSS model framework address the engineering and regulatory needs of the LTCP? If no, provide suggestions on how the model framework can be improved in the notes column to the right.",null,null,"i\nPage 81"]
["a\na",{"$f":"B61+1","v":49},"Is the level of detail of the CSS model consistent with and representative of the complexity of the CSS? If no, provide suggestions on how the level of detail can be improved in the notes column to the right.",null,null,"i\nPage 81"]
["a\na",50,"Are flow and effluent concentration data available to calibrate the model? (e.g., 8 - 10 storms covering a range of annual storm sizes)",null,null,"i\nPage 81"]
["a\na",51,"Is the model credible? That is, has the model been documented, calibrated and verified to demonstrate that it represents observed behavior (in terms of CSO volume, duration, frequency, and peak overflow rate) over a variety of rainfall events? If no, describe the deficiencies in the notes column to the right.",null,null,"i\nPage 81"]
["sm",null,"Receiving Water(s)"]
["a\na",{"$f":"B64+1","v":52},"Has some type of model been developed to assess the response of receiving waters to external CSO loads?",null,null,"i\nPage 81"]
["a\na",{"$f":"B66+1","v":53},"Is the level of detail of the water quality model(s) relatively consistent with and representative of the complexity of the receiving waters? If no, please describe any improvements that can be made in the notes column to the right.",null,null,"i\nPage 81"]
["a\na",{"$f":"B67+1","v":54},"Is the model credible? That is, has the model been documented, calibrated and verified to demonstrate that it generally represents the major processes affecting water quality for the pollutants of concern? If no, describe any deficiencies in the notes column to the right.",null,null,"i\nPage 81"]
["sm\nall",55,"Do modeling results show that water quality standards and designated uses are not met in part because of other sources of pollutants, such as stormwater and upstream sources? Provide documentation for the assessment of other sources and associated modeling results. ",null,null,"i\nPage 81"]
["sm",null,"Additional Considerations"]
[null,null,"If there are other considerations not noted above and related to System Characterization, note them here."]
[]
[]
["Button: Reset all entries on this page"]
["Button: Go to the next page"]

{"sheet":"Alternatives","index":4,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[52,2,52,6],[51,2,51,7],[10,2,10,6],[1,2,1,6],[9,5,9,6],[44,2,44,6],[50,2,50,6]]}
["3. Alternatives Evaluation. This page includes questions about the Alternatives Evaluation performed by the permittee. 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,"Long-Term Control Plan (LTCP) Review Checklist"]
["Button: Go to the Getting Started page"]
["Button: Go to the 1. Nine Minimum Controls page"]
["Button: Go to the 2. System Characterization page"]
[]
["Button: Go to the 4. LTCP Implementation page"]
["Button: Go to the 5. Addressed Items page"]
["Button: Go to the 6. Recommendations page"]
[null,null,"Answer the following questions regarding alternatives evaluation. ","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\nResources"]
["sm",null,"Development and Evaluation of CSO Control Alternatives"]
["sm\nall","MC4","Major Question: Has the permittee evaluated CSO control alternatives to select a cost-effective CSO control plan to meet water quality standards and protect designated uses?",null,null,"i\nPage 98"]
["sm",null,"Long-Term Control Plan Approach"]
["sm\nall",{"$f":"SystChar!B69+1","v":56},"Has the permittee organized the evaluation of controls in a technical framework and approach that is understandable and consistent with the CSO Control Policy and EPA guidance? If no, list any specific recommendations for improvement in the notes column to the right.",null,null,"i\nPage 100"]
["sm\nall",{"$f":"B14+1","v":57},"Has the permittee identified whether the presumption approach, the demonstration approach or some combination of the two is being used? ",null,null,"i\nPage 100"]
["sm",null,"Development of CSO Control Alternatives"]
["sm\nall",{"$f":"B15+1","v":58},"Has the permittee considered a range of control technology within the general categories of source controls, collection system controls, storage technologies and treatment technologies? If only a partial range has been considered, note any suggested improvements in the notes column to the right.",null,null,"i\nPage 126"]
["sm\nall",{"$f":"B17+1","v":59},"Has the permittee evaluated a full range of potential controls with respect to meeting water quality standards and protecting designated uses? (A full range should include zero overflow events per year, and averages of 1 to 3, 4 to 7, and 8 to 12 overflow events per year)",null,null,"i\nPage 115"]
["sm\nall",{"$f":"B18+1","v":60},"Does the LTCP describe the process by which the CSO control and alternatives combinations were developed?",null,null,"i\nPage 115"]
["sm\nall",61,"Does the LTCP describe the approach used to screen and narrow the list of CSO control technologies, and list the screening criteria?",null,null,"i\nPage 115"]
["sm\nall",62,"Does the LTCP explain the reasons for selecting certain CSO controls?",null,null,"i\nPage 115"]
["sm\nall",63,"Have the NMC been integrated into the permittee’s description of the selected CSO controls?",null,null,"i\nPage 116"]
["sm\nall",64,"Has the permittee maximized treatment at the existing POTW for wet weather flows, and considered expansion of primary and secondary treatment capacity? Primary treatment is defined in CWA Section 301(h)(9).",null,null,"i\nPage 123"]
["sm\nall",65,"Has a cost/performance (knee of the curve) analysis been developed for the control alternatives considered?",null,null,"i\nPage 138"]
["sm/\nsn",66,{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"Has the permittee given the control of CSO discharges to sensitive areas a high priority?\",\"Sensitive Areas Question - Not Applicable\")","v":"Has the permittee given the control of CSO discharges to sensitive areas a high priority?"},null,null,"i\nPage 125"]
["sm/\nsn",{"$f":"B25+1","v":67},{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"If sensitive areas are impacted, will the selected CSO controls eliminate all CSO impacts on sensitive areas? If sensitive areas are not impacted, indicate this in the notes column to the right.\",\"Sensitive Areas Question - Not Applicable\")","v":"If sensitive areas are impacted, will the selected CSO controls eliminate all CSO impacts on sensitive areas? If sensitive areas are not impacted, indicate this in the notes column to the right."},null,null,"i\nPage 125"]
["sm/\nsn",68,{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"If not, do the data support the permittee’s apparent conclusion that elimination is not physically possible or economically achievable? If this question does not apply, indicate this in the notes column to the right. \",\"Sensitive Areas Question - Not Applicable\")","v":"If not, do the data support the permittee’s apparent conclusion that elimination is not physically possible or economically achievable? If this question does not apply, indicate this in the notes column to the right. "},null,null,"i\nPage 118","i\nPage 30"]
["sm/\nsn",69,{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"If CSO discharges to sensitive areas remain, will these CSOs receive treatment?\",\"Sensitive Areas Question - Not Applicable\")","v":"If CSO discharges to sensitive areas remain, will these CSOs receive treatment?"},null,null,"i\nPage 135","i\nPage 30"]
["sm\nall",70,"Will the selected CSO controls provide the treatment of floatables and settleable solids equivalent to that achieved by primary clarification?",null,null,"i\nPage 135","i\nPage 30"]
["sm\nall",71,"Does the LTCP demonstrate whether or not disinfection of effluent will be necessary based on applicable water quality standards?",null,null,"i\nPage 135","i\nPage 104"]
["sm",null,"Green Infrastructure"]
["sm\nall",{"$f":"B30+1","v":72},"Is the permittee implementing green infrastructure?",null,null,"i\nPage 7"]
["sm\nall",{"$f":"B32+1","v":73},{"$f":"IF($D$32=\"No\",\"Green Infrastructure Question - Not Applicable\",\"Did the permittee implement green infrastructure in response to requirements of an enforceable mechanism such as an NPDES permit and/or an enforcement order?\")","v":"Did the permittee implement green infrastructure in response to requirements of an enforceable mechanism such as an NPDES permit and/or an enforcement order?"},null,null,"i\nPage 12"]
["sm\nall",{"$f":"B33+1","v":74},{"$f":"IF($D$32=\"No\",\"Green Infrastructure Question - Not Applicable\",\"Did the permittee determine the volume of runoff expected to be controlled by green infrastructure in a well-documented and verifiable way?\")","v":"Did the permittee determine the volume of runoff expected to be controlled by green infrastructure in a well-documented and verifiable way?"},null,null,"i\nPage 20"]
["sm",null,"Water Quality Standards"]
["sm\nall",{"$f":"B34+1","v":75},"Is information provided to show that CSO discharges remaining after implementation of the planned control program will not cause or contribute to the non-attainment of water quality standards or existing uses?",null,null,"i\nPage 118"]
["sm\nall",{"$f":"B36+1","v":76},"If water quality standards cannot be met because of CSO discharges that remain after implementation of the planned control program, has the permittee shown any one of the six factors specified under 40 CFR 131.10(g) preclude the attainment of use as determined through the use attainability analysis (UAA) (40 CFR 131.10(j)) to justify a water quality standards review?",null,null,"i\nPage 118","i"]
["sm\nall",{"$f":"B37+1","v":77},"Has it been demonstrated that there may be removal of designated uses based on 40 CFR 131.10 (g) and (h)? ",null,null,"i\nPage 118","i"]
["sm\nall",78,"If water quality standards cannot be met because of sources other than CSOs, are the other limiting sources and natural background conditions documented?",null,null,"i\nPage 118"]
[null,null,"Watershed Considerations"]
["a\na",{"$f":"B39+1","v":79},"Is the LTCP monitoring being coordinated with other municipal efforts, or ongoing or planned state programs, within the same watershed?",null,null,"i\nPage 22"]
["a\na",{"$f":"B41+1","v":80},"Has LTCP development been coordinated with watershed or TMDL efforts?",null,null,"i\nPage 22"]
[null,null,"Financial Capability"]
["a\na",{"$f":"B42+1","v":81},"Has an assessment of the financial resources available for the implementation of CSO controls been completed following the general guidelines in Section 3.5 of EPA's Guidance for LTCP? If no, describe any recommended improvements in the notes column to the right. (Financial indicators include such factors as total annual wastewater and CSO control cost per household; unemployment rate; median household income; property tax revenue collection rate)",null,null,"i\nPage 163","i"]
["sm",null,"Public Participation"]
["sm\nall","MC5","Major Question: Does the LTCP document the process used to inform the public about the alternatives for CSO control and engage them in the decision process?",null,null,"i\nPage 98","i\nPage 177"]
["sm",null,"General"]
["sm\nall",{"$f":"B44+1","v":82},"Did the public participation process actively involve the affected public including rate payers, industrial users of the CSS, persons near impacted waters, and persons who use the impacted waters?",null,null,"i\nPage 98","i\nPage 177"]
["sm\nall",{"$f":"B48+1","v":83},"Does LTCP include a record of the public participation events, including the number of people attending and a record or summary of participant comments?",null,null,"i\nPage 98","i\nPage 177"]
["sm\nall",{"$f":"B49+1","v":84},"Does the LTCP document decisions or changes made in response to public comments?",null,null,"i\nPage 98","i\nPage 177"]
["sm",null,"Additional Considerations"]
[null,null,"If there are other considerations not noted above and related to Alternatives Evaluation, note them here."]
[]
["Button: Go to the previous page"]
["Button: Reset all entries on this page"]
["Button: Go to the next page"]

{"sheet":"Implementation","index":5,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,2,35,6],[34,2,34,7],[1,2,1,6],[9,5,9,6],[10,2,10,6],[33,2,33,6]]}
["4. LTCP Implementation. This page includes questions about the LTCP 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,"Long-Term Control Plan (LTCP) Review Checklist"]
["Button: Go to the Getting Started page"]
["Button: Go to the 1. Nine Minimum Controls page"]
["Button: Go to the 2. System Characterization page"]
["Button: Go to the 3. Alternatives Evaluation page"]
[]
["Button: Go to the 5. Addressed Items page"]
["Button: Go to the 6. Recommendations page"]
[null,null,"Answer the following questions regarding LTCP 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\nResources"]
["sm",null,"Selection of Controls and Implementation"]
["a\na","MC6","Major Question: Does the LTCP document a reasonable process for evaluating a range of controls and selecting a suite of CSO controls sufficient to meet water quality standards and designated and existing uses?",null,null,"i\nPage 98"]
["sm",null,"Long-Term Control Plan Approach"]
["sm\nall",{"$f":"Alternatives!B50+1","v":85},"Does the LTCP document benefits derived from implementation of the NMC?",null,null,"i\nPage 116"]
[null,null,"Selection and Development of Recommended Plan"]
["a\na",{"$f":"B14+1","v":86},"Does the LTCP document the controls selected for implementation, including detailed descriptions, preliminary engineering analysis, and cost estimates? If specific items are missing, list them in the notes section to the right.",null,null,"i\nPage 180"]
["a\na",{"$f":"B16+1","v":87},"Has the selected alternative been shown to be adequate, or reasonable to presume adequate, to provide for the attainment of applicable water quality standards and the protection of existing and designated uses?",null,null,"i\nPage 180"]
[null,null,"Financing Plan"]
["a\na",{"$f":"B17+1","v":88},"Does the LTCP recommend a financing approach demonstrating how the permittee will finance the alternative selected; identifying a specific capital and annual cost funding approach?",null,null,"i\nPage 182"]
["a\na",{"$f":"B19+1","v":89},"Did the permittee evaluate funding through increased sewer user fees and rate structures for residential, commercial and industrial  users?",null,null,"i\nPage 182"]
["a\na",{"$f":"B20+1","v":90},"Did the permittee evaluate grant and loan availability and other sources of financing?",null,null,"i\nPage 182"]
["sm",null,"Implementation Schedule"]
["a\na",{"$f":"B21+1","v":91},"Are the implementation phases of the LTCP consistent with permittee’s available resources and the priorities for eliminating the CSO-induced impairment? If no, provide specific recommendations for the permittee to improve their implementation schedule in the notes column to the right.",null,null,"i\nPage 185"]
["sn/\nsm",{"$f":"B23+1","v":92},{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"If sensitive areas are present and impacted by CSOs, has the permittee given the control of CSO discharges to sensitive areas a high priority?\",\"Sensitive Areas Question - Not Applicable\")","v":"If sensitive areas are present and impacted by CSOs, has the permittee given the control of CSO discharges to sensitive areas a high priority?"},null,null,"i\nPage 185"]
[null,null,"Operational Plan"]
["a\na",{"$f":"B24+1","v":93},"Does the LTCP document how the current operational plan for the CSS will be developed/revised to include the operational and maintenance needs of the controls selected for implementation?",null,null,"i\nPage 189","i"]
["a\na",{"$f":"B26+1","v":94},"Does the operational plan include sampling and maintenance schedules?",null,null,"i\nPage 189","i"]
["a\na",{"$f":"B27+1","v":95},"Does the operational plan identify staffing needs?",null,null,"i\nPage 189","i"]
["sm",null,"Post-Construction Compliance Monitoring"]
["sm\nall",{"$f":"B28+1","v":96},"Does the monitoring program verify compliance with water quality standards and protection of designated uses?",null,null,"i\nPage 191"]
["sm\nall",{"$f":"B30+1","v":97},"Does the monitoring plan include 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 191"]
["sm\nall",{"$f":"B31+1","v":98},"Does the LTCP describe how and when post-construction monitoring will be conducted and how the results will be reported? If no, provide suggestions on how to improve post construction monitoring and reporting in the notes column to the right.",null,null,"i\nPage 191"]
["sm\nall",99,"Does the post-construction compliance monitoring program include adequate spatial and temporal coverage during wet weather conditions to assess the effectiveness of CSO controls and improvement from pre-control baseline conditions associated with LTCP implementation? Provide suggestions on how to improve the monitoring program in the notes column to the right.",null,null,"i\nPage 191"]
["sm",null,"Additional Considerations"]
[null,null,"If there are other considerations not noted above and related to LTCP Implementation, note them here."]
[]
["Button: Go to the previous page"]
["Button: Reset all entries on this page"]
["Button: Go to the next page"]

{"sheet":"Rev. Sum.","index":6,"n_rows":135,"n_cols":8,"rows_kept":135,"cut":false,"hidden":false,"merged":[[66,2,66,6],[79,2,79,6],[77,2,77,6],[132,2,132,5],[12,4,12,6],[1,2,1,6],[131,2,131,6],[13,2,13,6],[113,2,113,5],[24,2,24,5],[78,2,78,5],[23,2,23,6],[107,2,107,6],[114,2,114,6],[112,2,112,6],[25,2,25,6],[52,2,52,6]]}
["5. Addressed Items. This page provides a summary of all items that were addressed within the LTCP, as well as the specific documentation that was used to support each item. 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 addressed items. This action will filter the full list of questions down to only those for which the reviewer answered \"yes\"."]
[null,null,"Long-Term Control Plan (LTCP) Review Checklist"]
["Button: Go to the Getting Started page"]
["Button: Go to the 1. Nine Minimum Controls page"]
["Button: Go to the 2. System Characterization page"]
["Button: Go to the 3. Alternatives Evaluation page"]
["Button: Go to the 4. LTCP Implementation page"]
[]
["Button: Go to the 6. Recommendations page"]
["Button: Press enter to see Addressed Items"]
[]
[]
[null,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\nResources"]
["Yes",null,"Nine Minimum Controls"]
[{"$f":"VLOOKUP(B15,NMC!$B$12:$D$20,3,FALSE)","v":0},1,"1. Proper operation and regular maintenance programs for the sewer system and CSO outfalls",{"$f":"IF(ISBLANK(VLOOKUP(B15,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B15,NMC!B:E,4,FALSE))","v":""},"i\nPage 18","i",null,"a\na"]
[{"$f":"VLOOKUP(B16,NMC!$B$12:$D$20,3,FALSE)","v":0},2,"2. Maximum use of the collection system for storage",{"$f":"IF(ISBLANK(VLOOKUP(B16,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B16,NMC!B:E,4,FALSE))","v":""},"i\nPage 24","i",null,"a\na"]
[{"$f":"VLOOKUP(B17,NMC!$B$12:$D$20,3,FALSE)","v":0},3,"3. Review and modification of pretreatment requirements to ensure that CSO impacts are minimized",{"$f":"IF(ISBLANK(VLOOKUP(B17,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B17,NMC!B:E,4,FALSE))","v":""},"i\nPage 28","i",null,"a\na"]
[{"$f":"VLOOKUP(B18,NMC!$B$12:$D$20,3,FALSE)","v":0},4,"4. Maximization of flow to the POTW",{"$f":"IF(ISBLANK(VLOOKUP(B18,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B18,NMC!B:E,4,FALSE))","v":""},"i\nPage 32","i",null,"a\na"]
[{"$f":"VLOOKUP(B19,NMC!$B$12:$D$20,3,FALSE)","v":0},5,"5. Elimination of CSOs during dry weather",{"$f":"IF(ISBLANK(VLOOKUP(B19,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B19,NMC!B:E,4,FALSE))","v":""},"i\nPage 35","i",null,"a\na"]
[{"$f":"VLOOKUP(B20,NMC!$B$12:$D$20,3,FALSE)","v":0},6,"6. Control of solid and floatable materials in CSOs",{"$f":"IF(ISBLANK(VLOOKUP(B20,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B20,NMC!B:E,4,FALSE))","v":""},"i\nPage 40","i",null,"a\na"]
[{"$f":"VLOOKUP(B21,NMC!$B$12:$D$20,3,FALSE)","v":0},7,"7. Pollution prevention programs to reduce containments in CSOs",{"$f":"IF(ISBLANK(VLOOKUP(B21,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B21,NMC!B:E,4,FALSE))","v":""},"i\nPage 54","i",null,"a\na"]
[{"$f":"VLOOKUP(B22,NMC!$B$12:$D$20,3,FALSE)","v":0},8,"8. Public notification to ensure that the public receives adequate notification of CSO occurrences and CSO impacts",{"$f":"IF(ISBLANK(VLOOKUP(B22,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B22,NMC!B:E,4,FALSE))","v":""},"i\nPage 60","i",null,"a\na"]
[{"$f":"VLOOKUP(B23,NMC!$B$12:$D$20,3,FALSE)","v":0},9,"9. Monitoring to effectively characterize CSO impacts and the efficacy of CSO controls",{"$f":"IF(ISBLANK(VLOOKUP(B23,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B23,NMC!B:E,4,FALSE))","v":""},"i\nPage 63","i",null,"a\na"]
[{"$f":"IF(ISBLANK(NMC!$C$23),\"NAC\",\"Yes\")","v":"NAC"},null,"Additional Considerations - Nine Minimum Controls"]
[{"$f":"IF(ISBLANK(NMC!$C$23),\"NAC\",\"Yes\")","v":"NAC"},null,{"$f":"IF(ISBLANK(NMC!$C$23),\"\",NMC!$C$23)","v":""}]
["Yes",null,"General System Characterization"]
[{"$f":"VLOOKUP(B27,SystChar!B:H,3,FALSE)","v":0},"MC1","Major Question: Has the permittee collected and presented existing information and data on the CSS and receiving waters in a format that is understandable and consistent with the CSO Control Policy and guidance? If no, briefly describe what the permittee can do to improve the quality of their submittal.",{"$f":"IF(ISBLANK(VLOOKUP(B27,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B27,SystChar!B:E,4,FALSE))","v":""},"i\nPage 34",null,null,"a\na"]
[{"$f":"VLOOKUP(B28,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B14","v":10},"Is the location provided for the major interceptors and each CSO outfall (latitude/longitude or street address) and identified on a map?",{"$f":"IF(ISBLANK(VLOOKUP(B28,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B28,SystChar!B:E,4,FALSE))","v":""},null,null,null,"a\na"]
[{"$f":"VLOOKUP(B29,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B15","v":11},"Are the identified CSO outfalls consistent with the existing permit?",{"$f":"IF(ISBLANK(VLOOKUP(B29,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B29,SystChar!B:E,4,FALSE))","v":""},null,null,null,"a\na"]
[{"$f":"VLOOKUP(B30,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B16","v":12},"Have the CSS area and its sewersheds been delineated?",{"$f":"IF(ISBLANK(VLOOKUP(B30,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B30,SystChar!B:E,4,FALSE))","v":""},"i\nPage 40",null,null,"a\na"]
[{"$f":"VLOOKUP(B31,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B17","v":13},"Have land use and estimated impervious cover been provided for each sewershed? If only land use or impervious cover is missing, please provide additional detail in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B31,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B31,SystChar!B:E,4,FALSE))","v":""},"i\nPage 40",null,null,"a\na"]
[{"$f":"VLOOKUP(B32,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B18","v":14},"Are the principal hydraulic control structures identified on a map (e.g., interceptors; regulators; pump stations; storage and controls facilities; POTW)?  If no, indicate which items are missing in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B32,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B32,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42",null,null,"a\na"]
[{"$f":"VLOOKUP(B33,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B19","v":15},"Are POTW capacities (e.g., primary and secondary; average and peak) specified?",{"$f":"IF(ISBLANK(VLOOKUP(B33,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B33,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42","i\nPage 33",null,"a\na"]
[{"$f":"VLOOKUP(B34,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B20","v":16},"Are dry weather sanitary flow (baseflow) estimates or patterns presented?",{"$f":"IF(ISBLANK(VLOOKUP(B34,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B34,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42","i\nPage 33",null,"a\na"]
[{"$f":"VLOOKUP(B35,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B21","v":17},"Are wastewater flows to the CSS from neighboring or satellite communities identified and quantified, if present? If no neighboring or satellite communities are present, indicate this in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B35,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B35,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42",null,null,"a\na"]
[{"$f":"VLOOKUP(B36,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B22","v":18},"Are any existing flow metering or SCADA records described? If there is no flow metering or SCADA system in place, indicate this in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B36,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B36,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42",null,null,"a\na"]
[{"$f":"VLOOKUP(B37,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B23","v":19},"Are chronic problem areas or bottlenecks within the CSS described? If the CSS has been well characterized and there are no known problem areas, indicate this in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B37,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B37,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42",null,null,"a\na"]
[{"$f":"VLOOKUP(B38,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B24","v":20},"Did the permittee identify significant industrial users within the CSS service area? If there are no significant industrial users within the CSS service area, indicate this in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B38,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B38,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42",null,null,"a\na"]
[{"$f":"VLOOKUP(B39,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B26","v":21},"Are all of the CSO-impacted waters identified?",{"$f":"IF(ISBLANK(VLOOKUP(B39,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B39,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,"a\na"]
[{"$f":"VLOOKUP(B40,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B27","v":22},"Is the available information on stream flow or tidal conditions, water quality and sediment in the receiving water(s) summarized and presented?",{"$f":"IF(ISBLANK(VLOOKUP(B40,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B40,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,"a\na"]
[{"$f":"VLOOKUP(B41,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B28","v":23},"Are the pollutants of concern identified for each receiving water?",{"$f":"IF(ISBLANK(VLOOKUP(B41,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B41,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,"a\na"]
[{"$f":"VLOOKUP(B42,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B29","v":24},"Does the characterization provide information on the known effects of the CSOs on water quality during wet weather events?",{"$f":"IF(ISBLANK(VLOOKUP(B42,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B42,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,"a\na"]
[{"$f":"VLOOKUP(B43,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B30","v":25},"Are the current water quality standards and existing and designated uses of each receiving water identified?",{"$f":"IF(ISBLANK(VLOOKUP(B43,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B43,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,"a\na"]
[{"$f":"VLOOKUP(B44,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B31","v":26},"Is there information on whether the designated uses are currently being met?",{"$f":"IF(ISBLANK(VLOOKUP(B44,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B44,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,"a\na"]
[{"$f":"VLOOKUP(B45,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B32","v":27},"Are any known impairments attributable to CSOs identified for the receiving waters (303(d) list, 305(b) list, fish kills, beach closures, etc.)?",{"$f":"IF(ISBLANK(VLOOKUP(B45,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B45,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,"a\na"]
[{"$f":"VLOOKUP(B46,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B33","v":28},"If a TMDL has been or will be developed, does the permittee consider the TMDL in the LTCP?",{"$f":"IF(ISBLANK(VLOOKUP(B46,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B46,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,"a\na"]
[{"$f":"VLOOKUP(B47,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B34","v":29},"Is the presence or absence of sensitive areas determined and documented?",{"$f":"IF(ISBLANK(VLOOKUP(B47,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B47,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44","i\nPage 30",null,"a\na"]
[{"$f":"VLOOKUP(B48,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B35","v":30},"Are sensitive areas present?",{"$f":"IF(ISBLANK(VLOOKUP(B48,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B48,SystChar!B:E,4,FALSE))","v":""},"i\nPage 30","i\nPage 125",null,"a\na"]
[{"$f":"VLOOKUP(B49,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B36","v":31},{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"Have CSO outfalls located in sensitive areas been identified?\",\"Sensitive Areas Question - Not Applicable\")","v":"Have CSO outfalls located in sensitive areas been identified?"},{"$f":"IF(ISBLANK(VLOOKUP(B49,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B49,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44","i\nPage 30",null,"a\na"]
[{"$f":"VLOOKUP(B50,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B37","v":32},"Was the available information on pollutant loadings, from other point and nonpoint sources in the watershed, identified and compiled? If there are known sources of information on pollutant loadings that are missing, describe these in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B50,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B50,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,"a\na"]
[{"$f":"VLOOKUP(B51,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B39","v":33},"Are long-term rainfall records and annual average conditions identified and evaluated? If incomplete, describe how evaluation of rainfall conditions could be improved in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B51,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B51,SystChar!B:E,4,FALSE))","v":""},"i\nPage 59",null,null,"a\na"]
[{"$f":"VLOOKUP(B52,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B40","v":34},"Does the permittee demonstrate an adequate understanding of the rainfall conditions that cause CSO events at each outfall? If not, describe how they can improve their understanding of conditions that cause CSO events in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B52,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B52,SystChar!B:E,4,FALSE))","v":""},"i\nPage 59",null,null,"a\na"]
["Yes",null,"Characterization of Collection System and Receiving Waters Monitoring"]
[{"$f":"VLOOKUP(B54,SystChar!B:H,3,FALSE)","v":0},"MC2","Major Question: Does the monitoring program document the frequency and magnitude of CSO events, associated impacts, and inform the evaluation and selection of CSO controls?",{"$f":"IF(ISBLANK(VLOOKUP(B54,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B54,SystChar!B:E,4,FALSE))","v":""},"i\nPage 53",null,null,"a\na"]
[{"$f":"VLOOKUP(B55,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B44","v":35},"Are data available for a range of storms to characterize the hydraulic response of the CSS, including frequency, volume and flow rate, and pollutant loads from CSOs at major or representative outfalls?",{"$f":"IF(ISBLANK(VLOOKUP(B55,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B55,SystChar!B:E,4,FALSE))","v":""},"i\nPage 57",null,null,"a\na"]
[{"$f":"VLOOKUP(B56,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B45","v":36},"Does the LTCP present estimated concentrations of the pollutants discharged and reasonable justification (compiled through sampling, from literature values, or with values from other CSO studies)? If concentrations are presented but justification is not provided, indicate required revisions in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B56,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B56,SystChar!B:E,4,FALSE))","v":""},"i\nPage 58",null,null,"a\na"]
[{"$f":"VLOOKUP(B57,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B46","v":37},"Was rainfall data collected within the CSS during the flow monitoring periods?",{"$f":"IF(ISBLANK(VLOOKUP(B57,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B57,SystChar!B:E,4,FALSE))","v":""},"i\nPage 59",null,null,"a\na"]
[{"$f":"VLOOKUP(B58,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B47","v":38},"Does the flow monitoring data portray the hydraulic response of the CSS to rainfall? If no, describe any deficiencies in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B58,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B58,SystChar!B:E,4,FALSE))","v":""},"i\nPage 60",null,null,"a\na"]
[{"$f":"VLOOKUP(B59,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B48","v":39},"Is the monitoring program able to evaluate the effectiveness of any control measures implemented as part of the NMC? If no, describe any specific improvements that can be made in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B59,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B59,SystChar!B:E,4,FALSE))","v":""},"i\nPage 62",null,null,"a\na"]
[{"$f":"VLOOKUP(B60,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B49","v":40},"If one CSO outfall is selected to represent a subset of CSO outfalls, did the LTCP provide a justification for that selection?",{"$f":"IF(ISBLANK(VLOOKUP(B60,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B60,SystChar!B:E,4,FALSE))","v":""},"i\nPage 74"]
[{"$f":"VLOOKUP(B61,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B51","v":41},"Does the monitoring program take into account the type (e.g., free flowing, tidal) and physical characteristics of the receiving water? ",{"$f":"IF(ISBLANK(VLOOKUP(B61,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B61,SystChar!B:E,4,FALSE))","v":""},"i\nPage 65",null,null,"a\na"]
[{"$f":"VLOOKUP(B62,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B52","v":42},"Is there information on the impact of CSO pollutant loadings on the receiving waters for the water quality parameters of concern? (Typically bacteria, BOD and TSS)",{"$f":"IF(ISBLANK(VLOOKUP(B62,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B62,SystChar!B:E,4,FALSE))","v":""},"i\nPage 65",null,null,"a\na"]
[{"$f":"VLOOKUP(B63,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B53","v":43},"Does the monitoring document pre-control baseline conditions, to allow the permittee to demonstrate the long-term benefits of CSO controls? If no, describe any specific improvements that can be made to the monitoring program in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B63,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B63,SystChar!B:E,4,FALSE))","v":""},"i\nPage 62",null,null,"a\na"]
[{"$f":"VLOOKUP(B64,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B54","v":44},"Does the monitoring program include adequate spatial and temporal coverage during wet weather conditions to support an evaluation of the impacts associated with CSOs? If no, describe any specific improvements that can be made to the monitoring program in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B64,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B64,SystChar!B:E,4,FALSE))","v":""},"i\nPage 55",null,null,"a\na"]
[{"$f":"VLOOKUP(B65,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B55","v":45},"Do monitoring results show that water quality standards and designated uses are not met in part because of other sources of pollutants, such as stormwater and upstream sources? Provide documentation for the assessment of other sources and associated monitoring results.",{"$f":"IF(ISBLANK(VLOOKUP(B65,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B65,SystChar!B:E,4,FALSE))","v":""},"i\nPage 55",null,null,"a\na"]
[{"$f":"VLOOKUP(B66,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B56","v":46},"Does the monitoring consider the appropriate range of possible CSO impacts on receiving waters based on the concerns of the local community? (Typically bacteria and floatables; sometimes dissolved oxygen, metals, or nutrients)",{"$f":"IF(ISBLANK(VLOOKUP(B66,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B66,SystChar!B:E,4,FALSE))","v":""},"i\nPage 65",null,null,"a\na"]
["Yes",null,"Characterization of Collection System and Receiving Waters Modeling"]
[{"$f":"VLOOKUP(B68,SystChar!B:H,3,FALSE)","v":0},"MC3","Major Question: Has the permittee developed, calibrated, and verified a model of the collection system and/or receiving water, as appropriate, that is able to support the evaluation and selection of CSO controls given the complexity of the CSS?",{"$f":"IF(ISBLANK(VLOOKUP(B68,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B68,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,"a\na"]
[{"$f":"VLOOKUP(B69,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B60","v":47},"Has some type of model (e.g., spreadsheet, SWMM, HydroWorks, etc.) been developed to assess the response of the CSS to different rainfall conditions with respect to CSO volume, frequency and peak overflow rate?",{"$f":"IF(ISBLANK(VLOOKUP(B69,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B69,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,"a\na"]
[{"$f":"VLOOKUP(B70,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B61","v":48},"Does the selected CSS model framework address the engineering and regulatory needs of the LTCP? If no, provide suggestions on how the model framework can be improved in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B70,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B70,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,"a\na"]
[{"$f":"VLOOKUP(B71,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B62","v":49},"Is the level of detail of the CSS model consistent with and representative of the complexity of the CSS? If no, provide suggestions on how the level of detail can be improved in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B71,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B71,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,"a\na"]
[{"$f":"VLOOKUP(B72,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B63","v":50},"Are flow and effluent concentration data available to calibrate the model? (e.g., 8 - 10 storms covering a range of annual storm sizes)",{"$f":"IF(ISBLANK(VLOOKUP(B72,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B72,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,"a\na"]
[{"$f":"VLOOKUP(B73,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B64","v":51},"Is the model credible? That is, has the model been documented, calibrated and verified to demonstrate that it represents observed behavior (in terms of CSO volume, duration, frequency, and peak overflow rate) over a variety of rainfall events? If no, describe the deficiencies in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B73,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B73,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,"a\na"]
[{"$f":"VLOOKUP(B74,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B66","v":52},"Has some type of model been developed to assess the response of receiving waters to external CSO loads?",{"$f":"IF(ISBLANK(VLOOKUP(B74,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B74,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,"a\na"]
[{"$f":"VLOOKUP(B75,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B67","v":53},"Is the level of detail of the water quality model(s) relatively consistent with and representative of the complexity of the receiving waters? If no, please describe any improvements that can be made in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B75,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B75,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,"a\na"]
[{"$f":"VLOOKUP(B76,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B68","v":54},"Is the model credible? That is, has the model been documented, calibrated and verified to demonstrate that it generally represents the major processes affecting water quality for the pollutants of concern? If no, describe any deficiencies in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B76,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B76,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,"a\na"]
[{"$f":"VLOOKUP(B77,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B69","v":55},"Do modeling results show that water quality standards and designated uses are not met in part because of other sources of pollutants, such as stormwater and upstream sources? Provide documentation for the assessment of other sources and associated modeling results. ",{"$f":"IF(ISBLANK(VLOOKUP(B77,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B77,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,"a\na"]
[{"$f":"IF(ISBLANK(SystChar!$C$72),\"NAC\",\"Yes\")","v":"NAC"},null,"Additional Considerations - System Characterization"]
[{"$f":"IF(ISBLANK(SystChar!$C$72),\"NAC\",\"Yes\")","v":"NAC"},null,{"$f":"IF(ISBLANK(SystChar!$C$72),\"\",SystChar!$C$72)","v":""}]
["Yes",null,"Development and Evaluation of CSO Control Alternatives"]
[{"$f":"VLOOKUP(B81,Alternatives!B:H,3,FALSE)","v":0},"MC4","Major Question: Has the permittee evaluated CSO control alternatives to select a cost-effective CSO control plan to meet water quality standards and protect designated uses?",{"$f":"IF(ISBLANK(VLOOKUP(B81,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B81,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 98",null,null,"a\na"]
[{"$f":"VLOOKUP(B82,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B14","v":56},"Has the permittee organized the evaluation of controls in a technical framework and approach that is understandable and consistent with the CSO Control Policy and EPA guidance? If no, list any specific recommendations for improvement in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B82,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B82,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 100",null,null,"a\na"]
[{"$f":"VLOOKUP(B83,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B15","v":57},"Has the permittee identified whether the presumption approach, the demonstration approach or some combination of the two is being used? ",{"$f":"IF(ISBLANK(VLOOKUP(B83,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B83,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 100",null,null,"a\na"]
[{"$f":"VLOOKUP(B84,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B17","v":58},"Has the permittee considered a range of control technology within the general categories of source controls, collection system controls, storage technologies and treatment technologies? If only a partial range has been considered, note any suggested improvements in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B84,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B84,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 126",null,null,"a\na"]
[{"$f":"VLOOKUP(B85,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B18","v":59},"Has the permittee evaluated a full range of potential controls with respect to meeting water quality standards and protecting designated uses? (A full range should include zero overflow events per year, and averages of 1 to 3, 4 to 7, and 8 to 12 overflow events per year)",{"$f":"IF(ISBLANK(VLOOKUP(B85,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B85,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 115",null,null,"a\na"]
[{"$f":"VLOOKUP(B86,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B19","v":60},"Does the LTCP describe the process by which the CSO control and alternatives combinations were developed?",{"$f":"IF(ISBLANK(VLOOKUP(B86,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B86,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 115",null,null,"a\na"]
[{"$f":"VLOOKUP(B87,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B20","v":61},"Does the LTCP describe the approach used to screen and narrow the list of CSO control technologies, and list the screening criteria?",{"$f":"IF(ISBLANK(VLOOKUP(B87,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B87,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 115",null,null,"a\na"]
[{"$f":"VLOOKUP(B88,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B21","v":62},"Does the LTCP explain the reasons for selecting certain CSO controls?",{"$f":"IF(ISBLANK(VLOOKUP(B88,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B88,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 115",null,null,"a\na"]
[{"$f":"VLOOKUP(B89,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B22","v":63},"Have the NMC been integrated into the permittee’s description of the selected CSO controls?",{"$f":"IF(ISBLANK(VLOOKUP(B89,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B89,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 116",null,null,"a\na"]
[{"$f":"VLOOKUP(B90,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B23","v":64},"Has the permittee maximized treatment at the existing POTW for wet weather flows, and considered expansion of primary and secondary treatment capacity? Primary treatment is defined in CWA Section 301(h)(9).",{"$f":"IF(ISBLANK(VLOOKUP(B90,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B90,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 123",null,null,"a\na"]
[{"$f":"VLOOKUP(B91,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B24","v":65},"Has a cost/performance (knee of the curve) analysis been developed for the control alternatives considered?",{"$f":"IF(ISBLANK(VLOOKUP(B91,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B91,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 138",null,null,"a\na"]
[{"$f":"IF(SystChar!$D$35=\"No\",\"No SA\",VLOOKUP(B92,Alternatives!B:H,3,FALSE))","v":0},{"$f":"Alternatives!B25","v":66},{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"Has the permittee given the control of CSO discharges to sensitive areas a high priority?\",\"Sensitive Areas Question - Not Applicable\")","v":"Has the permittee given the control of CSO discharges to sensitive areas a high priority?"},{"$f":"IF(ISBLANK(VLOOKUP(B92,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B92,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 125",null,null,"a\na"]
[{"$f":"IF(SystChar!$D$35=\"No\",\"No SA\",VLOOKUP(B93,Alternatives!B:H,3,FALSE))","v":0},{"$f":"Alternatives!B26","v":67},{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"If sensitive areas are impacted, will the selected CSO controls eliminate all CSO impacts on sensitive areas? If sensitive areas are not impacted, indicate this in the notes column to the right.\",\"Sensitive Areas Question - Not Applicable\")","v":"If sensitive areas are impacted, will the selected CSO controls eliminate all CSO impacts on sensitive areas? If sensitive areas are not impacted, indicate this in the notes column to the right."},{"$f":"IF(ISBLANK(VLOOKUP(B93,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B93,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 125",null,null,"a\na"]
[{"$f":"IF(SystChar!$D$35=\"No\",\"No SA\",VLOOKUP(B94,Alternatives!B:H,3,FALSE))","v":0},{"$f":"Alternatives!B27","v":68},{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"If not, do the data support the permittee’s apparent conclusion that elimination is not physically possible or economically achievable? If this question does not apply, indicate this in the notes column to the right. \",\"Sensitive Areas Question - Not Applicable\")","v":"If not, do the data support the permittee’s apparent conclusion that elimination is not physically possible or economically achievable? If this question does not apply, indicate this in the notes column to the right. "},{"$f":"IF(ISBLANK(VLOOKUP(B94,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B94,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 118","i\nPage 30",null,"a\na"]
[{"$f":"IF(SystChar!$D$35=\"No\",\"No SA\",VLOOKUP(B95,Alternatives!B:H,3,FALSE))","v":0},{"$f":"Alternatives!B28","v":69},{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"If CSO discharges to sensitive areas remain, will these CSOs receive treatment?\",\"Sensitive Areas Question - Not Applicable\")","v":"If CSO discharges to sensitive areas remain, will these CSOs receive treatment?"},{"$f":"IF(ISBLANK(VLOOKUP(B95,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B95,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 135","i\nPage 30",null,"a\na"]
[{"$f":"VLOOKUP(B96,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B29","v":70},"Will the selected CSO controls provide the treatment of floatables and settleable solids equivalent to that achieved by primary clarification?",{"$f":"IF(ISBLANK(VLOOKUP(B96,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B96,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 135","i\nPage 30",null,"a\na"]
[{"$f":"VLOOKUP(B97,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B30","v":71},"Does the LTCP demonstrate whether or not disinfection of effluent will be necessary based on applicable water quality standards?",{"$f":"IF(ISBLANK(VLOOKUP(B97,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B97,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 135","i\nPage 104",null,"a\na"]
[{"$f":"VLOOKUP(B98,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B32","v":72},"Is the permittee implementing green infrastructure?",{"$f":"IF(ISBLANK(VLOOKUP(B98,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B98,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 7"]
[{"$f":"VLOOKUP(B99,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B33","v":73},{"$f":"IF(Alternatives!D32=\"No\",\"Green Infrastructure Question - Not Applicable\",\"Did the permittee implement green infrastructure in response to requirements of an enforceable mechanism such as an NPDES permit and/or an enforcement order?\")","v":"Did the permittee implement green infrastructure in response to requirements of an enforceable mechanism such as an NPDES permit and/or an enforcement order?"},{"$f":"IF(ISBLANK(VLOOKUP(B99,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B99,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 12"]
[{"$f":"VLOOKUP(B100,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B34","v":74},{"$f":"IF(Alternatives!D32=\"No\",\"Green Infrastructure Question - Not Applicable\",\"Did the permittee determine the volume of runoff expected to be controlled by green infrastructure in a well-documented and verifiable way?\")","v":"Did the permittee determine the volume of runoff expected to be controlled by green infrastructure in a well-documented and verifiable way?"},{"$f":"IF(ISBLANK(VLOOKUP(B100,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B100,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 20"]
[{"$f":"VLOOKUP(B101,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B36","v":75},"Is information provided to show that CSO discharges remaining after implementation of the planned control program will not cause or contribute to the non-attainment of water quality standards or existing uses?",{"$f":"IF(ISBLANK(VLOOKUP(B101,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B101,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 118",null,null,"a\na"]
[{"$f":"VLOOKUP(B102,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B37","v":76},"If water quality standards cannot be met because of CSO discharges that remain after implementation of the planned control program, has the permittee shown any one of the six factors specified under 40 CFR 131.10(g) preclude the attainment of use as determined through the use attainability analysis (UAA) (40 CFR 131.10(j)) to justify a water quality standards review?",{"$f":"IF(ISBLANK(VLOOKUP(B102,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B102,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 118","i",null,"a\na"]
[{"$f":"VLOOKUP(B103,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B38","v":77},"Has it been demonstrated that there may be removal of designated uses based on 40 CFR 131.10 (g) and (h)? ",{"$f":"IF(ISBLANK(VLOOKUP(B103,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B103,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 118","i",null,"a\na"]
[{"$f":"VLOOKUP(B104,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B39","v":78},"If water quality standards cannot be met because of sources other than CSOs, are the other limiting sources and natural background conditions documented?",{"$f":"IF(ISBLANK(VLOOKUP(B104,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B104,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 118",null,null,"a\na"]
[{"$f":"VLOOKUP(B105,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B41","v":79},"Is the LTCP monitoring being coordinated with other municipal efforts, or ongoing or planned state programs, within the same watershed?",{"$f":"IF(ISBLANK(VLOOKUP(B105,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B105,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 22",null,null,"a\na"]
[{"$f":"VLOOKUP(B106,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B42","v":80},"Has LTCP development been coordinated with watershed or TMDL efforts?",{"$f":"IF(ISBLANK(VLOOKUP(B106,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B106,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 22",null,null,"a\na"]
[{"$f":"VLOOKUP(B107,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B44","v":81},"Has an assessment of the financial resources available for the implementation of CSO controls been completed following the general guidelines in Section 3.5 of EPA's Guidance for LTCP? If no, describe any recommended improvements in the notes column to the right. (Financial indicators include such factors as total annual wastewater and CSO control cost per household; unemployment rate; median household income; property tax revenue collection rate)",{"$f":"IF(ISBLANK(VLOOKUP(B107,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B107,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 163",null,null,"a\na"]
["Yes",null,"Public Participation"]
[{"$f":"VLOOKUP(B109,Alternatives!$B:$H,3,FALSE)","v":0},"MC5","Major Question: Does the LTCP document the process used to inform the public about the alternatives for CSO control and engage them in the decision process?",{"$f":"IF(ISBLANK(VLOOKUP(B109,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B109,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 98","i\nPage 177",null,"a\na"]
[{"$f":"VLOOKUP(B110,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B48","v":82},"Did the public participation process actively involve the affected public including rate payers, industrial users of the CSS, persons near impacted waters, and persons who use the impacted waters?",{"$f":"IF(ISBLANK(VLOOKUP(B110,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B110,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 98","i\nPage 177",null,"a\na"]
[{"$f":"VLOOKUP(B111,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B49","v":83},"Does LTCP include a record of the public participation events, including the number of people attending and a record or summary of participant comments?",{"$f":"IF(ISBLANK(VLOOKUP(B111,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B111,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 98","i\nPage 177",null,"a\na"]
[{"$f":"VLOOKUP(B112,Alternatives!$B:$H,3,FALSE)","v":0},{"$f":"Alternatives!B50","v":84},"Does the LTCP document decisions or changes made in response to public comments?",{"$f":"IF(ISBLANK(VLOOKUP(B112,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B112,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 98","i\nPage 177",null,"a\na"]
[{"$f":"IF(ISBLANK(Alternatives!$C$53),\"NAC\",\"Yes\")","v":"NAC"},null,"Additional Considerations - Alternatives Evaluation"]
[{"$f":"IF(ISBLANK(Alternatives!$C$53),\"NAC\",\"Yes\")","v":"NAC"},null,{"$f":"IF(ISBLANK(Alternatives!$C$53),\"\",Alternatives!$C$53)","v":""}]
["Yes",null,"Selection of Controls and Implementation"]
[{"$f":"VLOOKUP(B116,Implementation!$B$12:$E$33,3,FALSE)","v":0},"MC6","Major Question: Does the LTCP document a reasonable process for evaluating a range of controls and selecting a suite of CSO controls sufficient to meet water quality standards and designated and existing uses?",{"$f":"IF(ISBLANK(VLOOKUP(B116,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B116,Implementation!B:E,4,FALSE))","v":""},"i\nPage 98",null,null,"a\na"]
[{"$f":"VLOOKUP(B117,Implementation!$B$12:$E$33,3,FALSE)","v":0},{"$f":"Implementation!B14","v":85},"Does the LTCP document benefits derived from implementation of the NMC?",{"$f":"IF(ISBLANK(VLOOKUP(B117,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B117,Implementation!B:E,4,FALSE))","v":""},"i\nPage 116",null,null,"a\na"]
[{"$f":"VLOOKUP(B118,Implementation!$B$12:$E$33,3,FALSE)","v":0},{"$f":"Implementation!B16","v":86},"Does the LTCP document the controls selected for implementation, including detailed descriptions, preliminary engineering analysis, and cost estimates? If specific items are missing, list them in the notes section to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B118,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B118,Implementation!B:E,4,FALSE))","v":""},"i\nPage 180",null,null,"a\na"]
[{"$f":"VLOOKUP(B119,Implementation!$B$12:$E$33,3,FALSE)","v":0},{"$f":"Implementation!B17","v":87},"Has the selected alternative been shown to be adequate, or reasonable to presume adequate, to provide for the attainment of applicable water quality standards and the protection of existing and designated uses?",{"$f":"IF(ISBLANK(VLOOKUP(B119,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B119,Implementation!B:E,4,FALSE))","v":""},"i\nPage 180",null,null,"a\na"]
[{"$f":"VLOOKUP(B120,Implementation!$B$12:$E$33,3,FALSE)","v":0},{"$f":"Implementation!B19","v":88},"Does the LTCP recommend a financing approach demonstrating how the permittee will finance the alternative selected; identifying a specific capital and annual cost funding approach?",{"$f":"IF(ISBLANK(VLOOKUP(B120,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B120,Implementation!B:E,4,FALSE))","v":""},"i\nPage 182",null,null,"a\na"]
[{"$f":"VLOOKUP(B121,Implementation!$B$12:$E$33,3,FALSE)","v":0},{"$f":"Implementation!B20","v":89},"Did the permittee evaluate funding through increased sewer user fees and rate structures for residential, commercial and industrial  users?",{"$f":"IF(ISBLANK(VLOOKUP(B121,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B121,Implementation!B:E,4,FALSE))","v":""},"i\nPage 182",null,null,"a\na"]
[{"$f":"VLOOKUP(B122,Implementation!$B$12:$E$33,3,FALSE)","v":0},{"$f":"Implementation!B21","v":90},"Did the permittee evaluate grant and loan availability and other sources of financing?",{"$f":"IF(ISBLANK(VLOOKUP(B122,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B122,Implementation!B:E,4,FALSE))","v":""},"i\nPage 182",null,null,"a\na"]
[{"$f":"VLOOKUP(B123,Implementation!$B$12:$E$33,3,FALSE)","v":0},{"$f":"Implementation!B23","v":91},"Are the implementation phases of the LTCP consistent with permittee’s available resources and the priorities for eliminating the CSO-induced impairment? If no, provide specific recommendations for the permittee to improve their implementation schedule in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B123,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B123,Implementation!B:E,4,FALSE))","v":""},"i\nPage 185",null,null,"a\na"]
[{"$f":"IF(SystChar!$D$35=\"No\",\"No SA\",VLOOKUP(B124,Implementation!$B$12:$E$33,3,FALSE))","v":0},{"$f":"Implementation!B24","v":92},{"$f":"IF(OR(SystChar!$D$35=\"Yes\",SystChar!$D$35=\"\"),\"If sensitive areas are present and impacted by CSOs, has the permittee given the control of CSO discharges to sensitive areas a high priority?\",\"Sensitive Areas Question - Not Applicable\")","v":"If sensitive areas are present and impacted by CSOs, has the permittee given the control of CSO discharges to sensitive areas a high priority?"},{"$f":"IF(ISBLANK(VLOOKUP(B124,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B124,Implementation!B:E,4,FALSE))","v":""},"i\nPage 185",null,null,"a\na"]
[{"$f":"VLOOKUP(B125,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B26","v":93},"Does the LTCP document how the current operational plan for the CSS will be developed/revised to include the operational and maintenance needs of the controls selected for implementation?",{"$f":"IF(ISBLANK(VLOOKUP(B125,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B125,Implementation!B:E,4,FALSE))","v":""},"i\nPage 189","i",null,"a\na"]
[{"$f":"VLOOKUP(B126,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B27","v":94},"Does the operational plan include sampling and maintenance schedules?",{"$f":"IF(ISBLANK(VLOOKUP(B126,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B126,Implementation!B:E,4,FALSE))","v":""},"i\nPage 189","i"]
[{"$f":"VLOOKUP(B127,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B28","v":95},"Does the operational plan identify staffing needs?",{"$f":"IF(ISBLANK(VLOOKUP(B127,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B127,Implementation!B:E,4,FALSE))","v":""},"i\nPage 189","i"]
[{"$f":"VLOOKUP(B128,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B30","v":96},"Does the monitoring program verify compliance with water quality standards and protection of designated uses?",{"$f":"IF(ISBLANK(VLOOKUP(B128,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B128,Implementation!B:E,4,FALSE))","v":""},"i\nPage 191"]
[{"$f":"VLOOKUP(B129,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B31","v":97},"Does the monitoring plan include 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(B129,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B129,Implementation!B:E,4,FALSE))","v":""},"i\nPage 191"]
[{"$f":"VLOOKUP(B130,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B32","v":98},"Does the LTCP describe how and when post-construction monitoring will be conducted and how the results will be reported? If no, provide suggestions on how to improve post construction monitoring and reporting in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B130,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B130,Implementation!B:E,4,FALSE))","v":""},"i\nPage 191",null,null,"a\na"]
[{"$f":"VLOOKUP(B131,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B33","v":99},"Does the post-construction compliance monitoring program include adequate spatial and temporal coverage during wet weather conditions to assess the effectiveness of CSO controls and improvement from pre-control baseline conditions associated with LTCP implementation? Provide suggestions on how to improve the monitoring program in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B131,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B131,Implementation!B:E,4,FALSE))","v":""},"i\nPage 191",null,null,"a\na"]
[{"$f":"IF(ISBLANK(Implementation!$C$36),\"NAC\",\"Yes\")","v":"NAC"},null,"Additional Considerations - LTCP Implementation"]
[{"$f":"IF(ISBLANK(Implementation!$C$36),\"NAC\",\"Yes\")","v":"NAC"},null,{"$f":"IF(ISBLANK(Implementation!$C$36),\"\",Implementation!$C$36)","v":""}]
["Button: Go to the previous page"]
["Button: Go to the next page"]

{"sheet":"O. Items","index":7,"n_rows":134,"n_cols":8,"rows_kept":134,"cut":false,"hidden":false,"merged":[[51,2,51,6],[76,2,76,6],[111,2,111,6],[131,2,131,5],[12,4,12,6],[1,2,1,6],[130,2,130,6],[24,2,24,5],[77,2,77,5],[112,2,112,5],[23,2,23,6],[25,2,25,6],[13,2,13,6],[113,2,113,6],[106,2,106,6],[78,2,78,6],[65,2,65,6]]}
["6. 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,"Long-Term Control Plan (LTCP) Review Checklist"]
["Button: Go to the Getting Started page"]
["Button: Go to the 1. Nine Minimum Controls page"]
["Button: Go to the 2. System Characterization page"]
["Button: Go to the 3. Alternatives Evaluation page"]
["Button: Go to the 4. LTCP Implementation page"]
["Button: Go to the 5. Addressed Items page"]
[]
["Button: Press enter to see Recommendations"]
[]
[]
[null,null,"List of recommendations to improve the LTCP. The recommendations are generated based on questions responded to with a \"No.\"","Additional notes provided here.","Helpful\nResources"]
["No",null,"Nine Minimum Controls",null,null,null,null,0]
[{"$f":"VLOOKUP(B15,NMC!$B$12:$D$20,3,FALSE)","v":0},1,"Document implementation of NMC 1: Proper operation and regular maintenance programs for the sewer system and CSO outfalls",{"$f":"IF(ISBLANK(VLOOKUP(B15,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B15,NMC!B:E,4,FALSE))","v":""},"i\nPage 18","i",null,"a\na"]
[{"$f":"VLOOKUP(B16,NMC!$B$12:$D$20,3,FALSE)","v":0},2,"Document implementation of NMC 2: Maximum use of the collection system for storage",{"$f":"IF(ISBLANK(VLOOKUP(B16,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B16,NMC!B:E,4,FALSE))","v":""},"i\nPage 24","i",null,"a\na"]
[{"$f":"VLOOKUP(B17,NMC!$B$12:$D$20,3,FALSE)","v":0},3,"Document implementation of NMC 3: Review and modification of pretreatment requirements to ensure that CSO impacts are minimized",{"$f":"IF(ISBLANK(VLOOKUP(B17,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B17,NMC!B:E,4,FALSE))","v":""},"i\nPage 28","i",null,"a\na"]
[{"$f":"VLOOKUP(B18,NMC!$B$12:$D$20,3,FALSE)","v":0},4,"Document implementation of NMC 4: Maximization of flow to the POTW",{"$f":"IF(ISBLANK(VLOOKUP(B18,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B18,NMC!B:E,4,FALSE))","v":""},"i\nPage 32","i",null,"a\na"]
[{"$f":"VLOOKUP(B19,NMC!$B$12:$D$20,3,FALSE)","v":0},5,"Document implementation of NMC 5: Elimination of CSOs during dry weather",{"$f":"IF(ISBLANK(VLOOKUP(B19,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B19,NMC!B:E,4,FALSE))","v":""},"i\nPage 35","i",null,"a\na"]
[{"$f":"VLOOKUP(B20,NMC!$B$12:$D$20,3,FALSE)","v":0},6,"Document implementation of NMC 6: Control of solid and floatable materials in CSOs",{"$f":"IF(ISBLANK(VLOOKUP(B20,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B20,NMC!B:E,4,FALSE))","v":""},"i\nPage 40","i",null,"a\na"]
[{"$f":"VLOOKUP(B21,NMC!$B$12:$D$20,3,FALSE)","v":0},7,"Document implementation of NMC 7: Pollution prevention programs to reduce containments in CSOs",{"$f":"IF(ISBLANK(VLOOKUP(B21,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B21,NMC!B:E,4,FALSE))","v":""},"i\nPage 54","i",null,"a\na"]
[{"$f":"VLOOKUP(B22,NMC!$B$12:$D$20,3,FALSE)","v":0},8,"Document implementation of NMC 8: Public notification to ensure that the public receives adequate notification of CSO occurrences and CSO impacts",{"$f":"IF(ISBLANK(VLOOKUP(B22,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B22,NMC!B:E,4,FALSE))","v":""},"i\nPage 60","i",null,"a\na"]
[{"$f":"VLOOKUP(B23,NMC!$B$12:$D$20,3,FALSE)","v":0},9,"Document implementation of NMC 9: Monitoring to effectively characterize CSO impacts and the efficacy of CSO controls",{"$f":"IF(ISBLANK(VLOOKUP(B23,NMC!B:E,4,FALSE)),\"\",VLOOKUP(B23,NMC!B:E,4,FALSE))","v":""},"i\nPage 63","i",null,"a\na"]
[{"$f":"IF(ISBLANK(NMC!$C$23),\"NAC\",\"No\")","v":"NAC"},null,"Additional Considerations - Nine Minimum Controls"]
[{"$f":"IF(ISBLANK(NMC!$C$23),\"NAC\",\"No\")","v":"NAC"},null,{"$f":"IF(ISBLANK(NMC!$C$23),\"\",NMC!$C$23)","v":""}]
["No",null,"General System Characterization",null,null,null,null,0]
[{"$f":"VLOOKUP(B27,SystChar!B:H,3,FALSE)","v":0},"MC1","Major Question: Revise the general collection and presentation of existing information on the CSS and receiving waters so that it is understandable and consistent with the CSO Control Policy and guidance. Specific areas of improvement should be indicated throughout this section in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B27,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B27,SystChar!B:E,4,FALSE))","v":""},"i\nPage 34",null,null,{"$f":"VLOOKUP(B27,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B28,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B14","v":10},"Provide the location of each major interceptor and CSO outfall (latitude/longitude or street address) and indicate their location on a map.",{"$f":"IF(ISBLANK(VLOOKUP(B28,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B28,SystChar!B:E,4,FALSE))","v":""},null,null,null,{"$f":"VLOOKUP(B28,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B29,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B15","v":11},"Make the necessary changes so that the location of CSO outfalls are correct in both the LTCP and the existing permit.",{"$f":"IF(ISBLANK(VLOOKUP(B29,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B29,SystChar!B:E,4,FALSE))","v":""},null,null,null,{"$f":"VLOOKUP(B29,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B30,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B16","v":12},"Delineate the CSS area and its sewersheds and illustrate these areas on a map.",{"$f":"IF(ISBLANK(VLOOKUP(B30,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B30,SystChar!B:E,4,FALSE))","v":""},"i\nPage 40",null,null,{"$f":"VLOOKUP(B30,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B31,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B17","v":13},"Provide the land use and estimated impervious cover for each sewershed. In addition to the guidance to the right, national land cover and impervious surface data can be obtained from the Multi-Resolution Land Characteristics Consortium as well as the USGS National Map.",{"$f":"IF(ISBLANK(VLOOKUP(B31,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B31,SystChar!B:E,4,FALSE))","v":""},"i\nPage 40",null,null,{"$f":"VLOOKUP(B31,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B32,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B18","v":14},"Identify the principal hydraulic control structures (e.g., interceptors, regulators, pump stations, storage and control facilities, POTW) on a map.",{"$f":"IF(ISBLANK(VLOOKUP(B32,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B32,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42",null,null,{"$f":"VLOOKUP(B32,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B33,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B19","v":15},"Specify average and peak flow capacities of the POTW, including primary and secondary, as applicable.",{"$f":"IF(ISBLANK(VLOOKUP(B33,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B33,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42","i\nPage 33",null,{"$f":"VLOOKUP(B33,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B34,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B20","v":16},"Present dry weather sanitary flow (baseflow) estimates or patterns.",{"$f":"IF(ISBLANK(VLOOKUP(B34,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B34,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42","i\nPage 33",null,{"$f":"VLOOKUP(B34,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B35,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B21","v":17},"Identify and quantify wastewater flows to the CSS from neighboring or satellite communities.",{"$f":"IF(ISBLANK(VLOOKUP(B35,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B35,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42",null,null,{"$f":"VLOOKUP(B35,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B36,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B22","v":18},"Describe any existing flow metering or SCADA records.",{"$f":"IF(ISBLANK(VLOOKUP(B36,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B36,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42",null,null,{"$f":"VLOOKUP(B36,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B37,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B23","v":19},"Describe any chronic problem areas or bottlenecks within the CSS.",{"$f":"IF(ISBLANK(VLOOKUP(B37,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B37,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42",null,null,{"$f":"VLOOKUP(B37,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B38,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B24","v":20},"Identify significant industrial users within the CSS service area.",{"$f":"IF(ISBLANK(VLOOKUP(B38,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B38,SystChar!B:E,4,FALSE))","v":""},"i\nPage 42",null,null,{"$f":"VLOOKUP(B38,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B39,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B26","v":21},"Identify all of the CSO-impacted waters.",{"$f":"IF(ISBLANK(VLOOKUP(B39,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B39,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"VLOOKUP(B39,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B40,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B27","v":22},"Summarize and present all available information on stream flow or tidal conditions, water quality and sediment in the receiving water(s). ",{"$f":"IF(ISBLANK(VLOOKUP(B40,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B40,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"VLOOKUP(B40,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B41,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B28","v":23},"Identify all pollutants of concern for each receiving water.",{"$f":"IF(ISBLANK(VLOOKUP(B41,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B41,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"VLOOKUP(B41,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B42,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B29","v":24},"Provide information on the known effects of the CSOs on water quality during wet weather events.",{"$f":"IF(ISBLANK(VLOOKUP(B42,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B42,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"VLOOKUP(B42,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B43,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B30","v":25},"Identify the current water quality standards and existing and designated uses of each receiving water.",{"$f":"IF(ISBLANK(VLOOKUP(B43,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B43,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"VLOOKUP(B43,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B44,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B31","v":26},"Indicate whether the existing designated uses are currently being met.",{"$f":"IF(ISBLANK(VLOOKUP(B44,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B44,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"VLOOKUP(B44,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B45,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B32","v":27},"Review the causes of known impairments associated with all receiving waters and note if any are attributable to CSOs. Information on impairments and their causes can be found on your state's 303(d) list or 305(b) list.",{"$f":"IF(ISBLANK(VLOOKUP(B45,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B45,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"VLOOKUP(B45,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B46,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B33","v":28},"Consider any existing or planned TMDL in the LTCP and note how it relates to the LTCP.",{"$f":"IF(ISBLANK(VLOOKUP(B46,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B46,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"VLOOKUP(B46,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B47,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B34","v":29},"Document the presence or absence of any sensitive areas.",{"$f":"IF(ISBLANK(VLOOKUP(B47,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B47,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44","i\nPage 30",null,{"$f":"VLOOKUP(B47,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B48,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B36","v":31},{"$f":"IF(SystChar!D35=\"No\",\"Sensitive Areas Question - Not Applicable\",\"Identify any CSOs that are present in sensitive areas.\")","v":"Identify any CSOs that are present in sensitive areas."},{"$f":"IF(ISBLANK(VLOOKUP(B48,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B48,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44","i\nPage 30",null,{"$f":"VLOOKUP(B48,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B49,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B37","v":32},"Identify and compile available information on pollutant loadings from other point and nonpoint sources in the watershed.",{"$f":"IF(ISBLANK(VLOOKUP(B49,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B49,SystChar!B:E,4,FALSE))","v":""},"i\nPage 44",null,null,{"$f":"VLOOKUP(B49,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B50,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B39","v":33},"Identify and evaluate long-term rainfall records and annual average conditions.",{"$f":"IF(ISBLANK(VLOOKUP(B50,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B50,SystChar!B:E,4,FALSE))","v":""},"i\nPage 59",null,null,{"$f":"VLOOKUP(B50,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B51,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B40","v":34},"Characterize the rainfall conditions that cause CSO events at each outfall.",{"$f":"IF(ISBLANK(VLOOKUP(B51,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B51,SystChar!B:E,4,FALSE))","v":""},"i\nPage 59",null,null,{"$f":"VLOOKUP(B51,SystChar!B:I,8,FALSE)","v":0}]
["No",null,"Characterization of Collection System and Receiving Waters Monitoring",null,null,null,null,0]
[{"$f":"VLOOKUP(B53,SystChar!B:H,3,FALSE)","v":0},"MC2","Major Question: Revise the monitoring program to better document the frequency and magnitude of CSO events, associated impacts, and to inform the evaluation and selection of CSO controls. Specific areas of improvement should be indicated throughout this section in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B53,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B53,SystChar!B:E,4,FALSE))","v":""},"i\nPage 53",null,null,{"$f":"VLOOKUP(B53,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B54,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B44","v":35},"Collect data for a larger range of storms to characterize the response of the CSS. Data should describe frequency, volume, flow rate, and pollutant loads from CSOs at major or representative outfalls. ",{"$f":"IF(ISBLANK(VLOOKUP(B54,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B54,SystChar!B:E,4,FALSE))","v":""},"i\nPage 57",null,null,{"$f":"VLOOKUP(B54,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B55,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B45","v":36},"Present estimated concentrations of the pollutants discharged and justification of those values. Data can be compiled through sampling, from literature values, or from other CSO studies.",{"$f":"IF(ISBLANK(VLOOKUP(B55,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B55,SystChar!B:E,4,FALSE))","v":""},"i\nPage 58",null,null,{"$f":"VLOOKUP(B55,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B56,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B46","v":37},"Collect rainfall data within the CSS during the flow monitoring periods.",{"$f":"IF(ISBLANK(VLOOKUP(B56,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B56,SystChar!B:E,4,FALSE))","v":""},"i\nPage 59",null,null,{"$f":"VLOOKUP(B56,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B57,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B47","v":38},"Revise the flow monitoring data to better portray the hydraulic response of the CSS to rainfall.",{"$f":"IF(ISBLANK(VLOOKUP(B57,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B57,SystChar!B:E,4,FALSE))","v":""},"i\nPage 60",null,null,{"$f":"VLOOKUP(B57,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B58,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B48","v":39},"Revise the monitoring program to better evaluate the effectiveness of any control measures implemented as part of the NMC.",{"$f":"IF(ISBLANK(VLOOKUP(B58,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B58,SystChar!B:E,4,FALSE))","v":""},"i\nPage 62",null,null,{"$f":"VLOOKUP(B58,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B59,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B49","v":40},"Provide justification for selection of one CSO outfall as representative of a subset of outfalls.",{"$f":"IF(ISBLANK(VLOOKUP(B59,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B59,SystChar!B:E,4,FALSE))","v":""},"i\nPage 74",null,null,{"$f":"VLOOKUP(B59,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B60,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B51","v":41},"Note the type (e.g., free flowing, tidal, etc.) and physical characteristics of the receiving water.",{"$f":"IF(ISBLANK(VLOOKUP(B60,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B60,SystChar!B:E,4,FALSE))","v":""},"i\nPage 65",null,null,{"$f":"VLOOKUP(B60,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B61,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B52","v":42},"Provide information on the impact of CSO pollutant loadings on the receiving waters for the water quality parameters of concern (typically bacteria, BOD and TSS).",{"$f":"IF(ISBLANK(VLOOKUP(B61,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B61,SystChar!B:E,4,FALSE))","v":""},"i\nPage 65",null,null,{"$f":"VLOOKUP(B61,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B62,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B53","v":43},"Revise the monitoring to better document pre-control baseline conditions, which will allow for demonstration of the long-term benefits of CSO controls. ",{"$f":"IF(ISBLANK(VLOOKUP(B62,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B62,SystChar!B:E,4,FALSE))","v":""},"i\nPage 62",null,null,{"$f":"VLOOKUP(B62,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B63,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B54","v":44},"Improve the spatial and temporal coverage of the wet weather monitoring program to better evaluate the impacts associated with CSOs.",{"$f":"IF(ISBLANK(VLOOKUP(B63,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B63,SystChar!B:E,4,FALSE))","v":""},"i\nPage 55",null,null,{"$f":"VLOOKUP(B63,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B64,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B55","v":45},"Monitor water quality impacts and other sources of pollution to show compliance with water quality standards or demonstrate that other sources of pollution may preclude attainment of water quality standards even if CSOs are eliminated.",{"$f":"IF(ISBLANK(VLOOKUP(B64,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B64,SystChar!B:E,4,FALSE))","v":""},"i\nPage 55",null,null,{"$f":"VLOOKUP(B64,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B65,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B56","v":46},"Consider a larger range of possible CSO impacts on receiving waters based on the concerns of the local community. These impacts may include bacteria and floatables, dissolved oxygen, metals or nutrients.",{"$f":"IF(ISBLANK(VLOOKUP(B65,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B65,SystChar!B:E,4,FALSE))","v":""},"i\nPage 65",null,null,{"$f":"VLOOKUP(B65,SystChar!B:I,8,FALSE)","v":0}]
["No",null,"Characterization of Collection System and Receiving Waters Modeling",null,null,null,null,0]
[{"$f":"VLOOKUP(B67,SystChar!B:H,3,FALSE)","v":0},"MC3","Major Question: Develop a model of the collection system and/or receiving water, as appropriate, that is able to support the evaluation and selection of CSO controls given the complexity of the CSS. If a model has been developed, see the notes column to the right for specific recommendations on how the model can be improved.",{"$f":"IF(ISBLANK(VLOOKUP(B67,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B67,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,{"$f":"VLOOKUP(B67,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B68,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B60","v":47},"Develop a model (e.g., spreadsheet, SWMM, HydroWorks, etc.) to assess the response of the CSS to different rainfall conditions with respect to CSO volume, frequency and peak overflow rate.",{"$f":"IF(ISBLANK(VLOOKUP(B68,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B68,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,{"$f":"VLOOKUP(B68,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B69,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B61","v":48},"Revise the CSS model framework to address the engineering and regulatory needs of the LTCP.",{"$f":"IF(ISBLANK(VLOOKUP(B69,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B69,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,{"$f":"VLOOKUP(B69,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B70,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B62","v":49},"Revise the level of detail of the CSS model to be consistent with and representative of the complexity of the CSS.",{"$f":"IF(ISBLANK(VLOOKUP(B70,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B70,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,{"$f":"VLOOKUP(B70,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B71,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B63","v":50},"Incorporate additional flow and effluent concentration data to calibrate the model. It is generally recommended that permittees use 8-10 storms covering a range of storm sizes for calibration.",{"$f":"IF(ISBLANK(VLOOKUP(B71,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B71,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,{"$f":"VLOOKUP(B71,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B72,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B64","v":51},"Revise the model to better represent the observed behavior of the CSS over a variety of rainfall events. This may include characterization of CSO volume, duration, frequency and peak overflow rate.",{"$f":"IF(ISBLANK(VLOOKUP(B72,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B72,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,{"$f":"VLOOKUP(B72,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B73,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B66","v":52},"Develop a model to assess the response of receiving waters to external CSO loads.",{"$f":"IF(ISBLANK(VLOOKUP(B73,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B73,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,{"$f":"VLOOKUP(B73,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B74,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B67","v":53},"Ensure the level of detail of the water quality model(s) is consistent with and representative of the complexity of the receiving waters.",{"$f":"IF(ISBLANK(VLOOKUP(B74,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B74,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,{"$f":"VLOOKUP(B74,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B75,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B68","v":54},"Revise the model to better represent the major processes affecting water quality for the pollutants of concern.",{"$f":"IF(ISBLANK(VLOOKUP(B75,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B75,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,{"$f":"VLOOKUP(B75,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B76,SystChar!B:H,3,FALSE)","v":0},{"$f":"SystChar!B69","v":55},"Model water quality impacts and other sources of pollution to show compliance with water quality standards or demonstrate that other sources of pollution may preclude attainment of water quality standards even if CSOs are eliminated.",{"$f":"IF(ISBLANK(VLOOKUP(B76,SystChar!B:E,4,FALSE)),\"\",VLOOKUP(B76,SystChar!B:E,4,FALSE))","v":""},"i\nPage 81",null,null,{"$f":"VLOOKUP(B76,SystChar!B:I,8,FALSE)","v":0}]
[{"$f":"IF(ISBLANK(SystChar!$C$72),\"NAC\",\"No\")","v":"NAC"},null,"Additional Considerations - System Characterization"]
[{"$f":"IF(ISBLANK(SystChar!$C$72),\"NAC\",\"No\")","v":"NAC"},null,{"$f":"IF(ISBLANK(SystChar!$C$72),\"\",SystChar!$C$72)","v":""}]
[null,null,"Development and Evaluation of CSO Control Alternatives",null,null,null,null,0]
[{"$f":"VLOOKUP(B80,Alternatives!B:H,3,FALSE)","v":0},"MC4","Major Question: Revise the evaluation of CSO control alternatives and identification of a cost-effective CSO control plan. Specific areas of improvement should be indicated throughout this section in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B80,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B80,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 98",null,null,{"$f":"VLOOKUP(B80,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B81,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B14","v":56},"Revise the evaluation of controls in a way that is more understandable and consistent with the CSO Control Policy and EPA guidance.",{"$f":"IF(ISBLANK(VLOOKUP(B81,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B81,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 100",null,null,{"$f":"VLOOKUP(B81,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B82,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B15","v":57},"Identify whether the presumption approach, the demonstration approach or some combination of the two is being used.",{"$f":"IF(ISBLANK(VLOOKUP(B82,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B82,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 100",null,null,{"$f":"VLOOKUP(B82,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B83,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B17","v":58},"Include a range of control technologies within the general categories of source controls, collection system controls, storage technologies and treatment technologies.",{"$f":"IF(ISBLANK(VLOOKUP(B83,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B83,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 126",null,null,{"$f":"VLOOKUP(B83,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B84,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B18","v":59},"Evaluate a full range of potential controls with respect to meeting water quality standards and protecting designated uses. A full range should include zero overflow events per year, and averages of 1 to 3, 4 to 7, and 8 to 12 overflow events per year.",{"$f":"IF(ISBLANK(VLOOKUP(B84,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B84,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 115",null,null,{"$f":"VLOOKUP(B84,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B85,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B19","v":60},"Describe the process by which the CSO controls and alternative combinations were developed.",{"$f":"IF(ISBLANK(VLOOKUP(B85,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B85,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 115",null,null,{"$f":"VLOOKUP(B85,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B86,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B20","v":61},"Describe the process used to screen and narrow the list of CSO control technologies. This should include a list of the screening criteria.",{"$f":"IF(ISBLANK(VLOOKUP(B86,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B86,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 115",null,null,{"$f":"VLOOKUP(B86,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B87,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B21","v":62},"Explain the reasons for selecting certain CSO controls.",{"$f":"IF(ISBLANK(VLOOKUP(B87,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B87,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 115",null,null,{"$f":"VLOOKUP(B87,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B88,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B22","v":63},"Integrate the NMC into the description of the selected CSO controls.",{"$f":"IF(ISBLANK(VLOOKUP(B88,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B88,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 116",null,null,{"$f":"VLOOKUP(B88,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B89,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B23","v":64},"Consider maximization of treatment at the existing POTW for wet weather flows, as well as the expansion of primary and secondary treatment capacity. Primary treatment is defined in CWA Section 301(h)(9).",{"$f":"IF(ISBLANK(VLOOKUP(B89,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B89,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 123",null,null,{"$f":"VLOOKUP(B89,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B90,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B24","v":65},"Develop a cost/performance (knee of the curve) analysis for the control alternatives considered.",{"$f":"IF(ISBLANK(VLOOKUP(B90,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B90,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 138",null,null,{"$f":"VLOOKUP(B90,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B91,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B25","v":66},{"$f":"IF(SystChar!D35=\"No\",\"Sensitive Areas Question - Not Applicable\",\"Give a higher priority to control of CSO discharges in sensitive areas.\")","v":"Give a higher priority to control of CSO discharges in sensitive areas."},{"$f":"IF(ISBLANK(VLOOKUP(B91,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B91,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 125",null,null,{"$f":"VLOOKUP(B91,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B92,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B26","v":67},{"$f":"IF(SystChar!D35=\"No\",\"Sensitive Areas Question - Not Applicable\",\"Describe whether the selected CSO controls will eliminate all CSO impacts to sensitive areas.\")","v":"Describe whether the selected CSO controls will eliminate all CSO impacts to sensitive areas."},{"$f":"IF(ISBLANK(VLOOKUP(B92,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B92,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 125",null,null,{"$f":"VLOOKUP(B92,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B93,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B27","v":68},{"$f":"IF(SystChar!D35=\"No\",\"Sensitive Areas Question - Not Applicable\",\"Provide data and analysis that support the conclusion that elimination of CSO impacts is not physically possible or economically achievable.\")","v":"Provide data and analysis that support the conclusion that elimination of CSO impacts is not physically possible or economically achievable."},{"$f":"IF(ISBLANK(VLOOKUP(B93,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B93,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 118","i\nPage 30",null,{"$f":"VLOOKUP(B93,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B94,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B28","v":69},{"$f":"IF(SystChar!D35=\"No\",\"Sensitive Areas Question - Not Applicable\",\"State whether remaining CSOs to sensitive areas will receive treatment.\")","v":"State whether remaining CSOs to sensitive areas will receive treatment."},{"$f":"IF(ISBLANK(VLOOKUP(B94,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B94,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 135","i\nPage 30",null,{"$f":"VLOOKUP(B94,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B95,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B29","v":70},"State whether the selected CSO controls will provide the treatment of floatables and settleable solids equivalent to that achieved by primary clarification.",{"$f":"IF(ISBLANK(VLOOKUP(B95,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B95,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 135","i\nPage 30",null,{"$f":"VLOOKUP(B95,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B96,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B30","v":71},"Ensure the LTCP demonstrates whether or not disinfection of effluent will be necessary based on applicable water quality standards.",{"$f":"IF(ISBLANK(VLOOKUP(B96,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B96,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 135","i\nPage 104",null,{"$f":"VLOOKUP(B96,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B97,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B32","v":72},"Consider using green infrastructure to manage wet weather flows.",{"$f":"IF(ISBLANK(VLOOKUP(B97,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B97,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 7",null,null,{"$f":"VLOOKUP(B97,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B98,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B33","v":73},{"$f":"IF(Alternatives!D32=\"No\",\"Green Infrastructure Question - Not Applicable\",\"Determine the runoff volume expected to be controlled using green infrastructure.\")","v":"Determine the runoff volume expected to be controlled using green infrastructure."},{"$f":"IF(ISBLANK(VLOOKUP(B98,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B98,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 12",null,null,{"$f":"VLOOKUP(B98,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B99,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B34","v":74},{"$f":"IF(Alternatives!D32=\"No\",\"Green Infrastructure Question - Not Applicable\",\"Determine the volume expected to be retained using green infrastructure.\")","v":"Determine the volume expected to be retained using green infrastructure."},{"$f":"IF(ISBLANK(VLOOKUP(B99,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B99,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 20",null,null,{"$f":"VLOOKUP(B99,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B100,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B36","v":75},"Provide information showing that CSO discharges remaining after implementation of the planned control program will not cause or contribute to the non-attainment of water quality standards or existing uses.",{"$f":"IF(ISBLANK(VLOOKUP(B100,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B100,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 118",null,null,{"$f":"VLOOKUP(B100,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B101,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B37","v":76},"Provide a UAA or similar analysis to justify a water quality standards review.",{"$f":"IF(ISBLANK(VLOOKUP(B101,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B101,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 118","i",null,{"$f":"VLOOKUP(B101,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B102,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B38","v":77},"Provide a UAA or similar analysis to demonstrate the removal of the designated use(s) based on 40 CFR 131.10 (g) and (h).",{"$f":"IF(ISBLANK(VLOOKUP(B102,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B102,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 118","i",null,{"$f":"VLOOKUP(B102,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B103,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B39","v":78},"Document pollutant sources or natural background conditions other than CSOs that preclude water quality standards from being met",{"$f":"IF(ISBLANK(VLOOKUP(B103,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B103,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 118",null,null,{"$f":"VLOOKUP(B103,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B104,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B41","v":79},"The LTCP monitoring should be coordinated with other municipal efforts, or ongoing or planned state programs. Permittees should document this coordination in the LTCP.",{"$f":"IF(ISBLANK(VLOOKUP(B104,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B104,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 22",null,null,{"$f":"VLOOKUP(B104,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B105,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B42","v":80},"LTCP development should be coordinated with watershed or TMDL efforts. Permittees should document this in the LTCP.",{"$f":"IF(ISBLANK(VLOOKUP(B105,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B105,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 22",null,null,{"$f":"VLOOKUP(B105,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B106,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B44","v":81},"Revise the assessment of financial resources available for the implementation of CSO controls following the general guidelines in Section 3.5 of EPA's Guidance for LTCP. Financial indicators include such factors as total annual wastewater and CSO control cost per household, unemployment rate, median household income or property tax revenue collection rate.",{"$f":"IF(ISBLANK(VLOOKUP(B106,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B106,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 163",null,null,{"$f":"VLOOKUP(B106,Alternatives!B:I,8,FALSE)","v":0}]
["No",null,"Public Participation",null,null,null,null,0]
[{"$f":"VLOOKUP(B108,Alternatives!B:H,3,FALSE)","v":0},"MC5","Major Question: Revise the public notification and engagement portions of the LTCP. Specific areas of improvement should be indicated throughout this section in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B108,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B108,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 98","i\nPage 177",null,{"$f":"VLOOKUP(B108,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B109,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B48","v":82},"Ensure the public participation process actively involves the affected public including rate payers, industrial users of the CSS, persons near impacted waters, and persons who use the impacted waters.",{"$f":"IF(ISBLANK(VLOOKUP(B109,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B109,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 98","i\nPage 177",null,{"$f":"VLOOKUP(B109,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B110,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B49","v":83},"Include a record of the public participation events in the LTCP. This record should include the number of people attending and a record or summary of participant comments.",{"$f":"IF(ISBLANK(VLOOKUP(B110,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B110,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 98","i\nPage 177",null,{"$f":"VLOOKUP(B110,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B111,Alternatives!B:H,3,FALSE)","v":0},{"$f":"Alternatives!B50","v":84},"Ensure the LTCP documents decisions or changes made in response to public comments.",{"$f":"IF(ISBLANK(VLOOKUP(B111,Alternatives!B:E,4,FALSE)),\"\",VLOOKUP(B111,Alternatives!B:E,4,FALSE))","v":""},"i\nPage 98","i\nPage 177",null,{"$f":"VLOOKUP(B111,Alternatives!B:I,8,FALSE)","v":0}]
[{"$f":"IF(ISBLANK(Alternatives!$C$53),\"NAC\",\"No\")","v":"NAC"},null,"Additional Considerations - Alternatives Evaluation"]
[{"$f":"IF(ISBLANK(Alternatives!$C$53),\"NAC\",\"No\")","v":"NAC"},null,{"$f":"IF(ISBLANK(Alternatives!$C$53),\"\",Alternatives!$C$53)","v":""}]
[null,null,"Selection of Controls and Implementation",null,null,null,null,0]
[{"$f":"VLOOKUP(B115,Implementation!B:E,3,FALSE)","v":0},"MC6","Major Question: Revise the process for evaluating and selecting CSO controls. Specific areas of improvement should be indicated throughout this section in the notes column to the right.",{"$f":"IF(ISBLANK(VLOOKUP(B115,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B115,Implementation!B:E,4,FALSE))","v":""},"i\nPage 98",null,null,{"$f":"VLOOKUP(B115,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B116,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B14","v":85},"Ensure the LTCP documents benefits derived from implementation of the NMC.",{"$f":"IF(ISBLANK(VLOOKUP(B116,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B116,Implementation!B:E,4,FALSE))","v":""},"i\nPage 116",null,null,{"$f":"VLOOKUP(B116,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B117,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B16","v":86},"Document the controls selected for implementation, including detailed descriptions, preliminary engineering analysis, and cost estimates.",{"$f":"IF(ISBLANK(VLOOKUP(B117,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B117,Implementation!B:E,4,FALSE))","v":""},"i\nPage 180",null,null,{"$f":"VLOOKUP(B117,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B118,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B17","v":87},"Revise the selected alternative or its description to show that it is adequate, or reasonable to presume adequate, to provide for the attainment of applicable water quality standards and the protection of existing and designated uses.",{"$f":"IF(ISBLANK(VLOOKUP(B118,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B118,Implementation!B:E,4,FALSE))","v":""},"i\nPage 180",null,null,{"$f":"VLOOKUP(B118,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B119,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B19","v":88},"The LTCP should recommend a financing approach demonstrating how the permittee will finance the alternative selected. The approach should identify a specific capital and annual cost funding approach.",{"$f":"IF(ISBLANK(VLOOKUP(B119,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B119,Implementation!B:E,4,FALSE))","v":""},"i\nPage 182",null,null,{"$f":"VLOOKUP(B119,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B120,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B20","v":89},"The permittee should evaluate funding through increased user fees and rate structures for residential, commercial and industrial users. ",{"$f":"IF(ISBLANK(VLOOKUP(B120,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B120,Implementation!B:E,4,FALSE))","v":""},"i\nPage 182",null,null,{"$f":"VLOOKUP(B120,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B121,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B21","v":90},"The permittee should evaluate grant and loan availability and other sources of financing.",{"$f":"IF(ISBLANK(VLOOKUP(B121,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B121,Implementation!B:E,4,FALSE))","v":""},"i\nPage 182",null,null,{"$f":"VLOOKUP(B121,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B122,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B23","v":91},"The permittee should revise the implementation phases of the LTCP to be consistent with their available resources and the priorities for eliminating the CSO-induced impairment.",{"$f":"IF(ISBLANK(VLOOKUP(B122,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B122,Implementation!B:E,4,FALSE))","v":""},"i\nPage 185",null,null,{"$f":"VLOOKUP(B122,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B123,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B24","v":92},{"$f":"IF(SystChar!D35=\"No\",\"Sensitive Areas Question - Not Applicable\",\"The permittee should give a higher priority to control of CSO discharges to sensitive areas.\")","v":"The permittee should give a higher priority to control of CSO discharges to sensitive areas."},{"$f":"IF(ISBLANK(VLOOKUP(B123,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B123,Implementation!B:E,4,FALSE))","v":""},"i\nPage 185",null,null,{"$f":"VLOOKUP(B123,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B124,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B26","v":93},"The permittee should revise the LTCP to document how the current operational plan for the CSS will be developed/revised to include the operational and maintenance needs of the controls selected for implementation.",{"$f":"IF(ISBLANK(VLOOKUP(B124,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B124,Implementation!B:E,4,FALSE))","v":""},"i\nPage 189","i",null,{"$f":"VLOOKUP(B124,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B125,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B27","v":94},"The operational plan should include sampling and maintenance schedules.",{"$f":"IF(ISBLANK(VLOOKUP(B125,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B125,Implementation!B:E,4,FALSE))","v":""},"i\nPage 189","i",null,{"$f":"VLOOKUP(B125,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B126,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B28","v":95},"The operational plan should identify staffing needs.",{"$f":"IF(ISBLANK(VLOOKUP(B126,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B126,Implementation!B:E,4,FALSE))","v":""},"i\nPage 189","i",null,{"$f":"VLOOKUP(B126,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B127,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B30","v":96},"The monitoring program should verify compliance with water quality standards and protection of designated uses.",{"$f":"IF(ISBLANK(VLOOKUP(B127,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B127,Implementation!B:E,4,FALSE))","v":""},"i\nPage 191"]
[{"$f":"VLOOKUP(B128,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B31","v":97},"The monitoring plan should include 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(B128,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B128,Implementation!B:E,4,FALSE))","v":""},"i\nPage 191"]
[{"$f":"VLOOKUP(B129,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B32","v":98},"The LTCP should describe how and when post-construction monitoring will be conducted and how the results will be reported.",{"$f":"IF(ISBLANK(VLOOKUP(B129,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B129,Implementation!B:E,4,FALSE))","v":""},"i\nPage 191",null,null,{"$f":"VLOOKUP(B129,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"VLOOKUP(B130,Implementation!B:E,3,FALSE)","v":0},{"$f":"Implementation!B33","v":99},"The post-construction compliance monitoring program should be revised to improve the spatial and temporal coverage during wet weather conditions to assess the effectiveness of CSO controls and improvement from pre-control baseline conditions associated with LTCP implementation.",{"$f":"IF(ISBLANK(VLOOKUP(B130,Implementation!B:E,4,FALSE)),\"\",VLOOKUP(B130,Implementation!B:E,4,FALSE))","v":""},"i\nPage 191",null,null,{"$f":"VLOOKUP(B130,Implementation!B:I,8,FALSE)","v":0}]
[{"$f":"IF(ISBLANK(Implementation!$C$36),\"NAC\",\"No\")","v":"NAC"},null,"Additional Considerations - LTCP Implementation"]
[{"$f":"IF(ISBLANK(Implementation!$C$36),\"NAC\",\"No\")","v":"NAC"},null,{"$f":"IF(ISBLANK(Implementation!$C$36),\"\",Implementation!$C$36)","v":""}]
[]
["Button: Go to the previous page"]

{"sheet":"Lists","index":8,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"blank, yes, no",null,null,null,null,"Who are you?"]
[]
[null,"Yes",null,null,null,null,"Small System Permittee or NPDES Authority"]
[null,"No",null,null,null,null,"Large System Permittee or NPDES Authority"]
[null,"NA"]
[]
[]
[]
[]
[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]