Steering wheel center zone test data processing method, device, equipment and medium

Abstract

The application discloses a kind of steering wheel center area test data processing method, device, equipment and medium, belong to vehicle detection technical field.The method divides out first steering wheel angle data set, second steering wheel angle data set and lateral acceleration data set in each cycle of steering wheel angle and lateral acceleration in test data, and the value of the objective evaluation index of the vehicle dynamic performance of steering wheel center area corresponding to data set is automatically calculated by the calculation function in Excel, that is, yaw angular velocity minimum gain and yaw angular velocity average gain, maximum steering stiffness and average steering stiffness, steering wheel sensitivity and maximum torque gradient and other evaluation indexes.Can process a large number of test data at high speed, improve test efficiency, the value of the objective evaluation index of the vehicle dynamic performance of steering wheel center area is automatically calculated by the function in Excel, the result calculated is accurate and reliable, reduces error, improves the accuracy of vehicle dynamic performance objective evaluation.

Description

Technical Field

[0001] This invention relates to the field of vehicle testing technology, and in particular to a method, apparatus, equipment and medium for processing test data of the center area of ​​a steering wheel. Background Technology

[0002] Vehicle handling stability refers to the ability of a vehicle to travel in the direction specified by the driver through the steering system and steering wheels, without the driver feeling excessive tension or fatigue, and to resist external disturbances and maintain stable driving. Handling stability testing is an important component of vehicle performance testing. The steering wheel center area test, as the seventh test in handling stability evaluation, provides objective evaluation indicators of the vehicle's dynamic performance in the steering wheel center area.

[0003] In existing technologies, engineers need to manually process the test data obtained from steering wheel center zone tests and manually calculate the values ​​of evaluation indicators using the formulas for evaluation indicators. However, the amount of experimental data for the steering wheel center zone is large, the calculation process is complex, and the analysis process takes a long time, resulting in low test efficiency; moreover, manual calculation has a high margin of error, which can easily lead to inaccurate objective evaluation of vehicle dynamic performance. Summary of the Invention

[0004] In view of the above problems, the present invention is proposed to provide a method, apparatus, equipment and medium for processing test data of the steering wheel center area to overcome or at least partially solve the above problems. It can process a large amount of test data at high speed, improve test efficiency, and automatically calculate the value of the objective evaluation index of vehicle dynamic performance in the steering wheel center area through functions in Excel. The calculated results are accurate and reliable, reduce errors and improve the accuracy of objective evaluation of vehicle dynamic performance.

[0005] In a first aspect, the present invention provides a method for processing test data of the center area of ​​a steering wheel, the method comprising:

[0006] The lateral acceleration data, steering wheel angle data, steering wheel torque data, and yaw rate data generated in each cycle during the steering wheel center area test are obtained, and the steering wheel angle, yaw rate, steering wheel torque, and lateral acceleration are stored in an Excel file in a one-to-one correspondence.

[0007] Based on the steering wheel angle in the first steering wheel angle dataset, and the yaw rate, steering wheel torque and lateral acceleration corresponding to the first steering wheel angle dataset, calculate the minimum and average values ​​of the yaw rate gain, the maximum and average values ​​of the steering stiffness, and the steering wheel sensitivity corresponding to the first steering wheel angle dataset using functions in Excel;

[0008] Based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset, the average value of the yaw rate gain corresponding to the second steering wheel angle dataset is calculated using a function in Excel;

[0009] Based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset, the maximum value of the torque gradient corresponding to the lateral acceleration dataset is calculated using a function in Excel;

[0010] Each of the first steering wheel angle datasets consists of steering wheel angles within a corresponding period that fall between a first steering wheel angle threshold and a second steering wheel angle threshold. The second steering wheel angle dataset consists of steering wheel angles within the corresponding period that are greater than a third steering wheel angle threshold and less than a first steering wheel angle threshold, or greater than a second steering wheel angle threshold and less than a fourth steering wheel angle threshold. The yaw rate gain is the ratio of the yaw rate to the corresponding steering wheel angle. The steering stiffness is the ratio of the steering wheel torque to the corresponding steering wheel angle. Each of the lateral acceleration datasets consists of lateral accelerations within a corresponding period that fall between a first acceleration threshold and a second acceleration threshold. The torque gradient is the ratio of the steering wheel torque to the corresponding lateral acceleration.

[0011] Optionally, the step of calculating the minimum and average values ​​of the yaw rate gain, the maximum and average values ​​of the steering stiffness, and the steering wheel sensitivity corresponding to the first steering wheel angle dataset using functions in Excel, based on the steering wheel angle in the first steering wheel angle dataset and the yaw rate, steering wheel torque, and lateral acceleration corresponding to the first steering wheel angle dataset, includes:

[0012] Based on the steering wheel angle in the first steering wheel angle dataset and the yaw rate corresponding to the first steering wheel angle dataset, calculate the first yaw rate gain corresponding to the first steering wheel angle dataset, and calculate the minimum and average values ​​of the first yaw rate gain using the min and average functions in Excel.

[0013] Based on the steering wheel angle in the first steering wheel angle dataset and the steering wheel torque corresponding to the first steering wheel angle dataset, the steering stiffness corresponding to the first steering wheel angle dataset is calculated, and the maximum and average values ​​of the steering stiffness are calculated using the ABS function, MAX function and AVERAGE function in Excel.

[0014] Based on the steering wheel angle in the first steering wheel angle dataset and the lateral acceleration corresponding to the first steering wheel angle dataset, the steering wheel sensitivity corresponding to the first steering wheel angle dataset is calculated using the linest, index, and average functions in Excel.

[0015] Optionally, the step of calculating the average value of the yaw rate gain corresponding to the second steering wheel angle dataset using a function in Excel, based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset, includes:

[0016] Based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset, the second yaw rate gain corresponding to the second steering wheel angle data is calculated, and the average value of the second yaw rate gain is calculated using the average function in Excel.

[0017] Optionally, the step of calculating the maximum value of the torque gradient corresponding to the lateral acceleration dataset using a function in Excel, based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset, includes:

[0018] Based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset, the torque gradient corresponding to the lateral acceleration dataset is calculated, and the maximum value of the torque gradient is calculated using the MAX and AVERAGE functions in Excel.

[0019] Optionally, the method further includes:

[0020] The maximum and minimum steering wheel angles in the steering wheel angle data are determined using the MAX and MIN functions in Excel, respectively.

[0021] Based on the maximum steering wheel angle and the minimum steering wheel angle, determine the first theoretical maximum value and the first theoretical minimum value of the steering wheel angle in the first steering wheel angle dataset, and the second theoretical maximum value and the second theoretical minimum value of the steering wheel angle in the second steering wheel angle dataset;

[0022] Based on the steering wheel angle data, the first theoretical maximum value, the first theoretical minimum value, the second theoretical maximum value, and the second theoretical minimum value, the first actual maximum value and the first actual minimum value of the steering wheel angle in the first steering wheel angle dataset, and the second actual maximum value and the second actual minimum value of the steering wheel angle in the second steering wheel angle dataset are determined using the small, ABS, and IF functions in Excel.

