A parameter selection method and device

Abstract

The present application relates to a parameter selection method and device, and relates to the field of automobile manufacturing technology. The method includes the following steps: select a connection information table that needs to supplement parameters, count the number of data rows that need to be processed, and clear the content of the parameter to be selected area; if the weld number is not empty, then based on the material information corresponding to the weld, find the material category corresponding to the material information and whether there is coating information, and fill in the material category of the weld and the number of coated plates in the connection information table; select the plate thickness corresponding to the weld, combine the statistics of the number of various material categories, define the calculation method of the number of overlap layers, reference plate thickness and total plate thickness, and fill in the calculation results in the connection information table; if there is no missing information on the weld material and material thickness, fill in the nugget diameter, pressure serial number and parameter serial number in the connection information table. This application completes the parameter information based on the relevant information of the connection information table to be supplemented, so as to ensure the smooth progress of spot welding and provide convenience for daily vehicle production.

Description

Technical Field

[0001] The present application relates to the field of automobile manufacturing technology, and in particular to a parameter selection method and device. Background Art

[0002] With the widespread application of resistance spot welding in the automotive industry, various automobile manufacturers have established parameter selection specifications based on their own conditions. On the one hand, the existing experience can be quickly transferred to subsequent projects to improve the connection performance of welds; on the other hand, only the plate combinations outside the parameter selection specifications need to be tested, reducing the investment cost of the initial parameter selection test. At present, most of them adopt manual parameter selection schemes, and each car has an average of 3000-5000 welds, which is very inefficient.

[0003] In the prior art, when selecting parameters, the vlookup, if, index and match functions provided by Excel are often used to sort out the material category of the solder joint, the presence or absence of coating, the number of overlapping layers of the plate, the reference plate thickness, the total plate thickness, the parameter sequence and the pressure sequence. The existing scheme has not been adjusted according to the parameter selection specifications released by the company, and there are the following problems: First, the calculation of the weld core diameter is missing, and the information is supplemented manually; second, the reference plate thickness judgment does not take into account the clause in the standard that "when the thickness of any two layers of the three-layer plate is the same, the same plate thickness is taken as the reference plate thickness", and the calculation of the reference plate thickness of the three-layer plate is distorted; third, the parameter sequence and pressure sequence are inconsistent with the standard, resulting in distortion of the selection parameters of some solder joints.

[0004] Therefore, in order to make up for the shortcomings of parameter selection in the current solder joint work, a new parameter selection technology is provided to meet the current automobile production needs. Summary of the invention

[0005] The present application provides a parameter selection method and device. When the parameter information of the welding point is missing, the parameter information is supplemented based on the relevant information of the connection information table of the information to be supplemented, combined with the preset calculation method of different parameters, to ensure the smooth progress of the spot welding work and provide convenience for the daily production work of the vehicle.

[0006] To achieve the above objectives, this application provides the following solutions.

[0007] In a first aspect, the present application provides a parameter selection method, the method comprising the following steps:

[0008] Select the connection information table that needs to supplement parameters, count the number of data rows to be processed, and clear the content of the parameter to be selected area;

[0009] Determine whether the solder joint number is empty. If the solder joint number is not empty, then based on the material information corresponding to the solder joint, find the material category corresponding to the material information and whether there is coating information, and fill in the material category and the number of coated plates corresponding to the solder joint in the connection information table;

[0010] Select the plate thickness corresponding to the welding point, combine the statistics of the number of various material categories, define the calculation method of the number of overlapping layers, the base plate thickness and the total plate thickness, and fill in the corresponding calculation results in the connection information table;

[0011] Determine whether there is any missing information on the material and thickness of the weld. If there is no missing information, find the corresponding nugget diameter, pressure serial number and parameter serial number, and fill them in the connection information table.

