{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["INICIO","TAE","CUOTAS REGULARES","CUOTA PLUS","PR SELECCION","CUOTAS IRREGULARES","CARENCIAS","LEASING","DOBLE TIPO 12.0","DOBLE TIPO 6.0","DEMOS","DOBLE TIPO 4.0","LEASING SELECCION","SEG"],"not_rendered":{"charts":0,"images":29,"macros":0,"external_links":0,"defined_names":8,"comments":1,"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":"row_number_cap","date_system":"1900"}

{"sheet":"INICIO","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Consumer Finance"]
[]
[null,null,null,null,null,"Simuladores de Cálculo"]
[]
[]
[]
[null,null,null,"Préstamo Cuotas Regulares",null,"Leasing"]
[]
[null,null,null,"Préstamo con Cuota Plus"]
[]
[null,null,null,"Préstamo Selección"]
[]
[null,null,null,"Préstamo con Cuotas Irregulares",null,"Doble Tipo 12.0 VN y VSN"]
[]
[null,null,null,"Préstamo con Carencia"]

{"sheet":"TAE","index":1,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":true,"merged":[[14,4,15,7],[4,1,4,4]]}
["volver"]
[]
[]
[null,null,null,null,"Consumer Finance"]
[null,"CALCULADORA T.A.E."]
[]
[null,"Principal"]
[]
[null,"T.I.N. Anual (1)",null,"Plazo"]
[]
[null,"Seguros "]
[]
[null,"Com. Apert.",null,"Com. Estudio"]
[]
[null,"T.A.E",{"$f":"+IF(ISERROR(((1+(D15/12))^12)-1),\"\",((1+(D15/12))^12)-1)","v":""},{"$f":"RATE(E9,PMT(C9/12,E9,-1,0,0),-1+C13+E13,0,0)*12","v":{"$error":"#NUM!"}},{"$f":"+IF(J28=\"X\",\"El Seguro de Siniestro total no se puede contratar para plazos superiores a 84 meses. Para este plazo, por favor seleccione la opción Seguro PPP unicamente\",\"\")","v":""}]
[]
[null,"(1) Condiciones financieras de la Tarifa correspondiente al Colaborador"]
[null," Cálculo válido para Cuotas Regulares"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,1,null,1,null,{"$f":"+IF(AND((H26=2),(E9>84)),\"xx\",\"\")","v":""}]
[null,null,null,null,null,"Financiadas",null,"PPP",null,{"$f":"+IF(AND((H26=3),(E9>84)),\"xx\",\"\")","v":""}]
[null,null,null,null,null,"Al Contado",null,"Siniestro Total",null,{"$f":"+IF(OR((J26=\"xx\"),(J27=\"xx\")),\"X\",\"\")","v":""}]
[null,null,null,null,null,null,null,"PPP+ST"]
[null,null,null,null,null,null,null,"Seg T/X(vida+desempl)"]
[null,null,null,null,null,null,null,"SegT/X + D"]
[null,null,null,null,null,null,null,"Vehic Sust"]
[null,null,null,null,null,null,null,"Vehic sust+D"]
[null,null,null,null,null,null,null,"Sin Seguros"]
[]
[null,null,"Principal",{"$f":"+C7","v":0}]
[null,null,"Seguros",{"$f":"INDEX(I39:I46,H26,1)","v":{"$error":"#N/A"}}]
[null,null,"CAP",{"$f":"+IF(D36=0,\"\",IF(F26=1,(D36+D37)*C13,0))","v":""}]
[null,null,"Financiado",{"$f":"+D36+D37+D38","v":{"$error":"#N/A"}},null,"PPP",{"$f":"INDEX(SEG!$A$3:$E$122,MATCH($E$9,SEG!$A$3:$A$122,1),2)","v":{"$error":"#N/A"}},null,{"$f":"+G39*$D$36","v":{"$error":"#N/A"}}]
[null,null,"Plazo",{"$f":"+IF(E9=\"\",\"\",E9)","v":""},null,"Siniestro Total",{"$f":"INDEX(SEG!$A$3:$E$122,MATCH($E$9,SEG!$A$3:$A$122,1),3)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,"Cuotas",{"$f":"+IF(C7=\"\",\"\",PMT($C$9/12,E9,-D39,0,0))","v":""},null,"PPP+Siniestro Total",{"$f":"+G39+G40","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,"Seg T/X(vida+desempl)",{"$f":"INDEX(SEG!$A$3:$E$122,MATCH($E$9,SEG!$A$3:$A$122,1),5)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,"SegT/X + D",{"$f":"+G42+G40","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,"Vehic Sust",{"$f":"INDEX(SEG!$A$3:$F$122,MATCH($E$9,SEG!$A$3:$A$122,1),6)","v":{"$error":"#N/A"}},null,{"$f":"+G44","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Vehic sust+D",null,null,{"$f":"+I40+I44","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Sin Seguros",0,null,0]

{"sheet":"CUOTAS REGULARES","index":2,"n_rows":272,"n_cols":11,"rows_kept":272,"cut":false,"hidden":false,"merged":[[0,6,0,7],[4,1,4,5],[14,1,14,2]],"read":"row_number_cap"}
["volver"]
[]
[null,null,null,null,null,"Financia"]
[]
[null,"SIMULADOR CUOTAS CONSTANTES v9"]
[]
[null,"Principal"]
[]
[null,"T.I.N. Anual (1)",3.9899999999999998E-2,"Plazo"]
[]
[null,"Seguros (2)",null,null,{"$f":"IF(AND(E9<H22,OR(J29=4,J29=5,J29=8,J29=9,J29=10,J29=11)),\"¡¡¡Seguro tipo Y no contratable por plazo, Cambie de producto!!!\",\"\")","v":""}]
[]
[null,"Com. Apert.",3.5000000000000003E-2,"Com. Estudio"]
[]
[null,{"$f":"IF(C13=\"\",\"\",IF(C44<150,\"Aplica cap mínimo\",\"\"))","v":"Aplica cap mínimo"}]
[null,"Importe Total Financiado",null,{"$f":"+IF(ISERROR(E50),\"\",E50)","v":150}]
[]
[null,"Importe de las Cuotas",null,{"$f":"+E52","v":""},{"$f":"IF(D18<20,\"Cuota mínima 20€\",\"\")","v":""}]
[null,null,"TAE",{"$f":"+D150","v":""}]
[]
[null,"(1) Condiciones financieras de la Tarifa correspondiente al Colaborador"]
[null,"(2) En operaciones a partir de 84 meses el Seguro PPP es obligatorio. Plazo minimo segruo TIPO Y (meses)"]
[null,"(2 bis) El Seguro de SiniEstro Total sólo es contrtable ne operaciones hasta 84 meses"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,1,null,13,{"$f":"IF(OR(I29=4,I29=5,I29=8,I29=9,I29=10,I29=11),I29,0)","v":0},{"$f":"+IF(AND((I29=2),(E9>84)),\"xx\",\"\")","v":""}]
[null,null,null,null,null,null,"Financiadas",null,"PPP (Q)",null,{"$f":"+IF(AND((I29=3),(E9>84)),\"xx\",\"\")","v":""}]
[null,null,null,null,null,null,"Al Contado",null,"SINIESTRO TOTAL (D)",null,{"$f":"+IF(OR((K29=\"xx\"),(K30=\"xx\")),\"X\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,"PLATINO: PPP+Sustitc. + R. Carnet"]
[null,null,null,null,null,null,null,null,"DORADO:Sustitc.+ R.Carnet "]
[null,null,null,null,null,null,null,null,"PPP+ST"]
[null,null,null,null,null,null,null,null,"PPP+ST+Y"]
[null,null,null,null,null,null,null,null,"TITANIO: PPP+ Y"]
[null,null,null,null,null,null,null,null,"DESEMPLEO (T/X)"]
[null,null,null,null,null,null,null,null,"DESEMPLEO (T/X)+ SINIESTRO TOTAL (D)"]
[null,null,null,null,null,null,null,null,"DESEMPLEO (T/X)+ST+Y"]
[null,null,null,null,null,null,null,null,"DESEMPLEO (T/X)+VEHÍCULO DE SUSTITUCIÓN (Y)"]
[null,null,"Min CAP",150,null,null,null,null,"VEHÍCULO DE SUSTITUCIÓN (Y) +SINIESTRO TOTAL (D)"]
[null,null,"Min CEST",{"$f":"+IF($E$13=0,0,30.05)","v":0},null,null,null,null,"SIN SEGUROS"]
[null,null,null,null,null,null,null,null,"VEHÍCULO DE SUSTITUCIÒN (Y)"]
[null,"CAP",{"$f":"C13*C7","v":0},null,null,null,null,null,"RETIRADA DE CARNET (W)"]
[null,null,null,null,null,null,null,null,"EXTENSIÓN DE GARANTÍA VO (7)"]
[null,null,null,"Principal",{"$f":"+C7","v":0},null,null,null,"PPP+RET.CARNET"]
[null,null,null,"Seguros",{"$f":"(INDEX(J73:J92,I29,1))","v":0},null,null,null,"DESEMPLEO + RET.CARNET"]
[null,null,{"$f":"+IF($E$46=0,\"\",IF(G$29=1,($E$46+$E$47)*$C$13,0))","v":""},"CAP",{"$f":"+IF((C13*($E$46+$E$47))<D41,D41,C13*($E$46+$E$47))","v":150},{"$f":"IF(C48<E48,\"Importe minimo cap 150,00 €\",\"\")","v":""},null,null,"PPP-SENIOR (M)"]
[null,null,{"$f":"+IF($E$46=0,\"\",IF(G$29=1,($E$46+$E$47)*$E$13,0))","v":""},"CEST",{"$f":"+IF((C14*($E$46+$E$47))<D42,D42,C14*($E$46+$E$47))","v":0},null,null,null,"PPP-EXTENSIÓN DE GARANTÍA"]
[null,null,{"$f":"IF(E13>0,C49,\"\")","v":""},"Financiado",{"$f":"+IF(G29=1,E46+E47+E48+E49,E46+E47)","v":150}]
[null,null,null,"Plazo",{"$f":"+IF(E9=\"\",\"\",E9)","v":""}]
[null,null,null,"Cuotas",{"$f":"IF(ISERROR(PMT($C$9/12,E51,-E50,0,0)),\"\",PMT($C$9/12,E51,-E50,0,0))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"PPP",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($E$9,SEG!$A$3:$A$122,1),2)","v":{"$error":"#N/A"}},null,{"$f":"+H73*$E$46","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Siniestro Total",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($E$9,SEG!$A$3:$A$122,1),3)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"PLATINO: PPP+Sustitc. + R. Carnet",{"$f":"+H73+H86+H87","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"DORADO: Sustitc. + R.C.",{"$f":"+H86+H87","v":0},null,0]
[null,null,null,null,null,null,"PPP+Siniestro Total",{"$f":"+H73+H74","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"PPP+ST+Y",{"$f":"+H73+H74+H86","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"TITANIO: PPP+Y",{"$f":"+H73+H86","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"Desempleo",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($E$9,SEG!$A$3:$A$122,1),5)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"Desemp+ST",{"$f":"+H80+H74","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"Desempleo+ST+Y",{"$f":"H80+H74+H86","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"Desempleo+Y",{"$f":"H80+H86","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"Vehic Sust+ST",{"$f":"+H86+H74","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"Sin Seguros",0,null,0]
[null,null,null,null,null,null,"Vehic Sustituc (Y)",{"$f":"IF(E9>11,INDEX(SEG!$A$3:$J$122,MATCH($E$9,SEG!$A$3:$A$122,1),6),0)","v":0},null,{"$f":"+H86*E46","v":0}]
[null,null,null,null,null,null,"Retirada Carnet",{"$f":"IF(E9>11,INDEX(SEG!$A$3:$J$122,MATCH($E$9,SEG!$A$3:$A$122,1),7),0)","v":0},null,{"$f":"+H87*E46","v":0}]
[null,null,null,null,null,null,"EG VO",{"$f":"IF(E9>11,INDEX(SEG!$A$3:$J$122,MATCH($E$9,SEG!$A$3:$A$122,1),8),0)","v":0},null,{"$f":"+H88","v":0}]
[null,null,null,null,null,null,"PPP+RETIRADA DE CARNET",{"$f":"+H73+H87","v":{"$error":"#N/A"}},null,{"$f":"+H89*$E$46","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"DESEMPLEO+RET.CARNET",{"$f":"+H80+H87","v":{"$error":"#N/A"}},null,{"$f":"+H90*$E$46","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"PPP-SENIOR (M)",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($E$9,SEG!$A$3:$A$122,1),10)","v":{"$error":"#N/A"}},null,{"$f":"+H91*$E$46","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"PPP-EXTENSIÓN DE GARANTÍA",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($E$9,SEG!$A$3:$A$122,1),2)","v":{"$error":"#N/A"}},null,{"$f":"+H92*$E$46+J88","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TAE",{"$f":"+IF(ISERROR((((1+((IRR($D$152:$D$272,0.0025)*12)/12))^12)-1)),\"\",(((1+((IRR($D$152:$D$272,0.0025)*12)/12))^12)-1))","v":""}]
[null,null,"tir",{"$f":"+IRR($D$152:$D$272,0.0025)*12","v":{"$error":"#NUM!"}}]
[null,null,0,{"$f":"IF(G29=2,-C7-E47+($E$48+$E$49),-C7-E47)","v":0}]
[null,null,1,{"$f":"+IF($E$9>(C153-1),$D$18,0)","v":0}]
[null,null,2,{"$f":"+IF($E$9>(C154-1),$D$18,0)","v":0}]
[null,null,3,0]
[null,null,4,0]
[null,null,5,0]
[null,null,6,0]
[null,null,7,0]
[null,null,8,0]
[null,null,9,0]
[null,null,10,0]
[null,null,11,0]
[null,null,12,0]
[null,null,13,0]
[null,null,14,0]
[null,null,15,0]
[null,null,16,0]
[null,null,17,0]
[null,null,18,0]
[null,null,19,0]
[null,null,20,0]
[null,null,21,0]
[null,null,22,0]
[null,null,23,0]
[null,null,24,0]
[null,null,25,0]
[null,null,26,0]
[null,null,27,0]
[null,null,28,0]
[null,null,29,0]
[null,null,30,0]
[null,null,31,0]
[null,null,32,0]
[null,null,33,0]
[null,null,34,0]
[null,null,35,0]
[null,null,36,0]
[null,null,37,0]
[null,null,38,0]
[null,null,39,0]
[null,null,40,0]
[null,null,41,0]
[null,null,42,0]
[null,null,43,0]
[null,null,44,0]
[null,null,45,0]
[null,null,46,0]
[null,null,47,0]
[null,null,48,0]
[null,null,49,0]
[null,null,50,0]
[null,null,51,0]
[null,null,52,0]
[null,null,53,0]
[null,null,54,0]
[null,null,55,0]
[null,null,56,0]
[null,null,57,0]
[null,null,58,0]
[null,null,59,0]
[null,null,60,0]
[null,null,61,0]
[null,null,62,0]
[null,null,63,0]
[null,null,64,0]
[null,null,65,0]
[null,null,66,{"$f":"+IF($E$9>(C218-1),$D$18,0)","v":0}]
[null,null,67,0]
[null,null,68,0]
[null,null,69,0]
[null,null,70,0]
[null,null,71,0]
[null,null,72,0]
[null,null,73,0]
[null,null,74,0]
[null,null,75,0]
[null,null,76,0]
[null,null,77,0]
[null,null,78,0]
[null,null,79,0]
[null,null,80,0]
[null,null,81,0]
[null,null,82,0]
[null,null,83,0]
[null,null,84,0]
[null,null,85,0]
[null,null,86,0]
[null,null,87,0]
[null,null,88,0]
[null,null,89,0]
[null,null,90,0]
[null,null,91,0]
[null,null,92,0]
[null,null,93,0]
[null,null,94,0]
[null,null,95,0]
[null,null,96,0]
[null,null,97,0]
[null,null,98,0]
[null,null,99,0]
[null,null,100,0]
[null,null,101,0]
[null,null,102,0]
[null,null,103,0]
[null,null,104,0]
[null,null,105,0]
[null,null,106,0]
[null,null,107,0]
[null,null,108,0]
[null,null,109,0]
[null,null,110,0]
[null,null,111,0]
[null,null,112,0]
[null,null,113,0]
[null,null,114,0]
[null,null,115,0]
[null,null,116,0]
[null,null,117,0]
[null,null,118,0]
[null,null,119,0]
[null,null,120,0]

{"sheet":"CUOTA PLUS","index":3,"n_rows":216,"n_cols":12,"rows_kept":216,"cut":false,"hidden":false,"merged":[[0,5,0,6],[3,1,3,5]],"read":"row_number_cap"}
[null,"volver"]
[null,null,null,null,null,"Consumer Finance"]
[]
[null,"SIMULADOR CÁLCULO CUOTA PLUS"]
[]
[]
[]
[null,{"$f":"+IF(J62=2,\"P.V.P. Vehículo\",\"\")","v":""}]
[]
[null,"Principal"]
[]
[null,"T.I.N. Anual ",null,null,"Plazo"]
[]
[null,"Seguro "]
[]
[null,"Com. Apert.",null,"Com. Estudio"]
[null,null,{"$f":"IF(C16=\"\",\"\",IF(B48<150,\"Aplica cap mínimo\",\"\"))","v":""}]
[null,"Importe Total Financiado",null,{"$f":"+D50","v":150}]
[]
[null,{"$f":"+\"Cuotas de las 1 a la \"&D51-1","v":"Cuotas de las 1 a la 59"},null,{"$f":"+D54","v":""},{"$f":"+IF((((C12/12)*D50)*1.05)>D20,\"OPERACIÓN INVIABLE: Eleve el Principal o varíe el Plazo\",\"\")","v":""}]
[]
[null,{"$f":"+\"Cuota nº \"&D51","v":"Cuota nº 60"},null,{"$f":"+E52","v":52.5}]
[null,null,"TAE",{"$f":"+C94","v":-0.99999662077949192}]
[null,null,null,null,null,null,null,1,{"$f":"IF(OR(H24=4,H24=5,H24=8,H24=9,H24=10,H24=11),H24,0)","v":0}]
[null,null,null,null,null,null,null,"PPP"]
[null,null,null,null,null,null,null,"Siniestro Total"]
[null,null,null,null,null,null,null,"PLATINO: PPP+Sustitc. + R. Carnet"]
[null,null,null,null,null,null,null,"DORADO:Sustitc.+ R.Carnet "]
[null,null,null,null,null,null,null,"PPP+ST"]
[null,null,null,null,null,null,null,"PPP+ST+Y"]
[null,null,null,null,null,null,null,"TITANIO: PPP+ Y"]
[null,null,null,null,null,null,null,"Desempleo (T/X)"]
[null,null,null,null,null,null,null,"Desempleo+ST"]
[null,null,null,null,null,null,null,"Desempleo+ST+Y"]
[null,null,null,null,null,null,null,"Desempleo+Y"]
[null,null,3,null,null,1,null,"Vehic Sustituc+ST"]
[null,null,36,0.45,null,"Financiadas",null,"Sin Seguros"]
[null,null,48,0.4,null,"Al Contado",null,"Vehic Sustituc (Y)"]
[null,null,60,0.35,null,null,null,"Retirada Carnet"]
[null,null,null,null,null,null,null,"EG VO"]
[null,null,null,null,null,null,null,"JADE VO (PPP+EG VO)"]
[null,null,null,null,null,null,null,"Desempleo + PPP + EG VO"]
[null,"Min CAP",150,null,null,null,null,"PPP-SENIOR(M)"]
[null,"Min CEST",30.05]
[]
[null,null,"Principal",{"$f":"+C10","v":0}]
[null,null,"Seguro",{"$f":"INDEX(L62:L80,H24,1)","v":0}]
[null,{"$f":"(D46+D47)*(C16)","v":0},"CAP",{"$f":"+IF(SUM($D$46:$D$47)*($C$16)<$C$43,$C$43,SUM($D$46:$D$47)*($C$16))","v":150}]
[null,{"$f":"+(D46+D47)*(E16)","v":0},"CEST",{"$f":"+IF($E$16=0,0,IF(SUM($D$46:$D$47)*($E$16)<$C$44,$C$44,SUM($D$46:$D$47)*($E$16)))","v":0}]
[null,{"$f":"IF(E16>0,B49,\"\")","v":""},"Financiado",{"$f":"+IF(F36=1,SUM(D46:D49),SUM(D46:D47))","v":150}]
[null,null,"Plazo",{"$f":"INDEX(C37:C39,C36,1)","v":60}]
[null,null,"Cuota Plus",{"$f":"INDEX(D37:D39,C36,1)","v":0.35},{"$f":"+IF(D50=0,\"\",D52*D18)","v":52.5}]
[null,null,{"$f":"+\"RV \"&D51-1","v":"RV 59"},{"$f":"-ROUND(PV(C12/12,1,E52,0,0),2)","v":52.5}]
[null,null,"Resto Cuotas",{"$f":"IF(D46=0,\"\",PMT(C12/12,D51-1,-D50,D53,0))","v":""}]
[]
[]
[]
[]
[null,null,null,null,"30/04/2013"]
[]
[]
[null,null,null,null,null,null,null,"PPP",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($D$51,SEG!$A$3:$A$122,1),2)","v":5.3197399999999999E-2},1,null,{"$f":"+I62*$D$46","v":0}]
[null,null,null,null,null,null,null,"Siniestro Total",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($D$51,SEG!$A$3:$A$122,1),3)","v":5.3407000000000003E-2},null,null,0]
[null,null,null,null,null,null,null,"PLATINO: PPP+Sustitc. + R. Carnet",{"$f":"+I62+I75+I76","v":8.9342399999999975E-2},null,null,0]
[null,null,null,null,null,null,null,"DORADO: Sustitc. + R.C.",{"$f":"I75+I76","v":3.6144999999999983E-2},null,null,0]
[null,null,null,null,null,null,null,"PPP+Siniestro Total",{"$f":"+I62+I63","v":0.1066044},null,null,0]
[null,null,null,null,null,null,null,"PPP+ST+Y",{"$f":"+I62+I63+I75","v":0.12544439999999998},null,null,0]
[null,null,null,null,null,null,null,"TITANIO: PPP+Y",{"$f":"I62+I75","v":7.2037399999999974E-2},null,null,0]
[null,null,null,null,null,null,null,"Desempleo",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($D$51,SEG!$A$3:$A$122,1),5)","v":8.8791079999999994E-2},null,null,0]
[null,null,null,null,null,null,null,"Desemp+ST",{"$f":"I69+I63","v":0.14219808},null,null,0]
[null,null,null,null,null,null,null,"Desempleo+ST+Y",{"$f":"I69+I63+I75","v":0.16103807999999997},null,null,0]
[null,null,null,null,null,null,null,"Desempleo+Y",{"$f":"I75+I69","v":0.10763107999999998},null,null,0]
[null,null,null,null,null,null,null,"Vehic Sust+ST",{"$f":"I75+I63","v":7.2246999999999978E-2},null,null,0]
[null,null,null,null,null,null,null,"Sin Seguros",null,null,null,0]
[null,null,null,null,null,null,null,"Vehic Sustituc (Y)",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($D$51,SEG!$A$3:$A$122,1),6)","v":1.8839999999999982E-2},null,null,{"$f":"+I75*$D$46","v":0}]
[null,null,null,null,null,null,null,"Retirada Carnet",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($D$51,SEG!$A$3:$A$122,1),7)","v":1.7305000000000001E-2},null,null,{"$f":"+I76*$D$46","v":0}]
[null,null,null,null,null,null,null,"EG VO",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($D$51,SEG!$A$3:$A$122,1),8)","v":257.51},null,null,{"$f":"+I77","v":257.51}]
[null,null,null,null,null,null,null,"JADE VO (PPP+EG VO)",{"$f":"I62","v":5.3197399999999999E-2},null,null,{"$f":"(+I78*$D$46)+L77","v":257.51}]
[null,null,null,null,null,null,null,"Desempleo + PPP + EG VO",{"$f":"I69","v":8.8791079999999994E-2},null,null,{"$f":"(+I79*$D$46)+L77","v":257.51}]
[null,null,null,null,null,null,null,"PPP-SENIOR(M)",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($D$51,SEG!$A$3:$A$122,1),10)","v":0.1249397},null,null,{"$f":"+I80*$D$46","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TAE",{"$f":"+IF(ISERROR((((1+((IRR($C$96:$C$216,0.0025)*12)/12))^12)-1)),\"\",(((1+((IRR($C$96:$C$2161,0.0025)*12)/12))^12)-1))","v":-0.99999662077949192}]
[null,"tir",{"$f":"+IRR($C$96:$C$2161,0.0025)*12","v":-7.8000000000000016}]
[null,0,{"$f":"+IF(F36=1,-D18,-D18+D48+D49)","v":-150}]
[null,1,{"$f":"+IF($D$51>B97,$D$54,IF($D$51=B97,$E$52,0))","v":""}]
[null,2,{"$f":"+IF($D$51>B98,$D$54,IF($D$51=B98,$E$52,0))","v":""}]
[null,3,""]
[null,4,""]
[null,5,""]
[null,6,""]
[null,7,""]
[null,8,""]
[null,9,""]
[null,10,""]
[null,11,""]
[null,12,""]
[null,13,""]
[null,14,""]
[null,15,""]
[null,16,""]
[null,17,""]
[null,18,""]
[null,19,""]
[null,20,""]
[null,21,""]
[null,22,""]
[null,23,""]
[null,24,""]
[null,25,""]
[null,26,""]
[null,27,""]
[null,28,""]
[null,29,""]
[null,30,""]
[null,31,""]
[null,32,""]
[null,33,""]
[null,34,""]
[null,35,""]
[null,36,""]
[null,37,""]
[null,38,""]
[null,39,""]
[null,40,""]
[null,41,""]
[null,42,""]
[null,43,""]
[null,44,""]
[null,45,""]
[null,46,""]
[null,47,""]
[null,48,""]
[null,49,""]
[null,50,""]
[null,51,""]
[null,52,""]
[null,53,""]
[null,54,""]
[null,55,""]
[null,56,""]
[null,57,""]
[null,58,""]
[null,59,""]
[null,60,52.5]
[null,61,0]
[null,62,0]
[null,63,0]
[null,64,0]
[null,65,0]
[null,66,{"$f":"+IF($D$51>B162,$D$54,IF($D$51=B162,$E$52,0))","v":0}]
[null,67,0]
[null,68,0]
[null,69,0]
[null,70,0]
[null,71,0]
[null,72,0]
[null,73,0]
[null,74,0]
[null,75,0]
[null,76,0]
[null,77,0]
[null,78,0]
[null,79,0]
[null,80,0]
[null,81,0]
[null,82,0]
[null,83,0]
[null,84,0]
[null,85,0]
[null,86,0]
[null,87,0]
[null,88,0]
[null,89,0]
[null,90,0]
[null,91,0]
[null,92,0]
[null,93,0]
[null,94,0]
[null,95,0]
[null,96,0]
[null,97,0]
[null,98,0]
[null,99,0]
[null,100,0]
[null,101,0]
[null,102,0]
[null,103,0]
[null,104,0]
[null,105,0]
[null,106,0]
[null,107,0]
[null,108,0]
[null,109,0]
[null,110,0]
[null,111,0]
[null,112,0]
[null,113,0]
[null,114,0]
[null,115,0]
[null,116,0]
[null,117,0]
[null,118,0]
[null,119,0]
[null,120,0]

{"sheet":"PR SELECCION","index":4,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,6,0,7],[2,2,2,7]]}
[null,null,"volver",null,null,null,"BBVA Finanzia"]
[]
[null,null,"SIMULADOR PRESTAMO SELECCIÓN"]
[]
[null,null,"Principal"]
[]
[null,null,"T.I.N. Anual ",null,"Plazo Total"]
[]
[null,null,"Seguro (1)"]
[]
[null,null,"Com. Apert.",2.75E-2,"Com. Estudio",0]
[]
[null,null,"Importe Total Financiado",null,{"$f":"+IF(ISERROR(E41),\"\",E41)","v":0}]
[]
[null,null,"VR Intermedio",null,"Momento"]
[]
[null,{"$f":"+IF(F7=\"\",\"\",E44)","v":""},"Cuotas Mensuales",null,{"$f":"IF(ISERROR(+E45),\"\",E45)","v":""}]
[]
[null,{"$f":"+IF(F7=\"\",\"\",F7-B17)","v":""},{"$f":"+C17","v":"Cuotas Mensuales"},null,{"$f":"+IF(ISERROR(E46),\"\",E46)","v":""}]
[]
[null,null,"(1) En operaciones a partir de 72 meses el Seguro PPP es obligatorio."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,1,null,3,{"$f":"INDEX(J33:J36,I32,1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Financiadas",null,"PPP",{"$f":"INDEX(SEG!$A$3:$D$122,MATCH($F$7,SEG!$A$3:$A$122,1),2)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Al Contado",null,"Siniestro total",{"$f":"INDEX(SEG!$A$3:$D$122,MATCH($F$7,SEG!$A$3:$A$122,1),3)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"PPP + ST",{"$f":"INDEX(SEG!$A$3:$D$122,MATCH($F$7,SEG!$A$3:$A$122,1),4)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,"Sin Seguros",0]
[]
[null,null,null,"Principal",{"$f":"+D5","v":0},null,1,{"$f":"INDEX(H40:H46,G38,1)","v":0}]
[null,null,null,"Seguro",{"$f":"+IF(E38=0,\"\",J32*D5)","v":""},null,"Momentos Inter.","% Inter"]
[null,null,null,"CAP",{"$f":"+IF(E38=0,\"\",IF(G32=1,(E38+E39)*(D11+F11),0))","v":""}]
[null,null,null,"Financiado",{"$f":"+ROUND(SUM(E38:E40),2)","v":0},null,12,0.6]
[null,null,null,"Plazo",{"$f":"+IF(F7=\"\",\"\",F7)","v":""},null,24,0.55000000000000004]
[null,null,null,"vr Intermedio",{"$f":"+D15","v":0},null,36,0.5]
[null,null,null,"Plazo Interm",{"$f":"INDEX(G40:G46,G38,1)","v":0},null,48,0.45]
[null,null,null,"Cuotas Inic",{"$f":"PMT(D7/12,E44,-E41,E43,0)","v":{"$error":"#NUM!"}},null,60,0.4]
[null,null,null,"Cuotas Post",{"$f":"PMT(D7/12,B19,-D15,0,0)","v":{"$error":"#VALUE!"}},null,72,0.35]

{"sheet":"CUOTAS IRREGULARES","index":5,"n_rows":218,"n_cols":11,"rows_kept":218,"cut":false,"hidden":false,"merged":[[0,5,0,6],[4,1,4,6]]}
[1,"volver"]
[]
[null,null,null,null,null,null,"Consumer Finance"]
[]
[null,"SIMULADOR CUOTAS IRREGULARES v9"]
[]
[null,"Principal"]
[]
[null,"T.I.N. Anual (1)",null,null,"Plazo"]
[]
[null,"Seguro (2)",null,null,{"$f":"IF(AND(F9<I27,OR(I31=6,I31=7)),\"¡¡¡Seguro tipo Y no contratable por plazo, Cambie de producto!!!\",\"\")","v":""}]
[]
[null,"Com. Apert.",null,"Com. Estudio"]
[]
[null,"Importe Total Financiado",null,{"$f":"+IF(ISERROR(D88),\"\",D88)","v":""}]
[]
[null,"Nº de Cuotas Irregulares (3)",null,null,"Importe Cuotas Iniciales (3)"]
[]
[null,"Cuotas Iniciales Mínimas",null,{"$f":"+IF(ISERROR(ROUND(IF(D15=\"\",\"\",(D15*C9/12)+E19),0)),\"\",ROUND(IF(D15=\"\",\"\",(D15*C9/12)+E19),0))","v":""},{"$f":"IF(C9=\"\",\"\",(PPMT(C9/12,1,F9,-D15,0))*25%)","v":""}]
[]
[null,{"$f":"+IF(F9=\"\",\"Cuotas de la 1 a la X\",\"Cuotas de las 1 a la \"&D90)","v":"Cuotas de la 1 a la X"},null,{"$f":"+G17","v":0},{"$f":"+IF(G17<D19,\"La Cuota no cubre el mínimo exigido, revisela\",\"\")","v":""}]
[]
[null,{"$f":"+IF(D17=\"\",\"Cuotas de la X a la Y\",\"Cuotas de la \"&D90+1&\" a la \"&D89)","v":"Cuotas de la X a la Y"},null,{"$f":"+E93","v":""}]
[null,null,"TAE",{"$f":"+C96","v":""}]
[]
[null,"(1) Condiciones financieras de la Tarifa correspondiente al Colaborador"]
[null,"(2) En operaciones a partir de 84 meses el Seguro PPP es recomendado. "]
[null,"(3) Sujeto a autorización previa por parte de la Entidad a través de Campañas."]
[]
[null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,"PPP"]
[null,null,null,null,null,null,null,"Siniestro Total"]
[null,null,null,null,null,null,null,"PLATINO: PPP+Sustitc. + R. Carnet"]
[null,null,null,null,null,null,null,"DORADO:Sustitc.+ R.Carnet "]
[null,null,null,null,null,null,null,"PPP+ST"]
[null,null,null,null,null,null,null,"PPP+ST+Y"]
[null,null,null,null,null,null,null,"TITANIO: PPP+ Y"]
[null,null,null,null,null,null,null,"Desempleo (T/X)"]
[null,null,null,null,null,null,null,"Desempleo+ST"]
[null,null,null,null,null,null,null,"Desempleo+ST+Y"]
[null,null,null,null,null,null,null,"Desempleo+Y"]
[null,null,null,null,null,null,null,"Vehic Sustituc+ST"]
[null,null,null,null,null,null,null,"Sin Seguros"]
[null,null,null,null,null,null,null,"Vehic Sustituc (Y)"]
[null,null,null,null,null,null,null,"Retirada Carnet"]
[null,null,null,null,null,null,null,"EG VO"]
[null,null,null,null,null,null,null,"JADE VO (PPP+ EG VO)"]
[null,null,null,null,null,null,null,"Desempleo + EG VO"]
[null,null,null,null,null,null,null,"PPP-SENIOR (M)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,1,{"$f":"IF(OR(H73=4,H73=5,H73=8,H73=9,H73=10,H73=11),H73,0)","v":0},{"$f":"+IF(AND((H73=2),(D55>84)),\"xx\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"+IF(AND((H73=3),(D55>84)),\"xx\",\"\")","v":""}]
[null,null,null,null,null,1,null,"PPP",{"$f":"INDEX(SEG!$A$3:$E$122,MATCH($F$9,SEG!$A$3:$A$122,1),2)","v":{"$error":"#N/A"}},null,{"$f":"+I75*$D$84","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Financiadas",null,"Siniestro Total",{"$f":"INDEX(SEG!$A$3:$E$122,MATCH($F$9,SEG!$A$3:$A$122,1),3)","v":{"$error":"#N/A"}},null,{"$f":"+I76*$D$84","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Al Contado",null,"PLATINO: PPP+Sustitc. + R. Carnet",{"$f":"+I75+I88+I89","v":{"$error":"#N/A"}},null,{"$f":"+I77*$D$84","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"DORADO: Sustitc. + R.C.",{"$f":"+I88+I89","v":0},null,{"$f":"+I78*$D$84","v":0}]
[null,null,null,null,null,"Imprte Seguro",{"$f":"INDEX(SEG!A3:C122,MATCH(F9,SEG!A3:A122,1),3)","v":{"$error":"#N/A"}},"PPP+Siniestro Total",{"$f":"+I75+I76","v":{"$error":"#N/A"}},null,{"$f":"+K75+K76","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"PPP+ST+Y",null,null,{"$f":"+K79+K88","v":{"$error":"#N/A"}}]
[null,"Min CAP",150,null,null,null,null,"TITANIO: PPP+Y",null,null,{"$f":"+K75+K88","v":{"$error":"#N/A"}}]
[null,"Min CEST",30.05,null,null,null,null,"Desempleo",{"$f":"INDEX(SEG!$A$3:$E$122,MATCH($F$9,SEG!$A$3:$A$122,1),5)","v":{"$error":"#N/A"}},null,{"$f":"+D84*I82","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Desemp+ST",{"$f":"+I82+I76","v":{"$error":"#N/A"}},null,{"$f":"+K76+K82","v":{"$error":"#N/A"}}]
[null,null,"Principal",{"$f":"+C7","v":0},null,null,null,"Desempleo+ST+Y",null,null,{"$f":"+K83+K88","v":{"$error":"#N/A"}}]
[null,null,"Seguro",{"$f":"(INDEX(K75:K93,H30,1))","v":{"$error":"#N/A"}},null,null,null,"Desempleo+Y",null,null,{"$f":"+K82+K88","v":{"$error":"#N/A"}}]
[null,{"$f":"+IF(D84=\"\",0,IF(F75=1,(D84+D85)*(C13),0))","v":{"$error":"#N/A"}},"CAP",{"$f":"+IF(((D84+D85)*C13)<$C$81,$C$81,(D84+D85)*C13)","v":{"$error":"#N/A"}},null,null,null,"Vehic Sust+ST",null,null,{"$f":"+K88+K76","v":{"$error":"#N/A"}}]
[null,{"$f":"+IF(D84=\"\",0,IF(F75=1,(D84+D85)*(E13),0))","v":{"$error":"#N/A"}},"CEST",{"$f":"+IF(E13=0,0,IF(((D85+D86)*$E$13)<$C$82,$C$82,(D85+D86)*$E$13))","v":0},null,null,null,"Sin Seguros",0,null,0]
[null,null,"Financiado",{"$f":"+IF(F75=1,SUM(D84:D87),SUM(D84:D85))","v":{"$error":"#N/A"}},null,null,null,"Vehic Sustituc (Y)",{"$f":"IF(F9>23,INDEX(SEG!$A$3:$I$122,MATCH($F$9,SEG!$A$3:$A$122,1),6),0)","v":0},null,{"$f":"+I88*$D$84","v":0}]
[null,null,"Plazo",{"$f":"+IF(F9=\"\",\"\",F9)","v":""},null,null,null,"Retirada Carnet",{"$f":"IF(F9>23,INDEX(SEG!$A$3:$G$122,MATCH($F$9,SEG!$A$3:$A$122,1),7),0)","v":0},null,{"$f":"+I89*$D$84","v":0}]
[null,null,"Nº Cuotas Irreg.",{"$f":"+IF(D17=\"\",\"\",D17)","v":""},null,null,null,"EG VO",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($F$9,SEG!$A$3:$A$122,1),8)","v":{"$error":"#N/A"}},null,{"$f":"+I90","v":{"$error":"#N/A"}}]
[null,null,"Resto de Cuotas",{"$f":"+IF((D89-D90)=\"\",\"\",D89-D90)","v":{"$error":"#VALUE!"}},null,null,null,"JADE VO (PPP+ EG VO)",{"$f":"I75","v":{"$error":"#N/A"}},null,{"$f":"(+I91*$D$84)+K90","v":{"$error":"#N/A"}}]
[null,null,{"$f":"+\"RV \"&D90","v":"RV "},{"$f":"FV($C$9/12,D90,G17,-D15,0)","v":{"$error":"#VALUE!"}},null,null,null,"Desempleo + EG VO",{"$f":"I82","v":{"$error":"#N/A"}},null,{"$f":"(+I92*$D$84)+K90","v":{"$error":"#N/A"}}]
[null,null,"Importe Resto Cuotas",null,{"$f":"IF(D17=\"\",\"\",PMT(C9/12,D91,-D92,0,0))","v":""},null,null,"PPP-SENIOR (M)",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($F$9,SEG!$A$3:$A$122,1),10)","v":{"$error":"#N/A"}},null,{"$f":"+I93*$D$84","v":{"$error":"#N/A"}}]
[]
[]
[null,"TAE",{"$f":"+IF(ISERROR(((1+(C97/12))^12)-1),\"\",((1+(C97/12))^12)-1)","v":""}]
[null,"TIR",{"$f":"+IRR(C98:C210,0.0025)*12","v":{"$error":"#VALUE!"}}]
[null,0,{"$f":"+IF(F75=1,-D88,-D88+D86+D87)","v":{"$error":"#N/A"}}]
[null,1,{"$f":"+IF(B99<($D$90+1),$D$21,IF(B99<($D$89+1),$E$93,0))","v":{"$error":"#VALUE!"}}]
[null,2,{"$error":"#VALUE!"}]
[null,3,{"$error":"#VALUE!"}]
[null,4,{"$error":"#VALUE!"}]
[null,5,{"$error":"#VALUE!"}]
[null,6,{"$error":"#VALUE!"}]
[null,7,{"$error":"#VALUE!"}]
[null,8,{"$error":"#VALUE!"}]
[null,9,{"$error":"#VALUE!"}]
[null,10,{"$error":"#VALUE!"}]
[null,11,{"$error":"#VALUE!"}]
[null,12,{"$error":"#VALUE!"}]
[null,13,{"$error":"#VALUE!"}]
[null,14,{"$error":"#VALUE!"}]
[null,15,{"$error":"#VALUE!"}]
[null,16,{"$error":"#VALUE!"}]
[null,17,{"$error":"#VALUE!"}]
[null,18,{"$error":"#VALUE!"}]
[null,19,{"$error":"#VALUE!"}]
[null,20,{"$error":"#VALUE!"}]
[null,21,{"$error":"#VALUE!"}]
[null,22,{"$error":"#VALUE!"}]
[null,23,{"$error":"#VALUE!"}]
[null,24,{"$error":"#VALUE!"}]
[null,25,{"$error":"#VALUE!"}]
[null,26,{"$error":"#VALUE!"}]
[null,27,{"$error":"#VALUE!"}]
[null,28,{"$error":"#VALUE!"}]
[null,29,{"$error":"#VALUE!"}]
[null,30,{"$error":"#VALUE!"}]
[null,31,{"$error":"#VALUE!"}]
[null,32,{"$error":"#VALUE!"}]
[null,33,{"$f":"+IF(B131<($D$90+1),$D$21,IF(B131<($D$89+1),$E$93,0))","v":{"$error":"#VALUE!"}}]
[null,34,{"$error":"#VALUE!"}]
[null,35,{"$error":"#VALUE!"}]
[null,36,{"$error":"#VALUE!"}]
[null,37,{"$error":"#VALUE!"}]
[null,38,{"$error":"#VALUE!"}]
[null,39,{"$error":"#VALUE!"}]
[null,40,{"$error":"#VALUE!"}]
[null,41,{"$error":"#VALUE!"}]
[null,42,{"$error":"#VALUE!"}]
[null,43,{"$error":"#VALUE!"}]
[null,44,{"$error":"#VALUE!"}]
[null,45,{"$error":"#VALUE!"}]
[null,46,{"$error":"#VALUE!"}]
[null,47,{"$error":"#VALUE!"}]
[null,48,{"$error":"#VALUE!"}]
[null,49,{"$error":"#VALUE!"}]
[null,50,{"$error":"#VALUE!"}]
[null,51,{"$error":"#VALUE!"}]
[null,52,{"$error":"#VALUE!"}]
[null,53,{"$error":"#VALUE!"}]
[null,54,{"$error":"#VALUE!"}]
[null,55,{"$error":"#VALUE!"}]
[null,56,{"$error":"#VALUE!"}]
[null,57,{"$error":"#VALUE!"}]
[null,58,{"$error":"#VALUE!"}]
[null,59,{"$error":"#VALUE!"}]
[null,60,{"$error":"#VALUE!"}]
[null,61,{"$error":"#VALUE!"}]
[null,62,{"$error":"#VALUE!"}]
[null,63,{"$error":"#VALUE!"}]
[null,64,{"$error":"#VALUE!"}]
[null,65,{"$f":"+IF(B163<($D$90+1),$D$21,IF(B163<($D$89+1),$E$93,0))","v":{"$error":"#VALUE!"}}]
[null,66,{"$error":"#VALUE!"}]
[null,67,{"$error":"#VALUE!"}]
[null,68,{"$error":"#VALUE!"}]
[null,69,{"$error":"#VALUE!"}]
[null,70,{"$error":"#VALUE!"}]
[null,71,{"$error":"#VALUE!"}]
[null,72,{"$error":"#VALUE!"}]
[null,73,{"$error":"#VALUE!"}]
[null,74,{"$error":"#VALUE!"}]
[null,75,{"$error":"#VALUE!"}]
[null,76,{"$error":"#VALUE!"}]
[null,77,{"$error":"#VALUE!"}]
[null,78,{"$error":"#VALUE!"}]
[null,79,{"$error":"#VALUE!"}]
[null,80,{"$error":"#VALUE!"}]
[null,81,{"$error":"#VALUE!"}]
[null,82,{"$error":"#VALUE!"}]
[null,83,{"$error":"#VALUE!"}]
[null,84,{"$error":"#VALUE!"}]
[null,85,{"$error":"#VALUE!"}]
[null,86,{"$error":"#VALUE!"}]
[null,87,{"$error":"#VALUE!"}]
[null,88,{"$error":"#VALUE!"}]
[null,89,{"$error":"#VALUE!"}]
[null,90,{"$error":"#VALUE!"}]
[null,91,{"$error":"#VALUE!"}]
[null,92,{"$error":"#VALUE!"}]
[null,93,{"$error":"#VALUE!"}]
[null,94,{"$error":"#VALUE!"}]
[null,95,{"$error":"#VALUE!"}]
[null,96,{"$error":"#VALUE!"}]
[null,97,{"$f":"+IF(B195<($D$90+1),$D$21,IF(B195<($D$89+1),$E$93,0))","v":{"$error":"#VALUE!"}}]
[null,98,{"$error":"#VALUE!"}]
[null,99,{"$error":"#VALUE!"}]
[null,100,{"$error":"#VALUE!"}]
[null,101,{"$error":"#VALUE!"}]
[null,102,{"$error":"#VALUE!"}]
[null,103,{"$error":"#VALUE!"}]
[null,104,{"$error":"#VALUE!"}]
[null,105,{"$error":"#VALUE!"}]
[null,106,{"$error":"#VALUE!"}]
[null,107,{"$error":"#VALUE!"}]
[null,108,{"$error":"#VALUE!"}]
[null,109,{"$error":"#VALUE!"}]
[null,110,{"$error":"#VALUE!"}]
[null,111,{"$error":"#VALUE!"}]
[null,112,{"$error":"#VALUE!"}]
[null,113,{"$error":"#VALUE!"}]
[null,114,{"$error":"#VALUE!"}]
[null,115,{"$error":"#VALUE!"}]
[null,116,{"$error":"#VALUE!"}]
[null,117,{"$error":"#VALUE!"}]
[null,118,{"$error":"#VALUE!"}]
[null,119,{"$error":"#VALUE!"}]
[null,120,{"$error":"#VALUE!"}]

{"sheet":"CARENCIAS","index":6,"n_rows":222,"n_cols":10,"rows_kept":222,"cut":false,"hidden":false,"merged":[[0,5,0,6],[4,1,4,6]]}
[null,"volver"]
[]
[null,null,null,null,null,null,"Consumer Finance"]
[]
[null,"SIMULADOR CUOTAS CON CARENCIAS v9 "]
[]
[null,"Principal"]
[]
[null,"T.I.N. Anual (1)",null,null,"Plazo (2)"]
[]
[null,"Seguros (4)",null,{"$f":"IF(AND(F9<E27,OR(I31=6,I31=7)),\"¡¡¡Seguro tipo Y no contratable por plazo, Cambie de producto!!!\",\"\")","v":""}]
[]
[null,"Com. Apert.",null,"Com. Estudio"]
[]
[null,"Importe Total Financiado",null,{"$f":"+IF(ISERROR(D89),\"\",D89)","v":""}]
[]
[null,"Nº de Cuotas en Carencia (3)"]
[]
[null,{"$f":"+IF(F9=\"\",\"Cuotas de la 1 a la X\",\"Cuotas de las 1 a la \"&D91)","v":"Cuotas de la 1 a la X"},null,0]
[]
[null,{"$f":"+IF(D17=\"\",\"\",IF(F9=\"\",\"Cuotas de la X a la Y\",\"Cuotas de la \"&D91+1&\" a la \"&D90))","v":""},null,{"$f":"+E94","v":{"$error":"#VALUE!"}}]
[null,null,"TAE",{"$f":"+C100","v":""}]
[]
[null,"(1) Condiciones financieras de la Tarifa correspondiente al Colaborador"]
[null,"(2) Plazo total de la operación, incluída la carencia"]
[null,"(3) Sujeto a autorización previa por parte de la Entidad."]
[null,"(4) Plazo minimo del seguro tipo \"Y\" (meses)"]
[]
[]
[]
[null,null,null,null,null,null,null,1,{"$f":"IF(OR(H31=6,H31=7),H31,0)","v":0}]
[]
[null,null,null,null,null,null,null,"PPP"]
[null,null,null,null,null,null,null,"Siniestro Total"]
[null,null,null,null,null,null,null,"PLATINO:PPP+Sust.+R.C."]
[null,null,null,null,null,null,null,"DORADO: Sustit.+ R.C"]
[null,null,null,null,null,null,null,"PPP+ Siniestro Total"]
[null,null,null,null,null,null,null,"PPP+ Siniestro Total+Y"]
[null,null,null,null,null,null,null,"Desempleo"]
[null,null,null,null,null,null,null,"Desempleo+ ST"]
[null,null,null,null,null,null,null,"Desempleo+ ST+ Y"]
[null,null,null,null,null,null,null,"Desempleo+ Y"]
[null,null,null,null,null,null,null,"Vehic. Sustic.+ ST"]
[null,null,null,null,null,null,null,"Sin Seguros"]
[null,null,null,null,null,null,null,"Vehic. Sustituc.(Y)"]
[null,null,null,null,null,null,null,"Retirada Carnet"]
[null,null,null,null,null,null,null,"EG VO(7)"]
[null,null,null,null,null,null,null,"PPP+RET.CARNET"]
[null,null,null,null,null,null,null,"DESEMPLEO + RET.CARNET"]
[null,null,null,null,null,null,null,"PPP-SENIOR (M)"]
[null,null,null,null,null,null,null,"PPP-EXTENSIÓN DE GARANTÍA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,2,null,null,{"$f":"INDEX(I76:I94,H31,1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Financiadas",null,"PPP",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($F$9,SEG!$A$3:$A$122,1),2)","v":{"$error":"#N/A"}},{"$f":"+$D$85*I76","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Al Contado",null,"Siniestro Total",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($F$9,SEG!$A$3:$A$122,1),3)","v":{"$error":"#N/A"}},{"$f":"+$D$85*I77","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"PLATINO:PPP+Sust.+R.C.",{"$f":"+I76+I88+I89","v":{"$error":"#N/A"}},{"$f":"+$D$85*I78","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"DORADO: Sustit.+ R.C",{"$f":"+I88+I89","v":{"$error":"#N/A"}},{"$f":"+$D$85*I79","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"PPP+ Siniestro Total",{"$f":"+I76+I77","v":{"$error":"#N/A"}},{"$f":"+J76+J77","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"PPP+ Siniestro Total+Y",{"$f":"+I77+I76+I88","v":{"$error":"#N/A"}},{"$f":"+J88+J77+J76","v":{"$error":"#N/A"}}]
[null,"Min CAP",150,null,null,null,null,"Desempleo",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($F$9,SEG!$A$3:$A$122,1),5)","v":{"$error":"#N/A"}},{"$f":"+$D$85*I82","v":{"$error":"#N/A"}}]
[null,"Min CEST",30.05,null,null,null,null,"Desempleo+ ST",{"$f":"I82+I77","v":{"$error":"#N/A"}},{"$f":"+$D$85*I83","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Desempleo+ ST+ Y",{"$f":"I82+I77+I88","v":{"$error":"#N/A"}},{"$f":"+$D$85*I84","v":{"$error":"#N/A"}}]
[null,null,"Principal",{"$f":"+C7","v":0},null,null,null,"Desempleo+ Y",{"$f":"I82+I88","v":{"$error":"#N/A"}},{"$f":"+I85*D85","v":{"$error":"#N/A"}}]
[null,null,"Seguro",{"$f":"ROUND((INDEX(J76:J95,H31,1)),2)","v":{"$error":"#N/A"}},null,null,null,"Vehic. Sustic.+ ST",{"$f":"+I88+I77","v":{"$error":"#N/A"}},{"$f":"+I86*D85","v":{"$error":"#N/A"}}]
[null,{"$f":"+ROUND(IF(D85=0,0,IF($F$75=1,(D85+D86)*(C13),0)),2)","v":0},"CAP",{"$f":"+ROUND(IF((SUM(D85:D86)*$C$13)<$C$82,$C$82,(SUM(D85:D86)*$C$13)),2)","v":{"$error":"#N/A"}},null,null,null,"Sin Seguros",0,{"$f":"+I87","v":0}]
[null,{"$f":"+IF(D85=0,0,IF($F$75=1,(D85+D86)*(E13),0))","v":0},"CEST",{"$f":"+IF(E13=0,0,(IF((SUM(D85:D86)*$E$13)<$C$83,$C$83,(SUM(D85:D86)*$E$13))))","v":0},null,null,null,"Vehic. Sustituc.(Y)",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($F$9,SEG!$A$3:$A$122,1),6)","v":{"$error":"#N/A"}},{"$f":"+I88*D85","v":{"$error":"#N/A"}}]
[null,null,"Financiado",{"$f":"+ROUND(IF(F75=1,SUM(D85:D88),SUM(D85:D86)),2)","v":{"$error":"#N/A"}},null,null,null,"Retirada Carnet",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($F$9,SEG!$A$3:$A$122,1),7)","v":{"$error":"#N/A"}},{"$f":"+I89*D85","v":{"$error":"#N/A"}}]
[null,null,"Plazo",{"$f":"+IF(F9=\"\",\"\",F9)","v":""},null,null,null,"EG VO",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($F$9,SEG!$A$3:$A$122,1),8)","v":{"$error":"#N/A"}},{"$f":"+I90","v":{"$error":"#N/A"}}]
[null,null,"Nº Cuotas Irreg.",{"$f":"+IF(D17=\"\",\"\",D17)","v":""},null,null,null,"PPP+RET.CARNET",{"$f":"I76+I89","v":{"$error":"#N/A"}},{"$f":"+I91*D85","v":{"$error":"#N/A"}}]
[null,null,"Resto de Cuotas",{"$f":"+IF(D17=\"\",\"\",IF((D90-D91)=\"\",\"\",D90-D91))","v":""},null,null,null,"DESEMPLEO + RET.CARNET",{"$f":"I82+I89","v":{"$error":"#N/A"}},{"$f":"+I92*D85","v":{"$error":"#N/A"}}]
[null,null,{"$f":"+\"RV \"&D91","v":"RV "},{"$f":"ROUND(FV($C$9/12,D91,0,-D15,0),2)","v":{"$error":"#VALUE!"}},null,null,null,"PPP-SENIOR (M)",{"$f":"INDEX(SEG!$A$3:$J$122,MATCH($F$9,SEG!$A$3:$A$122,1),10)","v":{"$error":"#N/A"}},{"$f":"+$D$85*I93","v":{"$error":"#N/A"}}]
[null,null,"Importe Resto Cuotas",null,{"$f":"ROUND(IF(D17=\"\",\"\",PMT(C9/12,D92,-D93,0,0)),4)","v":{"$error":"#VALUE!"}},null,null,"PPP-EXTENSIÓN DE GARANTÍA",{"$f":"+I76","v":{"$error":"#N/A"}},{"$f":"J76+J90","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[null,"TAE",{"$f":"+IF(ISERROR(((1+(C101/12))^12)-1),\"\",((1+(C101/12))^12)-1)","v":""}]
[null,"TIR",{"$f":"+IRR(C102:C222,0.0025)*12","v":{"$error":"#VALUE!"}}]
[null,0,{"$f":"+IF(F75=1,-D89,-D89+D87+D88)","v":{"$error":"#N/A"}}]
[null,1,{"$f":"+IF(B103<($D$91+1),0,IF(B103<($D$90+1),$E$94,0))","v":{"$error":"#VALUE!"}}]
[null,2,{"$f":"+IF(B104<($D$91+1),0,IF(B104<($D$90+1),$E$94,0))","v":{"$error":"#VALUE!"}}]
[null,3,{"$error":"#VALUE!"}]
[null,4,{"$error":"#VALUE!"}]
[null,5,{"$error":"#VALUE!"}]
[null,6,{"$error":"#VALUE!"}]
[null,7,{"$error":"#VALUE!"}]
[null,8,{"$error":"#VALUE!"}]
[null,9,{"$error":"#VALUE!"}]
[null,10,{"$error":"#VALUE!"}]
[null,11,{"$error":"#VALUE!"}]
[null,12,{"$error":"#VALUE!"}]
[null,13,{"$error":"#VALUE!"}]
[null,14,{"$error":"#VALUE!"}]
[null,15,{"$error":"#VALUE!"}]
[null,16,{"$error":"#VALUE!"}]
[null,17,{"$error":"#VALUE!"}]
[null,18,{"$error":"#VALUE!"}]
[null,19,{"$error":"#VALUE!"}]
[null,20,{"$error":"#VALUE!"}]
[null,21,{"$error":"#VALUE!"}]
[null,22,{"$error":"#VALUE!"}]
[null,23,{"$error":"#VALUE!"}]
[null,24,{"$error":"#VALUE!"}]
[null,25,{"$error":"#VALUE!"}]
[null,26,{"$error":"#VALUE!"}]
[null,27,{"$error":"#VALUE!"}]
[null,28,{"$error":"#VALUE!"}]
[null,29,{"$error":"#VALUE!"}]
[null,30,{"$error":"#VALUE!"}]
[null,31,{"$error":"#VALUE!"}]
[null,32,{"$error":"#VALUE!"}]
[null,33,{"$error":"#VALUE!"}]
[null,34,{"$error":"#VALUE!"}]
[null,35,{"$error":"#VALUE!"}]
[null,36,{"$error":"#VALUE!"}]
[null,37,{"$error":"#VALUE!"}]
[null,38,{"$error":"#VALUE!"}]
[null,39,{"$error":"#VALUE!"}]
[null,40,{"$error":"#VALUE!"}]
[null,41,{"$error":"#VALUE!"}]
[null,42,{"$error":"#VALUE!"}]
[null,43,{"$error":"#VALUE!"}]
[null,44,{"$error":"#VALUE!"}]
[null,45,{"$error":"#VALUE!"}]
[null,46,{"$error":"#VALUE!"}]
[null,47,{"$error":"#VALUE!"}]
[null,48,{"$error":"#VALUE!"}]
[null,49,{"$error":"#VALUE!"}]
[null,50,{"$error":"#VALUE!"}]
[null,51,{"$error":"#VALUE!"}]
[null,52,{"$error":"#VALUE!"}]
[null,53,{"$error":"#VALUE!"}]
[null,54,{"$error":"#VALUE!"}]
[null,55,{"$error":"#VALUE!"}]
[null,56,{"$error":"#VALUE!"}]
[null,57,{"$error":"#VALUE!"}]
[null,58,{"$error":"#VALUE!"}]
[null,59,{"$error":"#VALUE!"}]
[null,60,{"$error":"#VALUE!"}]
[null,61,{"$error":"#VALUE!"}]
[null,62,{"$error":"#VALUE!"}]
[null,63,{"$error":"#VALUE!"}]
[null,64,{"$error":"#VALUE!"}]
[null,65,{"$error":"#VALUE!"}]
[null,66,{"$f":"+IF(B168<($D$91+1),0,IF(B168<($D$90+1),$E$94,0))","v":{"$error":"#VALUE!"}}]
[null,67,{"$error":"#VALUE!"}]
[null,68,{"$error":"#VALUE!"}]
[null,69,{"$error":"#VALUE!"}]
[null,70,{"$error":"#VALUE!"}]
[null,71,{"$error":"#VALUE!"}]
[null,72,{"$error":"#VALUE!"}]
[null,73,{"$error":"#VALUE!"}]
[null,74,{"$error":"#VALUE!"}]
[null,75,{"$error":"#VALUE!"}]
[null,76,{"$error":"#VALUE!"}]
[null,77,{"$error":"#VALUE!"}]
[null,78,{"$error":"#VALUE!"}]
[null,79,{"$error":"#VALUE!"}]
[null,80,{"$error":"#VALUE!"}]
[null,81,{"$error":"#VALUE!"}]
[null,82,{"$error":"#VALUE!"}]
[null,83,{"$error":"#VALUE!"}]
[null,84,{"$error":"#VALUE!"}]
[null,85,{"$error":"#VALUE!"}]
[null,86,{"$error":"#VALUE!"}]
[null,87,{"$error":"#VALUE!"}]
[null,88,{"$error":"#VALUE!"}]
[null,89,{"$error":"#VALUE!"}]
[null,90,{"$error":"#VALUE!"}]
[null,91,{"$error":"#VALUE!"}]
[null,92,{"$error":"#VALUE!"}]
[null,93,{"$error":"#VALUE!"}]
[null,94,{"$error":"#VALUE!"}]
[null,95,{"$error":"#VALUE!"}]
[null,96,{"$error":"#VALUE!"}]
[null,97,{"$error":"#VALUE!"}]
[null,98,{"$error":"#VALUE!"}]
[null,99,{"$error":"#VALUE!"}]
[null,100,{"$error":"#VALUE!"}]
[null,101,{"$error":"#VALUE!"}]
[null,102,{"$error":"#VALUE!"}]
[null,103,{"$error":"#VALUE!"}]
[null,104,{"$error":"#VALUE!"}]
[null,105,{"$error":"#VALUE!"}]
[null,106,{"$error":"#VALUE!"}]
[null,107,{"$error":"#VALUE!"}]
[null,108,{"$error":"#VALUE!"}]
[null,109,{"$error":"#VALUE!"}]
[null,110,{"$error":"#VALUE!"}]
[null,111,{"$error":"#VALUE!"}]
[null,112,{"$error":"#VALUE!"}]
[null,113,{"$error":"#VALUE!"}]
[null,114,{"$error":"#VALUE!"}]
[null,115,{"$error":"#VALUE!"}]
[null,116,{"$error":"#VALUE!"}]
[null,117,{"$error":"#VALUE!"}]
[null,118,{"$error":"#VALUE!"}]
[null,119,{"$error":"#VALUE!"}]
[null,120,{"$error":"#VALUE!"}]

{"sheet":"LEASING","index":7,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,"volver"]
[]
[null,null,null,null,null,"SIMULADOR OPERACIONES DE LEASING"]
[]
[null,"Imp. Financiado"]
[]
[null,"T.I.N. Anual (1)",null,"Plazo "]
[]
[null,"Com. Apert.",null,"Com. Estudio"]
[]
[null,"Importe de las Cuotas",null,{"$f":"+D36","v":""}]
[]
[null,"Valor Residual igual a UNA Cuota"]
[]
[null,"(1) Condiciones financieras de la Tarifa correspondiente al Colaborador"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,1,null,1]
[null,null,null,null,null,"Financiada ",null,"Sí"]
[null,null,null,null,null,"Al Contado",null,"No"]
[]
[null,null,null,null,null,"Imprte Seguro",{"$f":"+IF(D31<18030.36,442.12,IF(D31<30050.61,912.91,1800.99))","v":442.12}]
[]
[null,null,"Principal",{"$f":"+C5","v":0}]
[null,null,"Seguro",{"$f":"+IF(D31=0,\"\",IF(H25=1,G29,0))","v":""}]
[null,null,"CAP",{"$f":"+IF(D31=0,\"\",IF(F25=1,(D31+D32)*C9,0))","v":""}]
[null,null,"Financiado",{"$f":"+ROUND(SUM(D31:D33),2)","v":0}]
[null,null,"Plazo",{"$f":"+IF(E7=\"\",\"\",E7)","v":""}]
[null,null,"Cuotas",{"$f":"+IF(C5=\"\",\"\",PMT($C$7/12,E7+1,-C5,0,1))","v":""}]

{"sheet":"DOBLE TIPO 12.0","index":8,"n_rows":172,"n_cols":12,"rows_kept":172,"cut":false,"hidden":false,"merged":[[3,3,3,7],[0,5,0,8],[2,2,2,7],[4,3,4,7]]}
[null,null,null,null,"Volver"]
[]
[]
[null,null,null,"Simulador de Cuotas"]
[null,null,null,"DOBLE TIPO 12.0"]
[]
[null,null,null,"Importe Solicitado"]
[]
[null,null,null,"Plazo Total de la Operación",null,"meses"]
[]
[null,null,null,"TIN del Período 1",0,"Duración Período 1",null,12]
[]
[null,null,null,"TIN del Período 2",null,"Duración Período 2",null,{"$f":"+IF(F48=\"\",\"\",F48-H11)","v":48}]
[]
[null,null,null,"Seguro (2)"]
[]
[null,null,null,"Com. Apert.",3.95E-2]
[]
[null,null,null,"Importe Total Financiado",null,{"$f":"+IF(ISERROR(F44),\"\",F44)","v":150}]
[]
[null,null,null,{"$f":"+IF(H11=\"\",\"\",\"Cuotas de las 1 a la \"&H11)","v":"Cuotas de las 1 a la 12"},{"$f":"IF(E7=\"\",\"\",PMT(E11/12,F48,-F19,0,0))","v":""}]
[]
[null,null,null,{"$f":"+IF(H11=\"\",\"\",\"Cuotas de la \"&H11+1&\" a la \"&F48)","v":"Cuotas de la 13 a la 60"},{"$f":"IF(ISERROR(PMT(F47/12,H13,-F46,0,0)),\"\",PMT(F47/12,H13,-F46,0,0))","v":""}]
[null,null,null,"TAE",{"$f":"+E50","v":""}]
[]
[null,null,null,"Válido para VN y VSN."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,1,null,1,null,{"$f":"INDEX(L36:L74,J35,1)","v":0}]
[null,null,null,null,"Min CAP",150,null,"Financiadas",null,"PPP",{"$f":"INDEX(SEG!$A$3:$J$122,$F$48,2)","v":5.3197399999999999E-2},{"$f":"+K36*$E$7","v":0}]
[null,null,null,null,null,null,null,"Al Contado",null,"Siniestro Total",{"$f":"INDEX(SEG!$A$3:$J$122,$F$48,3)","v":5.3407000000000003E-2},0]
[null,null,null,null,null,null,null,null,null,"PLATINO: PPP+Sustic.+R.Carnet",{"$f":"+K36+K49+K48","v":8.9342399999999975E-2},0]
[null,null,null,null,null,null,null,"Imprte Seguro",null,"DORADO:Sustic.+R.C.",{"$f":"+K49+K48","v":3.6144999999999983E-2},0]
[null,null,1,null,null,null,null,null,null,"PPP+ST",{"$f":"+K36+K37","v":0.1066044},0]
[null,null,60,null,"Principal",{"$f":"+E7","v":0},null,null,null,"PPP+ST+Y",{"$f":"+K36+K37+K48","v":0.12544439999999998},0]
[null,null,72,null,"Seguro",{"$f":"+IF(F41=0,\"\",L35)","v":""},null,null,null,"TITANIO: PPP+Y",{"$f":"K36+K48","v":7.2037399999999974E-2},{"$f":"+L48+L36","v":0}]
[null,null,84,null,"CAP",{"$f":"+IF((SUM(F41:F42)*$E$17)<$F$36,$F$36,(SUM(F41:F42)*$E$17))","v":150},null,null,null,"Desempleo (t/x)",{"$f":"INDEX(SEG!$A$3:$J$122,$F$48,5)","v":8.8791079999999994E-2},{"$f":"+K43*$E$7","v":0}]
[null,null,96,null,"Financiado",{"$f":"+IF(H35=1,SUM(F41:F43),SUM(F41:F42))","v":150},null,null,null,"Desempleo+ ST",{"$f":"K43+K37","v":0.14219808},{"$f":"+L43+L37","v":0}]
[null,null,108,null,"Plazo",{"$f":"+IF(H13=\"\",\"\",H13)","v":48},null,null,null,"Desempleo+ ST+Y",{"$f":"K43+K37+K48","v":0.16103807999999997},{"$f":"+K45*$E$7","v":0}]
[null,null,120,null,"VR",{"$f":"FV(E11/12,H11,E21,-F44,0)","v":{"$error":"#VALUE!"}},null,null,null,"Desempleo+Y",{"$f":"K43+K48","v":0.10763107999999998},{"$f":"+L43+L48","v":0}]
[null,null,null,null,"tin plazo 2",{"$f":"+$E$13","v":0},null,null,null,"Vehic. Sustic. + ST",{"$f":"K48+K37","v":7.2246999999999978E-2},{"$f":"+L48+L37","v":0}]
[null,null,null,null,"Plazo Total",{"$f":"+INDEX(C41:C46,C40,1)","v":60},null,null,null,"Vehic. Sustic. (Y)",{"$f":"INDEX(SEG!$A$3:$J$122,$F$48,6)","v":1.8839999999999982E-2},{"$f":"+K48*$E$7","v":0}]
[null,null,null,null,null,null,null,null,null,"Retirada Carnet",{"$f":"INDEX(SEG!$A$3:$J$122,$F$48,7)","v":1.7305000000000001E-2},{"$f":"+K49*$E$7","v":0}]
[null,null,null,"TAE",{"$f":"+IF(ISERROR(((1+(E51/12))^12)-1),\"\",((1+(E51/12))^12)-1)","v":""},null,null,null,null,"EG VO",{"$f":"INDEX(SEG!$A$3:$J$122,$F$48,8)","v":257.51},{"$f":"+K50","v":257.51}]
[null,null,null,"TIR",{"$f":"+IRR(E52:E172,0.0025)*12","v":{"$error":"#NUM!"}},null,null,null,null,"JADE VO (PPP+ EG VO)",{"$f":"K36","v":5.3197399999999999E-2},{"$f":"(+K51*$E$7)+L50","v":257.51}]
[null,null,null,0,{"$f":"+IF(H35=1,-F44,-F44+F43)","v":-150},null,null,null,null,"Desempleo + EG V0",{"$f":"K43","v":8.8791079999999994E-2},{"$f":"(+K52*$E$7)+L50","v":257.51}]
[null,null,null,1,{"$f":"+IF(D53<=($F$48-$F$45),$E$21,IF(D53<=($F$48+1),$E$23,0))","v":""},null,null,null,null,"PPP-Senior( M)",{"$f":"INDEX(SEG!$A$3:$J$122,$F$48,10)","v":0.1249397},{"$f":"+K53*$E$7","v":0}]
[null,null,null,2,""]
[null,null,null,3,""]
[null,null,null,4,""]
[null,null,null,5,""]
[null,null,null,6,""]
[null,null,null,7,""]
[null,null,null,8,""]
[null,null,null,9,""]
[null,null,null,10,""]
[null,null,null,11,""]
[null,null,null,12,""]
[null,null,null,13,{"$f":"+IF(D65<($F$48-$F$45),$E$21,IF(D65<($F$48+1),$E$23,0))","v":""}]
[null,null,null,14,{"$f":"+IF(D66<($F$48-$F$45),$E$21,IF(D66<($F$48+1),$E$23,0))","v":""}]
[null,null,null,15,""]
[null,null,null,16,""]
[null,null,null,17,""]
[null,null,null,18,""]
[null,null,null,19,""]
[null,null,null,20,""]
[null,null,null,21,""]
[null,null,null,22,""]
[null,null,null,23,""]
[null,null,null,24,""]
[null,null,null,25,""]
[null,null,null,26,""]
[null,null,null,27,""]
[null,null,null,28,""]
[null,null,null,29,""]
[null,null,null,30,""]
[null,null,null,31,""]
[null,null,null,32,""]
[null,null,null,33,""]
[null,null,null,34,""]
[null,null,null,35,""]
[null,null,null,36,""]
[null,null,null,37,""]
[null,null,null,38,""]
[null,null,null,39,""]
[null,null,null,40,""]
[null,null,null,41,""]
[null,null,null,42,""]
[null,null,null,43,""]
[null,null,null,44,""]
[null,null,null,45,""]
[null,null,null,46,""]
[null,null,null,47,""]
[null,null,null,48,""]
[null,null,null,49,""]
[null,null,null,50,""]
[null,null,null,51,""]
[null,null,null,52,""]
[null,null,null,53,""]
[null,null,null,54,""]
[null,null,null,55,""]
[null,null,null,56,""]
[null,null,null,57,""]
[null,null,null,58,""]
[null,null,null,59,""]
[null,null,null,60,""]
[null,null,null,61,0]
[null,null,null,62,0]
[null,null,null,63,0]
[null,null,null,64,0]
[null,null,null,65,0]
[null,null,null,66,0]
[null,null,null,67,0]
[null,null,null,68,0]
[null,null,null,69,0]
[null,null,null,70,0]
[null,null,null,71,0]
[null,null,null,72,0]
[null,null,null,73,0]
[null,null,null,74,0]
[null,null,null,75,0]
[null,null,null,76,0]
[null,null,null,77,0]
[null,null,null,78,{"$f":"+IF(D130<($F$48-$F$45),$E$21,IF(D130<($F$48+1),$E$23,0))","v":0}]
[null,null,null,79,0]
[null,null,null,80,0]
[null,null,null,81,0]
[null,null,null,82,0]
[null,null,null,83,0]
[null,null,null,84,0]
[null,null,null,85,0]
[null,null,null,86,0]
[null,null,null,87,0]
[null,null,null,88,0]
[null,null,null,89,0]
[null,null,null,90,0]
[null,null,null,91,0]
[null,null,null,92,0]
[null,null,null,93,0]
[null,null,null,94,0]
[null,null,null,95,0]
[null,null,null,96,0]
[null,null,null,97,0]
[null,null,null,98,0]
[null,null,null,99,0]
[null,null,null,100,0]
[null,null,null,101,0]
[null,null,null,102,0]
[null,null,null,103,0]
[null,null,null,104,0]
[null,null,null,105,0]
[null,null,null,106,0]
[null,null,null,107,0]
[null,null,null,108,0]
[null,null,null,109,0]
[null,null,null,110,0]
[null,null,null,111,0]
[null,null,null,112,0]
[null,null,null,113,0]
[null,null,null,114,0]
[null,null,null,115,0]
[null,null,null,116,0]
[null,null,null,117,0]
[null,null,null,118,0]
[null,null,null,119,0]
[null,null,null,120,0]

{"sheet":"DOBLE TIPO 6.0","index":9,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":true,"merged":[[3,3,3,7],[2,5,2,9],[4,3,4,7]]}
[null,null,null,null,null,"Volver"]
[]
[]
[null,null,null,"Simulador de Cuotas"]
[null,null,null,"DOBLE TIPO 6.0"]
[]
[null,null,null,"Importe Solicitado"]
[]
[null,null,null,"Plazo Total de la Operación",null,"meses"]
[]
[null,null,null,"TIN del Período 1",0,"Duración 1er Período",null,6,"meses"]
[]
[null,null,null,"TIN del Período 2",null,"Duración 2o Período",null,{"$f":"+IF(F48=\"\",\"\",F48-H11)","v":66},"meses"]
[]
[null,null,null,"Seguro (2)"]
[]
[null,null,null,"Com. Apert.",3.95E-2]
[]
[null,null,null,"Importe Total Financiado",null,{"$f":"+IF(ISERROR(F44),\"\",F44)","v":0}]
[]
[null,null,null,{"$f":"+IF(H11=\"\",\"\",\"Cuotas de las 1 a la \"&H11)","v":"Cuotas de las 1 a la 6"},{"$f":"IF(E7=\"\",\"\",PMT(E11/12,F48,-F19,0,0))","v":""}]
[]
[null,null,null,{"$f":"+IF(H11=\"\",\"\",\"Cuotas de la \"&H11+1&\" a la \"&F48)","v":"Cuotas de la 7 a la 72"},{"$f":"IF(ISERROR(PMT(F47/12,H13,-F46,0,0)),\"\",PMT(F47/12,H13,-F46,0,0))","v":""}]
[]
[]
[null,null,null,"Válido para VN y VSN."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO SEGURO"]
[]
[null,null,null,null,null,null,null,1,null,null,1,{"$f":"INDEX($M36:$M46,$K35,1)","v":0},{"$f":"+INDEX($M$36:$M$76,K35,1)","v":0}]
[null,null,null,null,null,null,null,"Financiadas",null,null,"PPP",{"$f":"INDEX(SEG!$A$3:$F$122,$F$48,2)","v":5.7136300000000001E-2},{"$f":"+L36*$E$7","v":0},"Q"]
[null,null,null,null,null,null,null,"Al Contado",null,null,"Siniestro Total",{"$f":"INDEX(SEG!$A$3:$F$122,$F$48,3)","v":6.4088300000000001E-2},{"$f":"+L37*$E$7","v":0},"D"]
[null,null,null,null,null,null,null,null,null,null,"PPP + ST",{"$f":"+L36+L37","v":0.1212246},0,"Q+D"]
[null,null,null,null,null,null,null,"Imprte Seguro",null,null,"Desemp./Incap.",{"$f":"INDEX(SEG!$A$3:$F$122,$F$48,4)","v":9.269194E-2},0,"T/X"]
[null,null,1,2,null,null,null,null,null,null,"Des/Inc + ST",{"$f":"L37+L39","v":0.15678024000000002},0,"T/X + D"]
[null,null,3.9899999999999998E-2,60,"Principal",{"$f":"+E7","v":0},null,null,null,null,"Vehic.Sustit",{"$f":"INDEX(SEG!$A$3:$F$122,$F$48,6)","v":2.2607999999999961E-2},0,"Y"]
[null,null,4.99E-2,72,"Seguro",{"$f":"+IF(F41=0,\"\",M35)","v":""},null,null,null,null,"TITANIO (PPP+Vehic.Sust)",{"$f":"L36+L41","v":7.9744299999999962E-2},{"$f":"+M41+M36","v":0},"Q+Y"]
[null,null,5.9900000000000002E-2,84,"CAP",{"$f":"+IF(F41=0,\"\",IF(H35=1,(F41+F42)*(E17+G17),0))","v":""},null,null,null,null,"PPP+D+Vehic sust",{"$f":"L36+L37+L41","v":0.14383259999999998},{"$f":"+M36+M37+M41","v":0},"Q+D+Y"]
[null,null,6.9900000000000004E-2,96,"Financiado",{"$f":"+ROUND(SUM(F41:F43),2)","v":0},null,null,null,null,"Desemp./Incap.+Vehic Sust",{"$f":"L39+L41","v":0.11529993999999996},{"$f":"+M39+M41","v":0},"T/X+Y"]
[null,null,7.9899999999999999E-2,108,"Plazo",{"$f":"+IF(H13=\"\",\"\",H13)","v":66},null,null,null,null,"Desempl/Incap+Vehic Sust+ST",{"$f":"L39+L41+L37","v":0.17938823999999998},{"$f":"+M37+M39+M41","v":0},"T/X+D+Y"]
[null,null,8.9899999999999994E-2,120,"VR",{"$f":"FV(E11/12,H11,E21,-F44,0)","v":{"$error":"#VALUE!"}},null,null,null,null,"ST+Vehic Sust.",{"$f":"L37+L41","v":8.6696299999999962E-2},{"$f":"+M37+M41","v":0},"D+Y"]
[null,null,null,null,"tin plazo 2",{"$f":"INDEX(C41:C46,C40,1)","v":3.9899999999999998E-2},null,null,null,null,"Retirada de Canet",{"$f":"INDEX(SEG!$A$3:$G$122,$F$48,7)","v":2.0766E-2},{"$f":"+L47*$E$7","v":0}]
[null,null,null,null,"Plazo Total",{"$f":"+INDEX(D41:D46,D40,1)","v":72},null,null,null,null,"DORADO (Sust + RC)",{"$f":"L41+L47","v":4.3373999999999961E-2},{"$f":"+M47+M41","v":0}]
[null,null,null,null,null,null,null,null,null,null,"PLATINO (PPP+Sust+RC)",{"$f":"L36+L41+L47","v":0.10051029999999997},{"$f":"+M36+M41+M47","v":0}]
[null,null,null,null,null,null,null,null,null,null,"EXTENSIÓN DE GARANTÍA VO (7)",252.75,{"$f":"+L50","v":252.75}]
[null,null,null,null,null,null,null,null,null,null,"PPP-SENIOR (M)",{"$f":"INDEX(SEG!$A$3:$J$122,$F$48,10)","v":0.16395290000000001},{"$f":"L51*$E$7","v":0}]
[null,null,null,null,null,null,null,null,null,null,"PPP-EXTENSIÓN DE GARANTÍA",null,{"$f":"M36+M50","v":252.75}]

{"sheet":"DEMOS","index":10,"n_rows":276,"n_cols":17,"rows_kept":276,"cut":false,"hidden":true,"merged":[[0,6,0,7],[4,1,4,5]]}
["volver"]
[]
[null,null,null,null,null,"Consumer Finance"]
[]
[null,"SIMULADOR OPERACIONES DEMO"]
[]
[null,"Principal",391142.43]
[]
[null,"T.I.N. Anual (1)",1.9E-2,"Plazo",8]
[]
[null,"Seguros (2)",null,null,{"$f":"IF(AND(E9<H26,OR(P33=4,P33=5,P33=8,P33=9,P33=10,P33=11)),\"¡¡¡Seguro tipo Y no contratable por plazo, Cambie de producto!!!\",\"\")","v":""}]
[]
[null,"Com. Apert.",2.5000000000000001E-3,"Com. Estudio"]
[]
[null,"% Amortización mensuales sobre el capital (3)",null,null,0.05]
[]
[null,"Importe Total Financiado",null,{"$f":"+IF(ISERROR(N46),\"\",N46)","v":392120.28607500001}]
[]
[null,"Ultima Cuota",null,{"$f":"+($E$15*($E$9-1))","v":0.35000000000000003}]
[]
[]
[null,"Importe de las Cuotas",null,{"$f":"+N48","v":49364.912486590416}]
[null,null,"TAE",{"$f":"+IF(ISERROR((((1+((IRR(E32:E153,0.0025)*12)/12))^12)-1)),\"\",(((1+((IRR(E32:E153,0.0025)*12)/12))^12)-1))","v":2.3260630705635332E-2}]
[]
[null,"(1) Condiciones financieras de la Tarifa correspondiente al Colaborador"]
[null,"(2) En operaciones a partir de 84 meses el Seguro PPP es obligatorio. Plazo minimo segruo TIPO Y (meses)"]
[null,"(3) El % de amortización mensual debe estar autorizado e indicado por el Dpto de Riesgos."]
[]
[null,null,{"$f":"+SUM(C33:C39)","v":137242.10012625004}]
[null,null,{"$f":"+C29+C40","v":392120.28607500001}]
[null,"Nº Cuota","Amortización","Intereses","Cuotas","Pendiente"]
[0,{"$f":"+IF(A32<($E$9+1),A32,\"\")","v":0},null,null,{"$f":"IF(M33=2,-D17+($N$44+$N$45),-D17)","v":-392120.28607500001},{"$f":"+IF(B32<>\"\",D17,\"\")","v":392120.28607500001}]
[1,{"$f":"+IF(A33<($E$9+1),A33,\"\")","v":1},{"$f":"+IF(B33=\"\",\"\",IF($E$9=B33,(1-(($E$9-1)*$E$15))*$D$17,$E$15*$D$17))","v":19606.014303750002},{"$f":"+IF(B33=\"\",\"\",$C$9/12*$D$17)","v":620.85711961874995},{"$f":"+IF(B33=\"\",\"\",C33+D33)","v":20226.871423368753},{"$f":"+IF(B33<>\"\",F32-C33,\"\")","v":372514.27177125},null,null,null,null,null,null,1,null,13,{"$f":"IF(OR(O33=4,O33=5,O33=8,O33=9,O33=10,O33=11),O33,0)","v":0},{"$f":"+IF(AND((O33=2),(E9>84)),\"xx\",\"\")","v":""}]
[2,2,19606.014303750002,{"$f":"+IF(B34=\"\",\"\",$C$9/12*$D$17)","v":620.85711961874995},20226.871423368753,{"$f":"+IF(B34<>\"\",F33-C34,\"\")","v":352908.25746749999},null,null,null,null,null,null,"Financiadas",null,"PPP",null,{"$f":"+IF(AND((O33=3),(E9>84)),\"xx\",\"\")","v":""}]
[3,3,19606.014303750002,620.85711961874995,20226.871423368753,333302.24316374998,null,null,null,null,null,null,"Al Contado",null,"Siniestro Total",null,{"$f":"+IF(OR((Q33=\"xx\"),(Q34=\"xx\")),\"X\",\"\")","v":""}]
[4,4,19606.014303750002,620.85711961874995,20226.871423368753,313696.22885999997,null,null,null,null,null,null,null,null,"PLATINO: PPP+Sustitc. + R. Carnet"]
[5,5,19606.014303750002,620.85711961874995,20226.871423368753,294090.21455624996,null,null,null,null,null,"Min CAP",{"$f":"IF(C13<>0,150,0)","v":150},null,"DORADO:Sustitc.+ R.Carnet "]
[6,6,19606.014303750002,620.85711961874995,20226.871423368753,274484.20025249996,null,null,null,null,null,"Min CEST",{"$f":"+IF($E$13=0,0,30.05)","v":0},null,"PPP+ST"]
[7,7,19606.014303750002,620.85711961874995,20226.871423368753,254878.18594874995,null,null,null,null,null,null,null,null,"PPP+ST+Y"]
[8,8,254878.18594874998,620.85711961874995,255499.04306836872,-2.9103830456733704E-11,null,null,null,null,null,null,null,null,"TITANIO: PPP+ Y"]
[9,"","","","","",null,null,null,null,null,null,null,null,"Desempleo"]
[10,"","","","","",null,null,null,null,null,null,"Principal",{"$f":"+C7","v":391142.43},"Desempleo+ST"]
[11,"","","","","",null,null,null,null,null,null,"Seguros",{"$f":"(INDEX(M77:M97,O33,1))","v":0},"Desempleo+ST+Y"]
[12,"","","","","",null,null,null,null,null,{"$f":"+IF($N$42=0,\"\",IF(M$33=1,($N$42+$N$43)*$C$13,0))","v":977.85607500000003},"CAP",{"$f":"+IF((C13*($N$42+$N$43))<M37,M37,C13*($N$42+$N$43))","v":977.85607500000003},"Desempleo+Y"]
[13,"","","","","",null,null,null,null,null,{"$f":"+IF($N$42=0,\"\",IF(M$33=1,($N$42+$N$43)*$E$13,0))","v":0},"CEST",{"$f":"+IF((C14*($N$42+$N$43))<M38,M38,C14*($N$42+$N$43))","v":0},"Vehic Sustituc+ST"]
[14,"","","","","",null,null,null,null,null,{"$f":"IF(E13>0,L45,\"\")","v":""},"Financiado",{"$f":"+IF(M33=1,N42+N43+N44+N45,N42+N43)","v":392120.28607500001},"Sin Seguros"]
[15,"",{"$f":"+IF(B47=\"\",\"\",IF($E$9=B47,(1-(($E$9-1)*$E$15))*$D$17,$E$15*$D$17))","v":""},"","","",null,null,null,null,null,null,"Plazo",{"$f":"+IF(E9=\"\",\"\",E9)","v":8},"Vehic Sustituc (Y)"]
[16,"",{"$f":"+IF(B48=\"\",\"\",IF($E$9=B48,(1-(($E$9-1)*$E$15))*$D$17,$E$15*$D$17))","v":""},"","","",null,null,null,null,null,null,"Cuotas",{"$f":"IF(ISERROR(PMT($C$9/12,N47,-N46,0,0)),\"\",PMT($C$9/12,N47,-N46,0,0))","v":49364.912486590416},"Retirada Carnet"]
[17,"","","","","",null,null,null,null,null,null,null,null,"EG VN"]
[18,"","","","","",null,null,null,null,null,null,null,null,"EG VO"]
[19,"","","","","",null,null,null,null,null,null,null,null,"JADE VN (PPP+ EG VN)"]
[20,"","","","","",null,null,null,null,null,null,null,null,"JADE VO (PPP+EG VO)"]
[21,"","","","","",null,null,null,null,null,null,null,null,"Desempleo + PPP + EG VN"]
[22,"","","","","",null,null,null,null,null,null,null,null,"Desempleo + PPP + EG VO"]
[23,"","","","",""]
[24,"","","","",""]
[25,"","","","",""]
[26,"","","","",""]
[27,"","","","",""]
[28,"","","","",""]
[29,"","","","",""]
[30,"","","","",""]
[31,"","","","",""]
[32,"","","","",""]
[33,"","","","",""]
[34,"","","","",""]
[35,"","","","",""]
[36,"","","","",""]
[37,"","","","",""]
[38,"","","","",""]
[39,"","","","",""]
[40,"","","","",""]
[41,"","","","",""]
[42,"","","","",""]
[43,"","","","",""]
[44,"","","","",""]
[45,"","","","","",null,null,"PPP",{"$f":"INDEX(SEG!$A$3:$I$122,MATCH($E$9,SEG!$A$3:$A$122,1),2)","v":9.2464999999999995E-3},null,null,{"$f":"+J77*$N$42","v":3616.6984789949997}]
[46,"","","","","",null,null,"Siniestro Total",{"$f":"INDEX(SEG!$A$3:$I$122,MATCH($E$9,SEG!$A$3:$A$122,1),3)","v":7.2725000000000003E-3},null,null,2844.5833221749999]
[47,"","","","","",null,null,"PLATINO: PPP+Sustitc. + R. Carnet",{"$f":"+J77+J90+J91","v":9.2464999999999995E-3},null,null,3616.6984789949997]
[48,"","","","","",null,null,"DORADO: Sustitc. + R.C.",{"$f":"+J90+J91","v":0},null,null,0]
[49,"","","","","",null,null,"PPP+Siniestro Total",{"$f":"+J77+J78","v":1.6518999999999999E-2},null,null,6461.2818011699992]
[50,"","","","","",null,null,"PPP+ST+Y",{"$f":"+J77+J78+J90","v":1.6518999999999999E-2},null,null,6461.2818011699992]
[51,"","","","","",null,null,"TITANIO: PPP+Y",{"$f":"+J77+J90","v":9.2464999999999995E-3},null,null,3616.6984789949997]
[52,"","","","","",null,null,"Desempleo",{"$f":"INDEX(SEG!$A$3:$I$122,MATCH($E$9,SEG!$A$3:$A$122,1),5)","v":4.6111399999999997E-2},null,null,18036.125046702]
[53,"","","","","",null,null,"Desemp+ST",{"$f":"+J84+J78","v":5.3383899999999998E-2},null,null,20880.708368877]
[54,"","","","","",null,null,"Desempleo+ST+Y",{"$f":"J84+J78+J90","v":5.3383899999999998E-2},null,null,20880.708368877]
[55,"","","","","",null,null,"Desempleo+Y",{"$f":"J84+J90","v":4.6111399999999997E-2},null,null,18036.125046702]
[56,"","","","","",null,null,"Vehic Sust+ST",{"$f":"+J90+J78","v":7.2725000000000003E-3},null,null,2844.5833221749999]
[57,"","","","","",null,null,"Sin Seguros",0,null,null,0]
[58,"","","","","",null,null,"Vehic Sustituc (Y)",{"$f":"IF(E9>23,INDEX(SEG!$A$3:$I$122,MATCH($E$9,SEG!$A$3:$A$122,1),6),0)","v":0},null,null,{"$f":"+J90*N42","v":0}]
[59,"","","","","",null,null,"Retirada Carnet",{"$f":"IF(E9>23,INDEX(SEG!$A$3:$I$122,MATCH($E$9,SEG!$A$3:$A$122,1),7),0)","v":0},null,null,{"$f":"+J91*N42","v":0}]
[60,"","","","","",null,null,"EG VN",{"$f":"IF($E$9>23,INDEX(SEG!$A$3:$I$122,MATCH($E$9,SEG!$A$3:$A$122,1),8),0)","v":0},null,null,{"$f":"+J92*$N$42","v":0}]
[61,"","","","","",null,null,"EG VO",{"$f":"IF($E$9>23,INDEX(SEG!$A$3:$I$122,MATCH($E$9,SEG!$A$3:$A$122,1),9),0)","v":0},null,null,0]
[62,"","","","","",null,null,"JADE VN (PPP+ EG VN)",{"$f":"J77+J92","v":9.2464999999999995E-3},null,null,3616.6984789949997]
[63,"","","","","",null,null,"JADE VO (PPP+EG VO)",{"$f":"J77+J93","v":9.2464999999999995E-3},null,null,3616.6984789949997]
[64,"","","","","",null,null,"Desempleo + PPP + EG VN",{"$f":"+J84+J92","v":4.6111399999999997E-2},null,null,18036.125046702]
[65,{"$f":"+IF(A97<($E$9+1),A97,\"\")","v":""},"","",{"$f":"+IF(B97=\"\",\"\",C97+D97)","v":""},"",null,null,"Desempleo + PPP + EG VO",{"$f":"J84+J93","v":4.6111399999999997E-2},null,null,18036.125046702]
[66,"","",{"$f":"+IF(B98=\"\",\"\",$C$9/12*$D$17)","v":""},"",{"$f":"+IF(B98<>\"\",F97-C98,\"\")","v":""}]
[67,"","","","",""]
[68,"","","","",""]
[69,"","","","",""]
[70,"","","","",""]
[71,"","","","",""]
[72,"","","","",""]
[73,"","","","",""]
[74,"","","","",""]
[75,"","","","",""]
[76,"","","","",""]
[77,"","","","",""]
[78,"","","","",""]
[79,"","","","",""]
[80,"",{"$f":"+IF(B112=\"\",\"\",IF($E$9=B112,(1-(($E$9-1)*$E$15))*$D$17,$E$15*$D$17))","v":""},"","",""]
[81,"","","","",""]
[82,"","","","",""]
[83,"","","","",""]
[84,"","","","",""]
[85,"","","","",""]
[86,"","","","",""]
[87,"","","","",""]
[88,"","","","",""]
[89,"","","","",""]
[90,"","","","",""]
[91,"","","","",""]
[92,"","","","",""]
[93,"","","","",""]
[94,"","","","",""]
[95,"","","","",""]
[96,"","","","",""]
[97,"","","","",""]
[98,"","","","",""]
[99,"","","","",""]
[100,"","","","",""]
[101,"","","","",""]
[102,"","","","",""]
[103,"","","","",""]
[104,"","","","",""]
[105,"","","","",""]
[106,"","","","",""]
[107,"","","","",""]
[108,"","","","",""]
[109,"","","","",""]
[110,"","","","",""]
[111,"","","","",""]
[112,"","","","",""]
[113,"","","","",""]
[114,"","","","",""]
[115,"","","","",""]
[116,"","","","",""]
[117,"","","","",""]
[118,"","","","",""]
[119,"","","","",""]
[120,"","","","",""]
[]
[null,null,"TAE",{"$f":"+IF(ISERROR((((1+((IRR($D$156:$D$276,0.0025)*12)/12))^12)-1)),\"\",(((1+((IRR($D$156:$D$276,0.0025)*12)/12))^12)-1))","v":1.9166334704505017E-2}]
[null,null,"tir",{"$f":"+IRR($D$156:$D$276,0.0025)*12","v":1.899999999999924E-2}]
[null,null,0,{"$f":"IF(M33=2,-D17+($N$44+$N$45),-D17)","v":-392120.28607500001}]
[null,null,1,{"$f":"+IF($E$9>(C157-1),$D$22,0)","v":49364.912486590416}]
[null,null,2,49364.912486590416]
[null,null,3,49364.912486590416]
[null,null,4,49364.912486590416]
[null,null,5,49364.912486590416]
[null,null,6,49364.912486590416]
[null,null,7,49364.912486590416]
[null,null,8,49364.912486590416]
[null,null,9,0]
[null,null,10,0]
[null,null,11,0]
[null,null,12,0]
[null,null,13,0]
[null,null,14,0]
[null,null,15,0]
[null,null,16,0]
[null,null,17,0]
[null,null,18,0]
[null,null,19,0]
[null,null,20,0]
[null,null,21,0]
[null,null,22,0]
[null,null,23,0]
[null,null,24,0]
[null,null,25,0]
[null,null,26,0]
[null,null,27,0]
[null,null,28,0]
[null,null,29,0]
[null,null,30,0]
[null,null,31,0]
[null,null,32,0]
[null,null,33,{"$f":"+IF($E$9>(C189-1),$D$22,0)","v":0}]
[null,null,34,0]
[null,null,35,0]
[null,null,36,0]
[null,null,37,0]
[null,null,38,0]
[null,null,39,0]
[null,null,40,0]
[null,null,41,0]
[null,null,42,0]
[null,null,43,0]
[null,null,44,0]
[null,null,45,0]
[null,null,46,0]
[null,null,47,0]
[null,null,48,0]
[null,null,49,0]
[null,null,50,0]
[null,null,51,0]
[null,null,52,0]
[null,null,53,0]
[null,null,54,0]
[null,null,55,0]
[null,null,56,0]
[null,null,57,0]
[null,null,58,0]
[null,null,59,0]
[null,null,60,0]
[null,null,61,0]
[null,null,62,0]
[null,null,63,0]
[null,null,64,0]
[null,null,65,{"$f":"+IF($E$9>(C221-1),$D$22,0)","v":0}]
[null,null,66,0]
[null,null,67,0]
[null,null,68,0]
[null,null,69,0]
[null,null,70,0]
[null,null,71,0]
[null,null,72,0]
[null,null,73,0]
[null,null,74,0]
[null,null,75,0]
[null,null,76,0]
[null,null,77,0]
[null,null,78,0]
[null,null,79,0]
[null,null,80,0]
[null,null,81,0]
[null,null,82,0]
[null,null,83,0]
[null,null,84,0]
[null,null,85,0]
[null,null,86,0]
[null,null,87,0]
[null,null,88,0]
[null,null,89,0]
[null,null,90,0]
[null,null,91,0]
[null,null,92,0]
[null,null,93,0]
[null,null,94,0]
[null,null,95,0]
[null,null,96,0]
[null,null,97,{"$f":"+IF($E$9>(C253-1),$D$22,0)","v":0}]
[null,null,98,0]
[null,null,99,0]
[null,null,100,0]
[null,null,101,0]
[null,null,102,0]
[null,null,103,0]
[null,null,104,0]
[null,null,105,0]
[null,null,106,0]
[null,null,107,0]
[null,null,108,0]
[null,null,109,0]
[null,null,110,0]
[null,null,111,0]
[null,null,112,0]
[null,null,113,0]
[null,null,114,0]
[null,null,115,0]
[null,null,116,0]
[null,null,117,0]
[null,null,118,0]
[null,null,119,0]
[null,null,120,0]

{"sheet":"DOBLE TIPO 4.0","index":11,"n_rows":172,"n_cols":14,"rows_kept":172,"cut":false,"hidden":true,"merged":[[3,3,3,7],[2,5,2,9],[4,3,4,7]]}
[null,null,"Consumer Finance",null,null,"Volver"]
[]
[]
[null,null,null,"Simulador de Cuotas Campaña 12.0"]
[null,null,null,"OFERTA 12.0 2514 V.O."]
[]
[null,null,null,"Importe Solicitado"]
[]
[null,null,null,"Plazo Total de la Operación",null,"meses"]
[]
[null,null,null,"TIN del Período 1",0,"Duración 1er Período",null,12,"meses"]
[]
[null,null,null,"TIN del Período 2",null,"Duración 2o Período",null,{"$f":"+IF(F48=\"\",\"\",F48-H11)","v":48},"meses"]
[]
[null,null,null,"Seguro (2)"]
[]
[null,null,null,"Com. Apert.",0.03]
[]
[null,null,null,"Importe Total Financiado",null,{"$f":"+IF(ISERROR(F44),\"\",F44)","v":150}]
[]
[null,null,null,{"$f":"+IF(H11=\"\",\"\",\"Cuotas de las 1 a la \"&H11)","v":"Cuotas de las 1 a la 12"},{"$f":"IF(E7=\"\",\"\",PMT(E11/12,F48,-F19,0,0))","v":""}]
[]
[null,null,null,{"$f":"+IF(H11=\"\",\"\",\"Cuotas de la \"&H11+1&\" a la \"&F48)","v":"Cuotas de la 13 a la 60"},{"$f":"IF(ISERROR(PMT(F47/12,H13,-F46,0,0)),\"\",PMT(F47/12,H13,-F46,0,0))","v":""}]
[null,null,null,"TAE",{"$f":"+E50","v":""}]
[]
[null,null,null,"Válido para VO"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO SEGURO"]
[]
[null,null,null,null,null,null,null,1,null,null,1,{"$f":"INDEX($M36:$M46,$K35,1)","v":0},{"$f":"+INDEX($M$36:$M$76,$K$35,1)","v":0}]
[null,null,null,null,"Min CAP",150,null,"Financiadas",null,null,"PPP",{"$f":"INDEX(SEG!$A$3:$F$122,$F$48,2)","v":5.3197399999999999E-2},{"$f":"+L36*$E$7","v":0},"Q"]
[null,null,null,null,null,null,null,"Al Contado",null,null,"Siniestro Total",{"$f":"INDEX(SEG!$A$3:$F$122,$F$48,3)","v":5.3407000000000003E-2},0,"D"]
[null,null,null,null,null,null,null,null,null,null,"PPP + ST",{"$f":"+L36+L37","v":0.1066044},0,"Q+D"]
[null,null,1,1,null,null,null,"Imprte Seguro",null,null,"Desemp./Incap.",{"$f":"INDEX(SEG!$A$3:$F$122,$F$48,4)","v":8.8791079999999994E-2},0,"T/X"]
[null,null,null,60,null,null,null,null,null,null,"Des/Inc + ST",{"$f":"L37+L39","v":0.14219808},0,"T/X + D"]
[null,null,9.9900000000000003E-2,72,"Principal",{"$f":"+E7","v":0},null,null,null,null,"Vehic.Sustit",{"$f":"INDEX(SEG!$A$3:$F$122,$F$48,6)","v":1.8839999999999982E-2},0,"Y"]
[null,null,null,84,"Seguro",{"$f":"+IF(F41=0,\"\",M35)","v":""},null,null,null,null,"TITANIO (PPP+Vehic.Sust)",0,{"$f":"+M41+M36","v":0},"Q+Y"]
[null,null,null,96,"CAP",{"$f":"+IF((SUM(F41:F42)*$E$17)<$F$36,$F$36,SUM(F41:F42)*$E$17)","v":150},null,null,null,null,"PPP+D+Vehic sust",0,{"$f":"+M36+M37+M41","v":0},"Q+D+Y"]
[null,null,null,108,"Financiado",{"$f":"+IF(H35=1,SUM(F41:F43),SUM(F41:F42))","v":150},null,null,null,null,"Desemp./Incap.+Vehic Sust",0,{"$f":"+M39+M41","v":0},"T/X+Y"]
[null,null,null,null,"Plazo",{"$f":"+IF(H13=\"\",\"\",H13)","v":48},null,null,null,null,"Desempl/Incap+Vehic Sust+ST",0,{"$f":"+M37+M39+M41","v":0},"T/X+D+Y"]
[null,null,null,null,"VR",{"$f":"FV(E11/12,H11,E21,-F44,0)","v":{"$error":"#VALUE!"}},null,null,null,null,"ST+Vehic Sust.",0,{"$f":"+M37+M41","v":0},"D+Y"]
[null,null,null,null,"tin plazo 2",{"$f":"+E13","v":0},null,null,null,null,"Retirada de Carnét",{"$f":"INDEX(SEG!$A$3:$G$122,$F$48,7)","v":1.7305000000000001E-2},{"$f":"+L47*$E$7","v":0}]
[null,null,null,null,"Plazo Total",{"$f":"+INDEX(D40:D43,D39,1)","v":60},null,null,null,null,"PLATINO (PPP+Sust+RC)",null,{"$f":"+M36+M41+M47","v":0}]
[null,null,null,null,null,null,null,{"$f":"+F44/D42","v":1.7857142857142858},null,null,"DORADO (Sust+ RC)",null,{"$f":"+M41+M47","v":0}]
[null,null,null,"TAE",{"$f":"+IF(ISERROR(((1+(E51/12))^12)-1),\"\",((1+(E51/12))^12)-1)","v":""},null,null,null,null,null,"EG-18 M (< 1600 CC) 2+2",null,{"$f":"+SEG!M2","v":0}]
[null,null,null,"TIR",{"$f":"+IRR(E52:E172,0.0025)*12","v":{"$error":"#NUM!"}},null,null,null,null,null,"EG-18 M (1601-2000 CC) 2+2",null,{"$f":"+SEG!M3","v":0}]
[null,null,null,0,{"$f":"+IF(H35=1,-F44,-F44+F43)","v":-150},null,null,null,null,null,"EG-18 M (2001-3200 CC) 2+2",null,{"$f":"+SEG!M4","v":0}]
[null,null,null,1,{"$f":"+IF(D53<($F$48-$F$45),$E$21,IF(D53<($F$48+1),$E$23,0))","v":""},null,null,null,null,null,"EG-18 M (< 1600 CC) 3+2",null,{"$f":"+SEG!M5","v":0}]
[null,null,null,2,{"$f":"+IF(D54<($F$48-$F$45),$E$21,IF(D54<($F$48+1),$E$23,0))","v":""},null,null,null,null,null,"EG-18 M (1601-2000 CC) 3+2",null,{"$f":"+SEG!M6","v":0}]
[null,null,null,3,"",null,null,null,null,null,"EG-18 M (2001-3200 CC) 3+2",null,{"$f":"+SEG!M7","v":0}]
[null,null,null,4,"",null,null,null,null,null,"EG +18 M (< 1600 CC) 1+1",null,{"$f":"+SEG!M8","v":0}]
[null,null,null,5,"",null,null,null,null,null,"EG +18 M (1601-2000 CC) 1+1",null,{"$f":"+SEG!M9","v":0}]
[null,null,null,6,"",null,null,null,null,null,"EG +18 M (2001-3200 CC) 1+1",null,{"$f":"+SEG!M10","v":0}]
[null,null,null,7,"",null,null,null,null,null,"PPP + EG-18 M (< 1600 CC) 2+2",null,{"$f":"+M50+$M$36","v":0}]
[null,null,null,8,"",null,null,null,null,null,"PPP + EG-18 M (1601-2000 CC) 2+2",null,{"$f":"+M51+$M$36","v":0}]
[null,null,null,9,"",null,null,null,null,null,"PPP + EG-18 M (2001-3200 CC) 2+2",null,0]
[null,null,null,10,"",null,null,null,null,null,"PPP + EG-18 M (< 1600 CC) 3+2",null,0]
[null,null,null,11,"",null,null,null,null,null,"PPP + EG-18 M (1601-2000 CC) 3+2",null,0]
[null,null,null,12,"",null,null,null,null,null,"PPP + EG-18 M (2001-3200 CC) 3+2",null,0]
[null,null,null,13,"",null,null,null,null,null,"PPP + EG +18 M (< 1600 CC) 1+1",null,0]
[null,null,null,14,"",null,null,null,null,null,"PPP + EG +18 M (1601-2000 CC) 1+1",null,0]
[null,null,null,15,"",null,null,null,null,null,"PPP + EG +18 M (2001-3200 CC) 1+1",null,0]
[null,null,null,16,"",null,null,null,null,null,"Desempleo + PPP + EG-18 M (< 1600 CC) 2+2",null,{"$f":"+M50+$M$39","v":0}]
[null,null,null,17,"",null,null,null,null,null,"Desempleo + PPP + EG-18 M (1601-2000 CC) 2+2",null,{"$f":"+M51+$M$39","v":0}]
[null,null,null,18,"",null,null,null,null,null,"Desempleo + PPP + EG-18 M (2001-3200 CC) 2+2",null,0]
[null,null,null,19,"",null,null,null,null,null,"Desempleo + PPP + EG-18 M (< 1600 CC) 3+2",null,0]
[null,null,null,20,"",null,null,null,null,null,"Desempleo + PPP + EG-18 M (1601-2000 CC) 3+2",null,0]
[null,null,null,21,"",null,null,null,null,null,"Desempleo + PPP + EG-18 M (2001-3200 CC) 3+2",null,0]
[null,null,null,22,"",null,null,null,null,null,"Desempleo + PPP + EG +18 M (< 1600 CC) 1+1",null,0]
[null,null,null,23,"",null,null,null,null,null,"Desempleo + PPP + EG +18 M (1601-2000 CC) 1+1",null,0]
[null,null,null,24,"",null,null,null,null,null,"Desempleo + PPP + EG +18 M (2001-3200 CC) 1+1",null,0]
[null,null,null,25,""]
[null,null,null,26,""]
[null,null,null,27,""]
[null,null,null,28,""]
[null,null,null,29,""]
[null,null,null,30,""]
[null,null,null,31,""]
[null,null,null,32,""]
[null,null,null,33,""]
[null,null,null,34,""]
[null,null,null,35,""]
[null,null,null,36,""]
[null,null,null,37,""]
[null,null,null,38,""]
[null,null,null,39,""]
[null,null,null,40,""]
[null,null,null,41,""]
[null,null,null,42,""]
[null,null,null,43,""]
[null,null,null,44,""]
[null,null,null,45,""]
[null,null,null,46,""]
[null,null,null,47,""]
[null,null,null,48,""]
[null,null,null,49,""]
[null,null,null,50,""]
[null,null,null,51,""]
[null,null,null,52,""]
[null,null,null,53,""]
[null,null,null,54,""]
[null,null,null,55,""]
[null,null,null,56,""]
[null,null,null,57,""]
[null,null,null,58,""]
[null,null,null,59,""]
[null,null,null,60,""]
[null,null,null,61,0]
[null,null,null,62,0]
[null,null,null,63,0]
[null,null,null,64,0]
[null,null,null,65,0]
[null,null,null,66,{"$f":"+IF(D118<($F$48-$F$45),$E$21,IF(D118<($F$48+1),$E$23,0))","v":0}]
[null,null,null,67,0]
[null,null,null,68,0]
[null,null,null,69,0]
[null,null,null,70,0]
[null,null,null,71,0]
[null,null,null,72,0]
[null,null,null,73,0]
[null,null,null,74,0]
[null,null,null,75,0]
[null,null,null,76,0]
[null,null,null,77,0]
[null,null,null,78,0]
[null,null,null,79,0]
[null,null,null,80,0]
[null,null,null,81,0]
[null,null,null,82,0]
[null,null,null,83,0]
[null,null,null,84,0]
[null,null,null,85,0]
[null,null,null,86,0]
[null,null,null,87,0]
[null,null,null,88,0]
[null,null,null,89,0]
[null,null,null,90,0]
[null,null,null,91,0]
[null,null,null,92,0]
[null,null,null,93,0]
[null,null,null,94,0]
[null,null,null,95,0]
[null,null,null,96,0]
[null,null,null,97,0]
[null,null,null,98,0]
[null,null,null,99,0]
[null,null,null,100,0]
[null,null,null,101,0]
[null,null,null,102,0]
[null,null,null,103,0]
[null,null,null,104,0]
[null,null,null,105,0]
[null,null,null,106,0]
[null,null,null,107,0]
[null,null,null,108,0]
[null,null,null,109,0]
[null,null,null,110,0]
[null,null,null,111,0]
[null,null,null,112,0]
[null,null,null,113,0]
[null,null,null,114,0]
[null,null,null,115,0]
[null,null,null,116,0]
[null,null,null,117,0]
[null,null,null,118,0]
[null,null,null,119,0]
[null,null,null,120,0]

{"sheet":"LEASING SELECCION","index":12,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":true,"merged":[[0,8,0,9],[2,2,2,9],[5,2,5,3],[5,6,5,7],[27,8,27,9],[27,10,27,11],[19,3,19,4],[7,2,7,3],[13,2,13,3],[15,2,15,3],[21,3,21,4],[21,10,21,11],[16,9,17,9],[17,2,17,3]]}
[null,null,"volver",null,null,null,null,null,"BBVA Finanzia"]
[]
[null,null,"SIMULADOR OPERACIONES DE LEASING SELECCIÓN"]
[]
[]
[null,null,"Precio del Bien",null,null,"Entrada"]
[]
[null,null,"Importe a Financiar",null,{"$f":"+E6-G6","v":0}]
[]
[null,null,"TIN"]
[]
[null,null,"Comisión de Apertura",null,null,"Comisión de Estudio"]
[]
[null,null,"Plazo Total "]
[]
[null,null,"VR Intermedio",null,null,"Momento"]
[]
[null,null,"VR Final",null,"1 Cuota","Momento",{"$f":"IF(E14<C20,\"Revise Plazo\",+E14)","v":0}]
[]
[null,null,{"$f":"+N45","v":0},"Cuotas Mensuales",null,{"$f":"IF(ISERROR(IF(E14<C20,\"Revise Datos\",IF(E6<0,\"Revise Datos\",+PMT(E10/12,C20,-E8,E16,1)))),\"\",IF(E14<C20,\"Revise Datos\",IF(E6<0,\"Revise Datos\",+PMT(E10/12,C20,-E8,E16,1))))","v":""},{"$f":"+IF(F20=\"\",\"\",IF(N45>=E14,\"Operación Inviable\",\"\"))","v":""}]
[]
[null,null,{"$f":"+E14-C20","v":0},{"$f":"+D20","v":"Cuotas Mensuales"},null,{"$f":"IF(E14=C20,\" \",IF(C22<0,\"Revise Datos\",IF(E16<0,\"Revise Datos\",+PMT(E10/12,C22+1,-E16,0,1))))","v":" "},{"$f":"+IF(F20>F22,\"Revise Datos: Amortizaciones Decrecientes\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PLAZO",null,{"$f":"+IF(E44=1,12,IF(E44=2,24,IF(E44=3,36,IF(E44=4,48,60))))","v":60}]
[null,null,null,null,5,null,null,null,null,"plazos intermedios",1,1]
[null,null,null,null,null,null,null,null,null,null,null,"Plazo VR",null,{"$f":"INDEX(J45:J49,K44,1)","v":0}]
[null,null,null,null,null,null,null,null,null,24,0.55000000000000004,"% VR",null,{"$f":"INDEX(K45:K49,K44,1)","v":0}]
[null,null,null,null,null,null,null,null,null,36,0.5]
[null,null,null,null,null,null,null,null,null,48,0.45]
[null,null,null,null,null,null,null,null,null,60,0.4]

{"sheet":"SEG","index":13,"n_rows":122,"n_cols":13,"rows_kept":122,"cut":false,"hidden":true,"merged":[]}
["Seguros","2021-04-01"]
["Plazo de la Financiación. Hasta (meses):","PPP","ST","VIDA+ IT","DESEMPLEO","SUSTITUCIÓN","RETIRADA CARNET","EG\nV0",null,"PPP-SENIOR(M)","EG-18 M (< 1600 CC) 2+2",null,0]
[1,4.9182000000000002E-3,1.3067E-3,4.1909660000000001E-2,4.1909660000000001E-2,3.1399999999999999E-4,3.4610000000000001E-3,257.51,null,1.01645E-2,"EG-18 M (1601-2000 CC) 2+2",null,0]
[2,4.9182000000000002E-3,2.1591000000000002E-3,4.1909660000000001E-2,4.1909660000000001E-2,6.2799999999999998E-4,3.4610000000000001E-3,257.51,null,1.01645E-2,"EG-18 M (2001-3200 CC) 2+2",null,0]
[3,4.9182000000000002E-3,3.0111000000000001E-3,4.1909660000000001E-2,4.1909660000000001E-2,9.4199999999999991E-4,3.4610000000000001E-3,257.51,null,1.01645E-2,"EG-18 M (< 1600 CC) 3+2",null,0]
[4,4.9182000000000002E-3,3.8635000000000002E-3,4.1909660000000001E-2,4.1909660000000001E-2,1.256E-3,3.4610000000000001E-3,257.51,null,1.01645E-2,"EG-18 M (1601-2000 CC) 3+2",null,0]
[5,4.9182000000000002E-3,4.7158E-3,4.1909660000000001E-2,4.1909660000000001E-2,1.57E-3,3.4610000000000001E-3,257.51,null,1.01645E-2,"EG-18 M (2001-3200 CC) 3+2",null,0]
[6,4.9182000000000002E-3,5.5678999999999998E-3,4.1909660000000001E-2,4.1909660000000001E-2,1.884E-3,3.4610000000000001E-3,257.51,null,1.01645E-2,"EG +18 M (< 1600 CC) 1+1",null,0]
[7,9.2464999999999995E-3,6.4202E-3,4.6111399999999997E-2,4.6111399999999997E-2,2.1979999999999999E-3,3.4610000000000001E-3,257.51,null,1.93417E-2,"EG +18 M (1601-2000 CC) 1+1",null,0]
[8,9.2464999999999995E-3,7.2725000000000003E-3,4.6111399999999997E-2,4.6111399999999997E-2,2.5119999999999999E-3,3.4610000000000001E-3,257.51,null,1.93417E-2,"EG +18 M (2001-3200 CC) 1+1",null,0]
[9,9.2464999999999995E-3,8.1245999999999992E-3,4.6111399999999997E-2,4.6111399999999997E-2,2.826E-3,3.4610000000000001E-3,257.51,null,1.93417E-2]
[10,9.2464999999999995E-3,8.9768999999999995E-3,4.6111399999999997E-2,4.6111399999999997E-2,3.14E-3,3.4610000000000001E-3,257.51,null,1.93417E-2]
[11,9.2464999999999995E-3,9.8292999999999991E-3,4.6111399999999997E-2,4.6111399999999997E-2,3.454E-3,3.4610000000000001E-3,257.51,null,1.93417E-2]
[12,9.2464999999999995E-3,1.0681400000000001E-2,4.6111399999999997E-2,4.6111399999999997E-2,3.7680000000000001E-3,3.4610000000000001E-3,257.51,null,1.93417E-2]
[13,1.38212E-2,1.19881E-2,5.0615630000000002E-2,5.0615630000000002E-2,4.0819999999999997E-3,6.9220000000000002E-3,257.51,null,2.9277999999999998E-2]
[14,1.38212E-2,1.2840499999999999E-2,5.0615630000000002E-2,5.0615630000000002E-2,4.3959999999999997E-3,6.9220000000000002E-3,257.51,null,2.9277999999999998E-2]
[15,1.38212E-2,1.3692599999999999E-2,5.0615630000000002E-2,5.0615630000000002E-2,4.7099999999999998E-3,6.9220000000000002E-3,257.51,null,2.9277999999999998E-2]
[16,1.38212E-2,1.45448E-2,5.0615630000000002E-2,5.0615630000000002E-2,5.0239999999999998E-3,6.9220000000000002E-3,257.51,null,2.9277999999999998E-2]
[17,1.38212E-2,1.53971E-2,5.0615630000000002E-2,5.0615630000000002E-2,5.3379999999999999E-3,6.9220000000000002E-3,257.51,null,2.9277999999999998E-2]
[18,1.38212E-2,1.6249400000000001E-2,5.0615630000000002E-2,5.0615630000000002E-2,5.6519999999999999E-3,6.9220000000000002E-3,257.51,null,2.9277999999999998E-2]
[19,1.8619699999999999E-2,1.7101600000000002E-2,5.5328620000000002E-2,5.5328620000000002E-2,5.9659999999999999E-3,6.9220000000000002E-3,257.51,null,3.99546E-2]
[20,1.8619699999999999E-2,1.7953899999999998E-2,5.5328620000000002E-2,5.5328620000000002E-2,6.28E-3,6.9220000000000002E-3,257.51,null,3.99546E-2]
[21,1.8619699999999999E-2,1.8806099999999999E-2,5.5328620000000002E-2,5.5328620000000002E-2,6.594E-3,6.9220000000000002E-3,257.51,null,3.99546E-2]
[22,1.8619699999999999E-2,1.96583E-2,5.5328620000000002E-2,5.5328620000000002E-2,6.9080000000000001E-3,6.9220000000000002E-3,257.51,null,3.99546E-2]
[23,1.8619699999999999E-2,2.05106E-2,5.5328620000000002E-2,5.5328620000000002E-2,7.2220000000000001E-3,6.9220000000000002E-3,257.51,null,3.99546E-2]
[24,1.8619699999999999E-2,2.1362800000000001E-2,5.5328620000000002E-2,5.5328620000000002E-2,7.5360000000000002E-3,6.9220000000000002E-3,257.51,null,3.99546E-2]
[25,2.3677299999999998E-2,2.2669499999999999E-2,6.0351009999999997E-2,6.0351009999999997E-2,7.8499999999999993E-3,1.0383E-2,257.51,null,5.1499299999999998E-2]
[26,2.3677299999999998E-2,2.3521899999999998E-2,6.0351009999999997E-2,6.0351009999999997E-2,8.1639999999999994E-3,1.0383E-2,257.51,null,5.1499299999999998E-2]
[27,2.3677299999999998E-2,2.4374E-2,6.0351009999999997E-2,6.0351009999999997E-2,8.4779999999999994E-3,1.0383E-2,257.51,null,5.1499299999999998E-2]
[28,2.3677299999999998E-2,2.5226200000000001E-2,6.0351009999999997E-2,6.0351009999999997E-2,8.7919999999999995E-3,1.0383E-2,257.51,null,5.1499299999999998E-2]
[29,2.3677299999999998E-2,2.60787E-2,6.0351009999999997E-2,6.0351009999999997E-2,9.1059999999999995E-3,1.0383E-2,257.51,null,5.1499299999999998E-2]
[30,2.3677299999999998E-2,2.6930599999999999E-2,6.0351009999999997E-2,6.0351009999999997E-2,9.4199999999999996E-3,1.0383E-2,257.51,null,5.1499299999999998E-2]
[31,2.8989399999999999E-2,2.7782899999999999E-2,6.5466499999999997E-2,6.5466499999999997E-2,9.7339999999999996E-3,1.0383E-2,257.51,null,6.3941499999999998E-2]
[32,2.8989399999999999E-2,2.8635399999999998E-2,6.5466499999999997E-2,6.5466499999999997E-2,1.0048E-2,1.0383E-2,257.51,null,6.3941499999999998E-2]
[33,2.8989399999999999E-2,2.94875E-2,6.5466499999999997E-2,6.5466499999999997E-2,1.0362E-2,1.0383E-2,257.51,null,6.3941499999999998E-2]
[34,2.8989399999999999E-2,3.0339700000000001E-2,6.5466499999999997E-2,6.5466499999999997E-2,1.0676E-2,1.0383E-2,257.51,null,6.3941499999999998E-2]
[35,2.8989399999999999E-2,3.1192000000000001E-2,6.5466499999999997E-2,6.5466499999999997E-2,1.099E-2,1.0383E-2,257.51,null,6.3941499999999998E-2]
[36,2.8989399999999999E-2,3.2044299999999998E-2,6.5466499999999997E-2,6.5466499999999997E-2,1.1304E-2,1.0383E-2,257.51,null,6.3941499999999998E-2]
[37,3.4586600000000002E-2,3.3350900000000003E-2,7.0891380000000004E-2,7.0891380000000004E-2,1.1618E-2,1.3844E-2,257.51,null,7.7415600000000001E-2]
[38,3.4586600000000002E-2,3.4203200000000003E-2,7.0891380000000004E-2,7.0891380000000004E-2,1.1932E-2,1.3844E-2,257.51,null,7.7415600000000001E-2]
[39,3.4586600000000002E-2,3.5055599999999999E-2,7.0891380000000004E-2,7.0891380000000004E-2,1.2246E-2,1.3844E-2,257.51,null,7.7415600000000001E-2]
[40,3.4586600000000002E-2,3.5907599999999998E-2,7.0891380000000004E-2,7.0891380000000004E-2,1.256E-2,1.3844E-2,257.51,null,7.7415600000000001E-2]
[41,3.4586600000000002E-2,3.6759899999999998E-2,7.0891380000000004E-2,7.0891380000000004E-2,1.2874E-2,1.3844E-2,257.51,null,7.7415600000000001E-2]
[42,3.4586600000000002E-2,3.7612300000000001E-2,7.0891380000000004E-2,7.0891380000000004E-2,1.3188E-2,1.3844E-2,257.51,null,7.7415600000000001E-2]
[43,4.0470800000000001E-2,3.8464400000000003E-2,7.6517520000000006E-2,7.6517520000000006E-2,1.3502E-2,1.3844E-2,257.51,null,9.1980000000000006E-2]
[44,4.0470800000000001E-2,3.9316799999999999E-2,7.6517520000000006E-2,7.6517520000000006E-2,1.3816E-2,1.3844E-2,257.51,null,9.1980000000000006E-2]
[45,4.0470800000000001E-2,4.0168700000000002E-2,7.6517520000000006E-2,7.6517520000000006E-2,1.413E-2,1.3844E-2,257.51,null,9.1980000000000006E-2]
[46,4.0470800000000001E-2,4.1021200000000001E-2,7.6517520000000006E-2,7.6517520000000006E-2,1.4444E-2,1.3844E-2,257.51,null,9.1980000000000006E-2]
[47,4.0470800000000001E-2,4.1873500000000001E-2,7.6517520000000006E-2,7.6517520000000006E-2,1.4758E-2,1.3844E-2,257.51,null,9.1980000000000006E-2]
[48,4.0470800000000001E-2,4.2725600000000002E-2,7.6517520000000006E-2,7.6517520000000006E-2,1.5072E-2,1.3844E-2,257.51,null,9.1980000000000006E-2]
[49,4.66723E-2,4.4032399999999999E-2,8.2553680000000004E-2,8.2553680000000004E-2,1.5386E-2,1.7305000000000001E-2,257.51,null,0.1077914]
[50,4.66723E-2,4.4884599999999997E-2,8.2553680000000004E-2,8.2553680000000004E-2,1.5699999999999999E-2,1.7305000000000001E-2,257.51,null,0.1077914]
[51,4.66723E-2,4.5736800000000001E-2,8.2553680000000004E-2,8.2553680000000004E-2,1.6013999999999997E-2,1.7305000000000001E-2,257.51,null,0.1077914]
[52,4.66723E-2,4.6588999999999998E-2,8.2553680000000004E-2,8.2553680000000004E-2,1.6327999999999995E-2,1.7305000000000001E-2,257.51,null,0.1077914]
[53,4.66723E-2,4.7441400000000002E-2,8.2553680000000004E-2,8.2553680000000004E-2,1.6641999999999994E-2,1.7305000000000001E-2,257.51,null,0.1077914]
[54,4.66723E-2,4.8293799999999998E-2,8.2553680000000004E-2,8.2553680000000004E-2,1.6955999999999992E-2,1.7305000000000001E-2,257.51,null,0.1077914]
[55,5.3197399999999999E-2,4.91457E-2,8.8791079999999994E-2,8.8791079999999994E-2,1.726999999999999E-2,1.7305000000000001E-2,257.51,null,0.1249397]
[56,5.3197399999999999E-2,4.9998099999999997E-2,8.8791079999999994E-2,8.8791079999999994E-2,1.7583999999999989E-2,1.7305000000000001E-2,257.51,null,0.1249397]
[57,5.3197399999999999E-2,5.0850300000000001E-2,8.8791079999999994E-2,8.8791079999999994E-2,1.7897999999999987E-2,1.7305000000000001E-2,257.51,null,0.1249397]
[58,5.3197399999999999E-2,5.1702400000000003E-2,8.8791079999999994E-2,8.8791079999999994E-2,1.8211999999999985E-2,1.7305000000000001E-2,257.51,null,0.1249397]
[59,5.3197399999999999E-2,5.2554900000000002E-2,8.8791079999999994E-2,8.8791079999999994E-2,1.8525999999999983E-2,1.7305000000000001E-2,257.51,null,0.1249397]
[60,5.3197399999999999E-2,5.3407000000000003E-2,8.8791079999999994E-2,8.8791079999999994E-2,1.8839999999999982E-2,1.7305000000000001E-2,257.51,null,0.1249397]
[61,5.1011000000000001E-2,5.4713600000000001E-2,9.026236E-2,9.026236E-2,1.915399999999998E-2,2.0766E-2,257.51,null,0.14361670000000001]
[62,5.1011000000000001E-2,5.55661E-2,9.026236E-2,9.026236E-2,1.9467999999999978E-2,2.0766E-2,257.51,null,0.14361670000000001]
[63,5.1011000000000001E-2,5.6418200000000002E-2,9.026236E-2,9.026236E-2,1.9781999999999977E-2,2.0766E-2,257.51,null,0.14361670000000001]
[64,5.1011000000000001E-2,5.7270500000000002E-2,9.026236E-2,9.026236E-2,2.0095999999999975E-2,2.0766E-2,257.51,null,0.14361670000000001]
[65,5.1011000000000001E-2,5.8122800000000002E-2,9.026236E-2,9.026236E-2,2.0409999999999973E-2,2.0766E-2,257.51,null,0.14361670000000001]
[66,5.1011000000000001E-2,5.8974800000000001E-2,9.026236E-2,9.026236E-2,2.0723999999999972E-2,2.0766E-2,257.51,null,0.14361670000000001]
[67,5.7136300000000001E-2,5.9827199999999997E-2,9.269194E-2,9.269194E-2,2.103799999999997E-2,2.0766E-2,257.51,null,0.16395290000000001]
[68,5.7136300000000001E-2,6.0679499999999997E-2,9.269194E-2,9.269194E-2,2.1351999999999968E-2,2.0766E-2,257.51,null,0.16395290000000001]
[69,5.7136300000000001E-2,6.1531700000000002E-2,9.269194E-2,9.269194E-2,2.1665999999999967E-2,2.0766E-2,257.51,null,0.16395290000000001]
[70,5.7136300000000001E-2,6.2383899999999999E-2,9.269194E-2,9.269194E-2,2.1979999999999965E-2,2.0766E-2,257.51,null,0.16395290000000001]
[71,5.7136300000000001E-2,6.3236299999999995E-2,9.269194E-2,9.269194E-2,2.2293999999999963E-2,2.0766E-2,257.51,null,0.16395290000000001]
[72,5.7136300000000001E-2,6.4088300000000001E-2,9.269194E-2,9.269194E-2,2.2607999999999961E-2,2.0766E-2,257.51,null,0.16395290000000001]
[73,6.35907E-2,6.5394999999999995E-2,9.5747840000000001E-2,9.5747840000000001E-2,2.292199999999996E-2,2.4226999999999999E-2,257.51,null,0.18619160000000001]
[74,6.35907E-2,6.6247399999999998E-2,9.5747840000000001E-2,9.5747840000000001E-2,2.3235999999999958E-2,2.4226999999999999E-2,257.51,null,0.18619160000000001]
[75,6.35907E-2,6.7099800000000001E-2,9.5747840000000001E-2,9.5747840000000001E-2,2.3549999999999956E-2,2.4226999999999999E-2,257.51,null,0.18619160000000001]
[76,6.35907E-2,6.7951899999999996E-2,9.5747840000000001E-2,9.5747840000000001E-2,2.3863999999999955E-2,2.4226999999999999E-2,257.51,null,0.18619160000000001]
[77,6.35907E-2,6.8804199999999996E-2,9.5747840000000001E-2,9.5747840000000001E-2,2.4177999999999953E-2,2.4226999999999999E-2,257.51,null,0.18619160000000001]
[78,6.35907E-2,6.9656399999999993E-2,9.5747840000000001E-2,9.5747840000000001E-2,2.4491999999999951E-2,2.4226999999999999E-2,257.51,null,0.18619160000000001]
[79,7.0384100000000005E-2,7.0508500000000002E-2,9.9538210000000002E-2,9.9538210000000002E-2,2.480599999999995E-2,2.4226999999999999E-2,257.51,null,0.2105195]
[80,7.0384100000000005E-2,7.1360900000000005E-2,9.9538210000000002E-2,9.9538210000000002E-2,2.5119999999999948E-2,2.4226999999999999E-2,257.51,null,0.2105195]
[81,7.0384100000000005E-2,7.2213299999999994E-2,9.9538210000000002E-2,9.9538210000000002E-2,2.5433999999999946E-2,2.4226999999999999E-2,257.51,null,0.2105195]
[82,7.0384100000000005E-2,7.30653E-2,9.9538210000000002E-2,9.9538210000000002E-2,2.5747999999999945E-2,2.4226999999999999E-2,257.51,null,0.2105195]
[83,7.0384100000000005E-2,7.3917499999999997E-2,9.9538210000000002E-2,9.9538210000000002E-2,2.6061999999999943E-2,2.4226999999999999E-2,257.51,null,0.2105195]
[84,7.0384100000000005E-2,7.4769799999999997E-2,9.9538210000000002E-2,9.9538210000000002E-2,2.6375999999999941E-2,2.4226999999999999E-2,257.51,null,0.2105195]
[85,7.1280800000000005E-2,7.6076599999999994E-2,0.1039549,0.1039549,2.6689999999999939E-2,2.7688000000000001E-2,257.51,null,0.2372544]
[86,7.1280800000000005E-2,7.6928899999999995E-2,0.1039549,0.1039549,2.7003999999999938E-2,2.7688000000000001E-2,257.51,null,0.2372544]
[87,7.1280800000000005E-2,7.7781000000000003E-2,0.1039549,0.1039549,2.7317999999999936E-2,2.7688000000000001E-2,257.51,null,0.2372544]
[88,7.1280800000000005E-2,7.86332E-2,0.1039549,0.1039549,2.7631999999999934E-2,2.7688000000000001E-2,257.51,null,0.2372544]
[89,7.1280800000000005E-2,7.9485600000000003E-2,0.1039549,0.1039549,2.7945999999999933E-2,2.7688000000000001E-2,257.51,null,0.2372544]
[90,7.1280800000000005E-2,8.0337800000000001E-2,0.1039549,0.1039549,2.8259999999999931E-2,2.7688000000000001E-2,257.51,null,0.2372544]
[91,7.8198000000000004E-2,8.1189999999999998E-2,0.10888977,0.10888977,2.8573999999999929E-2,2.7688000000000001E-2,257.51,null,0.26666469999999998]
[92,7.8198000000000004E-2,8.2042400000000001E-2,0.10888977,0.10888977,2.8887999999999928E-2,2.7688000000000001E-2,257.51,null,0.26666469999999998]
[93,7.8198000000000004E-2,8.2894300000000004E-2,0.10888977,0.10888977,2.9201999999999926E-2,2.7688000000000001E-2,257.51,null,0.26666469999999998]
[94,7.8198000000000004E-2,8.3746600000000004E-2,0.10888977,0.10888977,2.9515999999999924E-2,2.7688000000000001E-2,257.51,null,0.26666469999999998]
[95,7.8198000000000004E-2,8.4599099999999997E-2,0.10888977,0.10888977,2.9829999999999923E-2,2.7688000000000001E-2,257.51,null,0.26666469999999998]
[96,7.8198000000000004E-2,8.5451200000000005E-2,0.10888977,0.10888977,3.0143999999999921E-2,2.7688000000000001E-2,257.51,null,0.26666469999999998]
[97,8.54911E-2,8.6757899999999999E-2,0.11434281,0.11434281,3.0457999999999919E-2,3.1149E-2,257.51,null,0.29917840000000001]
[98,8.54911E-2,8.7610300000000002E-2,0.11434281,0.11434281,3.0771999999999917E-2,3.1149E-2,257.51,null,0.29917840000000001]
[99,8.54911E-2,8.8462499999999999E-2,0.11434281,0.11434281,3.1085999999999916E-2,3.1149E-2,257.51,null,0.29917840000000001]
[100,8.54911E-2,8.9314599999999994E-2,0.11434281,0.11434281,3.1399999999999914E-2,3.1149E-2,257.51,null,0.29917840000000001]
[101,8.54911E-2,9.0166899999999994E-2,0.11434281,0.11434281,3.1713999999999916E-2,3.1149E-2,257.51,null,0.29917840000000001]
[102,8.54911E-2,9.1019299999999997E-2,0.11434281,0.11434281,3.2027999999999918E-2,3.1149E-2,257.51,null,0.29917840000000001]
[103,9.3174499999999993E-2,9.1871400000000006E-2,0.12030649,0.12030649,3.2341999999999919E-2,3.1149E-2,257.51,null,0.33518720000000002]
[104,9.3174499999999993E-2,9.2723700000000006E-2,0.12030649,0.12030649,3.2655999999999921E-2,3.1149E-2,257.51,null,0.33518720000000002]
[105,9.3174499999999993E-2,9.3575900000000004E-2,0.12030649,0.12030649,3.2969999999999923E-2,3.1149E-2,257.51,null,0.33518720000000002]
[106,9.3174499999999993E-2,9.4427999999999998E-2,0.12030649,0.12030649,3.3283999999999925E-2,3.1149E-2,257.51,null,0.33518720000000002]
[107,9.3174499999999993E-2,9.5280500000000004E-2,0.12030649,0.12030649,3.3597999999999927E-2,3.1149E-2,257.51,null,0.33518720000000002]
[108,9.3174499999999993E-2,9.6132700000000001E-2,0.12030649,0.12030649,3.3911999999999928E-2,3.1149E-2,257.51,null,0.33518720000000002]
[109,0.1012817,9.7439499999999998E-2,0.12678834999999999,0.12678834999999999,3.422599999999993E-2,3.4610000000000002E-2,257.51,null,0.37528669999999997]
[110,0.1012817,9.8291699999999996E-2,0.12678834999999999,0.12678834999999999,3.4539999999999932E-2,3.4610000000000002E-2,257.51,null,0.37528669999999997]
[111,0.1012817,9.9143899999999993E-2,0.12678834999999999,0.12678834999999999,3.4853999999999934E-2,3.4610000000000002E-2,257.51,null,0.37528669999999997]
[112,0.1012817,9.9996100000000004E-2,0.12678834999999999,0.12678834999999999,3.5167999999999935E-2,3.4610000000000002E-2,257.51,null,0.37528669999999997]
[113,0.1012817,0.10084849999999999,0.12678834999999999,0.12678834999999999,3.5481999999999937E-2,3.4610000000000002E-2,257.51,null,0.37528669999999997]
[114,0.1012817,0.1017005,0.12678834999999999,0.12678834999999999,3.5795999999999939E-2,3.4610000000000002E-2,257.51,null,0.37528669999999997]
[115,0.10983080000000001,0.1025527,0.13368023000000001,0.13368023000000001,3.6109999999999941E-2,3.4610000000000002E-2,257.51,null,0.42006329999999997]
[116,0.10983080000000001,0.1034051,0.13368023000000001,0.13368023000000001,3.6423999999999943E-2,3.4610000000000002E-2,257.51,null,0.42006329999999997]
[117,0.10983080000000001,0.1042574,0.13368023000000001,0.13368023000000001,3.6737999999999944E-2,3.4610000000000002E-2,257.51,null,0.42006329999999997]
[118,0.10983080000000001,0.1051096,0.13368023000000001,0.13368023000000001,3.7051999999999946E-2,3.4610000000000002E-2,257.51,null,0.42006329999999997]
[119,0.10983080000000001,0.1059619,0.13368023000000001,0.13368023000000001,3.7365999999999948E-2,3.4610000000000002E-2,257.51,null,0.42006329999999997]
[120,0.10983080000000001,0.1068141,0.13368023000000001,0.13368023000000001,3.767999999999995E-2,3.4610000000000002E-2,257.51,null,0.42006329999999997]