均布荷载矩形群基础任意点沉降计算的Excel实现  

Settlement Calculation of Arbitrary Point of Rectangular Group Foundation under Uniformly Distributed Load by Microsoft Excel

作　　者：刘大海 

机构地区：[1]深圳市地质局,深圳518023

出　　处：《土工基础》2010年第1期67-69,75,共4页Soil Engineering and Foundation

摘　　要：以Excel为工具,使用解析公式计算矩形基础角点平均应力系数,利用符号函数将任意点平均应力系数的条件计算式转化为非条件计算式,采用应力承载比及等价压缩模量的曲面拟合公式计算规范沉降修正系数,从而使用Excel工具进行沉降计算不再需要人工查表插值,实现了均布荷载矩形群基础任意点沉降的自动计算。Microsoft Excel as the tool,the average stress coefficient of angular point of rectangular foundation is calculated by the analytical formula,the conditional formula of the average stress coefficient of arbitrary point is converted to non-conditional formula by the symbolic function,the modified settlement coefficient of foundation on code is calculated by the surface simulated formula related to and equivalent compression modulus,then the settlement calculation is done without interpolation by manual searching table,in which the automatic calculation of settlement of arbitrary point of rectangular group foundation under uniformly distributed load is realized.

关 键 词：矩形基础 平均应力系数 沉降计算 EXCEL 

分 类 号：TU455[建筑科学—岩土工程]