Big data acquisition method for power transmission equipment cost

Abstract

The invention relates to the technical field of business data abnormity monitoring, in particular to a big data acquisition method for power transmission equipment cost. The method comprises the following steps: firstly, obtaining the purchase influence degree of the power transmission equipment according to the difference condition of the stage amount of the purchase stage of the power transmission equipment and the difference condition of the reference degree; according to the corresponding stage amount and the stage duration of the design stage of the power transmission equipment and the reference degree of the power transmission equipment, obtaining the design influence degree of the power transmission equipment; obtaining the quality measurement of the power transmission equipment according to the purchase influence degree, the design influence degree and the reference degree; and cleaning the data sets of all the power transmission devices in the database according to the quality metrics of all the power transmission devices. According to the method, the data quality of the power transmission equipment is reflected more accurately by constructing the quality measurement, so that data cleaning is performed better to guarantee the data quality.

Description

Technical Field

[0001] The present invention relates to the technical field of commercial data anomaly monitoring, and in particular to a big data collection method for power transmission equipment cost. Background Art

[0002] The cost of power transmission equipment refers to the relevant costs of all items in the design, procurement, construction, commissioning and maintenance stages of power transmission equipment. Power design engineers can select appropriate materials and technologies and optimize design solutions by understanding the big data of power transmission equipment costs to meet the actual needs and limitations of power transmission equipment. Through the historical collection of power transmission equipment costs, a large database is built to provide a reference for the subsequent design of power transmission equipment solutions.

[0003] Since there are problematic data caused by unreasonable design schemes in the process of big data collection, data cleaning is required to ensure the data quality of the big database. In the process of using traditional data cleaning methods to clean the data of data equipment in the database, it is mainly based on whether each data is in a reasonable value range, and the degree of abnormality of the data is determined to perform data cleaning. When traditional data cleaning processes the data of problematic power transmission equipment that is significantly different from the data values ​​of normal power transmission equipment, the degree of abnormality of the problematic power transmission equipment data is more obvious. Traditional data cleaning methods have good cleaning effects. However, when the data values ​​of problematic power transmission equipment are close to the data values ​​of normal power transmission equipment, the degree of abnormality of the problematic power transmission equipment data is not obvious, resulting in poor cleaning effects and difficulty in ensuring the quality of the cleaned data. Summary of the invention

[0004] In order to solve the technical problem that the existing technology has poor cleaning effect and is difficult to ensure data quality, the purpose of the present invention is to provide a big data collection method for power transmission equipment cost. The technical solution adopted is as follows:

[0005] A big data collection method for power transmission equipment cost, the method comprising:

[0006] Acquire a data set of each power transmission equipment in the database; the data set includes: the unit price and quantity of each project in the design stage, the procurement stage, the construction stage, and the maintenance stage, the stage amount, and the stage duration;

[0007] According to the difference between the unit price of each item of the power transmission equipment and its corresponding preset standard unit price, the normality of the unit price of the power transmission equipment is obtained; according to the normality of the unit price of the power transmission equipment, the stage duration of the design stage, the stage amount of the procurement stage, the stage duration of the construction stage, and the number of items of all items in the maintenance stage, the reference degree of the power transmission equipment is obtained;

[0008] Obtain the procurement impact of the power transmission equipment according to the difference in the stage amounts and the difference in the reference degree of the procurement stage of the power transmission equipment; obtain the design impact of the power transmission equipment according to the stage amount and stage duration corresponding to the design stage of the power transmission equipment and the reference degree of the power transmission equipment; obtain the quality metric of the power transmission equipment according to the procurement impact, the design impact and the reference degree;

[0009] According to the quality metrics of all power transmission equipment, the data set of all power transmission equipment in the database is cleaned.

[0010] Furthermore, the method for obtaining the normality of the unit price includes:

[0011] Obtaining a first deviation value for each item of the power transmission equipment according to a difference between the item unit price of each item of the power transmission equipment and its corresponding preset standard unit price;

[0012] The unit price normality of the power transmission equipment is obtained according to the overall distribution of the first deviation values ​​of all items of the power transmission equipment.

[0013] Furthermore, the method for obtaining the normality of the unit price of the power transmission equipment according to the overall distribution of the first deviation values ​​of all items of the power transmission equipment includes:

[0014] The average of the first deviation values ​​of all items of the power transmission equipment is calculated to obtain the second deviation value; the second deviation value is inversely normalized to obtain the unit price normality of the power transmission equipment.

[0015] Furthermore, the method for obtaining the reference degree includes:

[0016] According to the stage duration of the design stage, the stage amount of the procurement stage and the stage duration of the construction stage, the construction problem rate of the power transmission equipment is obtained; the stage duration of the design stage and the stage duration of the construction stage are both positively correlated with the construction problem rate, and the stage amount of the procurement stage is negatively correlated with the construction problem rate;

[0017] The number of projects of all projects in the comprehensive maintenance phase is used to obtain the equipment failure rate of the power transmission equipment; the number of projects and the equipment failure rate are positively correlated;

