CN112000724A - Highway engineering collaborative computation amount information management system based on custom formula - Google Patents

Highway engineering collaborative computation amount information management system based on custom formula Download PDF

Info

Publication number
CN112000724A
CN112000724A CN202010877554.5A CN202010877554A CN112000724A CN 112000724 A CN112000724 A CN 112000724A CN 202010877554 A CN202010877554 A CN 202010877554A CN 112000724 A CN112000724 A CN 112000724A
Authority
CN
China
Prior art keywords
engineering
data
project
calculation
items
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010877554.5A
Other languages
Chinese (zh)
Inventor
向正松
唐诗皓
王海珠
刘万春
李海清
周明凯
孙家俊
席锦州
阮玲玉
郭玉龙
秦春伟
齐飞
李金阳
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Sichuan Road and Bridge (Group) Co Ltd
Original Assignee
Sichuan Road and Bridge (Group) Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Sichuan Road and Bridge (Group) Co Ltd filed Critical Sichuan Road and Bridge (Group) Co Ltd
Priority to CN202010877554.5A priority Critical patent/CN112000724A/en
Publication of CN112000724A publication Critical patent/CN112000724A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Data Mining & Analysis (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a road engineering collaborative computation amount information management system based on a custom formula; the method comprises the following steps: the system comprises a data processing center, a front-end interactive system, an online form editing module and a data interface service. The invention has the following advantages: 1. project managers only need to manage the templates, the related formulas and the numerical terms of the projects, and do not need to communicate and issue related materials to designers repeatedly. 2. The designer only needs to fill in the related numerical values of the subentries and does not need to care about the calculation formulas and calculation results of the subentries. 3. The items are not interfered with each other, and the modified formula and the data items are only effective in the item. 4. And automatically generating a project amount list and the project amount required to be classified by the cost software. This patent liberates project management personnel and project design personnel from a large amount of complicated calculations calculation and communication, has practiced thrift a large amount of time cost and human cost, because the computational process is carried out by the computer simultaneously, has guaranteed the accuracy of computational result, provides reliable guarantee for the result of engineering calculations.

Description

Highway engineering collaborative computation amount information management system based on custom formula
Technical Field
The invention relates to the field related to engineering management, in particular to a road engineering cooperative calculation amount information management system based on a custom formula.
Background
The existing engineering calculation amount can only be calculated by a fixed formula, and meanwhile, the form field is fixed, so that the calculation formulas of different projects and different calculation projects cannot be flexibly changed according to engineering design, the calculation amount process is rigid, once the calculation formulas and the calculation projects are changed, recalculation and summarization are needed, huge workload is generated for related designers, and even if communication is not timely, errors and omissions are generated in the calculation amount of the whole project.
Disclosure of Invention
Therefore, in order to solve the above-mentioned deficiencies, the present invention provides a road engineering collaborative computation amount information management system based on a custom formula; the invention aims to solve the problems that in the engineering calculation process of a design project, if a calculation formula is changed in the design process, the calculation of all engineering drawings needs to be recalculated and summarized again, a great amount of repeated and complicated work is generated for each designer, and in the changing process, calculation errors can occur. Therefore, the invention provides a method for changing the calculation formula, changing the calculation items and automatically calculating the calculation by the building engineering calculation information management system, thereby solving the problem. The system also has the following characteristics that 1, the calculation amount is calculated once without repeated calculation. 2. And the system is in seamless connection with a cost software system.
The invention is realized in such a way that a road engineering collaborative computation information management system based on a self-defined formula is constructed; it is characterized in that;
the system comprises: the system comprises a data processing center, a front-end interactive system, an online form editing module and a data interface service;
the data processing center provides data interaction for a data interaction service, provides data interaction for a front-end interaction system, meets the requirement of database writing and reading, and provides data support for a data interface;
the front-end interactive system is an engineering computation system man-machine interactive system accessed by a user through a browser;
the online form editing module is an online Excel editing module accessed through a browser;
the data interface service is a standard API response service provided by the server side.
The invention relates to a road engineering collaborative computation amount information management system based on a custom formula; it is characterized in that; the system executes the following processes;
1) accessing the engineering calculation system, inputting relevant information of projects, inputting section information (including section pile numbers), and inputting relevant information (including pile number information and later used for calculation) of roads, bridges, tunnels and the like (called sub-items after roads, bridges, tunnels and the like); uploading the standard calculation amount template of the enterprise;
2) entering an engineering computation quantity value management module, automatically generating a project tree by the system, clicking one project, and automatically copying an enterprise standard computation quantity template by the system to generate a project computation quantity template of the project;
3) the system automatically reads the engineering materials, the engineering projects, the related formulas and the related numerical values in the project computation amount template and writes the engineering materials, the engineering projects, the related formulas and the related numerical values into a data center;
4) entering an engineering calculation quantity value filling module, wherein the system automatically generates a directory tree of the project and the sub-items in a recursion manner, clicks one of the sub-items, and reads the engineering material and the project information of the project from the data center to regenerate the data related to the sub-items;
5) filling sub-item calculation amount filling values according to engineering materials and projects;
6) entering an engineering calculation quantity engineering quantity table module, wherein the system automatically generates a directory tree of the item and the sub-items in a recursion manner, clicking one of the sub-items, automatically calculating the data by the data center, writing a calculation result into a copied calculation quantity template of the item, and opening the calculation quantity template on line through an online form editing module so as to facilitate export and copy;
7) entering an engineering calculation amount engineering quantity list module, wherein the system automatically generates a directory tree of the project and the mark segments in a recursion manner, clicking one mark segment, automatically calculating the data by the data center, summarizing according to all sub-items contained in mark segment pile numbers, writing a calculation result into a copied engineering quantity list template of the project, and opening online through an online form editing module to facilitate export and copy;
8) entering an engineering calculation amount engineering amount detailed list module, automatically generating a directory tree of the project and the mark segments by the system in a recursion mode, clicking one mark segment, automatically calculating the data by the data center, summarizing according to all sub-items contained in mark segment pile numbers, writing a calculation result into a copied engineering amount detailed list template of the project, and opening the template on line through an online form editing module to facilitate exporting and copying. And provides a data pushing function, and pushes the data to the cost management system through the data interface service.
The invention relates to a road engineering collaborative computation amount information management system based on a custom formula; it is characterized in that; wherein the execution process of the automatic calculation of the data comprises the following steps:
1) the data center reads the stored project engineering materials, project projects, formulas and reported values;
2) the data center writes the read project engineering materials, project projects, formulas and filling values into a blank Excel table automatically built by the system, rereads the execution result of the Excel formula, and outputs the result to the front-end interactive system;
the invention relates to a road engineering collaborative computation amount information management system based on a custom formula; it is characterized in that; a formula modification data item modification execution process;
1) entering an engineering calculation quantity value management module, clicking one item in the item tree, and modifying and storing the listed formula and data item;
2) the data center writes new formulas and data items, and when automatic calculation of data is performed, calculation is performed according to the new formulas and data items.
The invention has the following advantages: 1. project managers only need to manage the templates, the related formulas and the numerical terms of the projects, and do not need to communicate and issue related materials to designers repeatedly. 2. The designer only needs to fill in the related numerical values of the subentries and does not need to care about the calculation formulas and calculation results of the subentries. 3. The items are not interfered with each other, and the modified formula and the data items are only effective in the item. This patent liberates project management personnel and project design personnel from a large amount of complicated calculations calculation and communication, has practiced thrift a large amount of time cost and human cost, because the computational process is carried out by the computer simultaneously, has guaranteed the accuracy of computational result, provides reliable guarantee for the result of engineering calculations. The system also has the following characteristics that 1, the calculation amount is calculated once without repeated calculation. 2. And the system is in seamless connection with a cost software system.
Drawings
FIG. 1 is a block diagram of the system of the present invention;
fig. 2 is a flow chart of the system of the present invention.
Detailed Description
The present invention will be described in detail with reference to fig. 1-2, and the technical solutions in the embodiments of the present invention will be clearly and completely described, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention provides a road engineering cooperative computation information management system based on a self-defined formula by improvement; as shown in fig. 1, the system includes: the system comprises a data processing center, a front-end interactive system, an online form editing module and a data interface service.
The data processing center provides data interaction for the data interaction service, provides data interaction for the front-end interaction system, meets the requirement of database writing and reading, and provides data support for the data interface.
The front-end interactive system is engineering computation system man-machine interactive software accessed by a user through a browser.
The online form editing module is an online Excel editing module accessed through a browser.
The data interface service is a standard API response service provided by the server side.
The system executes the process:
1) and accessing the engineering calculation system, inputting relevant information of projects, inputting section information (including section pile numbers), and inputting relevant information (including pile number information and later calculation) of roads, bridges, tunnels and the like (called sub-items after roads, bridges, tunnels and the like). And uploading the standard calculation amount template of the enterprise.
2) Entering an engineering calculation quantity value management module, automatically generating a project tree by the system, clicking one project, and automatically copying an enterprise standard calculation quantity template by the system to generate a project calculation quantity template of the project.
3) The system automatically reads the engineering materials, the engineering projects, the related formulas and the related numerical values in the project computation amount template and writes the engineering materials, the engineering projects, the related formulas and the related numerical values into the data center.
4) Entering an engineering calculation quantity value filling module, automatically generating a directory tree of the project and the sub-items by the system in a recursion mode, clicking one of the sub-items, and reading the engineering material and the project information of the project from the data center by the system to regenerate the data related to the sub-items.
5) Filling the sub-item computation amount filling values according to engineering materials and projects.
6) Entering an engineering calculation quantity engineering quantity table module, automatically generating a directory tree of the item and the sub-items by the system through recursion, clicking one of the sub-items, automatically calculating the data by the data center, writing the calculation result into a copied calculation quantity template of the item, and opening the copied calculation quantity template on line through an online form editing module so as to facilitate export and copy.
7) Entering an engineering calculation amount engineering amount list module, automatically generating a directory tree of the project and the mark segments by the system in a recursion mode, clicking one mark segment, automatically calculating the data by the data center, summarizing according to all sub-items contained in mark segment pile numbers, writing a calculation result into a copied engineering amount list template of the project, and opening on line through an online form editing module to facilitate export and copy.
8) Entering an engineering calculation amount engineering amount detailed list module, automatically generating a directory tree of the project and the mark segments by the system in a recursion mode, clicking one mark segment, automatically calculating the data by the data center, summarizing according to all sub-items contained in mark segment pile numbers, writing a calculation result into a copied engineering amount detailed list template of the project, and opening the template on line through an online form editing module to facilitate exporting and copying. And provides a data pushing function, and pushes the data to the cost management system through the data interface service.
Wherein the execution process of the automatic calculation of the data comprises the following steps:
1) the data center reads the stored project engineering materials, project projects, formulas and reported values.
2) And the data center writes the read project engineering materials, project projects, formulas and filling values into a blank Excel table automatically built by the system, rereads the execution result of the Excel formula, and outputs the result to the front-end interactive system.
Formula modification data item modification execution process:
1) entering an engineering calculation quantity value management module, clicking one item in the item tree, and modifying and storing the listed formula and data item.
2) The data center writes new formulas and data items, and when automatic calculation of data is performed, calculation is performed according to the new formulas and data items.
This patent the system have following advantage and beneficial effect:
1. project managers only need to manage the templates, the related formulas and the numerical terms of the projects, and do not need to communicate and issue related materials to designers repeatedly. 2. The designer only needs to fill in the related numerical values of the subentries and does not need to care about the calculation formulas and calculation results of the subentries. 3. The items are not interfered with each other, and the modified formula and the data items are only effective in the item. This patent liberates project management personnel and project design personnel from a large amount of complicated calculations calculation and communication, has practiced thrift a large amount of time cost and human cost, because the computational process is carried out by the computer simultaneously, has guaranteed the accuracy of computational result, provides reliable guarantee for the result of engineering calculations.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (4)

