CN117391332A - Engineering quantity calculation list hanging method, device, computer equipment and storage medium - Google Patents
Engineering quantity calculation list hanging method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN117391332A CN117391332A CN202311152904.1A CN202311152904A CN117391332A CN 117391332 A CN117391332 A CN 117391332A CN 202311152904 A CN202311152904 A CN 202311152904A CN 117391332 A CN117391332 A CN 117391332A
- Authority
- CN
- China
- Prior art keywords
- engineering quantity
- engineering
- calculated
- filling area
- calculation
- 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.)
- Granted
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 166
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000013461 design Methods 0.000 claims description 92
- 238000010276 construction Methods 0.000 claims description 55
- 238000004590 computer program Methods 0.000 claims description 14
- 238000012552 review Methods 0.000 claims description 14
- 238000012937 correction Methods 0.000 claims description 2
- 230000000694 effects Effects 0.000 abstract description 6
- 230000006870 function Effects 0.000 description 5
- 230000001105 regulatory effect Effects 0.000 description 3
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000002131 composite material Substances 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06311—Scheduling, planning or task assignment for a person or group
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0633—Workflow analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- Data Mining & Analysis (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application relates to the technical field of engineering quantity calculation, in particular to an engineering quantity calculation list hanging method, an engineering quantity calculation list hanging device, computer equipment and a storage medium, wherein the engineering quantity calculation list hanging method comprises the following steps: acquiring an engineering quantity filling area from a work quantity list to be calculated, and acquiring engineering quantity categories to be calculated and parameters to be calculated corresponding to each engineering quantity category to be calculated from the engineering quantity filling area; inputting parameters to be calculated into a preset engineering quantity calculation model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into an engineering quantity filling area according to a filling area mark; the method comprises the steps of obtaining actual engineering quantity data, splitting the actual engineering quantity according to the engineering quantity category to be calculated to obtain the actual engineering quantity category and corresponding category data, and inputting the category data into a work quantity list to be checked according to an engineering quantity filling area to obtain an engineering quantity list. The method and the device have the effect of improving the efficiency of engineering quantity calculation.
Description
Technical Field
The present invention relates to the field of engineering quantity computing technologies, and in particular, to a method, an apparatus, a computer device, and a storage medium for hooking an engineering quantity computing list.
Background
Currently, in the engineering quantity calculating method, engineering quantity calculation and list hanging summarization are mainly performed through an Excel table or other tools. For example, when an Excel form is used for summarizing, due to the fact that a large number of Excel formulas and functions are adopted, and the capability of related personnel is uneven when the form is processed, the problems that the formula setting is wrong, the acquired data are inaccurate and the like exist, and because each project is specially provided with a calculation formula, the workload is large, the popularization and use difficulty is high, the data review difficulty is high, and the engineering quantity calculation and the list hooking function cannot be completed quickly and efficiently.
Disclosure of Invention
In order to improve the efficiency of engineering quantity calculation, the application provides an engineering quantity calculation list hooking method, an engineering quantity calculation list hooking device, computer equipment and a storage medium.
The first object of the present invention is achieved by the following technical solutions:
the engineering quantity calculation list hanging method is characterized by comprising the following steps of:
acquiring a construction design drawing, and acquiring a workload list to be checked according to the construction design drawing;
acquiring an engineering quantity filling area from the to-be-calculated workload list, and acquiring to-be-calculated engineering quantity categories and to-be-calculated parameters corresponding to each to-be-calculated engineering quantity category from the engineering quantity filling area, wherein the engineering quantity filling area comprises a filling area identifier;
inputting the parameters to be calculated into a preset engineering quantity calculation model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into the engineering quantity filling area according to the filling area identification;
the actual engineering quantity data are obtained, the actual engineering quantity is split according to the engineering quantity category to be calculated, the actual engineering quantity category and the corresponding category data are obtained, the category data are input into the work quantity list to be checked according to the engineering quantity filling area, and the engineering quantity list is obtained.
Through adopting the technical scheme, through setting corresponding engineering quantity calculation models in advance, the formula of engineering quantity calculation can be unified and regulated, when engineering quantity calculation is required, a corresponding engineering quantity list to be calculated is generated according to a corresponding construction design drawing, so that corresponding engineering quantity data can be automatically calculated according to engineering quantity category to be calculated, the corresponding engineering quantity data are input into the engineering quantity filling area, the problems of complicated workload and easy error caused by manual formula setting are reduced, and simultaneously, after the actual engineering quantity is obtained, the corresponding data can be automatically filled into the list according to the engineering quantity category to be calculated, thereby realizing the automatic list hooking effect, having simple and convenient operation and strong universality, effectively improving the engineering quantity calculation efficiency and accuracy, and improving the list hooking accuracy.
The present application may be further configured in a preferred example to: before the parameters to be calculated are input into a preset engineering quantity calculation model, corresponding engineering quantity information is calculated according to the corresponding engineering quantity category to be calculated, and the engineering quantity information is input into the engineering quantity filling area according to the filling area identification, the engineering quantity calculation list hanging method further comprises the following steps:
acquiring a preset engineering quantity calculation template, acquiring a corresponding engineering quantity calculation formula according to the engineering quantity calculation template, and generating an engineering quantity initial model according to the engineering quantity calculation formula;
and identifying engineering design feature data from the construction design drawing, and modifying the engineering quantity initial model according to the engineering design feature data to obtain the engineering quantity calculation model.
By adopting the technical scheme, the corresponding engineering quantity initial model is generated according to the preset engineering quantity calculation template, the standard engineering quantity calculation model can be specified to be the engineering quantity initial model, after the construction design drawing is obtained, the engineering quantity calculation formula is adjusted according to engineering design feature data of each construction design drawing, so that the engineering quantity calculation model can be more matched with the construction design drawing, and calculation accuracy is further improved.
The present application may be further configured in a preferred example to: the engineering design feature data is identified from the construction design drawing, the engineering quantity initial model is modified according to the engineering design feature data, and the engineering quantity calculation model is obtained, specifically comprising:
acquiring corresponding design party data according to the construction design drawing, and acquiring a corresponding engineering quantity accounting formula according to the design party data;
and comparing the engineering design characteristic data according to the engineering quantity accounting formula and the corresponding engineering quantity calculating formula.
By adopting the technical scheme, as the design party of each drawing has a corresponding formula for calculating the engineering quantity, the calculated engineering quantity can accord with the conception of the design drawing of the design party by comparing the engineering quantity accounting formula with the engineering quantity calculating formula, and the accuracy is further improved.
The present application may be further configured in a preferred example to: inputting the parameter to be calculated into a preset engineering quantity calculation model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into the engineering quantity filling area according to the filling area identification, wherein the method specifically comprises the following steps of:
inputting the engineering quantity category to be calculated corresponding to the parameter to be calculated into the engineering quantity calculation model to obtain a corresponding numerical calculation formula;
and calculating the corresponding engineering quantity information through the numerical calculation formula, and inputting the engineering quantity information into the engineering quantity filling area according to the filling area identifier corresponding to the engineering quantity category to be calculated.
By adopting the technical scheme, the corresponding numerical calculation formula can be obtained by inputting the category of the formula to be calculated into the engineering quantity calculation model, and then the corresponding engineering quantity is automatically calculated according to the category of the engineering quantity to be calculated through the parameter to be calculated, and then the engineering quantity filling area is automatically filled, and further the calculation of the engineering quantity can be automatically completed.
The present application may be further configured in a preferred example to: the method for hanging the engineering quantity calculation list further comprises the steps of:
acquiring a review data filling area corresponding to each engineering quantity filling area, and acquiring a preset engineering quantity review formula from the review data filling area;
and carrying out difference calculation on the engineering quantity information and the actual engineering quantity according to the engineering quantity rechecking formula, and inputting a difference calculation result into the rechecking data filling area.
By adopting the technical scheme, the engineering quantity can be rapidly calculated by setting the composite data filling area and each engineering quantity rechecking formula corresponding to the data filling area, so that whether the engineering quantity is accurately calculated or not can be judged according to the difference calculation result, and the subsequent attribution analysis is realized.
The second object of the present invention is achieved by the following technical solutions:
an engineering quantity calculation bill hooking device, the engineering quantity calculation bill hooking device comprising:
the list generation module is used for acquiring a construction design drawing and acquiring a workload list to be checked according to the construction design drawing;
the parameter acquisition module is used for acquiring an engineering quantity filling area from the to-be-calculated workload list, and acquiring to-be-calculated engineering quantity categories and to-be-calculated parameters corresponding to each to-be-calculated engineering quantity category from the engineering quantity filling area, wherein the engineering quantity filling area comprises a filling area identifier;
the engineering quantity calculating module is used for inputting the parameters to be calculated into a preset engineering quantity calculating model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into the engineering quantity filling area according to the filling area identification;
the engineering quantity accounting module is used for acquiring actual engineering quantity data, splitting the actual engineering quantity according to the engineering quantity category to be calculated to obtain an actual engineering quantity category and corresponding category data, and inputting the category data into the engineering quantity list to be accounted according to the engineering quantity filling area to obtain an engineering quantity list.
Through adopting the technical scheme, through setting corresponding engineering quantity calculation models in advance, the formula of engineering quantity calculation can be unified and regulated, when engineering quantity calculation is required, a corresponding engineering quantity list to be calculated is generated according to a corresponding construction design drawing, so that corresponding engineering quantity data can be automatically calculated according to engineering quantity category to be calculated, the corresponding engineering quantity data are input into the engineering quantity filling area, the problems of complicated workload and easy error caused by manual formula setting are reduced, and simultaneously, after the actual engineering quantity is obtained, the corresponding data can be automatically filled into the list according to the engineering quantity category to be calculated, thereby realizing the automatic list hooking effect, having simple and convenient operation and strong universality, effectively improving the engineering quantity calculation efficiency and accuracy, and improving the list hooking accuracy.
The third object of the present application is achieved by the following technical solutions:
a computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the engineering quantity calculation inventory hooking method described above when the computer program is executed.
The fourth object of the present application is achieved by the following technical solutions:
a computer readable storage medium storing a computer program which, when executed by a processor, performs the steps of the engineering quantity calculation list hooking method described above.
In summary, the present application includes at least one of the following beneficial technical effects:
1. the method has the advantages that through presetting a corresponding engineering quantity calculation model, the formula of engineering quantity calculation can be unified, when the engineering quantity is required to be calculated, a corresponding engineering quantity list to be calculated is generated according to a corresponding construction design drawing, so that corresponding engineering quantity data can be automatically calculated according to engineering quantity category to be calculated, and is input into an engineering quantity filling area, the problems of complicated workload and easy error caused by manual formula setting are reduced, and meanwhile, after the actual engineering quantity is obtained, the corresponding data can be automatically filled into the list according to the engineering quantity category to be calculated, thereby realizing the automatic list hooking effect, being simple and convenient to operate, having strong universality, effectively improving the engineering quantity calculation efficiency and accuracy, and improving the list hooking accuracy;
2. because the design party of each drawing has a corresponding formula for calculating the engineering quantity, the calculated engineering quantity can accord with the conception of the design drawing of the design party by comparing the engineering quantity accounting formula with the engineering quantity calculating formula, thereby improving the accuracy;
3. the category of the formula to be calculated is input into the engineering quantity calculation model, so that a corresponding numerical calculation formula can be obtained, the corresponding engineering quantity is automatically calculated according to the category of the engineering quantity to be calculated through the parameter to be calculated, the engineering quantity filling area is automatically filled, and the calculation of the engineering quantity can be automatically completed.
Drawings
FIG. 1 is a flow chart of a method for hooking an industrial scale calculation list according to one embodiment of the present application;
FIG. 2 is a flow chart of another implementation of a method for hooking an engineering calculation list in an embodiment of the present application;
FIG. 3 is a flowchart showing a method step S30 of hooking an engineering calculation list in an embodiment of the present application;
FIG. 4 is a flowchart showing a method step S40 of hooking an engineering calculation list in an embodiment of the present application;
FIG. 5 is a flowchart of another implementation of a method for hooking an engineering calculation list in an embodiment of the present application;
FIG. 6 is a schematic block diagram of an example of an equipment list of process volume calculations;
fig. 7 is a schematic view of an apparatus in an embodiment of the present application.
Detailed Description
The present application is described in further detail below with reference to the accompanying drawings.
In one embodiment, as shown in fig. 1, the application discloses a method for hooking and counting engineering quantity list, which specifically includes the following steps:
s10: and acquiring a construction design drawing, and acquiring a work load list to be checked according to the construction design drawing.
In this embodiment, the construction design drawing refers to a construction drawing designed by a corresponding construction drawing designer. The work load list to be checked refers to a basic data table of the statistical engineering quantity.
Specifically, when the engineering quantity is required to be calculated, a construction design drawing corresponding to the engineering is firstly obtained, and an Excel table of the to-be-calculated workload list is generated according to a construction scheme in the construction design drawing.
S20: and acquiring an engineering quantity filling area from the to-be-calculated workload list, and acquiring to-be-calculated engineering quantity categories and to-be-calculated parameters corresponding to each to-be-calculated engineering quantity category from the engineering quantity filling area, wherein the engineering quantity filling area comprises a filling area identifier.
In this embodiment, the engineering quantity filling area refers to an area for filling in the corresponding engineering quantity. The category of the engineering quantity to be calculated refers to each list sub-number in the construction project. The filling area identifier refers to an identifier for distinguishing the filling area of each engineering quantity, and for an Excel form, the filling area identifier can be expressed in the form of a cell number.
Specifically, the engineering quantity filling area is set on one side of a cell column where each list sub-number is located in an Excel form of the workload list to be checked, so that the engineering quantity calculated by each specific list sub-number, namely the engineering quantity category to be calculated, is filled in the corresponding engineering quantity filling area.
Further, according to the engineering quantity category to be calculated of each engineering quantity filling area, corresponding construction parameters are obtained and used as parameters to be calculated.
S30: inputting parameters to be calculated into a preset engineering quantity calculation model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into an engineering quantity filling area according to the filling area identification.
In the present embodiment, the engineering amount calculation model refers to a model for calculating the engineering amount of the construction project.
Specifically, the engineering quantity calculation model is obtained by a mode of preparing a calculation template for calculating the engineering quantity into a macro file of Excel in advance, the parameters to be calculated corresponding to the construction design drawing are input into the engineering quantity calculation model, and then engineering quantity information of each engineering quantity category to be calculated is calculated through the calculation template in the macro file and is filled into a corresponding engineering quantity filling area.
S40: the method comprises the steps of obtaining actual engineering quantity data, splitting the actual engineering quantity according to the engineering quantity category to be calculated to obtain the actual engineering quantity category and corresponding category data, and inputting the category data into a work quantity list to be checked according to an engineering quantity filling area to obtain an engineering quantity list.
Specifically, after the corresponding actual engineering quantity is obtained through real-time statistics according to a construction site, splitting the actual engineering quantity according to the engineering quantity category to be calculated to obtain category data corresponding to each category, namely the actual engineering quantity of each list sub-number, and inputting the actual engineering quantity obtained through splitting to a position corresponding to the work quantity list to be calculated to obtain an engineering quantity list.
In this embodiment, by presetting a corresponding engineering quantity calculation model, the formula of engineering quantity calculation can be unified and regulated, when engineering quantity is required to be calculated, a corresponding engineering quantity list to be calculated is generated according to a corresponding construction design drawing, so that corresponding engineering quantity data can be automatically calculated according to engineering quantity category to be calculated, and is input into the engineering quantity filling area, the problems of complicated workload and easy error caused by manual formula setting are reduced, and simultaneously, after actual engineering quantity is obtained, the corresponding data can be automatically filled into the list according to engineering quantity category to be calculated, thereby realizing the effect of automatic list hooking.
In one embodiment, as shown in fig. 2, before step S30, the method for hooking the engineering quantity calculation list further includes:
s301: obtaining a preset engineering quantity calculation template, obtaining a corresponding engineering quantity calculation formula according to the engineering quantity calculation template, and generating an engineering quantity initial model according to the engineering quantity calculation formula.
In the present embodiment, the engineering amount calculation template refers to a general calculation formula in which engineering amounts of respective categories are calculated is recorded.
Specifically, each project category related in the construction process is counted, then the engineering quantity calculation formula corresponding to each category is counted, the engineering quantity calculation template is obtained through counting, and then the generated engineering quantity calculation target is built in an Excel macro file, so that the engineering quantity initial model is obtained.
S302: and identifying engineering design characteristic data from the construction design drawing, and modifying the engineering quantity initial model according to the engineering design characteristic data to obtain an engineering quantity calculation model.
Specifically, the engineering design feature data refers to content adaptively adjusted according to actual conditions when the construction design drawing is designed.
Specifically, when the construction design drawing is designed each time, the standard drawing mode of the drawing is adjusted according to the actual situation, so that the construction design drawing is obtained, further, an adjusted part is obtained from the construction design drawing and is used as engineering design feature data, and after the part corresponding to the engineering quantity initial model is adjusted according to the engineering design feature data, the engineering quantity calculation model is obtained.
In one embodiment, as shown in fig. 3, in step S30, engineering design feature data is identified from a construction design drawing, and an engineering quantity initial model is modified according to the engineering design feature data to obtain an engineering quantity calculation model, which specifically includes:
s31: and obtaining corresponding design party data according to the construction design drawing, and obtaining a corresponding engineering quantity accounting formula according to the design party data.
Specifically, a design unit for actually designing the construction design drawing is obtained as the designer data, and a calculation formula for calculating each engineering quantity by the design unit stored in advance is obtained as the engineering quantity calculation formula.
S32: and comparing the engineering design characteristic data according to the engineering quantity accounting formula and the corresponding engineering quantity calculating formula.
Specifically, when designing the engineering quantity accounting formula, each design unit adjusts the standard formula according to the actual situation, for example, a corresponding coefficient or corresponding adjustment is added in the standard formula, so that the engineering quantity accounting formula and the engineering quantity computing formula for computing the same engineering quantity are compared, and the compared difference is used as the engineering design characteristic data.
In one embodiment, as shown in fig. 4, in step S40, parameters to be calculated are input into a preset engineering quantity calculation model, corresponding engineering quantity information is calculated according to a corresponding engineering quantity category to be calculated, and the engineering quantity information is input into an engineering quantity filling area according to a filling area identifier, which specifically includes:
s41: inputting the engineering quantity category to be calculated corresponding to the parameter to be calculated into an engineering quantity calculation model, and obtaining a corresponding numerical calculation formula.
Specifically, according to the category of the engineering quantity to be calculated, a formula for calculating the corresponding engineering quantity, namely a numerical calculation formula, is obtained from an engineering quantity calculation template.
S42: and calculating corresponding engineering quantity information through a numerical calculation formula, and inputting the engineering quantity information into an engineering quantity filling area according to a filling area identifier corresponding to the engineering quantity category to be calculated.
Specifically, the corresponding engineering quantity information is calculated by the parameters to be calculated through the numerical calculation formula, and the calculated engineering quantity information is input into an engineering quantity filling area corresponding to the filling area identification of the engineering quantity category to be calculated according to the related Excel function. When in actual operation, an operator only needs to input a to-be-calculated workload list into an engineering calculation model, the engineering calculation model writes a corresponding numerical calculation formula into a corresponding workload filling area according to a list letter number in the to-be-calculated workload list, and then the corresponding workload information is obtained through calculation and then is input into the workload filling area.
In one embodiment, as shown in fig. 5, after step S40, the engineering quantity calculation list hooking method further includes:
s50: and acquiring a review data filling area corresponding to each engineering quantity filling area, and acquiring a preset engineering quantity review formula from the review data filling area.
Specifically, a corresponding check data filling area is set at one side of each engineering quantity filling area and is used for filling the coincidence condition of the engineering quantity, and a corresponding engineering quantity check formula is set in the check data filling area, wherein the engineering quantity check formula can be used for calculating a difference value or increasing a related coefficient or error range according to the actual condition.
S60: and carrying out difference calculation on the engineering quantity information and the actual engineering quantity according to the engineering quantity rechecking formula, and inputting a difference calculation result into a rechecking data filling area.
Specifically, after the actual engineering quantity is obtained, the corresponding engineering quantity information and the actual engineering quantity are substituted into the corresponding engineering quantity coincidence formula, and the difference calculation result is input into the rechecking data filling area.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic of each process, and should not limit the implementation process of the embodiment of the present application in any way.
In one embodiment, an engineering quantity calculation list hooking device is provided, and the engineering quantity calculation list hooking device corresponds to the engineering quantity calculation list hooking method in the embodiment one by one. As shown in fig. 6, the engineering quantity calculation list hooking device includes a list generation module parameter acquisition module, an engineering quantity calculation module, and an engineering quantity calculation module. The functional modules are described in detail as follows:
the list generation module is used for acquiring a construction design drawing and acquiring a workload list to be checked according to the construction design drawing;
the parameter acquisition module is used for acquiring an engineering quantity filling area from the work quantity list to be checked, and acquiring engineering quantity types to be calculated and parameters to be calculated corresponding to each engineering quantity type to be calculated from the engineering quantity filling area, wherein the engineering quantity filling area comprises a filling area identifier;
the engineering quantity calculating module is used for inputting parameters to be calculated into a preset engineering quantity calculating model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into an engineering quantity filling area according to the filling area identification;
the engineering quantity accounting module is used for acquiring actual engineering quantity data, splitting the actual engineering quantity according to the engineering quantity category to be calculated to obtain the actual engineering quantity category and corresponding category data, and inputting the category data into the work quantity list to be accounted according to the engineering quantity filling area to obtain the engineering quantity list.
Optionally, the engineering quantity calculation list hooking device further includes:
the initial model acquisition module is used for acquiring a preset engineering quantity calculation template, acquiring a corresponding engineering quantity calculation formula according to the engineering quantity calculation template, and generating an engineering quantity initial model according to the engineering quantity calculation formula;
the calculation model acquisition module is used for identifying engineering design feature data from the construction design drawing, and modifying the engineering quantity initial model according to the engineering design feature data to obtain an engineering quantity calculation model.
Optionally, the engineering calculation module includes:
the design data acquisition sub-module is used for acquiring corresponding design party data according to a construction design drawing and acquiring a corresponding engineering quantity accounting formula according to the design party data;
and the formula correction sub-module is used for comparing the engineering design characteristic data according to the engineering quantity calculation formula and the corresponding engineering quantity calculation formula.
Optionally, the engineering quantity accounting module includes:
the parameter input sub-module is used for inputting the engineering quantity category to be calculated corresponding to the parameter to be calculated into the engineering quantity calculation model to obtain a corresponding numerical calculation formula;
the engineering quantity core operator module is used for calculating corresponding engineering quantity information through a numerical calculation formula, and inputting the engineering quantity information into an engineering quantity filling area according to a filling area identifier corresponding to the engineering quantity category to be calculated.
Optionally, the engineering calculation bill hanging device further includes:
the review formula acquisition module is used for acquiring a review data filling area corresponding to each engineering quantity filling area and acquiring a preset engineering quantity review formula from the review data filling area;
and the data rechecking module is used for carrying out difference calculation on the engineering quantity information and the actual engineering quantity according to the engineering quantity rechecking formula, and inputting a difference calculation result into a rechecking data filling area.
The construction amount calculation list hooking device may be specifically defined by referring to the above definition of the construction amount calculation list hooking method, and will not be described herein. The modules in the engineering quantity calculation list hooking device can be realized in whole or in part by software, hardware and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 7. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program when executed by a processor implements an engineering quantity calculation list hooking method.
In one embodiment, a computer device is provided comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the steps of when executing the computer program:
acquiring a construction design drawing, and acquiring a workload list to be checked according to the construction design drawing;
acquiring an engineering quantity filling area from a work quantity list to be calculated, and acquiring engineering quantity types to be calculated and parameters to be calculated corresponding to each engineering quantity type to be calculated from the engineering quantity filling area, wherein the engineering quantity filling area comprises a filling area identifier;
inputting parameters to be calculated into a preset engineering quantity calculation model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into an engineering quantity filling area according to a filling area mark;
the method comprises the steps of obtaining actual engineering quantity data, splitting the actual engineering quantity according to the engineering quantity category to be calculated to obtain the actual engineering quantity category and corresponding category data, and inputting the category data into a work quantity list to be checked according to an engineering quantity filling area to obtain an engineering quantity list.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
acquiring a construction design drawing, and acquiring a workload list to be checked according to the construction design drawing;
acquiring an engineering quantity filling area from a work quantity list to be calculated, and acquiring engineering quantity types to be calculated and parameters to be calculated corresponding to each engineering quantity type to be calculated from the engineering quantity filling area, wherein the engineering quantity filling area comprises a filling area identifier;
inputting parameters to be calculated into a preset engineering quantity calculation model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into an engineering quantity filling area according to a filling area mark;
the method comprises the steps of obtaining actual engineering quantity data, splitting the actual engineering quantity according to the engineering quantity category to be calculated to obtain the actual engineering quantity category and corresponding category data, and inputting the category data into a work quantity list to be checked according to an engineering quantity filling area to obtain an engineering quantity list.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the various embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions.
The above embodiments are only for illustrating the technical solution of the present application, and are not limiting; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present application, and are intended to be included in the scope of the present application.
Claims (10)
1. The engineering quantity calculation list hanging method is characterized by comprising the following steps of:
acquiring a construction design drawing, and acquiring a workload list to be checked according to the construction design drawing;
acquiring an engineering quantity filling area from the to-be-calculated workload list, and acquiring to-be-calculated engineering quantity categories and to-be-calculated parameters corresponding to each to-be-calculated engineering quantity category from the engineering quantity filling area, wherein the engineering quantity filling area comprises a filling area identifier;
inputting the parameters to be calculated into a preset engineering quantity calculation model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into the engineering quantity filling area according to the filling area identification;
the actual engineering quantity data are obtained, the actual engineering quantity is split according to the engineering quantity category to be calculated, the actual engineering quantity category and the corresponding category data are obtained, the category data are input into the work quantity list to be checked according to the engineering quantity filling area, and the engineering quantity list is obtained.
2. The method according to claim 1, wherein before the parameter to be calculated is input into a preset engineering quantity calculation model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into the engineering quantity filling area according to the filling area identifier, the method further comprises:
acquiring a preset engineering quantity calculation template, acquiring a corresponding engineering quantity calculation formula according to the engineering quantity calculation template, and generating an engineering quantity initial model according to the engineering quantity calculation formula;
and identifying engineering design feature data from the construction design drawing, and modifying the engineering quantity initial model according to the engineering design feature data to obtain the engineering quantity calculation model.
3. The method for hooking an engineering quantity calculation list according to claim 2, wherein the engineering design feature data is identified from the construction design drawing, and the engineering quantity initial model is modified according to the engineering design feature data to obtain the engineering quantity calculation model, specifically comprising:
acquiring corresponding design party data according to the construction design drawing, and acquiring a corresponding engineering quantity accounting formula according to the design party data;
and comparing the engineering design characteristic data according to the engineering quantity accounting formula and the corresponding engineering quantity calculating formula.
4. The method for hooking up an engineering quantity calculation list according to claim 2 or 3, wherein the inputting the parameter to be calculated into a preset engineering quantity calculation model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into the engineering quantity filling area according to the filling area identifier specifically includes:
inputting the engineering quantity category to be calculated corresponding to the parameter to be calculated into the engineering quantity calculation model to obtain a corresponding numerical calculation formula;
and calculating the corresponding engineering quantity information through the numerical calculation formula, and inputting the engineering quantity information into the engineering quantity filling area according to the filling area identifier corresponding to the engineering quantity category to be calculated.
5. The method for hooking an engineering quantity calculation list according to claim 1, wherein after the actual engineering quantity data is obtained, the actual engineering quantity is split according to the engineering quantity category to be calculated to obtain an actual engineering quantity category and corresponding category data, the category data is input into the engineering quantity calculation list according to the engineering quantity filling area, and after the engineering quantity list is obtained, the engineering quantity calculation list hooking method further comprises:
acquiring a review data filling area corresponding to each engineering quantity filling area, and acquiring a preset engineering quantity review formula from the review data filling area;
and carrying out difference calculation on the engineering quantity information and the actual engineering quantity according to the engineering quantity rechecking formula, and inputting a difference calculation result into the rechecking data filling area.
6. An engineering quantity calculation bill hooking device, characterized in that the engineering quantity calculation bill hooking device comprises:
the list generation module is used for acquiring a construction design drawing and acquiring a workload list to be checked according to the construction design drawing;
the parameter acquisition module is used for acquiring an engineering quantity filling area from the to-be-calculated workload list, and acquiring to-be-calculated engineering quantity categories and to-be-calculated parameters corresponding to each to-be-calculated engineering quantity category from the engineering quantity filling area, wherein the engineering quantity filling area comprises a filling area identifier;
the engineering quantity calculating module is used for inputting the parameters to be calculated into a preset engineering quantity calculating model, calculating corresponding engineering quantity information according to the corresponding engineering quantity category to be calculated, and inputting the engineering quantity information into the engineering quantity filling area according to the filling area identification;
the engineering quantity accounting module is used for acquiring actual engineering quantity data, splitting the actual engineering quantity according to the engineering quantity category to be calculated to obtain an actual engineering quantity category and corresponding category data, and inputting the category data into the engineering quantity list to be accounted according to the engineering quantity filling area to obtain an engineering quantity list.
7. The engineering quantity calculation bill hooking apparatus according to claim 6, wherein the engineering quantity calculation bill hooking apparatus further comprises:
the initial model acquisition module is used for acquiring a preset engineering quantity calculation template, acquiring a corresponding engineering quantity calculation formula according to the engineering quantity calculation template, and generating an engineering quantity initial model according to the engineering quantity calculation formula;
and the calculation model acquisition module is used for identifying engineering design characteristic data from the construction design drawing, and modifying the engineering quantity initial model according to the engineering design characteristic data to obtain the engineering quantity calculation model.
8. The engineering quantity calculation bill hooking apparatus according to claim 7, wherein the engineering quantity calculation module includes:
the design data acquisition sub-module is used for acquiring corresponding design party data according to the construction design drawing and acquiring a corresponding engineering quantity accounting formula according to the design party data;
and the formula correction sub-module is used for comparing the engineering design characteristic data according to the engineering quantity calculation formula and the corresponding engineering quantity calculation formula.
9. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the engineering quantity calculation manifest hooking method according to any one of claims 1 to 5 when the computer program is executed.
10. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the steps of the engineering quantity calculation manifest hooking method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311152904.1A CN117391332B (en) | 2023-09-07 | 2023-09-07 | Engineering quantity calculation list hanging method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311152904.1A CN117391332B (en) | 2023-09-07 | 2023-09-07 | Engineering quantity calculation list hanging method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117391332A true CN117391332A (en) | 2024-01-12 |
| CN117391332B CN117391332B (en) | 2024-08-09 |
Family
ID=89469089
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311152904.1A Active CN117391332B (en) | 2023-09-07 | 2023-09-07 | Engineering quantity calculation list hanging method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117391332B (en) |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105160110A (en) * | 2015-09-11 | 2015-12-16 | 北京恒华伟业科技股份有限公司 | Generation method and device of engineering calculation sheet |
| CN107563828A (en) * | 2017-07-11 | 2018-01-09 | 北京海数宝科技有限公司 | Full statement of expense generation method, device, storage medium and computer equipment |
| 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 |
| CN111598729A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | Method for conveniently compiling settlement change list |
| CN111666087A (en) * | 2020-05-28 | 2020-09-15 | 平安医疗健康管理股份有限公司 | Operation rule updating method and device, computer system and readable storage medium |
| CN112541221A (en) * | 2020-12-25 | 2021-03-23 | 深圳高速工程顾问有限公司 | BIM-based engineering quantity inventory compiling method, system, equipment and storage medium |
| CN112966486A (en) * | 2021-03-17 | 2021-06-15 | 机械工业第九设计研究院有限公司 | Intelligent engineering quantity list generation method and device, terminal and storage medium |
| CN114648244A (en) * | 2022-04-06 | 2022-06-21 | 北京梦诚科技有限公司 | Design method and system of five-volume dynamic machine account |
| CN114724158A (en) * | 2022-04-21 | 2022-07-08 | 北京梦诚科技有限公司 | Engineering quantity auditing method and system, electronic equipment and storage medium |
| CN114741871A (en) * | 2022-04-07 | 2022-07-12 | 中国电建集团中南勘测设计研究院有限公司 | Automatic statistical calculation method, equipment and storage medium for highway tunnel engineering quantity |
| CN114943560A (en) * | 2022-06-08 | 2022-08-26 | 深圳市栋森工程项目管理有限公司 | Municipal road type project cost management method and system |
| CN114971597A (en) * | 2022-07-29 | 2022-08-30 | 浙江小塔塔峰软件技术有限公司 | Road cost calculation system and method based on BIM calculation amount and metering payment |
| CN115907876A (en) * | 2022-10-31 | 2023-04-04 | 中建三局科创产业发展有限公司 | Decoration project amount estimation method, system and storage medium |
| CN116167703A (en) * | 2021-11-24 | 2023-05-26 | 国网宁夏电力有限公司经济技术研究院 | Automatic calculation method, device, equipment and storage medium for power transmission line engineering |
| CN116403234A (en) * | 2022-11-24 | 2023-07-07 | 北京理工大学 | Automatic prediction method for building engineering structure calculation based on CAD drawing |
-
2023
- 2023-09-07 CN CN202311152904.1A patent/CN117391332B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105160110A (en) * | 2015-09-11 | 2015-12-16 | 北京恒华伟业科技股份有限公司 | Generation method and device of engineering calculation sheet |
| CN107563828A (en) * | 2017-07-11 | 2018-01-09 | 北京海数宝科技有限公司 | Full statement of expense generation method, device, storage medium and computer equipment |
| 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 |
| CN111598729A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | Method for conveniently compiling settlement change list |
| CN111666087A (en) * | 2020-05-28 | 2020-09-15 | 平安医疗健康管理股份有限公司 | Operation rule updating method and device, computer system and readable storage medium |
| CN112541221A (en) * | 2020-12-25 | 2021-03-23 | 深圳高速工程顾问有限公司 | BIM-based engineering quantity inventory compiling method, system, equipment and storage medium |
| CN112966486A (en) * | 2021-03-17 | 2021-06-15 | 机械工业第九设计研究院有限公司 | Intelligent engineering quantity list generation method and device, terminal and storage medium |
| CN116167703A (en) * | 2021-11-24 | 2023-05-26 | 国网宁夏电力有限公司经济技术研究院 | Automatic calculation method, device, equipment and storage medium for power transmission line engineering |
| CN114648244A (en) * | 2022-04-06 | 2022-06-21 | 北京梦诚科技有限公司 | Design method and system of five-volume dynamic machine account |
| CN114741871A (en) * | 2022-04-07 | 2022-07-12 | 中国电建集团中南勘测设计研究院有限公司 | Automatic statistical calculation method, equipment and storage medium for highway tunnel engineering quantity |
| CN114724158A (en) * | 2022-04-21 | 2022-07-08 | 北京梦诚科技有限公司 | Engineering quantity auditing method and system, electronic equipment and storage medium |
| CN114943560A (en) * | 2022-06-08 | 2022-08-26 | 深圳市栋森工程项目管理有限公司 | Municipal road type project cost management method and system |
| CN114971597A (en) * | 2022-07-29 | 2022-08-30 | 浙江小塔塔峰软件技术有限公司 | Road cost calculation system and method based on BIM calculation amount and metering payment |
| CN115907876A (en) * | 2022-10-31 | 2023-04-04 | 中建三局科创产业发展有限公司 | Decoration project amount estimation method, system and storage medium |
| CN116403234A (en) * | 2022-11-24 | 2023-07-07 | 北京理工大学 | Automatic prediction method for building engineering structure calculation based on CAD drawing |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117391332B (en) | 2024-08-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110309125B (en) | Data verification method, electronic device and storage medium | |
| CN111666491A (en) | Abnormal data query method and device, computer equipment and storage medium | |
| CN113127347B (en) | Interface testing method, device, equipment and readable storage medium | |
| CN111026460B (en) | Method and device for rapidly allocating points by using regional templates in configuration tool | |
| CN109740760B (en) | Text quality inspection automatic training method, electronic device and computer equipment | |
| CN112101584A (en) | Nuclear power station spare part systematic maintenance method, device, equipment and storage medium | |
| WO2019242113A1 (en) | Service data table filing correction method, device, computer equipment and storage medium | |
| CN110750443A (en) | Webpage testing method and device, computer equipment and storage medium | |
| CN112527286A (en) | Service code generation method and device, computer equipment and storage medium | |
| CN114185867A (en) | Method and device for confirming data consistency and electronic equipment | |
| CN110084476B (en) | Case adjustment method, device, computer equipment and storage medium | |
| CN117391332B (en) | Engineering quantity calculation list hanging method, device, computer equipment and storage medium | |
| CN111367754A (en) | Data monitoring method and device, computer equipment and storage medium | |
| CN117391306A (en) | Homeland space planning result examination method, device, equipment and storage medium | |
| CN109542947B (en) | Data statistical method, device, computer equipment and storage medium | |
| CN109710980B (en) | File auditing processing method, device, computer equipment and storage medium | |
| CN111401023A (en) | Report generation method and device, server and storage medium | |
| CN112085791A (en) | Automatic positioning method, device and equipment for construction design drawing and storage medium | |
| CN112527786B (en) | Data table partition newly-adding method and device, computer equipment and storage medium | |
| CN112988662A (en) | BIM-based project supervision information processing method, system, equipment and storage medium | |
| CN112214414A (en) | Coverage rate processing method, device, equipment and medium based on automatic test | |
| CN114996519B (en) | Data processing method, device, electronic equipment, storage medium and product | |
| CN112686752A (en) | Index value acquisition method and device, computer equipment and storage medium | |
| CN117291384B (en) | Project progress adjustment method, device, equipment and medium based on resource allocation | |
| CN111752786A (en) | Data storage method, data summarization method, equipment and medium in pressure test process |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |