借助办公软件(Microsoft Excel)自动计算肉牛全混日粮配方  

Automatic calculation of total mixed ration formula for beef cattle with help of office software Microsoft Excel

作　　者：张丽君 Zhang Lijun(Liaoning Agricultural Development Service Center,Liaoning Shenyang 110032)

机构地区：[1]辽宁省农业发展服务中心,辽宁沈阳110032

出　　处：《现代畜牧兽医》2022年第6期26-31,共6页Modern Journal of Animal Husbandry and Veterinary Medicine

摘　　要：研究旨在帮助中、小型肉牛养殖场实现全混合日粮精准饲养,以北方农区肉牛养殖的主流饲料组成和饲喂方式下的哺乳期母牛为具体样例,利用办公软件Microsoft Excel的数据分析功能,自动运算肉牛全混日粮配方,并进行了3个分析配方设计验证配方的合理性。结果显示,配方紧密结合养殖实践,达到成本最低、各主要营养素精准的设计要求。研究表明,Excel线性规划求解的运算方法是设计肉牛全混日粮配方的高效、实用、准确、免费的好方法。The purpose of the study is to help small and medium-sized beef cattle farms achieve precision feeding of full mixed rations. Taking the mainstream feed composition and feeding methods of beef cattle breeding in northern agricultural areas as a specific example, using the data analysis function of the office software Microsoft Excel, the formula of the total mixed ration for beef cattle was automatically calculated, and three analytical formula designs were carried out to verify the rationality of the formula. The result showed that the formula was closely integrated with farming practice, and meets the design requirements of the lowest cost and the precise design of each major nutrient. The study indicates that the Excel linear programming method is an efficient, practical, accurate and free method for designing a formula for a total mixed ration for beef cattle.

关 键 词：肉牛 日粮配方 精准营养 全混日粮 Microsoft Excel 

分 类 号：S8-01[农业科学—畜牧兽医]