[0023] The first actual minimum value is used as the first corner threshold, the second actual maximum value is used as the second corner threshold, the second actual minimum value is used as the third corner threshold, and the second actual maximum value is used as the fourth corner threshold.

[0024] Optionally, determining the first actual maximum and first actual minimum value of the steering wheel angle in the first steering wheel angle dataset, and the second actual maximum and second actual minimum value of the steering wheel angle in the second steering wheel angle dataset, based on the steering wheel angle data, the first theoretical maximum value, the first theoretical minimum value, the second theoretical maximum value, and the second theoretical minimum value, using the SMOTO, ABS, and IF functions in Excel, includes:

[0025] The first actual maximum value is determined by using the small function, ABS function, and IF function in Excel to identify the steering wheel angle that deviates the least from the first theoretical maximum value among the steering wheel angle data.

[0026] The first actual minimum value is determined by using the small function, ABS function, and IF function in Excel to identify the steering wheel angle that deviates the least from the first theoretical minimum value among the steering wheel angle data.

[0027] The steering wheel angle that deviates the least from the second theoretical maximum value among the steering wheel angle data is determined by using the small function, ABS function and IF function in Excel;

[0028] The steering wheel angle that deviates the least from the second theoretical minimum value is determined using the SULTISE, ABS, and IF functions in Excel.

[0029] Optionally, the method further includes:

[0030] The target row number corresponding to each threshold is determined by the ROW function in Excel, and each steering wheel angle data corresponds to one row number in Excel;

[0031] Based on the target row number, the steering wheel angle in each first steering wheel angle dataset and the steering wheel angle in each second steering wheel angle dataset are determined using the INDIRECT function in Excel. The yaw rate, steering wheel torque, and lateral acceleration corresponding to the first steering wheel angle dataset, and the yaw rate corresponding to the second steering wheel angle dataset are also determined.

[0032] In a second aspect, the present invention provides a steering wheel center zone test data processing device, the device comprising:

[0033] The data acquisition module is used to acquire the lateral acceleration data, steering wheel angle data, steering wheel torque data and yaw rate data generated in each cycle during the steering wheel center area test. The steering wheel angle, the yaw rate, the steering wheel torque and the lateral acceleration are stored in an Excel file in a one-to-one correspondence.

[0034] The first calculation module is used to calculate the minimum and average values ​​of the yaw rate gain, the maximum and average values ​​of the steering stiffness, and the steering wheel sensitivity corresponding to the first steering wheel angle dataset, based on the steering wheel angle in the first steering wheel angle dataset, and the yaw rate, steering wheel torque, and lateral acceleration corresponding to the first steering wheel angle dataset, using functions in Excel.

[0035] The second calculation module is used to calculate the average value of the yaw rate gain corresponding to the second steering wheel angle dataset using a function in Excel, based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset.

[0036] The third calculation module is used to calculate the maximum value of the torque gradient corresponding to the lateral acceleration dataset using a function in Excel, based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset.

[0037] Each of the first steering wheel angle datasets consists of steering wheel angles within a corresponding period that fall between a first steering wheel angle threshold and a second steering wheel angle threshold. The second steering wheel angle dataset consists of steering wheel angles within the corresponding period that are greater than a third steering wheel angle threshold and less than a first steering wheel angle threshold, or greater than a second steering wheel angle threshold and less than a fourth steering wheel angle threshold. The yaw rate gain is the ratio of the yaw rate to the corresponding steering wheel angle. The steering stiffness is the ratio of the steering wheel torque to the corresponding steering wheel angle. Each of the lateral acceleration datasets consists of lateral accelerations within a corresponding period that fall between a first acceleration threshold and a second acceleration threshold. The torque gradient is the ratio of the steering wheel torque to the corresponding lateral acceleration.

[0038] Optionally, the first calculation module is also used for:

[0039] Based on the steering wheel angle in the first steering wheel angle dataset and the yaw rate corresponding to the first steering wheel angle dataset, calculate the first yaw rate gain corresponding to the first steering wheel angle dataset, and calculate the minimum and average values ​​of the first yaw rate gain using the min and average functions in Excel.

[0040] Based on the steering wheel angle in the first steering wheel angle dataset and the steering wheel torque corresponding to the first steering wheel angle dataset, the steering stiffness corresponding to the first steering wheel angle dataset is calculated, and the maximum and average values ​​of the steering stiffness are calculated using the ABS function, MAX function and AVERAGE function in Excel.

[0041] Based on the steering wheel angle in the first steering wheel angle dataset and the lateral acceleration corresponding to the first steering wheel angle dataset, the steering wheel sensitivity corresponding to the first steering wheel angle dataset is calculated using the linest, index, and average functions in Excel.

[0042] Optionally, the second calculation module is also used for:

[0043] Based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset, the second yaw rate gain corresponding to the second steering wheel angle data is calculated, and the average value of the second yaw rate gain is calculated using the average function in Excel.

[0044] Optionally, the third calculation module is also used for:

[0045] Based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset, the torque gradient corresponding to the lateral acceleration dataset is calculated, and the maximum value of the torque gradient is calculated using the MAX and AVERAGE functions in Excel.

[0046] Optionally, the device also includes:

[0047] The maximum and minimum steering angle determination module is used to determine the maximum and minimum steering wheel angles in the steering wheel angle data using the MAX and MIN functions in Excel, respectively.

[0048] The theoretical value determination module is used to determine, based on the maximum steering wheel angle and the minimum steering wheel angle, a first theoretical maximum value and a first theoretical minimum value of the steering wheel angle in the first steering wheel angle dataset, and a second theoretical maximum value and a second theoretical minimum value of the steering wheel angle in the second steering wheel angle dataset;

[0049] The actual value determination module is used to determine the first actual maximum value and the first actual minimum value of the steering wheel angle in the first steering wheel angle dataset, and the second actual maximum value and the second actual minimum value of the steering wheel angle in the second steering wheel angle dataset, based on the steering wheel angle data, the first theoretical maximum value, the first theoretical minimum value, the second theoretical maximum value, and the second theoretical minimum value, using the small function, ABS function, and IF function in Excel.

[0050] The threshold determination module is used to take the first actual minimum value as the first corner threshold, the second actual maximum value as the second corner threshold, the second actual minimum value as the third corner threshold, and the second actual maximum value as the fourth corner threshold.

[0051] Optionally, the actual value determination module is also used for:

[0052] The first actual maximum value is determined by using the small function, ABS function, and IF function in Excel to identify the steering wheel angle that deviates the least from the first theoretical maximum value among the steering wheel angle data.

[0053] The first actual minimum value is determined by using the small function, ABS function, and IF function in Excel to identify the steering wheel angle that deviates the least from the first theoretical minimum value among the steering wheel angle data.

[0054] The steering wheel angle that deviates the least from the second theoretical maximum value among the steering wheel angle data is determined by using the small function, ABS function and IF function in Excel;

[0055] The steering wheel angle that deviates the least from the second theoretical minimum value is determined using the SULTISE, ABS, and IF functions in Excel.

[0056] Optionally, the device also includes:

[0057] The target row number determination module is used to determine the target row number corresponding to each threshold using the ROW function in Excel, and each steering wheel angle data corresponds to one row number in Excel;

[0058] The dataset determination module is used to determine, based on the target row number, the steering wheel angle in each first steering wheel angle dataset and the steering wheel angle in each second steering wheel angle dataset, the yaw rate, the steering wheel torque and the lateral acceleration corresponding to the first steering wheel angle dataset, and the yaw rate corresponding to the second steering wheel angle dataset, using the INDIRECT function in Excel.

[0059] Thirdly, the present invention provides an electronic device comprising: a memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the computer instructions to perform the steering wheel center zone test data processing method as described in the first aspect.

[0060] Fourthly, the present invention provides a computer-readable storage medium storing computer instructions for causing the computer to perform the steering wheel center zone test data processing method as described in the first aspect.

[0061] The technical solutions provided in the embodiments of the present invention have at least the following technical effects or advantages:

[0062] This invention provides a method, apparatus, device, and medium for processing test data in the center zone of a steering wheel. First, it acquires lateral acceleration data, steering wheel angle data, steering wheel torque data, and yaw rate data generated in each cycle during the steering wheel center zone test. The steering wheel angle, yaw rate, steering wheel torque, and lateral acceleration are stored in an Excel spreadsheet, corresponding one-to-one. Then, using functions in Excel, it calculates the minimum and average yaw rate gain, the maximum and average steering stiffness, and steering wheel sensitivity corresponding to the first steering wheel angle dataset; the average yaw rate gain corresponding to the second steering wheel angle dataset; and the maximum torque gradient corresponding to the lateral acceleration dataset. This method can process large amounts of test data at high speed, improving test efficiency. It automatically calculates the values ​​of objective evaluation indicators of vehicle dynamic performance in the center zone of the steering wheel using functions in Excel. The calculated results are accurate and reliable, reducing errors and improving the accuracy of objective evaluation of vehicle dynamic performance.

[0063] The above description is merely an overview of the technical solution of the present invention. In order to better understand the technical means of the present invention and to implement it in accordance with the contents of the specification, and in order to make the above and other objects, features and advantages of the present invention more apparent and understandable, specific embodiments of the present invention are described below. Attached Figure Description

[0064] Various other advantages and benefits will become apparent to those skilled in the art upon reading the following detailed description of preferred embodiments. The accompanying drawings are for illustrative purposes only and are not intended to limit the invention. Furthermore, the same reference numerals denote the same parts throughout the drawings. In the drawings:

[0065] Figure 1 This is a flowchart of a method for processing test data of the center area of ​​a steering wheel provided in an embodiment of the present invention;

[0066] Figure 2 This is a schematic diagram of the curve of test data for the center area of ​​a steering wheel provided in an embodiment of the present invention;

[0067] Figure 3 This is a schematic diagram illustrating the range division of a steering wheel angle curve provided in an embodiment of the present invention;

[0068] Figure 4 This is a structural block diagram of a steering wheel center area test data processing device provided in an embodiment of the present invention. Detailed Implementation

[0069] To make the objectives, technical solutions, and advantages of this application clearer, the embodiments of this application will be described in further detail below with reference to the accompanying drawings.

[0070] Figure 1 This is a flowchart of a method for processing test data of the center area of ​​a steering wheel provided in an embodiment of the present invention, such as... Figure 1 As shown, the method includes:

[0071] Step S110: Obtain the lateral acceleration data, steering wheel angle data, steering wheel torque data, and yaw rate data generated in each cycle during the steering wheel center zone test.

[0072] The steering wheel angle, yaw rate, steering wheel torque, and lateral acceleration are all stored in Excel in a corresponding manner.

[0073] In this embodiment, the steering wheel center zone test involves inputting a sine wave with a frequency of 0.2Hz to the steering wheel for at least four cycles, while simultaneously ensuring that the steering angle amplitude generates a speed of 2m / s². 2 Lateral acceleration was measured, and state data such as steering wheel angle, steering wheel torque, lateral acceleration, and yaw rate were collected during the test. All state data were entered into an Excel spreadsheet, with the steering wheel angle, steering wheel torque, lateral acceleration, and yaw rate at the same time recorded in the same row of the spreadsheet.

[0074] When it is necessary to calculate objective evaluation indicators of vehicle dynamic performance in the center area of ​​the steering wheel, the required data can be obtained directly from the table.

[0075] Step S120: Based on the steering wheel angle in the first steering wheel angle dataset, and the yaw rate, steering wheel torque, and lateral acceleration corresponding to the first steering wheel angle dataset, calculate the minimum and average values ​​of the yaw rate gain, the maximum and average values ​​of the steering stiffness, and the steering wheel sensitivity corresponding to the first steering wheel angle dataset using functions in Excel.

[0076] Each first steering wheel angle dataset consists of steering wheel angles within the range of a first and a second steering wheel angle threshold in the corresponding period. The second steering wheel angle dataset consists of steering wheel angles within the corresponding period that are greater than a third steering wheel threshold but less than a first steering wheel threshold, or greater than a second steering wheel threshold but less than a fourth steering wheel threshold. The yaw rate gain is the ratio of the yaw rate to the corresponding steering wheel angle, and the steering stiffness is the ratio of the steering wheel torque to the corresponding steering wheel angle.

[0077] Figure 2 This is a schematic diagram of the curve data of the steering wheel center area provided in an embodiment of the present invention, such as... Figure 2 As shown, in the test of the steering wheel center area, the input sine wave changes periodically, and the corresponding data of steering wheel angle, lateral acceleration, steering wheel torque and yaw rate also change periodically.

[0078] Figure 3 This is a schematic diagram illustrating the range division of a steering wheel angle curve provided in an embodiment of the present invention, such as... Figure 3 As shown, in order to more accurately evaluate the vehicle's dynamic performance, each cycle of the steering wheel angle is divided into the middle range A and the off-center range B.

[0079] This can be understood as follows: steering wheel angles within the middle range A constitute the first steering wheel angle dataset, where the lower limit of the middle range is the first angle threshold, and the upper limit of the middle range is the second angle threshold; steering wheel angles outside the middle range B constitute the second steering wheel angle dataset. The deviation from the middle range includes a first deviation from the middle range and a second deviation from the middle range. The lower limit of the first deviation from the middle range is the third angle threshold, and the upper limit is the first angle threshold; the lower limit of the second deviation from the middle range is the second angle threshold, and the upper limit is the fourth angle threshold.

