{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MRC Spreadsheet","Reference","Versions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":5,"defined_names":79,"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":"MRC Spreadsheet","index":0,"n_rows":228,"n_cols":51,"rows_kept":228,"cut":false,"hidden":false,"merged":[[161,16,161,20],[161,21,161,25],[162,16,162,20],[163,16,163,20],[162,21,162,25],[163,21,163,25],[164,16,164,20],[164,21,164,25],[157,2,157,15],[158,2,158,15],[159,2,159,15],[157,21,157,25],[158,16,158,20],[158,21,158,25],[159,16,159,17],[159,19,159,20],[159,21,159,22],[159,24,159,25],[160,16,160,20],[160,21,160,25],[124,2,124,19],[124,20,124,22],[130,2,130,15],[125,2,125,19],[125,20,125,22],[150,21,150,25],[151,21,151,25],[156,2,156,15],[150,16,150,20],[135,2,135,15],[135,16,135,20],[156,16,156,20],[126,23,126,25],[135,21,135,25],[148,2,148,25],[149,2,149,25],[141,16,141,20],[141,21,141,25],[136,16,136,20],[142,21,142,25],[136,21,136,25],[139,2,139,15],[139,16,139,20],[139,21,139,25],[117,20,117,22],[117,23,117,25],[118,16,118,17],[118,18,118,19],[118,20,118,22],[118,23,118,25],[119,16,119,17],[119,18,119,19],[119,20,119,22],[119,23,119,25],[214,27,215,27],[214,28,215,28],[100,16,101,17],[100,18,101,19],[100,20,101,22],[100,23,101,25],[115,20,115,22],[115,23,115,25],[116,16,116,17],[116,18,116,19],[116,20,116,22],[116,23,116,25],[117,16,117,17],[117,18,117,19],[128,2,128,25],[136,2,136,15],[122,16,122,17],[134,2,134,15],[134,16,134,20],[134,21,134,25],[121,23,121,25],[102,16,102,17],[102,18,102,19],[156,21,156,25],[9,2,9,20],[7,2,7,9],[29,27,30,28],[78,27,79,28],[73,16,73,17],[123,23,123,25],[123,20,123,22],[123,2,123,19],[126,20,126,22],[126,2,126,19],[7,23,7,24],[7,15,7,22],[7,13,7,14],[11,2,11,12],[120,16,120,17],[120,18,120,19],[124,23,124,25],[120,20,120,22],[120,23,120,25],[121,16,121,17],[121,18,121,19],[121,20,121,22],[26,17,26,25],[71,16,71,17],[78,30,79,30],[78,31,79,31],[78,32,79,32],[78,33,79,33],[78,20,79,22],[78,23,79,25],[93,16,93,17],[93,18,93,19],[93,20,93,22],[93,23,93,25],[78,29,79,29],[81,16,81,17],[81,18,81,19],[81,20,81,22],[81,23,81,25],[82,16,82,17],[82,18,82,19],[82,20,82,22],[82,23,82,25],[83,16,83,17],[83,18,83,19],[83,20,83,22],[83,23,83,25],[84,16,84,17],[51,15,52,15],[53,2,53,14],[66,2,66,14],[67,2,67,14],[50,16,50,17],[97,23,97,25],[98,16,98,17],[98,18,98,19],[98,20,98,22],[98,23,98,25],[78,16,79,17],[78,18,79,19],[80,16,80,17],[80,18,80,19],[80,20,80,22],[80,23,80,25],[67,16,67,17],[67,18,67,19],[67,20,67,22],[67,23,67,25],[50,18,50,19],[50,20,50,22],[50,23,50,25],[71,18,71,19],[51,16,52,17],[51,18,52,19],[51,20,52,22],[51,23,52,25],[72,16,72,17],[72,18,72,19],[53,16,53,17],[53,18,53,19],[53,20,53,22],[53,23,53,25],[66,16,66,17],[66,18,66,19],[66,20,66,22],[66,23,66,25],[71,20,71,22],[71,23,71,25],[69,23,69,25],[72,20,72,22],[56,16,56,17],[56,18,56,19],[56,20,56,22],[56,23,56,25],[68,23,68,25],[68,2,68,14],[71,2,71,14],[72,2,72,14],[74,23,74,25],[74,20,74,22],[74,2,74,19],[69,16,69,17],[69,18,69,19],[69,20,69,22],[29,32,30,32],[29,31,30,31],[29,33,30,33],[29,29,30,29],[34,16,34,17],[34,18,34,19],[34,20,34,22],[34,23,34,25],[47,16,47,17],[47,18,47,19],[47,20,47,22],[47,23,47,25],[33,16,33,17],[33,18,33,19],[33,20,33,22],[33,23,33,25],[29,16,30,17],[29,18,30,19],[29,20,30,22],[29,23,30,25],[41,18,41,19],[41,20,41,22],[41,23,41,25],[42,18,42,19],[0,0,0,25],[17,2,17,7],[17,8,17,18],[17,21,17,23],[17,24,17,25],[154,2,154,25],[155,2,155,25],[144,2,144,15],[144,16,144,20],[144,21,144,25],[145,2,145,15],[145,16,145,20],[145,21,145,25],[146,2,146,15],[146,16,146,20],[146,21,146,25],[143,2,143,15],[143,16,143,20],[143,21,143,25],[130,21,130,25],[130,16,130,20],[141,2,141,15],[76,2,76,10],[76,11,76,12],[49,16,49,17],[49,18,49,19],[49,20,49,22],[49,23,49,25],[31,16,31,17],[31,18,31,19],[31,20,31,22],[31,23,31,25],[48,20,48,22],[48,23,48,25],[48,16,48,17],[48,18,48,19],[42,20,42,22],[42,23,42,25],[35,18,35,19],[35,20,35,22],[35,23,35,25],[43,18,43,19],[43,20,43,22],[43,23,43,25],[39,23,39,25],[40,18,40,19],[40,20,40,22],[40,23,40,25],[27,2,27,10],[27,11,27,12],[27,13,27,14],[11,24,11,25],[11,21,11,23],[25,2,25,25],[27,17,27,25],[32,16,32,17],[32,18,32,19],[32,20,32,22],[32,23,32,25],[31,2,31,14],[29,2,30,14],[29,15,30,15],[32,2,32,14],[23,13,23,18],[1,1,1,25],[5,15,5,16],[5,17,5,25],[7,10,7,11],[3,1,3,7],[3,8,3,9],[5,2,5,4],[5,5,5,6],[5,12,5,14],[140,2,140,15],[140,16,140,20],[140,21,140,25],[142,16,142,20],[142,2,142,15],[137,21,137,25],[137,2,137,15],[137,16,137,20],[147,16,147,20],[147,21,147,25],[227,2,227,9],[227,22,227,25],[227,19,227,21],[227,10,227,17],[13,24,13,25],[15,2,15,5],[15,6,15,9],[14,0,14,25],[15,10,15,12],[15,13,15,17],[15,21,15,23],[15,24,15,25],[218,22,218,25],[218,2,218,21],[147,2,147,15],[19,2,19,25],[168,2,168,3],[168,4,168,25],[225,2,225,15],[225,16,225,25],[167,2,167,3],[167,4,167,25],[151,16,151,20],[152,2,152,15],[153,16,153,20],[153,21,153,25],[151,2,151,15],[220,2,220,21],[220,22,220,25],[165,2,165,15],[165,16,165,20],[165,21,165,25],[172,2,172,15],[172,16,172,20],[172,21,172,25],[173,2,173,15],[176,2,176,15],[176,16,176,20],[173,21,173,25],[174,2,174,15],[174,16,174,20],[216,2,216,21],[160,2,160,15],[161,2,161,15],[162,2,162,15],[163,2,163,15],[164,2,164,15],[157,16,157,20],[216,22,216,25],[217,2,217,21],[217,22,217,25],[214,2,214,25],[150,2,150,15],[132,2,132,15],[132,16,132,20],[132,21,132,25],[133,2,133,15],[133,16,133,20],[133,21,133,25],[138,2,138,15],[138,16,138,20],[138,21,138,25],[176,21,176,25],[173,16,173,20],[180,2,180,15],[180,16,180,20],[181,16,181,20],[181,21,181,25],[174,21,174,25],[152,16,152,20],[152,21,152,25],[153,2,153,15],[175,2,175,15],[175,16,175,20],[175,21,175,25],[177,2,177,15],[177,16,177,20],[177,21,177,25],[178,2,178,15],[178,16,178,20],[178,21,178,25],[179,2,179,15],[179,16,179,20],[179,21,179,25],[183,2,183,15],[183,16,183,20],[183,21,183,25],[184,2,184,15],[184,16,184,20],[184,21,184,25],[180,21,180,25],[181,2,181,15],[189,21,189,25],[192,2,192,15],[192,16,192,20],[192,21,192,25],[191,16,191,20],[191,21,191,25],[212,2,212,3],[212,4,212,25],[196,16,196,20],[196,21,196,25],[199,2,199,15],[199,16,199,20],[211,2,211,3],[211,4,211,25],[199,21,199,25],[200,2,200,15],[200,16,200,20],[200,21,200,25],[197,2,197,25],[198,2,198,25],[189,2,189,15],[190,2,190,15],[193,2,193,15],[193,21,193,25],[196,2,196,15],[194,2,194,25],[195,2,195,25],[191,2,191,15],[190,16,190,20],[190,21,190,25],[202,2,202,15],[202,16,202,20],[202,21,202,25],[208,16,208,20],[208,21,208,25],[203,2,203,15],[203,16,203,20],[203,21,203,25],[204,2,204,15],[204,16,204,20],[204,21,204,25],[205,2,205,15],[205,16,205,17],[205,19,205,20],[205,21,205,22],[205,24,205,25],[206,2,206,15],[206,16,206,20],[206,21,206,25],[207,2,207,15],[207,16,207,20],[33,2,33,14],[34,2,34,14],[47,2,47,14],[209,2,209,15],[209,16,209,20],[193,16,193,20],[189,16,189,20],[170,18,170,25],[170,15,170,17],[185,2,185,25],[186,2,186,25],[187,2,187,15],[187,16,187,20],[187,21,187,25],[188,2,188,15],[188,16,188,20],[188,21,188,25],[182,2,182,15],[182,16,182,20],[182,21,182,25],[48,2,48,14],[49,2,49,14],[50,2,50,14],[51,2,52,14],[81,2,81,14],[82,2,82,14],[83,2,83,14],[84,2,84,14],[87,2,87,14],[89,2,89,14],[91,2,91,14],[103,2,103,14],[105,2,105,14],[97,2,97,14],[98,2,98,14],[86,2,86,14],[104,2,104,14],[56,2,56,14],[102,20,102,22],[102,23,102,25],[115,16,115,17],[115,18,115,19],[97,16,97,17],[99,16,99,17],[99,18,99,19],[99,20,99,22],[99,23,99,25],[97,18,97,19],[97,20,97,22],[78,2,79,14],[78,15,79,15],[80,2,80,14],[93,2,93,14],[94,2,94,14],[95,2,95,14],[96,2,96,14],[94,16,94,17],[94,18,94,19],[94,20,94,22],[94,23,94,25],[95,16,95,17],[46,23,46,25],[99,2,99,14],[100,2,101,14],[100,15,101,15],[102,2,102,14],[115,2,115,14],[116,2,116,14],[117,2,117,14],[35,2,35,14],[35,16,35,17],[43,2,43,14],[43,16,43,17],[40,2,40,14],[40,16,40,17],[41,2,41,14],[41,16,41,17],[42,2,42,14],[42,16,42,17],[44,2,44,14],[44,16,44,17],[36,2,36,14],[36,16,36,17],[39,2,39,14],[39,16,39,17],[36,18,36,19],[36,20,36,22],[36,23,36,25],[37,2,37,14],[37,16,37,17],[37,18,37,19],[37,20,37,22],[37,23,37,25],[38,2,38,14],[38,16,38,17],[38,18,38,19],[38,20,38,22],[38,23,38,25],[39,18,39,19],[39,20,39,22],[54,2,54,14],[54,16,54,17],[54,18,54,19],[54,20,54,22],[54,23,54,25],[55,2,55,14],[55,16,55,17],[55,18,55,19],[55,20,55,22],[55,23,55,25],[44,18,44,19],[44,20,44,22],[44,23,44,25],[45,2,45,14],[45,16,45,17],[45,18,45,19],[45,20,45,22],[45,23,45,25],[46,2,46,14],[46,16,46,17],[46,18,46,19],[46,20,46,22],[57,2,57,14],[57,16,57,17],[57,18,57,19],[57,20,57,22],[57,23,57,25],[58,2,58,14],[58,16,58,17],[58,18,58,19],[58,20,58,22],[58,23,58,25],[59,2,59,14],[59,16,59,17],[59,18,59,19],[59,20,59,22],[59,23,59,25],[60,2,60,14],[60,16,60,17],[60,18,60,19],[60,20,60,22],[60,23,60,25],[61,2,61,14],[61,16,61,17],[61,18,61,19],[61,20,61,22],[61,23,61,25],[62,2,62,14],[62,16,62,17],[62,18,62,19],[62,20,62,22],[62,23,62,25],[63,2,63,14],[63,16,63,17],[63,18,63,19],[63,20,63,22],[63,23,63,25],[64,2,64,14],[64,16,64,17],[64,18,64,19],[64,20,64,22],[64,23,64,25],[65,2,65,14],[65,16,65,17],[65,18,65,19],[65,20,65,22],[65,23,65,25],[84,18,84,19],[84,20,84,22],[84,23,84,25],[85,2,85,14],[85,16,85,17],[85,18,85,19],[85,20,85,22],[85,23,85,25],[76,13,76,14],[72,23,72,25],[70,16,70,17],[70,18,70,19],[70,20,70,22],[70,23,70,25],[68,16,68,17],[68,18,68,19],[68,20,68,22],[70,2,70,14],[69,2,69,14],[86,16,86,17],[86,18,86,19],[86,20,86,22],[86,23,86,25],[87,16,87,17],[87,18,87,19],[87,20,87,22],[87,23,87,25],[88,2,88,14],[88,16,88,17],[88,18,88,19],[88,20,88,22],[88,23,88,25],[89,16,89,17],[89,18,89,19],[89,20,89,22],[89,23,89,25],[90,2,90,14],[90,16,90,17],[90,18,90,19],[90,20,90,22],[90,23,90,25],[91,16,91,17],[91,18,91,19],[91,20,91,22],[91,23,91,25],[92,2,92,14],[92,16,92,17],[92,18,92,19],[92,20,92,22],[92,23,92,25],[103,16,103,17],[103,18,103,19],[103,20,103,22],[103,23,103,25],[95,18,95,19],[95,20,95,22],[95,23,95,25],[96,16,96,17],[96,18,96,19],[96,20,96,22],[96,23,96,25],[104,16,104,17],[104,18,104,19],[104,20,104,22],[104,23,104,25],[105,16,105,17],[105,18,105,19],[105,20,105,22],[105,23,105,25],[106,2,106,14],[106,16,106,17],[106,18,106,19],[106,20,106,22],[106,23,106,25],[107,16,107,17],[107,18,107,19],[107,20,107,22],[107,23,107,25],[108,2,108,14],[108,16,108,17],[108,18,108,19],[108,20,108,22],[108,23,108,25],[107,2,107,14],[109,16,109,17],[109,18,109,19],[109,20,109,22],[109,23,109,25],[110,2,110,14],[110,16,110,17],[110,18,110,19],[110,20,110,22],[110,23,110,25],[109,2,109,14],[111,16,111,17],[111,18,111,19],[111,20,111,22],[111,23,111,25],[112,2,112,14],[112,16,112,17],[112,18,112,19],[112,20,112,22],[112,23,112,25],[111,2,111,14],[223,1,223,25],[222,1,222,25],[113,16,113,17],[113,18,113,19],[113,20,113,22],[113,23,113,25],[114,2,114,14],[114,16,114,17],[114,18,114,19],[114,20,114,22],[114,23,114,25],[120,2,120,14],[121,2,121,14],[122,20,122,22],[125,23,125,25],[209,21,209,25],[201,2,201,15],[201,16,201,20],[201,21,201,25],[118,2,118,14],[119,2,119,14],[113,2,113,14],[207,21,207,25],[208,2,208,15]]}
["Revised 4/2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,"MRC Bioretention","Upstream","Rows","Disconnection",null,false,true,"Double Ring Infiltrometer",0,0,0,"sand","USDA Soil","Upstream Vegetated Component","Deep Plantings","Regenerative Air","> 1 / week",true,"< 1.2-Inch/2-Hour Storm","Forebay","Forebay","N/A"]
[null,"Managed Release Concept (MRC) Spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MRC Storage Systems","Downstream",1,"Simple Downspout Disconnection",null,false,false,"Other",1,1,1,"loamy sand","HSG","Upstream MTD Pretreatment","Shallow Plantings","Vacuum","1 / week",false,"1.2-Inch/2-Hour Storm","SCM Surface","Settling Chamber"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MRC Karst","PCSM Objective A",2,"Sheet Flow Disconnection",false,false,null,null,2,2,2,"sandy loam",null,"Permeable Pavement",null,null,"1 / 2 weeks","N/A","< 2-Year/24-Hour Storm","Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-Construction 1-Inch/2-Hour Storm","PCSM Objective B",3,null,false,false,null,null,3,3,3,"loam",null,null,null,null,"1 / 4 weeks",null,"2-Year/24-Hour Storm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum 1-Year Storm Discharge","PCSM Objective C",4,null,null,false,null,null,4,4,4,"silt loam",null,null,null,null,"< 1 / 4 weeks",null,"> 2-Year/24-Hour Storm"]
[null,null,"SCM ID:",null,null,null,null,null,null,null,null,null,null,null,null,"Type:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P6=\"Riparian Forest Buffer Meeting § 102.14(b)\",\"Y\",\"\")","v":""},null,null,"Pre-Construction 2-Year/24-Hour Storm","PCSM Objective D",5,null,null,false,null,null,5,5,5,"silt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum 2-Year Storm Discharge","None",6,null,null,false,null,null,6,6,6,"silty clay loam"]
[null,null,"2-year/24-hour Precipitation Depth:",null,null,null,null,null,null,null,null,null,"in",null,null,"Incremental SCM Drainage Area:",null,null,null,null,null,null,null,null,null,"ac",null,{"$f":"IF(X8<>\"\",IF(AND(OR(N24=\"< 1.2-Inch/2-Hour Storm\",N24=\"1.2-Inch/2-Hour Storm\"),X8>B124,U126=0),B124/(IF(AND(AI1=TRUE,O12<>\"\"),O12,1)),X8/(IF(AND(AI1=TRUE,O12<>\"\"),O12,1))),\"\")","v":""},null,"1.2-Inch/2-Hour Storm","MRC Bioswale",7,null,null,false,null,null,7,7,7,"clay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(X8<>\"\",AB8<>\"\",N24<>\"\"),IF(AND(N24<>\"> 2-Year/24-Hour Storm\",AB8>6.1),\"Y\",IF(AND(N24=\"> 2-Year/24-Hour Storm\",AB8>3.1),\"Y\",\"\")),\"\")","v":""},null,"2-Year/24-Hour Storm","Off-Site",8,null,null,true,null,null,8,8,8,"clay loam"]
[null,null,"Will flow from the drainage area be split into multiple MRC SCMs (cells) in parallel?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"No",null,null,null,"> 2-Year/24-Hour Storm (All Flows)","to a downstream Objective A SCM",9,null,null,false,null,null,9,9,9,"sandy clay loam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"to a downstream Objective B SCM",10,null,null,false,null,null,10,10,10,"silty clay"]
[null,null,"Enter the number of cells and their surface area:",null,null,null,null,null,null,null,null,null,null,"No:",null,null,"Surface area of cells:",null,null,null,null,null,null,null,"SF",null,null,null,null,{"$f":"IF(AI12=TRUE,\"PCLand_Cover\",\"LandCover_Pre_Construction\")","v":"LandCover_Pre_Construction"},"to a downstream Objective C SCM",11,null,null,false,null,null,11,11,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"to a downstream Objective D SCM",12,null,null,false,null,null,12,12,12]
[null,null,"Is this SCM in series?",null,null,null,null,null,null,"Yes",null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< 2-Year/24-Hour Storm",13,null,null,null,null,null,"> 12",13,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Year/24-Hour Storm",14,null,null,null,null,null,null,14,14]
[null,null,"This SCM is:",null,null,null,null,null,null,null,"of a",null,null,null,null,null,null,null,"SCM",null,null,"SCM ID:",null,null,null,null,null,{"$f":"IF(AND(R6<>\"\",OR(AB140<>\"\",AB178<>\"\"),G16<>\"\",N16<>\"\"),IF(AND(OR(AND(R6=\"MRC Bioretention\",AB140=0),AND(R6=\"MRC Storage Systems\",AB178=0)),OR(G16=\"Downstream\",G16=\"Upstream\"),N16=\"PCSM Objective D\"),\"Y\",\"\"),\"\")","v":""},null,null,"> 2-Year/24-Hour Storm",15,null,null,null,null,null,null,15,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",16,null,null,null,null,null,null,16,16]
[null,null,"This SCM discharges:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCM ID:",null,null,null,null,null,{"$f":"IF(AND(I18<>\"\",I18<>\"Off-Site\"),\"Y\",\"\")","v":""},null,null,"Pipe storage",17,null,null,null,null,null,null,17,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manufactured storage",18,null,null,null,null,null,null,18,18]
[null,null,"Will at least 10% of runoff from the 1.2-Inch/2-Hour Storm be managed using PCSM Objective A SCMs?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tank/cistern and chamber",19,null,null,null,null,null,null,19,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Permeable pavement w/IWS",20,null,null,null,null,null,null,20,20]
[null,null,null,"Yes",null,null,"No",null,null,"There are no or insufficient natural stormwater features on the project site.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manufactured treatment device",null,null,null,null,null,null,null,"> 20",21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In vegetated component",null,null,null,null,null,null,null,null,22]
[null,null,"Maximum storm event routed to the MRC SCM:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N24<>\"\",IF(AND(N24=\"> 2-Year/24-Hour Storm\",OR(AND(R6=\"MRC Bioretention\",V154<>\"Forebay\"),AND(R6=\"MRC Storage Systems\",V202<>\"Forebay\",V202<>\"Settling Chamber\"))),0.5,0),\"\")","v":""},null,null,"In storage system",null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No IWS provided",null,null,null,null,null,null,null,null,24]
[null,null,"Drainage Area Characterization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exempt from §§ 102.8(g)(2)(ii) & (iii)"]
[null,null,"Pre-Construction Drainage Area",null,null,null,null,null,null,null,null,"Rows:",null,null,null,null,null,"Calculate runoff automatically"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Runoff (2-year/24-hr storm)"]
[null,null,"Pre-Construction Drainage Area Cover Type",null,null,null,null,null,null,null,null,null,null,null,null,"HSG","Area (ac)",null,"Off-Site",null,"Runoff, 1.2-Inch (CF)",null,null,"Runoff, 2-Year (CF)",null,null,null,"1.2-inch/2-year storm",null,"CN",null,"Q","Volume","Soil Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(AC32<>\"\",AC32,\"\")","v":""},null,null,{"$f":"IF(AG32<>\"\",AG32,\"\")","v":""},null,null,null,{"$f":"IF(AE32<>\"\",IF(1.2-AE32>0,((1.2-AE32)^2)/(1.2+0.8*((1000/AD32)-10)),0),\"\")","v":""},{"$f":"IF(AB32<>\"\",Q32*43560*(AB32/12),\"\")","v":""},{"$f":"IF(AND(C32<>\"\",Q32<>\"\",P32<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C32,Reference!$A$1:$E$62,AH32,FALSE))=TRUE,\"\",VLOOKUP(C32,Reference!$A$1:$E$62,AH32,FALSE)),IF(ISNA(VLOOKUP(C32,Reference!$M$1:$Q$12,AH32,FALSE))=TRUE,\"\",VLOOKUP(C32,Reference!$M$1:$Q$12,AH32,FALSE))),\"\")","v":""},{"$f":"IF(AD32<>\"\",0.2*((1000/AD32)-10),\"\")","v":""},{"$f":"IF(AND(AE32<>\"\",$K$8<>\"\"),IF($K$8-AE32>0,(($K$8-AE32)^2)/($K$8+0.8*((1000/AD32)-10)),0),\"\")","v":""},{"$f":"IF(AF32<>\"\",Q32*43560*(AF32/12),\"\")","v":""},{"$f":"IF(P32<>\"\",IF(P32=\"A\",2,IF(P32=\"B\",3,IF(P32=\"C\",4,IF(OR(P32=\"D\",P32=\"N/A\"),5,)))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(AC33<>\"\",AC33,\"\")","v":""},null,null,{"$f":"IF(AG33<>\"\",AG33,\"\")","v":""},null,null,null,{"$f":"IF(AE33<>\"\",IF(1.2-AE33>0,((1.2-AE33)^2)/(1.2+0.8*((1000/AD33)-10)),0),\"\")","v":""},{"$f":"IF(AB33<>\"\",Q33*43560*(AB33/12),\"\")","v":""},{"$f":"IF(AND(C33<>\"\",Q33<>\"\",P33<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C33,Reference!$A$1:$E$62,AH33,FALSE))=TRUE,\"\",VLOOKUP(C33,Reference!$A$1:$E$62,AH33,FALSE)),IF(ISNA(VLOOKUP(C33,Reference!$M$1:$Q$12,AH33,FALSE))=TRUE,\"\",VLOOKUP(C33,Reference!$M$1:$Q$12,AH33,FALSE))),\"\")","v":""},{"$f":"IF(AD33<>\"\",0.2*((1000/AD33)-10),\"\")","v":""},{"$f":"IF(AND(AE33<>\"\",$K$8<>\"\"),IF($K$8-AE33>0,(($K$8-AE33)^2)/($K$8+0.8*((1000/AD33)-10)),0),\"\")","v":""},{"$f":"IF(AF33<>\"\",Q33*43560*(AF33/12),\"\")","v":""},{"$f":"IF(P33<>\"\",IF(P33=\"A\",2,IF(P33=\"B\",3,IF(P33=\"C\",4,IF(OR(P33=\"D\",P33=\"N/A\"),5,)))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C34<>\"\",Q34<>\"\",P34<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C34,Reference!$A$1:$E$62,AH34,FALSE))=TRUE,\"\",VLOOKUP(C34,Reference!$A$1:$E$62,AH34,FALSE)),IF(ISNA(VLOOKUP(C34,Reference!$M$1:$Q$12,AH34,FALSE))=TRUE,\"\",VLOOKUP(C34,Reference!$M$1:$Q$12,AH34,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C35<>\"\",Q35<>\"\",P35<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C35,Reference!$A$1:$E$62,AH35,FALSE))=TRUE,\"\",VLOOKUP(C35,Reference!$A$1:$E$62,AH35,FALSE)),IF(ISNA(VLOOKUP(C35,Reference!$M$1:$Q$12,AH35,FALSE))=TRUE,\"\",VLOOKUP(C35,Reference!$M$1:$Q$12,AH35,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C36<>\"\",Q36<>\"\",P36<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C36,Reference!$A$1:$E$62,AH36,FALSE))=TRUE,\"\",VLOOKUP(C36,Reference!$A$1:$E$62,AH36,FALSE)),IF(ISNA(VLOOKUP(C36,Reference!$M$1:$Q$12,AH36,FALSE))=TRUE,\"\",VLOOKUP(C36,Reference!$M$1:$Q$12,AH36,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(AC37<>\"\",AC37,\"\")","v":""},null,null,{"$f":"IF(AG37<>\"\",AG37,\"\")","v":""},null,null,null,"","",{"$f":"IF(AND(C37<>\"\",Q37<>\"\",P37<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C37,Reference!$A$1:$E$62,AH37,FALSE))=TRUE,\"\",VLOOKUP(C37,Reference!$A$1:$E$62,AH37,FALSE)),IF(ISNA(VLOOKUP(C37,Reference!$M$1:$Q$12,AH37,FALSE))=TRUE,\"\",VLOOKUP(C37,Reference!$M$1:$Q$12,AH37,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C38<>\"\",Q38<>\"\",P38<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C38,Reference!$A$1:$E$62,AH38,FALSE))=TRUE,\"\",VLOOKUP(C38,Reference!$A$1:$E$62,AH38,FALSE)),IF(ISNA(VLOOKUP(C38,Reference!$M$1:$Q$12,AH38,FALSE))=TRUE,\"\",VLOOKUP(C38,Reference!$M$1:$Q$12,AH38,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C39<>\"\",Q39<>\"\",P39<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C39,Reference!$A$1:$E$62,AH39,FALSE))=TRUE,\"\",VLOOKUP(C39,Reference!$A$1:$E$62,AH39,FALSE)),IF(ISNA(VLOOKUP(C39,Reference!$M$1:$Q$12,AH39,FALSE))=TRUE,\"\",VLOOKUP(C39,Reference!$M$1:$Q$12,AH39,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C40<>\"\",Q40<>\"\",P40<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C40,Reference!$A$1:$E$62,AH40,FALSE))=TRUE,\"\",VLOOKUP(C40,Reference!$A$1:$E$62,AH40,FALSE)),IF(ISNA(VLOOKUP(C40,Reference!$M$1:$Q$12,AH40,FALSE))=TRUE,\"\",VLOOKUP(C40,Reference!$M$1:$Q$12,AH40,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C41<>\"\",Q41<>\"\",P41<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C41,Reference!$A$1:$E$62,AH41,FALSE))=TRUE,\"\",VLOOKUP(C41,Reference!$A$1:$E$62,AH41,FALSE)),IF(ISNA(VLOOKUP(C41,Reference!$M$1:$Q$12,AH41,FALSE))=TRUE,\"\",VLOOKUP(C41,Reference!$M$1:$Q$12,AH41,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C42<>\"\",Q42<>\"\",P42<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C42,Reference!$A$1:$E$62,AH42,FALSE))=TRUE,\"\",VLOOKUP(C42,Reference!$A$1:$E$62,AH42,FALSE)),IF(ISNA(VLOOKUP(C42,Reference!$M$1:$Q$12,AH42,FALSE))=TRUE,\"\",VLOOKUP(C42,Reference!$M$1:$Q$12,AH42,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C43<>\"\",Q43<>\"\",P43<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C43,Reference!$A$1:$E$62,AH43,FALSE))=TRUE,\"\",VLOOKUP(C43,Reference!$A$1:$E$62,AH43,FALSE)),IF(ISNA(VLOOKUP(C43,Reference!$M$1:$Q$12,AH43,FALSE))=TRUE,\"\",VLOOKUP(C43,Reference!$M$1:$Q$12,AH43,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C44<>\"\",Q44<>\"\",P44<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C44,Reference!$A$1:$E$62,AH44,FALSE))=TRUE,\"\",VLOOKUP(C44,Reference!$A$1:$E$62,AH44,FALSE)),IF(ISNA(VLOOKUP(C44,Reference!$M$1:$Q$12,AH44,FALSE))=TRUE,\"\",VLOOKUP(C44,Reference!$M$1:$Q$12,AH44,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C45<>\"\",Q45<>\"\",P45<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C45,Reference!$A$1:$E$62,AH45,FALSE))=TRUE,\"\",VLOOKUP(C45,Reference!$A$1:$E$62,AH45,FALSE)),IF(ISNA(VLOOKUP(C45,Reference!$M$1:$Q$12,AH45,FALSE))=TRUE,\"\",VLOOKUP(C45,Reference!$M$1:$Q$12,AH45,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C46<>\"\",Q46<>\"\",P46<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C46,Reference!$A$1:$E$62,AH46,FALSE))=TRUE,\"\",VLOOKUP(C46,Reference!$A$1:$E$62,AH46,FALSE)),IF(ISNA(VLOOKUP(C46,Reference!$M$1:$Q$12,AH46,FALSE))=TRUE,\"\",VLOOKUP(C46,Reference!$M$1:$Q$12,AH46,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C47<>\"\",Q47<>\"\",P47<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C47,Reference!$A$1:$E$62,AH47,FALSE))=TRUE,\"\",VLOOKUP(C47,Reference!$A$1:$E$62,AH47,FALSE)),IF(ISNA(VLOOKUP(C47,Reference!$M$1:$Q$12,AH47,FALSE))=TRUE,\"\",VLOOKUP(C47,Reference!$M$1:$Q$12,AH47,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C48<>\"\",Q48<>\"\",P48<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C48,Reference!$A$1:$E$62,AH48,FALSE))=TRUE,\"\",VLOOKUP(C48,Reference!$A$1:$E$62,AH48,FALSE)),IF(ISNA(VLOOKUP(C48,Reference!$M$1:$Q$12,AH48,FALSE))=TRUE,\"\",VLOOKUP(C48,Reference!$M$1:$Q$12,AH48,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C49<>\"\",Q49<>\"\",P49<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C49,Reference!$A$1:$E$62,AH49,FALSE))=TRUE,\"\",VLOOKUP(C49,Reference!$A$1:$E$62,AH49,FALSE)),IF(ISNA(VLOOKUP(C49,Reference!$M$1:$Q$12,AH49,FALSE))=TRUE,\"\",VLOOKUP(C49,Reference!$M$1:$Q$12,AH49,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C50<>\"\",Q50<>\"\",P50<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C50,Reference!$A$1:$E$62,AH50,FALSE))=TRUE,\"\",VLOOKUP(C50,Reference!$A$1:$E$62,AH50,FALSE)),IF(ISNA(VLOOKUP(C50,Reference!$M$1:$Q$12,AH50,FALSE))=TRUE,\"\",VLOOKUP(C50,Reference!$M$1:$Q$12,AH50,FALSE))),\"\")","v":""},"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C51<>\"\",Q51<>\"\",P51<>\"\"),IF($AD$12=\"PCLand_Cover\",IF(ISNA(VLOOKUP(C51,Reference!$A$1:$E$62,AH51,FALSE))=TRUE,\"\",VLOOKUP(C51,Reference!$A$1:$E$62,AH51,FALSE)),IF(ISNA(VLOOKUP(C51,Reference!$M$1:$Q$12,AH51,FALSE))=TRUE,\"\",VLOOKUP(C51,Reference!$M$1:$Q$12,AH51,FALSE))),\"\")","v":""},"","","",""]
[null,null,"Pre-Construction Drainage Area Cover Type",null,null,null,null,null,null,null,null,null,null,null,null,"HSG","Area (ac)",null,"Off-Site",null,"Runoff, 1.2-Inch (CF)",null,null,"Runoff, 2-Year (CF)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S52<>\"\",IF(S52=\"HSG\",\"Soil_Type\",\"USDA\"),\"\")","v":"USDA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AI9=TRUE,SUM(Q32:Q51)>0),SUM(Q32:Q51),IF(AND(AI9=FALSE,SUM(Q53:Q72)>0),SUM(Q53:Q72),\"\"))","v":""}]
[null,null,"Totals (CF):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(SUM(U32:U51)>=0,AI9=TRUE),SUM(U32:U51),IF(AND(SUM(U54:U73)>=0,AI9<>TRUE),SUM(U54:U73),\"\"))","v":0},null,null,{"$f":"IF(AND(SUM(X32:X51)>0,AI9=TRUE),SUM(X32:X51),IF(AND(SUM(X54:X73)>0,AI9<>TRUE),SUM(X54:X73),\"\"))","v":""}]
[]
[null,null,"Post-Construction Drainage Area",null,null,null,null,null,null,null,null,"Rows:",null,null,null,null,null,"Receives direct precipitation only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Runoff (2-year/24-hr storm)"]
[null,null,"Post-Construction Drainage Area Cover Type",null,null,null,null,null,null,null,null,null,null,null,null,"HSG","Area (ac)",null,"Off-Site",null,"Runoff, 1.2-Inch (CF)",null,null,"Runoff, 2-Year (CF)",null,null,null,"1.2-inch/2-year storm",null,"CN","Ia","Q","Volume","Soil Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.2-Inch Off-Site Volume","2-Yr Off-Site Volume"]
[null,{"$f":"IF(S81=FALSE,Q81,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(AC81<>\"\",AC81,\"\")","v":""},null,null,{"$f":"IF(AG81<>\"\",AG81,\"\")","v":""},null,null,{"$f":"IF(AND(C81<>\"\",P81<>\"\",Q81<>\"\"),IF(ISNA(VLOOKUP(C81,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C81,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q81,0)),0)","v":0},{"$f":"IF(AE81<>\"\",IF(1.2-AE81>0,((1.2-AE81)^2)/(1.2+0.8*((1000/AD81)-10)),0),\"\")","v":""},{"$f":"IF(AB81<>\"\",Q81*43560*(AB81/12),\"\")","v":""},{"$f":"IF(AND(C81<>\"\",Q81<>\"\",P81<>\"\"),IF(ISNA(VLOOKUP(C81,Reference!$A$1:$E$61,AH81,FALSE))=TRUE,\"\",VLOOKUP(C81,Reference!$A$1:$E$61,AH81,FALSE)),\"\")","v":""},{"$f":"IF(AD81<>\"\",0.2*((1000/AD81)-10),\"\")","v":""},{"$f":"IF(AND(AE81<>\"\",$K$8<>\"\"),IF($K$8-AE81>0,(($K$8-AE81)^2)/($K$8+0.8*((1000/AD81)-10)),0),\"\")","v":""},{"$f":"IF(AF81<>\"\",Q81*43560*(AF81/12),\"\")","v":""},{"$f":"IF(P81<>\"\",IF(P81=\"A\",2,IF(P81=\"B\",3,IF(P81=\"C\",4,IF(OR(P81=\"D\",P81=\"N/A\"),5,)))),\"\")","v":""},{"$f":"IF(S81=TRUE,U81,0)","v":0},{"$f":"IF(S81=TRUE,X81,0)","v":0}]
[null,{"$f":"IF(S82=FALSE,Q82,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(AC82<>\"\",AC82,\"\")","v":""},null,null,{"$f":"IF(AG82<>\"\",AG82,\"\")","v":""},null,null,{"$f":"IF(AND(C82<>\"\",P82<>\"\",Q82<>\"\"),IF(ISNA(VLOOKUP(C82,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C82,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q82,0)),0)","v":0},{"$f":"IF(AE82<>\"\",IF(1.2-AE82>0,((1.2-AE82)^2)/(1.2+0.8*((1000/AD82)-10)),0),\"\")","v":""},{"$f":"IF(AB82<>\"\",Q82*43560*(AB82/12),\"\")","v":""},{"$f":"IF(AND(C82<>\"\",Q82<>\"\",P82<>\"\"),IF(ISNA(VLOOKUP(C82,Reference!$A$1:$E$61,AH82,FALSE))=TRUE,\"\",VLOOKUP(C82,Reference!$A$1:$E$61,AH82,FALSE)),\"\")","v":""},{"$f":"IF(AD82<>\"\",0.2*((1000/AD82)-10),\"\")","v":""},{"$f":"IF(AND(AE82<>\"\",$K$8<>\"\"),IF($K$8-AE82>0,(($K$8-AE82)^2)/($K$8+0.8*((1000/AD82)-10)),0),\"\")","v":""},{"$f":"IF(AF82<>\"\",Q82*43560*(AF82/12),\"\")","v":""},{"$f":"IF(P82<>\"\",IF(P82=\"A\",2,IF(P82=\"B\",3,IF(P82=\"C\",4,IF(OR(P82=\"D\",P82=\"N/A\"),5,)))),\"\")","v":""},{"$f":"IF(S82=TRUE,U82,0)","v":0},{"$f":"IF(S82=TRUE,X82,0)","v":0}]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C83<>\"\",P83<>\"\",Q83<>\"\"),IF(ISNA(VLOOKUP(C83,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C83,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q83,0)),0)","v":0},"","",{"$f":"IF(AND(C83<>\"\",Q83<>\"\",P83<>\"\"),IF(ISNA(VLOOKUP(C83,Reference!$A$1:$E$61,AH83,FALSE))=TRUE,\"\",VLOOKUP(C83,Reference!$A$1:$E$61,AH83,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C84<>\"\",P84<>\"\",Q84<>\"\"),IF(ISNA(VLOOKUP(C84,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C84,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q84,0)),0)","v":0},"","",{"$f":"IF(AND(C84<>\"\",Q84<>\"\",P84<>\"\"),IF(ISNA(VLOOKUP(C84,Reference!$A$1:$E$61,AH84,FALSE))=TRUE,\"\",VLOOKUP(C84,Reference!$A$1:$E$61,AH84,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C85<>\"\",P85<>\"\",Q85<>\"\"),IF(ISNA(VLOOKUP(C85,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C85,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q85,0)),0)","v":0},"","",{"$f":"IF(AND(C85<>\"\",Q85<>\"\",P85<>\"\"),IF(ISNA(VLOOKUP(C85,Reference!$A$1:$E$61,AH85,FALSE))=TRUE,\"\",VLOOKUP(C85,Reference!$A$1:$E$61,AH85,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C86<>\"\",P86<>\"\",Q86<>\"\"),IF(ISNA(VLOOKUP(C86,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C86,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q86,0)),0)","v":0},"","",{"$f":"IF(AND(C86<>\"\",Q86<>\"\",P86<>\"\"),IF(ISNA(VLOOKUP(C86,Reference!$A$1:$E$61,AH86,FALSE))=TRUE,\"\",VLOOKUP(C86,Reference!$A$1:$E$61,AH86,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C87<>\"\",P87<>\"\",Q87<>\"\"),IF(ISNA(VLOOKUP(C87,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C87,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q87,0)),0)","v":0},"","",{"$f":"IF(AND(C87<>\"\",Q87<>\"\",P87<>\"\"),IF(ISNA(VLOOKUP(C87,Reference!$A$1:$E$61,AH87,FALSE))=TRUE,\"\",VLOOKUP(C87,Reference!$A$1:$E$61,AH87,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C88<>\"\",P88<>\"\",Q88<>\"\"),IF(ISNA(VLOOKUP(C88,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C88,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q88,0)),0)","v":0},"","",{"$f":"IF(AND(C88<>\"\",Q88<>\"\",P88<>\"\"),IF(ISNA(VLOOKUP(C88,Reference!$A$1:$E$61,AH88,FALSE))=TRUE,\"\",VLOOKUP(C88,Reference!$A$1:$E$61,AH88,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C89<>\"\",P89<>\"\",Q89<>\"\"),IF(ISNA(VLOOKUP(C89,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C89,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q89,0)),0)","v":0},"","",{"$f":"IF(AND(C89<>\"\",Q89<>\"\",P89<>\"\"),IF(ISNA(VLOOKUP(C89,Reference!$A$1:$E$61,AH89,FALSE))=TRUE,\"\",VLOOKUP(C89,Reference!$A$1:$E$61,AH89,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C90<>\"\",P90<>\"\",Q90<>\"\"),IF(ISNA(VLOOKUP(C90,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C90,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q90,0)),0)","v":0},"","",{"$f":"IF(AND(C90<>\"\",Q90<>\"\",P90<>\"\"),IF(ISNA(VLOOKUP(C90,Reference!$A$1:$E$61,AH90,FALSE))=TRUE,\"\",VLOOKUP(C90,Reference!$A$1:$E$61,AH90,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C91<>\"\",P91<>\"\",Q91<>\"\"),IF(ISNA(VLOOKUP(C91,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C91,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q91,0)),0)","v":0},"","",{"$f":"IF(AND(C91<>\"\",Q91<>\"\",P91<>\"\"),IF(ISNA(VLOOKUP(C91,Reference!$A$1:$E$61,AH91,FALSE))=TRUE,\"\",VLOOKUP(C91,Reference!$A$1:$E$61,AH91,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C92<>\"\",P92<>\"\",Q92<>\"\"),IF(ISNA(VLOOKUP(C92,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C92,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q92,0)),0)","v":0},"","",{"$f":"IF(AND(C92<>\"\",Q92<>\"\",P92<>\"\"),IF(ISNA(VLOOKUP(C92,Reference!$A$1:$E$61,AH92,FALSE))=TRUE,\"\",VLOOKUP(C92,Reference!$A$1:$E$61,AH92,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C93<>\"\",P93<>\"\",Q93<>\"\"),IF(ISNA(VLOOKUP(C93,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C93,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q93,0)),0)","v":0},"","",{"$f":"IF(AND(C93<>\"\",Q93<>\"\",P93<>\"\"),IF(ISNA(VLOOKUP(C93,Reference!$A$1:$E$61,AH93,FALSE))=TRUE,\"\",VLOOKUP(C93,Reference!$A$1:$E$61,AH93,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,{"$f":"IF(AG94<>\"\",AG94,\"\")","v":""},null,null,{"$f":"IF(AND(C94<>\"\",P94<>\"\",Q94<>\"\"),IF(ISNA(VLOOKUP(C94,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C94,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q94,0)),0)","v":0},"","",{"$f":"IF(AND(C94<>\"\",Q94<>\"\",P94<>\"\"),IF(ISNA(VLOOKUP(C94,Reference!$A$1:$E$61,AH94,FALSE))=TRUE,\"\",VLOOKUP(C94,Reference!$A$1:$E$61,AH94,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C95<>\"\",P95<>\"\",Q95<>\"\"),IF(ISNA(VLOOKUP(C95,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C95,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q95,0)),0)","v":0},"","",{"$f":"IF(AND(C95<>\"\",Q95<>\"\",P95<>\"\"),IF(ISNA(VLOOKUP(C95,Reference!$A$1:$E$61,AH95,FALSE))=TRUE,\"\",VLOOKUP(C95,Reference!$A$1:$E$61,AH95,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C96<>\"\",P96<>\"\",Q96<>\"\"),IF(ISNA(VLOOKUP(C96,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C96,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q96,0)),0)","v":0},"","",{"$f":"IF(AND(C96<>\"\",Q96<>\"\",P96<>\"\"),IF(ISNA(VLOOKUP(C96,Reference!$A$1:$E$61,AH96,FALSE))=TRUE,\"\",VLOOKUP(C96,Reference!$A$1:$E$61,AH96,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C97<>\"\",P97<>\"\",Q97<>\"\"),IF(ISNA(VLOOKUP(C97,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C97,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q97,0)),0)","v":0},"","",{"$f":"IF(AND(C97<>\"\",Q97<>\"\",P97<>\"\"),IF(ISNA(VLOOKUP(C97,Reference!$A$1:$E$61,AH97,FALSE))=TRUE,\"\",VLOOKUP(C97,Reference!$A$1:$E$61,AH97,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C98<>\"\",P98<>\"\",Q98<>\"\"),IF(ISNA(VLOOKUP(C98,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C98,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q98,0)),0)","v":0},"","",{"$f":"IF(AND(C98<>\"\",Q98<>\"\",P98<>\"\"),IF(ISNA(VLOOKUP(C98,Reference!$A$1:$E$61,AH98,FALSE))=TRUE,\"\",VLOOKUP(C98,Reference!$A$1:$E$61,AH98,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C99<>\"\",P99<>\"\",Q99<>\"\"),IF(ISNA(VLOOKUP(C99,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C99,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q99,0)),0)","v":0},"","",{"$f":"IF(AND(C99<>\"\",Q99<>\"\",P99<>\"\"),IF(ISNA(VLOOKUP(C99,Reference!$A$1:$E$61,AH99,FALSE))=TRUE,\"\",VLOOKUP(C99,Reference!$A$1:$E$61,AH99,FALSE)),\"\")","v":""},"","","","",0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,"",null,null,{"$f":"IF(AND(C100<>\"\",P100<>\"\",Q100<>\"\"),IF(ISNA(VLOOKUP(C100,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C100,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q100,0)),0)","v":0},"","",{"$f":"IF(AND(C100<>\"\",Q100<>\"\",P100<>\"\"),IF(ISNA(VLOOKUP(C100,Reference!$A$1:$E$61,AH100,FALSE))=TRUE,\"\",VLOOKUP(C100,Reference!$A$1:$E$61,AH100,FALSE)),\"\")","v":""},"","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Runoff, 1.2-Inch (CF)",null,null,"Runoff, 2-Year (CF)",null,null,null,"","",{"$f":"IF(AND(C101<>\"\",Q101<>\"\",P101<>\"\"),IF(ISNA(VLOOKUP(C101,Reference!$A$1:$E$61,AH101,FALSE))=TRUE,\"\",VLOOKUP(C101,Reference!$A$1:$E$61,AH101,FALSE)),\"\")","v":""},"","","","",{"$f":"SUM(AI81:AI100)","v":0},{"$f":"SUM(AJ81:AJ100)","v":0}]
[]
[null,{"$f":"IF(S103=FALSE,Q103,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C103<>\"\",P103<>\"\",Q103<>\"\"),IF(ISNA(VLOOKUP(C103,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C103,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q103,0)),0)","v":0},null,null,null,null,null,null,null,"1.2-Inch Off-Site Volume","2-Yr Off-Site Volume"]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C104<>\"\",P104<>\"\",Q104<>\"\"),IF(ISNA(VLOOKUP(C104,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C104,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q104,0)),0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(S104=TRUE,U104,0)","v":0},{"$f":"IF(S104=TRUE,X104,0)","v":0}]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C105<>\"\",P105<>\"\",Q105<>\"\"),IF(ISNA(VLOOKUP(C105,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C105,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q105,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C106<>\"\",P106<>\"\",Q106<>\"\"),IF(ISNA(VLOOKUP(C106,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C106,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q106,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C107<>\"\",P107<>\"\",Q107<>\"\"),IF(ISNA(VLOOKUP(C107,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C107,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q107,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C108<>\"\",P108<>\"\",Q108<>\"\"),IF(ISNA(VLOOKUP(C108,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C108,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q108,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C109<>\"\",P109<>\"\",Q109<>\"\"),IF(ISNA(VLOOKUP(C109,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C109,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q109,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C110<>\"\",P110<>\"\",Q110<>\"\"),IF(ISNA(VLOOKUP(C110,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C110,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q110,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C111<>\"\",P111<>\"\",Q111<>\"\"),IF(ISNA(VLOOKUP(C111,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C111,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q111,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C112<>\"\",P112<>\"\",Q112<>\"\"),IF(ISNA(VLOOKUP(C112,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C112,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q112,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C113<>\"\",P113<>\"\",Q113<>\"\"),IF(ISNA(VLOOKUP(C113,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C113,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q113,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C114<>\"\",P114<>\"\",Q114<>\"\"),IF(ISNA(VLOOKUP(C114,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C114,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q114,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C115<>\"\",P115<>\"\",Q115<>\"\"),IF(ISNA(VLOOKUP(C115,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C115,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q115,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C116<>\"\",P116<>\"\",Q116<>\"\"),IF(ISNA(VLOOKUP(C116,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C116,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q116,0)),0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(S116=TRUE,U116,0)","v":0},{"$f":"IF(S116=TRUE,X116,0)","v":0}]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C117<>\"\",P117<>\"\",Q117<>\"\"),IF(ISNA(VLOOKUP(C117,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C117,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q117,0)),0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(S117=TRUE,U117,0)","v":0},0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C118<>\"\",P118<>\"\",Q118<>\"\"),IF(ISNA(VLOOKUP(C118,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C118,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q118,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C119<>\"\",P119<>\"\",Q119<>\"\"),IF(ISNA(VLOOKUP(C119,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C119,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q119,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C120<>\"\",P120<>\"\",Q120<>\"\"),IF(ISNA(VLOOKUP(C120,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C120,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q120,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C121<>\"\",P121<>\"\",Q121<>\"\"),IF(ISNA(VLOOKUP(C121,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C121,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q121,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,{"$f":"IF(AND(C122<>\"\",P122<>\"\",Q122<>\"\"),IF(ISNA(VLOOKUP(C122,Reference!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C122,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q122,0)),0)","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AI9=TRUE,SUM(Q81:Q100)>0),SUM(Q81:Q100),IF(AND(AI9=FALSE,SUM(Q103:Q122)>0),SUM(Q103:Q122),\"\"))","v":""}]
[null,{"$f":"IF(AI9=TRUE,SUM(B81:B100),SUM(B103:B122))","v":0},"Totals (CF):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(SUM(U81:U100)>=0,AI9=TRUE),SUM(U81:U100),IF(AND(SUM(U103:U122)>=0,AI9<>TRUE),SUM(U103:U122),\"\"))","v":0},null,null,{"$f":"IF(AND(SUM(X81:X100)>=0,AI9=TRUE),SUM(X81:X100),IF(AND(SUM(X103:X122)>=0,AI9<>TRUE),SUM(X103:X122),\"\"))","v":0},null,null,{"$f":"IF(AI9=TRUE,IF(SUM(AA81:AA100)>=0,SUM(AA81:AA100),IF(SUM(AA103:AA122)>0,SUM(AA103:AA122),\"\")))","v":0},{"$f":"IF(AND(AI9=TRUE,SUM(AA81:AA100)>=0),SUM(AA81:AA100))","v":0},{"$f":"IF(AND(N24<>\"\",N24=\"< 2-Year/24-Hour Storm\",X125>U124,X125<=((X124-X126)+1)),TRUE,FALSE)","v":false},"< 1.2-Inch Credit","1.2-Inch Credit","< 2-Yr Credit","2-Yr Credit","> 2-Yr Credit",{"$f":"IF(SUM(AI103:AI122)>0,SUM(AI103:AI122),0)","v":0},{"$f":"IF(SUM(AJ103:AJ122)>0,SUM(AJ103:AJ122),0)","v":0},{"$f":"IF(AND(OR(N24<>\"\",AB16<>\"\"),R6<>\"\"),IF(OR(AB16=\"Y\",AND(R6=\"MRC Bioretention\",OR(N24=\"2-Year/24-Hour Storm\",N24=\"> 2-Year/24-Hour Storm\")),AND(R6=\"MRC Storage Systems\",OR(N24=\"2-Year/24-Hour Storm\",N24=\"> 2-Year/24-Hour Storm\"))),AN123,IF(U125<>\"\",(U125/U124)*AK123,AK123)),\"\")","v":""},{"$f":"IF(AND(OR(N24<>\"\",AB16<>\"\"),R6<>\"\"),IF(OR(AB16=\"Y\",AND(R6=\"MRC Bioretention\",OR(N24=\"2-Year/24-Hour Storm\",N24=\"> 2-Year/24-Hour Storm\")),AND(R6=\"MRC Storage Systems\",OR(N24=\"2-Year/24-Hour Storm\",N24=\"> 2-Year/24-Hour Storm\"))),AO123,IF(U125<>\"\",(U125/U124)*AL123,AL123)),\"\")","v":""},{"$f":"IF(AND(OR(N24<>\"\",AB16<>\"\"),R6<>\"\"),IF(OR(AB16=\"Y\",AND(R6=\"MRC Bioretention\",OR(N24=\"2-Year/24-Hour Storm\",N24=\"> 2-Year/24-Hour Storm\")),AND(R6=\"MRC Storage Systems\",OR(N24=\"2-Year/24-Hour Storm\",N24=\"> 2-Year/24-Hour Storm\"))),AP123,IF(U125<>\"\",(U125/U124)*AM123,AM123)),\"\")","v":""}]
[null,null,"Volume Planned to be Routed to SCM (CF):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U125<>\"\",U125/(0.083333*43560),U124/(0.083333*43560))","v":0},{"$f":"IF(U125=\"\",U124,U125)","v":0},null,{"$f":"IF(AND(N24=\"< 1.2-Inch/2-Hour Storm\",U125<>\"\",X127<>\"\"),X127,\"\")","v":""},{"$f":"IF(AND(N24=\"1.2-Inch/2-Hour Storm\",X124<>\"\"),X124-X126,\"\")","v":""},{"$f":"IF(AND(N24=\"< 2-Year/24-Hour Storm\",X124<>\"\"),X124-X126,\"\")","v":""},{"$f":"IF(AND(N24=\"2-Year/24-Hour Storm\",X124<>\"\"),X124-X126,\"\")","v":""},{"$f":"IF(AND(N24=\"> 2-Year/24-Hour Storm\",X124<>\"\"),X124-X126,\"\")","v":""}]
[null,null,"Total Volume from Off-Site Sources (CF):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI9=TRUE,AI101,AI124)","v":0},null,null,{"$f":"IF(AI9=TRUE,AJ101,AJ124)","v":0},null,null,null,{"$f":"IF(AND(U125<>\"\",U125<U124,U125<=(U124-U126)),U125,IF(OR(AND(R6=\"MRC Bioretention\",OR(N24=\"< 2-Year/24-Hour Storm\",N24=\"1.2-Inch/2-Hour Storm\",N24=\"< 1.2-Inch/2-Hour Storm\"),AB16=\"Y\",V140<=V139),AND(R6=\"MRC Storage Systems\",OR(N24=\"< 2-Year/24-Hour Storm\",N24=\"1.2-Inch/2-Hour Storm\",N24=\"< 1.2-Inch/2-Hour Storm\"),AB16=\"Y\",V178<=V177)),MAX(AB125-IF(U126<>\"\",U126,0),X124-IF(X126<>\"\",X126,0)),AB125-IF(U126<>\"\",U126,0)))","v":0}]
[null,null,"Equivalent Impervious Area (ac):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AA124<>\"\",AA125<>\"\"),IF(U125<>\"\",AA125,IF(AA125<AA124,AA124,AA125)),\"\")","v":0},null,null,{"$f":"IF(AND(U125<>\"\",K8<>\"\"),U127*43560*(((K8-0.040816)^2/(K8+0.163265))/12),\"\")","v":""},null,null,null,"Volume Credit:",{"$f":"IF(AD125<>\"\",AD125,IF(AE125<>\"\",AE125,IF(AF125<>\"\",AF125,IF(AG125<>\"\",AG125,IF(AH125<>\"\",AH125)))))","v":false}]
[]
[null,null,"Design Standards"]
[]
[null,null,"MRC Bioretention",null,null,null,null,null,null,null,null,null,null,null,null,null,"Variation:"]
[]
[null,null,"Parameter",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI1=TRUE,\"Standard per Cell\",\"Standard\")","v":"Standard"},null,null,null,null,"Design Value",null,null,null,null,null,"Deduction","Required?","Entry Complete?"]
[null,null,"Bypass/Overflow Volume @ 1.2-Inch/2-Hour Storm",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V134<>\"\",IF(V134>0,0.5,0),\"\")","v":""},"Y",{"$f":"IF(OR(AC134=\"\",AND(AC134=\"Y\",V134<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"MRC SCM Drainage Area (Equivalent Impervious, maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AI5=TRUE,AI6=TRUE,AI7=TRUE),IF(AI13=TRUE,\"-\",IF(N24<>\"\",IF(AND(OR(N24=\"1.2-Inch/2-Hour Storm\",N24=\"< 1.2-Inch/2-Hour Storm\"),AI5=TRUE),6,IF(AND(OR(N24=\"1.2-Inch/2-Hour Storm\",N24=\"< 1.2-Inch/2-Hour Storm\"),AI5=FALSE),5,IF(AND(OR(N24=\"< 2-Year/24-Hour Storm\",N24=\"2-Year/24-Hour Storm\"),AI5=TRUE),2.5,IF(AND(OR(N24=\"< 2-Year/24-Hour Storm\",N24=\"2-Year/24-Hour Storm\"),AI5=FALSE),2,IF(AND(N24=\"> 2-Year/24-Hour Storm\",AI5=TRUE),1.5,IF(AND(N24=\"> 2-Year/24-Hour Storm\",AI5=FALSE),1)))))),\"\")),\"\")","v":""},null,null,null,null,{"$f":"IF(AND($AI$1=TRUE,$O$12<>\"\",$U$127<>\"\"),$U$127/$O$12,IF(AND(OR($AI$1<>TRUE,$O$12=\"\"),$U$127<>\"\"),$U$127,\"\"))","v":0},null,null,null,null,null,{"$f":"IF(Q135=\"-\",0,IF(AND(X8<>\"\",Q135<>\"\",V135<>\"\"),IF(OR(V135>(Q135+0.1),AB9=\"Y\"),0.5,0),\"\"))","v":""},"Y",{"$f":"IF(OR(AC135=\"\",AND(AC135=\"Y\",V135<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Hydraulic Allowance for Diversion (inches) (maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N24<>\"\",IF(OR(N24=\"< 1.2-Inch/2-Hour Storm\",N24=\"1.2-Inch/2-Hour Storm\",N24=\"< 2-Year/24-Hour Storm\",N24=\"2-Year/24-Hour Storm\"),\"6\",\"-\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(V136<>\"\",IF(V136=\"> 24\",24,V136),\"\")","v":""},{"$f":"IF(Q136<>\"-\",IF(AND(Q136<>\"\",AA136<>\"\"),IF(AA136>(Q136*1.1),(AA136-(Q136*1.1))/(Q136*1.1),0),\"\"),0)","v":""},{"$f":"IF(N24<>\"> 2-Year/24-Hour Storm\",\"Y\",\"\")","v":"Y"},""]
[null,null,"Ponding Depth @ 1.2-Inch/2-Hour Storm (ft) (maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,{"$f":"IF(V137=TRUE,1,IF(V137=FALSE,2,IF(V137=\"\",0)))","v":2},{"$f":"IF(AND(Q137<>\"\",V137<>\"\"),IF(V137>(Q137*1.1),(V137-(Q137*1.1))/(Q137*1.1),0),\"\")","v":""},"Y",""]
[null,null,"Ponding Depth @ 2-Year/24-Hour Storm (ft) (maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q138<>\"\",V138<>\"\"),IF(V138>(Q138*1.1),(V138-(Q138*1.1))/(Q138*1.1),0),\"\")","v":""},"Y",{"$f":"IF(OR(N24=\"1.2-Inch/2-Hour Storm\",AND(N24<>\"1.2-Inch/2-Hour Storm\",V138<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"Pre-Construction 1-Year/24-Hour Peak Rate (cfs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",""]
[null,null,"Post-Construction 2-Year/24-Hour Peak Rate (cfs) (see Note 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V139<>\"\",IF(V139<0.15,0.15,V139),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q140<>\"\",V140<>\"\"),IF(V140>Q140,1,0),\"\")","v":""},"Y",""]
[null,null,"Controlled Release Rate for 1.2-Inch/2-Hour Storm (cfs) (see Note 2)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U127<>\"\",ROUNDUP(((U127/IF(AND(AI1=TRUE,$O$12<>\"\"),$O$12,1))*0.02),2),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q141<>\"\",\"Y\",\"\")","v":"Y"}]
[null,null,"Underdrain Outflow Rate for 1.2-Inch/2-Hour Storm (cfs).",null,null,null,null,null,null,null,null,null,null,null,null,null,"≤ Controlled Release",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q141<>\"\",V142<>\"\"),IF(V142>Q141,1,0),\"\")","v":""},"Y",{"$f":"IF(OR(AC142=\"\",AND(AC142=\"Y\",V142<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"Ponding Time for Storm Event Routed to MRC SCM (hrs) (maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,72,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q143<>\"\",V143<>\"\"),IF(V143>(Q143*1.1),(V143-(Q143*1.1))/(Q143*1.1),0),\"\")","v":""},"Y",""]
[null,null,"Soil Media Depth Above Internal Water Storage (IWS) (ft) (minimum)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V144<>\"\",IF(V144<Q144,0.5,0),\"\")","v":""},"Y",""]
[null,null,"IWS Depth (ft) (minimum)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V145<>\"\",IF(V145<Q145,0.5,0),\"\")","v":""},"Y",""]
[null,null,"Inflow Velocity for Storm Event Routed to MRC SCM (fps) (maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N24<>\"\",IF(OR(N24=\"< 1.2-Inch/2-Hour Storm\",N24=\"1.2-Inch/2-Hour Storm\",N24=\"< 2-Year/24-Hour Storm\",N24=\"2-Year/24-Hour Storm\"),2,3),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q146<>\"\",V146<>\"\"),IF(V146>(Q146*1.1),(V146-(Q146*1.1))/(Q146*1.1),0),\"\")","v":""},"Y",""]
[null,null,"Separation Distance Between MRC SCM Bottom and SHWT (in)",null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V148<>TRUE,IF(AND(Q147<>\"\",V147<>\"\"),IF(V147<(Q147-(Q147*0.1)),((Q147-(Q147*0.1))-V147)/(Q147-(Q147*0.1)),0),\"\"),0)","v":""},"Y",""]
[null,null,"A Synthetic Liner Will Be Installed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",""]
[null,null,"Reason for Liner:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V148=TRUE,\"Y\",\"\")","v":""},{"$f":"IF(OR(AC150=\"\",AND(AC150=\"Y\",C150<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Diameter of Managed Release Orifice (in) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",{"$f":"IF(OR(AC151=\"\",AND(AC151=\"Y\",V151<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"SCM Embankment Slopes ",null,null,null,null,null,null,null,null,null,null,null,null,null,0.33,null,null,null,null,null,null,null,null,null,null,null,"Y",{"$f":"IF(OR(AC152=\"\",AND(AC152=\"Y\",V152<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"Check Dams and Level Step Sections Separated by Undisturbed Earth Will Be Provided",null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V153<>\"\",V131=\"MRC Bioswale\"),IF(V153=TRUE,0,0.25),\"\")","v":""},{"$f":"IF(V131=\"MRC Bioswale\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC153=\"\",AND(AC153=\"Y\",V153<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Pretreatment",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N24<>\"\",IF(N24=\"> 2-Year/24-Hour Storm\",\"Forebay\",\"-\"),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"IF(V154=TRUE,1,IF(V154=FALSE,2,IF(V154=\"\",0)))","v":2},null,"Y",{"$f":"IF(OR(AC154=\"\",AND(AC154=\"Y\",V154<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"Description of Pretreatment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V154=\"Other\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC156=\"\",AND(AC156=\"Y\",C156<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Forebay Storage Volume (CF) (minimum)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U127<>\"\",N24=\"> 2-Year/24-Hour Storm\",V154=\"Forebay\"),U127*0.25*3630,\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q157<>\"\",V157<>\"\",N24=\"> 2-Year/24-Hour Storm\"),IF(V157<Q157,0.25,0),\"\")","v":""},{"$f":"IF(V154=\"Forebay\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC157=\"\",AND(AC157=\"Y\",V157<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Forebay Length in Direction of Flow (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V154=\"Forebay\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Forebay Width (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V158<>\"\",V159<>\"\"),V158/V159,\"\")","v":""},null,{"$f":"IF(V154=\"Forebay\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Forebay Length:Width Ratio (minimum)",null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,":",1,null,{"$f":"IF(AA159<>\"\",AA159,\"\")","v":""},null,{"$f":"IF(AND(V158<>\"\",V159<>\"\"),\":\",\"\")","v":""},{"$f":"IF(AND(V158<>\"\",V159<>\"\"),\"1\",\"\")","v":""},null,null,{"$f":"IF(AND(Q160<>\"\",V160<>\"\",N24=\"> 2-Year/24-Hour Storm\"),IF(V160<(Q160*0.9),((Q160*0.9)-V160)/(Q160*0.9),0),\"\")","v":""},{"$f":"IF(V154=\"Forebay\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Forebay Depth (ft) (minimum)",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q161<>\"\",V161<>\"\",N24=\"> 2-Year/24-Hour Storm\"),IF(V161<(Q161*0.9),((Q161*0.9)-V161)/(Q161*0.9),0),\"\")","v":""},{"$f":"IF(V154=\"Forebay\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Forebay Dewatering Time (hrs) (maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,72,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q162<>\"\",V162<>\"\",N24=\"> 2-Year/24-Hour Storm\"),IF(V162>(Q162*1.1),(V162-(Q162*1.1))/(Q162*1.1),0),\"\")","v":""},{"$f":"IF(V154=\"Forebay\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Forebay Flow Rate @ Maximum Routed Storm (cfs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V154=\"Forebay\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Forebay Cross-Sectional Area Perpendicular to Flow (SF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V154=\"Forebay\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Forebay Flow Through Velocity (fps) (maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,{"$f":"IF(AND(V163<>\"\",V164<>\"\"),V163/V164,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(Q165<>\"\",V165<>\"\",N24=\"> 2-Year/24-Hour Storm\"),IF(V165>(Q165*1.1),(V165-(Q165*1.1))/(Q165*1.1),0),\"\")","v":""},{"$f":"IF(V154=\"Forebay\",\"Y\",\"\")","v":""},"Y"]
[null,null,"SCM Bed Bottom Area (SF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",{"$f":"IF(OR(AC166=\"\",AND(AC166=\"Y\",V166<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(AD134:AD166)=0,IF((SUM(AB134:AB166)+AB24)>1,1,SUM(AB134:AB166)+AB24),\"\")","v":""},null,{"$f":"IF(COUNTBLANK(AD134:AD166)=0,\"Y\",\"\")","v":""}]
[null,null,"Note 1:",null,"The standard is either 1) ≤ the pre-construction 1-Year/24-Hour Peak Rate OR 2) 0.15 cfs, if the 1-Year/24-Hour Peak Rate is < 0.15 cfs."]
[null,null,"Note 2:",null,"The standard is calculated based on the MRC release rate for the 1.2-Inch/2-Hour storm of 0.02 cfs/acre equivalent impervious x equivalent impervious in the drainage area (of each cell)."]
[]
[null,null,"MRC Storage Systems",null,null,null,null,null,null,null,null,null,null,null,null,"Variation:"]
[]
[null,null,"Parameter",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI1=TRUE,\"Standard per Cell\",\"Standard\")","v":"Standard"},null,null,null,null,"Design Value",null,null,null,null,null,"Deduction","Required?","Entry Complete?"]
[null,null,"Bypass/Overflow Volume @ 1.2-Inch/2-Hour Storm",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V174<>\"\",IF(V174>0,0.5,0),\"\")","v":""},"Y",{"$f":"IF(OR(AC174=\"\",AND(AC174=\"Y\",V174<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"MRC SCM Drainage Area (Equivalent Impervious, maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AI5=TRUE,AI6=TRUE,AI7=TRUE),IF(AI13=TRUE,\"-\",IF(N24<>\"\",IF(AND(OR(N24=\"< 1.2-Inch/2-Hour Storm\",N24=\"1.2-Inch/2-Hour Storm\"),AI5=TRUE),6,IF(AND(OR(N24=\"< 1.2-Inch/24-Hour Storm\",N24=\"1.2-Inch/2-Hour Storm\"),AI5=FALSE),5,IF(AND(OR(N24=\"< 2-Year/24-Hour Storm\",N24=\"2-Year/24-Hour Storm\"),AI5=TRUE),2.5,IF(AND(OR(N24=\"< 2-Year/24-Hour Storm\",N24=\"2-Year/24-Hour Storm\"),AI5=FALSE),2,IF(AND(N24=\"> 2-Year/24-Hour Storm\",AI5=TRUE),1.5,IF(AND(N24=\"> 2-Year/24-Hour Storm\",AI5=FALSE),1)))))),\"\")),\"\")","v":""},null,null,null,null,{"$f":"IF(AND($AI$1=TRUE,$O$12<>\"\",$U$127<>\"\"),$U$127/$O$12,IF(AND(OR($AI$1<>TRUE,$O$12=\"\"),$U$127<>\"\"),$U$127,\"\"))","v":0},null,null,null,null,null,{"$f":"IF(AND(Q175<>\"\",V175<>\"\"),IF(V175>(Q175+0.1),0.5,0),\"\")","v":""},"Y","Y"]
[null,null,"Storage Unit - Freeboard (inches) (minimum)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N24<>\"\",IF(OR(N24=\"< 1.2-Inch/2-Hour Storm\",N24=\"1.2-Inch/2-Hour Storm\",N24=\"< 2 -Year/24-Hour Storm\",N24=\"2-Year/24-Hour Storm\"),\"6\",\"12\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(V176<>\"\",IF(V176=\"> 24\",24,V176),\"\")","v":""},{"$f":"IF(AND(Q176<>\"\",AA176<>\"\"),IF((Q176*0.9)>AA176,((Q176*0.9)-AA176)/(Q176*0.9),0),\"\")","v":""},"Y",""]
[null,null,"Storage Unit - Pre-Construction 1-Year/24-Hour Peak Rate (cfs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",""]
[null,null,"Storage Unit - Post-Construction 2-Year/24-Hour Peak Rate (cfs) (see Note 1)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V177<>\"\",IF(V177<0.15,0.15,V177),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q178<>\"\",V178<>\"\"),IF(V178>Q178,1,0),\"\")","v":""},"Y",""]
[null,null,"Storage Unit - Controlled Release Rate for 1.2-Inch/2-Hour Storm (cfs) (see Note 2)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U127<>\"\",ROUNDUP(((U127/IF(AND(AI1=TRUE,$O$12<>\"\"),$O$12,1))*0.02),2),\"\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q179<>\"\",\"Y\",\"\")","v":"Y"}]
[null,null,"Storage Unit - Underdrain Outflow Rate for 1.2-Inch/2-Hour Storm (cfs).",null,null,null,null,null,null,null,null,null,null,null,null,null,"≤ Controlled Release Rate",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q179<>\"\",V180<>\"\"),IF(V180>Q179,1,0),\"\")","v":""},"Y",{"$f":"IF(OR(AC180=\"\",AND(AC180=\"Y\",V180<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"Storage Unit - Drawdown Time for Storm Event Routed to MRC SCM (hrs) (maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,168,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q181<>\"\",V181<>\"\"),IF(V181>(Q181*1.1),(V181-(Q181*1.1))/(Q181*1.1),0),\"\")","v":""},"Y",""]
[null,null,"Storage Unit - Separation Distance Between MRC SCM Bottom and SHWT (in)",null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V185<>TRUE,IF(AND(Q182<>\"\",V182<>\"\"),IF(V182<(Q182-(Q182*0.1)),((Q182-(Q182*0.1))-V182)/(Q182-(Q182*0.1)),0),\"\"),0)","v":""},"Y",""]
[null,null,"Storage Unit - IWS Depth (ft) (minimum)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V183<>\"\",IF(V183<Q183,0.5,0),\"\")","v":""},"Y",""]
[null,null,"Storage Unit - IWS Area (SF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",""]
[null,null,"Storage Unit - A Synthetic Liner Will Be Installed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",""]
[null,null,"Reason for Liner:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V185=TRUE,\"Y\",\"\")","v":""},{"$f":"IF(OR(AC187=\"\",AND(AC187=\"Y\",C187<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Storage Unit - Diameter of Managed Release Orifice (in) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y",{"$f":"IF(OR(AC188=\"\",AND(AC188=\"Y\",V188<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"Storage Unit - Pretreatment for Additional Flows",null,null,null,null,null,null,null,null,null,null,null,null,null,"TRUE OR N/A",null,null,null,null,null,null,null,null,null,{"$f":"IF(V189=\"\",0,IF(V189=TRUE,1,IF(V189=FALSE,2)))","v":0},{"$f":"IF(AA189=2,0.25,0)","v":0},{"$f":"IF(AND(U125<>\"\",U125<>0),\"Y\",\"\")","v":""},"Y"]
[null,null,"Upstream Vegetated Component - Ponding Depth @ 1.2-Inch/2-Hour Storm (ft) (maximum) ",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q190<>\"\",V190<>\"\"),IF(V190>(Q190*1.1),(V190-(Q190*1.1))/(Q190*1.1),0),\"\")","v":""},{"$f":"IF($S$171=\"Upstream Vegetated Component\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Upstream Vegetated Component - Soil Media Depth (ft) (minimum) ",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,null,null,null,null,null,null,null,null,null,{"$f":"IF(V191=TRUE,1,IF(V191=FALSE,2,IF(V191=\"\",0)))","v":2},{"$f":"IF(AND(Q191<>\"\",V191<>\"\"),IF(V191<(Q191*0.9),((Q191*0.9)-V191)/(Q191*0.9),0),\"\")","v":""},{"$f":"IF($S$171=\"Upstream Vegetated Component\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Upstream Vegetated Component - Surface Area (SF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($S$171=\"Upstream Vegetated Component\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Upstream MTD - NJDEP/TAPE Certified to Remove ≥ 50% TSS at 2-Year/24-Hour Storm Flow (or Non-Proprietary Sand Filter)",null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V193<>\"\",IF(V193=TRUE,0,0.5),\"\")","v":""},{"$f":"IF($S$171=\"Upstream MTD Pretreatment\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Permeable Pavement - Direct Connections",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($S$171=\"Permeable Pavement\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Description of Pretreatment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V194=TRUE,$S$171=\"Permeable Pavement\"),\"Y\",\"\")","v":""},{"$f":"IF(OR(AC196=\"\",AND(AC196=\"Y\",C196<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Permeable Pavement - Adjacent Areas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($S$171=\"Permeable Pavement\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC197=\"\",AND(AC197=\"Y\",V197<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Description of Pretreatment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V197=TRUE,$S$171=\"Permeable Pavement\"),\"Y\",\"\")","v":""},{"$f":"IF(OR(AC199=\"\",AND(AC199=\"Y\",C199<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Permeable Pavement - Street Sweeper Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($S$171=\"Permeable Pavement\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC200=\"\",AND(AC200=\"Y\",V200<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Permeable Pavement - Sweeping Frequency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($S$171=\"Permeable Pavement\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC201=\"\",AND(AC201=\"Y\",V201<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Additional Pretreatment",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N24<>\"> 2-Year/24-Hour Storm\",\"-\",\"Forebay / Settling Chamber\")","v":"-"},null,null,null,null,null,null,null,null,null,{"$f":"IF(V202=TRUE,1,IF(V202=FALSE,2,IF(V202=\"\",0)))","v":2},null,{"$f":"IF(N24=\"> 2-Year/24-Hour Storm\",\"Y\",\"\")","v":""},{"$f":"IF(OR($AC$202=\"\",AND($AC$202=\"Y\",V202<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,{"$f":"CONCATENATE(V202,\" Storage Volume (CF) (minimum)\")","v":" Storage Volume (CF) (minimum)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U127<>\"\",N24=\"> 2-Year/24-Hour Storm\",V202<>\"\"),ROUND(U127*0.25*3630,0),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q203<>\"\",V203<>\"\",N24=\"> 2-Year/24-Hour Storm\"),IF(V203<Q203,0.25,0),\"\")","v":""},{"$f":"IF(V202<>\"\",\"Y\",\"\")","v":""},"Y"]
[null,null,{"$f":"CONCATENATE(V202,\" Length in Direction of Flow (ft)\")","v":" Length in Direction of Flow (ft)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V203<>\"\",\"Y\",\"\")","v":""},"Y"]
[null,null,{"$f":"CONCATENATE(V202,\" Width (ft)\")","v":" Width (ft)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V204<>\"\",V205<>\"\"),V204/V205,\"\")","v":""},null,"","Y"]
[null,null,{"$f":"CONCATENATE(V202,\" Length:Width Ratio (minimum)\")","v":" Length:Width Ratio (minimum)"},null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,":",1,null,{"$f":"IF(AA205<>\"\",AA205,\"\")","v":""},null,{"$f":"IF(AND(V204<>\"\",V205<>\"\"),\":\",\"\")","v":""},{"$f":"IF(AND(V204<>\"\",V205<>\"\"),\"1\",\"\")","v":""},null,null,{"$f":"IF(AND(Q206<>\"\",V206<>\"\",N24=\"> 2-Year/24-Hour Storm\"),IF(V206<(Q206*0.9),((Q206*0.9)-V206)/(Q206*0.9),0),\"\")","v":""},"","Y"]
[null,null,{"$f":"CONCATENATE(V202,\" Depth (ft) (minimum)\")","v":" Depth (ft) (minimum)"},null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q207<>\"\",V207<>\"\",N24=\"> 2-Year/24-Hour Storm\"),IF(V207<(Q207*0.9),((Q207*0.9)-V207)/(Q207*0.9),0),\"\")","v":""},"","Y"]
[null,null,{"$f":"CONCATENATE(V202,\" Flow Rate @ Maximum Routed Storm (cfs)\")","v":" Flow Rate @ Maximum Routed Storm (cfs)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Y"]
[null,null,{"$f":"CONCATENATE(V202,\" Cross-Sectional Area Perpendicular to Flow (SF)\")","v":" Cross-Sectional Area Perpendicular to Flow (SF)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Y"]
[null,null,{"$f":"CONCATENATE(V202,\" Flow Through Velocity (fps) (maximum)\")","v":" Flow Through Velocity (fps) (maximum)"},null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,{"$f":"IF(AND(V208<>\"\",V209<>\"\"),V208/V209,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(Q210<>\"\",V210<>\"\",V179=\"> 2-Year/24-Hour Storm\"),IF(V210>(Q210*1.1),(V210-(Q210*1.1))/(Q210*1.1),0),\"\")","v":""},"","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(AD174:AD210)=0,IF(SUM(AB174:AB210)+AB24>1,1,SUM(AB174:AB210)+AB24),\"\")","v":""},null,{"$f":"IF(AND($S$171<>\"\",COUNTBLANK(AD174:AD210)=0),\"Y\",\"\")","v":""}]
[null,null,"Note 1:",null,"The standard is either 1) ≤ the pre-construction 1-Year/24-Hour Peak Rate OR 2) 0.15 cfs, if the 1-Year/24-Hour Peak Rate is < 0.15 cfs."]
[null,null,"Note 2:",null,"The standard is calculated based on the MRC release rate for the 1.2-Inch/2-Hour storm of 0.02 cfs/acre equivalent impervious x equivalent impervious in the drainage area (of each cell)."]
[]
[null,null,"Volume Management Credit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Storage Volume","Bio Volume"]
[]
[null,null,"There are design standard deviations; a justification for the deviations is attached",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AC127<>\"\",R6<>\"\"),IF(R6=\"MRC Storage Systems\",IF(AB221<>\"Y\",AC127*(1-IF(AB211<>\"\",AB211,0)),AC127),\"\"),\"\")","v":""},{"$f":"IF(AND(AC127<>\"\",R6<>\"\"),IF(R6=\"MRC Bioretention\",IF(AB221<>\"Y\",AC127*(1-IF(AB167<>\"\",AB167,0)),AC127),\"\"),\"\")","v":""}]
[null,null,"The applicant is seeking full management credit for this design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB217<>\"\",IF(AND(AB217<>\"\",AB211>0,AB211<1,OR(AND(W221=TRUE,W218=TRUE),W217=TRUE)),AB217/(1-AB211),AB217),\"\")","v":""},{"$f":"IF(AC217<>\"\",IF(AND(AC217<>\"\",AB167>0,AB167<1,OR(AND(W221=TRUE,W218=TRUE),W217=TRUE)),AC217/(1-AB167),AC217),\"\")","v":""}]
[null,null,"Volume Management Credit (CF):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(R6=\"MRC Bioretention\",AD167=\"Y\",AC218<>\"\"),AC218,IF(AND(R6=\"MRC Storage Systems\",AD211=\"Y\",AB218<>\"\"),AB218,\"\"))","v":""}]
[]
[null,null,"The design has been approved by DEP's Bureau of Clean Water (attached)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(AND(R6=\"MRC Bioretention\",AB167>=1),AND(R6=\"MRC Storage Systems\",AB211>=1)),W218=TRUE,W221=TRUE),\"Y\",\"\")","v":""}]
[]
[null,"CERTIFICATION"]
[null,"I certify under penalty of law and subject to the penalties of 18 Pa.C.S. § 4904 (relating to unsworn falsification to authorities) that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gathered and evaluated the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I further certify that the structure, function, and calculations contained in this spreadsheet have not been modified in comparison to the spreadsheet DEP has posted to its website."]
[]
[null,null,"PA-Licensed Professional Engineer Responsible for Design:"]
[]
[null,null,"Professional Engineer Company:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"License No.:"]

{"sheet":"Reference","index":1,"n_rows":61,"n_cols":21,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["Land_Cover","A","B","C","D","IMP?","TSS_Conc (mg/L)","TP_Conc (mg/L)","TN_Conc (mg/L)","Soils","CN",null,"LandCover_Pre_Construction","A","B","C","D","TSS_Conc (mg/L)","TP_Conc (mg/L)","TN_Conc (mg/L)","IMP?"]
["Open Space (Lawns, Parks, Golf Courses, Cemeteries, Etc.) - Poor Condition (Grass Cover < 50%)",68,79,86,89,null,78,0.25,1.25,"A",40,null,"Pervious as Meadow",30,58,71,78,48.8,0.22,2.2999999999999998]
["Open Space (Lawns, Parks, Golf Courses, Cemeteries, Etc.) - Fair Condition (Grass Cover 50% to 75%)",49,69,79,84,null,78,0.25,1.25,"B",41,null,"Impervious as Meadow",30,58,71,78,48.8,0.22,2.2999999999999998]
["Open Space (Lawns, Parks, Golf Courses, Cemeteries, Etc.) - Good Condition (Grass Cover > 75%)",39,61,74,80,null,78,0.25,1.25,"C",42,null,"Forested (Good Condition)",30,55,70,77,45,0.13,1.05]
["Impervious Areas: Paved Parking Lots, Roofs, Driveways, Etc. (Excluding ROW)",98,98,98,98,"Y",65,0.28999999999999998,2.0499999999999998,"D",43,null,"Impervious Areas: Paved Parking Lots, Roofs, Driveways, Etc. (Excluding ROW)",98,98,98,98,65,0.28999999999999998,2.0499999999999998,"Y"]
["Impervious Areas: Streets and Roads - Paved; Curbs and Storm Sewers (Excluding ROW)",98,98,98,98,"Y",142,0.32,3,"N/A",44,null,"Impervious Areas: Streets and Roads - Paved; Curbs and Storm Sewers (Excluding ROW)",98,98,98,98,142,0.32,3,"Y"]
["Impervious Areas: Streets and Roads - Paved; Open Ditches (Including ROW)",83,89,92,93,null,141,0.43,2.65,null,45,null,"Impervious Areas: Streets and Roads - Paved; Open Ditches (Including ROW)",83,89,92,93,141,0.43,2.65]
["Impervious Areas: Streets and Roads - Gravel (Including ROW)",76,85,89,91,null,141,0.43,2.65,null,46,null,"Impervious Areas: Streets and Roads - Gravel (Including ROW)",76,85,89,91,141,0.43,2.65]
["Impervious Areas: Streets and Roads - Dirt (Including ROW)",72,82,87,89,null,141,0.43,2.65,null,47,null,"Impervious Areas: Streets and Roads - Dirt (Including ROW)",72,82,87,89,141,0.43,2.65]
["Impervious Areas: Commercial",98,98,98,98,"Y",61.72,0.22,2.02,null,48,null,"Impervious Areas: Commercial",98,98,98,98,61.72,0.22,2.02,"Y"]
["Impervious Areas: Industrial",98,98,98,98,"Y",81,0.24,2.0099999999999998,null,49,null,"Impervious Areas: Industrial",98,98,98,98,81,0.24,2.0099999999999998,"Y"]
["Impervious Areas: Institutional ",98,98,98,98,"Y",67.489999999999995,0.14000000000000001,1.21,null,50,null,"Impervious Areas: Institutional ",98,98,98,98,67.489999999999995,0.14000000000000001,1.21,"Y"]
["Fallow - Bare Soil",77,86,91,94,null,216,1.07,7.7,null,51]
["Fallow - Crop Residue Cover (Poor Condition)",76,85,90,93,null,216,1.07,7.7,null,52]
["Fallow - Crop Residue Cover (Good Condition)",74,83,88,90,null,216,1.07,7.7,null,53]
["Row Crops - Straight Row (Poor Condition)",72,81,88,91,null,145,0.55000000000000004,5.71,null,54]
["Row Crops - Straight Row (Good Condition)",67,78,85,89,null,145,0.55000000000000004,5.71,null,55]
["Row Crops - Straight Row & Crop Residue (Poor Condition)",71,80,87,90,null,216,1.07,7.7,null,56]
["Row Crops - Straight Row & Crop Residue (Good Condition)",64,75,82,85,null,216,1.07,7.7,null,57]
["Row Crops - Contoured (Poor Condition)",70,79,84,88,null,145,0.55000000000000004,5.71,null,58]
["Row Crops - Contoured (Good Condition)",65,75,82,86,null,145,0.55000000000000004,5.71,null,59]
["Row Crops - Contoured & Crop Residue (Poor Condition)",69,78,83,87,null,216,1.07,7.7,null,60]
["Row Crops - Contoured & Crop Residue (Good Condition)",64,74,81,85,null,216,1.07,7.7,null,61]
["Row Crops - Contoured & Terraced (Poor Condition)",66,74,80,82,null,145,0.55000000000000004,5.71,null,62]
["Row Crops - Contoured & Terraced (Good Condition)",62,71,78,81,null,145,0.55000000000000004,5.71,null,63]
["Row Crops - Contoured, Terraced & Crop Residue (Poor Condition)",65,73,79,81,null,216,1.07,7.7,null,64]
["Row Crops - Contoured, Terraced & Crop Residue (Good Condition)",61,70,77,80,null,216,1.07,7.7,null,65]
["Small Grain - Straight Row (Poor Condition)",65,76,84,88,null,145,0.55000000000000004,5.71,null,66]
["Small Grain - Straight Row (Good Condition)",63,75,83,87,null,145,0.55000000000000004,5.71,null,67]
["Small Grain - Straight Row & Crop Residue (Poor Condition)",64,75,83,86,null,216,1.07,7.7,null,68]
["Small Grain - Straight Row & Crop Residue (Good Condition)",60,72,80,84,null,216,1.07,7.7,null,69]
["Small Grain - Contoured (Poor Condition)",63,74,82,85,null,145,0.55000000000000004,5.71,null,70]
["Small Grain - Contoured (Good Condition)",61,73,81,84,null,145,0.55000000000000004,5.71,null,71]
["Small Grain - Contoured & Crop Residue (Poor Condition)",62,73,81,84,null,216,1.07,7.7,null,72]
["Small Grain - Contoured & Crop Residue (Good Condition)",60,72,80,83,null,216,1.07,7.7,null,73]
["Small Grain - Contoured & Terraced (Poor Condition)",61,72,79,82,null,145,0.55000000000000004,5.71,null,74]
["Small Grain - Contoured & Terraced (Good Condition)",59,70,78,81,null,145,0.55000000000000004,5.71,null,75]
["Small Grain - Contoured, Terraced & Crop Residue (Poor Condition)",60,71,78,81,null,216,1.07,7.7,null,76]
["Small Grain - Contoured, Terraced & Crop Residue (Good Condition)",58,69,77,80,null,216,1.07,7.7,null,77]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Straight Row (Poor Condition)",66,77,85,89,null,145,0.55000000000000004,5.71,null,78]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Straight Row (Good Condition)",58,72,81,85,null,145,0.55000000000000004,5.71,null,79]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured (Poor Condition)",64,75,83,85,null,145,0.55000000000000004,5.71,null,80]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured (Good Condition)",55,69,78,83,null,145,0.55000000000000004,5.71,null,81]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured & Terraced (Poor Condition)",63,73,80,83,null,145,0.55000000000000004,5.71,null,82]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured & Terraced (Good Condition)",51,67,76,80,null,145,0.55000000000000004,5.71,null,83]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Poor Condition)",68,79,86,89,null,48.8,0.22,2.2999999999999998,null,84]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Fair Condition)",49,69,79,84,null,48.8,0.22,2.2999999999999998,null,85]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Good Condition)",39,61,74,80,null,48.8,0.22,2.2999999999999998]
["Meadow-Continuous Grass, Protected from Grazing and Generally Mowed for Hay",30,58,71,78,null,48.8,0.22,2.2999999999999998]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Poor Condition)",48,67,77,83,null,39,0.15,0.19]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Fair Condition)",35,56,70,77,null,39,0.15,0.19]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Good Condition)",30,48,65,73,null,39,0.15,0.19]
["Woods-Grass Combination (Orchard or Tree Farm) (Poor Condition)",57,73,82,86,null,45,0.13,1.05]
["Woods-Grass Combination (Orchard or Tree Farm) (Fair Condition)",43,65,76,82,null,45,0.13,1.05]
["Woods-Grass Combination (Orchard or Tree Farm) (Good Condition)",32,58,72,79,null,45,0.13,1.05]
["Woods (Poor Condition)",45,66,77,83,null,45,0.13,1.05]
["Woods (Fair Condition)",36,60,73,79,null,45,0.13,1.05]
["Woods (Good Condition)",30,55,70,77,null,45,0.13,1.05]
["Farmstead-Buildings, Lanes, Driveways and Surrounding Lots",59,74,82,86,null,65,0.28999999999999998,2.0499999999999998]
["Roads (Including ROW) - Dirt",72,82,87,89,null,141,0.43,2.65]
["Roads (Including ROW) - Gravel",76,85,89,91,null,141,0.43,2.65]

