A secondary measure single generation method, storage medium and device

Abstract

Embodiments of the present application disclose a secondary measure single generation method, a storage medium and equipment, the method comprising: importing original data into a first original data table to obtain a second original data table, marking cells corresponding to data that does not meet a preset rule, and modifying the second original data table according to the position information of the marked cells and a first preset requirement to obtain a third original data table, and de-duplicating and sorting the third original data table to obtain a start-end table and a loop function table, finding and replacing data that does not meet a second preset requirement according to the second preset requirement to obtain a fourth original data table, updating the start-end table and the loop function table, generating a first measure table according to a first preset format, summarizing the first measure table and a preset measure table and updating the sequence numbers, generating a second measure table according to a second preset format, summarizing the second measure table and updating the sequence numbers, and generating a secondary measure single according to a measure table template, a pre-operation measure table and an operation measure table. The method can reduce the amount of manual tasks and improve efficiency.

Description

Technical Field

[0001] This invention relates to the field of computer application technology, and in particular to a method, storage medium, and device for generating secondary measure sheets. Background Technology

[0002] With the development of power grids, substation equipment is gradually aging, leading to a large number of secondary equipment upgrades in substations. One of the safety control measures used during these upgrades is the secondary action sheet. This sheet ensures the correctness of operations on secondary circuits and facilitates traceability in the event of secondary accidents. Therefore, high standards are required for the accuracy and standardization of the secondary action sheet.

[0003] The current method for generating secondary measure orders mainly relies on individuals manually acquiring data, writing, formatting, numbering, and reviewing them. This purely manual method has the following problems: data acquisition is prone to omissions, leading to repeated on-site inspections and wasting manpower and resources; writing is prone to typos and word errors, and requires a certain level of skill from the writers, wasting manpower and resources, and is inefficient, no longer meeting the demands of today's large volume of work; formatting requires a certain level of skill from the formatters, wasting manpower and resources; numbering requires that each page number and the work process number correspond and be sequential, preventing the addition or deletion of work according to actual needs; and review is time-consuming and labor-intensive, requires a certain level of skill from the reviewers, wasting manpower and resources, and is inefficient. Summary of the Invention

[0004] Therefore, it is necessary to address the above problems by proposing a software-based approach to automatically acquire, write, format, number, and review data, which greatly reduces the workload of manual labor, improves work efficiency, and saves labor costs.

[0005] To achieve the above objectives, the present invention provides a method for generating a secondary measure sheet in a first aspect, the method comprising:

[0006] Obtain the raw data and import each piece of data from the raw data into the first raw data table to obtain the second raw data table;

[0007] When the data in the second original data table does not conform to the preset rules, the cells corresponding to the data that does not conform to the preset rules are marked, and the position information of the marked cells is summarized into the preset cells;

[0008] The third original data table is obtained by modifying the data corresponding to the second original data table according to the position information in the preset cell and the first preset requirements;

[0009] Data in the third original data table is respectively de-duplicated and summarized and sorted to obtain a start-end point table and a loop function table;

[0010] When data in the start-end point table does not meet the second preset requirement, and / or when data in the loop function table does not meet the second preset requirement, the third original data table is looked up and replaced with corresponding data according to the data that does not meet the second preset requirement and the second preset requirement to obtain a fourth original data table, and the start-end point table and / or the loop function table is updated;

[0011] A first measure table is generated according to the start-end point table and the fourth original data table in a first preset format, and the first measure table and a preset measure table are summarized and updated in sequence number to obtain a pre-operation measure table;

[0012] A second measure table is generated according to the loop function table and the fourth original data table in a second preset format, and the second measure table is summarized and updated in sequence number to obtain an operation measure table;

[0013] A measure table template is determined, and a secondary measure sheet is generated according to the measure table template, the pre-operation measure table and the operation measure table.

[0014] Optionally, the original data is obtained, and each piece of data of the original data is imported into a first original data table to obtain a second original data table, including:

[0015] Data in the fourth original data table of the last time is emptied to obtain the first original data table;

[0016] The original data is obtained, and each piece of data of the original data is input into a preset window template in sequence to import each piece of data of the original data into a corresponding cell of the first original data table to obtain the second original data table.

[0017] Optionally, the original data is obtained, and each piece of data of the original data is imported into a first original data table to obtain a second original data table, including:

[0018] Data in the fourth original data table of the last time is emptied to obtain the first original data table;

[0019] The original data in all original data tables under a preset directory is obtained, and each piece of data of the original data is imported into the first original data table to obtain the second original data table after the original data is merged and summarized.

[0020] Optionally, the original 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 and a measure type.

[0021] Optionally, when the data of the second original data table does not conform to the preset rule, marking the cells corresponding to the data that does not conform to the preset rule, comprising:

[0022] When the kth starting point of the same cable number of the second original data table is not equal to the k+1th starting point, marking the cell corresponding to the k+1th starting point; wherein k takes positive integers greater than 0 in turn until k+1 is equal to the number of starting points of the same cable number;

[0023] When the pth end point of the same cable number of the second original data table is not equal to the p+1th end point, marking the cell corresponding to the p+1th end point; wherein p takes positive integers greater than 0 in turn until p+1 is equal to the number of end points of the same cable number;

