{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Contribución Solidaria","Contribución Solidaria ","Zarela","Alfredo","Oscar","Carlos","Flor M° J. S.","Douglas I. R. R."],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":3,"defined_names":732,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Contribución Solidaria","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[[0,0,0,5],[2,0,2,4],[6,3,6,4],[4,0,4,5],[22,0,22,5],[6,0,6,2],[10,0,10,1],[11,0,11,1],[12,0,12,1],[30,0,30,5],[7,0,7,1],[9,0,9,1],[20,3,20,4],[20,0,20,1],[41,0,41,4],[31,0,31,3],[34,0,34,3],[33,0,33,3],[36,0,36,3],[37,0,37,3],[39,0,39,3],[32,0,32,3],[35,0,35,3],[38,0,38,5],[40,0,40,3]]}
["Matriz para el Cálculo Mensual de la deducción de ley denominada\nContribución Solidaria "]
[]
["Monto Bruto de Asignación Mensual",{"$nulls":4},3059204.56]
[]
["Contribución Solidaria"]
[]
["Datos de Ley para Contribución Solidaria."]
["Cant. De Salarios",null,6]
["Aplica CS",null,"SI"]
["Monto Salario + bajo",null,433800]
["Monto Tope",null,{"$f":"+C10*C8","v":2602800}]
["Monto Tasable",null,{"$f":"+IF(OR(F3<C11,C9=\"no\"),\"N/A\",F3-C11)","v":456404.56000000006}]
["% Contribución Aplicada",null,{"$f":"IF(C12=\"N/A\",0,SUM(F15:F19)/F3)","v":5.2216709561913051E-2}]
["Rangos",0.25,"Limite Inf.","Limite Sup.","Exceso","Aporte"]
["Estrato A",0.35,{"$f":"+C11","v":2602800},{"$f":"+C15*(1+$B$14)","v":3253500},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C15,$F$3<D15),($F$3-C15),IF(AND($F$3>C15,$F$3>D15),D15-C15,0)))","v":456404.56000000006},{"$f":"IF($C$12=\"N/A\",\"\",E15*B15)","v":159741.59600000002}]
["Estrato B",0.4,{"$f":"+D15","v":3253500},{"$f":"+C16*(1+$B$14)","v":4066875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C16,$F$3<D16),($F$3-C16),IF(AND($F$3>C16,$F$3>D16),D16-C16,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E16*B16)","v":0}]
["Estrato C",0.45,{"$f":"+D16","v":4066875},{"$f":"+C17*(1+$B$14)","v":5083593.75},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C17,$F$3<D17),($F$3-C17),IF(AND($F$3>C17,$F$3>D17),D17-C17,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E17*B17)","v":0}]
["Estrato D",0.5,{"$f":"+D17","v":5083593.75},{"$f":"+C18*(1+$B$14)","v":6354492.1875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C18,$F$3<D18),($F$3-C18),IF(AND($F$3>C18,$F$3>D18),D18-C18,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E18*B18)","v":0}]
["Estrato E",0.55000000000000004,{"$f":"+D18","v":6354492.1875},15000000,{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C19,$F$3<D19),($F$3-C19),IF(AND($F$3>C19,$F$3>D19),D19-C19,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E19*B19)","v":0}]
[{"$nulls":4},{"$f":"SUM(E15:E19)","v":456404.56000000006},{"$f":"SUM(F15:F19)","v":159741.59600000002}]
["Contribución Máxima",null,0.55000000000000004,null,null,{"$f":"IF(C9=\"si\",IF((SUM(F15:F19,F33:F38)/F3)>C21,F3*(C21-E32),SUM(F15:F19)),0)","v":-844431.24759999954}]
[]
["Impuesto sobre la Renta"]
["Monto Tasable",{"$f":"+F3-C25","v":2219204.56}]
["Rango 1",0.1,840000,1233000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C25,$F$3<D25),($F$3-C25),IF(AND($F$3>C25,$F$3>D25),D25-C25,0)))","v":393000},{"$f":"IF($C$12=\"N/A\",\"\",E25*B25)","v":39300}]
["Rango 2",0.15,{"$f":"+D25","v":1233000},2163000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C26,$F$3<D26),($F$3-C26),IF(AND($F$3>C26,$F$3>D26),D26-C26,0)))","v":930000},{"$f":"IF($C$12=\"N/A\",\"\",E26*B26)","v":139500}]
["Rango 3",0.2,{"$f":"+D26","v":2163000},4325000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C27,$F$3<D27),($F$3-C27),IF(AND($F$3>C27,$F$3>D27),D27-C27,0)))","v":896204.56},{"$f":"IF($C$12=\"N/A\",\"\",E27*B27)","v":179240.91200000001}]
["Rango 4",0.25,{"$f":"+D27","v":4325000},15000000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C28,$F$3<D28),($F$3-C28),IF(AND($F$3>C28,$F$3>D28),D28-C28,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E28*B28)","v":0}]
[{"$nulls":4},{"$f":"SUM(E24:E28)","v":2219204.56},{"$f":"SUM(F24:F28)","v":358040.91200000001}]
[]
["Total deducciones de Ley"]
["Deducciones de Ley sin contribución:",null,null,null,{"$f":"+SUM(F33:F38)/F3","v":0.82602967733547039}]
["Aporte al Fondo de Jubilaciones y Pensiones PJ (FJPPJ)",null,null,null,0.13,{"$f":"+F3*E33","v":397696.59280000004}]
["Seguro de Enfermedad y Maternidad (C.C.S.S.)",null,null,null,0.05,{"$f":"F3*E34","v":152960.228}]
["Fondo de Socorro Mutuo",null,null,null,500,3000]
["Pensión Alimentaria (en caso que aplique)",{"$nulls":4},1600000]
["Costo de Administración Junta Administradora FJPPJ",null,null,null,5.0000000000000001E-3,{"$f":"+E37*F3","v":15296.022800000001}]
["Impto. sobre la renta",{"$nulls":4},{"$f":"+F29","v":358040.91200000001}]
[]
["Contribución Solidaria",{"$nulls":4},{"$f":"IF(F21<0,0,F21)","v":0}]
["Total deducciones de Ley con contribución",null,null,null,{"$f":"+F41/F3","v":0.82602967733547039},{"$f":"SUM(F33:F40)","v":2526993.7555999998}]
["Monto Neto beneficio",{"$nulls":4},{"$f":"+F3-F41","v":532210.80440000026}]

