Automatic processing method, system and storage medium for power battery bench test data

Through the automatic processing method of power battery mount test data, the test data is automatically processed, and the problem of manual processing is solved, and efficient and accurate data processing and equivalent mileage calculation are achieved, which is suitable for all power batteries. Bench test.

CN113868198BActive Publication Date: 2024-11-08DEEPAL AUTOMOBILE TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202111138740.8
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-09-27
Publication Date
2024-11-08
Estimated Expiration
2041-09-27

AI Technical Summary

Technical Problem

In the power battery bench test, manual processing of test data takes a long time and is prone to omissions, with low accuracy, especially in the cycle life test, the equivalent mileage needs to be manually calculated, which is cumbersome and has many repetitive work.

Method used

Provide an automatic processing method for the test data of the power battery mount, including automatic processing programs, through data preprocessing, segmentation processing, statistics and calculation of equivalent mileage, to realize automatic data extraction, format conversion, charging and discharging step identification and information Statistics, output results.

Benefits of technology

It greatly reduces data processing time, improves processing accuracy and efficiency, and reduces the possibility of human error. It is suitable for all power battery assembly bench tests, with convenient operation, accurate and efficient performance and reliable performance.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN113868198B_ABST
    Figure CN113868198B_ABST
Patent Text Reader

Abstract

The present invention discloses a method, system and storage medium for automatic processing of power battery bench test data, including: step 1: running an automatic processing program; step 2: selecting files or folders to be processed; step 3: automatically preprocessing the experimental data; step 4: automatically segmenting the preprocessed data; step 5: based on the data segmentation result of step 4, segmenting and counting the charging and discharging time, charging and discharging power and charging and discharging temperature of each segment of data, and calculating the equivalent mileage of the simulated working condition discharge data; step 6: automatically writing the automatically counted test results into a specified file and keeping them in a specified file path; step 7: data automatic processing is completed. The present invention has the functions of test data format conversion, specified data signal extraction, automatic identification of charging and discharging steps, automatic statistics of charging and discharging information, automatic calculation of cycle equivalent mileage and data result output.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention belongs to the technical field of data processing, and in particular relates to a method, system and storage medium for automatic processing of power battery bench test data. Background Art

[0002] like Figure 1 As shown in the figure, when the power battery assembly of new energy vehicles is tested on the test bench, the test equipment will synchronously record the local signal of the test equipment and all CAN signals of the battery BMS. If the data recording interval is set to 1s, the data volume is about 600 per second. The cycle life test runs uninterruptedly for 7 days, and the data can reach 360 million data points. However, when processing the test data, it is often necessary to focus on only about 50 signals (other data signals must be recorded for other analysis needs). This requires manual screening of the required signals from more than 600 data signals (repeated search, cut, paste, etc. in EXCEL for more than 50 times), and then segmenting the test data according to the charge and discharge current (manually pull down or through EXCEL L formula to find the starting and ending positions where the current is not 0) and note the type of each data segment, including static, charging (constant current charging and variable current charging), discharging (constant current discharge, simulated working condition discharge), and respectively count the start and end serial number positions, test time, cumulative charging capacity, cumulative discharge capacity, cumulative charging energy, cumulative discharge energy, maximum temperature difference, maximum pressure difference, maximum temperature, fault code, etc. of each data segment. If it is a cycle life test, it is also necessary to calculate the equivalent mileage during simulated working condition discharge (manually compare the output power of the test equipment with the target power, determine the equivalent mileage per second, and finally sum them up). The whole process is time-consuming and repetitive work. Manual processing of test data is also prone to omissions and low accuracy.

[0003] Therefore, it is necessary to develop a new automatic processing method, system and storage medium for power battery bench test data. Summary of the invention

[0004] The purpose of the present invention is to provide a method, system and storage medium for automatic processing of power battery bench test data, which has the functions of test data format conversion, specified data signal extraction, automatic identification of charging and discharging steps, automatic statistics of charging and discharging information, automatic calculation of cycle equivalent mileage and data result output.

[0005] In a first aspect, a method for automatically processing power battery bench test data according to the present invention comprises the following steps:

[0006] Step 1: Run the automatic processing program;

[0007] Step 2: Select the files or folders you want to process;

[0008] Step 3: Automatically preprocess the experimental data, including data extraction, format conversion and file saving of the raw data;

[0009] Step 4: Automatically segment the preprocessed data, including reading the preprocessed file, extracting the current signal, and comparing the current signal with a preset current threshold, wherein the preset current threshold is a threshold for judging whether the power battery is in a charging or discharging state or a static state. If |current signal|≥preset current threshold, the power battery is considered to be in a charging or discharging state; if |current signal|<preset current threshold and lasts for more than a preset time, the power battery is considered to be in a static state; segment the data according to the above standards, and record the start and end serial numbers of each segment of data;

[0010] Step 5: Based on the data segmentation results of step 4, the charging and discharging time, charging and discharging quantity and charging and discharging temperature of each segment of data are segmented and the equivalent mileage of the simulated working condition discharge data is calculated;

[0011] Step 6: Automatically write the automatically counted test results into the specified file and keep them in the specified file path;

[0012] Step 7: Data automatic processing is completed.

[0013] Optionally, the step 3 is specifically:

[0014] Step 301: Data preprocessing begins;

[0015] Step 302: determine the file path of the data to be processed, and automatically search for all files of the specified file type under the path, save the file names and the number of files N that meet the conditions, and create a new "pre-processing" folder under the current path;

[0016] Step 303: Use variable i to mark the serial number of the file being processed by the current program, initialize i=1, load the preset variable signal list at the same time, and use M to mark the number of preset signals;

[0017] Step 304: read the i-th file and automatically locate the line where the signal name is located;

[0018] Step 305: Mark the sequence number of the preset signal with j, and initialize j=1;

[0019] Step 306: automatically search for the jth preset signal name in the row where the signal name is located. If it can be found, record the column number Col_j where the signal is located. If the search fails, report a warning.

[0020] Step 307: j=j+1, i.e. searching for the next preset signal;

[0021] Step 308: Determine whether the current value of j is less than or equal to the total number M of preset signals. If so, go to step 306; if not, it means that all preset signals have been retrieved, go to step 309;

[0022] Step 309: Create a new EXCEL file in the "pre-processing" folder, and automatically copy all column data of all preset signals. After the copying is completed, save the file as "original name of the i-th data" + "pre-processing.xlsx";

[0023] Step 310: i=i+1, i.e., preprocessing the next file;

[0024] Step 311: determine whether the current value of i is less than or equal to the total number N of files to be processed. If so, go to step 304; if not, it means that all files to be processed have been pre-processed, go to step 312;

[0025] Step 312: The pre-processing function is completed and ends.

[0026] Optionally, the step 4 is specifically:

[0027] Step 401: Data segmentation starts;

[0028] Step 402: automatically search for files of the file type ".XLSX" in the "pre-processing" folder, record the number of files that meet the requirement as N, and create a new "processing result" folder under the original file path;

[0029] Step 403: mark the sequence number of the currently processed file with m, and initialize m=1;

[0030] Step 404: Start processing the mth file, automatically open the file, and read the data in the column where the "current signal" is located, and record the data volume of the column as L;

[0031] Step 405: mark the data segment number of the current file with n, and initialize n=0; mark the row number of the column where the "current signal" is located with k, and initialize k=0; mark the row numbers of the start and end positions of the nth segment of data with ak and bk respectively;

[0032] Step 406: extract the kth data data_k according to the row number k and the column number Col_j where the “current signal” is located;

[0033] Step 407: Determine whether the absolute value of the current value is less than a preset current threshold value. If the requirement is met, it indicates that the power battery is in a static state, and the process goes to step 408; if the requirement is not met, it indicates that the power battery is in a charging or discharging state, and the process goes to step 410;

[0034] Step 408: execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row;

[0035] Step 409: Determine whether the value of k is greater than L-1. If the condition is satisfied, it means that the data in the "current signal" column has been traversed and the process goes to step 419. If the condition is not satisfied, the process goes to step 406.

[0036] Step 410: execute n=n+1, that is, the number of data segments of the mth file is increased by 1; execute ak=k, that is, the k value is used as the starting sequence number of the nth segment of data; execute k=k+1, that is, the line number is increased by 1, and prepare to extract the next line of data;

[0037] Step 411: determine whether the absolute value of the current value is less than a preset current threshold value. If the requirement is met, it indicates that the power battery is in a static state for 1 second, and the process goes to step 414 to continue to determine the battery state. If the requirement is not met, it indicates that the power battery is still in a charging or discharging state, and the process goes to step 412.

[0038] Step 412: Execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row;

[0039] Step 413: Determine whether the value of k is greater than L-1. If it meets the requirement, it indicates that the data in the "current signal" column has been traversed and the process goes to step 419; if it does not meet the requirement, the process goes to step 411;

[0040] Step 414: execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row;

[0041] Step 415: Determine whether the absolute value of the current value is less than a preset current threshold value. If the requirement is met, it indicates that the power battery is in a static state for 2 seconds, and the process goes to step 416 to continue to determine the battery state. If the requirement is not met, it indicates that the power battery is in a charging or discharging state, and the process goes to step 411.

[0042] Step 416: execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row;

[0043] Step 417: Determine whether the absolute value of the current value is less than a preset current threshold value. If the requirement is met, it indicates that the power battery is in a static state for 3 seconds, and the process goes to step 418; if the requirement is not met, it indicates that the power battery is in a charging or discharging state, and the process goes to step 411;

[0044] Step 418: execute bk=k-3, that is, it is considered that the power battery is in a static state when the absolute value of the "current signal" for 3 consecutive seconds is less than the preset current threshold; execute k=k-2, that is, the row number is located at the next row of the end position bk of the nth segment data, and prepare to extract the data of this row, and go to step 406;

[0045] Step 419: execute bk=k-1, that is, when the traversal of the "current signal" column data is completed, k-1 is used as the sequence number of the end position of the nth segment of data;

[0046] Step 420: automatically open the mth file and create a new worksheet named "Statistical Results"; automatically write the charging and discharging information of all n segments of data according to the data segmentation; after writing is completed, the file is automatically saved in the "Processing Results" folder; when writing the test results, it is automatically determined whether the equivalent mileage needs to be calculated according to the type of each segment of data;

[0047] Step 421: execute m=m+1, that is, the mth file is processed and ready to process the next file;

[0048] Step 422: determine whether the value of m is greater than the total number N of files to be processed. If the condition is satisfied, it means that all files have been automatically processed. If the condition is not satisfied, go to step 404.

[0049] Step 423: Data segmentation, result statistics and automatic writing are completed and ended.

[0050] Optionally, the step 5 is specifically:

[0051] Step 501: Automatic calculation of mileage begins;

[0052] Step 502: According to the data segmentation result of step 4, it is known that the number of data segments of each file is n, and the serial numbers of the start and end positions of each data segment are ak and bk respectively; at the same time, the "time-vehicle speed-power" file is loaded, and the working condition length is recorded as G;

[0053] Step 503: mark the data segment number of the currently processed file with o, and initialize o=1;

[0054] Step 504: Start processing the oth segment number;

[0055] Step 505: Determine whether the minimum value of all the "current signal" data in the oth segment of data is less than 0. If the minimum value is less than 0, go to step 506; if the minimum value is greater than 0, go to step 509;

[0056] Step 506: the power battery is judged to be in a state of discharge, and the equivalent driving mileage needs to be calculated, with S being the accumulated mileage, and S being initialized to 0;

[0057] Step 507: pow_Rea represents the actual discharge power of the power battery, and pow_Sim represents the given power in the “time-vehicle speed-power” file;

[0058] Step 508: mark the row number of the oth segment of data with p1, and initialize p1=ak; mark the row number of the given power with p2, and initialize p2=0; mark the vehicle speed corresponding to the given power with v_p2;

[0059] Step 509: the power battery is judged to be in charging state, and it is not necessary to calculate the equivalent driving mileage, and o=o+1 is executed, i.e., preparing to process the next segment of data;

[0060] Step 510: Determine whether the value of o is greater than the total number of data segments n of the current file. If so, go to step 511; if not, go to step 504;

[0061] Step 511: All data segments of the current file have been processed, and the program ends;