[0080] For example, the range of steering wheel angle is 13 degrees to -13 degrees. Steering wheel angles between 6.5 degrees and -6.5 degrees (inclusive) are classified into the first steering wheel angle dataset; steering wheel angles between 13 degrees and 6.5 degrees and between -6.5 degrees and -13 degrees (exclusive) are classified into the second steering wheel angle dataset.

[0081] Optionally, the processing method also includes:

[0082] The first step is to use the MAX and MIN functions in Excel to determine the maximum and minimum steering wheel angles in the steering wheel angle data, respectively.

[0083] The max function is the maximum value function, used to return the maximum value in a list of data; the min function is the minimum value function, used to return the minimum value in a list of data.

[0084] This can be understood as using the max function to calculate the maximum steering wheel angle and the min function to calculate the minimum steering wheel angle, based on the steering wheel angle data in the table.

[0085] The second step is to determine the first theoretical maximum value and the first theoretical minimum value of the steering wheel angle in the first steering wheel angle dataset, and the second theoretical maximum value and the second theoretical minimum value of the steering wheel angle in the second steering wheel angle dataset, based on the maximum and minimum steering wheel angles.

[0086] In this embodiment, the first theoretical maximum value and the first theoretical minimum value can be determined by formulas (1) and (2):

[0087] Rang(x)=max(x)-min(x); (1)

[0088] Midrang(x)=[(max(x)+min(x)) / 2]±0.5*(Rang(x) / 2); (2)

[0089] Where X represents the steering wheel angle, max(x) represents the maximum steering wheel angle, min(x) represents the minimum steering wheel angle, Rang(x) represents the range of each cycle, and Midrang(x) represents the first theoretical maximum or minimum value. If Midrang(x) is positive, it represents the first theoretical maximum value; if Midrang(x) is negative, it represents the first theoretical minimum value.

[0090] In this embodiment, the second theoretical maximum value can be 90% of the maximum steering wheel angle, and the second theoretical minimum value can be 90% of the minimum steering wheel angle.

[0091] Specifically, the second theoretical maximum and the second theoretical minimum can be calculated using formula (3):

[0092] DevMidrang(x)=[(max(x)+min(x)) / 2] ±0.9*(Rang(x) / 2); (3)

[0093] Here, DevMidrang(x) represents the second theoretical maximum or the second theoretical minimum. If DevMidrang(x) is positive, it is the second theoretical maximum; if DevMidrang(x) is negative, it is the second theoretical minimum.

[0094] The third step is to determine the first actual maximum and first actual minimum values ​​of the steering wheel angle in the first steering wheel angle dataset, and the second actual maximum and second actual minimum values ​​of the steering wheel angle in the second steering wheel angle dataset, based on the steering wheel angle data, the first theoretical maximum value, the first theoretical minimum value, the second theoretical maximum value, and the second actual minimum value of the steering wheel angle in the second steering wheel angle dataset, using the small, ABS, and IF functions in Excel.

[0095] The `small` function returns the Kth smallest value in a dataset. The `ABS` function returns the absolute value of a given number. The `if` function checks if a condition is met; it returns one value if the condition is met and another value if the condition is not met.

[0096] Optional, the third step includes:

[0097] The first actual maximum value is determined by using the SHOPPING, ABS, and IF functions in Excel to identify the steering wheel angle that deviates the least from the first theoretical maximum value in the steering wheel angle data.

[0098] The first actual minimum value is determined by using the SHOPPING, ABS, and IF functions in Excel to identify the steering wheel angle that deviates the least from the first theoretical minimum value in the steering wheel angle data.

[0099] The second actual maximum value is determined by using the SHOPPING, ABS, and IF functions in Excel to identify the steering wheel angle that deviates the least from the second theoretical maximum value in the steering wheel angle data.

[0100] The second actual minimum steering wheel angle is determined by using the SHOPPING, ABS, and IF functions in Excel to identify the steering wheel angle data that deviates the least from the second theoretical minimum.

[0101] This can be understood as follows: the maximum or minimum theoretical value calculated using the above formula differs from the maximum or minimum value in the actual experimental data. Therefore, the `small` function is used to calculate at least one steering wheel angle in the steering wheel angle data that is closest to the theoretical value, which is then used as the initial actual value. Next, the `ABS` function is used to calculate the absolute value of the difference between the initial actual value and the theoretical value. Finally, the steering wheel angle with the smallest deviation from the theoretical value among the initial actual values ​​is selected as the actual value; that is, the `if` function selects the initial actual value corresponding to the smallest absolute difference as the final actual value.

[0102] For example, the first theoretical maximum value calculated by the above formula is 6.5 degrees. Then, the `small` function calculates two steering wheel angles closest to 6.5 degrees: 6.55 degrees and 6.41 degrees, which are used as the first initial actual values. The `ABS` function automatically calculates the absolute value of the difference between 6.55 degrees and 6.5 degrees as 0.05 degrees, and the absolute value of the difference between 6.41 degrees and 6.5 degrees as 0.09 degrees, thus calculating the two steering wheel angles closest to the first theoretical maximum value. Because the absolute value of the difference (0.05 degrees) is less than 0.09 degrees, the `if` function selects the steering wheel angle of 6.55 degrees, corresponding to the absolute difference of 0.05 degrees, as the first actual maximum value.

[0103] It should be noted that the calculation methods for the first actual minimum value, the second actual maximum value, and the second actual minimum value are the same as those for the first actual maximum value, and will not be repeated here.

[0104] Fourth step: Take the first actual minimum value as the first corner threshold, the second actual maximum value as the second corner threshold, the second actual minimum value as the third corner threshold, and the second actual maximum value as the fourth corner threshold.

[0105] Table 1 is an example table of corner thresholds, as shown below:

[0106] Table 1

[0107]

[0108] Here, assuming the maximum steering wheel angle is 13 degrees and the minimum steering wheel angle is -13 degrees, the first theoretical maximum and minimum values ​​are ±6.5 degrees, and the second theoretical maximum and minimum values ​​are ±11.70 degrees. Based on the initial actual values ​​in Table 1, the first steering angle threshold is -6.55, the second steering angle threshold is 6.55, the third steering angle threshold is -11.69, and the fourth steering angle threshold is 11.69 degrees through the third and fourth steps.

[0109] Optionally, the method further includes:

[0110] The target row number corresponding to each threshold is determined using the ROW function in Excel, and each steering wheel angle data corresponds to a row number in Excel. Based on the target row number, the steering wheel angle in each first steering wheel angle dataset and each second steering wheel angle dataset is determined using the INDIRECT function in Excel. The yaw rate, steering wheel torque, and lateral acceleration corresponding to the first steering wheel angle dataset, and the yaw rate corresponding to the second steering wheel angle dataset are also determined.

[0111] The `indirect` function returns a reference specified by a text string. The `row` function returns the line number of the specified reference.

[0112] This can be understood as follows: using the ROW function in Excel to return the target row number corresponding to each steering wheel angle threshold, and further obtaining the target row numbers for all cycles. Since each steering wheel angle data corresponds to a row number in Excel, the target row numbers for all cycles are different. For example, the first steering wheel angle threshold corresponds to the first target row number, the second steering wheel angle threshold corresponds to the second target row number, the third steering wheel angle threshold corresponds to the third target row number, and the fourth steering wheel angle threshold corresponds to the fourth target row number. Moreover, the first, second, third, and fourth target row numbers are all different within each cycle. Using the INDIRECT function in Excel, the steering wheel angle data between the first and second target row numbers in each cycle can be found, thus obtaining the first steering wheel angle dataset. The steering wheel angle data between the third and first target row numbers, and between the second and fourth target row numbers in each cycle, can be found, thus obtaining the second steering wheel angle dataset. Similarly, based on the target row numbers, the yaw rate, steering wheel angle, and lateral acceleration corresponding to the first steering wheel angle dataset, and the yaw rate corresponding to the second steering wheel angle dataset, can be found.

[0113] Optionally, step S120 includes:

[0114] The first step is to calculate the first yaw rate gain corresponding to the first steering wheel angle dataset based on the steering wheel angle in the first steering wheel angle dataset and the yaw rate corresponding to the first steering wheel angle dataset. The minimum and average values ​​of the first yaw rate gain are calculated using the min and average functions in Excel.

[0115] The average function returns the average value of all parameters.

[0116] This can be understood as follows: calculate the yaw rate corresponding to the first steering wheel angle dataset in each cycle, and the ratio of the yaw rate to the steering wheel angle in the first steering wheel angle dataset to obtain the yaw rate gain corresponding to the first steering wheel angle dataset in each cycle; use the min function in Excel to calculate the minimum and average values ​​of the yaw rate gain in each cycle; use the average function in Excel to calculate the average of the minimum values ​​in all cycles as the minimum value of the first yaw rate gain, and calculate the average of the average values ​​in all cycles as the average value of the yaw rate gain, which is denoted as the first average gain.

[0117] The second step is to calculate the steering stiffness corresponding to the first steering wheel angle dataset based on the steering wheel angle in the first steering wheel angle dataset and the steering wheel torque corresponding to the first steering wheel angle dataset. The maximum value and average value of the steering stiffness are calculated using the ABS function, MAX function and AVERAGE function in Excel.

[0118] This can be understood as follows: The ratio of the steering wheel torque corresponding to the first steering wheel angle dataset for each cycle to the steering wheel angle data in the first steering wheel angle dataset is calculated to obtain the steering stiffness corresponding to the first steering wheel angle dataset. Then, the maximum absolute value of the steering stiffness corresponding to the first steering wheel angle dataset for each cycle is determined by combining the ABS function and the AVERAGE function in Excel. Finally, the average of the maximum absolute values ​​for all cycles is calculated using the AVERAGE function, which is taken as the maximum steering stiffness, i.e., the maximum steering stiffness. The average of the absolute values ​​of the steering stiffness corresponding to the first steering wheel angle dataset for all cycles is determined by combining the ABS function and the AVERAGE function.

[0119] In this embodiment, the steering wheel angle when the steering wheel torque is 0 N·m and the steering wheel torque when the steering wheel angle is 0 degrees can also be calculated by combining the small, if, and indirect functions. For example, the small function can be used to determine the row number of the steering wheel angle when the steering wheel angle is 0 N·m, and the indirect function can be used to determine the actual value of the steering wheel angle corresponding to that row number.

[0120] The third step is to calculate the steering wheel sensitivity corresponding to the first steering wheel angle dataset using the linest and average functions in Excel, based on the steering wheel angle in the first steering wheel angle dataset and the lateral acceleration corresponding to the first steering wheel angle dataset.

[0121] In this embodiment, the first-order linear fitting of steering wheel angle data and lateral acceleration data is achieved through the linest function, and the slope of the first-order fitting is extracted by superimposing the index function, thereby realizing the automatic return of linear regression coefficients through the least squares method to calculate the steering wheel sensitivity feature value.

[0122] In this embodiment, the steering wheel sensitivity corresponding to the first steering wheel angle dataset for each cycle can be calculated first, thereby obtaining the steering wheel sensitivity for all cycles; then, the average value of all steering wheel sensitivities can be calculated using the average function to obtain the steering wheel sensitivity corresponding to the first steering wheel angle dataset, which is the final overall steering wheel sensitivity.

[0123] Optionally, step S120 further includes:

[0124] Based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset, the second yaw rate gain corresponding to the second steering wheel angle data is calculated, and the average value of the second yaw rate gain is calculated using the AVERAGE function in Excel.

[0125] This can be understood as follows: calculate the ratio of the yaw rate corresponding to the second steering wheel angle dataset to the steering wheel angle in the first steering wheel angle dataset to obtain the yaw rate gain corresponding to the second steering wheel angle dataset; calculate the average value of all yaw rate gains using the AVERAGE function in Excel, which is the average value of the yaw rate gain corresponding to the second steering wheel angle dataset, and is the second average gain.

[0126] In this embodiment, the yaw rate gain linearity, i.e., the ratio of the first average gain to the second average gain, can also be calculated using functions in Excel.

[0127] Optionally, step S120 further includes:

[0128] Based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset, the torque gradient corresponding to the lateral acceleration dataset is calculated, and the maximum value of the torque gradient is calculated using the MAX and AVERAGE functions in Excel.

[0129] Each lateral acceleration dataset consists of lateral accelerations that fall between the first and second acceleration thresholds in the corresponding period, and the torque gradient is the ratio of the steering wheel torque to the corresponding lateral acceleration.

[0130] In this embodiment, when calculating the maximum value of the torque gradient, it is also necessary to first divide each cycle of the lateral acceleration into an intermediate range. The lateral accelerations within the intermediate range constitute the lateral acceleration dataset. The calculation methods for the first and second acceleration thresholds corresponding to the lateral acceleration dataset are the same as the calculation methods for the first and second steering wheel angle thresholds. For details, please refer to the relevant calculation content above, which will not be repeated here.

[0131] Specifically, the ratio of the steering wheel torque corresponding to the lateral acceleration dataset for each cycle to the lateral acceleration in the dataset is calculated to obtain the torque gradient corresponding to the lateral acceleration dataset for each cycle. The maximum value of the torque gradient corresponding to each lateral acceleration dataset is calculated using the max function, thus obtaining the maximum torque gradient for each cycle. Finally, the average of the maximum torque gradient values ​​for all cycles is calculated using the average function in Excel, thus obtaining the maximum torque gradient corresponding to the lateral acceleration dataset.

[0132] In this embodiment, the steering wheel torque at 75% lateral acceleration and the lateral acceleration when the steering wheel torque is 0 N·m can be calculated using functions in Excel.

[0133] In this embodiment, the vehicle dynamic performance in the steering wheel center area is evaluated based on the characteristic values ​​such as minimum and average yaw rate gain, steering stiffness, steering wheel sensitivity, and maximum torque gradient calculated in the above steps.

[0134] Based on the same inventive concept, embodiments of the present invention also provide a steering wheel center zone test data processing device. Figure 4 This is a structural block diagram of a steering wheel center area test data processing device provided in an embodiment of the present invention, as shown below. Figure 4 As shown, the device 400 includes a data acquisition module 410, a first calculation module 420, a second calculation module 430, and a third calculation module 440.

[0135] The data acquisition module 410 is used to acquire the lateral acceleration data, steering wheel angle data, steering wheel torque data and yaw rate data generated in each cycle during the steering wheel center area test. The steering wheel angle, yaw rate, steering wheel torque and lateral acceleration are stored in Excel in a one-to-one correspondence.

[0136] The first calculation module 420 is used to calculate the minimum and average values ​​of the yaw rate gain, the maximum and average values ​​of the steering stiffness, and the steering wheel sensitivity corresponding to the first steering wheel angle dataset, based on the steering wheel angle in the first steering wheel angle dataset and the yaw rate, steering wheel torque, and lateral acceleration corresponding to the first steering wheel angle dataset, using functions in Excel.

[0137] The second calculation module 430 is used to calculate the average value of the yaw rate gain corresponding to the second steering wheel angle dataset using a function in Excel, based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset.

[0138] The third calculation module 440 is used to calculate the maximum value of the torque gradient corresponding to the lateral acceleration dataset using functions in Excel, based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset.

[0139] Each first steering wheel angle dataset consists of steering wheel angles within the first and second steering wheel angle thresholds in the corresponding period. The second steering wheel angle dataset consists of steering wheel angles within the corresponding period that are greater than the third steering wheel threshold and less than the first steering wheel threshold, or greater than the second steering wheel threshold and less than the fourth steering wheel threshold. The yaw rate gain is the ratio of the yaw rate to the corresponding steering wheel angle. The steering stiffness is the ratio of the steering wheel torque to the corresponding steering wheel angle. Each lateral acceleration dataset consists of lateral accelerations within the first and second acceleration thresholds in the corresponding period. The torque gradient is the ratio of the steering wheel torque to the corresponding lateral acceleration.

[0140] Optionally, the first computing module 420 is also used for:

[0141] Based on the steering wheel angle in the first steering wheel angle dataset and the yaw rate corresponding to the first steering wheel angle dataset, calculate the first yaw rate gain corresponding to the first steering wheel angle dataset. Use the min and average functions in Excel to calculate the minimum and average values ​​of the first yaw rate gain.

[0142] Based on the steering wheel angle in the first steering wheel angle dataset and the steering wheel torque corresponding to the first steering wheel angle dataset, calculate the steering stiffness corresponding to the first steering wheel angle dataset. Use the ABS function, MAX function and AVERAGE function in Excel to calculate the maximum value and average value of the steering stiffness.

[0143] Based on the steering wheel angle in the first steering wheel angle dataset and the lateral acceleration corresponding to the first steering wheel angle dataset, the steering wheel sensitivity corresponding to the first steering wheel angle dataset is calculated using the Linest, Index, and Average functions in Excel.

[0144] Optionally, the second computing module 430 is also used for:

[0145] Based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset, the second yaw rate gain corresponding to the second steering wheel angle data is calculated, and the average value of the second yaw rate gain is calculated using the AVERAGE function in Excel.

[0146] Optionally, the third computing module 440 is also used for:

[0147] Based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset, the torque gradient corresponding to the lateral acceleration dataset is calculated, and the maximum value of the torque gradient is calculated using the MAX and AVERAGE functions in Excel.

[0148] Optionally, device 400 also includes:

[0149] The maximum and minimum steering angle determination module is used to determine the maximum and minimum steering wheel angles in the steering wheel angle data using the MAX and MIN functions in Excel, respectively.

[0150] The theoretical value determination module is used to determine the first theoretical maximum value and the first theoretical minimum value of the steering wheel angle in the first steering wheel angle dataset, and the second theoretical maximum value and the second theoretical minimum value of the steering wheel angle in the second steering wheel angle dataset, based on the maximum steering wheel angle and the minimum steering wheel angle.

[0151] The actual value determination module is used to determine the first actual maximum and first actual minimum values ​​of the steering wheel angle in the first steering wheel angle dataset, and the second actual maximum and second actual minimum values ​​of the steering wheel angle in the second steering wheel angle dataset, based on the steering wheel angle data, the first theoretical maximum value, the first theoretical minimum value, the second theoretical maximum value, and the second theoretical minimum value, using the small, ABS, and IF functions in Excel.

[0152] The threshold determination module is used to take the first actual minimum value as the first corner threshold, the second actual maximum value as the second corner threshold, the second actual minimum value as the third corner threshold, and the second actual maximum value as the fourth corner threshold.

[0153] Optionally, the actual value determination module is also used for:

[0154] The first actual maximum value is determined by using the SHOPPING, ABS, and IF functions in Excel to identify the steering wheel angle that deviates the least from the first theoretical maximum value in the steering wheel angle data.

[0155] The first actual minimum value is determined by using the SHOPPING, ABS, and IF functions in Excel to identify the steering wheel angle that deviates the least from the first theoretical minimum value in the steering wheel angle data.

[0156] The second actual maximum value is determined by using the SHOPPING, ABS, and IF functions in Excel to identify the steering wheel angle that deviates the least from the second theoretical maximum value in the steering wheel angle data.

[0157] The second actual minimum steering wheel angle is determined by using the SHOPPING, ABS, and IF functions in Excel to identify the steering wheel angle data that deviates the least from the second theoretical minimum.

[0158] Optionally, device 400 also includes:

[0159] The target row number determination module is used to determine the target row number corresponding to each threshold using the ROW function in Excel. Each steering wheel angle data corresponds to a row number in Excel.

[0160] The dataset determination module is used to determine the steering wheel angle in each first steering wheel angle dataset and each second steering wheel angle dataset based on the target row number using the INDIRECT function in Excel, as well as the yaw rate, steering wheel torque, and lateral acceleration corresponding to the first steering wheel angle dataset, and the yaw rate corresponding to the second steering wheel angle dataset.

[0161] It is understood that the device provided in the above embodiments is only illustrated by the division of the above functional modules. In actual applications, the above functions can be assigned to different functional modules as needed, that is, the internal structure of the device can be divided into different functional modules to complete all or part of the functions described above.

[0162] This invention also provides an electronic device that may include a processor and a memory, wherein the processor and the memory may be interconnected via a bus or other means.

[0163] The processor may be a central processing unit (CPU), an application-specific integrated circuit (ASIC), or one or more integrated circuits configured to implement the embodiments of this application.

