CN116298932A

CN116298932A - Battery test data processing method, system, device, equipment and storage medium

Info

Publication number: CN116298932A
Application number: CN202310560672.7A
Authority: CN
Inventors: 殷俏; 胥飞龙; 王旭聪
Original assignee: Jiangsu Contemporary Amperex Technology Ltd
Current assignee: Jiangsu Contemporary Amperex Technology Ltd
Priority date: 2023-05-18
Filing date: 2023-05-18
Publication date: 2023-06-23
Anticipated expiration: 2043-05-18
Also published as: CN116298932B

Abstract

The application discloses a battery test data processing method, a system, a device, equipment and a storage medium. The method comprises the following steps: detecting a test completion signal of the test equipment through the test plug-in program, and determining a channel number for completing the test based on the test completion signal; test data corresponding to the channel numbers are obtained from the test equipment, and the mapping relation between the channel numbers and the test data is stored in a data storage table; a test report is generated based on the data storage table. The whole process of the embodiment of the application does not need to manually check whether the test is finished or not, and does not need to manually record test data. Whether the test is finished or not can be automatically detected through the test plug-in program, the export process of the test data and the generation of the test report are automatically finished, the automation degree of the whole process is improved, the labor cost is saved, the processing efficiency of the test data is improved, and errors caused by manual operation are reduced.

Description

Battery test data processing method, system, device, equipment and storage medium

Technical Field

The present disclosure relates to the field of battery technologies, and in particular, to a battery test data processing method, system, device, equipment, and storage medium.

Background

In a plurality of links of battery production and use, performance test is required to be carried out on the battery, and whether the battery meets the standards is judged according to test data.

In the related art, from the performance test of the battery by the test equipment to the generation of a test report, a large amount of manual participation is required in the whole process, so that the test efficiency is low and errors are easy to occur.

The statements are to be understood as merely provide background information related to the present application and may not necessarily constitute prior art.

Disclosure of Invention

In view of the above problems, the present application provides a battery test data processing method, system, device, equipment and storage medium, which can improve the automation degree of the battery test data processing process, and alleviate the problems of low test efficiency and easy error caused by too much manual participation.

In a first aspect of an embodiment of the present application, a battery test data processing method is provided, including:

detecting a test completion signal of the test equipment through the test plug-in program, and determining a channel number for completing the test based on the test completion signal;

obtaining test data corresponding to the channel number from the test equipment, and storing the mapping relation between the channel number and the test data into a data storage table;

And generating a test report based on the data storage table.

In the embodiment, the test plug-in program is set, and the test plug-in program automatically responds to the test completion signal of the test equipment, so that the channel number of the test channel with the completed test can be automatically identified based on the test completion signal, the test data measured by the test channel with the completed test can be automatically acquired from the test equipment based on the channel number, and the test data can be automatically written into the data storage table. The automatic storage of the test data is realized, the test data is not required to be transcribed into the designated file manually, the efficiency of the test data transfer is improved, and the occurrence of the condition of data errors caused by manual operation is reduced. A test report is generated based on the data storage table. And the test is not required to be manually checked, and the test data is not required to be manually recorded. Whether the test is finished or not and the export process of the test data can be automatically finished through the test plug-in program, a test report is generated based on a data storage table storing the test data, the automation degree of the whole process is improved, the labor cost is saved, the processing efficiency of the test data is improved, and errors caused by manual operation are reduced.

In some embodiments of the present application, the detecting, by the test plug-in, a test completion signal of the test device includes:

and detecting that the status flag bit in the test equipment is updated to be a test channel for indicating the completion of the test by the test plug-in program, and triggering and generating a test completion signal of the test equipment.

The test plug-in program is used for monitoring the status zone bit of each test channel in the test equipment, so that whether the test channel with the finished test appears in the test equipment is automatically detected, whether the test channel with the finished test appears is not required to be checked manually, and the labor cost is saved.

receiving equipment state information transmitted by the test equipment;

and detecting that the equipment state information carries the channel number of the tested channel by the test plug-in program, and triggering to generate a test completion signal of the test equipment.

The test equipment automatically uploads the equipment state information of the test equipment, and the test plug-in program automatically identifies whether the channel number of the test completion exists in the equipment state information, so that whether the test channel of the test completion exists in the test equipment is automatically detected, whether the test channel of the test completion exists is not required to be checked manually, and the labor cost is saved.

In some embodiments of the present application, storing the mapping relationship between the channel number and the test data in a data storage table includes:

caching the mapping relation between the channel numbers and the test data into a preset test file;

and under the condition that the data quantity stored in the preset test file reaches a preset threshold value, the data currently cached in the preset test file are transferred to a data storage table in batches.

And caching the mapping relation between the channel numbers and the test data through a preset test file, and storing the cached data in a data storage table in a memory in batches under the condition that the cached data reach a preset threshold value. Therefore, the number of times of writing data into the data storage table in the memory can be reduced, the computing resource of the equipment is saved, and the whole process of caching the data into the preset test file and storing the data into the data storage table in batches is automatically completed by the equipment without manual operation, so that the efficiency and the accuracy of data storage are improved.

In some embodiments of the present application, the caching the mapping relationship between the channel number and the test data into a preset test file includes:

Identifying a current storage offset address in a preset test file;

and caching the mapping relation between the channel number and the test data into the preset test file based on the storage offset address and the file parameters of the preset test file.

In this embodiment, the storage offset address of the preset test file can be automatically identified, and the mapping relationship between the channel number and the test data is automatically cached in the preset test file based on the storage offset address and the file parameter of the preset test file. In the process, manual operation is not needed, the data caching efficiency is high, and data errors caused by manual data recording are reduced.

In some embodiments of the present application, the generating a test report based on the data storage table includes:

screening test data and test conditions of at least one battery required by a report from the data storage table, wherein the test conditions are recorded in the data storage table in the starting process of a battery test program;

and generating a test report based on the test data and the test conditions of the at least one battery.

And screening test data and test conditions of at least one battery from data corresponding to a plurality of batteries stored in the data storage table, and automatically generating a test report based on the screened test data and test conditions. The automatic analysis processing of the test data, the test conditions and other data is realized, the test report is automatically generated, the artificial subjective analysis and the artificial transcription of the data are not needed, the generation efficiency and the accuracy of the test report are improved, and the data error caused by the artificial operation is reduced.

In some embodiments of the present application, the screening test data and test conditions of at least one battery required for reporting from the data storage table includes:

traversing the test data of each battery in the data storage table, and eliminating the test data of which the included parameter value is not in a preset normal value interval;

and selecting test data and test conditions of at least one battery from the rest of the test data.

The record containing the abnormal parameter value in the data storage table is deleted, and the data required by screening the report is selected from the rest test data. The test data with abnormal parameter values are automatically identified and removed, so that the influence of the abnormal parameter values on the test result can be reduced, and the accuracy of the test result is improved.

In some embodiments of the present application, the selecting the test data and the test conditions of the at least one battery from the remaining test data includes:

calculating average values of preset parameters in the rest test data;

and selecting a preset number of test data with the minimum difference value between the preset parameter value and the average value and corresponding test conditions from the rest test data.

And solving the average value of the preset parameters for the rest test data after the abnormal data are removed, and selecting the preset number of test data with the value of the preset parameters closest to the preset average value and the corresponding test conditions. The error of the selected test data is smaller, which is helpful to improve the accuracy of the final test result and the accuracy of the test report.

In some embodiments of the present application, the generating a test report based on the test data and the test conditions of the at least one battery includes:

acquiring a report template based on a preset storage path;

determining a test result based on the test data of the at least one battery and a preset specification interval in the report template;

and filling the test result, the test data and the test conditions of the at least one battery into the report template to obtain a test report.

According to the embodiment, the report template is automatically opened, the test result is automatically judged based on the test data and the preset specification interval, the objectivity of the judgment of the test result is improved, and the occurrence of misjudgment caused by artificial subjective judgment is reduced. And automatically generating a test report based on the test conditions, the test data, the determined test result and the report template. The whole generation process of the test report does not need manual operation, so that the automation degree of generating the test report is improved, and the report generation efficiency and accuracy are improved.

In some embodiments of the present application, the filling the test result, the test data of the at least one battery, and the test condition into the report template to obtain a test report includes:

analyzing the report template, and respectively determining the test result, the test data of the at least one battery and the corresponding filling position of each data in the report template;

and filling each data into the report template based on the determined filling position to obtain a test report.

By automatically identifying filling positions of all data in the report template, the data is automatically written into the report template based on the identified filling positions, and automatic generation of a test report is realized. The data is not required to be written into the report template manually, so that the generation efficiency and accuracy of the test report are improved, and the data errors caused by manual writing are reduced.

In a second aspect of embodiments of the present application, a battery test data processing system includes: test equipment and an upper computer;

the test equipment is provided with at least one test channel, and the battery to be detected is tested through the test channel;

the upper computer is connected with the testing equipment and is used for executing the method in the first aspect.

In a third aspect of the embodiments of the present application, a battery test data processing apparatus includes:

the determining module is used for detecting a test completion signal of the test equipment through the test plug-in program and determining a channel number for completing the test based on the test completion signal;

the storage module is used for acquiring test data corresponding to the channel number from the test equipment and storing the mapping relation between the channel number and the test data into a data storage table;

and the report generation module is used for generating a test report based on the data storage table.

In a fourth aspect of embodiments of the present application, there is provided an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor executing the program to implement the method as described in the first aspect.

In a fifth aspect of embodiments of the present application, there is provided a computer readable storage medium having stored thereon a computer program to be executed by a processor to implement the method of the first aspect.

A sixth aspect of embodiments of the present application provides a computer program product comprising a computer program for execution by a processor to implement the method of the first aspect described above.

Additional features and advantages of the application will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the application.

Drawings

Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the embodiments. The drawings are only for purposes of illustrating embodiments of the present application and are not to be construed as limiting the application. Also, like reference numerals are used to designate like parts throughout the accompanying drawings.

Fig. 1 is a flow diagram of a battery test data processing method provided in accordance with one or more embodiments.

Fig. 2 is another flow diagram of a battery test data processing method provided in accordance with one or more embodiments.

FIG. 3 is a schematic diagram of an operator interface for filling out test conditions provided in accordance with one or more embodiments.

FIG. 4 is a schematic diagram of a battery test data processing system provided in accordance with one or more embodiments.

Fig. 5 is a schematic diagram of a battery test data processing device provided in accordance with one or more embodiments.

Fig. 6 is a block diagram of an electronic device in accordance with one or more embodiments.

FIG. 7 is a schematic diagram of a computer-readable storage medium in accordance with one or more embodiments.

Detailed Description

Embodiments of the technical solutions of the present application will be described in detail below with reference to the accompanying drawings. The following examples are only for more clearly illustrating the technical solutions of the present application, and thus are only examples, and are not intended to limit the scope of protection of the present application.

Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs; the terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application; the terms "comprising" and "having" and any variations thereof in the description and claims of the present application and in the description of the figures above are intended to cover non-exclusive inclusions.

In the description of the embodiments of the present application, the technical terms "first," "second," etc. are used merely to distinguish between different objects and are not to be construed as indicating or implying a relative importance or implicitly indicating the number of technical features indicated, a particular order or a primary or secondary relationship. In the description of the embodiments of the present application, the meaning of "plurality" is two or more (including two) unless otherwise specifically defined.

Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the present application. The appearances of such phrases in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Those of skill in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments.

