{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["START","Generation | Propagation (2D)","Generation | Propagation (3D)","Run-up | Overtopping","Overland flow","Wave force"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":14,"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":"START","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,0,14,8],[3,1,3,8],[6,0,6,8],[8,0,8,8],[10,0,10,8],[12,0,12,8]]}
["Landslide-generated Impulse Waves in Reservoirs - Basics and Computation"]
["Computational tool v1.0"]
[]
["Project:"]
[]
["Generation | Propagation (2D)"]
["Computes 2D impulse wave characteristics based on governing slide parameters at a streamwise distance x (Figure 3-2a)"]
["Generation | Propagation (3D)"]
["Computes 3D impulse wave characteristics based on governing slide parameters at a radial distance r and a propagation angle γ (Figure 3-2b)"]
["Run-up | Overtopping "]
["Computes run-up heights and overtopping characteristics based on governing impulse wave (2D or 3D input) and shore/dam parameters"]
["Overland flow"]
["Computes overland flow characteristics based on governing impulse wave (2D or 3D input) and shore parameters"]
["Wave force"]
["Computes wave force based on governing impulse wave (2D or 3D input) and dam parameters"]
[]
["Colour coding"]
[null,"Insert parameter value"]
[null,"Within limitation range"]
[null,"Outside limitation range"]

{"sheet":"Generation | Propagation (2D)","index":1,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Generation | Propagation (2D)"]
["Project:",{"$f":"IF(ISBLANK(START!B4), \"\",START!B4)","v":""}]
[]
["Governing parameters"]
["Wave generation"]
["Slide impact velocity",null,null,"Vs ",null,null,"[m/s]"]
["Bulk slide volume",null,null,"Vs ",null,null,"[m3]"]
["Slide thickness",null,null,"s ",null,null,"[m]"]
["Slide/reservoir width",null,null,"b ",null,null,"[m]"]
["Bulk slide density",null,null,"ρs",null,null,"[kg/m3]"]
["Bulk slide porosity",null,null,"n",null,null,"[%]"]
["Slide impact angle ",null,null,"α",null,null,"[°]"]
["Still water depth",null,null,"h",null,null,"[m]"]
["Wave propagation "]
["Streamwise distance",null,null,"x",null,null,"[m]",null,"Limitations (Table 3-2)"]
[null,null,null,null,null,null,null,null,"Slide Froude number",null,null,"0.86 ≤ F ≤ 6.83",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F13)), \"\", F6/SQRT(9.81*F13))","v":""},"[-]"]
["Main results",null,null,null,null,null,null,null,"Relative slide thickness",null,null,"0.09 ≤ S ≤ 1.64",{"$f":"IF(OR(ISBLANK(F8),ISBLANK(F13)),\"\",F8/F13)","v":""},"[-]"]
["Maximum wave height",null,null,"HM ","Eq. (3.13)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", (5/9)*M26^(4/5)*F13)","v":""},"[m]",null,"Relative slide mass",null,null,"0.11 ≤ M ≤ 10.02",{"$f":"IF(OR(ISBLANK(F7),ISBLANK(F9),ISBLANK(F10),ISBLANK(F13)), \"\", (F10*F7)/(1000*F9*F13^2))","v":""},"[-]"]
["Maximum wave amplitude",null,null,"aM ","Eq. (3.16)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", (5/9)*M26^(4/5)*F13*(4/5))","v":""},"[m]",null,"Relative slide density",null,null,"0.59 ≤ D ≤ 1.72",{"$f":"IF(OR(ISBLANK(F10)), \"\", F10/1000)","v":""},"[-]"]
["Streamwise distance of aM",null,null,"xM ","Eq. (3.14)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", (11/2)*M26^(1/2)*F13)","v":""},"[m]",null,"Relative granulate density",null,null,"0.96 ≤ ρg/ρw ≤ 2.75",{"$f":"IF(OR(ISBLANK(F10),ISBLANK(F11)), \"\", (F10/(1-(F11/100)))/1000)","v":""},"[-]"]
["Wave period at xM",null,null,"TM ","Eq. (3.15)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", 9*M26^(1/2)*(F13/9.81)^(1/2))","v":""},"[s]",null,"Relative slide volume",null,null,"0.05 ≤ V ≤ 5.94",{"$f":"IF(OR(ISBLANK(F7),ISBLANK(F9),ISBLANK(F13)), \"\", F7/(F9*F13^2))","v":""},"[-]"]
["Wave celerity at xM",null,null,"c(xM)","Eq. (3.17)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", (9.81*(F13+F19))^(1/2))","v":""},"[m/s]",null,"Bulk slide porosity",null,null,"30.7 ≤ n ≤ 43.3",{"$f":"IF(OR(ISBLANK(F11)), \"\", F11)","v":""},"[%]"]
["Wave length at xM",null,null,"LM ","Eq. (3.18)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", F22*F21)","v":""},"[m]",null,"Slide impact angle",null,null,"30 ≤ α ≤ 90",{"$f":"IF(OR(ISBLANK(F12)),\"\",F12)","v":""},"[°]"]
["Wave height at x",null,null,"H(x)","Eq. (3.19)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15)), \"\", IF(F20>F15, \"x < x_M\", (3/4)*(M26*(M25)^(-1/3))^(4/5)*F13))","v":""},"[m]",null,"Relative slide width",null,null,"0.74 ≤ B ≤ 3.33",{"$f":"IF(OR(ISBLANK(F9),ISBLANK(F13)), \"\", F9/F13)","v":""},"[-]"]
["Wave amplitude at x",null,null,"a(x)","Eq. (3.16)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15)), \"\", IF(F20>F15,\"x < x_M\", (3/4)*(M26*(M25)^(-1/3))^(4/5)*F13*(4/5)))","v":""},"[m]",null,"Relative streamwise distance",null,null,"2.7 ≤ X ≤ 59.2",{"$f":"IF(OR(ISBLANK(F15),ISBLANK(F13)), \"\", F15/F13)","v":""},"[-]"]
["Wave period at x",null,null,"T(x)","Eq. (3.20)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15)), \"\", IF(F20>F15, \"x < x_M\",9*M26^(1/4)*M25^(5/16)*(F13/9.81)^(1/2)))","v":""},"[s]",null,"Impulse product parameter",null,null,"0.17 ≤ P ≤ 8.13",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\",M16*M17^0.5*M18^0.25*COS((6/7)*RADIANS(M23))^0.5)","v":""},"[-]"]
["Wave celerity at x",null,null,"c(x)","Eq. (3.17)",{"$f":" IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15)), \"\", IF(F20>F15, \"x < x_M\", (9.81*(F13+F25))^0.5))","v":""},"[m/s]"]
["Wave length at x",null,null,"L(x)","Eq. (3.21)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15)), \"\", IF(F20>F15,\"x < x_M\", F27*F26))","v":""},"[m]"]

