{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["STSELIND","STSELINDMBV","PseudoBLUP (2)","PseudoBLUP","example covarstructure","About","Sheet3","Sheet1"],"not_rendered":{"macros":1,"defined_names":6,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"STSELIND","index":0,"n_rows":57,"n_cols":19,"rows_kept":57}
["Single Trait selection index calculation"]
["Parameters"]
["Heritability",0.1]
["Repeatability of subsequent records",0.5]
["c-squared (among full sibs)",0]
[{"$nulls":8},"Accuracy of EBV",{"v":0.5289536721718543,"d":"0.5290"}]
[null," ",null,"Index",null,"value of"]
["Information used","Nr.Records",null,"weight",null,"variate:"]
["nr of own records ",1,null,{"v":0.08002311252176784,"d":"0.080"},"own",{"v":0.11903669937562056,"d":"12%"}]
["nr. of records on dam",1,null,{"v":0.04189011433775171,"d":"0.042"},"dam",{"v":0.03156772113568296,"d":"3%"}]
["nr of records on sire",1,null,{"v":0.015936456541535984,"d":"0.016"},"sire",{"v":0.004249932946285617,"d":"0%"}]
["nr of full sib records",3,null,{"v":0.08217460072319827,"d":"0.082"},"FS",{"v":0.04275657764954088,"d":"4%"},null,null,"correlation EBV FS",{"v":0.9314205649748141,"d":"0.931"}]
["nr. of half sib records (excl. full sibs)",76,null,{"v":0.5190731559243145,"d":"0.519"},"HS",{"v":0.1829690138462554,"d":"18%"},null,null,"correlation EBV HS",{"v":0.6063132121799819,"d":"0.606"}," "," "," "," "," "," "]
["nr. of progeny",0,"-","-","-","-"]
[]
[{"$nulls":4}," "," "," "," "," "," "]
[null,null,"P-matrix",{"$nulls":6},"G-Matrix",null,"b",null,"accuracy"]
[null,"own",{"v":1,"d":"1.0000"},{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"},{"v":0.025,"d":"0.0250"},null,null,{"v":0.1,"d":"0.100"},"own",{"v":0.08002311252176784,"d":"0.080"},null,{"v":0.5289536721718543,"d":"0.5290"}]
[null,"dam",{"v":0.05,"d":"0.0500"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":0.05,"d":"0.0500"},{"v":0,"d":"0.0000"},null,null,{"v":0.05,"d":"0.050"},"dam",{"v":0.04189011433775171,"d":"0.042"}]
[null,"sire",{"v":0.05,"d":"0.0500"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.0000"},{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"},null,null,0.05,"sire",{"v":0.015936456541535984,"d":"0.016"}]
[null,"FS",{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"},{"v":0.36666666666666664,"d":"0.3667"},{"v":0.025,"d":"0.0250"},null,null,0.05,"FS",{"v":0.08217460072319827,"d":"0.082"}]
[null,"HS",{"v":0.025,"d":"0.0250"},{"v":0,"d":"0.0000"},{"v":0.05,"d":"0.0500"},{"v":0.025,"d":"0.0250"},{"v":0.03881578947368421,"d":"0.0388"},null,null,0.025,"HS",{"v":0.5190731559243145,"d":"0.519"}]
[]
[]
[]
[null,null,"Covariance Matrix of information sources of Full Sibs"]
["nr of FS groups per sire","own",{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"},{"v":0.3666666666666667,"d":"0.3667"},{"v":0.025,"d":"0.0250"}]
[20,"dam",{"v":0.05,"d":"0.0500"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":0.05,"d":"0.0500"},{"v":0,"d":"0.0000"}]
["size of FS groups","sire",{"v":0.05,"d":"0.0500"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.0000"},{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"}]
[4,"FS",{"v":0.3666666666666667,"d":"0.3667"},{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"},{"v":0.36666666666666664,"d":"0.3667"},{"v":0.025,"d":"0.0250"}]
[null,"HS",{"v":0.025,"d":"0.0250"},{"v":0,"d":"0.0000"},{"v":0.05,"d":"0.0500"},{"v":0.025,"d":"0.0250"},{"v":0.03881578947368421,"d":"0.0388"}]
["corr EBV FS"]
[{"v":0.9314205649748141,"d":"0.931"}]
[]
[]
["size of HS groups","own",{"v":0.025,"d":"0.0250"},{"v":0,"d":"0.0000"},{"v":0.05,"d":"0.0500"},{"v":0.025,"d":"0.0250"},{"v":0.025,"d":"0.0250"}]
[80,"dam",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0.05,"d":"0.0500"},{"v":0,"d":"0.0000"}]
[null,"sire",{"v":0.05,"d":"0.0500"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.0000"},{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"}]
["corr EBV HS","FS",{"v":0.025,"d":"0.0250"},{"v":0.05,"d":"0.0500"},{"v":0.05,"d":"0.0500"},{"v":0.025,"d":"0.0250"},{"v":0.025,"d":"0.0250"}]
[{"v":0.6063132121799819,"d":"0.606"},"HS",{"v":0.025,"d":"0.0250"},{"v":0,"d":"0.0000"},{"v":0.05,"d":"0.0500"},{"v":0.025,"d":"0.0250"},{"v":0.03864698753462604,"d":"0.0386"}]
{"$rows_empty":12}
[null,"yes"]
[null,"no"]
[]
[]
[{"$nulls":18}," "]

{"sheet":"STSELINDMBV","index":1,"n_rows":72,"n_cols":20,"rows_kept":72}
["Single Trait selection index calculation using genomic testing"]
["Parameters"]
["Heritability",0.25]
["Repeatability of subsequent records",0.5]
["c-squared (among full sibs)",0.15]
["Reliability of genomic test (prop expl)",0.090909,{"$nulls":6},"Accurcay of EBV",{"v":0.6011690876522756,"d":"0.6012"}]
[null," ",null,"              Index Wght",null,"     Value of Variate"]
["Information used","Nr.Records","Genotyped","Pheno","Geno","Pheno","Geno",null,"Accuracy of Pheno EBV",{"v":0.5976328264696248,"d":"0.598"}]
["nr of own records ",1,0,{"v":0.20130768566082574,"d":"0.201"},"-",{"v":0.21796340179101803,"d":"21.8%"},"-",null,"Accuracy of MBV",{"v":0.15075228039402291,"d":"0.151"}]
["nr. of records on dam",1,0,{"v":0.09261306615305244,"d":"0.093"},"-",{"v":0.04705312733004541,"d":"4.7%"},"-"]
["nr of records on sire",1,1,{"v":0.06688635348544879,"d":"0.067"},{"v":0.22071199578953815,"d":"0.221"},{"v":0.02256186329546539,"d":"2.3%"},{"v":0.005882307083454719,"d":"0.6%"}]
["nr of fulls sib records",2,0,{"v":0.05778778511475506,"d":"0.058"},"-",{"v":0.009983492122736304,"d":"1.0%"},"-",null,"correlation EBV FS",{"v":0.7614668579126037,"d":"0.761"}]
["nr. of half sib records (excl. full sibs)",9,0,{"v":0.1656825219944005,"d":"0.166"},"-",{"v":0.02945652862600434,"d":"2.9%"},"-",null,"correlation EBV HS",{"v":0.35349893551068434,"d":"0.353"}]
["nr. of progeny",0,0,"-","-","-","-"]
[]
[{"$nulls":5}," "," "," "," "," "]
[null,null,"P-matrix",{"$nulls":11},"G-Matrix",null,"b",null,"accuracy"]
[null,"own",{"v":1,"d":"1.0000"},{"v":0.125,"d":"0.1250"},{"v":0.125,"d":"0.1250"},{"v":0.275,"d":"0.2750"},0.0625,{"v":0.011363625,"d":"0.0114"},{"$nulls":6},{"v":0.25,"d":"0.250"},"own",{"v":0.20130768566082574,"d":"0.201"},null,{"v":0.6011690876522756,"d":"0.6012"}]
[null,"dam",{"v":0.125,"d":"0.1250"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":0.125,"d":"0.1250"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"$nulls":6},0.125,"dam",{"v":0.09261306615305244,"d":"0.093"}]
[null,"sire",{"v":0.125,"d":"0.1250"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.0000"},{"v":0.125,"d":"0.1250"},{"v":0.125,"d":"0.1250"},{"v":0.022728250000000002,"d":"0.0227"},{"$nulls":6},0.125,"sire",{"v":0.06688635348544879,"d":"0.067"},null,"Variance=Covariance matrix of Pheno-DNA EBV's (correlation below diag)"]
[null,"FS",{"v":0.275,"d":"0.2750"},{"v":0.125,"d":"0.1250"},{"v":0.125,"d":"0.1250"},0.6375,0.0625,{"v":0.011363625,"d":"0.0114"},{"$nulls":6},0.125,"FS",{"v":0.05778778511475506,"d":"0.058"},null,{"v":0.2977346070949662,"d":"0.29773"},{"v":0.12491903069810963,"d":"0.12492"}]
[null,"HS",0.0625,{"v":0,"d":"0.0000"},{"v":0.125,"d":"0.1250"},0.0625,{"v":0.2138888888888889,"d":"0.2139"},{"v":0.011363625,"d":"0.0114"},{"$nulls":6},0.0625,"HS",{"v":0.1656825219944005,"d":"0.166"},null,{"v":0.831040513513742,"d":"0.83104"},{"v":0.07588981621652649,"d":"0.07589"}]
[null,"sire DNA",{"v":0.011363625,"d":"0.0114"},{"v":0,"d":"0.0000"},{"v":0.022728250000000002,"d":"0.0227"},{"v":0.011363625,"d":"0.0114"},{"v":0.011363625,"d":"0.0114"},{"v":0.022728250000000002,"d":"0.0227"},{"$nulls":6},0.011363625,"sire DNA",{"v":0.22071199578953815,"d":"0.2207"}]
{"$rows_empty":7}
[null,null,"Covariance Matrix of information sources of Full Sibs"]
["nr of FS groups per sire","own",{"v":0.275,"d":"0.2750"},{"v":0.125,"d":"0.1250"},{"v":0.125,"d":"0.1250"},0.6375,0.0625,{"v":0.011363625,"d":"0.0114"}]
[4,"dam",{"v":0.125,"d":"0.1250"},{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":0.125,"d":"0.1250"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
["size of FS groups","sire",{"v":0.125,"d":"0.1250"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.0000"},{"v":0.125,"d":"0.1250"},{"v":0.125,"d":"0.1250"},{"v":0.022728250000000002,"d":"0.0227"}]
[3,"FS",0.6375,{"v":0.125,"d":"0.1250"},{"v":0.125,"d":"0.1250"},{"v":0.45624999999999993,"d":"0.4563"},0.0625,{"v":0.011363625,"d":"0.0114"}]
[null,"HS",0.0625,{"v":0,"d":"0.0000"},{"v":0.125,"d":"0.1250"},0.0625,{"v":0.2138888888888889,"d":"0.2139"},{"v":0.011363625,"d":"0.0114"}]
["corr EBV FS","sire DNA",{"v":0.011363625,"d":"0.0114"},{"v":0,"d":"0.0000"},{"v":0.022728250000000002,"d":"0.0227"},{"v":0.011363625,"d":"0.0114"},{"v":0.011363625,"d":"0.0114"},{"v":0.022728250000000002,"d":"0.0227"}]
[{"v":0.7614668579126037,"d":"0.761"}]
[]
[]
[]
[]
[]
[]
[null,null,"Covariance Matrix of information sources of Half Sibs"]
["size of HS groups","own",0.0625,{"v":0,"d":"0.0000"},{"v":0.125,"d":"0.1250"},0.0625,0.0625,{"v":0.011363625,"d":"0.0114"}]
[12,"dam",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0.125,"d":"0.1250"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"sire",{"v":0.125,"d":"0.1250"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.0000"},{"v":0.125,"d":"0.1250"},{"v":0.125,"d":"0.1250"},{"v":0.022728250000000002,"d":"0.0227"}]
["corr EBV HS","FS",0.0625,{"v":0.125,"d":"0.1250"},{"v":0.125,"d":"0.1250"},0.0625,0.0625,{"v":0.011363625,"d":"0.0114"}]
[{"v":0.35349893551068434,"d":"0.353"},"HS",0.0625,{"v":0,"d":"0.0000"},{"v":0.125,"d":"0.1250"},0.0625,{"v":0.20231481481481484,"d":"0.2023"},{"v":0.011363625,"d":"0.0114"}]
[null,"sire DNA",{"v":0.011363625,"d":"0.0114"},{"v":0,"d":"0.0000"},{"v":0.022728250000000002,"d":"0.0227"},{"v":0.011363625,"d":"0.0114"},{"v":0.011363625,"d":"0.0114"},{"v":0.022728250000000002,"d":"0.0227"}]
{"$rows_empty":11}
[{"$nulls":8},"sum Vofv",{"$f":"SUM(E9:E15)","v":{"v":0.22071199578953815,"d":"0.221"}}]
[{"$nulls":8},"own",{"$f":"(E9/$J$63)*$D$6","v":{"$error":"#VALUE!"}}]
[{"$nulls":8},"dam",{"$error":"#VALUE!"}]
[{"$nulls":8},"sire",0]
[{"$nulls":8},"FS",{"$error":"#VALUE!"}]
[null,"yes",{"$nulls":6},"HS",{"$error":"#VALUE!"}]
[null,"no",{"$nulls":6},"prog",{"$error":"#VALUE!"}]
[{"$nulls":8},"DNAtest",0]
[{"$nulls":8},"unexpl",0]
[{"$nulls":18}," "]

{"sheet":"PseudoBLUP (2)","index":2,"n_rows":57,"n_cols":19,"rows_kept":57}
["Single Trait calculation of BLUP EBV  ",{"$nulls":8},"nr iter","iteration","accuracy"]
["Parameters",{"$nulls":8},8,1,{"v":0.5491312481680862,"d":"0.54913"}]
["Heritability",0.25,{"$nulls":8},2,{"v":0.5703139012930576,"d":"0.57031"}]
["Repeatability of subsequent records",0.25,{"$nulls":8},3,{"v":0.5396336556585964,"d":"0.53963"}]
["c-squared (among full sibs)",0,{"$nulls":8},4,{"v":0.5166098365734711,"d":"0.51661"}]
["selected proportion males",{"v":0.02,"d":"2%"},{"$nulls":6},"SD of BV",{"$f":"SQRT(J7)","v":{"v":0.44891805313068306,"d":"0.449"}},5,{"v":0.513643715005614,"d":"0.51364"}]
["selected proportion females",{"v":0.02,"d":"2%"},"Index",null,null,"value of",null,null,"Equilibrium Va",{"v":0.2015274184266428,"d":"0.202"},6,{"v":0.5182279600277712,"d":"0.51823"}]
["Information used","Nr.Records","weight",null,null,"variate:",null,null,"Equilibrium h2",{"v":0.2117936010292481,"d":"0.212"},7,{"v":0.5213895191050992,"d":"0.52139"}]
["nr of own records ",0,"-","-","-","-",null,null,"SD of EBV",{"v":0.13812514377097296,"d":"0.138"},8,{"v":0.3076845379857419,"d":"0.30768"},"w/o own"]
["nr. of dams per sire",20,{"v":0.5,"d":"0.500"},"EBV","dam",{"v":0.0407843984390891,"d":"4%"},null,null,"Accuracy of EBV",{"v":0.3076845379857419,"d":"0.3077"}]
["nr of progeny per dam",1,{"v":0.2827159324448124,"d":"0.283"},"EBV","sire",{"v":0.01262777305964602,"d":"1%"}]
["nr. of progeny",0,"-","-","-","-",null,null,"correlation EBV FS",{"v":1,"d":"1.000"}]
["recorded on","both sexes",{"v":0.43456813511037523,"d":"0.435"},19,"HS",{"v":0.6002364956073659,"d":"60%"},null,null,"correlation EBV HS",{"v":0.8950491003691007,"d":"0.895"},null,null," "," "," "]
[null,null,{"v":-0.21728406755518767,"d":"-0.217"},20,"Mates",{"v":3.9681153632042943E-4,"d":"0%"}]
[null,null,"-","-","-","-",null,"With Bulmer Correction"]
[{"$nulls":4}," "," "," ",null," "," "]
[null,null,"P-matrix",{"$nulls":6},"G-Matrix",null,"b",null,"accuracy"]
[null,"dam",{"v":0.006097920652241267,"d":"0.0061"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"$nulls":3},{"v":3.0489603261206334E-3,"d":"0.0030"},"dam",{"v":0.5,"d":"0.500"},null,{"v":0.3076845379857419,"d":"0.3077"}]
[null,"sire",{"v":0,"d":"0.0000"},{"v":0.006097920652241267,"d":"0.0061"},{"v":3.0489603261206334E-3,"d":"0.0030"},{"v":0,"d":"0.0000"},{"$nulls":3},{"v":3.0489603261206334E-3,"d":"0.0030"},"sire",{"v":0.2827159324448124,"d":"0.283"}]
[null,"HS",{"v":0,"d":"0.0000"},{"v":3.0489603261206334E-3,"d":"0.0030"},{"v":0.08648499399625212,"d":"0.0865"},{"v":1.6047159611161228E-4,"d":"0.0002"},{"$nulls":3},{"v":0.038410744296439515,"d":"0.0384"},"HS",{"v":0.43456813511037523,"d":"0.435"}]
[null,"Mates",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":1.6047159611161228E-4,"d":"0.0002"},{"v":3.2094319222322455E-4,"d":"0.0003"},{"$nulls":3},{"v":0,"d":"0.0000"},"Mates",{"v":-0.21728406755518767,"d":"-0.217"}]
[]
[]
[]
[]
[null,null,"Covariance Matrix of information sources of Full Sibs"]
["nr of FS groups per sire","dam",{"v":0.006097920652241267,"d":"0.0061"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[20,"sire",{"v":0,"d":"0.0000"},{"v":0.006097920652241267,"d":"0.0061"},{"v":3.0489603261206334E-3,"d":"0.0030"},{"v":0,"d":"0.0000"}]
["size of FS groups","HS",{"v":0,"d":"0.0000"},{"v":3.0489603261206334E-3,"d":"0.0030"},{"v":0.08648499399625212,"d":"0.0865"},{"v":1.6047159611161228E-4,"d":"0.0002"}]
[1,"Mates",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":1.6047159611161228E-4,"d":"0.0002"},{"v":3.2094319222322455E-4,"d":"0.0003"}]
[]
["corr EBV FS"]
[{"v":1,"d":"1.000"}]
[]
[]
["size of HS groups","dam",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[20,"sire",{"v":0,"d":"0.0000"},{"v":0.006097920652241267,"d":"0.0061"},{"v":3.0489603261206334E-3,"d":"0.0030"},{"v":0,"d":"0.0000"}]
[null,"HS",{"v":0,"d":"0.0000"},{"v":3.0489603261206334E-3,"d":"0.0030"},{"v":0.08395477032784093,"d":"0.0840"},{"v":1.6047159611161228E-4,"d":"0.0002"}]
["corr EBV HS","Mates",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":1.6047159611161228E-4,"d":"0.0002"},{"v":3.2094319222322455E-4,"d":"0.0003"}]
[{"v":0.8950491003691007,"d":"0.895"}]
{"$rows_empty":12}
[null,"both sexes"]
[null,"females only"]
[null,"males only"]
[]
[{"$nulls":18}," "]

{"sheet":"PseudoBLUP","index":3,"n_rows":57,"n_cols":19,"rows_kept":57}
["Single Trait calculation of BLUP EBV  ",{"$nulls":8},"nr iter","iteration","accuracy"]
["Parameters",{"$nulls":8},8,1,{"v":0.5444720180098439,"d":"0.54447"}]
["Heritability",0.25,{"$nulls":8},2,{"v":0.5634131470875748,"d":"0.56341"}]
["Repeatability of subsequent records",0.25,{"$nulls":8},3,{"v":0.5358553209344005,"d":"0.53586"}]
["c-squared (among full sibs)",0.15,{"$nulls":8},4,{"v":0.5152502831598459,"d":"0.51525"}]
["selected proportion males",{"v":0.05,"d":"5%"},{"$nulls":6},"SD of BV",{"$f":"SQRT(J7)","v":{"v":0.45334426104677406,"d":"0.453"}},5,{"v":0.5117572079357972,"d":"0.51176"}]
["selected proportion females",{"v":0.25,"d":"25%"},"Index",null,null,"value of",null,null,"Equilibrium Va",{"v":0.20552101902404563,"d":"0.206"},6,{"v":0.5150741393247843,"d":"0.51507"}]
["Information used","Nr.Records","weight",null,null,"variate:",null,null,"Equilibrium h2",{"v":0.21508791008486827,"d":"0.215"},7,{"v":0.5177131963564605,"d":"0.51771"}]
["nr of own records ",0,"-","-","-","-",null,null,"SD of EBV",{"v":0.16148380334221252,"d":"0.161"},8,{"v":0.3562056856512215,"d":"0.35621"},"w/o own"]
["nr. of dams per sire",5,{"v":0.41753520876659905,"d":"0.418"},"EBV","dam",{"v":0.04518436731139264,"d":"5%"},null,null,"Accuracy of EBV",{"v":0.3562056856512215,"d":"0.3562"}]
["nr of progeny per dam",8,{"v":0.3063322387255144,"d":"0.306"},"EBV","sire",{"v":0.013574062480356863,"d":"1%"}]
["nr. of progeny",0,{"v":0.1649295824668019,"d":"0.165"},4,"FS",{"v":0.23435148780743376,"d":"23%"},null,null,"correlation EBV FS",{"v":1,"d":"1.000"}]
["recorded on","females only",{"v":0.22240594008216955,"d":"0.222"},16,"HS",{"v":0.14103868217325,"d":"14%"},null,null,"correlation EBV HS",{"v":0.5157740361247454,"d":"0.516"},null,null," "," "," "]
[null,null,{"v":-0.11120297004108479,"d":"-0.111"},5,"Mates",{"v":9.80272395704751E-4,"d":"0%"}]
[null,null,"-","-","-","-",null,"With Bulmer Correction"]
[{"$nulls":4}," "," "," ",null," "," "]
[null,null,"P-matrix",{"$nulls":6},"G-Matrix",null,"b",null,"accuracy"]
[null,"dam",{"v":0.01332284948117657,"d":"0.0133"},{"v":0,"d":"0.0000"},{"v":0.006661424740588285,"d":"0.0067"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},null,null,{"v":0.006661424740588285,"d":"0.0067"},"dam",{"v":0.41753520876659905,"d":"0.418"},null,{"v":0.3562056856512215,"d":"0.3562"}]
[null,"sire",{"v":0,"d":"0.0000"},{"v":0.007612959440255115,"d":"0.0076"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":0,"d":"0.0000"},null,null,{"v":3.8064797201275576E-3,"d":"0.0038"},"sire",{"v":0.3063322387255144,"d":"0.306"}]
[null,"FS",{"v":0.006661424740588285,"d":"0.0067"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":0.41195994293399446,"d":"0.4120"},{"v":0.039648827389730974,"d":"0.0396"},{"v":0,"d":"0.0000"},null,null,{"v":0.08070994293399447,"d":"0.0807"},"FS",{"v":0.1649295824668019,"d":"0.165"}]
[null,"HS",{"v":0,"d":"0.0000"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":0.039648827389730974,"d":"0.0396"},{"v":0.14466792599731332,"d":"0.1447"},{"v":0.002081695231433839,"d":"0.0021"},null,null,{"v":0.039648827389730974,"d":"0.0396"},"HS",{"v":0.22240594008216955,"d":"0.222"}]
[null,"Mates",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0.002081695231433839,"d":"0.0021"},{"v":0.004163390462867678,"d":"0.0042"},null,null,{"v":0,"d":"0.0000"},"Mates",{"v":-0.11120297004108479,"d":"-0.111"}]
[]
[]
[]
[null,null,"Covariance Matrix of information sources of Full Sibs"]
["nr of FS groups per sire","dam",{"v":0.01332284948117657,"d":"0.0133"},{"v":0,"d":"0.0000"},{"v":0.006661424740588285,"d":"0.0067"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[5,"sire",{"v":0,"d":"0.0000"},{"v":0.007612959440255115,"d":"0.0076"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":0,"d":"0.0000"}]
["size of FS groups","FS",{"v":0.006661424740588285,"d":"0.0067"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":0.41195994293399446,"d":"0.4120"},{"v":0.039648827389730974,"d":"0.0396"},{"v":0,"d":"0.0000"}]
[8,"HS",{"v":0,"d":"0.0000"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":0.039648827389730974,"d":"0.0396"},{"v":0.14466792599731332,"d":"0.1447"},{"v":0.002081695231433839,"d":"0.0021"}]
[null,"Mates",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0.002081695231433839,"d":"0.0021"},{"v":0.004163390462867678,"d":"0.0042"}]
["corr EBV FS"]
[{"v":1,"d":"1.000"}]
[]
[]
["size of HS groups","dam",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0.006661424740588285,"d":"0.0067"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[40,"sire",{"v":0,"d":"0.0000"},{"v":0.007612959440255115,"d":"0.0076"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":0,"d":"0.0000"}]
[null,"FS",{"v":0.006661424740588285,"d":"0.0067"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":0.039648827389730974,"d":"0.0396"},{"v":0.039648827389730974,"d":"0.0396"},{"v":0,"d":"0.0000"}]
["corr EBV HS","HS",{"v":0,"d":"0.0000"},{"v":3.8064797201275576E-3,"d":"0.0038"},{"v":0.039648827389730974,"d":"0.0396"},{"v":0.14108956226471853,"d":"0.1411"},{"v":0.002081695231433839,"d":"0.0021"}]
[{"v":0.5157740361247454,"d":"0.516"},"Mates",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0.002081695231433839,"d":"0.0021"},{"v":0.004163390462867678,"d":"0.0042"}]
{"$rows_empty":12}
[null,"both sexes"]
[null,"females only"]
[null,"males only"]
[]
[{"$nulls":18}," "]

{"sheet":"example covarstructure","index":4,"n_rows":30,"n_cols":21,"rows_kept":30}
{"$rows_empty":13}
[null,null,"Heritability",0.25]
[null,null,"c-squared (among full sibs)",0.15]
[]
[null,null,"nr. of dams per sire",4," FS families",{"$nulls":3},"dams/sire =",null,"m"]
[null,null,"nr of progeny per dam",3,"prog per FS family",{"$nulls":3},"prog/dam = m",null,"n",{"$f":"D17*D18","v":12},"prog per HS family",{"$nulls":3},"n.m"]
[{"$nulls":5},"FS family",null,"total",{"$nulls":4},"HS family",null,"total"]
[{"$nulls":4},{"$f":"D18*D18","v":9},"total elements",{"$nulls":4},"covar in Vp",{"$f":"L18*12","v":144},"total elements",{"$nulls":4},"covar in Vp",null,"sum"]
[{"$nulls":4},{"$f":"D18","v":3},"diagnonal elements",{"$nulls":4},1,{"$f":"L18","v":12},"diagnonal elements",{"$nulls":4},1,null,{"$f":"L21*R21","v":12}]
[{"$nulls":4},{"$f":"E20-E21","v":6},"off diag blocks FS",{"$nulls":4},{"$f":"D14/2+D15","v":0.275},{"$f":"D17*D18*D18-L18","v":24},"off diag blocks FS",{"$nulls":4},{"$f":"D14/2+D15","v":0.275},null,{"$f":"L22*R22","v":6.6000000000000005}]
[{"$nulls":17},{"$f":"D14/4","v":{"v":0.0625,"d":"0.063"}},null,{"$f":"L23*R23","v":0}]
[{"$nulls":4},"FS excl self",{"$nulls":6},"HS excl self",{"$nulls":7},{"$f":"SUM(T21:T23)","v":18.6},"Total"]
[{"$nulls":5},"FS family mean of size",{"$nulls":3},{"$f":"D18-1","v":2},null,null,"HS family mean of size",{"$nulls":3},{"$f":"L21-E21","v":9},null,null,{"$f":"T24/L20","v":0.12916666666666668},"Mean"]
[{"$nulls":4},{"$f":"J25*J25","v":4},"total elements",{"$nulls":4},"covar in Vp",{"$f":"Q25*Q25","v":81},"total elements",{"$nulls":4},"covar in Vp"]
[{"$nulls":4},{"$f":"J25","v":2},"diagnonal elements",{"$nulls":4},{"$f":"K21","v":1},{"$f":"Q25","v":9},"diagnonal elements",{"$nulls":4},{"$f":"R21","v":1}]
[{"$nulls":4},{"$f":"E26-E27","v":2},"off diag blocks FS",{"$nulls":4},{"$f":"K22","v":0.275},{"$f":"(D17-1)*(D18*D18-D18)","v":18},"off diag blocks FS",{"$nulls":4},{"$f":"R22","v":0.275}]
[{"$nulls":11},{"$f":"(D17-1)*(D17-1)*(D18*D18)-(D17-1)*(D18*D18)","v":54},"off diag blocks HS",{"$nulls":4},{"v":0.0625,"d":"0.063"}]
[{"$nulls":9},"average",{"$f":"(E27*K27+E28*K28)/E26","v":0.6375},{"$nulls":5},"average",{"$f":"(L27*R27+L28*R28+L29*R29)/L26","v":{"v":0.21388888888888888,"d":"0.2139"}}]

{"sheet":"About","index":5,"n_rows":16,"n_cols":4,"rows_kept":16}
[]
[null,"These spreadsheets are developed by Julius van der Werf, Uiversity of New England, Armidale"]
[]
[{"$nulls":3},"contact: jvanderw@une.edu.au"]
[]
[]
[]
[null,"STSELIND","simple selection index based on max 6 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"]
[{"$nulls":3},"Iterating on STSELIND and assuming parents an EBV accurcay based on their parents and sibs"]
[{"$nulls":3},"Also allowing animals to have progeny 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."]
[{"$nulls":3},"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":6,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet1","index":7,"n_rows":10,"n_cols":16,"rows_kept":10}
[{"$nulls":5},"P",{"$nulls":3},"G",null,null,"b",null,"rel","acc"]
[null,"h2",0.3,null,"own",{"$f":"1","v":1},{"$nulls":3},{"$f":"C2","v":0.3},null,null,{"$f":"J2/F2","v":0.3},null,{"$f":"C2","v":{"v":0.3,"d":"0.300"}},{"$f":"SQRT(O2)","v":0.5477225575051661}]
[]
[]
[null,"ebvsirer2",0.99,null,"OWN",1,{"$f":"0.5*C5^2*C2","v":0.14701499999999998},null,null,{"$f":"C2","v":0.3},null,null,{"$f":"MMULT(MINVERSE(F5:G6),J5:J6)","v":0.24446231351036302},null,{"$f":"MMULT(MMULT(TRANSPOSE(M5:M6),F5:G6),M5:M6)/C2","v":0.42958793514248633},{"$f":"SQRT(O5)","v":0.6554295806129643}]
[{"$nulls":4},"sire",{"$f":"G5","v":0.14701499999999998},{"$f":"C5^2*C2","v":0.29402999999999996},null,null,{"$f":"0.5*C5^2*C2","v":0.14701499999999998},null,null,0.3777688432448185]
[{"$nulls":3},"t"]
[null,"25HS",25,{"$f":"0.25*C2","v":0.075},null,1,{"$f":"F9","v":0.075},{"$f":"F10","v":0.075},null,{"$f":"C2","v":0.3},null,null,{"$f":"MMULT(MINVERSE(F8:H10),J8:J10)","v":0.23832656949747572},null,{"$f":"MMULT(MMULT(TRANSPOSE(M8:M10),F8:H10),M8:M10)/C5","v":{"$error":"#VALUE!"}},{"$f":"SQRT(O8)","v":{"$error":"#VALUE!"}}]
[null,"50prog",50,{"$f":"D8","v":0.075},null,{"$f":"D8","v":0.075},{"$f":"D8+(1-D8)/25","v":0.112},{"$f":"G10","v":0.0375},null,{"$f":"D8","v":0.075},null,null,0.3528696917641235]
[{"$nulls":5},{"$f":"D9","v":0.075},{"$f":"C2/8","v":0.0375},{"$f":"D9+(1-D9)/C9","v":0.0935},null,{"$f":"D9","v":0.075},null,null,0.4694427149361998]