CN114049082A - Power grid technical improvement overhaul cost data structuring method - Google Patents
Power grid technical improvement overhaul cost data structuring method Download PDFInfo
- Publication number
- CN114049082A CN114049082A CN202111325764.4A CN202111325764A CN114049082A CN 114049082 A CN114049082 A CN 114049082A CN 202111325764 A CN202111325764 A CN 202111325764A CN 114049082 A CN114049082 A CN 114049082A
- Authority
- CN
- China
- Prior art keywords
- data
- project
- overhaul
- cost
- power grid
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 230000006872 improvement Effects 0.000 title claims abstract description 61
- 238000000034 method Methods 0.000 title claims abstract description 34
- 230000008439 repair process Effects 0.000 claims abstract description 19
- 238000012986 modification Methods 0.000 claims abstract description 14
- 230000004048 modification Effects 0.000 claims abstract description 14
- 238000010276 construction Methods 0.000 claims description 32
- 238000004364 calculation method Methods 0.000 claims description 17
- 238000004458 analytical method Methods 0.000 claims description 16
- 238000003860 storage Methods 0.000 claims description 10
- 238000012795 verification Methods 0.000 claims description 10
- 230000000007 visual effect Effects 0.000 claims description 9
- 238000004140 cleaning Methods 0.000 claims description 6
- 238000013480 data collection Methods 0.000 claims description 4
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000013461 design Methods 0.000 claims description 3
- 230000008569 process Effects 0.000 claims description 3
- 238000000926 separation method Methods 0.000 claims description 2
- 238000012545 processing Methods 0.000 abstract description 7
- 238000007405 data analysis Methods 0.000 abstract description 3
- 230000007547 defect Effects 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 7
- 238000009826 distribution Methods 0.000 description 6
- 230000005540 biological transmission Effects 0.000 description 4
- 230000009466 transformation Effects 0.000 description 4
- 230000008901 benefit Effects 0.000 description 3
- 238000013500 data storage Methods 0.000 description 3
- 238000009434 installation Methods 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 238000011156 evaluation Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000009430 construction management Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000004870 electrical engineering Methods 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 238000010606 normalization Methods 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Computational Linguistics (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Probability & Statistics with Applications (AREA)
- General Health & Medical Sciences (AREA)
- Operations Research (AREA)
- Mathematical Physics (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Fuzzy Systems (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a structuring method of power grid technical modification and overhaul cost data, which has the defect that the structuring processing of the power grid technical modification and overhaul cost data is difficult to realize compared with the prior art. The invention comprises the following steps: acquiring cost data of the past year; data standardization processing; warehousing of standardized data; the power grid technical improvement major repair cost data is displayed in a structured mode. The invention solves the problems of inconsistent data formats and difficult structuralization of the technical overhaul project, and improves the quality and efficiency of data analysis and statistics work.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a power grid technical improvement and overhaul manufacturing cost data structuring method.
Background
In the construction management of a power grid technical improvement and major repair project, investment management and control are important links, and the economic benefit and the social benefit of the project and an enterprise are directly influenced. At present, the technical level of the technical overhaul project is different, and related data are mastered in hands of corresponding professional managers, so that the problems of inaccurate evaluation of the technical overhaul project, over-evaluation of project settlement, high auditing difficulty, high post-settlement dispute and the like cannot be solved all the time due to the lack of unified data dimension format requirement and depth analysis, and the problems bring about not less burden and pressure to related personnel.
For the power grid technical improvement and overhaul cost data, the project data formats are inconsistent and are difficult to structure, and the structural processing is difficult to realize. Therefore, how to perform structured processing on the power grid technical modification and overhaul cost data becomes a technical problem to be solved urgently.
Disclosure of Invention
The invention aims to solve the defect that the structuring processing of the power grid technical modification overhaul cost data is difficult in the prior art, and provides a power grid technical modification overhaul cost data structuring method to solve the problems.
In order to achieve the purpose, the technical scheme of the invention is as follows:
a power grid technical improvement major repair cost data structuring method comprises the following steps:
acquiring cost data of the past year: collecting and acquiring technical improvement and overhaul cost data of the power grid over the years;
and (3) data standardization treatment: carrying out data cleaning on the acquired technical improvement and major repair cost data of the power grid in the past year to form a standardized data specification;
warehousing of standardized data: performing data warehousing and structured storage on the power grid technical improvement overhaul standardized data to generate a technical improvement overhaul project information base;
the power grid technical improvement and overhaul cost data structured display: and constructing a deep analysis model based on the data of the technical improvement and major repair project information base, performing data grouping and statistical comparison after extracting core index data, and visually displaying a statistical result in a chart form.
The data normalization process comprises the following steps:
carrying out data cleaning and conversion on technical improvement and major repair cost data of the power grid in the past year;
dividing power grid technical improvement and overhaul cost data of all the years into structured settlement data and unstructured estimation and calculation and analysis basic data;
the structured calculation data is obtained through a data interface;
and forming a standard construction cost data collection standard for the unstructured estimation approximate calculation and analysis basic data by formulating a construction cost data standard template, wherein the construction cost data standard template comprises an estimation book, an approximate calculation book and a settlement book.
The warehousing of the standardized data comprises the following steps:
classifying the standardized data according to project stage information, wherein the project stage information comprises conventional technical modification, conventional overhaul, information technical modification, information overhaul project types, feasibility study estimation, preliminary design approximate calculation and completion drawing settlement;
configuring the header of the cost book of the project stage information through fields by adopting a configuration method of the dynamic header to dynamically build the table;
the method comprises the following specific steps of putting a cost book into a warehouse in an EXCEL format:
configuring a core business report template format based on different project types and project stages, wherein the core business report template format comprises a table name of each report and contents of header fields in the report; if the table names have differences, compatibility is carried out in a separation mode;
format verification is carried out when the EXCEL cost book is put in storage, whether a core report exists or not is verified preferentially, if the core report does not exist, the verification is finished, and error information is thrown out; and if yes, checking whether the header field in each core business report is in compliance, throwing error information out if the header field in each core business report is in compliance, if all the reports are in compliance, warehousing, and storing related data into a structured database according to a unified standard in a sub-table mode to form a technical improvement overhaul project information base.
The structured display of the power grid technical improvement and overhaul cost data comprises the following steps:
aiming at a technical improvement and major repair project information base, searching a numerical relation among all factors by utilizing a gray level correlation method through the correlation of the construction cost and the project attribute of each project type;
wherein, the relevance is used for measuring the relevance size of the factors between the cost and the project attribute which are changed along with the difference of the attribute parameters;
according to the voltage level and the item type information, value information hidden in data is found through a gray level correlation method according to the specification, and the cost conditions of the items of conventional technical improvement, conventional overhaul, information technical improvement and information overhaul are analyzed in a classified manner;
constructing a data depth analysis model based on the relationship between the construction cost and the project attribute, and analyzing the data condition from multiple dimensions, wherein the multiple dimensions comprise a matched project type, a matched typical project type, a matched voltage grade and a voltage grade project annual unit construction cost statistic;
and generating visual display by using visual software according to the structured data of the power grid technical improvement and major repair cost data summarized above.
Advantageous effects
Compared with the prior art, the structuring method of the power grid technical modification overhaul cost data solves the problems that the technical modification overhaul project data formats are inconsistent and are difficult to structure, and improves the quality and efficiency of data analysis and statistics work.
The technical expense information with different fineness is highlighted from different dimensions, and the rationality of the technical expense is analyzed in an auxiliary manner; the observation, utilization and traceability of the cost data of the technical overhaul project are realized; the multi-dimensional statistics of the technical improvement overhaul data is realized, and the efficiency of analysis work is improved; the technical channel work efficiency and the cost management lean level are improved.
Drawings
FIG. 1 is a sequence diagram of the method of the present invention;
FIG. 2 is a diagram showing a structured data format according to an embodiment of the present invention;
FIG. 3 is a data sub-table storage presentation diagram according to an embodiment of the present invention;
FIG. 4 is a diagram showing basic attributes of an analytical model of a technical improvement project according to an embodiment of the present invention;
fig. 5 is a visualization display diagram of structured data of power grid technical improvement and major repair cost data according to an embodiment of the present invention.
Detailed Description
So that the manner in which the above recited features of the present invention can be understood and readily understood, a more particular description of the invention, briefly summarized above, may be had by reference to embodiments, some of which are illustrated in the appended drawings, wherein:
the construction cost information data is structured after the relevant formats of the data in the whole process are analyzed by collecting the work construction cost data over the years, the structured data is collected and integrated through an informatization means, and then the structured data is utilized to carry out relevant application work. As shown in fig. 1, the method for structuring the cost data of power grid technical improvement and overhaul according to the present invention includes the following steps:
step one, acquiring the cost data of the past year: and collecting and acquiring the power grid technical improvement and overhaul cost data of the past year.
Step two, data standardization treatment: and (4) carrying out data cleaning on the acquired technical improvement and major repair cost data of the power grid in the past year to form a standardized data specification. The method comprises the following specific steps:
(1) because the power grid technical improvement and overhaul project has more data sources, including a power grid full-service unified data center and an unstructured management platform, power grid technical improvement and overhaul cost data of all the years are subjected to data cleaning and conversion.
(2) The technical improvement and overhaul cost data of the power grid over the years are divided into structured settlement data and unstructured estimation and calculation and analysis basic data.
(3) And the structured calculation data is acquired through a data interface.
(4) And forming a standard construction cost data collection standard for the unstructured estimation approximate calculation and analysis basic data by formulating a construction cost data standard template, wherein the construction cost data standard template comprises an estimation book, an approximate calculation book and a settlement book. Therefore, standard construction cost data collection specifications are formed, standardization and unification of basic construction cost data are effectively specified, and a data analysis work tamping foundation is formed.
Step three, standardized data storage: and performing data warehousing and structured storage on the power grid technical improvement overhaul standardized data to generate a technical improvement overhaul project information base. The method comprises the following specific steps:
(1) the standardized data is classified according to project stage information, wherein the project stage information comprises conventional technical modification, conventional overhaul, information technical modification, information overhaul project types, feasibility study estimation, preliminary design approximate calculation and completion drawing settlement.
(2) And (4) adopting a configuration method of the dynamic table header to configure the table header for the cost book of the project stage information through the field, and dynamically building the table. Because the formats of the construction books of different types of projects are different, the construction book files with smaller difference (such as different field names but the same actual meanings) are configured by adopting a dynamic header configuration method, the construction book files do not need to be re-developed when the format difference of the construction books is smaller, a new template is reconfigured to support the storage of a new form, the dynamic table building is realized only by configuring the header through the field, and the storage of different construction books is supported as much as possible.
(3) The method comprises the following specific steps of putting a cost book into a warehouse in an EXCEL format:
A1) configuring a core business report template format based on different project types and project stages, wherein the core business report template format comprises a table name of each report and contents of header fields in the report; if the table names have slight differences, compatibility is carried out in a similar & separated mode;
A2) format verification is carried out when the EXCEL cost book is put in storage, whether a core report exists or not is verified preferentially, if the core report does not exist, the verification is finished, and error information is thrown out; and if yes, checking whether the header field in each core business report is in compliance, throwing error information out if the header field in each core business report is in compliance, if all the reports are in compliance, warehousing, and storing related data into a structured database according to a unified standard in a sub-table mode to form a technical improvement overhaul project information base.
Fourthly, the power grid technical improvement and overhaul cost data are displayed in a structured mode: and constructing a deep analysis model based on the data of the technical improvement and major repair project information base, performing data grouping and statistical comparison after extracting core index data, and visually displaying a statistical result in a chart form. The method comprises the following specific steps:
(1) aiming at a technical improvement and major repair project information base, searching a numerical relation among all factors by utilizing a gray level correlation method through the correlation of the construction cost and the project attribute of each project type;
wherein the degree of association is used to measure the degree of association of the factor between the cost and the project attribute which varies with the attribute parameter.
(2) According to the voltage level and the item type information, value information hidden in data is found through a gray level correlation method according to the specification, and the manufacturing cost conditions of the items of conventional technical improvement, conventional overhaul, information technical improvement and information overhaul are analyzed in a classification way.
(3) And constructing a data depth analysis model based on the relationship between the construction cost and the project attribute, and analyzing the data condition from multiple dimensions, wherein the multiple dimensions comprise a matched project type, a matched typical project type, a matched voltage level and a voltage level project annual unit construction cost statistic.
(4) And generating visual display by using visual software according to the structured data of the power grid technical improvement and major repair cost data summarized above.
Here, for example, the technical improvement project can be structured and put in storage of an estimation book, the technical improvement project estimation book is generally divided into core reports such as a first general calculation table, a second engineering summary table, a third engineering detail table, a fourth other expense table, a first equipment master summary table and the like from large to small, and the table field information and the structure of each report are different, so that a data storage mode needs to be constructed in a sub-table manner. When analyzing the available estimation book, all the engineering quantities in the construction engineering, the installation engineering and the dismantling engineering in the estimation book are required to be specified, including the engineering quantities of quota, main materials, equipment and the like.
The specific method comprises the following steps:
(1) and (4) format checking, namely checking the table names of the first table, the second table, the third table, the fourth table and the first master material summary table of the equipment, allowing the next step to be carried out when the names are specified by the table name specifications, and otherwise, prompting error information.
And (3) specification of table names: the technical reconstruction project summary table I, the technical reconstruction installation project major summary table II, the technical reconstruction building project major summary table II, the dismantling project major summary table II, the technical reconstruction installation project table III, the technical reconstruction building project table III, the dismantling project table tripropyl, the other expense table IV, the first supply equipment summary table I, the second supply equipment summary table II, the first supply main material summary table III and the second supply main material summary table IV.
(2) And (4) format checking, namely checking the header formats of the first table, the second table, the third table, the fourth table and the first main material summary table of the equipment respectively, entering the next step only when the field accords with the checking specification, and otherwise, prompting error information.
And storing the data in a sub-table mode, and constructing a cost database. According to the preset structure of each table, the effective cost data in the tables passing the verification is stored to form a database, and the structured data format can restore the original state to be visually checked by a user according to the structure, as shown in fig. 2.
Structuring technical improvement single project cost basic data:
technical improvement single project cost basic data are generally divided into different types such as alternating current transformation (distribution) electric engineering, alternating current transmission engineering, alternating current relay protection engineering, dispatching automation systems and the like, and table field information and structures of all reports are different, so that a data storage mode needs to be established in a table dividing mode. When analyzing a single project cost basic data table, cost information and attribute parameter information in the basic data table need to be specified, and the specific mode is as follows:
(1) and (4) format checking, namely checking the names of alternating current transformation (distribution) projects, alternating current transmission projects, alternating current relay protection projects and scheduling automation system sheet pages, allowing the next step to be carried out when the names meet requirements, and otherwise, prompting error information.
(2) And (4) format verification, namely respectively verifying the format of the header of the alternating current transformation (distribution) project, the alternating current transmission project, the alternating current relay protection project and the dispatching automation system, entering the next step only when the field conforms to the verification specification, and otherwise, prompting error information.
(3) And storing the data in a sub-table manner, and constructing a single project cost basic database. According to the preset structure of each table, the effective cost and parameter data in the tables passing the verification are stored to form a database, and the structured data format can restore the original state to be visually checked by a user according to the structure, as shown in fig. 3.
Analyzing technical improvement project cost data based on a depth analysis model:
(1) and constructing the basic attributes of the technical improvement project analysis model in a classified manner based on the influence factors influencing the construction cost.
Taking a technical improvement project as an example, the attributes influencing the cost of the project have project categories including an alternating current transformation (distribution) project, an alternating current transmission project, an alternating current relay protection project, a dispatching automation system and the like; the method comprises the following steps that (1) project types are provided, and the corresponding types of each project type are different, wherein the project types take alternating current (distribution) electrical engineering as an example and comprise various types such as transformer replacement, combined electrical appliance replacement, circuit breaker replacement, isolation switch replacement, high-voltage switch cabinet replacement and the like; there are voltage classes, including 35kV, 110kV, 220kV, 500kV, 750kV, etc., as shown in FIG. 4.
(2) And analyzing the distribution condition of the data from multiple dimensions by combining the cost data in the structured database according to the basic attributes.
Matching engineering categories: and counting the typical project quantity and investment amount of different project classes and calculating the investment ratio of the total investment of the projects in all the project classes. Matching typical engineering types: and counting the project quantity and the investment amount of different typical project types and calculating the investment proportion of the total investment of the projects in the project class. Matching voltage class: and counting the quantity of the projects with different voltage levels and the investment amount under different typical projects and calculating the investment ratio of the total investment of the typical projects. And (5) carrying out statistics on annual unit construction cost of the voltage class project. And after the matching is finished, calculating annual unit cost, wherein the calculation rule is as follows: total project investment of the voltage class project/total number (capacity) of corresponding equipment and features in the voltage class project in the year.
Finally, the structured data of the power grid technical overhaul cost data is generated through visual software, as shown in fig. 5, the visual display diagram is a structured data visual display diagram of the power grid technical overhaul cost data, and the structured processing of the power grid technical overhaul cost data is completed.
The foregoing shows and describes the general principles, essential features, and advantages of the invention. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are merely illustrative of the principles of the invention, but that various changes and modifications may be made without departing from the spirit and scope of the invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.
Claims (4)
1. A power grid technical improvement and overhaul construction cost data structuring method is characterized by comprising the following steps:
11) acquiring cost data of the past year: collecting and acquiring technical improvement and overhaul cost data of the power grid over the years;
12) and (3) data standardization treatment: carrying out data cleaning on the acquired technical improvement and major repair cost data of the power grid in the past year to form a standardized data specification;
13) warehousing of standardized data: performing data warehousing and structured storage on the power grid technical improvement overhaul standardized data to generate a technical improvement overhaul project information base;
14) the power grid technical improvement and overhaul cost data structured display: and constructing a deep analysis model based on the data of the technical improvement and major repair project information base, performing data grouping and statistical comparison after extracting core index data, and visually displaying a statistical result in a chart form.
2. The method for structuring construction cost of power grid technical improvement and major repair according to claim 1, wherein the data standardization process comprises the following steps:
21) carrying out data cleaning and conversion on technical improvement and major repair cost data of the power grid in the past year;
22) dividing power grid technical improvement and overhaul cost data of all the years into structured settlement data and unstructured estimation and calculation and analysis basic data;
23) the structured calculation data is obtained through a data interface;
24) and forming a standard construction cost data collection standard for the unstructured estimation approximate calculation and analysis basic data by formulating a construction cost data standard template, wherein the construction cost data standard template comprises an estimation book, an approximate calculation book and a settlement book.
3. The method as claimed in claim 1, wherein the step of storing the standardized data comprises the following steps:
31) classifying the standardized data according to project stage information, wherein the project stage information comprises conventional technical modification, conventional overhaul, information technical modification, information overhaul project types, feasibility study estimation, preliminary design approximate calculation and completion drawing settlement;
32) configuring the header of the cost book of the project stage information through fields by adopting a configuration method of the dynamic header to dynamically build the table;
33) the method comprises the following specific steps of putting a cost book into a warehouse in an EXCEL format:
331) configuring a core business report template format based on different project types and project stages, wherein the core business report template format comprises a table name of each report and contents of header fields in the report; if the table names have differences, compatibility is carried out in a separation mode;
332) format verification is carried out when the EXCEL cost book is put in storage, whether a core report exists or not is verified preferentially, if the core report does not exist, the verification is finished, and error information is thrown out; and if yes, checking whether the header field in each core business report is in compliance, throwing error information out if the header field in each core business report is in compliance, if all the reports are in compliance, warehousing, and storing related data into a structured database according to a unified standard in a sub-table mode to form a technical improvement overhaul project information base.
4. The method for structuring the power grid technical overhaul cost data according to claim 1, wherein the structured display of the power grid technical overhaul cost data comprises the following steps:
41) aiming at a technical improvement and major repair project information base, searching a numerical relation among all factors by utilizing a gray level correlation method through the correlation of the construction cost and the project attribute of each project type;
wherein, the relevance is used for measuring the relevance size of the factors between the cost and the project attribute which are changed along with the difference of the attribute parameters;
42) according to the voltage level and the item type information, value information hidden in data is found through a gray level correlation method according to the specification, and the cost conditions of the items of conventional technical improvement, conventional overhaul, information technical improvement and information overhaul are analyzed in a classified manner;
43) constructing a data depth analysis model based on the relationship between the construction cost and the project attribute, and analyzing the data condition from multiple dimensions, wherein the multiple dimensions comprise a matched project type, a matched typical project type, a matched voltage grade and a voltage grade project annual unit construction cost statistic;
44) and generating visual display by using visual software according to the structured data of the power grid technical improvement and major repair cost data summarized above.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111325764.4A CN114049082A (en) | 2021-11-10 | 2021-11-10 | Power grid technical improvement overhaul cost data structuring method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111325764.4A CN114049082A (en) | 2021-11-10 | 2021-11-10 | Power grid technical improvement overhaul cost data structuring method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114049082A true CN114049082A (en) | 2022-02-15 |
Family
ID=80207954
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111325764.4A Pending CN114049082A (en) | 2021-11-10 | 2021-11-10 | Power grid technical improvement overhaul cost data structuring method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114049082A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114372177A (en) * | 2022-03-22 | 2022-04-19 | 创意信息技术股份有限公司 | Excel table data matching method |
-
2021
- 2021-11-10 CN CN202111325764.4A patent/CN114049082A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114372177A (en) * | 2022-03-22 | 2022-04-19 | 创意信息技术股份有限公司 | Excel table data matching method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107402976B (en) | Power grid multi-source data fusion method and system based on multi-element heterogeneous model | |
| CN105574652B (en) | Intelligent power distribution network planning big data management and control system and method | |
| US5604892A (en) | Method for modeling a physical system of elements using a relational database | |
| CN111159365B (en) | Implementation method, system and storage medium of scheduling model ontology intelligent question-answering system | |
| CN103970887A (en) | Information stream display system and method based on GIS distribution network graphs | |
| CN111461521A (en) | Residential housing vacancy rate analysis method based on electric power big data | |
| CN107844962B (en) | Distribution network engineering cost data collection system based on standard data structure | |
| CN114049082A (en) | Power grid technical improvement overhaul cost data structuring method | |
| CN116340437A (en) | Multi-clustering method for large-scale multi-source heterogeneous data | |
| CN107944659A (en) | A kind of substation supervisory control system auto report completing method and apparatus | |
| CN114092024A (en) | Investment project full-process management method and system | |
| CN108564261A (en) | Method, apparatus and computer equipment are determined based on the power information of work ticket | |
| CN117035532A (en) | Electric power marketing management system and method based on marketing index multidimensional linkage analysis | |
| CN111291546A (en) | Transformer substation equipment monitoring information table carding method based on version difference checking | |
| Skoogh et al. | Time-consumption analysis of input data activities in discrete event simulation projects | |
| CN111127186A (en) | Application method of customer credit rating evaluation system based on big data technology | |
| CN115333232A (en) | Online monitoring method for abnormal starting and stopping state of transformer and related device | |
| CN112200458B (en) | Power distribution network planning data application method and system | |
| CN115330404A (en) | System and method for electric power marketing inspection | |
| CN109214927A (en) | Method based on the investment of national grid General Engineering Cost digital simulation electricity power engineering | |
| CN112445796B (en) | New energy station report generation method | |
| CN114757482A (en) | Method, system, device and medium for analyzing electric quantity use trend of user group | |
| CN114385782A (en) | Nuclear power plant maintenance auxiliary decision-making method based on knowledge graph | |
| CN113313475A (en) | Intelligent skill review method based on big data | |
| CN106066860A (en) | A kind of method of electric power meter management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |