{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["IOFSC-E","IOFSC-M","MSGC-Arg"],"not_rendered":{"charts":6,"images":11,"macros":1,"external_links":0,"defined_names":136,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"IOFSC-E","index":0,"n_rows":115,"n_cols":43,"rows_kept":115,"cut":false,"hidden":true,"merged":[[198,5,198,6],[198,7,198,8],[198,13,198,15],[198,17,198,19],[199,13,199,15],[199,17,199,19],[198,9,198,10],[198,11,198,12],[198,1,198,2],[198,3,198,4],[199,1,199,2],[199,3,199,4],[199,5,199,6],[199,7,199,8],[199,9,199,10],[199,11,199,12],[196,13,196,15],[196,17,196,19],[197,1,197,2],[197,3,197,4],[197,5,197,6],[197,7,197,8],[197,13,197,15],[197,17,197,19],[197,9,197,10],[197,11,197,12],[196,9,196,10],[196,11,196,12],[196,1,196,2],[196,3,196,4],[196,5,196,6],[196,7,196,8],[195,13,195,15],[195,17,195,19],[194,1,194,2],[194,3,194,4],[195,9,195,10],[195,11,195,12],[195,1,195,2],[195,3,195,4],[195,5,195,6],[195,7,195,8],[194,9,194,10],[194,11,194,12],[192,13,192,15],[192,17,192,19],[193,13,193,15],[193,17,193,19],[193,9,193,10],[193,11,193,12],[194,13,194,15],[194,17,194,19],[192,1,192,2],[192,3,192,4],[194,5,194,6],[194,7,194,8],[193,1,193,2],[193,3,193,4],[193,5,193,6],[193,7,193,8],[192,5,192,6],[192,7,192,8],[191,13,191,15],[191,17,191,19],[191,1,191,2],[191,3,191,4],[191,5,191,6],[191,7,191,8],[192,9,192,10],[192,11,192,12],[188,9,188,10],[188,11,188,12],[189,9,189,10],[189,11,189,12],[191,9,191,10],[191,11,191,12],[190,9,190,10],[190,11,190,12],[190,1,190,2],[190,3,190,4],[190,5,190,6],[190,7,190,8],[188,13,188,15],[188,17,188,19],[189,13,189,15],[189,17,189,19],[190,13,190,15],[190,17,190,19],[189,5,189,6],[189,7,189,8],[189,1,189,2],[189,3,189,4],[188,1,188,2],[188,3,188,4],[188,5,188,6],[188,7,188,8],[187,5,187,6],[187,7,187,8],[184,9,184,10],[184,11,184,12],[187,9,187,10],[187,11,187,12],[186,9,186,10],[186,11,186,12],[186,1,186,2],[186,3,186,4],[187,13,187,15],[187,17,187,19],[185,9,185,10],[185,11,185,12],[186,13,186,15],[186,17,186,19],[187,1,187,2],[187,3,187,4],[183,5,183,6],[183,7,183,8],[184,5,184,6],[184,7,184,8],[186,5,186,6],[186,7,186,8],[185,5,185,6],[185,7,185,8],[184,13,184,15],[184,17,184,19],[185,13,185,15],[185,17,185,19],[184,1,184,2],[184,3,184,4],[185,1,185,2],[185,3,185,4],[182,1,182,2],[182,3,182,4],[182,5,182,6],[182,7,182,8],[183,13,183,15],[183,17,183,19],[182,13,182,15],[182,17,182,19],[183,1,183,2],[183,3,183,4],[180,17,180,19],[181,9,181,10],[181,11,181,12],[181,13,181,15],[181,17,181,19],[183,9,183,10],[183,11,183,12],[180,9,180,10],[180,11,180,12],[182,9,182,10],[182,11,182,12],[181,5,181,6],[181,7,181,8],[181,1,181,2],[181,3,181,4],[180,1,180,2],[180,3,180,4],[180,5,180,6],[180,7,180,8],[180,13,180,15],[178,9,178,10],[178,11,178,12],[178,13,178,15],[178,17,178,19],[179,1,179,2],[179,3,179,4],[179,5,179,6],[179,7,179,8],[179,13,179,15],[179,17,179,19],[179,9,179,10],[179,11,179,12],[178,5,178,6],[178,7,178,8],[178,1,178,2],[178,3,178,4],[177,9,177,10],[177,11,177,12],[176,1,176,2],[176,3,176,4],[176,13,176,15],[176,17,176,19],[177,13,177,15],[177,17,177,19],[176,5,176,6],[176,7,176,8],[177,1,177,2],[177,3,177,4],[177,5,177,6],[177,7,177,8],[175,5,175,6],[175,7,175,8],[175,13,175,15],[175,17,175,19],[174,1,174,2],[174,3,174,4],[176,9,176,10],[176,11,176,12],[173,5,173,6],[173,7,173,8],[174,5,174,6],[174,7,174,8],[175,9,175,10],[175,11,175,12],[173,1,173,2],[173,3,173,4],[175,1,175,2],[175,3,175,4],[173,13,173,15],[173,17,173,19],[174,9,174,10],[174,11,174,12],[173,9,173,10],[173,11,173,12],[172,13,172,15],[172,17,172,19],[172,9,172,10],[172,11,172,12],[174,13,174,15],[174,17,174,19],[172,1,172,2],[172,3,172,4],[172,5,172,6],[172,7,172,8],[171,13,171,15],[171,17,171,19],[171,1,171,2],[171,3,171,4],[171,5,171,6],[171,7,171,8],[170,9,170,10],[170,11,170,12],[171,9,171,10],[171,11,171,12],[169,13,169,15],[169,17,169,19],[170,5,170,6],[170,7,170,8],[169,9,169,10],[169,11,169,12],[170,13,170,15],[170,17,170,19],[169,1,169,2],[169,3,169,4],[169,5,169,6],[169,7,169,8],[170,1,170,2],[170,3,170,4],[168,13,168,15],[168,17,168,19],[168,1,168,2],[168,3,168,4],[168,5,168,6],[168,7,168,8],[168,9,168,10],[168,11,168,12],[167,9,167,10],[167,11,167,12],[166,17,166,19],[167,13,167,15],[167,17,167,19],[166,5,166,6],[166,7,166,8],[165,5,165,6],[165,7,165,8],[165,17,165,19],[167,1,167,2],[167,3,167,4],[167,5,167,6],[167,7,167,8],[165,1,165,2],[165,3,165,4],[166,1,166,2],[166,3,166,4],[164,1,164,2],[164,3,164,4],[164,5,164,6],[164,7,164,8],[165,13,165,15],[165,9,165,10],[165,11,165,12],[164,13,164,15],[166,9,166,10],[166,11,166,12],[166,13,166,15],[164,17,164,19],[163,9,163,10],[163,11,163,12],[163,13,163,15],[163,17,163,19],[164,9,164,10],[164,11,164,12],[161,1,161,2],[161,3,161,4],[161,5,161,6],[161,7,161,8],[163,1,163,2],[163,3,163,4],[163,5,163,6],[163,7,163,8],[162,13,162,15],[162,17,162,19],[162,1,162,2],[162,3,162,4],[162,5,162,6],[162,7,162,8],[162,9,162,10],[162,11,162,12],[161,13,161,15],[161,17,161,19],[161,9,161,10],[161,11,161,12],[159,9,159,10],[159,11,159,12],[159,13,159,15],[159,17,159,19],[160,9,160,10],[160,11,160,12],[160,13,160,15],[160,17,160,19],[160,1,160,2],[160,3,160,4],[160,5,160,6],[160,7,160,8],[159,1,159,2],[159,3,159,4],[158,11,158,12],[158,13,158,15],[158,1,158,2],[158,3,158,4],[158,5,158,6],[158,7,158,8],[159,5,159,6],[159,7,159,8],[158,17,158,19],[157,9,157,10],[157,11,157,12],[157,13,157,15],[157,17,157,19],[158,9,158,10],[157,7,157,8],[155,17,155,19],[156,9,156,10],[156,11,156,12],[156,13,156,15],[156,17,156,19],[155,7,155,8],[155,13,155,15],[155,9,155,10],[155,11,155,12],[157,1,157,2],[157,3,157,4],[157,5,157,6],[156,1,156,2],[156,3,156,4],[156,5,156,6],[156,7,156,8],[154,11,154,12],[154,9,154,10],[150,1,150,2],[153,5,153,6],[153,7,153,8],[153,9,153,10],[153,11,153,12],[155,1,155,2],[155,3,155,4],[154,17,154,19],[153,1,153,2],[153,3,153,4],[154,1,154,2],[154,3,154,4],[154,5,154,6],[154,7,154,8],[153,17,153,19],[150,3,150,4],[150,5,150,6],[150,7,150,8],[150,11,150,12],[150,9,150,10],[155,5,155,6],[142,17,142,19],[139,17,139,19],[140,17,140,19],[137,17,137,19],[138,17,138,19],[141,17,141,19],[134,17,134,19],[135,17,135,19],[130,17,130,19],[133,17,133,19],[146,13,146,15],[150,17,150,19],[150,13,150,15],[145,13,145,15],[149,13,149,15],[148,13,148,15],[147,13,147,15],[139,13,139,15],[125,32,125,34],[149,17,149,19],[143,17,143,19],[144,17,144,19],[145,17,145,19],[146,17,146,19],[147,17,147,19],[148,17,148,19],[136,17,136,19],[138,13,138,15],[135,13,135,15],[136,13,136,15],[137,13,137,15],[143,13,143,15],[140,13,140,15],[141,13,141,15],[118,32,118,34],[120,32,120,34],[121,32,121,34],[120,30,120,31],[123,32,123,34],[119,32,119,34],[122,30,122,31],[114,32,114,34],[115,32,115,34],[120,17,120,19],[115,30,115,31],[108,32,108,34],[109,32,109,34],[110,32,110,34],[111,32,111,34],[116,32,116,34],[108,30,108,31],[129,17,129,19],[121,30,121,31],[117,32,117,34],[124,30,124,31],[122,32,122,34],[119,30,119,31],[123,30,123,31],[124,32,124,34],[125,30,125,31],[122,17,122,19],[109,30,109,31],[110,30,110,31],[111,30,111,31],[112,32,112,34],[113,32,113,34],[112,30,112,31],[114,17,114,19],[117,30,117,31],[118,30,118,31],[114,30,114,31],[116,30,116,31],[115,17,115,19],[117,17,117,19],[113,30,113,31],[118,17,118,19],[113,17,113,19],[124,17,124,19],[132,13,132,15],[126,13,126,15],[132,17,132,19],[127,13,127,15],[126,17,126,19],[127,17,127,19],[125,17,125,19],[124,13,124,15],[125,13,125,15],[131,17,131,19],[128,17,128,19],[131,13,131,15],[130,13,130,15],[107,7,107,8],[107,9,107,10],[140,11,140,12],[140,9,140,10],[139,11,139,12],[137,3,137,4],[138,3,138,4],[139,9,139,10],[140,3,140,4],[140,5,140,6],[140,7,140,8],[139,7,139,8],[133,9,133,10],[134,9,134,10],[136,11,136,12],[138,11,138,12],[133,11,133,12],[134,11,134,12],[137,11,137,12],[135,11,135,12],[114,9,114,10],[113,9,113,10],[112,7,112,8],[112,9,112,10],[112,11,112,12],[117,13,117,15],[116,7,116,8],[136,9,136,10],[138,9,138,10],[137,9,137,10],[142,13,142,15],[133,13,133,15],[134,13,134,15],[129,13,129,15],[135,7,135,8],[136,7,136,8],[132,9,132,10],[130,11,130,12],[121,9,121,10],[119,9,119,10],[120,11,120,12],[119,11,119,12],[121,11,121,12],[120,13,120,15],[118,13,118,15],[119,13,119,15],[132,11,132,12],[127,7,127,8],[144,13,144,15],[107,11,107,12],[128,13,128,15],[129,11,129,12],[131,11,131,12],[146,11,146,12],[147,3,147,4],[149,3,149,4],[147,5,147,6],[149,5,149,6],[146,9,146,10],[146,3,146,4],[148,11,148,12],[146,7,146,8],[147,7,147,8],[149,7,149,8],[149,9,149,10],[147,9,147,10],[148,9,148,10],[148,7,148,8],[149,11,149,12],[147,11,147,12],[148,3,148,4],[148,5,148,6],[143,3,143,4],[143,5,143,6],[135,9,135,10],[145,11,145,12],[144,7,144,8],[144,11,144,12],[145,9,145,10],[143,11,143,12],[142,3,142,4],[141,5,141,6],[143,7,143,8],[141,11,141,12],[142,11,142,12],[142,7,142,8],[144,9,144,10],[145,7,145,8],[142,9,142,10],[141,9,141,10],[141,3,141,4],[144,3,144,4],[144,5,144,6],[130,9,130,10],[129,7,129,8],[129,5,129,6],[132,5,132,6],[131,7,131,8],[128,5,128,6],[131,9,131,10],[130,7,130,8],[143,9,143,10],[141,7,141,8],[132,7,132,8],[127,5,127,6],[125,5,125,6],[120,9,120,10],[117,5,117,6],[131,3,131,4],[128,9,128,10],[128,11,128,12],[127,9,127,10],[126,9,126,10],[127,11,127,12],[126,11,126,12],[128,7,128,8],[129,9,129,10],[117,11,117,12],[118,7,118,8],[119,7,119,8],[119,5,119,6],[120,7,120,8],[118,5,118,6],[120,5,120,6],[118,9,118,10],[118,11,118,12],[130,5,130,6],[131,5,131,6],[111,5,111,6],[109,3,109,4],[110,3,110,4],[113,13,113,15],[112,13,112,15],[114,13,114,15],[116,11,116,12],[109,11,109,12],[109,5,109,6],[110,5,110,6],[115,5,115,6],[114,7,114,8],[113,5,113,6],[115,7,115,8],[113,7,113,8],[111,3,111,4],[116,3,116,4],[116,5,116,6],[114,5,114,6],[112,3,112,4],[112,5,112,6],[116,9,116,10],[116,13,116,15],[115,13,115,15],[123,1,123,2],[115,1,115,2],[116,1,116,2],[113,3,113,4],[114,3,114,4],[115,3,115,4],[117,3,117,4],[122,1,122,2],[117,1,117,2],[118,1,118,2],[119,1,119,2],[119,3,119,4],[118,3,118,4],[121,3,121,4],[121,17,121,19],[121,5,121,6],[121,7,121,8],[126,5,126,6],[126,7,126,8],[123,5,123,6],[123,7,123,8],[125,7,125,8],[124,5,124,6],[124,7,124,8],[122,5,122,6],[122,7,122,8],[122,9,122,10],[122,11,122,12],[123,9,123,10],[123,11,123,12],[125,9,125,10],[124,11,124,12],[124,9,124,10],[125,11,125,12],[122,13,122,15],[123,13,123,15],[123,17,123,19],[121,13,121,15],[109,1,109,2],[131,1,131,2],[127,1,127,2],[128,1,128,2],[125,1,125,2],[129,1,129,2],[120,3,120,4],[123,3,123,4],[121,1,121,2],[120,1,120,2],[129,3,129,4],[130,1,130,2],[125,3,125,4],[126,1,126,2],[126,3,126,4],[130,3,130,4],[124,3,124,4],[127,3,127,4],[128,3,128,4],[124,1,124,2],[112,1,112,2],[114,1,114,2],[113,1,113,2],[122,3,122,4],[107,13,107,15],[119,17,119,19],[116,17,116,19],[111,13,111,15],[105,1,105,2],[106,1,106,2],[117,7,117,8],[115,9,115,10],[111,7,111,8],[110,7,110,8],[111,9,111,10],[110,9,110,10],[117,9,117,10],[107,1,107,2],[105,3,105,4],[108,1,108,2],[111,17,111,19],[112,17,112,19],[115,11,115,12],[113,11,113,12],[114,11,114,12],[111,11,111,12],[110,1,110,2],[111,1,111,2],[109,13,109,15],[110,13,110,15],[59,1,60,1],[47,1,48,1],[58,20,58,21],[102,11,102,12],[104,5,104,6],[102,9,102,10],[104,3,104,4],[102,3,102,4],[104,1,104,2],[102,17,102,19],[104,7,104,8],[104,9,104,10],[110,17,110,19],[110,11,110,12],[109,9,109,10],[105,11,105,12],[108,11,108,12],[108,9,108,10],[108,17,108,19],[108,13,108,15],[109,17,109,19],[109,7,109,8],[0,1,0,23],[6,2,6,23],[12,2,12,23],[19,2,19,23],[7,16,7,18],[8,16,8,18],[9,16,9,18],[1,22,1,23],[1,8,1,10],[14,3,14,11],[1,11,1,12],[1,13,1,21],[2,8,2,21],[3,1,4,7],[3,10,3,21],[3,8,3,9],[14,18,14,19],[16,18,16,19],[132,1,132,2],[141,1,141,2],[134,1,134,2],[140,1,140,2],[139,1,139,2],[137,5,137,6],[139,3,139,4],[139,5,139,6],[134,3,134,4],[135,1,135,2],[136,3,136,4],[135,3,135,4],[135,5,135,6],[132,3,132,4],[136,5,136,6],[133,3,133,4],[133,5,133,6],[21,13,21,15],[22,17,22,19],[149,1,149,2],[133,7,133,8],[134,7,134,8],[137,7,137,8],[138,7,138,8],[145,1,145,2],[134,5,134,6],[148,1,148,2],[146,5,146,6],[142,5,142,6],[147,1,147,2],[144,1,144,2],[145,3,145,4],[138,1,138,2],[137,1,137,2],[136,1,136,2],[146,1,146,2],[142,1,142,2],[133,1,133,2],[143,1,143,2],[138,5,138,6],[145,5,145,6],[36,17,36,19],[35,17,35,19],[34,17,34,19],[4,25,4,26],[34,13,34,15],[33,13,33,15],[33,17,33,19],[24,13,24,15],[15,18,15,19],[28,17,28,19],[4,8,4,21],[28,13,28,15],[27,17,27,19],[13,16,13,17],[24,17,24,19],[31,17,31,19],[29,13,29,15],[29,17,29,19],[27,13,27,15],[26,2,26,23],[14,25,14,26],[22,13,22,15],[20,13,20,15],[20,17,20,19],[23,13,23,15],[23,17,23,19],[23,27,23,28],[33,31,33,32],[22,29,22,30],[23,29,23,30],[23,31,23,32],[29,31,29,32],[31,31,31,32],[33,27,33,28],[33,29,33,30],[24,27,24,28],[30,13,30,15],[31,13,31,15],[32,27,32,28],[32,29,32,30],[32,13,32,15],[32,17,32,19],[108,7,108,8],[105,7,105,8],[54,2,54,23],[62,2,62,23],[82,2,82,23],[103,2,103,23],[106,17,106,19],[108,5,108,6],[107,17,107,19],[104,17,104,19],[105,17,105,19],[102,5,102,6],[106,13,106,15],[106,11,106,12],[106,7,106,8],[104,11,104,12],[105,5,105,6],[102,7,102,8],[105,9,105,10],[106,9,106,10],[106,3,106,4],[107,3,107,4],[106,5,106,6],[108,3,108,4],[107,5,107,6],[46,2,46,23],[35,13,35,15],[46,31,46,32],[46,27,46,28],[41,31,41,32],[45,27,45,28],[42,27,42,28],[41,29,41,30],[39,27,39,28],[36,27,36,28],[35,27,35,28],[44,13,44,15],[36,13,36,15],[36,31,36,32],[35,31,35,32],[40,31,40,32],[38,2,38,23],[107,30,107,31],[39,31,39,32],[40,29,40,30],[42,29,42,30],[107,32,107,34],[45,29,45,30],[44,31,44,32],[45,31,45,32],[106,32,106,34],[106,30,106,31],[39,29,39,30],[43,31,43,32],[42,31,42,32],[46,29,46,30],[20,27,20,28],[32,31,32,32],[34,29,34,30],[34,31,34,32],[43,27,43,28],[35,29,35,30],[41,27,41,28],[36,29,36,30],[43,29,43,30],[40,27,40,28],[34,27,34,28],[21,17,21,19],[24,29,24,30],[30,27,30,28],[31,27,31,28],[24,31,24,32],[20,29,20,30],[20,31,20,32],[21,27,21,28],[21,29,21,30],[29,29,29,30],[29,27,29,28],[30,29,30,30],[31,29,31,30],[22,31,22,32],[30,31,30,32],[21,31,21,32],[30,17,30,19],[22,27,22,28]]}
[null,"Income Over Feed Supplement Cost (IOFSC)®",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corn",56,{"$f":"AJ1*0.454","v":25.423999999999999}]
[null,null,null,null,null,null,null,null,"Overwrite",null,null,"yellow",null,"cells and make appropriate selections.",null,null,null,null,null,null,null,null,"Units",null,null,null,null,null,null,null,null,null,null,null,"Barley",48,{"$f":"AJ2*0.454","v":21.792000000000002}]
[null,null,null,null,null,null,null,null,"Click on blue button to optimize IOFSC: results appear in",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheat",60,{"$f":"AJ3*0.454","v":27.240000000000002}]
[null,"V.E. Cabrera, R.D. Shaver, and M.A. Wattiaux",null,null,null,null,null,null,"blue",null,"cells. Click on red button to substitute between"]
[null,null,null,null,null,null,null,null,"feed supplements; results appear in figures and table.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUP(%)","RDP(%)","CP(%)",null,"A","B","C","Kd","Kp"]
[null,1,"Calculate Dry Matter Intake (DMI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"35-Corn Silage-CoSi",null,null,null,null,null,{"$f":"AK7*(AN7*(AQ7/(AP7+AQ7))+AO7)","v":3.0932853512844343E-2},{"$f":"AK7*(AM7+AN7*(AP7/(AP7+AQ7)))","v":5.6803146487155648E-2},8.7999999999999995E-2,null,0.51,0.30199999999999999,0.185,4.4000000000000004,{"$f":"3.054+0.614*(DMI/BW)*100","v":5.407344070289577}]
[null,1.1000000000000001,null,"Milk Producion (MP)",null,null,null,null,null,null,null,null,null,null,null,"lb/cow/day",80,null,null,null,null,null,null,null,null,null,null,2,"83-Alf. Silage-AlSi",null,null,null,null,null,3.9947544799323123E-2,0.17905245520067686,0.219,null,0.57299999999999995,0.35299999999999998,7.3999999999999996E-2,12.2,{"$f":"3.054+0.614*(DMI/BW)*100","v":5.407344070289577}]
[null,1.2,null,"Body Weight (BW)",null,null,null,null,null,null,null,null,null,null,null,"lb/cow",1400,null,null,null,null,null,null,null,null,null,null,3,"74-Mx. Silage-MxSi",null,null,null,null,null,{"$f":"AK9*(AN9*(AQ9/(AP9+AQ9))+AO9)","v":3.6858226078018176E-2},0.15314177392198183,0.19,null,0.58099999999999996,0.34200000000000003,7.6999999999999999E-2,10.4,{"$f":"3.054+0.614*(DMI/BW)*100","v":5.407344070289577}]
[null,1.3,null,"Days in Milk (DIM)",null,null,null,null,null,null,null,null,null,null,null,"day",100,null,null,null,null,null,null,100,null,null,null,4,"77-Hay Forage-",null,null,null,null,null,3.4749887037041439E-2,0.16725011296295855,0.20200000000000001,null,0.41899999999999998,0.49199999999999999,8.8999999999999996E-2,16.600000000000001,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Q14)-0.017*0.396","v":3.3701271499946048}]
[null,1.4,null,"Dry Matter Intake (DMI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lb/cow/day",{"$f":"((0.372*(FCM*0.454)+0.0968*(BW*0.454)^0.75*(1-EXP(1)^(-0.192*((DIM/7)+3.67))))/0.454)*(X10/100)","v":53.659311048948027},null,null,null,5,"82-Silage Inmature<40% NDF-Si40",null,null,null,null,null,3.5391952617091368E-2,0.19660804738290863,0.23200000000000001,null,0.61599999999999999,0.29099999999999998,9.2999999999999999E-2,13.1,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Forage)-0.017*0.367","v":3.3706201499946049}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"83-Silage Inmature 40-46% NDF-Si43",null,null,null,null,null,3.2936585711316975E-2,0.186063414288683,0.219,null,0.57299999999999995,0.35299999999999998,7.3999999999999996E-2,12.2,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Forage)-0.017*0.432","v":3.369515149994605}]
[null,2,"Set the Sources and Proportion of Forage in the Diet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"84-Silage Inmature>46% NDF-Si50",null,null,null,null,null,4.6471695381710809E-2,0.1565283046182892,0.20300000000000001,null,0.52900000000000003,0.34399999999999997,0.127,8,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Forage)-0.017*0.5","v":3.3683591499946046}]
[null,2.1,null,"Proportion of Forage in Diet",null,null,null,null,null,null,null,"---------",null,null,null,"% of Diet",0.5,null,null,null,null,null,null,{"$f":"Forage*DMI","v":26.829655524474013}]
[null,2.2000000000000002,null,"Corn Silage",null,null,null,null,null,null,null,null,"-----------",null,null,null,null,"% of Forage",0.5,null,null,null,null,null,null,{"$f":"SUM(S15:T17)","v":1},null,1,{"$f":"VLOOKUP($AB15,$AB$7:$AQ$13,$AC$5,)","v":"35-Corn Silage-CoSi"},null,null,null,null,null,{"$f":"VLOOKUP($AB15,$AB$7:$AQ$13,AI$5,TRUE)","v":3.0932853512844343E-2},5.6803146487155648E-2,8.7999999999999995E-2,null,{"$f":"VLOOKUP($AB15,$AB$7:$AQ$13,AM$5,TRUE)","v":0.51},0.30199999999999999,0.185,4.4000000000000004,5.407344070289577]
[null,2.2999999999999998,null,"Alfalfa",null,null,null,null,null,null,null,null,"-----------",null,null,null,null,"% of Forage",0.5,null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP($AB16,$AB$7:$AQ$13,$AC$5,)","v":"83-Alf. Silage-AlSi"},null,null,null,null,null,3.9947544799323123E-2,0.17905245520067686,0.219,null,0.57299999999999995,0.35299999999999998,7.3999999999999996E-2,12.2,5.407344070289577]
[null,2.4,null,{"$f":"AC17","v":"35-Corn Silage-CoSi"},null,null,null,null,null,null,null,null,"-----------",null,null,null,null,"% of Forage",0,null,null,null,null,null,null,null,null,1,"35-Corn Silage-CoSi",null,null,null,null,null,3.1699999999999999E-2,5.6100000000000004E-2,{"$f":"SUM(AI17:AJ17)","v":8.7800000000000003E-2},null,0.51,0.30199999999999999,0.185,4.4000000000000004,{"$f":"3.054+0.614*(DMI/BW)*100","v":5.407344070289577}]
[null,2.4,null,"Crude Protein in Diet Provided by Forage",null,null,null,null,null,null,null,null,null,null,null,"----------------------------",null,null,null,null,null,null,"lb/cow/day",{"$f":"DMI*CP_F","v":4.118352123006761},null,null,null,null,null,null,null,null,null,null,{"$f":"$Q$14*SUMPRODUCT($S$15:$S$17,AI15:AI17)","v":1.7720099578041867E-2},{"$f":"$Q$14*SUMPRODUCT($S$15:$S$17,AJ15:AJ17)","v":5.8963900421958128E-2},{"$f":"$Q$14*SUMPRODUCT($S$15:$S$17,AK15:AK17)","v":7.6749999999999999E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V42-AI18","v":4.7279900421958135E-2},{"$f":"V43-AJ18","v":5.6036099578041877E-2},{"$f":"V44-AK17","v":9.219999999999999E-2}]
[null,3,"Set Source of Energy Supplements and Prices"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Price",null,null,null,"Current ",null,null,null,"Upper ",null,"Optimal",null,null,null,"RUP(%)",null,"RDP(%)",null,"CP(%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"($/bu)",null,null,null,"Diet (lb)",null,null,null,"Limit (lb)",null,"(lb)"]
[null,3.1,null,"27-Corn-CGG",null,null,null,null,null,null,null,null,null,3.54,null,null,null,20.88,null,null,null,25,null,17.624403319359693,null,15,null,{"$f":"$X23/DMI*$AI23","v":1.4411367017989859E-2},null,{"$f":"$X23/DMI*$AJ23","v":1.6462937546013485E-2},null,{"$f":"$X23/DMI*$AK23","v":3.0874304564003346E-2},null,null,{"$f":"AK23*(AN23*(AQ23/(AP23+AQ23))+AO23)","v":4.3876891117750651E-2},{"$f":"AK23*(AM23+AN23*(AP23/(AP23+AQ23)))","v":5.0123108882249343E-2},9.4E-2,null,0.23899999999999999,0.72499999999999998,3.5999999999999997E-2,4.9000000000000004,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":7.1741109065931106}]
[null,3.2,null,"8-Barley-BGR",null,null,null,null,null,null,null,null,null,4.8,null,null,null,null,null,null,null,0,null,0,null,0,null,{"$f":"$X24/DMI*$AI24","v":0},null,{"$f":"$X24/DMI*$AJ24","v":0},null,{"$f":"$X24/DMI*$AK24","v":0},null,null,{"$f":"AK24*(AN24*(AQ24/(AP24+AQ24))+AO24)","v":2.8888104817103844E-2},{"$f":"AK24*(AM24+AN24*(AP24/(AP24+AQ24)))","v":9.5111895182896145E-2},0.124,null,0.30199999999999999,0.61199999999999999,8.5999999999999993E-2,22.7,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":7.1741109065931106}]
[null,3.3,null,"116-Wheat-WGR",null,null,null,null,null,null,null,null,null,7.4,null,null,null,null,null,null,null,0,null,0,null,10,null,{"$f":"$X25/DMI*$AI25","v":0},null,{"$f":"$X25/DMI*$AJ25","v":0},null,{"$f":"$X25/DMI*$AK25","v":0},null,null,{"$f":"AK25*(AN25*(AQ25/(AP25+AQ25))+AO25)","v":3.6608699186979309E-2},{"$f":"AK25*(AM25+AN25*(AP25/(AP25+AQ25)))","v":0.10539130081302069},0.14199999999999999,null,0.27100000000000002,0.65100000000000002,7.8E-2,18.8,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":7.1741109065931106}]
[]
[null,4,"Set the Source of Protein, Byproduct Supplements and Prices"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Price",null,null,null,"Current",null,null,null,"Upper ",null,"Optimal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"($/ton)",null,null,null,"Diet (lb)",null,null,null,"Limit (lb)",null,"(lb)"]
[null,4.0999999999999996,null,"106-Soybean Meal-SBM",null,null,null,null,null,null,null,null,null,300,null,null,null,5.95,null,null,null,25,null,4.20525220511432,null,15,null,{"$f":"$X30/DMI*$AI30","v":1.327384079143888E-2},null,{"$f":"$X30/DMI*$AJ30","v":2.5832528808384464E-2},null,{"$f":"$X30/DMI*$AK30","v":3.9106369599823339E-2},null,null,{"$f":"AK30*(AN30*(AQ30/(AP30+AQ30))+AO30)","v":0.16937513307187488},{"$f":"AK30*(AM30+AN30*(AP30/(AP30+AQ30)))","v":0.32962486692812515},0.499,null,0.22500000000000001,0.76800000000000002,7.0000000000000001E-3,9.4,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":7.1741109065931106}]
[null,4.2,null,"25-Corn Gluten Meal-CGM",null,null,null,null,null,null,null,null,null,550,null,null,null,null,null,null,null,0,null,0,null,2,null,0,null,0,null,0,null,null,0.48121121050321547,0.16878878949678455,0.65,null,3.9E-2,0.90900000000000003,5.2000000000000005E-2,2.2999999999999998,7.1741109065931106]
[null,4.3,null,"24-Corn Gluten Feed-CGF",null,null,null,null,null,null,null,null,null,160,null,null,null,null,null,null,null,0,null,0,null,10,null,0,null,0,null,0,null,null,7.0534418654557854E-2,0.16746558134544215,0.23799999999999999,null,0.48,0.43200000000000005,8.8000000000000009E-2,7.7,7.1741109065931106]
[null,4.4000000000000004,null,"23-Corn Distiller Grains-CDG",null,null,null,null,null,null,null,null,null,140,null,null,null,null,null,null,null,5,null,5,null,10,null,1.3933967343727923E-2,null,1.3740633223643932E-2,null,2.7674600567371855E-2,null,null,0.14953741756859615,0.14746258243140384,0.29699999999999999,null,0.28499999999999998,0.63300000000000001,8.199999999999999E-2,3.6,7.1741109065931106]
[null,4.5,null,"109-Soybean Whole Roasted- HSB",null,null,null,null,null,null,null,null,null,318,null,null,null,null,null,null,null,0,null,0,null,7,null,0,null,0,null,0,null,null,0.16654672635148643,0.26345327364851362,0.43,null,0.17800000000000002,0.77,5.2000000000000005E-2,9.3000000000000007,7.1741109065931106]
[null,4.5999999999999996,null,"104-Soybean Meal Expellers-SBMx",null,null,null,null,null,null,null,null,null,402,null,null,null,null,null,null,null,0,null,0,null,15,null,0,null,0,null,0,null,null,0.3167534842567723,0.14624651574322767,0.46300000000000002,null,8.6999999999999994E-2,0.91299999999999992,0,2.4,7.1741109065931106]
[null,4.7,null,"14-Blood Meal Ring Dried-BMRD",null,null,null,null,null,null,null,null,null,900,null,null,null,null,null,null,null,0,null,0,null,1,null,0,null,0,null,0,null,null,0.73676662288130035,0.21823337711869945,0.95499999999999996,null,0.10099999999999999,0.60899999999999999,0.28999999999999998,1.9,7.1741109065931106]
[null,4.8,null,"Urea",null,null,null,null,null,null,null,null,null,635,null,null,null,null,null,null,null,0,null,0,null,1,null,0,null,0,null,0,null,null,0,2.81,2.81]
[]
[null,5,"Set the Upper Limits for RUP and RDP, and Milk Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper ",null,"Amount",null,null,null,"FCM",null,{"$f":"MP*0.4+MP*0.035*15","v":74}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limit",null,"in Diet",null,null,null,"DMIf",null,{"$f":"SUM(grains,protein)+DMI*Forage","v":53.659311048948027}]
[null,5.0999999999999996,null,"RUP",null,"Rumen Undegradable Protein",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of Diet DM",6.5000000000000002E-2,null,{"$f":"SUM(AB30:AC37,AB23:AC25,AI18)","v":5.933927473119853E-2}]
[null,5.2,null,"RDP",null,"Rumen Degradable Protein",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of Diet DM",0.115,null,{"$f":"SUM(AD30:AE37,AD23:AE25,AJ18)","v":0.11500000000000002}]
[null,5.3,null,"CP",null,"Crude Protein",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of Diet DM",{"$f":"SUM(V42:V43)","v":0.18},null,{"$f":"SUM(AF30:AG37,AF23:AG25,CP_F)","v":0.17440527473119855}]
[null,5.4,null,"Milk Price",null,null,null,null,null,null,null,null,"$/cwt",9.4]
[]
[null,6,"Perform Optimization, Maximize IOFSC"]
[null,6.1,null,"Click the button to  maximize the Income"]
[null,null,null,"Over Feed Supplement Cost (IOFSC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current ",null,"Optimal"]
[null,6.2,null,"Expected Milk Producion (E-MP)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lb/cow/day",78.839097450705864,null,{"$f":"(-55.61+1.15*(AD41*0.454)+8.79*X43*100-0.36*(X43*100)^2+1.85*X42*100)/0.454","v":81.185665471205922}]
[null,6.3,null,"Maximum Income Over Feed Supplement Cost (IOFSC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/cow/day",5.1984608746520662,null,{"$f":"(fMP*MPrice/100)-(SUMPRODUCT(protein/2000,N30:N37)+(N23*X23/56+N24*X24/48+N25*X25/60))","v":5.5365506565524001}]
[]
[]
[null,7,"Perform a Substitution Analysis"]
[null,7.1,null,"Select an ENERGY supplement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,7.2,null,"Select a PROTEIN/BYPRODUCT supplement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"7.3.a",null,"Select one of the following to change its price",null,null,null,null,null,null,null,null,null,null,null,null,"-------------",null,null,null,null,null,null,null,null,null,2]
[null,"7.3.b",null,"Define the upper (↑) and lower (↓) limit in the price ----",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑",0.51,null,"↓",0.5]
[null,7.4,null,"Click the button to update the results "]
[null,null,null,"of sections 8, 9, and 10"]
[]
[null,8,"IOFSC and Milk Production when Substituting Energy for Protein/Byproducts"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,9,"Change in IOFSC at Upper and Lower Selected Prices"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"X23","v":17.624403319359693},null,{"$f":"X30","v":4.20525220511432},null,{"$f":"X42","v":5.933927473119853E-2},null,{"$f":"X43","v":0.11500000000000002},null,{"$f":"X44","v":0.17440527473119855},null,{"$f":"X51","v":81.185665471205922},null,null,null,null,null,{"$f":"X52","v":5.5365506565524001},null,null,null,{"$f":"X52","v":5.5365506565524001},null,{"$f":"X52","v":5.5365506565524001}]
[null,10,"IOFSC and Milk Production when Substituting Feed Supplements and Changing Selected Prices"]
[null,"Energy",null,"Protein",null,"RUP",null,"RDP",null,"CP",null,"Milk",null,null,null,null,null,"IOFSCbase",null,null,null,"IOFSCupper",null,"IOFSClower"]
[null,23.17106613477301,null,3.6585893897010031,null,4.8215243451971118E-2,null,0.10308239291166524,null,0.15136363636363637,null,74.187759216745391,null,null,null,null,null,4.9601185629707656,null,null,null,5.2400006512828927,null,4.6857243587431903]
[null,22.764556202584011,null,4.0650993218900036,null,4.9165987709199332E-2,null,0.10519983047261885,null,0.1544318181818182,null,75.177685940541224,null,null,null,null,null,5.017892420178315,null,null,null,5.3288725183028998,null,4.7130099710365645]
[null,22.358046270395008,null,4.471609254079004,null,5.0116731966427547E-2,null,0.10731726803357246,null,0.15750000000000003,null,76.096508036282785,null,null,null,null,null,5.0689824423487604,null,null,null,5.4110605502858045,null,4.7336117482928355]
[null,21.951536338206008,null,4.8781191862680044,null,5.1067476223655761E-2,null,0.10943470559452606,null,0.16056818181818183,null,76.944225503969903,null,null,null,null,null,5.1133886294820909,null,null,null,5.4865647472315935,null,4.7475296905119908]
[null,21.545026406017008,null,5.2846291184570049,null,5.2018220480883975E-2,null,0.11155214315547968,null,0.16363636363636364,null,77.720838343602793,null,null,null,null,null,5.1511109815783236,null,null,null,5.5553851091402837,null,4.7547637976940473]
[null,21.138516473828009,null,5.6911390506460053,null,5.296896473811219E-2,null,0.11366958071643327,null,0.16670454545454549,null,78.426346555181297,null,null,null,null,null,5.1821494986374432,null,null,null,5.6175216360118618,null,4.7553140698389926]
[null,20.732006541639009,null,6.0976489828350058,null,5.3919708995340411E-2,null,0.11578701827738688,null,0.1697727272727273,null,79.060750138705444,null,null,null,null,null,5.2065041806594525,null,null,null,5.6729743278463305,null,4.7491805069468267]
[null,20.325496609450006,null,6.5041589150240062,null,5.4870453252568618E-2,null,0.1179044558383405,null,0.1728409090909091,null,79.624049094175305,null,null,null,null,null,5.2241750276443604,null,null,null,5.7217431846436959,null,4.7363631090175593]
[null,19.918986677261007,null,6.9106688472130067,null,5.5821197509796833E-2,null,0.12002189339929409,null,0.1759090909090909,null,80.116243421590852,null,null,null,null,null,5.2351620395921614,null,null,null,5.7638282064039563,null,4.7168618760511851]
[null,19.512476745072007,null,7.3171787794020071,null,5.6771941767025054E-2,null,0.12213933096024771,null,0.17897727272727276,null,80.537333120951985,null,null,null,null,null,5.2394652165028486,null,null,null,5.799229393127102,null,4.6906768080476979]

{"sheet":"IOFSC-M","index":1,"n_rows":118,"n_cols":43,"rows_kept":118,"cut":false,"hidden":true,"merged":[[41,31,41,32],[20,27,20,28],[20,29,20,30],[20,31,20,32],[21,27,21,28],[21,29,21,30],[21,31,21,32],[36,27,36,28],[41,27,41,28],[40,27,40,28],[29,27,29,28],[30,27,30,28],[31,27,31,28],[32,27,32,28],[30,29,30,30],[33,31,33,32],[33,29,33,30],[22,27,22,28],[23,27,23,28],[23,29,23,30],[23,31,23,32],[24,31,24,32],[39,31,39,32],[40,31,40,32],[35,29,35,30],[35,31,35,32],[39,29,39,30],[36,29,36,30],[36,31,36,32],[30,31,30,32],[29,29,29,30],[34,31,34,32],[32,29,32,30],[32,31,32,32],[31,31,31,32],[29,31,29,32],[22,31,22,32],[22,29,22,30],[109,3,109,4],[106,9,106,10],[105,11,105,12],[104,9,104,10],[108,9,108,10],[107,5,107,6],[105,7,105,8],[105,9,105,10],[106,3,106,4],[105,3,105,4],[104,3,104,4],[105,5,105,6],[108,7,108,8],[108,30,108,31],[109,30,109,31],[24,27,24,28],[24,29,24,30],[56,19,56,23],[102,17,102,19],[42,27,42,28],[43,27,43,28],[31,29,31,30],[107,32,107,34],[45,29,45,30],[107,30,107,31],[46,29,46,30],[106,32,106,34],[106,30,106,31],[46,31,46,32],[111,30,111,31],[110,32,110,34],[111,32,111,34],[121,13,121,15],[123,11,123,12],[13,16,13,17],[15,18,15,19],[21,17,21,19],[34,27,34,28],[39,27,39,28],[35,27,35,28],[34,29,34,30],[40,29,40,30],[41,29,41,30],[45,27,45,28],[46,27,46,28],[33,27,33,28],[113,30,113,31],[110,30,110,31],[42,29,42,30],[42,31,42,32],[43,29,43,30],[44,31,44,32],[45,31,45,32],[43,31,43,32],[108,32,108,34],[109,32,109,34],[4,25,4,26],[29,13,29,15],[29,17,29,19],[28,17,28,19],[22,17,22,19],[27,13,27,15],[28,13,28,15],[8,16,8,18],[23,13,23,15],[9,16,9,18],[21,13,21,15],[20,17,20,19],[14,25,14,26],[138,3,138,4],[140,3,140,4],[140,1,140,2],[142,1,142,2],[143,1,143,2],[141,1,141,2],[138,1,138,2],[146,5,146,6],[145,3,145,4],[139,5,139,6],[105,17,105,19],[104,17,104,19],[107,17,107,19],[107,9,107,10],[109,13,109,15],[145,1,145,2],[146,1,146,2],[139,1,139,2],[144,1,144,2],[113,7,113,8],[125,9,125,10],[136,3,136,4],[133,1,133,2],[135,1,135,2],[137,1,137,2],[132,1,132,2],[136,1,136,2],[132,3,132,4],[133,3,133,4],[134,1,134,2],[135,3,135,4],[122,3,122,4],[122,5,122,6],[138,5,138,6],[108,17,108,19],[114,13,114,15],[109,17,109,19],[113,17,113,19],[112,13,112,15],[113,9,113,10],[111,9,111,10],[109,9,109,10],[109,11,109,12],[112,9,112,10],[110,11,110,12],[108,13,108,15],[108,11,108,12],[111,17,111,19],[110,13,110,15],[114,9,114,10],[0,1,0,23],[6,2,6,23],[12,2,12,23],[19,2,19,23],[7,16,7,18],[16,18,16,19],[14,3,14,11],[107,11,107,12],[110,9,110,10],[1,22,1,23],[1,8,1,10],[1,11,1,12],[106,13,106,15],[106,17,106,19],[30,17,30,19],[31,17,31,19],[36,17,36,19],[35,17,35,19],[104,11,104,12],[36,13,36,15],[31,13,31,15],[30,13,30,15],[35,13,35,15],[62,2,62,23],[1,13,1,21],[2,8,2,21],[27,17,27,19],[32,17,32,19],[59,1,60,1],[47,1,48,1],[44,13,44,15],[46,2,46,23],[55,19,55,23],[22,13,22,15],[20,13,20,15],[24,17,24,19],[34,17,34,19],[58,20,58,21],[33,17,33,19],[34,13,34,15],[24,13,24,15],[32,13,32,15],[33,13,33,15],[38,2,38,23],[54,2,54,23],[14,18,14,19],[23,17,23,19],[102,3,102,4],[102,7,102,8],[102,9,102,10],[102,5,102,6],[106,11,106,12],[104,5,104,6],[82,2,82,23],[103,2,103,23],[116,9,116,10],[106,7,106,8],[109,1,109,2],[115,17,115,19],[113,3,113,4],[114,5,114,6],[114,3,114,4],[111,3,111,4],[110,3,110,4],[111,1,111,2],[110,1,110,2],[115,3,115,4],[113,1,113,2],[104,7,104,8],[112,17,112,19],[110,17,110,19],[107,7,107,8],[108,5,108,6],[114,11,114,12],[119,5,119,6],[116,7,116,8],[118,13,118,15],[116,13,116,15],[107,13,107,15],[116,11,116,12],[113,11,113,12],[118,9,118,10],[117,7,117,8],[115,9,115,10],[112,11,112,12],[116,5,116,6],[114,7,114,8],[112,7,112,8],[110,5,110,6],[111,7,111,8],[110,7,110,8],[118,7,118,8],[118,11,118,12],[119,13,119,15],[117,5,117,6],[126,1,126,2],[123,5,123,6],[4,8,4,21],[123,3,123,4],[113,13,113,15],[111,13,111,15],[115,11,115,12],[124,5,124,6],[104,1,104,2],[105,1,105,2],[106,1,106,2],[107,1,107,2],[108,1,108,2],[113,5,113,6],[115,7,115,8],[111,5,111,6],[106,5,106,6],[107,3,107,4],[109,7,109,8],[112,5,112,6],[108,3,108,4],[111,11,111,12],[109,5,109,6],[117,9,117,10],[120,1,120,2],[117,1,117,2],[119,3,119,4],[119,1,119,2],[118,1,118,2],[116,3,116,4],[132,5,132,6],[133,5,133,6],[135,5,135,6],[122,1,122,2],[125,1,125,2],[120,3,120,4],[123,1,123,2],[121,3,121,4],[124,3,124,4],[125,5,125,6],[124,1,124,2],[129,1,129,2],[129,3,129,4],[126,3,126,4],[127,5,127,6],[126,5,126,6],[129,5,129,6],[125,3,125,4],[127,1,127,2],[130,3,130,4],[127,7,127,8],[127,9,127,10],[128,9,128,10],[131,9,131,10],[130,13,130,15],[128,13,128,15],[127,13,127,15],[131,13,131,15],[129,13,129,15],[130,1,130,2],[129,9,129,10],[128,7,128,8],[130,5,130,6],[128,5,128,6],[129,7,129,8],[130,7,130,8],[128,1,128,2],[128,3,128,4],[135,17,135,19],[133,11,133,12],[132,13,132,15],[132,17,132,19],[133,7,133,8],[135,7,135,8],[134,17,134,19],[133,17,133,19],[131,1,131,2],[131,5,131,6],[131,3,131,4],[131,7,131,8],[131,17,131,19],[136,13,136,15],[134,7,134,8],[136,7,136,8],[132,11,132,12],[139,3,139,4],[140,7,140,8],[141,11,141,12],[141,7,141,8],[134,13,134,15],[134,11,134,12],[134,9,134,10],[134,5,134,6],[135,9,135,10],[140,5,140,6],[139,13,139,15],[135,13,135,15],[133,13,133,15],[133,9,133,10],[134,3,134,4],[137,7,137,8],[137,5,137,6],[136,5,136,6],[138,11,138,12],[132,7,132,8],[137,9,137,10],[135,11,135,12],[148,5,148,6],[147,7,147,8],[143,3,143,4],[143,5,143,6],[142,5,142,6],[142,11,142,12],[137,11,137,12],[137,3,137,4],[146,3,146,4],[145,9,145,10],[144,9,144,10],[145,7,145,8],[145,5,145,6],[138,7,138,8],[144,11,144,12],[141,3,141,4],[142,3,142,4],[141,5,141,6],[144,3,144,4],[144,5,144,6],[146,11,146,12],[136,9,136,10],[146,7,146,8],[146,17,146,19],[145,13,145,15],[146,13,146,15],[148,13,148,15],[146,9,146,10],[145,11,145,12],[145,17,145,19],[139,11,139,12],[139,7,139,8],[144,7,144,8],[142,7,142,8],[143,7,143,8],[143,9,143,10],[143,11,143,12],[142,17,142,19],[142,9,142,10],[139,9,139,10],[141,17,141,19],[144,13,144,15],[141,9,141,10],[102,11,102,12],[26,2,26,23],[127,11,127,12],[112,1,112,2],[112,3,112,4],[114,1,114,2],[121,1,121,2],[126,13,126,15],[126,11,126,12],[117,13,117,15],[125,11,125,12],[122,13,122,15],[124,11,124,12],[124,13,124,15],[116,1,116,2],[115,5,115,6],[115,1,115,2],[120,17,120,19],[127,17,127,19],[126,17,126,19],[126,7,126,8],[125,7,125,8],[124,7,124,8],[124,17,124,19],[138,9,138,10],[130,9,130,10],[129,11,129,12],[130,11,130,12],[140,9,140,10],[136,11,136,12],[132,9,132,10],[119,17,119,19],[140,17,140,19],[136,17,136,19],[137,17,137,19],[138,17,138,19],[139,17,139,19],[140,11,140,12],[123,9,123,10],[124,9,124,10],[122,9,122,10],[125,13,125,15],[123,17,123,19],[122,17,122,19],[126,9,126,10],[123,13,123,15],[122,11,122,12],[131,11,131,12],[125,17,125,19],[128,11,128,12],[115,32,115,34],[114,32,114,34],[114,17,114,19],[115,13,115,15],[114,30,114,31],[115,30,115,31],[116,30,116,31],[117,30,117,31],[124,32,124,34],[125,32,125,34],[120,32,120,34],[121,32,121,34],[122,32,122,34],[123,32,123,34],[122,30,122,31],[123,30,123,31],[121,30,121,31],[117,11,117,12],[119,11,119,12],[124,30,124,31],[125,30,125,31],[120,30,120,31],[118,3,118,4],[116,17,116,19],[120,5,120,6],[121,5,121,6],[130,17,130,19],[128,17,128,19],[129,17,129,19],[121,7,121,8],[127,3,127,4],[119,7,119,8],[120,13,120,15],[119,9,119,10],[120,7,120,8],[120,11,120,12],[120,9,120,10],[121,9,121,10],[121,11,121,12],[121,17,121,19],[118,17,118,19],[117,17,117,19],[117,3,117,4],[118,5,118,6],[122,7,122,8],[123,7,123,8],[118,30,118,31],[119,30,119,31],[119,32,119,34],[112,30,112,31],[118,32,118,34],[113,32,113,34],[116,32,116,34],[117,32,117,34],[112,32,112,34],[137,13,137,15],[138,13,138,15],[140,13,140,15],[141,13,141,15],[143,13,143,15],[143,17,143,19],[144,17,144,19],[142,13,142,15],[150,1,150,2],[150,3,150,4],[150,5,150,6],[150,7,150,8],[147,17,147,19],[148,17,148,19],[149,13,149,15],[149,7,149,8],[148,7,148,8],[147,13,147,15],[149,11,149,12],[148,3,148,4],[147,3,147,4],[149,9,149,10],[147,9,147,10],[148,9,148,10],[147,5,147,6],[149,1,149,2],[149,3,149,4],[150,13,150,15],[149,17,149,19],[150,9,150,10],[150,11,150,12],[149,5,149,6],[154,1,154,2],[153,1,153,2],[153,3,153,4],[153,5,153,6],[154,3,154,4],[154,5,154,6],[147,11,147,12],[148,11,148,12],[153,7,153,8],[148,1,148,2],[147,1,147,2],[150,17,150,19],[154,11,154,12],[154,17,154,19],[155,13,155,15],[153,17,153,19],[153,9,153,10],[153,11,153,12],[154,9,154,10],[156,5,156,6],[156,7,156,8],[154,7,154,8],[155,9,155,10],[155,11,155,12],[155,17,155,19],[157,5,157,6],[157,7,157,8],[158,9,158,10],[158,11,158,12],[155,5,155,6],[155,7,155,8],[157,1,157,2],[157,3,157,4],[156,1,156,2],[156,3,156,4],[158,1,158,2],[158,3,158,4],[158,5,158,6],[158,7,158,8],[155,1,155,2],[155,3,155,4],[157,17,157,19],[156,17,156,19],[157,13,157,15],[157,9,157,10],[157,11,157,12],[156,9,156,10],[156,11,156,12],[158,13,158,15],[158,17,158,19],[156,13,156,15],[159,1,159,2],[159,3,159,4],[159,5,159,6],[159,7,159,8],[159,13,159,15],[159,17,159,19],[159,9,159,10],[159,11,159,12],[161,1,161,2],[161,3,161,4],[161,5,161,6],[161,7,161,8],[160,9,160,10],[160,11,160,12],[160,1,160,2],[160,3,160,4],[160,5,160,6],[160,7,160,8],[160,13,160,15],[160,17,160,19],[162,13,162,15],[162,17,162,19],[161,13,161,15],[161,17,161,19],[161,9,161,10],[161,11,161,12],[164,1,164,2],[164,3,164,4],[162,9,162,10],[162,11,162,12],[162,5,162,6],[162,7,162,8],[162,1,162,2],[162,3,162,4],[163,1,163,2],[163,3,163,4],[163,5,163,6],[163,7,163,8],[163,13,163,15],[163,17,163,19],[165,13,165,15],[165,17,165,19],[163,9,163,10],[163,11,163,12],[164,13,164,15],[164,17,164,19],[164,9,164,10],[164,11,164,12],[164,5,164,6],[164,7,164,8],[165,9,165,10],[165,11,165,12],[165,1,165,2],[165,3,165,4],[166,1,166,2],[166,3,166,4],[168,1,168,2],[168,3,168,4],[166,13,166,15],[166,17,166,19],[165,5,165,6],[165,7,165,8],[166,9,166,10],[166,11,166,12],[166,5,166,6],[166,7,166,8],[167,13,167,15],[167,17,167,19],[167,9,167,10],[167,11,167,12],[167,1,167,2],[167,3,167,4],[168,5,168,6],[168,7,168,8],[167,5,167,6],[167,7,167,8],[170,13,170,15],[170,17,170,19],[168,13,168,15],[168,17,168,19],[169,13,169,15],[169,17,169,19],[168,9,168,10],[168,11,168,12],[170,9,170,10],[170,11,170,12],[171,9,171,10],[171,11,171,12],[170,5,170,6],[170,7,170,8],[169,1,169,2],[169,3,169,4],[169,5,169,6],[169,7,169,8],[170,1,170,2],[170,3,170,4],[171,5,171,6],[171,7,171,8],[171,1,171,2],[171,3,171,4],[169,9,169,10],[169,11,169,12],[175,9,175,10],[175,1,175,2],[175,3,175,4],[171,13,171,15],[171,17,171,19],[175,11,175,12],[174,9,174,10],[174,11,174,12],[173,5,173,6],[173,7,173,8],[173,9,173,10],[173,11,173,12],[175,13,175,15],[175,17,175,19],[173,13,173,15],[173,17,173,19],[174,13,174,15],[174,17,174,19],[175,5,175,6],[175,7,175,8],[172,13,172,15],[172,17,172,19],[172,5,172,6],[172,7,172,8],[172,9,172,10],[172,11,172,12],[174,1,174,2],[174,3,174,4],[174,5,174,6],[174,7,174,8],[173,1,173,2],[173,3,173,4],[172,1,172,2],[172,3,172,4],[176,5,176,6],[176,7,176,8],[177,1,177,2],[177,3,177,4],[176,1,176,2],[176,3,176,4],[178,13,178,15],[178,17,178,19],[178,5,178,6],[178,7,178,8],[177,5,177,6],[177,7,177,8],[178,9,178,10],[178,11,178,12],[176,13,176,15],[176,17,176,19],[177,13,177,15],[177,17,177,19],[176,9,176,10],[176,11,176,12],[177,9,177,10],[177,11,177,12],[178,1,178,2],[178,3,178,4],[180,17,180,19],[179,9,179,10],[179,11,179,12],[180,9,180,10],[180,11,180,12],[179,13,179,15],[179,17,179,19],[181,1,181,2],[181,3,181,4],[179,1,179,2],[179,3,179,4],[179,5,179,6],[179,7,179,8],[180,1,180,2],[180,3,180,4],[180,5,180,6],[180,7,180,8],[180,13,180,15],[182,1,182,2],[182,3,182,4],[182,5,182,6],[182,7,182,8],[181,5,181,6],[181,7,181,8],[181,13,181,15],[181,17,181,19],[182,9,182,10],[182,11,182,12],[181,9,181,10],[181,11,181,12],[182,13,182,15],[182,17,182,19],[183,13,183,15],[183,17,183,19],[183,1,183,2],[183,3,183,4],[183,5,183,6],[183,7,183,8],[183,9,183,10],[183,11,183,12],[186,13,186,15],[186,17,186,19],[184,13,184,15],[184,17,184,19],[185,13,185,15],[185,17,185,19],[184,1,184,2],[184,3,184,4],[186,5,186,6],[186,7,186,8],[185,1,185,2],[185,3,185,4],[185,5,185,6],[185,7,185,8],[184,5,184,6],[184,7,184,8],[184,9,184,10],[184,11,184,12],[187,13,187,15],[187,17,187,19],[186,9,186,10],[186,11,186,12],[187,9,187,10],[187,11,187,12],[185,9,185,10],[185,11,185,12],[189,1,189,2],[189,3,189,4],[186,1,186,2],[186,3,186,4],[187,1,187,2],[187,3,187,4],[187,5,187,6],[187,7,187,8],[188,1,188,2],[188,3,188,4],[188,5,188,6],[188,7,188,8],[188,13,188,15],[188,17,188,19],[189,9,189,10],[189,11,189,12],[188,9,188,10],[188,11,188,12],[189,13,189,15],[189,17,189,19],[192,5,192,6],[192,7,192,8],[191,13,191,15],[191,17,191,19],[189,5,189,6],[189,7,189,8],[190,9,190,10],[190,11,190,12],[190,13,190,15],[190,17,190,19],[191,9,191,10],[191,11,191,12],[190,1,190,2],[190,3,190,4],[190,5,190,6],[190,7,190,8],[191,1,191,2],[191,3,191,4],[191,5,191,6],[191,7,191,8],[193,1,193,2],[193,3,193,4],[193,5,193,6],[193,7,193,8],[194,3,194,4],[192,1,192,2],[192,3,192,4],[192,17,192,19],[193,13,193,15],[193,17,193,19],[192,9,192,10],[192,11,192,12],[193,9,193,10],[193,11,193,12],[192,13,192,15],[194,13,194,15],[194,17,194,19],[197,5,197,6],[198,1,198,2],[198,3,198,4],[198,5,198,6],[197,11,197,12],[196,13,196,15],[198,17,198,19],[197,13,197,15],[3,1,4,7],[195,13,195,15],[195,17,195,19],[195,11,195,12],[194,11,194,12],[197,1,197,2],[197,3,197,4],[197,17,197,19],[196,1,196,2],[196,3,196,4],[196,5,196,6],[196,7,196,8],[197,9,197,10],[196,17,196,19],[196,11,196,12],[194,1,194,2],[199,5,199,6],[199,7,199,8],[199,9,199,10],[199,11,199,12],[3,8,3,9],[3,10,3,21],[198,7,198,8],[199,1,199,2],[199,3,199,4],[198,9,198,10],[198,11,198,12],[198,13,198,15],[199,13,199,15],[199,17,199,19],[197,7,197,8],[196,9,196,10],[195,1,195,2],[195,3,195,4],[195,5,195,6],[195,7,195,8],[194,5,194,6],[195,9,195,10],[194,9,194,10],[194,7,194,8]]}
[null,"Income Over Feed Supplement Cost (IOFSC)®"]
[null,null,null,null,null,null,null,null,"Overwrite",null,null,"yellow",null,"cells and make aproppriate selections.",null,null,null,null,null,null,null,null,"Units"]
[null,null,null,null,null,null,null,null,"Click on blue button to optimize IOFSC: results appear in"]
[null,"V.E. Cabrera, R.D. Shaver, and M.A. Wattiaux",null,null,null,null,null,null,"blue",null,"cells. Click on red button to substitute between"]
[null,null,null,null,null,null,null,null,"feed supplements: results appear in figures and table.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUP(%)","RDP(%)","CP(%)",null,"A","B","C","Kd","Kp"]
[null,1,"Calculate Dry Matter Intake (DMI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"35-Corn Silage-CoSi",null,null,null,null,null,{"$f":"AK7*(AN7*(AQ7/(AP7+AQ7))+AO7)","v":3.1893486933375119E-2},{"$f":"AK7*(AM7+AN7*(AP7/(AP7+AQ7)))","v":5.5842513066624876E-2},8.7999999999999995E-2,null,0.51,0.30199999999999999,0.185,4.4000000000000004,{"$f":"3.054+0.614*(DMI/BW)*100","v":6.26675125396239}]
[null,1.1000000000000001,null,"Milk Producion (MP)",null,null,null,null,null,null,null,null,null,null,null,"kg/cow/day",60,null,null,null,null,null,null,null,null,null,null,2,"83-Alf. Silage-AlSi",null,null,null,null,null,4.244037834449195E-2,0.17655962165550804,0.219,null,0.57299999999999995,0.35299999999999998,7.3999999999999996E-2,12.2,{"$f":"3.054+0.614*(DMI/BW)*100","v":6.26675125396239}]
[null,1.2,null,"Body Weight (BW)",null,null,null,null,null,null,null,null,null,null,null,"kg/cow",625,null,null,null,null,null,null,null,null,null,null,3,"74-Mx. Silage-MxSi",null,null,null,null,null,3.9062685787259487E-2,0.15093731421274051,0.19,null,0.58099999999999996,0.34200000000000003,7.6999999999999999E-2,10.4,{"$f":"3.054+0.614*(DMI/BW)*100","v":6.26675125396239}]
[null,1.3,null,"Days in Milk (DIM)",null,null,null,null,null,null,null,null,null,null,null,"day",180,null,null,null,null,null,null,null,null,null,null,4,"77-Hay Forage-",null,null,null,null,null,3.4777612783179548E-2,0.16722238721682045,0.20200000000000001,null,0.41899999999999998,0.49199999999999999,8.8999999999999996E-2,16.600000000000001,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Q14)-0.017*0.396","v":3.3768316457760261}]
[null,1.4,null,"Dry Matter Intake (DMI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg/cow/day",{"$f":"((0.372*(FCMkg)+0.0968*(BW)^0.75*(1-EXP(1)^(-0.192*((DIM/7)+3.67)))))","v":32.703086868509672},null,null,null,5,"82-Silage Inmature<40% NDF-Si40",null,null,null,null,null,3.5413801122895376E-2,0.19658619887710463,0.23200000000000001,null,0.61599999999999999,0.29099999999999998,9.2999999999999999E-2,13.1,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Forage)-0.017*0.367","v":3.3773246457760262}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"83-Silage Inmature 40-46% NDF-Si43",null,null,null,null,null,3.2962659708942084E-2,0.1860373402910579,0.219,null,0.57299999999999995,0.35299999999999998,7.3999999999999996E-2,12.2,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Forage)-0.017*0.432","v":3.3762196457760263}]
[null,2,"Set the Sources and Proportion of Forage in the Diet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"84-Silage Inmature>46% NDF-Si50",null,null,null,null,null,4.6500659410376198E-2,0.15649934058962384,0.20300000000000001,null,0.52900000000000003,0.34399999999999997,0.127,8,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Forage)-0.017*0.5","v":3.3750636457760259}]
[null,2.1,null,"Proportion of Forage in Diet",null,null,null,null,null,null,null,"---------",null,null,null,"% of Diet",0.5]
[null,2.2000000000000002,null,"Corn Silage",null,null,null,null,null,null,null,null,"-----------",null,null,null,null,"% of Forage",0.5,null,null,null,null,null,null,{"$f":"SUM(S15:T17)","v":1},null,1,{"$f":"VLOOKUP($AB15,$AB$7:$AQ$13,$AC$5,)","v":"35-Corn Silage-CoSi"},null,null,null,null,null,{"$f":"VLOOKUP($AB15,$AB$7:$AQ$13,AI$5,TRUE)","v":3.1893486933375119E-2},5.5842513066624876E-2,8.7999999999999995E-2,null,0.51,0.30199999999999999,0.185,4.4000000000000004,6.26675125396239]
[null,2.2999999999999998,null,"Alfalfa",null,null,null,null,null,null,null,null,"-----------",null,null,null,null,"% of Forage",0.5,null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP($AB16,$AB$7:$AQ$13,$AC$5,)","v":"83-Alf. Silage-AlSi"},null,null,null,null,null,4.244037834449195E-2,0.17655962165550804,0.219,null,0.57299999999999995,0.35299999999999998,7.3999999999999996E-2,12.2,6.26675125396239]
[null,2.4,null,"Mixed",null,null,null,null,null,null,null,null,"-----------",null,null,null,null,"% of Forage",0,null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP($AB17,$AB$7:$AQ$13,$AC$5,)","v":"83-Alf. Silage-AlSi"},null,null,null,null,null,4.244037834449195E-2,0.17655962165550804,0.219,null,0.57299999999999995,0.35299999999999998,7.3999999999999996E-2,12.2,6.26675125396239]
[null,2.4,null,"Crude Protein in Diet Provided by Forage",null,null,null,null,null,null,null,null,null,null,null,"----------------------------",null,null,null,null,null,null,"kg/cow/day",{"$f":"DMI*CP_F","v":2.5099619171581171},null,null,null,null,null,null,null,null,null,null,{"$f":"$Q$14*SUMPRODUCT($S$15:$S$17,AI15:AI17)","v":1.8583466319466765E-2},{"$f":"$Q$14*SUMPRODUCT($S$15:$S$17,AJ15:AJ17)","v":5.810053368053323E-2},{"$f":"$Q$14*SUMPRODUCT($S$15:$S$17,AK15:AK17)","v":7.6749999999999999E-2}]
[]
[null,3,"Set Source of Energy Supplements and Prices"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Price",null,null,null,"Current",null,null,null,"Upper ",null,"Optimal",null,null,null,"RUP(%)",null,"RDP(%)",null,"CP(%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"($/kg)",null,null,null,"Diet (kg)",null,null,null,"Limit (kg)",null,"(kg)"]
[null,3.1,null,"27-Corn-CGG",null,null,null,null,null,null,null,null,null,0.224,null,null,null,12,null,null,null,10,null,7.8113703493559372,null,null,null,{"$f":"$X23/DMI*$AI23","v":1.1388535765440237E-2},null,{"$f":"$X23/DMI*$AJ23","v":1.1064048475055337E-2},null,{"$f":"$X23/DMI*$AK23","v":2.2452584240495576E-2},null,null,{"$f":"AK23*(AN23*(AQ23/(AP23+AQ23))+AO23)","v":4.7679249323139543E-2},{"$f":"AK23*(AM23+AN23*(AP23/(AP23+AQ23)))","v":4.6320750676860444E-2},9.4E-2,null,0.23899999999999999,0.72499999999999998,3.5999999999999997E-2,4.9000000000000004,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":9.0986791110721263}]
[null,3.2,null,"8-Barley-BGR",null,null,null,null,null,null,null,null,null,0.218,null,null,null,null,null,null,null,0,null,0,null,null,null,{"$f":"$X24/DMI*$AI24","v":0},null,{"$f":"$X24/DMI*$AJ24","v":0},null,{"$f":"$X24/DMI*$AK24","v":0},null,null,{"$f":"AK24*(AN24*(AQ24/(AP24+AQ24))+AO24)","v":3.237812711733111E-2},{"$f":"AK24*(AM24+AN24*(AP24/(AP24+AQ24)))","v":9.1621872882668889E-2},0.124,null,0.30199999999999999,0.61199999999999999,8.5999999999999993E-2,22.7,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":9.0986791110721263}]
[null,3.3,null,"116-Wheat-WGR",null,null,null,null,null,null,null,null,null,0.27200000000000002,null,null,null,null,null,null,null,10,null,0,null,null,null,{"$f":"$X25/DMI*$AI25","v":0},null,{"$f":"$X25/DMI*$AJ25","v":0},null,{"$f":"$X25/DMI*$AK25","v":0},null,null,{"$f":"AK25*(AN25*(AQ25/(AP25+AQ25))+AO25)","v":4.122438412374594E-2},{"$f":"AK25*(AM25+AN25*(AP25/(AP25+AQ25)))","v":0.10077561587625405},0.14199999999999999,null,0.27100000000000002,0.65100000000000002,7.8E-2,18.8,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":9.0986791110721263}]
[]
[null,4,"Set the Source of Protein, Byproduct Supplements and Prices"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Price",null,null,null,"Current",null,null,null,"Upper ",null,"Optimal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"($/kg)",null,null,null,"Diet (kg)",null,null,null,"Limit (kg)",null,"(kg)"]
[null,4.0999999999999996,null,"106-Soybean Meal-SBM",null,null,null,null,null,null,null,null,null,0.4,null,null,null,3.33,null,null,null,10,null,0,null,null,null,{"$f":"$X30/DMI*$AI30","v":0},null,{"$f":"$X30/DMI*$AJ30","v":0},null,{"$f":"$X30/DMI*$AK30","v":0},null,null,{"$f":"AK30*(AN30*(AQ30/(AP30+AQ30))+AO30)","v":0.19198780939465318},{"$f":"AK30*(AM30+AN30*(AP30/(AP30+AQ30)))","v":0.30701219060534679},0.499,null,0.22500000000000001,0.76800000000000002,7.0000000000000001E-3,9.4,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":9.0986791110721263}]
[null,4.2,null,"25-Corn Gluten Meal-CGM",null,null,null,null,null,null,null,null,null,0.60599999999999998,null,null,null,null,null,null,null,10,null,0,null,null,null,0,null,0,null,0,null,null,{"$f":"AK31*(AN31*(AQ31/(AP31+AQ31))+AO31)","v":0.50542960728976261},{"$f":"AK31*(AM31+AN31*(AP31/(AP31+AQ31)))","v":0.14457039271023753},0.65,null,3.9E-2,0.90900000000000003,5.2000000000000005E-2,2.2999999999999998,9.0986791110721263]
[null,4.3,null,"24-Corn Gluten Feed-CGF",null,null,null,null,null,null,null,null,null,0.17599999999999999,null,null,null,null,null,null,null,2,null,2,null,null,null,4.686548087851264E-3,null,9.8686528298440046E-3,null,1.4555200917695266E-2,null,null,7.6632294615223889E-2,0.16136770538477613,0.23799999999999999,null,0.48,0.43200000000000005,8.8000000000000009E-2,7.7,9.0986791110721263]
[null,4.4000000000000004,null,"23-Corn Distiller Grains-CDG",null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,null,null,null,10,null,0,null,null,null,0,null,0,null,0,null,null,0.15905783467436491,0.13794216532563508,0.29699999999999999,null,0.28499999999999998,0.63300000000000001,8.199999999999999E-2,3.6,9.0986791110721263]
[null,4.5,null,"109-Soybean Whole Roasted- HSB",null,null,null,null,null,null,null,null,null,0.35,null,null,null,null,null,null,null,10,null,3.8741246451190241,null,null,null,2.204589739862953E-2,null,2.8893440655273779E-2,null,5.0939338053903306E-2,null,null,0.18609852902641513,0.24390147097358486,0.43,null,0.17800000000000002,0.77,5.2000000000000005E-2,9.3000000000000007,9.0986791110721263]
[null,4.5999999999999996,null,"104-Soybean Meal Expellers-SBMx",null,null,null,null,null,null,null,null,null,0.443,null,null,null,null,null,null,null,10,null,0.94554843977987335,null,null,null,9.6711294673512329E-3,null,3.7156474255553317E-3,null,1.3386776892906566E-2,null,null,0.33448924854766937,0.12851075145233065,0.46300000000000002,null,8.6999999999999994E-2,0.91299999999999992,0,2.4,9.0986791110721263]
[null,4.7,null,"14-Blood Meal Ring Dried-BMRD",null,null,null,null,null,null,null,null,null,0.99199999999999999,null,null,null,null,null,null,null,0.45400000000000001,null,0,null,null,null,0,null,0,null,0,null,null,0.75807561737317242,0.19692438262682743,0.95499999999999996,null,0.10099999999999999,0.60899999999999999,0.28999999999999998,1.9,9.0986791110721263]
[null,4.8,null,"Urea",null,null,null,null,null,null,null,null,null,0.7,null,null,null,null,null,null,null,0.45400000000000001,null,0,null,null,null,0,null,0,null,0,null,null,0,2.81,2.81]
[]
[null,5,"Set the Upper Limits for RUP and RDP, and Milk Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper ",null,"Amount",null,null,null,"FCM",null,{"$f":"MP*0.4+MP*0.035*15","v":55.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limit",null,"in Diet",null,null,null,"DMIf",null,{"$f":"SUM(grains,protein)+DMI*Forage","v":30.982586868509671}]
[null,5.0999999999999996,null,"RUP",null,"Rumen Undegradable Protein",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of Diet DM",7.0000000000000007E-2,null,{"$f":"SUM(AB30:AC37,AB23:AC25,AI18)","v":6.6375577038739031E-2}]
[null,5.2,null,"RDP",null,"Rumen Degradable Protein",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of Diet DM",0.12,null,{"$f":"SUM(AD30:AE37,AD23:AE25,AJ18)","v":0.11164232306626168}]
[null,5.3,null,"CP",null,"Crude Protein",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of Diet DM",{"$f":"SUM(V42:V43)","v":0.19},null,{"$f":"SUM(AF30:AG37,AF23:AG25,CP_F)","v":0.17808390010500072}]
[null,5.4,null,"Milk Price",null,null,null,null,null,null,null,null,"$/kg",0.33]
[]
[null,6,"Perform Optimization, Maximize IOFSC"]
[null,6.1,null,"Click button to  maximize the Income"]
[null,null,null,"Over Feed Supplement Cost (IOFSC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current",null,"Optimal"]
[null,6.2,null,"Expected Milk Producion (E-MP)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg/cow/day",43.015792268966798,null,{"$f":"-55.61+1.15*AD41+8.79*X43*100-0.36*(X43*100)^2+1.85*X42*100","v":45.562628747523277}]
[null,6.3,null,"Maximum Income Over Feed Supplement Cost (IOFSC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/cow/day",14.046632752966055,null,{"$f":"(fMP*MPrice)-(SUMPRODUCT(protein,N30:N37)+SUMPRODUCT(grains,N23:N25))","v":11.159098943812809}]
[]
[]
[null,7,"Perform a Substitution Analysis"]
[null,7.1,null,"Select an ENERGY supplement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,7.2,null,"Select a PROTEIN/BYPRODUCT supplement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"7.3.a",null,"Select one of the following to change its price",null,null,null,null,null,null,null,null,null,null,null,null,"-------------",null,null,null,null,null,null,null,null,null,3]
[null,"7.3.b",null,"Define the upper (↑) and lower (↓) limit in the price ----",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑",0,null,"↓",0.26000000000000006]
[null,7.4,null,"Click the button to update the results "]
[null,null,null,"of sections 8, 9, and 10"]
[]
[null,8,"IOFSC and Milk Production when Substituting Energy for Protein/Byproducts"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,9,"Change in IOFSC at Upper and Lower Selected Prices"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"X23","v":7.8113703493559372},null,{"$f":"X30","v":0},null,{"$f":"X42","v":6.6375577038739031E-2},null,{"$f":"X43","v":0.11164232306626168},null,{"$f":"X44","v":0.17808390010500072},null,{"$f":"X51","v":45.562628747523277},null,null,null,null,null,{"$f":"X52","v":11.159098943812809},null,null,null,{"$f":"X52","v":11.159098943812809},null,{"$f":"X52","v":11.159098943812809}]
[null,10,"IOFSC and Milk Production when Substituting Feed Supplements and Changing Selected Prices"]
[null,"Energy",null,"Protein",null,"RUP",null,"RDP",null,"CP",null,"Milk",null,null,null,null,null,"IOFSCbase",null,null,null,"IOFSCupper",null,"IOFSClower"]
[null,12.635901147765537,null,1.9951422864892951,null,5.077908892141153E-2,null,0.10051854744222483,null,0.15136363636363637,null,39.417012383341564,null,null,null,null,null,12.926646429308256,null,null,null,12.926646429308256,null,17.230984181569156]
[null,12.41421867148895,null,2.2168247627658837,null,5.1819718256311501E-2,null,0.10254609992550667,null,0.15443181818181817,null,39.909540214968892,null,null,null,null,null,13.094492002767055,null,null,null,13.094492002767055,null,17.45261379424166]
[null,12.192536195212361,null,2.438507239042472,null,5.2860347591211471E-2,null,0.10457365240878852,null,0.15749999999999997,null,40.372469069274501,null,null,null,null,null,13.249906005750731,null,null,null,13.249906005750731,null,17.658579628115508]
[null,11.970853718935773,null,2.6601897153190603,null,5.3900976926111427E-2,null,0.10660120489207037,null,0.16056818181818183,null,40.805798946258371,null,null,null,null,null,13.392888438259277,null,null,null,13.392888438259277,null,17.84888168319069]
[null,11.749171242659184,null,2.8818721915956487,null,5.4941606261011397E-2,null,0.10862875737535223,null,0.16363636363636364,null,41.209529845920514,null,null,null,null,null,13.523439300292699,null,null,null,13.523439300292699,null,18.023519959467222]
[null,11.527488766382596,null,3.103554667872237,null,5.5982235595911367E-2,null,0.11065630985863407,null,0.16670454545454544,null,41.583661768260924,null,null,null,null,null,13.641558591850993,null,null,null,13.641558591850993,null,18.182494456945083]
[null,11.305806290106007,null,3.3252371441488253,null,5.7022864930811323E-2,null,0.11268386234191594,null,0.16977272727272724,null,41.928194713279609,null,null,null,null,null,13.747246312934161,null,null,null,13.747246312934161,null,18.325805175624296]
[null,11.08412381382942,null,3.5469196204254136,null,5.8063494265711307E-2,null,0.11471141482519778,null,0.1728409090909091,null,42.243128680976561,null,null,null,null,null,13.840502463542199,null,null,null,13.840502463542199,null,18.453452115504838]
[null,10.862441337552831,null,3.768602096702002,null,5.9104123600611264E-2,null,0.11673896730847963,null,0.1759090909090909,null,42.528463671351787,null,null,null,null,null,13.921327043675115,null,null,null,13.921327043675115,null,18.565435276586733]
[null,10.640758861276243,null,3.9902845729785903,null,6.0144752935511234E-2,null,0.11876651979176149,null,0.17897727272727271,null,42.784199684405294,null,null,null,null,null,13.989720053332908,null,null,null,13.989720053332908,null,18.661754658869967]
[null,10.419076384999654,null,4.2119670492551791,null,6.118538227041119E-2,null,0.12079407227504334,null,0.18204545454545454,null,43.010336720137033,null,null,null,null,null,14.045681492515559,null,null,null,14.045681492515559,null,18.742410262354525]
[null,10.197393908723065,null,4.4336495255317674,null,6.222601160531116E-2,null,0.1228216247583252,null,0.18511363636363637,null,43.206874778547082,null,null,null,null,null,14.0892113612231,null,null,null,14.0892113612231,null,18.807402087040444]
[null,9.9757114324464773,null,4.6553320018083557,null,6.326664094021113E-2,null,0.12484917724160705,null,0.18818181818181817,null,43.373813859635391,null,null,null,null,null,14.120309659455511,null,null,null,14.120309659455511,null,18.856730132927694]

{"sheet":"MSGC-Arg","index":2,"n_rows":124,"n_cols":43,"rows_kept":124,"cut":false,"hidden":false,"merged":[[199,13,199,15],[199,17,199,19],[199,1,199,2],[199,3,199,4],[199,5,199,6],[199,7,199,8],[199,9,199,10],[199,11,199,12],[197,13,197,15],[197,17,197,19],[198,1,198,2],[198,3,198,4],[198,5,198,6],[198,7,198,8],[198,9,198,10],[198,11,198,12],[198,13,198,15],[198,17,198,19],[197,1,197,2],[197,3,197,4],[197,5,197,6],[197,7,197,8],[197,9,197,10],[197,11,197,12],[195,13,195,15],[195,17,195,19],[196,1,196,2],[196,3,196,4],[196,5,196,6],[196,7,196,8],[196,9,196,10],[196,11,196,12],[196,13,196,15],[196,17,196,19],[195,1,195,2],[195,3,195,4],[195,5,195,6],[195,7,195,8],[195,9,195,10],[195,11,195,12],[193,13,193,15],[193,17,193,19],[194,1,194,2],[194,3,194,4],[194,5,194,6],[194,7,194,8],[194,9,194,10],[194,11,194,12],[194,13,194,15],[194,17,194,19],[193,1,193,2],[193,3,193,4],[193,5,193,6],[193,7,193,8],[193,9,193,10],[193,11,193,12],[191,13,191,15],[191,17,191,19],[192,1,192,2],[192,3,192,4],[192,5,192,6],[192,7,192,8],[192,9,192,10],[192,11,192,12],[192,13,192,15],[192,17,192,19],[191,1,191,2],[191,3,191,4],[191,5,191,6],[191,7,191,8],[191,9,191,10],[191,11,191,12],[189,13,189,15],[189,17,189,19],[190,1,190,2],[190,3,190,4],[190,5,190,6],[190,7,190,8],[190,9,190,10],[190,11,190,12],[190,13,190,15],[190,17,190,19],[189,1,189,2],[189,3,189,4],[189,5,189,6],[189,7,189,8],[189,9,189,10],[189,11,189,12],[187,13,187,15],[187,17,187,19],[188,1,188,2],[188,3,188,4],[188,5,188,6],[188,7,188,8],[188,9,188,10],[188,11,188,12],[188,13,188,15],[188,17,188,19],[187,1,187,2],[187,3,187,4],[187,5,187,6],[187,7,187,8],[187,9,187,10],[187,11,187,12],[185,13,185,15],[185,17,185,19],[186,1,186,2],[186,3,186,4],[186,5,186,6],[186,7,186,8],[186,9,186,10],[186,11,186,12],[186,13,186,15],[186,17,186,19],[185,1,185,2],[185,3,185,4],[185,5,185,6],[185,7,185,8],[185,9,185,10],[185,11,185,12],[183,13,183,15],[183,17,183,19],[184,1,184,2],[184,3,184,4],[184,5,184,6],[184,7,184,8],[184,9,184,10],[184,11,184,12],[184,13,184,15],[184,17,184,19],[183,1,183,2],[183,3,183,4],[183,5,183,6],[183,7,183,8],[183,9,183,10],[183,11,183,12],[181,13,181,15],[181,17,181,19],[182,1,182,2],[182,3,182,4],[182,5,182,6],[182,7,182,8],[182,9,182,10],[182,11,182,12],[182,13,182,15],[182,17,182,19],[181,1,181,2],[181,3,181,4],[181,5,181,6],[181,7,181,8],[181,9,181,10],[181,11,181,12],[179,13,179,15],[179,17,179,19],[180,1,180,2],[180,3,180,4],[180,5,180,6],[180,7,180,8],[180,9,180,10],[180,11,180,12],[180,13,180,15],[180,17,180,19],[179,1,179,2],[179,3,179,4],[179,5,179,6],[179,7,179,8],[179,9,179,10],[179,11,179,12],[177,13,177,15],[177,17,177,19],[178,1,178,2],[178,3,178,4],[178,5,178,6],[178,7,178,8],[178,9,178,10],[178,11,178,12],[178,13,178,15],[178,17,178,19],[177,1,177,2],[177,3,177,4],[177,5,177,6],[177,7,177,8],[177,9,177,10],[177,11,177,12],[175,13,175,15],[175,17,175,19],[176,1,176,2],[176,3,176,4],[176,5,176,6],[176,7,176,8],[176,9,176,10],[176,11,176,12],[176,13,176,15],[176,17,176,19],[175,1,175,2],[175,3,175,4],[175,5,175,6],[175,7,175,8],[175,9,175,10],[175,11,175,12],[173,13,173,15],[173,17,173,19],[174,1,174,2],[174,3,174,4],[174,5,174,6],[174,7,174,8],[174,9,174,10],[174,11,174,12],[174,13,174,15],[174,17,174,19],[173,1,173,2],[173,3,173,4],[173,5,173,6],[173,7,173,8],[173,9,173,10],[173,11,173,12],[171,13,171,15],[171,17,171,19],[172,1,172,2],[172,3,172,4],[172,5,172,6],[172,7,172,8],[172,9,172,10],[172,11,172,12],[172,13,172,15],[172,17,172,19],[171,1,171,2],[171,3,171,4],[171,5,171,6],[171,7,171,8],[171,9,171,10],[171,11,171,12],[169,13,169,15],[169,17,169,19],[170,1,170,2],[170,3,170,4],[170,5,170,6],[170,7,170,8],[170,9,170,10],[170,11,170,12],[170,13,170,15],[170,17,170,19],[169,1,169,2],[169,3,169,4],[169,5,169,6],[169,7,169,8],[169,9,169,10],[169,11,169,12],[167,13,167,15],[167,17,167,19],[168,1,168,2],[168,3,168,4],[168,5,168,6],[168,7,168,8],[168,9,168,10],[168,11,168,12],[168,13,168,15],[168,17,168,19],[167,1,167,2],[167,3,167,4],[167,5,167,6],[167,7,167,8],[167,9,167,10],[167,11,167,12],[165,13,165,15],[165,17,165,19],[166,1,166,2],[166,3,166,4],[166,5,166,6],[166,7,166,8],[166,9,166,10],[166,11,166,12],[166,13,166,15],[166,17,166,19],[165,1,165,2],[165,3,165,4],[165,5,165,6],[165,7,165,8],[165,9,165,10],[165,11,165,12],[163,13,163,15],[163,17,163,19],[164,1,164,2],[164,3,164,4],[164,5,164,6],[164,7,164,8],[164,9,164,10],[164,11,164,12],[164,13,164,15],[164,17,164,19],[163,1,163,2],[163,3,163,4],[163,5,163,6],[163,7,163,8],[163,9,163,10],[163,11,163,12],[161,13,161,15],[161,17,161,19],[162,1,162,2],[162,3,162,4],[162,5,162,6],[162,7,162,8],[162,9,162,10],[162,11,162,12],[162,13,162,15],[162,17,162,19],[161,1,161,2],[161,3,161,4],[161,5,161,6],[161,7,161,8],[161,9,161,10],[161,11,161,12],[159,13,159,15],[159,17,159,19],[160,1,160,2],[160,3,160,4],[160,5,160,6],[160,7,160,8],[160,9,160,10],[160,11,160,12],[160,13,160,15],[160,17,160,19],[159,1,159,2],[159,3,159,4],[159,5,159,6],[159,7,159,8],[159,9,159,10],[159,11,159,12],[157,13,157,15],[157,17,157,19],[158,1,158,2],[158,3,158,4],[158,5,158,6],[158,7,158,8],[158,9,158,10],[158,11,158,12],[158,13,158,15],[158,17,158,19],[157,1,157,2],[157,3,157,4],[157,5,157,6],[157,7,157,8],[157,9,157,10],[157,11,157,12],[155,13,155,15],[155,17,155,19],[156,1,156,2],[156,3,156,4],[156,5,156,6],[156,7,156,8],[156,9,156,10],[156,11,156,12],[156,13,156,15],[156,17,156,19],[155,1,155,2],[155,3,155,4],[155,5,155,6],[155,7,155,8],[155,9,155,10],[155,11,155,12],[153,17,153,19],[154,1,154,2],[154,3,154,4],[154,5,154,6],[154,7,154,8],[154,9,154,10],[154,11,154,12],[154,17,154,19],[153,1,153,2],[153,3,153,4],[153,5,153,6],[153,7,153,8],[153,9,153,10],[153,11,153,12],[149,13,149,15],[149,17,149,19],[150,1,150,2],[150,3,150,4],[150,5,150,6],[150,7,150,8],[150,9,150,10],[150,11,150,12],[150,13,150,15],[150,17,150,19],[149,1,149,2],[149,3,149,4],[149,5,149,6],[149,7,149,8],[149,9,149,10],[149,11,149,12],[147,13,147,15],[147,17,147,19],[148,1,148,2],[148,3,148,4],[148,5,148,6],[148,7,148,8],[148,9,148,10],[148,11,148,12],[148,13,148,15],[148,17,148,19],[147,1,147,2],[147,3,147,4],[147,5,147,6],[147,7,147,8],[147,9,147,10],[147,11,147,12],[145,13,145,15],[145,17,145,19],[146,1,146,2],[146,3,146,4],[146,5,146,6],[146,7,146,8],[146,9,146,10],[146,11,146,12],[146,13,146,15],[146,17,146,19],[145,1,145,2],[145,3,145,4],[145,5,145,6],[145,7,145,8],[145,9,145,10],[145,11,145,12],[143,13,143,15],[143,17,143,19],[144,1,144,2],[144,3,144,4],[144,5,144,6],[144,7,144,8],[144,9,144,10],[144,11,144,12],[144,13,144,15],[144,17,144,19],[143,1,143,2],[143,3,143,4],[143,5,143,6],[143,7,143,8],[143,9,143,10],[143,11,143,12],[141,13,141,15],[141,17,141,19],[142,1,142,2],[142,3,142,4],[142,5,142,6],[142,7,142,8],[142,9,142,10],[142,11,142,12],[142,13,142,15],[142,17,142,19],[141,1,141,2],[141,3,141,4],[141,5,141,6],[141,7,141,8],[141,9,141,10],[141,11,141,12],[139,13,139,15],[139,17,139,19],[140,1,140,2],[140,3,140,4],[140,5,140,6],[140,7,140,8],[140,9,140,10],[140,11,140,12],[140,13,140,15],[140,17,140,19],[139,1,139,2],[139,3,139,4],[139,5,139,6],[139,7,139,8],[139,9,139,10],[139,11,139,12],[137,13,137,15],[137,17,137,19],[138,1,138,2],[138,3,138,4],[138,5,138,6],[138,7,138,8],[138,9,138,10],[138,11,138,12],[138,13,138,15],[138,17,138,19],[137,1,137,2],[137,3,137,4],[137,5,137,6],[137,7,137,8],[137,9,137,10],[137,11,137,12],[135,13,135,15],[135,17,135,19],[136,1,136,2],[136,3,136,4],[136,5,136,6],[136,7,136,8],[136,9,136,10],[136,11,136,12],[136,13,136,15],[136,17,136,19],[135,1,135,2],[135,3,135,4],[135,5,135,6],[135,7,135,8],[135,9,135,10],[135,11,135,12],[133,13,133,15],[133,17,133,19],[134,1,134,2],[134,3,134,4],[134,5,134,6],[134,7,134,8],[134,9,134,10],[134,11,134,12],[134,13,134,15],[134,17,134,19],[133,1,133,2],[133,3,133,4],[133,5,133,6],[133,7,133,8],[133,9,133,10],[133,11,133,12],[131,13,131,15],[131,17,131,19],[132,1,132,2],[132,3,132,4],[132,5,132,6],[132,7,132,8],[132,9,132,10],[132,11,132,12],[132,13,132,15],[132,17,132,19],[131,1,131,2],[131,3,131,4],[131,5,131,6],[131,7,131,8],[131,9,131,10],[131,11,131,12],[129,13,129,15],[129,17,129,19],[130,1,130,2],[130,3,130,4],[130,5,130,6],[130,7,130,8],[130,9,130,10],[130,11,130,12],[130,13,130,15],[130,17,130,19],[129,1,129,2],[129,3,129,4],[129,5,129,6],[129,7,129,8],[129,9,129,10],[129,11,129,12],[128,1,128,2],[128,3,128,4],[128,5,128,6],[128,7,128,8],[128,9,128,10],[128,11,128,12],[128,13,128,15],[128,17,128,19],[127,1,127,2],[127,3,127,4],[127,5,127,6],[127,7,127,8],[127,9,127,10],[127,11,127,12],[126,1,126,2],[126,3,126,4],[126,5,126,6],[126,7,126,8],[126,9,126,10],[126,11,126,12],[126,13,126,15],[126,17,126,19],[127,13,127,15],[127,17,127,19],[124,32,124,34],[125,1,125,2],[125,3,125,4],[125,5,125,6],[125,7,125,8],[125,9,125,10],[125,11,125,12],[125,13,125,15],[125,17,125,19],[125,30,125,31],[125,32,125,34],[124,1,124,2],[124,3,124,4],[124,5,124,6],[124,7,124,8],[124,9,124,10],[124,11,124,12],[124,13,124,15],[124,17,124,19],[124,30,124,31],[122,32,122,34],[123,1,123,2],[123,3,123,4],[123,5,123,6],[123,7,123,8],[123,9,123,10],[123,11,123,12],[123,13,123,15],[123,17,123,19],[123,30,123,31],[123,32,123,34],[122,1,122,2],[122,3,122,4],[122,5,122,6],[122,7,122,8],[122,9,122,10],[122,11,122,12],[122,13,122,15],[122,17,122,19],[122,30,122,31],[120,32,120,34],[121,1,121,2],[121,3,121,4],[121,5,121,6],[121,7,121,8],[121,9,121,10],[121,11,121,12],[121,13,121,15],[121,17,121,19],[121,30,121,31],[121,32,121,34],[120,1,120,2],[120,3,120,4],[120,5,120,6],[120,7,120,8],[120,9,120,10],[120,11,120,12],[120,13,120,15],[120,17,120,19],[120,30,120,31],[118,32,118,34],[119,1,119,2],[119,3,119,4],[119,5,119,6],[119,7,119,8],[119,9,119,10],[119,11,119,12],[119,13,119,15],[119,17,119,19],[119,30,119,31],[119,32,119,34],[118,1,118,2],[118,3,118,4],[118,5,118,6],[118,7,118,8],[118,9,118,10],[118,11,118,12],[118,13,118,15],[118,17,118,19],[118,30,118,31],[116,32,116,34],[117,1,117,2],[117,3,117,4],[117,5,117,6],[117,7,117,8],[117,9,117,10],[117,11,117,12],[117,13,117,15],[117,17,117,19],[117,30,117,31],[117,32,117,34],[116,1,116,2],[116,3,116,4],[116,5,116,6],[116,7,116,8],[116,9,116,10],[116,11,116,12],[116,13,116,15],[116,17,116,19],[116,30,116,31],[114,32,114,34],[115,1,115,2],[115,3,115,4],[115,5,115,6],[115,7,115,8],[115,9,115,10],[115,11,115,12],[115,13,115,15],[115,17,115,19],[115,30,115,31],[115,32,115,34],[114,1,114,2],[114,3,114,4],[114,5,114,6],[114,7,114,8],[114,9,114,10],[114,11,114,12],[114,13,114,15],[114,17,114,19],[114,30,114,31],[112,32,112,34],[113,1,113,2],[113,3,113,4],[113,5,113,6],[113,7,113,8],[113,9,113,10],[113,11,113,12],[113,13,113,15],[113,17,113,19],[113,30,113,31],[113,32,113,34],[112,1,112,2],[112,3,112,4],[112,5,112,6],[112,7,112,8],[112,9,112,10],[112,11,112,12],[112,13,112,15],[112,17,112,19],[112,30,112,31],[110,32,110,34],[111,1,111,2],[111,3,111,4],[111,5,111,6],[111,7,111,8],[111,9,111,10],[111,11,111,12],[111,13,111,15],[111,17,111,19],[111,30,111,31],[111,32,111,34],[110,1,110,2],[110,3,110,4],[110,5,110,6],[110,7,110,8],[110,9,110,10],[110,11,110,12],[110,13,110,15],[110,17,110,19],[110,30,110,31],[108,32,108,34],[109,1,109,2],[109,3,109,4],[109,5,109,6],[109,7,109,8],[109,9,109,10],[109,11,109,12],[109,13,109,15],[109,17,109,19],[109,30,109,31],[109,32,109,34],[108,1,108,2],[108,3,108,4],[108,5,108,6],[108,7,108,8],[108,9,108,10],[108,11,108,12],[108,13,108,15],[108,17,108,19],[108,30,108,31],[106,30,106,31],[106,32,106,34],[107,1,107,2],[107,3,107,4],[107,5,107,6],[107,7,107,8],[107,9,107,10],[107,11,107,12],[107,13,107,15],[107,17,107,19],[107,30,107,31],[107,32,107,34],[105,17,105,19],[106,1,106,2],[106,3,106,4],[106,5,106,6],[106,7,106,8],[106,9,106,10],[106,11,106,12],[106,13,106,15],[106,17,106,19],[105,1,105,2],[105,3,105,4],[105,5,105,6],[105,7,105,8],[105,9,105,10],[105,11,105,12],[103,2,103,23],[104,1,104,2],[104,3,104,4],[104,5,104,6],[104,7,104,8],[104,9,104,10],[104,11,104,12],[104,17,104,19],[102,3,102,4],[102,5,102,6],[102,7,102,8],[102,9,102,10],[102,11,102,12],[102,17,102,19],[55,19,55,23],[56,19,56,23],[58,20,58,21],[59,1,60,1],[62,2,62,23],[82,2,82,23],[46,2,46,23],[46,27,46,28],[46,29,46,30],[46,31,46,32],[47,1,48,1],[54,2,54,23],[43,27,43,28],[43,29,43,30],[43,31,43,32],[44,13,44,15],[44,31,44,32],[45,27,45,28],[45,29,45,30],[45,31,45,32],[41,27,41,28],[41,29,41,30],[41,31,41,32],[42,27,42,28],[42,29,42,30],[42,31,42,32],[38,2,38,23],[39,27,39,28],[39,29,39,30],[39,31,39,32],[40,27,40,28],[40,29,40,30],[40,31,40,32],[35,13,35,15],[35,17,35,19],[35,27,35,28],[35,29,35,30],[35,31,35,32],[36,13,36,15],[36,17,36,19],[36,27,36,28],[36,29,36,30],[36,31,36,32],[33,13,33,15],[33,17,33,19],[33,27,33,28],[33,29,33,30],[33,31,33,32],[34,13,34,15],[34,17,34,19],[34,27,34,28],[34,29,34,30],[34,31,34,32],[31,13,31,15],[31,17,31,19],[31,27,31,28],[31,29,31,30],[31,31,31,32],[32,13,32,15],[32,17,32,19],[32,27,32,28],[32,29,32,30],[32,31,32,32],[29,27,29,28],[29,29,29,30],[29,31,29,32],[30,13,30,15],[30,17,30,19],[30,27,30,28],[30,29,30,30],[30,31,30,32],[27,13,27,15],[27,17,27,19],[28,13,28,15],[28,17,28,19],[29,13,29,15],[29,17,29,19],[24,13,24,15],[24,17,24,19],[24,27,24,28],[24,29,24,30],[24,31,24,32],[26,2,26,23],[22,13,22,15],[22,17,22,19],[22,27,22,28],[22,29,22,30],[22,31,22,32],[23,13,23,15],[23,17,23,19],[23,27,23,28],[23,29,23,30],[23,31,23,32],[20,27,20,28],[20,29,20,30],[20,31,20,32],[21,13,21,15],[21,17,21,19],[21,27,21,28],[21,29,21,30],[21,31,21,32],[14,25,14,26],[15,18,15,19],[16,18,16,19],[19,2,19,23],[20,13,20,15],[20,17,20,19],[8,16,8,18],[9,16,9,18],[12,2,12,23],[13,16,13,17],[14,3,14,11],[14,18,14,19],[3,1,4,7],[3,8,3,9],[4,8,4,21],[3,10,3,11],[3,12,3,21],[4,25,4,26],[6,2,6,23],[0,1,0,23],[2,8,2,21],[7,16,7,18],[1,22,4,23],[1,8,1,10],[1,11,1,13],[1,14,1,21]]}
[null,"Margen Sobre Gastos en Concentrados (MSGC)®                                                                                                             "]
[null,null,null,null,null,null,null,null,"Rellenar las celdas",null,null,"Amarillas",null,null," y hacer las selecciones apropiadas."]
[null,null,null,null,null,null,null,null,"Hacer Click en el boton azul para optimizar MSGC: Los resultados aparecen en "]
[null,"V.E. Cabrera, R.D. Shaver, and M.A. Wattiaux",null,null,null,null,null,null,"en las celdas",null,"Azules.",null,"  Hacer Click en el boton rojo para la sustitución de"]
[null,null,null,null,null,null,null,null,"alimentos concentrados: Los resultados aparecen en los gráficos y la tabla.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUP(%)","RDP(%)","CP(%)",null,"A","B","C","Kd","Kp"]
[null,1,"Calcular el Consumo de Materia Seca (CMS)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"35-Silaje de Maíz 45%FDN-SiMz45",null,null,null,null,null,{"$f":"AK7*(AN7*(AQ7/(AP7+AQ7))+AO7)","v":2.9960297715006346E-2},{"$f":"AK7*(AM7+AN7*(AP7/(AP7+AQ7)))","v":5.4784702284993658E-2},8.5000000000000006E-2,null,0.51,0.30199999999999999,0.185,4.4000000000000004,{"$f":"3.054+0.614*(DMI/BW)*100","v":5.4776511346716426}]
[null,1.1000000000000001,null,"Producción de Leche (PL)",null,null,null,null,null,null,null,null,null,null,null,"Lts/vaca/día",35,null,null,null,null,null,null,null,null,null,null,2,"83-Silaje de Alfalfa 43%FDN-SiAl45",null,null,null,null,null,{"$f":"AK8*(AN8*(AQ8/(AP8+AQ8))+AO8)","v":3.5759423970563392E-2},0.15924057602943659,0.19500000000000001,null,0.57299999999999995,0.35299999999999998,7.3999999999999996E-2,12.2,{"$f":"3.054+0.614*(DMI/BW)*100","v":5.4776511346716426}]
[null,1.2,null,"Peso Corporal (PC)",null,null,null,null,null,null,null,null,null,null,null,"kg/vaca",600,null,null,null,null,null,null,null,null,null,null,3,"102-Silaje de Sorgo 65%FDN-SiSo65",null,null,null,null,null,4.5383713284723973E-2,4.4616286715276031E-2,0.09,null,0.376,0.29699999999999999,0.32700000000000001,3.7,{"$f":"3.054+0.614*(DMI/BW)*100","v":5.4776511346716426}]
[null,1.3,null,"Días en Leche (DEL)",null,null,null,null,null,null,null,null,null,null,null,"días",150,null,null,null,null,null,null,null,null,null,null,4,"79-Heno de Alfalfa 50%FDN-HeAl43",null,null,null,null,null,3.5914529766203844E-2,0.13408547023379619,0.17,null,0.38900000000000001,0.496,0.115,14,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Q14)-0.017*0.396","v":3.37137563670208}]
[null,1.4,null,"Consumo de Materia Seca (CMS)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg/vaca/día",{"$f":"((0.372*(FCMkg)+0.0968*(BW*1)^0.75*(1-EXP(1)^(-0.192*((DIM/7)+3.67)))))","v":23.683887309494885},null,null,null,5,"76-Pastura Alfalfa 10%Floración-PaAl10",null,null,null,null,null,4.5217699585084419E-2,0.17478230041491555,0.22,null,0.311,0.61599999999999999,7.2999999999999995E-2,12.3,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Forage)-0.017*0.367","v":3.37186863670208}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"76a-Pastura Alfalfa 100%Floración-PaAl100",null,null,null,null,null,4.0831620463531788E-2,0.1182319795364682,0.159,null,0.28599999999999998,0.58299999999999996,{"$f":"7.3%*1.8","v":0.13139999999999999},12.3,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Forage)-0.017*0.432","v":3.3707636367020801}]
[null,2,"Sellecionar las Fuentes y Proporción de Forraje en la Dieta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"10-Silaje de Cebada 55%FDN-SiCe45",null,null,null,null,null,{"$f":"AK13*(AN13*(AQ13/(AP13+AQ13))+AO13)","v":2.8972785437545508E-2},{"$f":"AK13*(AM13+AN13*(AP13/(AP13+AQ13)))","v":0.10002721456245449},0.129,null,0.56599999999999995,0.32900000000000001,0.105,5.9,{"$f":"3.362+0.479*(DMI/BW)-0.007*(1-Forage)-0.017*0.5","v":3.3696076367020797}]
[null,2.1,null,"Proporción de Forraje en la Dieta",null,null,null,null,null,null,null,null,null,null,null,"% en la Dieta",0.6]
[null,2.2000000000000002,null,"Corn Silage",null,null,null,null,null,null,null,null,null,null,null,null,null,"% del Forraje",0.4,null,null,null,null,null,null,{"$f":"SUM(S15:T17)","v":1},null,1,{"$f":"VLOOKUP($AB15,$AB$7:$AQ$13,$AC$5,)","v":"35-Silaje de Maíz 45%FDN-SiMz45"},null,null,null,null,null,{"$f":"VLOOKUP($AB15,$AB$7:$AQ$13,AI$5,TRUE)","v":2.9960297715006346E-2},5.4784702284993658E-2,8.5000000000000006E-2,null,0.51,0.30199999999999999,0.185,4.4000000000000004,5.4776511346716426]
[null,2.2999999999999998,null,"Alfalfa",null,null,null,null,null,null,null,null,null,null,null,null,null,"% del Forraje",0,null,null,null,null,null,null,null,null,3,{"$f":"VLOOKUP($AB16,$AB$7:$AQ$13,$AC$5,)","v":"102-Silaje de Sorgo 65%FDN-SiSo65"},null,null,null,null,null,4.5383713284723973E-2,4.4616286715276031E-2,0.09,null,0.376,0.29699999999999999,0.32700000000000001,3.7,5.4776511346716426]
[null,2.4,null,"Mixed",null,null,null,null,null,null,null,null,null,null,null,null,null,"% del Forraje",0.6,null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP($AB17,$AB$7:$AQ$13,$AC$5,)","v":"83-Silaje de Alfalfa 43%FDN-SiAl45"},null,null,null,null,null,3.5759423970563392E-2,0.15924057602943659,0.19500000000000001,null,0.57299999999999995,0.35299999999999998,7.3999999999999996E-2,12.2,5.4776511346716426]
[null,2.5,null,"Proteína Cruda (PC)en la Dieta Proveniente del Forraje",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg/vaca/día",{"$f":"DMI*CP_F","v":2.1457601902402366},null,null,null,null,null,null,null,null,null,null,{"$f":"$Q$14*SUMPRODUCT($S$15:$S$17,AI15:AI17)","v":2.0063864081004343E-2},{"$f":"$Q$14*SUMPRODUCT($S$15:$S$17,AJ15:AJ17)","v":7.0474935918995646E-2},{"$f":"$Q$14*SUMPRODUCT($S$15:$S$17,AK15:AK17)","v":9.06E-2}]
[]
[null,3,"Indicar la Canidad de Concentrados Energéticos en la Dieta y sus Precios (Base MS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Precio",null,null,null,"Dieta Actual",null,null,null,"Límite Máx",null,"Óptimo",null,null,null,"RUP(%)",null,"RDP(%)",null,"CP(%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"($/kgMS)",null,null,null,"(kg/vaca)",null,null,null,"(kg/vaca)",null,"(kg/vaca)"]
[null,3.1,null,"27-Maíz-GM",null,null,null,null,null,null,null,null,null,0.75,null,null,null,6.5,null,null,null,7,null,1.1041529026309658,null,null,null,{"$f":"$X23/DMI*$AI23","v":2.0826332625814232E-3},null,{"$f":"$X23/DMI*$AJ23","v":2.2996867295298875E-3},null,{"$f":"$X23/DMI*$AK23","v":4.3823199921113106E-3},null,null,{"$f":"AK23*(AN23*(AQ23/(AP23+AQ23))+AO23)","v":4.4672120482999476E-2},{"$f":"AK23*(AM23+AN23*(AP23/(AP23+AQ23)))","v":4.9327879517000524E-2},9.4E-2,null,0.23899999999999999,0.72499999999999998,3.5999999999999997E-2,4.9000000000000004,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":7.5315575084259114}]
[null,3.2,null,"116-Trigo-GT",null,null,null,null,null,null,null,null,null,0.7,null,null,null,null,null,null,null,1.5,null,0,null,null,null,{"$f":"$X24/DMI*$AI24","v":0},null,{"$f":"$X24/DMI*$AJ24","v":0},null,{"$f":"$X24/DMI*$AK24","v":0},null,null,{"$f":"AK24*(AN24*(AQ24/(AP24+AQ24))+AO24)","v":3.6724369744435728E-2},{"$f":"AK24*(AM24+AN24*(AP24/(AP24+AQ24)))","v":0.10227563025556428},0.13900000000000001,null,0.27100000000000002,0.65100000000000002,7.8E-2,18.8,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":7.5315575084259114}]
[null,3.3,null,"103-Cáscara de Soja-CS",null,null,null,null,null,null,null,null,null,0.65,null,null,null,0,null,null,null,4,null,4,null,null,null,{"$f":"$X25/DMI*$AI25","v":9.7824860559691806E-3},null,{"$f":"$X25/DMI*$AJ25","v":1.2004477935923116E-2},null,{"$f":"$X25/DMI*$AK25","v":2.17869639918923E-2},null,null,{"$f":"AK25*(AN25*(AQ25/(AP25+AQ25))+AO25)","v":5.7921824339069783E-2},{"$f":"AK25*(AM25+AN25*(AP25/(AP25+AQ25)))","v":7.1078175660930207E-2},0.129,null,0.22500000000000001,0.72199999999999998,5.2999999999999999E-2,6.2,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":7.5315575084259114}]
[]
[null,4,"Indicar la Cantidad de Concentrados Proteicos en la Dieta y sus Precios (Base MS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Precio",null,null,null,"Dieta Actual",null,null,null,"Límite Máx",null,"Óptimo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"($/kgMS)",null,null,null,"(kgMS/vaca)",null,null,null,"(kgMS/vaca)",null,"(kgMS/vaca)"]
[null,4.0999999999999996,null,"106-Harina de Soja Solvente 44%PB-ESjS",null,null,null,null,null,null,null,null,null,1.4,null,null,null,3,null,null,null,4,null,0,null,null,null,{"$f":"$X30/DMI*$AI30","v":0},null,{"$f":"$X30/DMI*$AJ30","v":0},null,{"$f":"$X30/DMI*$AK30","v":0},null,null,{"$f":"AK30*(AN30*(AQ30/(AP30+AQ30))+AO30)","v":0.15339481374237099},{"$f":"AK30*(AM30+AN30*(AP30/(AP30+AQ30)))","v":0.28660518625762899},0.44,null,0.22500000000000001,0.76800000000000002,7.0000000000000001E-3,9.4,{"$f":"2.904+1.375*(DMI/BW)*100-0.02*(100-Forage*100)","v":7.5315575084259114}]
[null,4.2,null,"25-Gluten Meal de Maíz-GMM",null,null,null,null,null,null,null,null,null,1.7,null,null,null,null,null,null,null,0,null,0,null,null,null,0,null,0,null,0,null,null,{"$f":"AK31*(AN31*(AQ31/(AP31+AQ31))+AO31)","v":0.44900882241446199},{"$f":"AK31*(AM31+AN31*(AP31/(AP31+AQ31)))","v":0.15099117758553796},0.6,null,3.9E-2,0.90900000000000003,5.2000000000000005E-2,2.2999999999999998,7.5315575084259114]
[null,4.3,null,"24-Gluten Feed de Maíz Seco-GFM",null,null,null,null,null,null,null,null,null,0.6,null,null,null,null,null,null,null,0,null,0,null,null,null,0,null,0,null,0,null,null,6.0322260567773511E-2,0.1396777394322265,0.2,null,0.48,0.43200000000000005,8.8000000000000009E-2,7.7,7.5315575084259114]
[null,4.4000000000000004,null,"111-Harina de Girasol Solvente 34%PB-EGiS",null,null,null,null,null,null,null,null,null,0.7,null,null,null,null,null,null,null,3,null,0,null,null,null,0,null,0,null,0,null,null,5.4489362184069308E-2,0.28551063781593072,0.34,null,0.42,0.52800000000000002,5.1999999999999998E-2,29.2,7.5315575084259114]
[null,4.5,null,"37-Semilla de Algodón-SeAlg",null,null,null,null,null,null,null,null,null,0.63,null,null,null,2,null,null,null,3,null,6.5003931787395025E-2,null,null,null,1.3659072384156383E-4,null,4.5625322456078901E-4,null,5.9284394840235287E-4,null,null,4.9766209858912502E-2,0.1662337901410875,0.216,null,0.45400000000000001,0.46700000000000003,7.9000000000000001E-2,15.7,7.5315575084259114]
[null,4.5999999999999996,null,"104-Harina de Soja Estrujado 42%PB-ESjE",null,null,null,null,null,null,null,null,null,1.35,null,null,null,0,null,null,null,3,null,0.80439808937959711,null,null,null,9.8765563786170994E-3,null,4.388297744548215E-3,null,1.4264854123165313E-2,null,null,0.29079538025438445,0.12920461974561553,0.42,null,8.6999999999999994E-2,0.91299999999999992,0,2.4,7.5315575084259114]
[null,4.7,null,"39-Harina de Algodón Solvente 39%PB-EAlgS",null,null,null,null,null,null,null,null,null,0.8,null,null,null,null,null,null,null,3.5,null,3.5,null,null,null,2.805786993505802E-2,null,3.0315148899808467E-2,null,5.837301883486648E-2,null,null,0.18986269419610818,0.20513730580389186,0.39500000000000002,null,0.25600000000000001,0.55500000000000005,0.189,6.8,7.5315575084259114]
[null,4.8,null,"Urea",null,null,null,null,null,null,null,null,null,2.4,null,null,null,null,null,null,null,0.2,null,0,null,null,null,0,null,0,null,0,null,null,0,2.81,2.81]
[]
[null,5,"Indicar los limites Maximos de PNDR y PDR, y el Precio de la Leche"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limite",null,"Cantidad ",null,null,null,"FCM",null,{"$f":"MP*0.4+MP*0.035*15","v":32.375}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximo",null,"en la dieta",null,null,null,"DMIf",null,{"$f":"SUM(grains,protein)+DMI*Forage","v":23.683887309494889}]
[null,5.0999999999999996,null,"PNDR",null,"Preteina No Degradable en Rumen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% en la Dieta (MS)",7.0000000000000007E-2,null,{"$f":"SUM(AB30:AC37,AB23:AC25,AI18)","v":7.0000000437071636E-2}]
[null,5.2,null,"PDR",null,"Prteina Degradable en Rumen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% en la Dieta (MS)",0.12,null,{"$f":"SUM(AD30:AE37,AD23:AE25,AJ18)","v":0.11993880045336612}]
[null,5.3,null,"PB",null,"Proteina Bruta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% en la Dieta (MS)",{"$f":"SUM(V42:V43)","v":0.19},null,{"$f":"SUM(AF30:AG37,AF23:AG25,CP_F)","v":0.19000000089043775}]
[null,5.4,null,"Precio de la Leche",null,null,null,null,null,null,null,null,"$/Lt",1.4]
[]
[null,6,"Resultado de la Optimizacion, Maximiza el MSCSC"]
[null,6.1,null,"Hacer Click en el boton para Maximizar el Margen"]
[null,null,null,"Sobre los Gastos en Concentrados"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual",null,"Optimizada"]
[null,6.2,null,"Produccion de Leche Esperada",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lts/vaca/dia",37.42244023844308,null,{"$f":"-55.61+1.15*AD41+8.79*X43*100-0.36*(X43*100)^2+1.85*X42*100","v":38.215539010193638}]
[null,6.3,null,"Maximo Margen Sobre los Gastos en Concentrados (MSGC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/vaca/dia",42.056416333820309,null,{"$f":"(fMP*MPrice)-(SUMPRODUCT(protein,N30:N37)+SUMPRODUCT(grains,N23:N25))","v":46.146750039609351}]
[]
[]
[null,7,"Analisis de Sustitucion de Energía y Proteína"]
[null,7.1,null,"Seleccionar el Suplemento Energetico",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,7.2,null,"Selecionar el Suplemento Proteico o Subproducto",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"7.3.a",null,"Seleccionar una opcion para hacer un analisis de sensibilidad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"7.3.b",null,"Definir la maxima y minima variacion en los precios ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑",0.50000000000000022,null,"↓",0.25000000000000006]
[null,7.4,null,"Hacer Click en el Boton para actualizar los resultados "]
[null,null,null,"de las Secciones 8,9 y 10."]
[]
[null,8,"MSGC y Producción de Leche al Sustituir Energía por Proteína/Subproductos"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,9,"Cambios en MSGC según la Máxima y Mínima variación de Precios Seleccionada"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"X23","v":1.1041529026309658},null,{"$f":"X30","v":0},null,{"$f":"X42","v":7.0000000437071636E-2},null,{"$f":"X43","v":0.11993880045336612},null,{"$f":"X44","v":0.19000000089043775},null,{"$f":"X51","v":38.215539010193638},null,null,null,null,null,{"$f":"X52","v":46.146750039609351},null,null,null,{"$f":"X52","v":46.146750039609351},null,{"$f":"X52","v":46.146750039609351}]
[null,10,"MSGC y Producción de Leche según la Sustitución de Alimentos Concentrados y la Variación de Precios Seleccionados"]
[null,"Conc. Energético (KgMS)",null,"Conc. Proteico (KgMS)",null,"PNDR",null,"PDR",null,"PB",null,"Leche",null,null,null,null,null,"MSGCbase       ($/Vaca/día)",null,null,null,"MSGCBajoPrecio       ($/Vaca/día)",null,"MSGCAltoPrecio     ($/Vaca/día)"]
[null,7.8946291031649611,null,1.5789258206329928,null,4.51808918248289E-2,null,0.10602457484183775,null,0.15126666666666666,null,32.712178986075003,null,null,null,null,null,37.665582604245088,null,null,null,38.770830678688185,null,37.11295856702354]
[null,7.751090392198325,null,1.7224645315996285,null,4.5839817238522061E-2,null,0.10746261912511429,null,0.15336363636363637,null,32.992906572795391,null,null,null,null,null,37.965301063525317,null,null,null,39.171026235645058,null,37.362438477465453]
[null,7.6075516812316897,null,1.8660032425662643,null,4.6498742652215222E-2,null,0.10890066340839083,null,0.15546060606060608,null,33.258744765719001,null,null,null,null,null,38.244174371490061,null,null,null,39.550376641286448,null,37.591073236591868]
[null,7.4640129702650544,null,2.0095419535328998,null,4.715766806590839E-2,null,0.11033870769166737,null,0.15755757575757579,null,33.509693564845804,null,null,null,null,null,38.502202528139271,null,null,null,39.908881895612303,null,37.798862844402755]
[null,7.3204742592984182,null,2.1530806644995355,null,4.7816593479601543E-2,null,0.11177675197494391,null,0.15965454545454547,null,33.745752970175836,null,null,null,null,null,38.739385533472998,null,null,null,40.246541998622675,null,37.985807300898166]
[null,7.176935548331782,null,2.2966193754661712,null,4.8475518893294704E-2,null,0.11321479625822044,null,0.16175151515151515,null,33.966922981709097,null,null,null,null,null,38.955723387491254,null,null,null,40.563356950317576,null,38.151906606078093]
[null,7.0333968373651468,null,2.440158086432807,null,4.9134444306987865E-2,null,0.11465284054149698,null,0.16384848484848485,null,34.173203599445543,null,null,null,null,null,39.151216090193969,null,null,null,40.859326750696937,null,38.297160759942486]
[null,6.8898581263985115,null,2.5836967973994427,null,4.9793369720681033E-2,null,0.1160908848247735,null,0.16594545454545456,null,34.364594823385247,null,null,null,null,null,39.325863641581236,null,null,null,41.134451399760849,null,38.42156976249143]
[null,6.7463194154318753,null,2.7272355083660784,null,5.0452295134374187E-2,null,0.11752892910805005,null,0.16804242424242427,null,34.541096653528143,null,null,null,null,null,39.479666041652983,null,null,null,41.388730897509234,null,38.525133613724854]
[null,6.6027807044652391,null,2.8707742193327141,null,5.1111220548067347E-2,null,0.11896697339132659,null,0.17013939393939395,null,34.702709089874247,null,null,null,null,null,39.612623290409211,null,null,null,41.622165243942113,null,38.607852313642759]
[null,6.4592419934986038,null,3.0143129302993499,null,5.1770145961760508E-2,null,0.12040501767460313,null,0.17223636363636363,null,34.849432132423573,null,null,null,null,null,39.724735387849961,null,null,null,41.834754439059502,null,38.669725862245187]
[null,6.3157032825319686,null,3.1578516412659856,null,5.2429071375453669E-2,null,0.12184306195787965,null,0.17433333333333334,null,34.981265781176141,null,null,null,null,null,39.816002333975241,null,null,null,42.026498482861427,null,38.710754259532145]
[null,6.1721645715653324,null,3.3013903522326213,null,5.308799678914683E-2,null,0.12328110624115619,null,0.17643030303030305,null,35.098210036131889,null,null,null,null,null,39.886424128784974,null,null,null,42.197397375347812,null,38.730937505503555]
[null,6.0286258605986962,null,3.4449290631992571,null,5.374692220283999E-2,null,0.12471915052443273,null,0.17852727272727276,null,35.200264897290893,null,null,null,null,null,39.936000772279264,null,null,null,42.347451116518748,null,38.73027560015953]
[null,5.8850871496320609,null,3.5884677741658928,null,5.4405847616533151E-2,null,0.12615719480770926,null,0.18062424242424246,null,35.287430364653105,null,null,null,null,null,39.96473226445805,null,null,null,42.476659706374171,null,38.708768543499986]
[null,5.7415484386654256,null,3.7320064851325285,null,5.5064773030226312E-2,null,0.1275952390909858,null,0.18272121212121215,null,35.359706438218517,null,null,null,null,null,39.972618605321315,null,null,null,42.585023144914089,null,38.666416335524929]
[null,5.5980097276987895,null,3.8755451960991643,null,5.572369844391948E-2,null,0.12903328337426234,null,0.18481818181818183,null,35.417093117987136,null,null,null,null,null,39.959659794869061,null,null,null,42.67254143213848,null,38.603218976234359]
[null,5.4544710167321542,null,4.0190839070657995,null,5.638262385761264E-2,null,0.13047132765753888,null,0.18691515151515153,null,35.459590403958998,null,null,null,null,null,39.925855833101366,null,null,null,42.739214568047423,null,38.519176465628334]
[null,5.3109323057655189,null,4.1626226180324348,null,5.7041549271305794E-2,null,0.13190937194081542,null,0.18901212121212121,null,35.487198296134054,null,null,null,null,null,39.871206720018122,null,null,null,42.785042552640824,null,38.414288803706768]