A research method for the effect of door sealing strip aging on door closing force

Abstract

The present invention discloses a method for studying the influence of the aging of a vehicle door sealing strip on the closing force, which specifically comprises the following steps: selecting n vehicles, obtaining the initial minimum closing force of each vehicle, and recording the corresponding sealing strip aging time; measuring the closing force once every 24 hours, and recording the minimum closing force and the corresponding sealing strip aging time of each vehicle in turn; and calculating the closing force of each vehicle according to the P value. nm =F nm / F n1 , get the closing force aging percentage array; use the least squares LINEST function to calculate P nm Arrays and T nm The array is fitted with the best straight line y = kx + b; the aging percentage Fa% of the minimum closing force over time is calculated, and the Fa% variation curve over time T is plotted; the final percentage f of the curve is measured; according to F g =F 标 / f, calculate the control standard F of the door closing force when the vehicle is off the line g The present invention can accurately study the change curve of the door closing force aging percentage from the time a vehicle rolls off the production line to the time it is delivered to the customer, thereby enabling more accurate management and control from the production end to ensure that the vehicle meets the user's requirements when it is delivered to the user.

Description

Technical Field

[0001] The present invention relates to the technical field of automobile door closing, and in particular to a method for studying the influence of aging of a door sealing strip on the door closing force. Background Art

[0002] Car doors are the most frequently used components in daily life, requiring users to operate them every time they enter or exit the vehicle. As my country's automotive industry continues to improve, users are increasingly demanding a smooth and effortless door closing experience. Therefore, door closing force is closely related to user-perceived quality, and controlling this force is crucial for enhancing user-perceived quality and comfort.

[0003] Door sealing strips are a significant factor influencing door closing force. Due to their material properties, they gradually age over time, reducing their reaction force on the door and causing the door's closing force to fluctuate accordingly. Consequently, the closing force of a vehicle rolling off the production line differs from that of the vehicle delivered to the user. Only by studying the impact of sealing strip aging on closing force can we more accurately control it.

[0004] Currently, most project development focuses solely on the closing force of vehicles as they roll off the production line, lacking research into how this force changes with seal aging. This inability to accurately control closing force makes it impossible to ensure that vehicles meet user requirements when delivered. Summary of the Invention

[0005] The purpose of this invention is to provide a method for studying the effect of door sealing strip aging on closing force, thereby generating a curve showing how door closing force changes with sealing strip aging. Based on the closing force standard for aged sealing strips required for delivery to customers, the closing force standard for pre-aging sealing strips can be inferred. This method can be used for testing vehicles before they roll off the production line, facilitating quality control in vehicle production.

[0006] In order to achieve the above-mentioned object of the invention, the present invention provides a method for studying the effect of aging of a vehicle door sealing strip on the door closing force, which comprises:

[0007] S1: Select n vehicles to be studied, replace the new sealing strips, and obtain the initial minimum closing force F of each sample vehicle door 11 , F 21 ,……,F n1 ; and record the corresponding sealing strip aging time T during measurement 11 , T 21 ,……,T n1 ;

[0008] S2: Measure the door closing force every 24 hours and record the minimum door closing force F of each sample vehicle every day. 12, F 13 ,……,F 1m ; F 22 , F 23 ,……,F 2m ;……;F n2 , F n3 ,……,F nm ; and record the corresponding sealing strip aging time T 12 , T 13 ,……,T 1m ;T 22 , T 23 ,……,T 2m ;……;T n2 , T n3 ,……,T nm ; Get the sealing strip aging time array and the corresponding minimum door closing force array of n sample vehicles;

[0009] S3: According to formula P nm =F nm / F n1 , get the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm , where n is the number of sample vehicles, m is the number of measurement days, P nm F is the aging percentage of the closing force of n sample vehicles after m days, nm F is the minimum door closing force of n sample vehicles for m days, n1 is the initial minimum door closing force of n sample vehicles;

[0010] S4: Use the least squares LINEST function to calculate P nm Arrays and T nm The array is fitted with the best straight line y = kx + b, and the array describing this line {k, b; se, se b ; r 2 ,se y ; F, d f ;ss reg , ss resid} or {k, b};

[0011] S5: Calculate the aging percentage Fa% of the minimum closing force over time according to the formula Fa%=k / (T+offset)+b, and draw a curve of Fa% changing with time T, where k is the slope of the optimal straight line, T is time, offset is the time offset, and b is the intercept of the optimal straight line;

[0012] S6: When it is found that the closing force percentage in the curve gradually levels off over time, the measurement is terminated and the aging percentage Fa% at this time is taken as the final closing force percentage of the sealing strip after aging, recorded as f;

