A method and device for automatically counting splash rate

Abstract

The present application relates to a method and device for automatic statistics of spatter rate, and relates to the field of automobile manufacturing technology. The method includes the following steps: based on the welds of the vehicle model to be counted, determine the names of the weld parameters to be extracted from the welds, and define them as the names of the weld parameters to be extracted; confirm one by one whether the names of the weld parameters to be extracted are in the list of weld spatter rates of the vehicle model to be counted, and if so, extract the corresponding weld parameter information in the list of weld spatter rates; based on the correspondence between the controller and the wire body corresponding to the weld, obtain the wire body name corresponding to each weld; based on the wire body name corresponding to the weld and the corresponding weld parameter information, sort out and obtain the wire body spatter rate data. The present application extracts the names of the weld parameters to be extracted, the weld parameter information and the weld number, and combines the correspondence between the controller and the wire body to sort out the data, and completes the automatic statistics of the spatter rate data. The statistical work is highly versatile, accurate and reliable, and has high work efficiency.

Description

Technical Field

[0001] The present application relates to the field of automobile manufacturing technology, and in particular to a method and device for automatically counting spatter rate. Background Art

[0002] In today's automotive industry, as the automotive industry's requirements for the appearance of body welds and the exquisiteness of the body are becoming more and more stringent, it is imperative to reduce the spatter of steel plate resistance spot welding. In the process of reducing spatter, it is necessary to understand the spatter rate of each model and line. However, most lines are produced on the same line, and some welds share the same program. The weld spatter rate list data derived from the BOSCH controller cannot directly sort out the spatter rate of specific models and lines.

[0003] Therefore, an automatic spatter rate statistics technology is now provided to meet the current spatter rate statistics needs. Summary of the invention

[0004] The present application provides a method and device for automatic statistics of spatter rate, which extracts the names of solder joint parameters, solder joint parameter information and solder joint numbers that need to be counted, and organizes the data in combination with the correspondence between the controller and the line body, thereby completing the automatic statistics of spatter rate data. The statistical work is highly versatile, accurate and reliable, and has high work efficiency.

[0005] In a first aspect, the present application provides a method for automatically counting splash rate, the method comprising the following steps:

[0006] Based on the welding points of the vehicle model to be counted, determine the welding point parameter names to be extracted from the welding points, and define them as the welding point parameter names to be extracted;

[0007] Confirm one by one whether the name of each of the welding point parameters to be extracted is in the list of welding point spatter rates of the vehicle models to be counted, and if so, extract the corresponding welding point parameter information in the list of welding point spatter rates;

[0008] Based on the correspondence between the controllers corresponding to the soldering points and the wire bodies, obtaining the wire body names corresponding to the soldering points;

[0009] Based on the wire body name corresponding to the welding point and the corresponding welding point parameter information, the wire body spatter rate data is sorted and obtained.

[0010] Specifically, the step of confirming one by one whether the name of each of the to-be-extracted welding spot parameter is in the list of welding spot spatter rates of the vehicle models to be counted, and if so, extracting the corresponding welding spot parameter information in the list of welding spot spatter rates, comprises the following steps:

[0011] Confirm one by one whether the name of each of the welding point parameters to be extracted is in the list of welding point spatter rates of the vehicle model to be counted, and if so, determine the document column number corresponding to the name of the welding point parameter to be extracted in the list of welding point spatter rates, and extract the corresponding welding point number;

[0012] Identify whether the welding point number of the welding point parameter name to be extracted in the welding point spatter rate is the welding point number of the vehicle model to be counted, and if so, extract the corresponding welding point parameter information in the welding point spatter rate list.

[0013] Furthermore, before confirming one by one whether the names of the welding point parameters to be extracted are in the list of welding point spatter rates of the vehicle models to be counted, and if so, extracting the corresponding welding point parameter information in the list of welding point spatter rates, the method further comprises the following steps:

[0014] The weld spot spatter rate list is processed by data separation.

[0015] Specifically, the solder spot spatter rate list is a txt document;

[0016] In the data separation processing of the weld spot spatter rate list, the method comprises the following steps:

[0017] Use the slipt command to perform data separation based on the semicolons and commas in the solder spot spatter rate list.

[0018] Furthermore, after obtaining the wire body spatter rate data based on the wire body name corresponding to the welding point and the corresponding welding point parameter information, the method includes the following steps:

[0019] The vehicle type and line body splash rate data to be counted are associated and stored in a preset data storage area.

[0020] In a second aspect, the present application provides a device for automatically counting splash rate, the device comprising:

[0021] A welding point parameter name definition module is used to determine the welding point parameter names to be extracted from the welding points of the vehicle model to be counted, and define them as the welding point parameter names to be extracted;

[0022] A welding point parameter information acquisition module, which is used to confirm one by one whether the name of each welding point parameter to be extracted is in the list of welding point spatter rates of the vehicle model to be counted, and if so, extract the corresponding welding point parameter information in the list of welding point spatter rates;

[0023] A wire name acquisition module, which is used to obtain the wire name corresponding to each welding point based on the corresponding relationship between the controller corresponding to the welding point and the wire body;

[0024] The wire spatter rate data sorting module is used to sort and obtain the wire spatter rate data based on the wire name corresponding to the welding point and the corresponding welding point parameter information.

[0025] Furthermore, the welding point parameter information acquisition module is also used to confirm one by one whether the name of each welding point parameter to be extracted is in the list of welding point spatter rates of the vehicle model to be counted, and if so, determine the document column number corresponding to the name of the welding point parameter to be extracted in the list of welding point spatter rates, and extract the corresponding welding point number;

[0026] The welding point parameter information acquisition module is also used to identify whether the welding point number of the welding point parameter name to be extracted in the welding point spatter rate is the welding point number of the vehicle model to be counted, and if so, extract the corresponding welding point parameter information in the welding point spatter rate list.

[0027] Furthermore, the device also includes a list preprocessing module;

[0028] The list preprocessing module is used to perform data column separation processing on the weld spot spatter rate list.

[0029] Furthermore, the solder spot spatter rate list is a txt document;

[0030] The list preprocessing module is also used to use the slipt instruction to perform data column separation processing based on the semicolons and commas in the solder spot spatter rate list.

[0031] Furthermore, the device also includes:

[0032] The data storage module is used to associate the vehicle type and line body splash rate data to be counted and store them in a preset data storage area.

[0033] The beneficial effects of the technical solution provided by this application include:

[0034] The present application extracts the names of the solder joint parameters, solder joint parameter information and solder joint numbers that need to be counted, and organizes the data in combination with the correspondence between the controller and the line body, thereby completing the automatic statistics of the spatter rate data. The statistical work is highly versatile, accurate and reliable, and has high work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0036] Figure 1A flowchart of the automatic statistical method for spatter rate provided in an embodiment of the present application;

[0037] Figure 2 The splash rate data processing flow of the current splash rate data processing flow provided in the embodiment of the present application;

[0038] Figure 3 This is a principle flow chart of the automatic statistical method for splash rate provided in the embodiments of the present application;

[0039] Figure 4 This is a structural block diagram of the automatic splash rate statistics device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0040] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of this application.

[0041] The embodiments of the present application are further described in detail below in conjunction with the accompanying drawings.

[0042] The embodiment of the present application provides a method and device for automatic statistics of spatter rate, which extracts the names of weld point parameters to be extracted, weld point parameter information and weld point numbers that need to be counted, and organizes the data in combination with the correspondence between the controller and the line body, thereby completing the automatic statistics of spatter rate data. The statistical work is highly versatile, accurate and reliable, and has high work efficiency.

[0043] In order to achieve the above technical effects, the overall idea of ​​this application is as follows:

[0044] A method for automatically counting splash rate, the method comprising the following steps:

[0045] S1. Based on the welding points of the vehicle model to be counted, determine the welding point parameter names to be extracted from the welding points, and define them as the welding point parameter names to be extracted;

[0046] S2, confirming one by one whether the name of each welding point parameter to be extracted is in the list of welding point spatter rates of the vehicle model to be counted, and if so, extracting the corresponding welding point parameter information in the list of welding point spatter rates;

[0047] S3, based on the correspondence between the controllers corresponding to the welding points and the wire bodies, obtaining the wire body names corresponding to the welding points;

[0048] S4. Based on the wire body name corresponding to the welding point and the corresponding welding point parameter information, the wire body spatter rate data is obtained through sorting.

[0049] The embodiments of the present application are further described in detail below in conjunction with the accompanying drawings.

[0050] First, see Figures 1 to 3 As shown, the embodiment of the present application provides a method for automatically counting the spatter rate, the method comprising the following steps:

[0051] S1. Based on the welding points of the vehicle model to be counted, determine the welding point parameter names to be extracted from the welding points, and define them as the welding point parameter names to be extracted;

[0052] S2, confirming one by one whether the name of each welding point parameter to be extracted is in the list of welding point spatter rates of the vehicle model to be counted, and if so, extracting the corresponding welding point parameter information in the list of welding point spatter rates;

[0053] S3, based on the correspondence between the controller corresponding to the soldering point and the wire body, obtaining the wire body name corresponding to each soldering point;

[0054] S4. Based on the wire body name corresponding to the welding point and the corresponding welding point parameter information, the wire body spatter rate data is obtained by sorting out.

[0055] It should be noted that the controller in the embodiment of the present application may specifically be a BOSCH controller.

[0056] In an embodiment of the present application, the names of the weld point parameters to be extracted, the weld point parameter information and the weld point numbers that need to be counted are extracted, and the data is sorted in combination with the correspondence between the controller and the line body, thereby completing the automatic statistics of the spatter rate data. The statistical work is highly versatile, accurate and reliable, and has high work efficiency.

[0057] Specifically, the step of confirming one by one whether the name of each of the to-be-extracted welding spot parameter is in the list of welding spot spatter rates of the vehicle models to be counted, and if so, extracting the corresponding welding spot parameter information in the list of welding spot spatter rates, comprises the following steps:

[0058] Confirm one by one whether the name of each of the welding point parameters to be extracted is in the list of welding point spatter rates of the vehicle model to be counted, and if so, determine the document column number corresponding to the name of the welding point parameter to be extracted in the list of welding point spatter rates, and extract the corresponding welding point number;

[0059] Identify whether the welding point number of the welding point parameter name to be extracted in the welding point spatter rate is the welding point number of the vehicle model to be counted, and if so, extract the corresponding welding point parameter information in the welding point spatter rate list.

[0060] Furthermore, before confirming one by one whether the names of the welding point parameters to be extracted are in the list of welding point spatter rates of the vehicle models to be counted, and if so, extracting the corresponding welding point parameter information in the list of welding point spatter rates, the method further comprises the following steps:

[0061] The weld spot spatter rate list is processed by data separation.

[0062] Specifically, the solder spot spatter rate list is a txt document;

[0063] In the data separation processing of the weld spot spatter rate list, the method comprises the following steps:

[0064] Use the slipt command to perform data separation based on the semicolons and commas in the solder spot spatter rate list.

[0065] Furthermore, after obtaining the wire body spatter rate data based on the wire body name corresponding to the welding point and the corresponding welding point parameter information, the method includes the following steps:

[0066] The vehicle type and line body splash rate data to be counted are associated and stored in a preset data storage area.

[0067] Based on the technical solution of the embodiment of the present application, a specific implementation process is given, which is as follows:

[0068] A1. Determine the welding point number based on the welding points of the vehicle model to be counted, and copy it to the preset data storage area;

[0069] A2. Determine the parameter name to be extracted from the solder spot spatter rate list, that is, the solder spot parameter name to be extracted;

[0070] A3. Select a list of spatter rates of solder joints to be processed, which is preferably a txt file;

[0071] A4. To process the txt document of the list of spatter rates of welding points, use slipt and press ";" or "," to complete the data column processing;

[0072] A5. Determine whether the solder joint parameter name to be extracted exists in the solder joint spatter rate list txt file after data segmentation processing. If not, go to step A4. If yes, go to step A6.

[0073] A6. Record the column number of the solder joint parameter name to be extracted in the solder joint spatter rate list txt file after the data is processed;

[0074] A7. Extract the solder joint number from the solder joint spatter rate list txt file after data separation processing;

[0075] A8, determine whether the solder joint number in the solder joint spatter rate list txt file exists in the preset data storage area, if so, proceed to step A9;

[0076] A9. Based on the number of columns of the solder joint parameter names to be extracted in the solder joint spatter rate list txt document after data column processing, write the parameter information of the solder joint parameter names to be extracted into a preset data storage area and associate them with the corresponding solder joint numbers;

[0077] A10. Based on the correspondence between the controller and the wire body corresponding to the welding point, use if nesting to obtain the wire body name corresponding to each welding point, and obtain the wire body spatter rate data. A11. Based on the wire body spatter rate data and the vehicle model to be counted, generate the vehicle model and wire body spatter rate data, and write them into the preset data storage area.

[0078] As shown in the attached figure of the specification Figure 2 As shown in the figure, the current implementation scheme for the splash rate data processing flow is as follows:

[0079] Use the existing macro code on the Internet to process the txt document of the welding point spatter rate list in the BOSCH controller and convert it into excel format;

[0080] Then use the built-in column sorting function of Excel to process the data;

[0081] Use Excel formulas to sort out the corresponding spatter rate data based on the specific vehicle model's welding point number, and sort out the area name based on the name of the controller where the welding point is located.

[0082] It should be noted that the current solder joint spatter rate list txt document has inconsistent formats. After being converted into excel data, the format needs to be processed manually. It is necessary to automatically complete the format consistency during the conversion of txt to excel.

[0083] In addition, many formulas are used in the statistical process of vehicle model and line body splash rate, which requires high skills of personnel. Different personnel have inconsistent judgments on line body areas based on controller names, which can easily lead to distortion of splash rate data of each line body. Therefore, it is necessary to unify the correspondence between controller names and line body names.

[0084] To address the above problems, the technical solutions of the embodiments of the present application can achieve the following technical effects:

[0085] First, due to the difference in the steps of converting the txt document format into Excel data, based on the principle that the parameter names of the solder spatter rate list need to be extracted in the process, the problem of inconsistent txt document format of the solder spatter rate list in the existing technical solution is solved. After conversion into excel data, the format problem needs to be manually processed.

[0086] Secondly, due to the difference in the steps of corresponding the welding point number to the wire body name, based on the principle of defining the correspondence between the controller name and the wire body name, the problem of different personnel in the existing technical solution inconsistently judging the wire body area based on the controller name, resulting in distortion of the spatter rate data of each wire body, is solved.

[0087] Thirdly, the technical solution of the embodiment of the present application is simple and convenient to operate, which shortens the time for collating data on vehicle model and line splash rate and improves data processing efficiency.

[0088] Fourthly, the improvement in data processing efficiency has in turn promoted the smooth progress of the work of reducing the splash rate of vehicle models.

[0089] Second, see Figure 4 As shown, the embodiment of the present application provides a spatter rate automatic statistical device based on the technology of the spatter rate automatic statistical method mentioned in the first aspect, and the spatter rate automatic statistical device includes:

[0090] A welding point parameter name definition module is used to determine the welding point parameter names to be extracted from the welding points of the vehicle model to be counted, and define them as the welding point parameter names to be extracted;

[0091] A welding point parameter information acquisition module, which is used to confirm one by one whether the name of each welding point parameter to be extracted is in the list of welding point spatter rates of the vehicle model to be counted, and if so, extract the corresponding welding point parameter information in the list of welding point spatter rates;

