Teaching the principles of least-cost poultry feed formulation utilizing the Solver function within a computer software workbook

利用计算机软件工作簿中的求解器功能,教授最低成本家禽饲料配方原理

阅读:1

Abstract

A Microsoft Excel workbook, User-Friendly Feed Formulation with Data from Australia (UffdAu.xlsm), has been developed for teaching feed formulation techniques to tertiary level, university students. It runs under both Microsoft Windows and Apple iOS operating systems. The example ingredient composition matrix is based on the Australian Feed Ingredient Database to illustrate the biological and econometric principles of least-cost feed formulation. The nutrient data are based roughly on recent primary breeder company recommendations. The workbook is easily adapted to appropriate ingredients, nutrients, and prices most relevant to the students, wherever it is used. The workbook uses the linear routines of Excel's Solver add-in under the Data heading in the header Ribbon. There is a worksheet illustrating how to adapt non-linear responses such as exogenous enzymes to typical linear models using a step function. Additional worksheets illustrate how proximate analysis can be interpreted in modern analytical chemistry terms and, how various feed energy measures are related to feed composition. UffdAu.xlsm is available free of charge from the Poultry Hub Australia website (https://www.poultryhub.org).

特别声明

1、本页面内容包含部分的内容是基于公开信息的合理引用;引用内容仅为补充信息,不代表本站立场。

2、若认为本页面引用内容涉及侵权,请及时与本站联系,我们将第一时间处理。

3、其他媒体/个人如需使用本页面原创内容,需注明“来源:[生知库]”并获得授权;使用引用内容的,需自行联系原作者获得许可。

4、投稿及合作请联系:info@biocloudy.com。