In the description of the embodiments of the present application, the term "and/or" is merely an association relationship describing an association object, which means that three relationships may exist, for example, a and/or B may mean: there are three cases, a, B, a and B simultaneously. In addition, the character "/" herein generally indicates that the front and rear associated objects are an "or" relationship.

Multiple processes in the battery manufacturing process may require testing of raw materials of the battery, semi-finished or finished batteries produced, etc. For raw materials or semi-finished products, the raw materials or semi-finished products often need to be assembled into batteries first, and then tested by using testing equipment. And judging whether the measured raw materials, semi-finished products or finished batteries and the like reach the standard or not according to the test data.

The test device in the related art has a plurality of test channels, through which a plurality of batteries to be tested can be tested at the same time. After a test of a certain test channel is completed, a mark for the test channel to be completed is displayed in a display interface of the test equipment, and the mark can include, but is not limited to, the words "test completed" or check number ". V. During the test, a worker needs to check the display interface of the test equipment from time to determine whether a test channel is available for completing the test. If the test channel which completes the test is seen, the test data measured by the test channel is manually recorded into the designated file. When a test report is required to be sent, the staff manually processes the test data, and manually fills in test conditions and the test data on a system interface for sending the report. And manually judging whether the test result is qualified or unqualified based on the test data, and writing the judged test result in a system interface so as to form a test report.

As can be seen from the above related art process, the whole process basically depends on manual operation and artificial subjective judgment, so that the time from the start of the test to the output of the test report is long, the labor cost is high, and the data error or report error caused by the human is easy to occur.

Taking the test of the anode powder and the cathode powder as an example, in order to produce a battery with energy density reaching the standard, the anode powder and the cathode powder need to be assembled into a half-button battery before production, and the half-button battery is subjected to the first charge and discharge test so as to identify the anode powder and the cathode powder which do not reach the standard in advance. The blue electric tester is used for carrying out charge and discharge tests on the assembled semi-button battery, a check number is displayed on a display interface of the blue electric tester after the test is finished, and after a worker sees the check number displayed, test data such as charge capacity, discharge capacity, charge and discharge efficiency and the like measured by the tested channel are manually pasted into a specified table file. When a test report is required to be sent, a worker compares the test data in the form file, manually fills the test data into the report template, and manually fills the test conditions into the report template. The whole process from the testing of the half-cell by the blue-ray tester to the generation of a test report is therefore basically dependent on manual operation by a worker, and is time-consuming and prone to error.

Based on the above, the embodiment of the application designs a battery test data processing method, which detects a test completion signal of test equipment through a test plug-in program, and determines a channel number for completing the test based on the test completion signal; test data corresponding to the channel numbers are obtained from the test equipment, and the mapping relation between the channel numbers and the test data is stored in the data storage table. A test report is generated based on the data storage table.

The battery test data processing method provided by the embodiment of the application can be applied to processing test data of any battery, including but not limited to processing test data of batteries such as lithium ion batteries, lithium metal batteries, lead-acid batteries, nickel-metal batteries, nickel-hydrogen batteries, lithium-sulfur batteries or sodium ion batteries. Suitable batteries include, but are not limited to, battery cells, battery modules, battery packs, and the like of different sizes. The method can be used for processing test data obtained by testing the battery by any test equipment, wherein the test equipment comprises, but is not limited to, a blue-ray tester, a battery internal resistance tester, a battery discharge tester, a battery inspection tester, a battery capacity tester and the like. The battery test data processing method provided by the embodiment of the application can be applied to various stages in the battery production process, including but not limited to a batching stage, an activation stage, a sample inspection stage, a factory compliance inspection stage and the like.

In some embodiments of the present application, the devices involved in the battery test data processing method may include, but are not limited to, test devices and a host computer. The test equipment can include, but is not limited to, instruments and equipment for performing internal resistance tests, positive/negative electrode material tests, capacity tests, charge/discharge tests and the like on the battery. The host computer may include, but is not limited to, a server or terminal connected to the test equipment. The connection relationship between the upper computer and the test equipment can be wired connection or wireless connection, etc.

In these embodiments, the above-described test plug-in may be installed in the host computer, through which the host computer detects whether a test completion signal of the test device is present. Under the condition that the test completion signal is detected, the upper computer exports the test data measured by the test equipment to a data storage table in the memory of the upper computer through the test plug-in program. The upper computer automatically generates a test report based on the data stored in the data storage table through the test plug-in. Therefore, manual operation is greatly reduced in the whole process, labor cost is saved, processing efficiency is improved, and data errors caused by manual misoperation are reduced.

In other embodiments of the present application, the apparatus involved in the battery test data processing method may also include a test apparatus, and the test plug-in may be installed in the test apparatus, through which the test apparatus detects whether a test completion signal occurs. And under the condition that the test completion signal is detected, exporting and storing the measured test data into a data storage table in the memory of the test equipment through the test plug-in program. The test equipment automatically generates a test report based on the data stored in the data storage table through the test plug-in. Therefore, manual operation is greatly reduced in the whole process, labor cost is saved, processing efficiency is improved, and data errors caused by manual misoperation are reduced. In addition, in the embodiments, the whole process from the battery testing to the test report generating can be automatically completed through the test equipment, the product form of the test equipment capable of directly outputting the test report is provided, and the hardware cost of the whole test process is reduced.

For convenience of description, the specific processing procedure of the embodiment of the present application will be described in detail below by taking an example that the related devices include a host computer and a test device. Referring to fig. 1, the battery test data processing method provided in the embodiment of the present application specifically includes the following steps:

Step 101: and detecting a test completion signal of the test equipment through the test plug-in program, and determining a channel number for completing the test based on the test completion signal.

Step 102: test data corresponding to the channel numbers are obtained from the test equipment, and the mapping relation between the channel numbers and the test data is stored in the data storage table.

Step 103: a test report is generated based on the data storage table.

The test completion signal is used for indicating the test process of the test equipment on the battery to be ended. The test plug-in is used for detecting whether a test completion signal of the test equipment appears, exporting test data of the battery which is indicated by the test completion signal and completes the test to the data storage table when the test completion signal is detected, and generating a test report based on the data storage table. In other words, the test plug-in is used for automatically completing the operations from testing the battery to producing a test report. The data storage table may be a storage structure in memory for storing data.

In the embodiment of the application, the test equipment is provided with a plurality of test channels, and when a certain test is needed to be carried out on the battery, the plurality of batteries can be respectively tested through the plurality of test channels, so that the accuracy of a test result is improved, and the situation that the test result accuracy is reduced due to the fact that the test of a small number of batteries is high in accident is reduced. Each test channel in the test equipment is correspondingly provided with a channel number, and after the test of the battery is completed by using one test channel, the mapping relation between the channel number of the test channel and the measured test data is recorded in the test equipment.

The test completion signals include, but are not limited to, a channel number for completion of the test and an indicator for indicating completion of the test. The indicator may be, for example, a character string of 001 or 010 or the like for uniquely indicating that the test is completed.

And under the condition that the upper computer detects a test completion signal of the test equipment through the test plug-in program, analyzing the test completion signal, and extracting the channel number of the test channel of which the current test is completed. And then transmitting a data acquisition instruction to the test equipment, wherein the data acquisition instruction carries the channel number extracted from the test completion signal. The test equipment receives the data acquisition instruction, acquires the test data corresponding to the channel number carried by the data acquisition instruction from the mapping relation between the stored channel number and the test data, and sends the acquired test data to the upper computer. The upper computer stores the received test data into a data storage table in the memory through the test plug-in. The data storage table stores the test data in the form of a mapping relationship between the channel numbers and the test data.

In this embodiment, the channel number of the test channel for which the test is completed can be automatically identified, the test data measured by the test channel for which the test is completed is automatically acquired from the test apparatus based on the channel number, and the test data is automatically written into the data storage table. The automatic storage of the test data is realized, the test data is not required to be transcribed into the designated file manually, the efficiency of the test data transfer is improved, and the occurrence of the condition of data errors caused by manual operation is reduced.

The test report is used to show all data related to battery testing including, but not limited to, test conditions, test data, test results, and the like. The test conditions may include, but are not limited to, conditions reflecting the environment in which the battery is subjected during testing of the battery, the current input to the battery or the voltage applied during testing, and the like. The test data may include battery performance parameters reflected by the battery under test conditions including, but not limited to, current, voltage, discharge capacity, charge-discharge efficiency, and the like. The test result is used for reflecting whether the tested battery is qualified or not.

And automatically responding to a test completion signal of the test equipment through the test plug-in by setting the test plug-in, storing test data of the battery which completes the test into a data storage table, and generating a test report based on the data storage table. And the test is not required to be manually checked, and the test data is not required to be manually recorded. Whether the test is finished or not and the export process of the test data can be automatically finished through the test plug-in program, a test report is generated based on a data storage table storing the test data, the automation degree of the whole process is improved, the labor cost is saved, the processing efficiency of the test data is improved, and errors caused by manual operation are reduced.

In some embodiments of the present application, detecting, by the test plug-in, a test completion signal of the test device may include: and detecting that the status flag bit in the test equipment is updated to be a test channel for indicating the completion of the test by the test plug-in program, and triggering to generate a test completion signal of the test equipment.

In this embodiment, each test channel in the test device may have a status flag bit that may have both a first value to identify that the test channel is not tested and a second value to identify that the test channel is tested. When the test channel is testing the battery, the value of the status flag bit is a first value, and when the test channel is testing the battery, the status flag bit is updated from the first value to a second value.

The status flag bit of each test channel in the test equipment is detected in real time through the test plug-in program, when the status flag bit is detected to be updated from the first value to the second value, that is, the status flag bit is detected to be updated to be the test channel indicating the test completion, the test completion signal of the test equipment is triggered and generated at this time, and then step 101 is executed to respond to the test completion signal to perform subsequent operations.

In other embodiments of the present application, another way of detecting whether a test completion signal occurs is provided, which may specifically include receiving device status information transmitted by a test device; and detecting that the equipment state information carries the channel number of the tested channel after the test is finished by the test plug-in program, and triggering to generate a test finishing signal of the test equipment.

In this embodiment, the test device is communicatively connected to the host computer, and the test device may periodically generate device status information to the host computer, where the device status information may include, but is not limited to, a status of each test channel, and the status of each test channel may be represented by a channel number and a status identifier for indicating whether the test is complete. Analyzing the equipment state information through the test plug-in program, and triggering to generate a test completion signal of the test equipment if the equipment state information is identified to carry the channel number of the test channel after the test is completed.

In some embodiments of the present application, the mapping relationship between the channel number after the test is completed and the corresponding test data is cached in a preset test file; and under the condition that the data quantity stored in the preset test file reaches a preset threshold value, the data currently cached in the preset test file are transferred to the data storage table in batches.

The preset test file may be a file set in a cache for caching test data, and the preset test file may include, but is not limited to, an Excel file or a CSV (Comma Separated Values) file. The preset threshold includes, but is not limited to, 6 test channels of data, 8 test channels of data, 10 test channels of data, etc.