{"sheet":"Contribución Solidaria ","index":1,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[9,0,9,1],[0,7,0,11],[2,0,2,5],[30,0,30,3],[0,0,0,5],[4,0,4,4],[6,0,6,5],[8,0,8,2],[8,3,8,4],[36,0,36,3],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[22,0,22,1],[22,3,22,4],[24,0,24,5],[32,0,32,5],[33,0,33,3],[34,0,34,3],[35,0,35,3],[44,0,44,4],[37,0,37,3],[38,0,38,3],[39,0,39,3],[40,0,40,5],[41,0,41,3],[42,0,42,3]]}
["Matriz para el Cálculo Mensual de la deducción de ley denominada\nContribución Solidaria ",{"$nulls":6},"Notas Aclaratorias"]
[]
["Favor completar los campos marcados en color verde"]
[]
["Monto Bruto de Asignación Mensual",{"$nulls":4},0]
[]
["Cálculo Contribución Solidaria"]
[]
["Datos de Ley para Contribución Solidaria."]
["Cant. De Salarios",null,6]
["Aplica CS",null,"SI"]
["Monto Salario + bajo",null,433800]
["Monto Tope",null,{"$f":"+C12*C10","v":2602800}]
["Monto Tasable",null,{"$f":"+IF(OR(F5<C13,C11=\"no\"),\"N/A\",F5-C13)","v":"N/A"}]
["% Contribución Aplicada",null,{"$f":"IF(C14=\"N/A\",0,SUM(F17:F21)/F5)","v":0}]
["Rangos",0.25,"Limite Inf.","Limite Sup.","Exceso","Aporte"]
["Estrato A",0.35,{"$f":"+C13","v":2602800},{"$f":"+C17*(1+$B$16)","v":3253500},{"$f":"IF($C$14=\"N/A\",\"\",IF(AND($F$5>C17,$F$5<D17),($F$5-C17),IF(AND($F$5>C17,$F$5>D17),D17-C17,0)))","v":""},{"$f":"IF($C$14=\"N/A\",\"\",E17*B17)","v":""}]
["Estrato B",0.4,{"$f":"+D17","v":3253500},{"$f":"+C18*(1+$B$16)","v":4066875},{"$f":"IF($C$14=\"N/A\",\"\",IF(AND($F$5>C18,$F$5<D18),($F$5-C18),IF(AND($F$5>C18,$F$5>D18),D18-C18,0)))","v":""},{"$f":"IF($C$14=\"N/A\",\"\",E18*B18)","v":""}]
["Estrato C",0.45,{"$f":"+D18","v":4066875},{"$f":"+C19*(1+$B$16)","v":5083593.75},{"$f":"IF($C$14=\"N/A\",\"\",IF(AND($F$5>C19,$F$5<D19),($F$5-C19),IF(AND($F$5>C19,$F$5>D19),D19-C19,0)))","v":""},{"$f":"IF($C$14=\"N/A\",\"\",E19*B19)","v":""}]
["Estrato D",0.5,{"$f":"+D19","v":5083593.75},{"$f":"+C20*(1+$B$16)","v":6354492.1875},{"$f":"IF($C$14=\"N/A\",\"\",IF(AND($F$5>C20,$F$5<D20),($F$5-C20),IF(AND($F$5>C20,$F$5>D20),D20-C20,0)))","v":""},{"$f":"IF($C$14=\"N/A\",\"\",E20*B20)","v":""}]
["Estrato E",0.55000000000000004,{"$f":"+D20","v":6354492.1875},15000000,{"$f":"IF($C$14=\"N/A\",\"\",IF(AND($F$5>C21,$F$5<D21),($F$5-C21),IF(AND($F$5>C21,$F$5>D21),D21-C21,0)))","v":""},{"$f":"IF($C$14=\"N/A\",\"\",E21*B21)","v":""}]
[{"$nulls":4},{"$f":"SUM(E17:E21)","v":0},{"$f":"SUM(F17:F21)","v":0}]
["Contribución Máxima",null,0.55000000000000004,null,null,{"$f":"_xlfn.IFS(F5*(C23-E34)<0,0,(SUM(F17:F21,F35:F40)/F5)>C23,F5*(C23-E34),(SUM(F17:F21,F35:F40)/F5)<C23,SUM(F17:F21))","v":{"$error":"#DIV/0!"}}]
[]
["Cálculo Impuesto sobre la Renta"]
["Monto a aplicar renta",null,{"$f":"+F5-C27","v":-840000}]
["Tope 1",0.1,840000,1233000,{"$f":"IF($C$26=\"N/A\",\"\",IF(AND($F$5>C27,$F$5<D27),($F$5-C27),IF(AND($F$5>C27,$F$5>D27),D27-C27,0)))","v":0},{"$f":"IF($C$14=\"N/A\",\"\",E27*B27)","v":""}]
["Tope 2",0.15,{"$f":"+D27","v":1233000},2163000,{"$f":"IF($C$26=\"N/A\",\"\",IF(AND($F$5>C28,$F$5<D28),($F$5-C28),IF(AND($F$5>C28,$F$5>D28),D28-C28,0)))","v":0},{"$f":"IF($C$14=\"N/A\",\"\",E28*B28)","v":""}]
["Tope 3",0.2,{"$f":"+D28","v":2163000},4325000,{"$f":"IF($C$26=\"N/A\",\"\",IF(AND($F$5>C29,$F$5<D29),($F$5-C29),IF(AND($F$5>C29,$F$5>D29),D29-C29,0)))","v":0},{"$f":"IF($C$14=\"N/A\",\"\",E29*B29)","v":""}]
["Tope 4",0.25,{"$f":"+D29","v":4325000},15000000,{"$f":"IF($C$26=\"N/A\",\"\",IF(AND($F$5>C30,$F$5<D30),($F$5-C30),IF(AND($F$5>C30,$F$5>D30),D30-C30,0)))","v":0},{"$f":"IF($C$14=\"N/A\",\"\",E30*B30)","v":""}]
["Totales",null,null,null,{"$f":"SUM(E26:E30)","v":0},{"$f":"SUM(F26:F30)","v":0}]
[]
["Total deducciones de Ley"]
["Deducciones de Ley sin contribución:",null,null,null,{"$f":"+SUM(F35:F40)/F5","v":{"$error":"#DIV/0!"}}]
["Aporte al Fondo de Jubilaciones y Pensiones PJ (FJPPJ)",null,null,null,0.13,{"$f":"+F5*E35","v":0}]
["Seguro de Enfermedad y Maternidad (C.C.S.S.)",null,null,null,0.05,{"$f":"F5*E36","v":0}]
["Fondo de Socorro Mutuo",null,null,null,500,3000]
["Pensión Alimentaria (en caso que aplique)"]
["Costo de Administración Junta Administradora FJPPJ",null,null,null,5.0000000000000001E-3,{"$f":"+E39*F5","v":0}]
["Impto. sobre la renta",{"$nulls":4},{"$f":"+F31","v":0}]
[]
["Contribución Solidaria",{"$nulls":4},{"$f":"+F23","v":{"$error":"#DIV/0!"}}]
["Total deducciones de Ley con Contribución Solidaria",null,null,null,{"$f":"+F43/F5","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F35:F42)","v":{"$error":"#DIV/0!"}}]
[]
["Monto Neto beneficio",{"$nulls":4},{"$f":"+F5-F43","v":{"$error":"#DIV/0!"}}]