1. A road engineering cooperative computation information management system based on a custom formula; it is characterized in that;
the system comprises: the system comprises a data processing center, a front-end interactive system, an online form editing module and a data interface service;
the data processing center provides data interaction for a data interaction service, provides data interaction for a front-end interaction system, meets the requirement of database writing and reading, and provides data support for a data interface;
the front-end interactive system is an engineering computation system man-machine interactive system accessed by a user through a browser;
the online form editing module is an online Excel editing module accessed through a browser;
the data interface service is a standard API response service provided by the server side.
2. The road engineering collaborative computation amount information management system based on the custom formula according to claim 1; it is characterized in that; the system executes the following processes;
1) accessing the engineering calculation system, inputting relevant information of projects, inputting section information (including section pile numbers), and inputting relevant information (including pile number information and later used for calculation) of roads, bridges, tunnels and the like (called sub-items after roads, bridges, tunnels and the like); uploading the standard calculation amount template of the enterprise;
2) entering an engineering computation quantity value management module, automatically generating a project tree by the system, clicking one project, and automatically copying an enterprise standard computation quantity template by the system to generate a project computation quantity template of the project;
3) the system automatically reads the engineering materials, the engineering projects, the related formulas and the related numerical values in the project computation amount template and writes the engineering materials, the engineering projects, the related formulas and the related numerical values into a data center;
4) entering an engineering calculation quantity value filling module, wherein the system automatically generates a directory tree of the project and the sub-items in a recursion manner, clicks one of the sub-items, and reads the engineering material and the project information of the project from the data center to regenerate the data related to the sub-items;
5) filling sub-item calculation amount filling values according to engineering materials and projects;
6) entering an engineering calculation quantity engineering quantity table module, wherein the system automatically generates a directory tree of the item and the sub-items in a recursion manner, clicking one of the sub-items, automatically calculating the data by the data center, writing a calculation result into a copied calculation quantity template of the item, and opening the calculation quantity template on line through an online form editing module so as to facilitate export and copy;
7) entering an engineering calculation amount engineering quantity list module, wherein the system automatically generates a directory tree of the project and the mark segments in a recursion manner, clicking one mark segment, automatically calculating the data by the data center, summarizing according to all sub-items contained in mark segment pile numbers, writing a calculation result into a copied engineering quantity list template of the project, and opening online through an online form editing module to facilitate export and copy;
8) entering an engineering calculation amount engineering quantity detailed list module, wherein the system automatically generates a directory tree of the project and the mark segments in a recursion manner, clicking one mark segment, automatically calculating the data by the data center, summarizing according to all sub-items contained in mark segment pile numbers, writing a calculation result into a copied engineering quantity detailed list template of the project, and opening the template on line through an online form editing module so as to facilitate export and copy;
and provides a data pushing function, and pushes the data to the cost management system through the data interface service.
3. The road engineering collaborative computation information management system based on the custom formula according to claim 1; it is characterized in that; wherein the execution process of the automatic calculation of the data comprises the following steps:
1) the data center reads the stored project engineering materials, project projects, formulas and reported values;
2) and the data center writes the read project engineering materials, project projects, formulas and filling values into a blank Excel table automatically built by the system, rereads the execution result of the Excel formula, and outputs the result to the front-end interactive system.
4. The road engineering collaborative computation information management system based on the custom formula according to claim 1; it is characterized in that; a formula modification data item modification execution process;
1) entering an engineering calculation quantity value management module, clicking one item in the item tree, and modifying and storing the listed formula and data item;
2) the data center writes new formulas and data items, and when automatic calculation of data is performed, calculation is performed according to the new formulas and data items.
CN202010877554.5A 2020-08-27 2020-08-27 Highway engineering collaborative computation amount information management system based on custom formula Pending CN112000724A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010877554.5A CN112000724A (en) 2020-08-27 2020-08-27 Highway engineering collaborative computation amount information management system based on custom formula

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010877554.5A CN112000724A (en) 2020-08-27 2020-08-27 Highway engineering collaborative computation amount information management system based on custom formula