[0012] It should be noted that in the prior art, when selecting parameters, the vlookup, if, index and match functions provided by Excel are often used to sort out the material category of the solder joint, the presence or absence of coating, the number of overlapping layers of the plate, the reference plate thickness, the total plate thickness, the parameter sequence and the pressure sequence. The existing scheme has not been adjusted according to the parameter selection specifications released by the company, and there are the following problems: First, the calculation of the weld core diameter is missing, and the information is supplemented by manual sorting; second, the reference plate thickness judgment does not take into account the clause in the standard that "when the thickness of any two layers of the three-layer plate is the same, the same plate thickness is taken as the reference plate thickness", and the calculation of the reference plate thickness of the three-layer plate is distorted; third, the parameter sequence and pressure sequence are inconsistent with the standard, resulting in distortion of the selection parameters of some solder joints.

[0013] Furthermore, the existing technical solutions still have the following technical defects:

[0014] First, when the material or thickness information of the weld is missing, the existing solutions will mostly calculate according to the two-layer board to obtain the wrong weld core diameter, parameter sequence and pressure sequence. It is necessary to implement a function that will not continue to select parameter specifications when information is missing.

[0015] Secondly, the existing solution lacks the function of supplementing the weld core diameter, and when the writing method of the weld core diameter of the three-layer plate is consistent with the writing method of the date, the system defaults to the date, and the information is wrong. It is necessary to realize the function of automatically supplementing the weld core diameter and being able to distinguish and not report an error when the writing method of the weld core diameter of the three-layer plate is consistent with the date.

[0016] Third, the calculation of the benchmark plate thickness is relatively simple using the Excel built-in function roundup & min, but VBA cannot be written directly in the Excel formula format and requires the use of Excel built-in function functionality.

[0017] In this application, when the welding point parameter information is missing, the parameter information is supplemented based on the relevant information of the connection information table to be supplemented, combined with the preset calculation method of different parameters, to ensure the smooth progress of the spot welding work and provide convenience for the daily production work of the vehicle.

[0018] The technical solution of this application has the following characteristics:

[0019] When the solder joint material or material thickness information is missing, the parameter specification function will not be selected, but the if condition will be used to determine whether the solder joint material or material thickness information is missing;

[0020] The function that can distinguish the three-layer plate nugget diameter and the date writing method without error is defined by using the cell NumberFormatLocal;

[0021] The base plate thickness calculation uses the built-in function of Excel, which is defined using "Application.WorksheetFunction."

[0022] Specifically, the determination of whether there is any missing information about the material and thickness of the weld point, if there is no missing information, then finding the corresponding nugget diameter, pressure serial number and parameter serial number, and filling them into the connection information table, includes the following steps:

[0023] Arrange the reference plate thickness information used for nugget diameter selection, find the corresponding nugget diameter, and fill it into the connection information table.

[0024] Specifically, the determination of whether there is any missing information about the material and thickness of the weld point, if there is no missing information, then finding the corresponding nugget diameter, pressure serial number and parameter serial number, and filling them into the connection information table, includes the following steps:

[0025] Find the pressure serial number based on the base plate thickness and the number of various material categories and fill it in the connection information table.

[0026] Specifically, the determination of whether there is any missing information about the material and thickness of the weld point, if there is no missing information, then finding the corresponding nugget diameter, pressure serial number and parameter serial number, and filling them into the connection information table, includes the following steps:

[0027] According to the base plate thickness, the number of various material categories and the plate thickness ratio, find the parameter serial number and fill it in the connection information table.

[0028] Furthermore, the method further comprises the following steps:

[0029] Determine whether the soldering point number is empty, and if the soldering point number is not empty, terminate the operation.

[0030] Specifically, the method further comprises the following steps:

[0031] Determine whether there is any missing information about the material and thickness of the solder joint. If there is any missing information, determine whether the next solder joint number is empty.

[0032] The technical solution of this application has the following advantages:

[0033] First, since the continued calculation when the solder joint material or material thickness information is missing causes the parameter selection error, the problem of incorrect parameter selection in the prior art solution is solved by adding the if condition judgment of whether the solder joint material and material thickness are missing;

[0034] Second, since the nugget diameter cannot be generated and an error message will be displayed when the nugget diameter of the three-layer plate is consistent with the date writing method, the problem that the nugget diameter cannot be generated and an error message will be displayed when the nugget diameter of the three-layer plate is consistent with the date writing method in the prior art solution is solved based on the definition of the nugget diameter cell NumberFormatLocal;

[0035] Thirdly, since it is easier to use the built-in function of Excel to calculate the reference plate thickness, the problem that the Excel function cannot be used in VBA in the prior art solution is solved based on the use of "Application.WorksheetFunction." to define the use function;

[0036] Fourthly, the operation method is simple and convenient, the time for parameter selection can be greatly shortened, and the data processing efficiency is significantly improved.

[0037] In a second aspect, the present application provides a parameter selection device, the device comprising:

[0038] The information table preprocessing module is used to select the connection information table that needs to be supplemented with parameters, count the number of data rows to be processed, and clear the content of the parameter to be selected area;

[0039] The basic parameter acquisition module is used to determine whether the solder joint number is empty. If the solder joint number is not empty, the material category corresponding to the material information and the presence or absence of coating information are found based on the material information corresponding to the solder joint, and the material category and the number of coated plates corresponding to the solder joint in the connection information table are filled in;

[0040] The calculation method acquisition module is used to select the plate thickness corresponding to the welding point, combine the statistics of the number of various material categories, define the calculation method of the number of overlapping layers, the reference plate thickness and the total plate thickness, and fill in the corresponding calculation results in the connection information table;

[0041] The parameter supplement module is used to determine whether there is any missing information about the material and thickness of the weld. If there is no missing information, the corresponding weld core diameter, pressure serial number and parameter serial number are found and filled in the connection information table.

[0042] It should be noted that in the prior art, when selecting parameters, the vlookup, if, index and match functions provided by Excel are often used to sort out the material category of the solder joint, the presence or absence of coating, the number of overlapping layers of the plate, the reference plate thickness, the total plate thickness, the parameter sequence and the pressure sequence. The existing scheme has not been adjusted according to the parameter selection specifications released by the company, and there are the following problems: First, the calculation of the weld core diameter is missing, and the information is supplemented by manual sorting; second, the reference plate thickness judgment does not take into account the clause in the standard that "when the thickness of any two layers of the three-layer plate is the same, the same plate thickness is taken as the reference plate thickness", and the calculation of the reference plate thickness of the three-layer plate is distorted; third, the parameter sequence and pressure sequence are inconsistent with the standard, resulting in distortion of the selection parameters of some solder joints.

[0043] Furthermore, the existing technical solutions still have the following technical defects:

[0044] First, when the material or thickness information of the weld is missing, the existing solutions will mostly calculate according to the two-layer board to obtain the wrong weld core diameter, parameter sequence and pressure sequence. It is necessary to implement a function that will not continue to select parameter specifications when information is missing.

[0045] Secondly, the existing solution lacks the function of supplementing the weld core diameter, and when the writing method of the weld core diameter of the three-layer plate is consistent with the writing method of the date, the system defaults to the date, and the information is wrong. It is necessary to realize the function of automatically supplementing the weld core diameter and being able to distinguish and not report an error when the writing method of the weld core diameter of the three-layer plate is consistent with the date.

[0046] Third, the calculation of the benchmark plate thickness is relatively simple using the Excel built-in function roundup & min, but VBA cannot be written directly in the Excel formula format and requires the use of Excel built-in function functionality.

[0047] In this application, when the welding point parameter information is missing, the parameter information is supplemented based on the relevant information of the connection information table to be supplemented, combined with the preset calculation method of different parameters, to ensure the smooth progress of the spot welding work and provide convenience for the daily production work of the vehicle.

[0048] The technical solution of this application has the following characteristics:

[0049] When the solder joint material or material thickness information is missing, the parameter specification function will not be selected, but the if condition will be used to determine whether the solder joint material or material thickness information is missing;

[0050] The function that can distinguish the three-layer plate nugget diameter and the date writing method without error is defined by using the cell NumberFormatLocal;

[0051] The base plate thickness calculation uses the built-in function of Excel, which is defined using "Application.WorksheetFunction."

[0052] Furthermore, the parameter supplement module is also used to sort out the reference plate thickness information used for selecting the weld core diameter, find the corresponding weld core diameter, and fill it into the connection information table.

[0053] Furthermore, the parameter supplement module is also used to find the pressure serial number according to the reference plate thickness and the number of various material categories, and fill it into the connection information table.

[0054] Furthermore, the parameter supplement module is also used to find the parameter serial number according to the reference plate thickness, the number of various material categories and the plate thickness ratio, and fill it into the connection information table.

[0055] Furthermore, the basic parameter acquisition module is also used to determine whether the welding point number is empty, and if the welding point number is not empty, the operation is terminated.

[0056] Specifically, the parameter supplement module is also used to determine whether there is any missing information about the material and thickness of the welding point. If there is any missing information, it is determined whether the next welding point number is empty.

[0057] The technical solution of this application has the following advantages:

[0058] First, since the continued calculation when the solder joint material or material thickness information is missing causes the parameter selection error, the problem of incorrect parameter selection in the prior art solution is solved by adding the if condition judgment of whether the solder joint material and material thickness are missing;

[0059] Second, since the nugget diameter cannot be generated and an error message will be displayed when the nugget diameter of the three-layer plate is consistent with the date writing method, the problem that the nugget diameter cannot be generated and an error message will be displayed when the nugget diameter of the three-layer plate is consistent with the date writing method in the prior art solution is solved based on the definition of the nugget diameter cell NumberFormatLocal;

[0060] Thirdly, since it is easier to use the built-in function of Excel to calculate the reference plate thickness, the problem that the Excel function cannot be used in VBA in the prior art solution is solved based on the use of "Application.WorksheetFunction." to define the use function;

[0061] Fourthly, the operation method is simple and convenient, the time for parameter selection can be greatly shortened, and the data processing efficiency is significantly improved.

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

[0063] When the welding point parameter information is missing, the present application completes the parameter information based on the relevant information of the connection information table to be supplemented, combined with the preset calculation method of different parameters, to ensure the smooth progress of the spot welding work and provide convenience for the daily production work of the vehicle. BRIEF DESCRIPTION OF THE DRAWINGS

[0064] 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.

[0065] Figure 1 A flow chart of the steps of the parameter selection method provided in the embodiments of the present application;

[0066] Figure 2 This is a flowchart of the steps of the current parameter supplement scheme provided in the embodiments of the present application;

[0067] Figure 3 The principle flow chart of the parameter selection method provided in the embodiment of the present application;

[0068] Figure 4 This is a structural block diagram of the parameter selection device provided in the embodiment of the present application. DETAILED DESCRIPTION

[0069] 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.

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

[0071] The embodiment of the present application provides a parameter selection method and device. When the welding point parameter information is missing, the parameter information is supplemented based on the relevant information of the connection information table of the information to be supplemented, combined with the preset calculation method of different parameters, to ensure the smooth progress of the spot welding work and provide convenience for the daily production work of the vehicle.

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

[0073] A parameter selection method, the method comprising the following steps:

[0074] S1. Select the connection information table that needs to supplement parameters, count the number of data rows to be processed, and clear the content of the parameter to be selected area;

[0075] S2. Determine whether the solder joint number is empty. If the solder joint number is not empty, then find the material category and coating information corresponding to the material information based on the material information corresponding to the solder joint, and fill in the material category and number of coated plates corresponding to the solder joint in the connection information table;

[0076] S3. Select the plate thickness corresponding to the welding point, combine the statistics of the number of various material categories, define the calculation method of the number of overlapping layers, the reference plate thickness and the total plate thickness, and fill in the corresponding calculation results in the connection information table;

[0077] S4. Determine whether there is any missing information on the material and thickness of the weld. If there is no missing information, find the corresponding nugget diameter, pressure serial number and parameter serial number, and fill them in the connection information table.

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

[0079] The present invention provides a parameter selection method, which includes the following steps:

[0080] S1. Select the connection information table that needs to supplement parameters, count the number of data rows to be processed, and clear the content of the parameter to be selected area;

[0081] S2. Determine whether the solder joint number is empty. If the solder joint number is not empty, then find the material category and coating information corresponding to the material information based on the material information corresponding to the solder joint, and fill in the material category and number of coated plates corresponding to the solder joint in the connection information table;

[0082] S3. Select the plate thickness corresponding to the welding point, combine the statistics of the number of various material categories, define the calculation method of the number of overlapping layers, the reference plate thickness and the total plate thickness, and fill in the corresponding calculation results in the connection information table;

[0083] S4. Determine whether there is any missing information on the material and thickness of the weld. If there is no missing information, find the corresponding nugget diameter, pressure serial number and parameter serial number, and fill them in the connection information table.

[0084] It should be noted that in the prior art, when selecting parameters, the vlookup, if, index and match functions provided by Excel are often used to sort out the material category of the solder joint, the presence or absence of coating, the number of overlapping layers of the plate, the reference plate thickness, the total plate thickness, the parameter sequence and the pressure sequence. The existing scheme has not been adjusted according to the parameter selection specifications released by the company, and there are the following problems: First, the calculation of the weld core diameter is missing, and the information is supplemented by manual sorting; second, the reference plate thickness judgment does not take into account the clause in the standard that "when the thickness of any two layers of the three-layer plate is the same, the same plate thickness is taken as the reference plate thickness", and the calculation of the reference plate thickness of the three-layer plate is distorted; third, the parameter sequence and pressure sequence are inconsistent with the standard, resulting in distortion of the selection parameters of some solder joints.

[0085] Furthermore, the existing technical solutions still have the following technical defects:

[0086] First, when the material or thickness information of the weld is missing, the existing solutions will mostly calculate according to the two-layer board to obtain the wrong weld core diameter, parameter sequence and pressure sequence. It is necessary to implement a function that will not continue to select parameter specifications when information is missing.

[0087] Secondly, the existing solution lacks the function of supplementing the weld core diameter, and when the writing method of the weld core diameter of the three-layer plate is consistent with the writing method of the date, the system defaults to the date, and the information is wrong. It is necessary to realize the function of automatically supplementing the weld core diameter and being able to distinguish and not report an error when the writing method of the weld core diameter of the three-layer plate is consistent with the date.

[0088] Third, the calculation of the benchmark plate thickness is relatively simple using the Excel built-in function roundup & min, but VBA cannot be written directly in the Excel formula format and requires the use of Excel built-in function functionality.

[0089] It should be noted that the step flow chart of the current parameter supplement scheme provided in the embodiment of the present application is as shown in the accompanying drawing of the specification. Figure 2 As shown, the principle flow chart of the parameter selection method provided in the embodiment of the present application is shown in the accompanying drawings of the specification. Figure 3 shown.

[0090] In an embodiment of the present application, when the welding point parameter information is missing, the parameter information is supplemented based on the relevant information of the connection information table of the information to be supplemented, combined with the preset calculation method of different parameters, to ensure the smooth progress of the spot welding work and provide convenience for the daily production work of the vehicle.

[0091] The technical solution of the embodiment of the present application has the following characteristics:

[0092] When the solder joint material or material thickness information is missing, the parameter specification function will not be selected, but the if condition will be used to determine whether the solder joint material or material thickness information is missing;

[0093] The function that can distinguish the three-layer plate nugget diameter and the date writing method without error is defined by using the cell NumberFormatLocal;

