Body-in-white measurement data processing method and device, electronic equipment and storage medium

Abstract

The embodiment of the invention relates to the technical field of vehicles, and discloses a body-in-white measurement data processing method and device, electronic equipment and a storage medium. According to the embodiment of the invention, on the basis of the CSV format detection data output by the three-coordinate measuring machine, the CSV format detection data are in one-to-one correspondence with the element numbers for size measurement of the body-in-white, and the established vehicle model template is utilized to realize online systematic management of all the body-in-white and the size and precision measurement data of the corresponding measurement points. Therefore, at least the functions of body-in-white measurement point precision checking, multi-point deviation comparison, qualified rate calculation, trend management, backtracking and the like can be realized, the data form can be expanded, and the data processing efficiency can be improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of vehicles, in particular to a method and device for processing body-in-white measurement data, electronic equipment and storage medium. BACKGROUND

[0002] As a common body-in-white detection means, three-coordinate measurement has been widely used in commercial vehicle production process. However, the detection report of the existing three-coordinate measuring machine is mostly based on the template built by Excel, so the display form is limited. At the same time, the output of multiple reports is relatively independent, and the user wants to compare multiple reports horizontally, which needs to spend a lot of manpower and material resources for data analysis, and the data processing efficiency is low. SUMMARY

[0003] The purpose of the present application is to provide a method and device for processing body-in-white measurement data, electronic equipment and storage medium, to solve the technical problems of limited form and mutual independence of the detection report of the existing three-coordinate measuring machine, difficult to compare data horizontally, low data processing efficiency, and at least to realize the saving, processing and analysis of each three-coordinate measurement data of each body-in-white detection point of each vehicle type, which is beneficial to expand the data form and improve the data processing efficiency.

[0004] In order to solve the above technical problems, in the first aspect, the present application provides a method for processing body-in-white measurement data, at least comprising:

[0005] Formulate the measurement point naming rule and measurement point numbering rule of the body-in-white measurement point and mark the key detection points to generate at least one vehicle type template information table, and then create at least one new vehicle type template based on the vehicle type template information table and the corresponding vehicle type information;

[0006] Obtain the CSV file output by the three-coordinate measuring machine, and match the corresponding new vehicle type template based on the measuring machine information of the three-coordinate measuring machine, and then obtain the data value of each body-in-white measurement point according to the CSV file and the corresponding new vehicle type template;

[0007] According to the data value of each body-in-white measurement point and the key size identification in the corresponding new vehicle type template, at least the full size pass rate and the key size pass rate are calculated, and the method related data is uploaded to the management database.

[0008] Optionally, the formulation of the measurement point naming rule and the measurement point numbering rule of the body-in-white measurement point at least comprises:

[0009] According to the vehicle structure characteristics and the measurement point function characteristics corresponding to each body-in-white measurement point, the measurement point naming rule is formulated;

[0010] The measurement point numbering rule is formulated according to the size characteristics and sequence order of each body-in-white measurement point.

[0011] Optionally, the full-size qualification rate refers at least to the ratio of the number of qualified body-in-white measurement points to the total number of body-in-white measurement points.

[0012] The key dimension qualification rate refers at least to the ratio of the number of qualified key detection points to the total number of key detection points.

[0013] Optionally, the data value of the body-in-white measurement point includes at least a theoretical value, a measured value, a tolerance value, a deviation value, and an out-of-tolerance value.

[0014] The full-size qualification rate and the key dimension qualification rate are calculated according to the data value of each body-in-white measurement point and the key dimension identifier in the corresponding new vehicle model template, and at least include:

[0015] The measurement point type of each body-in-white measurement point is determined.

[0016] If the measurement point type of any body-in-white measurement point is a hole type, the weight of the corresponding hole type measurement point is assigned as 3, and the hole type measurement point is equivalently split into three point type measurement points to calculate the number of unqualified point type measurement points.

[0017] If the measurement point type of any body-in-white measurement point is a point type, the weight of the corresponding point type measurement point is assigned as 1.

[0018] The number of unqualified point type measurement points is accumulated according to the out-of-tolerance value of each point type measurement point.

[0019] The number of hole type measurement points and the number of point type measurement points are obtained.

[0020] The full-size qualification rate is calculated according to the number of hole type measurement points, the number of point type measurement points, the weight of hole type measurement points, the weight of point type measurement points, and the number of unqualified point type measurement points.

[0021] Optionally, the data value of the key detection point includes at least a theoretical value, a measured value, a tolerance value, a deviation value, and an out-of-tolerance value.

[0022] The full-size qualification rate and the key dimension qualification rate are calculated according to the data value of each body-in-white measurement point and the key dimension identifier in the corresponding new vehicle model template, and at least include:

[0023] The measurement point type of each key detection point is determined.

[0024] If the type of any of the key detection points is a hole type, the weight of the corresponding hole type key detection point is assigned as 3, and the hole type key detection point is equivalently split into 3 point type key detection points to calculate the unqualified number of the point type key detection point;

[0025] If the type of any of the key detection points is a point type, the weight of the corresponding point type key detection point is assigned as 1.

[0026] The unqualified number of each point type key detection point is counted according to the cumulative count of the out-of-tolerance value of the point type key detection point.

[0027] The number of the hole type key detection points and the number of the point type key detection points are obtained.

[0028] According to the number of the hole type key detection points, the number of the point type key detection points, the weight of the hole type key detection point, the weight of the point type key detection point, and the unqualified number of the point type key detection point, the key dimension qualification rate is calculated.

[0029] Optionally, after obtaining the CSV file output by the coordinate measuring machine and matching the corresponding new vehicle model template based on the measuring machine information of the coordinate measuring machine, and then obtaining the data value of each body-in-white detection point according to the CSV file and the corresponding new vehicle model template, the method further comprises:

[0030] At least one group of detection point related dimensions and related dimension qualification rates are calculated according to the data values of all the body-in-white detection points, and the related dimension qualification rates and each detection point related dimension are uploaded to the management database.

[0031] The related dimension qualification rate is used to at least represent the relative size relationship between a plurality of body-in-white detection points.

[0032] Optionally, after obtaining the CSV file output by the coordinate measuring machine and matching the corresponding new vehicle model template based on the measuring machine information of the coordinate measuring machine, and then obtaining the data value of each body-in-white detection point according to the CSV file and the corresponding new vehicle model template, the method further comprises:

[0033] At least a detection point change trend chart, a cross-vehicle model same detection point joint display chart, a body-in-white 3D point cloud image, and / or a related dimension state chart are generated according to the data values of all the body-in-white detection points.

[0034] Based on the same concept, in a second aspect, the present application further provides a body-in-white measurement data processing device, which at least comprises:

[0035] The template creation module is configured to formulate a measurement point naming rule and a measurement point numbering rule of the body-in-white measurement points, mark key detection points, and generate at least one vehicle model template information table, so as to complete the creation of at least one new vehicle model template based on at least the vehicle model template information table and corresponding vehicle model information;

[0036] The data value determination module is configured to obtain a CSV file output by the coordinate measuring machine, match the corresponding new vehicle model template based on the measuring machine information of the coordinate measuring machine, and obtain the data value of each body-in-white measurement point according to the CSV file and the corresponding new vehicle model template.

[0037] The first calculation uploading module is configured to calculate at least the full-size qualification rate and the key size qualification rate according to the data value of each body-in-white measurement point and the key size identifier in the corresponding new vehicle model template, and upload all method-related data to the management database.

[0038] Based on the same concept, in a third aspect, the present application further provides an electronic device comprising a memory and a processor, wherein the memory stores a computer program capable of running on the processor, and wherein the processor implements the steps of the white body measurement data processing method of any one of the first aspect when executing the program.

[0039] Based on the same concept, in a fourth aspect, the present application further provides a computer readable storage medium having a computer program stored thereon, wherein the computer program is executed by a processor to implement the steps of the white body measurement data processing method of any one of the first aspect.

[0040] The technical solution provided by the embodiment of the present application firstly formulates a measurement point naming rule and a measurement point numbering rule of the body-in-white measurement points, marks key detection points, and generates at least one vehicle model template information table, so as to complete the creation of at least one new vehicle model template based on at least the vehicle model template information table and corresponding vehicle model information; then, obtains a CSV file output by the coordinate measuring machine, matches the corresponding new vehicle model template based on the measuring machine information of the coordinate measuring machine, and obtains the data value of each body-in-white measurement point according to the CSV file and the corresponding new vehicle model template; finally, calculates at least the full-size qualification rate and the key size qualification rate according to the data value of each body-in-white measurement point and the key size identifier in the corresponding new vehicle model template, and uploads all method-related data to the management database.

[0041] It can be seen that, based on the CSV format detection data output by the three-coordinate measuring machine, the embodiment of the application one-to-one corresponds the detection data with the element number of the body-in-white size measurement, and realizes the online systematic management of all the body-in-white under production and the corresponding measurement point size and precision measurement data by using the created vehicle model template, and further at least realizes the functions of body-in-white measurement point precision viewing, multi-point deviation comparison, qualified rate calculation, trend management and backtracking, which is beneficial to expand data forms and improve data processing efficiency. BRIEF DESCRIPTION OF DRAWINGS

[0042] Figure 1 is a flow chart of a body-in-white measurement data processing method provided by the embodiment of the application;

[0043] Figure 2 is a flow chart of another body-in-white measurement data processing method provided by the embodiment of the application;

[0044] Figure 3 is a measurement point change trend chart provided by the embodiment of the application;

[0045] Figure 4 is a body-in-white 3D point cloud image schematic diagram provided by the embodiment of the application;

[0046] Figure 5 is a structural schematic diagram of a body-in-white measurement data processing device provided by the embodiment of the application;

[0047] Figure 6 is a structural schematic diagram of an electronic device provided by the embodiment of the application. DETAILED DESCRIPTION

[0048] In order to make the purposes, technical solutions and advantages of the present application clearer, the present application will be further described in detail below with the accompanying drawings. Obviously, the described embodiments are only some of the embodiments of the present application, but not all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative work fall within the scope of protection of the present application.

[0049] The terms used in the embodiments of the present application are only for the purpose of describing the specific embodiments, and are not intended to limit the present application. The singular forms "a", "an" and "the" used in the embodiments of the present application and the appended claims are also intended to include the plural forms, unless the context clearly indicates otherwise. "Multiple" generally includes at least two.

