土石坝波浪和护坡自动计算表格(EXCEL)

,莆田试验站公式,,,,,,鹤地水库公式,,,,,,官厅水库公式,,,,

,计算内容,计算项目,参数,单位,数值,,计算内容,计算项目,参数,单位,数值,,计算内容,计算项目,参数,单位,数值

,波浪计算,波高计算,计算风速W,m/s,24.00,,波浪计算,波高计算,计算风速W,m/s,24.00,,波浪计算,波高计算,计算风速W,m/s,24.00

,,,风区长度D,m,253.2,,,,风区长度D,m,253.2,,,,风区长度D,m,253

,,,水域平均水深Hm,m,20.00,,,,水域平均水深Hm,m,20.00,,,,水域平均水深Hm,m,20.00

,,,重力加速度g,m/s2,9.81,,,,重力加速度g,m/s2,9.81,,,,重力加速度g,m/s2,9.81

,,,坝迎水面前水深H,m,35.50,,,,坝迎水面前水深H,m,35.50,,,,坝迎水面前水深H,m,35.50

,,,0.7(gHm/W2)0.7,中间变量,0.329,,,,,,,,,,累积频率2％的波高h1％,m,0.557

,,,0.0018(gD/W2)0.45/(0.13th[0.7(gHm/W2)0.7]),中间变量,0.084,,,,累积频率2％的波高h2％,m,1.014,,,,累积频率5％的波高h2％,m,0.557

,,,平均波高hm,m,0.204,,,,平均波高hm,m,0.455,,,,平均波高hm,m,0.286

,,,平均波周期Tm,s,2.002,,,,,,,,,,gD/W2,中间变量,4.309

,,,2πH/Lm,中间变量,11.264,19.802,,,,,,,,,,,

,,,平均波长Lm,m,6.259,,,,平均波长Lm,m,4.706,,,,平均波长Lm,m,6.543

,,,累积频率1％的波高h1％,m,0.493,,,,累积频率1％的波高h1％,m,1.101,,,,累积频率1％的波高h1％,m,0.691

,,,累积频率2％的波高h2％,m,0.454,,,,累积频率2％的波高h2％,m,1.014,,,,累积频率2％的波高h2％,m,0.637

,,,累积频率5％的波高h5％,m,0.397,,,,累积频率5％的波高h5％,m,0.887,,,,累积频率5％的波高h5％,m,0.557

,,,累积频率10％的波高h10％,m,0.348,,,,累积频率10％的波高h10％,m,0.778,,,,累积频率10％的波高h10％,m,0.489

,,,有效波高hs,m,0.326,,,,有效波高hs,m,0.728,,,,有效波高hs,m,0.457

,,风壅水面高度,计算风向与坝轴线法线的夹角,度,25,,,风壅水面高度,计算风向与坝轴线法线的夹角,度,25,,,风壅水面高度,计算风向与坝轴线法线的夹角,度,25

,,,综合摩阻系数K,/,0.0000036,,,,综合摩阻系数K,/,0.0000036,,,,综合摩阻系数K,/,0.0000036

,,,风壅水面高度e,m,0.001,,,,风壅水面高度e,m,0.001,,,,风壅水面高度e,m,0.001

,,平均波浪爬高,坡度系数或折算坡度系数m,/,1.6,,,平均波浪爬高,坡度系数或折算坡度系数m,/,1.6,,,平均波浪爬高,坡度系数或折算坡度系数m,/,1.6

,,,斜坡的糙率渗透性系数KΔ,/,0.775,,,,斜坡的糙率渗透性系数KΔ,/,0.775,,,,斜坡的糙率渗透性系数KΔ,/,0.775

,,,经验系数Kw,/,1.000,,,,经验系数Kw,/,1.000,,,,经验系数Kw,/,1.000

,,,系数R0,/,,,,,系数R0,/,,,,,系数R0,/,

,,,平均波浪爬高Rm（m＝1.5～5.0）,m,0.464,,,,平均波浪爬高Rm（m＝1.5～5.0）,m,0.601,,,,平均波浪爬高Rm（m＝1.5～5.0）,m,0.562

,,,平均波浪爬高Rm（m≤1.25）,m,,,,,平均波浪爬高Rm（m≤1.25）,m,,,,,平均波浪爬高Rm（m≤1.25）,m,

