CN104156285B - Section fuel cell Processing for Data Analysis in Physics and system based on VBA modules - Google Patents

Abstract

The present invention relates to a kind of section fuel cell Processing for Data Analysis in Physics and system based on VBA modules, wherein, the method includes：The step of establishing VBA data processing modules；The step of VBA data processing modules is called to import fuel cell experiment initial data；The step of VBA data processing modules is called to be formatted processing to the data of importing；The step of VBA data processing modules is called to draw respective image；The step of VBA data processing modules is called to be formatted processing to the image of drafting.Compared with prior art, the present invention has many advantages, such as fast and automatically to change, greatly improves data-handling efficiency.

Description

Data processing method and system for partitioned fuel cell experiments based on VBA module

technical field

The invention relates to a method and system for processing experimental data of partitioned fuel cells based on a VBA module.

Background technique

For nearly a century, human society is experiencing rapid development. With the continuous growth of energy consumption around the world, traditional energy sources have been overwhelmed and are facing a crisis of depletion. At present, the energy supply in most countries is insufficient, coupled with the environmental pollution caused by the exhaust emissions of traditional fuel vehicles, the development of new energy vehicles has become the consensus of all countries in the world. Among them, fuel cell vehicles (Fuel Cell Vehicle, FCV) have won the policy support of governments of various countries and extensive media attention due to their high power density, environmental friendliness, and rapid start-up. R&D strategic priorities for automakers.

There are still some technical bottlenecks in the large-scale commercialization of fuel cell vehicles, such as battery durability, stability and cost. In order to gain an in-depth understanding of the influence of various parameters on the performance of fuel cells, researchers have developed online partition testing technology for fuel cells. The basic principle is to divide the entire active area of the fuel cell into several separate areas, and investigate the electrochemical reaction performance of each area of the fuel cell. The online partition test technology can not destroy the structure of the fuel cell, does not affect the reaction, and can test the local current density distribution of the fuel cell in real time and accurately, so as to investigate the difference between the local electrochemical reactions of the battery and understand its electrochemical reaction mechanism. The main idea is to use a printed circuit board (PCB) to replace the current collecting plate of the proton exchange membrane fuel cell currently under study, and divide the PCB into several partitions that are insulated from each other, and measure the data generated by each partition, such as temperature, current, etc. density etc.

At present, data processing for partitioned fuel cell experiments is generally based on manual operations by analysts: manually selecting data and using drawing tools such as excel and origin to draw images is very cumbersome and time-consuming.

Therefore, it is necessary to develop a method that can quickly and automatically format experimental data, and automatically perform visual analysis of partitioned fuel cell data according to the needs of analysts, thereby greatly improving the efficiency of data processing and reducing the operation and effort of data analysts. Operating errors greatly save analysts' time and effort.

Contents of the invention

The object of the present invention is to provide a fast, automatic, and greatly improved data processing efficiency data processing method and system for partitioned fuel cell experiments based on VBA modules in order to overcome the above-mentioned defects in the prior art.

The purpose of the present invention can be achieved through the following technical solutions:

A method for processing partitioned fuel cell experimental data based on a VBA module, comprising:

Steps for establishing a VBA data processing module;

The step of calling the VBA data processing module to import the raw data of the fuel cell experiment;

The step of calling the VBA data processing module to format the imported data;

Call the step of described VBA data processing module to draw corresponding image;

The step of calling the VBA data processing module to format the drawn image.

The established VBA data processing module includes a data import module, a data formatting module, an image drawing module and an image formatting module.

When establishing the data formatting module or image formatting module, it includes:

Steps to set and save at least one formatting standard.

The raw data of the fuel cell experiment includes the experimental data of the fuel cell as a whole or the experimental data of each subdivision of the fuel cell based on the fuel cell online subdivision test technology.

The step of calling the VBA data processing module to draw the corresponding image includes:

Steps to set image start time and end time.

In the step of calling the VBA data processing module to draw a corresponding image, the drawn image includes an average parameter-time image, a partitioned column current density-time Mapping image, and an image of working condition cycle selection points.

A data processing system for partitioned fuel cell experiments based on VBA modules, including:

VBA data processing module creating device, used to set up VBA data processing module;

A data importing device, used to call the VBA data processing module to import the raw data of the fuel cell experiment;

A data formatting device, used to call the VBA data processing module to format the imported data;

An image drawing device, used to call the VBA data processing module to draw a corresponding image;

The image formatting device is used to call the VBA data processing module to format the drawn image.

Both the data formatting device and the image formatting device include a format standard storage unit for storing at least one format standard.

The image drawing device includes a time setting unit, which is used to set an image start time and an end time.

Compared with the prior art, the present invention has the following advantages:

1) Automatic data processing of mass data of fuel cells in online partitions is realized, which greatly improves the efficiency of data analysis, reduces user operations and operational errors, and greatly saves users' time and energy in data processing.

2) It can be conveniently used in Excel, which is widely used in scientific research, easy to operate and easy to use.

3) By pre-storing the required format standards, rapid and automatic format data or images can be realized.

Description of drawings

Fig. 1 is a schematic flow sheet of the inventive method;

Fig. 2 is the structural representation of the system of the present invention;

Fig. 3 is the test platform image schematic diagram in embodiment 1;

FIG. 4 is a schematic diagram of selected point images of cycle working conditions in Example 2.

Detailed ways

The present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments. This embodiment is carried out on the premise of the technical solution of the present invention, and detailed implementation and specific operation process are given, but the protection scope of the present invention is not limited to the following embodiments.

Example 1

The experimental object is a fuel cell divided into 64 partitions. In an experiment of a partitioned fuel cell with a duration of 4 hours and a data acquisition frequency of 1 time per second, hundreds of thousands of experimental raw data were generated. At the same time, the fuel cell test platform is taking the whole fuel cell as the object Collect data such as average current density, average voltage, inlet and outlet pressure, flow rate, etc.

In this embodiment, the raw data of the fuel cell experiment is the experimental data from the test platform and the fuel cell as a whole, and the data is processed in Excel. As shown in Figure 1, a VBA module-based partitioned fuel cell experimental data processing method provided by the embodiment of the present invention is specifically:

In step s1, a VBA data processing module is established, and the established VBA data processing module includes a data import module, a data formatting module, an image drawing module and an image formatting module.

Step s2, calling the VBA data processing module to import the raw data of the fuel cell experiment. When importing, you can find the address of the file through the Application.GetOpenFilename command, and then use the Workbooks.OpenText command to open the data file according to the above address.

Step s3, calling the VBA data processing module to format the imported data. In Excel, the Origin:=, DataType:=, Comma:= commands can be used to initially format the data. The data array is defined by the =.usedrange command, and the data is formatted more deeply through the value and arrangement of the array.

Step s4, calling the VBA data processing module to draw the test platform image.

According to requirements, the average parameter-time images of some fuel cell parameters can be automatically drawn, including: average current-time image, average voltage-time image, anode flow-time image, cathode flow-time image, anode inlet pressure-time Image, cathode inlet pressure-time image, anode outlet pressure-time image, cathode outlet pressure-time image, anode inlet temperature-time image, cathode inlet temperature-time image, anode outlet temperature-time image, cathode outlet temperature-time image etc., as shown in Figure 3.

By comparing the changes of different experimental parameters in the same time period, the influence of different parameters on the performance of the fuel cell can be analyzed.

In Excel, you can use Controls("togglebutton").Value to judge whether the button control is selected, and if it is selected, call the corresponding parameter, set it as the data source of the image through series.collection, and draw the image. If two physical coordinates are involved, you can click "Set Second Coordinate" after selecting the physical quantity of the second coordinate class, and you can get the required double-ordinate experimental data image through the AxisGroup statement.

When drawing an image, you can set the start time and end time of the image, and you can more accurately observe the process of the parameters of the time period of interest changing with time.

Step s5, calling the VBA data processing module to format the drawn image and transform it into a scientific image.

