{"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":[[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",null,null,{"$f":"+IF(D8=0,\"Por favor digite el valor  matrícula (Sin Recargo Extraordinario)\",\"\")","v":"Por favor digite el valor  matrícula (Sin Recargo Extraordinario)"},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",null,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":"Por favor seleccione la fecha en la cual desea iniciar su plan de pagos"}]
[null,null,"Tasa de Interes de Financiación",1.2E-2,{"$f":"+(1.2%*12)/360","v":4.0000000000000007E-4}]
[null,null,"Valor Matricula Extraordinaria",0]
[]
[]
[null,null,null,{"$f":"IF(D8=\"\",\"\",\"PERIODO\")","v":""},null,{"$f":"IF(D8=\"\",\"\",\"MATRICULA\")","v":""},{"$f":"IF(D8=\"\",\"\",\"INTERES DE FINANCIACIÓN/ EXTRAORDINARIA\")","v":""},{"$f":"IF(D8=\"\",\"\",\"SALDO CAPITAL\")","v":""},{"$f":"IF(D8=\"\",\"\",\"PAGO MENSUAL\")","v":""},{"$f":"IF(D8=\"\",\"\",\"FECHA DE PAGO\")","v":""}]
[null,null,null,{"$f":"IF(F9<>\"\",\"\",IF(F10<>\"\",\"\",IF(D8<>\"\",1,\"\")))","v":""},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":""},{"$f":"+IF(F10<>\"\",\"\",IF(D12=\"\",\"\",D12))","v":""},{"$f":"IF(F9<>\"\",\"\",IF(F10<>\"\",\"\",IF(F10<>\"\",\"\",+D8-F16)))","v":""},{"$f":"IFERROR(IF(F10<>\"\",\"\",+F16+D12),\"\")","v":""},{"$f":"IF(F9<>\"\",\"\",IF(F10<>\"\",\"\",IF(D8<>\"\",D10,\"\")))","v":""}]
[null,null,null,{"$f":"IF(D16<D9,D16+1,\"\")","v":""},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":""},{"$f":"IF(F10<>\"\",\"\",IF(D17<>\"\",H16*$E$11*K17,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D17<>\"\",+H16-F17,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D17<>\"\",F17+G17,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D17<>\"\",EDATE(J16,1),\"\"))","v":""},{"$f":"+J17-J16","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(D17<$D$9,D17+1,\"\")","v":""},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":""},{"$f":"IF(F10<>\"\",\"\",IF(D18<>\"\",H17*$E$11*K18,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D18<>\"\",+H17-F18,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D18<>\"\",F18+G18,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D18<>\"\",EDATE(J17,1),\"\"))","v":""},{"$f":"+J18-J17","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(D18<$D$9,D18+1,\"\")","v":""},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":""},{"$f":"IF(F10<>\"\",\"\",IF(D19<>\"\",H18*$E$11*K19,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D19<>\"\",+H18-F19,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D19<>\"\",F19+G19,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D19<>\"\",EDATE(J18,1),\"\"))","v":""},{"$f":"+J19-J18","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(D19<$D$9,D19+1,\"\")","v":""},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":""},{"$f":"IF(F10<>\"\",\"\",IF(D20<>\"\",H19*$E$11*K20,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D20<>\"\",H19-F20,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D20<>\"\",F20+G20,\"\"))","v":""},{"$f":"IF(F10<>\"\",\"\",IF(D20<>\"\",EDATE(J19,1),\"\"))","v":""},{"$f":"+J20-J19","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(D20<$D$9,D20+1,\"\")","v":""},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":""},{"$f":"IF(F11<>\"\",\"\",IF(D21<>\"\",H20*$E$11*K21,\"\"))","v":""},{"$f":"IF(F11<>\"\",\"\",IF(D21<>\"\",H20-F21,\"\"))","v":""},{"$f":"IF(F11<>\"\",\"\",IF(D21<>\"\",F21+G21,\"\"))","v":""},{"$f":"IF(F11<>\"\",\"\",IF(D21<>\"\",EDATE(J20,1),\"\"))","v":""},{"$f":"+J21-J20","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(D23<$D$9,D23+1,\"\")","v":""}]
[null,null,null,"TOTAL",null,{"$f":"SUM(F16:F21)","v":0},{"$f":"SUM(G16:G21)","v":0},"*Valores aproximados"]
[]
[]
[null,null,null,null,null,null,"SIMULADOR CUOTA VARIABLE"]
[]
[]
[null,null,"Valor Matricula",null,null,{"$f":"+IF(D29=0,\"Por favor digite el valor  matrícula (Sin Recargo Extraordinario)\",\"\")","v":"Por favor digite el valor  matrícula (Sin Recargo Extraordinario)"}]
[null,null,"Valor Deseado 1ra Cuota",null,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",6,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",1.2E-2,{"$f":"+(1.2%*12)/360","v":4.0000000000000007E-4}]
[null,null,"Fecha Vencimiento Factura",null,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":"Por favor seleccione la fecha en la cual desea iniciar su plan de pagos"}]
[null,null,"Valor Matricula Extraordinaria",0]
[]
[null,null,null,{"$f":"IF(D29=\"\",\"\",\"PERIODO\")","v":""},null,{"$f":"IF(D29=\"\",\"\",\"MATRICULA\")","v":""},{"$f":"IF(D29=\"\",\"\",\"INTERES DE FINANCIACIÓN/ EXTRAORDINARIA\")","v":""},{"$f":"IF(D29=\"\",\"\",\"SALDO CAPITAL\")","v":""},{"$f":"IF(D29=\"\",\"\",\"PAGO MENSUAL\")","v":""},{"$f":"IF(D29=\"\",\"\",\"FECHA DE PAGO\")","v":""}]
[null,null,null,{"$f":"IF(F31=\"\",IF(F33<>\"\",\"\",IF(D29<>\"\",1,\"\")),\"\")","v":""},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":""},{"$f":"+IF(F31<>\"\",\"\",IF(D34=\"\",\"\",D34))","v":0},{"$f":"+IFERROR(IF(F31=\"\",IF(F33<>\"\",\"\",D29-F37),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(F37=\"\",D29+G37,F37+G37),\"\")","v":0},{"$f":"IF(F31=\"\",IF(F33<>\"\",\"\",IF(D29<>\"\",D33,\"\")),\"\")","v":""}]
[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":""},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":""},{"$f":"IF(F33<>\"\",\"\",IF(D38<>\"\",H37*E32*K38,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D38<>\"\",+H37-F38,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D38<>\"\",F38+G38,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D38<>\"\",EDATE(J37,1),\"\"))","v":""},{"$f":"+J38-J37","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(D38<$D$31,D38+1,\"\")","v":""},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":""},{"$f":"IF(F33<>\"\",\"\",IF(D39<>\"\",H38*E32*K39,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D39<>\"\",+H38-F39,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D39<>\"\",F39+G39,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D39<>\"\",EDATE(J38,1),\"\"))","v":""},{"$f":"+J39-J38","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(D39<$D$31,D39+1,\"\")","v":""},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":""},{"$f":"IF(F33<>\"\",\"\",IF(D40<>\"\",H39*E32*K40,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D40<>\"\",+H39-F40,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D40<>\"\",F40+G40,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D40<>\"\",EDATE(J39,1),\"\"))","v":""},{"$f":"+J40-J39","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"IF(D40<$D$31,D40+1,\"\")","v":""},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":""},{"$f":"IF(F33<>\"\",\"\",IF(D41<>\"\",H40*E32*K41,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D41<>\"\",H40-F41,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D41<>\"\",F41+G41,\"\"))","v":""},{"$f":"IF(F33<>\"\",\"\",IF(D41<>\"\",EDATE(J40,1),\"\"))","v":""},{"$f":"+J41-J40","v":{"$error":"#VALUE!"}}]
[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":0},{"$f":"SUM(G37:G42)","v":0},"*Valores aproximados"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 cuotas."]