表計算ソフト Excel を用いた施設生産トマトの年間期待収穫量概算ツールの開発 [in Japanese] Development of an Estimation Tool for Expected Annual Yield of Tomato Grown in a Horticultural Facility by Using MS Excel [in Japanese]
Access this Article
Search this Article
To increase the annual yield of greenhouses, CO<sub>2 </sub>enrichment has been increasing in popularity in Japan. For appropriate use of the instrumentation, scientific knowledge of the environmental response of canopy photosynthesis is required. However, a lack of such knowledge by growers and instructors, e.g. agricultural extension workers and farming instructors, has resulted in scientifically inappropriate usage of such instrumentation in commercial greenhouses. To solve this problem, an adequate learning tool for growers and instructors to obtain enough knowledge of the environmental response of canopy photosynthesis is required. In this study, we developed an MS Excel based annual yield estimation tool for greenhouse tomato production. This tool is composed of 10 spreadsheets. Each spreadsheet has a particular function; an equation for leaf area estimation (Sheet 1), a model for vertical leaf area distribution (Sheet 2), a model for vertical light distribution (Sheet 3), a model for photosynthetic light (and CO<sub>2</sub>) response of leaves (Sheet 4), a model for dry matter distribution within a plant body (Sheet 5), specifics of greenhouse structure and parameter settings for greenhouse environmental control (Sheet 6), data on solar radiation and air temperature at intervals of 1 hour (Sheet 7), estimation of total photosynthesis of tomato canopy without CO<sub>2</sub> enrichment (Sheet 8), estimation of total photosynthesis of tomato canopy with CO<sub>2</sub> enrichment (Sheet 9), and estimation of expected annual tomato yield (Sheet 10). By using the developed tool, we investigated the effect of CO<sub>2</sub> enrichment in a greenhouse located in Matsuyama City (Ehime Prefecture, Japan) and demonstrated that CO<sub>2</sub> enrichment at 8.0 kg 10 a <sup>-1 </sup>h<sup>-1 </sup> increased the annual tomato yield at 38.9% but further CO<sub>2</sub> enrichment above 10 kg 10 a <sup>-1 </sup>h<sup>-1 </sup> was not effective to improve annual tomato yield.
Eco-Engineering 30(2), 47-58, 2018
The Society of Eco-Engineering