{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Read Me","0. Plan Information","1. Adminstrative Timeline","2. Activity Log","3. Plan Review","4. Plan Completeness Summary","5. Adequacy Summary","6. Evaluation Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":2,"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":"Read Me","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
["This workbook was created as a companion to Module 3 of EPA's Integrated Planning Permitting Authority Toolkit to help permitting authorities facilitate an integrated plan review as part of the permit renewal process, determine if the plan contains all of the information necessary to inform the permit development, and align the integrated plan outcomes with permit requirements, permit issuance, and compliance schedules. Use the tab and arrow keys to navigate each page. Messages are provided in most cells to notify the user how to use each cell and form."]
[null,"Integrated Planning in Action Permitting Authority Toolkit: Module 3 Workbook"]
[null,"Overview","This workbook was created as a companion to Module 3 of EPA's Integrated Planning Permitting Authority Toolkit to help permitting authorities facilitate an integrated plan review as part of the permit renewal process, determine if the plan contains all of the information necessary to inform the permit development, and align the integrated plan outcomes with permit requirements, permit issuance, and compliance schedules."]
[null,"Sheet","Description"]
[null,"0. Plan Information","Enter basic information about the permittee, integrated plan submittal, and the relevant permits and enforcement actions."]
[null,"1. Administrative Timeline","Displays plan review timeline against permit expiration dates to visualize the integrated plan review window and help you identify key dates."]
[null,"2. Activity Log","Table to track different aspects of permitting authority review and document any follow up with the permittee."]
[null,"3. Plan Review","Guides you through a completeness review of the integrated plan based on the six elements of the Integrated Planning Framework. Includes space for you to take notes on what is included in or missing from the plan."]
[null,"4. Plan Completeness Summary","Output from the plan review sheet highlighting which elements are missing information. Includes space to document any follow-up communications with the permittee. "]
[null,"5. Adequacy Summary","Allows you to compare the original permit requirements with the proposed outcomes of the integrated plan. Guides you through documenting the water quality drivers and requirements as well as and non-CWA requirements and drivers to elaborate on the justification for an integrated approach."]
[null,"6. Evaluation Summary","Output sheet summarizing the basic plan information,  plan completeness, and adequacy from previous tabs. Includes space to document the final state decision regarding a permit revision and/or compliance schedule."]
[null,"Key"]
[null,"Tool inputs are indicated in purple"]
[null,"Satisfactory answers are indicated in green"]
[null,"Unsatisfactory answers are indicated in red"]
[null,"Tool outputs are indicated in orange and should not be edited"]
[null,"General notes and answers are indicated in grey"]

{"sheet":"0. Plan Information","index":1,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,1,2,3],[3,1,3,2],[4,1,4,2],[64,2,65,2],[64,3,65,3],[65,1,67,1],[66,2,68,2],[66,3,68,3],[58,2,59,2],[58,3,59,3],[59,1,61,1],[60,2,62,2],[60,3,62,3],[6,1,6,2],[10,1,10,3],[10,5,10,7],[11,1,11,2],[16,2,17,2],[16,3,17,3],[22,2,23,2],[22,3,23,3],[49,5,49,7],[50,1,50,2],[52,2,53,2],[52,3,53,3],[53,1,55,1],[54,2,56,2],[54,3,56,3],[49,1,49,3],[5,1,5,3],[28,2,29,2],[28,3,29,3],[34,2,35,2],[34,3,35,3],[40,2,41,2],[40,3,41,3],[9,1,9,2],[46,2,47,2],[46,3,47,3]]}
[null,"Instructions: Enter information in purple tool input cells. The number of permit and enforcement actions you indicate will determine how many sections are shown. Enter the number of permit or enforcement requirements being addressed in the plan which will make tables available to the right where you can input the compliance requirements being addressed in the plan and the deadline for each requirement."]
[]
[null,"Basic Plan Information"]
[null,"Permittee Name"]
[null,"Plan Name"]
[null,"Integrated Plan Information",null,null,null,null,null,null,null,null,null,null,"WWTF",2,"Yes",1,1]
[null,"Has the permittee submitted an integrated plan for review and incorporation into one or more permits?",null,null,null,null,null,null,null,null,null,null,"CSO",3,"No",2,2]
[null,null,"When did you begin your review? (MM/DD/YYYY)",null,null,null,null,null,null,null,null,null,"MS4",4,null,3,3]
[null,null,"When do you expect the permittee to submit the integrated plan? (MM/DD/YYYY)",null,null,null,null,null,null,null,null,null,"WWTF and CSO",5,null,4]
[null,"How many months do you expect that it will take to review the integrated plan and determine if the plan's outcomes should be incorporated into facility permits?",null,null,null,null,null,null,null,null,null,null,"WWTF and MS4",6,null,5]
[null,"Permit Information ",null,null,null,"Permit Requirements",null,null,null,null,null,null,"WWTF, CSO, MS4"]
[null,"How many of the facility's permits are being addressed in the integrated plan?",null,null,null,"Req.","Compliance Requirement","Compliance Date"]
[]
[null,null,"Facility Name",null,null,1]
[null,null,"Permit Number",null,null,2]
[null,"Permit 1","Discharges Addressed",null,null,3]
[null,null,"How many permit requirements are addressed in the Integrated Plan?",null,null,4]
[null,null,null,null,null,5]
[]
[null,null,"Facility Name",null,null,1]
[null,null,"Permit Number",null,null,2]
[null,"Permit 2","Discharges Addressed",null,null,3]
[null,null,"How many permit requirements are addressed in the Integrated Plan?",null,null,4]
[null,null,null,null,null,5]
[]
[{"$f":"IF($D$12<3,0,1)","v":0},null,"Facility Name",null,null,1]
[{"$f":"IF($D$12<3,0,1)","v":0},null,"Permit Number",null,null,2]
[0,"Permit 3","Discharges Addressed",null,null,3]
[0,null,"How many permit requirements are addressed in the Integrated Plan?",null,null,4]
[0,null,null,null,null,5]
[0]
[{"$f":"IF($D$12<4,0,1)","v":0},null,"Facility Name",null,null,1]
[{"$f":"IF($D$12<4,0,1)","v":0},null,"Permit Number",null,null,2]
[0,"Permit 4","Discharges Addressed",null,null,3]
[0,null,"How many permit requirements are addressed in the Integrated Plan?",null,null,4]
[0,null,null,null,null,5]
[0]
[{"$f":"IF($D$12<5,0,1)","v":0},null,"Facility Name",null,null,1]
[{"$f":"IF($D$12<5,0,1)","v":0},null,"Permit Number",null,null,2]
[0,"Permit 5","Discharges Addressed",null,null,3]
[0,null,"How many permit requirements are addressed in the Integrated Plan?",null,null,4]
[0,null,null,null,null,5]
[0]
[{"$f":"IF($D$12<6,0,1)","v":0},null,"Facility Name",null,null,1]
[{"$f":"IF($D$12<6,0,1)","v":0},null,"Permit Number",null,null,2]
[0,"Permit 6","Discharges Addressed",null,null,3]
[0,null,"How many permit requirements are addressed in the Integrated Plan?",null,null,4]
[0,null,null,null,null,5]
[0]
[null,"Enforcement Information ",null,null,null,"Enforcement Requirements"]
[null,"How many enforcement mechanisms are included in the Integrated Plan?",null,null,null,"Req.","Compliance Requirement","Compliance Date"]
[]
[null,null,"Enforcement Mechanism",null,null,1]
[null,"Enforcement Mechanism 1",null,null,null,2]
[null,null,"How many compliance requirements are included in this enforcement mechanism?",null,null,3]
[null,null,null,null,null,4]
[null,null,null,null,null,5]
[]
[{"$f":"IF($D$51>1,1,0)","v":0},null,"Enforcement Mechanism",null,null,1]
[{"$f":"IF($D$51>1,1,0)","v":0},"Enforcement Mechanism 2",null,null,null,2]
[0,null,"How many compliance requirements are included in this enforcement mechanism?",null,null,3]
[0,null,null,null,null,4]
[0,null,null,null,null,5]
[0]
[{"$f":"IF($D$51>2,1,0)","v":0},null,"Enforcement Mechanism",null,null,1]
[{"$f":"IF($D$51>2,1,0)","v":0},"Enforcement Mechanism 3",null,null,null,2]
[0,null,"How many compliance requirements are included in this enforcement mechanism?",null,null,3]
[0,null,null,null,null,4]
[0,null,null,null,null,5]
[0]