[0062] Step 512: Determine whether the absolute value of the difference between the p1th power pow_Rea-p1 of the oth segment data and the p2th given power pow_Sim-p2 is less than a preset value, which is adjusted according to the control error of different devices. If the requirement is met, go to step 513; if not, go to step 519;

[0063] Step 513: execute p1=p1+1, p2=p2+1, that is, after the p1th power point is matched successfully, the power row number is increased by 1, and the matching of the p1+1th power point is prepared;

[0064] Step 514: Determine whether the value of p1 is greater than the end sequence number bk of the oth segment of data. If the condition is satisfied, go to step 523; if the condition is not satisfied, go to step 515;

[0065] Step 515: Determine whether the value of p2 is greater than G-1, that is, whether the row number of the given power exceeds the operating condition length. If the condition is met, go to step 516; if the condition is not met, go to step 517;

[0066] Step 516: execute p2=0, initialize the row number mark of the given power to 0, and go to step 512;

[0067] Step 517: Determine whether the absolute value of the difference between the p1th power pow_Rea-p1 of the oth segment data and the p2th given power pow_Sim-p2 is less than a preset value. If the requirement is met, go to step 526; if not, go to step 518;

[0068] Step 518: execute p1=p1-1, that is, the power matching fails, and the actual discharge power number of the power battery is relocated to the initial test position, while the position number p2 of the given power remains unchanged; and go to step 512;

[0069] Step 519: execute p2=p2+1, that is, add 1 to the given power mark number and locate to the next given power;

[0070] Step 520: Determine whether p2 is greater than G-1. If the condition is met, go to step 521; if the condition is not met, go to step 512;

[0071] Step 521: execute p2=0, that is, relocate the mark number of the given power to the first row; execute p1=p1+1, that is, the p1th actual power is not matched successfully, and prepare to match the next actual power point;

[0072] Step 522: Determine whether the value of p1 is greater than bk. If the condition is satisfied, go to step 523; if the condition is not satisfied, go to step 512;

[0073] Step 523: execute o=o+1, the oth segment of data has been processed, and the o+1th segment of data is ready to be processed;

[0074] Step 524: Determine whether the value of o is greater than the total number of segments n of the current file data. If the condition is satisfied, go to step 525; if the condition is not satisfied, go to step 504;

[0075] Step 525: The equivalent mileage calculation ends;

[0076] Step 526: execute p1=p1+1, p2=p2+1, i.e. prepare to perform power matching at the p1+1th point;

[0077] Step 527: Determine whether the value of p1 is greater than bk. If the condition is satisfied, go to step 523; if the condition is not satisfied, go to step 528;

[0078] Step 528: Determine whether the value of p2 is greater than G-1. If the condition is satisfied, go to step 521; if the condition is not satisfied, go to step 529;

[0079] Step 529: Determine whether the absolute value of the difference between the p1th power pow_Rea-p1 of the oth segment data and the p2th given power pow_Sim-p2 is less than a preset value. If the requirement is met, go to step 530; if not, go to step 535;

[0080] Step 530: Execute p1=p1+1, p2=p2+1, i.e. prepare to perform power matching at the p1+1th point;

[0081] Step 531: Determine whether the value of p1 is greater than bk. If the condition is satisfied, go to step 523; if the condition is not satisfied, go to step 532;

[0082] Step 532: Determine whether the value of p2 is greater than G-1. If the condition is satisfied, go to step 521; if the condition is not satisfied, go to step 533;

[0083] Step 533: Execute S=v_(p2-1)+v_(p2-2)+v_(p2-3), that is, calculate the equivalent mileage when the first three power matches are successful;

[0084] Step 534: determine whether the absolute value of the difference between the p1th power pow_Rea-p1 of the oth segment data and the p2th given power pow_Sim-p2 is less than a preset value. If the requirement is met, go to step 537; if not, go to step 536;

[0085] Step 535: execute p1=p1-2, p2=p2-1, that is, the current power matching fails, the actual discharge power of the power battery is relocated to the initial test position, and the given power is located to the next power point of the initial test position, and go to step S512;

[0086] Step 536: execute p1=p1-3, p2=p2-2, that is, the current power matching fails, the actual discharge power of the power battery is relocated to the initial test position, and the given power is located to the next power point of the initial test position, and go to step S512;

[0087] Step 537: execute S=S+v_p2, accumulate the mileage corresponding to the current power, p1=p1+1, p2=p2+1, that is, after the p1th power point is successfully matched, the power line number is increased by 1, and the p1+1th power point is prepared for matching;

[0088] Step 538: Determine whether the value of p1 is greater than bk. If the condition is satisfied, go to step 523; if the condition is not satisfied, go to step 539;

[0089] Step 539: Determine whether the value of p2 is greater than G-1. If the condition is satisfied, go to step 540; if the condition is not satisfied, go to step 534;

[0090] Step 540: execute p1=p1-1, p2=0, that is, the given power has been completely traversed, reposition the mark number to the first row, and go to step S512.

[0091] Optionally, before executing step 411, the following steps are further executed:

[0092] Determine whether the value of k is greater than L-1. If the condition is met, it means that the "current signal" column data has been traversed and go to step 419; if the condition is not met, extract the kth data data_k according to the row number k and the column number Col_j where the "current signal" is located, and go to step 411.

[0093] Optionally, before executing step 415, the following steps are further executed:

[0094] Determine whether the value of k is greater than L-1. If the condition is met, it means that the "current signal" column data has been traversed and go to step 419; if the condition is not met, extract the kth data data_k according to the row number k and the column number Col_j where the "current signal" is located, and go to step 415.

[0095] Optionally, before executing step 417, the following steps are further executed:

[0096] Determine whether the value of k is greater than L-1. If the condition is met, it means that the "current signal" column data has been traversed and go to step 419; if the condition is not met, extract the kth data data_k according to the row number k and the column number Col_j where the "current signal" is located, and go to step 417.

[0097] In a second aspect, a system for automatically processing power battery bench test data according to the present invention comprises a memory and a controller, wherein the memory stores a computer-readable program, and when the computer-readable program is called by the controller, it can execute the steps of the method for automatically processing power battery bench test data according to the present invention.

[0098] In a third aspect, a storage medium described in the present invention stores a computer-readable program therein, and when the computer-readable program is called, it can execute the steps of the method for automatic processing of power battery bench test data as described in the present invention.