[0094] The base plate thickness calculation uses the built-in function of Excel, which is defined using "Application.WorksheetFunction."

[0095] Specifically, the determination of whether there is any missing information about the material and thickness of the weld point, if there is no missing information, then finding the corresponding nugget diameter, pressure serial number and parameter serial number, and filling them into the connection information table, includes the following steps:

[0096] Arrange the reference plate thickness information used for nugget diameter selection, find the corresponding nugget diameter, and fill it into the connection information table.

[0097] Specifically, the determination of whether there is any missing information about the material and thickness of the weld point, if there is no missing information, then finding the corresponding nugget diameter, pressure serial number and parameter serial number, and filling them into the connection information table, includes the following steps:

[0098] According to the base plate thickness and the number of various material categories, find the pressure serial number and fill it in the connection information table.

[0099] Specifically, the determination of whether there is any missing information about the material and thickness of the weld point, if there is no missing information, then finding the corresponding nugget diameter, pressure serial number and parameter serial number, and filling them into the connection information table, includes the following steps:

[0100] According to the base plate thickness, the number of various material categories and the plate thickness ratio, find the parameter serial number and fill it into the connection information table.

[0101] Furthermore, the method further comprises the following steps:

[0102] Determine whether the soldering point number is empty, and if the soldering point number is not empty, terminate the operation.

[0103] Furthermore, it is determined whether there is any missing information about the material and thickness of the solder joint. If there is any missing information, it is determined whether the next solder joint number is empty.

[0104] 5 The technical solution of the embodiment of the present application has the following advantages:

[0105] First, since the continued calculation when the solder joint material or material thickness information is missing causes the parameter selection error, the problem of incorrect parameter selection in the prior art solution is solved by adding the if condition judgment of whether the solder joint material and material thickness are missing;

[0106] Second, since the nugget diameter cannot be generated and the nugget diameter of the three-layer plate is consistent with the date writing, an error will be reported. Based on the definition of the nugget diameter cell NumberFormatLocal, the problem is solved.

[0107] The existing technical solution cannot generate the nugget diameter and will report an error when the nugget diameter of the three-layer plate is consistent with the date writing method;

[0108] Third, since it is easier to calculate the base plate thickness using Excel's built-in functions, based on the use of

[0109] "Application.WorksheetFunction." defines the use of functions, solving the problem of not being able to use Excel functions in VBA in the prior art solution;

[0110] Fourthly, the operation method is simple and convenient, the time for parameter selection can be greatly shortened, and the data processing efficiency is significantly improved.

[0111] It should be noted that the step numbers of the steps in the embodiments of the present application do not limit the sequence of the operations in the technical solution of the present application.

[0112] Based on the same inventive concept as the method embodiment, the embodiment of the present application provides a parameter selection device, which includes:

[0113] The information table preprocessing module is used to select the connection information table that needs to be supplemented with parameters, count the number of data rows to be processed, and clear the content of the parameter to be selected area;

[0114] The basic parameter acquisition module is used to determine whether the solder joint number is empty. If the solder joint number is not empty, the material category corresponding to the material information and the presence or absence of coating information are found based on the material information corresponding to the solder joint, and the material category and the number of coated plates corresponding to the solder joint in the connection information table are filled in;

[0115] The calculation method acquisition module is used to select the plate thickness corresponding to the welding point, combine the statistics of the number of various material categories, define the calculation method of the number of overlapping layers, the reference plate thickness and the total plate thickness, and fill in the corresponding calculation results in the connection information table;

[0116] The parameter supplement module is used to determine whether there is any missing information about the material and thickness of the weld. If there is no missing information, the corresponding weld core diameter, pressure serial number and parameter serial number are found and filled in the connection information table.