[0050] It should be understood that the term "and / or" as used herein merely describes an associated relationship among associated objects, and indicates that there can be three relationships, for example, A and / or B, which can represent three cases of A existing alone, A and B existing simultaneously, and B existing alone. In addition, the character " / " herein generally represents an "or" relationship between the front and rear associated objects.

[0051] It should be understood that although the terms first, second, third, etc. can be used in embodiments of the present application to describe various elements, these descriptions are not intended to be limiting. These terms are only used to distinguish one element from another. For example, a first can be termed a second, and, similarly, a second can be termed a first, without departing from the scope of the embodiments of the present application.

[0052] Depending on the context, the word "if" as used herein can be interpreted as meaning "when" or "upon" or "in response to determining" or "in response to detecting." Similarly, depending on the context, the phrase "if it is determined" or "if [a stated condition or event] is detected" can be interpreted as meaning "when it is determined" or "in response to determining" or "when [a stated condition or event] is detected" or "in response to detecting [a stated condition or event]."

[0053] It should also be noted that the terms "comprising," "including," or any other variation thereof are intended to cover a non-exclusive inclusion, such that a product or process that comprises a list of elements does not include only those elements but can also include other elements not expressly listed or inherent to such product or process. Without more limitations, an element defined by the phrase "comprising a" does not exclude the existence of additional identical elements in the product or process that includes the element.

[0054] It should be particularly noted that the symbols and / or numbers present in the specification, if not marked in the description of the drawings, are not drawing reference numbers.

[0055] Figure 1 is a flowchart of a body-in-white measurement data processing method provided by an embodiment of the present application. The present embodiment is applicable to body-in-white data measurement, processing and analysis scenarios of various vehicles, especially commercial vehicles. The body-in-white measurement data processing method can be executed by a body-in-white measurement data processing device in the embodiment of the present application as an execution subject, and the execution subject can be realized in the form of software and / or hardware. As shown in the figure, the body-in-white measurement data processing method at least includes the following steps: Figure 1

[0056] ​S1, formulating a measurement point naming rule and a measurement point numbering rule of the body-in-white measurement points and marking key detection points to generate at least one vehicle model template information table, and then creating at least one new vehicle model template based on at least the vehicle model template information table and corresponding vehicle model information.

[0057] The key detection points can be measurement points of the body-in-white which are focused on, and whether a measurement point is a key point can be marked by "yes" or "no" for subsequent calculation of a key dimension qualification rate.

[0058] In a specific embodiment, the measurement point naming rule and the measurement point numbering rule of the body-in-white measurement points can be formulated, at least including:

[0059] (1-1) Formulating a measurement point naming rule according to a vehicle structure feature and a measurement point function feature corresponding to each body-in-white measurement point.

[0060] (1-2) Formulating a measurement point numbering rule according to a size feature and a sequence order of each body-in-white measurement point.

[0061] Specifically, to achieve quick retrieval of the required body-in-white measurement points, the naming of any measurement point can be achieved by adding the function of the measurement point (such as positioning, assembly, etc., corresponding to the aforementioned measurement point function feature) to the structure where the measurement point is located (such as the front outer panel, etc., corresponding to the aforementioned vehicle structure feature). In addition, through system configuration, the three-coordinate measuring machine can automatically generate a measurement point number with a unified format (i.e., "size position", for example, size feature + sequence order number) and uniqueness in the report during the detection process.

[0062] It can be understood that for a new vehicle model, the relevant information of the body-in-white measurement points of the vehicle model needs to be uploaded first before the three-coordinate detection data is uploaded for the first time. To achieve quick entry of vehicle model measurement point information, the inventors designed a vehicle model template information Excel table (i.e., the aforementioned vehicle model template information table) as shown in Table 1. Through data conversion batch processing commands, the quick acquisition of new vehicle model measurement point naming is achieved in the form of original file fixed column grabbing, and then the vehicle model template information Excel table is generated based on the related contents of measurement point naming, measurement point numbering, and key detection point identification. Subsequently, by creating a new template, inputting the platform and vehicle model code (i.e., the aforementioned vehicle model information) to which the new vehicle model belongs, and uploading the template information Excel table corresponding to the vehicle model as an attachment, the template creation of the new vehicle model can be completed.

[0063] Table 1

[0064]

[0065] S2, acquire the CSV file output by the coordinate measuring machine, and match the corresponding new vehicle model template based on the measuring machine information of the coordinate measuring machine, and then obtain the data value of each body-in-white measuring point according to the CSV file and the corresponding new vehicle model template.

[0066] Wherein, when uploading the CSV file output by the coordinate measuring machine, the CSV file to be uploaded needs to be named and processed, such as in the format of "platform-vehicle-body-in-white stamp number-inspector-inspection time". After uploading the CSV file, the platform, vehicle, body-in-white stamp number, inspector and inspection time information can be obtained by parsing the file name with "-" as the interval in the background and displayed on the page. At the same time, the existing or newly created vehicle model template can be automatically matched according to the coordinate measuring machine "platform-vehicle" information (i.e. the aforementioned measuring machine information), and then the corresponding body-in-white measuring point in the CSV file is obtained in the form of one-to-one correspondence of two file size numbers, and then the data obtained is used to calculate the overall size pass rate and the key size pass rate according to the key size marks in the vehicle model template, and then stored in the system database for easy calling later.

