{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["STSELIND","STSELINDMBV","PseudoBLUP","About","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":3,"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":"STSELIND","index":0,"n_rows":57,"n_cols":19,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Single Trait selection index calculation"]
["Parameters"]
["Heritability",0.25]
["Repeatability of subsequent records",0.5]
["c-squared (among full sibs)",0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(0.4)","v":0.63245553203367588}]
[null,null,null,null,null,null,null,null,"Accuracy of EBV",0.63245553203367588]
[null," ",null,"Index",null,"value of"]
["Information used","Nr.Records",null,"weight",null,"variate:"]
["nr of own records ",0,null,"-","-","-"]
["nr. of records on dam",0,null,"-","-","-"]
["nr of records on sire",0,null,"-","-","-"]
["nr of full sib records",0,null,"-","-","-",null,null,"correlation EBV FS",0.20000000000000004]
["nr. of half sib records (excl. full sibs)",0,null,"-","-","-",null,null,"correlation EBV HS",0.10000000000000002," "," "," "," "," "," "]
["nr. of progeny",10,null,0.8,"Prog",1]
[]
[null,null,null,null," "," "," "," "," "," "]
[null,null,"P-matrix",null,null,null,null,null,null,"G-Matrix",null,"b",null,"accuracy"]
[null,"Prog",0.15625,null,null,null,null,null,null,0.125,"Prog",0.8,null,0.63245553203367588]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Covariance Matrix of information sources of Full Sibs"]
["nr of FS groups per sire","Prog",3.125E-2]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"109000/28","v":3892.8571428571427}]
["size of FS groups"]
[1]
[]
["corr EBV FS"]
[0.20000000000000004]
[]
[]
["size of HS groups","Prog",1.5625E-2]
[1]
[]
["corr EBV HS"]
[0.10000000000000002]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"yes"]
[null,"no"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"STSELINDMBV","index":1,"n_rows":444,"n_cols":20,"rows_kept":444,"cut":false,"hidden":false,"merged":[]}
["Single Trait selection index calculation using genomic testing"]
["Parameters"]
["Heritability",0.5]
["Repeatability of subsequent records",0.5]
["c-squared (among full sibs)",0.15,null,null,0.31311214554257477]
["Reliability of genomic test (prop expl)",0.25,null,null,null,null,null,null,"Accurcay of EBV",0.54772255750516607]
[null," ",null,"              Index Wght",null,"     Value of Variate"]
["Information used","Nr.Records","Genotyped","Pheno","Geno","Pheno","Geno",null,"Accuracy of Pheno EBV",0.54772255750516607]
["nr of own records ",0,0,"-","-","-","-",null,"Accuracy of MBV",0]
["nr. of records on dam",0,0,"-","-","-","-"]
["nr of records on sire",0,0,"-","-","-","-"]
["nr of fulls sib records",0,0,"-","-","-","-",null,"correlation EBV FS",0.15]
["nr. of half sib records (excl. full sibs)",0,0,"-","-","-","-",null,"correlation EBV HS",7.4999999999999997E-2]
["nr. of progeny",3,0,0.6,"-",1,"-"]
[]
[null,null,null,null,null," "," "," "," "," "]
[null,null,"P-matrix",null,null,null,null,null,null,null,null,null,null,null,"G-Matrix",null,"b",null,"accuracy"]
[null,"Prog",0.41666666666666669,null,null,null,null,null,null,null,null,null,null,null,0.25,"Prog",0.6,null,0.54772255750516607]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variance=Covariance matrix of Pheno-DNA EBV's (correlation below diag)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.29773460709496619,0.12491903069810963]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.83104051351374197,7.588981621652649E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Covariance Matrix of information sources of Full Sibs"]
["nr of FS groups per sire","Prog",6.25E-2]
[1]
["size of FS groups"]
[1]
[]
["corr EBV FS"]
[0.15]
[]
[]
[]
[]
[]
[]
[null,null,"Covariance Matrix of information sources of Half Sibs"]
["size of HS groups","Prog",3.125E-2]
[1]
[]
["corr EBV HS"]
[7.4999999999999997E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"sum Vofv",{"$f":"SUM(E9:E15)","v":0}]
[null,null,null,null,null,null,null,null,"own",{"$f":"(E9/$J$63)*$D$6","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,"dam",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,"sire",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,"FS",{"$error":"#VALUE!"}]
[null,"yes",null,null,null,null,null,null,"HS",{"$error":"#VALUE!"}]
[null,"no",null,null,null,null,null,null,"prog",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,"DNAtest",{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,"unexpl",{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,0.25]
[null,0.5]
[null,0.15]
[null,0.5]
[]
[]
[null,0,0]
[null,0,0]
[null,0,0]
[null,2,0]
[null,0,0]
[null,0,0]

{"sheet":"PseudoBLUP","index":2,"n_rows":57,"n_cols":19,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Single Trait calculation of BLUP EBV  ",null,null,null,null,null,null,null,null,"nr iter","iteration","accuracy"]
["Parameters",null,null,null,null,null,null,null,null,8,1,0.6486514285812981]
["Heritability",0.25,null,null,null,null,null,null,null,null,2,0.68882242557488982]
["Repeatability of subsequent records",0.25,null,null,null,null,null,null,null,null,3,0.63270419151693102]
["c-squared (among full sibs)",0,null,null,null,null,null,null,null,null,4,0.58548191681840944]
["selected proportion males",0.05,null,null,null,null,null,null,"SD of BV",{"$f":"SQRT(J7)","v":0.44424304355204108},5,0.58234966265317012]
["selected proportion females",0.5,"Index",null,null,"value of",null,null,"Equilibrium Va",0.19735188174438067,6,0.595680484010083]
["Information used","Nr.Records","weight",null,null,"variate:",null,null,"Equilibrium h2",0.20831951204972765,7,0.60349529756316667]
["nr of own records ",1,0.16843936694532605,1,"own",0.19754585046060402,null,null,"SD of EBV",0.26807801730798314,8,0.60344899306583966]
["nr. of dams per sire",20,0.30066030813051287,1,"dam",1.584526268935238E-2,null,null,"Accuracy of EBV",0.60344899306583966]
["nr of progeny per dam",10,5.0276691386083316E-2,1,"sire",1.8153625070060908E-4]
["nr. of progeny",0,0.23024001679364831,9,"FS",5.0290721803925131E-2,null,null,"correlation EBV FS",0.55076187072654592]
["recorded on","both sexes",0.5007672334888591,190,"HS",5.6808982693893784E-2,null,null,"correlation EBV HS",0.4323467682418497," "," "," "," "," "]
[null,null,-0.25038361674442955,20,"Mates",5.9768930221903993E-4]
[null,null,0.43693547139297101,"-","-","-"]
[null,null,null,null," "," "," "," "," "," "]
[null,null,"P-matrix",null,null,null,null,null,null,"G-Matrix",null,"b",null,"accuracy"]
[null,"own",0.94819534857277377,1.315639493112742E-2,5.5360689071305346E-3,7.3195348572773766E-2,3.4737666302666149E-2,0,null,0.19819534857277377,"own",0.16843936694532605,null,0.60344899306583966]
[null,"dam",1.315639493112742E-2,2.631278986225484E-2,0,1.315639493112742E-2,0,0,null,1.315639493112742E-2,"dam",0.30066030813051287]
[null,"sire",5.5360689071305346E-3,0,1.1072137814261069E-2,5.5360689071305346E-3,5.5360689071305346E-3,0,null,5.5360689071305346E-3,"sire",5.0276691386083316E-2]
[null,"FS",7.3195348572773766E-2,1.315639493112742E-2,5.5360689071305346E-3,0.17041757079499598,3.4737666302666149E-2,0,null,7.3195348572773766E-2,"FS",0.23024001679364831]
[null,"HS",3.4737666302666149E-2,0,5.5360689071305346E-3,3.4737666302666149E-2,4.1503346031164512E-2,6.924418384803905E-4,null,3.4737666302666149E-2,"HS",0.5007672334888591]
[null,"Mates",0,0,0,0,6.924418384803905E-4,1.384883676960781E-3,null,0,"Mates",-0.25038361674442955]
[]
[]
[null,null,"Covariance Matrix of information sources of Full Sibs"]
["nr of FS groups per sire","own",0,1.315639493112742E-2,5.5360689071305346E-3,6.5062532064687789E-2,3.4737666302666149E-2,4.9548837143193442E-2]
[20,"dam",1.315639493112742E-2,2.631278986225484E-2,0,1.315639493112742E-2,0,0]
["size of FS groups","sire",5.5360689071305346E-3,0,1.1072137814261069E-2,5.5360689071305346E-3,5.5360689071305346E-3,0]
[10,"FS",6.5062532064687789E-2,1.315639493112742E-2,5.5360689071305346E-3,0.15961510165919351,3.4737666302666149E-2,0]
[null,"HS",3.4737666302666149E-2,0,5.5360689071305346E-3,3.4737666302666149E-2,4.1503346031164512E-2,6.924418384803905E-4]
["corr EBV FS","Mates",4.9548837143193442E-2,0,0,0,6.924418384803905E-4,1.384883676960781E-3]
[0.55076187072654592]
[]
[]
["size of HS groups","own",0,0,5.5360689071305346E-3,3.4737666302666149E-2,3.4737666302666149E-2,0]
[200,"dam",0,0,0,1.315639493112742E-2,0,0]
[null,"sire",5.5360689071305346E-3,0,1.1072137814261069E-2,5.5360689071305346E-3,5.5360689071305346E-3,0]
["corr EBV HS","FS",3.4737666302666149E-2,1.315639493112742E-2,5.5360689071305346E-3,3.4737666302666149E-2,3.4737666302666149E-2,0]
[0.4323467682418497,"HS",3.4737666302666149E-2,0,5.5360689071305346E-3,3.4737666302666149E-2,4.1478042494259522E-2,6.924418384803905E-4]
[null,"Mates",0,0,0,0,6.924418384803905E-4,1.384883676960781E-3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"both sexes"]
[null,"females only"]
[null,"males only"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"About","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"These spreadsheets are developed by Julius van der Werf, Uiversity of New England, Armidale"]
[]
[null,null,null,"contact: jvanderw@une.edu.au"]
[]
[]
[]
[null,"STSELIND","simple selection index based on max6 information sources"]
[]
[]
[null,"STSELTMBV","as STSELIND but additionally one can have genomic predictions for the traits on candidatse or relatives"]
[]
[null,"PseudoBLUP","Predicting PseudoBLUP EBV accurcay"]
[null,null,null,"iterating on STSELIND and assuming prents an EBV accurcay based on their parents and sibs"]
[null,null,null,"Also allowing animals to have progney records (but note that the procedure does iterate without progeny records on animal,  to get parental EBV accuracies without prgeny means. Just leaving candidates OP out in last iteration round."]
[null,null,null,"Also allowing animals to have no own performance (but note that the procedure does iterate with own OP on animal,  to get parental EBV accuracies with own EBV. Just adding in candidates progeny   in last iteration round."]

{"sheet":"Sheet3","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}