{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["INPUT","SUMMARY","BMP INPUT","Outlet Calculations","PRE vs POST Calculations","Restricted Outlet Calculations","BMP Volume Calculations","REF_Curve Numbers","REF_Runoff Coefficients","REF_Time of Concentration"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"INPUT","index":0,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,1,63,6],[48,1,48,6],[20,5,21,5],[20,6,21,6],[3,2,3,7],[51,3,52,3],[51,5,52,5],[24,1,25,1],[32,2,33,2],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[24,3,24,4],[11,1,11,8],[12,8,13,8],[12,6,13,6],[19,3,19,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[6,1,6,3],[12,7,13,7],[0,1,0,8],[32,3,33,4],[20,3,21,4],[20,8,21,8],[20,7,21,7],[13,3,13,4],[12,3,12,4],[7,1,7,2],[8,1,8,2],[9,1,9,2],[20,2,21,2],[2,1,2,7],[4,2,4,7],[12,1,13,1],[36,5,37,5],[36,3,37,3],[23,1,23,8],[24,6,25,6],[24,8,25,8],[32,5,33,5],[32,6,33,6],[32,7,33,7],[32,8,33,8],[25,3,25,4],[24,7,25,7]]}
[null,"Proposed Stormwater Calculation Tool - Calhoun County Stormwater Management TRM"]
[]
[null,"Stormwater Management Requirements"]
[null,"Site Name:","Example 20-acre Commercial Development"]
[null,"Outlet ID:"]
[]
[null,"If Restricted Outflow Rate is required by Reviewing Agency:"]
[null,"25-Year Allowable Peak Discharge*:",null,2,"cfs"]
[]
[]
[]
[null,"PRE-DEVELOPMENT CONDITIONS"]
[null,"Sub-Drainage District ID","Area","Description/Hydrologic Group",null,"Runoff Coefficient (C)","A*C","Curve Number (CN)","A*CN"]
[null,null,"(acres)"," (select from list)"]
[null,1,20,"Row Crops (Type B)",null,{"$f":"IFERROR(VLOOKUP(D15,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":0.2},{"$f":"IFERROR(C15*F15,0)","v":4},{"$f":"IFERROR(VLOOKUP(D15,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":75},{"$f":"IFERROR(C15*H15,0)","v":1500}]
[null,2,null,null,null,{"$f":"IFERROR(VLOOKUP(D16,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":""},0,{"$f":"IFERROR(VLOOKUP(D16,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":""},0]
[null,3,null,null,null,{"$f":"IFERROR(VLOOKUP(D17,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":""},0,{"$f":"IFERROR(VLOOKUP(D17,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":""},0]
[null,4,null,null,null,{"$f":"IFERROR(VLOOKUP(D18,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":""},0,{"$f":"IFERROR(VLOOKUP(D18,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":""},0]
[null,5,null,null,null,{"$f":"IFERROR(VLOOKUP(D19,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":""},0,{"$f":"IFERROR(VLOOKUP(D19,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":""},0]
[null,6,null,null,null,{"$f":"IFERROR(VLOOKUP(D20,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":""},0,{"$f":"IFERROR(VLOOKUP(D20,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":""},0]
[null,"TOTAL AREA (acres)",{"$f":"SUM(C15:C20)","v":20},null,null,"Weighted C",{"$f":"IFERROR(SUM(G15:G20)/$C$21,0)","v":0.2},"Weighted CN",{"$f":"IFERROR(SUM(I15:I20)/$C$21,0)","v":75}]
[null,"(total area of developed site)"]
[]
[null,"POST-DEVELOPMENT CONDITIONS"]
[null,"Sub-Drainage District ID","Area","Description/Hydrologic Group",null,"Runoff Coefficient (C)","A*C","Curve Number (CN)","A*CN"]
[null,null,"(acres)"," (select from list)"]
[null,1,15,"Impervious Cover (pavement/gravel/rooftop)",null,{"$f":"IFERROR(VLOOKUP(D27,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":0.9},{"$f":"IFERROR(C27*F27,0)","v":13.5},{"$f":"IFERROR(VLOOKUP(D27,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":98},{"$f":"IFERROR(C27*H27,0)","v":1470}]
[null,2,5,"Manicured Lawn Areas (Type B)",null,{"$f":"IFERROR(VLOOKUP(D28,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":0.2},1,{"$f":"IFERROR(VLOOKUP(D28,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":61},305]
[null,3,null,null,null,{"$f":"IFERROR(VLOOKUP(D29,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":""},0,{"$f":"IFERROR(VLOOKUP(D29,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":""},0]
[null,4,null,null,null,{"$f":"IFERROR(VLOOKUP(D30,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":""},0,{"$f":"IFERROR(VLOOKUP(D30,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":""},0]
[null,5,null,null,null,{"$f":"IFERROR(VLOOKUP(D31,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":""},0,{"$f":"IFERROR(VLOOKUP(D31,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":""},0]
[null,6,null,null,null,{"$f":"IFERROR(VLOOKUP(D32,'REF_Runoff Coefficients'!$A$2:$B$43,2,FALSE),\"\")","v":""},0,{"$f":"IFERROR(VLOOKUP(D32,'REF_Curve Numbers'!$A$2:$B$43,2,FALSE),\"\")","v":""},0]
[null,"TOTAL AREA (acres)",{"$f":"SUM(C27:C32)","v":20},null,null,"Weighted C",{"$f":"IFERROR(SUM(G27:G32)/$C$33,0)","v":0.72499999999999998},"Weighted CN",{"$f":"IFERROR(SUM(I27:I32)/$C$33,0)","v":88.75}]
[null,"(total area of developed site)"]
[]
[null,"TIME OF CONCENTRATION (PRE-DEVELOPMENT)"]
[null,"Segment Length","Segment Description","K","Slope % (S)","S0.5","V","TC"]
[null,"(L) (ft)","(choose from list)",null,"(enter slope)",null,"K*S0.5","L/(V*3600)"]
[null,100,"Sheet Flow",{"$f":"IFERROR(VLOOKUP(C39,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":0.48},0.4,{"$f":"E39^0.5","v":0.63245553203367588},{"$f":"IFERROR(D39*F39,\"\")","v":0.30357865537616441},{"$f":"IFERROR(B39/(G39*3600),0)","v":9.1501089703946173E-2}]
[null,500,"Waterway",{"$f":"IFERROR(VLOOKUP(C40,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":1.2},0.5,{"$f":"E40^0.5","v":0.70710678118654757},{"$f":"IFERROR(D40*F40,\"\")","v":0.84852813742385702},0.16368212527466378]
[null,800,"Small Tributary",{"$f":"IFERROR(VLOOKUP(C41,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":2.1},0.75,0.8660254037844386,1.818653347947321,0.12219053316182556]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C42,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C43,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C44,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C45,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C46,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C47,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C48,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,"Total TC (hrs)",null,null,null,null,null,{"$f":"SUM(H39:H48)","v":0.37737374814043551}]
[]
[null,"TIME OF CONCENTRATION (POST-DEVELOPMENT)"]
[null,"Segment Length","Segment Description","K","Slope % (S)","S0.5","V","TC"]
[null,"(L) (ft)","(choose from list)",null,"(enter slope)",null,"K*S0.5","L/(V*3600)"]
[null,30,"Sheet Flow",{"$f":"IFERROR(VLOOKUP(C54,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":0.48},1.25,{"$f":"E54^0.5","v":1.1180339887498949},{"$f":"IFERROR(D54*F54,\"\")","v":0.53665631459994956},{"$f":"IFERROR(B54/(G54*3600),0)","v":1.5528249843748537E-2}]
[null,300,"Waterway",{"$f":"IFERROR(VLOOKUP(C55,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":1.2},0.8,{"$f":"E55^0.5","v":0.89442719099991586},{"$f":"IFERROR(D55*F55,\"\")","v":1.0733126291998989},7.7641249218742714E-2]
[null,1000,"Small Tributary",{"$f":"IFERROR(VLOOKUP(C56,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":2.1},0.5,0.70710678118654757,1.48492424049175,0.18706528602818717]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C57,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C58,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C59,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C60,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C61,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C62,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C63,'REF_Time of Concentration'!$A$2:$B$5,2,FALSE),\"\")","v":""},null,0,"",0]
[null,"Total TC (hrs)",null,null,null,null,null,{"$f":"SUM(H54:H63)","v":0.28023478509067845}]