{"sheet":"Versions","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Version","Date","Change(s)"]
[1.3,"2026-04-02","Increased the number of rows for the pre- and post-construction drainage area tables from 8 to 20.  Changed the location for selecting Maximum Storm Event Routed to MRC SCM from the Design Standards section to the Background section.  Added column for \"Off-Site\" to pre- and post-construction drainage area tables to allow users to identify when land cover and soil type combinations are outside of the project site.  Added a checkbox for \"Receives direct precipitation only\" above post-construction drainage area table (e.g., MRC Storage Systems below turf fields) which eliminates deductions for drainage area exceedances.  Modified crediting equation when flow routed to an MRC SCM is the 1.2-inch/2-hour storm by providing full credit up to the 2-year/24-hour storm when the post-construction 2-year/24-hour peak rate is less than or equal to the pre-construction 1-year/24-hour peak rate (i.e., management done within the SCM rather than an Objective D SCM in series)."]
[1.2,"2025-10-21","Corrected error relating to the calculation of equivalent impervious area when post-construction volumes for land covers are entered manually rather than auto-calculated."]
[1.2,"2025-09-10","1) Corrected error in calculating deductions for MRC Storage Systems. 2) Clarified that the post-construction 2-year peak rate standard is 0.15 cfs (rather than 0.15 cfs/equivalent impervious area) when the pre-construction 1-year peak rate is less than 0.15 cfs."]
[1.2,"2025-08-15","1) Revised Drainage Area Characterization section to request the total volume of stormwater routed to the SCM from off-site sources.  Design standards must include this volume but off-site volume is deducted from Volume Management Credit. 2) Eliminated maximum freeboard standard for MRC Bioretention and replaced it with a hydraulic allowance standard which would generally apply when diversions of larger storms is proposed. 3) Modified pretreatment standards for both types of SCMs per the MRC Concept Paper and MRC Spreadsheet Instructions. 4) Modified Volume Management Credit logic to provide credit up to the 2-year/24-hour storm when a volume less than the 2-year/24-hour storm is routed to an MRC SCM and the MRC SCM is either upstream or downstream of an Objective D rate control SCM (previously full credit provided only when upstream). 5) Removed IWS Void Space % parameter and IWS Void Space Volume standard for MRC Storage Systems."]
["1.1","2025-03-11","Fixed calculation error relating to equivalent impervious.  2/24/25: 1) For MRC Storage Systems, changed IWS Void Space Volume design value formula to use one-half the user-entered Void Space in IWS % (rather than the full Void Space in IWS %) as explained in the MRC Spreadsheet Instructions.  2) When an MRC Storage System is to be lined, the Void Space in IWS % should be entered as zero (0), resulting in a value of 0 for IWS Void Space Volume.  Changed logic to eliminate the deduction for lined MRC Storage Systems without IWS Void Space as long as the product of IWS depth and IWS Area is greater than or equal to the standard for IWS Void Space Volume."]
["1.0","2024-11-18","Original"]