{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Setup","DrawPrep","Draw","PrgPrep","Day1","Day2","notes","tmp","tmpRankings"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":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":3},"3 4"]
["Διοργανωτής: ","Θ ΕΝΩΣΗ",null,null,{"$f":"VALUE(RIGHT(F2,1))","v":4}]
["Τίτλος Τουρνουά: ","1οΕ3"]
["type: "]
["Έδρα αγώνων: ","ΟΑ ΧΑΛΚΙΔΑΣ"]
["Κατηγορία: ","Α14",null,"1 2 3 4 11 6 10 12 5 7 8 13 15 14 16 9 "]
["Έναρξη: ","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":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,{"$f":"IF(E14=\"-\",\"-\",IF(E14>0,D13+1,0))","v":3},3,6,3,3]
[null,null,null,{"$f":"IF(E15=\"-\",\"-\",IF(E15>0,D14+1,0))","v":4},{"$f":"IF(F15>0,VALUE(MID($D$7,F14+1,F15-F14-1)),\"-\")","v":4},8,4,4]
[null,null,null,5,{"$f":"IF(F16>0,VALUE(MID($D$7,F15+1,F16-F15-1)),\"-\")","v":11},11,5,11]
["Main Draw",{"$f":"\"(\"&COUNTBLANK(DrawPrep!D3:D18)&\")\"","v":"(0)"},null,6,{"$f":"IF(F17>0,VALUE(MID($D$7,F16+1,F17-F16-1)),\"-\")","v":6},13,6,6]
["Πλήθος bye (0-7): ",{"$f":"COUNTBLANK(DrawPrep!D3:D18)","v":0},null,7,10,16,7,10]
["Αριθμός θέσεων seeded: ",4,null,8,12,19,8,12]
[null,null,null,9,5,21,9,5]
[null,null,null,10,7,23,10,7]
[null,null,null,11,8,25,11,8]
[null,null,null,12,13,28,12,13]
["md  (# για off) ","ok",null,13,15,31,13,15]
[null,null,null,14,14,34,14,14]
[null,null,null,15,16,37,15,16]
["=RandUniq(3;4;2)",null,null,16,9,39,16,9]
[]
["=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":1,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[19,1,19,3],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7]]}
[{"$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":"Α14"}]
["α/α","από","Α.Μ.","Ονοματεπώνυμο","Σύλλογος","βαθμοί","Τηλέφωνο","Υπογραφή","SortPts","Rnd","trim"]
[1,null,30061,"ΑΝΑΓΝΩΣΤΟΠΟΥΛΟΣ ΔΗΜΗΤΡΗΣ","ΟΑ ΚΕΡΑΤΣΙΝΙΟΥ",84,null,null,{"$f":"IF(D3>\" \",F3+J3,0)","v":84.002591928240179},2.591928240173126E-3,{"$f":"TRIM(D3)","v":"ΑΝΑΓΝΩΣΤΟΠΟΥΛΟΣ ΔΗΜΗΤΡΗΣ"}]
[2,null,30060,"ΡΟΥΜΠΗΣ ΑΛΕΞΑΝΔΡΟΣ","ΟΑ ΧΑΛΚΙΔΑΣ",65.5,null,null,65.503289632375839,3.2896323758328703E-3,"ΡΟΥΜΠΗΣ ΑΛΕΞΑΝΔΡΟΣ"]
[3,null,32742,"ΜΑΝΟΥΣΑΚΗΣ ΔΗΜΗΤΡΗΣ","PALASKASTENNIS",62,null,null,62.002981610861276,2.981610861276354E-3,"ΜΑΝΟΥΣΑΚΗΣ ΔΗΜΗΤΡΗΣ"]
[4,null,32220,"ΣΦΙΚΤΗΣ ΠΑΝΑΓΙΩΤΗΣ","Ο.Α. ΠΕΤΡΟΥΠΟΛΗΣ",45,null,null,45.002283293683732,2.2832936837300587E-3,"ΣΦΙΚΤΗΣ ΠΑΝΑΓΙΩΤΗΣ"]
[5,null,33904,"ΜΟΥΜΤΖΟΓΛΟΥ ΝΙΚΟΣ","Α.Α. ΑΙΓΑΛΕΩ",null,null,null,4.0888249870355753E-3,4.0888249870355753E-3,"ΜΟΥΜΤΖΟΓΛΟΥ ΝΙΚΟΣ"]
[6,null,30180,"ΦΡΑΓΓΙΑΣ ΓΕΩΡΓΙΟΣ","ΟΑ ΧΑΛΚΙΔΑΣ",null,null,null,3.6672790026042791E-3,3.6672790026042791E-3,"ΦΡΑΓΓΙΑΣ ΓΕΩΡΓΙΟΣ"]
[7,null,34841,"ΒΡΕΚΟΣ ΔΗΜΗΤΡΗΣ","PALASKASTENNIS",null,null,null,3.5761741795440108E-3,3.5761741795440108E-3,"ΒΡΕΚΟΣ ΔΗΜΗΤΡΗΣ"]
[8,null,32084,"ΤΣΑΛΑΣ ΓΙΑΝΝΗΣ","Ο.Α. ΑΓΙΩΝ ΑΝΑΡΓΥΡΩΝ",null,null,null,3.2736047062224428E-3,3.2736047062224428E-3,"ΤΣΑΛΑΣ ΓΙΑΝΝΗΣ"]
[9,null,29735,"ΤΑΛΙΟΥΡΗΣ ΓΙΩΡΓΟΣ","ΑΙΟΛΟΣ ΙΛΙΟΥ",null,null,null,2.9359203326012186E-3,2.9359203326012186E-3,"ΤΑΛΙΟΥΡΗΣ ΓΙΩΡΓΟΣ"]
[10,null,29435,"ΤΖΑΘΑΣ ΝΙΚΟΣ","Ο.Α.ΚΑΙΣΑΡΙΑΝΗΣ",null,null,null,2.9120852755342166E-3,2.9120852755342166E-3,"ΤΖΑΘΑΣ ΝΙΚΟΣ"]
[11,null,35341,"ΤΣΙΑΚΑΛΟΣ ΜΙΧΑΗΛ","ΣΑ ΓΑΛΑΤΣΙΟΥ",null,null,null,2.3859058596848127E-3,2.3859058596848127E-3,"ΤΣΙΑΚΑΛΟΣ ΜΙΧΑΗΛ"]
[12,null,30287,"ΝΤΟΥΛΗΣ ΜΙΧΑΛΗΣ","Ο.Α ΣΑΛΑΜΙΝΑΣ",null,null,null,1.7931427938749701E-3,1.7931427938749701E-3,"ΝΤΟΥΛΗΣ ΜΙΧΑΛΗΣ"]
[13,null,35089,"ΚΑΣΤΡΙΤΣΕΑΣ ΑΡΙΣΤΟΦΑΝΗΣ","PALASKASTENNIS",null,null,null,1.5582527933040578E-3,1.5582527933040578E-3,"ΚΑΣΤΡΙΤΣΕΑΣ ΑΡΙΣΤΟΦΑΝΗΣ"]
[14,null,32140,"ΣΑΡΑΝΤΙΝΟΣ ΣΤΡΑΤΗΣ -ΓΡΗΓΟΡΗΣ","ΟΑ ΛΕΣΒΟΥ",null,null,null,1.0403613169710981E-3,1.0403613169710981E-3,"ΣΑΡΑΝΤΙΝΟΣ ΣΤΡΑΤΗΣ -ΓΡΗΓΟΡΗΣ"]
[15,null,34675,"KOTΣΑΝΤΑΣ ΑΝΤΩΝΗΣ","ΟΑ ΧΑΛΚΙΔΑΣ",null,null,null,5.8668758401409751E-4,5.8668758401409751E-4,"KOTΣΑΝΤΑΣ ΑΝΤΩΝΗΣ"]
[16,null,34369,"ΠΡΑΤΙΚΑΚΗΣ ΧΡΗΣΤΟΣ","ΣΑ ΓΑΛΑΤΣΙΟΥ",null,null,null,4.4390038905069117E-3,4.4390038905069117E-3,"ΠΡΑΤΙΚΑΚΗΣ ΧΡΗΣΤΟΣ"]
[]
[null,"Walk-over",null,null,"med"]
[null,"α/α","Α.Μ.","Ονοματεπώνυμο","Ν ή Ο",null,null,{"$f":"Setup!$B$10","v":0}]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]