[0024] When the qth loop function of the same cable number of the second original data table is not equal to the q+1th loop function, marking the cell corresponding to the q+1th loop function; wherein q takes positive integers greater than 0 in turn until q+1 is equal to the number of loop functions of the same cable number;

[0025] 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;

[0026] When the measure type in the second original data table is not equal to the preset type, marking the cell corresponding to the measure type that is not equal to the preset type;

[0027] Marking the blank cells in the second original data table.

[0028] Optionally, the data of the third original data table is respectively de-duplicated and summarized and sorted to obtain a starting point-end point table and a loop function table, comprising:

[0029] The third original data table is de-duplicated by starting point to obtain a plurality of unique starting points, the third original data table is de-duplicated by end point to obtain a plurality of unique end points, the first first row number of the plurality of unique starting points and the plurality of unique end points in the three original data tables is determined, and the plurality of unique starting points, the plurality of unique end points and the first first row number are summarized and sorted to obtain the starting point-end point table;

[0030] The third original data table is de-duplicated by loop function to obtain a plurality of unique loop functions, and the second first row number of the plurality of unique loop functions in the third original data table is determined, and the plurality of unique loop functions and the second first row number are summarized and sorted to obtain the loop function table.

[0031] Optionally, when the data of the start-end table does not meet the second preset requirement, and / or when the data of the loop function table does not meet the second preset requirement, the third original data table is searched and replaced with corresponding data according to the data that does not meet the second preset requirement and the second preset requirement to obtain a fourth original data table, including:

[0032] When the start of the start-end table does not meet the second preset requirement, the third original data table is searched and replaced with corresponding start according to the start that does not meet the second preset requirement and the second preset requirement; when the end of the start-end table does not meet the second preset requirement, the third original data table is searched and replaced with corresponding end according to the end that does not meet the second preset requirement and the second preset requirement; when the loop function of the loop function table does not meet the second preset requirement, the third original data table is searched and replaced with corresponding loop function according to the loop function that does not meet the second preset requirement and the second preset requirement, to obtain the fourth original data table.

[0033] Optionally, the first measure table is generated according to the start-end table and the fourth original data table in a first preset format, including:

[0034] Respective sealing terminals of each start and each end of the start-end table are set;

[0035] The first measure table is generated according to each start and the corresponding sealing terminal of each start, each end and the corresponding sealing terminal of each end of the start-end table and the fourth original data table in the first preset format.

[0036] To achieve the above object, the present application provides a computer readable storage medium in the second aspect, which stores a computer program, the computer program is executed by a processor, so that the processor executes the steps of the method as described in the first aspect.

[0037] To achieve the above object, the present application provides a computer device in the third aspect, which includes a memory and a processor, the memory stores a computer program, the computer program is executed by the processor, so that the processor executes the steps of the method as described in the first aspect.

[0038] The present invention provides the following advantages: Raw data is acquired, and each piece of data from the raw data is imported into a first raw data table to obtain a second raw data table; when the data in the second raw data table does not conform to preset rules, the cells corresponding to the data that do not conform to the preset rules are marked, and the position information of the marked cells is summarized into preset cells; the data corresponding to the second raw data table is modified according to the position information in the preset cells and the first preset requirements to obtain a third raw data table; the data in the third raw data table is deduplicated and summarized and sorted to obtain a start-end point table and a loop function table; when the data in the start-end point table does not conform to the second preset requirements, and / or when the data in the loop function table does not conform to the second preset requirements, and / or when the data in the loop function table does not conform to the second preset requirements, the second raw data table is modified according to the first preset requirements. When the data does not meet the second preset requirements, the third original data table is searched and replaced with corresponding data based on the data that does not meet the second preset requirements and the second preset requirements to obtain a fourth original data table, and the start-end point table and / or loop function table are updated; a first measure table is generated according to the first preset format based on the start-end point table and the fourth original data table, and the first measure table and the preset measure table are summarized and the serial numbers are updated to obtain the pre-operation measure table; a second measure table is generated according to the second preset format based on the loop function table and the fourth original data table, and the second measure table is summarized and the serial numbers are updated to obtain the operation measure table; a measure table template is determined, and a secondary measure sheet is generated based on the measure table template, the pre-operation measure table, and the operation measure table. The above method uses software to automatically acquire data, write, format, number, and review data, greatly reducing the workload of manual tasks, improving work efficiency, and saving labor costs. Attached Figure Description

[0039] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0040] in:

[0041] Figure 1 A flowchart illustrating a method for generating a secondary measure order in an embodiment of this application;

[0042] Figure 2 This is a schematic diagram of the first original data table in an embodiment of this application;

[0043] Figure 3 This is a schematic diagram of the second original data table in an embodiment of this application;

[0044] Figure 4 This is a schematic diagram of the second original data table after the cells are marked in the embodiments of this application;

[0045] Figure 5 Fig. 3 is a schematic diagram of a third original data table in an embodiment of the present application;

[0046] Figure 6 Fig. 4 is a schematic diagram of a start-end table in an embodiment of the present application;

[0047] Figure 7 Fig. 5 is a schematic diagram of a loop function table in an embodiment of the present application;

[0048] Figure 8 Fig. 6 is a schematic diagram of a fourth original data table in an embodiment of the present application;

[0049] Figure 9 Fig. 7 is an updated start-end table in an embodiment of the present application;

