Highway engineering construction cost management system based on Excel-VBA writing

The invention discloses a highway engineering construction cost management system based on Excel-VBA writing, and belongs to the technical field of highway engineering construction management. The system comprises a data acquisition module for extracting mobile phone data, a data check and query module for counting check data, a data extraction module for extracting data, a data analysis module for merging data files, and a financial settlement report generation module for docking financial departments. The system is simple and visual, can automatically generate various cost analysis results of the road and bridge engineering industry, can achieve the precise butt joint of engineering management data and financial management data, and effectively improves the construction cost management efficiency. 本发明公开了一种基于Excel-VBA编写的公路工程施工成本管理系统，属于公路工程施工管理技术领域，包括提取手机数据作用的数据采集模块、统计检查数据作用的数据检查与查询模块、进行数据提取的数据提取模块、合并数据文件的数据分析模块、对接财务部门的财务结算报告生成模块。本发明简洁直观，可自动生成路桥工程行业的各种成本分析结果、且能够实现工程管理数据与财务管理数据精准对接，有效提高了施工成本管理效率。