{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Setup","DrawPrep","MD","Day1","Day2","notes","PrgPrep","tables","matches"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Setup","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Μέγεθος ταμπλό: ",8]
[]
["Διοργανωτής: ","Ζ΄ ΕΝΩΣΗ"]
["Τίτλος Τουρνουά: ","3ο Ε3 2016"]
["grade: ","e3"]
["age: ",16]
["Έδρα αγώνων: ","Γ.Σ. ΛΙΒΥΚΟΣ ΙΕΡΑΠ.",null,"1 2 7 4 6 3 5 8 "]
["Κατηγορία: ","Κ16",null,"1 2 3 4 "]
["Έναρξη: ","22",null,"0 0 0 0 0 0 0  "]
["Λήξη: ","23 Οκτωβρίου "]
["Επιδιατητής: ","Κ. Χατζηδάκης",null,0,"seed","space pos","Index","Value"]
["Τηλέφωνο επιδ: ",6948254785,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,7,6,3,7]
[null,null,null,4,4,8,4,4]
[null,null,null,5,6,10,5,6]
["Main Draw",{"$f":"\"(\"&COUNTBLANK(DrawPrep!D3:D10)&\")\"","v":"(0)"},null,6,3,12,6,3]
["Πλήθος bye (0-4): ",{"$f":"COUNTBLANK(DrawPrep!D3:D10)","v":0},null,7,5,14,7,5]
["Αριθμός θέσεων seeded: ",2,null,8,8,16,8,8]
[]
[]
[]
[]
["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);\" \")"]
["=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$7 & \", \" & Setup!$B$9 & \"-\" & Setup!$B$10","v":"Ζ΄ ΕΝΩΣΗ, 3ο Ε3 2016, Γ.Σ. ΛΙΒΥΚΟΣ ΙΕΡΑΠ., 22-23 Οκτωβρίου "},null,null,null,null,null,null,{"$f":"Setup!$B$8","v":"Κ16"}]
["α/α","από","Α.Μ.","Ονοματεπώνυμο","Σύλλογος","βαθμοί","Τηλέφωνο","Υπογραφή","SortPts","Rnd"]
[1,null,29655,"ΜΠΑΛΑΣΚΑ ΒΑΣΙΛΙΚΗ","Ο.Α.ΧΑΝΙΩΝ",168,null,null,{"$f":"IF(D3>\" \",F3+J3,0)","v":168.00309997974324},3.0999797432514995E-3]
[2,null,31852,"ΒΕΛΙΒΑΣΑΚΗ ΧΑΡΙΚΛΕΙΑ","ΗΡΑΚΛΕΙΟ Ο.Α.& Α.",85,null,null,85.043055314578822,4.3055314578819226E-2]
[3,null,30527,"ΒΑΡΒΕΡΑΚΗ ΜΑΡΙΑ","Ο.Α.ΧΑΝΙΩΝ",73,null,null,73.026132819198509,2.6132819198510283E-2]
[4,null,33088,"ΖΑΦΕΙΡΟΠΟΥΛΟΥ ΚΑΤΕΡΙΝΑ","ΗΡΑΚΛΕΙΟ Ο.Α.& Α.",61,null,null,61.006973613979341,6.9736139793432524E-3]
[5,null,30596,"ΚΡΟΝΤΗΡΑ ΕΛΕΝΗ","ΗΡΑΚΛΕΙΟ Ο.Α.& Α.",59,null,null,59.045418389240041,4.5418389240040588E-2]
[6,null,33092,"ΔΕΣΚΟΥΛΙΔΟΥ ΧΡΥΣΑΝΘΗ","Α.Π.Μ.Σ.ΑΣΚΗΣΗ ΗΡΑΚΛΕΙΟΥ",53,null,null,53.015410907851191,1.5410907851191046E-2]
[7,null,30544,"ΔΕΣΚΟΥΛΙΔΟΥ ΙΩΑΝΝΑ","Α.Π.Μ.Σ.ΑΣΚΗΣΗ ΗΡΑΚΛΕΙΟΥ",41,null,null,41.043757453689636,4.3757453689638584E-2]
[8,null,32222,"ΣΤΑΜΟΥΛΟΥ ΑΝΝΑ-ΜΑΡΙΑ","Ο.Α.ΧΑΝΙΩΝ",28,null,null,28.040902784767042,4.0902784767041386E-2]
[]
[]
[null,"Walk-over",null,null,"med"]
[null,"α/α","Α.Μ.","Ονοματεπώνυμο","Ν ή Ο",null,null,{"$f":"Setup!$B$11","v":"Κ. Χατζηδάκης"}]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]

