{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Summary Sheet","Schedule 1a, b, c","Crop Inv","Livestock Inv","Structural Change"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"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":"Summary Sheet","index":0,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,0,5,1],[0,12,0,13],[0,2,0,4],[1,2,1,3],[9,0,9,2]]}
["Participant:",null,null,null,null,"         Projected Applied Reference Margin",null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-07-04"},null,null,null,"hide here and after"]
["AFSC ID:",870,null,null,null,null,null,2023]
[]
["Ownership %",null,100,null,null,"",null,"",null,"",null,"",null,""]
["Beginning Farmer",null,"N"]
[null,null,null,null,null,{"$f":"H2-5","v":2018},null,{"$f":"H2-4","v":2019},null,{"$f":"H2-3","v":2020},null,{"$f":"H2-2","v":2021},null,{"$f":"H2-1","v":2022}]
["Production Margin per Schedule 4",null,null,null,null,null,"<hide>",null,"<hide>",null,"<hide>",null,"<hide>"]
[]
["Total Allowable Income"]
["Private Insurance Adjustment"]
["AgriRecovery Program Payment Adjustment"]
[]
["Total Allowable Expenses"]
[]
["ACCRUAL ADJUSTMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Structural Change"]
["Net Increase/(Decrease): In Deferred Income",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Schedule 1a, b, c'!I15),\"\",'Schedule 1a, b, c'!I15)","v":0},null,null,null,null,{"$f":"IF(ISBLANK('Structural Change'!C58),0,'Structural Change'!C58*F23)","v":0}]
["Net (Increase)/Decrease: In Unpaid Expenses",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Schedule 1a, b, c'!I29),\"\",'Schedule 1a, b, c'!I29)","v":0},null,null,null,null,{"$f":"IF(ISBLANK('Structural Change'!E58),0,'Structural Change'!E58*H23)","v":0}]
["Net Increase/(Decrease): In Purchased Inputs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Schedule 1a, b, c'!I43),\"\",'Schedule 1a, b, c'!I43)","v":0},null,null,null,null,{"$f":"IF(ISBLANK('Structural Change'!G58),0,'Structural Change'!G58*J23)","v":0}]
["Net Increase/(Decrease): In Crop Inventory ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Crop Inv'!I36),0,'Crop Inv'!I36)","v":0},null,null,null,null,{"$f":"IF(ISBLANK('Structural Change'!I58),0,'Structural Change'!I58*L23)","v":0}]
["Net Increase/(Decrease): In Livestock Inventory",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Livestock Inv'!O45),0,'Livestock Inv'!O45)","v":0},null,null,null,null,{"$f":"IF(ISBLANK('Structural Change'!K58),0,'Structural Change'!K58*N23)","v":0}]
["Estimated Production Margin",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(C4),(N9-N13+N16+N17+N18+N19+N20+N10-ABS(N11)),((N9-N13+N16+N17+N18+N19+N20)*(C4/100)+N10-ABS(N11)))","v":0}]
[]
["Production Margins before Structural Change",null,null,null,null,{"$f":"+F7","v":0},null,{"$f":"+H7","v":0},null,{"$f":"+J7","v":0},null,{"$f":"+L7","v":0},null,{"$f":"+N21","v":0},null,null,null,null,"Unadj",null,null,null,"Adj"]
[" Structural Change",null,null,null,null,{"$f":"IFERROR(IF(U37=\"Y\",S16,0),\"\")","v":0},null,{"$f":"IFERROR(IF(U37=\"Y\",S17,0),\"\")","v":0},null,{"$f":"IFERROR(IF(U37=\"Y\",S18,0),\"\")","v":0},null,{"$f":"IFERROR(IF(U37=\"Y\",S19,0),\"\")","v":0},null,{"$f":"IFERROR(IF(U37=\"Y\",S20,0),\"\")","v":0},null,null,null,null,{"$f":"F23","v":0},{"$f":"IF(C5=\"N\",IF(S24=MAX(S24:S28),\"MAX\",IF(S24=MIN(S24:S28),\"MIN\", \"USE\")),\"DROP\")","v":"MAX"},{"$f":"IF(T24=\"USE\",S24,0)","v":0},null,{"$f":"IFERROR(ROUND(S24+S16,0),0)","v":0},{"$f":"IF(C5=\"N\",IF(W24=MAX(W24:W28),\"MAX\",IF(W24=MIN(W24:W28),\"MIN\", \"USE\")),\"DROP\")","v":"MAX"},{"$f":"IF(X24=\"USE\",W24,0)","v":0}]
["Adjusted Production Margins - Olympic",null,null,null,null,{"$f":"IFERROR(F23+F24,\"\")","v":0},null,{"$f":"IFERROR(ROUND(H23+H24,0),\"\")","v":0},null,{"$f":"IFERROR(ROUND(J23+J24,0),\"\")","v":0},null,{"$f":"IFERROR(L23+L24,\"\")","v":0},null,{"$f":"IFERROR(N23+N24,\"\")","v":0},null,null,null,null,{"$f":"H23","v":0},{"$f":"IF(C5=\"N\",IF(S25=MAX(S24:S28),IF(T24<>\"MAX\",\"MAX\",\"USE\"),IF(S25=MIN(S24:S28),IF(T24<>\"MIN\",\"MIN\",\"USE\"), \"USE\")),\"DROP\")","v":"USE"},{"$f":"IF(T25=\"USE\",S25,0)","v":0},null,{"$f":"IFERROR(ROUND(S25+S17,0),\"\")","v":0},{"$f":"IF(C5=\"N\",IF(W25=MAX(W24:W28),IF(X24<>\"MAX\",\"MAX\",\"USE\"),IF(W25=MIN(W24:W28),IF(X24<>\"MIN\",\"MIN\",\"USE\"), \"USE\")),\"DROP\")","v":"USE"},0]
[null,null,null,null,null,null,null,"Estimated Olympic Average Reference Margin",null,null,null,null,null,null,{"$f":"IFERROR(IF(U37=\"Y\",ROUND(U33,0),ROUND(U32,0)),\"\")","v":0},null,null,null,{"$f":"J23","v":0},{"$f":"IF(C5=\"N\",IF(S26=MAX(S24:S28),IF(AND(T24<>\"MAX\",T25<>\"MAX\"),\"MAX\",\"USE\"),IF(S26=MIN(S24:S28),IF(AND(T24<>\"MIN\",T25<>\"MIN\"),\"MIN\",\"USE\"), \"USE\")),\"USE\")","v":"USE"},{"$f":"IF(T26=\"USE\",S26,0)","v":0},null,{"$f":"IFERROR(ROUND(S26+S18,0),\"\")","v":0},{"$f":"IF(C5=\"N\",IF(W26=MAX(W24:W28),IF(AND(X24<>\"MAX\",X25<>\"MAX\"),\"MAX\",\"USE\"),IF(W26=MIN(W24:W28),IF(AND(X24<>\"MIN\",X25<>\"MIN\"),\"MIN\",\"USE\"), \"USE\")),\"USE\")","v":"USE"},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L23","v":0},{"$f":"IF(C5=\"N\",IF(S27=MAX(S24:S28),IF(AND(T24<>\"MAX\",T25<>\"MAX\",T26<>\"MAX\"),\"MAX\",\"USE\"),IF(S27=MIN(S24:S28),IF(AND(T24<>\"MIN\",T25<>\"MIN\",T26<>\"MIN\"),\"MIN\",\"USE\"), \"USE\")),\"USE\")","v":"USE"},{"$f":"IF(T27=\"USE\",S27,0)","v":0},null,{"$f":"IFERROR(ROUND(S27+S19,0),\"\")","v":0},{"$f":"IF(C5=\"N\",IF(W27=MAX(W24:W28),IF(AND(X24<>\"MAX\",X25<>\"MAX\",X26<>\"MAX\"),\"MAX\",\"USE\"),IF(W27=MIN(W24:W28),IF(AND(X24<>\"MIN\",X25<>\"MIN\",X26<>\"MIN\"),\"MIN\",\"USE\"), \"USE\")),\"USE\")","v":"USE"},0]
["Projected Reference Margin",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O26","v":0},null,null,null,{"$f":"N23","v":0},{"$f":"IF(C5=\"N\",IF(S28=MAX(S24:S28),IF(AND(T24<>\"MAX\",T25<>\"MAX\",T26<>\"MAX\", T27<>\"MAX\"),\"MAX\",\"USE\"),IF(S28=MIN(S24:S28),IF(AND(T24<>\"MIN\",T25<>\"MIN\",T26<>\"MIN\",T27<>\"MIN\"),\"MIN\",\"USE\"), \"USE\")),\"USE\")","v":"USE"},{"$f":"IF(T28=\"USE\",S28,0)","v":0},null,{"$f":"IFERROR(ROUND(S28+S20,0),\"\")","v":0},{"$f":"IF(C5=\"N\",IF(W28=MAX(W24:W28),IF(AND(X24<>\"MAX\",X25<>\"MAX\",X26<>\"MAX\",X27<>\"MAX\"),\"MAX\",\"USE\"),IF(W28=MIN(W24:W28),IF(AND(X24<>\"MIN\",X25<>\"MIN\",X26<>\"MIN\",X27<>\"MIN\"),\"MIN\",\"USE\"), \"USE\")),\"USE\")","v":"USE"},0]
[]
["hide here and after"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UnAdj Margin",null,{"$f":"ROUND(SUM(U24:U28)/3,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted Margin",null,{"$f":"ROUND(SUM(Y24:Y28)/3,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StructChange Amt",null,{"$f":"IFERROR(U33-U32,\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StructChange %",null,{"$f":"IFERROR(IF(U32=0,0,(U33-U32)/U32),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use StructChange",null,{"$f":"IFERROR(IF(ABS(U35)>5000,IF(ABS(U36)>0.1,\"Y\",\"N\"),\"N\"),\"\")","v":"N"}]

{"sheet":"Schedule 1a, b, c","index":1,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[[7,1,7,2],[1,0,1,1],[1,3,1,7],[5,1,5,2],[6,1,6,2],[20,1,20,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,6],[19,1,19,2],[33,1,33,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,6],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,6],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2]]}
[null,null,null,null,null,null,"Schedules 1a, 1b & 1c",null,null,null,"hide here and after"]
["Participant:",null,{"$f":"IF(ISBLANK('Summary Sheet'!C1),\"\",'Summary Sheet'!C1)","v":""}]
[]
[null,"Schedule 1a Deferred Income & Receivables"]
[null,"Description",null,null,"          Starting ($)",null,"           Ending ($)",null,"Change in Value ($)"]
[null,null,null,null,null,null,null,null,{"$f":"G6-E6","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,"Net Increase/(Decrease): in Deferred Income",null,null,null,null,null,null,{"$f":"SUM(I6:I14)","v":0}]
[]
[]
[null,"Schedule1b Unpaid Expenses"]
[null,"Description",null,null,"                   Starting ($)",null,"                     Ending ($)",null,"Change in Value ($)"]
[null,null,null,null,null,null,null,null,{"$f":"E20-G20","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,"Net (Increase)/Decrease: in Unpaid Expenses",null,null,null,null,null,null,{"$f":"SUM(I20:I28)","v":0}]
[]
[]
[null,"Schedule 1c Purchased Inputs"]
[null,"Description",null,null,"                  Starting ($)",null,"                     Ending ($)",null,"Change in Value ($)"]
[null,null,null,null,null,null,null,null,{"$f":"G34-E34","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,"Net Increase/(Decrease): in Purchased Inputs",null,null,null,null,null,null,{"$f":"SUM(I34:I42)","v":0}]
[]
["hide here and after"]

{"sheet":"Crop Inv","index":2,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,9,37,9],[2,2,2,4],[4,2,4,3]]}
[null,null,null,null,"Crop Inventory",null,null,null,null,null,"hide here and after"]
[]
["Participant:",null,{"$f":"IF(ISBLANK('Summary Sheet'!C1),\"\",'Summary Sheet'!C1)","v":""}]
[]
["AFSC ID:",null,{"$f":"IF(ISBLANK('Summary Sheet'!C2),\"\",870&TEXT('Summary Sheet'!C2,\"00000000\"))","v":""}]
[]
[]
[null,"Commodity Description","Starting Inventory","Starting\nPrice ($)","Starting\nValue","Ending Inventory","Ending\nPrice ($)","Ending\nValue","Change in Value ($)"]
[null,null,null,null,{"$f":"IF(AND(C9=\"\",D9=\"\"),\"\",(C9*D9))","v":""},null,null,{"$f":"IF(AND(F9=\"\",G9=\"\"),\"\",(F9*G9))","v":""},{"$f":"IF(H9=\"\",0,H9)-IF(E9=\"\",0,E9)","v":0}]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,null,"",null,null,"",0]
[null,null,null,"Net Increase/(Decrease) in Crop Inventory",null,null,null,null,{"$f":"SUM(I9:I35)","v":0}]
["hide here and after",null,null,null,null,null,null,null,null,1]

{"sheet":"Livestock Inv","index":3,"n_rows":47,"n_cols":17,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,2,2,6],[3,2,3,4],[5,1,5,2]]}
[null,null,null,null,null,null,"         Livestock Inventory",null,null,null,null,null,null,null,null,null,"hide here and after"]
[]
["Participant:",null,{"$f":"IF(ISBLANK('Summary Sheet'!C1),\"\",'Summary Sheet'!C1)","v":""}]
["AFSC ID:",null,{"$f":"IF(ISBLANK('Summary Sheet'!C2),\"\",870&TEXT('Summary Sheet'!C2,\"00000000\"))","v":""}]
[]
[null,"Breeding Livestock (P2 Pricing)"]
[null,"Commodity Description","Starting Inventory",null,"Ending Inventory",null,"Ending\nPrice ($)",null,"Ending\nValue",null,"Change in Value ($)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(E8=\"\",G8=\"\"),\"\",(E8*G8))","v":""},null,{"$f":"(E8-C8)*G8","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(E9=\"\",G9=\"\"),\"\",(E9*G9))","v":""},null,0]
[null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,1,null,null,null,null,"",null,{"$f":"(E13-C13)*G13","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(E14=\"\",G14=\"\"),\"\",(E14*G14))","v":""},null,0]
[null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,null,null,"",null,0]
[null,null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(K8:K18)","v":0}]
[]
[null,"Marketable Livestock (P1-P2 Pricing)"]
[null,"Commodity Description","Starting Inventory",null,"Starting\nPrice ($)",null,"Starting\nValue",null,"Ending Inventory",null,"Ending\nPrice ($)",null,"Ending\nValue",null,"Change in Value ($)"]
[null,null,null,11,null,null,{"$f":"IF(AND(C23=\"\",E23=\"\"),\"\",(C23*E23))","v":""},null,null,null,null,null,{"$f":"IF(AND(I23=\"\",K23=\"\"),\"\",(I23*K23))","v":""},null,{"$f":"IF(M23=\"\",0,M23)-IF(G23=\"\",0,G23)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(C24=\"\",E24=\"\"),\"\",(C24*E24))","v":""},null,null,null,null,null,"",null,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(O23:O42)","v":0}]
[]
[null,null,null,null,"Net Increase/(Decrease) in Livestock Inventory",null,null,null,null,"Total Livestock Inventory",null,null,null,null,{"$f":"(K19+O43)","v":0}]
[]
["hide here and after"]

{"sheet":"Structural Change","index":4,"n_rows":58,"n_cols":41,"rows_kept":58,"cut":false,"hidden":false,"merged":[[18,0,19,0],[4,9,4,10],[13,0,14,0],[0,9,0,10],[2,2,2,4],[2,7,2,8]]}
[null,null,null,null,null,null,"Structural Change Information",null,null,null,null,null,null,null,"hide here and after"]
[]
["Participant:",null,{"$f":"IF(ISBLANK('Summary Sheet'!C1),\"\",'Summary Sheet'!C1)","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,null,null,2018,2019,2020,2021,2022,null,"PREVIOUS MARGIN DATA",2016,2017,2018,2019,2020]
[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,"MARGIN BPU'S","Crop Basket - Dryland",237.73,232.93100000000001,240.517,343.63600000000002,583.41,null,"Crop Basket - Dryland",212.52799999999999,236.21299999999999,237.73,232.93,240.517]
["AFSC ID:",null,{"$f":"IF(ISBLANK('Summary Sheet'!C2),\"\",870&TEXT('Summary Sheet'!C2,\"00000000\"))","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,null,"Crop Basket - Irrigated",400.03399999999999,345.56599999999997,427.60599999999999,758.077,818.80799999999999,null,"Crop Basket - Irrigated",321.88400000000001,375.02499999999998,400.03399999999999,345.56599999999997,427.60599999999999]
[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,"Forage Basket - Dryland",133.18700000000001,221.709,225.863,145.096,343.40800000000002,null,"Forage Basket - Dryland",195.03299999999999,137.33600000000001,133.18700000000001,221.709,225.863]
[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,"Forage Basket - Irrigated",511.642,665.10199999999998,590.48699999999997,655.47199999999998,722.79200000000003,null,"Forage Basket - Irrigated",386.45800000000003,387.70100000000002,511.642,665.10199999999998,590.48699999999997]
[null,null,{"$f":"IF(ISBLANK('Summary Sheet'!H2),\"\",'Summary Sheet'!H2-5)","v":2018},null,{"$f":"IF(ISBLANK('Summary Sheet'!H2),\"\",'Summary Sheet'!H2 - 4)","v":2019},null,{"$f":"IF(ISBLANK('Summary Sheet'!H2),\"\",'Summary Sheet'!H2 - 3)","v":2020},null,{"$f":"IF(ISBLANK('Summary Sheet'!H2),\"\",'Summary Sheet'!H2 - 2)","v":2021},null,{"$f":"IF(ISBLANK('Summary Sheet'!H2),\"\",'Summary Sheet'!H2 - 1)","v":2022},null,{"$f":"IF(ISBLANK('Summary Sheet'!H2),\"\",'Summary Sheet'!H2 )","v":2023}]
["Crop Basket",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,"Cow/Calf - Births",608.697,527.13300000000004,538.97199999999998,410.40300000000002,494.94,null,"Cow/Calf - Births",410.04599999999999,733.99400000000003,608.74599999999998,527.10599999999999,538.62599999999998]
[null,null,null,{"$f":"IF(ISBLANK(C10),\"\",IF(C10>0,C10,1))","v":""},null,{"$f":"IF(ISBLANK(E10),\"\",IF(E10>0,E10,1))","v":""},null,{"$f":"IF(ISBLANK(G10),\"\",IF(G10>0,G10,1))","v":""},null,{"$f":"IF(ISBLANK(I10),\"\",IF(I10>0,I10,1))","v":""},null,{"$f":"IF(ISBLANK(K10),\"\",IF(K10>0,K10,1))","v":""},null,{"$f":"IF(ISBLANK(M10),\"\",IF(M10>0,M10,1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beef Feeders/Fats owned",72.08,69.41,62.91,19.11,0.01,null,"Beef Feeders/Fats owned",27.29,69.8,72.08,69.41,62.91]
[null,null,null,{"$f":"IF(ISBLANK(C11),\"\",IF(C11>0,C11,1))","v":""},null,{"$f":"IF(ISBLANK(E11),\"\",IF(E11>0,E11,1))","v":""},null,{"$f":"IF(ISBLANK(G11),\"\",IF(G11>0,G11,1))","v":""},null,{"$f":"IF(ISBLANK(I11),\"\",IF(I11>0,I11,1))","v":""},null,{"$f":"IF(ISBLANK(K11),\"\",IF(K11>0,K11,1))","v":""},null,{"$f":"IF(ISBLANK(M11),\"\",IF(M11>0,M11,1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Fed Cattle",25.82,27.84,28.6,30.46,34.9,null,"Custom Fed Cattle",27.96,25.82,25.82,27.84,28.6]
[null,null,null,{"$f":"IF(ISBLANK(C12),\"\",IF(C12>0,C12,1))","v":""},null,"",null,"",null,"",null,"",null,""]
[null,null,null,{"$f":"IF(ISBLANK(C13),\"\",IF(C13>0,C13,1))","v":""},null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farrow to Finish",6.77,5.14,1.96,5.18,7.74,null,"Farrow to Finish",0.98,13.83,6.77,5.14,1.96]
["Beef",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farrow to Wean",7.09,7.04,6.11,9.3699999999999992,11.18,null,"Farrow to Wean",4.08,7.09,7.09,7.04,6.11]
[null,null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wean to Finish",1.45,0.01,0.01,0.79,1.75,null,"Wean to Finish",0.01,6.52,1.45,0.01,0.01]
[null,null,null,{"$f":"IF(ISBLANK(C16),\"\",IF(C16>0,C16,1))","v":""},null,{"$f":"IF(ISBLANK(E16),\"\",IF(E16>0,E16,1))","v":""},null,{"$f":"IF(ISBLANK(G16),\"\",IF(G16>0,G16,1))","v":""},null,{"$f":"IF(ISBLANK(I16),\"\",IF(I16>0,I16,1))","v":""},null,{"$f":"IF(ISBLANK(K16),\"\",IF(K16>0,K16,1))","v":""},null,{"$f":"IF(ISBLANK(M16),\"\",IF(M16>0,M16,1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020]
[null,null,null,{"$f":"IF(ISBLANK(C17),\"\",IF(C17>0,C17,1))","v":""},null,{"$f":"IF(ISBLANK(E17),\"\",IF(E17>0,E17,1))","v":""},null,{"$f":"IF(ISBLANK(G17),\"\",IF(G17>0,G17,1))","v":""},null,{"$f":"IF(ISBLANK(I17),\"\",IF(I17>0,I17,1))","v":""},null,{"$f":"IF(ISBLANK(K17),\"\",IF(K17>0,K17,1))","v":""},null,{"$f":"IF(ISBLANK(M17),\"\",IF(M17>0,M17,1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"EXPENSE BPU'S","Crop Basket - Dryland",138.06707692307691,137.6243076923077,124.75753846153846,100.34153846153846,100.34153846153846]
[null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crop Basket - Irrigated",226.982,223.8,196.28800000000001,161.12899999999999,161.12899999999999]
["Market Hogs",null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forage Basket - Dryland",41.579538461538462,39.548615384615381,34.895076923076921,30.367076923076922,30.367076923076922]
[null,null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forage Basket - Irrigated",121.26,116.69,101.97,85.34,85.34]
[null,null,null,{"$f":"IF(ISBLANK(C21),\"\",IF(C21>0,C21,1))","v":""},null,"",null,"",null,"",null,"",null,""]
[null,null,null,"",null,{"$f":"IF(ISBLANK(E22),\"\",IF(E22>0,E22,1))","v":""},null,{"$f":"IF(ISBLANK(G22),\"\",IF(G22>0,G22,1))","v":""},null,{"$f":"IF(ISBLANK(I22),\"\",IF(I22>0,I22,1))","v":""},null,{"$f":"IF(ISBLANK(K22),\"\",IF(K22>0,K22,1))","v":""},null,{"$f":"IF(ISBLANK(M22),\"\",IF(M22>0,M22,1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cow/Calf - Births",362.55200000000002,510.42599999999999,467.274,374.41,374.41]
[null,null,null,"",null,{"$f":"IF(ISBLANK(E23),\"\",IF(E23>0,E23,1))","v":""},null,{"$f":"IF(ISBLANK(G23),\"\",IF(G23>0,G23,1))","v":""},null,{"$f":"IF(ISBLANK(I23),\"\",IF(I23>0,I23,1))","v":""},null,{"$f":"IF(ISBLANK(K23),\"\",IF(K23>0,K23,1))","v":""},null,{"$f":"IF(ISBLANK(M23),\"\",IF(M23>0,M23,1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feeders/Fats - Sold",1224.3499999999999,1986.1,1957.99,1279.3900000000001,1279.3900000000001]
[null,null,null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Fed Cattle",299.85000000000002,348.65,315.76,303.8,303.8]
[]
["hide here and after",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,"Farrow to Finish",141.34,144.62,150.6,149.31,149.31]
[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,"Farrow to Wean",62.24,63.81,65.349999999999994,65.459999999999994,65.459999999999994]
[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,"Wean to Finish",138.66,144.44,152.94,157.56,157.56]
[]
["current size",null,null,null,null,null,null,null,null,null,null,null,null,"Expense"]
["crop basket 1",null,{"$f":"ROUND(M10*ROUND(O10,4),2)","v":0},null,{"$f":"ROUND(M10*ROUND(P10,4),2)","v":0},null,{"$f":"ROUND(M10*ROUND(Q10,4),2)","v":0},null,{"$f":"ROUND(M10*ROUND(R10,4),2)","v":0},null,{"$f":"ROUND(M10*ROUND(S10,4),2)","v":0},null,null,{"$f":"ROUND(M10*ROUND(U10,4),2)","v":0},{"$f":"ROUND(M10*ROUND(V10,4),2)","v":0},{"$f":"ROUND(M10*ROUND(W10,4),2)","v":0},{"$f":"ROUND(M10*ROUND(X10,4),2)","v":0},{"$f":"ROUND(M10*ROUND(Y10,4),2)","v":0}]
["crop basket 2",null,{"$f":"ROUND(M11*ROUND(O11,4),2)","v":0},null,{"$f":"ROUND(M11*ROUND(P11,4),2)","v":0},null,{"$f":"ROUND(M11*ROUND(Q11,4),2)","v":0},null,{"$f":"ROUND(M11*ROUND(R11,4),2)","v":0},null,{"$f":"ROUND(M11*ROUND(S11,4),2)","v":0},null,null,{"$f":"ROUND(M11*ROUND(U11,4),2)","v":0},{"$f":"ROUND(M11*ROUND(V11,4),2)","v":0},{"$f":"ROUND(M11*ROUND(W11,4),2)","v":0},{"$f":"ROUND(M11*ROUND(X11,4),2)","v":0},{"$f":"ROUND(M11*ROUND(Y11,4),2)","v":0}]
["crop basket 3",null,{"$f":"ROUND(M12*ROUND(O12,4),2)","v":0},null,{"$f":"ROUND(M12*ROUND(P12,4),2)","v":0},null,{"$f":"ROUND(M12*ROUND(Q12,4),2)","v":0},null,{"$f":"ROUND(M12*ROUND(R12,4),2)","v":0},null,{"$f":"ROUND(M12*ROUND(S12,4),2)","v":0},null,null,{"$f":"ROUND(M12*ROUND(U12,4),2)","v":0},{"$f":"ROUND(M12*ROUND(V12,4),2)","v":0},{"$f":"ROUND(M12*ROUND(W12,4),2)","v":0},{"$f":"ROUND(M12*ROUND(X12,4),2)","v":0},{"$f":"ROUND(M12*ROUND(Y12,4),2)","v":0}]
["crop basket 4",null,{"$f":"ROUND(M13*ROUND(O13,4),2)","v":0},null,{"$f":"ROUND(M13*ROUND(P13,4),2)","v":0},null,{"$f":"ROUND(M13*ROUND(Q13,4),2)","v":0},null,{"$f":"ROUND(M13*ROUND(R13,4),2)","v":0},null,{"$f":"ROUND(M13*ROUND(S13,4),2)","v":0},null,null,{"$f":"ROUND(M13*ROUND(U13,4),2)","v":0},{"$f":"ROUND(M13*ROUND(V13,4),2)","v":0},{"$f":"ROUND(M13*ROUND(W13,4),2)","v":0},{"$f":"ROUND(M13*ROUND(X13,4),2)","v":0},{"$f":"ROUND(M13*ROUND(Y13,4),2)","v":0}]
["beef 1",null,{"$f":"ROUND(M16*ROUND(O16,4),2)","v":0},null,{"$f":"ROUND(M16*ROUND(P16,4),2)","v":0},null,{"$f":"ROUND(M16*ROUND(Q16,4),2)","v":0},null,{"$f":"ROUND(M16*ROUND(R16,4),2)","v":0},null,{"$f":"ROUND(M16*ROUND(S16,4),2)","v":0},null,null,{"$f":"ROUND(M16*ROUND(U16,4),2)","v":0},{"$f":"ROUND(M16*ROUND(V16,4),2)","v":0},{"$f":"ROUND(M16*ROUND(W16,4),2)","v":0},{"$f":"ROUND(M16*ROUND(X16,4),2)","v":0},{"$f":"ROUND(M16*ROUND(Y16,4),2)","v":0}]
["beef 2",null,{"$f":"ROUND(M17*ROUND(O17,4),2)","v":0},null,{"$f":"ROUND(M17*ROUND(P17,4),2)","v":0},null,{"$f":"ROUND(M17*ROUND(Q17,4),2)","v":0},null,{"$f":"ROUND(M17*ROUND(R17,4),2)","v":0},null,{"$f":"ROUND(M17*ROUND(S17,4),2)","v":0},null,null,{"$f":"ROUND(M17*ROUND(U17,4),2)","v":0},{"$f":"ROUND(M17*ROUND(V17,4),2)","v":0},{"$f":"ROUND(M17*ROUND(W17,4),2)","v":0},{"$f":"ROUND(M17*ROUND(X17,4),2)","v":0},{"$f":"ROUND(M17*ROUND(Y17,4),2)","v":0}]
["beef3",null,{"$f":"ROUND(M18*ROUND(O18,4),2)","v":0},null,{"$f":"ROUND(M18*ROUND(P18,4),2)","v":0},null,{"$f":"ROUND(M18*ROUND(Q18,4),2)","v":0},null,{"$f":"ROUND(M18*ROUND(R18,4),2)","v":0},null,{"$f":"ROUND(M18*ROUND(S18,4),2)","v":0},null,null,{"$f":"ROUND(M18*ROUND(U18,4),2)","v":0},{"$f":"ROUND(M18*ROUND(V18,4),2)","v":0},{"$f":"ROUND(M18*ROUND(W18,4),2)","v":0},{"$f":"ROUND(M18*ROUND(X18,4),2)","v":0},{"$f":"ROUND(M18*ROUND(Y18,4),2)","v":0}]
["market hogs1",null,{"$f":"ROUND(M21*ROUND(O21,4),2)","v":0},null,{"$f":"ROUND(M21*ROUND(P21,4),2)","v":0},null,{"$f":"ROUND(M21*ROUND(Q21,4),2)","v":0},null,{"$f":"ROUND(M21*ROUND(R21,4),2)","v":0},null,{"$f":"ROUND(M21*ROUND(S21,4),2)","v":0},null,null,{"$f":"ROUND(M21*ROUND(U21,4),2)","v":0},{"$f":"ROUND(M21*ROUND(V21,4),2)","v":0},{"$f":"ROUND(M21*ROUND(W21,4),2)","v":0},{"$f":"ROUND(M21*ROUND(X21,4),2)","v":0},{"$f":"ROUND(M21*ROUND(Y21,4),2)","v":0}]
["market hogs 2",null,{"$f":"ROUND(M22*ROUND(O22,4),2)","v":0},null,{"$f":"ROUND(M22*ROUND(P22,4),2)","v":0},null,{"$f":"ROUND(M22*ROUND(Q22,4),2)","v":0},null,{"$f":"ROUND(M22*ROUND(R22,4),2)","v":0},null,{"$f":"ROUND(M22*ROUND(S22,4),2)","v":0},null,null,{"$f":"ROUND(M22*ROUND(U22,4),2)","v":0},{"$f":"ROUND(M22*ROUND(V22,4),2)","v":0},{"$f":"ROUND(M22*ROUND(W22,4),2)","v":0},{"$f":"ROUND(M22*ROUND(X22,4),2)","v":0},{"$f":"ROUND(M22*ROUND(Y22,4),2)","v":0}]
["markethogs 3",null,{"$f":"ROUND(M23*ROUND(O23,4),2)","v":0},null,{"$f":"ROUND(M23*ROUND(P23,4),2)","v":0},null,{"$f":"ROUND(M23*ROUND(Q23,4),2)","v":0},null,{"$f":"ROUND(M23*ROUND(R23,4),2)","v":0},null,{"$f":"ROUND(M23*ROUND(S23,4),2)","v":0},null,null,{"$f":"ROUND(M23*ROUND(U23,4),2)","v":0},{"$f":"ROUND(M23*ROUND(V23,4),2)","v":0},{"$f":"ROUND(M23*ROUND(W23,4),2)","v":0},{"$f":"ROUND(M23*ROUND(X23,4),2)","v":0},{"$f":"ROUND(M23*ROUND(Y23,4),2)","v":0}]
["Current size total",null,{"$f":"SUM(C30:C40)","v":0},null,{"$f":"SUM(E30:E40)","v":0},null,{"$f":"SUM(G30:G40)","v":0},null,{"$f":"SUM(I30:I40)","v":0},null,{"$f":"SUM(K30:K40)","v":0},null,null,{"$f":"SUM(N30:N40)","v":0},{"$f":"SUM(O30:O40)","v":0},{"$f":"SUM(P30:P40)","v":0},{"$f":"SUM(Q30:Q40)","v":0},{"$f":"SUM(R30:R40)","v":0}]
[]
[]
["Historic size",null,null,null,null,null,null,null,null,null,null,null,null,"Expense"]
["crop basket 1",null,{"$f":"ROUND(C10*ROUND(O10,4),2)","v":0},null,{"$f":"ROUND(E10*ROUND(P10,4),2)","v":0},null,{"$f":"ROUND(G10*ROUND(Q10,4),2)","v":0},null,{"$f":"ROUND(I10*ROUND(R10,4),2)","v":0},null,{"$f":"ROUND(K10*ROUND(S10,4),2)","v":0},null,null,{"$f":"ROUND(C10*ROUND(U10,4),2)","v":0},{"$f":"ROUND(E10*ROUND(V10,4),2)","v":0},{"$f":"ROUND(G10*ROUND(W10,4),2)","v":0},{"$f":"ROUND(I10*ROUND(X10,4),2)","v":0},{"$f":"ROUND(K10*ROUND(Y10,4),2)","v":0}]
["crop basket 2",null,{"$f":"ROUND(C11*ROUND(O11,4),2)","v":0},null,{"$f":"ROUND(E11*ROUND(P11,4),2)","v":0},null,{"$f":"ROUND(G11*ROUND(Q11,4),2)","v":0},null,{"$f":"ROUND(I11*ROUND(R11,4),2)","v":0},null,{"$f":"ROUND(K11*ROUND(S11,4),2)","v":0},null,null,{"$f":"ROUND(C11*ROUND(U11,4),2)","v":0},{"$f":"ROUND(E11*ROUND(V11,4),2)","v":0},{"$f":"ROUND(G11*ROUND(W11,4),2)","v":0},{"$f":"ROUND(I11*ROUND(X11,4),2)","v":0},{"$f":"ROUND(K11*ROUND(Y11,4),2)","v":0}]
["crop basket 3",null,{"$f":"ROUND(C12*ROUND(O12,4),2)","v":0},null,{"$f":"ROUND(E12*ROUND(P12,4),2)","v":0},null,{"$f":"ROUND(G12*ROUND(Q12,4),2)","v":0},null,{"$f":"ROUND(I12*ROUND(R12,4),2)","v":0},null,{"$f":"ROUND(K12*ROUND(S12,4),2)","v":0},null,null,{"$f":"ROUND(C12*ROUND(U12,4),2)","v":0},{"$f":"ROUND(E12*ROUND(V12,4),2)","v":0},{"$f":"ROUND(G12*ROUND(W12,4),2)","v":0},{"$f":"ROUND(I12*ROUND(X12,4),2)","v":0},{"$f":"ROUND(K12*ROUND(Y12,4),2)","v":0}]
["crop basket 4",null,{"$f":"ROUND(C13*ROUND(O13,4),2)","v":0},null,{"$f":"ROUND(E13*ROUND(P13,4),2)","v":0},null,{"$f":"ROUND(G13*ROUND(Q13,4),2)","v":0},null,{"$f":"ROUND(I13*ROUND(R13,4),2)","v":0},null,{"$f":"ROUND(K13*ROUND(S13,4),2)","v":0},null,null,{"$f":"ROUND(C13*ROUND(U13,4),2)","v":0},{"$f":"ROUND(E13*ROUND(V13,4),2)","v":0},{"$f":"ROUND(G13*ROUND(W13,4),2)","v":0},{"$f":"ROUND(I13*ROUND(X13,4),2)","v":0},{"$f":"ROUND(K13*ROUND(Y13,4),2)","v":0}]
["beef 1",null,{"$f":"ROUND(C16*ROUND(O16,4),2)","v":0},null,{"$f":"ROUND(E16*ROUND(P16,4),2)","v":0},null,{"$f":"ROUND(G16*ROUND(Q16,4),2)","v":0},null,{"$f":"ROUND(I16*ROUND(R16,4),2)","v":0},null,{"$f":"ROUND(K16*ROUND(S16,4),2)","v":0},null,null,{"$f":"ROUND(C16*ROUND(U16,4),2)","v":0},{"$f":"ROUND(E16*ROUND(V16,4),2)","v":0},{"$f":"ROUND(G16*ROUND(W16,4),2)","v":0},{"$f":"ROUND(I16*ROUND(X16,4),2)","v":0},{"$f":"ROUND(K16*ROUND(Y16,4),2)","v":0}]
["beef 2",null,{"$f":"ROUND(C17*ROUND(O17,4),2)","v":0},null,{"$f":"ROUND(E17*ROUND(P17,4),2)","v":0},null,{"$f":"ROUND(G17*ROUND(Q17,4),2)","v":0},null,{"$f":"ROUND(I17*ROUND(R17,4),2)","v":0},null,{"$f":"ROUND(K17*ROUND(S17,4),2)","v":0},null,null,{"$f":"ROUND(C17*ROUND(U17,4),2)","v":0},{"$f":"ROUND(E17*ROUND(V17,4),2)","v":0},{"$f":"ROUND(G17*ROUND(W17,4),2)","v":0},{"$f":"ROUND(I17*ROUND(X17,4),2)","v":0},{"$f":"ROUND(K17*ROUND(Y17,4),2)","v":0}]
["beef3",null,{"$f":"ROUND(C18*ROUND(O18,4),2)","v":0},null,{"$f":"ROUND(E18*ROUND(P18,4),2)","v":0},null,{"$f":"ROUND(G18*ROUND(Q18,4),2)","v":0},null,{"$f":"ROUND(I18*ROUND(R18,4),2)","v":0},null,{"$f":"ROUND(K18*ROUND(S18,4),2)","v":0},null,null,{"$f":"ROUND(C18*ROUND(U18,4),2)","v":0},{"$f":"ROUND(E18*ROUND(V18,4),2)","v":0},{"$f":"ROUND(G18*ROUND(W18,4),2)","v":0},{"$f":"ROUND(I18*ROUND(X18,4),2)","v":0},{"$f":"ROUND(K18*ROUND(Y18,4),2)","v":0}]
["market hogs1",null,{"$f":"ROUND(C21*ROUND(O21,4),2)","v":0},null,{"$f":"ROUND(E21*ROUND(P21,4),2)","v":0},null,{"$f":"ROUND(G21*ROUND(Q21,4),2)","v":0},null,{"$f":"ROUND(I21*ROUND(R21,4),2)","v":0},null,{"$f":"ROUND(K21*ROUND(S21,4),2)","v":0},null,null,{"$f":"ROUND(C21*ROUND(U21,4),2)","v":0},{"$f":"ROUND(E21*ROUND(V21,4),2)","v":0},{"$f":"ROUND(G21*ROUND(W21,4),2)","v":0},{"$f":"ROUND(I21*ROUND(X21,4),2)","v":0},{"$f":"ROUND(K21*ROUND(Y21,4),2)","v":0}]
["market hogs 2",null,{"$f":"ROUND(C22*ROUND(O22,4),2)","v":0},null,{"$f":"ROUND(E22*ROUND(P22,4),2)","v":0},null,{"$f":"ROUND(G22*ROUND(Q22,4),2)","v":0},null,{"$f":"ROUND(I22*ROUND(R22,4),2)","v":0},null,{"$f":"ROUND(K22*ROUND(S22,4),2)","v":0},null,null,{"$f":"ROUND(C22*ROUND(U22,4),2)","v":0},{"$f":"ROUND(E22*ROUND(V22,4),2)","v":0},{"$f":"ROUND(G22*ROUND(W22,4),2)","v":0},{"$f":"ROUND(I22*ROUND(X22,4),2)","v":0},{"$f":"ROUND(K22*ROUND(Y22,4),2)","v":0}]
["markethogs 3",null,{"$f":"ROUND(C23*ROUND(O23,4),2)","v":0},null,{"$f":"ROUND(E23*ROUND(P23,4),2)","v":0},null,{"$f":"ROUND(G23*ROUND(Q23,4),2)","v":0},null,{"$f":"ROUND(I23*ROUND(R23,4),2)","v":0},null,{"$f":"ROUND(K23*ROUND(S23,4),2)","v":0},null,null,{"$f":"ROUND(C23*ROUND(U23,4),2)","v":0},{"$f":"ROUND(E23*ROUND(V23,4),2)","v":0},{"$f":"ROUND(G23*ROUND(W23,4),2)","v":0},{"$f":"ROUND(I23*ROUND(X23,4),2)","v":0},{"$f":"ROUND(K23*ROUND(Y23,4),2)","v":0}]
["Historic size totals",null,{"$f":"SUM(C45:C54)","v":0},null,{"$f":"SUM(E45:E54)","v":0},null,{"$f":"SUM(G45:G54)","v":0},null,{"$f":"SUM(I45:I54)","v":0},null,{"$f":"SUM(K45:K54)","v":0},null,null,{"$f":"SUM(N45:N54)","v":0},{"$f":"SUM(O45:O54)","v":0},{"$f":"SUM(P45:P54)","v":0},{"$f":"SUM(Q45:Q54)","v":0},{"$f":"SUM(R45:R54)","v":0}]
[]
[]
["Ratio difference %",null,{"$f":"IF(C55=0,0,((C41-C55)/C55))","v":0},null,{"$f":"IF(E55=0,0,((E41-E55)/E55))","v":0},null,{"$f":"IF(G55=0,0,((G41-G55)/G55))","v":0},null,{"$f":"IF(I55=0,0,((I41-I55)/I55))","v":0},null,{"$f":"IF(K55=0,0,((K41-K55)/K55))","v":0},null,null,{"$f":"IF(N55=0,0,((N41-N55)/N55))","v":0},{"$f":"IF(O55=0,0,((O41-O55)/O55))","v":0},{"$f":"IF(P55=0,0,((P41-P55)/P55))","v":0},{"$f":"IF(Q55=0,0,((Q41-Q55)/Q55))","v":0},{"$f":"IF(R55=0,0,((R41-R55)/R55))","v":0}]