{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Draw (2)","Setup","DrawPrep","Draw","PrgPrep","Day1","Day2","notes","tmp","tmpRankings"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Draw (2)","index":0,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,15],[2,9,2,11],[26,17,26,18]]}
[{"$f":"Setup!B3 & \", \" & Setup!B4 & \", \" & Setup!B6 & \", \" & Setup!B8 & \"-\" & Setup!B9","v":"Θ ΕΝΩΣΗ, 1ο Ε3, ΟΑ ΧΑΛΚΙΔΑΣ, 15-16 ΜΑΡΤΙΟΥ"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Setup!B7","v":"Α12"}]
[null,{"$f":"Setup!$B$18","v":2},null,null,null,null,null,null,"p1",null,null,null,null,"p2",null,"p3",null,"p4-5"]
[null,null,null,null,null,null,null,null,null,16,null,null,null,8,null,4,null,2]
["α/α",null,"ByeOrder","ByeSum","ByeCnt","από","seed","Pts","Α.Μ.","Ονοματεπώνυμο","επώνυμο","Σύλλογος"]
[1,1,null,null,0,{"$f":"IF(NOT($G5=\"-\"),VLOOKUP($G5,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B5,Setup!$G$12:$H$27,2,FALSE)","v":1},{"$f":"IF($G5>0,VLOOKUP($G5,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":55.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G5>0,VLOOKUP($G5,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":27444},{"$f":"IF($I5>0,VLOOKUP($I5,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΧΡΙΣΤΑΝΑΣ ΔΗΜΗΤΡΗΣ"},{"$f":"IF(NOT(I5>0),\"\", IF(ISERROR(FIND(\"-\",J5)), LEFT(J5,FIND(\" \",J5)-1), IF(FIND(\"-\",J5)>FIND(\" \",J5),LEFT(J5,FIND(\" \",J5)-1), LEFT(J5,FIND(\"-\",J5)-1) )))","v":"ΧΡΙΣΤΑΝΑΣ"},{"$f":"IF($I5>0,VLOOKUP($I5,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Α.Ο.Α ΑΙΓΑΛΕΩ 92"},1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M5=1,M5=\"a\"),I5,IF(OR(M5=2,M5=\"b\"),I6,\"\")),IF(OR(M5=1,M5=\"1\"),K5,IF(OR(M5=2,M5=\"b\"),K6,\"\"))))","v":"ΧΡΙΣΤΑΝΑΣ"}]
[2,{"$f":"1-D6+4","v":4},1,{"$f":"E6","v":1},{"$f":"IF($B$2>=C6,1,0)","v":1},{"$f":"IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":""},{"$f":"IF($B$2>=C6,\"-\",VLOOKUP($B6,Setup!$G$12:$H$27,2,FALSE))","v":"-"},{"$f":"IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":0},{"$f":"IF($I6>0,VLOOKUP($I6,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"bye"},{"$f":"IF(NOT(I6>0),\"\", IF(ISERROR(FIND(\"-\",J6)), LEFT(J6,FIND(\" \",J6)-1), IF(FIND(\"-\",J6)>FIND(\" \",J6),LEFT(J6,FIND(\" \",J6)-1), LEFT(J6,FIND(\"-\",J6)-1) )))","v":""},{"$f":"IF($I6>0,VLOOKUP($I6,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":""},null,null,1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(O6=1,O6=\"a\"),N5,IF(OR(O6=2,O6=\"b\"),N7,\"\")),IF(OR(O6=1,O6=\"a\"),N5,IF(OR(O6=2,O6=\"b\"),N7,\"\"))))","v":"ΧΡΙΣΤΑΝΑΣ"}]
[3,{"$f":"2-D7+4","v":5},null,{"$f":"D6+E7","v":1},0,{"$f":"IF(NOT($G7=\"-\"),VLOOKUP($G7,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B7,Setup!$G$12:$H$27,2,FALSE)","v":9},{"$f":"IF($G7>0,VLOOKUP($G7,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":5},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G7>0,VLOOKUP($G7,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":33606},{"$f":"IF($I7>0,VLOOKUP($I7,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΓΙΩΤΗΣ ΧΑΡΑΛΑΜΠΟΣ"},"ΓΙΩΤΗΣ",{"$f":"IF($I7>0,VLOOKUP($I7,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΓΟ ΠΑΛΑΣΚΑΣ"},1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M7=1,M7=\"a\"),I7,IF(OR(M7=2,M7=\"b\"),I8,\"\")),IF(OR(M7=1,M7=\"a\"),K7,IF(OR(M7=2,M7=\"b\"),K8,\"\"))))","v":"ΓΙΩΤΗΣ"},null,"62 60"]
[4,{"$f":"3-D8+4","v":6},7,1,{"$f":"IF($B$2>=C8,1,0)","v":0},{"$f":"IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C8,\"-\",VLOOKUP($B8,Setup!$G$12:$H$27,2,FALSE))","v":6},{"$f":"IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":8.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":33565},{"$f":"IF($I8>0,VLOOKUP($I8,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΖΑΧΑΡΟΓΙΩΡΓΑΣ ΓΙΑΝΝΗΣ"},"ΖΑΧΑΡΟΓΙΩΡΓΑΣ",{"$f":"IF($I8>0,VLOOKUP($I8,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΓΟ ΠΑΛΑΣΚΑΣ"},null,"62 61",null,null,1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(Q8=1,Q8=\"a\"),P6,IF(OR(Q8=2,Q8=\"b\"),P10,\"\")),IF(OR(Q8=1,Q8=\"a\"),P6,IF(OR(Q8=2,Q8=\"b\"),P10,\"\"))))","v":"ΧΡΙΣΤΑΝΑΣ"}]
[5,{"$f":"VALUE(Setup!E2)","v":4},null,1,0,{"$f":"IF(NOT($G9=\"-\"),VLOOKUP($G9,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B9,Setup!$G$12:$H$27,2,FALSE)","v":4},{"$f":"IF($G9>0,VLOOKUP($G9,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":39},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G9>0,VLOOKUP($G9,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":31088},{"$f":"IF($I9>0,VLOOKUP($I9,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ ΚΩΝΣΤΑΝΤΙΝΟΣ"},"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ",{"$f":"IF($I9>0,VLOOKUP($I9,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Ο.Α.ΠΕΤΡΟΥΠΟΛΗΣ"},1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M9=1,M9=\"a\"),I9,IF(OR(M9=2,M9=\"b\"),I10,\"\")),IF(OR(M9=1,M9=\"a\"),K9,IF(OR(M9=2,M9=\"b\"),K10,\"\"))))","v":"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ"},null,null,null,"62 62"]
[6,{"$f":"4-D10+4","v":7},{"$f":"IF(Setup!E2=3,3,4)","v":4},1,{"$f":"IF($B$2>=C10,1,0)","v":0},{"$f":"IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C10,\"-\",VLOOKUP($B10,Setup!$G$12:$H$27,2,FALSE))","v":11},{"$f":"IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":1.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":28665},{"$f":"IF($I10>0,VLOOKUP($I10,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΜΑΜΑΗΣ ΙΩΑΝΝΗΣ"},"ΜΑΜΑΗΣ",{"$f":"IF($I10>0,VLOOKUP($I10,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Σ.Α. ΓΑΛΑΤΣΙΟΥ"},null,"60 60",1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(O10=1,O10=\"a\"),N9,IF(OR(O10=2,O10=\"b\"),N11,\"\")),IF(OR(O10=1,O10=\"a\"),N9,IF(OR(O10=2,O10=\"b\"),N11,\"\"))))","v":"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ"}]
[7,{"$f":"5-D11+4","v":8},5,1,{"$f":"IF($B$2>=C11,1,0)","v":0},{"$f":"IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C11,\"-\",VLOOKUP($B11,Setup!$G$12:$H$27,2,FALSE))","v":10},{"$f":"IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":2.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":33659},{"$f":"IF($I11>0,VLOOKUP($I11,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΚΟΥΡΣΑΡΗΣ ΝΙΚΗΤΑΣ"},"ΚΟΥΡΣΑΡΗΣ",{"$f":"IF($I11>0,VLOOKUP($I11,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΑΑ ΑΙΓΑΛΕΩ"},2,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M11=1,M11=\"a\"),I11,IF(OR(M11=2,M11=\"b\"),I12,\"\")),IF(OR(M11=1,M11=\"a\"),K11,IF(OR(M11=2,M11=\"b\"),K12,\"\"))))","v":"ΧΑΡΑΛΑΜΠΙΔΗΣ"},null,"64 61"]
[8,{"$f":"6-D12+4","v":9},null,1,0,{"$f":"IF(NOT($G12=\"-\"),VLOOKUP($G12,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B12,Setup!$G$12:$H$27,2,FALSE)","v":5},{"$f":"IF($G12>0,VLOOKUP($G12,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":36.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G12>0,VLOOKUP($G12,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32524},{"$f":"IF($I12>0,VLOOKUP($I12,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΧΑΡΑΛΑΜΠΙΔΗΣ ΚΩΝΣΤΑΝΤΙΝΟΣ"},"ΧΑΡΑΛΑΜΠΙΔΗΣ",{"$f":"IF($I12>0,VLOOKUP($I12,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Α.Ο.Α ΑΙΓΑΛΕΩ 92"},null,"60 60",null,null,1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(Q12=1,Q12=\"a\"),R8,IF(OR(Q12=2,Q12=\"b\"),R16,\"\")),IF(OR(Q12=1,Q12=\"a\"),R8,IF(OR(Q12=2,Q12=\"b\"),R16,\"\"))))","v":"ΧΡΙΣΤΑΝΑΣ"}]
[9,{"$f":"VALUE(Setup!E3)","v":3},null,1,0,{"$f":"IF(NOT($G13=\"-\"),VLOOKUP($G13,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B13,Setup!$G$12:$H$27,2,FALSE)","v":3},{"$f":"IF($G13>0,VLOOKUP($G13,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":40.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G13>0,VLOOKUP($G13,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32623},{"$f":"IF($I13>0,VLOOKUP($I13,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΖΑΧΙΩΤΗΣ ΦΙΛΛΙΠΟΣ"},"ΖΑΧΙΩΤΗΣ",{"$f":"IF($I13>0,VLOOKUP($I13,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΓΟ ΠΑΛΑΣΚΑΣ"},1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M13=1,M13=\"a\"),I13,IF(OR(M13=2,M13=\"b\"),I14,\"\")),IF(OR(M13=1,M13=\"a\"),K13,IF(OR(M13=2,M13=\"b\"),K14,\"\"))))","v":"ΖΑΧΙΩΤΗΣ"},null,null,null,"76 57 63"]
[10,{"$f":"7-D14+4","v":10},{"$f":"IF(Setup!E2=3,4,3)","v":3},1,{"$f":"IF($B$2>=C14,1,0)","v":0},{"$f":"IF(NOT($G14=\"-\"),VLOOKUP($G14,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C14,\"-\",VLOOKUP($B14,Setup!$G$12:$H$27,2,FALSE))","v":7},{"$f":"IF(NOT($G14=\"-\"),VLOOKUP($G14,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":6},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G14=\"-\"),VLOOKUP($G14,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":33660},{"$f":"IF($I14>0,VLOOKUP($I14,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΚΟΥΡΣΑΡΗΣ ΓΙΩΡΓΟΣ"},"ΚΟΥΡΣΑΡΗΣ",{"$f":"IF($I14>0,VLOOKUP($I14,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΑΑ ΑΙΓΑΛΕΩ"},null,"60 60",1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(O14=1,O14=\"a\"),N13,IF(OR(O14=2,O14=\"b\"),N15,\"\")),IF(OR(O14=1,O14=\"a\"),N13,IF(OR(O14=2,O14=\"b\"),N15,\"\"))))","v":"ΖΑΧΙΩΤΗΣ"}]
[11,{"$f":"8-D15+4","v":11},null,1,0,{"$f":"IF(NOT($G15=\"-\"),VLOOKUP($G15,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B15,Setup!$G$12:$H$27,2,FALSE)","v":8},{"$f":"IF($G15>0,VLOOKUP($G15,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":6},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G15>0,VLOOKUP($G15,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":31792},{"$f":"IF($I15>0,VLOOKUP($I15,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΣΑΚΟΓΙΑΝΝΗΣ ΒΑΠΤΙΣΤΗΣ"},"ΣΑΚΟΓΙΑΝΝΗΣ",{"$f":"IF($I15>0,VLOOKUP($I15,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Α.Ο ΧΑΙΔΑΡΙΟΥ"},1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M15=1,M15=\"a\"),I15,IF(OR(M15=2,M15=\"b\"),I16,\"\")),IF(OR(M15=1,M15=\"a\"),K15,IF(OR(M15=2,M15=\"b\"),K16,\"\"))))","v":"ΣΑΚΟΓΙΑΝΝΗΣ"},null,"61 60"]
[12,{"$f":"9-D16+4","v":12},6,1,{"$f":"IF($B$2>=C16,1,0)","v":0},{"$f":"IF(NOT($G16=\"-\"),VLOOKUP($G16,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C16,\"-\",VLOOKUP($B16,Setup!$G$12:$H$27,2,FALSE))","v":13},{"$f":"IF(NOT($G16=\"-\"),VLOOKUP($G16,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G16=\"-\"),VLOOKUP($G16,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":34969},{"$f":"IF($I16>0,VLOOKUP($I16,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΚΑΤΣΟΥΛΗΣ ΝΙΚΟΛΑΟΣ"},"ΚΑΤΣΟΥΛΗΣ",{"$f":"IF($I16>0,VLOOKUP($I16,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΑΙΟΛΟΣ ΙΛΙΟΥ"},null,"62 61",null,null,1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(Q16=1,Q16=\"a\"),P14,IF(OR(Q16=2,Q16=\"b\"),P18,\"\")),IF(OR(Q16=1,Q16=\"a\"),P14,IF(OR(Q16=2,Q16=\"b\"),P18,\"\"))))","v":"ΖΑΧΙΩΤΗΣ"}]
[13,{"$f":"10-D17+4","v":13},null,1,0,{"$f":"IF(NOT($G17=\"-\"),VLOOKUP($G17,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B17,Setup!$G$12:$H$27,2,FALSE)","v":12},{"$f":"IF($G17>0,VLOOKUP($G17,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G17>0,VLOOKUP($G17,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32826},{"$f":"IF($I17>0,VLOOKUP($I17,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΑΡΑΜΠΑΤΖΗΣ ΓΙΩΡΓΟΣ"},"ΑΡΑΜΠΑΤΖΗΣ",{"$f":"IF($I17>0,VLOOKUP($I17,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Ο.Α.ΣΑΛΑΜΙΝΑΣ"},2,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M17=1,M17=\"a\"),I17,IF(OR(M17=2,M17=\"b\"),I18,\"\")),IF(OR(M17=1,M17=\"a\"),K17,IF(OR(M17=2,M17=\"b\"),K18,\"\"))))","v":"ΚΑΣΣΗΣ"},null,null,null,"61 62"]
[14,{"$f":"11-D18+4","v":14},8,1,{"$f":"IF($B$2>=C18,1,0)","v":0},{"$f":"IF(NOT($G18=\"-\"),VLOOKUP($G18,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C18,\"-\",VLOOKUP($B18,Setup!$G$12:$H$27,2,FALSE))","v":14},{"$f":"IF(NOT($G18=\"-\"),VLOOKUP($G18,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G18=\"-\"),VLOOKUP($G18,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32766},{"$f":"IF($I18>0,VLOOKUP($I18,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΚΑΣΣΗΣ ΙΩΑΝΝΗΣ"},"ΚΑΣΣΗΣ",{"$f":"IF($I18>0,VLOOKUP($I18,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Α.Ο.ΧΑΙΔΑΡΙΟΥ"},null,"62 61",2,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(O18=1,O18=\"a\"),N17,IF(OR(O18=2,O18=\"b\"),N19,\"\")),IF(OR(O18=1,O18=\"a\"),N17,IF(OR(O18=2,O18=\"b\"),N19,\"\"))))","v":"ΚΑΡΑΜΑΝΗΣ"}]
[15,{"$f":"12-D19+4","v":14},2,2,{"$f":"IF($B$2>=C19,1,0)","v":1},{"$f":"IF(NOT($G19=\"-\"),VLOOKUP($G19,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":""},{"$f":"IF($B$2>=C19,\"-\",VLOOKUP($B19,Setup!$G$12:$H$27,2,FALSE))","v":"-"},{"$f":"IF(NOT($G19=\"-\"),VLOOKUP($G19,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G19=\"-\"),VLOOKUP($G19,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":0},{"$f":"IF($I19>0,VLOOKUP($I19,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"bye"},"",{"$f":"IF($I19>0,VLOOKUP($I19,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":""},2,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M19=1,M19=\"a\"),I19,IF(OR(M19=2,M19=\"b\"),I20,\"\")),IF(OR(M19=1,M19=\"a\"),K19,IF(OR(M19=2,M19=\"b\"),K20,\"\"))))","v":"ΚΑΡΑΜΑΝΗΣ"},null,"61 75"]
[16,2,null,2,0,{"$f":"IF(NOT($G20=\"-\"),VLOOKUP($G20,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B20,Setup!$G$12:$H$27,2,FALSE)","v":2},{"$f":"IF($G20>0,VLOOKUP($G20,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":42},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G20>0,VLOOKUP($G20,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":31791},{"$f":"IF($I20>0,VLOOKUP($I20,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΚΑΡΑΜΑΝΗΣ ΟΡΕΣΤΗΣ"},"ΚΑΡΑΜΑΝΗΣ",{"$f":"IF($I20>0,VLOOKUP($I20,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Α.Ο ΧΑΙΔΑΡΙΟΥ"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,"seeded players"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"1. \" & IF(Setup!B19>0,LEFT(DrawPrep!D3,FIND(\" \",DrawPrep!D3)+1),\"\")","v":"1. ΧΡΙΣΤΑΝΑΣ Δ"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"2. \" & IF(Setup!B19>1,LEFT(DrawPrep!D4,FIND(\" \",DrawPrep!D4)+1),\"\")","v":"2. ΚΑΡΑΜΑΝΗΣ Ο"},null,null,null,null,null,null,null,"επιδιαιτητής"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"3. \" & IF(Setup!B19>2,LEFT(DrawPrep!D5,FIND(\" \",DrawPrep!D5)+1),\"\")","v":"3. ΖΑΧΙΩΤΗΣ Φ"},null,null,null,null,null,null,null,{"$f":"Setup!B10","v":"ΤΣΑΔΑΡΗΣ ΣΑΚΗΣ"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"4. \" & IF(Setup!B19>3,LEFT(DrawPrep!D6,FIND(\" \",DrawPrep!D6)+1),\"\")","v":"4. ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ Κ"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"BoldPlayers"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Setup!$B$19>0,LEFT(DrawPrep!D3,FIND(\" \",DrawPrep!D3)-1))","v":"ΧΡΙΣΤΑΝΑΣ"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Setup!$B$19>1,LEFT(DrawPrep!D4,FIND(\" \",DrawPrep!D4)-1))","v":"ΚΑΡΑΜΑΝΗΣ"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Setup!$B$19>2,LEFT(DrawPrep!D5,FIND(\" \",DrawPrep!D5)-1))","v":"ΖΑΧΙΩΤΗΣ"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Setup!$B$19>3,LEFT(DrawPrep!D6,FIND(\" \",DrawPrep!D6)-1))","v":"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ"}]

{"sheet":"Setup","index":1,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,3,2,3],[0,0,0,1]]}
["16άρι ταμπλό",null,null,"Θέσεις","seed"]
[null,null,null,"3-4",{"$f":"VALUE(LEFT(F2,1))","v":4},"4 3"]
["Διοργανωτής: ","Θ ΕΝΩΣΗ",null,null,{"$f":"VALUE(RIGHT(F2,1))","v":3}]
["Τίτλος Τουρνουά: ","1ο Ε3"]
["type: "]
["Έδρα αγώνων: ","ΟΑ ΧΑΛΚΙΔΑΣ"]
["Κατηγορία: ","Α12",null,"0 0 1 2 3 4 9 6 11 10 5 7 8 13 12 14 "]
["Έναρξη: ","15",null,"1 2 3 4 "]
["Λήξη: ","16 ΜΑΡΤΙΟΥ",null,"0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0  "]
["Επιδιατητής: ","ΤΣΑΔΑΡΗΣ ΣΑΚΗΣ"]
["Τηλέφωνο επιδ: ",null,null,0,"seed","space pos","Index","Value"]
[null,null,null,{"$f":"IF(E12=\"-\",\"-\",IF(E12>0,D11+1,0))","v":0},{"$f":"IF(F12>0,VALUE(MID($D$7,1,F12-1)),\"-\")","v":0},{"$f":"IF(LEN($D$7)>1,FIND(\" \",$D$7,1),0)","v":2},0,0]
[null,null,null,{"$f":"IF(E13=\"-\",\"-\",IF(E13>0,D12+1,0))","v":0},{"$f":"IF(F13>0,VALUE(MID($D$7,F12+1,F13-F12-1)),\"-\")","v":0},{"$f":"IF(AND(F12>0,LEN($D$7)>F12+1),FIND(\" \",$D$7,F12+1),0)","v":4},0,0]
[null,null,null,{"$f":"IF(E14=\"-\",\"-\",IF(E14>0,D13+1,0))","v":1},1,6,1,1]
[null,null,null,{"$f":"IF(E15=\"-\",\"-\",IF(E15>0,D14+1,0))","v":2},{"$f":"IF(F15>0,VALUE(MID($D$7,F14+1,F15-F14-1)),\"-\")","v":2},8,2,2]
[null,null,null,3,{"$f":"IF(F16>0,VALUE(MID($D$7,F15+1,F16-F15-1)),\"-\")","v":3},10,3,3]
["Main Draw",{"$f":"\"(\"&COUNTBLANK(DrawPrep!D3:D18)&\")\"","v":"(2)"},null,4,{"$f":"IF(F17>0,VALUE(MID($D$7,F16+1,F17-F16-1)),\"-\")","v":4},12,4,4]
["Πλήθος bye (0-7): ",{"$f":"COUNTBLANK(DrawPrep!D3:D18)","v":2},null,5,9,14,5,9]
["Αριθμός θέσεων seeded: ",4,null,6,6,16,6,6]
[null,null,null,7,11,19,7,11]
[null,null,null,8,10,22,8,10]
[null,null,null,9,5,24,9,5]
[null,null,null,10,7,26,10,7]
["md  (# για off) ","ok",null,11,8,28,11,8]
[null,null,null,12,13,31,12,13]
[null,null,null,13,12,34,13,12]
["=RandUniq(3;4;2)",null,null,14,14,37,14,14]
[]
["=LEFT(D9;$B$18*2)&LEFT(D8;$B$19*2)&RandUniq($B$19+1;16-$B$18;16-$B$19-$B$18)&\" \""]
[]
[null,null," "]

{"sheet":"DrawPrep","index":2,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[19,1,19,3]]}
[{"$f":"Setup!$B$3 & \", \" & Setup!$B$4 & \", \" & Setup!$B$6 & \", \" & Setup!$B$8 & \"-\" & Setup!$B$9","v":"Θ ΕΝΩΣΗ, 1ο Ε3, ΟΑ ΧΑΛΚΙΔΑΣ, 15-16 ΜΑΡΤΙΟΥ"},null,null,null,null,null,null,{"$f":"Setup!$B$7","v":"Α12"}]
["α/α","από","Α.Μ.","Ονοματεπώνυμο","Σύλλογος","βαθμοί","Τηλέφωνο","Υπογραφή","SortPts","Rnd","trim"]
[1,null,27444,"ΧΡΙΣΤΑΝΑΣ ΔΗΜΗΤΡΗΣ","Α.Ο.Α ΑΙΓΑΛΕΩ 92",55.5,null,null,{"$f":"IF(D3>\" \",F3+J3,0)","v":55.50033873084184},3.3873084183980038E-4,{"$f":"TRIM(D3)","v":"ΧΡΙΣΤΑΝΑΣ ΔΗΜΗΤΡΗΣ"}]
[2,null,31791,"ΚΑΡΑΜΑΝΗΣ ΟΡΕΣΤΗΣ","Α.Ο ΧΑΙΔΑΡΙΟΥ",42,null,null,42.000152532928368,1.525329283705051E-4,"ΚΑΡΑΜΑΝΗΣ ΟΡΕΣΤΗΣ"]
[3,null,32623,"ΖΑΧΙΩΤΗΣ ΦΙΛΛΙΠΟΣ","ΓΟ ΠΑΛΑΣΚΑΣ",40.5,null,null,40.503243138050529,3.2431380505318773E-3,"ΖΑΧΙΩΤΗΣ ΦΙΛΛΙΠΟΣ"]
[4,null,31088,"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ ΚΩΝΣΤΑΝΤΙΝΟΣ","Ο.Α.ΠΕΤΡΟΥΠΟΛΗΣ",39,null," ",39.002532049593057,2.5320495930536754E-3,"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ ΚΩΝΣΤΑΝΤΙΝΟΣ"]
[5,null,32524,"ΧΑΡΑΛΑΜΠΙΔΗΣ ΚΩΝΣΤΑΝΤΙΝΟΣ","Α.Ο.Α ΑΙΓΑΛΕΩ 92",36.5,null,null,36.504207952335108,4.2079523351073837E-3,"ΧΑΡΑΛΑΜΠΙΔΗΣ ΚΩΝΣΤΑΝΤΙΝΟΣ"]
[6,null,33565,"ΖΑΧΑΡΟΓΙΩΡΓΑΣ ΓΙΑΝΝΗΣ","ΓΟ ΠΑΛΑΣΚΑΣ",8.5,null,null,8.5000025592361297,2.5592361293273783E-6,"ΖΑΧΑΡΟΓΙΩΡΓΑΣ ΓΙΑΝΝΗΣ"]
[7,null,33660,"ΚΟΥΡΣΑΡΗΣ ΓΙΩΡΓΟΣ","ΑΑ ΑΙΓΑΛΕΩ",6,null,null,6.0037809060870799,3.7809060870799241E-3,"ΚΟΥΡΣΑΡΗΣ ΓΙΩΡΓΟΣ"]
[8,null,31792,"ΣΑΚΟΓΙΑΝΝΗΣ ΒΑΠΤΙΣΤΗΣ","Α.Ο ΧΑΙΔΑΡΙΟΥ",6,null,null,6.0008946078542955,8.9460785429595056E-4,"ΣΑΚΟΓΙΑΝΝΗΣ ΒΑΠΤΙΣΤΗΣ"]
[9,null,33606,"ΓΙΩΤΗΣ ΧΑΡΑΛΑΜΠΟΣ","ΓΟ ΠΑΛΑΣΚΑΣ",5,null,null,5.0038567279834485,3.8567279834484654E-3,"ΓΙΩΤΗΣ ΧΑΡΑΛΑΜΠΟΣ"]
[10,null,33659,"ΚΟΥΡΣΑΡΗΣ ΝΙΚΗΤΑΣ","ΑΑ ΑΙΓΑΛΕΩ",2.5,null,null,2.5038746538063688,3.8746538063688697E-3,"ΚΟΥΡΣΑΡΗΣ ΝΙΚΗΤΑΣ"]
[11,null,28665,"ΜΑΜΑΗΣ ΙΩΑΝΝΗΣ","Σ.Α. ΓΑΛΑΤΣΙΟΥ",1.5,null,null,1.5028350394379562,2.8350394379561736E-3,"ΜΑΜΑΗΣ ΙΩΑΝΝΗΣ"]
[12,null,32826,"ΑΡΑΜΠΑΤΖΗΣ ΓΙΩΡΓΟΣ","Ο.Α.ΣΑΛΑΜΙΝΑΣ",null,null,null,4.0278506564581365E-3,4.0278506564581365E-3,"ΑΡΑΜΠΑΤΖΗΣ ΓΙΩΡΓΟΣ"]
[13,null,34969,"ΚΑΤΣΟΥΛΗΣ ΝΙΚΟΛΑΟΣ","ΑΙΟΛΟΣ ΙΛΙΟΥ",null,null,null,3.835128641581597E-3,3.835128641581597E-3,"ΚΑΤΣΟΥΛΗΣ ΝΙΚΟΛΑΟΣ"]
[14,null,32766,"ΚΑΣΣΗΣ ΙΩΑΝΝΗΣ","Α.Ο.ΧΑΙΔΑΡΙΟΥ",null,null,null,4.2667291484443676E-4,4.2667291484443676E-4,"ΚΑΣΣΗΣ ΙΩΑΝΝΗΣ"]
[15,null,null,"",null,null,null,null,0,1.0611514500062913E-3,""]
[16,null,null,"",null,null,null,null,0,3.5877227514723073E-3,""]
[]
[null,"Walk-over",null,null,"med"]
[null,"α/α","Α.Μ.","Ονοματεπώνυμο","Ν ή Ο",null,null,{"$f":"Setup!$B$10","v":"ΤΣΑΔΑΡΗΣ ΣΑΚΗΣ"}]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]

{"sheet":"Draw","index":3,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[26,17,26,18],[2,9,2,11],[0,0,0,15]]}
[{"$f":"Setup!B3 & \", \" & Setup!B4 & \", \" & Setup!B6 & \", \" & Setup!B8 & \"-\" & Setup!B9","v":"Θ ΕΝΩΣΗ, 1ο Ε3, ΟΑ ΧΑΛΚΙΔΑΣ, 15-16 ΜΑΡΤΙΟΥ"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Setup!B7","v":"Α12"}]
[null,{"$f":"Setup!$B$18","v":2},null,null,null,null,null,null,"p1",null,null,null,null,"p2",null,"p3",null,"p4-5"]
[null,null,null,null,null,null,null,null,null,16,null,null,null,8,null,4,null,2]
["α/α",null,"ByeOrder","ByeSum","ByeCnt","από","seed","Pts","Α.Μ.","Ονοματεπώνυμο","επώνυμο","Σύλλογος"]
[1,1,null,null,0,{"$f":"IF(NOT($G5=\"-\"),VLOOKUP($G5,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B5,Setup!$G$12:$H$27,2,FALSE)","v":1},{"$f":"IF($G5>0,VLOOKUP($G5,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":55.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G5>0,VLOOKUP($G5,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":27444},{"$f":"IF($I5>0,VLOOKUP($I5,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΧΡΙΣΤΑΝΑΣ ΔΗΜΗΤΡΗΣ"},{"$f":"IF(NOT(I5>0),\"\", IF(ISERROR(FIND(\"-\",J5)), LEFT(J5,FIND(\" \",J5)-1), IF(FIND(\"-\",J5)>FIND(\" \",J5),LEFT(J5,FIND(\" \",J5)-1), LEFT(J5,FIND(\"-\",J5)-1) )))","v":"ΧΡΙΣΤΑΝΑΣ"},{"$f":"IF($I5>0,VLOOKUP($I5,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Α.Ο.Α ΑΙΓΑΛΕΩ 92"},1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M5=1,M5=\"a\"),I5,IF(OR(M5=2,M5=\"b\"),I6,\"\")),IF(OR(M5=1,M5=\"1\"),K5,IF(OR(M5=2,M5=\"b\"),K6,\"\"))))","v":"ΧΡΙΣΤΑΝΑΣ"}]
[2,{"$f":"1-D6+4","v":4},1,{"$f":"E6","v":1},{"$f":"IF($B$2>=C6,1,0)","v":1},{"$f":"IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":""},{"$f":"IF($B$2>=C6,\"-\",VLOOKUP($B6,Setup!$G$12:$H$27,2,FALSE))","v":"-"},{"$f":"IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":0},{"$f":"IF($I6>0,VLOOKUP($I6,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"bye"},{"$f":"IF(NOT(I6>0),\"\", IF(ISERROR(FIND(\"-\",J6)), LEFT(J6,FIND(\" \",J6)-1), IF(FIND(\"-\",J6)>FIND(\" \",J6),LEFT(J6,FIND(\" \",J6)-1), LEFT(J6,FIND(\"-\",J6)-1) )))","v":""},{"$f":"IF($I6>0,VLOOKUP($I6,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":""},null,null,1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(O6=1,O6=\"a\"),N5,IF(OR(O6=2,O6=\"b\"),N7,\"\")),IF(OR(O6=1,O6=\"a\"),N5,IF(OR(O6=2,O6=\"b\"),N7,\"\"))))","v":"ΧΡΙΣΤΑΝΑΣ"}]
[3,{"$f":"2-D7+4","v":5},null,{"$f":"D6+E7","v":1},0,{"$f":"IF(NOT($G7=\"-\"),VLOOKUP($G7,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B7,Setup!$G$12:$H$27,2,FALSE)","v":9},{"$f":"IF($G7>0,VLOOKUP($G7,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":5},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G7>0,VLOOKUP($G7,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":33606},{"$f":"IF($I7>0,VLOOKUP($I7,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΓΙΩΤΗΣ ΧΑΡΑΛΑΜΠΟΣ"},"ΓΙΩΤΗΣ",{"$f":"IF($I7>0,VLOOKUP($I7,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΓΟ ΠΑΛΑΣΚΑΣ"},1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M7=1,M7=\"a\"),I7,IF(OR(M7=2,M7=\"b\"),I8,\"\")),IF(OR(M7=1,M7=\"a\"),K7,IF(OR(M7=2,M7=\"b\"),K8,\"\"))))","v":"ΓΙΩΤΗΣ"},null,"62 60"]
[4,{"$f":"3-D8+4","v":6},7,1,{"$f":"IF($B$2>=C8,1,0)","v":0},{"$f":"IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C8,\"-\",VLOOKUP($B8,Setup!$G$12:$H$27,2,FALSE))","v":6},{"$f":"IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":8.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":33565},{"$f":"IF($I8>0,VLOOKUP($I8,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΖΑΧΑΡΟΓΙΩΡΓΑΣ ΓΙΑΝΝΗΣ"},"ΖΑΧΑΡΟΓΙΩΡΓΑΣ",{"$f":"IF($I8>0,VLOOKUP($I8,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΓΟ ΠΑΛΑΣΚΑΣ"},null,"62 61",null,null,1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(Q8=1,Q8=\"a\"),P6,IF(OR(Q8=2,Q8=\"b\"),P10,\"\")),IF(OR(Q8=1,Q8=\"a\"),P6,IF(OR(Q8=2,Q8=\"b\"),P10,\"\"))))","v":"ΧΡΙΣΤΑΝΑΣ"}]
[5,{"$f":"VALUE(Setup!E2)","v":4},null,1,0,{"$f":"IF(NOT($G9=\"-\"),VLOOKUP($G9,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B9,Setup!$G$12:$H$27,2,FALSE)","v":4},{"$f":"IF($G9>0,VLOOKUP($G9,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":39},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G9>0,VLOOKUP($G9,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":31088},{"$f":"IF($I9>0,VLOOKUP($I9,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ ΚΩΝΣΤΑΝΤΙΝΟΣ"},"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ",{"$f":"IF($I9>0,VLOOKUP($I9,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Ο.Α.ΠΕΤΡΟΥΠΟΛΗΣ"},1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M9=1,M9=\"a\"),I9,IF(OR(M9=2,M9=\"b\"),I10,\"\")),IF(OR(M9=1,M9=\"a\"),K9,IF(OR(M9=2,M9=\"b\"),K10,\"\"))))","v":"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ"},null,null,null,"62 62"]
[6,{"$f":"4-D10+4","v":7},{"$f":"IF(Setup!E2=3,3,4)","v":4},1,{"$f":"IF($B$2>=C10,1,0)","v":0},{"$f":"IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C10,\"-\",VLOOKUP($B10,Setup!$G$12:$H$27,2,FALSE))","v":11},{"$f":"IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":1.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":28665},{"$f":"IF($I10>0,VLOOKUP($I10,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΜΑΜΑΗΣ ΙΩΑΝΝΗΣ"},"ΜΑΜΑΗΣ",{"$f":"IF($I10>0,VLOOKUP($I10,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Σ.Α. ΓΑΛΑΤΣΙΟΥ"},null,"60 60",1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(O10=1,O10=\"a\"),N9,IF(OR(O10=2,O10=\"b\"),N11,\"\")),IF(OR(O10=1,O10=\"a\"),N9,IF(OR(O10=2,O10=\"b\"),N11,\"\"))))","v":"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ"}]
[7,{"$f":"5-D11+4","v":8},5,1,{"$f":"IF($B$2>=C11,1,0)","v":0},{"$f":"IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C11,\"-\",VLOOKUP($B11,Setup!$G$12:$H$27,2,FALSE))","v":10},{"$f":"IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":2.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":33659},{"$f":"IF($I11>0,VLOOKUP($I11,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΚΟΥΡΣΑΡΗΣ ΝΙΚΗΤΑΣ"},"ΚΟΥΡΣΑΡΗΣ",{"$f":"IF($I11>0,VLOOKUP($I11,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΑΑ ΑΙΓΑΛΕΩ"},2,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M11=1,M11=\"a\"),I11,IF(OR(M11=2,M11=\"b\"),I12,\"\")),IF(OR(M11=1,M11=\"a\"),K11,IF(OR(M11=2,M11=\"b\"),K12,\"\"))))","v":"ΧΑΡΑΛΑΜΠΙΔΗΣ"},null,"64 61"]
[8,{"$f":"6-D12+4","v":9},null,1,0,{"$f":"IF(NOT($G12=\"-\"),VLOOKUP($G12,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B12,Setup!$G$12:$H$27,2,FALSE)","v":5},{"$f":"IF($G12>0,VLOOKUP($G12,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":36.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G12>0,VLOOKUP($G12,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32524},{"$f":"IF($I12>0,VLOOKUP($I12,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΧΑΡΑΛΑΜΠΙΔΗΣ ΚΩΝΣΤΑΝΤΙΝΟΣ"},"ΧΑΡΑΛΑΜΠΙΔΗΣ",{"$f":"IF($I12>0,VLOOKUP($I12,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Α.Ο.Α ΑΙΓΑΛΕΩ 92"},null,"60 60",null,null,1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(Q12=1,Q12=\"a\"),R8,IF(OR(Q12=2,Q12=\"b\"),R16,\"\")),IF(OR(Q12=1,Q12=\"a\"),R8,IF(OR(Q12=2,Q12=\"b\"),R16,\"\"))))","v":"ΧΡΙΣΤΑΝΑΣ"}]
[9,{"$f":"VALUE(Setup!E3)","v":3},null,1,0,{"$f":"IF(NOT($G13=\"-\"),VLOOKUP($G13,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B13,Setup!$G$12:$H$27,2,FALSE)","v":3},{"$f":"IF($G13>0,VLOOKUP($G13,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":40.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G13>0,VLOOKUP($G13,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32623},{"$f":"IF($I13>0,VLOOKUP($I13,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΖΑΧΙΩΤΗΣ ΦΙΛΛΙΠΟΣ"},"ΖΑΧΙΩΤΗΣ",{"$f":"IF($I13>0,VLOOKUP($I13,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΓΟ ΠΑΛΑΣΚΑΣ"},1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M13=1,M13=\"a\"),I13,IF(OR(M13=2,M13=\"b\"),I14,\"\")),IF(OR(M13=1,M13=\"a\"),K13,IF(OR(M13=2,M13=\"b\"),K14,\"\"))))","v":"ΖΑΧΙΩΤΗΣ"},null,null,null,"76 57 63"]
[10,{"$f":"7-D14+4","v":10},{"$f":"IF(Setup!E2=3,4,3)","v":3},1,{"$f":"IF($B$2>=C14,1,0)","v":0},{"$f":"IF(NOT($G14=\"-\"),VLOOKUP($G14,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C14,\"-\",VLOOKUP($B14,Setup!$G$12:$H$27,2,FALSE))","v":7},{"$f":"IF(NOT($G14=\"-\"),VLOOKUP($G14,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":6},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G14=\"-\"),VLOOKUP($G14,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":33660},{"$f":"IF($I14>0,VLOOKUP($I14,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΚΟΥΡΣΑΡΗΣ ΓΙΩΡΓΟΣ"},"ΚΟΥΡΣΑΡΗΣ",{"$f":"IF($I14>0,VLOOKUP($I14,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΑΑ ΑΙΓΑΛΕΩ"},null,"60 60",1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(O14=1,O14=\"a\"),N13,IF(OR(O14=2,O14=\"b\"),N15,\"\")),IF(OR(O14=1,O14=\"a\"),N13,IF(OR(O14=2,O14=\"b\"),N15,\"\"))))","v":"ΖΑΧΙΩΤΗΣ"}]
[11,{"$f":"8-D15+4","v":11},null,1,0,{"$f":"IF(NOT($G15=\"-\"),VLOOKUP($G15,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B15,Setup!$G$12:$H$27,2,FALSE)","v":8},{"$f":"IF($G15>0,VLOOKUP($G15,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":6},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G15>0,VLOOKUP($G15,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":31792},{"$f":"IF($I15>0,VLOOKUP($I15,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΣΑΚΟΓΙΑΝΝΗΣ ΒΑΠΤΙΣΤΗΣ"},"ΣΑΚΟΓΙΑΝΝΗΣ",{"$f":"IF($I15>0,VLOOKUP($I15,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Α.Ο ΧΑΙΔΑΡΙΟΥ"},1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M15=1,M15=\"a\"),I15,IF(OR(M15=2,M15=\"b\"),I16,\"\")),IF(OR(M15=1,M15=\"a\"),K15,IF(OR(M15=2,M15=\"b\"),K16,\"\"))))","v":"ΣΑΚΟΓΙΑΝΝΗΣ"},null,"61 60"]
[12,{"$f":"9-D16+4","v":12},6,1,{"$f":"IF($B$2>=C16,1,0)","v":0},{"$f":"IF(NOT($G16=\"-\"),VLOOKUP($G16,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C16,\"-\",VLOOKUP($B16,Setup!$G$12:$H$27,2,FALSE))","v":13},{"$f":"IF(NOT($G16=\"-\"),VLOOKUP($G16,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G16=\"-\"),VLOOKUP($G16,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":34969},{"$f":"IF($I16>0,VLOOKUP($I16,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΚΑΤΣΟΥΛΗΣ ΝΙΚΟΛΑΟΣ"},"ΚΑΤΣΟΥΛΗΣ",{"$f":"IF($I16>0,VLOOKUP($I16,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΑΙΟΛΟΣ ΙΛΙΟΥ"},null,"62 61",null,null,1,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(Q16=1,Q16=\"a\"),P14,IF(OR(Q16=2,Q16=\"b\"),P18,\"\")),IF(OR(Q16=1,Q16=\"a\"),P14,IF(OR(Q16=2,Q16=\"b\"),P18,\"\"))))","v":"ΖΑΧΙΩΤΗΣ"}]
[13,{"$f":"10-D17+4","v":13},null,1,0,{"$f":"IF(NOT($G17=\"-\"),VLOOKUP($G17,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B17,Setup!$G$12:$H$27,2,FALSE)","v":12},{"$f":"IF($G17>0,VLOOKUP($G17,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G17>0,VLOOKUP($G17,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32826},{"$f":"IF($I17>0,VLOOKUP($I17,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΑΡΑΜΠΑΤΖΗΣ ΓΙΩΡΓΟΣ"},"ΑΡΑΜΠΑΤΖΗΣ",{"$f":"IF($I17>0,VLOOKUP($I17,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Ο.Α.ΣΑΛΑΜΙΝΑΣ"},2,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M17=1,M17=\"a\"),I17,IF(OR(M17=2,M17=\"b\"),I18,\"\")),IF(OR(M17=1,M17=\"a\"),K17,IF(OR(M17=2,M17=\"b\"),K18,\"\"))))","v":"ΚΑΣΣΗΣ"},null,null,null,"61 62"]
[14,{"$f":"11-D18+4","v":14},8,1,{"$f":"IF($B$2>=C18,1,0)","v":0},{"$f":"IF(NOT($G18=\"-\"),VLOOKUP($G18,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C18,\"-\",VLOOKUP($B18,Setup!$G$12:$H$27,2,FALSE))","v":14},{"$f":"IF(NOT($G18=\"-\"),VLOOKUP($G18,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G18=\"-\"),VLOOKUP($G18,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32766},{"$f":"IF($I18>0,VLOOKUP($I18,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΚΑΣΣΗΣ ΙΩΑΝΝΗΣ"},"ΚΑΣΣΗΣ",{"$f":"IF($I18>0,VLOOKUP($I18,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Α.Ο.ΧΑΙΔΑΡΙΟΥ"},null,"62 61",2,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(O18=1,O18=\"a\"),N17,IF(OR(O18=2,O18=\"b\"),N19,\"\")),IF(OR(O18=1,O18=\"a\"),N17,IF(OR(O18=2,O18=\"b\"),N19,\"\"))))","v":"ΚΑΡΑΜΑΝΗΣ"}]
[15,{"$f":"12-D19+4","v":14},2,2,{"$f":"IF($B$2>=C19,1,0)","v":1},{"$f":"IF(NOT($G19=\"-\"),VLOOKUP($G19,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":""},{"$f":"IF($B$2>=C19,\"-\",VLOOKUP($B19,Setup!$G$12:$H$27,2,FALSE))","v":"-"},{"$f":"IF(NOT($G19=\"-\"),VLOOKUP($G19,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G19=\"-\"),VLOOKUP($G19,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":0},{"$f":"IF($I19>0,VLOOKUP($I19,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"bye"},"",{"$f":"IF($I19>0,VLOOKUP($I19,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":""},2,{"$f":"UPPER(IF($A$2=\"R\",IF(OR(M19=1,M19=\"a\"),I19,IF(OR(M19=2,M19=\"b\"),I20,\"\")),IF(OR(M19=1,M19=\"a\"),K19,IF(OR(M19=2,M19=\"b\"),K20,\"\"))))","v":"ΚΑΡΑΜΑΝΗΣ"},null,"61 75"]
[16,2,null,2,0,{"$f":"IF(NOT($G20=\"-\"),VLOOKUP($G20,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B20,Setup!$G$12:$H$27,2,FALSE)","v":2},{"$f":"IF($G20>0,VLOOKUP($G20,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":42},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G20>0,VLOOKUP($G20,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":31791},{"$f":"IF($I20>0,VLOOKUP($I20,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΚΑΡΑΜΑΝΗΣ ΟΡΕΣΤΗΣ"},"ΚΑΡΑΜΑΝΗΣ",{"$f":"IF($I20>0,VLOOKUP($I20,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"Α.Ο ΧΑΙΔΑΡΙΟΥ"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,"seeded players"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"1. \" & IF(Setup!B19>0,LEFT(DrawPrep!D3,FIND(\" \",DrawPrep!D3)+1),\"\")","v":"1. ΧΡΙΣΤΑΝΑΣ Δ"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"2. \" & IF(Setup!B19>1,LEFT(DrawPrep!D4,FIND(\" \",DrawPrep!D4)+1),\"\")","v":"2. ΚΑΡΑΜΑΝΗΣ Ο"},null,null,null,null,null,null,null,"επιδιαιτητής"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"3. \" & IF(Setup!B19>2,LEFT(DrawPrep!D5,FIND(\" \",DrawPrep!D5)+1),\"\")","v":"3. ΖΑΧΙΩΤΗΣ Φ"},null,null,null,null,null,null,null,{"$f":"Setup!B10","v":"ΤΣΑΔΑΡΗΣ ΣΑΚΗΣ"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"4. \" & IF(Setup!B19>3,LEFT(DrawPrep!D6,FIND(\" \",DrawPrep!D6)+1),\"\")","v":"4. ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ Κ"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"BoldPlayers"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Setup!$B$19>0,LEFT(DrawPrep!D3,FIND(\" \",DrawPrep!D3)-1))","v":"ΧΡΙΣΤΑΝΑΣ"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Setup!$B$19>1,LEFT(DrawPrep!D4,FIND(\" \",DrawPrep!D4)-1))","v":"ΚΑΡΑΜΑΝΗΣ"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Setup!$B$19>2,LEFT(DrawPrep!D5,FIND(\" \",DrawPrep!D5)-1))","v":"ΖΑΧΙΩΤΗΣ"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Setup!$B$19>3,LEFT(DrawPrep!D6,FIND(\" \",DrawPrep!D6)-1))","v":"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ"}]

{"sheet":"PrgPrep","index":4,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,5,3,5],[17,5,18,5],[0,0,0,5],[1,0,1,5]]}
[{"$f":"Setup!B3 & \", \" & Setup!B4 & \", \" & Setup!B6  & \" (\" & Setup!B7 & \")\"","v":"Θ ΕΝΩΣΗ, 1ο Ε3, ΟΑ ΧΑΛΚΙΔΑΣ (Α12)"},null,null,null,null,null,"Don't Change this Worksheet !"]
[{"$f":"Setup!$B$10","v":"ΤΣΑΔΑΡΗΣ ΣΑΚΗΣ"}]
["Πρόγραμμα αγώνων",null,null,null,"Round 1","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["Έναρξη",{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(OR(Draw!J5=\"bye\",Draw!J5=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J5,FIND(\" \",Draw!J5)+1),\" (\",Draw!L5,\")\"))","v":"ΧΡΙΣΤΑΝΑΣ Δ (Α.Ο.Α ΑΙΓΑΛΕΩ 92)"},{"$f":"IF(OR(C5=\"\",E5=\"\"),\" \",\"-\")","v":" "},{"$f":"IF(OR(Draw!J6=\"bye\",Draw!J6=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J6,FIND(\" \",Draw!J6)+1),\" (\",Draw!L6,\")\"))","v":""}]
[null,{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(OR(Draw!J7=\"bye\",Draw!J7=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J7,FIND(\" \",Draw!J7)+1),\" (\",Draw!L7,\")\"))","v":"ΓΙΩΤΗΣ Χ (ΓΟ ΠΑΛΑΣΚΑΣ)"},{"$f":"IF(OR(C6=\"\",E6=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(OR(Draw!J8=\"bye\",Draw!J8=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J8,FIND(\" \",Draw!J8)+1),\" (\",Draw!L8,\")\"))","v":"ΖΑΧΑΡΟΓΙΩΡΓΑΣ Γ (ΓΟ ΠΑΛΑΣΚΑΣ)"}]
[null,{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(OR(Draw!J9=\"bye\",Draw!J9=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J9,FIND(\" \",Draw!J9)+1),\" (\",Draw!L9,\")\"))","v":"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ Κ (Ο.Α.ΠΕΤΡΟΥΠΟΛΗΣ)"},"-",{"$f":"IF(OR(Draw!J10=\"bye\",Draw!J10=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J10,FIND(\" \",Draw!J10)+1),\" (\",Draw!L10,\")\"))","v":"ΜΑΜΑΗΣ Ι (Σ.Α. ΓΑΛΑΤΣΙΟΥ)"}]
[null,{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(OR(Draw!J11=\"bye\",Draw!J11=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J11,FIND(\" \",Draw!J11)+1),\" (\",Draw!L11,\")\"))","v":"ΚΟΥΡΣΑΡΗΣ Ν (ΑΑ ΑΙΓΑΛΕΩ)"},"-",{"$f":"IF(OR(Draw!J12=\"bye\",Draw!J12=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J12,FIND(\" \",Draw!J12)+1),\" (\",Draw!L12,\")\"))","v":"ΧΑΡΑΛΑΜΠΙΔΗΣ Κ (Α.Ο.Α ΑΙΓΑΛΕΩ 92)"}]
["όχι πριν",{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(OR(Draw!J13=\"bye\",Draw!J13=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J13,FIND(\" \",Draw!J13)+1),\" (\",Draw!L13,\")\"))","v":"ΖΑΧΙΩΤΗΣ Φ (ΓΟ ΠΑΛΑΣΚΑΣ)"},"-",{"$f":"IF(OR(Draw!J14=\"bye\",Draw!J14=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J14,FIND(\" \",Draw!J14)+1),\" (\",Draw!L14,\")\"))","v":"ΚΟΥΡΣΑΡΗΣ Γ (ΑΑ ΑΙΓΑΛΕΩ)"}]
[null,{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(OR(Draw!J15=\"bye\",Draw!J15=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J15,FIND(\" \",Draw!J15)+1),\" (\",Draw!L15,\")\"))","v":"ΣΑΚΟΓΙΑΝΝΗΣ Β (Α.Ο ΧΑΙΔΑΡΙΟΥ)"},"-",{"$f":"IF(OR(Draw!J16=\"bye\",Draw!J16=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J16,FIND(\" \",Draw!J16)+1),\" (\",Draw!L16,\")\"))","v":"ΚΑΤΣΟΥΛΗΣ Ν (ΑΙΟΛΟΣ ΙΛΙΟΥ)"}]
[null,{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(OR(Draw!J17=\"bye\",Draw!J17=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J17,FIND(\" \",Draw!J17)+1),\" (\",Draw!L17,\")\"))","v":"ΑΡΑΜΠΑΤΖΗΣ Γ (Ο.Α.ΣΑΛΑΜΙΝΑΣ)"},"-",{"$f":"IF(OR(Draw!J18=\"bye\",Draw!J18=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J18,FIND(\" \",Draw!J18)+1),\" (\",Draw!L18,\")\"))","v":"ΚΑΣΣΗΣ Ι (Α.Ο.ΧΑΙΔΑΡΙΟΥ)"}]
[null,{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(OR(Draw!J19=\"bye\",Draw!J19=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J19,FIND(\" \",Draw!J19)+1),\" (\",Draw!L19,\")\"))","v":""}," ",{"$f":"IF(OR(Draw!J20=\"bye\",Draw!J20=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J20,FIND(\" \",Draw!J20)+1),\" (\",Draw!L20,\")\"))","v":"ΚΑΡΑΜΑΝΗΣ Ο (Α.Ο ΧΑΙΔΑΡΙΟΥ)"}]
[]
[]
[]
[]
[]
["Πρόγραμμα αγώνων",null,null,null,"Round 2","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["Έναρξη",{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(Draw!M5=\"\", \"\", IF(Draw!M5=1, CONCATENATE(LEFT(Draw!J5,FIND(\" \",Draw!J5)+1),\" (\",Draw!L5,\")\"),CONCATENATE(LEFT(Draw!J6,FIND(\" \",Draw!J6)+1),\" (\",Draw!L6,\")\")))","v":"ΧΡΙΣΤΑΝΑΣ Δ (Α.Ο.Α ΑΙΓΑΛΕΩ 92)"},{"$f":"IF(OR(C20=\"\",E20=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(Draw!M7=\"\", \"\", IF(Draw!M7=1, CONCATENATE(LEFT(Draw!J7,FIND(\" \",Draw!J7)+1),\" (\",Draw!L7,\")\"),CONCATENATE(LEFT(Draw!J8,FIND(\" \",Draw!J8)+1),\" (\",Draw!L8,\")\")))","v":"ΓΙΩΤΗΣ Χ (ΓΟ ΠΑΛΑΣΚΑΣ)"}]
[null,{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(Draw!M9=\"\", \"\", IF(Draw!M9=1, CONCATENATE(LEFT(Draw!J9,FIND(\" \",Draw!J9)+1),\" (\",Draw!L9,\")\"),CONCATENATE(LEFT(Draw!J10,FIND(\" \",Draw!J10)+1),\" (\",Draw!L10,\")\")))","v":"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ Κ (Ο.Α.ΠΕΤΡΟΥΠΟΛΗΣ)"},{"$f":"IF(OR(C21=\"\",E21=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(Draw!M11=\"\", \"\", IF(Draw!M11=1, CONCATENATE(LEFT(Draw!J11,FIND(\" \",Draw!J11)+1),\" (\",Draw!L11,\")\"),CONCATENATE(LEFT(Draw!J12,FIND(\" \",Draw!J12)+1),\" (\",Draw!L12,\")\")))","v":"ΧΑΡΑΛΑΜΠΙΔΗΣ Κ (Α.Ο.Α ΑΙΓΑΛΕΩ 92)"}]
[null,{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(Draw!M13=\"\", \"\", IF(Draw!M13=1, CONCATENATE(LEFT(Draw!J13,FIND(\" \",Draw!J13)+1),\" (\",Draw!L13,\")\"),CONCATENATE(LEFT(Draw!J14,FIND(\" \",Draw!J14)+1),\" (\",Draw!L14,\")\")))","v":"ΖΑΧΙΩΤΗΣ Φ (ΓΟ ΠΑΛΑΣΚΑΣ)"},{"$f":"IF(OR(C22=\"\",E22=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(Draw!M15=\"\", \"\", IF(Draw!M15=1, CONCATENATE(LEFT(Draw!J15,FIND(\" \",Draw!J15)+1),\" (\",Draw!L15,\")\"),CONCATENATE(LEFT(Draw!J16,FIND(\" \",Draw!J16)+1),\" (\",Draw!L16,\")\")))","v":"ΣΑΚΟΓΙΑΝΝΗΣ Β (Α.Ο ΧΑΙΔΑΡΙΟΥ)"}]
[null,{"$f":"Setup!$B$7","v":"Α12"},{"$f":"IF(Draw!M17=\"\", \"\", IF(Draw!M17=1, CONCATENATE(LEFT(Draw!J17,FIND(\" \",Draw!J17)+1),\" (\",Draw!L17,\")\"),CONCATENATE(LEFT(Draw!J18,FIND(\" \",Draw!J18)+1),\" (\",Draw!L18,\")\")))","v":"ΚΑΣΣΗΣ Ι (Α.Ο.ΧΑΙΔΑΡΙΟΥ)"},{"$f":"IF(OR(C23=\"\",E23=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(Draw!M19=\"\", \"\", IF(Draw!M19=1, CONCATENATE(LEFT(Draw!J19,FIND(\" \",Draw!J19)+1),\" (\",Draw!L19,\")\"),CONCATENATE(LEFT(Draw!J20,FIND(\" \",Draw!J20)+1),\" (\",Draw!L20,\")\")))","v":"ΚΑΡΑΜΑΝΗΣ Ο (Α.Ο ΧΑΙΔΑΡΙΟΥ)"}]
["όχι πριν"]
[]
[]
[]
[]
[]
["Don't Change this Worksheet !"]

{"sheet":"Day1","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,5,3,5],[0,0,0,5],[1,0,1,5]]}
[{"$f":"Setup!B3 & \", \" & Setup!B4 & \", \" & Setup!B6  & \" (\" & Setup!B7 & \")\"","v":"Θ ΕΝΩΣΗ, 1ο Ε3, ΟΑ ΧΑΛΚΙΔΑΣ (Α12)"}]
[{"$f":"Setup!$B$10","v":"ΤΣΑΔΑΡΗΣ ΣΑΚΗΣ"}]
["Πρόγραμμα αγώνων",null,null,null,"Round 1","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["Έναρξη"]
[]
[]
[]
["όχι πριν"]

{"sheet":"Day2","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,5,3,5]]}
[{"$f":"Setup!B3 & \", \" & Setup!B4 & \", \" & Setup!B6  & \" (\" & Setup!B7 & \")\"","v":"Θ ΕΝΩΣΗ, 1ο Ε3, ΟΑ ΧΑΛΚΙΔΑΣ (Α12)"}]
[{"$f":"Setup!$B$10","v":"ΤΣΑΔΑΡΗΣ ΣΑΚΗΣ"}]
["Πρόγραμμα αγώνων",null,null,null,"Round 2","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["Έναρξη","Α12",""," ",""]
[null,"Α12",""," ",""]
[null,"Α12",""," ",""]
[null,"Α12",""," ",""]
["όχι πριν"]
[]
[]
[]
[]
[" "]

{"sheet":"notes","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"tmp","index":8,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,9,33,9],[31,16,33,16],[20,8,22,8],[20,16,22,16],[25,9,25,22],[26,9,26,10],[26,16,26,17],[27,9,30,9],[27,16,30,16],[11,8,11,23],[12,16,12,17],[13,8,16,8],[13,16,16,16],[17,8,19,8],[17,16,19,16],[0,8,0,23],[1,16,1,17],[2,8,5,8],[2,16,5,16],[6,8,8,8],[6,16,8,16]]}
["RndIndx","random","FixRandom",null,"α/α","seed","ByeOrder",null,"ΠΡΟΚΡΙΜΑΤΙΚΑ E1, E2 (32 για 8)"]
[1,{"$f":"RAND()/222","v":1.6430602168175544E-3},3.3873084183980038E-4,null,1,1,null,null,null,null,"17-32","9-16","5-8","3-4","2ος","1ος",null,null,"17-32","9-16","5-8","3-4","2ος","1ος"]
[2,{"$f":"RAND()/222","v":7.6491240015981162E-4},1.525329283705051E-4,null,2,null,1,null,"E1","E1-12",1,2,2,0,0,0,"E1","E1-12",1,1,0,0,0,0]
[3,{"$f":"RAND()/222","v":1.9718178287465372E-4},3.2431380505318773E-3,null,3,null,null,null,null,"E1-14",3,4,4,0,0,0,null,"E1-14",3,1,0,0,0,0]
[4,{"$f":"RAND()/222","v":4.1471920402376874E-3},2.5320495930536754E-3,null,4,null,7,null,null,"E1-16",6,8,8,0,0,0,null,"E1-16",6,2,0,0,0,0]
[5,{"$f":"RAND()/222","v":1.5847780495381143E-3},4.2079523351073837E-3,null,5,3,null,null,null,"E1-18",7.5,10,10,null,null,null,null,"E1-18",7.5,2.5,0,0,0,0]
[6,{"$f":"RAND()/222","v":3.4860647033134354E-3},2.5592361293273783E-6,null,6,null,3,null,"E2","E2-12",0.3,0.5,0.5,0,0,0,"E2","E2-12",0.3,0.2,0,0,0,0]
[7,2.4117581123083722E-3,8.9460785429595056E-4,null,7,null,5,null,null,"E2-14",1,2,2,0,0,0,null,"E2-14",1,1,0,0,0,0]
[8,4.0142013430791634E-3,3.7809060870799241E-3,null,8,null,null,null,null,"E2-16",2,4,4,0,0,0,null,"E2-16",2,2,0,0,0,0]
[9,1.1149546805401481E-3,3.8567279834484654E-3,null,9,4]
[10,2.5420993685936668E-3,3.8746538063688697E-3,null,10,null,4]
[11,1.5663182070646197E-3,2.8350394379561736E-3,null,11,null,null,null,"ΚΥΡΙΩΣ ΤΑΜΠΛΟ E1, E2 & E3"]
[12,1.1472568075653754E-3,4.0278506564581365E-3,null,12,null,6,null,null,null,"17-32","9-16","5-8","3-4","2ος","1ος",null,null,"17-32","9-16","5-8","3-4","2ος","1ος"]
[13,2.4659470600985165E-3,4.2667291484443676E-4,null,13,null,null,null,"E1","E1-12",7,10,14,21,35,42,"E1","E1-12",7,3,4,7,14,7]
[14,4.0449611888902877E-3,3.835128641581597E-3,null,14,null,8,null,null,"E1-14",10,15,20,30,50,60,null,"E1-14",10,5,5,10,20,10]
[15,1.6421743100029874E-3,1.0611514500062913E-3,null,15,null,2,null,null,"E1-16",20,30,40,60,100,120,null,"E1-16",20,10,10,20,40,20]
[16,3.1034254203657899E-3,3.5877227514723073E-3,null,16,2,null,null,null,"E1-18",25,37,50,75,125,150,null,"E1-18",25,12,13,25,50,25]
[null,null,null,null,null,null,null,null,"E2","E2-12",4,5,7,10,15,18,"E2","E2-12",4,1,2,3,5,3]
[null,null,null,null,null,null,null,null,null,"E2-14",5,8,10,15,25,30,null,"E2-14",5,3,2,5,10,5]
[null,null,null,null,null,null,null,null,null,"E2-16",10,15,20,30,50,60,null,"E2-16",10,5,5,10,20,10]
[null,null,null,null,null,null,null,null,"E3","E3-12",0.5,2,3,4,7,8,"E3","E3-12",0.5,1.5,1,1,3,1]
[null,null,null,null,null,null,null,null,null,"E3-14",2,3,4,6,10,12,null,"E3-14",2,1,1,2,4,2]
[null,null,null,null,null,null,null,null,null,"E3-16",4,6,8,12,20,24,null,"E3-16",4,2,2,4,8,4]
[]
[]
[null,null,null,null,null,null,null,null,null,"ΔΙΠΛΑ E1, E2"]
[null,null,null,null,null,null,null,null,null,null,null,"9-16","5-8","3-4","2ος","1ος",null,null,"9-16","5-8","3-4","2ος","1ος"]
[null,null,null,null,null,null,null,null,null,"E1","E1-12",3,4,5,9,11,"E1","E1-12",3,1,1,4,2]
[null,null,null,null,null,null,null,null,null,null,"E1-14",4,5,8,13,15,null,"E1-14",4,1,3,5,2]
[null,null,null,null,null,null,null,null,null,null,"E1-16",8,10,15,25,30,null,"E1-16",8,2,5,10,5]
[null,null,null,null,null,null,null,null,null,null,"E1-18",9,12,19,31,37,null,"E1-18",9,3,7,12,6]
[null,null,null,null,null,null,null,null,null,"E2","E2-12",1,2,3,4,8,"E2","E2-12",1,1,1,1,4]
[null,null,null,null,null,null,null,null,null,null,"E2-14",2,3,4,6,8,null,"E2-14",2,1,1,2,2]
[null,null,null,null,null,null,null,null,null,null,"E2-16",4,6,8,12,16,null,"E2-16",4,2,2,4,4]

{"sheet":"tmpRankings","index":9,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["ΑΜ","Ονοματεπώνυμο","Γεν.","Σύλλογος","Βαθμ"]
[null,null,null,null,null,null,"=VLOOKUP(c3;tmpRankings!$A$2:$E$251;5;FALSE)"]