[0013] S7: According to the formula, F g =F 标 / f, calculate the control standard F of the door closing force when the vehicle is off the line g , where F 标 The standards set for businesses that vehicles must meet when delivered to customers.

[0014] It can be seen from the above scheme that the research method of the present invention is based on monitoring the numerical value of the vehicle door closing force that changes with the aging of the sealing strip. Through data analysis and application of linear regression theory, a model of the door closing force that changes with the aging time of the sealing strip is established. The closing force standard of the sealing strip after aging is derived from the closing force standard when the sealing strip is not aged, which is used for vehicle offline management and control, to ensure the comfort of closing the door when the vehicle is delivered to the customer, improve the quality of the vehicle, and enhance the user experience. Before the present invention, there was no research on the impact of the aging of the sealing strip on the closing force of the vehicle door.

[0015] As an improvement of the research method of the present invention, the method further includes: obtaining the initial minimum door closing force F of each sample car door in S1 11 , F 21 ,……,F n1 for:

[0016] The minimum door closing force of each vehicle is measured in turn using a door closing force measuring device to obtain the minimum door closing force.

[0017] As an improvement to the research method of the present invention, the method further includes: using the door closing force measuring device to sequentially measure the minimum door closing force of each vehicle, thereby obtaining the minimum door closing force specifically includes:

[0018] The closing force measuring device is respectively attached to the glass of the door being tested and the glass of the door opposite to the door being tested by suction cups at both ends. The door is manually opened at a small angle, and the value displayed on the door closing force measuring device is observed. The door is released and closed by the door closing force measuring device. If it is recorded that the door is not closed, the above steps are repeated to gradually increase the force value until the door can be closed. The above process is repeated, and the force value each time the door can be closed is recorded until two identical door closing forces are collected. This force value is used as the minimum door closing force.

[0019] From the above scheme, it can be seen that using the closing force measuring equipment to measure the minimum closing force will make the measurement results more accurate. The minimum closing force will be displayed on the force value display, making it easier for staff to read the reading.

[0020] As an improvement of the research method of the present invention, the method further includes: obtaining the initial minimum door closing force F of each sample car door in S1 11 , F 21 ,……,F n1 for:

[0021] Use the minimum closing speed or minimum closing energy to obtain the minimum closing force of the door, according to the formula E=F 2 / 2k'=mV 2 / 2, and the minimum door closing force is obtained, where E is the minimum door closing energy, F is the minimum door closing force, k' is the elastic coefficient of the door closing force measurement device, m is the mass of the door assembly, and V is the minimum door closing speed at the center of mass of the door.

[0022] As an improvement to the research method of the present invention, the method further includes: after obtaining the sealing strip aging time array and the corresponding minimum door closing force array of n sample vehicles in S2, the method further includes:

[0023] Set the sealing strip aging time array T 11 , T 12 ,……,T 1m ;T 21 , T 22 ,……,T 2m ;……;T n1 , T n2 ,……,T nm Array T is formed by column-major storage 11 , T 21 ,……,T n1 , T 12 , T 22 ,……,T n2 ,……,T 1m , T 2m ,……,T nm .

[0024] As can be seen from the above solution, the sealing strip aging time array is an n*m dimensional array. Subsequently, the LINEST function needs to be used to perform the best straight line fitting on the sealing strip aging time array. Multidimensional arrays cannot be input into the LINEST function, so the n*m ​​dimensional array must first be stored into an nm*1 dimensional array through column-first storage to facilitate the processing of the LINEST function.

[0025] As an improvement of the research method of the present invention, the method further includes: in S3 according to the formula P nm =F nm / F n1 , get the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm After that, it also includes:

[0026] Set the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm The array P is formed by column-first storage 11 , P 21 ,……,P n1 , P 12 , P 22 ,……,P n2 ,……,P 1m , P 2m ,……,P nm .

[0027] As can be seen from the above solution, the aging percentage array is an n*m-dimensional array. The LINEST function will be used to perform the best straight line fit on the aging percentage array. The LINEST function cannot input multidimensional arrays, so the n*m-dimensional array must first be stored as an nm*1-dimensional array using column-major storage to facilitate processing by the LINEST function.

[0028] As an improvement of the research method of the present invention, the method further includes: using the least squares LINEST function in S4 to calculate P nm and Tnm The array composed of the best straight line y=kx+b fitting specifically includes:

