{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["2023-11-26-Dörferturnier","lichess_tournament_2023 11 26_V","Hilfe"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2023-11-26-Dörferturnier","index":0,"n_rows":206,"n_cols":26,"rows_kept":206,"cut":false,"hidden":false,"merged":[]}
["Turnier:",null,"https://lichess.org/tournament/VG7xUX2I"]
["Datum:",null,"2023-11-26"]
["Bed.Zeit:",null,"5/3"]
["Berserker:",null,"J","(J/N)"]
["Arenastr:",null,"J","(J/N)"]
["Rang","Titel","Benutzername","Elo","Pkt.","Perf.","Team","Anzahl\nPartien","Bers.\n%","Partien Resultate","Check\nPunkte","Check\nAnzahl\nPartien","Gespielte\nAnzahl\nPartien","Anzahl\nGewinn\nPartien","Anzahl\nRemis\nPartien","Anzahl\nArena Remis\nPartien","Anzahl\nVerlust\nPartien","Anzahl\nBerserker\nPartien","Berserker\nBilanz\n+ Gut\n- Schlecht","Anzahl\nBerserker\nGewinne","Anzahl\nBerserker\nRemis u.\nVerluste","Anzahl\nArena\nStrikes","Pkt.","Faktor\nPerformance\ngeteilt durch\nElozahl","Elo Zuwachs\nPerformance\nminus Elozahl"]
[1,"","TheRealBerniMan",2201,49,2080,"frauenfeld-west",15,0.53,"224033555423344",{"$f":"IF(W7=E7,\"OK\",\"Falsch\")","v":"OK"},{"$f":"IF(H7=0,\"\",IF(M7=H7,\"OK\",\"Falsch\"))","v":"OK"},{"$f":"LEN(J7)","v":15},{"$f":"M7-(M7-LEN(SUBSTITUTE(J7,\"0\",\"\")))-(M7-LEN(SUBSTITUTE(J7,\"1\",\"\")))-P7","v":13},{"$f":"M7-LEN(SUBSTITUTE(J7,\"1\",\"\"))+P7","v":1},{"$f":"IF($Z$7=\"J\",(M7-LEN(SUBSTITUTE(J7,\"42\",\"\")))/2+(M7-LEN(SUBSTITUTE(J7,\"222\",\"\")))/3,0)","v":1},{"$f":"M7-LEN(SUBSTITUTE(J7,\"0\",\"\"))","v":1},{"$f":"ROUND(I7*M7,0)","v":8},{"$f":"IF(R7=0,\"\",T7-U7)","v":6},{"$f":"M7-(M7-(LEN(J7)-LEN(SUBSTITUTE(J7,\"3\",\"\"))))+M7-(M7-(LEN(J7)-LEN(SUBSTITUTE(J7,\"5\",\"\"))))","v":7},{"$f":"R7-T7","v":1},{"$f":"M7-(M7-(LEN(J7)-LEN(SUBSTITUTE(J7,\"4\",\"\"))))+M7-(M7-(LEN(J7)-LEN(SUBSTITUTE(J7,\"5\",\"\"))))","v":7},{"$f":"SUM(MID(J7,ROW(INDIRECT(\"h1:H\"&LEN(J7))),1)*1)","v":49},{"$f":"F7/D7","v":0.94502498864152662},{"$f":"F7-D7","v":-121},{"$f":"C5","v":"J"}]
[2,"","SHKirillSH",2032,38,2024,"suso-schachteam",17,0.4,"20334031222235501","OK",{"$f":"IF(H8=0,\"\",IF(M8=H8,\"OK\",\"Falsch\"))","v":"OK"},17,{"$f":"M8-(M8-LEN(SUBSTITUTE(J8,\"0\",\"\")))-(M8-LEN(SUBSTITUTE(J8,\"1\",\"\")))-P8","v":11},3,{"$f":"IF($Z$7=\"J\",(M8-LEN(SUBSTITUTE(J8,\"42\",\"\")))/2+(M8-LEN(SUBSTITUTE(J8,\"222\",\"\")))/3,0)","v":1},3,{"$f":"ROUND(I8*M8,0)","v":7},{"$f":"IF(R8=0,\"\",T8-U8)","v":5},6,{"$f":"R8-T8","v":1},3,{"$f":"SUM(MID(J8,ROW(INDIRECT(\"h1:H\"&LEN(J8))),1)*1)","v":38},{"$f":"F8/D8","v":0.99606299212598426},{"$f":"F8-D8","v":-8}]
[3,"","denisowitch06",1921,34,2087,"suso-schachteam",12,0.08,"123444444400","OK","OK",12,9,1,0,2,1,1,1,0,7,{"$f":"SUM(MID(J9,ROW(INDIRECT(\"h1:H\"&LEN(J9))),1)*1)","v":34},1.086413326392504,166]
[4,"","Freecs",2146,34,2045,"rossruti-sg-ch",17,0.41,"02133030224400334","OK","OK",17,11,1,0,5,7,3,5,2,3,{"$f":"SUM(MID(J10,ROW(INDIRECT(\"h1:H\"&LEN(J10))),1)*1)","v":34},0.95293569431500469,-101]
[5,"","JMChess03",2205,32,2009,"mullheim-wigoltingen",12,0.42,"032440235540","OK","OK",12,9,0,0,3,5,3,4,1,5,{"$f":"SUM(MID(J11,ROW(INDIRECT(\"h1:H\"&LEN(J11))),1)*1)","v":32},0.91111111111111109,-196]
[6,"","BlitzDude71",2058,31,1921,"pfyn-tg",14,0.36,"20320203344440","OK","OK",14,10,0,0,4,5,1,3,2,4,{"$f":"SUM(MID(J12,ROW(INDIRECT(\"h1:H\"&LEN(J12))),1)*1)","v":31},0.9334305150631681,-137]
[7,"","Lukas_Ro",1481,29,1668,"romanshorn-junioren",18,0,"100220202240202244","OK","OK",18,11,1,0,6,0,"",0,0,3,{"$f":"SUM(MID(J13,ROW(INDIRECT(\"h1:H\"&LEN(J13))),1)*1)","v":29},1.1262660364618502,187]
[8,"","Drachenfestung",1945,28,1794,"schachclub-steckborn",13,0.23,"0202244450023","OK","OK",13,9,0,0,4,3,1,2,1,4,{"$f":"SUM(MID(J14,ROW(INDIRECT(\"h1:H\"&LEN(J14))),1)*1)","v":28},0.9223650385604113,-151]
[9,"","TomicSasa_CH",2072,28,1762,"rorschach",11,0.09,"20224444402","OK","OK",11,9,0,0,2,1,-1,0,1,5,{"$f":"SUM(MID(J15,ROW(INDIRECT(\"h1:H\"&LEN(J15))),1)*1)","v":28},0.85038610038610041,-310]
[10,"","luki999",1795,26,1795,"suso-schachteam",15,0.2,"225003000202244","OK","OK",15,9,0,0,6,3,1,2,1,3,{"$f":"SUM(MID(J16,ROW(INDIRECT(\"h1:H\"&LEN(J16))),1)*1)","v":26},1,0]
[11,"","pedestrian99",1861,26,1793,"kirchplatz-wil",18,0,"0022444442","OK","Falsch",10,7,1,1,2,0,"",0,0,5,{"$f":"SUM(MID(J17,ROW(INDIRECT(\"h1:H\"&LEN(J17))),1)*1)","v":26},0.96346050510478243,-68]
[12,"","ManuelSprenger",2231,26,1782,"wangi-ch",6,1,"335555","OK","OK",6,6,0,0,0,6,6,6,0,4,{"$f":"SUM(MID(J18,ROW(INDIRECT(\"h1:H\"&LEN(J18))),1)*1)","v":26},0.79874495741819806,-449]
[13,"","Parzival1912",2086,26,1756,"sc-aadorf",15,0.8,"313033003033013","OK","OK",15,8,2,0,5,12,4,8,4,0,{"$f":"SUM(MID(J19,ROW(INDIRECT(\"h1:H\"&LEN(J19))),1)*1)","v":26},0.84180249280920427,-330]
[14,"","Scheurer",1488,26,1641,"romanshorn",18,0.11,"220220224420202000","OK","OK",18,10,1,1,7,2,-2,0,2,2,{"$f":"SUM(MID(J20,ROW(INDIRECT(\"h1:H\"&LEN(J20))),1)*1)","v":26},1.1028225806451613,153]
[15,"WIM","theater",2035,25,2116,"wiler-schachbaren-1",9,0.11,"224454400","OK","OK",9,7,0,0,2,1,1,1,0,5,{"$f":"SUM(MID(J21,ROW(INDIRECT(\"h1:H\"&LEN(J21))),1)*1)","v":25},1.0398034398034397,81]
[16,"","elyiax",1392,25,1666,"kanti-wil",14,0.64,"02240200212244","OK","OK",14,9,1,0,4,9,-9,0,9,3,{"$f":"SUM(MID(J22,ROW(INDIRECT(\"h1:H\"&LEN(J22))),1)*1)","v":25},1.1968390804597702,274]
[17,"","Ladina13",1800,24,1695,"zuzwil-sg-ch",15,0.2,"120022023450030","OK","OK",15,8,1,0,6,3,3,3,0,2,{"$f":"SUM(MID(J23,ROW(INDIRECT(\"h1:H\"&LEN(J23))),1)*1)","v":24},0.94166666666666665,-105]
[18,"","agim_1977",1654,24,1679,"liho-wil",12,0,"022400224422","OK","OK",12,8,1,1,3,0,"",0,0,3,{"$f":"SUM(MID(J24,ROW(INDIRECT(\"h1:H\"&LEN(J24))),1)*1)","v":24},1.0151148730350665,25]
[19,"","squat23",2013,22,1974,"liho-wil",11,0.09,"22544021020","OK","OK",11,7,1,0,3,1,1,1,0,3,{"$f":"SUM(MID(J25,ROW(INDIRECT(\"h1:H\"&LEN(J25))),1)*1)","v":22},0.98062593144560362,-39]
[20,"","CH6081",1904,22,1871,"romanshorn",15,0,"120220224022021","OK","OK",15,9,2,0,4,0,"",0,0,1,{"$f":"SUM(MID(J26,ROW(INDIRECT(\"h1:H\"&LEN(J26))),1)*1)","v":22},0.98266806722689071,-33]
[21,"","Zwetschgengott",1811,21,1844,"mullheim-wigoltingen",11,0.18,"13244222001","OK","OK",11,5,4,2,2,2,0,1,1,2,{"$f":"SUM(MID(J27,ROW(INDIRECT(\"h1:H\"&LEN(J27))),1)*1)","v":21},1.0182219768083931,33]
[22,"","N3roo84",1819,21,1731,"gachnang",14,0,"22022022022401","OK","OK",14,9,1,0,4,0,"",0,0,1,{"$f":"SUM(MID(J28,ROW(INDIRECT(\"h1:H\"&LEN(J28))),1)*1)","v":21},0.95162177020340843,-88]
[23,"","nicoh46",1393,21,1435,"gachnang",12,0,"210020224440","OK","OK",12,7,1,0,4,0,"",0,0,3,{"$f":"SUM(MID(J29,ROW(INDIRECT(\"h1:H\"&LEN(J29))),1)*1)","v":21},1.0301507537688441,42]
[24,"","isak-23",2020,20,2250,"liho-wil",6,0,"224444","OK","OK",6,6,0,0,0,0,"",0,0,4,{"$f":"SUM(MID(J30,ROW(INDIRECT(\"h1:H\"&LEN(J30))),1)*1)","v":20},1.113861386138614,230]
[25,"","Murkrow",2013,20,1672,"stgallen-innenstadt",10,0.5,"0002255033","OK","OK",10,6,0,0,4,5,3,4,1,2,{"$f":"SUM(MID(J31,ROW(INDIRECT(\"h1:H\"&LEN(J31))),1)*1)","v":20},0.8306010928961749,-341]
[26,"","Wiesenbocksbart",1250,20,1524,"au-sg",9,0,"224400224","OK","OK",9,7,0,0,2,0,"",0,0,3,{"$f":"SUM(MID(J32,ROW(INDIRECT(\"h1:H\"&LEN(J32))),1)*1)","v":20},1.2192000000000001,274]
[27,"","lennyman",1232,20,1297,"kanti-wil",16,0,"0200022400200224","OK","OK",16,8,0,0,8,0,"",0,0,2,{"$f":"SUM(MID(J33,ROW(INDIRECT(\"h1:H\"&LEN(J33))),1)*1)","v":20},1.0527597402597402,65]
[28,"","robiwild",2112,19,1993,"uzwil",10,0.2,"0225401212","OK","OK",10,6,2,0,2,2,0,1,1,2,{"$f":"SUM(MID(J34,ROW(INDIRECT(\"h1:H\"&LEN(J34))),1)*1)","v":19},0.94365530303030298,-119]
[29,"","onlySeriousChess",1861,19,1749,"rorschach",7,0.86,"3355003","OK","OK",7,5,0,0,2,6,4,5,1,2,{"$f":"SUM(MID(J35,ROW(INDIRECT(\"h1:H\"&LEN(J35))),1)*1)","v":19},0.93981730252552387,-112]
[30,"","Kegov",1195,19,1640,"uzwil",14,0,"22401200220022","OK","OK",14,8,1,0,5,0,"",0,0,1,{"$f":"SUM(MID(J36,ROW(INDIRECT(\"h1:H\"&LEN(J36))),1)*1)","v":19},1.3723849372384938,445]
[31,"","Civolila",1516,19,1331,"hanfland-buchs-sg",11,0.09,"20022444001","OK","OK",11,6,1,0,4,1,-1,0,1,3,{"$f":"SUM(MID(J37,ROW(INDIRECT(\"h1:H\"&LEN(J37))),1)*1)","v":19},0.87796833773087068,-185]
[32,"","T2godto_be",1090,19,1312,"jona-ch",19,0.05,"2002020002244001000","OK","OK",19,7,1,0,11,1,-1,0,1,2,{"$f":"SUM(MID(J38,ROW(INDIRECT(\"h1:H\"&LEN(J38))),1)*1)","v":19},1.2036697247706423,222]
[33,"","World_Genius",1992,18,1661,"sprengschach",10,0,"2244400020","OK","OK",10,6,0,0,4,0,"",0,0,3,{"$f":"SUM(MID(J39,ROW(INDIRECT(\"h1:H\"&LEN(J39))),1)*1)","v":18},0.83383534136546189,-331]
[34,"","Sandro77551",1538,18,1586,"nesslau",17,0,"22020200224000020","OK","OK",17,8,0,0,9,0,"",0,0,1,{"$f":"SUM(MID(J40,ROW(INDIRECT(\"h1:H\"&LEN(J40))),1)*1)","v":18},1.0312093628088426,48]
[35,"","TeamBuchs26",1442,18,1578,"hanfland-buchs-sg",8,0,"22444002","OK","OK",8,6,0,0,2,0,"",0,0,3,{"$f":"SUM(MID(J41,ROW(INDIRECT(\"h1:H\"&LEN(J41))),1)*1)","v":18},1.0943134535367545,136]
[36,"","maria_zhukova_2121",1618,18,1545,"suso-schachteam",12,0,"022402240020","OK","OK",12,7,0,0,5,0,"",0,0,2,{"$f":"SUM(MID(J42,ROW(INDIRECT(\"h1:H\"&LEN(J42))),1)*1)","v":18},0.95488257107540175,-73]
[37,"","sarveeshX",1288,18,1506,"wiler-schachbaren-1",11,0,"22402002240","OK","OK",11,7,0,0,4,0,"",0,0,2,{"$f":"SUM(MID(J43,ROW(INDIRECT(\"h1:H\"&LEN(J43))),1)*1)","v":18},1.1692546583850931,218]
[38,"","RolandKir",1450,18,1425,"kirchberg-sg-ch",9,0,"200022444","OK","OK",9,6,0,0,3,0,"",0,0,3,{"$f":"SUM(MID(J44,ROW(INDIRECT(\"h1:H\"&LEN(J44))),1)*1)","v":18},0.98275862068965514,-25]
[39,"","marko-64",978,18,956,"niederuzwil",15,0,"020224022020020","OK","OK",15,8,0,0,7,0,"",0,0,1,{"$f":"SUM(MID(J45,ROW(INDIRECT(\"h1:H\"&LEN(J45))),1)*1)","v":18},0.97750511247443761,-22]
[40,"","Jourefrmg",1953,17,1938,"munsterlingen",10,0,"0224221022","OK","OK",10,6,2,1,2,0,"",0,0,1,{"$f":"SUM(MID(J46,ROW(INDIRECT(\"h1:H\"&LEN(J46))),1)*1)","v":17},0.99231950844854067,-15]
[41,"","Maeximum",1778,17,1606,"romanshorn",12,0.08,"020224003202","OK","OK",12,7,0,0,5,1,1,1,0,1,{"$f":"SUM(MID(J47,ROW(INDIRECT(\"h1:H\"&LEN(J47))),1)*1)","v":17},0.9032620922384702,-172]
[42,"","Lukas159753",1365,17,1560,"suso-schachteam",13,0,"2244002100002","OK","OK",13,6,1,0,6,0,"",0,0,2,{"$f":"SUM(MID(J48,ROW(INDIRECT(\"h1:H\"&LEN(J48))),1)*1)","v":17},1.1428571428571428,195]
[43,"","lukarlsen",1583,17,1543,"kanti-wil",10,0.1,"0302244002","OK","OK",10,6,0,0,4,1,1,1,0,2,{"$f":"SUM(MID(J49,ROW(INDIRECT(\"h1:H\"&LEN(J49))),1)*1)","v":17},0.97473152242577388,-40]
[44,"","Galaxxion",1386,17,1512,"zuzwil-sg-ch",10,0,"1002244400","OK","OK",10,5,1,0,4,0,"",0,0,3,{"$f":"SUM(MID(J50,ROW(INDIRECT(\"h1:H\"&LEN(J50))),1)*1)","v":17},1.0909090909090908,126]
[45,"","caesar48bc",1669,17,1471,"schulen-aadorf",13,0.38,"0224402000030","OK","OK",13,6,0,0,7,5,-3,1,4,2,{"$f":"SUM(MID(J51,ROW(INDIRECT(\"h1:H\"&LEN(J51))),1)*1)","v":17},0.88136608747753142,-198]
[46,"","MauroSUI",1693,17,1442,"bottighofen",10,0.1,"0022440230","OK","OK",10,6,0,0,4,1,1,1,0,2,{"$f":"SUM(MID(J52,ROW(INDIRECT(\"h1:H\"&LEN(J52))),1)*1)","v":17},0.85174246898995865,-251]
[47,"","patron2510",1744,16,1734,"jona-ch",12,0,"220020222220","OK","OK",12,7,1,1,4,0,"",0,0,0,{"$f":"SUM(MID(J53,ROW(INDIRECT(\"h1:H\"&LEN(J53))),1)*1)","v":16},0.99426605504587151,-10]
[48,"","Malters-LU",1751,16,1729,"schachclub-steckborn",14,0.14000000000000001,"21220230000220","OK","OK",14,7,1,0,6,2,0,1,1,0,{"$f":"SUM(MID(J54,ROW(INDIRECT(\"h1:H\"&LEN(J54))),1)*1)","v":16},0.98743575099942893,-22]
[49,"","SuperiorTenzin",1365,16,1727,"bronschhofen",7,0,"2240224","OK","OK",7,6,0,0,1,0,"",0,0,2,{"$f":"SUM(MID(J55,ROW(INDIRECT(\"h1:H\"&LEN(J55))),1)*1)","v":16},1.2652014652014651,362]
[50,"","migelu",1978,16,1643,"kirchberg-sg-ch",9,0,"220224400","OK","OK",9,6,0,0,3,0,"",0,0,2,{"$f":"SUM(MID(J56,ROW(INDIRECT(\"h1:H\"&LEN(J56))),1)*1)","v":16},0.83063700707785637,-335]
[51,"","modef",1506,16,1545,"schachclub-hoferberg",11,0,"20022022402","OK","OK",11,7,0,0,4,0,"",0,0,1,{"$f":"SUM(MID(J57,ROW(INDIRECT(\"h1:H\"&LEN(J57))),1)*1)","v":16},1.0258964143426295,39]
[52,"","N_bruecklmeier",1222,16,1485,"schach-st-gallen",18,0,"022402000002000022","OK","OK",18,7,0,0,11,0,"",0,0,1,{"$f":"SUM(MID(J58,ROW(INDIRECT(\"h1:H\"&LEN(J58))),1)*1)","v":16},1.2152209492635024,263]
[53,"","ChessShah",2020,16,1398,"nesslau",7,0,"2240224","OK","OK",7,6,0,0,1,0,"",0,0,2,{"$f":"SUM(MID(J59,ROW(INDIRECT(\"h1:H\"&LEN(J59))),1)*1)","v":16},0.69207920792079203,-622]
[54,"","Torterra567",1437,16,1280,"nesslau",7,0,"2240224","OK","OK",7,6,0,0,1,0,"",0,0,2,{"$f":"SUM(MID(J60,ROW(INDIRECT(\"h1:H\"&LEN(J60))),1)*1)","v":16},0.89074460681976342,-157]
[55,"","Johannes_5d",1083,16,1122,"suso-schachteam",11,0,"22400002240","OK","OK",11,6,0,0,5,0,"",0,0,2,{"$f":"SUM(MID(J61,ROW(INDIRECT(\"h1:H\"&LEN(J61))),1)*1)","v":16},1.0360110803324101,39]
[56,"","Anonzmous",965,16,928,"grabs1",17,0.65,"22000003003020031","OK","OK",17,6,1,0,10,11,-5,3,8,0,{"$f":"SUM(MID(J62,ROW(INDIRECT(\"h1:H\"&LEN(J62))),1)*1)","v":16},0.9616580310880829,-37]
[57,"","maurokoel",1879,15,1633,"os-sproochbrugg",14,0.36,"22002103200003","OK","OK",14,6,1,0,7,5,-1,2,3,0,{"$f":"SUM(MID(J63,ROW(INDIRECT(\"h1:H\"&LEN(J63))),1)*1)","v":15},0.86907929749866952,-246]
[58,"","Livio64a",1010,15,1157,"kirchplatz-wil",11,0.09,"02244010002","OK","OK",11,5,1,0,5,1,-1,0,1,2,{"$f":"SUM(MID(J64,ROW(INDIRECT(\"h1:H\"&LEN(J64))),1)*1)","v":15},1.1455445544554455,147]
[59,"","AndrejNikita",1138,15,1100,"schach-matt-wil",9,0,"022442001","OK","OK",9,4,2,1,3,0,"",0,0,2,{"$f":"SUM(MID(J65,ROW(INDIRECT(\"h1:H\"&LEN(J65))),1)*1)","v":15},0.96660808435852374,-38]
[60,"","crimle",1413,14,1527,"schachclub-steckborn",10,0,"2202022022","OK","OK",10,7,0,0,3,0,"",0,0,0,{"$f":"SUM(MID(J66,ROW(INDIRECT(\"h1:H\"&LEN(J66))),1)*1)","v":14},1.0806794055201698,114]
[61,"","RoterYoshi",1128,14,1444,"suso-schachteam",14,0.28999999999999998,"20224000130000","OK","OK",14,5,1,0,8,4,-2,1,3,1,{"$f":"SUM(MID(J67,ROW(INDIRECT(\"h1:H\"&LEN(J67))),1)*1)","v":14},1.2801418439716312,316]
[62,"","Finngratzei",1228,14,1374,"uzwil",15,0,"220200202002200","OK","OK",15,7,0,0,8,0,"",0,0,0,{"$f":"SUM(MID(J68,ROW(INDIRECT(\"h1:H\"&LEN(J68))),1)*1)","v":14},1.1188925081433225,146]
[63,"","Gameknight1",1271,14,1326,"suso-schachteam",15,0,"202002200202002","OK","OK",15,7,0,0,8,0,"",0,0,0,{"$f":"SUM(MID(J69,ROW(INDIRECT(\"h1:H\"&LEN(J69))),1)*1)","v":14},1.043273013375295,55]
[64,"","elamk",1283,14,1182,"suso-schachteam",14,0,"03002020202300","OK","OK",14,6,0,0,8,0,"",2,-2,0,{"$f":"SUM(MID(J70,ROW(INDIRECT(\"h1:H\"&LEN(J70))),1)*1)","v":14},0.92127825409197195,-101]
[65,"","wolf920",726,14,1024,"uzwil",16,0,"2200000202200202",{"$f":"IF(W71=E71,\"OK\",\"Falsch\")","v":"OK"},"OK",{"$f":"LEN(J71)","v":16},7,{"$f":"M71-LEN(SUBSTITUTE(J71,\"1\",\"\"))+P71","v":0},0,{"$f":"M71-LEN(SUBSTITUTE(J71,\"0\",\"\"))","v":9},0,"",{"$f":"M71-(M71-(LEN(J71)-LEN(SUBSTITUTE(J71,\"3\",\"\"))))+M71-(M71-(LEN(J71)-LEN(SUBSTITUTE(J71,\"5\",\"\"))))","v":0},0,{"$f":"M71-(M71-(LEN(J71)-LEN(SUBSTITUTE(J71,\"4\",\"\"))))+M71-(M71-(LEN(J71)-LEN(SUBSTITUTE(J71,\"5\",\"\"))))","v":0},{"$f":"SUM(MID(J71,ROW(INDIRECT(\"h1:H\"&LEN(J71))),1)*1)","v":14},1.4104683195592287,298]
[66,"","KxKh9",2018,13,1732,"kirchberg-sg-ch",5,0.6,"32440","OK",{"$f":"IF(H72=0,\"\",IF(M72=H72,\"OK\",\"Falsch\"))","v":"OK"},5,{"$f":"M72-(M72-LEN(SUBSTITUTE(J72,\"0\",\"\")))-(M72-LEN(SUBSTITUTE(J72,\"1\",\"\")))-P72","v":4},0,{"$f":"IF($Z$7=\"J\",(M72-LEN(SUBSTITUTE(J72,\"42\",\"\")))/2+(M72-LEN(SUBSTITUTE(J72,\"222\",\"\")))/3,0)","v":0},1,{"$f":"ROUND(I72*M72,0)","v":3},{"$f":"IF(R72=0,\"\",T72-U72)","v":-1},1,{"$f":"R72-T72","v":2},2,{"$f":"SUM(MID(J72,ROW(INDIRECT(\"h1:H\"&LEN(J72))),1)*1)","v":13},{"$f":"F72/D72","v":0.85827552031714571},{"$f":"F72-D72","v":-286}]
[67,"","hapewe",1126,13,1286,"plankenli",11,0,"22012200022","OK","OK",11,6,1,0,4,0,"",0,0,0,{"$f":"SUM(MID(J73,ROW(INDIRECT(\"h1:H\"&LEN(J73))),1)*1)","v":13},1.1420959147424512,160]
[68,"","Caner-Ro",823,13,1152,"romanshorn-junioren",13,0,"2020200012022","OK","OK",13,6,1,0,6,0,"",0,0,0,{"$f":"SUM(MID(J74,ROW(INDIRECT(\"h1:H\"&LEN(J74))),1)*1)","v":13},1.399756986634265,329]
[69,"","Sdarko",1104,12,1580,"hanfland-buchs-sg",4,0,"2244","OK","OK",4,4,0,0,0,0,"",0,0,2,{"$f":"SUM(MID(J75,ROW(INDIRECT(\"h1:H\"&LEN(J75))),1)*1)","v":12},1.431159420289855,476]
[70,"","philipp63",1150,12,1336,"berg-tg-ch",10,0,"2020220022","OK","OK",10,6,0,0,4,0,"",0,0,0,{"$f":"SUM(MID(J76,ROW(INDIRECT(\"h1:H\"&LEN(J76))),1)*1)","v":12},1.1617391304347826,186]
[71,"","Kammja",1061,12,1274,"romanshorn-junioren",11,0,"20202002202","OK","OK",11,6,0,0,5,0,"",0,0,0,{"$f":"SUM(MID(J77,ROW(INDIRECT(\"h1:H\"&LEN(J77))),1)*1)","v":12},1.2007540056550423,213]
[72,"","yokasummo",1255,12,1274,"rickenbach-tg",11,0.09,"20002022400","OK","OK",11,5,0,0,6,1,-1,0,1,1,{"$f":"SUM(MID(J78,ROW(INDIRECT(\"h1:H\"&LEN(J78))),1)*1)","v":12},1.0151394422310758,19]
[73,"","SuperiorTenzin2",1358,12,1262,"wiler-schachkids",11,0,"22002202200","OK","OK",11,6,0,0,5,0,"",0,0,0,{"$f":"SUM(MID(J79,ROW(INDIRECT(\"h1:H\"&LEN(J79))),1)*1)","v":12},0.92930780559646542,-96]
[74,"","Wusche",1155,12,1152,"schachclub-steckborn",12,0,"200200224000","OK","OK",12,5,0,0,7,0,"",0,0,1,{"$f":"SUM(MID(J80,ROW(INDIRECT(\"h1:H\"&LEN(J80))),1)*1)","v":12},0.9974025974025974,-3]
[75,"","levin-64",1132,12,1144,"uzwil",11,0,"02202002022","OK","OK",11,6,0,0,5,0,"",0,0,0,{"$f":"SUM(MID(J81,ROW(INDIRECT(\"h1:H\"&LEN(J81))),1)*1)","v":12},1.010600706713781,12]
[76,"","tokyo0",1495,12,1133,"hanfland-buchs-sg",7,0.14000000000000001,"0220224","OK","OK",7,5,0,0,2,1,-1,0,1,1,{"$f":"SUM(MID(J82,ROW(INDIRECT(\"h1:H\"&LEN(J82))),1)*1)","v":12},0.75785953177257526,-362]
[77,"","JuaJamal",820,12,897,"kanti-wattwil",16,0.06,"0022400002020000","OK","OK",16,5,0,0,11,1,-1,0,1,1,{"$f":"SUM(MID(J83,ROW(INDIRECT(\"h1:H\"&LEN(J83))),1)*1)","v":12},1.0939024390243903,77]
[78,"","chessworvati",829,11,1247,"plankenli",10,0,"2200020122","OK","OK",10,5,1,0,4,0,"",0,0,0,{"$f":"SUM(MID(J84,ROW(INDIRECT(\"h1:H\"&LEN(J84))),1)*1)","v":11},1.5042219541616406,418]
[79,"","Barkerstrike_20",1217,10,1359,"gachnang",12,0,"202000200022","OK","OK",12,5,0,0,7,0,"",0,0,0,{"$f":"SUM(MID(J85,ROW(INDIRECT(\"h1:H\"&LEN(J85))),1)*1)","v":10},1.1166803615447822,142]
[80,"","Levin64",1136,10,1306,"berg-tg-ch",12,0,"220002002200","OK","OK",12,5,0,0,7,0,"",0,0,0,{"$f":"SUM(MID(J86,ROW(INDIRECT(\"h1:H\"&LEN(J86))),1)*1)","v":10},1.1496478873239437,170]
[81,"","seri_ous",1213,10,1270,"zihlschlacht",10,0,"2002202020","OK","OK",10,5,0,0,5,0,"",0,0,0,{"$f":"SUM(MID(J87,ROW(INDIRECT(\"h1:H\"&LEN(J87))),1)*1)","v":10},1.0469909315746084,57]
[82,"","Ra_Sta",1194,10,1256,"zihlschlacht",11,0,"02002012120","OK","OK",11,4,2,0,5,0,"",0,0,0,{"$f":"SUM(MID(J88,ROW(INDIRECT(\"h1:H\"&LEN(J88))),1)*1)","v":10},1.051926298157454,62]
[83,"","fleurer",998,10,1153,"wiler-schachbaren-1",10,0,"0202022020","OK","OK",10,5,0,0,5,0,"",0,0,0,{"$f":"SUM(MID(J89,ROW(INDIRECT(\"h1:H\"&LEN(J89))),1)*1)","v":10},1.1553106212424851,155]
[84,"","Alinahae",959,10,1109,"sekundarschule-altnau",8,0,"20202022","OK","OK",8,5,0,0,3,0,"",0,0,0,{"$f":"SUM(MID(J90,ROW(INDIRECT(\"h1:H\"&LEN(J90))),1)*1)","v":10},1.1564129301355579,150]
[85,"","Trankevi-Romanshorn",1063,10,1091,"romanshorn-junioren",10,0,"0224000020","OK","OK",10,4,0,0,6,0,"",0,0,1,{"$f":"SUM(MID(J91,ROW(INDIRECT(\"h1:H\"&LEN(J91))),1)*1)","v":10},1.0263405456255879,28]
[86,"","Ponyhof02",965,10,1058,"kirchplatz-wil",12,0.08,"012012020020","OK","OK",12,4,2,0,6,1,-1,0,1,0,{"$f":"SUM(MID(J92,ROW(INDIRECT(\"h1:H\"&LEN(J92))),1)*1)","v":10},1.0963730569948187,93]
[87,"","Felix0605",1045,10,1049,"suso-schachteam",9,0,"202202002","OK","OK",9,5,0,0,4,0,"",0,0,0,{"$f":"SUM(MID(J93,ROW(INDIRECT(\"h1:H\"&LEN(J93))),1)*1)","v":10},1.0038277511961722,4]
[88,"","FeLiCe_CaPoNiO",908,10,1037,"zuzwil-sg-ch",10,0,"2022002200","OK","OK",10,5,0,0,5,0,"",0,0,0,{"$f":"SUM(MID(J94,ROW(INDIRECT(\"h1:H\"&LEN(J94))),1)*1)","v":10},1.1420704845814977,129]
[89,"","fabulusfungus",482,10,993,"zihlschlacht",7,0,"0224002","OK","OK",7,4,0,0,3,0,"",0,0,1,{"$f":"SUM(MID(J95,ROW(INDIRECT(\"h1:H\"&LEN(J95))),1)*1)","v":10},2.0601659751037342,511]
[90,"","Elina_Frischknecht",718,10,846,"schachclub-hoferberg",20,0,"02000022002000200000","OK","OK",20,5,0,0,15,0,"",0,0,0,{"$f":"SUM(MID(J96,ROW(INDIRECT(\"h1:H\"&LEN(J96))),1)*1)","v":10},1.1782729805013927,128]
[91,"","M31d",787,10,822,"pro-senectute",9,0,"020002240","OK","OK",9,4,0,0,5,0,"",0,0,1,{"$f":"SUM(MID(J97,ROW(INDIRECT(\"h1:H\"&LEN(J97))),1)*1)","v":10},1.0444726810673444,35]
[92,"","enexis3146",2012,9,2019,"zuzwil-sg-ch",6,0.17,"220230","OK","OK",6,4,0,0,2,1,1,1,0,0,{"$f":"SUM(MID(J98,ROW(INDIRECT(\"h1:H\"&LEN(J98))),1)*1)","v":9},1.0034791252485089,7]
[93,"","Spikeleo",1399,9,1501,"eschenz",10,0.2,"2020230000","OK","OK",10,4,0,0,6,2,0,1,1,0,{"$f":"SUM(MID(J99,ROW(INDIRECT(\"h1:H\"&LEN(J99))),1)*1)","v":9},1.0729092208720514,102]
[94,"","MvdK2012",1108,9,1129,"oberschan",8,0,"01102122","OK","OK",8,3,3,0,2,0,"",0,0,0,{"$f":"SUM(MID(J100,ROW(INDIRECT(\"h1:H\"&LEN(J100))),1)*1)","v":9},1.0189530685920578,21]
[95,"","NilsPort",960,9,1122,"grabs1",11,0,"20000202012","OK","OK",11,4,1,0,6,0,"",0,0,0,{"$f":"SUM(MID(J101,ROW(INDIRECT(\"h1:H\"&LEN(J101))),1)*1)","v":9},1.16875,162]
[96,"","NathanDillen",988,9,1078,"grabs1",18,0,"2000002020012","OK","Falsch",13,4,1,0,8,0,"",0,0,0,{"$f":"SUM(MID(J102,ROW(INDIRECT(\"h1:H\"&LEN(J102))),1)*1)","v":9},1.0910931174089069,90]
[97,"","Ngawang1a",843,9,960,"sirnach-tg-ch",11,0,"20102002002","OK","OK",11,4,1,0,6,0,"",0,0,0,{"$f":"SUM(MID(J103,ROW(INDIRECT(\"h1:H\"&LEN(J103))),1)*1)","v":9},1.1387900355871887,117]
[98,"","Benyboy11",935,9,948,"warth-weiningen",12,0,"002200022010","OK","OK",12,4,1,0,7,0,"",0,0,0,{"$f":"SUM(MID(J104,ROW(INDIRECT(\"h1:H\"&LEN(J104))),1)*1)","v":9},1.013903743315508,13]
[99,"","dummgloffe",1375,8,1322,"schachklub-stgallen",6,0.33,"020330","OK","OK",6,3,0,0,3,2,2,2,0,0,{"$f":"SUM(MID(J105,ROW(INDIRECT(\"h1:H\"&LEN(J105))),1)*1)","v":8},0.96145454545454545,-53]
[100,"","noahKoenig",968,8,1212,"schwarzenbach-sg",14,0,"02240000000000","OK","OK",14,3,0,0,11,0,"",0,0,1,{"$f":"SUM(MID(J106,ROW(INDIRECT(\"h1:H\"&LEN(J106))),1)*1)","v":8},1.2520661157024793,244]
[101,"","Dado1234567",1321,8,1183,"uzwil",5,0,"02222","OK","OK",5,3,1,1,1,0,"",0,0,0,{"$f":"SUM(MID(J107,ROW(INDIRECT(\"h1:H\"&LEN(J107))),1)*1)","v":8},0.89553368660105981,-138]
[102,"","RunFynn",1160,7,1273,"university-of-st-gallen-chess-club",10,0,"2020012000","OK","OK",10,3,1,0,6,0,"",0,0,0,{"$f":"SUM(MID(J108,ROW(INDIRECT(\"h1:H\"&LEN(J108))),1)*1)","v":7},1.0974137931034482,113]
[103,"","Luc64x2",919,7,927,"wuppenau",14,0,"20000200010020","OK","OK",14,3,1,0,10,0,"",0,0,0,{"$f":"SUM(MID(J109,ROW(INDIRECT(\"h1:H\"&LEN(J109))),1)*1)","v":7},1.0087051142546246,8]
[104,"","Toxic243",933,7,882,"ps-tobel",9,0,"001220200","OK","OK",9,3,1,0,5,0,"",0,0,0,{"$f":"SUM(MID(J110,ROW(INDIRECT(\"h1:H\"&LEN(J110))),1)*1)","v":7},0.94533762057877813,-51]
[105,"","liazehnder",769,7,843,"niederburen",10,0,"2020102000","OK","OK",10,3,1,0,6,0,"",0,0,0,{"$f":"SUM(MID(J111,ROW(INDIRECT(\"h1:H\"&LEN(J111))),1)*1)","v":7},1.0962288686605981,74]
[106,"","cr7-x-goat",730,7,836,"kirchplatz-wil",13,0,"0021000102100","OK","OK",13,2,3,0,8,0,"",0,0,0,{"$f":"SUM(MID(J112,ROW(INDIRECT(\"h1:H\"&LEN(J112))),1)*1)","v":7},1.1452054794520548,106]
[107,"","Milch63",571,7,604,"oberschan",16,0,"0000001200020020","OK","OK",16,3,1,0,12,0,"",0,0,0,{"$f":"SUM(MID(J113,ROW(INDIRECT(\"h1:H\"&LEN(J113))),1)*1)","v":7},1.0577933450087567,33]
[108,"","retost",935,6,1094,"niederburen",8,0,"20021001","OK","OK",8,2,2,0,4,0,"",0,0,0,{"$f":"SUM(MID(J114,ROW(INDIRECT(\"h1:H\"&LEN(J114))),1)*1)","v":6},1.170053475935829,159]
[109,"","MarlonVW",931,6,987,"suso-schachteam",10,0,"0012200100","OK","OK",10,2,2,0,6,0,"",0,0,0,{"$f":"SUM(MID(J115,ROW(INDIRECT(\"h1:H\"&LEN(J115))),1)*1)","v":6},1.0601503759398496,56]
[110,"","Pippilotta71",917,6,958,"schachclub-hoferberg",9,0,"010012011","OK","OK",9,1,4,0,4,0,"",0,0,0,{"$f":"SUM(MID(J116,ROW(INDIRECT(\"h1:H\"&LEN(J116))),1)*1)","v":6},1.0447110141766631,41]
[111,"","TenzinLo",707,6,741,"sirnach-tg-ch",9,0,"010101210","OK","OK",9,1,4,0,4,0,"",0,0,0,{"$f":"SUM(MID(J117,ROW(INDIRECT(\"h1:H\"&LEN(J117))),1)*1)","v":6},1.0480905233380482,34]
[112,"","Masiesch",714,6,695,"eschenz",7,0,"0102120","OK","OK",7,2,2,0,3,0,"",0,0,0,{"$f":"SUM(MID(J118,ROW(INDIRECT(\"h1:H\"&LEN(J118))),1)*1)","v":6},0.9733893557422969,-19]
[113,"","xegermann",754,6,656,"niederburen",10,0,"0000100212","OK","OK",10,2,2,0,6,0,"",0,0,0,{"$f":"SUM(MID(J119,ROW(INDIRECT(\"h1:H\"&LEN(J119))),1)*1)","v":6},0.87002652519893897,-98]
[114,"","Fabian-James",1157,5,1246,"wangi-ch",14,0,"22000000100000","OK","OK",14,2,1,0,11,0,"",0,0,0,{"$f":"SUM(MID(J120,ROW(INDIRECT(\"h1:H\"&LEN(J120))),1)*1)","v":5},1.0769230769230769,89]
[115,"","pika0204",854,5,890,"eschenz",9,0,"000021110","OK","OK",9,1,3,0,5,0,"",0,0,0,{"$f":"SUM(MID(J121,ROW(INDIRECT(\"h1:H\"&LEN(J121))),1)*1)","v":5},1.0421545667447307,36]
[116,"","Mirjam64",878,5,890,"wuppenau",9,0,"011200100","OK","OK",9,1,3,0,5,0,"",0,0,0,{"$f":"SUM(MID(J122,ROW(INDIRECT(\"h1:H\"&LEN(J122))),1)*1)","v":5},1.0136674259681093,12]
[117,"","Malea_Malibu",938,5,887,"schachclub-hoferberg",9,0,"000002120","OK","OK",9,2,1,0,6,0,"",0,0,0,{"$f":"SUM(MID(J123,ROW(INDIRECT(\"h1:H\"&LEN(J123))),1)*1)","v":5},0.94562899786780386,-51]
[118,"","StarSuperCorn",1085,5,702,"nesslau",5,0,"02120","OK","OK",5,2,1,0,2,0,"",0,0,0,{"$f":"SUM(MID(J124,ROW(INDIRECT(\"h1:H\"&LEN(J124))),1)*1)","v":5},0.64700460829493089,-383]
[119,"","morena64",630,5,640,"wattwil",8,0,"00120200","OK","OK",8,2,1,0,5,0,"",0,0,0,{"$f":"SUM(MID(J125,ROW(INDIRECT(\"h1:H\"&LEN(J125))),1)*1)","v":5},1.0158730158730158,10]
[120,"","AnnemarieW",538,5,628,"wangi-ch",8,0,"00021200","OK","OK",8,2,1,0,5,0,"",0,0,0,{"$f":"SUM(MID(J126,ROW(INDIRECT(\"h1:H\"&LEN(J126))),1)*1)","v":5},1.1672862453531598,90]
[121,"","Pandi0204",588,5,618,"eschenz",12,0,"200100100010","OK","OK",12,1,3,0,8,0,"",0,0,0,{"$f":"SUM(MID(J127,ROW(INDIRECT(\"h1:H\"&LEN(J127))),1)*1)","v":5},1.0510204081632653,30]
[122,"","Jamtasty",1432,4,1276,"kanti-wattwil",3,0,"121","OK","OK",3,1,{"$f":"M128-LEN(SUBSTITUTE(J128,\"1\",\"\"))+P128","v":2},0,0,0,"",0,0,0,{"$f":"SUM(MID(J128,ROW(INDIRECT(\"h1:H\"&LEN(J128))),1)*1)","v":4},0.89106145251396651,-156]
[123,"","ichernov2005",976,4,1071,"frauenfeld-ost",6,0,"220000","OK","OK",6,2,{"$f":"M129-LEN(SUBSTITUTE(J129,\"1\",\"\"))+P129","v":0},0,4,0,"",0,0,0,{"$f":"SUM(MID(J129,ROW(INDIRECT(\"h1:H\"&LEN(J129))),1)*1)","v":4},1.0973360655737705,95]
[124,"","radi1961",1456,4,883,"niederuzwil",3,0,"202","OK","OK",3,2,0,0,1,0,"",0,0,0,{"$f":"SUM(MID(J130,ROW(INDIRECT(\"h1:H\"&LEN(J130))),1)*1)","v":4},0.60645604395604391,-573]
[125,"","Superstoeff",763,4,730,"oberschan",8,0,"00020200","OK","OK",8,2,0,0,6,0,"",0,0,0,{"$f":"SUM(MID(J131,ROW(INDIRECT(\"h1:H\"&LEN(J131))),1)*1)","v":4},0.95674967234600261,-33]
[126,"","aria1nna",893,3,1043,"oberschan",10,0,"0000000012","OK","OK",10,1,1,0,8,0,"",0,0,0,{"$f":"SUM(MID(J132,ROW(INDIRECT(\"h1:H\"&LEN(J132))),1)*1)","v":3},1.1679731243001119,150]
[127,"","kommunistudssr",1988,3,973,"sekundarschule-altnau",1,1,"3","OK","OK",1,1,0,0,0,1,1,1,0,0,{"$f":"SUM(MID(J133,ROW(INDIRECT(\"h1:H\"&LEN(J133))),1)*1)","v":3},0.48943661971830987,-1015]
[128,"","anni7",717,3,712,"schachclub-hoferberg",10,0,"0000210000","OK","OK",10,1,1,0,8,0,"",0,0,0,{"$f":"SUM(MID(J134,ROW(INDIRECT(\"h1:H\"&LEN(J134))),1)*1)","v":3},0.99302649930264997,-5]
[129,"","Kathy71",696,3,662,"kanti-wil",8,0,"00000102",{"$f":"IF(W135=E135,\"OK\",\"Falsch\")","v":"OK"},"OK",{"$f":"LEN(J135)","v":8},1,1,0,{"$f":"M135-LEN(SUBSTITUTE(J135,\"0\",\"\"))","v":6},0,"",{"$f":"M135-(M135-(LEN(J135)-LEN(SUBSTITUTE(J135,\"3\",\"\"))))+M135-(M135-(LEN(J135)-LEN(SUBSTITUTE(J135,\"5\",\"\"))))","v":0},0,{"$f":"M135-(M135-(LEN(J135)-LEN(SUBSTITUTE(J135,\"4\",\"\"))))+M135-(M135-(LEN(J135)-LEN(SUBSTITUTE(J135,\"5\",\"\"))))","v":0},{"$f":"SUM(MID(J135,ROW(INDIRECT(\"h1:H\"&LEN(J135))),1)*1)","v":3},0.95114942528735635,-34]
[130,"","RigzinUdpalla",1925,2,940,"kaltbrunn",1,0,"2","OK",{"$f":"IF(H136=0,\"\",IF(M136=H136,\"OK\",\"Falsch\"))","v":"OK"},1,{"$f":"M136-(M136-LEN(SUBSTITUTE(J136,\"0\",\"\")))-(M136-LEN(SUBSTITUTE(J136,\"1\",\"\")))-P136","v":1},0,{"$f":"IF($Z$7=\"J\",(M136-LEN(SUBSTITUTE(J136,\"42\",\"\")))/2+(M136-LEN(SUBSTITUTE(J136,\"222\",\"\")))/3,0)","v":0},0,{"$f":"ROUND(I136*M136,0)","v":0},{"$f":"IF(R136=0,\"\",T136-U136)","v":""},0,{"$f":"R136-T136","v":0},0,{"$f":"SUM(MID(J136,ROW(INDIRECT(\"h1:H\"&LEN(J136))),1)*1)","v":2},{"$f":"F136/D136","v":0.48831168831168831},{"$f":"F136-D136","v":-985}]
[131,"","Ursina",535,2,621,"oberschan",10,0,"0100000010","OK","OK",10,0,2,0,8,0,"",0,0,0,{"$f":"SUM(MID(J137,ROW(INDIRECT(\"h1:H\"&LEN(J137))),1)*1)","v":2},1.1607476635514018,86]
[132,"","dario_stoni",712,2,557,"schachclub-hoferberg",6,0,"010010","OK","OK",6,0,2,0,4,0,"",0,0,0,{"$f":"SUM(MID(J138,ROW(INDIRECT(\"h1:H\"&LEN(J138))),1)*1)","v":2},0.78230337078651691,-155]
[133,"","jasi34",440,1,733,"schachclub-hoferberg",13,0,"0010000000000","OK","OK",13,0,1,0,12,0,"",0,0,0,{"$f":"SUM(MID(J139,ROW(INDIRECT(\"h1:H\"&LEN(J139))),1)*1)","v":1},1.665909090909091,293]
[134,"","LiSaFrOmPiSa",456,0,662,"oberschan",9,0,"000000000","OK","OK",9,0,0,0,9,0,"",0,0,0,{"$f":"SUM(MID(J140,ROW(INDIRECT(\"h1:H\"&LEN(J140))),1)*1)","v":0},1.4517543859649122,206]
[135,"","mouton59",1968,0,null,"arbon",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J141,ROW(INDIRECT(\"h1:H\"&LEN(J141))),1)*1)","v":{"$error":"#REF!"}},0,-1968]
[136,"","Soibat",1938,0,null,"weinfelden-hobby",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J142,ROW(INDIRECT(\"h1:H\"&LEN(J142))),1)*1)","v":{"$error":"#REF!"}},0,-1938]
[137,"","rago41",1894,0,null,"sc-aadorf",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J143,ROW(INDIRECT(\"h1:H\"&LEN(J143))),1)*1)","v":{"$error":"#REF!"}},0,-1894]
[138,"","fabbib",1752,0,null,"wiler-schachbaren-1",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J144,ROW(INDIRECT(\"h1:H\"&LEN(J144))),1)*1)","v":{"$error":"#REF!"}},0,-1752]
[139,"","Debidebide",1689,0,null,"hanfland-buchs-sg",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J145,ROW(INDIRECT(\"h1:H\"&LEN(J145))),1)*1)","v":{"$error":"#REF!"}},0,-1689]
[140,"","El_Narco",1500,0,null,"arbon",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J146,ROW(INDIRECT(\"h1:H\"&LEN(J146))),1)*1)","v":{"$error":"#REF!"}},0,-1500]
[141,"","lupinmillhaeusler",1500,0,null,"arbon",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J147,ROW(INDIRECT(\"h1:H\"&LEN(J147))),1)*1)","v":{"$error":"#REF!"}},0,-1500]
[142,"","RicoZeller-Hr",1500,0,null,"arbon",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J148,ROW(INDIRECT(\"h1:H\"&LEN(J148))),1)*1)","v":{"$error":"#REF!"}},0,-1500]
[143,"","fabian187",1500,0,null,"arbon",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J149,ROW(INDIRECT(\"h1:H\"&LEN(J149))),1)*1)","v":{"$error":"#REF!"}},0,-1500]
[144,"","Etienne244",1500,0,null,"arbon",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J150,ROW(INDIRECT(\"h1:H\"&LEN(J150))),1)*1)","v":{"$error":"#REF!"}},0,-1500]
[145,"","kosta70",1500,0,null,"nesslau",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J151,ROW(INDIRECT(\"h1:H\"&LEN(J151))),1)*1)","v":{"$error":"#REF!"}},0,-1500]
[146,"","wattwil",1500,0,null,"kanti-wattwil",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J152,ROW(INDIRECT(\"h1:H\"&LEN(J152))),1)*1)","v":{"$error":"#REF!"}},0,-1500]
[147,"","DerSahnenmann",1500,0,null,"sekundarschule-altnau",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J153,ROW(INDIRECT(\"h1:H\"&LEN(J153))),1)*1)","v":{"$error":"#REF!"}},0,-1500]
[148,"","Perseus384",1487,0,null,"teufen-ar",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J154,ROW(INDIRECT(\"h1:H\"&LEN(J154))),1)*1)","v":{"$error":"#REF!"}},0,-1487]
[149,"","toodie123",1311,0,null,"sekundarschule-altnau",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J155,ROW(INDIRECT(\"h1:H\"&LEN(J155))),1)*1)","v":{"$error":"#REF!"}},0,-1311]
[150,"","DSol11",1284,0,null,"schach-thurgau",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J156,ROW(INDIRECT(\"h1:H\"&LEN(J156))),1)*1)","v":{"$error":"#REF!"}},0,-1284]
[151,"","beni222",1200,0,null,"kanti-wattwil",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J157,ROW(INDIRECT(\"h1:H\"&LEN(J157))),1)*1)","v":{"$error":"#REF!"}},0,-1200]
[152,"","WaldemarBastron",1161,0,null,"hanfland-buchs-sg",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J158,ROW(INDIRECT(\"h1:H\"&LEN(J158))),1)*1)","v":{"$error":"#REF!"}},0,-1161]
[153,"","Gondor_III",1151,0,null,"kanti-wil",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J159,ROW(INDIRECT(\"h1:H\"&LEN(J159))),1)*1)","v":{"$error":"#REF!"}},0,-1151]
[154,"","ivan_g_chess",1069,0,null,"uzwil",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J160,ROW(INDIRECT(\"h1:H\"&LEN(J160))),1)*1)","v":{"$error":"#REF!"}},0,-1069]
[155,"","varunesh64",1046,0,null,"sprengschach",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J161,ROW(INDIRECT(\"h1:H\"&LEN(J161))),1)*1)","v":{"$error":"#REF!"}},0,-1046]
[156,"","florian-76",919,0,null,"sprengschach",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J162,ROW(INDIRECT(\"h1:H\"&LEN(J162))),1)*1)","v":{"$error":"#REF!"}},0,-919]
[157,"","lesniakowski",906,0,null,"niederuzwil",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J163,ROW(INDIRECT(\"h1:H\"&LEN(J163))),1)*1)","v":{"$error":"#REF!"}},0,-906]
[158,"","sarako",905,0,null,"sirnach-sek",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J164,ROW(INDIRECT(\"h1:H\"&LEN(J164))),1)*1)","v":{"$error":"#REF!"}},0,-905]
[159,"","ahhhh69",842,0,null,"kanti-wil",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J165,ROW(INDIRECT(\"h1:H\"&LEN(J165))),1)*1)","v":{"$error":"#REF!"}},0,-842]
[160,"","wolfx12",800,0,null,"kirchplatz-wil",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J166,ROW(INDIRECT(\"h1:H\"&LEN(J166))),1)*1)","v":{"$error":"#REF!"}},0,-800]
[161,"","rolandx7",800,0,null,"pro-senectute",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J167,ROW(INDIRECT(\"h1:H\"&LEN(J167))),1)*1)","v":{"$error":"#REF!"}},0,-800]
[162,"","eli64a",773,0,null,"sirnach-sek",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J168,ROW(INDIRECT(\"h1:H\"&LEN(J168))),1)*1)","v":{"$error":"#REF!"}},0,-773]
[163,"","Gemperlijo",730,0,null,"thundorf",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J169,ROW(INDIRECT(\"h1:H\"&LEN(J169))),1)*1)","v":{"$error":"#REF!"}},0,-730]
[164,"","Christian-FRo",716,0,null,"romanshorn-junioren",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J170,ROW(INDIRECT(\"h1:H\"&LEN(J170))),1)*1)","v":{"$error":"#REF!"}},0,-716]
[165,"","O_oOo_O",705,0,null,"schach-matt-wil",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J171,ROW(INDIRECT(\"h1:H\"&LEN(J171))),1)*1)","v":{"$error":"#REF!"}},0,-705]
[166,"","soloflug",704,0,null,"weinfelden-hobby",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J172,ROW(INDIRECT(\"h1:H\"&LEN(J172))),1)*1)","v":{"$error":"#REF!"}},0,-704]
[167,"","Floris2006",701,0,null,"gahwil-ch",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J173,ROW(INDIRECT(\"h1:H\"&LEN(J173))),1)*1)","v":{"$error":"#REF!"}},0,-701]
[168,"","Endrik-Gu",664,0,null,"guttingen-ferienpass-2021",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J174,ROW(INDIRECT(\"h1:H\"&LEN(J174))),1)*1)","v":{"$error":"#REF!"}},0,-664]
[169,"","LiSaFrOmPiSa",456,0,662,"oberschan",null,0,"000000000","OK","",9,0,0,0,9,0,"",0,0,0,{"$f":"SUM(MID(J175,ROW(INDIRECT(\"h1:H\"&LEN(J175))),1)*1)","v":0},1.4517543859649122,206]
[170,"","martan7",612,0,null,"wiler-schachkids",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J176,ROW(INDIRECT(\"h1:H\"&LEN(J176))),1)*1)","v":{"$error":"#REF!"}},0,-612]
[171,"","adriano12x",532,0,null,"niederuzwil",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J177,ROW(INDIRECT(\"h1:H\"&LEN(J177))),1)*1)","v":{"$error":"#REF!"}},0,-532]
[172,"","Lennox64",435,0,null,"schach-matt-wil",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J178,ROW(INDIRECT(\"h1:H\"&LEN(J178))),1)*1)","v":{"$error":"#REF!"}},0,-435]
[173,"","DzoCaloderp",2051,0,null,"schach-st-gallen",null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J179,ROW(INDIRECT(\"h1:H\"&LEN(J179))),1)*1)","v":{"$error":"#REF!"}},0,-2051]
[174,"",null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J180,ROW(INDIRECT(\"h1:H\"&LEN(J180))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[175,"",null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J181,ROW(INDIRECT(\"h1:H\"&LEN(J181))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[176,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J182,ROW(INDIRECT(\"h1:H\"&LEN(J182))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[177,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J183,ROW(INDIRECT(\"h1:H\"&LEN(J183))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[178,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J184,ROW(INDIRECT(\"h1:H\"&LEN(J184))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[179,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J185,ROW(INDIRECT(\"h1:H\"&LEN(J185))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[180,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J186,ROW(INDIRECT(\"h1:H\"&LEN(J186))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[181,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J187,ROW(INDIRECT(\"h1:H\"&LEN(J187))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[182,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J188,ROW(INDIRECT(\"h1:H\"&LEN(J188))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[183,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J189,ROW(INDIRECT(\"h1:H\"&LEN(J189))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[184,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J190,ROW(INDIRECT(\"h1:H\"&LEN(J190))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[185,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J191,ROW(INDIRECT(\"h1:H\"&LEN(J191))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[186,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J192,ROW(INDIRECT(\"h1:H\"&LEN(J192))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[187,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,{"$f":"M193-LEN(SUBSTITUTE(J193,\"1\",\"\"))+P193","v":0},0,0,0,"",0,0,0,{"$f":"SUM(MID(J193,ROW(INDIRECT(\"h1:H\"&LEN(J193))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[188,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J194,ROW(INDIRECT(\"h1:H\"&LEN(J194))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[189,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J195,ROW(INDIRECT(\"h1:H\"&LEN(J195))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[190,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J196,ROW(INDIRECT(\"h1:H\"&LEN(J196))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[191,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J197,ROW(INDIRECT(\"h1:H\"&LEN(J197))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[192,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J198,ROW(INDIRECT(\"h1:H\"&LEN(J198))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[193,null,null,null,null,null,null,null,0,null,{"$f":"IF(W199=E199,\"OK\",\"Falsch\")","v":{"$error":"#REF!"}},"",{"$f":"LEN(J199)","v":0},0,0,0,{"$f":"M199-LEN(SUBSTITUTE(J199,\"0\",\"\"))","v":0},0,"",{"$f":"M199-(M199-(LEN(J199)-LEN(SUBSTITUTE(J199,\"3\",\"\"))))+M199-(M199-(LEN(J199)-LEN(SUBSTITUTE(J199,\"5\",\"\"))))","v":0},0,{"$f":"M199-(M199-(LEN(J199)-LEN(SUBSTITUTE(J199,\"4\",\"\"))))+M199-(M199-(LEN(J199)-LEN(SUBSTITUTE(J199,\"5\",\"\"))))","v":0},{"$f":"SUM(MID(J199,ROW(INDIRECT(\"h1:H\"&LEN(J199))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[194,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},{"$f":"IF(H200=0,\"\",IF(M200=H200,\"OK\",\"Falsch\"))","v":""},0,{"$f":"M200-(M200-LEN(SUBSTITUTE(J200,\"0\",\"\")))-(M200-LEN(SUBSTITUTE(J200,\"1\",\"\")))-P200","v":0},0,{"$f":"IF($Z$7=\"J\",(M200-LEN(SUBSTITUTE(J200,\"42\",\"\")))/2+(M200-LEN(SUBSTITUTE(J200,\"222\",\"\")))/3,0)","v":0},0,{"$f":"ROUND(I200*M200,0)","v":0},{"$f":"IF(R200=0,\"\",T200-U200)","v":""},0,{"$f":"R200-T200","v":0},0,{"$f":"SUM(MID(J200,ROW(INDIRECT(\"h1:H\"&LEN(J200))),1)*1)","v":{"$error":"#REF!"}},{"$f":"F200/D200","v":{"$error":"#DIV/0!"}},{"$f":"F200-D200","v":0}]
[195,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J201,ROW(INDIRECT(\"h1:H\"&LEN(J201))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[196,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J202,ROW(INDIRECT(\"h1:H\"&LEN(J202))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[197,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J203,ROW(INDIRECT(\"h1:H\"&LEN(J203))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[198,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J204,ROW(INDIRECT(\"h1:H\"&LEN(J204))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[199,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J205,ROW(INDIRECT(\"h1:H\"&LEN(J205))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]
[200,null,null,null,null,null,null,null,0,null,{"$error":"#REF!"},"",0,0,0,0,0,0,"",0,0,0,{"$f":"SUM(MID(J206,ROW(INDIRECT(\"h1:H\"&LEN(J206))),1)*1)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"},0]

{"sheet":"lichess_tournament_2023 11 26_V","index":1,"n_rows":173,"n_cols":8,"rows_kept":173,"cut":false,"hidden":false,"merged":[]}
["Rank","Title","Username","Rating","Score","Performance","Team","Sheet"]
[1,"","TheRealBerniMan",2201,49,2080,"frauenfeld-west",""]
[2,"","SHKirillSH",2032,38,2024,"suso-schachteam",""]
[3,"","denisowitch06",1921,34,2087,"suso-schachteam",""]
[4,"","Freecs",2146,34,2045,"rossruti-sg-ch",""]
[5,"","JMChess03",2205,32,2009,"mullheim-wigoltingen",""]
[6,"","BlitzDude71",2058,31,1921,"pfyn-tg",""]
[7,"","Lukas_Ro",1481,29,1668,"romanshorn-junioren",""]
[8,"","Drachenfestung",1945,28,1794,"schachclub-steckborn",""]
[9,"","TomicSasa_CH",2072,28,1762,"rorschach",""]
[10,"","luki999",1795,26,1795,"suso-schachteam",""]
[11,"","pedestrian99",1861,26,1793,"kirchplatz-wil",""]
[12,"","ManuelSprenger",2231,26,1782,"wangi-ch",""]
[13,"","Parzival1912",2086,26,1756,"sc-aadorf",""]
[14,"","Scheurer",1488,26,1641,"romanshorn",""]
[15,"WIM","theater",2035,25,2116,"wiler-schachbaren-1",""]
[16,"","elyiax",1392,25,1666,"kanti-wil",""]
[17,"","Ladina13",1800,24,1695,"zuzwil-sg-ch",""]
[18,"","agim_1977",1654,24,1679,"liho-wil",""]
[19,"","squat23",2013,22,1974,"liho-wil",""]
[20,"","CH6081",1904,22,1871,"romanshorn",""]
[21,"","Zwetschgengott",1811,21,1844,"mullheim-wigoltingen",""]
[22,"","N3roo84",1819,21,1731,"gachnang",""]
[23,"","nicoh46",1393,21,1435,"gachnang",""]
[24,"","isak-23",2020,20,2250,"liho-wil",""]
[25,"","Murkrow",2013,20,1672,"stgallen-innenstadt",""]
[26,"","Wiesenbocksbart",1250,20,1524,"au-sg",""]
[27,"","lennyman",1232,20,1297,"kanti-wil",""]
[28,"","robiwild",2112,19,1993,"uzwil",""]
[29,"","onlySeriousChess",1861,19,1749,"rorschach",""]
[30,"","Kegov",1195,19,1640,"uzwil",""]
[31,"","Civolila",1516,19,1331,"hanfland-buchs-sg",""]
[32,"","T2godto_be",1090,19,1312,"jona-ch",""]
[33,"","World_Genius",1992,18,1661,"sprengschach",""]
[34,"","Sandro77551",1538,18,1586,"nesslau",""]
[35,"","TeamBuchs26",1442,18,1578,"hanfland-buchs-sg",""]
[36,"","maria_zhukova_2121",1618,18,1545,"suso-schachteam",""]
[37,"","sarveeshX",1288,18,1506,"wiler-schachbaren-1",""]
[38,"","RolandKir",1450,18,1425,"kirchberg-sg-ch",""]
[39,"","marko-64",978,18,956,"niederuzwil",""]
[40,"","Jourefrmg",1953,17,1938,"munsterlingen",""]
[41,"","Maeximum",1778,17,1606,"romanshorn",""]
[42,"","Lukas159753",1365,17,1560,"suso-schachteam",""]
[43,"","lukarlsen",1583,17,1543,"kanti-wil",""]
[44,"","Galaxxion",1386,17,1512,"zuzwil-sg-ch",""]
[45,"","caesar48bc",1669,17,1471,"schulen-aadorf",""]
[46,"","MauroSUI",1693,17,1442,"bottighofen",""]
[47,"","patron2510",1744,16,1734,"jona-ch",""]
[48,"","Malters-LU",1751,16,1729,"schachclub-steckborn",""]
[49,"","SuperiorTenzin",1365,16,1727,"bronschhofen",""]
[50,"","migelu",1978,16,1643,"kirchberg-sg-ch",""]
[51,"","modef",1506,16,1545,"schachclub-hoferberg",""]
[52,"","N_bruecklmeier",1222,16,1485,"schach-st-gallen",""]
[53,"","ChessShah",2020,16,1398,"nesslau",""]
[54,"","Torterra567",1437,16,1280,"nesslau",""]
[55,"","Johannes_5d",1083,16,1122,"suso-schachteam",""]
[56,"","Anonzmous",965,16,928,"grabs1",""]
[57,"","maurokoel",1879,15,1633,"os-sproochbrugg",""]
[58,"","Livio64a",1010,15,1157,"kirchplatz-wil",""]
[59,"","AndrejNikita",1138,15,1100,"schach-matt-wil",""]
[60,"","crimle",1413,14,1527,"schachclub-steckborn",""]
[61,"","RoterYoshi",1128,14,1444,"suso-schachteam",""]
[62,"","Finngratzei",1228,14,1374,"uzwil",""]
[63,"","Gameknight1",1271,14,1326,"suso-schachteam",""]
[64,"","elamk",1283,14,1182,"suso-schachteam",""]
[65,"","wolf920",726,14,1024,"uzwil",""]
[66,"","KxKh9",2018,13,1732,"kirchberg-sg-ch",""]
[67,"","hapewe",1126,13,1286,"plankenli",""]
[68,"","Caner-Ro",823,13,1152,"romanshorn-junioren",""]
[69,"","Sdarko",1104,12,1580,"hanfland-buchs-sg",""]
[70,"","philipp63",1150,12,1336,"berg-tg-ch",""]
[71,"","Kammja",1061,12,1274,"romanshorn-junioren",""]
[72,"","yokasummo",1255,12,1274,"rickenbach-tg",""]
[73,"","SuperiorTenzin2",1358,12,1262,"wiler-schachkids",""]
[74,"","Wusche",1155,12,1152,"schachclub-steckborn",""]
[75,"","levin-64",1132,12,1144,"uzwil",""]
[76,"","tokyo0",1495,12,1133,"hanfland-buchs-sg",""]
[77,"","JuaJamal",820,12,897,"kanti-wattwil",""]
[78,"","chessworvati",829,11,1247,"plankenli",""]
[79,"","Barkerstrike_20",1217,10,1359,"gachnang",""]
[80,"","Levin64",1136,10,1306,"berg-tg-ch",""]
[81,"","seri_ous",1213,10,1270,"zihlschlacht",""]
[82,"","Ra_Sta",1194,10,1256,"zihlschlacht",""]
[83,"","fleurer",998,10,1153,"wiler-schachbaren-1",""]
[84,"","Alinahae",959,10,1109,"sekundarschule-altnau",""]
[85,"","Trankevi-Romanshorn",1063,10,1091,"romanshorn-junioren",""]
[86,"","Ponyhof02",965,10,1058,"kirchplatz-wil",""]
[87,"","Felix0605",1045,10,1049,"suso-schachteam",""]
[88,"","FeLiCe_CaPoNiO",908,10,1037,"zuzwil-sg-ch",""]
[89,"","fabulusfungus",482,10,993,"zihlschlacht",""]
[90,"","Elina_Frischknecht",718,10,846,"schachclub-hoferberg",""]
[91,"","M31d",787,10,822,"pro-senectute",""]
[92,"","enexis3146",2012,9,2019,"zuzwil-sg-ch",""]
[93,"","Spikeleo",1399,9,1501,"eschenz",""]
[94,"","MvdK2012",1108,9,1129,"oberschan",""]
[95,"","NilsPort",960,9,1122,"grabs1",""]
[96,"","NathanDillen",988,9,1078,"grabs1",""]
[97,"","Ngawang1a",843,9,960,"sirnach-tg-ch",""]
[98,"","Benyboy11",935,9,948,"warth-weiningen",""]
[99,"","dummgloffe",1375,8,1322,"schachklub-stgallen",""]
[100,"","noahKoenig",968,8,1212,"schwarzenbach-sg",""]
[101,"","Dado1234567",1321,8,1183,"uzwil",""]
[102,"","RunFynn",1160,7,1273,"university-of-st-gallen-chess-club",""]
[103,"","Luc64x2",919,7,927,"wuppenau",""]
[104,"","Toxic243",933,7,882,"ps-tobel",""]
[105,"","liazehnder",769,7,843,"niederburen",""]
[106,"","cr7-x-goat",730,7,836,"kirchplatz-wil",""]
[107,"","Milch63",571,7,604,"oberschan",""]
[108,"","retost",935,6,1094,"niederburen",""]
[109,"","MarlonVW",931,6,987,"suso-schachteam",""]
[110,"","Pippilotta71",917,6,958,"schachclub-hoferberg",""]
[111,"","TenzinLo",707,6,741,"sirnach-tg-ch",""]
[112,"","Masiesch",714,6,695,"eschenz",""]
[113,"","xegermann",754,6,656,"niederburen",""]
[114,"","Fabian-James",1157,5,1246,"wangi-ch",""]
[115,"","pika0204",854,5,890,"eschenz",""]
[116,"","Mirjam64",878,5,890,"wuppenau",""]
[117,"","Malea_Malibu",938,5,887,"schachclub-hoferberg",""]
[118,"","StarSuperCorn",1085,5,702,"nesslau",""]
[119,"","morena64",630,5,640,"wattwil",""]
[120,"","AnnemarieW",538,5,628,"wangi-ch",""]
[121,"","Pandi0204",588,5,618,"eschenz",""]
[122,"","Jamtasty",1432,4,1276,"kanti-wattwil",""]
[123,"","ichernov2005",976,4,1071,"frauenfeld-ost",""]
[124,"","radi1961",1456,4,883,"niederuzwil",""]
[125,"","Superstoeff",763,4,730,"oberschan",""]
[126,"","aria1nna",893,3,1043,"oberschan",""]
[127,"","kommunistudssr",1988,3,973,"sekundarschule-altnau",""]
[128,"","anni7",717,3,712,"schachclub-hoferberg",""]
[129,"","Kathy71",696,3,662,"kanti-wil",""]
[130,"","RigzinUdpalla",1925,2,940,"kaltbrunn",""]
[131,"","Ursina",535,2,621,"oberschan",""]
[132,"","dario_stoni",712,2,557,"schachclub-hoferberg",""]
[133,"","jasi34",440,1,733,"schachclub-hoferberg",""]
[134,"","DzoCaloderp",2051,0,null,"schach-st-gallen",""]
[135,"","mouton59",1968,0,null,"arbon",""]
[136,"","Soibat",1938,0,null,"weinfelden-hobby",""]
[137,"","rago41",1894,0,null,"sc-aadorf",""]
[138,"","fabbib",1752,0,null,"wiler-schachbaren-1",""]
[139,"","Debidebide",1689,0,null,"hanfland-buchs-sg",""]
[140,"","El_Narco",1500,0,null,"arbon",""]
[141,"","lupinmillhaeusler",1500,0,null,"arbon",""]
[142,"","RicoZeller-Hr",1500,0,null,"arbon",""]
[143,"","fabian187",1500,0,null,"arbon",""]
[144,"","Etienne244",1500,0,null,"arbon",""]
[145,"","kosta70",1500,0,null,"nesslau",""]
[146,"","wattwil",1500,0,null,"kanti-wattwil",""]
[147,"","DerSahnenmann",1500,0,null,"sekundarschule-altnau",""]
[148,"","Perseus384",1487,0,null,"teufen-ar",""]
[149,"","toodie123",1311,0,null,"sekundarschule-altnau",""]
[150,"","DSol11",1284,0,null,"schach-thurgau",""]
[151,"","beni222",1200,0,null,"kanti-wattwil",""]
[152,"","WaldemarBastron",1161,0,null,"hanfland-buchs-sg",""]
[153,"","Gondor_III",1151,0,null,"kanti-wil",""]
[154,"","ivan_g_chess",1069,0,null,"uzwil",""]
[155,"","varunesh64",1046,0,null,"sprengschach",""]
[156,"","florian-76",919,0,null,"sprengschach",""]
[157,"","lesniakowski",906,0,null,"niederuzwil",""]
[158,"","sarako",905,0,null,"sirnach-sek",""]
[159,"","ahhhh69",842,0,null,"kanti-wil",""]
[160,"","wolfx12",800,0,null,"kirchplatz-wil",""]
[161,"","rolandx7",800,0,null,"pro-senectute",""]
[162,"","eli64a",773,0,null,"sirnach-sek",""]
[163,"","Gemperlijo",730,0,null,"thundorf",""]
[164,"","Christian-FRo",716,0,null,"romanshorn-junioren",""]
[165,"","O_oOo_O",705,0,null,"schach-matt-wil",""]
[166,"","soloflug",704,0,null,"weinfelden-hobby",""]
[167,"","Floris2006",701,0,null,"gahwil-ch",""]
[168,"","Endrik-Gu",664,0,null,"guttingen-ferienpass-2021",""]
[169,"","LiSaFrOmPiSa",456,0,662,"oberschan",""]
[170,"","martan7",612,0,null,"wiler-schachkids",""]
[171,"","adriano12x",532,0,null,"niederuzwil",""]
[172,"","Lennox64",435,0,null,"schach-matt-wil",""]

{"sheet":"Hilfe","index":2,"n_rows":22,"n_cols":25,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,0,20,6],[20,7,20,9],[20,10,20,11],[20,12,20,24]]}
["Mit dieser Tabelle kann ein Lichess Turnier erfasst werden."]
["1.) Die CSV Daten des Turniers herunterladen."]
["2.) Neue leere Excelmappe erstellen. / Diese öffnen. / Register Daten wählen Aus Text/CSV wählen"]
["3.)Die CSV Datei anwählen /importieren /Daten transformieren Speichern und importieren. "]
["4.) Das Blatt ist jetzt als Excel Blatt in dieser Tabelle."]
["5.)Alle Daten ausser Kopfzeile markieren( Ctrl-c) Kopieren drücken. Zu Tabelle Lichess Turnier erfassen wechseln/ Zelle A2 auswählen Inhalte einfügen: Werte wählen!"]
["Alle Daten sollten jetzt im Blatt lichess Turnier sein."]
["6.) Jetzt müssen nur noch die Grünen Zellen für jeden Spieler ausgefüllt werden."]
[null,"Wer sich die Arbeit erleichtern will installiert eine Text Scanner App wie (Barcode Manager for Education)"]
[null,"Mit dem Snipping Tool alle 10 sichtbaren Spielresultate in ein jpg ausschneiden und speichern Mit der Scanner App das Bild scannen"]
[null,"Die Zwischenablage direkt ins Excel Kopieren wichtig nur die Werte einfügen damit die Formatierung im Excel bestehen bleibt."]
["7.)Die CSV Tabelle und die neue Arbeitsmappe können gelöscht werden."]
["8.) Die Lichess erfassen Tabelle mit speichern unter neuem Namen abspeichern."]
[]
["Wenn die Sortierfilter verwendet werden soll,muss das Blatt entsperrt werden."]
["Register überprüfen wählen Blattschutz aufheben. Jetzt füktioniert das Sortieren."]
["Wichtig die Formeln sind jetzt nicht mehr geschützt. Keine Formelzellen verändern!!  (Die roten und gelben Spalten)"]
["Nach dem Sortieren den Normalansicht Knopf drücken das Blatt wird wieder gesperrt."]
[]
["Die Ergebnisse"]
["Diese Daten sind in der CSV Datei des Turniers\nenthalten und werden mit Inhalte einfügen hier Hineinkopiert. ",null,null,null,null,null,null,"Daten Eingeben von lichess Turnier",null,null,"Check muss OK zeigen",null,"Ergebnisse werden berechnet und angezeit."]
["Rang","Titel","Benutzer\nName","Elo","Pkt.","Perf.","Team","Anzahl\nPartien","Bers.\n%","Partien\nResultate","Check\nPunkte","Check\nAnzahl\nPartien","Gespielte\nAnzahl\nPartien","Anzahl\nGewinn\nPartien","Anzahl\nRemis\nPartien","Anzahl\nArena Remis\nPartien","Anzahl\nVerlust\nPartien","Anzahl\nBerserker\nPartien","Berserker\nBilanz\n+ Gut\n- Schlecht","Anzahl\nBerserker\nGewinne","Anzahl\nBerserker\nRemis u.\nVerluste","Anzahl\nArena\nStrikes","Pkt.","Faktor\nPerformance\ngeteilt durch\nElozahl","Elo Zuwachs\nPerformance\nminus Elozahl"]