Excel函数及宏编程在提高施工结算效率中的应用

Application of Excel Function and Macro Programming in Improving Construction Settlement Efficiency

为提高一线土建工程项目信息化程度,提高工程内业计量与结算工作生产效率,通过改进项目部员工Excel处理与计算方式,引入数据标准化思维方式,在不进行任何信息化软件投资前提下,通过数据标准化结合Excel函数和宏编程,大大提高了一线项目管理人员Excel数据处理能力,是一种跨学科计量思维的突破。实验结果表明,同等工作量前提下可将之前29天工作量缩减为4.7天,提高项目部工程结算量6倍。Excel函数及宏编程不仅能快速有效处理大量工程业务数据,而且能有效降低原工作模式数据误差,提高工程计量准确性与工作效率。

In order to improve the degree of informatization of front-line civil engineering projects and improve the production efficien⁃cy of internal engineering measurement and settlement,a method is proposed without any information under the premise of software in⁃vestment to improve the EXCEL data processing ability of front-line project managers,which is by improving the Excel processing and calculation methods of the project department employees,and introducing the data standardization thinking in information construction through data standardization combined with Excel functions and macro programming.The method is a breakthrough in interdisciplinary measurement thinking.The experimental results show that under the same workload,the 29-day work volume can be reduced to 4.7 days,and the project settlement measurement of the project department can be increased by 6 times.Excel function and macro pro⁃gramming can not only quickly and effectively process a large number of engineering business data,but also effectively reduce the data error of the original working mode and improve the accuracy and efficiency of engineering measurement.