{"sheet":"MD","index":2,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[16,17,16,20],[2,9,2,11]]}
[{"$f":"Setup!B3 & \", \" & Setup!B4 & \", \" & Setup!B7 & \", \" & Setup!B9 & \"-\" & Setup!B10","v":"Ζ΄ ΕΝΩΣΗ, 3ο Ε3 2016, Γ.Σ. ΛΙΒΥΚΟΣ ΙΕΡΑΠ., 22-23 Οκτωβρίου "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Setup!B8","v":"Κ16"}]
[null,{"$f":"Setup!$B$18","v":0}]
[null,null,null,null,null,null,null,null,null,8,null,null,null,null,4,null,null,2,null,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$28,2,FALSE)","v":1},{"$f":"IF($G5>0,VLOOKUP($G5,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":168},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G5>0,VLOOKUP($G5,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":29655},{"$f":"IF($I5>0,VLOOKUP($I5,DrawPrep!$C$3:$G$10,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$10,3,FALSE),\"\")","v":"Ο.Α.ΧΑΝΙΩΝ"},1,{"$f":"IF((OR(M5=1,M5=2)),IF(M5=1,I5,I6),\"\")","v":29655},{"$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$28,2,FALSE))","v":7},{"$f":"IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":41},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":30544},{"$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,null,"42 41",1,{"$f":"IF((OR(P6=1,P6=2)),IF(P6=1,N5,N7),\"\")","v":29655},{"$f":"UPPER(IF($A$2=\"R\",IF(OR(P6=1,P6=\"a\"),O5,IF(OR(P6=2,P6=\"b\"),O7,\"\")),IF(OR(P6=1,P6=\"a\"),O5,IF(OR(P6=2,P6=\"b\"),O7,\"\"))))","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$28,2,FALSE)","v":4},{"$f":"IF($G7>0,VLOOKUP($G7,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":61},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G7>0,VLOOKUP($G7,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":33088},{"$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":"IF((OR(M7=1,M7=2)),IF(M7=1,I7,I8),\"\")","v":33088},{"$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,null,"60 62"]
[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$28,2,FALSE))","v":6},{"$f":"IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":53},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":33092},{"$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,null,"40 42",null,null,null,1,{"$f":"IF((OR(S8=1,S8=2)),IF(S8=1,Q6,Q10),\"\")","v":29655},{"$f":"UPPER(IF($A$2=\"R\",IF(OR(S8=1,S8=\"a\"),R6,IF(OR(S8=2,S8=\"b\"),R10,\"\")),IF(OR(S8=1,S8=\"a\"),R6,IF(OR(S8=2,S8=\"b\"),R10,\"\"))))","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$28,2,FALSE)","v":3},{"$f":"IF($G9>0,VLOOKUP($G9,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":73},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G9>0,VLOOKUP($G9,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":30527},{"$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":"IF((OR(M9=1,M9=2)),IF(M9=1,I9,I10),\"\")","v":30527},{"$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,null,null,"62 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$28,2,FALSE))","v":5},{"$f":"IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":59},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":30596},{"$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,null,"40 40",2,{"$f":"IF((OR(P10=1,P10=2)),IF(P10=1,N9,N11),\"\")","v":31852},{"$f":"UPPER(IF($A$2=\"R\",IF(OR(P10=1,P10=\"a\"),O9,IF(OR(P10=2,P10=\"b\"),O11,\"\")),IF(OR(P10=1,P10=\"a\"),O9,IF(OR(P10=2,P10=\"b\"),O11,\"\"))))","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$28,2,FALSE))","v":8},{"$f":"IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":28},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":32222},{"$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":"IF((OR(M11=1,M11=2)),IF(M11=1,I11,I12),\"\")","v":31852},{"$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,null,"61 60"]
[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$28,2,FALSE)","v":2},{"$f":"IF($G12>0,VLOOKUP($G12,DrawPrep!$A$3:$G$10,6,FALSE),0)","v":85},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G12>0,VLOOKUP($G12,DrawPrep!$A$3:$G$10,3,FALSE),0))","v":31852},{"$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,null,"40 41"]
[null,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,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,{"$f":"Setup!B11","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":"ΒΕΛΙΒΑΣΑΚΗ"}]

{"sheet":"Day1","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,5,3,5],[2,0,2,2]]}
["Ζ΄ ΕΝΩΣΗ, 3ο Ε3 2016, Γ.Σ. ΛΙΒΥΚΟΣ ΙΕΡΑΠ. (Κ16)"]
["Κ. Χατζηδάκης"]
["Πρόγραμμα αγώνων",null,null,null,"Round 1","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["Έναρξη","Κ16","ΜΠΑΛΑΣΚΑ Β (Ο.Α.ΧΑΝΙΩΝ)","-","ΔΕΣΚΟΥΛΙΔΟΥ Ι (Α.Π.Μ.Σ.ΑΣΚΗΣΗ ΗΡΑΚΛΕΙΟΥ)"]
[null,"Κ16","ΖΑΦΕΙΡΟΠΟΥΛΟΥ Κ (ΗΡΑΚΛΕΙΟ Ο.Α.& Α.)","-","ΔΕΣΚΟΥΛΙΔΟΥ Χ (Α.Π.Μ.Σ.ΑΣΚΗΣΗ ΗΡΑΚΛΕΙΟΥ)"]
[null,"Κ16","ΒΑΡΒΕΡΑΚΗ Μ (Ο.Α.ΧΑΝΙΩΝ)","-","ΚΡΟΝΤΗΡΑ Ε (ΗΡΑΚΛΕΙΟ Ο.Α.& Α.)"]
[null,"Κ16","ΣΤΑΜΟΥΛΟΥ Α (Ο.Α.ΧΑΝΙΩΝ)","-","ΒΕΛΙΒΑΣΑΚΗ Χ (ΗΡΑΚΛΕΙΟ Ο.Α.& Α.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Day2","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,5,3,5],[2,0,2,2]]}
["Ζ΄ ΕΝΩΣΗ, 3ο Ε3 2016, Γ.Σ. ΛΙΒΥΚΟΣ ΙΕΡΑΠ. (Κ16)"]
["Κ. Χατζηδάκης"]
["Πρόγραμμα αγώνων",null,null,null,"Round 2","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["Έναρξη","Α12","ΟΡΦΑΝΙΔΗΣ Μ (0)","-","ΘΕΟΔΩΡΟΥ Κ (0)"]
[null,"Α12","ΜΑΜΑΣΗΣ Γ (0)","-","ΣΤΑΥΡΙΔΗΣ Π (0)"]
[]
[]
[]
[]
[]
[]
[]
[" "]

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

{"sheet":"PrgPrep","index":6,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,5,3,5],[17,5,18,5],[2,0,2,2],[17,0,17,2]]}
[{"$f":"Setup!B3 & \", \" & Setup!B4 & \", \" & Setup!B7  & \" (\" & Setup!B8 & \")\"","v":"Ζ΄ ΕΝΩΣΗ, 3ο Ε3 2016, Γ.Σ. ΛΙΒΥΚΟΣ ΙΕΡΑΠ. (Κ16)"},null,null,null,null,null,null,"Don't Change this Worksheet !"]
[{"$f":"Setup!$B$11","v":"Κ. Χατζηδάκης"}]
["Πρόγραμμα αγώνων",null,null,null,"Round 1","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["Έναρξη",{"$f":"Setup!$B$8","v":"Κ16"},{"$f":"IF(OR(MD!J5=\"bye\",MD!J5=\"LWD\"), \"\",CONCATENATE(LEFT(MD!J5,FIND(\" \",MD!J5)+1),\" (\",MD!L5,\")\"))","v":"ΜΠΑΛΑΣΚΑ Β (Ο.Α.ΧΑΝΙΩΝ)"},{"$f":"IF(OR(C5=\"\",E5=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(OR(MD!J6=\"bye\",MD!J6=\"LWD\"), \"\",CONCATENATE(LEFT(MD!J6,FIND(\" \",MD!J6)+1),\" (\",MD!L6,\")\"))","v":"ΔΕΣΚΟΥΛΙΔΟΥ Ι (Α.Π.Μ.Σ.ΑΣΚΗΣΗ ΗΡΑΚΛΕΙΟΥ)"}]
[null,{"$f":"Setup!$B$8","v":"Κ16"},{"$f":"IF(OR(MD!J7=\"bye\",MD!J7=\"LWD\"), \"\",CONCATENATE(LEFT(MD!J7,FIND(\" \",MD!J7)+1),\" (\",MD!L7,\")\"))","v":"ΖΑΦΕΙΡΟΠΟΥΛΟΥ Κ (ΗΡΑΚΛΕΙΟ Ο.Α.& Α.)"},{"$f":"IF(OR(C6=\"\",E6=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(OR(MD!J8=\"bye\",MD!J8=\"LWD\"), \"\",CONCATENATE(LEFT(MD!J8,FIND(\" \",MD!J8)+1),\" (\",MD!L8,\")\"))","v":"ΔΕΣΚΟΥΛΙΔΟΥ Χ (Α.Π.Μ.Σ.ΑΣΚΗΣΗ ΗΡΑΚΛΕΙΟΥ)"}]
[null,{"$f":"Setup!$B$8","v":"Κ16"},{"$f":"IF(OR(MD!J9=\"bye\",MD!J9=\"LWD\"), \"\",CONCATENATE(LEFT(MD!J9,FIND(\" \",MD!J9)+1),\" (\",MD!L9,\")\"))","v":"ΒΑΡΒΕΡΑΚΗ Μ (Ο.Α.ΧΑΝΙΩΝ)"},{"$f":"IF(OR(C7=\"\",E7=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(OR(MD!J10=\"bye\",MD!J10=\"LWD\"), \"\",CONCATENATE(LEFT(MD!J10,FIND(\" \",MD!J10)+1),\" (\",MD!L10,\")\"))","v":"ΚΡΟΝΤΗΡΑ Ε (ΗΡΑΚΛΕΙΟ Ο.Α.& Α.)"}]
[null,{"$f":"Setup!$B$8","v":"Κ16"},{"$f":"IF(OR(MD!J11=\"bye\",MD!J11=\"LWD\"), \"\",CONCATENATE(LEFT(MD!J11,FIND(\" \",MD!J11)+1),\" (\",MD!L11,\")\"))","v":"ΣΤΑΜΟΥΛΟΥ Α (Ο.Α.ΧΑΝΙΩΝ)"},{"$f":"IF(OR(C8=\"\",E8=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(OR(MD!J12=\"bye\",MD!J12=\"LWD\"), \"\",CONCATENATE(LEFT(MD!J12,FIND(\" \",MD!J12)+1),\" (\",MD!L12,\")\"))","v":"ΒΕΛΙΒΑΣΑΚΗ Χ (ΗΡΑΚΛΕΙΟ Ο.Α.& Α.)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Πρόγραμμα αγώνων",null,null,null,"Round 2","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["Έναρξη",{"$f":"Setup!$B$8","v":"Κ16"},{"$f":"IF(MD!M5=\"\", \"\", IF(MD!M5=1, CONCATENATE(LEFT(MD!J5,FIND(\" \",MD!J5)+1),\" (\",MD!L5,\")\"),CONCATENATE(LEFT(MD!J6,FIND(\" \",MD!J6)+1),\" (\",MD!L6,\")\")))","v":"ΜΠΑΛΑΣΚΑ Β (Ο.Α.ΧΑΝΙΩΝ)"},{"$f":"IF(OR(C20=\"\",E20=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(MD!M7=\"\", \"\", IF(MD!M7=1, CONCATENATE(LEFT(MD!J7,FIND(\" \",MD!J7)+1),\" (\",MD!L7,\")\"),CONCATENATE(LEFT(MD!J8,FIND(\" \",MD!J8)+1),\" (\",MD!L8,\")\")))","v":"ΖΑΦΕΙΡΟΠΟΥΛΟΥ Κ (ΗΡΑΚΛΕΙΟ Ο.Α.& Α.)"}]
[null,{"$f":"Setup!$B$8","v":"Κ16"},{"$f":"IF(MD!M9=\"\", \"\", IF(MD!M9=1, CONCATENATE(LEFT(MD!J9,FIND(\" \",MD!J9)+1),\" (\",MD!L9,\")\"),CONCATENATE(LEFT(MD!J10,FIND(\" \",MD!J10)+1),\" (\",MD!L10,\")\")))","v":"ΒΑΡΒΕΡΑΚΗ Μ (Ο.Α.ΧΑΝΙΩΝ)"},{"$f":"IF(OR(C21=\"\",E21=\"\"),\" \",\"-\")","v":"-"},{"$f":"IF(MD!M11=\"\", \"\", IF(MD!M11=1, CONCATENATE(LEFT(MD!J11,FIND(\" \",MD!J11)+1),\" (\",MD!L11,\")\"),CONCATENATE(LEFT(MD!J12,FIND(\" \",MD!J12)+1),\" (\",MD!L12,\")\")))","v":"ΒΕΛΙΒΑΣΑΚΗ Χ (ΗΡΑΚΛΕΙΟ Ο.Α.& Α.)"}]
[]
[]
[]
[]
[]
[]
[]
[]
["Don't Change this Worksheet !"]

{"sheet":"tables","index":7,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["RndIndx","random","FixRandom",null,null,"1ος","2ος","3-4","5-8","9-16","17-32",null,null,null,null,"Category","Juniors","Serniors"]
[1,{"$f":"RAND()/222","v":7.491937210100803E-4},3.0999797432514995E-3,null,"E1-12",30,25,15,10,7.5,5,null,null,null,null,"Α10","Α10","m35"]
[2,{"$f":"RAND()/22","v":5.9556943641484094E-3},4.3055314578819226E-2,null,"E1-14",60,50,30,20,15,10,null,null,null,null,"Α12","Α12","m40"]
[3,{"$f":"RAND()/22","v":3.8190044060142363E-2},2.6132819198510283E-2,null,"E1-16",120,100,60,40,30,20,null,null,null,null,"Α14","Α14","m45"]
[4,{"$f":"RAND()/22","v":3.5490060625671914E-2},6.9736139793432524E-3,null,"E1-18",150,125,75,50,37.5,25,null,null,null,null,"Α16","Α16","m50"]
[5,{"$f":"RAND()/22","v":4.1408339881080169E-2},4.5418389240040588E-2,null,"E2-12",15,12.5,7.5,5,4,2.5,null,null,null,null,"Α18","Α18","m55"]
[6,6.6109618685707009E-3,1.5410907851191046E-2,null,"E2-14",30,25,15,10,8,5,null,null,null,null,"Κ10","Κ10","m60"]
[7,4.2452489673366338E-2,4.3757453689638584E-2,null,"E2-16",60,50,30,20,16,10,null,null,null,null,"Κ12","Κ12","m65"]
[8,{"$f":"RAND()/22","v":1.681982958081046E-2},4.0902784767041386E-2,null,"E3-12",6,5,3,2,1.5,1,null,null,null,null,"Κ14","Κ14","m70"]
[null,null,null,null,"E3-14",12,10,6,4,3,2,null,null,null,null,"Κ16","Κ16","m75"]
[null,null,null,null,"E3-16",24,20,12,8,6,4,null,null,null,null,"Κ18","Κ18","w35"]
[null,null,null,null,"E4-12",3,2.5,1.5,1,0.75,0.5,null,null,null,null,"ΑΝΔ","ΑΝΔ","w40"]
[null,null,null,null,"E4-14",6,5,3,2,1.5,1,null,null,null,null,"ΓΥΝ","ΓΥΝ","w45"]
[null,null,null,null,"E4-16",12,10,6,4,3,2,null,null,null,null,"-","-","w50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-","w55"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-","-"]

{"sheet":"matches","index":8,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,10,0,11],[0,1,0,2],[0,3,0,4]]}
["round","winner",null,"looser",null,"score",null," Player "," Position ",null,"Set-up"]
[8,{"$f":"IF(OR(MD!$M$5 =1,MD!$M$5 =2), IF(MD!$M$5 =1,MD!$I$5,MD!$I$6),\"#\")","v":29655},{"$f":"TRIM(LEFT(VLOOKUP(B2,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(B2,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΜΠΑΛΑΣΚΑ"},{"$f":"IF(OR(MD!$M$5 =1,MD!$M$5 =2), IF(MD!$M$5 =2,MD!$I$5,MD!$I$6),\"#\")","v":30544},{"$f":"TRIM(LEFT(VLOOKUP(D2,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(D2,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΔΕΣΚΟΥΛΙΔΟΥ"},{"$f":"MD!O6","v":"42 41"},null,{"$f":"B8","v":29655},"1st",null,"title: ",{"$f":"Setup!$B$4","v":"3ο Ε3 2016"}]
[8,{"$f":"IF(OR(MD!$M$7 =1,MD!$M$7 =2), IF(MD!$M$7 =1,MD!$I$7,MD!$I$8),\"#\")","v":33088},{"$f":"TRIM(LEFT(VLOOKUP(B3,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(B3,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΖΑΦΕΙΡΟΠΟΥΛΟΥ"},{"$f":"IF(OR(MD!$M$7 =1,MD!$M$7 =2), IF(MD!$M$7 =2,MD!$I$7,MD!$I$8),\"#\")","v":33092},{"$f":"TRIM(LEFT(VLOOKUP(D3,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(D3,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΔΕΣΚΟΥΛΙΔΟΥ"},{"$f":"MD!O8","v":"40 42"},null,{"$f":"D8","v":31852},"2nd",null,"grade: ",{"$f":"Setup!$B$5","v":"e3"}]
[8,{"$f":"IF(OR(MD!$M$9 =1,MD!$M$9 =2), IF(MD!$M$9 =1,MD!$I$9,MD!$I$10),\"#\")","v":30527},{"$f":"TRIM(LEFT(VLOOKUP(B4,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(B4,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΒΑΡΒΕΡΑΚΗ"},{"$f":"IF(OR(MD!$M$9 =1,MD!$M$9 =2), IF(MD!$M$9 =2,MD!$I$9,MD!$I$10),\"#\")","v":30596},{"$f":"TRIM(LEFT(VLOOKUP(D4,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(D4,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΚΡΟΝΤΗΡΑ"},{"$f":"MD!O10","v":"40 40"},null,{"$f":"D6","v":33088},"3_4",null,"age: ",{"$f":"Setup!$B$6","v":16}]
[8,{"$f":"IF(OR(MD!$M$11=1,MD!$M$11=2), IF(MD!$M$11=1,MD!$I$11,MD!$I$12),\"#\")","v":31852},{"$f":"TRIM(LEFT(VLOOKUP(B5,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(B5,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΒΕΛΙΒΑΣΑΚΗ"},{"$f":"IF(OR(MD!$M$11=1,MD!$M$11=2), IF(MD!$M$11=2,MD!$I$11,MD!$I12),\"#\")","v":32222},{"$f":"TRIM(LEFT(VLOOKUP(D5,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(D5,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΣΤΑΜΟΥΛΟΥ"},{"$f":"MD!O12","v":"40 41"},null,{"$f":"D7","v":30527},"3_4",null,"category: ",{"$f":"Setup!$B$8","v":"Κ16"}]
[4,{"$f":"IF(OR(MD!$P$6 =1,MD!$P$6 =2), IF(MD!$P$6 =1,MD!$N$5,MD!$N$7),\"#\")","v":29655},{"$f":"TRIM(LEFT(VLOOKUP(B6,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(B6,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΜΠΑΛΑΣΚΑ"},{"$f":"IF(OR(MD!$P$6 =1,MD!$P$6 =2), IF(MD!$P$6 =2,MD!$N$5,MD!$N$7),\"#\")","v":33088},{"$f":"TRIM(LEFT(VLOOKUP(D6,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(D6,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΖΑΦΕΙΡΟΠΟΥΛΟΥ"},{"$f":"MD!R7","v":"60 62"},null,{"$f":"D2","v":30544},"5_8",null,"period: ",{"$f":"Setup!$B$9&\"-\"&Setup!$B$10","v":"22-23 Οκτωβρίου "}]
[4,{"$f":"IF(OR(MD!$P$10=1,MD!$P$10=2), IF(MD!$P$10=1,MD!$N$9,MD!$N$11),\"#\")","v":31852},{"$f":"TRIM(LEFT(VLOOKUP(B7,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(B7,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΒΕΛΙΒΑΣΑΚΗ"},{"$f":"IF(OR(MD!$P$10=1,MD!$P$10=2), IF(MD!$P$10=2,MD!$N$9,MD!$N$11),\"#\")","v":30527},{"$f":"TRIM(LEFT(VLOOKUP(D7,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(D7,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΒΑΡΒΕΡΑΚΗ"},{"$f":"MD!R11","v":"61 60"},null,{"$f":"D3","v":33092},"5_8",null,"organizer: ",{"$f":"Setup!$B$3","v":"Ζ΄ ΕΝΩΣΗ"}]
[2,{"$f":"IF(OR(MD!$S$8 =1,MD!$S$8 =2), IF(MD!$S$8 =1,MD!$Q$6,MD!$Q$10),\"#\")","v":29655},{"$f":"TRIM(LEFT(VLOOKUP(B8,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(B8,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΜΠΑΛΑΣΚΑ"},{"$f":"IF(OR(MD!$S$8 =1,MD!$S$8 =2), IF(MD!$S$8 =2,MD!$Q$6,MD!$Q$10),\"#\")","v":31852},{"$f":"TRIM(LEFT(VLOOKUP(D8,DrawPrep!$C$3:$D$10,2,FALSE),FIND(\" \",VLOOKUP(D8,DrawPrep!$C$3:$D$10,2,FALSE),1)-1))","v":"ΒΕΛΙΒΑΣΑΚΗ"},{"$f":"MD!U9","v":"62 61"},null,{"$f":"D4","v":30596},"5_8"]
[null,null,null,null,null,null,null,{"$f":"D5","v":32222},"5_8"]