[0050] Figure 10 Fig. 8 is an updated loop function table in an embodiment of the present application;

[0051] Figure 11 Fig. 9 is a schematic diagram of a first measure table in an embodiment of the present application;

[0052] Figure 12 Fig. 10 is a schematic diagram of a preset measure table in an embodiment of the present application;

[0053] Figure 13 Fig. 11 is a schematic diagram of a pre-job measure table in an embodiment of the present application;

[0054] Figure 14 Fig. 12 is a schematic diagram of a second measure table in an embodiment of the present application;

[0055] Figure 15 Fig. 13 is a schematic diagram of a job measure table in an embodiment of the present application;

[0056] Figure 16 Fig. 14 is a schematic diagram of a secondary measure sheet generated in an example of the present application;

[0057] Figure 17 Fig. 15 is a schematic diagram of a preset window template in an embodiment of the present application;

[0058] Figure 18 Fig. 16 is a schematic diagram of an original data table 1 in an embodiment of the present application;

[0059] Figure 19 Fig. 17 is a schematic diagram of an original data table 2 in an embodiment of the present application;

[0060] Figure 20 Fig. 18 is a schematic diagram of an internal structure of a computer device in some embodiments. DETAILED DESCRIPTION

[0061] With reference to the drawings of the embodiments of the present application, the technical solutions in the embodiments of the present application will be clearly and completely described. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all the embodiments of the present application. Based on the embodiments of the present application, all the other embodiments obtained by a person of ordinary skill in the art without creative effort belong to the scope of protection of the present application.

[0062] Please refer to Figure 1 , a flowchart of a method for generating a secondary measure sheet in an embodiment of the present application. The method comprises:

[0063] 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.

[0064] The original data includes some data required in the process of generating the secondary measure sheet, for example, the original data includes cable number, starting point, ending point, starting point loop number, ending point loop number, starting point terminal number, ending point terminal number, loop function and measure type, etc. The first original data table is a data table that can store cable number, starting point, ending point, starting point loop number, ending point loop number, starting point terminal number, ending point terminal number, loop function and measure type, etc. It can be understood that the first original data table is equivalent to a template table. For example, please refer to Figure 2 , a schematic diagram of the first original data table in an embodiment of the present application. The first original data table has cells that can store cable number, starting point, ending point, starting point loop number, ending point loop number, starting point terminal number, ending point terminal number, loop function and measure type, etc.

[0065] In some embodiments, after obtaining the original data, each piece of cable number, starting point, ending point, starting point loop number, ending point loop number, starting point terminal number, ending point terminal number, loop function and measure type, etc. of the original data is imported into the corresponding cells of the first original data table to obtain the second original data table (i.e. the first original data table storing the original data). For example, please refer to Figure 3 , a schematic diagram of the second original data table in an embodiment of the present application.

[0066] Step 120: when the data of the second original data table does not comply with the preset rule, marking the cells corresponding to the data not complying with the preset rule, and summarizing the position information of the marked cells to a preset cell.

[0067] The preset rule is a rule preset by an operator according to actual needs. When the data of the second original data table does not comply with the preset rule, it means that the data is wrong. Therefore, the cells corresponding to the data of the second original data table not complying with the preset rule need to be marked. For example, please refer to Figure 4As a schematic diagram of the second original data table after marking the cells in the embodiment of the present application, after marking the cells corresponding to the data not meeting the preset rule, the position information of the marked cells is summarized into the preset cell, so as to modify the error data according to the position information in the preset cell.

[0068] Step 130: 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.

[0069] The first preset requirement is set by the operator according to the actual demand, and it can be understood that the purpose of setting the first preset requirement is to provide a modification basis for modifying the error data. For example, in some embodiments, the second original data table (i.e., the second original data table shown in FIG. 6) can be modified according to the position information in the preset cell and the first preset requirement to obtain a third original data table (i.e., the third original data table shown in FIG. 7). Figure 4 The third original data table shown in FIG. 7 is a schematic diagram of the third original data table in the embodiment of the present application. Figure 5 The third original data table shown in FIG. 7 is a schematic diagram of the third original data table in the embodiment of the present application.

[0070] In another embodiment, the operator does not set the first preset requirement, and thus the operator can manually modify the second original data table (i.e., the second original data table shown in FIG. 6) according to the position information in the preset cell to obtain a third original data table (i.e., the third original data table shown in FIG. 7). Figure 4 The third original data table shown in FIG. 7 is a schematic diagram of the third original data table in the embodiment of the present application. Figure 5 The third original data table shown in FIG. 7 is a schematic diagram of the third original data table in the embodiment of the present application.

[0071] Step 140: removing the duplicate data and sorting the data of the third original data table to obtain a start-end table and a loop function table.

[0072] It should be noted that since the start, end, and loop function in the third original data table have multiple data, and the data of the same start, end, and loop function are more, it is not conducive to determine whether it meets the requirement, and thus the data amount needs to be reduced. The data of the third original data table is removed and sorted to obtain a start-end table and a loop function table. For example, refer to Figure 6 As a schematic diagram of the start-end table in the embodiment of the present application, and refer to Figure 7 As a schematic diagram of the loop function table in the embodiment of the present application.

[0073] Step 150: when the data of the start-end table does not meet the second preset requirement, and / or when the data of the loop function table does not meet the second preset requirement, the third original data table is searched and replaced according to the data not meeting the second preset requirement and the second preset requirement to obtain a fourth original data table, and the start-end table and / or the loop function table is updated.

[0074] The second preset requirement is set by the operator based on actual needs. It is understood that the purpose of setting the second preset requirement is to filter out non-existent or erroneous data and provide a basis for modifying such data. For example, in some embodiments, data that does not meet the second preset requirement can be used to modify the data based on the second preset requirement. Figure 5 The fourth original data table is obtained by searching and replacing the corresponding data in the third original data table shown. Please refer to [link / reference]. Figure 8 This is a schematic diagram of the fourth original data table in the embodiments of this application.

[0075] It should be noted that for updating the start / end point table and / or the loop function table, the corresponding erroneous data can be updated after performing a lookup and replace operation on the fourth original data table. For example, [the following is an example:] Figure 6 Please refer to the updated start and end point table shown. Figure 9 , is the updated start and end point table in this application embodiment, Figure 7 Please refer to the updated loop function table shown. Figure 10 This is the updated loop function table in the embodiments of this application.

[0076] In some other embodiments, the operator does not set a second preset requirement; therefore, the operator can manually adjust the start and end point table. Figure 5 The third original data table shown is used to find and replace the corresponding data to obtain... Figure 8 The fourth original data table is shown.

[0077] Step 160: Generate the first measures table according to the first preset format based on the start and end point table and the fourth original data table, and summarize and update the serial numbers of the first measures table and the preset measures table to obtain the pre-operation measures table.

[0078] In some embodiments, when the origin and destination tables need to be updated, the origin and destination tables here are: Figure 9 The start and end point table is shown; when the start and end point table does not need to be updated, the start and end point table here is... Figure 6 The starting and ending points are shown in the table.

[0079] It should be noted that the first preset format is pre-set by the operator according to actual needs. It is understandable that the format of the pre-operation safety measures on the secondary measures sheet used by operators in different regions varies. Therefore, operators can set the first preset format to meet the format requirements of operators in different regions. For example, in some embodiments, based on the start-end point table (i.e.... Figure 9 (The starting and ending point table shown) and Figure 8The fourth raw data table shown is used to generate a first measure table in a first preset format. Please refer to Figure 11 , which is a schematic diagram of the first measure table in the embodiments of the present application. The preset measure table is some pre-job safety measures related to the secondary measure sheet. The number of pre-job safety measures can be increased or decreased according to the needs of the operator. It can be understood that if there are no pre-job safety measures related to the secondary measure sheet, the preset measure table can be an empty table. Please refer to Figure 12 , which is a schematic diagram of the preset measure table in the embodiments of the present application.

[0080] In some embodiments, after obtaining the first measure table, the first measure table and the preset measure table are combined and summarized together, and the serial number is updated to obtain a pre-job measure table. Please refer to Figure 13 , which is a schematic diagram of the pre-job measure table in the embodiments of the present application.

[0081] Step 170: generating a second measure table in a second preset format according to the loop function table and the fourth raw data table, and summarizing and updating the serial number of the second measure table to obtain a job measure table.

[0082] In some embodiments, when the loop function table needs to be updated, the loop function table here is Figure 10 , which is a loop function table shown. When the loop function table does not need to be updated, the loop function table here is Figure 7 , which is a loop function table shown.

[0083] It should be noted that the second preset format is preset by the operator according to actual needs. It can be understood that, since the format of the pre-job safety measures of the secondary measure sheet used by the operators in different regions has certain differences, the operator can set the second preset format to meet the format needs of the operators in different regions. For example, in some embodiments, a second measure table is generated in a second preset format according to a loop function table (i.e. Figure 10 , which is a loop function table shown) and Figure 8 , which is a fourth raw data table shown. Please refer to Figure 14 , which is a schematic diagram of the second measure table in the embodiments of the present application.

[0084] In some embodiments, after obtaining the second measure table, the second measure table is summarized and the serial number is updated to obtain a job measure table. Please refer to Figure 15 , which is a schematic diagram of the job measure table in the embodiments of the present application.

[0085] Step 180: determining a measure table template, and generating a secondary measure sheet according to the measure table template, the pre-job measure table and the job measure table.

[0086] The measure table template is a standard format template of the secondary measure sheet, and can be set by an operator according to actual requirements. The operator can modify information such as a power station name, a number style, and a personnel list to meet requirements of different power stations.

[0087] In some embodiments, after obtaining the measure table template, data of the pre-job measure table and the job measure table can be imported into the measure table template, so as to generate the secondary measure sheet. Please refer to Figure 16 FIG. 1 is a schematic diagram of a secondary measure sheet generated in an example of the present application.

[0088] In the embodiments of the present application, data is automatically acquired, written, typeset, numbered, and audited by software, which greatly reduces the amount of manual tasks, improves work efficiency, and saves labor costs.

[0089] In a feasible implementation manner, in step 110, the original data is acquired, and each piece of data of the original data is imported into a first original data table to obtain a second original data table, including: emptying data of a fourth original data table of last time to obtain the first original data table; acquiring the original data, and sequentially inputting each piece of data of the original data into a preset window template to import each piece of data of the original data into a corresponding cell of the first original data table to obtain the second original data table.

[0090] The preset window template is set by an operator according to a data type of the original data. If the original data 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, and measure type, the preset window is a window with data cells of the cable number, the start point, the end point, the start point loop number, the end point loop number, the start point terminal number, the end point terminal number, the loop function, and the measure type. For an example, please refer to FIG. 2. Figure 17 FIG. 2 is a schematic diagram of a preset window template in an embodiment of the present application.

[0091] It should be noted that the first original data is processed to obtain the fourth original data table each time the program is executed. Therefore, the data in the fourth original data table of last time needs to be emptied to obtain the first original data table again when the program is executed next time.

[0092] In some embodiments, after acquiring the original data, each piece of data of the original data (including the cable number, the start point, the end point, the start point loop number, the end point loop number, the start point terminal number, the end point terminal number, the loop function, and the measure type) is sequentially input into Figure 17 a data cell corresponding to the preset window template shown in FIG. 2, to import each piece of data of the original data into Figure 2 a cell corresponding to the first original data table shown in FIG. 1 to obtain Figure 3The second raw data table is shown.

[0093] In the embodiment of the present application, by acquiring the raw data, each piece of data of the raw data is sequentially input into the preset window template to import each piece of data of the raw data into the corresponding cell of the first raw data table to obtain the second raw data table, so as to realize automatic data acquisition of the software and avoid missing data during data acquisition, thereby saving manpower and material resources.

[0094] In another possible implementation, in step 110, the raw data is acquired, and each piece of data of the raw data is imported into the first raw data table to obtain the second raw data table, including: emptying the data of the fourth raw data table of the last time to obtain the first raw data table; acquiring the raw data in all raw data tables under the preset directory, merging and summarizing the raw data, and importing each piece of data of the raw data into the first raw data table to obtain the second raw data table.

[0095] The preset directory is a storage location for storing raw data tables, which is set by an operator in advance; the raw data table is a data table having the same format as the first raw data table, the second raw data table, the third raw data table, and the fourth raw data table, i.e., the raw data table also has cells of cable number, starting point, ending point, starting point loop number, ending point loop number, starting point terminal number, ending point terminal number, loop function, and measure type. The raw data table can be manually edited during data collection by an operator or generated by software. For example, the raw data table 1 and the raw data table 2 under the preset directory are shown in Figure 18 , which is a schematic diagram of the raw data table 1 in the embodiment of the present application, and Figure 19 , which is a schematic diagram of the raw data table 2 in the embodiment of the present application.

[0096] It should be noted that the first raw data is processed to obtain the fourth raw data table each time the program is executed, and therefore, the data in the fourth raw data table of the last time needs to be emptied to obtain the first raw data table again when the program is executed next time.

[0097] In some embodiments, after acquiring the raw data in all raw data tables (i.e., the raw data table 1 shown in Figure 18 and the raw data table 2 shown in Figure 19 ) under the preset directory, the raw data is merged and summarized, and each piece of data (including cable number, starting point, ending point, starting point loop number, ending point loop number, starting point terminal number, ending point terminal number, loop function, and measure type) of the raw data is imported into the first raw data table shown in Figure 2 to obtain the second raw data table shown in Figure 3The second original data table is shown. 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.

[0098] In the embodiment of the present application, by acquiring the original data in all original data tables under the preset directory, and after merging and summarizing the original data, 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 software can automatically acquire data, and the problems such as missing data and the need to consume manpower and resources when acquiring data can be avoided.

[0099] In a feasible implementation manner, the original data in the embodiment of the present application includes cable number, starting point, ending point, starting point loop number, ending point loop number, starting point terminal number, ending point terminal number, loop function, and measure type.

[0100] In the embodiment of the present application, the data types of the original data are preferably set, so that the operating personnel can understand and determine some data required in the process of generating the secondary measure sheet.

[0101] In a feasible implementation manner, in step 120, when the data of the second original data table does not conform to the preset rule, the cells corresponding to the data not conforming to the preset rule are marked, including: when the kth starting point of the same cable number in the second original data table is not equal to the k+1th starting point, the cell corresponding to the k+1th starting point is marked; wherein k is a positive integer greater than 0, and k is sequentially taken until k+1 is equal to the number of starting points of the same cable number; when the pth ending point of the same cable number in the second original data table is not equal to the p+1th ending point, the cell corresponding to the p+1th ending point is marked; wherein p is a positive integer greater than 0, and p is sequentially taken until p+1 is equal to the number of ending points of the same cable number; when the qth loop function of the same cable number in the second original data table is not equal to the q+1th loop function, the cell corresponding to the q+1th loop function is marked; wherein q is a positive integer greater than 0, and q is sequentially taken 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 ending point loop number, the cells corresponding to the starting point loop number and the ending point loop number of the same row are marked; when the measure type in the second original data table is not equal to the preset type, the cell corresponding to the measure type not equal to the preset type is marked; and the blank cells in the second original data table are marked.

[0102] The preset type is set by the operating personnel according to the actual need of the measure type, and specifically, it can be demolition, access, disconnection, and the like.

[0103] In some embodiments, the operator sets the preset rule to the following conditions according to actual needs: when the kth starting point of the same cable number in the second raw data table is not equal to the k+1th starting point, mark the cell corresponding to the k+1th starting point, k is a positive integer greater than 0 in turn, until k+1 is equal to the number of starting points of the same cable number; when the pth end point of the same cable number in the second raw data table is not equal to the p+1th end point, mark the cell corresponding to the p+1th end point, p is a positive integer greater than 0 in turn, until p+1 is equal to the number of end points of the same cable number; when the qth loop function of the same cable number in the second raw data table is not equal to the q+1th loop function, mark the cell corresponding to the q+1th loop function, q is a positive integer greater than 0 in turn, until q+1 is equal to the number of loop functions of the same cable number; when the starting loop number of the same row in the second raw data table is not equal to the end loop number, mark the cells corresponding to the starting loop number and the end loop number of the same row; when the measure type in the second raw data table is not equal to the preset type, mark the cell corresponding to the measure type which is not equal to the preset type, the preset type is set by the operator according to actual needs; mark the blank cells in the second raw data table.

[0104] For examples, please continue to read Figure 3 The second raw data table and Figure 4The second original data table after the marked cell is shown, the same cable number is cable number 2, the number of starting points of the cable number is 4, when the first starting point of the cable number 2 of the second original data table is equal to the second starting point, k is 1, when the second starting point of the cable number 2 of the second original data table is not equal to the third starting point, the cell corresponding to the third starting point is marked, k is 2, when the third starting point of the cable number 2 of the second original data table is not equal to the fourth starting point, the cell corresponding to the fourth starting point is marked, until 4 is equal to the number 4 of the starting points of the cable number 2; the same cable number is cable number 1, the number of ending points of the cable number 1 is 3, when the first ending point of the cable number 1 of the second original data table is not equal to the second ending point, p is 1, when the second ending point of the cable number 1 of the second original data table is not equal to the third ending point, the cell corresponding to the third ending point is marked, p is 2, until 3 is equal to the number 3 of the ending points of the cable number 1; the same cable number is cable number 1, the number of loop functions of the cable number 1 is 3, when the first loop function of the cable number 1 of the second original data table is not equal to the second loop function, q is 1, when the second loop function of the cable number 1 of the second original data table is not equal to the third loop function, the cell corresponding to the third loop function is marked, q is 1, 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, the cell corresponding to the loop function 1 is marked, until 3 is equal to the number 3 of the loop functions of the cable number 1; the same row is the third row of the cable number 1, when the starting loop number of the third row of the cable number 1 in the second original data table is not equal to the ending loop number, the cells corresponding to the starting loop number and the ending loop number of the third row of the cable number 1 are marked; the preset type is the measure type 1, when the measure type (the measure type 3) in the second original data table is not equal to the measure type 1, the cells corresponding to the measure types not equal to the measure type 1 are marked; the blank cells in the second original data table are marked.

[0105] In the embodiment of the present application, the starting point, the ending point, the loop function, the starting loop number and the ending loop number, the blank cell and the like are automatically checked for errors, which facilitates high efficiency of auditing, greatly reduces the task amount of manual work and saves the labor cost.

[0106] In one feasible implementation, in step 140, the data in the third original data table is deduplicated and sorted to obtain a start-end point table and a loop function table. This includes: deduplicating the third original data table by start point to obtain multiple unique start points; deduplicating the third original data table by end point to obtain multiple unique end points; determining the first row number of each unique start point and unique end point in the three original data tables; and sorting the multiple unique start points, multiple unique end points, and the first row number to obtain the start-end point table; deduplicating the third original data table by loop function to obtain multiple unique loop functions; determining the second row number of each unique loop function in the third original data table; and sorting the multiple unique loop functions and the second row number to obtain the loop function table.

[0107] The first initial row number is the row number of the first occurrence of the start and end points in the third original data table. That is, after deduplication of multiple start and end points, the unique start and end points are obtained, and the row number of the first occurrence of the unique start and end points in the third original data table before deduplication. The second initial row number is the row number of the first occurrence of the loop function in the third original data table. That is, after deduplication of multiple loop functions, the unique loop function is obtained, and the row number of the first occurrence of the unique loop function in the third original data table before deduplication.

[0108] In some embodiments, in the case of Figure 5 The starting point, ending point, and loop functions of the third original data table shown are deduplicated and summarized and sorted to obtain the results. Figure 6 The starting and ending point table shown and Figure 7 This is the circuit function table.

[0109] In this embodiment of the application, by deduplicating the start point, end point, and loop functions, and setting a first initial row number and a second initial row number, it is easier to further determine whether the start point, end point, and loop functions do not meet the requirements, and to facilitate further searching and replacing data that does not meet the requirements.

[0110] In a feasible implementation, in step 150, when the data of the start-end point table does not meet the second preset requirement, and / or when the data of the loop function table does not meet the second preset requirement, the corresponding data of the third original data table is replaced by searching and replacing according to the data that does not meet the second preset requirement and the second preset requirement to obtain the fourth original data table, including: when the start point of the start-end point table does not meet the second preset requirement, the corresponding start point is replaced by searching and replacing according to the start point that does not meet the second preset requirement and the second preset requirement; when the end point of the start-end point table does not meet the second preset requirement, the corresponding end point is replaced by searching and replacing according to the end point that does not meet the second preset requirement and the second preset requirement; when the loop function of the loop function table does not meet the second preset requirement, the corresponding loop function is replaced by searching and replacing according to the loop function that does not meet the second preset requirement and the second preset requirement, to obtain the fourth original data table.

[0111] For example, please continue to refer to Figure 5 the third original data table shown, Figure 6 the start-end point table shown, Figure 7 the loop function table shown, and Figure 8 the fourth original data table, 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-end point table does not meet the second preset requirement, the corresponding start point 3 is replaced by searching and replacing according to the start point 3 that does not meet the second preset requirement and the second preset requirement (start point 2), that is, the start point 3 is replaced by searching and replacing to the start point 2; when the end point 5 of the start-end point table does not meet the second preset requirement, the corresponding end point 5 is replaced by searching and replacing according to the end point 5 that does not meet the second preset requirement and the second preset requirement (end point 4), that is, the end point 5 is replaced by searching and replacing to the end point 4; when the loop function 3 of the loop function table does not meet the second preset requirement, the corresponding loop function 3 is replaced by searching and replacing according to the loop function 3 that does not meet the second preset requirement and the second preset requirement (loop function 2), that is, the loop function 3 is replaced by searching and replacing to the loop function 2, to obtain the fourth original data table.

[0112] In the embodiment of the application, the start point and the end point in the start-end point table that do not meet the second preset requirement are replaced by searching and replacing the corresponding start point and end point, and the loop function in the loop function table that does not meet the second preset requirement is replaced by searching and replacing the corresponding loop function, to obtain the fourth original data table with accurate start point, end point, loop function and other data, thereby obtaining an accurate secondary measure sheet.

[0113] In a feasible implementation, in step 160, the first measure table is generated according to the starting point and ending point table and the fourth original data table in the first preset format, including: setting the sealed terminal of each starting point and each ending point of the starting point and ending point table respectively; and generating the first measure table according to each starting point and the sealed terminal corresponding to each starting point, each ending point and the sealed terminal corresponding to each ending point of the starting point and ending point table, and the fourth original data table in the first preset format.

[0114] In some embodiments, please continue to refer to Figure 9 The starting point and ending point table shown, Figure 8 The fourth original data table shown, Figure 11 The first measure table shown, that is, the sealed terminal of each starting point and each ending point of the starting point and ending point table can be set respectively, and then the first measure table is generated according to each starting point and the sealed terminal corresponding to each starting point, each ending point and the sealed terminal corresponding to each ending point of the starting point and ending point table, and the fourth original data table in the first preset format. It can be understood that, by setting the sealed terminal of each starting point and each ending point in the starting point and ending point table, when the sealed terminal of the starting point and the ending point has data, or the data is "no", the starting point and the ending point with no data of the sealed terminal are not generated, and the starting point and the ending point with no data of the sealed terminal are generated in the first measure table in the first preset format. That is, when the sealed terminal of starting point 1 is set to "no" in the starting point and ending point table, starting point 1 is not generated, and starting point 3, ending point 2 and ending point 5 are generated in the first measure table as "the terminal except the sealed terminal".

[0115] In the embodiments of the present application, by setting the sealed terminal of each starting point and each ending point of the starting point and ending point table respectively; and generating the first measure table according to each starting point and the sealed terminal corresponding to each starting point, each ending point and the sealed terminal corresponding to each ending point of the starting point and ending point table, and the fourth original data table in the first preset format, the corresponding pre-operation safety measures can be generated according to the actual demand of the operator, so as to realize the automatic generation of the secondary measure sheet by the software.

[0116] In the embodiments of the present application, a computer readable storage medium is provided, which stores a computer program. When the computer program is executed by a processor, the processor executes any one of the secondary measure sheet generation methods in the above method embodiments.

[0117] In some embodiments, a computer device is provided, which includes a memory and a processor. The memory stores a computer program. When the computer program is executed by the processor, the processor executes any one of the secondary measure sheet generation methods in the above method embodiments.

[0118] Figure 20 The internal structure diagram of the computer device in some embodiments is shown. The computer device can be a terminal, a server, or a gateway. As shown inFigure 20 As shown in the figure, the computer device includes a processor, a memory and a network interface connected through a system bus.

[0119] 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 can also store a computer program, which, when executed by the processor, can enable the processor to implement each step in the above method embodiments. The internal memory can also store a computer program, which, when executed by the processor, can enable the processor to execute each step in the above method embodiments. Those skilled in the art can understand that, Figure 20 The structure shown in the figure is only a block diagram of part of the structure related to the scheme of the present application, and does not constitute a limitation on the computer device to which the scheme of the present application is applied. The specific computer device can include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0120] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiments can be completed by a computer program instructing related hardware. The program can be stored in a non-volatile computer readable storage medium, and when executed, can include the processes of the above-mentioned embodiments.

[0121] Any reference to memory, storage, databases, or other media in the embodiments provided by the present application can include non-volatile and / or volatile storage. Non-volatile storage can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile storage can include random access memory (RAM) or external cache memory. As an illustration but not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDR SDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

[0122] Each technical feature of the above embodiments can be combined arbitrarily. In order to make the description concise, not all possible combinations of the technical features in the above embodiments are described, but as long as the combinations of the technical features do not exist, they should be considered as the scope of the present application.

[0123] The above-described embodiments are merely illustrative of several embodiments of the present application, which are described in more detail and in a specific manner, but should not be construed as limiting the scope of the patent of the present application. It should be noted that, for those of ordinary skill in the art, several modifications and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application should be subject to the appended claims.

Claims

1. A method for generating a secondary measure order, characterized in that, The method includes: Obtain the raw data and import each piece of data from the raw data into the first raw data table to obtain the second raw data table; When the data in the second original data table does not conform to the preset rules, the cells corresponding to the data that does not conform to the preset rules are marked, and the position information of the marked cells is summarized into the preset cells; The third original data table is obtained by modifying the data corresponding to the second original data table according to the position information in the preset cell and the first preset requirements; The data in the third original data table are deduplicated and sorted to obtain the start-end point table and the loop function table. When the data in the start-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 third original data table is searched and replaced with corresponding data based on the data that does not meet the second preset requirement and the second preset requirement to obtain the fourth original data table, and the start-end point table and / or the loop function table are updated. A first measures table is generated according to the starting point and ending point table and the fourth original data table in a first preset format. The first measures table and the preset measures table are then summarized and their serial numbers are updated to obtain the pre-operation measures table. A second measure table is generated according to the second preset format based on the loop function table and the fourth original data table. The second measure table is then summarized and its serial number is updated to obtain the work measure table. Determine the action sheet template, and generate a secondary action sheet based on the action sheet template, the pre-operation action sheet, and the operation action sheet.

