CN115935017A - Secondary measure list generation method, storage medium and equipment - Google Patents
Secondary measure list generation method, storage medium and equipment Download PDFInfo
- Publication number
- CN115935017A CN115935017A CN202211569954.5A CN202211569954A CN115935017A CN 115935017 A CN115935017 A CN 115935017A CN 202211569954 A CN202211569954 A CN 202211569954A CN 115935017 A CN115935017 A CN 115935017A
- Authority
- CN
- China
- Prior art keywords
- original data
- data table
- preset
- measure
- point
- 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
Images
Classifications
-
- 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
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a secondary measure list generation method, a storage medium and equipment, wherein the method comprises the following steps: the method comprises the steps of importing original data into a first original data table to obtain a second original data table, marking cells corresponding to the data which do not accord with preset rules, modifying according to marked position information and a first preset requirement to obtain a third original data table, removing duplication, summarizing and sorting to obtain a starting point end point table and a loop function table, searching and replacing according to the data which do not accord with the second preset requirement and the second preset requirement to obtain a fourth original data table, updating the starting point end point table and the loop function table, generating a first measure table according to a first preset format, summarizing and updating sequence numbers of the first measure table and the preset measure table, generating a second measure table according to the second preset format, summarizing and updating sequence numbers of the second measure table, and generating a secondary measure table according to a measure table template, a pre-operation measure table and an operation measure table. The method can reduce the manual task amount, improve the efficiency and the like.
Description
Technical Field
The invention relates to the technical field of computer application, in particular to a secondary measure list generation method, a storage medium and equipment.
Background
With the development of a power grid, substation equipment is gradually aged, a large number of secondary equipment transformation of the substation are met, and one of applied safety technology control means is a secondary measure list in the process of secondary equipment transformation. Wherein, the secondary measure is singly used for guaranteeing the correctness of work on the secondary circuit and the retrospective nature after the secondary accident happens. Therefore, there are high demands for the correctness and normalization of the secondary measure sheet.
The conventional secondary measure list generation method mainly depends on the pure manual mode of each responsible person to acquire data, compile, typeset, number and audit, and the pure manual mode has the following problems: data are easy to miss when being acquired, so that repeated site survey is caused, and manpower and material resources are consumed; during writing, the handwriting is easy to be mistaken by hands, the requirement is made on the operation level of a writer, manpower and material resources are consumed, the writing efficiency is low, and the requirement of a large amount of current operations cannot be met; during typesetting, the requirement is provided for the operation level of typesetters, and manpower and material resources are consumed; during numbering, because the page number of each page of the secondary measure list and the number of the operation process are corresponding and in sequence, the operation cannot be added or deleted at will according to actual requirements; when the audit is carried out, the audit time is long, the workload is large, the requirement is met on the operation level of auditors, manpower and material resources are consumed, and the efficiency is low.
Disclosure of Invention
Therefore, it is necessary to provide a software method for automatically acquiring data, compiling, composing, numbering and auditing, so as to greatly reduce the amount of manual tasks, improve the working efficiency and save the labor cost.
To achieve the above object, the present invention provides, in a first aspect, a method for generating a secondary measure sheet, the method including:
acquiring original data, and importing each piece of data of the original data into a first original data table to obtain a second original data table;
when the data of the second original data table do not accord with a preset rule, marking the cells corresponding to the data which do not accord with the preset rule, and summarizing the position information of the marked cells to the preset cells;
modifying data corresponding to the second original data table according to the position information in the preset cells and a first preset requirement to obtain a third original data table;
respectively carrying out duplication removal and summary sorting on the data of the third original data table to obtain a starting point end point table and a loop function table;
when the data of the starting point and end point table does not accord with a second preset requirement, and/or when the data of the loop function table does not accord with the second preset requirement, searching and replacing corresponding data in the third original data table according to the data which does not accord with the second preset requirement and the second preset requirement to obtain a fourth original data table, and updating the starting point and end point table and/or the loop function table;
generating a first measure table according to a starting point end point table and the fourth original data table according to a first preset format, summarizing the first measure table and a preset measure table, and updating a serial number to obtain a pre-operation measure table;
generating a second measure table according to the loop function table and the fourth original data table and a second preset format, and summarizing and updating the serial number of the second measure table to obtain an operation measure table;
and determining a measure table template, and generating a secondary measure sheet according to the measure table template, the pre-operation measure table and the operation measure table.
Optionally, the obtaining of the original data and importing each piece of data of the original data into the first original data table to obtain a second original data table includes:
emptying the data of the last fourth original data table to obtain the first original data table;
and acquiring the original data, and sequentially inputting each piece of data of the original data into a preset window template so as to import each piece of data of the original data into a cell corresponding to the first original data table to obtain the second original data table.
Optionally, the obtaining of the original data and importing each piece of data of the original data into the first original data table to obtain a second original data table includes:
emptying the data of the last fourth original data table to obtain the first original data table;
and acquiring the original data in all original data tables in a preset directory, merging and summarizing the original data, and importing each piece of data of the original data into the first original data table to obtain the second original data table.
Optionally, the raw data includes a cable number, a start point, an end point, a start point loop number, an end point loop number, a start point terminal number, an end point terminal number, a loop function, a measure type.
Optionally, when the data of the second original data table does not comply with a preset rule, marking a cell corresponding to the data that does not comply with the preset rule, including:
when the kth starting point of the same cable number of the second original data table is not equal to the kth +1 starting point, marking the cell corresponding to the kth +1 starting point; wherein k is a positive integer greater than 0 in sequence until k +1 is equal to the number of starting points of the same cable number;
when the p-th endpoint of the same cable number of the second original data table is not equal to the p + 1-th endpoint, marking the cell corresponding to the p + 1-th endpoint; wherein, p is a positive integer larger than 0 in sequence until p +1 is equal to the number of the end points of the same cable number;
when the q loop function of the same cable number of the second original data table is not equal to the q +1 loop function, marking the cell corresponding to the q +1 loop function; wherein q is a positive integer greater than 0 in sequence until q +1 is equal to the number of loop functions of the same cable number;
when the starting point loop number of the same row in the second original data table is not equal to the end point loop number, marking the cells corresponding to the starting point loop number and the end point loop number of the same row;
when the measure type in the second original data table is not equal to a preset type, marking the cells corresponding to the measure types not equal to the preset type;
and marking blank cells in the second original data table.
Optionally, the removing duplicate and the collecting and sorting of the data in the third original data table to obtain a starting point end point table and a loop function table respectively includes:
removing duplication of the third original data table according to a starting point to obtain a plurality of unique starting points, removing duplication of the third original data table according to an end point to obtain a plurality of unique end points, respectively determining a plurality of unique starting points and a plurality of unique end points at a first primary row number of the third original data table, and summarizing and sorting the unique starting points, the unique end points and the first primary row number to obtain a starting point and end point table;
and de-duplicating the third original data table according to the loop functions to obtain a plurality of unique loop functions, respectively determining second first line numbers of the plurality of unique loop functions in the third original data table, and summarizing and sorting the plurality of unique loop functions and the second first line numbers to obtain the loop function table.
Optionally, when the data of the start-point and end-point table does not meet a second preset requirement, and/or when the data of the loop function table does not meet the second preset requirement, the step of searching for and replacing the corresponding data in the third original data table according to the data that does not meet the second preset requirement and the second preset requirement to obtain a fourth original data table includes:
when the starting point of the starting point and end point table does not accord with the second preset requirement, the corresponding starting point is searched and replaced for the third original data table according to the starting point which does not accord with the second preset requirement and the second preset requirement, when the end point of the starting point and end point table does not accord with the second preset requirement, the corresponding end point is searched and replaced for the third original data table according to the end point which does not accord with the second preset requirement and the second preset requirement, and when the loop function of the loop function table does not accord with the second preset requirement, the corresponding loop function is searched and replaced for the third original data table according to the loop function which does not accord with the second preset requirement and the second preset requirement, so that the fourth original data table is obtained.
Optionally, the generating a first measure table according to the starting point and ending point table and the fourth original data table according to a first preset format includes:
a hermetic terminal for respectively setting each start point and each end point of the start point and end point table;
and generating the first measure table according to each starting point of the starting point and end point table, the sealing terminal corresponding to each starting point, each end point and each end point, and the fourth original data table according to the first preset format.
To achieve the above object, the present invention provides, in a second aspect, a computer-readable storage medium storing a computer program, which, when executed by a processor, causes the processor to perform the steps of the method according to the first aspect.
To achieve the above object, the present invention provides in a third aspect a computer device comprising a memory and a processor, the memory storing a computer program which, when executed by the processor, causes the processor to perform the steps of the method according to the first aspect.
The embodiment of the invention has the following beneficial effects: acquiring original data, and importing each piece of data of the original data into a first original data table to obtain a second original data table; when the data of the second original data table do not accord with the preset rule, marking the cells corresponding to the data which do not accord with the preset rule, and summarizing the position information of the marked cells into the preset cells; modifying data corresponding to the second original data table according to the position information in the preset cells and the first preset requirement to obtain a third original data table; respectively carrying out duplicate removal and summary sorting on the data of the third original data table to obtain a starting point end table and a loop function table; when the data of the starting point end point table does not accord with the second preset requirement and/or when the data of the loop function table does not accord with the second preset requirement, searching and replacing the corresponding data of the third original data table according to the data which does not accord with the second preset requirement and the second preset requirement to obtain a fourth original data table, and updating the starting point end point table and/or the loop function table; generating a first measure table according to the starting point and end point table and the fourth original data table according to a first preset format, summarizing the first measure table and the preset measure table, and updating the serial number to obtain a pre-operation measure table; generating a second measure table according to the loop function table and the fourth original data table and a second preset format, and summarizing and updating the serial number of the second measure table to obtain an operation measure table; and determining a measure table template, and generating a secondary measure sheet according to the measure table template, the pre-operation measure table and the operation measure table. The method realizes automatic data acquisition, compiling, typesetting, numbering and auditing in a software mode, greatly reduces the manual task amount, improves the working efficiency and saves the labor cost.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the embodiments or the prior art descriptions will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
Wherein:
FIG. 1 is a schematic flow chart of a method for generating a secondary measure sheet in an embodiment of the present application;
FIG. 2 is a diagram illustrating a first raw data table in an embodiment of the present application;
FIG. 3 is a diagram of a second raw data table in an embodiment of the present application;
FIG. 4 is a diagram illustrating a second raw data table after marking cells in an embodiment of the present application;
FIG. 5 is a diagram illustrating a third raw data table in the embodiment of the present application;
FIG. 6 is a diagram illustrating a start-point and end-point table according to an embodiment of the present disclosure;
FIG. 7 is a schematic diagram of a loop function table in an embodiment of the present application;
FIG. 8 is a diagram of a fourth raw data table in an embodiment of the present application;
FIG. 9 is a table of updated start points and end points in the embodiment of the present application;
FIG. 10 is a table of updated loop functions in an embodiment of the present application;
FIG. 11 is a diagram showing a first measure table in the embodiment of the present application;
FIG. 12 is a diagram illustrating a table of predetermined measures in an embodiment of the present application;
FIG. 13 is a schematic view of a pre-job measure table in the embodiment of the present application;
FIG. 14 is a diagram showing a second measure table in the embodiment of the present application;
FIG. 15 is a schematic view of a job measure table in the embodiment of the present application;
FIG. 16 is a schematic diagram of a secondary action sheet generated in an example of the present application;
FIG. 17 is a diagram illustrating a default window template in an embodiment of the present application;
FIG. 18 is a diagram of the original data table 1 in the example of the present application;
FIG. 19 is a diagram of the original data table 2 in the embodiment of the present application;
FIG. 20 is a diagram of the internal structure of a computer device in some embodiments.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Please refer to fig. 1, which is a schematic flow chart diagram of a secondary measure list generation method in an embodiment of the present application, the method including:
step 110: and acquiring original data, and importing each piece of data of the original data into the first original data table to obtain a second original data table.
The original data includes some data required in the process of generating the secondary measure list, for example, the original data includes data such as a cable number, a starting point, an end point, a starting point loop number, an end point loop number, a starting point terminal number, an end point terminal number, a loop function, a measure type and the like; the first raw data table is a data table capable of storing data such as a cable number, a start point, an end point, a start point loop number, an end point loop number, a loop function, a measure type, and the like, and it can be understood that the first raw data table corresponds to a template table, for example, refer to fig. 2, which is a schematic diagram of the first raw data table in the embodiment of the present application, and the first raw data table has cells capable of storing data such as a cable number, a start point, an end point, a start point loop number, an end point terminal number, a loop function, a measure type, and the like.
In some embodiments, after the original data is obtained, data such as each cable number, a start point, an end point, a start point loop number, an end point loop number, a start point terminal number, an end point terminal number, a loop function, and a measure type of the original data is imported into a cell corresponding to the first original data table to obtain a second original data table (i.e., the first original data table in which the original data is stored).
Step 120: when the data of the second original data table do not accord with the preset rule, marking the cells corresponding to the data which do not accord with the preset rule, and summarizing the position information of the marked cells to the preset cells.
The preset rule is a rule preset by an operator according to actual requirements, and when data of the second original data table does not conform to the preset rule, it indicates that the data is in error, and therefore, cells corresponding to the data, which do not conform to the preset rule, of the second original data table need to be marked, for example, please refer to fig. 4, which is a schematic diagram of the second original data table after marking the cells in the embodiment of the present application.
Step 130: and modifying the data corresponding to the second original data table according to the position information in the preset cell and the first preset requirement to obtain a third original data table.
The first preset requirement is preset by an operator according to an actual requirement, and it can be understood that the purpose of setting the first preset requirement is to provide a modification basis when modifying error data, for example, in some embodiments, a third original data table may be obtained after modifying a second original data table (i.e., the second original data table marked with cells shown in fig. 4) according to position information in preset cells and the first preset requirement, and please refer to fig. 5, which is a schematic diagram of the third original data table in the embodiment of the present application.
In other embodiments, the operator does not set the first preset requirement, so the operator may modify the second original data table (i.e., the second original data table marked with cells shown in fig. 4) manually according to the location information in the preset cells to obtain a third original data table (i.e., the third original data table shown in fig. 5).
Step 140: and respectively carrying out duplication removal and summary sorting on the data of the third original data table to obtain a starting point end table and a loop function table.
It should be noted that, because there are multiple start points, end points, and loop functions in the third original data table, and there are many data with the same start point, end point, and loop functions, which are not beneficial to determining whether the data meet the requirements, it is necessary to reduce the data amount, and perform deduplication and summarization sorting on the data in the third original data table to obtain a start point end point table and a loop function table, for example, refer to fig. 6, which is a schematic diagram of the start point end point table in the embodiment of the present application, and refer to fig. 7, which is a schematic diagram of the loop function table in the embodiment of the present application.
Step 150: and when the data of the starting point and end point table does not accord with the second preset requirement and/or when the data of the loop function table does not accord with the second preset requirement, searching and replacing the corresponding data of the third original data table according to the data which does not accord with the second preset requirement and the second preset requirement to obtain a fourth original data table, and updating the starting point and end point table and/or the loop function table.
The second preset requirement is preset by an operator according to an actual requirement, and it can be understood that the purpose of setting the second preset requirement is to screen out non-existent and erroneous data and provide a modification basis when the non-existent and erroneous data exist, for example, in some embodiments, a third original data table shown in fig. 5 may be searched for and substituted for corresponding data according to the data which do not meet the second preset requirement and the second preset requirement to obtain a fourth original data table, please refer to fig. 8, which is a schematic diagram of the fourth original data table in the embodiment of the present application.
It should be noted that, for updating the start-point/end-point table and/or the loop function table, after the fourth original data table is searched and replaced, corresponding error data may be updated, for example, the start-point/end-point table updated by the start-point/end-point table shown in fig. 6 is shown in fig. 9, the loop function table updated by the loop function table shown in fig. 7 is shown in fig. 10, and the loop function table updated by the embodiment of the present application is shown in the present application.
In other embodiments, the operator does not set the second preset requirement, so the operator may manually search the third original data table shown in fig. 5 according to the start-end point table to replace the corresponding data to obtain the fourth original data table shown in fig. 8.
Step 160: and generating a first measure table according to the starting point end point table and the fourth original data table according to a first preset format, summarizing the first measure table and the preset measure table, and updating the serial number to obtain a pre-operation measure table.
In some embodiments, when the start-end-point table needs to be updated, the start-end-point table here is the start-end-point table shown in fig. 9; when the start-point/end-point table does not need to be updated, the start-point/end-point table here is the start-point/end-point table shown in fig. 6.
It should be noted that the first preset format is preset by an operator according to actual requirements, and it can be understood that, because the formats of the safety measures before operation of the secondary measure lists used by the operators in each region have a certain difference, the operator can meet the format requirements of the operators in each region by setting the first preset format, for example, in some embodiments, the first measure table is generated according to the starting point and ending point table (i.e., the starting point and ending point table shown in fig. 9) and the fourth original data table shown in fig. 8 according to the first preset format, refer to fig. 11, which is a schematic diagram of the first measure table in the embodiment of the present application; the preset measure table is some pre-operation safety measures related to the secondary measure sheet, and may be increased or decreased according to the requirement of the operator, and it can be understood that, if there is no pre-operation safety measure related to the secondary measure sheet, the preset measure sheet may be an empty table, please refer to fig. 12, which is a schematic diagram of the preset measure table in the embodiment of the present application.
In some embodiments, after obtaining the first measure table, the first measure table and the preset measure table are merged and summarized together, and the serial number is updated to obtain the pre-operation measure table, please refer to fig. 13, which is a schematic diagram of the pre-operation measure table in the embodiment of the present application.
Step 170: and generating a second measure table according to the loop function table and the fourth original data table according to a second preset format, summarizing the second measure table and updating the serial number to obtain an operation measure table.
In some embodiments, when the loop function table needs to be updated, the loop function table herein is the loop function table shown in fig. 10; when the loop function table does not need to be updated, the loop function table here is the loop function table shown in fig. 7.
It should be noted that the second preset format is preset by an operator according to actual requirements, and it can be understood that, because the formats of the safety measures of the operation process of the secondary measure lists used by the operators in each region have a certain difference, the operator can meet the format requirements of the operators in each region by setting the second preset format, for example, in some embodiments, the second measure table is generated according to the loop function table (i.e., the loop function table shown in fig. 10) and the fourth raw data table shown in fig. 8 according to the second preset format, please refer to fig. 14, which is a schematic diagram of the second measure table in the embodiment of the present application.
In some embodiments, after obtaining the second measure table, the second measure table is summarized and the serial number is updated to obtain the operation measure table, please refer to fig. 15, which is a schematic diagram of the operation measure table in the embodiment of the present application.
Step 180: and determining a measure table template, and generating a secondary measure sheet according to the measure table template, the pre-operation measure table and the operation measure table.
The measure table template is a standard format template of the secondary measure list, can be set by an operator according to actual requirements, and can modify information such as power station names, numbering styles, personnel lists and the like so as to meet the requirements of different power stations.
In some embodiments, after obtaining the measure table template, the data of the pre-job measure table and the job measure table may be imported into the measure table template, so as to generate a secondary measure sheet, please refer to fig. 16, which is a schematic diagram of the secondary measure sheet generated in the example of the present application.
In the embodiment of the application, the data acquisition, the compiling, the typesetting, the numbering and the auditing are automatically realized in a software mode, so that the manual task amount is greatly reduced, the working efficiency is improved, and the labor cost is saved.
In one possible implementation manner, in step 110, obtaining original data, and importing each piece of data of the original data into a first original data table to obtain a second original data table, includes: emptying the data of the last fourth original data table to obtain a first original data table; and acquiring original data, and sequentially inputting each piece of data of the original data into a preset window template so as to import each piece of data of the original data into a cell corresponding to the first original data table to obtain a second original data table.
The preset window template is set by an operator according to the data type of the original data, and if the original data includes data such as a cable number, a start point, an end point, a start point loop number, an end point loop number, a start point terminal number, an end point terminal number, a loop function, a measure type, and the like, the preset window is a window having a data lattice such as a cable number, a start point, an end point, a start point loop number, an end point loop number, a start point terminal number, an end point terminal number, a loop function, a measure type, and the like.
It should be noted that, each time the program is executed, the first original data is processed to obtain the fourth original data table, and therefore, in the next program execution, data in the fourth original data table in the previous time needs to be cleared to obtain the first original data table again.
In some embodiments, after the raw data is obtained, each piece of data (including a cable number, a start point, an end point, a start point loop number, an end point loop number, a start point terminal number, an end point terminal number, a loop function, and a measure type) of the raw data is sequentially input into a data grid corresponding to the preset window template shown in fig. 17, so that each piece of data of the raw data is imported into a cell corresponding to the first raw data table shown in fig. 2 to obtain the second raw data table shown in fig. 3.
In the embodiment of the application, each piece of data of the original data is sequentially input into the preset window template by acquiring the original data, so that each piece of data of the original data is imported into the cell corresponding to the first original data table to obtain the second original data table, and the automatic data acquisition of software is realized, and the problems of manpower and material resources consumption and the like caused by omission in data acquisition are avoided.
In another possible implementation manner, in step 110, obtaining original data, and importing each piece of data of the original data into a first original data table to obtain a second original data table, including: emptying the data of the last fourth original data table to obtain a first original data table; and acquiring original data in all original data tables under a preset directory, merging and summarizing the original data, and importing each piece of data of the original data into the first original data table to obtain a second original data table.
The preset directory is a storage position preset by an operator for storing an original data table; the original data table is a data table having the same format as the first original data table, the second original data table, the third original data table, and the fourth original data table, that is, the original data table also has unit cells of a cable number, a start point, an end point, a start point loop number, an end point loop number, a start point terminal number, an end point terminal number, a loop function, and a measure type, the original data table may be obtained by manual editing during a process of collecting data by an operator, or may be generated in a software manner, for example, the preset directory has an original data table 1 and an original data table 2, refer to fig. 18, which is a schematic diagram of an original data table 1 in the embodiment of the present application, and refer to fig. 19, which is a schematic diagram of an original data table 2 in the embodiment of the present application.
It should be noted that, each time the program is executed, the first original data is processed to obtain the fourth original data table, and therefore, in the next program execution, data in the fourth original data table in the last time needs to be cleared to obtain the first original data table again.
In some embodiments, after acquiring the original data in all the original data tables under the preset directory (i.e. the original data table 1 shown in fig. 18 and the original data table 2 shown in fig. 19), merging and summarizing the original data, importing each piece of data (including a cable number, a start point, an end point, a start point loop number, an end point loop number, a start point terminal number, an end point terminal number, a loop function, and a measure type) of the original data into the first original data table shown in fig. 2 to obtain the second original data table shown in fig. 3, it can be understood that, since the original data table is a data table having the same format as the first original data table, the original data in the original data table can be directly imported into the first original data table to obtain the second original data table.
In the embodiment of the application, the original data in all the original data tables in the preset directory are obtained, and after the original data are merged and aggregated, each piece of data of the original data is imported into the first original data table to obtain the second original data table, so that the automatic data acquisition of software is realized, and the problems of manpower and material resource consumption and the like caused by omission in data acquisition are avoided.
In one possible implementation, the raw data in the embodiments of the present application includes cable number, start point, end point, start point loop number, end point loop number, start point terminal number, end point terminal number, loop function, measure type.
In the embodiment of the application, the data type of the original data is preferably set so that an operator can conveniently determine some data required in the process of generating the secondary measure list according to the understanding.
In one possible implementation manner, in step 120, when the data of the second original data table does not comply with the preset rule, marking the cell corresponding to the data that does not comply with the preset rule, including: when the kth starting point of the same cable number of the second original data table is not equal to the kth +1 starting point, marking the cell corresponding to the kth +1 starting point; wherein k is a positive integer greater than 0 in sequence until k +1 is equal to the number of starting points of the same cable number; when the p-th endpoint of the same cable number of the second original data table is not equal to the p + 1-th endpoint, marking the cell corresponding to the p + 1-th endpoint; wherein, p is a positive integer larger than 0 in sequence until p +1 is equal to the number of the end points of the same cable number; when the q loop function of the same cable number of the second original data table is not equal to the q +1 loop function, marking the cell corresponding to the q +1 loop function; wherein q is a positive integer greater than 0 in sequence until q +1 is equal to the number of loop functions of the same cable number; when the starting point loop number of the same row in the second original data table is not equal to the end point loop number, marking the cells corresponding to the starting point loop number and the end point loop number of the same row; when the measure type in the second original data table is not equal to the preset type, marking the cells corresponding to the measure types which are not equal to the preset type; and marking the blank cells in the second original data table.
The preset type is preset by an operator according to the type of measures operated by actual needs, and specifically, the preset type can be removing, connecting, disconnecting a connecting sheet and the like.
In some embodiments, the operator sets the preset rules to the following conditions according to actual needs: when the kth starting point of the same cable number of the second original data table is not equal to the kth +1 starting point, marking the cells corresponding to the kth +1 starting point, wherein k is a positive integer larger than 0 in sequence until k +1 is equal to the number of the starting points of the same cable number; when the p-th endpoint of the same cable number of the second original data table is not equal to the p + 1-th endpoint, marking the cells corresponding to the p + 1-th endpoint, and sequentially taking positive integers more than 0 for p until the p +1 is equal to the number of the endpoints of the same cable number; when the q loop function of the same cable number of the second original data table is not equal to the q +1 loop function, marking the cells corresponding to the q +1 loop function, and sequentially taking positive integers more than 0 for q until the q +1 is equal to the number of the loop functions of the same cable number; when the starting point loop number of the same row in the second original data table is not equal to the end point loop number, marking the cells corresponding to the starting point loop number and the end point loop number of the same row; when the measure type in the second original data table is not equal to the preset type, marking the cells corresponding to the measure types not equal to the preset type, wherein the preset type is set by an operator according to actual requirements; and marking the blank cells in the second original data table.
For example, please continue to refer to the second original data table shown in fig. 3 and the second original data table shown in fig. 4 after marking the cells, where the same cable number is cable number 2, the number of starting points of the cable number is 4, and k is 1, when the 1 st starting point of the cable number 2 of the second original data table is equal to the 2 nd starting point, k +1 is performed, that is, k is 2, when the 2 nd starting point of the cable number 2 of the second original data table is not equal to the 3 rd starting point, the cell corresponding to the 3 rd starting point is marked, k +1 is performed, that is, k is 3, when the 3 rd starting point of the cable number 2 of the second original data table is not equal to the 4 th starting point, the cell corresponding to the 4 th starting point is marked until 4 is equal to the number of starting points of the cable number 2; when the same cable number is a cable number 1, the number of the end points of the cable number 1 is 3, and p is 1, when the 1 st end point of the cable number 1 of the second original data table is not equal to the 2 nd end point, marking the cell corresponding to the 2 nd end point, and performing p +1, namely when p is 2, when the 2 nd end point of the cable number 1 of the second original data table is not equal to the 3 rd end point, marking the cell corresponding to the 3 rd end point until 3 is equal to the number 3 of the end points of the cable number 1; when the number of the loop functions of the cable number 1 is 3, and q is 1, when the 1 st loop function of the cable number 1 of the second original data table is not equal to the 2 nd loop function, marking the cell corresponding to the 2 nd loop function, and performing q +1, namely when q is 1, when the 2 nd loop function of the cable number 1 of the second original data table is not equal to the 3 rd loop function, marking the cell corresponding to the 3 rd loop function until 3 is equal to the number 3 of the loop functions of the cable number 1; when the loop function 2 of the cable number 1 of the second original data table is not equal to the loop function 1, marking the cell corresponding to the loop function 1 until 3 is equal to the number 3 of the loop functions of the cable number 1; in the 3 rd row of the same cable number 1, when the starting point loop number of the 3 rd row of the cable number 1 in the second original data table is not equal to the end point loop number, marking the cell corresponding to the starting point loop number and the end point loop number of the 3 rd row of the cable number 1; the preset type is a measure type 1, and when the measure type (measure type 3) in the second original data table is not equal to the measure type 1, the cell corresponding to the measure type which is not equal to the measure type 1 is marked; and marking blank cells in the second original data table.
In the embodiment of the application, the starting point, the end point, the loop function, the starting point loop number, the end point loop number, the blank cell and the like are automatically checked for errors, so that the checking efficiency is high, the manual task amount is greatly reduced, and the labor cost is saved.
In one possible implementation manner, in step 140, the data in the third original data table is subjected to deduplication and summary sorting respectively to obtain a starting point end point table and a loop function table, including: removing duplication of a third original data table according to a starting point to obtain a plurality of unique starting points, removing duplication of the third original data table according to an end point to obtain a plurality of unique end points, respectively determining a plurality of unique starting points and a plurality of unique end points at first primary line numbers of the third original data table, and summarizing and sorting the unique starting points, the unique end points and the first primary line numbers to obtain a starting point end point table; and repeating the third original data table according to the loop functions to obtain a plurality of unique loop functions, respectively determining second first line numbers of the plurality of unique loop functions in the third original data table, and summarizing and sequencing the plurality of unique loop functions and the second first line numbers to obtain a loop function table.
The first initial line number is a line number of which the starting point and the end point appear for the first time in the third original data table, namely, the unique starting point and the unique end point obtained after the multiple starting points and the multiple end points are subjected to deduplication, and the line number of which the unique starting point and the unique end point appear for the first time in the third original data table before deduplication; the second first line number is a line number of the loop function appearing in the third original data table for the first time, namely, the unique loop function obtained after the multiple loop functions are subjected to de-duplication, and the line number of the unique loop function appearing in the third original data table for the first time before de-duplication.
In some embodiments, the loop function table shown in fig. 6 and the loop function table shown in fig. 7 are obtained by performing deduplication and summary sorting on the start point, the end point, and the loop function of the third raw data table shown in fig. 5.
In the embodiment of the application, the starting point, the end point and the loop function are deduplicated, and the first line number and the second first line number are set, so that whether the starting point, the end point and the loop function are not in accordance with the requirement is further judged, and the data which is not in accordance with the requirement is further searched and replaced.
In a possible implementation manner, in step 150, when the data in the start-point/end-point table does not meet the second preset requirement, and/or when the data in the loop function table does not meet the second preset requirement, the step of searching the third original data table according to the data that does not meet the second preset requirement and the second preset requirement to replace the corresponding data to obtain a fourth original data table includes: when the starting point of the starting point and end point table does not accord with the second preset requirement, the third original data table is searched and replaced by the corresponding starting point according to the starting point which does not accord with the second preset requirement and the second preset requirement, when the end point of the starting point and end point table does not accord with the second preset requirement, the third original data table is searched and replaced by the corresponding end point according to the end point which does not accord with the second preset requirement and the second preset requirement, and when the loop function of the loop function table does not accord with the second preset requirement, the third original data table is searched and replaced by the corresponding loop function according to the loop function which does not accord with the second preset requirement and the second preset requirement, so that a fourth original data table is obtained.
For example, please continue to refer to the third original data table shown in fig. 5, the start point and end point table shown in fig. 6, the loop function table shown in fig. 7, and the fourth original data table shown in fig. 8, if the replaceable start point of the second preset requirement is start point 2, the replaceable end point is end point 4, and the replaceable loop function is loop function 2, when the start point 3 of the start point and end point table does not meet the second preset requirement, the third original data table is searched for and replaced by the corresponding start point 3 according to the start point 3 and the second preset requirement (start point 2) that do not meet the second preset requirement, that is, the start point 3 is searched for and replaced by the start point 2, when the end point 5 of the start point and end point table does not meet the second preset requirement, the third original data table is searched for and replaced by the corresponding end point 5 according to the end point 5 and the second preset requirement (end point 4) that do not meet the second preset requirement, that the end point 5 is searched for the end point 4, and when the loop function 3 of the loop function table does not meet the second preset requirement, the third original data table is replaced by the corresponding end point 3, that the original data table is searched for the loop function table, that obtain the fourth original loop function table 2.
In the embodiment of the application, the starting point and the end point which do not meet the second preset requirement in the starting point and end point table are searched and replaced with the corresponding starting point and end point, and the loop function which does not meet the second preset requirement in the loop function table is searched and replaced with the corresponding loop function, so that the fourth original data table of accurate data of the starting point, the end point, the loop function and the like is obtained, and an accurate secondary measure list is obtained.
In one possible implementation, in step 160, generating a first measure table according to the start-point-end-point table and the fourth original data table in a first preset format includes: a hermetic terminal for respectively setting each start point and each end point of the start point and end point table; and generating a first measure table according to each starting point of the starting point and end point table, the sealing terminal corresponding to each starting point, each end point, the sealing terminal corresponding to each end point and a fourth original data table according to a first preset format.
In some embodiments, please continue to refer to the start point and end point table shown in fig. 9, the fourth original data table shown in fig. 8, and the first measure table shown in fig. 11, that is, the seal terminals of each start point and each end point of the start point and end point table may be set separately, and then the first measure table may be generated according to the first preset format according to the seal terminals of each start point and each start point, the seal terminals of each end point and each end point of the start point and end point table, it is understood that, by setting the seal terminals of each start point and each end point in the start point and end point table, when the seal terminals of the start point and the end point have data or the data is "no", the start point and the end point of the seal terminal without data are not generated, or when the data is "no", and the start point and the end point of the seal terminal without data are generated in the first measure table according to the first preset format, that the start point 1 and the end point 3, the end point 2, and the end point 5 generate the measure table according to "measure table except for the seal terminal".
In the embodiment of the application, the sealing terminals of each starting point and each end point of the starting point and end point table are respectively arranged; and generating a first measure table according to each starting point of the starting point and end point table, the sealing terminal corresponding to each end point and the fourth original data table according to a first preset format, so that an operator can generate corresponding safety measures before operation according to actual requirements, and software can automatically generate a secondary measure list.
In an embodiment of the present application, a computer-readable storage medium is provided, which stores a computer program, and when the computer program is executed by a processor, the computer program causes the processor to execute any one of the secondary measure sheet generation methods in the above-mentioned method embodiments.
In some embodiments, a computer device is proposed, comprising a memory and a processor, the memory storing a computer program, the computer program, when executed by the processor, causing the processor to perform any one of the above method embodiments of the secondary measure sheet generation method.
FIG. 20 illustrates an internal block diagram of a computer device in some embodiments. The computer device may be specifically a terminal, a server, or a gateway. As shown in fig. 20, the computer device includes a processor, a memory, and a network interface connected by a system bus.
Wherein the memory includes a non-volatile storage medium and an internal memory. The non-volatile storage medium of the computer device stores an operating system and may also store a computer program, which, when executed by the processor, causes the processor to carry out the steps of the above-described method embodiments. The internal memory may also store a computer program, which, when executed by the processor, causes the processor to perform the steps of the above-described method embodiments. Those skilled in the art will appreciate that the architecture shown in fig. 20 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a non-volatile computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the program is executed.
Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), rambus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A secondary measure list generation method, comprising:
acquiring original data, and importing each piece of data of the original data into a first original data table to obtain a second original data table;
when the data of the second original data table do not accord with a preset rule, marking the cells corresponding to the data which do not accord with the preset rule, and summarizing the position information of the marked cells to the preset cells;
modifying data corresponding to the second original data table according to the position information in the preset cell and a first preset requirement to obtain a third original data table;
performing deduplication and summarizing and sorting on the data of the third original data table respectively to obtain a starting point end point table and a loop function table;
when the data of the starting point and end point table does not accord with a second preset requirement, and/or when the data of the loop function table does not accord with the second preset requirement, searching and replacing corresponding data for the third original data table according to the data which does not accord with the second preset requirement and the second preset requirement to obtain a fourth original data table, and updating the starting point and end point table and/or the loop function table;
generating a first measure table according to a starting point end point table and the fourth original data table according to a first preset format, summarizing the first measure table and a preset measure table, and updating a serial number to obtain a pre-operation measure table;
generating a second measure table according to the loop function table and the fourth original data table and a second preset format, and summarizing and updating the serial number of the second measure table to obtain an operation measure table;
and determining a measure table template, and generating a secondary measure sheet according to the measure table template, the pre-operation measure table and the operation measure table.
2. The method of claim 1, wherein obtaining the raw data and importing each piece of the raw data into a first raw data table to obtain a second raw data table comprises:
emptying the data of the last fourth original data table to obtain the first original data table;
and acquiring the original data, and sequentially inputting each piece of data of the original data into a preset window template so as to import each piece of data of the original data into a cell corresponding to the first original data table to obtain the second original data table.
3. The method of claim 1, wherein obtaining the raw data and importing each piece of the raw data into a first raw data table to obtain a second raw data table comprises:
emptying the data of the last fourth original data table to obtain the first original data table;
and acquiring the original data in all original data tables in a preset directory, merging and summarizing the original data, and importing each piece of data of the original data into the first original data table to obtain the second original data table.
4. The method of claim 1, wherein the raw data includes a cable number, a start point, an end point, a start point loop number, an end point loop number, a start point terminal number, an end point terminal number, a loop function, a measure type.
5. The method according to claim 4, wherein when the data in the second raw data table does not comply with a preset rule, marking a cell corresponding to the data not complying with the preset rule, including:
when the kth starting point of the same cable number of the second original data table is not equal to the kth +1 starting point, marking the cell corresponding to the kth +1 starting point; wherein k is a positive integer greater than 0 in sequence until k +1 is equal to the number of starting points of the same cable number;
when the p-th endpoint of the same cable number of the second original data table is not equal to the p + 1-th endpoint, marking the cell corresponding to the p + 1-th endpoint; wherein, p is a positive integer larger than 0 in sequence until p +1 is equal to the number of the end points of the same cable number;
when the q loop function of the same cable number of the second original data table is not equal to the q +1 loop function, marking the cell corresponding to the q +1 loop function; wherein q is a positive integer greater than 0 in sequence until q +1 is equal to the number of loop functions of the same cable number;
when the starting point loop number of the same row in the second original data table is not equal to the end point loop number, marking the cells corresponding to the starting point loop number and the end point loop number of the same row;
when the measure type in the second original data table is not equal to a preset type, marking the cells corresponding to the measure types not equal to the preset type;
and marking blank cells in the second original data table.
6. The method of claim 4, wherein the de-duplicating and summarizing the data in the third original data table to obtain a starting point destination table and a loop function table respectively comprises:
removing duplication of the third original data table according to a starting point to obtain a plurality of unique starting points, removing duplication of the third original data table according to an end point to obtain a plurality of unique end points, respectively determining a plurality of unique starting points and a plurality of unique end points on a first line number of the third original data table, and summarizing and sequencing the unique starting points, the unique end points and the first line number to obtain a starting point and end point table;
and de-duplicating the third original data table according to the loop functions to obtain a plurality of unique loop functions, respectively determining second first line numbers of the plurality of unique loop functions in the third original data table, and summarizing and sorting the plurality of unique loop functions and the second first line numbers to obtain the loop function table.
7. The method according to claim 4, wherein when the data in the start-point/end-point table does not meet a second predetermined requirement and/or when the data in the loop function table does not meet the second predetermined requirement, the step of searching the third original data table according to the data that does not meet the second predetermined requirement and the second predetermined requirement to replace the corresponding data to obtain a fourth original data table comprises:
when the starting point of the starting point and end point table does not accord with the second preset requirement, the corresponding starting point is searched and replaced for the third original data table according to the starting point which does not accord with the second preset requirement and the second preset requirement, when the end point of the starting point and end point table does not accord with the second preset requirement, the corresponding end point is searched and replaced for the third original data table according to the end point which does not accord with the second preset requirement and the second preset requirement, and when the loop function of the loop function table does not accord with the second preset requirement, the corresponding loop function is searched and replaced for the third original data table according to the loop function which does not accord with the second preset requirement and the second preset requirement, so that the fourth original data table is obtained.
8. The method of claim 4, wherein generating a first measure table according to the start-point-end-point table and the fourth raw data table in a first preset format comprises:
a hermetic terminal for respectively setting each start point and each end point of the start point and end point table;
and generating the first measure table according to each starting point of the starting point and end point table, the sealing terminal corresponding to each starting point, each end point, the sealing terminal corresponding to each end point and the fourth original data table according to the first preset format.
9. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, causes the processor to carry out the steps of the method according to any one of claims 1 to 8.
10. A computer arrangement comprising a memory and a processor, the memory storing a computer program which, when executed by the processor, causes the processor to carry out the steps of the method according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211569954.5A CN115935017A (en) | 2022-12-08 | 2022-12-08 | Secondary measure list generation method, storage medium and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211569954.5A CN115935017A (en) | 2022-12-08 | 2022-12-08 | Secondary measure list generation method, storage medium and equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115935017A true CN115935017A (en) | 2023-04-07 |
Family
ID=86655356
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211569954.5A Pending CN115935017A (en) | 2022-12-08 | 2022-12-08 | Secondary measure list generation method, storage medium and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115935017A (en) |
-
2022
- 2022-12-08 CN CN202211569954.5A patent/CN115935017A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109388566B (en) | Code coverage rate analysis method, device, equipment and storage medium | |
| CN108804708B (en) | Method and device for archiving and correcting business data table, computer equipment and storage medium | |
| CN109376142B (en) | Data migration method and terminal equipment | |
| CN107394892B (en) | Method and system for determining debugging range of interval change of intelligent substation | |
| CN112214617B (en) | Digital file management method and system based on block chain technology | |
| JP5552487B2 (en) | Raster image processor automatic test method | |
| CN112434003B (en) | SQL optimization method and device, computer equipment and storage medium | |
| CN114661584A (en) | Testing device for software testing and using method | |
| CN113722872B (en) | Method for extracting start and end point attributes of roads in batch in urban area road network | |
| CN111724110A (en) | Address information processing method and device, computer equipment and storage medium | |
| CN114510536A (en) | Data verification method and device, computer equipment and storage medium | |
| CN110806977A (en) | Test case set generation method and device based on product requirements and electronic equipment | |
| CN107844515B (en) | Data compliance checking method and device | |
| CN115935017A (en) | Secondary measure list generation method, storage medium and equipment | |
| CN113535563A (en) | Test case duplication removing method and device, computer equipment and storage medium | |
| CN113220588A (en) | Automatic testing method, device and equipment for data processing and storage medium | |
| CN115686493A (en) | Method for automatically generating interface control document by C language data structure code | |
| CN115906795A (en) | System and method for rapidly acquiring single machine component model information based on digital satellite management system | |
| CN115794618A (en) | Method and device for detecting repeated application function module | |
| CN111414582B (en) | Photovoltaic theoretical power calculation method, device, equipment and storage medium | |
| CN112948173A (en) | Data recovery method, device, equipment and medium | |
| CN112527757A (en) | Rapid retrieval method based on large-scale chip test result | |
| CN112347095B (en) | Data table processing method, device and server | |
| CN117591531B (en) | Remote data synchronization method and system for database | |
| CN108334316B (en) | Application development implementation method and device |
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 |