[0164] Memory may include mass storage for data or instructions. For example, and not limitingly, memory may include hard disk drives (HDDs), floppy disk drives, flash memory, optical disks, magneto-optical disks, magnetic tape, or Universal Serial Bus (USB) drives, or combinations of two or more of these. Where appropriate, memory may include removable or non-removable (or fixed) media. Where appropriate, memory may be internal or external to an electronic device. In a particular embodiment, memory may be non-volatile solid-state memory.

[0165] In one instance, the memory may be read-only memory (ROM). In one instance, the ROM may be a mask-programmed ROM, a programmable ROM (PROM), an erasable PROM (EPROM), an electrically erasable PROM (EEPROM), an electrically rewritable ROM (EAROM), or flash memory, or a combination of two or more of these.

[0166] The processor reads and executes computer program instructions stored in the memory to implement any of the steering wheel center area test data processing methods in the above embodiments.

[0167] In one example, the electronic device may further include a communication interface and a bus. The processor, memory, and communication interface are connected via the bus to communicate with each other. The communication interface is primarily used to enable communication between the various modules, devices, units, and / or equipment in the embodiments of this application. Where appropriate, the bus may include one or more buses.

[0168] Furthermore, in conjunction with the steering wheel center area test data processing method in the above embodiments, this invention can be implemented using a computer-readable storage medium. This computer-readable storage medium stores computer program instructions; when these computer program instructions are executed by a processor, they implement any of the steering wheel center area test data processing methods in the above embodiments.

[0169] The technical solutions described in the embodiments of this application have at least the following technical effects or advantages:

[0170] This invention provides a method, apparatus, device, and medium for processing test data in the center zone of a steering wheel. First, it acquires lateral acceleration data, steering wheel angle data, steering wheel torque data, and yaw rate data generated in each cycle during the steering wheel center zone test. The steering wheel angle, yaw rate, steering wheel torque, and lateral acceleration are stored in an Excel spreadsheet, corresponding one-to-one. Then, using functions in Excel, it calculates the minimum and average yaw rate gain, the maximum and average steering stiffness, and steering wheel sensitivity corresponding to the first steering wheel angle dataset; the average yaw rate gain corresponding to the second steering wheel angle dataset; and the maximum torque gradient corresponding to the lateral acceleration dataset. This method can process large amounts of test data at high speed, improving test efficiency. It automatically calculates the values ​​of objective evaluation indicators of vehicle dynamic performance in the center zone of the steering wheel using functions in Excel. The calculated results are accurate and reliable, reducing errors and improving the accuracy of objective evaluation of vehicle dynamic performance.

[0171] Numerous specific details are set forth in the specification provided herein. However, it will be understood that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures, and techniques have not been shown in detail so as not to obscure the understanding of this specification.

[0172] Similarly, it should be understood that, in order to simplify this disclosure and aid in understanding one or more of the various aspects of the invention, in the above description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof. However, this method of disclosure should not be construed as reflecting an intention that the claimed invention requires more features than are expressly recited in each claim. Rather, as reflected in the following claims, inventive aspects lie in fewer than all features of a single foregoing disclosed embodiment. Therefore, the claims following the detailed description are hereby expressly incorporated into this detailed description, wherein each claim itself is a separate embodiment of the invention.

[0173] It should be noted that the above embodiments are illustrative of the invention and not restrictive, and that those skilled in the art can devise alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses should not be construed as limiting the claims. The word "comprising" does not exclude the presence of components or steps not listed in the claims. The word "a" or "an" preceding a component does not exclude the presence of a plurality of such components. The invention can be implemented by means of hardware comprising several different components and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by the same item of hardware. The use of the words first, second, and third, etc., does not indicate any order. These words can be interpreted as names.

Claims

1. A method for processing test data of the center area of ​​a steering wheel, characterized in that, The method includes: The lateral acceleration data, steering wheel angle data, steering wheel torque data, and yaw rate data generated in each cycle during the steering wheel center area test are obtained, and the steering wheel angle, yaw rate, steering wheel torque, and lateral acceleration are stored in an Excel file in a one-to-one correspondence. Based on the steering wheel angle in the first steering wheel angle dataset, and the yaw rate, steering wheel torque and lateral acceleration corresponding to the first steering wheel angle dataset, calculate the minimum and average values ​​of the yaw rate gain, the maximum and average values ​​of the steering stiffness, and the steering wheel sensitivity corresponding to the first steering wheel angle dataset using functions in Excel; Based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset, the average value of the yaw rate gain corresponding to the second steering wheel angle dataset is calculated using a function in Excel; Based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset, the maximum value of the torque gradient corresponding to the lateral acceleration dataset is calculated using a function in Excel; Wherein, each first steering wheel angle dataset consists of steering wheel angles between a first steering wheel angle threshold and a second steering wheel angle threshold in the corresponding period; the second steering wheel angle dataset consists of steering wheel angles greater than a third steering wheel angle threshold and less than a first steering wheel angle threshold, or greater than a second steering wheel angle threshold and less than a fourth steering wheel angle threshold in the corresponding period; the yaw rate gain is the ratio of the yaw rate to the corresponding steering wheel angle; the steering stiffness is the ratio of the steering wheel torque to the corresponding steering wheel angle; each lateral acceleration dataset consists of lateral accelerations between a first acceleration threshold and a second acceleration threshold in the corresponding period; and the torque gradient is the ratio of the steering wheel torque to the corresponding lateral acceleration. The method further includes: The maximum and minimum steering wheel angles in the steering wheel angle data are determined using the MAX and MIN functions in Excel, respectively. Based on the maximum steering wheel angle and the minimum steering wheel angle, determine the first theoretical maximum value and the first theoretical minimum value of the steering wheel angle in the first steering wheel angle dataset, and the second theoretical maximum value and the second theoretical minimum value of the steering wheel angle in the second steering wheel angle dataset; Based on the steering wheel angle data, the first theoretical maximum value, the first theoretical minimum value, the second theoretical maximum value, and the second theoretical minimum value, the first actual maximum value and the first actual minimum value of the steering wheel angle in the first steering wheel angle dataset, and the second actual maximum value and the second actual minimum value of the steering wheel angle in the second steering wheel angle dataset are determined using the small, ABS, and IF functions in Excel. The first actual minimum value is used as the first corner threshold, the second actual maximum value is used as the second corner threshold, the second actual minimum value is used as the third corner threshold, and the second actual maximum value is used as the fourth corner threshold; The method further includes: The target row number corresponding to each threshold is determined by the ROW function in Excel, and each steering wheel angle data corresponds to one row number in Excel; Based on the target row number, the steering wheel angle in each first steering wheel angle dataset and the steering wheel angle in each second steering wheel angle dataset are determined using the INDIRECT function in Excel. The yaw rate, steering wheel torque, and lateral acceleration corresponding to the first steering wheel angle dataset, and the yaw rate corresponding to the second steering wheel angle dataset are also determined.