2. The method according to claim 1, characterized in that, The process of obtaining raw data and importing each piece of raw data into a first raw data table to obtain a second raw data table includes: Clear the data from the previous fourth original data table to obtain the first original data table; The original data is obtained, and each piece of data in the original data is sequentially entered into a preset window template to import each piece of data in the original data into the corresponding cell of the first original data table to obtain the second original data table.

3. The method according to claim 1, characterized in that, The process of obtaining raw data and importing each piece of raw data into a first raw data table to obtain a second raw data table includes: Clear the data from the previous fourth original data table to obtain the first original data table; Obtain the original data from all the original data tables in the preset directory, merge and summarize the original data, and then import each piece of the original data into the first original data table to obtain the second original data table.

4. The method according to claim 1, characterized in that, The raw data 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, and measure type.

5. The method according to claim 4, characterized in that, When the data in the second original data table does not conform to the preset rules, the cells corresponding to the data that do not conform to the preset rules are marked, including: When the k-th starting point of the same cable number in the second original data table is not equal to the (k+1)-th starting point, the cell corresponding to the (k+1)-th starting point is marked; where k takes positive integers greater than 0 in turn, 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 in the second original data table is not equal to the p+1-th endpoint, the cell corresponding to the p+1-th endpoint is marked; where p takes positive integers greater than 0 in turn, until p+1 is equal to the number of endpoints of the same cable number; When the function of the qth loop of the same cable number in the second original data table is not equal to the function of the (q+1)th loop, the cell corresponding to the (q+1)th loop function is marked; where q takes positive integers greater than 0 in turn, until q+1 is equal to the number of loop functions of the same cable number; When the starting loop number in the same row of the second original data table is not equal to the ending loop number, the cells corresponding to the starting loop number and the ending loop number in the same row are marked. When the measure type in the second original data table is not equal to the preset type, the cell corresponding to the measure type that is not equal to the preset type will be marked; Mark the blank cells in the second original data table.

