{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","2Traits","MilkandFeed","MilkandFerility","exampleSelection"],"not_rendered":{"macros":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":33,"n_cols":11,"rows_kept":33}
[]
[null,"MTINDEX","is a simple spreadsheet for selection index calculations"]
[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 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 MT-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/"]
[]
[]
[{"$nulls":4},"other tools:"]
[{"$nulls":4},"http://www-personal.une.edu.au/~jvanderw/software.htm"]

{"sheet":"2Traits","index":1,"n_rows":51,"n_cols":26,"rows_kept":51}
["Input","Enter data only in"]
[null,"light blue cells",null,"  ",{"$nulls":4},"SD of breeding objective"]
[2,"Nr of traits  ",{"$nulls":3},"Parameters",{"$nulls":3},{"v":1.0505014948077294,"d":"1.05"}]
[{"$nulls":3},"Phenotypic  ","Herit","Repeat","c2 among","Economic  ","Genetic standard deviation",null,"Variance=Covariance matrix of MT_EBV's (correltion below diag)"]
["trait","Name","Units","Stand. Dev","ability","ability","fulls sibs"," value ","Physical","Dollar value",{"$f":"IF(COLUMN(K5)<=nt+10,COLUMN(K5)-10,IF(J5=nt,\"     \",\"\"))","v":1},2,"     ","","",""]
[{"$f":"IF(ROW(A6)<=nt+5,ROW(A6)-5,IF(A5=nt,\"     \",\"\"))","v":1},"Trait 1","Units",1,0.25,0.5,0,1,{"$f":"IF($A6<=nt,SQRT(E6)*D6,\" \")","v":{"v":0.5,"d":"0.50"}},{"$f":"IF($A6<=nt,H6*I6,\" \")","v":{"v":0.5,"d":"0.50"}},{"v":0.05937215426040558,"d":"0.06"},{"v":0.11141802079990504,"d":"0.11"}," "," "," "," "]
[2,"Trait 2","Units",1,0.5,0.5,0,1,{"$f":"IF($A7<=nt,SQRT(E7)*D7,\" \")","v":{"v":0.7071067811865476,"d":"0.71"}},{"v":0.7071067811865476,"d":"0.71"},{"v":0.8333353186596333,"d":"0.83"},{"v":0.3010845667306925,"d":"0.30"}," "," "," "," "]
["     ",{"$nulls":7}," "," "," "," "," "," "," "," "]
["",{"$nulls":7}," "," "," "," "," "," "," "," "]
["",{"$nulls":7}," "," "," "," "," "," "," "," ",{"$nulls":9},{"$f":"IF(COLUMN(Z10)<=nt+3,COLUMN(Z10)-3,IF(Y10=nt,\"Correlation structure\",\"\"))","v":""}]
["",{"$nulls":7}," "," "," "," "," "," "," "," "]
[{"$nulls":3},"Correlations",{"$nulls":5},"Number of records"]
["Correlation structure",null,{"$f":"IF(COLUMN(C13)<=nt+2,COLUMN(C13)-2,IF(B13=nt,\"Phenotypic\",\"\"))","v":1},2,"Phenotypic","","","","own","dam","sire","full sibs","half sibs","progeny"]
[{"$f":"IF(ROW(A14)<=nt+22,$B6,IF(A13=nt,\" Genetic Correlation   \",\"\"))","v":"Trait 1"},{"$f":"IF(ROW(B14)<=nt+13,ROW(B14)-13,IF(B13=nt,\" Genetic   \",\"\"))","v":1},1,0.1,{"$nulls":4},0,1,1,0,0,0]
[{"$f":"IF(ROW(A15)<=nt+22,$B7,IF(A14=nt,\" Genetic Correlation   \",\"\"))","v":"Trait 2"},2,0.5,1,{"$nulls":4},1,1,1,0,25,0]
[{"$f":"IF(ROW(A16)<=nt+5,ROW(A16)-5,IF(A15=nt,\"     \",\"\"))","v":""}," Genetic   "]
[{"$f":"IF(ROW(A17)<=nt+5,ROW(A17)-5,IF(A16=nt,\"     \",\"\"))","v":""},""]
[{"$f":"IF(ROW(A18)<=nt+5,ROW(A18)-5,IF(A17=nt,\"     \",\"\"))","v":""},""]
[{"$f":"IF(ROW(A19)<=nt+5,ROW(A19)-5,IF(A18=nt,\"     \",\"\"))","v":""},""]
[null,"","  ","  ","  "]
[{"$nulls":5},"SD Index","Accuracy of Index"]
["Results",null," ",null,null,{"v":0.7637360555786981,"d":"0.764"},{"v":0.727020436766235,"d":"0.7270"}]
[null,"Trait","Genetic",null,"Response",null,"         Accuracy",{"$nulls":3},"Index weights"]
[null,null,"Stand. Dev",null,null,"Dollar value","MT-EBV","ST-EBV","own","dam","sire","full sibs","half sibs","progeny"]
[{"$f":"A6","v":1},{"$f":"IF(ROW(A6)<=nt+5,B6,IF(A5=nt,\"     \",\"\"))","v":"Trait 1"},{"$f":"IF($A6<=nt,SQRT(E6)*D6,\" \")","v":{"v":0.5,"d":"0.50"}},{"v":0.22362460671167284,"d":"0.22"},{"$f":"IF(ROW(A6)<=nt+5,C6,IF(A5=nt,\"     \",\"\"))","v":"Units"},{"v":0.22362460671167284,"d":"0.22"},{"v":0.48732803843163214,"d":"0.487"},{"v":0.3535533905932738,"d":"0.354"},"-",{"v":0.14752092408933415,"d":"0.148"},{"v":0.11859626642127025,"d":"0.119"},"-","-","-"]
[2,"Trait 2",{"v":0.7071067811865476,"d":"0.71"},{"v":0.5401114488670252,"d":"0.54"},"Units",{"v":0.5401114488670252,"d":"0.54"},{"v":0.7759955756712695,"d":"0.776"},{"v":0.7738529372704305,"d":"0.774"},{"v":0.5285482155320791,"d":"0.529"},{"v":0.19149920135636536,"d":"0.191"},{"v":0.08145525154465733,"d":"0.081"},"-",{"v":0.4517456623140573,"d":"0.45"},"-"]
["     ","     "," "," ","     "," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
[]
[]
[]
[]
[null,null," Genetic Covariance matrix as given (correlations below diagonal)",{"$nulls":5}," Genetic Covariance matrix POSITIVE DEFINITE "]
[null,0.25,{"v":0.1767766952966369,"d":"0.18"},{"$nulls":5},"   ","   ","   ","   ","   ","   "]
[null,{"v":0.5,"d":"0.50"},{"v":0.5000000000000001,"d":"0.50"},{"$nulls":5},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[]
[]
[]
[null,null," Residual Covariance matrix as given (correlations below diagonal) ",{"$nulls":5}," Residual Covariance matrix POSITIVE DEFINITE "]
[null,0.75,{"v":-0.07677669529663689,"d":"-0.08"},{"$nulls":5},"  ","  ","  ","  ","  ","  "]
[null,{"v":-0.1253758184092677,"d":"-0.13"},{"v":0.4999999999999999,"d":"0.50"},{"$nulls":5},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]

{"sheet":"MilkandFeed","index":2,"n_rows":51,"n_cols":26,"rows_kept":51}
["Input","Enter data only in"]
[null,"light blue cells",null,"  ",{"$nulls":4},"SD of breeding objective"]
[2,"Nr of traits  ",{"$nulls":3},"Parameters",{"$nulls":3},{"v":0.21005101952408253,"d":"0.21"}]
[{"$nulls":3},"Phenotypic  ","Herit","Repeat","c2 among","Economic  ","Genetic standard deviation",null,"Variance=Covariance matrix of MT_EBV's (correltion below diag)"]
["trait","Name","Units","Stand. Dev","ability","ability","fulls sibs"," value ","Physical","Dollar value",{"$f":"IF(COLUMN(K5)<=nt+10,COLUMN(K5)-10,IF(J5=nt,\"     \",\"\"))","v":1},2,"     ","","",""]
[{"$f":"IF(ROW(A6)<=nt+5,ROW(A6)-5,IF(A5=nt,\"     \",\"\"))","v":1},"Milk","kg/day",2.5,0.3,0.5,0,0.2,{"$f":"IF($A6<=nt,SQRT(E6)*D6,\" \")","v":{"v":1.369306393762915,"d":"1.37"}},{"$f":"IF($A6<=nt,H6*I6,\" \")","v":{"v":0.27386127875258304,"d":"0.27"}},{"v":1.5056119397272278,"d":"1.51"},{"v":0.7002923771242338,"d":"0.70"}," "," "," "," "]
[2,"Feed","kg/day",2,0.2,0.5,0,-0.3,{"v":0.8944271909999159,"d":"0.89"},{"v":-0.2683281572999747,"d":"-0.27"},{"v":0.8874178013035551,"d":"0.89"},{"v":0.413608519017877,"d":"0.41"}," "," "," "," "]
["     ",{"$nulls":7}," "," "," "," "," "," "," "," "]
["",{"$nulls":7}," "," "," "," "," "," "," "," "]
["",{"$nulls":7}," "," "," "," "," "," "," "," ",{"$nulls":9},{"$f":"IF(COLUMN(Z10)<=nt+3,COLUMN(Z10)-3,IF(Y10=nt,\"Correlation structure\",\"\"))","v":""}]
["",{"$nulls":7}," "," "," "," "," "," "," "," "]
[{"$nulls":3},"Correlations",{"$nulls":5},"Number of records"]
["Correlation structure",null,{"$f":"IF(COLUMN(C13)<=nt+2,COLUMN(C13)-2,IF(B13=nt,\"Phenotypic\",\"\"))","v":1},2,"Phenotypic","","","","own","dam","sire","full sibs","half sibs","progeny"]
[{"$f":"IF(ROW(A14)<=nt+22,$B6,IF(A13=nt,\" Genetic Correlation   \",\"\"))","v":"Milk"},{"$f":"IF(ROW(B14)<=nt+13,ROW(B14)-13,IF(B13=nt,\" Genetic   \",\"\"))","v":1},1,0.4,{"$nulls":4},0,0,0,0,0,50]
[{"$f":"IF(ROW(A15)<=nt+22,$B7,IF(A14=nt,\" Genetic Correlation   \",\"\"))","v":"Feed"},2,0.7,1,{"$nulls":4},0,0,0,0,0,10]
[{"$f":"IF(ROW(A16)<=nt+22,$B8,IF(A15=nt,\" Genetic Correlation   \",\"\"))","v":0}," Genetic   "]
[{"$f":"IF(ROW(A17)<=nt+22,$B9,IF(A16=nt,\" Genetic Correlation   \",\"\"))","v":0},""]
[{"$f":"IF(ROW(A18)<=nt+22,$B10,IF(A17=nt,\" Genetic Correlation   \",\"\"))","v":0},""]
[{"$f":"IF(ROW(A19)<=nt+13,$B11,IF(A18=nt,\" Genetic Correlation   \",\"\"))","v":""},""]
[null,"","  ","  ","  "]
[{"$nulls":5},"SD Index","Accuracy of Index"]
["Results",null," ",null,null,{"v":0.11581951064388929,"d":"0.116"},{"v":0.5513875195954975,"d":"0.5514"}]
[null,"Trait","Genetic",null,"Response",null,"         Accuracy",{"$nulls":3},"Index weights"]
[null,null,"Stand. Dev",null,null,"Dollar value","MT-EBV","ST-EBV","own","dam","sire","full sibs","half sibs","progeny"]
[{"$f":"A6","v":1},{"$f":"IF(ROW(A6)<=nt+5,B6,IF(A5=nt,\"     \",\"\"))","v":"Milk"},{"$f":"IF($A6<=nt,SQRT(E6)*D6,\" \")","v":{"v":1.369306393762915,"d":"1.37"}},{"v":0.7860046576097193,"d":"0.79"},{"$f":"IF(ROW(A6)<=nt+5,C6,IF(A5=nt,\"     \",\"\"))","v":"kg/day"},{"v":0.15720093152194387,"d":"0.16"},{"v":0.8960987861397807,"d":"0.896"},{"v":0.8956221510397981,"d":"0.896"},"-","-","-","-","-",{"v":0.15459148190065206,"d":"0.155"}]
[2,"Feed",{"v":0.8944271909999159,"d":"0.89"},{"v":0.13793806959351523,"d":"0.14"},"kg/day",{"v":-0.04138142087805457,"d":"-0.04"},{"v":0.7190345254383452,"d":"0.719"},{"v":0.5872202195147036,"d":"0.587"},"-","-","-","-","-",{"v":-0.12572843474260892,"d":"-0.126"}]
["     ","     "," "," ","     "," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
[]
[]
[]
[]
[null,null," Genetic Covariance matrix as given (correlations below diagonal)",{"$nulls":5}," Genetic Covariance matrix POSITIVE DEFINITE "]
[null,{"v":1.8749999999999993,"d":"1.88"},{"v":0.8573214099741121,"d":"0.86"},{"$nulls":5},"   ","   ","   ","   ","   ","   "]
[null,{"v":0.7,"d":"0.70"},{"v":0.7999999999999999,"d":"0.80"},{"$nulls":5},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[]
[]
[]
[null,null," Residual Covariance matrix as given (correlations below diagonal) ",{"$nulls":5}," Residual Covariance matrix POSITIVE DEFINITE "]
[null,{"v":4.375000000000001,"d":"4.38"},{"v":1.1426785900258878,"d":"1.14"},{"$nulls":5},"  ","  ","  ","  ","  ","  "]
[null,{"v":0.30539369907705677,"d":"0.31"},{"v":3.2,"d":"3.20"},{"$nulls":5},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]

{"sheet":"MilkandFerility","index":3,"n_rows":51,"n_cols":26,"rows_kept":51}
["Input","Enter data only in"]
[null,"light blue cells",null,"  ",{"$nulls":4},"SD of breeding objective"]
[2,"Nr of traits  ",{"$nulls":3},"Parameters",{"$nulls":3},{"v":94.60336342085986,"d":"94.60"}]
[{"$nulls":3},"Phenotypic  ","Herit","Repeat","c2 among","Economic  ","Genetic standard deviation",null,"Variance=Covariance matrix of MT_EBV's (correltion below diag)"]
["trait","Name","Units","Stand. Dev","ability","ability","fulls sibs"," value ","Physical","Dollar value",{"$f":"IF(COLUMN(K5)<=nt+10,COLUMN(K5)-10,IF(J5=nt,\"     \",\"\"))","v":1},2,"     ","","",""]
[{"$f":"IF(ROW(A6)<=nt+5,ROW(A6)-5,IF(A5=nt,\"     \",\"\"))","v":1},"Milk","kg/lact",800,0.3,0.5,0,0.2,{"$f":"IF($A6<=nt,SQRT(E6)*D6,\" \")","v":{"v":438.17804600413285,"d":"438.18"}},{"$f":"IF($A6<=nt,H6*I6,\" \")","v":{"v":87.63560920082658,"d":"87.64"}},{"v":154013.41898103053,"d":"154013.42"},{"v":-696.8326248506553,"d":"-696.83"}," "," "," "," "]
[2,"Fertility","%",46,0.03,0.03,0,{"v":8,"d":"8.0"},{"v":7.967433714816836,"d":"7.97"},{"v":63.739469718534686,"d":"63.74"},{"v":-0.6665304581122555,"d":"-0.67"},{"v":7.096731746041991,"d":"7.10"}," "," "," "," "]
["     ",{"$nulls":7}," "," "," "," "," "," "," "," "]
["",{"$nulls":7}," "," "," "," "," "," "," "," "]
["",{"$nulls":7}," "," "," "," "," "," "," "," ",{"$nulls":9},{"$f":"IF(COLUMN(Z10)<=nt+3,COLUMN(Z10)-3,IF(Y10=nt,\"Correlation structure\",\"\"))","v":""}]
["",{"$nulls":7}," "," "," "," "," "," "," "," "]
[{"$nulls":3},"Correlations",{"$nulls":5},"Number of records"]
["Correlation structure",null,{"$f":"IF(COLUMN(C13)<=nt+2,COLUMN(C13)-2,IF(B13=nt,\"Phenotypic\",\"\"))","v":1},2,"Phenotypic","","","","own","dam","sire","full sibs","half sibs","progeny"]
[{"$f":"IF(ROW(A14)<=nt+22,$B6,IF(A13=nt,\" Genetic Correlation   \",\"\"))","v":"Milk"},{"$f":"IF(ROW(B14)<=nt+13,ROW(B14)-13,IF(B13=nt,\" Genetic   \",\"\"))","v":1},1,-0.1,{"$nulls":4},0,0,0,0,0,50]
[{"$f":"IF(ROW(A15)<=nt+22,$B7,IF(A14=nt,\" Genetic Correlation   \",\"\"))","v":"Fertility"},2,-0.25,1,{"$nulls":4},0,0,0,0,0,10]
[{"$f":"IF(ROW(A16)<=nt+22,$B8,IF(A15=nt,\" Genetic Correlation   \",\"\"))","v":0}," Genetic   "]
[{"$f":"IF(ROW(A17)<=nt+22,$B9,IF(A16=nt,\" Genetic Correlation   \",\"\"))","v":0},""]
[{"$f":"IF(ROW(A18)<=nt+22,$B10,IF(A17=nt,\" Genetic Correlation   \",\"\"))","v":0},""]
[{"$f":"IF(ROW(A19)<=nt+13,$B11,IF(A18=nt,\" Genetic Correlation   \",\"\"))","v":""},""]
[null,"","  ","  ","  "]
[{"$nulls":5},"SD Index","Accuracy of Index"]
["Results",null," ",null,null,{"v":66.21829952109773,"d":"66.218"},{"v":0.6999571381676344,"d":"0.7000"}]
[null,"Trait","Genetic",null,"Response",null,"         Accuracy",{"$nulls":3},"Index weights"]
[null,null,"Stand. Dev",null,null,"Dollar value","MT-EBV","ST-EBV","own","dam","sire","full sibs","half sibs","progeny"]
[{"$f":"A6","v":1},{"$f":"IF(ROW(A6)<=nt+5,B6,IF(A5=nt,\"     \",\"\"))","v":"Milk"},{"$f":"IF($A6<=nt,SQRT(E6)*D6,\" \")","v":{"v":438.17804600413285,"d":"438.18"}},{"v":380.98264346644834,"d":"380.98"},{"$f":"IF(ROW(A6)<=nt+5,C6,IF(A5=nt,\"     \",\"\"))","v":"kg/lact"},{"v":76.19652869328966,"d":"76.20"},{"v":0.89563007087722,"d":"0.896"},{"v":0.8956221510397983,"d":"0.896"},"-","-","-","-","-",{"v":0.2676939268115742,"d":"0.268"}]
[2,"Fertility",{"v":7.967433714816836,"d":"7.97"},{"v":-1.2472786465239922,"d":"-1.25"},"%",{"v":-9.978229172191938,"d":"-9.98"},{"v":0.33435724308844045,"d":"0.334"},{"v":0.26506152350203105,"d":"0.265"},"-","-","-","-","-",{"v":1.0783691676693627,"d":"1.078"}]
["     ","     "," "," ","     "," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
[]
[]
[]
[]
[null,null," Genetic Covariance matrix as given (correlations below diagonal)",{"$nulls":5}," Genetic Covariance matrix POSITIVE DEFINITE "]
[null,{"v":191999.99999999997,"d":"192000.00"},{"v":-872.7886342064727,"d":"-872.79"},{"$nulls":5},"   ","   ","   ","   ","   ","   "]
[null,{"v":-0.25000000000000006,"d":"-0.25"},{"v":63.480000000000004,"d":"63.48"},{"$nulls":5},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[]
[]
[]
[null,null," Residual Covariance matrix as given (correlations below diagonal) ",{"$nulls":5}," Residual Covariance matrix POSITIVE DEFINITE "]
[null,{"v":448000,"d":"448000.00"},{"v":-2807.2113657935274,"d":"-2807.21"},{"$nulls":5},"  ","  ","  ","  ","  ","  "]
[null,{"v":-0.0925747201275664,"d":"-0.09"},2052.52,{"$nulls":5},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]

{"sheet":"exampleSelection","index":4,"n_rows":51,"n_cols":26,"rows_kept":51}
["Input","Enter data only in"]
[null,"light blue cells",null,"  ",{"$nulls":4},"SD of breeding objective"]
[2,"Nr of traits  ",{"$nulls":3},"Parameters",{"$nulls":3},{"v":3.464101615137755,"d":"3.46"}]
[{"$nulls":3},"Phenotypic  ","Herit","Repeat","c2 among","Economic  ","Genetic standard deviation",null,"Variance=Covariance matrix of MT_EBV's (correltion below diag)"]
["trait","Name","Units","Stand. Dev","ability","ability","fulls sibs"," value ","Physical","Dollar value",{"$f":"IF(COLUMN(K5)<=nt+10,COLUMN(K5)-10,IF(J5=nt,\"     \",\"\"))","v":1},2,"     ","","",""]
[{"$f":"IF(ROW(A6)<=nt+5,ROW(A6)-5,IF(A5=nt,\"     \",\"\"))","v":1},"t1",null,{"$f":"SQRT(25)","v":5},0.4,0.5,0,{"v":1,"d":"1.0"},{"$f":"IF($A6<=nt,SQRT(E6)*D6,\" \")","v":{"v":3.1622776601683795,"d":"3.16"}},{"$f":"IF($A6<=nt,H6*I6,\" \")","v":{"v":3.1622776601683795,"d":"3.16"}},{"v":8.725011907682989,"d":"8.73"},{"v":-3.4900047630731943,"d":"-3.49"}," "," "," "," "]
[2,"t2",null,10,0.1,0.1,0,{"v":1,"d":"1.0"},{"v":3.1622776601683795,"d":"3.16"},{"v":3.1622776601683795,"d":"3.16"},{"v":-0.5607455302404917,"d":"-0.56"},{"v":4.439707617758744,"d":"4.44"}," "," "," "," "]
["     ",{"$nulls":7}," "," "," "," "," "," "," "," "]
["",{"$nulls":7}," "," "," "," "," "," "," "," "]
["",{"$nulls":7}," "," "," "," "," "," "," "," ",{"$nulls":9},{"$f":"IF(COLUMN(Z10)<=nt+3,COLUMN(Z10)-3,IF(Y10=nt,\"Correlation structure\",\"\"))","v":""}]
["",{"$nulls":7}," "," "," "," "," "," "," "," "]
[{"$nulls":3},"Correlations",{"$nulls":5},"Number of records"]
["Correlation structure",null,{"$f":"IF(COLUMN(C13)<=nt+2,COLUMN(C13)-2,IF(B13=nt,\"Phenotypic\",\"\"))","v":1},2,"Phenotypic","","","","own","dam","sire","full sibs","half sibs","progeny"]
[{"$f":"IF(ROW(A14)<=nt+22,$B6,IF(A13=nt,\" Genetic Correlation   \",\"\"))","v":"t1"},{"$f":"IF(ROW(B14)<=nt+13,ROW(B14)-13,IF(B13=nt,\" Genetic   \",\"\"))","v":1},1,-0.2,{"$nulls":4},1,1,1,7,32,50]
[{"$f":"IF(ROW(A15)<=nt+22,$B7,IF(A14=nt,\" Genetic Correlation   \",\"\"))","v":"t2"},2,-0.4,1,{"$nulls":4},1,1,1,7,32,10]
[{"$f":"IF(ROW(A16)<=nt+22,$B8,IF(A15=nt,\" Genetic Correlation   \",\"\"))","v":0}," Genetic   "]
[{"$f":"IF(ROW(A17)<=nt+22,$B9,IF(A16=nt,\" Genetic Correlation   \",\"\"))","v":0},""]
[{"$f":"IF(ROW(A18)<=nt+22,$B10,IF(A17=nt,\" Genetic Correlation   \",\"\"))","v":0},""]
[{"$f":"IF(ROW(A19)<=nt+13,$B11,IF(A18=nt,\" Genetic Correlation   \",\"\"))","v":""},""]
[null,"","  ","  ","  "]
[{"$nulls":5},"SD Index","Accuracy of Index"]
["Results",null," ",null,null,{"v":2.486907718290999,"d":"2.487"},{"v":0.7179084203025331,"d":"0.7179"}]
[null,"Trait","Genetic",null,"Response",null,"         Accuracy",{"$nulls":3},"Index weights"]
[null,null,"Stand. Dev",null,null,"Dollar value","MT-EBV","ST-EBV","own","dam","sire","full sibs","half sibs","progeny"]
[{"$f":"A6","v":1},{"$f":"IF(ROW(A6)<=nt+5,B6,IF(A5=nt,\"     \",\"\"))","v":"t1"},{"$f":"IF($A6<=nt,SQRT(E6)*D6,\" \")","v":{"v":3.1622776601683795,"d":"3.16"}},{"v":2.105026698862508,"d":"2.11"},{"$f":"IF(ROW(A6)<=nt+5,C6,IF(A5=nt,\"     \",\"\"))","v":0},{"v":2.105026698862508,"d":"2.11"},{"v":0.9340777220169096,"d":"0.934"},{"v":0.9340777220169092,"d":"0.934"},{"v":0.07545748847565131,"d":"0.075"},{"v":0.026000422779186926,"d":"0.026"},{"v":0.011541103660466675,"d":"0.012"},{"v":0.11156578446501988,"d":"0.112"},{"v":0.15234741369325233,"d":"0.152"},{"v":0.9606821687459719,"d":"0.961"}]
[2,"t2",{"v":3.1622776601683795,"d":"3.16"},{"v":0.38188101942849045,"d":"0.38"},0,{"v":0.38188101942849045,"d":"0.38"},{"v":0.6663113099564455,"d":"0.666"},{"v":0.6270241398172467,"d":"0.627"},{"v":0.06114491195742619,"d":"0.061"},{"v":0.028368694030657206,"d":"0.028"},{"v":0.017161579496706016,"d":"0.017"},{"v":0.152065161911651,"d":"0.152"},{"v":0.25616261791888373,"d":"0.26"},{"v":0.27672526800323083,"d":"0.277"}]
["     ","     "," "," ","     "," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
[]
[]
[]
[]
[null,null," Genetic Covariance matrix as given (correlations below diagonal)",{"$nulls":5}," Genetic Covariance matrix POSITIVE DEFINITE "]
[null,{"v":10.000000000000002,"d":"10.00"},{"v":-4.000000000000001,"d":"-4.00"},{"$nulls":5},"   ","   ","   ","   ","   ","   "]
[null,{"v":-0.4,"d":"-0.40"},{"v":10.000000000000002,"d":"10.00"},{"$nulls":5},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[{"$nulls":8},"   ","   ","   ","   ","   ","   "]
[]
[]
[]
[null,null," Residual Covariance matrix as given (correlations below diagonal) ",{"$nulls":5}," Residual Covariance matrix POSITIVE DEFINITE "]
[null,{"v":14.999999999999998,"d":"15.00"},{"v":-5.999999999999999,"d":"-6.00"},{"$nulls":5},"  ","  ","  ","  ","  ","  "]
[null,{"v":-0.1632993161855452,"d":"-0.16"},{"v":90,"d":"90.00"},{"$nulls":5},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]
[{"$nulls":8},"  ","  ","  ","  ","  ","  "]