[0067] More specifically, after the backend drf framework receives the uploaded CSV format detection report and the vehicle model to which the report belongs (each uploaded detection report contains all detection data of a body-in-white vehicle, body-in-white stamp number, detection time, etc.), the data in the CSV file can be extracted by pandas (for example, pandas first reads the data in the CSV file as a dataframe object, and then performs cleaning operations on the data in the dataframe to remove table headers, blank rows, other non-measurement data, etc. in the detection report, and structured operations to convert data that is not originally a standard two-dimensional structure into a standard two-dimensional structure corresponding to the database table structure through splitting and merging operations, etc.). After extracting the detection data, the detection data is stored in the mysql database (the detection report data is stored in the detection record and the detection data is stored in two tables respectively). After uploading a detection report, the detection record table will correspondingly increase a data, which contains the vehicle model to which the detected body-in-white belongs, the detection time, the body-in-white stamp number, the uploading personnel, etc. The detection data table increases hundreds of detection data according to the detection points, each data contains the number of each detection point, whether it is a key point, the reference value of the xyz three directions of the detection point, the measured value, etc. Each detection data is bound to a corresponding detection record data (i.e. the data of the two tables can be bound by foreign key association in the database).

[0068] S3, according to the data value of each body-in-white measuring point and the key size mark in the corresponding new vehicle model template, at least the overall size pass rate and the key size pass rate are calculated, and the method related data is uploaded to the management database.

[0069] wherein the critical dimension identifier is the aforementioned "yes" or "no".

[0070] In another specific embodiment, optionally, the full dimension pass rate at least refers to the ratio of the number of the body-in-white measurement points passing the test to the total number of the body-in-white measurement points; and the critical dimension pass rate at least refers to the ratio of the number of the critical measurement points passing the test to the total number of the critical measurement points.

[0071] In yet another specific embodiment, optionally, the data value of the body-in-white measurement point at least includes a theoretical value, a measured value, a tolerance value, a deviation value and an out-of-tolerance value.

[0072] According to the data value of each body-in-white measurement point and the critical dimension identifier in the template of the new vehicle model, at least the full dimension pass rate and the critical dimension pass rate are calculated, at least including:

[0073] (3-1-1) Determine the measurement point type of each body-in-white measurement point.

[0074] (3-1-2) If the measurement point type of any body-in-white measurement point is a hole type (such as a round hole, a slot hole, a square hole, etc.), the weight of the corresponding hole type measurement point is assigned as 3, and the hole type measurement point is equivalent to be split into 3 point type measurement points to calculate the number of unqualified point type measurement points.

[0075] (3-1-3) If the measurement point type of any body-in-white measurement point is a point type, the weight of the corresponding point type measurement point is assigned as 1.

[0076] (3-1-4) According to the out-of-tolerance value of each point type measurement point, the number of unqualified point type measurement points is accumulated (i.e. for each point type measurement point with an out-of-tolerance value, the number of unqualified point type measurement points is increased by one, and the accumulation is carried out one by one).

[0077] (3-1-5) Obtain the number of hole type measurement points and the number of point type measurement points.

[0078] (3-1-6) According to the number of hole type measurement points, the number of point type measurement points, the weight of hole type measurement points, the weight of point type measurement points and the number of unqualified point type measurement points, the full dimension pass rate is calculated.

[0079] It can be understood that the full dimension pass rate is calculated by the following method:

[0080] Q = 1 - n / (ab + cd);

[0081] In the formula, Q represents the full dimension pass rate, n represents the number of unqualified point type measurement points, a represents the number of hole type measurement points, b represents the weight of hole type measurement points, c represents the number of point type measurement points, and d represents the weight of point type measurement points; b = 3 and d = 1.

[0082] In another specific embodiment, the data value of the key detection point comprises at least the theoretical value, the measured value, the tolerance value, the deviation value and the out-of-tolerance value.

[0083] According to the data value of each bodywork detection point and the key dimension identifier in the corresponding new vehicle model template, at least the full-size qualification rate and the key dimension qualification rate are calculated, at least comprising:

[0084] (3-2-1) Determine the detection point type of each key detection point.

[0085] (3-2-2) If the detection point type of any key detection point is a hole type, the weight of the corresponding hole type key detection point is assigned as 3, and the hole type key detection point is equivalent to split into three point type key detection points to calculate the unqualified number of point type key detection points.

[0086] (3-2-3) If the detection point type of any key detection point is a point type, the weight of the corresponding point type key detection point is assigned as 1.

[0087] (3-2-4) According to the out-of-tolerance value of each point type key detection point, the unqualified number of point type key detection points is accumulated.

[0088] (3-2-5) Obtain the number of hole type key detection points and the number of point type key detection points.

[0089] (3-2-6) According to the number of hole type key detection points, the number of point type key detection points, the weight of hole type key detection points, the weight of point type key detection points and the unqualified number of point type key detection points, the key dimension qualification rate is calculated.

[0090] It can be understood that the key dimension qualification rate is calculated by the following method:

[0091] P=1-m / (ef+gh);

[0092] In the formula, P represents the key dimension qualification rate, m represents the unqualified number of point type key detection points, e represents the number of hole type key detection points, f represents the weight of hole type key detection points, g represents the number of point type key detection points, and h represents the weight of point type key detection points; f=3, h=1.

