Algorithm for calculating engineering cost dynamic index

Abstract

The invention belongs to the technical field of engineering cost dynamic index calculation, particularly relates to an algorithm for calculating an engineering cost dynamic index, and aims to solve the problems that the existing static cost index cannot reflect the influence of market condition change and technical progress, is difficult to be used for long-term planning and decision making, and cannot reflect the difference of engineering cost indexes and rates in different regions. In order to solve the problem that project data cannot be reused under the condition of large material and labor cost difference in the prior art, the invention provides the following scheme: the method comprises the following steps: S1, preparing a computing system which comprises a data acquisition module and a database module, the data acquisition module is connected with an engineering project data module and a data arrangement module, and the database module is connected with the engineering project data module; according to the method, reference can be provided for investment decision-making of proposed projects with similar or similar construction standards in the use process, adjustment can be performed according to market conditions of different time points and different regions, price differences can be reflected, and project cost estimation is more accurate.

Description

Technical Field

[0001] The invention relates to the technical field of engineering cost dynamic index calculation, and in particular to an algorithm for calculating the engineering cost dynamic index. Background Art

[0002] Engineering cost index refers to the process of establishing a complete set of engineering cost indexes by analyzing and comparing the design estimate, construction drawing budget and project completion settlement of completed engineering projects to obtain a series of price and quantity indicators that can reflect the characteristics of the project, and using a scientific and systematic method. The algorithm of dynamic engineering cost index mainly involves the dynamic calculation method, which is a method that considers the time value of money. In the analysis process of engineering cost index, most of them use static engineering cost index to provide a reference for project cost estimation, budget control and decision-making.

[0003] In the existing technology, static cost indicators cannot reflect the impact of market changes and technological progress, and are difficult to use for long-term planning and decision-making. They cannot also reflect the differences in engineering cost indices and rates in different regions. Especially when there are large differences in material and labor costs, project data cannot be reused. For this reason, we propose an algorithm for calculating dynamic indicators of engineering cost to solve the above problems. Summary of the invention

[0004] The purpose of the present invention is to solve the shortcomings of the prior art that static cost indicators cannot reflect the impact of market changes and technological progress, are difficult to use for long-term planning and decision-making, and cannot reflect the differences in engineering cost indices and rates in different regions, especially when there are large differences in material and labor costs, and cannot reuse project data. An algorithm for calculating dynamic indicators of engineering cost is proposed.

[0005] The algorithm for calculating the dynamic index of engineering cost provided in this application adopts the following technical solution:

[0006] An algorithm for calculating a dynamic index of engineering cost includes the following steps:

[0007] S1: Prepare a computing system, the computing system comprising a data acquisition module and a database module, the data acquisition module is connected to an engineering project data module and a data sorting module, the data sorting module is connected to a model selection module, the model selection module is connected to a computing module, the database module is connected to a basic data configuration module, the basic data configuration module is connected to a coefficient adjustment module, the coefficient adjustment module is connected to a benchmark selection module, the benchmark selection module is connected to a partitioning module, the benchmark selection module is connected to a computing module, the computing module is connected to a dynamic adjustment module and a monitoring module, the dynamic adjustment module is connected to a result output module, the result output module is connected to a verification module, the verification module is connected to a feedback optimization module, the monitoring module is connected to an analysis module, the analysis module is connected to a comparison module, the comparison module is connected to a strategy formulation module, the strategy formulation module is connected to a historical data module, and the historical data module is connected to a model selection module;

[0008] S2: First, the basic data and cost data of the engineering project are obtained through the data acquisition module and the engineering project data module, the collected data are preprocessed and structured through the data sorting module, the calculation module is selected through the model selection module to calculate the dynamic index, and the appropriate benchmark cost is selected through the benchmark selection module, the coefficient adjustment module adjusts the benchmark cost coefficient, and the dynamic index is calculated through the calculation module;

[0009] S3: Then, the calculated dynamic index data is transmitted to the dynamic adjustment module. The dynamic adjustment module adjusts the benchmark cost according to the calculated dynamic index. The result output module outputs the adjusted cost result. The verification module verifies and tests each module. The feedback optimization module adjusts and optimizes the algorithm according to the verification result.

[0010] S4: Finally, the monitoring module monitors the calculation process in real time, the analysis module conducts in-depth analysis of the calculated dynamic indicators, the comparison module compares and evaluates the dynamic indicators with the budget, plan or actual value, and then formulates the corresponding engineering cost management strategy through the strategy formulation module. At the same time, the historical data module can store and analyze the calculated historical data, and use the collected historical data to calibrate and optimize the calculation module in the model selection module.

