{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Maestra","Round Robin","Round Robin (3)","Round Robin (2)","Eliminación Sencilla","Hoja1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":14,"comments":1,"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":[]}
[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. RECUERDE, EN TODAS LAS HOJAS, SÓLO PODRA"]
["ESCRIBIR EN LAS AREAS GRISES."]
["TORNEO",null,null,null,"CLASE",null,null,"CATEGORIA"]
[]
["2DO RANKING DEPARTAMENTAL 2020",null,null,null,"SENCILLOS ",null,null,"TERCERA"]
[]
["SEDE",null,null,null,"CIUDAD",null,null,"FECHA"]
[]
["LIGA SANTANDEREANA DE TENIS ",null,null,null,"BUCARAMANGA ",null,null,"17 OCT - 02 NOV"]
[null,null,null,null,null,null,null,"D/M/A"]
["COORDINADORA",null,null,null,"SUPERFICIE"]
[]
["PAOLA A CHINCHILLA ",null,null,null,"POLVO DE LADRILLO "]

{"sheet":"Round Robin","index":1,"n_rows":34,"n_cols":33,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,7,6,16]]}
[null,null,null,null,"SENCILLOS CUADRO DE ROUND ROBIN"]
["Torneo",null,null,null,{"$f":"Maestra!A10","v":"2DO RANKING DEPARTAMENTAL 2020"}]
["Sede",null,null,null,{"$f":"Maestra!A14","v":"LIGA SANTANDEREANA DE TENIS "}]
["Clase",null,null,null,{"$f":"Maestra!E10","v":"SENCILLOS "}]
["Ciudad",null,null,null,{"$f":"Maestra!E14","v":"BUCARAMANGA "}]
["Categoría",null,null,null,{"$f":"Maestra!H10","v":"TERCERA"}]
["Fecha",null,{"$f":"Maestra!H14","v":"17 OCT - 02 NOV"},null,null,null,null,"COORDINADORA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Maestra!A18","v":"PAOLA A CHINCHILLA "}]
[null,null,"CUADRO NO. 1"]
["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,#REF!,7)))","v":""},"ANDRES ALMEYDA ORTIZ",null,"PN",null,null,null,null,null,null,4,6,6,1,8,10,6,0,6,0,null,null,null,null,null,null,null,null,null,{"$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":60},{"$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":63.829787234042556}]
[2,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,#REF!,7)))","v":""},"SEIDER GUTIERREZ CORTES ",null,"UTS",6,4,1,6,10,8,null,null,null,null,null,null,3,6,6,4,10,4,6,1,6,1,null,null,null,{"$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":62.5},{"$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":58.536585365853654}]
[3,{"$f":"UPPER(IF($D12=\"\",\"\",VLOOKUP($D12,#REF!,7)))","v":""},"OSCAR ANDRES QUINTERO ",null,"IND",0,6,0,6,null,null,6,3,4,6,4,10,null,null,null,null,null,null,6,2,6,0,null,null,null,{"$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":42.857142857142854},{"$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":44.067796610169488}]
[4,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,#REF!,7)))","v":""},"ANDRES ALDANA OJEDA ",null,"UNAB",null,null,null,null,null,null,1,6,1,6,null,null,2,6,0,6,null,null,null,null,null,null,null,null,null,{"$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":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":14.285714285714285}]
[]
[null,null,"CUADRO NO. 2"]
["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,null,"JOSE A. OJEDA MURCIA",null,"IND",null,null,null,null,null,null,6,1,6,3,null,null,null,null,null,null,null,null,6,3,6,2,null,null,null,{"$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":100},{"$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":72.727272727272734}]
[6,null,"JAIME ANDRES VILLAMIL ",null,"SOC",1,6,3,6,null,null,null,null,null,null,null,null,6,1,6,2,null,null,6,3,6,1,null,null,null,{"$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":66.666666666666657},{"$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":59.574468085106382}]
[7,null,"JERONIMO GARCIA ",null,"PN",null,null,null,null,null,null,1,6,2,6,null,null,null,null,null,null,null,null,0,6,0,6,null,null,null,{"$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":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":11.111111111111111}]
[8,null,"KAREN DAYANA PARADA MATEUS",null,"UNAB",3,6,2,6,null,null,3,6,1,6,null,null,6,0,6,0,null,null,null,null,null,null,null,null,null,{"$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":33.333333333333329},{"$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":46.666666666666664}]
[]
[null,null,"CUADRO NO. 3"]
["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,#REF!,7)))","v":""},"CARLOS A. GONZALEZ ",null,"SCC",null,null,null,null,null,null,6,0,6,0,null,null,6,4,6,0,null,null,6,0,6,2,null,null,null,{"$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":100},{"$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":85.714285714285708}]
[10,{"$f":"UPPER(IF($D25=\"\",\"\",VLOOKUP($D25,#REF!,7)))","v":""},"CAROLINA ZAMBRANO",null,"LT",0,6,0,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,6,3,6,null,null,null,{"$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":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":17.241379310344829}]
[11,{"$f":"UPPER(IF($D26=\"\",\"\",VLOOKUP($D26,#REF!,7)))","v":""},"VICTOR A. ACUÑA ",null,"PM",4,6,0,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,6,5,7,null,null,null,{"$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":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":32.432432432432435}]
[12,{"$f":"UPPER(IF($D27=\"\",\"\",VLOOKUP($D27,#REF!,7)))","v":""},"OSCAR FELIPE VILLANUEVA A.",null,"IND",0,6,2,6,null,null,6,2,6,3,null,null,6,3,7,5,null,null,null,null,null,null,null,null,null,{"$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":66.666666666666657},{"$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":51.923076923076927}]
[]
[null,null,"CUADRO NO. 4"]
["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,#REF!,7)))","v":""},"FABIAN FARFAN ",null,"IND",null,null,null,null,null,null,6,3,6,4,null,null,6,3,5,7,4,10,null,null,null,null,null,null,null,{"$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":60},{"$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":50}]
[14,{"$f":"UPPER(IF($D32=\"\",\"\",VLOOKUP($D32,#REF!,7)))","v":""},"MARIA VALENTINA ARDILA ",null,"LT",3,6,4,6,null,null,null,null,null,null,null,null,0,6,0,6,null,null,null,null,null,null,null,null,null,{"$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":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":22.58064516129032}]
[15,{"$f":"UPPER(IF($D33=\"\",\"\",VLOOKUP($D33,#REF!,7)))","v":""},"CESAR A. HERNANDEZ CALDERON",null,"FT",3,6,7,5,10,4,6,0,6,0,null,null,null,null,null,null,null,null,6,1,6,3,null,null,null,{"$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":85.714285714285708},{"$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":69.841269841269835}]
[16,{"$f":"UPPER(IF($D34=\"\",\"\",VLOOKUP($D34,#REF!,7)))","v":""},"MIGUEL ANGEL MEDINA ",null,"CH",null,null,null,null,null,null,null,null,null,null,null,null,1,6,3,6,null,null,null,null,null,null,null,null,null,{"$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":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":25}]

{"sheet":"Round Robin (3)","index":2,"n_rows":34,"n_cols":33,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,7,6,16]]}
[null,null,null,null,"SENCILLOS CUADRO DE ROUND ROBIN"]
["Torneo",null,null,null,{"$f":"Maestra!A10","v":"2DO RANKING DEPARTAMENTAL 2020"}]
["Sede",null,null,null,{"$f":"Maestra!A14","v":"LIGA SANTANDEREANA DE TENIS "}]
["Clase",null,null,null,{"$f":"Maestra!E10","v":"SENCILLOS "}]
["Ciudad",null,null,null,{"$f":"Maestra!E14","v":"BUCARAMANGA "}]
["Categoría",null,null,null,{"$f":"Maestra!H10","v":"TERCERA"}]
["Fecha",null,{"$f":"Maestra!H14","v":"17 OCT - 02 NOV"},null,null,null,null,"COORDINADORA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Maestra!A18","v":"PAOLA A CHINCHILLA "}]
[null,null,"CUADRO NO. 5"]
["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"]
[17,null,"ANDRES FERNANDO PEÑA ",null,"CU",null,null,null,null,null,null,6,7,2,6,null,null,6,3,1,6,9,10,null,null,null,null,null,null,null,{"$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":20},{"$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":42.857142857142854}]
[18,null,"OSCAR MERCHAN MENDEZ",null,"IND",7,6,6,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,6,0,6,null,null,null,{"$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":50},{"$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":41.17647058823529}]
[19,null,"SERGIO MARQUEZ ",null,"FT",3,6,6,1,10,9,null,null,null,null,null,null,null,null,null,null,null,null,2,6,2,6,null,null,null,{"$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":20},{"$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":45.098039215686278}]
[20,null,"ROQUE PARRA SIERRA ",null,"ACET",null,null,null,null,null,null,6,1,6,0,null,null,6,2,6,2,null,null,null,null,null,null,null,null,null,{"$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":100},{"$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":82.758620689655174}]
[]
[null,null,"CUADRO NO. 6"]
["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"]
[21,null,"NELSON CORREA PACHECO ",null,"USTA",null,null,null,null,null,null,6,1,6,0,null,null,null,null,null,null,null,null,3,6,0,6,null,null,null,{"$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":50},{"$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":53.571428571428569}]
[22,null,"ANDRES F. BARRERA ",null,"RT",0,6,1,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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":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":7.6923076923076925}]
[23,null,"JUAN DIEGO MORENO POSADA",null,"UNAB ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,6,0,6,null,null,null,{"$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":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":0}]
[24,null,"DIEGO A. PARADA MATEUS ",null,"UPB",6,3,6,0,null,null,null,null,null,null,null,null,6,0,6,0,null,null,null,null,null,null,null,null,null,{"$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":100},{"$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":88.888888888888886}]
[]
[null,null,"CUADRO NO. 7"]
["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"]
[25,{"$f":"UPPER(IF($D24=\"\",\"\",VLOOKUP($D24,#REF!,7)))","v":""},"CARLOS A. QUIROZ",null,"IND",null,null,null,null,null,null,2,6,4,6,null,null,0,6,2,6,null,null,null,null,null,null,null,null,null,{"$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":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":25}]
[26,{"$f":"UPPER(IF($D25=\"\",\"\",VLOOKUP($D25,#REF!,7)))","v":""},"MIGUEL BECERRA",null,"COMF",6,2,6,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,6,2,6,null,null,null,{"$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":50},{"$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":47.058823529411761}]
[27,{"$f":"UPPER(IF($D26=\"\",\"\",VLOOKUP($D26,#REF!,7)))","v":""},"MIGUEL A. SANCHEZ ",null,"CH",6,0,6,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,6,2,6,null,null,null,{"$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":50},{"$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":54.838709677419352}]
[28,{"$f":"UPPER(IF($D27=\"\",\"\",VLOOKUP($D27,#REF!,7)))","v":""},"JUAN GONZALO ARENAS ",null,"IND",null,null,null,null,null,null,6,2,6,2,null,null,6,3,6,2,null,null,null,null,null,null,null,null,null,{"$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":100},{"$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":72.727272727272734}]
[]
[null,null,"CUADRO NO. 8"]
["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"]
[29,null,"JOSE FERNANDO DUARTE ",null,"IND",null,null,null,null,null,null,4,6,2,6,null,null,6,0,6,2,null,null,null,null,null,null,null,null,null,{"$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":50},{"$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":56.25}]
[30,null,"SAMUEL DAVID BOTELLO",null,"USTA ",6,4,6,2,null,null,null,null,null,null,null,null,6,2,7,5,null,null,6,0,6,2,null,null,null,{"$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":100},{"$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":71.15384615384616}]
[31,null,"WILMER MOJICA GOMEZ ",null,"LT",0,6,2,6,null,null,2,6,5,7,null,null,null,null,null,null,null,null,6,0,6,0,null,null,null,{"$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":33.333333333333329},{"$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":45.652173913043477}]
[32,null,"LUISA JULIANA CARRILLO",null,"IND",null,null,null,null,null,null,0,6,2,6,null,null,0,6,0,6,null,null,null,null,null,null,null,null,null,{"$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":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":7.6923076923076925}]

{"sheet":"Round Robin (2)","index":3,"n_rows":35,"n_cols":39,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,7,6,16]]}
[null,null,null,null,"SENCILLOS CUADRO DE ROUND ROBIN"]
["Torneo",null,null,null,{"$f":"Maestra!A10","v":"2DO RANKING DEPARTAMENTAL 2020"}]
["Sede",null,null,null,{"$f":"Maestra!A14","v":"LIGA SANTANDEREANA DE TENIS "}]
["Clase",null,null,null,{"$f":"Maestra!E10","v":"SENCILLOS "}]
["Ciudad",null,null,null,{"$f":"Maestra!E14","v":"BUCARAMANGA "}]
["Categoría",null,null,null,{"$f":"Maestra!H10","v":"TERCERA"}]
["Fecha",null,{"$f":"Maestra!H14","v":"17 OCT - 02 NOV"},null,null,null,null,"COORDINADORA",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,{"$f":"Maestra!A18","v":"PAOLA A CHINCHILLA "}]
[null,null,"CUADRO NO. 9"]
["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,null,null,null,5,null,null,"PUNTOS","% SETS","% GAMES","PUESTO"]
[33,null,"DANIEL FERNANDO NIÑO",null,"IND",null,null,null,null,null,null,2,6,0,6,null,null,null,null,null,null,null,null,6,1,6,1,null,null,null,null,null,null,null,null,null,{"$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":50},{"$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":50}]
[34,null,"ISABELLA PALLARES AMAYA ",null,"ACET",6,2,6,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,4,6,7,10,null,{"$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":100},{"$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":85.714285714285708}]
[35,null,"RAFAEL ACEVEDO FRANCO",null,"VS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,7,6,4,10,7,null,null,null,null,null,null,null,{"$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":33.333333333333329},{"$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":55.000000000000007}]
[36,null,"OSCAR SANTIAGO CASTIBLANCO ",null,"LT",1,6,1,6,null,null,null,null,null,null,null,null,7,6,4,6,7,10,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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":20},{"$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":37.037037037037038}]
[37,null,"JUAN MARTIN LOPEZ",null,"CC",null,null,null,null,null,null,0,6,6,4,10,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((IF(AND(F14>5,G14<7),1,0)+IF(AND(H14>5,I14<7),1,0)+IF(AND(J14>5,K14<7),1,0)+IF(AND(L14>5,M14<7),1,0)+IF(AND(N14>5,O14<7),1,0)+IF(AND(P14>5,Q14<7),1,0)+IF(AND(R14>5,S14<7),1,0)+IF(AND(T14>5,U14<7),1,0)+IF(AND(V14>5,W14<7),1,0))/(COUNTIF(F14,\">=0\")+COUNTIF(H14,\">=0\")+COUNTIF(J14,\">=0\")+COUNTIF(R14,\">=0\")+COUNTIF(T14,\">=0\")+COUNTIF(V14,\">=0\")++COUNTIF(L14,\">=0\")+COUNTIF(N14,\">=0\")+COUNTIF(P14,\">=0\")))*100","v":33.333333333333329},{"$f":"((F14+J14+H14+L14+N14+P14+R14+T14+V14)/(F14+G14+H14+I14+J14+K14+L14+M14+N14+O14+P14+Q14+R14+S14+T14+U14+V14+W14))*100","v":48.484848484848484}]
[]
[null,null,"CUADRO NO. 10"]
["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,null,null,null,4,null,null,"PUNTOS","% SETS","% GAMES","PUESTO"]
[37,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,null,null,null,null,null,null,null,{"$f":"((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(L18>5,M18<7),1,0)+IF(AND(N18>5,O18<7),1,0)+IF(AND(P18>5,Q18<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(R18,\">=0\")+COUNTIF(T18,\">=0\")+COUNTIF(V18,\">=0\")+COUNTIF(X18,\">=0\")+COUNTIF(Z18,\">=0\")+COUNTIF(AB18,\">=0\")++COUNTIF(L18,\">=0\")+COUNTIF(N18,\">=0\")+COUNTIF(P18,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((L18+N18+P18+R18+T18+V18+X18+Z18+AB18)/(L18+M18+N18+O18+P18+Q18+R18+S18+T18+U18+V18+W18+X18+Y18+Z18+AA18+AB18+AC18))*100","v":{"$error":"#DIV/0!"}}]
[38,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,null,null,null,null,null,null,null,{"$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(R19>5,S19<7),1,0)+IF(AND(T19>5,U19<7),1,0)+IF(AND(V19>5,W19<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(R19,\">=0\")+COUNTIF(T19,\">=0\")+COUNTIF(V19,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F19+J19+H19+R19+T19+V19+X19+Z19+AB19)/(F19+G19+H19+I19+J19+K19+R19+S19+T19+U19+V19+W19+X19+Y19+Z19+AA19+AB19+AC19))*100","v":{"$error":"#DIV/0!"}}]
[39,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,null,null,null,null,null,null,null,{"$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(X20>5,Y20<7),1,0)+IF(AND(Z20>5,AA20<7),1,0)+IF(AND(AB20>5,AC20<7),1,0))/(COUNTIF(F20,\">=0\")+COUNTIF(H20,\">=0\")+COUNTIF(J20,\">=0\")+COUNTIF(X20,\">=0\")+COUNTIF(Z20,\">=0\")+COUNTIF(AB20,\">=0\")+COUNTIF(L20,\">=0\")+COUNTIF(N20,\">=0\")+COUNTIF(P20,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F20+J20+H20+L20+N20+P20+X20+Z20+AB20)/(F20+G20+H20+I20+J20+K20+L20+M20+N20+O20+P20+Q20+X20+Y20+Z20+AA20+AB20+AC20))*100","v":{"$error":"#DIV/0!"}}]
[40,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,null,null,null,null,null,null,null,{"$f":"((IF(AND(F21>5,G21<7),1,0)+IF(AND(H21>5,I21<7),1,0)+IF(AND(J21>5,K21<7),1,0)+IF(AND(L21>5,M21<7),1,0)+IF(AND(N21>5,O21<7),1,0)+IF(AND(P21>5,Q21<7),1,0)+IF(AND(R21>5,S21<7),1,0)+IF(AND(T21>5,U21<7),1,0)+IF(AND(V21>5,W21<7),1,0))/(COUNTIF(F21,\">=0\")+COUNTIF(H21,\">=0\")+COUNTIF(J21,\">=0\")+COUNTIF(R21,\">=0\")+COUNTIF(T21,\">=0\")+COUNTIF(V21,\">=0\")++COUNTIF(L21,\">=0\")+COUNTIF(N21,\">=0\")+COUNTIF(P21,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F21+J21+H21+L21+N21+P21+R21+T21+V21)/(F21+G21+H21+I21+J21+K21+L21+M21+N21+O21+P21+Q21+R21+S21+T21+U21+V21+W21))*100","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"CUADRO NO. 11"]
["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,null,null,null,4,null,null,"PUNTOS","% SETS","% GAMES","PUESTO"]
[41,{"$f":"UPPER(IF($D25=\"\",\"\",VLOOKUP($D25,#REF!,7)))","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,null,null,null,null,null,null,null,null,null,null,{"$f":"((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(L25>5,M25<7),1,0)+IF(AND(N25>5,O25<7),1,0)+IF(AND(P25>5,Q25<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(R25,\">=0\")+COUNTIF(T25,\">=0\")+COUNTIF(V25,\">=0\")+COUNTIF(X25,\">=0\")+COUNTIF(Z25,\">=0\")+COUNTIF(AB25,\">=0\")++COUNTIF(L25,\">=0\")+COUNTIF(N25,\">=0\")+COUNTIF(P25,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((L25+N25+P25+R25+T25+V25+X25+Z25+AB25)/(L25+M25+N25+O25+P25+Q25+R25+S25+T25+U25+V25+W25+X25+Y25+Z25+AA25+AB25+AC25))*100","v":{"$error":"#DIV/0!"}}]
[42,{"$f":"UPPER(IF($D26=\"\",\"\",VLOOKUP($D26,#REF!,7)))","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,null,null,null,null,null,null,null,null,null,null,{"$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(R26>5,S26<7),1,0)+IF(AND(T26>5,U26<7),1,0)+IF(AND(V26>5,W26<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(R26,\">=0\")+COUNTIF(T26,\">=0\")+COUNTIF(V26,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F26+J26+H26+R26+T26+V26+X26+Z26+AB26)/(F26+G26+H26+I26+J26+K26+R26+S26+T26+U26+V26+W26+X26+Y26+Z26+AA26+AB26+AC26))*100","v":{"$error":"#DIV/0!"}}]
[43,{"$f":"UPPER(IF($D27=\"\",\"\",VLOOKUP($D27,#REF!,7)))","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,null,null,null,null,null,null,null,null,null,null,{"$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(X27>5,Y27<7),1,0)+IF(AND(Z27>5,AA27<7),1,0)+IF(AND(AB27>5,AC27<7),1,0))/(COUNTIF(F27,\">=0\")+COUNTIF(H27,\">=0\")+COUNTIF(J27,\">=0\")+COUNTIF(X27,\">=0\")+COUNTIF(Z27,\">=0\")+COUNTIF(AB27,\">=0\")+COUNTIF(L27,\">=0\")+COUNTIF(N27,\">=0\")+COUNTIF(P27,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F27+J27+H27+L27+N27+P27+X27+Z27+AB27)/(F27+G27+H27+I27+J27+K27+L27+M27+N27+O27+P27+Q27+X27+Y27+Z27+AA27+AB27+AC27))*100","v":{"$error":"#DIV/0!"}}]
[44,{"$f":"UPPER(IF($D28=\"\",\"\",VLOOKUP($D28,#REF!,7)))","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,null,null,null,null,null,null,null,null,null,null,{"$f":"((IF(AND(F28>5,G28<7),1,0)+IF(AND(H28>5,I28<7),1,0)+IF(AND(J28>5,K28<7),1,0)+IF(AND(L28>5,M28<7),1,0)+IF(AND(N28>5,O28<7),1,0)+IF(AND(P28>5,Q28<7),1,0)+IF(AND(R28>5,S28<7),1,0)+IF(AND(T28>5,U28<7),1,0)+IF(AND(V28>5,W28<7),1,0))/(COUNTIF(F28,\">=0\")+COUNTIF(H28,\">=0\")+COUNTIF(J28,\">=0\")+COUNTIF(R28,\">=0\")+COUNTIF(T28,\">=0\")+COUNTIF(V28,\">=0\")++COUNTIF(L28,\">=0\")+COUNTIF(N28,\">=0\")+COUNTIF(P28,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F28+J28+H28+L28+N28+P28+R28+T28+V28)/(F28+G28+H28+I28+J28+K28+L28+M28+N28+O28+P28+Q28+R28+S28+T28+U28+V28+W28))*100","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"CUADRO NO. 12"]
["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,null,null,null,4,null,null,"PUNTOS","% SETS","% GAMES","PUESTO"]
[45,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,null,null,null,null,null,null,null,{"$f":"((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(L32>5,M32<7),1,0)+IF(AND(N32>5,O32<7),1,0)+IF(AND(P32>5,Q32<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(R32,\">=0\")+COUNTIF(T32,\">=0\")+COUNTIF(V32,\">=0\")+COUNTIF(X32,\">=0\")+COUNTIF(Z32,\">=0\")+COUNTIF(AB32,\">=0\")++COUNTIF(L32,\">=0\")+COUNTIF(N32,\">=0\")+COUNTIF(P32,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((L32+N32+P32+R32+T32+V32+X32+Z32+AB32)/(L32+M32+N32+O32+P32+Q32+R32+S32+T32+U32+V32+W32+X32+Y32+Z32+AA32+AB32+AC32))*100","v":{"$error":"#DIV/0!"}}]
[46,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,null,null,null,null,null,null,null,{"$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(R33>5,S33<7),1,0)+IF(AND(T33>5,U33<7),1,0)+IF(AND(V33>5,W33<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(R33,\">=0\")+COUNTIF(T33,\">=0\")+COUNTIF(V33,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F33+J33+H33+R33+T33+V33+X33+Z33+AB33)/(F33+G33+H33+I33+J33+K33+R33+S33+T33+U33+V33+W33+X33+Y33+Z33+AA33+AB33+AC33))*100","v":{"$error":"#DIV/0!"}}]
[47,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,null,null,null,null,null,null,null,{"$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(X34>5,Y34<7),1,0)+IF(AND(Z34>5,AA34<7),1,0)+IF(AND(AB34>5,AC34<7),1,0))/(COUNTIF(F34,\">=0\")+COUNTIF(H34,\">=0\")+COUNTIF(J34,\">=0\")+COUNTIF(X34,\">=0\")+COUNTIF(Z34,\">=0\")+COUNTIF(AB34,\">=0\")+COUNTIF(L34,\">=0\")+COUNTIF(N34,\">=0\")+COUNTIF(P34,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F34+J34+H34+L34+N34+P34+X34+Z34+AB34)/(F34+G34+H34+I34+J34+K34+L34+M34+N34+O34+P34+Q34+X34+Y34+Z34+AA34+AB34+AC34))*100","v":{"$error":"#DIV/0!"}}]
[48,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,null,null,null,null,null,null,null,{"$f":"((IF(AND(F35>5,G35<7),1,0)+IF(AND(H35>5,I35<7),1,0)+IF(AND(J35>5,K35<7),1,0)+IF(AND(L35>5,M35<7),1,0)+IF(AND(N35>5,O35<7),1,0)+IF(AND(P35>5,Q35<7),1,0)+IF(AND(R35>5,S35<7),1,0)+IF(AND(T35>5,U35<7),1,0)+IF(AND(V35>5,W35<7),1,0))/(COUNTIF(F35,\">=0\")+COUNTIF(H35,\">=0\")+COUNTIF(J35,\">=0\")+COUNTIF(R35,\">=0\")+COUNTIF(T35,\">=0\")+COUNTIF(V35,\">=0\")++COUNTIF(L35,\">=0\")+COUNTIF(N35,\">=0\")+COUNTIF(P35,\">=0\")))*100","v":{"$error":"#DIV/0!"}},{"$f":"((F35+J35+H35+L35+N35+P35+R35+T35+V35)/(F35+G35+H35+I35+J35+K35+L35+M35+N35+O35+P35+Q35+R35+S35+T35+U35+V35+W35))*100","v":{"$error":"#DIV/0!"}}]

{"sheet":"Eliminación Sencilla","index":4,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[26,11,26,12],[18,11,18,12],[1,1,1,4],[10,11,10,12],[12,15,12,16],[14,11,14,12],[22,11,22,12],[58,11,58,12],[62,11,62,12],[65,9,65,10],[32,13,32,14],[34,11,34,12],[38,11,38,12],[46,11,46,12],[50,11,50,12]]}
[null,null,null,null,null,null,null,"SENCILLOS CUADRO PRINCIPAL"]
["Torneo","2DO RANKING DEPARTAMENTAL 2020",null,null,null,"Clase",null,"Sencillos",null,null,null,"Categoría",null,"3RA"]
["Sede","Liga Santandereana de Tenis ",null,null,null,"Ciudad",null,"Bucaramanga",null,null,null,"Fecha",null,"2020-10-17"]
[]
[1,{"$f":"UPPER(IF($D5=\"\",\"\",VLOOKUP($D5,#REF!,6)))","v":""},{"$f":"UPPER(IF($D5=\"\",\"\",VLOOKUP($D5,#REF!,7)))","v":""}]
[2,{"$f":"UPPER(IF($D6=\"\",\"\",VLOOKUP($D6,#REF!,6)))","v":""},{"$f":"UPPER(IF($D6=\"\",\"\",VLOOKUP($D6,#REF!,7)))","v":""}]
[3,{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,#REF!,6)))","v":""},{"$f":"UPPER(IF($D7=\"\",\"\",VLOOKUP($D7,#REF!,7)))","v":""}]
[4,{"$f":"UPPER(IF($D8=\"\",\"\",VLOOKUP($D8,#REF!,6)))","v":""},{"$f":"UPPER(IF($D8=\"\",\"\",VLOOKUP($D8,#REF!,7)))","v":""}]
[5,{"$f":"UPPER(IF($D9=\"\",\"\",VLOOKUP($D9,#REF!,6)))","v":""},{"$f":"UPPER(IF($D9=\"\",\"\",VLOOKUP($D9,#REF!,7)))","v":""}]
[6,{"$f":"UPPER(IF($D10=\"\",\"\",VLOOKUP($D10,#REF!,6)))","v":""},{"$f":"UPPER(IF($D10=\"\",\"\",VLOOKUP($D10,#REF!,7)))","v":""}]
[7,{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,#REF!,6)))","v":""},{"$f":"UPPER(IF($D11=\"\",\"\",VLOOKUP($D11,#REF!,7)))","v":""}]
[8,{"$f":"UPPER(IF($D12=\"\",\"\",VLOOKUP($D12,#REF!,6)))","v":""},{"$f":"UPPER(IF($D12=\"\",\"\",VLOOKUP($D12,#REF!,7)))","v":""}]
[9,{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,#REF!,6)))","v":""},{"$f":"UPPER(IF($D13=\"\",\"\",VLOOKUP($D13,#REF!,7)))","v":""}]
[10,{"$f":"UPPER(IF($D14=\"\",\"\",VLOOKUP($D14,#REF!,6)))","v":""},{"$f":"UPPER(IF($D14=\"\",\"\",VLOOKUP($D14,#REF!,7)))","v":""}]
[11,{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,#REF!,6)))","v":""},{"$f":"UPPER(IF($D15=\"\",\"\",VLOOKUP($D15,#REF!,7)))","v":""}]
[12,{"$f":"UPPER(IF($D16=\"\",\"\",VLOOKUP($D16,#REF!,6)))","v":""},{"$f":"UPPER(IF($D16=\"\",\"\",VLOOKUP($D16,#REF!,7)))","v":""}]
[13,{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,#REF!,6)))","v":""},{"$f":"UPPER(IF($D17=\"\",\"\",VLOOKUP($D17,#REF!,7)))","v":""}]
[14,{"$f":"UPPER(IF($D18=\"\",\"\",VLOOKUP($D18,#REF!,6)))","v":""},{"$f":"UPPER(IF($D18=\"\",\"\",VLOOKUP($D18,#REF!,7)))","v":""}]
[15,{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,#REF!,6)))","v":""},{"$f":"UPPER(IF($D19=\"\",\"\",VLOOKUP($D19,#REF!,7)))","v":""}]
[16,{"$f":"UPPER(IF($D20=\"\",\"\",VLOOKUP($D20,#REF!,6)))","v":""},{"$f":"UPPER(IF($D20=\"\",\"\",VLOOKUP($D20,#REF!,7)))","v":""}]
[17,{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,#REF!,6)))","v":""},{"$f":"UPPER(IF($D21=\"\",\"\",VLOOKUP($D21,#REF!,7)))","v":""}]
[18,{"$f":"UPPER(IF($D22=\"\",\"\",VLOOKUP($D22,#REF!,6)))","v":""},{"$f":"UPPER(IF($D22=\"\",\"\",VLOOKUP($D22,#REF!,7)))","v":""}]
[19,{"$f":"UPPER(IF($D23=\"\",\"\",VLOOKUP($D23,#REF!,6)))","v":""},{"$f":"UPPER(IF($D23=\"\",\"\",VLOOKUP($D23,#REF!,7)))","v":""}]
[20,{"$f":"UPPER(IF($D24=\"\",\"\",VLOOKUP($D24,#REF!,6)))","v":""},{"$f":"UPPER(IF($D24=\"\",\"\",VLOOKUP($D24,#REF!,7)))","v":""}]
[21,{"$f":"UPPER(IF($D25=\"\",\"\",VLOOKUP($D25,#REF!,6)))","v":""},{"$f":"UPPER(IF($D25=\"\",\"\",VLOOKUP($D25,#REF!,7)))","v":""}]
[22,{"$f":"UPPER(IF($D26=\"\",\"\",VLOOKUP($D26,#REF!,6)))","v":""},{"$f":"UPPER(IF($D26=\"\",\"\",VLOOKUP($D26,#REF!,7)))","v":""}]
[23,{"$f":"UPPER(IF($D27=\"\",\"\",VLOOKUP($D27,#REF!,6)))","v":""},{"$f":"UPPER(IF($D27=\"\",\"\",VLOOKUP($D27,#REF!,7)))","v":""}]
[24,{"$f":"UPPER(IF($D28=\"\",\"\",VLOOKUP($D28,#REF!,6)))","v":""},{"$f":"UPPER(IF($D28=\"\",\"\",VLOOKUP($D28,#REF!,7)))","v":""}]
[25,{"$f":"UPPER(IF($D29=\"\",\"\",VLOOKUP($D29,#REF!,6)))","v":""},{"$f":"UPPER(IF($D29=\"\",\"\",VLOOKUP($D29,#REF!,7)))","v":""}]
[26,{"$f":"UPPER(IF($D30=\"\",\"\",VLOOKUP($D30,#REF!,6)))","v":""},{"$f":"UPPER(IF($D30=\"\",\"\",VLOOKUP($D30,#REF!,7)))","v":""}]
[27,{"$f":"UPPER(IF($D31=\"\",\"\",VLOOKUP($D31,#REF!,6)))","v":""},{"$f":"UPPER(IF($D31=\"\",\"\",VLOOKUP($D31,#REF!,7)))","v":""}]
[28,{"$f":"UPPER(IF($D32=\"\",\"\",VLOOKUP($D32,#REF!,6)))","v":""},{"$f":"UPPER(IF($D32=\"\",\"\",VLOOKUP($D32,#REF!,7)))","v":""}]
[29,{"$f":"UPPER(IF($D33=\"\",\"\",VLOOKUP($D33,#REF!,6)))","v":""},{"$f":"UPPER(IF($D33=\"\",\"\",VLOOKUP($D33,#REF!,7)))","v":""}]
[30,{"$f":"UPPER(IF($D34=\"\",\"\",VLOOKUP($D34,#REF!,6)))","v":""},{"$f":"UPPER(IF($D34=\"\",\"\",VLOOKUP($D34,#REF!,7)))","v":""}]
[31,{"$f":"UPPER(IF($D35=\"\",\"\",VLOOKUP($D35,#REF!,6)))","v":""},{"$f":"UPPER(IF($D35=\"\",\"\",VLOOKUP($D35,#REF!,7)))","v":""}]
[32,{"$f":"UPPER(IF($D36=\"\",\"\",VLOOKUP($D36,#REF!,6)))","v":""},{"$f":"UPPER(IF($D36=\"\",\"\",VLOOKUP($D36,#REF!,7)))","v":""}]
[33,{"$f":"UPPER(IF($D37=\"\",\"\",VLOOKUP($D37,#REF!,6)))","v":""},{"$f":"UPPER(IF($D37=\"\",\"\",VLOOKUP($D37,#REF!,7)))","v":""}]
[34,{"$f":"UPPER(IF($D38=\"\",\"\",VLOOKUP($D38,#REF!,6)))","v":""},{"$f":"UPPER(IF($D38=\"\",\"\",VLOOKUP($D38,#REF!,7)))","v":""}]
[35,{"$f":"UPPER(IF($D39=\"\",\"\",VLOOKUP($D39,#REF!,6)))","v":""},{"$f":"UPPER(IF($D39=\"\",\"\",VLOOKUP($D39,#REF!,7)))","v":""}]
[36,{"$f":"UPPER(IF($D40=\"\",\"\",VLOOKUP($D40,#REF!,6)))","v":""},{"$f":"UPPER(IF($D40=\"\",\"\",VLOOKUP($D40,#REF!,7)))","v":""}]
[37,{"$f":"UPPER(IF($D41=\"\",\"\",VLOOKUP($D41,#REF!,6)))","v":""},{"$f":"UPPER(IF($D41=\"\",\"\",VLOOKUP($D41,#REF!,7)))","v":""}]
[38,{"$f":"UPPER(IF($D42=\"\",\"\",VLOOKUP($D42,#REF!,6)))","v":""},{"$f":"UPPER(IF($D42=\"\",\"\",VLOOKUP($D42,#REF!,7)))","v":""}]
[39,{"$f":"UPPER(IF($D43=\"\",\"\",VLOOKUP($D43,#REF!,6)))","v":""},{"$f":"UPPER(IF($D43=\"\",\"\",VLOOKUP($D43,#REF!,7)))","v":""}]
[40,{"$f":"UPPER(IF($D44=\"\",\"\",VLOOKUP($D44,#REF!,6)))","v":""},{"$f":"UPPER(IF($D44=\"\",\"\",VLOOKUP($D44,#REF!,7)))","v":""}]
[41,{"$f":"UPPER(IF($D45=\"\",\"\",VLOOKUP($D45,#REF!,6)))","v":""},{"$f":"UPPER(IF($D45=\"\",\"\",VLOOKUP($D45,#REF!,7)))","v":""}]
[42,{"$f":"UPPER(IF($D46=\"\",\"\",VLOOKUP($D46,#REF!,6)))","v":""},{"$f":"UPPER(IF($D46=\"\",\"\",VLOOKUP($D46,#REF!,7)))","v":""},null,null,"  "]
[43,{"$f":"UPPER(IF($D47=\"\",\"\",VLOOKUP($D47,#REF!,6)))","v":""},{"$f":"UPPER(IF($D47=\"\",\"\",VLOOKUP($D47,#REF!,7)))","v":""}]
[44,{"$f":"UPPER(IF($D48=\"\",\"\",VLOOKUP($D48,#REF!,6)))","v":""},{"$f":"UPPER(IF($D48=\"\",\"\",VLOOKUP($D48,#REF!,7)))","v":""}]
[45,{"$f":"UPPER(IF($D49=\"\",\"\",VLOOKUP($D49,#REF!,6)))","v":""},{"$f":"UPPER(IF($D49=\"\",\"\",VLOOKUP($D49,#REF!,7)))","v":""}]
[46,{"$f":"UPPER(IF($D50=\"\",\"\",VLOOKUP($D50,#REF!,6)))","v":""},{"$f":"UPPER(IF($D50=\"\",\"\",VLOOKUP($D50,#REF!,7)))","v":""}]
[47,{"$f":"UPPER(IF($D51=\"\",\"\",VLOOKUP($D51,#REF!,6)))","v":""},{"$f":"UPPER(IF($D51=\"\",\"\",VLOOKUP($D51,#REF!,7)))","v":""}]
[48,{"$f":"UPPER(IF($D52=\"\",\"\",VLOOKUP($D52,#REF!,6)))","v":""},{"$f":"UPPER(IF($D52=\"\",\"\",VLOOKUP($D52,#REF!,7)))","v":""}]
[49,{"$f":"UPPER(IF($D53=\"\",\"\",VLOOKUP($D53,#REF!,6)))","v":""},{"$f":"UPPER(IF($D53=\"\",\"\",VLOOKUP($D53,#REF!,7)))","v":""}]
[50,{"$f":"UPPER(IF($D54=\"\",\"\",VLOOKUP($D54,#REF!,6)))","v":""},{"$f":"UPPER(IF($D54=\"\",\"\",VLOOKUP($D54,#REF!,7)))","v":""}]
[51,{"$f":"UPPER(IF($D55=\"\",\"\",VLOOKUP($D55,#REF!,6)))","v":""},{"$f":"UPPER(IF($D55=\"\",\"\",VLOOKUP($D55,#REF!,7)))","v":""}]
[52,{"$f":"UPPER(IF($D56=\"\",\"\",VLOOKUP($D56,#REF!,6)))","v":""},{"$f":"UPPER(IF($D56=\"\",\"\",VLOOKUP($D56,#REF!,7)))","v":""}]
[53,{"$f":"UPPER(IF($D57=\"\",\"\",VLOOKUP($D57,#REF!,6)))","v":""},{"$f":"UPPER(IF($D57=\"\",\"\",VLOOKUP($D57,#REF!,7)))","v":""}]
[54,{"$f":"UPPER(IF($D58=\"\",\"\",VLOOKUP($D58,#REF!,6)))","v":""},{"$f":"UPPER(IF($D58=\"\",\"\",VLOOKUP($D58,#REF!,7)))","v":""}]
[55,{"$f":"UPPER(IF($D59=\"\",\"\",VLOOKUP($D59,#REF!,6)))","v":""},{"$f":"UPPER(IF($D59=\"\",\"\",VLOOKUP($D59,#REF!,7)))","v":""}]
[56,{"$f":"UPPER(IF($D60=\"\",\"\",VLOOKUP($D60,#REF!,6)))","v":""},{"$f":"UPPER(IF($D60=\"\",\"\",VLOOKUP($D60,#REF!,7)))","v":""}]
[57,{"$f":"UPPER(IF($D61=\"\",\"\",VLOOKUP($D61,#REF!,6)))","v":""},{"$f":"UPPER(IF($D61=\"\",\"\",VLOOKUP($D61,#REF!,7)))","v":""}]
[58,{"$f":"UPPER(IF($D62=\"\",\"\",VLOOKUP($D62,#REF!,6)))","v":""},{"$f":"UPPER(IF($D62=\"\",\"\",VLOOKUP($D62,#REF!,7)))","v":""}]
[59,{"$f":"UPPER(IF($D63=\"\",\"\",VLOOKUP($D63,#REF!,6)))","v":""},{"$f":"UPPER(IF($D63=\"\",\"\",VLOOKUP($D63,#REF!,7)))","v":""}]
[60,{"$f":"UPPER(IF($D64=\"\",\"\",VLOOKUP($D64,#REF!,6)))","v":""},{"$f":"UPPER(IF($D64=\"\",\"\",VLOOKUP($D64,#REF!,7)))","v":""}]
[61,{"$f":"UPPER(IF($D65=\"\",\"\",VLOOKUP($D65,#REF!,6)))","v":""},{"$f":"UPPER(IF($D65=\"\",\"\",VLOOKUP($D65,#REF!,7)))","v":""}]
[62,{"$f":"UPPER(IF($D66=\"\",\"\",VLOOKUP($D66,#REF!,6)))","v":""},{"$f":"UPPER(IF($D66=\"\",\"\",VLOOKUP($D66,#REF!,7)))","v":""}]
[63,{"$f":"UPPER(IF($D67=\"\",\"\",VLOOKUP($D67,#REF!,6)))","v":""},{"$f":"UPPER(IF($D67=\"\",\"\",VLOOKUP($D67,#REF!,7)))","v":""}]
[64,{"$f":"UPPER(IF($D68=\"\",\"\",VLOOKUP($D68,#REF!,6)))","v":""},{"$f":"UPPER(IF($D68=\"\",\"\",VLOOKUP($D68,#REF!,7)))","v":""}]
[]
[null,"W/0"]

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