CN116976293A - Automatic acquisition system and method for electrical test report data - Google Patents

Automatic acquisition system and method for electrical test report data Download PDF

Info

Publication number
CN116976293A
CN116976293A CN202310996317.4A CN202310996317A CN116976293A CN 116976293 A CN116976293 A CN 116976293A CN 202310996317 A CN202310996317 A CN 202310996317A CN 116976293 A CN116976293 A CN 116976293A
Authority
CN
China
Prior art keywords
data
cell
input
test report
electrical test
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
Application number
CN202310996317.4A
Other languages
Chinese (zh)
Inventor
刘华锋
韩光军
邓卫
马永平
曾林龙
任东风
田实雨
李金鑫
雷杨
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xiangyang Power Supply Co of State Grid Hubei Electric Power Co Ltd
Original Assignee
Xiangyang Power Supply Co of State Grid Hubei Electric Power Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Xiangyang Power Supply Co of State Grid Hubei Electric Power Co Ltd filed Critical Xiangyang Power Supply Co of State Grid Hubei Electric Power Co Ltd
Priority to CN202310996317.4A priority Critical patent/CN116976293A/en
Publication of CN116976293A publication Critical patent/CN116976293A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/174—Form filling; Merging
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/12—Use of codes for handling textual entities
    • G06F40/151—Transformation
    • G06F40/154—Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/186—Templates

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Tests Of Electronic Circuits (AREA)

Abstract

The invention relates to an automatic collection system and method for electrical test report data, wherein the system comprises: the data acquisition module is used for automatically identifying the positions of target measured values in the electrical test report data with the same data protocol and format and converting the target measured values into intermediate structural data based on JSON; the data input module is used for constructing a data table based on the content of the electrical test report data; the data table comprises each name cell and corresponding cells to be input; the name cell is a cell indicating the type of data, and the cell to be input is a cell of the numerical value of the type of data to be input; each cell to be recorded is respectively configured with a corresponding recording rule, and when the data acquired by the data acquisition module accords with the recording rule, the corresponding cell to be recorded is automatically filled; the problems of time consumption, labor consumption, error and omission of manual measurement input are solved, and paperless, automatic and intelligent test report input is realized.

Description

