{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculadora del ascenso","Datos"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculadora del ascenso","index":0,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,1,4,11],[1,1,1,23],[2,1,2,23]]}
[]
[null,"LA CALCULADORA DEL ASCENSO DIRECTO"]
[null,"Creada por Virgilio Correa para udlaspalmas.net"]
[]
[]
[null,"Jornada 37",null,null,null,null,null,"Jornada 40",null,null,null,null,null,null,null,null,"Puntos","PJ","PG","PE","PP","GF","GC","DG",null,null,"Puntos+DG",null,"Puntos+D+GF"]
[null,"Barcelona B","Girona FC",null,"-",null,null,"SD Ponferradina","Lugo",null,"-",null,null,{"$f":"RANK(AC7,$AC$7:$AC$13)","v":1},null,"Real Betis",{"$f":"3*S7+T7","v":72},{"$f":"36+IF(ISBLANK($D$11)+ISBLANK($F$11),0,1)+IF(ISBLANK($D$21)+ISBLANK($F$21),0,1)+IF(ISBLANK($D$30)+ISBLANK($F$30),0,1)+IF(ISBLANK($J$9)+ISBLANK($L$9),0,1)+IF(ISBLANK($J$17)+ISBLANK($L$17),0,1)+IF(ISBLANK($J$24)+ISBLANK($L$24),0,1)","v":36},{"$f":"21+IF($D$11-$F$11<0, 1,0)+IF($D$30-$F$30<0, 1,0)+IF($J$17-$L$17<0, 1,0)+IF($D$21-$F$21>0, 1,0)+IF($J$9-$L$9>0, 1,0)+IF($J$24-$L$24>0, 1,0)","v":21},{"$f":"9+IF(ISBLANK($D$11)+ISBLANK($F$11),0,1)*IF($D$11+$F$11=0, 1,0)+IF(ISBLANK($D$21)+ISBLANK($F$21),0,1)*IF($D$21+$F$21=0, 1,0)+IF(ISBLANK($D$30)+ISBLANK($F$30),0,1)*IF($D$30+$F$30=0, 1,0)+IF(ISBLANK($J$9)+ISBLANK($L$9),0,1)*IF($J$9+$L$9=0, 1,0)+IF(ISBLANK($J$17)+ISBLANK($L$17),0,1)*IF($J$17+$L$17=0, 1,0)+IF(ISBLANK($J$24)+ISBLANK($L$24),0,1)*IF($J$24+$L$24=0, 1,0)","v":9},{"$f":"6+IF($D$11-$F$11>0, 1,0)+IF($D$30-$F$30>0, 1,0)+IF($J$17-$L$17>0, 1,0)+IF($D$21-$F$21<0, 1,0)+IF($J$9-$L$9<0, 1,0)+IF($J$24-$L$24<0, 1,0)","v":6},{"$f":"59+$F$11+$D$21+$F$30+$J$24+$L$17+$J$9","v":59},{"$f":"31+$D$11+$F$21+$D$30+$L$24+$J$17+$L$9","v":31},{"$f":"V7-W7","v":28},null,{"$f":"IF(COUNTIF($Q$7:$Q$13, Q7) > 1, _xlfn.RANK.EQ(X7,$X$7:$X$13, 1) / 10, 0)","v":0},{"$f":"Q7+Z7","v":72},{"$f":"IF(COUNTIF($AA$7:$AA$13, AA7) > 1, _xlfn.RANK.EQ(V7,$V$7:$V$13, 1) / 100, 0)","v":0},{"$f":"AA7+AB7","v":72}]
[null,"Lugo","R. Sporting",null,"-",null,null,"UD Las Palmas","Barcelona B",null,"-",null,null,{"$f":"RANK(AC8,$AC$7:$AC$13)","v":2},null,"Girona FC",{"$f":"3*S8+T8","v":68},{"$f":"36+IF(ISBLANK($D$7)+ISBLANK($F$7),0,1)+IF(ISBLANK($D$19)+ISBLANK($F$19),0,1)+IF(ISBLANK($D$28)+ISBLANK($F$28),0,1)+IF(ISBLANK($J$10)+ISBLANK($L$10),0,1)+IF(ISBLANK($J$19)+ISBLANK($L$19),0,1)+IF(ISBLANK($J$26)+ISBLANK($L$26),0,1)","v":36},{"$f":"20+IF($D$7-$F$7<0, 1,0)+IF($D$28-$F$28<0, 1,0)+IF($J$19-$L$19<0, 1,0)+IF($D$19-$F$19>0, 1,0)+IF($J$10-$L$10>0, 1,0)+IF($J$26-$L$26>0, 1,0)","v":20},{"$f":"8+IF(ISBLANK($D$7)+ISBLANK($F$7),0,1)*IF($D$7+$F$7=0, 1,0)+IF(ISBLANK($D$19)+ISBLANK($F$19),0,1)*IF($D$19+$F$19=0, 1,0)+IF(ISBLANK($D$28)+ISBLANK($F$28),0,1)*IF($D$28+$F$28=0, 1,0)+IF(ISBLANK($J$10)+ISBLANK($L$10),0,1)*IF($J$10+$L$10=0, 1,0)+IF(ISBLANK($J$19)+ISBLANK($L$19),0,1)*IF($J$19+$L$19=0, 1,0)+IF(ISBLANK($J$26)+ISBLANK($L$26),0,1)*IF($J$26+$L$26=0, 1,0)","v":8},{"$f":"8+IF($D$7-$F$7>0, 1,0)+IF($D$28-$F$28>0, 1,0)+IF($J$19-$L$19>0, 1,0)+IF($D$19-$F$19<0, 1,0)+IF($J$10-$L$10<0, 1,0)+IF($J$26-$L$26<0, 1,0)","v":8},{"$f":"52+$F$7+$D$19+$F$28+$J$26+$L$19+$J$10","v":52},{"$f":"31+$D$7+$F$19+$D$28+$L$26+$J$19+$L$10","v":31},{"$f":"V8-W8","v":21},null,0,68,0,68]
[null,"Recreativo","R Valladolid CF",null,"-",null,null,"Real Betis","Alcorcón",null,"-",null,null,{"$f":"RANK(AC9,$AC$7:$AC$13)","v":3},null,"R. Sporting",{"$f":"3*S9+T9","v":66},{"$f":"36+IF(ISBLANK($D$8)+ISBLANK($F$8),0,1)+IF(ISBLANK($D$16)+ISBLANK($F$16),0,1)+IF(ISBLANK($D$26)+ISBLANK($F$26),0,1)+IF(ISBLANK($J$11)+ISBLANK($L$11),0,1)+IF(ISBLANK($J$16)+ISBLANK($L$16),0,1)+IF(ISBLANK($J$24)+ISBLANK($L$24),0,1)","v":36},{"$f":"16+IF($D$8-$F$8<0, 1,0)+IF($D$26-$F$26<0, 1,0)+IF($J$24-$L$24<0, 1,0)+IF($D$16-$F$16>0, 1,0)+IF($J$11-$L$11>0, 1,0)+IF($J$16-$L$16>0, 1,0)","v":16},{"$f":"18+IF(ISBLANK($D$8)+ISBLANK($F$8),0,1)*IF($D$8+$F$8=0, 1,0)+IF(ISBLANK($D$16)+ISBLANK($F$16),0,1)*IF($D$16+$F$16=0, 1,0)+IF(ISBLANK($D$26)+ISBLANK($F$26),0,1)*IF($D$26+$F$26=0, 1,0)+IF(ISBLANK($J$11)+ISBLANK($L$11),0,1)*IF($J$11+$L$11=0, 1,0)+IF(ISBLANK($J$16)+ISBLANK($L$16),0,1)*IF($J$16+$L$16=0, 1,0)+IF(ISBLANK($J$24)+ISBLANK($L$24),0,1)*IF($J$24+$L$24=0, 1,0)","v":18},{"$f":"2+IF($D$8-$F$8>0, 1,0)+IF($D$26-$F$26>0, 1,0)+IF($J$24-$L$24>0, 1,0)+IF($D$16-$F$16<0, 1,0)+IF($J$11-$L$11<0, 1,0)+IF($J$16-$L$16<0, 1,0)","v":2},{"$f":"45+$F$8+$D$16+$F$26+$L$24+$J$16+$J$11","v":45},{"$f":"25+$D$8+$F$16+$D$26+$J$24+$L$16+$L$11","v":25},{"$f":"V9-W9","v":20},null,0,66,0,66]
[null,"Leganés ","UD Las Palmas",null,"-",null,null,"Girona FC","Llagostera",null,"-",null,null,{"$f":"RANK(AC10,$AC$7:$AC$13)","v":4},null,"UD Las Palmas",{"$f":"3*S10+T10","v":63},{"$f":"36+IF(ISBLANK($D$10)+ISBLANK($F$10),0,1)+IF(ISBLANK($D$18)+ISBLANK($F$18),0,1)+IF(ISBLANK($D$25)+ISBLANK($F$25),0,1)+IF(ISBLANK($J$8)+ISBLANK($L$8),0,1)+IF(ISBLANK($J$21)+ISBLANK($L$21),0,1)+IF(ISBLANK($J$28)+ISBLANK($L$28),0,1)","v":36},{"$f":"17+IF($D$10-$F$10<0, 1,0)+IF($D$25-$F$25<0, 1,0)+IF($J$21-$L$21<0, 1,0)+IF($D$18-$F$18>0, 1,0)+IF($J$8-$L$8>0, 1,0)+IF($J$28-$L$28>0, 1,0)","v":17},{"$f":"12+IF(ISBLANK($D$10)+ISBLANK($F$10),0,1)*IF($D$10+$F$10=0, 1,0)+IF(ISBLANK($D$18)+ISBLANK($F$18),0,1)*IF($D$18+$F$18=0, 1,0)+IF(ISBLANK($D$25)+ISBLANK($F$25),0,1)*IF($D$25+$F$25=0, 1,0)+IF(ISBLANK($J$8)+ISBLANK($L$8),0,1)*IF($J$8+$L$8=0, 1,0)+IF(ISBLANK($J$21)+ISBLANK($L$21),0,1)*IF($J$21+$L$21=0, 1,0)+IF(ISBLANK($J$28)+ISBLANK($L$28),0,1)*IF($J$28+$L$28=0, 1,0)","v":12},{"$f":"7+IF($D$10-$F$10>0, 1,0)+IF($D$25-$F$25>0, 1,0)+IF($J$21-$L$21>0, 1,0)+IF($D$18-$F$18<0, 1,0)+IF($J$8-$L$8<0, 1,0)+IF($J$28-$L$28<0, 1,0)","v":7},{"$f":"58+$F$10+$D$18+$F$25+$J$28+$L$21+$J$8","v":58},{"$f":"39+$D$10+$F$18+$D$25+$L$28+$J$21+$L$8","v":39},{"$f":"V10-W10","v":19},null,0,63,0,63]
[null,"Mallorca","Real Betis",null,"-",null,null,"R. Sporting","Tenerife",null,"-",null,null,{"$f":"RANK(AC11,$AC$7:$AC$13)","v":5},null,"R Valladolid CF",{"$f":"3*S11+T11","v":62},{"$f":"36+IF(ISBLANK($D$9)+ISBLANK($F$9),0,1)+IF(ISBLANK($D$17)+ISBLANK($F$17),0,1)+IF(ISBLANK($D$24)+ISBLANK($F$24),0,1)+IF(ISBLANK($J$12)+ISBLANK($L$12),0,1)+IF(ISBLANK($J$20)+ISBLANK($L$20),0,1)+IF(ISBLANK($J$27)+ISBLANK($L$27),0,1)","v":36},{"$f":"18+IF($D$9-$F$9<0, 1,0)+IF($D$24-$F$24<0, 1,0)+IF($J$20-$L$20<0, 1,0)+IF($D$17-$F$17>0, 1,0)+IF($J$12-$L$12>0, 1,0)+IF($J$27-$L$27>0, 1,0)","v":18},{"$f":"8+IF(ISBLANK($D$9)+ISBLANK($F$9),0,1)*IF($D$9+$F$9=0, 1,0)+IF(ISBLANK($D$17)+ISBLANK($F$17),0,1)*IF($D$17+$F$17=0, 1,0)+IF(ISBLANK($D$24)+ISBLANK($F$24),0,1)*IF($D$24+$F$24=0, 1,0)+IF(ISBLANK($J$12)+ISBLANK($L$12),0,1)*IF($J$12+$L$12=0, 1,0)+IF(ISBLANK($J$20)+ISBLANK($L$20),0,1)*IF($J$20+$L$20=0, 1,0)+IF(ISBLANK($J$27)+ISBLANK($L$27),0,1)*IF($J$27+$L$27=0, 1,0)","v":8},{"$f":"10+IF($D$9-$F$9>0, 1,0)+IF($D$24-$F$24>0, 1,0)+IF($J$20-$L$20>0, 1,0)+IF($D$17-$F$17<0, 1,0)+IF($J$12-$L$12<0, 1,0)+IF($J$27-$L$27<0, 1,0)","v":10},{"$f":"53+$F$9+$D$17+$F$24+$J$27+$L$20+$J$12","v":53},{"$f":"31+$D$9+$F$17+$D$24+$L$27+$J$20+$L$12","v":31},{"$f":"V11-W11","v":22},null,0,62,0,62]
[null,"Alavés ","SD Ponferradina",null,"-",null,null,"R Valladolid CF","R. Zaragoza",null,"-",null,null,{"$f":"RANK(AC12,$AC$7:$AC$13)","v":6},null,"SD Ponferradina",{"$f":"3*S12+T12","v":53},{"$f":"36+IF(ISBLANK($D$12)+ISBLANK($F$12),0,1)+IF(ISBLANK($D$20)+ISBLANK($F$20),0,1)+IF(ISBLANK($D$27)+ISBLANK($F$27),0,1)+IF(ISBLANK($J$7)+ISBLANK($L$7),0,1)+IF(ISBLANK($J$18)+ISBLANK($L$18),0,1)+IF(ISBLANK($J$25)+ISBLANK($L$25),0,1)","v":36},{"$f":"14+IF($D$12-$F$12<0, 1,0)+IF($D$27-$F$27<0, 1,0)+IF($J$18-$L$18<0, 1,0)+IF($D$20-$F$20>0, 1,0)+IF($J$7-$L$7>0, 1,0)+IF($J$25-$L$25>0, 1,0)","v":14},{"$f":"11+IF(ISBLANK($D$12)+ISBLANK($F$12),0,1)*IF($D$12+$F$12=0, 1,0)+IF(ISBLANK($D$20)+ISBLANK($F$20),0,1)*IF($D$20+$F$20=0, 1,0)+IF(ISBLANK($D$27)+ISBLANK($F$27),0,1)*IF($D$27+$F$27=0, 1,0)+IF(ISBLANK($J$7)+ISBLANK($L$7),0,1)*IF($J$7+$L$7=0, 1,0)+IF(ISBLANK($J$18)+ISBLANK($L$18),0,1)*IF($J$18+$L$18=0, 1,0)+IF(ISBLANK($J$25)+ISBLANK($L$25),0,1)*IF($J$25+$L$25=0, 1,0)","v":11},{"$f":"11+IF($D$12-$F$12>0, 1,0)+IF($D$27-$F$27>0, 1,0)+IF($J$18-$L$18>0, 1,0)+IF($D$20-$F$20<0, 1,0)+IF($J$7-$L$7<0, 1,0)+IF($J$25-$L$25<0, 1,0)","v":11},{"$f":"51+$F$12+$D$20+$F$27+$J$25+$L$18+$J$7","v":51},{"$f":"46+$D$12+$F$20+$D$27+$L$25+$J$18+$L$7","v":46},{"$f":"V12-W12","v":5},null,0.2,53.2,0,53.2]
[null,"R. Zaragoza","Albacete",null,"-",null,null,null,null,null,null,null,null,{"$f":"RANK(AC13,$AC$7:$AC$13)","v":7},null,"R. Zaragoza",{"$f":"3*S13+T13","v":53},{"$f":"36+IF(ISBLANK($D$13)+ISBLANK($F$13),0,1)+IF(ISBLANK($D$19)+ISBLANK($F$19),0,1)+IF(ISBLANK($D$29)+ISBLANK($F$29),0,1)+IF(ISBLANK($J$12)+ISBLANK($L$12),0,1)+IF(ISBLANK($J$21)+ISBLANK($L$21),0,1)+IF(ISBLANK($J$29)+ISBLANK($L$29),0,1)","v":36},{"$f":"13+IF($D$19-$F$19<0, 1,0)+IF($J$12-$L$12<0, 1,0)+IF($J$29-$L$29<0, 1,0)+IF($D$13-$F$13>0, 1,0)+IF($D$29-$F$29>0, 1,0)+IF($J$21-$L$21>0, 1,0)","v":13},{"$f":"14+IF(ISBLANK($D$13)+ISBLANK($F$13),0,1)*IF($D$13+$F$13=0, 1,0)+IF(ISBLANK($D$19)+ISBLANK($F$19),0,1)*IF($D$19+$F$19=0, 1,0)+IF(ISBLANK($D$29)+ISBLANK($F$29),0,1)*IF($D$29+$F$29=0, 1,0)+IF(ISBLANK($J$12)+ISBLANK($L$12),0,1)*IF($J$12+$L$12=0, 1,0)+IF(ISBLANK($J$21)+ISBLANK($L$21),0,1)*IF($J$21+$L$21=0, 1,0)+IF(ISBLANK($J$29)+ISBLANK($L$29),0,1)*IF($J$29+$L$29=0, 1,0)","v":14},{"$f":"9+IF($D$19-$F$19>0, 1,0)+IF($J$12-$L$12>0, 1,0)+IF($J$29-$L$29>0, 1,0)+IF($D$13-$F$13<0, 1,0)+IF($D$29-$F$29<0, 1,0)+IF($J$21-$L$21<0, 1,0)","v":9},{"$f":"52+$D$13+$F$19+$D$29+$L$29+$J$21+$L$12","v":52},{"$f":"50+$F$13+$D$19+$F$29+$J$29+$L$21+$J$12","v":50},{"$f":"V13-W13","v":2},null,0.1,53.1,0,53.1]
[]
[null,"Jornada 38",null,null,null,null,null,"Jornada 41"]
[null,"R. Sporting","Racing",null,"-",null,null,"R. Sporting","Sabadell",null,"-"]
[null,"R Valladolid CF","Osasuna",null,"-",null,null,"Tenerife","Real Betis",null,"-"]
[null,"UD Las Palmas","Recreativo",null,"-",null,null,"Racing","SD Ponferradina",null,"-"]
[null,"Girona FC","R. Zaragoza",null,"-",null,null,"Mallorca","Girona FC",null,"-"]
[null,"SD Ponferradina","Llagostera",null,"-",null,null,"Alavés","R Valladolid CF",null,"-"]
[null,"Real Betis","Lugo",null,"-",null,null,"R. Zaragoza","UD Las Palmas",null,"-"]
[]
[null,"Jornada 39",null,null,null,null,null,"Jornada 42"]
[null,"Barcelona B","R Valladolid CF",null,"-",null,null,"Real Betis","R. Sporting",null,"-"]
[null,"Osasuna","UD Las Palmas",null,"-",null,null,"SD Ponferradina","Alcorcón",null,"-"]
[null,"Alcorcón","R. Sporting",null,"-",null,null,"Girona FC","Lugo",null,"-"]
[null,"Mallorca","SD Ponferradina",null,"-",null,null,"R Valladolid CF","Llagostera",null,"-"]
[null,"Alavés ","Girona FC",null,"-",null,null,"UD Las Palmas","Alavés",null,"-"]
[null,"R. Zaragoza","Mirandés",null,"-",null,null,"Leganés","R. Zaragoza",null,"-"]
[null,"Racing","Real Betis",null,"-"]
[]
[null,"¿Cómo usar la calculadora del ascenso directo?"]
[null,"1) Si se le pregunta al abrir el fichero, habilite las macros. Esto es para que se pueda ordenar la clasificación."]
[null,"2) Rellene las tablas de las jornadas con los pronósticos que Ud. considere (se desplegará una lista con la que introducir los goles). Revise que cada jornada está completa."]
[null,"3) Finalmente, para ordenar la tabla, pulse en \"Actualizar tabla\". Tras ello, habrá visto ya el resultado de su pronóstico. Para empezar de nuevo, pulse \"Borrar pronósticos\"."]
[]
[null,"Consideraciones"]
[null,"La tabla se ordena por puntos. Si existe un empate, este se deshace por diferencia de goles. Si persiste el empate, por goles a favor. Por tanto, no se tienen en cuenta enfrentamientos directos (UD Las Palmas lo tiene ganado con Girona FC, R. Valladolid CF"]
[null," y SD Ponferradina, empatado con R. Sporting y perdido con Real Betis)"]
[null,"Se han tenido en cuenta únicamente a aquellos equipos que tienen posibilidades reales de ascender directamente. Por tanto, esta calculadora no es idónea para ver cómo quedarían los play-off."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Virgilio Correa"]

{"sheet":"Datos","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Resultados"]
[null,0]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]