excel做的建筑实用程序-截面特性.xls

《excel做的建筑实用程序-截面特性.xls》由会员分享，可在线阅读，更多相关《excel做的建筑实用程序-截面特性.xls（5页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、第一跨截面距跨中距离X（m）梁高H（cm）梁底板上缘y(cm)梁底板厚h（cm）所在单元号AmIm0200180202.5202181.8116.2548926278690151.17.5218196.221.8450734254649794.412.525022525354350504360952.317.5298268.229.8259774816052205.122.5362325.836.216700613813450892540036040各截面特性（把对应的H和h代入黄色的单元格）用替换功能分块号分块面积AiYi(cm)SiYs-Yi(cm)IxIi17000535000113.2

2、89739364.04 58333.333332105002021000098.2101305659.2525000386001086000108.2100728865.4 286666.66674208601493108140-30.819756470.71 154370953.3512814283.13627643.4-164.9348332613.7 948278.7133合计Am=Ys=Si求和=659862973.115618923259774118.27066783.4Im=816052205.1第二跨截面距跨中距离X（m）梁高H（cm）梁底板上缘y(cm)梁底板厚h（cm）所在单

3、元号AmIm0200180203.7201.99874181.7933920.205351548928278714686.311.1217.98866196.1405121.848151450754345205596.418.5249.9685224.8347525.133751354405505204163.125.9297.93826267.8761130.06215125988281817677133.3361.89794325.2645936.633351167185138594158737399.874359.33940.535各截面特性（把对应的H和h代入黄色的单元格）用替换功能分

4、块号分块面积AiYi(cm)SiYs-Yi(cm)IxIi1700053500065.029601006.67 58333.333332105002021000050.026280009.6752500038600108600060.030989493.82 286666.6667414139.9118100.999371428122.184-31.013562866.23 48079813.6158688.3005191.8960651667250.677-121.9129035908.6 295587.6895合计Am=Ys=Si求和=22946928549245401.348928.21

5、2370.03426372.861Im=278714686.3第三跨截面距跨中距离X（m）梁高H（cm）梁底板上缘y(cm)梁底板厚h（cm）所在单元号AmIm0200180203201.9999998181.820.19999982548926278690149.39217.9999982196.221.79999822450734344957688.215249.99999522524.9999952354350504360890.921297.9999902268.229.79999022259774816052046.827361.9999838325.836.199983821670

6、06138134473630399.9999836039.99998各截面特性（把对应的H和h代入黄色的单元格）用替换功能分块号分块面积AiYi(cm)SiYs-Yi(cm)IxIi17000535000113.289739340.68 58333.333332105002021000098.2101305628.8525000386001086000108.2100728838 286666.6667420859.99931148.99999513108139.796-30.819756482.69 154370938.1512813.99579283.09999513627642.144-164.9348332540.7 948277.7778合计Am=Ys=Si求和=659862830.9 156189215.959773.9951118.27066781.94Im=816052046.8Ys70.077.693.3AmImYs118.2588668.02E+08117.94153.3Ys7077.693.4118.5153.7Ys70.077.693.3118.2153.3