[0093] The technical scheme provided by the embodiment first formulates a measurement point naming rule and a measurement point numbering rule of a body-in-white measurement point and marks key detection points to generate at least one vehicle model template information table, and then at least creates at least one new vehicle model template based on the vehicle model template information table and corresponding vehicle model information; then, a CSV file output by a three-coordinate measuring machine is acquired, and corresponding new vehicle model templates are matched based on measuring machine information of the three-coordinate measuring machine, and then data values of each body-in-white measurement point are obtained according to the CSV file and the corresponding new vehicle model templates; finally, at least a full-size qualification rate and a key size qualification rate are calculated according to the data values of each body-in-white measurement point and key size identifiers in the corresponding new vehicle model templates, and all method-related data is uploaded to a management database.

[0094] It can be seen that, based on the CSV format detection data output by the three-coordinate measuring machine, the embodiment one-to-one corresponds the CSV format detection data to the element number of the body-in-white size measurement, realizes online system management of all in-process body-in-white and corresponding measurement point size and precision measurement data by using the created vehicle model template, and can at least realize body-in-white measurement point precision viewing, multi-point deviation comparison, qualification rate calculation, trend management and backtracking, which is beneficial to expand data forms and improve data processing efficiency.

[0095] It should be noted that, based on the scheme of the foregoing embodiments or implementation manners, in another specific implementation manner, after acquiring the CSV file output by the three-coordinate measuring machine, matching corresponding new vehicle model templates based on the measuring machine information of the three-coordinate measuring machine, and then obtaining data values of each body-in-white measurement point according to the CSV file and the corresponding new vehicle model templates, the scheme further includes:

[0096] At least one group of measurement point related sizes and related size qualification rates are calculated according to the data values of all body-in-white measurement points, and the related size qualification rates and each measurement point related size are uploaded to a management database.

[0097] The related size qualification rate is at least used to represent a relative size relationship between the plurality of body-in-white measurement points.

[0098] In another specific implementation manner, after acquiring the CSV file output by the three-coordinate measuring machine, matching corresponding new vehicle model templates based on the measuring machine information of the three-coordinate measuring machine, and then obtaining data values of each body-in-white measurement point according to the CSV file and the corresponding new vehicle model templates, the scheme further includes:

[0099] A measurement point change trend chart, a cross-vehicle model same measurement point joint display chart, a body-in-white 3D point cloud image and / or a related size state chart are generated according to the data values of all body-in-white measurement points.

[0100] Therefore, Figure 2is a flowchart of another white body measurement data processing method provided by the embodiment of the present application, as shown in Figure 2 The white body measurement data processing method at least includes the following steps:

[0101] S1, formulating a measurement point naming rule and a measurement point numbering rule of a white body measurement point and marking key detection points to generate at least one vehicle model template information table, and then creating at least one new vehicle model template based on the vehicle model template information table and corresponding vehicle model information.

[0102] S2, obtaining a CSV file output by a three-coordinate measuring machine, and matching a corresponding new vehicle model template based on the measuring machine information of the three-coordinate measuring machine, and then obtaining the data value of each white body measurement point according to the CSV file and the corresponding new vehicle model template.

[0103] S4, calculating at least one group of measurement point related dimensions and related dimension qualification rates according to the data values of all white body measurement points, and uploading the related dimension qualification rates and each measurement point related dimension to a management database.

[0104] Among them, the change trend of the related dimensions of the selected measurement points can be viewed by selecting multiple associated measurement points, for example, the change trend comparison of 8 measurement points can be realized, that is, the recent 8 parts change trends of the selected measurement points are displayed by default from the X, Y and Z three dimensions, thereby the analysis of the complex structure of the multi-level dimension chain can be realized, and the data sample capacity can be adaptively changed through data filtering. This function can realize the display of the change trend of multiple vehicle models and multiple points by combining the following cross-vehicle model same structure change trend calculation.

[0105] S5, generating at least a measurement point change trend chart, a cross-vehicle model same measurement point joint display chart, a white body 3D point cloud image and / or a related dimension state chart according to the data values of all white body measurement points.

[0106] Among them, the measurement point change trend chart can view the specific information of any measurement point, including the measurement point number, the measurement point name, the reference value and the measured value of the X, Y and Z three directions and the change trend. Specifically, Figure 3 is a measurement point change trend chart provided by the embodiment of the present application, as shown in Figure 3 The recent 25 parts measurement results can be displayed by default, including the change trend of the measurement point in the X, Y and Z three directions; the change trend of the measurement point in the detection structure of a specific time or a specific batch can also be viewed by filtering.

[0107] In the actual production process, the inventor found that the new vehicle model has less detection data at the initial stage, and the data change trend fluctuates greatly, which is not persuasive and is not conducive to the normal development of matching work. In order to overcome the problem of less data caused by the difficulty of measuring the new vehicle model at the early stage, and improve the reliability of the analysis result, the inventor uses the method of comparing the same structure and the same measuring point of multiple vehicle models together on the same platform to effectively solve the problem, realize reliable analysis of the change trend of the structure, and thus predict the change trend of the measuring point on the new vehicle model, and assist the normal development of subsequent matching work.

[0108] In addition, the white body 3D point cloud image can be based on Echarts webGL technology, and 3 types of data models can be constructed independently through vehicle classification, and the 3D point cloud image of the corresponding vehicle model is displayed according to each model. Figure 4 is a white body 3D point cloud image provided by an embodiment of the present application, which is described as follows Figure 4 The 3D data model can be created based on the reference values of the X, Y and Z directions of each measuring point, and the contour of the white body can be completely displayed, and the required measuring point can be quickly found through scaling and rotating. The user can view the name and reference value of the measuring point by hovering the mouse pointer over the measuring point, and click to view the specific change trend.

