Distribution network business expansion project settlement data processing method

Abstract

The invention relates to the technical field of electric power engineering, in particular to a distribution network business expansion project settlement data processing method. Firstly, a network system is established, historical archives of past project detailed data are comprehensively collected, and a dynamic fluctuation coefficient and a stability index of project cost are calculated according to the historical archives. And the construction party, the construction party and the auditing party input engineering information through the network system, and the engineering progress comprehensive evaluation index is calculated by combining the coefficients and the indexes. Analyzing the project settlement review file, and calculating the Pearson's correlation coefficient between the risk adjustment coefficient and the project amount and the cost for the fund with the amount dispute and the metering error; and the cost and the reliability after adjustment are calculated by combining the two coefficients and are displayed to an auditing party, and the auditing party issues an adjustment suggestion. And the construction party communicates with the construction party according to the adjustment opinion to determine whether to adjust the cost, further calculates the settlement amount, exports a full-aperture settlement report, and stores data into a historical file after settlement is completed.

Description

Technical Field

[0001] The present invention relates to the technical field of power engineering, and in particular, to a method for processing settlement data of distribution network business expansion projects. Background Art

[0002] At present, with the booming development of the power industry, the distribution network business expansion project, as a key link in the power supply system, shoulders the important task of providing power support for new user access and existing user capacity increase. With the acceleration of the urbanization process and the continuous expansion of various industries, the quantity and scale of distribution network business expansion projects have shown a rapid growth trend.

[0003] There are many drawbacks in the traditional method for processing settlement data of distribution network business expansion projects. On the one hand, in the data collection link, the data of past distribution network business expansion projects are scattered in various project documents and in the hands of different participants, lacking comprehensive and systematic collection and integration, resulting in frequent problems such as data missing and inconsistent formats, seriously affecting the accuracy and integrity of subsequent data analysis. On the other hand, in the settlement process, there is poor information communication among the construction party, the construction side, and the auditing side. There are differences in the project information recorded by each party, and there is no scientific and unified standard for project progress assessment, making it difficult to accurately determine the comprehensive assessment index of the project progress. At the same time, when analyzing the project settlement submission documents, there are no effective quantitative calculation means and risk assessment mechanisms for issues such as amount disputes and measurement errors, resulting in a lack of reasonable basis for cost adjustment during the settlement process and prone to disputes among all parties. In addition, the traditional settlement method is difficult to conduct dynamic analysis and cost prediction based on historical project data, unable to effectively cope with the dynamic fluctuations and stability changes of project costs. When determining the final settlement amount, it also fails to fully consider the actual situation of the project and various influencing factors, resulting in a significant reduction in the reliability and rationality of the settlement result. Summary of the Invention

[0004] In order to completely solve the problems existing in the traditional processing of settlement data of distribution network business expansion projects, such as difficult data collection and integration leading to missing data and inconsistent formats, poor information communication among all parties and non-uniform progress assessment standards, lack of effective means in analyzing submission documents resulting in insufficient basis for cost adjustment, and difficulty in dynamic analysis and prediction of costs based on historical data, the present invention provides the following technical solutions:

[0005] A method for processing settlement data of distribution network business expansion projects, characterized by comprising the following steps:

[0006] S1: Establish a network system and historical archives, and calculate the dynamic fluctuation coefficient and stability index of the project cost based on the historical archives. The historical archives store various cost data of past distribution network business expansion projects, including material costs and labor costs in different periods. By performing time series analysis on these historical cost data, calculate the change range of costs in different time periods, and thus obtain the dynamic fluctuation coefficient, which reflects the fluctuation of costs over time. The stability index is obtained by analyzing statistical characteristics such as the dispersion degree of cost data, and is used to measure the stability degree of cost data. These two indexes provide a basis for subsequent evaluation of the reasonableness of project costs.

[0007] S2: The construction party, the construction side, and the auditing side input project information, and combine the dynamic fluctuation coefficient and stability index to calculate the comprehensive evaluation index of the project progress. The project information input by the three parties covers various aspects such as project progress and resource investment. The dynamic fluctuation coefficient and stability index reflect the change characteristics of costs. Combine them with the actual project progress situation. For example, if the cost fluctuates greatly but the project progress is advancing as planned, it indicates that there may be cost management risks. Through a specific algorithm, comprehensively consider these factors to obtain the comprehensive evaluation index, which can comprehensively reflect the actual state of the project progress and the potential risks related to costs, and provide a reference for subsequent payment calculation.

