{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Tournament","Qualifying Draw","Main Draw","Import TA Scores","TOOLS","New Players","NOTES","Changelog"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Tournament","index":0,"n_rows":2,"n_cols":19,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Tournament_ID","Tournament_Location","Tournament_Name","Tournament_Family","Gender","Tournament_Date","Tournament_Country_ID","Tournament_Surface_ID","Tournament_Tour_ID","Tournament_URL","Stats_URL","Tournament_Prizemoney","Main_Draw_Size","MD_Set","MD_Final_Set","QD_Size","QD_Rounds","QD_Sets","ExternalCode"]
[20889,"Miami",null,"Miami TMS",0,"2018-03-19","USA",1,3,"www.miamiopen.com/","www.protennislive.com/LSHD/main.html?year=2018&wkno=99&eventid=&tour=&lang=en&ref=http%3A//www.atpworldtour.com/","USD7.98M",128,3,3,48,2,3,403]

{"sheet":"Qualifying Draw","index":1,"n_rows":37,"n_cols":34,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Match_ID","Status","Tournament_ID ","Gender      ","Rnd_ID         ","Winner_Seed_1       ","Winner_Seed_2       ","Winner_ID      ","Winner_Name","Winner_Rank","Loser_Seed_1          ","Loser_Seed_2            ","Loser_ID      ","Loser_Name","Loser_Rank","Sets_Best_of     ","Set_1_A","Set_1_B","Set_1_TB","Set_2_A","Set_2_B","Set_2_TB","Set_3_A","Set_3_B","Set_3_TB","Set_4_A","Set_4_B","Set_4_TB","Set_5_A","Set_5_B","Set_5_TB","Anoms","Result Status","Processed"]
[208891101,2,20889,0,768,1,null,11885,"Roberto Carballes Baena",null,null,null,10652,"Darian King",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891102,2,20889,0,768,null,null,15396,"Felix Auger Aliassime",null,24,null,13475,"Mackenzie Mcdonald",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891103,2,20889,0,768,2,null,7826,"Mirza Basic",null,null,null,11924,"Dennis Novikov",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891104,2,20889,0,768,null,null,14721,"Michael Mmoh",null,22,null,12320,"Ramkumar Ramanathan",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891105,2,20889,0,768,3,null,8629,"John Millman",null,null,null,15693,"Casper Ruud",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891106,2,20889,0,768,null,null,10413,"Gleb Sakharov",null,13,null,13448,"Ernesto Escobedo",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891107,2,20889,0,768,4,null,756,"Rogerio Dutra Silva",null,null,null,12462,"Kevin King",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891108,2,20889,0,768,null,null,14572,"Reilly Opelka",null,21,null,1717,"Peter Polansky",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891109,2,20889,0,768,5,null,7937,"Gastao Elias",null,null,null,9943,"Denis Kudla",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891110,2,20889,0,768,null,null,12959,"Calvin Hemery",null,15,null,10406,"Yannick Hanfmann",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891111,2,20889,0,768,6,null,7986,"Ricardas Berankis",null,null,null,10799,"Norbert Gombos",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891112,2,20889,0,768,null,"Alt",8990,"Evan King",null,14,null,335,"Sergiy Stakhovsky",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891113,2,20889,0,768,7,null,15283,"Matteo Berrettini",null,null,null,11691,"Filip Peliwo",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891114,2,20889,0,768,null,null,10784,"Liam Broady",null,17,null,9485,"Henri Laaksonen",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891115,2,20889,0,768,8,null,11765,"Taro Daniel",null,null,null,10876,"Bradley Klahn",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891116,2,20889,0,768,null,"WC",12261,"Thanasi Kokkinakis",null,16,null,11416,"Thiago Monteiro",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891117,2,20889,0,768,9,null,9184,"Yuki Bhambri",null,null,null,11143,"Renzo Olivo",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891118,2,20889,0,768,null,null,715,"Santiago Giraldo",null,19,"WC",13515,"Elias Ymer",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891119,2,20889,0,768,10,null,13696,"Cameron Norrie",null,null,null,13296,"Stefan Kozlov",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891120,2,20889,0,768,null,"WC",15939,"Patrick Kypson",null,18,null,1221,"Tim Smyczek",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891121,2,20889,0,768,11,null,11528,"Bjorn Fratangelo",null,null,null,14818,"Tommy Paul",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891122,2,20889,0,768,null,null,14383,"Akira Santillan",null,20,null,209,"Carlos Berlocq",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891123,2,20889,0,768,12,null,8483,"Ruben Bemelmans",null,null,"WC",6585,"Joao Souza",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891124,2,20889,0,768,null,"WC",15966,"Axel Geller",null,23,null,15690,"Alex De Minaur",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[208891201,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891202,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891203,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891204,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891205,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891206,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891207,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891208,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891209,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891210,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891211,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[208891212,0,20889,0,256,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Main Draw","index":2,"n_rows":128,"n_cols":34,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
["Match_ID",8,"Tournament_ID ","Gender      ","Rnd_ID         ","Winner_Seed_1       ","Winner_Seed_2       ","Winner_ID      ","Winner_Name","Winner_Rank","Loser_Seed_1          ","Loser_Seed_2            ","Loser_ID      ","Loser_Name","Loser_Rank","Sets_Best_of     ","Set_1_A","Set_1_B","Set_1_TB","Set_2_A","Set_2_B","Set_2_TB","Set_3_A","Set_3_B","Set_3_TB","Set_4_A","Set_4_B","Set_4_TB","Set_5_A","Set_5_B","Set_5_TB","Anoms","Result Status","Processed"]
[208894101,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894102,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894103,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894104,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894105,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894106,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894107,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894108,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894109,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894110,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894111,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894112,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894113,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894114,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894115,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894116,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894117,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894118,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894119,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894120,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894121,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894122,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894123,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894124,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894125,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894126,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894127,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894128,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894129,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894130,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894131,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894132,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894133,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894134,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894135,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894136,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894137,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894138,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894139,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894140,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894141,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894142,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894143,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894144,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894145,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894146,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894147,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894148,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894149,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894150,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894151,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894152,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894153,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894154,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894155,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894156,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894157,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894158,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894159,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894160,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894161,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894162,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894163,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894164,2,20889,0,128,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894201,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894202,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894203,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894204,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894205,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894206,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894207,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894208,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894209,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894210,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894211,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894212,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894213,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894214,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894215,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894216,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894217,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894218,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894219,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894220,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894221,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894222,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894223,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894224,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894225,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894226,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894227,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894228,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894229,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894230,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894231,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894232,0,20889,0,64,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894301,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894302,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894303,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894304,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894305,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894306,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894307,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894308,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894309,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894310,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894311,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894312,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894313,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894314,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894315,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894316,0,20889,0,32,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894401,0,20889,0,16,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894402,0,20889,0,16,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894403,0,20889,0,16,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894404,0,20889,0,16,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894405,0,20889,0,16,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894406,0,20889,0,16,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894407,0,20889,0,16,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894408,0,20889,0,16,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894501,0,20889,0,4,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894502,0,20889,0,4,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894503,0,20889,0,4,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894504,0,20889,0,4,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894601,0,20889,0,2,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894602,0,20889,0,2,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]
[208894701,0,20889,0,1,null,null,8649,"TBA",null,null,null,8649,"TBA",null,3]

{"sheet":"Import TA Scores","index":3,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Q1: (1)Henrique Cunha (BRA) bye"]
["Q1: (WC)Angel Peredo (MEX) d. (WC)Gabriel Alvarez Rodriguez (MEX) 60 62"]
["Q1: Antonio Ruiz Rosales (MEX) d. (WC)Jorge Enrique Gonzalez Aramburu (MEX) 62 63"]
["Q1: (6)Jorge Brian Panta Herreros (PER) bye"]
["Q1: (2)Kevin King (USA) bye"]
["Q1: Mauricio Astorga (MEX) d. Alejandro Mendoza (BOL) 60 75"]
["Q1: Alan Nunez Aguilera (MEX) d. Kevin Jack Carpenter (MEX) 64 46 76(3)"]
["Q1: (5)Ivan Endara (ECU) bye"]
["Q1: (3)Christopher Diaz Figueroa (GUA) bye"]
["Q1: Farzin Danny Amiri (USA) d. (WC)Mario Azael Gutierrez 61 63"]
["Q1: Dean Obrien (RSA) d. Pavel Krainik (CAN) 36 75 63"]
["Q1: (8)Luis Patino (MEX) d. (WC)Salvador Guerrero Gonzalez (MEX) 63 62"]
["Q1: (4)Mauricio Echazu (PER) bye"]
["Q1: Alberto Rojas Maldonado (MEX) d. Raul Isaias Rosas Zarur (MEX) 61 26 63"]
["Q1: Andres Alvarez Cerdan (MEX) d. Ivar Jose Aramburu Contreras (MEX) 62 62"]
["Q1: (7)Luis David Martinez (VEN) d. (WC)Luis Alfonso Pineda Chavez 62 64"]

{"sheet":"TOOLS","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Tools"]
[]
[]
[]
[]
[null,"INPUT",null,"RESULT"]
["Add New Male Player","Miomir Kecmanovic",null,16041]
[null,"e.g. Roger Federer"]
[]
["Add New Female Player","Lucie Kankova",null,60452]
[null,"e.g. Serena Williams"]
[]
["Get Exact Male Player","Alexander Ovcharov",null,15531]
["Get Exact Female Player","Serena Williams",null,53934]

{"sheet":"New Players","index":5,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Player ID","Player Name","First Name","Last Name","Name_Abbrev_1","Name_Abbrev_2","Gender","Country","ATP Code"]
[15638,"Miomir Kecmanovic","Miomir","Kecmanovic","Kecmanovic","KEC",0,"SRB"]

{"sheet":"NOTES","index":6,"n_rows":318,"n_cols":2,"rows_kept":318,"cut":false,"hidden":false,"merged":[]}
["2015/04/27 Version 1.3"]
["New Players"]
["~~~~~~~"]
["1. After identifying new players during the QD process, and getting an new ID from Tools tab, enter the ID and Full Player name here"]
["2. Click the 'Explode Names' macro."]
["3. Enter Gender as 0 for men, 1 for women."]
["4. Manually enter their country as 3 letter ISO code as in tournament notes below."]
["5. If male get ATP Code by searching for player at http://www.atpworldtour.com/en/players"]
["6. Export and and check the output file before uploading as type 'Players'"]
[]
["Import TA Scores"]
["~~~~~~~"]
["1. Copy the completed match lines from tennisabstract.com for the tournament"]
["2. Paste as values into 'Import TA Scores' tab"]
["3. Click the smiley!"]
[]
[]
[]
["QUALIFYING & MAIN DRAWS"]
["~~~~~~~"]
[]
["1. Ensure Tournament tab is filled out first, and then use Generate Qualifying Draw or Generate Main Draw macros."]
["2. Check QD/MD fields generated correctly, including Gender and Round IDs"]
["3. Enter known draw information, specfically Winner/Loser Seed columns, and Winner/Loser Name columns"]
["4. Click 'Populate Known Player IDs' button. This will fetch exact matches only and return 0 for non-exact matches"]
["5. Go to tennisinsight.com/player-matching/ and use Advanced option and search every Player Name that returned 0"]
["6. If there is an alias ID found for that player, enter it into the QD/MD field. "]
["7. If there is no match or alias (Google quickly in case the player got married or something), i.e. it's a new player -- then go to Tools tab and use 'Get New Male/Female Player ID' macro to get a new unique ID."]
[]
["Status = 2 for matches for at least one player that is TBA (not bye), or 0 for matches with both TBA. By default the generator outputs the first round of qd/md as 2, and the rest 0. Remember to change to 2 if players are straight through to 2nd round."]
[]
["Gender === 0 for male or  1 for women"]
[]
["Rnd_ID === number of players in that round for main draw OR 768, 512, 256 for Qualifying rounds - For MD must be 32, 64, 128, round up to one of these if draw size not divisible by 32 (i.e. draw of 56 becomes 64)"]
[]
["Winner_Seed_1 / Loser_Seed_1  === Player's seed or LL for lucky loser (or blank)"]
[]
["Winner_Seed_2 / Loser_Seed_2  === WC for wildcard,  q for Qualifier,  Alt for an alternate player (or blank)"]
[]
["Winner_ID / Loser_ID === Use macros as above"]
["Winner_Name / Loser_Name === Enter the names before using macros above"]
["Winner_Rank / Loser_Rank === Not required, but you can enter the rank if new ranks are out but not up on TI yet."]
[]
["Sets_Best_Of === 3 except for Mens Slams and Davis Cup (and Olympics?)"]
[]
[]
[]
["TOURNAMENTS"]
["~~~~~~~~~~~"]
["1. Enter known Tournament fields as per below instructions first."]
["2. Go to Tools and use the 'Get Tournament_ID' macro. It will return you either the known ID number, or give you a new one."]
["3. Enter known draw information, specfically Winner/Loser Seed columns, and Winner/Loser Name columns"]
["4. Click 'Populate Known Player IDs' button. This will fetch exact matches only and return 0 for non-exact matches"]
["5. Go to tennisinsight.com/player-matching/ and use Advanced option and search every Player Name that returned 0"]
["6. If there is an alias ID found for that player, enter it into the QD/MD field. "]
["7. If there is no match or alias (Google quickly in case the player got married or something), i.e. it's a new player -- then go to Tools tab and use 'Get New Male/Female Player ID' macro to get a new unique ID."]
[]
["Tourament_ID - Enter all other fields first, then see step 2 above."]
[]
["Tourament_Location === the City the Tournament is held in e.g. Miami"]
[]
["Tourament_Name === the full name ( optional )"]
[]
["Tourament_Family === City + Tour abbreviation e.g. Acapulco ATP"]
[]
["Gender === 0 for Mens or  1 Womens "]
[]
["Tournament_Date === format as 2015-02-23"]
[]
["Tournament_Country_ID === 3 letter country code (see Country codes below)"]
[]
["Tournament_Surface_ID ===  (select number from below)"]
[1,"Hard"]
[2,"Indoor Hard"]
[3,"Carpet"]
[10,"Clay"]
[20,"Grass"]
[]
[]
["Tournament_Tour_ID === (select number from below)"]
[1,"Grand Slam"]
[2,"World Tour Finals"]
[3,"ATP Masters 1000"]
[4,"ATP"]
[5,"Challenger"]
[6,"ATP Exhibition"]
[7,"Olympics"]
[8,"Davis Cup"]
[15,"WTA Slam"]
[20,"WTA Champs"]
[25,"WTA Challenger"]
[26,"WTA Premier"]
[27,"WTA International"]
[28,"ITF"]
[29,"WTA Exhibition"]
[30,"Fed Cup"]
[40,"Olympics"]
[]
[]
["Tournament_Draw_Size === number of players in the Main Draw"]
[]
["ExternalCode === get from atp or wta website (code is number in url of link to indiv tourny)"]
["http://www.atpworldtour.com/en/tournaments"]
["http://www.wtatennis.com/tournaments"]
[]
["Fields not mentioned here are not required in order to export the Tournament for upload."]
["However, in order to Generate QD or MD, you'll need to populate MD_Set, MD_Final_Set, QD_Size, QD_Rounds, QD_Sets"]
[]
["Country codes"]
["Country_Full_Name","Country_Short_Name"]
["Afghanistan","AFG"]
["Albania","ALB"]
["Algeria","ALG"]
["American Samoa","ASA"]
["Andorra","AND"]
["Angola","ANG"]
["Antigua and Barbuda","ANT"]
["Argentina","ARG"]
["Armenia","ARM"]
["Aruba","ARU"]
["Australia","AUS"]
["Austria","AUT"]
["Azerbaijan","AZE"]
["Bahamas","BAH"]
["Bahrain","BRN"]
["Bangladesh","BAN"]
["Barbados","BAR"]
["Belarus","BLR"]
["Belgium","BEL"]
["Belize","BIZ"]
["Benin","BEN"]
["Bermuda","BER"]
["Bhutan","BHU"]
["Bolivia","BOL"]
["Bosnia and Herzegovina","BIH"]
["Botswana","BOT"]
["Brazil","BRA"]
["British Virgin Islands","IVB"]
["Brunei","BRU"]
["Bulgaria","BUL"]
["Burkina Faso","BUR"]
["Burundi","BDI"]
["Cambodia","CAM"]
["Cameroon","CMR"]
["Canada","CAN"]
["Cape Verde","CPV"]
["Cayman Islands","CAY"]
["Central African Republic","CAF"]
["Chad","CHA"]
["Chile","CHI"]
["China","CHN"]
["Chinese Taipei","TPE"]
["Colombia","COL"]
["Comoros","COM"]
["Cook Islands","COK"]
["Costa Rica","CRC"]
["Cote d'Ivoire","CIV"]
["Croatia","CRO"]
["Cuba","CUB"]
["Cyprus","CYP"]
["Czech Republic","CZE"]
["Democratic Republic of the Congo","COD"]
["Denmark","DEN"]
["Djibouti","DJI"]
["Dominica","DMA"]
["Dominican Republic","DOM"]
["Ecuador","ECU"]
["Egypt","EGY"]
["El Salvador","ESA"]
["Equatorial Guinea","GEQ"]
["Eritrea","ERI"]
["Estonia","EST"]
["Ethiopia","ETH"]
["Federated States of Micronesia","FSM"]
["Fiji","FIJ"]
["Finland","FIN"]
["France","FRA"]
["Gabon","GAB"]
["Georgia","GEO"]
["Germany","GER"]
["Ghana","GHA"]
["Great Britain","GBR"]
["Greece","GRE"]
["Grenada","GRN"]
["Guam","GUM"]
["Guatemala","GUA"]
["Guinea","GUI"]
["Guinea-Bissau","GBS"]
["Guyana","GUY"]
["Haiti","HAI"]
["Honduras","HON"]
["Hong Kong","HKG"]
["Hungary","HUN"]
["Iceland","ISL"]
["India","IND"]
["Indonesia","INA"]
["Iran","IRI"]
["Iraq","IRQ"]
["Ireland","IRL"]
["Israel","ISR"]
["Italy","ITA"]
["Jamaica","JAM"]
["Japan","JPN"]
["Jordan","JOR"]
["Kazakhstan","KAZ"]
["Kenya","KEN"]
["Kuwait","KUW"]
["Kyrgyzstan","KGZ"]
["Laos","LAO"]
["Latvia","LAT"]
["Lebanon","LIB"]
["Lesotho","LES"]
["Liberia","LBR"]
["Libya","LBA"]
["Liechtenstein","LIE"]
["Lithuania","LTU"]
["Luxembourg","LUX"]
["Macedonia","MKD"]
["Madagascar","MAD"]
["Malawi","MAW"]
["Malaysia","MAS"]
["Maldives","MDV"]
["Mali","MLI"]
["Malta","MLT"]
["Mauritania","MTN"]
["Mauritius","MRI"]
["Mexico","MEX"]
["Moldova","MDA"]
["Monaco","MON"]
["Mongolia","MGL"]
["Morocco","MAR"]
["Mozambique","MOZ"]
["Myanmar","MYA"]
["Namibia","NAM"]
["Nauru","NRU"]
["Nepal","NEP"]
["Netherlands","NED"]
["Netherlands Antilles","AHO"]
["New Caledonia","NCL"]
["New Zealand","NZL"]
["Nicaragua","NCA"]
["Niger","NIG"]
["Nigeria","NGR"]
["North Korea","PRK"]
["Norway","NOR"]
["Oman","OMA"]
["Pakistan","PAK"]
["Palau","PLW"]
["Palestine","PLE"]
["Panama","PAN"]
["Papua New Guinea","PNG"]
["Paraguay","PAR"]
["Peru","PER"]
["Philippines","PHI"]
["Poland","POL"]
["Portugal","POR"]
["Puerto Rico","PUR"]
["Qatar","QAT"]
["Republic of the Congo","CGO"]
["Romania","ROU"]
["Russia","RUS"]
["Rwanda","RWA"]
["Saint Kitts and Nevis","SKN"]
["Saint Lucia","LCA"]
["Saint Vincent and the Grenadines","VIN"]
["Samoa","SAM"]
["San Marino","SMR"]
["Sao Tome and Principe","STP"]
["Saudi Arabia","KSA"]
["Scotland","SCO"]
["Senegal","SEN"]
["Serbia-Montenegro","SCG"]
["Seychelles","SEY"]
["Sierra Leone","SLE"]
["Singapore","SIN"]
["Slovakia","SVK"]
["Slovenia","SLO"]
["Solomon Islands","SOL"]
["Somalia","SOM"]
["South Africa","RSA"]
["South Korea","KOR"]
["Spain","ESP"]
["Sri Lanka","SRI"]
["Sudan","SUD"]
["Suriname","SUR"]
["Swaziland","SWZ"]
["Sweden","SWE"]
["Switzerland","SUI"]
["Syria","SYR"]
["Taiwan","TRE"]
["Tajikistan","TJK"]
["Tanzania","TAN"]
["Thailand","THA"]
["The Gambia","GAM"]
["Togo","TOG"]
["Tonga","TGA"]
["Trinidad and Tobago","TRI"]
["Tunisia","TUN"]
["Turkey","TUR"]
["Turkmenistan","TKM"]
["Uganda","UGA"]
["Ukraine","UKR"]
["United Arab Emirates","UAE"]
["United States","USA"]
["Uruguay","URU"]
["Uzbekistan","UZB"]
["Vanuatu","VAN"]
["Venezuela","VEN"]
["Vietnam","VIE"]
["Virgin Islands","ISV"]
["Yemen","YEM"]
["Yugoslavia","YUG"]
["Zambia","ZAM"]
["Zimbabwe","ZIM"]
["Pacific Oceania","POC"]
["Serbia","SRB"]
["Montenegro","MNE"]
["Cambodia","KHM"]

{"sheet":"Changelog","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Version","Date","Changes"]
["2015-04-17",1]
["2015-04-18",1.1000000000000001,"Fixed WTA populating players macro"]
[null,null,"Added Status column, default to 2 for first round only, 0 for others"]
[null,null,"Documentations updated"]
[]
["2015-04-24",1.2,"New players tab with ability to export New_Player.txt for upload"]
[null,null,"Scores functionality implemented"]
["2015-06-18",1.5,"Added External Codes for Tournaments and Players"]