[0109] S3, according to the data value of each white body measuring point and the key size identifier in the corresponding new vehicle model template, at least the full size qualification rate and the key size qualification rate are calculated, and the method related data is uploaded to the management database.

[0110] In summary, the present embodiment can realize the saving analysis and display of each three-coordinate measurement data of each detection point of multiple vehicle models; all detection data contained in a single report will be stored as source data in the database for subsequent traceability; after uploading the detection report, the detection report can be quickly analyzed, including qualification rate calculation, output of single point or multi-point change trend combined with past reports, generation of 3D point cloud view based on reference value and measured value, etc. No personnel working hours are occupied, and errors that may occur in the process of manual operation are avoided. At the same time, the display and review form is more simple and intuitive than the previous Excel.

[0111] Figure 5It is a structural schematic diagram of a body-in-white measurement data processing device provided by an embodiment of the present application. The embodiment is at least applicable to a body-in-white data measurement, processing and analysis scene of various vehicles, especially commercial vehicles. The body-in-white measurement data processing device can be realized in a software and / or hardware manner. As shown in the figure, the body-in-white measurement data processing device at least includes: Figure 5

[0112] A template creation module 110 is configured to formulate a measurement point naming rule and a measurement point numbering rule of the body-in-white measurement points and mark key detection points, so as to generate at least one vehicle model template information table, and then complete creation of at least one new vehicle model template based on the vehicle model template information table and corresponding vehicle model information.

[0113] A data value determination module 120 is configured to acquire a CSV file output by a three-coordinate measuring machine, match a corresponding new vehicle model template based on measuring machine information of the three-coordinate measuring machine, and then obtain a data value of each body-in-white measurement point according to the CSV file and the corresponding new vehicle model template.

[0114] A first calculation and uploading module 130 is configured to calculate at least a full-size pass rate and a key size pass rate according to the data value of each body-in-white measurement point and a key size identifier in the corresponding new vehicle model template, and upload all method-related data to a management database.

[0115] Optionally, the template creation module 110 is at least specifically configured to:

[0116] formulate a measurement point naming rule according to a vehicle structure feature and a measurement point function feature corresponding to each body-in-white measurement point;

[0117] formulate a measurement point numbering rule according to a size feature and a sequence order of each body-in-white measurement point.

[0118] Optionally, the full-size pass rate at least refers to a ratio of a number of qualified body-in-white measurement points to a total number of body-in-white measurement points.

[0119] The key size pass rate at least refers to a ratio of a number of qualified key detection points to a total number of key detection points.

[0120] Optionally, the data value of the body-in-white measurement point at least includes a theoretical value, a measured value, a tolerance value, a deviation value and an out-of-tolerance value.

[0121] The first calculation and uploading module 130 is at least specifically configured to:

[0122] determine a measurement point type of each body-in-white measurement point;

[0123] if the measurement point type of any body-in-white measurement point is a hole type, the weight of the corresponding hole type measurement point is valued as 3, and the hole type measurement point is equivalently split into three point type measurement points to calculate a number of unqualified point type measurement points.​

[0124] If the point type of any body-in-white measuring point is a hole type, the weight of the corresponding hole type measuring point is assigned as 1;

[0125] The unqualified number of the point type measuring point is counted according to the out-of-tolerance value of each point type measuring point;

[0126] The number of the hole type measuring point and the number of the point type measuring point are obtained;

[0127] The full-size qualified rate is calculated according to the number of the hole type measuring point, the number of the point type measuring point, the weight of the hole type measuring point, the weight of the point type measuring point, and the unqualified number of the point type measuring point.

[0128] Optionally, the data value of the key detection point at least includes a theoretical value, a measured value, a tolerance value, a deviation value, and an out-of-tolerance value;

[0129] The first calculation uploading module 130 is at least specifically used for:

[0130] The point type of each key detection point is judged;

[0131] If the point type of any key detection point is a hole type, the weight of the corresponding hole type key measuring point is assigned as 3, and the hole type key measuring point is equivalently split into three point type key measuring points to count the unqualified number of the point type key measuring point;

[0132] If the point type of any key detection point is a point type, the weight of the corresponding point type key measuring point is assigned as 1;

[0133] The unqualified number of the point type key measuring point is counted according to the out-of-tolerance value of each point type key measuring point;

[0134] The number of the hole type key measuring point and the number of the point type key measuring point are obtained;

[0135] The key size qualified rate is calculated according to the number of the hole type key measuring point, the number of the point type key measuring point, the weight of the hole type key measuring point, the weight of the point type key measuring point, and the unqualified number of the point type key measuring point.

[0136] Optionally, the method further comprises:

[0137] The second calculation uploading module 140 is used for calculating at least one group of measuring point related sizes and related size qualified rates according to the data values of all body-in-white measuring points, and uploading the related size qualified rates and each measuring point related size to the management database;

[0138] The related size qualified rate is at least used for representing the relative size relationship between the plurality of body-in-white measuring points.

[0139] Optionally, the method further comprises:

[0140] The image generation module 150 is configured to generate at least a measurement point change trend chart, a same measurement point joint display chart across vehicle models, a white vehicle body 3D point cloud image and / or a related size state chart according to the data values of all the white vehicle body measurement points.

[0141] The technical scheme provided by the embodiment first formulates the measurement point naming rule and the measurement point numbering rule of the white vehicle body measurement points and marks the key detection points by the template creation module to generate at least one vehicle model template information table, and then completes the creation of at least one new vehicle model template based on at least the vehicle model template information table and the corresponding vehicle model information; then, the data value determination module obtains the CSV file output by the three-coordinate measuring machine, and matches the corresponding new vehicle model template based on the measuring machine information of the three-coordinate measuring machine, and then obtains the data value of each white vehicle body measurement point according to the CSV file and the corresponding new vehicle model template; finally, the first calculation uploading module calculates at least the full-size qualification rate and the key size qualification rate according to the data value of each white vehicle body measurement point and the key size identifier in the corresponding new vehicle model template, and uploads all the method related data to the management database.

[0142] Therefore, it can be seen that on the basis of the CSV format detection data output by the three-coordinate measuring machine, the embodiment one-to-one corresponds the CSV format detection data to the element number of the white vehicle body size measurement, realizes the online systematized management of all the in-process white vehicle body and the corresponding measurement point size and precision measurement data by using the created vehicle model template, and can at least realize the white vehicle body measurement point precision viewing, multi-point deviation comparison, qualification rate calculation, trend management and backtracking functions, which is beneficial to expand the data form and improve the data processing efficiency.

[0143] The embodiment provides an electronic device, Figure 6 is a structural schematic diagram of an electronic device provided by the embodiment of the present application, referring to Figure 6The electronic device 1000 comprises a processor 1001 and a memory 1002, and the memory 1002 stores computer readable instructions, when the computer readable instructions are executed by the processor 1001, the steps in the body-in-white measurement data processing method of any one of the above are executed. Through the above technical solution, the processor 1001 and the memory 1002 are interconnected and communicate with each other through a communication bus and / or other forms of connection mechanism (not marked), the memory 1002 stores a computer program executable by the processor, when the electronic device 1000 is running, the processor 1001 executes the computer program to execute the body-in-white measurement data processing method in any optional implementation manner of the above embodiment, to at least implement the following functions: formulating a measurement point naming rule and a measurement point numbering rule of a body-in-white measurement point and marking a key detection point, to generate at least one vehicle model template information table, and then completing creation of at least one new vehicle model template based on at least the vehicle model template information table and corresponding vehicle model information; acquiring a CSV file output by a three-coordinate measuring machine, and matching a corresponding new vehicle model template based on measuring machine information of the three-coordinate measuring machine, and then obtaining a data value of each body-in-white measurement point according to the CSV file and the corresponding new vehicle model template; calculating at least a full-size pass rate and a key size pass rate according to the data value of each body-in-white measurement point and a key size identifier in the corresponding new vehicle model template, and uploading all method related data to a management database.

[0144] The embodiment provides a computer readable storage medium, which stores a computer program, and the program is executed by a processor to implement the body-in-white measurement data processing method provided by all the application embodiments: formulating a measurement point naming rule and a measurement point numbering rule of a body-in-white measurement point and marking a key detection point, to generate at least one vehicle model template information table, and then completing creation of at least one new vehicle model template based on at least the vehicle model template information table and corresponding vehicle model information; acquiring a CSV file output by a three-coordinate measuring machine, and matching a corresponding new vehicle model template based on measuring machine information of the three-coordinate measuring machine, and then obtaining a data value of each body-in-white measurement point according to the CSV file and the corresponding new vehicle model template; calculating at least a full-size pass rate and a key size pass rate according to the data value of each body-in-white measurement point and a key size identifier in the corresponding new vehicle model template, and uploading all method related data to a management database.

[0145] Any combination of one or more computer readable medium can be utilized. The computer readable medium can be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium include an electrical connection having one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium can be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

[0146] A computer readable signal medium can include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated signal can take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium can be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

[0147] Program code embodied on a computer readable medium can be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

[0148] Computer program code for carrying out operations of the present application can be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C++ or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code can execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection can be made to an external computer (for example, through the Internet using an Internet Service Provider). In an embodiment, the present application is directed to computer program products comprising machine-readable media for carrying or having machine-executable instructions or programs

[0149] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present application, and are not intended to limit the present application; although the present application has been described in detail with reference to the above embodiments, those skilled in the art should understand that the technical solutions recorded in the above embodiments can be modified, or some or all of the technical features can be replaced by equivalents; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the scope of the technical solutions of the embodiments of the present application.

Claims

1. A method of processing body-in-white measurement data, characterized by, At least comprising: Formulate the measurement point naming rules and measurement point numbering rules of the body-in-white measurement points, mark the key detection points, and generate at least one vehicle model template information table, and then create at least one new vehicle model template based on the vehicle model template information table and the corresponding vehicle model information; Obtain the CSV file output by the three-coordinate measuring machine, and match the corresponding new vehicle model template based on the measuring machine information of the three-coordinate measuring machine, and then obtain the data value of each body-in-white measurement point according to the CSV file and the corresponding new vehicle model template; According to the data value of each body-in-white measurement point and the key size identification in the corresponding new vehicle model template, at least the full-size qualification rate and the key size qualification rate are calculated, and all method related data are uploaded to the management database.