Automatic acquisition system and method for electrical test report data
Technical Field
The invention relates to the field of electrical tests, in particular to an automatic collection system and method for electrical test report data.
Background
In the electric test process, after a worker connects the measuring equipment with the tested equipment on site and makes a certain setting, the measured value of the time is read from a display screen of the measuring equipment, and the measured value is manually recorded on a paper test report.
For different measurement items (such as direct current resistance, dielectric loss and the like), different measurement instruments are required to obtain corresponding measurement results, and meanwhile, some measurement items are required to convert the measurement results according to a formula and fill in corresponding forms.
The existing operation flow needs to manually read data from the measurement equipment, and the required measurement result is calculated according to a calculation formula or logic of each measurement item and then manually filled into a correct cell.
Disclosure of Invention
Aiming at the technical problems existing in the prior art, the invention provides an automatic acquisition system and method for electric test report data, solves the problems of time and labor consumption, easy error and easy omission in manual measurement and input, and thoroughly solves the paperless, automatic and intelligent test report input.
According to a first aspect of the present invention, there is provided an automatic electrical test report data acquisition system comprising: the data acquisition module and the data input module;
the data acquisition module is used for automatically identifying the positions of target measured values in the electrical test report data with the same data protocol and format and converting the target measured values into intermediate structural data based on JSON;
the data entry module is used for constructing a data table based on the content of the electrical test report data; the data table comprises name cells and corresponding cells to be input; the name cell is a cell indicating the type of data, and the cell to be input is a cell of the numerical value of the type of data to be input; each cell to be recorded is respectively configured with a corresponding recording rule, and when the data acquired by the data acquisition module accords with the recording rules, the corresponding cell to be recorded is automatically filled.
On the basis of the technical scheme, the invention can also make the following improvements.
Optionally, an entry rule for each cell configuration to be entered may be created/edited;
the content that the entry rules can create/edit includes: the system comprises a mode, a name, a purpose, a PMS template, a target table, a target row and a target column and an input rule configuration, wherein the PMS template corresponds to a target test item in the electrical test report data, and the target table, the target row and the target column correspond to positions of the target table in the electrical test report data.
Optionally, when the electrical test report data is complex and irregular data, the input rule supports customized input through a key tag application customization mode.
Optionally, the cell to be input is further configured with a check rule which can be created/edited;
the verification method of the verification rule comprises the following steps: and judging that the verification is passed when the data filled in the cell to be recorded is within the set interval range.
Optionally, the cell to be input is further configured with a check rule which can be created/edited;
the verification method of the verification rule comprises the following steps: and judging that the verification is passed when the gap between the data filled in the cell to be recorded and the historical data is within a set threshold range.
Optionally, the cell to be input is further configured with a check rule which can be created/edited;
the verification method of the verification rule comprises the following steps: determining a set interval range of the cells to be recorded based on the content of the context of the current report, and judging that verification is passed when the data of the cells to be recorded is filled in the set interval range;
the context content is measured data in the report or basic information of the report.
Optionally, the system further comprises: a test procedure judging module;
the test rule judging module is used for managing the test rule and carrying out historical data comparison analysis on the electrical test report data;
managing the test protocol includes: mining and carding according to actual experimental data, summarizing experimental procedures and forming quantifiable analysis indexes; the configuration rules include: a data valid value and a data correlation; analyzing whether the acquired data accords with a test rule;
the historical data comparison analysis of the electrical test report data comprises: performing comparative analysis with the historical data and performing data fluctuation analysis with reference to the historical data;
the comparison analysis with the historical data includes: comparing the historical input data of the same type of equipment with the current data difference, the data fluctuation and the data abnormal value;
performing data fluctuation analysis with reference to the historical data includes: and identifying data with larger deviation values such as abnormal high deviation value or abnormal low deviation value according to the fluctuation amplitude of the historical data.
According to a second aspect of the present invention, there is provided an automatic collection method of electrical test report data, comprising:
step 1, automatically identifying the position of a target measured value in electrical test report data with the same data protocol and format, and converting the target measured value into intermediate structural data based on JSON;
step 2, constructing a data table based on the content of the electrical test report data; the data table comprises name cells and corresponding cells to be input; the name cell is a cell indicating the type of data, and the cell to be input is a cell of the numerical value of the type of data to be input; each cell to be input is configured with a corresponding input rule, and the data acquired in the step 1 is automatically filled into the corresponding cell to be input when the acquired data accords with the input rule.
According to a third aspect of the present invention, there is provided an electronic device comprising a memory, a processor for implementing the steps of the method for automatically collecting electrical test report data when executing a computer management program stored in the memory.
According to a fourth aspect of the present invention, there is provided a computer-readable storage medium having stored thereon a computer-management-class program which, when executed by a processor, implements the steps of a method for automatically collecting electrical test report data.
According to the system, the method, the electronic equipment and the storage medium for automatically acquiring the electrical test report data, a great amount of time is consumed for reading the measured value and calculating the step in the prior art, and measurement logics of different projects are required to be memorized or consulted, so that the work needs to be completed with abundant working experience, and meanwhile, the result is accurately written into a correct cell, so that the problems of easy error and difficult discovery are solved; an online electronic report which can be recorded is designed, real-time measurement data from measurement equipment can be automatically captured, and the real-time measurement data can be automatically recorded into a correct cell according to configuration, so that errors caused by manual recording are avoided; the measurement logic or the disclosure can be configured without turning over on site or memorizing the calculation formula or the conversion formula.
Drawings
FIG. 1 is a block diagram of an automatic acquisition system for electrical test report data provided by the invention;
FIG. 2 is a schematic diagram of an embodiment of a data table of an automatic electrical test report data acquisition system provided by the present invention;
FIG. 3 is a schematic diagram of an embodiment of a data table build/edit interface of an automatic electrical test report data collection system provided by the present invention;
FIG. 4 is a flowchart of an embodiment of a method for automatically collecting electrical test report data according to an embodiment of the present invention;
fig. 5 is a schematic hardware structure of one possible electronic device according to the present invention;
fig. 6 is a schematic hardware structure of a possible computer readable storage medium according to the present invention.
Detailed Description
The principles and features of the present invention are described below with reference to the drawings, the examples are illustrated for the purpose of illustrating the invention and are not to be construed as limiting the scope of the invention.
Fig. 1 is a block diagram of an automatic acquisition system for electrical test report data, provided by the invention, as shown in fig. 1, the system includes: the data acquisition module and the data input module;
and the data acquisition module is used for automatically identifying the positions of the target measured values in the electrical test report data with the same data protocol and format and converting the target measured values into intermediate structural data based on JSON.
In specific implementation, protocols of different manufacturers can have different data formats and different data protocols, and the invention identifies protocols of various manufacturers by designing a configuration framework based on a protocol template, designs generalized language, structured data, data conversion and data analysis into pms.
The data input module is used for constructing a data table based on the content of the electrical test report data; the data table comprises each name cell and corresponding cells to be input; the name cell is a cell indicating the type of data, and the cell to be input is a cell of the numerical value of the type of data to be input; each cell to be recorded is respectively configured with a corresponding recording rule, and when the data acquired by the data acquisition module accords with the recording rule, the corresponding cell to be recorded is automatically filled.
The automatic acquisition system for the electrical test report data provided by the invention solves the problems of time and labor consumption, easy error and easy omission in manual measurement input, and thoroughly solves the paperless, automatic and intelligent test report input.
Example 1
Embodiment 1 provided by the present invention is an embodiment of an automatic electrical test report data collection system provided by the present invention, and as can be seen in fig. 1, the embodiment of the system includes: and the data acquisition module and the data input module.
And the data acquisition module is used for automatically identifying the positions of the target measured values in the electrical test report data with the same data protocol and format and converting the target measured values into intermediate structural data based on JSON.
The data input module is used for constructing a data table based on the content of the electrical test report data; the data table comprises each name cell and corresponding cells to be input; the name cell is a cell indicating the type of data, and the cell to be input is a cell of the numerical value of the type of data to be input; each cell to be recorded is respectively configured with a corresponding recording rule, and when the data acquired by the data acquisition module accords with the recording rule, the corresponding cell to be recorded is automatically filled.
In one possible embodiment, the entry rules for each cell configuration to be entered may be created/edited. Fig. 2 is a schematic diagram of an embodiment of a data table of an automatic electrical test report data collection system according to the present invention, and fig. 3 is a schematic diagram of an embodiment of a data table construction/editing interface of an automatic electrical test report data collection system according to the present invention. As can be seen from fig. 2 and fig. 3, the present invention realizes an input configuration tool based on a PMS template and a unified form, and accurately inputs input data into correct cells of a PMS system.
Content that the entry rules may create/edit includes: the method comprises the steps of configuring modes, names, purposes, PMS templates, target tables, target rows and target columns and recording rules, wherein the PMS templates correspond to target test items in the electrical test report data, and the target tables, the target rows and the target columns correspond to positions of the target tables in the electrical test report data.
In specific implementation, the numerical value to be input by the cell to be input includes: two kinds of electric test report data and environmental data are taken as an example of a data table of the on-load voltage regulating transformer in the figure, and the electric test report data comprise: a direct current resistance value, an insulation resistance value, a leakage current value, an insulation oil breakdown voltage value, a dielectric loss value, a tap switch transition resistance value, a tap switch contact resistance value and the like. The environmental data includes: test date, weather, temperature, humidity, temperature of the device, etc.
In one possible embodiment, where the electrical test report data is complex and irregular, the entry rules support customized entry by means of key tag usage customization.
In a possible embodiment, the embodiment of the invention designs a verification rule configuration tool based on a webpage, and the cell to be input is also configured with a verification rule which can be created/edited.
The verification method of the verification rule comprises the following steps: and judging that the verification is passed when the data filled in the cell to be recorded is within the set interval range.
In one possible embodiment, the cells to be entered are also configured with a check rule that can be created/edited.
The verification method of the verification rule comprises the following steps: and judging that the verification is passed when the difference between the data filled in the cell to be recorded and the historical data is within a set threshold range.
In one possible embodiment, the cells to be entered are also configured with a check rule that can be created/edited.
The verification method of the verification rule comprises the following steps: and determining the set interval range of the cells to be recorded based on the content of the context of the current report, and judging that the verification is passed when the data of the cells to be recorded is filled in the set interval range.
The context content is the measured data in the report or the basic information of the report.
In a specific implementation, the present invention provides an expression to set a verification rule, where the expression is a method body and has a format of functionvalidate (ctx), and an input parameter ctx (context) represents a context of a current report, and all measured data in the report can be obtained through the context.
Basic information such as: voltage class, substation, report name, date, external variables the user is automatic with, and information of the current logged-in user. The manner of reference is as follows:
data currently to be entered: ctx.value
Data for all cells: ctx.value [ cell name ]
Voltage class: ctx.report.site_level
Substation: ctx.report.site
Report file name: ctx.report.name
User-defined variables: ctx.var [ variable name ]
Taking the context as an example of the measured data voltage level ctx.report.site_level in the report, when the voltage level is less than 35 kilovolts, the threshold range to be met by the dielectric loss high-ground tg% in the cell to be recorded is less than or equal to 0.015; when the voltage level is between 110 kv and 220 kv, the threshold range to be met by the dielectric loss high-ground tg% in the cell to be recorded is 0.008 or less.
Funcitonvalidate(ctx){
If(ctx.report.site_level≤35){returnctx.value≤0.015}
If(ctx.report.site_level≥110&&ctx.report.site_level≤220){returnctx.value≤0.008}
}
Because the verification rules are various and different, the invention designs a verification rule configuration tool based on the webpage according to the automatic matching verification rule (the matching rule is removed by people before) of the associated cells, and the rules are uniformly described. The setting of the context, the historical data and the external global variable is supported, and the custom check rule with great freedom degree can be realized.
In one possible embodiment, the system further comprises: and a test procedure judging module.
The test rule judging module is used for managing the test rule and carrying out historical data comparison analysis on the electrical test report data.
Managing the test protocol includes: mining and carding according to actual experimental data, summarizing experimental procedures and forming quantifiable analysis indexes; the configuration rules include: a data valid value and a data correlation; and analyzing whether the acquired data accords with the test procedure.
The historical data comparison analysis of the electrical test report data comprises: and comparing and analyzing with the historical data and analyzing the data fluctuation by referring to the historical data.
The comparison analysis with the historical data includes: and comparing the historical input data of the same type of equipment with the current data difference, the data fluctuation and the data outlier.
Performing data fluctuation analysis with reference to the historical data includes: and identifying data with larger deviation values such as abnormal high deviation value or abnormal low deviation value according to the fluctuation amplitude of the historical data.
The following table 1 shows a functional unit division table of an automatic acquisition system for electrical test report data provided by the embodiment of the invention:
TABLE 1 functional unit partition Table
According to the embodiment of the automatic acquisition system for the electrical test report data, the APP is recorded on line to replace a traditional handwriting paper report; the device is automatically used for collecting the measurement data of the device, replacing the traditional manual naked eye reading and identification, and automatically inputting the measurement data to a correct position; and carrying out intelligent verification, intelligent analysis and comparison and automatic calculation according to a formula or logic rules on the acquired data.
Example 2
Embodiment 2 provided by the present invention is an embodiment of an automatic electrical test report data collection method provided by the present invention, and fig. 4 is a flowchart of an embodiment of an automatic electrical test report data collection method provided by an embodiment of the present invention, as can be seen with reference to fig. 1 to 4, the embodiment of the method includes:
and step 1, automatically identifying the positions of target measured values in the electrical test report data with the same data protocol and format, and converting the target measured values into intermediate structural data based on JSON.
Step 2, constructing a data table based on the content of the electrical test report data; the data table comprises each name cell and corresponding cells to be input; the name cell is a cell indicating the type of data, and the cell to be input is a cell of the numerical value of the type of data to be input; each cell to be input is respectively configured with a corresponding input rule, and when the acquired data in the step 1 accords with the input rules, the corresponding cell to be input is automatically filled.
It can be understood that the automatic electrical test report data collection method provided by the present invention corresponds to the automatic electrical test report data collection system provided in the foregoing embodiments, and the relevant technical features of the automatic electrical test report data collection method may refer to the relevant technical features of the automatic electrical test report data collection system, which are not described herein.
Referring to fig. 5, fig. 5 is a schematic diagram of an embodiment of an electronic device according to an embodiment of the invention. As shown in fig. 5, an embodiment of the present invention provides an electronic device, including a memory 1310, a processor 1320, and a computer program 1311 stored in the memory 1310 and executable on the processor 1320, wherein the processor 1320 executes the computer program 1311 to implement the following steps: automatically identifying the position of a target measured value in the electrical test report data of the same data protocol and format, and converting the target measured value into intermediate structural data based on JSON; constructing a data table based on the content of the electrical test report data; the data table comprises each name cell and corresponding cells to be input; the name cell is a cell indicating the type of data, and the cell to be input is a cell of the numerical value of the type of data to be input; each cell to be input is respectively configured with a corresponding input rule, and the corresponding cell to be input is automatically filled when the acquired data accords with the input rules.
Referring to fig. 6, fig. 6 is a schematic diagram of an embodiment of a computer readable storage medium according to the present invention. As shown in fig. 6, the present embodiment provides a computer-readable storage medium 1400 having stored thereon a computer program 1411, which computer program 1411, when executed by a processor, performs the steps of: automatically identifying the position of a target measured value in the electrical test report data of the same data protocol and format, and converting the target measured value into intermediate structural data based on JSON; constructing a data table based on the content of the electrical test report data; the data table comprises each name cell and corresponding cells to be input; the name cell is a cell indicating the type of data, and the cell to be input is a cell of the numerical value of the type of data to be input; each cell to be input is respectively configured with a corresponding input rule, and the corresponding cell to be input is automatically filled when the acquired data accords with the input rules.
According to the system, the method, the electronic equipment and the storage medium for automatically collecting the electrical test report data, which are provided by the embodiment of the invention, aiming at the problems that a great amount of time is consumed in the step of reading measured values and calculating the measured values in the prior art, the measurement logic of different projects is required to be memorized or consulted, so that the work needs to be completed with abundant working experience, and meanwhile, the result is accurately written into a correct cell, so that the problems of error and difficult discovery are solved; an online electronic report which can be recorded is designed, real-time measurement data from measurement equipment can be automatically captured, and the real-time measurement data can be automatically recorded into a correct cell according to configuration, so that errors caused by manual recording are avoided; the measurement logic or the disclosure can be configured without turning over on site or memorizing the calculation formula or the conversion formula.
In the foregoing embodiments, the descriptions of the embodiments are focused on, and for those portions of one embodiment that are not described in detail, reference may be made to the related descriptions of other embodiments.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. It is therefore intended that the following claims be interpreted as including the preferred embodiments and all such alterations and modifications as fall within the scope of the invention.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present invention without departing from the spirit or scope of the invention. Thus, it is intended that the present invention also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.