[0099] The present invention has the following advantages: it has the functions of test data format conversion, specified data signal extraction, automatic identification of charge and discharge steps, automatic statistics of charge and discharge information, automatic calculation of cycle equivalent mileage and data result output, can be applied to all power battery assembly bench tests, and has the advantages of convenient operation, precise and efficient, reliable performance, saving data processing time, strong practicality, etc. BRIEF DESCRIPTION OF THE DRAWINGS

[0100] Figure 1 is a flow chart of background technology;

[0101] Figure 2 It is a schematic diagram of the workflow of this embodiment;

[0102] Figure 3 is a flow chart of data preprocessing in this embodiment;

[0103] Figure 4 is a flow chart of data segmentation in this embodiment;

[0104] Figure 54 is a flow chart of automatically calculating mileage in this embodiment. DETAILED DESCRIPTION

[0105] The present invention will be further described below in conjunction with the accompanying drawings.

[0106] See also Figure 2 In this embodiment, a method for automatically processing power battery bench test data includes the following steps:

[0107] Step 1: Run the automatic processing program. This program is based on Python code and needs to be run in IDLE of Python 3.7 or above.

[0108] Step 2: After the program is run, a file box will pop up, prompting you to select the file path to be processed. You can select a single file or a specified folder.

[0109] Step 3: Automatic data preprocessing. This step mainly extracts the original data, converts the format, and saves the file to prepare for the next step of automatic data processing.

[0110] Step 4: Automatically segment the preprocessed data, including reading the preprocessed file, extracting the current signal, and comparing the current signal with the preset current threshold, wherein the preset current threshold is a threshold for judging whether the power battery is in a charging or discharging state or a static state (depending on different charging and discharging test equipment, the preset current threshold can be set to about ±0.1A). If |current signal|≥preset current threshold, the power battery is considered to be in a charging or discharging state; if |current signal|<preset current threshold and lasts for more than a preset time (the preset time is set to 3s), the power battery is considered to be in a static state; segment the data according to the above standards, and record the start and end sequence numbers of each segment of data.

[0111] Step 5: Based on the data segmentation results of step 4, the charging and discharging time, charging and discharging power, charging and discharging temperature and other results of each segment of data are segmented and counted, and the equivalent mileage of the simulated working condition discharge data is calculated.

[0112] Step 6: Automatically write the automatically counted test results into the specified file and keep them in the specified file path.

[0113] Step 7: Data automatic processing is completed.

[0114] In this embodiment, the automatic processing method of the power battery bench test data consists of three subroutines: data preprocessing, data processing, and data result output. Among them, the data preprocessing program is mainly responsible for loading the test data to be processed, converting the original data in CSV format into XLSX format, and extracting the data according to the preset data signal name and saving it as a "data original name + preprocessing.xlsx" file, which effectively reduces the size of the data to be processed and greatly improves the speed of subsequent data processing. The data processing program is mainly responsible for segmenting the test data and counting the required information of each segment of data, and at the same time determines whether the simulated working condition discharge needs to calculate the equivalent mileage (if necessary, the target "time-vehicle speed-power" file needs to be input). The data result output program is mainly responsible for outputting the statistical data results as an EXCEL file according to the preset template, including digital results and curve diagrams.

[0115] See also Figure 3 In this embodiment, step 3 is specifically as follows:

[0116] Step 301: Preprocessing starts.

[0117] Step 302: Determine the file path of the data to be processed, and automatically search for all files of the ".CSV" type under the path (the search conditions can be changed according to the device record data type, such as ".XLSX", ".TXT", etc., or multiple types of files can be filtered at the same time), save the file names and file quantities (N) that meet the conditions, and create a new "pre-processing" folder under the current path.

[0118] Step 303: Use variable i to mark the serial number of the current program processing file, initialize i=1, and load the preset variable signal list, such as "current signal", "voltage signal", "power signal", "temperature signal", etc., and use M to mark the number of preset signals.

[0119] Step 304: Read the ith file and automatically locate the line where the signal name is located.

[0120] Step 305: Use j to mark the sequence number of the preset signal, and initialize j=1.

[0121] Step 306: Automatically search for the j-th preset signal name in the row where the signal name is located. If it can be retrieved, record the column number Col_j where the signal is located. If the retrieval fails, report "j-th signal retrieval failure warning".

[0122] Step 307: j=j+1, ie, searching for the next preset signal.

[0123] Step 308: Determine whether the current value of j is less than or equal to the total number M of preset signals. If so, go to step 306; if not, it means that all preset signals have been retrieved, go to step 309.

[0124] Step 309: Create a new EXCEL file in the "Preprocessing" folder, and automatically copy all column data of all preset signals. After the copying is completed, save the file as "original name of the i-th data" + "Preprocessing.xlsx".

[0125] Step 310: i=i+1, namely, preprocessing the next file.

[0126] Step 311: determine whether the current value of i is less than or equal to the total number N of files to be processed. If so, go to step 304; if not, it means that all files to be processed have been pre-processed, go to step 312;

[0127] Step 312: The pre-processing function is completed and ends.

[0128] See also Figure 4 In this embodiment, step 4 is specifically as follows:

[0129] Step 401: Data segmentation starts.

[0130] Step 402: Automatically search for files of the file type ".XLSX" in the "pre-processing" folder, record the number of files that meet the requirements as N, and create a new "processing result" folder under the original file path.

[0131] Step 403: mark the sequence number of the currently processed file with m, and initialize m=1.

[0132] Step 404: Start processing the mth file, automatically open the file, and read the data in the column where the “current signal” is located. The data volume of the column is recorded as L.

[0133] Step 405: mark the data segment number of the current file with n, and initialize n=0; mark the row number of the column where the "current signal" is located with k, and initialize k=0; mark the row numbers of the start and end positions of the nth segment of data with ak and bk respectively.

[0134] Step 406: extract the kth data data_k according to the row number k and the column number Col_j where the “current signal” is located.

[0135] Step 407: Determine whether the absolute value of the current value is less than 0.1 (0.1 is the threshold for determining whether the power battery is in a charging or discharging state or a static state, which is related to different types of test equipment. The threshold can be modified here according to actual conditions). If the requirement is met, it indicates that the power battery is in a static state, and go to step 408; if the requirement is not met, it indicates that the power battery is in a charging or discharging state, and go to step 410.

