CN112461176A - Automatic statistical method for three-coordinate measurement report based on LabVIEW - Google Patents
Automatic statistical method for three-coordinate measurement report based on LabVIEW Download PDFInfo
- Publication number
- CN112461176A CN112461176A CN202011223888.7A CN202011223888A CN112461176A CN 112461176 A CN112461176 A CN 112461176A CN 202011223888 A CN202011223888 A CN 202011223888A CN 112461176 A CN112461176 A CN 112461176A
- Authority
- CN
- China
- Prior art keywords
- data
- file
- labview
- reading
- report
- 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
- G01—MEASURING; TESTING
- G01B—MEASURING LENGTH, THICKNESS OR SIMILAR LINEAR DIMENSIONS; MEASURING ANGLES; MEASURING AREAS; MEASURING IRREGULARITIES OF SURFACES OR CONTOURS
- G01B21/00—Measuring arrangements or details thereof, where the measuring technique is not covered by the other groups of this subclass, unspecified or not relevant
- G01B21/02—Measuring arrangements or details thereof, where the measuring technique is not covered by the other groups of this subclass, unspecified or not relevant for measuring length, width, or thickness
- G01B21/04—Measuring arrangements or details thereof, where the measuring technique is not covered by the other groups of this subclass, unspecified or not relevant for measuring length, width, or thickness by measuring coordinates of points
Landscapes
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Complex Calculations (AREA)
Abstract
The invention provides a three-coordinate measurement report automatic statistics method based on LabVIEW, which comprises the following steps: s1, analyzing the original measurement report, and counting a report template; and S2, completing data statistics work by using LabVIEW software, reading a report template, writing the statistical data into a file, and generating a report. The method for automatically counting the three-coordinate measurement report based on the LabVIEW completes automatic generation of the measurement report by utilizing the LabVIEW, does not need to modify the current situation of the original equipment, and has low cost; the manual operation error is effectively reduced, and the reliability and the accuracy of the data are improved.
Description
Technical Field
The invention belongs to the technical field of metering test, and particularly relates to a three-coordinate measurement report automatic statistics method based on LabVIEW.
Background
The three-coordinate measuring machine is widely used in the industries of machinery, electronics, instruments, plastics and the like, is one of the most effective methods for measuring and obtaining dimension data, can replace various surface measuring tools and expensive combined gauges, and is used for detecting the mechanical dimension, form and position tolerance and the like of high-precision parts.
At present, the measurement data of three coordinates are different in type reports, one table is formed in each measurement, the measurement reports of a plurality of parts are not beneficial to statistical analysis, and the measurement results cannot be reflected visually. The statistical analysis of the existing measurement report is also manual operation, and the measurement data of the single component is searched and copied. The measured data items of a single part are more, and the manual operation process is time-consuming and labor-consuming and is easy to make mistakes.
Disclosure of Invention
In view of the above, in order to overcome the above drawbacks, the present invention aims to provide a method for automatically counting three-coordinate measurement reports based on LabVIEW.
In order to achieve the purpose, the technical scheme of the invention is realized as follows:
a three-coordinate measurement report automatic statistics method based on LabVIEW comprises the following steps:
s1, analyzing the original measurement report, and counting a report template;
and S2, completing data statistics work by using LabVIEW software, reading a report template, writing the statistical data into a file, and generating a report.
Further, the specific method of step S1 is as follows:
measuring items and template formats measured for multiple times in the original file data format are fixed, counting work reads items and test data at relatively fixed positions, and the data counting searching and reading processes are repeatedly programmable and automated;
the statistical report template is mainly used for counting detection results and comprises test items, positive tolerance, negative tolerance and measured data of each workpiece.
Further, in step S2, the statistics work includes reading a file, searching data, performing data statistics, writing a file, and saving a file.
Further, the method for reading the file comprises the following steps:
selecting a single file or a plurality of file paths according to the model of the three-coordinate measuring machine, and carrying out classification processing: judging the size of a single file, directly reading all data when the file is smaller than a certain threshold value, and reading the data when the file is larger than the threshold value, and reading the data in a segmented manner so as to avoid the situation that the processing is blocked due to overlarge content; and opening the files one by one, reading data from a single file, and reading the next file after the processing is finished.
Further, the method for searching data comprises:
carrying out programming design according to the manual searching step;
acquiring data of a single measurement result, segmenting data content under the condition of a single file, and processing the data in segments by taking the serial number of the part as a unit according to a fixed text;
formatting the single measurement data, and reducing the single measurement result into a form of a two-dimensional array table from a character string according to a tab character and a line feed character so as to search indexes conveniently;
and searching and indexing data at corresponding positions in the single measurement result two-dimensional data according to the required measurement items, wherein the single measurement result data is a one-dimensional array, and the multi-row data of the plurality of measurement items form the two-dimensional data.
Further, the data statistics method comprises the following steps:
and (4) forming a two-dimensional array by the name of the measurement item, the tolerance and the multiple measurement data according to the array, and completing data statistics.
Compared with the prior art, the method for automatically counting the three-coordinate measurement report based on the LabVIEW has the following advantages:
the method for automatically counting the three-coordinate measurement report based on the LabVIEW completes the automatic generation of the measurement report by utilizing the LabVIEW on the basis of the manual counting of the existing three-coordinate measuring machine, does not need to modify the current situation of the original equipment, and has low cost; the manual operation error is effectively reduced, and the reliability and the accuracy of data are improved; the invention adopts LabVIEW software, the human-computer interface is simple to operate, and the stability is high; meanwhile, the software is programmed by using a graphical language, so that modification and debugging are facilitated.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate an embodiment of the invention and, together with the description, serve to explain the invention and not to limit the invention. In the drawings:
FIG. 1 is a schematic diagram of a measurement report in GLOBAL555 raw data format;
fig. 2 is a schematic diagram of a measurement report in MGH8106 raw data format;
FIG. 3 is a diagram of a report template format;
FIG. 4 is a software interface schematic;
FIG. 5 is a schematic diagram of a sample report generation;
fig. 6 is a software flow diagram.
Detailed Description
It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict.
The present invention will be described in detail below with reference to the embodiments with reference to the attached drawings.
On the basis of the original measurement report, the invention provides a three-coordinate measurement report automatic statistics method based on LabVIEW, which comprises the following steps:
the method comprises the following steps: report analysis
The measurement report formats of different three-coordinate measuring machines are different, as shown in the attached figure 1, the storage form of the multiple measurement results of the GLOBAL555 type is a plurality of tables and a single file, and the file format is rtf; as shown in fig. 2, model MGH8106 is a single table with multiple files in docx format. The measurement items and template formats of multiple measurements in the original file data format are fixed, the statistical work is only required to read the items and the test data at the relatively fixed position, and the data statistical searching and reading processes are repeatedly programmable and automated.
The statistics report template, as shown in fig. 3, is mainly statistics of the detection results, including test items (requirements), positive tolerances, negative tolerances, and actual measurement data of each workpiece. And forming an array of the statistical data, writing the array into a report template, renaming and storing.
Step two: software implementation
The software is developed by adopting LabVIEW, the human-computer interface is simple to operate and high in stability, and graphical language programming is used, so that modification and debugging are convenient. The interface is as shown in fig. 4, the corresponding model is selected, a single file and a plurality of files are correspondingly selected, a file conversion button is clicked, and after the conversion of the popped file is completed, a statistical report (named by conversion time, such as '2020-02-19.16.08.04.460. docx') can be generated under the folder where the file is located. The report is shown in figure 5.
The basic flow of the statistical work comprises reading files, searching data, performing data statistics, writing files and storing files. The software flow is shown in fig. 6.
1. Reading a file:
selecting a single file or a plurality of file paths according to the model, and classifying: judging the size of a single file, directly reading all data of the file which is smaller than 1MB, and reading part of the file which is larger than 1MB, and reading the data in a segmented manner so as to avoid the situation that the processing is blocked due to overlarge content; and opening the files one by one, reading data from a single file, and reading the next file after the processing is finished.
2. Searching data:
the steps of manual searching are designed in a programming mode.
Single measurement data acquisition. In the case of a single file, the data content is first segmented, and the data is processed in segments in units of part numbers according to the fixed text. The data read step by step may relate to the data content split, the data integrity judgment is made for the part, and the subsequent processing is executed completely; and if the data content is not complete, the data content is spliced with the data content read in the next step, and then the subsequent processing is executed. In the case of multiple files, all data of one file can be read.
And (5) single measurement data formatting processing. The original data storage is stored in a table form, after the file is read, the data content is a long string of character strings, and the formatting processing is to restore the single measurement result from the character strings into a form of a two-dimensional array table according to the tabulation characters and the line feed characters so as to search the index conveniently.
And searching and indexing data at corresponding positions in the single measurement result two-dimensional data according to the required measurement items, wherein the single measurement result data is a one-dimensional array, and the multi-row data of the plurality of measurement items form the two-dimensional data.
3. Data statistics
And (4) forming a two-dimensional array by the name of the measurement item, the tolerance and the multiple measurement data according to the array, and completing data statistics.
4. Writing to files, file saving
Reading the report template, writing the statistical data into a file, storing the file additionally, and prompting the generation of a report.
Those of ordinary skill in the art will appreciate that the elements and method steps of the examples described in connection with the embodiments disclosed herein may be embodied in electronic hardware, computer software, or combinations of both, and that the components and steps of the examples have been described in a functional general in the foregoing description for the purpose of clearly illustrating the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
In the several embodiments provided in the present application, it should be understood that the disclosed method and system may be implemented in other ways. For example, the above described division of elements is merely a logical division, and other divisions may be realized, for example, multiple elements or components may be combined or integrated into another system, or some features may be omitted, or not executed. The units may or may not be physically separate, and components displayed as units may or may not be physical units, that is, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment of the present invention.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; such modifications and substitutions do not depart from the spirit and scope of the present invention, and they should be construed as being included in the following claims and description.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (6)
1. A three-coordinate measurement report automatic statistics method based on LabVIEW is characterized by comprising the following steps:
s1, analyzing the original measurement report, and counting a report template;
and S2, completing data statistics work by using LabVIEW software, reading a report template, writing the statistical data into a file, and generating a report.
2. The method for LabVIEW-based three-coordinate measurement report automatic statistics, according to claim 1, wherein the specific method of step S1 is as follows:
measuring items and template formats measured for multiple times in the original file data format are fixed, counting work reads items and test data at relatively fixed positions, and the data counting searching and reading processes are repeatedly programmable and automated;
the statistical report template is mainly used for counting detection results and comprises test items, positive tolerance, negative tolerance and measured data of each workpiece.
3. The method for LabVIEW-based three-coordinate measurement report automatic statistics, as claimed in claim 1, wherein the statistics work in step S2 includes reading files, finding data, data statistics, writing files, and saving files.
4. The method for LabVIEW-based three-coordinate measurement report auto-statistics, as claimed in claim 3, wherein: the method for reading the file comprises the following steps:
selecting a single file or a plurality of file paths according to the model of the three-coordinate measuring machine, and carrying out classification processing: judging the size of a single file, directly reading all data when the file is smaller than a certain threshold value, and reading the data when the file is larger than the threshold value, and reading the data in a segmented manner so as to avoid the situation that the processing is blocked due to overlarge content; and opening the files one by one, reading data from a single file, and reading the next file after the processing is finished.
5. The method for LabVIEW-based three-coordinate measurement report automatic statistics, according to claim 3, characterized in that the data searching method comprises:
carrying out programming design according to the manual searching step;
acquiring data of a single measurement result, segmenting data content under the condition of a single file, and processing the data in segments by taking the serial number of the part as a unit according to a fixed text;
formatting the single measurement data, and reducing the single measurement result into a form of a two-dimensional array table from a character string according to a tab character and a line feed character so as to search indexes conveniently;
and searching and indexing data at corresponding positions in the single measurement result two-dimensional data according to the required measurement items, wherein the single measurement result data is a one-dimensional array, and the multi-row data of the plurality of measurement items form the two-dimensional data.
6. The method for automatically counting LabVIEW-based three-coordinate measurement reports in claim 5, wherein the data counting method comprises the following steps:
and (4) forming a two-dimensional array by the name of the measurement item, the tolerance and the multiple measurement data according to the array, and completing data statistics.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011223888.7A CN112461176A (en) | 2020-11-05 | 2020-11-05 | Automatic statistical method for three-coordinate measurement report based on LabVIEW |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011223888.7A CN112461176A (en) | 2020-11-05 | 2020-11-05 | Automatic statistical method for three-coordinate measurement report based on LabVIEW |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112461176A true CN112461176A (en) | 2021-03-09 |
Family
ID=74825272
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011223888.7A Pending CN112461176A (en) | 2020-11-05 | 2020-11-05 | Automatic statistical method for three-coordinate measurement report based on LabVIEW |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112461176A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006234645A (en) * | 2005-02-25 | 2006-09-07 | Nikon Corp | Method of forming inspection report using display device, and device and program for forming inspection report |
| CN104375978A (en) * | 2014-11-21 | 2015-02-25 | 广东鸿图南通压铸有限公司 | Method for directly exporting measurement data to be shipment report |
| CN105424082A (en) * | 2015-11-03 | 2016-03-23 | 天津航天机电设备研究所 | Method for generating monitoring report of transport packaging case of spacecraft |
| CN108399198A (en) * | 2018-01-30 | 2018-08-14 | 北京智行鸿远汽车有限公司 | A kind of report-generating method and system based on LabVIEW attribute nodes |
| CN109408793A (en) * | 2018-11-05 | 2019-03-01 | 刘玉芳 | A kind of exchange method of CMM Data processing and information |
| CN109916350A (en) * | 2017-12-12 | 2019-06-21 | 深圳模德宝科技有限公司 | A kind of method, apparatus and terminal device generating three-dimensional coordinates measurement program |
-
2020
- 2020-11-05 CN CN202011223888.7A patent/CN112461176A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006234645A (en) * | 2005-02-25 | 2006-09-07 | Nikon Corp | Method of forming inspection report using display device, and device and program for forming inspection report |
| CN104375978A (en) * | 2014-11-21 | 2015-02-25 | 广东鸿图南通压铸有限公司 | Method for directly exporting measurement data to be shipment report |
| CN105424082A (en) * | 2015-11-03 | 2016-03-23 | 天津航天机电设备研究所 | Method for generating monitoring report of transport packaging case of spacecraft |
| CN109916350A (en) * | 2017-12-12 | 2019-06-21 | 深圳模德宝科技有限公司 | A kind of method, apparatus and terminal device generating three-dimensional coordinates measurement program |
| CN108399198A (en) * | 2018-01-30 | 2018-08-14 | 北京智行鸿远汽车有限公司 | A kind of report-generating method and system based on LabVIEW attribute nodes |
| CN109408793A (en) * | 2018-11-05 | 2019-03-01 | 刘玉芳 | A kind of exchange method of CMM Data processing and information |
Non-Patent Citations (1)
| Title |
|---|
| 张卫星 等: "基于LabVIEW的运动控制系统的研究", 《工业控制计算机》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101366020B (en) | Table detection in ink notes | |
| CN101655837B (en) | Method for detecting and correcting error on text after voice recognition | |
| CN109492106B (en) | Automatic classification method for defect reasons by combining text codes | |
| CN111027134A (en) | Method for realizing MBD-based inspection of aviation complex structural component | |
| CN111125116B (en) | Method and system for positioning code field in service table and corresponding code table | |
| CN109933578A (en) | A kind of configurable automated data detection method for quality and system | |
| CN108170468A (en) | The method and its system of a kind of automatic detection annotation and code consistency | |
| TWI698794B (en) | Auto-obtaining display equipment for guidance content of graphic data of patent document | |
| CN108416137B (en) | Method for conveniently dividing and tracking simplified expression standard part in aircraft manufacturing | |
| CN110991065B (en) | Automatic identification method for design change in building information model | |
| CN113190220A (en) | JSON file differentiation comparison method and device | |
| CN114357596B (en) | BIM component resource rapid design method and system | |
| CN109086985B (en) | Professional test information management system for spacecraft assembly | |
| CN112416732B (en) | Hidden Markov model-based data acquisition operation anomaly detection method | |
| CN112084302B (en) | Method, system, device and storage medium for detecting inventory data of cost file | |
| CN113837598A (en) | Information acquisition method based on intelligent manufacturing | |
| CN117808740A (en) | Method for generating three-dimensional detection element inspection sequence of part | |
| CN112461176A (en) | Automatic statistical method for three-coordinate measurement report based on LabVIEW | |
| CN106991050A (en) | A kind of static test null pointer dereference defect false positive recognition methods | |
| CN105701199B (en) | A kind of data quality checking method and device of data dependence | |
| Bartoli et al. | Semisupervised wrapper choice and generation for print-oriented documents | |
| CN112116314B (en) | Sample weighing data management system | |
| CN118053007B (en) | Standard content comparison display method and system based on big data | |
| CN116010663B (en) | TMT project map analysis and data analysis method and system | |
| CN117540894B (en) | Method, apparatus and storage medium for generating inspection plan |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210309 |
|
| RJ01 | Rejection of invention patent application after publication |