{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["GraficarPuntos","Opciones Nomina","Hoja2","Instrucciones","Anual26","Resumen","M-01","M-02","M-03","M-04","M-05","M-06","M-07","M-08","M-09","M-10","M-11","M-12","TARIFAS","Hoja1","Hoja3","Hoja4","Parametros"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":48,"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":"GraficarPuntos","index":0,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["Grafica de Comportamiento de Ambas Leyes:"]
[]
[]
["Veces de SMG","Ley Actual","Reforma"]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Opciones Nomina","index":1,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Opciones del sistema",null,null,null,null,null,null,null,null,null,"Nombre en la cedula"]
[]
[1,null,null,null,null,null,null,null,null,null,"Monto de Subisdio a pagar Maximo (475 o por Dias del Periodo)"]
[]
[2,null,null,null,null,null,null,null,null,null,"No aplica"]
[]
[3,null,null,null,null,null,null,null,null,null,"Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\""]
[]
[4,null,null,null,null,null,null,null,null,null,"Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)"]
[]
[5,null,null,null,null,null,null,null,null,null,"No aplica"]
[]
[6,null,null,null,null,null,null,null,null,null,"Retener ISR aunque el trabajador gané el minimo"]

{"sheet":"Hoja2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Instrucciones","index":3,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["Fecha última actualización: 02/ene/2026"]
[]
["Instrucciones:"]
[]
["Para hacer simulación de sueldos y el cálculo anual, recomeindo que solo modifiques las celdas en amarillo."]
[]
["Existen 5 banderas, están seleccionadas de la forma más conservadora posible, es decir, menos riesgos en el cálculo anual"]
["Tú puedes modificar estas banderas para ver el posible impacto que pudieras tener."]
[]
["La hoja Anual y Resumen están protegidas."]
[]
[]
[]
[]
[null,null,null,null,null,"Opcion","Auxilar Opción"]
["Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,"No",0]
["Retener ISR aunque el trabajador gane el mínimo",null,null,null,null,"No",0]
["Monto de Subisdio a pagar Máximo (536.21 o por Días del Periodo)",null,null,null,null,"Dias del Periodo",{"$f":"F19","v":"Dias del Periodo"}]
["Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,"Si",1]
[]
["En periodos de mas de 4 semanas, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,{"$f":"SubMens","v":536.21},{"$f":"F22","v":536.21}]
[]
["Nota: El salario diario limite para que el empleado se le otorgue  subsidio al empleo,  puede ser de 328.35 pesos,  para considerar meses que tengan  4 y 5 semanas en el mes"]
[]
[]
["Autores:"]
["Benito Brragán Rangel"]
["María Susana Hernández Valenzuela"]
["Edwin Alejandro Frias Berumen"]
["José Luis Aldana Díaz"]

{"sheet":"Anual26","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Calculo Anual 2026"]
[]
["Tipo concepto","Clave SAT","Conceptos","Importes"]
["Percepción","Varias","Ingreso gravado acumulable",{"$f":"+Resumen!C18","v":122080}]
[null,null,"Calculo según Tarifa Anual",{"$f":"(D4-VLOOKUP(D4,Anual,1))*VLOOKUP(D4,Anual,3)+VLOOKUP(D4,Anual,2)","v":8974.4673440000006}]
[null,"Nodo","Subsidio Causado Correspondiente",{"$f":"+Resumen!G18","v":6222.8581578947369}]
["Deducción","107","Ajuste Subs Causado (Resta)",{"$f":"+Resumen!H18","v":0}]
[null,null,"Total Subsidio Causado",{"$f":"+D6-D7","v":6222.8581578947369}]
[null,null,"Calculo Anual ISR Menos Subsidio",{"$f":"+D5-D8","v":2751.6091861052637}]
["Deducción","002","ISR Retenido del Mes",{"$f":"+Resumen!D18","v":2513.0900605263132}]
["Deducción","002","ISR Retenido de Menos",{"$f":"+Resumen!E18","v":380.24066536842213}]
["Deducción","002","ISR Por Ajuste Mensual",{"$f":"+Resumen!F18","v":0}]
[null,null,"Total de ISR Retenido",{"$f":"SUM(D10:D12)","v":2893.3307258947352}]
["Otro Pago","001","Reintegro de ISR retenido de mas",{"$f":"+Resumen!I18","v":28.340919157894632}]
[null,null,"Total ISR retenido",{"$f":"+D13-D14","v":2864.9898067368404}]
[null,null,"Saldo en Contra",{"$f":"MAX(0,+D9-D15)","v":0}]
[null,null,"Saldo a Favor",{"$f":"MAX(0,+D15-D9)","v":113.38062063157668}]

{"sheet":"Resumen","index":5,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Resumen Meses Para Calculo Anual"]
[]
[{"$f":"+'M-01'!M2","v":0},{"$f":"+'M-01'!N2","v":"Dias"},{"$f":"+'M-01'!O2","v":"Varios"},{"$f":"+'M-01'!P2","v":"Deduccion 002"},{"$f":"+'M-01'!R2","v":"Deduccion 002"},"Deducción 002","Nodo",{"$f":"+'M-01'!T2","v":"Deducción 107"},{"$f":"+'M-01'!U2","v":"Otro Pagos 001"}]
[{"$f":"+'M-01'!M3","v":"Mes"},{"$f":"+'M-01'!N3","v":"Acumulado Dias"},{"$f":"+'M-01'!O3","v":"Ingreso Acumulable del Mes"},{"$f":"+'M-01'!P3","v":"ISR Retenido del Mes"},"ISR Retenido de Menos","ISR Por Ajuste Mensual",{"$f":"+'M-01'!S3","v":"Subsidio Correspondiente"},{"$f":"+'M-01'!T3","v":"Ajuste al Subsidio Causado"},{"$f":"+'M-01'!U3","v":"Reintegro de ISR Retenido en Exceso"},{"$f":"+'M-01'!V3","v":"ISR Neto"},{"$f":"+'M-01'!W3","v":"Subsidio Correspondiente Neto"}]
[{"$f":"_xlfn.VSTACK('M-01:M-12'!M4:U4)","v":1},35,11480,299.5089289473683,54.320095052631586,0,536.21,0,0,{"$f":"+D5+E5+F5","v":353.82902399999989},{"$f":"+G5-H5","v":536.21}]
[2,28,8848,138.14071157894716,0,0,493.87763157894744,0,28.340919157894632,{"$f":"+D6+E6+F6","v":138.14071157894716},{"$f":"+G6-H6","v":493.87763157894744}]
[3,28,8848,138.14071157894716,0,0,493.87763157894744,0,0,138.14071157894716,493.87763157894744]
[4,28,8848,138.14071157894716,0,0,493.87763157894744,0,0,138.14071157894716,493.87763157894744]
[5,35,11060,253.81292894736822,54.320095052631757,0,536.21,0,0,308.13302399999998,536.21]
[6,28,8848,138.14071157894716,0,0,493.87763157894744,0,0,138.14071157894716,493.87763157894744]
[7,35,11060,253.81292894736822,54.320095052631757,0,536.21,0,0,308.13302399999998,536.21]
[8,28,8848,138.14071157894716,0,0,493.87763157894744,0,0,138.14071157894716,493.87763157894744]
[9,35,11060,253.81292894736822,54.320095052631757,0,536.21,0,0,308.13302399999998,536.21]
[10,35,11060,253.81292894736822,54.320095052631757,0,536.21,0,0,308.13302399999998,536.21]
[11,35,11060,253.81292894736822,54.320095052631757,0,536.21,0,0,308.13302399999998,536.21]
[12,35,11060,253.81292894736822,54.320095052631757,0,536.21,0,0,308.13302399999998,536.21]
[]
["Total",{"$f":"SUM(B5:B16)","v":385},{"$f":"SUM(C5:C16)","v":122080},{"$f":"SUM(D5:D16)","v":2513.0900605263132},380.24066536842213,{"$f":"SUM(F5:F16)","v":0},6222.8581578947369,0,28.340919157894632,2893.3307258947352,6222.8581578947369]

{"sheet":"M-01","index":6,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",5,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,7,{"$f":"SUM(D4:H4)","v":35},null,null,null,1,{"$f":"+I4","v":35},{"$f":"+I9","v":11480},{"$f":"SUM(D21:H21)","v":299.5089289473683},{"$f":"+H22","v":54.320095052631586},{"$f":"+J24","v":0},{"$f":"+I18","v":536.21},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":353.82902399999989},{"$f":"+S4-T4","v":536.21}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",328,{"$f":"+D6","v":328},{"$f":"+E6","v":328},328,{"$f":"G6","v":328}]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2296},{"$f":"E5*E6","v":2296},{"$f":"F5*F6","v":2296},{"$f":"G5*G6","v":2296},{"$f":"H5*H6","v":2296},{"$f":"SUM(D7:H7)","v":11480}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2296},{"$f":"+E8+E7","v":2296},{"$f":"+F8+F7","v":2296},{"$f":"+G8+G7","v":2296},{"$f":"+H8+H7","v":2296},{"$f":"SUM(D9:H9)","v":11480},{"$f":"I9","v":11480}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2296},{"$f":"+D10+E9","v":4592},{"$f":"+E10+F9","v":6888},{"$f":"+F10+G9","v":9184},{"$f":"+G10+H9","v":11480}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":7}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9971.1999999999989},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9971.1999999999989},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9971.1999999999989},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9971.1999999999989},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":9971.1999999999989}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":725.88158399999986},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":725.88158399999986},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":725.88158399999986},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":725.88158399999986},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":725.88158399999986}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":123.46940789473686}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":536.21}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":167.14378578947367},{"$f":"E13/30.4*E11","v":167.14378578947367},{"$f":"F13/30.4*F11","v":167.14378578947367},{"$f":"G13/30.4*G11","v":167.14378578947367},{"$f":"H13/30.4*H11","v":167.14378578947367},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":890.03902399999993},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":42.332368421052593},{"$f":"SUM(D18:H18)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":536.21}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":42.332368421052593},{"$f":"SUM(D19:H19)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":536.21}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":536.21}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":43.674377894736807},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":43.674377894736807},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":43.674377894736779},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":43.674377894736836},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":124.81141736842108},{"$f":"SUM(D21:H21)+H24","v":299.5089289473683},{"$f":"MAX(0,J17-J19)","v":353.82902399999989},{"$f":"J21-I21","v":54.320095052631586}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":54.320095052631586}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2252.3256221052634},{"$f":"+E9-E21-E24","v":2252.3256221052634},{"$f":"+F9-F21-F24","v":2252.3256221052634},{"$f":"+G9-G21-G24+G26","v":2252.3256221052634},{"$f":"+H9-H21-H24-H22+H26","v":2116.8684875789472}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,"Si",{"$f":"IF(G34=\"Si\",1,0)","v":1},null,{"$f":"IF(G34=\"si\",1,0)","v":1}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":536.21}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-02","index":7,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",4,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,null,{"$f":"SUM(D4:H4)","v":28},null,null,null,2,{"$f":"+I4","v":28},{"$f":"+I9","v":8848},{"$f":"SUM(D21:H21)","v":138.14071157894716},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":493.87763157894744},{"$f":"+J25","v":0},{"$f":"+J26","v":28.340919157894632},{"$f":"+P4+Q4+R4","v":138.14071157894716},{"$f":"+S4-T4","v":493.87763157894744}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":8848}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":8848},{"$f":"I9","v":8848}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":8848}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":0}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":0},null,null,null,null,10171,null,10171]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":0},null,null,null,null,{"$f":"+M12/28","v":363.25},null,{"$f":"+O12/35","v":290.60000000000002}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":0}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":603.67742399999997},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":0},{"$f":"SUM(D18:H18)","v":493.87763157894744},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":493.87763157894744}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":493.87763157894744},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":493.87763157894744}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":493.87763157894744}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":138.14071157894716},{"$f":"MAX(0,J17-J19)","v":109.79979242105253},{"$f":"J21-I21","v":-28.340919157894632}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":0}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":28.340919157894632},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":28.340919157894632}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2205.8057412631579},{"$f":"+H9-H21-H24-H22+H26","v":0}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,"Si",{"$f":"IF(G34=\"Si\",1,0)","v":1},null,{"$f":"IF(G34=\"si\",1,0)","v":1}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":493.87763157894744}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-03","index":8,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",4,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,null,{"$f":"SUM(D4:H4)","v":28},null,null,null,3,{"$f":"+I4","v":28},{"$f":"+I9","v":8848},{"$f":"SUM(D21:H21)","v":138.14071157894716},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":493.87763157894744},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":138.14071157894716},{"$f":"+S4-T4","v":493.87763157894744}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":8848}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":8848},{"$f":"I9","v":8848}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":8848}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":0}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":0}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":0}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":0}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":603.67742399999997},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":0},{"$f":"SUM(D18:H18)","v":493.87763157894744},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":493.87763157894744}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":493.87763157894744},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":493.87763157894744}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":493.87763157894744}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":138.14071157894716},{"$f":"MAX(0,J17-J19)","v":109.79979242105253},{"$f":"J21-I21","v":-28.340919157894632}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":0}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2177.464822105263},{"$f":"+H9-H21-H24-H22+H26","v":0}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,"No",{"$f":"IF(G34=\"Si\",1,0)","v":0},null,{"$f":"IF(G34=\"si\",1,0)","v":0}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":493.87763157894744}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-04","index":9,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",4,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,null,{"$f":"SUM(D4:H4)","v":28},null,null,null,4,{"$f":"+I4","v":28},{"$f":"+I9","v":8848},{"$f":"SUM(D21:H21)","v":138.14071157894716},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":493.87763157894744},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":138.14071157894716},{"$f":"+S4-T4","v":493.87763157894744}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":8848}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":8848},{"$f":"I9","v":8848}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":8848}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":0}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":0}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":0}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":0}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":603.67742399999997},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":0},{"$f":"SUM(D18:H18)","v":493.87763157894744},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":493.87763157894744}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":493.87763157894744},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":493.87763157894744}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":493.87763157894744}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":138.14071157894716},{"$f":"MAX(0,J17-J19)","v":109.79979242105253},{"$f":"J21-I21","v":-28.340919157894632}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":0}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2177.464822105263},{"$f":"+H9-H21-H24-H22+H26","v":0}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,{"$f":"+Instrucciones!F17","v":"No"},{"$f":"IF(G34=\"Si\",1,0)","v":0},null,{"$f":"IF(G34=\"si\",1,0)","v":0}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":493.87763157894744}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-05","index":10,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",5,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,7,{"$f":"SUM(D4:H4)","v":35},null,null,null,5,{"$f":"+I4","v":35},{"$f":"+I9","v":11060},{"$f":"SUM(D21:H21)","v":253.81292894736822},{"$f":"+H22","v":54.320095052631757},{"$f":"+J24","v":0},{"$f":"+I18","v":536.21},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":308.13302399999998},{"$f":"+S4-T4","v":536.21}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":2212},{"$f":"SUM(D7:H7)","v":11060}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":2212},{"$f":"SUM(D9:H9)","v":11060},{"$f":"I9","v":11060}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":11060}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":7}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":9606.4}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":686.19134399999984}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":123.46940789473686}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":536.21}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":158.00458578947365},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":844.34302400000001},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":42.332368421052593},{"$f":"SUM(D18:H18)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":536.21}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":42.332368421052593},{"$f":"SUM(D19:H19)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":536.21}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":536.21}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":115.67221736842106},{"$f":"SUM(D21:H21)+H24","v":253.81292894736822},{"$f":"MAX(0,J17-J19)","v":308.13302399999998},{"$f":"J21-I21","v":54.320095052631757}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":54.320095052631757}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2177.464822105263},{"$f":"+H9-H21-H24-H22+H26","v":2042.0076875789471}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,"No",{"$f":"IF(G34=\"Si\",1,0)","v":0},null,{"$f":"IF(G34=\"si\",1,0)","v":0}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":536.21}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-06","index":11,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",4,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,null,{"$f":"SUM(D4:H4)","v":28},null,null,null,6,{"$f":"+I4","v":28},{"$f":"+I9","v":8848},{"$f":"SUM(D21:H21)","v":138.14071157894716},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":493.87763157894744},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":138.14071157894716},{"$f":"+S4-T4","v":493.87763157894744}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":8848}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":8848},{"$f":"I9","v":8848}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":8848}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":0}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":0}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":0}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":0}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":603.67742399999997},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":0},{"$f":"SUM(D18:H18)","v":493.87763157894744},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":493.87763157894744}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":493.87763157894744},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":493.87763157894744}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":493.87763157894744}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":138.14071157894716},{"$f":"MAX(0,J17-J19)","v":109.79979242105253},{"$f":"J21-I21","v":-28.340919157894632}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":0}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2177.464822105263},{"$f":"+H9-H21-H24-H22+H26","v":0}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,{"$f":"+Instrucciones!F17","v":"No"},{"$f":"IF(G34=\"Si\",1,0)","v":0},null,{"$f":"IF(G34=\"si\",1,0)","v":0}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":493.87763157894744}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-07","index":12,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",5,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,7,{"$f":"SUM(D4:H4)","v":35},null,null,null,7,{"$f":"+I4","v":35},{"$f":"+I9","v":11060},{"$f":"SUM(D21:H21)","v":253.81292894736822},{"$f":"+H22","v":54.320095052631757},{"$f":"+J24","v":0},{"$f":"+I18","v":536.21},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":308.13302399999998},{"$f":"+S4-T4","v":536.21}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":2212},{"$f":"SUM(D7:H7)","v":11060}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":2212},{"$f":"SUM(D9:H9)","v":11060},{"$f":"I9","v":11060}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":11060}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":7}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":9606.4}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":686.19134399999984}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":123.46940789473686}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":536.21}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":158.00458578947365},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":844.34302400000001},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":42.332368421052593},{"$f":"SUM(D18:H18)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":536.21}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":42.332368421052593},{"$f":"SUM(D19:H19)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":536.21}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":536.21}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":115.67221736842106},{"$f":"SUM(D21:H21)+H24","v":253.81292894736822},{"$f":"MAX(0,J17-J19)","v":308.13302399999998},{"$f":"J21-I21","v":54.320095052631757}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":54.320095052631757}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2177.464822105263},{"$f":"+H9-H21-H24-H22+H26","v":2042.0076875789471}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,{"$f":"+Instrucciones!F17","v":"No"},{"$f":"IF(G34=\"Si\",1,0)","v":0},null,{"$f":"IF(G34=\"si\",1,0)","v":0}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":536.21}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-08","index":13,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",4,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,null,{"$f":"SUM(D4:H4)","v":28},null,null,null,8,{"$f":"+I4","v":28},{"$f":"+I9","v":8848},{"$f":"SUM(D21:H21)","v":138.14071157894716},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":493.87763157894744},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":138.14071157894716},{"$f":"+S4-T4","v":493.87763157894744}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":8848}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":8848},{"$f":"I9","v":8848}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":8848}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":0}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":0}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":0}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":0}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":603.67742399999997},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":0},{"$f":"SUM(D18:H18)","v":493.87763157894744},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":493.87763157894744}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":493.87763157894744},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":493.87763157894744}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":493.87763157894744}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":138.14071157894716},{"$f":"MAX(0,J17-J19)","v":109.79979242105253},{"$f":"J21-I21","v":-28.340919157894632}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":0}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2177.464822105263},{"$f":"+H9-H21-H24-H22+H26","v":0}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,{"$f":"+Instrucciones!F17","v":"No"},{"$f":"IF(G34=\"Si\",1,0)","v":0},null,{"$f":"IF(G34=\"si\",1,0)","v":0}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":493.87763157894744}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-09","index":14,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",5,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,7,{"$f":"SUM(D4:H4)","v":35},null,null,null,9,{"$f":"+I4","v":35},{"$f":"+I9","v":11060},{"$f":"SUM(D21:H21)","v":253.81292894736822},{"$f":"+H22","v":54.320095052631757},{"$f":"+J24","v":0},{"$f":"+I18","v":536.21},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":308.13302399999998},{"$f":"+S4-T4","v":536.21}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":2212},{"$f":"SUM(D7:H7)","v":11060}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":2212},{"$f":"SUM(D9:H9)","v":11060},{"$f":"I9","v":11060}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":11060}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":7}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":9606.4}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":686.19134399999984}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":123.46940789473686}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":536.21}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":158.00458578947365},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":844.34302400000001},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":42.332368421052593},{"$f":"SUM(D18:H18)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":536.21}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":42.332368421052593},{"$f":"SUM(D19:H19)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":536.21}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":536.21}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":115.67221736842106},{"$f":"SUM(D21:H21)+H24","v":253.81292894736822},{"$f":"MAX(0,J17-J19)","v":308.13302399999998},{"$f":"J21-I21","v":54.320095052631757}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":54.320095052631757}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2177.464822105263},{"$f":"+H9-H21-H24-H22+H26","v":2042.0076875789471}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,{"$f":"+Instrucciones!F17","v":"No"},{"$f":"IF(G34=\"Si\",1,0)","v":0},null,{"$f":"IF(G34=\"si\",1,0)","v":0}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":536.21}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-10","index":15,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",5,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,7,{"$f":"SUM(D4:H4)","v":35},null,null,null,10,{"$f":"+I4","v":35},{"$f":"+I9","v":11060},{"$f":"SUM(D21:H21)","v":253.81292894736822},{"$f":"+H22","v":54.320095052631757},{"$f":"+J24","v":0},{"$f":"+I18","v":536.21},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":308.13302399999998},{"$f":"+S4-T4","v":536.21}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":2212},{"$f":"SUM(D7:H7)","v":11060}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":2212},{"$f":"SUM(D9:H9)","v":11060},{"$f":"I9","v":11060}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":11060}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":7}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":9606.4}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":686.19134399999984}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":123.46940789473686}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":536.21}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":158.00458578947365},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":844.34302400000001},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":42.332368421052593},{"$f":"SUM(D18:H18)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":536.21}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":42.332368421052593},{"$f":"SUM(D19:H19)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":536.21}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":536.21}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":115.67221736842106},{"$f":"SUM(D21:H21)+H24","v":253.81292894736822},{"$f":"MAX(0,J17-J19)","v":308.13302399999998},{"$f":"J21-I21","v":54.320095052631757}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":54.320095052631757}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2177.464822105263},{"$f":"+H9-H21-H24-H22+H26","v":2042.0076875789471}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,{"$f":"+Instrucciones!F17","v":"No"},{"$f":"IF(G34=\"Si\",1,0)","v":0},null,{"$f":"IF(G34=\"si\",1,0)","v":0}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":536.21}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-11","index":16,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",5,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,7,{"$f":"SUM(D4:H4)","v":35},null,null,null,11,{"$f":"+I4","v":35},{"$f":"+I9","v":11060},{"$f":"SUM(D21:H21)","v":253.81292894736822},{"$f":"+H22","v":54.320095052631757},{"$f":"+J24","v":0},{"$f":"+I18","v":536.21},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":308.13302399999998},{"$f":"+S4-T4","v":536.21}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":2212},{"$f":"SUM(D7:H7)","v":11060}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":2212},{"$f":"SUM(D9:H9)","v":11060},{"$f":"I9","v":11060}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":11060}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":7}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":9606.4}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":686.19134399999984}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":123.46940789473686}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":536.21}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":158.00458578947365},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":844.34302400000001},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":42.332368421052593},{"$f":"SUM(D18:H18)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":536.21}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":42.332368421052593},{"$f":"SUM(D19:H19)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":536.21}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":536.21}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":115.67221736842106},{"$f":"SUM(D21:H21)+H24","v":253.81292894736822},{"$f":"MAX(0,J17-J19)","v":308.13302399999998},{"$f":"J21-I21","v":54.320095052631757}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":54.320095052631757}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2177.464822105263},{"$f":"+H9-H21-H24-H22+H26","v":2042.0076875789471}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,{"$f":"+Instrucciones!F17","v":"No"},{"$f":"IF(G34=\"Si\",1,0)","v":0},null,{"$f":"IF(G34=\"si\",1,0)","v":0}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":536.21}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"M-12","index":17,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Número de periodos \nen el mes",5,"Nota: Si vas a realizar el cálculo con 4 semanas, asegúrate de poner en cero los días pagados del periodo 5!!!!"]
[null,null,null,"P E R I O D O S",null,null,null,null,null,null,null,null,null,"Dias","Varios","Deduccion 002","Deduccion 002","Deduccion 002","Sin Concepto","Deducción 107","Otro Pagos 001"]
["Cve SAT","Tipo Concepto","Concepto",1,2,3,4,5,"Acumulados Periodo","Recalculo","Diferencia",null,"Mes","Acumulado Dias","Ingreso Acumulable del Mes","ISR Retenido del Mes","ISR Retenido de Menos","ISR Por Ajuste Mensual","Subsidio Correspondiente","Ajuste al Subsidio Causado","Reintegro de ISR Retenido en Exceso","ISR Neto","Subsidio Correspondiente Neto"]
[null,null,"Dias Periodo/Calendario",7,7,{"$f":"+E4","v":7},7,7,{"$f":"SUM(D4:H4)","v":35},null,null,null,12,{"$f":"+I4","v":35},{"$f":"+I9","v":11060},{"$f":"SUM(D21:H21)","v":253.81292894736822},{"$f":"+H22","v":54.320095052631757},{"$f":"+J24","v":0},{"$f":"+I18","v":536.21},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":308.13302399999998},{"$f":"+S4-T4","v":536.21}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",316,{"$f":"+D6","v":316},{"$f":"+E6","v":316},316,316]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":2212},{"$f":"E5*E6","v":2212},{"$f":"F5*F6","v":2212},{"$f":"G5*G6","v":2212},{"$f":"H5*H6","v":2212},{"$f":"SUM(D7:H7)","v":11060}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":2212},{"$f":"+E8+E7","v":2212},{"$f":"+F8+F7","v":2212},{"$f":"+G8+G7","v":2212},{"$f":"+H8+H7","v":2212},{"$f":"SUM(D9:H9)","v":11060},{"$f":"I9","v":11060}]
[null,"Ocultos","Oculto Acumulado para  11,492.66",{"$f":"+D9","v":2212},{"$f":"+D10+E9","v":4424},{"$f":"+E10+F9","v":6636},{"$f":"+F10+G9","v":8848},{"$f":"+G10+H9","v":11060}]
[null,"Ocultos","Dias a Tomar Para Elevar/DesElevar",{"$f":"+D4","v":7},{"$f":"+E4","v":7},{"$f":"+F4","v":7},{"$f":"+G4","v":7},{"$f":"+H4","v":7}]
[null,"Ocultos","Base gravada elevada al mes",{"$f":"IF(D9=0,0,D9/D11*30.4)","v":9606.4},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":9606.4},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":9606.4},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":9606.4},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":9606.4}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":686.19134399999984},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":686.19134399999984},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":686.19134399999984},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":686.19134399999984},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":686.19134399999984}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(E4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(F4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(G4=0,0,SubSem)","v":123.46940789473686},{"$f":"IF(H4=0,0,SubSem)","v":123.46940789473686}]
[null,"Ocultos","Oculto Para llegar a los 536.21",{"$f":"+D14","v":123.46940789473686},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":246.93881578947372},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":370.40822368421061},{"$f":"IF(G3=B1, MAX(H36,IF(G4=0,0,MIN(F15+G14,$H$36))), IF(G4=0,0,MIN(+F15+G14,$H$36)))","v":493.87763157894744},{"$f":"IF(H3=B1, MAX(H36,IF(H4=0,0,MIN(F15+H14,$H$36))), IF(H4=0,0,MIN(+F15+G14,$H$36)))","v":536.21}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264},{"$f":"LimiteSemSub","v":2646.3361842105264}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":158.00458578947365},{"$f":"E13/30.4*E11","v":158.00458578947365},{"$f":"F13/30.4*F11","v":158.00458578947365},{"$f":"G13/30.4*G11","v":158.00458578947365},{"$f":"H13/30.4*H11","v":158.00458578947365},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":844.34302400000001},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":123.46940789473686},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":123.46940789473686},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":123.46940789473689},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":42.332368421052593},{"$f":"SUM(D18:H18)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I18>H39),0,I18)","v":536.21}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":123.46940789473686},{"$f":"MIN(E18,E17)","v":123.46940789473686},{"$f":"MIN(F18,F17)","v":123.46940789473689},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":123.46940789473683},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":42.332368421052593},{"$f":"SUM(D19:H19)","v":536.21},{"$f":"IF(OR(I9>LimiteMensSub,I19>H39),0,I19)","v":536.21}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":123.46940789473686},{"$f":"E19+D20","v":246.93881578947372},{"$f":"F19+E20","v":370.40822368421061},{"$f":"G19+F20","v":493.87763157894744},{"$f":"H19+G20","v":536.21}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":34.53517789473679},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":34.535177894736762},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":34.535177894736819},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":115.67221736842106},{"$f":"SUM(D21:H21)+H24","v":253.81292894736822},{"$f":"MAX(0,J17-J19)","v":308.13302399999998},{"$f":"J21-I21","v":54.320095052631757}]
["002","Deducción","ISR Retenido de Menos",null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","v":54.320095052631757}]
["107","Deducción","Ajuste al Subsidio Causado",null,null,null,{"$f":"IF($H$9=0,J23,0)","v":0},{"$f":"IF($H$9<>0,J23,0)","v":0},"Resta",{"$f":"IF(I19>J19,I19,0)","v":0}]
["002","Deducción","ISR por ajuste mensual",null,null,null,{"$f":"IF($H$9=0,J24,0)","v":0},{"$f":"IF($H$9<>0,J24,0)","v":0},"Resta",{"$f":"+J23","v":0}]
["007","Otros Pagos","ISR ajustado por subsidio",null,null,null,{"$f":"IF($H$9=0,J25,0)","v":0},{"$f":"IF($H$9<>0,J25,0)","v":0},"Suma",{"$f":"+J24","v":0}]
["001","Otros Pagos","Reintegro de ISR retenido en exceso",null,null,null,{"$f":"IF($H$9=0,J26,0)","v":0},{"$f":"IF($H$9<>0,J26,0)","v":0},"Suma",{"$f":"MAX(0,K21*-1)*H34","v":0}]
[null,null,"Neto",{"$f":"+D9-D21-D24","v":2177.464822105263},{"$f":"+E9-E21-E24","v":2177.464822105263},{"$f":"+F9-F21-F24","v":2177.464822105263},{"$f":"+G9-G21-G24+G26","v":2177.464822105263},{"$f":"+H9-H21-H24-H22+H26","v":2042.0076875789471}]
[]
[]
[]
[]
[]
["Bandera",null,null,null,null,null,"Opcion","Auxilar Opción"]
["1)","Activar \"001 Otros Pagos, Reintegro de ISR Retenido en Exceso\"",null,null,null,null,{"$f":"+Instrucciones!F17","v":"No"},{"$f":"IF(G34=\"Si\",1,0)","v":0},null,{"$f":"IF(G34=\"si\",1,0)","v":0}]
["2)","Retener ISR aunque el trabajador gane el minimo",null,null,null,null,"No",{"$f":"IF(G35=\"Si\",1,0)","v":0}]
["3)","Monto de Subisdio a pagar máximo en meses de 4 semanas (536.21 o por Días del Periodo)",null,null,null,null,"Dias del periodo",{"$f":"IF(G36=SubMens,SubMens,MIN(SUM(D4:H4)*SubDiario,SubMens))","v":536.21}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F20","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de más de 4 semanas en el mes, topar a (536.21 o 35 días de Subsidio)",null,null,null,null,536.21,{"$f":"IF(G39=SubMens,SubMens,SubDiario*35)","v":536.21}]

{"sheet":"TARIFAS","index":18,"n_rows":118,"n_cols":22,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,8601.51,null,null,null,null,{"$f":"G10","v":14644.65},null,null,null,null,null,"Semanal",null,2978.65,null,null,null,null,5514.76]
[null,"ISROrigenMes",null,{"$f":"D3/I3","v":0.58734828077147627},null,null,"TablaMes",null,1,null,"Auxiliar Para Quintos Limites",null,null,null,"TablaPer",null,0.23026315789473684,null,null,"TablaQ",null,0.49342144614538019]
[null,"LIMITE INFERIOR","CUOTA FIJA","% EXCEDENTE",null,null,"LIMITE INFERIOR","CUOTA FIJA","% EXCEDENTE",null,null,"Quinto Limite Tabla",null,null,"LIMITE INFERIOR","CUOTA FIJA","% EXCEDENTE",null,null,"LIMITE INFERIOR","CUOTA FIJA","% EXCEDENTE"]
[1,{"$f":"G6*$D$4","v":0},{"$f":"H6*$D$4","v":0},1.9199999999999998E-2,null,1,0,0,1.9199999999999998E-2,null,"Mensual",12935.83,null,1,0,0,1.9199999999999998E-2,null,1,0.01,0,1.9199999999999998E-2]
[2,{"$f":"G7*$D$4","v":496.07435793958888},{"$f":"H7*$D$4","v":9.5267891141133436},6.4000000000000001E-2,null,2,844.6,16.22,6.4000000000000001E-2,null,"Quincenal",6382.81,null,2,171.79,3.29,6.4000000000000001E-2,null,2,368.11,7.05,6.4000000000000001E-2]
[3,4210.4178976759431,247.24425879075292,0.10880000000000001,null,3,7168.52,420.95,0.10880000000000001,null,"Decenal",4255.21,null,3,1458.04,85.61,0.10880000000000001,null,3,3124.36,183.45,0.10880000000000001]
[4,{"$f":"G9*$D$4","v":7399.4312616074812},594.20850869088713,0.16,null,4,12598.03,1011.68,0.16,null,"Semanal",2978.65,null,4,2562.36,205.8,0.16,null,4,5490.76,441,0.16]
[5,8601.51,786.54157671231485,0.17920000000000003,null,5,14644.65,1339.14,0.17920000000000003,null,30.4,12935.83,null,5,2978.65,272.37,0.17920000000000003,null,5,6382.81,583.65,0.17920000000000003]
[6,10298.359183148796,1090.6117816677079,0.21359999999999998,null,6,17533.650000000001,1856.84,0.21359999999999998,null,null,null,null,6,3566.23,377.65,0.21359999999999998,null,6,7641.91,809.25,0.21359999999999998]
[7,20770.303277196788,3327.4219862953364,0.23519999999999999,null,7,35362.839999999997,5665.16,0.23519999999999999,null,null,null,null,7,7192.65,1152.27,0.23519999999999999,null,7,15412.81,2469.15,0.23519999999999999]
[8,32736.849047392734,6141.9538333725968,0.3,null,8,{"$f":"55736.69","v":55736.69},10457.09,0.3,null,null,null,null,8,11336.58,2126.9499999999998,0.3,null,8,24292.66,4557.75,0.3]
[9,62500.030104515979,15070.904626419886,0.32,null,9,106410.51,25659.23,0.32,null,null,null,null,9,21643.31,5218.92,0.32,null,9,46378.51,11183.4,0.32]
[10,83333.367599205172,21737.577793385299,0.34,null,10,141880.67000000001,37009.69,0.34,null,null,null,null,10,28857.79,7527.59,0.34,null,10,61838.11,16130.55,0.34]
[11,250000.0969241327,78404.264471694449,0.35,null,11,425642,133488.54,0.35,null,null,null,null,11,86573.35,27150.83,0.35,null,11,185514.31,58180.35,0.35]
[]
[]
[]
[null,null,null,null,null,null,"Anual"]
[null,"Anterior",null,null,null,null,"Limite Inferior","Cuota Fija","%"]
["UMADiaria",113.14,null,null,null,1,0,0,1.9199999999999998E-2]
["SubsidioPorc",{"$f":"B24/B22","v":0.1558996538987561},null,null,null,2,10135.120000000001,194.59,6.4000000000000001E-2]
["SubDiario",{"$f":"B25/30.4","v":17.638486842105266},null,null,null,3,86022.12,5051.37,0.10880000000000001]
["SubMens",536.21,null,null,null,4,151176.20000000001,12140.13,0.16]
["LimiteMensSub",11492.66,null,null,null,5,175735.67,16069.64,0.17920000000000003]
["LimiteDiarioSub",{"$f":"B26/30.4","v":378.04802631578951},null,null,null,6,210403.7,22282.14,0.21359999999999998]
["LimiteSemSub",{"$f":"B27*7","v":2646.3361842105264},null,null,null,7,424353.98,67981.919999999998,0.23519999999999999]
["SubSem",{"$f":"B24*7","v":123.46940789473686},null,null,null,8,668840.15,125485.07,0.3]
["SMGMes",{"$f":"B31*30.4","v":9577.2160000000003},null,null,null,9,1276925.99,307910.81,0.32]
["SMGC",315.04000000000002,null,null,null,10,1702567.98,444116.23,0.34]
[null,null,null,null,null,11,5107703.93,1601862.46,0.35]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bandera si/no"]
["Si"]
["No"]
[]
[]
["Bandera3"]
[{"$f":"B25","v":536.21}]
["Dias del periodo"]
[]
[]
["Bandera4"]
[{"$f":"B25","v":536.21}]
["35 dias de Subsidio"]
[]
[]
[]
[]
[]
[]
[]
[null,"Anterior","Nuevo (Ene 2025)","Feb a Dic 2025"]
["UMADiaria",108.57,108.57,113.14,"UMADiaria",108.57,null,null,108.57,null,108.57,108.57]
["SubsidioPorc",0.1439,0.1439,0.13800000000000001,"SubsidioPorc",0.1182,null,null,30.4,null,30.4,30.4]
["SubDiario",15.62,15.623222999999999,{"$f":"D70*D71","v":15.613320000000002},"SubDiario",12.83,89.81,null,{"$f":"I70*I71","v":3300.5279999999998},null,{"$f":"K70*K71","v":3300.5279999999998},{"$f":"L70*L71","v":3300.5279999999998}]
["SubMens",475,475,475,"SubMens",390.03199999999998,null,null,0.1182,null,0.13800000000000001,0.1439]
["LimiteMensSub",10171,10171,10171,"LimiteMensSub",9081,null,null,{"$f":"I72*I73","v":390.12240959999997},"Mensual",{"$f":"K72*K73","v":455.47286400000002},{"$f":"L72*L73","v":474.94597919999995}]
["LimiteDiarioSub",334.57236842105266,334.57236842105266,334.57236842105266,"LimiteDiarioSub",298.71710526315792]
["LimiteSemSub",2342.0065789473688,2342.0065789473688,2342.0065789473688,"LimiteSemSub",2091.0197368421054]
["SubSem",{"$f":"B73/30.4*7","v":109.375},{"$f":"C73/30.4*7","v":109.375},{"$f":"D73/30.4*7","v":109.375},"SubSem",89.81]
["SMGMes",8452,8475.52,8475.52,"SMGMes",7567.4719999999998]
["SMGC",278.8,278.8,278.8,"SMGC",248.93,null,null,9081]
[]
[null,419.88]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[475]

{"sheet":"Hoja1","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Hoja3","index":20,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Hoja4","index":21,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Parametros","index":22,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[[6,1,6,8],[8,2,8,4],[9,2,9,4],[10,2,10,4]]}
[]
[]
[null,"Salario Mínimo Zona Frontera",176.72,"SMZF"]
[null,"Salarios Mínimo ",102.68,"SM"]
[]
[]
[null,"ISR Retenido de ejercicio anterior: Es el ISR que le debe retener el patrón al trabajador por el ajuste en el cálculo anual del trabajador correspondiente al ejercicio anterior de acuerdo a lo que establece el artículo 97, cuarto párrafo de la Ley del ISR."]
[]
["OP","007","ISR ajustado por subsidio",null,null,"Genera Flujo Postivo","Nuevo"]
["Op","001","Reintegro de ISR pagado en exceso (siempre que no haya sido enterado al SAT).",null,null,"2017-01-01"]
["OP","002","Subsidio para el empleo (efectivamente entregado al trabajador).",null,null,"2017-01-01"]