CN117033399B - Method and system for managing engineering quantity change - Google Patents
Method and system for managing engineering quantity change Download PDFInfo
- Publication number
- CN117033399B CN117033399B CN202310897192.XA CN202310897192A CN117033399B CN 117033399 B CN117033399 B CN 117033399B CN 202310897192 A CN202310897192 A CN 202310897192A CN 117033399 B CN117033399 B CN 117033399B
- Authority
- CN
- China
- Prior art keywords
- change
- engineering
- amount
- list
- 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.)
- Active
Links
- 230000008859 change Effects 0.000 title claims abstract description 297
- 238000000034 method Methods 0.000 title claims abstract description 48
- 238000004364 calculation method Methods 0.000 claims abstract description 205
- 239000000463 material Substances 0.000 claims abstract description 85
- 238000004806 packaging method and process Methods 0.000 claims abstract description 23
- 230000002776 aggregation Effects 0.000 claims abstract description 9
- 238000004220 aggregation Methods 0.000 claims abstract description 9
- 238000004590 computer program Methods 0.000 claims description 11
- 238000012545 processing Methods 0.000 claims description 8
- 229910000831 Steel Inorganic materials 0.000 description 18
- 239000010959 steel Substances 0.000 description 18
- 238000007726 management method Methods 0.000 description 9
- 230000004048 modification Effects 0.000 description 8
- 238000012986 modification Methods 0.000 description 8
- 238000013461 design Methods 0.000 description 6
- 238000004891 communication Methods 0.000 description 5
- 238000010276 construction Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 230000033228 biological regulation Effects 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 230000004044 response Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
-
- 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
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/08—Construction
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Tourism & Hospitality (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Development Economics (AREA)
- Software Systems (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method and a system for managing a change engineering quantity. The method comprises the following steps: calculating the engineering quantity and the quantity of change and increment by modifying the calculation parameters before change through a calculation component or a batch; calculating the change increase and decrease amount of the engineering quantity list by associating the calculated quantity content with the engineering quantity list and comparing the quantity of the changed engineering quantity list by collecting according to the calculation result of the changed engineering quantity; the calculated amount content is associated with a material dictionary, and the material change engineering amount comparison is formed by aggregation according to the calculation result of the change engineering amount; and integrating the subcontracting list to change the engineering quantity comparison according to the calculation result of the engineering quantity change by associating the calculated quantity content with the subcontracting list. According to the scheme provided by the invention, the calculation efficiency of the whole engineering quantity is improved by more than 5 times; and (3) completing the work and time consumption for replacing the original manual summary, and automatically forming the quantity comparison of the change engineering quantity list, the quantity comparison of the change sub-packaging list and the quantity comparison data of the change material.
Description
Technical Field
The invention belongs to the field of engineering quantity calculation, and particularly relates to a method and a system for managing a changed engineering quantity.
Background
1) Design change: the design change refers to the activities of modifying and perfecting the approved preliminary design file, technical design file or construction drawing design file from the date of the project preliminary design approval to the date of the approval of the final delivery, and is generally called as project amount change, which is accompanied by the increase or decrease of the project amount.
2) And (5) engineering quantity list: the engineering quantity list is a detailed list of names, corresponding quantities and the like of the subsection engineering projects, measure projects, other projects, regulation projects, tax projects and the like of the construction engineering, and is a list which is convenient for a construction unit (i.e. a homeowner) to meter and settle the construction unit. When the change occurs, the engineering quantity is summarized to the dimension of the engineering quantity list to reflect the change before and after the change when facing the industry owner.
3) And (5) a sub-packaging list: the subcontracting list is a list of construction units for metering and settling the labor team, which is convenient for subcontracting contract signing, receiving party settlement and cost management and control. When the change occurs, the work amount is summarized to the change before and after the change of the subcontracting list dimension response when facing the work team.
4) Calculating component: the method is characterized in that the calculation amount content in each element forming the building is packaged into a template, and the template comprises a plurality of calculation amount contents, and detailed calculation steps and calculation parameters of each content. For example, a bridge pile foundation can be used as a component, the component contains the calculation contents of steel bars, concrete and the like, and simultaneously contains the calculation formula and the calculation parameters of the steel bar engineering quantity and the calculation formula and the calculation parameters of the concrete.
Prior art and drawbacks thereof
(1) In the prior art, an Excel table is needed to be used for compiling a calculation formula, the engineering quantity is calculated and changed part by part, the calculation efficiency is low, and errors are easy to occur;
(2) After the engineering quantity is changed, the calculated engineering quantity is required to be copied to the engineering quantity list dimension in an Excel table, so that engineering quantity comparison of the engineering quantity list dimension is formed, the working efficiency is low, mistakes are easy, and the mistakes are difficult to find out;
(3) After the calculation of the engineering quantity is changed, the calculated engineering quantity is required to be copied to the dimension of the sub-packaging list in the Excel table, so that the engineering quantity comparison of the dimension of the sub-packaging list is formed, the working efficiency is low, the error is easy, and the error is difficult to find out;
(4) After the engineering quantity is changed, the calculated engineering quantity is required to be summarized to the material dimension in an Excel table, so that engineering quantity comparison of the material dimension is formed, the working efficiency is low, mistakes are easy, and the mistakes are difficult to find out.
Disclosure of Invention
In order to solve the technical problems, the invention provides a technical scheme for changing the engineering quantity management method so as to solve the technical problems.
The first aspect of the invention discloses a method for managing a change engineering quantity, which comprises the following steps:
S1, calculating a change engineering quantity and a change increment/decrement by modifying calculation parameters before change through a calculation component or in batches;
Step S2, calculating the change increase and decrease amount of the engineering quantity list by associating the calculated quantity content with the engineering quantity list and comparing the quantity of the changed engineering quantity list by collecting according to the calculation result of the changed engineering quantity; the calculated amount content is associated with a material dictionary, and the material change engineering amount comparison is formed by aggregation according to the calculation result of the change engineering amount; and integrating the subcontracting list to change the engineering quantity comparison according to the calculation result of the engineering quantity change by associating the calculated quantity content with the subcontracting list.
According to the method of the first aspect of the present invention, in the step S1, the method of calculating the change engineering quantity and the change increment quantity by the quantity calculating means includes:
Selecting a part with change, and automatically taking out the engineering quantity before the change because the engineering quantity before the change is calculated by the selected original part;
Selecting a calculation component which is the same as the calculation formula after the position is changed, and calculating the engineering quantity after the change by replacing the parameters and multiplexing the original calculation formula because the calculation component comprises two parts of contents of the calculation formula and the calculation parameters;
The same calculation amount content is identified, the engineering amount of each calculation amount content before and after the change is compared, and the change increment amount is calculated, namely, the change increment amount = the engineering amount after the change-the engineering amount before the change.
According to the method of the first aspect of the present invention, in the step S1, the method for calculating the change engineering quantity and the change increment quantity by modifying the calculated parameters before the change in batches includes:
selecting a part with change, and if the engineering quantity before the change is calculated by the selected original part, automatically taking out a calculation formula of the calculation quantity content and the calculation quantity content under the part and calculation parameters;
The default parameters after the change are all the same as the parameters before the change, and the calculation parameters which are changed are modified in batches;
Calculating the engineering quantity after the content of each calculation quantity is changed by using the changed calculation parameters and the multiplexing original calculation formula;
The same calculation amount content is identified, the engineering amount of each calculation amount content before and after the change is compared, and the change increment amount is calculated, namely, the change increment amount = the engineering amount after the change-the engineering amount before the change.
According to the method of the first aspect of the present invention, in the step S2, the method for calculating the change increase/decrease amount of the engineering quantity list by associating the calculated quantity content with the engineering quantity list and integrating the quantity comparison of the engineering quantity change list according to the calculation result of the engineering quantity change comprises:
Selecting a plurality of calculation content, and associating the calculation content with the engineering quantity list; each engineering quantity list corresponds to a unique unit price, and then the amount of each calculated quantity content=the unit price of the engineering quantity list related to the changed quantity;
Summarizing the changed amount in the engineering quantity list dimension, namely, the changed amount of a certain engineering quantity list is = Σ (the changed amount of the related calculation quantity content is monovalent);
The change increase/decrease amount is calculated in the engineering quantity list dimension, that is, the change increase/decrease amount of an engineering quantity list is = Σ (the amount after the change of an engineering quantity list is-the amount before the change of an engineering quantity list).
According to the method of the first aspect of the present invention, in the step S2, the method for forming the comparison of the material change engineering quantity by integrating the calculated quantity content with the material dictionary according to the calculation result of the change engineering quantity includes:
Selecting a plurality of calculation content, and associating the calculation content with a material dictionary to realize the unification of the statistical caliber of the material;
Summarizing the post-change quantity in the dictionary material dimension, i.e., a post-change quantity = Σfor a certain material (post-change quantity of the calculation content associated with this material dictionary);
the change increase/decrease number is calculated in the dictionary material dimension, that is, the change increase/decrease number of a certain material is = Σ (the number after a certain material change-the number before a certain material change).
According to the method of the first aspect of the present invention, in the step S2, the method for integrating the comparison of the change engineering quantity of the sub-packaging list according to the calculation result of the change engineering quantity by associating the calculated quantity content with the sub-packaging list includes:
selecting a plurality of items of calculation content, and associating the calculation content with the subcontracting list;
summarizing the changed quantity in the subcontracting list dimension, namely, the changed quantity of a certain subcontracting list is = Σ (the changed quantity of the calculated quantity content of the associated subcontracting list);
The change increase/decrease number is calculated in the sub-packet list dimension, that is, the change increase/decrease number of a certain sub-packet list = Σ (the number after a change of a certain sub-packet list-the number before a change of a certain sub-packet list).
The second aspect of the present invention discloses a system for managing a change engineering quantity, the system comprising:
A first processing module configured to calculate a change engineering quantity and a change increment quantity by modifying the pre-change calculation parameter by a calculation component or a batch;
The second processing module is configured to calculate the change increase and decrease amount of the engineering quantity list by associating the calculated quantity content with the engineering quantity list and integrating the quantity comparison of the engineering quantity change list according to the calculation result of the engineering quantity change; the calculated amount content is associated with a material dictionary, and the material change engineering amount comparison is formed by aggregation according to the calculation result of the change engineering amount; and integrating the subcontracting list to change the engineering quantity comparison according to the calculation result of the engineering quantity change by associating the calculated quantity content with the subcontracting list.
A third aspect of the invention discloses an electronic device. The electronic device comprises a memory storing a computer program and a processor implementing the steps in a method of altering engineering management of any of the first aspects of the present disclosure when the processor executes the computer program.
A fourth aspect of the invention discloses a computer-readable storage medium. A computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the steps in a method of altering engineering management of any of the first aspects of the present disclosure.
According to the scheme provided by the invention, the calculation efficiency of the whole engineering quantity is improved by more than 5 times; and (3) completing the work and time consumption for replacing the original manual summary, and automatically forming the quantity comparison of the change engineering quantity list, the quantity comparison of the change sub-packaging list and the quantity comparison data of the change material.
Compared with the original calculation mode of manually calculating the engineering quantity before change, calculating the engineering quantity after change and calculating the engineering quantity after change by means of an Excel table, the scheme provided by the invention has the advantages that the engineering quantity before change is automatically brought by a selected part, the engineering quantity after change is quickly calculated by adopting a modified parameter or a reference component, and then the addition and subtraction operation is automatically carried out, so that the calculation efficiency of the change and addition quantity is improved by more than 5 times; compared with the original method that after the change project amount is calculated by means of an Excel table, owner list details, material dictionaries and sub-packaging list items are input into an Excel data line, and then the number of the change project amount list is compared, the sub-packaging list number is compared and the material quantity comparison data is changed through column data filtering and summarization.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are needed in the description of the embodiments or the prior art will be briefly described, and it is obvious that the drawings in the description below are some embodiments of the present invention, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a method of altering engineering management according to an embodiment of the present invention;
FIG. 2 is a block diagram of a change engineering quantity management system according to an embodiment of the present invention;
Fig. 3 is a block diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The first aspect of the invention discloses a method for managing a change engineering quantity. FIG. 1 is a flow chart of a method for altering engineering management according to an embodiment of the present invention, as shown in FIG. 1, the method includes:
S1, calculating a change engineering quantity and a change increment/decrement by modifying calculation parameters before change through a calculation component or in batches;
Step S2, calculating the change increase and decrease amount of the engineering quantity list by associating the calculated quantity content with the engineering quantity list and comparing the quantity of the changed engineering quantity list by collecting according to the calculation result of the changed engineering quantity; the calculated amount content is associated with a material dictionary, and the material change engineering amount comparison is formed by aggregation according to the calculation result of the change engineering amount; and integrating the subcontracting list to change the engineering quantity comparison according to the calculation result of the engineering quantity change by associating the calculated quantity content with the subcontracting list.
In step S1, the calculation amount means or the batch modification pre-change calculation parameters are used to calculate the change engineering amount and the change increment amount.
In some embodiments, in the step S1, the method for calculating the change engineering quantity and the change increment quantity through the quantity calculating means includes:
Selecting a part with change, and automatically taking out the engineering quantity before the change because the engineering quantity before the change is calculated by the selected original part;
Selecting a calculation component which is the same as the calculation formula after the position is changed, and calculating the engineering quantity after the change by replacing the parameters and multiplexing the original calculation formula because the calculation component comprises two parts of contents of the calculation formula and the calculation parameters;
The same calculation amount content is identified, the engineering amount of each calculation amount content before and after the change is compared, and the change increment amount is calculated, namely, the change increment amount = the engineering amount after the change-the engineering amount before the change.
Specifically, in actual engineering, a plurality of parts are often changed at the same time, and at this time, the calculation component can be referenced to the plurality of parts, so as to realize automatic and rapid calculation of the change increase/decrease amount of the plurality of parts.
The tunnel engineering algorithm is also specially processed. Since the tunnel engineering is linear engineering, the engineering quantity of a longer section of tunnel is generally calculated when the engineering quantity before modification is calculated according to the earlier-stage comparison drawing, for example, K0+000-K0+200, and the section of tunnel from the zero pile number starting point to the position of 200m is represented. In actual change, the advanced geological forecast generally detects only 20m in length, so that the change is often 20m at a time. In this case, the method calculates the pre-change engineering quantity of K0+000 to K0+020 segments, that is, the total engineering quantity of K0+000 to K0+200, where K0+000 to K0+020 segments are calculated by automatic percentage calculation.
The method for calculating the engineering quantity and the increment quantity by modifying the calculated parameters before modification in batches comprises the following steps:
selecting a part with change, and if the engineering quantity before the change is calculated by the selected original part, automatically taking out a calculation formula of the calculation quantity content and the calculation quantity content under the part and calculation parameters;
The default parameters after the change are all the same as the parameters before the change, and the calculation parameters which are changed are modified in batches;
Calculating the engineering quantity after the content of each calculation quantity is changed by using the changed calculation parameters and the multiplexing original calculation formula;
The same calculation amount content is identified, the engineering amount of each calculation amount content before and after the change is compared, and the change increment amount is calculated, namely, the change increment amount = the engineering amount after the change-the engineering amount before the change.
In step S2, calculating the change increase and decrease amount of the engineering quantity list by associating the calculated quantity content with the engineering quantity list and integrating the quantity comparison of the changed engineering quantity list according to the calculation result of the changed engineering quantity; the calculated amount content is associated with a material dictionary, and the material change engineering amount comparison is formed by aggregation according to the calculation result of the change engineering amount; and integrating the subcontracting list to change the engineering quantity comparison according to the calculation result of the engineering quantity change by associating the calculated quantity content with the subcontracting list.
In some embodiments, in the step S2, the method for calculating the change increase/decrease amount of the engineering quantity list by associating the calculated quantity content with the engineering quantity list and integrating the calculation result of the change engineering quantity to form a comparison of the number of the change engineering quantity list includes:
Selecting a plurality of calculation content, and associating the calculation content with the engineering quantity list; each engineering quantity list corresponds to a unique unit price, and then the amount of each calculated quantity content=the unit price of the engineering quantity list related to the changed quantity;
specifically, in actual engineering, a plurality of similar accounting contents are often associated with the same engineering quantity list, for example, accounting content 1 is a threaded steel with a diameter of 22mm, accounting content 2-bit is a threaded steel with a diameter of 25mm, accounting content 3 is a threaded steel with a diameter of 28mm, and all the similar accounting contents can be associated with one engineering quantity list named as a 'steel bar';
Summarizing the changed amount in the engineering quantity list dimension, namely, the changed amount of a certain engineering quantity list is = Σ (the changed amount of the related calculation quantity content is monovalent);
The change increase/decrease amount is calculated in the engineering quantity list dimension, that is, the change increase/decrease amount of an engineering quantity list is = Σ (the amount after the change of an engineering quantity list is-the amount before the change of an engineering quantity list).
The method for comparing the quantity of the change engineering of the material by associating the quantity content with the material dictionary and integrating the quantity according to the calculation result of the quantity of the change engineering comprises the following steps:
Selecting a plurality of calculation content, and associating the calculation content with a material dictionary to realize the unification of the statistical caliber of the material;
Specifically, in actual engineering, the condition that the same calculated content is called or named inconsistent often occurs, but the same material is actually required to be unified through a related material dictionary; for example, a screw-thread steel with a diameter of 22mm, which is named as phi 22HRB400, a screw-thread steel with a diameter of 22mm, and a screw-thread steel with a diameter of 22mm, the number of screw-thread steels should be attributed to the same material;
Summarizing the post-change quantity in the dictionary material dimension, i.e., a post-change quantity = Σfor a certain material (post-change quantity of the calculation content associated with this material dictionary);
the change increase/decrease number is calculated in the dictionary material dimension, that is, the change increase/decrease number of a certain material is = Σ (the number after a certain material change-the number before a certain material change).
The method for comparing the change engineering quantity of the integrated sub-packaging list comprises the following steps of:
selecting a plurality of items of calculation content, and associating the calculation content with the subcontracting list;
summarizing the changed quantity in the subcontracting list dimension, namely, the changed quantity of a certain subcontracting list is = Σ (the changed quantity of the calculated quantity content of the associated subcontracting list);
The change increase/decrease number is calculated in the sub-packet list dimension, that is, the change increase/decrease number of a certain sub-packet list = Σ (the number after a change of a certain sub-packet list-the number before a change of a certain sub-packet list).
In summary, the scheme provided by the application improves the calculation efficiency of the whole engineering quantity by more than 5 times; and (3) completing the work and time consumption for replacing the original manual summary, and automatically forming the quantity comparison of the change engineering quantity list, the quantity comparison of the change sub-packaging list and the quantity comparison data of the change material. Compared with the original calculation mode of manually calculating the engineering quantity before change, calculating the engineering quantity after change and calculating the engineering quantity after change by means of an Excel table, the engineering quantity before change is automatically brought out by selecting the part, the engineering quantity after change is quickly calculated by adopting the modification parameters or the reference components, and then the modification and addition calculation is automatically carried out, so that the calculation efficiency of the change and addition amount is improved by more than 5 times; compared with the original method that after the change project amount is calculated by means of an Excel table, owner list details, material dictionaries and sub-packaging list items are input into an Excel data line, and then the number of the change project amount list is compared, the sub-packaging list number is compared and the material quantity comparison data is changed through column data filtering and summarization.
The second aspect of the invention discloses a system for managing a change engineering quantity. FIG. 2 is a block diagram of a change engineering quantity management system according to an embodiment of the present invention; as shown in fig. 2, the system 100 includes:
A first processing module 101 configured to calculate a change engineering quantity and a change increment quantity by modifying a pre-change calculation parameter by a calculation component or a batch;
A second processing module 102 configured to calculate an engineering quantity list change increase/decrease amount by associating the calculated quantity content with the engineering quantity list, and integrating a change engineering quantity list quantity comparison according to the calculation result of the change engineering quantity; the calculated amount content is associated with a material dictionary, and the material change engineering amount comparison is formed by aggregation according to the calculation result of the change engineering amount; and integrating the subcontracting list to change the engineering quantity comparison according to the calculation result of the engineering quantity change by associating the calculated quantity content with the subcontracting list.
According to the system of the second aspect of the present invention, the first processing module 101 is specifically configured such that the method for calculating the change engineering quantity and the change increment quantity by the calculation means includes:
Selecting a part with change, and automatically taking out the engineering quantity before the change because the engineering quantity before the change is calculated by the selected original part;
Selecting a calculation component which is the same as the calculation formula after the position is changed, and calculating the engineering quantity after the change by replacing the parameters and multiplexing the original calculation formula because the calculation component comprises two parts of contents of the calculation formula and the calculation parameters;
The same calculation amount content is identified, the engineering amount of each calculation amount content before and after the change is compared, and the change increment amount is calculated, namely, the change increment amount = the engineering amount after the change-the engineering amount before the change.
Specifically, in actual engineering, a plurality of parts are often changed at the same time, and at this time, the calculation component can be referenced to the plurality of parts, so as to realize automatic and rapid calculation of the change increase/decrease amount of the plurality of parts.
The tunnel engineering algorithm is also specially processed. Since the tunnel engineering is linear engineering, the engineering quantity of a longer section of tunnel is generally calculated when the engineering quantity before modification is calculated according to the earlier-stage comparison drawing, for example, K0+000-K0+200, and the section of tunnel from the zero pile number starting point to the position of 200m is represented. In actual change, the advanced geological forecast generally detects only 20m in length, so that the change is often 20m at a time. In this case, the method calculates the pre-change engineering quantity of K0+000 to K0+020 segments, that is, the total engineering quantity of K0+000 to K0+200, where K0+000 to K0+020 segments are calculated by automatic percentage calculation.
The method for calculating the engineering quantity and the increment quantity by modifying the calculated parameters before modification in batches comprises the following steps:
selecting a part with change, and if the engineering quantity before the change is calculated by the selected original part, automatically taking out a calculation formula of the calculation quantity content and the calculation quantity content under the part and calculation parameters;
The default parameters after the change are all the same as the parameters before the change, and the calculation parameters which are changed are modified in batches;
Calculating the engineering quantity after the content of each calculation quantity is changed by using the changed calculation parameters and the multiplexing original calculation formula;
The same calculation amount content is identified, the engineering amount of each calculation amount content before and after the change is compared, and the change increment amount is calculated, namely, the change increment amount = the engineering amount after the change-the engineering amount before the change.
According to the system of the second aspect of the present invention, the second processing module 102 is specifically configured to, by associating the calculated amount content with the engineering amount list, perform aggregation to form a modified engineering amount list quantity comparison according to the calculation result of the modified engineering amount, and the method for calculating the modified increasing/decreasing amount of the engineering amount list includes:
Selecting a plurality of calculation content, and associating the calculation content with the engineering quantity list; each engineering quantity list corresponds to a unique unit price, and then the amount of each calculated quantity content=the unit price of the engineering quantity list related to the changed quantity;
specifically, in actual engineering, a plurality of similar accounting contents are often associated with the same engineering quantity list, for example, accounting content 1 is a threaded steel with a diameter of 22mm, accounting content 2-bit is a threaded steel with a diameter of 25mm, accounting content 3 is a threaded steel with a diameter of 28mm, and all the similar accounting contents can be associated with one engineering quantity list named as a 'steel bar';
Summarizing the changed amount in the engineering quantity list dimension, namely, the changed amount of a certain engineering quantity list is = Σ (the changed amount of the related calculation quantity content is monovalent);
The change increase/decrease amount is calculated in the engineering quantity list dimension, that is, the change increase/decrease amount of an engineering quantity list is = Σ (the amount after the change of an engineering quantity list is-the amount before the change of an engineering quantity list).
The method for comparing the quantity of the change engineering of the material by associating the quantity content with the material dictionary and integrating the quantity according to the calculation result of the quantity of the change engineering comprises the following steps:
Selecting a plurality of calculation content, and associating the calculation content with a material dictionary to realize the unification of the statistical caliber of the material;
Specifically, in actual engineering, the condition that the same calculated content is called or named inconsistent often occurs, but the same material is actually required to be unified through a related material dictionary; for example, a screw-thread steel with a diameter of 22mm, which is named as phi 22HRB400, a screw-thread steel with a diameter of 22mm, and a screw-thread steel with a diameter of 22mm, the number of screw-thread steels should be attributed to the same material;
Summarizing the post-change quantity in the dictionary material dimension, i.e., a post-change quantity = Σfor a certain material (post-change quantity of the calculation content associated with this material dictionary);
the change increase/decrease number is calculated in the dictionary material dimension, that is, the change increase/decrease number of a certain material is = Σ (the number after a certain material change-the number before a certain material change).
The method for comparing the change engineering quantity of the integrated sub-packaging list comprises the following steps of:
selecting a plurality of items of calculation content, and associating the calculation content with the subcontracting list;
summarizing the changed quantity in the subcontracting list dimension, namely, the changed quantity of a certain subcontracting list is = Σ (the changed quantity of the calculated quantity content of the associated subcontracting list);
The change increase/decrease number is calculated in the sub-packet list dimension, that is, the change increase/decrease number of a certain sub-packet list = Σ (the number after a change of a certain sub-packet list-the number before a change of a certain sub-packet list).
A third aspect of the invention discloses an electronic device. The electronic device comprises a memory and a processor, the memory storing a computer program, the processor implementing the steps in a method of altering engineering management of any one of the first aspects of the present disclosure when the computer program is executed.
Fig. 3 is a block diagram of an electronic device according to an embodiment of the present invention, and as shown in fig. 3, the electronic device includes a processor, a memory, a communication interface, a display screen, and an input device connected through a system bus. Wherein the processor of the electronic device is configured to provide computing and control capabilities. The memory of the electronic device includes a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The communication interface of the electronic device is used for conducting wired or wireless communication with an external terminal, and the wireless communication can be achieved through WIFI, an operator network, near Field Communication (NFC) or other technologies. The display screen of the electronic equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the electronic equipment can be a touch layer covered on the display screen, can also be keys, a track ball or a touch pad arranged on the shell of the electronic equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structure shown in fig. 3 is merely a block diagram of a portion related to the technical solution of the present disclosure, and does not constitute a limitation of the electronic device to which the technical solution of the present disclosure is applied, and that a specific electronic device may include more or less components than those shown in the drawings, or may combine some components, or have different component arrangements.
A fourth aspect of the invention discloses a computer-readable storage medium. A computer-readable storage medium has stored thereon a computer program which, when executed by a processor, implements steps in a method of managing a quantity of work to be altered according to any of the first aspect of the present disclosure.
Note that the technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be regarded as the scope of the description. The foregoing examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.
Claims (4)
1. A method of altering engineering management, the method comprising:
S1, calculating a change engineering quantity and a change increment/decrement by modifying calculation parameters before change through a calculation component or in batches;
Step S2, calculating the change increase and decrease amount of the engineering quantity list by associating the calculated quantity content with the engineering quantity list and comparing the quantity of the changed engineering quantity list by collecting according to the calculation result of the changed engineering quantity; the calculated amount content is associated with a material dictionary, and the material change engineering amount comparison is formed by aggregation according to the calculation result of the change engineering amount; the calculated amount content is associated with the sub-packaging list, and the sub-packaging list is collected to form sub-packaging list to change the engineering amount comparison according to the calculation result of the engineering amount change;
In the step S2, the method for calculating the amount of change, increase and decrease of the amount of money in the engineering amount list by associating the calculated amount content with the engineering amount list and comparing the amount of change engineering amount list by integrating the calculated amount content according to the calculation result of the change engineering amount comprises:
selecting a plurality of calculation content, and associating the calculation content with the engineering quantity list; each engineering quantity list corresponds to a unique unit price, and then the amount of each calculated quantity content=the changed quantity is the unit price of the associated engineering quantity list;
Summarizing the changed amount in the engineering quantity list dimension, namely, the changed amount of a certain engineering quantity list is = Σ (the changed amount of the related calculation quantity content is monovalent);
Calculating change increase and decrease amount in the engineering quantity list dimension, namely, changing the increase and decrease amount of a certain engineering quantity list by using a value of the change of the engineering quantity list as a value of the change of the engineering quantity list;
in the step S2, the method for integrating and forming the comparison of the material change engineering quantity according to the calculation result of the change engineering quantity by associating the calculated quantity content with the material dictionary includes:
Selecting a plurality of calculation content, and associating the calculation content with a material dictionary to realize the unification of the statistical caliber of the material;
Summarizing the post-change quantity in the dictionary material dimension, i.e., a post-change quantity = Σfor a certain material (post-change quantity of the calculation content associated with this material dictionary);
calculating a change increase and decrease number in a dictionary material dimension, namely, a change increase and decrease number of a certain material is = Σ (a certain material change after-quantity-a certain material change before-quantity);
In the step S2, the method for integrating the comparison of the change engineering quantity of the sub-packaging list according to the calculation result of the change engineering quantity by associating the calculation quantity content with the sub-packaging list includes:
selecting a plurality of items of calculation content, and associating the calculation content with the subcontracting list;
summarizing the changed quantity in the subcontracting list dimension, namely, the changed quantity of a certain subcontracting list is = Σ (the changed quantity of the calculated quantity content of the associated subcontracting list);
calculating a change increase/decrease number in the dimension of the sub-packet list, that is, the change increase/decrease number of a certain sub-packet list = Σ (the number after a certain sub-packet list is changed-the number before a certain sub-packet list is changed);
in the step S1, the method for calculating the change work amount and the change increment amount by the calculation means includes:
Selecting a part with change, and if the engineering quantity before the change is calculated by the selected original part, automatically taking out the engineering quantity before the change;
Selecting a calculation component which is the same as the calculation formula after the change of the changed part, and if the calculation component contains two parts of contents of the calculation formula and the calculation parameters, calculating the engineering quantity after the change in a mode of replacing the parameters and multiplexing the original calculation formula;
Identifying the same calculated amount content, comparing the engineering amount before and after the change of each calculated amount content, and calculating the change increment amount, namely, change increment amount = changed engineering amount-changed engineering amount;
In the step S1, the method for calculating the change engineering quantity and the change increment quantity by modifying the calculation parameters before the change in batches includes:
selecting a part with change, and if the engineering quantity before the change is calculated by the selected original part, automatically taking out a calculation formula of the calculation quantity content and the calculation quantity content under the part and calculation parameters;
The default parameters after the change are all the same as the parameters before the change, and the calculation parameters which are changed are modified in batches;
Calculating the engineering quantity after the content of each calculation quantity is changed by using the changed calculation parameters and the multiplexing original calculation formula;
The same calculation amount content is identified, the engineering amount of each calculation amount content before and after the change is compared, and the change increment amount is calculated, namely, the change increment amount = the engineering amount after the change-the engineering amount before the change.
2. A system for altering an engineering management system, the system comprising:
A first processing module configured to calculate a change engineering quantity and a change increment quantity by modifying the pre-change calculation parameter by a calculation component or a batch;
The calculating means calculates a change engineering quantity and a change increase/decrease quantity, including:
Selecting a part with change, and if the engineering quantity before the change is calculated by the selected original part, automatically taking out the engineering quantity before the change;
Selecting a calculation component which is the same as the calculation formula after the change of the changed part, and if the calculation component contains two parts of contents of the calculation formula and the calculation parameters, calculating the engineering quantity after the change in a mode of replacing the parameters and multiplexing the original calculation formula;
Identifying the same calculated amount content, comparing the engineering amount before and after the change of each calculated amount content, and calculating the change increment amount, namely, change increment amount = changed engineering amount-changed engineering amount;
calculating the change engineering quantity and the change increase and decrease quantity by modifying the calculated parameters before change in batches comprises the following steps:
selecting a part with change, and if the engineering quantity before the change is calculated by the selected original part, automatically taking out a calculation formula of the calculation quantity content and the calculation quantity content under the part and calculation parameters;
The default parameters after the change are all the same as the parameters before the change, and the calculation parameters which are changed are modified in batches;
Calculating the engineering quantity after the content of each calculation quantity is changed by using the changed calculation parameters and the multiplexing original calculation formula;
Identifying the same calculated amount content, comparing the engineering amount before and after the change of each calculated amount content, and calculating the change increment amount, namely, change increment amount = changed engineering amount-changed engineering amount;
The second processing module is configured to calculate the change increase and decrease amount of the engineering quantity list by associating the calculated quantity content with the engineering quantity list and integrating the quantity comparison of the engineering quantity change list according to the calculation result of the engineering quantity change; the calculated amount content is associated with a material dictionary, and the material change engineering amount comparison is formed by aggregation according to the calculation result of the change engineering amount; the calculated amount content is associated with the sub-packaging list, and the sub-packaging list is collected to form sub-packaging list to change the engineering amount comparison according to the calculation result of the engineering amount change;
and the calculating the change, increase and decrease amount of the engineering quantity list comprises the steps of:
selecting a plurality of calculation content, and associating the calculation content with the engineering quantity list; each engineering quantity list corresponds to a unique unit price, and then the amount of each calculated quantity content=the changed quantity is the unit price of the associated engineering quantity list;
Summarizing the changed amount in the engineering quantity list dimension, namely, the changed amount of a certain engineering quantity list is = Σ (the changed amount of the related calculation quantity content is monovalent);
Calculating change increase and decrease amount in the engineering quantity list dimension, namely, changing the increase and decrease amount of a certain engineering quantity list by using a value of the change of the engineering quantity list as a value of the change of the engineering quantity list;
the step of integrating the material change engineering quantity comparison comprises the steps of:
Selecting a plurality of calculation content, and associating the calculation content with a material dictionary to realize the unification of the statistical caliber of the material;
Summarizing the post-change quantity in the dictionary material dimension, i.e., a post-change quantity = Σfor a certain material (post-change quantity of the calculation content associated with this material dictionary);
calculating a change increase and decrease number in a dictionary material dimension, namely, a change increase and decrease number of a certain material is = Σ (a certain material change after-quantity-a certain material change before-quantity);
The step of integrating the sub-packaging list to change the engineering quantity comparison comprises the steps of:
selecting a plurality of items of calculation content, and associating the calculation content with the subcontracting list;
summarizing the changed quantity in the subcontracting list dimension, namely, the changed quantity of a certain subcontracting list is = Σ (the changed quantity of the calculated quantity content of the associated subcontracting list);
The change increase/decrease number is calculated in the sub-packet list dimension, that is, the change increase/decrease number of a certain sub-packet list = Σ (the number after a change of a certain sub-packet list-the number before a change of a certain sub-packet list).
3. An electronic device comprising a memory and a processor, the memory storing a computer program, the processor implementing the steps of a method of altering engineering management of claim 1 when the computer program is executed.
4. A computer readable storage medium, having stored thereon a computer program which, when executed by a processor, implements the steps of a method of altering engineering management according to claim 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310897192.XA CN117033399B (en) | 2023-07-20 | 2023-07-20 | Method and system for managing engineering quantity change |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310897192.XA CN117033399B (en) | 2023-07-20 | 2023-07-20 | Method and system for managing engineering quantity change |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117033399A CN117033399A (en) | 2023-11-10 |
| CN117033399B true CN117033399B (en) | 2024-06-04 |
Family
ID=88628901
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310897192.XA Active CN117033399B (en) | 2023-07-20 | 2023-07-20 | Method and system for managing engineering quantity change |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117033399B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110880097A (en) * | 2019-11-21 | 2020-03-13 | 中国电力企业联合会电力建设技术经济咨询中心 | Project progress simulation display method and device |
| CN111598730A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | System and method for extracting engineering quantity and avoiding secondary quantity extraction |
| CN112541221A (en) * | 2020-12-25 | 2021-03-23 | 深圳高速工程顾问有限公司 | BIM-based engineering quantity inventory compiling method, system, equipment and storage medium |
| CN114418369A (en) * | 2022-01-13 | 2022-04-29 | 湖北国际物流机场有限公司 | Metering payment method and system based on BIM (building information modeling) |
| CN114511203A (en) * | 2022-01-13 | 2022-05-17 | 湖北国际物流机场有限公司 | Method and system for rapidly outputting project amount list based on BIM (building information modeling) |
| CN114648244A (en) * | 2022-04-06 | 2022-06-21 | 北京梦诚科技有限公司 | Design method and system of five-volume dynamic machine account |
| CN114647885A (en) * | 2022-04-02 | 2022-06-21 | 北京梦诚科技有限公司 | Method and system for construction drawing design content display and application calculation |
| CN114971597A (en) * | 2022-07-29 | 2022-08-30 | 浙江小塔塔峰软件技术有限公司 | Road cost calculation system and method based on BIM calculation amount and metering payment |
| CN116228153A (en) * | 2023-02-27 | 2023-06-06 | 广州市城市建设工程监理有限公司 | Engineering project design change price management method, system, equipment and medium |
-
2023
- 2023-07-20 CN CN202310897192.XA patent/CN117033399B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110880097A (en) * | 2019-11-21 | 2020-03-13 | 中国电力企业联合会电力建设技术经济咨询中心 | Project progress simulation display method and device |
| CN111598730A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | System and method for extracting engineering quantity and avoiding secondary quantity extraction |
| CN112541221A (en) * | 2020-12-25 | 2021-03-23 | 深圳高速工程顾问有限公司 | BIM-based engineering quantity inventory compiling method, system, equipment and storage medium |
| CN114418369A (en) * | 2022-01-13 | 2022-04-29 | 湖北国际物流机场有限公司 | Metering payment method and system based on BIM (building information modeling) |
| CN114511203A (en) * | 2022-01-13 | 2022-05-17 | 湖北国际物流机场有限公司 | Method and system for rapidly outputting project amount list based on BIM (building information modeling) |
| CN114647885A (en) * | 2022-04-02 | 2022-06-21 | 北京梦诚科技有限公司 | Method and system for construction drawing design content display and application calculation |
| CN114648244A (en) * | 2022-04-06 | 2022-06-21 | 北京梦诚科技有限公司 | Design method and system of five-volume dynamic machine account |
| CN114971597A (en) * | 2022-07-29 | 2022-08-30 | 浙江小塔塔峰软件技术有限公司 | Road cost calculation system and method based on BIM calculation amount and metering payment |
| CN116228153A (en) * | 2023-02-27 | 2023-06-06 | 广州市城市建设工程监理有限公司 | Engineering project design change price management method, system, equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117033399A (en) | 2023-11-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107679081A (en) | Information amending method, device, computer equipment and computer-readable recording medium | |
| CN111224469A (en) | Transmission line loss monitoring and early warning method, device, equipment and medium | |
| CN110828017A (en) | Information processing method and information processing system for nuclear power plant | |
| CN109597979B (en) | List table generation method and device, computer equipment and storage medium | |
| CN112381382B (en) | Leakage management method, leakage management device and terminal equipment | |
| CN111144962A (en) | Invoice issuing method and device based on e-commerce platform and e-commerce platform | |
| CN109783697A (en) | Data processing method, device, computer equipment and storage medium | |
| CN114648244A (en) | Design method and system of five-volume dynamic machine account | |
| Huang et al. | Optimal production planning with capacity reservation and convex capacity costs | |
| CN111369279A (en) | Revit-based engineering settlement method, system, device and storage medium | |
| CN117033399B (en) | Method and system for managing engineering quantity change | |
| CN108921459A (en) | Index generates method, apparatus, computer equipment and storage medium | |
| CN101793951A (en) | Method for communication of multitudinous electric energy meters | |
| CN105005696A (en) | Method and device for determining failure rates | |
| CN113220777A (en) | Service data processing method and device, computer equipment and storage medium | |
| CN107886440A (en) | A kind of insured amount computational methods of code insurance and device | |
| Ekström et al. | Recovering a time-homogeneous stock price process from perpetual option prices | |
| Wei | Ruin probability in the presence of interest earnings and tax payments | |
| CN113792995B (en) | Method, device, equipment and storage medium for determining power resource dominance degree | |
| CN113342502A (en) | Method and device for diagnosing performance of data lake, computer equipment and storage medium | |
| CN113988800A (en) | Method and device for checking abnormal electric quantity user, computer equipment and storage medium | |
| Chung et al. | On the rate of convergence of binomial Greeks | |
| CN103529777B (en) | Reliability data of power equipment automatic setting method and system | |
| CN109213784A (en) | Report on the evaluation of tenders generation method, device, electronic equipment and storage medium | |
| Wu et al. | Affine Regime-Switching Models for Interest Rate Term |
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 |