{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hoja1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":12,"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":191,"n_cols":14,"rows_kept":191,"cut":false,"hidden":false,"merged":[[7,7,8,9],[190,2,192,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Medic y Odont","Otros"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"SIMULADOR ESTÁNDAR",null,null,null,null,null,"2013-12-20","2013-12-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-10","2014-01-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-17","2014-01-24"]
[]
[null,null,"Valor Matricula",10923100,null,{"$f":"+IF(D8=0,\"Por favor digite el valor  matrícula (Sin Recargo Extraordinario)\",\"\")","v":""},null,null,null,null,null,null,0]
[null,null,"Número de Cuotas",6,null,{"$f":"+IF(AND(D9=5,Fecha_Vencimiento_Factura=N6),\"Última fecha solo podrá financiar a 4 contados\",IF(D9=0,\"Por favor digite el número de cuotas\",\"\"))","v":""}]
[null,"*","Fecha Vencimiento Factura","2020-06-02",null,{"$f":"+IF(D10=\"\",\"Por favor seleccione la fecha en la cual desea iniciar su plan de pagos\",IF(D10< TODAY(),\"Fecha no válida, por favor verifique\",\"\"))","v":""}]
[null,null,"Tasa de Interes de Financiación",0.01,{"$f":"+(1%*12)/365","v":3.2876712328767124E-4}]
[null,null,"Valor Matricula Extraordinaria",0]
[]
[]
[null,null,null,{"$f":"IF(D8=\"\",\"\",\"PERIODO\")","v":"PERIODO"},null,{"$f":"IF(D8=\"\",\"\",\"MATRICULA\")","v":"MATRICULA"},{"$f":"IF(D8=\"\",\"\",\"INTERES DE FINANCIACIÓN/ EXTRAORDINARIA\")","v":"INTERES DE FINANCIACIÓN/ EXTRAORDINARIA"},{"$f":"IF(D8=\"\",\"\",\"SALDO CAPITAL\")","v":"SALDO CAPITAL"},{"$f":"IF(D8=\"\",\"\",\"PAGO MENSUAL\")","v":"PAGO MENSUAL"},{"$f":"IF(D8=\"\",\"\",\"FECHA DE PAGO\")","v":"FECHA DE PAGO"}]
[null,null,null,{"$f":"IF(F9<>\"\",\"\",IF(F10<>\"\",\"\",IF(D8<>\"\",1,\"\")))","v":1},null,{"$f":"+IF(F9<>\"\",\"\",IF(F10<>\"\",\"\",IF($D$9=2,$D$8*50%,IF($D$9=3,$D$8*40%,IF($D$9=4,$D$8*25%,IF($D$9=5,$D$8*20%,IF($D$9=6,D8*20%,0)))))))","v":2184620},{"$f":"+IF(F10<>\"\",\"\",IF(D12=\"\",\"\",D12))","v":0},{"$f":"IF(F9<>\"\",\"\",IF(F10<>\"\",\"\",IF(F10<>\"\",\"\",+D8-F16)))","v":8738480},{"$f":"IFERROR(IF(F10<>\"\",\"\",+F16+D12),\"\")","v":2184620},{"$f":"IF(F9<>\"\",\"\",IF(F10<>\"\",\"\",IF(D8<>\"\",D10,\"\")))","v":"2020-06-02"}]
[null,null,null,{"$f":"IF(D16<D9,D16+1,\"\")","v":2},null,{"$f":"IF(F10<>\"\",\"\",IF(D17<>\"\",IF($D$9=2,$D$8*50%,IF($D$9=3,$D$8*30%,IF($D$9=4,$D$8*25%,IF($D$9=5,$D$8*20%,IF($D$9=6,$D$8*16%,0))))),\"\"))","v":1747696},{"$f":"IF(F10<>\"\",\"\",IF(D17<>\"\",H16*$E$11*K17,\"\"))","v":86187.747945205483},{"$f":"IF(F10<>\"\",\"\",IF(D17<>\"\",+H16-F17,\"\"))","v":6990784},{"$f":"IF(F10<>\"\",\"\",IF(D17<>\"\",F17+G17,\"\"))","v":1833883.7479452055},{"$f":"IF(F10<>\"\",\"\",IF(D17<>\"\",EDATE(J16,1),\"\"))","v":"2020-07-02"},{"$f":"+J17-J16","v":30}]
[null,null,null,{"$f":"IF(D17<$D$9,D17+1,\"\")","v":3},null,{"$f":"IF(F10<>\"\",\"\",IF(D18<>\"\",IF($D$9=2,$D$8*50%,IF($D$9=3,$D$8*30%,IF($D$9=4,$D$8*25%,IF($D$9=5,$D$8*20%,IF($D$9=6,$D$8*16%,0))))),\"\"))","v":1747696},{"$f":"IF(F10<>\"\",\"\",IF(D18<>\"\",H17*$E$11*K18,\"\"))","v":71248.538301369874},{"$f":"IF(F10<>\"\",\"\",IF(D18<>\"\",+H17-F18,\"\"))","v":5243088},{"$f":"IF(F10<>\"\",\"\",IF(D18<>\"\",F18+G18,\"\"))","v":1818944.5383013699},{"$f":"IF(F10<>\"\",\"\",IF(D18<>\"\",EDATE(J17,1),\"\"))","v":"2020-08-02"},{"$f":"+J18-J17","v":31}]
[null,null,null,{"$f":"IF(D18<$D$9,D18+1,\"\")","v":4},null,{"$f":"IF(F10<>\"\",\"\",IF(D19<>\"\",IF($D$9=2,$D$8*50%,IF($D$9=3,$D$8*30%,IF($D$9=4,$D$8*25%,IF($D$9=5,$D$8*20%,IF($D$9=6,$D$8*16%,0))))),\"\"))","v":1747696},{"$f":"IF(F10<>\"\",\"\",IF(D19<>\"\",H18*$E$11*K19,\"\"))","v":53436.403726027398},{"$f":"IF(F10<>\"\",\"\",IF(D19<>\"\",+H18-F19,\"\"))","v":3495392},{"$f":"IF(F10<>\"\",\"\",IF(D19<>\"\",F19+G19,\"\"))","v":1801132.4037260273},{"$f":"IF(F10<>\"\",\"\",IF(D19<>\"\",EDATE(J18,1),\"\"))","v":"2020-09-02"},{"$f":"+J19-J18","v":31}]
[null,null,null,{"$f":"IF(D19<$D$9,D19+1,\"\")","v":5},null,{"$f":"IF(F10<>\"\",\"\",IF(D20<>\"\",IF($D$9=2,$D$8*50%,IF($D$9=3,$D$8*30%,IF($D$9=4,$D$8*30%,IF($D$9=5,$D$8*20%,IF($D$9=6,$D$8*16%,0))))),\"\"))","v":1747696},{"$f":"IF(F10<>\"\",\"\",IF(D20<>\"\",H19*$E$11*K20,\"\"))","v":34475.099178082193},{"$f":"IF(F10<>\"\",\"\",IF(D20<>\"\",H19-F20,\"\"))","v":1747696},{"$f":"IF(F10<>\"\",\"\",IF(D20<>\"\",F20+G20,\"\"))","v":1782171.0991780823},{"$f":"IF(F10<>\"\",\"\",IF(D20<>\"\",EDATE(J19,1),\"\"))","v":"2020-10-02"},{"$f":"+J20-J19","v":30}]
[null,null,null,{"$f":"IF(D20<$D$9,D20+1,\"\")","v":6},null,{"$f":"IF(F11<>\"\",\"\",IF(D21<>\"\",IF($D$9=2,$D$8*50%,IF($D$9=3,$D$8*30%,IF($D$9=4,$D$8*30%,IF($D$9=5,$D$8*20%,IF($D$9=6,$D$8*16%,0))))),\"\"))","v":1747696},{"$f":"IF(F11<>\"\",\"\",IF(D21<>\"\",H20*$E$11*K21,\"\"))","v":17812.134575342468},{"$f":"IF(F11<>\"\",\"\",IF(D21<>\"\",H20-F21,\"\"))","v":0},{"$f":"IF(F11<>\"\",\"\",IF(D21<>\"\",F21+G21,\"\"))","v":1765508.1345753425},{"$f":"IF(F11<>\"\",\"\",IF(D21<>\"\",EDATE(J20,1),\"\"))","v":"2020-11-02"},{"$f":"+J21-J20","v":31}]
[null,null,null,{"$f":"IF(D23<$D$9,D23+1,\"\")","v":""}]
[null,null,null,"TOTAL",null,{"$f":"SUM(F16:F21)","v":10923100},{"$f":"SUM(G16:G21)","v":263159.92372602742}]
[]
[]
[null,null,null,null,null,null,"SIMULADOR CUOTA VARIABLE"]
[]
[]
[null,null,"Valor Matricula",1000000,null,{"$f":"+IF(D29=0,\"Por favor digite el valor  matrícula (Sin Recargo Extraordinario)\",\"\")","v":""}]
[null,null,"Valor Deseado 1ra Cuota",200000,null,{"$f":"+IF(D30<(D29*20%),\"Recuerde que el valor no puede ser Inferior al 20% de la  matrícula, El monto debe ser mayor a   \"&DOLLAR((D29*20%)),\"\")","v":""}]
[null,null,"Número de Cuotas",5,null,{"$f":"+IF(AND(D31=5,D33=N6),\"Última fecha solo podrá financiar a 4 contados\",IF(D31=0,\"Por favor digite el número de cuotas\",\"\"))","v":""}]
[null,null,"Tasa de Interes de Financiación",0.01,{"$f":"+(1%*12)/365","v":3.2876712328767124E-4}]
[null,null,"Fecha Vencimiento Factura","2020-06-02",null,{"$f":"+IF(D33=\"\",\"Por favor seleccione la fecha en la cual desea iniciar su plan de pagos\",IF(D33< TODAY(),\"Fecha no válida, por favor verifique\",\"\"))","v":""}]
[null,null,"Valor Matricula Extraordinaria",0]
[]
[null,null,null,{"$f":"IF(D29=\"\",\"\",\"PERIODO\")","v":"PERIODO"},null,{"$f":"IF(D29=\"\",\"\",\"MATRICULA\")","v":"MATRICULA"},{"$f":"IF(D29=\"\",\"\",\"INTERES DE FINANCIACIÓN/ EXTRAORDINARIA\")","v":"INTERES DE FINANCIACIÓN/ EXTRAORDINARIA"},{"$f":"IF(D29=\"\",\"\",\"SALDO CAPITAL\")","v":"SALDO CAPITAL"},{"$f":"IF(D29=\"\",\"\",\"PAGO MENSUAL\")","v":"PAGO MENSUAL"},{"$f":"IF(D29=\"\",\"\",\"FECHA DE PAGO\")","v":"FECHA DE PAGO"}]
[null,null,null,{"$f":"IF(F31=\"\",IF(F33<>\"\",\"\",IF(D29<>\"\",1,\"\")),\"\")","v":1},null,{"$f":"+IF(F31=\"\",IF(F33<>\"\",\"\",IF($D$31=2,IF(D30>=D29*20%,D30-G37,\"Menor al 20%\"),IF($D$31=3,IF(D30>=D29*20%,D30-G37,\"Menor al 20%\"),IF($D$31=4,IF(D30>=D29*20%,D30-G37,\"Menor al 20%\"),IF($D$31=5,IF(D30>=D29*20%,D30-G37,\"Menor al 20%\"),IF($D$31=6,IF(D30>=D29*20%,D30-G37,\"Menor al 20%\"),0)))))),\"\")","v":200000},{"$f":"+IF(F31<>\"\",\"\",IF(D34=\"\",\"\",D34))","v":0},{"$f":"+IFERROR(IF(F31=\"\",IF(F33<>\"\",\"\",D29-F37),\"\"),\"\")","v":800000},{"$f":"IFERROR(IF(F37=\"\",D29+G37,F37+G37),\"\")","v":200000},{"$f":"IF(F31=\"\",IF(F33<>\"\",\"\",IF(D29<>\"\",D33,\"\")),\"\")","v":"2020-06-02"}]
[null,null,null,{"$f":"IF(D37<$D$31,IF(F37=\"Menor al 20%\",\"\",IF(F37=\"Menor al 20%\",\"\",IF(F37=\"Menor al 20%\",\"\",IF(F37=\"Menor al 20%\",\"\",D37+1)))),\"\")","v":2},null,{"$f":"IF(F33<>\"\",\"\",IF(D38<>\"\",IF($D$31=2,H37,IF($D$31=3,H37/2,IF($D$31=4,H37/3,IF($D$31=5,H37/4,IF($D$31=6,H37/5,0))))),\"\"))","v":200000},{"$f":"IF(F33<>\"\",\"\",IF(D38<>\"\",H37*E32*K38,\"\"))","v":7890.4109589041109},{"$f":"IF(F33<>\"\",\"\",IF(D38<>\"\",+H37-F38,\"\"))","v":600000},{"$f":"IF(F33<>\"\",\"\",IF(D38<>\"\",F38+G38,\"\"))","v":207890.4109589041},{"$f":"IF(F33<>\"\",\"\",IF(D38<>\"\",EDATE(J37,1),\"\"))","v":"2020-07-02"},{"$f":"+J38-J37","v":30}]
[null,null,null,{"$f":"IF(D38<$D$31,D38+1,\"\")","v":3},null,{"$f":"IF(D39<>\"\",IF($D$31=2,$D$8*50%,IF($D$31=3,F38,IF($D$31=4,F38,IF($D$31=5,F38,IF($D$31=6,H37/5,0))))),\"\")","v":200000},{"$f":"IF(F33<>\"\",\"\",IF(D39<>\"\",H38*E32*K39,\"\"))","v":6115.0684931506848},{"$f":"IF(F33<>\"\",\"\",IF(D39<>\"\",+H38-F39,\"\"))","v":400000},{"$f":"IF(F33<>\"\",\"\",IF(D39<>\"\",F39+G39,\"\"))","v":206115.0684931507},{"$f":"IF(F33<>\"\",\"\",IF(D39<>\"\",EDATE(J38,1),\"\"))","v":"2020-08-02"},{"$f":"+J39-J38","v":31}]
[null,null,null,{"$f":"IF(D39<$D$31,D39+1,\"\")","v":4},null,{"$f":"IF(D40<>\"\",IF($D$31=2,$D$8*50%,IF($D$31=3,$D$8*30%,IF($D$31=4,F39,IF($D$31=5,F39,IF($D$31=6,H37/5,0))))),\"\")","v":200000},{"$f":"IF(F33<>\"\",\"\",IF(D40<>\"\",H39*E32*K40,\"\"))","v":4076.7123287671238},{"$f":"IF(F33<>\"\",\"\",IF(D40<>\"\",+H39-F40,\"\"))","v":200000},{"$f":"IF(F33<>\"\",\"\",IF(D40<>\"\",F40+G40,\"\"))","v":204076.71232876711},{"$f":"IF(F33<>\"\",\"\",IF(D40<>\"\",EDATE(J39,1),\"\"))","v":"2020-09-02"},{"$f":"+J40-J39","v":31}]
[null,null,null,{"$f":"IF(D40<$D$31,D40+1,\"\")","v":5},null,{"$f":"IF(D41<>\"\",IF($D$31=2,$D$8*50%,IF($D$31=3,$D$8*30%,IF($D$31=4,$D$8*30%,IF($D$31=5,F40,IF($D$31=6,H37/5,0))))),\"\")","v":200000},{"$f":"IF(F33<>\"\",\"\",IF(D41<>\"\",H40*E32*K41,\"\"))","v":1972.6027397260277},{"$f":"IF(F33<>\"\",\"\",IF(D41<>\"\",H40-F41,\"\"))","v":0},{"$f":"IF(F33<>\"\",\"\",IF(D41<>\"\",F41+G41,\"\"))","v":201972.60273972602},{"$f":"IF(F33<>\"\",\"\",IF(D41<>\"\",EDATE(J40,1),\"\"))","v":"2020-10-02"},{"$f":"+J41-J40","v":30}]
[null,null,null,{"$f":"IF(D41<$D$31,D41+1,\"\")","v":""},null,{"$f":"IF(D42<>\"\",IF($D$31=2,$D$8*50%,IF($D$31=3,$D$8*30%,IF($D$31=4,$D$8*30%,IF($D$31=5,F41,IF($D$31=6,F41,0))))),\"\")","v":""},{"$f":"IF(F34<>\"\",\"\",IF(D42<>\"\",H41*E32*K42,\"\"))","v":""},{"$f":"IF(F34<>\"\",\"\",IF(D42<>\"\",H41-F42,\"\"))","v":""},{"$f":"IF(F34<>\"\",\"\",IF(D42<>\"\",F42+G42,\"\"))","v":""},{"$f":"IF(F34<>\"\",\"\",IF(D42<>\"\",EDATE(J41,1),\"\"))","v":""},{"$f":"+J42-J41","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(D44<$D$9,D44+1,\"\")","v":""}]
[null,null,null,"TOTAL",null,{"$f":"SUM(F37:F42)","v":1000000},{"$f":"SUM(G37:G42)","v":20054.794520547948}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"*Recuerde \"Fecha de vencimiento Factura\" debe ser la misma fecha de su orden de pago financiera. Si desea realizar su crédito sobre segunda o tercera fecha, solo podrá acceder a un plan de pagos hasta en 5 ó 4 cuotas respectivamente."]