[0117] It should be noted that in the prior art, when selecting parameters, the vlookup, if, index and match functions provided by Excel are often used to sort out the material category of the solder joint, the presence or absence of coating, the number of overlapping layers of the plate, the reference plate thickness, the total plate thickness, the parameter sequence and the pressure sequence. The existing scheme has not been adjusted according to the parameter selection specifications released by the company, and there are the following problems: First, the calculation of the weld core diameter is missing, and the information is supplemented by manual sorting; second, the reference plate thickness judgment does not take into account the clause in the standard that "when the thickness of any two layers of the three-layer plate is the same, the same plate thickness is taken as the reference plate thickness", and the calculation of the reference plate thickness of the three-layer plate is distorted; third, the parameter sequence and pressure sequence are inconsistent with the standard, resulting in distortion of the selection parameters of some solder joints.

[0118] Furthermore, the existing technical solutions still have the following technical defects:

[0119] First, when the material or thickness information of the weld is missing, the existing solutions will mostly calculate according to the two-layer board to obtain the wrong weld core diameter, parameter sequence and pressure sequence. It is necessary to implement a function that will not continue to select parameter specifications when information is missing.

[0120] Secondly, the existing solution lacks the function of supplementing the weld core diameter, and when the writing method of the weld core diameter of the three-layer plate is consistent with the writing method of the date, the system defaults to the date, and the information is wrong. It is necessary to realize the function of automatically supplementing the weld core diameter and being able to distinguish and not report an error when the writing method of the weld core diameter of the three-layer plate is consistent with the date.

[0121] Third, the calculation of the benchmark plate thickness is relatively simple using the Excel built-in function roundup & min, but VBA cannot be written directly in the Excel formula format and requires the use of Excel built-in function functionality.

[0122] In an embodiment of the present application, when the welding point parameter information is missing, the parameter information is supplemented based on the relevant information of the connection information table of the information to be supplemented, combined with the preset calculation method of different parameters, to ensure the smooth progress of the spot welding work and provide convenience for the daily production work of the vehicle.

[0123] The technical solution of the embodiment of the present application has the following characteristics:

[0124] When the solder joint material or material thickness information is missing, the parameter specification function will not be selected, but the if condition will be used to determine whether the solder joint material or material thickness information is missing;

[0125] The function that can distinguish the three-layer plate nugget diameter and the date writing method without error is defined by using the cell NumberFormatLocal;

[0126] The base plate thickness calculation uses the built-in function of Excel, which is defined using "Application.WorksheetFunction."

[0127] Furthermore, the parameter supplement module is also used to sort out the reference plate thickness information used for selecting the weld core diameter, find the corresponding weld core diameter, and fill it into the connection information table.

[0128] Furthermore, the parameter supplement module is also used to find the pressure serial number according to the reference plate thickness and the number of various material categories, and fill it into the connection information table.

[0129] Furthermore, the parameter supplement module is also used to find the parameter serial number according to the reference plate thickness, the number of various material categories and the plate thickness ratio, and fill it into the connection information table.

[0130] Furthermore, the basic parameter acquisition module is also used to determine whether the welding point number is empty, and if the welding point number is not empty, the operation is terminated.

[0131] Specifically, the parameter supplement module is also used to determine whether there is any missing information about the material and thickness of the welding point. If there is any missing information, it is determined whether the next welding point number is empty.

[0132] The technical solution of the embodiment of the present application has the following advantages:

[0133] First, since the continued calculation when the solder joint material or material thickness information is missing causes the parameter selection error, the problem of incorrect parameter selection in the prior art solution is solved by adding the if condition judgment of whether the solder joint material and material thickness are missing;

[0134] Second, since the nugget diameter cannot be generated and an error message will be displayed when the nugget diameter of the three-layer plate is consistent with the date writing method, the problem that the nugget diameter cannot be generated and an error message will be displayed when the nugget diameter of the three-layer plate is consistent with the date writing method in the prior art solution is solved based on the definition of the nugget diameter cell NumberFormatLocal;

[0135] Thirdly, since it is easier to use the built-in function of Excel to calculate the reference plate thickness, the problem that the Excel function cannot be used in VBA in the prior art solution is solved based on the use of "Application.WorksheetFunction." to define the use function;

