{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input data","Analysis","Results"],"not_rendered":{"charts":4,"images":4,"macros":1,"external_links":0,"defined_names":62,"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":"Input data","index":0,"n_rows":86,"n_cols":2,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["ID","AFC, mo"]
[5484,21.57377049180328]
[5525,22.262295081967213]
[5583,22.295081967213115]
[5374,22.327868852459016]
[5567,22.393442622950818]
[5500,22.491803278688526]
[5655,22.491803278688526]
[5659,22.491803278688526]
[5550,22.524590163934427]
[5454,22.557377049180328]
[5491,22.590163934426229]
[5386,22.655737704918032]
[5559,22.688524590163933]
[5618,22.688524590163933]
[5654,22.688524590163933]
[5455,22.721311475409838]
[5515,22.721311475409838]
[5554,22.721311475409838]
[5584,22.721311475409838]
[5444,22.819672131147541]
[5517,22.819672131147541]
[5619,22.852459016393443]
[5365,22.918032786885245]
[5502,22.918032786885245]
[5459,22.950819672131146]
[5521,22.950819672131146]
[5446,22.983606557377048]
[5435,23.049180327868854]
[5510,23.049180327868854]
[5493,23.081967213114755]
[5513,23.147540983606557]
[5391,23.180327868852459]
[5543,23.21311475409836]
[5572,23.21311475409836]
[5482,23.245901639344261]
[5538,23.245901639344261]
[5637,23.245901639344261]
[5497,23.278688524590162]
[5445,23.344262295081968]
[5469,23.344262295081968]
[5544,23.442622950819672]
[5641,23.442622950819672]
[5421,23.508196721311474]
[5380,23.57377049180328]
[5403,23.606557377049182]
[5539,23.606557377049182]
[5613,23.606557377049182]
[5632,23.606557377049182]
[5660,23.606557377049182]
[5529,23.639344262295083]
[5424,23.672131147540984]
[5617,23.770491803278688]
[5396,23.803278688524589]
[5443,23.868852459016395]
[5471,23.868852459016395]
[5571,23.868852459016395]
[5573,23.901639344262296]
[5458,23.934426229508198]
[5557,23.934426229508198]
[5647,23.934426229508198]
[5429,24]
[5466,24.032786885245901]
[5477,24.065573770491802]
[5622,24.098360655737704]
[5492,24.16393442622951]
[5579,24.229508196721312]
[5395,24.295081967213115]
[5614,24.327868852459016]
[5540,24.393442622950818]
[5367,24.42622950819672]
[5523,24.655737704918032]
[5436,24.688524590163933]
[5595,24.754098360655739]
[5461,24.78688524590164]
[5629,24.78688524590164]
[5638,24.78688524590164]
[5490,24.950819672131146]
[5358,25.344262295081968]
[5503,25.442622950819672]
[5408,25.57377049180328]
[5393,25.934426229508198]
[5483,26.393442622950818]
[5366,26.524590163934427]
[5434,27.081967213114755]
[5601,27.147540983606557]

{"sheet":"Analysis","index":1,"n_rows":86,"n_cols":14,"rows_kept":86,"cut":false,"hidden":true,"merged":[[0,0,1,3]]}
["Heifer Management Report©",null,null,null,null,null,null,"Herd ",null,"Herd 1"]
[null,null,null,null,null,null,null,"Address"]
[null,null,"Breed ",{"$f":"Results!D3","v":"Holstein"},null,null,null,"City, Zip"]
[null,null,null,null,null,null,null,"email"]
[]
[null,"Developed by Patrick C. Hoffman, Department of Dairy Science, University of Wisconsin-Madison"]
["Calving Age (Averages and Variance)"]
[null,null,"Your Herd","Goals"]
["Summary Statistics"]
[null,"Average age @ first calving, mo",{"$f":"AVERAGE('Input data'!B:B)","v":23.665188042430092},"23-24 mo"]
[null,"Minimum calving age, mo",{"$f":"MIN('Input data'!B:B)","v":21.57377049180328},"na"]
[null,"Maximum calving age, mo",{"$f":"MAX('Input data'!B:B)","v":27.147540983606557},"na"]
[null,"Heifers calving/year, n",{"$f":"COUNT('Input data'!B:B)","v":85},"na"]
[null,"Calving age deviation, mo",{"$f":"STDEV('Input data'!B:B)","v":1.0964667759601892},"< 1.7 mo"]
[null,"Kurtosis",{"$f":"KURT('Input data'!B:B)","v":1.5659348694667776},"na"]
[null,"Skewness",{"$f":"SKEW('Input data'!B:B)","v":1.1684662648214135},"> 1.5"]
[]
["Range and Variance"]
[null,"Youngest calving age (typical), mo",{"$f":"(C10)-(C14*(2-C16/2))","v":22.112846709613205},"> 21 mo"]
[null,"Oldest calving age (typical), mo",{"$f":"(C10+(C14*2+C16/2))","v":26.442354726761177},"< 28 mo"]
[null,"Calving age range (typical), mo",{"$f":"(C20-C19)","v":4.3295080171479725},"< 6.0"]
[null,"Days on feed variance, d",{"$f":"(C21*30.5)","v":132.04999452301317},"< 200"]
[null,"Calving body weight variance, lbs",{"$f":"(C22*C50)","v":224.48499068912238},"< 325"]
[]
["Breeding Efficiency "]
[]
[null,"True heifer pregnancy rate©, %/mo",{"$f":"$D$83","v":49.839810935010654},"> 42.5"]
[null,"Average pregnancy age, mo",{"$f":"C10-9","v":14.665188042430092},"14.0-14.5"]
[null,"First (start) breeding age, mo",{"$f":"$D$85","v":12.766523049623327},"12.5-13.0"]
[]
["Rearing Cost"]
[]
[null,"Excess rearing days, days/heifer",{"$f":"(C35/C13)","v":0},"0 days"]
[null,"Excess rearing cost, $$/heifer",{"$f":"(C33*2.25)","v":0},"0 $$"]
[null,"Excess herd rearing days, days/herd",{"$f":"IF(C49<0,0,C49)","v":0},"0 days"]
[null,"Excess rearing cost,  $$/herd",{"$f":"(C35*2.25)","v":0},"0 $$"]
[]
["Nutrient management"]
[]
[null,"Excess manure production, tons/year",{"$f":"(C35*25)/2000","v":0},"0 tons"]
[null,"Excess P production , lbs/year",{"$f":"(C40*0.35*0.006)*2000","v":0},"0 lbs"]
[]
[null,"© Copyright: Patrick C. Hoffman 12/3/2012"]
[]
[]
[]
[null,"Target Calving Age Variance DOF",{"$f":"(C10-23.5)*(30.5)*(C13)","v":428.25000000001353}]
[null,"SD Variance DOF",{"$f":"(C22-180)*C13/2","v":-2037.8752327719403}]
[null,"Excess herd days on feed, d/year",{"$f":"(C47+C48)/2","v":-804.81261638596334}]
[null,"Breed ADG",{"$f":"IF(D3=\"milking shorthorn\",1.6,IF(D3=\"guernsey\",1.5,IF(D3=\"jersey\",1.3,IF(D3=\"cross\",1.5,IF(D3=\"arshire\",1.5,1.7)))))","v":1.7},null,null,null,null,null,null,null,{"$f":"COUNTIF(H53:H69,\">\"&0)-1","v":7},{"$f":"COUNTIF(H53:H69,\"=\"&100)","v":2},{"$f":"IF(L50=0,0,L50-1)","v":1},{"$f":"K50-M50","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"AFC, mo","Frequency","Frequency%","Freq Goal, %","Open Heifers, n","Preg Month","% Open x mo","Open % Goal",null,"x","y"]
[null,19,{"$f":"COUNTIF('Input data'!B:B,\"<=\"&B53)","v":0},{"$f":"(C53/$C$70)*100","v":0},0,{"$f":"(C70-C53)","v":85},{"$f":"(B53-9)","v":10},{"$f":"(F53/$C$70)*100","v":100},100,null,1,100]
[null,20,{"$f":"SUMPRODUCT(('Input data'!B:B<=B55)*('Input data'!B:B>B54)*('Input data'!B:B>0))","v":0},0,0,{"$f":"(F53-C54)","v":85},{"$f":"(B54-9)","v":11},{"$f":"(F54/$C$70)*100","v":100},100,null,2,98.82352941176471]
[null,21,{"$f":"SUMPRODUCT(('Input data'!B:B<B56)*('Input data'!B:B>=B55)*('Input data'!B:B>0))","v":1},1.1764705882352942,4,84,12,98.82352941176471,{"$f":"(I54-E55)","v":96},null,3,68.235294117647058]
[null,22,{"$f":"SUMPRODUCT(('Input data'!B:B<B57)*('Input data'!B:B>=B56)*('Input data'!B:B>0))","v":26},30.588235294117649,23,58,13,68.235294117647058,73,null,4,29.411764705882355]
[null,23,{"$f":"SUMPRODUCT(('Input data'!B:B<B58)*('Input data'!B:B>=B57)*('Input data'!B:B>0))","v":33},38.82352941176471,34,25,14,29.411764705882355,39,null,5,9.4117647058823533]
[null,24,{"$f":"SUMPRODUCT(('Input data'!B:B<B59)*('Input data'!B:B>=B58)*('Input data'!B:B>0))","v":17},20,19,8,15,9.4117647058823533,20,null,6,4.7058823529411766]
[null,25,{"$f":"SUMPRODUCT(('Input data'!B:B<B60)*('Input data'!B:B>=B59)*('Input data'!B:B>0))","v":4},4.7058823529411766,11,4,16,4.7058823529411766,9,null,7,2.3529411764705883]
[null,26,{"$f":"SUMPRODUCT(('Input data'!B:B<B61)*('Input data'!B:B>=B60)*('Input data'!B:B>0))","v":2},2.3529411764705883,6,2,17,2.3529411764705883,3,null,8]
[null,27,{"$f":"SUMPRODUCT(('Input data'!B:B<B62)*('Input data'!B:B>=B61)*('Input data'!B:B>0))","v":2},2.3529411764705883,3,0,18,0,0,null,9]
[null,28,{"$f":"SUMPRODUCT(('Input data'!B:B<B63)*('Input data'!B:B>=B62)*('Input data'!B:B>0))","v":0},0,0,0,19,0,0,null,10]
[null,29,{"$f":"SUMPRODUCT(('Input data'!B:B<B64)*('Input data'!B:B>=B63)*('Input data'!B:B>0))","v":0},0,0,0,20,0,0,null,11]
[null,30,{"$f":"SUMPRODUCT(('Input data'!B:B<B65)*('Input data'!B:B>=B64)*('Input data'!B:B>0))","v":0},0,0,0,21,0,0,null,12]
[null,31,{"$f":"SUMPRODUCT(('Input data'!B:B<B66)*('Input data'!B:B>=B65)*('Input data'!B:B>0))","v":0},0,0,0,22,0,0,null,13]
[null,32,{"$f":"SUMPRODUCT(('Input data'!B:B<B67)*('Input data'!B:B>=B66)*('Input data'!B:B>0))","v":0},0,0,0,23,0,0,null,14]
[null,33,{"$f":"SUMPRODUCT(('Input data'!B:B<B68)*('Input data'!B:B>=B67)*('Input data'!B:B>0))","v":0},0,0,0,24,0,0,null,15]
[null,34,{"$f":"SUMPRODUCT(('Input data'!B:B<B69)*('Input data'!B:B>=B68)*('Input data'!B:B>0))","v":0},0,0,0,25,0,0,null,16]
[null,35,{"$f":"COUNTIF('Input data'!B:B,\">=\"&B69)","v":0},0,0,0,26,0,0,null,17]
[null,"Heifers, n",{"$f":"SUM(C53:C69)","v":85}]
[]
[]
[null,"H(a) = H(i)e-ra"]
[]
[null,"where:"]
[null,"H(a) = % of open heifers at age (a)",null,100]
[null,"H(i) = initial % of open heifers",null,{"$f":"EXP(INDEX(LINEST(LN(y),x),1,2))","v":338.31592571155386},null,{"$f":"EXP(INDEX(LINEST(LN(y),x),1,2))","v":338.31592571155386}]
[null,"r = the decay rate of open heifers",null,{"$f":"INDEX(LINEST(LN(y),x),1)","v":-0.68994852043230515},null,{"$f":"INDEX(LINEST(LN(y),x),1)","v":-0.68994852043230515}]
[null,"a = age in months",null,{"$f":"LN((D76/D77))/D78","v":1.7665230496233268}]
[null,"where; a = [ln(H(a)/H(i)]/r"]
[]
[null,"Effective Pregnancy Rate, %/mo is"]
[null,"1-e(r)",null,{"$f":"(1-EXP(D78))*100","v":49.839810935010654}]
[]
[null,"First (start) breeding age, mo",11,{"$f":"(C85+D79)","v":12.766523049623327}]
[null,"(Min age + a)"]

{"sheet":"Results","index":2,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,1,3]]}
["Heifer Management Report©",null,null,null,null,null,null,"Herd ",null,"Herd 1"]
[null,null,null,null,null,null,null,"Address"]
[null,null,"Breed ","Holstein",null,null,null,"City, Zip"]
[null,null,null,null,null,null,null,"email"]
[]
[null,"Developed by Patrick C. Hoffman, Department of Dairy Science, University of Wisconsin-Madison"]
["Calving Age (Averages and Variance)"]
[null,null,"Your Herd","Goals"]
["Summary Statistics"]
[null,"Average age @ first calving, mo",{"$f":"Analysis!C10","v":23.665188042430092},"23-24 mo"]
[null,"Minimum calving age, mo",{"$f":"Analysis!C11","v":21.57377049180328},"na"]
[null,"Maximum calving age, mo",{"$f":"Analysis!C12","v":27.147540983606557},"na"]
[null,"Heifers calving/year, n",{"$f":"Analysis!C13","v":85},"na"]
[null,"Calving age deviation, mo",{"$f":"Analysis!C14","v":1.0964667759601892},"< 1.7 mo"]
[null,"Kurtosis",{"$f":"Analysis!C15","v":1.5659348694667776},"na"]
[null,"Skewness",{"$f":"Analysis!C16","v":1.1684662648214135},"> 1.5"]
[]
["Range and Variance"]
[null,"Youngest calving age (typical), mo",{"$f":"Analysis!C19","v":22.112846709613205},"> 21 mo"]
[null,"Oldest calving age (typical), mo",{"$f":"Analysis!C20","v":26.442354726761177},"< 28 mo"]
[null,"Calving age range (typical), mo",{"$f":"Analysis!C21","v":4.3295080171479725},"< 6.0"]
[null,"Days on feed variance, d",{"$f":"Analysis!C22","v":132.04999452301317},"< 200"]
[null,"Calving body weight variance, lbs",{"$f":"Analysis!C23","v":224.48499068912238},"< 325"]
[]
["Breeding Efficiency "]
[]
[null,"True heifer pregnancy rate©, %/mo",{"$f":"Analysis!C27","v":49.839810935010654},"> 42.5"]
[null,"Average pregnancy age, mo",{"$f":"Analysis!C28","v":14.665188042430092},"14.0-14.5"]
[null,"First (start) breeding age, mo",{"$f":"Analysis!C29","v":12.766523049623327},"12.5-13.0"]
[]
["Rearing Cost"]
[]
[null,"Excess rearing days, days/heifer",{"$f":"Analysis!C33","v":0},"0 days"]
[null,"Excess rearing cost, $$/heifer",{"$f":"Analysis!C34","v":0},"0 $$"]
[null,"Excess herd rearing days, days/herd",{"$f":"Analysis!C35","v":0},"0 days"]
[null,"Excess rearing cost,  $$/herd",{"$f":"Analysis!C36","v":0},"0 $$"]
[]
["Nutrient management"]
[]
[null,"Excess manure production, tons/year",{"$f":"Analysis!C40","v":0},"0 tons"]
[null,"Excess P production , lbs/year",{"$f":"Analysis!C41","v":0},"0 lbs"]
[]
[null,"© Copyright: Patrick C. Hoffman 12/3/2012"]