{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Vista Principal","Proceso Prima de Seguro","TarifarioBD","CostoCapBD"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vista Principal","index":0,"n_rows":398,"n_cols":21,"rows_kept":398,"cut":false,"hidden":false,"merged":[[397,1,401,12],[1,1,3,12]]}
[]
[null,"Simulador Préstamo Personal Libre Disponibilidad"]
[]
[]
[]
[]
[null,"1) Establecer los datos del préstamos"]
[]
[null,"Producto",null,null,"Préstamos Personales (LD )"]
[null,"Tipo de Seguro",null,null,"Seguro de Desgravamen"]
[null,"Tarifa",null,null,"TARIFA TITULAR"]
[null,"MAF Inicial",null,null,16000]
[null,"Seguro Desempleo",null,null,0]
[null,"Monto adicional desempleo",null,null,{"$f":"E13*E12","v":0}]
[null,"Prima de Seguro de Desgravamen/Vida",null,null,{"$f":"IF(E10=\"Seguro de vida\",'Proceso Prima de Seguro'!C13,'Proceso Prima de Seguro'!G16)","v":0.12751337792535133}]
[null,"Monto del Seguro (Prima única S/)",null,null,{"$f":"+E15*E12","v":2040.2140468056214}]
[null,"MAF Final",null,null,{"$f":"E12+E14+E16","v":18040.21404680562}]
[null,"Empleado",null,null,{"$f":"IF(OR(E9=\"Préstamos Personales (LD Y PA) (Empleados)\",E9 = \"Préstamos Vehiculares (Empleados)\"),\"SI\",\"NO\")","v":"NO"}]
[null,"Moneda",null,null,"Soles"]
[null,"Plazo ",null,null,24]
[null,"Fecha de Desembolso",null,null,{"$f":"TODAY()+2","v":"2022-08-20"},null,null,{"$f":"E22-E21","v":57},"Días de Periodo de Gracia"]
[null,"Fecha de 1er Pago",null,null,"2022-10-16",null,null,null,{"$f":"IF((DAY(E36)=29)*1+(DAY(E36)=30)*1+(DAY(E36)=31)*1,\" ALERTA: Primera fecha de vencimiento no puede ser 29, 30 o 31, elegir otro periodo de gracia\",IF(H21<40,\" ALERTA: Fecha de 1er Pago de cuota debe ser entre 40 y 60 días.\",IF(H21>60,\" ALERTA: Fecha de 1er Pago de cuota debe ser entre 40 y 60 días.\",\"\")))","v":""}]
[null,"Cuota Julio",null,null,1]
[null,"Cuota Diciembre",null,null,1]
[null,"TEA",null,null,0.39,null,null,{"$f":"SUM(J36:J395)","v":7662.2355377644481},"Total Intereses"]
[null,"TEA TOTAL",null,null,{"$f":"+E25","v":0.39}]
[null,"Monto del Bien",null,null,0]
[null,"Seguro del Bien",null,null,0]
[null,"Portes",null,null,0]
[null,"Cuota",null,null,{"$f":"(E17+(E28*E27+E29)*P34)/O34","v":1070.9353993570871}]
[null,"2) Calcular TCEA presionando el botón "]
[null,"TCEA",0.56739791381500349,null,{"$f":"C32","v":0.56739791381500349}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E17-U34-E14-E16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O36:O395)","v":16.845286893715226},{"$f":"SUM(P36:P395)","v":16.845286893715226},null,null,null,null,{"$f":"SUM(U36:U395)","v":15999.999999999998}]
[null,"N° Cuota","Fecha de pago","Día","Fecha de pago","Días","Dias Acumulados","Saldo Inicial","Amortización","Interés","Seguro del Bien","Portes","Cuota Constante","Saldo Final","Factor Cronograma","Factor Cronograma 2",null,"Vector i,1\nCuota","Vector i,2\nDías Acum","Vector i,3 Factor","Vector i,4\nCalculo VA"]
[null,1,{"$f":"E22","v":"2022-10-16"},{"$f":"IF(B36<=$E$20,WEEKDAY(C36,2),\"\")","v":7},{"$f":"IF(D36=7,C36+1,C36)","v":"2022-10-17"},{"$f":"E36-E21","v":58},{"$f":"F36","v":58},{"$f":"E17","v":18040.21404680562},{"$f":"IF(B36>E$20,\"\",M36-L36-K36-J36)","v":87.976357085337668},{"$f":"IF(B36>E$20,\"\",((1+E$25)^(F36/360)-1)*H36)","v":982.95904227174947},{"$f":"IF(B36>E$20,\"\",E$27*E$28)","v":0},{"$f":"IF(B36>E$20,\"\",E$29)","v":0},{"$f":"IF(B36>E$20,\"\",IF(B36=E$20,H36+J36+K36+L36,IF(AND(E$23=2,MONTH(E36)=7),2*E$30,IF(AND(E$24=2,MONTH(E36)=12),2*E$30,E$30))))","v":1070.9353993570871},{"$f":"IF(B36>E$20,\"\",H36-I36)","v":17952.237689720281},{"$f":"IFERROR(IF(AND(MONTH(E36)=7,E$23=2),2/(1+E$26)^(G36/360),IF(AND(MONTH(E36)=12,E$24=2),2/(1+E$26)^(G36/360),1/(1+E$26)^(G36/360))),\"\")","v":0.94832833420223994},{"$f":"IFERROR(1/(1+E$26)^(G36/360),\"\")","v":0.94832833420223994},null,{"$f":"IFERROR(I36+J36+K36+L36,\"\")","v":1070.9353993570871},{"$f":"G36","v":58},{"$f":"IFERROR((1+C$32)^(S36/360),\"\")","v":1.07509179691831},{"$f":"IFERROR(ROUND(R36/T36,2),\"\")","v":996.13}]
[null,2,{"$f":"IF(B37>$E$20,\"\",EDATE(C36,1))","v":"2022-11-16"},3,{"$f":"IF(D37=7,C37+1,C37)","v":"2022-11-16"},{"$f":"IF(B37>E$20,\"\",E37-E36)","v":30},{"$f":"IFERROR(F37+G36,\"\")","v":88},{"$f":"IF(B37>E$20,\"\",N36)","v":17952.237689720281},571.46863649973227,499.46676285735487,0,0,1070.9353993570871,17380.769053220549,0.92265815915541738,0.92265815915541738,null,{"$f":"IFERROR(I37+J37+K37+L37,\"\")","v":1070.9353993570871},88,1.1161189628386221,959.52]
[null,3,"2022-12-16",5,"2022-12-16",30,118,17380.769053220549,587.3680243576855,483.56737499940169,0,0,1070.9353993570871,16793.401028862863,0.89768284670329823,0.89768284670329823,null,1070.9353993570871,118,1.1587117888711942,924.25]
[null,4,"2023-01-16",1,"2023-01-16",31,149,16793.401028862863,587.91368270132671,483.02171665576049,0,0,1070.9353993570871,16205.487346161537,0.87258504051888264,0.87258504051888264,null,1070.9353993570871,149,1.2044326747710232,889.16]
[null,5,"2023-02-16",4,"2023-02-16",31,180,16205.487346161537,604.82360319782026,466.11179615926687,0,0,1070.9353993570871,15600.663742963718,0.84818892967997084,0.84818892967997084,null,1070.9353993570871,180,1.2519576325958492,855.41]
[null,6,"2023-03-16",4,"2023-03-16",28,208,15600.663742963718,666.20219385525479,404.73320550183234,0,0,1070.9353993570871,14934.461549108462,0.82674052540197174,0.82674052540197174,null,1070.9353993570871,208,1.296493195152868,826.02]
[null,7,"2023-04-16",7,"2023-04-17",32,240,14934.461549108462,627.32120174037141,443.61419761671573,0,0,1070.9353993570871,14307.140347368091,0.802891388432314,0.802891388432314,null,1070.9353993570871,240,1.3493341426418759,793.68]
[null,8,"2023-05-16",2,"2023-05-16",29,269,14307.140347368091,686.32762457293597,384.6077747841511,0,0,1070.9353993570871,13620.812722795155,0.78187290460514436,0.78187290460514436,null,1070.9353993570871,269,1.3990791473419126,765.46]
[null,9,"2023-06-16",5,"2023-06-16",31,300,13620.812722795155,679.16554092855688,391.76985842853026,0,0,1070.9353993570871,12941.647181866598,0.76001296298690824,0.76001296298690824,null,1070.9353993570871,300,1.4542845389456056,736.4]
[null,10,"2023-07-16",7,"2023-07-17",31,331,12941.647181866598,698.7001012543019,372.23529810278524,0,0,1070.9353993570871,12242.947080612295,0.73876419109298175,0.73876419109298175,null,1070.9353993570871,331,1.5116682456702888,708.45]
[null,11,"2023-08-16",3,"2023-08-16",30,361,12242.947080612295,730.31239447737596,340.62300487971117,0,0,1070.9353993570871,11512.634686134919,0.71876668029453639,0.71876668029453639,null,1070.9353993570871,361,1.5693558441705819,682.4]
[null,12,"2023-09-16",6,"2023-09-16",31,392,11512.634686134919,739.80220246801809,331.13319688906904,0,0,1070.9353993570871,10772.832483666902,0.69867108985288173,0.69867108985288173,null,1070.9353993570871,392,1.631280077769218,656.5]
[null,13,"2023-10-16",1,"2023-10-16",30,422,10772.832483666902,771.21389051684275,299.72150884024438,0,0,1070.9353993570871,10001.618593150059,0.67975885394276814,0.67975885394276814,null,1070.9353993570871,422,1.6935322487977564,632.37]
[null,14,"2023-11-16",4,"2023-11-16",31,453,10001.618593150059,783.26293956788413,287.67245978920306,0,0,1070.9353993570871,9218.3556535821735,0.66075386122061697,0.66075386122061697,null,1070.9353993570871,453,1.7603562817096807,608.36]
[null,15,"2023-12-16",6,"2023-12-16",30,483,9218.3556535821735,814.46251075451733,256.47288860256975,0,0,1070.9353993570871,8403.8931428276555,0.64286800178917258,0.64286800178917258,null,1070.9353993570871,483,1.8275342003354094,586]
[null,16,"2024-01-16",2,"2024-01-16",31,514,8403.8931428276555,829.21766240413035,241.71773695295684,0,0,1070.9353993570871,7574.6754804235252,0.62489441950415869,0.62489441950415869,null,1070.9353993570871,514,1.8996457326889131,563.76]
[null,17,"2024-02-16",5,"2024-02-16",31,545,7574.6754804235252,853.0681104513917,217.86728890569543,0,0,1070.9353993570871,6721.6073699721337,0.60742335042443285,0.60742335042443285,null,1070.9353993570871,545,1.9746026690285172,542.35]
[null,18,"2024-03-16",6,"2024-03-16",29,574,6721.6073699721337,890.24363351351678,180.69176584357032,0,0,1070.9353993570871,5831.3637364586166,0.59152192458890396,0.59152192458890396,null,1070.9353993570871,574,2.0473990327662714,523.07000000000005]
[null,19,"2024-04-16",2,"2024-04-16",31,605,5831.3637364586166,903.21027223201202,167.72512712507509,0,0,1070.9353993570871,4928.1534642266042,0.57498389818939566,0.57498389818939566,null,1070.9353993570871,605,2.1281860744340881,503.22]
[null,20,"2024-05-16",4,"2024-05-16",30,635,4928.1534642266042,933.82442187426432,137.11097748282285,0,0,1070.9353993570871,3994.3290423523399,0.55941973461513894,0.55941973461513894,null,1070.9353993570871,635,2.2094009469085911,484.72]
[null,21,"2024-06-16",7,"2024-06-17",32,667,3994.3290423523399,952.28759492746872,118.64780442961847,0,0,1070.9353993570871,3042.041447424871,0.54328204997958884,0.54328204997958884,null,1070.9353993570871,667,2.2994491167364286,465.74]
[null,22,"2024-07-16",2,"2024-07-16",29,696,3042.041447424871,989.15855482431743,81.776844532769744,0,0,1070.9353993570871,2052.8828926005535,0.52905974650790299,0.52905974650790299,null,1070.9353993570871,696,2.3842213784799808,449.18]
[null,23,"2024-08-16",5,"2024-08-16",31,727,2052.8828926005535,1011.8891694020638,59.046229955023357,0,0,1070.9353993570871,1040.9937231984898,0.51426806476128695,0.51426806476128695,null,1070.9353993570871,727,2.4782988830435717,432.13]
[null,24,"2024-09-16",1,"2024-09-16",31,758,1040.9937231984898,1040.9937231984898,29.941676158569877,0,0,1070.9353993570596,0,0.49988993526531439,0.49988993526531439,null,1070.9353993570596,758,2.5760885331926353,415.72]
[null,25,"","","","","","","","","","","","","","",null,"","","",""]
[null,26,"","","","","","","","","","","","","","",null,"","","",""]
[null,27,"","","","","","","","","","","","","","",null,"","","",""]
[null,28,"","","","","","","","","","","","","","",null,"","","",""]
[null,29,"","","","","","","","","","","","","","",null,"","","",""]
[null,30,"","","","","","","","","","","","","","",null,"","","",""]
[null,31,"","","","","","","","","","","","","","",null,"","","",""]
[null,32,"","","","","","","","","","","","","","",null,"","","",""]
[null,33,"","","","","","","","","","","","","","",null,"","","",""]
[null,34,"","","","","","","","","","","","","","",null,"","","",""]
[null,35,"","","","","","","","","","","","","","",null,"","","",""]
[null,36,"","","","","","","","","","","","","","",null,"","","",""]
[null,37,"","","","","","","","","","","","","","",null,"","","",""]
[null,38,"","","","","","","","","","","","","","",null,"","","",""]
[null,39,"","","","","","","","","","","","","","",null,"","","",""]
[null,40,"","","","","","","","","","","","","","",null,"","","",""]
[null,41,"","","","","","","","","","","","","","",null,"","","",""]
[null,42,"","","","","","","","","","","","","","",null,"","","",""]
[null,43,"","","","","","","","","","","","","","",null,"","","",""]
[null,44,"","","","","","","","","","","","","","",null,"","","",""]
[null,45,"","","","","","","","","","","","","","",null,"","","",""]
[null,46,"","","","","","","","","","","","","","",null,"","","",""]
[null,47,"","","","","","","","","","","","","","",null,"","","",""]
[null,48,"","","","","","","","","","","","","","",null,"","","",""]
[null,49,"","","","","","","","","","","","","","",null,"","","",""]
[null,50,"","","","","","","","","","","","","","",null,"","","",""]
[null,51,"","","","","","","","","","","","","","",null,"","","",""]
[null,52,"","","","","","","","","","","","","","",null,"","","",""]
[null,53,"","","","","","","","","","","","","","",null,"","","",""]
[null,54,"","","","","","","","","","","","","","",null,"","","",""]
[null,55,"","","","","","","","","","","","","","",null,"","","",""]
[null,56,"","","","","","","","","","","","","","",null,"","","",""]
[null,57,"","","","","","","","","","","","","","",null,"","","",""]
[null,58,"","","","","","","","","","","","","","",null,"","","",""]
[null,59,"","","","","","","","","","","","","","",null,"","","",""]
[null,60,"","","","","","","","","","","","","","",null,"","","",""]
[null,61,"","","","","","","","","","","","","","",null,"","","",""]
[null,62,"","","","","","","","","","","","","","",null,"","","",""]
[null,63,"","","","","","","","","","","","","","",null,"","","",""]
[null,64,"","","","","","","","","","","","","","",null,"","","",""]
[null,65,"",{"$f":"IF(B100<=$E$20,WEEKDAY(C100,2),\"\")","v":""},"","","","",{"$f":"IF(B100>E$20,\"\",M100-L100-K100-J100)","v":""},{"$f":"IF(B100>E$20,\"\",((1+E$25)^(F100/360)-1)*H100)","v":""},{"$f":"IF(B100>E$20,\"\",E$27*E$28)","v":""},{"$f":"IF(B100>E$20,\"\",E$29)","v":""},{"$f":"IF(B100>E$20,\"\",IF(B100=E$20,H100+J100+K100+L100,IF(AND(E$23=2,MONTH(E100)=7),2*E$30,IF(AND(E$24=2,MONTH(E100)=12),2*E$30,E$30))))","v":""},{"$f":"IF(B100>E$20,\"\",H100-I100)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E100)=7,E$23=2),2/(1+E$26)^(G100/360),IF(AND(MONTH(E100)=12,E$24=2),2/(1+E$26)^(G100/360),1/(1+E$26)^(G100/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+E$26)^(G100/360),\"\")","v":""},null,"",{"$f":"G100","v":""},{"$f":"IFERROR((1+C$32)^(S100/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R100/T100,2),\"\")","v":""}]
[null,66,{"$f":"IF(B101>$E$20,\"\",EDATE(C100,1))","v":""},"",{"$f":"IF(D101=7,C101+1,C101)","v":""},{"$f":"IF(B101>E$20,\"\",E101-E100)","v":""},{"$f":"IFERROR(F101+G100,\"\")","v":""},{"$f":"IF(B101>E$20,\"\",N100)","v":""},"","","","","","","","",null,{"$f":"IFERROR(I101+J101+K101+L101,\"\")","v":""},"","",""]
[null,67,"","","","","","","","","","","","","","",null,"","","",""]
[null,68,"","","","","","","","","","","","","","",null,"","","",""]
[null,69,"","","","","","","","","","","","","","",null,"","","",""]
[null,70,"","","","","","","","","","","","","","",null,"","","",""]
[null,71,"","","","","","","","","","","","","","",null,"","","",""]
[null,72,"","","","","","","","","","","","","","",null,"","","",""]
[null,73,"","","","","","","","","","","","","","",null,"","","",""]
[null,74,"","","","","","","","","","","","","","",null,"","","",""]
[null,75,"","","","","","","","","","","","","","",null,"","","",""]
[null,76,"","","","","","","","","","","","","","",null,"","","",""]
[null,77,"","","","","","","","","","","","","","",null,"","","",""]
[null,78,"","","","","","","","","","","","","","",null,"","","",""]
[null,79,"","","","","","","","","","","","","","",null,"","","",""]
[null,80,"","","","","","","","","","","","","","",null,"","","",""]
[null,81,"","","","","","","","","","","","","","",null,"","","",""]
[null,82,"","","","","","","","","","","","","","",null,"","","",""]
[null,83,"","","","","","","","","","","","","","",null,"","","",""]
[null,84,"","","","","","","","","","","","","","",null,"","","",""]
[null,85,"","","","","","","","","","","","","","",null,"","","",""]
[null,86,"","","","","","","","","","","","","","",null,"","","",""]
[null,87,"","","","","","","","","","","","","","",null,"","","",""]
[null,88,"","","","","","","","","","","","","","",null,"","","",""]
[null,89,"","","","","","","","","","","","","","",null,"","","",""]
[null,90,"","","","","","","","","","","","","","",null,"","","",""]
[null,91,"","","","","","","","","","","","","","",null,"","","",""]
[null,92,"","","","","","","","","","","","","","",null,"","","",""]
[null,93,"","","","","","","","","","","","","","",null,"","","",""]
[null,94,"","","","","","","","","","","","","","",null,"","","",""]
[null,95,"","","","","","","","","","","","","","",null,"","","",""]
[null,96,"","","","","","","","","","","","","","",null,"","","",""]
[null,97,"","","","","","","","","","","","","","",null,"","","",""]
[null,98,"","","","","","","","","","","","","","",null,"","","",""]
[null,99,"","","","","","","","","","","","","","",null,"","","",""]
[null,100,"","","","","","","","","","","","","","",null,"","","",""]
[null,101,"","","","","","","","","","","","","","",null,"","","",""]
[null,102,"","","","","","","","","","","","","","",null,"","","",""]
[null,103,"","","","","","","","","","","","","","",null,"","","",""]
[null,104,"","","","","","","","","","","","","","",null,"","","",""]
[null,105,"","","","","","","","","","","","","","",null,"","","",""]
[null,106,"","","","","","","","","","","","","","",null,"","","",""]
[null,107,"","","","","","","","","","","","","","",null,"","","",""]
[null,108,"","","","","","","","","","","","","","",null,"","","",""]
[null,109,"","","","","","","","","","","","","","",null,"","","",""]
[null,110,"","","","","","","","","","","","","","",null,"","","",""]
[null,111,"","","","","","","","","","","","","","",null,"","","",""]
[null,112,"","","","","","","","","","","","","","",null,"","","",""]
[null,113,"","","","","","","","","","","","","","",null,"","","",""]
[null,114,"","","","","","","","","","","","","","",null,"","","",""]
[null,115,"","","","","","","","","","","","","","",null,"","","",""]
[null,116,"","","","","","","","","","","","","","",null,"","","",""]
[null,117,"","","","","","","","","","","","","","",null,"","","",""]
[null,118,"","","","","","","","","","","","","","",null,"","","",""]
[null,119,"","","","","","","","","","","","","","",null,"","","",""]
[null,120,"","","","","","","","","","","","","","",null,"","","",""]
[null,121,"","","","","","","","","","","","","","",null,"","","",""]
[null,122,"","","","","","","","","","","","","","",null,"","","",""]
[null,123,"","","","","","","","","","","","","","",null,"","","",""]
[null,124,"","","","","","","","","","","","","","",null,"","","",""]
[null,125,"","","","","","","","","","","","","","",null,"","","",""]
[null,126,"","","","","","","","","","","","","","",null,"","","",""]
[null,127,"","","","","","","","","","","","","","",null,"","","",""]
[null,128,"","","","","","","","","","","","","","",null,"","","",""]
[null,129,"",{"$f":"IF(B164<=$E$20,WEEKDAY(C164,2),\"\")","v":""},"","","","",{"$f":"IF(B164>E$20,\"\",M164-L164-K164-J164)","v":""},{"$f":"IF(B164>E$20,\"\",((1+E$25)^(F164/360)-1)*H164)","v":""},{"$f":"IF(B164>E$20,\"\",E$27*E$28)","v":""},{"$f":"IF(B164>E$20,\"\",E$29)","v":""},{"$f":"IF(B164>E$20,\"\",IF(B164=E$20,H164+J164+K164+L164,IF(AND(E$23=2,MONTH(E164)=7),2*E$30,IF(AND(E$24=2,MONTH(E164)=12),2*E$30,E$30))))","v":""},{"$f":"IF(B164>E$20,\"\",H164-I164)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E164)=7,E$23=2),2/(1+E$26)^(G164/360),IF(AND(MONTH(E164)=12,E$24=2),2/(1+E$26)^(G164/360),1/(1+E$26)^(G164/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+E$26)^(G164/360),\"\")","v":""},null,"",{"$f":"G164","v":""},{"$f":"IFERROR((1+C$32)^(S164/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R164/T164,2),\"\")","v":""}]
[null,130,{"$f":"IF(B165>$E$20,\"\",EDATE(C164,1))","v":""},"",{"$f":"IF(D165=7,C165+1,C165)","v":""},{"$f":"IF(B165>E$20,\"\",E165-E164)","v":""},{"$f":"IFERROR(F165+G164,\"\")","v":""},{"$f":"IF(B165>E$20,\"\",N164)","v":""},"","","","","","","","",null,{"$f":"IFERROR(I165+J165+K165+L165,\"\")","v":""},"","",""]
[null,131,"","","","","","","","","","","","","","",null,"","","",""]
[null,132,"","","","","","","","","","","","","","",null,"","","",""]
[null,133,"","","","","","","","","","","","","","",null,"","","",""]
[null,134,"","","","","","","","","","","","","","",null,"","","",""]
[null,135,"","","","","","","","","","","","","","",null,"","","",""]
[null,136,"","","","","","","","","","","","","","",null,"","","",""]
[null,137,"","","","","","","","","","","","","","",null,"","","",""]
[null,138,"","","","","","","","","","","","","","",null,"","","",""]
[null,139,"","","","","","","","","","","","","","",null,"","","",""]
[null,140,"","","","","","","","","","","","","","",null,"","","",""]
[null,141,"","","","","","","","","","","","","","",null,"","","",""]
[null,142,"","","","","","","","","","","","","","",null,"","","",""]
[null,143,"","","","","","","","","","","","","","",null,"","","",""]
[null,144,"","","","","","","","","","","","","","",null,"","","",""]
[null,145,"","","","","","","","","","","","","","",null,"","","",""]
[null,146,"","","","","","","","","","","","","","",null,"","","",""]
[null,147,"","","","","","","","","","","","","","",null,"","","",""]
[null,148,"","","","","","","","","","","","","","",null,"","","",""]
[null,149,"","","","","","","","","","","","","","",null,"","","",""]
[null,150,"","","","","","","","","","","","","","",null,"","","",""]
[null,151,"","","","","","","","","","","","","","",null,"","","",""]
[null,152,"","","","","","","","","","","","","","",null,"","","",""]
[null,153,"","","","","","","","","","","","","","",null,"","","",""]
[null,154,"","","","","","","","","","","","","","",null,"","","",""]
[null,155,"","","","","","","","","","","","","","",null,"","","",""]
[null,156,"","","","","","","","","","","","","","",null,"","","",""]
[null,157,"","","","","","","","","","","","","","",null,"","","",""]
[null,158,"","","","","","","","","","","","","","",null,"","","",""]
[null,159,"","","","","","","","","","","","","","",null,"","","",""]
[null,160,"","","","","","","","","","","","","","",null,"","","",""]
[null,161,"","","","","","","","","","","","","","",null,"","","",""]
[null,162,"","","","","","","","","","","","","","",null,"","","",""]
[null,163,"","","","","","","","","","","","","","",null,"","","",""]
[null,164,"","","","","","","","","","","","","","",null,"","","",""]
[null,165,"","","","","","","","","","","","","","",null,"","","",""]
[null,166,"","","","","","","","","","","","","","",null,"","","",""]
[null,167,"","","","","","","","","","","","","","",null,"","","",""]
[null,168,"","","","","","","","","","","","","","",null,"","","",""]
[null,169,"","","","","","","","","","","","","","",null,"","","",""]
[null,170,"","","","","","","","","","","","","","",null,"","","",""]
[null,171,"","","","","","","","","","","","","","",null,"","","",""]
[null,172,"","","","","","","","","","","","","","",null,"","","",""]
[null,173,"","","","","","","","","","","","","","",null,"","","",""]
[null,174,"","","","","","","","","","","","","","",null,"","","",""]
[null,175,"","","","","","","","","","","","","","",null,"","","",""]
[null,176,"","","","","","","","","","","","","","",null,"","","",""]
[null,177,"","","","","","","","","","","","","","",null,"","","",""]
[null,178,"","","","","","","","","","","","","","",null,"","","",""]
[null,179,"","","","","","","","","","","","","","",null,"","","",""]
[null,180,"","","","","","","","","","","","","","",null,"","","",""]
[null,181,"","","","","","","","","","","","","","",null,"","","",""]
[null,182,"","","","","","","","","","","","","","",null,"","","",""]
[null,183,"","","","","","","","","","","","","","",null,"","","",""]
[null,184,"","","","","","","","","","","","","","",null,"","","",""]
[null,185,"","","","","","","","","","","","","","",null,"","","",""]
[null,186,"","","","","","","","","","","","","","",null,"","","",""]
[null,187,"","","","","","","","","","","","","","",null,"","","",""]
[null,188,"","","","","","","","","","","","","","",null,"","","",""]
[null,189,"","","","","","","","","","","","","","",null,"","","",""]
[null,190,"","","","","","","","","","","","","","",null,"","","",""]
[null,191,"","","","","","","","","","","","","","",null,"","","",""]
[null,192,"","","","","","","","","","","","","","",null,"","","",""]
[null,193,"",{"$f":"IF(B228<=$E$20,WEEKDAY(C228,2),\"\")","v":""},"","","","",{"$f":"IF(B228>E$20,\"\",M228-L228-K228-J228)","v":""},{"$f":"IF(B228>E$20,\"\",((1+E$25)^(F228/360)-1)*H228)","v":""},{"$f":"IF(B228>E$20,\"\",E$27*E$28)","v":""},{"$f":"IF(B228>E$20,\"\",E$29)","v":""},{"$f":"IF(B228>E$20,\"\",IF(B228=E$20,H228+J228+K228+L228,IF(AND(E$23=2,MONTH(E228)=7),2*E$30,IF(AND(E$24=2,MONTH(E228)=12),2*E$30,E$30))))","v":""},{"$f":"IF(B228>E$20,\"\",H228-I228)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E228)=7,E$23=2),2/(1+E$26)^(G228/360),IF(AND(MONTH(E228)=12,E$24=2),2/(1+E$26)^(G228/360),1/(1+E$26)^(G228/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+E$26)^(G228/360),\"\")","v":""},null,"",{"$f":"G228","v":""},{"$f":"IFERROR((1+C$32)^(S228/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R228/T228,2),\"\")","v":""}]
[null,194,{"$f":"IF(B229>$E$20,\"\",EDATE(C228,1))","v":""},"",{"$f":"IF(D229=7,C229+1,C229)","v":""},{"$f":"IF(B229>E$20,\"\",E229-E228)","v":""},{"$f":"IFERROR(F229+G228,\"\")","v":""},{"$f":"IF(B229>E$20,\"\",N228)","v":""},"","","","","","","","",null,{"$f":"IFERROR(I229+J229+K229+L229,\"\")","v":""},"","",""]
[null,195,"","","","","","","","","","","","","","",null,"","","",""]
[null,196,"","","","","","","","","","","","","","",null,"","","",""]
[null,197,"","","","","","","","","","","","","","",null,"","","",""]
[null,198,"","","","","","","","","","","","","","",null,"","","",""]
[null,199,"","","","","","","","","","","","","","",null,"","","",""]
[null,200,"","","","","","","","","","","","","","",null,"","","",""]
[null,201,"","","","","","","","","","","","","","",null,"","","",""]
[null,202,"","","","","","","","","","","","","","",null,"","","",""]
[null,203,"","","","","","","","","","","","","","",null,"","","",""]
[null,204,"","","","","","","","","","","","","","",null,"","","",""]
[null,205,"","","","","","","","","","","","","","",null,"","","",""]
[null,206,"","","","","","","","","","","","","","",null,"","","",""]
[null,207,"","","","","","","","","","","","","","",null,"","","",""]
[null,208,"","","","","","","","","","","","","","",null,"","","",""]
[null,209,"","","","","","","","","","","","","","",null,"","","",""]
[null,210,"","","","","","","","","","","","","","",null,"","","",""]
[null,211,"","","","","","","","","","","","","","",null,"","","",""]
[null,212,"","","","","","","","","","","","","","",null,"","","",""]
[null,213,"","","","","","","","","","","","","","",null,"","","",""]
[null,214,"","","","","","","","","","","","","","",null,"","","",""]
[null,215,"","","","","","","","","","","","","","",null,"","","",""]
[null,216,"","","","","","","","","","","","","","",null,"","","",""]
[null,217,"","","","","","","","","","","","","","",null,"","","",""]
[null,218,"","","","","","","","","","","","","","",null,"","","",""]
[null,219,"","","","","","","","","","","","","","",null,"","","",""]
[null,220,"","","","","","","","","","","","","","",null,"","","",""]
[null,221,"","","","","","","","","","","","","","",null,"","","",""]
[null,222,"","","","","","","","","","","","","","",null,"","","",""]
[null,223,"","","","","","","","","","","","","","",null,"","","",""]
[null,224,"","","","","","","","","","","","","","",null,"","","",""]
[null,225,"","","","","","","","","","","","","","",null,"","","",""]
[null,226,"","","","","","","","","","","","","","",null,"","","",""]
[null,227,"","","","","","","","","","","","","","",null,"","","",""]
[null,228,"","","","","","","","","","","","","","",null,"","","",""]
[null,229,"","","","","","","","","","","","","","",null,"","","",""]
[null,230,"","","","","","","","","","","","","","",null,"","","",""]
[null,231,"","","","","","","","","","","","","","",null,"","","",""]
[null,232,"","","","","","","","","","","","","","",null,"","","",""]
[null,233,"","","","","","","","","","","","","","",null,"","","",""]
[null,234,"","","","","","","","","","","","","","",null,"","","",""]
[null,235,"","","","","","","","","","","","","","",null,"","","",""]
[null,236,"","","","","","","","","","","","","","",null,"","","",""]
[null,237,"","","","","","","","","","","","","","",null,"","","",""]
[null,238,"","","","","","","","","","","","","","",null,"","","",""]
[null,239,"","","","","","","","","","","","","","",null,"","","",""]
[null,240,"","","","","","","","","","","","","","",null,"","","",""]
[null,241,"","","","","","","","","","","","","","",null,"","","",""]
[null,242,"","","","","","","","","","","","","","",null,"","","",""]
[null,243,"","","","","","","","","","","","","","",null,"","","",""]
[null,244,"","","","","","","","","","","","","","",null,"","","",""]
[null,245,"","","","","","","","","","","","","","",null,"","","",""]
[null,246,"","","","","","","","","","","","","","",null,"","","",""]
[null,247,"","","","","","","","","","","","","","",null,"","","",""]
[null,248,"","","","","","","","","","","","","","",null,"","","",""]
[null,249,"","","","","","","","","","","","","","",null,"","","",""]
[null,250,"","","","","","","","","","","","","","",null,"","","",""]
[null,251,"","","","","","","","","","","","","","",null,"","","",""]
[null,252,"","","","","","","","","","","","","","",null,"","","",""]
[null,253,"","","","","","","","","","","","","","",null,"","","",""]
[null,254,"","","","","","","","","","","","","","",null,"","","",""]
[null,255,"","","","","","","","","","","","","","",null,"","","",""]
[null,256,"","","","","","","","","","","","","","",null,"","","",""]
[null,257,"",{"$f":"IF(B292<=$E$20,WEEKDAY(C292,2),\"\")","v":""},"","","","",{"$f":"IF(B292>E$20,\"\",M292-L292-K292-J292)","v":""},{"$f":"IF(B292>E$20,\"\",((1+E$25)^(F292/360)-1)*H292)","v":""},{"$f":"IF(B292>E$20,\"\",E$27*E$28)","v":""},{"$f":"IF(B292>E$20,\"\",E$29)","v":""},{"$f":"IF(B292>E$20,\"\",IF(B292=E$20,H292+J292+K292+L292,IF(AND(E$23=2,MONTH(E292)=7),2*E$30,IF(AND(E$24=2,MONTH(E292)=12),2*E$30,E$30))))","v":""},{"$f":"IF(B292>E$20,\"\",H292-I292)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E292)=7,E$23=2),2/(1+E$26)^(G292/360),IF(AND(MONTH(E292)=12,E$24=2),2/(1+E$26)^(G292/360),1/(1+E$26)^(G292/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+E$26)^(G292/360),\"\")","v":""},null,"",{"$f":"G292","v":""},{"$f":"IFERROR((1+C$32)^(S292/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R292/T292,2),\"\")","v":""}]
[null,258,{"$f":"IF(B293>$E$20,\"\",EDATE(C292,1))","v":""},"",{"$f":"IF(D293=7,C293+1,C293)","v":""},{"$f":"IF(B293>E$20,\"\",E293-E292)","v":""},{"$f":"IFERROR(F293+G292,\"\")","v":""},{"$f":"IF(B293>E$20,\"\",N292)","v":""},"","","","","","","","",null,{"$f":"IFERROR(I293+J293+K293+L293,\"\")","v":""},"","",""]
[null,259,"","","","","","","","","","","","","","",null,"","","",""]
[null,260,"","","","","","","","","","","","","","",null,"","","",""]
[null,261,"","","","","","","","","","","","","","",null,"","","",""]
[null,262,"","","","","","","","","","","","","","",null,"","","",""]
[null,263,"","","","","","","","","","","","","","",null,"","","",""]
[null,264,"","","","","","","","","","","","","","",null,"","","",""]
[null,265,"","","","","","","","","","","","","","",null,"","","",""]
[null,266,"","","","","","","","","","","","","","",null,"","","",""]
[null,267,"","","","","","","","","","","","","","",null,"","","",""]
[null,268,"","","","","","","","","","","","","","",null,"","","",""]
[null,269,"","","","","","","","","","","","","","",null,"","","",""]
[null,270,"","","","","","","","","","","","","","",null,"","","",""]
[null,271,"","","","","","","","","","","","","","",null,"","","",""]
[null,272,"","","","","","","","","","","","","","",null,"","","",""]
[null,273,"","","","","","","","","","","","","","",null,"","","",""]
[null,274,"","","","","","","","","","","","","","",null,"","","",""]
[null,275,"","","","","","","","","","","","","","",null,"","","",""]
[null,276,"","","","","","","","","","","","","","",null,"","","",""]
[null,277,"","","","","","","","","","","","","","",null,"","","",""]
[null,278,"","","","","","","","","","","","","","",null,"","","",""]
[null,279,"","","","","","","","","","","","","","",null,"","","",""]
[null,280,"","","","","","","","","","","","","","",null,"","","",""]
[null,281,"","","","","","","","","","","","","","",null,"","","",""]
[null,282,"","","","","","","","","","","","","","",null,"","","",""]
[null,283,"","","","","","","","","","","","","","",null,"","","",""]
[null,284,"","","","","","","","","","","","","","",null,"","","",""]
[null,285,"","","","","","","","","","","","","","",null,"","","",""]
[null,286,"","","","","","","","","","","","","","",null,"","","",""]
[null,287,"","","","","","","","","","","","","","",null,"","","",""]
[null,288,"","","","","","","","","","","","","","",null,"","","",""]
[null,289,"","","","","","","","","","","","","","",null,"","","",""]
[null,290,"","","","","","","","","","","","","","",null,"","","",""]
[null,291,"","","","","","","","","","","","","","",null,"","","",""]
[null,292,"","","","","","","","","","","","","","",null,"","","",""]
[null,293,"","","","","","","","","","","","","","",null,"","","",""]
[null,294,"","","","","","","","","","","","","","",null,"","","",""]
[null,295,"","","","","","","","","","","","","","",null,"","","",""]
[null,296,"","","","","","","","","","","","","","",null,"","","",""]
[null,297,"","","","","","","","","","","","","","",null,"","","",""]
[null,298,"","","","","","","","","","","","","","",null,"","","",""]
[null,299,"","","","","","","","","","","","","","",null,"","","",""]
[null,300,"","","","","","","","","","","","","","",null,"","","",""]
[null,301,"","","","","","","","","","","","","","",null,"","","",""]
[null,302,"","","","","","","","","","","","","","",null,"","","",""]
[null,303,"","","","","","","","","","","","","","",null,"","","",""]
[null,304,"","","","","","","","","","","","","","",null,"","","",""]
[null,305,"","","","","","","","","","","","","","",null,"","","",""]
[null,306,"","","","","","","","","","","","","","",null,"","","",""]
[null,307,"","","","","","","","","","","","","","",null,"","","",""]
[null,308,"","","","","","","","","","","","","","",null,"","","",""]
[null,309,"","","","","","","","","","","","","","",null,"","","",""]
[null,310,"","","","","","","","","","","","","","",null,"","","",""]
[null,311,"","","","","","","","","","","","","","",null,"","","",""]
[null,312,"","","","","","","","","","","","","","",null,"","","",""]
[null,313,"","","","","","","","","","","","","","",null,"","","",""]
[null,314,"","","","","","","","","","","","","","",null,"","","",""]
[null,315,"","","","","","","","","","","","","","",null,"","","",""]
[null,316,"","","","","","","","","","","","","","",null,"","","",""]
[null,317,"","","","","","","","","","","","","","",null,"","","",""]
[null,318,"","","","","","","","","","","","","","",null,"","","",""]
[null,319,"","","","","","","","","","","","","","",null,"","","",""]
[null,320,"","","","","","","","","","","","","","",null,"","","",""]
[null,321,"",{"$f":"IF(B356<=$E$20,WEEKDAY(C356,2),\"\")","v":""},"","","","",{"$f":"IF(B356>E$20,\"\",M356-L356-K356-J356)","v":""},{"$f":"IF(B356>E$20,\"\",((1+E$25)^(F356/360)-1)*H356)","v":""},{"$f":"IF(B356>E$20,\"\",E$27*E$28)","v":""},{"$f":"IF(B356>E$20,\"\",E$29)","v":""},{"$f":"IF(B356>E$20,\"\",IF(B356=E$20,H356+J356+K356+L356,IF(AND(E$23=2,MONTH(E356)=7),2*E$30,IF(AND(E$24=2,MONTH(E356)=12),2*E$30,E$30))))","v":""},{"$f":"IF(B356>E$20,\"\",H356-I356)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E356)=7,E$23=2),2/(1+E$26)^(G356/360),IF(AND(MONTH(E356)=12,E$24=2),2/(1+E$26)^(G356/360),1/(1+E$26)^(G356/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+E$26)^(G356/360),\"\")","v":""},null,"",{"$f":"G356","v":""},{"$f":"IFERROR((1+C$32)^(S356/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R356/T356,2),\"\")","v":""}]
[null,322,{"$f":"IF(B357>$E$20,\"\",EDATE(C356,1))","v":""},"",{"$f":"IF(D357=7,C357+1,C357)","v":""},{"$f":"IF(B357>E$20,\"\",E357-E356)","v":""},{"$f":"IFERROR(F357+G356,\"\")","v":""},{"$f":"IF(B357>E$20,\"\",N356)","v":""},"","","","","","","","",null,{"$f":"IFERROR(I357+J357+K357+L357,\"\")","v":""},"","",""]
[null,323,"","","","","","","","","","","","","","",null,"","","",""]
[null,324,"","","","","","","","","","","","","","",null,"","","",""]
[null,325,"","","","","","","","","","","","","","",null,"","","",""]
[null,326,"","","","","","","","","","","","","","",null,"","","",""]
[null,327,"","","","","","","","","","","","","","",null,"","","",""]
[null,328,"","","","","","","","","","","","","","",null,"","","",""]
[null,329,"","","","","","","","","","","","","","",null,"","","",""]
[null,330,"","","","","","","","","","","","","","",null,"","","",""]
[null,331,"","","","","","","","","","","","","","",null,"","","",""]
[null,332,"","","","","","","","","","","","","","",null,"","","",""]
[null,333,"","","","","","","","","","","","","","",null,"","","",""]
[null,334,"","","","","","","","","","","","","","",null,"","","",""]
[null,335,"","","","","","","","","","","","","","",null,"","","",""]
[null,336,"","","","","","","","","","","","","","",null,"","","",""]
[null,337,"","","","","","","","","","","","","","",null,"","","",""]
[null,338,"","","","","","","","","","","","","","",null,"","","",""]
[null,339,"","","","","","","","","","","","","","",null,"","","",""]
[null,340,"","","","","","","","","","","","","","",null,"","","",""]
[null,341,"","","","","","","","","","","","","","",null,"","","",""]
[null,342,"","","","","","","","","","","","","","",null,"","","",""]
[null,343,"","","","","","","","","","","","","","",null,"","","",""]
[null,344,"","","","","","","","","","","","","","",null,"","","",""]
[null,345,"","","","","","","","","","","","","","",null,"","","",""]
[null,346,"","","","","","","","","","","","","","",null,"","","",""]
[null,347,"","","","","","","","","","","","","","",null,"","","",""]
[null,348,"","","","","","","","","","","","","","",null,"","","",""]
[null,349,"","","","","","","","","","","","","","",null,"","","",""]
[null,350,"","","","","","","","","","","","","","",null,"","","",""]
[null,351,"","","","","","","","","","","","","","",null,"","","",""]
[null,352,"","","","","","","","","","","","","","",null,"","","",""]
[null,353,"","","","","","","","","","","","","","",null,"","","",""]
[null,354,"","","","","","","","","","","","","","",null,"","","",""]
[null,355,"","","","","","","","","","","","","","",null,"","","",""]
[null,356,"","","","","","","","","","","","","","",null,"","","",""]
[null,357,"","","","","","","","","","","","","","",null,"","","",""]
[null,358,"","","","","","","","","","","","","","",null,"","","",""]
[null,359,"","","","","","","","","","","","","","",null,"","","",""]
[null,360,"","","","","","","","","","","","","","",null,"","","",""]
[]
[]
[null,"Esta simulación es solo referencial. No constituye declaración ni genera responsabilidad para CrediScotia. Las cuotas resultantes son aproximadas de acuerdo a los datos ingresados. La simulación asume que el crédito es desembolsado en el mismo día al de la fecha que se efectúa la simulación. Si cuenta con un seguro de vida contratado directamente, puede endosarlo a favor de CrediScotia, siempre que reúna las condiciones y características de cobertura requeridas hasta por el monto del saldo adeudado. Infórmate sobre nuestras tasas de interés, comisiones y gastos en el tarifario ubicado en www.crediscotia.com.pe."]

{"sheet":"Proceso Prima de Seguro","index":1,"n_rows":396,"n_cols":24,"rows_kept":396,"cut":false,"hidden":true,"merged":[[1,2,3,8]]}
[]
[null,null,"Proceso de Cálculo de la Prima de Seguros"]
[]
[]
[]
[]
[null,"1) Datos esenciales del préstamo",null,null,null,"3) Calculo del valor presente del Seguro"]
[]
[null,"Producto",{"$f":"'Vista Principal'!E9","v":"Préstamos Personales (LD )"},null,null,"Suma de Prima Mensual",{"$f":"SUM(K37:K396)","v":2091.8483291411135}]
[null,"Tipo de Seguro",{"$f":"'Vista Principal'!E10","v":"Seguro de Desgravamen"},null,null,"VPN - Valor Presente",{"$f":"NPV(C16,K37:K396)","v":2040.2140468056211}]
[null,"Tarifa",{"$f":"'Vista Principal'!E11","v":"TARIFA TITULAR"}]
[null,"Monto inicial",{"$f":"'Vista Principal'!E12","v":16000},null,null,"4) Calculo del Monto Adicional del Seguro y MAF"]
[null,{"$f":"C10","v":"Seguro de Desgravamen"},{"$f":"INDEX(_xlfn._xlws.FILTER(TarifarioPrincipal[],(TarifarioPrincipal[TARIFA]='Proceso Prima de Seguro'!C11)*(TarifarioPrincipal[PRODUCTO]='Proceso Prima de Seguro'!C9)*(TarifarioPrincipal[TIPO_SEGURO]='Proceso Prima de Seguro'!C10)*(TarifarioPrincipal[Plazo]='Proceso Prima de Seguro'!C19)),0,5)","v":8.3140000000000002E-3}]
[null,"Monto adicional Seguro de Desgravamen/ Vida",null,null,null,"Monto inicial",{"$f":"C12","v":16000}]
[null,"MAF Inicial",{"$f":"C12+C14","v":16000},null,null,"Monto adicional de Desgravamen / Vida",{"$f":"G10","v":2040.2140468056211}]
[null,"Costo Capital",{"$f":"INDEX(_xlfn._xlws.FILTER(Tabla2[],Tabla2[TARIFA]=C11),0,2)","v":2.8709999999999999E-3},null,null,"Prima de Seguro de Desgravamen / Vida",{"$f":"G15/G14","v":0.12751337792535133}]
[null,"Moneda",{"$f":"'Vista Principal'!E19","v":"Soles"},null,null,"MAF Inicial",{"$f":"G14+G15","v":18040.21404680562}]
[null,"Plazo Remanente Meses",{"$f":"'Vista Principal'!E20","v":24}]
[null,"Plazo Rango",{"$f":"IF(C18<=12,\"0-12\",IF(AND(C18>12,C18<=18),\"13-18\",IF(AND(C18>18,C18<=24),\"19-24\",IF(AND(C18>24,C18<=36),\"25-36\",IF(AND(C18>36,C18<=48),\"37-48\",\"49-84\")))))","v":"19-24"}]
[null,"Fecha de Desembolso",{"$f":"'Vista Principal'!E21","v":"2022-08-20"}]
[null,"Fecha de 1er Pago",{"$f":"'Vista Principal'!E22","v":"2022-10-16"}]
[null,"Cuota Julio",{"$f":"'Vista Principal'!E23","v":1}]
[null,"Cuota Diciembre",{"$f":"'Vista Principal'!E24","v":1}]
[null,"TEA",{"$f":"'Vista Principal'!E25","v":0.39}]
[null,"TEA TOTAL",{"$f":"(1+(((1+C24)^(30/360)-1)+C13))^12-1","v":0.5310911604200621}]
[null,"Monto del Bien",0]
[null,"Seguro del Bien",0]
[null,"Portes",0]
[null,"Cuota",{"$f":"(C15+(C27*C26+C28)*Q35)/P35","v":1046.5422174474136}]
[]
[null,"TCEA",0.9236764757563436]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C15-V35-C14","v":3123.1200000000026}]
[]
[null,"2) Creación de Cronograma de prima mensual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P37:P396)","v":15.288442007647879},{"$f":"SUM(Q37:Q396)","v":15.288442007647879},null,null,null,null,{"$f":"SUM(V37:V396)","v":12876.879999999997}]
[null,"N° Cuota","Fecha de pago","Día","Fecha de pago","Días","Dias Acumulados","Saldo Inicial","Amortización","Interés","Seguro Desgravamen","Seguro del Bien","Portes","Cuota Constante","Saldo Final","Factor Cronograma","Factor Cronograma 2",null,"Vector i,1\nCuota","Vector i,2\nDías Acum","Vector i,3 Factor","Vector i,4\nCalculo VA","VPN - Valor Presente","VPN - Valor Presente"]
[null,1,{"$f":"C21","v":"2022-10-16"},{"$f":"IF(B37<=$C$18,WEEKDAY(C37,2),\"\")","v":7},{"$f":"IF(D37=7,C37+1,C37)","v":"2022-10-17"},{"$f":"E37-C20","v":58},{"$f":"F37","v":58},{"$f":"C15","v":16000},{"$f":"IF(B37>C$18,\"\",N37-M37-L37-K37-J37)","v":-83.428839698324623},{"$f":"IF(B37>C$18,\"\",((1+C$24)^(F37/360)-1)*H37)","v":871.79368468373752},{"$f":"IF(B37>C$18,\"\",((1+C$13)^(F37/30)-1)*H37)","v":258.17737246200068},{"$f":"IF(B37>C$18,\"\",C$26*C$27)","v":0},{"$f":"IF(B37>C$18,\"\",C$28)","v":0},{"$f":"IF(B37>C$18,\"\",IF(B37=C$18,H37+J37+K37+L37+M37,IF(AND(C$22=2,MONTH(E37)=7),2*C$29,IF(AND(C$23=2,MONTH(E37)=12),2*C$29,C$29))))","v":1046.5422174474136},{"$f":"IF(B37>C$18,\"\",H37-I37)","v":16083.428839698325},{"$f":"IFERROR(IF(AND(MONTH(E37)=7,C$22=2),2/(1+C$25)^(G37/360),IF(AND(MONTH(E37)=12,C$23=2),2/(1+C$25)^(G37/360),1/(1+C$25)^(G37/360))),\"\")","v":0.93367187212903624},{"$f":"IFERROR(1/(1+C$25)^(G37/360),\"\")","v":0.93367187212903624},null,{"$f":"IFERROR(I37+J37+K37+L37+M37,\"\")","v":1046.5422174474136},{"$f":"G37","v":58},{"$f":"IFERROR((1+C$31)^(T37/360),\"\")","v":1.1111605849390616},{"$f":"IFERROR(ROUND(S37/U37,2),\"\")","v":941.85},{"$f":"K37/(1+$H$9)","v":258.17737246200068},{"$f":"K37/(1+$P$29)","v":258.17737246200068}]
[null,2,{"$f":"IF(B38>$C$18,\"\",EDATE(C37,1))","v":"2022-11-16"},3,{"$f":"IF(D38=7,C38+1,C38)","v":"2022-11-16"},{"$f":"IF(B38>C$18,\"\",E38-E37)","v":30},{"$f":"IFERROR(F38+G37,\"\")","v":88},{"$f":"IF(B38>C$18,\"\",O37)","v":16083.428839698325},465.35178601193491,447.47280406222785,{"$f":"IF(B38>C$18,\"\",((1+C$13)^(F38/30)-1)*H38)","v":133.71762737325079},0,0,1046.5422174474136,15618.077053686389,0.90110940254283933,0.90110940254283933,null,1046.5422174474136,88,1.1734227318565009,891.87,{"$f":"IF(N38=\"\",0,K38/((1+$H$9)^B38))","v":133.71762737325079},{"$f":"IF(N38=\"\",0,K38/((1+$P$29)^B38))","v":133.71762737325079}]
[null,3,"2022-12-16",5,"2022-12-16",30,118,15618.077053686389,482.16772793434291,434.52579688872311,129.84869262434759,0,0,1046.5422174474136,15135.909325752047,0.86968257220765055,0.86968257220765055,null,1046.5422174474136,118,1.2391736408766576,844.55,129.84869262434759,129.84869262434759]
[null,4,"2023-01-16",1,"2023-01-16",31,149,15135.909325752047,481.14167035408229,435.34796156569473,130.05258552763652,0,0,1046.5422174474136,14654.767655397965,0.83835917443884422,0.83835917443884422,null,1046.5422174474136,149,1.3109891333991677,798.28,130.05258552763652,130.05258552763652]
[null,5,"2023-02-16",4,"2023-02-16",31,180,14654.767655397965,499.1146746706948,421.50908073568183,125.91846204103689,0,0,1046.5422174474136,14155.652980727271,0.80816395294853016,0.80816395294853016,null,1046.5422174474136,180,1.386966645509669,754.55,125.91846204103689,125.91846204103689]
[null,6,"2023-03-16",4,"2023-03-16",28,208,14155.652980727271,569.48366607169453,367.24481094244175,109.81374043327726,0,0,1046.5422174474136,13586.169314655577,0.78182671275714366,0.78182671275714366,null,1046.5422174474136,208,1.4593691967937219,717.12,109.81374043327726,109.81374043327726]
[null,7,"2023-04-16",7,"2023-04-17",32,240,13586.169314655577,522.45870122601184,403.56443915887758,120.51907706252412,0,0,1046.5422174474136,13063.710613429565,0.75277635146391664,0.75277635146391664,null,1046.5422174474136,240,1.54675438562731,676.61,120.51907706252412,120.51907706252412]
[null,8,"2023-05-16",2,"2023-05-16",29,269,13063.710613429565,590.3838077482269,351.18161613473796,104.97679356444868,0,0,1046.5422174474136,12473.326805681338,0.72738292998796417,0.72738292998796417,null,1046.5422174474136,269,1.6304585778622964,641.87,104.97679356444868,104.97679356444868]
[null,9,"2023-06-16",5,"2023-06-16",31,300,12473.326805681338,580.60220365470195,358.76519090644723,107.17482288626442,0,0,1046.5422174474136,11892.724602026636,0.70118474507042994,0.70118474507042994,null,1046.5422174474136,300,1.7249507312976253,606.71,107.17482288626442,107.17482288626442]
[null,10,"2023-07-16",7,"2023-07-17",31,331,11892.724602026636,602.29054734948363,342.0655674876167,102.18610261031327,0,0,1046.5422174474136,11290.434054677153,0.67593014140106267,0.67593014140106267,null,1046.5422174474136,331,1.824919115274519,573.47,102.18610261031327,102.18610261031327]
[null,11,"2023-08-16",3,"2023-08-16",30,361,11290.434054677153,638.55134033201387,314.1222083848146,93.868668730585085,0,0,1046.5422174474136,10651.882714345138,0.65235659770891197,0.65235659770891197,null,1046.5422174474136,361,1.927175606017391,543.04,93.868668730585085,93.868668730585085]
[null,12,"2023-09-16",6,"2023-09-16",31,392,10651.882714345138,648.64208573758651,306.37574041469793,91.524391295129121,0,0,1046.5422174474136,10003.240628607551,0.6288606397006119,0.6288606397006119,null,1046.5422174474136,392,2.0388637994699192,513.29999999999995,91.524391295129121,91.524391295129121]
[null,13,"2023-10-16",1,"2023-10-16",30,422,{"$f":"IF(B49>C$18,\"\",O48)","v":10003.240628607551},{"$f":"IF(B49>C$18,\"\",N49-M49-L49-K49-J49)","v":685.06533371579883},278.30994114537225,83.166942586242499,0,0,1046.5422174474136,{"$f":"IF(B49>C$18,\"\",H49-I49)","v":9318.1752948917529},0.60692867830660147,0.60692867830660147,null,{"$f":"IFERROR(I49+J49+K49+L49+M49,\"\")","v":1046.5422174474136},422,2.1531083462508929,486.06,83.166942586242499,{"$f":"IF(N49=\"\",0,K49/((1+$P$29)^B49))","v":83.166942586242499}]
[null,14,"2023-11-16",4,"2023-11-16",31,453,9318.1752948917529,698.46260780813031,268.01486008118519,80.064749558098129,0,0,1046.5422174474136,8619.7126870836219,0.58506889979036092,0.58506889979036092,null,1046.5422174474136,453,2.2778903229163618,459.43,80.064749558098129,80.064749558098129]
[null,15,"2023-12-16",6,"2023-12-16",30,483,8619.7126870836219,735.06046903499202,239.81745713200891,71.664291280412655,0,0,1046.5422174474136,7884.6522180486299,0.56466420642435966,0.56466420642435966,null,1046.5422174474136,483,2.4055283474013729,435.06,71.664291280412655,71.664291280412655]
[null,16,"2024-01-16",2,"2024-01-16",31,514,7884.6522180486299,752.01173488561722,226.7830228701078,67.747459691688476,0,0,1046.5422174474136,7132.6404831630125,0.54432666936329221,0.54432666936329221,null,1046.5422174474133,514,2.5449391590478139,411.22,67.747459691688476,67.747459691688476]
[null,17,"2024-02-16",5,"2024-02-16",31,545,7132.6404831630125,780.10306637909582,205.15321729913208,61.285933769185718,0,0,1046.5422174474136,6352.5374167839163,0.5247216303231802,0.5247216303231802,null,1046.5422174474136,545,2.6924294324993561,388.7,61.285933769185718,61.285933769185718]
[null,18,"2024-03-16",6,"2024-03-16",29,574,6352.5374167839163,824.72443141839562,170.77034409268052,51.047441936337471,0,0,1046.5422174474136,5527.8129853655209,0.50702118384869488,0.50702118384869488,null,1046.5422174474136,574,2.8381329992008397,368.74,51.047441936337471,51.047441936337471]
[null,19,"2024-04-16",2,"2024-04-16",31,605,5527.8129853655209,840.05125487024475,158.99422117974967,47.496741397419115,0,0,1046.5422174474136,4687.7617304952764,0.48875977822044486,0.48875977822044486,null,1046.5422174474136,605,3.0026151286284826,348.54,47.496741397419115,47.496741397419115]
[null,20,"2024-05-16",4,"2024-05-16",30,635,4687.7617304952764,877.14536247526337,130.42280394481281,38.97405102733741,0,0,1046.5422174474136,3810.6163680200129,0.47171393386297439,0.47171393386297439,null,1046.5422174474136,635,3.1708619750421754,330.05,38.97405102733741,38.97405102733741]
[null,21,"2024-06-16",7,"2024-06-17",32,667,3810.6163680200129,899.5485226928165,113.19079144338053,33.802903311216554,0,0,1046.5422174474136,2911.0678453271967,0.45418644345855597,0.45418644345855597,null,1046.5422174474136,667,3.3607291951144314,311.39999999999998,33.802903311216554,33.802903311216554]
[null,22,"2024-07-16",2,"2024-07-16",29,696,2911.0678453271967,944.89360334800188,78.255982611014858,23.392631488396926,0,0,1046.5422174474136,1966.1742419791949,0.43886536201786236,0.43886536201786236,null,1046.5422174474136,696,3.5425984855535217,295.42,23.392631488396926,23.392631488396926]
[null,23,"2024-08-16",5,"2024-08-16",31,727,1966.1742419791949,973.0959534555659,56.552264545631289,16.893999446216299,0,0,1046.5422174474136,993.078288523629,0.42305872780356368,0.42305872780356368,null,1046.5422174474133,727,3.7479074484439354,279.23,16.893999446216299,16.893999446216299]
[null,24,"2024-09-16",1,"2024-09-16",31,758,993.078288523629,993.07828852362911,28.56350413307128,8.5328470377475032,0,0,1030.1746396944479,-1.1368683772161603E-13,0.40782140187104837,0.40782140187104837,null,1030.1746396944479,758,3.9651149571094439,259.81,8.5328470377475032,8.5328470377475032]
[null,25,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,26,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,27,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,28,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,29,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,30,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,31,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,32,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,33,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,34,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,35,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,36,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,37,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,38,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,39,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,40,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,41,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,42,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,43,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,44,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,45,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,46,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,47,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,48,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,49,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,50,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,51,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,52,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,53,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,54,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,55,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,56,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,57,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,58,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,59,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,60,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,61,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,62,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,63,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,64,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,65,"",{"$f":"IF(B101<=$C$18,WEEKDAY(C101,2),\"\")","v":""},"","","","",{"$f":"IF(B101>C$18,\"\",N101-M101-L101-K101-J101)","v":""},{"$f":"IF(B101>C$18,\"\",((1+C$24)^(F101/360)-1)*H101)","v":""},"",{"$f":"IF(B101>C$18,\"\",C$26*C$27)","v":""},{"$f":"IF(B101>C$18,\"\",C$28)","v":""},{"$f":"IF(B101>C$18,\"\",IF(B101=C$18,H101+J101+K101+L101+M101,IF(AND(C$22=2,MONTH(E101)=7),2*C$29,IF(AND(C$23=2,MONTH(E101)=12),2*C$29,C$29))))","v":""},{"$f":"IF(B101>C$18,\"\",H101-I101)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E101)=7,C$22=2),2/(1+C$25)^(G101/360),IF(AND(MONTH(E101)=12,C$23=2),2/(1+C$25)^(G101/360),1/(1+C$25)^(G101/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$25)^(G101/360),\"\")","v":""},null,"",{"$f":"G101","v":""},{"$f":"IFERROR((1+C$31)^(T101/360),\"\")","v":""},{"$f":"IFERROR(ROUND(S101/U101,2),\"\")","v":""},0,0]
[null,66,{"$f":"IF(B102>$C$18,\"\",EDATE(C101,1))","v":""},"",{"$f":"IF(D102=7,C102+1,C102)","v":""},{"$f":"IF(B102>C$18,\"\",E102-E101)","v":""},{"$f":"IFERROR(F102+G101,\"\")","v":""},{"$f":"IF(B102>C$18,\"\",O101)","v":""},"","",{"$f":"IF(B102>C$18,\"\",((1+C$13)^(F102/30)-1)*H102)","v":""},"","","","","","",null,{"$f":"IFERROR(I102+J102+K102+L102+M102,\"\")","v":""},"","","",{"$f":"IF(N102=\"\",0,K102/((1+$H$9)^B102))","v":0},0]
[null,67,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(N103=\"\",0,K103/((1+$P$29)^B103))","v":0}]
[null,68,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,69,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,70,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,71,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,72,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,73,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,74,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,75,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,76,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,77,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,78,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,79,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,80,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,81,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,82,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,83,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,84,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,85,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,86,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,87,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,88,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,89,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,90,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,91,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,92,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,93,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,94,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,95,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,96,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,97,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,98,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,99,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,100,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,101,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,102,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,103,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,104,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,105,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,106,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,107,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,108,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,109,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,110,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,111,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,112,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,113,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,114,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,115,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,116,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,117,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,118,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,119,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,120,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,121,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,122,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,123,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,124,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,125,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,126,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,127,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,128,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,129,"",{"$f":"IF(B165<=$C$18,WEEKDAY(C165,2),\"\")","v":""},"","","","",{"$f":"IF(B165>C$18,\"\",N165-M165-L165-K165-J165)","v":""},{"$f":"IF(B165>C$18,\"\",((1+C$24)^(F165/360)-1)*H165)","v":""},"",{"$f":"IF(B165>C$18,\"\",C$26*C$27)","v":""},{"$f":"IF(B165>C$18,\"\",C$28)","v":""},{"$f":"IF(B165>C$18,\"\",IF(B165=C$18,H165+J165+K165+L165+M165,IF(AND(C$22=2,MONTH(E165)=7),2*C$29,IF(AND(C$23=2,MONTH(E165)=12),2*C$29,C$29))))","v":""},{"$f":"IF(B165>C$18,\"\",H165-I165)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E165)=7,C$22=2),2/(1+C$25)^(G165/360),IF(AND(MONTH(E165)=12,C$23=2),2/(1+C$25)^(G165/360),1/(1+C$25)^(G165/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$25)^(G165/360),\"\")","v":""},null,"",{"$f":"G165","v":""},{"$f":"IFERROR((1+C$31)^(T165/360),\"\")","v":""},{"$f":"IFERROR(ROUND(S165/U165,2),\"\")","v":""},0,0]
[null,130,{"$f":"IF(B166>$C$18,\"\",EDATE(C165,1))","v":""},"",{"$f":"IF(D166=7,C166+1,C166)","v":""},{"$f":"IF(B166>C$18,\"\",E166-E165)","v":""},{"$f":"IFERROR(F166+G165,\"\")","v":""},{"$f":"IF(B166>C$18,\"\",O165)","v":""},"","",{"$f":"IF(B166>C$18,\"\",((1+C$13)^(F166/30)-1)*H166)","v":""},"","","","","","",null,{"$f":"IFERROR(I166+J166+K166+L166+M166,\"\")","v":""},"","","",{"$f":"IF(N166=\"\",0,K166/((1+$H$9)^B166))","v":0},0]
[null,131,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(N167=\"\",0,K167/((1+$P$29)^B167))","v":0}]
[null,132,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,133,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,134,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,135,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,136,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,137,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,138,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,139,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,140,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,141,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,142,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,143,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,144,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,145,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,146,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,147,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,148,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,149,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,150,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,151,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,152,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,153,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,154,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,155,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,156,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,157,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,158,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,159,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,160,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,161,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,162,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,163,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,164,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,165,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,166,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,167,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,168,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,169,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,170,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,171,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,172,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,173,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,174,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,175,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,176,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,177,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,178,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,179,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,180,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,181,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,182,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,183,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,184,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,185,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,186,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,187,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,188,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,189,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,190,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,191,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,192,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,193,"",{"$f":"IF(B229<=$C$18,WEEKDAY(C229,2),\"\")","v":""},"","","","",{"$f":"IF(B229>C$18,\"\",N229-M229-L229-K229-J229)","v":""},{"$f":"IF(B229>C$18,\"\",((1+C$24)^(F229/360)-1)*H229)","v":""},"",{"$f":"IF(B229>C$18,\"\",C$26*C$27)","v":""},{"$f":"IF(B229>C$18,\"\",C$28)","v":""},{"$f":"IF(B229>C$18,\"\",IF(B229=C$18,H229+J229+K229+L229+M229,IF(AND(C$22=2,MONTH(E229)=7),2*C$29,IF(AND(C$23=2,MONTH(E229)=12),2*C$29,C$29))))","v":""},{"$f":"IF(B229>C$18,\"\",H229-I229)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E229)=7,C$22=2),2/(1+C$25)^(G229/360),IF(AND(MONTH(E229)=12,C$23=2),2/(1+C$25)^(G229/360),1/(1+C$25)^(G229/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$25)^(G229/360),\"\")","v":""},null,"",{"$f":"G229","v":""},{"$f":"IFERROR((1+C$31)^(T229/360),\"\")","v":""},{"$f":"IFERROR(ROUND(S229/U229,2),\"\")","v":""},0,0]
[null,194,{"$f":"IF(B230>$C$18,\"\",EDATE(C229,1))","v":""},"",{"$f":"IF(D230=7,C230+1,C230)","v":""},{"$f":"IF(B230>C$18,\"\",E230-E229)","v":""},{"$f":"IFERROR(F230+G229,\"\")","v":""},{"$f":"IF(B230>C$18,\"\",O229)","v":""},"","",{"$f":"IF(B230>C$18,\"\",((1+C$13)^(F230/30)-1)*H230)","v":""},"","","","","","",null,{"$f":"IFERROR(I230+J230+K230+L230+M230,\"\")","v":""},"","","",{"$f":"IF(N230=\"\",0,K230/((1+$H$9)^B230))","v":0},0]
[null,195,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(N231=\"\",0,K231/((1+$P$29)^B231))","v":0}]
[null,196,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,197,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,198,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,199,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,200,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,201,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,202,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,203,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,204,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,205,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,206,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,207,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,208,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,209,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,210,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,211,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,212,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,213,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,214,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,215,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,216,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,217,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,218,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,219,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,220,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,221,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,222,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,223,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,224,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,225,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,226,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,227,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,228,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,229,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,230,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,231,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,232,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,233,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,234,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,235,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,236,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,237,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,238,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,239,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,240,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,241,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,242,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,243,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,244,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,245,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,246,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,247,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,248,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,249,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,250,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,251,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,252,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,253,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,254,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,255,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,256,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,257,"",{"$f":"IF(B293<=$C$18,WEEKDAY(C293,2),\"\")","v":""},"","","","",{"$f":"IF(B293>C$18,\"\",N293-M293-L293-K293-J293)","v":""},{"$f":"IF(B293>C$18,\"\",((1+C$24)^(F293/360)-1)*H293)","v":""},"",{"$f":"IF(B293>C$18,\"\",C$26*C$27)","v":""},{"$f":"IF(B293>C$18,\"\",C$28)","v":""},{"$f":"IF(B293>C$18,\"\",IF(B293=C$18,H293+J293+K293+L293+M293,IF(AND(C$22=2,MONTH(E293)=7),2*C$29,IF(AND(C$23=2,MONTH(E293)=12),2*C$29,C$29))))","v":""},{"$f":"IF(B293>C$18,\"\",H293-I293)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E293)=7,C$22=2),2/(1+C$25)^(G293/360),IF(AND(MONTH(E293)=12,C$23=2),2/(1+C$25)^(G293/360),1/(1+C$25)^(G293/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$25)^(G293/360),\"\")","v":""},null,"",{"$f":"G293","v":""},{"$f":"IFERROR((1+C$31)^(T293/360),\"\")","v":""},{"$f":"IFERROR(ROUND(S293/U293,2),\"\")","v":""},0,0]
[null,258,{"$f":"IF(B294>$C$18,\"\",EDATE(C293,1))","v":""},"",{"$f":"IF(D294=7,C294+1,C294)","v":""},{"$f":"IF(B294>C$18,\"\",E294-E293)","v":""},{"$f":"IFERROR(F294+G293,\"\")","v":""},{"$f":"IF(B294>C$18,\"\",O293)","v":""},"","",{"$f":"IF(B294>C$18,\"\",((1+C$13)^(F294/30)-1)*H294)","v":""},"","","","","","",null,{"$f":"IFERROR(I294+J294+K294+L294+M294,\"\")","v":""},"","","",{"$f":"IF(N294=\"\",0,K294/((1+$H$9)^B294))","v":0},0]
[null,259,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(N295=\"\",0,K295/((1+$P$29)^B295))","v":0}]
[null,260,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,261,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,262,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,263,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,264,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,265,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,266,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,267,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,268,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,269,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,270,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,271,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,272,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,273,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,274,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,275,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,276,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,277,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,278,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,279,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,280,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,281,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,282,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,283,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,284,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,285,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,286,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,287,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,288,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,289,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,290,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,291,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,292,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,293,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,294,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,295,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,296,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,297,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,298,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,299,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,300,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,301,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,302,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,303,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,304,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,305,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,306,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,307,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,308,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,309,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,310,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,311,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,312,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,313,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,314,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,315,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,316,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,317,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,318,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,319,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,320,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,321,"",{"$f":"IF(B357<=$C$18,WEEKDAY(C357,2),\"\")","v":""},"","","","",{"$f":"IF(B357>C$18,\"\",N357-M357-L357-K357-J357)","v":""},{"$f":"IF(B357>C$18,\"\",((1+C$24)^(F357/360)-1)*H357)","v":""},"",{"$f":"IF(B357>C$18,\"\",C$26*C$27)","v":""},{"$f":"IF(B357>C$18,\"\",C$28)","v":""},{"$f":"IF(B357>C$18,\"\",IF(B357=C$18,H357+J357+K357+L357+M357,IF(AND(C$22=2,MONTH(E357)=7),2*C$29,IF(AND(C$23=2,MONTH(E357)=12),2*C$29,C$29))))","v":""},{"$f":"IF(B357>C$18,\"\",H357-I357)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E357)=7,C$22=2),2/(1+C$25)^(G357/360),IF(AND(MONTH(E357)=12,C$23=2),2/(1+C$25)^(G357/360),1/(1+C$25)^(G357/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$25)^(G357/360),\"\")","v":""},null,"",{"$f":"G357","v":""},{"$f":"IFERROR((1+C$31)^(T357/360),\"\")","v":""},{"$f":"IFERROR(ROUND(S357/U357,2),\"\")","v":""},0,0]
[null,322,{"$f":"IF(B358>$C$18,\"\",EDATE(C357,1))","v":""},"",{"$f":"IF(D358=7,C358+1,C358)","v":""},{"$f":"IF(B358>C$18,\"\",E358-E357)","v":""},{"$f":"IFERROR(F358+G357,\"\")","v":""},{"$f":"IF(B358>C$18,\"\",O357)","v":""},"","",{"$f":"IF(B358>C$18,\"\",((1+C$13)^(F358/30)-1)*H358)","v":""},"","","","","","",null,{"$f":"IFERROR(I358+J358+K358+L358+M358,\"\")","v":""},"","","",{"$f":"IF(N358=\"\",0,K358/((1+$H$9)^B358))","v":0},0]
[null,323,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(N359=\"\",0,K359/((1+$P$29)^B359))","v":0}]
[null,324,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,325,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,326,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,327,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,328,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,329,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,330,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,331,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,332,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,333,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,334,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,335,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,336,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,337,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,338,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,339,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,340,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,341,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,342,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,343,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,344,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,345,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,346,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,347,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,348,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,349,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,350,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,351,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,352,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,353,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,354,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,355,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,356,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,357,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,358,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,359,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,360,"","","","","","","","","","","","","","","",null,"","","","",0,0]