[0008] S3: Analyze the project settlement submission documents, calculate the risk adjustment coefficient for the amounts in dispute and measurement errors in them in combination with the comprehensive evaluation index, and then calculate the Pearson correlation coefficient between the project quantity and the cost. In the project settlement submission documents, for the disputed and incorrect amounts, the comprehensive evaluation index reflects the overall progress and cost risks of the project. When the comprehensive evaluation index shows a high project risk, the risk adjustment coefficient for these amounts increases accordingly. The Pearson correlation coefficient is used to measure the linear correlation degree between the project quantity and the cost. By statistically analyzing the historical and current data of both, determine their correlation strength, and provide a basis for subsequent cost adjustment.

[0009] S4: Combine the risk adjustment coefficient and the Pearson correlation coefficient to calculate the adjusted cost and its reliability, and display the amounts in dispute and measurement errors, their adjusted costs, and reliability to the auditing side, and the auditing side issues adjustment opinions. The risk adjustment coefficient reflects the risk degree of the amounts, and the Pearson correlation coefficient reflects the correlation between the project quantity and the cost. Use these two coefficients to calculate the adjusted cost through a specific mathematical model.

[0010] S5: The construction party and the construction contractor communicate based on the adjustment opinions to determine whether to adjust the cost. Subsequently, the settlement amount is calculated, and a full-caliber settlement report is exported. After the settlement is completed, a series of data is stored in the historical archives. The construction party and the construction contractor communicate and negotiate based on the adjustment opinions of the auditing party, starting from their respective interests and the actual situation of the project. If both parties recognize the adjustment opinions, the settlement amount is calculated according to the adjusted cost. The full-caliber settlement report includes all cost details involved in the project from start to end, adjustment situations, and other information. After the settlement is completed, the relevant data of this project settlement is stored in the historical archives to provide historical reference data for subsequent new distribution network service expansion projects, forming a closed loop in the entire data processing process and continuously optimizing the processing of subsequent project settlements.

[0011] Preferably, in the above-mentioned S1, when establishing the historical archives, detailed data of past distribution network service expansion projects need to be comprehensively collected, including project name, project location, project scale, start date, completion date, details of each cost item, actual cost value, budget cost value, and actual construction period.

[0012] Preferably, in the above-mentioned S1, before calculating the dynamic fluctuation coefficient and stability index of the project cost, the actual cost value, budget cost value, and actual construction period of each project need to be extracted from the established historical archives, and these data are respectively integrated into sets C actual 、C budget 、D actual . At the same time, the weight of each project is set and a set ω is formed;

[0013] In the above-mentioned S1, when calculating the dynamic fluctuation coefficient of the project cost, the relevant expression is as follows:

[0014]

[0015] In the formula, K constl represents the dynamic fluctuation coefficient, ω i represents the weight of the i-th project in the set ω, C actual,i represents the actual cost of the i-th project in the set C actual , C budget,i represents the budget cost of the i-th project in the set C budget ;

[0016] In the above-mentioned S1, when calculating the stability index, the relevant expression is as follows:

[0017]

[0018] In the formula, S duration represents the stability index, D actual,i represents the actual construction period of the i-th project in the set D actual , Indicates the average actual construction period.

[0019] Preferably, in S2, the construction party, the construction contractor, and the auditing party enter the project information recorded by each of them through the network system established in S1;

[0020] The information entered by the construction party includes: contract information, project change information, equipment and material information, and project progress information;

[0021] The information entered by the construction contractor includes: quantity calculation sheets, construction drawings and as-built drawings, construction logs, material execution status, and equipment and material procurement information;

[0022] The information entered by the auditing party includes: the auditing party's opinions and processes on the information provided by the construction party and the construction contractor.

[0023] Preferably, in S2, when calculating the comprehensive evaluation index of the project progress, the relevant expression is as follows:

[0024]

[0025] In the formula, I progress represents the comprehensive evaluation index of the project progress, W completed represents the completed project quantity, W total represents the total project quantity, T elapsed represents the elapsed construction period, T total represents the total construction period, K cost1 represents the dynamic fluctuation coefficient, S duration represents the stability index, and α, β, and γ are weighting coefficients.

