{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MRC Spreadsheet","Reference"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":48,"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":170,"n_cols":48,"rows_kept":170,"cut":false,"hidden":false,"merged":[[126,16,126,20],[126,21,126,25],[128,2,128,15],[128,16,128,20],[128,21,128,25],[150,21,150,25],[151,2,151,15],[151,16,151,20],[151,21,151,25],[145,2,145,25],[146,2,146,25],[148,2,148,25],[149,2,149,25],[133,16,133,20],[133,21,133,25],[139,2,139,15],[139,16,139,20],[139,21,139,25],[140,2,140,15],[140,16,140,20],[136,16,136,20],[136,21,136,25],[138,2,138,15],[138,16,138,20],[138,21,138,25],[134,2,134,15],[134,16,134,20],[134,21,134,25],[137,2,137,15],[137,16,137,20],[137,21,137,25],[154,2,154,3],[154,4,154,25],[147,16,147,20],[147,21,147,25],[150,2,150,15],[150,16,150,20],[79,2,79,15],[111,18,111,25],[111,15,111,17],[127,2,127,15],[127,16,127,20],[127,21,127,25],[135,2,135,15],[135,16,135,20],[135,21,135,25],[129,2,129,25],[130,2,130,25],[131,2,131,15],[131,16,131,20],[131,21,131,25],[132,2,132,15],[132,16,132,20],[132,21,132,25],[133,2,133,15],[124,2,124,15],[124,16,124,20],[124,21,124,25],[153,2,153,3],[153,4,153,25],[140,21,140,25],[141,2,141,15],[141,16,141,20],[141,21,141,25],[142,2,142,15],[142,16,142,20],[142,21,142,25],[143,2,143,15],[143,16,143,20],[143,21,143,25],[144,2,144,15],[144,16,144,20],[144,21,144,25],[147,2,147,15],[125,2,125,15],[125,16,125,20],[125,21,125,25],[126,2,126,15],[136,2,136,15],[121,2,121,15],[121,16,121,20],[121,21,121,25],[122,2,122,15],[122,16,122,20],[122,21,122,25],[123,2,123,15],[123,16,123,20],[123,21,123,25],[116,21,116,25],[117,2,117,15],[117,16,117,20],[117,21,117,25],[119,2,119,15],[119,16,119,20],[119,21,119,25],[120,2,120,15],[120,16,120,20],[120,21,120,25],[74,2,74,19],[74,20,74,22],[23,2,23,25],[29,2,29,15],[158,2,158,21],[158,22,158,25],[159,2,159,21],[159,22,159,25],[156,2,156,25],[100,2,100,15],[81,2,81,15],[81,16,81,20],[81,21,81,25],[82,2,82,15],[82,16,82,20],[82,21,82,25],[88,2,88,15],[88,16,88,20],[88,21,88,25],[83,2,83,15],[83,16,83,20],[83,21,83,25],[118,21,118,25],[114,16,114,20],[102,2,102,15],[102,16,102,20],[102,21,102,25],[103,2,103,15],[103,16,103,20],[103,21,103,25],[101,2,101,15],[162,2,162,21],[162,22,162,25],[106,2,106,15],[106,16,106,20],[106,21,106,25],[113,2,113,15],[113,16,113,20],[113,21,113,25],[114,2,114,15],[118,2,118,15],[118,16,118,20],[114,21,114,25],[115,2,115,15],[115,16,115,20],[115,21,115,25],[116,2,116,15],[116,16,116,20],[169,2,169,9],[169,22,169,25],[169,19,169,21],[169,10,169,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],[160,22,160,25],[160,2,160,21],[97,2,97,15],[19,2,19,25],[109,2,109,3],[109,4,109,25],[167,2,167,15],[167,16,167,25],[108,2,108,3],[108,4,108,25],[101,16,101,20],[101,21,101,25],[100,16,100,20],[100,21,100,25],[85,2,85,15],[85,16,85,20],[85,21,85,25],[98,2,98,25],[99,2,99,25],[91,16,91,20],[91,21,91,25],[86,16,86,20],[92,21,92,25],[86,21,86,25],[89,2,89,15],[89,16,89,20],[89,21,89,25],[90,2,90,15],[90,16,90,20],[90,21,90,25],[92,16,92,20],[92,2,92,15],[87,21,87,25],[87,2,87,15],[87,16,87,20],[35,16,35,17],[35,18,35,19],[35,20,35,22],[35,23,35,25],[97,16,97,20],[97,21,97,25],[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],[30,2,30,15],[31,2,31,15],[32,2,32,15],[33,2,33,15],[25,2,25,10],[25,11,25,12],[25,13,25,14],[11,24,11,25],[11,21,11,23],[50,13,50,14],[36,16,36,17],[36,18,36,19],[36,20,36,22],[36,23,36,25],[39,2,39,15],[39,16,39,17],[39,18,39,19],[39,20,39,22],[39,23,39,25],[40,2,40,15],[40,16,40,17],[40,18,40,19],[40,20,40,22],[40,23,40,25],[41,2,41,15],[41,16,41,17],[41,18,41,19],[41,20,41,22],[41,23,41,25],[42,2,42,15],[44,2,44,15],[54,2,54,15],[55,2,55,15],[52,2,53,15],[52,16,53,17],[52,18,53,19],[54,16,54,17],[54,18,54,19],[54,20,54,22],[54,23,54,25],[64,20,64,22],[64,23,64,25],[65,2,65,15],[65,16,65,17],[65,18,65,19],[56,2,56,15],[57,2,57,15],[58,2,58,15],[56,16,56,17],[56,18,56,19],[56,20,56,22],[56,23,56,25],[57,16,57,17],[57,18,57,19],[57,20,57,22],[57,23,57,25],[58,16,58,17],[58,18,58,19],[58,20,58,22],[58,23,58,25],[59,2,59,15],[60,2,60,15],[61,2,61,15],[59,16,59,17],[59,18,59,19],[59,20,59,22],[59,23,59,25],[60,16,60,17],[60,18,60,19],[60,20,60,22],[60,23,60,25],[61,16,61,17],[61,18,61,19],[61,20,61,22],[61,23,61,25],[0,0,0,25],[164,1,164,25],[165,1,165,25],[17,2,17,7],[17,8,17,18],[17,21,17,23],[17,24,17,25],[104,2,104,25],[105,2,105,25],[94,2,94,15],[94,16,94,20],[94,21,94,25],[95,2,95,15],[95,16,95,20],[95,21,95,25],[96,2,96,15],[96,16,96,20],[96,21,96,25],[93,2,93,15],[93,16,93,20],[93,21,93,25],[79,21,79,25],[79,16,79,20],[91,2,91,15],[25,17,25,25],[30,16,30,17],[30,18,30,19],[30,20,30,22],[30,23,30,25],[31,16,31,17],[31,18,31,19],[31,20,31,22],[31,23,31,25],[27,16,28,17],[27,18,28,19],[27,20,28,22],[27,23,28,25],[29,16,29,17],[29,18,29,19],[29,20,29,22],[29,23,29,25],[27,32,28,32],[27,31,28,31],[27,33,28,33],[27,29,28,29],[32,16,32,17],[32,18,32,19],[32,20,32,22],[32,23,32,25],[33,16,33,17],[33,18,33,19],[33,20,33,22],[33,23,33,25],[34,20,34,22],[34,23,34,25],[27,2,28,15],[36,2,36,15],[34,2,34,15],[35,2,35,15],[52,29,53,29],[48,23,48,25],[48,20,48,22],[48,2,48,19],[43,2,43,15],[43,16,43,17],[43,18,43,19],[43,20,43,22],[37,2,38,15],[37,16,38,17],[37,18,38,19],[37,20,38,22],[37,23,38,25],[46,2,46,15],[46,16,46,17],[46,18,46,19],[50,2,50,10],[50,11,50,12],[52,30,53,30],[52,31,53,31],[52,32,53,32],[52,33,53,33],[52,20,53,22],[52,23,53,25],[55,16,55,17],[55,18,55,19],[55,20,55,22],[55,23,55,25],[9,2,9,20],[7,2,7,9],[27,27,28,28],[52,27,53,28],[47,16,47,17],[73,23,73,25],[73,20,73,22],[73,2,73,19],[75,20,75,22],[75,2,75,19],[7,23,7,24],[7,15,7,22],[7,13,7,14],[11,2,11,12],[70,2,70,15],[70,16,70,17],[70,18,70,19],[74,23,74,25],[70,20,70,22],[70,23,70,25],[71,2,71,15],[71,16,71,17],[71,18,71,19],[71,20,71,22],[68,2,68,15],[68,16,68,17],[68,18,68,19],[68,20,68,22],[68,23,68,25],[69,2,69,15],[69,16,69,17],[69,18,69,19],[69,20,69,22],[69,23,69,25],[156,27,157,27],[156,28,157,28],[62,2,63,15],[62,16,63,17],[62,18,63,19],[62,20,63,22],[62,23,63,25],[65,20,65,22],[65,23,65,25],[66,2,66,15],[66,16,66,17],[66,18,66,19],[66,20,66,22],[66,23,66,25],[67,2,67,15],[67,16,67,17],[67,18,67,19],[77,2,77,25],[86,2,86,15],[72,16,72,17],[84,2,84,15],[84,16,84,20],[84,21,84,25],[71,23,71,25],[67,20,67,22],[67,23,67,25],[64,2,64,15],[64,16,64,17],[64,18,64,19],[24,17,24,25],[45,2,45,15],[45,16,45,17],[45,18,45,19],[45,20,45,22],[45,23,45,25],[43,23,43,25],[46,20,46,22],[46,23,46,25],[44,16,44,17],[44,18,44,19],[44,20,44,22],[44,23,44,25],[42,16,42,17],[42,18,42,19],[42,20,42,22],[42,23,42,25],[34,16,34,17],[34,18,34,19]]}
["Version 1.0, November 2024",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"]
[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,"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,"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"]
[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,"< 1.2-Inch/2-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(AI1=TRUE,O12<>\"\"),X8/O12,X8),\"\")","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<>\"\",V84<>\"\"),IF(AND(V84<>\"> 2-Year/24-Hour Storm\",AB8>6),\"Y\",IF(AND(V84=\"> 2-Year/24-Hour Storm\",AB8>3),\"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",null,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",null,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",null,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",null,null,null,null,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",null,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",null,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(AB90<>\"\",AB120<>\"\"),G16<>\"\",N16<>\"\"),IF(AND(OR(AND(R6=\"MRC Bioretention\",AB90=0),AND(R6=\"MRC Storage Systems\",AB120=0)),G16=\"Upstream\",N16=\"PCSM Objective D\"),\"Y\",\"\"),\"\")","v":""},null,null,"> 2-Year/24-Hour Storm",null,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",null,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",null,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",null,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",null,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",null,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,"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,"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,"Exempt from §§ 102.8(g)(2)(ii) & (iii)",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,"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,"> 24"]
[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,null,"Area (ac)",null,"HSG",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,null,null,{"$f":"IF(AC30<>\"\",AC30,\"\")","v":""},null,null,{"$f":"IF(AG30<>\"\",AG30,\"\")","v":""},null,null,null,{"$f":"IF(AE30<>\"\",IF(1.2-AE30>0,((1.2-AE30)^2)/(1.2+0.8*((1000/AD30)-10)),0),\"\")","v":""},{"$f":"IF(AB30<>\"\",Q30*43560*(AB30/12),\"\")","v":""},{"$f":"IF(AND(C30<>\"\",Q30<>\"\",S30<>\"\"),IF(ISNA(VLOOKUP(C30,Reference!$M$1:$Q$12,AH30,FALSE))=TRUE,\"\",VLOOKUP(C30,Reference!$M$1:$Q$12,AH30,FALSE)),\"\")","v":""},{"$f":"IF(AD30<>\"\",0.2*((1000/AD30)-10),\"\")","v":""},{"$f":"IF(AND(AE30<>\"\",$K$8<>\"\"),IF($K$8-AE30>0,(($K$8-AE30)^2)/($K$8+0.8*((1000/AD30)-10)),0),\"\")","v":""},{"$f":"IF(AF30<>\"\",Q30*43560*(AF30/12),\"\")","v":""},{"$f":"IF(S30<>\"\",IF(S30=\"A\",2,IF(S30=\"B\",3,IF(S30=\"C\",4,IF(OR(S30=\"D\",S30=\"N/A\"),5,)))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(AG31<>\"\",AG31,\"\")","v":""},null,null,null,"","",{"$f":"IF(AND(C31<>\"\",Q31<>\"\",S31<>\"\"),IF(ISNA(VLOOKUP(C31,Reference!$M$1:$Q$12,AH31,FALSE))=TRUE,\"\",VLOOKUP(C31,Reference!$M$1:$Q$12,AH31,FALSE)),\"\")","v":""},"","","",{"$f":"IF(S31<>\"\",IF(S31=\"A\",2,IF(S31=\"B\",3,IF(S31=\"C\",4,IF(OR(S31=\"D\",S31=\"N/A\"),5,)))),\"\")","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,"","",{"$f":"IF(AND(C32<>\"\",Q32<>\"\",S32<>\"\"),IF(ISNA(VLOOKUP(C32,Reference!$M$1:$Q$12,AH32,FALSE))=TRUE,\"\",VLOOKUP(C32,Reference!$M$1:$Q$12,AH32,FALSE)),\"\")","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,"","",{"$f":"IF(AND(C33<>\"\",Q33<>\"\",S33<>\"\"),IF(ISNA(VLOOKUP(C33,Reference!$M$1:$Q$12,AH33,FALSE))=TRUE,\"\",VLOOKUP(C33,Reference!$M$1:$Q$12,AH33,FALSE)),\"\")","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,"","",{"$f":"IF(AND(C34<>\"\",Q34<>\"\",S34<>\"\"),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,null,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C35<>\"\",Q35<>\"\",S35<>\"\"),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,null,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C36<>\"\",Q36<>\"\",S36<>\"\"),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,null,null,"",null,null,"",null,null,null,"","",{"$f":"IF(AND(C37<>\"\",Q37<>\"\",S37<>\"\"),IF(ISNA(VLOOKUP(C37,Reference!$M$1:$Q$12,AH37,FALSE))=TRUE,\"\",VLOOKUP(C37,Reference!$M$1:$Q$12,AH37,FALSE)),\"\")","v":""},"","","",""]
[null,null,"Pre-Construction Drainage Area Cover Type",null,null,null,null,null,null,null,null,null,null,null,null,null,"Area (ac)",null,"HSG",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(S38<>\"\",IF(S38=\"HSG\",\"Soil_Type\",\"USDA\"),\"\")","v":"Soil_Type"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI9=TRUE,SUM(Q30:Q37),SUM(Q39:Q46))","v":0}]
[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(U30:U37)>=0,AI9=TRUE),SUM(U30:U37),IF(AND(SUM(U39:U46)>=0,AI9<>TRUE),SUM(U39:U46),\"\"))","v":0},null,null,{"$f":"IF(AND(SUM(X30:X37)>0,AI9=TRUE),SUM(X30:X37),IF(AND(SUM(X39:X46)>0,AI9<>TRUE),SUM(X39:X46),\"\"))","v":""}]
[]
[null,null,"Post-Construction Drainage Area",null,null,null,null,null,null,null,null,"Rows:"]
[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,null,"Area (ac)",null,"HSG",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,{"$f":"IF(AC55<>\"\",AC55,\"\")","v":""},null,null,{"$f":"IF(AG55<>\"\",AG55,\"\")","v":""},null,null,null,{"$f":"IF(AE55<>\"\",IF(1.2-AE55>0,((1.2-AE55)^2)/(1.2+0.8*((1000/AD55)-10)),0),\"\")","v":""},{"$f":"IF(AB55<>\"\",Q55*43560*(AB55/12),\"\")","v":""},{"$f":"IF(AND(C55<>\"\",Q55<>\"\",S55<>\"\"),IF(ISNA(VLOOKUP(C55,Reference!$A$1:$E$61,AH55,FALSE))=TRUE,\"\",VLOOKUP(C55,Reference!$A$1:$E$61,AH55,FALSE)),\"\")","v":""},{"$f":"IF(AD55<>\"\",0.2*((1000/AD55)-10),\"\")","v":""},{"$f":"IF(AND(AE55<>\"\",$K$8<>\"\"),IF($K$8-AE55>0,(($K$8-AE55)^2)/($K$8+0.8*((1000/AD55)-10)),0),\"\")","v":""},{"$f":"IF(AF55<>\"\",Q55*43560*(AF55/12),\"\")","v":""},{"$f":"IF(S55<>\"\",IF(S55=\"A\",2,IF(S55=\"B\",3,IF(S55=\"C\",4,IF(OR(S55=\"D\",S55=\"N/A\"),5,)))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(AG56<>\"\",AG56,\"\")","v":""},null,null,null,"","",{"$f":"IF(AND(C56<>\"\",Q56<>\"\",S56<>\"\"),IF(ISNA(VLOOKUP(C56,Reference!$A$1:$E$61,AH56,FALSE))=TRUE,\"\",VLOOKUP(C56,Reference!$A$1:$E$61,AH56,FALSE)),\"\")","v":""},"","","",{"$f":"IF(S56<>\"\",IF(S56=\"A\",2,IF(S56=\"B\",3,IF(S56=\"C\",4,IF(OR(S56=\"D\",S56=\"N/A\"),5,)))),\"\")","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,"","",{"$f":"IF(AND(C57<>\"\",Q57<>\"\",S57<>\"\"),IF(ISNA(VLOOKUP(C57,Reference!$A$1:$E$61,AH57,FALSE))=TRUE,\"\",VLOOKUP(C57,Reference!$A$1:$E$61,AH57,FALSE)),\"\")","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,"","",{"$f":"IF(AND(C58<>\"\",Q58<>\"\",S58<>\"\"),IF(ISNA(VLOOKUP(C58,Reference!$A$1:$E$61,AH58,FALSE))=TRUE,\"\",VLOOKUP(C58,Reference!$A$1:$E$61,AH58,FALSE)),\"\")","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,"","",{"$f":"IF(AND(C59<>\"\",Q59<>\"\",S59<>\"\"),IF(ISNA(VLOOKUP(C59,Reference!$A$1:$E$61,AH59,FALSE))=TRUE,\"\",VLOOKUP(C59,Reference!$A$1:$E$61,AH59,FALSE)),\"\")","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,"","",{"$f":"IF(AND(C60<>\"\",Q60<>\"\",S60<>\"\"),IF(ISNA(VLOOKUP(C60,Reference!$A$1:$E$61,AH60,FALSE))=TRUE,\"\",VLOOKUP(C60,Reference!$A$1:$E$61,AH60,FALSE)),\"\")","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,"","",{"$f":"IF(AND(C61<>\"\",Q61<>\"\",S61<>\"\"),IF(ISNA(VLOOKUP(C61,Reference!$A$1:$E$61,AH61,FALSE))=TRUE,\"\",VLOOKUP(C61,Reference!$A$1:$E$61,AH61,FALSE)),\"\")","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,"","",{"$f":"IF(AND(C62<>\"\",Q62<>\"\",S62<>\"\"),IF(ISNA(VLOOKUP(C62,Reference!$A$1:$E$61,AH62,FALSE))=TRUE,\"\",VLOOKUP(C62,Reference!$A$1:$E$61,AH62,FALSE)),\"\")","v":""},"","","",""]
[null,null,"Post-Construction Drainage Area Cover Type",null,null,null,null,null,null,null,null,null,null,null,null,null,"Area (ac)",null,"HSG",null,"Runoff, 1.2-Inch (CF)",null,null,"Runoff, 2-Year (CF)",null,null,null,{"$f":"IF(S63<>\"\",IF(S63=\"HSG\",\"Soil_Type\",\"USDA\"),\"\")","v":"Soil_Type"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI9=TRUE,SUM(Q55:Q62),SUM(Q65:Q72))","v":0}]
[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(U55:U62)>=0,AI9=TRUE),SUM(U55:U62),IF(AND(SUM(U65:U72)>=0,AI9<>TRUE),SUM(U65:U72),\"\"))","v":0},null,null,{"$f":"IF(AND(SUM(X55:X62)>=0,AI9=TRUE),SUM(X55:X62),IF(AND(SUM(X65:X72)>=0,AI9<>TRUE),SUM(X65:X72),\"\"))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(V84<>\"\",V116<>\"\"),R6<>\"\"),IF(OR(AB16=\"Y\",AND(R6=\"MRC Bioretention\",OR(V84=\"2-Year/24-Hour Storm\",V84=\"> 2-Year/24-Hour Storm\")),AND(R6=\"MRC Storage Systems\",OR(V116=\"2-Year/24-Hour Storm\",V116=\"> 2-Year/24-Hour Storm\"))),AN73,IF(U75<>\"\",(U75/U74)*AK73,AK73)),\"\")","v":""},{"$f":"IF(AND(OR(V84<>\"\",V116<>\"\"),R6<>\"\"),IF(OR(AB16=\"Y\",AND(R6=\"MRC Bioretention\",OR(V84=\"2-Year/24-Hour Storm\",V84=\"> 2-Year/24-Hour Storm\")),AND(R6=\"MRC Storage Systems\",OR(V116=\"2-Year/24-Hour Storm\",V116=\"> 2-Year/24-Hour Storm\"))),AO73,IF(U75<>\"\",(U75/U74)*AL73,AL73)),\"\")","v":""},{"$f":"IF(AND(OR(V84<>\"\",V116<>\"\"),R6<>\"\"),IF(OR(AB16=\"Y\",AND(R6=\"MRC Bioretention\",OR(V84=\"2-Year/24-Hour Storm\",V84=\"> 2-Year/24-Hour Storm\")),AND(R6=\"MRC Storage Systems\",OR(V116=\"2-Year/24-Hour Storm\",V116=\"> 2-Year/24-Hour Storm\"))),AP73,IF(U75<>\"\",(U75/U74)*AM73,AM73)),\"\")","v":""}]
[null,null,"Total Volume 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,null,{"$f":"IF(U75=\"\",U74,IF(U75<X74,U75,X74))","v":0},{"$f":"IF(U75=\"\",\"AllStorms\",IF(U75<U74,\"LESS12\",IF(U75=U74,\"EQUAL12\",IF(AND(U75>U74,U75<X74),\"LT2Y\",IF(U75=X74,\"E2Y\",IF(U75>X74,\"GT2Y\"))))))","v":"AllStorms"}]
[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(U74<>\"\",IF(OR(U75=\"\",U75>U74),U74/(0.083333*43560),U75/(0.083333*43560)),\"\")","v":0},null,null,null,null,null,null,{"$f":"IF(AND(OR(AND(R6=\"MRC Bioretention\",OR(V84=\"< 2-Year/24-Hour Storm\",V84=\"1.2-Inch/2-Hour Storm\",V84=\"< 1.2-Inch/2-Hour Storm\")),AND(R6=\"MRC Storage Systems\",OR(V116=\"< 2-Year/24-Hour Storm\",V116=\"1.2-Inch/2-Hour Storm\",V116=\"< 1.2-Inch/2-Hour Storm\"))),AB16=\"Y\"),MAX(AB75,X74),AB75)","v":0}]
[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,"Volume Credit:",{"$f":"IF(OR(AND(R6=\"MRC Bioretention\",OR(V84=\"2-Year/24-Hour Storm\",V84=\"> 2-Year/24-Hour Storm\")),AND(R6=\"MRC Storage Systems\",OR(V116=\"2-Year/24-Hour Storm\",V116=\"> 2-Year/24-Hour Storm\"))),X74,AB76)","v":0}]
[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(V83<>\"\",IF(V83>0,0.5,0),\"\")","v":""},"Y",{"$f":"IF(OR(AC83=\"\",AND(AC83=\"Y\",V83<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"Maximum Storm Event Routed to 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(V84<>\"\",IF(V84=\"> 2-Year/24-Hour Storm\",0.5,0),\"\")","v":""},"Y",{"$f":"IF(OR(AC84=\"\",AND(AC84=\"Y\",V84<>\"\")),\"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(V84<>\"\",IF(AND(OR(V84=\"1.2-Inch/2-Hour Storm\",V84=\"< 1.2-Inch/2-Hour Storm\"),AI5=TRUE),6,IF(AND(OR(V84=\"1.2-Inch/2-Hour Storm\",V84=\"< 1.2-Inch/2-Hour Storm\"),AI5=FALSE),5,IF(AND(OR(V84=\"< 2-Year/24-Hour Storm\",V84=\"2-Year/24-Hour Storm\"),AI5=TRUE),2.5,IF(AND(OR(V84=\"< 2-Year/24-Hour Storm\",V84=\"2-Year/24-Hour Storm\"),AI5=FALSE),2,IF(AND(V84=\"> 2-Year/24-Hour Storm\",AI5=TRUE),1.5,IF(AND(V84=\"> 2-Year/24-Hour Storm\",AI5=FALSE),1)))))),\"\")","v":""},null,null,null,null,{"$f":"IF(AND($AI$1=TRUE,$O$12<>\"\",$U$76<>\"\"),$U$76/$O$12,IF(AND(OR($AI$1<>TRUE,$O$12=\"\"),$U$76<>\"\"),$U$76,\"\"))","v":0},null,null,null,null,null,{"$f":"IF(AND(X8<>\"\",Q85<>\"\",V85<>\"\"),IF(OR(V85>Q85,AB9=\"Y\"),0.5,0),\"\")","v":""},"Y","Y"]
[null,null,"Freeboard (inches) (maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V84<>\"\",IF(OR(V84=\"< 1.2-Inch/2-Hour Storm\",V84=\"1.2-Inch/2-Hour Storm\",V84=\"< 2-Year/24-Hour Storm\",V84=\"2-Year/24-Hour Storm\"),\"6\",\"12\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(V86<>\"\",IF(V86=\"> 24\",24,V86),\"\")","v":""},{"$f":"IF(AND(Q86<>\"\",AA86<>\"\"),IF(AA86>(Q86*1.1),(AA86-(Q86*1.1))/(Q86*1.1),0),\"\")","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(V87=TRUE,1,IF(V87=FALSE,2,IF(V87=\"\",0)))","v":2},{"$f":"IF(AND(Q87<>\"\",V87<>\"\"),IF(V87>(Q87*1.1),(V87-(Q87*1.1))/(Q87*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(Q88<>\"\",V88<>\"\"),IF(V88>(Q88*1.1),(V88-(Q88*1.1))/(Q88*1.1),0),\"\")","v":""},"Y",{"$f":"IF(OR(V84=\"1.2-Inch/2-Hour Storm\",AND(V84<>\"1.2-Inch/2-Hour Storm\",V88<>\"\")),\"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(V89<>\"\",IF(V89<(0.15/IF(U76<>\"\",U76,1)),0.15/IF(U76<>\"\",U76,1),V89),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q90<>\"\",V90<>\"\"),IF(V90>Q90,0.5,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(U76<>\"\",ROUNDUP(((U76/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(Q91<>\"\",\"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(Q91<>\"\",V92<>\"\"),IF(Q91<>0,IF(V92>(Q91*1.1),(V92-(Q91*1.1))/(Q91*1.1),0),0),\"\")","v":""},"Y",{"$f":"IF(OR(AC92=\"\",AND(AC92=\"Y\",V92<>\"\")),\"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(Q93<>\"\",V93<>\"\"),IF(V93>(Q93*1.1),(V93-(Q93*1.1))/(Q93*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(V94<>\"\",IF(V94<Q94,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(V95<>\"\",IF(V95<Q95,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(V84<>\"\",IF(OR(V84=\"< 1.2-Inch/2-Hour Storm\",V84=\"1.2-Inch/2-Hour Storm\",V84=\"< 2-Year/24-Hour Storm\",V84=\"2-Year/24-Hour Storm\"),2,3),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q96<>\"\",V96<>\"\"),IF(V96>(Q96*1.1),(V96-(Q96*1.1))/(Q96*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(V98<>TRUE,IF(AND(Q97<>\"\",V97<>\"\"),IF(V97<(Q97-(Q97*0.1)),((Q97-(Q97*0.1))-V97)/(Q97-(Q97*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,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(V98=TRUE,\"Y\",\"\")","v":""},{"$f":"IF(OR(AC100=\"\",AND(AC100=\"Y\",C100<>\"\")),\"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(AC101=\"\",AND(AC101=\"Y\",V101<>\"\")),\"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(AC102=\"\",AND(AC102=\"Y\",V102<>\"\")),\"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(V103<>\"\",V80=\"MRC Bioswale\"),IF(V103=TRUE,0,0.25),\"\")","v":""},{"$f":"IF(V80=\"MRC Bioswale\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC103=\"\",AND(AC103=\"Y\",V103<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Pretreatment 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,{"$f":"IF(V104=TRUE,1,IF(V104=FALSE,2,IF(V104=\"\",0)))","v":2},{"$f":"IF(AND(V84=\"> 2-Year/24-Hour Storm\",V104=FALSE),0.5,0)","v":0},"Y",{"$f":"IF(OR(AC104=\"\",AND(AC104=\"Y\",V104<>\"\")),\"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(V104=TRUE,\"Y\",\"\")","v":""},{"$f":"IF(OR(AC106=\"\",AND(AC106=\"Y\",C106<>\"\")),\"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(AC107=\"\",AND(AC107=\"Y\",C107<>\"\")),\"Y\",\"\")","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(AD83:AD106)=0,IF(SUM(AB83:AB106)>1,1,SUM(AB83:AB106)),\"\")","v":""},null,{"$f":"IF(COUNTBLANK(AD83:AD107)=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/acre, if the 1-Year/24-Hour Peak Rate is < 0.15 cfs/acre."]
[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(V115<>\"\",IF(V115>0,0.5,0),\"\")","v":""},"Y",{"$f":"IF(OR(AC115=\"\",AND(AC115=\"Y\",V115<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"Maximum Storm Event Routed to 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,null,"Y",{"$f":"IF(OR(AC116=\"\",AND(AC116=\"Y\",V116<>\"\")),\"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(V116<>\"\",IF(AND(OR(V116=\"< 1.2-Inch/2-Hour Storm\",V116=\"1.2-Inch/2-Hour Storm\"),AI37=TRUE),6,IF(AND(OR(V116=\"< 1.2-Inch/24-Hour Storm\",V116=\"1.2-Inch/2-Hour Storm\"),AI37=FALSE),5,IF(AND(OR(V116=\"< 2-Year/24-Hour Storm\",V116=\"2-Year/24-Hour Storm\"),AI37=TRUE),2.5,IF(AND(OR(V116=\"< 2-Year/24-Hour Storm\",V116=\"2-Year/24-Hour Storm\"),AI37=FALSE),2,IF(AND(V116=\"> 2-Year/24-Hour Storm (All Flows)\",AI37=TRUE),1.5,IF(AND(V116=\"> 2-Year/24-Hour Storm (All Flows)\",AI37=FALSE),1)))))),\"\")","v":""},null,null,null,null,{"$f":"IF(AND($AI$1=TRUE,$O$12<>\"\",$U$76<>\"\"),$U$76/$O$12,IF(AND(OR($AI$1<>TRUE,$O$12=\"\"),$U$76<>\"\"),$U$76,\"\"))","v":0},null,null,null,null,null,{"$f":"IF(AND(Q117<>\"\",V117<>\"\"),IF(V117>Q117,0.5,0),\"\")","v":""},"Y","Y"]
[null,null,"Storage Unit - Freeboard (inches) (maximum)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V116<>\"\",IF(OR(V116=\"< 1.2-Inch/2-Hour Storm\",V116=\"1.2-Inch/2-Hour Storm\",V116=\"< 2 -Year/24-Hour Storm\",V116=\"2-Year/24-Hour Storm\"),\"6\",\"12\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(V118<>\"\",IF(V118=\"> 24\",24,V118),\"\")","v":""},{"$f":"IF(AND(Q118<>\"\",AA118<>\"\"),IF(AA118>(Q118*1.1),(AA118-(Q118*1.1))/(Q118*1.1),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",{"$f":"IF(OR(AC119=\"\",AND(AC119=\"Y\",V119<>\"\")),\"Y\",\"\")","v":""}]
[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(V119<>\"\",IF(V119<(0.15/IF(U76<>\"\",U76,1)),0.15/IF(U76<>\"\",U76,1),V119),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q120<>\"\",V120<>\"\"),IF(V120>Q120,0.5,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(U76<>\"\",ROUNDUP(((U76/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(Q121<>\"\",\"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(Q121<>\"\",V122<>\"\"),IF(Q121<>0,IF(V122>(Q121*1.1),(V122-(Q121*1.1))/(Q121*1.1),0),0),\"\")","v":""},"Y",{"$f":"IF(OR(AC122=\"\",AND(AC122=\"Y\",V122<>\"\")),\"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(Q123<>\"\",V123<>\"\"),IF(V123>(Q123*1.1),(V123-(Q123*1.1))/(Q123*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(V129<>TRUE,IF(AND(Q124<>\"\",V124<>\"\"),IF(V124<(Q124-(Q124*0.1)),((Q124-(Q124*0.1))-V124)/(Q124-(Q124*0.1)),0),\"\"),0)","v":""},"Y",{"$f":"IF(OR(AC124=\"\",AND(AC124=\"Y\",V124<>\"\")),\"Y\",\"\")","v":""}]
[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(V125<>\"\",IF(V125<Q125,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 - Void Space in IWS (%)",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 - IWS Void Space Volume (CF) (minimum)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA128<>\"\",IF(AND($AI$1=TRUE,$O$12<>\"\"),IF(AA128>0,AA128/$O$12,0),IF(AA128<0,0,AA128)),\"\")","v":0},null,null,null,null,{"$f":"IF(AND(V125<>\"\",V126<>\"\",V127<>\"\"),V125*V126*V127,\"\")","v":""},null,null,null,null,{"$f":"IF($U$76<>\"\",($U$76*43560*0.020833)-IF(V139<>\"\",V139,0),\"\")","v":0},{"$f":"IF(AND(Q128<>\"\",V128<>\"\"),IF(V128<(Q128*0.9),((Q128*0.9)-V128)/(Q128*0.9),0),\"\")","v":""},"Y",{"$f":"IF(OR(AC128=\"\",AND(AC128=\"Y\",V128<>\"\")),\"Y\",\"\")","v":""}]
[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(V129=TRUE,\"Y\",\"\")","v":""},{"$f":"IF(OR(AC131=\"\",AND(AC131=\"Y\",C131<>\"\")),\"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(AC132=\"\",AND(AC132=\"Y\",V132<>\"\")),\"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(V133=\"\",0,IF(V133=TRUE,1,IF(V133=FALSE,2)))","v":0},{"$f":"IF(AA133=2,0.25,0)","v":0},{"$f":"IF(AND(U75<>\"\",U75<>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(Q134<>\"\",V134<>\"\"),IF(V134>(Q134*1.1),(V134-(Q134*1.1))/(Q134*1.1),0),\"\")","v":""},{"$f":"IF($S$112=\"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(V135=TRUE,1,IF(V135=FALSE,2,IF(V135=\"\",0)))","v":2},{"$f":"IF(AND(Q135<>\"\",V135<>\"\"),IF(V135<(Q135*0.9),((Q135*0.9)-V135)/(Q135*0.9),0),\"\")","v":""},{"$f":"IF($S$112=\"Upstream Vegetated Component\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Upstream Vegetated Component - Rooting Depth ",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(V136<>\"\",IF(V136=\"Deep Plantings\",1.5,0.75),\"\")","v":""},null,"","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,{"$f":"IF(V137<>\"\",IF(V137=\"Deep Plantings\",1.5,0.75),\"\")","v":""},null,{"$f":"IF($S$112=\"Upstream Vegetated Component\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Upstream Vegetated Component - Void Space in Soil Media (%)",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,"Upstream Vegetated Component - Void Space Reduction (CF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AA136<>\"\",V137<>\"\",V138<>\"\"),AA136*V137*V138,\"\")","v":""},null,null,null,null,null,null,null,"Y"]
[null,null,"Upstream MTD - TSS MOC at Design Flow (mg/L)",null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q140<>\"\",V140<>\"\"),IF(V140>(Q140*1.1),(V140-(Q140*1.1))/(Q140*1.1),0),\"\")","v":""},{"$f":"IF($S$112=\"Upstream MTD Pretreatment\",\"Y\",\"\")","v":""},"Y"]
[null,null,"Upstream MTD - TP MOC at Design Flow (mg/L)",null,null,null,null,null,null,null,null,null,null,null,null,null,0.24,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q141<>\"\",V141<>\"\"),IF(V141>(Q141*1.1),(V141-(Q141*1.1))/(Q141*1.1),0),\"\")","v":""},{"$f":"IF($S$112=\"Upstream MTD Pretreatment\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC141=\"\",AND(AC141=\"Y\",V141<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Upstream MTD - TN MOC at Design Flow (mg/L)",null,null,null,null,null,null,null,null,null,null,null,null,null,0.96,null,null,null,null,null,null,null,null,null,null,"","","Y"]
[null,null,"Upstream MTD - Flow Used to Determine MOCs (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,"Upstream MTD - Design Flow for Project (cfs)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V143<>\"\",V143,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q144<>\"\",V144<>\"\"),IF(V144>(Q144*1.1),(V144-(Q144*1.1))/(Q144*1.1),0),\"\")","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$112=\"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(V145=TRUE,$S$112=\"Permeable Pavement\"),\"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$112=\"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(V148=TRUE,$S$112=\"Permeable Pavement\"),\"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$112=\"Permeable Pavement\",\"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,"","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(AD115:AD152)=0,IF(SUM(AB115:AB152)>1,1,SUM(AB115:AB152)),\"\")","v":""},null,{"$f":"IF(AND($S$112<>\"\",COUNTBLANK(AD115:AD152)=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/acre, if the 1-Year/24-Hour Peak Rate is < 0.15 cf/acre."]
[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 and Water Quality 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(AC77<>\"\",R6<>\"\"),IF(R6=\"MRC Storage Systems\",IF(AB163<>\"Y\",AC77*(1-IF(AB153<>\"\",AB153,0)),AC77),\"\"),\"\")","v":""},{"$f":"IF(AND(AC77<>\"\",R6<>\"\"),IF(R6=\"MRC Bioretention\",IF(AB163<>\"Y\",AC77*(1-IF(AB108<>\"\",AB108,0)),AC77),\"\"),\"\")","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(AB159<>\"\",IF(AND(AB159<>\"\",AB153>0,AB153<1,OR(AND(W163=TRUE,W160=TRUE),W159=TRUE)),AB159/(1-AB153),AB159),\"\")","v":""},{"$f":"IF(AC159<>\"\",IF(AND(AC159<>\"\",AB108>0,AB108<1,OR(AND(W163=TRUE,W160=TRUE),W159=TRUE)),AC159/(1-AB108),AC159),\"\")","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\",AD108=\"Y\",AC160<>\"\"),AC160,IF(AND(R6=\"MRC Storage Systems\",AD153=\"Y\",AB160<>\"\"),AB160,\"\"))","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\",AB108>=1),AND(R6=\"MRC Storage Systems\",AB153>=1)),W160=TRUE,W163=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":20,"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)"]
["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]
["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]
["Impervious Areas: Streets and Roads - Paved; Open Ditches (Including ROW)",83,89,92,93,"Y",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,"Y",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,"Y",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]
["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]
["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]
["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]