[0136] Step 408: Execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row.

[0137] Step 409 : Determine whether the value of k is greater than (L-1). If the condition is satisfied, it means that the data in the “current signal” column has been traversed, and go to step 419 ; if the condition is not satisfied, go to step 406 .

[0138] Step 410: execute n=n+1, that is, the number of data segments of the mth file is increased by 1; execute ak=k, that is, the k value is used as the starting sequence number of the nth segment of data; execute k=k+1, that is, the line number is increased by 1, and prepare to extract the next line of data.

[0139] Determine whether the value of k is greater than L-1. If the condition is met, it means that the "current signal" column data has been traversed and go to step 419; if the condition is not met, extract the kth data data_k according to the row number k and the column number Col_j where the "current signal" is located, and go to step 411.

[0140] Step 411: Determine whether the absolute value of the current value is less than 0.1. If it meets the requirement, it indicates that the power battery is in a static state for 1 second, and go to step 414 to continue to determine the battery state; if it does not meet the requirement, it indicates that the power battery is still in a charging or discharging state, and go to step 412.

[0141] Step 412: Execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row.

[0142] Step 413: Determine whether the value of k is greater than (L-1). If so, it indicates that the data in the "current signal" column has been traversed and the process goes to step 419; if not, the process goes to step 411.

[0143] Step 414: Execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row.

[0144] Determine whether the value of k is greater than L-1. If the condition is met, it means that the "current signal" column data has been traversed and go to step 419; if the condition is not met, extract the kth data data_k according to the row number k and the column number Col_j where the "current signal" is located, and go to step 415.

[0145] Step 415: Determine whether the absolute value of the current value is less than 0.1. If it meets the requirement, it indicates that the power battery is in a static state for 2 seconds, and go to step 416 to continue to determine the battery status; if it does not meet the requirement, it indicates that the power battery is in a charging or discharging state, and go to step 411.

[0146] Step 416: Execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row.

[0147] Determine whether the value of k is greater than L-1. If the condition is met, it means that the "current signal" column data has been traversed and go to step 419; if the condition is not met, extract the kth data data_k according to the row number k and the column number Col_j where the "current signal" is located, and go to step 417.

[0148] Step 417: Determine whether the absolute value of the current value is less than 0.1. If it meets the requirement, it indicates that the power battery is in a static state for 3 consecutive seconds, and go to step 418; if it does not meet the requirement, it indicates that the power battery is in a charging or discharging state, and go to step 411.

[0149] Step 418: execute bk=k-3, that is, it is considered that the power battery is in a static state when the absolute value of the "current signal" for 3 consecutive seconds is less than 0.1A; execute k=k-2, that is, the row number is positioned at the next row of the end position bk of the nth segment data, prepare to extract the data of this row, and go to step 406.

[0150] Step 419: execute bk=k-1, that is, when the traversal of the "current signal" column data is completed, (k-1) is used as the serial number of the end position of the nth segment of data, and the program prompts "the mth file segment ends".

[0151] Step 420: automatically open the mth file and create a new worksheet named "Statistical Results"; automatically write the charging and discharging information of all n segments of data according to the data segmentation; after writing is completed, the file is automatically saved in the "Processing Results" folder; when writing the test results, it is automatically determined whether the equivalent mileage needs to be calculated based on the type of each segment of data.

[0152] Step 421: execute m=m+1, that is, the mth file is processed and ready to process the next file.

[0153] Step 422: Determine whether the value of m is greater than the total number N of files to be processed. If the condition is met, it means that all files have been automatically processed; if the condition is not met, go to step 404.

[0154] Step 423: Data segmentation, result statistics and automatic writing are completed and ended.

[0155] See also Figure 5In this embodiment, step 5 is specifically as follows:

[0156] Step 501: Automatic calculation of mileage begins.

[0157] Step 502: According to the data segmentation result of step 4, it is known that the number of data segments of each file is n, and the serial numbers of the start and end positions of each data segment are ak and bk respectively; at the same time, the "time-vehicle speed-power" file is loaded, and the working condition length is recorded as G.

[0158] Step 503: Mark the data segment number of the currently processed file with o, and initialize o=1.

[0159] Step 504: Start processing the oth segment.

[0160] Step 505: Determine whether the minimum value of all "current signal" data in the oth segment of data is less than 0 (based on the fact that the charging current of the power battery is a positive value and the discharging current is a negative value, the state of the battery per second can be determined). If the minimum value is less than 0, go to step 506; if the minimum value is greater than 0, go to step 509.

[0161] Step 506: The state of the power battery is determined to be discharged, and the equivalent driving mileage needs to be calculated, with S being the accumulated mileage, and S=0 is initialized.

[0162] Step 507: pow_Rea represents the actual discharge power of the power battery, and pow_Sim represents the given power in the “time-vehicle speed-power” file.

[0163] Step 508: Use p1 to mark the row number of the oth segment of data, and initialize p1=ak; use p2 to mark the row number of the given power, and initialize p2=0; use v_p2 to mark the vehicle speed corresponding to the given power.

[0164] Step 509: The power battery is judged to be in the state of charging, and there is no need to calculate the equivalent mileage. o=o+1 is executed, that is, preparation is made to process the next segment of data.

[0165] Step 510: Determine whether the value of o is greater than the total number of data segments n of the current file. If so, go to step 511; if not, go to step 504.

[0166] Step 511: All data segments of the current file have been processed, and the program ends.

[0167] Step 512: Determine whether the absolute value of the difference between the p1th power (pow_Rea-p1) of the oth segment data and the p2th given power (pow_Sim-p2) is less than a preset value (the control error of different devices is different, and the preset value here can be adjusted according to the actual situation. In this embodiment, the preset value is 0.5). The purpose of the judgment here is to find the corresponding position of the actual discharge power of the power battery in the given power table. If the requirements are met, go to step 513; if not, go to step 519.

[0168] Step 513: execute p1=p1+1, p2=p2+1, that is, after the p1th power point is matched successfully, the power row number is increased by 1, and the matching of the (p1+1)th power point is prepared.

[0169] Step 514: Determine whether the value of p1 is greater than the end sequence number bk of the oth segment of data. If the condition is met, go to step 523; if the condition is not met, go to step 515.