[0029] Enter known_y's into P in the LINEST function LINEST([known_y's], [known_x's], [const], [stats]) 11 , P 21 ,……,P n1 , P 12 , P 22 ,……,P n2 ,……,P 1m , P 2m ,……,P nm array;

[0030] Input known_x's in LINEST function LINEST([known_y's], [known_x's], [const], [stats]) into T 11 , T 21 ,……,T n1 , T 12 , T 22 ,……,T n2 ,……,T 1m , T 2m ,……,T nm array;

[0031] Set const to "TURE" in the LINEST function LINEST([known_y's], [known_x's], [const], [stats]);

[0032] Set stats to "TURE" or "FALSE" in the LINEST function LINEST([known_y's], [known_x's], [const], [stats]);

[0033] Run the LINEST function and the returned array is {k, b; se, se b ; r 2 ,se y ; F, d f ;ss reg , ss resid} or {k, b}.

[0034] As can be seen from the above scheme, using the least squares method LINEST function to perform a univariate linear regression on the measured data is a common means of processing data in statistics. It is a statistical analysis method for studying the dependence of a random variable y on another (x) or a group of (x1, x2, ..., xn) variables, where y is called the dependent variable, i.e., known_y's in the LINEST function, and x is called the independent variable, i.e., known_x's in the LINEST function. y changes because of the change of x. In the present invention, the aging percentage is obtained based on the ratio between the minimum closing forces. The minimum closing force changes with time. Therefore, the aging percentage changes with time. Therefore, known_y's inputs the aging percentage and known_x's inputs the time; setting the value of const to TRUE can ensure that the value of b is calculated in the usual way. stats is optional. When it is set to TRUE, more parameters are returned than when it is set to FALSE. In the present invention, setting it to TRUE or FALSE can ensure that the next steps are carried out accurately.

[0035] As an improvement of the research method of the present invention, the method further includes: in S3 according to the formula P nm =F nm / F n1 , get the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm After that, it also includes:

[0036] Set the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm P in 11 , P 21 ,……,P n1 Set the value of 100%.

[0037] It can be seen from the above scheme that the value of the closing force aging percentage must be calculated through the formula. In the present invention, it is known that P 11 , P 21 ,……,P n1The value of is 100%. Setting it to 100% in advance can reduce the workload of calculation and improve the efficiency of calculation.

[0038] As an improvement of the research method of the present invention, the method further includes: using the least squares LINEST function in S4 to calculate P nm Arrays and T nm The array is fitted with the best straight line y=kx+b:

[0039] Use the LINEST function tool in Excel to fit the best straight line y=kx+b.

[0040] As an improvement to the research method of the present invention, the method further includes: in S5, according to the formula Fa%=k / (T+offset)+b, calculating the aging percentage Fa% of the minimum closing force over time, and drawing a curve of Fa% changing with time T as follows:

[0041] Use the scatter chart in Excel to draw the curve of Fa% changing with time T.

[0042] It can be seen from the above scheme that the present invention uses Excel to process data and uses Excel tools to draw images. Excel is mature and easy to operate. Using Excel to process related data can improve our efficiency in data processing.

[0043] Compared with the prior art, the research method of the present invention on the influence of aging of vehicle door sealing strips on door closing force has the following beneficial effects: the present invention focuses on the influence of aging of vehicle door sealing strips on door closing force, and multiple sample vehicles are measured in the experiment. The measurement data is credible, and the LINEST function is used to perform the best straight line fitting on the measured data, and the change curve of the aging percentage of the vehicle door closing force from the time the vehicle rolls off the production line to the time it is delivered to the customer is accurately studied, so that more accurate management and control can be carried out from the production end to ensure that the door closing force meets the user's requirements when the vehicle is delivered to the user, thereby improving the quality of the vehicle and enhancing the user's experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for use in the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0045] Figure 1 This is a flow chart of a method for studying the effect of aging of a vehicle door sealing strip on door closing force according to the present invention;

[0046] Figure 2It is a trend diagram of the closing force aging percentage changing with aging time according to the present invention. DETAILED DESCRIPTION

[0047] The embodiments of the present invention are described in detail below. The embodiments described with reference to the accompanying drawings are exemplary. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0048] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by those skilled in the art to which this invention pertains. The terms used in this specification of the present invention are for the purpose of describing specific embodiments only and are not intended to limit the present invention. The term "and / or" as used herein includes any and all combinations of one or more of the associated listed items.

[0049] This embodiment provides a method for studying and analyzing the effect of aging of a vehicle door sealing strip on the door closing force. Figure 1 As shown, the specific steps include:

[0050] Step S1: select n vehicles to be studied, replace the new sealing strips, and obtain the initial minimum closing force F of each sample vehicle door. 11 , F 21 ,……,F n1 ; and record the corresponding sealing strip aging time T during measurement 11 , T 21 ,……,T n1 .

[0051] Place n vehicles to be studied on the same flat ground and replace the sealing strips of n vehicles to be studied with new ones to ensure that the aging degree of the sealing strips is the same. This ensures that the external environmental factors are consistent during the measurement and will not affect the measurement results. The initial minimum closing force F 11 , F 21 ,……,F n1 is the minimum door closing force of each sample vehicle when measured on the first day. n1 It represents the initial minimum closing force of the nth sample car on the first day of measurement, and the corresponding sealing strip aging time is T n1 , which represents the aging time of the sealing strip of the nth sample vehicle when measured on the first day.

[0052] In step S1, the minimum door closing force F of each sample car door is obtained. 11 , F 21 ,……,F n1 The method is to use a door closing force measuring device to measure the minimum door closing force of each vehicle in turn, thereby obtaining the minimum door closing force.

[0053] The process of obtaining the minimum closing force by the door closing force measurement device specifically includes:

[0054] The closing force measuring device is respectively attached to the glass of the door being tested and the glass of the door opposite to the door being tested by suction cups at both ends. The door is manually opened at a small angle, and the value displayed on the door closing force measuring device is observed. The door is released and closed by the door closing force measuring device. If it is recorded that the door is not closed, the above steps are repeated to gradually increase the force value until the door can be closed. The above process is repeated, and the force value each time the door can be closed is recorded until two identical door closing forces are collected. This force value is used as the minimum door closing force.

[0055] It's important to note that the door closing force measurement device consists of a dynamometer, a force indicator, a spring, a chain, and two suction cups. One suction cup is attached to the glass opposite the door being measured, and the other suction cup is attached to the glass of the door being measured. The components are connected in this order: opposite door glass, suction cup, chain, spring, dynamometer, force indicator, chain, suction cup, and door being measured.

[0056] In step S1, the minimum door closing force F of each sample car door is obtained. 11 , F 21 ,……,F n1 You can also use the minimum closing speed or minimum closing energy to obtain the minimum closing force of the door, according to the formula E=F 2 / 2k'=mV 2 / 2, and the minimum door closing force is obtained, where E is the minimum door closing energy, F is the minimum door closing force, k' is the elastic coefficient of the door closing force measurement device, m is the mass of the door assembly, and V is the minimum door closing speed at the center of mass of the door.

[0057] The minimum door closing energy, E, is the minimum energy required to move from the door's open position to its closed position. The smaller this value, the easier the door is to close. The minimum door closing speed, V, is the minimum closing speed at the door's center of mass. Different door shapes and opening methods can lead to slight variations in closing speed at different door positions. The minimum closing speed at the door's center of mass is the most accurate, improving test accuracy. The minimum closing speed at the door's center of mass can be measured using measuring equipment.

[0058] Step S2: measure the door closing force every 24 hours and record the minimum door closing force F of each sample vehicle every day. 12 , F 13 ,……,F 1m ; F 22 , F 23 ,……,F 2m ;……;F n2 , F n3,……,F nm ; and record the corresponding sealing strip aging time T 12 , T 13 ,……,T 1m ;T 22 , T 23 ,……,T 2m ;……;T n2 , T n3 ,……,T nm ; Get the minimum door closing force array corresponding to the aging time of the sealing strip of n sample vehicles.

[0059] Among them, F 12 , F 13 ,……,F 1m ; F 22 , F 23 ,……,F 2m ;……;F n2 , F n3 ,……,F nm is the measurement results of n sample vehicles from the 2nd day to the mth day, where F 12 , F 13 ,……,F 1m The minimum door closing force recorded for the first prototype from the second day to the mth day, F n2 , F n3 ,……,F nm T is the minimum door closing force record of the nth sample car from the 2nd day to the mth day, 12 , T 13 ,……,T 1m ;T 22 , T 23 ,……,T 2m ;……;T n2 , T n3 ,……,T nm is the aging time record of n sample vehicles from the 2nd day to the mth day, where T 12 , T 13 ,……,T 1m T is the aging time record of the sealing strip of the first prototype from the 2nd day to the mth day. n2 , T n3 ,……,T nm The sealing strip aging time of the nth sample car from the 2nd day to the mth day is recorded, and the minimum door closing force array corresponding to the sealing strip aging time of n sample cars is obtained as shown in Table 1:

[0060] Table 1 Minimum door closing force array corresponding to the aging time of the sealing strip for n sample vehicles

[0061] Sample No. 1

[0062] Sealing strip aging time T <![CDATA[T 11 ]]> <![CDATA[T 12 ]]> <![CDATA[T 13 ]]> <![CDATA[T 14 ]]> <![CDATA[T 15 ]]> <![CDATA[T 16 ]]> …… <![CDATA[T 1m ]]> Minimum closing force F <![CDATA[F 11 ]]> <![CDATA[F 12 ]]> <![CDATA[F 13 ]]> <![CDATA[F 14 ]]> <![CDATA[F 15 ]]> <![CDATA[F 16 ]]> …… <![CDATA[F 1m ]]>

[0063] Sample No. 2

[0064] Sealing strip aging time T <![CDATA[T 21 ]]> <![CDATA[T 22 ]]> <![CDATA[T 23 ]]> <![CDATA[T 24 ]]> <![CDATA[T 25 ]]> <![CDATA[T 26 ]]> …… <![CDATA[T 2m ]]> Minimum closing force F <![CDATA[F 21 ]]> <![CDATA[F 22 ]]> <![CDATA[F 23 ]]> <![CDATA[F 24 ]]> <![CDATA[F 25 ]]> <![CDATA[F 26 ]]> …… <![CDATA[F 2m ]]>

[0065] …

[0066] Sample number n

[0067] Sealing strip aging time T <![CDATA[T n1 ]]> <![CDATA[T n2 ]]> <![CDATA[T n3 ]]> <![CDATA[T n4 ]]> <![CDATA[T n5 ]]> <![CDATA[T n6 ]]> …… <![CDATA[T nm ]]> Minimum closing force F <![CDATA[F n1 ]]> <![CDATA[F n2 ]]> <![CDATA[F n3 ]]> <![CDATA[F n4 ]]> <![CDATA[F n5 ]]> <![CDATA[F n6 ]]> …… <![CDATA[F nm ]]>

[0068] Furthermore, the minimum door closing force array T in step S2 11 , T 12 ,……,T 1m ;T 21 , T 22 ,……,T 2m ;……;T n1 , T n2 ,……,T nm Array T is formed by column-major storage 11 , T 21 ,……,T n1 , T 12 , T 22 ,……,T n2 ,……,T 1m , T 2m ,……,T nm .

[0069] The sealing strip aging time array is an n*m-dimensional array. The LINEST function will be used to perform a best straight line fit on the sealing strip aging time array. The LINEST function cannot accept multidimensional arrays, so the n*m-dimensional array must first be stored as an nm*1-dimensional array using column-major storage to facilitate LINEST function processing.

[0070] Step S3, according to formula P nm =F nm / F n1 , get the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm , where n is the number of sample vehicles, m is the number of measurement days, P nm F is the aging percentage of the closing force of n sample vehicles after m days, nm F is the minimum door closing force of n sample vehicles for m days, n1is the initial minimum door closing force of n sample vehicles on the first day. For example, the minimum door closing force F of sample vehicle No. 1 measured on the first day is 11 =100N. On the second day, due to the aging of the sealing strip, the minimum closing force F was measured. 12 =95N, then P 12 = F 12 / F 11 =100N / 95N=0.95=95%.

[0071] Furthermore, the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm P in 11 , P 21 ,……,P n1 The value of is set to 100%, and the aging percentage of all sample vehicles on the first day is set to 100%, which means that the sealing strip has not aged, the closing force remains unchanged, and the closing force aging percentage is 100%.

[0072] The records of the sealing strip aging time, minimum closing force and aging percentage of the sample vehicle are shown in Table 2:

[0073] Table 2 Record of sealing strip aging time, minimum closing force and aging percentage

[0074] Sample No. 1

[0075] Sealing strip aging time T <![CDATA[T 11 ]]> <![CDATA[T 12 ]]> <![CDATA[T 13 ]]> <![CDATA[T 14 ]]> <![CDATA[T 15 ]]> <![CDATA[T 16 ]]> …… <![CDATA[T 1m ]]> Minimum closing force F <![CDATA[F 11 ]]> <![CDATA[F 12 ]]> <![CDATA[F 13 ]]> <![CDATA[F 14 ]]> <![CDATA[F 15 ]]> <![CDATA[F 16 ]]> …… <![CDATA[F 1m ]]> Closing force aging percentage <![CDATA[P 11 ]]> <![CDATA[P 12 ]]> <![CDATA[P 13 ]]> <![CDATA[P 14 ]]> <![CDATA[P 15 ]]> <![CDATA[P 16 ]]> …… <![CDATA[P 1m ]]>

[0076] Sample No. 2