[0026] Preferably, in S3, when analyzing the project settlement submission documents, the following sub-steps are included:

[0027] S31: Extract the design workload list from the submission documents, compare it with the design task book and design contract in the system, and check the completion status of the design tasks;

[0028] S32: Compare the construction quantity list in the submission documents with the construction site progress records and the supervision logs, verify the authenticity and accuracy, check whether the construction technology meets the standards, and adjust the project quantity for non-compliant parts;

[0029] S33: Re-check the comparison results of the list of materials supplied by the employer and the material execution in the system, check whether the actual usage quantity is consistent with the submitted quantity, and pay attention to whether the handling of the remaining materials is compliant;

[0030] S34: Based on the contract billing standards and the actual situation, calculate the project management fees, temporary facility fees, water and electricity fees, etc., and mark and verify the fees without reasonable basis or exceeding the contract scope.

[0031] Preferably, in said S3, when calculating the risk adjustment coefficient of the cost, the relevant expression is as follows:

[0032]

[0033] Where R cost represents the risk adjustment coefficient, λ j represents the risk weight of the jth expense item in the set λ, C reported,j Represents the set C reported The amount of the jth expense item in C standard,j Represents the set C standard The standard amount of the jth expense item in I progress A comprehensive evaluation index that represents the progress of a project.

[0034] Preferably, in said S3, when calculating the Pearson correlation coefficient between the engineering quantity and the cost, the relevant expression is as follows:

[0035]

[0036] In the formula, r represents the number of data samples, W k represents the engineering quantity of the kth sample, Represents the average value of all sample engineering quantities, C k represents the cost of the k-th sample, represents the average cost of all samples, R cost represents the risk adjustment factor.

[0037] Preferably, in said S4, the adjusted cost and its reliability are calculated, and the relevant expressions are as follows:

[0038]

[0039] Where C adjusted represents the adjusted cost, C reported represents the expenses recorded in the application document, q represents the number of abnormal payments, ΔC l Indicates the adjustment amount of the lth abnormal payment, CI adjusted Represents the reliability of the adjusted cost, t α / 2,n-1 represents the quantile of the t-distribution, S is the sample standard deviation, and n is the sample size.

[0040] Preferably, in said S5, calculating the settlement amount includes the following sub-steps:

[0041] S51: Calculate the basic value of the settlement amount. The relevant expression is as follows:

[0042]

[0043] In the formula, S base represents the base value of the settlement amount, t represents the number of project cost items, C s represents the amount of s project cost items, μ represents the number of equipment and material cost items, V μ represents the amount of the u-th equipment and material cost item, C claim,w represents the amount of the w-th claim cost item, z represents the number of deduction cost items, D y represents the amount of the y-th deduction cost item, C adjusted represents the adjusted cost;

[0044] S52: Use the fuzzy comprehensive evaluation method to calculate the correction coefficient of the settlement amount. The relevant expressions are as follows:

[0045]

[0046] In the formula, K S represents the correction coefficient of the settlement amount, a i represents the weight of the i-th evaluation factor, r i represents the membership degree of the i-th evaluation factor, I progress represents the comprehensive evaluation index of the project progress.

[0047] S53: Calculate the final settlement amount according to the base value of the settlement amount and the correction coefficient of the settlement amount. The relevant expressions are as follows:

[0048] S = S base ×K S ;

[0049] In the formula, S represents the final settlement amount, S base represents the base value of the settlement amount, K S represents the correction number of the settlement amount.

[0050] The beneficial effects of the present invention are as follows:

[0051] 1. By establishing a historical file and calculating the dynamic fluctuation coefficient and stability index of the project cost, the present invention provides a reliable reference basis for subsequent project settlement data processing, making the calculation results more able to reflect the actual situation of the project, improving the accuracy of data processing, and effectively avoiding settlement errors caused by cost fluctuations and unstable construction periods.

[0052] 2. The construction party, the construction side, and the auditing side of the present invention input project information through the network system, realizing the timely sharing and interaction of information, breaking the information barrier, improving work efficiency, reducing communication costs and time costs caused by information asymmetry, and promoting the smooth progress of the project settlement process.