2. The method for processing test data of the steering wheel center area according to claim 1, characterized in that, The step of calculating the minimum and average values ​​of the yaw rate gain, the maximum and average values ​​of the steering stiffness, and the steering wheel sensitivity corresponding to the first steering wheel angle dataset using Excel functions, based on the steering wheel angle in the first steering wheel angle dataset and the yaw rate, steering wheel torque, and lateral acceleration corresponding to the first steering wheel angle dataset, includes: Based on the steering wheel angle in the first steering wheel angle dataset and the yaw rate corresponding to the first steering wheel angle dataset, calculate the first yaw rate gain corresponding to the first steering wheel angle dataset, and calculate the minimum and average values ​​of the first yaw rate gain using the min and average functions in Excel. Based on the steering wheel angle in the first steering wheel angle dataset and the steering wheel torque corresponding to the first steering wheel angle dataset, the steering stiffness corresponding to the first steering wheel angle dataset is calculated, and the maximum and average values ​​of the steering stiffness are calculated using the ABS function, MAX function and AVERAGE function in Excel. Based on the steering wheel angle in the first steering wheel angle dataset and the lateral acceleration corresponding to the first steering wheel angle dataset, the steering wheel sensitivity corresponding to the first steering wheel angle dataset is calculated using the linest, index, and average functions in Excel.

3. The method for processing test data of the steering wheel center area according to claim 1, characterized in that, The step of calculating the average value of the yaw rate gain corresponding to the second steering wheel angle dataset using an Excel function, based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset, includes: Based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset, the second yaw rate gain corresponding to the second steering wheel angle dataset is calculated, and the average value of the second yaw rate gain is calculated using the average function in Excel.

4. The method for processing test data of the steering wheel center area according to claim 1, characterized in that, The step of calculating the maximum value of the torque gradient corresponding to the lateral acceleration dataset using a function in Excel, based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset, includes: Based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset, the torque gradient corresponding to the lateral acceleration dataset is calculated, and the maximum value of the torque gradient is calculated using the MAX and AVERAGE functions in Excel.

5. The method for processing test data of the steering wheel center area according to claim 1, characterized in that, The step of determining the first actual maximum and first actual minimum values ​​of the steering wheel angle in the first steering wheel angle dataset, and the second actual maximum and second actual minimum values ​​of the steering wheel angle in the second steering wheel angle dataset, using the SHOPPING, ABS, and IF functions in Excel, based on the steering wheel angle data, the first theoretical maximum value, the first theoretical minimum value, the second theoretical maximum value, and the second theoretical minimum value, includes: The first actual maximum value is determined by using the small function, ABS function, and IF function in Excel to identify the steering wheel angle that deviates the least from the first theoretical maximum value among the steering wheel angle data. The first actual minimum value is determined by using the small function, ABS function, and IF function in Excel to identify the steering wheel angle that deviates the least from the first theoretical minimum value among the steering wheel angle data. The steering wheel angle that deviates the least from the second theoretical maximum value among the steering wheel angle data is determined by using the small function, ABS function and IF function in Excel; The steering wheel angle that deviates the least from the second theoretical minimum value is determined using the SULTISE, ABS, and IF functions in Excel.

6. A device for processing test data of the center area of ​​a steering wheel, characterized in that, The device includes: The data acquisition module is used to acquire the lateral acceleration data, steering wheel angle data, steering wheel torque data and yaw rate data generated in each cycle during the steering wheel center area test. The steering wheel angle, the yaw rate, the steering wheel torque and the lateral acceleration are stored in an Excel file in a one-to-one correspondence. The first calculation module is used to calculate the minimum and average values ​​of the yaw rate gain, the maximum and average values ​​of the steering stiffness, and the steering wheel sensitivity corresponding to the first steering wheel angle dataset, based on the steering wheel angle in the first steering wheel angle dataset, and the yaw rate, steering wheel torque, and lateral acceleration corresponding to the first steering wheel angle dataset, using functions in Excel. The second calculation module is used to calculate the average value of the yaw rate gain corresponding to the second steering wheel angle dataset using a function in Excel, based on the steering wheel angle in the second steering wheel angle dataset and the yaw rate corresponding to the second steering wheel angle dataset. The third calculation module is used to calculate the maximum value of the torque gradient corresponding to the lateral acceleration dataset using a function in Excel, based on the lateral acceleration in the lateral acceleration dataset and the steering wheel torque corresponding to the lateral acceleration dataset. Wherein, each first steering wheel angle dataset consists of steering wheel angles between a first steering wheel angle threshold and a second steering wheel angle threshold in the corresponding period; the second steering wheel angle dataset consists of steering wheel angles greater than a third steering wheel angle threshold and less than a first steering wheel angle threshold, or greater than a second steering wheel angle threshold and less than a fourth steering wheel angle threshold in the corresponding period; the yaw rate gain is the ratio of the yaw rate to the corresponding steering wheel angle; the steering stiffness is the ratio of the steering wheel torque to the corresponding steering wheel angle; each lateral acceleration dataset consists of lateral accelerations between a first acceleration threshold and a second acceleration threshold in the corresponding period; and the torque gradient is the ratio of the steering wheel torque to the corresponding lateral acceleration. The device further includes: The maximum and minimum steering angle determination module is used to determine the maximum and minimum steering wheel angles in the steering wheel angle data using the MAX and MIN functions in Excel, respectively. The theoretical value determination module is used to determine, based on the maximum steering wheel angle and the minimum steering wheel angle, a first theoretical maximum value and a first theoretical minimum value of the steering wheel angle in the first steering wheel angle dataset, and a second theoretical maximum value and a second theoretical minimum value of the steering wheel angle in the second steering wheel angle dataset; The actual value determination module is used to determine the first actual maximum value and the first actual minimum value of the steering wheel angle in the first steering wheel angle dataset, and the second actual maximum value and the second actual minimum value of the steering wheel angle in the second steering wheel angle dataset, based on the steering wheel angle data, the first theoretical maximum value, the first theoretical minimum value, the second theoretical maximum value, and the second theoretical minimum value, using the small function, ABS function, and IF function in Excel. The threshold determination module is used to take the first actual minimum value as the first corner threshold, the second actual maximum value as the second corner threshold, the second actual minimum value as the third corner threshold, and the second actual maximum value as the fourth corner threshold; The device further includes: The target row number determination module is used to determine the target row number corresponding to each threshold using the ROW function in Excel, and each steering wheel angle data corresponds to one row number in Excel; The dataset determination module is used to determine, based on the target row number, the steering wheel angle in each first steering wheel angle dataset and the steering wheel angle in each second steering wheel angle dataset, the yaw rate, the steering wheel torque and the lateral acceleration corresponding to the first steering wheel angle dataset, and the yaw rate corresponding to the second steering wheel angle dataset, using the INDIRECT function in Excel.

7. An electronic device, characterized in that, include: A memory and a processor are interconnected, the memory storing computer instructions, and the processor executing the computer instructions to perform the steering wheel center area test data processing method according to any one of claims 1-5.

8. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions for causing the computer to perform the steering wheel center zone test data processing method according to any one of claims 1-5.

Images