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 mod...
Gespeichert in:
| Hauptverfasser: | , , , , , , , , , , , , , , , , , , , , , , , , , , , , , |
|---|---|
| Format: | Patent |
| Sprache: | chi ; eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | |
|---|---|
| container_issue | |
| container_start_page | |
| container_title | |
| container_volume | |
| creator | YAO RUI CHAI YIMO ZHANG ZHAO ZHU SA WANG NING ZHU YANLEI ZHAO KUAN WANG JIANXIN WEI JIN CHENG ZHONGXUN FU HUIDE WANG ZHEN ZHANG HUICHAO SUN JIANGANG WANG LEI LIU GUANHUA ZHEN XINGSHUANG SONG SHAOHUA WANG TAO LIU YANYANG ZHANG JUN SU XIA ZHANG CHAORAN LIU SIHAN LI LIQIN LIU MIAOQING LIU MINGJUN CHEN LIANGHAO SUN YIN WANG YAN |
| description | 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编写的公路工程施工成本管理系统，属于公路工程施工管理技术领域，包括提取手机数据作用的数据采集模块、统计检查数据作用的数据检查与查询模块、进行数据提取的数据提取模块、合并数据文件的数据分析模块、对接财务部门的财务结算报告生成模块。本发明简洁直观，可自动生成路桥工程行业的各种成本分析结果、且能够实现工程管理数据与财务管理数据精准对接，有效提高了施工成本管理效率。 |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN112734403A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN112734403A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN112734403A3</originalsourceid><addsrcrecordid>eNqNizEOgkAQRbexMOodxgOQiJBYI8FQWRhjS9b1u24Cs4QZg9xeCg9g9fPy3l-aSx38a7QTgX1gYAjsyUUWHd5OQ-QZRKmzbD06sJJMoujobgUPmn31cWiT27GgcQg639dm8bStYPPbldmeqmtZJ-hjA-mtA0Ob8pym-0OW57usyP5pvkT2OCQ</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Highway engineering construction cost management system based on Excel-VBA writing</title><source>esp@cenet</source><creator>YAO RUI ; CHAI YIMO ; ZHANG ZHAO ; ZHU SA ; WANG NING ; ZHU YANLEI ; ZHAO KUAN ; WANG JIANXIN ; WEI JIN ; CHENG ZHONGXUN ; FU HUIDE ; WANG ZHEN ; ZHANG HUICHAO ; SUN JIANGANG ; WANG LEI ; LIU GUANHUA ; ZHEN XINGSHUANG ; SONG SHAOHUA ; WANG TAO ; LIU YANYANG ; ZHANG JUN ; SU XIA ; ZHANG CHAORAN ; LIU SIHAN ; LI LIQIN ; LIU MIAOQING ; LIU MINGJUN ; CHEN LIANGHAO ; SUN YIN ; WANG YAN</creator><creatorcontrib>YAO RUI ; CHAI YIMO ; ZHANG ZHAO ; ZHU SA ; WANG NING ; ZHU YANLEI ; ZHAO KUAN ; WANG JIANXIN ; WEI JIN ; CHENG ZHONGXUN ; FU HUIDE ; WANG ZHEN ; ZHANG HUICHAO ; SUN JIANGANG ; WANG LEI ; LIU GUANHUA ; ZHEN XINGSHUANG ; SONG SHAOHUA ; WANG TAO ; LIU YANYANG ; ZHANG JUN ; SU XIA ; ZHANG CHAORAN ; LIU SIHAN ; LI LIQIN ; LIU MIAOQING ; LIU MINGJUN ; CHEN LIANGHAO ; SUN YIN ; WANG YAN</creatorcontrib><description>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编写的公路工程施工成本管理系统，属于公路工程施工管理技术领域，包括提取手机数据作用的数据采集模块、统计检查数据作用的数据检查与查询模块、进行数据提取的数据提取模块、合并数据文件的数据分析模块、对接财务部门的财务结算报告生成模块。本发明简洁直观，可自动生成路桥工程行业的各种成本分析结果、且能够实现工程管理数据与财务管理数据精准对接，有效提高了施工成本管理效率。</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; DATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FORADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORYOR FORECASTING PURPOSES ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS ; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE,COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTINGPURPOSES, NOT OTHERWISE PROVIDED FOR</subject><creationdate>2021</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20210430&DB=EPODOC&CC=CN&NR=112734403A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76289</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20210430&DB=EPODOC&CC=CN&NR=112734403A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>YAO RUI</creatorcontrib><creatorcontrib>CHAI YIMO</creatorcontrib><creatorcontrib>ZHANG ZHAO</creatorcontrib><creatorcontrib>ZHU SA</creatorcontrib><creatorcontrib>WANG NING</creatorcontrib><creatorcontrib>ZHU YANLEI</creatorcontrib><creatorcontrib>ZHAO KUAN</creatorcontrib><creatorcontrib>WANG JIANXIN</creatorcontrib><creatorcontrib>WEI JIN</creatorcontrib><creatorcontrib>CHENG ZHONGXUN</creatorcontrib><creatorcontrib>FU HUIDE</creatorcontrib><creatorcontrib>WANG ZHEN</creatorcontrib><creatorcontrib>ZHANG HUICHAO</creatorcontrib><creatorcontrib>SUN JIANGANG</creatorcontrib><creatorcontrib>WANG LEI</creatorcontrib><creatorcontrib>LIU GUANHUA</creatorcontrib><creatorcontrib>ZHEN XINGSHUANG</creatorcontrib><creatorcontrib>SONG SHAOHUA</creatorcontrib><creatorcontrib>WANG TAO</creatorcontrib><creatorcontrib>LIU YANYANG</creatorcontrib><creatorcontrib>ZHANG JUN</creatorcontrib><creatorcontrib>SU XIA</creatorcontrib><creatorcontrib>ZHANG CHAORAN</creatorcontrib><creatorcontrib>LIU SIHAN</creatorcontrib><creatorcontrib>LI LIQIN</creatorcontrib><creatorcontrib>LIU MIAOQING</creatorcontrib><creatorcontrib>LIU MINGJUN</creatorcontrib><creatorcontrib>CHEN LIANGHAO</creatorcontrib><creatorcontrib>SUN YIN</creatorcontrib><creatorcontrib>WANG YAN</creatorcontrib><title>Highway engineering construction cost management system based on Excel-VBA writing</title><description>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编写的公路工程施工成本管理系统，属于公路工程施工管理技术领域，包括提取手机数据作用的数据采集模块、统计检查数据作用的数据检查与查询模块、进行数据提取的数据提取模块、合并数据文件的数据分析模块、对接财务部门的财务结算报告生成模块。本发明简洁直观，可自动生成路桥工程行业的各种成本分析结果、且能够实现工程管理数据与财务管理数据精准对接，有效提高了施工成本管理效率。</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>DATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FORADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORYOR FORECASTING PURPOSES</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><subject>SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE,COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTINGPURPOSES, NOT OTHERWISE PROVIDED FOR</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2021</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNizEOgkAQRbexMOodxgOQiJBYI8FQWRhjS9b1u24Cs4QZg9xeCg9g9fPy3l-aSx38a7QTgX1gYAjsyUUWHd5OQ-QZRKmzbD06sJJMoujobgUPmn31cWiT27GgcQg639dm8bStYPPbldmeqmtZJ-hjA-mtA0Ob8pym-0OW57usyP5pvkT2OCQ</recordid><startdate>20210430</startdate><enddate>20210430</enddate><creator>YAO RUI</creator><creator>CHAI YIMO</creator><creator>ZHANG ZHAO</creator><creator>ZHU SA</creator><creator>WANG NING</creator><creator>ZHU YANLEI</creator><creator>ZHAO KUAN</creator><creator>WANG JIANXIN</creator><creator>WEI JIN</creator><creator>CHENG ZHONGXUN</creator><creator>FU HUIDE</creator><creator>WANG ZHEN</creator><creator>ZHANG HUICHAO</creator><creator>SUN JIANGANG</creator><creator>WANG LEI</creator><creator>LIU GUANHUA</creator><creator>ZHEN XINGSHUANG</creator><creator>SONG SHAOHUA</creator><creator>WANG TAO</creator><creator>LIU YANYANG</creator><creator>ZHANG JUN</creator><creator>SU XIA</creator><creator>ZHANG CHAORAN</creator><creator>LIU SIHAN</creator><creator>LI LIQIN</creator><creator>LIU MIAOQING</creator><creator>LIU MINGJUN</creator><creator>CHEN LIANGHAO</creator><creator>SUN YIN</creator><creator>WANG YAN</creator><scope>EVB</scope></search><sort><creationdate>20210430</creationdate><title>Highway engineering construction cost management system based on Excel-VBA writing</title><author>YAO RUI ; CHAI YIMO ; ZHANG ZHAO ; ZHU SA ; WANG NING ; ZHU YANLEI ; ZHAO KUAN ; WANG JIANXIN ; WEI JIN ; CHENG ZHONGXUN ; FU HUIDE ; WANG ZHEN ; ZHANG HUICHAO ; SUN JIANGANG ; WANG LEI ; LIU GUANHUA ; ZHEN XINGSHUANG ; SONG SHAOHUA ; WANG TAO ; LIU YANYANG ; ZHANG JUN ; SU XIA ; ZHANG CHAORAN ; LIU SIHAN ; LI LIQIN ; LIU MIAOQING ; LIU MINGJUN ; CHEN LIANGHAO ; SUN YIN ; WANG YAN</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN112734403A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2021</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>DATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FORADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORYOR FORECASTING PURPOSES</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><topic>SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE,COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTINGPURPOSES, NOT OTHERWISE PROVIDED FOR</topic><toplevel>online_resources</toplevel><creatorcontrib>YAO RUI</creatorcontrib><creatorcontrib>CHAI YIMO</creatorcontrib><creatorcontrib>ZHANG ZHAO</creatorcontrib><creatorcontrib>ZHU SA</creatorcontrib><creatorcontrib>WANG NING</creatorcontrib><creatorcontrib>ZHU YANLEI</creatorcontrib><creatorcontrib>ZHAO KUAN</creatorcontrib><creatorcontrib>WANG JIANXIN</creatorcontrib><creatorcontrib>WEI JIN</creatorcontrib><creatorcontrib>CHENG ZHONGXUN</creatorcontrib><creatorcontrib>FU HUIDE</creatorcontrib><creatorcontrib>WANG ZHEN</creatorcontrib><creatorcontrib>ZHANG HUICHAO</creatorcontrib><creatorcontrib>SUN JIANGANG</creatorcontrib><creatorcontrib>WANG LEI</creatorcontrib><creatorcontrib>LIU GUANHUA</creatorcontrib><creatorcontrib>ZHEN XINGSHUANG</creatorcontrib><creatorcontrib>SONG SHAOHUA</creatorcontrib><creatorcontrib>WANG TAO</creatorcontrib><creatorcontrib>LIU YANYANG</creatorcontrib><creatorcontrib>ZHANG JUN</creatorcontrib><creatorcontrib>SU XIA</creatorcontrib><creatorcontrib>ZHANG CHAORAN</creatorcontrib><creatorcontrib>LIU SIHAN</creatorcontrib><creatorcontrib>LI LIQIN</creatorcontrib><creatorcontrib>LIU MIAOQING</creatorcontrib><creatorcontrib>LIU MINGJUN</creatorcontrib><creatorcontrib>CHEN LIANGHAO</creatorcontrib><creatorcontrib>SUN YIN</creatorcontrib><creatorcontrib>WANG YAN</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>YAO RUI</au><au>CHAI YIMO</au><au>ZHANG ZHAO</au><au>ZHU SA</au><au>WANG NING</au><au>ZHU YANLEI</au><au>ZHAO KUAN</au><au>WANG JIANXIN</au><au>WEI JIN</au><au>CHENG ZHONGXUN</au><au>FU HUIDE</au><au>WANG ZHEN</au><au>ZHANG HUICHAO</au><au>SUN JIANGANG</au><au>WANG LEI</au><au>LIU GUANHUA</au><au>ZHEN XINGSHUANG</au><au>SONG SHAOHUA</au><au>WANG TAO</au><au>LIU YANYANG</au><au>ZHANG JUN</au><au>SU XIA</au><au>ZHANG CHAORAN</au><au>LIU SIHAN</au><au>LI LIQIN</au><au>LIU MIAOQING</au><au>LIU MINGJUN</au><au>CHEN LIANGHAO</au><au>SUN YIN</au><au>WANG YAN</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Highway engineering construction cost management system based on Excel-VBA writing</title><date>2021-04-30</date><risdate>2021</risdate><abstract>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编写的公路工程施工成本管理系统，属于公路工程施工管理技术领域，包括提取手机数据作用的数据采集模块、统计检查数据作用的数据检查与查询模块、进行数据提取的数据提取模块、合并数据文件的数据分析模块、对接财务部门的财务结算报告生成模块。本发明简洁直观，可自动生成路桥工程行业的各种成本分析结果、且能够实现工程管理数据与财务管理数据精准对接，有效提高了施工成本管理效率。</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | chi ; eng |
| recordid | cdi_epo_espacenet_CN112734403A |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING DATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FORADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORYOR FORECASTING PURPOSES ELECTRIC DIGITAL DATA PROCESSING PHYSICS SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE,COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTINGPURPOSES, NOT OTHERWISE PROVIDED FOR |
| title | Highway engineering construction cost management system based on Excel-VBA writing |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-08T01%3A35%3A25IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=YAO%20RUI&rft.date=2021-04-30&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN112734403A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true |