{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Setup","DrawPrep","Draw"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Setup","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["ΤΟΥΡΝΟΥΑ 8άρι ταμπλό"]
[]
["Διοργανωτής: ","Α΄ ΕΝΩΣΗ"]
["Τίτλος Τουρνουά: ","1ο Ε3"]
[]
["Έδρα αγώνων: "]
["Κατηγορίες: ","Α 16",null,"1 2 4 6 8 5 7 3 "]
["Έναρξη: ","15",null,"1 2 3 4 "]
["Λήξη: ","16 ΜΑΡ 2014",null,"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":1},{"$f":"IF(F12>0,VALUE(MID($D$7,1,F12-1)),\"-\")","v":1},{"$f":"IF(LEN($D$7)>1,FIND(\" \",$D$7,1),0)","v":2},1,1]
[null,null,null,{"$f":"IF(E13=\"-\",\"-\",IF(E13>0,D12+1,0))","v":2},{"$f":"IF(F13>0,VALUE(MID($D$7,F12+1,F13-F12-1)),\"-\")","v":2},{"$f":"IF(AND(F12>0,LEN($D$7)>F12+1),FIND(\" \",$D$7,F12+1),0)","v":4},2,2]
[null,null,null,3,4,6,3,4]
[null,null,null,4,6,8,4,6]
[null,null,null,5,8,10,5,8]
[null,{"$f":"\"(\"&COUNTBLANK(DrawPrep!D3:D10)&\")\"","v":"(0)"},null,6,5,12,6,5]
["Πλήθος bye (0-4): ",{"$f":"COUNTBLANK(DrawPrep!D3:D10)","v":0},null,7,7,14,7,7]
["Αριθμός θέσεων seeded: ",2,null,8,3,16,8,3]
[]
["All - Seeded - NoSeeded: ",{"$f":"CONCATENATE(8-$B$18,\" - \",$B$19,\" - \",8-$B$19-$B$18)","v":"8 - 2 - 6"}]
[]
[]
["md  (# για off) ","ok"]
[]
[]
[]
[]
["=CONCATENATE(LEFT(D9;$B$18*2);LEFT(D8;$B$19*2);RandUniq($B$19+1;8-$B$18;8-$B$19-$B$18);\" \")"]
[]
[null,null," "]

