UPM Institutional Repository

Building mathematical models in excel: a guide for agriculturists


Citation

Teh, Christopher Boon Sung. (2015) Building mathematical models in excel: a guide for agriculturists. Universal Publishers, Boca Raton, Florida. ISBN 9781627340380

Abstract

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) 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.


Download File

[img] Text
9781627340380 new.pdf

Download (104kB)

Additional Metadata

Item Type: Book
Call Number: S494.5 M3T261
Divisions: Faculty of Agriculture
Publisher: Universal Publishers
Keywords: Mathematical models; Microsoft Excel; Agriculturists
Depositing User: Ms. Ainur Aqidah Hamzah
Date Deposited: 25 May 2022 05:10
Last Modified: 25 May 2022 05:10
URI: http://psasir.upm.edu.my/id/eprint/46951
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item