{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Input","Input explanation","stability - mathcad","Results","Im","Lookup"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"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":"Input","index":0,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[17,0,17,1],[22,0,22,1],[21,0,21,1],[20,0,20,1],[19,0,19,1],[18,0,18,1],[27,0,27,1],[26,0,26,1],[25,0,25,1],[24,0,24,1],[23,0,23,1],[32,0,32,1],[31,0,31,1],[30,0,30,1],[29,0,29,1],[28,0,28,1],[7,0,7,1],[6,0,6,1],[5,0,5,1],[4,0,4,1],[3,0,3,3],[9,0,9,1],[8,0,8,1],[16,0,16,1],[15,0,15,1],[14,0,14,1],[13,0,13,1],[12,0,12,1],[11,0,11,1],[10,0,10,1]]}
["Output file directory","C:\\Documents"]
["Output file name","test.rtf"]
[null,"Save Mathcad calculations",null,null,"no","no","no","no"]
["CALCULATION INPUT"]
["Wave&current input"]
["Location",null,null,null,"A","A","A","A"]
["RP waves",null,null,null,"-","-","-","-"]
["RP current",null,null,null,"-","-","-","-"]
["significant wave height",null,"H_s","[m]",1,1,1,2]
["Ratio Hs/Hmax",null,"h_s_ratio","[-]",0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004]
["Peak wave period",null,"T_p","[s]",8,8,8,11]
["Water depth re. to LAT",null,"h_LAT","[m]",21,21,21,20]
["Tide & storm surge",null,"h_tide","[m]",4,4,4,5]
["Current velocity given",null,"u_c","[m/s]",1,1,1,1]
["Current measurement height above seabed",null,"h_m","[m]",1,1,1,1]
["Other input"]
["Header"]
["Specific density rock material",null,"rho_s","[kg/m^3]",2650,2650,2650,2650]
["shape parameter rock material",null,"shape","[-]",0.84,0.84,0.84,0.84]
["Specific density water",null,"rho_w","[kg/m^3]",1025,1025,1025,1025]
["Angle of repose",null,"phi","[deg]",40,40,40,40]
["Berm slope steepness 1:n",null,"n","[-]",5,5,5,5]
["Angle of current to wave direction",null,"phi_w","[deg]",30,30,30,45]
["Angle of wave direction to berm",null,"phi_sl","[deg]",45,45,45,30]
["multiplication factors currents",null,"k_c","[-]",1.02,1.02,1.02,1]
["multiplication factors waves",null,"k_w","[-]",1.02,1.02,1.02,1]
["Shoaling",null,"sh_coef","[-]",0,0,0,0]
["Bottom roughness calculation method",null,"kr_m","[-]",1,1,1,0]
["K-value (only if applicable)",null,"K","[-]",1.5,1.5,1.5,1.5]
["D90 (only if applicable)",null,"D_90","[m]",0.5,0.5,0.5,0.5]
["Average/peak stress",null,"str_method","[-]",0,0,0,0]
["Critical Shields parameter (advised 0.03 for \"average, 0.056 for peak)",null,"psi_cr","[-]",{"$f":"IF(E31=1,0.03,IF(E31=0,0.056,\"\"))","v":5.6000000000000001E-2},{"$f":"IF(F31=1,0.03,IF(F31=0,0.056,\"\"))","v":5.6000000000000001E-2},{"$f":"IF(G31=1,0.03,IF(G31=0,0.056,\"\"))","v":5.6000000000000001E-2},{"$f":"IF(H31=1,0.03,IF(H31=0,0.056,\"\"))","v":5.6000000000000001E-2}]
["Slope influence",null,"sl_infl","[-]",0,1,2,1]

{"sheet":"Input explanation","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Input","Notation","Unit","Explanation","Recommended value (if no data available)"]
["significant wave height","H_s","[m]"]
["Peak wave period","Tp","[s]"]
["Water depth re. to LAT","h_LAT","[m]"]
["Tide & storm surge","h_tide","[m]"]
["Current velocity given","uc","[m/s]"]
["Current measurement height above seabed","hm","[m]"]
["Critical Shields parameter","ψ_cr","[-]"]
["Specific density rock material","ρs","[kg/m^3]"]
["shape parameter rock material","shape","[-]"]
["Specific density water","ρw","[kg/m^3]"]
["Angle of repose","φ","[deg]"]
["Berm slope steepness 1:n","n","[-]"]
["Angle of current to wave direction","φw","[deg]"]
["Angle of wave direction to berm","φsl","[deg]"]
["multiplication factors currents","kc","[-]"]
["multiplication factors waves","kw","[-]"]

{"sheet":"stability - mathcad","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Results","index":3,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,0,27,1],[28,0,28,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[12,0,12,1],[11,0,11,1],[10,0,10,1],[9,0,9,1],[21,0,21,1],[20,0,20,1],[19,0,19,1],[18,0,18,1],[17,0,17,1],[16,0,16,1],[15,0,15,1],[14,0,14,1],[13,0,13,1],[7,0,7,1],[8,0,8,1],[2,0,2,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1]]}
["Output file directory","C:\\Documents"]
["Output file name",{"$f":"#REF!&\"_\"&#REF!&\"_\"&#REF!&\"_RockStab_calcs_Rev_\"&#REF!","v":{"$error":"#REF!"}}]
["CALCULATION RESULTS"]
["Wave&current input"]
["Location",null,null,null,"A","A","A","A"]
["RP waves",null,null,null,"-","-","-","-"]
["RP current",null,null,null,"-","-","-","-"]
["Other input"]
["Header"]
["Minimum D50",null,{"$f":"VLOOKUP(A10,Lookup!$A$2:$B$158,2,0)","v":"D.50"},null,2.5622373793981645E-2,2.9892359053641595E-2,2.5622373793981645E-2,1.7684431697992314E-2]
["Wave theory",null,{"$f":"VLOOKUP(A11,Lookup!$A$2:$B$158,2,0)","v":"wave.theory"},null,"\"transitional","\"transitional","\"transitional","\"transitional"]
["Wave number",null,{"$f":"VLOOKUP(A12,Lookup!$A$2:$B$158,2,0)","v":"k"},null,6.7385067430077869E-2,6.7385067430077869E-2,6.7385067430077869E-2,4.2364677810543309E-2]
["Shoaling coefficient",null,{"$f":"VLOOKUP(A13,Lookup!$A$2:$B$158,2,0)","v":"K.sh"},null,0.93242670509542336,0.93242670509542336,0.93242670509542336,0.91621870594598032]
["Local wave amplitude",null,{"$f":"VLOOKUP(A14,Lookup!$A$2:$B$158,2,0)","v":"a"},null,0.5,0.5,0.5,1]
["Bed orbital velocity",null,{"$f":"VLOOKUP(A15,Lookup!$A$2:$B$158,2,0)","v":"u.b"},null,0.15089520607708071,0.15089520607708071,0.15089520607708071,0.45028367305045353]
["Bed orbital amplitude",null,{"$f":"VLOOKUP(A16,Lookup!$A$2:$B$158,2,0)","v":"a.b"},null,0.1921257434883008,0.1921257434883008,0.1921257434883008,0.78831359595509987]
["Depth averaged current",null,{"$f":"VLOOKUP(A17,Lookup!$A$2:$B$158,2,0)","v":"u.c.avg"},null,1.3858421576707567,1.3858421576707567,1.3858421576707567,1.3858421576707567]
["Current shear stress",null,{"$f":"VLOOKUP(A18,Lookup!$A$2:$B$158,2,0)","v":"τ.c"},null,8.7278334011069223,9.7481852526706838,8.7278334011069223,4.2970616443067273]
["Wave friction factor",null,{"$f":"VLOOKUP(A19,Lookup!$A$2:$B$158,2,0)","v":"f.w"},null,0.3,0.3,0.3,3.799867147868053E-2]
["Wave shear stress",null,{"$f":"VLOOKUP(A20,Lookup!$A$2:$B$158,2,0)","v":"τ.w"},null,3.957830234992465,4.9257588647698975,3.957830234992465,4.957402103894279]
["Combined shear stress",null,{"$f":"VLOOKUP(A21,Lookup!$A$2:$B$158,2,0)","v":"τ.cw"},null,22.86553832897426,26.676095165118888,22.86553832897426,15.781677922111587]
["Relative density",null,{"$f":"VLOOKUP(A22,Lookup!$A$2:$B$158,2,0)","v":"Δ"},null,1.5853658536585367,1.5853658536585367,1.5853658536585367,1.5853658536585367]
["Turbulence multiplication factor",null,{"$f":"VLOOKUP(A23,Lookup!$A$2:$B$158,2,0)","v":"k.t"},null,1.0424264068711928,1.0424264068711928,1.0424264068711928,1.03]
["Current slope red. parallel to berm",null,{"$f":"VLOOKUP(A24,Lookup!$A$2:$B$158,2,0)","v":"k.pp.c"},null,1,1.0466048456715566,1,1.0466048456715566]
["Current slope red. perpendicular to berm",null,{"$f":"VLOOKUP(A25,Lookup!$A$2:$B$158,2,0)","v":"k.ll.c"},null,1,1.0671724006758982,1,1.0671724006758982]
["Wave slope red. parallel to berm",null,{"$f":"VLOOKUP(A26,Lookup!$A$2:$B$158,2,0)","v":"k.pp.w"},null,1,1.0246075914666777,1,1.0372269275964132]
["Wave slope red. perpendicular to berm",null,{"$f":"VLOOKUP(A27,Lookup!$A$2:$B$158,2,0)","v":"k.ll.c"},null,1,1.0671724006758982,1,1.0671724006758982]
["Bottom roughness",null,{"$f":"VLOOKUP(A28,Lookup!$A$2:$B$158,2,0)","v":"k.r"},null,0.5,0.5,0.5,2.6526647546988472E-2]
["Chezy coefficient",null,{"$f":"VLOOKUP(A29,Lookup!$A$2:$B$158,2,0)","v":"Chezy"},null,50.006722506905582,50.006722506905582,50.006722506905582,72.961899977814554]

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

{"sheet":"Lookup","index":5,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Lookup table (add lines below):"]
["Minimum D50","D.50"]
["Chezy coefficient","Chezy"]
["Current shear stress","τ.c"]
["Wave friction factor","f.w"]
["Wave shear stress","τ.w"]
["Combined shear stress","τ.cw"]
["Relative density","Δ"]
["Wave theory","wave.theory"]
["Wave number","k"]
["Shoaling coefficient","K.sh"]
["Local wave amplitude","a"]
["Bed orbital velocity","u.b"]
["Bed orbital amplitude","a.b"]
["Turbulence multiplication factor","k.t"]
["Current slope red. parallel to berm","k.pp.c"]
["Current slope red. perpendicular to berm","k.ll.c"]
["Wave slope red. parallel to berm","k.pp.w"]
["Wave slope red. perpendicular to berm","k.ll.c"]
["Depth averaged current","u.c.avg"]
["Bottom roughness","k.r"]
["Minimum W50","W.50"]