[0053] 3. For the amounts in dispute and the items with measurement errors in the project settlement submission documents of the present invention, calculations are carried out in combination with the comprehensive evaluation index to obtain the risk adjustment coefficient, and the Pearson correlation coefficient is further calculated, making the adjustment of the disputed amounts more reasonable and scientific, effectively solving the dispute problems, and protecting the legitimate rights and interests of all parties.

[0054] 4. When calculating the adjusted cost and its reliability in the present invention, various factors are comprehensively considered, such as the number of abnormal items, the adjusted amount, the sample standard deviation, etc., making the adjusted cost more accurate and reliable, providing strong decision-making support for the auditing party, and enhancing the credibility of the settlement result.

[0055] 5. The method of the present invention covers the whole process from establishing the network system and historical archives to calculating various coefficients, handling disputed amounts, determining the final settlement amount and exporting the settlement report, forming a complete closed-loop settlement process, ensuring the standardization and integrity of the settlement work, and being conducive to the standardized management of the project settlement work.

[0056] 6. Through the calculation and application of the comprehensive evaluation index, risk adjustment coefficient, etc. of the project progress in the present invention, the risks in the project settlement process can be effectively identified, evaluated and controlled, potential risk factors can be discovered in time and corresponding measures can be taken to deal with them, reducing the risks of the project settlement and ensuring the smooth progress of the project.

[0057] 7. After the settlement of the present invention is completed, a series of data are stored in the historical archives, providing rich historical data references for the settlement of subsequent similar projects, helping to continuously optimize the settlement method and process, improving the quality and efficiency of the project settlement, and realizing the accumulation and effective utilization of data. BRIEF DESCRIPTION OF THE DRAWINGS

[0058] Figure 1 It is a schematic diagram of the steps of a method for processing project settlement data of a distribution network service expansion project of the present invention. DETAILED DESCRIPTION OF THE INVENTION

[0059] A method for processing project settlement data of a distribution network service expansion project includes the following steps:

[0060] S1: Establish a network system and historical archives, and calculate the dynamic fluctuation coefficient and stability index of the project cost according to the historical archives;

[0061] S2: The construction party, the construction side, and the auditing party input project information, and calculate the comprehensive evaluation index of the project progress in combination with the dynamic fluctuation coefficient and stability index;

[0062] S3: Analyze the project settlement application documents and calculate the risk adjustment coefficient for the amounts with disputed amounts and measurement errors based on the comprehensive assessment index. Then calculate the Pearson correlation coefficient between the project quantity and the cost.

[0063] S4: Calculate the adjusted costs and their reliability by combining the risk adjustment coefficient and Pearson correlation coefficient. Present the amounts with disputed amounts or measurement errors, along with their adjusted costs and reliability, to the auditor, who will issue adjustment opinions.

[0064] S5: The builder and the construction party communicate based on the adjustment opinions to determine whether to adjust the fees, then calculate the settlement amount and export a full-caliber settlement report. After the settlement is completed, a series of data will be stored in the historical archives.

[0065] In S1 described above, when establishing historical archives, it is necessary to comprehensively collect detailed data of past distribution network expansion projects, including project name, project location, project scale, start date, completion date, cost details, actual cost value, budgeted cost value, and actual construction period.

[0066] In S1, before calculating the dynamic fluctuation coefficient and stability index of the project cost, it is necessary to extract the actual cost value, budget cost value, and actual construction period of each project from the established historical archive and integrate these data into a set C actual 、C budget 、D actual In , the weight of each project is set at the same time and forms a set ω;

[0067] In S1, the dynamic fluctuation coefficient of engineering cost is expressed as follows:

[0068]

[0069] Where K constl represents the dynamic fluctuation coefficient, ω i represents the weight of the i-th project in the set ω, C actual,i Represents the set C actual The actual cost of the i-th project, C budget,i Represents the set C budget The budget cost of the i-th project in ;

[0070] In the above S1, when calculating the stability index, the relevant expression is as follows:

[0071]

[0072] Where S duration Denotes the stability index, D actual,i Denotes the set D actualThe actual construction period of the i-th project in represents the average actual construction period.

[0073] In S2 described above, the construction party, the construction contractor, and the auditing party input the project information recorded by each of them through the network system established in S1;

[0074] The information input by the construction party includes: contract information, project change information, equipment and material information, and project progress information;

[0075] The information input by the construction contractor includes: quantity calculation sheets, construction drawings and as-built drawings, construction logs, material execution status, and equipment and material procurement information;