After the upper computer obtains the test data corresponding to the channel number after the test is completed from the test equipment, the mapping relation between the channel number and the test data can be cached in a preset test file. And recording the current data quantity of the data stored in the preset test file, comparing the current data quantity with a preset threshold value, if the current data quantity is smaller than the preset threshold value, continuing to wait for a new test channel to be tested, and continuing to buffer the data in the preset test file according to the mode. And if the current data volume in the preset test file is judged to be greater than or equal to the preset threshold value, the data currently cached in the preset test file is transferred to a data storage table in the memory in batches.

After the data of the current cache are transferred to the data storage table in batches, the data of the current cache in the preset test file are also emptied, so that a storage space is reserved for storing the data of the completion of the subsequent test.

In some embodiments of the present application, the process of caching data in the preset test file may include identifying a current storage offset address in the preset test file; and caching the mapping relation between the channel number and the test data into the preset test file based on the storage offset address and the file parameters of the preset test file.

The storage offset address is used for indicating the starting position of the currently free storage space in the preset test file. The file parameters of the preset test file may include, but are not limited to, the file format of the preset test file, the data organization order in the file, and the like. The file format of the preset test file may include, but is not limited to, csv or xls, etc. The data organization order in the file is used to specify the order in which the different data are arranged in the file.

Based on file parameters of a preset test file, converting the mapping relation between the channel numbers and the test data into data conforming to the data format and the data organization form of the preset test file, and then storing the converted data into the preset test file according to the storage offset address.

Different file formats and data organization sequences have different requirements on the data format and data organization form of the stored data. For example, if the file format of the preset test file is xls, the data organization sequence in the preset test file is the arrangement sequence of the channel number, the discharge capacity, the charge capacity and the charge-discharge efficiency. The channel number, the discharge capacity, the charge capacity and the charge-discharge efficiency included in the test data are required to be ordered according to an arrangement sequence specified by the data organization sequence in the preset test file. And then storing the sorted channel numbers, discharge capacity, charge capacity and charge-discharge efficiency into a preset test file based on the storage offset address. And if the storage position indicated by the storage offset address is the 3 rd row in the preset test file, sequentially storing the ordered channel number, discharge capacity, charge capacity and charge-discharge efficiency into each column of the 3 rd row of the preset test file, namely storing the channel number in the 3 rd row and the 1 st column after storage, storing the discharge capacity in the 3 rd row and the 2 nd column, storing the charge capacity in the 3 rd row and the 3 rd column, and storing the charge-discharge efficiency in the 3 rd row and the 4 th column.

For another example, if the file format of the preset test file is csv, it is assumed that one line of the file is a record, and the data organization sequence of each record is the same, and the record is "channel number: arrangement of test data ". The acquired channel number and the corresponding test data form a channel number: arrangement of test data ". The "channel number" to be formed is then based on the memory offset address: the test data is written into a preset test file.

By the embodiment, the mapping relation between the tested test channel and the test data is automatically cached in the preset test file, and the cached data is transferred to the data storage table in the memory in batches under the condition that the cached data amount in the preset test file reaches the preset threshold value. In the event that the data in the data storage table reaches the amount required to report, a test report may be automatically generated from the data in the data storage table. The amount required to report may include, but is not limited to, 10 test channels of test data, 20 test channels of data, 25 test channels of data, and so forth. The data of the test channel may include a mapping relationship of the channel number and the corresponding test data.

In some embodiments of the present application, the process of generating the test report may include screening test data and test conditions of at least one battery required for reporting from a data storage table, where the test conditions are entered into the data storage table during a start-up process of a battery test program; and generating a test report based on the test data and the test conditions of the screened at least one battery.

Before a test program for a certain battery is started by the test equipment, the test conditions of the test are required to be set, and in particular, various test conditions including but not limited to temperature, humidity, test date, test duration, type of pole piece, current collector quality, theoretical gram capacity and the like can be recorded in a test interface of the test equipment or an upper computer. After the test conditions are set and the test starting instruction is triggered, the test equipment tests the battery according to the set test conditions. After the test conditions are set, if all the test conditions are recorded in the test interface of the test equipment, the test equipment can send all the test conditions and the channel number of the currently used test channel to the upper computer, and the upper computer stores the mapping relation between the channel number and the test conditions in the data storage table. If all the test conditions are recorded in the test interface of the upper computer, the channel numbers of the used test channels can be set in the test interface, and the upper computer stores the mapping relation between the set channel numbers and the test conditions into the data storage table.

In the above embodiments, the mapping relationship between the channel number and the test data is stored in the data storage table, or the storage location of the channel number and the test condition in the data storage table may be located based on the channel number, and the test data corresponding to the channel number, the stored channel number and the stored test condition are stored in association, so that the mapping relationship between the channel number, the test condition and the test data is formed in the data storage table.

In some embodiments of the present application, the process of screening data from the data storage table may include traversing test data of each battery in the data storage table, and rejecting test data that includes parameter values that are not within a preset normal value interval; and selecting test data and test conditions of at least one battery from the rest of the test data.

In these embodiments, a preset normal value interval of each parameter involved in the test data is preset, and the parameters in the test data include, but are not limited to, one or more of parameters of discharge capacity, charge-discharge efficiency, internal resistance, current, voltage, and the like. If the parameter value is not within the preset normal value corresponding to the parameter, the parameter value is indicated to be the abnormal parameter value, and the test data, the test condition and the corresponding channel number containing the abnormal parameter value are removed. That is, a record corresponding to the test data having the abnormal parameter value is removed.

In other embodiments of the present application, the process of selecting data from the data storage table after removing the abnormal data may include calculating an average value of a preset parameter in the remaining test data; and selecting a preset number of test data with the minimum difference value between the preset parameter value and the average value and corresponding test conditions from the rest test data.

