{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["sueldonetoybruto"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"sueldonetoybruto","index":0,"n_rows":94,"n_cols":18,"rows_kept":94,"cut":false,"hidden":false,"merged":[[3,2,3,6],[62,5,62,6],[57,2,62,3],[31,2,31,3],[31,4,31,6],[32,5,32,6],[48,2,48,3]]}
[]
[]
[]
[null,null,"             CALCULADORA SUELDOS NETOS Y SUELDOS BRUTOS 2018"]
[null,null,null,"Area Geografica:","A",null,null,null,null,null,null,null,null,null,null,null,"A",80.599999999999994]
[null,null,null,"Días de aguinaldo:",15,null,null,null,null,null,null,null,null,null,null,null,"B",80.599999999999994]
[null,null,null,"Días de vacaciones:",6]
[null,null,null,"Prima vacacional:",0.25]
[null,null,null,"Frecuencia de pago:","Mensual",null,null,null,null,null,7,14,15.2,30.4]
[null,null,null,"Neto a pagar:",10000]
[]
[null,null,null,"Días pago:",{"$f":"VLOOKUP(E9,A71:D74,3,FALSE)","v":30}]
[null,null,null,"Días naturales:",{"$f":"VLOOKUP(E9,A71:D74,4, FALSE)","v":30}]
[null,null,null,"Factor ISR:",{"$f":"VLOOKUP(E9,A71:D74,2,FALSE)","v":30.4}]
[]
[null,null,null,"Salario diario:",390.02366666666666,"Factor de integración",null,null,null,null,30.4]
[null,null,null,"Salario diario integrado:",{"$f":"IF(E16*F17>25*R5,25*R5,E16*F17)","v":407.65273639999998},{"$f":"ROUND( (365 +E6+E7*E8) / 365, 4 )","v":1.0451999999999999}]
[]
[null,null,null,"Percepciones"]
[null,null,null,"Sueldo Ordinario",{"$f":"E16*E12","v":11700.71}]
[null,null,null,"Total de Percepciones:",{"$f":"SUM(E20:E20)","v":11700.71}]
[]
[null,null,null,"Deducciones"]
[null,null,null,"ISPT",{"$f":"MAX( D47-D56, 0 )","v":1216.46}]
[null,null,null,"IMSS",{"$f":"F63","v":310.35000000000002}]
[null,null,null,"Subsidio al Empleo",{"$f":"MIN(D47-D56,0)","v":0}]
[null,null,null,"Total de Deducciones:",{"$f":"E24+E25+E26","v":1526.81}]
[]
[null,null,null,"Neto a Pagar:",{"$f":"E21-E27","v":10173.9}]
[null,null,null," "," "]
[]
[null,null,"ISR de Percepciones Periódicas",null,"IMSS Empleado"]
[null,null,"Percepciones Gravadas",{"$f":"E21","v":11700.71},"Salario Base de Cotización",{"$f":"$E$17","v":407.65273639999998}]
[null,null,"( / ) Días de Periodo de Pago",{"$f":"$E$14","v":30.4},"(X) Tasa Art. 25",3.7499999999999999E-3]
[null,null,"(X) Factor Mensual",{"$f":"$B$74","v":30.4},"(=) Cuota Diaria Art. 25",{"$f":"ROUND(F33*F34,4)","v":1.5286999999999999}]
[null,null,"(=) Gravadas Promedio Mensual",{"$f":"ROUND(D33/D34*D35,2)","v":11700.71}]
[null,null,"Tabla Art. 96 LISR",null,"Salario Base de Cotización",{"$f":"$E$17","v":407.65273639999998}]
[null,null,"(-) Límite Inferior",{"$f":"VLOOKUP($D$36,$E$70:$O$80,1)","v":10031.08},"(-) 3 SMGDF",{"$f":"3*$G$38","v":241.79999999999998},{"$f":"IF(E5=\"A\",R5,IF(E5=\"B\",R6,0))","v":80.599999999999994}]
[null,null,"(=) Excedente",{"$f":"D36-D38","v":1669.6299999999992},"(=) Excedente",{"$f":"MAX(F37-F38, 0)","v":165.8527364}]
[null,null,"(X) Tasa",{"$f":"VLOOKUP($D$36,$E$70:$O$80,4)","v":0.1792},"(X) Tasa Art. 106-2",4.0000000000000001E-3]
[null,null,"(=) Impuesto Marginal",{"$f":"D39*D40","v":299.19769599999984},"(=) Cuota Diaria Art. 106-2",{"$f":"ROUND(F39*F40,4)","v":0.66339999999999999}]
[null,null,"(+) Cuota Fija",{"$f":"VLOOKUP($D$36,$E$70:$O$80,3)","v":917.26}]
[null,null,"(=) ISR Promedio Mensual",{"$f":"D41+D42","v":1216.4576959999999},"Salario Base de Cotización",{"$f":"$E$17","v":407.65273639999998}]
[null,null,null,null,"(X) Tasa Art. 107",2.5000000000000001E-3]
[null,null,"(/ ) Factor Mensual",{"$f":"$B$74","v":30.4},"(=) Cuota Diaria Art. 107",{"$f":"ROUND(F43*F44,4)","v":1.0190999999999999}]
[null,null,"(X) Días de Periodo de Pago",{"$f":"$E$14","v":30.4}]
[null,null,"(=) ISR de Periodo",{"$f":"ROUND(D43/D45*D46,2)","v":1216.46},"Salario Base de Cotización",{"$f":"$E$17","v":407.65273639999998}]
[null,null,null,null,"(X) Tasa Invalidez y Vida",6.2500000000000003E-3]
[null,null,"Subsidio al Empleo",null,"(=) Cuota Diaria Invalidez y Vida",{"$f":"ROUND(F47*F48,4)","v":2.5478000000000001}]
[null,null,"Gravadas Promedio Mensual",{"$f":"D36","v":11700.71}]
[null,null,null,null,"Salario Base de Cotización",{"$f":"$E$17","v":407.65273639999998}]
[null,null,"Tabla Subsidio al Empleo",{"$f":"IF( D50 <= 0, 0, VLOOKUP(D50,$E$84:$G$94,3))","v":0},"(X) Tasa Cesantía y Vejez",1.125E-2]
[null,null,null,null,"(=) Cuota Diaria Cesantía y Vejez",{"$f":"ROUND(F51*F52,4)","v":4.5861000000000001}]
[null,null,"(/) Factor Mensual",{"$f":"$B$74","v":30.4}]
[null,null,"(X) Días de Periodo de Pago",{"$f":"$E$14","v":30.4},"Cuota Art. 25",{"$f":"F35","v":1.5286999999999999}]
[null,null,"(=) Subsidio del Periodo",{"$f":"ROUND(D52/D54*D55,2)","v":0},"(+) Cuota Art. 106-2",{"$f":"F41","v":0.66339999999999999}]
[null,null,null,null,"(+) Cuota Art. 107",{"$f":"F45","v":1.0190999999999999}]
[null,null,null,null,"(+) Cuota Invalidez y Vida",{"$f":"F49","v":2.5478000000000001}]
[null,null,null,null,"(+) Cuota Cesantía y Vejez",{"$f":"F53","v":4.5861000000000001}]
[null,null,null,null,"(=) Cuota Diaria Empleado",{"$f":"SUM(F55:F59)","v":10.3451}]
[]
[null,null,null,null,"(X) Dias de Periodo",{"$f":"E13","v":30}]
[null,null,null,null,"(=) IMSS Empleado",{"$f":"ROUND(F60*F62,2)","v":310.35000000000002}]
[]
[]
[]
[]
[null,null,null,null,"Tabla Art. 96 LISR"]
[" "," ",null,null,"Límite Inferior","Superior","Cuota Fija","Tasa"]
["Frecuencia","Factor ISR","Días Pago","Días  naturales",0.01,578.52,"–",1.9199999999999998E-2]
["Semanal",7,7,7,578.53,4910.18,11.11,6.4000000000000001E-2]
["Catorcenal",14,14,14,4910.1899999999996,8629.2000000000007,288.33,0.10879999999999999]
["Quincenal",15.2,15,15,8629.2099999999991,10031.07,692.96,0.16]
["Mensual",30.4,30,30,10031.08,12009.94,917.26,0.1792]
[null,null,null,null,12009.95,24222.31,1271.8699999999999,0.21360000000000001]
[null,null,null,null,24222.32,38177.69,3880.44,0.23519999999999999]
[null,null,null,null,38177.699999999997,72887.5,7162.74,0.3]
[null,null,null,null,72887.509999999995,97183.33,17575.689999999999,0.32]
[null,null,null,null,97183.34,291550,25350.35,0.34]
[null,null,null,null,291550.01,null,91435.02,0.35]
[]
[null,null,null,null,"Subsidio para el Empleo"]
[null,null,null,null,"Límite Inferior","Superior","Subsidio"]
[null,null,null,null,0.01,1768.96,407.02]
[null,null,null,null,1768.97,2653.38,406.83]
[null,null,null,null,2653.39,3472.84,406.62]
[null,null,null,null,3472.85,3537.87,392.77]
[null,null,null,null,3537.88,4446.1499999999996,382.46]
[null,null,null,null,4446.16,4717.18,354.23]
[null,null,null,null,4717.1899999999996,5335.42,324.87]
[null,null,null,null,5335.43,6224.67,294.63]
[null,null,null,null,6224.68,7113.9,253.54]
[null,null,null,null,7113.91,7382.33,217.61]
[null,null,null,null,7382.34,null,0]