{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hoja1"],"not_rendered":{"charts":0,"images":4,"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":"Hoja1","index":0,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,3,51,4],[3,3,3,5],[4,3,4,5],[5,4,5,5],[6,4,9,4],[50,3,50,4],[35,3,35,4],[37,3,37,4]]}
[]
[]
[]
[null,null,null,"Aplicación de las deducciones"]
[null,null,null,"básicas de ley (pensionados) - Ley 9796"]
[null,null,null,"Cotización","Renta"]
[null,null,null,287000,"Base Cotizable",929000]
[null,null,null,{"$f":"+D7*8","v":2296000},null,1363000]
[null,null,null,3908496.88,null,2392000,null,null,null," "]
[null,null,null,null,null,4783000]
[null,null,null,null,"Monto de pensión bruta",0,null,null,null,"  "]
[null,null,null,null,"Período","2024-01-01"]
[null,null,null,"Base cotizable","% Cotización","Deducción"]
[null,null,null,{"$f":"D7","v":287000},"**","**"]
[]
[null,null,null,{"$f":"D7*2.8","v":803600},0.1,{"$f":"IF($F$11<=D16,0,IF(AND($F$11>D16),($F$11*0)))","v":0}]
[]
[null,null,null,{"$f":"D7*4","v":1148000},0.12,{"$f":"IF($F$11<=D16,0,IF(AND(D16<$F$11,$F$11<=D18),($F$11-D16)*E18,(D18-D16)*E18))","v":0}]
[]
[null,null,null,{"$f":"D7*6","v":1722000},0.14000000000000001,{"$f":"IF($F$11<=D18,0,IF(AND(D18<$F$11,$F$11<=D20),($F$11-D18)*E20,(D20-D18)*E20))","v":0}]
[]
[null,null,null,{"$f":"D9","v":3908496.88},0.16,{"$f":"IF($F$11<=D20,0,IF(AND(D20<$F$11,$F$11<=D22),($F$11-D20)*E22,(D22-D20)*E22))","v":0}]
[]
[null,null,null,{"$f":"+D7*8","v":2296000},"**","**"]
[]
[null,null,null,{"$f":"D8*1.25","v":2870000},0.25,{"$f":"IF($F$11<=D8,0,IF(AND(D8<$F$11,$F$11<=D26),($F$11-D8)*E26,(D26-D8)*E26))","v":0}]
[]
[null,null,null,{"$f":"D26*1.25","v":3587500},0.35,{"$f":"IF($F$11<=D26,0,IF(AND(D26<$F$11,$F$11<=D28),($F$11-D26)*E28,(D28-D26)*E28))","v":0}]
[]
[null,null,null,{"$f":"D28*1.25","v":4484375},0.45,{"$f":"IF($F$11<=D28,0,IF(AND(D28<$F$11,$F$11<=D30),($F$11-D28)*E30,(D30-D28)*E30))","v":0}]
[]
[null,null,null,{"$f":"D30*1.25","v":5605468.75},0.55000000000000004,{"$f":"IF($F$11<=D30,0,IF(AND(D30<$F$11,$F$11<=D32),($F$11-D30)*E32,(D32-D30)*E32))","v":0}]
[]
[null,null,null,{"$f":"D32*1.25","v":7006835.9375},0.65,{"$f":"IF($F$11<=D32,0,IF(AND(D32<$F$11,$F$11<=D34),($F$11-D32)*E34,(D34-D32)*E34))","v":0}]
[null,null,null,"o más",0.75,{"$f":"IF($F$11<=D34,0,($F$11-D34)*E35)","v":0}]
[null,null,null,"Total deducciones  Art. 70",null,{"$f":"(F16+F18+F20+F22)","v":0}]
[null,null,null,"TOTAL DEDUCCIONES  ART. 71 (Sin Ajuste)",null,{"$f":"(F26+F28+F30+F32+F34+F35)","v":0}]
[null,null,null,"Total deducciones  Art. 71 (ley 9796)",null,{"$f":"IFERROR(IF(IF(G49>0.5,F11*0.5-F36-F45-F47-F48-F49,F37)<=0,0,IF(G49>0.5,F11*0.5-F36-F45-F47-F48-F49,F37)),0)","v":0},null,null,null,null," "]
[null,null,null,null,"Total fondo",{"$f":"ROUND(F36+F38,0)","v":0},null,null," "]
[]
[null,null,null,"Impuesto de renta",0.1,{"$f":"IF($F$11<$F$7,0,IF(AND($F$7<$F$11,$F$11<$F$8),($F$11-$F$7)*$E$41,IF($F$11>$F$8,($F$8-$F$7)*$E$41)))","v":0}]
[null,null,null,null,0.15,{"$f":"IF($F$11<$F$8,0,IF(AND($F$8<$F$11,$F$11<$F$9),($F$11-$F$8)*$E$42,IF($F$11>$F$9,($F$9-$F$8)*$E$42)))","v":0},null,null,"   "]
[null,null,null,null,0.2,{"$f":"IF($F$11<$F$9,0,IF(AND($F$9<$F$11,$F$11<$F$10),($F$11-$F$9)*$E$43,IF($F$11>$F$10,($F$10-$F$9)*$E$43)))","v":0}]
[null,null,null,null,0.25,{"$f":"IF($F$11<$F$10,0,IF(AND($F$10<$F$11,$F$11<$F$10),($F$11-$F$10)*$E$44,IF($F$11>$F$10,($F$11-$F$10)*$E$44)))","v":0}]
[null,null,null,null,"Total fondo",{"$f":"SUM(F41:F44)","v":0}]
[]
[null,null,null,"C.C.S.S.",0.05,{"$f":"E47*F11","v":0}]
[null,null,null,"JUPEMA",5.0000000000000001E-3,{"$f":"E48*F11","v":0},"%Cotizado"]
[null,null,null,"Póliza S.S.V.M.N.",null,19970,{"$f":"+(+F36+F37+F45+F47+F48+F49)/F11","v":{"$error":"#DIV/0!"}},"Sin Ajuste"]
[null,null,null,"Deducciones a terceros",null,0,{"$f":"+(+F36+F38+F45+F47+F48+F49)/F11","v":{"$error":"#DIV/0!"}},"Ajustado"]
[null,null,null,"Total deducciones de ley (según ley 9796)",null,{"$f":"+F36+F38+F45+F47+F48+F49","v":19970}]
[null,null,null,"Pensión líquida (Pensión bruta-Deducción ley-Deducción a terceros)",null,{"$f":"+F11-F51-F50","v":-19970}]