Excel饲料配方

表1 454 kg体重奶牛饲养标准营养需要干物质采食量（kg)产奶净能（MJ/kg粗蛋白质(%)RDP(%)总需要量166.2514.19.8表2 饲料原料营养成分含量和价格原料总可消化养分（％）干物质（%)产奶净能（MJ/kg粗蛋白质（%）玉米青贮65.623.55.388.8苜蓿干草56.490.34.9917羊草56.292.54.718.1干玉米秸秆51.394.84.225.2玉米88.788.18.448.6小麦麸71.589.16.3817.3豆粕（浸提）8089.18.4844棉籽粕（浸提）66.490.56.7641麻饼（内蒙、亚62.892.56.1234.4碳酸氢钠(27％Na)100磷酸氢钙97石粉100食盐(39.34Na、60.66CI)100添加剂95表3 配方制作原料用量(kg)比例（%DM）TDN(%)DM（kg)玉米青贮20.425531913019.684.8苜蓿干草3.1893687711810.1522.88羊草1.21081081173.9341.12干玉米秸秆0000玉米4.5402951192522.1754小麦麸1.6879910219.46.7211.504豆粕（浸提） 1.43658810386.41.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-141.5496636560体重454kg、平均日产乳量10kg、乳脂率为4.0%、乳蛋白3.5％奶牛日粮配方RUP(%)NDF(%) ADF(%)钙(%)磷(%)产奶净能（M粗蛋白质(g)RDP(g)4.343270.650.422.7 2256 1560NDFN(%)RDP(%)RUP(%)粗脂肪(%)NDF(%) ADF(%)ADL(%)ASH(%)1.467.8 32.22.654.1 34.13.54.83.159.1 40.91.841.6 32.87.6112.956.3 43.73.959.634.124.82 6.211.342.6 57.40.9 83.9866.574.186.90.752.7 47.349.53.40.91.52.879.3 20.74.242.5 15.536.30.765.4 34.61.814.9100.76.63.352.1 47.90.730.8 19.97.66.77.94753936.1 22.18.36.5NE（ MJ/kg）CP(%)NDFN(%)RDP(%)RUP(%)FAT(%)NDF(%) ADF(%)1.6142.64 0.421.789920.850080.7816.2310.230.89823.060.5581.808461.251540.3247.4885.9040.32970.5670.2030.3192210.2477790.2734.1722.3884000000002.11 2.150.1751.133051.01695 12.3750.850.599721.62620.26321.2895770.3366230.39483.9951.4570.67843.520.0562.302081.217920.1441.192 0.8000000000000000000000000000000000000000000000000000000006.2300213.56321.67528.6423084.9208922.915835.45221.62946.25 14.19.84.34327-0.320191795-3.88097-12.554713.46708-19.2423-22.0879RUP/RDP0.569396、乳蛋白3 .5 ％奶牛日粮配方RUP(g)钙(g)磷...