[0076] The information input by the auditing party includes: the auditing party's opinions and processes on the information provided by the construction party and the construction contractor.

[0077] In S2 described above, when calculating the comprehensive evaluation index of the project progress, the relevant expression is as follows:

[0078]

[0079] In the formula, I progress represents the comprehensive evaluation index of the project progress, W completed represents the completed project quantity, W total represents the total project quantity, T elapsed represents the elapsed construction period, T total represents the total construction period, K cost1 represents the dynamic fluctuation coefficient, S duration represents the stability index, and α, β, and γ are weighting coefficients.

[0080] In S3 described above, when analyzing the project settlement submission documents, the following sub-steps are included:

[0081] S31: Extract the design workload list from the submission document, check it against the design task book, design contract, etc. in the system, and check the completion status of the design task;

[0082] S32: Compare the construction quantity list in the submission document with the construction site progress record and the supervision log, verify the authenticity and accuracy, check whether the construction technology meets the standards, and adjust the project quantity for non-compliant parts;

[0083] S33: Re-check the comparison result between the list of materials provided by the employer and the material execution in the system, check whether the actual usage quantity is consistent with the submitted quantity, and pay attention to whether the handling of the remaining materials is compliant;

[0084] S34: Based on the contract billing standard and the actual situation, calculate the project management fee, temporary facility fee, water and electricity fee, etc., and mark and verify the fees without reasonable basis or exceeding the contract scope;

[0085] In S3, when calculating the risk adjustment coefficient of the cost, the relevant expression is as follows:

[0086]

[0087] Where R cost represents the risk adjustment coefficient, λ j represents the risk weight of the jth expense item in the set λ, C reported,j Represents the set C reported The amount of the jth expense item in C standard,j Represents the set C standard The standard amount of the jth expense item in I progress A comprehensive evaluation index that represents the progress of a project.

[0088] In S3, when calculating the Pearson correlation coefficient between the engineering quantity and the cost, the relevant expression is as follows:

[0089]

[0090] In the formula, r represents the number of data samples, W k represents the engineering quantity of the kth sample, Represents the average value of all sample engineering quantities, C k represents the cost of the k-th sample, represents the average cost of all samples, R cost represents the risk adjustment factor.

[0091] In S4, the adjusted cost and its reliability are calculated, and the relevant expressions are as follows:

[0092]

[0093] Where C adjusted represents the adjusted cost, C reported represents the expenses recorded in the application document, q represents the number of abnormal payments, ΔC l Indicates the adjustment amount of the lth abnormal payment, CI adjusted Represents the reliability of the adjusted cost, t α / 2,n-1 represents the quantile of the t-distribution, S is the sample standard deviation, and n is the sample size.

[0094] In the aforementioned S5, calculating the settlement amount includes the following sub-steps:

[0095] S51: Calculate the basic value of the settlement amount. The relevant expression is as follows:

[0096]

[0097] Wherein, S base represents the base value of the settlement amount, t represents the number of project cost items, C s represents the amount of s project cost items, μ represents the number of equipment and material cost items, V μ represents the amount of the u-th equipment and material cost item, C claim,w represents the amount of the w-th claim cost item, z represents the number of deduction cost items, D y represents the amount of the y-th deduction cost item, C adjusted represents the adjusted cost;

[0098] S52: Use the fuzzy comprehensive evaluation method to calculate the correction coefficient of the settlement amount. The relevant expressions are as follows:

[0099]

[0100] Wherein, K S represents the correction coefficient of the settlement amount, a i represents the weight of the i-th evaluation factor, r i represents the membership degree of the i-th evaluation factor, I progress represents the comprehensive evaluation index of the project progress.

[0101] S53: Calculate the final settlement amount according to the base value of the settlement amount and the correction coefficient of the settlement amount. The relevant expressions are as follows:

[0102] S = S base ×K S ;

[0103] Wherein, S represents the final settlement amount, S base represents the base value of the settlement amount, K S represents the correction number of the settlement amount.

[0104] Embodiments of the present invention are as follows:

[0105] A method for processing settlement data of distribution network service expansion projects, characterized by including the following steps:

[0106] S1: Establish a network system and comprehensively collect detailed data of past distribution network service expansion projects, including project name, project location, project scale, start date, completion date, various cost details, actual cost value, budget cost value, actual construction period, as historical archives.

