水电站压力管道计算器EXCEL表格

水电站压力管道计算,,,,,,,,,,,,,

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

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

一、管径计算,,,,SD144-85水电站压力钢管设计规范,,,,,,,,,

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

1、经济流速,,,,,,,,,,,,,

参数,,计算结果,工程应用取值,,,,,,,,,,

设计流量,经济流速,管径,5,,,,,,,,,,

88,5,4.732,,,,,,,,,,,

2、经验公式,,,,钢材材料力学性能,,单位Mpa,,,,,,,

参数,,计算结果,材质,<16,16~40,40~100,,,,,,,

设计流量,经济流速,管径,Q215,215,205,195,,,,,,,

88,--,4.792,Q235,235,225,215,,,,,,,

3、彭德舒公式,,,材质,<16,16~25,25~36,,,,,,,

参数,,计算结果,16Mn,345,325,315,,,,,,,

设计流量,设计水头,管径,15MnT,,390,375,,,,,,,

88,45,5.006,利用材料屈服强度,,225000,,,,,,,,

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

二、管壁厚度计算,,,,,,,,,,,,,

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

a、按内水压力初步计算,,,,,,,,,,,,,

参数,,,,,,,计算结果,,,,,,

钢管内径,跨中总水头,钢材屈服强度,钢材材质,强度,水头,焊缝,壁厚,,,,,,

m,m,kpa,,折算系数,乘数,系数,mm,,,,,,

5,45,99000,Q235,0.44,1.25,0.9,0.015,,,,,,

工程计算取值,0.015,工程采用壁厚,18,,,,,,,,,,

b1、稳定要求管壁厚度,,40,mm,不满足,,,,,,,,,

b2、稳定要求最小管壁厚度,,10,mm,满足要求,,,,,,,,,

c、不设加劲环，外压稳定计算,,,,,,,,,,,,,

钢材弹模,壁厚,内径,临界压力,抗外压稳定,是否满足,,,,,,,,

kpa,mm,m,,安全系数,稳定要求,,,,,,,,

2.06E+08,18,5.000,19.222272,2,不满足,,,,,,,,

c、设加劲环，外压稳定计算,,,,,,,,,,,,,

参数,,,,,计算结果,,,,,,,,

钢管平均半径,钢材弹模,壁厚,加劲环间距,泊松比,临界波数,临界压力,,,,,,,

2.509,2.06E+08,0.018,8,0.3,5,265.8951026,,,,,,,

计算过程,,,,是否满足2倍大气压值,,是否,,,,,,,

1+n2*l2/3.142/r2,,δ/r,n2-1,,,重新计算,,,,,,,

26.75247147,,0.007174173,24,满足条件,,否,,,,,,,

三、钢管受力分析,,,,,,,,,,,,,

参数输入区,,,,,,,,,,,,,

水容重,钢材容重,平均直径,壁厚,管线与水平夹角,加劲环间距,含附件材料重量系数,伸缩节水头,,,,,,

9.81,78.5,5.018,0.018,40,8,1.1,45,,,,,,

轴力计算,,,,,,,,,,,,,

每米水重,每米钢重,水、管法向分力,镇墩间钢管总跨数,钢管自重轴线分力,填料摩擦系数,支墩摩擦系数,,,,,,,

192.619,24.415,1330.060,6,721.905,0.3,0.1,,,,,,,

伸缩节内水压力,填料摩擦力,支墩钢管摩阻,填料长度,总轴向力,套管径差,,,,,,,,

97.352,419.0524322,665.030,0.2,-1903.339,取两倍的壁厚,,,,,,,,

四、管壁应力分析,,,,,,,,,,,,,

