基于 EXCEL 的造价信息差额调整法计算表设计

摘要

The main contractor specification material list is provided in the bill of quantities(2013 version). A simple practical calculation table is designed with the function of EXCEL to judgment of price difference adjustment,selection and calculation of basic price. With the table,the difference of the price is judged,the basis price is selected and the differential adjustment is calculated. And the other reality may exist to expand the calculation table and other conditions that may exist in the calculation table are expanded,with a view to solve various computation problems.%结合2013版计价规范中承包人提供的主要材料表，利用 EXCEL 的制表与函数功能设计了一种简单实用的计算表，实现调差的判断、基础选择和计算，并对计算表可能存在的其他现实情况进行了拓展，以便于解决各种计算问题。