表計算ソフト Excel を用いた施設生産トマトの年間期待収穫量概算ツールの開発

DOI Web Site オープンアクセス

書誌事項

タイトル別名
  • Development of an Estimation Tool for Expected Annual Yield of Tomato Grown in a Horticultural Facility by Using MS Excel
  • ヒョウ ケイサン ソフト Excel オ モチイタ シセツ セイサン トマト ノ ネンカン キタイ シュウカクリョウ ガイサン ツール ノ カイハツ

この論文をさがす

抄録

 To increase the annual yield of greenhouses, CO2 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 CO2) 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 CO2 enrichment (Sheet 8), estimation of total photosynthesis of tomato canopy with CO2 enrichment (Sheet 9), and estimation of expected annual tomato yield (Sheet 10). By using the developed tool, we investigated the effect of CO2 enrichment in a greenhouse located in Matsuyama City (Ehime Prefecture, Japan) and demonstrated that CO2 enrichment at 8.0 kg 10 a -1 h-1 increased the annual tomato yield at 38.9% but further CO2 enrichment above 10 kg 10 a -1 h-1 was not effective to improve annual tomato yield.

収録刊行物

  • Eco-Engineering

    Eco-Engineering 30 (2), 47-58, 2018-04-30

    生態工学会

関連プロジェクト

もっと見る

キーワード

詳細情報 詳細情報について

問題の指摘

ページトップへ