{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Coeff","Map","Sheet1","NOAA Data2","Design Flows","Versions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":4,"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":"Instructions","index":0,"n_rows":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,0,48,16383],[15,0,15,16383],[6,0,6,16383],[1,0,1,16383],[28,0,28,16383],[39,0,39,16383],[46,0,46,16383],[34,0,34,16383],[35,0,35,16383],[36,0,36,16383],[37,0,37,16383],[38,0,38,16383]]}
["Refer to the current drainage manual for a more detailed discussion of the methods and equations used.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v14a"]
[]
[null,60,null,"User required entries."]
[null,8,null,"Total travel time.  If cell is this color, total time was changed to 8 minutes because the computed time was < required 8 minute minimum."]
[null,"n",null,"Initial or assumed roughness value (see below)."]
[null,1.89,null,"Cells colored in this manner denote that the calculated shear exceeds the allowable shear (user selected roughness only)."]
[]
["Design storms calculated using NOAA IDF values are based on NOAA Atlas 14, Volume 2, Version 3.0.  Backward compatability with Thiessen polygon intensities is provided."]
["The appropriate Thiessen zone may be selected from a pull-down box in cell D7. Each zone is shown on the state map shown on the worksheet, \"Map\"."]
["The NOAA design intensity option may be selected from the drop-down box in cell D7.  Current latitude / longitude are displayed based on the current values in the spreadsheet."]
["If the user selects \"YES\" for cell G11, Internet Explorer will display a map on the NOAA webpage."]
["Check the screen on the NOAA webpage to ensure that \"Precipitation Intensity\" is selected.  Move the small \"X\" under the red cursor to the site and zoom in until the site is located."]
["The NOAA data is displayed below the map.  Copy and paste the interior part of the table from \"5-min\" to the last cell entry for 60-day in the lower right to cells A4 to K41 on sheet \"NOAA Data2\"."]
["Copy the site identification data including latitude and longitude to cell M1 on the \"NOAA Data2\" sheet, as shown."]
["If the user selects \"NO\" for cell G11, the current latitude and longitude entries in spreadsheet NOAA2 will be used in subsequent calculations."]
[]
["It is not necessary to enter a specific value for normal depth, dn or roughness.  The macro assumes initial values.  User values for roughness may be entered by preceding the value"]
["with a specific lower case letter as described below.  Specific upper case letters tell the program to solve for roughness using a specified liner type."]
["When user values for n are entered, actual and allowable shears are calculated.  Actual shear is color flagged if greater than allowable shear.  User roughness options are:"]
["  g.xxx - represents an undeveloped option for Gabion mattress"]
["  r.042 - represents a Class II channel lining with roughness = 0.042."]
["  s.045 - represents a Class III channel lining with roughness = 0.045."]
["  t.039 - represents a TRM, type 1 lining as a vegetative Class C grass with roughness = 0.039 and allowable shear = 6 psf."]
["  u.1.5 - represents a rock lined ditch with D50 = 1.5 feet."]
["  v.039 - represents a Vegetative Class C roughness value = 0.039.  Allowable shear = 1 psf."]
["  R.042 - represents a Class II channel lining that uses a program calculated roughness."]
["  S.045 - represents a Class III channel lining that uses a program calculated roughness."]
["There are no options for G,T,U and V.  When user roughness options are NOT entered, the program will select a liner that satisties hydraulic flow equations and meets shear requirements."]
[]
["User and program selected n values are applied to all design storm return intervals.  Up to 3 channel segments per storm may be entered."]
["The first channel segment contains the drainage area for sheet flow, shallow concentrated flow and the first channel segment."]
["Overland flow, shallow concentrated flow and concentrated channel flow segments calculations may be omitted from the calculations by zeroing out the input data."]
["KYTC's practice has been to include shallow concentrated flow as part of channel flow."]
["The 500 year flow is calculated as Q100 * 1.2."]
[]
["The IDF curve fitting method employed in FHWA's Hydraulic Toolbox 3.0 is included.  The exact same coefficients and design storm intensities are obtained if the same intensity data is used."]
["A summary of the coefficients used for each design storm is shown beginning in cell A21.  The calculated intensities for the FHWA method design equations are compared to the NOAA intensities"]
["for select travel times beginning in cell 45.  The color codes reflect the closeness of agreement of the calculated intensity results to the NOAA data.  The color scheme uses green as"]
["close agreement (maximum difference of 0.03), yellow as reasonably close agreement (> 0.03 but < 0.1) and red as large disagreement (> 0.1 iph)."]
[]
["An option to display additional output columns for each stream segment is available in cell \"U3\".  Enter 0, 2, 5 or 14 before running the macro."]
["  \"0\" displays no additional columns in addition to the 7 usual columns."]
["  \"2\" displays 2 additional columns for normal stream depth and roughness in addition to the 7 usual columns."]
["  \"5\" displays 3 additional columns for stream velocity, Reynolds number and method in addition to the 7 usual columns and 2 additional columns.."]
["  \"14\" displays 9 additional columns for calculated shear, permissible shear, safety factor (rock), Shields' parameter, Reynolds no., delta (rock), cross sectional area,"]
["         required liner, required D50 and D50 used in analysis in addition to the 7 usual columns and 5 additional columns."]
[]
["Press CTRL-r to execute the macro."]
[]
["NOTE:  As the side slope approaches the angle of repose, the Reynolds' number may increase rapidly."]
["     Gabion mattress, Type 1A usually will not be selected as a liner solution because Class III liner calculates to be stronger than a mattress unit based on a current HEC design method."]

{"sheet":"Coeff","index":1,"n_rows":95,"n_cols":42,"rows_kept":95,"cut":false,"hidden":true,"merged":[[88,34,89,34],[90,34,91,34],[92,34,93,34],[80,34,81,34],[82,34,83,34],[84,34,85,34],[86,34,87,34],[57,18,57,23],[62,18,62,23],[69,18,69,23],[74,18,74,23],[78,40,79,40],[78,41,79,41],[78,36,79,36],[78,37,79,37],[78,38,79,38],[78,39,79,39],[40,0,40,6],[15,0,15,6],[20,0,20,6],[25,0,25,6],[30,0,30,6],[35,0,35,6],[30,16,30,25],[0,16,0,20],[0,0,0,6],[5,0,5,6],[3,16,3,17],[10,0,10,6]]}
["Cairo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Segment Summary"]
["Return",2,5,10,25,50,100,null,null,null,null,null,null,null,null,null,"dn","n","V","R","Liner"]
["A0",6.41,8.25,9.4499999999999993,10.95,12.07,13.17]
["A1",-0.02,-3.5000000000000003E-2,-0.04,-4.2999999999999997E-2,-4.5999999999999999E-2,-4.7E-2,null,null,null,null,null,null,null,null,null,"Segm't Sum."]
["A2",-8.2000000000000003E-2,-7.5999999999999998E-2,-7.3999999999999996E-2,-7.1999999999999995E-2,-7.0000000000000007E-2,-7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,"dn","n"]
["Cincinnati"]
["Return",2,5,10,25,50,100]
["A0",7.26,7.98,8.5299999999999994,9.26,9.81,10.37]
["A1",-0.127,-0.04,0,3.7999999999999999E-2,0.06,7.9000000000000001E-2]
["A2",-7.3999999999999996E-2,-8.4000000000000005E-2,-8.7999999999999995E-2,-9.1999999999999998E-2,-9.5000000000000001E-2,-9.7000000000000003E-2]
["Evansville"]
["Return",2,5,10,25,50,100]
["A0",6.68,8.2100000000000009,9.23,10.53,11.49,12.44]
["A1",-7.1999999999999995E-2,-6.6000000000000003E-2,-6.4000000000000001E-2,-6.0999999999999999E-2,-0.06,-5.8999999999999997E-2]
["A2",-7.6999999999999999E-2,-7.3999999999999996E-2,-7.3999999999999996E-2,-7.1999999999999995E-2,-7.1999999999999995E-2,-7.0999999999999994E-2]
["Knoxville"]
["Return",2,5,10,25,50,100,null,"old means - kinematic equation used prior to the current Drainage Manual"]
["A0",5.5,5.68,5.9,6.24,6.52,6.81]
["A1",3.5999999999999997E-2,0.152,0.20399999999999999,0.254,0.28299999999999997,0.307,null,"old","to = 0.42 ( L * N ) ^ 0.8 / ( P2,24 ^ 0.5 * S ^ 0.4 )",null,null,null,null,"not iterative"]
["A2",-9.5000000000000001E-2,-0.106,-0.111,-0.11600000000000001,-0.11899999999999999,-0.122]
["Lexington",null,null,null,null,null,null,null,"current","to = 0.933 ( L * N ) ^ 0.6 / ( I ^ 0.4 * S ^ 0.3 )",null,null,null,null,"note S exponent"]
["Return",2,5,10,25,50,100]
["A0",5.7,6.44,6.96,7.64,8.14,8.66,null,null,"I = Ao * tc ^ ( A1 = A2 * ln ( tc ) )",null,null,null,null,"IDF equation"]
["A1",-4.0000000000000001E-3,5.6000000000000001E-2,8.5999999999999993E-2,0.114,0.13100000000000001,0.14499999999999999]
["A2",-8.7999999999999995E-2,-9.0999999999999998E-2,-9.2999999999999999E-2,-9.5000000000000001E-2,-9.6000000000000002E-2,-9.7000000000000003E-2]
["Louisville",null,null,null,null,null,null,null,null,"L","N","S","to","tc","I100"]
["Return",2,5,10,25,50,100,null,null,28,0.2,0.02,{"$f":"0.933*(J27*K27)^0.6/(O27^0.4*L27^0.3)","v":3.5362586724254235},3.536,{"$f":"$G$23*N27^($G$24+$G$25*LN(N27))","v":8.9095052743796312},"iterative"]
["A0",7.29,8.5299999999999994,9.3699999999999992,10.47,11.28,12.11]
["A1",-0.13500000000000001,-8.4000000000000005E-2,-5.8999999999999997E-2,-3.6999999999999998E-2,-2.5000000000000001E-2,-1.4E-2,null,"P2,24","L","N","S","to-old",null,"I100*"]
["A2",-7.0999999999999994E-2,-7.5999999999999998E-2,-7.9000000000000001E-2,-8.1000000000000003E-2,-8.2000000000000003E-2,-8.4000000000000005E-2,null,3.1,28,0.2,0.02,{"$f":"0.42*(J30*K30)^0.8/(I30^0.5*L30^0.4)","v":4.5259199344218111},null,{"$f":"$G$23*M30^($G$24+$G$25*LN(M30))","v":8.6410276947111697},"not iterative"]
["Nashville",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Summary"]
["Return",2,5,10,25,50,100,null,"* - uses Q100 Lexington Region values in IDF equation",null,null,null,null,null,null,null,"ts","tp","SF","Fx","Re","Delta","A","n Class","D50c","D50"]
["A0",7.31,9.94,11.68,13.89,15.54,17.170000000000002]
["A1",-0.104,-0.159,-0.182,-0.20499999999999999,-0.218,-0.22900000000000001,null,"PI",null,"K1","mu",null,"D50"]
["A2",-7.3999999999999996E-2,-6.3E-2,-5.8999999999999997E-2,-5.3999999999999999E-2,-5.0999999999999997E-2,-4.9000000000000002E-2,null,3.1415926540000001,null,{"$f":"IF(MIN('Design Flows'!A15,'Design Flows'!C15)<1.5,0.77,IF(MIN('Design Flows'!A15,'Design Flows'!C15)>5,1,MIN('Design Flows'!A15,'Design Flows'!C15)*0.066+0.067))","v":0.19900000000000001},0.82089999999999996,null,1]
["Parkersburg",null,null,null,null,null,null,null,null,"Ch Sl",null,null,"Z"]
["Return",2,5,10,25,50,100,null,null,{"$f":"'Design Flows'!E15","v":5.0000000000000001E-3},null,null,{"$f":"'Design Flows'!A15","v":2}]
["A0",6.32,8.08,9.25,10.72,11.82,12.91,null,"Alpha =",{"$f":"ATAN('Design Flows'!E15)","v":4.9999583339583225E-3},"rad","Theta =",{"$f":"ATAN(1/MIN('Design Flows'!A15,'Design Flows'!C15))","v":0.46364760900080609},"rad"]
["A1",-4.2000000000000003E-2,-0.04,-0.04,-3.9E-2,-3.7999999999999999E-2,-3.7999999999999999E-2,null,null,{"$f":"J38*180/$I$35","v":0.28647651023966841},"deg",null,{"$f":"M38*180/$I$35","v":26.565051173609316},"deg"]
["A2",-9.0999999999999998E-2,-8.8999999999999996E-2,-8.7999999999999995E-2,-8.6999999999999994E-2,-8.6999999999999994E-2,-8.5999999999999993E-2]
["Wytheville",null,null,null,null,null,null,null,null,{"$f":"J42*I35/180","v":0.74001960294222213},"rad","num =",{"$f":"COS(J38)","v":0.99998750023437011}]
["Return",2,5,10,25,50,100,null,"Phi =",{"$f":"IF(N35=0.5,42.2,42.4)","v":42.4},"deg","dem = ",{"$f":"(2*SIN(M38)/(N50*TAN(J41)))+SIN(J38)","v":8.0517396706440998}]
["A0",6.09,6.51,6.9,7.45,7.88,8.32,null,null,null,null,"Beta=",{"$f":"ATAN(M41/M42)","v":0.12356250771963447},"rad"]
["A1",-7.0999999999999994E-2,3.7999999999999999E-2,8.5000000000000006E-2,0.128,0.154,0.17399999999999999,null,null,null,null,null,{"$f":"M43*180/I35","v":7.0796101974633032},"deg"]
["A2",-0.08,-9.1999999999999998E-2,-9.6000000000000002E-2,-0.10100000000000001,-0.104,-0.106,null,"num = ",{"$f":"K35*(1+SIN(J38+M43))*TAN(J41)","v":0.20500900892922888}]
[null,null,null,null,null,null,null,null,"tl = ",{"$f":"COS(M38)*TAN(J41)","v":0.81672425852713981}]
[null,null,null,null,null,null,null,null,"tr = ",{"$f":"SIN(M38)*COS(M43)","v":0.4438039768869031},null,"Q10","Re = ",{"$f":"SQRT(32.2*'Design Flows'!H15*'Design Flows'!E15)*N35/0.00001217","v":47603.415771600412}]
[null,null,null,null,null,null,null,null,"diff =",{"$f":"J46-J47","v":0.37292028164023672},null,null,"Fx = ",{"$f":"IF(N47<40000, 0.047,IF(N47>200000,0.15,0.047+((N47-40000)/160000)*0.103))","v":5.1894698902967766E-2}]
[null,null,null,null,null,null,null,null,"dem =",{"$f":"2*J48","v":0.74584056328047343},null,null,"ts = ",{"$f":"62.4*'Design Flows'!H15*'Design Flows'!E15","v":0.65040834907501155}]
[null,null,null,null,null,null,null,null,"Delta =",{"$f":"J45/J49","v":0.27486974967884015},null,null,"mu = ",{"$f":"N49/(N48*102.96*N35)","v":0.12172914654153998}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cn = alpha * Cs ^ 0.10 *h ^ 0.528",null,null,null,"(h in FT)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cn per Veg Class"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D","E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h (in)",36,24,8,4,1.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cs",33,7.1,3.9,2.7,3.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cn",{"$f":"0.237*T61^0.1*(T60/12)^0.528","v":0.60050933435173826},{"$f":"0.237*U61^0.1*(U60/12)^0.528","v":0.41573636894609101},{"$f":"0.237*V61^0.1*(V60/12)^0.528","v":0.21921921685548709},{"$f":"0.237*W61^0.1*(W60/12)^0.528","v":0.14654287240083319},{"$f":"0.237*X61^0.1*(X60/12)^0.528","v":9.3474759965750248E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cn (general)",null,null,null,null,null,"(Cn = 0.2 is typical)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h (ft)","Ex","VG","G","F","P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,{"$f":"0.237*$T$68^0.1*$S$65^0.528","v":0.16822102643793529},{"$f":"0.237*$U$68^0.1*S65^0.528","v":0.15727318120292302},{"$f":"0.237*$V$68^0.1*S65^0.528","v":0.14199888084506929},{"$f":"0.237*$W$68^0.1*S65^0.528","v":0.12216974577718247},{"$f":"0.237*$X$68^0.1*S65^0.528","v":0.11045692699106957}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"0.237*$T$68^0.1*S66^0.528","v":0.24256275480753267},{"$f":"0.237*$U$68^0.1*S66^0.528","v":0.22677674068289022},{"$f":"0.237*$V$68^0.1*S66^0.528","v":0.20475228600554565},{"$f":"0.237*$W$68^0.1*S66^0.528","v":0.17616008365507527},{"$f":"0.237*$X$68^0.1*S66^0.528","v":0.15927103208119736}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,{"$f":"0.237*$T$68^0.1*S67^0.528","v":0.30046943551077027},{"$f":"0.237*$U$68^0.1*S67^0.528","v":0.28091484743413014},{"$f":"0.237*$V$68^0.1*S67^0.528","v":0.25363252426961452},{"$f":"0.237*$W$68^0.1*S67^0.528","v":0.21821454385018718},{"$f":"0.237*$X$68^0.1*S67^0.528","v":0.19729359167539026}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cs",49,25,9,2,0.73]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cf (general)",null,null,null,null,null,null,null,"n = 0.213 * Cn * bo ^ -0.4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Growth","Ex","VG","G","F","P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sod",0.98,0.95,0.9,0.84,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bunch",0.55000000000000004,0.53,0.5,0.47,0.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mixed",0.82,0.79,0.75,0.7,0.62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cf per veg class (interpolated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e","PI","p,soil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Growth","A","B","C","D","E",null,null,null,null,null,null,null,null,null,null,null,null,0.5,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sod","> 0.55","> 0.98",{"$f":"T72","v":0.98},{"$f":"(W62-V65)/(U65-V65)*(U72-V72)+V72","v":0.91487463075003461},"< 0.75"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bunch","> 0.55","> 0.55",{"$f":"($V$62-V66)/(U66-V66)*(U73-V73)+V73","v":0.51970572855747865},"< 0.41","< 0.41"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mixed","> 0.55","> 0.98",{"$f":"(V62-W67)/(V67-W67)*(V74-W74)+W74","v":0.70141830927879334},"< 0.62","< 0.62",null,null,null,null,null,null,null,null,null,null,"ASTM Soil ","Applicable ","C1 ","C2 ","C3 ","C4 ","C5 ","C6 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classification","Range"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GM ","10 < PI < 20",1.07,14.3,47.7,1.42,-0.61,1E-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,"20 < PI ",1.07,14.3,7.5999999999999998E-2,1.42,-0.61,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,"GC ","10 < PI < 20",4.7699999999999999E-2,2.86,42.9,1.42,-0.61,1E-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,"20 < PI ",4.7699999999999999E-2,2.86,0.11899999999999999,1.42,-0.61,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,"SM ","10 < PI < 20",1.07,7.15,11.9,1.42,-0.61,1E-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,"20 < PI ",1.07,7.15,5.8000000000000003E-2,1.42,-0.61,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,"SC ","10 < PI < 20",1.07,14.3,47.7,1.42,-0.61,1E-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,"20 < PI ",1.07,14.3,7.5999999999999998E-2,1.42,-0.61,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,"ML ","10 < PI < 20",1.07,7.15,11.9,1.48,-0.56999999999999995,1E-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,"20 < PI ",1.07,7.15,5.8000000000000003E-2,1.48,-0.56999999999999995,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,"CL ","10 < PI < 20",1.07,14.3,47.7,1.48,-0.56999999999999995,1E-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,"20 < PI ",1.07,14.3,7.5999999999999998E-2,1.48,-0.56999999999999995,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,"MH ","10 < PI < 20",4.7699999999999999E-2,1.43,10.7,1.38,-0.373,1E-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,"20 < PI ",4.7699999999999999E-2,1.43,5.8000000000000003E-2,1.38,-0.373,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,"CH ","20 < PI ",null,null,9.7000000000000003E-2,1.38,-0.373,1]

{"sheet":"Map","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet1","index":3,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":true,"merged":[[3,8,3,10],[4,9,4,10]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"HYCHL Input / Output"]
[null,null,null,null,null,null,null,"iterate","Output","Input"]
[null,null,null,null,null,null,"T",{"$f":"K12+H8*(K7+K8)","v":5.0282},{"$f":"K12+I8*(K7+K8)","v":5.54},"Sl",0.14000000000000001]
[null,null,null,null,null,null,"da/D50",{"$f":"H8/H9","v":0.50470000000000004},{"$f":"I8/K9","v":0.59},"lss",3]
[null,null,null,null,null,null,"da",0.50470000000000004,0.59,"rss",3]
[null,null,null,null,null,null,"D50",1,null,"D50",1]
[null,null,null,null,null,null,"A",{"$f":"H8*(K12+H8/2*(K7+K8))","v":1.7735662700000001},2.2400000000000002,"Q",9.99]
[]
[null,null,null,null,null,null,"WP",{"$f":"K12+H8*((K7^2+1)^0.5+(K8^2+1)^0.5)","v":5.1920030701739623},5.75,"BW",2]
[null,null,null,null,null,null,"V",{"$f":"K10/H10","v":5.6327187593616106},4.46]
[null,null,null,null,null,null,"Rh",{"$f":"H10/H12","v":0.34159576680307613},{"$f":"I10/I12","v":0.3895652173913044}]
[null,null,null,null,null,null,"n",{"$f":"1.486*H14^(2/3)*K6^0.5/H13","v":4.8236199178445897E-2},6.8000000000000005E-2]
[]
[]
[]
[null,null,null,null,null,null,"for da/D50 >185",null,null,"unknown"]
[null,null,null,null,null,null,"pg. 20 eq. 27 (HYCHL Manual)"]
[null,null,null,null,null,null,"n",{"$f":"0.0232*H8^(1/6)","v":2.0701105356966915E-2}]
[]
[null,null,null,null,null,null,"for da/D50 >2 and < 185",null,null,"unknown"]
[null,null,null,null,null,null,"pg. 19 eq. 26"]
[null,null,null,null,null,null,"num",{"$f":"4.657*H14^(1/6)","v":3.8936626208645917}]
[null,null,null,null,null,null,"dem",{"$f":"32.25+5.23*LOG(H14/H9)","v":29.810270270882885}]
[null,null,null,null,null,null,"n",{"$f":"H25/H26","v":0.13061480441080461}]
[]
[null,null,null,null,null,null,"for da/D50 <2",null,null,null,null,"Bathurst"]
[null,null,null,null,null,null,"pg. 20 eq. 28"]
[null,null,null,null,null,null,null,null,null,"f(FR)",{"$f":"((0.28/H34)*H32)^LOG(0.755/H34)","v":1.0871408243243774}]
[null,null,null,null,null,null,"Fr",{"$f":"H13/(32.2*H8)^0.5","v":1.3972479442461936},null,"f(REG)",{"$f":"13.434*(H6/K9)^0.492*H34^(1.025*(H6/K9)^0.118)","v":7.0739159975089185}]
[null,null,null,null,null,null,"a",{"$f":"(1.175*(K9/H6)^0.557)^H35","v":0.54818992620150342},null,"f(CG)",{"$f":"(H6/H8)^-H34","v":0.48568446530702214}]
[null,null,null,null,null,null,"b",{"$f":"H33*(H8/K9)^H35","v":0.314154957391725},null,"f(FR)*f(REG)*f(CG)",null,{"$f":"K31*K32*K33","v":3.7350800642283777}]
[null,null,null,null,null,null,"c",{"$f":"0.648*0.182^-0.134","v":0.81418939234477206},null,null,null,null,{"$f":"L34-L36","v":7.7785584018208453E-4},"diff."]
[null,null,null,null,null,null,null,null,null,"V/sqr(g*da*S)",null,{"$f":"H13/(32.2*H8*K6)^0.5","v":3.7343022083881956}]
[]
[null,null,null,null,null,null,"user",null,null,"Anderson"]
[null,null,null,null,null,null,"pg. 22 eq. 35",null,null,"user n"]
[null,null,null,null,null,null,"n",{"$f":"0.0481*K9^(1/6)","v":4.8099999999999997E-2}]

{"sheet":"NOAA Data2","index":4,"n_rows":69,"n_cols":32,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,29,1,31],[12,18,14,18],[12,25,12,26],[13,25,13,26],[14,25,14,26],[1,19,1,24],[2,25,2,26],[3,18,5,18],[3,25,3,26],[4,25,4,26],[5,25,5,26],[6,18,8,18],[6,25,6,26],[7,25,7,26],[8,25,8,26],[9,18,11,18],[9,25,9,26],[10,25,10,26],[11,25,11,26],[15,18,17,18],[15,25,15,26],[16,25,16,26],[17,25,17,26],[1,1,1,10],[0,0,0,10],[1,0,2,0],[52,1,52,6],[53,7,53,8],[56,7,56,8],[57,0,59,0],[57,7,57,8],[58,7,58,8],[59,7,59,8],[66,0,68,0],[66,7,66,8],[67,7,67,8],[68,7,68,8],[42,1,42,3],[60,0,62,0],[60,7,60,8],[61,7,61,8],[62,7,62,8],[63,0,65,0],[63,7,63,8],[64,7,64,8],[65,7,65,8],[54,0,56,0],[54,7,54,8],[55,7,55,8]]}
["PDS-based precipitation frequency estimates with 90% confidence intervals (in inches/hour)",null,null,null,null,null,null,null,null,null,null,null,"LOCATION INFORMATION:"]
["Duration","Average recurrence interval(years)",null,null,null,null,null,null,null,null,null,null,"Name: Monticello, Kentucky, USA*",null,null,null,{"$f":"MID(M2,7,40)","v":"Monticello, Kentucky, USA*"},null,null,"DESIGN STORM",null,null,null,null,null,null,null,null,null,"IDF Variables*"]
[null,1,2,5,10,25,50,100,200,500,1000,null,null,null,null,null,null,null,"tc",2,5,10,25,50,100,"IDF",null,null,"RI","a","b","m"]
["5-min",4.12,4.84,5.64,6.3,7.15,7.81,8.5,9.17,10.1,10.8,null,"Station name: -",null,null,null,null,null,5,null,null,null,null,null,null,"FHWA",null,null,2]
["10-min",3.29,3.86,4.5199999999999996,5.03,5.69,6.22,6.74,7.27,7.96,8.48,null,"Site ID: -",null,null,null,null,null,null,null,null,null,null,null,null,"NOAA",null,null,5]
["15-min",2.74,3.24,3.81,4.24,4.8099999999999996,5.25,5.68,6.12,6.68,7.1,null,"Latitude: 36.9190°",null,null,null,{"$f":"MID(M6,10,8)","v":" 36.9190"},null,null,null,null,null,null,null,null,"Diff",null,null,10]
["30-min",1.88,2.2400000000000002,2.71,3.08,3.56,3.95,4.3499999999999996,4.76,5.32,5.75,null,"Longitude: -84.7700°",null,null,null,{"$f":"MID(M7,12,8)","v":"-84.7700"},null,10,null,null,null,null,null,null,"FHWA",null,null,25]
["60-min",1.17,1.4,1.73,2,2.37,2.68,3,3.34,3.81,4.2,null,"Elevation: 898.35 ft **",null,null,null,null,null,null,null,null,null,null,null,null,"NOAA",null,null,50]
["2-hr",0.68600000000000005,0.82,1.01,1.1599999999999999,1.39,1.57,1.77,1.97,2.27,2.5099999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff",null,null,100]
["3-hr",0.497,0.59099999999999997,0.72499999999999998,0.83699999999999997,0.996,1.1299999999999999,1.27,1.42,1.63,1.81,null,null,null,null,null,null,null,15,null,null,null,null,null,null,"FHWA"]
["6-hr",0.30399999999999999,0.36099999999999999,0.44,0.50800000000000001,0.60499999999999998,0.68500000000000005,0.77200000000000002,0.86399999999999999,0.996,1.1000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOAA"]
["12-hr",0.184,0.218,0.26600000000000001,0.30599999999999999,0.36299999999999999,0.41099999999999998,0.46100000000000002,0.51500000000000001,0.59299999999999997,0.65600000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff"]
["24-hr",0.111,0.13200000000000001,0.16200000000000001,0.185,0.218,0.245,0.27300000000000002,0.30199999999999999,0.34200000000000003,0.374,null,null,null,null,null,null,null,30,null,null,null,null,null,null,"FHWA"]
["2-day",6.7000000000000004E-2,0.08,9.7000000000000003E-2,0.112,0.13300000000000001,0.14899999999999999,0.16700000000000001,0.186,0.21199999999999999,0.23200000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOAA"]
["3-day",4.8000000000000001E-2,5.7000000000000002E-2,7.0000000000000007E-2,0.08,9.4E-2,0.105,0.11700000000000001,0.129,0.14599999999999999,0.16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff"]
["4-day",3.7999999999999999E-2,4.5999999999999999E-2,5.6000000000000001E-2,6.3E-2,7.3999999999999996E-2,8.3000000000000004E-2,9.1999999999999998E-2,0.10100000000000001,0.113,0.123,null,null,null,null,null,null,null,60,null,null,null,null,null,null,"FHWA"]
["7-day",2.5999999999999999E-2,3.1E-2,3.7999999999999999E-2,4.3999999999999997E-2,5.0999999999999997E-2,5.7000000000000002E-2,6.4000000000000001E-2,7.0999999999999994E-2,0.08,8.6999999999999994E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOAA"]
["10-day",2.1000000000000001E-2,2.5000000000000001E-2,0.03,3.4000000000000002E-2,0.04,4.3999999999999997E-2,4.9000000000000002E-2,5.2999999999999999E-2,5.8999999999999997E-2,6.4000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff"]
["20-day",1.4999999999999999E-2,1.7000000000000001E-2,2.1000000000000001E-2,2.3E-2,2.5999999999999999E-2,2.8000000000000001E-2,3.1E-2,3.3000000000000002E-2,3.5999999999999997E-2,3.7999999999999999E-2]
["30-day",1.2E-2,1.4E-2,1.7000000000000001E-2,1.7999999999999999E-2,2.1000000000000001E-2,2.3E-2,2.4E-2,2.5999999999999999E-2,2.8000000000000001E-2,0.03]
["45-day",0.01,1.2E-2,1.4E-2,1.4999999999999999E-2,1.7000000000000001E-2,1.7999999999999999E-2,1.9E-2,2.1000000000000001E-2,2.1999999999999999E-2,2.3E-2]
["60-day",8.9999999999999993E-3,1.0999999999999999E-2,1.2E-2,1.4E-2,1.4999999999999999E-2,1.6E-2,1.7000000000000001E-2,1.7999999999999999E-2,1.9E-2,0.02]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IDF Variables*",null,null,"* I = a / (tc + b) ^ m"]
["RI","a","b","m"]
[2,50.781514830241903,11.396712934833801,0.84038245008875734]
[5,45.492849251878013,10.185413496998077,0.76743152461159503]
[10,38.208357809045275,8.3274986324320253,0.69599356714143323]
[25,32.861149354596428,6.5328359996261653,0.62374440169826684]
[50,30.161129721014216,5.4295416205491165,0.5762708557836479]
[100,27.160888485498237,4.0841218106488668,0.52648859839024631]
[]
[]
[null,"DESIGN STORM"]
["tc",2,5,10,25,50,100,"IDF"]
[5,4.8400000000000203,5.6399999999998922,6.3000000000000744,7.1499999999999551,7.8100000000000218,8.4999999999999396,"FHWA"]
[null,4.84,5.64,6.3,7.15,7.81,8.5,"NOAA"]
[null,2.042810365310288E-14,-1.0746958878371515E-13,7.460698725481052E-14,-4.5297099404706387E-14,2.2204460492503131E-14,-6.0396132539608516E-14,"Diff"]
[10,3.869949787235913,4.5333171596543185,5.0471553600956049,5.7114371962591282,6.2320996679123271,6.7476235389275407,"FHWA"]
[null,3.86,4.5199999999999996,5.03,5.69,6.22,6.74,"NOAA"]
[null,9.9497872359131101E-3,1.33171596543189E-2,1.7155360095604699E-2,2.1437196259127766E-2,1.2099667912327305E-2,7.6235389275405296E-3,"Diff"]
[15,3.243845091352775,3.8252265279377426,4.2670813572493698,4.8436005350426319,5.3013166654471551,5.7502227883858188,"FHWA"]
[null,3.24,3.81,4.24,4.8099999999999996,5.25,5.68,"NOAA"]
[null,3.8450913527747765E-3,1.5226527937742595E-2,2.7081357249369553E-2,3.3600535042632274E-2,5.1316665447155074E-2,7.0222788385819079E-2,"Diff"]
[30,2.2224700781329938,2.6725783642105339,3.0202665083275511,3.4831143688505914,3.860054198368009,4.2371394823659223,"FHWA"]
[null,2.2400000000000002,2.71,3.08,3.56,3.95,4.3499999999999996,"NOAA"]
[null,-1.7529921867006415E-2,-3.7421635789466112E-2,-5.9733491672449013E-2,-7.6885631149408606E-2,-8.9945801631991174E-2,-0.11286051763407734,"Diff"]
[60,1.4057464962880353,1.7421080721041828,2.0197224387870603,2.3964823115499936,2.7106287359556758,3.0388584219408066,"FHWA"]
[null,1.4,1.73,2,2.37,2.68,3,"NOAA"]
[null,5.7464962880353632E-3,1.2108072104182854E-2,1.9722438787060259E-2,2.6482311549993476E-2,3.0628735955675612E-2,3.8858421940806576E-2,"Diff"]

{"sheet":"Design Flows","index":5,"n_rows":39,"n_cols":35,"rows_kept":39,"cut":false,"hidden":false,"merged":[[18,5,18,11],[4,13,4,16],[5,13,5,16],[6,13,6,16],[12,7,12,13],[16,14,16,16],[16,12,16,13],[14,14,14,16],[15,14,15,16],[14,12,14,13],[15,12,15,13],[18,12,18,16],[7,0,7,1],[8,12,8,16],[8,4,8,11],[9,8,9,9],[9,4,9,5],[8,0,8,3],[7,2,7,16],[1,0,1,4],[2,0,2,4],[3,0,3,1],[1,14,1,16],[3,11,3,12],[1,5,2,13],[3,2,3,10],[2,14,2,16],[3,13,3,16],[5,0,5,2],[4,0,4,2],[6,0,6,2],[5,11,5,12],[4,3,4,10],[5,3,5,10],[4,11,4,12],[6,11,6,12],[6,3,6,4],[6,5,6,10],[10,2,10,3],[9,2,9,3],[11,0,11,16],[12,14,13,16],[13,12,13,13],[12,0,12,6],[10,4,10,5],[10,7,10,11],[9,6,9,7],[9,10,9,11]]}
[]
["Kentucky Transportation Cabinet",null,null,null,null,"RATIONAL FLOW ANALYSIS and DESIGN",null,null,null,null,null,null,null,null,"DR 401",null,null,null,"Cols."]
["Division of Highway Design 05-18-19",null,null,null,null,null,null,null,null,null,null,null,null,null,"page 1 of 1",null,null,"v17a",5,"(enter 0, 2, 5 or 14)",null,null,null,null,null,"V=",{"$f":"O21","v":1.8580624449163521},"D50=",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"dn",{"$f":"M21","v":1.7866611174266971},null,"Fr=",{"$f":"AA3/SQRT(32.2*AF3)","v":0.24496908305310963}]
["County:",null,"Wayne",null,null,null,null,null,null,null,null,"Road Name:",null,null,null,null,null,null,null,"for additional output columns ",null,null,null,null,null,null,null,"T=",{"$f":"B15+AF3*(A15+C15)","v":15.146644469706789},null,"num",{"$f":"0.262*AF3^(1/6)","v":0.28860797148354345}]
["Federal Proj. No.:",null,null,"BRO 5145 (003)",null,null,null,null,null,null,null,"Route No.:",null,"KY 90",null,null,null,null,null,null,null,null,null,null,null,null,null,"b=",{"$f":"1.14*(AC3/AC4)^0.453*(AF3/AC3)^0.814","v":{"$error":"#REF!"}},null,"dem",{"$f":"2.25+5.23*LOG(AF3/1)","v":3.5681806332402948}]
["State Proj. No.:",null,null,"FD52 100 196 005-006",null,null,null,null,null,null,null,"Item No.:",null,"8-109.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blodg","n",{"$f":"AF4/AF5","v":8.0883789569099293E-2}]
["Intensity Region:",null,null,"NOAA",null,null,null,null,null,null,null,"Station No.:"]
["Comments:",null,"Zollicoffer Estates Storm Sewer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dn/D50=",{"$f":"AF3/AC3","v":{"$error":"#REF!"}}]
["Overland Sheet Flow",null,null,null,"NOAA IDF Data Retrieval Information",null,null,null,null,null,null,null,"Shallow Concentrated Flow"]
["Lo","no","So",null,"latitude:",null," 36.9190",null,"longitude:",null,"-84.7700",null,"k","Sc","Ls","Vs","tsc",null,null,null,null,null,null,null,null,null,null,null,null,"Bath","num",{"$f":"1.49*AF3^(1/6)","v":1.6413201431697699}]
[150,0.24,0.11700000000000001,null,"Need IDF Data?",null,"No","Monticello, Kentucky, USA*",null,null,null,null,0.21299999999999999,8.5900000000000004E-2,3539,2.0476231411233852,28.805756366366015,null,null,null,null,null,null,null,null,null,null,null,null,null,"f(Fr)",{"$f":"(0.28*AI3/AC5)^LOG(0.755/AC5)","v":{"$error":"#REF!"}}]
[]
["Channel Flow Segments",null,null,null,null,null,null,"Q10 Storm Results",null,null,null,null,null,null,"Comments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f(REG)",{"$f":"13.434*(AC4/AC3)^0.492*AC5^(1.025*(AC4/AC3)^0.118)","v":{"$error":"#REF!"}}]
["LSS","W","RSS","L","Sl","Ar","C","dn","n","R","Shear","Q","Liner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f(CG)",{"$f":"(AC4/AF3)^-AC5","v":{"$error":"#REF!"}}]
[2,8,2,1,5.0000000000000001E-3,94.7,0.21,2.0846421444711907,6.3826629248345493E-2,1.4644629260344184,0.65040834907501155,53.858060136592172,"ECB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dem",{"$f":"SQRT(32.2)*AF11*AF13*AF14","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,94.7,0.21]
[null,null,null,null,null,"Watershed Results",null,null,null,null,null,null,"Segment Summary"]
[null,null,null,null,null,"RI","tov","tsc","tch","tc","I","Q","dn","n","V","R","Liner"]
[null,null,null,null,null,2,8.6874364350532609,28.805756366366015,8.969917406310304E-3,37.502162718825588,1.9321841968984346,38.42534712371917,1.7866611174266971,6.7123493529834988E-2,1.8580624449163521,1.2931430456286417,"ECB"]
[]
[]
[null,null,null,null,null,5,8.0781481561788056,28.805756366366015,8.2735936037340915E-3,36.892178116148557,2.366861020856172,47.069765121766693,1.9602132929269516,6.5080939393361528E-2,2.0144410597040396,1.3936600455242887,"ECB"]
[]
[]
[null,null,null,null,null,10,7.6863050207375068,28.805756366366015,7.8504507441850575E-3,36.499911837847705,2.7082865605414566,53.85969482948795,2.0846421444711907,6.3826629248345493E-2,2.123020347463731,1.4644629260344184,"ECB"]
[]
[]
[null,null,null,null,null,25,7.2597753486913916,28.805756366366015,7.3946637179411988E-3,36.072926378775342,3.1645429464235497,62.933265575525127,2.2380348282573741,6.245206345526428E-2,2.2538775666335442,1.5504578081648444,"ECB"]
[]
[]
[null,null,null,null,null,50,6.9749438299492965,28.805756366366015,7.0858683017779745E-3,35.787786064617087,3.5377257945038685,70.354752875298431,2.3537896185355258,6.1480875530766442E-2,2.3520994120769498,1.6144992884278493,"ECB"]
[]
[]
[null,null,null,null,null,100,6.7193188822436722,28.805756366366015,6.8095011227896933E-3,35.531884749732477,3.9145628467270708,77.848911332861263,2.4614463239940276,6.0512810671660096E-2,2.4475606018901312,1.6734604439267418,"ECB"]
[]
[]
[null,null,null,null,null,500,null,null,null,null,null,93.41869359943351]

{"sheet":"Versions","index":6,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,2,0]]}
["v16f","Added fix to correct new NOAA data format as copied by user to spreadsheet."]
["v17","Change error message for blank intensity region.  Tweaked NOAA page format. (3-18)"]
[null,"Removed TC form designation.  Changed name to DR 401. (3-18)"]
["v17a","Corrected lat / long display for NOAA data retrieval"]