{"sheet":"Zarela","index":2,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[[41,0,41,4],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,5],[39,0,39,3],[40,0,40,3],[34,0,34,3],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[20,0,20,1],[20,3,20,4],[22,0,22,5],[30,0,30,5],[31,0,31,3],[32,0,32,3],[33,0,33,3],[7,0,7,1],[0,0,0,5],[2,0,2,4],[4,0,4,5],[6,0,6,2],[6,3,6,4]]}
["Matriz para el Cálculo Mensual de la deducción de ley denominada\nContribución Solidaria "]
[]
["Monto Bruto de Asignación Mensual",{"$nulls":4},10284977.640000001]
[]
["Contribución Solidaria"]
[]
["Datos de Ley para Contribución Solidaria."]
["Cant. De Salarios",null,6]
["Aplica CS",null,"SI"]
["Monto Salario + bajo",null,433800]
["Monto Tope",null,{"$f":"+C10*C8","v":2602800}]
["Monto Tasable",null,{"$f":"+IF(OR(F3<C11,C9=\"no\"),\"N/A\",F3-C11)","v":7682177.6400000006}]
["% Contribución Aplicada",null,{"$f":"IF(C12=\"N/A\",0,SUM(F15:F19)/F3)","v":0.37023266247227354}]
["Rangos",0.25,"Limite Inf.","Limite Sup.","Exceso","Aporte"]
["Estrato A",0.35,{"$f":"+C11","v":2602800},{"$f":"+C15*(1+$B$14)","v":3253500},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C15,$F$3<D15),($F$3-C15),IF(AND($F$3>C15,$F$3>D15),D15-C15,0)))","v":650700},{"$f":"IF($C$12=\"N/A\",\"\",E15*B15)","v":227745}]
["Estrato B",0.4,{"$f":"+D15","v":3253500},{"$f":"+C16*(1+$B$14)","v":4066875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C16,$F$3<D16),($F$3-C16),IF(AND($F$3>C16,$F$3>D16),D16-C16,0)))","v":813375},{"$f":"IF($C$12=\"N/A\",\"\",E16*B16)","v":325350}]
["Estrato C",0.45,{"$f":"+D16","v":4066875},{"$f":"+C17*(1+$B$14)","v":5083593.75},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C17,$F$3<D17),($F$3-C17),IF(AND($F$3>C17,$F$3>D17),D17-C17,0)))","v":1016718.75},{"$f":"IF($C$12=\"N/A\",\"\",E17*B17)","v":457523.4375}]
["Estrato D",0.5,{"$f":"+D17","v":5083593.75},{"$f":"+C18*(1+$B$14)","v":6354492.1875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C18,$F$3<D18),($F$3-C18),IF(AND($F$3>C18,$F$3>D18),D18-C18,0)))","v":1270898.4375},{"$f":"IF($C$12=\"N/A\",\"\",E18*B18)","v":635449.21875}]
["Estrato E",0.55000000000000004,{"$f":"+D18","v":6354492.1875},15000000,{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C19,$F$3<D19),($F$3-C19),IF(AND($F$3>C19,$F$3>D19),D19-C19,0)))","v":3930485.4525000006},{"$f":"IF($C$12=\"N/A\",\"\",E19*B19)","v":2161766.9988750005}]
[{"$nulls":4},{"$f":"SUM(E15:E19)","v":7682177.6400000006},{"$f":"SUM(F15:F19)","v":3807834.6551250005}]
["Contribución Máxima",null,0.55000000000000004,null,null,{"$f":"_xlfn.IFS(F3*(C21-E32)<0,0,(SUM(F15:F19,F33:F38)/F3)>C21,F3*(C21-E32),(SUM(F15:F19,F33:F38)/F3)<C21,SUM(F15:F19))","v":1649822.4286000005}]
[]
["Impuesto sobre la Renta"]
["Monto Tasable",{"$f":"+F3-C25","v":9444977.6400000006}]
["Rango 1",0.1,840000,1233000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C25,$F$3<D25),($F$3-C25),IF(AND($F$3>C25,$F$3>D25),D25-C25,0)))","v":393000},{"$f":"IF($C$12=\"N/A\",\"\",E25*B25)","v":39300}]
["Rango 2",0.15,{"$f":"+D25","v":1233000},2163000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C26,$F$3<D26),($F$3-C26),IF(AND($F$3>C26,$F$3>D26),D26-C26,0)))","v":930000},{"$f":"IF($C$12=\"N/A\",\"\",E26*B26)","v":139500}]
["Rango 3",0.2,{"$f":"+D26","v":2163000},4325000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C27,$F$3<D27),($F$3-C27),IF(AND($F$3>C27,$F$3>D27),D27-C27,0)))","v":2162000},{"$f":"IF($C$12=\"N/A\",\"\",E27*B27)","v":432400}]
["Rango 4",0.25,{"$f":"+D27","v":4325000},15000000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C28,$F$3<D28),($F$3-C28),IF(AND($F$3>C28,$F$3>D28),D28-C28,0)))","v":5959977.6400000006},{"$f":"IF($C$12=\"N/A\",\"\",E28*B28)","v":1489994.4100000001}]
[{"$nulls":4},{"$f":"SUM(E24:E28)","v":9444977.6400000006},{"$f":"SUM(F24:F28)","v":2101194.41}]
[]
["Total deducciones de Ley"]
["Deducciones de Ley sin contribución:",null,null,null,{"$f":"+SUM(F33:F38)/F3","v":0.3895891088587724}]
["Aporte al Fondo de Jubilaciones y Pensiones PJ (FJPPJ)",null,null,null,0.13,{"$f":"+F3*E33","v":1337047.0932000002}]
["Seguro de Enfermedad y Maternidad (C.C.S.S.)",null,null,null,0.05,{"$f":"F3*E34","v":514248.88200000004}]
["Fondo de Socorro Mutuo",null,null,null,500,3000]
["Pensión Alimentaria (en caso que aplique)",{"$nulls":4},0]
["Costo de Administración Junta Administradora FJPPJ",null,null,null,5.0000000000000001E-3,{"$f":"+E37*F3","v":51424.888200000001}]
["Impto. sobre la renta",{"$nulls":4},{"$f":"+F29","v":2101194.41}]
[]
["Contribución Solidaria",{"$nulls":4},{"$f":"IF(F21<0,0,F21)","v":1649822.4286000005}]
["Total deducciones de Ley con contribución",null,null,null,{"$f":"+F41/F3","v":0.55000000000000004},{"$f":"SUM(F33:F40)","v":5656737.7020000005}]
["Monto Neto beneficio",{"$nulls":4},{"$f":"+F3-F41","v":4628239.9380000001}]

{"sheet":"Alfredo","index":3,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[[41,0,41,4],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,5],[39,0,39,3],[40,0,40,3],[34,0,34,3],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[20,0,20,1],[20,3,20,4],[22,0,22,5],[30,0,30,5],[31,0,31,3],[32,0,32,3],[33,0,33,3],[7,0,7,1],[0,0,0,5],[2,0,2,4],[4,0,4,5],[6,0,6,2],[6,3,6,4]]}
["Matriz para el Cálculo Mensual de la deducción de ley denominada\nContribución Solidaria "]
[]
["Monto Bruto de Asignación Mensual",{"$nulls":4},5263371.5]
[]
["Contribución Solidaria"]
[]
["Datos de Ley para Contribución Solidaria."]
["Cant. De Salarios",null,6]
["Aplica CS",null,"SI"]
["Monto Salario + bajo",null,433800]
["Monto Tope",null,{"$f":"+C10*C8","v":2602800}]
["Monto Tasable",null,{"$f":"+IF(OR(F3<C11,C9=\"no\"),\"N/A\",F3-C11)","v":2660571.5}]
["% Contribución Aplicada",null,{"$f":"IF(C12=\"N/A\",0,SUM(F15:F19)/F3)","v":0.20908790354243473}]
["Rangos",0.25,"Limite Inf.","Limite Sup.","Exceso","Aporte"]
["Estrato A",0.35,{"$f":"+C11","v":2602800},{"$f":"+C15*(1+$B$14)","v":3253500},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C15,$F$3<D15),($F$3-C15),IF(AND($F$3>C15,$F$3>D15),D15-C15,0)))","v":650700},{"$f":"IF($C$12=\"N/A\",\"\",E15*B15)","v":227745}]
["Estrato B",0.4,{"$f":"+D15","v":3253500},{"$f":"+C16*(1+$B$14)","v":4066875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C16,$F$3<D16),($F$3-C16),IF(AND($F$3>C16,$F$3>D16),D16-C16,0)))","v":813375},{"$f":"IF($C$12=\"N/A\",\"\",E16*B16)","v":325350}]
["Estrato C",0.45,{"$f":"+D16","v":4066875},{"$f":"+C17*(1+$B$14)","v":5083593.75},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C17,$F$3<D17),($F$3-C17),IF(AND($F$3>C17,$F$3>D17),D17-C17,0)))","v":1016718.75},{"$f":"IF($C$12=\"N/A\",\"\",E17*B17)","v":457523.4375}]
["Estrato D",0.5,{"$f":"+D17","v":5083593.75},{"$f":"+C18*(1+$B$14)","v":6354492.1875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C18,$F$3<D18),($F$3-C18),IF(AND($F$3>C18,$F$3>D18),D18-C18,0)))","v":179777.75},{"$f":"IF($C$12=\"N/A\",\"\",E18*B18)","v":89888.875}]
["Estrato E",0.55000000000000004,{"$f":"+D18","v":6354492.1875},15000000,{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C19,$F$3<D19),($F$3-C19),IF(AND($F$3>C19,$F$3>D19),D19-C19,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E19*B19)","v":0}]
[{"$nulls":4},{"$f":"SUM(E15:E19)","v":2660571.5},{"$f":"SUM(F15:F19)","v":1100507.3125}]
["Contribución Máxima",null,0.55000000000000004,null,null,{"$f":"_xlfn.IFS(F3*(C21-E32)<0,0,(SUM(F15:F19,F33:F38)/F3)>C21,F3*(C21-E32),(SUM(F15:F19,F33:F38)/F3)<C21,SUM(F15:F19))","v":1072337.7225000001}]
[]
["Impuesto sobre la Renta"]
["Monto Tasable",{"$f":"+F3-C25","v":4423371.5}]
["Rango 1",0.1,840000,1233000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C25,$F$3<D25),($F$3-C25),IF(AND($F$3>C25,$F$3>D25),D25-C25,0)))","v":393000},{"$f":"IF($C$12=\"N/A\",\"\",E25*B25)","v":39300}]
["Rango 2",0.15,{"$f":"+D25","v":1233000},2163000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C26,$F$3<D26),($F$3-C26),IF(AND($F$3>C26,$F$3>D26),D26-C26,0)))","v":930000},{"$f":"IF($C$12=\"N/A\",\"\",E26*B26)","v":139500}]
["Rango 3",0.2,{"$f":"+D26","v":2163000},4325000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C27,$F$3<D27),($F$3-C27),IF(AND($F$3>C27,$F$3>D27),D27-C27,0)))","v":2162000},{"$f":"IF($C$12=\"N/A\",\"\",E27*B27)","v":432400}]
["Rango 4",0.25,{"$f":"+D27","v":4325000},15000000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C28,$F$3<D28),($F$3-C28),IF(AND($F$3>C28,$F$3>D28),D28-C28,0)))","v":938371.5},{"$f":"IF($C$12=\"N/A\",\"\",E28*B28)","v":234592.875}]
[{"$nulls":4},{"$f":"SUM(E24:E28)","v":4423371.5},{"$f":"SUM(F24:F28)","v":845792.875}]
[]
["Total deducciones de Ley"]
["Deducciones de Ley sin contribución:",null,null,null,{"$f":"+SUM(F33:F38)/F3","v":0.34626410134644686}]
["Aporte al Fondo de Jubilaciones y Pensiones PJ (FJPPJ)",null,null,null,0.13,{"$f":"+F3*E33","v":684238.29500000004}]
["Seguro de Enfermedad y Maternidad (C.C.S.S.)",null,null,null,0.05,{"$f":"F3*E34","v":263168.57500000001}]
["Fondo de Socorro Mutuo",null,null,null,500,3000]
["Pensión Alimentaria (en caso que aplique)",{"$nulls":4},0]
["Costo de Administración Junta Administradora FJPPJ",null,null,null,5.0000000000000001E-3,{"$f":"+E37*F3","v":26316.857500000002}]
["Impto. sobre la renta",{"$nulls":4},{"$f":"+F29","v":845792.875}]
[]
["Contribución Solidaria",{"$nulls":4},{"$f":"IF(F21<0,0,F21)","v":1072337.7225000001}]
["Total deducciones de Ley con contribución",null,null,null,{"$f":"+F41/F3","v":0.55000000000000004},{"$f":"SUM(F33:F40)","v":2894854.3250000002}]
["Monto Neto beneficio",{"$nulls":4},{"$f":"+F3-F41","v":2368517.1749999998}]

