Excel工程算量模板的应用

-- 语言、表格、图形一个都不能少

excel templates for construction budget

--Descriptions、tables and drawings are all indispensable

摘要：我们大部分预算人员都是从手工算量开始的。但手工算量有过程繁琐、按计算器易出错、汇总困难及不易修改等缺点。因而很多人选择软件算量，但软件使用三维建模进行计算，较手工算量又多出了复杂的建模工作。

随着我国工程量清单规范的实施，编制自己的企业定额已日趋必要，企业定额的数据主要来源于历史数据的记录和统计分析。Excel具有强大的数据处理能力，是企业定额的理想选择。

本人通过实际经验总结，制作了工程算量模板，为编制企业定额提供了一个接入口。本模板在计算工程量及投标报价上具有以下优点：①数据清晰性强，②数据追溯性强，③调价直观性强。

关键词：Excel应用，Excel-CAD表格互导、工程算量软件，地毯式算量技术，工程量清单规范，企业定额。

Abstract: we all begin calculating by hand, It is troublesome to calculating by hand, and it’s not convenient to make statistics or modify. As a result, calculating soft wares have appeared one by one. However, when using soft wares to calculate, we have to do a lot of modeling work, which is the core of their calculating system.

As the specification for bill of quantities carries out, it becomes necessary to make the enterprise ration, the data of which come from the records and statistics of historical data. Excel has powerful data-dealing ability. And it will perfect technique.

After a lot of practice, I make a template for construction budget. It has the following advantages on construction budget and tender offer: ① The data is clear. ② It can easily tell the sources. ③ It is easy to read for adjusting prices.

Key: Application of Excel, data-in and data-out between tables of Excel and CAD, software for construction budget, specification for bill of quantities, the enterprise ration.