[0018] According to the construction problem rate and the equipment failure rate, obtaining equipment reference parameters of the power transmission equipment; the construction problem rate and the equipment failure rate are both negatively correlated with the equipment reference parameters of the power transmission equipment;

[0019] The reference degree of the power transmission equipment is obtained according to the equipment reference parameter and the unit price normality.

[0020] Furthermore, the method for obtaining the procurement influence includes:

[0021] The data set of the power transmission equipment also includes the total equipment amount of the power transmission equipment; according to the proportion of the stage amount of the power transmission equipment procurement stage in the total equipment amount, the procurement amount proportion parameter of the power transmission equipment is obtained;

[0022] Obtaining comparison equipment for power transmission equipment based on the differences between the procurement amount ratio parameters of all power transmission equipment;

[0023] According to the difference in the purchase amount ratio parameters between the power transmission equipment and the comparison equipment, a purchase amount difference index is obtained;

[0024] Obtaining a reference difference index according to a difference in the reference degree between the power transmission device and the comparison device;

[0025] According to the reference difference index and the purchase amount difference index, the purchase influence of the power transmission equipment is obtained; the reference difference index and the purchase influence are negatively correlated; the purchase amount difference index and the purchase influence are positively correlated.

[0026] Furthermore, the method for obtaining the comparison device includes:

[0027] Any power transmission device is used as a first device to be analyzed, and all power transmission devices except the first device to be analyzed are used as second devices to be analyzed of the first device to be analyzed;

[0028] The absolute value of the difference between the purchase amount ratio parameters of the first device to be analyzed and the second device to be analyzed is calculated, and the smallest absolute value of the difference is corresponding to the second device to be analyzed as the comparison device of the first device to be analyzed.

[0029] Furthermore, the method for obtaining the design influence includes:

[0030] According to the corresponding stage amount and stage duration of the design stage of the power transmission equipment, the design complexity of the power transmission equipment is obtained;

[0031] The design influence of the power transmission equipment is obtained according to the design complexity and reference degree of the power transmission equipment; the design complexity and the design influence are positively correlated; the reference degree and the design influence are negatively correlated.

[0032] Furthermore, the method for obtaining the design complexity includes:

[0033] Calculate the product of the corresponding stage amount and stage duration of the design stage of the power transmission equipment to obtain the design input cost of the power transmission equipment;

[0034] The data set of the power transmission equipment also includes the total equipment amount and the total equipment duration of the power transmission equipment; the product of the total equipment amount and the total equipment duration of the power transmission equipment is calculated to obtain the overall investment cost of the power transmission equipment;

[0035] The ratio of the design input cost to the overall input cost is calculated to obtain the design complexity of the power transmission equipment.

[0036] Furthermore, the quality measurement method includes:

[0037] Calculating the absolute value of the difference between the procurement impact and the design impact to obtain an impact difference index;

[0038] The sum of the impact difference index and the preset denominator adjustment index is calculated, and the ratio of the reference degree to the sum is calculated to obtain the quality metric of the power transmission equipment.

[0039] Furthermore, the method for cleaning the data set of all power transmission equipment in the database includes:

[0040] The transmission equipment whose quality metric is less than the preset quality threshold is marked as problematic equipment, and the data sets corresponding to all problematic equipment in the database are filtered out to obtain a cleaned database.

[0041] The present invention has the following beneficial effects:

[0042] In order to ensure the high quality of data in the database, it is necessary to analyze the quality of the data set of the transmission equipment. First, considering that there are errors in the recording of the unit price of the project of the transmission equipment due to operational errors or transmission errors, the unit price normality reflects the correctness of the unit price record of the project in the transmission equipment. In order to measure the rationality of the equipment scheme of the transmission equipment, considering that the more unreasonable the scheme design is, the more likely it is to cause the construction difficulty of the subsequent process to become higher and the transmission equipment to fail frequently, the reference degree is used to preliminarily reflect the rationality of the scheme of the transmission equipment from the perspective of the impact of the subsequent process. The lower the reference degree is, the more unreasonable the equipment scheme of the transmission equipment is. Considering that the procurement cost is the main expenditure of the transmission equipment, there is a situation where the scheme of the transmission equipment is unreasonable in order to save the cost of the procurement stage. The procurement influence of the transmission equipment reflects the influence of the procurement stage on the rationality of the scheme. The greater the procurement influence, the easier it is for the selection in the procurement stage to affect the rationality of the scheme of the transmission equipment; considering that the design complexity is the key factor affecting the unreasonable scheme, the design influence of the transmission equipment is obtained; the greater the design influence, the easier it is for the design stage to affect the rationality of the scheme of the transmission equipment. Considering that for power transmission equipment with reasonable scheme design, the degree of influence on the rationality of the scheme in the procurement stage and the design stage should be relatively consistent, and at the same time show a high degree of reference. Based on this, the quality metric of the power transmission equipment is obtained; the larger the quality metric, the more reasonable the scheme design of the power transmission equipment, and the higher the data quality of the data set of the power transmission equipment. Based on the quality metric of all power transmission equipment, the data set of all power transmission equipment in the database is cleaned to improve the quality of the data. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] In order to more clearly illustrate the technical solutions and advantages in the embodiments of the present invention or the prior art, the drawings required for use in the embodiments or the prior art descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0044] Figure 1 A flowchart of a big data collection method for power transmission equipment cost provided by an embodiment of the present invention;

[0045] Figure 2 A flow chart of a method for obtaining a reference degree provided by an embodiment of the present invention;

[0046] Figure 3 A flow chart of a method for obtaining procurement influence provided by an embodiment of the present invention;

[0047] Figure 4 A flow chart of a method for obtaining impact calculation provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0048] In order to further explain the technical means and effects adopted by the present invention to achieve the predetermined invention purpose, the following is a detailed description of the big data collection method for the cost of power transmission equipment proposed by the present invention, its specific implementation method, structure, features and effects, in combination with the accompanying drawings and preferred embodiments. In the following description, different "one embodiment" or "another embodiment" does not necessarily refer to the same embodiment. In addition, specific features, structures or characteristics in one or more embodiments may be combined in any suitable form.

[0049] Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs.

[0050] The following specifically describes a method for collecting big data on power transmission equipment costs provided by the present invention in conjunction with the accompanying drawings.

[0051] The embodiment of the present invention provides a big data collection method for power transmission equipment cost. Figure 1 , which shows a flow chart of a big data collection method for power transmission equipment cost provided by an embodiment of the present invention, the method comprising the following steps:

[0052] Step S1: Obtain a data set of each power transmission equipment in the database; the data set includes: the unit price and quantity of each project in the design stage, procurement stage, construction stage and maintenance stage, the stage amount and stage duration.

[0053] The main purpose of the present invention is to clean the database and ensure the data quality. First, it is necessary to obtain the data set of each power transmission equipment in the database to provide data support for subsequent data cleaning.

[0054] The data set of each power transmission equipment is obtained from the cloud service platform of the project company; specifically, the cloud service platform of the project company stores a corresponding quotation for each power transmission equipment, and the quotation stores the data values ​​of the unit price and quantity of each project at different stages of the power transmission equipment. The power transmission equipment project needs to go through the design, procurement, construction, commissioning and maintenance stages, that is, the quotation includes the design stage, procurement stage, construction stage, commissioning stage and maintenance stage; considering that there are multiple projects in each stage, for example, the procurement stage needs to purchase power lines, control lines and wire pipes, and the procurement stage includes power line projects, control line projects, wire pipe projects, etc. Please refer to Table 1, which shows the data values ​​of the unit price and quantity of each project at different stages of the power transmission equipment quotation. It should be noted that this table is only a schematic example for understanding the data values ​​of the unit price and quantity of each project at different stages of the power transmission equipment quotation.

[0055] Table 1

[0056]

[0057] In Table 1, f1, f2...f7, f8 are the data values ​​corresponding to the unit price of each item in the quotation; S1, S2...S7, S8 are the data values ​​corresponding to the quantity of each item in the quotation.

[0058] For any stage, the duration of the stage is taken as the stage duration of the stage; the stage amount of the stage is obtained by calculating the product of the project unit price and the project quantity to obtain the project amount of the project; calculating the cumulative sum of the project amounts of all projects in the stage to obtain the stage amount of the stage; that is, obtaining the stage duration and stage amount of the design stage, procurement stage, construction stage, commissioning stage and maintenance stage; calculating the cumulative sum of the stage amounts of all stages to obtain the total equipment amount, and calculating the cumulative sum of the stage duration of all stages to obtain the total equipment duration. The stage duration reflects the total time spent by the power transmission equipment in the stage, the stage amount reflects the total amount spent by the power transmission equipment in the stage, the total equipment amount reflects the total amount spent in all stages of the power transmission equipment, and the total equipment duration reflects the total time spent in all stages of the power transmission equipment.

[0059] The unit price and quantity of each project in each stage of the power transmission equipment, as well as the stage amount and stage duration of each stage, as well as the total amount of equipment and the total duration of equipment are counted to obtain the data set of each power transmission equipment; the data set of all power transmission equipment corresponding to the same type of power transmission equipment is counted to obtain a database. It should be noted that in order to control all power transmission equipment in the variable database to be the same type of power transmission equipment, the present invention takes all power transmission equipment in the database as a medium-sized distribution station as an example.

[0060] It should be noted that, in order to facilitate calculation, all indicator data involved in the calculation in the embodiment of the present invention are preprocessed to eliminate the dimension effect. The specific means of eliminating the dimension effect are technical means well known to those skilled in the art and are not limited here.

[0061] Step S2: According to the difference between the unit price of each project of the power transmission equipment and its corresponding preset standard unit price, the normality of the unit price of the power transmission equipment is obtained; according to the normality of the unit price of the power transmission equipment, the stage duration of the design stage, the stage amount of the procurement stage, the stage duration of the construction stage and the number of projects of all projects in the maintenance stage, the reference degree of the power transmission equipment is obtained.

[0062] In order to ensure the high quality of data in the database, it is necessary to analyze the quality of the data set of the power transmission equipment. First of all, considering that there are errors in the recording of the project unit price of the power transmission equipment due to operational errors or transmission errors, the correctness of the project unit price records in the power transmission equipment is reflected by the unit price normality. In order to measure the rationality of the equipment scheme of the power transmission equipment, considering that the more unreasonable the scheme design is, the more likely it is to cause the construction difficulty of the subsequent process to become higher and the power transmission equipment to fail frequently, the reference degree is used to preliminarily reflect the rationality of the transmission equipment scheme from the perspective of the impact of the subsequent process. The lower the reference degree, the more unreasonable the equipment scheme of the transmission equipment is.

[0063] In order to check the correctness of the records of the power transmission equipment, preferably, in one embodiment of the present invention, the method for obtaining the normality of the unit price includes:

[0064] Obtaining a first deviation value for each item of the power transmission equipment according to a difference between an item unit price of each item of the power transmission equipment and a corresponding preset standard unit price;

[0065] The unit price normality of the power transmission equipment is obtained according to the overall distribution of the first deviation values ​​of all items of the power transmission equipment.

[0066] Specifically, the absolute value of the difference between the project unit price of each item of the power transmission equipment and its corresponding preset standard unit price is calculated to obtain a first deviation value of each item of the power transmission equipment; the mean of the first deviation values ​​of all items of the power transmission equipment is calculated to obtain a second deviation value; the second deviation value is inversely normalized to obtain the normality of the unit price of the power transmission equipment. In one embodiment of the present invention, considering that the amount of data in the database is sufficient and recording errors are low-frequency events, the mean of all project unit prices of database items can reflect the correct project unit price, and the method for obtaining the preset standard unit price of the project is: obtain all project unit prices of the project from the database, calculate the mean of all project unit prices of the project, and obtain the preset standard unit price of the project. In one embodiment of the present invention, the method of inverse normalization is: take the opposite of the second deviation value as the power of an exponential function with a natural constant as the base, and obtain the inverse normalization result.

[0067] With respect to the above steps, the first deviation value reflects the degree to which the actual project unit price of the project deviates from the correct project unit price. The larger the first deviation value, the greater the degree of deviation. The greater the unit price normality, the smaller the degree to which the actual project unit price of all projects of the power transmission equipment deviates from the correct project unit price, and the higher the unit price normality of the project unit price.

[0068] To make a preliminary assessment of the feasibility of the equipment solution for the power transmission equipment, please refer to Figure 2 , which shows a flow chart of a method for obtaining a reference degree in one embodiment of the present invention. Preferably, in one embodiment of the present invention, the method for obtaining a reference degree includes:

[0069] Step S201: According to the stage duration of the design stage, the stage amount of the procurement stage and the stage duration of the construction stage, the construction problem rate of the transmission equipment is obtained; the stage duration of the design stage and the stage duration of the construction stage are both positively correlated with the construction problem rate, and the stage amount of the procurement stage is negatively correlated with the construction problem rate.

[0070] In order to evaluate the difficulty of the transmission equipment during the construction phase, taking into account that the quality of purchased materials is often insufficient in order to save procurement costs, and the design costs are long due to design difficulties, which makes the subsequent construction phase more difficult and the construction period longer, the construction problem rate is obtained. The larger the construction problem rate, the higher the construction difficulty, the more likely construction problems will occur, and the more likely the equipment plan for the transmission equipment is to be unreasonable.

[0071] In one embodiment of the present invention, the product of the stage duration of the design stage and the stage duration of the construction stage is calculated, and the ratio of the product to the stage amount of the procurement stage is calculated to obtain the construction problem rate of the power transmission equipment.

[0072] Step S202: The project quantity of all projects in the comprehensive maintenance phase is used to obtain the equipment failure rate of the power transmission equipment; the project quantity and the equipment failure rate are positively correlated.

[0073] In order to evaluate the failure of power transmission equipment during the maintenance phase, the higher the equipment failure rate, the worse the stability and reliability of the equipment, and the more maintenance is required. The equipment failure rate is obtained. The higher the equipment failure rate, the more likely the power transmission equipment is to fail, and the equipment solution of the power transmission equipment is more likely to be unreasonable.

[0074] In one embodiment of the present invention, the cumulative sum of the number of items of all items in the maintenance phase is calculated to obtain the equipment failure rate of the power transmission equipment. In the maintenance phase, different items reflect different types of maintenance, the number of items reflects the number of maintenance, and the equipment failure rate can reflect the frequency of equipment maintenance.

[0075] Step S203: obtaining equipment reference parameters of the power transmission equipment according to the construction problem rate and the equipment failure rate; the construction problem rate and the equipment failure rate are both negatively correlated with the equipment reference parameters of the power transmission equipment.

[0076] By combining the construction problem rate and equipment failure rate, we can get an equipment reference parameter that reflects the rationality of the equipment solution. This equipment reference parameter is used for the subsequent evaluation of the reference degree of the transmission equipment.

[0077] In one embodiment of the present invention, the sum of the construction problem rate and the equipment failure rate is calculated, and the sum is inversely normalized to obtain the equipment reference parameter of the power transmission equipment. In one embodiment of the present invention, the inverse normalization method is: the inverse of the sum is used as the power of an exponential function with a natural constant as the base to obtain a negative correlation mapping result.

[0078] Step S204: Obtain the reference degree of the power transmission equipment according to the equipment reference parameters and the normality of the unit price.

[0079] Combined with the equipment reference parameters and unit price normality, the referenceability of the transmission equipment data is evaluated. The referenceability reflects the reliability of the transmission equipment data and the rationality of the scheme. The lower the referenceability, the lower the reliability of the transmission equipment data and the more unreasonable the equipment scheme.

[0080] In one embodiment of the present invention, the product of the equipment reference parameter and the unit price normality is calculated to obtain the reference degree of the power transmission equipment.

[0081] In one embodiment of the present invention, the reference degree formula includes:

[0082] CK=ZQ×exp{-[SG+GZ]}

[0083] Wherein, CK is the reference degree of the transmission equipment; ZQ is the unit price normality of the transmission equipment; exp{} is an exponential function with e as the base; SG is the construction problem rate of the transmission equipment; GZ is the equipment failure rate of the transmission equipment; exp{-[SG+GZ]} is the equipment reference parameter of the transmission equipment.

[0084] Step S3: According to the differences in the stage amounts and the differences in the reference degree in the procurement stages of the power transmission equipment, the procurement impact of the power transmission equipment is obtained; according to the stage amounts and stage durations corresponding to the design stages of the power transmission equipment and the reference degree of the power transmission equipment, the design impact of the power transmission equipment is obtained; according to the procurement impact, the design impact and the reference degree, the quality metric of the power transmission equipment is obtained.

[0085] Considering that procurement costs are the main expenses of power transmission equipment, there are situations where the scheme of power transmission equipment is unreasonable in order to save costs in the procurement stage. The procurement influence of power transmission equipment reflects the influence of the procurement stage on the rationality of the scheme. The greater the procurement influence, the easier it is for the selection in the procurement stage to affect the rationality of the scheme of power transmission equipment; considering that design complexity is the key factor affecting the unreasonable scheme, the design influence of power transmission equipment is obtained; the greater the design influence, the easier it is for the design stage to affect the rationality of the scheme of power transmission equipment. Considering that for power transmission equipment with reasonable scheme design, the degree of influence on the rationality of the scheme in the procurement stage and the design stage should be relatively consistent, and at the same time show a high degree of reference. Based on this, the quality metric of power transmission equipment is obtained; the greater the quality metric, the more reasonable the scheme design of the power transmission equipment is, and the higher the data quality of the data set of the power transmission equipment is.

[0086] In order to analyze the circumstances that affect the rationality of the transmission equipment solution during the procurement phase, please refer to Figure 3 , which shows a flow chart of a method for obtaining a procurement influence in one embodiment of the present invention. Preferably, in one embodiment of the present invention, the method for obtaining a procurement influence includes:

[0087] Step S301: the data set of the power transmission equipment also includes the total equipment amount of the power transmission equipment; according to the proportion of the stage amount of the power transmission equipment procurement stage in the total equipment amount, the procurement amount proportion parameter of the power transmission equipment is obtained.

[0088] The parameter of purchase amount ratio reflects the proportion of the purchase stage in the total equipment cost.

[0089] In one embodiment of the present invention, a ratio of a stage amount of a procurement stage of the power transmission equipment to a total equipment amount is calculated to obtain a procurement amount ratio parameter of the power transmission equipment.

[0090] Step S302: Obtain comparison equipment for the power transmission equipment according to the differences between the procurement amount ratio parameters of all the power transmission equipment.

[0091] Considering that procurement costs are the main expenditure of power transmission equipment, there is a situation where the plan of power transmission equipment is unreasonable in order to save costs in the procurement stage. In order to subsequently evaluate the impact of changes in costs in the procurement stage of power transmission equipment on the rationality of the plan, it is necessary to find comparison equipment for power transmission equipment so that the proportion of procurement amount between the power transmission equipment and its comparison equipment has the greatest similarity.

[0092] In one embodiment of the present invention, a method for obtaining a comparison device includes: taking any one power transmission device as a first device to be analyzed, and taking all power transmission devices except the first device to be analyzed as second devices to be analyzed of the first device to be analyzed; calculating the absolute value of the difference between the procurement amount ratio parameters of the first device to be analyzed and the second device to be analyzed, and corresponding the smallest absolute value of the difference to the second device to be analyzed as a comparison device for the first device to be analyzed.