{"sheet":"Oscar","index":4,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[[41,0,41,4],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,5],[39,0,39,3],[40,0,40,3],[34,0,34,3],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[20,0,20,1],[20,3,20,4],[22,0,22,5],[30,0,30,5],[31,0,31,3],[32,0,32,3],[33,0,33,3],[7,0,7,1],[0,0,0,5],[2,0,2,4],[4,0,4,5],[6,0,6,2],[6,3,6,4]]}
["Matriz para el Cálculo Mensual de la deducción de ley denominada\nContribución Solidaria "]
[]
["Monto Bruto de Asignación Mensual",{"$nulls":4},3048795.8]
[]
["Contribución Solidaria"]
[]
["Datos de Ley para Contribución Solidaria."]
["Cant. De Salarios",null,6]
["Aplica CS",null,"SI"]
["Monto Salario + bajo",null,433800]
["Monto Tope",null,{"$f":"+C10*C8","v":2602800}]
["Monto Tasable",null,{"$f":"+IF(OR(F3<C11,C9=\"no\"),\"N/A\",F3-C11)","v":445995.79999999981}]
["% Contribución Aplicada",null,{"$f":"IF(C12=\"N/A\",0,SUM(F15:F19)/F3)","v":5.1200060692815151E-2}]
["Rangos",0.25,"Limite Inf.","Limite Sup.","Exceso","Aporte"]
["Estrato A",0.35,{"$f":"+C11","v":2602800},{"$f":"+C15*(1+$B$14)","v":3253500},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C15,$F$3<D15),($F$3-C15),IF(AND($F$3>C15,$F$3>D15),D15-C15,0)))","v":445995.79999999981},{"$f":"IF($C$12=\"N/A\",\"\",E15*B15)","v":156098.52999999991}]
["Estrato B",0.4,{"$f":"+D15","v":3253500},{"$f":"+C16*(1+$B$14)","v":4066875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C16,$F$3<D16),($F$3-C16),IF(AND($F$3>C16,$F$3>D16),D16-C16,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E16*B16)","v":0}]
["Estrato C",0.45,{"$f":"+D16","v":4066875},{"$f":"+C17*(1+$B$14)","v":5083593.75},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C17,$F$3<D17),($F$3-C17),IF(AND($F$3>C17,$F$3>D17),D17-C17,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E17*B17)","v":0}]
["Estrato D",0.5,{"$f":"+D17","v":5083593.75},{"$f":"+C18*(1+$B$14)","v":6354492.1875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C18,$F$3<D18),($F$3-C18),IF(AND($F$3>C18,$F$3>D18),D18-C18,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E18*B18)","v":0}]
["Estrato E",0.55000000000000004,{"$f":"+D18","v":6354492.1875},15000000,{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C19,$F$3<D19),($F$3-C19),IF(AND($F$3>C19,$F$3>D19),D19-C19,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E19*B19)","v":0}]
[{"$nulls":4},{"$f":"SUM(E15:E19)","v":445995.79999999981},{"$f":"SUM(F15:F19)","v":156098.52999999991}]
["Contribución Máxima",null,0.55000000000000004,null,null,{"$f":"_xlfn.IFS(F3*(C21-E32)<0,0,(SUM(F15:F19,F33:F38)/F3)>C21,F3*(C21-E32),(SUM(F15:F19,F33:F38)/F3)<C21,SUM(F15:F19))","v":156098.52999999991}]
[]
["Impuesto sobre la Renta"]
["Monto Tasable",{"$f":"+F3-C25","v":2208795.7999999998}]
["Rango 1",0.1,840000,1233000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C25,$F$3<D25),($F$3-C25),IF(AND($F$3>C25,$F$3>D25),D25-C25,0)))","v":393000},{"$f":"IF($C$12=\"N/A\",\"\",E25*B25)","v":39300}]
["Rango 2",0.15,{"$f":"+D25","v":1233000},2163000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C26,$F$3<D26),($F$3-C26),IF(AND($F$3>C26,$F$3>D26),D26-C26,0)))","v":930000},{"$f":"IF($C$12=\"N/A\",\"\",E26*B26)","v":139500}]
["Rango 3",0.2,{"$f":"+D26","v":2163000},4325000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C27,$F$3<D27),($F$3-C27),IF(AND($F$3>C27,$F$3>D27),D27-C27,0)))","v":885795.79999999981},{"$f":"IF($C$12=\"N/A\",\"\",E27*B27)","v":177159.15999999997}]
["Rango 4",0.25,{"$f":"+D27","v":4325000},15000000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C28,$F$3<D28),($F$3-C28),IF(AND($F$3>C28,$F$3>D28),D28-C28,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E28*B28)","v":0}]
[{"$nulls":4},{"$f":"SUM(E24:E28)","v":2208795.7999999998},{"$f":"SUM(F24:F28)","v":355959.16}]
[]
["Total deducciones de Ley"]
["Deducciones de Ley sin contribución:",null,null,null,{"$f":"+SUM(F33:F38)/F3","v":0.30273801315260274}]
["Aporte al Fondo de Jubilaciones y Pensiones PJ (FJPPJ)",null,null,null,0.13,{"$f":"+F3*E33","v":396343.45399999997}]
["Seguro de Enfermedad y Maternidad (C.C.S.S.)",null,null,null,0.05,{"$f":"F3*E34","v":152439.79}]
["Fondo de Socorro Mutuo",null,null,null,500,3000]
["Pensión Alimentaria (en caso que aplique)",{"$nulls":4},0]
["Costo de Administración Junta Administradora FJPPJ",null,null,null,5.0000000000000001E-3,{"$f":"+E37*F3","v":15243.978999999999}]
["Impto. sobre la renta",{"$nulls":4},{"$f":"+F29","v":355959.16}]
[]
["Contribución Solidaria",{"$nulls":4},{"$f":"+F21","v":156098.52999999991}]
["Total deducciones de Ley con contribución",null,null,null,{"$f":"+F41/F3","v":0.35393807384541787},{"$f":"SUM(F33:F40)","v":1079084.9129999997}]
["Monto Neto beneficio",{"$nulls":4},{"$f":"+F3-F41","v":1969710.8870000001}]

{"sheet":"Carlos","index":5,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[[41,0,41,4],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,5],[39,0,39,3],[40,0,40,3],[34,0,34,3],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[20,0,20,1],[20,3,20,4],[22,0,22,5],[30,0,30,5],[31,0,31,3],[32,0,32,3],[33,0,33,3],[7,0,7,1],[0,0,0,5],[2,0,2,4],[4,0,4,5],[6,0,6,2],[6,3,6,4]]}
["Matriz para el Cálculo Mensual de la deducción de ley denominada\nContribución Solidaria "]
[]
["Monto Bruto de Asignación Mensual",{"$nulls":4},3179434.36]
[]
["Contribución Solidaria"]
[]
["Datos de Ley para Contribución Solidaria."]
["Cant. De Salarios",null,6]
["Aplica CS",null,"SI"]
["Monto Salario + bajo",null,433800]
["Monto Tope",null,{"$f":"+C10*C8","v":2602800}]
["Monto Tasable",null,{"$f":"+IF(OR(F3<C11,C9=\"no\"),\"N/A\",F3-C11)","v":576634.35999999987}]
["% Contribución Aplicada",null,{"$f":"IF(C12=\"N/A\",0,SUM(F15:F19)/F3)","v":6.3477336893346017E-2}]
["Rangos",0.25,"Limite Inf.","Limite Sup.","Exceso","Aporte"]
["Estrato A",0.35,{"$f":"+C11","v":2602800},{"$f":"+C15*(1+$B$14)","v":3253500},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C15,$F$3<D15),($F$3-C15),IF(AND($F$3>C15,$F$3>D15),D15-C15,0)))","v":576634.35999999987},{"$f":"IF($C$12=\"N/A\",\"\",E15*B15)","v":201822.02599999995}]
["Estrato B",0.4,{"$f":"+D15","v":3253500},{"$f":"+C16*(1+$B$14)","v":4066875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C16,$F$3<D16),($F$3-C16),IF(AND($F$3>C16,$F$3>D16),D16-C16,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E16*B16)","v":0}]
["Estrato C",0.45,{"$f":"+D16","v":4066875},{"$f":"+C17*(1+$B$14)","v":5083593.75},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C17,$F$3<D17),($F$3-C17),IF(AND($F$3>C17,$F$3>D17),D17-C17,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E17*B17)","v":0}]
["Estrato D",0.5,{"$f":"+D17","v":5083593.75},{"$f":"+C18*(1+$B$14)","v":6354492.1875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C18,$F$3<D18),($F$3-C18),IF(AND($F$3>C18,$F$3>D18),D18-C18,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E18*B18)","v":0}]
["Estrato E",0.55000000000000004,{"$f":"+D18","v":6354492.1875},15000000,{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C19,$F$3<D19),($F$3-C19),IF(AND($F$3>C19,$F$3>D19),D19-C19,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E19*B19)","v":0}]
[{"$nulls":4},{"$f":"SUM(E15:E19)","v":576634.35999999987},{"$f":"SUM(F15:F19)","v":201822.02599999995}]
["Contribución Máxima",null,0.55000000000000004,null,null,{"$f":"_xlfn.IFS(F3*(C21-E32)<0,0,(SUM(F15:F19,F33:F38)/F3)>C21,F3*(C21-E32),(SUM(F15:F19,F33:F38)/F3)<C21,SUM(F15:F19))","v":201822.02599999995}]
[]
["Impuesto sobre la Renta"]
["Monto Tasable",{"$f":"+F3-C25","v":2339434.36}]
["Rango 1",0.1,840000,1233000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C25,$F$3<D25),($F$3-C25),IF(AND($F$3>C25,$F$3>D25),D25-C25,0)))","v":393000},{"$f":"IF($C$12=\"N/A\",\"\",E25*B25)","v":39300}]
["Rango 2",0.15,{"$f":"+D25","v":1233000},2163000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C26,$F$3<D26),($F$3-C26),IF(AND($F$3>C26,$F$3>D26),D26-C26,0)))","v":930000},{"$f":"IF($C$12=\"N/A\",\"\",E26*B26)","v":139500}]
["Rango 3",0.2,{"$f":"+D26","v":2163000},4325000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C27,$F$3<D27),($F$3-C27),IF(AND($F$3>C27,$F$3>D27),D27-C27,0)))","v":1016434.3599999999},{"$f":"IF($C$12=\"N/A\",\"\",E27*B27)","v":203286.87199999997}]
["Rango 4",0.25,{"$f":"+D27","v":4325000},15000000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C28,$F$3<D28),($F$3-C28),IF(AND($F$3>C28,$F$3>D28),D28-C28,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E28*B28)","v":0}]
[{"$nulls":4},{"$f":"SUM(E24:E28)","v":2339434.36},{"$f":"SUM(F24:F28)","v":382086.87199999997}]
[]
["Total deducciones de Ley"]
["Deducciones de Ley sin contribución:",null,null,null,{"$f":"+SUM(F33:F38)/F3","v":0.30611804440586093}]
["Aporte al Fondo de Jubilaciones y Pensiones PJ (FJPPJ)",null,null,null,0.13,{"$f":"+F3*E33","v":413326.46679999999}]
["Seguro de Enfermedad y Maternidad (C.C.S.S.)",null,null,null,0.05,{"$f":"F3*E34","v":158971.71799999999}]
["Fondo de Socorro Mutuo",null,null,null,500,3000]
["Pensión Alimentaria (en caso que aplique)",{"$nulls":4},0]
["Costo de Administración Junta Administradora FJPPJ",null,null,null,5.0000000000000001E-3,{"$f":"+E37*F3","v":15897.1718}]
["Impto. sobre la renta",{"$nulls":4},{"$f":"+F29","v":382086.87199999997}]
[]
["Contribución Solidaria",{"$nulls":4},{"$f":"+F21","v":201822.02599999995}]
["Total deducciones de Ley con contribución",null,null,null,{"$f":"+F41/F3","v":0.36959538129920694},{"$f":"SUM(F33:F40)","v":1175104.2545999999}]
["Monto Neto beneficio",{"$nulls":4},{"$f":"+F3-F41","v":2004330.1054}]

