{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Maestra","Firmas clasificaciòn","Prep. Clasificacion S","Clasificación","Firmas Principal","Prep. Principal S","Round Robin","Principal RR","Principal Sen.","Listado D","Prep. Principal D","Principal D"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":14,"comments":4,"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":"Maestra","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,2],[17,4,17,5],[17,7,17,8],[9,0,9,2],[9,4,9,5],[9,7,9,8],[13,0,13,2],[13,4,13,5],[13,7,13,8]]}
[null,null,"HOJA MAESTRA"]
[]
["ESTA HOJA LLENA EL ENCABEZAMIENTO DE TODAS LAS OTRAS, NO LA BORRE NI LA ELIMINE"]
["EN TODO ESTE ARCHIVO, ESCRIBA SOLO EN LAS AREAS GRISES"]
["CUANDO LLENE LAS AREAS GRISES DE ESTA HOJA, GUARDE COMO (Nombre que quiera darle) "]
["Y CONTINUE CON SU TRABAJO EN LAS OTRAS HOJAS."]
[]
["TORNEO",null,null,null,"CLASE",null,null,"CATEGORIA"]
[]
["COPA CLUB EL RODEO",null,null,null,"GRADO 2",null,null,"18 MASCULINO"]
[]
["SEDE",null,null,null,"CIUDAD",null,null,"FECHA"]
[]
["CLUB EL RODEO",null,null,null,"MEDELLIN",null,null,"MAYO 7 AL 11"]
[]
["SUPERVISOR FCT",null,null,null,"SUPERFICIE"]
[]
["ESTEBAN JIMENEZ",null,null,null,"CLAY"]

{"sheet":"Firmas clasificaciòn","index":1,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"PLANILLA DE FIRMAS CUADRO DE CLASIFICACION",null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[]
["Torneo",null,null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"},"Clase",{"$f":"Maestra!E10","v":"GRADO 2"},"Categoría",null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[]
["Sede",null,null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"},"Ciudad",{"$f":"Maestra!E14","v":"MEDELLIN"},"Fecha",null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[]
["Supervisor FCT",null,null,{"$f":"Maestra!A18","v":"ESTEBAN JIMENEZ"}]
[]
["Línea","Codigo","Apellido y Nombre","Liga","Fecha de Nacimiento D/M/A","Rank. Entrada","Status","Rank. Actual","FIRMA",null,"Teléfono para contacto","Estado"]
[1,"FCT01810",{"$f":"UPPER(IF($B11=\"\",\"\",VLOOKUP($B11,[1]Codigos!$A$5:$F$9000,2)))","v":"TOLEDO PABLO A"},{"$f":"UPPER(IF($B11=\"\",\"\",VLOOKUP($B11,[1]Codigos!$A$5:$F$9000,3)))","v":"BOG"},{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,[1]Codigos!$A$5:$F$9000,4))","v":"1998-03-09"},null,null,147,null,null,null,{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[2,"FCT01698",{"$f":"UPPER(IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,2)))","v":"PEREZ ANDRES F"},{"$f":"UPPER(IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,3)))","v":"VAL"},{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,4))","v":"1997-12-08"},99,"DA",57,null,null,null,{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[3,"FCT01324",{"$f":"UPPER(IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,2)))","v":"VILLABONA LUIS M"},{"$f":"UPPER(IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,3)))","v":"MET"},{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,4))","v":"1997-07-13"},110,"DA",96,null,null,null,{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[4,"FCT01481",{"$f":"UPPER(IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,2)))","v":"RIOS DILAN M"},{"$f":"UPPER(IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,3)))","v":"CUN"},{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,4))","v":"1997-04-04"},120,"DA",119,null,null,null,{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[5,"FCT03161",{"$f":"UPPER(IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,2)))","v":"QUINTANA JUAN C"},{"$f":"UPPER(IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,3)))","v":"CUN"},{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,4))","v":"1998-01-07"},null,null,139,null,null,null,{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,6))","v":"NO PUEDE JUGAR"}]
[6,"FCT02791",{"$f":"UPPER(IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,2)))","v":"ESTRADA SEBASTIAN "},{"$f":"UPPER(IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,3)))","v":"RIS"},{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,4))","v":"1997-09-20"},149,"DA",150,null,null,null,{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[7,"FCT00801",{"$f":"UPPER(IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,2)))","v":"DUQUE JUAN A"},{"$f":"UPPER(IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,3)))","v":"RIS"},{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,4))","v":"1997-11-29"},null,null,999,null,null,null,{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[8,"FCT00439",{"$f":"UPPER(IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,2)))","v":"TORO PABLO A"},{"$f":"UPPER(IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,3)))","v":"ANT"},{"$f":"IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,4))","v":"1998-09-06"},null,"DA",999,null,null,null,{"$f":"IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[9,"FCT00410",{"$f":"UPPER(IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,2)))","v":"BIGOTT CRISTIAN"},{"$f":"UPPER(IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,3)))","v":"BOG"},{"$f":"IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,4))","v":"1998-09-30"},null,"DA",999,null,null,null,{"$f":"IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[10,"FCT00815",{"$f":"UPPER(IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,2)))","v":"GONZALEZ DAVID"},{"$f":"UPPER(IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,3)))","v":"RIS"},{"$f":"IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,4))","v":"1997-02-10"},null,"DA",23,null,null,null,{"$f":"IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[11,null,{"$f":"UPPER(IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"DA",9999,null,null,null,{"$f":"IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[12,null,{"$f":"UPPER(IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"DA",9999,null,null,null,{"$f":"IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[13,null,{"$f":"UPPER(IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"DA",9999,null,null,null,{"$f":"IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[14,null,{"$f":"UPPER(IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"DA",9999,null,null,null,{"$f":"IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[15,null,{"$f":"UPPER(IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",9999,null,null,null,{"$f":"IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[16,null,{"$f":"UPPER(IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",9999,null,null,null,{"$f":"IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[17,null,{"$f":"UPPER(IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[18,null,{"$f":"UPPER(IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[19,null,{"$f":"UPPER(IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[20,null,{"$f":"UPPER(IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[21,null,{"$f":"UPPER(IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[22,null,{"$f":"UPPER(IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[23,null,{"$f":"UPPER(IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[24,null,{"$f":"UPPER(IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[25,null,{"$f":"UPPER(IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[26,null,{"$f":"UPPER(IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[27,null,{"$f":"UPPER(IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[28,null,{"$f":"UPPER(IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[29,null,{"$f":"UPPER(IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[30,null,{"$f":"UPPER(IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,6))","v":""}]

{"sheet":"Prep. Clasificacion S","index":2,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"LISTA DE PREPARACION"]
[null,null,null,null,"CUADRO CLASIFICACION SENCILLOS"]
[]
["Torneo",null,null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"},"Clase",{"$f":"Maestra!E10","v":"GRADO 2"},"Categoría",null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[]
["Sede",null,null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"},"Ciudad",{"$f":"Maestra!E14","v":"MEDELLIN"},"Fecha",null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[]
["Supervisor FCT",null,null,{"$f":"Maestra!A18","v":"ESTEBAN JIMENEZ"}]
[]
["Línea",null,"Apellido y Nombre","Liga","Fecha de Nacimiento D/M/A","Rank. Entrada","Status","Rank. Actual"]
[1,{"$f":"'Firmas clasificaciòn'!B20","v":"FCT00815"},{"$f":"'Firmas clasificaciòn'!C20","v":"GONZALEZ DAVID"},{"$f":"'Firmas clasificaciòn'!D20","v":"RIS"},{"$f":"'Firmas clasificaciòn'!E20","v":"1997-02-10"},{"$f":"'Firmas clasificaciòn'!F20","v":0},{"$f":"'Firmas clasificaciòn'!G20","v":"DA"},{"$f":"'Firmas clasificaciòn'!H20","v":23}]
[2,{"$f":"'Firmas clasificaciòn'!B12","v":"FCT01698"},{"$f":"'Firmas clasificaciòn'!C12","v":"PEREZ ANDRES F"},{"$f":"'Firmas clasificaciòn'!D12","v":"VAL"},{"$f":"'Firmas clasificaciòn'!E12","v":"1997-12-08"},{"$f":"'Firmas clasificaciòn'!F12","v":99},{"$f":"'Firmas clasificaciòn'!G12","v":"DA"},{"$f":"'Firmas clasificaciòn'!H12","v":57}]
[3,{"$f":"'Firmas clasificaciòn'!B13","v":"FCT01324"},{"$f":"'Firmas clasificaciòn'!C13","v":"VILLABONA LUIS M"},{"$f":"'Firmas clasificaciòn'!D13","v":"MET"},{"$f":"'Firmas clasificaciòn'!E13","v":"1997-07-13"},{"$f":"'Firmas clasificaciòn'!F13","v":110},{"$f":"'Firmas clasificaciòn'!G13","v":"DA"},{"$f":"'Firmas clasificaciòn'!H13","v":96}]
[4,{"$f":"'Firmas clasificaciòn'!B14","v":"FCT01481"},{"$f":"'Firmas clasificaciòn'!C14","v":"RIOS DILAN M"},{"$f":"'Firmas clasificaciòn'!D14","v":"CUN"},{"$f":"'Firmas clasificaciòn'!E14","v":"1997-04-04"},{"$f":"'Firmas clasificaciòn'!F14","v":120},{"$f":"'Firmas clasificaciòn'!G14","v":"DA"},{"$f":"'Firmas clasificaciòn'!H14","v":119}]
[5,{"$f":"'Firmas clasificaciòn'!B15","v":"FCT03161"},{"$f":"'Firmas clasificaciòn'!C15","v":"QUINTANA JUAN C"},{"$f":"'Firmas clasificaciòn'!D15","v":"CUN"},{"$f":"'Firmas clasificaciòn'!E15","v":"1998-01-07"},{"$f":"'Firmas clasificaciòn'!F15","v":0},{"$f":"'Firmas clasificaciòn'!G15","v":0},{"$f":"'Firmas clasificaciòn'!H15","v":139}]
[6,{"$f":"'Firmas clasificaciòn'!B11","v":"FCT01810"},{"$f":"'Firmas clasificaciòn'!C11","v":"TOLEDO PABLO A"},{"$f":"'Firmas clasificaciòn'!D11","v":"BOG"},{"$f":"'Firmas clasificaciòn'!E11","v":"1998-03-09"},{"$f":"'Firmas clasificaciòn'!F11","v":0},{"$f":"'Firmas clasificaciòn'!G11","v":0},{"$f":"'Firmas clasificaciòn'!H11","v":147}]
[7,{"$f":"'Firmas clasificaciòn'!B16","v":"FCT02791"},{"$f":"'Firmas clasificaciòn'!C16","v":"ESTRADA SEBASTIAN "},{"$f":"'Firmas clasificaciòn'!D16","v":"RIS"},{"$f":"'Firmas clasificaciòn'!E16","v":"1997-09-20"},{"$f":"'Firmas clasificaciòn'!F16","v":149},{"$f":"'Firmas clasificaciòn'!G16","v":"DA"},{"$f":"'Firmas clasificaciòn'!H16","v":150}]
[8,{"$f":"'Firmas clasificaciòn'!B19","v":"FCT00410"},{"$f":"'Firmas clasificaciòn'!C19","v":"BIGOTT CRISTIAN"},{"$f":"'Firmas clasificaciòn'!D19","v":"BOG"},{"$f":"'Firmas clasificaciòn'!E19","v":"1998-09-30"},{"$f":"'Firmas clasificaciòn'!F19","v":0},{"$f":"'Firmas clasificaciòn'!G19","v":"DA"},{"$f":"'Firmas clasificaciòn'!H19","v":999}]
[9,{"$f":"'Firmas clasificaciòn'!B17","v":"FCT00801"},{"$f":"'Firmas clasificaciòn'!C17","v":"DUQUE JUAN A"},{"$f":"'Firmas clasificaciòn'!D17","v":"RIS"},{"$f":"'Firmas clasificaciòn'!E17","v":"1997-11-29"},{"$f":"'Firmas clasificaciòn'!F17","v":0},{"$f":"'Firmas clasificaciòn'!G17","v":0},{"$f":"'Firmas clasificaciòn'!H17","v":999}]
[10,{"$f":"'Firmas clasificaciòn'!B18","v":"FCT00439"},{"$f":"'Firmas clasificaciòn'!C18","v":"TORO PABLO A"},{"$f":"'Firmas clasificaciòn'!D18","v":"ANT"},{"$f":"'Firmas clasificaciòn'!E18","v":"1998-09-06"},{"$f":"'Firmas clasificaciòn'!F18","v":0},{"$f":"'Firmas clasificaciòn'!G18","v":"DA"},{"$f":"'Firmas clasificaciòn'!H18","v":999}]
[11,{"$f":"'Firmas clasificaciòn'!B21","v":0},{"$f":"'Firmas clasificaciòn'!C21","v":""},{"$f":"'Firmas clasificaciòn'!D21","v":""},{"$f":"'Firmas clasificaciòn'!E21","v":""},{"$f":"'Firmas clasificaciòn'!F21","v":0},{"$f":"'Firmas clasificaciòn'!G21","v":"DA"},{"$f":"'Firmas clasificaciòn'!H21","v":9999}]
[12,{"$f":"'Firmas clasificaciòn'!B22","v":0},{"$f":"'Firmas clasificaciòn'!C22","v":""},{"$f":"'Firmas clasificaciòn'!D22","v":""},{"$f":"'Firmas clasificaciòn'!E22","v":""},{"$f":"'Firmas clasificaciòn'!F22","v":0},{"$f":"'Firmas clasificaciòn'!G22","v":"DA"},{"$f":"'Firmas clasificaciòn'!H22","v":9999}]
[13,{"$f":"'Firmas clasificaciòn'!B23","v":0},{"$f":"'Firmas clasificaciòn'!C23","v":""},{"$f":"'Firmas clasificaciòn'!D23","v":""},{"$f":"'Firmas clasificaciòn'!E23","v":""},{"$f":"'Firmas clasificaciòn'!F23","v":0},{"$f":"'Firmas clasificaciòn'!G23","v":"DA"},{"$f":"'Firmas clasificaciòn'!H23","v":9999}]
[14,{"$f":"'Firmas clasificaciòn'!B24","v":0},{"$f":"'Firmas clasificaciòn'!C24","v":""},{"$f":"'Firmas clasificaciòn'!D24","v":""},{"$f":"'Firmas clasificaciòn'!E24","v":""},{"$f":"'Firmas clasificaciòn'!F24","v":0},{"$f":"'Firmas clasificaciòn'!G24","v":"DA"},{"$f":"'Firmas clasificaciòn'!H24","v":9999}]
[15,null,{"$f":"UPPER(IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$5000,2)))","v":""},{"$f":"UPPER(IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$5000,3)))","v":""},{"$f":"IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$5000,4))","v":""},null,"WC"]
[16,null,{"$f":"UPPER(IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$5000,2)))","v":""},{"$f":"UPPER(IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$5000,3)))","v":""},{"$f":"IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$5000,4))","v":""},null,"WC"]

{"sheet":"Clasificación","index":3,"n_rows":79,"n_cols":18,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SENC. CLASIFICACION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Categoria",null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Torneo",null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ciudad",null,{"$f":"Maestra!E14","v":"MEDELLIN"}]
[{"$f":"Maestra!E10","v":"GRADO 2"},null,null,null,null,null,null,null,null,null,null,null,null,"Fecha",null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sede",null,{"$f":"Maestra!A15","v":0}]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":23},{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"DA"},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'Prep. Clasificacion S'!A$11:K$110,3)))","v":"GONZALEZ DAVID"},null,null,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":"RIS"},null,null,null,null,null,"Sede",null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"}]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I8=\"a\",E7,IF(I8=\"b\",E9,\"\"))","v":"GONZALEZ DAVID"},null,null,null,{"$f":"IF(I8=\"a\",H7,IF(I8=\"b\",H9,\"\"))","v":"RIS"}]
[2,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"a",{"$f":"IF(K10=\"a\",J8,IF(K10=\"b\",J12,\"\"))","v":"GONZALEZ DAVID"},null,null,{"$f":"IF(K10=\"a\",N8,IF(K10=\"b\",N12,\"\"))","v":"RIS"}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,"B",{"$f":"IF(I12=\"a\",E11,IF(I12=\"b\",E13,\"\"))","v":""},null,null,null,{"$f":"IF(I12=\"a\",H11,IF(I12=\"b\",H13,\"\"))","v":""}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":0},{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"WC"},16,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Clasificacion S'!A$11:K$110,3)))","v":""},null,null,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"B",{"$f":"IF(M14=\"a\",L10,IF(M14=\"b\",L18,\"\"))","v":"BIGOTT CRISTIAN"},{"$f":"IF(M14=\"a\",O10,IF(M14=\"b\",O18,\"\"))","v":"BOG"}]
[5,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":999},{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"DA"},8,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'Prep. Clasificacion S'!A$11:K$110,3)))","v":"BIGOTT CRISTIAN"},null,null,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":"BOG"},null,null,null,null,null,"46 75 10-6",null,null,"Clasificado","Clasificado"]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I16=\"a\",E15,IF(I16=\"b\",E17,\"\"))","v":"BIGOTT CRISTIAN"},null,null,null,{"$f":"IF(I16=\"a\",H15,IF(I16=\"b\",H17,\"\"))","v":"BOG"}]
[6,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(K18=\"a\",J16,IF(K18=\"b\",J20,\"\"))","v":"BIGOTT CRISTIAN"},null,null,{"$f":"IF(K18=\"a\",N16,IF(K18=\"b\",N20,\"\"))","v":"BOG"}]
[7,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""},null,null,null,"62 61"]
[null,null,{"$f":"IF($D20=\"\",\"\",VLOOKUP($D20,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,null,null,null,null,"B",{"$f":"IF(I20=\"a\",E19,IF(I20=\"b\",E21,\"\"))","v":"QUINTANA JUAN C"},null,null,null,{"$f":"IF(I20=\"a\",H19,IF(I20=\"b\",H21,\"\"))","v":"CUN"}]
[8,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":139},{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"0"},5,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'Prep. Clasificacion S'!A$11:K$110,3)))","v":"QUINTANA JUAN C"},null,null,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":"CUN"}]
[]
[9,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":57},{"$f":"UPPER(IF($D23=\"\",\"\",VLOOKUP($D23,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"DA"},2,{"$f":"UPPER(IF($D23=\"\",\"\",VLOOKUP($D23,'Prep. Clasificacion S'!A$11:K$110,3)))","v":"PEREZ ANDRES F"},null,null,{"$f":"UPPER(IF($D23=\"\",\"\",VLOOKUP($D23,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":"VAL"}]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I24=\"a\",E23,IF(I24=\"b\",E25,\"\"))","v":"PEREZ ANDRES F"},null,null,null,{"$f":"IF(I24=\"a\",H23,IF(I24=\"b\",H25,\"\"))","v":"VAL"}]
[10,{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"a",{"$f":"IF(K26=\"a\",J24,IF(K26=\"b\",J28,\"\"))","v":"PEREZ ANDRES F"},null,null,{"$f":"IF(K26=\"a\",N24,IF(K26=\"b\",N28,\"\"))","v":"VAL"}]
[11,{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,"B",{"$f":"IF(I28=\"a\",E27,IF(I28=\"b\",E29,\"\"))","v":""},null,null,null,{"$f":"IF(I28=\"a\",H27,IF(I28=\"b\",H29,\"\"))","v":""}]
[12,{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":0},{"$f":"UPPER(IF($D29=\"\",\"\",VLOOKUP($D29,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"WC"},16,{"$f":"UPPER(IF($D29=\"\",\"\",VLOOKUP($D29,'Prep. Clasificacion S'!A$11:K$110,3)))","v":""},null,null,{"$f":"UPPER(IF($D29=\"\",\"\",VLOOKUP($D29,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"B",{"$f":"IF(M30=\"a\",L26,IF(M30=\"b\",L34,\"\"))","v":"DUQUE JUAN A"},{"$f":"IF(M30=\"a\",O26,IF(M30=\"b\",O34,\"\"))","v":"RIS"}]
[13,{"$f":"IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":999},{"$f":"UPPER(IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"DA"},10,{"$f":"UPPER(IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Clasificacion S'!A$11:K$110,3)))","v":"TORO PABLO A"},null,null,{"$f":"UPPER(IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":"ANT"},null,null,null,null,null,"75 64",null,null,"Clasificado","Clasificado"]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I32=\"a\",E31,IF(I32=\"b\",E33,\"\"))","v":"TORO PABLO A"},null,null,null,{"$f":"IF(I32=\"a\",H31,IF(I32=\"b\",H33,\"\"))","v":"ANT"}]
[14,{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"B",{"$f":"IF(K34=\"a\",J32,IF(K34=\"b\",J36,\"\"))","v":"DUQUE JUAN A"},null,null,{"$f":"IF(K34=\"a\",N32,IF(K34=\"b\",N36,\"\"))","v":"RIS"}]
[15,{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""},null,null,null,"75 64"]
[null,null,null,null,null,null,null,null,"B",{"$f":"IF(I36=\"a\",E35,IF(I36=\"b\",E37,\"\"))","v":"DUQUE JUAN A"},null,null,null,{"$f":"IF(I36=\"a\",H35,IF(I36=\"b\",H37,\"\"))","v":"RIS"}]
[16,{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":999},{"$f":"UPPER(IF($D37=\"\",\"\",VLOOKUP($D37,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"0"},9,{"$f":"UPPER(IF($D37=\"\",\"\",VLOOKUP($D37,'Prep. Clasificacion S'!A$11:K$110,3)))","v":"DUQUE JUAN A"},null,null,{"$f":"UPPER(IF($D37=\"\",\"\",VLOOKUP($D37,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":"RIS"}]
[]
[17,{"$f":"IF($D39=\"\",\"\",VLOOKUP($D39,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":96},{"$f":"UPPER(IF($D39=\"\",\"\",VLOOKUP($D39,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"DA"},3,{"$f":"UPPER(IF($D39=\"\",\"\",VLOOKUP($D39,'Prep. Clasificacion S'!A$11:K$110,3)))","v":"VILLABONA LUIS M"},null,null,{"$f":"UPPER(IF($D39=\"\",\"\",VLOOKUP($D39,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":"MET"}]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I40=\"a\",E39,IF(I40=\"b\",E41,\"\"))","v":"VILLABONA LUIS M"},null,null,null,{"$f":"IF(I40=\"a\",H39,IF(I40=\"b\",H41,\"\"))","v":"MET"}]
[18,{"$f":"IF($D41=\"\",\"\",VLOOKUP($D41,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D41=\"\",\"\",VLOOKUP($D41,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D41=\"\",\"\",VLOOKUP($D41,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"a",{"$f":"IF(K42=\"a\",J40,IF(K42=\"b\",J44,\"\"))","v":"VILLABONA LUIS M"},null,null,{"$f":"IF(K42=\"a\",N40,IF(K42=\"b\",N44,\"\"))","v":"MET"}]
[19,{"$f":"IF($D43=\"\",\"\",VLOOKUP($D43,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D43=\"\",\"\",VLOOKUP($D43,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D43=\"\",\"\",VLOOKUP($D43,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,"B",{"$f":"IF(I44=\"a\",E43,IF(I44=\"b\",E45,\"\"))","v":""},null,null,null,{"$f":"IF(I44=\"a\",H43,IF(I44=\"b\",H45,\"\"))","v":""}]
[20,{"$f":"IF($D45=\"\",\"\",VLOOKUP($D45,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":0},{"$f":"UPPER(IF($D45=\"\",\"\",VLOOKUP($D45,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"WC"},16,{"$f":"UPPER(IF($D45=\"\",\"\",VLOOKUP($D45,'Prep. Clasificacion S'!A$11:K$110,3)))","v":""},null,null,{"$f":"UPPER(IF($D45=\"\",\"\",VLOOKUP($D45,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"B",{"$f":"IF(M46=\"a\",L42,IF(M46=\"b\",L50,\"\"))","v":"TOLEDO PABLO A"},{"$f":"IF(M46=\"a\",O42,IF(M46=\"b\",O50,\"\"))","v":"BOG"}]
[21,{"$f":"IF($D47=\"\",\"\",VLOOKUP($D47,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":0},{"$f":"UPPER(IF($D47=\"\",\"\",VLOOKUP($D47,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"WC"},16,{"$f":"UPPER(IF($D47=\"\",\"\",VLOOKUP($D47,'Prep. Clasificacion S'!A$11:K$110,3)))","v":""},null,null,{"$f":"UPPER(IF($D47=\"\",\"\",VLOOKUP($D47,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":""},null,null,null,null,null,"61 26 10-7",null,null,"Clasificado"]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I48=\"a\",E47,IF(I48=\"b\",E49,\"\"))","v":""},null,null,null,{"$f":"IF(I48=\"a\",H47,IF(I48=\"b\",H49,\"\"))","v":""}]
[22,{"$f":"IF($D49=\"\",\"\",VLOOKUP($D49,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D49=\"\",\"\",VLOOKUP($D49,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D49=\"\",\"\",VLOOKUP($D49,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"b",{"$f":"IF(K50=\"a\",J48,IF(K50=\"b\",J52,\"\"))","v":"TOLEDO PABLO A"},null,null,{"$f":"IF(K50=\"a\",N48,IF(K50=\"b\",N52,\"\"))","v":"BOG"}]
[23,{"$f":"IF($D51=\"\",\"\",VLOOKUP($D51,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D51=\"\",\"\",VLOOKUP($D51,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D51=\"\",\"\",VLOOKUP($D51,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,"B",{"$f":"IF(I52=\"a\",E51,IF(I52=\"b\",E53,\"\"))","v":"TOLEDO PABLO A"},null,null,null,{"$f":"IF(I52=\"a\",H51,IF(I52=\"b\",H53,\"\"))","v":"BOG"}]
[24,{"$f":"IF($D53=\"\",\"\",VLOOKUP($D53,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":147},{"$f":"UPPER(IF($D53=\"\",\"\",VLOOKUP($D53,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"0"},6,{"$f":"UPPER(IF($D53=\"\",\"\",VLOOKUP($D53,'Prep. Clasificacion S'!A$11:K$110,3)))","v":"TOLEDO PABLO A"},null,null,{"$f":"UPPER(IF($D53=\"\",\"\",VLOOKUP($D53,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":"BOG"}]
[]
[25,{"$f":"IF($D55=\"\",\"\",VLOOKUP($D55,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":119},{"$f":"UPPER(IF($D55=\"\",\"\",VLOOKUP($D55,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"DA"},4,{"$f":"UPPER(IF($D55=\"\",\"\",VLOOKUP($D55,'Prep. Clasificacion S'!A$11:K$110,3)))","v":"RIOS DILAN M"},null,null,{"$f":"UPPER(IF($D55=\"\",\"\",VLOOKUP($D55,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":"CUN"}]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I56=\"a\",E55,IF(I56=\"b\",E57,\"\"))","v":"RIOS DILAN M"},null,null,null,{"$f":"IF(I56=\"a\",H55,IF(I56=\"b\",H57,\"\"))","v":"CUN"}]
[26,{"$f":"IF($D57=\"\",\"\",VLOOKUP($D57,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D57=\"\",\"\",VLOOKUP($D57,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D57=\"\",\"\",VLOOKUP($D57,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"a",{"$f":"IF(K58=\"a\",J56,IF(K58=\"b\",J60,\"\"))","v":"RIOS DILAN M"},null,null,{"$f":"IF(K58=\"a\",N56,IF(K58=\"b\",N60,\"\"))","v":"CUN"}]
[27,{"$f":"IF($D59=\"\",\"\",VLOOKUP($D59,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D59=\"\",\"\",VLOOKUP($D59,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D59=\"\",\"\",VLOOKUP($D59,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,"B",{"$f":"IF(I60=\"a\",E59,IF(I60=\"b\",E61,\"\"))","v":""},null,null,null,{"$f":"IF(I60=\"a\",H59,IF(I60=\"b\",H61,\"\"))","v":""}]
[28,{"$f":"IF($D61=\"\",\"\",VLOOKUP($D61,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":0},{"$f":"UPPER(IF($D61=\"\",\"\",VLOOKUP($D61,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"WC"},16,{"$f":"UPPER(IF($D61=\"\",\"\",VLOOKUP($D61,'Prep. Clasificacion S'!A$11:K$110,3)))","v":""},null,null,{"$f":"UPPER(IF($D61=\"\",\"\",VLOOKUP($D61,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"IF(M62=\"a\",L58,IF(M62=\"b\",L66,\"\"))","v":"RIOS DILAN M"},{"$f":"IF(M62=\"a\",O58,IF(M62=\"b\",O66,\"\"))","v":"CUN"}]
[29,{"$f":"IF($D63=\"\",\"\",VLOOKUP($D63,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":0},{"$f":"UPPER(IF($D63=\"\",\"\",VLOOKUP($D63,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"WC"},16,{"$f":"UPPER(IF($D63=\"\",\"\",VLOOKUP($D63,'Prep. Clasificacion S'!A$11:K$110,3)))","v":""},null,null,{"$f":"UPPER(IF($D63=\"\",\"\",VLOOKUP($D63,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":""},null,null,null,null,null,"63 64",null,null,"Clasificado"]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I64=\"a\",E63,IF(I64=\"b\",E65,\"\"))","v":""},null,null,null,{"$f":"IF(I64=\"a\",H63,IF(I64=\"b\",H65,\"\"))","v":""}]
[30,{"$f":"IF($D65=\"\",\"\",VLOOKUP($D65,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D65=\"\",\"\",VLOOKUP($D65,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D65=\"\",\"\",VLOOKUP($D65,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"b",{"$f":"IF(K66=\"a\",J64,IF(K66=\"b\",J68,\"\"))","v":"ESTRADA SEBASTIAN "},null,null,{"$f":"IF(K66=\"a\",N64,IF(K66=\"b\",N68,\"\"))","v":"RIS"}]
[31,{"$f":"IF($D67=\"\",\"\",VLOOKUP($D67,'Firmas clasificaciòn'!$A$11:$K$40,8))","v":""},{"$f":"IF($D67=\"\",\"\",VLOOKUP($D67,'Firmas clasificaciòn'!$A$11:$K$40,7))","v":""},null,"BYE",null,null,{"$f":"IF($D67=\"\",\"\",VLOOKUP($D67,'Firmas clasificaciòn'!$A$11:$K$40,4))","v":""}]
[null,null,null,null,null,null,null,null,"B",{"$f":"IF(I68=\"a\",E67,IF(I68=\"b\",E69,\"\"))","v":"ESTRADA SEBASTIAN "},null,null,null,{"$f":"IF(I68=\"a\",H67,IF(I68=\"b\",H69,\"\"))","v":"RIS"}]
[32,{"$f":"IF($D69=\"\",\"\",VLOOKUP($D69,'Prep. Clasificacion S'!$A$11:$K$100,8))","v":150},{"$f":"UPPER(IF($D69=\"\",\"\",VLOOKUP($D69,'Prep. Clasificacion S'!$A$11:$K$100,7)))","v":"DA"},7,{"$f":"UPPER(IF($D69=\"\",\"\",VLOOKUP($D69,'Prep. Clasificacion S'!A$11:K$110,3)))","v":"ESTRADA SEBASTIAN "},null,null,{"$f":"UPPER(IF($D69=\"\",\"\",VLOOKUP($D69,'Prep. Clasificacion S'!$A$11:$K$100,4)))","v":"RIS"}]
[]
[null,"Siembras",null,null,null,null,"Puntuaciôn"]
[1,{"$f":"IF(D7=1,E7,\"\")","v":"GONZALEZ DAVID"},null,null,null,1,"Clasificado",null,null,12]
[2,{"$f":"IF(D23=2,E23,\"\")","v":"PEREZ ANDRES F"},null,null,null,2,"2da Ronda",null,null,6]
[3,{"$f":"IF(D23=3,E23,IF(D39=3,E39,\"\"))","v":"VILLABONA LUIS M"},null,null,null,3,"1ra Ronda",null,null,1]
[4,{"$f":"IF(D23=4,E23,IF(D55=4,E55,\"\"))","v":"RIOS DILAN M"},null,null,null,4]
[5,null,null,null,null,5,null,null,null,null,"Supervisor FCT"]
[6,null,null,null,null,6]
[7,null,null,null,null,7,null,null,null,null,{"$f":"Maestra!A18","v":"ESTEBAN JIMENEZ"}]
[8,null,null,null,null,8]

{"sheet":"Firmas Principal","index":4,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"PLANILLA DE FIRMAS CUADRO PRINCIPAL",null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[]
["Torneo",null,null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"},"Clase",{"$f":"Maestra!E10","v":"GRADO 2"},"Categoría",null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[]
["Sede",null,null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"},"Ciudad",{"$f":"Maestra!E14","v":"MEDELLIN"},"Fecha",null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[]
["Supervisor FCT",null,null,{"$f":"Maestra!A18","v":"ESTEBAN JIMENEZ"}]
[]
["Línea","Codigo","Apellido y Nombre","Liga","Fecha de Nacimiento D/M/A","Rank. Entrada","Status","Rank. Actual","FIRMA",null,"Teléfono para contacto","Estado"]
[1,"FCT00474",{"$f":"UPPER(IF($B11=\"\",\"\",VLOOKUP($B11,[1]Codigos!$A$5:$F$9000,2)))","v":"MONCADA ALEJANDRO"},{"$f":"UPPER(IF($B11=\"\",\"\",VLOOKUP($B11,[1]Codigos!$A$5:$F$9000,3)))","v":"ANT"},{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,[1]Codigos!$A$5:$F$9000,4))","v":"1997-08-22"},3,"DA",1,null,null,null,{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[2,"FCT00453",{"$f":"UPPER(IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,2)))","v":"MONTOYA MANUEL"},{"$f":"UPPER(IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,3)))","v":"ANT"},{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,4))","v":"1997-10-28"},10,"DA",12,null,null,null,{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[3,"FCT00280",{"$f":"UPPER(IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,2)))","v":"SANTAMARIA FELIPE"},{"$f":"UPPER(IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,3)))","v":"ANT"},{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,4))","v":"1996-07-01"},11,"DA",14,null,null,null,{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[4,"FCT00348",{"$f":"UPPER(IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,2)))","v":"ROLDAN TOMAS"},{"$f":"UPPER(IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,3)))","v":"ANT"},{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,4))","v":"1997-10-14"},12,"DA",3,null,null,null,{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[5,"FCT01373",{"$f":"UPPER(IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,2)))","v":"BOTERO MIGUEL A."},{"$f":"UPPER(IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,3)))","v":"RIS"},{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,4))","v":"1996-07-09"},14,"DA",18,null,null,null,{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[6,"FCT00850",{"$f":"UPPER(IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,2)))","v":"RODRIGUEZ JORGE D"},{"$f":"UPPER(IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,3)))","v":"CUN"},{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,4))","v":"1997-11-24"},15,"DA",15,null,null,null,{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[7,"FCT01757",{"$f":"UPPER(IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,2)))","v":"MONCAYO CAMILO A"},{"$f":"UPPER(IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,3)))","v":"NAR"},{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,4))","v":"1997-10-10"},17,"DA",11,null,null,null,{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[8,"FCT00542",{"$f":"UPPER(IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,2)))","v":"MENDIETA FEDERICO"},{"$f":"UPPER(IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,3)))","v":"SAN"},{"$f":"IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,4))","v":"1997-08-25"},18,"DA",16,null,null,null,{"$f":"IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[9,"FCT01211",{"$f":"UPPER(IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,2)))","v":"GROSSO CRISTIAN R"},{"$f":"UPPER(IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,3)))","v":"MET"},{"$f":"IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,4))","v":"1997-03-24"},27,"DA",32,null,null,null,{"$f":"IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[10,"FCT01096",{"$f":"UPPER(IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,2)))","v":"ECHAVARRIA RODRIGO"},{"$f":"UPPER(IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,3)))","v":"BOG"},{"$f":"IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,4))","v":"1996-12-10"},35,"DA",43,null,null,null,{"$f":"IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[11,"FCT00337",{"$f":"UPPER(IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,2)))","v":"NARANJO JUAN N"},{"$f":"UPPER(IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,3)))","v":"BOG"},{"$f":"IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,4))","v":"1996-12-22"},40,"DA",48,null,null,null,{"$f":"IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[12,"FCT01396",{"$f":"UPPER(IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,2)))","v":"PINTO ALEJANDRO"},{"$f":"UPPER(IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,3)))","v":"CUN"},{"$f":"IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,4))","v":"1996-07-18"},44,"DA",19,null,null,null,{"$f":"IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[13,"FCT00913",{"$f":"UPPER(IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,2)))","v":"JARAMILLO JUAN J"},{"$f":"UPPER(IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,3)))","v":"ANT"},{"$f":"IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,4))","v":"1997-04-09"},46,"DA",60,null,null,null,{"$f":"IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[14,"FCT01931",{"$f":"UPPER(IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,2)))","v":"MEJIA SANTIAGO"},{"$f":"UPPER(IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,3)))","v":"ANT"},{"$f":"IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,4))","v":"1996-08-17"},52,"DA",61,null,null,null,{"$f":"IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[15,"FCT01602",{"$f":"UPPER(IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,2)))","v":"COLMENARES DANIEL"},{"$f":"UPPER(IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,3)))","v":"CUN"},{"$f":"IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,4))","v":"1997-01-14"},56,"DA",42,null,null,null,{"$f":"IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,6))","v":"NO PUEDE JUGAR"}]
[16,null,{"$f":"UPPER(IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"LL",9999,null,null,null,{"$f":"IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[17,"FCT01413",{"$f":"UPPER(IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,2)))","v":"PRADA JUAN D"},{"$f":"UPPER(IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,3)))","v":"CUN"},{"$f":"IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,4))","v":"1996-03-12"},"WC","WC",22,null,null,null,{"$f":"IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[18,"FCT00727",{"$f":"UPPER(IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,2)))","v":"CUCALON PAOLO"},{"$f":"UPPER(IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,3)))","v":"VAL"},{"$f":"IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,4))","v":"1998-03-20"},"WC","WC",87,null,null,null,{"$f":"IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[19,"FCT00710",{"$f":"UPPER(IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,2)))","v":"CORZO PABLO A"},{"$f":"UPPER(IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,3)))","v":"ANT"},{"$f":"IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,4))","v":"1996-10-18"},"WC","WC",67,null,null,null,{"$f":"IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[20,"FCT03937",{"$f":"UPPER(IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,2)))","v":"MARIN A SANTIAGO "},{"$f":"UPPER(IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,3)))","v":"ANT"},{"$f":"IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,4))","v":"1997-05-07"},"WC","WC",119,null,null,null,{"$f":"IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,6))","v":"OK"}]
[21,null,{"$f":"UPPER(IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[22,null,{"$f":"UPPER(IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[23,null,{"$f":"UPPER(IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[24,null,{"$f":"UPPER(IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[25,null,{"$f":"UPPER(IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[26,null,{"$f":"UPPER(IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[27,null,{"$f":"UPPER(IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[28,null,{"$f":"UPPER(IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[29,null,{"$f":"UPPER(IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,6))","v":""}]
[30,null,{"$f":"UPPER(IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,4))","v":""},null,"ALT",null,null,null,null,{"$f":"IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,6))","v":""}]

{"sheet":"Prep. Principal S","index":5,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"LISTA DE PREPARACION"]
[null,null,null,null,"CUADRO PRINCIPAL SENCILLOS"]
[]
["Torneo",null,null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"},"Clase",{"$f":"Maestra!E10","v":"GRADO 2"},"Categoría",null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[]
["Sede",null,null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"},"Ciudad",{"$f":"Maestra!E14","v":"MEDELLIN"},"Fecha",null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[]
["Supervisor FCT",null,null,{"$f":"Maestra!A18","v":"ESTEBAN JIMENEZ"}]
[]
["Línea","Còdigo","Apellido y Nombre","Liga","Fecha de Nacimiento D/M/A","Rank. Entrada","Status","Rank. Actual"]
[1,{"$f":"'Firmas Principal'!B11","v":"FCT00474"},{"$f":"'Firmas Principal'!C11","v":"MONCADA ALEJANDRO"},{"$f":"'Firmas Principal'!D11","v":"ANT"},{"$f":"'Firmas Principal'!E11","v":"1997-08-22"},{"$f":"'Firmas Principal'!F11","v":3},{"$f":"'Firmas Principal'!G11","v":"DA"},{"$f":"'Firmas Principal'!H11","v":1}]
[2,{"$f":"'Firmas Principal'!B14","v":"FCT00348"},{"$f":"'Firmas Principal'!C14","v":"ROLDAN TOMAS"},{"$f":"'Firmas Principal'!D14","v":"ANT"},{"$f":"'Firmas Principal'!E14","v":"1997-10-14"},{"$f":"'Firmas Principal'!F14","v":12},{"$f":"'Firmas Principal'!G14","v":"DA"},{"$f":"'Firmas Principal'!H14","v":3}]
[3,{"$f":"'Firmas Principal'!B17","v":"FCT01757"},{"$f":"'Firmas Principal'!C17","v":"MONCAYO CAMILO A"},{"$f":"'Firmas Principal'!D17","v":"NAR"},{"$f":"'Firmas Principal'!E17","v":"1997-10-10"},{"$f":"'Firmas Principal'!F17","v":17},{"$f":"'Firmas Principal'!G17","v":"DA"},{"$f":"'Firmas Principal'!H17","v":11}]
[4,{"$f":"'Firmas Principal'!B12","v":"FCT00453"},{"$f":"'Firmas Principal'!C12","v":"MONTOYA MANUEL"},{"$f":"'Firmas Principal'!D12","v":"ANT"},{"$f":"'Firmas Principal'!E12","v":"1997-10-28"},{"$f":"'Firmas Principal'!F12","v":10},{"$f":"'Firmas Principal'!G12","v":"DA"},{"$f":"'Firmas Principal'!H12","v":12}]
[5,{"$f":"'Firmas Principal'!B13","v":"FCT00280"},{"$f":"'Firmas Principal'!C13","v":"SANTAMARIA FELIPE"},{"$f":"'Firmas Principal'!D13","v":"ANT"},{"$f":"'Firmas Principal'!E13","v":"1996-07-01"},{"$f":"'Firmas Principal'!F13","v":11},{"$f":"'Firmas Principal'!G13","v":"DA"},{"$f":"'Firmas Principal'!H13","v":14}]
[6,{"$f":"'Firmas Principal'!B16","v":"FCT00850"},{"$f":"'Firmas Principal'!C16","v":"RODRIGUEZ JORGE D"},{"$f":"'Firmas Principal'!D16","v":"CUN"},{"$f":"'Firmas Principal'!E16","v":"1997-11-24"},{"$f":"'Firmas Principal'!F16","v":15},{"$f":"'Firmas Principal'!G16","v":"DA"},{"$f":"'Firmas Principal'!H16","v":15}]
[7,{"$f":"'Firmas Principal'!B18","v":"FCT00542"},{"$f":"'Firmas Principal'!C18","v":"MENDIETA FEDERICO"},{"$f":"'Firmas Principal'!D18","v":"SAN"},{"$f":"'Firmas Principal'!E18","v":"1997-08-25"},{"$f":"'Firmas Principal'!F18","v":18},{"$f":"'Firmas Principal'!G18","v":"DA"},{"$f":"'Firmas Principal'!H18","v":16}]
[8,{"$f":"'Firmas Principal'!B15","v":"FCT01373"},{"$f":"'Firmas Principal'!C15","v":"BOTERO MIGUEL A."},{"$f":"'Firmas Principal'!D15","v":"RIS"},{"$f":"'Firmas Principal'!E15","v":"1996-07-09"},{"$f":"'Firmas Principal'!F15","v":14},{"$f":"'Firmas Principal'!G15","v":"DA"},{"$f":"'Firmas Principal'!H15","v":18}]
[9,{"$f":"'Firmas Principal'!B22","v":"FCT01396"},{"$f":"'Firmas Principal'!C22","v":"PINTO ALEJANDRO"},{"$f":"'Firmas Principal'!D22","v":"CUN"},{"$f":"'Firmas Principal'!E22","v":"1996-07-18"},{"$f":"'Firmas Principal'!F22","v":44},{"$f":"'Firmas Principal'!G22","v":"DA"},{"$f":"'Firmas Principal'!H22","v":19}]
[10,"FCT01413",{"$f":"UPPER(IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$5000,2)))","v":"PRADA JUAN D"},{"$f":"UPPER(IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$5000,3)))","v":"CUN"},{"$f":"IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$5000,4))","v":"1996-03-12"},null,"WC",22]
[11,{"$f":"'Firmas Principal'!B19","v":"FCT01211"},{"$f":"'Firmas Principal'!C19","v":"GROSSO CRISTIAN R"},{"$f":"'Firmas Principal'!D19","v":"MET"},{"$f":"'Firmas Principal'!E19","v":"1997-03-24"},{"$f":"'Firmas Principal'!F19","v":27},{"$f":"'Firmas Principal'!G19","v":"DA"},{"$f":"'Firmas Principal'!H19","v":32}]
[12,{"$f":"'Firmas Principal'!B25","v":"FCT01602"},{"$f":"'Firmas Principal'!C25","v":"COLMENARES DANIEL"},{"$f":"'Firmas Principal'!D25","v":"CUN"},{"$f":"'Firmas Principal'!E25","v":"1997-01-14"},{"$f":"'Firmas Principal'!F25","v":56},{"$f":"'Firmas Principal'!G25","v":"DA"},{"$f":"'Firmas Principal'!H25","v":42}]
[13,{"$f":"'Firmas Principal'!B20","v":"FCT01096"},{"$f":"'Firmas Principal'!C20","v":"ECHAVARRIA RODRIGO"},{"$f":"'Firmas Principal'!D20","v":"BOG"},{"$f":"'Firmas Principal'!E20","v":"1996-12-10"},{"$f":"'Firmas Principal'!F20","v":35},{"$f":"'Firmas Principal'!G20","v":"DA"},{"$f":"'Firmas Principal'!H20","v":43}]
[14,{"$f":"'Firmas Principal'!B21","v":"FCT00337"},{"$f":"'Firmas Principal'!C21","v":"NARANJO JUAN N"},{"$f":"'Firmas Principal'!D21","v":"BOG"},{"$f":"'Firmas Principal'!E21","v":"1996-12-22"},{"$f":"'Firmas Principal'!F21","v":40},{"$f":"'Firmas Principal'!G21","v":"DA"},{"$f":"'Firmas Principal'!H21","v":48}]
[15,{"$f":"'Firmas Principal'!B23","v":"FCT00913"},{"$f":"'Firmas Principal'!C23","v":"JARAMILLO JUAN J"},{"$f":"'Firmas Principal'!D23","v":"ANT"},{"$f":"'Firmas Principal'!E23","v":"1997-04-09"},{"$f":"'Firmas Principal'!F23","v":46},{"$f":"'Firmas Principal'!G23","v":"DA"},{"$f":"'Firmas Principal'!H23","v":60}]
[16,{"$f":"'Firmas Principal'!B24","v":"FCT01931"},{"$f":"'Firmas Principal'!C24","v":"MEJIA SANTIAGO"},{"$f":"'Firmas Principal'!D24","v":"ANT"},{"$f":"'Firmas Principal'!E24","v":"1996-08-17"},{"$f":"'Firmas Principal'!F24","v":52},{"$f":"'Firmas Principal'!G24","v":"DA"},{"$f":"'Firmas Principal'!H24","v":61}]
[17,"FCT00710",{"$f":"UPPER(IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$5000,2)))","v":"CORZO PABLO A"},{"$f":"UPPER(IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$5000,3)))","v":"ANT"},{"$f":"IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$5000,4))","v":"1996-10-18"},null,"WC",67]
[18,"FCT00727",{"$f":"UPPER(IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$5000,2)))","v":"CUCALON PAOLO"},{"$f":"UPPER(IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$5000,3)))","v":"VAL"},{"$f":"IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$5000,4))","v":"1998-03-20"},null,"WC",87]
[19,null,"RIOS DILAN M","CUN",null,null,"Q",119]
[20,"FCT03937",{"$f":"UPPER(IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$5000,2)))","v":"MARIN A SANTIAGO "},{"$f":"UPPER(IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$5000,3)))","v":"ANT"},{"$f":"IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$5000,4))","v":"1997-05-07"},null,"WC",119]
[21,null,"TOLEDO PABLO A","BOG",null,null,"Q",147]
[22,null,"BIGOTT CRISTIAN","BOG",null,null,"Q",999]
[23,null,"DUQUE JUAN A","RIS",null,null,"Q",999]
[24,{"$f":"'Firmas Principal'!B26","v":0},{"$f":"'Firmas Principal'!C26","v":""},{"$f":"'Firmas Principal'!D26","v":""},{"$f":"'Firmas Principal'!E26","v":""},{"$f":"'Firmas Principal'!F26","v":0},{"$f":"'Firmas Principal'!G26","v":"LL"},{"$f":"'Firmas Principal'!H26","v":9999}]

{"sheet":"Round Robin","index":6,"n_rows":34,"n_cols":33,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENCILLOS CUADRO DE ROUND ROBIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Torneo",null,null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ciudad",null,null,{"$f":"Maestra!E14","v":"MEDELLIN"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Categoría",null,null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha",null,null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sede",null,null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"}]
[{"$f":"Maestra!E10","v":"GRADO 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supervisor FCT",null,null,{"$f":"Maestra!A18","v":"ESTEBAN JIMENEZ"}]
[]
["N°","Rank","NOMBRE",null,"Liga",null,null,null,1,null,null,null,null,null,2,null,null,null,null,null,3,null,null,null,null,null,4,null,null,"PUNTOS","% SETS","% GAMES","PUESTO"]
[1,{"$f":"UPPER(IF($D10=\"\",\"\",VLOOKUP($D10,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D10=\"\",\"\",VLOOKUP($D10,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D10=\"\",\"\",VLOOKUP($D10,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(R10-S10>0,1,0)+IF(T10-U10>0,1,0)+IF(V10-W10>0,1,0))=2,1,0)+IF((IF(L10-M10>0,1,0)+IF(N10-O10>0,1,0)+IF(P10-Q10>0,1,0))=2,1,0)+IF((IF(X10-Y10>0,1,0)+IF(Z10-AA10>0,1,0)+IF(AB10-AC10>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(R10>5,S10<7),1,0)+IF(AND(T10>5,U10<7),1,0)+IF(AND(V10>5,W10<7),1,0)+IF(AND(L10>5,M10<7),1,0)+IF(AND(N10>5,O10<7),1,0)+IF(AND(P10>5,Q10<7),1,0)+IF(AND(X10>5,Y10<7),1,0)+IF(AND(Z10>5,AA10<7),1,0)+IF(AND(AB10>5,AC10<7),1,0))/(COUNTIF(R10,\">=0\")+COUNTIF(T10,\">=0\")+COUNTIF(V10,\">=0\")+COUNTIF(X10,\">=0\")+COUNTIF(Z10,\">=0\")+COUNTIF(AB10,\">=0\")++COUNTIF(L10,\">=0\")+COUNTIF(N10,\">=0\")+COUNTIF(P10,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((L10+N10+P10+R10+T10+V10+X10+Z10+AB10)/(L10+M10+N10+O10+P10+Q10+R10+S10+T10+U10+V10+W10+X10+Y10+Z10+AA10+AB10+AC10))*100","v":{"$error":"#DIV/0!"}}]
[2,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F11-G11>0,1,0)+IF(H11-I11>0,1,0)+IF(J11-K11>0,1,0))=2,1,0)+IF((IF(R11-S11>0,1,0)+IF(T11-U11>0,1,0)+IF(V11-W11>0,1,0))=2,1,0)+IF((IF(X11-Y11>0,1,0)+IF(Z11-AA11>0,1,0)+IF(AB11-AC11>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F11>5,G11<7),1,0)+IF(AND(H11>5,I11<7),1,0)+IF(AND(J11>5,K11<7),1,0)+IF(AND(R11>5,S11<7),1,0)+IF(AND(T11>5,U11<7),1,0)+IF(AND(V11>5,W11<7),1,0)+IF(AND(X11>5,Y11<7),1,0)+IF(AND(Z11>5,AA11<7),1,0)+IF(AND(AB11>5,AC11<7),1,0))/(COUNTIF(F11,\">=0\")+COUNTIF(H11,\">=0\")+COUNTIF(J11,\">=0\")+COUNTIF(X11,\">=0\")+COUNTIF(Z11,\">=0\")+COUNTIF(AB11,\">=0\")+COUNTIF(R11,\">=0\")+COUNTIF(T11,\">=0\")+COUNTIF(V11,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F11+J11+H11+R11+T11+V11+X11+Z11+AB11)/(F11+G11+H11+I11+J11+K11+R11+S11+T11+U11+V11+W11+X11+Y11+Z11+AA11+AB11+AC11))*100","v":{"$error":"#DIV/0!"}}]
[3,{"$f":"UPPER(IF($D12=\"\",\"\",VLOOKUP($D12,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D12=\"\",\"\",VLOOKUP($D12,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D12=\"\",\"\",VLOOKUP($D12,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F12-G12>0,1,0)+IF(H12-I12>0,1,0)+IF(J12-K12>0,1,0))=2,1,0)+IF((IF(L12-M12>0,1,0)+IF(N12-O12>0,1,0)+IF(P12-Q12>0,1,0))=2,1,0)+IF((IF(X12-Y12>0,1,0)+IF(Z12-AA12>0,1,0)+IF(AB12-AC12>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F12>5,G12<7),1,0)+IF(AND(H12>5,I12<7),1,0)+IF(AND(J12>5,K12<7),1,0)+IF(AND(L12>5,M12<7),1,0)+IF(AND(N12>5,O12<7),1,0)+IF(AND(P12>5,Q12<7),1,0)+IF(AND(X12>5,Y12<7),1,0)+IF(AND(Z12>5,AA12<7),1,0)+IF(AND(AB12>5,AC12<7),1,0))/(COUNTIF(F12,\">=0\")+COUNTIF(H12,\">=0\")+COUNTIF(J12,\">=0\")+COUNTIF(X12,\">=0\")+COUNTIF(Z12,\">=0\")+COUNTIF(AB12,\">=0\")+COUNTIF(L12,\">=0\")+COUNTIF(N12,\">=0\")+COUNTIF(P12,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F12+J12+H12+L12+N12+P12+X12+Z12+AB12)/(F12+G12+H12+I12+J12+K12+L12+M12+N12+O12+P12+Q12+X12+Y12+Z12+AA12+AB12+AC12))*100","v":{"$error":"#DIV/0!"}}]
[4,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F13-G13>0,1,0)+IF(H13-I13>0,1,0)+IF(J13-K13>0,1,0))=2,1,0)+IF((IF(L13-M13>0,1,0)+IF(N13-O13>0,1,0)+IF(P13-Q13>0,1,0))=2,1,0)+IF((IF(R13-S13>0,1,0)+IF(T13-U13>0,1,0)+IF(V13-W13>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F13>5,G13<7),1,0)+IF(AND(H13>5,I13<7),1,0)+IF(AND(J13>5,K13<7),1,0)+IF(AND(L13>5,M13<7),1,0)+IF(AND(N13>5,O13<7),1,0)+IF(AND(P13>5,Q13<7),1,0)+IF(AND(R13>5,S13<7),1,0)+IF(AND(T13>5,U13<7),1,0)+IF(AND(V13>5,W13<7),1,0))/(COUNTIF(F13,\">=0\")+COUNTIF(H13,\">=0\")+COUNTIF(J13,\">=0\")+COUNTIF(R13,\">=0\")+COUNTIF(T13,\">=0\")+COUNTIF(V13,\">=0\")++COUNTIF(L13,\">=0\")+COUNTIF(N13,\">=0\")+COUNTIF(P13,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F13+J13+H13+L13+N13+P13+R13+T13+V13)/(F13+G13+H13+I13+J13+K13+L13+M13+N13+O13+P13+Q13+R13+S13+T13+U13+V13+W13))*100","v":{"$error":"#DIV/0!"}}]
[]
[]
["N°","Rank","NOMBRE",null,"Liga",null,null,null,1,null,null,null,null,null,2,null,null,null,null,null,3,null,null,null,null,null,4,null,null,"PUNTOS","% SETS","% GAMES","PUESTO"]
[5,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(R17-S17>0,1,0)+IF(T17-U17>0,1,0)+IF(V17-W17>0,1,0))=2,1,0)+IF((IF(L17-M17>0,1,0)+IF(N17-O17>0,1,0)+IF(P17-Q17>0,1,0))=2,1,0)+IF((IF(X17-Y17>0,1,0)+IF(Z17-AA17>0,1,0)+IF(AB17-AC17>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(R17>5,S17<7),1,0)+IF(AND(T17>5,U17<7),1,0)+IF(AND(V17>5,W17<7),1,0)+IF(AND(L17>5,M17<7),1,0)+IF(AND(N17>5,O17<7),1,0)+IF(AND(P17>5,Q17<7),1,0)+IF(AND(X17>5,Y17<7),1,0)+IF(AND(Z17>5,AA17<7),1,0)+IF(AND(AB17>5,AC17<7),1,0))/(COUNTIF(R17,\">=0\")+COUNTIF(T17,\">=0\")+COUNTIF(V17,\">=0\")+COUNTIF(X17,\">=0\")+COUNTIF(Z17,\">=0\")+COUNTIF(AB17,\">=0\")++COUNTIF(L17,\">=0\")+COUNTIF(N17,\">=0\")+COUNTIF(P17,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((L17+N17+P17+R17+T17+V17+X17+Z17+AB17)/(L17+M17+N17+O17+P17+Q17+R17+S17+T17+U17+V17+W17+X17+Y17+Z17+AA17+AB17+AC17))*100","v":{"$error":"#DIV/0!"}}]
[6,{"$f":"UPPER(IF($D18=\"\",\"\",VLOOKUP($D18,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D18=\"\",\"\",VLOOKUP($D18,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D18=\"\",\"\",VLOOKUP($D18,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F18-G18>0,1,0)+IF(H18-I18>0,1,0)+IF(J18-K18>0,1,0))=2,1,0)+IF((IF(R18-S18>0,1,0)+IF(T18-U18>0,1,0)+IF(V18-W18>0,1,0))=2,1,0)+IF((IF(X18-Y18>0,1,0)+IF(Z18-AA18>0,1,0)+IF(AB18-AC18>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F18>5,G18<7),1,0)+IF(AND(H18>5,I18<7),1,0)+IF(AND(J18>5,K18<7),1,0)+IF(AND(R18>5,S18<7),1,0)+IF(AND(T18>5,U18<7),1,0)+IF(AND(V18>5,W18<7),1,0)+IF(AND(X18>5,Y18<7),1,0)+IF(AND(Z18>5,AA18<7),1,0)+IF(AND(AB18>5,AC18<7),1,0))/(COUNTIF(F18,\">=0\")+COUNTIF(H18,\">=0\")+COUNTIF(J18,\">=0\")+COUNTIF(X18,\">=0\")+COUNTIF(Z18,\">=0\")+COUNTIF(AB18,\">=0\")+COUNTIF(R18,\">=0\")+COUNTIF(T18,\">=0\")+COUNTIF(V18,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F18+J18+H18+R18+T18+V18+X18+Z18+AB18)/(F18+G18+H18+I18+J18+K18+R18+S18+T18+U18+V18+W18+X18+Y18+Z18+AA18+AB18+AC18))*100","v":{"$error":"#DIV/0!"}}]
[7,{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F19-G19>0,1,0)+IF(H19-I19>0,1,0)+IF(J19-K19>0,1,0))=2,1,0)+IF((IF(L19-M19>0,1,0)+IF(N19-O19>0,1,0)+IF(P19-Q19>0,1,0))=2,1,0)+IF((IF(X19-Y19>0,1,0)+IF(Z19-AA19>0,1,0)+IF(AB19-AC19>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F19>5,G19<7),1,0)+IF(AND(H19>5,I19<7),1,0)+IF(AND(J19>5,K19<7),1,0)+IF(AND(L19>5,M19<7),1,0)+IF(AND(N19>5,O19<7),1,0)+IF(AND(P19>5,Q19<7),1,0)+IF(AND(X19>5,Y19<7),1,0)+IF(AND(Z19>5,AA19<7),1,0)+IF(AND(AB19>5,AC19<7),1,0))/(COUNTIF(F19,\">=0\")+COUNTIF(H19,\">=0\")+COUNTIF(J19,\">=0\")+COUNTIF(X19,\">=0\")+COUNTIF(Z19,\">=0\")+COUNTIF(AB19,\">=0\")+COUNTIF(L19,\">=0\")+COUNTIF(N19,\">=0\")+COUNTIF(P19,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F19+J19+H19+L19+N19+P19+X19+Z19+AB19)/(F19+G19+H19+I19+J19+K19+L19+M19+N19+O19+P19+Q19+X19+Y19+Z19+AA19+AB19+AC19))*100","v":{"$error":"#DIV/0!"}}]
[8,{"$f":"UPPER(IF($D20=\"\",\"\",VLOOKUP($D20,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D20=\"\",\"\",VLOOKUP($D20,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D20=\"\",\"\",VLOOKUP($D20,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F20-G20>0,1,0)+IF(H20-I20>0,1,0)+IF(J20-K20>0,1,0))=2,1,0)+IF((IF(L20-M20>0,1,0)+IF(N20-O20>0,1,0)+IF(P20-Q20>0,1,0))=2,1,0)+IF((IF(R20-S20>0,1,0)+IF(T20-U20>0,1,0)+IF(V20-W20>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F20>5,G20<7),1,0)+IF(AND(H20>5,I20<7),1,0)+IF(AND(J20>5,K20<7),1,0)+IF(AND(L20>5,M20<7),1,0)+IF(AND(N20>5,O20<7),1,0)+IF(AND(P20>5,Q20<7),1,0)+IF(AND(R20>5,S20<7),1,0)+IF(AND(T20>5,U20<7),1,0)+IF(AND(V20>5,W20<7),1,0))/(COUNTIF(F20,\">=0\")+COUNTIF(H20,\">=0\")+COUNTIF(J20,\">=0\")+COUNTIF(R20,\">=0\")+COUNTIF(T20,\">=0\")+COUNTIF(V20,\">=0\")++COUNTIF(L20,\">=0\")+COUNTIF(N20,\">=0\")+COUNTIF(P20,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F20+J20+H20+L20+N20+P20+R20+T20+V20)/(F20+G20+H20+I20+J20+K20+L20+M20+N20+O20+P20+Q20+R20+S20+T20+U20+V20+W20))*100","v":{"$error":"#DIV/0!"}}]
[]
[]
["N°","Rank","NOMBRE",null,"Liga",null,null,null,1,null,null,null,null,null,2,null,null,null,null,null,3,null,null,null,null,null,4,null,null,"PUNTOS","% SETS","% GAMES","PUESTO"]
[9,{"$f":"UPPER(IF($D24=\"\",\"\",VLOOKUP($D24,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D24=\"\",\"\",VLOOKUP($D24,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D24=\"\",\"\",VLOOKUP($D24,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(R24-S24>0,1,0)+IF(T24-U24>0,1,0)+IF(V24-W24>0,1,0))=2,1,0)+IF((IF(L24-M24>0,1,0)+IF(N24-O24>0,1,0)+IF(P24-Q24>0,1,0))=2,1,0)+IF((IF(X24-Y24>0,1,0)+IF(Z24-AA24>0,1,0)+IF(AB24-AC24>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(R24>5,S24<7),1,0)+IF(AND(T24>5,U24<7),1,0)+IF(AND(V24>5,W24<7),1,0)+IF(AND(L24>5,M24<7),1,0)+IF(AND(N24>5,O24<7),1,0)+IF(AND(P24>5,Q24<7),1,0)+IF(AND(X24>5,Y24<7),1,0)+IF(AND(Z24>5,AA24<7),1,0)+IF(AND(AB24>5,AC24<7),1,0))/(COUNTIF(R24,\">=0\")+COUNTIF(T24,\">=0\")+COUNTIF(V24,\">=0\")+COUNTIF(X24,\">=0\")+COUNTIF(Z24,\">=0\")+COUNTIF(AB24,\">=0\")++COUNTIF(L24,\">=0\")+COUNTIF(N24,\">=0\")+COUNTIF(P24,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((L24+N24+P24+R24+T24+V24+X24+Z24+AB24)/(L24+M24+N24+O24+P24+Q24+R24+S24+T24+U24+V24+W24+X24+Y24+Z24+AA24+AB24+AC24))*100","v":{"$error":"#DIV/0!"}}]
[10,{"$f":"UPPER(IF($D25=\"\",\"\",VLOOKUP($D25,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D25=\"\",\"\",VLOOKUP($D25,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D25=\"\",\"\",VLOOKUP($D25,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F25-G25>0,1,0)+IF(H25-I25>0,1,0)+IF(J25-K25>0,1,0))=2,1,0)+IF((IF(R25-S25>0,1,0)+IF(T25-U25>0,1,0)+IF(V25-W25>0,1,0))=2,1,0)+IF((IF(X25-Y25>0,1,0)+IF(Z25-AA25>0,1,0)+IF(AB25-AC25>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F25>5,G25<7),1,0)+IF(AND(H25>5,I25<7),1,0)+IF(AND(J25>5,K25<7),1,0)+IF(AND(R25>5,S25<7),1,0)+IF(AND(T25>5,U25<7),1,0)+IF(AND(V25>5,W25<7),1,0)+IF(AND(X25>5,Y25<7),1,0)+IF(AND(Z25>5,AA25<7),1,0)+IF(AND(AB25>5,AC25<7),1,0))/(COUNTIF(F25,\">=0\")+COUNTIF(H25,\">=0\")+COUNTIF(J25,\">=0\")+COUNTIF(X25,\">=0\")+COUNTIF(Z25,\">=0\")+COUNTIF(AB25,\">=0\")+COUNTIF(R25,\">=0\")+COUNTIF(T25,\">=0\")+COUNTIF(V25,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F25+J25+H25+R25+T25+V25+X25+Z25+AB25)/(F25+G25+H25+I25+J25+K25+R25+S25+T25+U25+V25+W25+X25+Y25+Z25+AA25+AB25+AC25))*100","v":{"$error":"#DIV/0!"}}]
[11,{"$f":"UPPER(IF($D26=\"\",\"\",VLOOKUP($D26,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D26=\"\",\"\",VLOOKUP($D26,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D26=\"\",\"\",VLOOKUP($D26,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F26-G26>0,1,0)+IF(H26-I26>0,1,0)+IF(J26-K26>0,1,0))=2,1,0)+IF((IF(L26-M26>0,1,0)+IF(N26-O26>0,1,0)+IF(P26-Q26>0,1,0))=2,1,0)+IF((IF(X26-Y26>0,1,0)+IF(Z26-AA26>0,1,0)+IF(AB26-AC26>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F26>5,G26<7),1,0)+IF(AND(H26>5,I26<7),1,0)+IF(AND(J26>5,K26<7),1,0)+IF(AND(L26>5,M26<7),1,0)+IF(AND(N26>5,O26<7),1,0)+IF(AND(P26>5,Q26<7),1,0)+IF(AND(X26>5,Y26<7),1,0)+IF(AND(Z26>5,AA26<7),1,0)+IF(AND(AB26>5,AC26<7),1,0))/(COUNTIF(F26,\">=0\")+COUNTIF(H26,\">=0\")+COUNTIF(J26,\">=0\")+COUNTIF(X26,\">=0\")+COUNTIF(Z26,\">=0\")+COUNTIF(AB26,\">=0\")+COUNTIF(L26,\">=0\")+COUNTIF(N26,\">=0\")+COUNTIF(P26,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F26+J26+H26+L26+N26+P26+X26+Z26+AB26)/(F26+G26+H26+I26+J26+K26+L26+M26+N26+O26+P26+Q26+X26+Y26+Z26+AA26+AB26+AC26))*100","v":{"$error":"#DIV/0!"}}]
[12,{"$f":"UPPER(IF($D27=\"\",\"\",VLOOKUP($D27,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D27=\"\",\"\",VLOOKUP($D27,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D27=\"\",\"\",VLOOKUP($D27,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F27-G27>0,1,0)+IF(H27-I27>0,1,0)+IF(J27-K27>0,1,0))=2,1,0)+IF((IF(L27-M27>0,1,0)+IF(N27-O27>0,1,0)+IF(P27-Q27>0,1,0))=2,1,0)+IF((IF(R27-S27>0,1,0)+IF(T27-U27>0,1,0)+IF(V27-W27>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F27>5,G27<7),1,0)+IF(AND(H27>5,I27<7),1,0)+IF(AND(J27>5,K27<7),1,0)+IF(AND(L27>5,M27<7),1,0)+IF(AND(N27>5,O27<7),1,0)+IF(AND(P27>5,Q27<7),1,0)+IF(AND(R27>5,S27<7),1,0)+IF(AND(T27>5,U27<7),1,0)+IF(AND(V27>5,W27<7),1,0))/(COUNTIF(F27,\">=0\")+COUNTIF(H27,\">=0\")+COUNTIF(J27,\">=0\")+COUNTIF(R27,\">=0\")+COUNTIF(T27,\">=0\")+COUNTIF(V27,\">=0\")++COUNTIF(L27,\">=0\")+COUNTIF(N27,\">=0\")+COUNTIF(P27,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F27+J27+H27+L27+N27+P27+R27+T27+V27)/(F27+G27+H27+I27+J27+K27+L27+M27+N27+O27+P27+Q27+R27+S27+T27+U27+V27+W27))*100","v":{"$error":"#DIV/0!"}}]
[]
[]
["N°","Rank","NOMBRE",null,"Liga",null,null,null,1,null,null,null,null,null,2,null,null,null,null,null,3,null,null,null,null,null,4,null,null,"PUNTOS","% SETS","% GAMES","PUESTO"]
[13,{"$f":"UPPER(IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(R31-S31>0,1,0)+IF(T31-U31>0,1,0)+IF(V31-W31>0,1,0))=2,1,0)+IF((IF(L31-M31>0,1,0)+IF(N31-O31>0,1,0)+IF(P31-Q31>0,1,0))=2,1,0)+IF((IF(X31-Y31>0,1,0)+IF(Z31-AA31>0,1,0)+IF(AB31-AC31>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(R31>5,S31<7),1,0)+IF(AND(T31>5,U31<7),1,0)+IF(AND(V31>5,W31<7),1,0)+IF(AND(L31>5,M31<7),1,0)+IF(AND(N31>5,O31<7),1,0)+IF(AND(P31>5,Q31<7),1,0)+IF(AND(X31>5,Y31<7),1,0)+IF(AND(Z31>5,AA31<7),1,0)+IF(AND(AB31>5,AC31<7),1,0))/(COUNTIF(R31,\">=0\")+COUNTIF(T31,\">=0\")+COUNTIF(V31,\">=0\")+COUNTIF(X31,\">=0\")+COUNTIF(Z31,\">=0\")+COUNTIF(AB31,\">=0\")++COUNTIF(L31,\">=0\")+COUNTIF(N31,\">=0\")+COUNTIF(P31,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((L31+N31+P31+R31+T31+V31+X31+Z31+AB31)/(L31+M31+N31+O31+P31+Q31+R31+S31+T31+U31+V31+W31+X31+Y31+Z31+AA31+AB31+AC31))*100","v":{"$error":"#DIV/0!"}}]
[14,{"$f":"UPPER(IF($D32=\"\",\"\",VLOOKUP($D32,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D32=\"\",\"\",VLOOKUP($D32,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D32=\"\",\"\",VLOOKUP($D32,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F32-G32>0,1,0)+IF(H32-I32>0,1,0)+IF(J32-K32>0,1,0))=2,1,0)+IF((IF(R32-S32>0,1,0)+IF(T32-U32>0,1,0)+IF(V32-W32>0,1,0))=2,1,0)+IF((IF(X32-Y32>0,1,0)+IF(Z32-AA32>0,1,0)+IF(AB32-AC32>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F32>5,G32<7),1,0)+IF(AND(H32>5,I32<7),1,0)+IF(AND(J32>5,K32<7),1,0)+IF(AND(R32>5,S32<7),1,0)+IF(AND(T32>5,U32<7),1,0)+IF(AND(V32>5,W32<7),1,0)+IF(AND(X32>5,Y32<7),1,0)+IF(AND(Z32>5,AA32<7),1,0)+IF(AND(AB32>5,AC32<7),1,0))/(COUNTIF(F32,\">=0\")+COUNTIF(H32,\">=0\")+COUNTIF(J32,\">=0\")+COUNTIF(X32,\">=0\")+COUNTIF(Z32,\">=0\")+COUNTIF(AB32,\">=0\")+COUNTIF(R32,\">=0\")+COUNTIF(T32,\">=0\")+COUNTIF(V32,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F32+J32+H32+R32+T32+V32+X32+Z32+AB32)/(F32+G32+H32+I32+J32+K32+R32+S32+T32+U32+V32+W32+X32+Y32+Z32+AA32+AB32+AC32))*100","v":{"$error":"#DIV/0!"}}]
[15,{"$f":"UPPER(IF($D33=\"\",\"\",VLOOKUP($D33,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D33=\"\",\"\",VLOOKUP($D33,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D33=\"\",\"\",VLOOKUP($D33,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F33-G33>0,1,0)+IF(H33-I33>0,1,0)+IF(J33-K33>0,1,0))=2,1,0)+IF((IF(L33-M33>0,1,0)+IF(N33-O33>0,1,0)+IF(P33-Q33>0,1,0))=2,1,0)+IF((IF(X33-Y33>0,1,0)+IF(Z33-AA33>0,1,0)+IF(AB33-AC33>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F33>5,G33<7),1,0)+IF(AND(H33>5,I33<7),1,0)+IF(AND(J33>5,K33<7),1,0)+IF(AND(L33>5,M33<7),1,0)+IF(AND(N33>5,O33<7),1,0)+IF(AND(P33>5,Q33<7),1,0)+IF(AND(X33>5,Y33<7),1,0)+IF(AND(Z33>5,AA33<7),1,0)+IF(AND(AB33>5,AC33<7),1,0))/(COUNTIF(F33,\">=0\")+COUNTIF(H33,\">=0\")+COUNTIF(J33,\">=0\")+COUNTIF(X33,\">=0\")+COUNTIF(Z33,\">=0\")+COUNTIF(AB33,\">=0\")+COUNTIF(L33,\">=0\")+COUNTIF(N33,\">=0\")+COUNTIF(P33,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F33+J33+H33+L33+N33+P33+X33+Z33+AB33)/(F33+G33+H33+I33+J33+K33+L33+M33+N33+O33+P33+Q33+X33+Y33+Z33+AA33+AB33+AC33))*100","v":{"$error":"#DIV/0!"}}]
[16,{"$f":"UPPER(IF($D34=\"\",\"\",VLOOKUP($D34,'Prep. Principal S'!$A$11:$K$34,8)))","v":""},{"$f":"UPPER(IF($D34=\"\",\"\",VLOOKUP($D34,'Prep. Principal S'!$A$10:$J$34,3)))","v":""},null,{"$f":"UPPER(IF($D34=\"\",\"\",VLOOKUP($D34,'Prep. Principal S'!$A$10:$J$34,4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((IF(F34-G34>0,1,0)+IF(H34-I34>0,1,0)+IF(J34-K34>0,1,0))=2,1,0)+IF((IF(L34-M34>0,1,0)+IF(N34-O34>0,1,0)+IF(P34-Q34>0,1,0))=2,1,0)+IF((IF(R34-S34>0,1,0)+IF(T34-U34>0,1,0)+IF(V34-W34>0,1,0))=2,1,0)","v":0},{"$f":"((IF(AND(F34>5,G34<7),1,0)+IF(AND(H34>5,I34<7),1,0)+IF(AND(J34>5,K34<7),1,0)+IF(AND(L34>5,M34<7),1,0)+IF(AND(N34>5,O34<7),1,0)+IF(AND(P34>5,Q34<7),1,0)+IF(AND(R34>5,S34<7),1,0)+IF(AND(T34>5,U34<7),1,0)+IF(AND(V34>5,W34<7),1,0))/(COUNTIF(F34,\">=0\")+COUNTIF(H34,\">=0\")+COUNTIF(J34,\">=0\")+COUNTIF(R34,\">=0\")+COUNTIF(T34,\">=0\")+COUNTIF(V34,\">=0\")++COUNTIF(L34,\">=0\")+COUNTIF(N34,\">=0\")+COUNTIF(P34,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F34+J34+H34+L34+N34+P34+R34+T34+V34)/(F34+G34+H34+I34+J34+K34+L34+M34+N34+O34+P34+Q34+R34+S34+T34+U34+V34+W34))*100","v":{"$error":"#DIV/0!"}}]

{"sheet":"Principal RR","index":7,"n_rows":79,"n_cols":12,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"SENC. CUADRO PRINCIPAL"]
[null,null,null,null,null,null,null,null,"Categoria",null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[null,null,null,null,null,null,null,null,"Torneo",null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"}]
[null,null,null,null,null,null,null,null,"Ciudad",null,{"$f":"Maestra!E14","v":"MEDELLIN"}]
[{"$f":"Maestra!E10","v":"GRADO 2"},null,null,null,null,null,null,null,"Fecha",null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[]
[null,null,"NOMBRE","LIGA",null,null,null,null,"Sede",null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"}]
[]
[]
[]
[]
[]
[]
[null,null,null,"A",{"$f":"IF(D14=\"a\",C10,IF(C14=\"b\",C30,\"\"))","v":0}]
[]
[]
[]
[null,null,"BYE"]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(E22=\"a\",#REF!,IF(E22=\"b\",#REF!,\"\"))","v":""},{"$f":"IF(E22=\"a\",E14,IF(E22=\"b\",E30,\"\"))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"A",{"$f":"IF(D30=\"a\",C26,IF(C30=\"b\",C46,\"\"))","v":0}]
[]
[]
[]
[null,null,"BYE"]
[]
[]
[]
[null,null,null,null,"B",{"$f":"IF(E38=\"a\",F22,IF(E38=\"b\",F54,\"\"))","v":""},null,{"$f":"IF(G38=\"a\",F30,IF(G38=\"b\",F46,\"\"))","v":""},{"$f":"IF(G38=\"a\",G22,IF(G38=\"b\",G54,\"\"))","v":""},null,null,"Ganador"]
[]
[]
[]
[null,null,"BYE"]
[]
[]
[]
[null,null,null,"B",{"$f":"IF(D46=\"a\",C42,IF(D46=\"b\",C50,\"\"))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(E54=\"a\",#REF!,IF(E54=\"b\",#REF!,\"\"))","v":""},{"$f":"IF(E54=\"a\",E46,IF(E54=\"b\",E62,\"\"))","v":""}]
[]
[]
[]
[null,null,"BYE"]
[]
[]
[]
[null,null,null,"b",{"$f":"IF(D62=\"a\",C58,IF(D62=\"b\",C66,\"\"))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Siembras",null,null,"Puntuacion"]
[1,{"$f":"IF(D7=1,E7,\"\")","v":""},null,1,"Campeon",null,300,60]
[2,{"$f":"IF(D69=2,E69,\"\")","v":""},null,2,"Subcampeon",null,210,40]
[3,null,null,3,"Semifinal",null,150,30]
[4,null,null,4,null,null,null,24]
[5,null,null,5,null,null,null,12]
[6,null,null,6,null,null,null,1]
[7,null,null,7]
[8,null,null,8]

{"sheet":"Principal Sen.","index":8,"n_rows":79,"n_cols":16,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"SENC. CUADRO PRINCIPAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Categoria",null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Torneo",null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ciudad",null,{"$f":"Maestra!E14","v":"MEDELLIN"}]
[{"$f":"Maestra!E10","v":"GRADO 2"},null,null,null,null,null,null,null,null,null,null,null,null,"Fecha",null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sede",null,{"$f":"Maestra!A15","v":0}]
[1,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'Prep. Principal S'!$A$11:$J$34,8))","v":1},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},1,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,'Prep. Principal S'!$A$11:$J$34,3)))","v":"MONCADA ALEJANDRO"},null,null,{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,'Prep. Principal S'!$A$11:$J$34,4))","v":"ANT"},null,null,null,null,null,"Sede",null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"}]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I8=\"a\",E7,IF(I8=\"b\",E9,\"\"))","v":"MONCADA ALEJANDRO"}]
[2,null,null,null,"BYE"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K10=\"a\",J8,IF(K10=\"b\",J12,\"\"))","v":""}]
[3,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'Prep. Principal S'!$A$11:$J$34,8))","v":9999},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'Prep. Principal S'!$A$11:$J$34,7))","v":"LL"},24,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,'Prep. Principal S'!$A$11:$J$34,3)))","v":""},null,null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,'Prep. Principal S'!$A$11:$J$34,4))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"a\",E11,IF(I12=\"b\",E13,\"\"))","v":""}]
[4,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Principal S'!$A$11:$J$34,8))","v":42},{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},12,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Principal S'!$A$11:$J$34,3)))","v":"COLMENARES DANIEL"},null,null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,'Prep. Principal S'!$A$11:$J$34,4))","v":"CUN"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M14=\"a\",L10,IF(M14=\"b\",L18,\"\"))","v":""}]
[5,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'Prep. Principal S'!$A$11:$J$34,8))","v":119},{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'Prep. Principal S'!$A$11:$J$34,7))","v":"Q"},19,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,'Prep. Principal S'!$A$11:$J$34,3)))","v":"RIOS DILAN M"},null,null,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,'Prep. Principal S'!$A$11:$J$34,4))","v":"CUN"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I16=\"a\",E15,IF(I16=\"b\",E17,\"\"))","v":""}]
[6,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'Prep. Principal S'!$A$11:$J$34,8))","v":32},{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},11,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,'Prep. Principal S'!$A$11:$J$34,3)))","v":"GROSSO CRISTIAN R"},null,null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,'Prep. Principal S'!$A$11:$J$34,4))","v":"MET"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K18=\"a\",J16,IF(K18=\"b\",J20,\"\"))","v":""}]
[7,null,null,null,"BYE"]
[null,null,{"$f":"IF($D20=\"\",\"\",VLOOKUP($D20,'Prep. Principal S'!$A$11:$J$34,7))","v":""},null,null,null,null,null,"b",{"$f":"IF(I20=\"a\",E19,IF(I20=\"b\",E21,\"\"))","v":"RODRIGUEZ JORGE D"}]
[8,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'Prep. Principal S'!$A$11:$J$34,8))","v":15},{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},6,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,'Prep. Principal S'!$A$11:$J$34,3)))","v":"RODRIGUEZ JORGE D"},null,null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,'Prep. Principal S'!$A$11:$J$34,4))","v":"CUN"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O22=\"a\",N14,IF(O22=\"b\",N30,\"\"))","v":""}]
[9,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,'Prep. Principal S'!$A$11:$J$34,8))","v":12},{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},4,{"$f":"UPPER(IF($D23=\"\",\"\",VLOOKUP($D23,'Prep. Principal S'!$A$11:$J$34,3)))","v":"MONTOYA MANUEL"},null,null,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,'Prep. Principal S'!$A$11:$J$34,4))","v":"ANT"}]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I24=\"a\",E23,IF(I24=\"b\",E25,\"\"))","v":"MONTOYA MANUEL"}]
[10,null,null,null,"BYE"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K26=\"a\",J24,IF(K26=\"b\",J28,\"\"))","v":""}]
[11,{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,'Prep. Principal S'!$A$11:$J$34,8))","v":22},{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,'Prep. Principal S'!$A$11:$J$34,7))","v":"WC"},10,{"$f":"UPPER(IF($D27=\"\",\"\",VLOOKUP($D27,'Prep. Principal S'!$A$11:$J$34,3)))","v":"PRADA JUAN D"},null,null,{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,'Prep. Principal S'!$A$11:$J$34,4))","v":"CUN"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I28=\"a\",E27,IF(I28=\"b\",E29,\"\"))","v":""}]
[12,{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,'Prep. Principal S'!$A$11:$J$34,8))","v":60},{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},15,{"$f":"UPPER(IF($D29=\"\",\"\",VLOOKUP($D29,'Prep. Principal S'!$A$11:$J$34,3)))","v":"JARAMILLO JUAN J"},null,null,{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,'Prep. Principal S'!$A$11:$J$34,4))","v":"ANT"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M30=\"a\",L26,IF(M30=\"b\",L34,\"\"))","v":""}]
[13,{"$f":"IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Principal S'!$A$11:$J$34,8))","v":61},{"$f":"IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},16,{"$f":"UPPER(IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Principal S'!$A$11:$J$34,3)))","v":"MEJIA SANTIAGO"},null,null,{"$f":"IF($D31=\"\",\"\",VLOOKUP($D31,'Prep. Principal S'!$A$11:$J$34,4))","v":"ANT"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I32=\"a\",E31,IF(I32=\"b\",E33,\"\"))","v":""}]
[14,{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,'Prep. Principal S'!$A$11:$J$34,8))","v":999},{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,'Prep. Principal S'!$A$11:$J$34,7))","v":"Q"},22,{"$f":"UPPER(IF($D33=\"\",\"\",VLOOKUP($D33,'Prep. Principal S'!$A$11:$J$34,3)))","v":"BIGOTT CRISTIAN"},null,null,{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,'Prep. Principal S'!$A$11:$J$34,4))","v":"BOG"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K34=\"a\",J32,IF(K34=\"b\",J36,\"\"))","v":""}]
[15,{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,'Prep. Principal S'!$A$11:$J$34,8))","v":""},null,null,"BYE"]
[null,null,null,null,null,null,null,null,"B",{"$f":"IF(I36=\"a\",E35,IF(I36=\"b\",E37,\"\"))","v":"SANTAMARIA FELIPE"}]
[16,{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,'Prep. Principal S'!$A$11:$J$34,8))","v":14},{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},5,{"$f":"UPPER(IF($D37=\"\",\"\",VLOOKUP($D37,'Prep. Principal S'!$A$11:$J$34,3)))","v":"SANTAMARIA FELIPE"},null,null,{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,'Prep. Principal S'!$A$11:$J$34,4))","v":"ANT"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ganador",null,{"$f":"IF(O38=\"a\",P22,IF(O38=\"b\",P54,\"\"))","v":""}]
[17,{"$f":"IF($D39=\"\",\"\",VLOOKUP($D39,'Prep. Principal S'!$A$11:$J$34,8))","v":18},{"$f":"IF($D39=\"\",\"\",VLOOKUP($D39,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},8,{"$f":"UPPER(IF($D39=\"\",\"\",VLOOKUP($D39,'Prep. Principal S'!$A$11:$J$34,3)))","v":"BOTERO MIGUEL A."},null,null,{"$f":"IF($D39=\"\",\"\",VLOOKUP($D39,'Prep. Principal S'!$A$11:$J$34,4))","v":"RIS"}]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I40=\"a\",E39,IF(I40=\"b\",E41,\"\"))","v":"BOTERO MIGUEL A."}]
[18,{"$f":"IF($D41=\"\",\"\",VLOOKUP($D41,'Prep. Principal S'!$A$11:$J$34,8))","v":""},null,null,"BYE"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K42=\"a\",J40,IF(K42=\"b\",J44,\"\"))","v":""}]
[19,{"$f":"IF($D43=\"\",\"\",VLOOKUP($D43,'Prep. Principal S'!$A$11:$J$34,8))","v":67},{"$f":"IF($D43=\"\",\"\",VLOOKUP($D43,'Prep. Principal S'!$A$11:$J$34,7))","v":"WC"},17,{"$f":"UPPER(IF($D43=\"\",\"\",VLOOKUP($D43,'Prep. Principal S'!$A$11:$J$34,3)))","v":"CORZO PABLO A"},null,null,{"$f":"IF($D43=\"\",\"\",VLOOKUP($D43,'Prep. Principal S'!$A$11:$J$34,4))","v":"ANT"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I44=\"a\",E43,IF(I44=\"b\",E45,\"\"))","v":""}]
[20,{"$f":"IF($D45=\"\",\"\",VLOOKUP($D45,'Prep. Principal S'!$A$11:$J$34,8))","v":19},{"$f":"IF($D45=\"\",\"\",VLOOKUP($D45,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},9,{"$f":"UPPER(IF($D45=\"\",\"\",VLOOKUP($D45,'Prep. Principal S'!$A$11:$J$34,3)))","v":"PINTO ALEJANDRO"},null,null,{"$f":"IF($D45=\"\",\"\",VLOOKUP($D45,'Prep. Principal S'!$A$11:$J$34,4))","v":"CUN"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M46=\"a\",L42,IF(M46=\"b\",L50,\"\"))","v":""}]
[21,{"$f":"IF($D47=\"\",\"\",VLOOKUP($D47,'Prep. Principal S'!$A$11:$J$34,8))","v":999},{"$f":"IF($D47=\"\",\"\",VLOOKUP($D47,'Prep. Principal S'!$A$11:$J$34,7))","v":"Q"},23,{"$f":"UPPER(IF($D47=\"\",\"\",VLOOKUP($D47,'Prep. Principal S'!$A$11:$J$34,3)))","v":"DUQUE JUAN A"},null,null,{"$f":"IF($D47=\"\",\"\",VLOOKUP($D47,'Prep. Principal S'!$A$11:$J$34,4))","v":"RIS"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I48=\"a\",E47,IF(I48=\"b\",E49,\"\"))","v":""}]
[22,{"$f":"IF($D49=\"\",\"\",VLOOKUP($D49,'Prep. Principal S'!$A$11:$J$34,8))","v":48},{"$f":"IF($D49=\"\",\"\",VLOOKUP($D49,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},14,{"$f":"UPPER(IF($D49=\"\",\"\",VLOOKUP($D49,'Prep. Principal S'!$A$11:$J$34,3)))","v":"NARANJO JUAN N"},null,null,{"$f":"IF($D49=\"\",\"\",VLOOKUP($D49,'Prep. Principal S'!$A$11:$J$34,4))","v":"BOG"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K50=\"a\",J48,IF(K50=\"b\",J52,\"\"))","v":""}]
[23,null,null,null,"BYE"]
[null,null,null,null,null,null,null,null,"B",{"$f":"IF(I52=\"a\",E51,IF(I52=\"b\",E53,\"\"))","v":"MONCAYO CAMILO A"}]
[24,{"$f":"IF($D53=\"\",\"\",VLOOKUP($D53,'Prep. Principal S'!$A$11:$J$34,8))","v":11},{"$f":"IF($D53=\"\",\"\",VLOOKUP($D53,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},3,{"$f":"UPPER(IF($D53=\"\",\"\",VLOOKUP($D53,'Prep. Principal S'!$A$11:$J$34,3)))","v":"MONCAYO CAMILO A"},null,null,{"$f":"IF($D53=\"\",\"\",VLOOKUP($D53,'Prep. Principal S'!$A$11:$J$34,4))","v":"NAR"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O54=\"a\",N46,IF(O54=\"b\",N62,\"\"))","v":""}]
[25,{"$f":"IF($D55=\"\",\"\",VLOOKUP($D55,'Prep. Principal S'!$A$11:$J$34,8))","v":16},{"$f":"IF($D55=\"\",\"\",VLOOKUP($D55,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},7,{"$f":"UPPER(IF($D55=\"\",\"\",VLOOKUP($D55,'Prep. Principal S'!$A$11:$J$34,3)))","v":"MENDIETA FEDERICO"},null,null,{"$f":"IF($D55=\"\",\"\",VLOOKUP($D55,'Prep. Principal S'!$A$11:$J$34,4))","v":"SAN"}]
[null,null,null,null,null,null,null,null,"A",{"$f":"IF(I56=\"a\",E55,IF(I56=\"b\",E57,\"\"))","v":"MENDIETA FEDERICO"}]
[26,null,null,null,"BYE"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K58=\"a\",J56,IF(K58=\"b\",J60,\"\"))","v":""}]
[27,{"$f":"IF($D59=\"\",\"\",VLOOKUP($D59,'Prep. Principal S'!$A$11:$J$34,8))","v":43},{"$f":"IF($D59=\"\",\"\",VLOOKUP($D59,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},13,{"$f":"UPPER(IF($D59=\"\",\"\",VLOOKUP($D59,'Prep. Principal S'!$A$11:$J$34,3)))","v":"ECHAVARRIA RODRIGO"},null,null,{"$f":"IF($D59=\"\",\"\",VLOOKUP($D59,'Prep. Principal S'!$A$11:$J$34,4))","v":"BOG"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"a\",E59,IF(I60=\"b\",E61,\"\"))","v":""}]
[28,{"$f":"IF($D61=\"\",\"\",VLOOKUP($D61,'Prep. Principal S'!$A$11:$J$34,8))","v":119},{"$f":"IF($D61=\"\",\"\",VLOOKUP($D61,'Prep. Principal S'!$A$11:$J$34,7))","v":"WC"},20,{"$f":"UPPER(IF($D61=\"\",\"\",VLOOKUP($D61,'Prep. Principal S'!$A$11:$J$34,3)))","v":"MARIN A SANTIAGO "},null,null,{"$f":"IF($D61=\"\",\"\",VLOOKUP($D61,'Prep. Principal S'!$A$11:$J$34,4))","v":"ANT"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M62=\"a\",L58,IF(M62=\"b\",L66,\"\"))","v":""}]
[29,{"$f":"IF($D63=\"\",\"\",VLOOKUP($D63,'Prep. Principal S'!$A$11:$J$34,8))","v":147},{"$f":"IF($D63=\"\",\"\",VLOOKUP($D63,'Prep. Principal S'!$A$11:$J$34,7))","v":"Q"},21,{"$f":"UPPER(IF($D63=\"\",\"\",VLOOKUP($D63,'Prep. Principal S'!$A$11:$J$34,3)))","v":"TOLEDO PABLO A"},null,null,{"$f":"IF($D63=\"\",\"\",VLOOKUP($D63,'Prep. Principal S'!$A$11:$J$34,4))","v":"BOG"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I64=\"a\",E63,IF(I64=\"b\",E65,\"\"))","v":""}]
[30,{"$f":"IF($D65=\"\",\"\",VLOOKUP($D65,'Prep. Principal S'!$A$11:$J$34,8))","v":87},{"$f":"IF($D65=\"\",\"\",VLOOKUP($D65,'Prep. Principal S'!$A$11:$J$34,7))","v":"WC"},18,{"$f":"UPPER(IF($D65=\"\",\"\",VLOOKUP($D65,'Prep. Principal S'!$A$11:$J$34,3)))","v":"CUCALON PAOLO"},null,null,{"$f":"IF($D65=\"\",\"\",VLOOKUP($D65,'Prep. Principal S'!$A$11:$J$34,4))","v":"VAL"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K66=\"a\",J64,IF(K66=\"b\",J68,\"\"))","v":""}]
[31,null,null,null,"BYE"]
[null,null,null,null,null,null,null,null,"B",{"$f":"IF(I68=\"a\",E67,IF(I68=\"b\",E69,\"\"))","v":"ROLDAN TOMAS"}]
[32,{"$f":"IF($D69=\"\",\"\",VLOOKUP($D69,'Prep. Principal S'!$A$11:$J$34,8))","v":3},{"$f":"IF($D69=\"\",\"\",VLOOKUP($D69,'Prep. Principal S'!$A$11:$J$34,7))","v":"DA"},2,{"$f":"UPPER(IF($D69=\"\",\"\",VLOOKUP($D69,'Prep. Principal S'!$A$11:$J$34,3)))","v":"ROLDAN TOMAS"},null,null,{"$f":"IF($D69=\"\",\"\",VLOOKUP($D69,'Prep. Principal S'!$A$11:$J$34,4))","v":"ANT"}]
[]
[null,"Siembras",null,null,null,null,"Puntuacion"]
[1,{"$f":"IF(D7=1,E7,\"\")","v":"MONCADA ALEJANDRO"},null,null,null,1,"Campeòn",null,null,300]
[2,{"$f":"IF(D69=2,E69,\"\")","v":"ROLDAN TOMAS"},null,null,null,2,"Subcampeòn",null,null,210]
[3,{"$f":"IF(D23=3,E23,IF(D53=3,E53,\"\"))","v":"MONCAYO CAMILO A"},null,null,null,3,"Semifinal",null,null,150]
[4,{"$f":"IF(D23=4,E23,IF(D53=4,E53,\"\"))","v":"MONTOYA MANUEL"},null,null,null,4,"Cuartos de final",null,null,90]
[5,{"$f":"IF(D21=5,E21,IF(D37=5,E37,IF(D39=5,E39,IF(D55=5,E55,\"\"))))","v":"SANTAMARIA FELIPE"},null,null,null,5,"Octavos de final",null,null,45,"Supervisor FCT"]
[6,{"$f":"IF(D21=6,E21,IF(D37=6,E37,IF(D39=6,E39,IF(D55=6,E55,\"\"))))","v":"RODRIGUEZ JORGE D"},null,null,null,6,"Dieciseisavos de final",null,null,1]
[7,{"$f":"IF(D21=7,E21,IF(D37=7,E37,IF(D39=7,E39,IF(D55=7,E55,\"\"))))","v":"MENDIETA FEDERICO"},null,null,null,7,null,null,null,null,{"$f":"Maestra!A18","v":"ESTEBAN JIMENEZ"}]
[8,{"$f":"IF(D21=8,E21,IF(D37=8,E37,IF(D39=8,E39,IF(D55=8,E55,\"\"))))","v":"BOTERO MIGUEL A."},null,null,null,8]

{"sheet":"Listado D","index":9,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"LISTA DE DOBLES"]
[]
[]
["Torneo",null,null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"},"Clase",null,{"$f":"Maestra!E10","v":"GRADO 2"},null,null,"Categoría",null,null,null,null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[]
["Sede",null,null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"},"Ciudad",null,{"$f":"Maestra!E14","v":"MEDELLIN"},null,null,"Fecha",null,null,null,null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[]
["Supervisor FCT",null,null,{"$f":"Maestra!A18","v":"ESTEBAN JIMENEZ"}]
[]
[null,null,null,"Jugador 1",null,null,null,null,null,"Jugador 2",null,null,null,null,null,"Equipo"]
["Línea","Código","Apellido y Nombre","Liga","Fecha de Nacimiento D/M/A","Rank. Entrada","Estado","Código","Apellido y Nombre","Liga","Fecha de Nacimiento D/M/A","Rank. Entrada","Estado","Aceptación","Rank. Combinado","Rank. Sencillo","Status"]
[1,null,{"$f":"UPPER(IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B12=\"\",\"\",VLOOKUP($B12,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H12=\"\",\"\",VLOOKUP($H12,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H12=\"\",\"\",VLOOKUP($H12,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H12=\"\",\"\",VLOOKUP($H12,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H12=\"\",\"\",VLOOKUP($H12,[1]Codigos!$A$5:$F$9000,6)))","v":""},{"$f":"IF(AND(C12>0,I12>0),IF(AND(F12>0,L12>0),\"A\",IF(OR(AND(F12>0,M12>0),AND(G12>0,L12>0)),\"B\",IF(OR(AND(F12>0,M12=0),AND(G12=0,L12>0)),\"C\",IF(AND(G12>0,M12>0),\"D\",IF(OR(AND(F12>0,M12=0),AND(F12=0,M12>0)),\"E\",IF(AND(F12=0,M12=0),\"F\",\"\")))))),)","v":"D"},{"$f":"IF(N12=\"A\",F12+L12,\"\")","v":""},{"$f":"IF(OR(N12=\"B\",N12=\"C\"),F12+L12,\"\")","v":""},"DA"]
[2,null,{"$f":"UPPER(IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B13=\"\",\"\",VLOOKUP($B13,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H13=\"\",\"\",VLOOKUP($H13,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H13=\"\",\"\",VLOOKUP($H13,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H13=\"\",\"\",VLOOKUP($H13,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H13=\"\",\"\",VLOOKUP($H13,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[3,null,{"$f":"UPPER(IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B14=\"\",\"\",VLOOKUP($B14,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H14=\"\",\"\",VLOOKUP($H14,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H14=\"\",\"\",VLOOKUP($H14,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H14=\"\",\"\",VLOOKUP($H14,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H14=\"\",\"\",VLOOKUP($H14,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[4,null,{"$f":"UPPER(IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B15=\"\",\"\",VLOOKUP($B15,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H15=\"\",\"\",VLOOKUP($H15,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H15=\"\",\"\",VLOOKUP($H15,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H15=\"\",\"\",VLOOKUP($H15,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H15=\"\",\"\",VLOOKUP($H15,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[5,null,{"$f":"UPPER(IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B16=\"\",\"\",VLOOKUP($B16,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H16=\"\",\"\",VLOOKUP($H16,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H16=\"\",\"\",VLOOKUP($H16,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H16=\"\",\"\",VLOOKUP($H16,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H16=\"\",\"\",VLOOKUP($H16,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[6,null,{"$f":"UPPER(IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B17=\"\",\"\",VLOOKUP($B17,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H17=\"\",\"\",VLOOKUP($H17,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H17=\"\",\"\",VLOOKUP($H17,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H17=\"\",\"\",VLOOKUP($H17,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H17=\"\",\"\",VLOOKUP($H17,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[7,null,{"$f":"UPPER(IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B18=\"\",\"\",VLOOKUP($B18,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H18=\"\",\"\",VLOOKUP($H18,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H18=\"\",\"\",VLOOKUP($H18,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H18=\"\",\"\",VLOOKUP($H18,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H18=\"\",\"\",VLOOKUP($H18,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[8,null,{"$f":"UPPER(IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B19=\"\",\"\",VLOOKUP($B19,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H19=\"\",\"\",VLOOKUP($H19,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H19=\"\",\"\",VLOOKUP($H19,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H19=\"\",\"\",VLOOKUP($H19,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H19=\"\",\"\",VLOOKUP($H19,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[9,null,{"$f":"UPPER(IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B20=\"\",\"\",VLOOKUP($B20,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H20=\"\",\"\",VLOOKUP($H20,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H20=\"\",\"\",VLOOKUP($H20,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H20=\"\",\"\",VLOOKUP($H20,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H20=\"\",\"\",VLOOKUP($H20,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[10,null,{"$f":"UPPER(IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B21=\"\",\"\",VLOOKUP($B21,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H21=\"\",\"\",VLOOKUP($H21,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H21=\"\",\"\",VLOOKUP($H21,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H21=\"\",\"\",VLOOKUP($H21,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H21=\"\",\"\",VLOOKUP($H21,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[11,null,{"$f":"UPPER(IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B22=\"\",\"\",VLOOKUP($B22,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H22=\"\",\"\",VLOOKUP($H22,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H22=\"\",\"\",VLOOKUP($H22,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H22=\"\",\"\",VLOOKUP($H22,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H22=\"\",\"\",VLOOKUP($H22,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[12,null,{"$f":"UPPER(IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B23=\"\",\"\",VLOOKUP($B23,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H23=\"\",\"\",VLOOKUP($H23,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H23=\"\",\"\",VLOOKUP($H23,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H23=\"\",\"\",VLOOKUP($H23,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H23=\"\",\"\",VLOOKUP($H23,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[13,null,{"$f":"UPPER(IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B24=\"\",\"\",VLOOKUP($B24,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H24=\"\",\"\",VLOOKUP($H24,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H24=\"\",\"\",VLOOKUP($H24,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H24=\"\",\"\",VLOOKUP($H24,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H24=\"\",\"\",VLOOKUP($H24,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[14,null,{"$f":"UPPER(IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B25=\"\",\"\",VLOOKUP($B25,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H25=\"\",\"\",VLOOKUP($H25,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H25=\"\",\"\",VLOOKUP($H25,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H25=\"\",\"\",VLOOKUP($H25,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H25=\"\",\"\",VLOOKUP($H25,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[15,null,{"$f":"UPPER(IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B26=\"\",\"\",VLOOKUP($B26,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H26=\"\",\"\",VLOOKUP($H26,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H26=\"\",\"\",VLOOKUP($H26,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H26=\"\",\"\",VLOOKUP($H26,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H26=\"\",\"\",VLOOKUP($H26,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[16,null,{"$f":"UPPER(IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B27=\"\",\"\",VLOOKUP($B27,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H27=\"\",\"\",VLOOKUP($H27,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H27=\"\",\"\",VLOOKUP($H27,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H27=\"\",\"\",VLOOKUP($H27,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H27=\"\",\"\",VLOOKUP($H27,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[17,null,{"$f":"UPPER(IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B28=\"\",\"\",VLOOKUP($B28,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H28=\"\",\"\",VLOOKUP($H28,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H28=\"\",\"\",VLOOKUP($H28,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H28=\"\",\"\",VLOOKUP($H28,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H28=\"\",\"\",VLOOKUP($H28,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[18,null,{"$f":"UPPER(IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B29=\"\",\"\",VLOOKUP($B29,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H29=\"\",\"\",VLOOKUP($H29,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H29=\"\",\"\",VLOOKUP($H29,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H29=\"\",\"\",VLOOKUP($H29,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H29=\"\",\"\",VLOOKUP($H29,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[19,null,{"$f":"UPPER(IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B30=\"\",\"\",VLOOKUP($B30,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H30=\"\",\"\",VLOOKUP($H30,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H30=\"\",\"\",VLOOKUP($H30,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H30=\"\",\"\",VLOOKUP($H30,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H30=\"\",\"\",VLOOKUP($H30,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[20,null,{"$f":"UPPER(IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B31=\"\",\"\",VLOOKUP($B31,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H31=\"\",\"\",VLOOKUP($H31,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H31=\"\",\"\",VLOOKUP($H31,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H31=\"\",\"\",VLOOKUP($H31,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H31=\"\",\"\",VLOOKUP($H31,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[21,null,{"$f":"UPPER(IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B32=\"\",\"\",VLOOKUP($B32,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H32=\"\",\"\",VLOOKUP($H32,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H32=\"\",\"\",VLOOKUP($H32,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H32=\"\",\"\",VLOOKUP($H32,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H32=\"\",\"\",VLOOKUP($H32,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[22,null,{"$f":"UPPER(IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B33=\"\",\"\",VLOOKUP($B33,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H33=\"\",\"\",VLOOKUP($H33,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H33=\"\",\"\",VLOOKUP($H33,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H33=\"\",\"\",VLOOKUP($H33,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H33=\"\",\"\",VLOOKUP($H33,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[23,null,{"$f":"UPPER(IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B34=\"\",\"\",VLOOKUP($B34,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H34=\"\",\"\",VLOOKUP($H34,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H34=\"\",\"\",VLOOKUP($H34,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H34=\"\",\"\",VLOOKUP($H34,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H34=\"\",\"\",VLOOKUP($H34,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[24,null,{"$f":"UPPER(IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B35=\"\",\"\",VLOOKUP($B35,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H35=\"\",\"\",VLOOKUP($H35,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H35=\"\",\"\",VLOOKUP($H35,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H35=\"\",\"\",VLOOKUP($H35,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H35=\"\",\"\",VLOOKUP($H35,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[25,null,{"$f":"UPPER(IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B36=\"\",\"\",VLOOKUP($B36,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H36=\"\",\"\",VLOOKUP($H36,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H36=\"\",\"\",VLOOKUP($H36,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H36=\"\",\"\",VLOOKUP($H36,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H36=\"\",\"\",VLOOKUP($H36,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[26,null,{"$f":"UPPER(IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B37=\"\",\"\",VLOOKUP($B37,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H37=\"\",\"\",VLOOKUP($H37,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H37=\"\",\"\",VLOOKUP($H37,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H37=\"\",\"\",VLOOKUP($H37,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H37=\"\",\"\",VLOOKUP($H37,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[27,null,{"$f":"UPPER(IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B38=\"\",\"\",VLOOKUP($B38,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H38=\"\",\"\",VLOOKUP($H38,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H38=\"\",\"\",VLOOKUP($H38,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H38=\"\",\"\",VLOOKUP($H38,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H38=\"\",\"\",VLOOKUP($H38,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[28,null,{"$f":"UPPER(IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B39=\"\",\"\",VLOOKUP($B39,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H39=\"\",\"\",VLOOKUP($H39,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H39=\"\",\"\",VLOOKUP($H39,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H39=\"\",\"\",VLOOKUP($H39,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H39=\"\",\"\",VLOOKUP($H39,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[29,null,{"$f":"UPPER(IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B40=\"\",\"\",VLOOKUP($B40,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H40=\"\",\"\",VLOOKUP($H40,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H40=\"\",\"\",VLOOKUP($H40,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H40=\"\",\"\",VLOOKUP($H40,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H40=\"\",\"\",VLOOKUP($H40,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[30,null,{"$f":"UPPER(IF($B41=\"\",\"\",VLOOKUP($B41,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B41=\"\",\"\",VLOOKUP($B41,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B41=\"\",\"\",VLOOKUP($B41,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B41=\"\",\"\",VLOOKUP($B41,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H41=\"\",\"\",VLOOKUP($H41,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H41=\"\",\"\",VLOOKUP($H41,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H41=\"\",\"\",VLOOKUP($H41,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H41=\"\",\"\",VLOOKUP($H41,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[31,null,{"$f":"UPPER(IF($B42=\"\",\"\",VLOOKUP($B42,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B42=\"\",\"\",VLOOKUP($B42,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B42=\"\",\"\",VLOOKUP($B42,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B42=\"\",\"\",VLOOKUP($B42,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H42=\"\",\"\",VLOOKUP($H42,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H42=\"\",\"\",VLOOKUP($H42,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H42=\"\",\"\",VLOOKUP($H42,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H42=\"\",\"\",VLOOKUP($H42,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[32,null,{"$f":"UPPER(IF($B43=\"\",\"\",VLOOKUP($B43,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B43=\"\",\"\",VLOOKUP($B43,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B43=\"\",\"\",VLOOKUP($B43,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B43=\"\",\"\",VLOOKUP($B43,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H43=\"\",\"\",VLOOKUP($H43,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H43=\"\",\"\",VLOOKUP($H43,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H43=\"\",\"\",VLOOKUP($H43,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H43=\"\",\"\",VLOOKUP($H43,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","DA"]
[33,null,{"$f":"UPPER(IF($B44=\"\",\"\",VLOOKUP($B44,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B44=\"\",\"\",VLOOKUP($B44,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B44=\"\",\"\",VLOOKUP($B44,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B44=\"\",\"\",VLOOKUP($B44,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H44=\"\",\"\",VLOOKUP($H44,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H44=\"\",\"\",VLOOKUP($H44,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H44=\"\",\"\",VLOOKUP($H44,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H44=\"\",\"\",VLOOKUP($H44,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[34,null,{"$f":"UPPER(IF($B45=\"\",\"\",VLOOKUP($B45,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B45=\"\",\"\",VLOOKUP($B45,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B45=\"\",\"\",VLOOKUP($B45,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B45=\"\",\"\",VLOOKUP($B45,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H45=\"\",\"\",VLOOKUP($H45,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H45=\"\",\"\",VLOOKUP($H45,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H45=\"\",\"\",VLOOKUP($H45,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H45=\"\",\"\",VLOOKUP($H45,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[35,null,{"$f":"UPPER(IF($B46=\"\",\"\",VLOOKUP($B46,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B46=\"\",\"\",VLOOKUP($B46,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B46=\"\",\"\",VLOOKUP($B46,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B46=\"\",\"\",VLOOKUP($B46,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H46=\"\",\"\",VLOOKUP($H46,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H46=\"\",\"\",VLOOKUP($H46,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H46=\"\",\"\",VLOOKUP($H46,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H46=\"\",\"\",VLOOKUP($H46,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[36,null,{"$f":"UPPER(IF($B47=\"\",\"\",VLOOKUP($B47,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B47=\"\",\"\",VLOOKUP($B47,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B47=\"\",\"\",VLOOKUP($B47,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B47=\"\",\"\",VLOOKUP($B47,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H47=\"\",\"\",VLOOKUP($H47,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H47=\"\",\"\",VLOOKUP($H47,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H47=\"\",\"\",VLOOKUP($H47,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H47=\"\",\"\",VLOOKUP($H47,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[37,null,{"$f":"UPPER(IF($B48=\"\",\"\",VLOOKUP($B48,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B48=\"\",\"\",VLOOKUP($B48,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B48=\"\",\"\",VLOOKUP($B48,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B48=\"\",\"\",VLOOKUP($B48,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H48=\"\",\"\",VLOOKUP($H48,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H48=\"\",\"\",VLOOKUP($H48,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H48=\"\",\"\",VLOOKUP($H48,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H48=\"\",\"\",VLOOKUP($H48,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[38,null,{"$f":"UPPER(IF($B49=\"\",\"\",VLOOKUP($B49,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B49=\"\",\"\",VLOOKUP($B49,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B49=\"\",\"\",VLOOKUP($B49,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B49=\"\",\"\",VLOOKUP($B49,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H49=\"\",\"\",VLOOKUP($H49,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H49=\"\",\"\",VLOOKUP($H49,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H49=\"\",\"\",VLOOKUP($H49,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H49=\"\",\"\",VLOOKUP($H49,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[39,null,{"$f":"UPPER(IF($B50=\"\",\"\",VLOOKUP($B50,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B50=\"\",\"\",VLOOKUP($B50,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B50=\"\",\"\",VLOOKUP($B50,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B50=\"\",\"\",VLOOKUP($B50,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H50=\"\",\"\",VLOOKUP($H50,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H50=\"\",\"\",VLOOKUP($H50,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H50=\"\",\"\",VLOOKUP($H50,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H50=\"\",\"\",VLOOKUP($H50,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[40,null,{"$f":"UPPER(IF($B51=\"\",\"\",VLOOKUP($B51,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B51=\"\",\"\",VLOOKUP($B51,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B51=\"\",\"\",VLOOKUP($B51,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B51=\"\",\"\",VLOOKUP($B51,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H51=\"\",\"\",VLOOKUP($H51,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H51=\"\",\"\",VLOOKUP($H51,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H51=\"\",\"\",VLOOKUP($H51,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H51=\"\",\"\",VLOOKUP($H51,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[41,null,{"$f":"UPPER(IF($B52=\"\",\"\",VLOOKUP($B52,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B52=\"\",\"\",VLOOKUP($B52,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B52=\"\",\"\",VLOOKUP($B52,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B52=\"\",\"\",VLOOKUP($B52,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H52=\"\",\"\",VLOOKUP($H52,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H52=\"\",\"\",VLOOKUP($H52,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H52=\"\",\"\",VLOOKUP($H52,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H52=\"\",\"\",VLOOKUP($H52,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[42,null,{"$f":"UPPER(IF($B53=\"\",\"\",VLOOKUP($B53,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B53=\"\",\"\",VLOOKUP($B53,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B53=\"\",\"\",VLOOKUP($B53,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B53=\"\",\"\",VLOOKUP($B53,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H53=\"\",\"\",VLOOKUP($H53,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H53=\"\",\"\",VLOOKUP($H53,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H53=\"\",\"\",VLOOKUP($H53,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H53=\"\",\"\",VLOOKUP($H53,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[43,null,{"$f":"UPPER(IF($B54=\"\",\"\",VLOOKUP($B54,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B54=\"\",\"\",VLOOKUP($B54,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B54=\"\",\"\",VLOOKUP($B54,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B54=\"\",\"\",VLOOKUP($B54,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H54=\"\",\"\",VLOOKUP($H54,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H54=\"\",\"\",VLOOKUP($H54,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H54=\"\",\"\",VLOOKUP($H54,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H54=\"\",\"\",VLOOKUP($H54,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[44,null,{"$f":"UPPER(IF($B55=\"\",\"\",VLOOKUP($B55,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B55=\"\",\"\",VLOOKUP($B55,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B55=\"\",\"\",VLOOKUP($B55,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B55=\"\",\"\",VLOOKUP($B55,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H55=\"\",\"\",VLOOKUP($H55,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H55=\"\",\"\",VLOOKUP($H55,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H55=\"\",\"\",VLOOKUP($H55,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H55=\"\",\"\",VLOOKUP($H55,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[45,null,{"$f":"UPPER(IF($B56=\"\",\"\",VLOOKUP($B56,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B56=\"\",\"\",VLOOKUP($B56,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B56=\"\",\"\",VLOOKUP($B56,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B56=\"\",\"\",VLOOKUP($B56,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H56=\"\",\"\",VLOOKUP($H56,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H56=\"\",\"\",VLOOKUP($H56,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H56=\"\",\"\",VLOOKUP($H56,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H56=\"\",\"\",VLOOKUP($H56,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[46,null,{"$f":"UPPER(IF($B57=\"\",\"\",VLOOKUP($B57,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B57=\"\",\"\",VLOOKUP($B57,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B57=\"\",\"\",VLOOKUP($B57,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B57=\"\",\"\",VLOOKUP($B57,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H57=\"\",\"\",VLOOKUP($H57,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H57=\"\",\"\",VLOOKUP($H57,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H57=\"\",\"\",VLOOKUP($H57,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H57=\"\",\"\",VLOOKUP($H57,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[47,null,{"$f":"UPPER(IF($B58=\"\",\"\",VLOOKUP($B58,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B58=\"\",\"\",VLOOKUP($B58,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B58=\"\",\"\",VLOOKUP($B58,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B58=\"\",\"\",VLOOKUP($B58,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H58=\"\",\"\",VLOOKUP($H58,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H58=\"\",\"\",VLOOKUP($H58,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H58=\"\",\"\",VLOOKUP($H58,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H58=\"\",\"\",VLOOKUP($H58,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[48,null,{"$f":"UPPER(IF($B59=\"\",\"\",VLOOKUP($B59,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B59=\"\",\"\",VLOOKUP($B59,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B59=\"\",\"\",VLOOKUP($B59,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B59=\"\",\"\",VLOOKUP($B59,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H59=\"\",\"\",VLOOKUP($H59,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H59=\"\",\"\",VLOOKUP($H59,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H59=\"\",\"\",VLOOKUP($H59,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H59=\"\",\"\",VLOOKUP($H59,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[49,null,{"$f":"UPPER(IF($B60=\"\",\"\",VLOOKUP($B60,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B60=\"\",\"\",VLOOKUP($B60,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B60=\"\",\"\",VLOOKUP($B60,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B60=\"\",\"\",VLOOKUP($B60,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H60=\"\",\"\",VLOOKUP($H60,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H60=\"\",\"\",VLOOKUP($H60,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H60=\"\",\"\",VLOOKUP($H60,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H60=\"\",\"\",VLOOKUP($H60,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]
[50,null,{"$f":"UPPER(IF($B61=\"\",\"\",VLOOKUP($B61,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($B61=\"\",\"\",VLOOKUP($B61,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($B61=\"\",\"\",VLOOKUP($B61,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($B61=\"\",\"\",VLOOKUP($B61,[1]Codigos!$A$5:$F$9000,6)))","v":""},null,{"$f":"UPPER(IF($H61=\"\",\"\",VLOOKUP($H61,[1]Codigos!$A$5:$F$9000,2)))","v":""},{"$f":"UPPER(IF($H61=\"\",\"\",VLOOKUP($H61,[1]Codigos!$A$5:$F$9000,3)))","v":""},{"$f":"IF($H61=\"\",\"\",VLOOKUP($H61,[1]Codigos!$A$5:$F$9000,4))","v":""},null,{"$f":"UPPER(IF($H61=\"\",\"\",VLOOKUP($H61,[1]Codigos!$A$5:$F$9000,6)))","v":""},"D","","","ALT"]

{"sheet":"Prep. Principal D","index":10,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"LISTA DE PREPARACION DE DOBLES CUADRO PRINCIPAL"]
[]
[]
["Torneo",null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"},"Clase",null,{"$f":"Maestra!E10","v":"GRADO 2"},null,"Categoría",null,null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[]
["Sede",null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"},"Ciudad",null,{"$f":"Maestra!E14","v":"MEDELLIN"},null,"Fecha",null,null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[]
["Supervisor FCT",null,{"$f":"Maestra!A18","v":"ESTEBAN JIMENEZ"}]
[]
[null,null,"Jugador 1",null,null,null,null,"Jugador 2",null,null,null,null,null,"Equipo"]
["Línea","Apellido y Nombre","Liga","Fecha de Nacimiento D/M/A","Rank. Entrada","Puntos","Apellido y Nombre","Liga","Fecha de Nacimiento D/M/A","Rank. Entrada","Puntos","Aceptación","Rank. Combinado","Rank. Sencillo","Status"]
[1,{"$f":"'Listado D'!C12","v":""},{"$f":"'Listado D'!D12","v":""},{"$f":"'Listado D'!E12","v":""},{"$f":"'Listado D'!F12","v":0},null,{"$f":"'Listado D'!I12","v":""},{"$f":"'Listado D'!J12","v":""},{"$f":"'Listado D'!K12","v":""},{"$f":"'Listado D'!L12","v":0},null,"A",{"$f":"'Listado D'!O12","v":""},{"$f":"'Listado D'!P12","v":""},{"$f":"'Listado D'!Q12","v":"DA"}]
[2,{"$f":"'Listado D'!C13","v":""},{"$f":"'Listado D'!D13","v":""},{"$f":"'Listado D'!E13","v":""},{"$f":"'Listado D'!F13","v":0},null,{"$f":"'Listado D'!I13","v":""},{"$f":"'Listado D'!J13","v":""},{"$f":"'Listado D'!K13","v":""},{"$f":"'Listado D'!L13","v":0},null,"A",{"$f":"'Listado D'!O13","v":""},{"$f":"'Listado D'!P13","v":""},{"$f":"'Listado D'!Q13","v":"DA"}]
[3,{"$f":"'Listado D'!C14","v":""},{"$f":"'Listado D'!D14","v":""},{"$f":"'Listado D'!E14","v":""},{"$f":"'Listado D'!F14","v":0},null,{"$f":"'Listado D'!I14","v":""},{"$f":"'Listado D'!J14","v":""},{"$f":"'Listado D'!K14","v":""},{"$f":"'Listado D'!L14","v":0},null,"A",{"$f":"'Listado D'!O14","v":""},{"$f":"'Listado D'!P14","v":""},{"$f":"'Listado D'!Q14","v":"DA"}]
[4,{"$f":"'Listado D'!C15","v":""},{"$f":"'Listado D'!D15","v":""},{"$f":"'Listado D'!E15","v":""},{"$f":"'Listado D'!F15","v":0},null,{"$f":"'Listado D'!I15","v":""},{"$f":"'Listado D'!J15","v":""},{"$f":"'Listado D'!K15","v":""},{"$f":"'Listado D'!L15","v":0},null,"A",{"$f":"'Listado D'!O15","v":""},{"$f":"'Listado D'!P15","v":""},{"$f":"'Listado D'!Q15","v":"DA"}]
[5,{"$f":"'Listado D'!C16","v":""},{"$f":"'Listado D'!D16","v":""},{"$f":"'Listado D'!E16","v":""},{"$f":"'Listado D'!F16","v":0},null,{"$f":"'Listado D'!I16","v":""},{"$f":"'Listado D'!J16","v":""},{"$f":"'Listado D'!K16","v":""},{"$f":"'Listado D'!L16","v":0},null,"A",{"$f":"'Listado D'!O16","v":""},{"$f":"'Listado D'!P16","v":""},{"$f":"'Listado D'!Q16","v":"DA"}]
[6,{"$f":"'Listado D'!C17","v":""},{"$f":"'Listado D'!D17","v":""},{"$f":"'Listado D'!E17","v":""},{"$f":"'Listado D'!F17","v":0},null,{"$f":"'Listado D'!I17","v":""},{"$f":"'Listado D'!J17","v":""},{"$f":"'Listado D'!K17","v":""},{"$f":"'Listado D'!L17","v":0},null,"A",{"$f":"'Listado D'!O17","v":""},{"$f":"'Listado D'!P17","v":""},{"$f":"'Listado D'!Q17","v":"DA"}]
[7,{"$f":"'Listado D'!C18","v":""},{"$f":"'Listado D'!D18","v":""},{"$f":"'Listado D'!E18","v":""},{"$f":"'Listado D'!F18","v":0},null,{"$f":"'Listado D'!I18","v":""},{"$f":"'Listado D'!J18","v":""},{"$f":"'Listado D'!K18","v":""},{"$f":"'Listado D'!L18","v":0},null,"A",{"$f":"'Listado D'!O18","v":""},{"$f":"'Listado D'!P18","v":""},{"$f":"'Listado D'!Q18","v":"DA"}]
[8,{"$f":"'Listado D'!C19","v":""},{"$f":"'Listado D'!D19","v":""},{"$f":"'Listado D'!E19","v":""},{"$f":"'Listado D'!F19","v":0},null,{"$f":"'Listado D'!I19","v":""},{"$f":"'Listado D'!J19","v":""},{"$f":"'Listado D'!K19","v":""},{"$f":"'Listado D'!L19","v":0},null,"A",{"$f":"'Listado D'!O19","v":""},{"$f":"'Listado D'!P19","v":""},{"$f":"'Listado D'!Q19","v":"DA"}]
[9,{"$f":"'Listado D'!C20","v":""},{"$f":"'Listado D'!D20","v":""},{"$f":"'Listado D'!E20","v":""},{"$f":"'Listado D'!F20","v":0},null,{"$f":"'Listado D'!I20","v":""},{"$f":"'Listado D'!J20","v":""},{"$f":"'Listado D'!K20","v":""},{"$f":"'Listado D'!L20","v":0},null,"A",{"$f":"'Listado D'!O20","v":""},{"$f":"'Listado D'!P20","v":""},{"$f":"'Listado D'!Q20","v":"DA"}]
[10,{"$f":"'Listado D'!C21","v":""},{"$f":"'Listado D'!D21","v":""},{"$f":"'Listado D'!E21","v":""},{"$f":"'Listado D'!F21","v":0},null,{"$f":"'Listado D'!I21","v":""},{"$f":"'Listado D'!J21","v":""},{"$f":"'Listado D'!K21","v":""},{"$f":"'Listado D'!L21","v":0},null,"A",{"$f":"'Listado D'!O21","v":""},{"$f":"'Listado D'!P21","v":""},{"$f":"'Listado D'!Q21","v":"DA"}]
[11,{"$f":"'Listado D'!C22","v":""},{"$f":"'Listado D'!D22","v":""},{"$f":"'Listado D'!E22","v":""},{"$f":"'Listado D'!F22","v":0},null,{"$f":"'Listado D'!I22","v":""},{"$f":"'Listado D'!J22","v":""},{"$f":"'Listado D'!K22","v":""},{"$f":"'Listado D'!L22","v":0},null,"A",{"$f":"'Listado D'!O22","v":""},{"$f":"'Listado D'!P22","v":""},{"$f":"'Listado D'!Q22","v":"DA"}]
[12,{"$f":"'Listado D'!C23","v":""},{"$f":"'Listado D'!D23","v":""},{"$f":"'Listado D'!E23","v":""},{"$f":"'Listado D'!F23","v":0},null,{"$f":"'Listado D'!I23","v":""},{"$f":"'Listado D'!J23","v":""},{"$f":"'Listado D'!K23","v":""},{"$f":"'Listado D'!L23","v":0},null,"A",{"$f":"'Listado D'!O23","v":""},{"$f":"'Listado D'!P23","v":""},{"$f":"'Listado D'!Q23","v":"DA"}]
[13,{"$f":"'Listado D'!C24","v":""},{"$f":"'Listado D'!D24","v":""},{"$f":"'Listado D'!E24","v":""},{"$f":"'Listado D'!F24","v":0},null,{"$f":"'Listado D'!I24","v":""},{"$f":"'Listado D'!J24","v":""},{"$f":"'Listado D'!K24","v":""},{"$f":"'Listado D'!L24","v":0},null,"A",{"$f":"'Listado D'!O24","v":""},{"$f":"'Listado D'!P24","v":""},{"$f":"'Listado D'!Q24","v":"DA"}]
[14,{"$f":"'Listado D'!C25","v":""},{"$f":"'Listado D'!D25","v":""},{"$f":"'Listado D'!E25","v":""},{"$f":"'Listado D'!F25","v":0},null,{"$f":"'Listado D'!I25","v":""},{"$f":"'Listado D'!J25","v":""},{"$f":"'Listado D'!K25","v":""},{"$f":"'Listado D'!L25","v":0},null,"A",{"$f":"'Listado D'!O25","v":""},{"$f":"'Listado D'!P25","v":""},{"$f":"'Listado D'!Q25","v":"DA"}]
[15,{"$f":"'Listado D'!C26","v":""},{"$f":"'Listado D'!D26","v":""},{"$f":"'Listado D'!E26","v":""},{"$f":"'Listado D'!F26","v":0},null,{"$f":"'Listado D'!I26","v":""},{"$f":"'Listado D'!J26","v":""},{"$f":"'Listado D'!K26","v":""},{"$f":"'Listado D'!L26","v":0},null,"A",{"$f":"'Listado D'!O26","v":""},{"$f":"'Listado D'!P26","v":""},{"$f":"'Listado D'!Q26","v":"DA"}]
[16,{"$f":"'Listado D'!C27","v":""},{"$f":"'Listado D'!D27","v":""},{"$f":"'Listado D'!E27","v":""},{"$f":"'Listado D'!F27","v":0},null,{"$f":"'Listado D'!I27","v":""},{"$f":"'Listado D'!J27","v":""},{"$f":"'Listado D'!K27","v":""},{"$f":"'Listado D'!L27","v":0},null,"A",{"$f":"'Listado D'!O27","v":""},{"$f":"'Listado D'!P27","v":""},{"$f":"'Listado D'!Q27","v":"DA"}]
[17,{"$f":"'Listado D'!C28","v":""},{"$f":"'Listado D'!D28","v":""},{"$f":"'Listado D'!E28","v":""},{"$f":"'Listado D'!F28","v":0},null,{"$f":"'Listado D'!I28","v":""},{"$f":"'Listado D'!J28","v":""},{"$f":"'Listado D'!K28","v":""},{"$f":"'Listado D'!L28","v":0},null,"A",{"$f":"'Listado D'!O28","v":""},{"$f":"'Listado D'!P28","v":""},{"$f":"'Listado D'!Q28","v":"DA"}]
[18,{"$f":"'Listado D'!C29","v":""},{"$f":"'Listado D'!D29","v":""},{"$f":"'Listado D'!E29","v":""},{"$f":"'Listado D'!F29","v":0},null,{"$f":"'Listado D'!I29","v":""},{"$f":"'Listado D'!J29","v":""},{"$f":"'Listado D'!K29","v":""},{"$f":"'Listado D'!L29","v":0},null,"A",{"$f":"'Listado D'!O29","v":""},{"$f":"'Listado D'!P29","v":""},{"$f":"'Listado D'!Q29","v":"DA"}]
[19,{"$f":"'Listado D'!C30","v":""},{"$f":"'Listado D'!D30","v":""},{"$f":"'Listado D'!E30","v":""},{"$f":"'Listado D'!F30","v":0},null,{"$f":"'Listado D'!I30","v":""},{"$f":"'Listado D'!J30","v":""},{"$f":"'Listado D'!K30","v":""},{"$f":"'Listado D'!L30","v":0},null,"A",{"$f":"'Listado D'!O30","v":""},{"$f":"'Listado D'!P30","v":""},{"$f":"'Listado D'!Q30","v":"DA"}]
[20,{"$f":"'Listado D'!C31","v":""},{"$f":"'Listado D'!D31","v":""},{"$f":"'Listado D'!E31","v":""},{"$f":"'Listado D'!F31","v":0},null,{"$f":"'Listado D'!I31","v":""},{"$f":"'Listado D'!J31","v":""},{"$f":"'Listado D'!K31","v":""},{"$f":"'Listado D'!L31","v":0},null,"A",{"$f":"'Listado D'!O31","v":""},{"$f":"'Listado D'!P31","v":""},{"$f":"'Listado D'!Q31","v":"DA"}]
[21,{"$f":"'Listado D'!C32","v":""},{"$f":"'Listado D'!D32","v":""},{"$f":"'Listado D'!E32","v":""},{"$f":"'Listado D'!F32","v":0},null,{"$f":"'Listado D'!I32","v":""},{"$f":"'Listado D'!J32","v":""},{"$f":"'Listado D'!K32","v":""},{"$f":"'Listado D'!L32","v":0},null,"A",{"$f":"'Listado D'!O32","v":""},{"$f":"'Listado D'!P32","v":""},{"$f":"'Listado D'!Q32","v":"DA"}]
[22,{"$f":"'Listado D'!C33","v":""},{"$f":"'Listado D'!D33","v":""},{"$f":"'Listado D'!E33","v":""},{"$f":"'Listado D'!F33","v":0},null,{"$f":"'Listado D'!I33","v":""},{"$f":"'Listado D'!J33","v":""},{"$f":"'Listado D'!K33","v":""},{"$f":"'Listado D'!L33","v":0},null,"A",{"$f":"'Listado D'!O33","v":""},{"$f":"'Listado D'!P33","v":""},{"$f":"'Listado D'!Q33","v":"DA"}]
[23,{"$f":"'Listado D'!C34","v":""},{"$f":"'Listado D'!D34","v":""},{"$f":"'Listado D'!E34","v":""},{"$f":"'Listado D'!F34","v":0},null,{"$f":"'Listado D'!I34","v":""},{"$f":"'Listado D'!J34","v":""},{"$f":"'Listado D'!K34","v":""},{"$f":"'Listado D'!L34","v":0},null,"A",{"$f":"'Listado D'!O34","v":""},{"$f":"'Listado D'!P34","v":""},{"$f":"'Listado D'!Q34","v":"DA"}]
[24,{"$f":"'Listado D'!C35","v":""},{"$f":"'Listado D'!D35","v":""},{"$f":"'Listado D'!E35","v":""},{"$f":"'Listado D'!F35","v":0},null,{"$f":"'Listado D'!I35","v":""},{"$f":"'Listado D'!J35","v":""},{"$f":"'Listado D'!K35","v":""},{"$f":"'Listado D'!L35","v":0},null,"A",{"$f":"'Listado D'!O35","v":""},{"$f":"'Listado D'!P35","v":""},{"$f":"'Listado D'!Q35","v":"DA"}]
[25,{"$f":"'Listado D'!C36","v":""},{"$f":"'Listado D'!D36","v":""},{"$f":"'Listado D'!E36","v":""},{"$f":"'Listado D'!F36","v":0},null,{"$f":"'Listado D'!I36","v":""},{"$f":"'Listado D'!J36","v":""},{"$f":"'Listado D'!K36","v":""},{"$f":"'Listado D'!L36","v":0},null,"A",{"$f":"'Listado D'!O36","v":""},{"$f":"'Listado D'!P36","v":""},{"$f":"'Listado D'!Q36","v":"DA"}]
[26,{"$f":"'Listado D'!C37","v":""},{"$f":"'Listado D'!D37","v":""},{"$f":"'Listado D'!E37","v":""},{"$f":"'Listado D'!F37","v":0},null,{"$f":"'Listado D'!I37","v":""},{"$f":"'Listado D'!J37","v":""},{"$f":"'Listado D'!K37","v":""},{"$f":"'Listado D'!L37","v":0},null,"A",{"$f":"'Listado D'!O37","v":""},{"$f":"'Listado D'!P37","v":""},{"$f":"'Listado D'!Q37","v":"DA"}]
[27,{"$f":"'Listado D'!C38","v":""},{"$f":"'Listado D'!D38","v":""},{"$f":"'Listado D'!E38","v":""},{"$f":"'Listado D'!F38","v":0},null,{"$f":"'Listado D'!I38","v":""},{"$f":"'Listado D'!J38","v":""},{"$f":"'Listado D'!K38","v":""},{"$f":"'Listado D'!L38","v":0},null,"A",{"$f":"'Listado D'!O38","v":""},{"$f":"'Listado D'!P38","v":""},{"$f":"'Listado D'!Q38","v":"DA"}]
[28,{"$f":"'Listado D'!C39","v":""},{"$f":"'Listado D'!D39","v":""},{"$f":"'Listado D'!E39","v":""},{"$f":"'Listado D'!F39","v":0},null,{"$f":"'Listado D'!I39","v":""},{"$f":"'Listado D'!J39","v":""},{"$f":"'Listado D'!K39","v":""},{"$f":"'Listado D'!L39","v":0},null,"A",{"$f":"'Listado D'!O39","v":""},{"$f":"'Listado D'!P39","v":""},{"$f":"'Listado D'!Q39","v":"DA"}]
[29,{"$f":"'Listado D'!C40","v":""},{"$f":"'Listado D'!D40","v":""},{"$f":"'Listado D'!E40","v":""},{"$f":"'Listado D'!F40","v":0},null,{"$f":"'Listado D'!I40","v":""},{"$f":"'Listado D'!J40","v":""},{"$f":"'Listado D'!K40","v":""},{"$f":"'Listado D'!L40","v":0},null,"A",{"$f":"'Listado D'!O40","v":""},{"$f":"'Listado D'!P40","v":""},{"$f":"'Listado D'!Q40","v":"DA"}]
[30,{"$f":"'Listado D'!C41","v":""},{"$f":"'Listado D'!D41","v":""},{"$f":"'Listado D'!E41","v":""},{"$f":"'Listado D'!F41","v":0},null,{"$f":"'Listado D'!I41","v":""},{"$f":"'Listado D'!J41","v":""},{"$f":"'Listado D'!K41","v":""},{"$f":"'Listado D'!L41","v":0},null,"A",{"$f":"'Listado D'!O41","v":""},{"$f":"'Listado D'!P41","v":""},{"$f":"'Listado D'!Q41","v":"DA"}]
[31,{"$f":"'Listado D'!C42","v":""},{"$f":"'Listado D'!D42","v":""},{"$f":"'Listado D'!E42","v":""},{"$f":"'Listado D'!F42","v":0},null,{"$f":"'Listado D'!I42","v":""},{"$f":"'Listado D'!J42","v":""},{"$f":"'Listado D'!K42","v":""},{"$f":"'Listado D'!L42","v":0},null,"A",{"$f":"'Listado D'!O42","v":""},{"$f":"'Listado D'!P42","v":""},{"$f":"'Listado D'!Q42","v":"DA"}]
[32,{"$f":"'Listado D'!C43","v":""},{"$f":"'Listado D'!D43","v":""},{"$f":"'Listado D'!E43","v":""},{"$f":"'Listado D'!F43","v":0},null,{"$f":"'Listado D'!I43","v":""},{"$f":"'Listado D'!J43","v":""},{"$f":"'Listado D'!K43","v":""},{"$f":"'Listado D'!L43","v":0},null,"A",{"$f":"'Listado D'!O43","v":""},{"$f":"'Listado D'!P43","v":""},{"$f":"'Listado D'!Q43","v":"DA"}]

{"sheet":"Principal D","index":11,"n_rows":87,"n_cols":16,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DOBLES CUADRO PRINCIPAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Categoria",null,{"$f":"Maestra!H10","v":"18 MASCULINO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Torneo",null,{"$f":"Maestra!A10","v":"COPA CLUB EL RODEO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ciudad",null,{"$f":"Maestra!E14","v":"MEDELLIN"}]
[{"$f":"Maestra!E10","v":"GRADO 2"},null,null,null,null,null,null,null,null,null,null,null,null,"Fecha",null,{"$f":"Maestra!H14","v":"MAYO 7 AL 11"}]
[1,{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D6,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D6=\"\",\"\",VLOOKUP($D6,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D6=\"\",\"\",VLOOKUP($D6,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D6=\"\",\"\",VLOOKUP($D6,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I7=\"a\",E6,IF(I7=\"b\",E8,\"\"))","v":""},null,null,null,"Sede",null,{"$f":"Maestra!A14","v":"CLUB EL RODEO"}]
[null,null,null,null,{"$f":"UPPER(IF($D6=\"\",\"\",VLOOKUP($D6,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D6=\"\",\"\",VLOOKUP($D6,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I7=\"a\",E7,IF(I7=\"b\",E9,\"\"))","v":""}]
[2,{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D8,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D8=\"\",\"\",VLOOKUP($D8,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D8=\"\",\"\",VLOOKUP($D8,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D8=\"\",\"\",VLOOKUP($D8,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,{"$f":"IF(K9=\"a\",J6,IF(K9=\"b\",J10,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D8=\"\",\"\",VLOOKUP($D8,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D8=\"\",\"\",VLOOKUP($D8,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K9=\"a\",J7,IF(K9=\"b\",J11,\"\"))","v":""}]
[3,{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D10,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D10=\"\",\"\",VLOOKUP($D10,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D10=\"\",\"\",VLOOKUP($D10,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D10=\"\",\"\",VLOOKUP($D10,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I11=\"a\",E10,IF(I11=\"b\",E12,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D10=\"\",\"\",VLOOKUP($D10,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D10=\"\",\"\",VLOOKUP($D10,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I11=\"a\",E11,IF(I11=\"b\",E13,\"\"))","v":""}]
[4,{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D12,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D12=\"\",\"\",VLOOKUP($D12,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D12=\"\",\"\",VLOOKUP($D12,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D12=\"\",\"\",VLOOKUP($D12,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,null,null,{"$f":"IF(M13=\"a\",L8,IF(M13=\"b\",L16,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D12=\"\",\"\",VLOOKUP($D12,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D12=\"\",\"\",VLOOKUP($D12,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K14=\"a\",J9,IF(K14=\"b\",J17,\"\"))","v":""},null,{"$f":"IF(M13=\"a\",L9,IF(M13=\"b\",L17,\"\"))","v":""}]
[5,{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D14,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D14=\"\",\"\",VLOOKUP($D14,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D14=\"\",\"\",VLOOKUP($D14,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D14=\"\",\"\",VLOOKUP($D14,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I15=\"a\",E14,IF(I15=\"b\",E16,\"\"))","v":""},null,{"$f":"IF(K14=\"a\",J10,IF(K14=\"b\",J18,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D14=\"\",\"\",VLOOKUP($D14,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D14=\"\",\"\",VLOOKUP($D14,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I15=\"a\",E15,IF(I15=\"b\",E17,\"\"))","v":""}]
[6,{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D16,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D16=\"\",\"\",VLOOKUP($D16,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D16=\"\",\"\",VLOOKUP($D16,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D16=\"\",\"\",VLOOKUP($D16,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,{"$f":"IF(K17=\"a\",J14,IF(K17=\"b\",J18,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D16=\"\",\"\",VLOOKUP($D16,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D16=\"\",\"\",VLOOKUP($D16,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K17=\"a\",J15,IF(K17=\"b\",J19,\"\"))","v":""}]
[7,{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D18,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D18=\"\",\"\",VLOOKUP($D18,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D18=\"\",\"\",VLOOKUP($D18,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D18=\"\",\"\",VLOOKUP($D18,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I19=\"a\",E18,IF(I19=\"b\",E20,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D18=\"\",\"\",VLOOKUP($D18,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D18=\"\",\"\",VLOOKUP($D18,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I19=\"a\",E19,IF(I19=\"b\",E21,\"\"))","v":""}]
[8,{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D20,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D20=\"\",\"\",VLOOKUP($D20,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D20=\"\",\"\",VLOOKUP($D20,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D20=\"\",\"\",VLOOKUP($D20,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,null,null,null,null,{"$f":"IF(O21=\"a\",N12,IF(O21=\"b\",N28,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D20=\"\",\"\",VLOOKUP($D20,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D20=\"\",\"\",VLOOKUP($D20,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,null,null,{"$f":"IF(M22=\"a\",L13,IF(M22=\"b\",L29,\"\"))","v":""},null,{"$f":"IF(O21=\"a\",N13,IF(O21=\"b\",N29,\"\"))","v":""}]
[9,{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D22,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D22=\"\",\"\",VLOOKUP($D22,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D22=\"\",\"\",VLOOKUP($D22,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D22=\"\",\"\",VLOOKUP($D22,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I23=\"a\",E22,IF(I23=\"b\",E24,\"\"))","v":""},null,null,null,{"$f":"IF(M22=\"a\",L14,IF(M22=\"b\",L30,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D22=\"\",\"\",VLOOKUP($D22,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D22=\"\",\"\",VLOOKUP($D22,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I23=\"a\",E23,IF(I23=\"b\",E25,\"\"))","v":""}]
[10,{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D24,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D24=\"\",\"\",VLOOKUP($D24,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D24=\"\",\"\",VLOOKUP($D24,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D24=\"\",\"\",VLOOKUP($D24,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,{"$f":"IF(K25=\"a\",J22,IF(K25=\"b\",J26,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D24=\"\",\"\",VLOOKUP($D24,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D24=\"\",\"\",VLOOKUP($D24,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K25=\"a\",J23,IF(K25=\"b\",J27,\"\"))","v":""}]
[11,{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D26,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D26=\"\",\"\",VLOOKUP($D26,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D26=\"\",\"\",VLOOKUP($D26,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D26=\"\",\"\",VLOOKUP($D26,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I27=\"a\",E26,IF(I27=\"b\",E28,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D26=\"\",\"\",VLOOKUP($D26,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D26=\"\",\"\",VLOOKUP($D26,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I27=\"a\",E27,IF(I27=\"b\",E29,\"\"))","v":""}]
[12,{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D28,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D28=\"\",\"\",VLOOKUP($D28,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D28=\"\",\"\",VLOOKUP($D28,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D28=\"\",\"\",VLOOKUP($D28,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,null,null,{"$f":"IF(M29=\"a\",L24,IF(M29=\"b\",L32,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D28=\"\",\"\",VLOOKUP($D28,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D28=\"\",\"\",VLOOKUP($D28,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K30=\"a\",J25,IF(K30=\"b\",J33,\"\"))","v":""},null,{"$f":"IF(M29=\"a\",L25,IF(M29=\"b\",L33,\"\"))","v":""}]
[13,{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D30,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D30=\"\",\"\",VLOOKUP($D30,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D30=\"\",\"\",VLOOKUP($D30,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D30=\"\",\"\",VLOOKUP($D30,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I31=\"a\",E30,IF(I31=\"b\",E32,\"\"))","v":""},null,{"$f":"IF(K30=\"a\",J26,IF(K30=\"b\",J34,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D30=\"\",\"\",VLOOKUP($D30,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D30=\"\",\"\",VLOOKUP($D30,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I31=\"a\",E31,IF(I31=\"b\",E33,\"\"))","v":""}]
[14,{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D32,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D32=\"\",\"\",VLOOKUP($D32,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D32=\"\",\"\",VLOOKUP($D32,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D32=\"\",\"\",VLOOKUP($D32,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,{"$f":"IF(K33=\"a\",J30,IF(K33=\"b\",J34,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D32=\"\",\"\",VLOOKUP($D32,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D32=\"\",\"\",VLOOKUP($D32,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K33=\"a\",J31,IF(K33=\"b\",J35,\"\"))","v":""}]
[15,{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D34,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D34=\"\",\"\",VLOOKUP($D34,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D34=\"\",\"\",VLOOKUP($D34,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D34=\"\",\"\",VLOOKUP($D34,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I35=\"a\",E34,IF(I35=\"b\",E36,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D34=\"\",\"\",VLOOKUP($D34,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D34=\"\",\"\",VLOOKUP($D34,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I35=\"a\",E35,IF(I35=\"b\",E37,\"\"))","v":""}]
[16,{"$f":"IF($D36=\"\",\"\",IF(VLOOKUP($D36,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D36,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D36=\"\",\"\",VLOOKUP($D36,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D36=\"\",\"\",VLOOKUP($D36,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D36=\"\",\"\",VLOOKUP($D36,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,null,null,null,null,{"$f":"IF(O37=\"a\",P20,IF(O37=\"b\",P52,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D36=\"\",\"\",VLOOKUP($D36,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D36=\"\",\"\",VLOOKUP($D36,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,null,null,"CAMPEONES",null,{"$f":"IF(O37=\"a\",P21,IF(O37=\"b\",P53,\"\"))","v":""}]
[17,{"$f":"IF($D38=\"\",\"\",IF(VLOOKUP($D38,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D38,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D38=\"\",\"\",VLOOKUP($D38,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D38=\"\",\"\",VLOOKUP($D38,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D38=\"\",\"\",VLOOKUP($D38,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I39=\"a\",E38,IF(I39=\"b\",E40,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D38=\"\",\"\",VLOOKUP($D38,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D38=\"\",\"\",VLOOKUP($D38,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I39=\"a\",E39,IF(I39=\"b\",E41,\"\"))","v":""}]
[18,{"$f":"IF($D40=\"\",\"\",IF(VLOOKUP($D40,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D40,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D40=\"\",\"\",VLOOKUP($D40,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D40=\"\",\"\",VLOOKUP($D40,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D40=\"\",\"\",VLOOKUP($D40,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,{"$f":"IF(K41=\"a\",J38,IF(K41=\"b\",J42,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D40=\"\",\"\",VLOOKUP($D40,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D40=\"\",\"\",VLOOKUP($D40,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K41=\"a\",J39,IF(K41=\"b\",J43,\"\"))","v":""}]
[19,{"$f":"IF($D42=\"\",\"\",IF(VLOOKUP($D42,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D42,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D42=\"\",\"\",VLOOKUP($D42,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D42=\"\",\"\",VLOOKUP($D42,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D42=\"\",\"\",VLOOKUP($D42,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I43=\"a\",E42,IF(I43=\"b\",E44,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D42=\"\",\"\",VLOOKUP($D42,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D42=\"\",\"\",VLOOKUP($D42,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I43=\"a\",E43,IF(I43=\"b\",E45,\"\"))","v":""}]
[20,{"$f":"IF($D44=\"\",\"\",IF(VLOOKUP($D44,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D44,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D44=\"\",\"\",VLOOKUP($D44,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D44=\"\",\"\",VLOOKUP($D44,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D44=\"\",\"\",VLOOKUP($D44,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,null,null,{"$f":"IF(M45=\"a\",L40,IF(M45=\"b\",L48,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D44=\"\",\"\",VLOOKUP($D44,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D44=\"\",\"\",VLOOKUP($D44,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K46=\"a\",J41,IF(K46=\"b\",J49,\"\"))","v":""},null,{"$f":"IF(M45=\"a\",L41,IF(M45=\"b\",L49,\"\"))","v":""}]
[21,{"$f":"IF($D46=\"\",\"\",IF(VLOOKUP($D46,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D46,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D46=\"\",\"\",VLOOKUP($D46,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D46=\"\",\"\",VLOOKUP($D46,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D46=\"\",\"\",VLOOKUP($D46,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I47=\"a\",E46,IF(I47=\"b\",E48,\"\"))","v":""},null,{"$f":"IF(K46=\"a\",J42,IF(K46=\"b\",J50,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D46=\"\",\"\",VLOOKUP($D46,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D46=\"\",\"\",VLOOKUP($D46,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I47=\"a\",E47,IF(I47=\"b\",E49,\"\"))","v":""}]
[22,{"$f":"IF($D48=\"\",\"\",IF(VLOOKUP($D48,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D48,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D48=\"\",\"\",VLOOKUP($D48,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D48=\"\",\"\",VLOOKUP($D48,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D48=\"\",\"\",VLOOKUP($D48,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,{"$f":"IF(K49=\"a\",J46,IF(K49=\"b\",J50,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D48=\"\",\"\",VLOOKUP($D48,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D48=\"\",\"\",VLOOKUP($D48,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K49=\"a\",J47,IF(K49=\"b\",J51,\"\"))","v":""}]
[23,{"$f":"IF($D50=\"\",\"\",IF(VLOOKUP($D50,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D50,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D50=\"\",\"\",VLOOKUP($D50,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D50=\"\",\"\",VLOOKUP($D50,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D50=\"\",\"\",VLOOKUP($D50,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I51=\"a\",E50,IF(I51=\"b\",E52,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D50=\"\",\"\",VLOOKUP($D50,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D50=\"\",\"\",VLOOKUP($D50,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I51=\"a\",E51,IF(I51=\"b\",E53,\"\"))","v":""}]
[24,{"$f":"IF($D52=\"\",\"\",IF(VLOOKUP($D52,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D52,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D52=\"\",\"\",VLOOKUP($D52,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D52=\"\",\"\",VLOOKUP($D52,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D52=\"\",\"\",VLOOKUP($D52,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,null,null,null,null,{"$f":"IF(O53=\"a\",N44,IF(O53=\"b\",N60,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D52=\"\",\"\",VLOOKUP($D52,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D52=\"\",\"\",VLOOKUP($D52,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,null,null,{"$f":"IF(M54=\"a\",L45,IF(M54=\"b\",L61,\"\"))","v":""},null,{"$f":"IF(O53=\"a\",N45,IF(O53=\"b\",N61,\"\"))","v":""}]
[25,{"$f":"IF($D54=\"\",\"\",IF(VLOOKUP($D54,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D54,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D54=\"\",\"\",VLOOKUP($D54,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D54=\"\",\"\",VLOOKUP($D54,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D54=\"\",\"\",VLOOKUP($D54,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I55=\"a\",E54,IF(I55=\"b\",E56,\"\"))","v":""},null,null,null,{"$f":"IF(M54=\"a\",L46,IF(M54=\"b\",L62,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D54=\"\",\"\",VLOOKUP($D54,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D54=\"\",\"\",VLOOKUP($D54,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I55=\"a\",E55,IF(I55=\"b\",E57,\"\"))","v":""}]
[26,{"$f":"IF($D56=\"\",\"\",IF(VLOOKUP($D56,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D56,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D56=\"\",\"\",VLOOKUP($D56,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D56=\"\",\"\",VLOOKUP($D56,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D56=\"\",\"\",VLOOKUP($D56,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,{"$f":"IF(K57=\"a\",J54,IF(K57=\"b\",J58,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D56=\"\",\"\",VLOOKUP($D56,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D56=\"\",\"\",VLOOKUP($D56,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K57=\"a\",J55,IF(K57=\"b\",J59,\"\"))","v":""}]
[27,{"$f":"IF($D58=\"\",\"\",IF(VLOOKUP($D58,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D58,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D58=\"\",\"\",VLOOKUP($D58,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D58=\"\",\"\",VLOOKUP($D58,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D58=\"\",\"\",VLOOKUP($D58,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I59=\"a\",E58,IF(I59=\"b\",E60,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D58=\"\",\"\",VLOOKUP($D58,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D58=\"\",\"\",VLOOKUP($D58,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I59=\"a\",E59,IF(I59=\"b\",E61,\"\"))","v":""}]
[28,{"$f":"IF($D60=\"\",\"\",IF(VLOOKUP($D60,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D60,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D60=\"\",\"\",VLOOKUP($D60,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D60=\"\",\"\",VLOOKUP($D60,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D60=\"\",\"\",VLOOKUP($D60,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,null,null,{"$f":"IF(M61=\"a\",L56,IF(M61=\"b\",L64,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D60=\"\",\"\",VLOOKUP($D60,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D60=\"\",\"\",VLOOKUP($D60,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K62=\"a\",J57,IF(K62=\"b\",J65,\"\"))","v":""},null,{"$f":"IF(M61=\"a\",L57,IF(M61=\"b\",L65,\"\"))","v":""}]
[29,{"$f":"IF($D62=\"\",\"\",IF(VLOOKUP($D62,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D62,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D62=\"\",\"\",VLOOKUP($D62,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D62=\"\",\"\",VLOOKUP($D62,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D62=\"\",\"\",VLOOKUP($D62,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I63=\"a\",E62,IF(I63=\"b\",E64,\"\"))","v":""},null,{"$f":"IF(K62=\"a\",J58,IF(K62=\"b\",J66,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D62=\"\",\"\",VLOOKUP($D62,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D62=\"\",\"\",VLOOKUP($D62,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I63=\"a\",E63,IF(I63=\"b\",E65,\"\"))","v":""}]
[30,{"$f":"IF($D64=\"\",\"\",IF(VLOOKUP($D64,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D64,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D64=\"\",\"\",VLOOKUP($D64,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D64=\"\",\"\",VLOOKUP($D64,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D64=\"\",\"\",VLOOKUP($D64,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,null,null,{"$f":"IF(K65=\"a\",J62,IF(K65=\"b\",J66,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D64=\"\",\"\",VLOOKUP($D64,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D64=\"\",\"\",VLOOKUP($D64,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,null,null,{"$f":"IF(K65=\"a\",J63,IF(K65=\"b\",J67,\"\"))","v":""}]
[31,{"$f":"IF($D66=\"\",\"\",IF(VLOOKUP($D66,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D66,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D66=\"\",\"\",VLOOKUP($D66,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D66=\"\",\"\",VLOOKUP($D66,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D66=\"\",\"\",VLOOKUP($D66,'Prep. Principal D'!$A$12:$U$27,3))","v":""},null,{"$f":"IF(I67=\"a\",E66,IF(I67=\"b\",E68,\"\"))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D66=\"\",\"\",VLOOKUP($D66,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D66=\"\",\"\",VLOOKUP($D66,'Prep. Principal D'!$A$12:$U$27,8))","v":""},null,{"$f":"IF(I67=\"a\",E67,IF(I67=\"b\",E69,\"\"))","v":""}]
[32,{"$f":"IF($D68=\"\",\"\",IF(VLOOKUP($D68,'Prep. Principal D'!$A$12:$U$27,16)=\"DA\",,VLOOKUP($D68,'Prep. Principal D'!$A$12:$U$27,15)))","v":""},{"$f":"IF($D68=\"\",\"\",VLOOKUP($D68,'Prep. Principal D'!$A$12:$U$27,13))","v":""},null,{"$f":"UPPER(IF($D68=\"\",\"\",VLOOKUP($D68,'Prep. Principal D'!$A$7:$U$27,2)))","v":""},null,null,{"$f":"IF($D68=\"\",\"\",VLOOKUP($D68,'Prep. Principal D'!$A$12:$U$27,3))","v":""}]
[null,null,null,null,{"$f":"UPPER(IF($D68=\"\",\"\",VLOOKUP($D68,'Prep. Principal D'!$A$7:$U$27,7)))","v":""},null,null,{"$f":"IF($D68=\"\",\"\",VLOOKUP($D68,'Prep. Principal D'!$A$12:$U$27,8))","v":""}]
[]
[null,"Siembras",null,null,null,null,"Puntuacion"]
[1,{"$f":"IF(D6=1,E6,\"\")","v":""},null,null,null,1,"Campeones",null,null,210]
[null,{"$f":"IF(D6=1,E7,\"\")","v":""},null,null,null,null,"Subcampeones",null,null,150]
[2,{"$f":"IF(D68=2,E68,\"\")","v":""},null,null,null,2,"Semifinalistas",null,null,90]
[null,{"$f":"IF(D68=2,E69,\"\")","v":""},null,null,null,null,"Cuartos de Final",null,null,45]
[3,{"$f":"IF(D24=3,E24,IF(D52=3,E52,\"\"))","v":""},null,null,null,3,"Octavos de Final",null,null,15,"Supervisor FCT"]
[null,{"$f":"IF(D24=3,E25,IF(D52=3,E53,\"\"))","v":""},null,null,null,null,"1ra Ronda",null,null,1]
[4,{"$f":"IF(D24=4,E24,IF(D52=4,E52,\"\"))","v":""},null,null,null,4]
[null,{"$f":"IF(D24=4,E25,IF(D52=4,E53,\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"Maestra!A18","v":"ESTEBAN JIMENEZ"}]
[5,{"$f":"IF(D18=5,E18,IF(D36=5,E36,IF(D38=5,E38,IF(D54=5,E54,\"\"))))","v":""},null,null,null,5]
[null,{"$f":"IF(D18=5,E19,IF(D36=5,E37,IF(D38=5,E39,IF(D54=5,E55,\"\"))))","v":""}]
[6,{"$f":"IF(D22=6,E22,IF(D36=6,E36,IF(D38=6,E38,IF(D54=6,E54,\"\"))))","v":""},null,null,null,6]
[null,{"$f":"IF(D22=6,E23,IF(D36=6,E37,IF(D38=6,E39,IF(D54=6,E55,\"\"))))","v":""}]
[7,{"$f":"IF(D22=7,E22,IF(D36=7,E36,IF(D38=7,E38,IF(D54=7,E54,\"\"))))","v":""},null,null,null,7]
[null,{"$f":"IF(D22=7,E23,IF(D36=7,E37,IF(D38=7,E39,IF(D54=7,E55,\"\"))))","v":""}]
[8,{"$f":"IF(D22=8,E22,IF(D36=8,E36,IF(D38=8,E38,IF(D54=8,E54,\"\"))))","v":""},null,null,null,8]
[null,{"$f":"IF(D22=8,E23,IF(D36=8,E37,IF(D38=8,E39,IF(D54=8,E55,\"\"))))","v":""}]