{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Intro","Inlet Management","Inlet Pictures","Street Inlet","Area Inlet"],"not_rendered":{"charts":0,"images":34,"macros":1,"external_links":0,"defined_names":239,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,1,1,9],[0,1,0,9],[30,14,34,21]]}
[" ",null,null,null,null,null,null,null,null,null,null,"Worksheet Protected"]
[null,null,null,null,null,null,null,null,null,null,null,"Workbook Protected"]
[null,null,null,null,null,"          STREET AND INLET HYDRAULICS WORKBOOK"]
[null,null,null,null,null,"MHFD-Inlet, Version 6.00 (August 2025)"]
[null,null,null,null,null,"Mile High Flood District"]
[null,null,null,null,null,"Denver, Colorado"]
[null,null,null,null,null,"www.mhfd.org"]
[]
[null,"Purpose:","This workbook can be used to size a variety of inlets based on the design peak flow, "]
[null,null,"allowable spread, and depth in a street or swale."]
[]
[null,"Function:","1.  To calculate allowable half-street capacity based on allowable depth and spread."]
[]
[null,null,"2.  To determine the inlet capacity for selected inlet types."]
[]
[null,null,"3.  To manage inlet information and connect inlets in series to account for bypass flow."]
[]
[]
[null,"Content:","The workbook consists of the following sheets:"]
[]
[null,"Inlet Management","This worksheet is used to add new street and area inlets by creating new Inlet [#] worksheets with "]
[null,null,"specified names. It can also be used to re-organize inlets with the rename, move, and delete buttons"]
[null,null,"in order to connect inlets in series so that bypass flow from an upstream inlet is added to flow for"]
[null,null,"the next downstream inlet. Peak flows generated from the MHFD-Rational workbook "]
[null,null,"(or other methods) are entered on this worksheet. "]
[]
[null,"Inlet [#]","Inlet [#] sheets are created each time the user adds a new inlet on the Inlet Management sheet."]
[null,null,"The Inlet [#] sheets calculate allowable half-street capacity or grass channel capacity based on"]
[null,null,"allowable depth and allowable spread for the minor and major storm events.  "]
[null,null,"This is also where the user selects an inlet type and calculates the capacity of that inlet."]
[]
[null,"Inlet Pictures","Contains a library of photographs of the various types of inlets contained in MHFD-Inlet and "]
[null,null,"referenced in the USDCM."]
[]
[null,"Acknowledgements:","Spreadsheet Development Team:"]
[null,null,"Ken A. MacKenzie, P.E., Holly Piza, P.E., Chris Carandang"]
[null,null,"Mile High Flood District"]
[]
[null,null,"Derek N. Rapp, P.E."]
[null,null,"Peak Stormwater Engineering, LLC"]
[]
[null,null,"Dr. James C.Y. Guo, Ph.D., P.E."]
[null,null,"Professor, Department of Civil Engineering, University of Colorado at Denver"]
[null,null," "]
[null,"Accessibility:","MHFD is committed to ensuring equitable access design resources for all users, regardless of ability. "]
[null,null,"If you experience any issues, need assistance accessing information, or have comments on how we "]
[null,null,"can enhance accessibility to our resources, please contact us by email at questions@mhfd.org "]
[null,null,"or by phone at 303-455-6277."]
[]
[null,"Comments?","Direct all comments regarding this spreadsheet workbook to:",null,null,null,null,"MHFD E-mail"]
[null,"Revisions?","Check for revised versions of this or any other workbook at:",null,null,null,null,"Downloads"]

{"sheet":"Inlet Management","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,2,2,2]]}
[null,null,{"$f":"Intro!F4","v":"MHFD-Inlet, Version 6.00 (August 2025)"}]
[null,null,"INLET MANAGEMENT"]
[]
[]
[null,"Project:"]
[null,"Minor:"]
[null,"Major:"]
[null,null,"Worksheet Protected"]
[]
[null,null,"INLET NAME","No Bypass Flow Received"]
[null,null,"Inlet Application (Street or Area)"]
[null,null,"Hydraulic Condition"]
[null,null,"Inlet Type"]
[null,null,"Number of Inlet Units"]
[]
[null,"USER-DEFINED INPUT"]
[null,null,"User-Defined Peak Flows"]
[null,null,"Minor Peak Flow, Q (cfs)"]
[null,null,"Major Peak Flow, Q (cfs)"]
[]
[null,null,"Bypass (Carry-Over) Flow from Upstream              Inlets must be organized from upstream (left) to downstream (right) in order for bypass flows to be linked."]
[null,null,"Receive Bypass Flow from:"]
[null,null,"Bypass Flow Description (Optional):"]
[null,null,"Minor Bypass Flow Received, Qb (cfs)"]
[null,null,"Major Bypass Flow Received, Qb (cfs)"]
[]
[]
[null,"CALCULATED OUTPUT"]
[]
[null,null,"Minor Total Design Peak Flow, Q (cfs)"]
[null,null,"Major Total Design Peak Flow, Q (cfs)"]
[null,null,"Minor Inlet Interception Capacity, Qa (cfs)"]
[null,null,"Major Inlet Interception Capacity, Qa (cfs)"]
[null,null,"Minor Flow Bypassed Downstream, Qb (cfs)"]
[null,null,"Major Flow Bypassed Downstream, Qb (cfs)"]
[null,null,"Minor Flow Capture Percentage, C%"]
[null,null,"Major Flow Capture Percentage, C%"]

{"sheet":"Inlet Pictures","index":2,"n_rows":150,"n_cols":12,"rows_kept":150,"cut":false,"hidden":false,"merged":[[1,0,1,6]]}
[null,null,null,null,null,null,null,null,null,null,null,"Worksheet Protected"]
["INLET PICTURES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CDOT Type R Curb Opening",null,"Denver No. 14 Curb Opening",null,"Colorado Springs D-10-R",null,"CDOT/Denver 13 Valley Grate"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CDOT/Denver 13 Combination",null,"Denver No. 16 Combination",null,"Wheat Ridge Combination Inlet",null,"Denver No. 16 Valley Grate"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Directional Cast Vane Grate",null,"Directional 30-Degree Bar Grate (courtesy HEC-22)",null,"Directional 45-Degree Bar Grate",null,"Reticuline Riveted Grate"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1-7/8\" Bar Grate, Crossbars @ 8\"",null,"1-7/8\" Bar Grate, Crossbars @ 4\" (courtesy HEC-22)",null,"1-1/8 in. Bar Grate, Crossbars @ 8 in. (courtesy HEC-22)",null,"Slotted Inlet Parallel to Flow"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CDOT Type C Grate (Close Mesh)",null,"CDOT Type C Grate",null,"CDOT Type C Inlet",null,"CDOT Type C Inlet in Depression"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CDOT Type D Inlet In Series (Flat & Depressed)",null,"CDOT Type D Inlet In Series (10° Incline & Depressed)",null,"CDOT Type D Inlet In Series (20° Incline & Depressed)",null,"CDOT Type D Inlet In Series (30° Incline & Depressed)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CDOT Type D Inlet Parallel (Flat & Depressed)",null,"CDOT Type D Inlet Parallel (10° Incline & Depressed)",null,"CDOT Type D Inlet Parallel (20° Incline & Depressed)",null,"CDOT Type D Inlet Parallel (30° Incline & Depressed)"]

{"sheet":"Street Inlet","index":3,"n_rows":1176,"n_cols":116,"rows_kept":1176,"cut":false,"hidden":true,"merged":[[150,1,150,5],[166,7,170,11],[71,50,71,52],[75,1,75,5],[0,1,0,5]]}
[null,{"$f":"Intro!F4","v":"MHFD-Inlet, Version 6.00 (August 2025)"},null,null,null,null,null,null,null,null,null,"Worksheet Protected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Street Capacity Section (Hidden Cells)"]
[null,"ALLOWABLE CAPACITY FOR ONE-HALF OF STREET (Minor & Major Storm)"]
[null,"                                                 (Based on Regulated Criteria for Maximum Allowable Flow Depth and Spread)"]
["Project:",{"$f":"IF(IM_Project=\"\",\"\",IM_Project)","v":""}]
["Inlet ID:",null,null,null,null,null,null,null,null,null,null,"Quick Links"]
[null,null,null,null,null,null,null,null,null,null,null,"INTRO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QAllow Count",{"$f":"COUNTA(D19:D25,D28:E29)","v":1},"Cells D19:D25 and D28:E29"]
[null,null,null,null,null,null,null,null,null,null,null,"Inlet Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Input Complete",{"$f":"IF(AND(ISNUMBER(Hcurb),ISNUMBER(Tcrown),ISNUMBER(Wgutter),ISNUMBER(Sx),ISNUMBER(Sw),ISNUMBER(So),ISNUMBER(Nstreet),ISNUMBER(Minor_Tmax),ISNUMBER(Minor_Dmax)),TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Input Complete",{"$f":"IF(AND(ISNUMBER(Hcurb),ISNUMBER(Tcrown),ISNUMBER(Wgutter),ISNUMBER(Sx),ISNUMBER(Sw),ISNUMBER(So),ISNUMBER(Nstreet),ISNUMBER(Major_Tmax),ISNUMBER(Major_Dmax)),TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Design Qpeak",{"$f":"#REF!","v":{"$error":"#REF!"}},"Q-Peak'!H48 is changed to reference Inlet Management sheet when new inlet is added"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Design Qpeak",{"$f":"#REF!","v":{"$error":"#REF!"}},"Q-Peak'!I48 is changed to reference Inlet Management sheet when new inlet is added"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Storm Warning Message"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Storm Warning Message"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor CheckBox for Flow Depth at Crown",false]
[null,"Gutter Geometry:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major CheckBox for Flow Depth at Crown",false]
[null,"Maximum Allowable Width for Spread Behind Curb","TBACK =",null,"ft"]
[null,"Side Slope Behind Curb (leave blank for no conveyance credit behind curb)","SBACK =",null,"ft/ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optional:  Set d-MAX to Limit V*d Product"]
[{"$f":"IF(Nback=\"\",\"\",IF(OR(Nback<0.012,Nback>0.02),\"Warning 01\",\"\"))","v":""},"Manning's Roughness Behind Curb (typically between 0.012 and 0.020)","nBACK =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vd Product Boolean",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Allowable Gutter Depth Warning"]
[null,"Height of Curb at Gutter Flow Line","HCURB =",null,"inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Storm Max Allowable Depth (Temp Storage)",null,"inches"]
[null,"Distance from Curb Face to Street Crown","TCROWN =",null,"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Storm Max Allowable Depth (Temp Storage)",null,"inches"]
[null,"Gutter Width","W =",null,"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor User-Defined Vd Product"]
[null,"Street Transverse Slope","SX =",null,"ft/ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major User-Defined Vd Product"]
[null,"Gutter Cross Slope (typically 2 inches over 24 inches or 0.083 ft/ft)","SW =",8.3000000000000004E-2,"ft/ft"]
[null,"Street Longitudinal Slope - Enter 0 for sump condition","SO =",null,"ft/ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bypass MHFD Safety Factor"]
[{"$f":"IF(Nstreet=\"\",\"\",IF(OR(Nstreet<0.012,Nstreet>0.02),\"Warning 01\",\"\"))","v":""},"Manning's Roughness for Street Section (typically between 0.012 and 0.020)","nSTREET =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Safety Factor Override Boolean",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Safety Factor Warning"]
[null,null,null,"Minor Storm","Major 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,null,null,null,null,null,null,null,null,null,null,null,"Minor Storm Flow based on Allowable Depth",null,"cfs"]
[null,"Max. Allowable Spread for Minor & Major Storm","TMAX =",null,null,"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Storm Flow based on Allowable Depth",null,"cfs"]
[{"$f":"IF(Hcurb-Minor_Dmax<0,\"Warning 02\",\"\")","v":""},"Max. Allowable Depth at Gutter Flowline for Minor & Major Storm","dMAX =",null,null,"inches"]
[null,{"$f":"IF(OR(So=\"\",So>0),\"Allow Flow Depth at Street Crown (check box for yes, leave blank for no)\",\"Check boxes are not applicable in SUMP conditions\")","v":"Allow Flow Depth at Street Crown (check box for yes, leave blank for no)"},null,null,null,null,{"$f":"IF(VdProductBoolean=FALSE,\"\",\"   Click button again to reset d-MAX back to original values\")","v":""}]
[]
[null,"Maximum Capacity for 1/2 Street based On Allowable Spread",null,"Minor Storm","Major Storm"]
[null,"Water Depth without Gutter Depression (T * Sx * 12)","y =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",Minor_Tmax*Sx*12)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",Major_Tmax*Sx*12)","v":""},"inches"]
[null,"Vertical Depth between Gutter Lip and Gutter Flowline (W * Sw * 12)","dC =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",Wgutter*Sw*12)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",Wgutter*Sw*12)","v":""},"inches"]
[null,"Gutter Depression (dC - (W * Sx * 12))","a =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",D34-(Wgutter*Sx*12))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",E34-(Wgutter*Sx*12))","v":""},"inches"]
[null,"Water Depth at Gutter Flowline (y + a)","d =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",D33+Minor_a)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",E33+E35)","v":""},"inches"]
[null,"Allowable Spread for Discharge outside the Gutter Section (T - W)","TX =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(Minor_Tmax<=Wgutter,0,Minor_Tmax-Wgutter))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(Major_Tmax<=Wgutter,0,Major_Tmax-Wgutter))","v":""},"ft"]
[null,"Gutter Flow to Design Flow Ratio by FHWA HEC-22 method (Eq. 7-7)","EO =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(Minor_Tmax<=Wgutter,1,\n(1/((1+((Sw/Sx)/((1+((Sw/Sx)/((Minor_Tmax/Wgutter)-1)))^(8/3)-1)))))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(Major_Tmax<=Wgutter,1,\n(1/((1+((Sw/Sx)/((1+((Sw/Sx)/((Major_Tmax/Wgutter)-1)))^(8/3)-1)))))))","v":""}]
[null,"Discharge outside the Gutter Section, carried in Section TX","QX =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(Minor_Tmax<=Wgutter,0,\n0.56/Nstreet*Sx^(5/3)*So^0.5*D37^(8/3)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(Major_Tmax<=Wgutter,0,\n0.56/Nstreet*Sx^(5/3)*So^0.5*E37^(8/3)))","v":""},"cfs"]
[null,"Discharge within the Gutter Section (QT - QX - QBACK)","QW =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D42=\"SUMP\",0,\nIF(Minor_Tmax<=Wgutter,0.56/Nstreet*Sw^(5/3)*So^0.5*Minor_Tmax^(8/3),\n(D42-D39-D41))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(E42=\"SUMP\",0,\nIF(Major_Tmax<=Wgutter,0.56/Nstreet*Sw^(5/3)*So^0.5*Major_Tmax^(8/3),\n(E42-E39-E41))))","v":""},"cfs"]
[null,"Discharge Behind the Curb (e.g., sidewalk, driveways, & lawns)","QBACK =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",\nIF(OR(Tback=\"\",Sback=\"\",Nback=\"\"),0,IF(D36<=Hcurb,0,\nIF(Tback>=(D36-Hcurb)/12/Sback,\n0.56/Nback*Sback^(5/3)*So^0.5*((D36-Hcurb)/12/Sback)^(8/3),\n0.56/Nback*Sback^(5/3)*So^0.5*(((D36-Hcurb)/12/Sback)^(8/3)-((D36-Hcurb)/12/Sback-Tback)^(8/3))))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",\nIF(OR(Tback=\"\",Sback=\"\",Nback=\"\"),0,IF(E36<=Hcurb,0,\nIF(Tback>=(E36-Hcurb)/12/Sback,\n0.56/Nback*Sback^(5/3)*So^0.5*((E36-Hcurb)/12/Sback)^(8/3),\n0.56/Nback*Sback^(5/3)*So^0.5*(((E36-Hcurb)/12/Sback)^(8/3)-((E36-Hcurb)/12/Sback-Tback)^(8/3))))))","v":""},"cfs"]
[null,"Maximum Flow Based On Allowable Spread","QT =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(So=0,\"SUMP\",\nIF(Minor_Tmax<=Wgutter,0.56/Nstreet*Sw^(5/3)*So^0.5*Minor_Tmax^(8/3),\n(D39/(1-D38))+D41)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(So=0,\"SUMP\",\nIF(Major_Tmax<=Wgutter,0.56/Nstreet*Sw^(5/3)*So^0.5*Major_Tmax^(8/3),\n(E39/(1-E38))+E41)))","v":""},"cfs"]
[null,"Flow Velocity within the Gutter Section","V =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",\nD40/((((D36/12)*(D36/12/Sw))/2)-(((D36/12-Wgutter*Sw)*(D36/12/Sw-Wgutter))/2)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",\nE40/((((E36/12)*(E36/12/Sw))/2)-(((E36/12-Wgutter*Sw)*(E36/12/Sw-Wgutter))/2)))","v":""},"fps"]
[null,"V*d Product: Flow Velocity times Gutter Flowline Depth","V*d =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",D43*D36/12)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",E43*E36/12)","v":""}]
[]
[null,"Maximum Capacity for 1/2 Street based on Allowable Depth",null,"Minor Storm","Major Storm"]
[null,"Theoretical Water Spread","TTH =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(Minor_Dmax>D35,(Minor_Dmax-D35)/12/Sx,Minor_Dmax/12/Sw))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(Major_Dmax>E35,(Major_Dmax-E35)/12/Sx,Major_Dmax/12/Sw))","v":""},"ft"]
[null,"Theoretical Spread for Discharge outside the Gutter Section (T - W)","TX TH =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D47<=Wgutter,0,D47-Wgutter))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(E47<=Wgutter,0,E47-Wgutter))","v":""},"ft"]
[null,"Gutter Flow to Design Flow Ratio by FHWA HEC-22 method (Eq. 7-7)","EO =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D47<=Wgutter,1,\n(1/((1+((Sw/Sx)/((1+((Sw/Sx)/((D47/Wgutter)-1)))^(8/3)-1)))))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(E47<=Wgutter,1,\n(1/((1+((Sw/Sx)/((1+((Sw/Sx)/((E47/Wgutter)-1)))^(8/3)-1)))))))","v":""}]
[null,"Theoretical Discharge outside the Gutter Section, carried in Section TX TH","QX TH =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D47<=Wgutter,0,\n0.56/Nstreet*Sx^(5/3)*So^0.5*D48^(8/3)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(E47<=Wgutter,0,\n0.56/Nstreet*Sx^(5/3)*So^0.5*E48^(8/3)))","v":""},"cfs"]
[null,"Actual Discharge outside the Gutter Section, (limited by distance TCROWN)","QX =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D47<=Wgutter,0,\n0.56/Nstreet*Sx^(5/3)*So^0.5*(D48^(8/3)-MAX(D47-Tcrown,0)^(8/3))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(E47<=Wgutter,0,\n0.56/Nstreet*Sx^(5/3)*So^0.5*(E48^(8/3)-MAX(E47-Tcrown,0)^(8/3))))","v":""},"cfs"]
[null,"Discharge within the Gutter Section (Qd - QX)","QW =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(So=0,0,\nIF(D47<=Wgutter,0.56/Nstreet*Sw^(5/3)*So^0.5*D47^(8/3),\n(D50/(1-D49)-D50))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(So=0,0,\nIF(E47<=Wgutter,0.56/Nstreet*Sw^(5/3)*So^0.5*E47^(8/3),\n(E50/(1-E49)-E50))))","v":""},"cfs"]
[null,"Discharge Behind the Curb (e.g., sidewalk, driveways, & lawns)","QBACK =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",\nIF(OR(Tback=\"\",Sback=\"\",Nback=\"\"),0,IF(Minor_Dmax<=Hcurb,0,\nIF(Tback>=(Minor_Dmax-Hcurb)/12/Sback,\n0.56/Nback*Sback^(5/3)*So^0.5*((Minor_Dmax-Hcurb)/12/Sback)^(8/3),\n0.56/Nback*Sback^(5/3)*So^0.5*(((Minor_Dmax-Hcurb)/12/Sback)^(8/3)-((Minor_Dmax-Hcurb)/12/Sback-Tback)^(8/3))))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",\nIF(OR(Tback=\"\",Sback=\"\",Nback=\"\"),0,IF(Major_Dmax<=Hcurb,0,\nIF(Tback>=(Major_Dmax-Hcurb)/12/Sback,\n0.56/Nback*Sback^(5/3)*So^0.5*((Major_Dmax-Hcurb)/12/Sback)^(8/3),\n0.56/Nback*Sback^(5/3)*So^0.5*(((Major_Dmax-Hcurb)/12/Sback)^(8/3)-((Major_Dmax-Hcurb)/12/Sback-Tback)^(8/3))))))","v":""},"cfs"]
[null,"Total Discharge for Major & Minor Storm (Pre-Safety Factor)","Q =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(So=0,\"SUMP\",\nIF(D47<=Wgutter,0.56/Nstreet*Sw^(5/3)*So^0.5*D47^(8/3),\nIF(D47>Tcrown,D51+D52+D53,\nD50/(1-D49)+D53))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(So=0,\"SUMP\",\nIF(E47<=Wgutter,0.56/Nstreet*Sw^(5/3)*So^0.5*E47^(8/3),\nIF(E47>Tcrown,E51+E52+E53,\nE50/(1-E49)+E53))))","v":""},"cfs"]
[null,"Average Flow Velocity Within the Gutter Section","V =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",\nD52/((((Minor_Dmax/12)*(Minor_Dmax/12/Sw))/2)-(((Minor_Dmax/12-Wgutter*Sw)*(Minor_Dmax/12/Sw-Wgutter))/2)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",\nE52/((((Major_Dmax/12)*(Major_Dmax/12/Sw))/2)-(((Major_Dmax/12-Wgutter*Sw)*(Major_Dmax/12/Sw-Wgutter))/2)))","v":""},"fps"]
[null,"V*d Product: Flow Velocity Times Gutter Flowline Depth","V*d =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",D55*Minor_Dmax/12)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",E55*Major_Dmax/12)","v":""}]
[null,"Slope-Based Safety Factor for Minor/Major Storm depth reduction, d > 6\"","R =",{"$f":"IF(OR(Minor_Input_Complete_QAllow=FALSE,Major_Input_Complete_QAllow=FALSE),\"\",IF(So=0,\"SUMP\",Minor_FlowBasedOnAllowableDepth/D54))","v":""},{"$f":"IF(OR(Minor_Input_Complete_QAllow=FALSE,Major_Input_Complete_QAllow=FALSE),\"\",IF(So=0,\"SUMP\",Major_FlowBasedOnAllowableDepth/E54))","v":""}]
[null,{"$f":"IF(B61=\"WARNING - MHFD SAFETY FACTOR HAS BEEN BYPASSED\",\"Max Flow based on Allowable Depth (NO SAFETY FACTOR)\",\nIF(B61=\"NOTE:  Maximum allowable gutter depth based on user-defined limits for V*d product\", \"Max Flow based on Allowable Depth (User-Defined Limits for V*d)\",\n\"Max Flow based on Allowable Depth (Safety Factor Applied)\"))","v":"Max Flow based on Allowable Depth (Safety Factor Applied)"},"Qd =",{"$f":"IF(OR(Minor_Input_Complete_QAllow=FALSE,Major_Input_Complete_QAllow=FALSE),\"\",IF(So=0,\"SUMP\",Minor_FlowBasedOnAllowableDepth))","v":""},{"$f":"IF(OR(Minor_Input_Complete_QAllow=FALSE,Major_Input_Complete_QAllow=FALSE),\"\",IF(So=0,\"SUMP\",Major_FlowBasedOnAllowableDepth))","v":""},"cfs"]
[null,{"$f":"IF(B61=\"WARNING - MHFD SAFETY FACTOR HAS BEEN BYPASSED\",\"Resultant Flow Depth at Gutter Flowline (NO SAFETY FACTOR)\",\nIF(B61=\"NOTE:  Maximum allowable gutter depth based on user-defined limits for V*d product\", \"Resultant Flow Depth at Gutter Flowline (User-Defined Limits for V*d)\",\n\"Resultant Flow Depth at Gutter Flowline (Safety Factor Applied)\"))","v":"Resultant Flow Depth at Gutter Flowline (Safety Factor Applied)"},"d =",null,null,"inches"]
[null,{"$f":"IF(B61=\"WARNING - MHFD SAFETY FACTOR HAS BEEN BYPASSED\",\"Resultant Flow Depth at Street Crown (NO SAFETY FACTOR)\",\nIF(B61=\"NOTE:  Maximum allowable gutter depth based on user-defined limits for V*d product\", \"Resultant Flow Depth at Street Crown (User-Defined Limits for V*d)\",\n\"Resultant Flow Depth at Street Crown (Safety Factor Applied)\"))","v":"Resultant Flow Depth at Street Crown (Safety Factor Applied)"},"dCROWN =",null,null,"inches"]
[null,null,{"$f":"IF(SafetyFactorWarning=\"\",IF(MaxGutterDepthWarning=\"\",\"\",MaxGutterDepthWarning),SafetyFactorWarning)","v":""}]
[null,{"$f":"IF(D63=\"\",\"\",IF(D63=\"SUMP\",\"MINOR STORM Allowable Capacity is not applicable to Sump Condition\",IF(D63=D58,\"MINOR STORM Allowable Capacity is based on Depth Criterion\", \"MINOR STORM Allowable Capacity is based on Spread Criterion\")))","v":""},null,"Minor Storm","Major Storm"]
[null,{"$f":"IF(E63=\"\",\"\",IF(E63=\"SUMP\",\"MAJOR STORM Allowable Capacity is not applicable to Sump Condition\",IF(E63=E58, \"MAJOR STORM Allowable Capacity is based on Depth Criterion\",\"MAJOR STORM Allowable Capacity is based on Spread Criterion\")))","v":""},"Qallow =",{"$f":"IF(OR(Minor_Input_Complete_QAllow=FALSE,Major_Input_Complete_QAllow=FALSE),\"\",IF(So=0,\"SUMP\",IF(AU13=FALSE,MIN(D58,D42),D58)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_QAllow=FALSE,Major_Input_Complete_QAllow=FALSE),\"\",IF(So=0,\"SUMP\",IF(AU14=FALSE,MIN(E58,E42),E58)))","v":""},"cfs"]
[null,{"$f":"IF(MinorStormWarningMessage=\"\",\"\",MinorStormWarningMessage)","v":""}]
[null,{"$f":"IF(MajorStormWarningMessage=\"\",\"\",MajorStormWarningMessage)","v":""},null,null,null,null,{"$f":"IF(SafetyFactorBoolean=FALSE,\"\",\"   Click button again to re-apply MHFD Safety Factor\")","v":""}]
[null,{"$f":"IF(AND(A17=\"\",A25=\"\"),\"\",\"Warning 01:  Manning's n-value does not meet the USDCM recommended design range.\")","v":""}]
[null,{"$f":"IF(A29=\"\",\"\",IF(Hcurb-Minor_Dmax<0,\"Warning 02:  Max Allowable Depth for Minor Storm is greater than the Curb Height.\",\"\"))","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On-Grade Section (Hidden Cells)",null,null,null,null,"Clogging Coefficients"]
[null,"                           INLET ON A CONTINUOUS GRADE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor","Major",null,null,"Number","Grate","Curb"]
[null,null,{"$f":"Intro!F4","v":"MHFD-Inlet, Version 6.00 (August 2025)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check if user input is complete:",{"$f":"IF(COUNTA(D90:D95)=6,TRUE, FALSE)","v":false},{"$f":"IF(COUNTA(D90:D93,E94:E95)=6,TRUE, FALSE)","v":false},null,null,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1.5,1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1.75,1.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,1.88,1.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,1.94,1.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1.97,1.33]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1.98,1.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,1.99,1.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,2,1.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2,1.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,2,1.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OnGrade Inlet - Default Input Table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INLET_TYPE","alocal","Lo G","Wo G","Cw  G","Co G","Nw G","No G","Cm G","Lo C","Hvert C","Hthroat C","Theta C","Cw C","Co C","Nw C","No C","Cm C","K Comb","INLET_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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CDOT Type R Curb Opening",{"$f":"IF(Hcurb>9,0,6+3-Hcurb)","v":9},5,"N/A","N/A","N/A","N/A","N/A","N/A",5,{"$f":"IF(Hcurb>9,6,Hcurb+AU87-3)","v":6},{"$f":"BD87","v":6},63.4,3.6,0.67,1,1,0.93,"N/A","CDOT Type R Curb Opening"]
[null,"Design Information (Input)",null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"CDOT/Denver 13 Valley Grate",2,3,1.73,3.3,0.6,0.7,0.43,0.93,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.37,"CDOT/Denver 13 Valley Grate"]
[null,"Type of Inlet","Type =",{"$f":"IF(OG_InletType=\"\",\"\",OG_InletType)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"CDOT/Denver 13 Combination",2,3,1.73,3.3,0.6,0.7,0.43,0.93,3,6.5,5.25,0,3.7,0.66,1,1,0.86,0.37,"CDOT/Denver 13 Combination"]
[null,"Local Depression (additional to continuous gutter depression 'a')","aLOCAL =",null,{"$f":"IF(D90=\"\",\"\",D90)","v":""},"inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"CDOT Type C Grate",0,2.92,2.92,2.41,0.67,0.84,0.7,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","CDOT Type C Grate"]
[null,"Total Number of Units in the Inlet (Grate or Curb Opening)","No =",null,{"$f":"IF(D91=\"\",\"\",D91)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Denver No. 14 Curb Opening",3,6,"N/A","N/A","N/A","N/A","N/A","N/A",6,6,6,63.4,3.6,0.67,1,1,0.93,"N/A","Denver No. 14 Curb Opening"]
[null,"Length of a Single Unit Inlet (Grate or Curb Opening)","Lo =",null,{"$f":"IF(D92=\"\",\"\",D92)","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Denver No. 16 Combination",2,3,1.73,3.6,0.6,0.73,0.31,0.9,3,6.5,5.25,0,3.7,0.66,1,1,0.86,0.21,"Denver No. 16 Combination"]
[null,"Width of a Unit Grate (cannot be greater than W, Gutter Width) ","Wo =",null,{"$f":"IF(D93=\"\",\"\",D93)","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Denver No. 16 Valley Grate",2,3,1.73,3.6,0.6,0.73,0.31,0.9,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.21,"Denver No. 16 Valley Grate"]
[null,"Clogging Factor for a Single Unit Grate (typical min. value = 0.5)","Cf (G) =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Directional Cast Vane Grate",0,null,null,3,0.67,0.47,0.35,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.21,"Directional Cast Vane Grate"]
[null,"Clogging Factor for a Single Unit Curb Opening (typical min. value = 0.1)","Cf (C) =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Directional 45-Degree Bar Grate",0,null,null,3,0.67,0.36,0.2,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.21,"Directional 45-Degree Bar Grate"]
[null,{"$f":"IF(OG_Minor_Qo=\"\",\"Street Hydraulics\",\nIF(OG_Minor_Qo<=Minor_Qallow,\nIF(OG_Major_Qo<=Major_Qallow,\"Street Hydraulics: OK - Q < Allowable Street Capacity'\",\n\"Street Hydraulics: WARNING: Q > ALLOWABLE Q FOR MAJOR STORM\"),\nIF(OG_Major_Qo>D63,\"Street Hydraulics: WARNING: Q > ALLOWABLE Q FOR MINOR & MAJOR STORM\",\n\"Street Hydraulics: WARNING: Q > ALLOWABLE Q FOR MINOR STORM'\")))","v":"Street Hydraulics"},null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Directional 30-Degree Bar Grate",0,null,null,3,0.67,0.47,0.34,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.21,"Directional 30-Degree Bar Grate"]
[null,"Design Discharge for Half of Street (from Inlet Management)","Qo =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF(AU9=\"\",\"\",AU9))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(AU10=\"\",\"\",AU10))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Reticuline Riveted Grate",0,null,null,3,0.67,0.72,0.8,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.21,"Reticuline Riveted Grate"]
[null,"Water Spread Width","T =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",MIN(OG_Minor_Tcalc,Tcrown))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",MIN(OG_Major_Tcalc,Tcrown))","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"1-7/8\" Bar Grate, Crossbars @ 8\"",0,null,null,3,0.67,0.76,0.9,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.37,"1-7/8\" Bar Grate, Crossbars @ 8\""]
[null,"Water Depth at Flowline (outside of local depression)","d =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",(OG_Minor_Tcalc*Sx)*12+(Wgutter*(Sw-Sx))*12)","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",(OG_Major_Tcalc*Sx)*12+(Wgutter*(Sw-Sx))*12)","v":""},"inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"1-7/8\" Bar Grate, Crossbars @ 4\"",0,null,null,3,0.67,0.72,0.8,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.37,"1-7/8\" Bar Grate, Crossbars @ 4\""]
[null,"Water Depth at Street Crown (or at TMAX)","dCROWN =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Minor_Tcalc<Tcrown,0,Sx*(OG_Minor_Tcalc-Tcrown)*12))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Major_Tcalc<Tcrown,0,Sx*(OG_Major_Tcalc-Tcrown)*12))","v":""},"inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"1-1/8\" Bar Grate, Crossbars @ 8\"",0,null,null,3,0.67,0.62,0.6,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.37,"1-1/8\" Bar Grate, Crossbars @ 8\""]
[null,"Ratio of Gutter Flow to Design Flow","Eo =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Minor_T<=Wgutter,1,\nOG_Minor_Qw/(OG_Minor_Qx+OG_Minor_Qw)))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Major_T<=Wgutter,1,\nOG_Major_Qw/(OG_Major_Qx+OG_Major_Qw)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Slotted Inlet Parallel to Flow",0,null,null,2.48,0.8,0.76,0.9,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","Slotted Inlet Parallel to Flow"]
[null,"Discharge outside the Gutter Section W, carried in Section Tx","Qx =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Minor_T<=Wgutter,0,\n0.56/Nstreet*Sx^(5/3)*So^0.5*((OG_Minor_Tcalc-Wgutter)^(8/3)-MAX(OG_Minor_Tcalc-Tcrown,0)^(8/3))))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Major_T<=Wgutter,0,\n0.56/Nstreet*Sx^(5/3)*So^0.5*((OG_Major_Tcalc-Wgutter)^(8/3)-MAX(OG_Major_Tcalc-Tcrown,0)^(8/3))))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"User-Defined Combination",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User-Defined Combination"]
[null,"Discharge within the Gutter Section W","Qw =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",OG_Minor_Qo-OG_Minor_Qx-OG_Minor_Qback)","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",OG_Major_Qo-OG_Major_Qx-OG_Major_Qback)","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Colorado Springs D-10-R",4,4,"N/A","N/A","N/A","N/A","N/A","N/A",4,8,8,81,3.6,0.67,1,1,0.93,"N/A","Colorado Springs D-10-R"]
[null,"Discharge Behind the Curb Face","QBACK =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",\nIF(OR(Tback=\"\",Sback=\"\",Nback=\"\"),0,IF(OG_Minor_d<=Hcurb,0,\nIF(Tback>=(OG_Minor_d-Hcurb)/12/Sback,\n0.56/Nback*Sback^(5/3)*So^0.5*((OG_Minor_d-Hcurb)/12/Sback)^(8/3),\n0.56/Nback*Sback^(5/3)*So^0.5*(((OG_Minor_d-Hcurb)/12/Sback)^(8/3)-((OG_Minor_d-Hcurb)/12/Sback-Tback)^(8/3))))))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",\nIF(OR(Tback=\"\",Sback=\"\",Nback=\"\"),0,IF(OG_Major_d<=Hcurb,0,\nIF(Tback>=(OG_Major_d-Hcurb)/12/Sback,\n0.56/Nback*Sback^(5/3)*So^0.5*((OG_Major_d-Hcurb)/12/Sback)^(8/3),\n0.56/Nback*Sback^(5/3)*So^0.5*(((OG_Major_d-Hcurb)/12/Sback)^(8/3)-((OG_Major_d-Hcurb)/12/Sback-Tback)^(8/3))))))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Wheat Ridge Combination",2,2.75,1.37,3.6,0.67,0.64,0.65,0.97,2.88,6,5.25,0,3.7,0.66,1,1,0.86,0.21,"Wheat Ridge Combination"]
[null,"Flow Area within the Gutter Section W","AW =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",\nIF(OG_Minor_T<=Wgutter,\n(OG_Minor_d/12*OG_Minor_T)/2,\n((Sw*Wgutter)*Wgutter)/2+(OG_Minor_d/12-(Sw*Wgutter))*Wgutter))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",\nIF(OG_Major_T<=Wgutter,\n(OG_Major_d/12*OG_Major_T)/2,\n((Sw*Wgutter)*Wgutter)/2+(OG_Major_d/12-(Sw*Wgutter))*Wgutter))","v":""},"sq ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alpha","Beta","Gamma","Mu","Vo"]
[null,"Velocity within the Gutter Section W","VW =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Minor_Aw=0,0,OG_Minor_Qw/OG_Minor_Aw))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Major_Aw=0,0,OG_Major_Qw/OG_Major_Aw))","v":""},"fps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CDOT Type R Curb Opening",0,0,0,0,{"$f":"AU106+AV106*(OG_Lo*OG_No)-AW106*(OG_Lo*OG_No)^2+AX106*(OG_Lo*OG_No)^3","v":0},"Curb","*","c",1,null,null,null,null,null,null,null,null,"Street Capacity Calcs (Rows 97:107)"]
[null,"Water Depth for Design Condition","dLOCAL =",{"$f":"IF(OR(OG_Minor_Qo=\"\",OG_Minor_d=\"\"),\"\",OG_aLocal+OG_Minor_d)","v":""},{"$f":"IF(OR(OG_Major_Qo=\"\",OG_Major_d=\"\"),\"\",OG_aLocal+OG_Major_d)","v":""},"inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"CDOT/Denver 13 Valley Grate",0,0.68,0.06,2.3E-3,0,null,"*",null,2,null,null,null,null,null,null,null,"Minor","Major"]
[null,{"$f":"IF(UserDefined_OG_GrateType=\"\",\"Grate Analysis (Calculated)\",\"Analysis For Grate Type = \"&UserDefined_OG_GrateType&\" (Calculated)\")","v":"Grate Analysis (Calculated)"},null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"CDOT/Denver 13 Combination",0,0.68,0.06,2.3E-3,0,"Curb","*",null,3,null,"Grate Analysis (Calculated)",null,null,null,null,"Tcalc ="]
[null,"Total Length of Inlet Grate Opening","L =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Grate_Qa_Minor=\"N/A\",\"N/A\",OG_No*OG_Lo))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Grate_Qa_Major=\"N/A\",\"N/A\",OG_No*OG_Lo))","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"CDOT Type C Grate",2.2200000000000002,4.03,0.65,0.06,2.2200000000000002,null,"*",null,4,null,"L =",null,null,null,null,"Vs ="]
[null,"Ratio of Grate Flow to Design Flow","Eo-GRATE =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Grate_Qa_Minor=\"N/A\",\"N/A\",BF110))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Grate_Qa_Major=\"N/A\",\"N/A\",BG110))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Denver No. 14 Curb Opening",0,0,0,0,0,"Curb","*","c",5,null,"Eo-GRATE ="]
[null,"Under No-Clogging Condition",null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Denver No. 16 Combination",0,0.81499999999999995,7.3999999999999996E-2,3.0000000000000001E-3,0,null,"*",null,6,null,"Under No-Clogging Condition"]
[null,"Minimum Velocity Where Grate Splash-Over Begins","Vo =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Grate_Qa_Minor=\"N/A\",\"N/A\",BF112))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Grate_Qa_Major=\"N/A\",\"N/A\",BG112))","v":""},"fps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Denver No. 16 Valley Grate",0,0.81499999999999995,7.3999999999999996E-2,3.0000000000000001E-3,0,null,"*",null,7,null,"Vo =",null,null,null,null,"User-Defined Inlet (User Form Input Values)"]
[null,"Interception Rate of Frontal Flow","Rf =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Grate_Qa_Minor=\"N/A\",\"N/A\",BF113))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Grate_Qa_Major=\"N/A\",\"N/A\",BG113))","v":""}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Directional Cast Vane Grate",0.3,4.8499999999999996,1.31,0.15,0.3,null,null,null,8,null,"Rf =",null,null,null,null,null,"User Grate Type ="]
[null,"Interception Rate of Side Flow","Rx =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Grate_Qa_Minor=\"N/A\",\"N/A\",BF114))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Grate_Qa_Major=\"N/A\",\"N/A\",BG114))","v":""}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Directional 45-Degree Bar Grate",0.99,2.64,0.36,0.03,0.99,null,null,null,9,null,"Rx =",null,null,null,null,null,"Sweeper Boolean ="]
[null,"Interception Capacity","Qi =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Grate_Qa_Minor=\"N/A\",\"N/A\",BF115))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Grate_Qa_Major=\"N/A\",\"N/A\",BG115))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Directional 30-Degree Bar Grate",0.51,2.34,0.2,0.01,0.51,null,null,null,10,null,"Qi =",null,null,null,null,null,"User Curb Length ="]
[null,"Under Clogging Condition"," ","MINOR","MAJOR"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Reticuline Riveted Grate",0.28000000000000003,2.2799999999999998,0.18,0.01,0.28000000000000003,null,null,null,11,null,"Under Clogging Condition"]
[null,"Clogging Coefficient for Multiple-unit Grate Inlet","GrateCoeff =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Grate_Qa_Minor=\"N/A\",\"N/A\",BF117))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Grate_Qa_Major=\"N/A\",\"N/A\",BG117))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"1-7/8\" Bar Grate, Crossbars @ 8\"",2.2200000000000002,4.03,0.65,0.06,2.2200000000000002,null,null,null,12,null,"GrateCoef ="]
[null,"Clogging Factor for Multiple-unit Grate Inlet","GrateClog =","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"1-7/8\" Bar Grate, Crossbars @ 4\"",0.74,2.44,0.27,0.02,0.74,null,null,null,13,null,"GrateClog ="]
[null,"Effective (unclogged) Length of Multiple-unit Grate Inlet ","Le =","","","ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"1-1/8 in. Bar Grate, Crossbars @ 8 in.",1.76,3.12,0.45,0.03,1.76,null,null,null,14,null,"Le ="]
[null,"Minimum Velocity Where Grate Splash-Over Begins","Vo =","","","fps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Slotted Inlet Parallel to Flow",0,0,0,0,0,"Curb",null,"*",15,null,"Vo ="]
[null,"Interception Rate of Frontal Flow","Rf =","",""," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"User-Defined Combination",null,null,null,null,null,null,null,"*",16,null,"Rf ="]
[null,"Interception Rate of Side Flow","Rx =","",""," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Colorado Springs D-10-R",0,0,0,0,{"$f":"AU122+AV122*(OG_Lo*OG_No)-AW122*(OG_Lo*OG_No)^2+AX122*(OG_Lo*OG_No)^3","v":0},null,null,null,17,null,"Rx ="]
[null,"Actual Interception Capacity","Qa =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",BF123)","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",BG123)","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Wheat Ridge Combination",0.3,4.8499999999999996,1.31,0.15,{"$f":"AU123+AV123*(OG_Lo*OG_No)-AW123*(OG_Lo*OG_No)^2+AX123*(OG_Lo*OG_No)^3","v":0.3},null,null,null,18,null,"Qa ="]
[null,"Carry-Over Flow = Qo-Qa (to be applied to curb opening or next d/s inlet)","Qb =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",BF124)","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",BG124)","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OG_InletTypeNum =",null,null,"Qb ="]
[null,"Curb Opening or Slotted Inlet Analysis (Calculated)",null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OG_InletType =",{"$f":"IF(OG_InletTypeNum=\"\",\"\",INDEX($AS$106:$AT$123,MATCH(OG_InletTypeNum,$AS$106:$AS$123,0),2))","v":""},null,null,null,"Curb Opening or Slotted Inlet Analysis (Calculated)"]
[null,"Equivalent Slope Se","Se =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Curb_Qa_Minor=\"N/A\",\"N/A\",\nSx+(Minor_a/12+OG_aLocal/12)*OG_Minor_Eo/Wgutter))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Curb_Qa_Major=\"N/A\",\"N/A\",\nSx+(Major_a/12+OG_aLocal/12)*OG_Major_Eo/Wgutter))","v":""},"ft/ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OG_InletRowNum =",null,null,"Se ="]
[null,"Required Length LT to Have 100% Interception","LT =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Curb_Qa_Minor=\"N/A\",\"N/A\",BF127))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Curb_Qa_Major=\"N/A\",\"N/A\",BG127))","v":""},"ft  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For User-Defined Combination, InletRowNum is based on UserForm Inlet Selection",null,"LT ="]
[null,"Under No-Clogging Condition"," ","MINOR","MAJOR"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Under No-Clogging Condition"]
[null,"Effective Length of Curb Opening or Slotted Inlet (minimum of L, LT)","L =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Curb_Qa_Minor=\"N/A\",\"N/A\",BF129))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Curb_Qa_Major=\"N/A\",\"N/A\",BG129))","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L ="]
[null,"Interception Capacity ","Qi =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Curb_Qa_Minor=\"N/A\",\"N/A\",BF130))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Curb_Qa_Major=\"N/A\",\"N/A\",BG130))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qi ="]
[null,"Under Clogging Condition",null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Under Clogging Condition"]
[null,"Clogging Coefficient","CurbCoeff =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Curb_Qa_Minor=\"N/A\",\"N/A\",BF132))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Curb_Qa_Major=\"N/A\",\"N/A\",BG132))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CurbCoef ="]
[null,"Clogging Factor for Multiple-unit Curb Opening or Slotted Inlet","CurbClog =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Curb_Qa_Minor=\"N/A\",\"N/A\",BF133))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Curb_Qa_Major=\"N/A\",\"N/A\",BG133))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CurbClog ="]
[null,"Effective (Unclogged) Length ","Le =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Curb_Qa_Minor=\"N/A\",\"N/A\",BF134))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Curb_Qa_Major=\"N/A\",\"N/A\",BG134))","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le ="]
[null,"Actual Interception Capacity ","Qa =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",BF135)","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",BG135)","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qa ="]
[null,"Carry-Over Flow = Qb(GRATE)-Qa","Qb =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",BF136)","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",BG136)","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qb ="]
[null,"Summary",null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary"]
[null,"Total Inlet Interception Capacity","Qa =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Minor_Qo=\"N/A\",\"N/A\",\nIF(OG_Curb_Qa_Minor=\"N/A\",OG_Grate_Qa_Minor,\nIF(OG_Grate_Qa_Minor=\"N/A\",OG_Curb_Qa_Minor,\nIF(OG_Grate_Qa_Minor+OG_Curb_Qa_Minor<0,0,OG_Grate_Qa_Minor+OG_Curb_Qa_Minor)))))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Major_Qo=\"N/A\",\"N/A\",\nIF(OG_Curb_Qa_Major=\"N/A\",OG_Grate_Qa_Major,\nIF(OG_Grate_Qa_Major=\"N/A\",OG_Curb_Qa_Major,\nIF(OG_Grate_Qa_Major+OG_Curb_Qa_Major<0,0,OG_Grate_Qa_Major+OG_Curb_Qa_Major)))))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q ="]
[null,"Total Inlet Carry-Over Flow (flow bypassing inlet)","Qb =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Minor_Qo=\"N/A\",\"N/A\",\nIF(OG_Curb_Qa_Minor=\"N/A\",IF(OG_Grate_Qa_Minor=\"N/A\",OG_Minor_Qo,OG_Minor_Qo-OG_Grate_Qa_Minor),\nIF(OG_Grate_Qa_Minor=\"N/A\",OG_Minor_Qo-OG_Curb_Qa_Minor,\nOG_Minor_Qo-OG_Grate_Qa_Minor-OG_Curb_Qa_Minor))))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Major_Qo=\"N/A\",\"N/A\",\nIF(OG_Curb_Qa_Major=\"N/A\",IF(OG_Grate_Qa_Major=\"N/A\",OG_Major_Qo,OG_Major_Qo-OG_Grate_Qa_Major),\nIF(OG_Grate_Qa_Major=\"N/A\",OG_Major_Qo-OG_Curb_Qa_Major,\nOG_Major_Qo-OG_Grate_Qa_Major-OG_Curb_Qa_Major))))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qb ="]
[null,"Capture Percentage = Qa/Qo","C% =",{"$f":"IF(OG_Minor_Qo=\"\",\"\",IF(OG_Minor_Qo=\"N/A\",\"N/A\",IF(OG_Minor_Qo=0,0,\nIF(OG_Curb_Qa_Minor=\"N/A\",IF(OG_Grate_Qa_Minor=\"N/A\",\"N/A\",OG_Grate_Qa_Minor/OG_Minor_Qo*100),\nIF(OG_Grate_Qa_Minor=\"N/A\",OG_Curb_Qa_Minor/OG_Minor_Qo*100,\n(OG_Grate_Qa_Minor+OG_Curb_Qa_Minor)/OG_Minor_Qo*100)))))","v":""},{"$f":"IF(OG_Major_Qo=\"\",\"\",IF(OG_Major_Qo=\"N/A\",\"N/A\",IF(OG_Major_Qo=0,0,\nIF(OG_Curb_Qa_Major=\"N/A\",IF(OG_Grate_Qa_Major=\"N/A\",\"N/A\",OG_Grate_Qa_Major/OG_Major_Qo*100),\nIF(OG_Grate_Qa_Major=\"N/A\",OG_Curb_Qa_Major/OG_Major_Qo*100,\n(OG_Grate_Qa_Major+OG_Curb_Qa_Major)/OG_Major_Qo*100)))))","v":""},"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C% ="]
[null,{"$f":"IF(OR(A90=\"Warning 1\",A92=\"Warning 1\",A93=\"Warning 1\"),\"Warning 1: Dimension entered is not a typical dimension for inlet type specified.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(OR(A94=\"Warning 2\",A95=\"Warning 2\"),\"Warning 2: Clogging factor is not the recommended value for inlet type specified.\",\"\")","v":""}]
[null,{"$f":"IF(OR(OG_Minor_Qo=\"\",OG_Minor_Qo=\"N/A\"),\"\",\nIF(D130=\"N/A\",\n\"Note: Storm sewer should be sized for the sum of the unclogged interception capacities (Qminor = \" & ROUND(D115,1) & \" cfs and Qmajor = \" & ROUND(E115,1) & \" cfs)\",\nIF(D115=\"N/A\",\n\"Note: Storm sewer should be sized for the sum of the unclogged interception capacities (Qminor = \" & ROUND(D130,1) & \" cfs and Qmajor = \" & ROUND(E130,1) & \" cfs)\",\n\"Note: Storm sewer should be sized for the sum of the unclogged interception capacities (Qminor = \" & ROUND(D115+D130,1) & \" cfs and Qmajor = \" & ROUND(E115+E130,1) & \" cfs)\")))","v":""}]
[]
[]
[]
[]
[null,"                         INLET IN A SUMP OR SAG LOCATION"]
[null,null,{"$f":"Intro!F4","v":"MHFD-Inlet, Version 6.00 (August 2025)"}]
[]
[]
[]
[]
[]
[]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InSump Section (Hidden Cells)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INLET_TYPE","alocal","Lo G","Wo G","Cw  G","Co G","Nw G","No G","Cm G","Lo C","Hvert C","Hthroat C","Theta C","Cw C","Co C","Nw C","No C","Cm C","K Comb","INLET_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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CDOT Type R Curb Opening",{"$f":"IF(Hcurb>9,0,6+3-Hcurb)","v":9},"N/A","N/A","N/A","N/A","N/A","N/A","N/A",5,{"$f":"IF(Hcurb>9,6,Hcurb+AU161-3)","v":6},{"$f":"BD161","v":6},63.4,3.6,0.67,1,1,0.93,"N/A","CDOT Type R Curb Opening",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"CDOT/Denver 13 Valley Grate",2,3,1.73,3.3,0.6,0.7,0.43,0.93,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.37,"CDOT/Denver 13 Valley Grate",2]
[null,"Design Information (Input)",null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"CDOT/Denver 13 Combination",2,3,1.73,3.3,0.6,0.7,0.43,0.93,3,{"$f":"Hcurb+AU163-1.5","v":0.5},5.25,0,3.7,0.66,1,1,0.86,0.37,"CDOT/Denver 13 Combination",3]
[null,"Type of Inlet","Type =",{"$f":"IF(IS_InletTypeNum = \"\", \"\",BM181)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"CDOT Type C Grate",0,2.92,2.92,2.41,0.67,0.84,0.7,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","CDOT Type C Grate",4]
[null,"Local Depression (additional to continuous gutter depression 'a' from above)","alocal =",null,{"$f":"IF(IS_alocal=\"\",\"\",IS_alocal)","v":""},"inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Denver No. 14 Curb Opening",3,"N/A","N/A","N/A","N/A","N/A","N/A","N/A",6,{"$f":"Hcurb+AU165-3","v":0},{"$f":"BD165","v":0},63.4,3.6,0.67,1,1,0.93,"N/A","Denver No. 14 Curb Opening",5]
[null,"Number of Unit Inlets (Grate or Curb Opening)","No =",null,{"$f":"IF(IS_No=\"\",\"\",IS_No)","v":""},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Denver No. 16 Combination",2,3,1.73,3.6,0.6,0.73,0.31,0.9,3,{"$f":"Hcurb+AU166-1.5","v":0.5},5.25,0,3.7,0.66,1,1,0.86,0.21,"Denver No. 16 Combination",6]
[null,"Water Depth at Flowline (outside of local depression)","Ponding Depth =",null,null,"inches",null,"The Ponding Depths default to the minimum of the depth values for maximum allowable depth (cells D29:E29) or the depth based on allowable spread (cells D36:E36).  You can override these default values by checking the 'Override Depths' checkbox.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Denver No. 16 Valley Grate",2,3,1.73,3.6,0.6,0.73,0.31,0.9,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.21,"Denver No. 16 Valley Grate",7]
[null,"Grate Information",null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Directional Cast Vane Grate",0,null,null,3,0.67,{"$f":"ROUND(BA168^0.5*0.8,2)","v":0.47},0.35,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.21,"Directional Cast Vane Grate",8]
[null,"Length of a Unit Grate","Lo (G) =",null,{"$f":"IF(IS_LoG=\"\",\"\",IS_LoG)","v":""},"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Directional 45-Degree Bar Grate",0,null,null,3,0.67,0.36,0.2,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.21,"Directional 45-Degree Bar Grate",9]
[null,"Width of a Unit Grate","Wo =",null,{"$f":"IF(IS_Wo=\"\",\"\",IS_Wo)","v":""},"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Directional 30-Degree Bar Grate",0,null,null,3,0.67,0.47,0.34,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.21,"Directional 30-Degree Bar Grate",10]
[null,"Open Area Ratio for a Grate (typical values 0.15-0.90)","Aratio =",null,{"$f":"IF(IS_Aratio=\"\",\"\",IS_Aratio)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Reticuline Riveted Grate",0,null,null,3,0.67,0.72,0.8,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.21,"Reticuline Riveted Grate",11]
[null,"Clogging Factor for a Single Grate (typical value 0.50 - 0.70)","Cf (G) =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"1-7/8\" Bar Grate, Crossbars @ 8\"",0,null,null,3,0.67,0.76,0.9,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.37,"1-7/8\" Bar Grate, Crossbars @ 8\"",12]
[null,"Grate Weir Coefficient (typical value 2.15 - 3.60)","Cw  (G) =",null,{"$f":"IF(IS_CwG=\"\",\"\",IS_CwG)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"1-7/8\" Bar Grate, Crossbars @ 4\"",0,null,null,3,0.67,0.72,0.8,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.37,"1-7/8\" Bar Grate, Crossbars @ 4\"",13]
[null,"Grate Orifice Coefficient (typical value 0.60 - 0.80)","Co (G) =",null,{"$f":"IF(IS_CoG=\"\",\"\",IS_CoG)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"1-1/8\" Bar Grate, Crossbars @ 8\"",0,null,null,3,0.67,0.62,0.6,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.86,0.37,"1-1/8\" Bar Grate, Crossbars @ 8\"",14]
[null,"Curb Opening Information",null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Slotted Inlet Parallel to Flow",0,null,null,2.48,0.8,0.76,0.9,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","Slotted Inlet Parallel to Flow",15]
[null,{"$f":"IF(UserDefined_IS_CurbLength=\"\",\"Length of a Unit Curb Opening\",\"Total Length of Sweeper Curb Opening\")","v":"Length of a Unit Curb Opening"},"Lo (C) =",null,{"$f":"IF(IS_LoC=\"\",\"\",IS_LoC)","v":""},"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Slotted Inlet Normal to Flow",0,null,null,2.48,0.8,0.76,0.9,0.97,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","Slotted Inlet Normal to Flow",16]
[null,"Height of Vertical Curb Opening in Inches ","Hvert =",null,{"$f":"IF(IS_Hvert=\"\",\"\",IS_Hvert)","v":""},"inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"User-Defined Combination",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User-Defined Combination",17]
[null,"Height of Curb Orifice Throat in Inches ","Hthroat =",null,{"$f":"IF(IS_Hthroat=\"\",\"\",IS_Hthroat)","v":""},"inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Colorado Springs D-10-R",4,"N/A","N/A","N/A","N/A","N/A","N/A","N/A",4,8,{"$f":"BD178","v":8},81,3.6,0.67,1,1,0.93,"N/A","Colorado Springs D-10-R",18]
[null,"Angle of Throat","Theta =",null,{"$f":"IF(IS_Theta=\"\",\"\",IS_Theta)","v":""},"degrees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Wheat Ridge Combination",2,2.75,1.37,3.6,0.67,{"$f":"ROUND(BA179^0.5*0.8,2)","v":0.64},0.65,0.97,2.88,6,5.25,0,3.7,0.66,1,1,0.86,0.21,"Wheat Ridge Combination",19]
[null,"Side Width for Depression Pan (typically the gutter width of 2 feet)","Wp =",null,{"$f":"IF(IS_Wp=\"\",\"\",IS_Wp)","v":""},"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IS_InletTypeNum ="]
[null,"Clogging Factor for a Single Curb Opening (typical value 0.10)","Cf (C) =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor","Major",null,"IS_Clog_Coeff_Lookup",null,null,null,null,null,null,null,null,null,null,null,null,null,"IS_InletType =",{"$f":"IF(IS_InletTypeNum=\"\",\"\",INDEX($AS$161:$AT$179,MATCH(IS_InletTypeNum,$AS$161:$AS$179,0),2))","v":""}]
[null,"Curb Opening Weir Coefficient (typical value 2.3-3.7)","Cw (C) =",null,{"$f":"IF(IS_CwC=\"\",\"\",IS_CwC)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check if user input is complete:",{"$f":"IF(COUNTA(D165:D167,D169:D174,D176:D183)=17,TRUE, FALSE)","v":false},{"$f":"IF(COUNTA(D165:D166,E167,D169:D171,E172,D173:D174,D176:D180,E181,D182:D183)=17,TRUE, FALSE)","v":false},null,"No unit","Grate Coef","Curb Coef",null,null,"User-Defined Inlet (User Form Input Values)",null,null,null,null,null,null,null,null,null,"IS_InletGroup =",{"$f":"IF(OR(IS_InletTypeNum=1,IS_InletTypeNum=5,IS_InletTypeNum=18),\"curb\",\nIF(OR(IS_InletTypeNum=2,IS_InletTypeNum=4,IS_InletTypeNum=7,AND(IS_InletTypeNum>=8,IS_InletTypeNum<=16)),\"grate\",\nIF(OR(IS_InletTypeNum=3,IS_InletTypeNum=6,IS_InletTypeNum=17,IS_InletTypeNum=19),\"combo\",\"\")))","v":""}]
[null,"Curb Opening Orifice Coefficient (typical value 0.60 - 0.70)","Co (C) =",null,{"$f":"IF(IS_CoC=\"\",\"\",IS_CoC)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Ponding Depth =",{"$f":"MIN(Minor_Dmax,Minor_Dmax_Spread)","v":0},{"$f":"MIN(Major_Dmax,Major_Dmax_Spread)","v":0},null,1,1,1,null,null,null,"User Grate Type =",null,null,null,null,null,null,null,null,"CSU Study vs HEC-22 Boolean =",{"$f":"IF(OR(AND(IS_InletTypeNum>=1,IS_InletTypeNum<=3),AND(IS_InletTypeNum>=5,IS_InletTypeNum<=7),IS_InletTypeNum=18,IS_InletTypeNum=19),\"CSU\",\nIF(IS_InletTypeNum<>17,\"HEC-22\",\nIF(OR(UserDefined_IS_GrateTypeNum=2,UserDefined_IS_GrateTypeNum=7),\"CSU\",\"HEC-22\")))","v":"HEC-22"}]
[null,{"$f":"IF(UserDefined_IS_GrateType=\"\",\"Grate Flow Analysis (Calculated)\",\"Analysis For Grate Type = \"&UserDefined_IS_GrateType&\" (Calculated)\")","v":"Grate Flow Analysis (Calculated)"},null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1.5,1.25,null,null,null,"User Grate Type Num ="]
[null,"Clogging Coefficient for Multiple Units","Coef =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_CfG_minor=\"N/A\",\"N/A\",VLOOKUP(IS_No,IS_ClogCoeff_Lookup,2)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_CfG_major=\"N/A\",\"N/A\",VLOOKUP(IS_No,IS_ClogCoeff_Lookup,2)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1.75,1.31,null,null,null,"Sweeper Boolean ="]
[null,"Clogging Factor for Multiple Units","Clog =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_CfG_minor=\"N/A\",\"N/A\",\nIS_CfG_minor*IS_Grate_Coeff_Minor/IS_No))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_CfG_major=\"N/A\",\"N/A\",IS_CfG_major*IS_Grate_Coeff_Major/IS_No))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Override Depths Checkbox",null,null,4,1.88,1.33,null,null,null,"User Curb Length ="]
[null,{"$f":"IF(IS_CSU_HEC22_Boolean=\"CSU\",\"Grate Capacity as a Weir (based on MHFD - CSU 2010 Study)\",\"Grate Capacity as a Weir (based on Modified HEC-22 Method)\")","v":"Grate Capacity as a Weir (based on Modified HEC-22 Method)"},null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OverrideDepths_Boolean =",false,null,5,1.94,1.33]
[null,"Interception without Clogging","Qwi =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIF(IS_InletGroup=\"grate\",\nIF(IS_CSU_HEC22_Boolean=\"CSU\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,8)*IS_CwG*(2*IS_Wo+IS_No*IS_LoG)*(IS_dGrate_Minor^1.5)*IS_RFgrate_Minor,\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,8)*IS_CwG*IF(IS_InletTypeNum=15,IS_No*IS_LoG,IF(IS_InletTypeNum=16,IS_No*IS_Wo,2*IS_Wo+IS_No*IS_LoG))*(IS_dGrate_Minor^1.5)),\nIF(IS_CSU_HEC22_Boolean=\"CSU\",\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,8)*IS_CwG*(2*IS_Wo+IS_No*IS_LoG)*(IS_dGrate_Minor^1.5)*IS_RFgrate_Minor,\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,8)*IS_CwG*(2*IS_Wo+IS_No*IS_LoG)*(IS_dGrate_Minor^1.5)))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIF(IS_InletGroup=\"grate\",\nIF(IS_CSU_HEC22_Boolean=\"CSU\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,8)*IS_CwG*(2*IS_Wo+IS_No*IS_LoG)*(IS_dGrate_Major^1.5)*IS_RFgrate_Major,\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,8)*IS_CwG*IF(IS_InletTypeNum=15,IS_No*IS_LoG,IF(IS_InletTypeNum=16,IS_No*IS_Wo,2*IS_Wo+IS_No*IS_LoG))*(IS_dGrate_Major^1.5)),\nIF(IS_CSU_HEC22_Boolean=\"CSU\",\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,8)*IS_CwG*(2*IS_Wo+IS_No*IS_LoG)*(IS_dGrate_Major^1.5)*IS_RFgrate_Major,\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,8)*IS_CwG*(2*IS_Wo+IS_No*IS_LoG)*(IS_dGrate_Major^1.5)))))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OverrideDepths_Trigger =",null,null,6,1.97,1.33]
[null,"Interception with Clogging","Qwa =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIS_Grate_Qwi_Minor*(1-IS_Grate_Clog_Minor)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIS_Grate_Qwi_Major*(1-IS_Grate_Clog_Major)))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1.98,1.33]
[null,{"$f":"IF(IS_CSU_HEC22_Boolean=\"CSU\",\"Grate Capacity as an Orifice (based on MHFD - CSU 2010 Study)\",\"Grate Capacity as an Orifice (based on Modified HEC-22 Method)\")","v":"Grate Capacity as an Orifice (based on Modified HEC-22 Method)"}," ","MINOR","MAJOR"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,1.99,1.33]
[null,"Interception without Clogging","Qoi =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIF(IS_InletGroup=\"grate\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,9)*IS_CoG*IS_Wo*(IS_No*IS_LoG)*SQRT(64.4*IS_dGrate_Minor),\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,9)*IS_CoG*IS_Wo*(IS_No*IS_LoG)*SQRT(64.4*IS_dGrate_Minor))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIF(IS_InletGroup=\"grate\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,9)*IS_CoG*IS_Wo*(IS_No*IS_LoG)*SQRT(64.4*IS_dGrate_Major),\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,9)*IS_CoG*IS_Wo*(IS_No*IS_LoG)*SQRT(64.4*IS_dGrate_Major))))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,2,1.33]
[null,"Interception with Clogging","Qoa =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIS_Grate_Qoi_Minor*(1-IS_Grate_Clog_Minor)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIS_Grate_Qoi_Major*(1-IS_Grate_Clog_Major)))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2,1.33]
[null,"Grate Capacity as Mixed Flow"," ","MINOR","MAJOR"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,2,1.33]
[null,"Interception without Clogging","Qmi =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIF(IS_InletGroup=\"grate\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,10)*SQRT(IS_Grate_Qwi_Minor*IS_Grate_Qoi_Minor),\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,10)*SQRT(IS_Grate_Qwi_Minor*IS_Grate_Qoi_Minor))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIF(IS_InletGroup=\"grate\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,10)*SQRT(IS_Grate_Qwi_Major*IS_Grate_Qoi_Major),\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,10)*SQRT(IS_Grate_Qwi_Major*IS_Grate_Qoi_Major))))","v":""},"cfs"]
[null,"Interception with Clogging","Qma =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIF(IS_InletGroup=\"grate\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,10)*SQRT(IS_Grate_Qwa_Minor*IS_Grate_Qoa_Minor),\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,10)*SQRT(IS_Grate_Qwa_Minor*IS_Grate_Qoa_Minor))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nIF(IS_InletGroup=\"grate\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,10)*SQRT(IS_Grate_Qwa_Major*IS_Grate_Qoa_Major),\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,10)*SQRT(IS_Grate_Qwa_Major*IS_Grate_Qoa_Major))))","v":""},"cfs"]
[null,"Resulting Grate Capacity (assumes clogged condition)","QGrate =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nMIN(IS_Grate_Qwa_Minor,IS_Grate_Qoa_Minor,IS_Grate_Qma_Minor)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",\"N/A\",\nMIN(IS_Grate_Qwa_Major,IS_Grate_Qoa_Major,IS_Grate_Qma_Major)))","v":""},"cfs"]
[null,"Curb Opening Flow Analysis (Calculated)",null,"MINOR","MAJOR"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equation Numbers based on updated Ch.7 dated 7-31-22 which added a new 7-34 and bumped everything down by one equation number"]
[null,"Clogging Coefficient for Multiple Units","Coef =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_CfC_minor=\"N/A\",\"N/A\",VLOOKUP(MAX(1,ROUND(IS_No*IS_LoC/5,1)),IS_ClogCoeff_Lookup,3)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_CfC_major=\"N/A\",\"N/A\",VLOOKUP(MAX(1,ROUND(IS_No*IS_LoC/5,1)),IS_ClogCoeff_Lookup,3)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRATE equations",null,null,null,null,"CURB equations",null,null,"C & N","COMBINATION equations"]
[null,"Clogging Factor for Multiple Units","Clog =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_CfC_minor=\"N/A\",\"N/A\",MIN(1,IS_CfC_minor*IS_Curb_Coeff_Minor/(IS_No*IS_LoC/5))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_CfC_major=\"N/A\",\"N/A\",MIN(1,IS_CfC_major*IS_Curb_Coeff_Major/(IS_No*IS_LoC/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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type","Weir Eqn","Orifice Eqn","Mixed","Control","WPRF","Weir Eqn","Orifice Eqn","Mixed","Control","WPRF","Coeffs","Combo","User-Def","Sweeper"]
[null,{"$f":"IF(IS_CSU_HEC22_Boolean=\"CSU\",\"Curb Capacity as a Weir (based on MHFD - CSU 2010 Study)\",\"Curb Capacity as a Weir (based on Modified HEC-22 Method)\")","v":"Curb Capacity as a Weir (based on Modified HEC-22 Method)"},null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CDOT Type R Curb Opening","Curb","--","--","--","--","--","7-31","7-32","7-29","7-30","7-33","Table 7-7","--","--","--"]
[null,"Interception without Clogging","Qwi =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIF(IS_InletGroup=\"curb\",\nIF(IS_alocal=0,\n1*IS_CwC*(IS_No*IS_LoC)*(IS_dCurb_Minor^1.5)*IS_RFcurb_Minor,\n1*IS_CwC*(IS_No*IS_LoC+1.8*IS_Wp)*(IS_dCurb_Minor^1.5)*IS_RFcurb_Minor),\nIF(IS_CSU_HEC22_Boolean=\"CSU\",\n\nIF(UserDefined_IS_SweeperBoolean=1,\nIF(IS_alocal=0,\n1*IS_CwC*(IS_LoC)*(IS_dCurb_Minor^1.5)*IS_RFcombo_Minor,\n1*IS_CwC*(IS_LoC+1.8*IS_Wp)*(IS_dCurb_Minor^1.5)*IS_RFcombo_Minor),\nIF(IS_alocal=0,\n1*IS_CwC*(IS_No*IS_LoC)*(IS_dCurb_Minor^1.5)*IS_RFcombo_Minor,\n1*IS_CwC*(IS_No*IS_LoC+1.8*IS_Wp)*(IS_dCurb_Minor^1.5)*IS_RFcombo_Minor)),\n\nIF(UserDefined_IS_SweeperBoolean=1,\nIF(OR(IS_alocal=0,IS_LoC>12),\n1*IS_CwC*(IS_LoC)*(IS_dCurb_Minor^1.5),\n1*IS_CwC*(IS_LoC+1.8*IS_Wp)*(IS_dCurb_Minor^1.5)),\nIF(OR(IS_alocal=0,IS_LoC>12),\n1*IS_CwC*(IS_No*IS_LoC)*(IS_dCurb_Minor^1.5),\n1*IS_CwC*(IS_No*IS_LoC+1.8*IS_Wp)*(IS_dCurb_Minor^1.5)))))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIF(IS_InletGroup=\"curb\",\nIF(IS_alocal=0,\n1*IS_CwC*(IS_No*IS_LoC)*(IS_dCurb_Major^1.5)*IS_RFcurb_Major,\n1*IS_CwC*(IS_No*IS_LoC+1.8*IS_Wp)*(IS_dCurb_Major^1.5)*IS_RFcurb_Major),\nIF(IS_CSU_HEC22_Boolean=\"CSU\",\n\nIF(UserDefined_IS_SweeperBoolean=1,\nIF(IS_alocal=0,\n1*IS_CwC*(IS_LoC)*(IS_dCurb_Major^1.5)*IS_RFcombo_Major,\n1*IS_CwC*(IS_LoC+1.8*IS_Wp)*(IS_dCurb_Major^1.5)*IS_RFcombo_Major),\nIF(IS_alocal=0,\n1*IS_CwC*(IS_No*IS_LoC)*(IS_dCurb_Major^1.5)*IS_RFcombo_Major,\n1*IS_CwC*(IS_No*IS_LoC+1.8*IS_Wp)*(IS_dCurb_Major^1.5)*IS_RFcombo_Major)),\n\nIF(UserDefined_IS_SweeperBoolean=1,\nIF(OR(IS_alocal=0,IS_LoC>12),\n1*IS_CwC*(IS_LoC)*(IS_dCurb_Major^1.5),\n1*IS_CwC*(IS_LoC+1.8*IS_Wp)*(IS_dCurb_Major^1.5)),\nIF(OR(IS_alocal=0,IS_LoC>12),\n1*IS_CwC*(IS_No*IS_LoC)*(IS_dCurb_Major^1.5),\n1*IS_CwC*(IS_No*IS_LoC+1.8*IS_Wp)*(IS_dCurb_Major^1.5)))))))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"CDOT/Denver 13 Valley Grate","Grate","7-27","7-28","7-29","7-30","7-37","--","--","--","--","--","Table 7-7","--","7-36","7-36"]
[null,"Interception with Clogging","Qwa =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIS_Curb_Qwi_Minor*(1-IS_Curb_Clog_Minor)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIS_Curb_Qwi_Major*(1-IS_Curb_Clog_Major)))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"CDOT/Denver 13 Combination","Combo","7-27","7-28","7-29","7-30","7-37","7-34","7-35","7-29","7-30","7-37","Table 7-7","7-36","--","--"]
[null,{"$f":"IF(IS_CSU_HEC22_Boolean=\"CSU\",\"Curb Capacity as an Orifice (based on MHFD - CSU 2010 Study)\",\"Curb Capacity as an Orifice (based on Modified HEC-22 Method)\")","v":"Curb Capacity as an Orifice (based on Modified HEC-22 Method)"}," ","MINOR","MAJOR"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"CDOT Type C Grate","Other Grate","7-38","7-39","7-29","7-30","7-37","--","--","--","--","--",null,"--","--","--"]
[null,"Interception without Clogging","Qoi =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIF(IS_InletGroup=\"curb\",\n1*IS_CoC*(IS_No*IS_LoC)*IS_Hthroat/12*SQRT(64.4*((IS_PondingDepth_minor+IS_alocal)/12-0.5*IS_Hthroat/12*SIN(IS_Theta*PI()/180))),\nIF(UserDefined_IS_SweeperBoolean=1,\n1*IS_CoC*(IS_LoC)*IS_Hthroat/12*SQRT(64.4*(IS_PondingDepth_minor+IS_alocal)/12),\n1*IS_CoC*(IS_No*IS_LoC)*IS_Hthroat/12*SQRT(64.4*(IS_PondingDepth_minor+IS_alocal)/12)))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIF(IS_InletGroup=\"curb\",\n1*IS_CoC*(IS_No*IS_LoC)*IS_Hthroat/12*SQRT(64.4*((IS_PondingDepth_major+IS_alocal)/12-0.5*IS_Hthroat/12*SIN(IS_Theta*PI()/180))),\nIF(UserDefined_IS_SweeperBoolean=1,\n1*IS_CoC*(IS_LoC)*IS_Hthroat/12*SQRT(64.4*(IS_PondingDepth_major+IS_alocal)/12),\n1*IS_CoC*(IS_No*IS_LoC)*IS_Hthroat/12*SQRT(64.4*(IS_PondingDepth_major+IS_alocal)/12)))))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Denver No. 14 Curb Opening","Curb","--","--","--","--","--","7-31 ","7-32","7-29","7-30","7-33","Table 7-7","--","--","--"]
[null,"Interception with Clogging","Qoa =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIS_Curb_Qoi_Minor*(1-IS_Curb_Clog_Minor)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIS_Curb_Qoi_Major*(1-IS_Curb_Clog_Major)))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Denver No. 16 Combination","Combo","7-27","7-28","7-29","7-30","7-37","7-34","7-35","7-29","7-30","7-37","Table 7-7","7-36","--","--"]
[null,"Curb Opening Capacity as Mixed Flow"," ","MINOR","MAJOR"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Denver No. 16 Valley Grate","Grate","7-27","7-28","7-29","7-30","7-37","--","--","--","--","--","Table 7-7","--","7-36","7-36"]
[null,"Interception without Clogging","Qmi =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIF(IS_InletGroup=\"curb\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,19)*SQRT(IS_Curb_Qwi_Minor*IS_Curb_Qoi_Minor),\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,19)*SQRT(IS_Curb_Qwi_Minor*IS_Curb_Qoi_Minor))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIF(IS_InletGroup=\"curb\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,19)*SQRT(IS_Curb_Qwi_Major*IS_Curb_Qoi_Major),\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,19)*SQRT(IS_Curb_Qwi_Major*IS_Curb_Qoi_Major))))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Directional Cast Vane Grate","Other Grate","7-38","7-39","7-29","7-30","--","7-38","7-39","7-29","7-30","--","Table 7-8","--","7-36","7-36"]
[null,"Interception with Clogging","Qma =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIF(IS_InletGroup=\"curb\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,19)*SQRT(IS_Curb_Qwa_Minor*IS_Curb_Qoa_Minor),\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,19)*SQRT(IS_Curb_Qwa_Minor*IS_Curb_Qoa_Minor))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nIF(IS_InletGroup=\"curb\",\nVLOOKUP(IS_InletTypeNum,IS_DefaultTable,19)*SQRT(IS_Curb_Qwa_Major*IS_Curb_Qoa_Major),\nVLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,19)*SQRT(IS_Curb_Qwa_Major*IS_Curb_Qoa_Major))))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Directional 45-Degree Bar Grate","Other Grate","7-38","7-39","7-29","7-30","--","7-38","7-39","7-29","7-30","--","Table 7-8","--","7-36","7-36"]
[null,"Resulting Curb Opening Capacity (assumes clogged condition)","QCurb =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nMIN(IS_Curb_Qwa_Minor,IS_Curb_Qoa_Minor,IS_Curb_Qma_Minor)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"grate\",\"N/A\",\nMIN(IS_Curb_Qwa_Major,IS_Curb_Qoa_Major,IS_Curb_Qma_Major)))","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Directional 30-Degree Bar Grate","Other Grate","7-38","7-39","7-29","7-30","--","7-38","7-39","7-29","7-30","--","Table 7-8","--","7-36","7-36"]
[null,"Resultant Street Conditions",null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Reticuline Riveted Grate","Other Grate","7-38","7-39","7-29","7-30","--","7-38","7-39","7-29","7-30","--","Table 7-8","--","7-36","7-36"]
[null,"Total Inlet Length","L =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(UserDefined_IS_SweeperBoolean=0,\nIS_No*MAX(IS_LoG,IS_LoC),\nMAX(IS_No*IS_LoG,IS_LoC)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(UserDefined_IS_SweeperBoolean=0,\nIS_No*MAX(IS_LoG,IS_LoC),\nMAX(IS_No*IS_LoG,IS_LoC)))","v":""},"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"1-7/8\" Bar Grate, Crossbars @ 8\"","Other Grate","7-38","7-39","7-29","7-30","--","7-38","7-39","7-29","7-30","--","Table 7-8","--","7-36","7-36"]
[null,"Resultant Street Flow Spread (based on street geometry from above)","T =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_PondingDepth_minor/12<Wgutter*Sw,IS_PondingDepth_minor/12/Sw,(IS_PondingDepth_minor-Minor_a)/12/Sx))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_PondingDepth_major/12<Wgutter*Sw,IS_PondingDepth_major/12/Sw,(IS_PondingDepth_major-Major_a)/12/Sx))","v":""},{"$f":"IF(IS_T_Major=\"\",\"ft\",IF(IS_T_Major>Tcrown,\"ft.   >T-Crown\",\"ft\"))","v":"ft"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"1-7/8\" Bar Grate, Crossbars @ 4\"","Other Grate","7-38","7-39","7-29","7-30","--","7-38","7-39","7-29","7-30","--","Table 7-8","--","7-36","7-36"]
[null,"Resultant Flow Depth at Street Crown","dCROWN =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF((IS_PondingDepth_minor-Minor_a)/12/Sx>Tcrown,((IS_PondingDepth_minor-Minor_a)/12/Sx-Tcrown)*Sx*12,0))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF((IS_PondingDepth_major-Major_a)/12/Sx>Tcrown,((IS_PondingDepth_major-Major_a)/12/Sx-Tcrown)*Sx*12,0))","v":""},"inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"1-1/8\" Bar Grate, Crossbars @ 8\"","Other Grate","7-38","7-39","7-29","7-30","--","7-38","7-39","7-29","7-30","--","Table 7-8","--","7-36","7-36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Slotted Inlet Parallel to Flow","Other Grate","7-38","7-39","7-29","7-30","--","--","--","--","--","--","Table 7-8","--","--","--"]
[null,"Low Head Performance Reduction (Calculated)",null,"MINOR","MAJOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Slotted Inlet Normal to Flow","Other Grate","7-38","7-39","7-29","7-30","--","--","--","--","--","--","Table 7-8","--","--","--"]
[null,"Depth for Grate Midwidth","dGrate =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_Wo=\"N/A\",\"N/A\",((IS_PondingDepth_minor+IS_alocal)/12-(Sw+IS_alocal/12/Wgutter)*IS_Wo/2)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_Wo=\"N/A\",\"N/A\",((IS_PondingDepth_major+IS_alocal)/12-(Sw+IS_alocal/12/Wgutter)*IS_Wo/2)))","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"User-Defined Combination","Other Combo"]
[null,"Depth for Curb Opening Weir Equation","dCurb =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_LoC=\"N/A\",\"N/A\",MAX(0.02,IS_PondingDepth_minor/12-Sw*Wgutter)))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_LoC=\"N/A\",\"N/A\",MAX(0.02,IS_PondingDepth_major/12-Sw*Wgutter)))","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Colorado Springs D-10-R","Curb","--","--","--","--","--","7-31 ","7-32","7-29","7-30","7-33","Table 7-7","--","--","--"]
[null,"Grated Inlet Performance Reduction Factor for Long Inlets","RFGrate =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(OR(IS_InletGroup=\"curb\",IS_CSU_HEC22_Boolean=\"HEC-22\"),\"N/A\",\nMIN(1,IS_PondingDepth_minor/(0.7*MIN(9,IS_No*IS_LoG)+4.3))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(OR(IS_InletGroup=\"curb\",IS_CSU_HEC22_Boolean=\"HEC-22\"),\"N/A\",\nMIN(1,IS_PondingDepth_major/(0.7*MIN(9,IS_No*IS_LoG)+4.3))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Wheat Ridge Combination","Combo","7-27","7-28","7-29","7-30","7-37","7-34","7-35","7-29","7-30","7-37","Table 7-7","7-36","--","--"]
[null,"Curb Opening Performance Reduction Factor for Long Inlets","RFCurb =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(OR(IS_InletGroup<>\"curb\",IS_CSU_HEC22_Boolean=\"HEC-22\"),\"N/A\",\nIF(UserDefined_IS_SweeperBoolean=1,\nMAX(0.5,MIN(1,IS_PondingDepth_minor/(0.67*IS_PondingDepth_minor+0.24*MIN(15,IS_LoC)))),\nMAX(0.5,MIN(1,IS_PondingDepth_minor/(0.67*IS_PondingDepth_minor+0.24*MIN(15,IS_No*IS_LoC)))))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(OR(IS_InletGroup<>\"curb\",IS_CSU_HEC22_Boolean=\"HEC-22\"),\"N/A\",\nIF(UserDefined_IS_SweeperBoolean=1,\nMAX(0.5,MIN(1,IS_PondingDepth_major/(0.67*IS_PondingDepth_major+0.24*MIN(15,IS_LoC)))),\nMAX(0.5,MIN(1,IS_PondingDepth_major/(0.67*IS_PondingDepth_major+0.24*MIN(15,IS_No*IS_LoC)))))))","v":""}]
[null,"Combination Inlet Performance Reduction Factor for Long Inlets","RFCombination =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(OR(IS_InletGroup<>\"combo\",IS_CSU_HEC22_Boolean=\"HEC-22\"),\"N/A\",\nIF(UserDefined_IS_SweeperBoolean=1,\nMIN(1,IS_PondingDepth_minor/(0.7*MIN(9,IS_LoC)+4.3)),\nMIN(1,IS_PondingDepth_minor/(0.7*MIN(9,IS_No*IS_LoC)+4.3)))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(OR(IS_InletGroup<>\"combo\",IS_CSU_HEC22_Boolean=\"HEC-22\"),\"N/A\",\nIF(UserDefined_IS_SweeperBoolean=1,\nMIN(1,IS_PondingDepth_major/(0.7*MIN(9,IS_LoC)+4.3)),\nMIN(1,IS_PondingDepth_major/(0.7*MIN(9,IS_No*IS_LoC)+4.3)))))","v":""}]
[]
[null,null,null,"MINOR","MAJOR"]
[null,"Total Inlet Interception Capacity (assumes clogged condition)","Qa =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",IS_QCurb_Minor,\nIF(IS_InletGroup=\"grate\",IS_QGrate_Minor,\nIF(UserDefined_IS_SweeperBoolean=1,\nIS_QGrate_Minor+IS_QCurb_Minor*(IS_No*IS_LoG/IS_LoC)-VLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,20)*SQRT(IS_QGrate_Minor*IS_QCurb_Minor*(IS_No*IS_LoG/IS_LoC))+IS_QCurb_Minor*(1-IS_No*IS_LoG/IS_LoC),\nIS_QGrate_Minor+IS_QCurb_Minor-VLOOKUP(IS_InletTypeNum,IS_DefaultTable,20)*SQRT(IS_QGrate_Minor*IS_QCurb_Minor)))))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(IS_InletGroup=\"curb\",IS_QCurb_Major,\nIF(IS_InletGroup=\"grate\",IS_QGrate_Major,\nIF(UserDefined_IS_SweeperBoolean=1,\nIS_QGrate_Major+IS_QCurb_Major*(IS_No*IS_LoG/IS_LoC)-VLOOKUP(IF(IS_InletTypeNum<>17,IS_InletTypeNum,UserDefined_IS_GrateTypeNum),IS_DefaultTable,20)*SQRT(IS_QGrate_Major*IS_QCurb_Major*(IS_No*IS_LoG/IS_LoC))+IS_QCurb_Major*(1-IS_No*IS_LoG/IS_LoC),\nIS_QGrate_Major+IS_QCurb_Major-VLOOKUP(IS_InletTypeNum,IS_DefaultTable,20)*SQRT(IS_QGrate_Major*IS_QCurb_Major)))))","v":""},"cfs"]
[null,{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",\nIF(AND(IS_Qa_Minor<AU9,IS_Qa_Major<AU10),\"WARNING: Inlet Capacity < Q Peak for Minor and Major Storms\",\nIF(IS_Qa_Minor<AU9,\"WARNING: Inlet Capacity < Q Peak for Minor Storm\",\nIF(IS_Qa_Major<AU10,\"WARNING: Inlet Capacity < Q Peak for Major Storm\",\n\"Inlet Capacity IS GOOD for Minor and Major Storms (>Q Peak)\"))))","v":""},"Q PEAK REQUIRED =",{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",IF(AU9=\"\",\"\",AU9))","v":""},{"$f":"IF(OR(Minor_Input_Complete_InSump=FALSE,Major_Input_Complete_InSump=FALSE),\"\",IF(AU10=\"\",\"\",AU10))","v":""},"cfs"]
[null,{"$f":"IF(OR(A165=\"Warning 1\",A169=\"Warning 1\",A170=\"Warning 1\",A176=\"Warning 1\",A177=\"Warning 1\",A178=\"Warning 1\",A179=\"Warning 1\",A180=\"Warning 1\"),\n\"Warning 1: Dimension entered is not a typical dimension for inlet type specified.\",\"\")","v":""}]
[null,{"$f":"IF(A171=\"Warning 2\",\n\"Warning 2: The Open Area Ratio is not the recommended value for inlet type specified.\",\"\")","v":""}]
[null,{"$f":"IF(OR(A172=\"Warning 3\",A181=\"Warning 3\"),\n\"Warning 3: Clogging Factor is not the recommended value for inlet type specified..\",\"\")","v":""}]
[null,{"$f":"IF(OR(A173=\"Warning 4\",A174=\"Warning 4\",A182=\"Warning 4\",A183=\"Warning 4\"),\n\"Warning 4: Weir or Orifice Coefficient is not the recommended value for inlet type specified.\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warning 2: Clogging factor is not in the recommended value for inlet type specified."]

{"sheet":"Area Inlet","index":4,"n_rows":190,"n_cols":65,"rows_kept":190,"cut":false,"hidden":true,"merged":[[0,1,0,5],[76,3,76,4],[1,1,1,5],[3,1,3,5],[4,1,4,5],[73,1,73,5],[74,1,74,5],[6,3,12,4]]}
[null,{"$f":"Intro!F4","v":"MHFD-Inlet, Version 6.00 (August 2025)"},null,null,null,null,null,null,null,"Worksheet Protected"]
[null,"AREA INLET IN A SWALE"]
[]
[null,{"$f":"IF(IM_Project=\"\",\"\",IM_Project)","v":""}]
[null,null,null,null,null,null,null,null,null,"Quick Links"]
[null,null,null,null,null,null,null,null,null,"INTRO"]
[null,null,null,"This worksheet uses the NRCS vegetal retardance method to determine Manning's n for grass-lined channels.\n\nAn override Manning's n can be entered for other channel materials.",null,null,null,null,null,"Inlet Management"]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis of Trapezoidal Channel (Grass-Lined uses SCS Method)"]
[null,"NRCS Vegetal Retardance (A, B, C, D, or E)","A, B, C, D, or E ="]
[null,"Manning's n (Leave cell D16 blank to manually enter an n value)","n ="]
[null,"Channel Invert Slope","SO =",null,"ft/ft"]
[null,"Bottom Width","B =",null,"ft"]
[null,"Left Side Slope","Z1 =",null,"ft/ft"]
[null,"Right Side Sloe","Z2 =",null,"ft/ft"]
[null,"Check one of the following soil types:"]
[null,"          Soil Type:               Max. Velocity (VMAX)       Max Froude No. (FMAX)"]
[null,"      Non-Cohesive                     5.0 fps                                   0.60"]
[null,"          Cohesive                        7.0 fps                                   0.80"]
[null,"            Paved                            N/A                                      N/A"]
[null,null,null,"Minor Storm","Major Storm"]
[null,"Maximum Allowable Top Width of Channel for Minor & Major Storm","TMAX =",null,null,"ft"]
[null,"Maximum Allowable Water Depth in Channel for Minor & Major Storm","dMAX =",null,null,"ft"]
[]
[null,"Maximum Channel Capacity Based On Allowable Top Width",null,"Minor Storm","Major Storm"]
[null,"Maximum Allowable Top Width","TMAX =",{"$f":"IF($BA$138<10,\"\",D28)","v":""},{"$f":"IF($BA$138<10,\"\",E28)","v":""},"ft"]
[null,"Water Depth","d =",{"$f":"IF(D32=\"\",\"\",((D32-D19)/(D20+D21)))","v":""},{"$f":"IF(E32=\"\",\"\",((E32-D19)/(D20+D21)))","v":""},"ft"]
[null,"Flow Area","A =",{"$f":"IF(D32=\"\",\"\",((D19+D32)/2)*D33)","v":""},{"$f":"IF(E32=\"\",\"\",((D19+E32)/2)*E33)","v":""},"sq ft"]
[null,"Wetted Perimeter","P =",{"$f":"IF(D32=\"\",\"\",(D19+D33*(((1+D20^2)^0.5)+((1+D21^2)^0.5))))","v":""},{"$f":"IF(E32=\"\",\"\",(D19+E33*(((1+D20^2)^0.5)+((1+D21^2)^0.5))))","v":""},"ft"]
[null,"Hydraulic Radius","R =",{"$f":"IF(D32=\"\",\"\",D34/D35)","v":""},{"$f":"IF(E32=\"\",\"\",E34/E35)","v":""},"ft"]
[null,{"$f":"IF(OR($D$17=\"\",$D$17=\"see details below\"),\"Manning's n based on NRCS Vegetal Retardance\",\"Manning's n\")","v":"Manning's n based on NRCS Vegetal Retardance"},"n ="]
[null,"Flow Velocity","V =",{"$f":"IF(D32=\"\",\"\",(1.49/D37)*(D36^(2/3))*(D18^0.5))","v":""},{"$f":"IF(E32=\"\",\"\",(1.49/E37)*(E36^(2/3))*(D18^0.5))","v":""},"fps"]
[null,"Velocity-Depth Product","VR =",{"$f":"IF(D32=\"\",\"\",D38*D36)","v":""},{"$f":"IF(E32=\"\",\"\",E38*E36)","v":""},"ft^2/s"]
[null,"Hydraulic Depth","D =",{"$f":"IF(D32=\"\",\"\",D34/D32)","v":""},{"$f":"IF(E32=\"\",\"\",E34/E32)","v":""},"ft"]
[null,"Froude Number","Fr =",{"$f":"IF(D32=\"\",\"\",D38/((32.2*D40)^0.5))","v":""},{"$f":"IF(E32=\"\",\"\",E38/((32.2*E40)^0.5))","v":""}]
[null,"Maximum Flow Based on Allowable Water Depth","QT =",{"$f":"IF(D32=\"\",\"\",D38*D34)","v":""},{"$f":"IF(E32=\"\",\"\",E38*E34)","v":""},"cfs"]
[]
[null,"Maximum Channel Capacity Based On Allowable Water Depth",null,"Minor Storm","Major Storm"]
[null,"Maximum Allowable Water Depth","dMAX =",{"$f":"IF($BA$138<10,\"\",D29)","v":""},{"$f":"IF($BA$138<10,\"\",E29)","v":""},"ft"]
[null,"Top Width","T =",{"$f":"IF(D45=\"\",\"\",D19+D45*(D20+D21))","v":""},{"$f":"IF(E45=\"\",\"\",D19+E45*(D20+D21))","v":""},"ft"]
[null,"Flow Area","A =",{"$f":"IF(D45=\"\",\"\",((D19+D46)/2)*D45)","v":""},{"$f":"IF(E45=\"\",\"\",((D19+E46)/2)*E45)","v":""},"sq ft"]
[null,"Wetted Perimeter","P =",{"$f":"IF(D45=\"\",\"\",(D19+D45*(((1+D20^2)^0.5)+((1+D21^2)^0.5))))","v":""},{"$f":"IF(E45=\"\",\"\",(D19+E45*(((1+D20^2)^0.5)+((1+D21^2)^0.5))))","v":""},"ft"]
[null,"Hydraulic Radius","R =",{"$f":"IF(D45=\"\",\"\",D47/D48)","v":""},{"$f":"IF(E45=\"\",\"\",E47/E48)","v":""},"ft"]
[null,{"$f":"IF(OR($D$17=\"\",$D$17=\"see details below\"),\"Manning's n based on NRCS Vegetal Retardance\",\"Manning's n\")","v":"Manning's n based on NRCS Vegetal Retardance"},"n ="]
[null,"Flow Velocity","V =",{"$f":"IF(D45=\"\",\"\",(1.49/D50)*(D49^(2/3))*(D18^0.5))","v":""},{"$f":"IF(E45=\"\",\"\",(1.49/E50)*(E49^(2/3))*(D18^0.5))","v":""},"fps"]
[null,"Velocity-Depth Product","VR =",{"$f":"IF(D45=\"\",\"\",D51*D49)","v":""},{"$f":"IF(E45=\"\",\"\",E51*E49)","v":""},"ft^2/s"]
[null,"Hydraulic Depth","D =",{"$f":"IF(D45=\"\",\"\",D47/D46)","v":""},{"$f":"IF(E45=\"\",\"\",E47/E46)","v":""},"ft"]
[null,"Froude Number","Fr =",{"$f":"IF(D45=\"\",\"\",D51/((32.2*D53)^0.5))","v":""},{"$f":"IF(E45=\"\",\"\",E51/((32.2*E53)^0.5))","v":""}]
[null,"Maximum Flow Based On Allowable Water Depth","Qd =",{"$f":"IF(D45=\"\",\"\",D51*D47)","v":""},{"$f":"IF(E45=\"\",\"\",E51*E47)","v":""},"cfs"]
[]
[null,"Allowable Channel Capacity Based On Channel Geometry",null,"Minor Storm","Major Storm"]
[null,{"$f":"IF(D58=D55,\"MINOR STORM Allowable Capacity is based on Depth Criterion\", \"MINOR STORM Allowable Capacity is based on Top Width Criterion\")","v":"MINOR STORM Allowable Capacity is based on Depth Criterion"},"Qallow =",{"$f":"IF(D45=\"\",\"\",MIN(D42,D55))","v":""},{"$f":"IF(E45=\"\",\"\",MIN(E42,E55))","v":""},"cfs"]
[null,{"$f":"IF(E58=E55, \"MAJOR STORM Allowable Capacity is based on Depth Criterion\",\"MAJOR STORM Allowable Capacity is based on Top Width Criterion\")","v":"MAJOR STORM Allowable Capacity is based on Depth Criterion"},"dallow =",{"$f":"IF(D45=\"\",\"\",IF(D58=D55,D45,D33))","v":""},{"$f":"IF(E45=\"\",\"\",IF(E58=E55,E45,E33))","v":""},"ft"]
[]
[null,"Water Depth in Channel Based On Design Peak Flow"]
[null,"Design Peak Flow","Qo =",{"$f":"IF($BA$138<10,\"\",D69*D65)","v":""},{"$f":"IF($BA$138<10,\"\",E69*E65)","v":""},"cfs"]
[null,"Water Depth","d =",null,null,"ft"]
[null,"Top Width","T =",{"$f":"IF($BA$138<10,\"\",D19+D63*(D20+D21))","v":""},{"$f":"IF($BA$138<10,\"\",D19+E63*(D20+D21))","v":""},"ft"]
[null,"Flow Area","A =",{"$f":"IF($BA$138<10,\"\",((D19+D64)/2)*D63)","v":""},{"$f":"IF($BA$138<10,\"\",((D19+E64)/2)*E63)","v":""},"sq ft"]
[null,"Wetted Perimeter","P =",{"$f":"IF($BA$138<10,\"\",(D19+D63*(((1+D20^2)^0.5)+((1+D21^2)^0.5))))","v":""},{"$f":"IF($BA$138<10,\"\",(D19+E63*(((1+D20^2)^0.5)+((1+D21^2)^0.5))))","v":""},"ft"]
[null,"Hydraulic Radius","R =",{"$f":"IF($BA$138<10,\"\",D65/D66)","v":""},{"$f":"IF($BA$138<10,\"\",E65/E66)","v":""},"ft"]
[null,{"$f":"IF(OR($D$17=\"\",$D$17=\"see details below\"),\"Manning's n based on NRCS Vegetal Retardance\",\"Manning's n\")","v":"Manning's n based on NRCS Vegetal Retardance"},"n ="]
[null,"Flow Velocity","V =",{"$f":"IF($BA$138<10,\"\",(1.49/D68)*(D67^(2/3))*(D18^0.5))","v":""},{"$f":"IF($BA$138<10,\"\",(1.49/E68)*(E67^(2/3))*(D18^0.5))","v":""},"fps"]
[null,"Velocity-Depth Product","VR =",{"$f":"IF($BA$138<10,\"\",D69*D67)","v":""},{"$f":"IF($BA$138<10,\"\",E69*E67)","v":""},"ft^2/s"]
[null,"Hydraulic Depth","D =",{"$f":"IF($BA$138<10,\"\",D65/D64)","v":""},{"$f":"IF($BA$138<10,\"\",E65/E64)","v":""},"ft"]
[null,"Froude Number","Fr =",{"$f":"IF($BA$138<10,\"\",IF(D62=0,0,D69/((32.2*D71)^0.5)))","v":""},{"$f":"IF($BA$138<10,\"\",IF(E62=0,0,E69/((32.2*E71)^0.5)))","v":""}]
[]
[null,{"$f":"IF($BA$148=\"\",\"\",$BA$148)","v":""}]
[null,{"$f":"IF($BA$149=\"\",\"\",$BA$149)","v":""}]
[null,"Inlet Design Information (Input)"]
[null,"Type of Inlet","Inlet Type =",{"$f":"IF($BC$163=\"\",\"\",$BC$163)","v":""}]
[]
[null,"Angle of Inclined Grate (must be <= 30 degrees)",null,"θ =",null,"degrees"]
[null,"Width of Grate",null,"W =",null,"ft"]
[null,"Length of Grate",null,"L =",null,"ft"]
[null,"Open Area Ratio",null,"ARATIO ="]
[null,"Height of Inclined Grate",null,"HB =",null,"ft"]
[null,"Clogging Factor",null,"Cf ="]
[null,"Grate Discharge Coefficient",null,"Cd ="]
[null,"Orifice Coefficient",null,"Co ="]
[null,"Weir Coefficient",null,"Cw ="]
[]
[]
[null,null,null,"MINOR","MAJOR"]
[null,"Water Depth at Inlet (for depressed inlets, 1 foot is added for depression)","d =",{"$f":"IF(D63=\"\",\"\",IF($BA$166<10,\"\",IF(GrateTypeNum=2,D63+1,IF(GrateTypeNum=4,D63+1,IF(GrateTypeNum=6,D63+1,D63)))))","v":""},{"$f":"IF(E63=\"\",\"\",IF($BA$166<10,\"\",IF(GrateTypeNum=2,E63+1,IF(GrateTypeNum=4,E63+1,IF(GrateTypeNum=6,E63+1,E63)))))","v":""}]
[]
[null,"Grate Capacity as a Weir"]
[null,"Submerged Side Weir Length","X =",{"$f":"IF(D91=\"\",\"\",IF($E$79=0,$E$81,IF(D91/SIN($E$79/180*3.1416)>$E$81,$E$81,D91/SIN($E$79/180*3.1416))))","v":""},{"$f":"IF(E91=\"\",\"\",IF($E$79=0,$E$81,IF(E91/SIN($E$79/180*3.1416)>$E$81,$E$81,E91/SIN($E$79/180*3.1416))))","v":""},"ft"]
[null,"Inclined Side Weir Flow","Qws =",{"$f":"IF(D91=\"\",\"\",BA184)","v":""},{"$f":"IF(E91=\"\",\"\",BB184)","v":""},"cfs"]
[null,"Base Weir Flow","Qwb =",{"$f":"IF(D91=\"\",\"\",BA186)","v":""},{"$f":"IF(E91=\"\",\"\",BB186)","v":""},"cfs"]
[null,"Interception Without Cloggging","Qwi =",{"$f":"IF(D91=\"\",\"\",D96+(2*D95))","v":""},{"$f":"IF(E91=\"\",\"\",E96+(2*E95))","v":""},"cfs"]
[null,"Interception With Clogging","Qwa =",{"$f":"IF(D91=\"\",\"\",D97*(1-$E$84))","v":""},{"$f":"IF(E91=\"\",\"\",E97*(1-$E$84))","v":""},"cfs"]
[]
[null,"Grate Capacity as an Orifice"," ",null,null," "]
[null,"Interception Without Clogging","Qoi =",{"$f":"IF(D91=\"\",\"\",BA190)","v":""},{"$f":"IF(E91=\"\",\"\",BB190)","v":""},"cfs"]
[null,"Interception With Clogging","Qoa =",{"$f":"IF(D91=\"\",\"\",D101*(1-$E$84))","v":""},{"$f":"IF(E91=\"\",\"\",E101*(1-$E$84))","v":""},"cfs"]
[]
[null,"Total Inlet Interception Capacity (assumes clogged condition)","Qa =",{"$f":"IF(D91=\"\",\"\",MIN(D98,D102))","v":""},{"$f":"IF(E91=\"\",\"\",MIN(E98,E102))","v":""},"cfs"]
[null,"Bypassed Flow","Qb =",{"$f":"IF(D91=\"\",\"\",IF(D62-D104<0,0,D62-D104))","v":""},{"$f":"IF(E91=\"\",\"\",IF(E62-E104<0,0,E62-E104))","v":""},"cfs"]
[null,"Capture Percentage = Qa/Qo","C% =",{"$f":"IF(D91=\"\",\"\",IF(D104/D62>1,100,IF(D104/D62<0,0,(D104/D62)*100)))","v":""},{"$f":"IF(E91=\"\",\"\",IF(E104/E62>1,100,IF(E104/E62<0,0,(E104/E62)*100)))","v":""},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOOP COUNT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Tmax"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Tmax"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor dmax",null,null,null,null,null,"Flow Coefficient Cd -- Research by CSU and Dr. Guo 2011"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Dmax",null,null,null,null,null,null,"Inclined Angle (degrees)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Qpeak",null,null,null,null,null,"Type of Inlet",0,10,20,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Qpeak",null,null,null,null,null,"CDOT Type C",0.95935753219516107,0.68506867240517599,0.7329441576192397,0.86361218325413469]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDOT Type C (Depressed)",0.8440662120542235,0.57343815147981281,0.64131103761076846,0.77260971579485527]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil Type",null,"(Non-Cohesive=1 , Cohesive=2, Paved=3)",null,null,null,"CDOT Type D (In Series)",0.780124759107925,0.57343815147981281,0.64131103761076846,0.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDOT Type D (In Series & Depressed)",0.71549693558155525,0.51396232079534299,0.61444271391919325,0.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDOT TYPE D (Parallel)",0.75590498248727245,0.55000000000000004,0.59,0.76431092608373241]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"COUNTA(D17:D21,BB135,D28:E29)","v":0},"Count of input cells for Channel Capacity",null,null,null,null,"CDOT TYPE D (Parallel & Depressed)",0.68015568224024747,0.5,0.54,0.75415373144475195]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Third Order Polynomial Curve Fit","x3","x2","x","b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDOT Type C",{"$f":"LINEST(BH133:BK133,$BH$132:$BK$132^ROW($1:$3),TRUE,FALSE)","v":-3.989530076386938E-5},2.8076807479363213E-3,-5.151616338197474E-2,0.95935753219516107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINOR Q","MAJOR Q",null,null,null,null,"CDOT Type C (Depressed)",{"$f":"LINEST(BH134:BK134,$BH$132:$BK$132^ROW($1:$3),TRUE,FALSE)","v":-4.5845859108705663E-5},3.0678805067879972E-3,-5.3157025214450426E-2,0.8440662120542235]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,"CDOT Type D (In Series)",{"$f":"LINEST(BH135:BK135,$BH$132:$BK$132^ROW($1:$3),TRUE,FALSE)","v":-3.3957236250131803E-5},2.3915145562992896E-3,-4.1188082700790898E-2,0.78012475910792489]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDOT Type D (In Series & Depressed)",{"$f":"LINEST(BH136:BK136,$BH$132:$BK$132^ROW($1:$3),TRUE,FALSE)","v":-3.9489685825517465E-5},2.6947656143158326E-3,-4.3152149039227768E-2,0.71549693558155503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDOT TYPE D (Parallel)",{"$f":"LINEST(BH137:BK137,$BH$132:$BK$132^ROW($1:$3),TRUE,FALSE)","v":-1.8599009400589854E-5},1.7874951944540549E-3,-3.6605549253208781E-2,0.75590498248727245]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDOT TYPE D (Parallel & Depressed)",{"$f":"LINEST(BH138:BK138,$BH$132:$BK$132^ROW($1:$3),TRUE,FALSE)","v":-7.6669917992491658E-6},1.3307881651787104E-3,-3.0556750695886915E-2,0.68015568224024747]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Storm Msg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Storm Msg"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VLOOKUP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INLET_TYPE","Angle","Width","Length","A ratio","Box height","Cf","Cd","Co","Cw","Row"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CDOT Type C",{"$f":"IF($E$79=\"\",\"\",$E$79)","v":""},3,3,0.7,{"$f":"BF156*SIN(BD156/180*PI())","v":{"$error":"#VALUE!"}},0.5,{"$f":"(BH141*(BD156^3))+(BI141*(BD156^2))+(BJ141*BD156)+BK141","v":{"$error":"#VALUE!"}},{"$f":"BJ156*(2/3)","v":{"$error":"#VALUE!"}},{"$f":"BJ156*(4/15)*64.4^0.5","v":{"$error":"#VALUE!"}},1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"CDOT Type C (Depressed)","",3,3,0.7,{"$error":"#VALUE!"},0.5,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"CDOT Type D (In Series)","",3,6,0.7,{"$error":"#VALUE!"},0.375,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"CDOT Type D (In Series & Depressed)","",3,6,0.7,{"$error":"#VALUE!"},0.375,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"CDOT TYPE D (Parallel)","",6,3,0.7,{"$error":"#VALUE!"},0.375,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"CDOT TYPE D (Parallel & Depressed)","",6,3,0.7,{"$error":"#VALUE!"},0.375,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"User-Defined","",{"$f":"IF($E$80=\"\",\"\",$E$80)","v":""},{"$f":"IF($E$81=\"\",\"\",$E$81)","v":""},{"$f":"IF($E$82=\"\",\"\",$E$82)","v":""},{"$error":"#VALUE!"},{"$f":"IF($E$84=\"\",\"\",$E$84)","v":""},"N/A",{"$f":"IF($E$86=\"\",\"\",$E$86)","v":""},{"$f":"IF($E$87=\"\",\"\",$E$87)","v":""},7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRATE TYPE =",{"$f":"IF(GrateTypeNum=\"\",\"\",INDEX($BB$156:$BC$162,MATCH(GrateTypeNum,$BB$156:$BB$162,0),2))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRATE TYPE NUMBER = "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"COUNTA(D77,E79:E87)","v":1},"Count of input cells for Inlet Capacity",null,null,"=IF(BC163=\"\",0,VLOOKUP(BC163,$BC$156:$BM$162,11,FALSE))"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MINOR","MAJOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d =",{"$f":"D91","v":""},{"$f":"E91","v":""},"ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"E79","v":0},{"$f":"BA171","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W = ",0,{"$f":"BA172","v":0},"ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L = ",0,0,"ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARATIO = ",0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HB = ",0,0,"ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cf = ",0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cd = ",0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Co = ",0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cw = ",0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X =",{"$f":"D94","v":""},{"$f":"E94","v":""},"ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"θ = 0","Qws",{"$f":"(2/3)*$BA$174*(15*$BA$179/(4*(64.4^0.5)))*$BA$173*(64.4^0.5)*$BA$170^1.5","v":{"$error":"#VALUE!"}},{"$f":"(2/3)*$BB$174*(15*BB179/(4*(64.4^0.5)))*$BB$173*(64.4^0.5)*$BB$170^1.5","v":{"$error":"#VALUE!"}},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d < HB","Qws",{"$f":"(4/15)*$BA$174*(15*$BA$179/(4*(64.4^0.5)))*$BA$180*COS($BA$171/180*PI())*(64.4^0.5)*$BA$170^1.5","v":{"$error":"#VALUE!"}},{"$f":"(4/15)*$BB$174*(15*$BB$179/(4*(64.4^0.5)))*$BB$180*COS($BB$171/180*PI())*(64.4^0.5)*$BB$170^1.5","v":{"$error":"#VALUE!"}},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d >= HB","Qws",{"$f":"(4/15)*$BA$174*(15*$BA$179/(4*(64.4^0.5)))*$BA$173*COS($BA$171/180*PI())*(64.4^0.5)*($BA$170^1.5)*(($BA$170^2.5)-($BA$170-$BA$175)^2.5)/(($BA$170^1.5)*$BA$175)","v":{"$error":"#VALUE!"}},{"$f":"(4/15)*$BB$174*(15*$BB$179/(4*(64.4^0.5)))*$BB$173*COS($BB$171/180*PI())*(64.4^0.5)*($BB$170^1.5)*(($BB$170^2.5)-($BB$170-$BB$175)^2.5)/(($BB$170^1.5)*$BB$175)","v":{"$error":"#VALUE!"}},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SELECTED","Qws",{"$f":"IF(BA171=0,BA181,IF(BA170<BA175,BA182,BA183))","v":{"$error":"#VALUE!"}},{"$f":"IF(BB171=0,BB181,IF(BB170<BB175,BB182,BB183))","v":{"$error":"#VALUE!"}},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qwb",{"$f":"(2/3)*(64.4^0.5)*(15*$BA$179/(4*(64.4^0.5)))*$BA$172*$BA$170^1.5","v":{"$error":"#VALUE!"}},{"$f":"(2/3)*(64.4^0.5)*(15*$BB$179/(4*(64.4^0.5)))*$BB$172*$BB$170^1.5","v":{"$error":"#VALUE!"}},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SELECTED","Qwb",{"$f":"IF(BA170<0,0,BA185)","v":{"$error":"#VALUE!"}},{"$f":"IF(BB170<0,0,BB185)","v":{"$error":"#VALUE!"}},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HB = 0","Qo",{"$f":"(2/3)*BA$174*(1.5*$BA$178)*BA$172*BA$173*(64.4*BA$170)^0.5","v":{"$error":"#VALUE!"}},{"$f":"(2/3)*BB$174*(1.5*$BB$178)*BB$172*BB$173*(64.4*BB$170)^0.5","v":{"$error":"#VALUE!"}},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d < HB","Qo",{"$f":"(2/3)*BA$174*(1.5*$BA$178)*BA$172*BA$180*COS(BA$171/180*PI())*(64.4*BA$170)^0.5","v":{"$error":"#VALUE!"}},{"$f":"(2/3)*BB$174*(1.5*$BB$178)*BB$172*BB$180*COS(BB$171/180*PI())*(64.4*BB$170)^0.5","v":{"$error":"#VALUE!"}},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d >= HB","Qo",{"$f":"(2/3)*(1.5*$BA$178)*BA$172*BA$180*COS(BA$171/180*PI())*(64.4*BA$170)^0.5","v":{"$error":"#VALUE!"}},{"$f":"(2/3)*(1.5*$BB$178)*BB$172*BB$180*COS(BB$171/180*PI())*(64.4*BB$170)^0.5","v":{"$error":"#VALUE!"}},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SELECTED","Qo",{"$f":"IF(BA175=0,BA187,IF(BA170<BA175,BA188,BA189))","v":{"$error":"#VALUE!"}},{"$f":"IF(BB175=0,BB187,IF(BB170<BB175,BB188,BB189))","v":{"$error":"#VALUE!"}},"cfs"]