Excel在桩基竖向承载力估算中的应用

Application of Excel in Estimating the Vertical Bearing Capacity of Pile Foundation

利用Excel强大的数据查找、计算、处理功能,只需进行Excel的函数、公式、简单宏命令设置,输入地层数据和桩基计算参数,就能按桩基的通用公式、大直径桩公式、嵌岩桩公式、抗拔桩公式、后注浆公式等,进行单桩竖向承载力估算。尤其适用于大型或复杂工程中不同工点、不同装置、不同桩型、不同桩径、不同桩端持力层等多种条件下的桩基方案比选,可以大大提高工作效率。

Use Excel＇s strong functions of data looking for, data calculation and data processing, carry out the estimation of vertical bearing capacity of single-pile comply with the common formula, large diameter pile formula, socket-pile formula, anti-pull up pile formula, later inject mortar formula etc. only need to set up its function, formula and simple macro order, enter the stratum data and the parameter of pile foundation calculation. Specially fit for the pile foundation scheme selection for the large and complicated project with different location, different device, different pile type, different pile diameter and different pile end bearing layer, largely enhance the work efficiency.