EXCEL在桩基工程图表编制中的应用

Application of MS EXCEL in Pile Foundation Engineering Chart Compilation

以华电膝州新源热电一期桩基工程计算为例,介绍EXCEL应用程序在计算桩基工程量、钢筋用量、工程报价、绘制工程进度图表中的应用步骤。特别强调利用EXCEL模板功能,将常用的计算报表制成模板,在工程变动时,使用模板自动填充功能,将需要反复试算的问题或同类工程计算,引入模板,可方便快捷地完成重复性计算。

To take the first stage pile foundation engineering calculation of the China Huadian Corporation Tengzhou Xinyuan thermoelectric power station as an example, the paper introduced MS EXCEL application procedure in pile foundation workload, reinforcing steel bar quantity and project quoted price calculations, construction progress charts compilation. Specially emphasized the Excel template functions, to make commonly used calculation report form templates, when the project is changed, to use the automatic filling function of templates, lead problems need to be tentatively calculated again and again or engineering calculations of the same kind into templates, so as to iterative calculations can be accomplished easily and quickly.