{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["all sequence information","pol training data","pol test data","env training data","env test data"],"not_rendered":{"external_links":1,"defined_names":1,"comments":24},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"all sequence information","index":0,"n_rows":155,"n_cols":19,"rows_kept":155,"flags":["formulas_cached_only"]}
["Patient code","individual code","status","Sex","pol PCR","pol_sub","pol_Link","couple ","genetic distance(pol)","pol probability（Bayesian）","result（pol）","env PCR","env_sub","env_link","genetic distance(env)","env probability（Bayesian）","result（env）","SGA","Final"]
[5,"GXDY1003","index","Female","       1","08BC","NA",0,{"$nulls":3},"1","BC","NA"]
[12,"GXDY2006","partner","Female","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[14,"GXDY2007","partner","male","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[16,"GXDY2008","partner","Female","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[17,"GXDY1009","index","male","       0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[18,"GXDY2009","partner","Female","       0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[24,"GXDY2012","partner","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[35,"GXDY1018","index","male","       1","08BC","NA",0,{"$nulls":3},"1","BC","NA"]
[41,"GXDY1021","index","male","       1","01AE","NA",0,{"$nulls":3},"0","NA","NA"]
[42,"GXDY2021","partner","Female","       0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[43,"GXDY1022","index","male","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[47,"GXDY1024","index","male","       1","01AE","LINK",1,0.010746229557160175,"training",null,"1","01AE","NA",{"$nulls":4},"LINK"]
[48,"GXDY2024","partner","Female","       1","01AE","LINK",1,0.010746229557160175,"training",null,"0","NA","NA",{"$nulls":4},"LINK"]
[50,"GXDY2025","partner","Female","       0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[52,"GXDY2026","partner","Female","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[53,"GXDY1027","index","male","       1","01AE","LINK",2,0,"training",null,"1","01AE","LINK",0.022766901882698944,"training",null,"have","LINK"]
[54,"GXDY2027","partner","Female","       1","01AE","LINK",2,0,"training",null,"1","01AE","LINK",0.022766901882698944,"training",null,"have","LINK"]
[55,"GXDY1028","index","male","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[56,"GXDY2028","partner","Female","       0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[58,"GXDY2029","partner","Female","       0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[60,"GXDY2030","partner","Female","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[61,"GXDY1031","index","male","       0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[62,"GXDY2031","partner","Female","       1","01AE","NA",0,{"$nulls":3},"0","NA","NA"]
[65,"GXDY1033","index","Female","       0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[67,"GXDY1034","index","male","       1","08BC","CLUSTER",1,0.004780831835945464,1,"LINK","1","BC","NA",{"$nulls":4},"LINK"]
[68,"GXDY2034","partner","Female","       1","08BC","CLUSTER",1,0.004780831835945464,1,"LINK","0","NA","NA",{"$nulls":4},"LINK"]
[90,"GXDY2045","partner","Female","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[91,"GXDY1046","index","male","       1","01AE","LINK",2,0.014552764228869844,"training",null,"1","01AE","LINK",0.0765104057405435,"training",null,"have","LINK"]
[92,"GXDY2046","partner","Female","       1","01AE","LINK",2,0.014552764228869844,"training",null,"1","01AE","LINK",0.0765104057405435,"training",null,"have","LINK"]
[95,"GXDY1048","index","Female","       1","07BC","LINK",1,0.0024115802377146344,"training",null,"0","NA","NA",{"$nulls":4},"LINK"]
[96,"GXDY2048","partner","male","       1","07BC","LINK",1,0.0024115802377146344,"training",null,"0","NA","NA",{"$nulls":4},"LINK"]
[99,"GXDY1050","index","Female","       1","01AE","CLUSTER",1,0.008242262586523035,1,"LINK","1","01AE","NA",{"$nulls":4},"LINK"]
[100,"GXDY2050","partner","male","       1","01AE","CLUSTER",1,0.008242262586523035,1,"LINK","0","NA","NA",{"$nulls":4},"LINK"]
[103,"GXDY1052","index","male","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[107,"GXDY1054","index","male","       1","01AE","LINK",2,0.0031279100857825254,"training",null,"1","01AE","LINK",0.020514099367219395,"training",null,null,"LINK"]
[108,"GXDY2054","partner","Female","       1","01AE","LINK",2,0.0031279100857825254,"training",null,1,"01AE","LINK",0.020514099367219395,"training",null,null,"LINK"]
[110,"GXDY2055","partner","Female","       0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[113,"GXDY1057","index","male","       1","08BC","unlink",2,0.03376680395363042,"training",null,"1","BC","LINK",0.022973566689873003,"training",null,"Link","LINK"]
[114,"GXDY2057","partner","Female","       1","08BC","unlink",2,0.03376680395363042,"training",null,"1","BC","LINK",0.022973566689873003,"training",null,"Link","LINK"]
[125,"GXDY1063","partner","Female",1,"01AE","NA",0,{"$nulls":3},"0","NA","NA"]
[144,"GXDY2072","partner","Female","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[160,"GXDY2080","partner","Female","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[164,"GXDY2082","partner","Female","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[184,"GXDY2092","partner","Female","1","08BC","NA",0,{"$nulls":3},"1","BC","NA"]
[200,"GXDY2100","partner","Female","       1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[203,"GXDY1102","index","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[205,"GXDY1103","index","Female","0","NA","NA",0,{"$nulls":3},"1","BC","NA"]
[207,"GXDY1104","index","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[211,"GXDY1106","index","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[233,"GXDY1117","index","male","1","01AE","LINK",2,0.0031550491100922526,"training",null,"1","01AE","LINK",0.04721592693506562,"training",null,"have","LINK"]
[234,"GXDY2117","partner","Female","1","01AE","LINK",2,0.0031550491100922526,"training",null,"1","01AE","LINK",0.04721592693506562,"training",null,"have","LINK"]
[235,"GXDY1118","index","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[245,"GXDY1123","index","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[247,"GXDY1124","index","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[255,"GXDY1128","index","male","1","01AE","LINK",1,0.001613554990762215,"training",null,"0","NA","NA",{"$nulls":4},"LINK"]
[256,"GXDY2128","partner","Female","1","01AE","LINK",1,0.001613554990762215,"training",null,"1","01AE","NA",{"$nulls":4},"LINK"]
[262,"GXDY2131","partner","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[265,"GXDY1133","index","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[271,"GXDY1136","index","male","0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[272,"GXDY2136","partner","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[274,"GXDY2137","partner","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[275,"GXDY1138","index","male","1","01AE","NA",0,{"$nulls":3},"0","NA","NA"]
[277,"GXDY1139","index","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[279,"GXDY1140","index","male","1","01AE","NA",0,{"$nulls":3},"0","NA","NA"]
[280,"GXDY2140","partner","Female","0","NA","NA",0,{"$nulls":3},"1","01AE","NA"]
[310,"GXDY2155","partner","Female","0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[325,"GXDY1163","index","Female","0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[335,"GXDY1168","index","male","1","01AE","LINK",2,0.009658675815956494,"training",null,"1","01AE","LINK",0.08419846502343081,"training",null,"have","LINK"]
[336,"GXDY2168","partner","Female","1","01AE","LINK",2,0.009658675815956494,"training",null,"1","01AE","LINK",0.08419846502343081,"training",null,"have","LINK"]
[337,"GXDY1169","index","male","1","01AE","LINK",1,0.013450636110858878,"training",null,"0","NA","NA",{"$nulls":4},"LINK"]
[338,"GXDY2169","partner","Female","1","01AE","LINK",1,0.013450636110858878,"training",null,"0","NA","NA",{"$nulls":4},"LINK"]
[342,"GXDY2171","partner","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[379,"GXDY1190","index","Female","0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[384,"GXDY2192","partner","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[396,"GXDY2198","partner","male","0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[412,"GXDY2206","partner","Female","1","08BC","NA",0,{"$nulls":3},"1","BC","NA"]
[413,"GXDY1207","index","Female","1","08BC","NA",0,{"$nulls":3},"1","BC","NA"]
[445,"GXDY1223","index","male","1","01AE","LINK",2,0.00525627576147645,"training",null,"1","01AE","CLUSTER",0.08729350702030178,"training",null,"have","LINK"]
[446,"GXDY2223","partner","Female","1","01AE","LINK",2,0.00525627576147645,"training",null,"1","01AE","CLUSTER",0.08729350702030178,"training",null,"have","LINK"]
[447,"GXDY1224","index","male","0","NA","NA",0,{"$nulls":3},"1","01AE","NA"]
[461,"GXDY1231","index","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[481,"GXDY1241","index","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[489,"GXDY1245","index","male","1","01AE","LINK",1,0.007139181741155836,"training",null,"1","01AE","NA",{"$nulls":4},"LINK"]
[490,"GXDY2245","partner","male","1","01AE","LINK",1,0.007139181741155836,"training",null,"0","NA","NA",{"$nulls":4},"LINK"]
[493,"GXDY1247","index","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[503,"GXDY1252","index","Female","1","01AE","LINK",2,0.0023701393966024816,"training",null,"1","01AE","LINK",0.02015900957359398,"training",null,"have","LINK"]
[504,"GXDY2252","partner","male","1","01AE","LINK",2,0.0023701393966024816,"training",null,"1","01AE","LINK",0.02015900957359398,"training",null,"have","LINK"]
[507,"GXDY1254","index","male","1","08BC","LINK",1,0.0016652804735823054,"training",null,"0","NA","NA",{"$nulls":3},"have","LINK"]
[508,"GXDY2254","partner","Female","1","08BC","LINK",1,0.0016652804735823054,"training",null,"1","BC","NA",{"$nulls":3},"have","LINK"]
[514,"GXDY2257","partner","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[517,"GXDY1259","index","male","1","01AE","LINK",2,0.0074340357499444,"training",null,"1","01AE","LINK",0.04242349121338462,"training",null,"have","LINK"]
[518,"GXDY2259","partner","Female","1","01AE","LINK",2,0.0074340357499444,"training",null,"1","01AE","LINK",0.04242349121338462,"training",null,"have","LINK"]
[523,"GXDY1262","index","male","1","01AE","NA",0,{"$nulls":3},"0","NA","NA"]
[551,"GXDY1276","index","Female","1","01AE","LINK",2,0.0039845582375251055,"training",null,"1","01AE","LINK",0.09401544740826685,"training",null,"have","LINK"]
[552,"GXDY2276","partner","male","1","01AE","LINK",2,0.0039845582375251055,"training",null,"1","01AE","LINK",0.09401544740826685,"training",null,"have","LINK"]
[554,"GXDY2277","partner","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[555,"GXDY1278","index","male","1","08BC","LINK",2,0.0007987222145785877,"training",null,"1","BC","LINK",0.008818570743053422,"training",null,"have","LINK"]
[556,"GXDY2278","partner","Female","1","08BC","LINK",2,0.0007987222145785877,"training",null,"1","BC","LINK",0.008818570743053422,"training",null,"have","LINK"]
[562,"GXDY2281","partner","Female","1","08BC","NA",0,{"$nulls":3},"0","NA","NA"]
[563,"GXDY1282","index","male","1","01AE","unlink",2,0.015600175563419286,0.48617,"unlink","1","01AE","unlink",0.12403787897031195,0.14012,"unlink",null,"unlink"]
[564,"GXDY2282","partner","Female","1","01AE","unlink",2,0.015600175563419286,0.48617,"unlink","1","01AE","unlink",0.12403787897031195,0.14012,"unlink",null,"unlink"]
[565,"GXDY1283","index","male","1","01AE","LINK",2,0.007343053487985951,1,"LINK","1","01AE","LINK",0.021842614594480753,0.99992,"link","have","LINK"]
[566,"GXDY2283","partner","Female","1","01AE","LINK",2,0.007343053487985951,1,"LINK","1","01AE","LINK",0.021842614594480753,0.99992,"link","have","LINK"]
[567,"GXDY1284","index","male","1","08BC","LINK",2,0.003931298734954696,1,"link","1","BC","LINK",0.007732341985945402,0.99999,"link","have","LINK"]
[568,"GXDY2284","partner","Female","1","08BC","LINK",2,0.003931298734954696,1,"link","1","BC","LINK",0.007732341985945402,0.99999,"link","have","LINK"]
[569,"GXDY1285","index","male","1","07BC","NA",0,{"$nulls":3},"0","NA","NA"]
[570,"GXDY2285","partner","Female","0","NA","NA",0,{"$nulls":3},"0","NA","NA"]
[571,"GXDY1286","index","male","1","01AE","LINK",2,0.0015885636873360623,1,"link","1","01AE","LINK",0.03857729895484373,0.99945,"link",null,"LINK"]
[572,"GXDY2286","partner","Female","1","01AE","LINK",2,0.0015885636873360623,1,"link","1","01AE","LINK",0.03857729895484373,0.99945,"link",null,"LINK"]
[573,"GXDY1287","index","male","1","01AE","LINK",2,0.002334634591841806,1,"link","1","01AE","LINK",0.02565594807675405,0.99988,"link",null,"LINK"]
[574,"GXDY2287","partner","Female","1","01AE","LINK",2,0.002334634591841806,1,"link","1","01AE","LINK",0.02565594807675405,0.99988,"link",null,"LINK"]
[575,"GXDY1288","index","Female","0","NA","NA",1,{"$nulls":3},"1","BC","unlink",0.3398757569133086,0,"unlink",null,"unlink"]
[576,"GXDY2288","partner","male","1","01AE","NA",1,{"$nulls":3},"1","01AE","unlink",0.3398757569133086,0,"unlink",null,"unlink"]
[577,"GXDY1289","index","male","1","07BC","LINK",2,0,1,"link","1","BC","LINK",0.002036662693817893,0.99999,"link",null,"LINK"]
[578,"GXDY2289","partner","Female","1","07BC","LINK",2,0,1,"link","1","BC","LINK",0.002036662693817893,0.99999,"link",null,"LINK"]
[579,"GXDY1290","index","male","1","01AE","LINK",1,0.041026318685317434,0,"unlink","1","01AE","NA",{"$nulls":3},"NA","Indeter"]
[580,"GXDY2290","partner","Female","1","01AE","LINK",1,0.041026318685317434,0,"unlink","0","NA","NA",{"$nulls":3},"NA","Indeter"]
[581,"GXDY1291","index","Female","1","01AE","LINK",2,0.005568690335377264,1,"link","1","01AE","LINK",0.0605370565371916,0.99309,"link",null,"LINK"]
[582,"GXDY2291","partner","male","1","01AE","LINK",2,0.005568690335377264,1,"link","1","01AE","LINK",0.0605370565371916,0.99309,"link",null,"LINK"]
[583,"GXDY1292","index","male","1","01AE","LINK",2,0.0031225706483904297,1,"link","1","01AE","LINK",0.01720359759021419,0.99996,"link",null,"LINK"]
[584,"GXDY2292","partner","Female","1","01AE","LINK",2,0.0031225706483904297,1,"link","1","01AE","LINK",0.01720359759021419,0.99996,"link",null,"LINK"]
[585,"GXDY1293","index","male","1","01AE","LINK",2,0.017006348289876173,0.00401,"unlink","1","01AE","LINK",0.11731999144535164,0.2433,"unlink","NA","Indeter"]
[586,"GXDY2293","partner","Female","1","01AE","LINK",2,0.017006348289876173,0.00401,"unlink","1","01AE","LINK",0.11731999144535164,0.2433,"unlink","NA","Indeter"]
[587,"GXDY1294","index","male","1","08BC","CLUSTER",2,0.02485225162034655,0,"unlink","1","BC","unlink",0.11364912497365114,0.31874,"unlink","NA","unlink"]
[588,"GXDY2294","partner","Female","1","08BC","CLUSTER",2,0.02485225162034655,0,"unlink","1","BC","unlink",0.11364912497365114,0.31874,"unlink","NA","unlink"]
[589,"GXDY1295","index","male","1","01AE","LINK",2,0.007082995619503678,1,"link","1","01AE","LINK",0.10228445683661687,0.60319,"link",null,"LINK"]
[590,"GXDY2295","partner","Female","1","01AE","LINK",2,0.007082995619503678,1,"link","1","01AE","LINK",0.10228445683661687,0.60319,"link",null,"LINK"]
[591,"GXDY1296","index","male","1","01AE","LINK",2,0.0062647648074662336,1,"link","1","01AE","LINK",0.013690404993714107,0.99997,"link",null,"LINK"]
[592,"GXDY2296","partner","Female","1","01AE","LINK",2,0.0062647648074662336,1,"link","1","01AE","LINK",0.013690404993714107,0.99997,"link",null,"LINK"]
[593,"GXDY1297","index","male","1","01AE","LINK",2,0.00569308740685866,1,"link","1","01AE","LINK",0.020701245919995007,0.99993,"link",null,"LINK"]
[594,"GXDY2297","partner","Female","1","01AE","LINK",2,0.00569308740685866,1,"link","1","01AE","LINK",0.020701245919995007,0.99993,"link",null,"LINK"]
[595,"GXDY1298","index","male","1","01AE","LINK",2,0.00627997467577927,1,"link","1","01AE","LINK",0.07506938165974794,0.96593,"link",null,"LINK"]
[596,"GXDY2298","partner","Female","1","01AE","LINK",2,0.00627997467577927,1,"link","1","01AE","LINK",0.07506938165974794,0.96593,"link",null,"LINK"]
[597,"GXDY1299","index","male","1","01AE/BC","LINK",2,0.016792346014936402,0.00924,"unlink","1","BC","LINK",0.10549826484666358,0.52073,"link",null,"LINK"]
[598,"GXDY2299","partner","Female","1","01AE/BC","LINK",2,0.016792346014936402,0.00924,"unlink","1","BC","LINK",0.10549826484666358,0.52073,"link",null,"LINK"]
[599,"GXDY1300","index","Female","1","01AE","LINK",1,0.006294339614175775,null,null,"0","NA","NA",{"$nulls":4},"LINK"]
[600,"GXDY2300","partner","male","1","01AE","LINK",1,0.006294339614175775,null,null,"0","NA","NA",{"$nulls":4},"LINK"]
[602,"GXDY2301","partner","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[604,"GXDY2302","partner","Female","1","07BC","NA",0,{"$nulls":3},"1","BC","NA"]
[606,"GXDY2303","partner","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[607,"GXDY1304","index","male","1","01AE","LINK",2,0.006372008186883733,1,"link","1","01AE","LINK",0.052462440467667494,0.99723,"link",null,"LINK"]
[608,"GXDY2304","partner","Female","1","01AE","LINK",2,0.006372008186883733,1,"link","1","01AE","LINK",0.052462440467667494,0.99723,"link",null,"LINK"]
[609,"GXDY1305","index","Female","1","01AE","LINK",2,0.009002374201936919,0.99999,"link","1","01AE","LINK",0.07058651567860648,0.97898,"link",null,"LINK"]
[610,"GXDY2305","partner","male","1","01AE","LINK",2,0.009002374201936919,0.99999,"link","1","01AE","LINK",0.07058651567860648,0.97898,"link",null,"LINK"]
[611,"GXDY1306","index","Female","1","01AE","LINK",2,0.0007776051334032371,1,"link","1","01AE","LINK",0.08440548315257133,0.91088,"link",null,"LINK"]
[612,"GXDY2306","partner","male","1","01AE","LINK",2,0.0007776051334032371,1,"link","1","01AE","LINK",0.08440548315257133,0.91088,"link",null,"LINK"]
[613,"GXDY1307","index","male","1","01AE","LINK",2,0.004053848720262414,1,"link","1","01AE","unlink",0.1290100964692638,0.09018,"unlink","NA","Indeter"]
[614,"GXDY2307","partner","Female","1","01AE","LINK",2,0.004053848720262414,1,"link","1","01AE","unlink",0.1290100964692638,0.09018,"unlink","NA","Indeter"]
[615,"GXDY1308","index","Female","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[617,"GXDY1309","index","Female","1","01AE","unlink",2,0.05129527913435618,0,"unlink","1","01AE","unlink",0.16095070234234254,0.00455,"unlink",null,"unlink"]
[618,"GXDY2309","partner","male","1","01AE","unlink",2,0.05129527913435618,0,"unlink","1","01AE","unlink",0.16095070234234254,0.00455,"unlink",null,"unlink"]
[619,"GXDY1310","index","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[621,"GXDY1311","index","male","1","01AE","NA",0,{"$nulls":3},"1","01AE","NA"]
[625,"GXDY1315","partner","Female","1","08BC","NA",0,{"$nulls":3},"1","BC","NA"]

{"sheet":"pol training data","index":1,"n_rows":35,"n_cols":9,"rows_kept":35,"flags":["formulas_cached_only"]}
["individual code","status","Sex","pol PCR","pol_sub","pol_Link","couple ","genetic distance(pol)","pol（Bayesian）"]
["GXDY1024","index","male","       1","01AE","LINK",1,0.010746229557160175,"training"]
["GXDY2024","partner","female","       1","01AE","LINK",1,0.010746229557160175,"training"]
["GXDY1027","index","male","       1","01AE","LINK",2,0,"training"]
["GXDY2027","partner","female","       1","01AE","LINK",2,0,"training"]
["GXDY1046","index","male","       1","01AE","LINK",2,0.014552764228869844,"training"]
["GXDY2046","partner","female","       1","01AE","LINK",2,0.014552764228869844,"training"]
["GXDY1048","index","female","       1","BC","LINK",1,0.0024115802377146344,"training"]
["GXDY2048","partner","male","       1","BC","LINK",1,0.0024115802377146344,"training"]
["GXDY1054","index","male","       1","01AE","LINK",2,0.0031279100857825254,"training"]
["GXDY2054","partner","female","       1","01AE","LINK",2,0.0031279100857825254,"training"]
["GXDY1057","index","male","       1","BC","unlink",2,0.03376680395363042,"training"]
["GXDY2057","partner","female","       1","BC","unlink",2,0.03376680395363042,"training"]
["GXDY1117","index","male","1","01AE","LINK",2,0.0031550491100922526,"training"]
["GXDY2117","partner","female","1","01AE","LINK",2,0.0031550491100922526,"training"]
["GXDY1128","index","male","1","01AE","LINK",1,0.001613554990762215,"training"]
["GXDY2128","partner","female","1","01AE","LINK",1,0.001613554990762215,"training"]
["GXDY1168","index","male","1","01AE","LINK",2,0.009658675815956494,"training"]
["GXDY2168","partner","female","1","01AE","LINK",2,0.009658675815956494,"training"]
["GXDY1169","index","male","1","01AE","LINK",1,0.013450636110858878,"training"]
["GXDY2169","partner","female","1","01AE","LINK",1,0.013450636110858878,"training"]
["GXDY1223","index","male","1","01AE","LINK",2,0.00525627576147645,"training"]
["GXDY2223","partner","female","1","01AE","LINK",2,0.00525627576147645,"training"]
["GXDY1245","index","male","1","01AE","LINK",1,0.007139181741155836,"training"]
["GXDY2245","partner","male","1","01AE","LINK",1,0.007139181741155836,"training"]
["GXDY1252","index","female","1","01AE","LINK",2,0.0023701393966024816,"training"]
["GXDY2252","partner","male","1","01AE","LINK",2,0.0023701393966024816,"training"]
["GXDY1254","index","male","1","BC","LINK",1,0.0016652804735823054,"training"]
["GXDY2254","partner","female","1","BC","LINK",1,0.0016652804735823054,"training"]
["GXDY1259","index","male","1","01AE","LINK",2,0.0074340357499444,"training"]
["GXDY2259","partner","female","1","01AE","LINK",2,0.0074340357499444,"training"]
["GXDY1276","index","female","1","01AE","LINK",2,0.0039845582375251055,"training"]
["GXDY2276","partner","male","1","01AE","LINK",2,0.0039845582375251055,"training"]
["GXDY1278","index","male","1","BC","LINK",2,0.0007987222145785877,"training"]
["GXDY2278","partner","female","1","BC","LINK",2,0.0007987222145785877,"training"]

{"sheet":"pol test data","index":2,"n_rows":47,"n_cols":10,"rows_kept":47,"flags":["formulas_cached_only"]}
["individual code","status","Sex","pol PCR","pol_sub","pol_Link","couple ","genetic distance(pol)","pol（Bayesian）","result（pol）"]
["GXDY1034","index","male","       1","BC","CLUSTER",1,0.004780831835945464,1,"LINK"]
["GXDY2034","partner","female","       1","BC","CLUSTER",1,0.004780831835945464,1,"LINK"]
["GXDY1050","index","female","       1","01AE","CLUSTER",1,0.008242262586523035,1,"LINK"]
["GXDY2050","partner","male","       1","01AE","CLUSTER",1,0.008242262586523035,1,"LINK"]
["GXDY1282","index","male","1","01AE","unlink",2,0.015600175563419286,0.48617,"unlink"]
["GXDY2282","partner","female","1","01AE","unlink",2,0.015600175563419286,0.48617,"unlink"]
["GXDY1283","index","male","1","01AE","LINK",2,0.007343053487985951,1,"LINK"]
["GXDY2283","partner","female","1","01AE","LINK",2,0.007343053487985951,1,"LINK"]
["GXDY1284","index","male","1","BC","LINK",2,0.003931298734954696,1,"link"]
["GXDY2284","partner","female","1","BC","LINK",2,0.003931298734954696,1,"link"]
["GXDY1286","index","male","1","01AE","LINK",2,0.0015885636873360623,1,"link"]
["GXDY2286","partner","female","1","01AE","LINK",2,0.0015885636873360623,1,"link"]
["GXDY1287","index","male","1","01AE","LINK",2,0.002334634591841806,1,"link"]
["GXDY2287","partner","female","1","01AE","LINK",2,0.002334634591841806,1,"link"]
["GXDY1289","index","male","1","BC","LINK",2,0,1,"link"]
["GXDY2289","partner","female","1","BC","LINK",2,0,1,"link"]
["GXDY1290","index","male","1","01AE","LINK",1,0.041026318685317434,0,"unlink"]
["GXDY2290","partner","female","1","01AE","LINK",1,0.041026318685317434,0,"unlink"]
["GXDY1291","index","female","1","01AE","LINK",2,0.005568690335377264,1,"link"]
["GXDY2291","partner","male","1","01AE","LINK",2,0.005568690335377264,1,"link"]
["GXDY1292","index","male","1","01AE","LINK",2,0.0031225706483904297,1,"link"]
["GXDY2292","partner","female","1","01AE","LINK",2,0.0031225706483904297,1,"link"]
["GXDY1293","index","male","1","01AE","LINK",2,0.017006348289876173,0.00401,"unlink"]
["GXDY2293","partner","female","1","01AE","LINK",2,0.017006348289876173,0.00401,"unlink"]
["GXDY1294","index","male","1","BC","CLUSTER",2,0.02485225162034655,0,"unlink"]
["GXDY2294","partner","female","1","BC","CLUSTER",2,0.02485225162034655,0,"unlink"]
["GXDY1295","index","male","1","01AE","LINK",2,0.007082995619503678,1,"link"]
["GXDY2295","partner","female","1","01AE","LINK",2,0.007082995619503678,1,"link"]
["GXDY1296","index","male","1","01AE","LINK",2,0.0062647648074662336,1,"link"]
["GXDY2296","partner","female","1","01AE","LINK",2,0.0062647648074662336,1,"link"]
["GXDY1297","index","male","1","01AE","LINK",2,0.00569308740685866,1,"link"]
["GXDY2297","partner","female","1","01AE","LINK",2,0.00569308740685866,1,"link"]
["GXDY1298","index","male","1","01AE","LINK",2,0.00627997467577927,1,"link"]
["GXDY2298","partner","female","1","01AE","LINK",2,0.00627997467577927,1,"link"]
["GXDY1299","index","male","1","01AE/BC","LINK",2,0.016792346014936402,0.00924,"unlink"]
["GXDY2299","partner","female","1","01AE/BC","LINK",2,0.016792346014936402,0.00924,"unlink"]
["GXDY1304","index","male","1","01AE","LINK",2,0.006372008186883733,1,"link"]
["GXDY2304","partner","female","1","01AE","LINK",2,0.006372008186883733,1,"link"]
["GXDY1305","index","female","1","01AE","LINK",2,0.009002374201936919,0.99999,"link"]
["GXDY2305","partner","male","1","01AE","LINK",2,0.009002374201936919,0.99999,"link"]
["GXDY1306","index","female","1","01AE","LINK",2,0.0007776051334032371,1,"link"]
["GXDY2306","partner","male","1","01AE","LINK",2,0.0007776051334032371,1,"link"]
["GXDY1307","index","male","1","01AE","LINK",2,0.004053848720262414,1,"link"]
["GXDY2307","partner","female","1","01AE","LINK",2,0.004053848720262414,1,"link"]
["GXDY1309","index","female","1","01AE","unlink",2,0.05129527913435618,0,"unlink"]
["GXDY2309","partner","male","1","01AE","unlink",2,0.05129527913435618,0,"unlink"]

{"sheet":"env training data","index":3,"n_rows":23,"n_cols":8,"rows_kept":23,"flags":["formulas_cached_only"]}
["individual code","status","Sex","env PCR","env_sub","env_link","genetic distance(env)","env（Bayesian）"]
["GXDY1027","index","male","1","01AE","LINK",0.022766901882698944,"training"]
["GXDY2027","partner","Female","1","01AE","LINK",0.022766901882698944,"training"]
["GXDY1046","index","male","1","01AE","LINK",0.0765104057405435,"training"]
["GXDY2046","partner","Female","1","01AE","LINK",0.0765104057405435,"training"]
["GXDY1054","index","male","1","01AE","LINK",0.020514099367219395,"training"]
["GXDY2054","partner","Female",1,"01AE","LINK",0.020514099367219395,"training"]
["GXDY1057","index","male","1","BC","LINK",0.022973566689873003,"training"]
["GXDY2057","partner","Female","1","BC","LINK",0.022973566689873003,"training"]
["GXDY1117","index","male","1","01AE","LINK",0.04721592693506562,"training"]
["GXDY2117","partner","Female","1","01AE","LINK",0.04721592693506562,"training"]
["GXDY1168","index","male","1","01AE","LINK",0.08419846502343081,"training"]
["GXDY2168","partner","Female","1","01AE","LINK",0.08419846502343081,"training"]
["GXDY1223","index","male","1","01AE","CLUSTER",0.08729350702030178,"training"]
["GXDY2223","partner","Female","1","01AE","CLUSTER",0.08729350702030178,"training"]
["GXDY1252","index","Female","1","01AE","LINK",0.02015900957359398,"training"]
["GXDY2252","partner","male","1","01AE","LINK",0.02015900957359398,"training"]
["GXDY1259","index","male","1","01AE","LINK",0.04242349121338462,"training"]
["GXDY2259","partner","Female","1","01AE","LINK",0.04242349121338462,"training"]
["GXDY1276","index","Female","1","01AE","LINK",0.09401544740826685,"training"]
["GXDY2276","partner","male","1","01AE","LINK",0.09401544740826685,"training"]
["GXDY1278","index","male","1","BC","LINK",0.008818570743053422,"training"]
["GXDY2278","partner","Female","1","BC","LINK",0.008818570743053422,"training"]

{"sheet":"env test data","index":4,"n_rows":43,"n_cols":9,"rows_kept":43,"flags":["formulas_cached_only"]}
["individual code","status","Sex","env PCR","env_sub","env_link","genetic distance(env)","env（Bayesian）","result（env）"]
["GXDY1282","index","male","1","01AE","unlink",0.12403787897031195,0.14012,"unlink"]
["GXDY2282","partner","female","1","01AE","unlink",0.12403787897031195,0.14012,"unlink"]
["GXDY1283","index","male","1","01AE","LINK",0.021842614594480753,0.99992,"link"]
["GXDY2283","partner","female","1","01AE","LINK",0.021842614594480753,0.99992,"link"]
["GXDY1284","index","male","1","BC","LINK",0.007732341985945402,0.99999,"link"]
["GXDY2284","partner","female","1","BC","LINK",0.007732341985945402,0.99999,"link"]
["GXDY1286","index","male","1","01AE","LINK",0.03857729895484373,0.99945,"link"]
["GXDY2286","partner","female","1","01AE","LINK",0.03857729895484373,0.99945,"link"]
["GXDY1287","index","male","1","01AE","LINK",0.02565594807675405,0.99988,"link"]
["GXDY2287","partner","female","1","01AE","LINK",0.02565594807675405,0.99988,"link"]
["GXDY1288","index","female","1","BC","unlink",0.3398757569133086,0,"unlink"]
["GXDY2288","partner","male","1","01AE","unlink",0.3398757569133086,0,"unlink"]
["GXDY1289","index","male","1","BC","LINK",0.002036662693817893,0.99999,"link"]
["GXDY2289","partner","female","1","BC","LINK",0.002036662693817893,0.99999,"link"]
["GXDY1291","index","female","1","01AE","LINK",0.0605370565371916,0.99309,"link"]
["GXDY2291","partner","male","1","01AE","LINK",0.0605370565371916,0.99309,"link"]
["GXDY1292","index","male","1","01AE","LINK",0.01720359759021419,0.99996,"link"]
["GXDY2292","partner","female","1","01AE","LINK",0.01720359759021419,0.99996,"link"]
["GXDY1293","index","male","1","01AE","LINK",0.11731999144535164,0.2433,"unlink"]
["GXDY2293","partner","female","1","01AE","LINK",0.11731999144535164,0.2433,"unlink"]
["GXDY1294","index","male","1","BC","unlink",0.11364912497365114,0.31874,"unlink"]
["GXDY2294","partner","female","1","BC","unlink",0.11364912497365114,0.31874,"unlink"]
["GXDY1295","index","male","1","01AE","LINK",0.10228445683661687,0.60319,"link"]
["GXDY2295","partner","female","1","01AE","LINK",0.10228445683661687,0.60319,"link"]
["GXDY1296","index","male","1","01AE","LINK",0.013690404993714107,0.99997,"link"]
["GXDY2296","partner","female","1","01AE","LINK",0.013690404993714107,0.99997,"link"]
["GXDY1297","index","male","1","01AE","LINK",0.020701245919995007,0.99993,"link"]
["GXDY2297","partner","female","1","01AE","LINK",0.020701245919995007,0.99993,"link"]
["GXDY1298","index","male","1","01AE","LINK",0.07506938165974794,0.96593,"link"]
["GXDY2298","partner","female","1","01AE","LINK",0.07506938165974794,0.96593,"link"]
["GXDY1299","index","male","1","BC","LINK",0.10549826484666358,0.52073,"link"]
["GXDY2299","partner","female","1","BC","LINK",0.10549826484666358,0.52073,"link"]
["GXDY1304","index","male","1","01AE","LINK",0.052462440467667494,0.99723,"link"]
["GXDY2304","partner","female","1","01AE","LINK",0.052462440467667494,0.99723,"link"]
["GXDY1305","index","female","1","01AE","LINK",0.07058651567860648,0.97898,"link"]
["GXDY2305","partner","male","1","01AE","LINK",0.07058651567860648,0.97898,"link"]
["GXDY1306","index","female","1","01AE","LINK",0.08440548315257133,0.91088,"link"]
["GXDY2306","partner","male","1","01AE","LINK",0.08440548315257133,0.91088,"link"]
["GXDY1307","index","male","1","01AE","unlink",0.1290100964692638,0.09018,"unlink"]
["GXDY2307","partner","female","1","01AE","unlink",0.1290100964692638,0.09018,"unlink"]
["GXDY1309","index","female","1","01AE","unlink",0.16095070234234254,0.00455,"unlink"]
["GXDY2309","partner","male","1","01AE","unlink",0.16095070234234254,0.00455,"unlink"]