{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["OBJETIVO","ISR","CONTROL","TABLAD","DINAMICA","DINAMICA 1","ANUAL","VALIDA","TARIFA"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":"OBJETIVO","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Neto",500,null,"Control Active X",null,"Control de formulario"]
[]
[null,"Honorario",524.475542813836]
[null,"IVA",{"$f":"C4*0.16","v":83.916086850213759}]
[null,"Ret. ISR",{"$f":"C4*0.1","v":52.447554281383603}]
[null,"Ret. IVA",{"$f":"C4*0.1066667","v":55.9440753826606}]
[null,"Total",{"$f":"C4+C5-C6-C7","v":500.00000000000557}]
[]
[null,"Comando de VBA"]
[null,"Range(\"C8\").GoalSeek Goal:=Range(\"C2\"), ChangingCell:=Range(\"C4\")"]

{"sheet":"ISR","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Ingreso del periodo",10000,"Nombre","Tipo"]
[null,"(-) Límite inferior",7168.52,"VLIMITE","Single",null,"=BUSCARV(C4,TARIFA!$B$7:$E$17,1)"]
[null,"(=) Excedente del límite inferior",2831.4799999999996]
[null,"(x) % del excedente del límite inferior",10.88,"VPORCE","Single"]
[null,"(=) Impuesto marginal",308.07]
[null,"(+) Cuota fija",420.95,"VCUOTA","Single"]
[null,"(=) ISR causado",729.02]

{"sheet":"CONTROL","index":2,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Folio",1]
[]
[]
[]
[]
[]
[null,"Mes",null,null,null,"Abril",null,"Enero"]
[null,null,null,null,null,null,null,"Febrero"]
[null,null,null,null,null,null,null,"Marzo"]
[null,null,null,null,null,null,null,"Abril"]
[null,null,null,null,null,null,null,"Mayo"]
[null,null,null,null,null,null,null,"Junio"]
[null,null,null,null,null,null,null,"Julio"]
[null,null,null,null,null,null,null,"Agosto"]
[null,null,null,null,null,null,null,"Septiembre"]
[null,null,null,null,null,null,null,"Octubre"]
[null,null,null,null,null,null,null,"Noviembre"]
[null,null,null,null,null,null,null,"Diciembre"]
[]
[]
[]
[]
[null,"Producto",null,null,null,null,"Papas",15]
[null,null,null,null,null,null,"Chocolate",25]
[null,null,null,null,null,null,"Dulces",40]
[null,"Precio",15,null,null,null,"Chicharrón",20]
[]
[]
[]
[]
[]
[]
[]
[null,"Es incorrecto"]

{"sheet":"TABLAD","index":3,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Origen","Referencia","Cargo","Abono"]
[null,"Auxiliar","Ch. 1258 Proveedor X",null,1500]
[null,"Auxiliar","Cobro fact. 147",25000]
[null,"Auxiliar","Tr. 789 pago fact. 20",null,14000]
[null,"Banco","Ch. 1258 Proveedor X",-1500]
[null,"Banco","Cobro fact. 147",null,-25000]
[]
[]
[]
[null,"Origen","Referencia","Importe"]
[null,"Auxiliar","Ch. 1258 Proveedor X",{"$f":"E4*-1","v":-1500}]
[null,"Auxiliar","Cobro fact. 147",{"$f":"D5","v":25000}]
[null,"Auxiliar","Tr. 789 pago fact. 20",{"$f":"E6*-1","v":-14000}]
[null,"Banco","Ch. 1258 Proveedor X",1500]
[null,"Banco","Cobro fact. 147",-25000]

{"sheet":"DINAMICA","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4]]}
[]
[]
[null,"Origen","Valores"]
[null,"Auxiliar",null,"Banco"]
["Referencia","Suma de Cargo","Suma de Abono","Suma de Cargo","Suma de Abono"]
["Ch. 1258 Proveedor X",null,1500,-1500]
["Cobro fact. 147",25000,null,null,-25000]
["Tr. 789 pago fact. 20",null,14000]
["Total general",25000,15500,-1500,-25000]

{"sheet":"DINAMICA 1","index":5,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Suma de Importe","Etiquetas de columna"]
["Etiquetas de fila","Auxiliar","Banco","Total general"]
["Ch. 1258 Proveedor X",-1500,1500,0]
["Cobro fact. 147",25000,-25000,0]
["Tr. 789 pago fact. 20",-14000,null,-14000]
["Total general",9500,-23500,-14000]

{"sheet":"ANUAL","index":6,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[]
[]
[]
[null,null,"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"]
[null,"Ingreso del periodo",10000,8500,12600,10000,5000,10000,18600,10000,12000,7600,14000,10000]
[null,"ISR causado",729.02,565.82000000000005,1012,729.02,282.17,729.02,2084.61,729.02,946.62,467.9,1236,729.02]

{"sheet":"VALIDA","index":7,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Año"]

{"sheet":"TARIFA","index":8,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
[]
[]
[null,"V. Tarifa aplicable durante 2026 para el cálculo de los pagos provisionales mensuales a que se refieren los artículos 96 de la Ley del ISR y 175 de su Reglamento, así como la regla 3.12.2."]
[null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior"]
[null,"$","$","$","%"]
[null,0.01,844.59,0,1.92]
[null,844.6,7168.51,16.22,6.4]
[null,7168.52,12598.02,420.95,10.88]
[null,12598.03,14644.64,1011.68,16]
[null,14644.65,17533.64,1339.14,17.920000000000002]
[null,17533.650000000001,35362.83,1856.84,21.36]
[null,35362.839999999997,55736.68,5665.16,23.52]
[null,55736.69,106410.5,10457.09,30]
[null,106410.51,141880.66,25659.23,32]
[null,141880.67000000001,425641.99,37009.69,34]
[null,425642,"En adelante",133488.54,35]