[0093] Step S303: obtaining a purchase amount difference index according to the difference in purchase amount ratio parameters between the power transmission equipment and the comparison equipment.

[0094] The purchase amount difference index directly reflects the difference in the proportion of purchase amount between the equipment to be analyzed and the comparison equipment during the procurement stage. The larger the purchase amount difference index, the greater the difference.

[0095] In one embodiment of the present invention, the absolute value of the difference between the procurement amount ratio parameters of the power transmission equipment and the comparison equipment is calculated to obtain the procurement amount difference index.

[0096] Step S304: obtaining a reference difference index according to the difference in reference degree between the power transmission device and the comparison device.

[0097] The reference difference index reflects the degree of difference in the rationality of the plans. The larger the reference difference index, the greater the degree of difference.

[0098] In one embodiment of the present invention, the absolute value of the difference between the reference degrees of the power transmission device and the comparison device is calculated to obtain a reference difference index.

[0099] Step S305: According to the reference difference index and the purchase amount difference index, the purchase influence of the power transmission equipment is obtained; the reference difference index and the purchase influence are negatively correlated; the purchase amount difference index and the purchase influence are positively correlated.

[0100] Considering that the rationality of the scheme varies greatly under the premise of similar proportion of procurement amount, it means that the relationship between the expenditure in the procurement stage and the rationality of the scheme of power transmission equipment is weak, that is, the selection in the procurement stage is less likely to affect the rationality of the scheme of power transmission equipment. The procurement influence of power transmission equipment is obtained. The smaller the procurement influence, the less likely the selection in the procurement stage is to affect the rationality of the scheme of power transmission equipment.

[0101] In one embodiment of the present invention, the sum of the purchase amount difference index and the preset denominator adjustment parameter is calculated, the ratio of the reference difference index to the sum is calculated, and the comparison value is inversely normalized to obtain the purchase influence of the power transmission equipment. In one embodiment of the present invention, the preset denominator adjustment parameter is used to ensure that the denominator is not 0. The preset denominator adjustment parameter is a number greater than 0. This embodiment sets it to 0.001, and the implementer can set it according to the implementation scenario. In one embodiment of the present invention, the method of inverse normalization is: the inverse of the ratio is used as the power of an exponential function with a natural constant as the base.

[0102] Considering that even for the same type of transmission equipment, due to different application scenarios, the design schemes adopted by the transmission equipment are different, and the design complexity corresponding to the design scheme is also different. For example, for transmission equipment, that is, medium-sized distribution stations, for medium-sized distribution stations built in the city center, it is necessary to consider that the scenario focuses on the city center, land is scarce, environmental requirements are high, and there are high-density residential and commercial areas around. The design scheme needs to consider multiple factors such as space utilization, noise and vibration control, and environmental protection requirements. The design scheme complexity is relatively high; for medium-sized distribution stations built in remote areas, it is necessary to consider that the scenario focuses on remote areas, transportation is inconvenient, and maintenance costs are high, but the power demand is relatively stable. The design scheme complexity is relatively low, and the design scheme still needs to consider requirements such as remote monitoring and environmental adaptability. In order to analyze the impact of design stage complexity on the rationality of the transmission equipment scheme, please refer to Figure 4 , which shows a flow chart of a method for obtaining design influence in one embodiment of the present invention. Preferably, the method for obtaining design influence includes:

[0103] Step S311: obtaining the design complexity of the power transmission equipment according to the corresponding stage amount and stage duration of the design stage of the power transmission equipment.

[0104] The design complexity of the transmission equipment is quantified by the design complexity. The larger the design complexity value, the greater the complexity of the solution.

[0105] In one embodiment of the present invention, a method for obtaining design complexity includes:

[0106] Calculate the product of the corresponding stage amount and stage duration of the design stage of the power transmission equipment to obtain the design input cost of the power transmission equipment;

[0107] The data set of the power transmission equipment also includes the total equipment amount and the total equipment duration of the power transmission equipment; the product of the total equipment amount and the total equipment duration of the power transmission equipment is calculated to obtain the overall investment cost of the power transmission equipment;

[0108] The ratio of design input cost to overall input cost is calculated to obtain the design complexity of the transmission equipment.

[0109] Regarding the above steps, considering that there are professionals following up the design process to control the cost and time, the greater the design phase investment cost compared to the overall investment cost, the more complex the design solution is. The design investment cost measures the investment cost of the design phase from the perspectives of time and amount of money spent, and the overall investment cost measures the overall investment cost of the transmission equipment from the perspectives of time and amount of money spent. The design complexity of the transmission equipment is obtained by calculating the ratio of the design investment cost to the overall investment cost. The greater the design complexity, the greater the complexity of the design solution of the transmission equipment.

[0110] Step S312: according to the design complexity and reference degree of the power transmission equipment, the design influence of the power transmission equipment is obtained; the design complexity and the design influence are positively correlated; the reference degree and the design influence are negatively correlated.