{"sheet":"TarifarioBD","index":2,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["TARIFA","PRODUCTO","TIPO_SEGURO","Plazo","Valor",null,"TARIFA","PRODUCTO","TIPO_SEGURO"]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Vida","0-12",5.3999999999999999E-2,null,"TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Vida"]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Vida","13-18",5.8999999999999997E-2,null,null,null,"Seguro de Desgravamen"]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Vida","19-24",6.4000000000000001E-2,null,null,null,"Seguro de Desgravamen con Devolución"]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Vida","25-36",6.8000000000000005E-2]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Vida","37-48",7.3999999999999996E-2]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Vida","49-84",8.1000000000000003E-2]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen","0-12",8.3140000000000002E-3]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen","13-18",8.3140000000000002E-3]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen","19-24",8.3140000000000002E-3]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen","25-36",8.3140000000000002E-3]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen","37-48",8.3140000000000002E-3]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen","49-84",8.3140000000000002E-3]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen con Devolución","0-12",1.0843999999999999E-2]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen con Devolución","13-18",1.0843999999999999E-2]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen con Devolución","19-24",1.0843999999999999E-2]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen con Devolución","25-36",1.0843999999999999E-2]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen con Devolución","37-48",1.0843999999999999E-2]
["TARIFA TITULAR","Préstamos Personales (LD )","Seguro de Desgravamen con Devolución","49-84",1.0843999999999999E-2]

{"sheet":"CostoCapBD","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["TARIFA","CostoCapital"]
["TARIFA TITULAR",2.8709999999999999E-3]