{"sheet":"1. Adminstrative Timeline","index":2,"n_rows":22,"n_cols":133,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,2],[6,1,6,3],[9,56,9,67],[9,68,9,79],[9,104,9,115],[9,116,9,127],[7,1,8,3],[9,8,9,19],[9,20,9,31],[9,32,9,43],[9,5,9,6],[9,44,9,55],[9,80,9,91],[9,92,9,103]]}
[null,"Instructions: Enter the expiration date for each permit generated below from the Plan Information tab. The timeframe available to review the integrated plan without having to extend and/or reopen a permit will be generated in yellow."]
[null,null,null,null,null,null,null,null,1,{"$f":"I2+1","v":2},{"$f":"J2+1","v":3},4,5,6,7,8,9,10,11,12,{"$f":"T2+1","v":13},{"$f":"U2+1","v":14},{"$f":"V2+1","v":15},{"$f":"W2+1","v":16},{"$f":"X2+1","v":17},{"$f":"Y2+1","v":18},{"$f":"Z2+1","v":19},{"$f":"AA2+1","v":20},{"$f":"AB2+1","v":21},{"$f":"AC2+1","v":22},{"$f":"AD2+1","v":23},{"$f":"AE2+1","v":24},{"$f":"AF2+1","v":25},{"$f":"AG2+1","v":26},{"$f":"AH2+1","v":27},{"$f":"AI2+1","v":28},{"$f":"AJ2+1","v":29},{"$f":"AK2+1","v":30},{"$f":"AL2+1","v":31},{"$f":"AM2+1","v":32},{"$f":"AN2+1","v":33},{"$f":"AO2+1","v":34},{"$f":"AP2+1","v":35},{"$f":"AQ2+1","v":36},{"$f":"AR2+1","v":37},{"$f":"AS2+1","v":38},{"$f":"AT2+1","v":39},{"$f":"AU2+1","v":40},{"$f":"AV2+1","v":41},{"$f":"AW2+1","v":42},{"$f":"AX2+1","v":43},{"$f":"AY2+1","v":44},{"$f":"AZ2+1","v":45},{"$f":"BA2+1","v":46},{"$f":"BB2+1","v":47},{"$f":"BC2+1","v":48},{"$f":"BD2+1","v":49},{"$f":"BE2+1","v":50},{"$f":"BF2+1","v":51},{"$f":"BG2+1","v":52},{"$f":"BH2+1","v":53},{"$f":"BI2+1","v":54},{"$f":"BJ2+1","v":55},{"$f":"BK2+1","v":56},{"$f":"BL2+1","v":57},{"$f":"BM2+1","v":58},{"$f":"BN2+1","v":59},{"$f":"BO2+1","v":60},{"$f":"BP2+1","v":61},{"$f":"BQ2+1","v":62},{"$f":"BR2+1","v":63},{"$f":"BS2+1","v":64},{"$f":"BT2+1","v":65},{"$f":"BU2+1","v":66},{"$f":"BV2+1","v":67},{"$f":"BW2+1","v":68},{"$f":"BX2+1","v":69},{"$f":"BY2+1","v":70},{"$f":"BZ2+1","v":71},{"$f":"CA2+1","v":72},{"$f":"CB2+1","v":73},{"$f":"CC2+1","v":74},{"$f":"CD2+1","v":75},{"$f":"CE2+1","v":76},{"$f":"CF2+1","v":77},{"$f":"CG2+1","v":78},{"$f":"CH2+1","v":79},{"$f":"CI2+1","v":80},{"$f":"CJ2+1","v":81},{"$f":"CK2+1","v":82},{"$f":"CL2+1","v":83},{"$f":"CM2+1","v":84},{"$f":"CN2+1","v":85},{"$f":"CO2+1","v":86},{"$f":"CP2+1","v":87},{"$f":"CQ2+1","v":88},{"$f":"CR2+1","v":89},{"$f":"CS2+1","v":90},{"$f":"CT2+1","v":91},{"$f":"CU2+1","v":92},{"$f":"CV2+1","v":93},{"$f":"CW2+1","v":94},{"$f":"CX2+1","v":95},{"$f":"CY2+1","v":96},{"$f":"CZ2+1","v":97},{"$f":"DA2+1","v":98},{"$f":"DB2+1","v":99},{"$f":"DC2+1","v":100},{"$f":"DD2+1","v":101},{"$f":"DE2+1","v":102},{"$f":"DF2+1","v":103},{"$f":"DG2+1","v":104},{"$f":"DH2+1","v":105},{"$f":"DI2+1","v":106},{"$f":"DJ2+1","v":107},{"$f":"DK2+1","v":108},{"$f":"DL2+1","v":109},{"$f":"DM2+1","v":110},{"$f":"DN2+1","v":111},{"$f":"DO2+1","v":112},{"$f":"DP2+1","v":113},{"$f":"DQ2+1","v":114},{"$f":"DR2+1","v":115},{"$f":"DS2+1","v":116},{"$f":"DT2+1","v":117},{"$f":"DU2+1","v":118},{"$f":"DV2+1","v":119},{"$f":"DW2+1","v":120}]
[null,"DO NOT DELETE ROW","Plan Review Start Date",{"$f":"IF(ISBLANK('0. Plan Information'!$D$8),'0. Plan Information'!$D$9,'0. Plan Information'!$D$8)","v":"00:00:00"}]
[null,"DO NOT DELETE ROW","Plan Review End Date",{"$f":"EDATE(D3,'0. Plan Information'!$D$10)","v":"00:00:00"}]
[null,"DO NOT DELETE ROW","Timeline Start Date",{"$f":"DATE(IF(ISBLANK(D12),YEAR(D3),YEAR(MIN(D3,D12:D17))),1,1)","v":"1900-01-01"},null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"DO NOT DELETE ROW","Timeline End Date",{"$f":"MAX(E12:G17,D3:D4)","v":"00:00:00"},null,null,null,null,{"$f":"DATE(YEAR(D5),1,1)","v":"1900-01-01"},{"$f":"IF(J5=1,DATE(YEAR(I6)+1,1,1),DATE(YEAR(I6),J5,1))","v":"1900-02-01"},{"$f":"IF(K5=1,DATE(YEAR(J6)+1,1,1),DATE(YEAR(J6),K5,1))","v":"1900-03-01"},"1900-04-01","1900-05-01","1900-06-01","1900-07-01","1900-08-01","1900-09-01","1900-10-01","1900-11-01","1900-12-01","1901-01-01","1901-02-01","1901-03-01","1901-04-01","1901-05-01","1901-06-01","1901-07-01","1901-08-01","1901-09-01","1901-10-01","1901-11-01","1901-12-01",{"$f":"IF(AG5=1,DATE(YEAR(AF6)+1,1,1),DATE(YEAR(AF6),AG5,1))","v":"1902-01-01"},{"$f":"IF(AH5=1,DATE(YEAR(AG6)+1,1,1),DATE(YEAR(AG6),AH5,1))","v":"1902-02-01"},{"$f":"IF(AI5=1,DATE(YEAR(AH6)+1,1,1),DATE(YEAR(AH6),AI5,1))","v":"1902-03-01"},{"$f":"IF(AJ5=1,DATE(YEAR(AI6)+1,1,1),DATE(YEAR(AI6),AJ5,1))","v":"1902-04-01"},{"$f":"IF(AK5=1,DATE(YEAR(AJ6)+1,1,1),DATE(YEAR(AJ6),AK5,1))","v":"1902-05-01"},{"$f":"IF(AL5=1,DATE(YEAR(AK6)+1,1,1),DATE(YEAR(AK6),AL5,1))","v":"1902-06-01"},{"$f":"IF(AM5=1,DATE(YEAR(AL6)+1,1,1),DATE(YEAR(AL6),AM5,1))","v":"1902-07-01"},{"$f":"IF(AN5=1,DATE(YEAR(AM6)+1,1,1),DATE(YEAR(AM6),AN5,1))","v":"1902-08-01"},{"$f":"IF(AO5=1,DATE(YEAR(AN6)+1,1,1),DATE(YEAR(AN6),AO5,1))","v":"1902-09-01"},{"$f":"IF(AP5=1,DATE(YEAR(AO6)+1,1,1),DATE(YEAR(AO6),AP5,1))","v":"1902-10-01"},{"$f":"IF(AQ5=1,DATE(YEAR(AP6)+1,1,1),DATE(YEAR(AP6),AQ5,1))","v":"1902-11-01"},{"$f":"IF(AR5=1,DATE(YEAR(AQ6)+1,1,1),DATE(YEAR(AQ6),AR5,1))","v":"1902-12-01"},{"$f":"IF(AS5=1,DATE(YEAR(AR6)+1,1,1),DATE(YEAR(AR6),AS5,1))","v":"1903-01-01"},{"$f":"IF(AT5=1,DATE(YEAR(AS6)+1,1,1),DATE(YEAR(AS6),AT5,1))","v":"1903-02-01"},{"$f":"IF(AU5=1,DATE(YEAR(AT6)+1,1,1),DATE(YEAR(AT6),AU5,1))","v":"1903-03-01"},{"$f":"IF(AV5=1,DATE(YEAR(AU6)+1,1,1),DATE(YEAR(AU6),AV5,1))","v":"1903-04-01"},{"$f":"IF(AW5=1,DATE(YEAR(AV6)+1,1,1),DATE(YEAR(AV6),AW5,1))","v":"1903-05-01"},{"$f":"IF(AX5=1,DATE(YEAR(AW6)+1,1,1),DATE(YEAR(AW6),AX5,1))","v":"1903-06-01"},{"$f":"IF(AY5=1,DATE(YEAR(AX6)+1,1,1),DATE(YEAR(AX6),AY5,1))","v":"1903-07-01"},{"$f":"IF(AZ5=1,DATE(YEAR(AY6)+1,1,1),DATE(YEAR(AY6),AZ5,1))","v":"1903-08-01"},{"$f":"IF(BA5=1,DATE(YEAR(AZ6)+1,1,1),DATE(YEAR(AZ6),BA5,1))","v":"1903-09-01"},{"$f":"IF(BB5=1,DATE(YEAR(BA6)+1,1,1),DATE(YEAR(BA6),BB5,1))","v":"1903-10-01"},{"$f":"IF(BC5=1,DATE(YEAR(BB6)+1,1,1),DATE(YEAR(BB6),BC5,1))","v":"1903-11-01"},{"$f":"IF(BD5=1,DATE(YEAR(BC6)+1,1,1),DATE(YEAR(BC6),BD5,1))","v":"1903-12-01"},{"$f":"IF(BE5=1,DATE(YEAR(BD6)+1,1,1),DATE(YEAR(BD6),BE5,1))","v":"1904-01-01"},{"$f":"IF(BF5=1,DATE(YEAR(BE6)+1,1,1),DATE(YEAR(BE6),BF5,1))","v":"1904-02-01"},{"$f":"IF(BG5=1,DATE(YEAR(BF6)+1,1,1),DATE(YEAR(BF6),BG5,1))","v":"1904-03-01"},{"$f":"IF(BH5=1,DATE(YEAR(BG6)+1,1,1),DATE(YEAR(BG6),BH5,1))","v":"1904-04-01"},{"$f":"IF(BI5=1,DATE(YEAR(BH6)+1,1,1),DATE(YEAR(BH6),BI5,1))","v":"1904-05-01"},{"$f":"IF(BJ5=1,DATE(YEAR(BI6)+1,1,1),DATE(YEAR(BI6),BJ5,1))","v":"1904-06-01"},{"$f":"IF(BK5=1,DATE(YEAR(BJ6)+1,1,1),DATE(YEAR(BJ6),BK5,1))","v":"1904-07-01"},{"$f":"IF(BL5=1,DATE(YEAR(BK6)+1,1,1),DATE(YEAR(BK6),BL5,1))","v":"1904-08-01"},{"$f":"IF(BM5=1,DATE(YEAR(BL6)+1,1,1),DATE(YEAR(BL6),BM5,1))","v":"1904-09-01"},{"$f":"IF(BN5=1,DATE(YEAR(BM6)+1,1,1),DATE(YEAR(BM6),BN5,1))","v":"1904-10-01"},{"$f":"IF(BO5=1,DATE(YEAR(BN6)+1,1,1),DATE(YEAR(BN6),BO5,1))","v":"1904-11-01"},{"$f":"IF(BP5=1,DATE(YEAR(BO6)+1,1,1),DATE(YEAR(BO6),BP5,1))","v":"1904-12-01"},{"$f":"IF(BQ5=1,DATE(YEAR(BP6)+1,1,1),DATE(YEAR(BP6),BQ5,1))","v":"1905-01-01"},{"$f":"IF(BR5=1,DATE(YEAR(BQ6)+1,1,1),DATE(YEAR(BQ6),BR5,1))","v":"1905-02-01"},{"$f":"IF(BS5=1,DATE(YEAR(BR6)+1,1,1),DATE(YEAR(BR6),BS5,1))","v":"1905-03-01"},{"$f":"IF(BT5=1,DATE(YEAR(BS6)+1,1,1),DATE(YEAR(BS6),BT5,1))","v":"1905-04-01"},{"$f":"IF(BU5=1,DATE(YEAR(BT6)+1,1,1),DATE(YEAR(BT6),BU5,1))","v":"1905-05-01"},{"$f":"IF(BV5=1,DATE(YEAR(BU6)+1,1,1),DATE(YEAR(BU6),BV5,1))","v":"1905-06-01"},{"$f":"IF(BW5=1,DATE(YEAR(BV6)+1,1,1),DATE(YEAR(BV6),BW5,1))","v":"1905-07-01"},{"$f":"IF(BX5=1,DATE(YEAR(BW6)+1,1,1),DATE(YEAR(BW6),BX5,1))","v":"1905-08-01"},{"$f":"IF(BY5=1,DATE(YEAR(BX6)+1,1,1),DATE(YEAR(BX6),BY5,1))","v":"1905-09-01"},{"$f":"IF(BZ5=1,DATE(YEAR(BY6)+1,1,1),DATE(YEAR(BY6),BZ5,1))","v":"1905-10-01"},{"$f":"IF(CA5=1,DATE(YEAR(BZ6)+1,1,1),DATE(YEAR(BZ6),CA5,1))","v":"1905-11-01"},{"$f":"IF(CB5=1,DATE(YEAR(CA6)+1,1,1),DATE(YEAR(CA6),CB5,1))","v":"1905-12-01"},{"$f":"IF(CC5=1,DATE(YEAR(CB6)+1,1,1),DATE(YEAR(CB6),CC5,1))","v":"1906-01-01"},{"$f":"IF(CD5=1,DATE(YEAR(CC6)+1,1,1),DATE(YEAR(CC6),CD5,1))","v":"1906-02-01"},{"$f":"IF(CE5=1,DATE(YEAR(CD6)+1,1,1),DATE(YEAR(CD6),CE5,1))","v":"1906-03-01"},{"$f":"IF(CF5=1,DATE(YEAR(CE6)+1,1,1),DATE(YEAR(CE6),CF5,1))","v":"1906-04-01"},{"$f":"IF(CG5=1,DATE(YEAR(CF6)+1,1,1),DATE(YEAR(CF6),CG5,1))","v":"1906-05-01"},{"$f":"IF(CH5=1,DATE(YEAR(CG6)+1,1,1),DATE(YEAR(CG6),CH5,1))","v":"1906-06-01"},{"$f":"IF(CI5=1,DATE(YEAR(CH6)+1,1,1),DATE(YEAR(CH6),CI5,1))","v":"1906-07-01"},{"$f":"IF(CJ5=1,DATE(YEAR(CI6)+1,1,1),DATE(YEAR(CI6),CJ5,1))","v":"1906-08-01"},{"$f":"IF(CK5=1,DATE(YEAR(CJ6)+1,1,1),DATE(YEAR(CJ6),CK5,1))","v":"1906-09-01"},{"$f":"IF(CL5=1,DATE(YEAR(CK6)+1,1,1),DATE(YEAR(CK6),CL5,1))","v":"1906-10-01"},{"$f":"IF(CM5=1,DATE(YEAR(CL6)+1,1,1),DATE(YEAR(CL6),CM5,1))","v":"1906-11-01"},{"$f":"IF(CN5=1,DATE(YEAR(CM6)+1,1,1),DATE(YEAR(CM6),CN5,1))","v":"1906-12-01"},{"$f":"IF(CO5=1,DATE(YEAR(CN6)+1,1,1),DATE(YEAR(CN6),CO5,1))","v":"1907-01-01"},{"$f":"IF(CP5=1,DATE(YEAR(CO6)+1,1,1),DATE(YEAR(CO6),CP5,1))","v":"1907-02-01"},{"$f":"IF(CQ5=1,DATE(YEAR(CP6)+1,1,1),DATE(YEAR(CP6),CQ5,1))","v":"1907-03-01"},{"$f":"IF(CR5=1,DATE(YEAR(CQ6)+1,1,1),DATE(YEAR(CQ6),CR5,1))","v":"1907-04-01"},{"$f":"IF(CS5=1,DATE(YEAR(CR6)+1,1,1),DATE(YEAR(CR6),CS5,1))","v":"1907-05-01"},{"$f":"IF(CT5=1,DATE(YEAR(CS6)+1,1,1),DATE(YEAR(CS6),CT5,1))","v":"1907-06-01"},{"$f":"IF(CU5=1,DATE(YEAR(CT6)+1,1,1),DATE(YEAR(CT6),CU5,1))","v":"1907-07-01"},{"$f":"IF(CV5=1,DATE(YEAR(CU6)+1,1,1),DATE(YEAR(CU6),CV5,1))","v":"1907-08-01"},{"$f":"IF(CW5=1,DATE(YEAR(CV6)+1,1,1),DATE(YEAR(CV6),CW5,1))","v":"1907-09-01"},{"$f":"IF(CX5=1,DATE(YEAR(CW6)+1,1,1),DATE(YEAR(CW6),CX5,1))","v":"1907-10-01"},{"$f":"IF(CY5=1,DATE(YEAR(CX6)+1,1,1),DATE(YEAR(CX6),CY5,1))","v":"1907-11-01"},{"$f":"IF(CZ5=1,DATE(YEAR(CY6)+1,1,1),DATE(YEAR(CY6),CZ5,1))","v":"1907-12-01"},{"$f":"IF(DA5=1,DATE(YEAR(CZ6)+1,1,1),DATE(YEAR(CZ6),DA5,1))","v":"1908-01-01"},{"$f":"IF(DB5=1,DATE(YEAR(DA6)+1,1,1),DATE(YEAR(DA6),DB5,1))","v":"1908-02-01"},{"$f":"IF(DC5=1,DATE(YEAR(DB6)+1,1,1),DATE(YEAR(DB6),DC5,1))","v":"1908-03-01"},{"$f":"IF(DD5=1,DATE(YEAR(DC6)+1,1,1),DATE(YEAR(DC6),DD5,1))","v":"1908-04-01"},{"$f":"IF(DE5=1,DATE(YEAR(DD6)+1,1,1),DATE(YEAR(DD6),DE5,1))","v":"1908-05-01"},{"$f":"IF(DF5=1,DATE(YEAR(DE6)+1,1,1),DATE(YEAR(DE6),DF5,1))","v":"1908-06-01"},{"$f":"IF(DG5=1,DATE(YEAR(DF6)+1,1,1),DATE(YEAR(DF6),DG5,1))","v":"1908-07-01"},{"$f":"IF(DH5=1,DATE(YEAR(DG6)+1,1,1),DATE(YEAR(DG6),DH5,1))","v":"1908-08-01"},{"$f":"IF(DI5=1,DATE(YEAR(DH6)+1,1,1),DATE(YEAR(DH6),DI5,1))","v":"1908-09-01"},{"$f":"IF(DJ5=1,DATE(YEAR(DI6)+1,1,1),DATE(YEAR(DI6),DJ5,1))","v":"1908-10-01"},{"$f":"IF(DK5=1,DATE(YEAR(DJ6)+1,1,1),DATE(YEAR(DJ6),DK5,1))","v":"1908-11-01"},{"$f":"IF(DL5=1,DATE(YEAR(DK6)+1,1,1),DATE(YEAR(DK6),DL5,1))","v":"1908-12-01"},{"$f":"IF(DM5=1,DATE(YEAR(DL6)+1,1,1),DATE(YEAR(DL6),DM5,1))","v":"1909-01-01"},{"$f":"IF(DN5=1,DATE(YEAR(DM6)+1,1,1),DATE(YEAR(DM6),DN5,1))","v":"1909-02-01"},{"$f":"IF(DO5=1,DATE(YEAR(DN6)+1,1,1),DATE(YEAR(DN6),DO5,1))","v":"1909-03-01"},{"$f":"IF(DP5=1,DATE(YEAR(DO6)+1,1,1),DATE(YEAR(DO6),DP5,1))","v":"1909-04-01"},{"$f":"IF(DQ5=1,DATE(YEAR(DP6)+1,1,1),DATE(YEAR(DP6),DQ5,1))","v":"1909-05-01"},{"$f":"IF(DR5=1,DATE(YEAR(DQ6)+1,1,1),DATE(YEAR(DQ6),DR5,1))","v":"1909-06-01"},{"$f":"IF(DS5=1,DATE(YEAR(DR6)+1,1,1),DATE(YEAR(DR6),DS5,1))","v":"1909-07-01"},{"$f":"IF(DT5=1,DATE(YEAR(DS6)+1,1,1),DATE(YEAR(DS6),DT5,1))","v":"1909-08-01"},{"$f":"IF(DU5=1,DATE(YEAR(DT6)+1,1,1),DATE(YEAR(DT6),DU5,1))","v":"1909-09-01"},{"$f":"IF(DV5=1,DATE(YEAR(DU6)+1,1,1),DATE(YEAR(DU6),DV5,1))","v":"1909-10-01"},{"$f":"IF(DW5=1,DATE(YEAR(DV6)+1,1,1),DATE(YEAR(DV6),DW5,1))","v":"1909-11-01"},{"$f":"IF(DX5=1,DATE(YEAR(DW6)+1,1,1),DATE(YEAR(DW6),DX5,1))","v":"1909-12-01"}]
[null,"Administrative Timeline",null,null,null,null,null,null,null,null,"Expiration Date"]
[null,"For each permit below, enter the permit expiration date. If the expiration date has been administratively extended, note the new expiration date.",null,null,null,null,null,null,null,null,"Integrated Plan Review Window"]
[]
[null,{"$f":"'0. Plan Information'!$D$12","v":0},"Permit","Expiration Date","Single Event","Window",null,null,{"$f":"YEAR(D5)","v":1900},null,null,null,null,null,null,null,null,null,null,null,{"$f":"I10+1","v":1901},null,null,null,null,null,null,null,null,null,null,null,{"$f":"U10+1","v":1902},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG10+1","v":1903},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AS10+1","v":1904},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BE10+1","v":1905},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BQ10+1","v":1906},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CC10+1","v":1907},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CO10+1","v":1908},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DA10+1","v":1909}]
[null,null,null,null,null,"Start Date","End Date",null,"J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D","J","F","M","A","M","J","J","A","S","O","N","D"]
[null,null,{"$f":"CONCATENATE('0. Plan Information'!D14,\", \",\"Permit No. \",'0. Plan Information'!D15)","v":", Permit No. "},null,{"$f":"D12","v":"00:00:00"},null,null,{"$f":"IF(D12>$D$4,\"Permit expires after plan review end date\",\"Permit expires before plan review end date\")","v":"Permit expires before plan review end date"},{"$f":"IF(CONCATENATE(MONTH(I$6),YEAR(I$6))=CONCATENATE(MONTH($E12),YEAR($E12)),1,IF(AND(I$6>=DATE(YEAR($F12),MONTH($F12),1),I$6<=DATE(YEAR($G12),MONTH($G12),1)),2,IF(AND(I$6>=DATE(YEAR($D$3),MONTH($D$3),1),I$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":1},{"$f":"IF(CONCATENATE(MONTH(J$6),YEAR(J$6))=CONCATENATE(MONTH($E12),YEAR($E12)),1,IF(AND(J$6>=DATE(YEAR($F12),MONTH($F12),1),J$6<=DATE(YEAR($G12),MONTH($G12),1)),2,IF(AND(J$6>=DATE(YEAR($D$3),MONTH($D$3),1),J$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},{"$f":"IF(CONCATENATE(MONTH(K$6),YEAR(K$6))=CONCATENATE(MONTH($E12),YEAR($E12)),1,IF(AND(K$6>=DATE(YEAR($F12),MONTH($F12),1),K$6<=DATE(YEAR($G12),MONTH($G12),1)),2,IF(AND(K$6>=DATE(YEAR($D$3),MONTH($D$3),1),K$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(S$6),YEAR(S$6))=CONCATENATE(MONTH($E12),YEAR($E12)),1,IF(AND(S$6>=DATE(YEAR($F12),MONTH($F12),1),S$6<=DATE(YEAR($G12),MONTH($G12),1)),2,IF(AND(S$6>=DATE(YEAR($D$3),MONTH($D$3),1),S$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(Z$6),YEAR(Z$6))=CONCATENATE(MONTH($E12),YEAR($E12)),1,IF(AND(Z$6>=DATE(YEAR($F12),MONTH($F12),1),Z$6<=DATE(YEAR($G12),MONTH($G12),1)),2,IF(AND(Z$6>=DATE(YEAR($D$3),MONTH($D$3),1),Z$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(AL$6),YEAR(AL$6))=CONCATENATE(MONTH($E12),YEAR($E12)),1,IF(AND(AL$6>=DATE(YEAR($F12),MONTH($F12),1),AL$6<=DATE(YEAR($G12),MONTH($G12),1)),2,IF(AND(AL$6>=DATE(YEAR($D$3),MONTH($D$3),1),AL$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(CH$6),YEAR(CH$6))=CONCATENATE(MONTH($E12),YEAR($E12)),1,IF(AND(CH$6>=DATE(YEAR($F12),MONTH($F12),1),CH$6<=DATE(YEAR($G12),MONTH($G12),1)),2,IF(AND(CH$6>=DATE(YEAR($D$3),MONTH($D$3),1),CH$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"CONCATENATE('0. Plan Information'!D20,\", \",\"Permit No. \",'0. Plan Information'!D21)","v":", Permit No. "},null,{"$f":"D13","v":"00:00:00"},null,null,{"$f":"IF(D13>$D$4,\"Permit expires after plan review end date\",\"Permit expires before plan review end date\")","v":"Permit expires before plan review end date"},{"$f":"IF(CONCATENATE(MONTH(I$6),YEAR(I$6))=CONCATENATE(MONTH($E13),YEAR($E13)),1,IF(AND(I$6>=DATE(YEAR($F13),MONTH($F13),1),I$6<=DATE(YEAR($G13),MONTH($G13),1)),2,IF(AND(I$6>=DATE(YEAR($D$3),MONTH($D$3),1),I$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":1},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(V$6),YEAR(V$6))=CONCATENATE(MONTH($E13),YEAR($E13)),1,IF(AND(V$6>=DATE(YEAR($F13),MONTH($F13),1),V$6<=DATE(YEAR($G13),MONTH($G13),1)),2,IF(AND(V$6>=DATE(YEAR($D$3),MONTH($D$3),1),V$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(BF$6),YEAR(BF$6))=CONCATENATE(MONTH($E13),YEAR($E13)),1,IF(AND(BF$6>=DATE(YEAR($F13),MONTH($F13),1),BF$6<=DATE(YEAR($G13),MONTH($G13),1)),2,IF(AND(BF$6>=DATE(YEAR($D$3),MONTH($D$3),1),BF$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"CONCATENATE('0. Plan Information'!D26,\", \",\"Permit No. \",'0. Plan Information'!D27)","v":", Permit No. "},null,"00:00:00",null,null,"Permit expires before plan review end date",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(BE$6),YEAR(BE$6))=CONCATENATE(MONTH($E14),YEAR($E14)),1,IF(AND(BE$6>=DATE(YEAR($F14),MONTH($F14),1),BE$6<=DATE(YEAR($G14),MONTH($G14),1)),2,IF(AND(BE$6>=DATE(YEAR($D$3),MONTH($D$3),1),BE$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,0]
[null,null,{"$f":"CONCATENATE('0. Plan Information'!D32,\", \",\"Permit No. \",'0. Plan Information'!D33)","v":", Permit No. "},null,"00:00:00",null,null,"Permit expires before plan review end date",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(EC14=0,\"\",5)","v":""}]
[null,null,{"$f":"CONCATENATE('0. Plan Information'!D38,\", \",\"Permit No. \",'0. Plan Information'!D39)","v":", Permit No. "},null,"00:00:00",null,null,{"$f":"IF(D16>$D$4,\"Permit expires after plan review end date\",\"Permit expires before plan review end date\")","v":"Permit expires before plan review end date"},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(CY$6),YEAR(CY$6))=CONCATENATE(MONTH($E16),YEAR($E16)),1,IF(AND(CY$6>=DATE(YEAR($F16),MONTH($F16),1),CY$6<=DATE(YEAR($G16),MONTH($G16),1)),2,IF(AND(CY$6>=DATE(YEAR($D$3),MONTH($D$3),1),CY$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(DD$6),YEAR(DD$6))=CONCATENATE(MONTH($E16),YEAR($E16)),1,IF(AND(DD$6>=DATE(YEAR($F16),MONTH($F16),1),DD$6<=DATE(YEAR($G16),MONTH($G16),1)),2,IF(AND(DD$6>=DATE(YEAR($D$3),MONTH($D$3),1),DD$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(DJ$6),YEAR(DJ$6))=CONCATENATE(MONTH($E16),YEAR($E16)),1,IF(AND(DJ$6>=DATE(YEAR($F16),MONTH($F16),1),DJ$6<=DATE(YEAR($G16),MONTH($G16),1)),2,IF(AND(DJ$6>=DATE(YEAR($D$3),MONTH($D$3),1),DJ$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"CONCATENATE('0. Plan Information'!D44,\", \",\"Permit No. \",'0. Plan Information'!D45)","v":", Permit No. "},null,"00:00:00",null,null,"Permit expires before plan review end date",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(AP$6),YEAR(AP$6))=CONCATENATE(MONTH($E17),YEAR($E17)),1,IF(AND(AP$6>=DATE(YEAR($F17),MONTH($F17),1),AP$6<=DATE(YEAR($G17),MONTH($G17),1)),2,IF(AND(AP$6>=DATE(YEAR($D$3),MONTH($D$3),1),AP$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(CONCATENATE(MONTH(DD$6),YEAR(DD$6))=CONCATENATE(MONTH($E17),YEAR($E17)),1,IF(AND(DD$6>=DATE(YEAR($F17),MONTH($F17),1),DD$6<=DATE(YEAR($G17),MONTH($G17),1)),2,IF(AND(DD$6>=DATE(YEAR($D$3),MONTH($D$3),1),DD$6<=DATE(YEAR($D$4),MONTH($D$4),1)),3,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,0,"blank"]
[null,null,null,null,1,"event"]
[null,null,null,null,2,"window","variable"]
[null,null,null,null,3,"plan review"]

{"sheet":"2. Activity Log","index":3,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,7],[0,1,0,6]]}
[null,"Instructions: Select the plan review step from the dropdown and enter the reviewer name, completion date, notes, and whether follow-up with the permittee is needed. If there is follow-up, enter the date and any relevant notes.",null,null,null,null,null,null,"Yes"]
[null,"Activity Log",null,null,null,null,null,null,"No","WW technical review"]
[null,"Review Step","Reviewer Name","Date Complete","Review Notes","Follow-Up Required?","Follow-Up Date","Follow Up Notes",null,"CSO technical review"]
[null,null,null,null,null,null,null,null,null,"SW technical review"]
[null,null,null,null,null,null,null,null,null,"Enforcement"]
[null,null,null,null,null,null,null,null,null,"Management"]
[null,null,null,null,null,null,null,null,null,"Modeling "]
[null,null,null,null,null,null,null,null,null,"Economist"]

{"sheet":"3. Plan Review","index":4,"n_rows":108,"n_cols":7,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,1,0,4],[100,1,100,5],[99,2,99,3],[44,2,44,3],[75,2,75,3],[76,2,76,3],[85,2,85,3],[87,4,87,5],[89,2,89,3],[90,2,90,3],[92,2,97,2],[45,2,55,2],[45,5,55,5],[87,1,87,3],[85,4,85,5],[70,1,70,5],[86,1,86,5],[69,4,69,5],[83,2,83,3],[82,4,83,4],[82,5,83,5],[99,4,99,5],[71,1,71,3],[92,1,97,1],[78,2,78,3],[79,2,79,3],[82,2,82,3],[71,4,71,5],[73,2,73,3],[80,2,80,3],[81,2,81,3],[98,4,98,5],[98,2,98,3],[84,4,84,5],[84,2,84,3],[92,5,97,5],[74,2,74,3],[107,2,107,3],[101,4,101,5],[103,2,103,3],[104,2,104,3],[101,1,101,3],[107,4,107,5],[106,2,106,3],[106,4,106,5],[56,1,61,1],[62,1,67,1],[45,1,55,1],[68,4,68,5],[68,2,68,3],[62,5,67,5],[62,2,67,2],[2,1,2,5],[3,1,3,3],[3,4,3,5],[6,2,6,3],[5,2,5,3],[8,1,12,1],[39,1,39,3],[13,2,13,3],[14,2,14,3],[17,2,17,3],[36,2,36,3],[16,2,16,3],[29,2,35,2],[37,2,37,3],[19,1,19,5],[38,1,38,5],[24,1,28,1],[29,1,35,1],[20,1,20,3],[16,4,16,5],[18,4,18,5],[8,5,12,5],[8,2,12,2],[39,4,39,5],[22,2,22,3],[24,2,28,2],[24,5,28,5],[20,4,20,5],[15,2,15,3],[36,4,36,5],[29,5,35,5],[37,4,37,5],[17,4,17,5],[42,2,42,3],[18,2,18,3],[56,2,61,2],[56,5,61,5],[69,2,69,3],[41,2,41,3]]}
[null,"Instructions: Indicate what information the plan addresses for each element using the dropdowns in the purple tool input cells. Enter additional information to support your determination (e.g., plan page number, description of plan element) in the gray optional input cells. Add any questions specific to your permitting authority in the \"Placeholder\" cells with red text."]
[]
[null,"Element 1: A Description of the Water Quality, Human Health, and Regulatory Issues the Plan Addresses",null,null,null,null,"Yes"]
[null,"Question",null,null,"Answer & Notes",null,"Somewhat"]
[null,"Required Elements",null,null,null,null,"No"]
[{"$f":"E6","v":0},"E1.1","Does the plan include a description of the water quality, public health and regulatory issues to be addressed? If yes, note the plan section to the right."]
[{"$f":"E7","v":0},"E1.2","Does the plan identify multiple current or anticipated Clean Water Act obligations? If yes, note the plan section to the right."]
[null,"Additional Considerations"]
[{"$f":"E9","v":0},"E1.3","What non-Clean Water Act challenges and requirements are mentioned in the plan?","None?"]
[{"$f":"E10","v":0},null,null,"Source water protection?"]
[0,null,null,"Water supply?"]
[0,null,null,"High risk assets?"]
[0,null,null,"Other (describe to the right)?"]
[0,"E1.4","Did the municipality use tools to identify water quality and human health goals and objectives? "]
[null,"E1.5","Did the municipality identify environmental justice concerns?"]
[null,"E1.6","Did the municipality identify sensitive areas?"]
[0,"E1.7","What additional natural resources and locations are mentioned in the plan?"]
[null,"E1.8","[Placeholder: Include any questions specific to your permitting authority here]"]
[0,"E1.9","Are there any additional comments on Element 1?"]
[null,"Element 2: A Description of Existing Wastewater and Stormwater Systems in the Plan and How They Currently Function"]
[null,"Question",null,null,"Answer & Notes"]
[null,"Required Elements"]
[{"$f":"E23","v":0},"E2.1","Does the plan include a description of the existing wastewater and stormwater systems in the plan? If yes, note the plan section to the right."]
[null,"Additional Considerations"]
[0,"E2.2","What systems are characterized (including infrastructure components, capacity, condition, and age)? ","Separate sanitary sewer systems?"]
[0,null,null,"Storm sewer systems?"]
[0,null,null,"Combined sewer systems?"]
[0,null,null,"WWTF?"]
[0,null,null,"Other (describe to the right)?"]
[0,"E2.3","What flows and discharges are characterized? ","Collection system flows?"]
[0,null,null,"Infiltration and inflow?"]
[0,null,null,"Influent WWTF flows?"]
[0,null,null,"Effluent WWTF flows?"]
[0,null,null,"Pollutant loading?"]
[0,null,null,"Water quality sampling data?"]
[0,null,null,"Other (describe to the right)?"]
[null,"E2.4","[Placeholder: Include any questions specific to your permitting authority here]"]
[0,"E2.5","Are there any additional comments on Element 2?"]
[null,"Element 3: A Process for Continuous Stakeholder Engagement During the Planning Process and During Plan Implementation"]
[null,"Question",null,null,"Answer & Notes"]
[null,"Required Elements"]
[0,"E3.1","Does the plan include a process for engaging stakeholders and allowing for public input? If yes, note the plan section to the right."]
[null,"E3.2","Did the municipality involve stakeholders to identify community objectives that became part of the integrated planning goals? If yes, note the plan section to the right."]
[null,"Additional Considerations"]
[null,"E3.3","Were stakeholders included in the project prioritization process?"]
[0,"E3.4","What stakeholders are identified?","Municipal departments?"]
[0,null,null,"Industry?"]
[0,null,null,"Local environmental groups and organizations?"]
[0,null,null,"Other municipalities?"]
[0,null,null,"Municipal consultants?"]
[0,null,null,"Educational groups?"]
[0,null,null,"State and government agencies?"]
[0,null,null,"Residents?"]
[0,null,null,"Public schools?"]
[0,null,null,"Neighborhood/civic associations?"]
[0,null,null,"Other (describe to the right)?"]
[0,"E3.5","What stakeholder motivations are identified? ","Regulatory compliance?"]
[0,null,null,"Financial impacts?"]
[0,null,null,"Recreation opportunities?"]
[0,null,null,"Decrease in flooding?"]
[0,null,null,"Increased fees?"]
[0,null,null,"Other (describe to the right)?"]
[0,"E3.6","What engagement techniques does the plan include? ","Website?"]
[0,null,null,"In-person meetings?"]
[0,null,null,"Recreation opportunities?"]
[0,null,null,"Events?"]
[0,null,null,"Outreach materials?"]
[0,null,null,"Other (describe to the right)?"]
[null,"E3.7","[Placeholder: Include any questions specific to your permitting authority here]"]
[0,"E3.8","Are there any additional comments on Element 3?"]
[null,"Element 4: A Process for Choosing Alternatives and Proposing Implementation Schedules"]
[null,"Question",null,null,"Answer & Notes"]
[null,"Required Elements"]
[0,"E4.1","Are Clean Water Act goals identified in the plan? If yes, note the plan section to the right."]
[{"$f":"E75","v":0},"E4.2","Does the plan present and evaluate one or more alternatives to existing requirements? If yes, note the plan section to the right."]
[{"$f":"E76","v":0},"E4.3","Did the plan include an adequate description of modeling information, calculations, and analyses (i.e., model used, inputs, outputs, assumptions)? If yes, note the plan section to the right."]
[{"$f":"E77","v":0},"E4.4","Does the plan include a financial capability assessment? If yes, note the plan section to the right."]
[null,"Additional Considerations"]
[null,"E4.5","Are non-Clean Water Act goals identified in the plan?"]
[null,"E4.6","Are objectives established for each goal? "]
[0,"E4.7","Does the financial assessment evaluate the  financial burden on ratepayers for both existing requirements and the selected alternative?"]
[{"$f":"E82","v":0},"E4.8","Does the FCA account for other metrics (e.g., drinking water costs, water affordability programs, asset management costs, stormwater management costs, comparisons to county, state, and national data)?"]
[null,"E4.9","Does the plan consider options to lower costs of compliance and reduce or mitigate the financial impact of water service costs on the community’s low-income households?"]
[null,null,"(see FCA Guidance Appendix C for examples and case studies)"]
[null,"E4.10","[Placeholder: Include any questions specific to your permitting authority here]"]
[{"$f":"E86","v":0},"E4.11","Are there any additional comments on Element 4?"]
[null,"Element 5: A Process for Measuring the Success of an Implemented Alternative"]
[null,"Question",null,null,"Answer & Notes"]
[null,"Required Elements"]
[0,"E5.1","Does the plan include a process for measuring the success of an implemented alternative? If yes, note the plan section to the right. "]
[0,"E5.2","Does the plan identify quantifiable targets and milestones? If yes, note the plan section to the right."]
[null,"Additional Considerations"]
[0,"E5.3","What evaluation metrics does the plan identify to measure progress towards the integrated planning goals?","Pollutant load reductions?"]
[0,null,null,"Number of CSOs or SSOs?"]
[0,null,null,"Volume of CSOs or SSOs?"]
[0,null,null,"Acres of disconnected impervious areas?"]
[0,null,null,"Reduction of pollutants in receiving water quality?"]
[0,null,null,"Other (describe to the right)?"]
[null,"E5.4","[Placeholder: Include any questions specific to your permitting authority here]"]
[0,"E5.5","Are there any additional comments on Element 5?"]
[null,"Element 6: A Process to Improve the Plan Over Time by Choosing New or Modified Projects and Implementation Schedules"]
[null,"Question",null,null,"Answer & Notes"]
[null,"Required Elements"]
[0,"E6.1","Does the plan include a process to evaluate planning outcomes over time? If yes, note the plan section to the right."]
[0,"E6.2","Does the modification process ensure that water quality goals will be met through integrated plan implementation? If yes, note the plan section to the right."]
[null,"Additional Considerations"]
[null,"E6.3","[Placeholder: Include any questions specific to your permitting authority here]"]
[0,"E6.4","Are there any additional comments on Element 6?"]

{"sheet":"4. Plan Completeness Summary","index":5,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5],[3,1,3,2],[3,3,3,5],[4,1,4,2],[0,1,0,4]]}
[null,"Instructions: Element completeness cells use the Plan Review tab to summarize how completely the plan addresses each element. Red cells indicate that a required part of an element was not completed. Based on follow up with the permittee, indicate whether the missing information was resolved, including the follow up date and any relevant notes."]
[null,null,null,null,null,null,null,"Yes"]
[null,"Integrated Plan Completeness Summary",null,null,null,null,null,"No"]
[null,"Element Summary",null,"Follow-up"]
[null,"Element Completeness",null,"Resolved?","Resolved Date","Resolved Notes",null,null,"Blank","Yes","Somewhat","No","Blank, Somewhat and No"]
[null,"Element 1: Describing Requirements and Drivers",{"$f":"IF(AND(J6=\"\",K6=\"\",L6=\"\"),\"\",IF(AND(I6=\"\",K6=\"\",L6=\"\"),\"All required elements have been addressed.\",IF(M6<>\"\",CONCATENATE(\"Element(s) \",M6,\" must still be addressed.\"),\"\")))","v":""},null,null,null,null,"E6:E7",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E6:E7=\"\",'3. Plan Review'!B6:B7,\"\"))","v":"E1.1, E1.2"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E6:E7=\"Yes\",'3. Plan Review'!B6:B7,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E6:E7=\"Somewhat\",'3. Plan Review'!B6:B7,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E6:E7=\"No\",'3. Plan Review'!B6:B7,\"\"))","v":""},{"$f":"IF(AND(I6=\"\",K6=\"\"),L6,IF(AND(I6=\"\",L6=\"\"),K6,IF(AND(K6=\"\",L6=\"\"),I6,IF(I6=\"\",CONCATENATE(K6,\", \",L6),IF(K6=\"\",CONCATENATE(I6,\", \",L6),IF(L6=\"\",CONCATENATE(I6,\", \",K6),CONCATENATE(I6,\", \",K6,\", \",L6)))))))","v":"E1.1, E1.2"}]
[null,"Element 2: Characterizing Systems ",{"$f":"IF(AND(J7=\"\",K7=\"\",L7=\"\"),\"\",IF(AND(I7=\"\",K7=\"\",L7=\"\"),\"All required elements have been addressed.\",IF(M7<>\"\",CONCATENATE(\"Element(s) \",M7,\" must still be addressed.\"),\"\")))","v":""},null,null,null,null,"E23",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E23=\"\",'3. Plan Review'!B23,\"\"))","v":"E2.1"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E23=\"Yes\",'3. Plan Review'!B23,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E23=\"Somewhat\",'3. Plan Review'!B23,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E23=\"No\",'3. Plan Review'!B23,\"\"))","v":""},{"$f":"IF(AND(I7=\"\",K7=\"\"),L7,IF(AND(I7=\"\",L7=\"\"),K7,IF(AND(K7=\"\",L7=\"\"),I7,IF(I7=\"\",CONCATENATE(K7,\", \",L7),IF(K7=\"\",CONCATENATE(I7,\", \",L7),IF(L7=\"\",CONCATENATE(I7,\", \",K7),CONCATENATE(I7,\", \",K7,\", \",L7)))))))","v":"E2.1"}]
[null,"Element 3: Engaging Stakeholders","",null,null,null,null,"E42:E43",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E42:E43=\"\",'3. Plan Review'!B42:B43,\"\"))","v":"E3.1, E3.2"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E42:E43=\"Yes\",'3. Plan Review'!B42:B43,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E42:E43=\"Somewhat\",'3. Plan Review'!B42:B43,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E42:E43=\"No\",'3. Plan Review'!B42:B43,\"\"))","v":""},"E3.1, E3.2"]
[null,"Element 4: Developing and Selecting Alternatives","",null,null,null,null,"E74:E77",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E74:E77=\"\",'3. Plan Review'!B74:B77,\"\"))","v":"E4.1, E4.2, E4.3, E4.4"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E74:E77=\"Yes\",'3. Plan Review'!B74:B77,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E74:E77=\"Somewhat\",'3. Plan Review'!B74:B77,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E74:E77=\"No\",'3. Plan Review'!B74:B77,\"\"))","v":""},"E4.1, E4.2, E4.3, E4.4"]
[null,"Element 5: Measuring Performance","",null,null,null,null,"E89:E90",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E90:E91=\"\",'3. Plan Review'!B90:B91,\"\"))","v":"E5.1, E5.2"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E90:E91=\"Yes\",'3. Plan Review'!B90:B91,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E90:E91=\"Somewhat\",'3. Plan Review'!B90:B91,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E90:E91=\"No\",'3. Plan Review'!B90:B91,\"\"))","v":""},"E5.1, E5.2"]
[null,"Element 6: Adapting for Success","",null,null,null,null,"E103:E104",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E104:E105=\"\",'3. Plan Review'!B104:B105,\"\"))","v":"E6.1, E6.2"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E104:E105=\"Yes\",'3. Plan Review'!B104:B105,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E104:E105=\"Somewhat\",'3. Plan Review'!B104:B105,\"\"))","v":""},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF('3. Plan Review'!E104:E105=\"No\",'3. Plan Review'!B104:B105,\"\"))","v":""},"E6.1, E6.2"]

{"sheet":"5. Adequacy Summary","index":6,"n_rows":92,"n_cols":10,"rows_kept":92,"cut":false,"hidden":false,"merged":[[67,4,67,5],[68,4,68,5],[69,4,69,5],[70,4,70,5],[71,4,71,5],[60,4,60,5],[61,4,61,5],[62,4,62,5],[63,4,63,5],[64,4,64,5],[53,4,53,5],[54,4,54,5],[55,4,55,5],[56,4,56,5],[57,4,57,5],[48,1,48,7],[49,1,49,3],[49,4,49,7],[50,1,50,2],[50,4,50,5],[22,4,22,5],[23,4,23,5],[45,4,45,5],[46,4,46,5],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[35,4,35,5],[39,4,39,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[4,4,4,5],[7,4,7,5],[4,1,4,2],[18,4,18,5],[21,4,21,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[87,1,87,7],[88,1,88,3],[88,4,88,7],[89,1,89,3],[91,1,91,3],[89,5,89,7],[91,5,91,7],[90,1,90,3],[90,5,90,7],[82,1,82,3],[86,5,86,7],[86,1,86,3],[83,1,83,3],[84,1,84,3],[82,5,82,7],[83,5,83,7],[84,5,84,7],[85,1,85,3],[85,5,85,7],[78,1,78,3],[76,1,76,3],[77,1,77,3],[81,4,81,7],[79,4,79,7],[80,1,80,7],[81,1,81,3],[79,1,79,3],[78,4,78,7],[77,4,77,7],[0,1,0,6],[75,4,75,7],[76,4,76,7],[36,4,36,5],[37,4,37,5],[38,4,38,5],[75,1,75,3],[73,1,73,7],[74,4,74,7],[74,1,74,3],[24,4,24,5],[25,4,25,5],[28,4,28,5],[2,1,2,7],[3,1,3,3],[3,4,3,7]]}
[null,"Instructions: Enter information from the plan about proposed outcomes, revised compliance deadlines, and the permittee justification in purple tool input cells. Note that the Plan Outcome Adequacy table is populated based on the compliance requirements entered in the Plan Information tab. Use the optional questions under Water Quality Objectives to elaborate on the justification for an integrated approach to permit compliance. Add any questions specific to your permitting authority in the \"Placeholder\" cells with red text. "]
[]
[null,"Plan Outcome Adequacy - Permit Requirements",null,null,null,null,null,null,"Yes","Yes"]
[null,"Original Permit Requirements",null,null,"Proposed Integrated Plan Outcome",null,null,null,"Somewhat","No"]
[null,"Original Compliance Requirement",null,"Original Compliance Deadline","Proposed Plan Outcome",null,"Proposed  Compliance Deadline","Permittee Justification for Adjustment","No"]
[]
[{"$f":"IF(C8=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "}]
[{"$f":"IF(C8=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G14=\"\",\"\",'0. Plan Information'!G14)","v":""},{"$f":"IF('0. Plan Information'!H14=\"\",\"\",'0. Plan Information'!H14)","v":""}]
[{"$f":"IF(C9=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G15=\"\",\"\",'0. Plan Information'!G15)","v":""},{"$f":"IF('0. Plan Information'!H15=\"\",\"\",'0. Plan Information'!H15)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G16=\"\",\"\",'0. Plan Information'!G16)","v":""},{"$f":"IF('0. Plan Information'!H16=\"\",\"\",'0. Plan Information'!H16)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G17=\"\",\"\",'0. Plan Information'!G17)","v":""},{"$f":"IF('0. Plan Information'!H17=\"\",\"\",'0. Plan Information'!H17)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G18=\"\",\"\",'0. Plan Information'!G18)","v":""},{"$f":"IF('0. Plan Information'!H18=\"\",\"\",'0. Plan Information'!H18)","v":""}]
[{"$f":"SUM(A7:A11)","v":0}]
[{"$f":"IF(C15=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$13","v":", Permit No. "}]
[{"$f":"IF(C15=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$13","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G20=\"\",\"\",'0. Plan Information'!G20)","v":""},{"$f":"IF('0. Plan Information'!H20=\"\",\"\",'0. Plan Information'!H20)","v":""}]
[{"$f":"IF(C16=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$13","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G21=\"\",\"\",'0. Plan Information'!G21)","v":""},{"$f":"IF('0. Plan Information'!H21=\"\",\"\",'0. Plan Information'!H21)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$13","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G22=\"\",\"\",'0. Plan Information'!G22)","v":""},{"$f":"IF('0. Plan Information'!H22=\"\",\"\",'0. Plan Information'!H22)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$13","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G23=\"\",\"\",'0. Plan Information'!G23)","v":""},{"$f":"IF('0. Plan Information'!H23=\"\",\"\",'0. Plan Information'!H23)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$13","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G24=\"\",\"\",'0. Plan Information'!G24)","v":""},{"$f":"IF('0. Plan Information'!H24=\"\",\"\",'0. Plan Information'!H24)","v":""}]
[{"$f":"SUM(A14:A18)","v":0}]
[{"$f":"IF(C22=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$14","v":", Permit No. "}]
[{"$f":"IF(C22=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$14","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G26=\"\",\"\",'0. Plan Information'!G26)","v":""},{"$f":"IF('0. Plan Information'!H26=\"\",\"\",'0. Plan Information'!H26)","v":""}]
[{"$f":"IF(C23=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$14","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G27=\"\",\"\",'0. Plan Information'!G27)","v":""},{"$f":"IF('0. Plan Information'!H27=\"\",\"\",'0. Plan Information'!H27)","v":""}]
[{"$f":"IF(C24=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$14","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G28=\"\",\"\",'0. Plan Information'!G28)","v":""},{"$f":"IF('0. Plan Information'!H28=\"\",\"\",'0. Plan Information'!H28)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$14","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G29=\"\",\"\",'0. Plan Information'!G29)","v":""},{"$f":"IF('0. Plan Information'!H29=\"\",\"\",'0. Plan Information'!H29)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$14","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G30=\"\",\"\",'0. Plan Information'!G30)","v":""},{"$f":"IF('0. Plan Information'!H30=\"\",\"\",'0. Plan Information'!H30)","v":""}]
[{"$f":"SUM(A21:A25)","v":0}]
[{"$f":"IF(C29=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$15","v":", Permit No. "}]
[{"$f":"IF(C29=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$15","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G32=\"\",\"\",'0. Plan Information'!G32)","v":""},{"$f":"IF('0. Plan Information'!H32=\"\",\"\",'0. Plan Information'!H32)","v":""}]
[{"$f":"IF(C30=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$15","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G33=\"\",\"\",'0. Plan Information'!G33)","v":""},{"$f":"IF('0. Plan Information'!H33=\"\",\"\",'0. Plan Information'!H33)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$15","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G34=\"\",\"\",'0. Plan Information'!G34)","v":""},{"$f":"IF('0. Plan Information'!H34=\"\",\"\",'0. Plan Information'!H34)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$15","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G35=\"\",\"\",'0. Plan Information'!G35)","v":""},{"$f":"IF('0. Plan Information'!H35=\"\",\"\",'0. Plan Information'!H35)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$15","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G36=\"\",\"\",'0. Plan Information'!G36)","v":""},{"$f":"IF('0. Plan Information'!H36=\"\",\"\",'0. Plan Information'!H36)","v":""}]
[{"$f":"SUM(A28:A32)","v":0}]
[{"$f":"IF(C36=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$16","v":", Permit No. "}]
[{"$f":"IF(C36=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$16","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G38=\"\",\"\",'0. Plan Information'!G38)","v":""},{"$f":"IF('0. Plan Information'!H38=\"\",\"\",'0. Plan Information'!H38)","v":""}]
[{"$f":"IF(C37=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$16","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G39=\"\",\"\",'0. Plan Information'!G39)","v":""},{"$f":"IF('0. Plan Information'!H39=\"\",\"\",'0. Plan Information'!H39)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$16","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G40=\"\",\"\",'0. Plan Information'!G40)","v":""},{"$f":"IF('0. Plan Information'!H40=\"\",\"\",'0. Plan Information'!H40)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$16","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G41=\"\",\"\",'0. Plan Information'!G41)","v":""},{"$f":"IF('0. Plan Information'!H41=\"\",\"\",'0. Plan Information'!H41)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$16","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G42=\"\",\"\",'0. Plan Information'!G42)","v":""},{"$f":"IF('0. Plan Information'!H42=\"\",\"\",'0. Plan Information'!H42)","v":""}]
[{"$f":"SUM(A35:A39)","v":0}]
[{"$f":"IF(C43=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$17","v":", Permit No. "}]
[{"$f":"IF(C43=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$17","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G44=\"\",\"\",'0. Plan Information'!G44)","v":""},{"$f":"IF('0. Plan Information'!H44=\"\",\"\",'0. Plan Information'!H44)","v":""}]
[{"$f":"IF(C44=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$17","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G45=\"\",\"\",'0. Plan Information'!G45)","v":""},{"$f":"IF('0. Plan Information'!H45=\"\",\"\",'0. Plan Information'!H45)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$17","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G46=\"\",\"\",'0. Plan Information'!G46)","v":""},{"$f":"IF('0. Plan Information'!H46=\"\",\"\",'0. Plan Information'!H46)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$17","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G47=\"\",\"\",'0. Plan Information'!G47)","v":""},{"$f":"IF('0. Plan Information'!H47=\"\",\"\",'0. Plan Information'!H47)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$17","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G48=\"\",\"\",'0. Plan Information'!G48)","v":""},{"$f":"IF('0. Plan Information'!H48=\"\",\"\",'0. Plan Information'!H48)","v":""}]
[{"$f":"SUM(A42:A46)","v":0}]
[null,"Plan Outcome Adequacy - Enforcement Requirements",null,null,null,null,null,null,"Yes","Yes"]
[null,"Original Enforcement Requirements",null,null,"Proposed Integrated Plan Outcome",null,null,null,"Somewhat","No"]
[null,"Original Compliance Requirement",null,"Original Compliance Deadline","Proposed Plan Outcome",null,"Proposed  Compliance Deadline","Permittee Justification for Adjustment","No"]
[]
[{"$f":"IF(C54=\"\",0,1)","v":0},{"$f":"CONCATENATE(\"Enforcement Mechanism 1: \",'0. Plan Information'!D53)","v":"Enforcement Mechanism 1: "}]
[{"$f":"IF(C54=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G53=\"\",\"\",'0. Plan Information'!G53)","v":""},{"$f":"IF('0. Plan Information'!H53=\"\",\"\",'0. Plan Information'!H53)","v":""}]
[{"$f":"IF(C55=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G54=\"\",\"\",'0. Plan Information'!G54)","v":""},{"$f":"IF('0. Plan Information'!H54=\"\",\"\",'0. Plan Information'!H54)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G55=\"\",\"\",'0. Plan Information'!G55)","v":""},{"$f":"IF('0. Plan Information'!H55=\"\",\"\",'0. Plan Information'!H55)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G56=\"\",\"\",'0. Plan Information'!G56)","v":""},{"$f":"IF('0. Plan Information'!H56=\"\",\"\",'0. Plan Information'!H56)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G57=\"\",\"\",'0. Plan Information'!G57)","v":""},{"$f":"IF('0. Plan Information'!H57=\"\",\"\",'0. Plan Information'!H57)","v":""}]
[{"$f":"SUM(A53:A57)","v":0}]
[{"$f":"IF(C61=\"\",0,1)","v":0},{"$f":"CONCATENATE(\"Enforcement Mechanism 2: \",'0. Plan Information'!D59)","v":"Enforcement Mechanism 2: "}]
[{"$f":"IF(C61=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G59=\"\",\"\",'0. Plan Information'!G59)","v":""},{"$f":"IF('0. Plan Information'!H59=\"\",\"\",'0. Plan Information'!H59)","v":""}]
[{"$f":"IF(C62=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G60=\"\",\"\",'0. Plan Information'!G60)","v":""},{"$f":"IF('0. Plan Information'!H60=\"\",\"\",'0. Plan Information'!H60)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G61=\"\",\"\",'0. Plan Information'!G61)","v":""},{"$f":"IF('0. Plan Information'!H61=\"\",\"\",'0. Plan Information'!H61)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G62=\"\",\"\",'0. Plan Information'!G62)","v":""},{"$f":"IF('0. Plan Information'!H62=\"\",\"\",'0. Plan Information'!H62)","v":""}]
[{"$f":"IF(C65=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G63=\"\",\"\",'0. Plan Information'!G63)","v":""},{"$f":"IF('0. Plan Information'!H63=\"\",\"\",'0. Plan Information'!H63)","v":""}]
[{"$f":"SUM(A60:A64)","v":0}]
[{"$f":"IF(C68=\"\",0,1)","v":0},{"$f":"CONCATENATE(\"Enforcement Mechanism 3: \",'0. Plan Information'!D65)","v":"Enforcement Mechanism 3: "}]
[{"$f":"IF(C68=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G65=\"\",\"\",'0. Plan Information'!G65)","v":""},{"$f":"IF('0. Plan Information'!H65=\"\",\"\",'0. Plan Information'!H65)","v":""}]
[{"$f":"IF(C69=\"\",0,1)","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G66=\"\",\"\",'0. Plan Information'!G66)","v":""},{"$f":"IF('0. Plan Information'!H66=\"\",\"\",'0. Plan Information'!H66)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G67=\"\",\"\",'0. Plan Information'!G67)","v":""},{"$f":"IF('0. Plan Information'!H67=\"\",\"\",'0. Plan Information'!H67)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G68=\"\",\"\",'0. Plan Information'!G68)","v":""},{"$f":"IF('0. Plan Information'!H68=\"\",\"\",'0. Plan Information'!H68)","v":""}]
[0,{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF('0. Plan Information'!G69=\"\",\"\",'0. Plan Information'!G69)","v":""},{"$f":"IF('0. Plan Information'!H69=\"\",\"\",'0. Plan Information'!H69)","v":""}]
[{"$f":"SUM(A67:A71)","v":0}]
[null,"Water Quality Objectives"]
[null,"Question",null,null,"Answer & Notes"]
[null,"How were alternatives evaluated?"]
[null,"How were alternatives prioritized?"]
[null,"Do model outputs demonstrate that the selected alternative will achieve the same or better water quality outcomes?"]
[null,"Will the plan's selected alternative achieve additional environmental or human health benefits that would not be realized though existing, required projects only?"]
[null,"[Placeholder: Include any questions specific to your permitting authority here]"]
[null,"Non-CWA Outcomes"]
[null,"Question",null,null,"Answer & Notes"]
[null,"Does the proposed alternative incorporate green infrastructure?"]
[null,"Does the proposed alternative improve infrastructure resiliency?"]
[null,"Does the proposed alternative address environmental justice concerns?"]
[null,"Does the proposed alternative protect drinking water source waters?"]
[null,"Are other non-CWA outcomes predicted by the proposed alternative?"]
[null,"Financial Outcomes"]
[null,"Question",null,null,"Answer & Notes"]
[null,"Will the alternative be cheaper? "]
[null,"Will the alternative require that rates be increased more slowly over time? "]
[null,"[Placeholder: Include any questions specific to your permitting authority here]"]

{"sheet":"6. Evaluation Summary","index":7,"n_rows":81,"n_cols":8,"rows_kept":81,"cut":false,"hidden":false,"merged":[[57,1,57,3],[57,4,57,7],[58,1,58,2],[0,1,0,7],[10,1,10,3],[11,1,11,3],[12,4,12,7],[12,1,12,3],[9,4,9,7],[13,1,13,2],[10,4,10,7],[11,4,11,7],[5,1,5,7],[2,1,2,7],[3,1,3,3],[4,1,4,3],[8,1,8,3],[9,1,9,3],[7,4,7,7],[8,4,8,7],[3,4,3,7],[4,4,4,7],[6,4,6,7],[6,1,6,3],[7,1,7,3]]}
[null,"Instructions: Review the plan completeness summary along with the proposed integrated plan outcome. Once determined, input the final state decision and relevant notes for recordkeeping purposes. Each compliance requirement does not have to have an independent decision; if needed, put \"N/A\"."]
[]
[null,"Basic Plan Information"]
[null,"Permittee Name",null,null,{"$f":"IF(ISBLANK('0. Plan Information'!$D$4),\"\",'0. Plan Information'!$D$4)","v":""}]
[null,"Plan Name",null,null,{"$f":"IF(ISBLANK('0. Plan Information'!$D$4),\"\",'0. Plan Information'!$D$5)","v":""}]
[null,"Integrated Plan Completeness Summary"]
[null,"Element 1: Describing Requirements and Drivers",null,null,{"$f":"IF('4. Plan Completeness Summary'!C6=\"All required elements have been addressed.\",\"All required elements have been addressed.\",IF('4. Plan Completeness Summary'!D6=\"Yes\",\"Some elements were originally found to be lacking, but have since been fully resolved.\",'4. Plan Completeness Summary'!C6))","v":""}]
[null,"Element 2: Characterizing Systems ",null,null,{"$f":"IF('4. Plan Completeness Summary'!C7=\"All required elements have been addressed.\",\"All required elements have been addressed.\",IF('4. Plan Completeness Summary'!D7=\"Yes\",\"Some elements were originally found to be lacking, but have since been fully resolved.\",'4. Plan Completeness Summary'!C7))","v":""}]
[null,"Element 3: Engaging Stakeholders",null,null,{"$f":"IF('4. Plan Completeness Summary'!C8=\"All required elements have been addressed.\",\"All required elements have been addressed.\",IF('4. Plan Completeness Summary'!D8=\"Yes\",\"Some elements were originally found to be lacking, but have since been fully resolved.\",'4. Plan Completeness Summary'!C8))","v":""}]
[null,"Element 4: Developing and Selecting Alternatives",null,null,{"$f":"IF('4. Plan Completeness Summary'!C9=\"All required elements have been addressed.\",\"All required elements have been addressed.\",IF('4. Plan Completeness Summary'!D9=\"Yes\",\"Some elements were originally found to be lacking, but have since been fully resolved.\",'4. Plan Completeness Summary'!C9))","v":""}]
[null,"Element 5: Measuring Performance",null,null,{"$f":"IF('4. Plan Completeness Summary'!C10=\"All required elements have been addressed.\",\"All required elements have been addressed.\",IF('4. Plan Completeness Summary'!D10=\"Yes\",\"Some elements were originally found to be lacking, but have since been fully resolved.\",'4. Plan Completeness Summary'!C10))","v":""}]
[null,"Element 6: Adapting for Success",null,null,{"$f":"IF('4. Plan Completeness Summary'!C11=\"All required elements have been addressed.\",\"All required elements have been addressed.\",IF('4. Plan Completeness Summary'!D11=\"Yes\",\"Some elements were originally found to be lacking, but have since been fully resolved.\",'4. Plan Completeness Summary'!C11))","v":""}]
[null,"Original Permit Compliance Requirements",null,null,"Proposed Integrated Plan Outcome"]
[null,"Original Compliance Requirement",null,"Original Compliance Deadline","Proposed Plan Outcome","Proposed  Compliance Deadline","Permittee Justification for Adjustment","State Decision and Notes"]
[]
[{"$f":"'5. Adequacy Summary'!A7","v":0},{"$f":"'5. Adequacy Summary'!B7","v":", Permit No. "}]
[{"$f":"'5. Adequacy Summary'!A8","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C8),\"\",'5. Adequacy Summary'!C8)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D8),\"\",'5. Adequacy Summary'!D8)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E8),\"\",'5. Adequacy Summary'!E8)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F8),\"\",'5. Adequacy Summary'!F8)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G8),\"\",'5. Adequacy Summary'!G8)","v":""}]
[{"$f":"'5. Adequacy Summary'!A9","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C9),\"\",'5. Adequacy Summary'!C9)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D9),\"\",'5. Adequacy Summary'!D9)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E9),\"\",'5. Adequacy Summary'!E9)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F9),\"\",'5. Adequacy Summary'!F9)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G9),\"\",'5. Adequacy Summary'!G9)","v":""}]
[{"$f":"'5. Adequacy Summary'!A10","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C10),\"\",'5. Adequacy Summary'!C10)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D10),\"\",'5. Adequacy Summary'!D10)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E10),\"\",'5. Adequacy Summary'!E10)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F10),\"\",'5. Adequacy Summary'!F10)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G10),\"\",'5. Adequacy Summary'!G10)","v":""}]
[{"$f":"'5. Adequacy Summary'!A11","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C11),\"\",'5. Adequacy Summary'!C11)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D11),\"\",'5. Adequacy Summary'!D11)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E11),\"\",'5. Adequacy Summary'!E11)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F11),\"\",'5. Adequacy Summary'!F11)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G11),\"\",'5. Adequacy Summary'!G11)","v":""}]
[{"$f":"'5. Adequacy Summary'!A12","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C12),\"\",'5. Adequacy Summary'!C12)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D12),\"\",'5. Adequacy Summary'!D12)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E12),\"\",'5. Adequacy Summary'!E12)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F12),\"\",'5. Adequacy Summary'!F12)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G12),\"\",'5. Adequacy Summary'!G12)","v":""}]
[{"$f":"'5. Adequacy Summary'!A13","v":0}]
[{"$f":"'5. Adequacy Summary'!A14","v":0},{"$f":"'5. Adequacy Summary'!B14","v":", Permit No. "}]
[{"$f":"'5. Adequacy Summary'!A15","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C15),\"\",'5. Adequacy Summary'!C15)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D15),\"\",'5. Adequacy Summary'!D15)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E15),\"\",'5. Adequacy Summary'!E15)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F15),\"\",'5. Adequacy Summary'!F15)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G15),\"\",'5. Adequacy Summary'!G15)","v":""}]
[{"$f":"'5. Adequacy Summary'!A16","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C16),\"\",'5. Adequacy Summary'!C16)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D16),\"\",'5. Adequacy Summary'!D16)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E16),\"\",'5. Adequacy Summary'!E16)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F16),\"\",'5. Adequacy Summary'!F16)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G16),\"\",'5. Adequacy Summary'!G16)","v":""}]
[{"$f":"'5. Adequacy Summary'!A17","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C17),\"\",'5. Adequacy Summary'!C17)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D17),\"\",'5. Adequacy Summary'!D17)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E17),\"\",'5. Adequacy Summary'!E17)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F17),\"\",'5. Adequacy Summary'!F17)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G17),\"\",'5. Adequacy Summary'!G17)","v":""}]
[{"$f":"'5. Adequacy Summary'!A18","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C18),\"\",'5. Adequacy Summary'!C18)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D18),\"\",'5. Adequacy Summary'!D18)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E18),\"\",'5. Adequacy Summary'!E18)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F18),\"\",'5. Adequacy Summary'!F18)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G18),\"\",'5. Adequacy Summary'!G18)","v":""}]
[{"$f":"'5. Adequacy Summary'!A19","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C19),\"\",'5. Adequacy Summary'!C19)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D19),\"\",'5. Adequacy Summary'!D19)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E19),\"\",'5. Adequacy Summary'!E19)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F19),\"\",'5. Adequacy Summary'!F19)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G19),\"\",'5. Adequacy Summary'!G19)","v":""}]
[{"$f":"'5. Adequacy Summary'!A20","v":0}]
[{"$f":"'5. Adequacy Summary'!A21","v":0},{"$f":"'5. Adequacy Summary'!B21","v":", Permit No. "}]
[{"$f":"'5. Adequacy Summary'!A22","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C22),\"\",'5. Adequacy Summary'!C22)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D22),\"\",'5. Adequacy Summary'!D22)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E22),\"\",'5. Adequacy Summary'!E22)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F22),\"\",'5. Adequacy Summary'!F22)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G22),\"\",'5. Adequacy Summary'!G22)","v":""}]
[{"$f":"'5. Adequacy Summary'!A23","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C23),\"\",'5. Adequacy Summary'!C23)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D23),\"\",'5. Adequacy Summary'!D23)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E23),\"\",'5. Adequacy Summary'!E23)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F23),\"\",'5. Adequacy Summary'!F23)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G23),\"\",'5. Adequacy Summary'!G23)","v":""}]
[{"$f":"'5. Adequacy Summary'!A24","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C24),\"\",'5. Adequacy Summary'!C24)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D24),\"\",'5. Adequacy Summary'!D24)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E24),\"\",'5. Adequacy Summary'!E24)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F24),\"\",'5. Adequacy Summary'!F24)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G24),\"\",'5. Adequacy Summary'!G24)","v":""}]
[{"$f":"'5. Adequacy Summary'!A25","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C25),\"\",'5. Adequacy Summary'!C25)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D25),\"\",'5. Adequacy Summary'!D25)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E25),\"\",'5. Adequacy Summary'!E25)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F25),\"\",'5. Adequacy Summary'!F25)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G25),\"\",'5. Adequacy Summary'!G25)","v":""}]
[{"$f":"'5. Adequacy Summary'!A26","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C26),\"\",'5. Adequacy Summary'!C26)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D26),\"\",'5. Adequacy Summary'!D26)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E26),\"\",'5. Adequacy Summary'!E26)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F26),\"\",'5. Adequacy Summary'!F26)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G26),\"\",'5. Adequacy Summary'!G26)","v":""}]
[{"$f":"'5. Adequacy Summary'!A27","v":0}]
[{"$f":"'5. Adequacy Summary'!A28","v":0},{"$f":"'5. Adequacy Summary'!B28","v":", Permit No. "}]
[{"$f":"'5. Adequacy Summary'!A29","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C29),\"\",'5. Adequacy Summary'!C29)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D29),\"\",'5. Adequacy Summary'!D29)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E29),\"\",'5. Adequacy Summary'!E29)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F29),\"\",'5. Adequacy Summary'!F29)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G29),\"\",'5. Adequacy Summary'!G29)","v":""}]
[{"$f":"'5. Adequacy Summary'!A30","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C30),\"\",'5. Adequacy Summary'!C30)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D30),\"\",'5. Adequacy Summary'!D30)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E30),\"\",'5. Adequacy Summary'!E30)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F30),\"\",'5. Adequacy Summary'!F30)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G30),\"\",'5. Adequacy Summary'!G30)","v":""}]
[{"$f":"'5. Adequacy Summary'!A31","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C31),\"\",'5. Adequacy Summary'!C31)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D31),\"\",'5. Adequacy Summary'!D31)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E31),\"\",'5. Adequacy Summary'!E31)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F31),\"\",'5. Adequacy Summary'!F31)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G31),\"\",'5. Adequacy Summary'!G31)","v":""}]
[{"$f":"'5. Adequacy Summary'!A32","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C32),\"\",'5. Adequacy Summary'!C32)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D32),\"\",'5. Adequacy Summary'!D32)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E32),\"\",'5. Adequacy Summary'!E32)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F32),\"\",'5. Adequacy Summary'!F32)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G32),\"\",'5. Adequacy Summary'!G32)","v":""}]
[{"$f":"'5. Adequacy Summary'!A33","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C33),\"\",'5. Adequacy Summary'!C33)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D33),\"\",'5. Adequacy Summary'!D33)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E33),\"\",'5. Adequacy Summary'!E33)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F33),\"\",'5. Adequacy Summary'!F33)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G33),\"\",'5. Adequacy Summary'!G33)","v":""}]
[{"$f":"'5. Adequacy Summary'!A34","v":0}]
[{"$f":"'5. Adequacy Summary'!A35","v":0},{"$f":"'5. Adequacy Summary'!B35","v":", Permit No. "}]
[{"$f":"'5. Adequacy Summary'!A36","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C36),\"\",'5. Adequacy Summary'!C36)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D36),\"\",'5. Adequacy Summary'!D36)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E36),\"\",'5. Adequacy Summary'!E36)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F36),\"\",'5. Adequacy Summary'!F36)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G36),\"\",'5. Adequacy Summary'!G36)","v":""}]
[{"$f":"'5. Adequacy Summary'!A37","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C37),\"\",'5. Adequacy Summary'!C37)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D37),\"\",'5. Adequacy Summary'!D37)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E37),\"\",'5. Adequacy Summary'!E37)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F37),\"\",'5. Adequacy Summary'!F37)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G37),\"\",'5. Adequacy Summary'!G37)","v":""}]
[{"$f":"'5. Adequacy Summary'!A38","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C38),\"\",'5. Adequacy Summary'!C38)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D38),\"\",'5. Adequacy Summary'!D38)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E38),\"\",'5. Adequacy Summary'!E38)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F38),\"\",'5. Adequacy Summary'!F38)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G38),\"\",'5. Adequacy Summary'!G38)","v":""}]
[{"$f":"'5. Adequacy Summary'!A39","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C39),\"\",'5. Adequacy Summary'!C39)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D39),\"\",'5. Adequacy Summary'!D39)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E39),\"\",'5. Adequacy Summary'!E39)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F39),\"\",'5. Adequacy Summary'!F39)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G39),\"\",'5. Adequacy Summary'!G39)","v":""}]
[{"$f":"'5. Adequacy Summary'!A40","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C40),\"\",'5. Adequacy Summary'!C40)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D40),\"\",'5. Adequacy Summary'!D40)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E40),\"\",'5. Adequacy Summary'!E40)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F40),\"\",'5. Adequacy Summary'!F40)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G40),\"\",'5. Adequacy Summary'!G40)","v":""}]
[{"$f":"'5. Adequacy Summary'!A41","v":0}]
[{"$f":"'5. Adequacy Summary'!A42","v":0},{"$f":"'5. Adequacy Summary'!B42","v":", Permit No. "}]
[{"$f":"'5. Adequacy Summary'!A43","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C43),\"\",'5. Adequacy Summary'!C43)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D43),\"\",'5. Adequacy Summary'!D43)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E43),\"\",'5. Adequacy Summary'!E43)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F43),\"\",'5. Adequacy Summary'!F43)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G43),\"\",'5. Adequacy Summary'!G43)","v":""}]
[{"$f":"'5. Adequacy Summary'!A44","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C44),\"\",'5. Adequacy Summary'!C44)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D44),\"\",'5. Adequacy Summary'!D44)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E44),\"\",'5. Adequacy Summary'!E44)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F44),\"\",'5. Adequacy Summary'!F44)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G44),\"\",'5. Adequacy Summary'!G44)","v":""}]
[{"$f":"'5. Adequacy Summary'!A45","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C45),\"\",'5. Adequacy Summary'!C45)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D45),\"\",'5. Adequacy Summary'!D45)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E45),\"\",'5. Adequacy Summary'!E45)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F45),\"\",'5. Adequacy Summary'!F45)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G45),\"\",'5. Adequacy Summary'!G45)","v":""}]
[{"$f":"'5. Adequacy Summary'!A46","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C46),\"\",'5. Adequacy Summary'!C46)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D46),\"\",'5. Adequacy Summary'!D46)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E46),\"\",'5. Adequacy Summary'!E46)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F46),\"\",'5. Adequacy Summary'!F46)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G46),\"\",'5. Adequacy Summary'!G46)","v":""}]
[{"$f":"'5. Adequacy Summary'!A47","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C47),\"\",'5. Adequacy Summary'!C47)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D47),\"\",'5. Adequacy Summary'!D47)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E47),\"\",'5. Adequacy Summary'!E47)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!F47),\"\",'5. Adequacy Summary'!F47)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G47),\"\",'5. Adequacy Summary'!G47)","v":""}]
[{"$f":"'5. Adequacy Summary'!A48","v":0}]
[null,"Original Enforcement Compliance Requirements",null,null,"Proposed Integrated Plan Outcome"]
[null,"Original Compliance Requirement",null,"Original Compliance Deadline","Proposed Plan Outcome","Proposed  Compliance Deadline","Permittee Justification for Adjustment","State Decision and Notes"]
[]
[{"$f":"'5. Adequacy Summary'!A53","v":0},{"$f":"'5. Adequacy Summary'!B53","v":"Enforcement Mechanism 1: "}]
[{"$f":"'5. Adequacy Summary'!A54","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C54),\"\",'5. Adequacy Summary'!C54)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D54),\"\",'5. Adequacy Summary'!D54)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E54),\"\",'5. Adequacy Summary'!E54)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G54),\"\",'5. Adequacy Summary'!G54)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H54),\"\",'5. Adequacy Summary'!H54)","v":""}]
[{"$f":"'5. Adequacy Summary'!A55","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C55),\"\",'5. Adequacy Summary'!C55)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D55),\"\",'5. Adequacy Summary'!D55)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E55),\"\",'5. Adequacy Summary'!E55)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G55),\"\",'5. Adequacy Summary'!G55)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H55),\"\",'5. Adequacy Summary'!H55)","v":""}]
[{"$f":"'5. Adequacy Summary'!A56","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C56),\"\",'5. Adequacy Summary'!C56)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D56),\"\",'5. Adequacy Summary'!D56)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E56),\"\",'5. Adequacy Summary'!E56)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G56),\"\",'5. Adequacy Summary'!G56)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H56),\"\",'5. Adequacy Summary'!H56)","v":""}]
[{"$f":"'5. Adequacy Summary'!A57","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C57),\"\",'5. Adequacy Summary'!C57)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D57),\"\",'5. Adequacy Summary'!D57)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E57),\"\",'5. Adequacy Summary'!E57)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G57),\"\",'5. Adequacy Summary'!G57)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H57),\"\",'5. Adequacy Summary'!H57)","v":""}]
[{"$f":"'5. Adequacy Summary'!A58","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C58),\"\",'5. Adequacy Summary'!C58)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D58),\"\",'5. Adequacy Summary'!D58)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E58),\"\",'5. Adequacy Summary'!E58)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G58),\"\",'5. Adequacy Summary'!G58)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H58),\"\",'5. Adequacy Summary'!H58)","v":""}]
[{"$f":"'5. Adequacy Summary'!A59","v":0}]
[{"$f":"'5. Adequacy Summary'!A60","v":0},{"$f":"'5. Adequacy Summary'!B60","v":"Enforcement Mechanism 2: "}]
[{"$f":"'5. Adequacy Summary'!A61","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C61),\"\",'5. Adequacy Summary'!C61)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D61),\"\",'5. Adequacy Summary'!D61)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E61),\"\",'5. Adequacy Summary'!E61)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G61),\"\",'5. Adequacy Summary'!G61)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H61),\"\",'5. Adequacy Summary'!H61)","v":""}]
[{"$f":"'5. Adequacy Summary'!A62","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C62),\"\",'5. Adequacy Summary'!C62)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D62),\"\",'5. Adequacy Summary'!D62)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E62),\"\",'5. Adequacy Summary'!E62)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G62),\"\",'5. Adequacy Summary'!G62)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H62),\"\",'5. Adequacy Summary'!H62)","v":""}]
[{"$f":"'5. Adequacy Summary'!A63","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C63),\"\",'5. Adequacy Summary'!C63)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D63),\"\",'5. Adequacy Summary'!D63)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E63),\"\",'5. Adequacy Summary'!E63)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G63),\"\",'5. Adequacy Summary'!G63)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H63),\"\",'5. Adequacy Summary'!H63)","v":""}]
[{"$f":"'5. Adequacy Summary'!A64","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C64),\"\",'5. Adequacy Summary'!C64)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D64),\"\",'5. Adequacy Summary'!D64)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E64),\"\",'5. Adequacy Summary'!E64)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G64),\"\",'5. Adequacy Summary'!G64)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H64),\"\",'5. Adequacy Summary'!H64)","v":""}]
[{"$f":"'5. Adequacy Summary'!A65","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C65),\"\",'5. Adequacy Summary'!C65)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D65),\"\",'5. Adequacy Summary'!D65)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E65),\"\",'5. Adequacy Summary'!E65)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G65),\"\",'5. Adequacy Summary'!G65)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H65),\"\",'5. Adequacy Summary'!H65)","v":""}]
[{"$f":"'5. Adequacy Summary'!A66","v":0}]
[{"$f":"'5. Adequacy Summary'!A67","v":0},{"$f":"'5. Adequacy Summary'!B67","v":"Enforcement Mechanism 3: "}]
[{"$f":"'5. Adequacy Summary'!A68","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C68),\"\",'5. Adequacy Summary'!C68)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D68),\"\",'5. Adequacy Summary'!D68)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E68),\"\",'5. Adequacy Summary'!E68)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G68),\"\",'5. Adequacy Summary'!G68)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H68),\"\",'5. Adequacy Summary'!H68)","v":""}]
[{"$f":"'5. Adequacy Summary'!A69","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C69),\"\",'5. Adequacy Summary'!C69)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D69),\"\",'5. Adequacy Summary'!D69)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E69),\"\",'5. Adequacy Summary'!E69)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G69),\"\",'5. Adequacy Summary'!G69)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H69),\"\",'5. Adequacy Summary'!H69)","v":""}]
[{"$f":"'5. Adequacy Summary'!A70","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C70),\"\",'5. Adequacy Summary'!C70)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D70),\"\",'5. Adequacy Summary'!D70)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E70),\"\",'5. Adequacy Summary'!E70)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G70),\"\",'5. Adequacy Summary'!G70)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H70),\"\",'5. Adequacy Summary'!H70)","v":""}]
[{"$f":"'5. Adequacy Summary'!A71","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C71),\"\",'5. Adequacy Summary'!C71)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D71),\"\",'5. Adequacy Summary'!D71)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E71),\"\",'5. Adequacy Summary'!E71)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G71),\"\",'5. Adequacy Summary'!G71)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H71),\"\",'5. Adequacy Summary'!H71)","v":""}]
[{"$f":"'5. Adequacy Summary'!A72","v":0},{"$f":"'1. Adminstrative Timeline'!$C$12","v":", Permit No. "},{"$f":"IF(ISBLANK('5. Adequacy Summary'!C72),\"\",'5. Adequacy Summary'!C72)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!D72),\"\",'5. Adequacy Summary'!D72)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!E72),\"\",'5. Adequacy Summary'!E72)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!G72),\"\",'5. Adequacy Summary'!G72)","v":""},{"$f":"IF(ISBLANK('5. Adequacy Summary'!H72),\"\",'5. Adequacy Summary'!H72)","v":""}]
[{"$f":"'5. Adequacy Summary'!A73","v":0}]