Method for summarizing rice regional test information rapidly

Abstract

The invention discloses a method for summarizing rice regional test information rapidly. The method comprises the steps of: (1) collecting and managing element data from each test point according to a standard element data table format and recording the element data in corresponding element data tables; (2) respectively copying and sticking the data in each element data table into an Excel electronic table; (3) setting an Excel electronic table template group to automatically generate data needed by the summarization of the regional tests; (4) calculating a comparative value between the growth period of each variety and the growth period of a check variety; (5) calculating a comparative value between the yield of each variety and the yield of the check variety; (6) calculating a comparative value between the daily output of each variety and the daily output of the check variety; (7) performing an analysis of variance; and (8) generating a table and carrying out a summarization. The method for summarizing the rice regional test information rapidly, disclosed by the invention, solves the current situation that the traditional method has a great calculation workload, is easy to make mistakes and the like, can be popularized to the summarization of regional test information of other crops, and has the advantages of having wide application prospect, being simple and easy, shorting calculation time, improving accuracy and the like.

Description

technical field [0001] The present invention relates to the technical field of computer-aided design, in particular to a method for quickly summarizing rice regional test data that changes the current situation of traditional methods such as large calculation workload, cumbersome process, and error-prone, and can be extended to the summary of regional test data of other crops. method. Background technique [0002] Crop regional testing is a necessary procedure before crop variety approval. Its main purpose is to objectively identify the main characteristics of new varieties, provide basis and data indicators for new variety approval, and determine the most suitable promotion area for fine varieties. Every year, the test sites report the test results to form a summary and the time is very tight. The staff need to get the data in a short time. However, the regional test of crops has heavy tasks, a large workload, a large amount of data, and a large calculation workload. The su...

AI Technical Summary

Problems solved by technology

The method is time-consuming, labor-intensive, and the process is very cumbersome

In particular, in order to carry out the variance analysis of the crop area experiment, the yield data must be rearranged and converted in the data format, which needs to be re-entered manually, and the process is very cumbersome;

[0005] (2) Since the work of crop regional test summary has been operated by only a few units and individuals for a long time, it has not attracted enough attention, and this calculation method has not been effectively improved. Therefore, the traditional method has a large calculation workload and is very cumbersome , in the actual operation process, due to the tight time, there are often situations such as repeated rework due to mistakes

Images