{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instrucciones","BAREMACION","BASES"],"not_rendered":{"images":5,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Instrucciones","index":0,"n_rows":12,"n_cols":1,"rows_kept":12}
["INSTRUCCIONES"]
[]
["1. En la Pestaña BASES encontraréis el resumen de los puntos por cada apartado, con sus límites máximos"]
[]
["2. En la Pestaña BAREMACION está el formulario de Autobaremación"]
[]
["3. Solo se puede escribir en las celdas en las que hay que poner algún dato para evitar borrar accidentalmente alguna fórmula"]
[]
["4. Antes de iniciar la autobaremación, borrar todos los datos que haya escritos (parece obvio, pero por si acaso…)"]
["para hacerlo todo a la vez, solo tienes que pulsar la goma de borrar que está dentro de la hoja de Baremación."]
[]
["5. Por último, al final de la hoja vienen los puntos que se han obtenido en cada cuerpo en el que nos presentamos. Solo valen los que están en amarillo, ya que se aplican los máximos de cada apartado."]

{"sheet":"BAREMACION","index":1,"n_rows":61,"n_cols":12,"rows_kept":61,"merged":[[1,0,1,2],[1,4,1,6],[12,11,13,13],[14,3,16,3],[17,3,19,3],[20,3,21,3],[24,4,24,5],[24,6,24,7],[43,0,43,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[48,2,48,3],[49,2,49,3],[50,2,50,3],[52,2,53,3],[52,4,52,5],[52,6,52,7],[52,8,52,9],[56,2,57,2]]}
[]
["cursos",{"$nulls":3},"ejercicios aprobados"]
["de","a","puntos",100,"de","a","puntos"]
[11,29,1,null,{"v":0.5,"d":"50%"},{"v":0.5499,"d":"55%"},5]
[30,59,1.5,null,{"v":0.55,"d":"55%"},{"v":0.5999,"d":"60%"},5.5]
[60,119,2,null,{"v":0.6,"d":"60%"},{"v":0.6498999999999999,"d":"65%"},6]
[120,1000,2.5,null,{"v":0.65,"d":"65%"},{"v":0.6999,"d":"70%"},6.5]
[{"$nulls":4},{"v":0.7,"d":"70%"},{"v":0.7498999999999999,"d":"75%"},7]
[{"$nulls":4},{"v":0.75,"d":"75%"},{"v":0.7998999999999999,"d":"80%"},7.5]
[{"$nulls":4},{"v":0.8,"d":"80%"},{"v":0.8499,"d":"85%"},8]
[{"$nulls":4},{"v":0.85,"d":"85%"},{"v":0.8998999999999999,"d":"90%"},8.5]
[{"$nulls":4},{"v":0.9,"d":"90%"},{"v":1,"d":"100%"},9]
[{"$nulls":8},{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"},null,"para borrar datos haz click en la goma de borrar"]
[null,"MAX",22,"EJERCICIOS APROBADOS","nota obtenida","nota max","nota en %","puntuacion en el propio cuerpo","puntuacion en cuerpo inferior","puntuacion en cuerpo superior"]
[{"$nulls":3},"GESTION",44.25,60,{"$f":"IFERROR(+E15/F15,\"no apto\")","v":{"v":0.7375,"d":"74%"}},{"$f":"IFERROR(INDIRECT(\"g\"&SUMPRODUCT(--($E$4:$E$12<=G15)*($F$4:$F$12>=G15),ROW($E$4:$E$12))),0)","v":{"v":7,"d":"7.00"}},{"$f":"IFERROR(H15*I$13,\"\")","v":1.75},{"$f":"IFERROR(H15*J$13,0)","v":{"v":3.5,"d":"3.50"}}]
[{"$nulls":4},15,15,{"$f":"IFERROR(+E16/F16,\"no apto\")","v":{"v":1,"d":"100%"}},{"$f":"IFERROR(INDIRECT(\"g\"&SUMPRODUCT(--($E$4:$E$12<=G16)*($F$4:$F$12>=G16),ROW($E$4:$E$12))),0)","v":{"v":9,"d":"9.00"}},{"$f":"IFERROR(H16*I$13,0)","v":2.25},{"$f":"IFERROR(H16*J$13,0)","v":{"v":4.5,"d":"4.50"}}]
[{"$nulls":4},20,25,{"v":0.8,"d":"80%"},{"$f":"IFERROR(INDIRECT(\"g\"&SUMPRODUCT(--($E$4:$E$12<=G17)*($F$4:$F$12>=G17),ROW($E$4:$E$12))),0)","v":{"v":8,"d":"8.00"}},{"$f":"IFERROR(H17*I$13,0)","v":{"v":2,"d":"2.00"}},{"v":4,"d":"4.00"}]
[{"$nulls":3},"TRAMITACION",48.15,60,{"v":0.8025,"d":"80%"},{"$f":"IFERROR(INDIRECT(\"g\"&SUMPRODUCT(--($E$4:$E$12<=G18)*($F$4:$F$12>=G18),ROW($E$4:$E$12))),0)","v":{"v":8,"d":"8.00"}},{"v":2,"d":"2.00"},{"v":4,"d":"4.00"}]
[{"$nulls":4},17.5,20,{"v":0.875,"d":"88%"},{"$f":"IFERROR(INDIRECT(\"g\"&SUMPRODUCT(--($E$4:$E$12<=G19)*($F$4:$F$12>=G19),ROW($E$4:$E$12))),0)","v":{"v":8.5,"d":"8.50"}},{"v":2.125,"d":"2.13"},4.25]
[{"$nulls":4},18.34,20,{"v":0.917,"d":"92%"},{"$f":"IFERROR(INDIRECT(\"g\"&SUMPRODUCT(--($E$4:$E$12<=G20)*($F$4:$F$12>=G20),ROW($E$4:$E$12))),0)","v":{"v":9,"d":"9.00"}},2.25,{"v":4.5,"d":"4.50"}]
[{"$nulls":3},"AUXILIO",51,60,{"v":0.85,"d":"85%"},{"$f":"IFERROR(INDIRECT(\"g\"&SUMPRODUCT(--($E$4:$E$12<=G21)*($F$4:$F$12>=G21),ROW($E$4:$E$12))),0)","v":{"v":8.5,"d":"8.50"}},{"v":2.125,"d":"2.13"},4.25]
[{"$nulls":4},32.8,40,{"v":0.82,"d":"82%"},{"$f":"IFERROR(INDIRECT(\"g\"&SUMPRODUCT(--($E$4:$E$12<=G22)*($F$4:$F$12>=G22),ROW($E$4:$E$12))),0)","v":{"v":8,"d":"8.00"}},{"v":2,"d":"2.00"},{"v":4,"d":"4.00"}]
[]
[{"$nulls":4},"MAX",5.5,null,2.5]
[{"$nulls":4},"Juridico",null,"informatica"]
[null,"MAX",8,"CURSOS","horas","puntos","horas","puntos"]
[{"$nulls":4},120,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=E27)*($B$4:$B$7>=E27),ROW($A$4:$A$7))),\"\")","v":{"v":2.5,"d":"2.50"}},120,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=G27)*($B$4:$B$7>=G27),ROW($A$4:$A$7))),\"\")","v":{"v":2.5,"d":"2.50"}}]
[{"$nulls":4},120,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=E28)*($B$4:$B$7>=E28),ROW($A$4:$A$7))),\"\")","v":{"v":2.5,"d":"2.50"}},200,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=G28)*($B$4:$B$7>=G28),ROW($A$4:$A$7))),\"\")","v":{"v":2.5,"d":"2.50"}}]
[{"$nulls":4},65,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=E29)*($B$4:$B$7>=E29),ROW($A$4:$A$7))),\"\")","v":{"v":2,"d":"2.00"}},1,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=G29)*($B$4:$B$7>=G29),ROW($A$4:$A$7))),\"\")","v":""}]
[{"$nulls":4},30,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=E30)*($B$4:$B$7>=E30),ROW($A$4:$A$7))),\"\")","v":{"v":1.5,"d":"1.50"}},25,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=G30)*($B$4:$B$7>=G30),ROW($A$4:$A$7))),\"\")","v":{"v":1,"d":"1.00"}}]
[{"$nulls":4},50,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=E31)*($B$4:$B$7>=E31),ROW($A$4:$A$7))),\"\")","v":{"v":1.5,"d":"1.50"}},558,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=G31)*($B$4:$B$7>=G31),ROW($A$4:$A$7))),\"\")","v":{"v":2.5,"d":"2.50"}}]
[{"$nulls":4},35,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=E32)*($B$4:$B$7>=E32),ROW($A$4:$A$7))),\"\")","v":{"v":1.5,"d":"1.50"}},20,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=G32)*($B$4:$B$7>=G32),ROW($A$4:$A$7))),\"\")","v":{"v":1,"d":"1.00"}}]
[{"$nulls":4},111,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=E33)*($B$4:$B$7>=E33),ROW($A$4:$A$7))),\"\")","v":{"v":2,"d":"2.00"}},12,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=G33)*($B$4:$B$7>=G33),ROW($A$4:$A$7))),\"\")","v":{"v":1,"d":"1.00"}}]
[{"$nulls":4},444,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=E34)*($B$4:$B$7>=E34),ROW($A$4:$A$7))),\"\")","v":{"v":2.5,"d":"2.50"}},25,{"$f":"IFERROR(INDIRECT(\"c\"&SUMPRODUCT(--($A$4:$A$7<=G34)*($B$4:$B$7>=G34),ROW($A$4:$A$7))),\"\")","v":{"v":1,"d":"1.00"}}]
[{"$nulls":5},{"$f":"SUM(F27:F34)","v":{"v":16,"d":"16.00"}},null,{"$f":"SUM(H27:H34)","v":{"v":11.5,"d":"11.50"}}]
[{"$nulls":4},"tope",{"$f":"IF(F35>F24,F24,F35)","v":{"v":5.5,"d":"5.50"}},null,{"$f":"IF(H35>H24,H24,H35)","v":{"v":2.5,"d":"2.50"}}]
[]
[null,"MAX",10,"TITULOS","GESTION Y TRAMITACION",null,null,"AUXILIO"]
[{"$nulls":3},"Licenciatura Derecho o Grado + Máster Derecho:",10,null,"Licenciatura Derecho: ",8]
[{"$nulls":3},"Grado en Derecho: ",9,null,"Grado Derecho: ",7]
[{"$nulls":3},"(1)Licenciatura o grado:",4,null,"Carrera Jurídica1: ",3]
[{"$nulls":3},"Relaciones laborales: ",3,null,"Resto carreras: ",2]
[{"$nulls":3},"Otras: ",2,null,"Bachillerato: ",3]
["Poner aqui la puntuación que corresponda según titulación",{"$nulls":3},10,null,null,8]
[]
[{"$nulls":5},{"v":0.2,"d":"0.20"},null,{"v":0.1,"d":"0.10"},null,0.05]
[null,"MAX",60,"SERVICIOS PRESTADOS","EN EL MISMO CUERPO",null,"EN OTRO CUERPO",null,"LABORAL JUSTICIA"]
[{"$nulls":4},"MESES","PUNTOS","MESES","PUNTOS","MESES","PUNTOS"]
[null,null,"Para GESTION",null,120,{"$f":"+E49*F$46","v":{"v":24,"d":"24.00"}},60,{"$f":"+G49*H$46","v":{"v":6,"d":"6.00"}},20,{"$f":"+I49*J$46","v":{"v":1,"d":"1.00"}}]
[null,null,"para TRAMITACION",null,50,{"$f":"+E50*F$46","v":{"v":10,"d":"10.00"}},140,{"v":14,"d":"14.00"},20,{"$f":"+I50*J$46","v":{"v":1,"d":"1.00"}}]
[null,null,"para AUXILIO",null,10,{"v":2,"d":"2.00"},70,{"v":7,"d":"7.00"},20,{"$f":"+I51*J$46","v":{"v":1,"d":"1.00"}}]
[]
[null,null,"RESULTADO AUTOBAREMACION",null,"GESTION",null,"TRAMITACION",null,"AUXILIO"]
[{"$nulls":4},"puntos","Puntuación topada","puntos","Puntuación topada","puntos","Puntuación topada"]
[{"$nulls":3},"SERVICIOS PRESTADOS",{"$f":"+F49+H49+J49","v":{"v":31,"d":"31.00"}},{"$f":"IF(E55>$C$47,$C$47,E55)","v":{"v":31,"d":"31.00"}},{"$f":"+F50+H50+J50","v":{"v":25,"d":"25.00"}},{"$f":"IF(G55>$C$47,$C$47,G55)","v":{"v":25,"d":"25.00"}},{"$f":"+F51+H51+J51","v":{"v":10,"d":"10.00"}},{"$f":"IF(I55>$C$47,$C$47,I55)","v":{"v":10,"d":"10.00"}}]
[{"$nulls":3},"TITULACION",{"$f":"+E44","v":{"v":10,"d":"10.00"}},{"$f":"IF(E56>$C$38,$C$38,E56)","v":{"v":10,"d":"10.00"}},{"$f":"+E44","v":{"v":10,"d":"10.00"}},{"$f":"IF(G56>$C$38,$C$38,G56)","v":{"v":10,"d":"10.00"}},{"$f":"+H44","v":{"v":8,"d":"8.00"}},{"$f":"IF(I56>$C$38,$C$38,I56)","v":{"v":8,"d":"8.00"}}]
[null,null,"CURSOS","JURIDICOS",{"$f":"SUM($F$27:$F$34)","v":{"v":16,"d":"16.00"}},{"$f":"IF(E57>$F$24,$F$24,E57)","v":{"v":5.5,"d":"5.50"}},{"$f":"SUM($F$27:$F$34)","v":{"v":16,"d":"16.00"}},{"$f":"IF(G57>$F$24,$F$24,G57)","v":{"v":5.5,"d":"5.50"}},{"$f":"SUM($F$27:$F$34)","v":{"v":16,"d":"16.00"}},{"$f":"IF(I57>$F$24,$F$24,I57)","v":{"v":5.5,"d":"5.50"}}]
[{"$nulls":3},"INFORMATICOS",{"$f":"SUM($H$27:$H$34)","v":{"v":11.5,"d":"11.50"}},{"$f":"IF(E58>$H$24,$H$24,E58)","v":{"v":2.5,"d":"2.50"}},{"$f":"SUM($H$27:$H$34)","v":{"v":11.5,"d":"11.50"}},{"$f":"IF(G58>$H$24,$H$24,G58)","v":{"v":2.5,"d":"2.50"}},{"$f":"SUM($H$27:$H$34)","v":{"v":11.5,"d":"11.50"}},{"$f":"IF(I58>$H$24,$H$24,I58)","v":{"v":2.5,"d":"2.50"}}]
[{"$nulls":3},"SUMA CURSOS",{"$f":"+E57+E58","v":{"v":27.5,"d":"27.50"}},{"$f":"IF(E59>$C$26,$C$26,E59)","v":{"v":8,"d":"8.00"}},{"$f":"+G57+G58","v":{"v":27.5,"d":"27.50"}},{"$f":"IF(G59>$C$26,$C$26,G59)","v":{"v":8,"d":"8.00"}},{"$f":"+I57+I58","v":{"v":27.5,"d":"27.50"}},{"$f":"IF(I59>$C$26,$C$26,I59)","v":{"v":8,"d":"8.00"}}]
[{"$nulls":3},"EJERCICIOS ANTERORES",{"$f":"+H15+H16+H17+I18+I19+I20+I21+I22","v":{"v":34.5,"d":"34.50"}},{"$f":"IF(E60>$C$14,$C$14,E60)","v":{"v":22,"d":"22.00"}},{"$f":"+H18+H19+H20+I21+I22+J15+J16+J17","v":{"v":41.625,"d":"41.63"}},{"$f":"IF(G60>$C$14,$C$14,G60)","v":{"v":22,"d":"22.00"}},{"$f":"+H21+H22+J15+J16+J17+J18+J19+J20","v":41.25},{"$f":"IF(I60>$C$14,$C$14,I60)","v":{"v":22,"d":"22.00"}}]
[{"$nulls":3},"TOTAL PUNTOS",{"$f":"+E55+E56+E59+E60","v":{"v":103,"d":"103.00"}},{"v":71,"d":"71.00"},{"v":104.125,"d":"104.13"},{"v":65,"d":"65.00"},86.75,{"v":48,"d":"48.00"}]

