{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["GraficarPuntos","Opciones Nomina","Hoja2","Instrucciones","Anual25","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":47,"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":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
["Instrucciones:"]
[]
["Para hacer simulación de sueldos y el cálculo anual, recomeindo que solo modifiques las celdas en amarillo."]
[]
["Existen 4 banderas, están seleccionadas de la forma mas 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 (475 o por Días del Periodo)",null,null,null,null,475,475]
["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 (475 o 35 días de Subsidio)",null,null,null,null,475,475]
[]
[]
[]
[]
["Autores"]
["Benito Brragán Rangel"]
["María Susana Hernández Valenzuela"]
["Edwin Alejandro Frias Berumen"]
["José Luis Aldana Díaz"]

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

{"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,9758,0,0,0,475,0,0,{"$f":"+D5+E5+F5","v":0},{"$f":"+G5-H5","v":475}]
[2,28,7806.4000000000005,0,0,0,475,0,0,{"$f":"+D6+E6+F6","v":0},{"$f":"+G6-H6","v":475}]
[3,28,7806.4000000000005,0,0,0,475,0,0,0,475]
[4,28,7806.4000000000005,0,0,0,475,0,0,0,475]
[5,35,9758,0,0,0,475,0,0,0,475]
[6,28,7806.4000000000005,0,0,0,475,0,0,0,475]
[7,35,9758,0,0,0,475,0,0,0,475]
[8,28,7806.4000000000005,0,0,0,475,0,0,0,475]
[9,28,7806.4000000000005,0,0,0,475,0,0,0,475]
[10,35,9758,0,0,0,475,0,0,0,475]
[11,28,7806.4000000000005,0,0,0,475,0,0,0,475]
[12,28,7806.4000000000005,0,0,0,475,0,0,0,475]
[]
["Total",{"$f":"SUM(B5:B16)","v":364},{"$f":"SUM(C5:C16)","v":101483.19999999998},{"$f":"SUM(D5:D16)","v":0},0,{"$f":"SUM(F5:F16)","v":0},5700,0,0,0,5700]

{"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":9758},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",278.8,{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,{"$f":"G6","v":278.8}]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":1951.6000000000001},{"$f":"SUM(D7:H7)","v":9758}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":1951.6000000000001},{"$f":"SUM(D9:H9)","v":9758},{"$f":"I9","v":9758},{"$f":"+I9","v":9758}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":9758}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":8475.52}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":605.03844800000002}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":109.38}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":437.52},{"$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":475}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":139.31806368421053},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":744.57227199999988},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":37.480000000000018},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":37.480000000000018},{"$f":"SUM(D19:H19)","v":475},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":475}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":437.52},{"$f":"H19+G20","v":475}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":269.57227199999988},{"$f":"J21-I21","v":269.57227199999988}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":1951.6000000000001}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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!F15","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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":7806.4000000000005},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",278.8,{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":7806.4000000000005}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":7806.4000000000005},{"$f":"I9","v":7806.4000000000005},{"$f":"+I9","v":7806.4000000000005}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":7806.4000000000005}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$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":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$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":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":475},{"$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":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":532.23819200000003},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":146.86000000000001},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":0},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":139.31806368421053},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":467.45806368421052},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":467.45806368421052}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":467.45806368421052},{"$f":"H19+G20","v":467.45806368421052}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":64.780128315789511},{"$f":"J21-I21","v":64.780128315789511}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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!F15","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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":7806.4000000000005},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",{"$f":"+'M-01'!D6","v":278.8},{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":7806.4000000000005}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":7806.4000000000005},{"$f":"I9","v":7806.4000000000005},{"$f":"+I9","v":7806.4000000000005}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":7806.4000000000005}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$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":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$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":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":475},{"$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":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":532.23819200000003},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":146.86000000000001},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":0},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":139.31806368421053},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":467.45806368421052},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":467.45806368421052}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":467.45806368421052},{"$f":"H19+G20","v":467.45806368421052}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":64.780128315789511},{"$f":"J21-I21","v":64.780128315789511}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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 (475 o por Días del Periodo)",null,null,null,null,475,{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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":7806.4000000000005},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",{"$f":"+'M-01'!D6","v":278.8},{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":7806.4000000000005}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":7806.4000000000005},{"$f":"I9","v":7806.4000000000005},{"$f":"+I9","v":7806.4000000000005}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":7806.4000000000005}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$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":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$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":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":475},{"$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":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":532.23819200000003},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":146.86000000000001},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":0},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":139.31806368421053},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":467.45806368421052},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":467.45806368421052}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":467.45806368421052},{"$f":"H19+G20","v":467.45806368421052}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":64.780128315789511},{"$f":"J21-I21","v":64.780128315789511}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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!F15","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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":9758},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",278.8,{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":1951.6000000000001},{"$f":"SUM(D7:H7)","v":9758}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":1951.6000000000001},{"$f":"SUM(D9:H9)","v":9758},{"$f":"I9","v":9758},{"$f":"+I9","v":9758}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":9758}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":8475.52}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":605.03844800000002}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":109.38}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":437.52},{"$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":475}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":139.31806368421053},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":744.57227199999988},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":37.480000000000018},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":37.480000000000018},{"$f":"SUM(D19:H19)","v":475},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":475}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":437.52},{"$f":"H19+G20","v":475}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":269.57227199999988},{"$f":"J21-I21","v":269.57227199999988}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":1951.6000000000001}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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":7806.4000000000005},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",{"$f":"+'M-01'!D6","v":278.8},{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":7806.4000000000005}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":7806.4000000000005},{"$f":"I9","v":7806.4000000000005},{"$f":"+I9","v":7806.4000000000005}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":7806.4000000000005}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$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":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$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":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":475},{"$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":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":532.23819200000003},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":146.86000000000001},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":0},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":139.31806368421053},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":467.45806368421052},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":467.45806368421052}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":467.45806368421052},{"$f":"H19+G20","v":467.45806368421052}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":64.780128315789511},{"$f":"J21-I21","v":64.780128315789511}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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!F15","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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":9758},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",{"$f":"+'M-01'!D6","v":278.8},{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":1951.6000000000001},{"$f":"SUM(D7:H7)","v":9758}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":1951.6000000000001},{"$f":"SUM(D9:H9)","v":9758},{"$f":"I9","v":9758},{"$f":"+I9","v":9758}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":9758}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":8475.52}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":605.03844800000002}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":109.38}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":437.52},{"$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":475}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":139.31806368421053},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":744.57227199999988},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":37.480000000000018},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":37.480000000000018},{"$f":"SUM(D19:H19)","v":475},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":475}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":437.52},{"$f":"H19+G20","v":475}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":269.57227199999988},{"$f":"J21-I21","v":269.57227199999988}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":1951.6000000000001}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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!F15","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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":7806.4000000000005},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",{"$f":"+'M-01'!D6","v":278.8},{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":7806.4000000000005}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":7806.4000000000005},{"$f":"I9","v":7806.4000000000005},{"$f":"+I9","v":7806.4000000000005}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":7806.4000000000005}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$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":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$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":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":475},{"$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":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":532.23819200000003},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":146.86000000000001},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":0},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":139.31806368421053},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":467.45806368421052},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":467.45806368421052}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":467.45806368421052},{"$f":"H19+G20","v":467.45806368421052}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":64.780128315789511},{"$f":"J21-I21","v":64.780128315789511}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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!F15","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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,null,{"$f":"SUM(D4:H4)","v":28},null,null,null,9,{"$f":"+I4","v":28},{"$f":"+I9","v":7806.4000000000005},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",{"$f":"+'M-01'!D6","v":278.8},{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":7806.4000000000005}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":7806.4000000000005},{"$f":"I9","v":7806.4000000000005},{"$f":"+I9","v":7806.4000000000005}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":7806.4000000000005}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$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":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$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":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":437.52},{"$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":475}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":532.23819200000003},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":37.480000000000018},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":437.52},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":437.52}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":437.52},{"$f":"H19+G20","v":437.52}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":94.718192000000045},{"$f":"J21-I21","v":94.718192000000045}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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!F15","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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":9758},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7,7]
[null,null,"Salario Diario",{"$f":"+'M-01'!D6","v":278.8},{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":1951.6000000000001},{"$f":"SUM(D7:H7)","v":9758}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":1951.6000000000001},{"$f":"SUM(D9:H9)","v":9758},{"$f":"I9","v":9758},{"$f":"+I9","v":9758}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":9758}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$f":"IF(H4=0,0,IF(H9=0,0,H9/H11*30.4))","v":8475.52}]
[null,"Ocultos","ISR directo elevado al mes",{"$f":"((D12-VLOOKUP(D12,TablaMes,1))*VLOOKUP(D12,TablaMes,3))+VLOOKUP(D12,TablaMes,2)","v":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$f":"((H12-VLOOKUP(H12,TablaMes,1))*VLOOKUP(H12,TablaMes,3))+VLOOKUP(H12,TablaMes,2)","v":605.03844800000002}]
[null,"Ocultos","Subsidio semanal dato oculto relacionado",{"$f":"IF(D4=0,0,SubSem)","v":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":109.38}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":437.52},{"$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":475}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":139.31806368421053},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":744.57227199999988},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":37.480000000000018},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":37.480000000000018},{"$f":"SUM(D19:H19)","v":475},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":475}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":437.52},{"$f":"H19+G20","v":475}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":269.57227199999988},{"$f":"J21-I21","v":269.57227199999988}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":1951.6000000000001}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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!F15","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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,null,{"$f":"SUM(D4:H4)","v":28},null,null,null,11,{"$f":"+I4","v":28},{"$f":"+I9","v":7806.4000000000005},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",{"$f":"+'M-01'!D6","v":278.8},{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":7806.4000000000005}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":7806.4000000000005},{"$f":"I9","v":7806.4000000000005},{"$f":"+I9","v":7806.4000000000005}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":7806.4000000000005}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$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":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$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":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":437.52},{"$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":475}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":532.23819200000003},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":37.480000000000018},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":437.52},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":437.52}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":437.52},{"$f":"H19+G20","v":437.52}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":94.718192000000045},{"$f":"J21-I21","v":94.718192000000045}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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!F15","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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,null,{"$f":"SUM(D4:H4)","v":28},null,null,null,12,{"$f":"+I4","v":28},{"$f":"+I9","v":7806.4000000000005},{"$f":"SUM(D21:H21)","v":0},{"$f":"+H22","v":0},{"$f":"+J24","v":0},{"$f":"+I18","v":475},{"$f":"+J25","v":0},{"$f":"+J26","v":0},{"$f":"+P4+Q4+R4","v":0},{"$f":"+S4-T4","v":475}]
[null,null,"Dias Pagados",7,7,7,7]
[null,null,"Salario Diario",{"$f":"+'M-01'!D6","v":278.8},{"$f":"+D6","v":278.8},{"$f":"+E6","v":278.8},278.8,278.8]
[null,null,"Ingreso Ordinario",{"$f":"D5*D6","v":1951.6000000000001},{"$f":"E5*E6","v":1951.6000000000001},{"$f":"F5*F6","v":1951.6000000000001},{"$f":"G5*G6","v":1951.6000000000001},{"$f":"H5*H6","v":0},{"$f":"SUM(D7:H7)","v":7806.4000000000005}]
["Varias","Percepción","Ingreso ExtraOrdinario"]
["Varias","Percepción","Ingreso Gravado Acumulable",{"$f":"+D8+D7","v":1951.6000000000001},{"$f":"+E8+E7","v":1951.6000000000001},{"$f":"+F8+F7","v":1951.6000000000001},{"$f":"+G8+G7","v":1951.6000000000001},{"$f":"+H8+H7","v":0},{"$f":"SUM(D9:H9)","v":7806.4000000000005},{"$f":"I9","v":7806.4000000000005},{"$f":"+I9","v":7806.4000000000005}]
[null,"Ocultos","Oculto Acumulado para 8,091",{"$f":"+D9","v":1951.6000000000001},{"$f":"+D10+E9","v":3903.2000000000003},{"$f":"+E10+F9","v":5854.8},{"$f":"+F10+G9","v":7806.4000000000005},{"$f":"+G10+H9","v":7806.4000000000005}]
[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":8475.52},{"$f":"IF(E9=0,0,E9/E11*30.4)","v":8475.52},{"$f":"IF(F9=0,0,F9/F11*30.4)","v":8475.52},{"$f":"IF(G9=0,0,G9/G11*30.4)","v":8475.52},{"$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":605.03844800000002},{"$f":"((E12-VLOOKUP(E12,TablaMes,1))*VLOOKUP(E12,TablaMes,3))+VLOOKUP(E12,TablaMes,2)","v":605.03844800000002},{"$f":"((F12-VLOOKUP(F12,TablaMes,1))*VLOOKUP(F12,TablaMes,3))+VLOOKUP(F12,TablaMes,2)","v":605.03844800000002},{"$f":"((G12-VLOOKUP(G12,TablaMes,1))*VLOOKUP(G12,TablaMes,3))+VLOOKUP(G12,TablaMes,2)","v":605.03844800000002},{"$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":109.38},{"$f":"IF(E4=0,0,SubSem)","v":109.38},{"$f":"IF(F4=0,0,SubSem)","v":109.38},{"$f":"IF(G4=0,0,SubSem)","v":109.38},{"$f":"IF(H4=0,0,SubSem)","v":0}]
[null,"Ocultos","Oculto Para llegar a los 390",{"$f":"+D14","v":109.38},{"$f":"IF(E4=0,0,MIN(+D15+E14,$H$36))","v":218.76},{"$f":"IF(F4=0,0,MIN(+E15+F14,$H$36))","v":328.14},{"$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":437.52},{"$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":475}]
[null,"Ocultos","Limite para Subsidio Semanal",{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688},{"$f":"LimiteSemSub","v":2342.0065789473688}]
[null,null,"ISR de Tarifa",{"$f":"D13/30.4*D11","v":139.31806368421053},{"$f":"E13/30.4*E11","v":139.31806368421053},{"$f":"F13/30.4*F11","v":139.31806368421053},{"$f":"G13/30.4*G11","v":139.31806368421053},{"$f":"H13/30.4*H11","v":0},null,{"$f":"((J9-VLOOKUP(J9,TablaMes,1))*VLOOKUP(J9,TablaMes,3))+VLOOKUP(J9,TablaMes,2)","v":532.23819200000003},"Informativo"]
[null,null,"Subsidio Correspondiente del Periodo",{"$f":"IF(OR(D10>LimiteMensSub,D9>D16),0,MAX(+D15,0))","v":109.38},{"$f":"IF(OR(E10>LimiteMensSub,E9>E16),0,MAX(+E15-D15,0))","v":109.38},{"$f":"IF(OR(F10>LimiteMensSub,F9>F16),0,MAX(+F15-E15,0))","v":109.38},{"$f":"IF(OR(G10>LimiteMensSub,G9>G16),0,MAX(+G15-F15,0))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MAX(+H15-G15,0))","v":37.480000000000018},{"$f":"SUM(D18:H18)","v":475},{"$f":"IF(OR(I9>10171,I18>H39),0,I18)","v":475}]
[null,null,"Subsidio definitivo",{"$f":"MIN(D18,D17)","v":109.38},{"$f":"MIN(E18,E17)","v":109.38},{"$f":"MIN(F18,F17)","v":109.38},{"$f":"IF(G3=B1,IF(OR(G10>LimiteMensSub,G9>G16),0,MIN(MAX(G15-F20,0),G17)),MIN(G18,G17))","v":109.38},{"$f":"IF(OR(H10>LimiteMensSub,H9>H16),0,MIN(MAX(H15-G20,0),H17))","v":0},{"$f":"SUM(D19:H19)","v":437.52},{"$f":"IF(OR(I9>10171,I19>H39),0,I19)","v":437.52}]
[null,null,"Subsidio acumulado",{"$f":"D19","v":109.38},{"$f":"E19+D20","v":218.76},{"$f":"F19+E20","v":328.14},{"$f":"G19+F20","v":437.52},{"$f":"H19+G20","v":437.52}]
["002","Deducción","ISR Retención Semanal",{"$f":"IF(SMGC*7>=D9,(MAX(D17-D18,0)*$H$35),MAX(D17-D18,0))","v":0},{"$f":"IF(SMGC*7>=E9,(MAX(E17-E18,0)*$H$35),MAX(E17-E18,0))","v":0},{"$f":"IF(SMGC*7>=F9,(MAX(F17-F18,0)*$H$35),MAX(F17-F18,0))","v":0},{"$f":"IF(SMGC*7>=G9,(MAX(G17-G18,0)*$H$35),MAX(G17-G18,0))","v":0},{"$f":"IF(SMGC*7>=H9,(MAX(H17-H18,0)*$H$35),MAX(H17-H18,0))","v":0},{"$f":"SUM(D21:H21)+H24","v":0},{"$f":"MAX(0,J17-J19)","v":94.718192000000045},{"$f":"J21-I21","v":94.718192000000045}]
["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":1951.6000000000001},{"$f":"+E9-E21-E24","v":1951.6000000000001},{"$f":"+F9-F21-F24","v":1951.6000000000001},{"$f":"+G9-G21-G24","v":1951.6000000000001},{"$f":"+H9-H21-H24-H22","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H9=0,0,IF(I9>SMGC*I4,MAX(K21,0)*H37,(MAX(K21,0)*H37)*H35))","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!F15","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 (475 o por Días del Periodo)",null,null,null,null,{"$f":"+Instrucciones!F17","v":475},{"$f":"IF(G36=475,475,MIN(SUM(D4:H4)*15.62,475))","v":475}]
["4)","Retener ISR de menos en el ajuste mensual (periodos de 5 semanas)",null,null,null,null,{"$f":"+Instrucciones!F18","v":"Si"},{"$f":"IF(G37=\"Si\",1,0)","v":1}]
[]
["5)","En periodos de mas de 4 semanas, topar a (475 o 35 días de Subsidio)",null,null,null,null,{"$f":"+Instrucciones!F20","v":475},{"$f":"IF(G39=475,475,546.7)","v":475}]

{"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":12935.83},null,null,null,null,null,"Semanal",null,2978.65,null,null,null,null,5514.76]
[null,"ISROrigenMes",null,{"$f":"D3/I3","v":0.66493684595422176},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.07613392414709},{"$f":"H7*$D$4","v":9.5218956340644549},6.4000000000000001E-2,null,2,746.05,14.32,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.4200047928898,247.24346743115825,0.10880000000000001,null,3,6332.06,371.83,0.10880000000000001,null,"Decenal",4255.21,null,3,1458.04,85.61,0.10880000000000001,null,3,3124.36,183.45,0.10880000000000001]
[4,7399.4305205154988,594.20751365007118,0.16,null,4,11128.02,893.63,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.5404963423299,0.17920000000000003,null,5,12935.83,1182.8800000000001,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.355687822119,1090.6161159971955,0.21359999999999998,null,6,15487.72,1640.18,0.21359999999999998,null,null,null,null,6,3566.23,377.65,0.21359999999999998,null,6,7641.91,809.25,0.21359999999999998]
[7,20770.299788649048,3327.42376957644,0.23519999999999999,null,7,31236.5,5004.12,0.23519999999999999,null,null,null,null,7,7192.65,1152.27,0.23519999999999999,null,7,15412.81,2469.15,0.23519999999999999]
[8,32736.84238623266,6141.9485030260912,0.3,null,8,49233.01,9236.89,0.3,null,null,null,null,8,11336.58,2126.9499999999998,0.3,null,8,24292.66,4557.75,0.3]
[9,62500.014054304986,15070.906652816248,0.32,null,9,93993.91,22665.17,0.32,null,null,null,null,9,21643.31,5218.92,0.32,null,9,46378.51,11183.4,0.32]
[10,83333.349855950495,21737.570119721735,0.34,null,10,125325.21,32691.18,0.34,null,null,null,null,10,28857.79,7527.59,0.34,null,10,61838.11,16130.55,0.34]
[11,250000.042918483,78404.246159944902,0.35,null,11,375975.62,117912.32000000001,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",108.57,null,null,null,1,0,0,1.9199999999999998E-2]
["SubsidioPorc",0.1439,null,null,null,2,8952.5,171.88,6.4000000000000001E-2,null,null,null,113.22]
["SubDiario",{"$f":"B22*B23","v":15.623222999999999},null,null,null,3,75984.56,4461.9399999999996,0.10880000000000001]
["SubMens",475,null,null,null,4,133536.07999999999,10723.55,0.16]
["LimiteMensSub",10171,null,null,null,5,155229.81,14194.54,0.17920000000000003]
["LimiteDiarioSub",{"$f":"B26/30.4","v":334.57236842105266},null,null,null,6,185852.58,19682.13,0.21359999999999998]
["LimiteSemSub",{"$f":"B27*7","v":2342.0065789473688},null,null,null,7,374837.89,60049.4,0.23519999999999999]
["SubSem",109.38,null,null,null,8,590796,110842.74,0.3]
["SMGMes",8452,null,null,null,9,1127926.8500000001,271981.99,0.32]
["SMGC",278.8,null,null,null,10,1503902.47,392294.17,0.34]
[null,null,null,null,null,11,4511707.38,1414947.85,0.35]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bandera si/no"]
["Si"]
["No"]
[]
[]
["Bandera3"]
[475]
["Dias de periodo"]
[]
[]
["Bandera4","Bandera5 ??"]
[475]
["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"]