{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Resumen General","Liquidación Intereses"],"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":"Resumen General","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Resumen General Liquidación de Crédito SNETOR vs. POLIMFLEX"]
["Concepto","Valor"]
["Capital",{"$f":"'Liquidación Intereses'!A3","v":147935646}]
["Intereses Moratorios",{"$f":"'Liquidación Intereses'!F60","v":197920758.46900493}]
["Cláusula penal",15000000]
["Agencias en Derecho",4800000]
["Total:",{"$f":"SUM(B3:B6)","v":365656404.46900493}]

{"sheet":"Liquidación Intereses","index":1,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,0,0,2],[4,0,4,1],[4,3,4,4]]}
["Datos para liquidación "]
["Capital","Fecha de inicio de la mora","Fecha de presentación de liquidación"]
[147935646,"2020-01-27","2024-04-10"]
[]
["Fecha",null,null,"Interés Anual Efectivo Comercial"]
["Desde","Hasta","Capital","Interes Bancario Corriente","Tasa de Usura","Interes Moratorio","Capital + Intereses Periódico"]
["2020-01-27","2020-01-31",{"$f":"A3","v":147935646},0.18770000000000001,{"$f":"SUM(D7*1.5)","v":0.28155000000000002},{"$f":"C7*(E7/360)*(B7-A7)","v":462792.01257000002},{"$f":"C7+F7","v":148398438.01256999}]
["2020-02-01","2020-02-29",147935646,0.19059999999999999,{"$f":"SUM(D8*1.5)","v":0.28589999999999999},{"$f":"C8*(E8/360)*(B8-A8)","v":3289595.6482199999},{"$f":"G7+F8","v":151688033.66079}]
["2020-03-01","2020-03-31",147935646,0.1895,0.28425,3504225.6146250004,{"$f":"G8+F9","v":155192259.275415}]
["2020-04-01","2020-04-30",147935646,0.18690000000000001,0.28034999999999999,3340941.6453524996,158533200.92076752]
["2020-05-01","2020-05-31",147935646,0.18190000000000001,0.27285000000000004,3363686.7509250003,161896887.67169252]
["2020-06-01","2020-06-30",147935646,0.1812,0.27179999999999999,3239050.9691699995,165135938.64086252]
["2020-07-01","2020-07-31",147935646,0.1812,0.27179999999999999,3350742.3818999995,168486681.02276254]
["2020-08-01","2020-08-31",147935646,0.18290000000000001,0.27434999999999998,3382178.7066749996,171868859.72943753]
["2020-09-01","2020-09-30",147935646,0.1835,0.27524999999999999,3280164.7507875003,175149024.48022503]
["2020-10-01","2020-10-31",147935646,0.18090000000000001,0.27134999999999998,3345194.7951749996,178494219.27540001]
["2020-11-01","2020-11-30",147935646,0.1784,0.2676,3188999.40894,181683218.68434]
["2020-12-01","2020-12-31",147935646,0.17460000000000001,0.26190000000000002,3228695.47395,184911914.15829]
["2021-01-01","2021-01-31",147935646,0.17319999999999999,0.25979999999999998,3202806.7358999997,188114720.89419001]
["2021-02-01","2021-02-28",147935646,0.1754,0.2631,2919140.134695,191033861.02888501]
["2021-03-01","2021-03-31",147935646,0.1741,0.26114999999999999,3219449.4960749997,194253310.52496001]
["2021-04-01","2021-04-30",147935646,0.1731,0.25964999999999999,3094258.9556474998,197347569.48060751]
["2021-05-01","2021-05-31",147935646,0.17219999999999999,0.25829999999999997,3184314.78015,200531884.26075751]
["2021-06-01","2021-06-30",147935646,0.1721,{"$f":"SUM(D24*1.5)","v":0.25814999999999999},{"$f":"C24*(E24/360)*(B24-A24)","v":3076383.3984225001},203608267.65918002]
["2021-07-01","2021-07-31",147935646,0.17180000000000001,0.25770000000000004,{"$f":"C25*(E25/360)*(B25-A25)","v":3176917.9978500004},206785185.65703002]
["2021-08-01","2021-08-31",147935646,0.1724,0.2586,3188013.1712999996,209973198.82833001]
["2021-09-01","2021-09-30",147935646,0.1719,0.25785000000000002,3072808.2869775007,213046007.11530751]
["2021-10-01","2021-10-31",147935646,0.17080000000000001,0.25619999999999998,3158426.0420999997,216204433.15740752]
["2021-11-01","2021-11-30",147935646,0.17269999999999999,0.25905,3087108.7327575004,219291541.89016503]
["2021-12-01","2021-12-31",147935646,0.17460000000000001,0.26190000000000002,3228695.47395,222520237.36411503]
["2022-01-01","2022-01-31",147935646,0.17660000000000001,0.26490000000000002,3265679.3854499999,225785916.74956504]
["2022-02-01","2022-02-28",147935646,0.183,0.27449999999999997,3045625.1120249997,228831541.86159003]
["2022-03-01","2022-03-31",147935646,0.1847,0.27705000000000002,3415464.2270249999,232247006.08861503]
["2022-04-01","2022-04-30",147935646,0.1905,0.28575,3405293.6513625002,235652299.73997754]
["2022-05-01","2022-05-31",147935646,0.1971,0.29564999999999997,3644764.478325,239297064.21830255]
["2022-06-01","2022-06-30",147935646,0.20399999999999999,0.30599999999999999,3646613.6738999998,242943677.89220256]
["2022-07-01","2022-07-31",147935646,0.21279999999999999,0.31919999999999998,3935088.1835999996,246878766.07580256]
["2022-08-01","2022-08-31",147935646,0.22209999999999999,0.33315,4107063.3720749998,250985829.44787756]
["2022-09-01","2022-09-30",147935646,0.23499999999999999,0.35249999999999998,4200755.9478749996,255186585.39575255]
["2022-10-01","2022-10-31",147935646,0.24610000000000001,0.36915000000000003,4550870.3100749999,259737455.70582753]
["2022-11-01","2022-11-30",147935646,0.25779999999999997,0.38669999999999993,4608318.652604999,264345774.35843253]
["2022-12-01","2022-12-31",147935646,0.27639999999999998,0.41459999999999997,5111176.5692999987,269456950.92773253]
["2023-01-01","2023-01-31",147935646,0.28839999999999999,0.43259999999999998,5333080.0383000001,274790030.96603251]
["2023-02-01","2023-02-28",147935646,0.30180000000000001,0.45269999999999999,5022785.0208149999,279812815.98684752]
["2023-03-01","2023-03-31",147935646,0.30840000000000001,0.46260000000000001,5702919.1533000004,285515735.14014751]
["2023-04-01","2023-04-30",147935646,0.31390000000000001,0.47084999999999999,5611137.4129275,291126872.55307502]
["2023-05-01","2023-05-31",147935646,0.30270000000000002,0.45405000000000006,5597515.0055250004,296724387.55860001]
["2023-06-01","2023-06-30",147935646,0.29759999999999998,0.44639999999999996,5319765.8301600004,302044153.38876003]
["2023-07-01","2023-07-31",147935646,0.29360000000000003,0.44040000000000001,5429238.2082000012,307473391.59696001]
["2023-08-01","2023-08-31",147935646,0.28749999999999998,0.43124999999999997,5316437.2781249993,312789828.875085]
["2023-09-01","2023-09-30",147935646,0.28029999999999999,0.42044999999999999,5010518.6901675006,317800347.56525248]
["2023-10-01","2023-10-31",147935646,0.26529999999999998,0.39794999999999997,4905915.860475,322706263.42572749]
["2023-11-01","2023-11-30",147935646,0.25519999999999998,0.38279999999999997,4561842.2038199995,327268105.62954748]
["2023-12-01","2023-12-31",147935646,0.25040000000000001,0.37560000000000004,4630385.719800001,331898491.34934747]
["2024-01-01","2024-01-31",147935646,0.23319999999999999,0.3498,4312324.0808999995,336210815.43024749]
["2024-02-01","2024-02-29",147935646,0.2331,0.34965000000000002,4023109.8929699999,340233925.32321751]
["2024-03-01","2024-03-31",147935646,0.222,0.33300000000000002,{"$f":"C57*(E57/360)*(B57-A57)","v":4105214.1765000001},344339139.49971753]
["2024-04-01","2024-04-10",147935646,0.27350000000000002,0.41025,{"$f":"C58*(E58/360)*(B58-A58)","v":1517264.9692875},345856404.46900505]
[]
[null,null,null,null,"Total Intereses Moratorios:",{"$f":"SUM(F7:F58)","v":197920758.46900493}]