[0011] Furthermore, the engineering project data module includes a project data unit, a material data unit and a construction method data unit, the project data unit is connected to the material data unit, and the material data unit is connected to the construction method data unit.

[0012] Furthermore, the division module includes a time division unit, a location division unit and a cycle selection unit, the time division unit is connected to the location division unit, and the location division unit is connected to the cycle selection unit.

[0013] Furthermore, the verification module includes a unit test unit, an integrated test unit and a verification unit, the unit test unit is connected to the integrated test unit, and the integrated test unit is connected to the verification unit.

[0014] Furthermore, the data sorting module is used to clean the collected data, eliminate abnormal values ​​and format the data, and transmit the processed data to the calculation module.

[0015] Furthermore, the database module is used to store historical data and system configuration, the basic data configuration module is used to configure basic data for engineering cost calculation, and the coefficient adjustment module is used to adjust the benchmark cost coefficient.

[0016] Furthermore, the data collection module is used to collect regional price index, material supply price, and labor cost data, and the engineering project data module is used to collect cost data of different projects, different materials, and different construction methods.

[0017] Furthermore, the calculation module includes a calculation method selection unit, a calculation unit and a judgment unit, the calculation method selection unit is connected to the calculation unit, and the calculation unit is connected to the judgment unit.

[0018] Furthermore, the benchmark selection module includes a benchmark selection unit, an indicator generation unit and an indicator entry review unit, the benchmark selection unit is connected to the indicator generation unit, and the indicator generation unit is connected to the indicator entry review unit.

[0019] Furthermore, the data acquisition module includes a data cleaning unit, an exception processing unit and a format adjustment unit, the data cleaning unit is connected to the exception processing unit, and the exception processing unit is connected to the format adjustment unit.

[0020] In summary, the present application includes at least one of the following beneficial technical effects:

[0021] 1. This solution can divide the time point, location and period of the project by setting up the division module. The calculation module and dynamic adjustment module can be adjusted according to the market conditions at different time points and in different regions to reflect the price differences and make the project cost estimation more accurate;

[0022] 2. This solution can monitor the calculation process in real time through the monitoring module, conduct in-depth analysis of the calculated dynamic indicators through the analysis module, compare and evaluate the dynamic indicators with the budget, plan or actual value, and then formulate the corresponding engineering cost management strategy through the strategy formulation module.

[0023] During use, the present invention can provide a reference for investment decisions of planned projects of the same or similar construction standards, and can be adjusted according to market conditions at different points in time and in different regions to reflect price differences, thereby making project cost estimates more accurate. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1 This is a structural block diagram of a calculation system in an algorithm for calculating dynamic indicators of engineering cost proposed by the present invention;

[0025] Figure 2 This is a structural block diagram of a data acquisition module in an algorithm for calculating dynamic indicators of engineering cost proposed by the present invention;

[0026] Figure 3 It is a structural block diagram of a project data module in an algorithm for calculating dynamic indicators of project cost proposed by the present invention;

[0027] Figure 4 It is a structural block diagram of a benchmark selection module in an algorithm for calculating dynamic indicators of engineering cost proposed by the present invention;

[0028] Figure 5 A structural block diagram of the modules in the algorithm for calculating the dynamic index of engineering cost proposed by the present invention;

[0029] Figure 6 A structural block diagram of a calculation module in an algorithm for calculating dynamic indicators of engineering cost proposed by the present invention;

[0030] Figure 7 It is a structural block diagram of a verification module in an algorithm for calculating dynamic indicators of engineering cost proposed by the present invention;

[0031] Figure 8 The present invention provides a flow chart for the production of dynamic indicators in an algorithm for calculating dynamic indicators of engineering cost. DETAILED DESCRIPTION

[0032] The technical solutions in the embodiments of the present invention will be described clearly and completely below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all the embodiments.

[0033] Embodiment 1

[0034] Reference Figure 1-Figure 8, an algorithm for calculating the dynamic index of engineering cost, comprising the following steps:

[0035] S1: Prepare a computing system, which includes a data acquisition module and a database module. The data acquisition module is connected to an engineering project data module and a data sorting module. The data sorting module is connected to a model selection module, which is connected to a computing module. The model selection module includes regression analysis, index calculation, and weighted average.

[0036] Regression analysis model:

[0037] Regression analysis model algorithm is a statistical analysis method used in statistics to determine the quantitative relationship between two or more variables that are interdependent. It can be divided into univariate regression and multivariate regression analysis according to the number of variables involved; it can be divided into simple regression analysis and multiple regression analysis according to the number of dependent variables; it can be divided into linear regression analysis and nonlinear regression analysis according to the type of relationship between independent variables and dependent variables;

[0038] The formula of the regression analysis model algorithm mainly involves the multivariate linear regression model, and its basic formula is:

[0039] y=β0+β1x1+β2x2+…+β p x p +ε

[0040] Among them: 1. y is the dependent variable, that is, the variable we need to predict;

[0041] 2. β0 is the intercept term, which represents the expected value of the dependent variable when all independent variables are zero;

[0042] 3. β1,β2,...,β P is the regression coefficient of each variable, indicating the degree of influence of each variable on the dependent variable;

[0043] 4. x1,x2,...,x p is the independent variable, i.e., the characteristic or variable we use to predict the dependent variable;

[0044] 5. ε is the error term, which represents the part that the model cannot explain;

[0045] Index calculation model:

[0046] Index calculation refers to an important mathematical model of the laws of change of the objective world that needs to be described by different function models and used to solve some simple practical problems;

[0047] Weighted average model:

[0048] The formula for calculating the weighted average is: The weighted average is the average of data of different weights, that is, the original data is calculated according to a reasonable proportion. If there is a set of x1, x2, ..., x k , the number of times they appear is f1,f2,...,f k , then the weighted average of this group of numbers can be calculated by the following formula:

[0049]

[0050] This formula reflects that for each value x i Contribution to its overall mean, where f i is each value x i The concept of weighted average is widely used in statistics, mathematics and other fields that need to deal with data of different proportions.

[0051] The database module is connected to the basic data configuration module, the basic data configuration module is connected to the coefficient adjustment module, the coefficient adjustment module is connected to the benchmark selection module, the benchmark selection module is connected to the division module, the benchmark selection module is connected to the calculation module, the calculation module is connected to the dynamic adjustment module and the monitoring module, the dynamic adjustment module is connected to the result output module, the result output module is connected to the verification module, the verification module is connected to the feedback optimization module, the monitoring module is connected to the analysis module, the analysis module is connected to the comparison module, the comparison module is connected to the strategy formulation module, the strategy formulation module is connected to the historical data module, the historical data module is connected to the model selection module, the data acquisition module includes a data cleaning unit, an exception processing unit and a format adjustment unit, the data cleaning unit is connected to the exception processing unit, the exception processing unit The unit is connected with the format adjustment unit, the engineering project data module includes a project data unit, a material data unit and a construction method data unit, the project data unit is connected with the material data unit, the material data unit is connected with the construction method data unit, the data acquisition module is used to collect regional price index, material supply price, and labor cost data, the engineering project data module is used to collect cost data of different projects, different materials and different construction methods, the data sorting module is used to clean the collected data, exclude abnormal values ​​and format the data, and transmit the processed data to the calculation module, the database module is used to store historical data and system configuration, the basic data configuration module is used to configure the basic data for engineering cost calculation, and the coefficient adjustment module is used to adjust the benchmark cost coefficient;

[0052] S2: First, the basic data and cost data of the engineering project are obtained through the data acquisition module and the engineering project data module, the collected data are preprocessed and structured through the data sorting module, the calculation module is selected through the model selection module to calculate the dynamic index, and the appropriate benchmark cost is selected through the benchmark selection module, the coefficient adjustment module adjusts the benchmark cost coefficient, and the dynamic index is calculated through the calculation module;

[0053] S3: Then, the calculated dynamic index data is transmitted to the dynamic adjustment module. The dynamic adjustment module adjusts the benchmark cost according to the calculated dynamic index. The result output module outputs the adjusted cost result. The verification module verifies and tests each module. The feedback optimization module adjusts and optimizes the algorithm according to the verification result.

[0054] S4: Finally, the monitoring module monitors the calculation process in real time, the analysis module conducts in-depth analysis of the calculated dynamic indicators, the comparison module compares and evaluates the dynamic indicators with the budget, plan or actual value, and then formulates the corresponding engineering cost management strategy through the strategy formulation module. At the same time, the historical data module can store and analyze the calculated historical data, and use the collected historical data to calibrate and optimize the calculation module in the model selection module.

[0055] Reference Figure 4-Figure 8 The benchmark selection module includes a benchmark selection unit, an indicator generation unit and an indicator entry review unit, the benchmark selection unit is connected to the indicator generation unit, the indicator generation unit is connected to the indicator entry review unit, the division module includes a time division unit, a location division unit and a cycle selection unit, the time division unit is connected to the location division unit, the location division unit is connected to the cycle selection unit, the calculation module includes a calculation method selection unit, a calculation unit and a judgment unit, the calculation method selection unit is connected to the calculation unit, the calculation unit is connected to the judgment unit, the calculation method selection unit includes a month-on-month index method, a fixed base index method and a harmonic mean method;

