{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":119,"n_cols":12,"rows_kept":119,"merged":[[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,6],[1,8,1,10],[1,11,2,11],[3,2,3,10],[4,0,13,0],[14,0,19,0],[20,0,25,0],[26,0,39,0],[40,0,46,0],[47,0,59,0],[60,2,60,10],[61,0,64,0],[65,0,75,0],[76,0,87,0],[88,0,96,0],[97,0,104,0],[105,0,115,0]],"flags":["formulas_cached_only"]}
[" QTLs detected for plant height (PH) and ear height (EH) in Z1 and Z2 in five environments"]
["Environment","QTL ","chromosome","Position","Z1",{"$nulls":3},"Z2",null,null,"Gene cation b"]
[{"$nulls":4},"LOD","ai*","R2 (%) a ",null,"LOD","di*","R2 (%)"]
[null,null,"PH"]
["E1","qPH.A-1.3",1,152.9,{"v":8.1125,"d":"8.1"},-8.8,{"v":16.14,"d":"16.1"},{"$nulls":4},"A"]
[null,"qPH.A-7.2",7,124.2,{"v":3.2369,"d":"3.2"},3.2,{"v":7.1499999999999995,"d":"7.2"},{"$nulls":4},"PD"]
[null,"qPH.B-1.2",1,220.1,{"$nulls":4},4.7,{"v":4.737,"d":"4.7"},{"v":8.63,"d":"8.6"},"OD"]
[null,"qPH.B-1.3",1,228.7,{"$nulls":4},{"v":3.997,"d":"4.0"},{"v":4.4627,"d":"4.5"},{"v":7.39,"d":"7.4"},"OD"]
[null,"qPH.B-3",3,35.8,{"$nulls":4},{"v":5.174,"d":"5.2"},{"v":5.0427,"d":"5.0"},{"v":9.55,"d":"9.6"},"OD"]
[null,"qPH.B-4.1",4,102.1,{"$nulls":4},{"v":3.3717,"d":"3.4"},{"v":4.1146,"d":"4.1"},{"v":6.34,"d":"6.3"},"OD"]
[null,"qPH.B-4.2",4,112.2,{"$nulls":4},{"v":5.0397,"d":"5.0"},{"v":5.0128,"d":"5.0"},{"v":9.24,"d":"9.2"},"OD"]
[null,"qPH.B-5.1",5,{"v":2,"d":"2.0"},{"$nulls":4},{"v":3.6378,"d":"3.6"},{"v":4.1638,"d":"4.2"},{"v":6.65,"d":"6.7"},"OD"]
[null,"qPH.B-8.2",8,140.1,{"$nulls":4},{"v":3.6619,"d":"3.7"},{"v":4.168,"d":"4.2"},{"v":6.61,"d":"6.6"},"OD"]
[null,"qPH.B-9.1",9,86.4,{"$nulls":4},{"v":3.439,"d":"3.4"},{"v":4.7633,"d":"4.8"},{"v":6.6000000000000005,"d":"6.6"},"OD"]
["E2","qPH.A-1.1",1,133.1,{"v":4.5525,"d":"4.6"},-3.6,{"v":8.73,"d":"8.7"},{"$nulls":4},"PD"]
[null,"qPH.A-1.7",1,290.6,{"v":4.0367,"d":"4.0"},-3.6,7.9,{"$nulls":4},"A"]
[null,"qPH.A-5",5,186.2,{"v":4.2888,"d":"4.3"},-4.2,{"v":8.38,"d":"8.4"},{"$nulls":4},"A"]
[null,"qPH.B-5.3",5,276.6,{"$nulls":4},{"v":3.5239,"d":"3.5"},{"v":4.6525,"d":"4.7"},{"v":7.37,"d":"7.4"},"OD"]
[null,"qPH.B-9.2",9,{"v":103,"d":"103.0"},{"$nulls":4},{"v":5.6764,"d":"5.7"},{"v":7.6436,"d":"7.6"},10.7,"OD"]
[null,"qPH.B-9.3",9,113.7,{"$nulls":4},{"v":3.9596,"d":"4.0"},{"v":6.1488,"d":"6.1"},{"v":7.870000000000001,"d":"7.9"},"OD"]
["E3","qPH.A-1.3",1,152.9,{"v":3.2322,"d":"3.2"},-4,{"v":7.51,"d":"7.5"},{"$nulls":4},"PD"]
[null,"qPH.A-8.1",8,211.5,{"v":3.4684,"d":"3.5"},-3.8,{"v":7.290000000000001,"d":"7.3"},{"$nulls":4},"PD"]
[null,"qPH.A-8.2",8,217.7,{"v":3.202,"d":"3.2"},-3.9,{"v":7.46,"d":"7.5"},{"$nulls":4},"PD"]
[null,"qPH.B-1.1",1,208.5,{"v":4.5989,"d":"4.6"},{"$nulls":4},{"v":4.7188,"d":"4.7"},8.7,"OD"]
[null,"qPH.B-9.2",9,101.2,{"v":5.8694,"d":"5.9"},{"$nulls":4},{"v":7.3005,"d":"7.3"},{"v":10.489999999999998,"d":"10.5"},"OD"]
[null,"qPH.B-9.3",9,107.8,{"v":5.8222,"d":"5.8"},{"$nulls":4},{"v":6.8177,"d":"6.8"},{"v":10.57,"d":"10.6"},"OD"]
["E4","qPH.A-1.2",1,141.8,{"v":3.9753,"d":"4.0"},-3.4,{"v":8.17,"d":"8.2"},{"$nulls":4},"PD"]
[null,"qPH.A-1.3",1,152.9,{"v":5.7883,"d":"5.8"},-4.2,{"v":11.709999999999999,"d":"11.7"},{"$nulls":4},"PD"]
[null,"qPH.A-1.4",1,161.4,{"v":3.4166,"d":"3.4"},-4.3,{"v":8.110000000000001,"d":"8.1"},{"$nulls":4},"PD"]
[null,"qPH.A-1.7",1,291.6,{"v":3.8464,"d":"3.8"},-3.4,{"v":7.720000000000001,"d":"7.7"},{"$nulls":4},"A"]
[null,"qPH.A-7.1",7,{"v":120,"d":"120.0"},{"v":3.6844,"d":"3.7"},3.1,{"v":7.02,"d":"7.0"},{"$nulls":4},"A"]
[null,"qPH.A-7.2",7,125.8,{"v":4.8588,"d":"4.9"},3.5,{"v":8.86,"d":"8.9"},{"$nulls":4},"A"]
[null,"qPH.B-1.2",1,220.1,{"$nulls":4},{"v":3.5281,"d":"3.5"},{"v":3.5469,"d":"3.5"},{"v":5.92,"d":"5.9"},"OD"]
[null,"qPH.B-1.3",1,228.7,{"$nulls":4},{"v":4.2809,"d":"4.3"},{"v":3.8983,"d":"3.9"},{"v":7.090000000000001,"d":"7.1"},"OD"]
[null,"qPH.B-5.2",5,263.6,{"$nulls":4},{"v":3.5826,"d":"3.6"},{"v":3.5984,"d":"3.6"},{"v":6.09,"d":"6.1"},"OD"]
[null,"qPH.B-5.3",5,289.2,{"$nulls":4},{"v":4.2236,"d":"4.2"},{"v":4.3039,"d":"4.3"},{"v":8.469999999999999,"d":"8.5"},"OD"]
[null,"qPH.B-8.1",8,130.9,{"$nulls":4},{"v":3.408,"d":"3.4"},{"v":3.9805,"d":"4.0"},{"v":7.049999999999999,"d":"7.1"},"OD"]
[null,"qPH.B-8.2",8,140.1,{"$nulls":4},{"v":6.5013,"d":"6.5"},{"v":5.0659,"d":"5.1"},{"v":11.110000000000001,"d":"11.1"},"OD"]
[null,"qPH.B-8.3",8,146.1,{"$nulls":4},{"v":4.6044,"d":"4.6"},{"v":4.5125,"d":"4.5"},8.6,"OD"]
[null,"qPH.B-9.3",9,116.6,{"$nulls":4},{"v":3.4268,"d":"3.4"},{"v":4.5199,"d":"4.5"},{"v":5.59,"d":"5.6"},"OD"]
["E5","qPH.A-1.2",1,141.8,{"v":3.447,"d":"3.4"},-3,{"v":6.32,"d":"6.3"},{"$nulls":4},"PD"]
[null,"qPH.A-1.3",1,152.9,{"v":5.41,"d":"5.4"},-3.9,{"v":9.700000000000001,"d":"9.7"},{"$nulls":4},"PD"]
[null,"qPH.A-1.4",1,160.4,{"v":3.7627,"d":"3.8"},-3.2,{"v":6.859999999999999,"d":"6.9"},{"$nulls":4},"A"]
[null,"qPH.A-1.5",1,234.9,{"v":3.4296,"d":"3.4"},-2.9,{"v":5.93,"d":"5.9"},{"$nulls":4},"PD"]
[null,"qPH.B-8.2",8,140.1,{"$nulls":4},{"v":4.4635,"d":"4.5"},{"v":3.7687,"d":"3.8"},{"v":7.109999999999999,"d":"7.1"},"OD"]
[null,"qPH.B-8.3",8,146.1,{"$nulls":4},{"v":5.3497,"d":"5.3"},{"v":4.1305,"d":"4.1"},{"v":8.709999999999999,"d":"8.7"},"OD"]
[null,"qPH.B-9.2",9,102.1,{"$nulls":4},{"v":6.2088,"d":"6.2"},{"v":5.8521,"d":"5.9"},{"v":9.86,"d":"9.9"},"OD"]
["Combined analysis","qPH.A-1.2",1,141.8,{"v":4.6456,"d":"4.6"},-3.2,8.6,{"$nulls":4},"PD"]
[null,"qPH.A-1.3",1,152.9,{"v":6.2967,"d":"6.3"},-3.8,{"v":11.53,"d":"11.5"},{"$nulls":4},"PD"]
[null,"qPH.A-1.4",1,160.4,{"v":4.6001,"d":"4.6"},-3.2,{"v":8.53,"d":"8.5"},{"$nulls":4},"A"]
[null,"qPH.A-1.6",1,244.3,{"v":3.7732,"d":"3.8"},-2.8,{"v":6.909999999999999,"d":"6.9"},{"$nulls":4},"A"]
[null,"qPH.A-8.3",8,272.4,{"v":3.9055,"d":"3.9"},-3,{"v":7.739999999999999,"d":"7.7"},{"$nulls":4},"A"]
[null,"qPH.A-8.4",8,279.5,{"v":4.6487,"d":"4.6"},-3.2,{"v":9.17,"d":"9.2"},{"$nulls":4},"A"]
[null,"qPH.B-1.2",1,{"v":223,"d":"223.0"},{"$nulls":4},{"v":3.711,"d":"3.7"},{"v":2.55,"d":"2.6"},{"v":5.36,"d":"5.4"},"OD"]
[null,"qPH.B-1.3",1,228.7,{"$nulls":4},{"v":3.5816,"d":"3.6"},{"v":2.5091,"d":"2.5"},{"v":5.2299999999999995,"d":"5.2"},"OD"]
[null,"qPH.B-5.2",5,264.6,{"$nulls":4},{"v":3.6109,"d":"3.6"},{"v":2.6704,"d":"2.7"},{"v":5.75,"d":"5.8"},"OD"]
[null,"qPH.B-5.3",5,{"v":280,"d":"280.0"},{"$nulls":4},{"v":4.6578,"d":"4.7"},{"v":2.996,"d":"3.0"},{"v":7.180000000000001,"d":"7.2"},"OD"]
[null,"qPH.B-8.2",8,140.1,{"$nulls":4},{"v":6.554,"d":"6.6"},{"v":3.6397,"d":"3.6"},{"v":9.87,"d":"9.9"},"OD"]
[null,"qPH.B-9.2",9,101.5,{"$nulls":4},{"v":6.8877,"d":"6.9"},{"v":4.8786,"d":"4.9"},10.2,"OD"]
[null,"qPH.B-9.3",9,108.4,{"$nulls":4},{"v":6.2745,"d":"6.3"},{"v":4.4477,"d":"4.4"},{"v":9.379999999999999,"d":"9.4"},"OD"]
[null,null,"EH"]
["E1","qEH.A-1.4",1,153.8,{"v":5.7725,"d":"5.8"},-6.1,{"v":10.66,"d":"10.7"},{"$nulls":4},"A"]
[null,"qEH.A-1.6",1,233.8,{"v":3.333,"d":"3.3"},-2.2,{"v":6.2700000000000005,"d":"6.3"},{"$nulls":4},"PD"]
[null,"qEH.A-1.7",1,244.3,{"v":3.4995,"d":"3.5"},-2.2,6.4,{"$nulls":4},"PD"]
[null,"qEH.A-8.1",8,172,{"v":5.9347,"d":"5.9"},-2.9,{"v":10.83,"d":"10.8"},{"$nulls":4},"A"]
["E2","qEH.A-1.6",1,232.8,{"v":7.6319,"d":"7.6"},-2.7,{"v":13.270000000000001,"d":"13.3"},{"$nulls":4},"A"]
[null,"qEH.A-1.7",1,241.9,{"v":6.0775,"d":"6.1"},-2.5,{"v":11.09,"d":"11.1"},{"$nulls":4},"A"]
[null,"qEH.A-3",3,137.5,{"v":3.3318,"d":"3.3"},-1.7,{"v":5.56,"d":"5.6"},{"$nulls":4},"A"]
[null,"qEH.A-5.2",5,308.1,{"v":4.4483,"d":"4.4"},-2,{"v":7.17,"d":"7.2"},{"$nulls":4},"PD"]
[null,"qEH.A-5.3",5,320,{"v":4.5022,"d":"4.5"},-2.5,{"v":11.16,"d":"11.2"},{"$nulls":4},"PD"]
[null,"qEH.A-8.2",8,216.7,{"v":4.8588,"d":"4.9"},-2.2,{"v":8.68,"d":"8.7"},{"$nulls":4},"A"]
[null,"qEH.A-8.3",8,224.9,{"v":6.7457,"d":"6.7"},-2.5,{"v":11.18,"d":"11.2"},{"$nulls":4},"PD"]
[null,"qEH.B-2",2,188.9,{"$nulls":4},{"v":3.7013,"d":"3.7"},-2.8,{"v":7.4399999999999995,"d":"7.4"},"OD"]
[null,"qEH.B-9.1",9,68.2,{"$nulls":4},{"v":4.7093,"d":"4.7"},{"v":3.7228,"d":"3.7"},{"v":13.969999999999999,"d":"14.0"},"OD"]
[null,"qEH.B-9.2",9,74.4,{"$nulls":4},{"v":5.8491,"d":"5.8"},{"v":3.7202,"d":"3.7"},12.4,"OD"]
[null,"qEH.B-9.3",9,81.2,{"$nulls":4},{"v":6.1566,"d":"6.2"},{"v":3.7326,"d":"3.7"},{"v":12.82,"d":"12.8"},"OD"]
["E3","qEH.A-1.1",1,33.2,{"v":3.9396,"d":"3.9"},-2.2,{"v":7.380000000000001,"d":"7.4"},{"$nulls":4},"PD"]
[null,"qEH.A-1.6",1,232.8,{"v":3.4535,"d":"3.5"},-2.1,{"v":6.59,"d":"6.6"},{"$nulls":4},"D"]
[null,"qEH.A-1.7",1,242.6,{"v":4.0446,"d":"4.0"},-2.2,{"v":7.24,"d":"7.2"},{"$nulls":4},"PD"]
[null,"qEH.A-5.1",5,259.8,{"v":4.241,"d":"4.2"},-2.2,{"v":7.68,"d":"7.7"},{"$nulls":4},"PD"]
[null,"qEH.A-8.2",8,217.7,{"v":6.9366,"d":"6.9"},-3.1,{"v":14.46,"d":"14.5"},{"$nulls":4},"A"]
[null,"qEH.A-8.3",8,224.9,{"v":8.8043,"d":"8.8"},-3.3,{"v":17.11,"d":"17.1"},{"$nulls":4},"A"]
[null,"qEH.B-1.1",1,137,{"$nulls":4},{"v":3.7801,"d":"3.8"},{"v":3.8777,"d":"3.9"},{"v":6.859999999999999,"d":"6.9"},"OD"]
[null,"qEH.B-1.2",1,149.3,{"$nulls":4},{"v":4.0878,"d":"4.1"},{"v":4.3164,"d":"4.3"},{"v":7.91,"d":"7.9"},"OD"]
[null,"qEH.B-1.7",1,275.2,{"$nulls":4},{"v":5.2329,"d":"5.2"},{"v":4.6233,"d":"4.6"},{"v":8.959999999999999,"d":"9.0"},"OD"]
[null,"qEH.B-8.1",8,125.6,{"$nulls":4},{"v":0.0172,"d":"0.0"},-5.5,{"v":0.03,"d":"0.0"},"OD"]
[null,"qEH.B-8.2",8,138.2,{"$nulls":4},{"v":7.0664,"d":"7.1"},{"v":7.6539,"d":"7.7"},{"v":13.29,"d":"13.3"},"OD"]
[null,"qEH.B-8.3",8,147.1,{"$nulls":4},{"v":5.1283,"d":"5.1"},{"v":5.8028,"d":"5.8"},{"v":9.56,"d":"9.6"},"OD"]
["E4","qEH.A-1.1",1,32.2,{"v":3.3892,"d":"3.4"},-2.9,{"v":6.88,"d":"6.9"},{"$nulls":4},"PD"]
[null,"qEH.A-1.5",1,224,{"v":4.0338,"d":"4.0"},-2.4,{"v":8.08,"d":"8.1"},{"$nulls":4},"D"]
[null,"qEH.A-1.6",1,232.8,{"v":6.0384,"d":"6.0"},-2.9,{"v":11.92,"d":"11.9"},{"$nulls":4},"A"]
[null,"qEH.A-8.3",8,224.9,{"v":7.2559,"d":"7.3"},-3.1,{"v":13.69,"d":"13.7"},{"$nulls":4},"A"]
[null,"qEH.B-1.3",1,210.2,{"$nulls":4},{"v":3.3362,"d":"3.3"},{"v":2.3759,"d":"2.4"},{"v":6.619999999999999,"d":"6.6"},"OD"]
[null,"qEH.B-1.4",1,219.5,{"$nulls":4},{"v":7.566,"d":"7.6"},{"v":3.2686,"d":"3.3"},{"v":12.93,"d":"12.9"},"OD"]
[null,"qEH.B-1.5",1,228.7,{"$nulls":4},{"v":6.5061,"d":"6.5"},{"v":3.0542,"d":"3.1"},{"v":11.21,"d":"11.2"},"OD"]
[null,"qEH.B-8.2",8,140.1,{"$nulls":4},{"v":7.8219,"d":"7.8"},{"v":3.4786,"d":"3.5"},{"v":13.309999999999999,"d":"13.3"},"OD"]
[null,"qEH.B-9.6",9,112.4,{"$nulls":4},{"v":4.6929,"d":"4.7"},{"v":3.282,"d":"3.3"},7.6,"OD"]
["E5","qEH.A-1.3",1,131.8,{"v":3.7095,"d":"3.7"},-2.2,{"v":7.01,"d":"7.0"},{"$nulls":4},"PD"]
[null,"qEH.A-8.3",8,221.4,{"v":8.8488,"d":"8.8"},-3.3,{"v":17.22,"d":"17.2"},{"$nulls":4},"PD"]
[null,"qEH.B-1.4",1,223,{"$nulls":4},{"v":4.1665,"d":"4.2"},{"v":2.2189,"d":"2.2"},{"v":6.8500000000000005,"d":"6.9"},"OD"]
[null,"qEH.B-1.5",1,229.7,{"$nulls":4},{"v":3.824,"d":"3.8"},{"v":2.1613,"d":"2.2"},{"v":6.54,"d":"6.5"},"OD"]
[null,"qEH.B-3",3,217.5,{"$nulls":4},{"v":3.5683,"d":"3.6"},{"v":2.0951,"d":"2.1"},{"v":6.16,"d":"6.2"},"OD"]
[null,"qEH.B-4",4,46.4,{"$nulls":4},{"v":5.5299,"d":"5.5"},{"v":2.8357,"d":"2.8"},{"v":11.219999999999999,"d":"11.2"},"OD"]
[null,"qEH.B-9.4",9,102.1,{"$nulls":4},{"v":7.7563,"d":"7.8"},{"v":4.0255,"d":"4.0"},{"v":13.420000000000002,"d":"13.4"},"OD"]
[null,"qEH.B-10",10,7.5,{"$nulls":4},{"v":6.2222,"d":"6.2"},{"v":2.9825,"d":"3.0"},{"v":12.509999999999998,"d":"12.5"},"OD"]
["Combined analysis","qEH.A-1.2",1,126.2,{"v":4.1496,"d":"4.1"},-2.1,{"v":7.7299999999999995,"d":"7.7"},{"$nulls":4},"A"]
[null,"qEH.A-1.3",1,131.8,{"v":4.947,"d":"4.9"},-2.3,{"v":9.44,"d":"9.4"},{"$nulls":4},"A"]
[null,"qEH.A-1.6",1,233.8,{"v":3.9732,"d":"4.0"},-2,{"v":7.57,"d":"7.6"},{"$nulls":4},"D"]
[null,"qEH.A-1.7",1,240.9,{"v":4.5103,"d":"4.5"},-2.1,{"v":8.48,"d":"8.5"},{"$nulls":4},"D"]
[null,"qEH.A-8.3",8,224.9,{"v":4.91,"d":"4.9"},-2.2,{"v":9.23,"d":"9.2"},{"$nulls":4},"A"]
[null,"qEH.B-1.2",1,144.8,{"$nulls":4},{"v":3.6482,"d":"3.6"},{"v":1.8613,"d":"1.9"},{"v":6.41,"d":"6.4"},"OD"]
[null,"qEH.B-1.5",1,228.7,{"$nulls":4},{"v":4.9661,"d":"5.0"},{"v":2.0205,"d":"2.0"},{"v":8.39,"d":"8.4"},"OD"]
[null,"qEH.B-1.6",1,239.9,{"$nulls":4},{"v":5.93,"d":"5.9"},{"v":2.1922,"d":"2.2"},{"v":9.950000000000001,"d":"10.0"},"OD"]
[null,"qEH.B-8.2",8,140.1,{"$nulls":4},{"v":5.7108,"d":"5.7"},{"v":2.1974,"d":"2.2"},{"v":9.520000000000001,"d":"9.5"},"OD"]
[null,"qEH.B-9.5",9,105.3,{"$nulls":4},{"v":3.4263,"d":"3.4"},{"v":2.1533,"d":"2.2"},{"v":5.55,"d":"5.6"},"OD"]
[null,"qEH.B-9.6",9,112.7,{"$nulls":4},{"v":3.1753,"d":"3.2"},{"v":2.0816,"d":"2.1"},{"v":5.09,"d":"5.1"},"OD"]
[]
["aProportion (%) of phenotypic variance explained by the QTL"]
["b Degree of dominance: A, additive (|di*/ ai*|=0.00~0.20); PD, partial dominance (|di*/ ai*|= 0.21~0.80); D, dominance (|di*/ ai*|= 0.81~1.20); OD, overdominance (|di*/ ai*|>1.20)."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}