{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Pig Spaces","open1","open2"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pig Spaces","index":0,"n_rows":368,"n_cols":48,"rows_kept":368,"cut":false,"hidden":false,"merged":[[1,11,1,13],[2,1,4,7],[5,11,5,13],[4,11,4,13],[3,11,3,13],[2,11,2,13]]}
[null,"Iowa Pork Industry Center",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-10-01"}]
[null,null,null,null,null,null,null,null,null,null,"Prepared for:"]
[null,"Pig Space Considerations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Week","pigs to nursery","pigs to finisher","pigs to market","Week","Nursery Spaces","Finisher Spaces",null,null,"nursery weeks",null,null,null,null,null,null,"finisher weeks"]
[null,null,null,null,null,null,null,null,null,null,"Prepared by:",null,null,null,null,null,"jan",1,{"$f":"E10*G13","v":900},{"$f":"(1-$G$14)*S50","v":1012},{"$f":"(1-$G$14)*T28","v":981.64},{"$f":"1","v":1},{"$f":"SUM(S51:S55)+S4+SUM(AA4:AF4)","v":6000},{"$f":"T4+SUM(T44:T55)+(SUM(AH4:AU4))","v":21888},null,null,{"$f":"IF($L$14-$L$13>6,S50,0)","v":0},{"$f":"IF($L$14-$L$13>7,S49,0)","v":0},{"$f":"IF($L$14-$L$13>8,S48,0)","v":0},{"$f":"IF($L$14-$L$13>9,S47,0)","v":0},{"$f":"IF($L$14-$L$13>10,S46,0)","v":0},{"$f":"IF($L$14-$L$13>11,S45,0)","v":0},null,{"$f":"IF($L$15-$L$14>12,$T43,0)","v":1152},{"$f":"IF($L$15-$L$14>13,$T42,0)","v":1152},{"$f":"IF($L$15-$L$14>14,$T41,0)","v":1152},{"$f":"IF($L$15-$L$14>15,$T40,0)","v":1152},{"$f":"IF($L$15-$L$14>16,$T39,0)","v":1164},{"$f":"IF($L$15-$L$14>17,$T38,0)","v":1164},{"$f":"IF($L$15-$L$14>18,$T37,0)","v":1164},{"$f":"IF($L$15-$L$14>19,$T36,0)","v":0},{"$f":"IF($L$15-$L$14>20,$T35,0)","v":0},{"$f":"IF($L$15-$L$14>21,$T34,0)","v":0},{"$f":"IF($L$15-$L$14>22,$T33,0)","v":0},{"$f":"IF($L$15-$L$14>23,$T32,0)","v":0},{"$f":"IF($L$15-$L$14>24,$T31,0)","v":0},{"$f":"IF($L$15-$L$14>25,$T30,0)","v":0},"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jan",{"$f":"1+R4","v":2},{"$f":"S4","v":900},{"$f":"(1-$G$14)*S51","v":1012},{"$f":"(1-$G$14)*T29","v":981.64},{"$f":"1+V4","v":2},{"$f":"SUM(S52:S56)+SUM(S$4:S5)+SUM(AA5:AF5)","v":5800},{"$f":"SUM($T$4:T5)+SUM(T45:T56)+(SUM(AH5:AU5))","v":21736},null,null,0,0,0,0,0,0,null,1152,1152,1152,1152,1152,1164,1164,0,0,0,0,0,0,0,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jan",{"$f":"1+R5","v":3},{"$f":"S5","v":900},1012,1070.8800000000001,{"$f":"1+V5","v":3},{"$f":"SUM(S53:S57)+SUM(S$4:S6)+SUM(AA6:AF6)","v":5600},{"$f":"SUM($T$4:T6)+SUM(T46:T57)+(SUM(AH6:AU6))","v":21584},null,null,0,0,0,0,0,0,null,1152,1152,1152,1152,1152,1152,1164,0,0,0,0,0,0,0,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jan",4,900,1012,1070.8800000000001,4,{"$f":"SUM(S54:S58)+SUM(S$4:S7)+SUM(AA7:AF7)","v":5400},{"$f":"SUM($T$4:T7)+SUM(T47:T58)+(SUM(AH7:AU7))","v":21432},null,null,0,0,0,0,0,0,null,1056,1152,1152,1152,1152,1152,1152,0,0,0,0,0,0,0,"January - Feb."]
[null,"Input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jan",5,900,828,1070.8800000000001,5,{"$f":"SUM(S55:S59)+SUM(S4:S8)+SUM(AA8:AF8)","v":5400},{"$f":"SUM($T$4:T8)+SUM(T48:T59)+(SUM(AH8:AU8))","v":21108},null,null,0,0,0,0,0,0,null,1056,1056,1152,1152,1152,1152,1152,0,0,0,0,0,0,0,"February"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"feb",6,900,828,1070.8800000000001,6,{"$f":"SUM(S5:S9)+SUM(AA9:AF9)","v":4500},{"$f":"SUM($T$4:T9)+SUM(T49:T60)+(SUM(AH9:AU9))","v":20784},null,null,0,0,0,0,0,0,null,1056,1056,1056,1152,1152,1152,1152,0,0,0,0,0,0,0,"February"]
[null,"Sows Farrowing per Week ",null,null,100,null,{"$f":"(E10*52)/E11","v":2260.8695652173915},"sows",null,null,null,null,null,null,null,null,"feb",7,900,{"$f":"(1-$G$14)*S4","v":828},1070.8800000000001,7,{"$f":"SUM(S6:S10)+SUM(AA10:AF10)","v":4500},{"$f":"SUM($T$4:T10)+SUM(T50:T61)+(SUM(AH10:AU10))","v":20460},null,null,{"$f":"IF($L$14-$L$13>6,S4,0)","v":0},0,0,0,0,0,null,1056,1056,1056,1056,1152,1152,1152,0,0,0,0,0,0,0,"February"]
[null,"Litters per Sow per Year",null,null,2.2999999999999998,null,null,null,null,null,null,null,null,null,null,null,"feb",8,900,{"$f":"(1-$G$14)*S5","v":828},1070.8800000000001,8,4500,{"$f":"SUM($T$4:T11)+SUM(T51:T62)+(SUM(AH11:AU11))","v":20136},null,null,0,{"$f":"IF($L$14-$L$13>7,S4,0)","v":0},0,0,0,0,null,1056,1056,1056,1056,1056,1152,1152,0,0,0,0,0,0,0,"February - March"]
[null,"Seasonal Data",null,"Spring","Summer","Fall","Winter","Overall",null,"Current Timeline",null,null,null,null,null,null,"mar",9,900,828,1070.8800000000001,9,4500,{"$f":"SUM($T$4:T12)+SUM(T52:T63)+(SUM(AH12:AU12))","v":19812},null,null,0,0,{"$f":"IF($L$14-$L$13>8,S4,0)","v":0},0,0,0,null,1056,1056,1056,1056,1056,1056,1152,0,0,0,0,0,0,0,"March"]
[null,"Pigs Weaned per Sow",null,11,12,11,9,{"$f":"AVERAGE(D13:G13)","v":10.75},null,"Age Entering Nursery",null,4,"weeks 3-5",null,null,null,"mar",10,900,828,1070.8800000000001,10,4500,{"$f":"SUM($T$4:T13)+SUM(T53:T64)+(SUM(AH13:AU13))","v":19488},null,null,0,0,0,{"$f":"IF($L$14-$L$13>9,S4,0)","v":0},0,0,null,1056,1056,1056,1056,1056,1056,1056,0,0,0,0,0,0,0,"March"]
[null,"Nursery Mortality",null,0.05,0.03,0.04,0.08,{"$f":"AVERAGE(D14:G14)","v":0.05},null,"Age Entering Finisher",null,10,"weeks (10-15)",{"$f":"(L14-L13)*7","v":42},null,null,"mar",11,{"$f":"S13","v":900},828,1070.8800000000001,11,4500,{"$f":"SUM($T$4:T14)+SUM(T54:T65)+(SUM(AH14:AU14))","v":19260},null,null,0,0,0,0,{"$f":"IF($L$14-$L$13>10,S4,0)","v":0},0,null,1056,1056,1056,1056,1056,1056,1056,0,0,0,0,0,0,0,"March"]
[null,"Finisher Mortality",null,0.03,0.06,0.05,7.0000000000000007E-2,5.2500000000000005E-2,null,"Age at Market",null,29,"weeks (27 - 34)",{"$f":"(L15-L14)*7","v":133},null,null,"mar",12,{"$f":"E10*D13","v":1100},{"$f":"(1-$D$14)*S9","v":855},1070.8800000000001,12,4700,{"$f":"SUM($T$4:T15)+SUM(T55:T66)+(SUM(AH15:AU15))","v":19059},null,null,0,0,0,0,0,{"$f":"IF($L$14-$L$13>11,S4,0)","v":0},null,1012,1056,1056,1056,1056,1056,1056,0,0,0,0,0,0,0,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mar",13,{"$f":"S15","v":1100},{"$f":"(1-$D$14)*S10","v":855},{"$f":"(1-$D$14)*T40","v":1094.3999999999999},13,4900,{"$f":"SUM(T4:T16)+(SUM(AH16:AU16))","v":18858},null,null,0,0,0,0,0,0,null,1012,1012,1056,1056,1056,1056,1056,0,0,0,0,0,0,0,"April"]
[null,"Current Performance",null,"Nursery","Finisher",null,null,null,null,"Current Market Weights",null,null,null,null,null,null,"apr",14,{"$f":"S16","v":1100},855,{"$f":"(1-$D$14)*T41","v":1094.3999999999999},14,5100,{"$f":"SUM(T5:T17)+(SUM(AH17:AU17))","v":18657},null,null,0,0,0,0,0,0,null,{"$f":"IF($L$15-$L$14>12,$T4,0)","v":1012},1012,1012,1056,1056,1056,1056,0,0,0,0,0,0,0,"April"]
[null,"Wt. per Pig Entering ",null,15,58,"lbs",null,null,null,"Finished Market  Wt.",null,285,"lbs",null,null,null,"apr",15,1100,855,1094.3999999999999,15,5300,18456,null,null,0,0,0,0,0,0,null,1012,{"$f":"IF($L$15-$L$14>13,$T4,0)","v":1012},1012,1012,1056,1056,1056,0,0,0,0,0,0,0,"April"]
[null,"Avg Daily Gain",null,{"$f":"(E18-D18)/(7*(L14-L13))","v":1.0238095238095237},{"$f":"(L18-E18)/((L15-L14)*7)","v":1.7067669172932332},"lbs/day",null,null,null,"Target Market Wt. Range",null,270,"lbs     to",300,"lbs",null,"apr",16,1100,855,1094.3999999999999,16,5500,18255,null,null,0,0,0,0,0,0,null,1012,1012,{"$f":"IF($L$15-$L$14>14,$T4,0)","v":1012},1012,1012,1056,1056,0,0,0,0,0,0,0,"April"]
[null,"F:G",null,2,2.4,null,null,null,null,null,null,null,null,null,null,null,"apr",17,1100,855,1094.3999999999999,17,5500,18054,null,null,0,0,0,0,0,0,null,1012,1012,1012,{"$f":"IF($L$15-$L$14>15,$T4,0)","v":1012},1012,1012,1056,0,0,0,0,0,0,0,"April-May"]
[null,"Livability  ",null,{"$f":"1-H14","v":0.95},{"$f":"1-H15","v":0.94750000000000001},null,null,null,null,"Current Building Specs.",null,"Nursery","Finisher",null,null,null,"may",18,1100,1045,1094.3999999999999,18,5500,18043,null,null,0,0,0,0,0,0,null,828,1012,1012,1012,{"$f":"IF($L$15-$L$14>16,$T4,0)","v":1012},1012,1012,0,0,0,0,0,0,0,"May"]
[null,null,null,null,null,null,null,null,null,"Building Cost",null,100000,100000,null,null,null,"may",19,1100,1045,1003.1999999999999,19,5500,18076,null,null,0,0,0,0,0,0,null,828,828,1012,1012,1012,{"$f":"IF($L$15-$L$14>17,$T4,0)","v":1012},1012,0,0,0,0,0,0,0,"May"]
[null,"Pen Charge ",null,0.15,0.2,"$/hd/day",null,null,null,"Building Capacity",null,4000,2000,"head",null,null,"may",20,1100,1045,1003.1999999999999,20,5500,18109,null,null,0,0,0,0,0,0,null,828,828,828,1012,1012,1012,{"$f":"IF($L$15-$L$14>18,$T4,0)","v":1012},0,0,0,0,0,0,0,"May"]
[null,"Feed Cost ",null,200,180,"$/ton",null,null,null,"Current Floor Space/Pig",null,3.5,8,"square feet ",null,null,"may",21,{"$f":"E10*E13","v":1200},{"$f":"(1-$E$14)*S18","v":1067},1003.1999999999999,21,5600,18164,null,null,0,0,0,0,0,0,null,828,828,828,828,1012,1012,1012,{"$f":"IF($L$15-$L$14>19,$T4,0)","v":0},0,0,0,0,0,0,"May"]
[null,"Breakeven  ",null,80,45,"$/cwt - live",null,null,null,null,null,{"$f":"L24*L23","v":14000},{"$f":"M24*M23","v":16000},null,null,null,"June",22,{"$f":"S24","v":1200},{"$f":"(1-$E$14)*S19","v":1067},1003.1999999999999,22,5700,18219,null,null,0,0,0,0,0,0,null,828,828,828,828,828,1012,1012,0,{"$f":"IF($L$15-$L$14>20,$T4,0)","v":0},0,0,0,0,0,{"$f":"Q26","v":"June"}]
[null,"Market Value  ",null,100,50,"$/cwt - live",null,null,null,"Floor Space Adjustments",null,"Default","User Defined",null,null,null,"June",23,{"$f":"S25","v":1200},1067,1003.1999999999999,23,5800,18274,null,null,0,0,0,0,0,0,null,828,828,828,828,828,828,1012,0,0,{"$f":"IF($L$15-$L$14>21,$T4,0)","v":0},0,0,0,0,"June"]
[null,"Weeks per Turn",null,13,21,null,null,null,null,"Avg. Daily Gain",null,5.8500000000000003E-2,5.8500000000000003E-2,"per added square foot",null,null,"June",24,1200,1067,1003.1999999999999,24,5900,18329,null,null,0,0,0,0,0,0,null,828,828,828,828,828,828,828,0,0,0,{"$f":"IF($L$15-$L$14>22,$T4,0)","v":0},0,0,0,"June"]
[null,"Total Spaces",null,4000,20000,null,null,null,null,"Feed to Gain ",null,-7.1999999999999995E-2,-7.1999999999999995E-2,"per added square foot",null,null,"June",25,1200,1067,{"$f":"(1-$E$14)*T52","v":1024.32},25,6000,18568,null,null,0,0,0,0,0,0,null,855,828,828,828,828,828,828,0,0,0,0,{"$f":"IF($L$15-$L$14>23,$T4,0)","v":0},0,0,"June-July"]
[null,"Spaces / Sow",null,{"$f":"D28/G10","v":1.7692307692307692},{"$f":"E28/G10","v":8.8461538461538449},null,null,null,null,"Livability ",null,1.4E-2,1.4E-2,"per added square foot",null,null,"july",26,1200,1067,{"$f":"(1-$E$14)*T53","v":1024.32},26,6000,18807,null,null,0,0,0,0,0,0,null,855,855,828,828,828,828,828,0,0,0,0,0,{"$f":"IF($L$15-$L$14>24,$T4,0)","v":0},0,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M29>H14,0.1*M29,M29)","v":1.4E-2},{"$f":"IF(M29>H15,0.1*M29,M29)","v":1.4E-2},null,null,"july",27,1200,1164,981.64,27,6000,19143,null,null,0,0,0,0,0,0,null,855,855,855,828,828,828,828,0,0,0,0,0,0,{"$f":"IF($L$15-$L$14>25,$T4,0)","v":0},"July"]
[null,"Output",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"july",28,1200,1164,981.64,28,6000,19479,null,null,0,0,0,0,0,0,null,855,855,855,855,828,828,828,0,0,0,0,0,0,0,"July"]
[null,"Yearly Space Projection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"july",29,1200,1164,{"$f":"(1-$E$14)*T4","v":981.64},29,6000,19815,null,null,0,0,0,0,0,0,null,855,855,855,855,855,828,828,0,0,0,0,0,0,0,"July"]
[null,null,null,"Nursery Spaces - Min.",{"$f":"MIN(W4:W55)","v":4500},"Max.",{"$f":"MAX(W4:W55)","v":6000},null,null,null,null,null,null,null,null,null,"aug",30,1200,1164,{"$f":"(1-$E$14)*T5","v":981.64},30,6000,20151,null,null,0,0,0,0,0,0,null,855,855,855,855,855,855,828,0,0,0,0,0,0,0,"August"]
[null,null,null,"Finisher Spaces - Min.",{"$f":"MIN(X4:X55)","v":18043},"Max.",{"$f":"MAX(X4:X55)","v":22820},null,null,null,null,null,null,null,null,null,"aug",31,1200,1164,981.64,31,6000,20487,null,null,0,0,0,0,0,0,null,1045,855,855,855,855,855,855,0,0,0,0,0,0,0,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aug",32,1200,1164,981.64,32,6000,20796,null,null,0,0,0,0,0,0,null,1045,1045,855,855,855,855,855,0,0,0,0,0,0,0,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aug",33,1200,1164,803.16,33,6000,21105,null,null,0,0,0,0,0,0,null,1045,1045,1045,855,855,855,855,0,0,0,0,0,0,0,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aug",34,1200,1164,803.16,34,6000,21414,null,null,0,0,0,0,0,0,null,1067,1045,1045,1045,855,855,855,0,0,0,0,0,0,0,"August-Sept"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sept",35,1200,1164,803.16,35,6000,21723,null,null,0,0,0,0,0,0,null,1067,1067,1045,1045,1045,855,855,0,0,0,0,0,0,0,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sept",36,1200,1164,803.16,36,6000,22032,null,null,0,0,0,0,0,0,null,1067,1067,1067,1045,1045,1045,855,0,0,0,0,0,0,0,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sept",37,{"$f":"E10*F13","v":1100},{"$f":"(1-$F$14)*S34","v":1152},803.16,37,5900,22329,null,null,0,0,0,0,0,0,null,1067,1067,1067,1067,1045,1045,1045,0,0,0,0,0,0,0,"September"]
[null,null,null,{"$f":"D25*0.01*E18","v":46.400000000000006},{"$f":"E25*L18*0.01","v":128.25},null,null,null,null,null,null,null,null,null,null,null,"sept",38,{"$f":"S40","v":1100},{"$f":"(1-$F$14)*S35","v":1152},{"$f":"(1-$F$14)*T13","v":794.88},38,5800,22436,null,null,0,0,0,0,0,0,null,1067,1067,1067,1067,1067,1045,1045,0,0,0,0,0,0,0,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oct",39,{"$f":"S41","v":1100},1152,{"$f":"(1-$F$14)*T14","v":794.88},39,5700,22543,null,null,0,0,0,0,0,0,null,1067,1067,1067,1067,1067,1067,1045,0,0,0,0,0,0,0,"October"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oct",40,1100,1152,820.8,40,5600,22650,null,null,0,0,0,0,0,0,null,1164,1067,1067,1067,1067,1067,1067,0,0,0,0,0,0,0,"October"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oct",41,1100,1152,820.8,41,5500,22735,null,null,0,0,0,0,0,0,null,1164,1164,1067,1067,1067,1067,1067,0,0,0,0,0,0,0,"October"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oct",42,1100,1152,820.8,42,5500,22820,null,null,0,0,0,0,0,0,null,1164,1164,1164,1067,1067,1067,1067,0,0,0,0,0,0,0,"October"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nov",43,1100,1056,820.8,43,5500,22809,null,null,0,0,0,0,0,0,null,1164,1164,1164,1164,1067,1067,1067,0,0,0,0,0,0,0,"October-Nov"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nov",44,1100,1056,820.8,44,5500,22798,null,null,0,0,0,0,0,0,null,1164,1164,1164,1164,1164,1067,1067,0,0,0,0,0,0,0,"November"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nov",45,1100,1056,820.8,45,5500,22787,null,null,0,0,0,0,0,0,null,1164,1164,1164,1164,1164,1164,1067,0,0,0,0,0,0,0,"November"]
[null,"Week of Year",null,null,11,null,{"$f":"VLOOKUP(E49,R4:AV55,31)","v":"March"},null,"Pig Movement",null,"Pigs to Nursery",null,{"$f":"VLOOKUP(E49,R4:U55,2)","v":900},null,null,null,"nov",46,1100,1056,1003.1999999999999,46,5500,22776,null,null,0,0,0,0,0,0,null,1164,1164,1164,1164,1164,1164,1164,0,0,0,0,0,0,0,"November"]
[null,"Nursery Spaces Needed",null,null,{"$f":"VLOOKUP(E49,V4:X55,2)","v":4500},null,{"$f":"IF(P50>0,P50&\" spaces short\",P50*-1&\" spaces long\")","v":"500 spaces short"},null,"Week = ",{"$f":"E49","v":11},"Pigs to Finisher",null,{"$f":"VLOOKUP(E49,R4:U55,3)","v":828},null,null,{"$f":"E50-D28","v":500},"nov",47,1100,1056,1003.1999999999999,47,5500,22668,null,null,0,0,0,0,0,0,null,1164,1164,1164,1164,1164,1164,1164,0,0,0,0,0,0,0,"November"]
[null,"Finisher Spaces Needed",null,null,{"$f":"VLOOKUP(E49,V4:X55,3)","v":19260},null,{"$f":"IF(P51>0,P51&\" spaces short\",P51*-1&\" spaces long\")","v":"740 spaces long"},null,null,null,"Pigs to Market",null,{"$f":"VLOOKUP(E49,R4:U55,4)","v":1070.8800000000001},null,null,{"$f":"E51-E28","v":-740},"dec",48,1100,1056,1003.1999999999999,48,5500,22560,null,null,0,0,0,0,0,0,null,1164,1164,1164,1164,1164,1164,1164,0,0,0,0,0,0,0,"December"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dec",49,1100,1056,1024.32,49,5500,22452,null,null,0,0,0,0,0,0,null,1164,1164,1164,1164,1164,1164,1164,0,0,0,0,0,0,0,"December"]
[null,"WorkSheet - Change in Population",null,null,null,null,null,null,"WorkSheet - Direct Change in Space Allocation",null,null,null,null,null,null,null,"dec",50,1100,1056,1024.32,50,5500,22344,null,null,0,0,0,0,0,0,null,1152,1164,1164,1164,1164,1164,1164,0,0,0,0,0,0,0,"December"]
[null,null,null,"Nursery","Finisher",null,null,null,null,null,"Nursery","Finisher",null,null,null,null,"dec",51,{"$f":"E10*G13","v":900},{"$f":"(1-$G$14)*S48","v":1012},{"$f":"(1-$G$14)*T26","v":981.64},51,5300,22192,null,null,0,0,0,0,0,0,null,1152,1152,1164,1164,1164,1164,1164,0,0,0,0,0,0,0,"December"]
[null,"Proposed Head Count",null,4400,1800,"pigs",null,null,"Proposed Floor Space",null,4,9,"square feet ",null,null,null,"dec",52,{"$f":"S54","v":900},1012,{"$f":"(1-$G$14)*T27","v":981.64},52,5100,22040,null,null,0,0,0,0,0,0,null,1152,1152,1152,1164,1164,1164,1164,0,0,0,0,0,0,0,"December"]
[null,"Percent Overstocking",null,{"$f":"D55/L23-1","v":0.10000000000000009},{"$f":"E55/M23-1","v":-9.9999999999999978E-2},null,null,null,"Effective Change",null,{"$f":"IF(K55>4,4-L24,K55-L24)","v":0.5},{"$f":"IF(L55>9,9-M24,L55-M24)","v":1},"square feet ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Floor Space/Pig",null,{"$f":"IF(D55=\"\",\"\",L25/D55)","v":3.1818181818181817},{"$f":"IF(E55=\"\",\"\",M25/E55)","v":8.8888888888888893},"square feet "]
[null,"Effective Change",null,{"$f":"IF(D57>4,4-L24,D57-L24)","v":-0.31818181818181834},{"$f":"IF(E57>9,9-M24,E57-M24)","v":0.88888888888888928},"square feet ",null,null,null,null,null,{"$f":"IF(OR(K55=\"\",K55=0),(L56*M27+E19)*N15+E18,(L56*M27+E19)*N15+K62)","v":294.00900000000001}]
[null,null,null,null,{"$f":"IF(OR(D55=\"\",D55=0),(E58*M27+E19)*N15+E18,(E58*M27+E19)*N15+D62)","v":291.13422727272729},null,null,null,"New Head Count",null,{"$f":"L25/K55","v":3500},{"$f":"M25/L55","v":1777.7777777777778},"pigs"]
[null,"New Avg. Daily Gain",null,{"$f":"(D19+M27*D58)","v":1.0051958874458873},{"$f":"E58*M27+E19","v":1.7587669172932332},"lbs / day",null,null,"New Avg. Daily Gain",null,{"$f":"(D19+M27*K56)","v":1.0530595238095237},{"$f":"(L56*M27+E19)","v":1.7652669172932332},"lbs / day"]
[null,"New Feed to Gain",null,{"$f":"D58*M28+D20","v":2.0229090909090908},{"$f":"E58*M28+E20","v":2.3359999999999999},null,null,null,"New Feed to Gain",null,{"$f":"K56*M28+D20","v":1.964},{"$f":"L56*M28+E20","v":2.3279999999999998}]
[null,"New Market Wt.",null,{"$f":"(D19+M27*D58)*N14+D18","v":57.218227272727269},{"$f":"IF(E59>N19,N19,E59)","v":291.13422727272729},"lbs",null,null,"New Market Wt.",null,{"$f":"(D19+M27*K56)*N14+D18","v":59.228499999999997},{"$f":"IF(L58>N19,N19,L58)","v":294.00900000000001},"lbs"]
[null,"Change in Days Fed",null,0,{"$f":"IF(E62<L19,(L19-E62)/E60,IF(E62<E59,(E62-E59)/E60,0))","v":0},"days",null,null,"Change in Days Fed",null,0,{"$f":"IF(L62<L19,(L19-L62)/L60,IF(L62<L58,(L62-L58)/L60,0))","v":0},"days"]
[]
[null,"Floor Space Impact for 100 pigs",null,null,null,null,null,null,"Floor Space Impact for 100 pigs"]
[null,"Weight Value Change",null,{"$f":"((D62-E18)*D26*0.01)*100","v":-78.177272727273106},{"$f":"((E62-L18)*E26*0.01)*100","v":306.71136363636435},null,null,null,"Weight Value Change",null,{"$f":"((K62-E18)*D26*0.01)*100","v":122.84999999999968},{"$f":"((L62-L18)*E26*0.01)*100","v":450.45000000000073}]
[null,"Pen Charge Change",null,{"$f":"D63*D23*100","v":0},{"$f":"E63*E23*100","v":0},null,null,null,"Pen Charge Change",null,{"$f":"K63*D23*100","v":0},{"$f":"L63*E23*100","v":0}]
[null,"Feed $ Change",null,{"$f":"(D61-D20)*(D24/2000)*(D62-D18)*100","v":9.6718120661156419},{"$f":"IF(OR(D55=\"\",D55=0),(E61-E20)*(E24/2000)*(E62-E18)*100,(E61-E20)*(E24/2000)*(E62-D62)*100)","v":-134.73561600000014},null,null,null,"Feed $ Change",null,{"$f":"(K61-D20)*(D24/2000)*(K62-D18)*100","v":-15.922260000000014},{"$f":"IF(OR(K55=\"\",K55=0),(L61-E20)*(E24/2000)*(L62-E18)*100,(L61-E20)*(E24/2000)*(L62-K62)*100)","v":-152.13776400000015}]
[null,"Livability Change",null,{"$f":"(M30*D58)*100*D41","v":-20.669090909090922},{"$f":"(N30*E58)*100*E41","v":159.60000000000008},null,null,null,"Livability Change",null,{"$f":"(M30*K56)*100*D41","v":32.480000000000004},{"$f":"(N30*L56)*100*E41","v":179.55}]
[null,"Income Change",null,{"$f":"D66+D67+D68+D69","v":-89.174551570248383},{"$f":"E66+E67+E68+E69","v":331.57574763636433},"$/100 pigs",null,null,"Income Change",null,{"$f":"K66+K67+K68+K69","v":139.40773999999968},{"$f":"L66+L67+L68+L69","v":477.86223600000056},"$/100 pigs"]
[null,"New Spaces per Sow",null,{"$f":"(D55/L23*D28)/G10","v":1.9461538461538459},{"$f":"(E55/M23*E28)/G10","v":7.9615384615384608},null,null,null,"New Spaces per Sow",null,{"$f":"(K59/L23*D28)/G10","v":1.5480769230769229},{"$f":"(L59/M23*E28)/G10","v":7.8632478632478628}]
[null,"Income Change per Turn of Building",null,null,null,null,null,null,"Income Change per Turn of Building"]
[null,"Current Gross Income",null,{"$f":"E18*L23*(1-H14)*D26*0.01","v":220400},{"$f":"M23*(1-H15)*L18*E26*0.01","v":270037.5},null,null,null,"Current Gross Income",null,{"$f":"E18*L23*(1-H14)*D26*0.01","v":220400},{"$f":"M23*(1-H15)*L18*E26*0.01","v":270037.5}]
[null,"Current Cost",null,{"$f":"E18*L23*(1-H14)*D25*0.01","v":176320},{"$f":"M23*(1-H15)*L18*E25*0.01","v":243033.75},null,null,null,"Current Cost",null,{"$f":"E18*L23*(1-H14)*D25*0.01","v":176320},{"$f":"M23*(1-H15)*L18*E25*0.01","v":243033.75}]
[null,"Current Net / Turn",null,{"$f":"D73-D74","v":44080},{"$f":"E73-E74","v":27003.75},null,null,null,"Current Net / Turn",null,{"$f":"K73-K74","v":44080},{"$f":"L73-L74","v":27003.75}]
[null,"Current Pigs Sold",null,{"$f":"L23*(1-H14)","v":3800},{"$f":"M23*(1-H15)","v":1895},null,null,null,"Current Pigs Sold",null,{"$f":"L23*(1-H14)","v":3800},{"$f":"M23*(1-H15)","v":1895}]
[null,null,null,{"$f":"D75/D76","v":11.6},{"$f":"E75/E76","v":14.25},null,null,null,null,null,{"$f":"K75/K76","v":11.6},{"$f":"L75/L76","v":14.25}]
[null,"Proposed Net / Turn",null,{"$f":"(D77+D70*0.01)*D79","v":44550.621956471383},{"$f":"(E77+E70*0.01)*E79","v":30351.872343408741},null,null,null,"Proposed Net / Turn",null,{"$f":"(K77+K70*0.01)*K79","v":43523.662251299989},{"$f":"(L77+L70*0.01)*L79","v":32526.258487360014}]
[null,"Proposed Pigs Sold",null,{"$f":"D55*(1-H14+M30*D58)","v":4160.3999999999996},{"$f":"E55*(1-H15+N30*E58)","v":1727.9},null,null,null,"Proposed Pigs Sold",null,{"$f":"K59*(1-H14+M30*K56)","v":3349.5},{"$f":"L59*(1-H15+N30*L56)","v":1709.3333333333335}]
[]
[null,"Change In Pig Numbers (new - old) per Turn",null,null,null,null,null,null,"Change In Pig Numbers (new - old) per Turn"]
[null,"     Entering Building",null,{"$f":"D55-L23","v":400},{"$f":"E55-M23","v":-200},null,null,null,"     Entering Building",null,{"$f":"K59-L23","v":-500},{"$f":"L59-M23","v":-222.22222222222217}]
[null,"     Marketed from Building",null,{"$f":"D79-D76","v":360.39999999999964},{"$f":"E79-E76","v":-167.09999999999991},null,null,null,"     Marketed from Building",null,{"$f":"K79-K76","v":-450.5},{"$f":"L79-L76","v":-185.66666666666652}]
[]
[null,"Surplus Pigs",null,{"$f":"IF(D82<0,D82,0)*-1","v":0},{"$f":"IF(E82<0,E82,0)*-1","v":200},{"$f":"D78/D79","v":10.708254484297516},{"$f":"E78/E79","v":17.565757476363643},null,"Surplus Pigs",null,{"$f":"IF(K82<0,K82,0)*-1","v":500},{"$f":"IF(L82<0,L82,0)*-1","v":222.22222222222217},{"$f":"K78/K79","v":12.994077399999997},{"$f":"L78/L79","v":19.028622360000007}]
[null,"New Building Payoff Time",null,{"$f":"IF(D85=0,0,L22/((52/D27)*D83*-1*F85))","v":0},{"$f":"IF(E85=0,0,M22/((52/E27)*E83*-1*G85))","v":13.758548493290911},"years",null,null,"New Building Payoff Time",null,{"$f":"IF(K85=0,0,L22/((52/D27)*K83*-1*M85))","v":4.2707068738467076},{"$f":"IF(L85=0,0,M22/((52/E27)*E83*-1*G85))","v":13.758548493290911},"years"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"march"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"april"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"may"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"june"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"july"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"august"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"september"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oct"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nov"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dec"]

{"sheet":"open1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"open2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}