{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["IR PNatural","IR PAsalariada","IR SV","Hoja3","Nuevo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"IR PNatural","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"Sal Base","IR",null,"de","a","imp base","porsentaje","exceso"]
[null,55000,{"$f":"IF(AND((B6*12)>=$E$7,(B6*12)<=$F$7),(((((B6*12)-$I$7)*$H$7)+$G$7)/12),IF(AND((B6*12)>=$E$8,(B6*12)<=$F$8),(((((B6*12)-$I$8)*$H$8)+$G$8)/12),IF(AND((B6*12)>=$E$9,(B6*12)<=$F$9),(((((B6*12)-$I$9)*$H$9)+$G$9)/12),IF(AND((B6*12)>=$E$10,(B6*12)<=$F$10),(((((B6*12)-$I$10)*$H$10)+$G$10)/12),IF((B6*12)>=$E$11,(((((B6*12)-$I$11)*$H$11)+$G$11)/12),\"0\")))))","v":11500},null,1,50000,0,0,0]
[null,null,{"$f":"IF(AND((B7*12)>=$E$7,(B7*12)<=$F$7),(((((B7*12)-$I$7)*$H$7)+$G$7)/12),IF(AND((B7*12)>=$E$8,(B7*12)<=$F$8),(((((B7*12)-$I$8)*$H$8)+$G$8)/12),IF(AND((B7*12)>=$E$9,(B7*12)<=$F$9),(((((B7*12)-$I$9)*$H$9)+$G$9)/12),IF(AND((B7*12)>=$E$10,(B7*12)<=$F$10),(((((B7*12)-$I$10)*$H$10)+$G$10)/12),IF((B7*12)>=$E$11,(((((B7*12)-$I$11)*$H$11)+$G$11)/12),\"0\")))))","v":"0"},null,50000.01,100000,0,0.1,50000]
[null,null,"0",null,100000.01,200000,5000,0.15,100000]
[null,null,"0",null,200000.01,300000,20000,0.2,200000]
[null,null,"0",null,300000.01,500000,40000,0.25,300000]
[null,null,"0",null,500000.01,"a más",90000,0.3,500000]
[null,null,"0"]
[null,null,"0"]
[null,null,"0"]
[null,null,"0"]
[null,null,"0"]
[null,null,"0"]
[null,null,"0"]
[null,null,"0"]
[null,null,"0"]

{"sheet":"IR PAsalariada","index":1,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,6,3,10],[3,1,3,4]]}
[]
[]
[]
[null,"CALCULO DE IR",null,null,null,null,"TABLA DEL IR PERSONAS ASALARIADAS"]
[null,"Salario","INSS","S. Base","IR",null,"de","a","imp base","porsentaje","exceso"]
[null,10000,{"$f":"+B6*0.07","v":700.00000000000011},{"$f":"+B6-C6","v":9300},{"$f":"IF(AND((D6*12)>=$G$7,(D6*12)<=$H$7),(((((D6*12)-$K$7)*$J$7)+$I$7)/12),IF(AND((D6*12)>=$G$8,(D6*12)<=$H$8),(((((D6*12)-$K$8)*$J$8)+$I$8)/12),IF(AND((D6*12)>=$G$9,(D6*12)<=$H$9),(((((D6*12)-$K$9)*$J$9)+$I$9)/12),IF((D6*12)>=$G$10,(((((D6*12)-$K$10)*$J$10)+$I$10)/12),\"0\"))))","v":145},null,1,100000,0,0,0]
[null,15000,{"$f":"+B7*0.07","v":1050},{"$f":"+B7-C7","v":13950},{"$f":"IF(AND((D7*12)>=$G$7,(D7*12)<=$H$7),(((((D7*12)-$K$7)*$J$7)+$I$7)/12),IF(AND((D7*12)>=$G$8,(D7*12)<=$H$8),(((((D7*12)-$K$8)*$J$8)+$I$8)/12),IF(AND((D7*12)>=$G$9,(D7*12)<=$H$9),(((((D7*12)-$K$9)*$J$9)+$I$9)/12),IF((D7*12)>=$G$10,(((((D7*12)-$K$10)*$J$10)+$I$10)/12),\"0\"))))","v":842.5},null,100000.01,200000,0,0.15,100000]
[null,20000,1400.0000000000002,18600,{"$f":"IF(AND((D8*12)>=$G$7,(D8*12)<=$H$7),(((((D8*12)-$K$7)*$J$7)+$I$7)/12),IF(AND((D8*12)>=$G$8,(D8*12)<=$H$8),(((((D8*12)-$K$8)*$J$8)+$I$8)/12),IF(AND((D8*12)>=$G$9,(D8*12)<=$H$9),(((((D8*12)-$K$9)*$J$9)+$I$9)/12),IF((D8*12)>=$G$10,(((((D8*12)-$K$10)*$J$10)+$I$10)/12),\"0\"))))","v":1636.6666666666667},null,200000.01,350000,15000,0.2,200000]
[null,25000,1750.0000000000002,23250,2566.6666666666665,null,350000.01,500000,45000,0.25,350000]
[null,30000,2100,27900,3496.6666666666665,null,500000.01,"a más",82500,0.3,500000]
[null,35000,2450.0000000000005,32550,4595.833333333333]
[null,40000,2800.0000000000005,37200,5758.333333333333]
[null,45000,3150.0000000000005,41850,6930]
[null,50000,3500.0000000000005,46500,8325]
[null,55000,3850.0000000000005,51150,9720]
[null,60000,4200,55800,11115]
[null,65000,4550,60450,12510]
[null,70000,4900.0000000000009,65100,13905]
[null,75000,5250.0000000000009,69750,15300]
[null,80000,5600.0000000000009,74400,16695]

