Automatic processing method and system for photovoltaic inverter grid-connected test data

Abstract

The present invention discloses an automated processing method and system for photovoltaic inverter grid-connected test data, including: obtaining the original data of the photovoltaic inverter grid-connected test; obtaining the configured parameters, variables and conversion functions; extracting the original parameters and test values ​​from the original data based on the target parameters, and then converting and processing the converted data based on the conversion function and the variables, and storing them; obtaining the configured stage interval division parameters, stage interval division variables and stage interval division functions; performing the operation of dividing the converted data into a plurality of stage intervals according to the stage interval division parameters, the stage interval division functions and the stage interval division variables, wherein each stage interval divided includes the stage interval division parameters, the starting line and the ending line, and the values ​​corresponding to the starting line and the ending line corresponding to the stage interval division parameters; and generating an analysis report. The present invention significantly improves the efficiency and accuracy of the analysis report generation, reduces human errors, and saves the time of the tester.

Description

Technical Field

[0001] The present invention relates to the technical field of photovoltaic inverter grid-connected testing, and more specifically, to an automatic processing method and system for photovoltaic inverter grid-connected testing data. Background Art

[0002] At present, most data processing products in the industry adopt a combination of software and hardware, and there is no data processing solution that is completely based on software. Usually, manufacturers closely integrate test equipment with data processing software so that data analysis can be performed directly after the test is completed. The disadvantage of this solution is that the test equipment and data processing software are highly coupled, resulting in limited software flexibility. When the test equipment fails, the related data processing cannot be carried out normally. In addition, the maintenance and use costs of such equipment are high. Summary of the invention

[0003] An object of the present invention is to solve at least the above problems and to provide at least the advantages which will be described hereinafter.

[0004] In order to achieve these purposes and other advantages according to the present invention, a method for automatically processing photovoltaic inverter grid-connected test data is provided, comprising the following steps:

[0005] S1. Obtaining the original data of the photovoltaic inverter grid-connected test;

[0006] S2, acquiring configured parameters, variables and conversion functions, wherein the parameters include original parameters selected from the original data and target parameters of the conversion function operation, and the variables include set values ​​required for the conversion function operation;

[0007] S3, extracting the original parameter and the test value corresponding to the original parameter from the original data based on the target parameter, and then converting the converted data based on the conversion function and the corresponding variable, and storing the converted data, wherein the target parameter forms the column name of the converted data, and the converted value forms the column value of the target parameter;

[0008] S4, obtaining configured phase interval division parameters, phase interval division variables and phase interval division functions, wherein the phase interval division parameters are selected from the column names of the conversion data;

[0009] S5, performing an operation of dividing the conversion data into a plurality of stage intervals according to the stage interval division parameter, the stage interval division function and the stage interval division variable, wherein each stage interval divided includes the stage interval division parameter, the stage interval division variable, the starting row and the ending row, and the values ​​corresponding to the starting row and the ending row corresponding to the stage interval division parameter;

[0010] S6. Generate an analysis report including parameters, variables and stage intervals;

[0011] S7. Display the analysis report of step S6.

[0012] Preferably, before extracting the original data in step S3, the step further includes verifying whether the original data is valid. If the original data is valid, the subsequent steps are continued.

[0013] Among them, the original data verification rules include:

[0014] Check whether the original data has the column name of the parameter configured in step S3. If not, verify that the original data is invalid.

[0015] Detect the column names with the parameters configured in step S3 in the original data, and whether the values ​​of the columns corresponding to the parameters are non-digital. If not, continue to determine whether the values ​​of some parameter columns are empty cells. If so, calculate the sum of the values ​​of non-empty cells in each row of the corresponding column, and then divide it by the total number of rows of non-empty cells, fill the values ​​of the corresponding empty cells with the calculated value, and verify that the original data is valid;

[0016] Detect the column names of the parameters configured in step S3 in the original data, and whether the values ​​of the columns corresponding to the parameters are non-digital. If not, continue to determine whether the values ​​of some parameter columns are empty cells. If not, verify that the original data is valid.

[0017] Check the column names of the parameters configured in step S3 in the original data, and check whether the values ​​of the columns corresponding to the parameters are non-numeric. If so, verify that the original data is invalid.

[0018] Preferably, the variables also include a single traversal duration, a continuous duration, a total traversal duration, and a lower floating value a1, an upper floating value a2, and a standard value b of the stage interval division parameter of the stage interval to be obtained, wherein the stage interval division parameter, the lower floating value a1, the upper floating value a2, and the standard value b of each stage interval can be set to be the same or different;

[0019] The stage interval division function is configured as follows: based on the configured stage interval division parameter, the column value of the stage interval division parameter in the conversion data is traversed according to the single traversal duration, and the row corresponding to the first value entering the range of [b-a1, b+a2] is determined as the starting row of the stage interval, and the row corresponding to the last value in the range of [b-a1, b+a2] is determined as the ending row of the stage interval;

[0020] And, when after traversing a single traversal time, if no value of the column of the phase interval division parameter in the conversion data falls within the interval [b-a1, b+a2], it is determined that the phase interval does not exist, and the division of the next phase interval is continued, and the starting traversal position of the division of the next phase interval is the next row of the end row of the adjacent existing phase interval;

[0021] The above traversal judgment method is repeated to reach the total traversal time, and the division of all phase intervals of the conversion data is completed in sequence.

[0022] Preferably, the variable also includes a burr point number threshold. When the number of column values ​​of the stage interval division parameter in a stage interval that are outside the interval [b-a1, b+a2] is greater than the burr point number threshold within a single traversal duration, the stage interval division parameter in the original data is judged to be abnormal.

[0023] Preferably, before step S6, the method further includes obtaining anchor point parameters, anchor point variables and anchor point functions of each stage interval configured, wherein the anchor point parameters are selected from one or a combination of several of the column names of the conversion data, and the anchor point variables are one or more set values;

[0024] Anchor point values ​​are calculated based on the anchor point function and the anchor point variable, and rows whose values ​​of the columns of the anchor point parameters in the corresponding phase interval are the same as the anchor point values ​​are traversed, that is, as anchor point positions;

[0025] In step S6, the analysis report includes a mark of the anchor point position.

[0026] Preferably, the original parameters of the original data include input voltage, input power, output voltage A phase, output voltage B phase, output voltage C phase, positive sequence voltage, negative sequence voltage, active power, reactive power, apparent power, power factor and output frequency;

[0027] The variables include time variables, rated AC output voltage, rated AC output current, rated AC output apparent power, rated AC output active power, minimum output power and rated charging power.

[0028] Preferably, the method further includes calculating the sum of the time of each stage interval divided in step S5. 总 and compared with the preset total time, where T 总 When it is greater than or equal to the total time, it is considered to be normal operation;

[0029] When T 总 When it is less than the total time, it is judged as normal operation, and the comparison result is output to the analysis report at the same time.

[0030] A system for executing the method for automatically processing photovoltaic inverter grid-connected test data is provided, comprising:

[0031] A data acquisition module, which is used to obtain the original data of the photovoltaic inverter grid-connected test;

[0032] A data input module, which is used to obtain configured parameters, variables and conversion functions, wherein the parameters include original parameters selected from the original data and target parameters of the conversion function operation, and the variables include set values ​​required for the conversion function operation; and

[0033] Used to obtain configured phase interval division parameters, phase interval division variables and phase interval division functions, wherein the phase interval division parameters are selected from the column names of the conversion data;

[0034] A data conversion module, which is used to extract the original parameter and the test value corresponding to the original parameter from the original data based on the target parameter, and then obtain the converted data based on the conversion function and the corresponding variable conversion processing, and store it, wherein the target parameter forms the column name of the converted data, and the converted value forms the column value of the target parameter;

[0035] A stage interval division module, which is used to perform an operation of dividing the conversion data into multiple stage intervals according to the stage interval division parameter, the stage interval division function and the stage interval division variable, wherein each stage interval divided includes the stage interval division parameter, the stage interval division variable, the starting row and the ending row, and the values ​​corresponding to the starting row and the ending row corresponding to the stage interval division parameter;

[0036] A report generation module, which is used to generate analysis reports including parameters, variables and stage intervals;

[0037] A data display module is used to display the analysis report.

[0038] Preferably, the data input module is further used to obtain the anchor point parameters, anchor point variables and anchor point functions of each stage interval of the configuration, wherein the anchor point parameters are selected from one or a combination of several of the column names of the conversion data, and the anchor point variables are one or more set values;

[0039] It also includes an anchor point setting module, which is used to calculate the anchor point value based on the anchor point function and the anchor point variable, and traverse the rows whose values ​​of the columns of the anchor point parameters in the corresponding stage interval are the same as the anchor point value, that is, as the anchor point position.

[0040] An electronic device is provided, comprising:

[0041] one or more processors;

[0042] Memory; and

[0043] One or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, the programs including instructions for executing the method.

[0044] The present invention has at least the following beneficial effects:

[0045] First, in traditional data processing, engineers rely on personal experience and understanding of standards to select certain special points as markers. This method is highly subjective, and different engineers may have different interpretations of the same standard. The present invention uniformly sets special point selection rules and methods according to standard requirements to ensure consistent data processing results and avoid deviations in understanding.

[0046] Second, traditional manual data processing can only process one copy of data at a time, and the processing speed is relatively slow. The present invention can process multiple copies of data at the same time through multi-threading technology, achieving efficiency that cannot be achieved by manual processing.

[0047] Third, it usually takes about 60 minutes to manually process a file, and it may even take several hours for a large file. However, the present invention can complete data processing and data visualization in about 5 minutes, significantly improving the processing speed.

[0048] Fourth, most of the existing data processing software needs to be bound to a specific test device, which means that once the device fails, data processing will be affected, and these software can only process data from the device. The present invention is based on a web application, and only requires the device to be connected to the Internet to be able to process data, and can process data output from different test devices. As an embedded web application, no specific hardware support is required, and any device that can be connected to the Internet can process data. Since it does not rely on specific test equipment, the present invention can be widely used in different scenarios and can process data from different PCS (Photovoltaic System Inverter) test equipment.

[0049] Other advantages, objectives and features of the present invention will be embodied in part through the following description, and in part will be understood by those skilled in the art through study and practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0050] Figure 1 This is a screenshot of the anchor point position of one of the examples of the present invention;

[0051] Figure 2 This is a screenshot of the anchor point position of another example of the present invention. DETAILED DESCRIPTION

[0052] The present invention is further described in detail below in conjunction with the accompanying drawings so that those skilled in the art can implement the invention with reference to the description.

[0053] It should be noted that the experimental methods described in the following embodiments are conventional methods unless otherwise specified, and the reagents and materials are commercially available unless otherwise specified; in the description of the present invention, the orientation or positional relationship indicated by the terms is based on the orientation or positional relationship shown in the accompanying drawings, which is only for the convenience of describing the present invention and simplifying the description, and does not indicate or imply that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as a limitation on the present invention.

[0054] The present invention provides an automated processing method for photovoltaic inverter grid-connected test data, comprising the following steps:

[0055] S1. Obtain the original data of the photovoltaic inverter grid-connected test. The original data is exported by the test equipment. The data formats of the exported original data include integer, float type, etc. The column names of the original data include input voltage, input power, output voltage phase A, output voltage phase B, output voltage phase C, positive sequence voltage, negative sequence voltage, active power, reactive power, apparent power, power factor, output frequency, etc.

[0056] S2. Obtain the configured parameters, variables and conversion functions, wherein the parameters include the original parameters selected from the original data and the target parameters of the conversion function operation, and the variables include the set values ​​required for the conversion function operation. Variables include time variables Time (s), rated AC output voltage (V) Voltage, rated AC output current (A) Current, rated AC output apparent power (VA) (1~1.1Pn) Apparent Power, rated AC output active power (W) Output Power, minimum output power Pmin(pu), rated charging power (W) Charge Power, etc.

[0057] S3, extracting the original parameter and the test value corresponding to the original parameter from the original data based on the target parameter, and then converting the converted data based on the conversion function and the corresponding variable, and storing the converted data, wherein the target parameter forms the column name of the converted data, and the converted value forms the column value of the target parameter;

[0058] S4, obtaining configured phase interval division parameters, phase interval division variables and phase interval division functions, wherein the phase interval division parameters are selected from the column names of the conversion data;

[0059] S5, performing an operation of dividing the conversion data into a plurality of stage intervals according to the stage interval division parameter, the stage interval division function and the stage interval division variable, wherein each stage interval divided includes the stage interval division parameter, the stage interval division variable, the starting row and the ending row, and the values ​​corresponding to the starting row and the ending row corresponding to the stage interval division parameter;

[0060] S6. Generate an analysis report including parameters, variables and phase intervals; the analysis report can be in the form of a table, a coordinate graph, or a combination of a table and a graph. The content can include the phase interval parameters, which phase interval they belong to, the starting row index value (number of rows) and the ending row index value (number of rows) of each phase interval parameter. You can also draw a graph with time as the X-axis and the phase interval parameter or anchor point parameter as the vertical axis, and mark the anchor point value. An analysis report containing charts, data summaries and conclusions can be automatically generated.

[0061] S7. Display the analysis report of step S6.

[0062] In the above technical solution, by setting the phase interval division parameters and phase interval division functions according to the phase change rules of some parameters in the photovoltaic inverter grid connection test, the starting and ending rows of each phase interval are accurately and quickly found to achieve accurate phase interval division. Then it is presented in the form of an analysis report. For the same standard, unified processing can be achieved, which can overcome the defects caused by engineers relying on personal experience and inconsistent understanding of the standard, because different engineers may have different interpretations of the same standard.

[0063] When performing automated processing of raw data, you can also establish multi-threaded simultaneous processing, that is, you can achieve automated processing of multiple copies of raw data at the same time. Compared with manual processing where only one process can be performed at the same time, the processing efficiency is significantly improved.

[0064] When performing automated processing of raw data, it does not rely on the original test equipment and can be independent of the original test equipment. It only needs to export the raw data of the original test equipment to untie the raw data analysis and processing from the test equipment, and is no longer affected by the failure of the test equipment. When the automated processing method of raw data of the present invention needs to be run, only an embedded web application can be established, without the need for specific hardware support, and any device that can be connected to the Internet can perform data processing. Since it does not rely on specific test equipment, the present invention can be widely used in different scenarios and can process data from different PCS (photovoltaic inverter) test equipment.