Publications (1)

Publication Number Publication Date
CN112000724A true CN112000724A (en) 2020-11-27

Family

ID=73471945

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010877554.5A Pending CN112000724A (en) 2020-08-27 2020-08-27 Highway engineering collaborative computation amount information management system based on custom formula

Country Status (1)

Country Link
CN (1) CN112000724A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113626927A (en) * 2021-08-23 2021-11-09 四川公路桥梁建设集团有限公司 Intelligent reinforcing steel bar laying system based on three-dimensional digitization
CN114971597A (en) * 2022-07-29 2022-08-30 浙江小塔塔峰软件技术有限公司 Road cost calculation system and method based on BIM calculation amount and metering payment

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102063306A (en) * 2011-01-06 2011-05-18 夏春秋 Technical implementation method for application development through electronic form
CN102819774A (en) * 2011-06-09 2012-12-12 上海市第七建筑有限公司 Project cost management system and architecture thereof
CN103136595A (en) * 2011-11-29 2013-06-05 北京建龙重工集团有限公司 On-line management method for project budget generation by material and labor cost analysis
CN103136626A (en) * 2011-11-29 2013-06-05 北京建龙重工集团有限公司 On-line management method for engineering project
CN105335905A (en) * 2015-11-24 2016-02-17 广州拓欧信息技术有限公司 Building engineering computation and evaluation system and method
CN109118123A (en) * 2018-09-20 2019-01-01 长江勘测规划设计研究有限责任公司 Construction for Hydroelectric Project performance rating BIM management method
CN109165919A (en) * 2018-08-10 2019-01-08 深圳云联万企科技有限公司 A kind of engineering list workout system
CN109409634A (en) * 2018-08-23 2019-03-01 国网天津市电力公司 A method of the metering of Grid Construction Project project amount is carried out based on project management APP
CN109784681A (en) * 2018-12-26 2019-05-21 中国大唐集团科学技术研究院有限公司 Power engineering project investment management system

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102063306A (en) * 2011-01-06 2011-05-18 夏春秋 Technical implementation method for application development through electronic form
CN102819774A (en) * 2011-06-09 2012-12-12 上海市第七建筑有限公司 Project cost management system and architecture thereof
CN103136595A (en) * 2011-11-29 2013-06-05 北京建龙重工集团有限公司 On-line management method for project budget generation by material and labor cost analysis
CN103136626A (en) * 2011-11-29 2013-06-05 北京建龙重工集团有限公司 On-line management method for engineering project
CN105335905A (en) * 2015-11-24 2016-02-17 广州拓欧信息技术有限公司 Building engineering computation and evaluation system and method
CN109165919A (en) * 2018-08-10 2019-01-08 深圳云联万企科技有限公司 A kind of engineering list workout system
CN109409634A (en) * 2018-08-23 2019-03-01 国网天津市电力公司 A method of the metering of Grid Construction Project project amount is carried out based on project management APP
CN109118123A (en) * 2018-09-20 2019-01-01 长江勘测规划设计研究有限责任公司 Construction for Hydroelectric Project performance rating BIM management method
CN109784681A (en) * 2018-12-26 2019-05-21 中国大唐集团科学技术研究院有限公司 Power engineering project investment management system

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113626927A (en) * 2021-08-23 2021-11-09 四川公路桥梁建设集团有限公司 Intelligent reinforcing steel bar laying system based on three-dimensional digitization
CN114971597A (en) * 2022-07-29 2022-08-30 浙江小塔塔峰软件技术有限公司 Road cost calculation system and method based on BIM calculation amount and metering payment
CN114971597B (en) * 2022-07-29 2022-12-06 浙江小塔塔峰软件技术有限公司 BIM-based calculated amount and metering payment road cost calculation system and method