[0111] Considering that the design complexity is high and the reference degree of the scheme is low, it is more likely that the design complexity will lead to unreasonable design of the scheme and thus reduce the rationality of the scheme. The greater the design impact, the easier it is to affect the rationality of the transmission equipment scheme during the design stage.

[0112] In one embodiment of the present invention, the sum of the reference degree and the preset denominator adjustment value is calculated, and the ratio of the design complexity to the sum is calculated to obtain the design influence of the power transmission equipment. In one embodiment of the present invention, the preset denominator adjustment value is used to ensure that the denominator is not 0, and the preset denominator adjustment value is a number greater than 0. In this embodiment, it is set to 0.01, and the implementer can set it according to the implementation scenario.

[0113] In order to more accurately reflect the design degree of the power transmission equipment, preferably, in one embodiment of the present invention, the quality measurement method includes:

[0114] Calculate the absolute value of the difference between the procurement impact and the design impact to obtain the impact difference index;

[0115] The sum of the impact difference index and the preset denominator adjustment index is calculated, and the ratio of the reference degree to the sum is calculated to obtain the quality metric of the power transmission equipment. In one embodiment of the present invention, the preset denominator adjustment index is used to ensure that the denominator is not 0. The preset denominator adjustment index is a number greater than 0. This embodiment sets it to 0.001, and the implementer can set it according to the implementation scenario.

[0116] Specifically, considering that for power transmission equipment with reasonable scheme design, the degree of influence on the rationality of the scheme in the procurement stage and the design stage should be relatively consistent, and at the same time show a high degree of reference. Based on this, the quality metric of the power transmission equipment is obtained; the larger the quality metric, the more comprehensive the reflection of the reasonableness of the scheme design of the power transmission equipment, and the higher the data quality of the data set of the power transmission equipment.

[0117] Step S4: Clean the data set of all power transmission equipment in the database according to the quality metrics of all power transmission equipment.

[0118] The quality metric reflecting the data quality of the power transmission equipment is obtained through the above steps. Based on the quality metric of all power transmission equipment, the data set of all power transmission equipment in the database is cleaned to improve the quality of the cleaned data in the database.

[0119] Preferably, in one embodiment of the present invention, the method for cleaning the data set of all power transmission equipment in the database includes:

[0120] The power transmission equipment whose quality metric is less than the preset quality threshold is marked as a problem equipment, and the corresponding data set of all problem equipment in the database is screened out to obtain a cleaned database. In one embodiment of the present invention, the preset quality threshold is 0.68, which can be set by the implementer according to the implementation scenario. Specifically, since the quality metric can more accurately reflect the possibility that the power transmission equipment is a normal power transmission equipment, it can better determine the problem equipment with unreasonable design scheme, thereby ensuring the data quality of the cleaned database.

[0121] In summary, the embodiment of the present invention provides a big data collection method for the cost of power transmission equipment. First, the procurement impact of the power transmission equipment is obtained according to the difference in the stage amount and the difference in the reference degree of the procurement stage of the power transmission equipment; the design impact of the power transmission equipment is obtained according to the stage amount and stage duration corresponding to the design stage of the power transmission equipment and the reference degree of the power transmission equipment; the quality metric of the power transmission equipment is obtained according to the procurement impact, design impact and reference degree; and the data set of all power transmission equipment in the database is cleaned according to the quality metric of all power transmission equipment. In the embodiment of the present invention, the quality metric is constructed to more accurately reflect the data quality of the power transmission equipment, so that the data cleaning is better performed to ensure the quality of the data.

[0122] It should be noted that the sequence of the above embodiments of the present invention is only for description and does not represent the advantages and disadvantages of the embodiments. The processes depicted in the accompanying drawings do not necessarily require the specific order or continuous order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0123] The various embodiments in this specification are described in a progressive manner, and the same or similar parts between the various embodiments can be referenced to each other, and each embodiment focuses on the differences from other embodiments.

Claims

1. A big data collection method for power transmission equipment cost, characterized in that: The method comprises: Acquire a data set of each power transmission equipment in the database; the data set includes: the unit price and quantity of each project in the design stage, the procurement stage, the construction stage, and the maintenance stage, the stage amount, and the stage duration; According to the difference between the unit price of each item of the power transmission equipment and its corresponding preset standard unit price, the normality of the unit price of the power transmission equipment is obtained; according to the normality of the unit price of the power transmission equipment, the stage duration of the design stage, the stage amount of the procurement stage, the stage duration of the construction stage, and the number of items of all items in the maintenance stage, the reference degree of the power transmission equipment is obtained; Obtain the procurement impact of the power transmission equipment according to the difference in the stage amounts and the difference in the reference degree of the procurement stage of the power transmission equipment; obtain the design impact of the power transmission equipment according to the stage amount and stage duration corresponding to the design stage of the power transmission equipment and the reference degree of the power transmission equipment; obtain the quality metric of the power transmission equipment according to the procurement impact, the design impact and the reference degree; According to the quality metrics of all power transmission equipment, the data set of all power transmission equipment in the database is cleaned.

