{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","STTD P Energy equation","NRC 2012","Finisher Model - NE Metric","Current Performance - NE ","FW - Projected Performance - NE","FT - Projected Performance - NE","Finisher Model - ME Metric","Current Performance - ME","FW - Projected Performance - ME","FT - Projected Performance - ME"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":1,"defined_names":1,"comments":2,"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":"Instructions","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,1,10]]}
["            Economic model for optimum phosphorus level "]

{"sheet":"STTD P Energy equation","index":1,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Trial"]
["Start_wt_kg","End_wt_kg","Avg wt_kg","Avg_NE_kcal_kg","Avg_NE_kcal_lb","STTD P req","STTDP_NE_kg","Total P","TotalP_NE_kg","Avg_ME_kcal_kg","Avg_ME_kcal_lb","STTD P_ME_kg"]
[11.33980925,24.176473321000003,17.758141285500002,2410,1093,0.43,{"$f":"(F4/D4)*10000","v":1.7842323651452281},0.69,{"$f":"(H4/D4)*10000","v":2.8630705394190867},3265,1481,{"$f":"(F4/J4)*10000","v":1.3169984686064318}]
[24.176473321000003,49.078694434000006,36.627583877500001,2429,1101.6580186568638,0.38,{"$f":"(F5/D5)*10000","v":1.5644298065047344},0.64,{"$f":"(H5/D5)*10000","v":2.6348291477974475},3285,1489.6730937961286,{"$f":"(F5/J5)*10000","v":1.1567732115677321}]
[49.078694434000006,77.337499085000005,63.208096759499995,2496,1131.5498008628074,0.33,{"$f":"(F6/D6)*10000","v":1.3221153846153846},0.56000000000000005,{"$f":"(H6/D6)*10000","v":2.2435897435897441},3300,1496.7264061682447,1]
[75.523129605000008,89.72057078600001,82.621850195500016,2538,1150.2546741567794,0.28999999999999998,{"$f":"(F7/D7)*10000","v":1.1426319936958234},0.51,{"$f":"(H7/D7)*10000","v":2.0094562647754137},3300,1496.7264061682447,0.87878787878787878]
[89.72057078600001,130.40780637500001,110.0641885805,2544,1153.6643178551378,0.26,{"$f":"(F8/D8)*10000","v":1.0220125786163523},0.47,{"$f":"(H8/D8)*10000","v":1.8474842767295596},3309,1501.2897715571009,0.78573587186461169]

{"sheet":"NRC 2012","index":2,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":true,"merged":[[2,1,2,14],[4,1,4,2],[5,1,5,2],[4,3,4,4],[5,3,5,4],[4,5,4,6],[4,7,4,8],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[4,9,4,10],[4,11,4,12],[4,13,4,14]]}
[]
["NRC, 2012. Table 16-1A"]
[null,"Body Weight Range, Kg"]
["Item:",5,7,7,11,11,25,25,50,50,75,75,100,100,135]
["Avg. wt, calculated",6,null,9,null,18,null,37.5,null,62.5,null,87.5,null,117.5]
["P, STTD",0.45,null,0.4,null,0.33,null,0.31,null,0.27,null,0.24,null,0.21]
[]
["Reformatted table for Regression Analysis"]
[]
["Growth Stage","Avg. wt, kg","Wt*Wt","P, STTD"]
["Early growth",6,36,0.45]
[null,9,81,0.4]
["Grow-finish",18,324,0.33]
[null,37.5,1406.25,0.31]
[null,62.5,3906.25,0.27]
[null,87.5,7656.25,0.24]
[null,117.5,13806.25,0.21]
[]
["Growth Stage","Avg. wt, kg","Wt*Wt","P, STTD"]
["Grow-finish",18,324,0.33]
[null,37.5,1406.25,0.31]
[null,62.5,3906.25,0.27]
[null,87.5,7656.25,0.24]
[null,117.5,13806.25,0.21]
[]
[]
["SUMMARY OUTPUT"]
[]
["Regression Statistics"]
["Multiple R",0.99656093246964184]
["R Square",0.99313369212476199]
["Adjusted R Square",0.99084492283301595]
["Standard Error",4.7069402741166553E-3]
["Observations",5]
[]
["ANOVA"]
[null,"df","SS","MS","F","Significance F"]
["Regression",1,9.6135341397676991E-3,9.6135341397676991E-3,433.91603326132571,2.4197514080650506E-4]
["Residual",3,6.6465860232304113E-5,2.2155286744101371E-5]
["Total",4,9.6800000000000028E-3]
[]
[null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
["Intercept",0.35222662516845271,4.3890930381389288E-3,80.250434909396333,4.2646740825928458E-6,0.33825857224568101,0.36619467809122441,0.33825857224568101,0.36619467809122441]
["X Variable 1",-1.2418982224218697E-3,5.9618789878213777E-5,-20.830651292298217,2.4197514080650528E-4,-1.431631819995277E-3,-1.0521646248484624E-3,-1.431631819995277E-3,-1.0521646248484624E-3]
[]
[]
[]
["RESIDUAL OUTPUT"]
[null,null,null,null,null,null,"Avg. wt, kg","Actual","Linear","Exponential"]
["Observation","Predicted Y","Residuals","Standard Residuals",null,null,18,0.33,{"$f":" -0.0012418982*G50 + 0.3522266252","v":0.32987245759999995},{"$f":" 0.3627881688*EXP(-0.0046664463*G50)","v":0.33356010483312182}]
[1,0.32987245716485908,1.2754283514093689E-4,3.1288644390393264E-2,null,null,37.5,0.31,{"$f":" -0.0012418982*G51 + 0.3522266252","v":0.3056554427},{"$f":" 0.3627881688*EXP(-0.0046664463*G51)","v":0.30454759204592941}]
[2,0.3056554418276326,4.3445581723673965E-3,1.0658014269352694,null,null,62.5,0.27,0.27460798769999994,0.27101284361078137]
[3,0.27460798626708582,-4.6079862670858063E-3,-1.1304252685565981,null,null,87.5,0.24,0.24356053269999997,0.2411707178788825]
[4,0.2435605307065391,-3.5605307065391112E-3,-0.87346481670157727,null,null,117.5,0.21,0.20630358669999999,{"$f":" 0.3627881688*EXP(-0.0046664463*G54)","v":0.20966513581667967}]
[5,0.20630358403388302,3.6964159661169727E-3,0.90680001393260812]

{"sheet":"Finisher Model - NE Metric","index":3,"n_rows":66,"n_cols":29,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,1,9],[5,0,5,2],[14,4,14,5],[36,23,36,24],[5,23,5,24],[9,23,9,24],[13,23,13,24],[17,23,17,24],[21,23,21,24],[27,5,27,7],[38,17,38,18],[39,17,39,18],[37,17,37,19],[13,0,13,2],[6,0,6,2],[7,0,7,2],[9,0,9,2],[10,0,10,2],[8,0,8,2],[23,1,23,3],[14,7,14,8],[24,1,24,3],[25,1,25,3],[23,5,23,7],[24,5,24,7],[25,5,25,7]]}
["            Economic model for optimum phosphorus levels"]
[]
[]
["Input (please fill yellow cells)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STTD P","0.000047291257153852600x2 - 0.014390782029002800000x + 2.027514542222900000000"]
[]
["Economic evaluation criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slot (Phase) 1"]
["Live pig price, $/kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STTD P:NE"]
["Carcass price, $/kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,"Barrows and Gilts",{"$f":"0.0000472912571538526*(U17*U17)- 0.0143907820290028*U17 + 2.0275145422229","v":{"$error":"#VALUE!"}}]
["Current carcass yield, %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Live",3]
["Facility cost, $/pig/day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carcass",4,null,null,null,"Slot (Phase) 2"]
["Number of phases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,"STTD P:NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,"Barrows and Gilts",{"$f":"0.0000472912571538526*(U18*U18) - 0.0143907820290028*U18 + 2.0275145422229","v":{"$error":"#VALUE!"}}]
[]
["Gender",null,null,"Barrows and gilts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slot (Phase) 3"]
[null,null,null,null,"Current diets",null,null,"Maximal growth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STTD P:NE"]
[null,"BW, kg",null,"Energy, kcal NE/kg","STTD P, % ","$/ton",null,"STTD P, %","$/ton",null,null,null,null,null,null,"Biological % of NRC",null,"Current % of NRC",null,null,"Avg Wt, kg","Gain, kg","NRC, % STTD P","Barrows and Gilts",{"$f":"0.0000472912571538526*(U19*U19) - 0.0143907820290028*U19 + 2.0275145422229","v":{"$error":"#VALUE!"}}]
["Phase 1",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$7:$Y$8,2,FALSE)*D17/10000,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IFERROR(H17/W17,\"\")","v":""},null,{"$f":"IFERROR(E17/W17,\"\")","v":""},null,"Slot (phase 1)",{"$f":"IFERROR(AVERAGE(B17:C17),\"\")","v":""},{"$f":"IF(C17-B17=0,0,C17-B17)","v":0},{"$f":" -0.0012418982*U17+ 0.3522266252","v":{"$error":"#VALUE!"}}]
["Phase 2",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$11:$Y$12,2,FALSE)*D18/10000,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,"Slot (phase 2)","",0,{"$error":"#VALUE!"},"Slot (Phase) 4"]
["Phase 3",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$15:$Y$16,2,FALSE)*D19/10000,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,"Slot (phase 3)","",0,{"$error":"#VALUE!"},null,"STTD P:NE"]
["Phase 4",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$19:$Y$20,2,FALSE)*D20/10000,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,"Slot (phase 4)","",0,{"$error":"#VALUE!"},"Barrows and Gilts",{"$f":"0.0000472912571538526*(U20*U20) - 0.0143907820290028*U20 + 2.0275145422229","v":{"$error":"#VALUE!"}}]
["Phase 5",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$34:$Y$35,2,FALSE)*D21/10000,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,"Slot (phase 5)","",0,{"$error":"#VALUE!"}]
["Phase 6",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$38:$Y$39,2,FALSE)*D22/10000,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,"Slot (phase 6)","",0,{"$error":"#VALUE!"},"Slot (Phase) 5"]
[]
[null,"Performance Output",null,null,null,"Economics Output"]
[null,"Performance difference between maximal growth and current diets, %",null,null,null,"Net profit difference between maximal growth and current diets, $/pig"]
[null,"Fixed Weight (space long)",null,null,null,"Fixed Weight (space long)"]
[null,"Growth rate",null,{"$f":"IFERROR(E58,\"\")","v":""},null,{"$f":"IF($D$10>0,\"IOFFC\",\"IOFC\")","v":"IOFC"},null,{"$f":"IFERROR(IF($F$27=\"IOFC\",$E$65,$E$66),\"\")","v":""}]
[null,"Feed efficiency",null,{"$f":"IFERROR(E59,\"\")","v":""},null,"Fixed Time (space short)"]
[null,"Carcass yield",null,{"$f":"IFERROR(E60,\"\")","v":""},null,"IOFC",null,{"$f":"IFERROR(K65,\"\")","v":""}]
[null,"Fixed Time (space short)"]
[null,"Growth rate",null,{"$f":"IFERROR(K58,\"\")","v":""}]
[null,"Feed efficiency",null,{"$f":"IFERROR(K59,\"\")","v":""}]
[null,"Carcass yield",null,{"$f":"IFERROR(K60,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total gain",{"$f":"SUM(V17:V22)","v":0},null,null,"STTD P:NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barrows and Gilts",{"$f":"0.0000472912571538526*(U21*U21) - 0.0143907820290028*U21 + 2.0275145422229","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slot (Phase) 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADG response",null,null,null,null,null,null,"STTD P:NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optimum STTD Ca:STTD P",null,2.48,null,null,null,"Barrows and Gilts",{"$f":"0.0000472912571538526*(U22*U22) - 0.0143907820290028*U22 + 2.0275145422229","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optimum STTD Ca:STTD P",null,1.7849999999999999]
[]
[]
[]
[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,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Output - Fixed Weight (space long)",null,null,null,null,null,"Output - Fixed Time (space short)"]
[null,null,"Maximal Growth","Current",null,null,null,null,"Maximal Growth","Current"]
["% of maximum ADG",null,1,{"$f":"'Current Performance - NE '!K5/'FW - Projected Performance - NE'!K6","v":{"$error":"#VALUE!"}},{"$f":"(D58-C58)/D58","v":{"$error":"#VALUE!"}},null,"% of maximum ADG",null,1,{"$f":"'Current Performance - NE '!K5/'FT - Projected Performance - NE'!K5","v":{"$error":"#VALUE!"}},{"$f":"(J58-I58)/J58","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["% of maximum feed efficiency",null,1,{"$f":"'FW - Projected Performance - NE'!K7/'Current Performance - NE '!K6","v":{"$error":"#VALUE!"}},{"$f":"(D59-C59)/D59","v":{"$error":"#VALUE!"}},null,"% of maximum feed efficiency",null,1,{"$f":"'FT - Projected Performance - NE'!K6/'Current Performance - NE '!K6","v":{"$error":"#VALUE!"}},{"$f":"(J59-I59)/J59","v":{"$error":"#VALUE!"}}]
["Carcass yield",null,{"$f":"'FW - Projected Performance - NE'!B43","v":{"$error":"#N/A"}},{"$f":"'Current Performance - NE '!B36","v":{"$error":"#N/A"}},{"$f":"(D60-C60)/D60","v":{"$error":"#N/A"}},null,"Carcass yield",null,{"$f":"'FT - Projected Performance - NE'!B33","v":{"$error":"#N/A"}},{"$f":"'Current Performance - NE '!B36","v":{"$error":"#N/A"}},{"$f":"(J60-I60)/J60","v":{"$error":"#N/A"}}]
["Economics, $/pig",null,null,null,null,null,"Economics, $/pig"]
["  Total feed cost",null,{"$f":"IF(D6=\"Live\",'FW - Projected Performance - NE'!K11,'FW - Projected Performance - NE'!K22)","v":""},{"$f":"'Current Performance - NE '!K10","v":""},null,null,"  Total feed cost",null,{"$f":"'FT - Projected Performance - NE'!K10","v":""},{"$f":"'Current Performance - NE '!K10","v":""}]
["  Total feed and facility cost",null,{"$f":"IF(D13=\"Live\",'FW - Projected Performance - NE'!K12,'FW - Projected Performance - NE'!K23)","v":""},{"$f":"'Current Performance - NE '!K11","v":""},null,null,"  Total feed and facility cost",null,{"$f":"'FT - Projected Performance - NE'!K11","v":""},{"$f":"'Current Performance - NE '!K11","v":""}]
["  Total revenue",null,{"$f":"IF($D$6=\"Live\",'FW - Projected Performance - NE'!K13,'FW - Projected Performance - NE'!K24)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - NE '!K12,'Current Performance - NE '!K15)","v":""},"Difference",null,"  Total revenue",null,{"$f":"IF($D$6=\"Live\",'FT - Projected Performance - NE'!K12,'FT - Projected Performance - NE'!K16)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - NE '!K12,'Current Performance - NE '!K15)","v":""},"Difference"]
["  IOFC",null,{"$f":"IF(D15=\"Live\",'FW - Projected Performance - NE'!K14,'FW - Projected Performance - NE'!K25)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - NE '!K13,'Current Performance - NE '!K16)","v":""},{"$f":"C65-D65","v":{"$error":"#VALUE!"}},null,"  IOFC",null,{"$f":"IF($D$6=\"Live\",'FT - Projected Performance - NE'!K13,'FT - Projected Performance - NE'!K17)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - NE '!K13,'Current Performance - NE '!K16)","v":""},{"$f":"I65-J65","v":{"$error":"#VALUE!"}}]
["  IOFFC",null,{"$f":"IF($D$6=\"Live\",'FW - Projected Performance - NE'!K15,'FW - Projected Performance - NE'!K26)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - NE '!K14,'Current Performance - NE '!K17)","v":""},{"$f":"C66-D66","v":{"$error":"#VALUE!"}},null,"  IOFFC",null,{"$f":"IF($D$6=\"Live\",'FT - Projected Performance - NE'!K14,'FT - Projected Performance - NE'!K18)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - NE '!K14,'Current Performance - NE '!K17)","v":""},{"$f":"I66-J66","v":{"$error":"#VALUE!"}}]

{"sheet":"Current Performance - NE ","index":4,"n_rows":96,"n_cols":16,"rows_kept":96,"cut":false,"hidden":true,"merged":[[39,1,39,4],[0,0,0,14],[1,0,3,0],[1,9,2,10],[38,1,38,4],[1,1,2,6]]}
["Economic model for optimum phosphorus level - Model Calculations by phase"]
["Item","Dietary phase",null,null,null,null,null,null,null,"Summary of Calculations with Current Phosphorus Levels"]
[]
[null,1,2,3,4,5,6,null,null,"Item","Output",2,3,4,5,6]
["Starting weight, kg",{"$f":"'Finisher Model - NE Metric'!B17","v":0},{"$f":"'Finisher Model - NE Metric'!B18","v":0},{"$f":"'Finisher Model - NE Metric'!B19","v":0},{"$f":"'Finisher Model - NE Metric'!B20","v":0},{"$f":"'Finisher Model - NE Metric'!B21","v":0},{"$f":"'Finisher Model - NE Metric'!B22","v":0},null,null,"Predicted ADG, g",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L5,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M5,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N5,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O5,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P5,\"\")))))","v":""},{"$f":"((SUMPRODUCT($B$11:$C$11,$B$16:$C$16)/SUM($B$16:$C$16))/1000)","v":{"$error":"#VALUE!"}},{"$f":"((SUMPRODUCT($B$11:$D$11,$B$16:$D$16)/SUM($B$16:$D$16))/1000)","v":{"$error":"#VALUE!"}},{"$f":"((SUMPRODUCT($B$11:$E$11,$B$16:$E$16)/SUM($B$16:$E$16))/1000)","v":{"$error":"#VALUE!"}},{"$f":"((SUMPRODUCT($B$11:$F$11,$B$16:$F$16)/SUM($B$16:$F$16))/1000)","v":{"$error":"#VALUE!"}},{"$f":"((SUMPRODUCT($B$11:$G$11,$B$16:$G$16)/SUM($B$16:$G$16))/1000)","v":{"$error":"#VALUE!"}}]
["Final weight, kg",{"$f":"'Finisher Model - NE Metric'!C17","v":0},{"$f":"'Finisher Model - NE Metric'!C18","v":0},{"$f":"'Finisher Model - NE Metric'!C19","v":0},{"$f":"'Finisher Model - NE Metric'!C20","v":0},{"$f":"'Finisher Model - NE Metric'!C21","v":0},{"$f":"'Finisher Model - NE Metric'!C22","v":0},null,null,"Predicted F/G",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L6,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M6,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N6,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O6,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P6,\"\")))))","v":""},{"$f":"SUM($B$17:$C$17)/SUM($B$19:$C$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$D$17)/SUM($B$19:$D$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$E$17)/SUM($B$19:$E$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$F$17)/SUM($B$19:$F$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$G$17)/SUM($B$19:$G$19)","v":{"$error":"#VALUE!"}}]
["Total gain, lg",{"$f":"B6-B5","v":0},{"$f":"C6-C5","v":0},0,0,{"$f":"F6-F5","v":0},{"$f":"G6-G5","v":0},null,null,"Predicted ADFI, kg",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L7,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M7,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N7,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O7,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P7,\"\")))))","v":""},{"$f":"SUM(B17:C17)/SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:D17)/SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:E17)/SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:G17)/SUM(B16:G16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(C17:G17)/SUM(C16:G16)","v":{"$error":"#VALUE!"}}]
["Current NE, kcal/kg",{"$f":"'Finisher Model - NE Metric'!D17","v":0},{"$f":"'Finisher Model - NE Metric'!D18","v":0},{"$f":"'Finisher Model - NE Metric'!D19","v":0},{"$f":"'Finisher Model - NE Metric'!D20","v":0},{"$f":"'Finisher Model - NE Metric'!D21","v":0},{"$f":"'Finisher Model - NE Metric'!D22","v":0},null,null,"Phases duration, d",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L8,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M8,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N8,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O8,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P8,\"\")))))","v":""},{"$f":"SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Current Diet Cost, $/Ton",{"$f":"'Finisher Model - NE Metric'!F17","v":0},{"$f":"'Finisher Model - NE Metric'!F18","v":0},{"$f":"'Finisher Model - NE Metric'!F19","v":0},{"$f":"'Finisher Model - NE Metric'!F20","v":0},{"$f":"'Finisher Model - NE Metric'!F21","v":0},{"$f":"'Finisher Model - NE Metric'!F22","v":0},null,null,"Total feed, kg/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L9,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M9,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N9,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O9,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P9,\"\")))))","v":""},{"$f":"SUM(B17:C17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:E17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:F17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:G17)","v":{"$error":"#VALUE!"}}]
["Average Starting Wt & End Wt, kg",{"$f":"AVERAGE(B5:B6)","v":0},{"$f":"AVERAGE(C5:C6)","v":0},0,{"$f":"AVERAGE(E5:E6)","v":0},{"$f":"AVERAGE(F5:F6)","v":0},{"$f":"AVERAGE(G5:G6)","v":0},null,null,"Total feed cost, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L10,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M10,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N10,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O10,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P10,\"\")))))","v":""},{"$f":"SUM(B18:C18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:D18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:F18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:G18)","v":{"$error":"#VALUE!"}}]
["Calculated Overall ADG with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!R17-216.9*('Finisher Model - NE Metric'!R17*'Finisher Model - NE Metric'!R17),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!R18-216.9*('Finisher Model - NE Metric'!R18*'Finisher Model - NE Metric'!R18),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!R19-216.9*('Finisher Model - NE Metric'!R19*'Finisher Model - NE Metric'!R19),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!R20-216.9*('Finisher Model - NE Metric'!R20*'Finisher Model - NE Metric'!R20),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!R21-216.9*('Finisher Model - NE Metric'!R21*'Finisher Model - NE Metric'!R21),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!R22-216.9*('Finisher Model - NE Metric'!R22*'Finisher Model - NE Metric'!R22),\"\")","v":""},null,null,"Total feed cost & facility cost, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L11,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M11,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N11,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O11,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P11,\"\")))))","v":""},{"$f":"SUM(B21:C21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:D21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:E21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:F21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:G21)","v":{"$error":"#VALUE!"}}]
["Calculated Overall G:F with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!R17-46.7864*('Finisher Model - NE Metric'!R17*'Finisher Model - NE Metric'!R17),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!R18-46.7864*('Finisher Model - NE Metric'!R18*'Finisher Model - NE Metric'!R18),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!R19-46.7864*('Finisher Model - NE Metric'!R19*'Finisher Model - NE Metric'!R19),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!R20-46.7864*('Finisher Model - NE Metric'!R20*'Finisher Model - NE Metric'!R20),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!R21-46.7864*('Finisher Model - NE Metric'!R21*'Finisher Model - NE Metric'!R21),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!R22-46.7864*('Finisher Model - NE Metric'!R22*'Finisher Model - NE Metric'!R22),\"\")","v":""},null,null,"Revenue Live, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L12,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M12,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N12,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O12,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P12,\"\")))))","v":""},{"$f":"SUM(B19:C19,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:D19,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:E19,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:F19,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:G19,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}}]
["Predicted Overall ADFI, g/d",{"$f":"(B11/B12)*1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFC Live, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L13,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M13,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N13,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O13,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P13,\"\")))))","v":""},{"$f":"L12-L10","v":{"$error":"#VALUE!"}},{"$f":"M12-M10","v":{"$error":"#VALUE!"}},{"$f":"N12-N10","v":{"$error":"#VALUE!"}},{"$f":"O12-O10","v":{"$error":"#VALUE!"}},{"$f":"P12-P10","v":{"$error":"#VALUE!"}}]
["Precited Overall F/G",{"$f":"B13/B11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFFC Live, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L14,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M14,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N14,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O14,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P14,\"\")))))","v":""},{"$f":"L12-L11","v":{"$error":"#VALUE!"}},{"$f":"M12-M11","v":{"$error":"#VALUE!"}},{"$f":"N12-N11","v":{"$error":"#VALUE!"}},{"$f":"O12-O11","v":{"$error":"#VALUE!"}},{"$f":"P12-P11","v":{"$error":"#VALUE!"}}]
["Overall average F/G (weighted average based on phase duration)",{"$f":"IF('Finisher Model - NE Metric'!D11=2,(SUMPRODUCT(B14:C14,B16:C16)/SUM(B16:C16)),IF('Finisher Model - NE Metric'!D11=3,(SUMPRODUCT(B14:D14,B16:D16)/SUM(B16:D16)),IF('Finisher Model - NE Metric'!D11=4,(SUMPRODUCT(B14:E14,B16:E16)/SUM(B16:E16)),IF('Finisher Model - NE Metric'!D11=5,(SUMPRODUCT(B14:F14,B16:F16)/SUM(B16:F16)),IF('Finisher Model - NE Metric'!D11=6,(SUMPRODUCT(B14:G14,B16:G16)/SUM(B16:G16)),\"\")))))","v":""},null,null,null,null,null,null,null,"Revenue Carcass, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L15,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M15,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N15,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O15,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P15,\"\")))))","v":""},{"$f":"C28*'Finisher Model - NE Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"D28*'Finisher Model - NE Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"E28*'Finisher Model - NE Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"F28*'Finisher Model - NE Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"G28*'Finisher Model - NE Metric'!$D$8","v":{"$error":"#VALUE!"}}]
["Phase duration, d",{"$f":"(CONVERT(B7,\"kg\",\"g\"))/B11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUM(B16:C16),IF('Finisher Model - NE Metric'!D11=3,SUM(B16:D16),IF('Finisher Model - NE Metric'!D11=4,SUM(B16:E16),IF('Finisher Model - NE Metric'!D11=5,SUM(B16:F16),IF('Finisher Model - NE Metric'!D11=6,SUM(B16:G16),\"\")))))","v":""},null,"Total IOFC Carcass, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L16,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M16,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N16,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O16,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P16,\"\")))))","v":""},{"$f":"L15-L10","v":{"$error":"#VALUE!"}},{"$f":"M15-M10","v":{"$error":"#VALUE!"}},{"$f":"N15-N10","v":{"$error":"#VALUE!"}},{"$f":"O15-O10","v":{"$error":"#VALUE!"}},{"$f":"P15-P10","v":{"$error":"#VALUE!"}}]
["Feed budget by phase, kg/pig",{"$f":"CONVERT(D45,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D46,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D47,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D48,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D49,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D50,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},null,null,"Total IOFFC Carcass $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,'Current Performance - NE '!L17,IF('Finisher Model - NE Metric'!$D$11=3,'Current Performance - NE '!M17,IF('Finisher Model - NE Metric'!$D$11=4,'Current Performance - NE '!N17,IF('Finisher Model - NE Metric'!$D$11=5,'Current Performance - NE '!O17,IF('Finisher Model - NE Metric'!$D$11=6,'Current Performance - NE '!P17,\"\")))))","v":""},{"$f":"L15-L11","v":{"$error":"#VALUE!"}},{"$f":"M15-M11","v":{"$error":"#VALUE!"}},{"$f":"N15-N11","v":{"$error":"#VALUE!"}},{"$f":"O15-O11","v":{"$error":"#VALUE!"}},{"$f":"P15-P11","v":{"$error":"#VALUE!"}}]
["Total feed cost per phase, $/pig",{"$f":"(B17*(B9/907))","v":{"$error":"#VALUE!"}},{"$f":"(C17*(C9/907))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Gain, kg",{"$f":"B11/1000*B16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUM(B19:C19)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=3,SUM(B19:D19)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=4,SUM(B19:E19)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=5,SUM(B19:F19)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=6,SUM(B19:G19)+'Finisher Model - NE Metric'!B17,\"\")))))","v":""}]
["Feed cost per/kg of gain, $/pig",{"$f":"B18/((B11/1000)*B16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Feed and facility cost, $/pig",{"$f":"B18+(B16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"C18+(C16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"D18+(D16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"E18+(E16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"F18+(F16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"G18+(G16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}}]
[]
["Revenue per pig by phase, $/pig",{"$f":"B19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"C19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"D19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"E19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"F19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"G19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}}]
["IOFC by phase, $/pig",{"$f":"B23-B18","v":{"$error":"#VALUE!"}},{"$f":"C23-C18","v":{"$error":"#VALUE!"}},{"$f":"D23-D18","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["IOFFC by phase, $/pig",{"$f":"B23-B21","v":{"$error":"#VALUE!"}},{"$f":"C23-C21","v":{"$error":"#VALUE!"}},{"$f":"D23-D21","v":{"$error":"#VALUE!"}},{"$f":"E23-E21","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["STTD P",{"$f":"'Finisher Model - NE Metric'!R17","v":""},{"$f":"'Finisher Model - NE Metric'!R18","v":""},{"$f":"'Finisher Model - NE Metric'!R19","v":""},{"$f":"'Finisher Model - NE Metric'!R20","v":""},{"$f":"'Finisher Model - NE Metric'!R21","v":""},{"$f":"'Finisher Model - NE Metric'!R22","v":""}]
["Weighted average of STTD P",{"$f":"SUMPRODUCT(B26,B17)/SUM(B17)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B26:C26,B17:C17)/SUM(B17:C17)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B26:D26,B17:D17)/SUM(B17:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B26:E26,B17:E17)/SUM(B17:E17)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B26:F26,B17:F17)/SUM(B17:F17)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B26:G26,B17:G17)/SUM(B17:G17)","v":{"$error":"#VALUE!"}}]
["Calculated Overall HCW, lb based on final BW and corrected yield",{"$f":"$H$19*B36/100","v":{"$error":"#VALUE!"}},{"$f":"$H$19*C36/100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Yield based on final body weight and PIC equation",{"$f":"(VLOOKUP($H$19,$C$57:$I$96,7,TRUE))*100","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($H$19,$C$57:$I$96,7,TRUE))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["User yield",{"$f":"'Finisher Model - NE Metric'!D9","v":0}]
["User/PIC ratio",{"$f":"B30/B29","v":{"$error":"#N/A"}}]
["Current STTD P as a % of NRC",{"$f":"'Finisher Model - NE Metric'!R17","v":""},{"$f":"'Finisher Model - NE Metric'!R18","v":""},{"$f":"'Finisher Model - NE Metric'!R19","v":""},{"$f":"'Finisher Model - NE Metric'!R20","v":""},{"$f":"'Finisher Model - NE Metric'!R21","v":""},{"$f":"'Finisher Model - NE Metric'!R22","v":""},{"$f":"IF('Finisher Model - NE Metric'!D11=2,(SUMPRODUCT(B32:C32,B16:C16)/SUM(B16:C16)),IF('Finisher Model - NE Metric'!D11=3,(SUMPRODUCT(B32:D32,B16:D16)/SUM(B16:D16)),IF('Finisher Model - NE Metric'!D11=4,(SUMPRODUCT(B32:E32,B16:E16)/SUM(B16:E16)),IF('Finisher Model - NE Metric'!D11=5,(SUMPRODUCT(B32:F32,B16:F16)/SUM(B16:F16)),IF('Finisher Model - NE Metric'!D11=6,(SUMPRODUCT(B32:G32,B16:G16)/SUM(B16:G16)),\"\")))))","v":""}]
["Predicted yield based on STTD P level",{"$f":"73.859-1.19192*H32","v":{"$error":"#VALUE!"}}]
["Yield at 100% of NRC",{"$f":"73.859-1.19192*1","v":72.667079999999999}]
["Yield correction factor based on STTD P level",{"$f":"B33/$B$34","v":{"$error":"#VALUE!"}}]
["Corrected current yield",{"$f":"(VLOOKUP($H$19,$C$57:$K$96,9,TRUE))","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($H$19,$C$57:$K$96,9,TRUE))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[null,"Mixed Sex Feed Budget",null,null,null,null,null,null,null,"Yield equation"]
[null,"Closeout Feed Efficiency",null,null,null,null,null,null,null,"73.859 - 1.19192 x STTD P % of NRC"]
[null,"Initial Wt","Final Wt","F/G"]
[null,{"$f":"CONVERT('Finisher Model - NE Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT(IF('Finisher Model - NE Metric'!$D$11=2,'Finisher Model - NE Metric'!C18,IF('Finisher Model - NE Metric'!$D$11=3,'Finisher Model - NE Metric'!C19,IF('Finisher Model - NE Metric'!$D$11=4,'Finisher Model - NE Metric'!C20,IF('Finisher Model - NE Metric'!$D$11=5,'Finisher Model - NE Metric'!C21,IF('Finisher Model - NE Metric'!$D$11=6,'Finisher Model - NE Metric'!C22,\"\"))))),\"kg\",\"lbm\")","v":{"$error":"#VALUE!"}},{"$f":"B15","v":""}]
[]
[null,"Initial Wt","Final Wt","lb/pig",{"$f":"IF(B45=0,F44,((0.00463*B45^2 + 1.68*B45 - 22.05)/(((0.00463*C42^2 + 1.68*C42 - 22.05)-(0.00463*B42^2 + 1.68*B42 - 22.05))/(C42-B42))*D42))","v":0}]
[1,{"$f":"CONVERT('Finisher Model - NE Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT('Finisher Model - NE Metric'!C17,\"kg\",\"lbm\")","v":0},{"$f":"IF(C45=\"\",\"\",(E45-E44))","v":{"$error":"#VALUE!"}},{"$f":"IF(B46=\"\",\"\",((0.00463*B46^2 + 1.68*B46 - 22.05)/(((0.00463*$C$42^2 + 1.68*$C$42 - 22.05)-(0.00463*$B$42^2 + 1.68*$B$42 - 22.05))/($C$42-$B$42))*$D$42))","v":{"$error":"#VALUE!"}}]
[2,{"$f":"C45","v":0},{"$f":"CONVERT('Finisher Model - NE Metric'!C18,\"kg\",\"lbm\")","v":0},{"$f":"IF(C46=\"\",\"\",(E46-E45))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[3,0,{"$f":"CONVERT('Finisher Model - NE Metric'!C19,\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,0,{"$f":"CONVERT('Finisher Model - NE Metric'!C20,\"kg\",\"lbm\")","v":0},{"$f":"IF(C48=\"\",\"\",(E48-E47))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[5,0,{"$f":"CONVERT('Finisher Model - NE Metric'!C21,\"kg\",\"lbm\")","v":0},{"$f":"IF(C49=\"\",\"\",(E49-E48))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[6,0,{"$f":"CONVERT('Finisher Model - NE Metric'!C22,\"kg\",\"lbm\")","v":0},{"$f":"IF(C50=\"\",\"\",(E50-E49))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,0]
[]
[]
[]
[null,"Hot Carcass Wheight","Market weight    (est. by Carcass yield)","Back Fat for PIC 337",null,null,null,null,"Carcass Yield (%) =                                   66.411 + ( Carcass weight, kg x 0.0878)"]
[null,"kg","kg","Barrows","Gilts","Average",null,null,null,"User/PIC Adjusted Yield","User/PIC Asjusted and STTD P adjusted"]
[null,81,110.17670623134534,16.864782047899471,14.510728742835685,15.687755395367578,null,null,0.73518262408316082,{"$f":"($B$31*I57)*100","v":{"$error":"#N/A"}},{"$f":"J57*$B$35","v":{"$error":"#N/A"}}]
[null,82,111.4039519642067,17.074455706764272,14.613701440729169,15.844078573746721,null,null,0.73606006388665657,{"$f":"($B$31*I58)*100","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,83,112.6282752396024,17.284147265806148,14.71614342750836,16.000145346657256,null,null,0.73693750369015243,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,84,113.84968648405146,17.493856510850449,14.81806378371237,16.155960147281409,null,null,0.73781494349364829,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,85,115.06819607453319,17.703583232804778,14.919471328516645,16.311527280660712,null,null,0.73869238329714404,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,86,116.28381433878111,17.913327227479776,15.020374630235036,16.466850928857404,null,null,0.7395698231006399,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,87,117.49655155557477,18.123088295418643,15.120782016283018,16.621935155850831,null,null,0.74044726290413565,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,88,118.70641795502937,18.332866241734184,15.220701582635391,16.776783912184786,null,null,0.74132470270763151,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,89,119.91342371888354,18.542660875953423,15.320141202809715,16.931401039381569,null,null,0.74220214251112737,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,90,121.11757898078487,18.752472011869195,15.419108536404257,17.085790274136727,null,null,0.74307958231462312,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,91,122.31889382657351,18.962299467398132,15.517611037217174,17.239955252307652,null,null,0.74395702211811898,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,92,123.51737829456385,19.172143064445141,15.615655960971905,17.393899512708522,null,null,0.74483446192161473,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,93,124.71304237582397,19.382002628773577,15.713250372671933,17.547626500722757,null,null,0.74571190172511059,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,94,125.90589601445348,19.591877989881006,15.81040115360647,17.701139571743738,null,null,0.74658934152860634,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,95,127.09594910785896,19.80176898088045,15.907115008027194,17.854441994453822,null,null,0.7474667813321022,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,96,128.28321150702794,20.011675438386312,16.003398469514622,18.007536953950467,null,null,0.74834422113559795,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,97,129.46769301680052,20.221597202405267,16.099257907051943,18.160427554728606,null,null,0.74922166093909381,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,98,130.64940339613941,20.43153411623155,16.194699530822238,18.313116823526894,null,null,0.75009910074258968,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,99,131.82835235839786,20.641486026346577,16.289729397744711,18.465607712045646,null,null,0.75097654054608542,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,100,133.00454957158581,20.851452782322603,16.384353416763961,18.617903099543284,null,null,0.75185398034958129,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,101,134.17800465863434,21.061434236730111,16.478577353905742,18.770005795317928,null,null,0.75273142015307704,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,102,135.34872719765769,21.27143024504899,16.572406837111849,18.921918541080419,null,null,0.7536088599565729,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,103,136.51672672221434,21.481440665583278,16.665847360865602,19.073644013224438,null,null,0.75448629976006876,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,104,137.68201272156554,21.69146535937886,16.758904290619089,19.225184824998976,null,null,0.75536373956356451,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,105,138.84459464093223,21.901504190144763,16.851582867032572,19.37654352858867,null,null,0.75624117936706026,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,106,140.00448188175039,22.111557024177106,16.943888210035503,19.527722617106306,null,null,0.75711861917055612,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,107,141.16168380192445,22.321623730286092,17.035825322718448,19.678724526502272,null,null,0.75799605897405198,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,108,142.31620971607887,22.531704179725708,17.127399095064437,19.82955163739507,null,null,0.75887349877754773,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,109,143.46806889580807,22.741798246125917,17.218614307527691,19.980206276826806,null,null,0.75975093858104359,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,110,144.61727056992473,22.951905805427518,17.309475634467464,20.130690719947491,null,null,0.76062837838453934,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,111,145.76382392470609,23.162026735819119,17.399987647444007,20.281007191631563,null,null,0.7615058181880352,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,112,146.9077381041389,23.372160917676677,17.49015481838342,20.431157868030049,null,null,0.76238325799153106,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,113,148.04902221016243,23.582308233504943,17.579981522617746,20.581144878061345,null,null,0.76326069779502681,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,114,149.18768530290981,23.792468567881055,17.66947204180623,20.730970304843645,null,null,0.76413813759852267,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,115,150.32373640094792,24.002641807400256,17.758630566743491,20.880636187071872,null,null,0.76501557740201842,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,116,151.45718448151536,24.212827840623181,17.847461200059801,21.030144520341491,null,null,0.76589301720551428,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,117,152.58803848075902,24.423026558025349,17.935967958818601,21.179497258421975,null,null,0.76677045700901003,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,118,153.71630729396878,24.633237851947925,18.024154777015983,21.328696314481952,null,null,0.76764789681250589,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,119,154.84199977581099,24.843461616550663,18.112025507986587,21.477743562268625,null,null,0.76852533661600164,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,120,155.96512474055984,25.053697747765945,18.199583926720305,21.626640837243123,null,null,0.7694027764194975,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"FW - Projected Performance - NE","index":5,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":true,"merged":[[62,3,62,5],[62,8,63,8],[49,1,49,4],[0,0,0,14],[1,0,3,0],[1,9,2,10],[48,1,48,4],[1,1,2,6],[48,6,48,9],[49,6,49,9]]}
["Economic model for optimum phosphorus level - Model Calculations by phase"]
["Item","Dietary phase",null,null,null,null,null,null,null,"Summary of Calculations with Current Phosphorus Levels"]
[]
[null,1,2,3,4,5,6,null,null,"Item","Output",2,3,4,5,6]
["Starting weight, kg",{"$f":"'Finisher Model - NE Metric'!B17","v":0},{"$f":"'Finisher Model - NE Metric'!B18","v":0},{"$f":"'Finisher Model - NE Metric'!B19","v":0},{"$f":"'Finisher Model - NE Metric'!B20","v":0},{"$f":"'Finisher Model - NE Metric'!B21","v":0},{"$f":"'Finisher Model - NE Metric'!B22","v":0},null,null,"Live"]
["Final weight, kg",{"$f":"'Finisher Model - NE Metric'!C17","v":0},{"$f":"'Finisher Model - NE Metric'!C18","v":0},{"$f":"'Finisher Model - NE Metric'!C19","v":0},{"$f":"'Finisher Model - NE Metric'!C20","v":0},{"$f":"'Finisher Model - NE Metric'!C21","v":0},{"$f":"'Finisher Model - NE Metric'!C22","v":0},null,null,"Predicted ADG, kg",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L6,IF('Finisher Model - NE Metric'!$D$11=3,M6,IF('Finisher Model - NE Metric'!$D$11=4,N6,IF('Finisher Model - NE Metric'!$D$11=5,O6,IF('Finisher Model - NE Metric'!$D$11=6,P6,\"\")))))","v":""},{"$f":"((SUM($B$22:$C$22)/SUM(B16:C16)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$22:$D$22)/SUM(B16:D16)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$22:$E$22)/SUM(B16:E16)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$22:$F$22)/SUM(B16:F16)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$22:$G$22)/SUM(B16:G16)))","v":{"$error":"#VALUE!"}}]
["Total gain, kg",{"$f":"B6-B5","v":0},{"$f":"C6-C5","v":0},0,0,0,0,null,null,"Predicted F/G",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L7,IF('Finisher Model - NE Metric'!$D$11=3,M7,IF('Finisher Model - NE Metric'!$D$11=4,N7,IF('Finisher Model - NE Metric'!$D$11=5,O7,IF('Finisher Model - NE Metric'!$D$11=6,P7,\"\")))))","v":""},{"$f":"SUM($B$18:$C$18)/SUM($B$22:$C$22)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$18:$D$18)/SUM($B$22:$D$22)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$18:$E$18)/SUM($B$22:$E$22)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$18:$F$18)/SUM($B$22:$F$22)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$18:$G$18)/SUM($B$22:$G$22)","v":{"$error":"#VALUE!"}}]
["Current NE, kcal/kg",{"$f":"'Finisher Model - NE Metric'!D17","v":0},{"$f":"'Finisher Model - NE Metric'!D18","v":0},{"$f":"'Finisher Model - NE Metric'!D19","v":0},{"$f":"'Finisher Model - NE Metric'!D20","v":0},{"$f":"'Finisher Model - NE Metric'!D21","v":0},{"$f":"'Finisher Model - NE Metric'!D22","v":0},null,null,"Predicted ADFI, kg",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L8,IF('Finisher Model - NE Metric'!$D$11=3,M8,IF('Finisher Model - NE Metric'!$D$11=4,N8,IF('Finisher Model - NE Metric'!$D$11=5,O8,IF('Finisher Model - NE Metric'!$D$11=6,P8,\"\")))))","v":""},{"$f":"SUM(B18:C18)/SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:D18)/SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:E18)/SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:F18)/SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:G18)/SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Current Diet Cost, $/Ton",{"$f":"'Finisher Model - NE Metric'!I17","v":0},{"$f":"'Finisher Model - NE Metric'!I18","v":0},{"$f":"'Finisher Model - NE Metric'!I19","v":0},{"$f":"'Finisher Model - NE Metric'!I20","v":0},{"$f":"'Finisher Model - NE Metric'!I21","v":0},{"$f":"'Finisher Model - NE Metric'!I22","v":0},null,null,"Phases duration, d",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L9,IF('Finisher Model - NE Metric'!$D$11=3,M9,IF('Finisher Model - NE Metric'!$D$11=4,N9,IF('Finisher Model - NE Metric'!$D$11=5,O9,IF('Finisher Model - NE Metric'!$D$11=6,P9,\"\")))))","v":""},{"$f":"SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Average Starting Wt & End Wt, kg",{"$f":"AVERAGE(B5:B6)","v":0},{"$f":"AVERAGE(C5:C6)","v":0},0,0,{"$f":"AVERAGE(F5:F6)","v":0},{"$f":"AVERAGE(G5:G6)","v":0},null,null,"Total feed, kg/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L10,IF('Finisher Model - NE Metric'!$D$11=3,M10,IF('Finisher Model - NE Metric'!$D$11=4,N10,IF('Finisher Model - NE Metric'!$D$11=5,O10,IF('Finisher Model - NE Metric'!$D$11=6,P10,\"\")))))","v":""},{"$f":"SUM(B18:C18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:D18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:F18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:G18)","v":{"$error":"#VALUE!"}}]
["Calculated Overall ADG with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P17-216.9*('Finisher Model - NE Metric'!P17*'Finisher Model - NE Metric'!P17),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P18-216.9*('Finisher Model - NE Metric'!P18*'Finisher Model - NE Metric'!P18),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P19-216.9*('Finisher Model - NE Metric'!P19*'Finisher Model - NE Metric'!P19),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P20-216.9*('Finisher Model - NE Metric'!P20*'Finisher Model - NE Metric'!P20),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P21-216.9*('Finisher Model - NE Metric'!P21*'Finisher Model - NE Metric'!P21),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P22-216.9*('Finisher Model - NE Metric'!P22*'Finisher Model - NE Metric'!P22),\"\")","v":""},null,null,"Total feed cost, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L11,IF('Finisher Model - NE Metric'!$D$11=3,M11,IF('Finisher Model - NE Metric'!$D$11=4,N11,IF('Finisher Model - NE Metric'!$D$11=5,O11,IF('Finisher Model - NE Metric'!$D$11=6,P11,\"\")))))","v":""},{"$f":"SUM(B20:C20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B20:D20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B20:E20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B20:F20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B20:G20)","v":{"$error":"#VALUE!"}}]
["Calculated Overall G:F with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P17-46.7864*('Finisher Model - NE Metric'!P17*'Finisher Model - NE Metric'!P17),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P18-46.7864*('Finisher Model - NE Metric'!P18*'Finisher Model - NE Metric'!P18),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P19-46.7864*('Finisher Model - NE Metric'!P19*'Finisher Model - NE Metric'!P19),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P20-46.7864*('Finisher Model - NE Metric'!P20*'Finisher Model - NE Metric'!P20),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P21-46.7864*('Finisher Model - NE Metric'!P21*'Finisher Model - NE Metric'!P21),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P22-46.7864*('Finisher Model - NE Metric'!P22*'Finisher Model - NE Metric'!P22),\"\")","v":""},null,null,"Total feed cost & facility cost, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L12,IF('Finisher Model - NE Metric'!$D$11=3,M12,IF('Finisher Model - NE Metric'!$D$11=4,N12,IF('Finisher Model - NE Metric'!$D$11=5,O12,IF('Finisher Model - NE Metric'!$D$11=6,P12,\"\")))))","v":""},{"$f":"SUM(B26:C26)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B26:D26)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B26:E26)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B26:F26)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B26:G26)","v":{"$error":"#VALUE!"}}]
["Predicted Overall ADFI, g/d",{"$f":"(B11/B12)*1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Revenue Live, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L13,IF('Finisher Model - NE Metric'!$D$11=3,M13,IF('Finisher Model - NE Metric'!$D$11=4,N13,IF('Finisher Model - NE Metric'!$D$11=5,O13,IF('Finisher Model - NE Metric'!$D$11=6,P13,\"\")))))","v":""},{"$f":"SUM(B22:C22,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B22:D22,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B22:E22,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B22:F22,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B22:G22,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}}]
["Predicted Overall F/G",{"$f":"B13/B11","v":{"$error":"#VALUE!"}},{"$f":"C13/C11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFC Live, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L14,IF('Finisher Model - NE Metric'!$D$11=3,M14,IF('Finisher Model - NE Metric'!$D$11=4,N14,IF('Finisher Model - NE Metric'!$D$11=5,O14,IF('Finisher Model - NE Metric'!$D$11=6,P14,\"\")))))","v":""},{"$f":"L13-L11","v":{"$error":"#VALUE!"}},{"$f":"M13-M11","v":{"$error":"#VALUE!"}},{"$f":"N13-N11","v":{"$error":"#VALUE!"}},{"$f":"O13-O11","v":{"$error":"#VALUE!"}},{"$f":"P13-P11","v":{"$error":"#VALUE!"}}]
["Overall average F/G (weighted average based on phase duration)",{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUMPRODUCT(B14:C14,B16:C16)/SUM(B16:C16),IF('Finisher Model - NE Metric'!D11=3,SUMPRODUCT(B14:D14,B16:D16)/SUM(B16:D16),IF('Finisher Model - NE Metric'!D11=4,SUMPRODUCT(B14:E14,B16:E16)/SUM(B16:E16),IF('Finisher Model - NE Metric'!D11=5,SUMPRODUCT(B14:F14,B16:F16)/SUM(B16:F16),IF('Finisher Model - NE Metric'!D11=6,SUMPRODUCT(B14:G14,B16:G16)/SUM(B16:G16),\"\")))))","v":""},null,null,null,null,null,null,null,"Total IOFFC Live, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L15,IF('Finisher Model - NE Metric'!$D$11=3,M15,IF('Finisher Model - NE Metric'!$D$11=4,N15,IF('Finisher Model - NE Metric'!$D$11=5,O15,IF('Finisher Model - NE Metric'!$D$11=6,P15,\"\")))))","v":""},{"$f":"L13-L12","v":{"$error":"#VALUE!"}},{"$f":"M13-M12","v":{"$error":"#VALUE!"}},{"$f":"N13-N12","v":{"$error":"#VALUE!"}},{"$f":"O13-O12","v":{"$error":"#VALUE!"}},{"$f":"P13-P12","v":{"$error":"#VALUE!"}}]
["Phase duration, d for Live Basis",{"$f":"(CONVERT(B7,\"kg\",\"g\"))/B11","v":{"$error":"#VALUE!"}},{"$f":"(CONVERT(C7,\"kg\",\"g\"))/C11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUM(B16:C16),IF('Finisher Model - NE Metric'!D11=3,SUM(B16:D16),IF('Finisher Model - NE Metric'!D11=4,SUM(B16:E16),IF('Finisher Model - NE Metric'!D11=5,SUM(B16:F16),IF('Finisher Model - NE Metric'!D11=6,SUM(B16:G16),\"\")))))","v":""},null,"Carcass"]
["Phase duration, d for Carcass Basis",{"$f":"(B6-B5)/(B11/1000)","v":{"$error":"#VALUE!"}},{"$f":"(IF('Finisher Model - NE Metric'!D11=2,'FW - Projected Performance - NE'!$B$34-'FW - Projected Performance - NE'!C5,'FW - Projected Performance - NE'!C6-'FW - Projected Performance - NE'!C5))/('FW - Projected Performance - NE'!C11/1000)","v":{"$error":"#VALUE!"}},{"$f":"(IF('Finisher Model - NE Metric'!D11=3,'FW - Projected Performance - NE'!$B$34-'FW - Projected Performance - NE'!D5,'FW - Projected Performance - NE'!D6-'FW - Projected Performance - NE'!D5))/('FW - Projected Performance - NE'!D11/1000)","v":{"$error":"#VALUE!"}},{"$f":"(IF('Finisher Model - NE Metric'!D11=4,'FW - Projected Performance - NE'!$B$34-'FW - Projected Performance - NE'!E5,'FW - Projected Performance - NE'!E6-'FW - Projected Performance - NE'!E5))/('FW - Projected Performance - NE'!E11/1000)","v":{"$error":"#VALUE!"}},{"$f":"(IF('Finisher Model - NE Metric'!D11=5,'FW - Projected Performance - NE'!$B$34-'FW - Projected Performance - NE'!F5,'FW - Projected Performance - NE'!F6-'FW - Projected Performance - NE'!F5))/('FW - Projected Performance - NE'!F11/1000)","v":{"$error":"#VALUE!"}},{"$f":"(IF('Finisher Model - NE Metric'!D11=6,'FW - Projected Performance - NE'!$B$34-'FW - Projected Performance - NE'!G5,'FW - Projected Performance - NE'!G6-'FW - Projected Performance - NE'!G5))/('FW - Projected Performance - NE'!G11/1000)","v":{"$error":"#VALUE!"}},{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUM(B17:C17),IF('Finisher Model - NE Metric'!D11=3,SUM(B17:D17),IF('Finisher Model - NE Metric'!D11=4,SUM(B17:E17),IF('Finisher Model - NE Metric'!D11=5,SUM(B17:F17),IF('Finisher Model - NE Metric'!D11=6,SUM(B17:G17),\"\")))))","v":""},null,"Predicted ADG, kg",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L17,IF('Finisher Model - NE Metric'!$D$11=3,M17,IF('Finisher Model - NE Metric'!$D$11=4,N17,IF('Finisher Model - NE Metric'!$D$11=5,O17,IF('Finisher Model - NE Metric'!$D$11=6,P17,\"\")))))","v":""},{"$f":"((SUM($B$23:$C$23)/SUM(B17:C17)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$23:$D$23)/SUM(B17:D17)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$23:$E$23)/SUM(B17:E17)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$23:$F$23)/SUM(B17:F17)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$23:$G$23)/SUM(B17:G17)))","v":{"$error":"#VALUE!"}}]
["Feed budget by phase, kg/pig for Live Basis",{"$f":"CONVERT(D55,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D56,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D57,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D58,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D59,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D60,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},null,null,"Predicted F/G",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L18,IF('Finisher Model - NE Metric'!$D$11=3,M18,IF('Finisher Model - NE Metric'!$D$11=4,N18,IF('Finisher Model - NE Metric'!$D$11=5,O18,IF('Finisher Model - NE Metric'!$D$11=6,P18,\"\")))))","v":""},{"$f":"SUM($B$19:$C$19)/SUM($B$23:$C$23)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$19:$D$19)/SUM($B$23:$D$23)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$19:$E$19)/SUM($B$23:$E$23)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$19:$F$19)/SUM($B$23:$F$23)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$19:$G$19)/SUM($B$23:$G$23)","v":{"$error":"#VALUE!"}}]
["Feed budget by phase, kg/pig for Carcass Basis",{"$f":"CONVERT(I55,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(I56,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(I57,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(I58,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(I59,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(I60,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},null,null,"Predicted ADFI, kg",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L19,IF('Finisher Model - NE Metric'!$D$11=3,M19,IF('Finisher Model - NE Metric'!$D$11=4,N19,IF('Finisher Model - NE Metric'!$D$11=5,O19,IF('Finisher Model - NE Metric'!$D$11=6,P19,\"\")))))","v":""},{"$f":"SUM(B19:C19)/SUM(B17:C17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:D19)/SUM(B17:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:E19)/SUM(B17:E17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:F19)/SUM(B17:F17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:G19)/SUM(B17:G17)","v":{"$error":"#VALUE!"}}]
["Total feed cost per phase, $/pig for Live Basis",{"$f":"(B18*(B9/907))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Phases duration, d",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L20,IF('Finisher Model - NE Metric'!$D$11=3,M20,IF('Finisher Model - NE Metric'!$D$11=4,N20,IF('Finisher Model - NE Metric'!$D$11=5,O20,IF('Finisher Model - NE Metric'!$D$11=6,P20,\"\")))))","v":""},{"$f":"SUM(B17:C17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:E17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:F17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:G17)","v":{"$error":"#VALUE!"}}]
["Total feed cost per phase, $/pig for Carcass Basis",{"$f":"(B19*(B9/907))","v":{"$error":"#VALUE!"}},{"$f":"(C19*(C9/907))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total feed, kg/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L21,IF('Finisher Model - NE Metric'!$D$11=3,M21,IF('Finisher Model - NE Metric'!$D$11=4,N21,IF('Finisher Model - NE Metric'!$D$11=5,O21,IF('Finisher Model - NE Metric'!$D$11=6,P21,\"\")))))","v":""},{"$f":"SUM(B19:C19)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:D19)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:E19)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:F19)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:G19)","v":{"$error":"#VALUE!"}}]
["Gain, kg for Live Basis",{"$f":"B11/1000*B16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUM(B22:C22)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=3,SUM(B22:D22)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=4,SUM(B22:E22)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=5,SUM(B22:F22)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=6, SUM(B22:G22)+'Finisher Model - NE Metric'!B17,\"\")))))","v":""},null,"Total feed cost, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L22,IF('Finisher Model - NE Metric'!$D$11=3,M22,IF('Finisher Model - NE Metric'!$D$11=4,N22,IF('Finisher Model - NE Metric'!$D$11=5,O22,IF('Finisher Model - NE Metric'!$D$11=6,P22,\"\")))))","v":""},{"$f":"SUM(B21:C21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:D21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:E21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:F21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:G21)","v":{"$error":"#VALUE!"}}]
["Gain, kg for Carcass Basis",{"$f":"B11/1000*B17","v":{"$error":"#VALUE!"}},{"$f":"C11/1000*C17","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUM(B23:C23)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=3,SUM(B23:D23)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=4,SUM(B23:E23)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=5,SUM(B23:F23)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=6, SUM(B23:G23)+'Finisher Model - NE Metric'!B17,\"\")))))","v":""},null,"Total feed cost & facility cost, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L23,IF('Finisher Model - NE Metric'!$D$11=3,M23,IF('Finisher Model - NE Metric'!$D$11=4,N23,IF('Finisher Model - NE Metric'!$D$11=5,O23,IF('Finisher Model - NE Metric'!$D$11=6,P23,\"\")))))","v":""},{"$f":"SUM(B27:C27)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B27:D27)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B27:E27)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B27:F27)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B27:G27)","v":{"$error":"#VALUE!"}}]
["Feed cost per/kg of gain, $/pig for Live Basis",{"$f":"B20/((B11/1000)*B16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Revenue Carcass, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L24,IF('Finisher Model - NE Metric'!$D$11=3,M24,IF('Finisher Model - NE Metric'!$D$11=4,N24,IF('Finisher Model - NE Metric'!$D$11=5,O24,IF('Finisher Model - NE Metric'!$D$11=6,P24,\"\")))))","v":""},{"$f":"$B$33*'Finisher Model - NE Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"$B$33*'Finisher Model - NE Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"$B$33*'Finisher Model - NE Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"$B$33*'Finisher Model - NE Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"$B$33*'Finisher Model - NE Metric'!$D$8","v":{"$error":"#VALUE!"}}]
["Feed cost per/kg of gain, $/pig for Carcass Basis",{"$f":"B21/((B11/1000)*B17)","v":{"$error":"#VALUE!"}},{"$f":"C21/((C11/1000)*C17)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFC Carcass, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L25,IF('Finisher Model - NE Metric'!$D$11=3,M25,IF('Finisher Model - NE Metric'!$D$11=4,N25,IF('Finisher Model - NE Metric'!$D$11=5,O25,IF('Finisher Model - NE Metric'!$D$11=6,P25,\"\")))))","v":""},{"$f":"L24-L22","v":{"$error":"#VALUE!"}},{"$f":"M24-M22","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Feed and facility cost, $/pig for Live Basis",{"$f":"B20+(B16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"C20+(C16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"D20+(D16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"E20+(E16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"F20+(F16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"G20+(G16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},null,null,"Total IOFFC Carcass, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L26,IF('Finisher Model - NE Metric'!$D$11=3,M26,IF('Finisher Model - NE Metric'!$D$11=4,N26,IF('Finisher Model - NE Metric'!$D$11=5,O26,IF('Finisher Model - NE Metric'!$D$11=6,P26,\"\")))))","v":""},{"$f":"L24-L23","v":{"$error":"#VALUE!"}},{"$f":"M24-M23","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"P24-P23","v":{"$error":"#VALUE!"}}]
["Feed and facility cost, $/pig for Carcass Basis",{"$f":"B21+(B17*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"C21+(C17*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"D21+(D17*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"E21+(E17*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"F21+(F17*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"G21+(G17*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}}]
["Revenue per pig by phase, $/pig for Live Basis",{"$f":"B22*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"C22*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"D22*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"E22*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"F22*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"G22*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}}]
["IOFC by phase, $/pig",{"$f":"B28-B20","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["IOFFC by phase, $/pig",{"$f":"B28-B26","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["STTD P",{"$f":"'Finisher Model - NE Metric'!R17","v":""},{"$f":"'Finisher Model - NE Metric'!R18","v":""},{"$f":"'Finisher Model - NE Metric'!R19","v":""},{"$f":"'Finisher Model - NE Metric'!R20","v":""},{"$f":"'Finisher Model - NE Metric'!R21","v":""},{"$f":"'Finisher Model - NE Metric'!R22","v":""}]
["Weighted average of STTD P",{"$f":"SUMPRODUCT(B31,B18)/SUM(B18)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B31:C31,B18:C18)/SUM(B18:C18)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B31:D31,B18:D18)/SUM(B18:D18)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B31:E31,B18:E18)/SUM(B18:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B31:F31,B18:F18)/SUM(B18:F18)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B31:G31,B18:G18)/SUM(B18:G18)","v":{"$error":"#VALUE!"}}]
["Calculated overall HCW for CURRENT performance",{"$f":"'Current Performance - NE '!B28","v":{"$error":"#VALUE!"}}]
["Predicted final BW, lb for Fixed Weight to achieve the same Current Carcass Wt",{"$f":"B33/(B43/100)","v":{"$error":"#VALUE!"}}]
["Calculated Overall HCW,lb based on final BW and corrected yield",{"$f":"$H$22*$B$43/100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Yield based on final BW and PIC equation",{"$f":"(VLOOKUP($H$22,$C$65:$I$104,7,TRUE))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["User yield",{"$f":"'Finisher Model - NE Metric'!D9","v":0}]
["User/PIC ratio",{"$f":"B37/B36","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Yield equation"]
["Current STTD P as % of NRC",{"$f":"'Finisher Model - NE Metric'!P17","v":""},{"$f":"'Finisher Model - NE Metric'!P18","v":""},{"$f":"'Finisher Model - NE Metric'!P19","v":""},{"$f":"'Finisher Model - NE Metric'!P20","v":""},{"$f":"'Finisher Model - NE Metric'!P21","v":""},{"$f":"'Finisher Model - NE Metric'!P22","v":""},{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUMPRODUCT(B39:C39,B16:C16)/SUM(B16:C16),IF('Finisher Model - NE Metric'!D11=3,SUMPRODUCT(B39:D39,B16:D16)/SUM(B16:D16),IF('Finisher Model - NE Metric'!D11=4,SUMPRODUCT(B39:E39,B16:E16)/SUM(B16:E16),IF('Finisher Model - NE Metric'!D11=5,SUMPRODUCT(B39:F39,B16:F16)/SUM(B16:F16),IF('Finisher Model - NE Metric'!D11=6,SUMPRODUCT(B39:G39,B16:G16)/SUM(B16:G16),\"\")))))","v":""},null,"73.859 - 1.19192 x STTD P % of NRC"]
["Predicted yield based on biological STTD P level",{"$f":"73.859-1.19192*H39","v":{"$error":"#VALUE!"}}]
["Yield at 100% of NRC",{"$f":"73.859-1.19192*1","v":72.667079999999999}]
["Yield correction factor based on STTD P level",{"$f":"B40/B41","v":{"$error":"#VALUE!"}}]
["Corrected current yield",{"$f":"(VLOOKUP($H$22,$C$65:$K$104,9,TRUE))","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[null,"Mixed Sex Feed Budget - Live Basis",null,null,null,null,"Mixed Sex Feed Budget - Carcass Basis"]
[null,"Closeout Feed Efficiency",null,null,null,null,"Closeout Feed Efficiency"]
[null,"Initial Wt","Final Wt","F/G",null,null,"Initial Wt","Final Wt","F/G"]
[null,{"$f":"CONVERT('Finisher Model - NE Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT(IF('Finisher Model - NE Metric'!$D$11=2,'Finisher Model - NE Metric'!C18,IF('Finisher Model - NE Metric'!$D$11=3,'Finisher Model - NE Metric'!C19,IF('Finisher Model - NE Metric'!$D$11=4,'Finisher Model - NE Metric'!C20,IF('Finisher Model - NE Metric'!$D$11=5,'Finisher Model - NE Metric'!C21,IF('Finisher Model - NE Metric'!$D$11=6,'Finisher Model - NE Metric'!C22,\"\"))))),\"kg\",\"lbm\")","v":{"$error":"#VALUE!"}},{"$f":"B15","v":""},null,null,{"$f":"CONVERT('Finisher Model - NE Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT(IF('Finisher Model - NE Metric'!$D$11=2,'Finisher Model - NE Metric'!C18,IF('Finisher Model - NE Metric'!$D$11=3,'Finisher Model - NE Metric'!C19,IF('Finisher Model - NE Metric'!$D$11=4,'Finisher Model - NE Metric'!C20,IF('Finisher Model - NE Metric'!$D$11=5,'Finisher Model - NE Metric'!C21,IF('Finisher Model - NE Metric'!$D$11=6,'Finisher Model - NE Metric'!C22,\"\"))))),\"kg\",\"lbm\")","v":{"$error":"#VALUE!"}},{"$f":"B15","v":""}]
[]
[null,"Initial Wt","Final Wt","lb/pig",{"$f":"IF(B55=0,F54,((0.00463*B55^2 + 1.68*B55 - 22.05)/(((0.00463*C52^2 + 1.68*C52 - 22.05)-(0.00463*B52^2 + 1.68*B52 - 22.05))/(C52-B52))*D52))","v":0},null,"Initial Wt","Final Wt","lb/pig",{"$f":"IF(G55=0,K54,((0.00463*G55^2 + 1.68*G55 - 22.05)/(((0.00463*H52^2 + 1.68*H52 - 22.05)-(0.00463*G52^2 + 1.68*G52 - 22.05))/(H52-G52))*I52))","v":0}]
[1,{"$f":"CONVERT('Finisher Model - NE Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT('Finisher Model - NE Metric'!C17,\"kg\",\"lbm\")","v":0},{"$f":"IF(C55=\"\",\"\",(E55-E54))","v":{"$error":"#VALUE!"}},{"$f":"IF(B56=\"\",\"\",((0.00463*B56^2 + 1.68*B56 - 22.05)/(((0.00463*$C$52^2 + 1.68*$C$52 - 22.05)-(0.00463*$B$52^2 + 1.68*$B$52 - 22.05))/($C$52-$B$52))*$D$52))","v":{"$error":"#VALUE!"}},null,{"$f":"CONVERT('Finisher Model - NE Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT('Finisher Model - NE Metric'!C17,\"kg\",\"lbm\")","v":0},{"$f":"IF(H55=\"\",\"\",(J55-J54))","v":{"$error":"#VALUE!"}},{"$f":"IF(G56=\"\",\"\",((0.00463*G56^2 + 1.68*G56 - 22.05)/(((0.00463*$C$52^2 + 1.68*$C$52 - 22.05)-(0.00463*$B$52^2 + 1.68*$B$52 - 22.05))/($C$52-$B$52))*$D$52))","v":{"$error":"#VALUE!"}}]
[2,{"$f":"C55","v":0},{"$f":"CONVERT('Finisher Model - NE Metric'!C18,\"kg\",\"lbm\")","v":0},{"$f":"IF(C56=\"\",\"\",(E56-E55))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,{"$f":"H55","v":0},{"$f":"CONVERT(IF(AND('Finisher Model - NE Metric'!D11=2,'Finisher Model - NE Metric'!D6=\"Carcass\"),'FW - Projected Performance - NE'!$B$34,'Finisher Model - NE Metric'!C18),\"kg\",\"lbm\")","v":0},{"$f":"IF(H56=\"\",\"\",(J56-J55))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[3,0,{"$f":"CONVERT('Finisher Model - NE Metric'!C19,\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0,{"$f":"CONVERT(IF(AND('Finisher Model - NE Metric'!D11=3,'Finisher Model - NE Metric'!D6=\"Carcass\"),'FW - Projected Performance - NE'!$B$34,'Finisher Model - NE Metric'!C19),\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,0,{"$f":"CONVERT('Finisher Model - NE Metric'!C20,\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0,{"$f":"CONVERT(IF(AND('Finisher Model - NE Metric'!D11=4,'Finisher Model - NE Metric'!D6=\"Carcass\"),'FW - Projected Performance - NE'!$B$34,'Finisher Model - NE Metric'!C20),\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,0,{"$f":"CONVERT('Finisher Model - NE Metric'!C21,\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0,{"$f":"CONVERT(IF(AND('Finisher Model - NE Metric'!D11=5,'Finisher Model - NE Metric'!D6=\"Carcass\"),'FW - Projected Performance - NE'!$B$34,'Finisher Model - NE Metric'!C21),\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,0,{"$f":"CONVERT('Finisher Model - NE Metric'!C22,\"kg\",\"lbm\")","v":0},{"$f":"IF(C60=\"\",\"\",(E60-E59))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,0,{"$f":"CONVERT(IF(AND('Finisher Model - NE Metric'!D11=6,'Finisher Model - NE Metric'!D6=\"Carcass\"),'FW - Projected Performance - NE'!$B$34,'Finisher Model - NE Metric'!C22),\"kg\",\"lbm\")","v":0},{"$f":"IF(H60=\"\",\"\",(J60-J59))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,0,null,null,null,null,0]
[]
[null,"Hot Carcass Wheight","Market weight    (est. by Carcass yield)","Back Fat for PIC 337",null,null,null,null,"Carcass Yield (%) =                                   66.411 + ( Carcass weight, kg x 0.0878)"]
[null,"kg","kg","Barrows","Gilts","Average",null,null,null,"User/PIC Adjusted Yield","User/PIC Asjusted and STTD P adjusted"]
[null,81,110.17670623134534,16.864782047899471,14.510728742835685,15.687755395367578,null,null,0.73518262408316082,{"$f":"(I65*$B$38)*100","v":{"$error":"#N/A"}},{"$f":"J65*$B$42","v":{"$error":"#N/A"}}]
[null,82,111.4039519642067,17.074455706764272,14.613701440729169,15.844078573746721,null,null,0.73606006388665657,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,83,112.6282752396024,17.284147265806148,14.71614342750836,16.000145346657256,null,null,0.73693750369015243,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,84,113.84968648405146,17.493856510850449,14.81806378371237,16.155960147281409,null,null,0.73781494349364829,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,85,115.06819607453319,17.703583232804778,14.919471328516645,16.311527280660712,null,null,0.73869238329714404,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,86,116.28381433878111,17.913327227479776,15.020374630235036,16.466850928857404,null,null,0.7395698231006399,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,87,117.49655155557477,18.123088295418643,15.120782016283018,16.621935155850831,null,null,0.74044726290413565,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,88,118.70641795502937,18.332866241734184,15.220701582635391,16.776783912184786,null,null,0.74132470270763151,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,89,119.91342371888354,18.542660875953423,15.320141202809715,16.931401039381569,null,null,0.74220214251112737,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,90,121.11757898078487,18.752472011869195,15.419108536404257,17.085790274136727,null,null,0.74307958231462312,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,91,122.31889382657351,18.962299467398132,15.517611037217174,17.239955252307652,null,null,0.74395702211811898,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,92,123.51737829456385,19.172143064445141,15.615655960971905,17.393899512708522,null,null,0.74483446192161473,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,93,124.71304237582397,19.382002628773577,15.713250372671933,17.547626500722757,null,null,0.74571190172511059,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,94,125.90589601445348,19.591877989881006,15.81040115360647,17.701139571743738,null,null,0.74658934152860634,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,95,127.09594910785896,19.80176898088045,15.907115008027194,17.854441994453822,null,null,0.7474667813321022,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,96,128.28321150702794,20.011675438386312,16.003398469514622,18.007536953950467,null,null,0.74834422113559795,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,97,129.46769301680052,20.221597202405267,16.099257907051943,18.160427554728606,null,null,0.74922166093909381,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,98,130.64940339613941,20.43153411623155,16.194699530822238,18.313116823526894,null,null,0.75009910074258968,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,99,131.82835235839786,20.641486026346577,16.289729397744711,18.465607712045646,null,null,0.75097654054608542,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,100,133.00454957158581,20.851452782322603,16.384353416763961,18.617903099543284,null,null,0.75185398034958129,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,101,134.17800465863434,21.061434236730111,16.478577353905742,18.770005795317928,null,null,0.75273142015307704,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,102,135.34872719765769,21.27143024504899,16.572406837111849,18.921918541080419,null,null,0.7536088599565729,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,103,136.51672672221434,21.481440665583278,16.665847360865602,19.073644013224438,null,null,0.75448629976006876,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,104,137.68201272156554,21.69146535937886,16.758904290619089,19.225184824998976,null,null,0.75536373956356451,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,105,138.84459464093223,21.901504190144763,16.851582867032572,19.37654352858867,null,null,0.75624117936706026,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,106,140.00448188175039,22.111557024177106,16.943888210035503,19.527722617106306,null,null,0.75711861917055612,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,107,141.16168380192445,22.321623730286092,17.035825322718448,19.678724526502272,null,null,0.75799605897405198,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,108,142.31620971607887,22.531704179725708,17.127399095064437,19.82955163739507,null,null,0.75887349877754773,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,109,143.46806889580807,22.741798246125917,17.218614307527691,19.980206276826806,null,null,0.75975093858104359,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,110,144.61727056992473,22.951905805427518,17.309475634467464,20.130690719947491,null,null,0.76062837838453934,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,111,145.76382392470609,23.162026735819119,17.399987647444007,20.281007191631563,null,null,0.7615058181880352,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,112,146.9077381041389,23.372160917676677,17.49015481838342,20.431157868030049,null,null,0.76238325799153106,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,113,148.04902221016243,23.582308233504943,17.579981522617746,20.581144878061345,null,null,0.76326069779502681,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,114,149.18768530290981,23.792468567881055,17.66947204180623,20.730970304843645,null,null,0.76413813759852267,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,115,150.32373640094792,24.002641807400256,17.758630566743491,20.880636187071872,null,null,0.76501557740201842,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,116,151.45718448151536,24.212827840623181,17.847461200059801,21.030144520341491,null,null,0.76589301720551428,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,117,152.58803848075902,24.423026558025349,17.935967958818601,21.179497258421975,null,null,0.76677045700901003,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,118,153.71630729396878,24.633237851947925,18.024154777015983,21.328696314481952,null,null,0.76764789681250589,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,119,154.84199977581099,24.843461616550663,18.112025507986587,21.477743562268625,null,null,0.76852533661600164,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,120,155.96512474055984,25.053697747765945,18.199583926720305,21.626640837243123,null,null,0.7694027764194975,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"FT - Projected Performance - NE","index":6,"n_rows":94,"n_cols":16,"rows_kept":94,"cut":false,"hidden":true,"merged":[[52,3,52,5],[52,8,53,8],[37,1,37,4],[0,0,0,14],[1,0,3,0],[1,9,2,10],[36,1,36,4],[1,1,2,6]]}
["Economic model for optimum phosphorus level - Model Calculations by phase"]
["Item","Dietary phase",null,null,null,null,null,null,null,"Summary of Calculations with Current Phosphorus Levels"]
[]
[null,1,2,3,4,5,6,null,null,"Item","Output",2,3,4,5,6]
["Starting weight, kg",{"$f":"'Finisher Model - NE Metric'!B17","v":0},{"$f":"'Finisher Model - NE Metric'!B18","v":0},{"$f":"'Finisher Model - NE Metric'!B19","v":0},{"$f":"'Finisher Model - NE Metric'!B20","v":0},{"$f":"'Finisher Model - NE Metric'!B21","v":0},{"$f":"'Finisher Model - NE Metric'!B22","v":0},null,null,"Predicted ADG, kg",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L5,IF('Finisher Model - NE Metric'!$D$11=3,M5,IF('Finisher Model - NE Metric'!$D$11=4,N5,IF('Finisher Model - NE Metric'!$D$11=5,O5,IF('Finisher Model - NE Metric'!$D$11=6,P5,\"\")))))","v":""},{"$f":"((SUM(B19:C19)/SUM(B16:C16)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM(B19:D19)/SUM(B16:D16)))","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:E19)/SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:F19)/SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:G19)/SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Final weight, kg",{"$f":"'Finisher Model - NE Metric'!C17","v":0},{"$f":"'Finisher Model - NE Metric'!C18","v":0},{"$f":"'Finisher Model - NE Metric'!C19","v":0},{"$f":"'Finisher Model - NE Metric'!C20","v":0},{"$f":"'Finisher Model - NE Metric'!C21","v":0},{"$f":"'Finisher Model - NE Metric'!C22","v":0},null,null,"Predicted F/G",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L6,IF('Finisher Model - NE Metric'!$D$11=3,M6,IF('Finisher Model - NE Metric'!$D$11=4,N6,IF('Finisher Model - NE Metric'!$D$11=5,O6,IF('Finisher Model - NE Metric'!$D$11=6,P6,\"\")))))","v":""},{"$f":"SUM($B$17:$C$17)/SUM($B$19:$C$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$D$17)/SUM($B$19:$D$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$E$17)/SUM($B$19:$E$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$F$17)/SUM($B$19:$F$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$G$17)/SUM($B$19:$G$19)","v":{"$error":"#VALUE!"}}]
["Total gain, kg",{"$f":"B6-B5","v":0},{"$f":"C6-C5","v":0},0,0,{"$f":"F6-F5","v":0},{"$f":"G6-G5","v":0},null,null,"Predicted ADFI, kg",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L7,IF('Finisher Model - NE Metric'!$D$11=3,M7,IF('Finisher Model - NE Metric'!$D$11=4,N7,IF('Finisher Model - NE Metric'!$D$11=5,O7,IF('Finisher Model - NE Metric'!$D$11=6,P7,\"\")))))","v":""},{"$f":"SUM(B17:C17)/SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:D17)/SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:E17)/SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:F17)/SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:G17)/SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Current NE, kcal/kg",{"$f":"'Finisher Model - NE Metric'!D17","v":0},{"$f":"'Finisher Model - NE Metric'!D18","v":0},{"$f":"'Finisher Model - NE Metric'!D19","v":0},{"$f":"'Finisher Model - NE Metric'!D20","v":0},{"$f":"'Finisher Model - NE Metric'!D21","v":0},{"$f":"'Finisher Model - NE Metric'!D22","v":0},null,null,"Phases duration, d",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L8,IF('Finisher Model - NE Metric'!$D$11=3,M8,IF('Finisher Model - NE Metric'!$D$11=4,N8,IF('Finisher Model - NE Metric'!$D$11=5,O8,IF('Finisher Model - NE Metric'!$D$11=6,P8,\"\")))))","v":""},{"$f":"SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Current Diet Cost, $/Ton",{"$f":"'Finisher Model - NE Metric'!I17","v":0},{"$f":"'Finisher Model - NE Metric'!I18","v":0},{"$f":"'Finisher Model - NE Metric'!I19","v":0},{"$f":"'Finisher Model - NE Metric'!I20","v":0},{"$f":"'Finisher Model - NE Metric'!I21","v":0},{"$f":"'Finisher Model - NE Metric'!I22","v":0},null,null,"Total feed, kg/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L9,IF('Finisher Model - NE Metric'!$D$11=3,M9,IF('Finisher Model - NE Metric'!$D$11=4,N9,IF('Finisher Model - NE Metric'!$D$11=5,O9,IF('Finisher Model - NE Metric'!$D$11=6,P9,\"\")))))","v":""},{"$f":"SUM(B17:C17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:E17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:F17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:G17)","v":{"$error":"#VALUE!"}}]
["Average Starting Wt & End Wt, kg",{"$f":"AVERAGE(B5:B6)","v":0},{"$f":"AVERAGE(C5:C6)","v":0},0,0,0,{"$f":"AVERAGE(G5:G6)","v":0},null,null,"Total feed cost, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L10,IF('Finisher Model - NE Metric'!$D$11=3,M10,IF('Finisher Model - NE Metric'!$D$11=4,N10,IF('Finisher Model - NE Metric'!$D$11=5,O10,IF('Finisher Model - NE Metric'!$D$11=6,P10,\"\")))))","v":""},{"$f":"SUM(B18:C18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:D18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:F18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:G18)","v":{"$error":"#VALUE!"}}]
["Calculated Overall ADG with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P17-216.9*('Finisher Model - NE Metric'!P17*'Finisher Model - NE Metric'!P17),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P18-216.9*('Finisher Model - NE Metric'!P18*'Finisher Model - NE Metric'!P18),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P19-216.9*('Finisher Model - NE Metric'!P19*'Finisher Model - NE Metric'!P19),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P20-216.9*('Finisher Model - NE Metric'!P20*'Finisher Model - NE Metric'!P20),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P21-216.9*('Finisher Model - NE Metric'!P21*'Finisher Model - NE Metric'!P21),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - NE Metric'!P22-216.9*('Finisher Model - NE Metric'!P22*'Finisher Model - NE Metric'!P22),\"\")","v":""},null,null,"Total feed cost & facility cost, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L11,IF('Finisher Model - NE Metric'!$D$11=3,M11,IF('Finisher Model - NE Metric'!$D$11=4,N11,IF('Finisher Model - NE Metric'!$D$11=5,O11,IF('Finisher Model - NE Metric'!$D$11=6,P11,\"\")))))","v":""},{"$f":"SUM(B21:C21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:D21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:E21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:F21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:G21)","v":{"$error":"#VALUE!"}}]
["Calculated Overall G:F with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P17-46.7864*('Finisher Model - NE Metric'!P17*'Finisher Model - NE Metric'!P17),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P18-46.7864*('Finisher Model - NE Metric'!P18*'Finisher Model - NE Metric'!P18),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P19-46.7864*('Finisher Model - NE Metric'!P19*'Finisher Model - NE Metric'!P19),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P20-46.7864*('Finisher Model - NE Metric'!P20*'Finisher Model - NE Metric'!P20),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P21-46.7864*('Finisher Model - NE Metric'!P21*'Finisher Model - NE Metric'!P21),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - NE Metric'!P22-46.7864*('Finisher Model - NE Metric'!P22*'Finisher Model - NE Metric'!P22),\"\")","v":""},null,null,"Revenue Live, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L12,IF('Finisher Model - NE Metric'!$D$11=3,M12,IF('Finisher Model - NE Metric'!$D$11=4,N12,IF('Finisher Model - NE Metric'!$D$11=5,O12,IF('Finisher Model - NE Metric'!$D$11=6,P12,\"\")))))","v":""},{"$f":"SUM(B19:C19,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:D19,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:E19,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:F19,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:G19,'Finisher Model - NE Metric'!B17)*'Finisher Model - NE Metric'!D7","v":{"$error":"#VALUE!"}}]
["Predicted Overall ADFI, g/d",{"$f":"(B11/B12)*1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFC Live, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L13,IF('Finisher Model - NE Metric'!$D$11=3,M13,IF('Finisher Model - NE Metric'!$D$11=4,N13,IF('Finisher Model - NE Metric'!$D$11=5,O13,IF('Finisher Model - NE Metric'!$D$11=6,P13,\"\")))))","v":""},{"$f":"L12-L10","v":{"$error":"#VALUE!"}},{"$f":"M12-M10","v":{"$error":"#VALUE!"}},{"$f":"N12-N10","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"P12-P10","v":{"$error":"#VALUE!"}}]
["Predicted Overall F/G",{"$f":"B13/B11","v":{"$error":"#VALUE!"}},{"$f":"C13/C11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFFC Live, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L14,IF('Finisher Model - NE Metric'!$D$11=3,M14,IF('Finisher Model - NE Metric'!$D$11=4,N14,IF('Finisher Model - NE Metric'!$D$11=5,O14,IF('Finisher Model - NE Metric'!$D$11=6,P14,\"\")))))","v":""},{"$f":"L12-L11","v":{"$error":"#VALUE!"}},{"$f":"M12-M11","v":{"$error":"#VALUE!"}},{"$f":"N12-N11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"P12-P11","v":{"$error":"#VALUE!"}}]
["Overall average F/G (weighted average based on phase duration)",{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUMPRODUCT(B14:C14,B16:C16)/SUM(B16:C16),IF('Finisher Model - NE Metric'!D11=3,SUMPRODUCT(B14:D14,B16:D16)/SUM(B16:D16),IF('Finisher Model - NE Metric'!D11=4,SUMPRODUCT(B14:E14,B16:E16)/SUM(B16:E16),IF('Finisher Model - NE Metric'!D11=5,SUMPRODUCT(B14:F14,B16:F16)/SUM(B16:F16),IF('Finisher Model - NE Metric'!D11=6,SUMPRODUCT(B14:G14,B16:G16)/SUM(B16:G16),\"\")))))","v":""},null,null,null,null,null,null,null,"HCW",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L15,IF('Finisher Model - NE Metric'!$D$11=3,M15,IF('Finisher Model - NE Metric'!$D$11=4,N15,IF('Finisher Model - NE Metric'!$D$11=5,O15,IF('Finisher Model - NE Metric'!$D$11=6,P15,\"\")))))","v":""},{"$f":"C25","v":{"$error":"#VALUE!"}},{"$f":"D25","v":{"$error":"#VALUE!"}},{"$f":"E25","v":{"$error":"#VALUE!"}},{"$f":"F25","v":{"$error":"#VALUE!"}},{"$f":"G25","v":{"$error":"#VALUE!"}}]
["Phase duration, d",{"$f":"'Current Performance - NE '!B16","v":{"$error":"#VALUE!"}},{"$f":"'Current Performance - NE '!C16","v":{"$error":"#VALUE!"}},{"$f":"'Current Performance - NE '!D16","v":{"$error":"#VALUE!"}},{"$f":"'Current Performance - NE '!E16","v":{"$error":"#VALUE!"}},{"$f":"'Current Performance - NE '!F16","v":{"$error":"#VALUE!"}},{"$f":"'Current Performance - NE '!G16","v":{"$error":"#VALUE!"}},{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUM(B16:C16),IF('Finisher Model - NE Metric'!D11=3,SUM(B16:D16),IF('Finisher Model - NE Metric'!D11=4,SUM(B16:E16),IF('Finisher Model - NE Metric'!D11=5,SUM(B16:F16),IF('Finisher Model - NE Metric'!D11=6,SUM(B16:G16),\"\")))))","v":""},null,"Revenue Carcass, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L16,IF('Finisher Model - NE Metric'!$D$11=3,M16,IF('Finisher Model - NE Metric'!$D$11=4,N16,IF('Finisher Model - NE Metric'!$D$11=5,O16,IF('Finisher Model - NE Metric'!$D$11=6,P16,\"\")))))","v":""},{"$f":"SUM(L15*'Finisher Model - NE Metric'!$D$8)","v":{"$error":"#VALUE!"}},{"$f":"SUM(M15*'Finisher Model - NE Metric'!$D$8)","v":{"$error":"#VALUE!"}},{"$f":"SUM(N15*'Finisher Model - NE Metric'!$D$8)","v":{"$error":"#VALUE!"}},{"$f":"SUM(O15*'Finisher Model - NE Metric'!$D$8)","v":{"$error":"#VALUE!"}},{"$f":"SUM(P15*'Finisher Model - NE Metric'!$D$8)","v":{"$error":"#VALUE!"}}]
["Feed budget by phase, kg/pig",{"$f":"CONVERT(D43,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D44,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D45,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D46,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D47,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D48,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},null,null,"Total IOFC Carcass, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L17,IF('Finisher Model - NE Metric'!$D$11=3,M17,IF('Finisher Model - NE Metric'!$D$11=4,N17,IF('Finisher Model - NE Metric'!$D$11=5,O17,IF('Finisher Model - NE Metric'!$D$11=6,P17,\"\")))))","v":""},{"$f":"L16-L10","v":{"$error":"#VALUE!"}},{"$f":"M16-M10","v":{"$error":"#VALUE!"}},{"$f":"N16-N10","v":{"$error":"#VALUE!"}},{"$f":"O16-O10","v":{"$error":"#VALUE!"}},{"$f":"P16-P10","v":{"$error":"#VALUE!"}}]
["Total feed cost per phase, $/pig",{"$f":"(B17*(B9/907))","v":{"$error":"#VALUE!"}},{"$f":"(C17*(C9/907))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"(F17*(F9/907))","v":{"$error":"#VALUE!"}},{"$f":"(G17*(G9/907))","v":{"$error":"#VALUE!"}},null,null,"Total IOFFC Carcass, $/pig",{"$f":"IF('Finisher Model - NE Metric'!$D$11=2,L18,IF('Finisher Model - NE Metric'!$D$11=3,M18,IF('Finisher Model - NE Metric'!$D$11=4,N18,IF('Finisher Model - NE Metric'!$D$11=5,O18,IF('Finisher Model - NE Metric'!$D$11=6,P18,\"\")))))","v":""},{"$f":"L16-L11","v":{"$error":"#VALUE!"}},{"$f":"M16-M11","v":{"$error":"#VALUE!"}},{"$f":"N16-N11","v":{"$error":"#VALUE!"}},{"$f":"O16-O11","v":{"$error":"#VALUE!"}},{"$f":"P16-P11","v":{"$error":"#VALUE!"}}]
["Gain, kg",{"$f":"B11/1000*B16","v":{"$error":"#VALUE!"}},{"$f":"C11/1000*C16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUM(B19:C19)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=3,SUM(B19:D19)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=4,SUM(B19:E19)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=5,SUM(B19:F19)+'Finisher Model - NE Metric'!B17,IF('Finisher Model - NE Metric'!D11=6,SUM(B19:G19)+'Finisher Model - NE Metric'!B17,\"\")))))","v":""}]
["Feed cost per/kg of gain, $/pig",{"$f":"B18/((B11/1000)*B16)","v":{"$error":"#VALUE!"}},{"$f":"C18/((C11/1000)*C16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Feed and facility cost, $/pig",{"$f":"B18+(B16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"C18+(C16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"D18+(D16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"E18+(E16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"F18+(F16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"G18+(G16*'Finisher Model - NE Metric'!$D$10)","v":{"$error":"#VALUE!"}}]
["Revenue per pig, $/pig",{"$f":"B19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"C19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"D19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"E19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"F19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"G19*'Finisher Model - NE Metric'!$D$7","v":{"$error":"#VALUE!"}}]
["IOFC by phase, $/pig",{"$f":"B22-B18","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["IOFFC by phase, $/pig",{"$f":"B22-B21","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Calculated Overall HCW,lb based on final BW and corrected yield",{"$f":"$H$19*B33/100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Yield based on final BW and PIC equation",{"$f":"(VLOOKUP($H$19,$C$55:$I$94,7,TRUE))*100","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($H$19,$C$55:$I$94,7,TRUE))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["User yield",{"$f":"'Finisher Model - NE Metric'!D9","v":0}]
["User/PIC ratio",{"$f":"B27/B26","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Yield equation"]
["Biological STTD P as % of NRC",{"$f":"'Finisher Model - NE Metric'!P17","v":""},{"$f":"'Finisher Model - NE Metric'!P18","v":""},{"$f":"'Finisher Model - NE Metric'!P19","v":""},{"$f":"'Finisher Model - NE Metric'!P20","v":""},{"$f":"'Finisher Model - NE Metric'!P21","v":""},{"$f":"'Finisher Model - NE Metric'!P22","v":""},{"$f":"IF('Finisher Model - NE Metric'!D11=2,SUMPRODUCT(B29:C29,B16:C16)/SUM(B16:C16),IF('Finisher Model - NE Metric'!D11=3,SUMPRODUCT(B29:D29,B16:D16)/SUM(B16:D16),IF('Finisher Model - NE Metric'!D11=4,SUMPRODUCT(B29:E29,B16:E16)/SUM(B16:E16),IF('Finisher Model - NE Metric'!D11=5,SUMPRODUCT(B29:F29,B16:F16)/SUM(B16:F16),IF('Finisher Model - NE Metric'!D11=6,SUMPRODUCT(B29:G29,B16:G16)/SUM(B16:G16),\"\")))))","v":""}]
["Predicted yield based on biological STTD P level",{"$f":"73.859-1.19192*H29","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"73.859 - 1.19192 x STTD P % of NRC"]
["Yield at 100% of NRC",{"$f":"73.859-1.19192*1","v":72.667079999999999}]
["Yield correction factor based on STTD P level",{"$f":"B30/B31","v":{"$error":"#VALUE!"}}]
["Corrected current yield",{"$f":"(VLOOKUP($H$19,$C$55:$K$94,9,TRUE))","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($H$19,$C$55:$K$94,9,TRUE))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[]
[null,"Mixed Sex Feed Budget"]
[null,"Closeout Feed Efficiency"]
[null,"Initial Wt","Final Wt","F/G"]
[null,{"$f":"CONVERT('Finisher Model - NE Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT(H19,\"kg\",\"lbm\")","v":{"$error":"#VALUE!"}},{"$f":"B15","v":""}]
[]
[null,"Initial Wt","Final Wt","lb/pig",{"$f":"IF(B43=0,F42,((0.00463*B43^2 + 1.68*B43 - 22.05)/(((0.00463*C40^2 + 1.68*C40 - 22.05)-(0.00463*B40^2 + 1.68*B40 - 22.05))/(C40-B40))*D40))","v":0}]
[1,{"$f":"CONVERT('Finisher Model - NE Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT('Finisher Model - NE Metric'!C17,\"kg\",\"lbm\")","v":0},{"$f":"IF(C43=\"\",\"\",(E43-E42))","v":{"$error":"#VALUE!"}},{"$f":"IF(B44=\"\",\"\",((0.00463*B44^2 + 1.68*B44 - 22.05)/(((0.00463*$C$40^2 + 1.68*$C$40 - 22.05)-(0.00463*$B$40^2 + 1.68*$B$40 - 22.05))/($C$40-$B$40))*$D$40))","v":{"$error":"#VALUE!"}}]
[2,{"$f":"C43","v":0},{"$f":"CONVERT(IF('Finisher Model - NE Metric'!D11=2,H19,'Finisher Model - NE Metric'!C18),\"kg\",\"lbm\")","v":0},{"$f":"IF(C44=\"\",\"\",(E44-E43))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[3,0,{"$f":"CONVERT(IF('Finisher Model - NE Metric'!D11=3,H19,'Finisher Model - NE Metric'!C19),\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,0,{"$f":"CONVERT(IF('Finisher Model - NE Metric'!D11=4,H19,'Finisher Model - NE Metric'!C20),\"kg\",\"lbm\")","v":0},{"$f":"IF(C46=\"\",\"\",(E46-E45))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[5,{"$f":"C46","v":0},{"$f":"CONVERT(IF('Finisher Model - NE Metric'!D11=5,H19,'Finisher Model - NE Metric'!C21),\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"C47","v":0},{"$f":"CONVERT(IF('Finisher Model - NE Metric'!D11=6,H19,\"\"),\"kg\",\"lbm\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C48=\"\",\"\",(E48-E47))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,{"$f":"C48","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[null,"Hot Carcass Wheight","Market weight    (est. by Carcass yield)","Back Fat for PIC 337",null,null,null,null,"Carcass Yield (%) =                                   66.411 + ( Carcass weight, kg x 0.0878)"]
[null,"kg","kg","Barrows","Gilts","Average",null,null,null,"User/PIC Adjusted Yield","User/PIC Asjusted and STTD P adjusted"]
[null,81,110.17670623134534,16.864782047899471,14.510728742835685,15.687755395367578,null,null,0.73518262408316082,{"$f":"(I55*$B$28)*100","v":{"$error":"#N/A"}},{"$f":"J55*$B$32","v":{"$error":"#N/A"}}]
[null,82,111.4039519642067,17.074455706764272,14.613701440729169,15.844078573746721,null,null,0.73606006388665657,{"$f":"(I56*$B$28)*100","v":{"$error":"#N/A"}},{"$f":"J56*$B$32","v":{"$error":"#N/A"}}]
[null,83,112.6282752396024,17.284147265806148,14.71614342750836,16.000145346657256,null,null,0.73693750369015243,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,84,113.84968648405146,17.493856510850449,14.81806378371237,16.155960147281409,null,null,0.73781494349364829,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,85,115.06819607453319,17.703583232804778,14.919471328516645,16.311527280660712,null,null,0.73869238329714404,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,86,116.28381433878111,17.913327227479776,15.020374630235036,16.466850928857404,null,null,0.7395698231006399,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,87,117.49655155557477,18.123088295418643,15.120782016283018,16.621935155850831,null,null,0.74044726290413565,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,88,118.70641795502937,18.332866241734184,15.220701582635391,16.776783912184786,null,null,0.74132470270763151,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,89,119.91342371888354,18.542660875953423,15.320141202809715,16.931401039381569,null,null,0.74220214251112737,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,90,121.11757898078487,18.752472011869195,15.419108536404257,17.085790274136727,null,null,0.74307958231462312,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,91,122.31889382657351,18.962299467398132,15.517611037217174,17.239955252307652,null,null,0.74395702211811898,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,92,123.51737829456385,19.172143064445141,15.615655960971905,17.393899512708522,null,null,0.74483446192161473,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,93,124.71304237582397,19.382002628773577,15.713250372671933,17.547626500722757,null,null,0.74571190172511059,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,94,125.90589601445348,19.591877989881006,15.81040115360647,17.701139571743738,null,null,0.74658934152860634,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,95,127.09594910785896,19.80176898088045,15.907115008027194,17.854441994453822,null,null,0.7474667813321022,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,96,128.28321150702794,20.011675438386312,16.003398469514622,18.007536953950467,null,null,0.74834422113559795,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,97,129.46769301680052,20.221597202405267,16.099257907051943,18.160427554728606,null,null,0.74922166093909381,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,98,130.64940339613941,20.43153411623155,16.194699530822238,18.313116823526894,null,null,0.75009910074258968,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,99,131.82835235839786,20.641486026346577,16.289729397744711,18.465607712045646,null,null,0.75097654054608542,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,100,133.00454957158581,20.851452782322603,16.384353416763961,18.617903099543284,null,null,0.75185398034958129,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,101,134.17800465863434,21.061434236730111,16.478577353905742,18.770005795317928,null,null,0.75273142015307704,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,102,135.34872719765769,21.27143024504899,16.572406837111849,18.921918541080419,null,null,0.7536088599565729,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,103,136.51672672221434,21.481440665583278,16.665847360865602,19.073644013224438,null,null,0.75448629976006876,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,104,137.68201272156554,21.69146535937886,16.758904290619089,19.225184824998976,null,null,0.75536373956356451,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,105,138.84459464093223,21.901504190144763,16.851582867032572,19.37654352858867,null,null,0.75624117936706026,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,106,140.00448188175039,22.111557024177106,16.943888210035503,19.527722617106306,null,null,0.75711861917055612,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,107,141.16168380192445,22.321623730286092,17.035825322718448,19.678724526502272,null,null,0.75799605897405198,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,108,142.31620971607887,22.531704179725708,17.127399095064437,19.82955163739507,null,null,0.75887349877754773,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,109,143.46806889580807,22.741798246125917,17.218614307527691,19.980206276826806,null,null,0.75975093858104359,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,110,144.61727056992473,22.951905805427518,17.309475634467464,20.130690719947491,null,null,0.76062837838453934,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,111,145.76382392470609,23.162026735819119,17.399987647444007,20.281007191631563,null,null,0.7615058181880352,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,112,146.9077381041389,23.372160917676677,17.49015481838342,20.431157868030049,null,null,0.76238325799153106,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,113,148.04902221016243,23.582308233504943,17.579981522617746,20.581144878061345,null,null,0.76326069779502681,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,114,149.18768530290981,23.792468567881055,17.66947204180623,20.730970304843645,null,null,0.76413813759852267,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,115,150.32373640094792,24.002641807400256,17.758630566743491,20.880636187071872,null,null,0.76501557740201842,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,116,151.45718448151536,24.212827840623181,17.847461200059801,21.030144520341491,null,null,0.76589301720551428,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,117,152.58803848075902,24.423026558025349,17.935967958818601,21.179497258421975,null,null,0.76677045700901003,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,118,153.71630729396878,24.633237851947925,18.024154777015983,21.328696314481952,null,null,0.76764789681250589,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,119,154.84199977581099,24.843461616550663,18.112025507986587,21.477743562268625,null,null,0.76852533661600164,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,120,155.96512474055984,25.053697747765945,18.199583926720305,21.626640837243123,null,null,0.7694027764194975,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Finisher Model - ME Metric","index":7,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":false,"merged":[[28,17,28,18],[29,17,29,18],[17,23,17,24],[21,23,21,24],[25,23,25,24],[27,17,27,19],[15,1,15,2],[0,0,1,8],[13,23,13,24],[5,23,5,24],[6,0,6,2],[7,0,7,2],[9,0,9,2],[10,0,10,2],[9,23,9,24],[13,0,13,2],[8,0,8,2],[5,0,5,2],[14,7,14,8],[14,4,14,5],[28,5,28,7],[24,1,24,3],[25,1,25,3],[26,1,26,3],[24,5,24,7],[25,5,25,7],[26,5,26,7]]}
["            Economic model for optimum phosphorus levels"]
[]
[]
["Input (please fill yellow cells)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STTD P","0.000030626936175869600x2 - 0.009664361472054440000x + 1.476750678631610000000"]
["Economic evaluation criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slot (Phase) 1"]
["Live pig price, $/kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STTD P:ME"]
["Carcass price, $/kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,"Barrows and Gilts",{"$f":"0.0000306269361758696*(U17*U17)- 0.00966436147205444*U17+ 1.47675067863161","v":{"$error":"#VALUE!"}}]
["Current carcass yield, %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Live",3]
["Facility cost, $/pig/day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carcass",4,null,null,null,"Slot (Phase) 2"]
["Number of phases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,"STTD P:ME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,"Barrows and Gilts",{"$f":"0.0000306269361758696*(U18*U18)- 0.00966436147205444*U18+ 1.47675067863161","v":{"$error":"#VALUE!"}}]
[]
["Gender",null,null,"Barrows and gilts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slot (Phase) 3"]
[null,null,null,null,"Maximal growth",null,null,"Current diets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STTD P:ME"]
[null,"BW, kg",null,"Energy, kcal ME/kg","STTD P, % ","$/ton",null,"STTD P, %","$/ton",null,null,null,null,null,null,"Biological % of NRC",null,"Current % of NRC",null,null,"Avg Wt, kg","Gain, kg","NRC, % STTD P","Barrows and Gilts",{"$f":"0.0000306269361758696*(U19*U19)- 0.00966436147205444*U19+ 1.47675067863161","v":{"$error":"#VALUE!"}}]
["Phase 1",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$7:$Y$8,2,FALSE)*D17/10000,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IFERROR(H17/W17,\"\")","v":""},null,{"$f":"IFERROR(E17/W17,\"\")","v":""},null,"Slot (phase 1)",{"$f":"IFERROR(AVERAGE(B17:C17),\"\")","v":""},{"$f":"IF(C17-B17=0,0,C17-B17)","v":0},{"$f":" -0.0012418982*U17+ 0.3522266252","v":{"$error":"#VALUE!"}}]
["Phase 2",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$11:$Y$12,2,FALSE)*D18/10000,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,"Slot (phase 2)","",0,{"$error":"#VALUE!"},"Slot (Phase) 4"]
["Phase 3",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$15:$Y$16,2,FALSE)*D19/10000,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,"Slot (phase 3)","",0,{"$error":"#VALUE!"},null,"STTD P:ME"]
["Phase 4",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$19:$Y$20,2,FALSE)*D20/10000,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,"Slot (phase 4)","",0,{"$error":"#VALUE!"},"Barrows and Gilts",{"$f":"0.0000306269361758696*(U20*U20)- 0.00966436147205444*U20+ 1.47675067863161","v":{"$error":"#VALUE!"}}]
["Phase 5",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$23:$Y$24,2,FALSE)*D21/10000,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,"Slot (phase 5)","",0,{"$error":"#VALUE!"}]
["Phase 6",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$14,$X$28:$Y$29,2,FALSE)*D22/10000,\"\")","v":""},null,null,null,null,null,null,null,"",null,"",null,"Slot (phase 5)","",0,{"$error":"#VALUE!"},"Slot (Phase) 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total gain",{"$f":"SUM(V17:V21)","v":0},null,null,"STTD P:ME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barrows and Gilts",{"$f":"0.0000306269361758696*(U21*U21)- 0.00966436147205444*U21+ 1.47675067863161","v":{"$error":"#VALUE!"}}]
[null,"Performance Output",null,null,null,"Economics Output"]
[null,"Performance difference between maximal growth and current diets, %",null,null,null,"Net profit difference between maximal growth and current diets, $/pig",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slot (Phase) 6"]
[null,"Fixed Weight (space long)",null,null,null,"Fixed Weight (space long)"]
[null,"Growth rate",null,{"$f":"IFERROR(E51,\"\")","v":""},null,{"$f":"IF($D$10>0,\"IOFFC\",\"IOFC\")","v":"IOFC"},null,{"$f":"IFERROR(IF($F$28=\"IOFFC\",$E$59,$E$58),\"\")","v":""},null,null,null,null,null,null,null,null,null,"ADG response",null,null,null,null,null,null,"STTD P:ME"]
[null,"Feed efficiency",null,{"$f":"IFERROR(E52,\"\")","v":""},null,"Fixed Time (space short)",null,null,null,null,null,null,null,null,null,null,null,"Optimum STTD Ca:STTD P",null,2.48,null,null,null,"Barrows and Gilts",{"$f":"0.0000306269361758696*(U22*U22)- 0.00966436147205444*U22+ 1.47675067863161","v":{"$error":"#VALUE!"}}]
[null,"Carcass yield",null,{"$f":"IFERROR(E53,\"\")","v":""},null,"IOFC",null,{"$f":"IFERROR(K58,\"\")","v":""},null,null,null,null,null,null,null,null,null,"Optimum STTD Ca:STTD P",null,1.7849999999999999]
[null,"Fixed Time (space short)"]
[null,"Growth rate",null,{"$f":"IFERROR(K51,\"\")","v":""}]
[null,"Feed efficiency",null,{"$f":"IFERROR(K52,\"\")","v":""}]
[null,"Carcass yield",null,{"$f":"IFERROR(K53,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,0]
[]
["Output - Fixed Weight (space long)",null,null,null,null,null,"Output - Fixed Time (space short)"]
[null,null,"Biological","Current",null,null,null,null,"Biological","Current"]
["% of maximum ADG",null,1,{"$f":"IF(D6=\"Live\",'Current Performance - ME'!K5/'FW - Projected Performance - ME'!K6,'Current Performance - ME'!K5/'FW - Projected Performance - ME'!K17)","v":{"$error":"#VALUE!"}},{"$f":"(D51-C51)/D51","v":{"$error":"#VALUE!"}},null,"% of maximum ADG",null,1,{"$f":"'Current Performance - ME'!K5/'FT - Projected Performance - ME'!K5","v":{"$error":"#VALUE!"}},{"$f":"(J51-I51)/J51","v":{"$error":"#VALUE!"}}]
["% of maximum feed efficiency",null,1,{"$f":"IF(D6=\"Live\",'FW - Projected Performance - ME'!K7/'Current Performance - ME'!K6,'FW - Projected Performance - ME'!K18/'Current Performance - ME'!K6)","v":{"$error":"#VALUE!"}},{"$f":"(D52-C52)/D52","v":{"$error":"#VALUE!"}},null,"% of maximum feed efficiency",null,1,{"$f":"'FT - Projected Performance - ME'!K6/'Current Performance - ME'!K6","v":{"$error":"#VALUE!"}},{"$f":"(J52-I52)/J52","v":{"$error":"#VALUE!"}}]
["Carcass yield",null,{"$f":"'FW - Projected Performance - ME'!B43","v":{"$error":"#N/A"}},{"$f":"'Current Performance - ME'!B36","v":{"$error":"#N/A"}},{"$f":"(D53-C53)/D53","v":{"$error":"#N/A"}},null,"Carcass yield",null,{"$f":"'FT - Projected Performance - ME'!B33","v":{"$error":"#N/A"}},{"$f":"'Current Performance - ME'!B36","v":{"$error":"#N/A"}},{"$f":"(J53-I53)/J53","v":{"$error":"#N/A"}}]
["Economics, $/pig",null,null,null,null,null,"Economics, $/pig"]
["  Total feed cost",null,{"$f":"IF($D$6=\"Live\",'FW - Projected Performance - ME'!K11,'FW - Projected Performance - ME'!K22)","v":""},{"$f":"'Current Performance - ME'!K10","v":""},null,null,"  Total feed cost",null,{"$f":"'FT - Projected Performance - ME'!K10","v":""},{"$f":"'Current Performance - ME'!K10","v":""}]
["  Total feed and facility cost",null,{"$f":"IF($D$6=\"Live\",'FW - Projected Performance - ME'!K12,'FW - Projected Performance - ME'!K23)","v":""},{"$f":"'Current Performance - ME'!K11","v":""},null,null,"  Total feed and facility cost",null,{"$f":"'FT - Projected Performance - ME'!K11","v":""},{"$f":"'Current Performance - ME'!K11","v":""}]
["  Total revenue",null,{"$f":"IF($D$6=\"Live\",'FW - Projected Performance - ME'!K13,'FW - Projected Performance - ME'!K24)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - ME'!K12,'Current Performance - ME'!K15)","v":""},"Difference",null,"  Total revenue",null,{"$f":"IF($D$6=\"Live\",'FT - Projected Performance - ME'!K12,'FT - Projected Performance - ME'!K16)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - ME'!K12,'Current Performance - ME'!K15)","v":""},"Difference"]
["  IOFC",null,{"$f":"IF($D$6=\"Live\",'FW - Projected Performance - ME'!K14,'FW - Projected Performance - ME'!K25)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - ME'!K13,'Current Performance - ME'!K16)","v":""},{"$f":"C58-D58","v":{"$error":"#VALUE!"}},null,"  IOFC",null,{"$f":"IF($D$6=\"Live\",'FT - Projected Performance - ME'!K13,'FT - Projected Performance - ME'!K17)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - ME'!K13,'Current Performance - ME'!K16)","v":""},{"$f":"I58-J58","v":{"$error":"#VALUE!"}}]
["  IOFFC",null,{"$f":"IF($D$6=\"Live\",'FW - Projected Performance - ME'!K15,'FW - Projected Performance - ME'!K26)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - ME'!K14,'Current Performance - ME'!K17)","v":""},{"$f":"C59-D59","v":{"$error":"#VALUE!"}},null,"  IOFFC",null,{"$f":"IF($D$6=\"Live\",'FT - Projected Performance - ME'!K14,'FT - Projected Performance - ME'!K18)","v":""},{"$f":"IF($D$6=\"Live\",'Current Performance - ME'!K14,'Current Performance - ME'!K17)","v":""},{"$f":"I59-J59","v":{"$error":"#VALUE!"}}]

{"sheet":"Current Performance - ME","index":8,"n_rows":96,"n_cols":16,"rows_kept":96,"cut":false,"hidden":true,"merged":[[39,1,39,4],[0,0,0,14],[1,0,3,0],[1,1,2,6],[1,9,2,10],[38,1,38,4]]}
["Economic model for optimum phosphorus level - Model Calculations by phase"]
["Item","Dietary phase",null,null,null,null,null,null,null,"Summary of Calculations with Current Phosphorus Levels"]
[]
[null,1,2,3,4,5,6,null,null,"Item","Output",2,3,4,5,6]
["Starting weight, kg",{"$f":"'Finisher Model - ME Metric'!B17","v":0},{"$f":"'Finisher Model - ME Metric'!B18","v":0},{"$f":"'Finisher Model - ME Metric'!B19","v":0},{"$f":"'Finisher Model - ME Metric'!B20","v":0},{"$f":"'Finisher Model - ME Metric'!B21","v":0},{"$f":"'Finisher Model - ME Metric'!B22","v":0},null,null,"Predicted ADG, kg",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L5,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M5,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N5,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O5,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P5,\"\")))))","v":""},{"$f":"((SUMPRODUCT($B$11:$C$11,$B$16:$C$16)/SUM($B$16:$C$16))/1000)","v":{"$error":"#VALUE!"}},{"$f":"((SUMPRODUCT($B$11:$D$11,$B$16:$D$16)/SUM($B$16:$D$16))/1000)","v":{"$error":"#VALUE!"}},{"$f":"((SUMPRODUCT($B$11:$E$11,$B$16:$E$16)/SUM($B$16:$E$16))/1000)","v":{"$error":"#VALUE!"}},{"$f":"((SUMPRODUCT($B$11:$F$11,$B$16:$F$16)/SUM($B$16:$F$16))/1000)","v":{"$error":"#VALUE!"}},{"$f":"((SUMPRODUCT($B$11:$G$11,$B$16:$G$16)/SUM($B$16:$G$16))/1000)","v":{"$error":"#VALUE!"}}]
["Final weight, kg",{"$f":"'Finisher Model - ME Metric'!C17","v":0},{"$f":"'Finisher Model - ME Metric'!C18","v":0},{"$f":"'Finisher Model - ME Metric'!C19","v":0},{"$f":"'Finisher Model - ME Metric'!C20","v":0},{"$f":"'Finisher Model - ME Metric'!C21","v":0},{"$f":"'Finisher Model - ME Metric'!C22","v":0},null,null,"Predicted F/G",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L6,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M6,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N6,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O6,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P6,\"\")))))","v":""},{"$f":"SUM($B$17:$C$17)/SUM($B$19:$C$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$D$17)/SUM($B$19:$D$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$E$17)/SUM($B$19:$E$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$F$17)/SUM($B$19:$F$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$G$17)/SUM($B$19:$G$19)","v":{"$error":"#VALUE!"}}]
["Total gain, kg",{"$f":"B6-B5","v":0},{"$f":"C6-C5","v":0},0,0,{"$f":"F6-F5","v":0},{"$f":"G6-G5","v":0},null,null,"Predicted ADFI, kg",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L7,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M7,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N7,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O7,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P7,\"\")))))","v":""},{"$f":"SUM(B17:C17)/SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:D17)/SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:E17)/SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:G17)/SUM(B16:G16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(C17:G17)/SUM(C16:G16)","v":{"$error":"#VALUE!"}}]
["Current NE, kcal/kg",{"$f":"'Finisher Model - ME Metric'!D17","v":0},{"$f":"'Finisher Model - ME Metric'!D18","v":0},{"$f":"'Finisher Model - ME Metric'!D19","v":0},{"$f":"'Finisher Model - ME Metric'!D20","v":0},{"$f":"'Finisher Model - ME Metric'!D21","v":0},{"$f":"'Finisher Model - ME Metric'!D22","v":0},null,null,"Phases duration, d",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L8,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M8,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N8,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O8,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P8,\"\")))))","v":""},{"$f":"SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Current Diet Cost, $/Ton",{"$f":"'Finisher Model - ME Metric'!F17","v":0},{"$f":"'Finisher Model - ME Metric'!F18","v":0},{"$f":"'Finisher Model - ME Metric'!F19","v":0},{"$f":"'Finisher Model - ME Metric'!F20","v":0},{"$f":"'Finisher Model - ME Metric'!F21","v":0},{"$f":"'Finisher Model - ME Metric'!F22","v":0},null,null,"Total feed, kg/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L9,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M9,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N9,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O9,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P9,\"\")))))","v":""},{"$f":"SUM(B17:C17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:E17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:F17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:G17)","v":{"$error":"#VALUE!"}}]
["Average Starting Wt & End Wt, kg",{"$f":"AVERAGE(B5:B6)","v":0},{"$f":"AVERAGE(C5:C6)","v":0},0,{"$f":"AVERAGE(E5:E6)","v":0},{"$f":"AVERAGE(F5:F6)","v":0},{"$f":"AVERAGE(G5:G6)","v":0},null,null,"Total feed cost, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L10,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M10,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N10,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O10,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P10,\"\")))))","v":""},{"$f":"SUM(B18:C18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:D18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:F18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:G18)","v":{"$error":"#VALUE!"}}]
["Calculated Overall ADG with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!R17-216.9*('Finisher Model - ME Metric'!R17*'Finisher Model - ME Metric'!R17),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!R18-216.9*('Finisher Model - ME Metric'!R18*'Finisher Model - ME Metric'!R18),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!R19-216.9*('Finisher Model - ME Metric'!R19*'Finisher Model - ME Metric'!R19),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!R20-216.9*('Finisher Model - ME Metric'!R20*'Finisher Model - ME Metric'!R20),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!R21-216.9*('Finisher Model - ME Metric'!R21*'Finisher Model - ME Metric'!R21),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!R22-216.9*('Finisher Model - ME Metric'!R22*'Finisher Model - ME Metric'!R22),\"\")","v":""},null,null,"Total feed cost & facility cost, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L11,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M11,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N11,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O11,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P11,\"\")))))","v":""},{"$f":"SUM(B21:C21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:D21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:E21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:F21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:G21)","v":{"$error":"#VALUE!"}}]
["Calculated Overall G:F with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!R17-46.7864*('Finisher Model - ME Metric'!R17*'Finisher Model - ME Metric'!R17),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!R18-46.7864*('Finisher Model - ME Metric'!R18*'Finisher Model - ME Metric'!R18),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!R19-46.7864*('Finisher Model - ME Metric'!R19*'Finisher Model - ME Metric'!R19),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!R20-46.7864*('Finisher Model - ME Metric'!R20*'Finisher Model - ME Metric'!R20),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!R21-46.7864*('Finisher Model - ME Metric'!R21*'Finisher Model - ME Metric'!R21),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!R22-46.7864*('Finisher Model - ME Metric'!R22*'Finisher Model - ME Metric'!R22),\"\")","v":""},null,null,"Revenue Live, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L12,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M12,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N12,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O12,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P12,\"\")))))","v":""},{"$f":"SUM(B19:C19,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:D19,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:E19,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:F19,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:G19,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}}]
["Predicted Overall ADFI, g/d",{"$f":"(B11/B12)*1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFC Live, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L13,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M13,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N13,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O13,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P13,\"\")))))","v":""},{"$f":"L12-L10","v":{"$error":"#VALUE!"}},{"$f":"M12-M10","v":{"$error":"#VALUE!"}},{"$f":"N12-N10","v":{"$error":"#VALUE!"}},{"$f":"O12-O10","v":{"$error":"#VALUE!"}},{"$f":"P12-P10","v":{"$error":"#VALUE!"}}]
["Precited Overall F/G",{"$f":"B13/B11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFFC Live, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L14,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M14,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N14,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O14,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P14,\"\")))))","v":""},{"$f":"L12-L11","v":{"$error":"#VALUE!"}},{"$f":"M12-M11","v":{"$error":"#VALUE!"}},{"$f":"N12-N11","v":{"$error":"#VALUE!"}},{"$f":"O12-O11","v":{"$error":"#VALUE!"}},{"$f":"P12-P11","v":{"$error":"#VALUE!"}}]
["Overall average F/G (weighted average based on phase duration)",{"$f":"IF('Finisher Model - ME Metric'!D11=2,(SUMPRODUCT(B14:C14,B16:C16)/SUM(B16:C16)),IF('Finisher Model - ME Metric'!D11=3,(SUMPRODUCT(B14:D14,B16:D16)/SUM(B16:D16)),IF('Finisher Model - ME Metric'!D11=4,(SUMPRODUCT(B14:E14,B16:E16)/SUM(B16:E16)),IF('Finisher Model - ME Metric'!D11=5,(SUMPRODUCT(B14:F14,B16:F16)/SUM(B16:F16)),IF('Finisher Model - ME Metric'!D11=6,(SUMPRODUCT(B14:G14,B16:G16)/SUM(B16:G16)),\"\")))))","v":""},null,null,null,null,null,null,null,"Revenue Carcass, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L15,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M15,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N15,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O15,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P15,\"\")))))","v":""},{"$f":"C28*'Finisher Model - ME Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"D28*'Finisher Model - ME Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"E28*'Finisher Model - ME Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"F28*'Finisher Model - ME Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"G28*'Finisher Model - ME Metric'!$D$8","v":{"$error":"#VALUE!"}}]
["Phase duration, d",{"$f":"(CONVERT(B7,\"kg\",\"g\"))/B11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUM(B16:C16),IF('Finisher Model - ME Metric'!D11=3,SUM(B16:D16),IF('Finisher Model - ME Metric'!D11=4,SUM(B16:E16),IF('Finisher Model - ME Metric'!D11=5,SUM(B16:F16),IF('Finisher Model - ME Metric'!D11=6,SUM(B16:G16),\"\")))))","v":""},null,"Total IOFC Carcass, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L16,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M16,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N16,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O16,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P16,\"\")))))","v":""},{"$f":"L15-L10","v":{"$error":"#VALUE!"}},{"$f":"M15-M10","v":{"$error":"#VALUE!"}},{"$f":"N15-N10","v":{"$error":"#VALUE!"}},{"$f":"O15-O10","v":{"$error":"#VALUE!"}},{"$f":"P15-P10","v":{"$error":"#VALUE!"}}]
["Feed budget by phase, kg/pig",{"$f":"CONVERT(D45,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D46,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D47,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D48,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D49,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D50,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},null,null,"Total IOFFC Carcass $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,'Current Performance - ME'!L17,IF('Finisher Model - ME Metric'!$D$11=3,'Current Performance - ME'!M17,IF('Finisher Model - ME Metric'!$D$11=4,'Current Performance - ME'!N17,IF('Finisher Model - ME Metric'!$D$11=5,'Current Performance - ME'!O17,IF('Finisher Model - ME Metric'!$D$11=6,'Current Performance - ME'!P17,\"\")))))","v":""},{"$f":"L15-L11","v":{"$error":"#VALUE!"}},{"$f":"M15-M11","v":{"$error":"#VALUE!"}},{"$f":"N15-N11","v":{"$error":"#VALUE!"}},{"$f":"O15-O11","v":{"$error":"#VALUE!"}},{"$f":"P15-P11","v":{"$error":"#VALUE!"}}]
["Total feed cost per phase, $/pig",{"$f":"(B17*(B9/907))","v":{"$error":"#VALUE!"}},{"$f":"(C17*(C9/907))","v":{"$error":"#VALUE!"}},{"$f":"(D17*(D9/907))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Gain, kg",{"$f":"B11/1000*B16","v":{"$error":"#VALUE!"}},{"$f":"C11/1000*C16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUM(B19:C19)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=3,SUM(B19:D19)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=4,SUM(B19:E19)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=5,SUM(B19:F19)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=6,SUM(B19:G19)+'Finisher Model - ME Metric'!B17,\"\")))))","v":""}]
["Feed cost per/lb of gain, $/pig",{"$f":"B18/((B11/1000)*B16)","v":{"$error":"#VALUE!"}},{"$f":"C18/((C11/1000)*C16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Feed and facility cost, $/pig",{"$f":"B18+(B16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"C18+(C16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"D18+(D16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"E18+(E16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"F18+(F16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"G18+(G16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}}]
[]
["Revenue per pig by phase, $/pig",{"$f":"B19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"C19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"D19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"E19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"F19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"G19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}}]
["IOFC by phase, $/pig",{"$f":"B23-B18","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["IOFFC by phase, $/pig",{"$f":"B23-B21","v":{"$error":"#VALUE!"}},{"$f":"C23-C21","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["STTD P",{"$f":"'Finisher Model - ME Metric'!R17","v":""},{"$f":"'Finisher Model - ME Metric'!R18","v":""},{"$f":"'Finisher Model - ME Metric'!R19","v":""},{"$f":"'Finisher Model - ME Metric'!R20","v":""},{"$f":"'Finisher Model - ME Metric'!R21","v":""},{"$f":"'Finisher Model - ME Metric'!R22","v":""}]
["Weighted average of STTD P",{"$f":"SUMPRODUCT(B26,B17)/SUM(B17)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B26:C26,B17:C17)/SUM(B17:C17)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B26:D26,B17:D17)/SUM(B17:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B26:E26,B17:E17)/SUM(B17:E17)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B26:F26,B17:F17)/SUM(B17:F17)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B26:G26,B17:G17)/SUM(B17:G17)","v":{"$error":"#VALUE!"}}]
["Calculated Overall HCW, lb based on final BW and corrected yield",{"$f":"$H$19*B36/100","v":{"$error":"#VALUE!"}},{"$f":"$H$19*C36/100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Yield based on final body weight and PIC equation",{"$f":"(VLOOKUP($H$19,$C$57:$I$96,7,TRUE))*100","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($H$19,$C$57:$I$96,7,TRUE))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["User yield",{"$f":"'Finisher Model - ME Metric'!D9","v":0}]
["User/PIC ratio",{"$f":"B30/B29","v":{"$error":"#N/A"}}]
["Current STTD P as a % of NRC",{"$f":"'Finisher Model - ME Metric'!R17","v":""},{"$f":"'Finisher Model - ME Metric'!R18","v":""},{"$f":"'Finisher Model - ME Metric'!R19","v":""},{"$f":"'Finisher Model - ME Metric'!R20","v":""},{"$f":"'Finisher Model - ME Metric'!R21","v":""},{"$f":"'Finisher Model - ME Metric'!R22","v":""},{"$f":"IF('Finisher Model - ME Metric'!D11=2,(SUMPRODUCT(B32:C32,B16:C16)/SUM(B16:C16)),IF('Finisher Model - ME Metric'!D11=3,(SUMPRODUCT(B32:D32,B16:D16)/SUM(B16:D16)),IF('Finisher Model - ME Metric'!D11=4,(SUMPRODUCT(B32:E32,B16:E16)/SUM(B16:E16)),IF('Finisher Model - ME Metric'!D11=5,(SUMPRODUCT(B32:F32,B16:F16)/SUM(B16:F16)),IF('Finisher Model - ME Metric'!D11=6,(SUMPRODUCT(B32:G32,B16:G16)/SUM(B16:G16)),\"\")))))","v":""}]
["Predicted yield based on STTD P level",{"$f":"73.859-1.19192*H32","v":{"$error":"#VALUE!"}}]
["Yield at 100% of NRC",{"$f":"73.859-1.19192*1","v":72.667079999999999}]
["Yield correction factor based on STTD P level",{"$f":"B33/$B$34","v":{"$error":"#VALUE!"}}]
["Corrected current yield",{"$f":"(VLOOKUP($H$19,$C$57:$K$96,9,TRUE))","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($H$19,$C$57:$K$96,9,TRUE))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[null,"Mixed Sex Feed Budget",null,null,null,null,null,null,null,"Yield equation"]
[null,"Closeout Feed Efficiency",null,null,null,null,null,null,null,"73.859 - 1.19192 x STTD P % of NRC"]
[null,"Initial Wt","Final Wt","F/G"]
[null,{"$f":"CONVERT('Finisher Model - ME Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT(IF('Finisher Model - ME Metric'!$D$11=2,'Finisher Model - ME Metric'!C18,IF('Finisher Model - ME Metric'!$D$11=3,'Finisher Model - ME Metric'!C19,IF('Finisher Model - ME Metric'!$D$11=4,'Finisher Model - ME Metric'!C20,IF('Finisher Model - ME Metric'!$D$11=5,'Finisher Model - ME Metric'!C21,IF('Finisher Model - ME Metric'!$D$11=6,'Finisher Model - ME Metric'!C22,\"\"))))),\"kg\",\"lbm\")","v":{"$error":"#VALUE!"}},{"$f":"B15","v":""}]
[]
[null,"Initial Wt","Final Wt","lb/pig",{"$f":"IF(B45=0,F44,((0.00463*B45^2 + 1.68*B45 - 22.05)/(((0.00463*C42^2 + 1.68*C42 - 22.05)-(0.00463*B42^2 + 1.68*B42 - 22.05))/(C42-B42))*D42))","v":0}]
[1,{"$f":"CONVERT('Finisher Model - ME Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT('Finisher Model - ME Metric'!C17,\"kg\",\"lbm\")","v":0},{"$f":"IF(C45=\"\",\"\",(E45-E44))","v":{"$error":"#VALUE!"}},{"$f":"IF(B46=\"\",\"\",((0.00463*B46^2 + 1.68*B46 - 22.05)/(((0.00463*$C$42^2 + 1.68*$C$42 - 22.05)-(0.00463*$B$42^2 + 1.68*$B$42 - 22.05))/($C$42-$B$42))*$D$42))","v":{"$error":"#VALUE!"}}]
[2,{"$f":"C45","v":0},{"$f":"CONVERT('Finisher Model - ME Metric'!C18,\"kg\",\"lbm\")","v":0},{"$f":"IF(C46=\"\",\"\",(E46-E45))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[3,0,{"$f":"CONVERT('Finisher Model - ME Metric'!C19,\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,0,{"$f":"CONVERT('Finisher Model - ME Metric'!C20,\"kg\",\"lbm\")","v":0},{"$f":"IF(C48=\"\",\"\",(E48-E47))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[5,0,{"$f":"CONVERT('Finisher Model - ME Metric'!C21,\"kg\",\"lbm\")","v":0},{"$f":"IF(C49=\"\",\"\",(E49-E48))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[6,0,{"$f":"CONVERT('Finisher Model - ME Metric'!C22,\"kg\",\"lbm\")","v":0},{"$f":"IF(C50=\"\",\"\",(E50-E49))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,0]
[]
[]
[]
[null,"Hot Carcass Wheight","Market weight    (est. by Carcass yield)","Back Fat for PIC 337",null,null,null,null,"Carcass Yield (%) =                                   66.411 + ( Carcass weight, kg x 0.0878)"]
[null,"kg","kg","Barrows","Gilts","Average",null,null,null,"User/PIC Adjusted Yield","User/PIC Asjusted and STTD P adjusted"]
[null,81,110.17670623134534,16.864782047899471,14.510728742835685,15.687755395367578,null,null,0.73518262408316082,{"$f":"($B$31*I57)*100","v":{"$error":"#N/A"}},{"$f":"J57*$B$35","v":{"$error":"#N/A"}}]
[null,82,111.4039519642067,17.074455706764272,14.613701440729169,15.844078573746721,null,null,0.73606006388665657,{"$f":"($B$31*I58)*100","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,83,112.6282752396024,17.284147265806148,14.71614342750836,16.000145346657256,null,null,0.73693750369015243,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,84,113.84968648405146,17.493856510850449,14.81806378371237,16.155960147281409,null,null,0.73781494349364829,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,85,115.06819607453319,17.703583232804778,14.919471328516645,16.311527280660712,null,null,0.73869238329714404,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,86,116.28381433878111,17.913327227479776,15.020374630235036,16.466850928857404,null,null,0.7395698231006399,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,87,117.49655155557477,18.123088295418643,15.120782016283018,16.621935155850831,null,null,0.74044726290413565,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,88,118.70641795502937,18.332866241734184,15.220701582635391,16.776783912184786,null,null,0.74132470270763151,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,89,119.91342371888354,18.542660875953423,15.320141202809715,16.931401039381569,null,null,0.74220214251112737,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,90,121.11757898078487,18.752472011869195,15.419108536404257,17.085790274136727,null,null,0.74307958231462312,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,91,122.31889382657351,18.962299467398132,15.517611037217174,17.239955252307652,null,null,0.74395702211811898,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,92,123.51737829456385,19.172143064445141,15.615655960971905,17.393899512708522,null,null,0.74483446192161473,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,93,124.71304237582397,19.382002628773577,15.713250372671933,17.547626500722757,null,null,0.74571190172511059,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,94,125.90589601445348,19.591877989881006,15.81040115360647,17.701139571743738,null,null,0.74658934152860634,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,95,127.09594910785896,19.80176898088045,15.907115008027194,17.854441994453822,null,null,0.7474667813321022,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,96,128.28321150702794,20.011675438386312,16.003398469514622,18.007536953950467,null,null,0.74834422113559795,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,97,129.46769301680052,20.221597202405267,16.099257907051943,18.160427554728606,null,null,0.74922166093909381,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,98,130.64940339613941,20.43153411623155,16.194699530822238,18.313116823526894,null,null,0.75009910074258968,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,99,131.82835235839786,20.641486026346577,16.289729397744711,18.465607712045646,null,null,0.75097654054608542,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,100,133.00454957158581,20.851452782322603,16.384353416763961,18.617903099543284,null,null,0.75185398034958129,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,101,134.17800465863434,21.061434236730111,16.478577353905742,18.770005795317928,null,null,0.75273142015307704,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,102,135.34872719765769,21.27143024504899,16.572406837111849,18.921918541080419,null,null,0.7536088599565729,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,103,136.51672672221434,21.481440665583278,16.665847360865602,19.073644013224438,null,null,0.75448629976006876,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,104,137.68201272156554,21.69146535937886,16.758904290619089,19.225184824998976,null,null,0.75536373956356451,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,105,138.84459464093223,21.901504190144763,16.851582867032572,19.37654352858867,null,null,0.75624117936706026,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,106,140.00448188175039,22.111557024177106,16.943888210035503,19.527722617106306,null,null,0.75711861917055612,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,107,141.16168380192445,22.321623730286092,17.035825322718448,19.678724526502272,null,null,0.75799605897405198,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,108,142.31620971607887,22.531704179725708,17.127399095064437,19.82955163739507,null,null,0.75887349877754773,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,109,143.46806889580807,22.741798246125917,17.218614307527691,19.980206276826806,null,null,0.75975093858104359,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,110,144.61727056992473,22.951905805427518,17.309475634467464,20.130690719947491,null,null,0.76062837838453934,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,111,145.76382392470609,23.162026735819119,17.399987647444007,20.281007191631563,null,null,0.7615058181880352,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,112,146.9077381041389,23.372160917676677,17.49015481838342,20.431157868030049,null,null,0.76238325799153106,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,113,148.04902221016243,23.582308233504943,17.579981522617746,20.581144878061345,null,null,0.76326069779502681,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,114,149.18768530290981,23.792468567881055,17.66947204180623,20.730970304843645,null,null,0.76413813759852267,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,115,150.32373640094792,24.002641807400256,17.758630566743491,20.880636187071872,null,null,0.76501557740201842,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,116,151.45718448151536,24.212827840623181,17.847461200059801,21.030144520341491,null,null,0.76589301720551428,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,117,152.58803848075902,24.423026558025349,17.935967958818601,21.179497258421975,null,null,0.76677045700901003,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,118,153.71630729396878,24.633237851947925,18.024154777015983,21.328696314481952,null,null,0.76764789681250589,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,119,154.84199977581099,24.843461616550663,18.112025507986587,21.477743562268625,null,null,0.76852533661600164,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,120,155.96512474055984,25.053697747765945,18.199583926720305,21.626640837243123,null,null,0.7694027764194975,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"FW - Projected Performance - ME","index":9,"n_rows":120,"n_cols":16,"rows_kept":120,"cut":false,"hidden":true,"merged":[[78,3,78,5],[78,8,79,8],[0,0,0,14],[1,0,3,0],[1,1,2,6],[1,9,2,10],[44,1,44,4],[45,1,45,4],[44,6,44,9],[45,6,45,9]]}
["Economic model for optimum phosphorus level - Model Calculations by phase"]
["Item","Dietary phase",null,null,null,null,null,null,null,"Summary of Calculations with Current Phosphorus Levels"]
[]
[null,1,2,3,4,5,6,null,null,"Item","Output",2,3,4,5,6]
["Starting weight, kg",{"$f":"'Finisher Model - ME Metric'!B17","v":0},{"$f":"'Finisher Model - ME Metric'!B18","v":0},{"$f":"'Finisher Model - ME Metric'!B19","v":0},{"$f":"'Finisher Model - ME Metric'!B20","v":0},{"$f":"'Finisher Model - ME Metric'!B21","v":0},{"$f":"'Finisher Model - ME Metric'!B22","v":0},null,null,"Live"]
["Final weight, kg",{"$f":"'Finisher Model - ME Metric'!C17","v":0},{"$f":"'Finisher Model - ME Metric'!C18","v":0},{"$f":"'Finisher Model - ME Metric'!C19","v":0},{"$f":"'Finisher Model - ME Metric'!C20","v":0},{"$f":"'Finisher Model - ME Metric'!C21","v":0},{"$f":"'Finisher Model - ME Metric'!C22","v":0},null,null,"Predicted ADG, kg",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L6,IF('Finisher Model - ME Metric'!$D$11=3,M6,IF('Finisher Model - ME Metric'!$D$11=4,N6,IF('Finisher Model - ME Metric'!$D$11=5,O6,IF('Finisher Model - ME Metric'!$D$11=6,P6,\"\")))))","v":""},{"$f":"((SUM($B$22:$C$22)/SUM(B16:C16)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$22:$D$22)/SUM(B16:D16)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$22:$E$22)/SUM(B16:E16)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$22:$F$22)/SUM(B16:F16)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$22:$G$22)/SUM(B16:G16)))","v":{"$error":"#VALUE!"}}]
["Total gain, kg",{"$f":"B6-B5","v":0},{"$f":"C6-C5","v":0},0,0,0,0,null,null,"Predicted F/G",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L7,IF('Finisher Model - ME Metric'!$D$11=3,M7,IF('Finisher Model - ME Metric'!$D$11=4,N7,IF('Finisher Model - ME Metric'!$D$11=5,O7,IF('Finisher Model - ME Metric'!$D$11=6,P7,\"\")))))","v":""},{"$f":"SUM($B$18:$C$18)/SUM($B$22:$C$22)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$18:$D$18)/SUM($B$22:$D$22)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$18:$E$18)/SUM($B$22:$E$22)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$18:$F$18)/SUM($B$22:$F$22)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$18:$G$18)/SUM($B$22:$G$22)","v":{"$error":"#VALUE!"}}]
["Current NE, kcal/kg",{"$f":"'Finisher Model - ME Metric'!D17","v":0},{"$f":"'Finisher Model - ME Metric'!D18","v":0},{"$f":"'Finisher Model - ME Metric'!D19","v":0},{"$f":"'Finisher Model - ME Metric'!D20","v":0},{"$f":"'Finisher Model - ME Metric'!D21","v":0},{"$f":"'Finisher Model - ME Metric'!D22","v":0},null,null,"Predicted ADFI, kg",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L8,IF('Finisher Model - ME Metric'!$D$11=3,M8,IF('Finisher Model - ME Metric'!$D$11=4,N8,IF('Finisher Model - ME Metric'!$D$11=5,O8,IF('Finisher Model - ME Metric'!$D$11=6,P8,\"\")))))","v":""},{"$f":"SUM(B18:C18)/SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:D18)/SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:E18)/SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:F18)/SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:G18)/SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Current Diet Cost, $/Ton",{"$f":"'Finisher Model - ME Metric'!I17","v":0},{"$f":"'Finisher Model - ME Metric'!I18","v":0},{"$f":"'Finisher Model - ME Metric'!I19","v":0},{"$f":"'Finisher Model - ME Metric'!I20","v":0},{"$f":"'Finisher Model - ME Metric'!I21","v":0},{"$f":"'Finisher Model - ME Metric'!I22","v":0},null,null,"Phases duration, d",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L9,IF('Finisher Model - ME Metric'!$D$11=3,M9,IF('Finisher Model - ME Metric'!$D$11=4,N9,IF('Finisher Model - ME Metric'!$D$11=5,O9,IF('Finisher Model - ME Metric'!$D$11=6,P9,\"\")))))","v":""},{"$f":"SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Average Starting Wt & End Wt, kg",{"$f":"AVERAGE(B5:B6)","v":0},{"$f":"AVERAGE(C5:C6)","v":0},0,0,{"$f":"AVERAGE(F5:F6)","v":0},{"$f":"AVERAGE(G5:G6)","v":0},null,null,"Total feed, kg/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L10,IF('Finisher Model - ME Metric'!$D$11=3,M10,IF('Finisher Model - ME Metric'!$D$11=4,N10,IF('Finisher Model - ME Metric'!$D$11=5,O10,IF('Finisher Model - ME Metric'!$D$11=6,P10,\"\")))))","v":""},{"$f":"SUM(B18:C18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:D18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:F18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:G18)","v":{"$error":"#VALUE!"}}]
["Calculated Overall ADG with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P17-216.9*('Finisher Model - ME Metric'!P17*'Finisher Model - ME Metric'!P17),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P18-216.9*('Finisher Model - ME Metric'!P18*'Finisher Model - ME Metric'!P18),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P19-216.9*('Finisher Model - ME Metric'!P19*'Finisher Model - ME Metric'!P19),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P20-216.9*('Finisher Model - ME Metric'!P20*'Finisher Model - ME Metric'!P20),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P21-216.9*('Finisher Model - ME Metric'!P21*'Finisher Model - ME Metric'!P21),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P22-216.9*('Finisher Model - ME Metric'!P22*'Finisher Model - ME Metric'!P22),\"\")","v":""},null,null,"Total feed cost, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L11,IF('Finisher Model - ME Metric'!$D$11=3,M11,IF('Finisher Model - ME Metric'!$D$11=4,N11,IF('Finisher Model - ME Metric'!$D$11=5,O11,IF('Finisher Model - ME Metric'!$D$11=6,P11,\"\")))))","v":""},{"$f":"SUM(B20:C20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B20:D20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B20:E20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B20:F20)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B20:G20)","v":{"$error":"#VALUE!"}}]
["Calculated Overall G:F with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P17-46.7864*('Finisher Model - ME Metric'!P17*'Finisher Model - ME Metric'!P17),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P18-46.7864*('Finisher Model - ME Metric'!P18*'Finisher Model - ME Metric'!P18),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P19-46.7864*('Finisher Model - ME Metric'!P19*'Finisher Model - ME Metric'!P19),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P20-46.7864*('Finisher Model - ME Metric'!P20*'Finisher Model - ME Metric'!P20),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P21-46.7864*('Finisher Model - ME Metric'!P21*'Finisher Model - ME Metric'!P21),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P22-46.7864*('Finisher Model - ME Metric'!P22*'Finisher Model - ME Metric'!P22),\"\")","v":""},null,null,"Total feed cost & facility cost, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L12,IF('Finisher Model - ME Metric'!$D$11=3,M12,IF('Finisher Model - ME Metric'!$D$11=4,N12,IF('Finisher Model - ME Metric'!$D$11=5,O12,IF('Finisher Model - ME Metric'!$D$11=6,P12,\"\")))))","v":""},{"$f":"SUM(B26:C26)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B26:D26)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B26:E26)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B26:F26)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B26:G26)","v":{"$error":"#VALUE!"}}]
["Predicted Overall ADFI, g/d",{"$f":"(B11/B12)*1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Revenue Live, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L13,IF('Finisher Model - ME Metric'!$D$11=3,M13,IF('Finisher Model - ME Metric'!$D$11=4,N13,IF('Finisher Model - ME Metric'!$D$11=5,O13,IF('Finisher Model - ME Metric'!$D$11=6,P13,\"\")))))","v":""},{"$f":"SUM(B22:C22,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B22:D22,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B22:E22,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B22:F22,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B22:G22,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}}]
["Predicted Overall F/G",{"$f":"B13/B11","v":{"$error":"#VALUE!"}},{"$f":"C13/C11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFC Live, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L14,IF('Finisher Model - ME Metric'!$D$11=3,M14,IF('Finisher Model - ME Metric'!$D$11=4,N14,IF('Finisher Model - ME Metric'!$D$11=5,O14,IF('Finisher Model - ME Metric'!$D$11=6,P14,\"\")))))","v":""},{"$f":"L13-L11","v":{"$error":"#VALUE!"}},{"$f":"M13-M11","v":{"$error":"#VALUE!"}},{"$f":"N13-N11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"P13-P11","v":{"$error":"#VALUE!"}}]
["Overall average F/G (weighted average based on phase duration)",{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUMPRODUCT(B14:C14,B16:C16)/SUM(B16:C16),IF('Finisher Model - ME Metric'!D11=3,SUMPRODUCT(B14:D14,B16:D16)/SUM(B16:D16),IF('Finisher Model - ME Metric'!D11=4,SUMPRODUCT(B14:E14,B16:E16)/SUM(B16:E16),IF('Finisher Model - ME Metric'!D11=5,SUMPRODUCT(B14:F14,B16:F16)/SUM(B16:F16),IF('Finisher Model - ME Metric'!D11=6,SUMPRODUCT(B14:G14,B16:G16)/SUM(B16:G16),\"\")))))","v":""},null,null,null,null,null,null,null,"Total IOFFC Live, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L15,IF('Finisher Model - ME Metric'!$D$11=3,M15,IF('Finisher Model - ME Metric'!$D$11=4,N15,IF('Finisher Model - ME Metric'!$D$11=5,O15,IF('Finisher Model - ME Metric'!$D$11=6,P15,\"\")))))","v":""},{"$f":"L13-L12","v":{"$error":"#VALUE!"}},{"$f":"M13-M12","v":{"$error":"#VALUE!"}},{"$f":"N13-N12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"P13-P12","v":{"$error":"#VALUE!"}}]
["Phase duration, d for Live Basis",{"$f":"(CONVERT(B7,\"kg\",\"g\"))/B11","v":{"$error":"#VALUE!"}},{"$f":"(CONVERT(C7,\"kg\",\"g\"))/C11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUM(B16:C16),IF('Finisher Model - ME Metric'!D11=3,SUM(B16:D16),IF('Finisher Model - ME Metric'!D11=4,SUM(B16:E16),IF('Finisher Model - ME Metric'!D11=5,SUM(B16:F16),IF('Finisher Model - ME Metric'!D11=6,SUM(B16:G16),\"\")))))","v":""},null,"Carcass"]
["Phase duration, d for Carcass Basis",{"$f":"(B6-B5)/(B11/1000)","v":{"$error":"#VALUE!"}},{"$f":"(IF('Finisher Model - ME Metric'!D11=2,'FW - Projected Performance - ME'!$B$34-'FW - Projected Performance - ME'!C5,'FW - Projected Performance - ME'!C6-'FW - Projected Performance - ME'!C5))/('FW - Projected Performance - ME'!C11/1000)","v":{"$error":"#VALUE!"}},{"$f":"(IF('Finisher Model - ME Metric'!$D$11=3,'FW - Projected Performance - ME'!$B$34-'FW - Projected Performance - ME'!D5,'FW - Projected Performance - ME'!D6-'FW - Projected Performance - ME'!D5))/('FW - Projected Performance - ME'!D11/1000)","v":{"$error":"#VALUE!"}},{"$f":"(IF('Finisher Model - ME Metric'!$D$11=4,'FW - Projected Performance - ME'!$B$34-'FW - Projected Performance - ME'!E5,'FW - Projected Performance - ME'!E6-'FW - Projected Performance - ME'!E5))/('FW - Projected Performance - ME'!E11/1000)","v":{"$error":"#VALUE!"}},{"$f":"(IF('Finisher Model - ME Metric'!$D$11=5,'FW - Projected Performance - ME'!$B$34-'FW - Projected Performance - ME'!F5,'FW - Projected Performance - ME'!F6-'FW - Projected Performance - ME'!F5))/('FW - Projected Performance - ME'!F11/1000)","v":{"$error":"#VALUE!"}},{"$f":"(IF('Finisher Model - ME Metric'!$D$11=6,'FW - Projected Performance - ME'!$B$34-'FW - Projected Performance - ME'!G5,'FW - Projected Performance - ME'!G6-'FW - Projected Performance - ME'!G5))/('FW - Projected Performance - ME'!G11/1000)","v":{"$error":"#VALUE!"}},{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUM(B17:C17),IF('Finisher Model - ME Metric'!D11=3,SUM(B17:D17),IF('Finisher Model - ME Metric'!D11=4,SUM(B17:E17),IF('Finisher Model - ME Metric'!D11=5,SUM(B17:F17),IF('Finisher Model - ME Metric'!D11=6,SUM(B17:G17),\"\")))))","v":""},null,"Predicted ADG, kg",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L17,IF('Finisher Model - ME Metric'!$D$11=3,M17,IF('Finisher Model - ME Metric'!$D$11=4,N17,IF('Finisher Model - ME Metric'!$D$11=5,O17,IF('Finisher Model - ME Metric'!$D$11=6,P17,\"\")))))","v":""},{"$f":"((SUM($B$23:$C$23)/SUM(B17:C17)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$23:$D$23)/SUM(B17:D17)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$23:$E$23)/SUM(B17:E17)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$23:$F$23)/SUM(B17:F17)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM($B$23:$G$23)/SUM(B17:G17)))","v":{"$error":"#VALUE!"}}]
["Feed budget by phase, kg/pig for Live Basis",{"$f":"CONVERT(D51,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D52,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D53,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D54,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D55,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D56,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},null,null,"Predicted F/G",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L18,IF('Finisher Model - ME Metric'!$D$11=3,M18,IF('Finisher Model - ME Metric'!$D$11=4,N18,IF('Finisher Model - ME Metric'!$D$11=5,O18,IF('Finisher Model - ME Metric'!$D$11=6,P18,\"\")))))","v":""},{"$f":"SUM($B$19:$C$19)/SUM($B$23:$C$23)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$19:$D$19)/SUM($B$23:$D$23)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$19:$E$19)/SUM($B$23:$E$23)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$19:$F$19)/SUM($B$23:$F$23)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$19:$G$19)/SUM($B$23:$G$23)","v":{"$error":"#VALUE!"}}]
["Feed budget by phase, kg/pig for Carcass Basis",{"$f":"CONVERT(I51,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(I52,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(I53,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(I54,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(I55,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(I56,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},null,null,"Predicted ADFI, kg",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L19,IF('Finisher Model - ME Metric'!$D$11=3,M19,IF('Finisher Model - ME Metric'!$D$11=4,N19,IF('Finisher Model - ME Metric'!$D$11=5,O19,IF('Finisher Model - ME Metric'!$D$11=6,P19,\"\")))))","v":""},{"$f":"SUM(B19:C19)/SUM(B17:C17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:D19)/SUM(B17:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:E19)/SUM(B17:E17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:F19)/SUM(B17:F17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:G19)/SUM(B17:G17)","v":{"$error":"#VALUE!"}}]
["Total feed cost per phase, $/pig for Live Basis",{"$f":"(B18*(B9/907))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Phases duration, d",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L20,IF('Finisher Model - ME Metric'!$D$11=3,M20,IF('Finisher Model - ME Metric'!$D$11=4,N20,IF('Finisher Model - ME Metric'!$D$11=5,O20,IF('Finisher Model - ME Metric'!$D$11=6,P20,\"\")))))","v":""},{"$f":"SUM(B17:C17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:E17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:F17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:G17)","v":{"$error":"#VALUE!"}}]
["Total feed cost per phase, $/pig for Carcass Basis",{"$f":"(B19*(B9/907))","v":{"$error":"#VALUE!"}},{"$f":"(C19*(C9/907))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total feed, kg/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L21,IF('Finisher Model - ME Metric'!$D$11=3,M21,IF('Finisher Model - ME Metric'!$D$11=4,N21,IF('Finisher Model - ME Metric'!$D$11=5,O21,IF('Finisher Model - ME Metric'!$D$11=6,P21,\"\")))))","v":""},{"$f":"SUM(B19:C19)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:D19)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:E19)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:F19)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:G19)","v":{"$error":"#VALUE!"}}]
["Gain, kg for Live Basis",{"$f":"B11/1000*B16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUM(B22:C22)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=3,SUM(B22:D22)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=4,SUM(B22:E22)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=5,SUM(B22:F22)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=6, SUM(B22:G22)+'Finisher Model - ME Metric'!B17,\"\")))))","v":""},null,"Total feed cost, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L22,IF('Finisher Model - ME Metric'!$D$11=3,M22,IF('Finisher Model - ME Metric'!$D$11=4,N22,IF('Finisher Model - ME Metric'!$D$11=5,O22,IF('Finisher Model - ME Metric'!$D$11=6,P22,\"\")))))","v":""},{"$f":"SUM(B21:C21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:D21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:E21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:F21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:G21)","v":{"$error":"#VALUE!"}}]
["Gain, kg for Carcass Basis",{"$f":"B11/1000*B17","v":{"$error":"#VALUE!"}},{"$f":"C11/1000*C17","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUM(B23:C23)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=3,SUM(B23:D23)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=4,SUM(B23:E23)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=5,SUM(B23:F23)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=6, SUM(B23:G23)+'Finisher Model - ME Metric'!B17,\"\")))))","v":""},null,"Total feed cost & facility cost, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L23,IF('Finisher Model - ME Metric'!$D$11=3,M23,IF('Finisher Model - ME Metric'!$D$11=4,N23,IF('Finisher Model - ME Metric'!$D$11=5,O23,IF('Finisher Model - ME Metric'!$D$11=6,P23,\"\")))))","v":""},{"$f":"SUM(B27:C27)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B27:D27)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B27:E27)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B27:F27)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B27:G27)","v":{"$error":"#VALUE!"}}]
["Feed cost per/kg of gain, $/pig for Live Basis",{"$f":"B20/((B11/1000)*B16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Revenue Carcass, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L24,IF('Finisher Model - ME Metric'!$D$11=3,M24,IF('Finisher Model - ME Metric'!$D$11=4,N24,IF('Finisher Model - ME Metric'!$D$11=5,O24,IF('Finisher Model - ME Metric'!$D$11=6,P24,\"\")))))","v":""},{"$f":"$B$33*'Finisher Model - ME Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"$B$33*'Finisher Model - ME Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"$B$33*'Finisher Model - ME Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"$B$33*'Finisher Model - ME Metric'!$D$8","v":{"$error":"#VALUE!"}},{"$f":"$B$33*'Finisher Model - ME Metric'!$D$8","v":{"$error":"#VALUE!"}}]
["Feed cost per/kg of gain, $/pig for Carcass Basis",{"$f":"B21/((B11/1000)*B17)","v":{"$error":"#VALUE!"}},{"$f":"C21/((C11/1000)*C17)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFC Carcass, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L25,IF('Finisher Model - ME Metric'!$D$11=3,M25,IF('Finisher Model - ME Metric'!$D$11=4,N25,IF('Finisher Model - ME Metric'!$D$11=5,O25,IF('Finisher Model - ME Metric'!$D$11=6,P25,\"\")))))","v":""},{"$f":"L24-L22","v":{"$error":"#VALUE!"}},{"$f":"M24-M22","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Feed and facility cost, $/pig for Live Basis",{"$f":"B20+(B16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"C20+(C16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"D20+(D16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"E20+(E16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"F20+(F16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"G20+(G16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},null,null,"Total IOFFC Carcass, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L26,IF('Finisher Model - ME Metric'!$D$11=3,M26,IF('Finisher Model - ME Metric'!$D$11=4,N26,IF('Finisher Model - ME Metric'!$D$11=5,O26,IF('Finisher Model - ME Metric'!$D$11=6,P26,\"\")))))","v":""},{"$f":"L24-L23","v":{"$error":"#VALUE!"}},{"$f":"M24-M23","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Feed and facility cost, $/pig for Carcass Basis",{"$f":"B21+(B17*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"C21+(C17*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"D21+(D17*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"E21+(E17*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"F21+(F17*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"G21+(G17*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}}]
["Revenue per pig by phase, $/pig for Live Basis",{"$f":"B22*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"C22*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"D22*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"E22*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"F22*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"G22*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}}]
["IOFC by phase, $/pig",{"$f":"B28-B20","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["IOFFC by phase, $/pig",{"$f":"B28-B26","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["STTD P",{"$f":"'Finisher Model - ME Metric'!R17","v":""},{"$f":"'Finisher Model - ME Metric'!R18","v":""},{"$f":"'Finisher Model - ME Metric'!R19","v":""},{"$f":"'Finisher Model - ME Metric'!R20","v":""},{"$f":"'Finisher Model - ME Metric'!R21","v":""},{"$f":"'Finisher Model - ME Metric'!R22","v":""}]
["Weighted average of STTD P",{"$f":"SUMPRODUCT(B31,B18)/SUM(B18)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B31:C31,B18:C18)/SUM(B18:C18)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B31:D31,B18:D18)/SUM(B18:D18)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B31:E31,B18:E18)/SUM(B18:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B31:F31,B18:F18)/SUM(B18:F18)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(B31:G31,B18:G18)/SUM(B18:G18)","v":{"$error":"#VALUE!"}}]
["Calculated overall HCW for CURRENT performance",{"$f":"'Current Performance - ME'!B28","v":{"$error":"#VALUE!"}}]
["Predicted final BW, lb for Fixed Weight to achieve the same Current Carcass Wt",{"$f":"B33/(B43/100)","v":{"$error":"#VALUE!"}}]
["Calculated Overall HCW,lb based on final BW and corrected yield",{"$f":"$H$22*$B$43/100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Yield based on final BW and PIC equation",{"$f":"(VLOOKUP($H$22,$C$81:$I$120,7,TRUE))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["User yield",{"$f":"'Finisher Model - ME Metric'!D9","v":0}]
["User/PIC ratio",{"$f":"B37/B36","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Yield equation"]
["Current STTD P as % of NRC",{"$f":"'Finisher Model - ME Metric'!P17","v":""},{"$f":"'Finisher Model - ME Metric'!P18","v":""},{"$f":"'Finisher Model - ME Metric'!P19","v":""},{"$f":"'Finisher Model - ME Metric'!P20","v":""},{"$f":"'Finisher Model - ME Metric'!P21","v":""},{"$f":"'Finisher Model - ME Metric'!P22","v":""},{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUMPRODUCT(B39:C39,B16:C16)/SUM(B16:C16),IF('Finisher Model - ME Metric'!D11=3,SUMPRODUCT(B39:D39,B16:D16)/SUM(B16:D16),IF('Finisher Model - ME Metric'!D11=4,SUMPRODUCT(B39:E39,B16:E16)/SUM(B16:E16),IF('Finisher Model - ME Metric'!D11=5,SUMPRODUCT(B39:F39,B16:F16)/SUM(B16:F16),IF('Finisher Model - ME Metric'!D11=6,SUMPRODUCT(B39:G39,B16:G16)/SUM(B16:G16),\"\")))))","v":""},null,"73.859 - 1.19192 x STTD P % of NRC"]
["Predicted yield based on biological STTD P level",{"$f":"73.859-1.19192*H39","v":{"$error":"#VALUE!"}}]
["Yield at 100% of NRC",{"$f":"73.859-1.19192*1","v":72.667079999999999}]
["Yield correction factor based on STTD P level",{"$f":"B40/B41","v":{"$error":"#VALUE!"}}]
["Corrected current yield",{"$f":"(VLOOKUP($H$22,$C$81:$K$120,9,TRUE))","v":{"$error":"#N/A"}}]
[]
[null,"Mixed Sex Feed Budget - Live Basis",null,null,null,null,"Mixed Sex Feed Budget - Carcass Basis"]
[null,"Closeout Feed Efficiency",null,null,null,null,"Closeout Feed Efficiency"]
[null,"Initial Wt","Final Wt","F/G",null,null,"Initial Wt","Final Wt","F/G"]
[null,{"$f":"CONVERT('Finisher Model - ME Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT(IF('Finisher Model - ME Metric'!$D$11=2,'Finisher Model - ME Metric'!C18,IF('Finisher Model - ME Metric'!$D$11=3,'Finisher Model - ME Metric'!C19,IF('Finisher Model - ME Metric'!$D$11=4,'Finisher Model - ME Metric'!C20,IF('Finisher Model - ME Metric'!$D$11=5,'Finisher Model - ME Metric'!C21,IF('Finisher Model - ME Metric'!$D$11=6,'Finisher Model - ME Metric'!C22,\"\"))))),\"kg\",\"lbm\")","v":{"$error":"#VALUE!"}},{"$f":"B15","v":""},null,null,{"$f":"CONVERT('Finisher Model - ME Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT(IF('Finisher Model - ME Metric'!$D$11=2,'Finisher Model - ME Metric'!C18,IF('Finisher Model - ME Metric'!$D$11=3,'Finisher Model - ME Metric'!C19,IF('Finisher Model - ME Metric'!$D$11=4,'Finisher Model - ME Metric'!C20,IF('Finisher Model - ME Metric'!$D$11=5,'Finisher Model - ME Metric'!C21,IF('Finisher Model - ME Metric'!$D$11=6,'Finisher Model - ME Metric'!C22,\"\"))))),\"kg\",\"lbm\")","v":{"$error":"#VALUE!"}},{"$f":"B15","v":""}]
[]
[null,"Initial Wt","Final Wt","lb/pig",{"$f":"IF(B51=0,F50,((0.00463*B51^2 + 1.68*B51 - 22.05)/(((0.00463*C48^2 + 1.68*C48 - 22.05)-(0.00463*B48^2 + 1.68*B48 - 22.05))/(C48-B48))*D48))","v":0},null,"Initial Wt","Final Wt","lb/pig",{"$f":"IF(G51=0,K50,((0.00463*G51^2 + 1.68*G51 - 22.05)/(((0.00463*H48^2 + 1.68*H48 - 22.05)-(0.00463*G48^2 + 1.68*G48 - 22.05))/(H48-G48))*I48))","v":0}]
[1,{"$f":"CONVERT('Finisher Model - ME Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT('Finisher Model - ME Metric'!C17,\"kg\",\"lbm\")","v":0},{"$f":"IF(C51=\"\",\"\",(E51-E50))","v":{"$error":"#VALUE!"}},{"$f":"IF(B52=\"\",\"\",((0.00463*B52^2 + 1.68*B52 - 22.05)/(((0.00463*$C$48^2 + 1.68*$C$48 - 22.05)-(0.00463*$B$48^2 + 1.68*$B$48 - 22.05))/($C$48-$B$48))*$D$48))","v":{"$error":"#VALUE!"}},null,{"$f":"CONVERT('Finisher Model - ME Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT('Finisher Model - ME Metric'!C17,\"kg\",\"lbm\")","v":0},{"$f":"IF(H51=\"\",\"\",(J51-J50))","v":{"$error":"#VALUE!"}},{"$f":"IF(G52=\"\",\"\",((0.00463*G52^2 + 1.68*G52 - 22.05)/(((0.00463*$C$48^2 + 1.68*$C$48 - 22.05)-(0.00463*$B$48^2 + 1.68*$B$48 - 22.05))/($C$48-$B$48))*$D$48))","v":{"$error":"#VALUE!"}}]
[2,{"$f":"C51","v":0},{"$f":"CONVERT('Finisher Model - ME Metric'!C18,\"kg\",\"lbm\")","v":0},{"$f":"IF(C52=\"\",\"\",(E52-E51))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,{"$f":"H51","v":0},{"$f":"CONVERT(IF(AND('Finisher Model - ME Metric'!$D$11=2,'Finisher Model - ME Metric'!$D$6=\"Carcass\"),'FW - Projected Performance - ME'!$B$34,'Finisher Model - ME Metric'!C18),\"kg\",\"lbm\")","v":0},{"$f":"IF(H52=\"\",\"\",(J52-J51))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[3,0,{"$f":"CONVERT('Finisher Model - ME Metric'!C19,\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0,{"$f":"CONVERT(IF(AND('Finisher Model - ME Metric'!$D$11=3,'Finisher Model - ME Metric'!$D$6=\"Carcass\"),'FW - Projected Performance - ME'!$B$34,'Finisher Model - ME Metric'!C19),\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,0,{"$f":"CONVERT('Finisher Model - ME Metric'!C20,\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0,{"$f":"CONVERT(IF(AND('Finisher Model - ME Metric'!$D$11=4,'Finisher Model - ME Metric'!$D$6=\"Carcass\"),'FW - Projected Performance - ME'!$B$34,'Finisher Model - ME Metric'!C20),\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,0,{"$f":"CONVERT('Finisher Model - ME Metric'!C21,\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0,{"$f":"CONVERT(IF(AND('Finisher Model - ME Metric'!$D$11=5,'Finisher Model - ME Metric'!$D$6=\"Carcass\"),'FW - Projected Performance - ME'!$B$34,'Finisher Model - ME Metric'!C21),\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,0,{"$f":"CONVERT('Finisher Model - ME Metric'!C22,\"kg\",\"lbm\")","v":0},{"$f":"IF(C56=\"\",\"\",(E56-E55))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,0,{"$f":"CONVERT(IF(AND('Finisher Model - ME Metric'!$D$11=6,'Finisher Model - ME Metric'!$D$6=\"Carcass\"),'FW - Projected Performance - ME'!$B$34,'Finisher Model - ME Metric'!C22),\"kg\",\"lbm\")","v":0},{"$f":"IF(H56=\"\",\"\",(J56-J55))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,0,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hot Carcass Wheight","Market weight    (est. by Carcass yield)","Back Fat for PIC 337",null,null,null,null,"Carcass Yield (%) =                                   66.411 + ( Carcass weight, kg x 0.0878)"]
[null,"kg","kg","Barrows","Gilts","Average",null,null,null,"User/PIC Adjusted Yield","User/PIC Asjusted and STTD P adjusted"]
[null,81,110.17670623134534,16.864782047899471,14.510728742835685,15.687755395367578,null,null,0.73518262408316082,{"$f":"(I81*$B$38)*100","v":{"$error":"#N/A"}},{"$f":"J81*$B$42","v":{"$error":"#N/A"}}]
[null,82,111.4039519642067,17.074455706764272,14.613701440729169,15.844078573746721,null,null,0.73606006388665657,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,83,112.6282752396024,17.284147265806148,14.71614342750836,16.000145346657256,null,null,0.73693750369015243,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,84,113.84968648405146,17.493856510850449,14.81806378371237,16.155960147281409,null,null,0.73781494349364829,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,85,115.06819607453319,17.703583232804778,14.919471328516645,16.311527280660712,null,null,0.73869238329714404,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,86,116.28381433878111,17.913327227479776,15.020374630235036,16.466850928857404,null,null,0.7395698231006399,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,87,117.49655155557477,18.123088295418643,15.120782016283018,16.621935155850831,null,null,0.74044726290413565,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,88,118.70641795502937,18.332866241734184,15.220701582635391,16.776783912184786,null,null,0.74132470270763151,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,89,119.91342371888354,18.542660875953423,15.320141202809715,16.931401039381569,null,null,0.74220214251112737,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,90,121.11757898078487,18.752472011869195,15.419108536404257,17.085790274136727,null,null,0.74307958231462312,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,91,122.31889382657351,18.962299467398132,15.517611037217174,17.239955252307652,null,null,0.74395702211811898,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,92,123.51737829456385,19.172143064445141,15.615655960971905,17.393899512708522,null,null,0.74483446192161473,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,93,124.71304237582397,19.382002628773577,15.713250372671933,17.547626500722757,null,null,0.74571190172511059,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,94,125.90589601445348,19.591877989881006,15.81040115360647,17.701139571743738,null,null,0.74658934152860634,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,95,127.09594910785896,19.80176898088045,15.907115008027194,17.854441994453822,null,null,0.7474667813321022,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,96,128.28321150702794,20.011675438386312,16.003398469514622,18.007536953950467,null,null,0.74834422113559795,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,97,129.46769301680052,20.221597202405267,16.099257907051943,18.160427554728606,null,null,0.74922166093909381,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,98,130.64940339613941,20.43153411623155,16.194699530822238,18.313116823526894,null,null,0.75009910074258968,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,99,131.82835235839786,20.641486026346577,16.289729397744711,18.465607712045646,null,null,0.75097654054608542,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,100,133.00454957158581,20.851452782322603,16.384353416763961,18.617903099543284,null,null,0.75185398034958129,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,101,134.17800465863434,21.061434236730111,16.478577353905742,18.770005795317928,null,null,0.75273142015307704,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,102,135.34872719765769,21.27143024504899,16.572406837111849,18.921918541080419,null,null,0.7536088599565729,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,103,136.51672672221434,21.481440665583278,16.665847360865602,19.073644013224438,null,null,0.75448629976006876,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,104,137.68201272156554,21.69146535937886,16.758904290619089,19.225184824998976,null,null,0.75536373956356451,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,105,138.84459464093223,21.901504190144763,16.851582867032572,19.37654352858867,null,null,0.75624117936706026,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,106,140.00448188175039,22.111557024177106,16.943888210035503,19.527722617106306,null,null,0.75711861917055612,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,107,141.16168380192445,22.321623730286092,17.035825322718448,19.678724526502272,null,null,0.75799605897405198,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,108,142.31620971607887,22.531704179725708,17.127399095064437,19.82955163739507,null,null,0.75887349877754773,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,109,143.46806889580807,22.741798246125917,17.218614307527691,19.980206276826806,null,null,0.75975093858104359,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,110,144.61727056992473,22.951905805427518,17.309475634467464,20.130690719947491,null,null,0.76062837838453934,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,111,145.76382392470609,23.162026735819119,17.399987647444007,20.281007191631563,null,null,0.7615058181880352,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,112,146.9077381041389,23.372160917676677,17.49015481838342,20.431157868030049,null,null,0.76238325799153106,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,113,148.04902221016243,23.582308233504943,17.579981522617746,20.581144878061345,null,null,0.76326069779502681,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,114,149.18768530290981,23.792468567881055,17.66947204180623,20.730970304843645,null,null,0.76413813759852267,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,115,150.32373640094792,24.002641807400256,17.758630566743491,20.880636187071872,null,null,0.76501557740201842,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,116,151.45718448151536,24.212827840623181,17.847461200059801,21.030144520341491,null,null,0.76589301720551428,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,117,152.58803848075902,24.423026558025349,17.935967958818601,21.179497258421975,null,null,0.76677045700901003,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,118,153.71630729396878,24.633237851947925,18.024154777015983,21.328696314481952,null,null,0.76764789681250589,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,119,154.84199977581099,24.843461616550663,18.112025507986587,21.477743562268625,null,null,0.76852533661600164,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,120,155.96512474055984,25.053697747765945,18.199583926720305,21.626640837243123,null,null,0.7694027764194975,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"FT - Projected Performance - ME","index":10,"n_rows":94,"n_cols":16,"rows_kept":94,"cut":false,"hidden":true,"merged":[[52,3,52,5],[52,8,53,8],[0,0,0,14],[1,0,3,0],[1,1,2,6],[1,9,2,10],[36,1,36,4],[37,1,37,4]]}
["Economic model for optimum phosphorus level - Model Calculations by phase"]
["Item","Dietary phase",null,null,null,null,null,null,null,"Summary of Calculations with Current Phosphorus Levels"]
[]
[null,1,2,3,4,5,6,null,null,"Item","Output",2,3,4,5,6]
["Starting weight, kg",{"$f":"'Finisher Model - ME Metric'!B17","v":0},{"$f":"'Finisher Model - ME Metric'!B18","v":0},{"$f":"'Finisher Model - ME Metric'!B19","v":0},{"$f":"'Finisher Model - ME Metric'!B20","v":0},{"$f":"'Finisher Model - ME Metric'!B21","v":0},{"$f":"'Finisher Model - ME Metric'!B22","v":0},null,null,"Predicted ADG, kg",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L5,IF('Finisher Model - ME Metric'!$D$11=3,M5,IF('Finisher Model - ME Metric'!$D$11=4,N5,IF('Finisher Model - ME Metric'!$D$11=5,O5,IF('Finisher Model - ME Metric'!$D$11=6,P5,\"\")))))","v":""},{"$f":"((SUM(B19:C19)/SUM(B16:C16)))","v":{"$error":"#VALUE!"}},{"$f":"((SUM(B19:D19)/SUM(B16:D16)))","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:E19)/SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:F19)/SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:G19)/SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Final weight, kg",{"$f":"'Finisher Model - ME Metric'!C17","v":0},{"$f":"'Finisher Model - ME Metric'!C18","v":0},{"$f":"'Finisher Model - ME Metric'!C19","v":0},{"$f":"'Finisher Model - ME Metric'!C20","v":0},{"$f":"'Finisher Model - ME Metric'!C21","v":0},{"$f":"'Finisher Model - ME Metric'!C22","v":0},null,null,"Predicted F/G",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L6,IF('Finisher Model - ME Metric'!$D$11=3,M6,IF('Finisher Model - ME Metric'!$D$11=4,N6,IF('Finisher Model - ME Metric'!$D$11=5,O6,IF('Finisher Model - ME Metric'!$D$11=6,P6,\"\")))))","v":""},{"$f":"SUM($B$17:$C$17)/SUM($B$19:$C$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$D$17)/SUM($B$19:$D$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$E$17)/SUM($B$19:$E$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$F$17)/SUM($B$19:$F$19)","v":{"$error":"#VALUE!"}},{"$f":"SUM($B$17:$G$17)/SUM($B$19:$G$19)","v":{"$error":"#VALUE!"}}]
["Total gain, kg",{"$f":"B6-B5","v":0},{"$f":"C6-C5","v":0},0,0,{"$f":"F6-F5","v":0},{"$f":"G6-G5","v":0},null,null,"Predicted ADFI, kg",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L7,IF('Finisher Model - ME Metric'!$D$11=3,M7,IF('Finisher Model - ME Metric'!$D$11=4,N7,IF('Finisher Model - ME Metric'!$D$11=5,O7,IF('Finisher Model - ME Metric'!$D$11=6,P7,\"\")))))","v":""},{"$f":"SUM(B17:C17)/SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:D17)/SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:E17)/SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:F17)/SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:G17)/SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Current NE, kcal/kg",{"$f":"'Finisher Model - ME Metric'!D17","v":0},{"$f":"'Finisher Model - ME Metric'!D18","v":0},{"$f":"'Finisher Model - ME Metric'!D19","v":0},{"$f":"'Finisher Model - ME Metric'!D20","v":0},{"$f":"'Finisher Model - ME Metric'!D21","v":0},{"$f":"'Finisher Model - ME Metric'!D22","v":0},null,null,"Phases duration, d",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L8,IF('Finisher Model - ME Metric'!$D$11=3,M8,IF('Finisher Model - ME Metric'!$D$11=4,N8,IF('Finisher Model - ME Metric'!$D$11=5,O8,IF('Finisher Model - ME Metric'!$D$11=6,P8,\"\")))))","v":""},{"$f":"SUM(B16:C16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:D16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:E16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:F16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B16:G16)","v":{"$error":"#VALUE!"}}]
["Current Diet Cost, $/Ton",{"$f":"'Finisher Model - ME Metric'!I17","v":0},{"$f":"'Finisher Model - ME Metric'!I18","v":0},{"$f":"'Finisher Model - ME Metric'!I19","v":0},{"$f":"'Finisher Model - ME Metric'!I20","v":0},{"$f":"'Finisher Model - ME Metric'!I21","v":0},{"$f":"'Finisher Model - ME Metric'!I22","v":0},null,null,"Total feed, kg/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L9,IF('Finisher Model - ME Metric'!$D$11=3,M9,IF('Finisher Model - ME Metric'!$D$11=4,N9,IF('Finisher Model - ME Metric'!$D$11=5,O9,IF('Finisher Model - ME Metric'!$D$11=6,P9,\"\")))))","v":""},{"$f":"SUM(B17:C17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:E17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:F17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B17:G17)","v":{"$error":"#VALUE!"}}]
["Average Starting Wt & End Wt, kg",{"$f":"AVERAGE(B5:B6)","v":0},{"$f":"AVERAGE(C5:C6)","v":0},0,0,0,{"$f":"AVERAGE(G5:G6)","v":0},null,null,"Total feed cost, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L10,IF('Finisher Model - ME Metric'!$D$11=3,M10,IF('Finisher Model - ME Metric'!$D$11=4,N10,IF('Finisher Model - ME Metric'!$D$11=5,O10,IF('Finisher Model - ME Metric'!$D$11=6,P10,\"\")))))","v":""},{"$f":"SUM(B18:C18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:D18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:E18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:F18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B18:G18)","v":{"$error":"#VALUE!"}}]
["Calculated Overall ADG with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P17-216.9*('Finisher Model - ME Metric'!P17*'Finisher Model - ME Metric'!P17),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P18-216.9*('Finisher Model - ME Metric'!P18*'Finisher Model - ME Metric'!P18),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P19-216.9*('Finisher Model - ME Metric'!P19*'Finisher Model - ME Metric'!P19),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P20-216.9*('Finisher Model - ME Metric'!P20*'Finisher Model - ME Metric'!P20),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P21-216.9*('Finisher Model - ME Metric'!P21*'Finisher Model - ME Metric'!P21),\"\")","v":""},{"$f":"IFERROR(651.36+531.33*'Finisher Model - ME Metric'!P22-216.9*('Finisher Model - ME Metric'!P22*'Finisher Model - ME Metric'!P22),\"\")","v":""},null,null,"Total feed cost & facility cost, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L11,IF('Finisher Model - ME Metric'!$D$11=3,M11,IF('Finisher Model - ME Metric'!$D$11=4,N11,IF('Finisher Model - ME Metric'!$D$11=5,O11,IF('Finisher Model - ME Metric'!$D$11=6,P11,\"\")))))","v":""},{"$f":"SUM(B21:C21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:D21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:E21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:F21)","v":{"$error":"#VALUE!"}},{"$f":"SUM(B21:G21)","v":{"$error":"#VALUE!"}}]
["Calculated Overall G:F with STTD P trial (Vier et al.,2017)",{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P17-46.7864*('Finisher Model - ME Metric'!P17*'Finisher Model - ME Metric'!P17),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P18-46.7864*('Finisher Model - ME Metric'!P18*'Finisher Model - ME Metric'!P18),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P19-46.7864*('Finisher Model - ME Metric'!P19*'Finisher Model - ME Metric'!P19),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P20-46.7864*('Finisher Model - ME Metric'!P20*'Finisher Model - ME Metric'!P20),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P21-46.7864*('Finisher Model - ME Metric'!P21*'Finisher Model - ME Metric'!P21),\"\")","v":""},{"$f":"IFERROR(338.34+108.98*'Finisher Model - ME Metric'!P22-46.7864*('Finisher Model - ME Metric'!P22*'Finisher Model - ME Metric'!P22),\"\")","v":""},null,null,"Revenue Live, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L12,IF('Finisher Model - ME Metric'!$D$11=3,M12,IF('Finisher Model - ME Metric'!$D$11=4,N12,IF('Finisher Model - ME Metric'!$D$11=5,O12,IF('Finisher Model - ME Metric'!$D$11=6,P12,\"\")))))","v":""},{"$f":"SUM(B19:C19,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:D19,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:E19,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:F19,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}},{"$f":"SUM(B19:G19,'Finisher Model - ME Metric'!B17)*'Finisher Model - ME Metric'!D7","v":{"$error":"#VALUE!"}}]
["Predicted Overall ADFI, g/d",{"$f":"(B11/B12)*1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFC Live, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L13,IF('Finisher Model - ME Metric'!$D$11=3,M13,IF('Finisher Model - ME Metric'!$D$11=4,N13,IF('Finisher Model - ME Metric'!$D$11=5,O13,IF('Finisher Model - ME Metric'!$D$11=6,P13,\"\")))))","v":""},{"$f":"L12-L10","v":{"$error":"#VALUE!"}},{"$f":"M12-M10","v":{"$error":"#VALUE!"}},{"$f":"N12-N10","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"P12-P10","v":{"$error":"#VALUE!"}}]
["Predicted Overall F/G",{"$f":"B13/B11","v":{"$error":"#VALUE!"}},{"$f":"C13/C11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Total IOFFC Live, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L14,IF('Finisher Model - ME Metric'!$D$11=3,M14,IF('Finisher Model - ME Metric'!$D$11=4,N14,IF('Finisher Model - ME Metric'!$D$11=5,O14,IF('Finisher Model - ME Metric'!$D$11=6,P14,\"\")))))","v":""},{"$f":"L12-L11","v":{"$error":"#VALUE!"}},{"$f":"M12-M11","v":{"$error":"#VALUE!"}},{"$f":"N12-N11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"P12-P11","v":{"$error":"#VALUE!"}}]
["Overall average F/G (weighted average based on phase duration)",{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUMPRODUCT(B14:C14,B16:C16)/SUM(B16:C16),IF('Finisher Model - ME Metric'!D11=3,SUMPRODUCT(B14:D14,B16:D16)/SUM(B16:D16),IF('Finisher Model - ME Metric'!D11=4,SUMPRODUCT(B14:E14,B16:E16)/SUM(B16:E16),IF('Finisher Model - ME Metric'!D11=5,SUMPRODUCT(B14:F14,B16:F16)/SUM(B16:F16),IF('Finisher Model - ME Metric'!D11=6,SUMPRODUCT(B14:G14,B16:G16)/SUM(B16:G16),\"\")))))","v":""},null,null,null,null,null,null,null,"HCW",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L15,IF('Finisher Model - ME Metric'!$D$11=3,M15,IF('Finisher Model - ME Metric'!$D$11=4,N15,IF('Finisher Model - ME Metric'!$D$11=5,O15,IF('Finisher Model - ME Metric'!$D$11=6,P15,\"\")))))","v":""},{"$f":"C25","v":{"$error":"#VALUE!"}},{"$f":"D25","v":{"$error":"#VALUE!"}},{"$f":"E25","v":{"$error":"#VALUE!"}},{"$f":"F25","v":{"$error":"#VALUE!"}},{"$f":"G25","v":{"$error":"#VALUE!"}}]
["Phase duration, d",{"$f":"'Current Performance - ME'!B16","v":{"$error":"#VALUE!"}},{"$f":"'Current Performance - ME'!C16","v":{"$error":"#VALUE!"}},{"$f":"'Current Performance - ME'!D16","v":{"$error":"#VALUE!"}},{"$f":"'Current Performance - ME'!E16","v":{"$error":"#VALUE!"}},{"$f":"'Current Performance - ME'!F16","v":{"$error":"#VALUE!"}},{"$f":"'Current Performance - ME'!G16","v":{"$error":"#VALUE!"}},{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUM(B16:C16),IF('Finisher Model - ME Metric'!D11=3,SUM(B16:D16),IF('Finisher Model - ME Metric'!D11=4,SUM(B16:E16),IF('Finisher Model - ME Metric'!D11=5,SUM(B16:F16),IF('Finisher Model - ME Metric'!D11=6,SUM(B16:G16),\"\")))))","v":""},null,"Revenue Carcass, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L16,IF('Finisher Model - ME Metric'!$D$11=3,M16,IF('Finisher Model - ME Metric'!$D$11=4,N16,IF('Finisher Model - ME Metric'!$D$11=5,O16,IF('Finisher Model - ME Metric'!$D$11=6,P16,\"\")))))","v":""},{"$f":"SUM(L15*'Finisher Model - ME Metric'!$D$8)","v":{"$error":"#VALUE!"}},{"$f":"SUM(M15*'Finisher Model - ME Metric'!$D$8)","v":{"$error":"#VALUE!"}},{"$f":"SUM(N15*'Finisher Model - ME Metric'!$D$8)","v":{"$error":"#VALUE!"}},{"$f":"SUM(O15*'Finisher Model - ME Metric'!$D$8)","v":{"$error":"#VALUE!"}},{"$f":"SUM(P15*'Finisher Model - ME Metric'!$D$8)","v":{"$error":"#VALUE!"}}]
["Feed budget by phase, kg/pig",{"$f":"CONVERT(D43,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D44,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D45,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D46,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D47,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},{"$f":"CONVERT(D48,\"lbm\",\"kg\")","v":{"$error":"#VALUE!"}},null,null,"Total IOFC Carcass, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L17,IF('Finisher Model - ME Metric'!$D$11=3,M17,IF('Finisher Model - ME Metric'!$D$11=4,N17,IF('Finisher Model - ME Metric'!$D$11=5,O17,IF('Finisher Model - ME Metric'!$D$11=6,P17,\"\")))))","v":""},{"$f":"L16-L10","v":{"$error":"#VALUE!"}},{"$f":"M16-M10","v":{"$error":"#VALUE!"}},{"$f":"N16-N10","v":{"$error":"#VALUE!"}},{"$f":"O16-O10","v":{"$error":"#VALUE!"}},{"$f":"P16-P10","v":{"$error":"#VALUE!"}}]
["Total feed cost per phase, $/pig",{"$f":"(B17*(B9/907))","v":{"$error":"#VALUE!"}},{"$f":"(C17*(C9/907))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"(F17*(F9/907))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"Total IOFFC Carcass, $/pig",{"$f":"IF('Finisher Model - ME Metric'!$D$11=2,L18,IF('Finisher Model - ME Metric'!$D$11=3,M18,IF('Finisher Model - ME Metric'!$D$11=4,N18,IF('Finisher Model - ME Metric'!$D$11=5,O18,IF('Finisher Model - ME Metric'!$D$11=6,P18,\"\")))))","v":""},{"$f":"L16-L11","v":{"$error":"#VALUE!"}},{"$f":"M16-M11","v":{"$error":"#VALUE!"}},{"$f":"N16-N11","v":{"$error":"#VALUE!"}},{"$f":"O16-O11","v":{"$error":"#VALUE!"}},{"$f":"P16-P11","v":{"$error":"#VALUE!"}}]
["Gain, kg",{"$f":"B11/1000*B16","v":{"$error":"#VALUE!"}},{"$f":"C11/1000*C16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUM(B19:C19)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=3,SUM(B19:D19)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=4,SUM(B19:E19)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=5,SUM(B19:F19)+'Finisher Model - ME Metric'!B17,IF('Finisher Model - ME Metric'!D11=6,SUM(B19:G19)+'Finisher Model - ME Metric'!B17,\"\")))))","v":""}]
["Feed cost per/kg of gain, $/pig",{"$f":"B18/((B11/1000)*B16)","v":{"$error":"#VALUE!"}},{"$f":"C18/((C11/1000)*C16)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Feed and facility cost, $/pig",{"$f":"B18+(B16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"C18+(C16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"D18+(D16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"E18+(E16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"F18+(F16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}},{"$f":"G18+(G16*'Finisher Model - ME Metric'!$D$10)","v":{"$error":"#VALUE!"}}]
["Revenue per pig, $/pig",{"$f":"B19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"C19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"D19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"E19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"F19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}},{"$f":"G19*'Finisher Model - ME Metric'!$D$7","v":{"$error":"#VALUE!"}}]
["IOFC by phase, $/pig",{"$f":"B22-B18","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["IOFFC by phase, $/pig",{"$f":"B22-B21","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Calculated Overall HCW,lb based on final BW and corrected yield",{"$f":"$H$19*B33/100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Yield based on final BW and PIC equation",{"$f":"(VLOOKUP($H$19,$C$55:$I$94,7,TRUE))*100","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($H$19,$C$55:$I$94,7,TRUE))*100","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["User yield",{"$f":"'Finisher Model - ME Metric'!D9","v":0}]
["User/PIC ratio",{"$f":"B27/B26","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Yield equation"]
["Biological STTD P as % of NRC",{"$f":"'Finisher Model - ME Metric'!P17","v":""},{"$f":"'Finisher Model - ME Metric'!P18","v":""},{"$f":"'Finisher Model - ME Metric'!P19","v":""},{"$f":"'Finisher Model - ME Metric'!P20","v":""},{"$f":"'Finisher Model - ME Metric'!P21","v":""},{"$f":"'Finisher Model - ME Metric'!P22","v":""},{"$f":"IF('Finisher Model - ME Metric'!D11=2,SUMPRODUCT(B29:C29,B16:C16)/SUM(B16:C16),IF('Finisher Model - ME Metric'!D11=3,SUMPRODUCT(B29:D29,B16:D16)/SUM(B16:D16),IF('Finisher Model - ME Metric'!D11=4,SUMPRODUCT(B29:E29,B16:E16)/SUM(B16:E16),IF('Finisher Model - ME Metric'!D11=5,SUMPRODUCT(B29:F29,B16:F16)/SUM(B16:F16),IF('Finisher Model - ME Metric'!D11=6,SUMPRODUCT(B29:G29,B16:G16)/SUM(B16:G16),\"\")))))","v":""}]
["Predicted yield based on biological STTD P level",{"$f":"73.859-1.19192*H29","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"73.859 - 1.19192 x STTD P % of NRC"]
["Yield at 100% of NRC",{"$f":"73.859-1.19192*1","v":72.667079999999999}]
["Yield correction factor based on STTD P level",{"$f":"B30/B31","v":{"$error":"#VALUE!"}}]
["Corrected current yield",{"$f":"(VLOOKUP($H$19,$C$55:$K$94,9,TRUE))","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($H$19,$C$55:$K$94,9,TRUE))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[]
[null,"Mixed Sex Feed Budget"]
[null,"Closeout Feed Efficiency"]
[null,"Initial Wt","Final Wt","F/G"]
[null,{"$f":"CONVERT('Finisher Model - ME Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT(H19,\"kg\",\"lbm\")","v":{"$error":"#VALUE!"}},{"$f":"B15","v":""}]
[]
[null,"Initial Wt","Final Wt","lb/pig",{"$f":"IF(B43=0,F42,((0.00463*B43^2 + 1.68*B43 - 22.05)/(((0.00463*C40^2 + 1.68*C40 - 22.05)-(0.00463*B40^2 + 1.68*B40 - 22.05))/(C40-B40))*D40))","v":0}]
[1,{"$f":"CONVERT('Finisher Model - ME Metric'!B17,\"kg\",\"lbm\")","v":0},{"$f":"CONVERT('Finisher Model - ME Metric'!C17,\"kg\",\"lbm\")","v":0},{"$f":"IF(C43=\"\",\"\",(E43-E42))","v":{"$error":"#VALUE!"}},{"$f":"IF(B44=\"\",\"\",((0.00463*B44^2 + 1.68*B44 - 22.05)/(((0.00463*$C$40^2 + 1.68*$C$40 - 22.05)-(0.00463*$B$40^2 + 1.68*$B$40 - 22.05))/($C$40-$B$40))*$D$40))","v":{"$error":"#VALUE!"}}]
[2,{"$f":"C43","v":0},{"$f":"CONVERT(IF('Finisher Model - ME Metric'!D11=2,H19,'Finisher Model - ME Metric'!C18),\"kg\",\"lbm\")","v":0},{"$f":"IF(C44=\"\",\"\",(E44-E43))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[3,0,{"$f":"CONVERT(IF('Finisher Model - ME Metric'!D11=3,H19,'Finisher Model - ME Metric'!C19),\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,0,{"$f":"CONVERT(IF('Finisher Model - ME Metric'!D11=4,H19,'Finisher Model - ME Metric'!C20),\"kg\",\"lbm\")","v":0},{"$f":"IF(C46=\"\",\"\",(E46-E45))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[5,{"$f":"C46","v":0},{"$f":"CONVERT(IF('Finisher Model - ME Metric'!D11=5,H19,'Finisher Model - ME Metric'!C21),\"kg\",\"lbm\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"C47","v":0},{"$f":"CONVERT(IF('Finisher Model - ME Metric'!D11=6,H19,\"\"),\"kg\",\"lbm\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C48=\"\",\"\",(E48-E47))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,{"$f":"C48","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[null,"Hot Carcass Wheight","Market weight    (est. by Carcass yield)","Back Fat for PIC 337",null,null,null,null,"Carcass Yield (%) =                                   66.411 + ( Carcass weight, kg x 0.0878)"]
[null,"kg","kg","Barrows","Gilts","Average",null,null,null,"User/PIC Adjusted Yield","User/PIC Asjusted and STTD P adjusted"]
[null,81,110.17670623134534,16.864782047899471,14.510728742835685,15.687755395367578,null,null,0.73518262408316082,{"$f":"(I55*$B$28)*100","v":{"$error":"#N/A"}},{"$f":"J55*$B$32","v":{"$error":"#N/A"}}]
[null,82,111.4039519642067,17.074455706764272,14.613701440729169,15.844078573746721,null,null,0.73606006388665657,{"$f":"(I56*$B$28)*100","v":{"$error":"#N/A"}},{"$f":"J56*$B$32","v":{"$error":"#N/A"}}]
[null,83,112.6282752396024,17.284147265806148,14.71614342750836,16.000145346657256,null,null,0.73693750369015243,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,84,113.84968648405146,17.493856510850449,14.81806378371237,16.155960147281409,null,null,0.73781494349364829,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,85,115.06819607453319,17.703583232804778,14.919471328516645,16.311527280660712,null,null,0.73869238329714404,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,86,116.28381433878111,17.913327227479776,15.020374630235036,16.466850928857404,null,null,0.7395698231006399,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,87,117.49655155557477,18.123088295418643,15.120782016283018,16.621935155850831,null,null,0.74044726290413565,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,88,118.70641795502937,18.332866241734184,15.220701582635391,16.776783912184786,null,null,0.74132470270763151,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,89,119.91342371888354,18.542660875953423,15.320141202809715,16.931401039381569,null,null,0.74220214251112737,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,90,121.11757898078487,18.752472011869195,15.419108536404257,17.085790274136727,null,null,0.74307958231462312,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,91,122.31889382657351,18.962299467398132,15.517611037217174,17.239955252307652,null,null,0.74395702211811898,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,92,123.51737829456385,19.172143064445141,15.615655960971905,17.393899512708522,null,null,0.74483446192161473,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,93,124.71304237582397,19.382002628773577,15.713250372671933,17.547626500722757,null,null,0.74571190172511059,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,94,125.90589601445348,19.591877989881006,15.81040115360647,17.701139571743738,null,null,0.74658934152860634,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,95,127.09594910785896,19.80176898088045,15.907115008027194,17.854441994453822,null,null,0.7474667813321022,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,96,128.28321150702794,20.011675438386312,16.003398469514622,18.007536953950467,null,null,0.74834422113559795,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,97,129.46769301680052,20.221597202405267,16.099257907051943,18.160427554728606,null,null,0.74922166093909381,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,98,130.64940339613941,20.43153411623155,16.194699530822238,18.313116823526894,null,null,0.75009910074258968,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,99,131.82835235839786,20.641486026346577,16.289729397744711,18.465607712045646,null,null,0.75097654054608542,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,100,133.00454957158581,20.851452782322603,16.384353416763961,18.617903099543284,null,null,0.75185398034958129,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,101,134.17800465863434,21.061434236730111,16.478577353905742,18.770005795317928,null,null,0.75273142015307704,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,102,135.34872719765769,21.27143024504899,16.572406837111849,18.921918541080419,null,null,0.7536088599565729,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,103,136.51672672221434,21.481440665583278,16.665847360865602,19.073644013224438,null,null,0.75448629976006876,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,104,137.68201272156554,21.69146535937886,16.758904290619089,19.225184824998976,null,null,0.75536373956356451,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,105,138.84459464093223,21.901504190144763,16.851582867032572,19.37654352858867,null,null,0.75624117936706026,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,106,140.00448188175039,22.111557024177106,16.943888210035503,19.527722617106306,null,null,0.75711861917055612,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,107,141.16168380192445,22.321623730286092,17.035825322718448,19.678724526502272,null,null,0.75799605897405198,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,108,142.31620971607887,22.531704179725708,17.127399095064437,19.82955163739507,null,null,0.75887349877754773,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,109,143.46806889580807,22.741798246125917,17.218614307527691,19.980206276826806,null,null,0.75975093858104359,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,110,144.61727056992473,22.951905805427518,17.309475634467464,20.130690719947491,null,null,0.76062837838453934,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,111,145.76382392470609,23.162026735819119,17.399987647444007,20.281007191631563,null,null,0.7615058181880352,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,112,146.9077381041389,23.372160917676677,17.49015481838342,20.431157868030049,null,null,0.76238325799153106,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,113,148.04902221016243,23.582308233504943,17.579981522617746,20.581144878061345,null,null,0.76326069779502681,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,114,149.18768530290981,23.792468567881055,17.66947204180623,20.730970304843645,null,null,0.76413813759852267,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,115,150.32373640094792,24.002641807400256,17.758630566743491,20.880636187071872,null,null,0.76501557740201842,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,116,151.45718448151536,24.212827840623181,17.847461200059801,21.030144520341491,null,null,0.76589301720551428,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,117,152.58803848075902,24.423026558025349,17.935967958818601,21.179497258421975,null,null,0.76677045700901003,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,118,153.71630729396878,24.633237851947925,18.024154777015983,21.328696314481952,null,null,0.76764789681250589,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,119,154.84199977581099,24.843461616550663,18.112025507986587,21.477743562268625,null,null,0.76852533661600164,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,120,155.96512474055984,25.053697747765945,18.199583926720305,21.626640837243123,null,null,0.7694027764194975,{"$error":"#N/A"},{"$error":"#N/A"}]