Similar Documents

Publication Publication Date Title
Blacker et al. CUBIT geometry and mesh generation toolkit 15.1 user documentation
Codsi et al. GEMPACK: General-purpose software for applied general equilibrium and other economic modellers
Ardis et al. Software product lines: a case study
US7363578B2 (en) Method and apparatus for mapping a data model to a user interface model
CN106874066A (en) A kind of virtual machine migration method and device, electronic equipment
CN112000724A (en) Highway engineering collaborative computation amount information management system based on custom formula
US20070083543A1 (en) XML schema template builder
EP1618488A2 (en) System and method in a data table for managing insertion operations in recursive scalable template instances
Estublier et al. Three dimensional versioning
US8595610B2 (en) Method, software and computer system for manipulating aggregated data
CN112764743B (en) Method for automatically generating software based on data model drive
CN105653255A (en) Method arranging report template to automatically generate report files in office frame
CN101916267B (en) Intelligent spatial data object modeling method applied to management of spatial data resource of road system
CN110414926A (en) Account management method, device and computer readable storage medium
CN115840567A (en) Application editing method and related equipment
CN106951593B (en) Method and device for generating configuration file of protection measurement and control device
CN103903085A (en) Method and device for isolating report application scene
US20060206497A1 (en) System and method in a data table for creating recursive scalable template instances
CN114895875B (en) Zero-code visual information system metadata production application method and system
CN103345485A (en) Method and system for automatic generation of mainframe platform dynamic reports
CN114896655A (en) Method, device, equipment and medium for determining component calculated amount in antique building project
US20060026522A1 (en) Method and apparatus for revising data models and maps by example
CN113906409A (en) Row level worksheet security
CN106933544A (en) Declare table generating method and system
EP1618490A2 (en) System and method in a data table for exporting and importing recursive scalable templates

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination