石油建设工程施工监理费的自动计算研究——基于Excel表格  

Research on Automatic Calculation of Construction Supervision Fees for Petroleum Construction Projects:Based on the Excel Table

作　　者：郝存河 贺悝 朱航熠 刘丽芬 HAO Cunhe;HE Kui;ZHU Hangyi;LIU Lifen(North China Oilfield Corporation Economic and Technological Research Institute,China Petroleum,Renqiu 062552,China)

机构地区：[1]中国石油华北油田公司经济技术研究院,河北任丘062552

出　　处：《建筑经济》2018年第9期52-55,共4页Construction Economy

摘　　要：在分类简化监理费计费额的基础上,利用Excel表格中IF函数条件判断功能进行编程,自动选取计算公式,结合Excel表格传递功能,形成自动计算石油建设工程施工监理费的新方法。该方法解决人工计算监理费过程中存在的运算复杂、重复性强、计算速度慢、易出错等问题,保证了监理费计算的准确性。On the basis of classifying and simplifying the amount of supervision fee,this paper uses the function of IF function condition judgment in excel table to program,automatically selects calculation formula,and combines the function of excel form transfer to form a new method for automatic calculation of construction supervision fee of petroleum construction project. This method can solve the problems of complex operation,strong repeatability,slow calculation speed,error prone and so on in the process of manual calculation of supervision and supervision,which ensures the accuracy of the calculation of supervision fee.

关 键 词：监理费 EXCEL表格 效率 准确性 

分 类 号：F407.9[经济管理—产业经济]