{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tool"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":15,"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":"Tool","index":0,"n_rows":202,"n_cols":26,"rows_kept":202,"cut":false,"hidden":false,"merged":[[0,2,0,7],[2,2,2,3],[5,2,5,3],[3,2,3,3],[6,2,6,3],[27,5,27,6],[28,5,29,5],[28,6,29,6],[20,3,20,7],[1,2,1,7],[7,2,7,3],[8,2,8,3],[10,2,10,3],[4,2,4,3]]}
[null,null,"Herd Structure Simulation (HSS) Model"]
[null,null,"Victor E. Cabrera (University of Wisconsin-Extension) and Pierre Meyer (Alltech, Inc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CowCI-8","v":5},"CowPreg"]
[null,null,"Time to First Calving",null,24,"months",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"hfrcalving-8","v":16},"hfrPreg"]
[null,null,"Heifer Calf Born",null,0.47,"of all born",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E6/hfrcalving","v":6.4583333333333333E-3},"mo"]
[null,null,"Stillbirth Rate",null,7.0000000000000007E-2,"die at calving or shortly after",null,null,null,null,null,null,null,null,null,null,"Heifers","Cows",null,null,{"$f":"E7/12","v":2.4999999999999998E-2},"mo",null,"Heifers Calving",null,{"$f":"VLOOKUP(hfrcalving,O12:S41,5)","v":60.454338767841683}]
[null,null,"Calves and Heifers Culled",null,0.155,"do not make it to 1st lactation",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S12:S41)","v":1676.6521225883062},{"$f":"SUM(S43:S202)","v":1938.1865509621614},null,null,null,null,null,"Cows Calving",null,{"$f":"SUM(Z12:Z20)","v":123.2412598804076}]
[null,null,"Cow Replacement Rate",null,0.3,"per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Calving",null,{"$f":"SUM(Z5:Z6)","v":183.69559864824927}]
[null,null,"Cow Calving Interval",null,13,"months"]
[null,null,"Number of Adult Cows",null,1000,"count"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"month",null,620,null,"m+1",{"$f":"S10+1","v":621}]
[null,null,"Herd Projected at",null,120,"months",null,null,null,null,null,null,null,"Heifers","Age (m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"IF(U12=1,IF(O12<hfrpreg,\"Open\",\"Pregnant\"),\"\")","v":"Open"},null,79.392422924350143,null,{"$f":"IF(O12<=hfrcalving,1,0)","v":1},{"$f":"Z7*(1-hfrcull)*(fmlcalv-E5/2)*U12","v":79.391515589535999},null,null,1,{"$f":"VLOOKUP(CowCI,O43:S58,5)","v":40.910685071339167}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"Open",null,78.878664905680907,null,1,{"$f":"S12*(1-hfrcull)*U13","v":78.879680192963718},null,null,2,{"$f":"VLOOKUP(CowCI,O61:S76,5)","v":27.695860906530211}]
[null,null,"Heifers",null,null,null,null,null,null,null,null,null,null,null,3,null,"Open",null,78.370648937607967,null,1,78.369240194831718,null,null,3,{"$f":"VLOOKUP(CowCI,O79:S94,5)","v":18.749693983022627}]
[null,null,"≤ 2 months old",{"$f":"SUM(S12:S13)","v":158.27108783003104},null,null,null,null,null,null,null,null,null,null,4,null,"Open",null,77.60025692884571,null,1,77.864505163219249,null,null,4,{"$f":"VLOOKUP(CowCI,O97:S112,5)","v":12.709115213691375}]
[null,null,"3 to 6 months old",{"$f":"SUM(S14:S17)","v":308.366587862958},null,null,null,null,null,null,null,null,null,null,5,null,"Open",null,77.100307305924076,null,1,77.099088602846919,null,null,5,{"$f":"VLOOKUP(CowCI,O115:S130,5)","v":8.5933306559069038}]
[null,null,"≥ 7 months non pregnant",{"$f":"D19-D18-D15-D16","v":634.80075436540244},null,null,null,null,null,null,null,null,null,null,6,null,"Open",null,75.29537469058026,null,1,76.60236782123998,null,null,6,{"$f":"VLOOKUP(CowCI,O133:S148,5)","v":5.8625275035249675}]
[null,null,"pregnant",{"$f":"SUMIF(Q12:Q41,\"pregnant\",S12:S41)","v":575.21369252991462},null,null,null,null,null,null,null,null,null,null,7,null,"Open",null,74.809898790724532,null,1,74.809092062370269,null,null,7,{"$f":"VLOOKUP(CowCI,O151:S166,5)","v":3.8975849780599821}]
[null,null,"Total",{"$f":"Q6","v":1676.6521225883062},null,null,null,null,null,null,null,null,null,null,8,null,"Open",null,72.339594499793279,null,1,74.326751527701106,null,null,8,{"$f":"VLOOKUP(CowCI,O169:S184,5)","v":2.804495968063367}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"Open",null,71.872868151413144,null,1,71.872401285315448,null,null,9,{"$f":"VLOOKUP(CowCI,O187:S202,5)","v":2.0179656002690054}]
[null,null,null,"Lactation",null,null,null,null,null,null,null,null,null,null,10,null,"Open",null,70.468122125363664,null,1,71.408689211268594]
[null,null,"Cows","1st","2nd ","3rd","Later","All",null,null,null,null,null,null,11,null,"Open",null,70.01329676389183,null,1,70.013015503304018]
[null,null,"Non-pregnant",{"$f":"SUMIF(Q43:Q58,\"Open\",S43:S58)","v":227.07785290305873},{"$f":"SUMIF(Q61:Q76,\"Open\",S61:S76)","v":153.66842448002936},{"$f":"SUMIF(Q79:Q94,\"Open\",S79:S94)","v":104.03112259439219},{"$f":"SUMIF(Q97:Q202,\"Open\",S97:S202)","v":197.63915128740049},{"$f":"SUM(D23:G23)","v":682.41655126488081},null,null,null,null,null,null,12,null,"Open",null,69.494591711442055,null,1,69.561127555625035]
[null,null,"Pregnant milking",{"$f":"SUMPRODUCT(--(P43:P58=\"Milking\"),--(Q43:Q58=\"Pregnant\"),S43:S58)","v":336.71138943302157},{"$f":"SUMPRODUCT(--(P61:P76=\"Milking\"),--(Q61:Q76=\"Pregnant\"),S61:S76)","v":226.91454569542864},{"$f":"SUMPRODUCT(--(P79:P94=\"Milking\"),--(Q79:Q94=\"Pregnant\"),S79:S94)","v":152.9898486591658},{"$f":"SUMPRODUCT(--(P97:P202=\"Milking\"),--(Q97:Q202=\"Pregnant\"),S97:S202)","v":289.51108840211981},{"$f":"SUM(D24:G24)","v":1006.1268721897359},null,null,null,null,null,null,13,null,"Open",null,69.04546068874258,null,1,69.045772473305661]
[null,null,"Dry",{"$f":"SUMIF(P43:P58,\"Dry\",S43:S58)","v":82.87032803311871},{"$f":"SUMIF(P61:P76,\"Dry\",S61:S76)","v":56.101890704242777},{"$f":"SUMIF(P79:P94,\"Dry\",S79:S94)","v":37.980200865499029},{"$f":"SUMIF(P97:P202,\"Dry\",S97:S202)","v":72.690707904683649},{"$f":"SUM(D25:G25)","v":249.64312750754416},null,null,null,null,null,null,14,null,"Open",null,68.600514608007245,null,1,68.599542088461121]
[null,null,"Total",{"$f":"SUM(D23:D25)","v":646.65957036919895},{"$f":"SUM(E23:E25)","v":436.68486087970075},{"$f":"SUM(F23:F25)","v":295.00117211905706},{"$f":"SUM(G23:G25)","v":559.84094759420395},{"$f":"SUM(D26:G26)","v":1938.1865509621607},null,null,null,null,null,null,15,null,"Open",null,68.156407026023842,null,1,68.157469617830529]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,"Pregnant",null,67.717478768374747,null,1,67.71623023064744]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,null,"Pregnant",null,66.943154009797041,null,1,67.28013671799566]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,"Pregnant",null,66.51178035051268,null,1,66.5108128068171]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,null,"Pregnant",null,64.651461585063956,null,1,66.08222510241562]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,"Pregnant",null,64.234531705022505,null,1,64.233920895660418]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,null,"Pregnant",null,62.127375901774002,null,1,63.8196836877609]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,null,"Pregnant",null,61.726480026801767,null,1,61.726136599075048]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,null,"Pregnant",null,60.847091414726172,null,1,61.327829843295341]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,"Pregnant",null,60.454338767841683,null,1,60.454120616006065]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,"",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,null,"",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,null,"",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,null,"",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,null,"",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,"",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1st Lact","MIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(U43=1,IF(O43<CowCI-1,\"Milking\",\"Dry\"),\"\")","v":"Milking"},{"$f":"IF(U43=1,IF(O43<CowPreg,\"Open\",\"Pregnant\"),\"\")","v":"Open"},null,58.943309811351867,null,{"$f":"IF(O43<=CowCI,1,0)","v":1},{"$f":"Z5*(1-cowcull)*U43","v":58.942980298645637}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Milking","Open",null,57.469320804115718,null,1,{"$f":"S43*(1-cowcull)*U44","v":57.469727066068067}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Milking","Open",null,56.03352503586126,null,1,56.032587784012826]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Milking","Open",null,54.631697251729882,null,1,54.632686909964725]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Milking","Pregnant",null,53.266870009582561,null,1,53.265904820436631]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Milking","Pregnant",null,51.551223144934532,null,1,51.935198259342997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Milking","Pregnant",null,50.263104637949695,null,1,50.262442566311165]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Milking","Pregnant",null,47.696708064995114,null,1,49.006527022000952]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Milking","Pregnant",null,46.504674622226723,null,1,46.504290363370238]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Milking","Pregnant",null,44.267646826725695,null,1,45.342057756671053]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Milking","Pregnant",null,43.161162126607245,null,1,43.160955656057553]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dry","Pregnant",null,41.959642961779537,null,1,42.082133073442066]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Dry","Pregnant",null,40.910685071339167,null,1,40.91065188773505]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","",null,0,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd Lact","MIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(U61=1,IF(O61<CowCI-1,\"Milking\",\"Dry\"),\"\")","v":"Milking"},{"$f":"IF(U61=1,IF(O61<CowPreg,\"Open\",\"Pregnant\"),\"\")","v":"Open"},null,39.888264413934991,null,{"$f":"IF(O61<=CowCI,1,0)","v":1},{"$f":"VLOOKUP(CowCI,O43:S58,5)*(1-cowcull)*U61","v":39.887917944555689}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Milking","Open",null,38.890663947616687,null,1,{"$f":"S61*(1-cowcull)*U62","v":38.891057803586612}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Milking","Open",null,37.919108854047408,null,1,37.91839734892627]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Milking","Open",null,36.970387264430265,null,1,36.971131132696222]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Milking","Pregnant",null,36.046743752747261,null,1,36.046127582819508]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Milking","Pregnant",null,34.761962764953765,null,1,35.14557515892858]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Milking","Pregnant",null,33.893314996639283,null,1,33.892913695829918]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Milking","Pregnant",null,31.998259984456595,null,1,33.045982121723299]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Milking","Pregnant",null,31.1985230996656,null,1,31.19830348484518]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Milking","Pregnant",null,29.881326122350046,null,1,30.41856002217396]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Milking","Pregnant",null,29.134414974616078,null,1,29.134292969291295]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dry","Pregnant",null,28.406029797712566,null,1,28.406054600250677]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Dry","Pregnant",null,27.695860906530211,null,1,27.695879052769751]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","",null,0,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3rd Lact","MIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(U79=1,IF(O79<CowCI-1,\"Milking\",\"Dry\"),\"\")","v":"Milking"},{"$f":"IF(U79=1,IF(O79<CowPreg,\"Open\",\"Pregnant\"),\"\")","v":"Open"},null,27.003794583769942,null,{"$f":"IF(O79<=CowCI,1,0)","v":1},{"$f":"VLOOKUP(CowCI,O61:S76,5)*(1-cowcull)*U79","v":27.003464383866955}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Milking","Open",null,26.328340202008537,null,1,{"$f":"S79*(1-cowcull)*U80","v":26.328699719175692}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Milking","Open",null,25.670642207623857,null,1,25.670131696958322]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Milking","Open",null,25.028345600989855,null,1,25.028876152433259]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Milking","Pregnant",null,24.403018390647588,null,1,24.402636960965108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Milking","Pregnant",null,23.409573721077162,null,1,23.792942930881399]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Milking","Pregnant",null,22.82457520300213,null,1,22.824334378050231]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Milking","Pregnant",null,21.468231588335087,null,1,22.253960822927077]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Milking","Pregnant",null,20.931649345972925,null,1,20.931525798626708]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Milking","Pregnant",null,20.22922801515497,null,1,20.408358112323601]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Milking","Pregnant",null,19.723572394975946,null,1,19.723497314776093]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dry","Pregnant",null,19.230506882476405,null,1,19.230483085101547]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Dry","Pregnant",null,18.749693983022627,null,1,18.749744210414494]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","",null,0,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4th Lact","MIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(U97=1,IF(O97<CowCI-1,\"Milking\",\"Dry\"),\"\")","v":"Milking"},{"$f":"IF(U97=1,IF(O97<CowPreg,\"Open\",\"Pregnant\"),\"\")","v":"Open"},null,18.281245628184198,null,{"$f":"IF(O97<=CowCI,1,0)","v":1},{"$f":"VLOOKUP(CowCI,O79:S94,5)*(1-cowcull)*U97","v":18.28095163344706}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Milking","Open",null,17.823902468807351,null,1,{"$f":"S97*(1-cowcull)*U98","v":17.824214487479594}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Milking","Open",null,17.378648261815499,null,1,17.378304907087166]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Milking","Open",null,16.94382634960601,null,1,16.944182055270112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Milking","Pregnant",null,16.520465419019889,null,1,16.520230690865858]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Milking","Pregnant",null,15.724236573306259,null,1,16.10745378354439]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Milking","Pregnant",null,15.331271176938342,null,1,15.331130658973603]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Milking","Pregnant",null,14.424190703625808,null,1,14.947989397514883]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Milking","Pregnant",null,14.0636545734497,null,1,14.063585936035162]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Milking","Pregnant",null,13.711992121985279,null,1,13.712063209113458]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Milking","Pregnant",null,13.369239244060577,null,1,13.369192318935648]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dry","Pregnant",null,13.035061220281655,null,1,13.035008262959062]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Dry","Pregnant",null,12.709115213691375,null,1,12.709184689774613]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","",null,0,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5th Lact","MIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(U115=1,IF(O115<CowCI-1,\"Milking\",\"Dry\"),\"\")","v":"Milking"},{"$f":"IF(U115=1,IF(O115<CowPreg,\"Open\",\"Pregnant\"),\"\")","v":"Open"},null,12.391631832460597,null,{"$f":"IF(O115<=CowCI,1,0)","v":1},{"$f":"VLOOKUP(CowCI,O97:S112,5)*(1-cowcull)*U115","v":12.39138733334909}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Milking","Open",null,12.081585289599877,null,1,{"$f":"S115*(1-cowcull)*U116","v":12.081841036649081}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Milking","Open",null,11.779760237792805,null,1,11.779545657359879]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Milking","Open",null,11.485043901971547,null,1,11.485266231847985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Milking","Pregnant",null,11.198064523525677,null,1,11.197917804422259]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Milking","Pregnant",null,10.534986917101147,null,1,10.918112910437534]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Milking","Pregnant",null,10.271692560970841,null,1,10.271612244173618]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Milking","Pregnant",null,9.7529905020826018,null,1,10.014900246946571]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Milking","Pregnant",null,9.5092069219792421,null,1,9.5091657395305358]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Milking","Pregnant",null,9.2714340966528663,null,1,9.2714767489297607]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Milking","Pregnant",null,9.0396763993114906,null,1,9.0396482442365453]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dry","Pregnant",null,8.8137568866164777,null,1,8.8136844893287023]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Dry","Pregnant",null,8.5933306559069038,null,1,8.5934129644510655]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","",null,0,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"6th Lact","MIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(U133=1,IF(O133<CowCI-1,\"Milking\",\"Dry\"),\"\")","v":"Milking"},{"$f":"IF(U133=1,IF(O133<CowPreg,\"Open\",\"Pregnant\"),\"\")","v":"Open"},null,8.3786857477652852,null,{"$f":"IF(O133<=CowCI,1,0)","v":1},{"$f":"VLOOKUP(CowCI,O115:S130,5)*(1-cowcull)*U133","v":8.3784973895092314}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Milking","Open",null,8.1690235152090196,null,1,{"$f":"S133*(1-cowcull)*U134","v":8.169218604071153}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Milking","Open",null,7.9649266582314429,null,1,7.9647979273287941]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Milking","Open",null,7.7656700687468199,null,1,7.7658034917756567]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Milking","Pregnant",null,7.5716163733199018,null,1,7.5715283170281493]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Milking","Pregnant",null,6.9992608068280315,null,1,7.3823259639869043]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Milking","Pregnant",null,6.8243194450559121,null,1,6.8242792866573305]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Milking","Pregnant",null,6.6536698672517627,null,1,6.6537114589295143]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Milking","Pregnant",null,6.4873555755362808,null,1,6.487328120570468]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Milking","Pregnant",null,6.3251432512966259,null,1,6.3251716861478737]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Milking","Pregnant",null,6.1670334400641611,null,1,6.1670146700142103]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dry","Pregnant",null,6.0129397213328968,null,1,6.0128576040625568]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Dry","Pregnant",null,5.8625275035249675,null,1,5.862616228299574]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","",null,0,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"7th Lact","MIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(U151=1,IF(O151<CowCI-1,\"Milking\",\"Dry\"),\"\")","v":"Milking"},{"$f":"IF(U151=1,IF(O151<CowPreg,\"Open\",\"Pregnant\"),\"\")","v":"Open"},null,5.7160898881075362,null,{"$f":"IF(O151<=CowCI,1,0)","v":1},{"$f":"VLOOKUP(CowCI,O133:S148,5)*(1-cowcull)*U151","v":5.7159643159368434}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Milking","Open",null,5.5730575967939,null,1,{"$f":"S151*(1-cowcull)*U152","v":5.5731876409048473}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Milking","Open",null,5.4338169630115507,null,1,5.4337311568740523]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Milking","Open",null,5.2978825538149259,null,1,5.2979715389362614]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Milking","Pregnant",null,5.1654942296885897,null,1,5.1654354899695525]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Milking","Pregnant",null,4.653322134876281,null,1,5.0363568739463744]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Milking","Pregnant",null,4.5370091607036382,null,1,4.5369890815043741]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Milking","Pregnant",null,4.4235631358471776,null,1,4.4235839316860472]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Milking","Pregnant",null,4.3129877849339016,null,1,4.3129740574509983]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Milking","Pregnant",null,4.2051488728849407,null,1,4.2051630903105544]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Milking","Pregnant",null,4.1000295360877885,null,1,4.1000201510628171]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dry","Pregnant",null,3.9976206349385235,null,1,3.9975287976855935]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Dry","Pregnant",null,3.8975849780599821,null,1,3.8976801190650603]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","",null,0,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"8th Lact","MIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(U169=1,IF(O169<CowCI-1,\"Milking\",\"Dry\"),\"\")","v":"Milking"},{"$f":"IF(U169=1,IF(O169<CowPreg,\"Open\",\"Pregnant\"),\"\")","v":"Open"},null,3.800208139693841,null,{"$f":"IF(O169<=CowCI,1,0)","v":1},{"$f":"VLOOKUP(CowCI,O151:S166,5)*(1-cowcull)*U169","v":3.8001453536084826}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Milking","Open",null,3.7051379368417083,null,1,{"$f":"S169*(1-cowcull)*U170","v":3.7052029362014949}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Milking","Open",null,3.6125523697930029,null,1,3.6125094884206654]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Milking","Open",null,3.5221940679874932,null,1,3.5222385605481779]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Milking","Pregnant",null,3.4341685861473223,null,1,3.4341392162878059]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Milking","Pregnant",null,3.3482839534049025,null,1,3.3483143714936392]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Milking","Pregnant",null,3.2645969337690741,null,1,3.2645768545697798]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Milking","Pregnant",null,3.1829612145859585,null,1,3.1829820104248472]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Milking","Pregnant",null,3.1034009117042296,null,1,3.1033871842213094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Milking","Pregnant",null,3.0258016714859757,null,1,3.025815888911624]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Milking","Pregnant",null,2.9501660147238349,null,1,2.9501566296988262]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dry","Pregnant",null,2.8765037016086481,null,1,2.876411864355739]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Dry","Pregnant",null,2.804495968063367,null,1,2.8045911090684319]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","",null,0,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"9th Lact","MIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(U187=1,IF(O187<CowCI-1,\"Milking\",\"Dry\"),\"\")","v":"Milking"},{"$f":"IF(U187=1,IF(O187<CowPreg,\"Open\",\"Pregnant\"),\"\")","v":"Open"},null,2.7344463549471509,null,{"$f":"IF(O187<=CowCI,1,0)","v":1},{"$f":"VLOOKUP(CowCI,O169:S184,5)*(1-cowcull)*U187","v":2.7343835688617828}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Milking","Open",null,2.6660201167724877,null,1,{"$f":"S187*(1-cowcull)*U188","v":2.6660851960734719}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Milking","Open",null,2.5994125731681543,null,1,2.5993696138531757]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Milking","Open",null,2.5343827662782825,null,1,2.5344272588389503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Milking","Pregnant",null,2.471052566980835,null,1,2.4710231971213252]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Milking","Pregnant",null,2.4092458347175851,null,1,2.4092762528063139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Milking","Pregnant",null,2.3490347680489334,null,1,2.3490146888496453]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Milking","Pregnant",null,2.2902881030088253,null,1,2.2903088988477101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Milking","Pregnant",null,2.233044627916525,null,1,2.2330309004336049]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Milking","Pregnant",null,2.177204294792964,null,1,2.1772185122186118]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Milking","Pregnant",null,2.1227835724481414,null,1,2.1227741874231398]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dry","Pregnant",null,2.0698058203898437,null,1,2.0697139831369378]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Dry","Pregnant",null,2.0179656002690054,null,1,2.0180606748800978]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","",null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","",null,0,null,0,0]