The above-mentioned preset parameter may be any one of various parameters included in the test data, for example, the test data may include parameters such as a discharge capacity, a charge-discharge efficiency, etc., the preset parameter may be a discharge capacity, or the preset parameter may be a charge capacity, a charge-discharge efficiency, etc.

And for each piece of residual test data, acquiring the value of the preset parameter in each piece of residual test data, and averaging the values of the preset parameters. And respectively calculating the difference value between the value of the preset parameter in each residual test data and the calculated average value, determining the preset number of test data with the minimum difference value, and acquiring the preset number of test data and the corresponding test conditions from a data storage table.

In some embodiments of the present application, using the data selected in the above embodiments, a test report is generated by:

Acquiring a report template based on a preset storage path; determining a test result based on the test data of at least one battery and a preset specification interval in a report template; and filling the test result, the test data of at least one battery and the test conditions into a report template to obtain a test report.

In this embodiment, the storage path of the report template is preset, and the report template does not need to be manually opened when the report is required to be sent. The device can automatically open the report template based on a preset storage path. And if the report template needs to be modified, the modified report template is stored under the storage path after the report template is modified, and the device can directly open the modified report template based on the storage path when the report template needs to be generated, so that the report template can be maintained conveniently.

The report template is pre-written with a preset specification interval, and the preset specification interval is used for judging whether the test result of the test is qualified or unqualified. The preset specification interval may include, but is not limited to, a qualified value interval required for at least one parameter in the test data. For example, the preset specification interval may include a qualified value interval of charge-discharge efficiency, if the charge-discharge efficiency in the test data is within the qualified value interval, the battery to which the test data belongs may be determined to be qualified, otherwise, the battery to which the test data belongs may be determined to be unqualified.

And automatically judging a test result based on the test data of the battery and a preset specification interval in the report template. And then filling the test result, the test data and the test conditions into a report template to obtain a test report.

In some embodiments of the present application, the process of automatically filling the data into the report template may include parsing the report template to determine a test result, test data of at least one battery, and a filling position of each data in the test condition in the report template, respectively; and filling each data into a report template based on the determined filling position to obtain a test report.

The report template has a defined layout of data, and each of the test results, each of the parameters in the test data, and each of the test conditions has a fixed fill position in the report template. Analyzing the report template, identifying the filling position of each data in the report template, and filling each data in the corresponding filling position in the report template respectively to obtain the test report.

In the embodiment of the application, the test plug-in program automatically responds to the test completion signal of the test equipment, test data of the battery which completes the test are stored in the data storage table, and a test report is automatically generated based on the data storage table. The whole process does not need to check whether the test is finished or not manually, and test data are not required to be recorded manually. Whether the test is finished or not and the export process of the test data can be automatically finished through the test plug-in program, a test report is generated based on a data storage table storing the test data, the automation degree of the whole process is improved, the labor cost is saved, the processing efficiency of the test data is improved, and errors caused by manual operation are reduced.

The foregoing description of various embodiments is intended to highlight differences between the various embodiments, which may be the same or similar to each other by reference, and is not repeated herein for the sake of brevity.

The following describes the processing of battery Test data with a specific example of performing a cell gram capacity Test, in which the Test device is a blue-ray tester, and the Test plug-ins in the above embodiments include a LANDExport software plug-in, RPA (Robotic Process Automation, robot process automation software) software, and a TRP (Test Report) system. Referring to the flow chart shown in fig. 2, this specific example specifically includes the following steps.

Step S1: the upper computer detects that a test channel with the test completed appears in the test equipment through the LANDExport software plug-in, and the test data measured by the test channel is led out to the InouTable.csv file through the LANDExport software plug-in.

The test data comprise a charge capacity, a discharge capacity and a charge-discharge efficiency. The inountable.

Step S2: and opening the InouTable.csv file through the LANDExport software plug-in, and copying the data in the InouTable.csv file into a data storage table in batches.

Specifically, when the data volume stored in the inouttable.csv file is detected to reach the test data of 8 batteries or the test data of 10 batteries, the data in the inouttable.csv file can be copied to the data storage table in batches. The data storage table may be as shown in table 1.

TABLE 1

Step S3: the data needed for reporting is screened from the data storage table by the RPA software.

Assuming that the cell gram capacity test in this specific example is to test 6 cells simultaneously, the 6 cells belong to parallel test samples, and the test data of the 6 cells are stored in the data storage table. Test data containing outliers were removed from the test data of the 6 cells. For example, assuming that the charge capacity 370.7 corresponding to the channel number 046-3 in the above table 1 is an abnormal value, the entire record corresponding to the channel number 046-3 is deleted. The discharge capacity of the remaining records was then averaged 353.6, and the two records with the discharge capacity closest to the average 353.6 were selected, i.e., the two records corresponding to channel numbers 046-1 and 046-5.

Step S4: the upper computer opens the TRP system to enter a test sheet needing to be reported, and the test conditions corresponding to the screened test data are grabbed from the data storage table through the RPA and automatically filled into the TRP system.

The test list to be reported includes the test list of the battery corresponding to each test data screened in the step S3. Test conditions may include, but are not limited to, test temperature/humidity, test date, test man-hour, pole piece weight, current collector mass, theoretical gram capacity, and the like. The interface for filling out the test conditions is shown in fig. 3, and fig. 3 schematically illustrates some test conditions, and the test conditions in practical applications may include, but are not limited to, the test conditions illustrated in fig. 3.

For the test conditions corresponding to the screened test data, determining a test sheet of a channel number corresponding to the test conditions in the TRP system, automatically identifying filling positions of each test condition in the test sheet, and writing each test condition corresponding to the test data to the corresponding filling position of the test sheet.

Step S5: the upper computer automatically opens the report template based on a preset storage path, and the screened test data is automatically filled into the report template through RPA software.