{"sheet":"Generation | Propagation (3D)","index":2,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Generation | Propagation (3D)"]
["Project:",{"$f":"IF(ISBLANK(START!B4), \"\",START!B4)","v":""}]
[]
["Governing parameters"]
["Wave generation"]
["Slide impact velocity",null,null,"Vs ",null,null,"[m/s]"]
["Bulk slide volume",null,null,"Vs ",null,null,"[m3]"]
["Slide thickness",null,null,"s ",null,null,"[m]"]
["Slide width",null,null,"b ",null,null,"[m]"]
["Bulk slide density",null,null,"ρs",null,null,"[kg/m3]"]
["Bulk slide porosity",null,null,"n",null,null,"[%]"]
["Slide impact angle ",null,null,"α",null,null,"[°]"]
["Still water depth",null,null,"h",null,null,"[m]"]
["Wave propagation "]
["Radial distance",null,null,"r",null,null,"[m]"]
["Wave propagation angle",null,null,"γ",null,null,"[°]"]
[null,null,null,null,null,null,null,null,"Limitations (Table 3-3)"]
["Main results",null,null,null,null,null,null,null,"Slide Froude number",null,null,"0.40 ≤ F ≤ 3.40",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F13)), \"\", F6/SQRT(9.81*F13))","v":""},"[-]"]
["Impact radius for γ = 0°",null,null,"r0,0° ","Eq. (3.22)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", 2.5*(M29*M26*COS((6/7)*RADIANS(F12)))^0.25*F13)","v":""},"[m]",null,"Relative slide thickness",null,null,"0.15 ≤ S ≤ 0.60",{"$f":"IF(OR(ISBLANK(F8),ISBLANK(F13)),\"\",F8/F13)","v":""},"[-]"]
["Impact radius for γ = 90°",null,null,"r0,90° ","Eq. (3.23)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", (F9/2)+1.5*(M29*COS((6/7)*RADIANS(F12)))^0.25*F13)","v":""},"[m]",null,"Relative slide mass",null,null,"0.25 ≤ M ≤ 1.00",{"$f":"IF(OR(ISBLANK(F7),ISBLANK(F9),ISBLANK(F10),ISBLANK(F13)), \"\", (F10*F7)/(1000*F9*F13^2))","v":""},"[-]"]
["Impact radius",null,null,"r0(γ) ","Eq. (3.24)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F16)), \"\", SQRT((F19^2*F20^2)/((F19^2*SIN(RADIANS(F16))^2)+(F20^2*COS(RADIANS(F16))^2))))","v":""},"[m]",null,"Relative slide density",null,null,"0.59 ≤ D ≤ 1.72",{"$f":"IF(OR(ISBLANK(F10)), \"\", F10/1000)","v":""},"[-] (1)"]
["Surrogate radial distance",null,null,"r* ","Eq. (3.25)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15),ISBLANK(F16)), \"\", F15-F21)","v":""},"[m]",null,"Relative granulate density",null,null,"0.96 ≤ ρg/ρw ≤ 2.75",{"$f":"IF(OR(ISBLANK(F10),ISBLANK(F11)), \"\", (F10/(1-(F11/100)))/1000)","v":""},"[-] (1)"]
["Initial first wave crest amplitude",null,null,"a0,c1","Eq. (3.26)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", 0.2*M29^0.5*M26^0.75*COS((6/7)*RADIANS(F12))^0.25*F13)","v":""},"[m]",null,"Relative slide volume",null,null,"0.187 ≤ V ≤ 0.750",{"$f":"IF(OR(ISBLANK(F7),ISBLANK(F9),ISBLANK(F13)), \"\", F7/(F9*F13^2))","v":""},"[-]"]
["Initial first wave trough amplitude",null,null,"a0,t1","Eq. (3.27)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", 0.35*(M29*M26*COS((6/7)*RADIANS(F12)))^0.5*F13)","v":""},"[m]",null,"Bulk slide porosity",null,null,"30.7 ≤ n ≤ 43.3",{"$f":"IF(OR(ISBLANK(F11)), \"\", F11)","v":""},"[%] (1)"]
["Initial second wave crest amplitude",null,null,"a0,c2","Eq. (3.28)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\", 0.14*(M29*M26*COS((6/7)*RADIANS(F12)))^0.25*F13)","v":""},"[m]",null,"Slide impact angle",null,null,"30° ≤ α ≤ 90°",{"$f":"IF(OR(ISBLANK(F12)),\"\",F12)","v":""},"[°]"]
["First wave crest amplitude",null,null,"ac1","Eq. (3.29)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15),ISBLANK(F16)), \"\",IF(F21>F15, \"r < r_0\", F23*EXP(-0.4*(F23/F13)^(-0.3)*SQRT(F22/F13))*_xlfn.SECH(3.2*(F16/90))^(COS((6/7)*RADIANS(F12))*EXP(-0.15*SQRT(F22/F13)))))","v":""},"[m]",null,"Relative slide width",null,null,"0.83 ≤ B ≤ 5.00",{"$f":"IF(OR(ISBLANK(F9),ISBLANK(F13)), \"\", F9/F13)","v":""},"[-]"]
["First wave trough amplitude",null,null,"at1","Eq. (3.30)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15),ISBLANK(F16)), \"\",IF(F21>F15, \"r < r_0\", F24*EXP(-0.4*(F24/F13)^(-0.3)*SQRT(F22/F13))*_xlfn.SECH(3.6*(F16/90))^(COS((6/7)*RADIANS(F12))*EXP(-0.15*SQRT(F22/F13)))))","v":""},"[m]",null,"Relative radial distance",null,null,"1 ≤ r/h ≤ 16",{"$f":"IF(OR(ISBLANK(F15),ISBLANK(F13)), \"\", F15/F13)","v":""},"[-]"]
["Second wave crest amplitude",null,null,"ac2","Eq. (3.31)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15),ISBLANK(F16)), \"\",IF(F21>F15, \"r < r_0\", F25*EXP(-0.1*(F25/F13)^(-0.3)*SQRT(F22/F13))*_xlfn.SECH(3*(F16/90))^(COS((6/7)*RADIANS(F12))*EXP(-0.15*SQRT(F22/F13)))))","v":""},"[m]",null,"Wave propagation angle",null,null,"−90° ≤ γ ≤ 90°",{"$f":"IF(OR(ISBLANK(F16)), \"\", F16)","v":""},"[°]"]
["First wave crest celerity",null,null,"cc1","Eq. (3.32)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15),ISBLANK(F16)), \"\",IF(F21>F15, \"r < r_0\", 0.95*SQRT(9.81*(F13+F26))))","v":""},"[m/s]",null,"Impulse product parameter",null,null,"0.13 ≤ P ≤ 2.08",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13)), \"\",M18*M19^0.5*M20^0.25*COS((6/7)*RADIANS(M25))^0.5)","v":""},"[-]"]
["Second wave crest celerity",null,null,"cc2","Eq. (3.33)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15),ISBLANK(F16)), \"\",IF(F21>F15, \"r < r_0\", 0.7*SQRT(9.81*(F13+F28))))","v":""},"[m/s]",null,"(1) extended density range 0.59 ≤ D ≤ 1.72"]
["Wave period (first wave)",null,null,"T1","Eq. (3.34)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15),ISBLANK(F16)), \"\", IF(F21>F15, \"r < r_0\",(10*((F26+F27)/F13)^0.2+(F22/(2*F13)))*SQRT(F13/9.81)))","v":""},"[s]"]
["Wave length (first wave)",null,null,"L1","Eq. (3.35)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F9),ISBLANK(F10),ISBLANK(F12),ISBLANK(F13),ISBLANK(F15),ISBLANK(F16)), \"\", IF(F21>F15, \"r < r_0\",F31*F29))","v":""},"[m]"]