{"sheet":"SUMMARY","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[15,3,16,3]]}
[]
[null,"Summary"]
[null,"Outlet ID",{"$f":"INPUT!C5","v":0},"Notes"]
[null,"Total Acreage (ac)",{"$f":"INPUT!C33","v":20}]
[null,"Weighted C - Proposed Conditions",{"$f":"IFERROR(INPUT!G33,0)","v":0.72499999999999998}]
[null,"Weighted CN - Proposed Conditions",{"$f":"IFERROR(INPUT!I33,0)","v":88.75}]
[null,"Time of Concentration PRE (hr)",{"$f":"INPUT!H49","v":0.37737374814043551}]
[null,"Time of Concentration POST (hr)",{"$f":"INPUT!H64","v":0.28023478509067845}]
[null,"Water Quality (WQ) Volume (ft3)",{"$f":"IFERROR('PRE vs POST Calculations'!H4,0)","v":52635},"Volume from 1 inch of rainfall"]
[null,"Channel Protection (CP) Volume (ft3)",{"$f":"'PRE vs POST Calculations'!K30","v":77855.75784945066},"2-yr / 24-hr rainfall event (volume difference between pre-development and post-development"]
[null,"Infiltration Volume (ft3) - Required",{"$f":"IFERROR('PRE vs POST Calculations'!L37,0)","v":77855.75784945066},"Larger of the WQ volume and CP volume"]
[null,"Infiltration Volume (ft3) - Provided",{"$f":"'BMP Volume Calculations'!J20","v":77657.5},"Computed from the \"BMP INPUT\" worksheet"]
[null,"25-Year Peak Allowable Discharge (cfs)",{"$f":"IFERROR(IF(INPUT!D8=\"\",'PRE vs POST Calculations'!W85,INPUT!D8),0)","v":2}]
[null,"25-Year Flood Protection (FP) Volume (ft3)",{"$f":"'PRE vs POST Calculations'!AS29","v":101579.52846974303}]
[]
[null,"25-Year TOTAL BASIN VOLUME (ft3) - Pre vs Post",{"$f":"C14","v":101579.52846974303},"Use the larger of these two values (represents net 25-year volume, including credit for Infiltration Volume)"]
[null,"25-Year TOTAL BASIN VOLUME (ft3) - Restricted Outlet",{"$f":"IFERROR('Restricted Outlet Calculations'!B9,\"N/A\")","v":170000}]
[null,"25-Year Volume (ft3) - REQUIRED (net of infiltration)",{"$f":"MAX(C16:C17)-C12","v":92342.5}]
[]
[null,"100-year RETENTION VOLUME (ft3)",{"$f":"ROUND('PRE vs POST Calculations'!AM27,-2)","v":330900},"Use only for sites with approved No Outlet Certification"]

{"sheet":"BMP INPUT","index":2,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,4,1,5],[8,4,8,5],[15,4,15,5],[17,10,17,11],[7,13,7,14],[13,13,13,14],[1,7,1,8],[8,7,8,8],[15,7,15,8],[1,10,1,11],[1,13,1,14],[9,10,9,11],[38,1,38,2],[1,1,1,2],[8,1,8,2],[16,1,16,2],[23,1,23,2],[31,1,31,2]]}
[]
[null,"Bioretention/Rain Garden/Infiltration Basin #1",null,null,"Porous Pavement #1",null,null,"Dry Well #1",null,null,"Bioswale #1",null,null,"Other #1"]
[null,"Avg Design Infiltration Rate (in/hr)",0.6,null,"Avg Design Infiltration Rate (in/hr)",null,null,"Avg Design Infiltration Rate (in/hr)",null,null,"Avg Design Infiltration Rate (in/hr)",null,null,"Type of BMP"]
[null,"Area of Bioretention Ponding at Max. Depth (ft2)",12000,null,"Average Bed Area (ft2)",null,null,"Average Bed Area (ft2)",null,null,"Length of Swale Per Check Dam (ft)",null,null,"Avg Design Infiltration Rate (in/hr)"]
[null,"Area of Bioretention at Bottom (ft2)",11000,null,"Maximum Water Depth (ft)",null,null,"Maximum Water Depth (ft)",null,null,"Depth of Check Dam (ft)",null,null,"Bed Area (ft2)"]
[null,"Maximum Ponding Depth (ft)",1,null,"Void Ratio (0.30 max)",null,null,"Void Ratio",0.3,null,"Top Width of Check Dam (ft)",null,null,"Storage Volume (ft3)"]
[null,"BMP Area (ft2)",{"$f":"(C4+C5)/2","v":11500},null,"Storage Volume (ft3)",{"$f":"IF(F6>0.3,F4*F5*0.3,F4*F5*F6)","v":0},null,"Storage Volume (ft3)",{"$f":"I4*I5*I6","v":0},null,"Bottom Width of Check Dam (ft)"]
[null,"Surface Storage Volume (ft3)",{"$f":"IFERROR(AVERAGE(C4:C5)*C6,0)","v":11500},null,null,null,null,null,null,null,"Storage Volume (ft3)",{"$f":"0.5*L4*L5*(L6+L7)/2","v":0},null,"Other #2"]
[null,null,null,null,"Porous Pavement #2",null,null,"Dry Well #2",null,null,null,null,null,"Type of BMP"]
[null,"Area of engineered soil media (ft)",11000,null,"Avg Design Infiltration Rate (in/hr)",null,null,"Avg Design Infiltration Rate (in/hr)",null,null,"Bioswale #2",null,null,"Avg Design Infiltration Rate (in/hr)"]
[null,"Depth of engineered soil media (ft)",3,null,"Average Bed Area (ft2)",null,null,"Average Bed Area (ft2)",null,null,"Avg Design Infiltration Rate (in/hr)",null,null,"Bed Area (ft2)"]
[null,"Void Ratio (max 0.30)",0.3,null,"Maximum Water Depth (ft)",null,null,"Maximum Water Depth (ft)",null,null,"Length of Swale Per Check Dam (ft)",null,null,"Storage Volume (ft3)"]
[null,"Soil Storage Volume (ft3)",{"$f":"IF(C12>0.3,C10*C11*0.3,C10*C11*C12)","v":9900},null,"Void Ratio (0.30 max)",null,null,"Void Ratio",0.3,null,"Depth of Check Dam (ft)"]
[null,"TOTAL STORAGE VOLUME (ft3)",{"$f":"C8+C13","v":21400},null,"Storage Volume (ft3)",{"$f":"IF(F13>0.3,F11*F12*0.3,F11*F12*F13)","v":0},null,"Storage Volume (ft3)",{"$f":"I11*I12*I13","v":0},null,"Top Width of Check Dam (ft)",null,null,"Other #3"]
[null,"TOTAL VOLUME: STORAGE + ACTIVE INFILTRATION",{"$f":"(C7/12*C3*6)+C14","v":24850},null,null,null,null,null,null,null,"Bottom Width of Check Dam (ft)",null,null,"Type of BMP"]
[null,null,null,null,"Porous Pavement #3",null,null,"Dry Well #3",null,null,"Storage Volume (ft3)",{"$f":"0.5*L12*L13*(L14+L15)/2","v":0},null,"Avg Design Infiltration Rate (in/hr)"]
[null,"Bioretention/Rain Garden/Infiltration Basin #2",null,null,"Avg Design Infiltration Rate (in/hr)",null,null,"Avg Design Infiltration Rate (in/hr)",null,null,null,null,null,"Bed Area (ft2)"]
[null,"Avg Design Infiltration Rate (in/hr)",0.7,null,"Average Bed Area (ft2)",null,null,"Average Bed Area (ft2)",null,null,"Bioswale #3",null,null,"Storage Volume (ft3)"]
[null,"Area of Bioretention Ponding at Max. Depth (ft2)",10500,null,"Maximum Water Depth (ft)",null,null,"Maximum Water Depth (ft)",null,null,"Avg Design Infiltration Rate (in/hr)"]
[null,"Area of Bioretention at Bottom (ft2)",9600,null,"Void Ratio (0.30 max)",null,null,"Void Ratio",0.3,null,"Length of Swale Per Check Dam (ft)"]
[null,"Maximum Ponding Depth (ft)",1,null,"Storage Volume (ft3)",{"$f":"IF(F20>0.3,F18*F19*0.3,F18*F19*F20)","v":0},null,"Storage Volume (ft3)",{"$f":"I18*I19*I20","v":0},null,"Depth of Check Dam (ft)"]
[null,"BMP Area (ft2)",{"$f":"(C19+C20)/2","v":10050},null,null,null,null,null,null,null,"Top Width of Check Dam (ft)"]
[null,"Surface Storage Volume (ft3)",{"$f":"IFERROR(AVERAGE(C19:C20)*C21,)","v":10050},null,null,null,null,null,null,null,"Bottom Width of Check Dam (ft)"]
[null,null,null,null,null,null,null,null,null,null,"Storage Volume (ft3)",{"$f":"0.5*L20*L21*(L22+L23)/2","v":0}]
[null,"Area of engineered soil media (ft)",9600]
[null,"Depth of engineered soil media (ft)",3]
[null,"Void Ratio (max 0.30)",0.3]
[null,"Soil Storage Volume (ft3)",{"$f":"IF(C27>0.3,C25*C26*0.3,C25*C26*C27)","v":8640}]
[null,"TOTAL STORAGE VOLUME (ft3)",{"$f":"C23+C28","v":18690}]
[null,"TOTAL VOLUME: STORAGE + ACTIVE INFILTRATION",{"$f":"(C22/12*C18*6)+C29","v":22207.5}]
[]
[null,"Bioretention/Rain Garden/Infiltration Basin #3"]
[null,"Avg Design Infiltration Rate (in/hr)",2.4]
[null,"Area of Bioretention Ponding at Max. Depth (ft2)",9000]
[null,"Area of Bioretention at Bottom (ft2)",8200]
[null,"Maximum Ponding Depth (ft)",1.5]
[null,"BMP Area (ft2)",{"$f":"(C34+C35)/2","v":8600}]
[null,"Surface Storage Volume (ft3)",{"$f":"IFERROR(AVERAGE(C34:C35)*C36,0)","v":12900}]
[]
[null,"Area of engineered soil media (ft)",8200]
[null,"Depth of engineered soil media (ft)",3]
[null,"Void Ratio (max 0.30)",0.3]
[null,"Soil Storage Volume (ft3)",{"$f":"IF(C42>0.3,C40*C41*0.3,C40*C41*C42)","v":7380}]
[null,"TOTAL STORAGE VOLUME (ft3)",{"$f":"C38+C43","v":20280}]
[null,"TOTAL VOLUME: STORAGE + ACTIVE INFILTRATION",{"$f":"(C37/12*C33*6)+C44","v":30600}]

