This book is for agriculturists, many of whom are either novices or non-computer programmers, about how they can build their mathematical models in Microsoft Excel. Of all modeling platforms, spreadsheets like Excel require the least proficiency in computer programming.
This book introduces an Excel add-in called BuildIt (available for free as download - see below) that shields users from having to use Excel’s VBA (Visual Basic for Applications) programming language and yet allows agriculturists to build simple to large complex models without having to learn complicated computer programming techniques or to use sophisticated Excel techniques.
This book first discusses how BuildIt works and how it is used to build models. Examples range from the simple to progressively more complex mathematical models. Ultimately, readers are taught how to build a generic crop growth model from its five core components: meteorology, canopy photosynthesis, energy balance, soil water, and crop growth development.
Ultimately, agriculturists will be able to build their own mathematical models in Excel and concentrate more on the science and mathematics of their modeling work rather than being distracted by the intricacies of computer programming.
Publisher: Universal-Publishers, Boca Raton, Florida, USA
No. of pages: 352
Type: Paperback and e-book
Dimensions: 5.5 by 8.5 inches (paperback)
|1. BuildIt add-in - download (4.79 Mb)|
|This archive contains the Excel add-in, called BuildIt, to build mathematical models in Excel, all book examples, and installation instructions. See Appendix A in the book for the installation instructions.|
|2. Graphviz - go to site to download the latest version (choose only the Windows version)|
|This software is needed for BuildIt's Trace feature. Since version 2.31, Graphviz no longers set your computer's PATH variable after installation. You need to do this yourself. Instructions on how to set the PATH variable are included in the BuildIt archive file (see above), as well as in the book (Appendix A).|
Publications on BuildIt:
|1.||TEH, C.B.S. 2015. Can we build agriculture models in Excel? In: C.I. Fauziah, Teh, C.B.S., Hanafi, M.M., Rosazlin, A., Rosenani, A.B., Shamsuddin, J., Qurban, A.P. and Wan Rasidah, K. (Eds.) Soil Science Conference of Malaysia: Soil Security for Sustainable Food Production, 7-9 April 2015, Putrajaya. pp. 99-102.|
|2.||TEH, C.B.S. 2011. Overcoming Microsoft Excel’s weaknesses for crop model building and simulations. Journal of Natural Resources and Life Sciences Education, 40: 122-136. [download paper]|
|3.||TEH, C.B.S. 2009. Crop model building and simulation in Microsoft Excel: Introducing BuildIt. International Advanced Technology Congress. ATCi 2009. “Meeting Globalization Challenges Through Advanced Technology”. Putra World Trade Centre (PWTC), Kuala Lumpur, 3-5 Nov. 2009. p. 113.|
Enquiries? Comments? Contact the book author
ResearchGate - profile
Google Scholar - profile
Tel: +60-3-8947 4858