{"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":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":"whole","date_system":"1900"}

{"sheet":"Vista Principal","index":0,"n_rows":395,"n_cols":21,"rows_kept":395,"cut":false,"hidden":false,"merged":[[1,2,3,8]]}
[]
[null,null,"Calculadora de Seguros PP - Scotiabank"]
[]
[]
[]
[]
[null,"1) Establecer los datos del préstamos"]
[]
[null,"Producto","Préstamos Personales (DXP)"]
[null,"Tipo de Seguro","Seguro de Vida","Seleccionar"]
[null,"Tarifa","TARIFA TITULAR"]
[null,"Monto inicial",10000,"Digitar"]
[null,"Seguro Desempleo",0,"Digitar en caso aplique"]
[null,"Monto adicional desempleo",{"$f":"+H17","v":0}]
[null,"Prima de Seguro de Desgravamen/Vida",{"$f":"IF(C10=\"Seguro de vida\",'Proceso Prima de Seguro'!D13, IF(AND(C10=\"Sin Seguro (Solo LD Garantía Liquida)\",C9=\"Préstamos Personales (LD Garantía Liquida)\"),0%, 'Proceso Prima de Seguro'!H16))","v":4.2000000000000003E-2}]
[null,"Monto adicional del Seguro",{"$f":"+C15*C12","v":420}]
[null,"MAF Inicial",{"$f":"C12+C14+C16","v":10420},null,null,null,{"$f":"+C12+C16","v":10420},{"$f":"+G17*C13","v":0},{"$f":"+H17+G17","v":10420}]
[null,"Empleado",{"$f":"IF(C9=\"Préstamos Personales (LD Y PA) (Empleados)\",\"SI\",\"NO\")","v":"NO"}]
[null,"Moneda","Soles","Seleccionar"]
[null,"Plazo Remanente",36,"Digitar"]
[null,"Fecha de Desembolso",{"$f":"TODAY()","v":"2022-08-09"}]
[null,"Fecha de 1er Pago","2022-08-31","Digitar"]
[null,"Cuota Julio",1,"Digitar 2 en caso de cuota doble"]
[null,"Cuota Diciembre",1,"Digitar 2 en caso de cuota doble"]
[null,"TEA",0.3,"Digitar"]
[null,"TEA TOTAL",{"$f":"+C25","v":0.3}]
[null,"Monto del Bien",0]
[null,"Seguro del Bien",0]
[null,"Portes",0,"Digitar"]
[null,"Cuota",{"$f":"(C17+(C28*C27+C29)*P34)/O34","v":421.66577737416873}]
[null,"2) Calcular TCEA presionando el botón "]
[null,"TCEA",0.38210870284211923]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C17-U34-C14-C16","v":384.6200000000008}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O36:O395)","v":24.711514567030477},{"$f":"SUM(P36:P395)","v":24.711514567030477},null,null,null,null,{"$f":"SUM(U36:U395)","v":9615.3799999999992}]
[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":"C22","v":"2022-08-31"},{"$f":"IF(B36<=$C$20,WEEKDAY(C36,2),\"\")","v":3},{"$f":"IF(D36=7,C36+1,C36)","v":"2022-08-31"},{"$f":"E36-C21","v":22},{"$f":"F36","v":22},{"$f":"C17","v":10420},{"$f":"IF(B36>C$20,\"\",M36-L36-K36-J36)","v":253.25152776993846},{"$f":"IF(B36>C$20,\"\",((1+C$25)^(F36/360)-1)*H36)","v":168.41424960423026},{"$f":"IF(B36>C$20,\"\",C$27*C$28)","v":0},{"$f":"IF(B36>C$20,\"\",C$29)","v":0},{"$f":"IF(B36>C$20,\"\",IF(B36=C$20,H36+J36+K36+L36,IF(AND(C$23=2,MONTH(E36)=7),2*C$30,IF(AND(C$24=2,MONTH(E36)=12),2*C$30,C$30))))","v":421.66577737416873},{"$f":"IF(B36>C$20,\"\",H36-I36)","v":10166.748472230061},{"$f":"IFERROR(IF(AND(MONTH(E36)=7,C$23=2),2/(1+C$26)^(G36/360),IF(AND(MONTH(E36)=12,C$24=2),2/(1+C$26)^(G36/360),1/(1+C$26)^(G36/360))),\"\")","v":0.9840944785844089},{"$f":"IFERROR(1/(1+C$26)^(G36/360),\"\")","v":0.9840944785844089},null,{"$f":"IFERROR(I36+J36+K36+L36,\"\")","v":421.66577737416873},{"$f":"G36","v":22},{"$f":"IFERROR((1+C$32)^(S36/360),\"\")","v":1.0199730341033582},{"$f":"IFERROR(ROUND(R36/T36,2),\"\")","v":413.41}]
[null,2,{"$f":"IF(B37>$C$20,\"\",EDATE(C36,1))","v":"2022-09-30"},5,{"$f":"IF(D37=7,C37+1,C37)","v":"2022-09-30"},{"$f":"IF(B37>C$20,\"\",E37-E36)","v":30},{"$f":"IFERROR(F37+G36,\"\")","v":52},{"$f":"IF(B37>C$20,\"\",N36)","v":10166.748472230061},{"$f":"IF(B37>C$20,\"\",M37-L37-K37-J37)","v":196.93538807203964},224.73038930212908,0,0,{"$f":"IF(B37>C$20,\"\",IF(B37=C$20,H37+J37+K37+L37,IF(AND(C$23=2,MONTH(E37)=7),2*C$30,IF(AND(C$24=2,MONTH(E37)=12),2*C$30,C$30))))","v":421.66577737416873},9969.8130841580223,0.96281204725492442,0.96281204725492442,null,{"$f":"IFERROR(I37+J37+K37+L37,\"\")","v":421.66577737416873},52,1.0478534321811137,402.41]
[null,3,"2022-10-30",7,"2022-10-31",31,83,9969.8130841580223,193.85932481990841,227.80645255426032,0,0,421.66577737416873,9775.9537593381137,0.94130361617725722,0.94130361617725722,null,421.66577737416873,83,1.0774640418254866,391.35]
[null,4,"2022-11-30",3,"2022-11-30",30,113,9775.9537593381137,205.573690495406,216.09208687876273,0,0,421.66577737416873,9570.3800688427073,0.92094659761100595,0.92094659761100595,null,421.66577737416873,113,1.1069159247637153,380.94]
[null,5,"2022-12-30",5,"2022-12-30",30,143,9570.3800688427073,210.11778398030899,211.54799339385974,0,0,421.66577737416873,9360.2622848623978,0.90102982828823464,0.90102982828823464,null,421.66577737416873,143,1.1371728586130976,370.8]
[null,6,"2023-01-30",1,"2023-01-30",31,174,9360.2622848623978,207.7873296949243,213.87844767924443,0,0,421.66577737416873,9152.474955167474,0.88090156128543429,0.88090156128543429,null,421.66577737416873,174,1.1693074879233045,360.61]
[null,7,"2023-02-28",2,"2023-02-28",29,203,9152.474955167474,226.17053371731157,195.49524365685716,0,0,421.66577737416873,8926.3044214501624,0.86247915923468099,0.86247915923468099,null,421.66577737416873,203,1.2001905030402245,351.33]
[null,8,"2023-03-28",2,"2023-03-28",28,231,8926.3044214501624,237.64342785979554,184.02234951437319,0,0,421.66577737416873,8688.6609935903671,0.84505767202794468,0.84505767202794468,null,421.66577737416873,231,1.2307823115153482,342.6]
[null,9,"2023-04-28",5,"2023-04-28",31,262,8688.6609935903671,223.13316480778616,198.53261256638257,0,0,421.66577737416873,8465.5278287825804,0.82617977706673362,0.82617977706673362,null,421.66577737416873,262,1.2655621895633888,333.18]
[null,10,"2023-05-28",7,"2023-05-29",31,293,8465.5278287825804,228.23167310407885,193.43410427008988,0,0,421.66577737416873,8237.2961556785012,0.80772359878825672,0.80772359878825672,null,421.66577737416873,293,1.3013248895984852,324.02999999999997]
[null,11,"2023-06-28",3,"2023-06-28",30,323,8237.2961556785012,239.58487147599129,182.08090589817743,0,0,421.66577737416873,7997.7112842025099,0.79025543653503172,0.79025543653503172,null,421.66577737416873,323,1.3368958848477777,315.41000000000003]
[null,12,"2023-07-28",5,"2023-07-28",30,353,7997.7112842025099,244.88076343051017,176.78501394365856,0,0,421.66577737416873,7752.8305207719995,0.77316504793230156,0.77316504793230156,null,421.66577737416873,353,1.373439193554792,307.01]
[null,13,"2023-08-28",1,"2023-08-28",31,384,7752.8305207719995,244.5165366328491,177.14924074131963,0,0,421.66577737416873,7508.3139841391503,0.75589317520020838,0.75589317520020838,null,421.66577737416873,384,1.4122503197883358,298.58]
[null,14,"2023-09-28",4,"2023-09-28",31,415,7508.3139841391503,250.10364687563731,171.56213049853142,0,0,421.66577737416873,7258.2103372635129,0.73900714193210981,0.73900714193210981,null,421.66577737416873,415,1.4521581844334415,290.37]
[null,15,"2023-10-28",6,"2023-10-28",30,445,7258.2103372635129,261.22702557605538,160.43875179811334,0,0,421.66577737416873,6996.9833116874579,0.72302506999447136,0.72302506999447136,null,421.66577737416873,445,1.4918521242732004,282.64999999999998]
[null,16,"2023-11-28",2,"2023-11-28",31,476,6996.9833116874579,261.78735905661063,159.87841831755807,0,0,421.66577737416873,6735.1959526308474,0.70687328322597431,0.70687328322597431,null,421.66577737416867,476,1.5340094046163417,274.88]
[null,17,"2023-12-28",4,"2023-12-28",30,506,6735.1959526308474,272.78797120091855,148.87780617325018,0,0,421.66577737416873,6462.4079814299284,0.69158615131304624,0.69158615131304624,null,421.66577737416873,506,1.5759407022347356,267.56]
[null,18,"2024-01-28",7,"2024-01-29",32,538,6462.4079814299284,269.18309545857653,152.48268191559222,0,0,421.66577737416873,6193.2248859713518,0.67564410230651561,0.67564410230651561,null,421.66577737416878,538,1.6219315149627134,259.98]
[null,19,"2024-02-28",3,"2024-02-28",30,568,6193.2248859713518,284.76794386706263,136.89783350710607,0,0,421.66577737416873,5908.4569421042888,0.66103234548496137,0.66103234548496137,null,421.66577737416867,568,1.6662661147806093,253.06]
[null,20,"2024-03-28",4,"2024-03-28",29,597,5908.4569421042888,295.46218378983741,126.20359358433133,0,0,421.66577737416873,5612.9947583144512,0.64720809522559486,0.64720809522559486,null,421.66577737416873,597,1.7102744890902384,246.55]
[null,21,"2024-04-28",7,"2024-04-29",32,629,5612.9947583144512,289.22528510172504,132.44049227244372,0,0,421.66577737416873,5323.7694732127266,0.63228902382441043,0.63228902382441043,null,421.66577737416878,629,1.7601855762457694,239.56]
[null,22,"2024-05-28",2,"2024-05-28",29,658,5323.7694732127266,307.95100454640567,113.71477282776303,0,0,421.66577737416873,5015.8184686663208,0.61906588616510805,0.61906588616510805,null,421.66577737416867,658,1.8066744923958966,233.39]
[null,23,"2024-06-28",5,"2024-06-28",31,689,5015.8184686663208,307.05622528350227,114.60955209066645,0,0,421.66577737416873,4708.7622433828183,0.60523646225721239,0.60523646225721239,null,421.66577737416873,689,1.8577281335882785,226.98]
[null,24,"2024-07-28",7,"2024-07-29",31,720,4708.7622433828183,314.0723437228425,107.59343365132624,0,0,421.66577737416873,4394.6898996599757,0.59171597633136086,0.59171597633136086,null,421.66577737416873,720,1.9102244664719257,220.74]
[null,25,"2024-08-28",3,"2024-08-28",30,750,4394.6898996599757,324.52357161287205,97.142205761296651,0,0,421.66577737416873,4070.1663280471039,0.57891928362869893,0.57891928362869893,null,421.66577737416867,750,1.9624393944772758,214.87]
[null,26,"2024-09-28",6,"2024-09-28",31,781,4070.1663280471039,328.66401849751111,93.001758876657604,0,0,421.66577737416873,3741.5023095495926,0.5659867018782303,0.5659867018782303,null,421.66577737416873,781,2.017894694880932,208.96]
[null,27,"2024-10-28",1,"2024-10-28",30,811,3741.5023095495926,338.96192442683008,82.70385294733866,0,0,421.66577737416873,3402.5403851227625,0.5537464410310684,0.5537464410310684,null,421.66577737416873,811,2.0730527289575176,203.4]
[null,28,"2024-11-28",4,"2024-11-28",31,842,3402.5403851227625,343.91901840643186,77.746758967736881,0,0,421.66577737416873,3058.6213667163306,0.54137619992806441,0.54137619992806441,null,421.66577737416873,842,2.1316337797458815,197.81]
[null,29,"2024-12-28",6,"2024-12-28",30,872,3058.6213667163306,354.05663248900976,67.609144885158997,0,0,421.66577737416873,2704.564734227321,0.52966817590281023,0.52966817590281023,null,421.66577737416878,872,2.1899008087242997,192.55]
[null,30,"2025-01-28",2,"2025-01-28",31,903,2704.564734227321,359.86749764646862,61.798279727700091,0,0,421.66577737416873,2344.6972365808524,0.5178358234847863,0.5178358234847863,null,421.66577737416873,903,2.2517837935154628,187.26]
[null,31,"2025-02-28",5,"2025-02-28",31,934,2344.6972365808524,368.09033365516837,53.575443719000333,0,0,421.66577737416873,1976.6069029256842,0.50626779611046679,0.50626779611046679,null,421.66577737416867,934,2.3154154893858707,182.11]
[null,32,"2025-03-28",5,"2025-03-28",28,962,1976.6069029256842,380.91656816406874,40.749209210099963,0,0,421.66577737416873,1595.6903347616153,0.4960415340162645,0.4960415340162645,null,421.66577737416867,962,2.3744334094678905,177.59]
[null,33,"2025-04-28",1,"2025-04-28",31,993,1595.6903347616153,385.20485764892567,36.460919725243066,0,0,421.66577737416873,1210.4854771126898,0.48496037318485635,0.48496037318485635,null,421.66577737416873,993,2.4415309811845418,172.71]
[null,34,"2025-05-28",3,"2025-05-28",30,1023,1210.4854771126898,394.90866095104172,26.757116423126991,0,0,421.66577737416873,815.57681616164803,0.47447242099689713,0.47447242099689713,null,421.66577737416873,1023,2.5082688785588956,168.11]
[null,35,"2025-06-28",6,"2025-06-28",31,1054,815.57681616164803,403.03015605339311,18.635621320775638,0,0,421.66577737416873,412.54666010825491,0.46387309645130009,0.46387309645130009,null,421.66577737416873,1054,2.5791484198813301,163.49]
[null,36,"2025-07-28",1,"2025-07-28",30,1084,412.54666010825491,412.54666010825491,9.1191172659241619,0,0,421.66577737417907,0,0.45384118636983994,0.45384118636983994,null,421.66577737417907,1084,2.6496480137368859,159.13999999999999]
[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<=$C$20,WEEKDAY(C100,2),\"\")","v":""},"","","","","",{"$f":"IF(B100>C$20,\"\",((1+C$25)^(F100/360)-1)*H100)","v":""},{"$f":"IF(B100>C$20,\"\",C$27*C$28)","v":""},{"$f":"IF(B100>C$20,\"\",C$29)","v":""},"",{"$f":"IF(B100>C$20,\"\",H100-I100)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E100)=7,C$23=2),2/(1+C$26)^(G100/360),IF(AND(MONTH(E100)=12,C$24=2),2/(1+C$26)^(G100/360),1/(1+C$26)^(G100/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$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>$C$20,\"\",EDATE(C100,1))","v":""},"",{"$f":"IF(D101=7,C101+1,C101)","v":""},{"$f":"IF(B101>C$20,\"\",E101-E100)","v":""},{"$f":"IFERROR(F101+G100,\"\")","v":""},{"$f":"IF(B101>C$20,\"\",N100)","v":""},{"$f":"IF(B101>C$20,\"\",M101-L101-K101-J101)","v":""},"","","",{"$f":"IF(B101>C$20,\"\",IF(B101=C$20,H101+J101+K101+L101,IF(AND(C$23=2,MONTH(E101)=7),2*C$30,IF(AND(C$24=2,MONTH(E101)=12),2*C$30,C$30))))","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<=$C$20,WEEKDAY(C164,2),\"\")","v":""},"","","","","",{"$f":"IF(B164>C$20,\"\",((1+C$25)^(F164/360)-1)*H164)","v":""},{"$f":"IF(B164>C$20,\"\",C$27*C$28)","v":""},{"$f":"IF(B164>C$20,\"\",C$29)","v":""},"",{"$f":"IF(B164>C$20,\"\",H164-I164)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E164)=7,C$23=2),2/(1+C$26)^(G164/360),IF(AND(MONTH(E164)=12,C$24=2),2/(1+C$26)^(G164/360),1/(1+C$26)^(G164/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$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>$C$20,\"\",EDATE(C164,1))","v":""},"",{"$f":"IF(D165=7,C165+1,C165)","v":""},{"$f":"IF(B165>C$20,\"\",E165-E164)","v":""},{"$f":"IFERROR(F165+G164,\"\")","v":""},{"$f":"IF(B165>C$20,\"\",N164)","v":""},{"$f":"IF(B165>C$20,\"\",M165-L165-K165-J165)","v":""},"","","",{"$f":"IF(B165>C$20,\"\",IF(B165=C$20,H165+J165+K165+L165,IF(AND(C$23=2,MONTH(E165)=7),2*C$30,IF(AND(C$24=2,MONTH(E165)=12),2*C$30,C$30))))","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<=$C$20,WEEKDAY(C228,2),\"\")","v":""},"","","","","",{"$f":"IF(B228>C$20,\"\",((1+C$25)^(F228/360)-1)*H228)","v":""},{"$f":"IF(B228>C$20,\"\",C$27*C$28)","v":""},{"$f":"IF(B228>C$20,\"\",C$29)","v":""},"",{"$f":"IF(B228>C$20,\"\",H228-I228)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E228)=7,C$23=2),2/(1+C$26)^(G228/360),IF(AND(MONTH(E228)=12,C$24=2),2/(1+C$26)^(G228/360),1/(1+C$26)^(G228/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$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>$C$20,\"\",EDATE(C228,1))","v":""},"",{"$f":"IF(D229=7,C229+1,C229)","v":""},{"$f":"IF(B229>C$20,\"\",E229-E228)","v":""},{"$f":"IFERROR(F229+G228,\"\")","v":""},{"$f":"IF(B229>C$20,\"\",N228)","v":""},{"$f":"IF(B229>C$20,\"\",M229-L229-K229-J229)","v":""},"","","",{"$f":"IF(B229>C$20,\"\",IF(B229=C$20,H229+J229+K229+L229,IF(AND(C$23=2,MONTH(E229)=7),2*C$30,IF(AND(C$24=2,MONTH(E229)=12),2*C$30,C$30))))","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<=$C$20,WEEKDAY(C292,2),\"\")","v":""},"","","","","",{"$f":"IF(B292>C$20,\"\",((1+C$25)^(F292/360)-1)*H292)","v":""},{"$f":"IF(B292>C$20,\"\",C$27*C$28)","v":""},{"$f":"IF(B292>C$20,\"\",C$29)","v":""},"",{"$f":"IF(B292>C$20,\"\",H292-I292)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E292)=7,C$23=2),2/(1+C$26)^(G292/360),IF(AND(MONTH(E292)=12,C$24=2),2/(1+C$26)^(G292/360),1/(1+C$26)^(G292/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$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>$C$20,\"\",EDATE(C292,1))","v":""},"",{"$f":"IF(D293=7,C293+1,C293)","v":""},{"$f":"IF(B293>C$20,\"\",E293-E292)","v":""},{"$f":"IFERROR(F293+G292,\"\")","v":""},{"$f":"IF(B293>C$20,\"\",N292)","v":""},{"$f":"IF(B293>C$20,\"\",M293-L293-K293-J293)","v":""},"","","",{"$f":"IF(B293>C$20,\"\",IF(B293=C$20,H293+J293+K293+L293,IF(AND(C$23=2,MONTH(E293)=7),2*C$30,IF(AND(C$24=2,MONTH(E293)=12),2*C$30,C$30))))","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<=$C$20,WEEKDAY(C356,2),\"\")","v":""},"","","","","",{"$f":"IF(B356>C$20,\"\",((1+C$25)^(F356/360)-1)*H356)","v":""},{"$f":"IF(B356>C$20,\"\",C$27*C$28)","v":""},{"$f":"IF(B356>C$20,\"\",C$29)","v":""},"",{"$f":"IF(B356>C$20,\"\",H356-I356)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E356)=7,C$23=2),2/(1+C$26)^(G356/360),IF(AND(MONTH(E356)=12,C$24=2),2/(1+C$26)^(G356/360),1/(1+C$26)^(G356/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$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>$C$20,\"\",EDATE(C356,1))","v":""},"",{"$f":"IF(D357=7,C357+1,C357)","v":""},{"$f":"IF(B357>C$20,\"\",E357-E356)","v":""},{"$f":"IFERROR(F357+G356,\"\")","v":""},{"$f":"IF(B357>C$20,\"\",N356)","v":""},{"$f":"IF(B357>C$20,\"\",M357-L357-K357-J357)","v":""},"","","",{"$f":"IF(B357>C$20,\"\",IF(B357=C$20,H357+J357+K357+L357,IF(AND(C$23=2,MONTH(E357)=7),2*C$30,IF(AND(C$24=2,MONTH(E357)=12),2*C$30,C$30))))","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,"","","",""]

{"sheet":"Proceso Prima de Seguro","index":1,"n_rows":395,"n_cols":25,"rows_kept":395,"cut":false,"hidden":true,"merged":[[1,3,3,9]]}
[]
[null,null,null,"Proceso de Cálculo de la Prima de Seguros"]
[]
[]
[]
[]
[null,"1) Datos esenciales del préstamo",null,null,null,null,"3) Calculo del valor presente del Seguro"]
[]
[null,"Producto",null,{"$f":"'Vista Principal'!C9","v":"Préstamos Personales (DXP)"},null,null,"Suma de Prima Mensual",{"$f":"SUM(L36:L395)","v":10207.370161000768}]
[null,"Tipo de Seguro",null,{"$f":"'Vista Principal'!C10","v":"Seguro de Vida"},null,null,"VPN - Valor Presente",{"$f":"NPV(D16,L36:L395)","v":9787.2020396193147}]
[null,"Tarifa",null,{"$f":"'Vista Principal'!C11","v":"TARIFA TITULAR"}]
[null,"Monto inicial",null,{"$f":"'Vista Principal'!C12","v":10000},null,null,"4) Calculo del Monto Adicional del Seguro y MAF"]
[null,{"$f":"D10","v":"Seguro de Vida"},{"$f":"+CONCATENATE(D9,D10,D11)","v":"Préstamos Personales (DXP)Seguro de VidaTARIFA TITULAR"},{"$f":"VLOOKUP(C13,CAPUCCI,2,0)","v":4.2000000000000003E-2}]
[null,"Monto adicional Seguro de Desgravamen/ Vida",null,null,null,null,"Monto inicial",{"$f":"D12","v":10000}]
[null,"MAF Inicial",null,{"$f":"D12+D14","v":10000},null,null,"Monto adicional de Desgravamen / Vida",{"$f":"H10","v":9787.2020396193147}]
[null,"Costo Capital",null,{"$f":"INDEX(_xlfn._xlws.FILTER(Tabla2[],Tabla2[TARIFA]=D11),0,2)","v":2.8709999999999999E-3},null,null,"Prima de Seguro de Desgravamen / Vida",{"$f":"H15/H14","v":0.97872020396193149}]
[null,"Moneda",null,{"$f":"'Vista Principal'!C19","v":"Soles"},null,null,"MAF Inicial",{"$f":"H14+H15","v":19787.202039619315}]
[null,"Plazo Remanente Meses",null,{"$f":"'Vista Principal'!C20","v":36}]
[null,"Fecha de Desembolso",null,{"$f":"'Vista Principal'!C21","v":"2022-08-09"}]
[null,"Fecha de 1er Pago",null,{"$f":"'Vista Principal'!C22","v":"2022-08-31"}]
[null,"Cuota Julio",null,{"$f":"'Vista Principal'!C23","v":1}]
[null,"Cuota Diciembre",null,{"$f":"'Vista Principal'!C24","v":1}]
[null,"TEA",null,{"$f":"'Vista Principal'!C25","v":0.3}]
[null,"TEA TOTAL",null,{"$f":"(1+(((1+D23)^(30/360)-1)+D13))^12-1","v":1.1077112590863156}]
[null,"Monto del Bien",null,0]
[null,"Seguro del Bien",null,0]
[null,"Portes",null,0]
[null,"Cuota",null,{"$f":"(D15+(D26*D25+D27)*R34)/Q34","v":710.34533611504651}]
[]
[null,"TCEA",null,0.23730675268258045]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D15-W34-D14","v":-8771.6200000000026}]
[]
[null,"2) Creación de Cronograma de prima mensual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q36:Q395)","v":14.077659824855125},{"$f":"SUM(R36:R395)","v":14.077659824855125},null,null,null,null,{"$f":"SUM(W36:W395)","v":18771.620000000003}]
[null,"N° Cuota",null,"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,null,{"$f":"D20","v":"2022-08-31"},{"$f":"IF(B36<=$D$18,WEEKDAY(D36,2),\"\")","v":3},{"$f":"IF(E36=7,D36+1,D36)","v":"2022-08-31"},{"$f":"F36-D19","v":22},{"$f":"G36","v":22},{"$f":"D15","v":10000},{"$f":"IF(B36>D$18,\"\",O36-N36-M36-L36-K36)","v":242.41429890940432},{"$f":"IF(B36>D$18,\"\",((1+D$23)^(G36/360)-1)*I36)","v":161.62595931308087},{"$f":"IF(B36>D$18,\"\",((1+D$13)^(G36/30)-1)*I36)","v":306.30507789256131},{"$f":"IF(B36>D$18,\"\",D$25*D$26)","v":0},{"$f":"IF(B36>D$18,\"\",D$27)","v":0},{"$f":"IF(B36>D$18,\"\",IF(B36=D$18,I36+K36+L36+M36+N36,IF(AND(D$21=2,MONTH(F36)=7),2*D$28,IF(AND(D$22=2,MONTH(F36)=12),2*D$28,D$28))))","v":710.34533611504651},{"$f":"IF(B36>D$18,\"\",I36-J36)","v":9757.5857010905966},{"$f":"IFERROR(IF(AND(MONTH(F36)=7,D$21=2),2/(1+D$24)^(H36/360),IF(AND(MONTH(F36)=12,D$22=2),2/(1+D$24)^(H36/360),1/(1+D$24)^(H36/360))),\"\")","v":0.9554578720451361},{"$f":"IFERROR(1/(1+D$24)^(H36/360),\"\")","v":0.9554578720451361},null,{"$f":"IFERROR(J36+K36+L36+M36+N36,\"\")","v":710.34533611504651},{"$f":"H36","v":22},{"$f":"IFERROR((1+D$30)^(U36/360),\"\")","v":1.0130978545269156},{"$f":"IFERROR(ROUND(T36/V36,2),\"\")","v":701.16},{"$f":"L36/(1+$I$9)","v":306.30507789256131},{"$f":"L36/(1+$Q$28)","v":306.30507789256131}]
[null,2,null,{"$f":"IF(B37>$D$18,\"\",EDATE(D36,1))","v":"2022-09-30"},5,{"$f":"IF(E37=7,D37+1,D37)","v":"2022-09-30"},{"$f":"IF(B37>D$18,\"\",F37-F36)","v":30},{"$f":"IFERROR(G37+H36,\"\")","v":52},{"$f":"IF(B37>D$18,\"\",P36)","v":9757.5857010905966},84.840665626511253,215.68607104272982,{"$f":"IF(B37>D$18,\"\",((1+D$13)^(G37/30)-1)*I37)","v":409.81859944580543},0,0,710.34533611504651,9672.745035464086,0.89789857707307708,0.89789857707307708,null,710.34533611504651,52,1.0312354742542889,688.83,{"$f":"IF(O37=\"\",0,L37/((1+$I$9)^B37))","v":409.81859944580543},{"$f":"IF(O37=\"\",0,L37/((1+$Q$28)^B37))","v":409.81859944580543}]
[null,3,null,"2022-10-30",7,"2022-10-31",31,83,9672.745035464086,69.239680162074961,221.01856016661711,420.08709578635444,0,0,710.34533611504651,9603.5053553020116,0.84206099006902324,0.84206099006902324,null,710.34533611504651,83,1.0503188853927408,676.31,420.08709578635444,420.08709578635444]
[null,4,null,"2022-11-30",3,"2022-11-30",30,113,9603.5053553020116,94.717901540562849,212.2802096517988,403.34722492268486,0,0,710.34533611504651,9508.787453761448,0.79133302148983142,0.79133302148983142,null,710.34533611504651,113,1.0691228779691815,664.42,403.34722492268486,403.34722492268486]
[null,5,null,"2022-12-30",5,"2022-12-30",30,143,9508.787453761448,100.78974058020091,210.18652247686444,399.36907305798115,0,0,710.34533611504651,9407.9977131812466,0.74366103914740933,0.74366103914740933,null,710.34533611504651,143,1.0882635208160614,652.73,399.36907305798115,399.36907305798115]
[null,6,null,"2023-01-30",1,"2023-01-30",31,174,9407.9977131812466,86.787026348874235,214.96918413485105,408.58912563132122,0,0,710.34533611504651,9321.2106868323717,0.69741501645041704,0.69741501645041704,null,710.34533611504651,174,1.1084022580038309,640.87,408.58912563132122,408.58912563132122]
[null,7,null,"2023-02-28",2,"2023-02-28",29,203,9321.2106868323717,133.06592948968813,199.09940899323129,378.17999763212708,0,0,710.34533611504651,9188.1447573426831,0.65675972128868354,0.65675972128868354,null,710.34533611504651,203,1.127578973595361,629.97,378.17999763212708,378.17999763212708]
[null,8,null,"2023-03-28",2,"2023-03-28",28,231,9188.1447573426831,161.24655508946822,189.42038116706763,359.67839985851066,0,0,710.34533611504651,9026.8982022532145,0.61975665778255851,0.61975665778255851,null,710.34533611504651,231,1.1464091776391623,619.63,359.67839985851066,359.67839985851066]
[null,9,null,"2023-04-28",5,"2023-04-28",31,262,9026.8982022532145,112.04614886694753,206.26120466504233,392.03798258305665,0,0,710.34533611504651,8914.8520533862666,0.58121587246014372,0.58121587246014372,null,710.34533611504651,262,1.1676239226862162,608.37,392.03798258305665,392.03798258305665]
[null,10,null,"2023-05-28",7,"2023-05-29",31,293,8914.8520533862666,119.47252261121349,203.70099260486791,387.17182089896511,0,0,710.34533611504651,8795.3795307750534,0.54507182158925216,0.54507182158925216,null,710.34533611504651,293,1.1892312547922279,597.30999999999995,387.17182089896511,387.17182089896511]
[null,11,null,"2023-06-28",3,"2023-06-28",30,323,8795.3795307750534,146.5223635323764,194.41703229011756,369.40594029255254,0,0,710.34533611504651,8648.857167242677,0.51223526157153199,0.51223526157153199,null,710.34533611504651,323,1.2105222131838049,586.80999999999995,369.40594029255254,369.40594029255254]
[null,12,null,"2023-07-28",5,"2023-07-28",30,353,8648.857167242677,155.91509914629745,191.17823594455632,363.25200102419274,0,0,710.34533611504651,8492.9420680963794,0.48137686228619664,0.48137686228619664,null,710.34533611504651,353,1.232194346311082,576.49,363.25200102419274,363.25200102419274]
[null,13,null,"2023-08-28",1,"2023-08-28",31,384,{"$f":"IF(B48>D$18,\"\",P47)","v":8492.9420680963794},{"$f":"IF(B48>D$18,\"\",O48-N48-M48-L48-K48)","v":147.43654697871855},{"$f":"IF(B48>D$18,\"\",((1+D$23)^(G48/360)-1)*I48)","v":194.06050925429903},368.84827988202892,0,0,710.34533611504651,{"$f":"IF(B48>D$18,\"\",I48-J48)","v":8345.5055211176605},0.45144149640415848,0.45144149640415848,null,{"$f":"IFERROR(J48+K48+L48+M48+N48,\"\")","v":710.34533611504651},384,1.2549965790699329,566.01,368.84827988202892,{"$f":"IF(O48=\"\",0,L48/((1+$Q$28)^B48))","v":368.84827988202892}]
[null,14,null,"2023-09-28",4,"2023-09-28",31,415,8345.5055211176605,157.20858209550047,190.69164000263359,362.44511401691244,0,0,710.34533611504651,8188.2969390221597,0.42336772005975537,0.42336772005975537,null,710.34533611504651,415,1.2782207759615891,555.73,362.44511401691244,362.44511401691244]
[null,15,null,"2023-10-28",6,"2023-10-28",30,445,8188.2969390221597,185.43905954164404,180.99780513447143,343.90847143893103,0,0,710.34533611504651,8002.8578794805153,0.39786293518796717,0.39786293518796717,null,710.34533611504651,445,1.3011049250676452,545.96,343.90847143893103,343.90847143893103]
[null,16,null,"2023-11-28",2,"2023-11-28",31,476,8002.8578794805153,179.91913016092676,182.86227118111836,347.56393477300139,0,0,710.34533611504651,7822.9387493195882,0.37312104693187492,0.37312104693187492,null,710.34533611504651,476,1.3251823747280005,536.04,347.56393477300139,347.56393477300139]
[null,17,null,"2023-12-28",4,"2023-12-28",30,506,7822.9387493195882,208.86014556240551,172.92176308121802,328.56342747142298,0,0,710.34533611504651,7614.0786037571825,0.35064325379310973,0.35064325379310973,null,710.34533611504651,506,1.3489072833089766,526.61,328.56342747142298,328.56342747142298]
[null,18,null,"2024-01-28",7,"2024-01-29",32,538,7614.0786037571825,189.10643989201611,179.6567361815072,341.5821600415232,0,0,710.34533611504651,7424.9721638651663,0.32815745691561565,0.32815745691561565,null,710.34533611504651,538,1.3746822068990463,516.73,341.5821600415232,341.5821600415232]
[null,19,null,"2024-02-28",3,"2024-02-28",30,568,7424.9721638651663,234.3715748775785,164.12493035513074,311.84883088233727,0,0,710.34533611504651,7190.6005889875878,0.3083883886892414,0.3083883886892414,null,710.34533611504651,568,1.3992933172703781,507.65,311.84883088233727,311.84883088233727]
[null,20,null,"2024-03-28",4,"2024-03-28",29,597,7190.6005889875878,265.01845951578611,153.58995474656797,291.73692185269243,0,0,710.34533611504651,6925.5821294718016,0.29041111451119977,0.29041111451119977,null,710.34533611504651,597,1.4235028041968563,499.01,291.73692185269243,291.73692185269243]
[null,21,null,"2024-04-28",7,"2024-04-29",32,629,6925.5821294718016,236.23901639744835,163.41143115122421,310.69488856637395,0,0,710.34533611504651,6689.3431130743529,0.27178784068167255,0.27178784068167255,null,710.34533611504651,629,1.4507030991781531,489.66,310.69488856637395,310.69488856637395]
[null,22,null,"2024-05-28",2,"2024-05-28",29,658,6689.3431130743529,296.06223998418488,142.8831838601694,271.3999122706922,0,0,710.34533611504651,6393.2808730901679,0.25594416851567586,0.25594416851567586,null,710.34533611504651,658,1.4758020382499595,481.33,271.3999122706922,271.3999122706922]
[null,23,null,"2024-06-28",5,"2024-06-28",31,689,6393.2808730901679,286.60124766793433,146.08404626922601,277.66004217788617,0,0,710.34533611504651,6106.6796254222336,0.2400277775751084,0.2400277775751084,null,710.34533611504651,689,1.5031123255296466,472.58,277.66004217788617,277.66004217788617]
[null,24,null,"2024-07-28",7,"2024-07-29",31,720,6106.6796254222336,305.59706325176518,139.53531632035646,265.21295654292487,0,0,710.34533611504651,5801.082562170468,0.22510117867411805,0.22510117867411805,null,710.34533611504651,720,1.5309280002339125,464,265.21295654292487,265.21295654292487]
[null,25,null,"2024-08-28",3,"2024-08-28",30,750,5801.082562170468,338.4701256189029,128.22974288498372,243.64546761115986,0,0,710.34533611504651,5462.6124365515652,0.21154049167686895,0.21154049167686895,null,710.34533611504639,750,1.5583363989134233,455.84,243.64546761115986,243.64546761115986]
[null,26,null,"2024-09-28",6,"2024-09-28",31,781,5462.6124365515652,348.28557784455217,124.81862501785217,237.24113325264219,0,0,710.34533611504651,5114.3268587070133,0.19838543061485983,0.19838543061485983,null,710.34533611504651,781,1.5871740164459116,447.55,237.24113325264219,237.24113325264219]
[null,27,null,"2024-10-28",1,"2024-10-28",30,811,5114.3268587070133,382.49422268145986,113.04938536789186,214.80172806569476,0,0,710.34533611504651,4731.8326360255533,0.18643417054048547,0.18643417054048547,null,710.34533611504651,811,1.6155893947065898,439.68,214.80172806569476,214.80172806569476]
[null,28,null,"2024-11-28",4,"2024-11-28",31,842,4731.8326360255533,396.72136951027676,108.12058338448688,205.50338322028287,0,0,710.34533611504651,4335.1112665152768,0.1748403953815838,0.1748403953815838,null,710.34533611504651,842,1.6454865010608906,431.69,205.50338322028287,205.50338322028287]
[null,29,null,"2024-12-28",6,"2024-12-28",30,872,4335.1112665152768,432.44541011289016,95.825252808514492,182.07467319364179,0,0,710.34533611504651,3902.6658564023865,0.1643075501507848,0.1643075501507848,null,710.34533611504639,872,1.6749458551493515,424.1,182.07467319364179,182.07467319364179]
[null,30,null,"2025-01-28",2,"2025-01-28",31,903,3902.6658564023865,451.67821063404557,89.174436546294075,169.49268893470685,0,0,710.34533611504651,3450.9876457683408,0.15408976235021374,0.15408976235021374,null,710.34533611504651,903,1.7059413757520292,416.39,169.49268893470685,169.49268893470685]
[null,31,null,"2025-02-28",5,"2025-02-28",31,934,3450.9876457683408,481.61526102113987,78.853760522377655,149.87631457152901,0,0,710.34533611504651,2969.3723847472011,0.14450738775762786,0.14450738775762786,null,710.34533611504662,934,1.7375104804466805,408.83,149.87631457152901,149.87631457152901]
[null,32,null,"2025-03-28",5,"2025-03-28",28,962,2969.3723847472011,532.89071388864886,61.215801862099653,116.23882036429806,0,0,710.34533611504651,2436.4816708585522,0.13636557291580489,0.13636557291580489,null,710.34533611504651,962,1.766526343318557,402.11,116.23882036429806,116.23882036429806]
[null,33,null,"2025-04-28",1,"2025-04-28",31,993,2436.4816708585522,548.85630956817658,55.672683275650279,105.81634327121967,0,0,710.34533611504651,1887.6253612903756,0.12788541186369065,0.12788541186369065,null,710.34533611504651,993,1.7992165962608651,394.81,105.81634327121967,105.81634327121967]
[null,34,null,"2025-05-28",3,"2025-05-28",30,1023,1887.6253612903756,589.34014940295128,41.724921537899426,79.280265174195847,0,0,710.34533611504651,1298.2852118874243,0.12018125832698952,0.12018125832698952,null,710.34533611504651,1023,1.8314281997938697,387.86,79.280265174195847,79.280265174195847]
[null,35,null,"2025-06-28",6,"2025-06-28",31,1054,1298.2852118874243,624.29551371928903,29.66532532025979,56.384497075497727,0,0,710.34533611504651,673.98969816813531,0.11270755067287465,0.11270755067287465,null,710.34533611504651,1054,1.8653194866820502,380.82,56.384497075497727,56.384497075497727]
[null,36,null,"2025-07-28",1,"2025-07-28",30,1084,673.98969816813531,673.98969816813531,14.898171983763623,28.307567323061708,0,0,717.19543747496061,0,0.10591775141058772,0.10591775141058772,null,717.19543747496061,1084,1.8987145386687085,377.73,28.307567323061708,28.307567323061708]
[null,37,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,38,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,39,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,40,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,41,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,42,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,43,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,44,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,45,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,46,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,47,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,48,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,49,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,50,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,51,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,52,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,53,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,54,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,55,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,56,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,57,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,58,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,59,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,60,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,61,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,62,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,63,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,64,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,65,null,"",{"$f":"IF(B100<=$D$18,WEEKDAY(D100,2),\"\")","v":""},"","","","",{"$f":"IF(B100>D$18,\"\",O100-N100-M100-L100-K100)","v":""},{"$f":"IF(B100>D$18,\"\",((1+D$23)^(G100/360)-1)*I100)","v":""},"",{"$f":"IF(B100>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B100>D$18,\"\",D$27)","v":""},{"$f":"IF(B100>D$18,\"\",IF(B100=D$18,I100+K100+L100+M100+N100,IF(AND(D$21=2,MONTH(F100)=7),2*D$28,IF(AND(D$22=2,MONTH(F100)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B100>D$18,\"\",I100-J100)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F100)=7,D$21=2),2/(1+D$24)^(H100/360),IF(AND(MONTH(F100)=12,D$22=2),2/(1+D$24)^(H100/360),1/(1+D$24)^(H100/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H100/360),\"\")","v":""},null,"",{"$f":"H100","v":""},{"$f":"IFERROR((1+D$30)^(U100/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T100/V100,2),\"\")","v":""},0,0]
[null,66,null,{"$f":"IF(B101>$D$18,\"\",EDATE(D100,1))","v":""},"",{"$f":"IF(E101=7,D101+1,D101)","v":""},{"$f":"IF(B101>D$18,\"\",F101-F100)","v":""},{"$f":"IFERROR(G101+H100,\"\")","v":""},{"$f":"IF(B101>D$18,\"\",P100)","v":""},"","",{"$f":"IF(B101>D$18,\"\",((1+D$13)^(G101/30)-1)*I101)","v":""},"","","","","","",null,{"$f":"IFERROR(J101+K101+L101+M101+N101,\"\")","v":""},"","","",{"$f":"IF(O101=\"\",0,L101/((1+$I$9)^B101))","v":0},0]
[null,67,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O102=\"\",0,L102/((1+$Q$28)^B102))","v":0}]
[null,68,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,69,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,70,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,71,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,72,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,73,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,74,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,75,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,76,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,77,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,78,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,79,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,80,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,81,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,82,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,83,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,84,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,85,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,86,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,87,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,88,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,89,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,90,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,91,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,92,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,93,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,94,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,95,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,96,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,97,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,98,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,99,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,100,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,101,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,102,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,103,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,104,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,105,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,106,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,107,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,108,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,109,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,110,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,111,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,112,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,113,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,114,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,115,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,116,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,117,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,118,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,119,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,120,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,121,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,122,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,123,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,124,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,125,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,126,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,127,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,128,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,129,null,"",{"$f":"IF(B164<=$D$18,WEEKDAY(D164,2),\"\")","v":""},"","","","",{"$f":"IF(B164>D$18,\"\",O164-N164-M164-L164-K164)","v":""},{"$f":"IF(B164>D$18,\"\",((1+D$23)^(G164/360)-1)*I164)","v":""},"",{"$f":"IF(B164>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B164>D$18,\"\",D$27)","v":""},{"$f":"IF(B164>D$18,\"\",IF(B164=D$18,I164+K164+L164+M164+N164,IF(AND(D$21=2,MONTH(F164)=7),2*D$28,IF(AND(D$22=2,MONTH(F164)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B164>D$18,\"\",I164-J164)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F164)=7,D$21=2),2/(1+D$24)^(H164/360),IF(AND(MONTH(F164)=12,D$22=2),2/(1+D$24)^(H164/360),1/(1+D$24)^(H164/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H164/360),\"\")","v":""},null,"",{"$f":"H164","v":""},{"$f":"IFERROR((1+D$30)^(U164/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T164/V164,2),\"\")","v":""},0,0]
[null,130,null,{"$f":"IF(B165>$D$18,\"\",EDATE(D164,1))","v":""},"",{"$f":"IF(E165=7,D165+1,D165)","v":""},{"$f":"IF(B165>D$18,\"\",F165-F164)","v":""},{"$f":"IFERROR(G165+H164,\"\")","v":""},{"$f":"IF(B165>D$18,\"\",P164)","v":""},"","",{"$f":"IF(B165>D$18,\"\",((1+D$13)^(G165/30)-1)*I165)","v":""},"","","","","","",null,{"$f":"IFERROR(J165+K165+L165+M165+N165,\"\")","v":""},"","","",{"$f":"IF(O165=\"\",0,L165/((1+$I$9)^B165))","v":0},0]
[null,131,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O166=\"\",0,L166/((1+$Q$28)^B166))","v":0}]
[null,132,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,133,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,134,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,135,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,136,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,137,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,138,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,139,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,140,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,141,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,142,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,143,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,144,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,145,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,146,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,147,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,148,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,149,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,150,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,151,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,152,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,153,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,154,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,155,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,156,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,157,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,158,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,159,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,160,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,161,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,162,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,163,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,164,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,165,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,166,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,167,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,168,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,169,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,170,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,171,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,172,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,173,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,174,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,175,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,176,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,177,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,178,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,179,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,180,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,181,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,182,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,183,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,184,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,185,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,186,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,187,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,188,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,189,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,190,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,191,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,192,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,193,null,"",{"$f":"IF(B228<=$D$18,WEEKDAY(D228,2),\"\")","v":""},"","","","",{"$f":"IF(B228>D$18,\"\",O228-N228-M228-L228-K228)","v":""},{"$f":"IF(B228>D$18,\"\",((1+D$23)^(G228/360)-1)*I228)","v":""},"",{"$f":"IF(B228>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B228>D$18,\"\",D$27)","v":""},{"$f":"IF(B228>D$18,\"\",IF(B228=D$18,I228+K228+L228+M228+N228,IF(AND(D$21=2,MONTH(F228)=7),2*D$28,IF(AND(D$22=2,MONTH(F228)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B228>D$18,\"\",I228-J228)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F228)=7,D$21=2),2/(1+D$24)^(H228/360),IF(AND(MONTH(F228)=12,D$22=2),2/(1+D$24)^(H228/360),1/(1+D$24)^(H228/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H228/360),\"\")","v":""},null,"",{"$f":"H228","v":""},{"$f":"IFERROR((1+D$30)^(U228/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T228/V228,2),\"\")","v":""},0,0]
[null,194,null,{"$f":"IF(B229>$D$18,\"\",EDATE(D228,1))","v":""},"",{"$f":"IF(E229=7,D229+1,D229)","v":""},{"$f":"IF(B229>D$18,\"\",F229-F228)","v":""},{"$f":"IFERROR(G229+H228,\"\")","v":""},{"$f":"IF(B229>D$18,\"\",P228)","v":""},"","",{"$f":"IF(B229>D$18,\"\",((1+D$13)^(G229/30)-1)*I229)","v":""},"","","","","","",null,{"$f":"IFERROR(J229+K229+L229+M229+N229,\"\")","v":""},"","","",{"$f":"IF(O229=\"\",0,L229/((1+$I$9)^B229))","v":0},0]
[null,195,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O230=\"\",0,L230/((1+$Q$28)^B230))","v":0}]
[null,196,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,197,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,198,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,199,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,200,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,201,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,202,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,203,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,204,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,205,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,206,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,207,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,208,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,209,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,210,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,211,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,212,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,213,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,214,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,215,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,216,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,217,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,218,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,219,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,220,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,221,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,222,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,223,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,224,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,225,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,226,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,227,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,228,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,229,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,230,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,231,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,232,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,233,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,234,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,235,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,236,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,237,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,238,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,239,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,240,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,241,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,242,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,243,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,244,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,245,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,246,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,247,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,248,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,249,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,250,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,251,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,252,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,253,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,254,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,255,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,256,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,257,null,"",{"$f":"IF(B292<=$D$18,WEEKDAY(D292,2),\"\")","v":""},"","","","",{"$f":"IF(B292>D$18,\"\",O292-N292-M292-L292-K292)","v":""},{"$f":"IF(B292>D$18,\"\",((1+D$23)^(G292/360)-1)*I292)","v":""},"",{"$f":"IF(B292>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B292>D$18,\"\",D$27)","v":""},{"$f":"IF(B292>D$18,\"\",IF(B292=D$18,I292+K292+L292+M292+N292,IF(AND(D$21=2,MONTH(F292)=7),2*D$28,IF(AND(D$22=2,MONTH(F292)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B292>D$18,\"\",I292-J292)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F292)=7,D$21=2),2/(1+D$24)^(H292/360),IF(AND(MONTH(F292)=12,D$22=2),2/(1+D$24)^(H292/360),1/(1+D$24)^(H292/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H292/360),\"\")","v":""},null,"",{"$f":"H292","v":""},{"$f":"IFERROR((1+D$30)^(U292/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T292/V292,2),\"\")","v":""},0,0]
[null,258,null,{"$f":"IF(B293>$D$18,\"\",EDATE(D292,1))","v":""},"",{"$f":"IF(E293=7,D293+1,D293)","v":""},{"$f":"IF(B293>D$18,\"\",F293-F292)","v":""},{"$f":"IFERROR(G293+H292,\"\")","v":""},{"$f":"IF(B293>D$18,\"\",P292)","v":""},"","",{"$f":"IF(B293>D$18,\"\",((1+D$13)^(G293/30)-1)*I293)","v":""},"","","","","","",null,{"$f":"IFERROR(J293+K293+L293+M293+N293,\"\")","v":""},"","","",{"$f":"IF(O293=\"\",0,L293/((1+$I$9)^B293))","v":0},0]
[null,259,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O294=\"\",0,L294/((1+$Q$28)^B294))","v":0}]
[null,260,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,261,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,262,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,263,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,264,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,265,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,266,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,267,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,268,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,269,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,270,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,271,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,272,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,273,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,274,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,275,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,276,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,277,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,278,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,279,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,280,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,281,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,282,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,283,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,284,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,285,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,286,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,287,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,288,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,289,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,290,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,291,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,292,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,293,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,294,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,295,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,296,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,297,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,298,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,299,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,300,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,301,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,302,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,303,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,304,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,305,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,306,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,307,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,308,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,309,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,310,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,311,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,312,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,313,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,314,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,315,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,316,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,317,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,318,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,319,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,320,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,321,null,"",{"$f":"IF(B356<=$D$18,WEEKDAY(D356,2),\"\")","v":""},"","","","",{"$f":"IF(B356>D$18,\"\",O356-N356-M356-L356-K356)","v":""},{"$f":"IF(B356>D$18,\"\",((1+D$23)^(G356/360)-1)*I356)","v":""},"",{"$f":"IF(B356>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B356>D$18,\"\",D$27)","v":""},{"$f":"IF(B356>D$18,\"\",IF(B356=D$18,I356+K356+L356+M356+N356,IF(AND(D$21=2,MONTH(F356)=7),2*D$28,IF(AND(D$22=2,MONTH(F356)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B356>D$18,\"\",I356-J356)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F356)=7,D$21=2),2/(1+D$24)^(H356/360),IF(AND(MONTH(F356)=12,D$22=2),2/(1+D$24)^(H356/360),1/(1+D$24)^(H356/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H356/360),\"\")","v":""},null,"",{"$f":"H356","v":""},{"$f":"IFERROR((1+D$30)^(U356/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T356/V356,2),\"\")","v":""},0,0]
[null,322,null,{"$f":"IF(B357>$D$18,\"\",EDATE(D356,1))","v":""},"",{"$f":"IF(E357=7,D357+1,D357)","v":""},{"$f":"IF(B357>D$18,\"\",F357-F356)","v":""},{"$f":"IFERROR(G357+H356,\"\")","v":""},{"$f":"IF(B357>D$18,\"\",P356)","v":""},"","",{"$f":"IF(B357>D$18,\"\",((1+D$13)^(G357/30)-1)*I357)","v":""},"","","","","","",null,{"$f":"IFERROR(J357+K357+L357+M357+N357,\"\")","v":""},"","","",{"$f":"IF(O357=\"\",0,L357/((1+$I$9)^B357))","v":0},0]
[null,323,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O358=\"\",0,L358/((1+$Q$28)^B358))","v":0}]
[null,324,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,325,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,326,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,327,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,328,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,329,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,330,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,331,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,332,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,333,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,334,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,335,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,336,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,337,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,338,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,339,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,340,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,341,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,342,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,343,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,344,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,345,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,346,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,347,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,348,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,349,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,350,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,351,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,352,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,353,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,354,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,355,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,356,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,357,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,358,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,359,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,360,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]

{"sheet":"TarifarioBD","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["TARIFA","PRODUCTO","TIPO_SEGURO","Valor","<","Columna2",null,"TARIFA","PRODUCTO","TIPO_SEGURO"]
["TARIFA TITULAR","Préstamos Personales (DXP)","Seguro de Vida",4.2000000000000003E-2,"Préstamos Personales (DXP)Seguro de VidaTARIFA TITULAR",4.2000000000000003E-2,null,"TARIFA TITULAR",null,"Seguro de Vida"]
["TARIFA TITULAR","Préstamos Personales (DXP)","Seguro de Desgravamen",1.8320000000000001E-3,"Préstamos Personales (DXP)Seguro de DesgravamenTARIFA TITULAR",1.8320000000000001E-3,null,"TARIFA TITULAR + CONYUGE",null,"Seguro de Desgravamen"]
["TARIFA TITULAR","Préstamos Personales (DXP)","Seguro de Desgravamen con Devolución",2.3419999999999999E-3,"Préstamos Personales (DXP)Seguro de Desgravamen con DevoluciónTARIFA TITULAR",2.3419999999999999E-3,null,null,"Préstamos Personales (DXP)","Seguro de Desgravamen con Devolución"]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Seguro de Vida",8.4000000000000005E-2,"Préstamos Personales (DXP)Seguro de VidaTARIFA TITULAR + CONYUGE",8.4000000000000005E-2]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Seguro de Desgravamen",3.6640000000000002E-3,"Préstamos Personales (DXP)Seguro de DesgravamenTARIFA TITULAR + CONYUGE",3.6640000000000002E-3]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Seguro de Desgravamen con Devolución",4.6839999999999998E-3,"Préstamos Personales (DXP)Seguro de Desgravamen con DevoluciónTARIFA TITULAR + CONYUGE",4.6839999999999998E-3]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Vida",3.6999999999999998E-2,"Préstamos Personales (LD Y PA) (Clientes)Seguro de VidaTARIFA TITULAR",3.6999999999999998E-2]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen",1.9949999999999998E-3,"Préstamos Personales (LD Y PA) (Clientes)Seguro de DesgravamenTARIFA TITULAR",1.9949999999999998E-3]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen con Devolución",2.594E-3,"Préstamos Personales (LD Y PA) (Clientes)Seguro de Desgravamen con DevoluciónTARIFA TITULAR",2.594E-3]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Vida",7.3999999999999996E-2,"Préstamos Personales (LD Y PA) (Clientes)Seguro de VidaTARIFA TITULAR + CONYUGE",7.3999999999999996E-2]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen",3.9899999999999996E-3,"Préstamos Personales (LD Y PA) (Clientes)Seguro de DesgravamenTARIFA TITULAR + CONYUGE",3.9899999999999996E-3]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen con Devolución",5.1879999999999999E-3,"Préstamos Personales (LD Y PA) (Clientes)Seguro de Desgravamen con DevoluciónTARIFA TITULAR + CONYUGE",5.1879999999999999E-3]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Vida",1.5866000000000002E-2,"Préstamos Personales (LD Y PA) (Empleados)Seguro de VidaTARIFA TITULAR",1.5866000000000002E-2]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen",8.5499999999999997E-4,"Préstamos Personales (LD Y PA) (Empleados)Seguro de DesgravamenTARIFA TITULAR",8.5499999999999997E-4]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen con Devolución",1.1119999999999999E-3,"Préstamos Personales (LD Y PA) (Empleados)Seguro de Desgravamen con DevoluciónTARIFA TITULAR",1.1119999999999999E-3]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Vida",3.1732000000000003E-2,"Préstamos Personales (LD Y PA) (Empleados)Seguro de VidaTARIFA TITULAR + CONYUGE",3.1732000000000003E-2]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen",1.7099999999999999E-3,"Préstamos Personales (LD Y PA) (Empleados)Seguro de DesgravamenTARIFA TITULAR + CONYUGE",1.7099999999999999E-3]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen con Devolución",2.2239999999999998E-3,"Préstamos Personales (LD Y PA) (Empleados)Seguro de Desgravamen con DevoluciónTARIFA TITULAR + CONYUGE",2.2239999999999998E-3]

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