欢迎来到冰点文库! | 帮助中心 分享价值,成长自我!
冰点文库
全部分类
  • 临时分类>
  • IT计算机>
  • 经管营销>
  • 医药卫生>
  • 自然科学>
  • 农林牧渔>
  • 人文社科>
  • 工程科技>
  • PPT模板>
  • 求职职场>
  • 解决方案>
  • 总结汇报>
  • ImageVerifierCode 换一换
    首页 冰点文库 > 资源分类 > XLS文档下载
    分享到微信 分享到微博 分享到QQ空间

    地基沉降量计算表格.xls

    • 资源ID:2485587       资源大小:418.50KB        全文页数:19页
    • 资源格式: XLS        下载积分:10金币
    快捷下载 游客一键下载
    账号登录下载
    微信登录下载
    三方登录下载: 微信开放平台登录 QQ登录
    二维码
    微信扫一扫登录
    下载资源需要10金币
    邮箱/手机:
    温馨提示:
    快捷下载时,用户名和密码都是您填写的邮箱或者手机号,方便查询和重复下载(系统自动生成)。
    如填写123,账号就是123,密码也是123。
    支付方式: 支付宝    微信支付   
    验证码:   换一换

    加入VIP,免费下载
     
    账号:
    密码:
    验证码:   换一换
      忘记密码?
        
    友情提示
    2、PDF文件下载后,可能会被浏览器默认打开,此种情况可以点击浏览器菜单,保存网页到桌面,就可以正常下载了。
    3、本站不支持迅雷下载,请使用电脑自带的IE浏览器,或者360浏览器、谷歌浏览器下载即可。
    4、本站资源下载后的文档和图纸-无水印,预览文档经过压缩,下载后原文更清晰。
    5、试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓。

    地基沉降量计算表格.xls

    1、变形计算 s计算Ai矩形面积上均布荷载作用下角点的 附加应力系数LBZa1130.0447矩形面积上均布荷载作用下角点的 平均附加应力系数LBZ(L2+B2+Z2)0.5(L2+B2)0.5a 3.22.535.0487622254.0607881010.2212应力系数 计算s计算Ai地基变形计算工程名称:工程编号:结构构件名称:1.计算原理根据建筑地基基础设计规范(GB50007-2002)第5.3.5条规定,计算地基变形时,地基内的应力分布,可采用各向同性均质线性变形体理论,其限制条件为矩形均布荷载作用下基础变形计算2.数据输入sp0(kpa)L(m)B(m)H(m)zn(m)1.001

    2、904427.78地层号层底深度fakEs土层到基底的深度hi注:地层自基底以下地层填起,基底以上有分层的地层不填mkpaMpa(m)12.52002.50.5231504.5135.31805.63.3410.530010.08.5520.52208.518.53.计算IziiEsisi(mm)si(mm)s(mm)10.50.24992.59.509.50计算深度不够21.00.24934.55.2514.75计算深度不够32.00.24525.68.1822.93计算深度不够43.00.23685.67.4630.39计算深度不够53.30.23355.62.0532.44计算深度不够6

    3、4.00.227410.02.6435.08计算深度不够75.00.212310.02.8837.96计算深度不够86.00.199110.02.5340.49计算深度不够97.00.186410.02.1042.59计算深度不够108.00.174610.01.7544.3344.354.说明黄色区为数据输入区,白色区数据自动计算生成.s为按建筑地基基础设计规范表5.3.5查出来的值,当有地区经验时,直接输入数据,关闭此表格但不保存就行。如有疑问,请咨询QQ19123524,海盗示示意意图图平均附加应力系数曲线计算s应力系数变形计算 计算Aipofak0.75fakpofakpo0.75fa

    4、k 分三种情况,按条件直接调用6.41.061.000.762.5471520pofak1.41.310.40.2po0.75fak1.110.70.40.2此表格根据前后表格数据自动生成,请勿更改SESE应力系数变形计算s第一层A1=0.124954065第二层A2=0.124367第三层A1/Es1=0.049981626A2/Es2=0.027637ndzZdAindzZdAindz1 0.005 0.0050.00125000110.0050.5050.00124810.012 0.005 0.0100.00125000120.0050.5100.001248120.013 0.005

    5、 0.0150.00125000130.0050.5150.0012480430.014 0.005 0.0200.00125000140.0050.5200.00124840.015 0.005 0.0250.00125000150.0050.5250.0012479350.016 0.005 0.0300.00125000160.0050.5300.0012478760.017 0.005 0.0350.0012570.0050.5350.00124870.018 0.005 0.0400.0012580.0050.5400.0012477580.019 0.005 0.0450.0012

    6、590.0050.5450.0012476890.0110 0.005 0.0500.001249999100.0050.5500.001248100.0111 0.005 0.0550.001249999110.0050.5550.00124756110.0112 0.005 0.0600.001249998120.0050.5600.00124749120.0113 0.005 0.0650.001249998130.0050.5650.001248130.0114 0.005 0.0700.001249998140.0050.5700.00124815140.0115 0.005 0.0

    7、750.001249997150.0050.5750.0012481150.0116 0.005 0.0800.001249996160.0050.5800.001248160.0117 0.005 0.0850.001249995170.0050.5850.001248170.0118 0.005 0.0900.001249994180.0050.5900.00124795180.00519 0.005 0.0950.001249992190.0050.5950.001248190.0120 0.005 0.1000.001249991200.0050.6000.00124785200.01

    8、21 0.005 0.1050.001249989210.0050.6050.00124779210.0122 0.005 0.1100.001249987220.0050.6100.001248220.0123 0.005 0.1150.001249986230.0050.6150.00124768230.0124 0.005 0.1200.001249983240.0050.6200.00124763240.0125 0.005 0.1250.001249972250.0050.6250.001247250.0126 0.005 0.1300.001249969260.0050.6300.

    9、00124645260.0127 0.005 0.1350.001249965270.0050.6350.00124637270.0128 0.005 0.1400.001249961280.0050.6400.001246280.0129 0.005 0.1450.001249956290.0050.6450.0012462290.0130 0.005 0.1500.001249952300.0050.6500.00124611300.00531 0.005 0.1550.001249947310.0050.6550.001246310.0132 0.005 0.1600.001249941

    10、320.0050.6600.00124593320.0133 0.005 0.1650.001249935330.0050.6650.00124584330.0134 0.005 0.1700.001249929340.0050.6700.001246340.0135 0.005 0.1750.001249923350.0050.6750.00124565350.0136 0.005 0.1800.001249916360.0050.6800.00124556360.0137 0.005 0.1850.001249909370.0050.6850.001245370.0138 0.005 0.

    11、1900.001249901380.0050.6900.00124537380.0139 0.005 0.1950.001249893390.0050.6950.00124527390.0140 0.005 0.2000.001249884400.0050.7000.001245400.0141 0.005 0.2050.001249875410.0050.7050.00124507410.0142 0.005 0.2100.001249866420.0050.7100.00124496420.00543 0.005 0.2150.001249856430.0050.7150.00124543

    12、0.0144 0.005 0.2200.001249846440.0050.7200.00124475440.0145 0.005 0.2250.001249835450.0050.7250.00124465450.0146 0.005 0.2300.001249824460.0050.7300.001245460.0147 0.005 0.2350.001249812470.0050.7350.00124443470.0148 0.005 0.2400.001249799480.0050.7400.00124432480.0149 0.005 0.2450.001249787490.0050

    13、.7450.001244490.0150 0.005 0.2500.001249773500.0050.7500.00124409500.0151 0.005 0.2550.001249759510.0050.7550.00124397510.0152 0.005 0.2600.001249745520.0050.5800.001247520.0153 0.005 0.2650.00124973530.0050.7650.00124374530.0154 0.005 0.2700.001249714540.0050.7700.00124362540.00555 0.005 0.2750.001

    14、249698550.0050.7750.001243550.0156 0.005 0.2800.001249681560.0050.7800.00124337560.0157 0.005 0.2850.001249664570.0050.7850.00124325570.0158 0.005 0.2900.001249646580.0050.7900.001243580.0159 0.005 0.2950.001249627590.0050.7950.001243590.0160 0.005 0.3000.001249608600.0050.8000.00124287600.0161 0.00

    15、5 0.3050.001249588610.0050.8050.001243610.0162 0.005 0.3100.001249568620.0050.8100.00124261620.0163 0.005 0.3150.001249547630.0050.8150.00124247630.0164 0.005 0.3200.001249525640.0050.8200.001242640.0165 0.005 0.3250.001249502650.0050.8250.0012422650.0166 0.005 0.3300.001249479660.0050.8300.00124207

    16、660.00567 0.005 0.3350.001249455670.0050.8350.001242670.0168 0.005 0.3400.00124943680.0050.8400.00124179680.0169 0.005 0.3450.001249405690.0050.8450.00124164690.0170 0.005 0.3500.001249379700.0050.8500.001242700.0171 0.005 0.3550.001249352710.0050.8550.00124136710.0172 0.005 0.3600.001249324720.0050

    17、.8600.00124121720.0173 0.005 0.3650.001249296730.0050.8650.001241730.0174 0.005 0.3700.001249267740.0050.8700.00124091740.0175 0.005 0.3750.001249237750.0050.8750.00124076750.0176 0.005 0.3800.001249206760.0050.8800.001241760.0177 0.005 0.3850.001249175770.0050.8850.00124045770.0178 0.005 0.3900.001

    18、249142780.0050.8900.0012403780.00579 0.005 0.3950.001249109790.0050.8950.00124790.0180 0.005 0.4000.001249075800.0050.9000.00123998800.0181 0.005 0.4050.00124904810.0050.9050.00123982810.0182 0.005 0.4100.001249005820.0050.9100.00124820.0183 0.005 0.4150.001248968830.0050.9150.00123949830.0184 0.005

    19、 0.4200.001248931840.0050.9200.00123933840.0185 0.005 0.4250.001248892850.0050.9250.001239850.0186 0.005 0.4300.001248853860.0050.9300.00123899860.0187 0.005 0.4350.001248813870.0050.9350.00123882870.0188 0.005 0.4400.001248772880.0050.5800.001247880.0189 0.005 0.4450.00124873890.0050.9450.001238478

    20、90.0190 0.005 0.4500.001248687900.0050.9500.0012383900.00591 0.005 0.4550.001248643910.0050.9550.001238910.0192 0.005 0.4600.001248599920.0050.9600.00123794920.0193 0.005 0.4650.001248553930.0050.9650.00123776930.0194 0.005 0.4700.001248506940.0050.9700.001238940.0195 0.005 0.4750.001248459950.0050.

    21、9750.0012374950.0196 0.005 0.4800.00124841960.0050.9800.00123721960.0197 0.005 0.4850.001248361970.0050.9850.00123702970.00598 0.005 0.4900.00124831980.0050.9900.001237980.00599 0.005 0.4950.001248258990.0050.9950.00123664990.005100 0.005 0.5000.0012482061000.0051.0000.001236451000.005A3=0.216879第四层

    22、A4=0.198689第五层A5=A3/Es3=0.038728A4/Es4=0.03548A5/Es5=ZdAindzZdAindzZ1.0100.0024721 0.012.0100.00232210.0033.0031.0200.002471332 0.012.0200.002320320.0033.0061.0300.002470533 0.012.0300.002318130.0033.0091.0400.002474 0.012.0400.00231640.0033.0121.0500.002468885 0.012.0500.0023136750.0033.0151.0300.0

    23、01235266 0.012.0300.0011590560.0033.0181.0700.0024677 0.012.0700.00230970.0033.0211.0800.00246638 0.012.0800.0023069380.0033.0241.0900.002465419 0.012.0900.0023046590.0033.0271.1000.00246510 0.012.1000.002302100.0033.0301.1100.0024635911 0.012.1100.00230008110.0033.0331.1200.0024626612 0.012.1200.00

    24、229777120.0033.0361.1300.00246213 0.012.1300.002295130.0033.0391.1400.0024607614 0.012.1400.00229313140.0033.0421.1500.0024597815 0.012.1500.00229079150.0033.0451.1600.00245916 0.012.1600.002288160.0033.0481.1700.002457817 0.012.1700.00228608170.0033.0511.0900.001232718 0.012.0900.00115233180.0033.0

    25、541.1900.00245619 0.012.1900.002281190.0033.0571.2000.0024547120 0.012.2000.00227893200.0033.0601.2100.0024536521 0.012.2100.00227653210.0033.0631.2200.00245322 0.012.2200.002274220.0033.0661.2300.0024514923 0.012.2300.00227168230.0033.0691.2400.0024503824 0.012.2400.00226925240.0033.0721.2500.00244

    26、925 0.012.2500.002267250.0033.0751.2600.0024481426 0.012.2600.00226434260.0033.0781.2700.0024469927 0.012.2700.00226188270.0033.0811.2800.00244628 0.012.2800.002259280.0033.0841.2900.0024446629 0.012.2900.00225691290.0033.0871.1500.0012298930 0.012.1500.0011454300.0033.0901.3100.00244231 0.012.3100.

    27、002252310.0033.0931.3200.0024410532 0.012.3200.00224939320.0033.0961.3300.0024398133 0.012.3300.00224686330.0033.0991.3400.00243934 0.012.3400.002244340.0033.1021.3500.002437335 0.012.3500.00224178350.0033.1051.3600.0024360336 0.012.3600.00223922360.0033.1081.3700.00243537 0.012.3700.002237370.0033.

    28、1111.3800.0024334338 0.012.3800.00223409380.0033.1141.3900.0024321139 0.012.3900.0022315390.0033.1171.4000.00243140 0.012.4000.002229400.0033.1201.4100.0024294241 0.012.4100.00222631410.0033.1231.2100.0012268242 0.012.2100.00113826420.0033.1261.4300.00242743 0.012.4300.002221430.0033.1291.4400.00242

    29、52844 0.012.4400.00221845440.0033.1321.4500.0024238745 0.012.4500.00221581450.0033.1351.4600.00242246 0.012.4600.002213460.0033.1381.4700.0024210147 0.012.4700.00221051470.0033.1411.4800.0024195648 0.012.4800.00220785480.0033.1441.4900.00241849 0.012.4900.002205490.0033.1471.5000.0024166150 0.012.50

    30、00.00220249500.0033.1501.5100.0024151151 0.012.5100.00219981510.0033.1531.1600.00245952 0.012.1600.002288520.0033.0481.5300.0024120853 0.012.5300.00219441530.0033.1591.2700.001223554 0.012.2700.00113094540.0033.1621.5500.00240955 0.012.5500.002189550.0033.1651.5600.0024074156 0.012.5600.00218625560.

    31、0033.1681.5700.0024058357 0.012.5700.00218351570.0033.1711.5800.00240458 0.012.5800.002181580.0033.1741.5900.0024026259 0.012.5900.00217802590.0033.1771.6000.00240160 0.012.6000.00217526600.0033.1801.6100.00239961 0.012.6100.002172610.0033.1831.6200.002397762 0.012.6200.00216972620.0033.1861.6300.00

    32、23960363 0.012.6300.00216694630.0033.1891.6400.00239464 0.012.6400.002164640.0033.1921.6500.0023926565 0.012.6500.00216136650.0033.1951.3300.0012199166 0.012.3300.00112343660.0033.1981.6700.00238967 0.012.6700.002156670.0033.2011.6800.0023874768 0.012.6800.00215293680.0033.2041.6900.0023857269 0.012

    33、.6900.00215011690.0033.2071.7000.00238470 0.012.7000.002147700.0033.2101.7100.0023821771 0.012.7100.00214445710.0033.2131.7200.0023803872 0.012.7200.00214161720.0033.2161.7300.00237973 0.012.7300.002139730.0033.2191.7400.0023767474 0.012.7400.00213591740.0033.2221.7500.0023749175 0.012.7500.00213305750.0033.2251.7600.00237376 0.012.7600.00213760.0033.2281.7700.0023711977 0.012.7700.00212731770.003


    注意事项

    本文(地基沉降量计算表格.xls)为本站会员主动上传,冰点文库仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知冰点文库(点击联系客服),我们立即给予删除!

    温馨提示:如果因为网速或其他原因下载失败请重新下载,重复下载不扣分。




    关于我们 - 网站声明 - 网站地图 - 资源地图 - 友情链接 - 网站客服 - 联系我们

    copyright@ 2008-2023 冰点文库 网站版权所有

    经营许可证编号:鄂ICP备19020893号-2


    收起
    展开