CN115453365A - Automatic battery testing method - Google Patents
Automatic battery testing method Download PDFInfo
- Publication number
- CN115453365A CN115453365A CN202210937085.0A CN202210937085A CN115453365A CN 115453365 A CN115453365 A CN 115453365A CN 202210937085 A CN202210937085 A CN 202210937085A CN 115453365 A CN115453365 A CN 115453365A
- Authority
- CN
- China
- Prior art keywords
- test
- battery
- scheme
- value
- plc
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01R—MEASURING ELECTRIC VARIABLES; MEASURING MAGNETIC VARIABLES
- G01R31/00—Arrangements for testing electric properties; Arrangements for locating electric faults; Arrangements for electrical testing characterised by what is being tested not provided for elsewhere
- G01R31/36—Arrangements for testing, measuring or monitoring the electrical condition of accumulators or electric batteries, e.g. capacity or state of charge [SoC]
- G01R31/367—Software therefor, e.g. for battery testing using modelling or look-up tables
Landscapes
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Secondary Cells (AREA)
Abstract
The invention provides an automatic battery testing method in the technical field of battery testing, which comprises the following steps: step S10, creating a scheme information table, a scheme parameter table, a test record table and a measuring point information table measuring point record table; s20, the PLC acquires and analyzes the bar code of the battery, and updates the type, the tracing code and the part number of the battery pack acquired by analysis to a test record table; step S30, the PLC updates the test flag bit and issues the test flag bit through OPC service; s40, the PLC executes the test of the battery based on the battery pack type matching scheme parameters; s50, in the process of testing the battery, recording the test value of each test point, updating the test point recording table, and carrying out safety monitoring on each test value based on the test point information table; step S60, after the test is finished, updating the test zone bit of the PLC through OPC service; and step S70, calculating the passing rate of the battery based on each test value. The invention has the advantages that: efficiency, quality and the security of battery test have greatly been promoted.
Description
Technical Field
The invention relates to the technical field of battery testing, in particular to an automatic battery testing method.
Background
The electric vehicle (BEV) is a vehicle which takes a vehicle-mounted power supply as power and drives wheels by a motor to run, meets various requirements of road traffic and safety regulations, and has a wide prospect due to smaller influence on the environment compared with the traditional vehicle. With the rapid development of electric vehicles, the demand for batteries is increasing, and in order to ensure the safety of the batteries, relevant tests are required after the batteries are produced.
For the test of the battery, firstly, the bar code of the battery to be tested is identified to obtain the battery information, and then the test of the battery is executed, and the traditional method of scanning the bar code attached to the battery by a code scanning gun and manually operating the entity key to start the test has the following defects: it makes mistakes easily to sweep the sign indicating number through sweeping the sign indicating number rifle, for example the bar code shows unclear or sweep wrong battery, and inefficiency, and manual operation entity button tests, and test equipment probably is not ready, leads to there being the potential safety hazard.
Therefore, how to provide an automatic battery testing method to improve the efficiency, quality and safety of battery testing becomes a technical problem to be solved urgently.
Disclosure of Invention
The technical problem to be solved by the invention is to provide an automatic battery testing method, which can improve the efficiency, quality and safety of battery testing.
The invention is realized in the following way: an automatic battery testing method comprises the following steps:
step S10, creating a scheme information table, a scheme parameter table, a test record table, a measuring point information table and a measuring point record table, and storing the scheme information table, the scheme parameter table, the test record table, the measuring point information table and the measuring point record table into a database;
s20, the PLC acquires and analyzes the bar code of the battery, and updates the type, the tracing code and the part number of the battery pack acquired by analysis to a test record table;
step S30, the PLC updates the test flag bit and issues the test flag bit through OPC service;
s40, the PLC executes the test of the battery based on the battery pack type matching scheme parameters;
step S50, in the process of testing the battery, recording the test value of each test point, updating the test point recording table, and carrying out safety monitoring on each test value based on the test point information table;
step S60, after the test is finished, updating the test flag bit of the PLC through OPC service;
and step S70, calculating the passing rate of the battery based on each test value.
Further, in step S10, the scheme information table at least includes a serial number, a scheme name, a battery pack type, and an update time;
the scheme parameter table at least comprises a sequence number, a scheme name, a scheme parameter and updating time;
the test record table at least comprises a serial number, a scheme name, a battery pack type, a test number, a tracing code, a part number, a test result, test time and a tester;
the measuring point information table at least comprises a serial number, a scheme name, a measuring point name, a first-gear maximum limit value, a first-gear minimum limit value, a second-gear maximum limit value, a second-gear minimum limit value, a third-gear maximum limit value and a third-gear minimum limit value;
the measuring point record table at least comprises a serial number, a measuring point information table ID, a measuring point name, a test value and test time.
Further, the step S20 specifically includes: and after the PLC controls the test equipment to perform self-check, the bar code of the battery is obtained and analyzed, and the type, the tracing code and the part number of the battery pack obtained through analysis are updated to a test record table in real time through an API (application programming interface) and an ODBC (odd distribution code) function.
Further, the step S30 specifically includes: and the PLC updates the test flag bit from 0 to 1,OPC service to periodically scan the test flag bit and map the test flag bit to a label of KEPServerEX service so as to complete the release of the test flag bit.
Further, the step S40 specifically includes: the PLC matches a scheme name from a scheme information table based on the battery pack type, matches a scheme parameter from a scheme parameter table based on the scheme name, and performs a test of the battery based on the scheme parameter.
Further, in step S50, the safety monitoring specifically includes:
and carrying out safety monitoring on the test value based on the first-gear minimum limit value, the first-gear maximum limit value, the second-gear minimum limit value, the second-gear maximum limit value, the third-gear minimum limit value and the third-gear maximum limit value of the test point information table so as to continuously execute the test, trigger the first-stage alarm, trigger the second-stage alarm or trigger the third-stage alarm.
Further, the step S60 specifically includes:
and after the test is finished, updating the test flag bit of the PLC from 1 to 0 through the OPC service and the KEPServerEX service.
Further, the step S70 is specifically:
and calculating a lower test value limit and an upper test value limit through a 6sigma algorithm based on each test value, and calculating the passing rate of the battery based on the lower test value limit and the upper test value limit.
The invention has the advantages that:
the bar code of the battery is automatically acquired through the PLC and analyzed, errors caused by the fact that a code scanning gun is manually operated to scan codes in the prior art are avoided, manual intervention is reduced, the PLC controls testing equipment to perform self-checking before testing, testing equipment is prevented from starting to test when the testing equipment is not ready, a testing value is safely monitored through a testing point information table which comprises a first-gear minimum limit value, a first-gear maximum limit value, a second-gear minimum limit value, a second-gear maximum limit value, a third-gear minimum limit value and a third-gear maximum limit value, and finally, the efficiency, the quality and the safety of battery testing are greatly improved.
Drawings
The invention will be further described with reference to the following examples with reference to the accompanying drawings.
Fig. 1 is a flow chart of an automatic battery testing method according to the present invention.
Detailed Description
Referring to fig. 1, a preferred embodiment of an automatic battery testing method according to the present invention includes the following steps:
step S10, creating a scheme information table, a scheme parameter table, a test record table, a measuring point information table and a measuring point record table, and storing the scheme information table, the scheme parameter table, the test record table, the measuring point information table and the measuring point record table into a database;
step S20, the PLC automatically acquires and analyzes the bar code of the battery, and updates the type, the tracing code and the part number of the battery pack obtained by analysis to a test record table; a PLC (programmable logic controller), which is a digital operation controller having a microprocessor and used for automation control; the bar codes are transmitted through the PLC, so that the error probability of code scanning is reduced;
step S30, the PLC updates the test flag bit and issues the test flag bit through OPC service; OPC (OLE in Process Control) defines a set of standard interfaces on the basis of Microsoft OLE/COM and DCOM technologies, thereby providing interoperability of software applications and interchangeability of equipment among automation and Control applications, equipment management and equipment, developers can concentrate a large amount of manpower and funds for developing a driving service program on the development of a single OPC interface, and only a highly optimized and reusable OPC server needs to be developed to access the underlying hardware; the OPC service can be compatible with most of PLCs, and even if the PLCs are replaced, the codes do not need to be changed, so that the version development workload of software is reduced, and the development efficiency is improved;
s40, the PLC executes the test of the battery based on the battery pack type matching scheme parameters;
step S50, in the process of testing the battery, recording the test value of each test point, updating the test point recording table, and carrying out safety monitoring on each test value based on the test point information table;
step S60, after the test is finished, updating the test flag bit of the PLC through OPC service;
and step S70, calculating the passing rate of the battery based on each test value.
In step S10, the scheme information table at least includes a serial number, a scheme name, a battery pack type, and update time;
the scheme parameter table at least comprises a sequence number, a scheme name, a scheme parameter and updating time;
the test record table at least comprises a serial number, a scheme name, a battery pack type, a test number, a tracing code, a part number, a test result, test time and a tester;
the measuring point information table at least comprises a serial number, a scheme name, a measuring point name, a first-gear maximum limit value, a first-gear minimum limit value, a second-gear maximum limit value, a second-gear minimum limit value, a third-gear maximum limit value and a third-gear minimum limit value;
the measuring point recording table at least comprises a serial number, a measuring point information table ID, a measuring point name, a test value and test time.
The scheme information table is exemplified as follows:
| column name | Type (B) | Whether or not it should be allowed to be empty | Description of the invention |
| id | int(11) | Self-increasing Id | Serial number |
| projectname | varchar(100) | NO | Name of scheme |
| packtype | varchar(100) | NO | Battery pack type |
| operatedate | varchar(100) | NO | Time of update |
The scheme parameter table is exemplified as follows:
| column name | Types of | Whether it should be allowed to empty | Description of the preferred embodiment |
| id | int(11) | Self-increasing Id | Serial number |
| projectname | varchar(100) | NO | Name of scheme |
| parameters | varchar(100) | NO | Recipe parameters (Json format) |
| operatedate | varchar(100) | NO | Time of update |
The test record table is exemplified as follows:
| column name | Types of | Whether or not it should be allowed to be empty | Description of the preferred embodiment |
| id | int(11) | Self-increasing Id | Serial number |
| projectname | varchar(100) | NO | Name of scheme |
| packtype | varchar(100) | NO | Battery pack type |
| testid | varchar(100) | NO | Test number |
| Barcode | varchar(100) | NO | Tracing code |
| partnum | varchar(100) | NO | Part number |
| testresult | varchar(100) | NO | Test results |
| operatedate | varchar(100) | NO | Time of measurement |
| operateuser | varchar(100) | NO | Tester |
The measurement point information table is exemplified as follows:
| column names | Type (B) | Whether it should be allowed to empty | Description of the preferred embodiment |
| id | int(11) | Self-increasing Id | Serial number |
| projectname | varchar(100) | NO | Name of scheme |
| testpointname | varchar(100) | NO | Point names |
| FirstMaxLimit | varchar(100) | NO | Maximum limit of first gear |
| FirstMinLimit | varchar(100) | NO | First gear minimum limit |
| SecondMaxLimit | varchar(100) | NO | Maximum second gear limit |
| SecondMinLimit | varchar(100) | NO | Minimum second gear limit |
| ThirdMaxLimit | varchar(100) | NO | Maximum limit of third gear |
| ThirdMinLimit | varchar(100) | NO | Minimum limit of third gear |
The station record table is exemplified as follows:
| column name | Type (B) | Whether it should be allowed to empty | Description of the preferred embodiment |
| id | int(11) | Self-increasing Id | Serial number |
| testpointsid | int(11) | NO | Measurement point information table ID |
| testpointname | varchar(100) | NO | Station names |
| testvalue | varchar(100) | NO | Test value |
| testdate | varchar(100) | NO | Time of measurement |
The step S20 is specifically: and after the PLC controls the test equipment to carry out self-check, the bar code of the battery is obtained and analyzed, and the type, the tracing code and the part number of the battery pack obtained through analysis are updated to a test record table in real time through an API (application program interface) and an ODBC (odd data base code) function. ODBC (Open Database Connectivity/Open Database interconnection) provides a common interface for accessing different databases, and uses SQL as a standard for accessing databases, providing maximum interoperability, and an application can access different databases through the same code.
The step S30 specifically includes: the PLC updates the test flag bit from 0 to 1,OPC service to periodically scan the test flag bit and map the test flag bit to a label of KEPServerEX service so as to complete the release of the test flag bit. The KEPServerEX is OPC service of a third party and is used for communication between lower level PLCs and upper computers of various devices of different manufacturers.
Before testing, the address bit of the PLC needs to be defined:
the step S40 is specifically: the PLC matches a scheme name from a scheme information table based on the battery pack type, matches a scheme parameter from a scheme parameter table based on the scheme name, and performs a test of the battery based on the scheme parameter. The recipe parameters include page (runtime interface), scripts, parameter1, parameter2, etc., i.e., the Scripts run within the page based on parameter1 and parameter2 to perform the test on the battery.
In the step S50, the safety monitoring specifically includes:
and carrying out safety monitoring on the test value based on the first-gear minimum limit value, the first-gear maximum limit value, the second-gear minimum limit value, the second-gear maximum limit value, the third-gear minimum limit value and the third-gear maximum limit value of the test point information table so as to continuously execute the test, trigger the first-stage alarm, trigger the second-stage alarm or trigger the third-stage alarm.
The security monitoring is as follows, for example, assuming that a is a test value:
if the FirstMinLimit is smaller than A < FirstMaxLimit, the test is normal, and the next test is continuously executed;
if A is less than FirstMinLimit and A is greater than SeconddMinLimit, triggering a first-level alarm and performing popup prompt;
if A < FirstMinLimit and A < SeconddMinLimit and A > ThirdMinLimit, triggering a secondary alarm and performing a pop-up alarm;
if A < FirstMinLimit, A < SeconddMinLimit and A < ThirdMinLimit, triggering a three-level alarm, directly stopping the test, and disconnecting all test loops;
if A is greater than FirstMaxLimit and A is less than SecondMaxLimit, triggering a first-level alarm and performing popup prompt;
if A > FirstMaxLimit, A > SecondMaxLimit and A < ThirdMaxLimit, triggering a secondary alarm and a popup alarm;
if A < FirstMinLimit, A > SeconddMinLimit and A > ThirdMinLimit, triggering a three-level alarm, directly stopping testing and disconnecting all testing loops;
all data are saved to the database through the API interface for subsequent analysis.
The step S60 specifically includes:
and after the test is finished, updating the test flag bit of the PLC from 1 to 0 through OPC service and KEPServerEX service.
The step S70 is specifically:
calculating a lower test value limit (FirstMinLimit) and an upper test value limit (FirstMaxLimit) by a 6sigma algorithm based on each test value, and calculating the passing rate of the battery based on the lower test value limit and the upper test value limit;
setting a lower alarm limit P1 and a lower alarm limit P2, storing the lower alarm limit and the lower alarm limit in a local configuration file, and when the lower alarm limit is lower than P1, prompting that the test equipment needs to be overhauled by popping up a window; when the passing rate is lower than P2, the popup prompts the test equipment to be in fault, and the test is not allowed.
In summary, the invention has the advantages that:
the bar code of the battery is automatically acquired through the PLC and analyzed, errors caused by the fact that a code scanning gun is manually operated to scan codes in the prior art are avoided, manual intervention is reduced, the PLC controls testing equipment to perform self-checking before testing, testing equipment is prevented from starting to test when the testing equipment is not ready, a testing value is safely monitored through a testing point information table which comprises a first-gear minimum limit value, a first-gear maximum limit value, a second-gear minimum limit value, a second-gear maximum limit value, a third-gear minimum limit value and a third-gear maximum limit value, and finally, the efficiency, the quality and the safety of battery testing are greatly improved.
Although specific embodiments of the invention have been described above, it will be understood by those skilled in the art that the specific embodiments described are illustrative only and are not limiting upon the scope of the invention, and that equivalent modifications and variations can be made by those skilled in the art without departing from the spirit of the invention, which is to be limited only by the appended claims.
Claims (8)
1. An automatic battery test method is characterized in that: the method comprises the following steps:
step S10, creating a scheme information table, a scheme parameter table, a test record table, a measuring point information table and a measuring point record table, and storing the scheme information table, the scheme parameter table, the test record table, the measuring point information table and the measuring point record table into a database;
s20, the PLC acquires and analyzes the bar code of the battery, and updates the type, the tracing code and the part number of the battery pack acquired by analysis to a test record table;
step S30, the PLC updates the test flag bit and issues the test flag bit through OPC service;
s40, the PLC executes the test of the battery based on the battery pack type matching scheme parameters;
s50, in the process of testing the battery, recording the test value of each test point, updating the test point recording table, and carrying out safety monitoring on each test value based on the test point information table;
step S60, after the test is finished, updating the test flag bit of the PLC through OPC service;
and step S70, calculating the passing rate of the battery based on each test value.
2. The automatic battery test method of claim 1, wherein: in step S10, the scheme information table at least includes a serial number, a scheme name, a battery pack type, and update time;
the scheme parameter table at least comprises a sequence number, a scheme name, a scheme parameter and updating time;
the test record table at least comprises a serial number, a scheme name, a battery pack type, a test number, a tracing code, a part number, a test result, test time and a tester;
the measuring point information table at least comprises a sequence number, a scheme name, a measuring point name, a first-gear maximum limit value, a first-gear minimum limit value, a second-gear maximum limit value, a second-gear minimum limit value, a third-gear maximum limit value and a third-gear minimum limit value;
the measuring point record table at least comprises a serial number, a measuring point information table ID, a measuring point name, a test value and test time.
3. The automatic battery test method of claim 1, wherein: the step S20 is specifically: and after the PLC controls the test equipment to perform self-check, the bar code of the battery is obtained and analyzed, and the type, the tracing code and the part number of the battery pack obtained through analysis are updated to a test record table in real time through an API (application programming interface) and an ODBC (odd distribution code) function.
4. The automatic battery test method of claim 1, wherein: the step S30 specifically includes: the PLC updates the test flag bit from 0 to 1,OPC service to periodically scan the test flag bit and map the test flag bit to a label of KEPServerEX service so as to complete the release of the test flag bit.
5. The automatic battery test method of claim 1, wherein: the step S40 is specifically: the PLC matches a scheme name from a scheme information table based on the battery pack type, matches a scheme parameter from a scheme parameter table based on the scheme name, and performs a test of the battery based on the scheme parameter.
6. The automatic battery test method of claim 1, wherein: in the step S50, the safety monitoring specifically includes:
and carrying out safety monitoring on the test value based on the first-gear minimum limit value, the first-gear maximum limit value, the second-gear minimum limit value, the second-gear maximum limit value, the third-gear minimum limit value and the third-gear maximum limit value of the test point information table so as to continuously execute the test, trigger the first-stage alarm, trigger the second-stage alarm or trigger the third-stage alarm.
7. The automatic battery test method of claim 1, wherein: the step S60 specifically includes:
and after the test is finished, updating the test flag bit of the PLC from 1 to 0 through OPC service and KEPServerEX service.
8. The automatic battery test method of claim 1, wherein: the step S70 is specifically:
and calculating a lower test value limit and an upper test value limit through a 6sigma algorithm based on each test value, and calculating the passing rate of the battery based on the lower test value limit and the upper test value limit.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210937085.0A CN115453365A (en) | 2022-08-05 | 2022-08-05 | Automatic battery testing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210937085.0A CN115453365A (en) | 2022-08-05 | 2022-08-05 | Automatic battery testing method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115453365A true CN115453365A (en) | 2022-12-09 |
Family
ID=84297059
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210937085.0A Pending CN115453365A (en) | 2022-08-05 | 2022-08-05 | Automatic battery testing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115453365A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116774090A (en) * | 2023-08-17 | 2023-09-19 | 深圳市菲尼基科技有限公司 | Energy storage battery health diagnosis method, device and equipment based on state monitoring |
-
2022
- 2022-08-05 CN CN202210937085.0A patent/CN115453365A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116774090A (en) * | 2023-08-17 | 2023-09-19 | 深圳市菲尼基科技有限公司 | Energy storage battery health diagnosis method, device and equipment based on state monitoring |
| CN116774090B (en) * | 2023-08-17 | 2023-10-31 | 深圳市菲尼基科技有限公司 | Energy storage battery health diagnosis method, device and equipment based on state monitoring |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102096760B (en) | Detecting anomalies in field failure data | |
| US7757125B2 (en) | Defect resolution methodology and data defects quality/risk metric model extension | |
| CN107678936B (en) | Business system pre-inspection method, server and computer readable storage medium | |
| US20090216401A1 (en) | Feedback loop on diagnostic procedure | |
| US20100262332A1 (en) | Support for preemptive symptoms | |
| CN113010413B (en) | Automatic interface testing method and device | |
| CN115453365A (en) | Automatic battery testing method | |
| CN112131116A (en) | Automatic regression testing method for embedded software | |
| CN110119348B (en) | Software upgrading test method and terminal | |
| CN112561370A (en) | Software version management method and device, computer equipment and storage medium | |
| US7647238B2 (en) | Computer-implemented vehicle repair claims rules generator system | |
| US20100131091A1 (en) | A method and relative device for the management of technological recipe information to aid in defining process flows, in particular for the development and production of micro-and nanotechnology devices in cleanroom laboratories | |
| CN108595323A (en) | A kind of system detection method and relevant apparatus | |
| WO2023125706A1 (en) | Test method and system for mileage order generation of battery swapping vehicle, device and medium | |
| CN110928933B (en) | Production management method, device and computer readable storage medium | |
| CN114564002B (en) | Method and device for quickly diagnosing lost packet and computer equipment | |
| Flemström et al. | Exploring test overlap in system integration: An industrial case study | |
| CN115629956A (en) | Software defect management method and system based on interface automatic test | |
| CN111552639B (en) | Software test comprehensive control method and system | |
| Juhnke et al. | Quality Indicators for Automotive Test Case Specifications. | |
| CN110704318B (en) | Map data automatic testing method, terminal device and storage medium | |
| CN114358627A (en) | Electric power operation and maintenance management system and operation and maintenance method thereof | |
| CN112346920A (en) | Integrated circuit test data analysis method and system | |
| US20230230430A1 (en) | System and method for determining vehicle health | |
| CN114817077B (en) | Method, system and network equipment for judging test quality and specification |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |