{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["APORTES AL SISTEMA","SALARIOS Y PRESTACIONES","IPC","Hoja3","DATOS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"APORTES AL SISTEMA","index":0,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[[57,0,57,9],[60,0,60,7],[60,8,60,9],[0,0,1,9],[3,7,4,7],[2,5,2,7],[3,5,4,5],[2,0,2,4],[3,6,4,6]]}
["LIQUIDACIÒN DE  PRESTACIONES SOCIALES, DEBIDAMENTE INDEXADAS, EN CONTRATO REALIDAD"]
[]
["LIQUIDADO",null,null,null,null,"AÑO FINAL HASTA DONDE SE INDEXA",null,null,2024,0,{"$f":"CONCATENATE(I3,\"-\",J3)","v":"2024-0"}]
["DESDE",null,null,"IPC","IPC","SALARIO PROMEDIO MENSUAL POR  AÑO","# DE MESES","TOTAL ANUAL SALARIOS","APORTE","APORTE"]
["Año",null,null,"FINAL","INICIAL",null,null,null,"SALUD (8%)","PENSIÒN (12%)"]
[2008,0,{"$f":"CONCATENATE(A6,\"-\",B6)","v":"2008-0"},{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C6)>=6,LOOKUP(C6,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":64.819999999999993},6000000,12,{"$f":"F6*G6","v":72000000},{"$f":"(H6*D6/E6)*8%","v":12238000.617093492},{"$f":"(H6*D6/E6)*12%","v":18357000.925640237}]
[{"$f":"A6+1","v":2009},0,{"$f":"CONCATENATE(A7,\"-\",B7)","v":"2009-0"},{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C7)>=6,LOOKUP(C7,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":69.8},6000000,12,{"$f":"F7*G7","v":72000000},{"$f":"(H7*D7/E7)*8%","v":11364859.598853869},{"$f":"(H7*D7/E7)*12%","v":17047289.398280803}]
[{"$f":"A7+1","v":2010},0,"2010-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C8)>=6,LOOKUP(C8,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":71.2},6000000,12,{"$f":"F8*G8","v":72000000},{"$f":"(H8*D8/E8)*8%","v":11141393.258426966},{"$f":"(H8*D8/E8)*12%","v":16712089.88764045}]
[{"$f":"A8+1","v":2011},0,"2011-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C9)>=6,LOOKUP(C9,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":73.45},6000000,12,72000000,{"$f":"(H9*D9/E9)*8%","v":10800098.025867937},{"$f":"(H9*D9/E9)*12%","v":16200147.038801905}]
[2012,0,"2012-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C10)>=6,LOOKUP(C10,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":76.19},6000000,12,72000000,{"$f":"(H10*D10/E10)*8%","v":10411697.073106708},{"$f":"(H10*D10/E10)*12%","v":15617545.609660061}]
[2013,0,"2013-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C11)>=6,LOOKUP(C11,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":78.05},6000000,12,72000000,{"$f":"(H11*D11/E11)*8%","v":10163577.194106342},{"$f":"(H11*D11/E11)*12%","v":15245365.791159514}]
[2014,0,"2014-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C12)>=6,LOOKUP(C12,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":79.56},6000000,12,72000000,{"$f":"(H12*D12/E12)*8%","v":9970678.7330316734},{"$f":"(H12*D12/E12)*12%","v":14956018.099547509}]
[2015,0,"2015-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C13)>=6,LOOKUP(C13,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":82.47},6000000,12,72000000,{"$f":"(H13*D13/E13)*8%","v":9618857.7664605305},{"$f":"(H13*D13/E13)*12%","v":14428286.649690796}]
[2016,0,"2016-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C14)>=6,LOOKUP(C14,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":88.05},6000000,12,72000000,{"$f":"(H14*D14/E14)*8%","v":9009281.0902896076},{"$f":"(H14*D14/E14)*12%","v":13513921.635434411}]
[2017,0,"2017-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C15)>=6,LOOKUP(C15,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":93.11},6000000,12,72000000,{"$f":"(H15*D15/E15)*8%","v":8519677.8004510794},{"$f":"(H15*D15/E15)*12%","v":12779516.700676618}]
[2018,0,"2018-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C16)>=6,LOOKUP(C16,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":96.92},6000000,12,72000000,{"$f":"(H16*D16/E16)*8%","v":8184762.6908790758},{"$f":"(H16*D16/E16)*12%","v":12277144.036318613}]
[2019,0,"2019-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C17)>=6,LOOKUP(C17,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":100},6000000,12,72000000,{"$f":"(H17*D17/E17)*8%","v":7932672},{"$f":"(H17*D17/E17)*12%","v":11899008}]
[2020,0,"2020-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C18)>=6,LOOKUP(C18,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":103.8},6000000,12,72000000,{"$f":"(H18*D18/E18)*8%","v":7642265.8959537577},{"$f":"(H18*D18/E18)*12%","v":11463398.843930636}]
[2021,0,"2021-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C19)>=6,LOOKUP(C19,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":105.48},6000000,12,72000000,{"$f":"(H19*D19/E19)*8%","v":7520546.0750853242},{"$f":"(H19*D19/E19)*12%","v":11280819.112627985}]
[2022,0,"2022-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C20)>=6,LOOKUP(C20,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":111.41},6000000,12,72000000,{"$f":"(H20*D20/E20)*8%","v":7120251.3239386063},{"$f":"(H20*D20/E20)*12%","v":10680376.985907909}]
[2023,0,"2023-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C21)>=6,LOOKUP(C21,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":126.03},6000000,1,6000000,{"$f":"(H21*D21/E21)*8%","v":524522.73268269456},{"$f":"(H21*D21/E21)*12%","v":786784.09902404179}]
[2024,0,"2024-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C22)>=6,LOOKUP(C22,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,{"$f":"(H22*D22/E22)*8%","v":0},{"$f":"(H22*D22/E22)*12%","v":0}]
[2025,0,"2025-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C23)>=6,LOOKUP(C23,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,{"$f":"F23/12*G23","v":0},{"$f":"I23*(D23/E23)","v":0},{"$f":"J23*G23/100","v":0},{"$f":"I23","v":0},{"$f":"L23*(D23/E23)","v":0},{"$f":"L23/2","v":0},{"$f":"N23*(D23/E23)","v":0},{"$f":"(H23*D23/E23)*8%","v":0},{"$f":"(H23*D23/E23)*12%","v":0}]
[2026,0,"2026-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C24)>=6,LOOKUP(C24,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2027,0,"2027-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C25)>=6,LOOKUP(C25,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2028,0,"2028-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C26)>=6,LOOKUP(C26,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2029,0,"2029-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C27)>=6,LOOKUP(C27,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2030,0,"2030-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C28)>=6,LOOKUP(C28,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2031,0,"2031-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C29)>=6,LOOKUP(C29,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2032,0,"2032-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C30)>=6,LOOKUP(C30,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2033,0,"2033-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C31)>=6,LOOKUP(C31,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2034,0,"2034-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C32)>=6,LOOKUP(C32,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2035,0,"2035-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C33)>=6,LOOKUP(C33,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2036,0,"2036-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C34)>=6,LOOKUP(C34,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2037,0,"2037-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C35)>=6,LOOKUP(C35,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2038,0,"2038-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C36)>=6,LOOKUP(C36,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2039,0,"2039-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C37)>=6,LOOKUP(C37,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2040,0,"2040-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C38)>=6,LOOKUP(C38,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,{"$f":"I38","v":0},0,0,0,0,0]
[2041,0,"2041-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C39)>=6,LOOKUP(C39,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2042,0,"2042-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C40)>=6,LOOKUP(C40,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2043,0,"2043-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C41)>=6,LOOKUP(C41,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2044,0,"2044-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C42)>=6,LOOKUP(C42,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2045,0,"2045-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C43)>=6,LOOKUP(C43,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2046,0,"2046-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C44)>=6,LOOKUP(C44,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2047,0,"2047-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C45)>=6,LOOKUP(C45,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2048,0,"2048-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C46)>=6,LOOKUP(C46,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2049,0,"2049-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C47)>=6,LOOKUP(C47,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2050,0,"2050-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C48)>=6,LOOKUP(C48,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2051,0,"2051-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C49)>=6,LOOKUP(C49,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2052,0,"2052-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C50)>=6,LOOKUP(C50,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2053,0,"2053-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C51)>=6,LOOKUP(C51,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2054,0,"2054-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C52)>=6,LOOKUP(C52,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2055,0,"2055-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C53)>=6,LOOKUP(C53,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2056,0,"2056-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C54)>=6,LOOKUP(C54,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2057,0,"2057-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C55)>=6,LOOKUP(C55,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2058,0,"2058-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C56)>=6,LOOKUP(C56,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,0,0,0,0]
[2059,0,"2059-0",{"$f":"IF(LEN($K$3)>=6,LOOKUP($K$3,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},{"$f":"IF(LEN(C57)>=6,LOOKUP(C57,IPC!$A$2:$A$69,IPC!$B$2:$B$69),0)","v":137.72},null,null,0,0,0,0,0,0,{"$f":"L57/2","v":0},0,0,0]
["CONSOLIDADO"]
[null,null,null,null,null,null,null,null,"APORTE SALUD","APORTE PENSIÒN"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I6:I22)","v":142163141.87622768},{"$f":"SUM(J6:J22)","v":213244712.81434146}]
["TOTAL APORTES EN SALUD (8%) Y PENSIÓN (12%):",null,null,null,null,null,null,null,{"$f":"I60+J60","v":355407854.69056916}]

{"sheet":"SALARIOS Y PRESTACIONES","index":1,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[[46,6,46,9],[47,6,47,9],[48,6,48,9],[38,10,38,13],[40,10,40,14],[41,10,41,11],[41,12,41,13],[42,10,42,11],[42,12,42,13],[30,10,30,12],[30,14,30,17],[31,10,31,12],[31,14,31,17],[33,10,33,14],[37,4,37,7],[27,10,27,12],[27,13,27,17],[28,10,28,12],[28,13,28,17],[29,10,29,12],[29,13,29,17],[21,10,21,13],[23,10,23,17],[24,10,24,12],[24,16,24,17],[25,10,25,12],[26,10,26,12],[1,0,1,4],[2,0,9,4],[12,0,12,2],[15,10,15,13],[17,0,17,1],[18,4,18,7]]}
[]
["PRESCRIPCIÓN"]
["SALARIOS: La reclamación se radicó el 28/06/2024, por lo tanto la diferencia salarial se podría reclamar desde el 28/06/2021. No obstante, se resalta que no hubo pago en los meses de diciembre de 2022 y enero de 2023, los cuales se aduedan en su totalidad.                                                CESANTÍAS: No prescriben                                                                                     INTERESES CESANTÍAS: Últimos 3 años (Agosto/2021-Enero 2023)                                                          PRIMAS: Últimos 3 años (Agosto/2021 a Enero 2023)                VACACIONES: Últimos 4 años (2020 a Enero 2023)                                     "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SALARIOS ADEUDADOS"]
["Desde","Hasta","Valor",null,"DESDE","HASTA","SALARIO","DÍAS","PRIMAS",null,"DESDE","HASTA","SALARIO","DÍAS","VACACIONES"]
[null,null,null,null,"2021-08-28","2021-12-31",6000000,{"$f":"DAYS360(E15,F15)","v":123},{"$f":"(G15*H15)/360","v":2050000},null,"2020-01-01","2023-01-31",6000000,{"$f":"DAYS360(K15,L15)+1","v":1111},{"$f":"(M15*N15)/720","v":9258333.333333334}]
["2022-12-01","2022-12-30",6000000,null,"2022-01-01","2022-12-31",6000000,{"$f":"DAYS360(E16,F16)","v":360},{"$f":"(G16*H16)/360","v":6000000},null,"TOTAL ADEUDADO",null,null,null,{"$f":"SUM(O15)","v":9258333.333333334}]
["2023-01-01","2023-01-30",6000000,null,"2023-01-01","2023-01-31",6000000,{"$f":"DAYS360(E17,F17)","v":30},500000]
["TOTAL",null,{"$f":"SUM(C15:C17)","v":12000000},null,null,null,null,null,null,null,"DESDE","HASTA","CESANTÍAS","DÍAS","INTERESES"]
[null,null,null,null,"TOTAL ADEUDADO",null,null,null,{"$f":"SUM(I15:I18)","v":8550000},null,"2021-08-28","2021-12-31",{"$f":"+I35","v":6000000},{"$f":"DAYS360(K19,L19)","v":123},{"$f":"(M19*N19*0.12)/360","v":246000}]
[null,null,null,null,null,null,null,null,null,null,"2022-01-01","2022-12-31",{"$f":"+I36","v":6000000},360,720000]
[null,null,null,null,"DESDE","HASTA","SALARIO","DÍAS","CESANTÍAS",null,"2023-01-01","2023-01-31",{"$f":"(K21*L21)/360","v":5610508.7194444444},{"$f":"DAYS360(K21,L21)","v":30},{"$f":"(M21*N21*0.12)/360","v":56105.087194444444}]
[null,null,null,null,"2008-01-01","2008-12-31",6000000,{"$f":"DAYS360(E22,F22)","v":360},{"$f":"(G22*H22)/360","v":6000000},null,"TOTAL ADEUDADO",null,null,null,{"$f":"SUM(O19:O21)","v":1022105.0871944445}]
[null,null,null,null,"2009-01-01","2009-12-31",6000000,{"$f":"DAYS360(E23,F23)","v":360},{"$f":"(G23*H23)/360","v":6000000}]
[null,null,null,null,"2010-01-01","2010-12-31",6000000,{"$f":"DAYS360(E24,F24)","v":360},6000000,null,"INDEMNIZACIÓN ARTÍCULO 64 DEL C.S.T."]
[null,null,null,null,"2011-01-01","2011-12-31",6000000,360,6000000,null,null,null,null,"AÑO","MES","DÍA","Tiempo Laborado en:"]
[null,null,null,null,"2012-01-01","2012-12-31",6000000,360,6000000,null,"Fecha de Terminación:",null,null,2023,1,31,"Días","Años"]
[null,null,null,null,"2013-01-01","2013-12-31",6000000,360,6000000,null,"Fecha de Ingreso:",null,null,2008,1,1,{"$f":"(N26-N27)*360+(O26-O27)*30+(P26-P27+1)","v":5431},{"$f":"Q27/360","v":15.08611111111111}]
[null,null,null,null,"2014-01-01","2014-12-31",6000000,360,6000000,null,"Ingreso Mensual:",null,null,6000000]
[null,null,null,null,"2015-01-01","2015-12-31",6000000,360,6000000,null,"Ingreso Diario:",null,null,{"$f":"N28/30","v":200000}]
[null,null,null,null,"2016-01-01","2016-12-31",6000000,360,6000000,null,"Indemnización primer año",null,null,{"$f":"N28","v":6000000}]
[null,null,null,null,"2017-01-01","2017-12-31",6000000,360,6000000,null,"Indemnización años adicionales:",null,null,{"$f":"R27-1","v":14.08611111111111},{"$f":"N31*20*N29","v":56344444.444444448}]
[null,null,null,null,"2018-01-01","2018-12-31",6000000,360,6000000,null,"Total Indemnizacón:",null,null,null,{"$f":"SUM(N30:O31)","v":62344458.530555561}]
[null,null,null,null,"2019-01-01","2019-12-31",6000000,360,6000000]
[null,null,null,null,"2020-01-01","2020-12-31",6000000,360,6000000,null,"SANCIÓN POR NO CONSIGNACIÓN DE CESANTÍAS"]
[null,null,null,null,"2021-01-01","2021-12-31",6000000,360,6000000,null,"DESDE","HASTA","SALARIO","DÍAS","SANCIÓN"]
[null,null,null,null,"2022-01-01","2022-12-31",6000000,360,6000000,null,"2021-02-15","2022-02-14",6000000,{"$f":"DAYS360(K36,L36)+1","v":360},{"$f":"(M36/30)*N36","v":72000000}]
[null,null,null,null,"2023-01-01","2023-01-31",6000000,{"$f":"DAYS360(E37,F37)","v":30},{"$f":"(G37*H37)/360","v":500000},null,"2022-02-15","2023-01-31",6000000,347,69400000]
[null,null,null,null,"TOTAL ADEUDADO",null,null,null,{"$f":"SUM(I22:I37)","v":90500000}]
[null,null,null,null,null,null,null,null,null,null,"TOTAL ADEUDADO",null,null,null,{"$f":"SUM(O36:O37)","v":141400000}]
[]
[null,null,null,null,null,null,null,null,null,null,"INDEMNIZACIÓN DEL ARTÍCULO 65 DEL C.S.T."]
[null,null,null,null,null,null,null,null,null,null,"Salario diario",null,"x 720 días",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"N29","v":200000},null,568,null,{"$f":"K43*M43","v":113600000}]
[]
[]
[]
[null,null,null,null,null,null,"Total Liquidación Salarios y Prestaciones:",null,null,null,{"$f":"SUM(C18+I38+I19+O16+O22+O32+O39+O43)","v":438674896.9510833}]
[null,null,null,null,null,null,"Total Liquidación Aportes al Sistema:",null,null,null,355407854.69056916]
[null,null,null,null,null,null,"TOTAL FINAL",null,null,null,{"$f":"SUM(K47:K48)","v":794082751.64165246}]

{"sheet":"IPC","index":2,"n_rows":55,"n_cols":2,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["AÑO","IPC"]
["1971-0",0.12]
["1972-0",0.14000000000000001]
["1973-0",0.16]
["1974-0",0.2]
["1975-0",0.25]
["1976-0",0.28999999999999998]
["1977-0",0.37]
["1978-0",0.47]
["1979-0",0.56000000000000005]
["1980",0.72]
["1981",0.91]
["1982",1.1399999999999999]
["1983",1.42]
["1984",1.66]
["1985",1.96]
["1986",2.4]
["1987",2.9]
["1988",3.6]
["1989",4.6100000000000003]
["1990",5.81]
["1991",7.69]
["1992",9.74]
["1993",12.19]
["1994",14.93]
["1995",18.29]
["1996",21.83]
["1997",26.55]
["1998",31.23]
["1999",36.42]
["2000",39.79]
["2001",43.27]
["2002",46.58]
["2003",49.83]
["2004",53.07]
["2005",55.98]
["2006",58.7]
["2007",61.33]
["2008",64.819999999999993]
["2009",69.8]
["2010",71.2]
["2011",73.45]
["2012",76.19]
["2013",78.05]
["2014",79.56]
["2015",82.47]
["2016",88.05]
["2017",93.11]
["2018",96.92]
["2019",100]
["2020-0",103.8]
["2021-0",105.48]
["2022-0",111.41]
["2023-0",126.03]
["2024-0",137.72]

{"sheet":"Hoja3","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,456]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"TEXT(C5,\"$0\")","v":"$456"}]

{"sheet":"DATOS","index":4,"n_rows":60,"n_cols":45,"rows_kept":60,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000]
[null,"TABLA INFORMATIVA"]
[null,"AÑO","Incremento P"]
[null,1967,7.17E-2]
[null,1968,6.5100000000000005E-2]
[null,1969,8.6300000000000002E-2]
[null,1970,6.5799999999999997E-2]
[null,1971,0.14030000000000001]
[null,1972,0.1399]
[null,1973,0.24079999999999999]
[null,1974,0.26350000000000001]
[null,1975,0.1777]
[null,1976,0.2576]
[null,1977,0.28710000000000002]
[null,1978,0.1842]
[null,1979,0.28799999999999998]
[null,1980,0.25850000000000001]
[null,1981,0.2636]
[null,1982,0.24030000000000001]
[null,1983,0.16639999999999999]
[null,1984,0.18279999999999999]
[null,1985,0.22450000000000001]
[null,1986,0.20949999999999999]
[null,1987,0.2402]
[null,1988,0.28120000000000001]
[null,1989,0.26119999999999999]
[null,1990,0.3236]
[null,1991,0.26819999999999999]
[null,1992,0.25130000000000002]
[null,1993,0.22600000000000001]
[null,1994,0.22589999999999999]
[null,1995,0.1946]
[null,1996,0.21629999999999999]
[null,1997,0.17680000000000001]
[null,1998,0.16700000000000001]
[null,1999,9.2299999999999993E-2]
[null,2000,8.7499999999999994E-2]
[null,2001,7.6499999999999999E-2]
[null,2002,6.9900000000000004E-2]
[null,2003,6.4899999999999999E-2]
[null,2004,5.5E-2]
[null,2005,4.8500000000000001E-2]
[null,2006,4.48E-2]
[null,2007,5.6899999999999999E-2]
[null,2008,7.6700000000000004E-2]
[null,2009,0.02]
[null,2010,3.1699999999999999E-2]
[null,2011,3.73E-2]
[null,2012,2.4400000000000002E-2]
[null,2013,1.9400000000000001E-2]
[null,2014,3.6600000000000001E-2]
[null,2015,6.7699999999999996E-2]
[null,2016,5.7500000000000002E-2]
[null,2017,4.0899999999999999E-2]
[null,2018,3.1800000000000002E-2]
[null,2019,3.7999999999999999E-2]
[null,2020,1.61E-2]
[null,2021,5.62E-2]
[null,2022,0.13120000000000001]
[null,2023,9.2799999999999994E-2]