{"sheet":"Run-up | Overtopping","index":3,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Run-up | Overtopping"]
["Project:",{"$f":"IF(ISBLANK(START!B4), \"\",START!B4)","v":""}]
[]
["Governing parameters"]
["Wave parameters"]
["Wave parameters input source",null,null,"(2D or 3D)"]
["Wave crest amplitude",null,null,"a ",null,{"$f":"IF(ISBLANK(F6),\"\",IF(F6=\"2D\", IF(ISBLANK('Generation | Propagation (2D)'!F6), \"no value\", 'Generation | Propagation (2D)'!F25), IF(ISBLANK('Generation | Propagation (3D)'!F6),\"no value\",IF('Generation | Propagation (3D)'!F21>'Generation | Propagation (3D)'!F15,'Generation | Propagation (3D)'!F26,MAX('Generation | Propagation (3D)'!$F$26,'Generation | Propagation (3D)'!$F$28)))))","v":""},"[m] (1)"]
["Wave height",null,null,"H ",null,{"$f":"IF(ISBLANK(F6),\"\",IF(F6=\"2D\", IF(ISBLANK('Generation | Propagation (2D)'!F6), \"no value\",'Generation | Propagation (2D)'!F24), IF(ISBLANK('Generation | Propagation (3D)'!F6),\"no value\",IF('Generation | Propagation (3D)'!F21>'Generation | Propagation (3D)'!F15,'Generation | Propagation (3D)'!F26,MAX('Generation | Propagation (3D)'!$F$26,'Generation | Propagation (3D)'!$F$28)+'Generation | Propagation (3D)'!$F$27))))","v":""},"[m] (2)"]
["Still water depth",null,null,"h ",null,null,"[m]"]
["Shore/dam parameters"]
["Run-up angle",null,null,"β",null,null,"[°]"]
["Freeboard",null,null,"f",null,null,"[m]"]
["Dam crest width",null,null,"bK",null,null,"[m]"]
[null,null,null,null,null,null,null,null,"Limitations (Tables 3-4, 3-5 and A-1)"]
["Main results",null,null,null,null,null,null,null,"Wave run-up"]
["Wave run-up",null,null,null,null,null,null,null,"Relative wave crest amplitude",null,null,"0.007 ≤ ε ≤ 0.69",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\",F7/F9)","v":""},"[-]"]
["Run-up height",null,null,"R ","Eq. (3.36)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F9),ISBLANK(F11),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", 2*F7*EXP(0.4*(F7/F9))*(90/F11)^0.2)","v":""},"[m]",null,"Non-linearity",null,null,"0.57 ≤ a/H ≤ 1.04",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\",F7/F8)","v":""},"[-]"]
["Wave overtopping (rigid dam)",null,null,null,null,null,null,null,"Run-up angle",null,null,"10° ≤ β ≤ 90°",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9)),\"\",F11)","v":""},"[°]"]
["Overtopping volume per unit dam crest length",null,null,"V","Eq. (3.38)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F9),ISBLANK(F11),ISBLANK(F12),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F7<F12, \"a < f\", 1.35*(F7/F8)^1.5*((F7/F9)*(F9/(F9+F12))^((2/(F7/F9))*(F11/90)^0.25)*((F7-F12)/F13)^0.12)^0.7*F9^2))","v":""},"[m3/m]",null,"Slope parameter",null,null,"So ≥ 0.37",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),ISBLANK(F11),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\", IF(F11=90, \"∞\", 1.521*(TAN(RADIANS(F11))/SQRT(M16))))","v":""},"[-] "]
["Maximum overtopping flow depth",null,null,"d0","Eq. (3.39)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F9),ISBLANK(F11),ISBLANK(F12),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F7<F12, \"a < f\", 1.32*((F7/F9)*(F9/(F9+F12))^(4*(F11/90)^(-0.21)-(F7/F9))*(F11/90)^0.16)*(F9+F12)))","v":""},"[m]",null,"Wave overtopping (rigid dam)"]
["Wave overtopping duration",null,null,"tO","Eq. (3.40)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F9),ISBLANK(F11),ISBLANK(F12),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F7<F12, \"a < f\", (1/0.15)*((F7/F9)^0.2*(F9/(F9+F12))^((-0.9/(F7/F9))*(F11/90)^0.4))^(-1.9)*SQRT((F9+F12)/9.81)))","v":""},"[s]",null,"Relative wave crest amplitude",null,null,"0.013 ≤ ε ≤ 0.700",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\",F7/F9)","v":""},"[-]"]
["Average unit discharge",null,null,"qm","Eq. (3.41)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F9),ISBLANK(F11),ISBLANK(F12),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F7<F12, \"a < f\", F19/F21))","v":""},"[m2/s]",null,"Relative effective wave amplitude",null,null,"0.02 ≤ aw/bK ≤ 130",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),ISBLANK(F12),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\",(F7-F12)/F13)","v":""},"[-]"]
["Wave overtopping (granular dam) (see Appendix A)",null,null,null,null,null,null,null,"Relative still water depth",null,null,"0.67 ≤ h/w ≤ 1.00",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),ISBLANK(F12)),\"\",F9/(F9+F12))","v":""},"[-]"]
["Overtopping volume per unit dam crest length",null,null,"V","Eq. (A.1)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F9),ISBLANK(F11),ISBLANK(F12),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", 1.53*(F7/F9)*(F9/(F9+F12))^2.5*((0.1/(TAN(RADIANS(F11))))+(F13/(F9+F12)))^(-1/9)*F9^2)","v":""},"[m3/m]",null,"Dam angle",null,null,"18.4° ≤ β ≤ 90°",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9)),\"\",F11)","v":""},"[°]"]
["Maximum overtopping flow depth",null,null,"d0","Eq. (A.2)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F9),ISBLANK(F11),ISBLANK(F12),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", 1.25*(F7/F9)*(F9/(F9+F12))^1.7*(F11/90)^0.25*(F9+F12))","v":""},"[m]",null,"Non-linearity",null,null,"0.63 ≤ a/H ≤ 1.00",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\",F7/F8)","v":""},"[-]"]
["Wave overtopping duration",null,null,"tO","Eq. (A.3)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F9),ISBLANK(F11),ISBLANK(F12),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\",(1/0.11)*(F9/(F9+F12))^(5/3)*((0.1/TAN(RADIANS(F11)))+(F13/(F9+F12)))^(0.2)*SQRT((F9+F12)/9.81))","v":""},"[s]",null,"Relative crest width",null,null,"0.07 ≤ bK/w ≤ 0.53",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),ISBLANK(F12),ISBLANK(F13)),\"\",F13/(F9+F12))","v":""},"[-]"]
["Average unit discharge",null,null,"qm","Eq. (A.4)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F9),ISBLANK(F11),ISBLANK(F12),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\",F24/F26)","v":""},"[m2/s]",null,"Wave overtopping (granular dam)"]
["Eroded crest depth",null,null,"he","Eq. (A.5)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F9),ISBLANK(F11),ISBLANK(F12),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\",0.36*TANH(2.8*(F7/F9))*(F9/(F9+F12))^3*EXP(-4.9*((0.1/TAN(RADIANS(F11)))+(F13/(F9+F12))))*(F9+F12))","v":""},"[m]",null,"Relative wave crest amplitude",null,null,"0.25 ≤ ε ≤ 0.75",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\",F7/F9)","v":""},"[-]"]
["(1) 3D: a = ac1 if ac1 > ac2 or a = ac2 if ac1 < ac2",null,null,null,null,null,null,null,"Wave-freeboard ratio",null,null,"0.8 ≤ a/f ≤ 11.4",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),ISBLANK(F12),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\",F7/F12)","v":""},"[-]"]
["(2) 3D: H = ac1 + at1 if ac1 > ac2 or H = ac2 + at1 if ac1 < ac2",null,null,null,null,null,null,null,"Relative still water depth",null,null,"0.70 ≤ h/w ≤ 0.95",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),ISBLANK(F12)),\"\",F9/(F9+F12))","v":""},"[-]"]
[null,null,null,null,null,null,null,null,"Dam angle",null,null,"18.4° ≤ β ≤ 33.3°",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9)),\"\",F11)","v":""},"[°]"]
[null,null,null,null,null,null,null,null,"Non-linearity",null,null,"a/H = 1.00",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\",F7/F8)","v":""},"[-]"]
[null,null,null,null,null,null,null,null,"Relative crest width",null,null,"0 ≤ bK/w ≤ 0.5",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F9),ISBLANK(F12),ISBLANK(F13)),\"\",F13/(F9+F12))","v":""},"[-]"]

