Crop plant nutrition balance diagnosis and regulation system and method based on Excel software

Abstract

The invention provides a crop plant nutrition balance diagnosis and regulation system and method based on Exce l software, and the system comprises a high-yield plant nutrient dynamic model database which is used for storing nutrient standard values of crop plants in different growth periods; a sample nutrient data management module used for inputting, browsing and editing plant sample data of crops; a nutrient data processing system module used for processing the sample data to obtain a nutrient index of the sample; a nutrient regulation scheme calculation module which is used for analyzing a nutrient balance index according to the nutrient index of the sample, determining the nutrient abundance and deficiency conditions of the plants in different growth periods, and supplementing nutrient elements to the plants in different growth periods according to a given nutrient regulation scheme; an output module which comprises nutrient content data backup, nutrient index backup, adjustment scheme backup, sampling basic information backup and the like; and a master control module which is used for controlling the operation of each module. According to the invention, a qualitative and quantitative fertilization scheme with strong pertinence is developed by diagnosing the nutrient balance of crop plants.

Description

technical field [0001] The invention belongs to the technical field of agricultural information, and in particular relates to a system and method for diagnosing and adjusting nutritional balance of crop plants based on Excel software. Background technique [0002] Plant nutrient balance diagnosis is a technical means to analyze and study the abundance and deficiency of nutrient elements in the normal growth and development of crops by using biological and chemical testing techniques. To achieve high yield, high quality and high efficiency. [0003] Nutrient elements in plants exist in three situations: deficiency, excess and excess. When a certain nutrient element is deficient, the content is lower than the critical value of the nutrient, and the plant yield will increase rapidly with the increase of the nutrient element. When the nutrient content reaches a critical value, the plant yield will reach the highest point. When the nutrient critical value is exceeded, the plan...

AI Technical Summary

Problems solved by technology

The critical value method is realized by determining the critical concentration of plant nutrients under the high-yield mode. The disadvantage of this method is that the fitting curve equation established between the nutrient content and the yield cannot intuitively obtain the diagnostic range; the optimal nutrient range is used to To determine the appropriate standard range of nutrient elements, the biggest defect of this method is that it cannot determine whether the high-yield level used has reached the maximum yield potential of the crop; the comprehensive method of nutritional diagnosis and fertilization is to use the index value and positive or negative to indicate the status of crop fertilizer requirements

[0005] During the "Ninth Five-Year Plan" period, the Ministry of Agriculture listed balanced fertilization as one of the ten technologies to be popularized nationwide. Unable to assemble, match and promote, and the conversion rate is low

Nutrient imbalances masked under the "recipe" have not been mitigated or eliminated despite the "recipe"

Images