{"sheet":"Draw","index":2,"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":"Α14"}]
[null,{"$f":"Setup!$B$18","v":0},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":84},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G5>0,VLOOKUP($G5,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":30061},{"$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":"ΟΑ ΚΕΡΑΤΣΙΝΙΟΥ"},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":5},1,{"$f":"E6","v":0},{"$f":"IF($B$2>=C6,1,0)","v":0},{"$f":"IF(NOT($G6=\"-\"),VLOOKUP($G6,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C6,\"-\",VLOOKUP($B6,Setup!$G$12:$H$27,2,FALSE))","v":11},{"$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":35341},{"$f":"IF($I6>0,VLOOKUP($I6,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΤΣΙΑΚΑΛΟΣ ΜΙΧΑΗΛ"},{"$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,"60 61",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":6},null,{"$f":"D6+E7","v":0},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":6},{"$f":"IF($G7>0,VLOOKUP($G7,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G7>0,VLOOKUP($G7,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":30180},{"$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,"63 61"]
[4,{"$f":"3-D8+4","v":7},7,0,{"$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":10},{"$f":"IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G8=\"-\"),VLOOKUP($G8,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":29435},{"$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,"75 63",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":3},null,0,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":3},{"$f":"IF($G9>0,VLOOKUP($G9,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":62},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G9>0,VLOOKUP($G9,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32742},{"$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":"PALASKASTENNIS"},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,"64 61"]
[6,{"$f":"4-D10+4","v":8},{"$f":"IF(Setup!E2=3,3,4)","v":3},0,{"$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":12},{"$f":"IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G10=\"-\"),VLOOKUP($G10,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":30287},{"$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,1,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":9},5,0,{"$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":5},{"$f":"IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G11=\"-\"),VLOOKUP($G11,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":33904},{"$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,"60 62"]
[8,{"$f":"6-D12+4","v":10},null,0,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":7},{"$f":"IF($G12>0,VLOOKUP($G12,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G12>0,VLOOKUP($G12,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":34841},{"$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":"PALASKASTENNIS"},null,"60 61",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":4},null,0,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":4},{"$f":"IF($G13>0,VLOOKUP($G13,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":45},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G13>0,VLOOKUP($G13,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32220},{"$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,"60 64"]
[10,{"$f":"7-D14+4","v":11},{"$f":"IF(Setup!E2=3,4,3)","v":4},0,{"$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":8},{"$f":"IF(NOT($G14=\"-\"),VLOOKUP($G14,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF(NOT($G14=\"-\"),VLOOKUP($G14,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":32084},{"$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":12},null,0,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":13},{"$f":"IF($G15>0,VLOOKUP($G15,DrawPrep!$A$3:$G$18,6,FALSE),0)","v":0},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G15>0,VLOOKUP($G15,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":35089},{"$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":"PALASKASTENNIS"},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 62"]
[12,{"$f":"9-D16+4","v":13},6,0,{"$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":15},{"$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":34675},{"$f":"IF($I16>0,VLOOKUP($I16,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"KOTΣΑΝΤΑΣ ΑΝΤΩΝΗΣ"},"KOTΣΑΝΤΑΣ",{"$f":"IF($I16>0,VLOOKUP($I16,DrawPrep!$C$3:$G$18,3,FALSE),\"\")","v":"ΟΑ ΧΑΛΚΙΔΑΣ"},null,"63 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":14},null,0,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":14},{"$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":32140},{"$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":"ΟΑ ΛΕΣΒΟΥ"},1,{"$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,"06 64 76(4)"]
[14,{"$f":"11-D18+4","v":15},8,0,{"$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":16},{"$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":34369},{"$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,"61 60",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":16},2,0,{"$f":"IF($B$2>=C19,1,0)","v":0},{"$f":"IF(NOT($G19=\"-\"),VLOOKUP($G19,DrawPrep!$A$3:$G$18,2,FALSE),\"\")","v":0},{"$f":"IF($B$2>=C19,\"-\",VLOOKUP($B19,Setup!$G$12:$H$27,2,FALSE))","v":9},{"$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":29735},{"$f":"IF($I19>0,VLOOKUP($I19,DrawPrep!$C$3:$G$18,2,FALSE),\"bye\")","v":"ΤΑΛΙΟΥΡΗΣ ΓΙΩΡΓΟΣ"},"ΤΑΛΙΟΥΡΗΣ",{"$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,"60 61"]
[16,2,null,0,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":65.5},{"$f":"IF(Setup!$B$24=\"#\",0,IF($G20>0,VLOOKUP($G20,DrawPrep!$A$3:$G$18,3,FALSE),0))","v":30060},{"$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,"61 60"]
[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":0}]
[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":3,"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, ΟΑ ΧΑΛΚΙΔΑΣ (Α14)"},null,null,null,null,null,"Don't Change this Worksheet !"]
[{"$f":"Setup!$B$10","v":0}]
["Πρόγραμμα αγώνων",null,null,null,"Round 1","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["Έναρξη",{"$f":"Setup!$B$7","v":"Α14"},{"$f":"IF(OR(Draw!J5=\"bye\",Draw!J5=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J5,FIND(\" \",Draw!J5)+1),\" (\",Draw!L5,\")\"))","v":"ΑΝΑΓΝΩΣΤΟΠΟΥΛΟΣ Δ (ΟΑ ΚΕΡΑΤΣΙΝΙΟΥ)"},{"$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":"Α14"},{"$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":"Α14"},{"$f":"IF(OR(Draw!J9=\"bye\",Draw!J9=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J9,FIND(\" \",Draw!J9)+1),\" (\",Draw!L9,\")\"))","v":"ΜΑΝΟΥΣΑΚΗΣ Δ (PALASKASTENNIS)"},"-",{"$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":"Α14"},{"$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":"ΒΡΕΚΟΣ Δ (PALASKASTENNIS)"}]
["όχι πριν",{"$f":"Setup!$B$7","v":"Α14"},{"$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":"Α14"},{"$f":"IF(OR(Draw!J15=\"bye\",Draw!J15=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J15,FIND(\" \",Draw!J15)+1),\" (\",Draw!L15,\")\"))","v":"ΚΑΣΤΡΙΤΣΕΑΣ Α (PALASKASTENNIS)"},"-",{"$f":"IF(OR(Draw!J16=\"bye\",Draw!J16=\"LWD\"), \"\",CONCATENATE(LEFT(Draw!J16,FIND(\" \",Draw!J16)+1),\" (\",Draw!L16,\")\"))","v":"KOTΣΑΝΤΑΣ Α (ΟΑ ΧΑΛΚΙΔΑΣ)"}]
[null,{"$f":"Setup!$B$7","v":"Α14"},{"$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":"Α14"},{"$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":"Α14"},{"$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":"ΑΝΑΓΝΩΣΤΟΠΟΥΛΟΣ Δ (ΟΑ ΚΕΡΑΤΣΙΝΙΟΥ)"},{"$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":"Α14"},{"$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":"ΜΑΝΟΥΣΑΚΗΣ Δ (PALASKASTENNIS)"},{"$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":"ΒΡΕΚΟΣ Δ (PALASKASTENNIS)"}]
[null,{"$f":"Setup!$B$7","v":"Α14"},{"$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":"ΚΑΣΤΡΙΤΣΕΑΣ Α (PALASKASTENNIS)"}]
[null,{"$f":"Setup!$B$7","v":"Α14"},{"$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":4,"n_rows":22,"n_cols":6,"rows_kept":22,"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, ΟΑ ΧΑΛΚΙΔΑΣ (Α14)"}]
[{"$f":"Setup!$B$10","v":0}]
["Πρόγραμμα αγώνων",null,null,null,"Round 1","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["09.30","Α14","ΑΝΑΓΝΩΣΤΟΠΟΥΛΟΣ",null,"ΦΡΑΓΓΙΑΣ"]
[null,"Α14","ΣΦΙΚΤΗΣ ",null,"ΚΟΤΣΑΝΤΑΣ"]
[null,"Α14","ΣΑΡΑΝΤΙΝΟΣ",null,"ΡΟΥΜΠΗΣ"]
[null,"Κ14","ΣΤΑΜΑΤΟΓΙΑΝΝΟΠΟΥΛΟΥ",null,"ΤΣΕΣΜΕΤΖΗ"]
[null,"Κ14","ΜΑΥΡΟΓΙΑΝΝΑΚΗ",null,"ΓΡΙΒΑ"]
["11.ΟΟ"]
[null,"Κ14","ΤΣΑΔΑΡΗ",null,"ΚΩΣΤΑΝΤΟΠΟΥΛΟΥ"]
[null,"Κ14","ΠΟΣΤΑΤΖΙΑΝ ",null,"ΚΩΣΤΑ ΦΩΤΗ"]
[null,"Κ12","ΖΑΧΑΡΑΚΗ",null,"ΠΑΠΑΣΩΤΗΡΙΟΥ"]
[null,"Κ12","ΑΔΑΜΟΠΟΥΛΟΥ",null,"ΑΔΑΜΟΠΟΥΛΟΥ"]
["12.30"]
[null,"Α16","ΠΙΤΣΙΝΗΣ",null,"ΤΖΩΡΤΖΗΣ"]
[null,"Α16","ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ",null,"ΖΕΡΔΙΛΑΣ"]
[null,"Κ16","ΓΡΙΒΑ ",null,"ΜΠΟΜΠΟΛΑΚΗ"]
[null,"Κ16","ΓΕΩΡΓΟΠΟΥΛΟΥ",null,"ΤΣΙΑΡΑ"]
[]
["13.30","Α12","ΧΡΙΣΤΑΝΑΣ ",null,"ΣΠΗΛΙΩΤΟΠΟΥΛΟΣ"]
[null,"Α12","ΖΑΧΙΩΤΗΣ ",null,"ΚΑΡΑΜΑΝΗΣ"]

{"sheet":"Day2","index":5,"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, ΟΑ ΧΑΛΚΙΔΑΣ (Α14)"}]
[{"$f":"Setup!$B$10","v":0}]
["Πρόγραμμα αγώνων",null,null,null,"Round 2","i"]
["ΩΡΑ","Κτγρ.","Αθλητής-Σύλλογος",null,"Αθλητής-Σύλλογος"]
["Έναρξη","Α12",""," ",""]
[null,"Α12",""," ",""]
[null,"Α12",""," ",""]
[null,"Α12",""," ",""]
["όχι πριν"]
[]
[]
[]
[]
[" "]

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

{"sheet":"tmp","index":7,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,8,0,23],[1,16,1,17],[2,8,5,8],[2,16,5,16],[6,8,8,8],[6,16,8,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],[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]]}
["RndIndx","random","FixRandom",null,"α/α","seed","ByeOrder",null,"ΠΡΟΚΡΙΜΑΤΙΚΑ E1, E2 (32 για 8)"]
[1,{"$f":"RAND()/222","v":1.6486080972398036E-3},2.591928240173126E-3,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":3.9163384486716555E-3},3.2896323758328703E-3,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":8.2382903914823889E-4},2.981610861276354E-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":2.6008096419232347E-4},2.2832936837300587E-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":3.2613798278282144E-3},1.0403613169710981E-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":1.4370290364567812E-4},3.5761741795440108E-3,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,4.0875475231889873E-3,4.0888249870355753E-3,null,7,null,5,null,null,"E2-14",1,2,2,0,0,0,null,"E2-14",1,1,0,0,0,0]
[8,3.9176768977319523E-3,3.2736047062224428E-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,3.1830461936991419E-3,3.6672790026042791E-3,null,9,4]
[10,3.7891115754133992E-3,1.5582527933040578E-3,null,10,null,4]
[11,3.0904140709831361E-3,1.7931427938749701E-3,null,11,null,null,null,"ΚΥΡΙΩΣ ΤΑΜΠΛΟ E1, E2 & E3"]
[12,3.207939919310572E-3,5.8668758401409751E-4,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,3.3117396209585352E-3,2.3859058596848127E-3,null,13,null,null,null,"E1","E1-12",7,10,14,21,35,42,"E1","E1-12",7,3,4,7,14,7]
[14,3.5538834723512465E-3,2.9359203326012186E-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,3.171471811297255E-3,2.9120852755342166E-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.1899383343884776E-3,4.4390038905069117E-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":8,"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)"]