{"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","Persona Natural"]
[null,"Tipo de Seguro","Seguro de Vida"]
[null,"Tarifa ","TARIFA TITULAR"]
[null,"Monto inicial",128000]
[null,"Seguro Desempleo"]
[null,"Monto adicional desempleo",{"$f":"C13*C12","v":0}]
[null,"Prima de Seguro de Desgravamen/Vida",2.5000000000000001E-2]
[null,"Monto adicional del Seguro",{"$f":"+C15*C12","v":3200}]
[null,"MAF final (MAF inicial+seguro)",{"$f":"C12+C14+C16","v":131200}]
[null,"Empleado",{"$f":"IF(C9=\"Préstamos Personales (LD Y PA) (Empleados)\",\"SI\",\"NO\")","v":"NO"}]
[null,"Moneda","Soles"]
[null,"Plazo Remanente",36]
[null,"Fecha de Desembolso",{"$f":"TODAY()","v":"2022-08-12"}]
[null,"Fecha de 1er Pago","2022-09-02"]
[null,"Cuota Julio",1]
[null,"Cuota Diciembre",1]
[null,"TEA",0.2]
[null,"TEA TOTAL",{"$f":"+C25","v":0.2}]
[null,"Monto del Bien",0]
[null,"Seguro del Bien",0]
[null,"Portes"]
[null,"Cuota",{"$f":"(C17+(C28*C27+C29)*P34)/O34","v":4762.2898900694317}]
[null,"2) Calcular TCEA presionando el botón "]
[null,"TCEA",0.25952530399215057]
[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":5274.1499999999942}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O36:O395)","v":27.549771859454605},{"$f":"SUM(P36:P395)","v":27.549771859454605},null,null,null,null,{"$f":"SUM(U36:U395)","v":122725.85}]
[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-09-02"},{"$f":"IF(B36<=$C$20,WEEKDAY(C36,2),\"\")","v":5},{"$f":"IF(D36=7,C36+1,C36)","v":"2022-09-02"},{"$f":"E36-C21","v":21},{"$f":"F36","v":21},{"$f":"C17","v":131200},{"$f":"IF(B36>C$20,\"\",M36-L36-K36-J36)","v":3359.4757030648379},{"$f":"IF(B36>C$20,\"\",((1+C$25)^(F36/360)-1)*H36)","v":1402.8141870045936},{"$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":4762.2898900694317},{"$f":"IF(B36>C$20,\"\",H36-I36)","v":127840.52429693517},{"$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.9894209320095857},{"$f":"IFERROR(1/(1+C$26)^(G36/360),\"\")","v":0.9894209320095857},null,{"$f":"IFERROR(I36+J36+K36+L36,\"\")","v":4762.2898900694317},{"$f":"G36","v":21},{"$f":"IFERROR((1+C$32)^(S36/360),\"\")","v":1.013550523563775},{"$f":"IFERROR(ROUND(R36/T36,2),\"\")","v":4698.62}]
[null,2,{"$f":"IF(B37>$C$20,\"\",EDATE(C36,1))","v":"2022-10-02"},7,{"$f":"IF(D37=7,C37+1,C37)","v":"2022-10-03"},{"$f":"IF(B37>C$20,\"\",E37-E36)","v":31},{"$f":"IFERROR(F37+G36,\"\")","v":52},{"$f":"IF(B37>C$20,\"\",N36)","v":127840.52429693517},{"$f":"IF(B37>C$20,\"\",M37-L37-K37-J37)","v":2739.3666230848476},2022.9232669845844,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":4762.2898900694317},125101.15767385032,0.97400841477128741,0.97400841477128741,null,{"$f":"IFERROR(I37+J37+K37+L37,\"\")","v":4762.2898900694317},52,1.0338899876177863,4606.1899999999996]
[null,3,"2022-11-02",3,"2022-11-02",30,82,125101.15767385032,2847.0574071793999,1915.2324828900321,0,0,4762.2898900694317,122254.10026667092,0.95932170739221456,0.95932170739221456,null,4762.2898900694317,82,1.0539618820195138,4518.47]
[null,4,"2022-12-02",5,"2022-12-02",30,112,122254.10026667092,2890.6443485656537,1871.6455415037778,0,0,4762.2898900694317,119363.45591810528,0.94485645536236373,0.94485645536236373,null,4762.2898900694317,112,1.07442345128965,4432.41]
[null,5,"2023-01-02",1,"2023-01-02",31,143,119363.45591810528,2873.5060828036103,1888.7838072658215,0,0,4762.2898900694317,116489.94983530167,0.93013813282150926,0.93013813282150926,null,4762.2898900694317,143,1.0959844851584439,4345.22]
[null,6,"2023-02-02",4,"2023-02-02",31,174,116489.94983530167,2918.9758768669044,1843.3140132025276,0,0,4762.2898900694317,113570.97395843477,0.91564908216337015,0.91564908216337015,null,4762.2898900694317,174,1.1179781959023876,4259.7299999999996]
[null,7,"2023-03-02",4,"2023-03-02",28,202,113570.97395843477,3140.3161794031198,1621.9737106663119,0,0,4762.2898900694317,110430.65777903165,0.90275628994373769,0.90275628994373769,null,4762.2898900694317,202,1.1382225968136397,4183.97]
[null,8,"2023-04-02",7,"2023-04-03",32,234,110430.65777903165,2958.0300757700043,1804.2598142994277,0,0,4762.2898900694317,107472.62770326165,0.88824381084206172,0.88824381084206172,null,4762.2898900694317,234,1.1618083220591926,4099.03]
[null,9,"2023-05-02",2,"2023-05-02",29,263,107472.62770326165,3172.1895402005339,1590.1003498688976,0,0,4762.2898900694317,104300.43816306112,0.87529349482116769,0.87529349482116769,null,4762.2898900694317,263,1.1836047660226554,4023.55]
[null,10,"2023-06-02",5,"2023-06-02",31,294,104300.43816306112,3111.8603077667758,1650.4295823026557,0,0,4762.2898900694317,101188.57785529434,0.86165877612757646,0.86165877612757646,null,4762.2898900694317,294,1.207356800117638,3944.39]
[null,11,"2023-07-02",7,"2023-07-03",31,325,101188.57785529434,3161.101772120956,1601.1881179484758,0,0,4762.2898900694317,98027.476083173387,0.84823644968293166,0.84823644968293166,null,4762.2898900694317,325,1.2315854790689478,3866.8]
[null,12,"2023-08-02",3,"2023-08-02",30,355,98027.476083173387,3261.5411368109835,1500.748753258448,0,0,4762.2898900694317,94765.934946362409,0.83544621056812673,0.83544621056812673,null,4762.2898900694317,355,1.2554954249806318,3793.16]
[null,13,"2023-09-02",6,"2023-09-02",31,386,94765.934946362409,3262.7324080047251,1499.5574820647066,0,0,4762.2898900694317,91503.202538357684,0.82243220540057949,0.82243220540057949,null,4762.2898900694317,386,1.2806901276350007,3718.53]
[null,14,"2023-10-02",1,"2023-10-02",30,416,91503.202538357684,3361.4243101775164,1400.8655798919153,0,0,4762.2898900694317,88141.778228180163,0.81003105880198434,0.81003105880198434,null,4762.2898900694317,416,1.3055533890178235,3647.72]
[null,15,"2023-11-02",4,"2023-11-02",31,447,88141.778228180163,3367.5517587001159,1394.7381313693156,0,0,4762.2898900694317,84774.226469480054,0.79741295334914586,0.79741295334914586,null,4762.2898900694317,447,1.3317526317878361,3575.96]
[null,16,"2023-12-02",6,"2023-12-02",30,477,84774.226469480054,3464.4413707973954,1297.8485192720361,0,0,4762.2898900694317,81309.785098682652,0.78538906266348762,0.78538906266348762,null,4762.2898900694317,477,1.3576072183633954,3507.86]
[null,17,"2024-01-02",2,"2024-01-02",31,508,81309.785098682652,3475.6598718164096,1286.6300182530219,0,0,4762.2898900694317,77834.12522686625,0.7731548132399525,0.7731548132399525,null,4762.2898900694317,508,1.3848510533527727,3438.85]
[null,18,"2024-02-02",5,"2024-02-02",31,539,77834.12522686625,3530.6580287896331,1231.6318612797984,0,0,4762.2898900694317,74303.467198076614,0.76111114052046458,0.76111114052046458,null,4762.2898900694317,539,1.4126416050470179,3371.19]
[null,19,"2024-03-02",6,"2024-03-02",29,568,74303.467198076614,3662.9404862905185,1099.349403778913,0,0,4762.2898900694317,70640.526711786093,0.75001437893715683,0.75001437893715683,null,4762.2898900694317,568,1.4391438799922431,3309.11]
[null,20,"2024-04-02",2,"2024-04-02",31,599,70640.526711786093,3644.4881142772465,1117.8017757921853,0,0,4762.2898900694317,66996.038597508843,0.73833117195177189,0.73833117195177189,null,4762.2898900694317,599,1.4680239550700305,3244.01]
[null,21,"2024-05-02",4,"2024-05-02",30,629,66996.038597508843,3736.6160135620175,1025.673876507414,0,0,4762.2898900694317,63259.422583946827,0.72719815327672288,0.72719815327672288,null,4762.2898900694317,629,1.4965241070767883,3182.23]
[null,22,"2024-06-02",7,"2024-06-03",32,661,63259.422583946827,3728.7323949000702,1033.5574951693616,0,0,4762.2898900694317,59530.690189046756,0.71550790185475444,0.71550790185475444,null,4762.2898900694317,661,1.5275343914549666,3117.63]
[null,23,"2024-07-02",2,"2024-07-02",29,690,59530.690189046756,3881.5096084250536,880.78028164437831,0,0,4762.2898900694317,55649.180580621702,0.70507602118036894,0.70507602118036894,null,4762.2898900694317,690,1.5561921460375803,3060.22]
[null,24,"2024-08-02",5,"2024-08-02",31,721,55649.180580621702,3881.7082215861997,880.58166848323219,0,0,4762.2898900694317,51767.472359035499,0.69409283295462409,0.69409283295462409,null,4762.2898900694317,721,1.5874210916891232,3000.02]
[null,25,"2024-09-02",1,"2024-09-02",31,752,51767.472359035499,3943.1316076390704,819.15828243036117,0,0,4762.2898900694317,47824.340751396427,0.68328073326398509,0.68328073326398509,null,4762.2898900694317,752,1.6192767254067832,2941]
[null,26,"2024-10-02",3,"2024-10-02",30,782,47824.340751396427,4030.1245561668356,732.16533390259588,0,0,4762.2898900694317,43794.216195229594,0.67297779949563274,0.67297779949563274,null,4762.2898900694317,782,1.6507132919939387,2884.99]
[null,27,"2024-11-02",6,"2024-11-02",31,813,43794.216195229594,4069.2988421376381,692.99104793179379,0,0,4762.2898900694317,39724.917353091958,0.66249461524092768,0.66249461524092768,null,4762.2898900694317,813,1.6838390443717646,2828.23]
[null,28,"2024-12-02",1,"2024-12-02",30,843,39724.917353091958,4154.1224397480109,608.16745032142103,0,0,4762.2898900694317,35570.794913343947,0.65250510754602775,0.65250510754602775,null,4762.2898900694317,843,1.7165290209581616,2774.37]
[null,29,"2025-01-02",4,"2025-01-02",31,874,35570.794913343947,4199.4246401725686,562.86524989686279,0,0,4762.2898900694317,31371.370273171378,0.64234083277401044,0.64234083277401044,null,4762.2898900694317,874,1.7509755330044343,2719.79]
[null,30,"2025-02-02",7,"2025-02-03",32,906,31371.370273171378,4249.7320203458821,512.5578697235494,0,0,4762.2898900694317,27121.638252825498,0.63201472592144359,0.63201472592144359,null,4762.2898900694317,906,1.7872584428225475,2664.58]
[null,31,"2025-03-02",7,"2025-03-03",28,934,27121.638252825498,4374.9498620409267,387.34002802850523,0,0,4762.2898900694317,22746.688390784569,0.62311564580463585,0.62311564580463585,null,4762.2898900694317,934,1.8196222014192125,2617.19]
[null,32,"2025-04-02",3,"2025-04-02",30,964,22746.688390784569,4414.0501351841376,348.23975488529436,0,0,4762.2898900694317,18332.638255600432,0.61371991881247878,0.61371991881247878,null,4762.2898900694317,964,1.8549482661991601,2567.34]
[null,33,"2025-05-02",5,"2025-05-02",30,994,18332.638255600432,4481.6269055130733,280.66298455635831,0,0,4762.2898900694317,13851.011350087359,0.60446586646178757,0.60446586646178757,null,4762.2898900694317,994,1.8909601496352355,2518.4499999999998]
[null,34,"2025-06-02",1,"2025-06-02",31,1025,13851.011350087359,4543.1142156465212,219.17567442291082,0,0,4762.2898900694317,9307.8971344408383,0.59504991387234407,0.59504991387234407,null,4762.2898900694317,1025,1.9289070650547446,2468.91]
[null,35,"2025-07-02",3,"2025-07-02",30,1055,9307.8971344408383,4619.7909134751771,142.49897659425451,0,0,4762.2898900694317,4688.1062209656611,0.58607737952002248,0.58607737952002248,null,4762.2898900694317,1055,1.9663547813342428,2421.89]
[null,36,"2025-08-02",6,"2025-08-02",31,1086,4688.1062209656611,4688.1062209656611,74.183669103694143,0,0,4762.2898900693554,0,0.5769478701043661,0.5769478701043661,null,4762.2898900693554,1086,2.0058146814206781,2374.2399999999998]
[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":"Persona Natural"},null,null,"Suma de Prima Mensual",{"$f":"SUM(L36:L395)","v":2512.5766577015534}]
[null,"Tipo de Seguro",null,{"$f":"'Vista Principal'!C10","v":"Seguro de Vida"},null,null,"VPN - Valor Presente",{"$f":"NPV(D16,L36:L395)","v":2512.5766577015534}]
[null,"Tarifa",null,{"$f":"'Vista Principal'!C11","v":"TARIFA TITULAR"}]
[null,"Monto inicial",null,{"$f":"'Vista Principal'!C12","v":128000},null,null,"4) Calculo del Monto Adicional del Seguro y MAF"]
[null,{"$f":"D10","v":"Seguro de Vida"},{"$f":"+CONCATENATE(D11,D9,D10)","v":"TARIFA TITULARPersona NaturalSeguro de Vida"},{"$f":"VLOOKUP(C13,capucci2020,2,0)","v":9.7499999999999996E-4}]
[null,"Monto adicional Seguro de Desgravamen/ Vida",null,null,null,null,"Monto inicial",{"$f":"D12","v":128000}]
[null,"MAF Inicial",null,{"$f":"D12+D14","v":128000},null,null,"Monto adicional de Desgravamen / Vida",{"$f":"H10","v":2512.5766577015534}]
[null,"Costo Capital",null,{"$f":"INDEX(_xlfn._xlws.FILTER(Tabla2[],Tabla2[TARIFA]=D11),0,2)","v":0},null,null,"Prima de Seguro de Desgravamen / Vida",{"$f":"H15/H14","v":1.9629505138293386E-2}]
[null,"Moneda",null,{"$f":"'Vista Principal'!C19","v":"Soles"},null,null,"MAF Inicial",{"$f":"H14+H15","v":130512.57665770156}]
[null,"Plazo Remanente Meses",null,{"$f":"'Vista Principal'!C20","v":36}]
[null,"Fecha de Desembolso",null,{"$f":"'Vista Principal'!C21","v":"2022-08-12"}]
[null,"Fecha de 1er Pago",null,{"$f":"'Vista Principal'!C22","v":"2022-09-02"}]
[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.2}]
[null,"TEA TOTAL",null,{"$f":"(1+(((1+D23)^(30/360)-1)+D13))^12-1","v":0.21390156649666725}]
[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":4721.2905449400678}]
[]
[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":3333.0100000000093}]
[]
[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":27.111231300344564},{"$f":"SUM(R36:R395)","v":27.111231300344564},null,null,null,null,{"$f":"SUM(W36:W395)","v":124666.98999999999}]
[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-09-02"},{"$f":"IF(B36<=$D$18,WEEKDAY(D36,2),\"\")","v":5},{"$f":"IF(E36=7,D36+1,D36)","v":"2022-09-02"},{"$f":"F36-D19","v":21},{"$f":"G36","v":21},{"$f":"D15","v":128000},{"$f":"IF(B36>D$18,\"\",O36-N36-M36-L36-K36)","v":3265.3441091113318},{"$f":"IF(B36>D$18,\"\",((1+D$23)^(G36/360)-1)*I36)","v":1368.5992068337498},{"$f":"IF(B36>D$18,\"\",((1+D$13)^(G36/30)-1)*I36)","v":87.347228994985926},{"$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":4721.2905449400678},{"$f":"IF(B36>D$18,\"\",I36-J36)","v":124734.65589088867},{"$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.98875637693341123},{"$f":"IFERROR(1/(1+D$24)^(H36/360),\"\")","v":0.98875637693341123},null,{"$f":"IFERROR(J36+K36+L36+M36+N36,\"\")","v":4721.2905449400678},{"$f":"H36","v":21},{"$f":"IFERROR((1+D$30)^(U36/360),\"\")","v":1.0124987926526892},{"$f":"IFERROR(ROUND(T36/V36,2),\"\")","v":4663.01},{"$f":"L36/(1+$I$9)","v":87.347228994985926},{"$f":"L36/(1+$Q$28)","v":87.347228994985926}]
[null,2,null,{"$f":"IF(B37>$D$18,\"\",EDATE(D36,1))","v":"2022-10-02"},7,{"$f":"IF(E37=7,D37+1,D37)","v":"2022-10-03"},{"$f":"IF(B37>D$18,\"\",F37-F36)","v":31},{"$f":"IFERROR(G37+H36,\"\")","v":52},{"$f":"IF(B37>D$18,\"\",P36)","v":124734.65589088867},2621.8417203284707,1973.7766173025914,{"$f":"IF(B37>D$18,\"\",((1+D$13)^(G37/30)-1)*I37)","v":125.67220730900614},0,0,4721.2905449400678,122112.81417056019,0.97238928629181731,0.97238928629181731,null,4721.2905449400678,52,1.0312354742542889,4578.29,{"$f":"IF(O37=\"\",0,L37/((1+$I$9)^B37))","v":125.67220730900614},{"$f":"IF(O37=\"\",0,L37/((1+$Q$28)^B37))","v":125.67220730900614}]
[null,3,null,"2022-11-02",3,"2022-11-02",30,82,122112.81417056019,2732.7480249404298,1869.4825261833482,119.05999381628985,0,0,4721.2905449400678,119380.06614561976,0.95680817184352973,0.95680817184352973,null,4721.2905449400678,82,1.0496978140942406,4497.76,119.05999381628985,119.05999381628985]
[null,4,null,"2022-12-02",5,"2022-12-02",30,112,119380.06614561976,2777.2493795357705,1827.6456009123242,116.39556449197308,0,0,4721.2905449400678,116602.81676608398,0.94147672193893162,0.94147672193893162,null,4721.2905449400678,112,1.0684906875522413,4418.6499999999996,116.39556449197308,116.39556449197308]
[null,5,null,"2023-01-02",1,"2023-01-02",31,143,116602.81676608398,2758.7113013648409,1845.0999972761097,117.47924629911739,0,0,4721.2905449400678,113844.10546471915,0.92589226129280511,0.92589226129280511,null,4721.2905449400678,143,1.0882635208160614,4338.37,117.47924629911739,117.47924629911739]
[null,6,null,"2023-02-02",4,"2023-02-02",31,174,113844.10546471915,2805.1440522128451,1801.4466932153248,114.69979951189822,0,0,4721.2905449400678,111038.96141250631,0.9105657734759276,0.9105657734759276,null,4721.2905449400678,174,1.1084022580038309,4259.55,114.69979951189822,114.69979951189822]
[null,7,null,"2023-03-02",4,"2023-03-02",28,202,111038.96141250631,3034.4358189162535,1585.8125539778407,101.04217204597343,0,0,4721.2905449400678,108004.52559359005,0.89694067388430021,0.89694067388430021,null,4721.2905449400678,202,1.1269122171016599,4189.58,101.04217204597343,101.04217204597343]
[null,8,null,"2023-04-02",7,"2023-04-03",32,234,108004.52559359005,2844.3414829045823,1764.6207059720127,112.32835606347237,0,0,4721.2905449400678,105160.18411068547,0.88161859823765321,0.88161859823765321,null,4721.2905449400678,234,1.1484452584366129,4111.03,112.32835606347237,112.32835606347237]
[null,9,null,"2023-05-02",2,"2023-05-02",29,263,105160.18411068547,3066.2918559569125,1555.8868255121663,99.111863470989491,0,0,4721.2905449400678,102093.89225472856,0.86795917220075436,0.86795917220075436,null,4721.2905449400678,263,1.1683147669426162,4041.11,99.111863470989491,99.111863470989491]
[null,10,null,"2023-06-02",5,"2023-06-02",31,294,102093.89225472856,3002.9156429264117,1615.5136346234381,102.86126739021843,0,0,4721.2905449400678,99090.976611802151,0.85359166289712585,0.85359166289712585,null,4721.2905449400678,294,1.1899348833886807,3967.69,102.86126739021843,102.86126739021843]
[null,11,null,"2023-07-02",7,"2023-07-03",31,325,99090.976611802151,3053.458675028608,1567.9960891794115,99.835780732048462,0,0,4721.2905449400678,96037.51793677354,0.83946198197322008,0.83946198197322008,null,4721.2905449400678,325,1.2119550884481629,3895.6,99.835780732048462,99.835780732048462]
[null,12,null,"2023-08-02",3,"2023-08-02",30,355,96037.51793677354,3157.3704172312791,1470.2835477204399,93.636579988349226,0,0,4721.2905449400678,92880.147519542254,0.8260108329318826,0.8260108329318826,null,4721.2905449400678,355,1.2336528745235198,3827.08,93.636579988349226,93.636579988349226]
[null,13,null,"2023-09-02",6,"2023-09-02",31,386,{"$f":"IF(B48>D$18,\"\",P47)","v":92880.147519542254},{"$f":"IF(B48>D$18,\"\",O48-N48-M48-L48-K48)","v":3157.9951227742504},{"$f":"IF(B48>D$18,\"\",((1+D$23)^(G48/360)-1)*I48)","v":1469.7171533952087},93.57826877060883,0,0,4721.2905449400678,{"$f":"IF(B48>D$18,\"\",I48-J48)","v":89722.152396767997},0.81233770324197385,0.81233770324197385,null,{"$f":"IFERROR(J48+K48+L48+M48+N48,\"\")","v":4721.2905449400678},386,1.2564820979108253,3757.55,93.57826877060883,{"$f":"IF(O48=\"\",0,L48/((1+$Q$28)^B48))","v":93.57826877060883}]
[null,14,null,"2023-10-02",1,"2023-10-02",30,416,89722.152396767997,3260.2128010625179,1373.5986452907059,87.479098586844145,0,0,4721.2905449400678,86461.93959570548,0.79932118104936523,0.79932118104936523,null,4721.2905449400678,416,1.2789770566991852,3691.46,87.479098586844145,87.479098586844145]
[null,15,null,"2023-11-02",4,"2023-11-02",31,447,86461.93959570548,3266.0220298561035,1368.1566958417231,87.111819242241324,0,0,4721.2905449400678,83195.917565849377,0.78608985073667892,0.78608985073667892,null,4721.2905449400678,447,1.3026450216004966,3624.39,87.111819242241324,87.111819242241324]
[null,16,null,"2023-12-02",6,"2023-12-02",30,477,83195.917565849377,3366.4890796409295,1273.6854456724391,81.116019626698829,0,0,4721.2905449400678,79829.428486208446,0.77349391194587469,0.77349391194587469,null,4721.2905449400678,477,1.3259664410823084,3560.64,81.116019626698829,81.116019626698829]
[null,17,null,"2024-01-02",2,"2024-01-02",31,508,79829.428486208446,3377.6559422888877,1263.2051469043024,80.429455746877863,0,0,4721.2905449400678,76451.772543919564,0.76069010580830687,0.76069010580830687,null,4721.2905449400678,508,1.3505039627082602,3495.95,80.429455746877863,80.429455746877863]
[null,18,null,"2024-02-02",5,"2024-02-02",31,539,76451.772543919564,3434.5063480348558,1209.7577848013866,77.026412103825407,0,0,4721.2905449400678,73017.266195884702,0.74809824374563938,0.74809824374563938,null,4721.2905449400678,539,1.3754955606583856,3432.43,77.026412103825407,77.026412103825407]
[null,19,null,"2024-03-02",6,"2024-03-02",29,568,73017.266195884702,3572.1533420217988,1080.319547458344,68.817655459924893,0,0,4721.2905449400678,69445.112853862898,0.73650752566278099,0.73650752566278099,null,4721.2905449400678,568,1.3992933172703781,3374.05,68.817655459924893,68.817655459924893]
[null,20,null,"2024-04-02",2,"2024-04-02",31,599,69445.112853862898,3552.4376747032884,1098.8857824468214,69.967087789957802,0,0,4721.2905449400678,65892.675179159603,0.72431596289569622,0.72431596289569622,null,4721.2905449400678,599,1.4251877810891955,3312.75,69.967087789957802,69.967087789957802]
[null,21,null,"2024-05-02",4,"2024-05-02",30,629,65892.675179159603,3648.2632198366773,1008.7819668037138,64.245358299677193,0,0,4721.2905449400678,62244.411959322926,0.71270986020236338,0.71270986020236338,null,4721.2905449400678,629,1.4507030991781531,3254.48,64.245358299677193,64.245358299677193]
[null,22,null,"2024-06-02",7,"2024-06-03",32,661,62244.411959322926,3639.5804036111822,1016.9738496679436,64.73629166094166,0,0,4721.2905449400678,58604.831555711746,0.70053492521492366,0.70053492521492366,null,4721.2905449400678,661,1.4784231374608952,3193.46,64.73629166094166,64.73629166094166]
[null,23,null,"2024-07-02",2,"2024-07-02",29,690,58604.831555711746,3798.9745542159108,867.08183425124298,55.234156472913938,0,0,4721.2905449400678,54805.857001495839,0.68968113309170176,0.68968113309170176,null,4721.2905449400678,690,1.5040016671204108,3139.15,55.234156472913938,55.234156472913938]
[null,24,null,"2024-08-02",5,"2024-08-02",31,721,54805.857001495839,3798.8356646839179,867.23708233425839,55.217797921891233,0,0,4721.2905449400678,51007.021336811922,0.67826469737260309,0.67826469737260309,null,4721.2905449400678,721,1.5318337994346434,3082.12,55.217797921891233,55.217797921891233]
[null,25,null,"2024-09-02",1,"2024-09-02",31,752,51007.021336811922,3862.7750808321439,807.1250552927346,51.390408815189289,0,0,4721.2905449400678,47144.246255979779,0.66703724029635059,0.66703724029635059,null,4721.2905449400678,752,1.56018097611757,3026.12,51.390408815189289,51.390408815189289]
[null,26,null,"2024-10-02",3,"2024-10-02",30,782,47144.246255979779,3953.5714575525044,721.75344728798518,45.96564009957784,0,0,4721.2905449400678,43190.674798427273,0.65634894525973886,0.65634894525973886,null,4721.2905449400678,782,1.5881130945444881,2972.89,45.96564009957784,45.96564009957784]
[null,27,null,"2024-11-02",6,"2024-11-02",31,813,43190.674798427273,3994.3345054007514,683.44072778961447,43.515311749701965,0,0,4721.2905449400678,39196.340293026522,0.64548426420160154,0.64548426420160154,null,4721.2905449400678,813,1.6175017413416388,2918.88,43.515311749701965,43.515311749701965]
[null,28,null,"2024-12-02",1,"2024-12-02",30,843,39196.340293026522,4082.9988977408548,600.07521541351457,38.216431785698823,0,0,4721.2905449400678,35113.341395285664,0.63514132404699808,0.63514132404699808,null,4721.2905449400678,843,1.6464600807179657,2867.54,38.216431785698823,38.216431785698823]
[null,29,null,"2025-01-02",4,"2025-01-02",31,874,35113.341395285664,4130.286683230589,555.6265955630098,35.37726614646941,0,0,4721.2905449400678,30983.054712055076,0.62462769716841327,0.62462769716841327,null,4721.2905449400678,874,1.6769284610518655,2815.44,35.37726614646941,35.37726614646941]
[null,30,null,"2025-02-02",7,"2025-02-03",32,906,30983.054712055076,4182.8537048060534,506.21341632374083,32.22342381027336,0,0,4721.2905449400678,26800.201007249023,0.6139574342338997,0.6139574342338997,null,4721.2905449400678,906,1.708971214089418,2762.65,32.22342381027336,32.22342381027336]
[null,31,null,"2025-03-02",7,"2025-03-03",28,934,26800.201007249023,4314.1537602260996,382.74939413868015,24.387390575288016,0,0,4721.2905449400678,22486.047247022922,0.60477058422247865,0.60477058422247865,null,4721.2905449400678,934,1.7375104804466805,2717.27,24.387390575288016,24.387390575288016]
[null,32,null,"2025-04-02",3,"2025-04-02",30,964,22486.047247022922,4355.1171718903624,344.24947698385921,21.923896065846183,0,0,4721.2905449400678,18130.930075132557,0.59508002117271219,0.59508002117271219,null,4721.2905449400678,964,1.7686173515409676,2669.48,21.923896065846183,21.923896065846183]
[null,33,null,"2025-05-02",5,"2025-05-02",30,994,18130.930075132557,4426.0379489988836,277.57493911793097,17.677656823253304,0,0,4721.2905449400678,13704.892126133673,0.58554473520597772,0.58554473520597772,null,4721.2905449400678,994,1.800281132904382,2622.53,17.677656823253304,17.677656823253304]
[null,34,null,"2025-06-02",1,"2025-06-02",31,1025,13704.892126133673,4490.6191292045005,216.8635126141632,13.80790312140385,0,0,4721.2905449400678,9214.2729969291722,0.57585209101232115,0.57585209101232115,null,4721.2905449400678,1025,1.8335960312779618,2574.88,13.80790312140385,13.80790312140385]
[null,35,null,"2025-07-02",3,"2025-07-02",30,1055,9214.2729969291722,4571.2409881451049,141.06564062295689,8.9839161720054648,0,0,4721.2905449400678,4643.0320087840673,0.56662490447104941,0.56662490447104941,null,4721.2905449400678,1055,1.8664231342081823,2529.59,8.9839161720054648,8.9839161720054648]
[null,36,null,"2025-08-02",6,"2025-08-02",31,1086,4643.0320087840673,4643.0320087840673,73.470423651482463,4.6779307401198729,0,0,4721.1803631756702,0,0.55724544418374877,0.55724544418374877,null,4721.1803631756702,1086,1.9009620158871396,2483.5700000000002,4.6779307401198729,4.6779307401198729]
[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":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TARIFA","PRODUCTO","TIPO_SEGURO","Valor","Columna1","Columna2","Columna3","TARIFA","PRODUCTO","TIPO_SEGURO"]
["TARIFA TITULAR","Persona Natural","Seguro de Vida",9.7499999999999996E-4,{"$f":"+CONCATENATE(TarifarioPrincipal[[#This Row],[TARIFA]],TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]])","v":"TARIFA TITULARPersona NaturalSeguro de Vida"},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]","v":9.7499999999999996E-4},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]*1","v":9.7499999999999996E-4},"TARIFA TITULAR","Persona Natural","Seguro de Vida"]
["TARIFA TITULAR","Persona Natural","Seguro de Desgravamen",2E-3,{"$f":"+CONCATENATE(TarifarioPrincipal[[#This Row],[TARIFA]],TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]])","v":"TARIFA TITULARPersona NaturalSeguro de Desgravamen"},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]","v":2E-3},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]*1","v":2E-3},"TARIFA TITULAR + CONYUGE"]
["TARIFA TITULAR","Persona Natural","Seguro de Desgravamen con Devolución",2.5999999999999999E-3,{"$f":"+CONCATENATE(TarifarioPrincipal[[#This Row],[TARIFA]],TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]])","v":"TARIFA TITULARPersona NaturalSeguro de Desgravamen con Devolución"},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]","v":2.5999999999999999E-3},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]*1","v":2.5999999999999999E-3}]
["TARIFA TITULAR + CONYUGE","Persona Natural","Seguro de Vida",1.9499999999999999E-3,{"$f":"+CONCATENATE(TarifarioPrincipal[[#This Row],[TARIFA]],TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]])","v":"TARIFA TITULAR + CONYUGEPersona NaturalSeguro de Vida"},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]","v":1.9499999999999999E-3},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]*1","v":1.9499999999999999E-3}]
["TARIFA TITULAR + CONYUGE","Persona Natural","Seguro de Desgravamen",4.0000000000000001E-3,{"$f":"+CONCATENATE(TarifarioPrincipal[[#This Row],[TARIFA]],TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]])","v":"TARIFA TITULAR + CONYUGEPersona NaturalSeguro de Desgravamen"},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]","v":4.0000000000000001E-3},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]*1","v":4.0000000000000001E-3}]
["TARIFA TITULAR + CONYUGE","Persona Natural","Seguro de Desgravamen con Devolución",5.1999999999999998E-3,{"$f":"+CONCATENATE(TarifarioPrincipal[[#This Row],[TARIFA]],TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]])","v":"TARIFA TITULAR + CONYUGEPersona NaturalSeguro de Desgravamen con Devolución"},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]","v":5.1999999999999998E-3},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]*1","v":5.1999999999999998E-3}]
["TARIFA TITULAR","Persona Jurídica","Seguro de Desgravamen",9.0899999999999998E-4,{"$f":"+CONCATENATE(TarifarioPrincipal[[#This Row],[TARIFA]],TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]])","v":"TARIFA TITULARPersona JurídicaSeguro de Desgravamen"},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]","v":9.0899999999999998E-4},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]*1","v":9.0899999999999998E-4}]
["TARIFA TITULAR","Persona Jurídica","Seguro de Desgravamen con Devolución",1.8E-3,{"$f":"+CONCATENATE(TarifarioPrincipal[[#This Row],[TARIFA]],TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]])","v":"TARIFA TITULARPersona JurídicaSeguro de Desgravamen con Devolución"},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]","v":1.8E-3},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]*1","v":1.8E-3}]
["TARIFA TITULAR + CONYUGE","Persona Jurídica","Seguro de Desgravamen",1.591E-3,{"$f":"+CONCATENATE(TarifarioPrincipal[[#This Row],[TARIFA]],TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]])","v":"TARIFA TITULAR + CONYUGEPersona JurídicaSeguro de Desgravamen"},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]","v":1.591E-3},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]*1","v":1.591E-3}]
["TARIFA TITULAR + CONYUGE","Persona Jurídica","Seguro de Desgravamen con Devolución",3.15E-3,{"$f":"+CONCATENATE(TarifarioPrincipal[[#This Row],[TARIFA]],TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]])","v":"TARIFA TITULAR + CONYUGEPersona JurídicaSeguro de Desgravamen con Devolución"},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]","v":3.15E-3},{"$f":"+TarifarioPrincipal[[#This Row],[Valor]]*1","v":3.15E-3}]

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