{"sheet":"IR SV","index":2,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,1,20,2],[19,3,21,3],[19,4,21,4],[19,5,21,5],[2,2,2,10]]}
[]
[]
[null,null,"IR para personas asalariadas (con salario variable)"]
[]
["Mes","S. Bruto","INSS","Salario N.","Acumulado","Mes","Prom. M.","Exp. Anual","IR","Ret. Acum","Saldo x Ret.","Mes x Ret.","Ret. Mes"]
["ENE",9000,{"$f":"B6*7%","v":630.00000000000011},{"$f":"B6-C6","v":8370},{"$f":"D6","v":8370},1,{"$f":"E6/F6","v":8370},{"$f":"G6*12","v":100440},{"$f":"IF(AND(H6>$B$24,H6<$C$24),(((H6-$F$24)*$E$24)+$D$24),IF(AND(H6>$B$25,H6<$C$25),(((H6-$F$25)*$E$25)+$D$25),IF(AND(H6>$B$26,H6<$C$26),(((H6-$F$26)*$E$26)+$D$26),IF(AND(H6>$B$27,H6<$C$27),(((H6-$F$27)*$E$27)+$D$27),\"0\"))))","v":66},0,{"$f":"I6-J6","v":66},12,{"$f":"K6/L6","v":5.5}]
["FEB",16000,{"$f":"B7*7%","v":1120},14880,{"$f":"E6+D7","v":23250},2,11625,{"$f":"G7*12","v":139500},5925,{"$f":"J6+M6","v":5.5},{"$f":"I7-J7","v":5919.5},11,{"$f":"K7/L7","v":538.13636363636363}]
["MAR",16500,1155,15345,38595,3,12865,154380,8157,{"$f":"J7+M7","v":543.63636363636363},{"$f":"I8-J8","v":7613.363636363636},10,761.33636363636356]
["ABR",17000,1190,15810,54405,4,13601.25,163215,9482.25,1304.9727272727273,8177.2772727272732,9,908.58636363636367]
["MAY",17500,1225.0000000000002,16275,70680,5,14136,169632,10444.799999999999,2213.5590909090911,8231.2409090909077,8,1028.9051136363635]
["JUN",18000,1260.0000000000002,16740,87420,6,14570,174840,11226,3242.4642045454548,7983.5357954545452,7,1140.5051136363636]
["JUL",18500,1295.0000000000002,17205,104625,7,14946.428571428571,179357.14285714284,{"$f":"IF(AND(H12>$B$24,H12<$C$24),(((H12-$F$24)*$E$24)+$D$24),IF(AND(H12>$B$25,H12<$C$25),(((H12-$F$25)*$E$25)+$D$25),IF(AND(H12>$B$26,H12<$C$26),(((H12-$F$26)*$E$26)+$D$26),IF(AND(H12>$B$27,H12<$C$27),(((H12-$F$27)*$E$27)+$D$27),\"0\"))))","v":11903.571428571426},4382.9693181818184,7520.6021103896073,6,1253.4336850649345]
["AGO",19000,1330.0000000000002,17670,122295,8,15286.875,183442.5,12516.375,5636.4030032467526,6879.9719967532474,5,1375.9943993506495]
["SEP",19500,1365.0000000000002,18135,140430,9,15603.333333333334,187240,13086,7012.3974025974021,6073.6025974025979,4,1518.4006493506495]
["OCT",20000,1400.0000000000002,18600,159030,10,15903,190836,13625.4,8530.7980519480516,5094.6019480519481,3,1698.2006493506494]
["NOV",20500,1435.0000000000002,19065,178095,11,16190.454545454546,194285.45454545456,14142.818181818184,10228.9987012987,3913.8194805194835,2,1956.9097402597417]
["DIC",21000,1470.0000000000002,19530,197625,12,16468.75,197625,14643.75,12185.908441558442,2457.8415584415579,1,2457.8415584415579]
["TOTAL",{"$f":"SUM(B6:B17)","v":212500},{"$f":"SUM(C6:C17)","v":14875},{"$f":"SUM(D6:D17)","v":197625},null,null,null,null,null,null,null,null,{"$f":"SUM(M6:M17)","v":14643.75}]
[]
[null,"Renta Gravable (Estratos)",null,"Impuesto Base","Porsentaje aplicable","Sobre Exceso de"]
[]
[null,"De C$","Hasta C$"]
[null,1,100000,0,0,0]
[null,100000.01,200000,0,0.15,100000]
[null,200000.01,350000,15000,0.2,200000]
[null,350000.01,500000,45000,0.25,350000]
[null,500000.01,"a más",82500,0.3,500000]

{"sheet":"Hoja3","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":true,"merged":[[3,1,4,2],[3,3,5,3],[3,4,5,4],[3,5,5,5],[0,1,1,5]]}
[null,"3. Para las personas asalariadas en particular, el impuesto a pagar se calculará de conformidad con la tarifa progresiva sig:"]
[]
[]
[null,"Renta Gravable (Estratos)",null,"Impuesto Base","Porsentaje aplicable","Sobre Exceso de"]
[]
[null,"De C$","Hasta C$"]
[null,1,75000,0,0,0]
[null,75000.009999999995,100000,0,0.1,75000]
[null,100000.01,200000,2500,0.15,100000]
[null,200000.01,300000,17500,0.2,200000]
[null,300000.01,500000,37500,0.25,300000]
[null,500000.01,"a más",87500,0.3,500000]

{"sheet":"Nuevo","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Seleccionar todas las cantidades (salarios) y precionar el botón de Calcular IR"]
[null,"INSS","BASE","IR"]
[10000,700.00000000000011,9300,145]
[15000,1050,13950,842.5]
[20000,1400.0000000000002,18600,1636.6666666666667]
[]
["Seleccionar"]
[25000]
[30000]
[35000]
[40000]
[45000]
[50000]