地基附加应力和变形计算的Excel电子表格法

地基附加应力和变形计算是地基设计计算的重要内容,直接关系着结构设计的安全可靠程度.传统的计算方法是基于计算成果表的查表插值法.该方法手工计算工作量大且容易出现计算错误.基于弹性理论的地基应力计算原理,给出了地基附加应力计算的Excel电子表格法.对地基变形计算的假定前提进行了讨论,对地基变形计算的传统分层总和法和规范推荐方法进行了原理分析、计算分析和计算结果比较,给出了地基变形计算的Excel电子表格法的基本方法.提出了一个适于Excel电子表格法的新的e-p表达式.给出的地基附加应力及变形计算Excel电子表格法可极大提高相关内容的计算效率,避免出现计算差错.

Excel method about stress and displacement of foundations

Calculation in superimposed stress and displacement of foundation is an important factorfor foundation design. It is the basis of construction designing dependably and safely. Traditional method of calculation in superimposed stress and displacement of foundation named numeric insert, is based upon the numeric tables, which had been given out by books. As far as this method is concerned, a large amount of calculation has to be done by hand, so it is no strange that errors may occur very frequently. Based upon the elastic theory about stress calculating, an Excel method about stress calculating of foundation has been given out. Discussing the assumptions about calculation in dissplacement of foundation from fundamental principles and through an example, analyzing and contrasting layerwise summation method with the method recommended by foundation code about displacement of foundation is also presented. Excel method for calculating displacement of foundation has also been given out. A new e-p formula is proposed primarily for Excel method. This method helps improve the efficiency of calculation in superimposed stress and displacement of foundation greatly, and can reduce the possibility of calculating errors.