1、跨中断面(计算点θ度管壁外缘应力最大）,,,,,,,,,,,,,

a、环向应力,σθ1,61533.225,,,,,,,,,,,

b、轴应力,σx1,-6707.539,σx,,,,,,,,,,

,σx1,-1245.550,-7953.09,,,,,,,,,,

两端固结,M,443.389,,,,,,,,,,,

c、强度校核,σ,65870.848,,,,,,,,,,,

允许应力,111375,满足条件,,,,,,,,,,,

2、支承环旁膜应力区边缘断面(θ=180度，剪应力τxθ=0),,,,,,,,,,,,,

a、环向应力,σθ1,64161.385,,,,,,,,,,,

b、轴应力,σx1,-6707.539,σx,,,,,,,,,,

,σx2,-2490.801,-9198.34,,,,,,,,,,

两端固结,M,-886.671,,,,,,,,,,,

c、强度校核,σ,69220.452,,,,,,,,,,,

允许应力,111375,满足条件,,,,,,,,,,,

3、加劲环及其旁管壁,,,,,,,,,,,,,

a、加劲环截面尺寸,,,,,,,,,,,,,

肋高,肋宽,上翼板宽,上翼板厚,管壁等效翼缘,环重心至内壁,环重心至钢管中心距离,,,,,,,

0.3,0.036,0.3,0.018,0.165,0.15,,,,,,,,

加劲环截面积,有效截面积,截面惯性矩,β,B1,b,2.65,,,,,,,

0.0168,0.022805,4.82E-04,0.724577943,0.907,0.106,,,,,,,,

单支面积,0.022805,双支面积,0.028204668,截面惯性矩计算见截面几何性质计算软件,,,,,,,,,

b、应力验算,,,,,,,,,,,,,

M1,N1,β,σθ2,σx1,σx2,σx3,,,,,,,

4.292838144,51.88880277,0.710,7102.908686,-6707.539,-2490.801,79381.04123,+内缘-外缘,,,,,,

钢管内壁应力,66914.58473,钢管外壁应力,92335.95833,最大应力值,92335.95833,,,,,,,,

允许应力,111375,是否满足条件,满足条件,,,,,,,,,,

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

4、支承环及其旁管壁,,,,,,,,,,,,,

a、支承环截面尺寸,,,,,,,,,,,,,

肋高,肋宽,支承板宽,支承板厚,管壁等效翼缘,环重心至内壁D,环重心至钢管中心距离,,,,,,,

0.4,0.036,0.400,0.018,0.165760553,0.2,,,,,,,,

支承环截面积,有效截面积,截面惯性矩,β,B1,b,2.700,,,,,,,

0.022248,0.03541538,1.00E-03,0.619053078,0.889,0.108,,,,,,,,

单支面积,0.028215,双支面积,0.03541538,截面惯性矩计算见截面几何性质计算软件,,,,,,,,,

b、环向应力,,,,,,,,,,,,,

水压力σθ2,23440.89266,kPa,,,,,,,,,,,

支承环TR的σθ3,,,,,,,,,,,,,

计算断面θ,K1,K2,K1+B1*K2,TR,σθ3,,,,,,,,

0,-0.238732415,0.318,0.044327599,58.95837564,1664.767557,,,,,,,,

67,-0.264596367,0.124,-0.153996008,-204.8239633,-5783.474957,,,,,,,,

90,-0.25,0.000,-0.25,-332.5150528,-9389.001412,+,,,,,,,

90,0.25,0.000,0.25,332.5150528,9389.001412,-,,,,,,,

113,0.264596367,-0.124,0.153996008,204.8239633,5783.474957,,,,,,,,

180,0.238732415,-0.318,-0.044327599,-58.95837564,-1664.767557,,,,,,,,

支承环M的σθ4,,,,,,,,,,,,,

ZR1,0.2,ZR2,0.182,ZR3,-0.236,,,,,,,,

计算断面θ,K3,K4,MR,σθ4（kPa),,,,,,,,,

,,,,管内壁,管外壁,外环壁,,,,,,,

0,0.11120661,-0.068309886,389.5485394,77843.12866,70837.24708,-91854.89182,,,,,,,

67,-0.144060366,0.125626419,-499.2983999,-99774.34298,-90794.65211,117733.7247,,,,,,,

90,-1.44275E-16,0.25,35.9116257,7176.187348,6530.330487,-8467.90107,+,,,,,,

90,1.44275E-16,-0.25,-35.9116257,-7176.187348,-6530.330487,8467.90107,-,,,,,,

113,0.144060366,-0.125626419,499.2983999,99774.34298,90794.65211,-117733.7247,,,,,,,

180,-0.11120661,0.068309886,-389.5485394,-77843.12866,-70837.24708,91854.89182,,,,,,,

轴向应力σx,σx1,-6707.538564,,,,,,,,,,,

,σx3,69175.676,内壁取正值,管外壁取负值,,,,,,,,,

-m/3.14*r^2*δ,2490.890321,,,,,,,,,,,,

,σx2计算表,,,,,,,,,,,,

计算断面θ,σx2(kPa),,,,,,,,,,,,

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

0,2490.89032,,,,,,,,,,,,

67,973.26839,,,,,,,,,,,,

90,0.00000,,,+,,,,,,,,,

90,0.00000,,,-,,,,,,,,,

113,-973.26839,,,,,,,,,,,,

180,-2490.89032,,,,,,,,,,,,

c、强度校核,,,,,,,,,,,,,

c1、轴力产生应力,,相当应力计算表,,,,,,,,,,,

计算断面θ,∑σθ,∑σx,σ（kPa),,叛断,最大内外壁应力,最大外环应力,,,,,,

,(2)+(3),(1)+(2),管内外壁,环外壁,,,,,,,,,

0,25105.66022,-4216.648,27457.90,25105.66,,36646.98,32829.9,,,,,,

67,17657.4177,-5734.270,21116.79,17657.42,,,,,,,,,

90,14051.89125,-6707.539,18349.40,14051.89,,,,,,,,,

90,32829.89407,-6707.539,36646.98,32829.89,90,,,,,,,,

113,29224.36762,-7680.807,33727.22,29224.37,,,,,,,,,

180,21776.1251,-9198.429,27552.08,21776.13,,,,,,,,,

允许应力,135675,钢管内外壁是否满足要求,,满足条件,,,,,,,,,

,,钢管外环是否满足要求,,满足条件,,,,,,,,,

,,最大应发生部位,,90,,,,,,,,,

c2、轴力弯矩产生应力,,相当应力计算表,,,,,,,,,,,

计算断面θ,∑σθ,,,∑σx,,,σ（kPa),,,最大应力,,,叛断发生部位

,管内壁,管外壁,环外壁,管内壁,管外壁,环外壁,管内壁,管外壁,环外壁,管内壁,管外壁,管外环,

0,102948.7889,95942.907,-66749.2316,64959.03,-73392.324,0,90170.25658,147081.4318,-66749.2316,126402.5889,171859.6046,135391.1424,计算时自行查看最大应力发生部位

67,-82116.92528,-73137.234,135391.1424,63441.41,-74909.946,0,126402.5889,74039.50813,135391.1424,,,,

90,21228.0786,20582.222,5583.990178,62468.14,-75883.214,0,55016.55147,87998.49528,5583.990178,,,,

90,25653.70672,26299.564,41297.79514,62468.14,-75883.214,0,54386.04177,91900.07965,41297.79514,,,