[0107] Subsequently, extract the actual cost value, budget cost value, and actual construction period of each project from the established historical archives, and respectively integrate these data into sets C actual 、C budget 、D actualMeanwhile, set the weight of each project and form a set ω.

[0108] Calculate the dynamic fluctuation coefficient and stability index of the project cost based on historical archives. The dynamic fluctuation coefficient of the project cost has the following related expression:

[0109]

[0110] In the formula, K constl represents the dynamic fluctuation coefficient, ω i represents the weight of the i-th project in the set ω, C actual,i represents the set C actual the actual cost of the i-th project in it, C budget,i represents the set C budget the budget cost of the i-th project in it;

[0111] Calculate the stability index. The related expression is as follows:

[0112]

[0113] In the formula, S duration represents the stability index, D actual,i represents the set D actual the actual construction period of the i-th project in it, represents the average actual construction period.

[0114] S2: The construction party, the construction contractor, and the auditing party enter the project information recorded by each of them through the network system established in S1. The information entered by the construction party includes: contract information, project change information, equipment and material information, and project progress information. The information entered by the construction contractor includes: engineering quantity calculation book, construction drawings and as-built drawings, construction log, material execution status, and equipment and material procurement information. The information entered by the auditing party includes: the auditing party's opinions and processes on the information provided by the construction party and the construction contractor.

[0115] Subsequently, combine the dynamic fluctuation coefficient and the stability index to calculate the comprehensive evaluation index of the project progress. The related expression is as follows:

[0116]

[0117] In the formula, I progress represents the comprehensive evaluation index of the project progress, W completed represents the completed engineering quantity, W total represents the total engineering quantity, T elapsed represents the elapsed construction period, T total represents the total construction period, K cost1 represents the dynamic fluctuation coefficient, S duration represents the stability index, and α, β, and γ are weighting coefficients.

[0118] S3: Analyze the project settlement submission documents, including the following sub-steps:

[0119] S31: Extract the design workload list from the submission documents, compare it with the design task statements and design contracts in the system, and check the completion status of the design tasks;

[0120] S32: Compare the construction quantity list in the submission documents with the construction site progress records and supervision logs, verify the authenticity and accuracy, check whether the construction technology meets the standards, and adjust the quantities for non-compliant parts;

[0121] S33: Re-check the comparison results between the list of materials provided by Party A and the system material implementation, check whether the actual usage quantity is consistent with the submitted quantity, and pay attention to whether the handling of the remaining materials is compliant;

[0122] S34: Calculate the project management fees, temporary facility fees, water and electricity fees, etc. based on the contract billing standards and the actual situation, and mark for verification the fees without reasonable basis or exceeding the contract scope.

[0123] Subsequently, calculate the risk adjustment coefficient by combining the amounts with disputes and measurement errors with the comprehensive evaluation index, and then calculate the Pearson correlation coefficient between the quantities and costs.

[0124] Calculate the risk adjustment coefficient of the cost, and the relevant expression is as follows:

[0125]

[0126] In the formula, R cost represents the risk adjustment coefficient, λ j represents the risk weight of the j-th cost item in the set λ, C reported,j represents the amount of the j-th cost item in the set C reported in, C standard,j represents the standard amount of the j-th cost item in the set C standard in, I progress represents the comprehensive evaluation index of the project progress.

[0127] Calculate the Pearson correlation coefficient between the quantities and costs, and the relevant expression is as follows:

[0128]

[0129] In the formula, r represents the number of data samples, W k represents the quantity of the k-th sample, represents the average value of the quantities of all samples, C k represents the cost of the k-th sample, represents the average value of the costs of all samples, R costrepresents the risk adjustment coefficient.

[0130] S4: Combine the risk adjustment coefficient and the Pearson correlation coefficient to calculate the adjusted cost and its reliability. The relevant expressions are as follows:

[0131]

[0132] In the formula, C adjusted represents the adjusted cost, C reported represents the cost recorded in the submission document, q represents the number of abnormal items, and ΔC l represents the adjustment amount of the l-th abnormal item, CI adjusted represents the reliability of the adjusted cost, t α / 2,n-1 represents the quantile of the t-distribution, S is the sample standard deviation, and n is the sample size.