[0170] Step 515: Determine whether the value of p2 is greater than (G-1), that is, whether the row number of the given power exceeds the operating condition length. If the condition is met, go to step 516; if the condition is not met, go to step 517.

[0171] Step 516: execute p2=0, initialize the row number mark of the given power to 0, and go to step 512.

[0172] Step 517: Determine whether the absolute value of the difference between the p1th power (pow_Rea-p1) of the oth segment data and the p2th given power (pow_Sim-p2) is less than a preset value. If so, go to step 526; if not, go to step 518.

[0173] Step 518: execute p1=p1-1, that is, the power matching fails, and the actual discharge power number of the power battery is repositioned to the initial test position, while the position number p2 of the given power remains unchanged.

[0174] Step 519: Execute p2=p2+1, that is, add 1 to the given power mark number and locate the next given power.

[0175] Step 520: Determine whether p2 is greater than (G-1). If the condition is satisfied, go to step 521; if the condition is not satisfied, go to step 512.

[0176] Step 521: execute p2=0, that is, relocate the mark number of the given power to the first row; execute p1=p1+1, that is, the p1th actual power is not matched successfully, and prepare to match the next actual power point.

[0177] Step 522: Determine whether the value of p1 is greater than bk. If the condition is met, go to step 523; if the condition is not met, go to step 512.

[0178] Step 523: Execute o=o+1, the oth segment of data has been processed, and the (o+1)th segment of data is ready to be processed.

[0179] Step 524: Determine whether the value of o is greater than the total number of segments n of the current file data. If the condition is met, go to step 525; if the condition is not met, go to step 504.

[0180] Step 525: The equivalent mileage calculation ends.

[0181] Step 526: execute p1=p1+1, p2=p2+1, that is, prepare to perform power matching at the (p1+1)th point.

[0182] Step 527: Determine whether the value of p1 is greater than bk. If the condition is met, go to step 523; if the condition is not met, go to step 528.

[0183] Step 528: Determine whether the value of p2 is greater than (G-1). If the condition is satisfied, go to step 521; if the condition is not satisfied, go to step 529.

[0184] Step 529: Determine whether the absolute value of the difference between the p1th power (pow_Rea-p1) of the oth segment data and the p2th given power (pow_Sim-p2) is less than a preset value. If so, go to step 530; if not, go to step 535.

[0185] Step 530: Execute p1=p1+1, p2=p2+1, that is, prepare to perform power matching at the (p1+1)th point.

[0186] Step 531: Determine whether the value of p1 is greater than bk. If the condition is met, go to step 523; if the condition is not met, go to step 532.

[0187] Step 532: Determine whether the value of p2 is greater than (G-1). If the condition is satisfied, go to step 521; if the condition is not satisfied, go to step 533.

[0188] Step 533: Execute S=v_(p2-1)+v_(p2-2)+v_(p2-3), that is, calculate the equivalent mileage when the first three power matches are successful.

[0189] Step 534: Determine whether the absolute value of the difference between the p1th power (pow_Rea-p1) of the oth segment data and the p2th given power (pow_Sim-p2) is less than a preset value. If so, go to step 537; if not, go to step 536.

[0190] Step 535: execute p1=p1-2, p2=p2-1, that is, the current power matching fails, the actual discharge power of the power battery is repositioned to the initial test position, and the given power is positioned to the next power point of the initial test position, and go to step S512.

[0191] Step 536: execute p1=p1-3, p2=p2-2, that is, the current power matching fails, the actual discharge power of the power battery is repositioned to the initial test position, and the given power is positioned to the next power point of the initial test position, and go to step S512.

[0192] Step 537: execute S=S+v_p2 (accumulate the mileage corresponding to the current power), p1=p1+1, p2=p2+1, that is, after the p1th power point is successfully matched, the power line number is increased by 1, and the matching of the (p1+1)th power point is prepared.

[0193] Step 538: Determine whether the value of p1 is greater than bk. If the condition is met, go to step 523; if the condition is not met, go to step 539.

[0194] Step 539: Determine whether the value of p2 is greater than (G-1). If the condition is satisfied, go to step 540; if the condition is not satisfied, go to step 534.

[0195] Step 540: execute p1=p1-1, p2=0, that is, the given power has been completely traversed, reposition the mark number to the first row, and go to step S512.

[0196] In the present embodiment, a system for automatically processing power battery bench test data includes a memory and a controller. The memory stores a computer-readable program. When the computer-readable program is called by the controller, it can execute the steps of the method for automatically processing power battery bench test data as described in the present embodiment.

[0197] In this embodiment, a storage medium stores a computer-readable program, which, when called, can execute the steps of the method for automatically processing power battery bench test data as described in this embodiment.

Claims