{"sheet":"Flor M° J. S.","index":6,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[[41,0,41,4],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,5],[39,0,39,3],[40,0,40,3],[34,0,34,3],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[20,0,20,1],[20,3,20,4],[22,0,22,5],[30,0,30,5],[31,0,31,3],[32,0,32,3],[33,0,33,3],[7,0,7,1],[0,0,0,5],[2,0,2,4],[4,0,4,5],[6,0,6,2],[6,3,6,4]]}
["Matriz para el Cálculo Mensual de la deducción de ley denominada\nContribución Solidaria "]
[]
["Monto Bruto de Asignación Mensual",{"$nulls":4},3059204.56]
[]
["Contribución Solidaria"]
[]
["Datos de Ley para Contribución Solidaria."]
["Cant. De Salarios",null,6]
["Aplica CS",null,"SI"]
["Monto Salario + bajo",null,433800]
["Monto Tope",null,{"$f":"+C10*C8","v":2602800}]
["Monto Tasable",null,{"$f":"+IF(OR(F3<C11,C9=\"no\"),\"N/A\",F3-C11)","v":456404.56000000006}]
["% Contribución Aplicada",null,{"$f":"IF(C12=\"N/A\",0,SUM(F15:F19)/F3)","v":5.2216709561913051E-2}]
["Rangos",0.25,"Limite Inf.","Limite Sup.","Exceso","Aporte"]
["Estrato A",0.35,{"$f":"+C11","v":2602800},{"$f":"+C15*(1+$B$14)","v":3253500},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C15,$F$3<D15),($F$3-C15),IF(AND($F$3>C15,$F$3>D15),D15-C15,0)))","v":456404.56000000006},{"$f":"IF($C$12=\"N/A\",\"\",E15*B15)","v":159741.59600000002}]
["Estrato B",0.4,{"$f":"+D15","v":3253500},{"$f":"+C16*(1+$B$14)","v":4066875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C16,$F$3<D16),($F$3-C16),IF(AND($F$3>C16,$F$3>D16),D16-C16,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E16*B16)","v":0}]
["Estrato C",0.45,{"$f":"+D16","v":4066875},{"$f":"+C17*(1+$B$14)","v":5083593.75},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C17,$F$3<D17),($F$3-C17),IF(AND($F$3>C17,$F$3>D17),D17-C17,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E17*B17)","v":0}]
["Estrato D",0.5,{"$f":"+D17","v":5083593.75},{"$f":"+C18*(1+$B$14)","v":6354492.1875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C18,$F$3<D18),($F$3-C18),IF(AND($F$3>C18,$F$3>D18),D18-C18,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E18*B18)","v":0}]
["Estrato E",0.55000000000000004,{"$f":"+D18","v":6354492.1875},15000000,{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C19,$F$3<D19),($F$3-C19),IF(AND($F$3>C19,$F$3>D19),D19-C19,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E19*B19)","v":0}]
[{"$nulls":4},{"$f":"SUM(E15:E19)","v":456404.56000000006},{"$f":"SUM(F15:F19)","v":159741.59600000002}]
["Contribución Máxima",null,0.55000000000000004,null,null,{"$f":"_xlfn.IFS(F3*(C21-E32)<0,0,(SUM(F15:F19,F33:F38)/F3)>C21,F3*(C21-E32),(SUM(F15:F19,F33:F38)/F3)<C21,SUM(F15:F19))","v":0}]
[]
["Impuesto sobre la Renta"]
["Monto Tasable",{"$f":"+F3-C25","v":2219204.56}]
["Rango 1",0.1,840000,1233000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C25,$F$3<D25),($F$3-C25),IF(AND($F$3>C25,$F$3>D25),D25-C25,0)))","v":393000},{"$f":"IF($C$12=\"N/A\",\"\",E25*B25)","v":39300}]
["Rango 2",0.15,{"$f":"+D25","v":1233000},2163000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C26,$F$3<D26),($F$3-C26),IF(AND($F$3>C26,$F$3>D26),D26-C26,0)))","v":930000},{"$f":"IF($C$12=\"N/A\",\"\",E26*B26)","v":139500}]
["Rango 3",0.2,{"$f":"+D26","v":2163000},4325000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C27,$F$3<D27),($F$3-C27),IF(AND($F$3>C27,$F$3>D27),D27-C27,0)))","v":896204.56},{"$f":"IF($C$12=\"N/A\",\"\",E27*B27)","v":179240.91200000001}]
["Rango 4",0.25,{"$f":"+D27","v":4325000},15000000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C28,$F$3<D28),($F$3-C28),IF(AND($F$3>C28,$F$3>D28),D28-C28,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E28*B28)","v":0}]
[{"$nulls":4},{"$f":"SUM(E24:E28)","v":2219204.56},{"$f":"SUM(F24:F28)","v":358040.91200000001}]
[]
["Total deducciones de Ley"]
["Deducciones de Ley sin contribución:",null,null,null,{"$f":"+SUM(F33:F38)/F3","v":0.82602967733547039}]
["Aporte al Fondo de Jubilaciones y Pensiones PJ (FJPPJ)",null,null,null,0.13,{"$f":"+F3*E33","v":397696.59280000004}]
["Seguro de Enfermedad y Maternidad (C.C.S.S.)",null,null,null,0.05,{"$f":"F3*E34","v":152960.228}]
["Fondo de Socorro Mutuo",null,null,null,500,3000]
["Pensión Alimentaria (en caso que aplique)",{"$nulls":4},1600000]
["Costo de Administración Junta Administradora FJPPJ",null,null,null,5.0000000000000001E-3,{"$f":"+E37*F3","v":15296.022800000001}]
["Impto. sobre la renta",{"$nulls":4},{"$f":"+F29","v":358040.91200000001}]
[]
["Contribución Solidaria",{"$nulls":4},{"$f":"IF(F21<0,0,F21)","v":0}]
["Total deducciones de Ley con contribución",null,null,null,{"$f":"+F41/F3","v":0.82602967733547039},{"$f":"SUM(F33:F40)","v":2526993.7555999998}]
["Monto Neto beneficio",{"$nulls":4},{"$f":"+F3-F41","v":532210.80440000026}]