And automatically identifying filling positions of each parameter in the test data in the report template through RPA software, and writing the test data into the report template based on the identified filling positions. Table 2 shows an example of a report template in which test data is written in the buckling capacity test. Wherein, in sample number S13-20211026-1165-01, S13 is used to characterize the factory producing the battery sample, 20211026 is the date of production of the battery sample, 1165 is the 1165 th battery sample produced by the factory represented by S13. 01 was used to characterize the bucking capacity test.

TABLE 2

Step S6: and judging a test result by the RPA software according to the test data and a preset specification interval in the report template, filling the test result in a test conclusion of the report template, storing the generated test report, and closing the test report.

Table 3 shows an example of a test report obtained by filling out the test results into the report template shown in table 2.

TABLE 3 Table 3

The data in the InouTable.csv file is copied to the data storage table in batches, and the data required by the report is automatically screened out from the data storage table, so that the processing of each sample can be saved by 5 minutes. The test conditions and the test data are automatically written into the report template, and each sample can be saved for 5 minutes in the step. After full automation of data processing and report issuing is realized through software, the total time can be saved by 10 minutes for each sample, the total time saving time is 20.3 hours per day according to the sample amount of more than 7000 per month, and the test efficiency can be improved by about 20 percent, as shown in table 4.

TABLE 4 Table 4

In the embodiment of the application, whether a test channel for completing the test appears in the test equipment is automatically detected through a LANDExport software plug-in, test data of a battery for completing the test is automatically stored in a data storage table, and a test report is automatically generated based on the data storage table through RPA software and a TRP system. The whole process does not need to check whether the test is finished or not manually, and test data are not required to be recorded manually. Whether the test is finished or not and the export process of the test data can be automatically finished through the test plug-in program, a test report is generated based on a data storage table storing the test data, the automation degree of the whole process is improved, the labor cost is saved, the processing efficiency of the test data is improved, and errors caused by manual operation are reduced.

As shown in fig. 4, another embodiment of the present application provides a battery test data processing system including a test apparatus 100 and a host computer 200.

The test device 100 has at least one test channel through which a battery to be tested is tested; the upper computer 200 is connected to the test device 100 for executing the method of any of the above embodiments.

In the embodiment of the application, the upper computer automatically responds to the test completion signal of the test equipment through the test plug-in program, stores the test data of the battery which completes the test into the data storage table, and automatically generates a test report based on the data storage table. The whole process does not need to check whether the test is finished or not manually, and test data are not required to be recorded manually. The upper computer can automatically detect whether the test is finished or not, automatically complete the exporting process of the test data, generate a test report based on a data storage table storing the test data, improve the automation degree of the whole process, save the labor cost, improve the processing efficiency of the test data and reduce errors caused by manual operation.

As shown in fig. 5, further embodiments of the present application provide a battery test data processing apparatus for performing the battery test data processing method provided in any one of the foregoing embodiments, where the apparatus includes:

a determining module 201, configured to detect a test completion signal of the test device through the test plug-in, and determine a channel number for completing the test based on the test completion signal;

the storage module 202 is configured to obtain test data corresponding to the channel number from the test device, and store a mapping relationship between the channel number and the test data in a data storage table;

and the report generating module 203 is configured to generate a test report based on the data storage table.

The determining module 201 is configured to trigger generation of a test completion signal of the test device by detecting, by the test plug-in, that the status flag bit in the test device is updated to indicate that the test is completed.

A determining module 201, configured to receive device status information transmitted by a test device; and detecting that the equipment state information carries the channel number of the tested channel after the test is finished by the test plug-in program, and triggering to generate a test finishing signal of the test equipment.

The storage module 202 is configured to cache a mapping relationship between the channel number and the test data into a preset test file; and under the condition that the data quantity stored in the preset test file reaches a preset threshold value, the data currently cached in the preset test file are transferred to the data storage table in batches.

A storage module 202, configured to identify a current storage offset address in a preset test file; and caching the mapping relation between the channel number and the test data into the preset test file based on the storage offset address and the file parameters of the preset test file.

The report generating module 203 is configured to screen out test data and test conditions of at least one battery required for reporting from the data storage table, where the test conditions are recorded in the data storage table during the starting process of the battery test program; a test report is generated based on the test data and the test conditions of the at least one battery.

The report generating module 203 is configured to traverse the test data of each battery in the data storage table, and reject the test data that the included parameter value is not in the preset normal value interval; and selecting test data and test conditions of at least one battery from the rest of the test data.

The report generating module 203 is configured to calculate an average value of preset parameters in the remaining test data; and selecting a preset number of test data with the minimum difference value between the preset parameter value and the average value and corresponding test conditions from the rest test data.

The report generating module 203 is configured to obtain a report template based on a preset storage path; determining a test result based on the test data of at least one battery and a preset specification interval in a report template; and filling the test result, the test data of at least one battery and the test conditions into a report template to obtain a test report.

The report generating module 203 is configured to parse the report template, and determine a test result, test data of at least one battery, and a corresponding filling position of each data in the test condition in the report template; and filling each data into a report template based on the determined filling position to obtain a test report.

The battery test data processing device provided by the embodiment of the application and the battery test data processing method provided by the embodiment of the application are the same in conception and have the same beneficial effects as the method adopted, operated or realized by the device.

Another embodiment of the present application provides an electronic device, which may be a device for performing production control on a battery production line such as an industrial personal computer, an upper computer, or may be a test device for testing a battery, where the electronic device includes a memory, a processor, and a computer program stored on the memory and executable on the processor, and the processor executes the program to implement a battery test data processing method according to any one of the foregoing embodiments.

