,,,,,,,,,,,,,,,

,堤防高程計算(按莆田試驗公式),,,,,,,,,,,單元格顏色說明,,

,V(m/s),F(m),d(m),m,β(°),KΔ,A(m),設(shè)計水位(m),超高Y(m),堤頂高程(m),,數(shù)據(jù)輸入單元格,,

,18.9,50,3,2.5,0,0.85,0.5,45.46,0.840,46.300,,單變量求解單元格,,

,H(m),T(s),tmin(s),L(m),Kv,Kp,R0,Rp,K,e(m),,公式計算單元格,,

,0.075,1.215,65.971,2.305,1.249,2.070,0.00,0.339,3.60E-06,0.001,,參考公式及數(shù)據(jù)單元格,,

,L值輔助計算區(qū),,,,,,Kv值輔助計算區(qū),,R0值輔助計算區(qū),,Kp值輔助計算區(qū),,,

,A,B,C,假設(shè)L,計算L,ΔL,V/(gd)^0.5,Kv,m,R0,H/d,<0.1,0.1~0.3,>0.3

,0.01578,0.13081,0.63084,2.305,2.305,0.000,3,1.22,1,2.2,P(%),Kp=Rp/R,,

,名詞解釋區(qū),,,,,,3.484,1.249,2.500,4,2,2.07,1.94,1.76

,V------計算風(fēng)速,,F-----風(fēng)區(qū)長度,,d-----水域平均水深,,3.5,1.25,1.25,2.5,0.1,2.66,2.44,2.13

,H------平均波高,,T-----平均波周期,,A-----安全超高,,1,1.00,0,1.24,1,2.23,2.08,1.86

,L------平均波長,,e-----風(fēng)雍水面度,,K-----綜合摩阻系數(shù),,1.5,1.02,0.5,1.45,2,2.07,1.94,1.76

,Kw------經(jīng)驗系數(shù),,m-----坡度系數(shù),,R0、Rp----波浪爬高,,2,1.08,1,2.20,3,1.97,1.86,1.70

,KΔ-----,斜坡的糙率滲透性系數(shù),,β-----,風(fēng)向與壩軸法線夾角,,2.5,1.16,1.25,2.50,4,1.90,1.80,1.65

,Kp-----,爬高累積頻率換算系數(shù),,tmin-----,風(fēng)浪穩(wěn)定時最小風(fēng)時,,3,1.22,m,Rp,5,1.84,1.75,1.61

,計算公式區(qū),,,,,,3.5,1.25,1.25,0.412,10,1.64,1.57,1.48

,,,,,,,4,1.28,2.500,0.887,13,1.54,1.48,1.40

,,,,,,,5,1.30,1.50,0.507,Kβ值輔助計算區(qū),,,

,,,,,,,護面類型,,,KΔ,β(°),Kβ,,

,,,,,,,光滑不透水護面（瀝青混凝土）,,,1,0,1.00,,

,,,,,,,混凝土或混凝土板,,,0.9,15,1,,

,,,,,,,草皮,,,0.85~0.90,20,0.96,,

,,,,,,,砌石,,,0.75~0.80,30,0.92,,

,,,,,,,拋填兩層塊石（不透水基礎(chǔ)）,,,0.60~0.65,40,0.87,,

,,,,,,,拋填兩層塊石（透水基礎(chǔ)）,,,0.50~0.55,50,0.82,,

,,,,,,,四腳空心方塊(安放一層),