Browse > Article
http://dx.doi.org/10.5532/KJAFM.2018.20.2.228

Development of a Chinese cabbage model using Microsoft Excel/VBA  

Moon, Kyung Hwan (Research Institute of Climate Change and Agriculture, National Institute of Horticultural and Herbal Science, Rural Development Administration)
Song, Eun Young (Research Institute of Climate Change and Agriculture, National Institute of Horticultural and Herbal Science, Rural Development Administration)
Wi, Seung Hwan (Research Institute of Climate Change and Agriculture, National Institute of Horticultural and Herbal Science, Rural Development Administration)
Oh, Sooja (Research Institute of Climate Change and Agriculture, National Institute of Horticultural and Herbal Science, Rural Development Administration)
Publication Information
Korean Journal of Agricultural and Forest Meteorology / v.20, no.2, 2018 , pp. 228-232 More about this Journal
Abstract
Process-based crop models have been used to assess the impact of climate change on crop production. These models are implemented in procedural or object oriented computer programming languages including FORTRAN, C++, Delphi, Java, which have a stiff learning curve. The requirement for a high level of computer programming is one of barriers for efforts to develop and improve crop models based on biophysical process. In this study, we attempted to develop a Chinese cabbage model using Microsoft Excel with Visual Basic for Application (VBA), which would be easy enough for most agricultural scientists to develop a simple model for crop growth simulation. Results from Soil-Plant-Atmosphere-Research (SPAR) experiments under six temperature conditions were used to determine parameters of the Chinese cabbage model. During a plant growing season in SPAR chambers, numbers of leaves, leaf areas, growth rate of plants were measured six times. Leaf photosynthesis was also measured using LI-6400 Potable Photosynthesis System. Farquhar, von Caemmerer, and Berry (FvCB) model was used to simulate a leaf-level photosynthesis process. A sun/shade model was used to scale up to canopy-level photosynthesis. An Excel add-in, which is a small VBA program to assist crop modeling, was used to implement a Chinese cabbage model under the environment of Excel organizing all of equations into a single set of crop model. The model was able to simulate hourly changes in photosynthesis, growth rate, and other physiological variables using meteorological input data. Estimates and measurements of dry weight obtained from six SPAR chambers were linearly related ($R^2=0.985$). This result indicated that the Excel/VBA can be widely used for many crop scientists to develop crop models.
Keywords
Chinese cabbage; Process-based crop model; Excel/VBA model;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Baier, W., 1973: Crop-weather analysis model: review and model development. Journal of applied Meteorology 12, 937-947.   DOI
2 Bouman, B., H. van Keulen, H. van Laar, and R. Rabbinge, 1996: The 'School of de Wit' crop growth simulation models: a pedigree and historical overview. Agricultural systems 52, 171-198.   DOI
3 Dubois, J. J., E. L. Fiscus, F. L. Booker, M. D. Flowers, and C. D. Reid, 2007: Optimizing the statistical estimation of the parameters of the Farquhar-von Caemmerer-Berry model of photosynthesis. New Phytologist 176, 402-414.   DOI
4 Farquhar, G. D., S. v. Caemmerer, and J. A. Berry, 1980: A biochemical model of photosynthetic CO2 assimilation in leaves of C3 species. Planta 149, 78-90.   DOI
5 Kim, S.-M., H.-J. Choi, H.-Y. Kim, D.-K. Lee, T.-H. Kim, M.-S. Ahn, and J.-H. Hur, 2002: Survey on pesticide use by chinese cabbage growers in gangwon alpine farmland. Korean Journal of Pesticide Science 6, 250-256.
6 Kim, S. H., and J. H. Lieth, 2003: A coupled model of photosynthesis, stomatal conductance and transpiration for a rose leaf (Rosa hybrida L.). Annals of Botany 91, 771-781.   DOI
7 Long, S. P., and C. J. Bernacchi, 2003: Gas exchange measurements, what can they tell us about the underlying limitations to photosynthesis? Procedures and sources of error. Journal of experimental botany 54, 2393-2401.
8 de Pury, D. G. G., and G. D. Farquhar, 1997: Simple scaling of photosynthesis from leaves to canopies without the errors of big‐leaf models. Plant, Cell & Environment 20, 537-557.   DOI
9 Sharkey, T. D., C. J. Bernacchi, G. D. Farquhar, and E. L. Singsaas, 2007: Fitting photosynthetic carbon dioxide response curves for C3 leaves. Plant, Cell & Environment 30, 1035-1040.   DOI
10 Teh, C. B. S., 2011: Overcoming Microsoft Excel's weaknesses for crop model building and simulations. Journal of Natural Resources & Life Sciences Education 40, 122-136.   DOI