Excel饲料配方

Excel饲料配方
Excel饲料配方

体重454kg、平均日产乳量10kg、乳脂率为4.0%、乳蛋白3.5%奶牛日粮配方表1 454 kg体重奶牛饲养标准

营养需要干物质采食量(kg)产奶净能(MJ/kg粗蛋白质(%)RDP(%)

总需要量16 6.2514.19.8

表2 饲料原料营养成分含量和价格

原料总可消化养分(%)干物质(%)产奶净能(MJ/kg粗蛋白质(%)

玉米青贮65.623.5 5.388.8

苜蓿干草56.490.3 4.9917

羊草56.292.5 4.718.1

干玉米秸秆51.394.8 4.22 5.2

玉米88.788.18.448.6

小麦麸71.589.1 6.3817.3

豆粕(浸提)8089.18.4844

棉籽粕(浸提)66.490.5 6.7641

麻饼(内蒙、亚62.892.5 6.1234.4

碳酸氢钠(27%Na)100

磷酸氢钙97

石粉100

食盐(39.34Na、60.66CI)100

添加剂95

表3 配方制作

原料用量(kg)比例(%DM)TDN(%)DM(kg)

玉米青贮20.425531913019.68 4.8

苜蓿干草 3.1893687711810.152 2.88

羊草 1.2108108117 3.934 1.12

干玉米秸秆0000

玉米 4.5402951192522.1754

小麦麸 1.6879910219.4 6.721 1.504

豆粕(浸提) 1.4365881038 6.4 1.28

棉籽粕(浸提)0000

麻饼(内蒙、亚0000

碳酸氢钠(27%N0.080.500.08

磷酸氢钙0.0329896910.200.032

石粉0.0640.400.064

食盐(39.34Na、0.080.500.08

添加剂0.168421053100.16

合计32.9159964810069.06216

饲养标准1006816

标准差 1.42109E-14 1.5496636560

、乳蛋白3.5%奶牛日粮配方

粗蛋白质(g)RDP(g) RUP(%)NDF(%)ADF(%)钙(%)磷(%)产奶净能(M

4.343270.650.422.722561560

NDFN(%)RDP(%)RUP(%)粗脂肪(%)NDF(%)ADF(%)ADL(%)ASH(%)

1.467.83

2.2 2.654.134.1

3.5

4.8

3.159.140.9 1.841.632.87.611

2.956.34

3.7 3.959.63

4.12 4.82 6.21

1.34

2.657.40.98

3.9866.57

4.18 6.9

0.752.747.349.5 3.40.9 1.5

2.879.320.7 4.242.515.53 6.3

0.765.434.6 1.814.9100.7 6.6

3.352.147.90.730.819.97.6 6.7

7.94753936.122.18.3 6.5

NE( MJ/kg)CP(%)NDFN(%)RDP(%)RUP(%)FAT(%)NDF(%)ADF(%)

1.614

2.640.42 1.789920.850080.7816.2310.23

0.8982 3.060.558 1.80846 1.251540.3247.488 5.904

0.32970.5670.2030.3192210.2477790.273 4.172 2.3884

00000000

2.11 2.150.175 1.13305 1.016951 2.3750.85

0.59972 1.62620.2632 1.2895770.3366230.3948 3.995 1.457

0.6784 3.520.056 2.30208 1.217920.144 1.1920.8

00000000

00000000

00000000

00000000

00000000

00000000

00000000

6.2300213.5632 1.67528.642308 4.920892 2.915835.45221.6294

6.2514.19.8 4.34327

-0.320191795-3.88097-12.554713.46708-19.2423-22.0879

RUP/RDP0.569396

RUP(g)钙(g)磷(g)

68010464

钙(%)磷(%)Leu(%CP)IIe(%CP)VaI(%CP)Arg(%CP)His(%CP)Lys(%CP)Met(%CP)

0.290.248.59 3.34 4.47 1.97 1.79 2.51 1.53

1.470.287.11 3.98 5.03 4.14

2.16 4.34 1.46

0.650.19 6.22 3.32 4.51 3.83 1.63 3.48 1.3

0.880.070000000

0.040.311.2 3.31 4.02 4.61 3.13 2.84 2.13

0.13 1.18 6.16 3.15 4.5 6.84 2.82 4.05 1.57

0.40.717.81 4.56 4.697.38 2.77 6.28 1.45

0.2 1.15 5.89 3.09 4.2411.05 2.82 4.13 1.59

0.40.83 6.13 4.64 5.188.84 2.02 3.69 1.76

2219.3

34

ADL(%)NSC(%)SC(%)CHO(%)HC(%)CEL(%)ASH(%)Ca(%)P(%)

1.059.3315.8125.1467.74 1.440.0870.072

1.368 5.706 6.931

2.636 1.584 2.556 1.980.26460.0504

0.3374 1.7563 3.969 5.7253 1.7836 1.61630.43470.04550.0133

000000000

0.22519.275 2.221.475 1.5250.250.3750.010.075

0.282 3.055 3.7318 6.7868 2.5380.58280.59220.012220.11092

0.056 2.672 1.136 3.8080.3920.2160.5280.0320.0568

000000000 000000000

00.500.500000

00.200.20000.0440.0386

00.400.40000.1360

00.500.500000

010100000

3.31844

4.394333.776878.171113.822612.9611

5.34990.631320.41702

0.650.4

-2.91574 4.166361 SC/NSC0.760836

Cys(%CP)Phe(%CP)Thr(%CP)Trp(%CP)Asp(%CP)Glu(%CP)Ala(%CP)Gly(%CP)Ser(%CP)

1.34 3.83 3.190.44

1.08 4.89 4.1 1.39

1.17 3.92 3.6 1.24

0000

2.13 4.62

3.550.72

2.1

3.97 3.26 1.37

1.52 5.26 3.98 1.27

1.68 5.31 3.23 1.21

1.76 4.67 3.75 1.55

Leu(%)IIe(%)VaI(%)Arg(%)His(%)Lys(%)Met(%)Cys(%)Phe(%) 0.2267760.0881760.1180080.0520080.0472560.0662640.0403920.0353760.101112 0.2175660.1217880.1539180.1266840.0660960.1328040.0446760.0330480.149634 0.0352670.0188240.0255720.0217160.0092420.0197320.0073710.0066340.022226

000000000

0.24080.0711650.086430.0991150.0672950.061060.0457950.0457950.09933 0.1001740.0512250.0731790.1112320.0458590.0658610.0255310.034150.06456 0.2749120.1605120.1650880.2597760.0975040.2210560.051040.0535040.185152

000000000 000000000 000000000 000000000 000000000 000000000 000000000 1.0954950.5116910.6221950.6705310.3332520.5667770.2148050.2085070.622015

Pro(%CP)Tyr(%CP)TEAA(%CP)TNEAA(%CP)B CAA(%CP)价格(元/kg)

0.2

1

0.7

0.3

0.4

0.72

2

1.3

1.2

4

6

5

0.6

0.1

Thr(%)Trp(%)Asp(%)Glu(%)Ala(%)Gly(%)Ser(%)Pro(%)Tyr(%) 0.0842160.011616

0.125460.042534

0.0204120.007031

00

0.0763250.01548

0.0530140.022279

0.1400960.044704

00

00

00

00

00

00

00

0.4995230.143644

TEAA(%)TNEAA(%)BCAA(%)价格(元/kg)5.4884340 2.2293810.06

0.18

0.049

0.1

0.06768

0.16

0.02

0.012

0.02

0.003

0.001

0.67268

相关文档
最新文档