CN117575475B - Quick construction and display method for large-screen report based on data warehouse - Google Patents
Quick construction and display method for large-screen report based on data warehouse Download PDFInfo
- Publication number
- CN117575475B CN117575475B CN202410058081.4A CN202410058081A CN117575475B CN 117575475 B CN117575475 B CN 117575475B CN 202410058081 A CN202410058081 A CN 202410058081A CN 117575475 B CN117575475 B CN 117575475B
- Authority
- CN
- China
- Prior art keywords
- construction
- project
- stage
- consumption
- engineering
- 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
- 238000010276 construction Methods 0.000 title claims abstract description 494
- 238000000034 method Methods 0.000 title claims abstract description 62
- 239000000463 material Substances 0.000 claims abstract description 320
- 238000004458 analytical method Methods 0.000 claims description 45
- 238000012937 correction Methods 0.000 claims description 25
- 238000013519 translation Methods 0.000 claims description 17
- 238000012216 screening Methods 0.000 claims description 11
- 239000004035 construction material Substances 0.000 claims description 4
- 230000001419 dependent effect Effects 0.000 claims description 3
- 238000013178 mathematical model Methods 0.000 claims description 3
- 238000012544 monitoring process Methods 0.000 claims description 3
- 238000006467 substitution reaction Methods 0.000 claims description 3
- 239000004973 liquid crystal related substance Substances 0.000 abstract description 4
- 230000000007 visual effect Effects 0.000 abstract description 3
- 238000007726 management method Methods 0.000 description 9
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 238000009435 building construction Methods 0.000 description 1
- 239000004566 building material Substances 0.000 description 1
- 239000003086 colorant Substances 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 238000013468 resource allocation 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/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- 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/26—Visual data mining; Browsing structured data
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- 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
-
- 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)
- Strategic Management (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Tourism & Hospitality (AREA)
- Data Mining & Analysis (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Operations Research (AREA)
- General Engineering & Computer Science (AREA)
- Quality & Reliability (AREA)
- Finance (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the field of quick construction and display of large-screen reports, and particularly discloses a quick construction and display method of a large-screen report based on a data warehouse, which is characterized in that the estimated consumption of various materials in the current construction stage of a construction project is obtained, and the estimated usable days and inventory tension coefficients of various materials in the current construction stage of the construction project are analyzed by combining a schedule of the current construction stage of the construction project and the existing quantity of the various materials, so that the situation of shortage or backlog of the materials is found in time and corresponding measures are taken in advance, and the problem of delay of the construction period or unnecessary expense caused by excessive materials due to insufficient material supply is avoided; further making a material report of the current construction stage of the construction project, and performing visual display in real time on a liquid crystal display large screen, so that project management personnel can intuitively find out problems related to material supply in the construction process at the first time, thereby improving the overall efficiency of the project.
Description
Technical Field
The invention relates to the field of quick construction and display of large-screen reports, in particular to a quick construction and display method of a large-screen report based on a data warehouse.
Background
Analysis management of construction project material data is crucial to successful implementation of a project, and by means of effective material data arrangement analysis, efficiency, control cost and management quality of the project can be improved, support is provided for decision making, project management decision making can be more accurate and targeted, planning, resource allocation, risk management and continuous improvement can be performed in a deeper layer, and accordingly overall performance and successful implementation probability of the project are improved.
The existing management method of the building engineering material data has some defects: on the one hand, the existing method is not comprehensive and deep enough for analysis and management of material data, if the existing method is only used for shallow layers such as purchasing quantity, consumption quantity and residual quantity of materials, the expected usable days, inventory tension state and the like of the materials are not further and deeply analyzed, and further, the conditions of shortage or backlog of the materials cannot be found in time and corresponding solving measures are adopted in advance, so that the conditions of delay of construction period due to insufficient material supply or unnecessary expense due to excessive materials are easy to exist, and the smooth progress of engineering projects is influenced.
On the other hand, the existing method does not sort the key information or analysis conclusion extracted from the building material data into a report form and visually display the report form, which is not beneficial to project management staff to intuitively find problems related to material supply in the building construction process at the first time, such as the problem that the material supply is not matched with the project progress, delay exists, and therefore, the supervision of the engineering project is loophole, and the overall efficiency of the engineering project is reduced.
Disclosure of Invention
Aiming at the problems, the invention provides a method for quickly constructing and displaying a large-screen report based on a data warehouse, which comprises the following specific technical scheme: a method for quickly constructing and displaying a large-screen report based on a data warehouse comprises the following steps: step one, building a building engineering material consumption model: and acquiring each engineering project of the same type as the construction engineering in the construction unit history period, recording the engineering project as each history engineering project, acquiring the engineering quantity and the consumption quantity of various materials in each construction stage of each history engineering project, analyzing the relation function between the engineering quantity and the consumption quantity of various materials in each construction stage of the construction engineering, and constructing a material consumption model of the construction engineering.
Step two, predicting material consumption in a historical construction stage: and obtaining the engineering quantity of each construction stage of the construction project, and combining the engineering quantity with a material consumption model of the construction project to obtain the predicted consumption quantity of various materials of each construction stage of the construction project.
Step three, material consumption in the historical construction stage is obtained: the actual consumption of various materials at each construction stage when the construction project is completed is obtained.
Fourth, building engineering material consumption model correction: judging whether the material consumption model of the construction project needs to be corrected according to the predicted consumption and the actual consumption of various materials in each construction stage of the construction project, if so, acquiring the corrected material consumption model of the construction project, and feeding back.
Fifthly, material consumption in the current construction stage is estimated: and acquiring the engineering quantity of the current construction stage of the construction engineering, and combining the corrected material consumption model of the construction engineering to obtain the estimated consumption quantity of various materials in the current construction stage of the construction engineering.
Step six, monitoring the stock state of the materials in the current construction stage: the method comprises the steps of obtaining a schedule of a current construction stage of a construction project and the existing quantity of various materials, and analyzing estimated usable days and inventory tension coefficients of various materials in the current construction stage of the construction project by combining the estimated consumption quantity of various materials in the current construction stage of the construction project.
Step seven, generating and displaying a material report at the current construction stage: and constructing and displaying a material report at the current construction stage of the construction project according to the existing quantity, estimated usable days and inventory tension coefficient of various materials at the current construction stage of the construction project.
On the basis of the above embodiment, the specific analysis process in the first step includes: setting the duration of a history period, acquiring each project built in the history period of a construction unit, further acquiring the type of each project built in the history period of the construction unit, acquiring the type of the construction project, screening and obtaining each project of the same type as the construction project built in the history period of the construction unit, recording the project as each history project, and acquiring the project amount of each construction stage of each history project and the consumption amount of various materials.
On the basis of the above embodiment, the specific analysis process of the first step further includes: the engineering quantity is taken as an independent variable, the consumption of materials is taken as a dependent variable, a reference coordinate system is established, the engineering quantity and the consumption of various materials in each historical engineering project are obtained according to the engineering quantity and the consumption of various materials in each construction stage of each historical engineering project, corresponding data points are marked in the reference coordinate system, a mathematical model establishing method is utilized to draw a change curve of the consumption of various materials in each construction stage along with the engineering quantity, the change curve is marked as a characteristic curve of the consumption of various materials in each construction stage, a function corresponding to the characteristic curve of the consumption of various materials in each construction stage is obtained, and the function is marked as a relation function between the engineering quantity and the consumption of various materials in each construction stage of the construction project, and a material consumption model of the construction project is established.
Based on the above embodiment, the specific analysis process in the second step is: and acquiring the engineering quantity of each construction stage of the construction project according to the engineering quantity list of the construction project.
And obtaining a relation function between the engineering quantity and various material consumption of each construction stage of the construction project according to the material consumption model of the construction project, and further screening to obtain a relation function between the engineering quantity and various material consumption of each construction stage of the construction project.
Substituting the engineering quantity of each construction stage of the construction project into a relation function between the engineering quantity of the construction stage and the consumption quantity of various materials to obtain the predicted consumption quantity of various materials of each construction stage of the construction project.
Based on the above embodiment, the specific analysis process in the fourth step includes: the predicted consumption and the actual consumption of various materials at each construction stage of the construction project are respectively recorded asAnd->，/>Indicating that the construction process is completed->Number of each construction stage->，/>Indicating +.>Numbering of class material>。
By analysis of formulasObtaining the prediction accuracy of the material consumption model of the construction project>Wherein->Correction coefficient representing preset prediction accuracy of engineering material consumption model under construction, +.>Indicating the preset +.>Weight factor of each construction stage->，/>Indicating the preset +.>First part of the construction phase>Threshold value for the difference between the predicted consumption and the actual consumption of the class material, < >>Indicating the preset +.>Weight factor of class material->。
On the basis of the above embodiment, the specific analysis process in the fourth step further includes: s1: and comparing the prediction accuracy of the material consumption model of the construction project with a preset prediction accuracy threshold, and if the prediction accuracy of the material consumption model of the construction project is smaller than the preset prediction accuracy threshold, correcting the material consumption model of the construction project, and executing S2.
S2: predicted consumption of various materials at each stage of construction where a construction project is to be completedAnd actual consumption->Substitution of the analytical formula +.>Obtaining predicted value fluctuation coefficient of engineering material consumption model>Wherein->Indicating the number of construction stages at which the construction has been completed, < > in>Indicating the number of types of materials at the stage of construction when the construction work has been completed.
By analysis of formulasObtaining predictive value correction amount of engineering material consumption model>Wherein->Reference adjustment quantity representing a preset model prediction value of the consumption of engineering material, < >>，/>And representing the compensation amount of the preset predicted value correction amount of the engineering material consumption model.
S3: and acquiring characteristic curves of various material consumption in each construction stage in a material consumption model of a construction project, and recording the characteristic curves as characteristic curves of various material consumption in each construction stage to be analyzed.
And taking the absolute value of the predicted value correction amount of the engineering material consumption model as the translation amount of the characteristic curve of various material consumption in each construction stage to be analyzed on the y axis.
And obtaining a sign of a predicted value correction amount of the engineering material consumption model, and further obtaining the translation direction of the characteristic curve of various material consumption in each construction stage to be analyzed on the y axis.
S4: according to the translation amount and translation direction of the characteristic curve of each material consumption in each construction stage to be analyzed on the y axis, translating the characteristic curve of each material consumption in each construction stage to be analyzed to obtain a corrected characteristic curve of each material consumption in each construction stage, obtaining a function corresponding to the corrected characteristic curve of each material consumption in each construction stage, recording the function as a relation function between the corrected engineering amount and each material consumption in each construction stage of the construction project, further obtaining a corrected material consumption model of the construction project, and feeding the corrected material consumption model back to a construction unit of the construction project.
Based on the above embodiment, the specific analysis procedure in the fifth step is: and acquiring the engineering quantity of the current construction stage of the construction project according to the engineering quantity list of the construction project.
And obtaining a relation function between the engineering quantity and various material consumption of each construction stage of the corrected construction project according to the corrected material consumption model of the construction project, and further screening to obtain a relation function between the engineering quantity and various material consumption of the current construction stage of the corrected construction project.
Substituting the engineering quantity of the current construction stage of the construction project into the corrected relation function between the engineering quantity of the current construction stage of the construction project and the consumption of various materials to obtain the estimated consumption of various materials of the current construction stage of the construction project.
On the basis of the above embodiment, the specific analysis process in the step six includes: acquiring a schedule of the current construction stage of the construction project, obtaining the project quantity of each working day of the current construction stage of the construction project, and marking the project quantity as，/>Indicating the current construction stage of the construction project>Number of working day>And the engineering quantity at the current construction stage of the construction engineering is recorded as +.>。
The estimated consumption of various materials at the current construction stage of the construction project is recorded as，/>Represents the +.>Numbering of class material>。
By analysis of formulasObtaining estimated consumption of various materials on each working day in the current construction stage of the construction project>。
On the basis of the foregoing embodiment, the specific analysis process in the sixth step further includes: the method comprises the steps of obtaining the existing quantity of various materials in the current construction stage of a construction project, comparing and analyzing the existing quantity of various materials in the current construction stage of the construction project with the estimated consumption quantity of various materials in each working day in the current construction stage of the construction project to obtain the estimated usable days of various materials in the current construction stage of the construction project, and marking the estimated usable days as。
On the basis of the foregoing embodiment, the specific analysis process in the sixth step further includes: by analysis of formulasObtaining stock tension coefficient of various materials at the current construction stage of a construction project>Wherein->Correction factor representing preset stock tension factor, < ->Representing natural constant->Representing the preset +.>Planned usage days for class material.
Compared with the prior art, the large-screen report quick construction display method based on the data warehouse has the following beneficial effects: 1. according to the invention, the estimated consumption and the existing quantity of various materials in the current construction stage of the construction project are obtained, the estimated available days and the inventory tension coefficient of various materials in the current construction stage of the construction project are analyzed by combining the schedule in the current construction stage of the construction project, feedback is carried out, and the situation of shortage or backlog of materials is found in time and corresponding measures are taken in advance by comprehensively and deeply analyzing the material data, so that the delay of the construction period or unnecessary expense caused by excessive materials due to insufficient material supply is avoided, and the smooth progress of the project is ensured.
2. According to the invention, the engineering quantity and the material consumption condition of each construction stage of the engineering project of the same type of engineering project are obtained, the material consumption model of the engineering project is constructed, and the material consumption model of the engineering project is corrected according to the engineering quantity and the material consumption information of each construction stage of the engineering project, so that the accuracy of the material consumption model of the engineering project is improved, and the accuracy of the material stock state analysis result based on the material consumption model is improved.
3. The invention prepares the material report form of the current construction stage of the construction project by acquiring the existing quantity, estimated usable days and inventory tension coefficient of various materials of the current construction stage of the construction project, and carries out visual, real-time and visual display on a liquid crystal display large screen, thereby leading project management personnel to be capable of visually finding out the problems related to the material supply in the construction process at the first time, ensuring that the material supply is matched with the project progress, and further improving the overall efficiency of the project.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic flow chart of the method of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. 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.
Referring to fig. 1, the method for quickly constructing and displaying a large-screen report based on a data warehouse provided by the invention comprises the following steps: step one, building a building engineering material consumption model: and acquiring each engineering project of the same type as the construction engineering in the construction unit history period, recording the engineering project as each history engineering project, acquiring the engineering quantity and the consumption quantity of various materials in each construction stage of each history engineering project, analyzing the relation function between the engineering quantity and the consumption quantity of various materials in each construction stage of the construction engineering, and constructing a material consumption model of the construction engineering.
As a preferred embodiment, the specific analysis process of the first step includes: setting the duration of a history period, acquiring each project built in the history period of a construction unit, further acquiring the type of each project built in the history period of the construction unit, acquiring the type of the construction project, screening and obtaining each project of the same type as the construction project built in the history period of the construction unit, recording the project as each history project, and acquiring the project amount of each construction stage of each history project and the consumption amount of various materials.
In another embodiment, the construction unit is a construction contractor.
The consumption of the material may be expressed in terms of the amount, volume, weight, or the like.
As a preferred embodiment, the specific analysis process of the first step further includes: the engineering quantity is taken as an independent variable, the consumption of materials is taken as a dependent variable, a reference coordinate system is established, the engineering quantity and the consumption of various materials in each historical engineering project are obtained according to the engineering quantity and the consumption of various materials in each construction stage of each historical engineering project, corresponding data points are marked in the reference coordinate system, a mathematical model establishing method is utilized to draw a change curve of the consumption of various materials in each construction stage along with the engineering quantity, the change curve is marked as a characteristic curve of the consumption of various materials in each construction stage, a function corresponding to the characteristic curve of the consumption of various materials in each construction stage is obtained, and the function is marked as a relation function between the engineering quantity and the consumption of various materials in each construction stage of the construction project, and a material consumption model of the construction project is established.
The construction stages of each history project are identical, and the construction stages of the construction project are identical to the construction stages of each history project.
Step two, predicting material consumption in a historical construction stage: and obtaining the engineering quantity of each construction stage of the construction project, and combining the engineering quantity with a material consumption model of the construction project to obtain the predicted consumption quantity of various materials of each construction stage of the construction project.
As a preferable scheme, the specific analysis process of the second step is as follows: and acquiring the engineering quantity of each construction stage of the construction project according to the engineering quantity list of the construction project.
And obtaining a relation function between the engineering quantity and various material consumption of each construction stage of the construction project according to the material consumption model of the construction project, and further screening to obtain a relation function between the engineering quantity and various material consumption of each construction stage of the construction project.
Substituting the engineering quantity of each construction stage of the construction project into a relation function between the engineering quantity of the construction stage and the consumption quantity of various materials to obtain the predicted consumption quantity of various materials of each construction stage of the construction project.
The construction amount of each construction stage of the construction project can be obtained by a construction plan, a construction design drawing or a construction scheme of the construction project.
Step three, material consumption in the historical construction stage is obtained: the actual consumption of various materials at each construction stage when the construction project is completed is obtained.
It should be noted that, the specific analysis process in the third step is as follows: and acquiring the actual consumption of various materials at each construction stage of the completed construction project through a purchasing department of the construction unit.
Fourth, building engineering material consumption model correction: judging whether the material consumption model of the construction project needs to be corrected according to the predicted consumption and the actual consumption of various materials in each construction stage of the construction project, if so, acquiring the corrected material consumption model of the construction project, and feeding back.
As a preferred embodiment, the specific analysis process in the fourth step includes: the predicted consumption and the actual consumption of various materials at each construction stage of the construction project are respectively recorded asAnd->，/>Indicating that the construction process is completed->Number of each construction stage->，/>Indicating +.>The number of the class material is given,。
by analysis of formulasObtaining the prediction accuracy of the material consumption model of the construction project>Wherein->Correction coefficient representing preset prediction accuracy of engineering material consumption model under construction, +.>Indicating the preset +.>Weight factor of each construction stage->，/>Indicating the preset +.>First part of the construction phase>Threshold value for the difference between the predicted consumption and the actual consumption of the class material, < >>Indicating the preset +.>Weight factor of class material->。
It should be noted that, the various materials consumed in each construction stage are different and not identical.
As a preferred embodiment, the specific analysis process in the fourth step further includes: s1: and comparing the prediction accuracy of the material consumption model of the construction project with a preset prediction accuracy threshold, and if the prediction accuracy of the material consumption model of the construction project is smaller than the preset prediction accuracy threshold, correcting the material consumption model of the construction project, and executing S2.
S2: each construction to be completed in the construction workPredicted consumption of various materials in stagesAnd actual consumption->Substitution of the analytical formula +.>Obtaining predicted value fluctuation coefficient of engineering material consumption model>WhereinIndicating the number of construction stages at which the construction has been completed, < > in>Indicating the number of types of materials at the stage of construction when the construction work has been completed.
By analysis of formulasObtaining predictive value correction amount of engineering material consumption model>Wherein->Reference adjustment quantity representing a preset model prediction value of the consumption of engineering material, < >>，/>And representing the compensation amount of the preset predicted value correction amount of the engineering material consumption model.
S3: and acquiring characteristic curves of various material consumption in each construction stage in a material consumption model of a construction project, and recording the characteristic curves as characteristic curves of various material consumption in each construction stage to be analyzed.
And taking the absolute value of the predicted value correction amount of the engineering material consumption model as the translation amount of the characteristic curve of various material consumption in each construction stage to be analyzed on the y axis.
And obtaining a sign of a predicted value correction amount of the engineering material consumption model, and further obtaining the translation direction of the characteristic curve of various material consumption in each construction stage to be analyzed on the y axis.
S4: according to the translation amount and translation direction of the characteristic curve of each material consumption in each construction stage to be analyzed on the y axis, translating the characteristic curve of each material consumption in each construction stage to be analyzed to obtain a corrected characteristic curve of each material consumption in each construction stage, obtaining a function corresponding to the corrected characteristic curve of each material consumption in each construction stage, recording the function as a relation function between the corrected engineering amount and each material consumption in each construction stage of the construction project, further obtaining a corrected material consumption model of the construction project, and feeding the corrected material consumption model back to a construction unit of the construction project.
It should be noted that the predicted value fluctuation coefficient of the engineering material consumption model may be positive or negative.
The predicted value correction amount of the engineering material consumption model can be positive or negative.
The method for acquiring the translation direction of the characteristic curve of consumption of various materials in each construction stage to be analyzed on the y axis comprises the following specific steps: acquiring a sign of a predicted value correction amount of a construction material consumption model, and if the sign of the predicted value correction amount of the construction material consumption model is positive, taking a translation direction of a characteristic curve of various material consumption in each construction stage to be analyzed on a y axis as an increasing direction, namely an upward direction; if the sign of the predicted value correction amount of the engineering material consumption model is negative, the translation direction of the characteristic curve of each material consumption in each construction stage to be analyzed on the y axis is the decreasing direction, namely the downward direction.
It should be noted that the translation amount and the translation direction of the characteristic curve of consumption of various materials in each construction stage to be analyzed are the same on the y axis.
The deviation between the predicted consumption and the actual consumption of the material at each construction stage when the construction is completed is used to evaluate whether the prediction of the material consumption model of the construction is accurate, and further fine-tuning the material consumption model of the construction is performed.
In the embodiment, the engineering quantity and the material consumption condition of each construction stage of the engineering project of the same type of engineering project are obtained, the material consumption model of the engineering project is built, and the material consumption model of the engineering project is corrected according to the engineering quantity and the material consumption information of each construction stage of the engineering project, so that the accuracy of the material consumption model of the engineering project is improved, and the accuracy of the material stock state analysis result based on the material consumption model is improved.
Fifthly, material consumption in the current construction stage is estimated: and acquiring the engineering quantity of the current construction stage of the construction engineering, and combining the corrected material consumption model of the construction engineering to obtain the estimated consumption quantity of various materials in the current construction stage of the construction engineering.
As a preferred scheme, the specific analysis process in the fifth step is as follows: and acquiring the engineering quantity of the current construction stage of the construction project according to the engineering quantity list of the construction project.
And obtaining a relation function between the engineering quantity and various material consumption of each construction stage of the corrected construction project according to the corrected material consumption model of the construction project, and further screening to obtain a relation function between the engineering quantity and various material consumption of the current construction stage of the corrected construction project.
Substituting the engineering quantity of the current construction stage of the construction project into the corrected relation function between the engineering quantity of the current construction stage of the construction project and the consumption of various materials to obtain the estimated consumption of various materials of the current construction stage of the construction project.
Step six, monitoring the stock state of the materials in the current construction stage: the method comprises the steps of obtaining a schedule of a current construction stage of a construction project and the existing quantity of various materials, and analyzing estimated usable days and inventory tension coefficients of various materials in the current construction stage of the construction project by combining the estimated consumption quantity of various materials in the current construction stage of the construction project.
As a preferred embodiment, the specific analysis in the step six includes: acquiring a schedule of the current construction stage of the construction project, obtaining the project quantity of each working day of the current construction stage of the construction project, and marking the project quantity as，/>Indicating the current construction stage of the construction project>Number of working day>And the engineering quantity at the current construction stage of the construction engineering is recorded as。
The estimated consumption of various materials at the current construction stage of the construction project is recorded as，/>Represents the +.>Numbering of class material>。
By analysis of formulasObtaining estimated consumption of various materials on each working day in the current construction stage of the construction project>。
As a preferred embodiment, the specific analysis process in the step six further includes: the method comprises the steps of obtaining the existing quantity of various materials in the current construction stage of a construction project, comparing and analyzing the existing quantity of various materials in the current construction stage of the construction project with the estimated consumption quantity of various materials in each working day in the current construction stage of the construction project to obtain the estimated usable days of various materials in the current construction stage of the construction project, and marking the estimated usable days as。
It should be noted that, the method for obtaining the estimated usable days of various materials in the current construction stage of the construction project specifically comprises the following steps: taking a method for obtaining estimated usable days of a certain type of materials in the current construction stage of a construction project as an example: accumulating estimated consumption of the materials in the current construction stage of the construction project on each working day by day until the estimated consumption of the materials accumulated in the working day and the working days before the working day is larger than the existing consumption of the materials in the current construction stage of the construction project, and recording the number of the working days before the working day as the estimated usable days of the materials in the current construction stage of the construction project.
And further obtaining the estimated usable days of various materials in the current construction stage of the construction project.
It should be noted that, purchasing materials in each construction stage of the construction project is generally performed in multiple times, so that the number of days available corresponding to the existing amount of various materials in the current construction stage of the construction project is smaller than the total number of days in the current construction stage.
As a preferred embodiment, the specific analysis process in the step six further includes: by analysis of formulasObtaining stock tension coefficient of various materials at the current construction stage of a construction project>Wherein->Correction factor representing preset stock tension factor, < ->Representing natural constant->Representing the preset +.>Planned usage days for class material.
In the embodiment, the estimated consumption and the existing quantity of various materials in the current construction stage of the construction project are obtained, and the estimated available days and the inventory tension coefficient of various materials in the current construction stage of the construction project are analyzed by combining the schedule in the current construction stage of the construction project, and are fed back, and the situation of shortage or backlog of the materials is found in time and corresponding measures are taken in advance by comprehensively and deeply analyzing the material data, so that the problem of delay of the construction period or unnecessary expense caused by excessive materials due to insufficient material supply is avoided, and the smooth progress of the project is ensured.
Step seven, generating and displaying a material report at the current construction stage: and constructing and displaying a material report at the current construction stage of the construction project according to the existing quantity, estimated usable days and inventory tension coefficient of various materials at the current construction stage of the construction project.
It should be noted that, the material report forms in the current construction stage of the construction project are displayed on the large-scale liquid crystal display screen in the form of tables.
In a specific embodiment, setting a range of inventory tension coefficients corresponding to each inventory tension degree, screening and obtaining the inventory tension degree of each material in the current construction stage of the construction project according to the inventory tension coefficient of each material in the current construction stage of the construction project, setting an early warning color corresponding to each inventory tension degree, screening and obtaining the early warning color of each material in the current construction stage of the construction project according to the inventory tension degree of each material in the current construction stage of the construction project, displaying a column of each material in a material report in the current construction stage of the construction project as the early warning color corresponding to the material, and feeding back to a purchasing department of a construction unit.
In one embodiment, the inventory tension is classified as severe tension, general tension and non-tension, and the corresponding pre-warning colors are red, orange and green, respectively.
In the embodiment, the present invention obtains the existing quantity, estimated available days and inventory tension coefficient of various materials in the current construction stage of the construction project, so as to manufacture a material report of the current construction stage of the construction project, and the material report is visually and real-time displayed on a liquid crystal display large screen, so that project management staff can visually discover the problems related to the material supply in the construction process at the first time, and ensure that the material supply is matched with the project progress, thereby improving the overall efficiency of the construction project.
The foregoing is merely illustrative and explanatory of the principles of this invention, as various modifications and additions may be made to the specific embodiments described, or similar arrangements may be substituted by those skilled in the art, without departing from the principles of this invention or beyond the scope of this invention as defined in the claims.
Claims (7)
1. A method for quickly constructing and displaying a large-screen report based on a data warehouse is characterized by comprising the following steps:
step one, building a building engineering material consumption model: acquiring each engineering project of the same type as a construction project in a construction unit history period, recording the engineering project as each history engineering project, acquiring the engineering quantity of each construction stage of each history engineering project and the consumption quantity of each material, analyzing a relation function between the engineering quantity of each construction stage of the construction project and the consumption quantity of each material, and constructing a material consumption model of the construction project;
step two, predicting material consumption in a historical construction stage: acquiring the engineering quantity of each construction stage of the construction project, and combining the engineering quantity with a material consumption model of the construction project to obtain the predicted consumption quantity of various materials of each construction stage of the construction project;
step three, material consumption in the historical construction stage is obtained: acquiring actual consumption of various materials at each construction stage of the construction project;
fourth, building engineering material consumption model correction: judging whether a material consumption model of the construction project needs to be corrected according to the predicted consumption and the actual consumption of various materials in each construction stage of the construction project, if so, acquiring the corrected material consumption model of the construction project, and feeding back;
fifthly, material consumption in the current construction stage is estimated: acquiring the engineering quantity of the current construction stage of the construction engineering, and combining the corrected material consumption model of the construction engineering to obtain the estimated consumption quantity of various materials in the current construction stage of the construction engineering;
step six, monitoring the stock state of the materials in the current construction stage: acquiring a schedule of a current construction stage of a construction project and the existing quantity of various materials, and analyzing estimated usable days and inventory tension coefficients of various materials in the current construction stage of the construction project by combining the estimated consumption quantity of various materials in the current construction stage of the construction project;
step seven, generating and displaying a material report at the current construction stage: according to the existing quantity, estimated usable days and inventory tension coefficient of various materials in the current construction stage of the construction project, a material report in the current construction stage of the construction project is constructed and displayed;
the specific analysis process of the fourth step comprises the following steps:
the predicted consumption and the actual consumption of various materials at each construction stage of the construction project are respectively recorded asAnd->，/>Indicating that the construction process is completed->Number of each construction stage->，/>Indicating +.>Numbering of class material>；
By analysis of formulasObtaining the prediction accuracy of the material consumption model of the construction project>Wherein->Correction coefficient representing preset prediction accuracy of engineering material consumption model under construction, +.>Indicating the preset +.>Weight factor of each construction stage->，/>Indicating the preset +.>First part of the construction phase>Threshold value for the difference between the predicted consumption and the actual consumption of the class material, < >>Indicating the preset +.>Weight factor of class material->；
The specific analysis process in the fourth step further comprises:
s1: comparing the prediction accuracy of the material consumption model of the construction project with a preset prediction accuracy threshold, if the prediction accuracy of the material consumption model of the construction project is smaller than the preset prediction accuracy threshold, correcting the material consumption model of the construction project, and executing S2;
s2: predicted consumption of various materials at each stage of construction where a construction project is to be completedAnd actual consumption->Substitution of the analytical formula +.>Obtaining predicted value fluctuation coefficient of engineering material consumption model>Wherein->Indicating the number of construction stages at which the construction has been completed, < > in>The variety and quantity of materials in the construction stage of the construction project are shown;
by analysis of formulasObtaining predictive value correction amount of engineering material consumption model>Wherein->Reference adjustment quantity representing a preset model prediction value of the consumption of engineering material, < >>，/>Representing a compensation amount of a preset predicted value correction amount of the engineering material consumption model;
s3: acquiring characteristic curves of various material consumption in each construction stage in a material consumption model of a construction project, and recording the characteristic curves as characteristic curves of various material consumption in each construction stage to be analyzed;
taking the absolute value of a predicted value correction amount of a construction material consumption model as the translation amount of a characteristic curve of various material consumption in each construction stage to be analyzed on a y axis;
acquiring a sign of a predicted value correction amount of a construction material consumption model, and further acquiring the translation direction of a characteristic curve of various material consumption in each construction stage to be analyzed on a y axis;
s4: according to the translation amount and translation direction of the characteristic curve of each material consumption in each construction stage to be analyzed on the y axis, translating the characteristic curve of each material consumption in each construction stage to be analyzed to obtain a corrected characteristic curve of each material consumption in each construction stage, obtaining a function corresponding to the corrected characteristic curve of each material consumption in each construction stage, recording the function as a relation function between the corrected engineering amount and each material consumption in each construction stage of a construction project, further obtaining a corrected material consumption model of the construction project, and feeding the corrected material consumption model back to a construction unit of the construction project;
by analysis of formulasObtaining stock tension coefficient of various materials at the current construction stage of a construction project>Wherein->Correction factor representing preset stock tension factor, < ->Representing natural constant->Representing the preset +.>Planned usage days of class material, +.>Represents the>The prediction of class material may be used for days.
2. The method for quickly constructing and displaying the large-screen report based on the data warehouse according to claim 1, which is characterized in that: the specific analysis process of the first step comprises the following steps:
setting the duration of a history period, acquiring each project built in the history period of a construction unit, further acquiring the type of each project built in the history period of the construction unit, acquiring the type of the construction project, screening and obtaining each project of the same type as the construction project built in the history period of the construction unit, recording the project as each history project, and acquiring the project amount of each construction stage of each history project and the consumption amount of various materials.
3. The method for quickly constructing and displaying the large-screen report based on the data warehouse according to claim 1, which is characterized in that: the specific analysis process of the first step further comprises:
the engineering quantity is taken as an independent variable, the consumption of materials is taken as a dependent variable, a reference coordinate system is established, the engineering quantity and the consumption of various materials in each historical engineering project are obtained according to the engineering quantity and the consumption of various materials in each construction stage of each historical engineering project, corresponding data points are marked in the reference coordinate system, a mathematical model establishing method is utilized to draw a change curve of the consumption of various materials in each construction stage along with the engineering quantity, the change curve is marked as a characteristic curve of the consumption of various materials in each construction stage, a function corresponding to the characteristic curve of the consumption of various materials in each construction stage is obtained, and the function is marked as a relation function between the engineering quantity and the consumption of various materials in each construction stage of the construction project, and a material consumption model of the construction project is established.
4. The method for quickly constructing and displaying the large-screen report based on the data warehouse according to claim 1, which is characterized in that: the specific analysis process of the second step is as follows:
acquiring the engineering quantity of each construction stage of the construction project according to the engineering quantity list of the construction project;
according to a material consumption model of the construction project, obtaining a relation function between the engineering quantity and various material consumption quantities of each construction stage of the construction project, and further screening to obtain a relation function between the engineering quantity and various material consumption quantities of each construction stage of the construction project;
substituting the engineering quantity of each construction stage of the construction project into a relation function between the engineering quantity of the construction stage and the consumption quantity of various materials to obtain the predicted consumption quantity of various materials of each construction stage of the construction project.
5. The method for quickly constructing and displaying the large-screen report based on the data warehouse according to claim 1, which is characterized in that: the specific analysis process in the fifth step is as follows:
acquiring the engineering quantity of the current construction stage of the construction project according to the engineering quantity list of the construction project;
obtaining a relation function between the engineering quantity and various material consumption of each construction stage of the corrected construction project according to the corrected material consumption model of the construction project, and further screening to obtain a relation function between the engineering quantity and various material consumption of the current construction stage of the corrected construction project;
substituting the engineering quantity of the current construction stage of the construction project into the corrected relation function between the engineering quantity of the current construction stage of the construction project and the consumption of various materials to obtain the estimated consumption of various materials of the current construction stage of the construction project.
6. The method for quickly constructing and displaying the large-screen report based on the data warehouse according to claim 1, which is characterized in that: the specific analysis process in the step six comprises the following steps:
acquiring a schedule of the current construction stage of the construction project, obtaining the project quantity of each working day of the current construction stage of the construction project, and marking the project quantity as，/>Representation ofThe current construction stage of the construction project>Number of working day>And the engineering quantity at the current construction stage of the construction engineering is recorded as +.>；
The estimated consumption of various materials at the current construction stage of the construction project is recorded as，/>Representing the current construction stageNumbering of class material>；
By analysis of formulasObtaining estimated consumption of various materials on each working day in the current construction stage of the construction project>。
7. The method for quickly constructing and displaying the large-screen report based on the data warehouse, which is characterized by comprising the following steps of: the specific analysis process in the step six further includes:
acquiring the existing quantity of various materials in the current construction stage of the construction project, and combining the existing quantity of various materials in the current construction stage of the construction project with the current construction of the construction projectThe estimated consumption of various materials in each working day is compared and analyzed to obtain the estimated usable days of various materials in the current construction stage of the construction project, and the estimated usable days are recorded as。
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410058081.4A CN117575475B (en) | 2024-01-16 | 2024-01-16 | Quick construction and display method for large-screen report based on data warehouse |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410058081.4A CN117575475B (en) | 2024-01-16 | 2024-01-16 | Quick construction and display method for large-screen report based on data warehouse |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117575475A CN117575475A (en) | 2024-02-20 |
| CN117575475B true CN117575475B (en) | 2024-04-12 |
Family
ID=89884875
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410058081.4A Active CN117575475B (en) | 2024-01-16 | 2024-01-16 | Quick construction and display method for large-screen report based on data warehouse |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117575475B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2645191A1 (en) * | 2012-03-28 | 2013-10-02 | ABB Research Ltd. | A method for visualizing material flow of raw or semi-processed material in a process control system |
| KR101322504B1 (en) * | 2012-04-30 | 2013-10-28 | 연세대학교 산학협력단 | System and method for evaluating economic and environmental impact assessment through estimating construction cost and co2 emission |
| CN105139090A (en) * | 2015-08-25 | 2015-12-09 | 国网天津市电力公司 | Power industry safety stock decision analysis method based on consumption prediction |
| CN113537945A (en) * | 2021-08-04 | 2021-10-22 | 四川隧唐科技股份有限公司 | Automatic analysis method and device for capital construction material excess saving |
| CN116362432A (en) * | 2023-06-02 | 2023-06-30 | 深圳市大司建设集团有限公司 | Engineering material consumption prediction method based on interior decoration |
| CN116384595A (en) * | 2023-06-05 | 2023-07-04 | 中铁四局集团有限公司 | Project progress prediction analysis method based on cost linkage |
| CN117291506A (en) * | 2023-11-24 | 2023-12-26 | 山东天振药业有限公司 | Raw material inventory data intelligent management system based on liquid veterinary drug production |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030018516A1 (en) * | 2001-07-20 | 2003-01-23 | International Business Machines Corporation | Method for dynamically evaluating projected days of supply of inventory levels in a supply chain |
| TWI793412B (en) * | 2020-03-31 | 2023-02-21 | 廣達電腦股份有限公司 | Consumption prediction system and consumption prediction method |
-
2024
- 2024-01-16 CN CN202410058081.4A patent/CN117575475B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2645191A1 (en) * | 2012-03-28 | 2013-10-02 | ABB Research Ltd. | A method for visualizing material flow of raw or semi-processed material in a process control system |
| KR101322504B1 (en) * | 2012-04-30 | 2013-10-28 | 연세대학교 산학협력단 | System and method for evaluating economic and environmental impact assessment through estimating construction cost and co2 emission |
| CN105139090A (en) * | 2015-08-25 | 2015-12-09 | 国网天津市电力公司 | Power industry safety stock decision analysis method based on consumption prediction |
| CN113537945A (en) * | 2021-08-04 | 2021-10-22 | 四川隧唐科技股份有限公司 | Automatic analysis method and device for capital construction material excess saving |
| CN116362432A (en) * | 2023-06-02 | 2023-06-30 | 深圳市大司建设集团有限公司 | Engineering material consumption prediction method based on interior decoration |
| CN116384595A (en) * | 2023-06-05 | 2023-07-04 | 中铁四局集团有限公司 | Project progress prediction analysis method based on cost linkage |
| CN117291506A (en) * | 2023-11-24 | 2023-12-26 | 山东天振药业有限公司 | Raw material inventory data intelligent management system based on liquid veterinary drug production |
Non-Patent Citations (2)
| Title |
|---|
| 基于BIM的工程项目施工阶段成本动态控制研究;高睿;;建筑知识;20170323(06);全文 * |
| 施工企业工程项目材料控制探析;祁有丽;;价值工程;20200518(14);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117575475A (en) | 2024-02-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7006878B2 (en) | Computer-implemented method for analyzing a problem statement based on an integration of Six Sigma, Lean Manufacturing, and Kaizen analysis techniques | |
| US8989887B2 (en) | Use of prediction data in monitoring actual production targets | |
| US7058544B2 (en) | Knowledge-based condition survey inspection (KBCSI) framework and procedure | |
| EP1450285A1 (en) | A computer-implemented system and method for improving manufacturing productivity | |
| US20060184414A1 (en) | Business management tool | |
| US20150134545A1 (en) | Structure Modelling and Maintenance Scheduling | |
| CN110941797B (en) | Operation index monitoring and trend prediction system based on service index | |
| CN113760625B (en) | Evaluation method and monitoring system for model predictive controller performance | |
| Ungermann et al. | Data analytics for manufacturing systems–a data-driven approach for process optimization | |
| CN117709617A (en) | MES-based intelligent scheduling system for production workshop | |
| CN117575475B (en) | Quick construction and display method for large-screen report based on data warehouse | |
| CN117114386B (en) | Workflow management system for designer and industrial worker | |
| CN117171145B (en) | Analysis processing method, equipment and storage medium for enterprise management system data | |
| Wang et al. | Multifactor uncertainty analysis of prefabricated building supply chain: Qualitative comparative analysis | |
| US9678487B1 (en) | System and method for allocating a fixed quantity distributed over a set of quantities | |
| CN117114446A (en) | Device health assessment method based on data driving | |
| Sinclair et al. | Going beyond SPC—why we need statistical thinking in operations such as Carbon Plants | |
| Bumba et al. | KPI tree-a hierarchical relationship structure of key performance indicators for value streams | |
| RU2503015C2 (en) | System to control power consumption of industrial enterprises and production facilities | |
| US8311870B1 (en) | Computer-implemented method and computer program to assist in managing supplier capacity | |
| Nestic et al. | Optimization of the maintenance process using genetic algorithms | |
| Gafurov et al. | Existing ways to increase energy efficiency in industrial enterprises | |
| Ismail et al. | Forecasting of foreign labor demand in Malaysia’s construction sector | |
| Oppenheim | Energy Conservation: Lean Manufacturing | |
| CN111667309B (en) | Medium-long term prediction method for living necessities |
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 |