{"sheet":"Douglas I. R. R.","index":7,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[[41,0,41,4],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,5],[39,0,39,3],[40,0,40,3],[34,0,34,3],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[20,0,20,1],[20,3,20,4],[22,0,22,5],[30,0,30,5],[31,0,31,3],[32,0,32,3],[33,0,33,3],[7,0,7,1],[0,0,0,5],[2,0,2,4],[4,0,4,5],[6,0,6,2],[6,3,6,4]]}
["Matriz para el Cálculo Mensual de la deducción de ley denominada\nContribución Solidaria "]
[]
["Monto Bruto de Asignación Mensual",{"$nulls":4},3787018.84]
[]
["Contribución Solidaria"]
[]
["Datos de Ley para Contribución Solidaria."]
["Cant. De Salarios",null,6]
["Aplica CS",null,"SI"]
["Monto Salario + bajo",null,433800]
["Monto Tope",null,{"$f":"+C10*C8","v":2602800}]
["Monto Tasable",null,{"$f":"+IF(OR(F3<C11,C9=\"no\"),\"N/A\",F3-C11)","v":1184218.8399999999}]
["% Contribución Aplicada",null,{"$f":"IF(C12=\"N/A\",0,SUM(F15:F19)/F3)","v":0.11649071595323776}]
["Rangos",0.25,"Limite Inf.","Limite Sup.","Exceso","Aporte"]
["Estrato A",0.35,{"$f":"+C11","v":2602800},{"$f":"+C15*(1+$B$14)","v":3253500},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C15,$F$3<D15),($F$3-C15),IF(AND($F$3>C15,$F$3>D15),D15-C15,0)))","v":650700},{"$f":"IF($C$12=\"N/A\",\"\",E15*B15)","v":227745}]
["Estrato B",0.4,{"$f":"+D15","v":3253500},{"$f":"+C16*(1+$B$14)","v":4066875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C16,$F$3<D16),($F$3-C16),IF(AND($F$3>C16,$F$3>D16),D16-C16,0)))","v":533518.83999999985},{"$f":"IF($C$12=\"N/A\",\"\",E16*B16)","v":213407.53599999996}]
["Estrato C",0.45,{"$f":"+D16","v":4066875},{"$f":"+C17*(1+$B$14)","v":5083593.75},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C17,$F$3<D17),($F$3-C17),IF(AND($F$3>C17,$F$3>D17),D17-C17,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E17*B17)","v":0}]
["Estrato D",0.5,{"$f":"+D17","v":5083593.75},{"$f":"+C18*(1+$B$14)","v":6354492.1875},{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C18,$F$3<D18),($F$3-C18),IF(AND($F$3>C18,$F$3>D18),D18-C18,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E18*B18)","v":0}]
["Estrato E",0.55000000000000004,{"$f":"+D18","v":6354492.1875},15000000,{"$f":"IF($C$12=\"N/A\",\"\",IF(AND($F$3>C19,$F$3<D19),($F$3-C19),IF(AND($F$3>C19,$F$3>D19),D19-C19,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E19*B19)","v":0}]
[{"$nulls":4},{"$f":"SUM(E15:E19)","v":1184218.8399999999},{"$f":"SUM(F15:F19)","v":441152.53599999996}]
["Contribución Máxima",null,0.55000000000000004,null,null,{"$f":"IF(C9=\"si\",IF((SUM(F15:F19,F33:F38)/F3)>C21,F3*(C21-E32),SUM(F15:F19)),0)","v":-424341.89139999973}]
[]
["Impuesto sobre la Renta"]
["Monto Tasable",{"$f":"+F3-C25","v":2947018.84}]
["Rango 1",0.1,840000,1233000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C25,$F$3<D25),($F$3-C25),IF(AND($F$3>C25,$F$3>D25),D25-C25,0)))","v":393000},{"$f":"IF($C$12=\"N/A\",\"\",E25*B25)","v":39300}]
["Rango 2",0.15,{"$f":"+D25","v":1233000},2163000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C26,$F$3<D26),($F$3-C26),IF(AND($F$3>C26,$F$3>D26),D26-C26,0)))","v":930000},{"$f":"IF($C$12=\"N/A\",\"\",E26*B26)","v":139500}]
["Rango 3",0.2,{"$f":"+D26","v":2163000},4325000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C27,$F$3<D27),($F$3-C27),IF(AND($F$3>C27,$F$3>D27),D27-C27,0)))","v":1624018.8399999999},{"$f":"IF($C$12=\"N/A\",\"\",E27*B27)","v":324803.76799999998}]
["Rango 4",0.25,{"$f":"+D27","v":4325000},15000000,{"$f":"IF($B$24=\"N/A\",\"\",IF(AND($F$3>C28,$F$3<D28),($F$3-C28),IF(AND($F$3>C28,$F$3>D28),D28-C28,0)))","v":0},{"$f":"IF($C$12=\"N/A\",\"\",E28*B28)","v":0}]
[{"$nulls":4},{"$f":"SUM(E24:E28)","v":2947018.84},{"$f":"SUM(F24:F28)","v":503603.76799999998}]
[]
["Total deducciones de Ley"]
["Deducciones de Ley sin contribución:",null,null,null,{"$f":"+SUM(F33:F38)/F3","v":0.66205169800528374}]
["Aporte al Fondo de Jubilaciones y Pensiones PJ (FJPPJ)",null,null,null,0.13,{"$f":"+F3*E33","v":492312.44919999997}]
["Seguro de Enfermedad y Maternidad (C.C.S.S.)",null,null,null,0.05,{"$f":"F3*E34","v":189350.94200000001}]
["Fondo de Socorro Mutuo",null,null,null,500,3000]
["Pensión Alimentaria (en caso que aplique)",{"$nulls":4},1300000]
["Costo de Administración Junta Administradora FJPPJ",null,null,null,5.0000000000000001E-3,{"$f":"+E37*F3","v":18935.0942}]
["Impto. sobre la renta",{"$nulls":4},{"$f":"+F29","v":503603.76799999998}]
[]
["Contribución Solidaria",{"$nulls":4},{"$f":"IF(F21<0,0,F21)","v":0}]
["Total deducciones de Ley con contribución",null,null,null,{"$f":"+F41/F3","v":0.66205169800528374},{"$f":"SUM(F33:F40)","v":2507202.2533999998}]
["Monto Neto beneficio",{"$nulls":4},{"$f":"+F3-F41","v":1279816.5866}]