,,,平均波浪爬高Rm（1.25＜m＜1.5）,m,,,,,平均波浪爬高Rm（1.25＜m＜1.5）,m,,,,,平均波浪爬高Rm（1.25＜m＜1.5）,m,

,,,平均波浪爬高Rm（考虑马道后）,m,0.464,,,,平均波浪爬高Rm（考虑马道后）,m,0.601,,,,平均波浪爬高Rm（考虑马道后）,m,0.562

,,,平均波浪爬高Rm（考虑斜向来波后）,m,0.436,,,,平均波浪爬高Rm（考虑斜向来波后）,m,0.565,,,,平均波浪爬高Rm（考虑斜向来波后）,m,0.528

,,累积频率爬高,累积频率1％的爬高R1％,m,0.972,,,累积频率爬高,累积频率1％的爬高R1％,m,1.260,,,累积频率爬高,累积频率1％的爬高R1％,m,1.177

,,,累积频率5％的爬高R5％,m,0.802,,,,累积频率5％的爬高R5％,m,1.040,,,,累积频率5％的爬高R5％,m,0.971

,,波浪压力,频率换算系数KP,/,1.350,,,波浪压力,频率换算系数KP,/,1.350,,,波浪压力,频率换算系数KP,/,1.350

,,,系数K1,/,1.049,,,,系数K1,/,1.353,,,,系数K1,/,1.102

,,,系数K2,/,1.277,,,,系数K2,/,1.097,,,,系数K2,/,1.071

,,,系数K3,/,2.770,,,,系数K3,/,2.414,,,,系数K3,/,2.903

,,,水的容重γw,kN/m3,9.810,,,,水的容重γw,kN/m3,9.810,,,,水的容重γw,kN/m3,9.810

,,,最大压力强度Pz,kN/m2,15.997,,,,最大压力强度Pz,kN/m2,34.543,,,,最大压力强度Pz,kN/m2,20.739

,,,A,中间变量,0.413,,,,A,中间变量,0.626,,,,A,中间变量,0.508

,,,B,中间变量,0.291,,,,B,中间变量,0.568,,,,B,中间变量,0.399

,,,最大压力作用点距水面的距离Zz,m,0.008,,,,最大压力作用点距水面的距离Zz,m,-0.061,,,,最大压力作用点距水面的距离Zz,m,-0.014

,护坡计算,砌石护坡,水的密度ρw,t/m3,1,,护坡计算,砌石护坡,水的密度ρw,t/m3,1,,护坡计算,砌石护坡,水的密度ρw,t/m3,1

,,,块石密度ρk,t/m3,2.35,,,,块石密度ρk,t/m3,2.35,,,,块石密度ρk,t/m3,2.35

,,,随坡率变化的系数Kt,/,1.244,,,,随坡率变化的系数Kt,/,1.244,,,,随坡率变化的系数Kt,/,1.244

,,,石块的换算球形直径D,m,0.122,,,,石块的换算球形直径D,m,0.273,,,,石块的换算球形直径D,m,0.171

,,,Lm/hp,中间变量,15.770,,,,Lm/hp,中间变量,5.306,,,,Lm/hp,中间变量,11.743

,,,护坡厚度t,m,0.178,,,,护坡厚度t,m,0.399,,,,护坡厚度t,m,0.250

,,堆石（抛石护坡）,系数k,/,4.370,,,堆石（抛石护坡）,系数k,/,4.370,,,堆石（抛石护坡）,系数k,/,4.370

,,,石块比重G,/,2.83,,,,石块比重G,/,2.83,,,,石块比重G,/,2.83

,,,石块的最大质量Qmax,t,0.007,,,,石块的最大质量Qmax,t,0.074,,,,石块的最大质量Qmax,t,0.018

,,,护坡厚度t,m,0.155,,,,护坡厚度t,m,0.347,,,,护坡厚度t,m,0.218

,,具有明缝的混凝土或钢筋混凝土板护坡,系数η,/,1.1,,,具有明缝的混凝土或钢筋混凝土板护坡,系数η,/,1.1,,,具有明缝的混凝土或钢筋混凝土板护坡,系数η,/