| 利用Excel 2007规划求解饲料配方表格的设计与使用 |
| |
| 引用本文： | 慕乾华,徐俊延. 利用Excel 2007规划求解饲料配方表格的设计与使用[J]. 计算机与农业, 2011, 0(5): 27-28,43 |
| |
| 作者姓名： | 慕乾华 徐俊延 |
| |
| 作者单位： | 黑龙江农垦科技职业学院,哈尔滨150431 |
| |
| 摘 要： | 根据动物的饲养标准、所用原料的营养成分含量和市场价格,以及饲料配方设计的要求和饲养经验,设计了饲料配制方案的表格,利用Excel 2007提供的规划求解、公式计算等强大功能,不需建立数学模型,将有关的参数添于表格中就可以直接规划求解饲料配方。
|
| 关 键 词： | Excel2007 饲料配方表格 规划求解 饲料配方 |
Application of Excel 2007 Solver in the Design and Use of Feed Formula Forms |
| |
| MU Qianhua,XU Junyan. Application of Excel 2007 Solver in the Design and Use of Feed Formula Forms[J]. Computer and Agriculture, 2011, 0(5): 27-28,43 |
| |
| Authors: | MU Qianhua XU Junyan |
| |
| Affiliation: | (Heilongjiang State Farm＇s Science and Technology Vocational College,Haerbin 150431) |
| |
| Abstract: | According to animal husbandry standards,the nutrients content in raw material,market prices,as well as feed formulation requirements and feeding experience,the feed formula form was scientifically designed by using tools like ＂Solver＂ and ＂Formula＂ in Excel 2007,with convenient operation and other powerful features.Without the need of a mathematical model,feed formula could be directly obtained by filling relevant parameters in tables. |
| |
| Keywords: | Excel 2007 feed formula form solver feed formula |
| 本文献已被 维普 等数据库收录！ |
|
