{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Boys 10 Si Main","Girls 10 Si Main","Boys 12 Si MD","Girls 12 Si MD","Boys 14 Si Main","Girls 14 Si Main","Boys 16 Si Main","Girls Si Main 16","Boys 18 Si Main","Girls 18 Si Main"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":4,"defined_names":284,"comments":10,"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":"Boys 10 Si Main","index":0,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
[{"$f":"'[1]Week SetUp'!$A$6","v":"Sagicor Junior Tennis Tournament 2015"},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"BOYS 10 SINGLES"]
["Week of",null,null,null,"Venue",null,null,null,null,"Tour. Director",null,null,null,null,null,null,"TUATT Referee"]
[{"$f":"'[1]Week SetUp'!$A$10","v":"5th - 11th July 2015"},null,null,null,{"$f":"'[1]Week SetUp'!$C$10","v":"Eddie Tayor Public Courts, Nelson Mandela Park"},null,null,null,null,{"$f":"'[1]Week SetUp'!$A$12","v":"Anthony Sanchez"},null,null,null,null,null,null,{"$f":"'[1]Week SetUp'!$E$10","v":"Colleen De Gannes / Edwin Chu For"}]
[null,"St.","Rank","Seed","Family Name","First name",null,"Nationality",null,"Semifinals",null,"Final",null,"Winner"]
[]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"SYLVESTER"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Beckham"},null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P21","v":"Umpire"}]
[null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(I8=\"a\",I8=\"as\"),E7,IF(OR(I8=\"b\",I8=\"bs\"),E9,)))","v":"SYLVESTER"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P22","v":" "}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},6,{"$f":"UPPER(IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"MITCHELL "},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Jayden"},null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"W/O",null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P23","v":" "}]
[null,null,null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(K10=\"a\",K10=\"as\"),J8,IF(OR(K10=\"b\",K10=\"bs\"),J12,)))","v":"SYLVESTER"},null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P24","v":" "}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},3,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"CHIN"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Alex"},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"6 0",null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P25","v":" "}]
[null,null,null,null,null,null,null,"Umpire","A",{"$f":"UPPER(IF(OR(I12=\"a\",I12=\"as\"),E11,IF(OR(I12=\"b\",I12=\"bs\"),E13,)))","v":"CHIN"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P26","v":" "}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},7,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"RAMSUMAIR"},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Shane"},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"6 4",null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P27","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Umpire","b",{"$f":"UPPER(IF(OR(M14=\"a\",M14=\"as\"),L10,IF(OR(M14=\"b\",M14=\"bs\"),L18,)))","v":"PASEA"},null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P28","v":" "}]
[5,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},5,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"SHEPPARD"},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Declan"},null,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,"65(6)",null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P29","v":" "}]
[null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(I16=\"a\",I16=\"as\"),E15,IF(OR(I16=\"b\",I16=\"bs\"),E17,)))","v":"TRESTRAIL"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P30","v":"None"}]
[6,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},4,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"TRESTRAIL"},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Ethan-Jude"},null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"6 4"]
[null,null,null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(K18=\"a\",K18=\"as\"),J16,IF(OR(K18=\"b\",K18=\"bs\"),J20,)))","v":"PASEA"}]
[7,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},8,{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"PASEA"},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Tim"},null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"6 1"]
[null,null,null,null,null,null,null,"Umpire","A",{"$f":"UPPER(IF(OR(I20=\"a\",I20=\"as\"),E19,IF(OR(I20=\"b\",I20=\"bs\"),E21,)))","v":"PASEA"}]
[8,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},2,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"READY"},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Nicholas"},null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Boys 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"6 4"]
[]
["Acc. Ranking",null,null,"#","Seeded players",null,null,null,"#","Lucky Losers",null,"Replacing",null,"Draw date/time:",null,"06/07/15 :5:45pm"]
["Rkg Date",null,null,1,{"$f":"IF(D24>$Q$31,,UPPER(VLOOKUP(D24,'[1]Boys 10 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"SYLVESTER"},null,null,null,"1",null,null,null,null,"Last Accepted player"]
["Top DA",null,null,2,{"$f":"IF(D25>$Q$31,,UPPER(VLOOKUP(D25,'[1]Boys 10 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"READY"},null,null,null,"2"]
["Last DA",null,null,3,{"$f":"IF(D26>$Q$31,,UPPER(VLOOKUP(D26,'[1]Boys 10 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"3",null,null,null,null,"Player representatives"]
[null,null,null,4,{"$f":"IF(D27>$Q$31,,UPPER(VLOOKUP(D27,'[1]Boys 10 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"4"]
["Seed ranking",null,null,null,null,null,null,null,"5"]
["Rkg Date",null,null,null,null,null,null,null,"6",null,null,null,null,"ITF Referee's signature"]
["Top seed",null,null,null,null,null,null,null,"7"]
["Last seed",null,null,null,null,null,null,null,"8",null,null,null,null,{"$f":"Q4","v":"Colleen De Gannes / Edwin Chu For"},null,null,{"$f":"MIN(4,'[1]Boys 10 Si Main Draw Prep'!R5)","v":2}]

{"sheet":"Girls 10 Si Main","index":1,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
[{"$f":"'[1]Week SetUp'!$A$6","v":"Sagicor Junior Tennis Tournament 2015"},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"GIRLS 10 SINGLES"]
["Week of",null,null,null,null,"Venue",null,null,null,null,null,"Tour. Director",null,null,null,null,"ITF Referee"]
[{"$f":"'[1]Week SetUp'!$A$10","v":"5th - 11th July 2015"},null,null,null,null,{"$f":"'[1]Week SetUp'!$C$10","v":"Eddie Tayor Public Courts, Nelson Mandela Park"},null,null,null,{"$f":"'[1]Week SetUp'!$D$10","v":0},null,{"$f":"'[1]Week SetUp'!$A$12","v":"Anthony Sanchez"},null,null,null,null,{"$f":"'[1]Week SetUp'!$E$10","v":"Colleen De Gannes / Edwin Chu For"}]
[null,"St.","Rank","Seed","Family Name","First name",null,"Nationality",null,"Semifinals",null,"Final",null,"Winner"]
[]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"WONG"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Cameron"},null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P21","v":"Umpire"}]
[null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(I8=\"a\",I8=\"as\"),E7,IF(OR(I8=\"b\",I8=\"bs\"),E9,)))","v":"WONG"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P22","v":" "}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},7,{"$f":"UPPER(IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"BYE"},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":0},null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P23","v":" "}]
[null,null,null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(K10=\"a\",K10=\"as\"),J8,IF(OR(K10=\"b\",K10=\"bs\"),J12,)))","v":"WONG"},null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P24","v":" "}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},6,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"ALI"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Ellice"},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"6 0",null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P25","v":" "}]
[null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(I12=\"a\",I12=\"as\"),E11,IF(OR(I12=\"b\",I12=\"bs\"),E13,)))","v":"MACKENZIE"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P26","v":" "}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},3,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"MACKENZIE"},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Gabriella"},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"6 0",null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P27","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Umpire","as",{"$f":"UPPER(IF(OR(M14=\"a\",M14=\"as\"),L10,IF(OR(M14=\"b\",M14=\"bs\"),L18,)))","v":"WONG"},null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P28","v":" "}]
[5,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},4,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"READY"},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Charlotte"},null,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,61,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P29","v":" "}]
[null,null,null,null,null,null,null,"Umpire","A",{"$f":"UPPER(IF(OR(I16=\"a\",I16=\"as\"),E15,IF(OR(I16=\"b\",I16=\"bs\"),E17,)))","v":"READY"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P30","v":"None"}]
[6,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},5,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"GHURAN"},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Zara"},null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"6 2"]
[null,null,null,null,null,null,null,null,null,"Umpire","A",{"$f":"UPPER(IF(OR(K18=\"a\",K18=\"as\"),J16,IF(OR(K18=\"b\",K18=\"bs\"),J20,)))","v":"READY"}]
[7,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},7,{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"BYE"},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":0},null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"6 5 (8)"]
[null,null,null,null,null,null,null,"Umpire","BS",{"$f":"UPPER(IF(OR(I20=\"a\",I20=\"as\"),E19,IF(OR(I20=\"b\",I20=\"bs\"),E21,)))","v":"CARRINGTON"}]
[8,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},2,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"CARRINGTON"},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Ella"},null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Girls 10 Si Main Draw Prep'!$A$7:$P$22,4))","v":0}]
[]
["Acc. Ranking",null,null,"#","Seeded players",null,null,null,"#","Lucky Losers",null,"Replacing",null,"Draw date/time:",null,"06/07/15 : 10:20pm"]
["Rkg Date",null,null,1,{"$f":"IF(D24>$Q$31,,UPPER(VLOOKUP(D24,'[1]Girls 10 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"WONG"},null,null,null,"1",null,null,null,null,"Last Accepted player"]
["Top DA",null,null,2,{"$f":"IF(D25>$Q$31,,UPPER(VLOOKUP(D25,'[1]Girls 10 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"CARRINGTON"},null,null,null,"2"]
["Last DA",null,null,3,{"$f":"IF(D26>$Q$31,,UPPER(VLOOKUP(D26,'[1]Girls 10 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"3",null,null,null,null,"Player representatives"]
[null,null,null,4,{"$f":"IF(D27>$Q$31,,UPPER(VLOOKUP(D27,'[1]Girls 10 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"4"]
["Seed ranking",null,null,null,null,null,null,null,"5"]
["Rkg Date",null,null,null,null,null,null,null,"6",null,null,null,null,"ITF Referee's signature"]
["Top seed",null,null,null,null,null,null,null,"7"]
["Last seed",null,null,null,null,null,null,null,"8",null,null,null,null,{"$f":"Q4","v":"Colleen De Gannes / Edwin Chu For"},null,null,{"$f":"MIN(4,'[1]Girls 10 Si Main Draw Prep'!R5)","v":2}]

{"sheet":"Boys 12 Si MD","index":2,"n_rows":47,"n_cols":20,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
[{"$f":"'[1]Week SetUp'!$A$6","v":"Sagicor Junior Tennis Tournament 2015"},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"BOYS 12 MAIN DRAW"]
["Week of",null,null,null,null,"Venue",null,null,null,null,null,"Tour. Director",null,null,null,null,"TUATT Referee"]
[{"$f":"'[1]Week SetUp'!$A$10","v":"5th - 11th July 2015"},null,null,null,null,{"$f":"'[1]Week SetUp'!$C$10","v":"Eddie Tayor Public Courts, Nelson Mandela Park"},null,null,null,{"$f":"'[1]Week SetUp'!$D$10","v":0},null,{"$f":"'[1]Week SetUp'!$A$12","v":"Anthony Sanchez"},null,null,null,null,{"$f":"'[1]Week SetUp'!$E$10","v":"Colleen De Gannes / Edwin Chu For"}]
[null,"St.","Rank","Seed","Family Name","First name",null,"Nationality",null,"Quarterfinals",null,"Semifinals",null,"Finals",null,"Winner"]
[]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,2)))","v":"SHEPPARD"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Liam"},null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P21","v":"Umpire"}]
[null,null,null,null,null,null,null,null,"as",{"$f":"UPPER(IF(OR(I8=\"a\",I8=\"as\"),E7,IF(OR(I8=\"b\",I8=\"bs\"),E9,)))","v":"SHEPPARD"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P22","v":" "}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":""},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":""},null,"BYE",{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":""},null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P23","v":" "}]
[null,null,null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(K10=\"a\",K10=\"as\"),J8,IF(OR(K10=\"b\",K10=\"bs\"),J12,)))","v":"SHEPPARD"},null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P24","v":" "}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},7,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,2)))","v":"SHAMSI"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Luca"},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0},null,null,null,"42 41",null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P25","v":" "}]
[null,null,null,null,null,null,null,"Umpire","a",{"$f":"UPPER(IF(OR(I12=\"a\",I12=\"as\"),E11,IF(OR(I12=\"b\",I12=\"bs\"),E13,)))","v":"SHAMSI"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P26","v":" "}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},9,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,2)))","v":"SYLVESTER"},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Sebastian"},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0},null,"42 40",null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P27","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Umpire","as",{"$f":"UPPER(IF(OR(M14=\"a\",M14=\"as\"),L10,IF(OR(M14=\"b\",M14=\"bs\"),L18,)))","v":"SHEPPARD"},null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P28","v":" "}]
[5,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},4,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,2)))","v":"NWOKOLO"},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Ebolum"},null,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0},null,null,null,null,null,"41 14 {10-4}",null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P29","v":" "}]
[null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(I16=\"a\",I16=\"as\"),E15,IF(OR(I16=\"b\",I16=\"bs\"),E17,)))","v":"NWOKOLO"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P30","v":"None"}]
[6,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":""},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":""},null,"BYE",{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":""},null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":""}]
[null,null,null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(K18=\"a\",K18=\"as\"),J16,IF(OR(K18=\"b\",K18=\"bs\"),J20,)))","v":"NWOKOLO"}]
[7,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},8,"WEST",{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Michael"},null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0},null,null,null,"42 40"]
[null,null,null,null,null,null,null,null,"a",{"$f":"UPPER(IF(OR(I20=\"a\",I20=\"as\"),E19,IF(OR(I20=\"b\",I20=\"bs\"),E21,)))","v":"WEST"}]
[8,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},6,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,2)))","v":"OURA"},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Kato"},null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0},null,"W/O"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Umpire","as",{"$f":"UPPER(IF(OR(O22=\"a\",O22=\"as\"),N14,IF(OR(O22=\"b\",O22=\"bs\"),N30,)))","v":"SHEPPARD"}]
[9,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},12,{"$f":"UPPER(IF($D23=\"\",\"\",VLOOKUP($D23,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,2)))","v":"ALI"},{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Elias"},null,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0},null,null,null,null,null,null,null,"42 14 {10-1}"]
[null,null,null,null,null,null,null,null,"B",{"$f":"UPPER(IF(OR(I24=\"a\",I24=\"as\"),E23,IF(OR(I24=\"b\",I24=\"bs\"),E25,)))","v":"DEVAUX"}]
[10,{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},10,"DEVAUX",{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Charles"},null,{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0},null,"41 24 [10 - 5]"]
[null,null,null,null,null,null,null,null,null,"Umpire","A",{"$f":"UPPER(IF(OR(K26=\"a\",K26=\"as\"),J24,IF(OR(K26=\"b\",K26=\"bs\"),J28,)))","v":"DEVAUX"}]
[11,{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":""},{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":""},null,"BYE",{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":""},null,{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":""},null,null,null,"04 42 [10 - 7]"]
[null,null,null,null,null,null,null,"Umpire","BS",{"$f":"UPPER(IF(OR(I28=\"a\",I28=\"as\"),E27,IF(OR(I28=\"b\",I28=\"bs\"),E29,)))","v":"VALDEZ"}]
[12,{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},3,{"$f":"UPPER(IF($D29=\"\",\"\",VLOOKUP($D29,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,2)))","v":"VALDEZ"},{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Nathan"},null,{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Umpire","bs",{"$f":"UPPER(IF(OR(M30=\"a\",M30=\"as\"),L26,IF(OR(M30=\"b\",M30=\"bs\"),L34,)))","v":"RODRIGUEZ"}]
[13,{"$f":"IF($D31=\"\",\"\",VLOOKUP($D31,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D31=\"\",\"\",VLOOKUP($D31,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},11,{"$f":"UPPER(IF($D31=\"\",\"\",VLOOKUP($D31,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,2)))","v":"HINKSON"},{"$f":"IF($D31=\"\",\"\",VLOOKUP($D31,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Levi"},null,{"$f":"IF($D31=\"\",\"\",VLOOKUP($D31,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0},null,null,null,null,null,"42 14 {10-6}"]
[null,null,null,null,null,null,null,"Umpire","bs",{"$f":"UPPER(IF(OR(I32=\"a\",I32=\"as\"),E31,IF(OR(I32=\"b\",I32=\"bs\"),E33,)))","v":"RODRIGUEZ"}]
[14,{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},5,{"$f":"UPPER(IF($D33=\"\",\"\",VLOOKUP($D33,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,2)))","v":"RODRIGUEZ"},{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"David"},null,{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0},null,"41 53"]
[null,null,null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(K34=\"a\",K34=\"as\"),J32,IF(OR(K34=\"b\",K34=\"bs\"),J36,)))","v":"RODRIGUEZ"}]
[15,{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":""},{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":""},null,"BYE",{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":""},null,{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":""},null,null,null,"54(5) 54(4)"]
[null,null,null,null,null,null,null,null,"bs",{"$f":"UPPER(IF(OR(I36=\"a\",I36=\"as\"),E35,IF(OR(I36=\"b\",I36=\"bs\"),E37,)))","v":"KERRY"}]
[16,{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,15))","v":0},{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,16))","v":0},2,{"$f":"UPPER(IF($D37=\"\",\"\",VLOOKUP($D37,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,2)))","v":"KERRY"},{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,3))","v":"Kyle"},null,{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,'[1]Boys 10 Si MD Prep'!$A$7:$P$30,4))","v":0}]
[]
["Acc. Ranking",null,null,"#","Seeded players",null,null,null,"#","Alternates",null,"Replacing",null,"Draw date/time:",null,"06/07/15 : 10:45pm"]
["Rkg Date",null,null,1,{"$f":"IF(D40>$Q$47,,UPPER(VLOOKUP(D40,'[1]Boys 10 Si MD Prep'!$A$7:$R$134,2)))","v":"SHEPPARD"},null,null,null,"1",null,null,null,null,"Last Accepted player"]
["Top DA",null,null,2,{"$f":"IF(D41>$Q$47,,UPPER(VLOOKUP(D41,'[1]Boys 10 Si MD Prep'!$A$7:$R$134,2)))","v":"KERRY"},null,null,null,"2"]
["Last DA",null,null,3,{"$f":"IF(D42>$Q$47,,UPPER(VLOOKUP(D42,'[1]Boys 10 Si MD Prep'!$A$7:$R$134,2)))","v":"VALDEZ"},null,null,null,"3",null,null,null,null,"Player representatives"]
[null,null,null,4,{"$f":"IF(D43>$Q$47,,UPPER(VLOOKUP(D43,'[1]Boys 10 Si MD Prep'!$A$7:$R$134,2)))","v":"NWOKOLO"},null,null,null,"4"]
["Seed ranking",null,null,null,null,null,null,null,"5"]
["Rkg Date",null,null,null,null,null,null,null,"6",null,null,null,null,"ITF Referee's signature"]
["Top seed",null,null,null,null,null,null,null,"7"]
["Last seed",null,null,null,null,null,null,null,"8",null,null,null,null,{"$f":"Q4","v":"Colleen De Gannes / Edwin Chu For"},null,null,{"$f":"MIN(6,'[1]Boys 10 Si MD Prep'!R5)","v":4}]

{"sheet":"Girls 12 Si MD","index":3,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
[{"$f":"'[1]Week SetUp'!$A$6","v":"Sagicor Junior Tennis Tournament 2015"},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"GIRLS 12 MAIN DRAW"]
["Week of",null,null,null,null,"Venue",null,null,null,null,null,"Tour. Director",null,null,null,null,"TUATT Referee"]
[{"$f":"'[1]Week SetUp'!$A$10","v":"5th - 11th July 2015"},null,null,null,null,{"$f":"'[1]Week SetUp'!$C$10","v":"Eddie Tayor Public Courts, Nelson Mandela Park"},null,null,null,{"$f":"'[1]Week SetUp'!$D$10","v":0},null,{"$f":"'[1]Week SetUp'!$A$12","v":"Anthony Sanchez"},null,null,null,null,{"$f":"'[1]Week SetUp'!$E$10","v":"Colleen De Gannes / Edwin Chu For"}]
[null,"St.","Rank","Seed","Family Name","First name",null,"Nationality",null,"Semifinals",null,"Finals",null,"Winner"]
[]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,16))","v":0},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,2)))","v":"LAWRENCE"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,3))","v":"Emily"},null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P21","v":"Umpire"}]
[null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(I8=\"a\",I8=\"as\"),E7,IF(OR(I8=\"b\",I8=\"bs\"),E9,)))","v":"LAWRENCE"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P22","v":" "}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,16))","v":0},7,{"$f":"UPPER(IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,2)))","v":"BYE"},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,3))","v":0},null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P23","v":" "}]
[null,null,null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(K10=\"a\",K10=\"as\"),J8,IF(OR(K10=\"b\",K10=\"bs\"),J12,)))","v":"LAWRENCE"},null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P24","v":" "}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,16))","v":0},3,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,2)))","v":"ABRAHAM"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,3))","v":"Isabel"},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"42 42",null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P25","v":" "}]
[null,null,null,null,null,null,null,"Umpire","b",{"$f":"UPPER(IF(OR(I12=\"a\",I12=\"as\"),E11,IF(OR(I12=\"b\",I12=\"bs\"),E13,)))","v":"HONORE"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P26","v":" "}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,16))","v":0},5,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,2)))","v":"HONORE"},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,3))","v":"Maria"},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,4))","v":0},null,"54(9) 42",null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P27","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Umpire","as",{"$f":"UPPER(IF(OR(M14=\"a\",M14=\"as\"),L10,IF(OR(M14=\"b\",M14=\"bs\"),L18,)))","v":"LAWRENCE"},null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P28","v":" "}]
[5,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,16))","v":0},6,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,2)))","v":"MERRY"},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,3))","v":"Charlotte"},null,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,"14 53 {11-9}",null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P29","v":" "}]
[null,null,null,null,null,null,null,"Umpire","a",{"$f":"UPPER(IF(OR(I16=\"a\",I16=\"as\"),E15,IF(OR(I16=\"b\",I16=\"bs\"),E17,)))","v":"MERRY"},null,null,null,null,null,null,null,null,null,{"$f":"'[1]SetUp Officials'!P30","v":"None"}]
[6,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,16))","v":0},4,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,2)))","v":"D'ARCY"},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,3))","v":"Isabella"},null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,4))","v":0},null,"42 41"]
[null,null,null,null,null,null,null,null,null,"Umpire","BS",{"$f":"UPPER(IF(OR(K18=\"a\",K18=\"as\"),J16,IF(OR(K18=\"b\",K18=\"bs\"),J20,)))","v":"ALEXIS"}]
[7,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,16))","v":0},7,{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,2)))","v":"BYE"},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,3))","v":0},null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"24 40 [10 - 2]"]
[null,null,null,null,null,null,null,"Umpire","BS",{"$f":"UPPER(IF(OR(I20=\"a\",I20=\"as\"),E19,IF(OR(I20=\"b\",I20=\"bs\"),E21,)))","v":"ALEXIS"}]
[8,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,16))","v":0},2,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,2)))","v":"ALEXIS"},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,3))","v":"Aalisha"},null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[1]Girls 12 Si MD Draw Prep'!$A$7:$P$22,4))","v":0}]
[]
["Acc. Ranking",null,null,"#","Seeded players",null,null,null,"#","Alternates",null,"Replacing",null,"Draw date/time:",null,"06/07/15 : 11:10pm"]
["Rkg Date",null,null,1,{"$f":"IF(D24>$Q$31,,UPPER(VLOOKUP(D24,'[1]Girls 12 Si MD Draw Prep'!$A$7:$R$134,2)))","v":"LAWRENCE"},null,null,null,"1",null,null,null,null,"Last Accepted player"]
["Top DA",null,null,2,{"$f":"IF(D25>$Q$31,,UPPER(VLOOKUP(D25,'[1]Girls 12 Si MD Draw Prep'!$A$7:$R$134,2)))","v":"ALEXIS"},null,null,null,"2"]
["Last DA",null,null,3,{"$f":"IF(D26>$Q$31,,UPPER(VLOOKUP(D26,'[1]Girls 12 Si MD Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"3",null,null,null,null,"Player representatives"]
[null,null,null,4,{"$f":"IF(D27>$Q$31,,UPPER(VLOOKUP(D27,'[1]Girls 12 Si MD Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"4"]
["Seed ranking",null,null,null,null,null,null,null,"5"]
["Rkg Date",null,null,null,null,null,null,null,"6",null,null,null,null,"ITF Referee's signature"]
["Top seed",null,null,null,null,null,null,null,"7"]
["Last seed",null,null,null,null,null,null,null,"8",null,null,null,null,{"$f":"Q4","v":"Colleen De Gannes / Edwin Chu For"},null,null,{"$f":"MIN(4,'[1]Girls 12 Si MD Draw Prep'!R5)","v":2}]

{"sheet":"Boys 14 Si Main","index":4,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
[{"$f":"'[2]Week SetUp'!$A$6","v":"Sagicor Junior Tennis Tournament 2015"},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"BOYS 14 MAIN DRAW SINGLES"]
["Week of",null,null,null,null,"Venue",null,null,null,null,null,"Tour. Director",null,null,null,null,"TUATT Referee"]
[{"$f":"'[2]Week SetUp'!$A$10","v":"5th  - 11th July 2015"},null,null,null,null,{"$f":"'[2]Week SetUp'!$C$10","v":"Eddie Taylor Public Courts, Nelson Mandela Park"},null,null,null,{"$f":"'[2]Week SetUp'!$D$10","v":0},null,{"$f":"'[2]Week SetUp'!$A$12","v":"Anthony Sanchez"},null,null,null,null,{"$f":"'[2]Week SetUp'!$E$10","v":"Colleen De Gannes / Edwin Chu For"}]
[null,"St.","Rank","Seed","Family Name","First name",null,"Nationality",null,"2nd Round",null,"Semifinals",null,"Final",null,"Winner"]
[]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"LAQUIS"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Edward"},null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P21","v":"Umpire"}]
[null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(I8=\"a\",I8=\"as\"),E7,IF(OR(I8=\"b\",I8=\"bs\"),E9,)))","v":"LAQUIS"},null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P22","v":" "}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":""},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":""},null,"BYE",{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":""},null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P23","v":" "}]
[null,null,null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(K10=\"a\",K10=\"as\"),J8,IF(OR(K10=\"b\",K10=\"bs\"),J12,)))","v":"ALEXIS"},null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P24","v":" "}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},4,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"ALEXIS"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Jaydon"},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"62 62",null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P25","v":" "}]
[null,null,null,null,null,null,null,"Umpire","A",{"$f":"UPPER(IF(OR(I12=\"a\",I12=\"as\"),E11,IF(OR(I12=\"b\",I12=\"bs\"),E13,)))","v":"ALEXIS"},null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P26","v":" "}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},5,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"GEORGE"},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Kaiell"},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"62 62",null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P27","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Umpire","BS",{"$f":"UPPER(IF(OR(M14=\"a\",M14=\"as\"),L10,IF(OR(M14=\"b\",M14=\"bs\"),L18,)))","v":"WEST"},null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P28","v":" "}]
[5,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},6,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"LEE YOUNG"},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Kyle"},null,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,"62 46 [11 - 9]",null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P29","v":" "}]
[null,null,null,null,null,null,null,"Umpire","B","WILKINSON",null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P30","v":"None"}]
[6,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},3,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"WILKINSON"},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Rashaan"},null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"61 60"]
[null,null,null,null,null,null,null,null,null,"Umpire","BS",{"$f":"UPPER(IF(OR(K18=\"a\",K18=\"as\"),J16,IF(OR(K18=\"b\",K18=\"bs\"),J20,)))","v":"WEST"}]
[7,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":""},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":""},null,"BYE",{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":""},null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":""},null,null,null,"62 64"]
[null,null,null,null,null,null,null,"Umpire","BS",{"$f":"UPPER(IF(OR(I20=\"a\",I20=\"as\"),E19,IF(OR(I20=\"b\",I20=\"bs\"),E21,)))","v":"WEST"}]
[8,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},2,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"WEST"},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Samuel"},null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[2]Boys 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0}]
[]
["Acc. Ranking",null,null,"#","Seeded players",null,null,null,"#","Lucky Losers",null,"Replacing",null,"Draw date/time:",null,"06/07/15 : 11:32pm"]
["Rkg Date",null,null,1,{"$f":"IF(D24>$Q$31,,UPPER(VLOOKUP(D24,'[2]Boys 14 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"LAQUIS"},null,null,null,"1",null,null,null,null,"Last Accepted player"]
["Top DA",null,null,2,{"$f":"IF(D25>$Q$31,,UPPER(VLOOKUP(D25,'[2]Boys 14 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"WEST"},null,null,null,"2"]
["Last DA",null,null,3,{"$f":"IF(D26>$Q$31,,UPPER(VLOOKUP(D26,'[2]Boys 14 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"3",null,null,null,null,"Player representatives"]
[null,null,null,4,{"$f":"IF(D27>$Q$31,,UPPER(VLOOKUP(D27,'[2]Boys 14 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"4"]
["Seed ranking",null,null,null,null,null,null,null,"5"]
["Rkg Date",null,null,null,null,null,null,null,"6",null,null,null,null,"ITF Referee's signature"]
["Top seed",null,null,null,null,null,null,null,"7"]
["Last seed",null,null,null,null,null,null,null,"8",null,null,null,null,{"$f":"Q4","v":"Colleen De Gannes / Edwin Chu For"},null,null,{"$f":"MIN(4,'[2]Boys 14 Si Main Draw Prep'!R5)","v":2}]

{"sheet":"Girls 14 Si Main","index":5,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
[{"$f":"'[2]Week SetUp'!$A$6","v":"Sagicor Junior Tennis Tournament 2015"},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"GIRLS 14 MAIN DRAW SINGLES"]
["Week of",null,null,null,null,"Venue",null,null,null,null,null,"COTECC Supervisor",null,null,null,null,"TUATT Referee"]
[{"$f":"'[2]Week SetUp'!$A$10","v":"5th  - 11th July 2015"},null,null,null,null,{"$f":"'[2]Week SetUp'!$C$10","v":"Eddie Taylor Public Courts, Nelson Mandela Park"},null,null,null,{"$f":"'[2]Week SetUp'!$D$10","v":0},null,{"$f":"'[2]Week SetUp'!$A$12","v":"Anthony Sanchez"},null,null,null,null,{"$f":"'[2]Week SetUp'!$E$10","v":"Colleen De Gannes / Edwin Chu For"}]
[null,"St.","Rank","Seed","Family Name","First name",null,"Nationality",null,"Semifinals",null,"Final",null,"Winner",null,"Winner"]
[]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"KOYLASS"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Victoria"},null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P21","v":"Umpire"}]
[null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(I8=\"a\",I8=\"as\"),E7,IF(OR(I8=\"b\",I8=\"bs\"),E9,)))","v":"KOYLASS"},null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P22","v":" "}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},7,{"$f":"UPPER(IF($D9=\"\",\"\",VLOOKUP($D9,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"MATA BREWER"},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Fabiana"},null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"60 61",null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P23","v":" "}]
[null,null,null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(K10=\"a\",K10=\"as\"),J8,IF(OR(K10=\"b\",K10=\"bs\"),J12,)))","v":"KOYLASS"},null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P24","v":" "}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},4,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"JONES"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Abigail"},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"63 61",null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P25","v":" "}]
[null,null,null,null,null,null,null,"Umpire","A",{"$f":"UPPER(IF(OR(I12=\"a\",I12=\"as\"),E11,IF(OR(I12=\"b\",I12=\"bs\"),E13,)))","v":"JONES"},null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P26","v":" "}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},6,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"SABGA"},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Kimberly"},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"63 61",null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P27","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Umpire","as",{"$f":"UPPER(IF(OR(M14=\"a\",M14=\"as\"),L10,IF(OR(M14=\"b\",M14=\"bs\"),L18,)))","v":"KOYLASS"},null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P28","v":" "}]
[5,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},8,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"HOULLIER"},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Rhyse"},null,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,"64 76(9)",null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P29","v":" "}]
[null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(I16=\"a\",I16=\"as\"),E15,IF(OR(I16=\"b\",I16=\"bs\"),E17,)))","v":"SABGA"},null,null,null,null,null,null,null,null,null,{"$f":"'[2]SetUp Officials'!P30","v":"None"}]
[6,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},3,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"SABGA"},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Vivian"},null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"61 60"]
[null,null,null,null,null,null,null,null,null,"Umpire","BS",{"$f":"UPPER(IF(OR(K18=\"a\",K18=\"as\"),J16,IF(OR(K18=\"b\",K18=\"bs\"),J20,)))","v":"LEE ASSANG"}]
[7,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},5,{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"LEITCH"},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Kelsey"},null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"61 61"]
[null,null,null,null,null,null,null,"Umpire","bs",{"$f":"UPPER(IF(OR(I20=\"a\",I20=\"as\"),E19,IF(OR(I20=\"b\",I20=\"bs\"),E21,)))","v":"LEE ASSANG"}]
[8,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},2,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"LEE ASSANG"},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Yin"},null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[2]Girls 14 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"61 60"]
[]
["Acc. Ranking",null,null,"#","Seeded players",null,null,null,"#","Lucky Losers",null,"Replacing",null,"Draw date/time:",null,"06/07/15 : 11:37pm"]
["Rkg Date",null,null,1,{"$f":"IF(D24>$Q$31,,UPPER(VLOOKUP(D24,'[2]Girls 14 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"KOYLASS"},null,null,null,"1",null,null,null,null,"Last Accepted player"]
["Top DA",null,null,2,{"$f":"IF(D25>$Q$31,,UPPER(VLOOKUP(D25,'[2]Girls 14 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"LEE ASSANG"},null,null,null,"2"]
["Last DA",null,null,3,{"$f":"IF(D26>$Q$31,,UPPER(VLOOKUP(D26,'[2]Girls 14 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"3",null,null,null,null,"Player representatives"]
[null,null,null,4,{"$f":"IF(D27>$Q$31,,UPPER(VLOOKUP(D27,'[2]Girls 14 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"4"]
["Seed ranking",null,null,null,null,null,null,null,"5"]
["Rkg Date",null,null,null,null,null,null,null,"6",null,null,null,null,"ITF Referee's signature"]
["Top seed",null,null,null,null,null,null,null,"7"]
["Last seed",null,null,null,null,null,null,null,"8",null,null,null,null,{"$f":"Q4","v":"Colleen De Gannes / Edwin Chu For"},null,null,{"$f":"MIN(4,'[2]Girls 14 Si Main Draw Prep'!R5)","v":2}]

{"sheet":"Boys 16 Si Main","index":6,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
[{"$f":"'[3]Week SetUp'!$A$6","v":"Sagicor Junior Tennis Tournament 2015"},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"BOYS 16 MAIN DRAW"]
["Week of",null,null,null,null,"Venue",null,null,null,null,null,"Tour. Director",null,null,null,null,"TUATT Referee"]
[{"$f":"'[3]Week SetUp'!$A$10","v":"5th - 11th July 2015"},null,null,null,null,{"$f":"'[3]Week SetUp'!$C$10","v":"Eddie Tayor Public Courts, Nelson Mandela Park"},null,null,null,null,null,{"$f":"'[3]Week SetUp'!$A$12","v":"Anthony Sanchez"},null,null,null,null,{"$f":"'[3]Week SetUp'!$E$10","v":"Colleen De Gannes / Edwin Chu For"}]
[null,"St.","Rank","Seed","Family Name","First name",null,"Nationality",null,"Semifinals",null,"Final",null,"Winner"]
[]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"MCLAUGHLIN-VANLOW"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Kaelan"},null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P21","v":"Umpire"}]
[null,null,null,null,null,null,null,"Umpire","as",{"$f":"UPPER(IF(OR(I8=\"a\",I8=\"as\"),E7,IF(OR(I8=\"b\",I8=\"bs\"),E9,)))","v":"MCLAUGHLIN-VANLOW"},null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P22","v":" "}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},7,{"$f":"UPPER(IF($D9=\"\",\"\",VLOOKUP($D9,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"BYE"},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,3))","v":0},null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P23","v":" "}]
[null,null,null,null,null,null,null,null,null,"Umpire","b",{"$f":"UPPER(IF(OR(K10=\"a\",K10=\"as\"),J8,IF(OR(K10=\"b\",K10=\"bs\"),J12,)))","v":"CARTER"},null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P24","v":" "}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},5,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"THOMPSON"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Shonari"},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"w/o",null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P25","v":" "}]
[null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(I12=\"a\",I12=\"as\"),E11,IF(OR(I12=\"b\",I12=\"bs\"),E13,)))","v":"CARTER"},null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P26","v":" "}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},4,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"CARTER"},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Aidan"},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"62 63",null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P27","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Umpire","b",{"$f":"UPPER(IF(OR(M14=\"a\",M14=\"as\"),L10,IF(OR(M14=\"b\",M14=\"bs\"),L18,)))","v":"ANDREWS"},null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P28","v":" "}]
[5,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},6,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"PARKS"},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Tzar"},null,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,"63 61",null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P29","v":" "}]
[null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(I16=\"a\",I16=\"as\"),E15,IF(OR(I16=\"b\",I16=\"bs\"),E17,)))","v":"ANDREWS"},null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P30","v":"None"}]
[6,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},3,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"ANDREWS"},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Che"},null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"W/O"]
[null,null,null,null,null,null,null,null,null,"Umpire","a",{"$f":"UPPER(IF(OR(K18=\"a\",K18=\"as\"),J16,IF(OR(K18=\"b\",K18=\"bs\"),J20,)))","v":"ANDREWS"}]
[7,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},7,{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"BYE"},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,3))","v":0},null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"64 63"]
[null,null,null,null,null,null,null,"Umpire","bs",{"$f":"UPPER(IF(OR(I20=\"a\",I20=\"as\"),E19,IF(OR(I20=\"b\",I20=\"bs\"),E21,)))","v":"VON WALDAU"}]
[8,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},2,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"VON WALDAU"},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Flynn"},null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[3]Boys 16 Si Main Draw Prep'!$A$7:$P$22,4))","v":0}]
[]
["Acc. Ranking",null,null,"#","Seeded players",null,null,null,"#","Lucky Losers",null,"Replacing",null,"Draw date/time:",null,"07/07/15:4:50pm"]
["Rkg Date",null,null,1,{"$f":"IF(D24>$Q$31,,UPPER(VLOOKUP(D24,'[3]Boys 16 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"MCLAUGHLIN-VANLOW"},null,null,null,"1",null,null,null,null,"Last Accepted player"]
["Top DA",null,null,2,{"$f":"IF(D25>$Q$31,,UPPER(VLOOKUP(D25,'[3]Boys 16 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"VON WALDAU"},null,null,null,"2"]
["Last DA",null,null,3,{"$f":"IF(D26>$Q$31,,UPPER(VLOOKUP(D26,'[3]Boys 16 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"3",null,null,null,null,"Player representatives"]
[null,null,null,4,{"$f":"IF(D27>$Q$31,,UPPER(VLOOKUP(D27,'[3]Boys 16 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"4"]
["Seed ranking",null,null,null,null,null,null,null,"5"]
["Rkg Date",null,null,null,null,null,null,null,"6",null,null,null,null,"ITF Referee's signature"]
["Top seed",null,null,null,null,null,null,null,"7"]
["Last seed",null,null,null,null,null,null,null,"8",null,null,null,null,{"$f":"Q4","v":"Colleen De Gannes / Edwin Chu For"},null,null,{"$f":"MIN(4,'[3]Boys 16 Si Main Draw Prep'!R5)","v":2}]

{"sheet":"Girls Si Main 16","index":7,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
[{"$f":"'[3]Week SetUp'!$A$6","v":"Sagicor Junior Tennis Tournament 2015"},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"GIRLS 16 MAIN DRAW SINGLES"]
["Week of",null,null,null,null,"Venue",null,null,null,null,null,"Tour. Director",null,null,null,null,"TUATT Referee"]
[{"$f":"'[3]Week SetUp'!$A$10","v":"5th - 11th July 2015"},null,null,null,null,{"$f":"'[3]Week SetUp'!$C$10","v":"Eddie Tayor Public Courts, Nelson Mandela Park"},null,null,null,null,null,{"$f":"'[3]Week SetUp'!$A$12","v":"Anthony Sanchez"},null,null,null,null,{"$f":"'[3]Week SetUp'!$E$10","v":"Colleen De Gannes / Edwin Chu For"}]
[null,"St.","Rank","Seed","Family Name","First name",null,"Nationality",null,"Final",null,"Winner"]
[]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,16))","v":0},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,2)))","v":"TOM YEW"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,3))","v":"Jade"},null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P21","v":"Umpire"}]
[null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(I8=\"a\",I8=\"as\"),E7,IF(OR(I8=\"b\",I8=\"bs\"),E9,)))","v":"TOM YEW"},null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P22","v":" "}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,16))","v":0},4,{"$f":"UPPER(IF($D9=\"\",\"\",VLOOKUP($D9,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,2)))","v":"WHITTIER"},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,3))","v":"Aura"},null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"61 61",null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P23","v":" "}]
[null,null,null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(K10=\"a\",K10=\"as\"),J8,IF(OR(K10=\"b\",K10=\"bs\"),J12,)))","v":"TOM YEW"},null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P24","v":" "}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,16))","v":0},3,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,2)))","v":"LANSER"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,3))","v":"Lily"},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"62 63",null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P25","v":" "}]
[null,null,null,null,null,null,null,"Umpire","A",{"$f":"UPPER(IF(OR(I12=\"a\",I12=\"as\"),E11,IF(OR(I12=\"b\",I12=\"bs\"),E13,)))","v":"LANSER"},null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P26","v":" "}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,16))","v":0},2,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,2)))","v":"NWOKOLO"},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,3))","v":"Osenyonye"},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[3]Girls Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"64 64",null,null,null,null,null,null,null,null,null,{"$f":"'[3]SetUp Officials'!P27","v":" "}]
[]
["Acc. Ranking",null,null,"#","Seeded players",null,null,null,"#","Lucky Losers",null,"Replacing",null,"Draw date/time:",null,"07/07/15:4:55pm"]
["Rkg Date",null,null,1,{"$f":"IF(D16>$Q$23,,UPPER(VLOOKUP(D16,'[3]Girls Si Main Draw Prep'!$A$7:$R$134,2)))","v":"TOM YEW"},null,null,null,"1",null,null,null,null,"Last Accepted player"]
["Top DA",null,null,2,{"$f":"IF(D17>$Q$23,,UPPER(VLOOKUP(D17,'[3]Girls Si Main Draw Prep'!$A$7:$R$134,2)))","v":"NWOKOLO"},null,null,null,"2"]
["Last DA",null,null,3,{"$f":"IF(D18>$Q$23,,UPPER(VLOOKUP(D18,'[3]Girls Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"3",null,null,null,null,"Player representatives"]
[null,null,null,4,{"$f":"IF(D19>$Q$23,,UPPER(VLOOKUP(D19,'[3]Girls Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"4"]
["Seed ranking",null,null,null,null,null,null,null,"5"]
["Rkg Date",null,null,null,null,null,null,null,"6",null,null,null,null,"ITF Referee's signature"]
["Top seed",null,null,null,null,null,null,null,"7"]
["Last seed",null,null,null,null,null,null,null,"8",null,null,null,null,{"$f":"Q4","v":"Colleen De Gannes / Edwin Chu For"},null,null,{"$f":"MIN(4,'[3]Girls Si Main Draw Prep'!R5)","v":2}]

{"sheet":"Boys 18 Si Main","index":8,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
[{"$f":"'[4]Week SetUp'!$A$6","v":"Sagicor Junior Tennis Tournament 2015"},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"BOYS 18 MAIN DRAW SINGLES"]
["Week of",null,null,null,null,"Venue",null,null,null,null,null,"Tour. Director",null,null,null,null,"TUATT Referee"]
[{"$f":"'[4]Week SetUp'!$A$10","v":"5th - 11th July 2015"},null,null,null,null,{"$f":"'[4]Week SetUp'!$C$10","v":"Eddie Tayor Public courts"},null,null,null,null,null,{"$f":"'[4]Week SetUp'!$A$12","v":"Anthony Sanchez"},null,null,null,null,{"$f":"'[4]Week SetUp'!$E$10","v":"Colleen De Gannes / Edwin Chu For"}]
[null,"St.","Rank","Seed","Family Name","First name",null,"Nationality",null,"2nd Round",null,"Semifinals",null,"Final",null,"Winner"]
[]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"MOHAMMED"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Nabeel"},null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P21","v":"Umpire"}]
[null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(I8=\"a\",I8=\"as\"),E7,IF(OR(I8=\"b\",I8=\"bs\"),E9,)))","v":"GREGOIRE"},null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P22","v":" "}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},5,{"$f":"UPPER(IF($D9=\"\",\"\",VLOOKUP($D9,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"GREGOIRE"},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Brandon"},null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"16V64 [12 - 10]",null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P23","v":" "}]
[null,null,null,null,null,null,null,null,null,"Umpire","b",{"$f":"UPPER(IF(OR(K10=\"a\",K10=\"as\"),J8,IF(OR(K10=\"b\",K10=\"bs\"),J12,)))","v":"THOMAS"},null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P24","v":" "}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},7,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"ROBINSON"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Gianluc"},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"64 61",null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P25","v":" "}]
[null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(I12=\"a\",I12=\"as\"),E11,IF(OR(I12=\"b\",I12=\"bs\"),E13,)))","v":"THOMAS"},null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P26","v":" "}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},4,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"THOMAS"},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Ryan"},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"46 62 [10 - 6]",null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P27","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(M14=\"a\",M14=\"as\"),L10,IF(OR(M14=\"b\",M14=\"bs\"),L18,)))","v":"HACKSHAW"},null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P28","v":" "}]
[5,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},8,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"SINGH"},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Clint"},null,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,"62 62",null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P29","v":" "}]
[null,null,null,null,null,null,null,"Umpire","B",{"$f":"UPPER(IF(OR(I16=\"a\",I16=\"as\"),E15,IF(OR(I16=\"b\",I16=\"bs\"),E17,)))","v":"HACKSHAW"},null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P30","v":"None"}]
[6,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},3,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"HACKSHAW"},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Scott"},null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"62 60"]
[null,null,null,null,null,null,null,null,null,"Umpire","a",{"$f":"UPPER(IF(OR(K18=\"a\",K18=\"as\"),J16,IF(OR(K18=\"b\",K18=\"bs\"),J20,)))","v":"HACKSHAW"}]
[7,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},6,{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"SCOTT"},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Adam"},null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"63 63"]
[null,null,null,null,null,null,null,"Umpire","BS",{"$f":"UPPER(IF(OR(I20=\"a\",I20=\"as\"),E19,IF(OR(I20=\"b\",I20=\"bs\"),E21,)))","v":"MOONASAR"}]
[8,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},2,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"MOONASAR"},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Keshan"},null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'[4]Boys 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"W/O"]
[]
["Acc. Ranking",null,null,"#","Seeded players",null,null,null,"#","Lucky Losers",null,"Replacing",null,"Draw date/time:",null,"07/07/15:6:07pm"]
["Rkg Date",null,null,1,{"$f":"IF(D24>$Q$31,,UPPER(VLOOKUP(D24,'[4]Boys 18 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"MOHAMMED"},null,null,null,"1",null,null,null,null,"Last Accepted player"]
["Top DA",null,null,2,{"$f":"IF(D25>$Q$31,,UPPER(VLOOKUP(D25,'[4]Boys 18 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"MOONASAR"},null,null,null,"2"]
["Last DA",null,null,3,{"$f":"IF(D26>$Q$31,,UPPER(VLOOKUP(D26,'[4]Boys 18 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"3",null,null,null,null,"Player representatives"]
[null,null,null,4,{"$f":"IF(D27>$Q$31,,UPPER(VLOOKUP(D27,'[4]Boys 18 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"4"]
["Seed ranking",null,null,null,null,null,null,null,"5"]
["Rkg Date",null,null,null,null,null,null,null,"6",null,null,null,null,"ITF Referee's signature"]
["Top seed",null,null,null,null,null,null,null,"7"]
["Last seed",null,null,null,null,null,null,null,"8",null,null,null,null,{"$f":"Q4","v":"Colleen De Gannes / Edwin Chu For"},null,null,{"$f":"MIN(4,'[4]Boys 18 Si Main Draw Prep'!R5)","v":2}]

{"sheet":"Girls 18 Si Main","index":9,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
[{"$f":"'[4]Week SetUp'!$A$6","v":"Sagicor Junior Tennis Tournament 2015"},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"GIRLS 18 SINGLES MAIN DRAW"]
["Week of",null,null,null,null,"Venue",null,null,null,null,null,"Tour. Director",null,null,null,null,"TUATT Referee"]
[{"$f":"'[4]Week SetUp'!$A$10","v":"5th - 11th July 2015"},null,null,null,null,{"$f":"'[4]Week SetUp'!$C$10","v":"Eddie Tayor Public courts"},null,null,null,null,null,{"$f":"'[4]Week SetUp'!$A$12","v":"Anthony Sanchez"},null,null,null,null,{"$f":"'[4]Week SetUp'!$E$10","v":"Colleen De Gannes / Edwin Chu For"}]
[null,"St.","Rank","Seed","Family Name","First name",null,"Nationality",null,"Final",null,"Winner"]
[]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"TRESTRAIL"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Emma-Rose"},null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P21","v":"Umpire"}]
[null,null,null,null,null,null,null,"Umpire","AS",{"$f":"UPPER(IF(OR(I8=\"a\",I8=\"as\"),E7,IF(OR(I8=\"b\",I8=\"bs\"),E9,)))","v":"TRESTRAIL"},null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P22","v":" "}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},4,{"$f":"UPPER(IF($D9=\"\",\"\",VLOOKUP($D9,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"FITZWILLIAM"},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Salina"},null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"60 61",null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P23","v":" "}]
[null,null,null,null,null,null,null,null,null,"Umpire","bs",{"$f":"UPPER(IF(OR(K10=\"a\",K10=\"as\"),J8,IF(OR(K10=\"b\",K10=\"bs\"),J12,)))","v":"DAVIS"},null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P24","v":" "}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},3,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"KING"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Anya"},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,null,null,"57 63 {10-6}",null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P25","v":" "}]
[null,null,null,null,null,null,null,"Umpire","BS",{"$f":"UPPER(IF(OR(I12=\"a\",I12=\"as\"),E11,IF(OR(I12=\"b\",I12=\"bs\"),E13,)))","v":"DAVIS"},null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P26","v":" "}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,15))","v":0},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,16))","v":0},2,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,2)))","v":"DAVIS"},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,3))","v":"Emma"},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'[4]Girls 18 Si Main Draw Prep'!$A$7:$P$22,4))","v":0},null,"76(1) 75",null,null,null,null,null,null,null,null,null,{"$f":"'[4]SetUp Officials'!P27","v":" "}]
[]
["Acc. Ranking",null,null,"#","Seeded players",null,null,null,"#","Lucky Losers",null,"Replacing",null,"Draw date/time:",null,"07/07/15:6:03pm"]
["Rkg Date",null,null,1,{"$f":"IF(D16>$Q$23,,UPPER(VLOOKUP(D16,'[4]Girls 18 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"TRESTRAIL"},null,null,null,"1",null,null,null,null,"Last Accepted player"]
["Top DA",null,null,2,{"$f":"IF(D17>$Q$23,,UPPER(VLOOKUP(D17,'[4]Girls 18 Si Main Draw Prep'!$A$7:$R$134,2)))","v":"DAVIS"},null,null,null,"2"]
["Last DA",null,null,3,{"$f":"IF(D18>$Q$23,,UPPER(VLOOKUP(D18,'[4]Girls 18 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"3",null,null,null,null,"Player representatives"]
[null,null,null,4,{"$f":"IF(D19>$Q$23,,UPPER(VLOOKUP(D19,'[4]Girls 18 Si Main Draw Prep'!$A$7:$R$134,2)))","v":0},null,null,null,"4"]
["Seed ranking",null,null,null,null,null,null,null,"5"]
["Rkg Date",null,null,null,null,null,null,null,"6",null,null,null,null,"ITF Referee's signature"]
["Top seed",null,null,null,null,null,null,null,"7"]
["Last seed",null,null,null,null,null,null,null,"8",null,null,null,null,{"$f":"Q4","v":"Colleen De Gannes / Edwin Chu For"},null,null,{"$f":"MIN(4,'[4]Girls 18 Si Main Draw Prep'!R5)","v":2}]