Power Pivot技术在工程建设信息化中的应用

Application of Power Pivot Technology in Engineering Construction Informatization

为了工程项目和合同明细的管理,跟踪合同的执行情况,及时分析合同工期和费用的偏差,采用Power Pivot技术应用于工程建设信息化。通过建立数据表、关联关系,运用Power Pivot内置的度量值,分别建立查询相关度量值;最后通过Power Pivot内置的度量值,分别建立统计分析相关度量值。该方法实现了单人工程信息的合同管理,为工程建设信息化提供了可靠的技术支持。

In order to manage engineering projects and contract details,track contract execution,and timely analyze deviations in contract duration and costs,Power Pivot technology is applied to engineering construction informatization.Firstly,establish four tables;Secondly,by using the built-in metrics in Power Pivot;Finally,establish statistical analysis related metrics using the built-in metrics of Power Pivot.This method achieves contract management of single person engineering information and provides reliable technical support for engineering construction informatization.