地基沉降量计算表格.xls

地基沉降量计算表格.xls

《地基沉降量计算表格.xls》由会员分享，可在线阅读，更多相关《地基沉降量计算表格.xls（19页珍藏版）》请在冰点文库上搜索。

变形计算s计算Ai矩形面积上均布荷载作用下角点的附加应力系数LBZa1130.0447矩形面积上均布荷载作用下角点的平均附加应力系数LBZ（L2+B2+Z2）0.5（L2+B2）0.5a3.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.001904427.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计算深度不够64.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.75fak分三种情况，按条件直接调用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.027637ndzZdAindzZdAindz10.0050.0050.00125000110.0050.5050.00124810.0120.0050.0100.00125000120.0050.5100.001248120.0130.0050.0150.00125000130.0050.5150.0012480430.0140.0050.0200.00125000140.0050.5200.00124840.0150.0050.0250.00125000150.0050.5250.0012479350.0160.0050.0300.00125000160.0050.5300.0012478760.0170.0050.0350.0012570.0050.5350.00124870.0180.0050.0400.0012580.0050.5400.0012477580.0190.0050.0450.0012590.0050.5450.0012476890.01100.0050.0500.001249999100.0050.5500.001248100.01110.0050.0550.001249999110.0050.5550.00124756110.01120.0050.0600.001249998120.0050.5600.00124749120.01130.0050.0650.001249998130.0050.5650.001248130.01140.0050.0700.001249998140.0050.5700.00124815140.01150.0050.0750.001249997150.0050.5750.0012481150.01160.0050.0800.001249996160.0050.5800.001248160.01170.0050.0850.001249995170.0050.5850.001248170.01180.0050.0900.001249994180.0050.5900.00124795180.005190.0050.0950.001249992190.0050.5950.001248190.01200.0050.1000.001249991200.0050.6000.00124785200.01210.0050.1050.001249989210.0050.6050.00124779210.01220.0050.1100.001249987220.0050.6100.001248220.01230.0050.1150.001249986230.0050.6150.00124768230.01240.0050.1200.001249983240.0050.6200.00124763240.01250.0050.1250.001249972250.0050.6250.001247250.01260.0050.1300.001249969260.0050.6300.00124645260.01270.0050.1350.001249965270.0050.6350.00124637270.01280.0050.1400.001249961280.0050.6400.001246280.01290.0050.1450.001249956290.0050.6450.0012462290.01300.0050.1500.001249952300.0050.6500.00124611300.005310.0050.1550.001249947310.0050.6550.001246310.01320.0050.1600.001249941320.0050.6600.00124593320.01330.0050.1650.001249935330.0050.6650.00124584330.01340.0050.1700.001249929340.0050.6700.001246340.01350.0050.1750.001249923350.0050.6750.00124565350.01360.0050.1800.001249916360.0050.6800.00124556360.01370.0050.1850.001249909370.0050.6850.001245370.01380.0050.1900.001249901380.0050.6900.00124537380.01390.0050.1950.001249893390.0050.6950.00124527390.01400.0050.2000.001249884400.0050.7000.001245400.01410.0050.2050.001249875410.0050.7050.00124507410.01420.0050.2100.001249866420.0050.7100.00124496420.005430.0050.2150.001249856430.0050.7150.001245430.01440.0050.2200.001249846440.0050.7200.00124475440.01450.0050.2250.001249835450.0050.7250.00124465450.01460.0050.2300.001249824460.0050.7300.001245460.01470.0050.2350.001249812470.0050.7350.00124443470.01480.0050.2400.001249799480.0050.7400.00124432480.01490.0050.2450.001249787490.0050.7450.001244490.01500.0050.2500.001249773500.0050.7500.00124409500.01510.0050.2550.001249759510.0050.7550.00124397510.01520.0050.2600.001249745520.0050.5800.001247520.01530.0050.2650.00124973530.0050.7650.00124374530.01540.0050.2700.001249714540.0050.7700.00124362540.005550.0050.2750.001249698550.0050.7750.001243550.01560.0050.2800.001249681560.0050.7800.00124337560.01570.0050.2850.001249664570.0050.7850.00124325570.01580.0050.2900.001249646580.0050.7900.001243580.01590.0050.2950.001249627590.0050.7950.001243590.01600.0050.3000.001249608600.0050.8000.00124287600.01610.0050.3050.001249588610.0050.8050.001243610.01620.0050.3100.001249568620.0050.8100.00124261620.01630.0050.3150.001249547630.0050.8150.00124247630.01640.0050.3200.001249525640.0050.8200.001242640.01650.0050.3250.001249502650.0050.8250.0012422650.01660.0050.3300.001249479660.0050.8300.00124207660.005670.0050.3350.001249455670.0050.8350.001242670.01680.0050.3400.00124943680.0050.8400.00124179680.01690.0050.3450.001249405690.0050.8450.00124164690.01700.0050.3500.001249379700.0050.8500.001242700.01710.0050.3550.001249352710.0050.8550.00124136710.01720.0050.3600.001249324720.0050.8600.00124121720.01730.0050.3650.001249296730.0050.8650.001241730.01740.0050.3700.001249267740.0050.8700.00124091740.01750.0050.3750.001249237750.0050.8750.00124076750.01760.0050.3800.001249206760.0050.8800.001241760.01770.0050.3850.001249175770.0050.8850.00124045770.01780.0050.3900.001249142780.0050.8900.0012403780.005790.0050.3950.001249109790.0050.8950.00124790.01800.0050.4000.001249075800.0050.9000.00123998800.01810.0050.4050.00124904810.0050.9050.00123982810.01820.0050.4100.001249005820.0050.9100.00124820.01830.0050.4150.001248968830.0050.9150.00123949830.01840.0050.4200.001248931840.0050.9200.00123933840.01850.0050.4250.001248892850.0050.9250.001239850.01860.0050.4300.001248853860.0050.9300.00123899860.01870.0050.4350.001248813870.0050.9350.00123882870.01880.0050.4400.001248772880.0050.5800.001247880.01890.0050.4450.00124873890.0050.9450.00123847890.01900.0050.4500.001248687900.0050.9500.0012383900.005910.0050.4550.001248643910.0050.9550.001238910.01920.0050.4600.001248599920.0050.9600.00123794920.01930.0050.4650.001248553930.0050.9650.00123776930.01940.0050.4700.001248506940.0050.9700.001238940.01950.0050.4750.001248459950.0050.9750.0012374950.01960.0050.4800.00124841960.0050.9800.00123721960.01970.0050.4850.001248361970.0050.9850.00123702970.005980.0050.4900.00124831980.0050.9900.001237980.005990.0050.4950.001248258990.0050.9950.00123664990.0051000.0050.5000.0012482061000.0051.0000.001236451000.005A3=0.216879第四层A4=0.198689第五层A5=A3/Es3=0.038728A4/Es4=0.03548A5/Es5=ZdAindzZdAindzZ1.0100.00247210.012.0100.00232210.0033.0031.0200.0024713320.012.0200.002320320.0033.0061.0300.0024705330.012.0300.002318130.0033.0091.0400.0024740.012.0400.00231640.0033.0121.0500.0024688850.012.0500.0023136750.0033.0151.0300.0012352660.012.0300.0011590560.0033.0181.0700.00246770.012.0700.00230970.0033.0211.0800.002466380.012.0800.0023069380.0033.0241.0900.0024654190.012.0900.0023046590.0033.0271.1000.002465100.012.1000.002302100.0033.0301.1100.00246359110.012.1100.00230008110.0033.0331.1200.00246266120.012.1200.00229777120.0033.0361.1300.002462130.012.1300.002295130.0033.0391.1400.00246076140.012.1400.00229313140.0033.0421.1500.00245978150.012.1500.00229079150.0033.0451.1600.002459160.012.1600.002288160.0033.0481.1700.0024578170.012.1700.00228608170.0033.0511.0900.0012327180.012.0900.00115233180.0033.0541.1900.002456190.012.1900.002281190.0033.0571.2000.00245471200.012.2000.00227893200.0033.0601.2100.00245365210.012.2100.00227653210.0033.0631.2200.002453220.012.2200.002274220.0033.0661.2300.00245149230.012.2300.00227168230.0033.0691.2400.00245038240.012.2400.00226925240.0033.0721.2500.002449250.012.2500.002267250.0033.0751.2600.00244814260.012.2600.00226434260.0033.0781.2700.00244699270.012.2700.00226188270.0033.0811.2800.002446280.012.2800.002259280.0033.0841.2900.00244466290.012.2900.00225691290.0033.0871.1500.00122989300.012.1500.0011454300.0033.0901.3100.002442310.012.3100.002252310.0033.0931.3200.00244105320.012.3200.00224939320.0033.0961.3300.00243981330.012.3300.00224686330.0033.0991.3400.002439340.012.3400.002244340.0033.1021.3500.0024373350.012.3500.00224178350.0033.1051.3600.00243603360.012.3600.00223922360.0033.1081.3700.002435370.012.3700.002237370.0033.1111.3800.00243343380.012.3800.00223409380.0033.1141.3900.00243211390.012.3900.0022315390.0033.1171.4000.002431400.012.4000.002229400.0033.1201.4100.00242942410.012.4100.00222631410.0033.1231.2100.00122682420.012.2100.00113826420.0033.1261.4300.002427430.012.4300.002221430.0033.1291.4400.00242528440.012.4400.00221845440.0033.1321.4500.00242387450.012.4500.00221581450.0033.1351.4600.002422460.012.4600.002213460.0033.1381.4700.00242101470.012.4700.00221051470.0033.1411.4800.00241956480.012.4800.00220785480.0033.1441.4900.002418490.012.4900.002205490.0033.1471.5000.00241661500.012.5000.00220249500.0033.1501.5100.00241511510.012.5100.00219981510.0033.1531.1600.002459520.012.1600.002288520.0033.0481.5300.00241208530.012.5300.00219441530.0033.1591.2700.0012235540.012.2700.00113094540.0033.1621.5500.002409550.012.5500.002189550.0033.1651.5600.00240741560.012.5600.00218625560.0033.1681.5700.00240583570.012.5700.00218351570.0033.1711.5800.002404580.012.5800.002181580.0033.1741.5900.00240262590.012.5900.00217802590.0033.1771.6000.002401600.012.6000.00217526600.0033.1801.6100.002399610.012.6100.002172610.0033.1831.6200.0023977620.012.6200.00216972620.0033.1861.6300.00239603630.012.6300.00216694630.0033.1891.6400.002394640.012.6400.002164640.0033.1921.6500.00239265650.012.6500.00216136650.0033.1951.3300.00121991660.012.3300.00112343660.0033.1981.6700.002389670.012.6700.002156670.0033.2011.6800.00238747680.012.6800.00215293680.0033.2041.6900.00238572690.012.6900.00215011690.0033.2071.7000.002384700.012.7000.002147700.0033.2101.7100.00238217710.012.7100.00214445710.0033.2131.7200.00238038720.012.7200.00214161720.0033.2161.7300.002379730.012.7300.002139730.0033.2191.7400.00237674740.012.7400.00213591740.0033.2221.7500.00237491750.012.7500.00213305750.0033.2251.7600.002373760.012.7600.00213760.0033.2281.7700.00237119770.012.7700.00212731770.003