免费excel饲料配方软件

1、,原料名称,原料价格,消化能,代谢能,粗蛋白,赖氨酸,蛋氨酸,钙,磷,有效磷,蛋+胱,食盐,粗灰分,粗脂肪,粗纤维,亚油酸,苏氨酸,色氨酸,肉牛增重净能,奶牛产奶净能,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,手动配方,上限,下限,自动配比玉米,1.20 ,3.41 ,3.24 ,8.70 ,0.24 ,0.18 ,0.02 ,0.27 ,0.12 ,0.375,0.02,1.4,3.6,1.6,2,0.314,0.062,1310,1840,50,7

2、0,58.3 小麦麸,0.82 ,2.24 ,1.63 ,15.70 ,0.58 ,0.13 ,0.11 ,0.92 ,0.24 ,0.39,0.18,4.9,3.9,8.9,1.8,0.43,0.2,1000,1490,0,5,3.1 次粉,0.90 ,3.27 ,3.05 ,15.40 ,0.59 ,0.23 ,0.08 ,0.48 ,0.14 ,0.49,0.15,1.8,2.1,2.8,1.74,0.5,0.18,1240,1760,0,0,0.0 豆粕,2.70 ,3.15 ,2.30 ,44.00 ,2.45 ,0.64 ,0.32 ,0.61 ,0.17 ,1.3,0.07,6,

3、1.9,5.1,0.8,1.88,0.7,1270,1890,83,0,100,13.6 花生饼,1.90 ,3.08 ,2.78 ,45.80 ,1.32 ,0.39 ,0.25 ,0.53 ,0.31 ,0.77,0.1,5.1,7.2,5.9,1.7,1.05,0.42,1650,2140,1,0,5,5.0 棉粕,1.25 ,2.26 ,2.01 ,38.00 ,1.59 ,0.45 ,0.24 ,0.97 ,0.33 ,1.136,0.1,6.5,0.7,10.1,0.35,1.17,0.393,1150,1630,0,3,3.0 菜粕,1.22 ,2.53 ,1.77 ,36.00

4、 ,1.30 ,0.63 ,0.65 ,1.02 ,0.35 ,1.399,0.23,7.3,1.4,11.8,0.42,1.39,0.401,1060,1540,0,3,3.0 玉米胚芽粕,0.99 ,3.28 ,2.07 ,17.00 ,0.75 ,0.21 ,0.06 ,1.23 ,0.49,0.03,5.9,2,6.5,0.8,0.68,0.18,1000,1400,0,3,2.6 玉米酒糟,1.10 ,3.43 ,2.20 ,27.00 ,0.59 ,0.59 ,0.20 ,0.74 ,0.74 ,0.89,2.25,3.6,14.6,8,5.05,1.17,1370,1900,0,

5、0,0.0 肉粉,2.50 ,2.73 ,2.46 ,60.00 ,6.67 ,0.74 ,0.29 ,0.31 ,0.31 ,1.14,1.8,21,9,0.62,2.4,0.65,1000,1500,0,0,0.0 乳清粉,5.00 ,3.44 ,2.73 ,12.00 ,1.10 ,0.20 ,0.87 ,0.79 ,0.79 ,0.5,6.3,9.7,0.7,0.8,0.2,1290,1800,0,0,0.0 鱼粉,4.80 ,3.00 ,2.82 ,60.00 ,4.72 ,1.64 ,4.04 ,2.90 ,2.90 ,2.2,2.2,14.5,0.5,0.12,2.78,0.75

6、,1140,3,0,0,0.0 肉骨粉,2.60 ,2.40 ,2.38 ,50.00 ,2.20 ,0.53 ,4.00 ,4.00 ,4.00 ,1,1.8,33,8.5,2.8,0.62,1.63,1200,1560,0,1,1.0 骨粉,1.30 ,1.30 ,1.00 ,0.20 ,31.00 ,13.00 ,13.00 ,98,0,0,0.0 磷酸氢钙,1.26 ,1.40 ,21.00 ,16.00 ,16.00 ,98,3,1,2,1.4 石粉,0.11 ,0.10 ,35.00 ,98,3,0,10,7.3 水解羽毛粉,1.20 ,77.90 ,2.30 ,3.52,1.75

7、,5.8,2.2,0.83,3.51,0.4,1000,1500,0,0,0,0.0 食盐,0.75 ,0.70 ,98,98,1.5,0.3,0.4,0.3 预混料,15.80 ,30,2,1,1,1.0 小苏打,0.80 ,98,0,0,0.0 磷酸脲,7.20 ,0,0,0.0 沸石粉,0.17 ,0.18 ,98,2.1,0,2,0.0 玉米油,4.05 ,9.00 ,8.80 ,98,1,0,0,0.0 酸化剂,20.00 ,0,0,0.0 氯化胆碱,3.80 ,0,0,0.0 赖氨酸,25.00 ,78.80 ,0,0,0.0 蛋氨酸,33.00 ,98.00 ,98,0,0.2,

8、0.1 鱼油,5.50 ,9.00 ,8.80 ,98,0,0,0.0 无水硫酸钠,0.80 ,98,0.2,0.1,0.1,0.1 赖氨酸,17.00 ,0.1,0.1,0.2,0.1 防霉剂,5.00 ,0.1,0.1,0.1,0.1 合计,100,100,100.0 成本（元/吨）,2840 ,1559.0 消化能,2885 ,2920.7 代谢能,2109 ,2580,2581.1 粗蛋白,38.78 ,17,17.0 赖氨酸,2.19 ,0.7 蛋氨酸,0.58 ,0.37,0.4 钙,2.07 ,3,3.0 总磷,1.08 ,0,0.7 有效磷,0.71 ,0.4,0.4 蛋+胱,1.15 ,0.7 食盐,1.60 ,0.4 粗灰分,15.67 ,12.2 粗脂肪,2.63 ,3.0 粗纤维,4.31 ,3.1 亚油酸,0.68 ,1.5 苏氨酸,1.65 ,0.6 色氨酸,0.61 ,0.2 肉牛增