As shown in fig. 6, the electronic device 60 may include: a processor 600, a memory 601, a bus 602 and a communication interface 603, the processor 600, the communication interface 603 and the memory 601 being connected by the bus 602; the memory 601 stores a computer program executable on the processor 600, which when executed by the processor 600 performs the methods provided by any of the embodiments described herein.

The memory 601 may include a high-speed random access memory (RAM: random Access Memory), and may further include a non-volatile memory (non-volatile memory), such as at least one magnetic disk memory. The communication connection between the system network element and at least one other network element is implemented via at least one communication interface 603 (which may be wired or wireless), the internet, a wide area network, a local network, a metropolitan area network, etc. may be used.

Bus 602 may be an ISA bus, a PCI bus, an EISA bus, or the like. The buses may be divided into address buses, data buses, control buses, etc. The memory 601 is configured to store a program, and the processor 600 executes the program after receiving an execution instruction, and the method disclosed in any of the foregoing embodiments of the present application may be applied to the processor 600 or implemented by the processor 600.

The processor 600 may be an integrated circuit chip with signal processing capabilities. In implementation, the steps of the methods described above may be performed by integrated logic circuitry in hardware or instructions in software in processor 600. The processor 600 may be a general-purpose processor, and may include a central processing unit (Central Processing Unit, CPU for short), a network processor (Network Processor, NP for short), and the like; but may also be a Digital Signal Processor (DSP), application Specific Integrated Circuit (ASIC), an off-the-shelf programmable gate array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components. The disclosed methods, steps, and logic blocks in the embodiments of the present application may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of a method disclosed in connection with the embodiments of the present application may be embodied directly in hardware, in a decoded processor, or in a combination of hardware and software modules in a decoded processor. The software modules may be located in a random access memory, flash memory, read only memory, programmable read only memory, or electrically erasable programmable memory, registers, etc. as well known in the art. The storage medium is located in the memory 601 and the processor 600 reads the information in the memory 601 and performs the steps of the method described above in combination with its hardware.

The electronic device provided by the embodiment of the application and the method provided by the embodiment of the application are the same in the invention conception, and have the same beneficial effects as the method adopted, operated or realized by the electronic device.

Another embodiment of the present application provides a computer-readable storage medium having stored thereon a computer program that is executed by a processor to implement the control method of any of the above embodiments.

Referring to fig. 7, a computer readable storage medium is shown as an optical disc 20 having a computer program (i.e., a program product) stored thereon, which, when executed by a processor, performs the method provided by any of the embodiments described above.

It should be noted that examples of the computer readable storage medium may also include, but are not limited to, a phase change memory (PRAM), a Static Random Access Memory (SRAM), a Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a flash memory, or other optical or magnetic storage medium, which will not be described in detail herein.

Another embodiment of the present application provides a computer program product comprising a computer program that is executed by a processor to implement the control method of any of the above embodiments.

The computer readable storage medium and the computer program product provided in the above embodiments of the present application are both in the same inventive concept as the methods provided in the embodiments of the present application, and have the same advantages as the methods adopted, operated or implemented by the application program stored therein.

It should be noted that:

the term "module" is not intended to be limited to a particular physical form. Depending on the particular application, modules may be implemented as hardware, firmware, software, and/or combinations thereof. Furthermore, different modules may share common components or even be implemented by the same components. There may or may not be clear boundaries between different modules.

The algorithms and displays presented herein are not inherently related to any particular computer, virtual machine, or other apparatus. Various general purpose devices may also be used with the examples herein. The required structure for the construction of such devices is apparent from the description above. In addition, the present application is not directed to any particular programming language. It will be appreciated that a variety of programming languages may be used to implement the teachings of the present application as described herein, and the above description of specific languages is provided for disclosure of preferred embodiments of the present application.

It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited in order and may be performed in other orders, unless explicitly stated herein. Moreover, at least some of the steps in the flowcharts of the figures may include a plurality of sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, the order of their execution not necessarily being sequential, but may be performed in turn or alternately with other steps or at least a portion of the other steps or stages.

The foregoing examples merely represent embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.

Claims

1. A battery test data processing method, comprising:

and generating a test report based on the data storage table.

2. The method of claim 1, wherein detecting, by the test plug-in, a test completion signal of the test device comprises:

3. The method of claim 1, wherein detecting, by the test plug-in, a test completion signal of the test device comprises:

receiving equipment state information transmitted by the test equipment;

4. The method of claim 1, wherein storing the mapping relationship between the channel number and the test data in a data storage table comprises:

5. The method of claim 4, wherein the caching the mapping relationship between the channel number and the test data in the preset test file comprises:

identifying a current storage offset address in a preset test file;

6. The method of any of claims 1-5, wherein the generating a test report based on the data storage table comprises:

7. The method of claim 6, wherein screening test data and test conditions for at least one battery required for reporting from the data storage table comprises:

8. The method of claim 7, wherein selecting test data and test conditions for at least one battery from the remaining test data comprises:

calculating average values of preset parameters in the rest test data;

9. The method of claim 6, wherein generating a test report based on the test data and the test conditions of the at least one battery comprises:

Acquiring a report template based on a preset storage path;

10. The method of claim 9, wherein the filling the report template with the test results, the test data of the at least one battery, and the test conditions to obtain a test report comprises:

11. A battery test data processing system, comprising: test equipment and an upper computer;

the upper computer is connected to the test equipment for performing the method of any of the claims 1-10.

12. A battery test data processing apparatus, comprising:

13. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor executing the program to implement the method of any of claims 1-10.

14. A computer readable storage medium having stored thereon a computer program, characterized in that the program is executed by a processor to implement the method of any of claims 1-10.

15. A computer program product comprising a computer program, characterized in that the computer program is executed by a processor to implement the method of any one of claims 1-10.