{"text_format":"3","workbook":"xlsx","n_sheets":16,"sheets":["Hoja1","Nomina empleados","Calculo -ISR","ISR","Calculadora ISR- DGII","NOMINA-TSS","Horas extras","HORAS EXTRAS-1 Q","Vacaciones","Regalia pascual","Bonificacion","REGISTRO CONTABLE NOMINA","IR4","IR 3","Plantilla de Autodeterminación","Plantilla de Bonificación"],"not_rendered":{"images":19,"external_links":4,"defined_names":3,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"Hoja1","index":0,"n_rows":21,"n_cols":18,"rows_kept":21,"hidden":true,"merged":[[4,0,4,3],[4,4,4,15],[4,16,4,17],[5,4,5,6],[5,8,5,9],[15,1,15,2]]}
[]
[]
[]
[]
["GENERALIDADES",{"$nulls":3},"DEDUCCIONES"]
[{"$nulls":4},"Aporte empleados",{"$nulls":3},"Aporte empleador",{"$nulls":5},{"v":0.01,"d":"$0.01"}]
["Nombres ","Cargo","cedula","Sueldo bruto","SFS  3.04%","Percapita ","AFP  2.87%","Total de deducciones","SFS 7.09%","AFP  7.10%","Total de aportes ","Sueldo bruto mensual","Sueldo bruto anual","ISR","INFOTEP ","TOTAL DEDUCCION","Sueldo neto a cobrar","Costo del trabajador"]
["Perez","Supervisor","402-0000000-1",{"v":75000,"d":"$75,000.00"},{"$f":"+D8*3.04%","v":{"v":2280,"d":"$2,280.00"}},null,{"$f":"+D8*2.87%","v":{"v":2152.5,"d":"$2,152.50"}},{"$f":"+G8+E8","v":{"v":4432.5,"d":"$4,432.50"}},{"$f":"+D8*7.09%","v":{"v":5317.5,"d":"$5,317.50"}},{"$f":"+D8*7.1%","v":{"v":5324.999999999999,"d":"$5,325.00"}},{"$f":"+J8+I8","v":{"v":10642.5,"d":"$10,642.50"}},{"$f":"+D8-H8","v":{"v":70567.5,"d":"$70,567.50"}},{"$f":"+L8*12","v":{"v":846810,"d":"$846,810.00"}},{"$f":"IF(M8>M$21,(M8-M$21)*L$21+N$21,IF(M8>M$20,(M8-M$20)*L$20+N$20,IF(M8>M$19,(M8-M$19)*L$19,0)))/12","v":{"v":6309.349833333334,"d":"$6,309.35"}},{"$f":"D8*O$6","v":750},{"$f":"E8+G8+N8","v":{"v":10741.849833333334,"d":"$10,741.85"}},{"$f":"D8-P8","v":{"v":64258.150166666666,"d":"$64,258.15"}}]
["Lucas","Contador","402-0000000-2",{"v":60000,"d":"$60,000.00"},{"v":1824,"d":"$1,824.00"},null,{"v":1722,"d":"$1,722.00"},{"v":3546,"d":"$3,546.00"},{"v":4254,"d":"$4,254.00"},{"v":4260,"d":"$4,260.00"},{"v":8514,"d":"$8,514.00"},{"v":56454,"d":"$56,454.00"},{"v":677448,"d":"$677,448.00"},{"v":3486.649833333333,"d":"$3,486.65"},{"$f":"D9*O$6","v":600},{"v":7032.649833333333,"d":"$7,032.65"},{"v":52967.35016666667,"d":"$52,967.35"}]
["Martinez","Enpacador","402-0000000-3",{"v":30000,"d":"$30,000.00"},{"v":912,"d":"$912.00"},null,{"v":861,"d":"$861.00"},{"v":1773,"d":"$1,773.00"},{"v":2127,"d":"$2,127.00"},{"v":2130,"d":"$2,130.00"},{"v":4257,"d":"$4,257.00"},{"v":28227,"d":"$28,227.00"},{"v":338724,"d":"$338,724.00"},{"v":0,"d":"$0.00"},300,{"v":1773,"d":"$1,773.00"},{"v":28227,"d":"$28,227.00"}]
["Omar","Encargado RRHH","402-0000000-4",{"v":45000,"d":"$45,000.00"},{"v":1368,"d":"$1,368.00"},null,{"v":1291.5,"d":"$1,291.50"},{"v":2659.5,"d":"$2,659.50"},{"v":3190.5,"d":"$3,190.50"},{"v":3194.9999999999995,"d":"$3,195.00"},{"v":6385.5,"d":"$6,385.50"},{"v":42340.5,"d":"$42,340.50"},{"v":508086,"d":"$508,086.00"},{"v":1148.3248749999998,"d":"$1,148.32"},450,{"v":3807.824875,"d":"$3,807.82"},{"v":41192.175125,"d":"$41,192.18"}]
["Leonel","Auditor","402-0000000-5",{"v":60000,"d":"$60,000.00"},{"v":1824,"d":"$1,824.00"},null,{"v":1722,"d":"$1,722.00"},{"v":3546,"d":"$3,546.00"},{"v":4254,"d":"$4,254.00"},{"v":4260,"d":"$4,260.00"},{"v":8514,"d":"$8,514.00"},{"v":56454,"d":"$56,454.00"},{"v":677448,"d":"$677,448.00"},{"v":3486.649833333333,"d":"$3,486.65"},600,{"v":7032.649833333333,"d":"$7,032.65"},{"v":52967.35016666667,"d":"$52,967.35"}]
["Danilo","Gerente","402-0000000-6",{"v":65000,"d":"$65,000.00"},{"v":1976,"d":"$1,976.00"},null,{"v":1865.5,"d":"$1,865.50"},{"v":3841.5,"d":"$3,841.50"},{"v":4608.5,"d":"$4,608.50"},{"v":4615,"d":"$4,615.00"},{"v":9223.5,"d":"$9,223.50"},{"v":61158.5,"d":"$61,158.50"},{"v":733902,"d":"$733,902.00"},{"v":4427.5498333333335,"d":"$4,427.55"},650,{"v":8269.049833333334,"d":"$8,269.05"},{"v":56730.95016666666,"d":"$56,730.95"}]
["Samuel","Auxiliar ","402-0000000-7",{"v":37000,"d":"$37,000.00"},{"v":1124.8,"d":"$1,124.80"},null,{"v":1061.9,"d":"$1,061.90"},{"v":2186.7,"d":"$2,186.70"},{"v":2623.3,"d":"$2,623.30"},{"v":2626.9999999999995,"d":"$2,627.00"},{"v":5250.299999999999,"d":"$5,250.30"},{"v":34813.3,"d":"$34,813.30"},{"v":417759.60000000003,"d":"$417,759.60"},{"v":19.24487500000032,"d":"$19.24"},370,{"v":2205.944875,"d":"$2,205.94"},{"v":34794.055125,"d":"$34,794.06"}]
["Jorge","Encargado de compras","402-0000000-8",{"v":43000,"d":"$43,000.00"},{"v":1307.2,"d":"$1,307.20"},null,{"v":1234.1,"d":"$1,234.10"},{"v":2541.3,"d":"$2,541.30"},{"v":3048.7000000000003,"d":"$3,048.70"},{"v":3052.9999999999995,"d":"$3,053.00"},{"v":6101.7,"d":"$6,101.70"},{"v":40458.7,"d":"$40,458.70"},{"v":485504.39999999997,"d":"$485,504.40"},{"v":866.0548749999994,"d":"$866.05"},430,{"v":3407.3548749999995,"d":"$3,407.35"},{"v":39592.645125,"d":"$39,592.65"}]
[null,"Totales",null,{"$f":"SUM(D8:D15)","v":{"v":415000,"d":"$415,000.00"}},{"$f":"SUM(E8:E15)","v":{"v":12616,"d":"$12,616.00"}},null,{"$f":"SUM(G8:G15)","v":{"v":11910.5,"d":"$11,910.50"}},{"v":24526.5,"d":"$24,526.50"},{"v":29423.5,"d":"$29,423.50"},{"v":29465,"d":"$29,465.00"},{"v":58888.5,"d":"$58,888.50"},{"v":390473.5,"d":"$390,473.50"},{"v":4685682,"d":"$4,685,682.00"},{"v":19743.82395833333,"d":"$19,743.82"},{"v":4150,"d":"$4,150.00"},{"v":44270.32395833333,"d":"$44,270.32"},{"v":370729.67604166665,"d":"$370,729.68"},{"v":0,"d":"$0.00"}]
[]
[{"$nulls":10},"Escala","porcentaje","monto","monto en mes"]
[{"$nulls":10},"Escala minima",{"v":0.15,"d":"15%"},{"v":416220.01,"d":"416,220.01"},{"$f":"M19/12","v":{"v":34685.00083333333,"d":"$34,685.00"}}]
[{"$nulls":10},"Escala intermedia",{"v":0.2,"d":"20%"},{"v":624329.01,"d":"624,329.01"},{"v":31216,"d":"$31,216.00"}]
[{"$nulls":10},"Escala maxima",{"v":0.25,"d":"25%"},{"v":867123.01,"d":"867,123.01"},{"v":79776,"d":"$79,776.00"}]

{"sheet":"Nomina empleados","index":1,"n_rows":13,"n_cols":17,"rows_kept":13,"merged":[[2,1,2,16],[3,1,3,16],[4,1,4,16],[5,1,5,16],[6,1,6,8],[6,11,6,15],[12,1,12,5],[23,4,23,5]]}
[]
[]
[null,"EMPRESA X"]
[null,"RNC: 132560430"]
[null,"Nomina de Empleados"]
[null,"Del 1 al 15 de JULIO- 2025"]
[{"$nulls":11},"DEDUCCIONES"]
[null,"Nombre","Departamento","Cargo","Cedula","Fecha de Entrada","Salario Mensual","Salario Quincenal","Horas Extras ","Otros Ingresos","Total de Ingresos","SFS (3.04%)","AFP (2.87%)","ISR","Otros Descuentos","Total Deducciones","Total a Pagar"]
[null,"Empleado 1","Ventas","Gerente","001-1361413-5","2024-07-03",{"v":60000,"d":"60,000.00"},{"$f":"+G9/2","v":{"v":30000,"d":"30,000.00"}},null,null,{"$f":"SUM(H9:J9)","v":{"v":30000,"d":"30,000.00"}},{"$f":"H9*3.04%","v":{"v":912,"d":"912.00"}},{"$f":"H9*2.87%","v":{"v":861,"d":"861.00"}},{"$f":"3486.65/2","v":{"v":1743.325,"d":"1,743.33"}},null,{"$f":"SUM(L9:O9)","v":{"v":3516.325,"d":"3,516.33"}},{"$f":"K9-P9","v":{"v":26483.675,"d":"26,483.68"}}]
[null,"Empleado 2","Contabilidad","Auxiliar ","021-0006315-1","2023-10-23",{"v":45000,"d":"45,000.00"},{"$f":"+G10/2","v":{"v":22500,"d":"22,500.00"}},null,null,{"$f":"SUM(H10:J10)","v":{"v":22500,"d":"22,500.00"}},{"$f":"H10*3.04%","v":{"v":684,"d":"684.00"}},{"$f":"H10*2.87%","v":645.75},null,null,{"$f":"SUM(L10:O10)","v":{"v":1329.75,"d":"1,329.75"}},{"$f":"K10-P10","v":{"v":21170.25,"d":"21,170.25"}}]
[null,"Empleado 3","Recursos Humanos","Secretaria","402-0519780-5","2022-05-05",{"v":35000,"d":"35,000.00"},{"$f":"+G11/2","v":{"v":17500,"d":"17,500.00"}},null,null,{"v":17500,"d":"17,500.00"},{"v":532,"d":"532.00"},502.25,null,null,{"v":1034.25,"d":"1,034.25"},{"v":16465.75,"d":"16,465.75"}]
[]
[null,"Totales",{"$nulls":4},{"$f":"SUM(G9:G11)","v":{"v":140000,"d":"140,000.00"}},{"$f":"SUM(H9:H11)","v":{"v":70000,"d":"70,000.00"}},{"$f":"SUM(I9:I11)","v":0},null,{"$f":"SUM(K9:K12)","v":{"v":70000,"d":"70,000.00"}},{"$f":"SUM(L9:L11)","v":{"v":2128,"d":"2,128.00"}},{"$f":"SUM(M9:M11)","v":{"v":2009,"d":"2,009.00"}},{"$f":"SUM(N9:N12)","v":{"v":1743.325,"d":"1,743.33"}},null,{"$f":"SUM(P9:P11)","v":{"v":5880.325,"d":"5,880.33"}},{"$f":"SUM(Q9:Q11)","v":{"v":64119.675,"d":"64,119.68"}}]

{"sheet":"Calculo -ISR","index":2,"n_rows":39,"n_cols":8,"rows_kept":39}
[]
[{"$nulls":6},"MENSUAL"]
[{"$nulls":6},{"v":60000,"d":"60,000.00"},"SALARIO"]
[{"$nulls":6},{"$f":"+G3*5.91%","v":{"v":3546,"d":"3,546.00"}},"TSS (3.04% + 2.87%)"]
[{"$nulls":6},{"$f":"+G3-G4","v":{"v":56454,"d":"56,454.00"}},"Salario Cotizable ISR"]
[{"$nulls":6},{"$f":"56454-52027.43","v":{"v":4426.57,"d":"4,426.57"}},"Excedente según aplique"]
[{"$nulls":6},{"$f":"4426.57*20%","v":{"v":885.314,"d":"885.31"}},"Porcetaje de ISR según aplique"]
[{"$nulls":6},{"v":2601.36,"d":"2,601.36"},"Base imponible DGII"]
[{"$nulls":6},{"$f":"G7+G8","v":{"v":3486.674,"d":"3,486.67"}},"Impuesto sobre la renta a pagar mensual"]
[{"$nulls":6},{"$f":"G9/2","v":{"v":1743.337,"d":"1,743.34"}}]
[]
[]
[{"$nulls":6},"ANUAL"]
[{"$nulls":6},{"$f":"G5*12","v":{"v":677448,"d":"677,448.00"}},"Salario Anual"]
[{"$nulls":6},{"$f":"G14-624329.01","v":{"v":53118.98999999999,"d":"53,118.99"}},"Excedente anual "]
[{"$nulls":6},{"$f":"G15/12","v":{"v":4426.5824999999995,"d":"4,426.58"}},"Excedente mensual"]
[{"$nulls":6},{"$f":"+G16*0.2","v":{"v":885.3164999999999,"d":"885.32"}},"Porcetaje de ISR según aplique"]
[{"$nulls":6},{"v":2601.36,"d":"2,601.36"},"Base imponible DGII"]
[{"$nulls":6},{"$f":"+G17+2601.36","v":{"v":3486.6765,"d":"3,486.68"}},"Impuesto sobre la renta a pagar mensual"]
[]
[]
[]
[]
[]
[]
["Escala","porcentaje","Monto ANUAL","VALOR A SUMAR","BASE ESTABLECIDA DGII"]
["Escala minima",{"v":0.15,"d":"15%"},{"v":416220.01,"d":"416,220.01"},{"v":34685.01,"d":"34,685.01"},{"v":0,"d":"0.00"}]
["Escala media",{"v":0.2,"d":"20%"},{"v":624329.01,"d":"624,329.01"},{"v":52027.43,"d":"52,027.43"},{"v":2601.36,"d":"2,601.36"}]
["Escala maxima",{"v":0.25,"d":"25%"},{"v":867123.01,"d":"867,123.01"},{"v":72260.25,"d":"72,260.25"},{"v":6647.92,"d":"6,647.92"}]
[]
[]
[]
["SALARIO","TSS","SALARIO PARA ISR","TOTAL ISR"]
[{"v":60000,"d":"60,000.00"},{"$f":"A34*5.91%","v":{"v":3546,"d":"3,546.00"}},{"$f":"A34-B34","v":{"v":56454,"d":"56,454.00"}},{"$f":"(C34-D28)*20%+E28","v":{"v":3486.674,"d":"3,486.67"}}]
[{"v":45000,"d":"45,000.00"},{"$f":"A35*5.91%","v":{"v":2659.5,"d":"2,659.50"}},{"$f":"A35-B35","v":{"v":42340.5,"d":"42,340.50"}},{"$f":"(C35-D27)*15%","v":{"v":1148.3234999999997,"d":"1,148.32"}}]
[{"v":50000,"d":"50,000.00"},{"v":2955,"d":"2,955.00"},{"v":47045,"d":"47,045.00"},{"$f":"(C36-D27)*15%","v":{"v":1853.9984999999997,"d":"1,854.00"}}]
[{"v":75000,"d":"75,000.00"},{"v":4432.5,"d":"4,432.50"},{"v":70567.5,"d":"70,567.50"},{"$f":"(C37-D29)*25%+E29","v":{"v":6224.7325,"d":"6,224.73"}}]
[{"v":48500,"d":"48,500.00"},{"v":2866.35,"d":"2,866.35"},{"v":45633.65,"d":"45,633.65"},{"$f":"(C38-D27)*15%","v":{"v":1642.2959999999998,"d":"1,642.30"}}]
[{"$nulls":3},{"$f":"SUM(D34:D38)","v":{"v":14356.0245,"d":"14,356.02"}}]

{"sheet":"ISR","index":3,"n_rows":36,"n_cols":9,"rows_kept":36,"hidden":true}
[]
["Escala","porcentaje","Monto","VALOR A SUMAR"]
["Escala minima",{"v":0.15,"d":"15%"},{"v":416220.01,"d":"416,220.01"},{"v":0,"d":"0.00"},{"$f":"E12-C4","v":{"v":53118.98999999999,"d":"53,118.99"}},{"$f":"+E3*0.2","v":{"v":10623.797999999999,"d":"10,623.80"}},{"$f":"F3/12","v":{"v":885.3164999999999,"d":"885.32"}}]
["Escala media",{"v":0.2,"d":"20%"},{"v":624329.01,"d":"624,329.01"},{"v":31216,"d":"31,216.00"},{"$f":"+E3/12","v":{"v":4426.5824999999995,"d":"4,426.58"}},{"$f":"+E4*0.15","v":{"v":663.9873749999999,"d":"663.99"}},{"$f":"G3+2601.36","v":{"v":3486.6765,"d":"3,486.68"}}]
["Escala maxima",{"v":0.25,"d":"25%"},{"v":867123.01,"d":"867,123.01"},{"v":79776,"d":"79,776.00"}]
[]
[{"$nulls":6}," "]
[null,{"v":0.0304,"d":"3.04%"},{"v":0.0287,"d":"2.87%"},1,2,3,4,5,6]
["Salario bruto","SFS","AFP","Salario Cotizable ISR","salario neto anual","salario neto  anual - monto (EXCEDENTE)","multiplicacion de porcentaje","porcentaje + VALOR A SUMAR","dividir entre 12"]
[]
[{"$f":"+Hoja1!D8","v":{"v":75000,"d":"75,000.00"}},{"$f":"+Hoja1!E8","v":{"v":2280,"d":"2,280.00"}},{"$f":"+Hoja1!G8","v":{"v":2152.5,"d":"2,152.50"}},{"$f":"A11-B11-C11","v":{"v":70567.5,"d":"70,567.50"}},{"$f":"+D11*12","v":{"v":846810,"d":"846,810.00"}},{"$f":"+E11-C4","v":{"v":222480.99,"d":"222,480.99"}},{"$f":"+F11*20%","v":{"v":44496.198000000004,"d":"44,496.20"}},{"$f":"+G11+D4","v":{"v":75712.198,"d":"75,712.20"}},{"$f":"+H11/12","v":{"v":6309.349833333334,"d":"6,309.35"}}]
[{"$f":"+Hoja1!D9","v":{"v":60000,"d":"60,000.00"}},{"$f":"+Hoja1!E9","v":{"v":1824,"d":"1,824.00"}},{"$f":"+Hoja1!G9","v":{"v":1722,"d":"1,722.00"}},{"v":56454,"d":"56,454.00"},{"$f":"+D12*12","v":{"v":677448,"d":"677,448.00"}},{"$f":"+E12-C4","v":{"v":53118.98999999999,"d":"53,118.99"}},{"$f":"+F12*20%","v":{"v":10623.797999999999,"d":"10,623.80"}},{"$f":"+G12+D4","v":{"v":41839.797999999995,"d":"41,839.80"}},{"v":3486.649833333333,"d":"3,486.65"}]
[{"v":85000,"d":"85,000.00"},{"$f":"+A13*3.04%","v":{"v":2584,"d":"2,584.00"}},{"$f":"+A13*2.87%","v":{"v":2439.5,"d":"2,439.50"}},{"v":79976.5,"d":"79,976.50"},{"v":959718,"d":"959,718.00"},{"$f":"+E13-C5","v":{"v":92594.98999999999,"d":"92,594.99"}},{"$f":"+F13*B5","v":{"v":23148.747499999998,"d":"23,148.75"}},{"$f":"+G13+D5","v":{"v":102924.7475,"d":"102,924.75"}},{"v":8577.062291666667,"d":"8,577.06"}]
[{"v":115000,"d":"115,000.00"},{"$f":"+A14*3.04%","v":{"v":3496,"d":"3,496.00"}},{"$f":"+A14*2.87%","v":{"v":3300.5,"d":"3,300.50"}},{"v":108203.5,"d":"108,203.50"},{"v":1298442,"d":"1,298,442.00"},{"$f":"+E14-C5","v":{"v":431318.99,"d":"431,318.99"}},{"$f":"+F14*25%","v":{"v":107829.7475,"d":"107,829.75"}},{"$f":"+G14+D5","v":{"v":187605.7475,"d":"187,605.75"}},{"v":15633.812291666667,"d":"15,633.81"}]
[{"v":150000,"d":"150,000.00"},{"$f":"+A15*3.04%","v":{"v":4560,"d":"4,560.00"}},{"v":4305,"d":"4,305.00"},{"v":141135,"d":"141,135.00"},{"v":1693620,"d":"1,693,620.00"},{"$f":"+E15-C5","v":{"v":826496.99,"d":"826,496.99"}},{"$f":"+F15*B5","v":{"v":206624.2475,"d":"206,624.25"}},{"$f":"+G15+D5","v":{"v":286400.2475,"d":"286,400.25"}},{"v":23866.687291666665,"d":"23,866.69"}]
[{"v":43000,"d":"43,000.00"},{"v":1307.2,"d":"1,307.20"},{"v":1234.1,"d":"1,234.10"},{"v":40458.700000000004,"d":"40,458.70"},{"v":485504.4,"d":"485,504.40"},{"v":62433,"d":"62,433.00"},{"$f":"+F16*15%","v":{"v":9364.949999999999,"d":"9,364.95"}},null,{"$f":"+G16/12","v":{"v":780.4124999999999,"d":"780.41"}}]
[{"$f":"+Hoja1!D14","v":{"v":37000,"d":"37,000.00"}},{"v":1124.8,"d":"1,124.80"},{"v":1061.9,"d":"1,061.90"},{"v":34813.299999999996,"d":"34,813.30"},{"v":417759.6,"d":"417,759.60"},{"$nulls":3},{"$f":"+G17/12","v":{"v":0,"d":"0.00"}}]
[{"$f":"+Hoja1!D15","v":{"v":43000,"d":"43,000.00"}},{"v":1307.2,"d":"1,307.20"},{"v":1234.1,"d":"1,234.10"},{"v":40458.700000000004,"d":"40,458.70"},{"v":485504.4,"d":"485,504.40"}]
[]
[{"$nulls":6},"MENSUAL"]
[{"$nulls":6},{"v":60000,"d":"60,000.00"}]
[null,{"v":13580.91,"d":"13,580.91"},{"$nulls":4},{"$f":"+G21*5.91%","v":{"v":3546,"d":"3,546.00"}}]
[null,{"$f":"+A10+B22","v":{"v":13580.91,"d":"13,580.91"}},{"$nulls":4},{"$f":"+G21-G22","v":{"v":56454,"d":"56,454.00"}}]
[{"$nulls":6},{"$f":"G23-52027.43","v":{"v":4426.57,"d":"4,426.57"}}]
[{"$nulls":6},{"$f":"+G24*0.2","v":{"v":885.314,"d":"885.31"}}]
[{"$nulls":6},{"v":2601.36,"d":"2,601.36"}]
[{"$nulls":6},{"$f":"SUM(G25:G26)","v":{"v":3486.674,"d":"3,486.67"}}]
[]
[]
[]
[{"$nulls":6},"ANUAL"]
[{"$nulls":6},{"$f":"G23*12","v":{"v":677448,"d":"677,448.00"}}]
[{"$nulls":6},{"$f":"G32-624329.01","v":{"v":53118.98999999999,"d":"53,118.99"}},{"$f":"416220/12","v":{"v":34685,"d":"34,685.00"}}]
[{"$nulls":6},{"$f":"G33/12","v":{"v":4426.5824999999995,"d":"4,426.58"}},{"$f":"624329/12","v":{"v":52027.416666666664,"d":"52,027.42"}}]
[{"$nulls":6},{"$f":"+G34*0.2","v":{"v":885.3164999999999,"d":"885.32"}}]
[{"$nulls":6},{"$f":"+G35+2601.36","v":{"v":3486.6765,"d":"3,486.68"}}]

{"sheet":"Calculadora ISR- DGII","index":4,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"NOMINA-TSS","index":5,"n_rows":21,"n_cols":26,"rows_kept":21,"merged":[[0,12,0,13],[1,1,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8],[1,9,3,9],[1,10,1,11],[1,12,3,12],[1,13,3,13],[1,14,3,14],[1,15,3,15],[1,16,3,16],[1,17,1,20],[1,21,1,23],[1,25,3,25],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,20,3,20],[13,0,13,2],[16,17,16,18]]}
[{"$nulls":12},"OTRAS REMUNERACIONES"]
[null,"CEDULA",null,"FECHA DE INGRESO ","NOMBRE ","PUESTO","SUELDO BRUTO","COMSION ","VACACIONES","SALARIO COTIZABLE TSS","DESC TRABAJADOR",null,"BONIFICACION","HORAS EXTRAS","SALARIO COTIZABLE ISR/DGII","SALARIO COTIZABLE ANUAL","ISR COBRADO","INGRESOS EXENTOS ",{"$nulls":3},"APORTE EMPRESA",null,null,"TOTAL","COSTO DEL TRABAJDOR"]
[{"$nulls":10},2.87,3.04,{"$nulls":5},"SUELDO NETO","PRE-AVISO Y CESANTIA","REGALIA PASCUAL","TOTAL A PAGAR",7.1,7.09,1.1,"APORTE TSS"]
[{"$nulls":10},"TOTAL AFP","TOTAL SFS",{"$nulls":9},"TOTAL AFP","TOTAL SFS","SRL"]
[null,1,"031-0109456-4","2014-01-01","ALAN ALBERTO","empleado 1",{"v":90000,"d":"90,000.00 "},null,null,{"$f":"G5+H5+I5","v":{"v":90000,"d":"90,000.00 "}},{"$f":"J5*K$3%","v":{"v":2583,"d":"2,583.00 "}},{"$f":"J5*L$3%","v":{"v":2736,"d":"2,736.00 "}},null,null,{"$f":"J5-K5-L5+M5+N5","v":{"v":84681,"d":"84,681.00 "}},{"$f":"O5*12","v":{"v":1016172,"d":"1,016,172.00 "}},{"$f":"IF(P5>L$16,((P5-L$16)*K$16+M$16)/12,IF(P5>L$15,((P5-L$15)*K$15+M$15)/12,IF(P5>L$14,((P5-L$14)*K$14+0)/12,0)))","v":{"v":9753.187291666667,"d":"$9,753.19"}},{"$f":"O5-Q5","v":{"v":74927.81270833334,"d":"74,927.81 "}},null,null,{"$f":"R5+S5+T5","v":{"v":74927.81270833334,"d":"74,927.81 "}},{"$f":"G5*V$3%","v":{"v":6389.999999999999,"d":"6,390.00 "}},{"$f":"G5*W$3%","v":{"v":6381,"d":"6,381.00 "}},{"$f":"G5*X$3%","v":{"v":990.0000000000001,"d":"990.00 "}},{"$f":"SUM(V5:X5)","v":{"v":13761,"d":"13,761.00 "}},{"$f":"G5+Y5","v":{"v":103761,"d":"103,761.0"}}]
[null,{"$f":"+B5+1","v":2},"031-0109456-5","2019-01-01","RAMON RIJO","empleado 2",{"v":75000,"d":"75,000.00 "},null,null,{"$f":"G6+H6+I6","v":{"v":75000,"d":"75,000.00 "}},{"$f":"J6*K$3%","v":{"v":2152.5,"d":"2,152.50 "}},{"$f":"J6*L$3%","v":{"v":2280,"d":"2,280.00 "}},null,null,{"$f":"J6-K6-L6+M6+N6","v":{"v":70567.5,"d":"70,567.50 "}},{"$f":"O6*12","v":{"v":846810,"d":"846,810.00 "}},{"$f":"IF(P6>L$16,((P6-L$16)*K$16+M$16)/12,IF(P6>L$15,((P6-L$15)*K$15+M$15)/12,IF(P6>L$14,((P6-L$14)*K$14+0)/12,0)))","v":{"v":6309.349833333334,"d":"$6,309.35"}},{"$f":"O6-Q6","v":{"v":64258.150166666666,"d":"64,258.15 "}},null,null,{"$f":"R6+S6+T6","v":{"v":64258.150166666666,"d":"64,258.15 "}},{"$f":"G6*V$3%","v":{"v":5324.999999999999,"d":"5,325.00 "}},{"$f":"G6*W$3%","v":{"v":5317.5,"d":"5,317.50 "}},{"$f":"G6*X$3%","v":{"v":825.0000000000001,"d":"825.00 "}},{"$f":"SUM(V6:X6)","v":{"v":11467.5,"d":"11,467.50 "}},{"$f":"G6+Y6","v":{"v":86467.5,"d":"86,467.5"}}]
[null,{"$f":"+B6+1","v":3},"031-0145456-8","2014-01-01","ALBERTO QUEZADA","empleado 3",{"v":45000,"d":"45,000.00 "},null,null,{"v":45000,"d":"45,000.00 "},{"$f":"J7*K$3%","v":{"v":1291.5,"d":"1,291.50 "}},{"$f":"J7*L$3%","v":{"v":1368,"d":"1,368.00 "}},null,null,{"v":42340.5,"d":"42,340.50 "},{"v":508086,"d":"508,086.00 "},{"v":1148.3248749999998,"d":"$1,148.32"},{"$f":"O7-Q7","v":{"v":41192.175125,"d":"41,192.18 "}},null,null,{"$f":"R7+S7+T7","v":{"v":41192.175125,"d":"41,192.18 "}},{"$f":"G7*V$3%","v":{"v":3194.9999999999995,"d":"3,195.00 "}},{"$f":"G7*W$3%","v":{"v":3190.5,"d":"3,190.50 "}},{"v":495.00000000000006,"d":"495.00 "},{"v":6880.5,"d":"6,880.50 "},{"v":51880.5,"d":"51,880.5"}]
[null,4,"031-0145456-9","2018-01-01","RAMON PEREZ","empleado 4",{"v":65000,"d":"65,000.00 "},null,null,{"$f":"G8+H8+I8","v":{"v":65000,"d":"65,000.00 "}},{"$f":"J8*K$3%","v":{"v":1865.5,"d":"1,865.50 "}},{"$f":"J8*L$3%","v":{"v":1976,"d":"1,976.00 "}},null,null,{"$f":"J8-K8-L8+M8+N8","v":{"v":61158.5,"d":"61,158.50 "}},{"v":733902,"d":"733,902.00 "},{"v":4427.5498333333335,"d":"$4,427.55"},{"$f":"O8-Q8","v":{"v":56730.95016666667,"d":"56,730.95 "}},null,null,{"$f":"R8+S8+T8","v":{"v":56730.95016666667,"d":"56,730.95 "}},{"$f":"G8*V$3%","v":{"v":4615,"d":"4,615.00 "}},{"$f":"G8*W$3%","v":{"v":4608.5,"d":"4,608.50 "}},{"v":715.0000000000001,"d":"715.00 "},{"v":9938.5,"d":"9,938.50 "},{"v":74938.5,"d":"74,938.5"}]
[]
[{"$nulls":6},{"$f":"SUM(G5:G9)","v":{"v":275000,"d":"275,000.00 "}},null,null,{"$f":"SUM(J5:J9)","v":{"v":275000,"d":"275,000.00 "}},{"$f":"SUM(K5:K9)","v":{"v":7892.5,"d":"7,892.50 "}},{"v":8360,"d":"8,360.00 "},null,null,{"$f":"SUM(O5:O9)","v":{"v":258747.5,"d":"258,747.50 "}},{"$f":"SUM(P5:P9)","v":{"v":3104970,"d":"3,104,970.00 "}},{"$f":"SUM(Q5:Q9)","v":{"v":21638.411833333335,"d":"$21,638.41"}},{"$f":"SUM(R5:R9)","v":{"v":237109.08816666668,"d":"237,109.09 "}},null,null,{"$f":"SUM(U5:U9)","v":{"v":237109.08816666668,"d":"237,109.09 "}},{"$f":"SUM(V5:V9)","v":{"v":19525,"d":"19,525.00 "}},{"$f":"SUM(W5:W9)","v":{"v":19497.5,"d":"19,497.50 "}},{"v":3025.0000000000005,"d":"3,025.00 "},{"$f":"SUM(Y5:Y9)","v":{"v":42047.5,"d":"42,047.50 "}},{"$f":"SUM(Z5:Z9)","v":{"v":317047.5,"d":"317,047.5"}}]
[{"$nulls":9},"SUELDO BRUTO + COMISIONES + VACACIONES",{"$nulls":4},"SUELDO TSS-DESCUENTOS + BONIFICACION + HORAS EXTRAS",null,"SALE DE LA ESCALA","SALARIO COTIZABLE - ISR COBRADO",{"$nulls":7},"sueldo bruto  MAS APORTE DE LA EMPRESA"]
[]
[{"$nulls":9},"Escala","porcentaje","monto"]
["TOPE SALARIAL",{"$nulls":8},"Escala minima",{"v":0.15,"d":"15%"},{"v":416220.01,"d":"416,220.01"},{"$nulls":8},"APORTE A INFOTEP"]
["AFP",{"v":312000,"d":"$312,000.00"},{"$f":"B15*K3%","v":{"v":8954.4,"d":"$8,954.40"}},{"$nulls":6},"Escala intermedia",{"v":0.2,"d":"20%"},{"v":624329.01,"d":"624,329.01"},{"v":31216,"d":"$31,216.00"},{"$nulls":7},{"$f":"G10*0.01","v":{"v":2750,"d":"$2,750.00"}}]
["SFS",{"v":156000,"d":"$156,000.00"},{"$f":"B16*L3%","v":{"v":4742.4,"d":"$4,742.40"}},{"$nulls":6},"Escala maxima",{"v":0.25,"d":"25%"},{"v":867123.01,"d":"867,123.01"},{"v":79776,"d":"$79,776.00"}]
[{"$nulls":17},"TSS A PAGAR",null,null,{"$f":"J10*0.01","v":{"v":2750,"d":"2,750.00"}}]
[{"$nulls":9},"ESCALA 1","=((P5-L14)*K14)/12",{"$nulls":6},"EMPLEDOS",{"$f":"K10+L10","v":{"v":16252.5,"d":"16,252.50"}}]
[{"$nulls":9},"ESCALA 2","=((P5-L15)*K15+M15)/12",{"$nulls":6},"EMPLEADOR",{"$f":"+Y10","v":{"v":42047.5,"d":"42,047.50 "}}]
[{"$nulls":9},"ESCALA 3","=((P5-L16)*K16+M16)/12",{"$nulls":6},"PAGO TSS",{"$f":"SUM(S18:S19)","v":{"v":58300,"d":"58,300.00"}}]
[{"$nulls":17},"INFOTEP",{"$f":"+U15","v":{"v":2750,"d":"$2,750.00"}}]

{"sheet":"Horas extras","index":6,"n_rows":21,"n_cols":8,"rows_kept":21,"merged":[[6,1,6,2],[6,5,6,7],[16,1,16,2]]}
[]
[]
[null,"Si es mensual",23.83]
[null,"Si es quincenal",11.91]
[null,"Si es semanal",5.5]
[]
[null,"SUELDO",{"$nulls":3},"CONDICIONES"]
[null,"Sueldo",{"v":25000,"d":"$25,000.00"},null,null,">44 y =68",{"v":0.35,"d":"35%"},"DIURNA"]
[null,"sueldo diario",{"$f":"25000/23.83","v":{"v":1049.0977759127152,"d":"$1,049.10"}},null,null,">44 y <69",{"v":0.15,"d":"15%"},"nocturna"]
[null,"sueldo por hora",{"$f":"C9/8","v":{"v":131.1372219890894,"d":"131.14"}},null,null,">69 Y NO LABORABLE",{"v":1,"d":"100%"}]
[null,"(+)  35%",{"$f":"C10*35%","v":{"v":45.89802769618129,"d":"45.90"}}]
[null,"Total Horas por hora Extras",{"$f":"SUM(C10:C11)","v":{"v":177.03524968527068,"d":"177.04"}}]
[null,{"v":0.15,"d":"15%"},{"$f":"C10*15%","v":{"v":19.670583298363407,"d":"19.67"}}]
[null,"Total Horas por hora Nocturnas",{"$f":"C12+C13","v":{"v":196.70583298363408,"d":"196.71"}}]
[null,{"v":1,"d":"100%"},{"$f":"C10*2","v":{"v":262.2744439781788,"d":"262.27"}}]
[]
[null,"CONDICIONES",null,"HORAS","VALOR DE LAS HORAS","VALOR A PAGAR"]
[null,{"v":0.35,"d":"35%"},"HORAS DIURNAS",10,{"$f":"C10*1.35","v":{"v":177.03524968527068,"d":"177.04"}},{"$f":"D18*E18","v":{"v":1770.3524968527067,"d":"$1,770.35"}}]
[null,{"v":0.15,"d":"15%"},"HORAS NOCTURNAS",10,{"$f":"C14","v":{"v":196.70583298363408,"d":"$196.71"}},{"$f":"(E18+E19)*D19","v":{"v":3737.4108266890476,"d":"$3,737.41"}}]
[null,{"v":1,"d":"100%"},"HORAS al 100%",5,{"$f":"C10*2","v":{"v":262.2744439781788,"d":"$262.27"}},{"$f":"E20*D20","v":{"v":1311.372219890894,"d":"$1,311.37"}}]
[null,null,"TOTAL A PAGAR",null,null,{"$f":"SUM(F18:F20)","v":{"v":6819.135543432649,"d":"$6,819.14"}}]

