利用Excel VBA进行工程量计算统计程序的研发  

The development of statistical program for engineering quantity calculation by using Excel VBA

作　　者：熊平华 徐利霞 Xiong Pinghua;Xu Lixia(Powerchina Huadong Engineering Corporation Limited,Hangzhou 311122,China)

机构地区：[1]中国电建集团华东勘测设计研究院有限公司,浙江杭州311122

出　　处：《山西建筑》2021年第20期196-198,共3页Shanxi Architecture

摘　　要：工程量计算及统计是设计人员一项重要且烦琐的工作,通过对工程量计算表进行标准化设计,并利用Excel VBA二次开发,实现了工程量按分部分项工程自动汇总、统计,实现了主要工程量的自动统计,实现了工程量清单表的自动生成,极大的减少了烦琐工作量,提高了工作效率,也保证了工程量成果的准确性,可供广大工程设计、监理、施工及管理人员借鉴。The calculation and statistics of engineering quantity is an important and tedious work for designers.In this paper,through the standardized design of engineering quantity calculation table,and using Excel the secondary development of VBA realizes the automatic summary and statistics of the quantities according to the sub projects,the automatic statistics of the main quantities,and the automatic generation of the bill of quantities,which greatly reduces the tedious workload,improves the work efficiency,and ensures the accuracy of the results of the quantities.It can be used for reference by engineering design,supervision,construction and management personnel.

关 键 词：工程量 标准化 分部分项工程 Excel VBA 

分 类 号：TP319[自动化与计算机技术—计算机软件与理论]