{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["ISPT-INFO-IMSS TRABAJADOR 2022","DATOS","SBC 2022","TARIFAS ISPT, SUBSIDO AL EMPLEO","CALCULO RETENCION"],"not_rendered":{"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"ISPT-INFO-IMSS TRABAJADOR 2022","index":0,"n_rows":36,"n_cols":14,"rows_kept":36,"merged":[[3,5,3,7],[4,1,4,3],[5,2,5,3],[6,2,6,3],[6,5,6,7],[7,2,7,3],[7,5,7,7],[8,2,8,3],[10,2,10,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[18,12,18,13],[20,2,20,3],[21,2,21,3],[24,1,24,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[39,4,39,5]]}
[]
[null,"Calculadora de Nominas 2022"]
[]
[]
[null,"DATOS"]
[null,"Promedio de dias al mes",30.4,{"$nulls":9},"UMA",{"v":89.62,"d":"$89.62"}]
[null,"Dias Laborados",15,{"$nulls":5},"( = )","Ingresos Mensuales Acumulables",{"$f":"(C9/C7)*C6","v":{"v":5255.248,"d":"$5,255.25"}},null,"Tope 3 salarios minimos",{"$f":"N6*3","v":{"v":268.86,"d":"$268.86"}}]
[null,"Salario Diario",172.87,{"$nulls":5},"( - )","Limite Inferior ",{"$f":"VLOOKUP(K7,'TARIFAS ISPT, SUBSIDO AL EMPLEO'!B5:E15,1)","v":{"v":644.59,"d":"$644.59"}}]
[null,"Ingresos en ese Periodo",{"$f":"C7*C8","v":{"v":2593.05,"d":"$2,593.05"}},{"$nulls":5},"( = )","Excedente sobre limite inferior",{"$f":"K7-K8","v":{"v":4610.657999999999,"d":"$4,610.66"}}]
[{"$nulls":8},"( * )","Tasa aplicable",{"$f":"VLOOKUP(K7,'TARIFAS ISPT, SUBSIDO AL EMPLEO'!B5:E15,4)","v":{"v":0.064,"d":"6.40%"}},null,"Invalidez y vida",{"v":0.00625,"d":"0.625%"}]
[null,"TIPO DE DESCUENTO",1,{"$nulls":6},"Impuesto marginal",{"$f":"K9*K10","v":{"v":295.082112,"d":"$295.08"}},null,"Cesantía y vejez ",{"v":0.01125,"d":"1.125%"}]
[null,null,1,"VECES SMGDF",{"$nulls":4},"( + )","Cuota Fija",{"$f":"VLOOKUP(K7,'TARIFAS ISPT, SUBSIDO AL EMPLEO'!B5:E15,3)","v":{"v":12.38,"d":"$12.38"}},null,"Prestaciones en Efectivo",{"v":0.0025,"d":"0.250%"}]
[null,null,2,"CUOTA FIJA",{"$nulls":4},"( = )","ISR Causado",{"$f":"K12+K11","v":{"v":307.462112,"d":"$307.46"}},null,"Gastos Médicos",{"v":0.00375,"d":"0.375%"}]
[null,null,3,"PORCENTAJE",{"$nulls":8},"Excedente ="]
[{"$nulls":9},"DETERMINACION DEL SUBSIDIO "]
[null,"Prestaciones",{"$nulls":10},"Total% Retención =",{"$f":"SUM(N10:N13)","v":{"v":0.02375,"d":"2.375%"}}]
[null,"Dias de Vacaciones",6,{"$nulls":5},"( = ) ","ISPT DEL PERIODO",{"$f":"(K13/C6)*C7","v":{"v":151.70827894736843,"d":"$151.71"}}]
[null,"% de Prima Vacacional",{"v":0.25,"d":"25.00%"},{"$nulls":5},"( - )","SUBSIDIO PARA EL EMPLEO",{"$f":"VLOOKUP(K7,'TARIFAS ISPT, SUBSIDO AL EMPLEO'!G5:I15,3)/C6*C7","v":{"v":160.29769736842104,"d":"$160.30"}}]
[null,"Dias de Aguinaldo",30,{"$nulls":5},"( = ) ","ISR A CARGO",{"$f":"IF(K17>K18,K17-K18,0)","v":0},null,"Retención IMSS"]
[{"$nulls":8},"( = ) ","SUBSIDIO A FAVOR",{"$f":"IF(K17<K18,K18-K17,0)","v":{"v":8.589418421052613,"d":"$8.59"}},null,"Salario Base de Cotización",{"$f":"C21","v":{"v":180.68467123287672,"d":"$180.68"}}]
[null,"SALARIO DIARIO INTEGRADO (PRESTACIONES DE LEY)",{"$f":"'SBC 2022'!E3","v":{"v":180.68467123287672,"d":"$180.68"}},{"$nulls":9},"(x) No. De días cotizados",{"$f":"C7","v":15}]
[null,"VALOR DEL DESCUENTO (si tiene Infonavit)",{"v":0,"d":"0.0000"},{"$nulls":9},"(=) Salario base cotización =",{"$f":"N20*N21","v":{"v":2710.270068493151,"d":"$2,710.27"}}]
[{"$nulls":12},"(x) % retención IMSS=",{"$f":"N16","v":{"v":0.02375,"d":"2.375%"}}]
[{"$nulls":12},"(=) Ret. Inic. IMSS =",{"$f":"N22*N23","v":{"v":64.36891412671234,"d":"$64.37"}}]
[null,"DESGLOSE DEL PERIODO"]
[{"$nulls":12},"Mayor a 3 SMDF",{"$f":"IF(N20>N7,\"SI\",\"NO\")","v":"NO"}]
[null,"SUELDO",{"$f":"C9","v":{"v":2593.05,"d":"$2,593.05"}}]
[null,"ISPT DEL PERIODO ANTES DEL SUBSIDIO",{"$f":"K17","v":{"v":151.70827894736843,"d":"$151.71"}},{"$nulls":9},"SDI – 3 Salarios minimos",{"$f":"IF(N26=\"SI\",N20-N7,0)","v":0}]
[null,"SUBSIDO PARA EL EMPLEO",{"$f":"K18","v":{"v":160.29769736842104,"d":"$160.30"}},{"$nulls":9},"(x) No. De días cotizados",{"$f":"N21","v":15}]
[null,{"$f":"IF(C30>0,\"ISPT A CARGO \",\"SUBSIDIO A FAVOR\")","v":"SUBSIDIO A FAVOR"},{"$f":"C28-C29","v":{"v":-8.589418421052613,"d":"-$8.59"}},{"$nulls":9},"(=) Salario base cotización excedente",{"$f":"N28*N29","v":0}]
[null,"IMSS",{"$f":"N35","v":{"v":64.36891412671234,"d":"$64.37"}},{"$nulls":9},"X % sobre excedente ",{"$f":"0.004","v":{"v":0.004,"d":"0.40%"}}]
[null,"RETENCION INFONAVIT",{"$f":"DATOS!D25","v":0},{"$nulls":9},"(=) IMSS sobre excedente",{"$f":"N30*N31","v":0}]
[null,"NETO A PAGAR",{"$f":"C27-C30-C31-C32","v":{"v":2537.2705042943403,"d":"$2,537.27"}},{"$nulls":9},"(+) Ret. Inic. IMSS",{"$f":"N24","v":{"v":64.36891412671234,"d":"$64.37"}}]
[]
[{"$nulls":12},"Total Retención IMSS.",{"$f":"+N32+N33","v":{"v":64.36891412671234,"d":"$64.37"}}]
[null,"Nota: Rellena solo los espacios en azul"]

{"sheet":"DATOS","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"merged":[[1,1,1,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[11,2,11,3],[12,2,12,3]]}
[]
[null,"DATOS GENERALES"]
[]
[null,"DIAS EN NOMINA",{"$f":"'ISPT-INFO-IMSS TRABAJADOR 2022'!C7:D7","v":15}]
[null,"Salario Minimo 2021",{"v":172.87,"d":"$172.87"},{"v":80.04,"d":"$80.04"}]
[null,"UMA 2021 (DOF 07.01.2021)",{"v":96.22,"d":"$96.22"}]
[null,"VALOR DE SEGURO DE VIVIENDA",{"v":0,"d":"$0.00"}]
[null,"TIPO DE DESCUENTO",{"$f":"'ISPT-INFO-IMSS TRABAJADOR 2022'!C11:D11","v":1}]
[null,null,1,"VECES SMGDF"]
[null,null,2,"CUOTA FIJA"]
[null,null,3,"PORCENTAJE"]
[null,"SALARIO BASE DE COTIZACION",{"$f":"'ISPT-INFO-IMSS TRABAJADOR 2022'!C21:D21","v":180.68467123287672}]
[null,"VALOR DEL DESCUENTO",{"$f":"'ISPT-INFO-IMSS TRABAJADOR 2022'!C22:D22","v":{"v":0,"d":"0.0000"}}]
[null,"PERIODO","FALTAS","AMORTIZACION MENSUAL"]
[null,"BIM 1",null,{"$f":"VLOOKUP(C8,result,3)","v":{"v":0,"d":"0.00"}}]
[null,"BIM 2",null,{"$f":"VLOOKUP(C8,result,4)","v":{"v":0,"d":"0.00"}}]
[null,"BIM 3",null,{"$f":"VLOOKUP(C8,result,5)","v":{"v":0,"d":"0.00"}}]
[null,"BIM 4",null,{"$f":"VLOOKUP(C8,result,6)","v":{"v":0,"d":"0.00"}}]
[null,"BIM 5",null,{"$f":"VLOOKUP(C8,result,7)","v":{"v":0,"d":"0.00"}}]
[null,"BIM 6",null,{"$f":"VLOOKUP(C8,result,8)","v":{"v":0,"d":"0.00"}}]
[]
[null,"AMORTIZACION ANUAL",null,{"$f":"SUM(D15:D21)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(15,0,D23)","v":0}]
[null,"RETENCION EN NOMINA EN BASE A DIAS",null,{"$f":"VLOOKUP(C8,result,2)*C4","v":{"v":3.813559322033898,"d":"3.81"}}]
[]
[{"$nulls":3},{"$f":"IF(D23>3.82,D23,0)","v":{"v":0,"d":"0.00"}}]

{"sheet":"SBC 2022","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[0,2,0,4],[4,3,4,4]]}
[null,null,"Salario Base de Cotización"]
["Datos generales para la integración","Importes","Fija","Variable","Total"]
["Salario minimo general",{"$f":"DATOS!C5","v":{"v":172.87,"d":"$172.87"}},{"$f":"IF(AND(B4<>\"\",ISNUMBER(E10)),(B4*E10),0)","v":{"v":180.68467123287672,"d":"180.68"}},0,{"$f":"SUMIF(C3:D3,\">0\")","v":{"v":180.68467123287672,"d":"180.68"}}]
["Cuota diaria del trabajador",{"$f":"'ISPT-INFO-IMSS TRABAJADOR 2022'!C8","v":{"v":172.87,"d":"$172.87"}}]
["Días de vacaciones",6,null,"Factor de integración"]
["Prima vacacional %",{"$f":"'ISPT-INFO-IMSS TRABAJADOR 2022'!C18","v":{"v":0.25,"d":"25%"}},null,"Prima vacacional",{"$f":"IF(AND(B5<>\"\",B6<>\"\"),(B5/365)*B6,\"\")","v":{"v":4.10958904109589E-3,"d":"0.0041"}}]
["Días de aguinaldo",15,"más: ","Por aguinaldo",{"$f":"IF(B7<>\"\",B7/365,\"\")","v":{"v":0.0410958904109589,"d":"0.0411"}}]
["Area geografica del contribuyente","UNICA","igual: ","Total",{"$f":"IF(AND(ISNUMBER(E6),ISNUMBER(E7)),E6+E7,\"\")","v":{"v":0.04520547945205479,"d":"0.0452"}}]
[null,null,"más: ","Unidad",{"v":1,"d":"1.00"}]
["Otros conceptos que integran el SBC",null,"igual: ","Factor ",{"$f":"IF(ISNUMBER(E8),E8+E9,\"\")","v":{"v":1.0452054794520549,"d":"1.0452"}}]

{"sheet":"TARIFAS ISPT, SUBSIDO AL EMPLEO","index":3,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[1,1,1,4],[1,6,1,8]]}
[]
[null,"TABLAS Y TARIFAS MENSUAL 2022",{"$nulls":4},"TABLA DE SUBSIDIO PARA EL EMPLEO 2022"]
[]
[null,"Limite inferior","Limite Superior","Cuota fija","% ",null,"Limite inferior","Limite Superior","Cuota fija"]
[null,{"v":0.01,"d":"$0.01"},{"v":644.58,"d":"$644.58"},0,{"v":0.0192,"d":"1.92%"},null,{"v":0.01,"d":"$0.01"},{"v":1768.96,"d":"$1,768.96"},{"v":407.02,"d":"$407.02"}]
[null,{"v":644.59,"d":"$644.59"},{"v":5470.92,"d":"$5,470.92"},{"v":12.38,"d":"$12.38"},{"v":0.064,"d":"6.40%"},null,{"v":1768.97,"d":"$1,768.97"},{"v":2653.38,"d":"$2,653.38"},{"v":406.83,"d":"$406.83"}]
[null,{"v":5470.93,"d":"$5,470.93"},{"v":9614.66,"d":"$9,614.66"},{"v":321.26,"d":"$321.26"},{"v":0.1088,"d":"10.88%"},null,{"v":2653.39,"d":"$2,653.39"},{"v":3472.84,"d":"$3,472.84"},{"v":406.62,"d":"$406.62"}]
[null,{"v":9614.67,"d":"$9,614.67"},{"v":11176.62,"d":"$11,176.62"},{"v":772.1,"d":"$772.10"},{"v":0.16,"d":"16.00%"},null,{"v":3472.85,"d":"$3,472.85"},{"v":3537.87,"d":"$3,537.87"},{"v":392.77,"d":"$392.77"}]
[null,{"v":11176.63,"d":"$11,176.63"},{"v":13381.47,"d":"$13,381.47"},{"v":1022.01,"d":"$1,022.01"},{"v":0.1792,"d":"17.92%"},null,{"v":3537.88,"d":"$3,537.88"},{"v":4446.15,"d":"$4,446.15"},{"v":382.46,"d":"$382.46"}]
[null,{"v":13381.48,"d":"$13,381.48"},{"v":26988.5,"d":"$26,988.50"},{"v":1417.12,"d":"$1,417.12"},{"v":0.2136,"d":"21.36%"},null,{"v":4446.16,"d":"$4,446.16"},{"v":4717.18,"d":"$4,717.18"},{"v":354.23,"d":"$354.23"}]
[null,{"v":26988.51,"d":"$26,988.51"},{"v":42537.58,"d":"$42,537.58"},{"v":4323.58,"d":"$4,323.58"},{"v":0.2352,"d":"23.52%"},null,{"v":4717.19,"d":"$4,717.19"},{"v":5335.42,"d":"$5,335.42"},{"v":324.87,"d":"$324.87"}]
[null,{"v":42537.59,"d":"$42,537.59"},{"v":81211.25,"d":"$81,211.25"},{"v":7980.73,"d":"$7,980.73"},{"v":0.3,"d":"30.00%"},null,{"v":5335.43,"d":"$5,335.43"},{"v":6224.67,"d":"$6,224.67"},{"v":294.63,"d":"$294.63"}]
[null,{"v":81211.26,"d":"$81,211.26"},{"v":108281.67,"d":"$108,281.67"},{"v":19582.83,"d":"$19,582.83"},{"v":0.32,"d":"32.00%"},null,{"v":6224.68,"d":"$6,224.68"},{"v":7113.9,"d":"$7,113.90"},{"v":253.54,"d":"$253.54"}]
[null,{"v":108281.68,"d":"$108,281.68"},{"v":324845.01,"d":"$324,845.01"},{"v":28245.36,"d":"$28,245.36"},{"v":0.34,"d":"34.00%"},null,{"v":7113.91,"d":"$7,113.91"},{"v":7382.33,"d":"$7,382.33"},{"v":217.61,"d":"$217.61"}]
[null,{"v":324845.02,"d":"$324,845.02"},{"v":999999999,"d":"$999,999,999.00"},{"v":101876.9,"d":"$101,876.90"},{"v":0.35,"d":"35.00%"},null,{"v":7382.34,"d":"$7,382.34"},{"v":999999999,"d":"$999,999,999.00"},0]

{"sheet":"CALCULO RETENCION","index":4,"n_rows":18,"n_cols":9,"rows_kept":18}
[]
[null,"SALARIO MINIMO CDMX",{"$f":"DATOS!C6","v":{"v":96.22,"d":"$96.22"}},"UMA al 7 de enero de 2022"]
[]
[null,"SALARIO BASE DE COTIZACION",null,{"$f":"DATOS!C12","v":{"v":180.68467123287672,"d":"180.6847"}}]
[null,"VSM",null,{"$f":"DATOS!C13","v":{"v":0,"d":"0.0000"}}]
[{"$nulls":3},"BIM 1","BIM 2","BIM 3","BIM 4","BIM 5","BIM 6"]
[{"$nulls":3},59,61,61,62,61,61]
[null,null,{"$f":"D7*C10","v":15},{"$f":"$D$5/100","v":{"v":0,"d":"0.0000%"}},{"$f":"$D$5/100","v":{"v":0,"d":"0.0000%"}},{"v":0,"d":"0.0000%"},{"v":0,"d":"0.0000%"},{"v":0,"d":"0.0000%"},{"v":0,"d":"0.0000%"}]
[{"$nulls":3},{"$f":"DATOS!C15","v":0},{"$f":"DATOS!C16","v":0},{"$f":"DATOS!C17","v":0},{"$f":"DATOS!C18","v":0},{"$f":"DATOS!C19","v":0},{"$f":"DATOS!C20","v":0}]
[null,1,{"$f":"(((($C$2*$D$5)*2)/D7))+(15/D7)","v":{"v":0.2542372881355932,"d":"0.25"}},{"$f":"(((($C$2*$D$5)*2)/D7)*(D7-D9))+IF(D7>D9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(((($C$2*$D$5)*2)/E7)*(E7-E9))+IF(E7>E9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(((($C$2*$D$5)*2)/F7)*(F7-F9))+IF(F7>F9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(((($C$2*$D$5)*2)/G7)*(G7-G9))+IF(G7>G9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(((($C$2*$D$5)*2)/H7)*(H7-H9))+IF(H7>H9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(((($C$2*$D$5)*2)/I7)*(I7-I9))+IF(I7>I9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}}]
[null,2,{"$f":"(($D$5*2)/D7)+(15/D7)","v":{"v":0.2542372881355932,"d":"0.25"}},{"$f":"(($D$5*2)/D7)*(D7-D9)+IF(D7>D9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$5*2)/E7)*(E7-E9)+IF(E7>E9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$5*2)/F7)*(F7-F9)+IF(F7>F9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$5*2)/G7)*(G7-G9)+IF(G7>G9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$5*2)/H7)*(H7-H9)+IF(H7>H9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$5*2)/I7)*(I7-I9)+IF(I7>I9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}}]
[null,3,{"$f":"(($D$4*D8))+(15/D7)","v":{"v":0.2542372881355932,"d":"0.25"}},{"$f":"(($D$4*D8)*(D7-D9))+IF(D7>D9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$4*E8)*(E7-E9))+IF(E7>E9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$4*F8)*(F7-F9))+IF(F7>F9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$4*G8)*(G7-G9))+IF(G7>G9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$4*H8)*(H7-H9))+IF(H7>H9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$4*I8)*(I7-I9))+IF(I7>I9,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}}]
[]
[null,1,null,null,{"$f":"(((($C$2*$D$5)*2)/E11)*(E11-E13))+IF(E11>E13,DATOS!$C$7,0)","v":{"$error":"#DIV/0!"}},{"$f":"(((($C$2*$D$5)*2)/F11)*(F11-F13))+IF(F11>F13,DATOS!$C$7,0)","v":{"$error":"#DIV/0!"}},{"$f":"(((($C$2*$D$5)*2)/G11)*(G11-G13))+IF(G11>G13,DATOS!$C$7,0)","v":{"$error":"#DIV/0!"}},{"$f":"(((($C$2*$D$5)*2)/H11)*(H11-H13))+IF(H11>H13,DATOS!$C$7,0)","v":{"$error":"#DIV/0!"}},{"$f":"(((($C$2*$D$5)*2)/I11)*(I11-I13))+IF(I11>I13,DATOS!$C$7,0)","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,{"$f":"(($D$5*2)/E11)*(E11-E13)+IF(E11>E13,DATOS!$C$7,0)","v":{"$error":"#DIV/0!"}},{"$f":"(($D$5*2)/F11)*(F11-F13)+IF(F11>F13,DATOS!$C$7,0)","v":{"$error":"#DIV/0!"}},{"$f":"(($D$5*2)/G11)*(G11-G13)+IF(G11>G13,DATOS!$C$7,0)","v":{"$error":"#DIV/0!"}},{"$f":"(($D$5*2)/H11)*(H11-H13)+IF(H11>H13,DATOS!$C$7,0)","v":{"$error":"#DIV/0!"}},{"$f":"(($D$5*2)/I11)*(I11-I13)+IF(I11>I13,DATOS!$C$7,0)","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,{"$f":"(($D$4*E12)*(E11-E13))+IF(E11>E13,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$4*F12)*(F11-F13))+IF(F11>F13,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$4*G12)*(G11-G13))+IF(G11>G13,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$4*H12)*(H11-H13))+IF(H11>H13,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}},{"$f":"(($D$4*I12)*(I11-I13))+IF(I11>I13,DATOS!$C$7,0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},{"$f":"(((($C$2*$D$5)*2)/D11))","v":{"$error":"#DIV/0!"}}]