{"sheet":"HORAS EXTRAS-1 Q","index":7,"n_rows":9,"n_cols":14,"rows_kept":9}
[]
["Nombres","Sueldos","Diario ","Salario por Hora","Precio Horas Extras 35%","Precio Horas Extras 100%","Precio Horas Nocturnas","Horas Extras Trabajadas (35%)","Horas Extras Nocturnas (35+15%)","Horas Extras Trabajadas (100%)","A PAGAR HORAS AL 35%","A PAGAR HORAS AL 100%","A PAGAR HORAS NOCTURNAS","TOTAL NETO A PAGAR"]
["EMPLEADO",{"$f":"+'[4]1era Quincena'!F13","v":{"v":28000,"d":"28,000.00"}},{"$f":"B3/23.83","v":{"v":1174.989509022241,"d":"1,174.99"}},{"$f":"(B3/23.83)/8","v":{"v":146.87368862778013,"d":"146.87"}},{"$f":"D3*1.35","v":{"v":198.2794796475032,"d":"198.28"}},{"$f":"D3*2","v":{"v":293.74737725556025,"d":"293.75"}},{"$f":"E3*1.15","v":{"v":228.02140159462866,"d":"228.02"}},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"E3*H3","v":{"v":198.2794796475032,"d":"198.28"}},{"$f":"F3*J3","v":{"v":293.74737725556025,"d":"293.75"}},{"$f":"G3*I3","v":{"v":228.02140159462866,"d":"228.02"}},{"$f":"SUM(K3:M3)","v":{"v":720.0482584976921,"d":"720.05"}}]
["EMPLEADO",{"$f":"+'[4]1era Quincena'!F27","v":{"v":30000,"d":"30,000.00"}},{"$f":"B4/23.83","v":{"v":1258.917331095258,"d":"1,258.92"}},{"$f":"(B4/23.83)/8","v":{"v":157.36466638690726,"d":"157.36"}},{"$f":"D4*1.35","v":{"v":212.4422996223248,"d":"212.44"}},{"$f":"D4*2","v":{"v":314.7293327738145,"d":"314.73"}},{"$f":"E4*1.15","v":{"v":244.30864456567352,"d":"244.31"}},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"E4*H4","v":{"v":212.4422996223248,"d":"212.44"}},{"$f":"F4*J4","v":{"v":314.7293327738145,"d":"314.73"}},{"$f":"G4*I4","v":{"v":244.30864456567352,"d":"244.31"}},{"$f":"SUM(K4:M4)","v":{"v":771.4802769618128,"d":"771.48"}}]
["EMPLEADO",{"$f":"+'[4]1era Quincena'!F14","v":{"v":28000,"d":"28,000.00"}},{"v":1174.989509022241,"d":"1,174.99"},{"v":146.87368862778013,"d":"146.87"},{"v":198.2794796475032,"d":"198.28"},{"v":293.74737725556025,"d":"293.75"},{"v":228.02140159462866,"d":"228.02"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":198.2794796475032,"d":"198.28"},{"v":293.74737725556025,"d":"293.75"},{"v":228.02140159462866,"d":"228.02"},{"v":720.0482584976921,"d":"720.05"}]
["EMPLEADO",{"$f":"+'[4]1era Quincena'!F28","v":{"v":17000,"d":"17,000.00"}},{"v":713.3864876206463,"d":"713.39"},{"v":89.17331095258079,"d":"89.17"},{"v":120.38396978598408,"d":"120.38"},{"v":178.34662190516158,"d":"178.35"},{"v":138.4415652538817,"d":"138.44"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":120.38396978598408,"d":"120.38"},{"v":178.34662190516158,"d":"178.35"},{"v":138.4415652538817,"d":"138.44"},{"v":437.1721569450274,"d":"437.17"}]
["EMPLEADO",{"$f":"+'[4]1era Quincena'!F29","v":{"v":16000,"d":"16,000.00"}},{"v":671.4225765841377,"d":"671.42"},{"v":83.92782207301721,"d":"83.93"},{"v":113.30255979857324,"d":"113.30"},{"v":167.85564414603442,"d":"167.86"},{"v":130.2979437683592,"d":"130.30"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":113.30255979857324,"d":"113.30"},{"v":167.85564414603442,"d":"167.86"},{"v":130.2979437683592,"d":"130.30"},{"v":411.45614771296687,"d":"411.46"}]
["EMPLEADO",{"$f":"+'[4]1era Quincena'!F30","v":{"v":16000,"d":"16,000.00"}},{"v":671.4225765841377,"d":"671.42"},{"v":83.92782207301721,"d":"83.93"},{"v":113.30255979857324,"d":"113.30"},{"v":167.85564414603442,"d":"167.86"},{"v":130.2979437683592,"d":"130.30"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":113.30255979857324,"d":"113.30"},{"v":167.85564414603442,"d":"167.86"},{"v":130.2979437683592,"d":"130.30"},{"v":411.45614771296687,"d":"411.46"}]
["EMPLEADO",{"v":15000,"d":"15,000.00"},{"v":629.458665547629,"d":"629.46"},{"v":78.68233319345363,"d":"78.68"},{"v":106.2211498111624,"d":"106.22"},{"v":157.36466638690726,"d":"157.36"},{"v":122.15432228283676,"d":"122.15"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":106.2211498111624,"d":"106.22"},{"v":157.36466638690726,"d":"157.36"},{"v":122.15432228283676,"d":"122.15"},{"v":385.7401384809064,"d":"385.74"}]

{"sheet":"Vacaciones","index":8,"n_rows":8,"n_cols":6,"rows_kept":8}
[]
[]
[{"$nulls":4},"PAGO QUINCENAL"]
[null,"SALARIO MENSUAL",{"v":40000,"d":"40,000.00"},null,{"$f":"C4/2","v":{"v":20000,"d":"20,000.00"}}]
[null,"X DIAS 23.83",{"$f":"40000/23.83","v":{"v":1678.5564414603443,"d":"1,678.56"}},null,{"$f":"E4*5.91%","v":{"v":1182,"d":"1,182.00"}},"(TSS / 5.91%)"]
[null,"14 DIAS",{"$f":"C5*14","v":{"v":23499.79018044482,"d":"23,499.79"}},null,{"$f":"E4-E5","v":{"v":18818,"d":"18,818.00"}}]
[]
[null,"PRIMA VACACIONAL",{"$f":"C6-E6","v":{"v":4681.790180444819,"d":"4,681.79"}}]

{"sheet":"Regalia pascual","index":9,"n_rows":11,"n_cols":16,"rows_kept":11}
[]
["Empleados","Cargo","Enero","febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre","Total Anual","Total a pagar"]
["Ramon","administrador",{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"v":70000,"d":"$70,000.00"},{"$f":"SUM(C3:N3)","v":{"v":840000,"d":"$840,000.00"}},{"$f":"O3/12","v":{"v":70000,"d":"$70,000.00"}}]
["perez","supervisor",{"v":39000,"d":"$39,000.00"},{"v":39000,"d":"$39,000.00"},{"v":39000,"d":"$39,000.00"},{"v":39000,"d":"$39,000.00"},{"v":39000,"d":"$39,000.00"},{"v":39000,"d":"$39,000.00"},{"v":39000,"d":"$39,000.00"},{"v":39000,"d":"$39,000.00"},{"v":39000,"d":"$39,000.00"},{"v":39000,"d":"$39,000.00"},{"v":39000,"d":"$39,000.00"},{"v":41000,"d":"$41,000.00"},{"$f":"SUM(C4:N4)","v":{"v":470000,"d":"$470,000.00"}},{"$f":"O4/12","v":{"v":39166.666666666664,"d":"$39,166.67"}}]
["lucas","contador",{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":50290,"d":"$50,290.00"},{"v":603480,"d":"$603,480.00"},{"v":50290,"d":"$50,290.00"}]
["martinez","empacador ",{"v":44000,"d":"$44,000.00"},{"v":44000,"d":"$44,000.00"},{"v":44000,"d":"$44,000.00"},{"v":44000,"d":"$44,000.00"},{"v":44000,"d":"$44,000.00"},{"v":44000,"d":"$44,000.00"},{"v":44000,"d":"$44,000.00"},{"v":44000,"d":"$44,000.00"},{"v":55000,"d":"$55,000.00"},{"v":55000,"d":"$55,000.00"},{"v":55000,"d":"$55,000.00"},{"v":55000,"d":"$55,000.00"},{"v":572000,"d":"$572,000.00"},{"v":47666.666666666664,"d":"$47,666.67"}]
["omar","encargado de RRHH",{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":35110,"d":"$35,110.00"},{"v":421320,"d":"$421,320.00"},{"v":35110,"d":"$35,110.00"}]
["leonel","Auditor",{"v":35300,"d":"$35,300.00"},{"v":35300,"d":"$35,300.00"},{"v":35300,"d":"$35,300.00"},{"v":35300,"d":"$35,300.00"},{"v":35300,"d":"$35,300.00"},{"v":35300,"d":"$35,300.00"},{"v":35300,"d":"$35,300.00"},{"v":40000,"d":"$40,000.00"},{"v":40000,"d":"$40,000.00"},{"v":40000,"d":"$40,000.00"},{"v":40000,"d":"$40,000.00"},{"v":40000,"d":"$40,000.00"},{"v":447100,"d":"$447,100.00"},{"v":37258.333333333336,"d":"$37,258.33"}]
["danilo","gerente",{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":42350,"d":"$42,350.00"},{"v":508200,"d":"$508,200.00"},{"v":42350,"d":"$42,350.00"}]
["miguel","con fiscal",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":45000,"d":"$45,000.00"},{"v":45000,"d":"$45,000.00"},{"v":45000,"d":"$45,000.00"},{"v":45000,"d":"$45,000.00"},{"v":45000,"d":"$45,000.00"},{"v":45000,"d":"$45,000.00"},{"v":45000,"d":"$45,000.00"},{"v":315000,"d":"$315,000.00"},{"v":26250,"d":"$26,250.00"}]
["faride","encargada de compras",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":49000,"d":"$49,000.00"},{"v":49000,"d":"$49,000.00"},{"v":49000,"d":"$49,000.00"},{"v":49000,"d":"$49,000.00"},{"v":55600,"d":"$55,600.00"},{"v":55600,"d":"$55,600.00"},{"v":55600,"d":"$55,600.00"},{"v":362800,"d":"$362,800.00"},{"v":30233.333333333332,"d":"$30,233.33"}]

{"sheet":"Bonificacion","index":10,"n_rows":16,"n_cols":23,"rows_kept":16}
[]
[{"$nulls":4},"UTILIDAD DE LA EMPRESA",{"v":2500000,"d":"$2,500,000.00"},null,"ANOS","DIAS "]
[{"$nulls":4},"TOTAL A REPARTIR",{"$f":"F2*10%","v":{"v":250000,"d":"$250,000.00"}},null,"<3 ",45,{"$nulls":13},"Fecha actual"]
[{"$nulls":4},"BONIFICACION DE LEY",{"$f":"I16","v":{"v":400335.71128829214,"d":"$400,335.71"}},null,"3 O >",60,{"$nulls":13},"2020-01-01"]
[{"$nulls":4},"CONVERTIDOR",{"$f":"F3/F4","v":{"v":0.6244758909853249,"d":"$0.62"}},{"$nulls":16},"2020-01-01"]
[{"$nulls":22},"2020-01-01"]
[{"$nulls":22},"2020-01-01"]
[{"$nulls":22},"2020-01-01"]
[]
[null,null,"NOMBRE",null,"Salario","Salario diario","ANOS","Dias de bonificacion","Bonificacion de ley","BONIFICACION A PAGAR"]
[null,null,"Ramon","031-0109456-4",{"v":25000,"d":"$25,000.00"},{"$f":"E11/23.83","v":{"v":1049.0977759127152,"d":"$1,049.10"}},2,45,{"$f":"F11*H11","v":{"v":47209.39991607218,"d":"$47,209.40"}},{"$f":"I11*F5","v":{"v":29481.132075471694,"d":"$29,481.13"}}]
[null,null,"perez","031-0109456-5",{"v":24000,"d":"$24,000.00"},{"$f":"E12/23.83","v":{"v":1007.1338648762065,"d":"$1,007.13"}},1,45,{"$f":"H12*F12","v":{"v":45321.023919429295,"d":"$45,321.02"}},{"$f":"I12*F5","v":{"v":28301.886792452828,"d":"$28,301.89"}}]
[null,null,"lucas","031-0145456-8",{"v":55000,"d":"$55,000.00"},{"v":2308.0151070079733,"d":"$2,308.02"},5,60,{"$f":"F13*H13","v":{"v":138480.9064204784,"d":"$138,480.91"}},{"$f":"I13*F$5","v":{"v":86477.98742138364,"d":"$86,477.99"}}]
[null,null,"martinez","031-0145456-9",{"v":41000,"d":"$41,000.00"},{"v":1720.5203524968529,"d":"$1,720.52"},7,60,{"v":103231.22114981117,"d":"$103,231.22"},{"$f":"I14*F$5","v":{"v":64465.408805031446,"d":"$64,465.41"}}]
[null,null,"omar","031-0109456-4",{"v":35000,"d":"$35,000.00"},{"v":1468.7368862778012,"d":"$1,468.74"},1,45,{"v":66093.15988250106,"d":"$66,093.16"},{"v":41273.58490566038,"d":"$41,273.58"}]
[{"$nulls":8},{"$f":"SUM(I11:I15)","v":{"v":400335.71128829214,"d":"$400,335.71"}},{"$f":"SUM(J11:J15)","v":{"v":250000,"d":"$250,000.00"}}]

{"sheet":"REGISTRO CONTABLE NOMINA","index":11,"n_rows":2,"n_cols":17,"rows_kept":2}
[]
[{"$nulls":13},"DETALLE","AUXILIAR","DEBITO","CREDITO"]

{"sheet":"IR4","index":12,"n_rows":70,"n_cols":53,"rows_kept":70,"merged":[[0,3,0,10],[2,3,2,15],[3,3,3,5],[3,51,5,52],[5,23,5,26],[5,28,5,31],[5,34,5,41],[6,2,6,4],[6,5,6,18],[7,2,7,4],[7,5,7,18],[8,2,9,4],[8,5,9,5],[8,8,9,9],[8,10,8,11],[8,12,8,15],[9,10,9,11],[9,12,9,15],[10,41,10,42],[11,2,11,13],[11,14,11,53],[12,2,12,7],[12,8,12,13],[12,14,12,20],[12,25,12,31],[12,32,12,34],[12,41,12,42],[12,43,12,44],[12,45,12,47],[12,48,12,49],[12,50,12,51],[12,52,12,53],[13,1,14,1],[13,2,14,7],[13,8,14,13],[13,14,14,18],[13,25,14,31],[13,32,14,34],[13,35,14,35],[13,36,13,40],[13,41,14,42],[13,43,14,44],[13,45,14,47],[13,48,14,49],[13,50,14,51],[13,52,14,53],[15,2,15,7],[15,8,15,13],[15,14,15,20],[15,25,15,31],[15,32,15,34],[15,41,15,42],[15,43,15,44],[15,45,15,47],[15,48,15,49],[15,50,15,51],[15,52,15,53],[16,2,16,7],[16,8,16,13],[16,14,16,20],[16,25,16,31],[16,32,16,34],[16,41,16,42],[16,43,16,44],[16,45,16,47],[16,48,16,49],[16,50,16,51],[16,52,16,53],[17,2,17,7],[17,8,17,13],[17,14,17,20],[17,25,17,31],[17,32,17,34],[17,41,17,42],[17,43,17,44],[17,45,17,47],[17,48,17,49],[17,50,17,51],[17,52,17,53],[18,2,18,7],[18,8,18,13],[18,14,18,20],[18,25,18,31],[18,32,18,34],[18,41,18,42],[18,43,18,44],[18,45,18,47],[18,48,18,49],[18,50,18,51],[18,52,18,53],[19,2,19,7],[19,8,19,13],[19,14,19,20],[19,25,19,31],[19,32,19,34],[19,41,19,42],[19,43,19,44],[19,45,19,47],[19,48,19,49],[19,50,19,51],[19,52,19,53],[20,2,20,7],[20,8,20,13],[20,14,20,20],[20,25,20,31],[20,32,20,34],[20,41,20,42],[20,43,20,44],[20,45,20,47],[20,48,20,49],[20,50,20,51],[20,52,20,53],[21,2,21,7],[21,8,21,13],[21,14,21,20],[21,25,21,31],[21,32,21,34],[21,41,21,42],[21,43,21,44],[21,45,21,47],[21,48,21,49],[21,50,21,51],[21,52,21,53],[22,2,22,7],[22,8,22,13],[22,14,22,20],[22,25,22,31],[22,32,22,34],[22,41,22,42],[22,43,22,44],[22,45,22,47],[22,48,22,49],[22,50,22,51],[22,52,22,53],[23,2,23,7],[23,8,23,13],[23,14,23,20],[23,25,23,31],[23,32,23,34],[23,41,23,42],[23,43,23,44],[23,45,23,47],[23,48,23,49],[23,50,23,51],[23,52,23,53],[24,2,24,7],[24,8,24,13],[24,14,24,20],[24,25,24,31],[24,32,24,34],[24,41,24,42],[24,43,24,44],[24,45,24,47],[24,48,24,49],[24,50,24,51],[24,52,24,53],[25,2,25,7],[25,8,25,13],[25,14,25,20],[25,25,25,31],[25,32,25,34],[25,41,25,42],[25,43,25,44],[25,45,25,47],[25,48,25,49],[25,50,25,51],[25,52,25,53],[26,2,26,7],[26,8,26,13],[26,14,26,20],[26,25,26,31],[26,32,26,34],[26,41,26,42],[26,43,26,44],[26,45,26,47],[26,48,26,49],[26,50,26,51],[26,52,26,53],[27,2,27,7],[27,8,27,13],[27,14,27,20],[27,25,27,31],[27,32,27,34],[27,41,27,42],[27,43,27,44],[27,45,27,47],[27,48,27,49],[27,50,27,51],[27,52,27,53],[28,2,28,7],[28,8,28,13],[28,14,28,20],[28,25,28,31],[28,32,28,34],[28,41,28,42],[28,43,28,44],[28,45,28,47],[28,48,28,49],[28,50,28,51],[28,52,28,53],[29,2,29,7],[29,8,29,13],[29,14,29,20],[29,25,29,31],[29,32,29,34],[29,41,29,42],[29,43,29,44],[29,45,29,47],[29,48,29,49],[29,50,29,51],[29,52,29,53],[30,2,30,7],[30,8,30,13],[30,14,30,20],[30,25,30,31],[30,32,30,34],[30,41,30,42],[30,43,30,44],[30,45,30,47],[30,48,30,49],[30,50,30,51],[30,52,30,53],[31,2,31,7],[31,8,31,13],[31,14,31,20],[31,25,31,31],[31,32,31,34],[31,41,31,42],[31,43,31,44],[31,45,31,47],[31,48,31,49],[31,50,31,51],[31,52,31,53],[32,2,32,7],[32,8,32,13],[32,14,32,20],[32,25,32,31],[32,32,32,34],[32,41,32,42],[32,43,32,44],[32,45,32,47],[32,48,32,49],[32,50,32,51],[32,52,32,53],[33,2,33,7],[33,8,33,13],[33,14,33,20],[33,25,33,31],[33,32,33,34],[33,41,33,42],[33,43,33,44],[33,45,33,47],[33,48,33,49],[33,50,33,51],[33,52,33,53],[34,2,34,7],[34,8,34,13],[34,14,34,20],[34,25,34,31],[34,32,34,34],[34,41,34,42],[34,43,34,44],[34,45,34,47],[34,48,34,49],[34,50,34,51],[34,52,34,53],[35,2,35,7],[35,8,35,13],[35,14,35,20],[35,25,35,31],[35,32,35,34],[35,41,35,42],[35,43,35,44],[35,45,35,47],[35,48,35,49],[35,50,35,51],[35,52,35,53],[36,2,36,7],[36,8,36,13],[36,14,36,20],[36,25,36,31],[36,32,36,34],[36,41,36,42],[36,43,36,44],[36,45,36,47],[36,48,36,49],[36,50,36,51],[36,52,36,53],[37,2,37,7],[37,8,37,13],[37,14,37,20],[37,25,37,31],[37,32,37,34],[37,41,37,42],[37,43,37,44],[37,45,37,47],[37,48,37,49],[37,50,37,51],[37,52,37,53],[38,2,38,7],[38,8,38,13],[38,14,38,20],[38,25,38,31],[38,32,38,34],[38,41,38,42],[38,43,38,44],[38,45,38,47],[38,48,38,49],[38,50,38,51],[38,52,38,53],[39,2,39,7],[39,8,39,13],[39,14,39,20],[39,25,39,31],[39,32,39,34],[39,41,39,42],[39,43,39,44],[39,45,39,47],[39,48,39,49],[39,50,39,51],[39,52,39,53],[40,2,40,7],[40,8,40,13],[40,14,40,20],[40,25,40,31],[40,32,40,34],[40,41,40,42],[40,43,40,44],[40,45,40,47],[40,48,40,49],[40,50,40,51],[40,52,40,53],[41,2,41,7],[41,8,41,13],[41,14,41,20],[41,25,41,31],[41,32,41,34],[41,41,41,42],[41,43,41,44],[41,45,41,47],[41,48,41,49],[41,50,41,51],[41,52,41,53],[42,2,42,7],[42,8,42,13],[42,14,42,20],[42,25,42,31],[42,32,42,34],[42,41,42,42],[42,43,42,44],[42,45,42,47],[42,48,42,49],[42,50,42,51],[42,52,42,53],[43,2,43,7],[43,8,43,13],[43,14,43,20],[43,25,43,31],[43,32,43,34],[43,41,43,42],[43,43,43,44],[43,45,43,47],[43,48,43,49],[43,50,43,51],[43,52,43,53],[44,2,44,7],[44,8,44,13],[44,14,44,20],[44,25,44,31],[44,32,44,34],[44,41,44,42],[44,43,44,44],[44,45,44,47],[44,48,44,49],[44,50,44,51],[44,52,44,53],[45,2,45,7],[45,8,45,13],[45,14,45,20],[45,25,45,31],[45,32,45,34],[45,41,45,42],[45,43,45,44],[45,45,45,47],[45,48,45,49],[45,50,45,51],[45,52,45,53],[46,2,46,7],[46,8,46,13],[46,14,46,20],[46,25,46,31],[46,32,46,34],[46,41,46,42],[46,43,46,44],[46,45,46,47],[46,48,46,49],[46,50,46,51],[46,52,46,53],[47,2,47,7],[47,8,47,13],[47,14,47,20],[47,25,47,31],[47,32,47,34],[47,41,47,42],[47,43,47,44],[47,45,47,47],[47,48,47,49],[47,50,47,51],[47,52,47,53],[48,2,48,7],[48,8,48,13],[48,14,48,20],[48,25,48,31],[48,32,48,34],[48,41,48,42],[48,43,48,44],[48,45,48,47],[48,48,48,49],[48,50,48,51],[48,52,48,53],[49,2,49,7],[49,8,49,13],[49,14,49,20],[49,25,49,31],[49,32,49,34],[49,41,49,42],[49,43,49,44],[49,45,49,47],[49,48,49,49],[49,50,49,51],[49,52,49,53],[50,2,50,7],[50,8,50,13],[50,14,50,20],[50,25,50,31],[50,32,50,34],[50,41,50,42],[50,43,50,44],[50,45,50,47],[50,48,50,49],[50,50,50,51],[50,52,50,53],[51,2,51,7],[51,8,51,13],[51,14,51,20],[51,25,51,31],[51,32,51,34],[51,41,51,42],[51,43,51,44],[51,45,51,47],[51,48,51,49],[51,50,51,51],[51,52,51,53],[52,2,52,7],[52,8,52,13],[52,14,52,20],[52,25,52,31],[52,32,52,34],[52,41,52,42],[52,43,52,44],[52,45,52,47],[52,48,52,49],[52,50,52,51],[52,52,52,53],[53,2,53,7],[53,8,53,13],[53,14,53,20],[53,25,53,31],[53,32,53,34],[53,41,53,42],[53,43,53,44],[53,45,53,47],[53,48,53,49],[53,50,53,51],[53,52,53,53],[54,2,54,7],[54,8,54,13],[54,14,54,20],[54,25,54,31],[54,32,54,34],[54,41,54,42],[54,43,54,44],[54,45,54,47],[54,48,54,49],[54,50,54,51],[54,52,54,53],[55,2,55,7],[55,8,55,13],[55,14,55,20],[55,25,55,31],[55,32,55,34],[55,41,55,42],[55,43,55,44],[55,45,55,47],[55,48,55,49],[55,50,55,51],[55,52,55,53],[56,2,56,7],[56,8,56,13],[56,14,56,20],[56,25,56,31],[56,32,56,34],[56,41,56,42],[56,43,56,44],[56,45,56,47],[56,48,56,49],[56,50,56,51],[56,52,56,53],[57,2,57,7],[57,8,57,13],[57,14,57,20],[57,25,57,31],[57,32,57,34],[57,41,57,42],[57,43,57,44],[57,45,57,47],[57,48,57,49],[57,50,57,51],[57,52,57,53],[58,2,58,7],[58,8,58,13],[58,14,58,20],[58,25,58,31],[58,32,58,34],[58,41,58,42],[58,43,58,44],[58,45,58,47],[58,48,58,49],[58,50,58,51],[58,52,58,53],[59,2,59,7],[59,8,59,13],[59,14,59,20],[59,25,59,31],[59,32,59,34],[59,41,59,42],[59,43,59,44],[59,45,59,47],[59,48,59,49],[59,50,59,51],[59,52,59,53],[60,2,60,7],[60,8,60,13],[60,14,60,20],[60,25,60,31],[60,32,60,34],[60,41,60,42],[60,43,60,44],[60,45,60,47],[60,48,60,49],[60,50,60,51],[60,52,60,53],[61,2,61,7],[61,8,61,13],[61,14,61,20],[61,21,61,24],[61,25,61,31],[61,32,61,34],[61,41,61,42],[61,43,61,44],[61,45,61,47],[61,48,61,49],[61,50,61,51],[61,52,61,53],[62,2,62,7],[62,8,62,13],[62,14,62,20],[62,21,62,24],[62,25,62,31],[62,32,62,34],[62,41,62,42],[62,43,62,44],[62,45,62,47],[62,48,62,49],[62,50,62,51],[62,52,62,53],[63,2,63,7],[63,8,63,13],[63,14,63,20],[63,21,63,24],[63,25,63,31],[63,32,63,34],[63,41,63,42],[63,43,63,44],[63,45,63,47],[63,48,63,49],[63,50,63,51],[63,52,63,53],[64,7,64,13],[64,14,64,18],[64,25,64,30],[64,32,64,34],[64,41,64,42],[64,43,64,44],[64,45,64,47],[64,48,64,49],[64,50,64,51],[64,52,64,53],[67,1,67,4],[67,6,67,9],[67,30,68,51],[69,1,70,5],[69,6,70,9]]}
[]
[{"$nulls":3},"DIRECCIÓN GENERAL DE IMPUESTOS INTERNOS"]
[{"$nulls":3},"CÁLCULO DE LAS RETENCIONES MENSUALES DEL ASALARIADO"]
[{"$nulls":3},"Versión 2017",{"$nulls":47},"IR-4"]
[]
[]
[null,null,"RNC"]
[null,null,"Agente de Retención",{"$nulls":39},{"v":416220,"d":"416,220.00"}]
[null,null,"Periodo",null,null,"Desde","Mes","Año","Hasta",null,"Mes",null,"Año"]
[{"$nulls":6},7,2025]
[]
[null,null,"IDENTIFICACION DEL ASALARIADO",{"$nulls":11},"REMUNERACIONES PERCIBIDAS"]
[null,null,"A",{"$nulls":5},"B",{"$nulls":5},"C",{"$nulls":10},"D",{"$nulls":6},"E",null,null,"F","G","H","I","J","K","L",null,"M",null,"N",null,null,"O",null,"P",null,"Q"]
[null,"Líneas","Apellidos y Nombres Completos",{"$nulls":5},"Cédula /RNC",{"$nulls":5},"Sueldos pagados por el agente de Retención",{"$nulls":10},"Otras remuneraciones pagadas por el Agente de Retención",{"$nulls":6},"Remuneraciones Pagadas por Otros Empleadores",null,null,"Total Pagado en el Mes","Retenciones e Ingresos Exentos del Período",{"$nulls":4},"Sueldos y otros pagos Sujetos a Retención",null,"Liquidación  Período",null,"Saldo a favor del Asalariado",null,null,"Saldo Compensado",null,"Nuevo Saldo a favor Asalariado a compensar (si M - L es positivo)",null,"Diferencia a Pagar"]
[{"$nulls":36},"Retención Seguridad Social","Regalía Pascual (Sueldo 13)","Preaviso, Cesantía, Viáticos e Indemnizaciones Accidentes Laborales","Retención Pensión Alimenticia","TOTAL RETENCIONES e INGRESOS EXENTOS          (Sumar G + H + I + J)"]
[{"$f":"+(AP16*12)-416220","v":{"v":148320,"d":"148320.00"}},1,"Galvan Sanchez, Luis Fermin","Galvan Sanchez, Luis Fermin","Galvan Sanchez, Luis Fermin","Galvan Sanchez, Luis Fermin","Galvan Sanchez, Luis Fermin","Galvan Sanchez, Luis Fermin",{"v":103841706,"d":"001-0384170-6"},{"v":103841706,"d":"001-0384170-6"},{"v":103841706,"d":"001-0384170-6"},{"v":103841706,"d":"001-0384170-6"},{"v":103841706,"d":"001-0384170-6"},{"v":103841706,"d":"001-0384170-6"},{"v":50000,"d":"50,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"$nulls":14},{"$f":"+SUM(O16+Z16+AG16)","v":{"v":50000,"d":"50,000.00"}},{"$f":"AJ16*5.91%","v":{"v":2955,"d":"2,955.00"}},{"$nulls":3},{"$f":"AK16+AL16+AM16+AN16","v":{"v":2955,"d":"2,955.00"}},{"$f":"IF((+AJ16-AO16)>0,(+AJ16-AO16),0)","v":{"v":47045,"d":"47,045.00"}},null,{"$f":"IF(AND(A16<=0,$AQ$8>0),0,IF(AND(A16<=208109,$AQ$8>0),0.15*A16,IF(AND(A16<=450903,$AQ$8>0), 31216.35 +(0.2*(A16-208109)),IF(AND(A16>=450903,$AQ$8>0), 79775.15 +(0.25*(A16-450903)),IF(A16<=624329,0.15*A16,IF(A16<=867123, 93649.35 +(0.2*(A16-624329)),IF(A16>867123, 142208.15 +(0.25*(A16-867123)))))))))/12","v":{"v":1854,"d":"1,854.00"}},{"$nulls":4},{"$f":"IF((AT16-AR16)>0,AR16,AT16)","v":0},null,{"$f":"IF((AT16-AW16)<0,0,(AT16-AW16))","v":0},null,{"$f":"IF((AR16-AT16)>0,(AR16-AT16),0)","v":{"v":1854,"d":"1,854.00"}}]
[{"$f":"+(AP17*12)-416220","v":{"v":124548.6000000001,"d":"124548.60"}},2,"Manuela Daneiry Herrera","Herrera Nuñez, Manuela Daneiry","Herrera Nuñez, Manuela Daneiry","Herrera Nuñez, Manuela Daneiry","Herrera Nuñez, Manuela Daneiry","Herrera Nuñez, Manuela Daneiry",{"v":113235675,"d":"001-1323567-5"},{"v":113235675,"d":"001-1323567-5"},{"v":113235675,"d":"001-1323567-5"},{"v":113235675,"d":"001-1323567-5"},{"v":113235675,"d":"001-1323567-5"},{"v":113235675,"d":"001-1323567-5"},{"v":12500,"d":"12,500.00"},{"v":12500,"d":"12,500.00"},{"v":12500,"d":"12,500.00"},{"v":12500,"d":"12,500.00"},{"v":12500,"d":"12,500.00"},{"v":12500,"d":"12,500.00"},{"v":12500,"d":"12,500.00"},{"$nulls":4},{"v":33302.8,"d":"33,302.80"},{"$nulls":9},{"$f":"+SUM(O17+Z17+AG17)","v":{"v":45802.8,"d":"45,802.80"}},{"$f":"O17*5.91%","v":738.75},{"$nulls":3},{"$f":"AK17+AL17+AM17+AN17","v":738.75},{"$f":"IF((+AJ17-AO17)>0,(+AJ17-AO17),0)","v":{"v":45064.05,"d":"45,064.05"}},null,{"$f":"IF(AND(A17<=0,$AQ$8>0),0,IF(AND(A17<=208109,$AQ$8>0),0.15*A17,IF(AND(A17<=450903,$AQ$8>0), 31216.35 +(0.2*(A17-208109)),IF(AND(A17>=450903,$AQ$8>0), 79775.15 +(0.25*(A17-450903)),IF(A17<=624329,0.15*A17,IF(A17<=867123, 93649.35 +(0.2*(A17-624329)),IF(A17>867123, 142208.15 +(0.25*(A17-867123)))))))))/12","v":{"v":1556.857500000001,"d":"1,556.86"}},{"$nulls":4},{"$f":"IF((AT17-AR17)>0,AR17,AT17)","v":0},null,{"$f":"IF((AT17-AW17)<0,0,(AT17-AW17))","v":0},null,{"$f":"IF((AR17-AT17)>0,(AR17-AT17),0)","v":{"v":1556.857500000001,"d":"1,556.86"}}]
[{"$f":"+(AP18*12)-416220","v":{"v":35412,"d":"35412.00"}},3,"Hanssel Asterio Martinez Gomez ","Leonardo Batista, Madelyn","Leonardo Batista, Madelyn","Leonardo Batista, Madelyn","Leonardo Batista, Madelyn","Leonardo Batista, Madelyn",{"v":40222702660,"d":"402-2270266-0"},{"v":40222702660,"d":"402-2270266-0"},{"v":40222702660,"d":"402-2270266-0"},{"v":40222702660,"d":"402-2270266-0"},{"v":40222702660,"d":"402-2270266-0"},{"v":40222702660,"d":"402-2270266-0"},{"v":40000,"d":"40,000.00"},{"v":25000,"d":"25,000.00"},{"v":25000,"d":"25,000.00"},{"v":25000,"d":"25,000.00"},{"v":25000,"d":"25,000.00"},{"v":25000,"d":"25,000.00"},{"v":25000,"d":"25,000.00"},{"$nulls":14},{"$f":"+SUM(O18+Z18+AG18)","v":{"v":40000,"d":"40,000.00"}},{"$f":"AJ18*5.91%","v":{"v":2364,"d":"2,364.00"}},{"$nulls":3},{"v":2364,"d":"2,364.00"},{"v":37636,"d":"37,636.00"},null,{"v":442.65000000000003,"d":"442.65"},{"$nulls":4},0,null,0,null,{"v":442.65000000000003,"d":"442.65"}]
[{"v":261228,"d":"261228.00"},4,"Joaquin Alberto Samboy Ferreras",{"$nulls":5},"001-1921774-3",{"$nulls":5},{"v":60000,"d":"60,000.00"},{"$nulls":20},{"v":60000,"d":"60,000.00"},{"v":3546,"d":"3,546.00"},{"$nulls":3},{"$f":"AK19+AL19+AM19+AN19","v":{"v":3546,"d":"3,546.00"}},{"v":56454,"d":"56,454.00"},null,{"v":3486.679166666667,"d":"3,486.68"},{"$nulls":4},0,null,0,null,{"v":3486.679166666667,"d":"3,486.68"}]
[{"v":430590,"d":"430590.00"},5,"Virgilio Alfredo Mercedes Peralta","Mercedes Peralta, Virgilio Alfredo","Mercedes Peralta, Virgilio Alfredo","Mercedes Peralta, Virgilio Alfredo","Mercedes Peralta, Virgilio Alfredo","Mercedes Peralta, Virgilio Alfredo",{"v":118385392,"d":"001-1838539-2"},{"v":118385392,"d":"001-1838539-2"},{"v":118385392,"d":"001-1838539-2"},{"v":118385392,"d":"001-1838539-2"},{"v":118385392,"d":"001-1838539-2"},{"v":118385392,"d":"001-1838539-2"},{"v":75000,"d":"75,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"$nulls":14},{"$f":"+SUM(O20+Z20+AG20)","v":{"v":75000,"d":"75,000.00"}},{"v":4432.5,"d":"4,432.50"},{"$nulls":3},{"v":4432.5,"d":"4,432.50"},{"v":70567.5,"d":"70,567.50"},null,{"v":6309.379166666667,"d":"6,309.38"},{"$nulls":4},0,null,0,null,{"v":6309.379166666667,"d":"6,309.38"}]
[{"v":148320,"d":"148320.00"},6,"Armando Peña Aquino ","Peña Aquino, Armando","Peña Aquino, Armando","Peña Aquino, Armando","Peña Aquino, Armando","Peña Aquino, Armando",{"v":400205878,"d":"004-0020587-8"},{"v":400205878,"d":"004-0020587-8"},{"v":400205878,"d":"004-0020587-8"},{"v":400205878,"d":"004-0020587-8"},{"v":400205878,"d":"004-0020587-8"},{"v":400205878,"d":"004-0020587-8"},{"v":50000,"d":"50,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"$nulls":14},{"$f":"+SUM(O21+Z21+AG21)","v":{"v":50000,"d":"50,000.00"}},{"v":2955,"d":"2,955.00"},{"$nulls":3},{"v":2955,"d":"2,955.00"},{"v":47045,"d":"47,045.00"},null,{"v":1854,"d":"1,854.00"},{"$nulls":4},0,null,0,null,{"v":1854,"d":"1,854.00"}]
[{"v":12830.399999999965,"d":"12830.40"},7,"Ana Elizabeth Rosario Hernandez","Rosario Hernandez, Ana Elizabeth","Rosario Hernandez, Ana Elizabeth","Rosario Hernandez, Ana Elizabeth","Rosario Hernandez, Ana Elizabeth","Rosario Hernandez, Ana Elizabeth",{"v":22400061747,"d":"224-0006174-7"},{"v":22400061747,"d":"224-0006174-7"},{"v":22400061747,"d":"224-0006174-7"},{"v":22400061747,"d":"224-0006174-7"},{"v":22400061747,"d":"224-0006174-7"},{"v":22400061747,"d":"224-0006174-7"},{"v":38000,"d":"38,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"},{"$nulls":14},{"$f":"+SUM(O22+Z22+AG22)","v":{"v":38000,"d":"38,000.00"}},{"v":2245.8,"d":"2,245.80"},{"$nulls":3},{"v":2245.8,"d":"2,245.80"},{"v":35754.2,"d":"35,754.20"},null,{"v":160.37999999999957,"d":"160.38"},{"$nulls":4},0,null,0,null,{"v":160.37999999999957,"d":"160.38"}]
[{"v":-416220,"d":"(416220.00)"},8,{"$nulls":33},0,0,{"$nulls":3},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},9,{"$nulls":33},{"$f":"+SUM(O24+Z24+AG24)","v":0},0,{"$nulls":3},{"$f":"AK24+AL24+AM24+AN24","v":0},0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},10,{"$nulls":33},0,0,{"$nulls":3},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},11,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},12,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},13,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},14,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ29-AO29)>0,(+AJ29-AO29),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},15,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ30-AO30)>0,(+AJ30-AO30),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},16,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},17,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},18,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},19,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},20,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},21,{"$nulls":33},{"$f":"+SUM(O36+Z36+AG36)","v":0},{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},22,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},23,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},24,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ39-AO39)>0,(+AJ39-AO39),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},25,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ40-AO40)>0,(+AJ40-AO40),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},26,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},27,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},28,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},29,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},30,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},31,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},32,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},33,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},34,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ49-AO49)>0,(+AJ49-AO49),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},35,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ50-AO50)>0,(+AJ50-AO50),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},36,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},37,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},38,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},39,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},40,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},41,{"$nulls":33},{"$f":"+SUM(O56+Z56+AG56)","v":0},{"$nulls":4},{"$f":"AK56+AL56+AM56+AN56","v":0},0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},42,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},43,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},44,{"$nulls":33},0,{"$nulls":4},0,0,null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},45,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ60-AO60)>0,(+AJ60-AO60),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},46,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ61-AO61)>0,(+AJ61-AO61),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},47,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ62-AO62)>0,(+AJ62-AO62),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},48,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ63-AO63)>0,(+AJ63-AO63),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"v":-416220,"d":"(416220.00)"},49,{"$nulls":33},0,{"$nulls":4},0,{"$f":"IF((+AJ64-AO64)>0,(+AJ64-AO64),0)","v":0},null,0,{"$nulls":4},0,null,0,null,0]
[{"$nulls":7},"TOTALES (RD$)",{"$nulls":6},{"$f":"SUM(O16:O64)","v":{"v":325500,"d":"325,500.00"}},{"$nulls":9},{"$f":"SUM(O65:X65)","v":{"v":325500,"d":"325,500.00"}},{"$f":"SUM(Z16:Z64)","v":{"v":33302.8,"d":"33,302.80"}},{"$nulls":6},{"$f":"+SUM(AG16:AG64)","v":0},null,null,{"$f":"+SUM(AJ16:AJ64)","v":{"v":358802.8,"d":"358,802.80"}},{"v":19237.05,"d":"19,237.05"},0,0,null,{"v":19237.05,"d":"19,237.05"},{"v":339565.75,"d":"339,565.75"},null,{"$f":"SUM(AR16:AS64)","v":{"v":15663.945833333333,"d":"15,663.95"}},null,{"$f":"+SUM(AT16:AT64)","v":0},null,null,{"$f":"+SUM(AW16:AW64)","v":0},null,{"$f":"+SUM(AY16:AY64)","v":0},null,{"$f":"+SUM(BA16:BA64)","v":{"v":15663.945833333333,"d":"15,663.95"}}]
[]
[]
[null,"NUMERO DE ASALARIADOS",{"$nulls":4},7,{"$nulls":3},"Llevar a la casilla con la letra (A) del formulario IR-3",{"$nulls":19},"NOTA: Este formulario es tan sólo un formato o modelo, para orientar el cálculo de las retenciones. El Agente de Retención deberá conservar en todo momento el detalle de estas retenciones por beneficiarios, disponible a solicitud de esta Dirección General en este formulario."]
[]
[null,"ASALARIADOS SUJETOS A RETENCION",{"$nulls":8},"Llevar a la casilla con la letra (B) del formulario IR-3"]

{"sheet":"IR 3","index":13,"n_rows":53,"n_cols":41,"rows_kept":53,"merged":[[2,2,2,5],[2,41,3,41],[4,6,4,23],[4,40,4,43],[5,6,5,23],[5,40,6,43],[6,3,6,5],[7,2,7,5],[11,2,11,6],[11,7,11,10],[11,14,11,17],[11,20,11,25],[13,3,13,43],[14,2,14,5],[14,6,14,14],[14,15,14,16],[14,18,14,22],[14,28,14,32],[14,34,14,41],[15,2,16,5],[15,6,15,7],[15,8,15,13],[15,14,15,15],[15,16,15,35],[15,36,15,38],[15,39,15,43],[16,6,16,7],[16,8,16,21],[16,22,16,25],[16,26,16,35],[16,36,16,38],[16,39,16,43],[17,2,17,43],[18,2,18,5],[18,7,18,25],[18,29,18,37],[18,38,22,43],[19,2,27,5],[19,7,19,25],[19,29,19,37],[20,7,20,25],[20,29,20,37],[21,7,21,25],[21,29,21,37],[22,7,22,25],[22,29,22,37],[23,7,23,34],[23,38,23,43],[24,7,24,25],[24,29,24,37],[24,38,27,43],[25,7,25,25],[25,29,25,37],[26,7,26,25],[26,29,26,37],[27,7,27,25],[27,29,27,37],[28,2,28,43],[29,2,29,5],[29,7,29,34],[29,38,29,43],[30,2,38,5],[30,7,30,25],[30,29,30,37],[30,38,33,43],[31,7,31,25],[31,29,31,37],[32,7,32,25],[32,29,32,37],[33,7,33,25],[33,29,33,37],[34,7,34,34],[34,38,34,43],[35,7,35,34],[35,38,35,43],[36,7,36,20],[36,22,36,25],[36,29,36,37],[36,38,37,43],[37,7,37,20],[37,22,37,25],[37,29,37,37],[38,7,38,34],[38,38,38,43],[39,2,39,43],[40,2,40,43],[42,2,42,24],[42,25,42,43],[43,37,53,43],[44,3,44,24],[45,5,45,21],[46,2,47,24],[46,26,46,27],[46,28,46,30],[46,31,46,35],[47,26,47,35],[49,26,49,35],[50,26,50,35],[51,4,51,9],[51,14,51,23],[52,4,52,9],[52,14,52,23]]}
[]
[]
[]
[]
[{"$nulls":6},"DIRECCION GENERAL DE IMPUESTOS INTERNOS",{"$nulls":33},"IR-3"]
[{"$nulls":6},"DECLARACION Y/O PAGO DE RETENCIONES DE ASALARIADOS\n"]
[]
[null,null,"Versión 2017"]
[]
[]
[]
[null,null,"PERIODO    MES/AÑO",{"$nulls":11},"FECHA LIMITE DE PAGO"]
[]
[]
[null,null,"I.",{"$nulls":3},"TIPO DE DECLARACION Y/O PAGO",{"$nulls":8},"NORMAL",null,null,"RECTIFICATIVA",{"$nulls":5},"D",null,"C",null,"AJUSTE O ESTIMACION",{"$nulls":5},"RECURSO DE RECONSIDERACION"]
[null,null,"DATOS GENERALES",{"$nulls":3},"RNC/CEDULA",{"$nulls":7},"RAZON SOCIAL/NOMBRE",{"$nulls":21},"TELEFONO"]
[{"$nulls":6},"NOMBRE COMERCIAL",{"$nulls":15},"CORREO ELECTRONICO",{"$nulls":13},"CELULAR"]
[]
[" ",null,"II.",{"$nulls":3},1,"TOTAL  ASALARIADOS",{"$nulls":18},"=","A",1,{"$f":"[1]IR4!O65","v":{"v":325500,"d":"325,500.00"}}]
[null,null,"ASALARIADOS",{"$nulls":3},2,"ASALARIADOS SUJETOS A RETENCION",{"$nulls":18},"=","B",2,{"v":7,"d":"7.00"}]
[{"$nulls":6},3,"SUELDOS PAGADOS POR EL AGENTE",{"$nulls":18},"=","C",3,{"$f":"[1]IR4!O65","v":{"v":325500,"d":"325,500.00"}}]
[{"$nulls":6},4,"OTRAS REMUNERACIONES",{"$nulls":18},"=","D",4,{"$f":"[1]IR4!Z65","v":{"v":33302.8,"d":"33,302.80"}}]
[{"$nulls":6},5," REMUNERACIONES DE OTROS AGENTES",{"$nulls":18},"=","E",5]
[{"$nulls":6},6,"TOTAL PAGADO (Sumar casillas 3+4+5)",{"$nulls":27},"=","F",6,{"$f":"+SUM(AD21:AL23)","v":{"v":358802.8,"d":"358,802.80"}}]
[{"$nulls":6},7,"PAGO TOTAL SUJETO A RETENCION",{"$nulls":18},"=","L",7,{"$f":"[1]IR4!AP65","v":{"v":339565.75,"d":"339,565.75"}}]
[{"$nulls":6},8,"IMPUESTO SOBRE LA RENTA ",{"$nulls":18},"=","M",8,{"v":15663.95,"d":"15,663.95"}]
[{"$nulls":6},9,"SALDO COMPENSADO AUTORIZADO",{"$nulls":18},"-","O",9]
[{"$nulls":6},10,"SALDO POR COMPENSAR",{"$nulls":18},"=","P",10]
[{"$nulls":6},10,{"$nulls":19},"+","K",10]
[null,null,"III.",null,"III.",null,11,"IMPUESTO A PAGAR (si el valor de las casilla 8-9 es positivo)",{"$nulls":27},"=","Q",11,{"$f":"+ABS(IF(AD26-AD27>0,AD26-AD27,0))","v":{"v":15663.95,"d":"15,663.95"}}]
[null,null,"LIQUIDACION",{"$nulls":3},12,"CREDITO AUTORIZADO",{"$nulls":18},"-",null,12]
[{"$nulls":6},13,"CREDITO GASTOS EDUCATIVOS IR-18",{"$nulls":18},"-",null,13]
[{"$nulls":6},14,"PAGOS COMPUTABLES A CUENTA",{"$nulls":18},"-",null,14]
[{"$nulls":6},15,"SALDO A FAVOR ANTERIOR",{"$nulls":18},"-",null,15]
[{"$nulls":6},16,"DIFERENCIA A PAGAR (Si el valor de las casillas  11-12-13-14-15 es positivo)",{"$nulls":27},"=",null,16,{"$f":"ABS(IF(AM30-AD31-AD32-AD33-AD34>0,AM30-AD31-AD32-AD33-AD34,0))","v":{"v":15663.95,"d":"15,663.95"}}]
[{"$nulls":6},17,"SALDO A FAVOR  (Si el valor de las casillas  11-12-13-14-15  es negativo)",{"$nulls":18},"-",null,17,{"$nulls":6},"=",null,17,{"$f":"ABS(IF(AM30-AD31-AD32-AD33-AD34<0,AM30-AD31-AD32-AD33-AD34,0))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},18,"RECARGOS",{"$nulls":14},"% de la Casilla 16",{"$nulls":3},"+",null,18,{"$f":"ABS(+AM35*V37)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},19,"INTERES INDEMNIZATORIO",{"$nulls":14},"% de la Casilla 16",{"$nulls":3},"+",null,19,{"$f":"ABS(+AM35*V38)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},20,"TOTAL A PAGAR (Sumar casillas 16+18+19)",{"$nulls":27},"=",null,20,{"$f":"ABS(IF(AM35+AD37+AD38>0,AM35+AD37+AD38,0))","v":{"v":15663.95,"d":"15,663.95"}}]
[{"$nulls":6},21,{"$nulls":21},21]
[null,null,"NOTA IMPORTANTE: El Agente de Retención debe conservar en todo momento el detalle de estas retenciones, disponible a solicitud de esta Direccion General del Formulario IR-4 (Asalariados)."]
[]
[null,null,"IV. JURAMENTO DEL DECLARANTE",{"$nulls":22},"V. PARA USO DE LA DGII"]
[{"$nulls":37},"FIRMA Y SELLO"]
[null,null,"Yo"]
[null,null,"en calidad de",{"$nulls":19}," "]
[null,null,"afirmo bajo juramento que los datos consignados en la presente declaracion son correctos y completos y que no he omitido ni falseado dato alguno que la misma deba contener, siendo en consecuencia todo su contenido la fiel expresion de la verdad."]
[{"$nulls":26},"FECHA DE PAGO"]
[]
[]
[{"$nulls":26},"NO. DE RECIBO DE PAGO"]
[]
[{"$nulls":4},"Fecha",{"$nulls":9},"Firma"]

{"sheet":"Plantilla de Autodeterminación","index":14,"n_rows":17,"n_cols":21,"rows_kept":17,"merged":[[1,7,6,9],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,2,9,3],[10,1,10,8],[10,9,10,12],[10,13,10,19]]}
[{"$nulls":10},"TARCHIVO","TDOC","SEXO",null,"TINGRESO"]
[{"$nulls":7},"Cuanto termine de llenar la información de sus empleados, presione el botón \"Generar Archivo\" para generar el archivo que deberá enviar a través de la página de internet de la Tesorería de la Seguridad Social.",null,null,"AM","N","M",{"v":0.011,"d":"1.10%"},"Normal",0.011]
[{"$nulls":10},"AR","C","F",{"v":0.0115,"d":"1.15%"},"Trabajador ocasional (no fijo)",0.0115]
[{"$nulls":11},"P",null,{"v":0.012,"d":"1.20%"},"Asalariado por hora o labora tiempo parcial",0.012]
["Plantilla de Archivo AutoDeterminación",{"$nulls":12},{"v":0.013,"d":"1.30%"},"No laboró mes completo por razones varias",0.013]
["Tipo de Archivo:",null,null,"AM",null,"Ver. 5.3",{"$nulls":8},"Salario prorrateado semanal/bisemanal"]
["RNC o Cédula:",null,null,"00119217743",{"$nulls":10},"Pensionado antes de la Ley 87-01"]
["Período:",null,null,"202507","<-- MMAAAA",{"$nulls":9},"Exento por Ley de pago al SDSS"]
[{"$nulls":14},"Trabajador con salario sectorizado"]
[null,null,"# de Empleados: ",null,"4"]
[null,"TRABAJADORES",{"$nulls":7},"SDSS",{"$nulls":3},"DGII",{"$nulls":6},"INFOTEP"]
[null,"Clave","Tipo","Número","Nombres","1er. Apellido","2do. Apellido","Sexo","Fecha","Salario","Aporte","Salario","Tipo","Otras","RNC/Céd.","Remuneración","Saldo a favor","Regalía Pascual","Preaviso, Cesantía, Viático e Indemminzaciones","Retención Pensión","Salario"]
[null,"Nómina","Doc.","Documento","",{"$nulls":3},"Nacimiento","Cotizable","Voluntario","ISR","Ingreso","Remuneraciones","Agente Ret","Otros Agentes","del período","(Saldo 13)","por Accidentes Laborales","Alimenticia","INFOTEP"]
[null,"1","C","031-0109456-4",{"$nulls":3},"M",null,90000,null,84681,"Normal",{"$nulls":7},90000]
[null,"1","C","031-0109456-5",{"$nulls":3},"M",null,75000,null,70567.5,"Normal",{"$nulls":7},75000]
[null,"1","C","031-0145456-8",{"$nulls":3},"M",null,45000,null,42340.5,"Normal",{"$nulls":7},45000]
[null,"1","C","031-0145456-9",{"$nulls":3},"F",null,65000,null,61158.5,"Normal",{"$nulls":7},65000]

{"sheet":"Plantilla de Bonificación","index":15,"n_rows":19,"n_cols":12,"rows_kept":19,"merged":[[1,6,9,8],[7,0,7,2],[8,0,8,2],[11,1,11,8],[11,10,11,14]]}
[]
[{"$nulls":6},"Cuanto termine de llenar la información de sus empleados, presione el botón \"Generar Archivo\" para generar el archivo que deberá enviar a través de la página de internet de la Tesorería de la Seguridad Social TSS.",null,null,"TDOC","SEXO","TASARL"]
[{"$nulls":9},"N","M",{"v":0.012,"d":"1.2%"}]
[{"$nulls":9},"C","F",{"v":0.013,"d":"1.3%"}]
[{"$nulls":9},"P",null,{"v":0.014,"d":"1.4%"}]
[]
["Plantilla de Archivo de Bonificación INFOTEP",{"$nulls":10},{"v":0.016,"d":"1.6%"}]
["RNC o Cédula:",null,null,"","Ver. 1.4"]
["Período:",null,null,"","<-- MMAAAA"]
[{"$nulls":3},""]
[null,null,"# de Empleados: ",1]
[null,"INFOTEP"]
[null,"Tipo Doc.","Número Doc.","Nombres","1er. Apellido","2do. Apellido","Sexo","Fecha Nacimento","Monto Bonificación"]
[]
[null,"C","031-0109456-4",{"$nulls":3},"M",null,"29481.13"]
[null,"C","031-0109456-5",{"$nulls":3},"M",null,"28301.89"]
[null,"C","031-0145456-8",{"$nulls":3},"M",null,"86477.99"]
[null,"C","031-0145456-9",{"$nulls":3},"M",null,"64465.41"]
[null,"C","031-0109456-4",{"$nulls":3},"M",null,"41273.58"]