{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["UnitHydrographs","StdUH","DesignHydrograph"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"UnitHydrographs","index":0,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Watershed A",null,null,null,null,null,"Watershed B",null,"CN",null,null,null,"Watershed C",null,"CN"]
["Forest",1,null,null,null,null,"Soils group B",null,null,null,null,null,"Soils Group C"]
["Soils group A",null,null,null,null,null,"Forest",0.3,null,{"$f":"I3*H3","v":0},null,null,"Residential",0.6,null,{"$f":"O3*N3","v":0}]
["CN",70,null,null,null,null,"Meadow",0.6,null,null,null,null,"C&B",0.2]
[null,null,null,null,null,null,"Residential",0.1,null,null,null,null,"Open",0.2]
[]
["Overall",{"$f":"B4","v":70},null,null,null,null,"Overall",null,{"$f":"SUM(J3:J5)","v":0},null,null,null,"Overall",null,{"$f":"SUM(P3:P5)","v":0}]
["S",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1000/O7-10","v":{"$error":"#DIV/0!"}}]
["Slp",20,"%",null,null,null,null,null,15,"%",null,null,null,null,3,"%"]
["Length",4,"mi",null,null,null,null,null,3,"mi",null,null,null,null,3.5,"mi"]
["Length",{"$f":"B10*5280","v":21120},"ft",null,null,null,null,null,{"$f":"I10*5280","v":15840},"ft",null,null,null,null,{"$f":"O10*5280","v":18480},"ft"]
["Area",3,"mi^2",null,null,null,null,null,4,"mi^2",null,null,null,null,3.5,"mi^2"]
["tp",null,"hr",null,null,null,null,null,null,"hr",null,null,null,null,{"$f":"O11^0.8*(O8+1)^0.7/(1900*O9^0.5)","v":{"$error":"#DIV/0!"}},"hr"]
[]
["Use D=",0.25,"hr"]
["TR",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O13+$B$15/2","v":{"$error":"#DIV/0!"}}]
["Qp",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"484*O12/O16","v":{"$error":"#DIV/0!"}}]
["B",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1.67*O16","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Interpolated A",null,null,null,null,null,null,"Interpolated B",null,null,null,null,null,"Interpolated C"]
["t","Q",null,"t","Q",null,null,"t","Q",null,"t","Q",null,"t","Q",null,"t","Q"]
[{"$f":"StdUH!$A4*B$16","v":0},{"$f":"B$17*StdUH!$B4","v":0},null,0,{"$f":"Linterp($A$22:$B$55,D22)","v":0},null,null,{"$f":"StdUH!$A4*I$16","v":0},{"$f":"I$17*StdUH!$B4","v":0},null,0,{"$f":"Linterp($H$22:$I$55,K22)","v":0},null,{"$f":"StdUH!$A4*O$16","v":{"$error":"#DIV/0!"}},{"$f":"O$17*StdUH!$B4","v":{"$error":"#DIV/0!"}},null,0,{"$f":"Linterp($N$22:$O$55,Q22)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"D22+$B$15","v":0.25},{"$f":"Linterp($A$22:$B$55,D23)","v":{"$error":"#VALUE!"}},null,null,{"$f":"StdUH!$A5*I$16","v":0},{"$f":"I$17*StdUH!$B5","v":0},null,{"$f":"K22+$B$15","v":0.25},{"$f":"Linterp($H$22:$I$55,K23)","v":{"$error":"#VALUE!"}},null,{"$f":"StdUH!$A5*O$16","v":{"$error":"#DIV/0!"}},{"$f":"O$17*StdUH!$B5","v":{"$error":"#DIV/0!"}},null,{"$f":"Q22+$B$15","v":0.25},{"$f":"Linterp($N$22:$O$55,Q23)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"StdUH!$A6*O$16","v":{"$error":"#DIV/0!"}},{"$f":"O$17*StdUH!$B6","v":{"$error":"#DIV/0!"}}]

{"sheet":"StdUH","index":1,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["SCS Dimensionless Unit Hydrograph"]
["Time Ratios","Discharge Ratios"]
["(t/tp)","(q/qp)"]
[0,0]
[0.1,0.03]
[0.2,0.1]
[0.3,0.19]
[0.4,0.31]
[0.5,0.47]
[0.6,0.66]
[0.7,0.82]
[0.8,0.93]
[0.9,0.99]
[1,1]
[1.1000000000000001,0.99]
[1.2,0.93]
[1.3,0.86]
[1.4,0.78]
[1.5,0.68]
[1.6,0.56000000000000005]
[1.7,0.46]
[1.8,0.39]
[1.9,0.33]
[2,0.28000000000000003]
[2.2000000000000002,0.20699999999999999]
[2.4,0.14699999999999999]
[2.6,0.107]
[2.8,7.6999999999999999E-2]
[3,5.5E-2]
[3.2,0.04]
[3.4,2.9000000000000001E-2]
[3.6,2.1000000000000001E-2]
[3.8,1.4999999999999999E-2]
[4,1.0999999999999999E-2]
[4.5,5.0000000000000001E-3]
[5,0]
[100,0]

{"sheet":"DesignHydrograph","index":2,"n_rows":84,"n_cols":13,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["Design Rainfall"]
["Dur",0.25,0.5,1,2,3]
["Cum",1.1299999999999999,1.52,1.89,2.15,2.23]
[]
[]
[null,null,null,"Threshold",0.5,"in"]
["t","P (in per Dt)","Cum P"]
[0.25,{"$f":"B19","v":2.0000000000000018E-2},{"$f":"B8","v":2.0000000000000018E-2},null,{"$f":"MAX(B8-$E$6,0)","v":0}]
[{"$f":"A8+$B$2","v":0.5},{"$f":"B18","v":2.0000000000000018E-2},{"$f":"C8+B9","v":4.0000000000000036E-2},null,{"$f":"MAX(B9-$E$6,0)","v":0}]
[{"$f":"A9+$B$2","v":0.75},{"$f":"B11","v":6.5000000000000002E-2},{"$f":"C9+B10","v":0.10500000000000004},null,0]
[1,{"$f":"B16","v":6.5000000000000002E-2},0.17000000000000004,null,0]
[1.25,{"$f":"(D3-C3)/2","v":0.18499999999999994},0.35499999999999998,null,0]
[1.5,{"$f":"C3-B3","v":0.39000000000000012},0.74500000000000011,null,0]
[1.75,{"$f":"B3","v":1.1299999999999999},1.875,null,0.62999999999999989]
[2,{"$f":"(D3-C3)/2","v":0.18499999999999994},2.06,null,0]
[2.25,{"$f":"(E3-D3)/4","v":6.5000000000000002E-2},2.125,null,0]
[2.5,{"$f":"B16","v":6.5000000000000002E-2},2.19,null,0]
[2.75,{"$f":"(F3-E3)/4","v":2.0000000000000018E-2},2.21,null,0]
[3,{"$f":"B18","v":2.0000000000000018E-2},2.23,null,0]
[]
[null,null,null,null,{"$f":"SUM(E8:E19)","v":0.62999999999999989}]
[]
["Watershed","A","B","C"]
["S",{"$f":"UnitHydrographs!B8","v":0},{"$f":"UnitHydrographs!I8","v":0},{"$f":"UnitHydrographs!O8","v":{"$error":"#DIV/0!"}}]
[]
["P",{"$f":"F3","v":2.23},{"$f":"B26","v":2.23},{"$f":"C26","v":2.23},"in"]
["Ia",{"$f":"0.2*B24","v":0},{"$f":"0.2*C24","v":0},{"$error":"#DIV/0!"},"in"]
["Q",{"$f":"(B26-0.2*B24)^2/(B26+0.8*B24)","v":2.23},{"$f":"(C26-0.2*C24)^2/(C26+0.8*C24)","v":2.23},{"$f":"(D26-0.2*D24)^2/(D26+0.8*D24)","v":{"$error":"#DIV/0!"}},"in"]
["F",{"$f":"(B27-0.2*B25)^2/(B27+0.8*B25)","v":{"$error":"#DIV/0!"}},{"$f":"C26-C27-C28","v":0},{"$f":"D26-D27-D28","v":{"$error":"#DIV/0!"}},"in"]
[]
["Excess Rainfall Hyetographs after having subtracted infiltration and Ia"]
["t","A","B","C"]
[0.25]
[{"$f":"A33+$B$2","v":0.5}]
[{"$f":"A34+$B$2","v":0.75}]
[1]
[1.25]
[1.5]
[1.75]
[2]
[2.25]
[2.5]
[2.75]
[3]
[]
[]
["Hydrographs",null,"P",null,null,"P",null,null,"P"]
[null,null,{"$f":"B39","v":0},null,null,{"$f":"C39","v":0},null,null,{"$f":"D38","v":0},{"$f":"D39","v":0},null,"A+B lagged 0.75 hr (3 time steps)"]
["t","UH A","H A",null,"UH B","H B",null,"UH C","H C",null,null,null,"Comb A +B + C"]
[1.5,{"$f":"UnitHydrographs!E22","v":0},null,null,{"$f":"UnitHydrographs!L22","v":0},null,null,{"$f":"UnitHydrographs!R22","v":{"$error":"#VALUE!"}},{"$f":"H50*$I$48","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"I50+J50+L50","v":{"$error":"#VALUE!"}}]
[{"$f":"A50+0.25","v":1.75},null,{"$f":"B50*$C$48","v":0},null,null,{"$f":"E50*$F$48","v":0},null,null,null,{"$f":"H50*$J$48","v":{"$error":"#VALUE!"}}]
[{"$f":"A51+0.25","v":2}]
[2.25]
[2.5,null,null,null,null,null,null,null,null,null,null,{"$f":"C51+F51","v":0}]
[2.75]
[3]
[3.25]
[3.5]
[3.75]
[4]
[4.25]
[4.5]
[4.75]
[5]
[5.25]
[5.5]
[5.75]
[6]
[6.25]
[6.5]
[6.75]
[7]
[7.25]
[7.5]
[7.75]
[8]
[{"$f":"A76+0.25","v":8.25}]
[8.5]
[8.75]
[9]
[9.25]
[9.5]
[9.75]
[10]