[0133] Subsequently, present the items with amount disputes and measurement errors, their adjusted costs, and reliabilities to the auditor, and the auditor issues adjustment opinions;

[0134] S5: The construction party and the construction contractor communicate based on the adjustment opinions to determine whether to adjust the cost, and then calculate the settlement amount, including the following sub-steps:

[0135] S51: Calculate the base value of the settlement amount. The relevant expressions are as follows:

[0136]

[0137] In the formula, S base represents the base value of the settlement amount, t represents the number of project cost items, C s represents the amount of s project cost items, μ represents the number of equipment and material cost items, V μ represents the amount of the u-th equipment and material cost item, C claim,w represents the amount of the w-th claim cost item, z represents the number of deduction cost items, D y represents the amount of the y-th deduction cost item, C adjusted represents the adjusted cost;

[0138] S52: Use the fuzzy comprehensive evaluation method to calculate the correction coefficient of the settlement amount. The relevant expressions are as follows:

[0139]

[0140] In the formula, K S represents the correction coefficient of the settlement amount, a i represents the weight of the i-th evaluation factor, r i represents the membership degree of the i-th evaluation factor, I progressRepresents the comprehensive evaluation index of the project progress.

[0141] S53: Calculate the final settlement amount based on the base value of the settlement amount and the correction coefficient of the settlement amount. The relevant expression is as follows:

[0142] S = S base ×K S ;

[0143] In the formula, S represents the final settlement amount, S base represents the base value of the settlement amount, and K S represents the correction factor of the settlement amount

[0144] Subsequently, a full-caliber settlement report is derived, and the construction party conducts the settlement based on the settlement report. After the settlement is completed, a series of data are automatically stored in the historical archives by the network system.

Claims

1. A method for processing settlement data of distribution network business expansion projects, characterized in that, It includes the following steps: S1: Establish a network system and historical archives, and calculate the dynamic fluctuation coefficient and stability index of the project cost according to the historical archives; S2: The construction party, the construction side, and the auditing side input project information, and calculate the comprehensive evaluation index of the project progress in combination with the dynamic fluctuation coefficient and stability index; S3: Analyze the project settlement submission documents, calculate the items with amount disputes and measurement errors in combination with the comprehensive evaluation index to obtain the risk adjustment coefficient, and then calculate the Pearson correlation coefficient between the project quantity and the cost; S4: Combine the risk adjustment coefficient and the Pearson correlation coefficient to calculate the adjusted cost and its reliability, display the items with amount disputes and measurement errors, their adjusted costs, and reliability to the auditing side, and the auditing side issues adjustment opinions; S5: The construction party and the construction side communicate based on the adjustment opinions to determine whether to adjust the cost, then calculate the settlement amount, export a full-caliber settlement report, and after the settlement is completed, store a series of data in the historical archives.

2. A method for processing the settlement data of the distribution network project expansion according to claim 1, characterized in that, In the above S1, when establishing the historical archives, it is necessary to comprehensively collect detailed data of past distribution network business expansion projects, including project name, project location, project scale, start date, completion date, details of each cost, actual cost value, budget cost value, and actual construction period.

3. A method for processing settlement data of distribution network business expansion projects according to claim 2, characterized in that, In the above-mentioned S1, before calculating the dynamic fluctuation coefficient and stability index of the project cost, it is necessary to extract the actual cost value, budget cost value, and actual construction period of each project from the established historical archives, and integrate these data into sets C actual , C budget , D actual . At the same time, set the weight of each project and form a set ω; In the above S1, when calculating the dynamic fluctuation coefficient of the project cost, the relevant expression is as follows: Where, K constl represents the dynamic fluctuation coefficient, ω i represents the weight of the i-th project in the set ω, C actual,i represents the set C actual the actual cost of the i-th project in, C budget,i represents the set C budget the budgeted cost of the i-th project in; In the above S1, when calculating the stability index, the relevant expression is as follows: Where S duration represents the stability index, D actual,i represents the actual construction period of the i-th project in the set D actual , and represents the average actual construction period.

4. A method for processing the settlement data of the distribution network business expansion project according to claim 1, characterized in that, In the above S2, the construction party, the construction side, and the auditing side input the project information they record through the network system established in S1; The information input by the construction party includes: contract information, project change information, equipment and material information, and project progress information; The information input by the construction side includes: project quantity calculation book, construction drawings and as-built drawings, construction logs, material execution status, and equipment and material procurement information; The information input by the auditing side includes: the auditing opinions and processes of the information provided by the construction party and the construction side.