Claims (10)

1. An automatic electrical test report data acquisition system, the system comprising: the data acquisition module and the data input module;
the data acquisition module is used for automatically identifying the positions of target measured values in the electrical test report data with the same data protocol and format and converting the target measured values into intermediate structural data based on JSON;
the data entry module is used for constructing a data table based on the content of the electrical test report data; the data table comprises name cells and corresponding cells to be input; the name cell is a cell indicating the type of data, and the cell to be input is a cell of the numerical value of the type of data to be input; each cell to be recorded is respectively configured with a corresponding recording rule, and when the data acquired by the data acquisition module accords with the recording rules, the corresponding cell to be recorded is automatically filled.
2. The system of claim 1, wherein the entry rules for each cell configuration to be entered are created/edited;
the content that the entry rules can create/edit includes: the system comprises a mode, a name, a purpose, a PMS template, a target table, a target row and a target column and an input rule configuration, wherein the PMS template corresponds to a target test item in the electrical test report data, and the target table, the target row and the target column correspond to positions of the target table in the electrical test report data.
3. The system of claim 2, wherein the logging rules support customized logging by means of critical tag usage plus customization when the electrical test report data is complex and irregular data.
4. The system according to claim 1, wherein the cells to be entered are further configured with a check rule that can be created/edited;
the verification method of the verification rule comprises the following steps: and judging that the verification is passed when the data filled in the cell to be recorded is within the set interval range.
5. The system according to claim 1, wherein the cells to be entered are further configured with a check rule that can be created/edited;
the verification method of the verification rule comprises the following steps: and judging that the verification is passed when the gap between the data filled in the cell to be recorded and the historical data is within a set threshold range.
6. The system according to claim 1, wherein the cells to be entered are further configured with a check rule that can be created/edited;
the verification method of the verification rule comprises the following steps: determining a set interval range of the cells to be recorded based on the content of the context of the current report, and judging that verification is passed when the data of the cells to be recorded is filled in the set interval range;
the context content is measured data in the report or basic information of the report.
7. The system of claim 1, wherein the system further comprises: a test procedure judging module;
the test rule judging module is used for managing the test rule and carrying out historical data comparison analysis on the electrical test report data;
managing the test protocol includes: mining and carding according to actual experimental data, summarizing experimental procedures and forming quantifiable analysis indexes; the configuration rules include: a data valid value and a data correlation; analyzing whether the acquired data accords with a test rule;
the historical data comparison analysis of the electrical test report data comprises: performing comparative analysis with the historical data and performing data fluctuation analysis with reference to the historical data;
the comparison analysis with the historical data includes: comparing the historical input data of the same type of equipment with the current data difference, the data fluctuation and the data abnormal value;
performing data fluctuation analysis with reference to the historical data includes: and identifying data with larger deviation values such as abnormal high deviation value or abnormal low deviation value according to the fluctuation amplitude of the historical data.
8. An automatic acquisition method for electrical test report data is characterized by comprising the following steps:
step 1, automatically identifying the position of a target measured value in electrical test report data with the same data protocol and format, and converting the target measured value into intermediate structural data based on JSON;
step 2, constructing a data table based on the content of the electrical test report data; the data table comprises name cells and corresponding cells to be input; the name cell is a cell indicating the type of data, and the cell to be input is a cell of the numerical value of the type of data to be input; each cell to be input is configured with a corresponding input rule, and the data acquired in the step 1 is automatically filled into the corresponding cell to be input when the acquired data accords with the input rule.
9. An electronic device comprising a memory, a processor for implementing the steps of the electrical test report data automatic collection method of claim 8 when executing a computer management class program stored in the memory.
10. A computer-readable storage medium, having stored thereon a computer-management-class program which, when executed by a processor, implements the steps of the electrical test report data automatic acquisition method of claim 8.
CN202310996317.4A 2023-08-09 2023-08-09 Automatic acquisition system and method for electrical test report data Pending CN116976293A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310996317.4A CN116976293A (en) 2023-08-09 2023-08-09 Automatic acquisition system and method for electrical test report data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310996317.4A CN116976293A (en) 2023-08-09 2023-08-09 Automatic acquisition system and method for electrical test report data

Publications (1)

Publication Number Publication Date
CN116976293A true CN116976293A (en) 2023-10-31

Family

ID=88483049

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310996317.4A Pending CN116976293A (en) 2023-08-09 2023-08-09 Automatic acquisition system and method for electrical test report data

Country Status (1)

Country Link
CN (1) CN116976293A (en)

Similar Documents

Publication Publication Date Title
CN109711659B (en) Yield improvement management system and method for industrial production
CN111597121B (en) Precise test method based on historical test case mining
CN112734284A (en) Process industry energy consumption optimization decision system and operation method thereof for improving accuracy of evaluation result under abnormal working condition
CN111737249A (en) Abnormal data detection method and device based on Lasso algorithm
CN117056688A (en) New material production data management system and method based on data analysis
CN114896309B (en) Method and system for converting and displaying monitoring data of hydropower station
CN110968703B (en) Method and system for constructing abnormal metering point knowledge base based on LSTM end-to-end extraction algorithm
CN111382558A (en) Test report automatic generation method and system based on power monitoring system
CN116976293A (en) Automatic acquisition system and method for electrical test report data
CN112345972A (en) Power failure event-based power distribution network line transformation relation abnormity diagnosis method, device and system
CN111626542A (en) Big data-based detection method for generator excitation system
CN116467219A (en) Test processing method and device
CN114384885B (en) Process parameter adjusting method, device, equipment and medium based on abnormal working conditions
CN115118618A (en) Intelligent gateway performance test method and system
CN112990682A (en) Chemical device control parameter optimization method and system based on big data
CN111400644B (en) Calculation processing method for laboratory analysis sample
CN112747413B (en) Air conditioning system load prediction method and device
CN112488410A (en) Production equipment performance optimization method and device based on equipment comprehensive efficiency
CN111931017A (en) Intelligent configuration method and system suitable for coal preparation plant
CN112560581A (en) Engineering drawing management system, management method, computer device, medium and terminal
CN112165167A (en) Intelligent substation relay protection maintenance auxiliary system and method
CN118092362B (en) Method, device and equipment for analyzing abnormal reasons in sintering process
CN112464896B (en) Physical and mental state analysis system based on student behaviors
CN118192511A (en) Set value test method and device of instrument control system, storage medium and electronic equipment
CN117236896A (en) Automatic type selection analysis method, device and equipment for thermal control instrument

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