Implementation of CTR Dairy Model Using the Visual Basic for Application Language of Microsoft Excel

A. Ahmadi, P. H. Robinson, F. Elizondo and P. Chilibroste
Additional contact information
A. Ahmadi: University of California Davis, Davis, USA
P. H. Robinson: University of California Davis, Davis, USA
F. Elizondo: Universidad de la República, Montevideo, Uruguay
P. Chilibroste: Universidad de la República, Montevideo, Uruguay

International Journal of Agricultural and Environmental Information Systems (IJAEIS), 2018, vol. 9, issue 3, 74-86

Abstract: The goal of the article is to implement the CTR Dairy model using the Visual Basic for Application (VBA) language of Microsoft Excel. CTR Dairy is a dynamic simulation model for grazing lactating dairy cows that predicts milk production and profit over feeding based on ruminal digestion and absorption of nutrients under discontinuous feeding schedules. The CTR Dairy model was originally developed as a research tool using a proprietary computer simulation software called SMART that required the SMART client to run the program. As SMART software is now discontinued, and its client is no longer available, rewriting the model in the VBA language using Microsoft Excel for inputs and outputs makes the program available to a broad range of users including dairy farmers, extension advisors, dairy nutrition consultants and researchers. Dairy farmers can use the new version of the CTR Dairy program to manipulate the herbage allowance and the access time to the grazing paddock, as well as the timing of supplemental feeding, to improve the utilization of the pasture and to increase the production of the milk.

Date: 2018
References: Add references at CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 18/IJAEIS.2018070105 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:jaeis0:v:9:y:2018:i:3:p:74-86

Access Statistics for this article

International Journal of Agricultural and Environmental Information Systems (IJAEIS) is currently edited by Frederic Andres

More articles in International Journal of Agricultural and Environmental Information Systems (IJAEIS) from IGI Global
Bibliographic data for series maintained by Journal Editor ().