CN114817863A - Process quality situation control system - Google Patents
Process quality situation control system Download PDFInfo
- Publication number
- CN114817863A CN114817863A CN202210656435.6A CN202210656435A CN114817863A CN 114817863 A CN114817863 A CN 114817863A CN 202210656435 A CN202210656435 A CN 202210656435A CN 114817863 A CN114817863 A CN 114817863A
- Authority
- CN
- China
- Prior art keywords
- data
- analysis
- acquisition
- report
- control system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
- G06F17/18—Complex mathematical operations for evaluating statistical data, e.g. average values, frequency distributions, probability functions, regression analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Data Mining & Analysis (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Educational Administration (AREA)
- Computational Mathematics (AREA)
- Development Economics (AREA)
- Mathematical Physics (AREA)
- Mathematical Analysis (AREA)
- Mathematical Optimization (AREA)
- Pure & Applied Mathematics (AREA)
- Bioinformatics & Computational Biology (AREA)
- General Factory Administration (AREA)
- Probability & Statistics with Applications (AREA)
- Evolutionary Biology (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- Algebra (AREA)
- Health & Medical Sciences (AREA)
- Life Sciences & Earth Sciences (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Game Theory and Decision Science (AREA)
- General Health & Medical Sciences (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Artificial Intelligence (AREA)
Abstract
The invention relates to the technical field of SPC statistical analysis and discloses a process quality situation control system, which consists of a data acquisition technology and a data analysis technology, wherein the data acquisition technology comprises the following steps: the system comprises an acquisition equipment module, an automatic strategy module and a background data acquisition service module, wherein the data analysis technology comprises the following steps: the system comprises an SPC client login end module, a data detection generation module and a data correction generation module. According to the invention, through the data acquisition and data analysis functions of the process quality situation control system, the working efficiency of measurement is greatly improved, the data is accurate, the reliability is high, and through SPC data analysis provided by the use system, the application value of quality data is improved, the analysis and control of process detection data are enhanced, the product compliance is ensured, the product quality is improved, and a data basis is provided for the improvement and research and development of product technology.
Description
Technical Field
The invention relates to the technical field of SPC statistical analysis, in particular to a process quality situation control system.
Background
SPC mainly refers to the application of statistical analysis technology to real-time monitoring of the production process, and scientifically distinguishes random fluctuation and abnormal fluctuation of product quality in the production process, so that early warning is provided for abnormal trends in the production process, production managers can take measures in time, abnormalities are eliminated, stability of the process is recovered, and the purpose of improving and controlling quality is achieved.
In the production process, the fluctuation of the processing size of the product is inevitable, and is caused by the fluctuation influence of basic factors such as people, machines, materials, methods, environment and the like, the existing processing product has many working procedures, the product is difficult to be effectively analyzed and controlled in real time by manual operation, the product quality in the process cannot be controlled comprehensively, meanwhile, the production process of the product is not monitored in real time, whether the production process is stable or not cannot be known in time, the collection of quality data is not automatic, the product is mainly collected in a manual mode, the sorting and statistics of the data are scattered, the data sharing performance is poor, and the query statistical analysis of historical data cannot be realized. Accordingly, one skilled in the art provides a process quality situational control system to address the problems set forth in the background above.
Disclosure of Invention
The present invention is directed to a process quality situation control system to solve the above-mentioned problems of the prior art.
In order to achieve the purpose, the invention provides the following technical scheme: a process quality situational control system comprised of a data acquisition technique and a data analysis technique, wherein:
the data acquisition technology is in an automatic acquisition mode and comprises the following steps:
the acquisition equipment module is used for acquiring data parameter information from the production equipment execution system;
the automatic strategy module is used for establishing an SPC strategy for the acquired data parameter information, correcting the data parameter information newly acquired by the acquisition equipment module to different degrees after the type of the data parameter information is modified;
the background data acquisition service module is used for acquiring background data, acquiring related data by the background data acquisition service and executing data transmission service according to a transmission strategy configured by the acquisition equipment module;
the data analysis technology is a report analysis mode and comprises the following steps:
the SPC client login end module is used for login query work of an SPC account;
the data detection generation module is used for generating a data parameter information comparison graph, and the graph analysis tool comprises: Xbar-R, Xbar-S, X-MR, Me-R, P, NP, C, U, pareto, histogram, sample plot, mean plot, linear regression plot, boxplot;
and the data correction generation module is used for dynamically correcting the original comparison graph, and the correction range comprises an average value, a maximum value, a minimum value, a standard deviation, a center offset, an offset coefficient, a process capability index (Cpk), a process performance index (Ppk) and a process capability index with a target value of the original graph tool.
As a still further scheme of the invention: the acquisition process of the data acquisition technology comprises the following steps:
s1, selecting equipment to be collected from the data collection configuration tool of the process quality situation control system;
s2, acquiring preferred Modbus of a device communication protocol, and firstly configuring connection parameters of Modbus protocol devices, wherein the configuration parameters of protocol device attributes comprise: equipment ID, equipment name, equipment IP, port number, acquisition protocol, acquisition frequency, station number, transmission queue name and analytic format;
s3, after the parameters are determined to be connected, adding work of collecting item times is carried out, wherein the adding variable attributes of the item times comprise: variable name, variable alias, function, data type, address, character length, bit address and decimal digit;
and S4, after the configuration is finished, the background data acquisition service acquires the related data, preferentially uses the MQTT to transmit according to the transmission strategy configured by the configuration tool, and transmits the data to the appointed MQTT server.
As a still further scheme of the invention: the acquisition device in step S1 includes:
automatically reading data from a test instrument data file (three-coordinate, durometer, cylinder coordinates);
acquiring data from a PLC (Siemens, Mitsubishi, ohm dragon) or a data interface (RS 232/485, TCP/IP) of the detection equipment;
obtaining data from a processing device CNC (hairy, siemens, mitsubishi) or off-standard device;
reading data from other system interfaces, such as MES and configuration software;
acquiring data from online measuring tools (calipers, micrometers and gauges) such as a serial port, a USB interface, Bluetooth and the like;
manual entry or file (text file, Excel file) import.
As a still further scheme of the invention: the analysis flow of the data analysis technology comprises the following steps:
a1, logging in an account by using the role of an SPC analyst, and displaying a system account interface;
a2, the main interface of the system has two types of nodes of measurement type detection and counting type detection, a measurement type detection report is added, and a measurement type detection node or a sub-node below the measurement type detection node is selected;
a3, after a metering type detection report appears, selecting a group name, a detection item and a product classification, filling a product name, a specification upper limit, a specification lower limit and a specification target value, wherein if the analysis is initial capacity analysis, Xbar-UCL, Xbar-LCL, Xbar-CL, R-UCL, R-LCL and R-CL do not need to be filled, and if the analysis is process capacity analysis, Xbar-UCL, Xbar-LCL, Xbar-CL, R-UCL, R-LCL and R-CL need to be filled;
a4, after the report is filled, executing the operation of 'exception judgment rule', and selecting the corresponding exception judgment rule, namely displaying the newly added report in the main interface of the system;
and A5, after the report analysis task is created, inputting or importing data, executing report import or manual import operation, collecting sample data, and performing SPC analysis according to the sample data.
As a still further scheme of the invention: the "report import" in the step a5 adopts an Excel table generation form, and the generation form is a metering type detection report form, and includes: the detection content of the metering type detection report comprises display sample data, an average value, a range value, a maximum value, a minimum value, a standard deviation value and sample state information.
Compared with the prior art, the invention has the beneficial effects that:
according to the invention, through the data acquisition and data analysis functions of the process quality situation control system, the working efficiency of measurement is greatly improved, the data is accurate, the reliability is high, and through SPC data analysis provided by the use system, the application value of quality data is improved, the analysis and control of process detection data are enhanced, the product compliance is ensured, the product quality is improved, and a data basis is provided for the improvement and research and development of product technology.
Drawings
FIG. 1 is a schematic diagram of a process quality situation control system;
FIG. 2 is a schematic flow diagram of a data acquisition technique in a process quality situation control system;
FIG. 3 is an Xbar-R control chart of a data analysis technique in a process quality situational control system;
FIG. 4 is a CPK analysis diagram of a data analysis technique in a process quality situation control system;
FIG. 5 is a sample operating diagram of a data analysis technique in a process quality situational control system;
FIG. 6 is a running graph of the mean of data analysis techniques in a process quality situation control system;
FIG. 7 is a sample normal distribution plot of a data analysis technique in a process quality situation control system;
FIG. 8 is a CPK trend graph of a data analysis technique in a process quality situation control system;
FIG. 9 is a sample linear regression graph of a data analysis technique in a process quality situation control system;
FIG. 10 is a box plot of a data analysis technique in a process quality situational control system.
Detailed Description
Referring to fig. 1 to 10, in an embodiment of the present invention, a process quality situation control system is composed of a data acquisition technology and a data analysis technology, where:
the data acquisition technology is in an automatic acquisition mode and comprises the following steps:
the acquisition equipment module is used for acquiring data parameter information from the production equipment execution system;
the automatic strategy module is used for establishing an SPC strategy for the acquired data parameter information, correcting the data parameter information newly acquired by the acquisition equipment module to different degrees after the type of the data parameter information is modified;
the background data acquisition service module is used for acquiring background data, acquiring related data by the background data acquisition service and executing data transmission service according to a transmission strategy configured by the acquisition equipment module;
the data analysis technology is a report analysis mode and comprises the following steps:
the SPC client login end module is used for login query work of an SPC account;
the data detection generation module is used for generating a data parameter information comparison graph, and the graph analysis tool comprises: Xbar-R, Xbar-S, X-MR, Me-R, P, NP, C, U, pareto, histogram, sample plot, mean plot, linear regression plot, boxplot;
and the data correction generation module is used for dynamically correcting the original comparison graph, and the correction range comprises an average value, a maximum value, a minimum value, a standard deviation, a center offset, an offset coefficient, a process capability index (Cpk), a process performance index (Ppk) and a process capability index with a target value of the original graph tool.
The acquisition process of the data acquisition technology comprises the following steps:
s1, selecting equipment to be collected from the data collection configuration tool of the process quality situation control system;
s2, acquiring preferred Modbus of a device communication protocol, and firstly configuring connection parameters of Modbus protocol devices, wherein the configuration parameters of protocol device attributes comprise: equipment ID, equipment name, equipment IP, port number, acquisition protocol, acquisition frequency, station number, transmission queue name and analytic format;
s3, after the parameters are determined to be connected, adding work of collecting item times is carried out, wherein the adding variable attributes of the item times comprise: variable name, variable alias, function, data type, address, character length, bit address and decimal digit;
and S4, after the configuration is finished, the background data acquisition service acquires the related data, preferentially uses the MQTT to transmit according to the transmission strategy configured by the configuration tool, and transmits the data to the appointed MQTT server.
The acquisition device in step S1 includes:
automatically reading data from a test instrument data file (three-coordinate, durometer, cylinder coordinates);
acquiring data from a PLC (Siemens, Mitsubishi, ohm dragon) or a data interface (RS 232/485, TCP/IP) of the detection equipment;
acquiring data from a CNC (computerized numerical control) or off-the-shelf (Sendai, Siemens, Mitsubishi) machine;
reading data from other system interfaces, such as MES and configuration software;
data are obtained from online measuring tools (calipers, a micrometer and a gauge) such as a serial port, a USB interface, Bluetooth and the like;
manual entry or file (text file, Excel file) import.
The analysis flow of the data analysis technology comprises the following steps:
a1, logging in an account by using the role of an SPC analyst, and displaying a system account interface;
a2, the main interface of the system has two types of nodes of measurement type detection and counting type detection, a measurement type detection report is added, and a measurement type detection node or a sub-node below the measurement type detection node is selected;
a3, after a metering type detection report appears, selecting a group name, a detection item and a product classification, filling a product name, a specification upper limit, a specification lower limit and a specification target value, wherein if the analysis is initial capacity analysis, Xbar-UCL, Xbar-LCL, Xbar-CL, R-UCL, R-LCL and R-CL do not need to be filled, and if the analysis is process capacity analysis, Xbar-UCL, Xbar-LCL, Xbar-CL, R-UCL, R-LCL and R-CL need to be filled;
a4, after the report is filled, executing the operation of 'exception judgment rule', and selecting the corresponding exception judgment rule, namely displaying the newly added report in the main interface of the system;
and A5, after the report analysis task is created, inputting or importing data, executing report import or manual import operation, collecting sample data, and performing SPC analysis according to the sample data.
The report import in the step a5 is in the form of Excel table generation, and the generated table is in the form of a metering type detection report, and includes: the detection content of the metering type detection report comprises display sample data, an average value, a range value, a maximum value, a minimum value, a standard difference value and sample state information.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art should be considered to be within the technical scope of the present invention, and the technical solutions and the inventive concepts thereof according to the present invention are equivalent to or changed within the technical scope of the present invention.
Claims (5)
1. Process quality situation control system, characterized in that process quality situation control system comprises data acquisition technique and data analysis technique, wherein:
the data acquisition technology is in an automatic acquisition mode and comprises the following steps:
the acquisition equipment module is used for acquiring data parameter information from the production equipment execution system;
the automatic strategy module is used for establishing an SPC strategy for the acquired data parameter information, correcting the data parameter information newly acquired by the acquisition equipment module to different degrees after the type of the data parameter information is modified;
the background data acquisition service module is used for acquiring background data, acquiring related data by the background data acquisition service and executing data transmission service according to a transmission strategy configured by the acquisition equipment module;
the data analysis technology is a report analysis mode and comprises the following steps:
the SPC client login end module is used for login query work of an SPC account;
the data detection generation module is used for generating a data parameter information comparison graph, and the graph analysis tool comprises: Xbar-R, Xbar-S, X-MR, Me-R, P, NP, C, U, pareto, histogram, sample plot, mean plot, linear regression plot, boxplot;
and the data correction generation module is used for dynamically correcting the original comparison graph, and the correction range comprises an average value, a maximum value, a minimum value, a standard deviation, a center offset, an offset coefficient, a process capability index (Cpk), a process performance index (Ppk) and a process capability index with a target value of the original graph tool.
2. The process quality situational control system of claim 1, wherein the acquisition flow of the data acquisition technique includes the steps of:
s1, selecting equipment to be collected from the data collection configuration tool of the process quality situation control system;
s2, acquiring preferred Modbus of a device communication protocol, and firstly configuring connection parameters of Modbus protocol devices, wherein the configuration parameters of protocol device attributes comprise: equipment ID, equipment name, equipment IP, port number, acquisition protocol, acquisition frequency, station number, transmission queue name and analytic format;
s3, after the parameters are determined to be connected, adding work of collecting item times is carried out, wherein the adding variable attributes of the item times comprise: variable name, variable alias, function, data type, address, character length, bit address and decimal digit;
and S4, after the configuration is finished, the background data acquisition service acquires the related data, preferentially uses the MQTT to transmit according to the transmission strategy configured by the configuration tool, and transmits the data to the appointed MQTT server.
3. The process quality situation control system according to claim 2, wherein the collecting device in step S1 includes:
automatically reading data from a test instrument data file (three-coordinate, durometer, cylinder coordinates);
acquiring data from a PLC (Siemens, Mitsubishi, ohm dragon) or a data interface (RS 232/485, TCP/IP) of the detection equipment;
acquiring data from a CNC (computerized numerical control) or off-the-shelf (Sendai, Siemens, Mitsubishi) machine;
reading data from other system interfaces, such as MES and configuration software;
acquiring data from online measuring tools (calipers, micrometers and gauges) such as a serial port, a USB interface, Bluetooth and the like;
manual entry or file (text file, Excel file) import.
4. The process quality situational control system of claim 1, wherein the analysis flow of the data analysis technique includes the steps of:
a1, logging in an account by using the role of an SPC analyst, and displaying a system account interface;
a2, the main interface of the system has two types of nodes of measurement type detection and counting type detection, a measurement type detection report is added, and a measurement type detection node or a sub-node below the measurement type detection node is selected;
a3, after a metering type detection report appears, selecting a group name, a detection item and a product classification, filling a product name, a specification upper limit, a specification lower limit and a specification target value, wherein if the analysis is initial capacity analysis, Xbar-UCL, Xbar-LCL, Xbar-CL, R-UCL, R-LCL and R-CL do not need to be filled, and if the analysis is process capacity analysis, Xbar-UCL, Xbar-LCL, Xbar-CL, R-UCL, R-LCL and R-CL need to be filled;
a4, after the report is filled, executing the operation of 'exception judgment rule', and selecting the corresponding exception judgment rule, namely displaying the newly added report in the main interface of the system;
and A5, after the report analysis task is created, inputting or importing data, executing report import or manual import operation, collecting sample data, and performing SPC analysis according to the sample data.
5. The process quality situation control system according to claim 4, wherein the "report import" in step A5 is in the form of Excel table generation, and the generation table is in the form of a metrology-type inspection report, and comprises: the detection content of the metering type detection report comprises display sample data, an average value, a range value, a maximum value, a minimum value, a standard deviation value and sample state information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210656435.6A CN114817863A (en) | 2022-06-11 | 2022-06-11 | Process quality situation control system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210656435.6A CN114817863A (en) | 2022-06-11 | 2022-06-11 | Process quality situation control system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114817863A true CN114817863A (en) | 2022-07-29 |
Family
ID=82520676
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210656435.6A Pending CN114817863A (en) | 2022-06-11 | 2022-06-11 | Process quality situation control system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114817863A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115238421A (en) * | 2022-09-23 | 2022-10-25 | 中国人民解放军国防科技大学 | Method and device for designing charging configuration of multi-pulse gas generator and computer equipment |
-
2022
- 2022-06-11 CN CN202210656435.6A patent/CN114817863A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115238421A (en) * | 2022-09-23 | 2022-10-25 | 中国人民解放军国防科技大学 | Method and device for designing charging configuration of multi-pulse gas generator and computer equipment |
| CN115238421B (en) * | 2022-09-23 | 2022-12-09 | 中国人民解放军国防科技大学 | Method and device for designing charging configuration of multi-pulse gas generator and computer equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104646565B (en) | A kind of full-automatic stamping line real-time monitoring system | |
| CN102927937B (en) | A kind of measuring system based on cloud | |
| CN106597991A (en) | Numerically controlled machine tool remote monitoring method and device | |
| CN104503362B (en) | Batch workpiece digital control processing progress automatic acquiring method based on Multi-information acquisition | |
| CN107942966A (en) | Production information management system, numerically-controlled machine tool and production management system | |
| CN108536094A (en) | Machine tool capability detecting system, method and numerically-controlled machine tool | |
| CN108090675A (en) | The quality control system that a kind of vehicle is manufactured | |
| CN103246228A (en) | System for monitoring mean value and standard deviation in on-line way | |
| CN114817863A (en) | Process quality situation control system | |
| CN112346413A (en) | Method for improving production quality of aviation structural part | |
| CN210878880U (en) | Numerical control lathe cutter wearing and tearing monitoring system | |
| Patel et al. | Real-Time Performance Monitoring of a CNC Milling Machine using ROS 2 and AWS IoT Towards Industry 4.0 | |
| CN108182642B (en) | Gas outburst parameter online management system and method | |
| CN110568817A (en) | machine tool motion temperature difference compensation method based on big data analysis and prejudgment | |
| Ferreira et al. | The coordinate measuring machines, essential tools for quality control of dimensional and geometrical specifications of technical components, in the context of the industry 4.0 | |
| CN208262422U (en) | A kind of laser scanning break detection device based on Internet of Things | |
| CN206435486U (en) | On-line pressing pump quality detection system | |
| CN206683599U (en) | Workpiece calibration system | |
| CN111774932B (en) | Cutter health condition online monitoring method, device and system | |
| CN108664007A (en) | A kind of H profile steel making information monitoring system | |
| Qiang et al. | Research of visualization monitoring technology based on internet of things in discrete manufacturing process | |
| CN103676872A (en) | Method and system for production management | |
| CN115243118A (en) | Zigbee-based measurement and test instrument measurement and control and information management system and method | |
| JP2021526675A (en) | Methods and systems for providing process protocols for machine data | |
| CN110287195A (en) | Distributed data analyzing system and method |
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 |