{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","2 trait GS selection index"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":37,"n_cols":11,"rows_kept":37}
[]
[null,"MTINDEX PC","is a simple spreadsheet for selection index calculations with thecombined use of purebred and crossbred data"]
[null,null,"it uses a macro, so you need to allow usage of macros",{"$nulls":4},"(see Tools>Security>Macro Security)"]
[]
[]
[null,null,"It does","Work out basic selection index",null,null,"weights"]
[{"$nulls":6},"accuracy"]
[{"$nulls":6},"response per trait in $ and trait units",{"$nulls":3},"This is per 'selection round'"]
[{"$nulls":10},"For purebred and crossbred animals separately and combined"]
[{"$nulls":10},"For response per year, multiply by"]
[{"$nulls":10},"i/(Lf+Lm), where i is selection intensity, and L is generation interval"]
[{"$nulls":10},"Typically you would calculate different indices for males and females"]
[{"$nulls":10},"Or even for different ages classes"]
[{"$nulls":3},"Check whether parameters are consistent"]
[{"$nulls":3},"Provide accuracy per trait EBV, from single trait and multiple trait information"]
[{"$nulls":3},"Provide covariance matrix about PC-EBVs"]
[]
[null,null,"It does not handle",null,"Desired Gains",null,"(see for this MTINDEX_DESGAIN)"]
[{"$nulls":4},"Multiple Stage Selection"]
[]
[]
[null,null,"Instruction:",null,"Input on in light blue cells, others are protected"]
[{"$nulls":4},"To run the program, just click on the RUN button (if this does not work, you might have turned on the 'Select Objects' button on the drawing toolbar)"]
[]
[]
[null,null,"Produced by",null,"Julius van der Werf "]
[{"$nulls":4},"University of New England"]
[{"$nulls":4},"Armidale, Australia"]
[{"$nulls":4},"julius.vanderwerf@une.edu.au"]
[{"$nulls":4},"http://www-personal.une.edu.au/~jvanderw/"]
[]
[null,null,"And",null,"Ilse van Grevenhof"]
[{"$nulls":4},"Wageningen University, Wageningen, The Netherlands"]
[{"$nulls":4},"ilse.vangrevenhof@wur.nl"]
[]
[{"$nulls":4},"other tools:"]
[{"$nulls":4},"http://www-personal.une.edu.au/~jvanderw/software.htm"]

{"sheet":"2 trait GS selection index","index":1,"n_rows":73,"n_cols":32,"rows_kept":73,"merged":[[2,2,2,3],[2,10,2,11],[8,7,8,8],[9,7,9,8],[10,0,10,1],[22,2,22,3],[22,10,22,11],[27,7,27,8],[29,0,29,1]]}
[]
[null,null,"Trait 1","  ",{"$nulls":6},"Trait 2"]
[null,null,"only fill in light blue cells",{"$nulls":7},"only fill in light blue cells"]
[]
[null,null,"Parameters",{"$nulls":7},"Parameters",{"$nulls":17}," "," "," "," "]
[null,null,"phen SD",1,{"$nulls":6},"phen SD",1,{"$nulls":16}," "," "," "," "]
[null,null,"heritability",0.5,{"$nulls":6},"heritability",0.3,{"$nulls":14}," "," "," "," "," "," "]
[null,null,"repeatability",0.5,{"$nulls":6},"repeatability",0.3,{"$nulls":14}," "," "," "," "," "," "]
[null,null,"c2 among full sibs",0.15,{"$nulls":6},"c2 among full sibs",0.15,{"$nulls":14}," "," "," "," "," "," "]
[null,null,"economic value",0,null,null,"Correlation",{"$nulls":3},"economic value",1,{"$nulls":14}," "," "," "," "," "," "]
["  INPUT"]
[null,null,"reliability of MBV",{"v":0.9,"d":"0.900"},null,null,"Genetic",0.5,null,null,"reliability of MBV",{"v":0.1,"d":"0.100"}]
[null,null,"Information used","Nr.Records",null,null,"Phenotypic",0.1,null,null,"Information used","Nr.Records"]
[null,null,"nr of own records ",0,{"$nulls":6},"nr of own records ",0]
[null,null,"nr. of records on dam",0,{"$nulls":6},"nr. of records on dam",0]
[null,null,"nr of records on sire",0,{"$nulls":6},"nr of records on sire",0]
[null,null,"nr of fulls sib records",0,{"$nulls":6},"nr of fulls sib records",0]
[null,null,"nr. of half sib records (excl. full sibs)",0,{"$nulls":6},"nr. of half sib records (excl. full sibs)",0]
[null,null,"nr. of progeny",99,{"$nulls":6},"nr. of progeny",1]
[null,null,"individual genotyped",{"$f":"H20","v":1},null,null,"individual genotyped",1,null,null,"individual genotyped",{"$f":"H20","v":1}]
[]
[null,null,"Trait 1",{"$nulls":7},"Trait 2"]
[null,null,"Results",{"$nulls":7},"Results"]
[null,null,"Genetic SD",{"$f":"SQRT(D7)*D6","v":{"v":0.7071067811865476,"d":"0.71"}},{"$nulls":6},"Genetic SD",{"$f":"SQRT(L7)*L6","v":{"v":0.5477225575051661,"d":"0.55"}}]
[null,null,"Genetic SD dollar",{"$f":"D24*D10","v":{"v":0,"d":"0.00"}},{"$nulls":6},"Genetic SD dollar",{"$f":"L24*L10","v":{"v":0.5477225575051661,"d":"0.55"}}]
[null,null,"Respons",{"v":0.5872982519626976,"d":"0.5873"},{"$nulls":6},"Respons",{"v":0.31770001962807326,"d":"0.32"},{"$nulls":12}," "," "," "," "," "," "]
[null,null,"Response dollar",{"v":0,"d":"0.00"},{"$nulls":6},"Response dollar",{"v":0.31770001962807326,"d":"0.32"},{"$nulls":12}," "," "," "," "," "," "]
[null,null,"SD Index",{"$f":"I36","v":{"v":0.3177000196280731,"d":"0.32"}},{"$nulls":6},"SD Index",{"$f":"I36","v":{"v":0.3177000196280731,"d":"0.32"}},{"$nulls":12}," "," "," "," "," "," "]
[null,null,"Accuracy ST",{"v":0.9790709277967582,"d":"0.98"},null,null,"VCV","T1","T2",null,"Accuracy ST",{"v":0.4015084905827965,"d":"0.40"},{"$nulls":12}," "," "," "," "," "," "]
["  OUTPUT",null,"Accuracy MT",{"v":0.9791033353789896,"d":"0.97910"},null,null,"T1",{"v":0.4793216706751316,"d":"0.479322"},{"v":0.18658466617608205,"d":"0.186585"},null,"AccuracyMT",{"v":0.5800382242337656,"d":"0.58004"}]
[null,null," accuracy of Index",{"$f":"I38","v":{"v":0.5800382242337656,"d":"0.5800"}},null,null,"T2",{"v":0.1865846661760821,"d":"0.186585"},{"v":0.10093330247167809,"d":"0.100933"},null,"Index of accuracy",{"$f":"I38","v":{"v":0.5800382242337656,"d":"0.5800"}}]
[null,null,"Information used","Index weight",{"$nulls":6},"Information used","Index weight"]
[null,null,"nr of own records ",{"$f":"R33","v":"-"},{"$nulls":6},"nr of own records ",{"$f":"S33","v":"-"},{"$nulls":5},"-","-"]
[null,null,"nr of records on dam","-",{"$nulls":6},"nr of records on dam","-",{"$nulls":5},"-","-"]
[null,null,"nr of records on sire","-",{"$nulls":6},"nr of records on sire","-",{"$nulls":5},"-","-"]
[null,null,"nr of fulls sib records","-",null,null,"SD Index",null,{"v":0.3177000196280731,"d":"0.32"},null,"nr of fulls sib records","-",{"$nulls":5},"-","-"]
[null,null,"nr of half sib records (excl. full sibs)","-",null,null,"SD of breeding objective",null,{"v":0.5477225575051661,"d":"0.55"},null,"nr of half sib records (excl. full sibs)","-",{"$nulls":5},"-","-"]
[null,null,"nr of progeny",{"v":0.3933179569486892,"d":"0.39"},null,null,"Overall Accuracy",null,{"v":0.5800382242337656,"d":"0.5800"},null,"nr of progeny",{"v":0.10738204920196445,"d":"0.11"},{"$nulls":5},0.3933179569486892,0.10738204920196445]
[null,null,"genotype of individual",{"v":0.14129002268577362,"d":"0.14"},{"$nulls":6},"genotype of individual",{"v":0.7372840649197103,"d":"0.74"},{"$nulls":5},0.14129002268577362,0.7372840649197103]
[]
[]
["  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  "]
[]
[]
[]
[]
[{"$nulls":8}," Genetic Covariance matrix POSITIVE DEFINITE "]
[]
[]
[]
[null,null," Genetic Covariance matrix as given (correlations below diagonal)"]
[null,0.29999999999999993,0.17146428199482244,{"$nulls":5},"   ","   ","   ","   ","   ","   "]
[null,0.7000000000000001,0.19999999999999998,{"$nulls":5},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8}," Residual Covariance matrix POSITIVE DEFINITE ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[]
[]
[]
[null,null," Residual Covariance matrix as given (correlations below diagonal) "]
[null,0.7000000000000001,0.42853571800517753,{"$nulls":5},"  ","  ","  ","  ","  ","  "]
[null,0.5726549409894811,0.8,{"$nulls":5},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]