Building mathematical models in excel: a guide for agriculturists

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

Full description

Bibliographic Details
Main Author: Teh, Christopher Boon Sung.
Format: Book
Language:English
Published: Universal Publishers 2015
Online Access:http://psasir.upm.edu.my/id/eprint/46951/
http://psasir.upm.edu.my/id/eprint/46951/1/9781627340380%20new.pdf
_version_ 1848850767350333440
author Teh, Christopher Boon Sung.
author_facet Teh, Christopher Boon Sung.
author_sort Teh, Christopher Boon Sung.
building UPM Institutional Repository
collection Online Access
description 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.
first_indexed 2025-11-15T10:11:31Z
format Book
id upm-46951
institution Universiti Putra Malaysia
institution_category Local University
language English
last_indexed 2025-11-15T10:11:31Z
publishDate 2015
publisher Universal Publishers
recordtype eprints
repository_type Digital Repository
spelling upm-469512022-05-25T05:10:07Z http://psasir.upm.edu.my/id/eprint/46951/ Building mathematical models in excel: a guide for agriculturists Teh, Christopher Boon Sung. 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. Universal Publishers 2015 Book PeerReviewed text en http://psasir.upm.edu.my/id/eprint/46951/1/9781627340380%20new.pdf Teh, Christopher Boon Sung. (2015) Building mathematical models in excel: a guide for agriculturists. Universal Publishers, Boca Raton, Florida. ISBN 9781627340380
spellingShingle Teh, Christopher Boon Sung.
Building mathematical models in excel: a guide for agriculturists
title Building mathematical models in excel: a guide for agriculturists
title_full Building mathematical models in excel: a guide for agriculturists
title_fullStr Building mathematical models in excel: a guide for agriculturists
title_full_unstemmed Building mathematical models in excel: a guide for agriculturists
title_short Building mathematical models in excel: a guide for agriculturists
title_sort building mathematical models in excel: a guide for agriculturists
url http://psasir.upm.edu.my/id/eprint/46951/
http://psasir.upm.edu.my/id/eprint/46951/1/9781627340380%20new.pdf