{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Indice","PTU","ISR"],"not_rendered":{"images":1,"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Indice","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"merged":[[8,0,8,7],[12,1,12,2],[12,10,12,11],[13,1,13,2],[14,1,14,2],[14,9,14,10],[14,11,14,12],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[23,1,23,2],[24,1,29,7]]}
{"$rows_empty":8}
["CALCULADORA PTU 2022 PARA EL EJERCICIO 2022."]
[]
[]
[]
["Indice","NOMBRE O RAZÓN SOCIAL",null,"MI EMPRESA, S.A. DE C.V",{"$nulls":6},"CALCULO DE FACTORES"]
["PTU","EJERCICIO FISCAL",null,2022]
["ISR","UMA",null,103.74,{"$nulls":5},"Factor por Dias",null,"Factor por Sueldos"]
[null,"SALARIO MINIMO VIGENTE",null,172.87,{"$nulls":5},"Factor",{"$f":"+K17/K18","v":{"v":29.51388888888889,"d":"29.51389"}},"Factor",{"$f":"+M17/M18","v":{"v":0.2725986178416244,"d":"0.27260"}}]
[null,"P.T.U. A REPARTIR",null,{"v":85000,"d":"85,000.00"},{"$nulls":5},"PTU a repartir",{"$f":"+Indice!D17/2","v":{"v":42500,"d":"42,500.00"}},"PTU a repartir",{"$f":"+Indice!D17/2","v":{"v":42500,"d":"42,500.00"}}]
[null,"TOPE SALARIAL",null,{"v":95000,"d":"95,000.00"},"<---- No incluir el 20% adicional ",{"$nulls":4},"Días trabajados",{"$f":"+PTU!S37","v":{"v":1440,"d":"1,440.00"}},"Sueldos devengados",{"$f":"+PTU!U37","v":{"v":155906.88,"d":"155,906.88"}}]
[null,"MONTO MÁXIMO*",null,{"$f":"+D18*1.2","v":{"v":114000,"d":"114,000.00"}}]
[]
[]
[]
[]
[null,"*Artículo 127, Fracción II"]
[null,"Los demás trabajadores de confianza participarán en las utilidades de las empresas, pero si\nel salario que perciben es mayor del que corresponda al trabajador sindicalizado de más alto\nsalario dentro de la empresa, o a falta de éste al trabajador de planta con la misma\ncaracterística, se considerará este salario aumentado en un veinte por ciento, como salario\nmáximo."]