{"sheet":"DrawPrep","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[12,1,12,3]]}
[{"$f":"Setup!$B$3 & \", \" & Setup!$B$4 & \", \" & Setup!$B$6 & \", \" & Setup!$B$8 & \"-\" & Setup!$B$9","v":"Α΄ ΕΝΩΣΗ, 1ο Ε3, , 15-16 ΜΑΡ 2014"},null,null,null,null,null,null,{"$f":"Setup!$B$7","v":"Α 16"}]
["α/α","από","Α.Μ.","Ονοματεπώνυμο","Σύλλογος","βαθμ.","Τηλέφωνο","Υπογραφή","SortPts","Rnd"]
[1,null,28259,"ΝΙΚΟΛΑΚΟΠΟΥΛΟΣ  ΒΑΣΙΛΕΙΟΣ","Σ.Α.ΣΕΡΡΩΝ",92,null,null,{"$f":"IF(D3>\" \",F3+J3,0)","v":92.004363547901846},4.3635479018406748E-3]
[2,null,30492,"ΚΑΤΣΑΛΟΒ  ΓΙΑΝΝΗΣ","Σ.Α.ΔΡΑΜΑΣ",40,null,null,40.043387504616781,4.3387504616784749E-2]
[3,null,28757,"ΠΑΠΟΥΔΑΣ-ΤΣΑΚΙΡΙΔΗΣ ΑΝΑΣΤΑΣΙΟΣ","Σ.Α.ΔΡΑΜΑΣ",11,null,null,11.021371605784307,2.1371605784307249E-2]
[4,null,33357,"ΚΑΚΟΥΛΙΑΔΗΣ  ΓΕΩΡΓΙΟΣ","Ο.Α.ΞΑΝΘΗΣ",10,null,null,10.036173977272217,3.6173977272217203E-2]
[5,null,35494,"ΤΣΑΟΥΣΙΔΗΣ  ΑΝΔΡΕΑΣ","Σ.Α.ΣΕΡΡΩΝ",0,null,null,3.3935117354654626E-2,3.3935117354654626E-2]
[6,null,32896,"ΣΕΡΤΗΣ ΕΥΑΓΓΕΛΟΣ","Σ.Α.ΔΡΑΜΑΣ",0,null,null,2.4204251512548316E-2,2.4204251512548316E-2]
[7,null,34984,"ΚΩΝΣΤΑΝΤΙΝΙΔΗΣ  ΔΗΜΗΤΡΙΟΣ","Ο.Α.ΞΑΝΘΗΣ",0,null,null,8.3605845735132758E-3,8.3605845735132758E-3]
[8,null,32448,"ΤΣΙΜΑΡΗΣ  ΔΗΜΗΤΡΙΟΣ","Ο.Α.ΞΑΝΘΗΣ",0,null,null,5.0874195849533507E-3,5.0874195849533507E-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":2,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[16,15,16,17],[0,0,0,15],[2,9,2,11]]}
[{"$f":"Setup!B3 & \", \" & Setup!B4 & \", \" & Setup!B6 & \", \" & Setup!B8 & \"-\" & Setup!B9","v":"Α΄ ΕΝΩΣΗ, 1ο Ε3, , 15-16 ΜΑΡ 2014"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Setup!B7","v":"Α 16"}]
[null,{"$f":"Setup!$B$18","v":0}]
[null,null,null,null,null,null,null,null,null,8,null,null,null,4,null,2,null,"w"]
["α/α",null,"ByeOrder","ByeSum","ByeCnt","από","seed","pts","Α.Μ.","Ονοματεπώνυμο","επώνυμο","Σύλλογος"]
[1,1,null,null,0,{"$f":"IF(NOT($G5=\"-\"),VLOOKUP($G5,DrawPrep!$A$3:$G$10,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$10,6,FALSE),0)","v":92},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G5>0,VLOOKUP($G5,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":28259},{"$f":"IF($I5>0,VLOOKUP($I5,DrawPrep!$C$3:$G$10,2,FALSE),\"bye\")","v":"ΝΙΚΟΛΑΚΟΠΟΥΛΟΣ  ΒΑΣΙΛΕΙΟΣ"},{"$f":"IF($I5>0,LEFT(J5,FIND(\" \",J5)-1),\"\")","v":"ΝΙΚΟΛΑΚΟΠΟΥΛΟΣ"},{"$f":"IF($I5>0,VLOOKUP($I5,DrawPrep!$C$3:$G$10,3,FALSE),\"\")","v":"Σ.Α.ΣΕΡΡΩΝ"},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+2","v":3},1,{"$f":"E6","v":0},{"$f":"IF($B$2>=1,1,0)","v":0},{"$f":"IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$10,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=1,\"-\",VLOOKUP($B6,Setup!$G$12:$H$27,2,FALSE))","v":4},{"$f":"IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":10},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":33357},{"$f":"IF($I6>0,VLOOKUP($I6,DrawPrep!$C$3:$G$10,2,FALSE),\"bye\")","v":"ΚΑΚΟΥΛΙΑΔΗΣ  ΓΕΩΡΓΙΟΣ"},"ΚΑΚΟΥΛΙΑΔΗΣ",{"$f":"IF($I6>0,VLOOKUP($I6,DrawPrep!$C$3:$G$10,3,FALSE),\"\")","v":"Ο.Α.ΞΑΝΘΗΣ"},null,"40 40",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+2","v":4},null,{"$f":"D6+E7","v":0},0,{"$f":"IF(NOT($G7=\"-\"),VLOOKUP($G7,DrawPrep!$A$3:$G$10,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B7,Setup!$G$12:$H$27,2,FALSE)","v":6},{"$f":"IF($G7>0,VLOOKUP($G7,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G7>0,VLOOKUP($G7,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":32896},{"$f":"IF($I7>0,VLOOKUP($I7,DrawPrep!$C$3:$G$10,2,FALSE),\"bye\")","v":"ΣΕΡΤΗΣ ΕΥΑΓΓΕΛΟΣ"},"ΣΕΡΤΗΣ",{"$f":"IF($I7>0,VLOOKUP($I7,DrawPrep!$C$3:$G$10,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+2","v":5},3,0,{"$f":"IF($B$2>=3,1,0)","v":0},{"$f":"IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$10,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=3,\"-\",VLOOKUP($B8,Setup!$G$12:$H$27,2,FALSE))","v":8},{"$f":"IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":32448},{"$f":"IF($I8>0,VLOOKUP($I8,DrawPrep!$C$3:$G$10,2,FALSE),\"bye\")","v":"ΤΣΙΜΑΡΗΣ  ΔΗΜΗΤΡΙΟΣ"},"ΤΣΙΜΑΡΗΣ",{"$f":"IF($I8>0,VLOOKUP($I8,DrawPrep!$C$3:$G$10,3,FALSE),\"\")","v":"Ο.Α.ΞΑΝΘΗΣ"},null,"41 42",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":"4-D9+2","v":6},null,0,0,{"$f":"IF(NOT($G9=\"-\"),VLOOKUP($G9,DrawPrep!$A$3:$G$10,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B9,Setup!$G$12:$H$27,2,FALSE)","v":5},{"$f":"IF($G9>0,VLOOKUP($G9,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G9>0,VLOOKUP($G9,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":35494},{"$f":"IF($I9>0,VLOOKUP($I9,DrawPrep!$C$3:$G$10,2,FALSE),\"bye\")","v":"ΤΣΑΟΥΣΙΔΗΣ  ΑΝΔΡΕΑΣ"},"ΤΣΑΟΥΣΙΔΗΣ",{"$f":"IF($I9>0,VLOOKUP($I9,DrawPrep!$C$3:$G$10,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,"61 61"]
[6,{"$f":"5-D10+2","v":7},4,0,{"$f":"IF($B$2>=4,1,0)","v":0},{"$f":"IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$10,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=4,\"-\",VLOOKUP($B10,Setup!$G$12:$H$27,2,FALSE))","v":7},{"$f":"IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":34984},{"$f":"IF($I10>0,VLOOKUP($I10,DrawPrep!$C$3:$G$10,2,FALSE),\"bye\")","v":"ΚΩΝΣΤΑΝΤΙΝΙΔΗΣ  ΔΗΜΗΤΡΙΟΣ"},"ΚΩΝΣΤΑΝΤΙΝΙΔΗΣ",{"$f":"IF($I10>0,VLOOKUP($I10,DrawPrep!$C$3:$G$10,3,FALSE),\"\")","v":"Ο.Α.ΞΑΝΘΗΣ"},null,"40 41",2,{"$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":"6-D11+2","v":8},2,0,{"$f":"IF($B$2>=2,1,0)","v":0},{"$f":"IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$10,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=2,\"-\",VLOOKUP($B11,Setup!$G$12:$H$27,2,FALSE))","v":3},{"$f":"IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":11},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":28757},{"$f":"IF($I11>0,VLOOKUP($I11,DrawPrep!$C$3:$G$10,2,FALSE),\"bye\")","v":"ΠΑΠΟΥΔΑΣ-ΤΣΑΚΙΡΙΔΗΣ ΑΝΑΣΤΑΣΙΟΣ"},"ΠΑΠΟΥΔΑΣ-ΤΣΑΚΙΡΙΔΗΣ",{"$f":"IF($I11>0,VLOOKUP($I11,DrawPrep!$C$3:$G$10,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,"61 62"]
[8,2,null,0,0,{"$f":"IF(NOT($G12=\"-\"),VLOOKUP($G12,DrawPrep!$A$3:$G$10,2,FALSE),\"\")","v":0},{"$f":"VLOOKUP($B12,Setup!$G$12:$H$27,2,FALSE)","v":2},{"$f":"IF($G12>0,VLOOKUP($G12,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":40},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G12>0,VLOOKUP($G12,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":30492},{"$f":"IF($I12>0,VLOOKUP($I12,DrawPrep!$C$3:$G$10,2,FALSE),\"bye\")","v":"ΚΑΤΣΑΛΟΒ  ΓΙΑΝΝΗΣ"},"ΚΑΤΣΑΛΟΒ",{"$f":"IF($I12>0,VLOOKUP($I12,DrawPrep!$C$3:$G$10,3,FALSE),\"\")","v":"Σ.Α.ΔΡΑΜΑΣ"},null,"41 40"]
[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,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,{"$f":"Setup!B10","v":"ΠΕΤΡΙΔΗΣ  ΜΑΝΟΣ"}]
[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,"ok"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"BoldNames"]
[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":"ΚΑΤΣΑΛΟΒ"}]