[0092] A wire name acquisition module, which is used to obtain the wire name corresponding to each welding point based on the corresponding relationship between the controller corresponding to the welding point and the wire body;

[0093] The wire spatter rate data sorting module is used to sort and obtain the wire spatter rate data based on the wire name corresponding to the welding point and the corresponding welding point parameter information.

[0094] It should be noted that the controller in the embodiment of the present application may specifically be a BOSCH controller.

[0095] In an embodiment of the present application, the names of the weld point parameters to be extracted, the weld point parameter information and the weld point numbers that need to be counted are extracted, and the data is sorted in combination with the correspondence between the controller and the line body, thereby completing the automatic statistics of the spatter rate data. The statistical work is highly versatile, accurate and reliable, and has high work efficiency.

[0096] Furthermore, the welding point parameter information acquisition module is also used to confirm one by one whether the name of each welding point parameter to be extracted is in the list of welding point spatter rates of the vehicle model to be counted, and if so, determine the document column number corresponding to the name of the welding point parameter to be extracted in the list of welding point spatter rates, and extract the corresponding welding point number;

[0097] The welding point parameter information acquisition module is also used to identify whether the welding point number of the welding point parameter name to be extracted in the welding point spatter rate is the welding point number of the vehicle model to be counted, and if so, extract the corresponding welding point parameter information in the welding point spatter rate list.

[0098] Furthermore, the automatic statistical device for spatter rate also includes a list preprocessing module;

[0099] The list preprocessing module is used to perform data column separation processing on the weld spot spatter rate list.

[0100] Furthermore, the solder spot spatter rate list is a txt document;

[0101] The list preprocessing module is also used to use the slipt instruction to perform data column separation processing based on the semicolons and commas in the solder spot spatter rate list.

[0102] Furthermore, the automatic statistical device for the splash rate also includes:

[0103] The data storage module is used to associate the vehicle type and line body splash rate data to be counted and store them in a preset data storage area.

[0104] Based on the technical solution of the embodiment of the present application, a specific implementation process of the automatic statistics device for the splash rate is given, which is as follows:

[0105] A1. Determine the welding point number based on the welding points of the vehicle model to be counted, and copy it to the preset data storage area;

[0106] A2. Determine the parameter name to be extracted from the solder spot spatter rate list, that is, the solder spot parameter name to be extracted;

[0107] A3. Select a list of spatter rates of solder joints to be processed, which is preferably a txt file;

[0108] A4. To process the txt document of the list of spatter rates of welding points, use slipt and press ";" or "," to complete the data column processing;

[0109] A5. Determine whether the solder joint parameter name to be extracted exists in the solder joint spatter rate list txt file after data segmentation processing. If not, go to step A4. If yes, go to step A6.

[0110] A6. Record the column number of the solder joint parameter name to be extracted in the solder joint spatter rate list txt file after the data is processed;

[0111] A7. Extract the solder joint number from the solder joint spatter rate list txt file after data separation processing;

[0112] A8, determine whether the solder joint number in the solder joint spatter rate list txt file exists in the preset data storage area, if so, proceed to step A9;

[0113] A9. Based on the number of columns of the solder joint parameter names to be extracted in the solder joint spatter rate list txt document after data column processing, write the parameter information of the solder joint parameter names to be extracted into a preset data storage area and associate them with the corresponding solder joint numbers;

[0114] A10. Based on the corresponding relationship between the controller and the wire corresponding to the soldering point, use if nesting to obtain the wire name corresponding to each soldering point, and obtain the wire spatter rate data statistically.

[0115] A11. Based on the line body splash rate data and the vehicle model to be counted, generate vehicle model and line body splash rate data and write them into a preset data storage area.

[0116] For the splash rate data processing flow, the current implementation plan is as follows:

[0117] Use the existing macro code on the Internet to process the txt document of the welding point spatter rate list in the BOSCH controller and convert it into excel format;

[0118] Then use the built-in column sorting function of Excel to process the data;

[0119] Use Excel formulas to sort out the corresponding spatter rate data based on the specific vehicle model's welding point number, and sort out the area name based on the name of the controller where the welding point is located.

[0120] It should be noted that the current solder joint spatter rate list txt document has inconsistent formats. After being converted into excel data, the format needs to be processed manually. It is necessary to automatically complete the format consistency during the conversion of txt to excel.

[0121] In addition, many formulas are used in the statistical process of vehicle model and line body splash rate, which requires high skills of personnel. Different personnel have inconsistent judgments on line body areas based on controller names, which can easily lead to distortion of splash rate data of each line body. Therefore, it is necessary to unify the correspondence between controller names and line body names.

[0122] To address the above problems, the technical solutions of the embodiments of the present application can achieve the following technical effects:

[0123] First, due to the difference in the steps of converting the txt document format into Excel data, based on the principle that the parameter names of the solder spatter rate list need to be extracted in the process, the problem of inconsistent txt document format of the solder spatter rate list in the existing technical solution is solved. After conversion into excel data, the format problem needs to be manually processed.

[0124] Secondly, due to the difference in the steps of corresponding the welding point number to the wire body name, based on the principle of defining the correspondence between the controller name and the wire body name, the problem of different personnel in the existing technical solution inconsistently judging the wire body area based on the controller name, resulting in distortion of the spatter rate data of each wire body, is solved.

[0125] Thirdly, the technical solution of the embodiment of the present application is simple and convenient to operate, which shortens the time for collating data on vehicle model and line splash rate and improves data processing efficiency.

[0126] Fourthly, the improvement in data processing efficiency has in turn promoted the smooth progress of the work of reducing the splash rate of vehicle models.

[0127] It should be noted that, in this application, relational terms such as "first" and "second" are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0128] The above is only a specific implementation of the present application, so that those skilled in the art can understand or implement the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest range consistent with the principles and novel features applied for herein.

Claims

1. A method for automatically calculating the spatter rate, characterized in that: The method comprises the following steps: Based on the welding points of the vehicle model to be counted, determine the welding point parameter names to be extracted from the welding points, and define them as the welding point parameter names to be extracted; Confirm one by one whether the name of each welding point parameter to be extracted is in the welding point spatter rate list txt document of the vehicle model to be counted, and if so, extract the corresponding welding point parameter information in the welding point spatter rate list txt document; Based on the correspondence between the controllers corresponding to the soldering points and the wire bodies, obtaining the wire body names corresponding to the soldering points; Based on the wire body name corresponding to the welding point and the corresponding welding point parameter information, the wire body spatter rate data is obtained; Before confirming one by one whether the names of the welding point parameters to be extracted are in the welding point spatter rate list txt document of the vehicle model to be counted, and if so, extracting the corresponding welding point parameter information in the welding point spatter rate list txt document, the method further comprises the following steps: Use the slipt command to perform data column separation based on the semicolons and commas in the solder spot spatter rate list txt document; The obtaining of the wire body name corresponding to each welding point based on the correspondence between the controller corresponding to the welding point and the wire body comprises the following steps: Determine whether the solder joint parameter name to be extracted exists in the solder joint spatter rate list txt document after data column processing; If the solder joint parameter name to be extracted exists, the column number of the solder joint parameter name to be extracted in the solder joint spatter rate list txt document after data column processing is recorded; Extract the solder joint number from the solder joint spatter rate list txt file after data separation; Determine whether the solder joint number in the solder joint spatter rate list txt document exists in the preset data storage area; If there is a preset data storage area, then based on the number of columns of the solder joint parameter name to be extracted in the solder joint spatter rate list txt document after data column processing, the parameter information of the solder joint parameter name to be extracted is written into the preset data storage area and associated with the corresponding solder joint number; Based on the correspondence between the controller and the wire body corresponding to the soldering point, if nesting is used to obtain the wire body name corresponding to each soldering point.

