{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hoja1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":182,"n_cols":7,"rows_kept":182,"cut":false,"hidden":false,"merged":[[122,0,133,0],[170,0,181,0],[38,0,49,0],[86,0,97,0],[98,0,109,0],[158,0,169,0],[10,0,10,3],[12,0,12,3],[14,0,25,0],[146,0,157,0],[62,0,73,0],[134,0,145,0],[8,0,8,4],[110,0,121,0],[74,0,85,0],[0,0,0,5],[1,0,1,5],[2,0,2,4],[4,0,4,4],[6,0,6,4],[50,0,61,0],[26,0,37,0]]}
["TABLA LIQUIDACIÓN INTERESES DE MORA DIAN"]
["DESDE ENERO 01 DE 2008"]
["IMPUESTO",null,null,null,null,0]
[]
["VENCIMIENTO",null,null,null,null,"2008-01-01"]
[null,null,null,null,null,"2017-11-24"]
["FECHA PAGO DEUDA",null,null,null,null,"2008-01-01"]
[]
["DIAS DE MORA",null,null,null,null,{"$f":"F7-F5","v":0}]
[]
["TOTAL INTERES DE MORA",null,null,null,null,{"$f":"ROUND(SUM(F15:F170),-3)","v":0}]
[]
["TOTAL A PAGAR",null,null,null,null,{"$f":"+F3+F11","v":0}]
[null,null,null,null,null,null,"DILIGENCIAR SOLO CELDAS COLOR NARANJA"]
[2008,"Enero","2008-01-31",0.32750000000000001,{"$f":"IF(C15<$F$5,0,IF(C15>$F$7,($F$7-$F$5),(C15-$F$5)))","v":0}]
[null,"Febrero","2008-02-29",0.32750000000000001,{"$f":"IF(C16<$F$5,0,IF(C16>$F$7,($F$7-$F$5),(C16-$F$5)))-SUM($E$15:E15)","v":0}]
[null,"Marzo","2008-03-31",0.32750000000000001,{"$f":"IF(C17<$F$5,0,IF(C17>$F$7,($F$7-$F$5),(C17-$F$5)))-SUM($E$15:E16)","v":0},{"$f":"ROUND(+$F$3*(D17/365)*(SUM(E15:E17)),-3)","v":0}]
[null,"Abril","2008-04-30",0.32879999999999998,{"$f":"IF(C18<$F$5,0,IF(C18>$F$7,($F$7-$F$5),(C18-$F$5)))-SUM($E$15:E17)","v":0}]
[null,"Mayo","2008-05-31",0.32879999999999998,{"$f":"IF(C19<$F$5,0,IF(C19>$F$7,($F$7-$F$5),(C19-$F$5)))-SUM($E$15:E18)","v":0}]
[null,"Junio","2008-06-30",0.32879999999999998,{"$f":"IF(C20<$F$5,0,IF(C20>$F$7,($F$7-$F$5),(C20-$F$5)))-SUM($E$15:E19)","v":0},{"$f":"ROUND(+$F$3*(D20/365)*(SUM(E18:E20)),-3)","v":0}]
[null,"Julio","2008-07-31",0.32269999999999999,{"$f":"IF(C21<$F$5,0,IF(C21>$F$7,($F$7-$F$5),(C21-$F$5)))-SUM($E$15:E20)","v":0}]
[null,"Agosto","2008-08-31",0.32269999999999999,{"$f":"IF(C22<$F$5,0,IF(C22>$F$7,($F$7-$F$5),(C22-$F$5)))-SUM($E$15:E21)","v":0}]
[null,"Septiembre","2008-09-30",0.32269999999999999,{"$f":"IF(C23<$F$5,0,IF(C23>$F$7,($F$7-$F$5),(C23-$F$5)))-SUM($E$15:E22)","v":0},{"$f":"ROUND(+$F$3*(D23/365)*(SUM(E21:E23)),-3)","v":0}]
[null,"Octubre","2008-10-31",0.31530000000000002,{"$f":"IF(C24<$F$5,0,IF(C24>$F$7,($F$7-$F$5),(C24-$F$5)))-SUM($E$15:E23)","v":0}]
[null,"Noviembre","2008-11-30",0.31530000000000002,{"$f":"IF(C25<$F$5,0,IF(C25>$F$7,($F$7-$F$5),(C25-$F$5)))-SUM($E$15:E24)","v":0}]
[null,"Diciembre","2008-12-31",0.31530000000000002,{"$f":"IF(C26<$F$5,0,IF(C26>$F$7,($F$7-$F$5),(C26-$F$5)))-SUM($E$15:E25)","v":0},{"$f":"ROUND(+$F$3*(D26/365)*(SUM(E24:E26)),-3)","v":0}]
[2009,"Enero","2009-01-31",0.30709999999999998,{"$f":"IF(C27<$F$5,0,IF(C27>$F$7,($F$7-$F$5),(C27-$F$5)))-SUM($E$15:E26)","v":0}]
[null,"Febrero","2009-02-28",0.30709999999999998,{"$f":"IF(C28<$F$5,0,IF(C28>$F$7,($F$7-$F$5),(C28-$F$5)))-SUM($E$15:E27)","v":0}]
[null,"Marzo","2009-03-31",0.30709999999999998,{"$f":"IF(C29<$F$5,0,IF(C29>$F$7,($F$7-$F$5),(C29-$F$5)))-SUM($E$15:E28)","v":0},{"$f":"ROUND(+$F$3*(D29/365)*(SUM(E27:E29)),-3)","v":0}]
[null,"Abril","2009-04-30",0.30420000000000003,{"$f":"IF(C30<$F$5,0,IF(C30>$F$7,($F$7-$F$5),(C30-$F$5)))-SUM($E$15:E29)","v":0}]
[null,"Mayo","2009-05-31",0.30420000000000003,{"$f":"IF(C31<$F$5,0,IF(C31>$F$7,($F$7-$F$5),(C31-$F$5)))-SUM($E$15:E30)","v":0}]
[null,"Junio","2009-06-30",0.30420000000000003,{"$f":"IF(C32<$F$5,0,IF(C32>$F$7,($F$7-$F$5),(C32-$F$5)))-SUM($E$15:E31)","v":0},{"$f":"ROUND(+$F$3*(D32/365)*(SUM(E30:E32)),-3)","v":0}]
[null,"Julio","2009-07-31",0.27979999999999999,{"$f":"IF(C33<$F$5,0,IF(C33>$F$7,($F$7-$F$5),(C33-$F$5)))-SUM($E$15:E32)","v":0}]
[null,"Agosto","2009-08-31",0.27979999999999999,{"$f":"IF(C34<$F$5,0,IF(C34>$F$7,($F$7-$F$5),(C34-$F$5)))-SUM($E$15:E33)","v":0}]
[null,"Septiembre","2009-09-30",0.27979999999999999,{"$f":"IF(C35<$F$5,0,IF(C35>$F$7,($F$7-$F$5),(C35-$F$5)))-SUM($E$15:E34)","v":0},{"$f":"ROUND(+$F$3*(D35/365)*(SUM(E33:E35)),-3)","v":0}]
[null,"Octubre","2009-10-31",0.25919999999999999,{"$f":"IF(C36<$F$5,0,IF(C36>$F$7,($F$7-$F$5),(C36-$F$5)))-SUM($E$15:E35)","v":0}]
[null,"Noviembre","2009-11-30",0.25919999999999999,{"$f":"IF(C37<$F$5,0,IF(C37>$F$7,($F$7-$F$5),(C37-$F$5)))-SUM($E$15:E36)","v":0}]
[null,"Diciembre","2009-12-31",0.25919999999999999,{"$f":"IF(C38<$F$5,0,IF(C38>$F$7,($F$7-$F$5),(C38-$F$5)))-SUM($E$15:E37)","v":0},{"$f":"ROUND(+$F$3*(D38/365)*(SUM(E36:E38)),-3)","v":0}]
[2010,"Enero","2010-01-31",0.24210000000000001,{"$f":"IF(C39<$F$5,0,IF(C39>$F$7,($F$7-$F$5),(C39-$F$5)))-SUM($E$15:E38)","v":0}]
[null,"Febrero","2010-02-28",0.24210000000000001,{"$f":"IF(C40<$F$5,0,IF(C40>$F$7,($F$7-$F$5),(C40-$F$5)))-SUM($E$15:E39)","v":0}]
[null,"Marzo","2010-03-31",0.24210000000000001,{"$f":"IF(C41<$F$5,0,IF(C41>$F$7,($F$7-$F$5),(C41-$F$5)))-SUM($E$15:E40)","v":0},{"$f":"ROUND(+$F$3*(D41/365)*(SUM(E39:E41)),-3)","v":0}]
[null,"Abril","2010-04-30",0.22969999999999999,{"$f":"IF(C42<$F$5,0,IF(C42>$F$7,($F$7-$F$5),(C42-$F$5)))-SUM($E$15:E41)","v":0}]
[null,"Mayo","2010-05-31",0.22969999999999999,{"$f":"IF(C43<$F$5,0,IF(C43>$F$7,($F$7-$F$5),(C43-$F$5)))-SUM($E$15:E42)","v":0}]
[null,"Junio","2010-06-30",0.22969999999999999,{"$f":"IF(C44<$F$5,0,IF(C44>$F$7,($F$7-$F$5),(C44-$F$5)))-SUM($E$15:E43)","v":0},{"$f":"ROUND(+$F$3*(D44/365)*(SUM(E42:E44)),-3)","v":0}]
[null,"Julio","2010-07-31",0.22409999999999999,{"$f":"IF(C45<$F$5,0,IF(C45>$F$7,($F$7-$F$5),(C45-$F$5)))-SUM($E$15:E44)","v":0}]
[null,"Agosto","2010-08-31",0.22409999999999999,{"$f":"IF(C46<$F$5,0,IF(C46>$F$7,($F$7-$F$5),(C46-$F$5)))-SUM($E$15:E45)","v":0}]
[null,"Septiembre","2010-09-30",0.22409999999999999,{"$f":"IF(C47<$F$5,0,IF(C47>$F$7,($F$7-$F$5),(C47-$F$5)))-SUM($E$15:E46)","v":0},{"$f":"ROUND(+$F$3*(D47/365)*(SUM(E45:E47)),-3)","v":0}]
[null,"Octubre","2010-10-31",0.2132,{"$f":"IF(C48<$F$5,0,IF(C48>$F$7,($F$7-$F$5),(C48-$F$5)))-SUM($E$15:E47)","v":0}]
[null,"Noviembre","2010-11-30",0.2132,{"$f":"IF(C49<$F$5,0,IF(C49>$F$7,($F$7-$F$5),(C49-$F$5)))-SUM($E$15:E48)","v":0}]
[null,"Diciembre","2010-12-31",0.2132,{"$f":"IF(C50<$F$5,0,IF(C50>$F$7,($F$7-$F$5),(C50-$F$5)))-SUM($E$15:E49)","v":0},{"$f":"ROUND(+$F$3*(D50/365)*(SUM(E48:E50)),-3)","v":0}]
[2011,"Enero","2011-01-31",0.23419999999999999,{"$f":"IF(C51<$F$5,0,IF(C51>$F$7,($F$7-$F$5),(C51-$F$5)))-SUM($E$15:E50)","v":0}]
[null,"Febrero","2011-02-28",0.23419999999999999,{"$f":"IF(C52<$F$5,0,IF(C52>$F$7,($F$7-$F$5),(C52-$F$5)))-SUM($E$15:E51)","v":0}]
[null,"Marzo","2011-03-31",0.23419999999999999,{"$f":"IF(C53<$F$5,0,IF(C53>$F$7,($F$7-$F$5),(C53-$F$5)))-SUM($E$15:E52)","v":0},{"$f":"ROUND(+$F$3*(D53/365)*(SUM(E51:E53)),-3)","v":0}]
[null,"Abril","2011-04-30",0.26540000000000002,{"$f":"IF(C54<$F$5,0,IF(C54>$F$7,($F$7-$F$5),(C54-$F$5)))-SUM($E$15:E53)","v":0}]
[null,"Mayo","2011-05-31",0.26540000000000002,{"$f":"IF(C55<$F$5,0,IF(C55>$F$7,($F$7-$F$5),(C55-$F$5)))-SUM($E$15:E54)","v":0}]
[null,"Junio","2011-06-30",0.26540000000000002,{"$f":"IF(C56<$F$5,0,IF(C56>$F$7,($F$7-$F$5),(C56-$F$5)))-SUM($E$15:E55)","v":0},{"$f":"ROUND(+$F$3*(D56/365)*(SUM(E54:E56)),-3)","v":0}]
[null,"Julio","2011-07-31",0.27950000000000003,{"$f":"IF(C57<$F$5,0,IF(C57>$F$7,($F$7-$F$5),(C57-$F$5)))-SUM($E$15:E56)","v":0}]
[null,"Agosto","2011-08-31",0.27950000000000003,{"$f":"IF(C58<$F$5,0,IF(C58>$F$7,($F$7-$F$5),(C58-$F$5)))-SUM($E$15:E57)","v":0}]
[null,"Septiembre","2011-09-30",0.27950000000000003,{"$f":"IF(C59<$F$5,0,IF(C59>$F$7,($F$7-$F$5),(C59-$F$5)))-SUM($E$15:E58)","v":0},{"$f":"ROUND(+$F$3*(D59/365)*(SUM(E57:E59)),-3)","v":0}]
[null,"Octubre","2011-10-31",0.29089999999999999,{"$f":"IF(C60<$F$5,0,IF(C60>$F$7,($F$7-$F$5),(C60-$F$5)))-SUM($E$15:E59)","v":0}]
[null,"Noviembre","2011-11-30",0.29089999999999999,{"$f":"IF(C61<$F$5,0,IF(C61>$F$7,($F$7-$F$5),(C61-$F$5)))-SUM($E$15:E60)","v":0}]
[null,"Diciembre","2011-12-31",0.29089999999999999,{"$f":"IF(C62<$F$5,0,IF(C62>$F$7,($F$7-$F$5),(C62-$F$5)))-SUM($E$15:E61)","v":0},{"$f":"ROUND(+$F$3*(D62/365)*(SUM(E60:E62)),-3)","v":0}]
[2012,"Enero","2012-01-31",0.29880000000000001,{"$f":"IF(C63<$F$5,0,IF(C63>$F$7,($F$7-$F$5),(C63-$F$5)))-SUM($E$15:E62)","v":0}]
[null,"Febrero","2012-02-29",0.29880000000000001,{"$f":"IF(C64<$F$5,0,IF(C64>$F$7,($F$7-$F$5),(C64-$F$5)))-SUM($E$15:E63)","v":0}]
[null,"Marzo","2012-03-31",0.29880000000000001,{"$f":"IF(C65<$F$5,0,IF(C65>$F$7,($F$7-$F$5),(C65-$F$5)))-SUM($E$15:E64)","v":0},{"$f":"ROUND(+$F$3*(D65/365)*(SUM(E63:E65)),-3)","v":0}]
[null,"Abril","2012-04-30",0.30780000000000002,{"$f":"IF(C66<$F$5,0,IF(C66>$F$7,($F$7-$F$5),(C66-$F$5)))-SUM($E$15:E65)","v":0}]
[null,"Mayo","2012-05-31",0.30780000000000002,{"$f":"IF(C67<$F$5,0,IF(C67>$F$7,($F$7-$F$5),(C67-$F$5)))-SUM($E$15:E66)","v":0}]
[null,"Junio","2012-06-30",0.30780000000000002,{"$f":"IF(C68<$F$5,0,IF(C68>$F$7,($F$7-$F$5),(C68-$F$5)))-SUM($E$15:E67)","v":0},{"$f":"ROUND(+$F$3*(D68/365)*(SUM(E66:E68)),-3)","v":0}]
[null,"Julio","2012-07-31",0.31290000000000001,{"$f":"IF(C69<$F$5,0,IF(C69>$F$7,($F$7-$F$5),(C69-$F$5)))-SUM($E$15:E68)","v":0}]
[null,"Agosto","2012-08-31",0.31290000000000001,{"$f":"IF(C70<$F$5,0,IF(C70>$F$7,($F$7-$F$5),(C70-$F$5)))-SUM($E$15:E69)","v":0}]
[null,"Septiembre","2012-09-30",0.31290000000000001,{"$f":"IF(C71<$F$5,0,IF(C71>$F$7,($F$7-$F$5),(C71-$F$5)))-SUM($E$15:E70)","v":0},{"$f":"ROUND(+$F$3*(D71/365)*(SUM(E69:E71)),-3)","v":0}]
[null,"Octubre","2012-10-31",0.31340000000000001,{"$f":"IF(C72<$F$5,0,IF(C72>$F$7,($F$7-$F$5),(C72-$F$5)))-SUM($E$15:E71)","v":0}]
[null,"Noviembre","2012-11-30",0.31340000000000001,{"$f":"IF(C73<$F$5,0,IF(C73>$F$7,($F$7-$F$5),(C73-$F$5)))-SUM($E$15:E72)","v":0}]
[null,"Diciembre","2012-12-31",0.31340000000000001,{"$f":"IF(C74<$F$5,0,IF(C74>$F$7,($F$7-$F$5),(C74-$F$5)))-SUM($E$15:E73)","v":0},{"$f":"ROUND(+$F$3*(D74/365)*(SUM(E72:E74)),-3)","v":0}]
[2013,"Enero","2013-01-31",0.31130000000000002,{"$f":"IF(C75<$F$5,0,IF(C75>$F$7,($F$7-$F$5),(C75-$F$5)))-SUM($E$15:E74)","v":0}]
[null,"Febrero","2013-02-28",0.31130000000000002,{"$f":"IF(C76<$F$5,0,IF(C76>$F$7,($F$7-$F$5),(C76-$F$5)))-SUM($E$15:E75)","v":0}]
[null,"Marzo","2013-03-31",0.31130000000000002,{"$f":"IF(C77<$F$5,0,IF(C77>$F$7,($F$7-$F$5),(C77-$F$5)))-SUM($E$15:E76)","v":0},{"$f":"ROUND(+$F$3*(D77/366)*(SUM(E75:E77)),-3)","v":0}]
[null,"Abril","2013-04-30",0.3125,{"$f":"IF(C78<$F$5,0,IF(C78>$F$7,($F$7-$F$5),(C78-$F$5)))-SUM($E$15:E77)","v":0}]
[null,"Mayo","2013-05-31",0.3125,{"$f":"IF(C79<$F$5,0,IF(C79>$F$7,($F$7-$F$5),(C79-$F$5)))-SUM($E$15:E78)","v":0}]
[null,"Junio","2013-06-30",0.3125,{"$f":"IF(C80<$F$5,0,IF(C80>$F$7,($F$7-$F$5),(C80-$F$5)))-SUM($E$15:E79)","v":0},{"$f":"ROUND(+$F$3*(D80/366)*(SUM(E78:E80)),-3)","v":0}]
[null,"Julio","2013-07-31",0.30509999999999998,{"$f":"IF(C81<$F$5,0,IF(C81>$F$7,($F$7-$F$5),(C81-$F$5)))-SUM($E$15:E80)","v":0}]
[null,"Agosto ","2013-08-31",0.30509999999999998,{"$f":"IF(C82<$F$5,0,IF(C82>$F$7,($F$7-$F$5),(C82-$F$5)))-SUM($E$15:E81)","v":0}]
[null,"Septiembre","2013-09-30",0.30509999999999998,{"$f":"IF(C83<$F$5,0,IF(C83>$F$7,($F$7-$F$5),(C83-$F$5)))-SUM($E$15:E82)","v":0},{"$f":"ROUND(+$F$3*(D83/366)*(SUM(E81:E83)),-3)","v":0}]
[null,"Octubre","2013-10-31",0.29780000000000001,{"$f":"IF(C84<$F$5,0,IF(C84>$F$7,($F$7-$F$5),(C84-$F$5)))-SUM($E$15:E83)","v":0}]
[null,"Noviembre","2013-11-30",0.29780000000000001,{"$f":"IF(C85<$F$5,0,IF(C85>$F$7,($F$7-$F$5),(C85-$F$5)))-SUM($E$15:E84)","v":0}]
[null,"Diciembre","2013-12-31",0.29780000000000001,{"$f":"IF(C86<$F$5,0,IF(C86>$F$7,($F$7-$F$5),(C86-$F$5)))-SUM($E$15:E85)","v":0},{"$f":"ROUND(+$F$3*(D86/366)*(SUM(E84:E86)),-3)","v":0}]
[2014,"Enero","2014-01-31",0.29480000000000001,{"$f":"IF(C87<$F$5,0,IF(C87>$F$7,($F$7-$F$5),(C87-$F$5)))-SUM($E$15:E86)","v":0}]
[null,"Febrero","2014-02-28",0.29480000000000001,{"$f":"IF(C88<$F$5,0,IF(C88>$F$7,($F$7-$F$5),(C88-$F$5)))-SUM($E$15:E87)","v":0}]
[null,"Marzo","2014-03-31",0.29480000000000001,{"$f":"IF(C89<$F$5,0,IF(C89>$F$7,($F$7-$F$5),(C89-$F$5)))-SUM($E$15:E88)","v":0},{"$f":"ROUND(+$F$3*(D89/366)*(SUM(E87:E89)),-3)","v":0}]
[null,"Abril","2014-04-30",0.29449999999999998,{"$f":"IF(C90<$F$5,0,IF(C90>$F$7,($F$7-$F$5),(C90-$F$5)))-SUM($E$15:E89)","v":0}]
[null,"Mayo","2014-05-31",0.29449999999999998,{"$f":"IF(C91<$F$5,0,IF(C91>$F$7,($F$7-$F$5),(C91-$F$5)))-SUM($E$15:E90)","v":0}]
[null,"Junio","2014-06-30",0.29449999999999998,{"$f":"IF(C92<$F$5,0,IF(C92>$F$7,($F$7-$F$5),(C92-$F$5)))-SUM($E$15:E91)","v":0},{"$f":"ROUND(+$F$3*(D92/366)*(SUM(E90:E92)),-3)","v":0}]
[null,"Julio","2014-07-31",0.28999999999999998,{"$f":"IF(C93<$F$5,0,IF(C93>$F$7,($F$7-$F$5),(C93-$F$5)))-SUM($E$15:E92)","v":0}]
[null,"Agosto ","2014-08-31",0.28999999999999998,{"$f":"IF(C94<$F$5,0,IF(C94>$F$7,($F$7-$F$5),(C94-$F$5)))-SUM($E$15:E93)","v":0}]
[null,"Septiembre","2014-09-30",0.28999999999999998,{"$f":"IF(C95<$F$5,0,IF(C95>$F$7,($F$7-$F$5),(C95-$F$5)))-SUM($E$15:E94)","v":0},{"$f":"ROUND(+$F$3*(D95/366)*(SUM(E93:E95)),-3)","v":0}]
[null,"Octubre","2014-10-31",0.28760000000000002,{"$f":"IF(C96<$F$5,0,IF(C96>$F$7,($F$7-$F$5),(C96-$F$5)))-SUM($E$15:E95)","v":0}]
[null,"Noviembre","2014-11-30",0.28760000000000002,{"$f":"IF(C97<$F$5,0,IF(C97>$F$7,($F$7-$F$5),(C97-$F$5)))-SUM($E$15:E96)","v":0}]
[null,"Diciembre","2014-12-31",0.28760000000000002,{"$f":"IF(C98<$F$5,0,IF(C98>$F$7,($F$7-$F$5),(C98-$F$5)))-SUM($E$15:E97)","v":0},{"$f":"ROUND(+$F$3*(D98/366)*(SUM(E96:E98)),-3)","v":0}]
[2015,"Enero","2015-01-31",0.28820000000000001,{"$f":"IF(C99<$F$5,0,IF(C99>$F$7,($F$7-$F$5),(C99-$F$5)))-SUM($E$15:E98)","v":0}]
[null,"Febrero","2015-02-28",0.28820000000000001,{"$f":"IF(C100<$F$5,0,IF(C100>$F$7,($F$7-$F$5),(C100-$F$5)))-SUM($E$15:E99)","v":0}]
[null,"Marzo","2015-03-31",0.28820000000000001,{"$f":"IF(C101<$F$5,0,IF(C101>$F$7,($F$7-$F$5),(C101-$F$5)))-SUM($E$15:E100)","v":0},{"$f":"ROUND(+$F$3*(D101/366)*(SUM(E99:E101)),-3)","v":0}]
[null,"Abril","2015-04-30",0.29060000000000002,{"$f":"IF(C102<$F$5,0,IF(C102>$F$7,($F$7-$F$5),(C102-$F$5)))-SUM($E$15:E101)","v":0}]
[null,"Mayo","2015-05-31",0.29060000000000002,{"$f":"IF(C103<$F$5,0,IF(C103>$F$7,($F$7-$F$5),(C103-$F$5)))-SUM($E$15:E102)","v":0}]
[null,"Junio","2015-06-30",0.29060000000000002,{"$f":"IF(C104<$F$5,0,IF(C104>$F$7,($F$7-$F$5),(C104-$F$5)))-SUM($E$15:E103)","v":0},{"$f":"ROUND(+$F$3*(D104/366)*(SUM(E102:E104)),-3)","v":0}]
[null,"Julio","2015-07-31",0.28889999999999999,{"$f":"IF(C105<$F$5,0,IF(C105>$F$7,($F$7-$F$5),(C105-$F$5)))-SUM($E$15:E104)","v":0}]
[null,"Agosto ","2015-08-31",0.28889999999999999,{"$f":"IF(C106<$F$5,0,IF(C106>$F$7,($F$7-$F$5),(C106-$F$5)))-SUM($E$15:E105)","v":0}]
[null,"Septiembre","2015-09-30",0.28889999999999999,{"$f":"IF(C107<$F$5,0,IF(C107>$F$7,($F$7-$F$5),(C107-$F$5)))-SUM($E$15:E106)","v":0},{"$f":"ROUND(+$F$3*(D107/366)*(SUM(E105:E107)),-3)","v":0}]
[null,"Octubre","2015-10-31",0.28999999999999998,{"$f":"IF(C108<$F$5,0,IF(C108>$F$7,($F$7-$F$5),(C108-$F$5)))-SUM($E$15:E107)","v":0}]
[null,"Noviembre","2015-11-30",0.28999999999999998,{"$f":"IF(C109<$F$5,0,IF(C109>$F$7,($F$7-$F$5),(C109-$F$5)))-SUM($E$15:E108)","v":0}]
[null,"Diciembre","2015-12-31",0.28999999999999998,{"$f":"IF(C110<$F$5,0,IF(C110>$F$7,($F$7-$F$5),(C110-$F$5)))-SUM($E$15:E109)","v":0},{"$f":"ROUND(+$F$3*(D110/366)*(SUM(E108:E110)),-3)","v":0}]
[2016,"Enero","2016-01-31",0.29520000000000002,{"$f":"IF(C111<$F$5,0,IF(C111>$F$7,($F$7-$F$5),(C111-$F$5)))-SUM($E$15:E110)","v":0}]
[null,"Febrero","2016-02-29",0.29520000000000002,{"$f":"IF(C112<$F$5,0,IF(C112>$F$7,($F$7-$F$5),(C112-$F$5)))-SUM($E$15:E111)","v":0}]
[null,"Marzo","2016-03-31",0.29520000000000002,{"$f":"IF(C113<$F$5,0,IF(C113>$F$7,($F$7-$F$5),(C113-$F$5)))-SUM($E$15:E112)","v":0},{"$f":"ROUND(+$F$3*(D113/366)*(SUM(E111:E113)),-3)","v":0}]
[null,"Abril","2016-04-30",0.30809999999999998,{"$f":"IF(C114<$F$5,0,IF(C114>$F$7,($F$7-$F$5),(C114-$F$5)))-SUM($E$15:E113)","v":0}]
[null,"Mayo","2016-05-31",0.30809999999999998,{"$f":"IF(C115<$F$5,0,IF(C115>$F$7,($F$7-$F$5),(C115-$F$5)))-SUM($E$15:E114)","v":0}]
[null,"Junio","2016-06-30",0.30809999999999998,{"$f":"IF(C116<$F$5,0,IF(C116>$F$7,($F$7-$F$5),(C116-$F$5)))-SUM($E$15:E115)","v":0},{"$f":"ROUND(+$F$3*(D116/366)*(SUM(E114:E116)),-3)","v":0}]
[null,"Julio","2016-07-31",0.3201,{"$f":"IF(C117<$F$5,0,IF(C117>$F$7,($F$7-$F$5),(C117-$F$5)))-SUM($E$15:E116)","v":0}]
[null,"Agosto ","2016-08-31",0.3201,{"$f":"IF(C118<$F$5,0,IF(C118>$F$7,($F$7-$F$5),(C118-$F$5)))-SUM($E$15:E117)","v":0}]
[null,"Septiembre","2016-09-30",0.3201,{"$f":"IF(C119<$F$5,0,IF(C119>$F$7,($F$7-$F$5),(C119-$F$5)))-SUM($E$15:E118)","v":0},{"$f":"ROUND(+$F$3*(D119/366)*(SUM(E117:E119)),-3)","v":0}]
[null,"Octubre","2016-10-31",0.32990000000000003,{"$f":"IF(C120<$F$5,0,IF(C120>$F$7,($F$7-$F$5),(C120-$F$5)))-SUM($E$15:E119)","v":0}]
[null,"Noviembre","2016-11-30",0.32990000000000003,{"$f":"IF(C121<$F$5,0,IF(C121>$F$7,($F$7-$F$5),(C121-$F$5)))-SUM($E$15:E120)","v":0}]
[null,"Diciembre","2016-12-31",0.32990000000000003,{"$f":"IF(C122<$F$5,0,IF(C122>$F$7,($F$7-$F$5),(C122-$F$5)))-SUM($E$15:E121)","v":0},{"$f":"ROUND(+$F$3*(D122/366)*(SUM(E120:E122)),-3)","v":0}]
[2017,"Enero","2017-01-31",0.31509999999999999,{"$f":"IF(C123<$F$5,0,IF(C123>$F$7,($F$7-$F$5),(C123-$F$5)))-SUM($E$15:E122)","v":0}]
[null,"Febrero","2017-02-28",0.31509999999999999,{"$f":"IF(C124<$F$5,0,IF(C124>$F$7,($F$7-$F$5),(C124-$F$5)))-SUM($E$15:E123)","v":0}]
[null,"Marzo","2017-03-31",0.31509999999999999,{"$f":"IF(C125<$F$5,0,IF(C125>$F$7,($F$7-$F$5),(C125-$F$5)))-SUM($E$15:E124)","v":0},{"$f":"ROUND(+$F$3*(D125/366)*(SUM(E123:E125)),-3)","v":0}]
[null,"Abril","2017-04-30",0.315,{"$f":"IF(C126<$F$5,0,IF(C126>$F$7,($F$7-$F$5),(C126-$F$5)))-SUM($E$15:E125)","v":0}]
[null,"Mayo","2017-05-31",0.315,{"$f":"IF(C127<$F$5,0,IF(C127>$F$7,($F$7-$F$5),(C127-$F$5)))-SUM($E$15:E126)","v":0}]
[null,"Junio","2017-06-30",0.315,{"$f":"IF(C128<$F$5,0,IF(C128>$F$7,($F$7-$F$5),(C128-$F$5)))-SUM($E$15:E127)","v":0},{"$f":"ROUND(+$F$3*(D128/366)*(SUM(E126:E128)),-3)","v":0}]
[null,"Julio","2017-07-31",0.30969999999999998,{"$f":"IF(C129<$F$5,0,IF(C129>$F$7,($F$7-$F$5),(C129-$F$5)))-SUM($E$15:E128)","v":0}]
[null,"Agosto ","2017-08-31",0.30969999999999998,{"$f":"IF(C130<$F$5,0,IF(C130>$F$7,($F$7-$F$5),(C130-$F$5)))-SUM($E$15:E129)","v":0}]
[null,"Septiembre","2017-09-30",0.30220000000000002,{"$f":"IF(C131<$F$5,0,IF(C131>$F$7,($F$7-$F$5),(C131-$F$5)))-SUM($E$15:E130)","v":0},{"$f":"ROUND(+$F$3*(D131/366)*(SUM(E129:E131)),-3)","v":0}]
[null,"Octubre","2017-10-31",0.29730000000000001,{"$f":"IF(C132<$F$5,0,IF(C132>$F$7,($F$7-$F$5),(C132-$F$5)))-SUM($E$15:E131)","v":0},{"$f":"+ROUND((F3*D132*E132)/366,-3)","v":0}]
[null,"Noviembre","2017-11-30",0.2944,{"$f":"IF(C133<$F$5,0,IF(C133>$F$7,($F$7-$F$5),(C133-$F$5)))-SUM($E$15:E132)","v":0},{"$f":"+ROUND(($F$3*D133*E133)/366,-3)","v":0}]
[null,"Diciembre","2017-12-31",0.29160000000000003,{"$f":"IF(C134<$F$5,0,IF(C134>$F$7,($F$7-$F$5),(C134-$F$5)))-SUM($E$15:E133)","v":0},{"$f":"+ROUND(($F$3*D134*E134)/366,-3)","v":0}]
[2018,"Enero","2018-01-31",0.29039999999999999,{"$f":"IF(C135<$F$5,0,IF(C135>$F$7,($F$7-$F$5),(C135-$F$5)))-SUM($E$15:E134)","v":0},0]
[null,"Febrero","2018-02-28",0.29520000000000002,{"$f":"IF(C136<$F$5,0,IF(C136>$F$7,($F$7-$F$5),(C136-$F$5)))-SUM($E$15:E135)","v":0},0]
[null,"Marzo","2018-03-31",0.29020000000000001,{"$f":"IF(C137<$F$5,0,IF(C137>$F$7,($F$7-$F$5),(C137-$F$5)))-SUM($E$15:E136)","v":0},0]
[null,"Abril","2018-04-30",0.28720000000000001,{"$f":"IF(C138<$F$5,0,IF(C138>$F$7,($F$7-$F$5),(C138-$F$5)))-SUM($E$15:E137)","v":0},0]
[null,"Mayo","2018-05-31",0.28660000000000002,{"$f":"IF(C139<$F$5,0,IF(C139>$F$7,($F$7-$F$5),(C139-$F$5)))-SUM($E$15:E138)","v":0},0]
[null,"Junio","2018-06-30",0.28420000000000001,{"$f":"IF(C140<$F$5,0,IF(C140>$F$7,($F$7-$F$5),(C140-$F$5)))-SUM($E$15:E139)","v":0},0]
[null,"Julio","2018-07-31",0.28050000000000003,{"$f":"IF(C141<$F$5,0,IF(C141>$F$7,($F$7-$F$5),(C141-$F$5)))-SUM($E$15:E140)","v":0},0]
[null,"Agosto ","2018-08-31",0.27910000000000001,{"$f":"IF(C142<$F$5,0,IF(C142>$F$7,($F$7-$F$5),(C142-$F$5)))-SUM($E$15:E141)","v":0},0]
[null,"Septiembre","2018-09-30",0.2772,{"$f":"IF(C143<$F$5,0,IF(C143>$F$7,($F$7-$F$5),(C143-$F$5)))-SUM($E$15:E142)","v":0},0]
[null,"Octubre","2018-10-31",0.27450000000000002,{"$f":"IF(C144<$F$5,0,IF(C144>$F$7,($F$7-$F$5),(C144-$F$5)))-SUM($E$15:E143)","v":0},0]
[null,"Noviembre","2018-11-30",0.27239999999999998,{"$f":"IF(C145<$F$5,0,IF(C145>$F$7,($F$7-$F$5),(C145-$F$5)))-SUM($E$15:E144)","v":0},0]
[null,"Diciembre","2018-12-31",0.27100000000000002,{"$f":"IF(C146<$F$5,0,IF(C146>$F$7,($F$7-$F$5),(C146-$F$5)))-SUM($E$15:E145)","v":0},0]
[2019,"Enero","2019-01-31",0.26740000000000003,{"$f":"IF(C147<$F$5,0,IF(C147>$F$7,($F$7-$F$5),(C147-$F$5)))-SUM($E$15:E146)","v":0},0]
[null,"Febrero","2019-02-28",0.27550000000000002,{"$f":"IF(C148<$F$5,0,IF(C148>$F$7,($F$7-$F$5),(C148-$F$5)))-SUM($E$15:E147)","v":0},0]
[null,"Marzo","2019-03-31",0.27060000000000001,{"$f":"IF(C149<$F$5,0,IF(C149>$F$7,($F$7-$F$5),(C149-$F$5)))-SUM($E$15:E148)","v":0},0]
[null,"Abril","2019-04-30",0.26979999999999998,{"$f":"IF(C150<$F$5,0,IF(C150>$F$7,($F$7-$F$5),(C150-$F$5)))-SUM($E$15:E149)","v":0},0]
[null,"Mayo","2019-05-31",0.27010000000000001,{"$f":"IF(C151<$F$5,0,IF(C151>$F$7,($F$7-$F$5),(C151-$F$5)))-SUM($E$15:E150)","v":0},0]
[null,"Junio","2019-06-30",0.26950000000000002,{"$f":"IF(C152<$F$5,0,IF(C152>$F$7,($F$7-$F$5),(C152-$F$5)))-SUM($E$15:E151)","v":0},0]
[null,"Julio","2019-07-31",0.26919999999999999,{"$f":"IF(C153<$F$5,0,IF(C153>$F$7,($F$7-$F$5),(C153-$F$5)))-SUM($E$15:E152)","v":0},0]
[null,"Agosto ","2019-08-31",0.26979999999999998,{"$f":"IF(C154<$F$5,0,IF(C154>$F$7,($F$7-$F$5),(C154-$F$5)))-SUM($E$15:E153)","v":0},0]
[null,"Septiembre","2019-09-30",0.26979999999999998,{"$f":"IF(C155<$F$5,0,IF(C155>$F$7,($F$7-$F$5),(C155-$F$5)))-SUM($E$15:E154)","v":0},0]
[null,"Octubre","2019-10-31",0.26650000000000001,{"$f":"IF(C156<$F$5,0,IF(C156>$F$7,($F$7-$F$5),(C156-$F$5)))-SUM($E$15:E155)","v":0},0]
[null,"Noviembre","2019-11-30",0.26550000000000001,{"$f":"IF(C157<$F$5,0,IF(C157>$F$7,($F$7-$F$5),(C157-$F$5)))-SUM($E$15:E156)","v":0},0]
[null,"Diciembre","2019-12-31",0.26369999999999999,{"$f":"IF(C158<$F$5,0,IF(C158>$F$7,($F$7-$F$5),(C158-$F$5)))-SUM($E$15:E157)","v":0},0]
[2020,"Enero","2020-01-31",0.2616,{"$f":"IF(C159<$F$5,0,IF(C159>$F$7,($F$7-$F$5),(C159-$F$5)))-SUM($E$15:E158)","v":0},{"$f":"+ROUND(($F$3*D159*E159)/366,-3)","v":0}]
[null,"Febrero","2020-02-29",0.26590000000000003,{"$f":"IF(C160<$F$5,0,IF(C160>$F$7,($F$7-$F$5),(C160-$F$5)))-SUM($E$15:E159)","v":0},0]
[null,"Marzo","2020-03-31",0.26429999999999998,{"$f":"IF(C161<$F$5,0,IF(C161>$F$7,($F$7-$F$5),(C161-$F$5)))-SUM($E$15:E160)","v":0},0]
[null,"Abril","2020-04-30",0.26040000000000002,{"$f":"IF(C162<$F$5,0,IF(C162>$F$7,($F$7-$F$5),(C162-$F$5)))-SUM($E$15:E161)","v":0},0]
[null,"Mayo","2020-05-31",0.25290000000000001,{"$f":"IF(C163<$F$5,0,IF(C163>$F$7,($F$7-$F$5),(C163-$F$5)))-SUM($E$15:E162)","v":0},0]
[null,"Junio","2020-06-30",0.25180000000000002,{"$f":"IF(C164<$F$5,0,IF(C164>$F$7,($F$7-$F$5),(C164-$F$5)))-SUM($E$15:E163)","v":0},0]
[null,"Julio","2020-07-31",0.25180000000000002,{"$f":"IF(C165<$F$5,0,IF(C165>$F$7,($F$7-$F$5),(C165-$F$5)))-SUM($E$15:E164)","v":0},0]
[null,"Agosto ","2020-08-31",0.25440000000000002,{"$f":"IF(C166<$F$5,0,IF(C166>$F$7,($F$7-$F$5),(C166-$F$5)))-SUM($E$15:E165)","v":0},0]
[null,"Septiembre","2020-09-30",0.25530000000000003,{"$f":"IF(C167<$F$5,0,IF(C167>$F$7,($F$7-$F$5),(C167-$F$5)))-SUM($E$15:E166)","v":0},0]
[null,"Octubre","2020-10-31",0.25140000000000001,{"$f":"IF(C168<$F$5,0,IF(C168>$F$7,($F$7-$F$5),(C168-$F$5)))-SUM($E$15:E167)","v":0},0]
[null,"Noviembre","2020-11-30",0.24759999999999999,{"$f":"IF(C169<$F$5,0,IF(C169>$F$7,($F$7-$F$5),(C169-$F$5)))-SUM($E$15:E168)","v":0},0]
[null,"Diciembre","2020-12-31",0.2419,{"$f":"IF(C170<$F$5,0,IF(C170>$F$7,($F$7-$F$5),(C170-$F$5)))-SUM($E$15:E169)","v":0},0]
[2020,"Enero","2020-01-31",0.23980000000000001,{"$f":"IF(C171<$F$5,0,IF(C171>$F$7,($F$7-$F$5),(C171-$F$5)))-SUM($E$15:E170)","v":0},{"$f":"+ROUND(($F$3*D171*E171)/366,-3)","v":0}]
[null,"Febrero","2020-02-29",0,{"$f":"IF(C172<$F$5,0,IF(C172>$F$7,($F$7-$F$5),(C172-$F$5)))-SUM($E$15:E171)","v":0},0]
[null,"Marzo","2020-03-31",0,{"$f":"IF(C173<$F$5,0,IF(C173>$F$7,($F$7-$F$5),(C173-$F$5)))-SUM($E$15:E172)","v":0},0]
[null,"Abril","2020-04-30",0,{"$f":"IF(C174<$F$5,0,IF(C174>$F$7,($F$7-$F$5),(C174-$F$5)))-SUM($E$15:E173)","v":0},0]
[null,"Mayo","2020-05-31",0,{"$f":"IF(C175<$F$5,0,IF(C175>$F$7,($F$7-$F$5),(C175-$F$5)))-SUM($E$15:E174)","v":0},0]
[null,"Junio","2020-06-30",0,{"$f":"IF(C176<$F$5,0,IF(C176>$F$7,($F$7-$F$5),(C176-$F$5)))-SUM($E$15:E175)","v":0},0]
[null,"Julio","2020-07-31",0,{"$f":"IF(C177<$F$5,0,IF(C177>$F$7,($F$7-$F$5),(C177-$F$5)))-SUM($E$15:E176)","v":0},0]
[null,"Agosto ","2020-08-31",0,{"$f":"IF(C178<$F$5,0,IF(C178>$F$7,($F$7-$F$5),(C178-$F$5)))-SUM($E$15:E177)","v":0},0]
[null,"Septiembre","2020-09-30",0,{"$f":"IF(C179<$F$5,0,IF(C179>$F$7,($F$7-$F$5),(C179-$F$5)))-SUM($E$15:E178)","v":0},0]
[null,"Octubre","2020-10-31",0,{"$f":"IF(C180<$F$5,0,IF(C180>$F$7,($F$7-$F$5),(C180-$F$5)))-SUM($E$15:E179)","v":0},0]
[null,"Noviembre","2020-11-30",0,{"$f":"IF(C181<$F$5,0,IF(C181>$F$7,($F$7-$F$5),(C181-$F$5)))-SUM($E$15:E180)","v":0},0]
[null,"Diciembre","2020-12-31",0,{"$f":"IF(C182<$F$5,0,IF(C182>$F$7,($F$7-$F$5),(C182-$F$5)))-SUM($E$15:E181)","v":0},0]