[0077] Sealing strip aging time T <![CDATA[T 21 ]]> <![CDATA[T 22 ]]> <![CDATA[T 23 ]]> <![CDATA[T 24 ]]> <![CDATA[T 25 ]]> <![CDATA[T 26 ]]> …… <![CDATA[T 2m ]]> Minimum closing force F <![CDATA[F 21 ]]> <![CDATA[F 22 ]]> <![CDATA[F 23 ]]> <![CDATA[F 24 ]]> <![CDATA[F 25 ]]> <![CDATA[F 26 ]]> …… <![CDATA[F 2m ]]> Closing force aging percentage <![CDATA[P 21 ]]> <![CDATA[P 22 ]]> <![CDATA[P 23 ]]> <![CDATA[P 24 ]]> <![CDATA[P 25 ]]> <![CDATA[P 26 ]]> …… <![CDATA[P 2m ]]>

[0078] …

[0079] Sample number n

[0080] Sealing strip aging time T <![CDATA[T n1 ]]> <![CDATA[T n2 ]]> <![CDATA[T n3 ]]> <![CDATA[T n4 ]]> <![CDATA[T n5 ]]> <![CDATA[T n6 ]]> …… <![CDATA[T nm ]]> Minimum closing force F <![CDATA[F n1 ]]> <![CDATA[F n2 ]]> <![CDATA[F n3 ]]> <![CDATA[F n4 ]]> <![CDATA[F n5 ]]> <![CDATA[F n6 ]]> …… <![CDATA[F nm ]]> Closing force aging percentage <![CDATA[P n1 ]]> <![CDATA[P n2 ]]> <![CDATA[P n3 ]]> <![CDATA[P n4 ]]> <![CDATA[P n5 ]]> <![CDATA[P n6 ]]> …… <![CDATA[P nm ]]>

[0081] Furthermore, the aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nmThe array P is formed by column-first storage 11 , P 21 ,……,P n1 , P 12 , P 22 ,……,P n2 ,……,P 1m , P 2m ,……,P nm .

[0082] The aging percentage array is an n*m-dimensional array. The LINEST function will be used to perform a best-fit straight line fit on the aging percentage array. The LINEST function cannot accept multidimensional arrays, so the n*m-dimensional array must first be converted to an nm*1-dimensional array using column-major storage to facilitate LINEST function processing.

[0083] Step S4, use the least squares LINEST function to calculate P nm Arrays and T nm The array is fitted with the best straight line y = kx + b, and the array describing this line {k, b; se, se b ; r 2 ,se y ; F, d f ;ss reg , ss resid} or {k, b}, the specific method is as follows:

[0084] Step S41, input known_y's in LINEST function LINEST([known_y's], [known_x's], [const], [stats]) into P 11 , P 21 ,……,P n1 , P 12 , P 22 ,……,P n2 ,……,P 1m , P 2m ,……,P nm array.

[0085] Step S42: Input known_x's in LINEST function LINEST([known_y's], [known_x's], [const], [stats]) into T 11 , T 21 ,……,T n1 , T 12 , T 22 ,……,T n2 ,……,T 1m , T 2m,……,T nm array.

[0086] Step S43, setting const in the LINEST function LINEST([known_y's], [known_x's], [const], [stats]) to "TURE" so that b in the relational expression y=kx+b is calculated normally.

[0087] Step S44, setting stats in the LINEST function LINEST([known_y's], [known_x's], [const], [stats]) to "TURE" or "FALSE".

[0088] Step S45, run the LINEST function and return the array {k, b; se, se b ; r 2 ,se y ; F, d f ;ss reg , ss resid} or {k, b}, the elements in the returned array and the meanings of each element are shown in Table 3 and Table 4:

[0089] Table 3 Returns the elements of the array

[0090] k b se <![CDATA[se b ]]> <![CDATA[r 2 ]]> <![CDATA[se y ]]> F df <![CDATA[ss reg ]]> <![CDATA[ss resid ]]>

[0091] Table 4 Meaning of each element

[0092] k The slope of the linear equation y = kx + b. b A constant in the linear formula y = kx + b. se is the standard error value of coefficient k. <![CDATA[se b ]]> The standard error of the constant b. <![CDATA[r 2 ]]> Coefficient of determination. This is the ratio of the estimated value of y to the actual value, and ranges from 0 to 1. If it is 1, the samples are well correlated, and there is no difference between the estimated and actual values ​​of y. Conversely, if the coefficient of determination is 0, the regression formula cannot be used to predict the value of y. <![CDATA[se y ]]> The standard error of the estimate of Y. F F-statistic or F-observed. Use the F-statistic to determine whether the observable relationship between the dependent and independent variables occurs by chance. df degrees of freedom. Used to find the F critical value in a statistical table. Compare the value found in the table with the F statistic returned by the LINEST function to determine the confidence interval for the model. <![CDATA[ss reg ]]> Regression sum of squares. <![CDATA[ss resid ]]> Residual sum of squares.

[0093] It should be noted that when stats is set to "FALSE" in the LINEST function LINEST([known_y's], [known_x's], [const], [stats]) so that the LINEST function returns other regression statistics, the returned regression statistics array is {k, b}.

[0094] By setting stats to "TURE", many linear regression elements are returned, including various error values ​​and values ​​of other elements. This provides more references for staff in actual calculations.

[0095] Use the LINEST function tool in Excel to fit the best straight line y=kx+b.

[0096] Step S5: Calculate the aging percentage Fa% of the minimum closing force over time according to the formula Fa%=k / (T+offset)+b, and plot a curve of Fa% versus time T, where k is the slope of the optimal straight line, T is time, offset is the time offset, and b is the intercept of the optimal straight line.

[0097] Using the scatter chart in Excel to draw F a The relationship curve of % changing with time T is shown in the attached figure. Figure 2 shown.

[0098] Step S6, observing the curve. When it is found that the aging percentage of the closing force in the curve gradually levels off over time, the measurement is terminated. The aging percentage at this time is used as the final closing force percentage of the sealing strip after aging, recorded as f.

[0099] Step S7, according to the formula, F g =F 标 / f, calculate the control standard F of the door closing force when the vehicle is off the line g , where F 标 The standards set for businesses that vehicles must meet when delivered to customers.

[0100] Throughout this specification, reference to terms such as "one embodiment," "some embodiments," "illustrative embodiments," "example," "specific example," or "some examples" means that a specific feature, structure, material, or characteristic described in conjunction with the embodiment or example is included in at least one embodiment or example of the present invention. In this specification, illustrative expressions of the above terms do not necessarily refer to the same embodiment or example.

[0101] Obviously, the described embodiments are only some of the embodiments of the present application, rather than all of the embodiments. Mentioning "embodiment" in this article means that the specific features, structures or characteristics described in conjunction with the embodiment may be included in at least one embodiment of the present embodiment application. The appearance of this phrase in various positions in the specification does not necessarily mean that they are all the same embodiments, nor are they independent or alternative embodiments that are mutually exclusive with other embodiments. It can be understood explicitly and implicitly by those skilled in the art that the embodiments described herein can be combined with other embodiments. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art without making creative work are within the scope of protection of this application.

[0102] While embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions, and variations may be made to the embodiments without departing from the principles and spirit of the invention, and that the scope of the invention is defined by the claims and their equivalents.

Claims

1. A method for studying the effect of aging of vehicle door sealing strips on door closing force, characterized in that: Specifically include: S1: Select n vehicles to be studied, replace the new sealing strips, and obtain the initial minimum closing force F of each sample vehicle door 11 , F 21 ,……,F n1 ; and record the corresponding sealing strip aging time T during measurement 11 , T 21 ,……,T n1 ; S2: Measure the door closing force every 24 hours and record the minimum door closing force F of each sample vehicle every day. 12 , F 13 ,……,F 1m ; F 22 , F 23 ,……,F 2m ;……;F n2 , F n3 ,……,F nm ; and record the corresponding sealing strip aging time T 12 , T 13 ,……,T 1m ;T 22 , T 23 ,……,T 2m ;……;T n2 , T n3 ,……,T nm ; Get the sealing strip aging time array and the corresponding minimum door closing force array of n sample vehicles; S3: According to formula P nm =F nm / F n1 , get the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm , where n is the number of sample vehicles, m is the number of measurement days, P nm F is the aging percentage of the closing force of n sample vehicles after m days, nm F is the minimum door closing force of n sample vehicles for m days, n1 is the initial minimum door closing force of n sample vehicles; S4: Use the least squares LINEST function to calculate P nm Arrays and T nm The array is fitted with the best straight line y = kx + b, and the array describing this line {k, b; se, se b ; r 2 ,se y ; F, d f ;ss reg , ss resid } or {k, b}; S5: Calculate the aging percentage Fa% of the minimum closing force over time according to the formula Fa%=k / (T+offset)+b, and draw a curve of Fa% changing with time T, where k is the slope of the optimal straight line, T is time, offset is the time offset, and b is the intercept of the optimal straight line; S6: When it is found that the closing force percentage in the curve gradually levels off over time, the measurement is terminated and the aging percentage Fa% at this time is taken as the final closing force percentage of the sealing strip after aging, recorded as f; S7: According to the formula, F g =F 标 / f, calculate the control standard F of the door closing force when the vehicle is off the line g , where F 标 The standards set for businesses that vehicles must meet when delivered to customers.

2. The research method according to claim 1, characterized in that The initial minimum closing force F of each sample car door is obtained in S1 11 , F 21 ,……,F n1 for: The minimum door closing force of each vehicle is measured in turn using a door closing force measuring device to obtain the minimum door closing force.

3. The research method according to claim 2, characterized in that The method of sequentially measuring the minimum door closing force of each vehicle using the door closing force measuring device to obtain the minimum door closing force specifically includes: The closing force measuring device is respectively attached to the glass of the door being tested and the glass of the door opposite to the door being tested by suction cups at both ends. The door is manually opened at a small angle, and the value displayed on the door closing force measuring device is observed. The door is released and closed by the door closing force measuring device. If it is recorded that the door is not closed, the above steps are repeated to gradually increase the force value until the door can be closed. The above process is repeated, and the force value each time the door can be closed is recorded until two identical door closing forces are collected. This force value is used as the minimum door closing force.

4. The research method according to claim 1, characterized in that The initial minimum closing force F of each sample car door is obtained in S1 11 , F 21 ,……,F n1 for: Use the minimum closing speed or minimum closing energy to obtain the minimum closing force of the door, according to the formula E=F 2 / 2k'=mV 2 / 2, and the minimum door closing force is obtained, where E is the minimum door closing energy, F is the minimum door closing force, k' is the elastic coefficient of the door closing force measurement device, m is the mass of the door assembly, and V is the minimum door closing speed at the center of mass of the door.

5. The research method according to claim 1, characterized in that After obtaining the sealing strip aging time array and the corresponding minimum door closing force array of n sample vehicles in S2, the following steps are also included: Set the sealing strip aging time array T 11 , T 12 ,……,T 1m ;T 21 , T 22 ,……,T 2m ;……;T n1 , T n2 ,……,T nm Array T is formed by column-major storage 11 , T 21 ,……,T n1 , T 12 , T 22 ,……,T n2 ,……,T 1m , T 2m ,……,T nm .

6. The research method according to claim 5, characterized in that In S3, according to the formula P nm =F nm / F n1 , get the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm After that, it also includes: Set the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm The array P is formed by column-first storage 11 , P 21 ,……,P n1 , P 12 , P 22 ,……,P n2 ,……,P 1m , P 2m ,……,P nm .

7. The research method according to claim 6, characterized in that The least squares method LINEST function is used in S4 to calculate P nm and T nm The array composed of the best straight line y=kx+b fitting specifically includes: Enter known_y's into P in the LINEST function LINEST([known_y's], [known_x's], [const], [stats]) 11 , P 21 ,……,P n1 , P 12 , P 22 ,……,P n2 ,……,P 1m , P 2m ,……,P nm array; Input known_x's in LINEST function LINEST([known_y's], [known_x's], [const], [stats]) into T 11 , T 21 ,……,T n1 , T 12 , T 22 ,……,T n2 ,……,T 1m , T 2m ,……,T nm array; Set const to "TURE" in the LINEST function LINEST([known_y's], [known_x's], [const], [stats]); Set stats to "TURE" or "FALSE" in the LINEST function LINEST([known_y's], [known_x's], [const], [stats]); Run the LINEST function and the returned array is {k, b; se, se b ; r 2 ,se y ; F, d f ;ss reg , ss resid } or {k, b}.

8. The research method according to claim 1, characterized in that In S3, according to the formula P nm =F nm / F n1 , get the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm After that, it also includes: Set the closing force aging percentage array P 11 , P 12 ,……,P 1m ;P 21 , P 22 ,……,P 2m ;……;P n1 , P n2 ,……,P nm P in 11 , P 21 ,……,P n1 Set the value of 100%.

9. The research method according to claim 1, characterized in that The least squares method LINEST function is used in S4 to calculate P nm Arrays and T nm The array is fitted with the best straight line y=kx+b: Use the LINEST function tool in Excel to fit the best straight line y=kx+b.

10. The research method according to claim 1, characterized in that In S5, the aging percentage Fa% of the minimum closing force over time is calculated according to the formula Fa%=k / (T+offset)+b, and a curve of Fa% changing over time T is plotted as follows: Use the scatter chart in Excel to draw the curve of Fa% changing with time T.

Images