{"sheet":"Outlet Calculations","index":3,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[[48,7,48,8],[52,7,52,8],[53,7,53,8],[54,7,54,8],[30,8,31,9],[36,7,36,10],[39,7,39,8],[40,7,40,8],[47,7,47,10],[41,7,41,8],[23,7,23,10],[23,2,23,5],[39,2,39,3],[40,2,40,3],[1,13,1,14],[24,2,24,3],[24,7,24,8],[27,2,27,3],[28,2,28,3],[28,7,28,8],[41,2,41,3],[37,2,37,3],[36,2,36,5],[27,7,27,8],[30,3,31,4]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"For Interpolation                                                      "]
[null,null,"Elevation","Contour","Storage","Total ",null,null,null,null,null,null,null,"Total ","Elevation"]
[null,null,"Contour","Area","Volume","Volume",null,null,null,null,null,null,null,"Volume","Contour"]
[null,null,"(feet)","(Sq. ft)","(Cu. ft.)","(Cu. Ft.)",null,null,null,null,null,null,null,"(Cu. Ft.)","(feet)"]
[null,"(lowest)",893,8273,0,0,null,null,null,null,null,null,null,{"$f":"F6","v":0},{"$f":"IF(C6=0,\"-\",C6)","v":893}]
[null,null,894,9400,{"$f":"IF(D7=0,\"-\",(D6+D7+(D6*D7)^0.5)*((C7-C6)/3))","v":8830.5048713837641},{"$f":"IF(E7=\"-\",\"-\",E7+E6)","v":8830.5048713837641},null,null,null,null,null,null,null,8830.5048713837641,894]
[null,null,895,10600,9993.9945902580748,{"$f":"IF(E8=\"-\",\"-\",E8+E7)","v":18824.499461641841},null,null,null,null,null,null,null,18824.499461641841,895]
[null,null,896,11871,11229.504364457745,21223.498954715818,null,null,null,null,null,null,null,21223.498954715818,896]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,null,null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[null,"(highest)",null,null,"-","-",null,null,null,null,null,null,null,"-","-"]
[]
[]
[null,null,"1-Stage Outlet Design - INFILTRATION REQUIREMENT SATISFIED",null,null,null,null,"2-Stage Outlet Design - INFILTRATION REQUIREMENT NOT MET"]
[null,null,null,null,null,null,null,"25-Year Allowable Peak Discharge",null,{"$f":"SUMMARY!C13","v":2},"cfs"]
[null,null,"25-Year Allowable Peak Discharge",null,{"$f":"SUMMARY!C13","v":2},"cfs",null,"2-Year Allowable Peak Discharge",null,{"$f":"'PRE vs POST Calculations'!W82","v":3.6969822761832392},"cfs"]
[]
[null,null,"25-Year Peak Storage Volume:",null,{"$f":"SUMMARY!C18","v":92342.5},"cft",null,"2-Year Peak Storage Volume:",null,{"$f":"SUMMARY!C10","v":77855.75784945066},"cft"]
[null,null,null,null,null,null,null,"25-Year Peak Storage Volume:",null,{"$f":"SUMMARY!C18","v":92342.5},"cft"]
[]
[null,null,null,"Peak Storage Elevations",null,null,null,null,"Peak Storage Elevations"]
[]
[null,null,null,"Xbot =",{"$f":"C6","v":893},null,null,null,"Xbot =",{"$f":"C6","v":893}]
[null,null,null,"X25 =",{"$f":"IFERROR(INDEX($N$6:$O$21,MATCH(E28,$N$6:$N$21,1),2)+(E28-INDEX($N$6:$O$21,MATCH(E28,$N$6:$N$21,1),1))*(INDEX($N$6:$O$21,MATCH(E28,$N$6:$N$21,1)+1,2)-INDEX($N$6:$O$21,MATCH(E28,$N$6:$N$21,1),2))/(INDEX($N$6:$O$21,MATCH(E28,$N$6:$N$21,1)+1,1)-INDEX($N$6:$O$21, MATCH(E28,$N$6:$N$21,1),1)),\"-\")","v":"-"},null,null,null,"X2 =",{"$f":"IFERROR(INDEX($N$6:$O$21,MATCH(J28,$N$6:$N$21,1),2)+(J28-INDEX($N$6:$O$21,MATCH(J28,$N$6:$N$21,1),1))*(INDEX($N$6:$O$21,MATCH(J28,$N$6:$N$21,1)+1,2)-INDEX($N$6:$O$21,MATCH(J28,$N$6:$N$21,1),2))/(INDEX($N$6:$O$21,MATCH(J28,$N$6:$N$21,1)+1,1)-INDEX($N$6:$O$21, MATCH(J28,$N$6:$N$21,1),1)),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,"X25 = ",{"$f":"IFERROR(INDEX($N$6:$O$21,MATCH(J29,$N$6:$N$21,1),2)+(J29-INDEX($N$6:$O$21,MATCH(J29,$N$6:$N$21,1),1))*(INDEX($N$6:$O$21,MATCH(J29,$N$6:$N$21,1)+1,2)-INDEX($N$6:$O$21,MATCH(J29,$N$6:$N$21,1),2))/(INDEX($N$6:$O$21,MATCH(J29,$N$6:$N$21,1)+1,1)-INDEX($N$6:$O$21, MATCH(J29,$N$6:$N$21,1),1)),\"-\")","v":"-"}]
[]
[null,null,"25-Year Orifice and Peak Flow Calculations",null,null,null,null,"2-Year Orifice and Peak Flow Calculations"]
[null,null,"25-Year Allowable Peak Discharge:",null,{"$f":"E26","v":2},"cfs",null,"2-Year Allowable Peak Discharge:",null,{"$f":"J26","v":3.6969822761832392},"cfs"]
[]
[null,null,"Chosen Orifice Size (25-Year Control):",null,null,"in",null,"Chosen Orifice Size (2-Year Control):",null,null,"in"]
[null,null,"Chosen Orifice Area:",null,{"$f":"3.14159*(E40/2)^2/144","v":0},"sft",null,"Chosen Orifice Area:",null,{"$f":"3.14159*(J40/2)^2/144","v":0},"sft"]
[null,null,"Number of Orifices (25-Year Control):",null,null,null,null,"Number of Orifices (2-Year Control):"]
[null,null,"Total Opening Area of 25-Year Control Orifice(s):",null,{"$f":"E41*E42","v":0},"sft",null,"Total Opening Area of 2-Year Control Orifice(s):",null,{"$f":"J41*J42","v":0},"sft"]
[null,null,"25-year Peak Flow:","0.62*#orif*Aorifact*sqrt(2*g*h)",{"$f":"0.62*E42*E41*SQRT(2*32.2*(E34-E33-(0.5*E40/12)))","v":{"$error":"#VALUE!"}},"cfs"," ","2-Year Peak Head:","(X2-Xbot-X1/2OrificeDia)",{"$f":"J34-J33-(0.5*(J40/12))","v":{"$error":"#VALUE!"}},"ft"]
[null,null,"25-Year Peak Flow Requirement Met?","Q25act < Q25allow?",{"$f":"E44<E38","v":{"$error":"#VALUE!"}},null,null,"2-Year Peak Flow:","0.62*#orif*Aorifact*sqrt(2*g*h)",{"$f":"0.62*J42*J41*SQRT(2*32.2*J44)","v":{"$error":"#VALUE!"}},"cfs"]
[null,null,null,null,null,null,null,"2-Year Peak Flow Requirement Met?:","Q2act < Q2allow?",{"$f":"J45<J38","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,"25-Year Orifice and Peak Flow Calculations"]
[null,null,null,null,null,null,null,"25-Year Allowable Peak Discharge:",null,{"$f":"J25","v":2},"cfs"]
[null,null,null,null,null,null,null,"Flow through 2-Year Control:","0.62*#orif2*Aorif2*sqrt(2*g*(X25-Xbot-X1/2OrificeDia))",{"$f":"0.62*J42*J41*SQRT(2*32.2*(J35-J33-(0.5*J40/12)))","v":{"$error":"#VALUE!"}},"cfs"]
[null,null,null,null,null,null,null,"Allowable Flow for 25-Year Control:","Q25allow - Q2",{"$f":"J49-J50","v":{"$error":"#VALUE!"}},"cfs"]
[]
[null,null,null,null,null,null,null,"Chosen Orifice Size (25-Year Control):",null,null,"in"]
[null,null,null,null,null,null,null,"Chosen Orifice Area:",null,{"$f":"3.14159*(J53/2)^2/144","v":0},"sft"]
[null,null,null,null,null,null,null,"Number of Orifices (25-Year control):"]
[null,null,null,null,null,null,null,"Total Opening Area of 25-Year Control Orifice(s):",null,{"$f":"J54*J55","v":0},"sft"]
[null,null,null,null,null,null,null,"25-year Peak Flow:","Q2 + 0.62*#orif*Aorifact*sqrt(2*g*h)",{"$f":"J50+0.62*J55*J54*SQRT(2*32.2*(J35-J33-(0.5*J53/12)))","v":{"$error":"#VALUE!"}},"cfs"]
[null,null,null,null,null,null,null,"25-Year Peak Flow Requirement Met?","Q25act < Q25allow?",{"$f":"J57<J49","v":{"$error":"#VALUE!"}}]

{"sheet":"PRE vs POST Calculations","index":4,"n_rows":92,"n_cols":47,"rows_kept":92,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,1,15],[2,10,2,15],[3,10,3,15],[4,10,4,15],[36,9,36,10],[1,32,1,38],[2,33,2,38],[3,17,3,21],[3,33,3,38],[4,33,4,38],[7,9,8,9],[7,12,8,12],[7,13,8,13],[18,9,18,15],[19,9,20,9],[19,12,20,12],[19,13,20,13],[6,9,6,15],[13,17,13,18],[29,10,29,11],[34,10,34,11],[5,17,5,18],[6,32,6,38],[7,32,8,32],[7,35,8,35],[7,36,8,36],[17,32,17,38],[18,32,19,32],[18,35,19,35],[18,36,19,36],[26,17,26,18],[7,24,8,24],[7,27,8,27],[30,36,30,37],[6,24,6,30],[7,28,8,28],[1,24,1,30],[2,25,2,30],[3,25,3,30],[31,9,32,15],[33,10,33,11],[4,25,4,30],[17,24,17,30],[18,24,19,24],[18,27,19,27],[18,28,19,28],[30,17,30,18],[7,40,8,40],[7,43,8,43],[7,44,8,44],[17,40,17,46],[18,40,19,40],[18,43,19,43],[18,44,19,44],[1,40,1,46],[2,41,2,46],[3,41,3,46],[4,41,4,46],[6,40,6,46],[28,36,28,37],[28,28,28,29],[30,28,30,29],[28,44,28,45],[30,44,30,45]]}
[]
[null,"Water Quality Treatment Volume",null,null,null,null,null,null,null,"Channel Protection Volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flood Protection Volume: 10-yr",null,null,null,null,null,null,null,"Flood Protection Volume: 100-yr",null,null,null,null,null,null,null,"Flood Protection Volume: 25-yr"]
[null,8.3333333333333329E-2,"*","Total Site Area (A) (Ft2)","*","Weighted C","=","VWQ (ft3)",null,"Site Name:",{"$f":"INPUT!C4","v":"Example 20-acre Commercial Development"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Site Name:",{"$f":"K3","v":"Example 20-acre Commercial Development"},null,null,null,null,null,null,"Site Name:",{"$f":"K3","v":"Example 20-acre Commercial Development"},null,null,null,null,null,null,"Site Name:",{"$f":"K3","v":"Example 20-acre Commercial Development"}]
[null,8.3333333333333329E-2,"*",{"$f":"INPUT!C33*43560","v":871200},"*",{"$f":"INPUT!G33","v":0.72499999999999998},"=",{"$f":"B4*D4*F4","v":52635},null,"Total Site Area (acres)",{"$f":"INPUT!D9","v":0},null,null,null,null,null,null,"To Calculate the Existing and Proposed Peak Stormwater Runoff Rate",null,null,null,null,null,null,"Total Site Area (acres):",{"$f":"K4","v":0},null,null,null,null,null,null,"Total Site Area (acres):",{"$f":"K4","v":0},null,null,null,null,null,null,"Total Site Area (acres):",{"$f":"K4","v":0}]
[null,null,null,null,null,null,null,null,null,"2-Year, 24-Hour Rainfall:",2.38,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-Year, 24-Hour Rainfall:",{"$f":"S9","v":3.56},null,null,null,null,null,null,"100-Year, 24-Hour Rainfall:",{"$f":"S10","v":5.71},null,null,null,null,null,null,"25-Year, 24-Hour Rainfall:",{"$f":"S11","v":4.33}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRECIPITATION"]
[null,null,null,null,null,null,null,null,null,"Pre-development Conditions",null,null,null,null,null,null,null,"Frequency","Rainfall (P) (in)",null,null,null,null,null,"Pre-development Conditions",null,null,null,null,null,null,null,"Pre-development Conditions",null,null,null,null,null,null,null,"Pre-development Conditions"]
[null,null,null,null,null,null,null,null,null,"Cover Type/Soil Type","Area","Area","CN","S","Q Runoff1","Runoff Volume2",null,"2-yr, 24 hr",2.54,null,null,null,null,null,"Cover Type/Soil Type","Area","Area","CN","S","Q Runoff","Runoff Volume",null,"Cover Type/Soil Type","Area","Area","CN","S","Q Runoff","Runoff Volume",null,"Cover Type/Soil Type","Area","Area","CN","S","Q Runoff","Runoff Volume"]
[null,null,null,null,null,null,null,null,null,null,"(sf)","(ac)",null,null,"(in)","(ft3)",null,"10-yr, 24 hr",3.56,null,null,null,null,null,null,"(sf)","(ac)",null,null,"(in)","(ft3)",null,null,"(sf)","(ac)",null,null,"(in)","(ft3)",null,null,"(sf)","(ac)",null,null,"(in)","(ft3)"]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D15","v":"Row Crops (Type B)"},{"$f":"L10*43560","v":871200},{"$f":"INPUT!C15","v":20},{"$f":"INPUT!H15","v":75},{"$f":"IFERROR(1000/M10-10,\"\")","v":3.3333333333333339},{"$f":"IFERROR((($K$5-0.2*N10)^2)/($K$5+0.8*N10),\"\")","v":0.58167327168648142},{"$f":"IFERROR(O10/12*K10, 0)","v":42229.479524438553},null,"100-yr, 24 hr",5.71,null,null,null,null,null,{"$f":"J10","v":"Row Crops (Type B)"},{"$f":"AA10*43560","v":871200},{"$f":"L10","v":20},{"$f":"M10","v":75},{"$f":"IFERROR(1000/AB10-10,\"\")","v":3.3333333333333339},{"$f":"IFERROR((($Z$5-0.2*AC10)^2)/($Z$5+0.8*AC10),\"\")","v":1.344439685938615},{"$f":"IFERROR(AD10/12*Z10, 0)","v":97606.321199143451},null,{"$f":"J10","v":"Row Crops (Type B)"},{"$f":"AI10*43560","v":871200},{"$f":"L10","v":20},{"$f":"M10","v":75},{"$f":"IFERROR(1000/AJ10-10,\"\")","v":3.3333333333333339},{"$f":"IFERROR((($AH$5-0.2*AK10)^2)/($AH$5+0.8*AK10),\"\")","v":3.0364358668258387},{"$f":"IFERROR(AL10/12*AH10, 0)","v":220445.24393155589},null,{"$f":"J10","v":"Row Crops (Type B)"},{"$f":"AQ10*43560","v":871200},{"$f":"L10","v":20},{"$f":"M10","v":75},{"$f":"IFERROR(1000/AR10-10,\"\")","v":3.3333333333333339},{"$f":"IFERROR((($AP$5-0.2*AS10)^2)/($AP$5+0.8*AS10),\"\")","v":1.9180578053041126},{"$f":"IFERROR(AT10/12*AP10, 0)","v":139250.99666507856}]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D16","v":0},{"$f":"L11*43560","v":0},{"$f":"INPUT!C16","v":0},{"$f":"INPUT!H16","v":""},{"$f":"IFERROR(1000/M11-10,\"\")","v":""},{"$f":"IFERROR((($K$5-0.2*N11)^2)/($K$5+0.8*N11),\"\")","v":""},{"$f":"IFERROR(O11/12*K11, 0)","v":0},null,"25-yr, 24 hr",4.33,null,null,null,null,null,{"$f":"J11","v":0},{"$f":"AA11*43560","v":0},{"$f":"L11","v":0},{"$f":"M11","v":""},{"$f":"IFERROR(1000/AB11-10,\"\")","v":""},{"$f":"IFERROR((($Z$5-0.2*AC11)^2)/($Z$5+0.8*AC11),\"\")","v":""},{"$f":"IFERROR(AD11/12*Z11, 0)","v":0},null,{"$f":"J11","v":0},{"$f":"AI11*43560","v":0},{"$f":"L11","v":0},{"$f":"M11","v":""},{"$f":"IFERROR(1000/AJ11-10,\"\")","v":""},{"$f":"IFERROR((($AH$5-0.2*AK11)^2)/($AH$5+0.8*AK11),\"\")","v":""},{"$f":"IFERROR(AL11/12*AH11, 0)","v":0},null,{"$f":"J11","v":0},{"$f":"AQ11*43560","v":0},{"$f":"L11","v":0},{"$f":"M11","v":""},{"$f":"IFERROR(1000/AR11-10,\"\")","v":""},{"$f":"IFERROR((($AP$5-0.2*AS11)^2)/($AP$5+0.8*AS11),\"\")","v":""},{"$f":"IFERROR(AT11/12*AP11, 0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D17","v":0},0,{"$f":"INPUT!C17","v":0},{"$f":"INPUT!H17","v":""},"","",0,null,null,null,null,null,null,null,null,0,0,0,"","","",0,null,0,0,0,"","","",0,null,0,0,0,"","","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D18","v":0},0,{"$f":"INPUT!C18","v":0},{"$f":"INPUT!H18","v":""},"","",0,null,null,null,null,null,null,null,null,0,0,0,"","","",0,null,0,0,0,"","","",0,null,0,0,0,"","","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D19","v":0},0,{"$f":"INPUT!C19","v":0},{"$f":"INPUT!H19","v":""},"","",0,null,"MAXIMUM RETENTION (S-in)",null,null,null,null,null,null,0,0,0,"","","",0,null,0,0,0,"","","",0,null,0,0,0,"","","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D20","v":0},0,{"$f":"INPUT!C20","v":0},{"$f":"INPUT!H20","v":""},"","",0,null,"Pre-Development",{"$f":"MIN(IFERROR((1000/INPUT!I21)-10,0),15)","v":3.3333333333333339},null,null,null,null,null,0,0,0,"","","",0,null,0,0,0,"","","",0,null,0,0,0,"","","",0]
[null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(K10:K15)","v":871200},{"$f":"SUM(L10:L15)","v":20},"N/A","N/A","N/A",{"$f":"SUM(P10:P15)","v":42229.479524438553},null,"Post-Development",{"$f":"IFERROR((1000/INPUT!I33)-10,0)","v":1.2676056338028161},null,null,null,null,null,"TOTAL",{"$f":"SUM(Z10:Z15)","v":871200},{"$f":"SUM(AA10:AA15)","v":20},"N/A","N/A","N/A",{"$f":"SUM(AE10:AE15)","v":97606.321199143451},null,"TOTAL",{"$f":"SUM(AH10:AH15)","v":871200},{"$f":"SUM(AI10:AI15)","v":20},"N/A","N/A","N/A",{"$f":"SUM(AM10:AM15)","v":220445.24393155589},null,"TOTAL",{"$f":"SUM(AP10:AP15)","v":871200},{"$f":"SUM(AQ10:AQ15)","v":20},"N/A","N/A","N/A",{"$f":"SUM(AU10:AU15)","v":139250.99666507856}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUNOFF (Q-in)",null,null,null,null,null,null,"Post-development Conditions",null,null,null,null,null,null,null,"Post-development Conditions",null,null,null,null,null,null,null,"Post-development Conditions"]
[null,null,null,null,null,null,null,null,null,"Post-development Conditions",null,null,null,null,null,null,null,null,"Pre-Development","Post-Development",null,null,null,null,"Cover Type/Soil Type","Area","Area","CN","S","Q Runoff","Runoff Volume",null,"Cover Type/Soil Type","Area","Area","CN","S","Q Runoff","Runoff Volume",null,"Cover Type/Soil Type","Area","Area","CN","S","Q Runoff","Runoff Volume"]
[null,null,null,null,null,null,null,null,null,"Cover Type","Area","Area","CN","S","Q Runoff1","Runoff Volume2",null,"2 yr, 24 hr",{"$f":"(($S$8-(0.2*$S$15))^2)/($S$8+(0.8*$S$15))","v":0.67401621852326055},{"$f":"(($S$8-(0.2*$S$16))^2)/($S$8+(0.8*$S$16))","v":1.4709795525152189},null,null,null,null,null,"(sf)","(ac)",null,null,"(in)","(ft3)",null,null,"(sf)","(ac)",null,null,"(in)","(ft3)",null,null,"(sf)","(ac)",null,null,"(in)","(ft3)"]
[null,null,null,null,null,null,null,null,null,null,"(sf)","(ac)",null,null,"(in)","(ft3)",null,"10 yr, 24 hr",{"$f":"(($S$9-(0.2*$S$15))^2)/($S$9+(0.8*$S$15))","v":1.344439685938615},{"$f":"(($S$9-(0.2*$S$16))^2)/($S$9+(0.8*$S$16))","v":2.3901619050427718},null,null,null,null,{"$f":"J22","v":"Impervious Cover (pavement/gravel/rooftop)"},{"$f":"AA21*43560","v":653400},{"$f":"L22","v":15},{"$f":"M22","v":98},{"$f":"IFERROR(1000/AB21-10,\"\")","v":0.20408163265306101},{"$f":"IFERROR((($Z$5-0.2*AC21)^2)/($Z$5+0.8*AC21),\"\")","v":3.3262882736957975},{"$f":"IFERROR(AD21/12*Z21, 0)","v":181116.3965027362},null,{"$f":"J22","v":"Impervious Cover (pavement/gravel/rooftop)"},{"$f":"AI21*43560","v":653400},{"$f":"L22","v":15},{"$f":"M22","v":98},{"$f":"IFERROR(1000/AJ21-10,\"\")","v":0.20408163265306101},{"$f":"IFERROR((($AH$5-0.2*AK21)^2)/($AH$5+0.8*AK21),\"\")","v":5.4721933793844864},{"$f":"IFERROR(AL21/12*AH21, 0)","v":297960.9295074853},null,{"$f":"J22","v":"Impervious Cover (pavement/gravel/rooftop)"},{"$f":"AQ21*43560","v":653400},{"$f":"L22","v":15},{"$f":"M22","v":98},{"$f":"IFERROR(1000/AR21-10,\"\")","v":0.20408163265306101},{"$f":"IFERROR((($AP$5-0.2*AS21)^2)/($AP$5+0.8*AS21),\"\")","v":4.0943713160424275},{"$f":"IFERROR(AT21/12*AP21, 0)","v":222938.51815851018}]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D27","v":"Impervious Cover (pavement/gravel/rooftop)"},{"$f":"L22*43560","v":653400},{"$f":"INPUT!C27","v":15},{"$f":"INPUT!H27","v":98},{"$f":"IFERROR(1000/M22-10,\"\")","v":0.20408163265306101},{"$f":"IFERROR((($K$5-0.2*N22)^2)/($K$5+0.8*N22),\"\")","v":2.1514783554249819},{"$f":"IFERROR(O22/12*K22,0)","v":117147.99645289026},null,"100 yr, 24 hr",{"$f":"(($S$10-(0.2*$S$15))^2)/($S$10+(0.8*$S$15))","v":3.0364358668258387},{"$f":"(($S$10-(0.2*$S$16))^2)/($S$10+(0.8*$S$16))","v":4.4278387136459028},null,null,null,null,{"$f":"J23","v":"Manicured Lawn Areas (Type B)"},{"$f":"AA22*43560","v":217800},{"$f":"L23","v":5},{"$f":"M23","v":61},{"$f":"IFERROR(1000/AB22-10,\"\")","v":6.3934426229508183},{"$f":"IFERROR((($Z$5-0.2*AC22)^2)/($Z$5+0.8*AC22),\"\")","v":0.59994577239026559},{"$f":"IFERROR(AD22/12*Z22, 0)","v":10889.015768883321},null,{"$f":"J23","v":"Manicured Lawn Areas (Type B)"},{"$f":"AI22*43560","v":217800},{"$f":"L23","v":5},{"$f":"M23","v":61},{"$f":"IFERROR(1000/AJ22-10,\"\")","v":6.3934426229508183},{"$f":"IFERROR((($AH$5-0.2*AK22)^2)/($AH$5+0.8*AK22),\"\")","v":1.814038565095232},{"$f":"IFERROR(AL22/12*AH22, 0)","v":32924.799956478462},null,{"$f":"J23","v":"Manicured Lawn Areas (Type B)"},{"$f":"AQ22*43560","v":217800},{"$f":"L23","v":5},{"$f":"M23","v":61},{"$f":"IFERROR(1000/AR22-10,\"\")","v":6.3934426229508183},{"$f":"IFERROR((($AP$5-0.2*AS22)^2)/($AP$5+0.8*AS22),\"\")","v":0.98578550833671708},{"$f":"IFERROR(AT22/12*AP22, 0)","v":17892.006976311415}]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D28","v":"Manicured Lawn Areas (Type B)"},{"$f":"L23*43560","v":217800},{"$f":"INPUT!C28","v":5},{"$f":"INPUT!H28","v":61},{"$f":"IFERROR(1000/M23-10,\"\")","v":6.3934426229508183},{"$f":"IFERROR((($K$5-0.2*N23)^2)/($K$5+0.8*N23),\"\")","v":0.16183145570242091},{"$f":"IFERROR(O23/12*K23,0)","v":2937.2409209989396},null,"25 yr, 24 hr",{"$f":"(($S$11-(0.2*$S$15))^2)/($S$11+(0.8*$S$15))","v":1.9180578053041126},{"$f":"(($S$11-(0.2*$S$16))^2)/($S$11+(0.8*$S$16))","v":3.1095466364854931},null,null,null,null,0,0,0,"","","",0,null,0,0,0,"","","",0,null,0,0,0,"","","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D29","v":0},0,{"$f":"INPUT!C29","v":0},{"$f":"INPUT!H29","v":""},"","",0,null,null,null,null,null,null,null,null,0,0,0,"","","",0,null,0,0,0,"","","",0,null,0,0,0,"","","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D30","v":0},0,{"$f":"INPUT!C30","v":0},{"$f":"INPUT!H30","v":""},"","",0,null,"Calculate Initial Abstraction",null,null,null,null,null,null,0,0,0,"","","",0,null,0,0,0,"","","",0,null,0,0,0,"","","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D31","v":0},0,{"$f":"INPUT!C31","v":0},{"$f":"INPUT!H31","v":""},"","",0,null,null,null,null,null,null,null,null,0,0,0,"","","",0,null,0,0,0,"","","",0,null,0,0,0,"","","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"INPUT!D32","v":0},0,{"$f":"INPUT!C32","v":0},{"$f":"INPUT!H32","v":""},"","",0,null,"Pre-Development",null,null,null,null,null,null,"TOTAL",{"$f":"SUM(Z21:Z26)","v":871200},{"$f":"SUM(AA21:AA26)","v":20},"N/A","N/A","N/A",{"$f":"SUM(AE21:AE26)","v":192005.41227161951},null,"TOTAL",{"$f":"SUM(AH21:AH26)","v":871200},{"$f":"SUM(AI21:AI26)","v":20},"N/A","N/A","N/A",{"$f":"SUM(AM21:AM26)","v":330885.72946396377},null,"TOTAL",{"$f":"SUM(AP21:AP26)","v":871200},{"$f":"SUM(AQ21:AQ26)","v":20},"N/A","N/A","N/A",{"$f":"SUM(AU21:AU26)","v":240830.5251348216}]
[null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(K22:K27)","v":871200},{"$f":"SUM(L22:L27)","v":20},"N/A","N/A","N/A",{"$f":"SUM(P22:P27)","v":120085.23737388921},null,"Curve Number","Initial Abstraction (Ia)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INPUT!I21,\"\")","v":75},{"$f":"IFERROR(((1000/R29)-10)*0.2,0)","v":0.66666666666666685},null,null,null,null,null,null,null,"V10 Runoff Volume Increase (ft3) =",null,{"$f":"AE27-AE16","v":94399.091072476062},null,null,null,null,null,"V100 Runoff Volume Increase (ft3) =",null,{"$f":"AM27-AM16","v":110440.48553240788},null,null,null,null,null,"V25 Runoff Volume Increase (ft3) =",null,{"$f":"AU27-AU16","v":101579.52846974303}]
[null,null,null,null,null,null,null,null,null,"VCP Volume Increase (ft3)",{"$f":"P28-P16","v":77855.75784945066}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Post-Development",null,null,null,null,null,null,null,null,"10-year peak detention pond discharge (cfs) =",null,{"$f":"IFERROR(W83,0)","v":23.675734712218102},null,null,null,null,null,"100-year peak detention pond discharge (cfs) =",null,{"$f":"IFERROR(W84,0)","v":56.886718474767108},null,null,null,null,null,"25-year peak detention pond discharge (cfs) =",null,{"$f":"IFERROR(W85,0)","v":34.779307624785041}]
[null,null,null,null,null,null,null,null,null,"Compare the Channel Protection Volume with the Water Quality Volume, the Greater of the two is the Onsite Infiltration Requirement.",null,null,null,null,null,null,null,"Curve Number","Initial Abstraction (Ia)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INPUT!I33,\"\")","v":88.75},{"$f":"IFERROR(((1000/R33)-10)*0.2,0)","v":0.25352112676056321}]
[null,null,null,null,null,null,null,null,null,null,"VWQ (ft3) =",null,{"$f":"H4","v":52635}]
[null,null,null,null,null,null,null,null,null,null,"VCP Volume Increase (ft3) =",null,{"$f":"K30","v":77855.75784945066},null,null,null,null,"Calculate Ia/P - Pre-Development"]
[]
[null,null,null,null,null,null,null,null,null,"Onsite Infiltration Requirement, Vinf (ft3) =",null,{"$f":"LARGE(M34:M35,1)","v":77855.75784945066},null,null,null,null,null,"Pre-Development"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frequency","Ia (in)","Rainfall (P-in)","Ia/P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 yr, 24 hr",{"$f":"$S$29","v":0.66666666666666685},{"$f":"S20","v":0.67401621852326055},{"$f":"IF(S39/T39<0.1,0.1,IF(S39/T39>0.5,0.5,S39/T39))","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 yr, 24 hr",{"$f":"$S$29","v":0.66666666666666685},{"$f":"S9","v":3.56},{"$f":"IF(S40/T40<0.1,0.1,IF(S40/T40>0.5,0.5,S40/T40))","v":0.1872659176029963}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 yr, 24 hr",{"$f":"$S$29","v":0.66666666666666685},{"$f":"S10","v":5.71},{"$f":"IF(S41/T41<0.1,0.1,IF(S41/T41>0.5,0.5,S41/T41))","v":0.11675423234092239}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 yr, 24 hr",{"$f":"$S$29","v":0.66666666666666685},{"$f":"S11","v":4.33},{"$f":"IF(S42/T42<0.1,0.1,IF(S42/T42>0.5,0.5,S42/T42))","v":0.15396458814472674}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Post-Development"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frequency","Ia (in)","Rainfall (P-in)","Ia/P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 yr, 24 hr",{"$f":"$S$33","v":0.25352112676056321},{"$f":"T20","v":1.4709795525152189},{"$f":"IF(S46/T46<0.1,0.1,IF(S46/T46>0.5,0.5,S46/T46))","v":0.17234850499931761}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 yr, 24 hr",{"$f":"$S$33","v":0.25352112676056321},{"$f":"S9","v":3.56},{"$f":"IF(S47/T47<0.1,0.1,IF(S47/T47>0.5,0.5,S47/T47))","v":0.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 yr, 24 hr",{"$f":"$S$33","v":0.25352112676056321},{"$f":"S10","v":5.71},{"$f":"IF(S48/T48<0.1,0.1,IF(S48/T48>0.5,0.5,S48/T48))","v":0.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 yr, 24 hr",{"$f":"$S$33","v":0.25352112676056321},{"$f":"S11","v":4.33},{"$f":"IF(S49/T49<0.1,0.1,IF(S49/T49>0.5,0.5,S49/T49))","v":0.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculate Unit Peak Discharge (qu)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Log(qu) =","C0 + C1*log(Tc) + C2*[log(Tc)]2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"qu =","10^(C0 + C1*log(Tc) + C2*[log(Tc)]2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rainfall Type II"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ia/P","C0","Ia/P","C1","Ia/P","C2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,2.5532300000000001,0.1,-0.61512,0.1,-0.16403000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,2.4653200000000002,0.3,-0.62256999999999996,0.3,-0.11656999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,2.4189600000000002,0.35,-0.61594000000000004,0.35,-8.8200000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,2.36409,0.4,-0.59857000000000005,0.4,-5.6210000000000003E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,2.2923800000000001,0.45,-0.57004999999999995,0.45,-2.281E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,2.0282,0.5,-0.51598999999999995,0.5,-1.259E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-Development"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frequency","Ia/P","C0","C1","C2","qu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 yr, 24 hr",{"$f":"IF(U39<0.5,U39,0.4999999)","v":0.4999999},{"$f":"INDEX($R$56:$S$61,MATCH($S$65,$R$56:$R$61,1),2)+($S$65-INDEX($R$56:$S$61,MATCH($S$65,$R$56:$R$61,1),1))*(INDEX($R$56:$S$61,MATCH($S$65,$R$56:$R$61,1)+1,2)-INDEX($R$56:$S$61,MATCH($S$65,$R$56:$R$61,1),2))/(INDEX($R$56:$S$61,MATCH($S$65,$R$56:$R$61,1)+1,1)-INDEX($R$56:$S$61, MATCH($S$65,$R$56:$R$61,1),1))","v":2.0282005283600002},{"$f":"INDEX($T$56:$U$61,MATCH($S$65,$T$56:$T$61,1),2)+($S$65-INDEX($T$56:$U$61,MATCH($S$65,$T$56:$T$61,1),1))*(INDEX($T$56:$U$61,MATCH($S$65,$T$56:$T$61,1)+1,2)-INDEX($T$56:$U$61,MATCH($S$65,$T$56:$T$61,1),2))/(INDEX($T$56:$U$61,MATCH($S$65,$T$56:$T$61,1)+1,1)-INDEX($T$56:$U$61, MATCH($S$65,$T$56:$T$61,1),1))","v":-0.5159901081199999},{"$f":"INDEX($V$56:$W$61,MATCH($S$65,$V$56:$V$61,1),2)+($S$65-INDEX($V$56:$W$61,MATCH($S$65,$V$56:$V$61,1),1))*(INDEX($V$56:$W$61,MATCH($S$65,$V$56:$V$61,1)+1,2)-INDEX($V$56:$W$61,MATCH($S$65,$V$56:$V$61,1),2))/(INDEX($V$56:$W$61,MATCH($S$65,$V$56:$V$61,1)+1,1)-INDEX($V$56:$W$61, MATCH($S$65,$V$56:$V$61,1),1))","v":-1.2590020440000002E-2},{"$f":"IFERROR(10^(T65+U65*LOG(INPUT!$H$49)+V65*(LOG(INPUT!$H$49))^2),0)","v":175.5201575075763}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 yr, 24 hr",{"$f":"IF(U40<0.5,U40,0.4999999)","v":0.1872659176029963},{"$f":"INDEX($R$56:$S$61,MATCH($S$66,$R$56:$R$61,1),2)+($S$66-INDEX($R$56:$S$61,MATCH($S$66,$R$56:$R$61,1),1))*(INDEX($R$56:$S$61,MATCH($S$66,$R$56:$R$61,1)+1,2)-INDEX($R$56:$S$61,MATCH($S$66,$R$56:$R$61,1),2))/(INDEX($R$56:$S$61,MATCH($S$66,$R$56:$R$61,1)+1,1)-INDEX($R$56:$S$61, MATCH($S$66,$R$56:$R$61,1),1))","v":2.514872265917603},{"$f":"INDEX($T$56:$U$61,MATCH($S$66,$T$56:$T$61,1),2)+($S$66-INDEX($T$56:$U$61,MATCH($S$66,$T$56:$T$61,1),1))*(INDEX($T$56:$U$61,MATCH($S$66,$T$56:$T$61,1)+1,2)-INDEX($T$56:$U$61,MATCH($S$66,$T$56:$T$61,1),2))/(INDEX($T$56:$U$61,MATCH($S$66,$T$56:$T$61,1)+1,1)-INDEX($T$56:$U$61, MATCH($S$66,$T$56:$T$61,1),1))","v":-0.61837065543071157},{"$f":"INDEX($V$56:$W$61,MATCH($S$66,$V$56:$V$61,1),2)+($S$66-INDEX($V$56:$W$61,MATCH($S$66,$V$56:$V$61,1),1))*(INDEX($V$56:$W$61,MATCH($S$66,$V$56:$V$61,1)+1,2)-INDEX($V$56:$W$61,MATCH($S$66,$V$56:$V$61,1),2))/(INDEX($V$56:$W$61,MATCH($S$66,$V$56:$V$61,1)+1,1)-INDEX($V$56:$W$61, MATCH($S$66,$V$56:$V$61,1),1))","v":-0.14332179775280898},{"$f":"IFERROR(10^(T66+U66*LOG(INPUT!$H$49)+V66*(LOG(INPUT!$H$49))^2),0)","v":563.5236141233421}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 yr, 24 hr",{"$f":"IF(U41<0.5,U41,0.4999999)","v":0.11675423234092239},{"$f":"INDEX($R$56:$S$61,MATCH($S$67,$R$56:$R$61,1),2)+($S$67-INDEX($R$56:$S$61,MATCH($S$67,$R$56:$R$61,1),1))*(INDEX($R$56:$S$61,MATCH($S$67,$R$56:$R$61,1)+1,2)-INDEX($R$56:$S$61,MATCH($S$67,$R$56:$R$61,1),2))/(INDEX($R$56:$S$61,MATCH($S$67,$R$56:$R$61,1)+1,1)-INDEX($R$56:$S$61, MATCH($S$67,$R$56:$R$61,1),1))","v":2.5458656771745476},{"$f":"INDEX($T$56:$U$61,MATCH($S$67,$T$56:$T$61,1),2)+($S$67-INDEX($T$56:$U$61,MATCH($S$67,$T$56:$T$61,1),1))*(INDEX($T$56:$U$61,MATCH($S$67,$T$56:$T$61,1)+1,2)-INDEX($T$56:$U$61,MATCH($S$67,$T$56:$T$61,1),2))/(INDEX($T$56:$U$61,MATCH($S$67,$T$56:$T$61,1)+1,1)-INDEX($T$56:$U$61, MATCH($S$67,$T$56:$T$61,1),1))","v":-0.6157440951546993},{"$f":"INDEX($V$56:$W$61,MATCH($S$67,$V$56:$V$61,1),2)+($S$67-INDEX($V$56:$W$61,MATCH($S$67,$V$56:$V$61,1),1))*(INDEX($V$56:$W$61,MATCH($S$67,$V$56:$V$61,1)+1,2)-INDEX($V$56:$W$61,MATCH($S$67,$V$56:$V$61,1),2))/(INDEX($V$56:$W$61,MATCH($S$67,$V$56:$V$61,1)+1,1)-INDEX($V$56:$W$61, MATCH($S$67,$V$56:$V$61,1),1))","v":-0.16005422066549913},{"$f":"IFERROR(10^(T67+U67*LOG(INPUT!$H$49)+V67*(LOG(INPUT!$H$49))^2),0)","v":599.51043625877412}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 yr, 24 hr",{"$f":"IF(U42<0.5,U42,0.4999999)","v":0.15396458814472674},{"$f":"INDEX($R$56:$S$61,MATCH($S$68,$R$56:$R$61,1),2)+($S$68-INDEX($R$56:$S$61,MATCH($S$68,$R$56:$R$61,1),1))*(INDEX($R$56:$S$61,MATCH($S$68,$R$56:$R$61,1)+1,2)-INDEX($R$56:$S$61,MATCH($S$68,$R$56:$R$61,1),2))/(INDEX($R$56:$S$61,MATCH($S$68,$R$56:$R$61,1)+1,1)-INDEX($R$56:$S$61, MATCH($S$68,$R$56:$R$61,1),1))","v":2.5295098652809855},{"$f":"INDEX($T$56:$U$61,MATCH($S$68,$T$56:$T$61,1),2)+($S$68-INDEX($T$56:$U$61,MATCH($S$68,$T$56:$T$61,1),1))*(INDEX($T$56:$U$61,MATCH($S$68,$T$56:$T$61,1)+1,2)-INDEX($T$56:$U$61,MATCH($S$68,$T$56:$T$61,1),2))/(INDEX($T$56:$U$61,MATCH($S$68,$T$56:$T$61,1)+1,1)-INDEX($T$56:$U$61, MATCH($S$68,$T$56:$T$61,1),1))","v":-0.61713018090839111},{"$f":"INDEX($V$56:$W$61,MATCH($S$68,$V$56:$V$61,1),2)+($S$68-INDEX($V$56:$W$61,MATCH($S$68,$V$56:$V$61,1),1))*(INDEX($V$56:$W$61,MATCH($S$68,$V$56:$V$61,1)+1,2)-INDEX($V$56:$W$61,MATCH($S$68,$V$56:$V$61,1),2))/(INDEX($V$56:$W$61,MATCH($S$68,$V$56:$V$61,1)+1,1)-INDEX($V$56:$W$61, MATCH($S$68,$V$56:$V$61,1),1))","v":-0.15122420323325636},{"$f":"IFERROR(10^(T68+U68*LOG(INPUT!$H$49)+V68*(LOG(INPUT!$H$49))^2),0)","v":580.24207660241098}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Post-Development"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frequency","Ia/P","C0","C1","C2","qu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 yr, 24 hr",{"$f":"IF(U46<0.5,U46,0.499999)","v":0.17234850499931761},{"$f":"INDEX($R$56:$S$61,MATCH($S$72,$R$56:$R$61,1),2)+($S$72-INDEX($R$56:$S$61,MATCH($S$72,$R$56:$R$61,1),1))*(INDEX($R$56:$S$61,MATCH($S$72,$R$56:$R$61,1)+1,2)-INDEX($R$56:$S$61,MATCH($S$72,$R$56:$R$61,1),2))/(INDEX($R$56:$S$61,MATCH($S$72,$R$56:$R$61,1)+1,1)-INDEX($R$56:$S$61, MATCH($S$72,$R$56:$R$61,1),1))","v":2.5214292146275499},{"$f":"INDEX($T$56:$U$61,MATCH($S$72,$T$56:$T$61,1),2)+($S$72-INDEX($T$56:$U$61,MATCH($S$72,$T$56:$T$61,1),1))*(INDEX($T$56:$U$61,MATCH($S$72,$T$56:$T$61,1)+1,2)-INDEX($T$56:$U$61,MATCH($S$72,$T$56:$T$61,1),2))/(INDEX($T$56:$U$61,MATCH($S$72,$T$56:$T$61,1)+1,1)-INDEX($T$56:$U$61, MATCH($S$72,$T$56:$T$61,1),1))","v":-0.61781498181122452},{"$f":"INDEX($V$56:$W$61,MATCH($S$72,$V$56:$V$61,1),2)+($S$72-INDEX($V$56:$W$61,MATCH($S$72,$V$56:$V$61,1),1))*(INDEX($V$56:$W$61,MATCH($S$72,$V$56:$V$61,1)+1,2)-INDEX($V$56:$W$61,MATCH($S$72,$V$56:$V$61,1),2))/(INDEX($V$56:$W$61,MATCH($S$72,$V$56:$V$61,1)+1,1)-INDEX($V$56:$W$61, MATCH($S$72,$V$56:$V$61,1),1))","v":-0.14686169976366192},{"$f":"IFERROR(10^(T72+U72*LOG(INPUT!$H$64)+V72*(LOG(INPUT!$H$64))^2),0)","v":657.55411380783869}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 yr, 24 hr",{"$f":"U47","v":0.1},{"$f":"INDEX($R$56:$S$61,MATCH($S$73,$R$56:$R$61,1),2)+($S$73-INDEX($R$56:$S$61,MATCH($S$73,$R$56:$R$61,1),1))*(INDEX($R$56:$S$61,MATCH($S$73,$R$56:$R$61,1)+1,2)-INDEX($R$56:$S$61,MATCH($S$73,$R$56:$R$61,1),2))/(INDEX($R$56:$S$61,MATCH($S$73,$R$56:$R$61,1)+1,1)-INDEX($R$56:$S$61, MATCH($S$73,$R$56:$R$61,1),1))","v":2.5532300000000001},{"$f":"INDEX($T$56:$U$61,MATCH($S$73,$T$56:$T$61,1),2)+($S$73-INDEX($T$56:$U$61,MATCH($S$73,$T$56:$T$61,1),1))*(INDEX($T$56:$U$61,MATCH($S$73,$T$56:$T$61,1)+1,2)-INDEX($T$56:$U$61,MATCH($S$73,$T$56:$T$61,1),2))/(INDEX($T$56:$U$61,MATCH($S$73,$T$56:$T$61,1)+1,1)-INDEX($T$56:$U$61, MATCH($S$73,$T$56:$T$61,1),1))","v":-0.61512},{"$f":"INDEX($V$56:$W$61,MATCH($S$73,$V$56:$V$61,1),2)+($S$73-INDEX($V$56:$W$61,MATCH($S$73,$V$56:$V$61,1),1))*(INDEX($V$56:$W$61,MATCH($S$73,$V$56:$V$61,1)+1,2)-INDEX($V$56:$W$61,MATCH($S$73,$V$56:$V$61,1),2))/(INDEX($V$56:$W$61,MATCH($S$73,$V$56:$V$61,1)+1,1)-INDEX($V$56:$W$61, MATCH($S$73,$V$56:$V$61,1),1))","v":-0.16403000000000001},{"$f":"IFERROR(10^(T73+U73*LOG(INPUT!$H$64)+V73*(LOG(INPUT!$H$64))^2),0)","v":696.63141238004607}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 yr, 24 hr",{"$f":"U48","v":0.1},{"$f":"INDEX($R$56:$S$61,MATCH($S$74,$R$56:$R$61,1),2)+($S$74-INDEX($R$56:$S$61,MATCH($S$74,$R$56:$R$61,1),1))*(INDEX($R$56:$S$61,MATCH($S$74,$R$56:$R$61,1)+1,2)-INDEX($R$56:$S$61,MATCH($S$74,$R$56:$R$61,1),2))/(INDEX($R$56:$S$61,MATCH($S$74,$R$56:$R$61,1)+1,1)-INDEX($R$56:$S$61, MATCH($S$74,$R$56:$R$61,1),1))","v":2.5532300000000001},{"$f":"INDEX($T$56:$U$61,MATCH($S$74,$T$56:$T$61,1),2)+($S$74-INDEX($T$56:$U$61,MATCH($S$74,$T$56:$T$61,1),1))*(INDEX($T$56:$U$61,MATCH($S$74,$T$56:$T$61,1)+1,2)-INDEX($T$56:$U$61,MATCH($S$74,$T$56:$T$61,1),2))/(INDEX($T$56:$U$61,MATCH($S$74,$T$56:$T$61,1)+1,1)-INDEX($T$56:$U$61, MATCH($S$74,$T$56:$T$61,1),1))","v":-0.61512},{"$f":"INDEX($V$56:$W$61,MATCH($S$74,$V$56:$V$61,1),2)+($S$74-INDEX($V$56:$W$61,MATCH($S$74,$V$56:$V$61,1),1))*(INDEX($V$56:$W$61,MATCH($S$74,$V$56:$V$61,1)+1,2)-INDEX($V$56:$W$61,MATCH($S$74,$V$56:$V$61,1),2))/(INDEX($V$56:$W$61,MATCH($S$74,$V$56:$V$61,1)+1,1)-INDEX($V$56:$W$61, MATCH($S$74,$V$56:$V$61,1),1))","v":-0.16403000000000001},{"$f":"IFERROR(10^(T74+U74*LOG(INPUT!$H$64)+V74*(LOG(INPUT!$H$64))^2),0)","v":696.63141238004607}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 yr, 24 hr",{"$f":"U49","v":0.1},{"$f":"INDEX($R$56:$S$61,MATCH($S$75,$R$56:$R$61,1),2)+($S$75-INDEX($R$56:$S$61,MATCH($S$75,$R$56:$R$61,1),1))*(INDEX($R$56:$S$61,MATCH($S$75,$R$56:$R$61,1)+1,2)-INDEX($R$56:$S$61,MATCH($S$75,$R$56:$R$61,1),2))/(INDEX($R$56:$S$61,MATCH($S$75,$R$56:$R$61,1)+1,1)-INDEX($R$56:$S$61, MATCH($S$75,$R$56:$R$61,1),1))","v":2.5532300000000001},{"$f":"INDEX($T$56:$U$61,MATCH($S$75,$T$56:$T$61,1),2)+($S$75-INDEX($T$56:$U$61,MATCH($S$75,$T$56:$T$61,1),1))*(INDEX($T$56:$U$61,MATCH($S$75,$T$56:$T$61,1)+1,2)-INDEX($T$56:$U$61,MATCH($S$75,$T$56:$T$61,1),2))/(INDEX($T$56:$U$61,MATCH($S$75,$T$56:$T$61,1)+1,1)-INDEX($T$56:$U$61, MATCH($S$75,$T$56:$T$61,1),1))","v":-0.61512},{"$f":"INDEX($V$56:$W$61,MATCH($S$75,$V$56:$V$61,1),2)+($S$75-INDEX($V$56:$W$61,MATCH($S$75,$V$56:$V$61,1),1))*(INDEX($V$56:$W$61,MATCH($S$75,$V$56:$V$61,1)+1,2)-INDEX($V$56:$W$61,MATCH($S$75,$V$56:$V$61,1),2))/(INDEX($V$56:$W$61,MATCH($S$75,$V$56:$V$61,1)+1,1)-INDEX($V$56:$W$61, MATCH($S$75,$V$56:$V$61,1),1))","v":-0.16403000000000001},{"$f":"IFERROR(10^(T75+U75*LOG(INPUT!$H$64)+V75*(LOG(INPUT!$H$64))^2),0)","v":696.63141238004607}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculate Peak Discharge (QP)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*assume no ponding factor (Fp)= 1.0"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-Development"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frequency","qu","Am (sq. mi.)","Q-in","Fp","Qp (cfs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 yr, 24 hr",{"$f":"W65","v":175.5201575075763},{"$f":"INPUT!$C$21/640","v":3.125E-2},{"$f":"S20","v":0.67401621852326055},1,{"$f":"S82*T82*U82*V82","v":3.6969822761832392}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 yr, 24 hr",{"$f":"W66","v":563.5236141233421},{"$f":"INPUT!$C$21/640","v":3.125E-2},{"$f":"S21","v":1.344439685938615},1,{"$f":"S83*T83*U83*V83","v":23.675734712218102}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 yr, 24 hr",{"$f":"W67","v":599.51043625877412},{"$f":"INPUT!$C$21/640","v":3.125E-2},{"$f":"S22","v":3.0364358668258387},1,{"$f":"S84*T84*U84*V84","v":56.886718474767108}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 yr, 24 hr",{"$f":"W68","v":580.24207660241098},{"$f":"INPUT!$C$21/640","v":3.125E-2},{"$f":"S23","v":1.9180578053041126},1,{"$f":"S85*T85*U85*V85","v":34.779307624785041}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Post-Development"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frequency","qu","Am (sq. mi.)","Q-in","Fp","Qp (cfs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2  yr, 24 hr",{"$f":"W72","v":657.55411380783869},{"$f":"INPUT!$C$33/640","v":3.125E-2},{"$f":"T20","v":1.4709795525152189},1,{"$f":"S89*T89*U89*V89","v":30.226520502612374}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 yr, 24 hr",{"$f":"W73","v":696.63141238004607},{"$f":"INPUT!$C$33/640","v":3.125E-2},{"$f":"T21","v":2.3901619050427718},1,{"$f":"S90*T90*U90*V90","v":52.033183241466489}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 yr, 24 hr",{"$f":"W74","v":696.63141238004607},{"$f":"INPUT!$C$33/640","v":3.125E-2},{"$f":"T22","v":4.4278387136459028},1,{"$f":"S91*T91*U91*V91","v":96.392860527443489}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 yr, 24 hr",{"$f":"W75","v":696.63141238004607},{"$f":"INPUT!$C$33/640","v":3.125E-2},{"$f":"T23","v":3.1095466364854931},1,{"$f":"S92*T92*U92*V92","v":67.693995788640962}]

{"sheet":"Restricted Outlet Calculations","index":5,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,0,17,3]]}
[]
[]
["Restricted Outflow Discharge (qo)",{"$f":"IF(INPUT!D8=\"\",\"N/A\",INPUT!D8)","v":2},"cfs"]
["25-yr Peak Inflow Discharge (qi)",{"$f":"'PRE vs POST Calculations'!W92","v":67.693995788640962},"cfs"]
["Qo / Qi RATIO",{"$f":"B3/B4","v":2.954471776558357E-2}]
["vs / vr RATIO",{"$f":"-0.142*LN(B5)+0.2062","v":0.70630274358357292}]
[]
["25-yr Post-Development Runoff Volume (vr)",{"$f":"'PRE vs POST Calculations'!AU27","v":240830.5251348216},"cubic feet"]
["25-yr Storage Volume for Flood Control (vs)",{"$f":"IF(B5<0.01,B8,(ROUND((-0.142*LN(B5)+0.2062)*B8,-3)))","v":170000},"cubic feet"]
[]
["Notes for Designers:"]
["1. When qo/qi is at 0.01 or below, store entire 100-yr runoff volume (vr)"]
["2. Designers may use hydrologic/hydraulic routing models to confirm exact storage volume needed"]
["3. vs / vr ratio = [ -.142 * ln(Qo/Qi) + 0.2062 ]"]
["4. Required volume (vs) =  vs / vr ratio * vr"]
["5. This spreadsheet is intented ONLY for restricted outlet scenarios for the 25-year storm"]
[]
["Note: these calculations may result in a lower flood control volume (vs) relative to the 'pre-vs.-post' volume calculated on the SUMMARY tab.  This can occur when the curve numbers are very low (SCS Soil Type A + Low Intensity Development).  In this case, the flood storage volume calculated in this worksheet shall be considered INVALID. "]
[]
[]
[]
[null,null,null,null,null,null,"Source: USDA-NRCS, Urban Hydrology for Small Watersheds, TR-55, June 1986"]
[null,null,null,null,null,null,"For x-axis values less than 0.1, curve based on HEC-HMS detention pond routing for typical developments"]

{"sheet":"BMP Volume Calculations","index":6,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,8,3,8],[1,1,1,9],[19,1,19,8],[12,1,12,2],[2,1,3,3],[2,4,3,4],[2,5,3,5],[4,1,4,2],[5,1,5,2],[6,1,6,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[2,6,3,6],[2,7,3,7]]}
[]
[null,"BMP INFILTRATION VOLUME"]
[null,"Proposed BMP",null,null,"BMP Area (ft2)","Storage Volume (ft3)","Infiltration Period (hrs)","Avg Design Infiltraton Rate (in/hr)","Infiltration Volume (ft3)","Total BMP Volume (ft3)"]
[null,null,null,null,null,null,null,null,null,"(Storage Volume + Infiltration Volume)"]
[null,"Bioretention/Rain Garden",null,"#1",{"$f":"'BMP INPUT'!C7","v":11500},{"$f":"'BMP INPUT'!C14","v":21400},6,{"$f":"IF('BMP INPUT'!C3<0.4,0.4,'BMP INPUT'!C3)","v":0.6},{"$f":"E5/12*G5*H5","v":3450},{"$f":"F5+I5","v":24850}]
[null,"Bioretention/Rain Garden",null,"#2",{"$f":"'BMP INPUT'!C22","v":10050},{"$f":"'BMP INPUT'!C29","v":18690},6,{"$f":"IF('BMP INPUT'!C18<0.4,0.4,'BMP INPUT'!C18)","v":0.7},{"$f":"E6/12*G6*H6","v":3517.5},{"$f":"F6+I6","v":22207.5}]
[null,"Bioretention/Rain Garden",null,"#3",{"$f":"'BMP INPUT'!C37","v":8600},{"$f":"'BMP INPUT'!C44","v":20280},6,{"$f":"IF('BMP INPUT'!C33<0.4,0.4,'BMP INPUT'!C33)","v":2.4},10320,30600]
[null,"Porous Pavement",null,"#1",{"$f":"'BMP INPUT'!F4","v":0},{"$f":"'BMP INPUT'!F7","v":0},6,{"$f":"IF('BMP INPUT'!F3<0.4,0.4,'BMP INPUT'!F3)","v":0.4},0,0]
[null,"Porous Pavement",null,"#2",{"$f":"'BMP INPUT'!F11","v":0},{"$f":"'BMP INPUT'!F14","v":0},6,{"$f":"IF('BMP INPUT'!F10<0.4,0.4,'BMP INPUT'!F10)","v":0.4},0,0]
[null,"Porous Pavement",null,"#3",{"$f":"'BMP INPUT'!F18","v":0},{"$f":"'BMP INPUT'!F21","v":0},6,{"$f":"IF('BMP INPUT'!F17<0.4,0.4,'BMP INPUT'!F17)","v":0.4},0,0]
[null,"Dry Well",null,"#1",{"$f":"'BMP INPUT'!I4","v":0},{"$f":"'BMP INPUT'!I7","v":0},6,{"$f":"IF('BMP INPUT'!I3<0.4,0.4,'BMP INPUT'!I3)","v":0.4},0,0]
[null,"Dry Well",null,"#2",{"$f":"'BMP INPUT'!I11","v":0},{"$f":"'BMP INPUT'!I14","v":0},6,{"$f":"IF('BMP INPUT'!I10<0.4,0.4,'BMP INPUT'!I10)","v":0.4},0,0]
[null,"Dry Well",null,"#3",{"$f":"'BMP INPUT'!I18","v":0},{"$f":"'BMP INPUT'!I21","v":0},6,{"$f":"IF('BMP INPUT'!I17<0.4,0.4,'BMP INPUT'!I17)","v":0.4},0,0]
[null,"Bioswale",null,"#1",{"$f":"'BMP INPUT'!L4*'BMP INPUT'!L7","v":0},{"$f":"'BMP INPUT'!L8","v":0},6,{"$f":"IF('BMP INPUT'!L3<0.4,0.4,'BMP INPUT'!L3)","v":0.4},0,0]
[null,"Bioswale",null,"#2",{"$f":"'BMP INPUT'!L12*'BMP INPUT'!L15","v":0},{"$f":"'BMP INPUT'!L16","v":0},6,{"$f":"IF('BMP INPUT'!L11<0.4,0.4,'BMP INPUT'!L11)","v":0.4},0,0]
[null,"Bioswale",null,"#3",{"$f":"'BMP INPUT'!L20*'BMP INPUT'!L23","v":0},{"$f":"'BMP INPUT'!L24","v":0},6,{"$f":"IF('BMP INPUT'!L19<0.4,0.4,'BMP INPUT'!L19)","v":0.4},0,0]
[null,"Other:",{"$f":"'BMP INPUT'!O3","v":0},"#1",{"$f":"'BMP INPUT'!O5","v":0},{"$f":"'BMP INPUT'!O6","v":0},6,{"$f":"IF('BMP INPUT'!O4<0.4,0.4,'BMP INPUT'!O4)","v":0.4},0,0]
[null,"Other:",{"$f":"'BMP INPUT'!O9","v":0},"#2",{"$f":"'BMP INPUT'!O11","v":0},{"$f":"'BMP INPUT'!O12","v":0},6,{"$f":"IF('BMP INPUT'!O10<0.4,0.4,'BMP INPUT'!O10)","v":0.4},0,0]
[null,"Other:",{"$f":"'BMP INPUT'!O15","v":0},"#3",{"$f":"'BMP INPUT'!O17","v":0},{"$f":"'BMP INPUT'!O18","v":0},6,{"$f":"IF('BMP INPUT'!O16<0.4,0.4,'BMP INPUT'!O16)","v":0.4},0,0]
[null,"TOTAL",null,null,null,null,null,null,null,{"$f":"SUM(J5:J19)","v":77657.5}]

{"sheet":"REF_Curve Numbers","index":7,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Curve Numbers"]
[]
["Impervious Cover (pavement/gravel/rooftop)",98]
["Open Water (detention pond footprint)",100]
["Pasture/Grasslands (Type A)",42,"(revised to CN=42 --> minimum CN allowed is 42)"]
["Pasture/Grasslands (Type B)",61]
["Pasture/Grasslands (Type C)",74]
["Meadow (Type A)",42,"(revised to CN=42 --> minimum CN allowed is 42)"]
["Meadow (Type B)",58]
["Meadow (Type C)",71]
["Brush (Type A)",42,"(revised to CN=42 --> minimum CN allowed is 42)"]
["Brush (Type B)",48]
["Brush (Type C)",65]
["Woods (Type A)",42,"(revised to CN=42 --> minimum CN allowed is 42)"]
["Woods (Type B)",58]
["Woods (Type C)",72]
["Row Crops (Type A)",65]
["Row Crops (Type B)",75,"(capped at 75 - maximum CN for undeveloped conditions = 75)"]
["Row Crops (Type C)",75,"(capped at 75 - maximum CN for undeveloped conditions = 75)"]
["Manicured Lawn Areas (Type A)",42,"(revised to CN=42 --> minimum CN allowed is 42)"]
["Manicured Lawn Areas (Type B)",61]
["Manicured Lawn Areas (Type C)",74]
["Naturalized Pervious Areas (Type A)",42,"(revised to CN=42 --> minimum CN allowed is 42)"]
["Naturalized Pervious Areas (Type B)",58]
["Naturalized Pervious Areas (Type C)",71]
["Residential Districts (avg lot size) - 1/8 acre or less (Type A)",77]
["Residential Districts (avg lot size) - 1/8 acre or less (Type B)",85]
["Residential Districts (avg lot size) - 1/8 acre or less (Type C)",90]
["Residential Districts (avg lot size) - 1/4 acre (Type A)",61]
["Residential Districts (avg lot size) - 1/4 acre (Type B)",75]
["Residential Districts (avg lot size) - 1/4 acre (Type C)",83]
["Residential Districts (avg lot size) - 1/3 acre (Type A)",57]
["Residential Districts (avg lot size) - 1/3 acre (Type B)",72]
["Residential Districts (avg lot size) - 1/3 acre (Type C)",81]
["Residential Districts (avg lot size) - 1/2 acre (Type A)",54]
["Residential Districts (avg lot size) - 1/2 acre (Type B)",70]
["Residential Districts (avg lot size) - 1/2 acre (Type C)",80]
["Residential Districts (avg lot size) - 1 acre (Type A)",51]
["Residential Districts (avg lot size) - 1 acre (Type B)",68]
["Residential Districts (avg lot size) - 1 acre (Type C)",79]
["Residential Districts (avg lot size) - 2 acre (Type A)",46]
["Residential Districts (avg lot size) - 2 acre (Type B)",65]
["Residential Districts (avg lot size) - 2 acre (Type C)",77]

{"sheet":"REF_Runoff Coefficients","index":8,"n_rows":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Runoff Coefficients"]
[]
["Impervious Cover (pavement/gravel/rooftop)",0.9]
["Open Water (detention pond footprint)",1]
["Pasture/Grasslands (Type A)",0.1]
["Pasture/Grasslands (Type B)",0.15]
["Pasture/Grasslands (Type C)",0.2]
["Meadow (Type A)",0.1]
["Meadow (Type B)",0.15]
["Meadow (Type C)",0.2]
["Brush (Type A)",0.1]
["Brush (Type B)",0.15]
["Brush (Type C)",0.2]
["Woods (Type A)",0.1]
["Woods (Type B)",0.15]
["Woods (Type C)",0.2]
["Row Crops (Type A)",0.15]
["Row Crops (Type B)",0.2]
["Row Crops (Type C)",0.25]
["Manicured Lawn Areas (Type A)",0.15]
["Manicured Lawn Areas (Type B)",0.2]
["Manicured Lawn Areas (Type C)",0.25]
["Naturalized Pervious Areas (Type A)",0.1]
["Naturalized Pervious Areas (Type B)",0.15]
["Naturalized Pervious Areas (Type C)",0.2]
["Residential Districts (avg lot size) - 1/8 acre or less (Type A)",0.5]
["Residential Districts (avg lot size) - 1/8 acre or less (Type B)",0.6]
["Residential Districts (avg lot size) - 1/8 acre or less (Type C)",0.7]
["Residential Districts (avg lot size) - 1/4 acre (Type A)",0.4]
["Residential Districts (avg lot size) - 1/4 acre (Type B)",0.45]
["Residential Districts (avg lot size) - 1/4 acre (Type C)",0.5]
["Residential Districts (avg lot size) - 1/3 acre (Type A)",0.35]
["Residential Districts (avg lot size) - 1/3 acre (Type B)",0.4]
["Residential Districts (avg lot size) - 1/3 acre (Type C)",0.45]
["Residential Districts (avg lot size) - 1/2 acre (Type A)",0.3]
["Residential Districts (avg lot size) - 1/2 acre (Type B)",0.35]
["Residential Districts (avg lot size) - 1/2 acre (Type C)",0.4]
["Residential Districts (avg lot size) - 1 acre (Type A)",0.25]
["Residential Districts (avg lot size) - 1 acre (Type B)",0.3]
["Residential Districts (avg lot size) - 1 acre (Type C)",0.35]
["Residential Districts (avg lot size) - 2 acre (Type A)",0.25]
["Residential Districts (avg lot size) - 2 acre (Type B)",0.3]
["Residential Districts (avg lot size) - 2 acre (Type C)",0.35]

{"sheet":"REF_Time of Concentration","index":9,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Segment Description"]
[]
["Sheet Flow",0.48]
["Waterway",1.2]
["Small Tributary",2.1]