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

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

以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.