As shown in Figure 2, an embodiment of the present invention provides a VBA module-based partitioned fuel cell experiment data processing system, including a VBA data processing module creation device 1, a data import device 2, a data formatting device 3, an image drawing device 4 and Image formatting device 5, wherein, the VBA data processing module creation device 1 is used to establish the VBA data processing module, the data import device 2 is used to call the VBA data processing module to import the raw data of the fuel cell experiment, and the data formatting device 3 is used to Call the VBA data processing module to format the imported data, the image drawing device 4 is used to call the VBA data processing module to draw corresponding images, and the image formatting device 5 is used to call the VBA data processing module to draw The image is formatted. Both the data formatting device 3 and the image formatting device 5 include a format standard storage unit for storing at least one format standard, which can quickly and automatically format the original data of the experiment. The image rendering device 4 includes a time setting unit for setting an image start time and an end time.

Example 2

In this embodiment, the raw data of the fuel cell experiment is the experimental data measured based on the fuel cell on-line partition test technology with each partition of the fuel cell as the object, and draws the selected points for operation under the vehicle operating conditions.

Simulated vehicle working conditions usually include test conditions such as start-stop/open circuit, idle speed, constant load, variable load and acceleration. Combining these test conditions according to a certain ratio forms a fuel cell durability evaluation method that simulates vehicle conditions. This method not only combines the actual operation of the fuel cell, but also investigates the fuel cell as a whole, so that the performance of the fuel cell can be analyzed comprehensively.

The simulated driving conditions used in the experiment are self-made working conditions according to the actual driving conditions of the vehicle, including open-road conditions, idling conditions, acceleration conditions, etc., and the duration of each cycle is 1200s. The following describes the process of using this program to analyze and process the recorded data.

Using a method similar to that described in Example 1, the steps of data import, data formatting, and image formatting are sequentially performed.

When drawing the image of the selected points of the working cycle in Excel, it is necessary to set the time first, including the start time a, the end time b, the experimental data collection interval c and the working cycle d, and determine the partition to be analyzed. Then read the information of start time a and end time b, and use the for-next loop in the data page to find the cells where a and b are located. According to the located cell, read the corresponding current density or temperature information; then obtain the interval between adjacent operating points from the quotient d/c of the operating cycle d and the collection interval c, the program starts with a Start, b is the end, step size is d/c for-next cycle. Start at time a, that is, take points every d/c cells until the end time b. Finally, set the obtained points as the data source of the image through series.collection and generate an image, as shown in Figure 4.

Claims (3)

1. a kind of section fuel cell Processing for Data Analysis in Physics based on VBA modules, which is characterized in that including：

The step of establishing VBA data processing modules；

The step of VBA data processing modules is called to import fuel cell experiment initial data, the fuel cell experiment are former Beginning data are included using the experimental data of fuel cell generally object or using each subregion of fuel cell as object, based on fuel electricity The experimental data that the online subregion measuring technology in pond measures；

The step of VBA data processing modules is called to be formatted processing to the data of importing；

The step of VBA data processing modules is called to draw respective image, the image of drafting include mean parameter-time diagram Picture, subregion row current density-time Mapping image, Operation mode cycle reconnaissance image；

The step of VBA data processing modules is called to be formatted processing to the image of drafting；

The VBA data processing modules established include data import modul, data formatting module, Image Rendering module and figure As formatting module；

When establishing the data formatting module or image formatting module, including：

The step of setting and preserving at least one format standard.

2. a kind of section fuel cell Processing for Data Analysis in Physics based on VBA modules according to claim 1, feature It is, the described the step of VBA data processing modules is called to draw respective image includes：

The step of image initial time and deadline are set.

3. a kind of section fuel cell Data Processing in Experiment based on VBA modules realized as described in any in claim 1-2 The system of method, which is characterized in that including：

VBA data processing module creating devices, for establishing VBA data processing modules；

Data importing device, for the VBA data processing modules to be called to import fuel cell experiment initial data；

Data formatter, for the VBA data processing modules to be called to be formatted processing to the data of importing；

Image plotting device for the VBA data processing modules to be called to draw respective image, sets image to originate including being used for Time and the time setting unit of deadline；

Image formatting device for the VBA data processing modules to be called to be formatted processing to the image of drafting, preserves There is at least one format standard.