[0056] Month-on-month index method:

[0057] The month-on-month index is a statistical tool used to measure the development of a phenomenon from period to period. It is compiled by comparing the commodity prices in each period with the commodity prices in the previous period, and can reflect the changes in the price level from period to period. The month-on-month index is divided into the month-on-month index, the quarterly index and the year-on-year index. The year-on-year index takes the same period of the previous year as the base period and 100 as the base number, reflecting the price changes of each month and quarter of the current year compared with the same month and quarter of the previous year;

[0058] The calculation formula of the month-on-month price index method is: month-on-month price index = (price of this statistical period / price of the previous statistical period) × 100%. This formula is used to calculate the price changes of two adjacent statistical periods. By comparing the prices of the two periods, the month-on-month price index can be obtained to understand the price fluctuations.

[0059] Fixed base index method:

[0060] The fixed base index is closely related to the month-on-month index. When constant weights are used, the quotient of two adjacent fixed base indices is equal to the month-on-month index. In addition, the calculation of the fixed base index also includes the step-by-step weighted average calculation of the category and the total index.

[0061] Index = (current period index value ÷ base period index value) x 100;

[0062] The current period index value refers to the current statistical index value, and the base period index value refers to the index value of the reference base period. Divide the current period index value by the base period index value, and then multiply by 100 to get the fixed base index.

[0063] Harmonic mean method:

[0064] The formula for the harmonic mean is: H = n / (1 / x1+1 / x2+1 / x3+·+1 / xn);

[0065] Where n represents the number of data, x1, x2, x3…xn represent the values ​​of the data;

[0066] The verification module includes a unit test unit, an integrated test unit and a verification unit. The unit test unit is connected to the integrated test unit, and the integrated test unit is connected to the verification unit.

[0067] The implementation principle in this embodiment is: when in use, the basic data and cost data of the engineering project are obtained through the data acquisition module and the engineering project data module, the collected data is preprocessed and structured through the data sorting module, the calculation module is selected through the model selection module to calculate the dynamic index, and the appropriate benchmark cost is selected through the benchmark selection module. The coefficient adjustment module adjusts the benchmark cost coefficient, the dynamic index is calculated by the calculation module, and the calculated dynamic index data is transmitted to the dynamic adjustment module. The dynamic adjustment module adjusts the benchmark cost according to the calculated dynamic index, the result output module outputs the adjusted cost result, the verification module verifies and tests each module, the feedback optimization module adjusts and optimizes the algorithm according to the verification result, the monitoring module monitors the calculation process in real time, the analysis module conducts in-depth analysis of the calculated dynamic index, the comparison module compares and evaluates the dynamic index with the budget, plan or actual value, and then the corresponding engineering cost management strategy is formulated through the strategy formulation module. At the same time, the historical data module can store and analyze the calculated historical data, and use the collected historical data to calibrate and optimize the calculation module in the model selection module.

[0068] Embodiment 2

[0069] The difference between this embodiment and the first embodiment is that the data acquisition module is connected to the engineering information feature unification module, and the engineering information feature unification module is used to specify a standard entry template to ensure that the engineering information feature entry is comprehensive and clear.

[0070] Embodiment 3

[0071] The difference between this embodiment and the second embodiment is that the model selection module is connected to the model matching module, and the model matching module is used to automatically match the calculation model according to the selected calculation method, so as to further improve the calculation efficiency of the dynamic index of the cost.

[0072] Embodiment 4

[0073] The difference between this embodiment and the third embodiment is that the result output module is connected to a report generation and display module, and the report generation and display module is used to display the calculated indicator data to the user in an intuitive manner.

[0074] Embodiment 5

[0075] The difference between this embodiment and the fourth embodiment is that the calculation module is connected to an automatic estimation module, and the automatic estimation module is used to automatically generate a project estimation framework to improve the calculation efficiency of dynamic cost indicators.

[0076] Experimental example

[0077] By comparing the calculation schemes of the dynamic indicators of engineering cost proposed in Examples 1 to 5 with the conventional calculation schemes of the dynamic indicators of engineering cost, the experimental data are as follows:

[0078]

[0079] The above description is only a preferred specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any technician familiar with the technical field can make equivalent replacements or changes according to the technical scheme and inventive concept of the present invention within the technical scope disclosed by the present invention, which should be covered by the protection scope of the present invention.

Claims

1. An algorithm for calculating dynamic indicators of construction cost, characterized in that: The following steps are involved: S1: Prepare a computing system, the computing system comprising a data acquisition module and a database module, the data acquisition module is connected to an engineering project data module and a data sorting module, the data sorting module is connected to a model selection module, the model selection module is connected to a computing module, the database module is connected to a basic data configuration module, the basic data configuration module is connected to a coefficient adjustment module, the coefficient adjustment module is connected to a benchmark selection module, the benchmark selection module is connected to a partitioning module, the benchmark selection module is connected to a computing module, the computing module is connected to a dynamic adjustment module and a monitoring module, the dynamic adjustment module is connected to a result output module, the result output module is connected to a verification module, the verification module is connected to a feedback optimization module, the monitoring module is connected to an analysis module, the analysis module is connected to a comparison module, the comparison module is connected to a strategy formulation module, the strategy formulation module is connected to a historical data module, and the historical data module is connected to a model selection module; S2: First, the basic data and cost data of the engineering project are obtained through the data acquisition module and the engineering project data module, the collected data are preprocessed and structured through the data sorting module, the calculation module is selected through the model selection module to calculate the dynamic index, and the appropriate benchmark cost is selected through the benchmark selection module, the coefficient adjustment module adjusts the benchmark cost coefficient, and the dynamic index is calculated through the calculation module; S3: Then, the calculated dynamic index data is transmitted to the dynamic adjustment module. The dynamic adjustment module adjusts the benchmark cost according to the calculated dynamic index. The result output module outputs the adjusted cost result. The verification module verifies and tests each module. The feedback optimization module adjusts and optimizes the algorithm according to the verification result. S4: Finally, the monitoring module monitors the calculation process in real time, the analysis module conducts in-depth analysis of the calculated dynamic indicators, the comparison module compares and evaluates the dynamic indicators with the budget, plan or actual value, and then formulates the corresponding engineering cost management strategy through the strategy formulation module. At the same time, the historical data module can store and analyze the calculated historical data, and use the collected historical data to calibrate and optimize the calculation module in the model selection module.

2. The algorithm for calculating the dynamic index of construction cost according to claim 1 is characterized in that: The data acquisition module comprises a data cleaning unit, an exception processing unit and a format adjustment unit. The data cleaning unit is connected to the exception processing unit, and the exception processing unit is connected to the format adjustment unit.

3. The algorithm for calculating the dynamic index of construction cost according to claim 2 is characterized in that: The engineering project data module includes a project data unit, a material data unit and a construction method data unit. The project data unit is connected to the material data unit, and the material data unit is connected to the construction method data unit.

4. The algorithm for calculating the dynamic index of construction cost according to claim 3 is characterized in that: The benchmark selection module includes a benchmark selection unit, an indicator generation unit and an indicator entry review unit. The benchmark selection unit is connected to the indicator generation unit, and the indicator generation unit is connected to the indicator entry review unit.

5. The algorithm for calculating the dynamic index of construction cost according to claim 4 is characterized in that: The division module includes a time division unit, a location division unit and a cycle selection unit, wherein the time division unit is connected to the location division unit, and the location division unit is connected to the cycle selection unit.

6. The algorithm for calculating the dynamic index of construction cost according to claim 5 is characterized in that: The calculation module includes a calculation method selection unit, a calculation unit and a judgment unit. The calculation method selection unit is connected to the calculation unit, and the calculation unit is connected to the judgment unit.

7. The algorithm for calculating the dynamic index of construction cost according to claim 6 is characterized in that: The verification module includes a unit test unit, an integrated test unit and a verification unit. The unit test unit is connected to the integrated test unit, and the integrated test unit is connected to the verification unit.

8. The algorithm for calculating the dynamic index of construction cost according to claim 7 is characterized in that: The data collection module is used to collect regional price index, material supply price, and labor cost data, and the engineering project data module is used to collect cost data of different projects, different materials, and different construction methods.

9. The algorithm for calculating the dynamic index of construction cost according to claim 8 is characterized in that: The data sorting module is used to clean the collected data, eliminate outliers and format the data, and transmit the processed data to the calculation module.

10. The algorithm for calculating the dynamic index of construction cost according to claim 9 is characterized in that: The database module is used to store historical data and system configuration, the basic data configuration module is used to configure the basic data for engineering cost calculation, and the coefficient adjustment module is used to adjust the benchmark cost coefficient.

Images