{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Intereses moratorios"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Intereses moratorios","index":0,"n_rows":166,"n_cols":16,"rows_kept":166,"cut":false,"hidden":false,"merged":[[1,12,2,13],[24,1,24,5],[11,0,12,9],[6,0,6,9],[21,1,21,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SÍ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[]
[]
[]
[]
["Liquidador de intereses de mora "]
[]
[]
[]
[]
["TABLA DE LIQUIDACION DE CREDITO- PROCESO- COOPENSIONADOS VS LUCINDO CORDOBA PALACIO"]
[]
[]
["a. Datos básicos"]
[null,"Valor del impuesto en mora (sin incluir ningún tipo de "]
[null,"sanciones)",null,null,null,null,11892700]
[]
[]
[null,"Fecha en que se venció la obligación",null,null,null,null,"2019-08-09"]
[null,"Fecha en que se decide hacer el pago",null,null,null,null,"2022-04-22"]
[null,"Tasa de interés bancario corriente para la modalidad de crédito de consumo y ordinario vigente al momento de hacer el cálculo",null,null,null,null,26.58]
[]
["b. Cálculo de los intereses moratorios respectivos"]
[null,"Períodos por los cuales se generaron intereses moratorios",null,null,null,null,"Base","Tasas diarias aplicables en ese período","Días en mora durante dicho período","Valor del interés moratorio"]
[null,null,null,null,null,null,null,"Tasa de usura reducida en 2 puntos"]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2019-08-01","y ","2019-08-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F29)>1826,0,IF(AND($G$20<D29,$G$21>F29),(F29-D29)+1,IF($G$21<D29,0,IF($G$20>F29,0,IF(AND($G$20>=D29,$G$20<=F29,$G$21>F29),(F29-$G$20),IF(AND($G$21>=D29,$G$21<=F29,$G$20<D29),($G$21-D29)+1,IF(AND($G$20>=D29,$G$20<=F29,$G$21>=D29,$G$21<=F29),($G$21-$G$20)))))))))","v":22},{"$f":"(G29*H29)*I29","v":176194.42334246571}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2019-09-01","y ","2019-09-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F33)>1826,0,IF(AND($G$20<D33,$G$21>F33),(F33-D33)+1,IF($G$21<D33,0,IF($G$20>F33,0,IF(AND($G$20>=D33,$G$20<=F33,$G$21>F33),(F33-$G$20),IF(AND($G$21>=D33,$G$21<=F33,$G$20<D33),($G$21-D33)+1,IF(AND($G$20>=D33,$G$20<=F33,$G$21>=D33,$G$21<=F33),($G$21-$G$20)))))))))","v":30},{"$f":"(G33*H33)*I33","v":240265.12273972598}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2019-10-01","y ","2019-10-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F37)>1826,0,IF(AND($G$20<D37,$G$21>F37),(F37-D37)+1,IF($G$21<D37,0,IF($G$20>F37,0,IF(AND($G$20>=D37,$G$20<=F37,$G$21>F37),(F37-$G$20),IF(AND($G$21>=D37,$G$21<=F37,$G$20<D37),($G$21-D37)+1,IF(AND($G$20>=D37,$G$20<=F37,$G$21>=D37,$G$21<=F37),($G$21-$G$20)))))))))","v":31},{"$f":"(G37*H37)*I37","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2019-11-01","y ","2019-11-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F41)>1826,0,IF(AND($G$20<D41,$G$21>F41),(F41-D41)+1,IF($G$21<D41,0,IF($G$20>F41,0,IF(AND($G$20>=D41,$G$20<=F41,$G$21>F41),(F41-$G$20),IF(AND($G$21>=D41,$G$21<=F41,$G$20<D41),($G$21-D41)+1,IF(AND($G$20>=D41,$G$20<=F41,$G$21>=D41,$G$21<=F41),($G$21-$G$20)))))))))","v":30},{"$f":"(G41*H41)*I41","v":240265.12273972598}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2019-12-01","y ","2019-12-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F45)>1826,0,IF(AND($G$20<D45,$G$21>F45),(F45-D45)+1,IF($G$21<D45,0,IF($G$20>F45,0,IF(AND($G$20>=D45,$G$20<=F45,$G$21>F45),(F45-$G$20),IF(AND($G$21>=D45,$G$21<=F45,$G$20<D45),($G$21-D45)+1,IF(AND($G$20>=D45,$G$20<=F45,$G$21>=D45,$G$21<=F45),($G$21-$G$20)))))))))","v":31},{"$f":"(G45*H45)*I45","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-01-01","y ","2020-01-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F49)>1826,0,IF(AND($G$20<D49,$G$21>F49),(F49-D49)+1,IF($G$21<D49,0,IF($G$20>F49,0,IF(AND($G$20>=D49,$G$20<=F49,$G$21>F49),(F49-$G$20),IF(AND($G$21>=D49,$G$21<=F49,$G$20<D49),($G$21-D49)+1,IF(AND($G$20>=D49,$G$20<=F49,$G$21>=D49,$G$21<=F49),($G$21-$G$20)))))))))","v":31},{"$f":"(G49*H49)*I49","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-02-01","y ","2020-02-29",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F53)>1826,0,IF(AND($G$20<D53,$G$21>F53),(F53-D53)+1,IF($G$21<D53,0,IF($G$20>F53,0,IF(AND($G$20>=D53,$G$20<=F53,$G$21>F53),(F53-$G$20),IF(AND($G$21>=D53,$G$21<=F53,$G$20<D53),($G$21-D53)+1,IF(AND($G$20>=D53,$G$20<=F53,$G$21>=D53,$G$21<=F53),($G$21-$G$20)))))))))","v":29},{"$f":"(G53*H53)*I53","v":232256.28531506847}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-03-01","y ","2020-03-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F57)>1826,0,IF(AND($G$20<D57,$G$21>F57),(F57-D57)+1,IF($G$21<D57,0,IF($G$20>F57,0,IF(AND($G$20>=D57,$G$20<=F57,$G$21>F57),(F57-$G$20),IF(AND($G$21>=D57,$G$21<=F57,$G$20<D57),($G$21-D57)+1,IF(AND($G$20>=D57,$G$20<=F57,$G$21>=D57,$G$21<=F57),($G$21-$G$20)))))))))","v":31},{"$f":"(G57*H57)*I57","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-04-01","y ","2020-04-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F61)>1826,0,IF(AND($G$20<D61,$G$21>F61),(F61-D61)+1,IF($G$21<D61,0,IF($G$20>F61,0,IF(AND($G$20>=D61,$G$20<=F61,$G$21>F61),(F61-$G$20),IF(AND($G$21>=D61,$G$21<=F61,$G$20<D61),($G$21-D61)+1,IF(AND($G$20>=D61,$G$20<=F61,$G$21>=D61,$G$21<=F61),($G$21-$G$20)))))))))","v":30},{"$f":"(G61*H61)*I61","v":240265.12273972598}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-05-01","y ","2020-05-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F65)>1826,0,IF(AND($G$20<D65,$G$21>F65),(F65-D65)+1,IF($G$21<D65,0,IF($G$20>F65,0,IF(AND($G$20>=D65,$G$20<=F65,$G$21>F65),(F65-$G$20),IF(AND($G$21>=D65,$G$21<=F65,$G$20<D65),($G$21-D65)+1,IF(AND($G$20>=D65,$G$20<=F65,$G$21>=D65,$G$21<=F65),($G$21-$G$20)))))))))","v":31},{"$f":"(G65*H65)*I65","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-06-01","y ","2020-06-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F69)>1826,0,IF(AND($G$20<D69,$G$21>F69),(F69-D69)+1,IF($G$21<D69,0,IF($G$20>F69,0,IF(AND($G$20>=D69,$G$20<=F69,$G$21>F69),(F69-$G$20),IF(AND($G$21>=D69,$G$21<=F69,$G$20<D69),($G$21-D69)+1,IF(AND($G$20>=D69,$G$20<=F69,$G$21>=D69,$G$21<=F69),($G$21-$G$20)))))))))","v":30},{"$f":"(G69*H69)*I69","v":240265.12273972598}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-07-01","y ","2020-07-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F73)>1826,0,IF(AND($G$20<D73,$G$21>F73),(F73-D73)+1,IF($G$21<D73,0,IF($G$20>F73,0,IF(AND($G$20>=D73,$G$20<=F73,$G$21>F73),(F73-$G$20),IF(AND($G$21>=D73,$G$21<=F73,$G$20<D73),($G$21-D73)+1,IF(AND($G$20>=D73,$G$20<=F73,$G$21>=D73,$G$21<=F73),($G$21-$G$20)))))))))","v":31},{"$f":"(G73*H73)*I73","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-08-01","y ","2020-08-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F77)>1826,0,IF(AND($G$20<D77,$G$21>F77),(F77-D77)+1,IF($G$21<D77,0,IF($G$20>F77,0,IF(AND($G$20>=D77,$G$20<=F77,$G$21>F77),(F77-$G$20),IF(AND($G$21>=D77,$G$21<=F77,$G$20<D77),($G$21-D77)+1,IF(AND($G$20>=D77,$G$20<=F77,$G$21>=D77,$G$21<=F77),($G$21-$G$20)))))))))","v":31},{"$f":"(G77*H77)*I77","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-09-01","y ","2020-09-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F81)>1826,0,IF(AND($G$20<D81,$G$21>F81),(F81-D81)+1,IF($G$21<D81,0,IF($G$20>F81,0,IF(AND($G$20>=D81,$G$20<=F81,$G$21>F81),(F81-$G$20),IF(AND($G$21>=D81,$G$21<=F81,$G$20<D81),($G$21-D81)+1,IF(AND($G$20>=D81,$G$20<=F81,$G$21>=D81,$G$21<=F81),($G$21-$G$20)))))))))","v":30},{"$f":"(G81*H81)*I81","v":240265.12273972598}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-10-01","y ","2020-10-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F85)>1826,0,IF(AND($G$20<D85,$G$21>F85),(F85-D85)+1,IF($G$21<D85,0,IF($G$20>F85,0,IF(AND($G$20>=D85,$G$20<=F85,$G$21>F85),(F85-$G$20),IF(AND($G$21>=D85,$G$21<=F85,$G$20<D85),($G$21-D85)+1,IF(AND($G$20>=D85,$G$20<=F85,$G$21>=D85,$G$21<=F85),($G$21-$G$20)))))))))","v":31},{"$f":"(G85*H85)*I85","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-11-01","y ","2020-11-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F89)>1826,0,IF(AND($G$20<D89,$G$21>F89),(F89-D89)+1,IF($G$21<D89,0,IF($G$20>F89,0,IF(AND($G$20>=D89,$G$20<=F89,$G$21>F89),(F89-$G$20),IF(AND($G$21>=D89,$G$21<=F89,$G$20<D89),($G$21-D89)+1,IF(AND($G$20>=D89,$G$20<=F89,$G$21>=D89,$G$21<=F89),($G$21-$G$20)))))))))","v":30},{"$f":"(G89*H89)*I89","v":240265.12273972598}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2020-12-01","y ","2020-12-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F93)>1826,0,IF(AND($G$20<D93,$G$21>F93),(F93-D93)+1,IF($G$21<D93,0,IF($G$20>F93,0,IF(AND($G$20>=D93,$G$20<=F93,$G$21>F93),(F93-$G$20),IF(AND($G$21>=D93,$G$21<=F93,$G$20<D93),($G$21-D93)+1,IF(AND($G$20>=D93,$G$20<=F93,$G$21>=D93,$G$21<=F93),($G$21-$G$20)))))))))","v":31},{"$f":"(G93*H93)*I93","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-01-01","y ","2021-01-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F97)>1826,0,IF(AND($G$20<D97,$G$21>F97),(F97-D97)+1,IF($G$21<D97,0,IF($G$20>F97,0,IF(AND($G$20>=D97,$G$20<=F97,$G$21>F97),(F97-$G$20),IF(AND($G$21>=D97,$G$21<=F97,$G$20<D97),($G$21-D97)+1,IF(AND($G$20>=D97,$G$20<=F97,$G$21>=D97,$G$21<=F97),($G$21-$G$20)))))))))","v":31},{"$f":"(G97*H97)*I97","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-02-01","y ","2021-02-28",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F101)>1826,0,IF(AND($G$20<D101,$G$21>F101),(F101-D101)+1,IF($G$21<D101,0,IF($G$20>F101,0,IF(AND($G$20>=D101,$G$20<=F101,$G$21>F101),(F101-$G$20),IF(AND($G$21>=D101,$G$21<=F101,$G$20<D101),($G$21-D101)+1,IF(AND($G$20>=D101,$G$20<=F101,$G$21>=D101,$G$21<=F101),($G$21-$G$20)))))))))","v":28},{"$f":"(G101*H101)*I101","v":224247.44789041093}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-03-01","y ","2021-03-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F105)>1826,0,IF(AND($G$20<D105,$G$21>F105),(F105-D105)+1,IF($G$21<D105,0,IF($G$20>F105,0,IF(AND($G$20>=D105,$G$20<=F105,$G$21>F105),(F105-$G$20),IF(AND($G$21>=D105,$G$21<=F105,$G$20<D105),($G$21-D105)+1,IF(AND($G$20>=D105,$G$20<=F105,$G$21>=D105,$G$21<=F105),($G$21-$G$20)))))))))","v":31},{"$f":"(G105*H105)*I105","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-04-01","y ","2021-04-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F109)>1826,0,IF(AND($G$20<D109,$G$21>F109),(F109-D109)+1,IF($G$21<D109,0,IF($G$20>F109,0,IF(AND($G$20>=D109,$G$20<=F109,$G$21>F109),(F109-$G$20),IF(AND($G$21>=D109,$G$21<=F109,$G$20<D109),($G$21-D109)+1,IF(AND($G$20>=D109,$G$20<=F109,$G$21>=D109,$G$21<=F109),($G$21-$G$20)))))))))","v":30},{"$f":"(G109*H109)*I109","v":240265.12273972598}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-05-01","y ","2021-05-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F113)>1826,0,IF(AND($G$20<D113,$G$21>F113),(F113-D113)+1,IF($G$21<D113,0,IF($G$20>F113,0,IF(AND($G$20>=D113,$G$20<=F113,$G$21>F113),(F113-$G$20),IF(AND($G$21>=D113,$G$21<=F113,$G$20<D113),($G$21-D113)+1,IF(AND($G$20>=D113,$G$20<=F113,$G$21>=D113,$G$21<=F113),($G$21-$G$20)))))))))","v":31},{"$f":"(G113*H113)*I113","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-06-01","y ","2021-06-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F117)>1826,0,IF(AND($G$20<D117,$G$21>F117),(F117-D117)+1,IF($G$21<D117,0,IF($G$20>F117,0,IF(AND($G$20>=D117,$G$20<=F117,$G$21>F117),(F117-$G$20),IF(AND($G$21>=D117,$G$21<=F117,$G$20<D117),($G$21-D117)+1,IF(AND($G$20>=D117,$G$20<=F117,$G$21>=D117,$G$21<=F117),($G$21-$G$20)))))))))","v":30},{"$f":"(G117*H117)*I117","v":240265.12273972598}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-07-01","y ","2021-07-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F121)>1826,0,IF(AND($G$20<D121,$G$21>F121),(F121-D121)+1,IF($G$21<D121,0,IF($G$20>F121,0,IF(AND($G$20>=D121,$G$20<=F121,$G$21>F121),(F121-$G$20),IF(AND($G$21>=D121,$G$21<=F121,$G$20<D121),($G$21-D121)+1,IF(AND($G$20>=D121,$G$20<=F121,$G$21>=D121,$G$21<=F121),($G$21-$G$20)))))))))","v":31},{"$f":"(G121*H121)*I121","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-08-01","y ","2021-08-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F125)>1826,0,IF(AND($G$20<D125,$G$21>F125),(F125-D125)+1,IF($G$21<D125,0,IF($G$20>F125,0,IF(AND($G$20>=D125,$G$20<=F125,$G$21>F125),(F125-$G$20),IF(AND($G$21>=D125,$G$21<=F125,$G$20<D125),($G$21-D125)+1,IF(AND($G$20>=D125,$G$20<=F125,$G$21>=D125,$G$21<=F125),($G$21-$G$20)))))))))","v":31},{"$f":"(G125*H125)*I125","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-09-01","y ","2021-09-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F129)>1826,0,IF(AND($G$20<D129,$G$21>F129),(F129-D129)+1,IF($G$21<D129,0,IF($G$20>F129,0,IF(AND($G$20>=D129,$G$20<=F129,$G$21>F129),(F129-$G$20),IF(AND($G$21>=D129,$G$21<=F129,$G$20<D129),($G$21-D129)+1,IF(AND($G$20>=D129,$G$20<=F129,$G$21>=D129,$G$21<=F129),($G$21-$G$20)))))))))","v":30},{"$f":"(G129*H129)*I129","v":240265.12273972598}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-10-01","y ","2021-10-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F133)>1826,0,IF(AND($G$20<D133,$G$21>F133),(F133-D133)+1,IF($G$21<D133,0,IF($G$20>F133,0,IF(AND($G$20>=D133,$G$20<=F133,$G$21>F133),(F133-$G$20),IF(AND($G$21>=D133,$G$21<=F133,$G$20<D133),($G$21-D133)+1,IF(AND($G$20>=D133,$G$20<=F133,$G$21>=D133,$G$21<=F133),($G$21-$G$20)))))))))","v":31},{"$f":"(G133*H133)*I133","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-11-01","y ","2021-11-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F137)>1826,0,IF(AND($G$20<D137,$G$21>F137),(F137-D137)+1,IF($G$21<D137,0,IF($G$20>F137,0,IF(AND($G$20>=D137,$G$20<=F137,$G$21>F137),(F137-$G$20),IF(AND($G$21>=D137,$G$21<=F137,$G$20<D137),($G$21-D137)+1,IF(AND($G$20>=D137,$G$20<=F137,$G$21>=D137,$G$21<=F137),($G$21-$G$20)))))))))","v":30},{"$f":"(G137*H137)*I137","v":240265.12273972598}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2021-12-01","y ","2021-12-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F141)>1826,0,IF(AND($G$20<D141,$G$21>F141),(F141-D141)+1,IF($G$21<D141,0,IF($G$20>F141,0,IF(AND($G$20>=D141,$G$20<=F141,$G$21>F141),(F141-$G$20),IF(AND($G$21>=D141,$G$21<=F141,$G$20<D141),($G$21-D141)+1,IF(AND($G$20>=D141,$G$20<=F141,$G$21>=D141,$G$21<=F141),($G$21-$G$20)))))))))","v":31},{"$f":"(G141*H141)*I141","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2022-01-01","y ","2022-01-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F145)>1826,0,IF(AND($G$20<D145,$G$21>F145),(F145-D145)+1,IF($G$21<D145,0,IF($G$20>F145,0,IF(AND($G$20>=D145,$G$20<=F145,$G$21>F145),(F145-$G$20),IF(AND($G$21>=D145,$G$21<=F145,$G$20<D145),($G$21-D145)+1,IF(AND($G$20>=D145,$G$20<=F145,$G$21>=D145,$G$21<=F145),($G$21-$G$20)))))))))","v":31},{"$f":"(G145*H145)*I145","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2022-02-01","y ","2022-02-28",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F149)>1826,0,IF(AND($G$20<D149,$G$21>F149),(F149-D149)+1,IF($G$21<D149,0,IF($G$20>F149,0,IF(AND($G$20>=D149,$G$20<=F149,$G$21>F149),(F149-$G$20),IF(AND($G$21>=D149,$G$21<=F149,$G$20<D149),($G$21-D149)+1,IF(AND($G$20>=D149,$G$20<=F149,$G$21>=D149,$G$21<=F149),($G$21-$G$20)))))))))","v":28},{"$f":"(G149*H149)*I149","v":224247.44789041093}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2022-03-01","y ","2022-03-31",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F153)>1826,0,IF(AND($G$20<D153,$G$21>F153),(F153-D153)+1,IF($G$21<D153,0,IF($G$20>F153,0,IF(AND($G$20>=D153,$G$20<=F153,$G$21>F153),(F153-$G$20),IF(AND($G$21>=D153,$G$21<=F153,$G$20<D153),($G$21-D153)+1,IF(AND($G$20>=D153,$G$20<=F153,$G$21>=D153,$G$21<=F153),($G$21-$G$20)))))))))","v":31},{"$f":"(G153*H153)*I153","v":248273.96016438352}]
[]
[]
[null,"Intereses de mora que se generan por los días"]
[null,"transcurridos entre ",null,"2022-04-01","y ","2022-04-30",{"$f":"+G$17","v":11892700},{"$f":"($G$22%-2%)/365","v":6.734246575342465E-4},{"$f":"IF($G$20<$D$29,0,IF((TODAY()-F157)>1826,0,IF(AND($G$20<D157,$G$21>F157),(F157-D157)+1,IF($G$21<D157,0,IF($G$20>F157,0,IF(AND($G$20>=D157,$G$20<=F157,$G$21>F157),(F157-$G$20),IF(AND($G$21>=D157,$G$21<=F157,$G$20<D157),($G$21-D157)+1,IF(AND($G$20>=D157,$G$20<=F157,$G$21>=D157,$G$21<=F157),($G$21-$G$20)))))))))","v":22},{"$f":"(G157*H157)*I157","v":176194.42334246571}]
[]
[]
[]
[null,null,null,null,null,null,"Total",null,null,{"$f":"ROUND(SUM(J29:J153),-3)","v":7729000}]
[]
[null,null,null,null,null,null,"Capital",null,null,11892700]
[]
[]
[null,null,null,null,null,null,"Total",null,null,{"$f":"ROUND(SUM(J161:J163),)","v":19621700}]