[0065] In another technical solution, before extracting the original data in step S3, it also includes verifying whether the original data is valid. If it is valid, the subsequent steps are continued to be processed; invalid data can be quickly identified, the analysis and processing time can be reduced, and the efficiency of automated processing can be improved.

[0066] Among them, the original data verification rules include:

[0067] Check whether the original data has the column name of the parameter configured in step S3. If not, verify that the original data is invalid. A prompt "column is empty, please check the test data file" may be generated.

[0068] Detect the column names with the parameters configured in step S3 in the original data, and whether the values ​​of the columns corresponding to the parameters are non-numeric. If not, continue to determine whether the values ​​of some parameter columns are empty cells. If so, calculate the sum of the values ​​of the non-empty cells in each row of the corresponding column, and then divide it by the total number of rows of non-empty cells to fill the values ​​of the corresponding empty cells with the calculated value, and verify that the original data is valid. The empty cells can be automatically filled with numerical values ​​to provide a numerical basis for subsequent analysis and processing, thereby improving processing efficiency.

[0069] Check the column names of the parameters configured in step S3 in the original data, and whether the values ​​of the columns corresponding to the parameters are non-numeric. If not, continue to determine whether the values ​​of some parameter columns are empty cells. If not, verify that the original data is valid; the subsequent analysis and processing operations can be performed directly.

[0070] Check the column names of the parameters configured in step S3 in the original data, and whether the values ​​of the columns corresponding to the parameters are non-numeric. If so, verify that the original data is invalid. If non-numeric, it means that valid data cannot be obtained from the test data, so there is no need to analyze it, and an error log such as "test data file non-numeric" can be generated.

[0071] In another technical solution, the stage interval division variable includes a single traversal duration, a continuous duration, a total traversal duration, and a lower floating value a1, an upper floating value a2, and a standard value b of the stage interval division parameter of the stage interval to be obtained, wherein the stage interval division parameter, the lower floating value a1, the upper floating value a2, and the standard value b of each stage interval can be set to be the same or different;

[0072] The stage interval division function is configured as follows: based on the configured stage interval division parameter, the column value of the stage interval division parameter in the conversion data is traversed according to the single traversal duration, and the row corresponding to the first value entering the range of [b-a1, b+a2] is determined as the starting row of the stage interval, and the row corresponding to the last value in the range of [b-a1, b+a2] is determined as the ending row of the stage interval;

[0073] And, when after traversing a single traversal time, if no value of the column of the phase interval division parameter in the conversion data falls within the interval [b-a1, b+a2], it is determined that the phase interval does not exist, and the division of the next phase interval is continued, and the starting traversal position of the division of the next phase interval is the next row of the end row of the adjacent existing phase interval;

[0074] The above traversal judgment method is repeated to reach the total traversal time, and the division of all phase intervals of the conversion data is completed in sequence.

[0075] In the above technical solution, the stage intervals are divided according to the changes in the measured values ​​of the stage interval parameters, which can reflect the performance and response of some test parameters of the test inverter in the power grid.

[0076] In another technical solution, the stage interval division variable also includes a burr point number threshold. When, within a single traversal duration, the number of column values ​​of the stage interval division parameter within a stage interval that is outside the interval [b-a1, b+a2] is greater than the burr point number threshold, the stage interval division parameter in the original data is judged to be abnormal.

[0077] In the above technical solution, there are usually thousands of rows between the start and end rows, and some abnormal points may jump out of the interval [b-a1, b+a2]. For example, if the value of a certain stage interval has a glitch point number threshold and the number below it jumps out of the interval [b-a1, b+a2], it is still considered normal, and when the number of abnormal points exceeds the glitch point number threshold, the stage interval is considered abnormal. The glitch point number threshold is usually set to 2.

[0078] In another technical solution, before step S6, it also includes obtaining the configured anchor point parameters, anchor point variables and anchor point functions of each stage interval, wherein the anchor point parameters are selected from one or a combination of several of the column names of the conversion data, and the anchor point variables are one or more set values;

[0079] Anchor point values ​​are calculated based on the anchor point function and the anchor point variable, and rows whose values ​​of the columns of the anchor point parameters in the corresponding phase interval are the same as the anchor point values ​​are traversed, that is, as anchor point positions;

[0080] In step S6, the analysis report includes the marking of the anchor point positions.

[0081] In the above technical solution, in some test standard requirements, it is also required to set the anchor point positions. Therefore, a method for automatically setting the anchor point positions is provided. For the divided stage intervals, according to the test standard requirements, the anchor point parameters, anchor point variables, and anchor point functions can be configured, so as to automatically, quickly, and accurately find the anchor point positions of each stage, and then display them in the form of an analysis report. For the same standard, unified processing can be achieved, and the defect of non-uniformity caused by engineers relying on personal experience and understanding of the standard to select some special points as anchor point marks can be overcome, because different engineers may have different interpretations of the same standard.

[0082] In another technical solution, a method for setting the anchor point positions with specific anchor point parameters is provided. The configured anchor point parameter is the reactive power Q;

[0083] The configured variables include setting the positive reactive power Q setpoint =QC×0.75, where 0.75 is a fixed value, and the negative reactive power is set as -Q setpoint ;

[0084] The configured anchor point function specifically includes:

[0085] Calculate the upper tolerance band and the lower tolerance band of the reactive power Q for each stage interval. The specific steps are as follows:

[0086] Compare and judge the magnitudes of Q1 and Q2. Q1 and Q2 respectively represent the reactive powers of two adjacent upper and lower stage intervals. Among them,

[0087] When Q2 > Q1, use formula (1) to calculate the upper tolerance band,

[0088] Formula (1);

[0089] Use formula (2) and formula (3) to calculate the lower tolerance band,

[0090] When t < 3s, Formula (2)

[0091] When t ≥ 3s, Formula (3)

[0092] When Q2 < Q1, use formula (4) and formula (5) to calculate the upper tolerance band,

[0093] When t < 3s, Formula (4);

[0094] When t ≥ 3s, Formula (5)

[0095] The lower tolerance band is calculated using formula (6):

[0096] Formula (6)

[0097] Among them, in this technical solution, S n It indicates the value of rated power P, t indicates the time of the current line, the unit is second s, the s in 3s indicates the unit second, and T indicates the time constant;

[0098] Starting from the end row of the previous stage interval of two adjacent stage intervals, traverse the values ​​of the anchor point parameters of the next stage interval, and compare them with the range controlled by the lower tolerance zone and the upper tolerance zone of the next stage interval. When the first row corresponding to the value within the range controlled by the lower tolerance zone and the upper tolerance zone is found, and all the values ​​of the anchor point parameters after this row within a single traversal time are also within the range controlled by the lower tolerance zone and the upper tolerance zone, then this row is used as the anchor point position of the next stage interval;

[0099] Repeat the above traversal judgment method to complete the setting of the anchor point positions of all stage intervals in turn.

[0100] In the above technical solution, a method for setting the anchor point position required by common test standards is provided. Through the configured anchor point parameters, variables and anchor point functions, the anchor point position of the reactive power Q in the corresponding stage interval can be accurately found in the conversion data. If it is calculated manually (each stage interval contains thousands of rows of data), it is very time-consuming, seriously affects the processing efficiency, and is prone to errors.

[0101] In another technical solution, the total time T of each stage interval divided in step S5 is calculated. 总 and compared with the preset total time, where T 总 When it is greater than or equal to the total time, it is considered to be normal operation;

[0102] When T 总 When it is less than the total time, it is judged as normal operation, and the comparison result is output to the analysis report at the same time.

[0103] In the above technical solution, since the photovoltaic inverter grid-connected test has a certain time pattern and duration, the above method can further reflect the duration information of the original data.

[0104] The present invention also provides a system for executing the method for automatically processing photovoltaic inverter grid-connected test data, comprising:

[0105] A data acquisition module, which is used to obtain the original data of the photovoltaic inverter grid-connected test;

[0106] A data input module, which is used to obtain configured parameters, variables and conversion functions, wherein the parameters include original parameters selected from the original data and target parameters of the conversion function operation, and the variables include set values ​​required for the conversion function operation; and

[0107] Used to obtain configured phase interval division parameters, phase interval division variables and phase interval division functions, wherein the phase interval division parameters are selected from the column names of the conversion data;

[0108] A data conversion module, which is used to extract the original parameter and the test value corresponding to the original parameter from the original data based on the target parameter, and then obtain the converted data based on the conversion function and the corresponding variable conversion processing, and store it, wherein the target parameter forms the column name of the converted data, and the converted value forms the column value of the target parameter;

[0109] A stage interval division module, which is used to perform an operation of dividing the conversion data into multiple stage intervals according to the stage interval division parameter, the stage interval division function and the stage interval division variable, wherein each stage interval divided includes the stage interval division parameter, the stage interval division variable, the starting row and the ending row, and the values ​​corresponding to the starting row and the ending row corresponding to the stage interval division parameter;

[0110] A report generation module, which is used to generate analysis reports including parameters, variables and stage intervals;

[0111] A data display module is used to display the analysis report.

[0112] In the above technical solution, by setting the phase interval division parameters and phase interval division functions according to the phase change rules of some parameters in the photovoltaic inverter grid connection test, the starting and ending rows of each phase interval are accurately and quickly found to achieve accurate division of the phase interval. The data input module is used to pre-configure the phase interval division parameters and phase interval division functions to achieve accurate division of the phase interval, and then present it in the form of an analysis report. For the same standard, unified processing can be achieved, which can overcome the defects caused by engineers relying on personal experience and inconsistent understanding of the standard, because different engineers may have different interpretations of the same standard.

[0113] In another technical solution, the data input module is further used to obtain the anchor point parameters, anchor point variables and anchor point functions of each stage interval of the configuration, wherein the anchor point parameters are selected from one or a combination of several of the column names of the conversion data, and the anchor point variables are one or more set values;

[0114] It also includes an anchor point setting module, which is used to calculate the anchor point value based on the anchor point function and the anchor point variable, and traverse the rows whose values ​​of the columns of the anchor point parameters in the corresponding stage interval are the same as the anchor point value, that is, as the anchor point position.

[0115] In the above technical solution, some test standards also require the setting of anchor points. Therefore, an anchor point setting module is set to execute the method of automatically setting anchor points. For the divided stage intervals, anchor point parameters, anchor point variables and anchor point functions can be configured according to the test standard requirements, so as to automatically, quickly and accurately find the anchor point positions of each stage, and then display them in the form of an analysis report. For the same standard, unified processing can be achieved, which can overcome the defects of inconsistency caused by engineers relying on personal experience and understanding of the standard to select certain special points as anchor point marks, because different engineers may have different interpretations of the same standard.

[0116] All relevant contents of each step involved in the aforementioned embodiment of the method for automated processing of photovoltaic inverter grid-connected test data can be referred to the functional description of the functional modules corresponding to the automated processing system for photovoltaic inverter grid-connected test data in the embodiment of the present application, and will not be repeated here.

[0117] The division of modules in the embodiments of the present application is schematic and is only a logical function division. There may be other division methods in actual implementation. In addition, each functional module in each embodiment of the present invention may be integrated into a processor, or may exist physically separately, or two or more modules may be integrated into one module. The above-mentioned integrated modules may be implemented in the form of hardware or in the form of software functional modules.

[0118] The present invention also provides an electronic device, comprising:

[0119] one or more processors;

[0120] Memory; and

[0121] One or more programs, wherein the one or more programs are stored in the memory and are configured to be executed by the one or more processors, and the programs include a program for executing the method. The electronic device can be any terminal device including a mobile phone, a laptop computer, a desktop computer, a tablet computer, a PDA (Personal Digital Assistant), a POS (Point of Sales), a car computer, etc.

[0122] The present invention also provides a computer-readable storage medium storing a computer program used in combination with an electronic device, wherein the computer program can be executed by a processor to implement the method described above.

[0123] Through the description of the above implementation mode, the technicians in the relevant field can clearly understand that the present invention can be implemented by means of software plus necessary general hardware, and of course, it can also be implemented by special hardware including special integrated circuits, special CPUs, special memories, special components, etc. In general, all functions completed by computer programs can be easily implemented by corresponding hardware, and the specific hardware structure used to implement the same function can also be various, such as analog circuits, digital circuits or special circuits. However, for the present invention, software program implementation is a better implementation mode in more cases. Based on such an understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art can be embodied in the form of a software product, which is stored in a readable storage medium, such as a computer floppy disk, a U disk, a mobile hard disk, a read-only memory (ROM, Read-Only Memory), a random access memory (RAM, Random Access Memory), a disk or an optical disk, etc., including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment of the present invention.

[0124] <An example of a process of automated processing method and system>

[0125] The column names and corresponding values ​​in Tables 1, 2 and 3 are only used for examples, and their specific values ​​do not affect the overall concept of the present invention. Among them, DtP, RtP, PtR and PtD recorded in the method name column in Table 3 are self-named method names.

[0126] Table 1 Example of raw data

[0127]

[0128] Table 2 Example of transformed data

[0129]

[0130] Table 3 Example of phase interval division

[0131]

[0132] Input the parameters to be measured into the test machine, measure the machine and obtain the raw data. The automated processing method and system of the present application starts with the raw data. An example of raw data is shown in Table 1. The column names corresponding to the columns of the raw data cannot be equivalent to the column names of the converted data in the present invention. They are just the parameters during the test, and the values ​​in the columns are the measured values ​​of the parameters during the test. The column names and the corresponding values ​​of the columns in Table 1 are only used for examples, and their specific values ​​do not affect the overall concept of the present invention.

[0133] Before data conversion processing, parameters, variables, and conversion functions are pre-configured according to the test standards. The configured parameters include the conversion target contained in the conversion function and the parameters in the dependent original data. The variables include the values ​​corresponding to the variable names in the conversion function. As shown in Table 2, voltage (Urms-1), current (Irms-1), power (P-1), and frequency (FreqU-1) are the parameters in the original data on which the conversion function depends; voltage (U), power (P), current (I), and sampling rate (Time) are variable names, and the values ​​of the corresponding columns are the values ​​corresponding to the variable names in the conversion function.

[0134] The data conversion process obtains the converted data, which is obtained by calculating the original data and its corresponding variables, as shown in Table 2. The conversion function is the calculation method. The following shows several calculation methods for converting data:

[0135] Sampling rate (Time): The variable sampling rate increases by 0.05;

[0136] Voltage (U(pu)) = Voltage (Urms-1) / Voltage (U);

[0137] Current (I(pu)) = current (Irms-1) / current (I);

[0138] Power (P(pu)) = power (P-1) / power (P);

[0139] Frequency(FreqU-1) = Frequency(FreqU-1);

[0140] This is how the conversion data is obtained.

[0141] Based on the conversion data, the stage intervals are divided, as shown in Table 3, including stage intervals 1 to 20. In the table, only stage intervals 1 to 11 are shown. The target column names in Table 3 are selected from the column names of the conversion data. Each of the 11 stage intervals is provided with a corresponding standard value and floating value. The first value that enters the interval corresponding to the standard value and floating value and the row where the last value of the interval is located are found in the target column, that is, the starting row and the ending row of the stage interval are obtained. The standard value is required by the standard and is obtained by preset. The floating value can be set and modified according to the standard requirements and experience.

[0142] After the stage interval division is completed, some standards require the determination of the anchor point position. The method of determining the anchor point position is different according to different standard requirements and different target anchor point parameters. For example, Figure 1 As shown in the figure, the starting and ending lines of each stage are anchor points, except for the first starting point and the last ending point. Figure 2 As shown, the reactive power Q (%Sn) is the anchor point on the orange line, and the green dotted line is 4%Pn upper limited. This line represents the upper floating value of the active power set value in a certain stage interval (set value × (1+4%)). The anchor point in this example is defined as the upper floating value of the active power set value of the stage interval passed when the active power of the previous stage interval falls back to the steady-state interval of the next stage interval (set value × (1+4%)). Figure 1 and Figure 2 The figures are only examples, and their specific values ​​do not affect the overall concept of the present invention.

[0143] Although the embodiments of the present invention have been disclosed as above, they are not limited to the applications listed in the specification and the implementation modes, and they can be fully applied to various fields suitable for the present invention. For those familiar with the art, additional modifications can be easily implemented. Therefore, without departing from the general concept defined by the claims and the scope of equivalents, the present invention is not limited to the specific details and the illustrations shown and described herein.

Claims

1. A method for automatically processing photovoltaic inverter grid-connected test data, characterized in that: The following steps are involved: S1. Obtaining the original data of the photovoltaic inverter grid-connected test; S2, acquiring configured parameters, variables and conversion functions, wherein the parameters include original parameters selected from the original data and target parameters of the conversion function operation, and the variables include set values ​​required for the conversion function operation; S3, extracting the original parameter and the test value corresponding to the original parameter from the original data based on the target parameter, and then converting the converted data based on the conversion function and the corresponding variable, and storing the converted data, wherein the target parameter forms the column name of the converted data, and the converted value forms the column value of the target parameter; S4, obtaining configured phase interval division parameters, phase interval division variables and phase interval division functions, wherein the phase interval division parameters are selected from the column names of the conversion data; S5, performing an operation of dividing the conversion data into a plurality of stage intervals according to the stage interval division parameter, the stage interval division function and the stage interval division variable, wherein each stage interval divided includes the stage interval division parameter, the stage interval division variable, the starting row and the ending row, and the values ​​corresponding to the starting row and the ending row corresponding to the stage interval division parameter; S6, generate an analysis report including parameters, variables and stage intervals; wherein the sum of the time of each stage interval divided in step S5 is calculated. 总 and compared with the preset total time, where T 总 When it is greater than or equal to the total time, it is considered to be normal operation; When T 总 When it is less than the total time, it is judged as normal operation, and the comparison result is output to the analysis report at the same time.

2. The method for automatically processing photovoltaic inverter grid-connected test data according to claim 1, characterized in that: Before extracting the original data, step S3 also includes verifying whether the original data is valid. If it is valid, proceed to the subsequent steps. The original data validation rules include: Check whether the original data has the column name of the parameter configured in step S3. If not, verify that the original data is invalid. Detect the column names with the parameters configured in step S3 in the original data, and whether the values ​​of the columns corresponding to the parameters are non-digital. If not, continue to determine whether the values ​​of some parameter columns are empty cells. If so, calculate the sum of the values ​​of non-empty cells in each row of the corresponding column, and then divide it by the total number of rows of non-empty cells, fill the values ​​of the corresponding empty cells with the calculated value, and verify that the original data is valid; Detect the column names of the parameters configured in step S3 in the original data, and whether the values ​​of the columns corresponding to the parameters are non-digital. If not, continue to determine whether the values ​​of some parameter columns are empty cells. If not, verify that the original data is valid. Check the column names of the parameters configured in step S3 in the original data, and check whether the values ​​of the columns corresponding to the parameters are non-numeric. If so, verify that the original data is invalid.

3. The method for automatically processing photovoltaic inverter grid-connected test data according to claim 1, characterized in that: The phase interval division variables include a single traversal duration, a continuous duration, a total traversal duration, and a lower floating value a1, an upper floating value a2, and a standard value b of the phase interval division parameter of the phase interval to be obtained, wherein the phase interval division parameter, the lower floating value a1, the upper floating value a2, and the standard value b of each phase interval can be set to be the same or different; The stage interval division function is configured as follows: based on the configured stage interval division parameter, the column value of the stage interval division parameter in the conversion data is traversed according to the single traversal duration, and the row corresponding to the first value entering the range of [b-a1, b+a2] is determined as the starting row of the stage interval, and the row corresponding to the last value in the range of [b-a1, b+a2] is determined as the ending row of the stage interval; And, when after traversing a single traversal time, if no value of the column of the phase interval division parameter in the conversion data falls within the interval [b-a1, b+a2], it is determined that the phase interval does not exist, and the division of the next phase interval is continued, and the starting traversal position of the division of the next phase interval is the next row of the end row of the adjacent existing phase interval; The above traversal judgment method is repeated to reach the total traversal time, and the division of all phase intervals of the conversion data is completed in sequence.

4. The method for automatically processing photovoltaic inverter grid-connected test data according to claim 3, characterized in that: The stage interval division variable also includes a burr point number threshold. Within a single traversal duration, when the number of values ​​of the column of the stage interval division parameter within a stage interval that is outside the interval [b-a1, b+a2] is greater than the burr point number threshold, the stage interval division parameter in the original data is judged to be abnormal.

5. The method for automatically processing photovoltaic inverter grid-connected test data according to claim 1, characterized in that: Before step S6, the method further includes obtaining anchor point parameters, anchor point variables and anchor point functions of each stage interval configured, wherein the anchor point parameters are selected from one or a combination of several of the column names of the conversion data, and the anchor point variables are one or more set values; Anchor point values ​​are calculated based on the anchor point function and the anchor point variable, and rows whose values ​​of the columns of the anchor point parameters in the corresponding phase interval are the same as the anchor point values ​​are traversed, that is, as anchor point positions; In step S6, the analysis report includes a mark of the anchor point position.

6. The method for automatically processing photovoltaic inverter grid-connected test data according to claim 5, characterized in that: The original parameters of the original data include input voltage, input power, output voltage phase A, output voltage phase B, output voltage phase C, positive sequence voltage, negative sequence voltage, active power, reactive power, apparent power, power factor and output frequency; The variables include time variables, rated AC output voltage, rated AC output current, rated AC output apparent power, rated AC output active power, minimum output power and rated charging power.

7. A system for executing the method for automatically processing photovoltaic inverter grid-connected test data according to any one of claims 1 to 6, characterized in that: include: A data acquisition module, which is used to obtain the original data of the photovoltaic inverter grid-connected test; A data input module, which is used to obtain configured parameters, variables and conversion functions, wherein the parameters include original parameters selected from the original data and target parameters of the conversion function operation, and the variables include set values ​​required for the conversion function operation; and Used to obtain configured phase interval division parameters, phase interval division variables and phase interval division functions, wherein the phase interval division parameters are selected from the column names of the conversion data; A data conversion module, which is used to extract the original parameter and the test value corresponding to the original parameter from the original data based on the target parameter, and then obtain the converted data based on the conversion function and the corresponding variable conversion processing, and store it, wherein the target parameter forms the column name of the converted data, and the converted value forms the column value of the target parameter; A stage interval division module, which is used to perform an operation of dividing the conversion data into multiple stage intervals according to the stage interval division parameter, the stage interval division function and the stage interval division variable, wherein each stage interval divided includes the stage interval division parameter, the stage interval division variable, the starting row and the ending row, and the values ​​corresponding to the starting row and the ending row corresponding to the stage interval division parameter; A report generation module, which is used to generate analysis reports including parameters, variables and stage intervals; A data display module is used to display the analysis report.

8. The system according to claim 7, characterized in that The data input module is also used to obtain the anchor point parameters, anchor point variables and anchor point functions of each stage interval of the configuration, wherein the anchor point parameters are selected from one or a combination of several of the column names of the conversion data, and the anchor point variables are one or more set values; It also includes an anchor point setting module, which is used to calculate the anchor point value based on the anchor point function and the anchor point variable, and traverse the rows whose values ​​of the columns of the anchor point parameters in the corresponding stage interval are the same as the anchor point value, that is, as the anchor point position.

9. An electronic device, characterized in that include: one or more processors; Memory; as well as One or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, the programs comprising a method for executing any one of claims 1 to 6.

Images