{"sheet":"PTU","index":1,"n_rows":40,"n_cols":29,"rows_kept":40,"merged":[[0,0,0,14],[1,0,1,14]]}
["MI EMPRESA, S.A. DE C.V."]
[{"$f":"+(\"CALCULADORA DE PTU EJERCICIO: \"&E4)","v":"CALCULADORA DE PTU EJERCICIO: 2022"}]
[{"$nulls":3},"TOPE SALARIAL",{"$f":"+Indice!D18","v":{"v":95000,"d":"95,000.00"}},{"v":1.2,"d":"1.20"},{"$f":"+Indice!D19","v":{"v":114000,"d":"114,000.00"}}]
[{"$nulls":3},"EJERCICIO:",{"$f":"+Indice!D14","v":2022},"P.T.U. A REPARTIR",{"$f":"+Indice!D17","v":{"v":85000,"d":"85,000.00"}},{"$nulls":6},"UMA 2022",{"$f":"+Indice!D15","v":103.74},{"$nulls":6},{"$f":"+PTU!G3","v":{"v":114000,"d":"114,000.00"}},null,null,{"$f":"+O4*15","v":1556.1}]
["Clave","Nombre completo","APLICA PTU","SUELDO MENSUAL","ISR RETENIDO EN EL MES ANTERIOR","SUBSIDIO PARA EL EMPLEO APLICADO","DETERMINACIÓN 3 MES DE SALARIO","PTU PAGADA 2018","PTU PAGADA 2019","PTU PAGADA 2020","PROMEDIO PTU PAGADA","MONTO MAS FAVORABLE","INICIO DE EJERCICIO","FIN DE EJERCICIO","DíAS DEL AÑO","INC. POR ENFERMEDAD GRAL.","PERMISOS SIN GOCE DE SUELDO","AUSENCIAS INJUSTIFICADS","DIAS EFECTIVAMENTE LABORADOS","TOTAL DE INGRESOS DEL AÑO 2020","TOPE SALARIAL","Participación por Sueldo","Participación por días","TOTAL A RECIBIR","PARTE GRAVADA","PARTE EXENTA","ISR","NETO A RECIBIR","STATUS"]
[1,"TRABAJADOR 1","SI",{"v":17500,"d":"17,500.00"},{"v":2190.035872,"d":"2,190.04"},null,{"$f":"+D6*3","v":{"v":52500,"d":"52,500.00"}},{"v":6000,"d":"6,000.00"},{"v":7000,"d":"7,000.00"},{"v":9000,"d":"9,000.00"},{"$f":"+IFERROR(AVERAGE(H6:J6),0)","v":{"v":7333.333333333333,"d":"7,333.33"}},{"$f":"+IF(G6>=K6,G6,K6)","v":{"v":52500,"d":"52,500.00"}},"2021-01-01","2021-12-31",{"$f":"+IF(C6=\"SI\",(IF(((N6-M6)+1)>60,((N6-M6)+1),0)),0)","v":365},20,null,null,{"$f":"+O6-P6-Q6-R6","v":345},{"$f":"+L6","v":{"v":52500,"d":"52,500.00"}},{"$f":"IF($C6=\"SI\",IF(S6>=60,IF($V$4<=0,T6,IF(T6>PTU!$V$4,PTU!$V$4,T6)),0),0)","v":{"v":52500,"d":"52,500"}},{"$f":"+IF(S6>=60,U6*Indice!$M$16,0)","v":{"v":14311.427436685282,"d":"14,311"}},{"$f":"+IF(S6>=60,S6*Indice!$K$16,0)","v":{"v":10182.291666666666,"d":"10,182"}},{"$f":"+V6+W6","v":{"v":24493.71910335195,"d":"24,494"}},{"$f":"+IF($Y$4<X6,X6-$Y$4,0)","v":{"v":22937.61910335195,"d":"22,938"}},{"$f":"+X6-Y6","v":{"v":1556.0999999999985,"d":"1,556"}},{"$f":"+ISR!N2","v":{"v":3458.291382581241,"d":"3,458"}},{"$f":"+X6-AA6","v":{"v":21035.427720770705,"d":"21,035"}},"BAJA"]
[2,"TRABAJADOR 2","SI",{"v":15000,"d":"15,000.00"},{"v":1762.8358719999999,"d":"1,762.84"},null,{"$f":"+D7*3","v":{"v":45000,"d":"45,000.00"}},{"v":6000,"d":"6,000.00"},{"v":7000,"d":"7,000.00"},{"v":9000,"d":"9,000.00"},{"$f":"+IFERROR(AVERAGE(H7:J7),0)","v":{"v":7333.333333333333,"d":"7,333.33"}},{"$f":"+IF(G7>=K7,G7,K7)","v":{"v":45000,"d":"45,000.00"}},"2021-01-01","2021-12-31",365,{"$nulls":3},{"$f":"+O7-P7-Q7-R7","v":365},{"$f":"+L7","v":{"v":45000,"d":"45,000.00"}},{"$f":"IF($C7=\"SI\",IF(S7>=60,IF($V$4<=0,T7,IF(T7>PTU!$V$4,PTU!$V$4,T7)),0),0)","v":{"v":45000,"d":"45,000"}},{"$f":"+IF(S7>=60,U7*Indice!$M$16,0)","v":{"v":12266.937802873099,"d":"12,267"}},{"$f":"+IF(S7>=60,S7*Indice!$K$16,0)","v":{"v":10772.569444444445,"d":"10,773"}},{"$f":"+V7+W7","v":{"v":23039.507247317546,"d":"23,040"}},{"$f":"+IF($Y$4<X7,X7-$Y$4,0)","v":{"v":21483.407247317547,"d":"21,483"}},{"$f":"+X7-Y7","v":{"v":1556.0999999999985,"d":"1,556"}},{"$f":"+ISR!N3","v":{"v":1865.3690985533492,"d":"1,865"}},{"$f":"+X7-AA7","v":{"v":21174.138148764196,"d":"21,174"}},"ALTA"]
[3,"TRABAJADOR 3","SI",{"$f":"7234.48*2","v":{"v":14468.96,"d":"14,468.96"}},{"v":1649.4057279999997,"d":"1,649.41"},null,{"v":43406.88,"d":"43,406.88"},{"v":6000,"d":"6,000.00"},{"v":7000,"d":"7,000.00"},{"v":9000,"d":"9,000.00"},{"v":7333.333333333333,"d":"7,333.33"},{"v":43406.88,"d":"43,406.88"},"2021-01-01","2021-12-31",365,{"$nulls":3},365,{"v":43406.88,"d":"43,406.88"},{"$f":"IF($C8=\"SI\",IF(S8>=60,IF($V$4<=0,T8,IF(T8>PTU!$V$4,PTU!$V$4,T8)),0),0)","v":{"v":43406.88,"d":"43,407"}},{"$f":"+IF(S8>=60,U8*Indice!$M$16,0)","v":{"v":11832.65549281725,"d":"11,833"}},{"$f":"+IF(S8>=60,S8*Indice!$K$16,0)","v":{"v":10772.569444444445,"d":"10,773"}},{"v":22605.224937261693,"d":"22,605"},{"v":21049.124937261695,"d":"21,049"},{"v":1556.0999999999985,"d":"1,556"},{"$f":"+ISR!N4","v":{"v":1772.6063971254196,"d":"1,773"}},{"v":20832.618540136275,"d":"20,833"},"ALTA"]
[4,"TRABAJADOR 4","SI",{"v":5000,"d":"5,000.00"},291.13,null,{"v":15000,"d":"15,000.00"},{"v":6000,"d":"6,000.00"},{"v":7000,"d":"7,000.00"},{"v":9000,"d":"9,000.00"},{"$f":"+IFERROR(AVERAGE(H9:J9),0)","v":{"v":7333.333333333333,"d":"7,333.33"}},{"v":15000,"d":"15,000.00"},"2021-01-01","2021-12-31",365,{"$nulls":3},365,{"v":15000,"d":"15,000.00"},{"$f":"IF($C9=\"SI\",IF(S9>=60,IF($V$4<=0,T9,IF(T9>PTU!$V$4,PTU!$V$4,T9)),0),0)","v":{"v":15000,"d":"15,000"}},{"$f":"+IF(S9>=60,U9*Indice!$M$16,0)","v":{"v":4088.9792676243665,"d":"4,089"}},{"$f":"+IF(S9>=60,S9*Indice!$K$16,0)","v":{"v":10772.569444444445,"d":"10,773"}},{"v":14861.548712068812,"d":"14,862"},{"v":13305.448712068812,"d":"13,305"},{"v":1556.1000000000004,"d":"1,556"},{"$f":"+ISR!N5","v":{"v":796.8323359934568,"d":"797"}},{"v":14064.716376075356,"d":"14,065"},"ALTA"]
[5,"TRABAJADOR 5",{"$nulls":4},0,{"$nulls":3},{"$f":"+IFERROR(AVERAGE(H10:J10),0)","v":0},0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C10=\"SI\",IF(S10>=60,IF($V$4<=0,T10,IF(T10>PTU!$V$4,PTU!$V$4,T10)),0),0)","v":0},{"$f":"+IF(S10>=60,U10*Indice!$M$16,0)","v":0},{"$f":"+IF(S10>=60,S10*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N6","v":0},0,"ALTA"]
[6,"TRABAJADOR 6",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C11=\"SI\",IF(S11>=60,IF($V$4<=0,T11,IF(T11>PTU!$V$4,PTU!$V$4,T11)),0),0)","v":0},{"$f":"+IF(S11>=60,U11*Indice!$M$16,0)","v":0},{"$f":"+IF(S11>=60,S11*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N7","v":0},0,"ALTA"]
[7,"TRABAJADOR 7",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C12=\"SI\",IF(S12>=60,IF($V$4<=0,T12,IF(T12>PTU!$V$4,PTU!$V$4,T12)),0),0)","v":0},{"$f":"+IF(S12>=60,U12*Indice!$M$16,0)","v":0},{"$f":"+IF(S12>=60,S12*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N8","v":0},0,"ALTA"]
[8,"TRABAJADOR 8",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C13=\"SI\",IF(S13>=60,IF($V$4<=0,T13,IF(T13>PTU!$V$4,PTU!$V$4,T13)),0),0)","v":0},{"$f":"+IF(S13>=60,U13*Indice!$M$16,0)","v":0},{"$f":"+IF(S13>=60,S13*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N9","v":0},0,"BAJA"]
[9,"TRABAJADOR 9",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C14=\"SI\",IF(S14>=60,IF($V$4<=0,T14,IF(T14>PTU!$V$4,PTU!$V$4,T14)),0),0)","v":0},{"$f":"+IF(S14>=60,U14*Indice!$M$16,0)","v":0},{"$f":"+IF(S14>=60,S14*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N10","v":0},0,"ALTA"]
[10,"TRABAJADOR 10",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C15=\"SI\",IF(S15>=60,IF($V$4<=0,T15,IF(T15>PTU!$V$4,PTU!$V$4,T15)),0),0)","v":0},{"$f":"+IF(S15>=60,U15*Indice!$M$16,0)","v":0},{"$f":"+IF(S15>=60,S15*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N11","v":0},0,"ALTA"]
[11,"TRABAJADOR 11",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C16=\"SI\",IF(S16>=60,IF($V$4<=0,T16,IF(T16>PTU!$V$4,PTU!$V$4,T16)),0),0)","v":0},{"$f":"+IF(S16>=60,U16*Indice!$M$16,0)","v":0},{"$f":"+IF(S16>=60,S16*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N12","v":0},0,"ALTA"]
[12,"TRABAJADOR 12",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C17=\"SI\",IF(S17>=60,IF($V$4<=0,T17,IF(T17>PTU!$V$4,PTU!$V$4,T17)),0),0)","v":0},{"$f":"+IF(S17>=60,U17*Indice!$M$16,0)","v":0},{"$f":"+IF(S17>=60,S17*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N13","v":0},0,"ALTA"]
[13,"TRABAJADOR 13",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C18=\"SI\",IF(S18>=60,IF($V$4<=0,T18,IF(T18>PTU!$V$4,PTU!$V$4,T18)),0),0)","v":0},{"$f":"+IF(S18>=60,U18*Indice!$M$16,0)","v":0},{"$f":"+IF(S18>=60,S18*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N14","v":0},0,"ALTA"]
[14,"TRABAJADOR 14",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C19=\"SI\",IF(S19>=60,IF($V$4<=0,T19,IF(T19>PTU!$V$4,PTU!$V$4,T19)),0),0)","v":0},{"$f":"+IF(S19>=60,U19*Indice!$M$16,0)","v":0},{"$f":"+IF(S19>=60,S19*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N15","v":0},0,"BAJA"]
[15,"TRABAJADOR 15",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C20=\"SI\",IF(S20>=60,IF($V$4<=0,T20,IF(T20>PTU!$V$4,PTU!$V$4,T20)),0),0)","v":0},{"$f":"+IF(S20>=60,U20*Indice!$M$16,0)","v":0},{"$f":"+IF(S20>=60,S20*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N16","v":0},0,"ALTA"]
[16,"TRABAJADOR 16",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C21=\"SI\",IF(S21>=60,IF($V$4<=0,T21,IF(T21>PTU!$V$4,PTU!$V$4,T21)),0),0)","v":0},{"$f":"+IF(S21>=60,U21*Indice!$M$16,0)","v":0},{"$f":"+IF(S21>=60,S21*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N17","v":0},0,"ALTA"]
[17,"TRABAJADOR 17",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C22=\"SI\",IF(S22>=60,IF($V$4<=0,T22,IF(T22>PTU!$V$4,PTU!$V$4,T22)),0),0)","v":0},{"$f":"+IF(S22>=60,U22*Indice!$M$16,0)","v":0},{"$f":"+IF(S22>=60,S22*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N18","v":0},0,"BAJA"]
[18,"TRABAJADOR 18",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C23=\"SI\",IF(S23>=60,IF($V$4<=0,T23,IF(T23>PTU!$V$4,PTU!$V$4,T23)),0),0)","v":0},{"$f":"+IF(S23>=60,U23*Indice!$M$16,0)","v":0},{"$f":"+IF(S23>=60,S23*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N19","v":0},0,"BAJA"]
[19,"TRABAJADOR 19",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C24=\"SI\",IF(S24>=60,IF($V$4<=0,T24,IF(T24>PTU!$V$4,PTU!$V$4,T24)),0),0)","v":0},{"$f":"+IF(S24>=60,U24*Indice!$M$16,0)","v":0},{"$f":"+IF(S24>=60,S24*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N20","v":0},0,"ALTA"]
[20,"TRABAJADOR 20",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C25=\"SI\",IF(S25>=60,IF($V$4<=0,T25,IF(T25>PTU!$V$4,PTU!$V$4,T25)),0),0)","v":0},{"$f":"+IF(S25>=60,U25*Indice!$M$16,0)","v":0},{"$f":"+IF(S25>=60,S25*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N21","v":0},0,"BAJA"]
[21,"TRABAJADOR 21",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C26=\"SI\",IF(S26>=60,IF($V$4<=0,T26,IF(T26>PTU!$V$4,PTU!$V$4,T26)),0),0)","v":0},{"$f":"+IF(S26>=60,U26*Indice!$M$16,0)","v":0},{"$f":"+IF(S26>=60,S26*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N22","v":0},0,"BAJA"]
[22,"TRABAJADOR 22",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C27=\"SI\",IF(S27>=60,IF($V$4<=0,T27,IF(T27>PTU!$V$4,PTU!$V$4,T27)),0),0)","v":0},{"$f":"+IF(S27>=60,U27*Indice!$M$16,0)","v":0},{"$f":"+IF(S27>=60,S27*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N23","v":0},0,"ALTA"]
[23,"TRABAJADOR 23",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C28=\"SI\",IF(S28>=60,IF($V$4<=0,T28,IF(T28>PTU!$V$4,PTU!$V$4,T28)),0),0)","v":0},{"$f":"+IF(S28>=60,U28*Indice!$M$16,0)","v":0},{"$f":"+IF(S28>=60,S28*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N24","v":0},0,"ALTA"]
[24,"TRABAJADOR 24",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C29=\"SI\",IF(S29>=60,IF($V$4<=0,T29,IF(T29>PTU!$V$4,PTU!$V$4,T29)),0),0)","v":0},{"$f":"+IF(S29>=60,U29*Indice!$M$16,0)","v":0},{"$f":"+IF(S29>=60,S29*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N25","v":0},0,"BAJA"]
[25,"TRABAJADOR 25",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C30=\"SI\",IF(S30>=60,IF($V$4<=0,T30,IF(T30>PTU!$V$4,PTU!$V$4,T30)),0),0)","v":0},{"$f":"+IF(S30>=60,U30*Indice!$M$16,0)","v":0},{"$f":"+IF(S30>=60,S30*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N26","v":0},0,"ALTA"]
[26,"TRABAJADOR 26",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C31=\"SI\",IF(S31>=60,IF($V$4<=0,T31,IF(T31>PTU!$V$4,PTU!$V$4,T31)),0),0)","v":0},{"$f":"+IF(S31>=60,U31*Indice!$M$16,0)","v":0},{"$f":"+IF(S31>=60,S31*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N27","v":0},0,"BAJA"]
[27,"TRABAJADOR 27",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C32=\"SI\",IF(S32>=60,IF($V$4<=0,T32,IF(T32>PTU!$V$4,PTU!$V$4,T32)),0),0)","v":0},{"$f":"+IF(S32>=60,U32*Indice!$M$16,0)","v":0},{"$f":"+IF(S32>=60,S32*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N28","v":0},0,"BAJA"]
[28,"TRABAJADOR 28",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C33=\"SI\",IF(S33>=60,IF($V$4<=0,T33,IF(T33>PTU!$V$4,PTU!$V$4,T33)),0),0)","v":0},{"$f":"+IF(S33>=60,U33*Indice!$M$16,0)","v":0},{"$f":"+IF(S33>=60,S33*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N29","v":0},0,"ALTA"]
[29,"TRABAJADOR 29",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C34=\"SI\",IF(S34>=60,IF($V$4<=0,T34,IF(T34>PTU!$V$4,PTU!$V$4,T34)),0),0)","v":0},{"$f":"+IF(S34>=60,U34*Indice!$M$16,0)","v":0},{"$f":"+IF(S34>=60,S34*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N30","v":0},0,"ALTA"]
[30,"TRABAJADOR 30",{"$nulls":4},0,{"$nulls":3},0,0,"2021-01-01","2021-12-31",0,{"$nulls":3},0,0,{"$f":"IF($C35=\"SI\",IF(S35>=60,IF($V$4<=0,T35,IF(T35>PTU!$V$4,PTU!$V$4,T35)),0),0)","v":0},{"$f":"+IF(S35>=60,U35*Indice!$M$16,0)","v":0},{"$f":"+IF(S35>=60,S35*Indice!$K$16,0)","v":0},0,0,0,{"$f":"+ISR!N31","v":0},0,"ALTA"]
[]
[{"$nulls":14},{"$f":"+SUM(O6:O35)","v":1460},{"$nulls":3},{"$f":"+SUMIF($C$6:$C$35,\"SI\",$S$6:$S$35)","v":{"v":1440,"d":"1,440"}},{"$f":"+SUM(T6:T35)","v":{"v":155906.88,"d":"155,906.88"}},{"$f":"+SUMIF($C$6:$C$35,\"SI\",$U$6:$U$35)","v":{"v":155906.88,"d":"155,907"}},{"$f":"+SUM(V6:V35)","v":{"v":42500,"d":"42,500"}},{"v":42500,"d":"42,500"},{"v":85000,"d":"85,000"},{"v":78775.6,"d":"78,776"},{"v":6224.399999999996,"d":"6,224"},{"v":7893.099214253467,"d":"7,893"},{"v":77106.90078574653,"d":"77,107"}]
[{"$nulls":22},{"$f":"+V37+W37","v":{"v":85000,"d":"85,000.00"}}]
[{"$nulls":22},{"$f":"+Indice!D17","v":{"v":85000,"d":"85,000.00"}}]
[{"$nulls":21},"DIFERENCIA",{"$f":"+W38-W39","v":0}]