{"sheet":"Overland flow","index":4,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Overland flow"]
["Project:",{"$f":"IF(ISBLANK(START!B4), \"\",START!B4)","v":""}]
[]
["Governing parameters"]
["Wave parameters"]
["Wave parameter input source",null,null,"(2D or 3D)"]
["Wave crest amplitude",null,null,"a ",null,{"$f":"IF(ISBLANK(F6),\"\",IF(F6=\"2D\", IF(ISBLANK('Generation | Propagation (2D)'!F6), \"no value\", 'Generation | Propagation (2D)'!F25), IF(ISBLANK('Generation | Propagation (3D)'!F6),\"no value\",IF('Generation | Propagation (3D)'!F21>'Generation | Propagation (3D)'!F15,'Generation | Propagation (3D)'!F26,MAX('Generation | Propagation (3D)'!$F$26,'Generation | Propagation (3D)'!$F$28)))))","v":""},"[m] (1)"]
["Still water depth",null,null,"h ",null,null,"[m]"]
["Shore parameters"]
["Run-up angle",null,null,"β",null,null,"[°]"]
["Freeboard",null,null,"f",null,null,"[m]"]
["Streamwise overland flow distance",null,null,"xov",null,null,"[m]"]
["Overland flow propagation time",null,null,"t",null,null,"[s]"]
[]
["Main results",null,null,null,null,null,null,null,"Limitations (Table 3-6)"]
["Minimum relative wave amplitude",null,null,"εmin ","Eq. (3.42)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),ISBLANK(F11),F7=\"no value\"), \"\", (F11*TAN(RADIANS(F10))^0.05)/(3*F8))","v":""},"[-]",null,"Relative wave crest amplitude",null,null,"0.1 ≤ ε ≤ 0.7",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F8),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\",F7/F8)","v":""},"[-]"]
["Effective relative wave amplitude",null,null,"εeff ","Eq. (3.43)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),ISBLANK(F11),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F16>M16,\"ε < ε_min\",(F7/F8)-F16))","v":""},"[-]",null,"Run-up angle",null,null,"11° ≤ β ≤ 34°",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F8)),\"\",F10)","v":""},"[°]"]
["Flow front position at time t",null,null,"xf","Eq. (3.44)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),ISBLANK(F11),ISBLANK(F13),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F16>M16,\"ε < ε_min\",(1.7*(F11/F8)+0.5)*(((F13*(SQRT(9.81*(F7+F8))*(F7/F8)^((F11/F8)+1.45))/F7))/(TAN(RADIANS(F10))^0.25))^(1.35-1.15*(F11/F8))*(F8+F11)))","v":""},"[m]",null,"Relative freeboard",null,null,"0.04 ≤ f/h ≤ 0.56",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F8),ISBLANK(F11)),\"\",F11/F8)","v":""},"[-]"]
["Maximum flow depth at xtr",null,null,"d0","Eq. (3.45)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),ISBLANK(F11),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F16>M16,\"ε < ε_min\",((0.4*TAN(RADIANS(F10))+0.9)*F17)/(((F8+F11)/F8)^(0.45*_xlfn.COT(RADIANS(F10))))*F8))","v":""},"[m]",null,"Overland flow distance",null,null,"0 ≤ xov/w ≤ 10",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F8),ISBLANK(F12),F7=\"no value\"),\"\",F12/(F8+F11))","v":""},"[-]"]
["Relative overland flow position",null,null,"x*max","Eq. (3.46)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),ISBLANK(F11),ISBLANK(F12),F7=\"no value\"), \"\", IF(F16>M16,\"ε < ε_min\",(F12/(F8+F11))*((F8+F11)/F8)^(5.3*TAN(RADIANS(F10))-1.4)))","v":""},"[-]"]
["Maximum flow depth at xov",null,null,"dmax","Eq. (3.47)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),ISBLANK(F11),ISBLANK(F12),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F16>M16,\"ε < ε_min\",F19*(1-TANH(0.54*F20^0.39))))","v":""},"[m]"]
["Maximum depth averaged flow velocity at xtr",null,null,"ṽx,max","Eq. (3.48)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),ISBLANK(F11),ISBLANK(F12),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F16>M16,\"ε < ε_min\",5*(SQRT(9.81*(F8+F7)))*TANH(0.017*F17*((F8+F11)/F8)^(3*TAN(RADIANS(F10))+2.5)*SQRT(_xlfn.COT(RADIANS(F10))))^0.5))","v":""},"[m/s]"]
["Maximum flow front velocity at xov/w = 5",null,null,"vf,max","Eq. (3.49)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),ISBLANK(F11),ISBLANK(F12),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F16>M16,\"ε < ε_min\",1.6*(SQRT(9.81*(F8+F7)))*TANH(2.2*(F17*(F8/(F8+F11)))^0.75)))","v":""},"[m/s]"]
["Maximum specific discharge at xtr",null,null,"q0","Eq. (3.51)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),ISBLANK(F11),ISBLANK(F12),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF(F16>M16,\"ε < ε_min\",0.83*(SQRT(9.81*(F8+F7)))*F7*TANH(F17/(((F8+F11)/F8)^(1.5*_xlfn.COT(RADIANS(F10)))*_xlfn.COT(RADIANS(F10))^0.5))^0.5))","v":""},"[m2/s]"]
["(1) 3D: a = ac1 if ac1 > ac2 or a = ac2 if ac1 < ac2"]