6. The method according to claim 4, characterized in that, The process of deduplicating and summarizing the data in the third original data table to obtain the start-end point table and the loop function table includes: The third original data table is deduplicated by starting point to obtain multiple unique starting points, and the third original data table is deduplicated by ending point to obtain multiple unique ending points. The first row number of the multiple unique starting points and multiple unique ending points in the three original data tables is determined respectively. The multiple unique starting points, multiple unique ending points and the first row number are summarized and sorted to obtain the starting point and ending point table. The third original data table is deduplicated according to loop function to obtain multiple unique loop functions. The second first row number of each unique loop function in the third original data table is determined. The multiple unique loop functions and the second first row number are summarized and sorted to obtain the loop function table.

7. The method according to claim 4, characterized in that, When the data in the start-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 third original data table is searched and replaced with corresponding data based on the data that does not meet the second preset requirement and the second preset requirement to obtain a fourth original data table, including: When the starting point of the starting point and ending point table does not meet the second preset requirement, the third original data table is searched and replaced with the corresponding starting point according to the starting point that does not meet the second preset requirement and the second preset requirement. When the ending point of the starting point and ending point table does not meet the second preset requirement, the third original data table is searched and replaced with the corresponding ending point according to the ending point that does not meet the second preset requirement and the second preset requirement. When the loop function of the loop function table does not meet the second preset requirement, the third original data table is searched and replaced with the corresponding loop function according to the loop function that does not meet the second preset requirement and the second preset requirement, so as to obtain the fourth original data table.

8. The method according to claim 4, characterized in that, The step of generating the first measures table according to the start-end point table and the fourth original data table in a first preset format includes: Seal terminals are set for each start point and each end point of the start point and end point table, respectively; The first measure table is generated according to the first preset format based on each starting point and its corresponding sealing terminal in the starting point and ending point table, each ending point and its corresponding sealing terminal, and the fourth original data table.

9. A computer-readable storage medium, characterized in that, The device stores a computer program that, when executed by a processor, causes the processor to perform the steps of the method as described in any one of claims 1 to 8.

10. A computer device, characterized in that, It includes a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform the steps of the method as described in any one of claims 1 to 8.

Images