{"sheet":"ISR","index":2,"n_rows":31,"n_cols":19,"rows_kept":31}
["NOMBRE","PTU","Indice","TOTAL","LIMITE INFERIOR","EXCEDENTE DEL LIMITE INFERIOR","% PARA APLICARSE","IMPUESTO MARGINAL","CUOTA FIJA","IMPUESTO CAUSADO","IMPUESTO ","IMPUESTO ART. 174","FACTOR","IMPUESTO A RETENER",null,"Tarifa mensual"]
[{"$f":"+PTU!B6","v":"TRABAJADOR 1"},{"$f":"+PTU!Y6","v":{"v":22937.61910335195,"d":"22,937.62"}},{"$f":"+B2/365*30.4","v":{"v":1910.4208787449295,"d":"1,910.42"}},{"$f":"+PTU!D6+C2","v":{"v":19410.420878744928,"d":"19,410.42"}},{"$f":"+IFERROR(VLOOKUP(D2,Tarifa_mensual,1),0)","v":{"v":15487.72,"d":"15,487.72"}},{"$f":"+D2-E2","v":{"v":3922.7008787449286,"d":"3,922.70"}},{"$f":"+IFERROR(VLOOKUP(D2,Tarifa_mensual,4),0)","v":{"v":0.2136,"d":"21.36%"}},{"$f":"+F2*G2","v":{"v":837.8889076999168,"d":"837.89"}},{"$f":"+IFERROR(VLOOKUP(D2,Tarifa_mensual,3),0)","v":{"v":1640.18,"d":"1,640.18"}},{"$f":"+H2+I2","v":{"v":2478.068907699917,"d":"2,478.07"}},{"$f":"+J2-PTU!F6","v":{"v":2478.068907699917,"d":"2,478.07"}},{"$f":"+IF((K2-PTU!E6)<1,0,(K2-PTU!E6))","v":{"v":288.03303569991704,"d":"288.03"}},{"$f":"IFERROR((L2/C2),0)","v":{"v":0.15076941364310428,"d":"0.15"}},{"$f":"+IF(K2>1,B2*M2,0)","v":{"v":3458.291382581241,"d":"3,458.29"}},null,"Límite Inferior","Límite Superior","Cuota Fija","% sobre excente de límite inferior"]
[{"$f":"+PTU!B7","v":"TRABAJADOR 2"},{"$f":"+PTU!Y7","v":{"v":21483.407247317547,"d":"21,483.41"}},{"$f":"+B3/365*30.4","v":{"v":1789.3029597765849,"d":"1,789.30"}},{"$f":"+PTU!D7+C3","v":{"v":16789.302959776585,"d":"16,789.30"}},{"v":15487.72,"d":"15,487.72"},{"$f":"+D3-E3","v":{"v":1301.582959776586,"d":"1,301.58"}},{"v":0.2136,"d":"21.36%"},{"$f":"+F3*G3","v":{"v":278.0181202082788,"d":"278.02"}},{"v":1640.18,"d":"1,640.18"},{"$f":"+H3+I3","v":{"v":1918.1981202082789,"d":"1,918.20"}},{"$f":"+J3-PTU!F7","v":{"v":1918.1981202082789,"d":"1,918.20"}},{"$f":"+IF((K3-PTU!E7)<1,0,(K3-PTU!E7))","v":{"v":155.36224820827897,"d":"155.36"}},{"v":0.08682836372644112,"d":"0.09"},{"$f":"+IF(K3>1,B3*M3,0)","v":{"v":1865.3690985533492,"d":"1,865.37"}},null,0.01,746.04,0,{"v":0.0192,"d":"1.92%"}]
[{"$f":"+PTU!B8","v":"TRABAJADOR 3"},{"$f":"+PTU!Y8","v":{"v":21049.124937261695,"d":"21,049.12"}},{"v":1753.1325975143986,"d":"1,753.13"},{"$f":"+PTU!D8+C4","v":{"v":16222.092597514398,"d":"16,222.09"}},{"v":15487.72,"d":"15,487.72"},{"v":734.3725975143989,"d":"734.37"},{"v":0.2136,"d":"21.36%"},{"v":156.86198682907562,"d":"156.86"},{"v":1640.18,"d":"1,640.18"},{"v":1797.0419868290758,"d":"1,797.04"},{"$f":"+J4-PTU!F8","v":{"v":1797.0419868290758,"d":"1,797.04"}},{"$f":"+IF((K4-PTU!E8)<1,0,(K4-PTU!E8))","v":{"v":147.63625882907604,"d":"147.64"}},{"v":0.08421283081404998,"d":"0.08"},{"v":1772.6063971254196,"d":"1,772.61"},null,746.05,{"v":6332.05,"d":"6,332.05"},14.32,{"v":0.064,"d":"6.40%"}]
[{"$f":"+PTU!B9","v":"TRABAJADOR 4"},{"$f":"+PTU!Y9","v":{"v":13305.448712068812,"d":"13,305.45"}},{"v":1108.1798379366899,"d":"1,108.18"},{"$f":"+PTU!D9+C5","v":{"v":6108.17983793669,"d":"6,108.18"}},746.05,{"v":5362.12983793669,"d":"5,362.13"},{"v":0.064,"d":"6.40%"},{"v":343.17630962794817,"d":"343.18"},14.32,{"v":357.49630962794816,"d":"357.50"},{"$f":"+J5-PTU!F9","v":{"v":357.49630962794816,"d":"357.50"}},{"$f":"+IF((K5-PTU!E9)<1,0,(K5-PTU!E9))","v":{"v":66.36630962794817,"d":"66.37"}},{"v":0.05988767107648792,"d":"0.06"},{"v":796.8323359934568,"d":"796.83"},null,{"v":6332.06,"d":"6,332.06"},{"v":11128.01,"d":"11,128.01"},371.83,{"v":0.1088,"d":"10.88%"}]
[{"$f":"+PTU!B10","v":"TRABAJADOR 5"},{"$f":"+PTU!Y10","v":0},0,{"$f":"+PTU!D10+C6","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J6-PTU!F10","v":0},{"$f":"+IF((K6-PTU!E10)<1,0,(K6-PTU!E10))","v":0},0,0,null,{"v":11128.02,"d":"11,128.02"},{"v":12935.82,"d":"12,935.82"},893.63,{"v":0.16,"d":"16.00%"}]
[{"$f":"+PTU!B11","v":"TRABAJADOR 6"},{"$f":"+PTU!Y11","v":0},0,{"$f":"+PTU!D11+C7","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J7-PTU!F11","v":0},{"$f":"+IF((K7-PTU!E11)<1,0,(K7-PTU!E11))","v":0},0,0,null,{"v":12935.83,"d":"12,935.83"},{"v":15487.71,"d":"15,487.71"},{"v":1182.88,"d":"1,182.88"},{"v":0.1792,"d":"17.92%"}]
[{"$f":"+PTU!B12","v":"TRABAJADOR 7"},{"$f":"+PTU!Y12","v":0},0,{"$f":"+PTU!D12+C8","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J8-PTU!F12","v":0},{"$f":"+IF((K8-PTU!E12)<1,0,(K8-PTU!E12))","v":0},0,0,null,{"v":15487.72,"d":"15,487.72"},{"v":31236.49,"d":"31,236.49"},{"v":1640.18,"d":"1,640.18"},{"v":0.2136,"d":"21.36%"}]
[{"$f":"+PTU!B13","v":"TRABAJADOR 8"},{"$f":"+PTU!Y13","v":0},0,{"$f":"+PTU!D13+C9","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J9-PTU!F13","v":0},{"$f":"+IF((K9-PTU!E13)<1,0,(K9-PTU!E13))","v":0},0,0,null,{"v":31236.5,"d":"31,236.50"},{"v":49233,"d":"49,233.00"},{"v":5004.12,"d":"5,004.12"},{"v":0.2352,"d":"23.52%"}]
[{"$f":"+PTU!B14","v":"TRABAJADOR 9"},{"$f":"+PTU!Y14","v":0},0,{"$f":"+PTU!D14+C10","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J10-PTU!F14","v":0},{"$f":"+IF((K10-PTU!E14)<1,0,(K10-PTU!E14))","v":0},0,0,null,{"v":49233.01,"d":"49,233.01"},{"v":93993.9,"d":"93,993.90"},{"v":9236.89,"d":"9,236.89"},{"v":0.3,"d":"30.00%"}]
[{"$f":"+PTU!B15","v":"TRABAJADOR 10"},{"$f":"+PTU!Y15","v":0},0,{"$f":"+PTU!D15+C11","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J11-PTU!F15","v":0},{"$f":"+IF((K11-PTU!E15)<1,0,(K11-PTU!E15))","v":0},0,0,null,{"v":93993.91,"d":"93,993.91"},{"v":125325.2,"d":"125,325.20"},{"v":22665.17,"d":"22,665.17"},{"v":0.32,"d":"32.00%"}]
[{"$f":"+PTU!B16","v":"TRABAJADOR 11"},{"$f":"+PTU!Y16","v":0},0,{"$f":"+PTU!D16+C12","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J12-PTU!F16","v":0},{"$f":"+IF((K12-PTU!E16)<1,0,(K12-PTU!E16))","v":0},0,0,null,{"v":125325.21,"d":"125,325.21"},{"v":375975.61,"d":"375,975.61"},{"v":32691.18,"d":"32,691.18"},{"v":0.34,"d":"34.00%"}]
[{"$f":"+PTU!B17","v":"TRABAJADOR 12"},{"$f":"+PTU!Y17","v":0},0,{"$f":"+PTU!D17+C13","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J13-PTU!F17","v":0},{"$f":"+IF((K13-PTU!E17)<1,0,(K13-PTU!E17))","v":0},0,0,null,{"v":375975.62,"d":"375,975.62"},"En adelante",{"v":117912.32,"d":"117,912.32"},{"v":0.35,"d":"35.00%"}]
[{"$f":"+PTU!B18","v":"TRABAJADOR 13"},{"$f":"+PTU!Y18","v":0},0,{"$f":"+PTU!D18+C14","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J14-PTU!F18","v":0},{"$f":"+IF((K14-PTU!E18)<1,0,(K14-PTU!E18))","v":0},0,0]
[{"$f":"+PTU!B19","v":"TRABAJADOR 14"},{"$f":"+PTU!Y19","v":0},0,{"$f":"+PTU!D19+C15","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J15-PTU!F19","v":0},{"$f":"+IF((K15-PTU!E19)<1,0,(K15-PTU!E19))","v":0},0,0]
[{"$f":"+PTU!B20","v":"TRABAJADOR 15"},{"$f":"+PTU!Y20","v":0},0,{"$f":"+PTU!D20+C16","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J16-PTU!F20","v":0},{"$f":"+IF((K16-PTU!E20)<1,0,(K16-PTU!E20))","v":0},0,0]
[{"$f":"+PTU!B21","v":"TRABAJADOR 16"},{"$f":"+PTU!Y21","v":0},0,{"$f":"+PTU!D21+C17","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J17-PTU!F21","v":0},{"$f":"+IF((K17-PTU!E21)<1,0,(K17-PTU!E21))","v":0},0,0]
[{"$f":"+PTU!B22","v":"TRABAJADOR 17"},{"$f":"+PTU!Y22","v":0},0,{"$f":"+PTU!D22+C18","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J18-PTU!F22","v":0},{"$f":"+IF((K18-PTU!E22)<1,0,(K18-PTU!E22))","v":0},0,0]
[{"$f":"+PTU!B23","v":"TRABAJADOR 18"},{"$f":"+PTU!Y23","v":0},0,{"$f":"+PTU!D23+C19","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J19-PTU!F23","v":0},{"$f":"+IF((K19-PTU!E23)<1,0,(K19-PTU!E23))","v":0},0,0]
[{"$f":"+PTU!B24","v":"TRABAJADOR 19"},{"$f":"+PTU!Y24","v":0},0,{"$f":"+PTU!D24+C20","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J20-PTU!F24","v":0},{"$f":"+IF((K20-PTU!E24)<1,0,(K20-PTU!E24))","v":0},0,0]
[{"$f":"+PTU!B25","v":"TRABAJADOR 20"},{"$f":"+PTU!Y25","v":0},0,{"$f":"+PTU!D25+C21","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J21-PTU!F25","v":0},{"$f":"+IF((K21-PTU!E25)<1,0,(K21-PTU!E25))","v":0},0,{"$f":"+IF(K21>0,B21*M21,0)","v":0}]
[{"$f":"+PTU!B26","v":"TRABAJADOR 21"},{"$f":"+PTU!Y26","v":0},0,{"$f":"+PTU!D26+C22","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J22-PTU!F26","v":0},{"$f":"+IF((K22-PTU!E26)<1,0,(K22-PTU!E26))","v":0},0,{"$f":"+IF(K22>0,B22*M22,0)","v":0}]
[{"$f":"+PTU!B27","v":"TRABAJADOR 22"},{"$f":"+PTU!Y27","v":0},0,{"$f":"+PTU!D27+C23","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J23-PTU!F27","v":0},{"$f":"+IF((K23-PTU!E27)<1,0,(K23-PTU!E27))","v":0},0,{"$f":"+IF(K23>0,B23*M23,0)","v":0}]
[{"$f":"+PTU!B28","v":"TRABAJADOR 23"},{"$f":"+PTU!Y28","v":0},0,{"$f":"+PTU!D28+C24","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J24-PTU!F28","v":0},{"$f":"+IF((K24-PTU!E28)<1,0,(K24-PTU!E28))","v":0},0,{"$f":"IF(K24>0,(B24*M24),0)","v":0}]
[{"$f":"+PTU!B29","v":"TRABAJADOR 24"},{"$f":"+PTU!Y29","v":0},0,{"$f":"+PTU!D29+C25","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J25-PTU!F29","v":0},{"$f":"+IF((K25-PTU!E29)<1,0,(K25-PTU!E29))","v":0},0,0]
[{"$f":"+PTU!B30","v":"TRABAJADOR 25"},{"$f":"+PTU!Y30","v":0},0,{"$f":"+PTU!D30+C26","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J26-PTU!F30","v":0},{"$f":"+IF((K26-PTU!E30)<1,0,(K26-PTU!E30))","v":0},0,0]
[{"$f":"+PTU!B31","v":"TRABAJADOR 26"},{"$f":"+PTU!Y31","v":0},0,{"$f":"+PTU!D31+C27","v":0},0,{"$f":"+D27-E27","v":0},{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J27-PTU!F31","v":0},{"$f":"+IF((K27-PTU!E31)<1,0,(K27-PTU!E31))","v":0},0,0]
[{"$f":"+PTU!B32","v":"TRABAJADOR 27"},{"$f":"+PTU!Y32","v":0},0,{"$f":"+PTU!D32+C28","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J28-PTU!F32","v":0},{"$f":"+IF((K28-PTU!E32)<1,0,(K28-PTU!E32))","v":0},0,0]
[{"$f":"+PTU!B33","v":"TRABAJADOR 28"},{"$f":"+PTU!Y33","v":0},0,{"$f":"+PTU!D33+C29","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J29-PTU!F33","v":0},{"$f":"+IF((K29-PTU!E33)<1,0,(K29-PTU!E33))","v":0},0,0]
[{"$f":"+PTU!B34","v":"TRABAJADOR 29"},{"$f":"+PTU!Y34","v":0},0,{"$f":"+PTU!D34+C30","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J30-PTU!F34","v":0},{"$f":"+IF((K30-PTU!E34)<1,0,(K30-PTU!E34))","v":0},0,0]
[{"$f":"+PTU!B35","v":"TRABAJADOR 30"},{"$f":"+PTU!Y35","v":0},0,{"$f":"+PTU!D35+C31","v":0},0,0,{"v":0,"d":"0.00%"},0,0,0,{"$f":"+J31-PTU!F35","v":0},{"$f":"+IF((K31-PTU!E35)<1,0,(K31-PTU!E35))","v":0},0,0]