2. The method of processing body-in-white measurement data according to claim 1, wherein, The measurement point naming rules and measurement point numbering rules of the body-in-white measurement points at least comprise: Formulate the measurement point naming rules according to the vehicle structure characteristics and measurement point function characteristics corresponding to each body-in-white measurement point; Formulate the measurement point numbering rules according to the size characteristics and sequence order of each body-in-white measurement point.

3. The method of processing body-in-white measurement data according to claim 1, wherein, The full-size qualification rate at least refers to the ratio of the number of qualified body-in-white measurement points to the total number of body-in-white measurement points; The key size qualification rate at least refers to the ratio of the number of qualified key detection points to the total number of key detection points.

4. The method of processing body-in-white measurement data according to claim 1, wherein, The data value of the body-in-white measurement point at least includes theoretical value, measured value, tolerance value, deviation value and out-of-tolerance value; According to the data value of each body-in-white measurement point and the key size identification in the corresponding new vehicle model template, at least the full-size qualification rate and the key size qualification rate are calculated, at least comprising: Determine the measurement point type of each body-in-white measurement point; If the measurement point type of any body-in-white measurement point is a hole type, the weight of the corresponding hole type measurement point is assigned as 3, and the hole type measurement point is equivalent to be split into 3 point type measurement points to calculate the unqualified number of point type measurement points; If the measurement point type of any body-in-white measurement point is a point type, the weight of the corresponding point type measurement point is assigned as 1; According to the out-of-tolerance value of each point type measurement point, the unqualified number of point type measurement points is accumulated and counted; Obtain the number of hole type measurement points and the number of point type measurement points; According to the number of hole type measurement points, the number of point type measurement points, the weight of hole type measurement points, the weight of point type measurement points and the unqualified number of point type measurement points, the full-size qualification rate is calculated.

5. The method of processing body-in-white measurement data according to claim 1, wherein, The data value of the key detection point at least includes theoretical value, measured value, tolerance value, deviation value and out-of-tolerance value; According to the data value of each body-in-white measurement point and the key size identification in the corresponding new vehicle model template, at least the full-size qualification rate and the key size qualification rate are calculated, at least comprising: Determine the measurement point type of each key detection point; If the measurement point type of any key detection point is a hole type, the weight of the corresponding hole type key measurement point is assigned as 3, and the hole type key measurement point is equivalent to be split into 3 point type key measurement points to calculate the unqualified number of point type key measurement points; If the point type of any of the key detection points is a point type, the weight of the corresponding point type key detection point is assigned as 1; The number of unqualified points of the point type key detection point is counted according to the out-of-tolerance value of each point type key detection point; The number of the hole type key detection points and the number of the point type key detection points are obtained; The key dimension qualification rate is calculated according to the number of the hole type key detection points, the number of the point type key detection points, the weight of the hole type key detection point, the weight of the point type key detection point, and the number of unqualified points of the point type key detection point.

6. The method of processing body-in-white measurement data according to claim 1, wherein, After obtaining the CSV file output by the three-coordinate measuring machine and matching the corresponding new vehicle model template based on the measuring machine information of the three-coordinate measuring machine, and then obtaining the data value of each body-in-white detection point according to the CSV file and the corresponding new vehicle model template, the method further comprises: At least one group of detection point related dimensions and related dimension qualification rates are calculated according to the data values of all the body-in-white detection points, and the related dimension qualification rates and each detection point related dimension are uploaded to the management database; The related dimension qualification rate is used to represent the relative size relationship between a plurality of body-in-white detection points.

7. The method of processing body-in-white measurement data according to claim 1, wherein, After obtaining the CSV file output by the three-coordinate measuring machine and matching the corresponding new vehicle model template based on the measuring machine information of the three-coordinate measuring machine, and then obtaining the data value of each body-in-white detection point according to the CSV file and the corresponding new vehicle model template, the method further comprises: At least a detection point trend chart, a cross-vehicle model same detection point joint display chart, a body-in-white 3D point cloud image, and / or a related dimension state chart are generated according to the data values of all the body-in-white detection points.

8. A body-in-white measurement data processing apparatus characterized by comprising: At least comprising: A template creation module is configured to formulate a detection point naming rule and a detection point numbering rule of a body-in-white detection point, mark key detection points, generate at least one vehicle model template information table, and then create at least one new vehicle model template based on the vehicle model template information table and corresponding vehicle model information; A data value determination module is configured to obtain a CSV file output by a three-coordinate measuring machine, match a corresponding new vehicle model template based on measuring machine information of the three-coordinate measuring machine, and then obtain a data value of each body-in-white detection point according to the CSV file and the corresponding new vehicle model template; A first calculation and uploading module is configured to calculate at least a full size qualification rate and a key size qualification rate according to the data value of each body-in-white detection point and a key size identifier in the corresponding new vehicle model template, and upload all method related data to a management database.

9. An electronic device comprising a memory and a processor, said memory storing a computer program operable on said processor, characterized in that, The processor executes the program to realize the steps in the body-in-white measurement data processing method of any one of claims 1 to 7.

10. A computer-readable storage medium having stored thereon a computer program, characterized in that, The computer program is executed by the processor to realize the steps in the body-in-white measurement data processing method of any one of claims 1 to 7.

Images