{"sheet":"BASES","index":2,"n_rows":35,"n_cols":22,"rows_kept":35,"merged":[[0,0,0,3],[1,7,2,8],[1,9,2,11],[1,12,2,13],[2,1,2,3],[3,0,5,0],[3,6,5,6],[3,7,3,8],[3,9,3,11],[3,12,3,13],[4,7,4,8],[4,9,4,11],[4,12,4,13],[5,7,5,8],[5,9,5,11],[5,12,5,13],[6,0,11,0],[6,1,6,2],[6,7,6,8],[6,9,6,11],[6,12,6,13],[7,1,7,2],[7,6,11,6],[7,7,7,8],[7,9,7,11],[7,12,7,13],[8,1,8,2],[8,7,8,8],[8,9,8,11],[8,12,8,13],[9,1,9,2],[9,7,9,8],[9,9,9,11],[9,12,9,13],[10,1,10,2],[10,7,10,8],[10,9,10,11],[10,12,10,13],[11,1,11,2],[11,7,11,8],[11,9,11,11],[11,12,11,13],[12,7,12,8],[12,9,12,11],[12,12,12,13],[13,0,17,0],[13,6,18,6],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,0,29,0],[18,1,18,2],[18,9,18,10],[19,7,19,8],[19,9,19,11],[19,12,19,13],[20,6,32,6],[21,15,23,15],[24,15,26,15],[27,15,28,15],[28,1,28,2],[29,1,29,2],[33,7,33,8],[33,9,33,11],[33,12,33,13],[34,7,34,8],[34,9,34,11],[34,12,34,13]]}
["CONCURSO DE MERITOS"]
["","GESTIÓN PROCESAL","TRAMITACIÓN","AUXILIO",{"$nulls":3},"GESTION",null,"TRAMITACION",null,null,"AUXILIO"]
["PUNTUACIÓN MÍNIMA","Será necesario obtener un mínimo de 15 puntos en su conjunto"]
["SERVICIOS PRESTADOS (máximo 60)","Gestión: 0,20 ptos/mes","Tramitación: 0,20 ptos/mes","Auxilio: 0,20 ptos/mes",null,null,"SERVICIOS PRESTADOS (máximo 60)",0,null,0,null,null,0]
[null,"Resto cuerpos grales: 0,10 ptos/mes","Resto cuerpos grales: 0,10 ptos/mes","Resto cuerpos grales: 0,10 ptos/mes",{"$nulls":3},0,null,0,null,null,0]
[null,"Laboral justicia: 0,05 ptos/mes","Laboral justicia: 0,05 ptos/mes","Laboral justicia: 0,05 ptos/mes",{"$nulls":3},0,null,0,null,null,0]
["TÍTULOS ACADÉMICOS\n(máximo 10)","GESTIÓN Y TRAMITACIÓN",null,"AUXILIO",null,null,"TOTAL SP",{"$f":"SUM(H3:H6)","v":0},null,{"$f":"SUM(J3:J6)","v":0},null,null,{"$f":"SUM(M3:M6)","v":0}]
[null,"Licenciatura Derecho o Grado + Máster Derecho: 10 puntos",null,"Licenciatura Derecho: 8",null,null,"TÍTULOS ACADÉMICOS\n(máximo 10)",10,null,10,null,null,8]
[null,"Grado en Derecho: 9 puntos",null,"Grado Derecho: 7"]
[null,"(1)Licenciatura o grado: 4 puntos",null,"Carrera Jurídica1: 3"]
[null,"Relaciones laborales: 3 puntos",null,"Resto carreras: 2"]
[null,"Otras: 2 puntos",null,"Bachillerato: 3"]
[{"$nulls":6},"TOTAL TITULOS",{"$f":"IF(SUM(H8:H12)>10,10,SUM(H8:H12))","v":10},null,{"$f":"IF(SUM(J8:J12)>10,10,SUM(J8:J12))","v":10},null,null,{"$f":"IF(SUM(M8:M12)>10,10,SUM(M8:M12))","v":8}]
["CURSOS DE FORMACIÓN (máximo 8)","Jurídicos (5,5):","Informáticos (2,5):",{"$nulls":3},"CURSOS DE FORMACIÓN (máximo 8)","Juridicos ","Informáticos","Juridicos ",null,"Informáticos","Juridicos ","Informáticos"]
[null,"Entre 11 y 29 h: 1 puntos.","Entre 11 y 29 h: 1 puntos.",{"$nulls":4},2.5,2.5,2.5,null,2.5,2.5,2.5]
[null,"Entre 30 y 59 h: 1,5 puntos","Entre 30 y 59 h: 1,5 puntos",{"$nulls":4},2.5,null,2.5,null,null,2.5]
[null,"Entre 60 y 119 h: 2 puntos.","Entre 60 y 119 h: 2 puntos.",{"$nulls":4},2,null,2,null,null,2]
[null,"Entre 120 o más h: 2,5 puntos","Entre 120 o más h: 2,5 puntos"]
["EJERCICIOS APROBADOS (máximo 22)","Por exámenes del mismo cuerpo:",{"$nulls":5},{"$f":"SUM(H15:H18)","v":7},{"$f":"SUM(I15:I18)","v":2.5},7,null,2.5,7,2.5]
[null,"por nota del 50 al 54,99%",5,{"$nulls":3},"TOTAL CURSOS",{"$f":"IF(SUM(H19:I19)>8,8,SUM(H19:I19))","v":8},null,{"$f":"IF(SUM(J19:L19)>8,8,SUM(J19:L19))","v":8},null,null,{"$f":"IF(SUM(M19:N19)>8,8,SUM(M19:N19))","v":8}]
[null,"por nota del 55 al 59,99%",5.5,{"$nulls":3},"EJERCICIOS APROBADOS (máximo 22)","Mismo cuerpo","cuerpo inferior","Mismo cuerpo","cuerpo superior","cuerpo inferior","Mismo cuerpo","cuerpo superior",null,null,"nota obtenida","nota max","nota en %",{"v":1,"d":"100%"},{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"}]
[null,"por nota de 60 al 64,99%",6,{"$nulls":4},{"v":7,"d":"7.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"},{"v":3.5,"d":"3.50"},{"v":2.125,"d":"2.13"},{"v":8.5,"d":"8.50"},{"v":3.5,"d":"3.50"},null,"GESTION",44.25,60,{"$f":"IFERROR(+Q22/R22,\"no apto\")","v":{"v":0.7375,"d":"73.8%"}},7,{"$f":"+T22*$U$21","v":1.75},{"$f":"+T22*$V$21","v":{"v":3.5,"d":"3.50"}}]
[null,"por nota de 65 al 69,99%",6.5,{"$nulls":5},{"v":2.125,"d":"2.13"},{"v":8.5,"d":"8.50"},null,{"v":2,"d":"2.00"},{"v":8,"d":"8.00"},{"v":4,"d":"4.00"},null,null,"-",15,{"$f":"IFERROR(+Q23/R23,\"no apto\")","v":"no apto"},null,{"v":0,"d":"0.00"},{"$f":"+T23*$V$21","v":{"v":0,"d":"0.00"}}]
[null,"por nota de 70 al 74,99%.",7,{"$nulls":5},2.25,{"v":9,"d":"9.00"},{"$nulls":3},4.25,null,null,"-",25,"no apto",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"por nota de 75 al 79,99%.",7.5,{"$nulls":5},{"v":2.125,"d":"2.13"},{"$nulls":4},{"v":4.5,"d":"4.50"},null,"TRAMITACION",48.15,60,{"v":0.8025,"d":"80.3%"},8,{"v":2,"d":"2.00"},{"v":4,"d":"4.00"}]
[null,"por nota de 80 al 84,99%.",8,{"$nulls":5},{"v":2,"d":"2.00"},{"$nulls":7},17.5,20,{"v":0.875,"d":"87.5%"},8.5,{"v":2.125,"d":"2.13"},4.25]
[null,"por nota de 85 al 89,99%.",8.5,{"$nulls":13},18.34,20,{"v":0.917,"d":"91.7%"},9,2.25,{"v":4.5,"d":"4.50"}]
[null,"por nota de 90% o superior.",9,{"$nulls":12},"AUXILIO",51,60,{"v":0.85,"d":"85.0%"},8.5,{"v":2.125,"d":"2.13"},4.25]
[null,"Si es de un Cuerpo inferior o especial, el 25% de la anterior puntuación",{"$nulls":14},32.8,40,{"v":0.82,"d":"82.0%"},8,{"v":2,"d":"2.00"},{"v":4,"d":"4.00"}]
[null,"Si es de un Cuerpo superior, el 50%  de la anterior puntuación."]
[]
[]
[null,null,{"$f":"22+8+10","v":40},{"$nulls":4},{"$f":"SUM(H22:H32)","v":{"v":7,"d":"7.00"}},{"$f":"SUM(I22:I32)","v":{"v":10.5,"d":"10.50"}},{"v":25.5,"d":"25.50"},{"v":3.5,"d":"3.50"},{"v":4.125,"d":"4.13"},{"v":16.5,"d":"16.50"},{"$f":"SUM(N22:N32)","v":16.25}]
[{"$nulls":6},"TOTAL NOTAS",{"$f":"IF(SUM(H33:I33)>22,22,SUM(H33:I33))","v":17.5},null,{"$f":"IF(SUM(J33:L33)>22,22,SUM(J33:L33))","v":22},null,null,{"$f":"IF(SUM(M33:N33)>22,22,SUM(M33:N33))","v":22}]
[{"$nulls":6},"TOTAL PUNTOS",{"$f":"+H34+H20+H13","v":{"v":35.5,"d":"35.50"}},null,{"$f":"+J34+J20+J13","v":{"v":40,"d":"40.00"}},null,null,{"$f":"+M34+M20+M13","v":{"v":38,"d":"38.00"}}]