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

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

工程量计算及统计是设计人员一项重要且烦琐的工作,通过对工程量计算表进行标准化设计,并利用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.