5. A method for processing settlement data of distribution network business expansion projects according to claim 1, characterized in that, In the above S2, when calculating the comprehensive evaluation index of the project progress, the relevant expression is as follows: Wherein, I progress represents the comprehensive evaluation index of the project progress, W completed represents the completed project quantity, W total represents the total project quantity, T elapsed represents the elapsed construction period, T total represents the total construction period, K cost1 represents the dynamic fluctuation coefficient, S duration represents the stability index, and α, β, and γ are weighting coefficients.

6. A method for processing the settlement data of the distribution network business expansion project according to claim 1, characterized in that, In the above S3, when analyzing the project settlement submission documents, it includes the following sub-steps: S31: Extract the design workload list from the submission documents, check it against the design task book and design contract in the system to check the completion of the design tasks; S32: Compare the construction project quantity list in the submission documents with the on-site construction progress records and supervision logs, verify the authenticity and accuracy, check whether the construction technology meets the standards, and adjust the project quantity for non-compliant parts; S33: Re-check the comparison result between the list of materials supplied by the employer and the system material execution, check whether the actual usage quantity is consistent with the submitted quantity, and pay attention to whether the handling of the remaining materials is compliant; S34: According to the contract billing standard and the actual situation, calculate the project management fee, temporary facility fee, water and electricity fee, etc., and mark and verify the fees without reasonable basis or exceeding the contract scope.

7. A method for processing settlement data of distribution network business expansion projects according to claim 1, characterized in that In the above S3, when calculating the risk adjustment coefficient of the cost, the relevant expression is as follows: Where R cost represents the risk adjustment coefficient, λ j represents the risk weight of the jth expense item in the set λ, C reported,j Represents the set C reported The amount of the jth expense item in C standard,j Represents the set C standard The standard amount of the jth expense item in I progress A comprehensive evaluation index that represents the progress of a project.

8. A method for processing settlement data of distribution network business expansion projects according to claim 6, characterized in that, In the above S3, when calculating the Pearson correlation coefficient between the project quantity and the cost, the relevant expression is as follows: In the formula, r represents the number of data samples, W k represents the engineering quantity of the kth sample, Represents the average value of all sample engineering quantities, C k represents the cost of the k-th sample, represents the average cost of all samples, R cost represents the risk adjustment factor.

9. A method for processing settlement data of distribution network business expansion projects according to claim 1, characterized in that, In the aforementioned S4, calculate the adjusted cost and its reliability. The relevant expressions are as follows: Where C adjusted represents the adjusted cost, C reported represents the cost recorded in the submission document, q represents the number of abnormal items, and ΔC l represents the adjustment amount of the l-th abnormal item, CI adjusted represents the reliability of the adjusted cost, t α / 2,n-1 represents the quantile of the t-distribution, S is the sample standard deviation, and n is the sample size.

10. A method for processing the settlement data of the distribution network business expansion project according to claim 7, characterized in that, In the aforementioned S5, calculate the settlement amount, including the following sub-steps: S51: Calculate the base value of the settlement amount. The relevant expressions are as follows: In the formula, S base represents the base value of the settlement amount, t represents the number of project cost items, C s represents the amount of s project cost items, μ represents the number of equipment and material cost items, V μ represents the amount of the u-th equipment and material cost item, C claim,w represents the amount of the w-th claim cost item, z represents the number of deduction cost items, D y represents the amount of the y-th deduction cost item, C adjusted represents the adjusted cost; S52: Use the fuzzy comprehensive evaluation method to calculate the correction coefficient of the settlement amount. The relevant expressions are as follows: where K S represents the correction coefficient of the settlement amount, a i represents the weight of the i-th evaluation factor, r i represents the membership degree of the i-th evaluation factor, I progress represents the comprehensive evaluation index of the project progress. S53: Calculate the final settlement amount based on the base value of the settlement amount and the correction coefficient of the settlement amount. The relevant expressions are as follows: S = S base × K S ; Wherein, S represents the final settlement amount, S base represents the base value of the settlement amount, and K S represents the correction factor of the settlement amount.

Images