{"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":true,"merged":[[1,2,3,8]]}
[]
[null,null,"Calculadora de Seguros PP - Scotiabank"]
[]
[]
[]
[]
[null,"1) Establecer los datos del préstamos"]
[]
[null,"Producto","Persona Juridica"]
[null,"Tipo de Seguro","Seguro de Desgravamen"]
[null,"Tarifa ","TARIFA TITULAR"]
[null,"Monto inicial",100000]
[null,"Seguro Desempleo"]
[null,"Monto adicional desempleo",{"$f":"C13*C12","v":0}]
[null,"Prima de Seguro de Desgravamen/Vida",{"$f":"IF(C10=\"Seguro de vida\",'Proceso Prima de Seguro'!C13, IF(AND(C10=\"Sin Seguro (Solo LD Garantía Liquida)\",C9=\"Préstamos Personales (LD Garantía Liquida)\"),0%, 'Proceso Prima de Seguro'!G16))","v":1.2358175718529072E-2}]
[null,"Monto adicional del Seguro",{"$f":"+C15*C12","v":1235.8175718529071}]
[null,"MAF final (MAF inicial+seguro)",{"$f":"C12+C14+C16","v":101235.81757185291}]
[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":3674.6517571291802}]
[null,"2) Calcular TCEA presionando el botón "]
[null,"TCEA",0.24550106099509675]
[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":3844.3800000000065}]
[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":96155.62}]
[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":101235.81757185291},{"$f":"IF(B36>C$20,\"\",M36-L36-K36-J36)","v":2592.2200412541483},{"$f":"IF(B36>C$20,\"\",((1+C$25)^(F36/360)-1)*H36)","v":1082.4317158750318},{"$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":3674.6517571291802},{"$f":"IF(B36>C$20,\"\",H36-I36)","v":98643.597530598767},{"$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":3674.6517571291802},{"$f":"G36","v":21},{"$f":"IFERROR((1+C$32)^(S36/360),\"\")","v":1.0128887307719776},{"$f":"IFERROR(ROUND(R36/T36,2),\"\")","v":3627.89}]
[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":98643.597530598767},{"$f":"IF(B37>C$20,\"\",M37-L37-K37-J37)","v":2113.7349063798806},1560.9168507492996,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":3674.6517571291802},96529.862624218891,0.97400841477128741,0.97400841477128741,null,{"$f":"IFERROR(I37+J37+K37+L37,\"\")","v":3674.6517571291802},52,1.0322191829574949,3559.95]
[null,3,"2022-11-02",3,"2022-11-02",30,82,96529.862624218891,2196.8306729405967,1477.8210841885837,0,0,3674.6517571291802,94333.031951278288,0.95932170739221456,0.95932170739221456,null,3674.6517571291806,82,1.0512772534020043,3495.42]
[null,4,"2022-12-02",5,"2022-12-02",30,112,94333.031951278288,2230.4629873208851,1444.1887698082949,0,0,3674.6517571291802,92102.568963957398,0.94485645536236373,0.94485645536236373,null,3674.6517571291797,112,1.0706871968353757,3432.05]
[null,5,"2023-01-02",1,"2023-01-02",31,143,92102.568963957398,2217.2388535847253,1457.4129035444548,0,0,3674.6517571291802,89885.33011037267,0.93013813282150926,0.93013813282150926,null,3674.6517571291802,143,1.0911207025456204,3367.78]
[null,6,"2023-02-02",4,"2023-02-02",31,174,89885.33011037267,2252.3240043226929,1422.3277528064873,0,0,3674.6517571291802,87633.006106049972,0.91564908216337015,0.91564908216337015,null,3674.6517571291802,174,1.1119441710356994,3304.71]
[null,7,"2023-03-02",4,"2023-03-02",28,202,87633.006106049972,2423.1133830487224,1251.5383740804577,0,0,3674.6517571291802,85209.892723001249,0.90275628994373769,0.90275628994373769,null,3674.6517571291802,202,1.1310938340507395,3248.76]
[null,8,"2023-04-02",7,"2023-04-03",32,234,85209.892723001249,2282.4587890450184,1392.1929680841615,0,0,3674.6517571291802,82927.433933956228,0.88824381084206172,0.88824381084206172,null,3674.6517571291797,234,1.1533833193377818,3185.98]
[null,9,"2023-05-02",2,"2023-05-02",29,263,82927.433933956228,2447.7073292308023,1226.9444278983776,0,0,3674.6517571291802,80479.726604725423,0.87529349482116769,0.87529349482116769,null,3674.6517571291797,263,1.173962334732001,3130.13]
[null,10,"2023-06-02",5,"2023-06-02",31,294,80479.726604725423,2401.1564209311546,1273.4953361980258,0,0,3674.6517571291802,78078.570183794276,0.86165877612757646,0.86165877612757646,null,3674.6517571291806,294,1.1963667924870394,3071.51]
[null,11,"2023-07-02",7,"2023-07-03",31,325,78078.570183794276,2439.1518470159917,1235.4999101131884,0,0,3674.6517571291802,75639.418336778283,0.84823644968293166,0.84823644968293166,null,3674.6517571291802,325,1.2191988276118508,3013.99]
[null,12,"2023-08-02",3,"2023-08-02",30,355,75639.418336778283,2516.6523134854465,1157.9994436437337,0,0,3674.6517571291802,73122.766023292832,0.83544621056812673,0.83544621056812673,null,3674.6517571291802,355,1.2417091408535752,2959.35]
[null,13,"2023-09-02",6,"2023-09-02",31,386,73122.766023292832,2517.571515568131,1157.0802415610492,0,0,3674.6517571291802,70605.194507724707,0.82243220540057949,0.82243220540057949,null,3674.6517571291802,386,1.2654065110052757,2903.93]
[null,14,"2023-10-02",1,"2023-10-02",30,416,70605.194507724707,2593.7236146853857,1080.9281424437943,0,0,3674.6517571291802,68011.470893039324,0.81003105880198434,0.81003105880198434,null,3674.6517571291797,416,1.2887699660018999,2851.29]
[null,15,"2023-11-02",4,"2023-11-02",31,447,68011.470893039324,2598.4516425879378,1076.2001145412423,0,0,3674.6517571291802,65413.019250451383,0.79741295334914586,0.79741295334914586,null,3674.6517571291802,447,1.3133654674119544,2797.89]
[null,16,"2023-12-02",6,"2023-12-02",30,477,65413.019250451383,2673.2130686160463,1001.438688513134,0,0,3674.6517571291802,62739.806181835338,0.78538906266348762,0.78538906266348762,null,3674.6517571291802,477,1.3376143982694559,2747.17]
[null,17,"2024-01-02",2,"2024-01-02",31,508,62739.806181835338,2681.8694262577424,992.78233087143781,0,0,3674.6517571291802,60057.936755577597,0.7731548132399525,0.7731548132399525,null,3674.6517571291802,508,1.3631420701477879,2695.72]
[null,18,"2024-02-02",5,"2024-02-02",31,539,60057.936755577597,2724.3067996276313,950.34495750154895,0,0,3674.6517571291802,57333.629955949968,0.76111114052046458,0.76111114052046458,null,3674.6517571291802,539,1.3891569243055353,2645.24]
[null,19,"2024-03-02",6,"2024-03-02",29,568,57333.629955949968,2826.3778570629665,848.27390006621363,0,0,3674.6517571291802,54507.252098887002,0.75001437893715683,0.75001437893715683,null,3674.6517571291802,568,1.4139426839493312,2598.87]
[null,20,"2024-04-02",2,"2024-04-02",31,599,54507.252098887002,2812.1397399371772,862.51201719200321,0,0,3674.6517571291802,51695.112358949824,0.73833117195177189,0.73833117195177189,null,3674.6517571291806,599,1.4409270412778143,2550.1999999999998]
[null,21,"2024-05-02",4,"2024-05-02",30,629,51695.112358949824,2883.2269594895483,791.42479763963172,0,0,3674.6517571291802,48811.885399460276,0.72719815327672288,0.72719815327672288,null,3674.6517571291802,629,1.4675311671373914,2503.9699999999998]
[null,22,"2024-06-02",7,"2024-06-03",32,661,48811.885399460276,2877.1438453076357,797.50791182154455,0,0,3674.6517571291802,45934.741554152642,0.71550790185475444,0.71550790185475444,null,3674.6517571291802,661,1.496450531184351,2455.58]
[null,23,"2024-07-02",2,"2024-07-02",29,690,45934.741554152642,2995.0289529109223,679.6228042182579,0,0,3674.6517571291802,42939.712601241721,0.70507602118036894,0.70507602118036894,null,3674.6517571291802,690,1.5231506559404571,2412.5300000000002]
[null,24,"2024-08-02",5,"2024-08-02",31,721,42939.712601241721,2995.1822056986443,679.46955143053572,0,0,3674.6517571291802,39944.530395543079,0.69409283295462409,0.69409283295462409,null,3674.6517571291802,721,1.5522191903524809,2367.35]
[null,25,"2024-09-02",1,"2024-09-02",31,752,39944.530395543079,3042.5773787557628,632.07437837341729,0,0,3674.6517571291802,36901.953016787316,0.68328073326398509,0.68328073326398509,null,3674.6517571291802,752,1.5818424825552508,2323.02]
[null,26,"2024-10-02",3,"2024-10-02",30,782,36901.953016787316,3109.7023960362085,564.94936109297191,0,0,3674.6517571291802,33792.250620751111,0.67297779949563274,0.67297779949563274,null,3674.6517571291806,782,1.6110483585575541,2280.91]
[null,27,"2024-11-02",6,"2024-11-02",31,813,33792.250620751111,3139.9298416768161,534.72191545236433,0,0,3674.6517571291802,30652.320779074296,0.66249461524092768,0.66249461524092768,null,3674.6517571291806,813,1.6417943746968766,2238.19]
[null,28,"2024-12-02",1,"2024-12-02",30,843,30652.320779074296,3205.380956413645,469.27080071553536,0,0,3674.6517571291802,27446.93982266065,0.65250510754602775,0.65250510754602775,null,3674.6517571291802,843,1.6721071545453605,2197.62]
[null,29,"2025-01-02",4,"2025-01-02",31,874,27446.93982266065,3240.3367894760236,434.3149676531566,0,0,3674.6517571291802,24206.603033184627,0.64234083277401044,0.64234083277401044,null,3674.6517571291802,874,1.704018445902473,2156.46]
[null,30,"2025-02-02",7,"2025-02-03",32,906,24206.603033184627,3279.1546916234583,395.49706550572205,0,0,3674.6517571291802,20927.448341561168,0.63201472592144359,0.63201472592144359,null,3674.6517571291806,906,1.737598059666938,2114.79]
[null,31,"2025-03-02",7,"2025-03-03",28,934,20927.448341561168,3375.7745893260544,298.8771678031257,0,0,3674.6517571291802,17551.673752235114,0.62311564580463585,0.62311564580463585,null,3674.6517571291802,934,1.767522599194149,2078.98]
[null,32,"2025-04-02",3,"2025-04-02",30,964,17551.673752235114,3405.9449255984305,268.70683153074975,0,0,3674.6517571291802,14145.728826636683,0.61371991881247878,0.61371991881247878,null,3674.6517571291802,964,1.8001567245464691,2041.3]
[null,33,"2025-05-02",5,"2025-05-02",30,994,14145.728826636683,3458.0881389605888,216.56361816859143,0,0,3674.6517571291802,10687.640687676094,0.60446586646178757,0.60446586646178757,null,3674.6517571291802,994,1.8333933803207465,2004.29]
[null,34,"2025-06-02",1,"2025-06-02",31,1025,10687.640687676094,3505.5326367628268,169.11912036635331,0,0,3674.6517571291802,7182.1080509132671,0.59504991387234407,0.59504991387234407,null,3674.6517571291802,1025,1.8683827350236302,1966.76]
[null,35,"2025-07-02",3,"2025-07-02",30,1055,7182.1080509132671,3564.6974857978416,109.95427133133856,0,0,3674.6517571291802,3617.4105651154255,0.58607737952002248,0.58607737952002248,null,3674.6517571291802,1055,1.9028790613555655,1931.1]
[null,36,"2025-08-02",6,"2025-08-02",31,1086,3617.4105651154255,3617.4105651154255,57.241192013660125,0,0,3674.6517571290856,0,0.5769478701043661,0.5769478701043661,null,3674.6517571290856,1086,1.9391945139742566,1894.94]
[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":24,"rows_kept":395,"cut":false,"hidden":false,"merged":[[1,2,3,8]]}
[]
[null,null,"Proceso de Cálculo de la Prima de Seguros"]
[]
[]
[]
[]
[null,"1) Datos esenciales del préstamo",null,null,null,"3) Calculo del valor presente del Seguro"]
[]
[null,"Producto",{"$f":"'Vista Principal'!C9","v":"Persona Juridica"},null,null,"Suma de Prima Mensual",{"$f":"SUM(K36:K395)","v":494.32702874116291}]
[null,"Tipo de Seguro",{"$f":"'Vista Principal'!C10","v":"Seguro de Desgravamen"},null,null,"VPN - Valor Presente",{"$f":"NPV(C16,K36:K395)","v":494.32702874116291}]
[null,"Tarifa",{"$f":"'Vista Principal'!C11","v":"TARIFA TITULAR"}]
[null,"Monto inicial",40000,"Indicar Importe",null,"4) Calculo del Monto Adicional del Seguro y MAF"]
[null,{"$f":"C10","v":"Seguro de Desgravamen"},{"$f":"+TarifarioBD!D8","v":9.0899999999999998E-4}]
[null,"Monto adicional Seguro de Desgravamen/ Vida",null,null,null,"Monto inicial",{"$f":"C12","v":40000}]
[null,"MAF Inicial",{"$f":"C12+C14","v":40000},null,null,"Monto adicional de Desgravamen / Vida",{"$f":"G10","v":494.32702874116291}]
[null,"Costo Capital",{"$f":"INDEX(_xlfn._xlws.FILTER(Tabla2[],Tabla2[TARIFA]=C11),0,2)","v":0},null,null,"Prima de Seguro de Desgravamen / Vida",{"$f":"G15/G14","v":1.2358175718529072E-2}]
[null,"Moneda",{"$f":"'Vista Principal'!C19","v":"Soles"},null,null,"MAF Inicial",{"$f":"G14+G15","v":40494.327028741165}]
[null,"Plazo Remanente Meses",24,"Indicar Plazo"]
[null,"Fecha de Desembolso","2022-07-19","Indicar Fecha desembolso"]
[null,"Fecha de 1er Pago","2022-08-19","Indicar Fecha primer pago"]
[null,"Cuota Julio",{"$f":"'Vista Principal'!C23","v":1}]
[null,"Cuota Diciembre",{"$f":"'Vista Principal'!C24","v":1}]
[null,"TEA",0.22620000000000001,"Indicar tasa"]
[null,"TEA TOTAL",{"$f":"(1+(((1+C23)^(30/360)-1)+C13))^12-1","v":0.23941484621357922}]
[null,"Monto del Bien",0]
[null,"Seguro del Bien",0]
[null,"Portes",0]
[null,"Cuota",{"$f":"(C15+(C26*C25+C27)*Q34)/P34","v":2075.6677210987582}]
[]
[null,"TCEA",0.23941089574285895]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C15-V34-C14","v":-7.2759576141834259E-12}]
[]
[null,"2) Creación de Cronograma de prima mensual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P36:P395)","v":19.270907184906232},{"$f":"SUM(Q36:Q395)","v":19.270907184906232},null,null,null,null,{"$f":"SUM(V36:V395)","v":40000.000000000007}]
[null,"N° Cuota","Fecha de pago","Día","Fecha de pago","Días","Dias Acumulados","Saldo Inicial","Amortización","Interés","Seguro Desgravamen","Seguro del Bien","Portes","Cuota Constante","Saldo Final","Factor Cronograma","Factor Cronograma 2",null,"Vector i,1\nCuota","Vector i,2\nDías Acum","Vector i,3 Factor","Vector i,4\nCalculo VA","VPN - Valor Presente","VPN - Valor Presente"]
[null,1,{"$f":"C20","v":"2022-08-19"},{"$f":"IF(B36<=$C$18,WEEKDAY(C36,2),\"\")","v":5},{"$f":"IF(D36=7,C36+1,C36)","v":"2022-08-19"},{"$f":"E36-C19","v":31},{"$f":"F36","v":31},{"$f":"C15","v":40000},{"$f":"IF(B36>C$18,\"\",N36-M36-L36-K36-J36)","v":1329.5010224745715},{"$f":"IF(B36>C$18,\"\",((1+C$23)^(F36/360)-1)*H36)","v":708.59412957503309},{"$f":"IF(B36>C$18,\"\",((1+C$13)^(F36/30)-1)*H36)","v":37.572569049153515},{"$f":"IF(B36>C$18,\"\",C$25*C$26)","v":0},{"$f":"IF(B36>C$18,\"\",C$27)","v":0},{"$f":"IF(B36>C$18,\"\",IF(B36=C$18,H36+J36+K36+L36+M36,IF(AND(C$21=2,MONTH(E36)=7),2*C$28,IF(AND(C$22=2,MONTH(E36)=12),2*C$28,C$28))))","v":2075.6677210987582},{"$f":"IF(B36>C$18,\"\",H36-I36)","v":38670.498977525429},{"$f":"IFERROR(IF(AND(MONTH(E36)=7,C$21=2),2/(1+C$24)^(G36/360),IF(AND(MONTH(E36)=12,C$22=2),2/(1+C$24)^(G36/360),1/(1+C$24)^(G36/360))),\"\")","v":0.98168692545578728},{"$f":"IFERROR(1/(1+C$24)^(G36/360),\"\")","v":0.98168692545578728},null,{"$f":"IFERROR(I36+J36+K36+L36+M36,\"\")","v":2075.6677210987582},{"$f":"G36","v":31},{"$f":"IFERROR((1+C$30)^(T36/360),\"\")","v":1.0186544198574765},{"$f":"IFERROR(ROUND(S36/U36,2),\"\")","v":2037.66},{"$f":"K36/(1+$H$9)","v":37.572569049153515},{"$f":"K36/(1+$P$28)","v":37.572569049153515}]
[null,2,{"$f":"IF(B37>$C$18,\"\",EDATE(C36,1))","v":"2022-09-19"},1,{"$f":"IF(D37=7,C37+1,C37)","v":"2022-09-19"},{"$f":"IF(B37>C$18,\"\",E37-E36)","v":31},{"$f":"IFERROR(F37+G36,\"\")","v":62},{"$f":"IF(B37>C$18,\"\",O36)","v":38670.498977525429},1354.301757193505,685.04221408029593,36.323749824957368,0,0,2075.6677210987582,37316.197220331924,0.96370921961083666,0.96370921961083666,null,2075.6677210987582,62,1.037656827095172,2000.34,{"$f":"IF(N37=\"\",0,K37/((1+$H$9)^B37))","v":36.323749824957368},{"$f":"IF(N37=\"\",0,K37/((1+$P$28)^B37))","v":36.323749824957368}]
[null,3,"2022-10-19",3,"2022-10-19",30,92,37316.197220331924,1402.2022457320681,639.54505209340641,33.920423273283532,0,0,2075.6677210987582,35913.994974599853,0.94662496980058608,0.94662496980058608,null,2075.6677210987582,92,1.0563836971891774,1964.88,33.920423273283532,33.920423273283532]
[null,4,"2022-11-19",6,"2022-11-19",31,123,35913.994974599853,1405.722044483688,636.21115021471735,33.734526400352635,0,0,2075.6677210987582,34508.272930116167,0.92928935616321506,0.92928935616321506,null,2075.6677210987577,123,1.0760899222071376,1928.9,33.734526400352635,33.734526400352635]
[null,5,"2022-12-19",1,"2022-12-19",30,153,34508.272930116167,1452.8783651591971,591.42133584608393,31.368020093477273,0,0,2075.6677210987582,33055.394564956972,0.9128152878616681,0.9128152878616681,null,2075.6677210987582,153,1.0955104046406745,1894.7,31.368020093477273,31.368020093477273]
[null,6,"2023-01-19",4,"2023-01-19",31,184,33055.394564956972,1459.0468552424127,585.5714634878741,31.04940236847149,0,0,2075.6677210987582,31596.347709714559,0.89609883344996044,0.89609883344996044,null,2075.6677210987582,184,1.1159465156870756,1860.01,31.04940236847149,31.04940236847149]
[null,7,"2023-02-19",7,"2023-02-20",32,216,31596.347709714559,1467.0865273678701,577.94444698863515,30.636746742252992,0,0,2075.6677210987582,30129.261182346687,0.87916417674014014,0.87916417674014014,null,2075.6677210987582,216,1.1374418044262489,1824.86,30.636746742252992,30.636746742252992]
[null,8,"2023-03-19",7,"2023-03-20",28,244,30129.261182346687,1568.4337830306861,481.67304714921846,25.560890918853673,0,0,2075.6677210987582,28560.827399316,0.8646090882999482,0.8646090882999482,null,2075.6677210987582,244,1.1565895538274134,1794.65,25.560890918853673,25.560890918853673]
[null,9,"2023-04-19",3,"2023-04-19",30,274,28560.827399316,1560.2151124694365,489.490816523342,25.961792105979633,0,0,2075.6677210987582,27000.612286846565,0.84928164579743237,0.84928164579743237,null,2075.6677210987582,274,1.177462834628006,1762.83,25.961792105979633,25.961792105979633]
[null,10,"2023-05-19",5,"2023-05-19",30,304,27000.612286846565,1588.3731534988965,462.75101103111695,24.54355656874484,0,0,2075.6677210987582,25412.23913334767,0.83422592203677026,0.83422592203677026,null,2075.6677210987582,304,1.1987128211060265,1731.58,24.54355656874484,24.54355656874484]
[null,11,"2023-06-19",1,"2023-06-19",31,335,25412.23913334767,1601.6235566292983,450.17408673117711,23.87007773828266,0,0,2075.6677210987582,23810.61557671837,0.8189486805397963,0.8189486805397963,null,2075.6677210987582,335,1.2210741133594785,1699.87,23.87007773828266,23.87007773828266]
[null,12,"2023-07-19",3,"2023-07-19",30,365,23810.61557671837,1645.944739320458,408.07913221906193,21.643849559238156,0,0,2075.6677210987582,22164.670837397913,0.80443068739891221,0.80443068739891221,null,2075.6677210987582,365,1.243111164240789,1669.74,21.643849559238156,21.643849559238156]
[null,13,"2023-08-19",6,"2023-08-19",31,396,22164.670837397913,1662.2042394779332,392.64389098357736,20.819590637247309,0,0,2075.6677210987582,20502.466597919978,0.78969908825492374,0.78969908825492374,null,{"$f":"IFERROR(I48+J48+K48+L48+M48,\"\")","v":2075.6677210987582},396,1.2663006818280531,1639.16,20.819590637247309,20.819590637247309]
[null,14,"2023-09-19",2,"2023-09-19",31,427,20502.466597919978,1693.211275723193,363.1981868273574,19.258258548207799,0,0,2075.6677210987582,18809.255322196786,0.77523726998421461,0.77523726998421461,null,2075.6677210987582,427,1.2899227864126825,1609.14,19.258258548207799,19.258258548207799]
[null,15,"2023-10-19",4,"2023-10-19",30,457,18809.255322196786,1736.2069769596201,322.36313105126004,17.097613087877793,0,0,2075.6677210987582,17073.048345237166,0.76149417516565987,0.76149417516565987,null,2075.6677210987582,457,1.3132023676978275,1580.62,17.097613087877793,17.097613087877793]
[null,16,"2023-11-19",7,"2023-11-20",32,489,17073.048345237166,1746.8216076799276,312.29158429803425,16.554529120796218,0,0,2075.6677210987582,15326.226737557239,0.74710330446972295,0.74710330446972295,null,2075.6677210987582,489,1.3384971857467474,1550.74,16.554529120796218,16.554529120796218]
[null,17,"2023-12-19",2,"2023-12-19",29,518,15326.226737557239,1808.3593963233507,253.84137330466689,13.466951470740495,0,0,2075.6677210987582,13517.867341233889,0.7342966294827975,0.7342966294827975,null,2075.6677210987582,518,1.3618412145507668,1524.16,13.466951470740495,13.466951470740495]
[null,18,"2024-01-19",5,"2024-01-19",31,549,13517.867341233889,1823.5031599375529,239.46703605930986,12.697525101895188,0,0,2075.6677210987582,11694.364181296336,0.72084940056951508,0.72084940056951508,null,2075.6677210987582,549,1.3872455723462125,1496.25,12.697525101895188,12.697525101895188]
[null,19,"2024-02-19",1,"2024-02-19",31,580,11694.364181296336,1857.5190932570874,207.16394519947804,10.984682642192604,0,0,2075.6677210987582,9836.8450880392484,0.70764843176173453,0.70764843176173453,null,2075.6677210987582,580,1.4131238336981842,1468.85,10.984682642192604,10.984682642192604]
[null,20,"2024-03-19",2,"2024-03-19",29,609,9836.8450880392484,1904.1009926022136,162.9232236277833,8.6435048687613634,0,0,2075.6677210987582,7932.744095437035,0.69551808323247399,0.69551808323247399,null,2075.6677210987582,609,1.4377693868071304,1443.67,8.6435048687613634,8.6435048687613634]
[null,21,"2024-04-19",5,"2024-04-19",31,640,7932.744095437035,1927.6889842806891,140.52739743619222,7.4513393818768208,0,0,2075.6677210987582,6005.0551111563454,0.68278100872738989,0.68278100872738989,null,2075.6677210987582,640,1.4645901406068573,1417.23,7.4513393818768208,7.4513393818768208]
[null,22,"2024-05-19",7,"2024-05-20",31,671,6005.0551111563454,1963.6484174150626,106.37866998849836,5.6406336951973506,0,0,2075.6677210987582,4041.4066937412827,0.67027718921719248,0.67027718921719248,null,2075.6677210987582,671,1.4919112200088582,1391.28,5.6406336951973506,5.6406336951973506]
[null,23,"2024-06-19",3,"2024-06-19",30,701,4041.4066937412827,2002.7302815177595,69.263800896387792,3.6736386846110225,0,0,2075.6677210987582,2038.6764122235231,0.65839478453570233,0.65839478453570233,null,2075.6677210987582,701,1.5188361405407331,1366.62,3.6736386846110225,3.6736386846110225]
[null,24,"2024-07-19",5,"2024-07-19",30,731,2038.6764122235231,2038.6764122235231,34.939932505949344,1.8531568587112817,0,0,2075.4695015881839,0,0.64672302634985002,0.64672302634985002,null,2075.4695015881839,731,1.5462469823096929,1342.26,1.8531568587112817,1.8531568587112817]
[null,25,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,26,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,27,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,28,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,29,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,30,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,31,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,32,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,33,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,34,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,35,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,36,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,37,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,38,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,39,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,40,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,41,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,42,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,43,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,44,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,45,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,46,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,47,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,48,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,49,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,50,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,51,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,52,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,53,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,54,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,55,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,56,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,57,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,58,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,59,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,60,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,61,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,62,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,63,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,64,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,65,"",{"$f":"IF(B100<=$C$18,WEEKDAY(C100,2),\"\")","v":""},"","","","",{"$f":"IF(B100>C$18,\"\",N100-M100-L100-K100-J100)","v":""},{"$f":"IF(B100>C$18,\"\",((1+C$23)^(F100/360)-1)*H100)","v":""},{"$f":"IF(B100>C$18,\"\",((1+C$13)^(F100/30)-1)*H100)","v":""},{"$f":"IF(B100>C$18,\"\",C$25*C$26)","v":""},{"$f":"IF(B100>C$18,\"\",C$27)","v":""},{"$f":"IF(B100>C$18,\"\",IF(B100=C$18,H100+J100+K100+L100+M100,IF(AND(C$21=2,MONTH(E100)=7),2*C$28,IF(AND(C$22=2,MONTH(E100)=12),2*C$28,C$28))))","v":""},{"$f":"IF(B100>C$18,\"\",H100-I100)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E100)=7,C$21=2),2/(1+C$24)^(G100/360),IF(AND(MONTH(E100)=12,C$22=2),2/(1+C$24)^(G100/360),1/(1+C$24)^(G100/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$24)^(G100/360),\"\")","v":""},null,"",{"$f":"G100","v":""},{"$f":"IFERROR((1+C$30)^(T100/360),\"\")","v":""},{"$f":"IFERROR(ROUND(S100/U100,2),\"\")","v":""},0,0]
[null,66,{"$f":"IF(B101>$C$18,\"\",EDATE(C100,1))","v":""},"",{"$f":"IF(D101=7,C101+1,C101)","v":""},{"$f":"IF(B101>C$18,\"\",E101-E100)","v":""},{"$f":"IFERROR(F101+G100,\"\")","v":""},{"$f":"IF(B101>C$18,\"\",O100)","v":""},"","","","","","","","","",null,{"$f":"IFERROR(I101+J101+K101+L101+M101,\"\")","v":""},"","","",{"$f":"IF(N101=\"\",0,K101/((1+$H$9)^B101))","v":0},{"$f":"IF(N101=\"\",0,K101/((1+$P$28)^B101))","v":0}]
[null,67,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,68,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,69,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,70,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,71,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,72,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,73,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,74,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,75,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,76,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,77,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,78,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,79,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,80,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,81,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,82,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,83,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,84,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,85,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,86,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,87,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,88,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,89,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,90,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,91,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,92,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,93,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,94,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,95,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,96,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,97,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,98,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,99,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,100,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,101,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,102,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,103,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,104,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,105,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,106,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,107,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,108,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,109,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,110,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,111,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,112,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,113,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,114,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,115,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,116,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,117,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,118,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,119,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,120,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,121,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,122,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,123,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,124,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,125,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,126,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,127,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,128,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,129,"",{"$f":"IF(B164<=$C$18,WEEKDAY(C164,2),\"\")","v":""},"","","","",{"$f":"IF(B164>C$18,\"\",N164-M164-L164-K164-J164)","v":""},{"$f":"IF(B164>C$18,\"\",((1+C$23)^(F164/360)-1)*H164)","v":""},{"$f":"IF(B164>C$18,\"\",((1+C$13)^(F164/30)-1)*H164)","v":""},{"$f":"IF(B164>C$18,\"\",C$25*C$26)","v":""},{"$f":"IF(B164>C$18,\"\",C$27)","v":""},{"$f":"IF(B164>C$18,\"\",IF(B164=C$18,H164+J164+K164+L164+M164,IF(AND(C$21=2,MONTH(E164)=7),2*C$28,IF(AND(C$22=2,MONTH(E164)=12),2*C$28,C$28))))","v":""},{"$f":"IF(B164>C$18,\"\",H164-I164)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E164)=7,C$21=2),2/(1+C$24)^(G164/360),IF(AND(MONTH(E164)=12,C$22=2),2/(1+C$24)^(G164/360),1/(1+C$24)^(G164/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$24)^(G164/360),\"\")","v":""},null,"",{"$f":"G164","v":""},{"$f":"IFERROR((1+C$30)^(T164/360),\"\")","v":""},{"$f":"IFERROR(ROUND(S164/U164,2),\"\")","v":""},0,0]
[null,130,{"$f":"IF(B165>$C$18,\"\",EDATE(C164,1))","v":""},"",{"$f":"IF(D165=7,C165+1,C165)","v":""},{"$f":"IF(B165>C$18,\"\",E165-E164)","v":""},{"$f":"IFERROR(F165+G164,\"\")","v":""},{"$f":"IF(B165>C$18,\"\",O164)","v":""},"","","","","","","","","",null,{"$f":"IFERROR(I165+J165+K165+L165+M165,\"\")","v":""},"","","",{"$f":"IF(N165=\"\",0,K165/((1+$H$9)^B165))","v":0},{"$f":"IF(N165=\"\",0,K165/((1+$P$28)^B165))","v":0}]
[null,131,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,132,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,133,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,134,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,135,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,136,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,137,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,138,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,139,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,140,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,141,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,142,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,143,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,144,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,145,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,146,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,147,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,148,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,149,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,150,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,151,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,152,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,153,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,154,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,155,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,156,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,157,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,158,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,159,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,160,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,161,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,162,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,163,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,164,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,165,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,166,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,167,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,168,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,169,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,170,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,171,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,172,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,173,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,174,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,175,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,176,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,177,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,178,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,179,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,180,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,181,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,182,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,183,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,184,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,185,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,186,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,187,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,188,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,189,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,190,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,191,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,192,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,193,"",{"$f":"IF(B228<=$C$18,WEEKDAY(C228,2),\"\")","v":""},"","","","",{"$f":"IF(B228>C$18,\"\",N228-M228-L228-K228-J228)","v":""},{"$f":"IF(B228>C$18,\"\",((1+C$23)^(F228/360)-1)*H228)","v":""},{"$f":"IF(B228>C$18,\"\",((1+C$13)^(F228/30)-1)*H228)","v":""},{"$f":"IF(B228>C$18,\"\",C$25*C$26)","v":""},{"$f":"IF(B228>C$18,\"\",C$27)","v":""},{"$f":"IF(B228>C$18,\"\",IF(B228=C$18,H228+J228+K228+L228+M228,IF(AND(C$21=2,MONTH(E228)=7),2*C$28,IF(AND(C$22=2,MONTH(E228)=12),2*C$28,C$28))))","v":""},{"$f":"IF(B228>C$18,\"\",H228-I228)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E228)=7,C$21=2),2/(1+C$24)^(G228/360),IF(AND(MONTH(E228)=12,C$22=2),2/(1+C$24)^(G228/360),1/(1+C$24)^(G228/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$24)^(G228/360),\"\")","v":""},null,"",{"$f":"G228","v":""},{"$f":"IFERROR((1+C$30)^(T228/360),\"\")","v":""},{"$f":"IFERROR(ROUND(S228/U228,2),\"\")","v":""},0,0]
[null,194,{"$f":"IF(B229>$C$18,\"\",EDATE(C228,1))","v":""},"",{"$f":"IF(D229=7,C229+1,C229)","v":""},{"$f":"IF(B229>C$18,\"\",E229-E228)","v":""},{"$f":"IFERROR(F229+G228,\"\")","v":""},{"$f":"IF(B229>C$18,\"\",O228)","v":""},"","","","","","","","","",null,{"$f":"IFERROR(I229+J229+K229+L229+M229,\"\")","v":""},"","","",{"$f":"IF(N229=\"\",0,K229/((1+$H$9)^B229))","v":0},{"$f":"IF(N229=\"\",0,K229/((1+$P$28)^B229))","v":0}]
[null,195,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,196,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,197,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,198,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,199,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,200,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,201,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,202,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,203,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,204,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,205,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,206,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,207,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,208,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,209,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,210,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,211,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,212,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,213,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,214,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,215,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,216,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,217,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,218,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,219,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,220,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,221,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,222,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,223,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,224,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,225,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,226,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,227,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,228,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,229,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,230,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,231,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,232,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,233,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,234,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,235,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,236,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,237,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,238,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,239,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,240,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,241,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,242,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,243,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,244,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,245,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,246,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,247,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,248,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,249,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,250,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,251,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,252,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,253,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,254,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,255,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,256,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,257,"",{"$f":"IF(B292<=$C$18,WEEKDAY(C292,2),\"\")","v":""},"","","","",{"$f":"IF(B292>C$18,\"\",N292-M292-L292-K292-J292)","v":""},{"$f":"IF(B292>C$18,\"\",((1+C$23)^(F292/360)-1)*H292)","v":""},{"$f":"IF(B292>C$18,\"\",((1+C$13)^(F292/30)-1)*H292)","v":""},{"$f":"IF(B292>C$18,\"\",C$25*C$26)","v":""},{"$f":"IF(B292>C$18,\"\",C$27)","v":""},{"$f":"IF(B292>C$18,\"\",IF(B292=C$18,H292+J292+K292+L292+M292,IF(AND(C$21=2,MONTH(E292)=7),2*C$28,IF(AND(C$22=2,MONTH(E292)=12),2*C$28,C$28))))","v":""},{"$f":"IF(B292>C$18,\"\",H292-I292)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E292)=7,C$21=2),2/(1+C$24)^(G292/360),IF(AND(MONTH(E292)=12,C$22=2),2/(1+C$24)^(G292/360),1/(1+C$24)^(G292/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$24)^(G292/360),\"\")","v":""},null,"",{"$f":"G292","v":""},{"$f":"IFERROR((1+C$30)^(T292/360),\"\")","v":""},{"$f":"IFERROR(ROUND(S292/U292,2),\"\")","v":""},0,0]
[null,258,{"$f":"IF(B293>$C$18,\"\",EDATE(C292,1))","v":""},"",{"$f":"IF(D293=7,C293+1,C293)","v":""},{"$f":"IF(B293>C$18,\"\",E293-E292)","v":""},{"$f":"IFERROR(F293+G292,\"\")","v":""},{"$f":"IF(B293>C$18,\"\",O292)","v":""},"","","","","","","","","",null,{"$f":"IFERROR(I293+J293+K293+L293+M293,\"\")","v":""},"","","",{"$f":"IF(N293=\"\",0,K293/((1+$H$9)^B293))","v":0},{"$f":"IF(N293=\"\",0,K293/((1+$P$28)^B293))","v":0}]
[null,259,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,260,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,261,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,262,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,263,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,264,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,265,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,266,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,267,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,268,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,269,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,270,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,271,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,272,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,273,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,274,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,275,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,276,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,277,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,278,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,279,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,280,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,281,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,282,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,283,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,284,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,285,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,286,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,287,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,288,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,289,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,290,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,291,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,292,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,293,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,294,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,295,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,296,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,297,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,298,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,299,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,300,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,301,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,302,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,303,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,304,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,305,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,306,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,307,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,308,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,309,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,310,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,311,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,312,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,313,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,314,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,315,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,316,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,317,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,318,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,319,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,320,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,321,"",{"$f":"IF(B356<=$C$18,WEEKDAY(C356,2),\"\")","v":""},"","","","",{"$f":"IF(B356>C$18,\"\",N356-M356-L356-K356-J356)","v":""},{"$f":"IF(B356>C$18,\"\",((1+C$23)^(F356/360)-1)*H356)","v":""},{"$f":"IF(B356>C$18,\"\",((1+C$13)^(F356/30)-1)*H356)","v":""},{"$f":"IF(B356>C$18,\"\",C$25*C$26)","v":""},{"$f":"IF(B356>C$18,\"\",C$27)","v":""},{"$f":"IF(B356>C$18,\"\",IF(B356=C$18,H356+J356+K356+L356+M356,IF(AND(C$21=2,MONTH(E356)=7),2*C$28,IF(AND(C$22=2,MONTH(E356)=12),2*C$28,C$28))))","v":""},{"$f":"IF(B356>C$18,\"\",H356-I356)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E356)=7,C$21=2),2/(1+C$24)^(G356/360),IF(AND(MONTH(E356)=12,C$22=2),2/(1+C$24)^(G356/360),1/(1+C$24)^(G356/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$24)^(G356/360),\"\")","v":""},null,"",{"$f":"G356","v":""},{"$f":"IFERROR((1+C$30)^(T356/360),\"\")","v":""},{"$f":"IFERROR(ROUND(S356/U356,2),\"\")","v":""},0,0]
[null,322,{"$f":"IF(B357>$C$18,\"\",EDATE(C356,1))","v":""},"",{"$f":"IF(D357=7,C357+1,C357)","v":""},{"$f":"IF(B357>C$18,\"\",E357-E356)","v":""},{"$f":"IFERROR(F357+G356,\"\")","v":""},{"$f":"IF(B357>C$18,\"\",O356)","v":""},"","","","","","","","","",null,{"$f":"IFERROR(I357+J357+K357+L357+M357,\"\")","v":""},"","","",{"$f":"IF(N357=\"\",0,K357/((1+$H$9)^B357))","v":0},{"$f":"IF(N357=\"\",0,K357/((1+$P$28)^B357))","v":0}]
[null,323,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,324,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,325,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,326,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,327,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,328,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,329,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,330,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,331,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,332,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,333,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,334,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,335,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,336,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,337,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,338,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,339,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,340,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,341,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,342,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,343,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,344,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,345,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,346,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,347,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,348,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,349,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,350,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,351,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,352,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,353,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,354,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,355,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,356,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,357,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,358,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,359,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,360,"","","","","","","","","","","","","","","",null,"","","","",0,0]

{"sheet":"TarifarioBD","index":2,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TARIFA","PRODUCTO","TIPO_SEGURO","Valor","Columna1","Columna2",null,"TARIFA","PRODUCTO","TIPO_SEGURO"]
["TARIFA TITULAR","Persona Natural","Seguro de Vida",9.7499999999999996E-4,"TARIFA TITULARPersona NaturalSeguro de Vida",9.7499999999999996E-4,null,"TARIFA TITULAR","Persona Juridica"]
["TARIFA TITULAR","Persona Natural","Seguro de Desgravamen",2E-3,"TARIFA TITULARPersona NaturalSeguro de Desgravamen",2E-3,null,null,null,"Seguro de Desgravamen"]
["TARIFA TITULAR","Persona Natural","Seguro de Desgravamen con Devolución",2.5999999999999999E-3,"TARIFA TITULARPersona NaturalSeguro de Desgravamen con Devolución",2.5999999999999999E-3,null,null,null,"Seguro de Desgravamen con Devolución"]
["TARIFA TITULAR + CONYUGE","Persona Natural","Seguro de Vida",1.9499999999999999E-3,"TARIFA TITULAR + CONYUGEPersona NaturalSeguro de Vida",1.9499999999999999E-3]
["TARIFA TITULAR + CONYUGE","Persona Natural","Seguro de Desgravamen",4.0000000000000001E-3,"TARIFA TITULAR + CONYUGEPersona NaturalSeguro de Desgravamen",4.0000000000000001E-3]
["TARIFA TITULAR + CONYUGE","Persona Natural","Seguro de Desgravamen con Devolución",5.1999999999999998E-3,"TARIFA TITULAR + CONYUGEPersona NaturalSeguro de Desgravamen con Devolución",5.1999999999999998E-3]
["TARIFA TITULAR","Persona Jurídica","Seguro de Desgravamen",9.0899999999999998E-4,"TARIFA TITULARPersona JurídicaSeguro de Desgravamen",9.0899999999999998E-4]
["TARIFA TITULAR","Persona Jurídica","Seguro de Desgravamen con Devolución",1.8E-3,"TARIFA TITULARPersona JurídicaSeguro de Desgravamen con Devolución",1.8E-3]
["TARIFA TITULAR + CONYUGE","Persona Jurídica","Seguro de Desgravamen",1.591E-3,"TARIFA TITULAR + CONYUGEPersona JurídicaSeguro de Desgravamen",1.591E-3]
["TARIFA TITULAR + CONYUGE","Persona Jurídica","Seguro de Desgravamen con Devolución",3.15E-3,"TARIFA TITULAR + CONYUGEPersona JurídicaSeguro de Desgravamen con Devolución",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]