NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ936027
Record Type: Journal
Publication Date: 2011
Pages: 15
Abstractor: As Provided
Reference Count: 28
ISSN: ISSN-1059-9053
Overcoming Microsoft Excel's Weaknesses for Crop Model Building and Simulations
Sung, Christopher Teh Boon
Journal of Natural Resources and Life Sciences Education, v40 p122-136 2011
Using spreadsheets such as Microsoft Excel for building crop models and running simulations can be beneficial. Excel is easy to use, powerful, and versatile, and it requires the least proficiency in computer programming compared to other programming platforms. Excel, however, has several weaknesses: it does not directly support loops for iterative calculations, and it does not allow one cell to alter the contents of another cell. Thus, the objective of this study was to develop an Excel add-in, called BuildIt, that overcomes some of Excel's weaknesses by: (1) providing a loop for repetitive calculations and (2) providing several operations (called actions) typically needed in building crop models. These actions are such as for numerical integration, initialization of variables, and solving differential equations using the Runge-Kutta method, as well as for copying and manipulation of cell ranges. BuildIt was written in Excel's script language, Visual Basic for Applications (VBA), but it does not require users to program in VBA to build their models. Several examples of models were used in this article to illustrate how BuildIt implements the infrastructure in Excel, and how it can be used to build models and run model simulations. With BuildIt, users are able to use Excel to build and run their mathematical models, without requiring any knowledge in VBA. (Contains 11 figures and 5 tables.)
American Society of Agronomy. 677 South Segoe Road, Madison, WI 53711. Tel: 608-273-8080; Fax: 608-273-2021; Web site:
Publication Type: Journal Articles; Reports - Research
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A