{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Intro","Q-Peak","Inlet Management","Inlet Pictures","Street Inlet","Area Inlet"],"not_rendered":{"charts":0,"images":58,"macros":1,"external_links":0,"defined_names":267,"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":[[27,2,29,9],[31,2,34,9],[36,2,37,9],[1,1,1,9],[0,1,0,9],[23,2,25,9],[2,1,3,10],[4,1,4,10],[5,1,5,10],[6,1,6,10],[7,1,7,10]]}
[" ",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,"STREET AND INLET HYDRAULICS WORKBOOK"]
[]
[null,"MHFD-Inlet, Version 5.01 (April 2021)"]
[null,"Mile High Flood District"]
[null,"Denver, Colorado"]
[null,"www.mhfd.org"]
[]
[null,"Purpose:","This workbook can be used to size a variety of inlets based on allowable spread and depth"]
[null,null,"in a street or swale."]
[]
[null,"Function:","1.  To calculate peak discharge for the tributary area to each inlet."]
[]
[null,null,"2.  To calculate allowable half-street capacity based on allowable depth and spread."]
[]
[null,null,"3.  To determine the inlet capacity for selected inlet types."]
[]
[null,null,"4.  To manage inlet information and connect inlets in series to account for bypass flow."]
[]
[]
[null,"Content:","The workbook consists of the following sheets:"]
[]
[null,"Q-Peak","Calculates the peak discharge for the inlet tributary area based on the Rational Method for the minor and major storm events.  Alternatively, the user can enter a known flow.  Information from this sheet is then exported to the Inlet Management sheet.\n"]
[]
[]
[]
[null,"Inlet Management","Imports information from the Q-Peak sheet and Inlet [#] sheets and can be used to connect inlets in series so that bypass flow from an upstream inlet is added to flow calculated for the next downstream inlet.  This sheet can also be used to modify design information from the Q-peak sheet."]
[]
[]
[]
[null,"Inlet [#]","Inlet [#] sheets are created each time the user exports information from the Q-Peak sheet to the Inlet Management sheet.  The Inlet [#] sheets calculate allowable half-street capacity based on allowable depth and allowable spread for the minor and major storm events.  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 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,"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":"Q-Peak","index":1,"n_rows":148,"n_cols":57,"rows_kept":148,"cut":false,"hidden":false,"merged":[[1,1,2,9],[5,2,5,9],[16,10,18,11],[3,1,3,9],[20,1,20,3],[12,10,14,11],[6,2,6,7]]}
[null,null,null,null,null,null,null,null,null,null,null,"Worksheet Protected"]
[null,"DESIGN PEAK FLOW FOR SWALE OR\nONE-HALF OF STREET BY THE RATIONAL METHOD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Return Period"]
[null,{"$f":"Intro!B5","v":"MHFD-Inlet, Version 5.01 (April 2021)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UrbanFlag",null,null,null,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,"StreetFlag",null,null,null,5]
[null,"Project:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(H14:I14)","v":0},"Qpeak_Qdata_Flag",null,null,null,10]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(QPeak_QData_Flag=2,AND(DesignQ_Minor<>\"\",DesignQ_Major<>\"\")),1,0)","v":0},"UserQ_Flag",null,null,null,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,null,{"$f":"IF(AND(QPeak_QData_Flag>0,QPeak_DataEntry_NoButtons_Flag>0),\"You cannot enter values for Q and use the Q calculator at the same time\",\"\")","v":""},"Flag_bothSections_Warning",null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(H26:H30)","v":0},"Count_Rainfall_Minor",null,null,null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(I26:I30)","v":0},"Count_Rainfall_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,{"$f":"IF(AND(UrbanFlag=1,Overland_Length>300),1,IF(AND(UrbanFlag=2,Overland_Length>500),2,0))","v":0},"Flag_OverlandFlow",null,null,null,"Soil 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,null,null,null,null,null,null,null,{"$f":"COUNTA(I17:I19,H22:I23,H26:I30,AZ4:AZ5)","v":0},"QPeak_DataEntry_Flag",null,null,null,"A"]
[null,"Design Flow:","ONLY if already determined through other methods",null,null,null,null,"Minor Storm","Major Storm",null,"FILL IN \nTHIS SECTION\n<---",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(I17:I19,H22:I23,H26:I30)","v":0},"QPeak_DataEntry_NoButtons_Flag",null,null,null,"B"]
[null,null,"   (local peak flow for 1/2 of street  OR  grass-lined channel):",null,null,null,"*QKnown =",null,null,"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,{"$f":"IF(AND(OR(UrbanFlag=\"\",StreetFlag=\"\"),AND(QPeak_DataEntry_Flag>8,QPeak_DataEntry_Flag<19)),1,0)","v":0},"OptionButton_Flag",null,null,null,"C"]
[null,"*If you enter flows in Row 14, select \"Street Inlet\" or \"Area Inlet\" button, skip the rest of this sheet, and click \"Add New Inlet\" at bottom.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(Minor_Ccalc<>\"\",Major_Ccalc<>\"\"),1,0)","v":0},"RunoffCoeff_Flag",null,null,null,"D"]
[null,"Geographic Information:",null,"Enter data in the blue cells",null,null,null,null,null,null,"OR…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(H14:I14)","v":0},"Number_Qs"]
[null,{"$f":"IF(QPeak_Area<=90,\"\",\"*NOTE: For Areas > 90 acres, CUHP hydrograph and routing are recommended.\")","v":""},null,null,null,null,null,"Subcatchment Area =",null,"acres","FILL IN THE SECTIONS BELOW.\n<---"]
[null,{"$f":"Flag_bothSections_Warning","v":""},null,null,null,null,null,"Percent Imperviousness =",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(Minor_C<>\"\",Minor_C,Minor_Cuser)","v":0},"QPeak_UserC_Minor",null,null,null,"Minor_Cuser"]
[null,{"$f":"IF(OptionButton_Flag=0,\"\",\"NOTE: Option Buttons must be selected in order to calculate Peak Flows\")","v":""},null,null,null,null,null,"NRCS Soil Type =",null,"A, B, C, or D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(Major_C<>\"\",Major_C,Major_Cuser)","v":0},"Qpeak_UserC_Major",null,null,null,"Major_Cuser"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(Minor_C5<>\"\",Minor_C5,Minor_C5user))","v":0},"QPeak_UserC5_Minor",null,null,null,"Minor_C5user"]
[null,null,null,null,null,null," ","Slope (ft/ft)","Length (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,{"$f":"IF(Major_C5<>\"\",Major_C5,Major_C5user)","v":0},"Qpeak_UserC5_Major",null,null,null,"Major_C5user"]
[null,null,null,null,null,null,"Overland Flow ="]
[null,null,null,null,null,null,{"$f":"IF(StreetFlag = 1, \"Gutter Flow =\",\"Channel Flow =\")","v":"Channel Flow ="},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User_Tc_Minor"]
[null,{"$f":"IF(Flag_OverlandFlow=1,\nIF(Overland_Length>300,\"NOTE: Overland flow length exceeds recommended limit of 300' for an urban setting.\",\"\"),\nIF(Overland_Length>500,\"NOTE: Overland flow length exceeds recommended limit of 500' for a rural setting.\",\"\"))","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,"User_Tc_Major"]
[null,"Rainfall Information:",null,"Intensity, I (inch/hr) = C1 * P1 / ( C2 + Tc ) ^ C3",null,null,null,"Minor Storm","Major Storm"]
[null,"Design Storm Return Period",null,null,null,null,"Tr =",null,null,"years"]
[null,"Return Period One-Hour Precipitation",null,null,null,null,"P1 =",null,null,"inches"]
[null,null,null,null,null,null,"C1 ="]
[null,null,null,null,null,null,"C2 ="]
[null,null,null,null,null,null,"C3 ="]
[null,"User-Defined Storm Runoff Coefficient (leave blank to accept calculated value)",null,null,null,null,"C ="]
[null,"User-Defined 5-yr. Runoff Coefficient (leave blank to accept calculated value)",null,null,null,null,"C5 ="]
[null,"Bypass (Carry-Over) Flow from upstream Subcatchments",null,null,null,null,"Qb =",null,null,"cfs"]
[null,null," "]
[null,"Analysis of Flow Time (Time of Concentration) for a Catchment:",null,null,null,null,null,"Minor Storm","Major Storm"]
[null,"Calculated Design Storm Runoff Coefficient",null,null,null,null,"C =",{"$f":"IF(Qminor=\"\",IF(Minor_Cuser=\"\",\"\",QPeak_UserC_Minor),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(Major_Cuser=\"\",\"\",QPeak_UserC_Major),\"N/A\")","v":""}]
[null,"Calculated 5-yr. Runoff Coefficient",null,null,null,null,"C5 =",{"$f":"IF(Qminor=\"\",IF(Minor_C5user=\"\",\"\",QPeak_UserC5_Minor),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(Major_C5user=\"\",\"\",Qpeak_UserC5_Major),\"N/A\")","v":""}]
[null,"Overland Flow Velocity",null,null,null,null,"Vi =",{"$f":"IF(Qminor=\"\",IF($H$40=\"\",\"\",Overland_Length/(60*Ti_minor)),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF($I$40=\"\",\"\",Overland_Length/(60*Ti_major)),\"N/A\")","v":""},"fps"]
[null,{"$f":"IF(StreetFlag = 1, \"Gutter Flow Velocity\",\"Channel Flow Velocity\")","v":"Channel Flow Velocity"},null,null,null,null,"Vt =",{"$f":"IF(Qminor=\"\",IF(Minor_C5calc=\"\",\"\",IF(StreetFlag=1,20*Channel_Slope^0.5,15*Channel_Slope^0.5)),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(Major_C5calc=\"\",\"\",IF(StreetFlag=1,20*Channel_Slope^0.5,15*Channel_Slope^0.5)),\"N/A\")","v":""},"fps"]
[null,"Overland Flow Time",null,null,null,null,"Ti =",{"$f":"IF(Qminor=\"\",IF(Minor_C5calc=\"\",\"\",0.395*(1.1-IF(Minor_C5=\"\",Minor_C5calc,Minor_C5))*Overland_Length^0.5/Overland_Slope^0.33),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(Major_C5calc=\"\",\"\",0.395*(1.1-IF(Major_C5=\"\",Major_C5calc,Major_C5))*Overland_Length^0.5/Overland_Slope^0.33),\"N/A\")","v":""},"minutes"]
[null,{"$f":"IF(StreetFlag=1, \"Gutter Travel Time\",\"Channel Travel Time\")","v":"Channel Travel Time"},null,null,null,null,"Tt =",{"$f":"IF(Qminor=\"\",IF(Vt_minor=\"\",\"\",Channel_Length/(60*Vt_minor)),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(Vt_major=\"\",\"\",Channel_Length/(60*Vt_major)),\"N/A\")","v":""},"minutes"]
[null,"Calculated Time of Concentration",null,null,null,null,"Tc, Calc =",{"$f":"IF(Qminor=\"\",IF(Ti_minor=\"\",\"\",ROUND(SUM(Ti_minor,Tt_minor),2)),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(Ti_major=\"\",\"\",ROUND(SUM(Ti_major,Tt_major),2)),\"N/A\")","v":""},"minutes"]
[null,"Time of Concentration by Regional Formula",null,null,null,null,"Tc, Regional Formula =",{"$f":"IF(Qminor=\"\",IF(Minor_C5calc=\"\",\"\",ROUND(((26-0.17*Qpeak_Imp)+(Channel_Length/(60*(0.14*Qpeak_Imp+9)*SQRT(Channel_Slope)))),2)),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(Major_C5calc=\"\",\"\",ROUND(((26-0.17*Qpeak_Imp)+(Channel_Length/(60*(0.14*Qpeak_Imp+9)*SQRT(Channel_Slope)))),2)),\"N/A\")","v":""},"minutes"]
[null,"Recommended Tc",null,null,null,null,"Tc, Recommended =",{"$f":"IF(Qminor=\"\",IF(Tc_regional_minor=\"\",\"\",IF(UrbanFlag=1,(MAX(5,(MIN(Tc_calc_minor,Tc_regional_minor)))),(MAX(10,(MIN(Tc_calc_minor,Tc_regional_minor)))))),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(Tc_regional_major=\"\",\"\",IF(UrbanFlag=1,(MAX(5,(MIN(Tc_calc_major,Tc_regional_major)))),(MAX(10,(MIN(Tc_calc_major,Tc_regional_major)))))),\"N/A\")","v":""},"minutes"]
[null,"Time of Concentration Selected by User",null,null,null,null,"Tc, User =",{"$f":"IF(Qminor=\"\",IF(User_Tc_Minor=\"\",\"\",User_Tc_Minor),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(User_Tc_Major=\"\",\"\",User_Tc_Major),\"N/A\")","v":""},"minutes"]
[null,"Design Rainfall Intensity",null,null,null,null,"I =",{"$f":"IF(Qminor=\"\",IF(Tc_selected_minor=\"\",\"\",(Minor_C1*Precip_Minor/(Minor_C2+Tc_selected_minor)^Minor_C3)),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(Tc_selected_major=\"\",\"\",(Major_C1*Precip_Major/(Major_C2+Tc_selected_major)^Major_C3)),\"N/A\")","v":""},"inch/hr"]
[null,"Calculated Local Peak Flow",null,null,null,null,"Qp =",{"$f":"IF(Qminor=\"\",IF(I_minor=\"\",\"\",(IF(Minor_C=\"\",(Minor_Ccalc*I_minor*QPeak_Area),(Minor_C*I_minor*QPeak_Area)))),\"N/A\")","v":""},{"$f":"IF(Qmajor=\"\",IF(I_major=\"\",\"\",(IF(Major_C=\"\",(Major_Ccalc*I_major*QPeak_Area),(Major_C*I_major*QPeak_Area)))),\"N/A\")","v":""},"cfs"]
[null,"Total Design Peak Flow",null,null,null,null,"Q =",{"$f":"IF(Qminor=\"\",IF(LocalQ_minor=\"\",\"\",LocalQ_minor+Bypass_Minor),Qminor+Bypass_Minor)","v":""},{"$f":"IF(Qmajor=\"\",IF(LocalQ_major=\"\",\"\",LocalQ_major+Bypass_Major),Qmajor+Bypass_Major)","v":""},"cfs"]
[]
[]
[]
[null,null,null,null,null," "]
[null,{"$f":"IF(AND(Minor_C=\"\",Major_C=\"\",Minor_C5=\"\",Major_C5=\"\"),\"\",\nIF(AND(Minor_C<>\"\",Major_C<>\"\",Minor_C5<>\"\",Major_C5<>\"\"),\"NOTE: For the MINOR STORM and MAJOR STORM, calculated values for Tc and Qp are based on override values entered for C and C5.\",\nIF(AND(Minor_C<>\"\",Major_C<>\"\",Minor_C5=\"\",Major_C5=\"\"),\"NOTE: For the MINOR STORM and MAJOR STORM, calculated values for Tc and Qp are based on override values entered for C.\",\nIF(AND(Minor_C=\"\",Major_C=\"\",Minor_C5<>\"\",Major_C5<>\"\"),\"NOTE: For the MINOR STORM and MAJOR STORM, calculated values for Tc and Qp are based on override values entered for C5.\",\nIF(AND(Minor_C<>\"\",Major_C=\"\",Minor_C5<>\"\",Major_C5=\"\"),\"NOTE: For the MINOR STORM, calculated values for Tc and Qp are based on override values entered for C and C5.\",\nIF(AND(Minor_C=\"\",Major_C<>\"\",Minor_C5=\"\",Major_C5<>\"\"),\"NOTE: For the MAJOR STORM, calculated values for Tc and Qp are based on override values entered for C and C5.\",\nIF(AND(Minor_C<>\"\",Major_C=\"\",Minor_C5=\"\",Major_C5=\"\"),\"NOTE: For the MINOR STORM, calculated values for Tc and Qp are based on override values entered for C.\",\nIF(AND(Minor_C=\"\",Major_C<>\"\",Minor_C5=\"\",Major_C5=\"\"),\"NOTE: For the MAJOR STORM, calculated values for Tc and Qp are based on override values entered for C.\",\nIF(AND(Minor_C=\"\",Major_C=\"\",Minor_C5<>\"\",Major_C5=\"\"),\"NOTE: For the MINOR STORM, calculated values for Tc and Qp are based on override values entered for C5.\",\nIF(AND(Minor_C=\"\",Major_C=\"\",Minor_C5=\"\",Major_C5<>\"\"),\"NOTE: For the MAJOR STORM, calculated values for Tc and Qp are based on override values entered for C5.\",\n\"NOTE: For the MINOR and/or MAJOR STORM, calculated values for Tc and Qp are based on override values entered for C and/or C5.\"))))))))))","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,"Stores User Input"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","Major Storm",null,null,"Urban Flag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Flag"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Tc Minor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subcatchment Area =",null,null,null,"User Tc 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,null,"Percent Imperviousness ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NRCS Soil 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,null,null,null,null,null,null,null,null,"Slope (ft/ft)","Length (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,null,"Minor Storm","Major Storm"]

{"sheet":"Inlet Management","index":2,"n_rows":88,"n_cols":5,"rows_kept":88,"cut":false,"hidden":false,"merged":[[1,2,2,2]]}
[null,null,{"$f":"Intro!B5","v":"MHFD-Inlet, Version 5.01 (April 2021)"}]
[null,null,"INLET MANAGEMENT"]
[]
[null,null,"Worksheet Protected"]
[]
[null,null,"INLET NAME","No Bypass Flow Received","User-Defined"]
[null,null,"Site Type (Urban or Rural)"]
[null,null,"Inlet Application (Street or Area)"]
[null,null,"Hydraulic Condition"]
[null,null,"Inlet Type"]
[]
[null,"USER-DEFINED INPUT"]
[null,null,"User-Defined Design Flows"]
[null,null,"Minor QKnown (cfs)"]
[null,null,"Major QKnown (cfs)"]
[]
[null,null,"Bypass (Carry-Over) Flow from Upstream"]
[null,null,"Receive Bypass Flow from:"]
[null,null,"Minor Bypass Flow Received, Qb (cfs)"]
[null,null,"Major Bypass Flow Received, Qb (cfs)"]
[]
[null,null,"Watershed Characteristics"]
[null,null,"Subcatchment Area (acres)"]
[null,null,"Percent Impervious"]
[null,null,"NRCS Soil Type"]
[]
[null,null,"Watershed Profile"]
[null,null,"Overland Slope (ft/ft)"]
[null,null,"Overland Length (ft)"]
[null,null,"Channel Slope (ft/ft)"]
[null,null,"Channel Length (ft)"]
[]
[null,null,"Minor Storm Rainfall Input"]
[null,null,"Design Storm Return Period, Tr (years)"]
[null,null,"One-Hour Precipitation, P1 (inches)"]
[null,null,"C1"]
[null,null,"C2"]
[null,null,"C3"]
[null,null,"User-defined C"]
[null,null,"User-defined 5-yr C5"]
[null,null,"User-defined Tc"]
[]
[null,null,"Major Storm Rainfall Input"]
[null,null,"Design Storm Return Period, Tr (years)"]
[null,null,"One-Hour Precipitation, P1 (inches)"]
[null,null,"C1"]
[null,null,"C2"]
[null,null,"C3"]
[null,null,"User-defined C"]
[null,null,"User-defined 5-yr C5"]
[null,null,"User-defined Tc"]
[]
[]
[]
[null,"CALCULATED OUTPUT"]
[]
[null,null,"Minor Total Design Peak Flow, Q (cfs)"]
[null,null,"Major Total Design Peak Flow, Q (cfs)"]
[null,null,"Minor Flow Bypassed Downstream, Qb (cfs)"]
[null,null,"Major Flow Bypassed Downstream, Qb (cfs)"]
[]
[null,null,"Minor Storm (Calculated) Analysis of Flow Time"]
[null,null,"C"]
[null,null,"C5"]
[null,null,"Overland Flow Velocity, Vi"]
[null,null,"Channel Flow Velocity, Vt"]
[null,null,"Overland Flow Time, Ti"]
[null,null,"Channel Travel Time, Tt"]
[null,null,"Calculated Time of Concentration, Tc"]
[null,null,"Regional Tc"]
[null,null,"Recommended Tc"]
[null,null,"Tc selected by User"]
[null,null,"Design Rainfall Intensity, I"]
[null,null,"Calculated Local Peak Flow, Qp"]
[]
[null,null,"Major Storm (Calculated) Analysis of Flow Time"]
[null,null,"C"]
[null,null,"C5"]
[null,null,"Overland Flow Velocity, Vi"]
[null,null,"Channel Flow Velocity, Vt"]
[null,null,"Overland Flow Time, Ti"]
[null,null,"Channel Travel Time, Tt"]
[null,null,"Calculated Time of Concentration, Tc"]
[null,null,"Regional Tc"]
[null,null,"Recommended Tc"]
[null,null,"Tc selected by User"]
[null,null,"Design Rainfall Intensity, I"]
[null,null,"Calculated Local Peak Flow, Qp"]

{"sheet":"Inlet Pictures","index":3,"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":4,"n_rows":1176,"n_cols":134,"rows_kept":1176,"cut":false,"hidden":true,"merged":[[149,1,149,5],[150,1,150,5],[163,3,163,4],[71,50,71,52],[72,1,72,5],[74,1,74,5],[75,1,75,5],[88,3,88,4],[0,1,0,5],[148,1,148,5],[73,1,73,5],[1,1,1,5],[3,1,3,5],[4,1,4,5],[63,1,63,5],[60,1,60,5],[2,1,2,5],[64,1,64,5],[147,1,147,5]]}
[null,{"$f":"Intro!B5","v":"MHFD-Inlet, Version 5.01 (April 2021)"},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)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First Activation Check for Worksheet_Activate Routine"]
["Project:",{"$f":"IF(Qpeak_Project=\"\",\"\",Qpeak_Project)","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,"Safety Factor Boolean",0]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Street Input Count",{"$f":"COUNTA(D19:D25)","v":1}]
[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}]
[null,null,null,null,null,null,null,null,null,null,null,"Q-Peak",null,null,null,null,null,null,null,null,null,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,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,"Safety Factor Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qpeak Minor",{"$f":"'Q-Peak'!H48","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,"Qpeak Major",{"$f":"'Q-Peak'!I48","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,"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,null,"Minor","Major"]
[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,"Check if user input is complete:",{"$f":"IF(AND(ISNUMBER(D19),ISNUMBER(D20),ISNUMBER(D21),ISNUMBER(D22),ISNUMBER(D23),ISNUMBER(D24),ISNUMBER(D25),ISNUMBER(D28),ISNUMBER(D29)),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISNUMBER(D19),ISNUMBER(D20),ISNUMBER(D21),ISNUMBER(D22),ISNUMBER(D23),ISNUMBER(D24),ISNUMBER(D25),ISNUMBER(E28),ISNUMBER(E29)),TRUE,FALSE)","v":false}]
[null,"Maximum Allowable Width for Spread Behind Curb","TBACK =",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,"Max Allowable Depth"]
[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,"Check for Flow Depth at Crown",false,false]
[{"$f":"IF(D17=\"\",\"\",IF(OR(D17<0.012,D17>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,"Total Discharge Pre-Safety Factor",0,0]
[]
[null,"Height of Curb at Gutter Flow Line","HCURB =",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,"Width Behind Curb (leave blank for no conveyance credit behind curb)"]
[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,"Side Slope Behind Curb (leave blank for no conveyance credit behind curb)"]
[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,"Manning's Roughness Behind Curb"]
[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,"Distance from Curb Face to Street Crown"]
[{"$f":"IF(D25=\"\",\"\",IF(OR(D25<0.012,D25>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,"Gutter Width"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gutter Depression"]
[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,"Street Transverse Slope"]
[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,"Gutter Cross Slope"]
[{"$f":"IF(D19-D29<0,\"Warning 02\",\"\")","v":""},"Max. Allowable Depth at Gutter Flowline for Minor & Major Storm","dMAX =",null,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,"Street Longitudinal Slope"]
[null,{"$f":"IF(OR(D24=\"\",D24>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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manning's Roughness for Street Section "]
[]
[null,"Maximum Capacity for 1/2 Street based On Allowable Spread",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,"Max. Allowable Depth at Gutter Flow Line for Major & Minor Storm"]
[null,"Water Depth without Gutter Depression (Eq. ST-2)","y =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",(D28*D22)*12)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",(E28*D22)*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,null,"Max. Allowable Water Spread for Major & Minor Storm"]
[null,"Vertical Depth between Gutter Lip and Gutter Flowline (usually 2\")","dC =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",(D21*D23)*12)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",(D21*D23)*12)","v":""},"inches"]
[null,"Gutter Depression (dC - (W * Sx * 12))","a =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",(D21*12*(D23-D22)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",(D21*12*(D23-D22)))","v":""},"inches"]
[null,"Water Depth at Gutter Flowline","d =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",(D33+D35))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",(E33+E35))","v":""},"inches"]
[null,"Allowable Spread for Discharge outside the Gutter Section W (T - W)","TX =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",(D28-D21))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",(E28-D21))","v":""},"ft"]
[null,"Gutter Flow to Design Flow Ratio by FHWA HEC-22 method (Eq. ST-7)","EO =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D28<=D21,1,(1/((1+((D23/D22)/((1+((D23/D22)/((D28/D21)-1)))^(8/3)-1)))))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(E28<=D21,1,(1/((1+((D23/D22)/((1+((D23/D22)/((E28/D21)-1)))^(8/3)-1)))))))","v":""}]
[null,"Discharge outside the Gutter Section W, carried in Section TX","QX =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",(IF(D28=\"\",\"\",0.56/D25*D22^(5/3)*D37^(8/3)*D24^0.5)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",0.56/D25*D22^(5/3)*E37^(8/3)*D24^0.5)","v":""},"cfs"]
[null,"Discharge within the Gutter Section W (QT - QX)","QW =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D42=\"SUMP\",0,IF(D28<=D21,0.56/D25*D23^(5/3)*D24^0.5*D28^(8/3),(D42-D41-D39))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(E42=\"SUMP\",0,IF(E28<=D21,0.56/D25*D23^(5/3)*D24^0.5*E28^(8/3),(E42-E41-E39))))","v":""},"cfs"]
[null,"Discharge Behind the Curb (e.g., sidewalk, driveways, & lawns)","QBACK =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D17=\"\",0,(IF(D16=\"\",0,(IF(D15=\"\",0,IF(D36>D19,IF(D15>=(D36-D19)/12/D16,0.56/D17*D16^(5/3)*((D36-D19)/12/D16)^(8/3)*D24^0.5,0.56/D17*D16^(5/3)*(((D36-D19)/12/D16)^(8/3)-((D36-D19)/12/D16-D15)^(8/3))*D24^0.5),0)))))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(D17=\"\",0,(IF(D16=\"\",0,(IF(D15=\"\",0,IF(E36>D19,IF(D15>=(E36-D19)/12/D16,0.56/D17*D16^(5/3)*((E36-D19)/12/D16)^(8/3)*D24^0.5,0.56/D17*D16^(5/3)*(((E36-D19)/12/D16)^(8/3)-((E36-D19)/12/D16-D15)^(8/3))*D24^0.5),0)))))))","v":""},"cfs"]
[null,"Maximum Flow Based On Allowable Spread","QT =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D24=0,\"SUMP\",IF(D28<=D21,0.56/D25*D23^(5/3)*D24^0.5*D28^(8/3),(D39/(1-D38))+D41)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(D24=0,\"SUMP\",IF(E28<=D21,0.56/D25*D23^(5/3)*D24^0.5*E28^(8/3),(E39/(1-E38))+E41)))","v":""},"cfs"]
[null,"Flow Velocity within the Gutter Section","V =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",D40/(D36/12+(D36/12-D21*D23))/2*D21)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",E40/(E36/12+(E36/12-D21*D23))/2*D21)","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,\"\",((D29-D35)/12/D22))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",((E29-E35)/12/D22))","v":""},"ft"]
[null,"Theoretical Spread for Discharge outside the Gutter Section W (T - W)","TX TH =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",MAX(0,(D47-D21)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",MAX(0,(E47-D21)))","v":""},"ft"]
[null,"Gutter Flow to Design Flow Ratio by FHWA HEC-22 method (Eq. ST-7)","EO =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D21>=D47,1,(1/((1+((D23/D22)/((1+((D23/D22)/((D47/D21)-1)))^(8/3)-1)))))))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(D21>=E47,1,(1/((1+((D23/D22)/((1+((D23/D22)/((E47/D21)-1)))^(8/3)-1)))))))","v":""}]
[null,"Theoretical Discharge outside the Gutter Section W, carried in Section TX TH","QX TH =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",0.56/D25*D22^(5/3)*D48^(8/3)*D24^0.5)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",0.56/D25*D22^(5/3)*E48^(8/3)*D24^0.5)","v":""},"cfs"]
[null,"Actual Discharge outside the Gutter Section W, (limited by distance TCROWN)","QX =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",0.56/D25*D22^(5/3)*D24^0.5*(D48^(8/3)-MAX(D47-D20,0)^(8/3)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",0.56/D25*D22^(5/3)*D24^0.5*(E48^(8/3)-MAX(E47-D20,0)^(8/3)))","v":""},"cfs"]
[null,"Discharge within the Gutter Section W (Qd - QX)","QW =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D47<=D21,0.56/D25*D23^(5/3)*D24^0.5*D47^(8/3),(D50/(1-D49)-D50)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(E47<=D21,0.56/D25*D23^(5/3)*D24^0.5*E47^(8/3),(E50/(1-E49)-E50)))","v":""},"cfs"]
[null,"Discharge Behind the Curb (e.g., sidewalk, driveways, & lawns)","QBACK =",{"$f":"IF(D52=\"\",\"\",IF(D17=\"\",0,IF(D16=\"\",0,IF(D15=\"\",0,IF(D29>D19,IF(D15>=(D29-D19)/12/D16,0.56/D17*D16^(5/3)*((D29-D19)/12/D16)^(8/3)*D24^0.5,0.56/D17*D16^(5/3)*(((D29-D19)/12/D16)^(8/3)-((D29-D19)/12/D16-D15)^(8/3))*D24^0.5),0)))))","v":""},{"$f":"IF(E52=\"\",\"\",IF(D17=\"\",0,IF(D16=\"\",0,IF(D15=\"\",0,IF(E29>D19,IF(D15>=(E29-D19)/12/D16,0.56/D17*D16^(5/3)*((E29-D19)/12/D16)^(8/3)*D24^0.5,0.56/D17*D16^(5/3)*(((E29-D19)/12/D16)^(8/3)-((E29-D19)/12/D16-D15)^(8/3))*D24^0.5),0)))))","v":""},"cfs"]
[null,"Total Discharge for Major & Minor Storm (Pre-Safety Factor)","Q =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D21>=D47,0.56/D25*D23^(5/3)*D47^(8/3)*D24^0.5,IF(D47>D20,D51+D52+D53,D50/(1-D49)+D53)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(D21>=E47,0.56/D25*D23^(5/3)*E47^(8/3)*D24^0.5,IF(E47>D20,E51+E52+E53,E50/(1-E49)+E53)))","v":""},"cfs"]
[null,"Average Flow Velocity Within the Gutter Section","V =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",D52/(D29/12+(D29/12-D21*D23))/2*D21)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",E52/(E29/12+(E29/12-D21*D23))/2*D21)","v":""},"fps"]
[null,"V*d Product: Flow Velocity Times Gutter Flowline Depth","V*d =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",D55*D29/12)","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(E54=\"\",\"\",E55*E29/12))","v":""}]
[null,"Slope-Based Depth Safety Reduction Factor for Major & Minor (d > 6\") Storm ","R =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D24=0,\"SUMP\",IF(D28=\"\",\"\",AU17/D54)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(D24=0,\"SUMP\",IF(E29=\"\",\"\",AV17/E54)))","v":""}]
[null,{"$f":"IF(B61=\"WARNING - MHFD SAFETY FACTOR HAS BEEN BYPASSED\",\"Max Flow Based on Allowable Depth (NO SAFETY FACTOR)\",\"Max Flow Based on Allowable Depth (Safety Factor Applied)\")","v":"Max Flow Based on Allowable Depth (Safety Factor Applied)"},"Qd =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF(D57=\"SUMP\",\"SUMP\",AU17))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF(E57=\"SUMP\",\"SUMP\",AV17))","v":""},"cfs"]
[null,{"$f":"IF(B61=\"WARNING - MHFD SAFETY FACTOR HAS BEEN BYPASSED\",\"Resultant Flow Depth at Gutter Flowline (NO SAFETY FACTOR)\",\"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)\",\"Resultant Flow Depth at Street Crown (Safety Factor Applied)\")","v":"Resultant Flow Depth at Street Crown (Safety Factor Applied)"},"dCROWN =",null,null,"inches"]
[null,{"$f":"IF(AU8=\"\",IF(AU7=\"\",\"\",AU7),AU8)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21]
[null,{"$f":"IF(D63=D58,\"MINOR STORM Allowable Capacity is based on Depth Criterion\", \"MINOR STORM Allowable Capacity is based on Spread Criterion\")","v":"MINOR STORM Allowable Capacity is based on Depth Criterion"},null,"Minor Storm","Major Storm"]
[null,{"$f":"IF(E63=E58, \"MAJOR STORM Allowable Capacity is based on Depth Criterion\",\"MAJOR STORM Allowable Capacity is based on Spread Criterion\")","v":"MAJOR STORM Allowable Capacity is based on Depth Criterion"},"Qallow =",{"$f":"IF(Minor_Input_Complete_QAllow=FALSE,\"\",IF($D24=0,\"SUMP\",IF(AU16=FALSE,MIN(D58,D42),D58)))","v":""},{"$f":"IF(Major_Input_Complete_QAllow=FALSE,\"\",IF($D24=0,\"SUMP\",IF(AV16=FALSE,MIN(E58,E42),E58)))","v":""},"cfs"]
[null,{"$f":"IF(AU11=\"\",\"\",AU11)","v":""}]
[null,{"$f":"IF(AU12=\"\",\"\",AU12)","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(D19-D29<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,"No","Grate","Curb"]
[null,{"$f":"Intro!B5","v":"MHFD-Inlet, Version 5.01 (April 2021)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(E90: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,null,"INLET_TYPE","alocal","Lo G","Wo G","Cw  G","Co G","Nw G","Na G","K G","Lo C","Hvert C","Hthroat C","Theta C","Cw C","Co C","Nw C","Na C","K C","K Comb","Match?","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":"6+3-AZ127","v":9},5,"N/A","N/A","N/A","N/A","N/A","N/A",5,6,6,63.4,3.4,0.67,1,1,0.9,"N/A",12,"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","N/A",12,"CDOT/Denver 13 Valley Grate"]
[null,"Type of Inlet","Type =",{"$f":"IF(OnGrade_Type=\"\",\"\",OnGrade_Type)","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.3,0.6,1,1,0.9,0.35,11,"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",1,"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.4,0.66,1,1,0.9,"N/A",11,"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.3,0.66,1,1,0.85,0.2,11,"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","N/A","N/A",12,"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","N/A","N/A",1,"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","N/A","N/A",1,"Directional 45-Degree Bar Grate"]
[null,{"$f":"IF(D97=\"\",\"\",IF(D97<=AU125,IF(E97<=AV125,\"Street Hydraulics: OK - Q < Allowable Street Capacity'\",\"Street Hydraulics: WARNING: Q > ALLOWABLE Q FOR MAJOR STORM\"),IF(E97>AV125,\"Street Hydraulics: WARNING: Q > ALLOWABLE Q FOR MINOR & MAJOR STORM\",\"Street Hydraulics: WARNING: Q > ALLOWABLE Q FOR MINOR STORM'\")))","v":""},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","N/A","N/A",1,"Directional 30-Degree Bar Grate"]
[null,"Design Discharge for Half of Street (from Inlet Management)","Qo =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF(AZ126=\"\",\"\",AZ126))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(BA126=\"\",\"\",BA126))","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","N/A","N/A",1,"Reticuline Riveted Grate"]
[null,"Water Spread Width","T =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF(BK112=\"\",\"\",BK112))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(BL112=\"\",\"\",BL112))","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","N/A","N/A",1,"1-7/8\" Bar Grate, Crossbars @ 8\""]
[null,"Water Depth at Flowline (outside of local depression)","d =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF(BK113=\"\",\"\",BK113))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(BL113=\"\",\"\",BL113))","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","N/A","N/A",1,"1-7/8\" Bar Grate, Crossbars @ 4\""]
[null,"Water Depth at Street Crown (or at TMAX)","dCROWN =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF((D99-$AZ$130)/12/$AZ$131>$AZ$128,((D99-$AZ$130)/12/$AZ$131-$AZ$128)*$AZ$131*12,0))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF((E99-$AZ$130)/12/$AZ$131>$AZ$128,((E99-$AZ$130)/12/$AZ$131-$AZ$128)*$AZ$131*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\"",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","N/A","N/A",1,"1-1/8\" Bar Grate, Crossbars @ 8\""]
[null,"Ratio of Gutter Flow to Design Flow","Eo =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF(MIN(BF106+BF107,AZ126)=0,0,BF107/(MIN(BF106+BF107,AZ126))))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(MIN(BG106+BG107,BA126)=0,0,BG107/(MIN(BG106+BG107,BA126))))","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",1,"Slotted Inlet Parallel to Flow"]
[null,"Discharge outside the Gutter Section W, carried in Section Tx","Qx =",{"$f":"IF(D97=\"\",\"\",BF106)","v":""},{"$f":"IF(E97=\"\",\"\",BG106)","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,3,1.73,3.3,0.64,null,null,0.97,null,null,null,0,2.7,0.67,1,1,0.86,0.37,1,"User-Defined Combination"]
[null,"Discharge within the Gutter Section W","Qw =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",BF107)","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",BG107)","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,"N/A","N/A","N/A","N/A","N/A","N/A","N/A",4,8,8,81,3.4,0.67,1,1,0.9,"N/A",1,"Colorado Springs D-10-R"]
[null,"Discharge Behind the Curb Face","QBACK =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",BF108)","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",BG108)","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.6,0.67,1,1,0.86,0.21,1,"Wheat Ridge Combination"]
[null,"Flow Area within the Gutter Section W","AW =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF((D99/12+(D99/12-$AZ129*$AU126))/2*$AZ129<0,0,(D99/12+(D99/12-$AZ129*$AU126))/2*$AZ129))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF((E99/12+(E99/12-$AZ129*$AU126))/2*$AZ129<0,0,(E99/12+(E99/12-$AZ129*$AU126))/2*$AZ129))","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"]
[null,"Velocity within the Gutter Section W","VW =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF(D105=0,0,D103/D105))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(E105=0,0,E103/E105))","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*($AU$132*$AU$137)-AW106*($AU$132*$AU$137)^2+AX106*($AU$132*$AU$137)^3","v":0},"Curb","*","c",1,null,"Qx =",null,null,null,null,"Cells being filled check"]
[null,"Water Depth for Design Condition","dLOCAL =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",D99+D90)","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(E90=\"\",E99,E99+E90))","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,"Qw =",null,null,null,null,{"$f":"IF(OR(D90=\"\",D91=\"\",D92=\"\",D93=\"\",D94=\"\",D95=\"\"),\"\",1)","v":""},{"$f":"IF(OR(E90=\"\",E91=\"\",E92=\"\",E93=\"\",E94=\"\",E95=\"\"),\"\",1)","v":""},1]
[null,{"$f":"IF(BF119=\"\",\"Grate Analysis (Calculated)\",\"Analysis For Grate Type = \"&BF119&\" (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,"QBACK =",null,null,null,null,{"$f":"(IF(AND(BJ107=1,BK107=1)=TRUE,1,\"\"))","v":""}]
[null,"Total Length of Inlet Grate Opening","L =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF(D94=\"N/A\",\"N/A\",D92*D91))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(E94=\"N/A\",\"N/A\",IF(E97=\"\",\"\",E92*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,4,"CDOT Type C Grate",2.2200000000000002,4.03,0.65,0.06,2.2200000000000002,null,"*",null,4,null,"As ="]
[null,"Ratio of Grate Flow to Design Flow","Eo-GRATE =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF(D94=\"N/A\",\"N/A\",BF113))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(E94=\"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,null,5,"Denver No. 14 Curb Opening",0,0,0,0,0,"Curb","*","c",5,null,"Vs =",null,null,null,null,"GRATETYPE ="]
[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,"dLOCAL =",null,null,null,null,"Qo ="]
[null,"Minimum Velocity Where Grate Splash-Over Begins","Vo =",{"$f":"IF(D110=\"N/A\",\"N/A\",IF(D110=\"\",\"\",BF114))","v":""},{"$f":"IF(E110=\"N/A\",\"N/A\",IF(E110=\"\",\"\",BG114))","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,"L =",null,null,null,null,"T ="]
[null,"Interception Rate of Frontal Flow","Rf =",{"$f":"IF(D110=\"\",\"\",IF(D110=\"N/A\",\"N/A\",BF116))","v":""},{"$f":"IF(E110=\"\",\"\",IF(E110=\"N/A\",\"N/A\",BG116))","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,"Eo-GRATE =",null,null,null,null,"d ="]
[null,"Interception Rate of Side Flow","Rx =",{"$f":"IF(D110=\"\",\"\",IF(D110=\"N/A\",\"N/A\",IF(D93=0,0,BF117)))","v":""},{"$f":"IF(E110=\"\",\"\",IF(E110=\"N/A\",\"N/A\",IF(E93=0,0,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,9,"Directional 45-Degree Bar Grate",0.99,2.64,0.36,0.03,0.99,null,null,null,9,null,"Vo =",null,null,null,null,"dCROWN ="]
[null,"Interception Capacity","Qi =",{"$f":"IF(D110=\"\",\"\",IF(D110=\"N/A\",\"N/A\",BF118))","v":""},{"$f":"IF(E110=\"\",\"\",IF(E110=\"N/A\",\"N/A\",BG118))","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,"Vo =",null,null,null,null,"Eo ="]
[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,"Rf =",null,null,null,null,"Combo/Sweeper Qi",{"$f":"D97*(1-(1-(D129-BF135)/D127)^1.8)+BT63","v":{"$error":"#VALUE!"}},{"$f":"E97*(1-(1-(E129-BF135)/E127)^1.8)+BT63","v":{"$error":"#VALUE!"}}]
[null,"Clogging Coefficient for Multiple-unit Grate Inlet","GrateCoef =",{"$f":"IF(D110=\"N/A\",\"N/A\",IF(Minor_Input_Complete_OnGrade=FALSE,\"\",VLOOKUP(D91,ClogCoef_Lookup,2)))","v":""},{"$f":"IF(E110=\"N/A\",\"N/A\",IF(Major_Input_Complete_OnGrade=FALSE,\"\",VLOOKUP(E91,ClogCoef_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,12,"1-7/8\" Bar Grate, Crossbars @ 8\"",2.2200000000000002,4.03,0.65,0.06,2.2200000000000002,null,null,null,12,null,"Rx ="]
[null,"Clogging Factor for Multiple-unit Grate Inlet","GrateClog =",{"$f":"IF(D110=\"\",\"\",IF(D110=\"N/A\",\"N/A\",D94*D117/D91))","v":""},{"$f":"IF(E110=\"\",\"\",IF(E110=\"N/A\",\"N/A\",E94*E117/E91))","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.74,2.44,0.27,0.02,0.74,null,null,null,13,null,"Qi =",null,null,null,null,"Warnings Check"]
[null,"Effective (unclogged) Length of Multiple-unit Grate Inlet ","Le =",{"$f":"IF(D110=\"\",\"\",IF(D110=\"N/A\",\"N/A\",(1-D118)*D109))","v":""},{"$f":"IF(E110=\"\",\"\",IF(E110=\"N/A\",\"N/A\",(1-E118)*E109))","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,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,"Grate Type =",null,null,null,null,{"$f":"IF(BJ108=\"\",\"\",IF(BK110=1,IF(D92=0,\"Warning 1\",IF(AU130=0,\"\",\"Warning 1\")),\"\"))","v":""},{"$f":"IF(D93=\"\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,5)=\"\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,5)=\"N/A\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,5)=D93,\"\",\"Warning 1\"))))","v":""},{"$f":"IF(D94=\"\",\"\",IF(D94<0.5,\"Warning 2\",IF(D94>0.99,\"Warning 2\",\"\")))","v":""},{"$f":"IF(D95=\"\",\"\",IF(D95<0.1,\"Warning 2\",IF(D95>0.99,\"Warning 2\",\"\")))","v":""}]
[null,"Minimum Velocity Where Grate Splash-Over Begins","Vo =",{"$f":"IF(D110=\"\",\"\",IF(D110=\"N/A\",\"N/A\",BF115))","v":""},{"$f":"IF(E110=\"\",\"\",IF(E110=\"N/A\",\"N/A\",BG115))","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,15,"Slotted Inlet Parallel to Flow",0,0,0,0,0,"Curb",null,"*",15,null,"GrateCoef =",null,null,null,null,{"$f":"IF(BJ108=\"\",\"\",IF(BK110=5,IF(AU131=0,IF(D92=3, \"Warning 1\",\"\"),\"Warning 1\"),\"\"))","v":""},{"$f":"IF(E93=\"\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,5)=\"\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,5)=\"N/A\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,5)=E93,\"\",\"Warning 1\"))))","v":""},{"$f":"IF(E94=\"\",\"\",IF(E94<0.5,\"Warning 2\",IF(E94>0.99,\"Warning 2\",\"\")))","v":""},{"$f":"IF(E95=\"\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,16)=\"N/A\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,6)>0,IF(E95<0.1,\"Warning 2\",IF(E95>0.99,\"Warning 2\",\"\")))))","v":""}]
[null,"Interception Rate of Frontal Flow","Rf =",{"$f":"IF(D110=\"\",\"\",IF(D110=\"N/A\",\"N/A\",BF126))","v":""},{"$f":"IF(E110=\"\",\"\",IF(E110=\"N/A\",\"N/A\",BG126))","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,16,"User-Defined Combination",2.2200000000000002,4.8499999999999996,1.31,0.15,8.3399999999999981,null,null,"*",16,null,"GrateClog =",null,null,null,null,{"$f":"IF(BJ108=\"\",\"\",IF(BK110=17,IF(OR(D92=2,D92=0),\"Warning 1\",IF(AU128=0,\"\",\"Warning 1\")),\"\"))","v":""},{"$f":"IF(BK120=\"Warning 1\",\"Warning 1\",IF(BK119=\"Warning 1\",\"Warning 1\",\"\"))","v":""},{"$f":"IF(BJ108=\"\",\"\",IF(D94=\"N/A\",\"\",IF(BL120=\"Warning 2\",\"Warning 2\",IF(BL119=\"Warning 2\",\"Warning 2\",\"\"))))","v":""},{"$f":"IF(BJ108=\"\",\"\",IF(D95=\"N/A\",\"\",IF(BM120=\"Warning 2\",\"Warning 2\",IF(BM119=\"Warning 2\",\"Warning 2\",\"\"))))","v":""}]
[null,"Interception Rate of Side Flow","Rx =",{"$f":"IF(D110=\"\",\"\",IF(D110=\"N/A\",\"N/A\",IF(D93=0,0,BF123)))","v":""},{"$f":"IF(E110=\"\",\"\",IF(E110=\"N/A\",\"N/A\",IF(E93=0,0,BG123)))","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,17,"Colorado Springs D-10-R",0,0,0,0,{"$f":"AU122+AV122*($AU$132*$AU$137)-AW122*($AU$132*$AU$137)^2+AX122*($AU$132*$AU$137)^3","v":0},null,null,null,17,null,"Le =",null,null,null,null,{"$f":"IF(BJ108=\"\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,4)=\"\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,4)=\"N/A\",IF(VLOOKUP($BK$110,AS87:BN103,11)=D92,\"\",\"Warning 1\"),IF(VLOOKUP($BK$110,AS87:BN103,4)=D92,\"\",\"Warning 1\"))))","v":""}]
[null,"Actual Interception Capacity","Qa =",{"$f":"IF(D110=\"\",\"\",IF(D110=\"N/A\",\"N/A\",BF124))","v":""},{"$f":"IF(E110=\"\",\"\",IF(E110=\"N/A\",\"N/A\",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,18,"Wheat Ridge Combination",0.3,4.8499999999999996,1.31,0.15,{"$f":"AU123+AV123*($AU$132*$AU$137)-AW123*($AU$132*$AU$137)^2+AX123*($AU$132*$AU$137)^3","v":0.3},null,null,null,18,null,"Rx =",null,null,null,null,{"$f":"IF(BJ108=\"\",\"\",IF(BK110=1,BJ119,IF(BK110=5,BJ120,IF(BK110=17,BJ121,BJ122))))","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,{"$f":"IF(D95=\"\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,16)=\"N/A\",\"\",IF(VLOOKUP($BK$110,AS87:BN103,6)>0,IF(D95<0.1,\"Warning 2\",IF(D95>0.99,\"Warning 2\",\"\")))))","v":""}]
[null,"Carry-Over Flow = Qo-Qa (to be applied to curb opening or next d/s inlet)","Qb =",{"$f":"IF(D110=\"\",\"\",IF(D110=\"N/A\",\"N/A\",BF125))","v":""},{"$f":"IF(E110=\"\",\"\",IF(E110=\"N/A\",\"N/A\",BG125))","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,"GrateTypeNum = ",{"$f":"IF(OnGrade_Type=\"\",\"\",VLOOKUP(OnGrade_Type,$AT$106:$BC$123,10,FALSE))","v":""},null,"Qa ="]
[null,"Curb or Slotted Inlet Opening 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,"Q Allow",{"$f":"'Street Inlet'!D63","v":""},{"$f":"'Street Inlet'!E63","v":""},null,null,null,null,null,null,null,null,"Qb ="]
[null,"Equivalent Slope Se (based on grate carry-over) ","Se =",{"$f":"IF(D127=\"\",\"\",IF(D127=\"N/A\",\"N/A\",BF127))","v":""},{"$f":"IF(E127=\"\",\"\",IF(E127=\"N/A\",\"N/A\",BG127))","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,"Sw=",{"$f":"'Street Inlet'!D23","v":8.3000000000000004E-2},null,null,null,"Qo =",{"$f":"IF('Q-Peak'!H48=\"\",0,'Q-Peak'!H48)","v":0},{"$f":"IF('Q-Peak'!I48=\"\",0,'Q-Peak'!I48)","v":0},null,null,null,"Rf =",null,null,null,null,"Value Change Check"]
[null,"Required Length LT to Have 100% Interception","LT =",{"$f":"IF(D97=\"\",\"\",IF(BF128=\"\",\"N/A\",BF128))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(BG128=\"\",\"N/A\",BG128))","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,"Yw",{"$f":"AZ128*AZ131-AZ131*AZ129","v":0},null,null,null,"HCURB =",{"$f":"'Street Inlet'!D19","v":0},null,null,null,null,"Se =",null,null,null,null,2,{"$f":"D90","v":0}]
[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,"Checks Type D-10-R Lcurb/2",{"$f":"IF(D92=\"\",\"\",IF(D92=\"N/A\",\"\",MOD(D92,2)))","v":""},null,null,null,"TMAX =",{"$f":"'Street Inlet'!D20","v":0},null,null,null,null,"LT =",null,null,null,null,1,0]
[null,"Effective Length of Curb Opening or Slotted Inlet (minimum of L, LT)","L =",{"$f":"IF(BF135=\"\",IF(D127=\"\",\"\",IF(D127=\"N/A\",\"N/A\",IF(D97-D104=0,0,MIN(D92*D91,D127-0.001)))),BF135)","v":""},{"$f":"IF(BF135=\"\",IF(E127=\"\",\"\",IF(E127=\"N/A\",\"N/A\",IF(E97-E104=0,0,MIN(E92*E91,E127-0.001)))),BF135)","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,"TBACK =",{"$f":"'Street Inlet'!D15","v":0},null,null,null,"W =",{"$f":"'Street Inlet'!D21","v":0},null,null,null,null,"CurbCoef =",null,null,null,null,3,0]
[null,"Interception Capacity ","Qi =",{"$f":"IF(D127=\"\",\"\",IF(D127=\"N/A\",\"N/A\",BF134))","v":""},{"$f":"IF(E127=\"\",\"\",IF(E127=\"N/A\",\"N/A\",BG134))","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,"Checks Type R Lcurb/5",{"$f":"IF(D92=\"\",\"\",IF(D92=\"N/A\",\"\",MOD(D92,5)))","v":""},0,null,null,"a =",{"$f":"'Street Inlet'!D35","v":""},null,null,null,null,"CurbClog =",null,null,null,null,1.73,0]
[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,"Checks Type 14 Lcurb/3",{"$f":"IF(D92=\"\",\"\",IF(D92=\"N/A\",\"\",MOD(D92,3)))","v":""},null,null,null,"Sx =",{"$f":"'Street Inlet'!D22","v":0},null,null,null,null,null,null,null,null,null,0.5,0]
[null,"Clogging Coefficient","CurbCoef =",{"$f":"IF(D127=\"N/A\",\"N/A\",IF(Minor_Input_Complete_OnGrade=FALSE,\"\",VLOOKUP(MAX(1,ROUND(D91*D92/5,1)),ClogCoef_Lookup,3)))","v":""},{"$f":"IF(E127=\"N/A\",\"N/A\",IF(Minor_Input_Complete_OnGrade=FALSE,\"\",VLOOKUP(MAX(1,ROUND(E91*E92/5,1)),ClogCoef_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,"Lo =",{"$f":"D92","v":0},null,null,null,"So =",{"$f":"IF('Street Inlet'!D24=\"\",\"\",'Street Inlet'!D24)","v":""},null,null,null,null,"Selected Inlet Type Row",null,null,null,null,0.1,0]
[null,"Clogging Factor for Multiple-unit Curb Opening or Slotted Inlet","CurbClog =",{"$f":"IF(D127=\"\",\"\",IF(D127=\"N/A\",\"N/A\",D132*D95/(D91*D92/5)))","v":""},{"$f":"IF(E127=\"\",\"\",IF(E127=\"N/A\",\"N/A\",E132*E95/(E91*D92/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,"Wo =",{"$f":"D93","v":0},null,null,null,"nSTREET =",{"$f":"'Street Inlet'!D25","v":0},null,null,null,null,"L =",null,null,null,null,0.5,{"$f":"E94","v":0}]
[null,"Effective (Unclogged) Length ","Le =",{"$f":"IF(D127=\"\",\"\",IF(D127=\"N/A\",\"N/A\",(1-D132*D95/D91)*(D91*D92)))","v":""},{"$f":"IF(E127=\"\",\"\",IF(E127=\"N/A\",\"N/A\",(1-E132*E95/E91)*(E91*E92)))","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,"Cf-G =",{"$f":"D94","v":0},{"$f":"E94","v":0},null,null,"Sum Check",{"$f":"SUM(AZ126:BA126,AZ127:AZ129,AZ131:AZ133)","v":0},null,null,null,null,"Qi =",null,null,null,null,0.1,{"$f":"E95","v":0}]
[null,"Actual Interception Capacity ","Qa =",{"$f":"IF(D127=\"\",\"\",IF(D127=\"N/A\",\"N/A\",BF136))","v":""},{"$f":"IF(E127=\"\",\"\",IF(E127=\"N/A\",\"N/A\",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,"Cf-C =",{"$f":"D95","v":0},{"$f":"E95","v":0},null,null,null,null,null,null,null,null,"Sweeper Length",null,null,null,null,3.4857509548408965,{"$f":"AU125","v":""},2,{"$f":"AZ126","v":0}]
[null,"Carry-Over Flow = Qb(GRATE)-Qa","Qb =",{"$f":"IF(D127=\"\",\"\",IF(D127=\"N/A\",\"N/A\",IF(D124=\"N/A\",D97-D135,IF(D124-D135<0,0,D124-D135))))","v":""},{"$f":"IF(E127=\"\",\"\",IF(E127=\"N/A\",\"N/A\",IF(E124=\"N/A\",E97-E135,IF(E124-E135<0,0,E124-E135))))","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,"alocal =",{"$f":"D90","v":0},null,null,null,"Length of Single Unit Inlet",{"$f":"MOD(D92,3)","v":0},null,null,null,null,"Qa =",null,null,null,null,7.1218028041561379,{"$f":"AV125","v":""},5,{"$f":"BA126","v":0}]
[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,"No =",{"$f":"D91","v":0},null,null,null,null,null,"Qb just checking",0.63093447685241699,2.5195291042327881,null,"Qb ="]
[null,"Total Inlet Interception Capacity","Q =",{"$f":"IF(D97=\"\",\"\",IF(D97=\"N/A\",\"N/A\",IF(D127=\"N/A\",D123,IF(D123=\"N/A\",D135,IF(D135+D123<0,0,D135+D123)))))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(E97=\"N/A\",\"N/A\",IF(E127=\"N/A\",E123,IF(E123=\"N/A\",E135,IF(E135+E123<0,0,E135+E123)))))","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,"SBACK =",{"$f":"'Street Inlet'!D16","v":0},null,null,null,null,null,"Warning 1",null,null,null,"Q =",null,null,null,null,{"$f":"SUM(D90:D95,E90:E95)","v":0}]
[null,"Total Inlet Carry-Over Flow (flow bypassing inlet)","Qb =",{"$f":"IF(D97=\"\",\"\",IF(D97=\"N/A\",\"N/A\",IF(D127=\"N/A\",IF(D123=\"N/A\",D97,D97-D123),IF(D123=\"N/A\",D97-D135,IF(D97-D123-D135<0,0,D97-D123-D135)))))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(E97=\"N/A\",\"N/A\",IF(E127=\"N/A\",IF(E123=\"N/A\",E97,E97-E123),IF(E123=\"N/A\",E97-E135,IF(E97-E123-E135<0,0,E97-E123-E135)))))","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,"nBACK =",{"$f":"'Street Inlet'!D17","v":0},null,null,null,null,null,"Warning 2",null,null,null,"Qb =",null,null,null,null,0,"sweeper boolean"]
[null,"Capture Percentage = Qa/Qo =","C% =",{"$f":"IF(Minor_Input_Complete_OnGrade=FALSE,\"\",IF(D97=\"N/A\",\"N/A\",IF(D97=0,0,IF(D123=\"N/A\",IF(D135=\"N/A\",D123/D97*100,(D135)/D97*100),IF(D135=\"N/A\",(D123)/D97*100,IF((D123+D135)/D97*100>100,100,IF((D123+D135)/D97*100<0,0,(D123+D135)/D97*100)))))))","v":""},{"$f":"IF(Major_Input_Complete_OnGrade=FALSE,\"\",IF(E97=\"N/A\",\"N/A\",IF(E97=0,0,IF(E123=\"N/A\",IF(E135=\"N/A\",E123/E97*100,(E135)/E97*100),IF(E135=\"N/A\",(E123)/E97*100,IF((E123+E135)/E97*100>100,100,IF((E123+E135)/E97*100<0,0,(E123+E135)/E97*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,"Warning 3",null,null,null,"C% ="]
[null,{"$f":"IF(A90=\"Warning 1\",\"Warning 1: Dimension entered is not a typical dimension for inlet type specified.\",IF(A92=\"Warning 1\",\"Warning 1: Dimension entered is not a typical dimension for inlet type specified.\",IF(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,"Warning 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,null,null,null,null,null,null,null,null,null,"  "]
[null,{"$f":"IF(A94=\"Warning 2\",\"Warning 2: Clogging factor is not in the recommended value for inlet type specified.\",IF(A95=\"Warning 2\",\"Warning 2: Clogging factor is not in 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,"Warning 4"]
[null,{"$f":"IF(OR(A93=\"\",A93=\"Warning 1\"),\"\",\"Warning 3: The width of the unit is greater than the gutter width.\")","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,"Warning 4"]
[]
[]
[]
[]
[null,"INLET IN A SUMP OR SAG LOCATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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)",false]
[null,{"$f":"Intro!B5","v":"MHFD-Inlet, Version 5.01 (April 2021)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","Na G","K G","Lo C","Hvert C","Hthroat C","Theta C","Cw C","Co C","Nw C","Na C","K C","K Comb","Match?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"IF(Type_No_Selected=AS161,0,1)","v":1},"CDOT Type R Curb Opening",{"$f":"IF('Street Inlet'!$D$165=AU161,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$169=AV161,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$170=AW161,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$173=AX161,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$174=AY161,0,1)","v":1},0,{"$f":"IF('Street Inlet'!$D$171=BA161,0,1)","v":1},0,0,{"$f":"IF('Street Inlet'!$D$177=BD161,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$178=BE161,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$179=BF161,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$182=BG161,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$183=BH161,0,1)","v":1},0,0,0,0,{"$f":"SUM(AT150,AV150:BM150)","v":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,2,{"$f":"IF(Type_No_Selected=AS162,0,1)","v":1},"CDOT/Denver 13 Valley Grate",{"$f":"IF('Street Inlet'!$D$165=AU162,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$169=AV162,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$170=AW162,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$173=AX162,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$174=AY162,0,1)","v":1},0,{"$f":"IF('Street Inlet'!$D$171=BA162,0,1)","v":1},0,0,{"$f":"IF('Street Inlet'!$D$177=BD162,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$178=BE162,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$179=BF162,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$182=BG162,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$183=BH162,0,1)","v":1},0,0,0,0,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,3,{"$f":"IF(Type_No_Selected=AS163,0,1)","v":1},"CDOT/Denver 13 Combination",{"$f":"IF('Street Inlet'!$D$165=AU163,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$169=AV163,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$170=AW163,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$173=AX163,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$174=AY163,0,1)","v":1},0,{"$f":"IF('Street Inlet'!$D$171=BA163,0,1)","v":1},0,0,{"$f":"IF('Street Inlet'!$D$177=BD163,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$178=BE163,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$179=BF163,0,1)","v":0},{"$f":"IF('Street Inlet'!$D$182=BG163,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$183=BH163,0,1)","v":1},0,0,0,0,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(Type_No_Selected=AS165,0,1)","v":1},"Denver No. 14 Curb Opening",{"$f":"IF('Street Inlet'!$D$165=AU165,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$169=AV165,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$170=AW165,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$173=AX165,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$174=AY165,0,1)","v":1},0,{"$f":"IF('Street Inlet'!$D$171=BA165,0,1)","v":1},0,0,{"$f":"IF('Street Inlet'!$D$177=BD165,0,1)","v":0},{"$f":"IF('Street Inlet'!$D$178=BE165,0,1)","v":0},{"$f":"IF('Street Inlet'!$D$179=BF165,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$182=BG165,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$183=BH165,0,1)","v":1},0,0,0,0,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"IF(Type_No_Selected=AS166,0,1)","v":1},"Denver No. 16 Combination",{"$f":"IF('Street Inlet'!$D$165=AU166,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$169=AV166,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$170=AW166,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$173=AX166,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$174=AY166,0,1)","v":1},0,{"$f":"IF('Street Inlet'!$D$171=BA166,0,1)","v":1},0,0,{"$f":"IF('Street Inlet'!$D$177=BD166,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$178=BE166,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$179=BF166,0,1)","v":0},{"$f":"IF('Street Inlet'!$D$182=BG166,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$183=BH166,0,1)","v":1},0,0,0,0,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(Type_No_Selected=AS167,0,1)","v":1},"Denver No. 16 Valley Grate",{"$f":"IF('Street Inlet'!$D$165=AU167,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$169=AV167,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$170=AW167,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$173=AX167,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$174=AY167,0,1)","v":1},0,{"$f":"IF('Street Inlet'!$D$171=BA167,0,1)","v":1},0,0,{"$f":"IF('Street Inlet'!$D$177=BD167,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$178=BE167,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$179=BF167,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$182=BG167,0,1)","v":1},{"$f":"IF('Street Inlet'!$D$183=BH167,0,1)","v":1},0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AT180=1,AT180=2,AT180=3,AT180=5,AT180=6,AT180=7),IF(VLOOKUP(AT180,AS150:BN155,22)=0,\"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,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,"VLOOKUP",{"$f":"IF('Street Inlet'!D176=\"\",\"\",IF('Street Inlet'!D176=\"N/A\",\"\",MOD('Street Inlet'!D176,2)))","v":""},{"$f":"IF(OR(Type_No_Selected=1,Type_No_Selected=5,Type_No_Selected=18),IF(VLOOKUP(IF(Type_No_Selected=17,$AU$201,Type_No_Selected),ParamTable,21)=0,\"sp_curb\",\"curb\"),IF(OR(Type_No_Selected=3,Type_No_Selected=6,Type_No_Selected=19),IF(VLOOKUP(IF(Type_No_Selected=17,$AU$201,Type_No_Selected),ParamTable,21)=0,\"sp_comb\",\"comb\"),IF(OR(Type_No_Selected=2,Type_No_Selected=7),IF(VLOOKUP(IF(Type_No_Selected=17,$AU$201,Type_No_Selected),ParamTable,21)=0,\"sp_grate\",\"grate\"),IF(Type_No_Selected=17,\"user_comb\",\"grate\"))))","v":"grate"},{"$f":"IF($AU$200<>\"\",\"comb\")","v":false},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,"INLET_TYPE","alocal","Lo G","Wo G","Cw  G","Co G","Nw G","Na G","K G","Lo C","Hvert C","Hthroat C","Theta C","Cw C","Co C","Nw C","Na C","K C","K Comb","Match?","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":"6+3-IS_HCURB","v":9},"N/A","N/A","N/A","N/A","N/A","N/A","N/A",5,{"$f":"AU191+AU161-3","v":6},{"$f":"BD161","v":6},63.4,3.6,0.67,1,1,0.93,"N/A",{"$f":"BN150","v":12},"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","N/A","N/A",{"$f":"BN151","v":12},"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":"AU191+AU163-1.5","v":0.5},5.25,0,3.7,0.66,1,1,0.86,0.35,{"$f":"BN152","v":11},"CDOT/Denver 13 Combination",3]
[null,"Type of Inlet","Type =",{"$f":"IF(Type_No_Selected = \"\", \"\",AT180)","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",1,"CDOT Type C Grate",4]
[null,"Local Depression (additional to continuous gutter depression 'a' from above)","alocal =",null,{"$f":"IF(D165=\"\",\"\",D165)","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":"AU191+AU165-3","v":0},{"$f":"BD165","v":0},63.4,3.6,0.67,1,1,0.93,"N/A",{"$f":"BN153","v":10},"Denver No. 14 Curb Opening",5]
[null,"Number of Unit Inlets (Grate or Curb Opening)","No =",null,{"$f":"IF(D166=\"\",\"\",D166)","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":"AU191+AU166-1.5","v":0.5},5.25,0,3.7,0.66,1,1,0.86,0.2,{"$f":"BN154","v":11},"Denver No. 16 Combination",6]
[null,"Water Depth at Flowline (outside of local depression)","Ponding Depth =",null,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,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","N/A","N/A",{"$f":"BN155","v":12},"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","N/A","N/A",1,"Directional Cast Vane Grate",8]
[null,"Length of a Unit Grate","Lo (G) =",null,{"$f":"IF(D169=\"\",\"\",D169)","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","N/A","N/A",1,"Directional 45-Degree Bar Grate",9]
[null,"Width of a Unit Grate","Wo =",null,{"$f":"IF(D170=\"\",\"\",D170)","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","N/A","N/A",1,"Directional 30-Degree Bar Grate",10]
[null,"Area Opening Ratio for a Grate (typical values 0.15-0.90)","Aratio =",null,{"$f":"IF(D171=\"\",\"\",D171)","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","N/A","N/A",1,"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","N/A","N/A",1,"1-7/8\" Bar Grate, Crossbars @ 8\"",12]
[null,"Grate Weir Coefficient (typical value 2.15 - 3.60)","Cw  (G) =",null,{"$f":"IF(D173=\"\",\"\",D173)","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","N/A","N/A",1,"1-7/8\" Bar Grate, Crossbars @ 4\"",13]
[null,"Grate Orifice Coefficient (typical value 0.60 - 0.80)","Co (G) =",null,{"$f":"IF(D174=\"\",\"\",D174)","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","N/A","N/A",1,"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",1,"Slotted Inlet Parallel to Flow",15]
[null,"Length of a Unit Curb Opening","Lo (C) =",null,{"$f":"IF(D176=\"\",\"\",D176)","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",1,"Slotted Inlet Normal to Flow",16]
[null,"Height of Vertical Curb Opening in Inches ","Hvert =",null,{"$f":"IF(Hvert_minor=\"\",\"\",Hvert_minor)","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",0,null,null,null,null,null,null,0.97,null,null,null,0,2.7,0.67,1,1,0.86,0.21,1,"User-Defined Combination",17]
[null,"Height of Curb Orifice Throat in Inches ","Hthroat =",null,{"$f":"IF(Hthroat_minor=\"\",\"\",Hthroat_minor)","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,8,81,3.6,0.67,1,1,0.93,"N/A",1,"Colorado Springs D-10-R",18]
[null,"Angle of Throat (see USDCM Figure ST-5)","Theta =",null,{"$f":"IF(Theta_minor=\"\",\"\",Theta_minor)","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.6,0.67,1,1,0.86,0.21,1,"Wheat Ridge Combination",19]
[null,"Side Width for Depression Pan (typically the gutter width of 2 feet)","Wp =",null,{"$f":"IF(Wp_minor=\"\",\"\",Wp_minor)","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,"GRATETYPE =",null,0,"GrateTypeNum =",{"$f":"IF($AT$180=\"\",\"\",VLOOKUP($AT$180,$BN$161:$BO$179,2,FALSE))","v":""}]
[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,"Checks Type R Lcurb/5",{"$f":"IF('Street Inlet'!D176=\"\",\"\",IF('Street Inlet'!D176=\"N/A\",\"\",MOD('Street Inlet'!D176,5)))","v":""},null,null,null,null,null,"Cells Filled in Check"]
[null,"Curb Opening Weir Coefficient (typical value 2.3-3.7)","Cw (C) =",null,{"$f":"IF(D182=\"\",\"\",D182)","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,"Checks Type 14 Lcurb/3",{"$f":"IF('Street Inlet'!D176=\"\",\"\",IF('Street Inlet'!D176=\"N/A\",\"\",MOD('Street Inlet'!D176,3)))","v":""},null,null,null,null,null,{"$f":"IF(COUNTA('Street Inlet'!D165:D167,'Street Inlet'!D169:D174,'Street Inlet'!D176:D183,'Street Inlet'!E181)<9,0,1)","v":0},null,null,null,null,null,null,null,null,"No unit","Grate Coef","Curb Coef","G.Coef/N","C.Coef/N"]
[null,"Curb Opening Orifice Coefficient (typical value 0.60 - 0.70)","Co (C) =",null,{"$f":"IF(D183=\"\",\"\",D183)","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,{"$f":"IF(OR(Type_No_Selected=2,Type_No_Selected=3,Type_No_Selected=6,Type_No_Selected=7),1,0)","v":0},"Type check for Weir Coef",null,null,null,null,null,null,null,1,1,1,{"$f":"BK183/BJ183","v":1},{"$f":"BL183/BJ183","v":1}]
[null,{"$f":"IF('Street Inlet'!AU203=\"\",\"Grate Flow Analysis (Calculated)\",\"Analysis For Grate Type = \"&'Street Inlet'!AU203&\" (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,"Max. Allowable Depth =",{"$f":"'Street Inlet'!D29","v":0},{"$f":"'Street Inlet'!E29","v":0},null,null,null,null,0,null,null,null,null,null,null,null,null,2,1.5,1.25,0.75,0.625]
[null,"Clogging Coefficient for Multiple Units","Coef =",{"$f":"IF('Street Inlet'!BA182=1,IF(D172=\"N/A\",\"N/A\",IF(D166=\"\",\"\",VLOOKUP(D166,ClogCoef,2))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E172=\"N/A\",\"N/A\",IF(E166=\"\",\"\",VLOOKUP(E166,ClogCoef,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,"Water Depth based on Spread Criteria =",{"$f":"'Street Inlet'!D36","v":""},{"$f":"'Street Inlet'!E36","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,3,1.75,1.31,0.58333333333333337,0.4366666666666667]
[null,"Clogging Factor for Multiple Units","Clog =",{"$f":"IF('Street Inlet'!BA182=1,IF(OR(D172=\"N/A\",D172>=1),\"N/A\",IF(D166=\"\",\"\",D172*D185/D166)),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(OR(E172=\"N/A\",E172>=1),\"N/A\",IF(E166=\"\",\"\",E172*E185/E166)),\"\")","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,"Flow Depth =",{"$f":"MIN(AU184:AU185)","v":0},{"$f":"MIN(AV184:AV185)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,4,1.88,1.33,0.47,0.33250000000000002]
[null,{"$f":"IF('Street Inlet'!BN156=\"True\",\"Grate Capacity as a Weir (based on MHFD - CSU 2010 Study)\",\"Grate Capacity as a Weir (based on Modified HEC22 Method)\")","v":"Grate Capacity as a Weir (based on Modified HEC22 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,"TBACK =",{"$f":"'Street Inlet'!D15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,1.94,1.33,0.38800000000000001,0.26600000000000001]
[null,"Interception without Clogging","Qwi =",{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",VLOOKUP(IF('Street Inlet'!Type_No_Selected=17,'Street Inlet'!$AU$201,'Street Inlet'!Type_No_Selected),ParamTable,8)*D173*grate_L_reduce_minor*(D166*D169+2*D170)*grate_depth_minor^1.5)))","v":""},{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",VLOOKUP(IF('Street Inlet'!Type_No_Selected=17,'Street Inlet'!$AU$201,'Street Inlet'!Type_No_Selected),ParamTable,8)*E173*grate_L_reduce_major*(E166*E169+2*E170)*grate_depth_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,"SBACK =",{"$f":"'Street Inlet'!D16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1.97,1.33,0.32833333333333331,0.22166666666666668]
[null,"Interception with Clogging","Qwa =",{"$f":"IF('Street Inlet'!BA182=1,IF(D167=\"\",\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",is_Qwi_minor*(1-is_Clog_minor)))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E167=\"\",\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",is_Qwi_major*(1-is_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,"nBACK =",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1.98,1.33,0.28285714285714286,0.19]
[null,{"$f":"IF('Street Inlet'!BN156=\"True\",\"Grate Capacity as a Orifice (based on MHFD - CSU 2010 Study)\",\"Grate Capacity as a Orifice (based on Modified HEC22 Method)\")","v":"Grate Capacity as a Orifice (based on Modified HEC22 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,"Qo (minor, major)=",3,6,null,null,null,null,null,null,null,null,null,null,null,null,null,8,1.99,1.33,0.24875,0.16625000000000001]
[null,"Interception without Clogging","Qoi =",{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",VLOOKUP(IF('Street Inlet'!Type_No_Selected=17,'Street Inlet'!$AU$201,'Street Inlet'!Type_No_Selected),ParamTable,9)*D174*(D166*D169*D170)*(64.4*grate_depth_minor)^0.5)))","v":""},{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",VLOOKUP(IF('Street Inlet'!Type_No_Selected=17,'Street Inlet'!$AU$201,'Street Inlet'!Type_No_Selected),ParamTable,9)*E174*(E166*E169*E170)*(64.4*grate_depth_major)^0.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,"HCURB =",{"$f":"'Street Inlet'!D19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,2,1.33,0.22222222222222221,0.14777777777777779]
[null,"Interception with Clogging","Qoa =",{"$f":"IF('Street Inlet'!BA182=1,IF(D167=\"\",\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",is_Qoi_minor*(1-is_Clog_minor)))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E167=\"\",\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",is_Qoi_major*(1-is_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,"Tcrown =",{"$f":"'Street Inlet'!D20","v":0}]
[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,"W =",{"$f":"'Street Inlet'!D21","v":0},{"$f":"IF(OR('Street Inlet'!D170=\"\",'Street Inlet'!D170=\"N/A\"),\"\",IF('Street Inlet'!D170>AU193,FALSE,TRUE))","v":""}]
[null,"Interception without Clogging","Qmi =",{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(D167=\"\",\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",VLOOKUP(IF('Street Inlet'!Type_No_Selected=17,'Street Inlet'!$AU$201,'Street Inlet'!Type_No_Selected),ParamTable,10)*(D188*D191)^0.5))))","v":""},{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(E167=\"\",\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",VLOOKUP(IF('Street Inlet'!Type_No_Selected=17,'Street Inlet'!$AU$201,'Street Inlet'!Type_No_Selected),ParamTable,10)*(E188*E191)^0.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,"a =",{"$f":"'Street Inlet'!D35","v":""}]
[null,"Interception with Clogging","Qma =",{"$f":"IF('Street Inlet'!BA182=1,IF(D167=\"\",\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",VLOOKUP(IF('Street Inlet'!Type_No_Selected=17,'Street Inlet'!$AU$201,'Street Inlet'!Type_No_Selected),ParamTable,10)*(D189*D192)^0.5))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E167=\"\",\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),\"N/A\",VLOOKUP(IF('Street Inlet'!Type_No_Selected=17,'Street Inlet'!$AU$201,'Street Inlet'!Type_No_Selected),ParamTable,10)*(E189*E192)^0.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,"Sx =",{"$f":"'Street Inlet'!D22","v":0}]
[null,"Resulting Grate Capacity (assumes clogged condition)","QGrate =",{"$f":"IF('Street Inlet'!BA182=1,IF(D167=\"\",\"\",IF(D186=\"N/A\",\"N/A\",IF(D167=0,0,MIN(D189,D192,D195)))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E167=\"\",\"\",IF(E186=\"N/A\",\"N/A\",IF(E167=0,0,MIN(E189,E192,E195)))),\"\")","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,"So =",{"$f":"'Street Inlet'!D24","v":0}]
[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,"nSTREET =",{"$f":"'Street Inlet'!D25","v":0}]
[null,"Clogging Coefficient for Multiple Units","Coef =",{"$f":"IF('Street Inlet'!BA182=1,IF(D181=\"N/A\",\"N/A\",IF(D166=\"\",\"\",VLOOKUP(MAX(1,ROUND(D166*D176/5,1)),ClogCoef,3))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E181=\"N/A\",\"N/A\",IF(E166=\"\",\"\",VLOOKUP(MAX(1,ROUND(E166*E176/5,1)),ClogCoef,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,"Sw=",{"$f":"'Street Inlet'!D23","v":8.3000000000000004E-2},{"$f":"'Street Inlet'!D23","v":8.3000000000000004E-2}]
[null,"Clogging Factor for Multiple Units","Clog =",{"$f":"IF('Street Inlet'!BA182=1,IF(OR(D181=\"N/A\",D181>=1),\"N/A\",IF(D166=\"\",\"\",D181*D198/(D166*D176/5))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(OR(E181=\"N/A\",E181>=1),\"N/A\",IF(E166=\"\",\"\",E181*E198/(E166*E176/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,"Slocal=",{"$f":"AU198+'Street Inlet'!D165/12/IS_W","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF('Street Inlet'!BN156=\"True\",\"Curb Opening as a Weir (based on MHFD - CSU 2010 Study)\",\"Curb Opening as a Weir (based on Modified HEC22 Method)\")","v":"Curb Opening as a Weir (based on Modified HEC22 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,"User Drop Down Index"]
[null,"Interception without Clogging","Qwi =",{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(D167=\"\",\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),IF('Street Inlet'!$AU$180=1,D182*curb_reduction_factor_minor*(D176+1.8*IS_W)*curb_weir_depth_minor^1.5,D182*curb_reduction_factor_minor*D166*(D176+1.8*IS_W)*curb_weir_depth_minor^1.5),IF(OR(Inlet_Type=\"sp_comb\",Inlet_Type=\"comb\"),IF('Street Inlet'!$AU$180=1,D182*D176*combcurb_L_reduce_minor*curb_weir_depth_minor^1.5,D182*D166*D176*combcurb_L_reduce_minor*curb_weir_depth_minor^1.5)))))))","v":""},{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(E167=\"\",\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",IF(OR(Inlet_Type=\"sp_curb\",Inlet_Type=\"curb\"),IF('Street Inlet'!$AU$180=1,E182*curb_reduction_factor_major*(E176+1.8*IS_W)*curb_weir_depth_major^1.5,E182*curb_reduction_factor_major*E166*(E176+1.8*IS_W)*curb_weir_depth_major^1.5),IF(OR(Inlet_Type=\"sp_comb\",Inlet_Type=\"comb\"),IF('Street Inlet'!$AU$180=1,E182*E176*combcurb_L_reduce_major*curb_weir_depth_major^1.5,E182*E166*E176*combcurb_L_reduce_major*curb_weir_depth_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,"User Defined Index",10]
[null,"Interception with Clogging","Qwa =",{"$f":"IF('Street Inlet'!BA182=1,IF(D167=\"\",\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",is_CO_Qwi_minor*(1-is_Clog_MU_minor)))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E167=\"\",\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",is_CO_Qwi_major*(1-is_Clog_MU_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,"Sweeper Grate length",5]
[null,{"$f":"IF('Street Inlet'!BN156=\"True\",\"Curb Opening as an Orifice (based on MHFD - CSU 2010 Study)\",\"Curb Opening as an Orifice (based on Modified HEC22 Method)\")","v":"Curb Opening as an Orifice (based on Modified HEC22 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,"User Defined Grate name"]
[null,"Interception without Clogging","Qoi =",{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(D167=\"\",\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",IF('Street Inlet'!$AU$180=1,\nD183*D176*D178/12*(64.4*((D165+D167)/12-D178/2/12*SIN(Theta_minor*PI()/180)))^0.5,\nD183*D166*D176*D178/12*(64.4*((D165+D167)/12-D178/2/12*SIN(Theta_minor*PI()/180)))^0.5)))))","v":""},{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(E167=\"\",\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",IF('Street Inlet'!$AU$180=1,\nE183*E176*E178/12*(64.4*((E165+E167)/12-E178/2/12*SIN(Theta_minor*PI()/180)))^0.5,\nE183*E166*E176*E178/12*(64.4*((E165+E167)/12-E178/2/12*SIN(Theta_minor*PI()/180)))^0.5)))))","v":""},"cfs"]
[null,"Interception with Clogging","Qoa =",{"$f":"IF('Street Inlet'!BA182=1,IF(D167=\"\",\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",is_CO_Qoi_minor*(1-is_Clog_MU_minor)))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E167=\"\",\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",is_CO_Qoi_major*(1-is_Clog_MU_major)))),\"\")","v":""},"cfs"]
[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,null,"Grate Coef ="]
[null,"Interception without Clogging","Qmi =",{"$f":"IF('Street Inlet'!BA182=1,IF(D167=\"\",\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",VLOOKUP(Type_No_Selected,ParamTable,19)*SQRT(D201*D204)))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E167=\"\",\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",VLOOKUP(Type_No_Selected,ParamTable,19)*SQRT(E201*E204)))),\"\")","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,"Grate Clog ="]
[null,"Interception with Clogging","Qma =",{"$f":"IF('Street Inlet'!BA182=1,IF(D167=\"\",\"\",IF(D167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",VLOOKUP(Type_No_Selected,ParamTable,19)*SQRT(D202*D205)))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E167=\"\",\"\",IF(E167=0,0,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),\"N/A\",VLOOKUP(Type_No_Selected,ParamTable,19)*SQRT(E202*E205)))),\"\")","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,"Grate dwi ="]
[null,"Resulting Curb Opening Capacity (assumes clogged condition)","QCurb =",{"$f":"IF('Street Inlet'!BA182=1,IF(OR(D199=\"\", D167=\"\"),\"\",IF(D199=\"N/A\",\"N/A\",IF(D167=0,0,MIN(D202,D205,D208)))),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(OR(E199=\"\", E167=\"\"),\"\",IF(E199=\"N/A\",\"N/A\",IF(E167=0,0,MIN(E202,E205,E208)))),\"\")","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,"Grate dwa ="]
[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,null,"Grate doi ="]
[null,"Total Inlet Length","L =",{"$f":"IF('Street Inlet'!BA182=1,IF(D166=\"\",\"\",D166*MAX(D169,D176)),\"\")","v":""},{"$f":"IF('Street Inlet'!BA182=1,IF(E166=\"\",\"\",E166*MAX(E169,E176)),\"\")","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,"Grate doa ="]
[null,"Resultant Street Flow Spread (based on street geometry from above)","T =",{"$f":"IF('Street Inlet'!$BA$182=0,0,IF(D167=\"\",\"\",IF(D167/12<IS_W*'Street Inlet'!AU198,D167/12/'Street Inlet'!AU198,(D167-IS_a)/12/IS_Sx)))","v":0},{"$f":"IF('Street Inlet'!$BA$182=0,0,IF(E167=\"\",\"\",IF(E167/12<IS_W*'Street Inlet'!AV198,E167/12/'Street Inlet'!AV198,(E167-IS_a)/12/IS_Sx)))","v":0},{"$f":"IF(is_RSC_T_major=\"\",\"ft\",IF(is_RSC_T_major>IS_Tmax_minor,\"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,null,"da-Grate ="]
[null,"Resultant Flow Depth at Street Crown","dCROWN =",{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(D167=\"\",\"\",IF((D167-IS_a)/12/IS_Sx>IS_Tmax_minor,((D167-IS_a)/12/IS_Sx-IS_Tmax_minor)*IS_Sx*12,0)))","v":""},{"$f":"IF('Street Inlet'!$BA$182=0,\"\",IF(E167=\"\",\"\",IF((E167-IS_a)/12/IS_Sx>IS_Tmax_minor,((E167-IS_a)/12/IS_Sx-IS_Tmax_minor)*IS_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,null,"Curb Coef ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Curb Clog ="]
[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,null,"Curb dwi ="]
[null,"Depth for Grate Midwidth","dGrate =",{"$f":"IF(ISNUMBER(D170),((D167+D165)/12-($AU$198+D165/12/IS_W)*D170/2),\"N/A\")","v":"N/A"},{"$f":"IF(ISNUMBER(E170),((E167+E165)/12-($AU$198+E165/12/IS_W)*E170/2),\"N/A\")","v":"N/A"},"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,"Curb dwa ="]
[null,"Depth for Curb Opening Weir Equation","dCurb =",{"$f":"IF(ISNUMBER(D176),MAX(0.02,D167/12-AU198*IS_W),\"N/A\")","v":"N/A"},{"$f":"IF(ISNUMBER(E176),MAX(0.02,E167/12-AV198*IS_W),\"N/A\")","v":"N/A"},"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,"Curb doi ="]
[null,"Combination Inlet Performance Reduction Factor for Long Inlets","RFCombination =",{"$f":"IF(ISNUMBER(D176),IF($AU$180=1,MIN(1,D167/(0.7*MIN(D176,9)+4.3)),MIN(1,D167/(0.7*MIN(D166*D176,9)+4.3))),\"N/A\")","v":"N/A"},{"$f":"IF(ISNUMBER(E176),IF($AU$180=1,MIN(1,E167/(0.7*MIN(E176,9)+4.3)),MIN(1,E167/(0.7*MIN(E166*E176,9)+4.3))),\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Curb doa ="]
[null,"Curb Opening Performance Reduction Factor for Long Inlets","RFCurb =",{"$f":"IF(ISNUMBER(D176),IF($AU$180=1,MAX(0.5,MIN(1,D167/(0.67*D167+0.24*MIN(D176,15)))),MAX(0.5,MIN(1,D167/(0.67*D167+0.24*MIN(D166*D176,15))))),\"N/A\")","v":"N/A"},{"$f":"IF(ISNUMBER(E176),IF($AU$180=1,MAX(0.5,MIN(1,E167/(0.67*E167+0.24*MIN(E176,15)))),MAX(0.5,MIN(1,E167/(0.67*E167+0.24*MIN(E166*E176,15))))),\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"da-Curb ="]
[null,"Grated Inlet Performance Reduction Factor for Long Inlets","RFGrate =",{"$f":"IF(ISNUMBER(D169),IF($AU$180=1,MIN(1,D167/(0.7*MIN(D169,9)+4.3)),MIN(1,D167/(0.7*MIN(D166*D169,9)+4.3))),\"N/A\")","v":"N/A"},{"$f":"IF(ISNUMBER(E169),IF($AU$180=1,MIN(1,E167/(0.7*MIN(E169,9)+4.3)),MIN(1,E167/(0.7*MIN(E166*E169,9)+4.3))),\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"d ="]
[null,"Total Inlet Interception Capacity (assumes clogged condition)","Qa =",{"$f":"IF(BA182=1,IF(OR(Inlet_Type=\"curb\",Inlet_Type=\"sp_curb\"),D209,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),D196,IF($AU$180=1,D209*(1-D166*D170/D176)+(D196+D209*D166*D170/D176-SQRT(D196*D209*D166*D170/D176))*VLOOKUP(Type_No_Selected,ParamTable,20),D196+D209-SQRT(D196*D209)*VLOOKUP(Type_No_Selected,ParamTable,20)))),\"\")","v":""},{"$f":"IF(BA182=1,IF(OR(Inlet_Type=\"curb\",Inlet_Type=\"sp_curb\"),E209,IF(OR(Inlet_Type=\"grate\",Inlet_Type=\"sp_grate\"),E196,IF($AU$180=1,E209*(1-E166*E170/E176)+(E196+E209*E166*E170/E176-SQRT(E196*E209*E166*E170/E176))*VLOOKUP(Type_No_Selected,ParamTable,20),E196+E209-SQRT(E196*E209)*VLOOKUP(Type_No_Selected,ParamTable,20)))),\"\")","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,"T ="]
[null,{"$f":"IF('Street Inlet'!BA182=1,IF(AND(is_RSC_Qa_minor<'Q-Peak'!H48,'Street Inlet'!is_RSC_Qa_major<'Q-Peak'!I48),\"WARNING: Inlet Capacity less than Q Peak for Minor and Major Storms\",IF(is_RSC_Qa_minor<'Q-Peak'!H48,\"WARNING: Inlet Capacity less than Q Peak for Minor Storm\",IF('Street Inlet'!is_RSC_Qa_major<'Q-Peak'!I48,\"WARNING: Inlet Capacity less than Q Peak for MAJOR Storm\",\"Inlet Capacity IS GOOD for Minor and Major Storms (>Q PEAK)\"))),\"\")","v":""},"Q PEAK REQUIRED =",{"$f":"IF(BA182=1,IF('Q-Peak'!H48=\"\",\"\",'Q-Peak'!H48),\"\")","v":""},{"$f":"IF(BA182=1,IF('Q-Peak'!I48=\"\",\"\",'Q-Peak'!I48),\"\")","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,"dCROWN ="]
[null,{"$f":"IF(AU225=\"\",\"\",AU225)","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,"Warning 1"]
[null,{"$f":"IF(AU226=\"\",\"\",AU226)","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,"Warning 2"]
[null,{"$f":"IF(AU227=\"\",\"\",AU227)","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,"Warning 3"]
[null,{"$f":"IF(AU228=\"\",\"\",AU228)","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,"Warning 4"]
[null,{"$f":"IF(AU251=\"\",\"\",AU251)","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,"Type Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LoGrate Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wo Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 (G) Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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  (G) Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 (G) Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alocal Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hvert Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hthroat Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Theta Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wp Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 (C) Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 (C) Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 (C) Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LoCurb Warning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QComboGrate in grate weir flow unclogged"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QComboGrate in grate weir flow clogged"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QComboGrate in curb weir flow unclogged"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QComboGrate in curb orif flow unclogged"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QComboGrate in curb weir flow clogged"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QComboGrate in curb orif flow clogged"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":5,"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,11,4]]}
[null,{"$f":"Intro!B5","v":"MHFD-Inlet, Version 5.01 (April 2021)"},null,null,null,null,null,null,null,"Worksheet Protected"]
[null,"AREA INLET IN A SWALE"]
[]
[null,{"$f":"IF(Qpeak_Project=\"\",\"\",Qpeak_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.\n  \nFor more information see \nSection 7.2.3 of the USDCM.",null,null,null,null,null,"Q-Peak"]
[null,null,null,null,null,null,null,null,null,"Inlet Management"]
[]
[]
[]
[]
[]
[]
[null,"Analysis of Trapezoidal Grass-Lined Channel Using 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-$D$19)/($D$20+$D$21)))","v":""},{"$f":"IF(E32=\"\",\"\",((E32-$D$19)/($D$20+$D$21)))","v":""},"ft"]
[null,"Flow Area","A =",{"$f":"IF(D32=\"\",\"\",(($D$19+D32)/2)*D33)","v":""},{"$f":"IF(E32=\"\",\"\",(($D$19+E32)/2)*E33)","v":""},"sq ft"]
[null,"Wetted Perimeter","P =",{"$f":"IF(D32=\"\",\"\",($D$19+D33*(((1+$D$20^2)^0.5)+((1+$D$21^2)^0.5))))","v":""},{"$f":"IF(E32=\"\",\"\",($D$19+E33*(((1+$D$20^2)^0.5)+((1+$D$21^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))*($D$18^0.5))","v":""},{"$f":"IF(E32=\"\",\"\",(1.49/E37)*(E36^(2/3))*($D$18^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=\"\",\"\",$D$19+D45*($D$20+$D$21))","v":""},{"$f":"IF(E45=\"\",\"\",$D$19+E45*($D$20+$D$21))","v":""},"ft"]
[null,"Flow Area","A =",{"$f":"IF(D45=\"\",\"\",(($D$19+D46)/2)*D45)","v":""},{"$f":"IF(E45=\"\",\"\",(($D$19+E46)/2)*E45)","v":""},"sq ft"]
[null,"Wetted Perimeter","P =",{"$f":"IF(D45=\"\",\"\",($D$19+D45*(((1+$D$20^2)^0.5)+((1+$D$21^2)^0.5))))","v":""},{"$f":"IF(E45=\"\",\"\",($D$19+E45*(((1+$D$20^2)^0.5)+((1+$D$21^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))*($D$18^0.5))","v":""},{"$f":"IF(E45=\"\",\"\",(1.49/E50)*(E49^(2/3))*($D$18^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,\"\",$D$19+D63*($D$20+$D$21))","v":""},{"$f":"IF($BA$138<10,\"\",$D$19+E63*($D$20+$D$21))","v":""},"ft"]
[null,"Flow Area","A =",{"$f":"IF($BA$138<10,\"\",(($D$19+D64)/2)*D63)","v":""},{"$f":"IF($BA$138<10,\"\",(($D$19+E64)/2)*E63)","v":""},"sq ft"]
[null,"Wetted Perimeter","P =",{"$f":"IF($BA$138<10,\"\",($D$19+D63*(((1+$D$20^2)^0.5)+((1+$D$21^2)^0.5))))","v":""},{"$f":"IF($BA$138<10,\"\",($D$19+E63*(((1+$D$20^2)^0.5)+((1+$D$21^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))*($D$18^0.5))","v":""},{"$f":"IF($BA$138<10,\"\",(1.49/E68)*(E67^(2/3))*($D$18^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(BA148=\"\",\"\",BA148)","v":""}]
[null,{"$f":"IF(BA149=\"\",\"\",BA149)","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(TYPE_SELECTED=2,D63+1,IF(TYPE_SELECTED=4,D63+1,IF(TYPE_SELECTED=6,D63+1,D63)))))","v":""},{"$f":"IF(E63=\"\",\"\",IF($BA$166<10,\"\",IF(TYPE_SELECTED=2,E63+1,IF(TYPE_SELECTED=4,E63+1,IF(TYPE_SELECTED=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,"Non-Cohesive",null,null,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,"Cohesive",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,"Paved",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:BB137,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":"'Q-Peak'!H48","v":""},{"$f":"'Q-Peak'!I48","v":""},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 ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 = ",{"$f":"IF(BC163=\"\",0,VLOOKUP(BC163,$BC$156:$BM$162,11,FALSE))","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,null,{"$f":"COUNTA(D77,E79:E87)","v":1},"Count of input cells for Inlet Capacity"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]