2. A big data collection method for power transmission equipment cost according to claim 1, characterized in that: The method for obtaining the unit price normality includes: Obtaining a first deviation value for each item of the power transmission equipment according to a difference between the item unit price of each item of the power transmission equipment and its corresponding preset standard unit price; The unit price normality of the power transmission equipment is obtained according to the overall distribution of the first deviation values ​​of all items of the power transmission equipment.

3. A big data collection method for power transmission equipment cost according to claim 2, characterized in that: The method for obtaining the normality of the unit price of the power transmission equipment according to the overall distribution of the first deviation values ​​of all items of the power transmission equipment comprises: The average of the first deviation values ​​of all items of the power transmission equipment is calculated to obtain the second deviation value; the second deviation value is inversely normalized to obtain the unit price normality of the power transmission equipment.

4. The big data collection method for power transmission equipment cost according to claim 1 is characterized in that: The method for obtaining the reference degree includes: According to the stage duration of the design stage, the stage amount of the procurement stage and the stage duration of the construction stage, the construction problem rate of the power transmission equipment is obtained; the stage duration of the design stage and the stage duration of the construction stage are both positively correlated with the construction problem rate, and the stage amount of the procurement stage is negatively correlated with the construction problem rate; The number of projects of all projects in the comprehensive maintenance phase is used to obtain the equipment failure rate of the power transmission equipment; the number of projects and the equipment failure rate are positively correlated; According to the construction problem rate and the equipment failure rate, obtaining equipment reference parameters of the power transmission equipment; the construction problem rate and the equipment failure rate are both negatively correlated with the equipment reference parameters of the power transmission equipment; The reference degree of the power transmission equipment is obtained according to the equipment reference parameter and the unit price normality.

5. The big data collection method for power transmission equipment cost according to claim 1 is characterized in that: The method for obtaining the procurement influence includes: The data set of the power transmission equipment also includes the total equipment amount of the power transmission equipment; according to the proportion of the stage amount of the power transmission equipment procurement stage in the total equipment amount, the procurement amount proportion parameter of the power transmission equipment is obtained; Obtaining comparison equipment for power transmission equipment based on the differences between the procurement amount ratio parameters of all power transmission equipment; According to the difference in the purchase amount ratio parameters between the power transmission equipment and the comparison equipment, a purchase amount difference index is obtained; Obtaining a reference difference index according to a difference in the reference degree between the power transmission device and the comparison device; According to the reference difference index and the purchase amount difference index, the purchase influence of the power transmission equipment is obtained; the reference difference index and the purchase influence are negatively correlated; the purchase amount difference index and the purchase influence are positively correlated.

6. A big data collection method for power transmission equipment cost according to claim 5, characterized in that: The method for obtaining the comparison device includes: Any power transmission device is used as a first device to be analyzed, and all power transmission devices except the first device to be analyzed are used as second devices to be analyzed of the first device to be analyzed; The absolute value of the difference between the purchase amount ratio parameters of the first device to be analyzed and the second device to be analyzed is calculated, and the smallest absolute value of the difference is corresponding to the second device to be analyzed as the comparison device of the first device to be analyzed.

7. The big data collection method for power transmission equipment cost according to claim 1 is characterized in that: The method for obtaining the design influence comprises: According to the corresponding stage amount and stage duration of the design stage of the power transmission equipment, the design complexity of the power transmission equipment is obtained; The design influence of the power transmission equipment is obtained according to the design complexity and reference degree of the power transmission equipment; the design complexity and the design influence are positively correlated; the reference degree and the design influence are negatively correlated.

8. A big data collection method for power transmission equipment cost according to claim 7, characterized in that: The method for obtaining the design complexity includes: Calculate the product of the corresponding stage amount and stage duration of the design stage of the power transmission equipment to obtain the design input cost of the power transmission equipment; The data set of the power transmission equipment also includes the total equipment amount and the total equipment duration of the power transmission equipment; the product of the total equipment amount and the total equipment duration of the power transmission equipment is calculated to obtain the overall investment cost of the power transmission equipment; The ratio of the design input cost to the overall input cost is calculated to obtain the design complexity of the power transmission equipment.

9. The big data collection method for power transmission equipment cost according to claim 1, characterized in that: The quality measurement method includes: Calculating the absolute value of the difference between the procurement impact and the design impact to obtain an impact difference index; The sum of the impact difference index and the preset denominator adjustment index is calculated, and the ratio of the reference degree to the sum is calculated to obtain the quality metric of the power transmission equipment.

10. The big data collection method for power transmission equipment cost according to claim 1, characterized in that: The method for cleaning the data set of all power transmission equipment in the database includes: The transmission equipment whose quality metric is less than the preset quality threshold is marked as problematic equipment, and the data sets corresponding to all problematic equipment in the database are filtered out to obtain a cleaned database.

Images