{"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"]
[21384,"Pune",null,"Pune ITF",1,"2018-12-10","IND",1,28,null,"live.itftennis.com/en/live-scores/?","USD25K",32,3,3,32,2,3]

{"sheet":"Qualifying Draw","index":1,"n_rows":25,"n_cols":34,"rows_kept":25,"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"]
[213841101,2,21384,1,768,1,null,55352,"Nigina ABDURAIMOVA",null,null,null,51338,"Emily WEBLEY-SMITH",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841102,2,21384,1,768,null,"WC",63455,"Tejasvi KATE",null,10,null,52352,"Ksenia PALKINA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841103,2,21384,1,768,2,null,54752,"Alexandrina NAYDENOVA",null,null,null,63159,"Ya-Hsin LEE",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841104,2,21384,1,768,null,null,58791,"Riya BHATIA",null,15,null,57187,"Jessica HO",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841105,2,21384,1,768,3,null,51445,"Fatma AL-NABHANI",null,null,null,50299,"Ana VESELINOVIC",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841106,2,21384,1,768,null,null,50078,"Albina KHABIBULINA",null,12,null,55088,"Julie GERVAIS",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841107,2,21384,1,768,4,null,60856,"Maryna CHERNYSHOVA",null,null,null,55512,"Sowjanya BAVISETTI",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841108,2,21384,1,768,null,"WC",63464,"Sharannya GAWARE",null,13,null,53029,"Melanie KLAFFNER",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841109,2,21384,1,768,5,null,58000,"Anastasia NEFEDOVA",null,null,null,59517,"Mallaurie NOEL",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841110,2,21384,1,768,null,null,61245,"YeXin MA",null,14,null,50875,"Chieh Yu HSU",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841111,2,21384,1,768,6,null,57772,"Ayla AKSU",null,null,null,57101,"Pei-Chi LEE",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841112,2,21384,1,768,null,"WC",61041,"Ishita PARIKH",null,11,null,59158,"Gozal AINITDINOVA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841113,2,21384,1,768,7,null,59297,"Pia CUK",null,null,"WC",62696,"Sai Dedeepya YEDDULA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841114,2,21384,1,768,null,null,50628,"Beatrice GUMULYA",null,9,null,54875,"Anna MORGINA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841115,2,21384,1,768,8,null,53553,"Paula GONCALVES",null,null,"WC",59680,"Jennifer LUIKHAM",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841116,2,21384,1,768,null,"WC",57140,"Natasha PALHA",null,16,null,58931,"Maria MARFUTINA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213841201,0,21384,1,256,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213841202,0,21384,1,256,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213841203,0,21384,1,256,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213841204,0,21384,1,256,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213841205,0,21384,1,256,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213841206,0,21384,1,256,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213841207,0,21384,1,256,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213841208,0,21384,1,256,null,null,54691,"TBA",null,null,null,54691,"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":32,"n_cols":34,"rows_kept":32,"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"]
[213844101,2,21384,1,32,1,null,51922,"Jia-Jing LU",null,null,"q",57101,"Pei-Chi LEE",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844102,2,21384,1,32,null,"q",53553,"Paula GONCALVES",null,null,"WC",61134,"Mahak JAIN",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844103,2,21384,1,32,null,null,51215,"Ekaterina YASHINA",null,null,null,57420,"Polina LEYKINA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844104,2,21384,1,32,null,"WC",60360,"Snehal MANE",null,5,null,52072,"Junri NAMIGATA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844105,2,21384,1,32,4,null,55523,"Diana MARCINKEVICA",null,null,"q",55352,"Nigina ABDURAIMOVA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844106,2,21384,1,32,null,null,59034,"Jaqueline Adina CRISTIAN",null,null,"q",50628,"Beatrice GUMULYA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844107,2,21384,1,32,null,null,58586,"Mariam BOLKVADZE",null,null,null,59297,"Pia CUK",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844108,2,21384,1,32,null,"WC",61742,"Zeel DESAI",null,6,null,57517,"Valeriya STRAKHOVA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844109,2,21384,1,32,7,null,52165,"Katarzyna PITER",null,null,null,57187,"Jessica HO",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844110,2,21384,1,32,null,"q",50875,"Chieh Yu HSU",null,null,null,53394,"Nika KUKHARCHUK",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844111,2,21384,1,32,null,null,59316,"Amina ANSHBA",null,null,null,55088,"Julie GERVAIS",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844112,2,21384,1,32,null,"q",51445,"Fatma AL-NABHANI",null,3,null,52164,"Katarzyna KAWA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844113,2,21384,1,32,8,null,59357,"Tessah ANDRIANJAFITRIMO",null,null,null,55408,"Valeria SAVINYKH",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844114,2,21384,1,32,null,"q",60856,"Maryna CHERNYSHOVA",null,null,"q",54752,"Alexandrina NAYDENOVA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844115,2,21384,1,32,null,null,52882,"Marina MELNIKOVA",null,null,"WC",58787,"Bhuvana KALVA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844116,2,21384,1,32,null,null,59758,"Berfu CENGIZ",null,2,null,56896,"Deniz KHAZANIUK",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[213844201,0,21384,1,16,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844202,0,21384,1,16,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844203,0,21384,1,16,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844204,0,21384,1,16,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844205,0,21384,1,16,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844206,0,21384,1,16,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844207,0,21384,1,16,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844208,0,21384,1,16,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844301,0,21384,1,4,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844302,0,21384,1,4,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844303,0,21384,1,4,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844304,0,21384,1,4,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844401,0,21384,1,2,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844402,0,21384,1,2,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[213844501,0,21384,1,1,null,null,54691,"TBA",null,null,null,54691,"TBA",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"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","M'balia Bangoura",null,0]
[null,"e.g. Roger Federer"]
[]
["Add New Female Player","Sharannya Gaware",null,63464]
[null,"e.g. Serena Williams"]
[]
["Get Exact Male Player","John-Patrick Smith",null,9534]
["Get Exact Female Player","Ema BURGIC ",null,51308]

{"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"]
[63464,"Sharannya Gaware","Sharannya","Gaware","Gaware","GAW",1,"IND"]

{"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"]