1. A method for automatically processing power battery bench test data, characterized in that: The following steps are involved: Step 1: Run the automatic processing program; Step 2: Select the files or folders you want to process; Step 3: Automatically preprocess the experimental data, including data extraction, format conversion and file saving of the raw data; Step 4: Automatically segment the preprocessed data, including reading the preprocessed file, extracting the current signal, and comparing the current signal with a preset current threshold, wherein the preset current threshold is a threshold for judging whether the power battery is in a charging or discharging state or a static state. If |current signal|≥preset current threshold, the power battery is considered to be in a charging or discharging state; if |current signal|<preset current threshold and lasts for more than a preset time, the power battery is considered to be in a static state; segment the data according to the above standards, and record the start and end serial numbers of each segment of data; Step 5: Based on the data segmentation results of step 4, the charge and discharge time, charge and discharge quantity, and charge and discharge temperature of each segment of data are counted in segments, and the equivalent mileage of the simulated working condition discharge data is calculated; specifically: Step 501: Automatic calculation of mileage begins; Step 502: According to the data segmentation result of step 4, it is known that the number of data segments of each file is n, and the serial numbers of the start and end positions of each data segment are ak and bk respectively; at the same time, the "time-vehicle speed-power" file is loaded, and the working condition length is recorded as G; Step 503: mark the data segment number of the currently processed file with o, and initialize o=1; Step 504: Start processing the oth segment number; Step 505: determine whether the minimum value of all "current signal" data in the oth segment of data is less than 0. If the minimum value is less than 0, go to step 506; if the minimum value is greater than 0, go to step 509; Step 506: the power battery is judged to be in a state of discharge, and the equivalent driving mileage needs to be calculated, with S being the accumulated mileage, and S being initialized to 0; Step 507: pow_Rea represents the actual discharge power of the power battery, and pow_Sim represents the given power in the "time-vehicle speed-power" file; Step 508: mark the row number of the oth segment of data with p1, and initialize p1=ak; mark the row number of the given power with p2, and initialize p2=0; mark the vehicle speed corresponding to the given power with v_p2; Step 509: the power battery is judged to be in charging state, and it is not necessary to calculate the equivalent driving mileage, and o=o+1 is executed, i.e., preparing to process the next segment of data; Step 510: Determine whether the value of o is greater than the total number of data segments n of the current file. If it meets the requirement, go to step 511; If the requirements are not met, go to step 504; Step 511: All data segments of the current file have been processed, and the program ends; Step 512: Determine whether the absolute value of the difference between the p1th power pow_Rea-p1 of the oth segment data and the p2th given power pow_Sim-p2 is less than a preset value, which is adjusted according to the control error of different devices. If the requirement is met, go to step 513; if not, go to step 519; Step 513: execute p1=p1+1, p2=p2+1, that is, after the p1th power point is matched successfully, the power row number is increased by 1, and the matching of the p1+1th power point is prepared; Step 514: Determine whether the value of p1 is greater than the end sequence number bk of the oth segment of data. If the condition is satisfied, go to step 523; if the condition is not satisfied, go to step 515; Step 515: Determine whether the value of p2 is greater than G-1, that is, whether the row number of the given power exceeds the operating condition length. If the condition is met, go to step 516; if the condition is not met, go to step 517; Step 516: execute p2=0, initialize the row number mark of the given power to 0, and go to step 512; Step 517: Determine whether the absolute value of the difference between the p1th power pow_Rea-p1 of the oth segment data and the p2th given power pow_Sim-p2 is less than a preset value. If the requirement is met, go to step 526; if not, go to step 518; Step 518: execute p1=p1-1, that is, the power matching fails, and the actual discharge power number of the power battery is relocated to the initial test position, while the position number p2 of the given power remains unchanged; and go to step 512; Step 519: execute p2=p2+1, that is, add 1 to the given power mark number and locate the next given power; Step 520: Determine whether p2 is greater than G-1. If the condition is met, go to step 521; if the condition is not met, go to step 512; Step 521: execute p2=0, that is, relocate the mark number of the given power to the first row; execute p1=p1+1, that is, the p1th actual power is not matched successfully, and prepare to match the next actual power point; Step 522: Determine whether the value of p1 is greater than bk. If the condition is satisfied, go to step 523; if the condition is not satisfied, go to step 512; Step 523: execute o=o+1, the oth segment of data has been processed, and the o+1th segment of data is ready to be processed; Step 524: Determine whether the value of o is greater than the total number of segments n of the current file data. If the condition is satisfied, go to step 525; if the condition is not satisfied, go to step 504; Step 525: The equivalent mileage calculation ends; Step 526: execute p1=p1+1, p2=p2+1, i.e. prepare to perform power matching at the p1+1th point; Step 527: Determine whether the value of p1 is greater than bk. If the condition is satisfied, go to step 523; if the condition is not satisfied, go to step 528; Step 528: Determine whether the value of p2 is greater than G-1. If the condition is satisfied, go to step 521; if the condition is not satisfied, go to step 529; Step 529: Determine whether the absolute value of the difference between the p1th power pow_Rea-p1 of the oth segment data and the p2th given power pow_Sim-p2 is less than a preset value. If the requirement is met, go to step 530; if not, go to step 535; Step 530: Execute p1=p1+1, p2=p2+1, i.e. prepare to perform power matching at the p1+1th point; Step 531: Determine whether the value of p1 is greater than bk. If the condition is satisfied, go to step 523; if the condition is not satisfied, go to step 532; Step 532: Determine whether the value of p2 is greater than G-1. If the condition is satisfied, go to step 521; if the condition is not satisfied, go to step 533; Step 533: Execute S=v_(p2-1)+v_(p2-2)+v_(p2-3), that is, calculate the equivalent mileage when the first three power matches are successful; Step 534: determine whether the absolute value of the difference between the p1th power pow_Rea-p1 of the oth segment data and the p2th given power pow_Sim-p2 is less than a preset value. If the requirement is met, go to step 537; if not, go to step 536; Step 535: execute p1=p1-2, p2=p2-1, that is, the current power matching fails, the actual discharge power of the power battery is relocated to the initial test position, and the given power is located to the next power point of the initial test position, and go to step S512; Step 536: execute p1=p1-3, p2=p2-2, that is, the current power matching fails, the actual discharge power of the power battery is relocated to the initial test position, and the given power is located to the next power point of the initial test position, and go to step S512; Step 537: execute S=S+v_p2, accumulate the mileage corresponding to the current power, p1=p1+1, p2=p2+1, that is, after the p1th power point is successfully matched, the power line number is increased by 1, and the p1+1th power point is prepared for matching; Step 538: Determine whether the value of p1 is greater than bk. If the condition is satisfied, go to step 523; if the condition is not satisfied, go to step 539; Step 539: Determine whether the value of p2 is greater than G-1. If the condition is satisfied, go to step 540; if the condition is not satisfied, go to step 534; Step 540: execute p1=p1-1, p2=0, that is, the given power has been completely traversed, reposition the mark number to the first row, and go to step S512; Step 6: Automatically write the automatically counted test results into the specified file and keep them in the specified file path; Step 7: Data automatic processing is completed.