2. The automatic statistical method for spatter rate according to claim 1, characterized in that: The step of confirming one by one whether the name of each welding spot parameter to be extracted is in the welding spot spatter rate list txt document of the vehicle model to be counted, and if so, extracting the corresponding welding spot parameter information in the welding spot spatter rate list txt document, comprises the following steps: Confirm one by one whether the name of each welding point parameter to be extracted is in the welding point spatter rate list txt document of the vehicle model to be counted, and if so, determine the document column number corresponding to the name of the welding point parameter to be extracted in the welding point spatter rate list txt document, and extract the corresponding welding point number; Identify whether the welding point number of the welding point parameter name to be extracted in the welding point spatter rate is the welding point number of the vehicle model to be counted, and if so, extract the corresponding welding point parameter information in the welding point spatter rate list txt document.

3. The automatic statistical method for spatter rate according to claim 1, characterized in that: After obtaining the wire body spatter rate data based on the wire body name corresponding to the welding point and the corresponding welding point parameter information, the method comprises the following steps: The vehicle type to be counted and the line body splash rate data are associated and stored in a preset data storage area.

4. A device for automatically counting spatter rate, characterized in that: The device comprises: A welding point parameter name definition module is used to determine the welding point parameter names to be extracted from the welding points of the vehicle model to be counted, and define them as the welding point parameter names to be extracted; A welding point parameter information acquisition module, which is used to confirm one by one whether the name of each welding point parameter to be extracted is in the welding point spatter rate list txt document of the vehicle model to be counted, and if so, extract the corresponding welding point parameter information in the welding point spatter rate list txt document; A wire name acquisition module, which is used to obtain the wire name corresponding to each welding point based on the corresponding relationship between the controller corresponding to the welding point and the wire body; A wire body spatter rate data sorting module, which is used to sort out wire body spatter rate data based on the wire body name corresponding to the welding point and the corresponding welding point parameter information; The device also includes a list preprocessing module, which is used to use the slipt instruction to perform data column separation processing based on the semicolons and commas in the solder spot spatter rate list txt document; The line name acquisition module is also used to determine whether there is a solder point parameter name to be extracted in the solder point spatter rate list txt document after data column processing; The line name acquisition module is also used to record the column number of the solder point parameter name to be extracted in the solder point spatter rate list txt document after data column processing if the solder point parameter name to be extracted exists; The line name acquisition module is also used to extract the solder joint number in the solder joint spatter rate list txt document after data column processing; The line name acquisition module is also used to determine whether the solder joint number in the solder joint spatter rate list txt document exists in the preset data storage area; The line name acquisition module is also used to write the parameter information of the solder point parameter name to be extracted into the preset data storage area if there is a preset data storage area, and associate it with the corresponding solder point number based on the number of columns of the solder point parameter name to be extracted in the solder point spatter rate list txt document after data column processing; The wire name acquisition module is also used to use if nesting to obtain the wire name corresponding to each welding point based on the corresponding relationship between the controller corresponding to the welding point and the wire body.

5. The automatic spatter rate counting device according to claim 4, characterized in that: The welding point parameter information acquisition module is also used to confirm one by one whether the name of each welding point parameter to be extracted is in the welding point spatter rate list txt document of the vehicle model to be counted, and if so, determine the document column number corresponding to the name of the welding point parameter to be extracted in the welding point spatter rate list txt document, and extract the corresponding welding point number; The welding point parameter information acquisition module is also used to identify whether the welding point number of the welding point parameter name to be extracted in the welding point spatter rate is the welding point number of the vehicle model to be counted, and if so, extract the corresponding welding point parameter information in the welding point spatter rate list txt document.

6. The automatic spatter rate counting device according to claim 4, characterized in that: The device also includes: The data storage module is used to associate the vehicle type and line body splash rate data to be counted and store them in a preset data storage area.

Images