{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"macros":1,"defined_names":47,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":28,"n_cols":13,"rows_kept":28}
[null,"X ","nmales","nfemales","G",null,"Relationships Matrix"]
["Male 1",{"v":0.10680763980803758,"d":"0.107"},4,4,127,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"}]
["Male 2",{"v":0.11298613541026722,"d":"0.113"},null,null,122,{"$f":"G2","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0.5,"d":"0.50"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.5,"d":"0.50"}]
["Male 3",{"v":0.1372023981146701,"d":"0.137"},null,null,150,{"$f":"H2","v":{"v":0.5,"d":"0.50"}},{"$f":"H3","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0.25,{"v":0,"d":"0.00"}]
["Male 4",{"v":0.14300382666702507,"d":"0.143"},null,null,109,{"$f":"I2","v":{"v":0,"d":"0.00"}},{"$f":"I3","v":{"v":0.5,"d":"0.50"}},{"$f":"I4","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0.25]
["Female   1",{"v":0.17513182611187575,"d":"0.175"},null,null,120,{"$f":"J2","v":{"v":0,"d":"0.00"}},{"$f":"J3","v":{"v":0,"d":"0.00"}},{"$f":"J4","v":{"v":0,"d":"0.00"}},{"$f":"J5","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Female   2",{"v":0.17539071711595172,"d":"0.175"},null,null,123,{"$f":"J3","v":{"v":0,"d":"0.00"}},{"$f":"K3","v":{"v":0,"d":"0.00"}},{"$f":"K4","v":{"v":0,"d":"0.00"}},{"$f":"K5","v":{"v":0,"d":"0.00"}},{"$f":"K6","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Female   3",{"v":0.08437314219762793,"d":"0.084"},null,null,89,{"$f":"L2","v":{"v":0.5,"d":"0.50"}},{"$f":"L3","v":{"v":0,"d":"0.00"}},{"$f":"L4","v":0.25},{"$f":"L5","v":{"v":0,"d":"0.00"}},{"$f":"L6","v":{"v":0,"d":"0.00"}},{"$f":"L7","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"}]
["Female   4",{"v":0.06510431457454446,"d":"0.065"},null,null,113,{"$f":"M2","v":{"v":0,"d":"0.00"}},{"$f":"M3","v":{"v":0.5,"d":"0.50"}},{"$f":"M5","v":0.25},{"$f":"M5","v":0.25},{"$f":"M6","v":{"v":0,"d":"0.00"}},{"$f":"M7","v":{"v":0,"d":"0.00"}},{"$f":"M8","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"}]
[null,"average merit of progeny","x'G",{"$f":"MMULT(TRANSPOSE(B2:B9),E2:E9)","v":{"v":120.97153014077918,"d":"120.97"}}]
[" Inbreeding weight",null,"l",{"v":-5000,"d":"-5000.0"}]
[null,"average co-acestry of progeny","x'Ax",{"$f":"MMULT(MMULT(TRANSPOSE(B2:B9),F2:M9),B2:B9)/2","v":{"v":0.09804719210189268,"d":"0.098"}}]
[null,null,"crit",{"$f":"D10+D11*D12","v":{"v":-369.2644303686842,"d":"-369.26"}}]
[{"$nulls":9},-6211.291969239064]
[null,null,"ngens",400]
[]
[null,null,"l","x'G","xAx"]
[null,null,{"v":0,"d":"0.00"},{"v":136.49967208170668,"d":"136.50"},{"v":0.24999166088641978,"d":"0.250"}]
[null,null,{"v":-8.77024543041332,"d":"-8.77"},{"v":136.38178973416794,"d":"136.38"},{"v":0.24170254902695992,"d":"0.242"}]
[null,null,{"v":-18.097287984099676,"d":"-18.10"},{"v":136.24985881662997,"d":"136.25"},{"v":0.2361133490653302,"d":"0.236"}]
[null,null,{"v":-28.688907915846112,"d":"-28.69"},{"v":135.2600159504756,"d":"135.26"},{"v":0.21761001823143808,"d":"0.218"}]
[null,null,{"v":-41.651062256235214,"d":"-41.65"},{"v":132.84947536551502,"d":"132.85"},{"v":0.18212983064619012,"d":"0.182"}]
[null,null,{"v":-59.049365715047976,"d":"-59.05"},{"v":130.194531251646,"d":"130.19"},{"v":0.15543596468742285,"d":"0.155"}]
[null,null,{"v":-85.53912377336715,"d":"-85.54"},{"v":127.97062976644575,"d":"127.97"},{"v":0.13952794814908784,"d":"0.140"}]
[null,null,{"v":-134.7430009181917,"d":"-134.74"},{"v":126.15229692876102,"d":"126.15"},{"v":0.13084321629489273,"d":"0.131"}]
[null,null,{"v":-272.1619204704715,"d":"-272.16"},{"v":124.56262393765176,"d":"124.56"},{"v":0.126435791886183,"d":"0.126"}]
[null,null,{"v":-6211.291969239064,"d":"-6211.29"},{"v":123.06679294323615,"d":"123.07"},{"v":0.12500262858199693,"d":"0.125"}]
[{"$nulls":3},{"$f":"D10","v":{"v":120.97153014077918,"d":"120.97"}},{"$f":"D12","v":{"v":0.09804719210189268,"d":"0.098"}}]

{"sheet":"Sheet2","index":1,"n_rows":1,"n_cols":1,"rows_kept":1}
[{"$f":"Sheet1!E14","v":0}]

{"sheet":"Sheet3","index":2,"n_rows":38,"n_cols":7,"rows_kept":38}
{"$rows_empty":19}
[null,1,0,0,1,0,0]
[null,2,0,0,2,0,0]
[null,3,0,0,1,0,0]
[null,4,0,0,2,0,0]
[null,5,1,2,1,127,4]
[null,6,1,2,1,122,4]
[null,7,0,0,1,150,4]
[null,8,0,0,1,109,4]
[null,9,3,4,2,120,4]
[null,10,0,0,2,123,4]
[null,11,3,4,2,89,4]
[null,12,0,0,2,113,4]
[]
[]
[{"$nulls":5},{"$f":"STDEV(F20:F31)","v":60.24866401134149}]
[]
[{"$nulls":5},{"$f":"STDEV(F24:F31)","v":17.266296649832007}]
[]
[{"$nulls":5},{"$f":"STDEV(F24:F27)","v":17.107503227141788}]