{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Selection intensity calulator","selection intensity tables","Selection intensity curves","correlated EBV"],"not_rendered":{"charts":4,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Selection intensity calulator","index":0,"n_rows":170,"n_cols":10,"rows_kept":170}
[]
[]
[]
[null,"proportion selected","p",{"v":0.1,"d":"10.00%"}]
[]
[{"$nulls":3},"Infinite population size",null,null,"Finite Population Size   = ",null,null,1000]
[null,"Selection threshold","x",{"$f":"-NORMSINV(D4)","v":{"v":1.2815515655446006,"d":"1.282"}}]
[null,"height at threshold","z",{"$f":"EXP(-0.5*(D7^2))/SQRT(2*PI())","v":{"v":0.1754983319324868,"d":"0.1755"}}]
[null,"Selection intensity","i",{"$f":"D8/D4","v":{"v":1.7549833193248678,"d":"1.755"}},null,null,"Corrected for population size",null,null,{"$f":"D9-(J6-J6*D4)/(2*D4*J6*((J6+1)*D9))","v":{"v":1.7524217539549851,"d":"1.752"}}]
[]
[]
[null,"variance reduction","i(i-x)",{"$f":"D9*(D9-D7)","v":{"v":0.8308648307230869,"d":"0.8309"}}]
[null,"variance of selected group",null,{"$f":"1-D12","v":{"v":0.16913516927691308,"d":"0.1691"}}]
[null,"variance in true  BV",null,{"$f":"(1-D12*C15*C15)","v":{"v":0.3269994871142996,"d":"0.3270"}}]
[null,"…………...for accuracy = ",0.9]
{"$rows_empty":84}
[-3.5,8.7268269504576015E-4,{"$f":"D7","v":{"v":1.2815515655446006,"d":"1.2816"}},0]
[-3.4,0.00123221916847302,{"$f":"D7","v":{"v":1.2815515655446006,"d":"1.2816"}},{"$f":"VLOOKUP(C101,A100:B170,2,TRUE)-0.01","v":{"v":0.18418605498321294,"d":"0.18418605"}}]
[-3.3,1.7225689390536812E-3,{"$f":"D9","v":{"v":1.7549833193248678,"d":"1.7550"}},{"v":0,"d":"0.00000000"}]
[-3.2,2.3840882014648404E-3,{"$f":"D9","v":{"v":1.7549833193248678,"d":"1.7550"}},{"$f":"VLOOKUP(C103,A100:B170,2,TRUE)-0.01","v":{"v":0.08404907737688695,"d":"0.08404908"}}]
[-3.1,0.003266819056199918]
[-3,4.4318484119380075E-3]
[-2.9,0.005952532419775854]
[-2.8,0.007915451582979969]
[-2.7,0.010420934814422592]
[-2.6,0.013582969233685613]
[-2.5,0.01752830049356854]
[-2.4,0.0223945302948429]
[-2.3,0.028327037741601186]
[-2.2,0.035474592846231424]
[-2.1,0.04398359598042719]
[-2,0.05399096651318806]
[-1.9,0.0656158147746766]
[-1.8,0.07895015830089415]
[-1.7,0.09404907737688695]
[-1.6,0.11092083467945554]
[-1.5,0.12951759566589174]
[-1.4,0.14972746563574488]
[-1.3,0.17136859204780736]
[-1.2,0.19418605498321295]
[-1.1,0.21785217703255053]
[-1,0.24197072451914337]
[-0.9,0.2660852498987548]
[-0.8,0.28969155276148273]
[-0.7,0.31225393336676127]
[-0.6,0.33322460289179967]
[-0.5,0.3520653267642995]
[-0.4,0.36827014030332333]
[-0.3,0.38138781546052414]
[-0.2,0.3910426939754559]
[-0.1,0.3969525474770118]
[0,0.3989422804014327]
[0.1,0.3969525474770118]
[0.2,0.3910426939754559]
[0.3,0.38138781546052414]
[0.4,0.36827014030332333]
[0.5,0.3520653267642995]
[0.6,0.33322460289179967]
[0.7,0.31225393336676127]
[0.8,0.28969155276148273]
[0.9,0.2660852498987548]
[1,0.24197072451914337]
[1.1,0.21785217703255053]
[1.2,0.19418605498321295]
[1.3,0.17136859204780736]
[1.4,0.14972746563574488]
[1.5,0.12951759566589174]
[1.6,0.11092083467945554]
[1.7,0.09404907737688695]
[1.8,0.07895015830089415]
[1.9,0.0656158147746766]
[2.00000000000001,0.05399096651318695]
[2.1,0.04398359598042719]
[2.2,0.035474592846231424]
[2.30000000000001,0.028327037741600516]
[2.40000000000001,0.022394530294842355]
[2.50000000000001,0.017528300493568086]
[2.6,0.013582969233685613]
[2.70000000000001,0.010420934814422318]
[2.80000000000001,7.915451582979743E-3]
[2.90000000000001,5.9525324197756795E-3]
[3.00000000000001,4.431848411937874E-3]
[3.10000000000001,0.00326681905619982]
[3.20000000000001,2.3840882014647662E-3]
[3.30000000000001,0.001722568939053623]
[3.40000000000001,1.2322191684729772E-3]
[3.50000000000001,8.7268269504572915E-4]

{"sheet":"selection intensity tables","index":1,"n_rows":49,"n_cols":11,"rows_kept":49}
[null,null,"Selection Intensity Table"]
[null,"of a large sample truncated standard normal distribution, giving the truncation point "]
[null,"and the average value of the selected group for a certain selected percentage"]
[]
["%","truncation","selection",null,"%","truncation","selection",null,"%","truncation","selection"]
["selected","point (x)","intensity (i)",null,"selected","point (x)","intensity (i)",null,"selected","point (x)","intensity (i)"]
[0.01,3.719,{"v":3.9585,"d":"3.959"},null,{"v":1,"d":"1.0"},{"v":2.3263,"d":"2.326"},{"v":2.6652,"d":"2.665"},null,20,{"v":0.8416,"d":"0.842"},{"v":1.3998,"d":"1.400"}]
[0.02,{"v":3.5401,"d":"3.540"},{"v":3.7892,"d":"3.789"},null,1.2,{"v":2.2571,"d":"2.257"},{"v":2.6028,"d":"2.603"},null,21,{"v":0.8064,"d":"0.806"},{"v":1.3724,"d":"1.372"}]
[0.03,{"v":3.4316,"d":"3.432"},{"v":3.6869,"d":"3.687"},null,1.4,{"v":2.1973,"d":"2.197"},{"v":2.5491,"d":"2.549"},null,22,{"v":0.7722,"d":"0.772"},{"v":1.3459,"d":"1.346"}]
[0.04,{"v":3.3528,"d":"3.353"},{"v":3.6128,"d":"3.613"},null,1.6,{"v":2.1444,"d":"2.144"},{"v":2.5017,"d":"2.502"},null,23,{"v":0.7388,"d":"0.739"},{"v":1.3202,"d":"1.320"}]
[0.05,{"v":3.2905,"d":"3.291"},{"v":3.5544,"d":"3.554"},null,1.8,{"v":2.0969,"d":"2.097"},{"v":2.4593,"d":"2.459"},null,24,{"v":0.7063,"d":"0.706"},{"v":1.2953,"d":"1.295"}]
[0.06,{"v":3.2389,"d":"3.239"},3.506,null,{"v":2,"d":"2.0"},{"v":2.0537,"d":"2.054"},{"v":2.4209,"d":"2.421"},null,25,{"v":0.6745,"d":"0.675"},{"v":1.2711,"d":"1.271"}]
[0.07,{"v":3.1947,"d":"3.195"},{"v":3.4646,"d":"3.465"},null,2.2,{"v":2.0141,"d":"2.014"},{"v":2.3857,"d":"2.386"},null,26,{"v":0.6433,"d":"0.643"},{"v":1.2476,"d":"1.248"}]
[0.08,{"v":3.1559,"d":"3.156"},{"v":3.4284,"d":"3.428"},null,2.4,{"v":1.9774,"d":"1.977"},{"v":2.3532,"d":"2.353"},null,27,{"v":0.6128,"d":"0.613"},{"v":1.2246,"d":"1.225"}]
[0.09,{"v":3.1214,"d":"3.121"},{"v":3.3962,"d":"3.396"},null,2.6,{"v":1.9431,"d":"1.943"},{"v":2.3229,"d":"2.323"},null,28,{"v":0.5828,"d":"0.583"},{"v":1.2022,"d":"1.202"}]
[{"v":0.1,"d":"0.10"},{"v":3.0902,"d":"3.090"},{"v":3.3671,"d":"3.367"},null,2.8,1.911,{"v":2.2947,"d":"2.295"},null,29,{"v":0.5534,"d":"0.553"},{"v":1.1804,"d":"1.180"}]
[{"$nulls":4},{"v":3,"d":"3.0"},{"v":1.8808,"d":"1.881"},{"v":2.2681,"d":"2.268"},null,30,{"v":0.5244,"d":"0.524"},1.159]
[0.12,{"v":3.0357,"d":"3.036"},{"v":3.3163,"d":"3.316"},null,3.2,{"v":1.8522,"d":"1.852"},2.243,null,31,{"v":0.4959,"d":"0.496"},1.138]
[0.14,{"v":2.9889,"d":"2.989"},{"v":3.2728,"d":"3.273"},null,3.4,1.825,{"v":2.2192,"d":"2.219"},null,32,{"v":0.4677,"d":"0.468"},{"v":1.1175,"d":"1.118"}]
[0.16,{"v":2.9478,"d":"2.948"},{"v":3.2347,"d":"3.235"},null,3.6,{"v":1.7991,"d":"1.799"},{"v":2.1965,"d":"2.197"},null,33,{"v":0.4399,"d":"0.440"},{"v":1.0974,"d":"1.097"}]
[0.18,{"v":2.9112,"d":"2.911"},{"v":3.2007,"d":"3.201"},null,3.8,{"v":1.7744,"d":"1.774"},2.175,null,34,{"v":0.4125,"d":"0.413"},{"v":1.0777,"d":"1.078"}]
[{"v":0.2,"d":"0.20"},{"v":2.8782,"d":"2.878"},{"v":3.1701,"d":"3.170"},null,{"v":4,"d":"4.0"},{"v":1.7507,"d":"1.751"},{"v":2.1543,"d":"2.154"},null,35,{"v":0.3853,"d":"0.385"},{"v":1.0583,"d":"1.058"}]
[0.22,2.848,{"v":3.1422,"d":"3.142"},null,4.2,{"v":1.7279,"d":"1.728"},{"v":2.1346,"d":"2.135"},null,36,{"v":0.3585,"d":"0.359"},{"v":1.0392,"d":"1.039"}]
[0.24,{"v":2.8202,"d":"2.820"},{"v":3.1165,"d":"3.117"},null,4.4,1.706,{"v":2.1156,"d":"2.116"},null,37,{"v":0.3319,"d":"0.332"},{"v":1.0205,"d":"1.021"}]
[0.26,{"v":2.7944,"d":"2.794"},{"v":3.0927,"d":"3.093"},null,4.6,{"v":1.6849,"d":"1.685"},{"v":2.0973,"d":"2.097"},null,38,{"v":0.3055,"d":"0.306"},1.002]
[0.28,{"v":2.7703,"d":"2.770"},{"v":3.0705,"d":"3.071"},null,4.8,{"v":1.6646,"d":"1.665"},{"v":2.0797,"d":"2.080"},null,39,{"v":0.2793,"d":"0.279"},{"v":0.9838,"d":"0.984"}]
[{"v":0.3,"d":"0.30"},{"v":2.7478,"d":"2.748"},{"v":3.0497,"d":"3.050"},null,{"v":5,"d":"5.0"},{"v":1.6449,"d":"1.645"},{"v":2.0627,"d":"2.063"},null,40,{"v":0.2533,"d":"0.253"},{"v":0.9659,"d":"0.966"}]
[0.32,{"v":2.7266,"d":"2.727"},{"v":3.0302,"d":"3.030"},{"$nulls":5},41,{"v":0.2275,"d":"0.228"},{"v":0.9482,"d":"0.948"}]
[0.34,{"v":2.7065,"d":"2.707"},{"v":3.0117,"d":"3.012"},null,{"v":5,"d":"5.0"},{"v":1.6449,"d":"1.645"},{"v":2.0627,"d":"2.063"},null,42,{"v":0.2019,"d":"0.202"},{"v":0.9307,"d":"0.931"}]
[0.36,{"v":2.6874,"d":"2.687"},{"v":2.9942,"d":"2.994"},null,5.5,{"v":1.5982,"d":"1.598"},{"v":2.0226,"d":"2.023"},null,43,{"v":0.1764,"d":"0.176"},{"v":0.9135,"d":"0.914"}]
[0.38,{"v":2.6693,"d":"2.669"},{"v":2.9776,"d":"2.978"},null,{"v":6,"d":"6.0"},{"v":1.5548,"d":"1.555"},{"v":1.9854,"d":"1.985"},null,44,0.151,{"v":0.8964,"d":"0.896"}]
[{"v":0.4,"d":"0.40"},{"v":2.6521,"d":"2.652"},{"v":2.9618,"d":"2.962"},null,6.5,{"v":1.5141,"d":"1.514"},{"v":1.9507,"d":"1.951"},null,45,{"v":0.1257,"d":"0.126"},{"v":0.8796,"d":"0.880"}]
[0.42,{"v":2.6356,"d":"2.636"},{"v":2.9466,"d":"2.947"},null,{"v":7,"d":"7.0"},{"v":1.4758,"d":"1.476"},{"v":1.9181,"d":"1.918"},null,46,{"v":0.1004,"d":"0.100"},{"v":0.8629,"d":"0.863"}]
[0.44,{"v":2.6197,"d":"2.620"},{"v":2.9321,"d":"2.932"},null,7.5,{"v":1.4395,"d":"1.440"},{"v":1.8874,"d":"1.887"},null,47,{"v":0.0753,"d":"0.075"},{"v":0.8464,"d":"0.846"}]
[0.46,{"v":2.6045,"d":"2.605"},{"v":2.9182,"d":"2.918"},null,{"v":8,"d":"8.0"},{"v":1.4051,"d":"1.405"},{"v":1.8583,"d":"1.858"},null,48,{"v":0.0502,"d":"0.050"},{"v":0.8301,"d":"0.830"}]
[0.48,{"v":2.5899,"d":"2.590"},{"v":2.9048,"d":"2.905"},null,8.5,{"v":1.3722,"d":"1.372"},{"v":1.8307,"d":"1.831"},null,49,{"v":0.0251,"d":"0.025"},{"v":0.8139,"d":"0.814"}]
[{"v":0.5,"d":"0.50"},{"v":2.5758,"d":"2.576"},{"v":2.8919,"d":"2.892"},null,{"v":9,"d":"9.0"},{"v":1.3408,"d":"1.341"},{"v":1.8043,"d":"1.804"},null,50,{"v":0,"d":"0.000"},{"v":0.7979,"d":"0.798"}]
[{"$nulls":4},9.5,{"v":1.3106,"d":"1.311"},{"v":1.7791,"d":"1.779"}]
[{"v":0.5,"d":"0.50"},{"v":2.5758,"d":"2.576"},{"v":2.8919,"d":"2.892"},null,{"v":10,"d":"10.0"},{"v":1.2816,"d":"1.282"},1.755,null,60,{"v":-0.2533,"d":"-0.253"},{"v":0.6439,"d":"0.644"}]
[0.55,{"v":2.5427,"d":"2.543"},{"v":2.8617,"d":"2.862"},{"$nulls":5},70,{"v":-0.5244,"d":"-0.524"},{"v":0.4967,"d":"0.497"}]
[{"v":0.6,"d":"0.60"},{"v":2.5121,"d":"2.512"},{"v":2.8338,"d":"2.834"},null,11,{"v":1.2265,"d":"1.227"},{"v":1.7094,"d":"1.709"},null,80,{"v":-0.8416,"d":"-0.842"},{"v":0.35,"d":"0.350"}]
[0.65,{"v":2.4838,"d":"2.484"},2.808,null,12,1.175,1.667,null,90,{"v":-1.2816,"d":"-1.282"},0.195]
[{"v":0.7,"d":"0.70"},{"v":2.4573,"d":"2.457"},{"v":2.7839,"d":"2.784"},null,13,{"v":1.1264,"d":"1.126"},{"v":1.6273,"d":"1.627"}]
[0.75,{"v":2.4324,"d":"2.432"},{"v":2.7612,"d":"2.761"},null,14,{"v":1.0803,"d":"1.080"},{"v":1.5898,"d":"1.590"}]
[{"v":0.8,"d":"0.80"},{"v":2.4089,"d":"2.409"},{"v":2.7399,"d":"2.740"},null,15,{"v":1.0364,"d":"1.036"},{"v":1.5544,"d":"1.554"}]
[0.85,{"v":2.3867,"d":"2.387"},{"v":2.7198,"d":"2.720"},null,16,{"v":0.9945,"d":"0.995"},{"v":1.5207,"d":"1.521"}]
[{"v":0.9,"d":"0.90"},{"v":2.3656,"d":"2.366"},{"v":2.7007,"d":"2.701"},null,17,{"v":0.9542,"d":"0.954"},{"v":1.4886,"d":"1.489"}]
[0.95,{"v":2.3455,"d":"2.346"},{"v":2.6825,"d":"2.683"},null,18,{"v":0.9154,"d":"0.915"},{"v":1.4578,"d":"1.458"}]
[{"v":1,"d":"1.00"},{"v":2.3263,"d":"2.326"},{"v":2.6652,"d":"2.665"},null,19,{"v":0.8779,"d":"0.878"},{"v":1.4282,"d":"1.428"}]

{"sheet":"Selection intensity curves","index":2,"n_rows":200,"n_cols":12,"rows_kept":200}
[]
[]
[]
[null,"proportion selected","p",{"v":0.99,"d":"99.0%"}]
[]
[{"$nulls":3},"Infinite population size",null,null,"Finite Population Size   = ",null,null,50]
[null,"Selection threshold","x",{"$f":"-NORMSINV(D4)","v":{"v":-2.3263478740408408,"d":"-2.326"}},null,null,"p corrected",null,{"$f":"(D4*J6+0.5)/(J6+(J6*D4)/(2*J6))","v":0.9901970492127934}]
[null,"height at threshold","z",{"$f":"EXP(-0.5*(D7^2))/SQRT(2*PI())","v":{"v":0.02665214220345808,"d":"0.0267"}},{"$nulls":4},{"$f":"EXP(-0.5*(-NORMSINV(I7)^2))/SQRT(2*PI())","v":0.026193004541180086},{"$f":"I8/I7","v":{"v":0.026452315286137767,"d":"0.026452"}},0]
[null,"Selection intensity","i",{"$f":"D8/D4","v":{"v":0.026921355761068768,"d":"0.027"}},null,null,"Corrected for population size",null,null,{"$f":"D9-(J6-J6*D4)/(2*D4*J6*((J6+1)*D9))","v":{"v":0.023242881628000617,"d":"0.02324"}}]
[]
[]
[null,"variance reduction","i(i-x)",{"$f":"D9*(D9-D7)","v":{"v":0.0633531981370735,"d":"0.0634"}}]
[null,"variance of selected group",null,{"$f":"1-D12","v":{"v":0.9366468018629265,"d":"0.9366"}}]
[null,"variance in true  BV",null,{"$f":"(1-D12*C15*C15)","v":{"v":0.9486839095089704,"d":"0.9487"}}]
[null,"…………...for accuracy = ",0.9]
{"$rows_empty":83}
[{"$nulls":7},"Infinte PopSize","PopSize ="]
[-3.5,8.7268269504576015E-4,{"$f":"D7","v":{"v":-2.3263478740408408,"d":"-2.3263"}},0,{"$nulls":3},"Infinite PopSize",{"$f":"CONCATENATE(I99,J6)","v":"PopSize =50"}]
[-3.4,0.00123221916847302,{"$f":"D7","v":{"v":-2.3263478740408408,"d":"-2.3263"}},{"$f":"VLOOKUP(C101,A100:B170,2,TRUE)-0.01","v":{"v":0.0123945302948429,"d":"0.01239453"}},null,1,2.3263478740408408,2.665214220345808,2.301045281172061,null,4,1.1415957266007766]
[-3.3,1.7225689390536812E-3,{"$f":"D9","v":{"v":0.026921355761068768,"d":"0.0269"}},{"v":0,"d":"0.00000000"},null,2,2.0537489106318225,2.4209067940371036,2.222471993471468,null,8,1.5509810958926211]
[-3.2,2.3840882014648404E-3,{"$f":"D9","v":{"v":0.026921355761068768,"d":"0.0269"}},{"$f":"VLOOKUP(C103,A100:B170,2,TRUE)-0.01","v":{"v":0.3889422804014327,"d":"0.38894228"}},null,3,1.8807936081512509,2.268065047214738,2.1283012144086344,null,12,1.708437007158715]
[-3.1,0.003266819056199918,{"$nulls":3},4,1.7506860712521695,2.154344350649534,2.0451259160125095,null,16,1.7917960190054705]
[-3,4.4318484119380075E-3,{"$nulls":3},5,1.6448536269514726,2.062712807507426,1.9724072113401077,null,20,1.8433992168153668]
[-2.9,0.005952532419775854,{"$nulls":3},6,1.554773594596853,1.9853827532110002,1.9080199520113736,null,24,1.8784893913260963]
[-2.8,0.007915451582979969,{"$nulls":3},7,1.4757910281791702,1.9181130652891667,1.8502066925119707,null,28,1.9038995176959348]
[-2.7,0.010420934814422592,{"$nulls":3},8,1.4050715603096353,1.8583278282706328,1.797657640629878,null,32,1.9231496134306612]
[-2.6,0.013582969233685613,{"$nulls":3},9,1.340755033690216,1.8043403091117498,1.7494013711495366,null,36,1.938237526303825]
[-2.5,0.01752830049356854,{"$nulls":3},10,1.2815515655446006,1.7549833193248678,1.7047063205944237,null,40,1.950381456177347]
[-2.4,0.0223945302948429,{"$nulls":3},11,1.2265281200366105,1.7094142455408337,1.6630108425312424,null,44,1.960366465184465]
[-2.3,0.028327037741601186,{"$nulls":3},12,1.1749867920660904,1.6670040315808303,1.6238755067095243,null,48,1.9687212686394007]
[-2.2,0.035474592846231424,{"$nulls":3},13,1.1263911290388013,1.627270070727581,1.5869504821671085,null,52,1.975814969686044]
[-2.1,0.04398359598042719,{"$nulls":3},14,1.0803193408149565,1.58983364361114,1.5519528943403789,null,56,1.9819130635682463]
[-2,0.05399096651318806,{"$nulls":3},15,1.0364333894937898,1.5543918350245483,1.5186508112339296,null,60,1.9872114074331106]
[-1.9,0.0656158147746766,{"$nulls":3},16,0.9944578832097497,1.520698379908448,1.4868517020166803,null,64,1.991857647437684]
[-1.8,0.07895015830089415,{"$nulls":3},17,0.9541652531461955,1.488550225959841,1.456393967829695,null,68,1.9959651929489732]
[-1.7,0.09404907737688695,{"$nulls":3},18,0.915365087842815,1.457777874992299,1.4271406221334382,null,72,1.9996225964864227]
[-1.6,0.11092083467945554,{"$nulls":3},19,0.8778962950512285,1.4282382920574592,1.3989745019272661,null,76,2.0029000100459555]
[-1.5,0.12951759566589174,{"$nulls":3},20,0.8416212335729145,1.3998096020390411,1.3717945875560815,null,80,2.0058537284391145]
[-1.4,0.14972746563574488,{"$nulls":3},21,0.8064212470182406,1.3723870572813548,1.3455131378293446,null,84,2.008529449807035]
[-1.3,0.17136859204780736,{"$nulls":3},22,0.772193214188685,1.3458799262504508,1.3200534334030483,null,88,2.010964656894693]
[-1.2,0.19418605498321295,{"$nulls":3},23,0.7388468491852139,1.3202090609680401,1.2953479799829875,null,92,2.0131903838027676]
[-1.1,0.21785217703255053,{"$nulls":3},24,0.7063025628400873,1.295304972334857,1.2713370633890393,null,96,2.0152325456050217]
[-1,0.24197072451914337,{"$nulls":3},25,0.6744897501960819,1.2711062907364277,1.2479675769087726,null,100,2.017112952016998]
[-0.9,0.2660852498987548,{"$nulls":3},26,0.643345405392917,1.247558522593554,1.225192061562186,null,104,2.0188500893690144]
[-0.8,0.28969155276148273,{"$nulls":3},27,0.6128129910166273,1.224613036840148,1.2029679144557628,null,108,2.0204597304016163]
[-0.7,0.31225393336676127,{"$nulls":3},28,0.5828415072712163,1.2022262319129329,1.1812567310283113,null,112,2.0219554145469547]
[-0.6,0.33322460289179967,{"$nulls":3},29,0.553384719555673,1.1803588458252467,1.160023754835772,null,116,2.0233488296909026]
[-0.5,0.3520653267642995,{"$nulls":3},30,0.5244005127080409,1.1589753806669127,1.139237414377844,null,120,2.024650118213763]
[-0.4,0.36827014030332333,{"$nulls":3},31,0.49585034734745354,1.1380436193652121,1.118868930884704,null,124,2.02586812427116]
[-0.3,0.38138781546052414,{"$nulls":3},32,0.4676987991145083,1.1175342174033343,1.098891984343356,null,128,2.027010595069184]
[-0.2,0.3910426939754559,{"$nulls":3},33,0.43991316567323374,1.0974203558700348,1.0792824276247939,null,132,2.0280843458192064]
[-0.1,0.3969525474770118,{"$nulls":3},34,0.41246312944140484,1.0776774450228859,1.0600180405726907,null,136,2.0290953957955047]
[0,0.3989422804014327,{"$nulls":3},35,0.38532046640756784,1.0582828697119018,1.0410783174751999,null,140,2.0300490812341407]
[0.1,0.3969525474770118,{"$nulls":3},36,0.35845879325119384,1.0392157696923163,1.0224442825689612,null,144,2.030950149545128]
[0.2,0.3910426939754559,{"$nulls":3},37,0.3318533464368166,1.0204568491726616,1.0040983291965142,null,148,2.031802838349485]
[0.3,0.38138781546052414,{"$nulls":3},38,0.30548078809939727,1.0019882109836886,0.9860240790131937,null,152,2.03261094211832]
[0.4,0.36827014030332333,{"$nulls":3},39,0.27931903444745415,0.9837932115794497,0.9682062582611484,null,156,2.033377868625049]
[0.5,0.3520653267642995,{"$nulls":3},40,0.2533471031357998,0.9658563337421513,0.9506305886295587,null,160,2.034106686982375]
[0.6,0.33322460289179967,{"$nulls":3},41,0.2275449766411495,0.9481630743936236,0.9332836906269486,null,164,2.034800168692073]
[0.7,0.31225393336676127,{"$nulls":3},42,0.20189347914185088,0.93069984534608,0.9161529977232225,null,168,2.035460822865218]
[0.8,0.28969155276148273,{"$nulls":3},43,0.17637416478086138,0.9134538851744978,0.8992266797908903,null,172,2.036090926556367]
[0.9,0.2660852498987548,{"$nulls":3},44,0.15096921549677725,0.8964131806788393,0.8824935745987256,null,176,2.0366925509846396]
[1,0.24197072451914337,{"$nulls":3},45,0.12566134685507402,0.8795663966391483,0.8659431262960724,null,180,2.0372675842779606]
[1.1,0.21785217703255053,{"$nulls":3},46,0.10043372051146976,0.8629028127602891,0.8495653299795408,null,184,2.0378177512667057]
[1.2,0.19418605498321295,{"$nulls":3},47,0.0752698620998299,0.8464122668635374,0.833350681561656,null,188,2.038344630763864]
[1.3,0.17136859204780736,{"$nulls":3},48,0.050153583464733656,0.8300851035155896,0.817290132267825,null,192,2.038849670696373]
[1.4,0.14972746563574488,{"$nulls":3},49,0.02506890825871106,0.8139121273967376,0.8013750471774141,null,196,2.039334201393044]
[1.5,0.12951759566589174,{"$nulls":3},50,0,0.7978845608028654,0.7855971672997722,null,200,2.039799447285868]
[1.6,0.11092083467945554,{"$nulls":3},51,-0.02506890825871106,0.7819940047537283,0.7699485747390842]
[1.7,0.09404907737688695,{"$nulls":3},52,-0.050153583464733656,0.7662324032451596,0.7544216605549153]
[1.8,0.07895015830089415,{"$nulls":3},53,-0.0752698620998299,0.7505920102374765,0.7390090949697703]
[1.9,0.0656158147746766,{"$nulls":3},54,-0.10043372051146988,0.7350653590180241,0.7237037996122014]
[2.00000000000001,0.05399096651318695,{"$nulls":3},55,-0.12566134685507416,0.7196452336138486,0.7084989215149683]
[2.1,0.04398359598042719,{"$nulls":3},56,-0.15096921549677741,0.7043246419619452,0.6933878086132844]
[2.2,0.035474592846231424,{"$nulls":3},57,-0.1763741647808612,0.6890967905702352,0.6783639865089173]
[2.30000000000001,0.028327037741600516,{"$nulls":3},58,-0.20189347914185077,0.6739550604230234,0.6634211362823336]
[2.40000000000001,0.022394530294842355,{"$nulls":3},59,-0.22754497664114934,0.6588929839006538,0.6485530731475406]
[2.50000000000001,0.017528300493568086,{"$nulls":3},60,-0.2533471031357998,0.6439042224947676,0.6337537257530392]
[2.6,0.013582969233685613,{"$nulls":3},61,-0.27931903444745415,0.6289825451081728,0.6190171159374556]
[2.70000000000001,0.010420934814422318,{"$nulls":3},62,-0.30548078809939727,0.6141218067319383,0.604337338750022]
[2.80000000000001,7.915451582979743E-3,{"$nulls":3},63,-0.3318533464368166,0.5993159272918805,0.5897085425439845]
[2.90000000000001,5.9525324197756795E-3,{"$nulls":3},64,-0.35845879325119384,0.5845588704519279,0.5751249089450408]
[3.00000000000001,4.431848411937874E-3,{"$nulls":3},65,-0.38532046640756784,0.5698446221525624,0.5605806324866459]
[3.10000000000001,0.00326681905619982,{"$nulls":3},66,-0.41246312944140473,0.5551671686481534,0.5460698996889619]
[3.20000000000001,2.3840882014647662E-3,{"$nulls":3},67,-0.43991316567323396,0.5405204737867335,0.531586867337585]
[3.30000000000001,0.001722568939053623,{"$nulls":3},68,-0.46769879911450835,0.5258984552486279,0.5171256396909911]
[3.40000000000001,1.2322191684729772E-3,{"$nulls":3},69,-0.4958503473474533,0.5112949594249504,0.5026802443105193]
[3.50000000000001,8.7268269504572915E-4,{"$nulls":3},70,-0.5244005127080408,0.49670373457153405,0.4882446061619332]
[{"$nulls":5},71,-0.5533847195556727,0.48211840181594595,0.47381251958080833]
[{"$nulls":5},72,-0.5828415072712163,0.46753242352169616,0.45937761762212115]
[{"$nulls":5},73,-0.6128129910166273,0.45293906842032877,0.4449333382233644]
[{"$nulls":5},74,-0.643345405392917,0.4383313728031406,0.4304728864948221]
[{"$nulls":5},75,-0.6744897501960819,0.42370209691214256,0.4159891923029242]
[{"$nulls":5},76,-0.7063025628400873,0.40904367547416537,0.4014748621228545]
[{"$nulls":5},77,-0.7388468491852139,0.39434816106837567,0.3869221238910223]
[{"$nulls":5},78,-0.772193214188685,0.3796071586860246,0.37232276326752645]
[{"$nulls":5},79,-0.8064212470182406,0.36481174940390443,0.35766804929640805]
[{"$nulls":5},80,-0.8416212335729147,0.34995240050976023,0.3429486468890203]
[{"$nulls":5},81,-0.8778962950512286,0.33501885863076203,0.32815451279775376]
[{"$nulls":5},82,-0.9153650878428126,0.3200000213397737,0.3132747707122189]
[{"$nulls":5},83,-0.9541652531461955,0.3048837812206904,0.2982975596759617]
[{"$nulls":5},84,-0.9944578832097497,0.2896568342682758,0.2832098480031772]
[{"$nulls":5},85,-1.0364333894937898,0.2743044414749203,0.2679972019824582]
[{"$nulls":5},86,-1.0803193408149565,0.2588101280297205,0.25264349442750356]
[{"$nulls":5},87,-1.1263911290388013,0.24315529792481094,0.2371305318180737]
[{"$nulls":5},88,-1.1749867920660904,0.22731873157920413,0.2214375690967533]
[{"$nulls":5},89,-1.2265281200366105,0.21127591798819292,0.20554066593082773]
[{"$nulls":5},90,-1.2815515655446006,0.194998146591652,0.1894118133993804]
[{"$nulls":5},91,-1.340755033690216,0.17845123936270052,0.17301771802577834]
[{"$nulls":5},92,-1.4050715603096329,0.1615937241974469,0.15631805570694648]
[{"$nulls":5},93,-1.4757910281791713,0.14437410168843165,0.13926286932885776]
[{"$nulls":5},94,-1.5547735945968528,0.12672655871559577,0.12178850757519406]
[{"$nulls":5},95,-1.6448536269514715,0.10856383197407529,0.10381090586000591]
[{"$nulls":5},96,-1.7506860712521695,0.08976434794373059,0.08521357983385458]
[{"$nulls":5},97,-1.8807936081512504,0.07014634166643527,0.0658237488992362]
[{"$nulls":5},98,-2.053748910631822,0.04940626110279808,0.045356571295336136]
[{"$nulls":5},99,-2.3263478740408408,0.026921355761068768,0.023242881628000617]
[{"$nulls":5},100,{"$error":"#NUM!"},{"$error":"#NUM!"}]

{"sheet":"correlated EBV","index":3,"n_rows":171,"n_cols":10,"rows_kept":171}
[]
[]
[]
[null,"proportion selected","p",{"v":0.5,"d":"50.00%"},null,null,"Population Size   = ",null,{"$f":"H5*H6*H7","v":200}]
[{"$nulls":6},"Nr Sires nhs",10]
[{"$nulls":3},"Infinite population size",null,null,"Nr dams/sire  ",5]
[{"$nulls":6},"Nr offspring per dam",4]
[null,"Selection threshold","x",{"$f":"-NORMSINV(D4)","v":{"v":0,"d":"0.000"}},null,null,"FS EBV correlation",{"v":0.6207838902589806,"d":"0.621"}]
[null,"height at threshold","z",{"$f":"EXP(-0.5*(D8^2))/SQRT(2*PI())","v":{"v":0.3989422804014327,"d":"0.3989"}},null,null,"HS EBV Correlation",{"v":0.41462833813194383,"d":"0.415"}]
[null,"Selection intensity","i",{"$f":"D9/D4","v":{"v":0.7978845608028654,"d":"0.798"}},null,null,"Corrected for population size",null,null,{"$f":"D10-(I4-I4*D4)/(2*D4*I4*((I4+1)*D10))","v":{"v":0.7947668639438716,"d":"0.795"}}]
[]
[{"$nulls":6},"t_average",{"$f":"(H8*(H7-1)+H9*H7*(H6-1))/(H7*H5*H6-1)","v":0.042695502919035386}]
[{"$nulls":6},"Corrected for related EBV",null,null,{"$f":"SQRT(1-H12)*J10","v":{"v":0.7776153079186531,"d":"0.778"}}]
{"$rows_empty":87}
[-3.5,8.7268269504576015E-4,{"$f":"D8","v":{"v":0,"d":"0.0000"}},0]
[-3.4,0.00123221916847302,{"$f":"D8","v":{"v":0,"d":"0.0000"}},{"$f":"VLOOKUP(C102,A101:B171,2,TRUE)-0.01","v":{"v":0.3889422804014327,"d":"0.38894228"}}]
[-3.3,1.7225689390536812E-3,{"$f":"D10","v":{"v":0.7978845608028654,"d":"0.7979"}},{"v":0,"d":"0.00000000"}]
[-3.2,2.3840882014648404E-3,{"$f":"D10","v":{"v":0.7978845608028654,"d":"0.7979"}},{"$f":"VLOOKUP(C104,A101:B171,2,TRUE)-0.01","v":{"v":0.30225393336676126,"d":"0.30225393"}}]
[-3.1,0.003266819056199918]
[-3,4.4318484119380075E-3]
[-2.9,0.005952532419775854]
[-2.8,0.007915451582979969]
[-2.7,0.010420934814422592]
[-2.6,0.013582969233685613]
[-2.5,0.01752830049356854]
[-2.4,0.0223945302948429]
[-2.3,0.028327037741601186]
[-2.2,0.035474592846231424]
[-2.1,0.04398359598042719]
[-2,0.05399096651318806]
[-1.9,0.0656158147746766]
[-1.8,0.07895015830089415]
[-1.7,0.09404907737688695]
[-1.6,0.11092083467945554]
[-1.5,0.12951759566589174]
[-1.4,0.14972746563574488]
[-1.3,0.17136859204780736]
[-1.2,0.19418605498321295]
[-1.1,0.21785217703255053]
[-1,0.24197072451914337]
[-0.9,0.2660852498987548]
[-0.8,0.28969155276148273]
[-0.7,0.31225393336676127]
[-0.6,0.33322460289179967]
[-0.5,0.3520653267642995]
[-0.4,0.36827014030332333]
[-0.3,0.38138781546052414]
[-0.2,0.3910426939754559]
[-0.1,0.3969525474770118]
[0,0.3989422804014327]
[0.1,0.3969525474770118]
[0.2,0.3910426939754559]
[0.3,0.38138781546052414]
[0.4,0.36827014030332333]
[0.5,0.3520653267642995]
[0.6,0.33322460289179967]
[0.7,0.31225393336676127]
[0.8,0.28969155276148273]
[0.9,0.2660852498987548]
[1,0.24197072451914337]
[1.1,0.21785217703255053]
[1.2,0.19418605498321295]
[1.3,0.17136859204780736]
[1.4,0.14972746563574488]
[1.5,0.12951759566589174]
[1.6,0.11092083467945554]
[1.7,0.09404907737688695]
[1.8,0.07895015830089415]
[1.9,0.0656158147746766]
[2.00000000000001,0.05399096651318695]
[2.1,0.04398359598042719]
[2.2,0.035474592846231424]
[2.30000000000001,0.028327037741600516]
[2.40000000000001,0.022394530294842355]
[2.50000000000001,0.017528300493568086]
[2.6,0.013582969233685613]
[2.70000000000001,0.010420934814422318]
[2.80000000000001,7.915451582979743E-3]
[2.90000000000001,5.9525324197756795E-3]
[3.00000000000001,4.431848411937874E-3]
[3.10000000000001,0.00326681905619982]
[3.20000000000001,2.3840882014647662E-3]
[3.30000000000001,0.001722568939053623]
[3.40000000000001,1.2322191684729772E-3]
[3.50000000000001,8.7268269504572915E-4]