CN109492209B - Automatic generation method of form signature column - Google Patents
Automatic generation method of form signature column Download PDFInfo
- Publication number
- CN109492209B CN109492209B CN201811248308.2A CN201811248308A CN109492209B CN 109492209 B CN109492209 B CN 109492209B CN 201811248308 A CN201811248308 A CN 201811248308A CN 109492209 B CN109492209 B CN 109492209B
- Authority
- CN
- China
- Prior art keywords
- data
- cells
- database
- signature
- data model
- 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.)
- Active
Links
Images
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
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)
- General Factory Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an automatic generation method of a form signature column, which comprises the following steps: acquiring equipment attribute data and monitoring data of the equipment in a production process, and establishing a production database; extracting the equipment attribute data and indexing the equipment attribute data and the monitoring data; establishing a data model for the indexed monitoring data and the equipment attributes; setting and associating all cells of the signature column, configuring a reference path, connecting the reference path with the data model and disassociating unmatched cells; applying the established data model to a background operation area and automatically filling a signature in a signature column according to the data model; the method solves the technical problem that a generator cannot uniformly sign a large number of automatically generated forms in the production process by establishing a data model and setting a reference path, thereby realizing uniform signing of all the forms by the generator and achieving the technical effects of saving time and improving the working efficiency.
Description
Technical Field
The invention relates to the field of enterprise transaction management, in particular to an automatic generation method of a form signature column.
Background
The workflow technology of the production process of the process enterprise aims to solve the production coordination problem of a plurality of links in the production process of a complex process. Manufacturing Execution System (MES) is an information execution system facing the inter-vehicle layer between a plan management system at the upper layer of a production type enterprise and an industrial control system at the field layer, and is used for carrying out production information management and data processing on the whole production process from production order issuing to product completion, including the contents of order data issuing, production instruction data issuing, production process execution monitoring, field production data acquisition, data statistical processing and reporting and the like, and is the key for realizing production information processing and man-machine interaction in the complex process production process.
Although the introduction of the MES system in modern enterprises can improve the production efficiency, the MES system can generate various monitoring data in the production process, so that a large number of forms can be automatically generated in the operation process of equipment, and the forms all need to be signed by a generator.
Disclosure of Invention
The invention provides an automatic generation method of a form signature column, which solves the technical problem that a generator cannot uniformly sign a large number of automatically generated forms in the production process, thereby realizing uniform signature of the generator on all forms, and achieving the technical effects of saving time and improving working efficiency.
In order to solve the above technical problem, an embodiment of the present invention provides an automatic generation method for a form signature column, including:
acquiring equipment attribute data and monitoring data of the equipment in a production process, and establishing a production database;
extracting the equipment attribute data and indexing the equipment attribute data and the monitoring data;
copying the production database into a training database and a testing database, and respectively storing the indexed production data and equipment attribute data in the training database and the testing database;
establishing a data model, transmitting data in the training database to the data model for repeated training, extracting a feature integration data structure, and stopping training until a training threshold and training accuracy are reached;
transmitting the data in the test database to the integrated data model, repeatedly testing the data model, optimizing the data model, and stopping testing until a test threshold and test accuracy are reached;
calling all cells of the signature bar through a cell program command to set association, and inputting a disabling macro command to realize that after the signature bar cells are triggered, the cells associated with the signature bar cells are disabled;
setting a reference path for the cells of the signature column, and associating the reference path to all the cells, so that the configuration data is directly and automatically filled into other associated cells through the reference path when the configuration data of the cells of the signature column is realized;
connecting the quote path with the data model, judging whether the monitoring data of all cells are matched with the original equipment attribute data in the cells of the trigger signature bar through the data model, and cancelling a forbidden macro command for the unmatched cells;
and applying the established data model to a background operation area and automatically filling the signature column with the signature according to the data model.
As a preferred scheme, the acquiring of the device attribute data and the monitoring data of the device in the production process and establishing of the production database include:
acquiring attribute data of equipment and monitoring data of the equipment in a production process, and performing threshold processing on the monitoring data;
extracting events from the monitoring data subjected to threshold processing to generate event rising edges and event falling edges;
calculating absolute values of the event rising edge and the event falling edge, and eliminating invalid monitoring data by setting an error value and deleting the absolute value events larger than the error value;
and integrating the monitoring data after the invalid monitoring data are removed, and establishing a production database.
As a preferred scheme, the extracting the device attribute data and indexing with the monitoring data includes:
extracting equipment attribute data in a database, and performing feature extraction on the attribute data;
extracting monitoring data in a database, carrying out relevant correspondence on the extracted equipment attribute data and the monitoring data in the database, and indexing the attribute data and the monitoring data.
As a preferred scheme, the applying the established data model to the background operation area and automatically filling the signature to the signature column according to the data model includes:
applying the established data model to a background operation area through a background starting program, and storing the data model in a background server;
and the reference path is referred to a background operation area through a background starting program, cells matched with the reference path are forbidden after the cells in the signature column are triggered, and the signatures in the cells in the signature column are automatically filled into other corresponding cells through a data model according to the equipment attribute data and the monitoring data related to the equipment attribute data.
Preferably, the set error value is 5.
Preferably, the training threshold is 20 ten thousand times, and the training accuracy is 90%.
Preferably, the test threshold is 20 ten thousand times, and the test accuracy is 90%.
Preferably, the device attribute data includes a device name, a device specification, and a device power.
Compared with the prior art, the embodiment of the invention has the following beneficial effects:
by establishing the data model and setting the reference path, the technical problem that a generator cannot uniformly sign a large number of automatically generated forms in the production process is solved, so that the generator can uniformly sign all the forms, and the technical effects of saving time and improving the working efficiency are achieved.
Drawings
FIG. 1: a flow chart of the specific steps of the automatic generation method embodiment of the invention;
FIG. 2: a specific flowchart of step S1 in the embodiment of the automatic generation method of the present invention;
FIG. 3: a specific flowchart of step S2 in the embodiment of the automatic generation method of the present invention;
FIG. 4: a specific flowchart of step S3 in the embodiment of the automatic generation method of the present invention;
FIG. 5: a specific flowchart of step S4 in the embodiment of the automatic generation method of the present invention;
FIG. 6: a specific flowchart of step S5 in the embodiment of the automatic generation method of the present invention;
FIG. 7: an exemplary schematic diagram of step S1 in the embodiment of the automatic generation method of the present invention is shown.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, a preferred embodiment of the present invention provides a method for automatically generating a form signature field, including:
s1, acquiring equipment attribute data and monitoring data of the equipment in the production process, and establishing a production database;
s2, extracting the equipment attribute data and indexing with the monitoring data;
s3, establishing a data model for the indexed monitoring data and the equipment attributes;
s4, associating all cell settings of the signature bar and configuring a reference path, connecting the reference path with the data model and disassociating unmatched cells;
and S5, applying the established data model to the background operation area and automatically filling the signature to the signature column according to the data model.
Referring to fig. 2 and fig. 7, in this embodiment, the step S1 obtains the device attribute data and the monitoring data of the device in the production process, and establishes a production database, including:
s11, acquiring attribute data of equipment and monitoring data of the equipment in the production process, and performing threshold processing on the monitoring data;
s12, extracting events from the monitoring data after threshold processing, and generating event rising edges and event falling edges;
s13, calculating absolute values of the event rising edge and the event falling edge, and eliminating invalid monitoring data by setting an error value and deleting the absolute value events larger than the error value;
and S14, integrating the monitoring data after the invalid monitoring data are removed, and establishing a production database.
Referring to fig. 3, in this embodiment, the step S2 of extracting the device attribute data and indexing the device attribute data with the monitoring data includes:
s21, extracting the device attribute data in the database, and extracting the characteristics of the attribute data;
and S22, extracting the monitoring data in the database, carrying out relevant correspondence on the extracted equipment attribute data and the monitoring data in the database, and indexing the attribute data and the monitoring data.
Referring to fig. 4, in this embodiment, the step S3 is to establish a data model for the indexed monitoring data and the device attributes, and includes:
s31, copying the production database into a training database and a testing database, and respectively storing the indexed production data and equipment attribute data in the training database and the testing database;
s32, establishing a data model, transmitting the data in the training database to the data model for repeated training, extracting a feature integration data structure, and stopping training until a training threshold and training accuracy are reached;
and S33, transmitting the data in the test database to the integrated data model, repeatedly testing the data model, and optimizing the data model until reaching the test threshold and the test accuracy.
Referring to fig. 5, in this embodiment, the step S4 of associating all cell settings of the signature bar and configuring a reference path, and connecting the reference path to the data model and disassociating unmatched cells includes:
s41, calling all the cells of the signature column to set association through a cell program command, and inputting a disabling macro command to disable the cells of the signature column after triggering the cells of the signature column;
s42, setting a reference path for the cells of the signature column, and associating the reference path to all the cells, so that the configuration data can be directly and automatically filled into other associated cells through the reference path when the configuration data of the cells of the signature column are realized;
and S43, connecting the reference path with the data model, judging whether the monitoring data of all the cells are matched with the original equipment attribute data in the cells of the trigger signature bar through the data model, and canceling the forbidden macro command for the unmatched cells.
Referring to fig. 6, in this embodiment, the step S5 applies the created data model to the background operation area and automatically fills the signature in the signature bar according to the data model, including:
s51, applying the established data model to a background operation area through a background starting program, and storing the data model in a background server;
and S52, the reference path is referred to a background operation area through a background starting program, cells matched with the reference path are forbidden after the signature column cells are triggered, and the signatures in the signature column cells are automatically filled into other corresponding cells through a data model according to the device attribute data and the monitoring data related to the device attribute data.
In the present embodiment, the set error value is 5.
In this embodiment, the training threshold is 20 ten thousand times, and the training accuracy is 90%.
In this embodiment, the test threshold is 20 ten thousand times, and the test accuracy is 90%.
In this embodiment, the device attribute data includes a device name, a device specification, and a device power.
In the embodiment, the specific implementation flow of the invention is as follows:
firstly, acquiring attribute data of equipment, including equipment name, equipment specification and equipment power, and monitoring data of the equipment in a production process, performing threshold processing on the monitoring data, extracting an event from the monitoring data subjected to the threshold processing, generating an event rising edge and an event falling edge, calculating absolute values of the event rising edge and the event falling edge, eliminating invalid monitoring data by setting an error value and deleting an absolute value event which is greater than the error value by 5, integrating the monitoring data after eliminating the invalid monitoring data, and establishing a production database; secondly, extracting the equipment name, the equipment specification and the equipment power in a database, extracting the characteristics of the equipment name, the equipment specification and the equipment power, extracting monitoring data in the database, carrying out relevant correspondence on the extracted equipment name, the extracted equipment specification and the extracted equipment power and the monitoring data in the database, and indexing the equipment name, the extracted equipment specification and the extracted equipment power and the monitoring data; then, copying the production database into a training database and a testing database, respectively storing the indexed production data and equipment attribute data in the training database and the testing database, establishing a data model, transmitting the data in the training database to the data model for repeated training, extracting a feature integration data structure, stopping training until a training threshold value of 20 ten thousand times and a training accuracy of 90% are reached, transmitting the data in the testing database to the integrated data model, repeatedly testing the data model, optimizing the data model, and stopping testing until the testing threshold value of 20 ten thousand times and the testing accuracy of 90% are reached; then, calling all cells of the signature column to set association through a cell program command, inputting a forbidden macro command, realizing that after the cells of the signature column are triggered, the cells associated with the cells are forbidden, setting a reference path for the cells of the signature column, associating the reference path to all the cells, directly and automatically filling the configuration data into other associated cells through the reference path when the configuration data of the cells of the signature column are realized, connecting the reference path with the data model, judging whether the monitoring data of all the cells are matched with the original equipment attribute data in the cells of the triggered signature column through the data model, and cancelling the forbidden macro command for the mismatched cells; and finally, applying the established data model to a background operation area through a background starting program, storing the data model in a background server, quoting the quoting path to the background operation area through the background starting program, disabling the cells matched with the signature column cells after triggering the signature column cells, and automatically filling the signatures in the signature column cells into other corresponding cells through the data model according to the equipment attribute data and the monitoring data related to the equipment attribute data.
The invention solves the technical problem that a generator cannot uniformly sign a large number of automatically generated forms in the production process by establishing a data model and setting a reference path, thereby realizing that the generator uniformly signs all the forms, and achieving the technical effects of saving time and improving the working efficiency.
The above-mentioned embodiments are provided to further explain the objects, technical solutions and advantages of the present invention in detail, and it should be understood that the above-mentioned embodiments are only examples of the present invention and are not intended to limit the scope of the present invention. It should be understood that any modifications, equivalents, improvements and the like, which come within the spirit and principle of the invention, may occur to those skilled in the art and are intended to be included within the scope of the invention.
Claims (7)
1. An automatic generation method for a form signature column is characterized by comprising the following steps:
acquiring equipment attribute data and monitoring data of the equipment in a production process, and establishing a production database;
extracting the equipment attribute data and indexing the equipment attribute data and the monitoring data;
copying the production database into a training database and a testing database, and respectively storing the indexed production data and equipment attribute data in the training database and the testing database;
establishing a data model, transmitting data in the training database to the data model for repeated training, extracting a feature integration data structure, and stopping training until a training threshold and training accuracy are reached;
transmitting the data in the test database to the integrated data model, repeatedly testing the data model, optimizing the data model, and stopping testing until a test threshold and test accuracy are reached;
calling all cells of the signature bar through a cell program command to set association, and inputting a disabling macro command to realize that after the signature bar cells are triggered, the cells associated with the signature bar cells are disabled;
setting a reference path for the cells of the signature column, and associating the reference path to all the cells, so that the configuration data is directly and automatically filled into other associated cells through the reference path when the configuration data of the cells of the signature column is realized;
connecting the quote path with the data model, judging whether the monitoring data of all cells are matched with the original equipment attribute data in the cells of the trigger signature bar through the data model, and cancelling a forbidden macro command for the unmatched cells;
and applying the established data model to a background operation area and automatically filling the signature column with the signature according to the data model.
2. The method for automatically generating form signature column according to claim 1, wherein the obtaining of the device attribute data and the monitoring data of the device in the production process and establishing of the production database comprises:
acquiring attribute data of equipment and monitoring data of the equipment in a production process, and performing threshold processing on the monitoring data;
extracting events from the monitoring data subjected to threshold processing to generate event rising edges and event falling edges;
calculating absolute values of the event rising edge and the event falling edge, and eliminating invalid monitoring data by setting an error value and deleting the absolute value events larger than the error value;
and integrating the monitoring data after the invalid monitoring data are removed, and establishing a production database.
3. The method of automatically generating a form signature panel of claim 1, wherein said extracting and indexing said device attribute data with said monitoring data comprises:
extracting equipment attribute data in a database, and performing feature extraction on the attribute data;
extracting monitoring data in a database, carrying out relevant correspondence on the extracted equipment attribute data and the monitoring data in the database, and indexing the attribute data and the monitoring data.
4. The method for automatically generating a form signature column according to claim 1, wherein the applying the established data model to the background operation area and automatically filling the signature column with the signature according to the data model comprises:
applying the established data model to a background operation area through a background starting program, and storing the data model in a background server;
and the reference path is referred to a background operation area through a background starting program, cells matched with the reference path are forbidden after the cells in the signature column are triggered, and the signatures in the cells in the signature column are automatically filled into other corresponding cells through a data model according to the equipment attribute data and the monitoring data related to the equipment attribute data.
5. The method for automatically generating a form signature column according to claim 2, wherein the set error value is 5.
6. The method of automatically generating a form signature column as claimed in claim 1, wherein the training threshold is 20 ten thousand times and the training accuracy is 90%.
7. The form signature column automatic generation method of any of claims 1 to 6, wherein the device attribute data includes a device name, a device specification, and a device power.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811248308.2A CN109492209B (en) | 2018-10-25 | 2018-10-25 | Automatic generation method of form signature column |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811248308.2A CN109492209B (en) | 2018-10-25 | 2018-10-25 | Automatic generation method of form signature column |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109492209A CN109492209A (en) | 2019-03-19 |
| CN109492209B true CN109492209B (en) | 2022-02-18 |
Family
ID=65691890
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811248308.2A Active CN109492209B (en) | 2018-10-25 | 2018-10-25 | Automatic generation method of form signature column |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109492209B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110197142A (en) * | 2019-05-16 | 2019-09-03 | 谷东科技有限公司 | Object identification method, device, medium and terminal device under faint light condition |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103530127B (en) * | 2013-10-22 | 2017-08-29 | 北京奇虎科技有限公司 | icon display method and device |
| US9514327B2 (en) * | 2013-11-14 | 2016-12-06 | Intralinks, Inc. | Litigation support in cloud-hosted file sharing and collaboration |
| CN104778241B (en) * | 2015-04-08 | 2019-06-04 | 北京京东尚科信息技术有限公司 | A kind of report form generation method and system |
| CN105441774A (en) * | 2015-11-15 | 2016-03-30 | 丹阳市德源精密工具有限公司 | Ferroboron mold |
| CN105511791A (en) * | 2015-12-08 | 2016-04-20 | 刘炳林 | Handwriting processing method and device for electronic test and quality control record chart |
| EP3296864A1 (en) * | 2016-09-20 | 2018-03-21 | Siemens Aktiengesellschaft | Storing and retrieving documentation |
| CN106547729B (en) * | 2016-12-01 | 2019-02-01 | 长城计算机软件与***有限公司 | A kind of dynamic creation method and system of data sheet |
-
2018
- 2018-10-25 CN CN201811248308.2A patent/CN109492209B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN109492209A (en) | 2019-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104391934B (en) | Data verification method and device | |
| CN102236672B (en) | A kind of data lead-in method and device | |
| CN101888655A (en) | Method and device for configuring network element data in template way in network management system | |
| CN103886119A (en) | Intelligent auxiliary designing system for sheet metal components | |
| CN106777106A (en) | The method for exhibiting data of the financial statement based on excel | |
| WO2024060725A1 (en) | Aircraft tool change method and apparatus, device, and storage medium | |
| CN109508953B (en) | Form template generation method | |
| CN109522536B (en) | Automatic form filling method | |
| CN109492209B (en) | Automatic generation method of form signature column | |
| CN110766167A (en) | Interactive feature selection method, device and readable storage medium | |
| CN111651968A (en) | Automatic EXCEL report generation method and system and information data processing terminal | |
| CN111177398B (en) | Method and device for updating organization architecture | |
| CN101667124A (en) | System and method for configuring monitoring device based on object model | |
| CN100520791C (en) | Print circuit board before-typesetting processing system and method | |
| CN113886590A (en) | Data summarizing method and device, computer equipment and storage medium | |
| CN109376159B (en) | Batch record automatic generation method | |
| CN109522268A (en) | It is a kind of that analysis method is imported with the power grid SVG mutually separated is imported based on verification | |
| CN109446182B (en) | Composite acquisition method | |
| CN107943835A (en) | It is a kind of to report and submit data analysis and taxis system for electric system | |
| CN111931012A (en) | Data model self-adaption method and device based on fault management subsystem | |
| CN109242357B (en) | Process editing method of MES system | |
| CN104318361A (en) | Temperature isostatic press reliability analysis management system and method | |
| CN104216986A (en) | Device and method for improving data query efficiency through pre-operation according to data update period | |
| CN104375926B (en) | Alarm threshold value setting system for monitoring of large-scale server | |
| CN110929876A (en) | Alarm threshold value setting method based on machine learning |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |