EXCEL制作的猪饲料配方

1、怀孕母猪料饲养标准2009/6/10营养指标粗蛋白 粗纤维%钙磷消化能(MJ/KG)赖氨酸 蛋氨酸 苏氨酸 色氨酸含量1280.680.5429500.460.120.370.09饲料价格及营养价值饲料名称价粗蛋白%粗纤维% CAP消化能赖氨酸 蛋氨酸 苏氨酸色氨酸玉米0.778.71.60.020.2734000.230.150.290.06小麦0.713.91.90.170.4132400.30.250.330.15麦麸0.7615.78.90.110.9222400.580.130.430.2米糠0.712.85.70.071.4330200.740.250.480.14菜籽饼0.735

2、.711.40.590.9628801.070.591.050.38豆粕1.71435.10.320.633002.660.621.920.64赖氨酸7.8780044407800预混料2.2500000小苏打0.5花生饼0.844.75.90.250.5330801.290.381.050.42芝麻饼0.8367.22.241.1928000.80.81.290.49配方饲料生产量配比%粗蛋白% 粗纤维% CAP消化能 赖氨酸 蛋氨酸苏氨酸 色氨酸玉米668.566.85 5.815951.06960.01337 0.180495 2272.9 0.1538 0.100275 0.1939

3、0.04011小麦00000000000麦麸200203.141.780.0220.184448 0.1160.0260.0860.04米糠00000000000菜籽饼00000000000豆粕9093.870.4590.02880.054297 0.23940.0558 0.17280.0576赖氨酸00000000000预混料404000000000花生饼00000000000小苏打1.50.15芝麻饼00000000000合计1000100 12.82593.30860.06417 0.418495 3017.9 0.5092 0.182075 0.4527 0.13771饲料标准100

4、01001280.680.5429500.460.120.370.09标准差00 6.65392 -82.9705 -165.508 -25.3533 2.27551 10.144 41.09906 20.097 41.90418成本911.39591.1395哺乳母猪料2009/6/10哺乳母猪营养标准营养指标粗蛋白粗纤维%钙磷消化能(MJ/KG)赖氨酸 蛋氨酸 苏氨酸 色氨酸含量1880.770.6233000.910.230.580.17饲料价格及营养指标饲料名称价粗蛋白%粗纤维% CAP消化能赖氨酸 蛋氨酸 苏氨酸色氨酸玉米0.78.71.60.020.2734000.230.150.

5、290.06小麦0.713.91.90.170.4132400.30.250.330.15麦麸0.715.78.90.110.9222400.580.130.430.2米糠0.712.85.70.071.4330200.740.250.480.14菜籽饼0.635.711.40.590.9628801.070.591.050.38豆粕1.57435.10.320.633002.660.621.920.64小苏打0.5赖氨酸7.8780044407800预混料3.0400000花生饼0.744.75.90.250.5330801.290.381.050.42芝麻饼0.7367.22.241.19

6、28000.80.81.290.49生物蛋白0.31327.975.720.5430000.680.341.190.14配方饲料生产量配比%粗蛋白% 粗纤维% CAP消化能 赖氨酸 蛋氨酸苏氨酸 色氨酸玉米67.5567.55 5.876851.08080.01351 0.182385 2296.7 0.1554 0.101325 0.1959 0.04053小麦00000000000麦麸10101.570.890.0110.092224 0.0580.0130.0430.02米糠00000000000菜籽饼00000000000豆粕18187.740.9180.05760.108594 0.

7、47880.1116 0.34560.1152小苏打0.150.150赖氨酸0.30.30.23400013.32 0.234000预混料44000000000花生饼00000000000芝麻饼00000000000生物蛋白00000000000合计100100 15.42092.88880.08211 0.382385 3128.02 0.9262 0.225925 0.5845 0.17573饲料标准1001001880.770.6233000.910.230.580.17标准差00 -15.434-93.88 -161.456 -47.4099 -5.3509 1.7607 -1.787

8、570.772 3.314725成本97.1297.12大猪料大猪营养标准营养指标粗蛋白粗纤维%钙磷消化能(MJ/KG)赖氨酸 蛋氨酸 苏氨酸 色氨酸含量14.550.490.4332000.70.190.480.13饲料价格及营养指标饲料名称价粗蛋白%粗纤维% CAP消化能赖氨酸 蛋氨酸 苏氨酸色氨酸玉米0.7058.71.60.020.2734000.230.150.290.06小麦0.7513.91.90.170.4132400.30.250.330.15麦麸0.715.78.90.110.9222400.580.130.430.2米糠0.7212.85.70.071.4330200.7

9、40.250.480.14菜籽饼0.635.711.40.590.9628801.070.591.050.38豆粕1.6435.10.320.633002.660.621.920.64酶0.1其它06000赖氨酸7.8780044407800小苏打0.5生物蛋白0.35327.975.720.5430000.680.341.190.14预混料3.0400000花生饼0.744.75.90.250.5330801.290.381.050.42芝麻饼0.7367.22.241.1928000.80.81.290.49碎米0.8210.41.10.060.3536000.420.220.380.12

10、配方饲料生产量配比%粗蛋白% 粗纤维% CAP消化能 赖氨酸 蛋氨酸苏氨酸 色氨酸玉米980494.2630.7840.00980.13231666 0.11270.0735 0.14210.0294小麦0000000000麦麸16081.2560.7120.00880.0736179.2 0.04640.0104 0.03440.016米糠200101.280.570.0070.143302 0.0740.0250.0480.014菜籽饼0000000000豆粕280146.020.7140.04480.084462 0.37240.0868 0.26880.0896酶0000000000其

11、它0000000000赖氨酸0000000000小苏打0000000000生物蛋白0000000000预混料804000000000花生饼200104.470.590.0250.053308 0.1290.0380.1050.042芝麻饼10051.80.360.1120.05951400.040.04 0.06450.0245碎米0000000000合计200010019.0893.730.20740.5454 3057.2 0.77450.2737 0.66280.2155饲料标准200010014.550.490.4332000.70.190.480.13标准差00 27.3244 -2

12、9.0951 -81.0439 23.66209 -4.5643 10.105 36.10093 31.992 49.49349成本1848.192.405中猪料2009/6/10饲养标准2009/6/10 10:35营养指标粗蛋白 粗纤维%钙磷消化能(MJ/KG)赖氨酸 蛋氨酸 苏氨酸 色氨酸含量16.430.460.3731000.820.220.580.15饲料价格及营养值饲料名称价粗蛋白%粗纤维% CAP消化能赖氨酸 蛋氨酸 苏氨酸色氨酸玉米0.78.71.60.020.2734000.230.150.290.06小麦0.713.91.90.170.4132400.30.250.330

13、.15麦麸0.715.78.90.110.9222400.580.130.430.2米糠0.712.85.70.071.4330200.740.250.480.14菜籽饼0.635.711.40.590.9628801.070.591.050.38豆粕1.68435.10.320.633002.660.621.920.64鱼粉053.50.85.883.230903.871.392.510.6酵母粉0500.85.883.230903.871.392.510.6赖氨酸7.8780044407800预混料3.200000花生饼0.844.75.90.250.5330801.290.381.050

14、.42芝麻饼0.8367.22.241.1928000.80.81.290.49小苏打0.5氯化胆碱1.8母猪浓缩料2.14085.720.5430002.80.651.190.14配方饲料生生产产量量配比%粗蛋白% 粗纤维% CAP消化能 赖氨酸 蛋氨酸苏氨酸 色氨酸玉米1 13 37 72 268.65.96821.09760.01372 0.18522 2332.4 0.15780.1029 0.1989 0.04116小麦0 0000000000麦麸8 80 040.6280.3560.00440.036889.6 0.02320.0052 0.01720.008米糠6 65 53.2

15、50.416 0.18525 0.002275 0.04647598.15 0.024 0.00813 0.0156 0.00455菜籽饼0 00000000000豆粕4 40 00 0208.61.020.0640.12660 0.5320.1240.3840.128鱼粉0 00000000000酵母粉0 00000000000赖氨酸3 30.150.1170006.66 0.117000预混料8 80 04000000000花生饼0 00000000000芝麻饼0 00000000000小苏打0 00000000000氯化胆碱0 00000000000母猪浓缩料0 00000000000合

16、计2 20 00 00 0100 15.7292 2.65885 0.084395 0.388495 3186.81 0.854 0.24023 0.6157 0.18171饲料标准2 20 00 00 010016.430.460.3731000.820.220.580.15标准差0 00 -4.1756 -12.0572-137.99 4.876763 2.76165 4.0656 8.78918 5.9779 19.11911成本2 20 01 13 3. .3 3100.6650 0小小猪猪料料2009/6/10饲饲养养标标准准营养指标粗蛋白粗纤维%钙磷消化能(MJ/KG)赖氨酸 蛋氨

17、酸 苏氨酸 色氨酸含量17.830.620.5331000.90.240.580.16饲料价格及营养价值饲料名称价粗蛋白%粗纤维% CAP消化能赖氨酸 蛋氨酸 苏氨酸色氨酸玉米0.7058.71.60.020.2734000.230.150.290.06小麦0.713.91.90.170.4132400.30.250.330.15麦麸0.715.78.90.110.9222400.580.130.430.2米糠0.712.85.70.071.4330200.740.250.480.14菜籽饼0.735.711.40.590.9628801.070.591.050.38豆粕1.68435.10.

18、320.633002.660.621.920.64赖氨酸7.8780044407800预混料3.0400000花生饼0.844.75.90.250.5330801.290.381.050.42芝麻饼0.8367.22.241.1928000.80.81.290.49生物蛋白0.35327.975.720.5430000.680.341.190.14小苏打0.5氯化胆碱1.8配配方方饲料生生产产量量配比%粗蛋白% 粗纤维% CAP消化能 赖氨酸 蛋氨酸苏氨酸色氨酸玉米3 33 38 8. .2 25 567.65 5.885551.08240.01353 0.182655 2300.1 0.15

19、56 0.101475 0.196185 0.04059小麦0 00000000000麦麸2 20 040.6280.3560.00440.036889.6 0.02320.00520.01720.008米糠0 00000000000菜籽饼0 00000000000豆粕1 12 20 02410.321.2240.07680.144792 0.63840.14880.4608 0.1536赖氨酸0 0. .7 75 50.150.1170006.66 0.117000预混料2 20 04000000000花生饼0 00000000000芝麻饼0 00000000000生物蛋白0 0000000

20、0000小苏打0 0. .5 50.1氯化胆碱0 0. .5 50.1合计5 50 00 0100 16.95062.66240.09473 0.363455 3188.36 0.9342 0.255475 0.674185 0.20219饲料标准5 50 00 010017.830.620.5331000.90.240.580.16标准差0 00 -4.88884 -11.9243 -146.984 -37.281 2.8103 3.7286116.2465311 15.0193成本5 52 21 1. .8 86 66 62 25 5 104.3733断断奶奶仔仔猪猪料料#NAME?饲饲养

21、养标标准准营养指标粗蛋白粗纤维%钙磷消化能(MJ/KG)赖氨酸 蛋氨酸 苏氨酸 色氨酸含量190.620.5332501.160.30.750.21饲料价格及营养价值饲料名称价粗蛋白%粗纤维% CAP消化能赖氨酸 蛋氨酸 苏氨酸色氨酸玉米0.78.71.60.020.2734000.230.150.290.06小麦0.713.91.90.170.4132400.30.250.330.15麦麸0.715.78.90.110.9222400.580.130.430.2米糠0.712.85.70.071.4330200.740.250.480.14菜籽饼0.635.711.40.590.962880

22、1.070.591.050.38豆粕1.57435.10.320.633002.660.621.920.64蛋氨酸401004000100赖氨酸7.8980044409800预混料3.0400000花生饼0.744.75.90.250.5330801.290.381.050.42芝麻饼0.8367.22.241.1928000.80.81.290.49乳清粉3.51200.040.137500.30.110.20.1小苏打0.5豆油58900氯化胆碱1.8配配方方饲料生生产产量量配比%粗蛋白% 粗纤维% CAP消化能 赖氨酸 蛋氨酸苏氨酸 色氨酸玉米6 65 5. .0 01 165.01 5

23、.65587 1.04016 0.013002 0.175527 2210.34 0.1495 0.097515 0.1885 0.03901小麦0 00000000000麦麸0 0000000000米糠0 00000000000菜籽饼0 00000000000豆粕3 30 03012.91.530.0960.18990 0.7980.1860.5760.192蛋氨酸0 0. .0 04 40.040.040001.600.0400赖氨酸0 0. .3 35 50.350.34300015.54 0.343000预混料4 44000000000花生饼0 00000000000芝麻饼0 0000

24、0000000乳清粉0 00811.800000000小苏打0 00000000000豆油0 0. .5 50.5000044.50000氯化胆碱0 0. .1 10.1000000000合计1 10 00 0100 830.739 2.57016 0.109002 0.355527 3261.98 1.2905 0.323515 0.7645 0.23101饲料标准1 10 00 01001900.620.5332501.160.30.750.21标准差0 00 191.0561200 -140.191 -39.405 0.3679 10.65266 7.5427 1.91862成本1 10

25、 07 7. .6 67 77 7107.677采购金额运费下车 玉米小麦 麸皮米糠豆粕菜饼2007/10/6312024602503004742007/10/7 张家勇74402007/10/7 王米厂3005002007/10/9 城西老刘795.22010402007/10/9 方庙酒厂502007/10/10 王米厂2484002007/10/10 章国820202007/10/12 宜城7260601042002007/10/18 章国851.2202007/10/18 门市2007/10/21 城西刘二440207542007/10/22 襄樊小邵4402007/10/22 李端正

26、11202007/10/23 门市2007/10/24 张家勇211892102007/10/26 张家勇02252007/10/28 李端正32002007/10/27 章国2007/10/27 城西老刘6492007/11/2 门市2007/11/5 圣清?2007/11/20 张家勇5022007/11/23 章国780202007/11/23 李端正55802007/11/25 张家勇141621682007/11/25 张福海14*1402007/12/12 张家勇395合计11984.416010 459110 12360265045002917库存 玉米小麦 麸皮米糠 豆粕菜饼花

27、生饼 赖氨酸合计33250.59156 10652995832.43843生产生产日期饲料品种 加工重量 玉米小麦 麸皮米糠 豆粕菜饼花生饼 赖氨酸2007/10/6 大猪料2000600400300250020020032007/10/8 中猪料1000398130801002510010022007/10/8 大猪料2000600400300400020020032007/10/9 怀孕料50022910010025250.52007/10/9 小猪料500336107012.65012007/10/10 大猪料200041750020040024020032007/10/12 大猪料200084043220014014016032007/10/12 哺乳料50021975502540700.52007/10/12 中猪料1000492130801007010022007/10/14 小猪料5003351070175012007/10/14 怀孕料50025410010025250.52007/10/14 大猪料200094033220014014016032007/10/17 大猪料