{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","2Traits","MilkandFeed","MilkandFerility","exampleSelection"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Instructions","index":0,"n_rows":56,"n_cols":19,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,"MTINDEX","is a simple spreadsheet for selection index calculations"]
[null,null,"it uses a macro, so you need to allow usage of macros",null,null,null,null,"(see Tools>Security>Macro Security)"]
[]
[]
[null,null,"It does","Work out basic selection index",null,null,"weights"]
[null,null,null,null,null,null,"accuracy"]
[null,null,null,null,null,null,"response per trait in $ and trait units",null,null,null,"This is per 'selection round'"]
[null,null,null,null,null,null,null,null,null,null,"For response per year, multiply by"]
[null,null,null,null,null,null,null,null,null,null,"i/(Lf+Lm), where i is selection intensity, and L is generation interval"]
[null,null,null,null,null,null,null,null,null,null,"Typically you would calculate different indices for males and females"]
[null,null,null,null,null,null,null,null,null,null,"Or even for different ages classes"]
[null,null,null,"Check whether parameters are consistent"]
[null,null,null,"Provide accuracy per trait EBV, from single trait and multiple trait information"]
[null,null,null,"Provide covariance matrix about MT-EBVs"]
[]
[null,null,"It does not handle",null,"Desired Gains",null,"(see for this MTINDEX_DESGAIN)"]
[null,null,null,null,"Multiple Stage Selection"]
[]
[]
[null,null,"Instruction:",null,"Input on in light blue cells, others are protected"]
[null,null,null,null,"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"]
[null,null,null,null,"University of New England"]
[null,null,null,null,"Armidale, Australia"]
[null,null,null,null,"julius.vanderwerf@une.edu.au"]
[null,null,null,null,"http://www-personal.une.edu.au/~jvanderw/"]
[]
[]
[null,null,null,null,"other tools:"]
[null,null,null,null,"http://www-personal.une.edu.au/~jvanderw/software.htm"]
[]
[]
["Calculate","Response per Year",null,null,null,"same index for sires and dams",null,null,null,null,null,null,"different indices for sires and dams"]
[null,null,null,null,null,2,0.5,null,null,null,"im",null,null,null,null,"if"]
[null,"(i_m x r_m   +","i_f  x  r_f)","sigma_H","same as","(i_m      +","i_f   )","sigma_Index",null,null,2,null,"SigmaMaleIndex",null,null,0.5,"Sigmafemale Index"]
[null,null,null,null,null,3,4,null,null,null,"Lm","Lf",null,null,"Lm","Lf"]
[null,"    ( L_m    +"," L_f  )",null,null,"   ( L_m   +"," L_f  )",null,null,null,3,5,null,null,3,5]
[]
[null," i  = selection intensity",null,null,null,"because sigma_Index = r. sigma_H"]
[null,"r  = selection accuracy",null,null,null,null,null,null,null,null,"Often, males and females candidates have not the same amount of information"]
[null,"L = generation interval",null,null,null,"so the SD Index can be multiplied by ",null,null,null,null,"to estimate their breeding value, and we have a different index accuracy for males and females"]
[null,"m / f  =","males/females",null,null,"a constant (i/L) to get response per year",null,null,null,null,"In that case we would do a mtindex run for males and females "]
[null,null,null,null,null,null,null,null,null,null,"and mutiply each outcome  that with contributins to genetic gain for males and females."]
[null,null,null,null,null,"sig(i)/sig(L)",0.35714285714285715,null,null,null,"sig(i)/sig(L)",0.25,null,null,"sig(i)/sig(L)",6.25E-2]
[]
[]
[null,null,null,null,null,"For example",null,null,"Resp/Year",null,null,"For example",null,"sires","For example",null,"dams","Resp/Year"]
[null,null,null,null,null,null,null,"SD Index",null,null,null,null,null,"SD Index",null,null,"SD Index"]
[null,null,null,null,null,null,null,66.218299521097734,23.649392686106335,"dollars",null,null,null,66.218299521097734,null,null,49.612629827384744,19.65536424448598,"dollars"]
[null,null,null,null,null,null,"Response",null,null,null,null,null,"Response",null,null,"Response"]
[null,null,null,null,null,null,null,"Dollar value",null,null,null,null,null,"Dollar value",null,null,"Dollar value"]
[null,null,null,null,"Milk",380.98264346644834,"kg/lact",76.196528693289665,136.06522980944584,"kg/lact","Milk",380.98264346644834,"kg/lact",76.196528693289665,285.69491883314146,"kg/lact",57.138983766628293,113.10159329368342,"kg/lact"]
[null,null,null,null,"Fertility",-1.2472786465239922,"%",-9.9782291721919378,-0.4454566594728544,"%","Fertility",-1.2472786465239922,"%",-9.9782291721919378,-0.94079424240544307,"%",-7.5263539392435446,-0.37061930178133823,"%"]

{"sheet":"2Traits","index":1,"n_rows":51,"n_cols":26,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Input","Enter data only in"]
[null,"light blue cells",null,"  ",null,null,null,null,"SD of breeding objective"]
[2,"Nr of traits  ",null,null,null,"Parameters",null,null,null,0.8660254037844386]
[null,null,null,"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":0.5},{"$f":"IF($A6<=nt,H6*I6,\" \")","v":0.5},0.19872647328221971,0.12328580620584673," "," "," "," "]
[2,"Trait 2","Units",1,0.25,0.5,0,1,{"$f":"IF($A7<=nt,SQRT(E7)*D7,\" \")","v":0.5},0.5,0.62037937960466616,0.19872647328221971," "," "," "," "]
["     ",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,{"$f":"IF(COLUMN(Z10)<=nt+3,COLUMN(Z10)-3,IF(Y10=nt,\"Correlation structure\",\"\"))","v":""}]
["",null,null,null,null,null,null,null," "," "," "," "," "," "," "," "]
[null,null,null,"Correlations",null,null,null,null,null,"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,null,null,null,null,0,1,1,0,0,50]
[{"$f":"IF(ROW(A15)<=nt+22,$B7,IF(A14=nt,\" Genetic Correlation   \",\"\"))","v":"Trait 2"},2,0.5,1,null,null,null,null,0,1,1,0,0,50]
[{"$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,"","  ","  ","  "]
[null,null,null,null,null,"SD Index","Accuracy of Index"]
["Results",null," ",null,null,0.80251140738068816,0.92666035415797154]
[null,"Trait","Genetic",null,"Response",null,"         Accuracy",null,null,null,"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":0.5},0.40125570369034419,{"$f":"IF(ROW(A6)<=nt+5,C6,IF(A5=nt,\"     \",\"\"))","v":"Units"},0.40125570369034419,0.8915749509317088,0.8812466991035206,"-",3.7184365271532321E-2,3.7184365271532335E-2,"-","-",1.64303009339329]
[2,"Trait 2",0.5,0.40125570369034408,"Units",0.40125570369034408,0.89157495093170869,0.8812466991035206,"-",3.7184365271532259E-2,3.7184365271532308E-2,"-","-",1.6430300933932895]
["     ","     "," "," ","     "," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
[]
[]
[]
[]
[null,null," Genetic Covariance matrix as given (correlations below diagonal)",null,null,null,null,null," Genetic Covariance matrix POSITIVE DEFINITE "]
[null,0.25,0.125,null,null,null,null,null,"   ","   ","   ","   ","   ","   "]
[null,0.5,0.25,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,null,null,null,"   ","   ","   ","   ","   ","   "]
[]
[]
[]
[null,null," Residual Covariance matrix as given (correlations below diagonal) ",null,null,null,null,null," Residual Covariance matrix POSITIVE DEFINITE "]
[null,0.75,-0.22500000000000001,null,null,null,null,null,"  ","  ","  ","  ","  ","  "]
[null,-0.3,0.75,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,null,null,null,"  ","  ","  ","  ","  ","  "]

{"sheet":"MilkandFeed","index":2,"n_rows":51,"n_cols":26,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Input","Enter data only in"]
[null,"light blue cells",null,"  ",null,null,null,null,"SD of breeding objective"]
[2,"Nr of traits  ",null,null,null,"Parameters",null,null,null,1.9599563056882416]
[null,null,null,"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,2,{"$f":"IF($A6<=nt,SQRT(E6)*D6,\" \")","v":1.3693063937629151},{"$f":"IF($A6<=nt,H6*I6,\" \")","v":2.7386127875258302},1.5040106951871655,0.68769097056746986," "," "," "," "]
[2,"Feed","kg/day",2,0.2,0.5,0,-2,0.89442719099991586,-1.7888543819998317,1,0.31443850267379692," "," "," "," "]
["     ",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,{"$f":"IF(COLUMN(Z10)<=nt+3,COLUMN(Z10)-3,IF(Y10=nt,\"Correlation structure\",\"\"))","v":""}]
["",null,null,null,null,null,null,null," "," "," "," "," "," "," "," "]
[null,null,null,"Correlations",null,null,null,null,null,"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,null,null,null,null,0,0,0,0,0,50]
[{"$f":"IF(ROW(A15)<=nt+22,$B7,IF(A14=nt,\" Genetic Correlation   \",\"\"))","v":"Feed"},2,0.7,1,null,null,null,null,0,0,0,0,0,0]
[{"$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,"","  ","  ","  "]
[null,null,null,null,null,"SD Index","Accuracy of Index"]
["Results",null," ",null,null,1.3312659489764209,0.67923246304664164]
[null,"Trait","Genetic",null,"Response",null,"         Accuracy",null,null,null,"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":1.3693063937629151},1.2263811378144911,{"$f":"IF(ROW(A6)<=nt+5,C6,IF(A5=nt,\"     \",\"\"))","v":"kg/day"},2.4527622756289822,0.89562215103979814,0.89562215103979814,"-","-","-","-","-",1.7414820791886843]
[2,"Feed",0.89442719099991586,0.56074816332628052,"kg/day",-1.121496326652561,0.62693550572785883,0,"-","-","-","-","-","-"]
["     ","     "," "," ","     "," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
[]
[]
[]
[]
[null,null," Genetic Covariance matrix as given (correlations below diagonal)",null,null,null,null,null," Genetic Covariance matrix POSITIVE DEFINITE "]
[null,1.8749999999999993,0.8573214099741121,null,null,null,null,null,"   ","   ","   ","   ","   ","   "]
[null,0.7,0.79999999999999993,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,null,null,null,"   ","   ","   ","   ","   ","   "]
[]
[]
[]
[null,null," Residual Covariance matrix as given (correlations below diagonal) ",null,null,null,null,null," Residual Covariance matrix POSITIVE DEFINITE "]
[null,4.3750000000000009,1.1426785900258878,null,null,null,null,null,"  ","  ","  ","  ","  ","  "]
[null,0.30539369907705677,3.2,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,null,null,null,"  ","  ","  ","  ","  ","  "]

{"sheet":"MilkandFerility","index":3,"n_rows":51,"n_cols":26,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Input","Enter data only in"]
[null,"light blue cells",null,"  ",null,null,null,null,"SD of breeding objective"]
[2,"Nr of traits  ",null,null,null,"Parameters",null,null,null,94.603363420859864]
[null,null,null,"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":438.17804600413285},{"$f":"IF($A6<=nt,H6*I6,\" \")","v":87.635609200826579},154013.41898103053,-696.83262485065529," "," "," "," "]
[2,"Fertility","%",46,0.03,0.03,0,8,7.9674337148168357,63.739469718534686,-0.66653045811225553,7.096731746041991," "," "," "," "]
["     ",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,{"$f":"IF(COLUMN(Z10)<=nt+3,COLUMN(Z10)-3,IF(Y10=nt,\"Correlation structure\",\"\"))","v":""}]
["",null,null,null,null,null,null,null," "," "," "," "," "," "," "," "]
[null,null,null,"Correlations",null,null,null,null,null,"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,null,null,null,null,0,0,0,0,0,50]
[{"$f":"IF(ROW(A15)<=nt+22,$B7,IF(A14=nt,\" Genetic Correlation   \",\"\"))","v":"Fertility"},2,-0.25,1,null,null,null,null,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,"","  ","  ","  "]
[null,null,null,null,null,"SD Index","Accuracy of Index"]
["Results",null," ",null,null,66.218299521097734,0.69995713816763439]
[null,"Trait","Genetic",null,"Response",null,"         Accuracy",null,null,null,"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":438.17804600413285},380.98264346644834,{"$f":"IF(ROW(A6)<=nt+5,C6,IF(A5=nt,\"     \",\"\"))","v":"kg/lact"},76.196528693289665,0.89563007087722002,0.89562215103979825,"-","-","-","-","-",0.26769392681157422]
[2,"Fertility",7.9674337148168357,-1.2472786465239922,"%",-9.9782291721919378,0.33435724308844045,0.26506152350203105,"-","-","-","-","-",1.0783691676693627]
["     ","     "," "," ","     "," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
[]
[]
[]
[]
[null,null," Genetic Covariance matrix as given (correlations below diagonal)",null,null,null,null,null," Genetic Covariance matrix POSITIVE DEFINITE "]
[null,191999.99999999997,-872.78863420647269,null,null,null,null,null,"   ","   ","   ","   ","   ","   "]
[null,-0.25000000000000006,63.480000000000004,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,null,null,null,"   ","   ","   ","   ","   ","   "]
[]
[]
[]
[null,null," Residual Covariance matrix as given (correlations below diagonal) ",null,null,null,null,null," Residual Covariance matrix POSITIVE DEFINITE "]
[null,448000,-2807.2113657935274,null,null,null,null,null,"  ","  ","  ","  ","  ","  "]
[null,-9.2574720127566401E-2,2052.52,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,null,null,null,"  ","  ","  ","  ","  ","  "]

{"sheet":"exampleSelection","index":4,"n_rows":51,"n_cols":26,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Input","Enter data only in"]
[null,"light blue cells",null,"  ",null,null,null,null,"SD of breeding objective"]
[4,"Nr of traits  ",null,null,null,"Parameters",null,null,null,14.709149330682155]
[null,null,null,"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,3,4,"     ",""]
[{"$f":"IF(ROW(A6)<=nt+5,ROW(A6)-5,IF(A5=nt,\"     \",\"\"))","v":1},"Trait 1","kg",20.23,0.4,0.5,0,1,{"$f":"IF($A6<=nt,SQRT(E6)*D6,\" \")","v":12.794575413041263},{"$f":"IF($A6<=nt,H6*I6,\" \")","v":12.794575413041263},102.38594227893464,1.1905248666296926,1.1457891324364573,-3.3292260467141528," "," "]
[2,"Trait 2","mm",0.45,0.3,0.25,0,12,0.24647515087732474,2.9577018105278969,0.69749734844489308,2.8454534717511016E-2,3.4680269543852775E-2,-2.744619286953456E-2," "," "]
[3,"Trait 3","%",1,0.2,0.3,0,4,0.44721359549995793,1.7888543819998317,0.42936706265518249,0.77956245224079224,6.9552318859429252E-2,3.1899330685347053E-2," "," "]
[4,"Trait 4","score",3,0.1,0.2,0,2.5,0.94868329805051377,2.3717082451262845,-0.68975050615397837,-0.34109493970370219,0.25356813341649709,0.22754231918972348," "," "]
["     ",null,null,null,null,null,null,null," "," "," "," "," "," "," "," ",null,null,null,null,null,null,null,null,null,{"$f":"IF(COLUMN(Z10)<=nt+3,COLUMN(Z10)-3,IF(Y10=nt,\"Correlation structure\",\"\"))","v":""}]
["",null,null,null,null,null,null,null," "," "," "," "," "," "," "," "]
[null,null,null,"Correlations",null,null,null,null,null,"Number of records"]
["Correlation structure",null,{"$f":"IF(COLUMN(C13)<=nt+2,COLUMN(C13)-2,IF(B13=nt,\"Phenotypic\",\"\"))","v":1},2,3,4,"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,0.3,-0.2,null,null,1,1,1,0,0,5]
[{"$f":"IF(ROW(A15)<=nt+22,$B7,IF(A14=nt,\" Genetic Correlation   \",\"\"))","v":"Trait 2"},2,0.5,1,0.5,-0.1,null,null,1,1,1,0,0,0]
[{"$f":"IF(ROW(A16)<=nt+22,$B8,IF(A15=nt,\" Genetic Correlation   \",\"\"))","v":"Trait 3"},3,0.3,0.6,1,0.3,null,null,0,1,1,0,0,5]
[{"$f":"IF(ROW(A17)<=nt+22,$B9,IF(A16=nt,\" Genetic Correlation   \",\"\"))","v":"Trait 4"},4,-0.4,-0.2,0.5,1,null,null,0,1,0,0,0,0]
[{"$f":"IF(ROW(A18)<=nt+22,$B10,IF(A17=nt,\" Genetic Correlation   \",\"\"))","v":0}," Genetic   "]
[{"$f":"IF(ROW(A19)<=nt+13,$B11,IF(A18=nt,\" Genetic Correlation   \",\"\"))","v":""},""]
[null,"","  ","  ","  "]
[null,null,null,null,null,"SD Index","Accuracy of Index"]
["Results",null," ",null,null,11.507896089977574,0.78236312863946433]
[null,"Trait","Genetic",null,"Response",null,"         Accuracy",null,null,null,"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":12.794575413041263},9.8134647035791467,{"$f":"IF(ROW(A6)<=nt+5,C6,IF(A5=nt,\"     \",\"\"))","v":"kg"},9.8134647035791467,0.7908503066162258,0.77169010488506862,0.28224222468552324,0.11065130967461215,9.8503041153867071E-2,"-","-",0.39582593097024044]
[2,"Trait 2",0.24647515087732474,0.13921614052777928,"mm",1.6705936863333513,0.68438834206712107,0.61397341211598122,7.3327096420505686,3.0186842919232451,2.444058279688742,"-","-","-"]
[3,"Trait 3",0.44721359549995793,0.16683414188852971,"%",0.66733656755411885,0.58971314577271083,0.5218624584427537,"-",-0.43826486348809013,-1.7268202458430137E-2,"-","-",2.7043857187498057]
[4,"Trait 4",0.94868329805051377,-0.25739954699561801,"score",-0.64349886748904506,0.5028168643747869,0.15811388300841897,"-",0.24219774069388178,"-","-","-","-"]
["     ","     "," "," ","     "," "," "," "," "," "," "," "," "," "]
["",""," "," ",""," "," "," "," "," "," "," "," "," "]
[]
[]
[]
[]
[null,null," Genetic Covariance matrix as given (correlations below diagonal)",null,null,null,null,null," Genetic Covariance matrix POSITIVE DEFINITE "]
[null,163.70116000000002,1.5767724526703275,1.7165724220084626,-4.8552000000000008,null,null,null,"   ","   ","   ","   ","   ","   "]
[null,0.5,6.0749999999999998E-2,6.6136223055145799E-2,-4.676537180435969E-2,null,null,null,"   ","   ","   ","   ","   ","   "]
[null,0.3,0.6,0.19999999999999998,0.21213203435596426,null,null,null,"   ","   ","   ","   ","   ","   "]
[null,-0.40000000000000008,-0.2,0.50000000000000011,0.89999999999999991,null,null,null,"   ","   ","   ","   ","   ","   "]
[null,null,null,null,null,null,null,null,"   ","   ","   ","   ","   ","   "]
[null,null,null,null,null,null,null,null,"   ","   ","   ","   ","   ","   "]
[]
[]
[]
[null,null," Residual Covariance matrix as given (correlations below diagonal) ",null,null,null,null,null," Residual Covariance matrix POSITIVE DEFINITE "]
[null,245.55174,-0.6664224526703274,4.3524275779915378,-7.2828000000000008,null,null,null,"  ","  ","  ","  ","  ","  "]
[null,-0.11295789195033247,0.14175000000000001,0.15886377694485421,-8.8234628195640319E-2,null,null,null,"  ","  ","  ","  ","  ","  "]
[null,0.31053821475306048,0.47175700356866784,0.8,0.68786796564403563,null,null,null,"  ","  ","  ","  ","  ","  "]
[null,-0.16329931618554522,-8.2344579622543934E-2,0.27022005725994042,8.1,null,null,null,"  ","  ","  ","  ","  ","  "]
[null,null,null,null,null,null,null,null,"  ","  ","  ","  ","  ","  "]
[null,null,null,null,null,null,null,null,"  ","  ","  ","  ","  ","  "]