{"sheet":"Wave force","index":5,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Wave force"]
["Project:",{"$f":"IF(ISBLANK(START!B4), \"\",START!B4)","v":""}]
[]
["Governing parameters"]
["Wave parameters"]
["Wave parameter input source",null,null,"(2D or 3D)"]
["Wave crest amplitude",null,null,"a ",null,{"$f":"IF(ISBLANK(F6),\"\",IF(F6=\"2D\", IF(ISBLANK('Generation | Propagation (2D)'!F6), \"no value\", 'Generation | Propagation (2D)'!F25), IF(ISBLANK('Generation | Propagation (3D)'!F6),\"no value\",IF('Generation | Propagation (3D)'!F21>'Generation | Propagation (3D)'!F15,'Generation | Propagation (3D)'!F26,MAX('Generation | Propagation (3D)'!$F$26,'Generation | Propagation (3D)'!$F$28)))))","v":""},"[m] (1)"]
["Still water depth",null,null,"h ",null,null,"[m]"]
["Dam parameters"]
["Run-up angle",null,null,"β",null,null,"[°]"]
["Freeboard",null,null,"f",null,null,"[m]"]
[]
["Main results"]
["Hydrostatic pressure force (horizontal component)",null,null,"FRW,h","Eq. (3.52)",{"$f":"IF(OR(ISBLANK(F8)), \"\", 0.5*1000*9.81*F8^2)","v":""},"[N/m]"]
["Hydrostatic pressure force (vertical component)",null,null,"FRW,v","Eq. (3.53)",{"$f":"IF(OR(ISBLANK(F8),ISBLANK(F10)), \"\", (0.5*1000*9.81*F8^2)/TAN(RADIANS(F10)))","v":""},"[N/m]"]
["Hydrostatic pressure force by 2a+h (horizontal)",null,null,"Fhs,h","Eq. (3.55)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", 0.5*1000*9.81*(2*F7+F8)^2)","v":""},"[N/m]"]
["Total horizontal force due to wave (horizontal)",null,null,"Ftot,h","Eq. (3.54)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", (1-1.5*(F7/F8))^(1/6)*F16)","v":""},"[N/m]",null,"Limitation "]
["Total horizontal force due to wave (vertical)",null,null,"Ftot,v","-",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", F17/TAN(RADIANS(F10)))","v":""},"[N/m]",null,"Relative wave crest amplitude",null,null,"0 ≤ ε ≤ 0.6",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F8),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"),\"\",F7/F8)","v":""},"[-]"]
["Pressure at dam crest",null,null,"pK","Eq. (3.56)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F11),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF((2*F7)<F11, \"2a < f\", (2*F17)/(2*F7+F8)^2*(2*F7-F11)))","v":""},"[N/m2]"]
["Reduced overtopping force (horizontal)",null,null,"Ftot,h,red","Eq. (3.57)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F11),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF((2*F7)<F11, \"2a < f\", 0.5*(F8+F11)*(F19+((2*F17)/(2*F7+F8)))))","v":""},"[N/m]"]
["Reduced overtopping force (vertical)",null,null,"Ftot,v,red","-",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F10),ISBLANK(F11),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF((2*F7)<F11, \"2a < f\", F20/TAN(RADIANS(F10))))","v":""},"[N/m]"]
["Elevation of the resultant of Ktot,h,red",null,null,"zK,tot,h,red","Eq. (3.58)",{"$f":"IF(OR(ISBLANK(F6),ISBLANK(F7),ISBLANK(F8),ISBLANK(F11),F7=\"no value\",F7=\"x < x_M\",F7=\"r < r_0\"), \"\", IF((2*F7)<F11, \"2a < f\", ((((2*F17)/(2*F7+F8))-F19)*((F8+F11)^2/6)+(0.5*F19*(F8+F11)^2))/((((2*F17)/(2*F7+F8))-F19)*((F8+F11)*0.5)+(F19*(F8+F11)))  ))","v":""},"[m]"]
["(1) 3D: a = ac1 if ac1 > ac2 or a = ac2 if ac1 < ac2"]