[0136] Fourthly, the operation method is simple and convenient, the time for parameter selection can be greatly shortened, and the data processing efficiency is significantly improved.

[0137] It should be noted that the parameter selection device provided in the embodiment of the present application, and its corresponding technical problems, technical means and technical effects are similar to the principles of the parameter selection method in terms of principle.

[0138] 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.

[0139] 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 parameter selection method, characterized in that: The method comprises the following steps: Select the connection information table that needs to supplement parameters, count the number of data rows to be processed, and clear the content of the parameter to be selected area; Determine whether the solder joint number is empty. If the solder joint number is not empty, then based on the material information corresponding to the solder joint, find the material category corresponding to the material information and whether there is coating information, and fill in the material category and the number of coated plates corresponding to the solder joint in the connection information table; Select the plate thickness corresponding to the welding point, combine the statistics of the number of various material categories, define the calculation method of the number of overlapping layers, the base plate thickness and the total plate thickness, and fill in the corresponding calculation results in the connection information table; Determine whether there is any missing information about the material and thickness of the weld. If there is no missing information, find the corresponding nugget diameter, pressure serial number and parameter serial number and fill them in the connection information table; among them, The method of judging whether there is any missing information about the material and thickness of the welding spot, and if there is no missing information, finding the corresponding nugget diameter, pressure serial number and parameter serial number, and filling them into the connection information table, includes the following steps: Arrange the reference plate thickness information used for nugget diameter selection, find the corresponding nugget diameter, and fill it in the connection information table; The method of judging whether there is any missing information about the material and thickness of the welding spot, and if there is no missing information, finding the corresponding nugget diameter, pressure serial number and parameter serial number, and filling them into the connection information table, includes the following steps: Find the pressure serial number according to the base plate thickness and the number of various material types, and fill it in the connection information table; The method of judging whether there is any missing information about the material and thickness of the welding spot, and if there is no missing information, finding the corresponding nugget diameter, pressure serial number and parameter serial number, and filling them into the connection information table, includes the following steps: According to the base plate thickness, the number of various material categories and the plate thickness ratio, find the parameter serial number and fill it in the connection information table.

2. The parameter selection method according to claim 1, characterized in that: The method further comprises the following steps: Determine whether the soldering point number is empty, and if the soldering point number is not empty, terminate the operation.

3. The parameter selection method according to claim 2, characterized in that: The method further comprises the following steps: Determine whether there is any missing information about the material and thickness of the solder joint. If there is any missing information, determine whether the next solder joint number is empty.

4. A parameter selection device, characterized in that: The device comprises: The information table preprocessing module is used to select the connection information table that needs to be supplemented with parameters, count the number of data rows to be processed, and clear the content of the parameter to be selected area; The basic parameter acquisition module is used to determine whether the solder joint number is empty. If the solder joint number is not empty, the material category corresponding to the material information and the presence or absence of coating information are found based on the material information corresponding to the solder joint, and the material category and the number of coated plates corresponding to the solder joint in the connection information table are filled in; The calculation method acquisition module is used to select the plate thickness corresponding to the welding point, combine the statistics of the number of various material categories, define the calculation method of the number of overlapping layers, the reference plate thickness and the total plate thickness, and fill in the corresponding calculation results in the connection information table; The parameter supplement module is used to determine whether there is any missing information about the material and thickness of the welding point. If there is no missing information, the corresponding nugget diameter, pressure serial number and parameter serial number are found and filled in the connection information table; The parameter supplement module is also used to sort out the reference plate thickness information used for selecting the nugget diameter, find the corresponding nugget diameter, and fill it into the connection information table; The parameter supplement module is also used to find the pressure sequence number according to the reference plate thickness and the number of various material categories, and fill it into the connection information table; The parameter supplement module is also used to find the parameter serial number according to the reference plate thickness, the number of various material categories and the plate thickness ratio, and fill it into the connection information table.

Images