2. The method for automatically processing power battery bench test data according to claim 1, characterized in that: The step 3 is specifically as follows: Step 301: Data preprocessing begins; Step 302: determine the file path of the data to be processed, and automatically search for all files of the specified file type under the path, save the file names and file quantity N that meet the conditions, and create a new "pre-processing" folder under the current path; Step 303: Use variable i to mark the serial number of the file being processed by the current program, initialize i=1, load the preset variable signal list at the same time, and use M to mark the number of preset signals; Step 304: read the i-th file and automatically locate the line where the signal name is located; Step 305: Mark the sequence number of the preset signal with j, and initialize j=1; Step 306: Automatically search for the jth preset signal name in the row where the signal name is located. If it can be found, record the column number Col_j where the signal is located. If the search fails, report a warning. Step 307: j=j+1, i.e. searching for the next preset signal; Step 308: Determine whether the current value of j is less than or equal to the total number M of preset signals. If so, go to step 306; if not, it means that all preset signals have been retrieved, go to step 309; Step 309: Create a new EXCEL file in the "pre-processing" folder, and automatically copy all column data of all preset signals. After the copying is completed, save the file as "original name of the i-th data" + "pre-processing.xlsx"; Step 310: i=i+1, i.e., preprocessing the next file; Step 311: determine whether the current value of i is less than or equal to the total number N of files to be processed. If so, go to step 304; if not, it means that all files to be processed have been pre-processed, go to step 312; Step 312: The pre-processing function is completed and ends.

3. The method for automatically processing power battery bench test data according to claim 2, characterized in that: The step 4 is specifically as follows: Step 401: Data segmentation starts; Step 402: Automatically search for files with a file type of ".XLSX" in the "pre-processing" folder, record the number of files that meet the requirements as N, and create a new "processing result" folder under the original file path; Step 403: mark the sequence number of the currently processed file with m, and initialize m=1; Step 404: Start processing the mth file, automatically open the file, and read the data in the column where "current signal" is located, and record the data volume of the column as L; Step 405: mark the data segment number of the current file with n, and initialize n=0; mark the row number of the column where "current signal" is located with k, and initialize k=0; mark the row numbers of the start and end positions of the nth segment of data with ak and bk respectively; Step 406: extract the kth data data_k according to the row number k and the column number Col_j where the "current signal" is located; Step 407: Determine whether the absolute value of the current value is less than a preset current threshold value. If the requirement is met, it indicates that the power battery is in a static state, and the process goes to step 408; if the requirement is not met, it indicates that the power battery is in a charging or discharging state, and the process goes to step 410; Step 408: execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row; Step 409: Determine whether the value of k is greater than L-1. If the condition is satisfied, it means that the data in the "current signal" column has been traversed and the process goes to step 419. If the condition is not satisfied, the process goes to step 406. Step 410: execute n=n+1, that is, the number of data segments of the mth file is increased by 1; execute ak=k, that is, the k value is used as the starting sequence number of the nth segment of data; execute k=k+1, that is, the line number is increased by 1, and prepare to extract the next line of data; Step 411: determine whether the absolute value of the current value is less than a preset current threshold value. If the requirement is met, it indicates that the power battery is in a static state for 1 second, and the process goes to step 414 to continue to determine the battery state. If the requirement is not met, it indicates that the power battery is still in a charging or discharging state, and the process goes to step 412. Step 412: Execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row; Step 413: Determine whether the value of k is greater than L-1. If it meets the requirement, it indicates that the data in the "current signal" column has been traversed and the process goes to step 419. If it does not meet the requirement, the process goes to step 411. Step 414: execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row; Step 415: Determine whether the absolute value of the current value is less than a preset current threshold value. If the requirement is met, it indicates that the power battery is in a static state for 2 seconds, and the process goes to step 416 to continue to determine the battery state. If the requirement is not met, it indicates that the power battery is in a charging or discharging state, and the process goes to step 411. Step 416: execute k=k+1, that is, the row number is increased by 1, and prepare to extract the data of the next row; Step 417: Determine whether the absolute value of the current value is less than a preset current threshold value. If the requirement is met, it indicates that the power battery is in a static state for 3 seconds, and the process goes to step 418; if the requirement is not met, it indicates that the power battery is in a charging or discharging state, and the process goes to step 411; Step 418: execute bk=k-3, that is, it is considered that the power battery is in a static state when the absolute value of the "current signal" for 3 consecutive seconds is less than the preset current threshold; execute k=k-2, that is, the row number is located at the next row of the end position bk of the nth segment data, and prepare to extract the data of this row, and go to step 406; Step 419: execute bk=k-1, that is, when the traversal of the "current signal" column data is completed, k-1 is used as the sequence number of the end position of the nth segment of data; Step 420: automatically open the mth file and create a new worksheet named "Statistical Results"; according to the data segmentation, automatically write the charge and discharge information of all n segments of data; After writing is completed, the file is automatically saved in the "Processing Results" folder; when writing test results, it is automatically determined whether the equivalent mileage needs to be calculated based on the type of each segment of data; Step 421: execute m=m+1, that is, the mth file is processed and ready to process the next file; Step 422: determine whether the value of m is greater than the total number N of files to be processed. If the condition is satisfied, it means that all files have been automatically processed. If the condition is not satisfied, go to step 404. Step 423: Data segmentation, result statistics and automatic writing are completed and ended.

4. The method for automatically processing power battery bench test data according to claim 3 is characterized in that: Before executing step 411, the following steps are further performed: Determine whether the value of k is greater than L-1. If the condition is met, it means that the "current signal" column data has been traversed and the process goes to step 419. If the condition is not met, extract the kth data data_k according to the row number k and the column number Col_j where the "current signal" is located, and the process goes to step 411.

5. The method for automatically processing power battery bench test data according to claim 4 is characterized in that: Before executing step 415, the following steps are further performed: Determine whether the value of k is greater than L-1. If the condition is met, it means that the "current signal" column data has been traversed and the process goes to step 419. If the condition is not met, extract the kth data data_k according to the row number k and the column number Col_j where the "current signal" is located, and the process goes to step 415.

6. The method for automatically processing power battery bench test data according to claim 5, characterized in that: Before executing step 417, the following steps are further performed: Determine whether the value of k is greater than L-1. If the condition is met, it means that the "current signal" column data has been traversed and go to step 419; if the condition is not met, extract the kth data data_k according to the row number k and the column number Col_j where the "current signal" is located, and go to step 417.

7. A power battery bench test data automatic processing system, characterized by: It comprises a memory and a controller, wherein the memory stores a computer-readable program, and when the computer-readable program is called by the controller, it can execute the steps of the method for automatically processing power battery bench test data as described in any one of claims 1 to 6.

8. A storage medium, characterized in that: A computer-readable program is stored therein, which, when called, can execute the steps of the method for automatically processing power battery bench test data as described in any one of claims 1 to 6.