{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Vista Principal","Proceso Prima de Seguro","TarifarioBD","CostoCapBD"],"not_rendered":{"macros":1,"defined_names":5,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Vista Principal","index":0,"n_rows":395,"n_cols":21,"rows_kept":395,"merged":[[1,2,3,8]]}
[]
[null,null,"Calculadora de Seguros PP - Scotiabank"]
[]
[]
[]
[]
[null,"1) Establecer los datos del préstamos"]
[]
[null,"Producto","Préstamos Personales (LD Y PA) (Clientes)"]
[null,"Tipo de Seguro","Seguro de Desgravamen","Seleccionar"]
[null,"Tarifa","TARIFA TITULAR","Seleccionar"]
[null,"Monto inicial",{"v":20000,"d":"20,000.00"},"Digitar"]
[null,"Seguro Desempleo",{"v":0,"d":"0.000%"},"Digitar en caso aplique"]
[null,"Monto adicional desempleo",{"$f":"+H17","v":0}]
[null,"Prima de Seguro de Desgravamen/Vida",{"$f":"IF(C10=\"Seguro de vida\",'Proceso Prima de Seguro'!D13, IF(AND(C10=\"Sin Seguro (Solo LD Garantía Liquida)\",C9=\"Préstamos Personales (LD Garantía Liquida)\"),0%, 'Proceso Prima de Seguro'!H16))","v":{"v":0.02752007594918048,"d":"2.7520%"}}]
[null,"Monto adicional del Seguro",{"$f":"+C15*C12","v":{"v":550.4015189836095,"d":"550.40"}},{"$nulls":3},"MAF SIN SEGURO","MONTO SEGURO DESEMNPLEO","MAF CON DESEMBPLEP"]
[null,"MAF Inicial",{"$f":"+I17","v":{"v":20550.40151898361,"d":"20,550.40"}},{"$nulls":3},{"$f":"+C12+C16","v":{"v":20550.40151898361,"d":"20550.40"}},{"$f":"+G17*C13","v":0},{"$f":"+H17+G17","v":{"v":20550.40151898361,"d":"20,550.40"}}]
[null,"Empleado","si"]
[null,"Moneda","Soles","Seleccionar"]
[null,"Plazo Remanente",24,"Digitar"]
[null,"Fecha de Desembolso","2023-09-07"]
[null,"Fecha de 1er Pago","2023-10-07","Digitar"]
[null,"Cuota Julio",1,"Digitar 2 en caso de cuota doble"]
[null,"Cuota Diciembre",1,"Digitar 2 en caso de cuota doble"]
[null,"TEA",{"v":0.4,"d":"40.000%"},"Digitar"]
[null,"TEA TOTAL",{"$f":"+C25","v":{"v":0.4,"d":"40.000%"}}]
[null,"Monto del Bien",0]
[null,"Seguro del Bien",{"v":0,"d":"0.000%"}]
[null,"Portes",0,"Digitar"]
[null,"Cuota",{"$f":"(C17+(C28*C27+C29)*P34)/O34","v":{"v":1198.8210554285079,"d":"1,198.82"}}]
[null,"2) Calcular TCEA presionando el botón "]
[null,"TCEA",{"v":0.44109630476226247,"d":"44.11%"},null,null,"*Borrar la TCEA para volver a calcular"]
[{"$nulls":20},{"$f":"C17-U34-C14-C16","v":0}]
[{"$nulls":14},{"$f":"SUM(O36:O395)","v":{"v":17.14217599526399,"d":"17.14"}},{"$f":"SUM(P36:P395)","v":{"v":17.14217599526399,"d":"17.14"}},{"$nulls":4},{"$f":"SUM(U36:U395)","v":{"v":20000,"d":"20,000.00"}}]
[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":"2023-10-07"},{"$f":"IF(B36<=$C$20,WEEKDAY(C36,2),\"\")","v":6},{"$f":"IF(D36=7,C36+1,C36)","v":"2023-10-07"},{"$f":"E36-C21","v":30},{"$f":"F36","v":30},{"$f":"C17","v":{"v":20550.40151898361,"d":"20,550.40"}},{"$f":"IF(B36>C$20,\"\",M36-L36-K36-J36)","v":{"v":614.4466375954388,"d":"614.45"}},{"$f":"IF(B36>C$20,\"\",((1+C$25)^(F36/360)-1)*H36)","v":{"v":584.3744178330691,"d":"584.37"}},{"$f":"IF(B36>C$20,\"\",C$27*C$28)","v":{"v":0,"d":"0.00"}},{"$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":{"v":1198.8210554285079,"d":"1,198.82"}},{"$f":"IF(B36>C$20,\"\",H36-I36)","v":{"v":19935.95488138817,"d":"19,935.95"}},{"$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":{"v":0.9723501011044507,"d":"0.97"}},{"$f":"IFERROR(1/(1+C$26)^(G36/360),\"\")","v":{"v":0.9723501011044507,"d":"0.97"}},null,{"$f":"IFERROR(I36+J36+K36+L36,\"\")","v":{"v":1198.8210554285079,"d":"1,198.82"}},{"$f":"G36","v":30},{"$f":"IFERROR((1+C$32)^(S36/360),\"\")","v":{"v":1.0309186990837647,"d":"1.03"}},{"$f":"IFERROR(ROUND(R36/T36,2),\"\")","v":{"v":1162.87,"d":"1,162.87"}}]
[null,2,{"$f":"IF(B37>$C$20,\"\",EDATE(C36,1))","v":"2023-11-07"},2,{"$f":"IF(D37=7,C37+1,C37)","v":"2023-11-07"},{"$f":"IF(B37>C$20,\"\",E37-E36)","v":31},{"$f":"IFERROR(F37+G36,\"\")","v":61},{"$f":"IF(B37>C$20,\"\",N36)","v":{"v":19935.95488138817,"d":"19,935.95"}},{"$f":"IF(B37>C$20,\"\",M37-L37-K37-J37)","v":{"v":612.7472851456522,"d":"612.75"}},{"v":586.0737702828557,"d":"586.07"},{"v":0,"d":"0.00"},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":{"v":1198.8210554285079,"d":"1,198.82"}},{"v":19323.20759624252,"d":"19,323.21"},{"v":0.9445814579814036,"d":"0.94"},{"v":0.9445814579814036,"d":"0.94"},null,{"$f":"IFERROR(I37+J37+K37+L37,\"\")","v":{"v":1198.8210554285079,"d":"1,198.82"}},61,{"v":1.0638726592828383,"d":"1.06"},{"v":1126.85,"d":"1,126.85"}]
[null,3,"2023-12-07",4,"2023-12-07",30,91,{"v":19323.20759624252,"d":"19,323.21"},{"v":649.3433150889487,"d":"649.34"},{"v":549.4777403395592,"d":"549.48"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":18673.86428115357,"d":"18,673.86"},{"v":0.9184638761696072,"d":"0.92"},{"v":0.9184638761696072,"d":"0.92"},null,{"v":1198.8210554285079,"d":"1,198.82"},91,{"v":1.0967662178986488,"d":"1.10"},{"v":1093.05,"d":"1,093.05"}]
[null,4,"2024-01-07",7,"2024-01-08",32,123,{"v":18673.86428115357,"d":"18,673.86"},{"v":631.8750797216437,"d":"631.88"},{"v":566.9459757068641,"d":"566.95"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":18041.989201431923,"d":"18,041.99"},{"v":0.8914005980916572,"d":"0.89"},{"v":0.8914005980916572,"d":"0.89"},null,{"v":1198.8210554285079,"d":"1,198.82"},123,{"v":1.1329744338449927,"d":"1.13"},{"v":1058.12,"d":"1,058.12"}]
[null,5,"2024-02-07",3,"2024-02-07",30,153,{"v":18041.989201431923,"d":"18,041.99"},{"v":685.7762408832614,"d":"685.78"},{"v":513.0448145452465,"d":"513.04"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":17356.212960548663,"d":"17,356.21"},{"v":0.8667534616789907,"d":"0.87"},{"v":0.8667534616789907,"d":"0.87"},null,{"v":1198.8210554285079,"d":"1,198.82"},153,{"v":1.1680045294346446,"d":"1.17"},{"v":1026.38,"d":"1,026.38"}]
[null,6,"2024-03-07",4,"2024-03-07",29,182,{"v":17356.212960548663,"d":"17,356.21"},{"v":721.9524747473326,"d":"721.95"},{"v":476.8685806811752,"d":"476.87"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":16634.26048580133,"d":"16,634.26"},{"v":0.8435758918284997,"d":"0.84"},{"v":0.8435758918284997,"d":"0.84"},null,{"v":1198.8210554285079,"d":"1,198.82"},182,{"v":1.2028961367237063,"d":"1.20"},996.61]
[null,7,"2024-04-07",7,"2024-04-08",32,214,{"v":16634.26048580133,"d":"16,634.26"},{"v":693.7982653248737,"d":"693.80"},{"v":505.0227901036342,"d":"505.02"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":15940.462220476456,"d":"15,940.46"},{"v":0.8187192485431697,"d":"0.82"},{"v":0.8187192485431697,"d":"0.82"},null,{"v":1198.8210554285079,"d":"1,198.82"},214,{"v":1.2426080847840355,"d":"1.24"},964.76]
[null,8,"2024-05-07",2,"2024-05-07",29,243,{"v":15940.462220476456,"d":"15,940.46"},{"v":760.8507671081804,"d":"760.85"},{"v":437.9702883203275,"d":"437.97"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":15179.611453368276,"d":"15,179.61"},{"v":0.796826145821327,"d":"0.80"},{"v":0.796826145821327,"d":"0.80"},null,{"v":1198.8210554285079,"d":"1,198.82"},243,{"v":1.279728311817302,"d":"1.28"},936.78]
[null,9,"2024-06-07",5,"2024-06-07",31,274,{"v":15179.611453368276,"d":"15,179.61"},{"v":752.5734505941967,"d":"752.57"},{"v":446.2476048343111,"d":"446.25"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":14427.03800277408,"d":"14,427.04"},{"v":0.7740701643602333,"d":"0.77"},{"v":0.7740701643602333,"d":"0.77"},null,{"v":1198.8210554285079,"d":"1,198.82"},274,{"v":1.320635626711033,"d":"1.32"},907.76]
[null,10,"2024-07-07",7,"2024-07-08",31,305,{"v":14427.03800277408,"d":"14,427.04"},{"v":774.6974753639502,"d":"774.70"},{"v":424.1235800645577,"d":"424.12"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":13652.34052741013,"d":"13,652.34"},{"v":0.7519640545116277,"d":"0.75"},{"v":0.7519640545116277,"d":"0.75"},null,{"v":1198.8210554285079,"d":"1,198.82"},305,{"v":1.36285056947887,"d":"1.36"},879.64]
[null,11,"2024-08-07",3,"2024-08-07",30,335,{"v":13652.34052741013,"d":"13,652.34"},{"v":810.6009741617603,"d":"810.60"},{"v":388.22008126674757,"d":"388.22"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":12841.73955324837,"d":"12,841.74"},{"v":0.7311723244312939,"d":"0.73"},{"v":0.7311723244312939,"d":"0.73"},null,{"v":1198.8210554285079,"d":"1,198.82"},335,{"v":1.4049881361327243,"d":"1.40"},853.26]
[null,12,"2024-09-07",6,"2024-09-07",31,366,{"v":12841.73955324837,"d":"12,841.74"},{"v":821.3018063260197,"d":"821.30"},{"v":377.51924910248823,"d":"377.52"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":12020.437746922351,"d":"12,020.44"},{"v":0.710291302960201,"d":"0.71"},{"v":0.710291302960201,"d":"0.71"},null,{"v":1198.8210554285079,"d":"1,198.82"},366,{"v":1.449899459556616,"d":"1.45"},826.83]
[null,13,"2024-10-07",1,"2024-10-07",30,396,{"v":12020.437746922351,"d":"12,020.44"},{"v":857.0060157579927,"d":"857.01"},{"v":341.81503967051515,"d":"341.82"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":11163.431731164359,"d":"11,163.43"},{"v":0.6906518202469635,"d":"0.69"},{"v":0.6906518202469635,"d":"0.69"},null,{"v":1198.8210554285079,"d":"1,198.82"},396,{"v":1.49472846464836,"d":"1.49"},802.03]
[null,14,"2024-11-07",4,"2024-11-07",31,427,{"v":11163.431731164359,"d":"11,163.43"},{"v":870.6404108140478,"d":"870.64"},{"v":328.18064461446016,"d":"328.18"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":10292.791320350312,"d":"10,292.79"},{"v":0.6709279945416575,"d":"0.67"},{"v":0.6709279945416575,"d":"0.67"},null,{"v":1198.8210554285079,"d":"1,198.82"},427,{"v":1.5425083937312472,"d":"1.54"},777.19]
[null,15,"2024-12-07",6,"2024-12-07",30,457,{"v":10292.791320350312,"d":"10,292.79"},{"v":906.1336385840868,"d":"906.13"},{"v":292.6874168444211,"d":"292.69"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":9386.657681766224,"d":"9,386.66"},{"v":0.6523769033263871,"d":"0.65"},{"v":0.6523769033263871,"d":"0.65"},null,{"v":1198.8210554285079,"d":"1,198.82"},457,{"v":1.5902007465912045,"d":"1.59"},753.88]
[null,16,"2025-01-07",2,"2025-01-07",31,488,{"v":9386.657681766224,"d":"9,386.66"},{"v":922.8737085049278,"d":"922.87"},{"v":275.9473469235801,"d":"275.95"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":8463.783973261297,"d":"8,463.78"},{"v":0.6337461432846981,"d":"0.63"},{"v":0.6337461432846981,"d":"0.63"},null,{"v":1198.8210554285079,"d":"1,198.82"},488,{"v":1.6410325068049612,"d":"1.64"},730.53]
[null,17,"2025-02-07",5,"2025-02-07",31,519,{"v":8463.783973261297,"d":"8,463.78"},{"v":950.004190945142,"d":"950.00"},{"v":248.81686448336592,"d":"248.82"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":7513.779782316155,"d":"7,513.78"},{"v":0.615647445641235,"d":"0.62"},{"v":0.615647445641235,"d":"0.62"},null,{"v":1198.8210554285079,"d":"1,198.82"},519,{"v":1.6934891359869706,"d":"1.69"},{"v":707.9,"d":"707.90"}]
[null,18,"2025-03-07",5,"2025-03-07",28,547,{"v":7513.779782316155,"d":"7,513.78"},{"v":999.58938417395,"d":"999.59"},{"v":199.23167125455794,"d":"199.23"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":6514.190398142206,"d":"6,514.19"},{"v":0.5997449061160384,"d":"0.60"},{"v":0.5997449061160384,"d":"0.60"},null,{"v":1198.8210554285079,"d":"1,198.82"},547,{"v":1.7423090969268753,"d":"1.74"},688.06]
[null,19,"2025-04-07",1,"2025-04-07",31,578,{"v":6514.190398142206,"d":"6,514.19"},{"v":1007.3180073079585,"d":"1,007.32"},{"v":191.50304812054935,"d":"191.50"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":5506.872390834247,"d":"5,506.87"},{"v":0.5826172252078089,"d":"0.58"},{"v":0.5826172252078089,"d":"0.58"},null,{"v":1198.8210554285079,"d":"1,198.82"},578,{"v":1.7980030955764692,"d":"1.80"},666.75]
[null,20,"2025-05-07",3,"2025-05-07",30,608,{"v":5506.872390834247,"d":"5,506.87"},{"v":1042.226774557546,"d":"1,042.23"},{"v":156.59428087096205,"d":"156.59"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":4464.645616276701,"d":"4,464.65"},{"v":0.5665079178360075,"d":"0.57"},{"v":0.5665079178360075,"d":"0.57"},null,{"v":1198.8210554285079,"d":"1,198.82"},608,{"v":1.8535950122402751,"d":"1.85"},646.75]
[null,21,"2025-06-07",6,"2025-06-07",31,639,{"v":4464.645616276701,"d":"4,464.65"},{"v":1067.570172043387,"d":"1,067.57"},{"v":131.2508833851209,"d":"131.25"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":3397.0754442333136,"d":"3,397.08"},{"v":0.550329428031872,"d":"0.55"},{"v":0.550329428031872,"d":"0.55"},null,{"v":1198.8210554285079,"d":"1,198.82"},639,{"v":1.9128463346897133,"d":"1.91"},626.72]
[null,22,"2025-07-07",1,"2025-07-07",30,669,{"v":3397.0754442333136,"d":"3,397.08"},{"v":1102.2212890820915,"d":"1,102.22"},{"v":96.59976634641639,"d":"96.60"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":2294.854155151222,"d":"2,294.85"},{"v":0.5351128749875451,"d":"0.54"},{"v":0.5351128749875451,"d":"0.54"},null,{"v":1198.8210554285079,"d":"1,198.82"},669,{"v":1.9719890549054666,"d":"1.97"},607.92]
[null,23,"2025-08-07",4,"2025-08-07",31,700,{"v":2294.854155151222,"d":"2,294.85"},{"v":1131.3573279591817,"d":"1,131.36"},{"v":67.46372746932617,"d":"67.46"},{"v":0,"d":"0.00"},0,{"v":1198.8210554285079,"d":"1,198.82"},{"v":1163.4968271920404,"d":"1,163.50"},{"v":0.5198309735004175,"d":"0.52"},{"v":0.5198309735004175,"d":"0.52"},null,{"v":1198.8210554285079,"d":"1,198.82"},700,{"v":2.0350249168857752,"d":"2.04"},589.09]
[null,24,"2025-09-07",7,"2025-09-08",32,732,{"v":1163.4968271920404,"d":"1,163.50"},{"v":1163.4968271920404,"d":"1,163.50"},{"v":35.32422823646457,"d":"35.32"},{"v":0,"d":"0.00"},0,{"v":1198.821055428505,"d":"1,198.82"},0,{"v":0.5045137350609001,"d":"0.50"},{"v":0.5045137350609001,"d":"0.50"},null,{"v":1198.821055428505,"d":"1,198.82"},732,{"v":2.1022084428225667,"d":"2.10"},570.27]
[null,25,"","","","","","","","","","","","","","",null,"","","",""]
[null,26,"","","","","","","","","","","","","","",null,"","","",""]
[null,27,"","","","","","","","","","","","","","",null,"","","",""]
[null,28,"","","","","","","","","","","","","","",null,"","","",""]
[null,29,"","","","","","","","","","","","","","",null,"","","",""]
[null,30,"","","","","","","","","","","","","","",null,"","","",""]
[null,31,"","","","","","","","","","","","","","",null,"","","",""]
[null,32,"","","","","","","","","","","","","","",null,"","","",""]
[null,33,"","","","","","","","","","","","","","",null,"","","",""]
[null,34,"","","","","","","","","","","","","","",null,"","","",""]
[null,35,"","","","","","","","","","","","","","",null,"","","",""]
[null,36,"","","","","","","","","","","","","","",null,"","","",""]
[null,37,"","","","","","","","","","","","","","",null,"","","",""]
[null,38,"","","","","","","","","","","","","","",null,"","","",""]
[null,39,"","","","","","","","","","","","","","",null,"","","",""]
[null,40,"","","","","","","","","","","","","","",null,"","","",""]
[null,41,"","","","","","","","","","","","","","",null,"","","",""]
[null,42,"","","","","","","","","","","","","","",null,"","","",""]
[null,43,"","","","","","","","","","","","","","",null,"","","",""]
[null,44,"","","","","","","","","","","","","","",null,"","","",""]
[null,45,"","","","","","","","","","","","","","",null,"","","",""]
[null,46,"","","","","","","","","","","","","","",null,"","","",""]
[null,47,"","","","","","","","","","","","","","",null,"","","",""]
[null,48,"","","","","","","","","","","","","","",null,"","","",""]
[null,49,"","","","","","","","","","","","","","",null,"","","",""]
[null,50,"","","","","","","","","","","","","","",null,"","","",""]
[null,51,"","","","","","","","","","","","","","",null,"","","",""]
[null,52,"","","","","","","","","","","","","","",null,"","","",""]
[null,53,"","","","","","","","","","","","","","",null,"","","",""]
[null,54,"","","","","","","","","","","","","","",null,"","","",""]
[null,55,"","","","","","","","","","","","","","",null,"","","",""]
[null,56,"","","","","","","","","","","","","","",null,"","","",""]
[null,57,"","","","","","","","","","","","","","",null,"","","",""]
[null,58,"","","","","","","","","","","","","","",null,"","","",""]
[null,59,"","","","","","","","","","","","","","",null,"","","",""]
[null,60,"","","","","","","","","","","","","","",null,"","","",""]
[null,61,"","","","","","","","","","","","","","",null,"","","",""]
[null,62,"","","","","","","","","","","","","","",null,"","","",""]
[null,63,"","","","","","","","","","","","","","",null,"","","",""]
[null,64,"","","","","","","","","","","","","","",null,"","","",""]
[null,65,"",{"$f":"IF(B100<=$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,"hidden":true,"merged":[[1,3,3,9]]}
[]
[{"$nulls":3},"Proceso de Cálculo de la Prima de Seguros"]
[]
[]
[]
[]
[null,"1) Datos esenciales del préstamo",{"$nulls":4},"3) Calculo del valor presente del Seguro"]
[]
[null,"Producto",null,{"$f":"'Vista Principal'!C9","v":"Préstamos Personales (LD Y PA) (Clientes)"},null,null,"Suma de Prima Mensual",{"$f":"SUM(L36:L395)","v":{"v":564.9351527208704,"d":"564.94"}}]
[null,"Tipo de Seguro",null,{"$f":"'Vista Principal'!C10","v":"Seguro de Desgravamen"},null,null,"VPN - Valor Presente",{"$f":"NPV(D16,L36:L395)","v":{"v":550.4015189836095,"d":"550.40"}}]
[null,"Tarifa",null,{"$f":"'Vista Principal'!C11","v":"TARIFA TITULAR"}]
[null,"Monto inicial",null,{"$f":"'Vista Principal'!C12","v":{"v":20000,"d":"20,000.00"}},null,null,"4) Calculo del Monto Adicional del Seguro y MAF"]
[null,{"$f":"D10","v":"Seguro de Desgravamen"},{"$f":"+CONCATENATE(D9,D10,D11)","v":"Préstamos Personales (LD Y PA) (Clientes)Seguro de DesgravamenTARIFA TITULAR"},{"$f":"VLOOKUP(C13,CAPUCCI,2,0)","v":{"v":0.001995,"d":"0.1995%"}}]
[null,"Monto adicional Seguro de Desgravamen/ Vida",{"$nulls":4},"Monto inicial",{"$f":"D12","v":{"v":20000,"d":"20,000.00"}}]
[null,"MAF Inicial",null,{"$f":"D12+D14","v":{"v":20000,"d":"20,000"}},null,null,"Monto adicional de Desgravamen / Vida",{"$f":"H10","v":{"v":550.4015189836095,"d":"550.40"}}]
[null,"Costo Capital",null,{"$f":"INDEX(_xlfn._xlws.FILTER(Tabla2[],Tabla2[TARIFA]=D11),0,2)","v":{"v":0.002871,"d":"0.2871%"}},null,null,"Prima de Seguro de Desgravamen / Vida",{"$f":"H15/H14","v":{"v":0.02752007594918048,"d":"2.7520%"}}]
[null,"Moneda",null,{"$f":"'Vista Principal'!C19","v":"Soles"},null,null,"MAF Inicial",{"$f":"H14+H15","v":{"v":20550.40151898361,"d":"20,550.40"}}]
[null,"Plazo Remanente Meses",null,{"$f":"'Vista Principal'!C20","v":24}]
[null,"Fecha de Desembolso",null,{"$f":"'Vista Principal'!C21","v":"2023-09-07"}]
[null,"Fecha de 1er Pago",null,{"$f":"'Vista Principal'!C22","v":"2023-10-07"}]
[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":{"v":0.4,"d":"40.00%"}}]
[null,"TEA TOTAL",null,{"$f":"(1+(((1+D23)^(30/360)-1)+D13))^12-1","v":{"v":0.4329392428219323,"d":"43.29%"}}]
[null,"Monto del Bien",null,0]
[null,"Seguro del Bien",null,{"v":0,"d":"0.0000%"}]
[null,"Portes",null,0]
[null,"Cuota",null,{"$f":"(D15+(D26*D25+D27)*R34)/Q34","v":{"v":1192.4778686786915,"d":"1,192.48"}}]
[]
[null,"TCEA",null,{"v":0.23730675268258045,"d":"23.73%"}]
[{"$nulls":22},{"$f":"D15-W34-D14","v":{"v":-3026.409999999996,"d":"-3,026.41"}}]
[]
[null,"2) Creación de Cronograma de prima mensual"]
[{"$nulls":16},{"$f":"SUM(Q36:Q395)","v":{"v":16.771799733407818,"d":"16.77"}},{"$f":"SUM(R36:R395)","v":{"v":16.771799733407818,"d":"16.77"}},{"$nulls":4},{"$f":"SUM(W36:W395)","v":{"v":23026.409999999996,"d":"23,026.41"}}]
[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":"2023-10-07"},{"$f":"IF(B36<=$D$18,WEEKDAY(D36,2),\"\")","v":6},{"$f":"IF(E36=7,D36+1,D36)","v":"2023-10-07"},{"$f":"F36-D19","v":30},{"$f":"G36","v":30},{"$f":"D15","v":{"v":20000,"d":"20,000.00"}},{"$f":"IF(B36>D$18,\"\",O36-N36-M36-L36-K36)","v":{"v":583.8547541514668,"d":"583.85"}},{"$f":"IF(B36>D$18,\"\",((1+D$23)^(G36/360)-1)*I36)","v":{"v":568.7231145272253,"d":"568.72"}},{"$f":"IF(B36>D$18,\"\",((1+D$13)^(G36/30)-1)*I36)","v":{"v":39.89999999999938,"d":"39.90"}},{"$f":"IF(B36>D$18,\"\",D$25*D$26)","v":{"v":0,"d":"0.00"}},{"$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":{"v":1192.4778686786915,"d":"1,192.48"}},{"$f":"IF(B36>D$18,\"\",I36-J36)","v":{"v":19416.145245848533,"d":"19,416.15"}},{"$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":{"v":0.9704675508332141,"d":"0.97"}},{"$f":"IFERROR(1/(1+D$24)^(H36/360),\"\")","v":{"v":0.9704675508332141,"d":"0.97"}},null,{"$f":"IFERROR(J36+K36+L36+M36+N36,\"\")","v":1192.4778686786915},{"$f":"H36","v":30},{"$f":"IFERROR((1+D$30)^(U36/360),\"\")","v":{"v":1.0179031271720964,"d":"1.02"}},{"$f":"IFERROR(ROUND(T36/V36,2),\"\")","v":{"v":1171.5,"d":"1,171.50"}},{"$f":"L36/(1+$I$9)","v":{"v":39.89999999999938,"d":"39.90"}},{"$f":"L36/(1+$Q$28)","v":{"v":39.89999999999938,"d":"39.90"}}]
[null,2,null,{"$f":"IF(B37>$D$18,\"\",EDATE(D36,1))","v":"2023-11-07"},2,{"$f":"IF(E37=7,D37+1,D37)","v":"2023-11-07"},{"$f":"IF(B37>D$18,\"\",F37-F36)","v":31},{"$f":"IFERROR(G37+H36,\"\")","v":61},{"$f":"IF(B37>D$18,\"\",P36)","v":{"v":19416.145245848533,"d":"19,416.15"}},{"v":581.6576591463954,"d":"581.66"},{"v":570.7924960854264,"d":"570.79"},{"$f":"IF(B37>D$18,\"\",((1+D$13)^(G37/30)-1)*I37)","v":{"v":40.02771344686978,"d":"40.03"}},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":18834.487586702136,"d":"18,834.49"},{"v":0.9408666422315083,"d":"0.94"},{"v":0.9408666422315083,"d":"0.94"},null,1192.4778686786915,61,{"v":1.036739818073355,"d":"1.04"},{"v":1150.22,"d":"1,150.22"},{"$f":"IF(O37=\"\",0,L37/((1+$I$9)^B37))","v":{"v":40.02771344686978,"d":"40.03"}},{"$f":"IF(O37=\"\",0,L37/((1+$Q$28)^B37))","v":{"v":40.02771344686978,"d":"40.03"}}]
[null,3,null,"2023-12-07",4,"2023-12-07",30,91,{"v":18834.487586702136,"d":"18,834.49"},{"v":619.322643901541,"d":"619.32"},{"v":535.5804220416802,"d":"535.58"},{"v":37.57480273547018,"d":"37.57"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":18215.164942800595,"d":"18,215.16"},{"v":0.9130805459470817,"d":"0.91"},{"v":0.9130805459470817,"d":"0.91"},null,1192.4778686786915,91,{"v":1.0553007028806982,"d":"1.06"},{"v":1129.99,"d":"1,129.99"},{"v":37.57480273547018,"d":"37.57"},{"v":37.57480273547018,"d":"37.57"}]
[null,4,null,"2024-01-07",7,"2024-01-08",32,123,{"v":18215.164942800595,"d":"18,215.16"},{"v":600.693740970072,"d":"600.69"},{"v":553.0196806442466,"d":"553.02"},{"v":38.76444706437284,"d":"38.76"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":17614.47120183052,"d":"17,614.47"},{"v":0.8843459196809722,"d":"0.88"},{"v":0.8843459196809722,"d":"0.88"},null,1192.4778686786915,123,{"v":1.0754653912309402,"d":"1.08"},{"v":1108.8,"d":"1,108.80"},{"v":38.76444706437284,"d":"38.76"},{"v":38.76444706437284,"d":"38.76"}]
[null,5,null,"2024-02-07",3,"2024-02-07",30,153,{"v":17614.47120183052,"d":"17,614.47"},{"v":656.4491524982816,"d":"656.45"},{"v":500.8878461327586,"d":"500.89"},{"v":35.14087004765135,"d":"35.14"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":16958.02204933224,"d":"16,958.02"},{"v":0.8582290187621392,"d":"0.86"},{"v":0.8582290187621392,"d":"0.86"},null,1192.4778686786915,153,{"v":1.094719584899336,"d":"1.09"},{"v":1089.3,"d":"1,089.30"},{"v":35.14087004765135,"d":"35.14"},{"v":35.14087004765135,"d":"35.14"}]
[null,6,null,"2024-03-07",4,"2024-03-07",29,182,{"v":16958.02204933224,"d":"16,958.02"},{"v":693.8472765053159,"d":"693.85"},{"v":465.9281332976628,"d":"465.93"},{"v":32.70245887571288,"d":"32.70"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":16264.174772826926,"d":"16,264.17"},{"v":0.8337160833870205,"d":"0.83"},{"v":0.8337160833870205,"d":"0.83"},null,1192.4778686786915,182,{"v":1.113659573500496,"d":"1.11"},{"v":1070.77,"d":"1,070.77"},{"v":32.70245887571288,"d":"32.70"},{"v":32.70245887571288,"d":"32.70"}]
[null,7,null,"2024-04-07",7,"2024-04-08",32,214,{"v":16264.174772826926,"d":"16,264.17"},{"v":664.0785645240466,"d":"664.08"},{"v":493.78684008930315,"d":"493.79"},{"v":34.612464065341705,"d":"34.61"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":15600.096208302879,"d":"15,600.10"},{"v":0.8074790551483761,"d":"0.81"},{"v":0.8074790551483761,"d":"0.81"},null,1192.4778686786915,214,{"v":1.1349393832898764,"d":"1.13"},{"v":1050.7,"d":"1,050.70"},{"v":34.612464065341705,"d":"34.61"},{"v":34.612464065341705,"d":"34.61"}]
[null,8,null,"2024-05-07",2,"2024-05-07",29,243,{"v":15600.096208302879,"d":"15,600.10"},{"v":733.7754806478893,"d":"733.78"},{"v":428.61860212551863,"d":"428.62"},{"v":30.08378590528357,"d":"30.08"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":14866.32072765499,"d":"14,866.32"},{"v":0.7844156519507501,"d":"0.78"},{"v":0.7844156519507501,"d":"0.78"},null,1192.4778686786915,243,{"v":1.1545752236265543,"d":"1.15"},{"v":1032.83,"d":"1,032.83"},{"v":30.08378590528357,"d":"30.08"},{"v":30.08378590528357,"d":"30.08"}]
[null,9,null,"2024-06-07",5,"2024-06-07",31,274,{"v":14866.32072765499,"d":"14,866.32"},{"v":724.792392140442,"d":"724.79"},{"v":437.037538002506,"d":"437.04"},{"v":30.64793853574352,"d":"30.65"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":14141.528335514548,"d":"14,141.53"},{"v":0.7604896422668548,"d":"0.76"},{"v":0.7604896422668548,"d":"0.76"},null,1192.4778686786915,274,{"v":1.1759410845116913,"d":"1.18"},{"v":1014.06,"d":"1,014.06"},{"v":30.64793853574352,"d":"30.65"},{"v":30.64793853574352,"d":"30.65"}]
[null,10,null,"2024-07-07",7,"2024-07-08",31,305,{"v":14141.528335514548,"d":"14,141.53"},{"v":747.5939233006654,"d":"747.59"},{"v":415.73021600757875,"d":"415.73"},{"v":29.153729370447333,"d":"29.15"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":13393.934412213883,"d":"13,393.93"},{"v":0.7372934165157128,"d":"0.74"},{"v":0.7372934165157128,"d":"0.74"},null,1192.4778686786915,305,{"v":1.1977023289127928,"d":"1.20"},995.64,{"v":29.153729370447333,"d":"29.15"},{"v":29.153729370447333,"d":"29.15"}]
[null,11,null,"2024-08-07",3,"2024-08-07",30,335,{"v":13393.934412213883,"d":"13,393.93"},{"v":784.8849647919423,"d":"784.88"},{"v":380.87200473438304,"d":"380.87"},{"v":26.720899152366282,"d":"26.72"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":12609.049447421941,"d":"12,609.05"},{"v":0.7155193361714566,"d":"0.72"},{"v":0.7155193361714566,"d":"0.72"},null,1192.4778686786915,335,{"v":1.2191449460216346,"d":"1.22"},978.13,{"v":26.720899152366282,"d":"26.72"},{"v":26.720899152366282,"d":"26.72"}]
[null,12,null,"2024-09-07",6,"2024-09-07",31,366,{"v":12609.049447421941,"d":"12,609.05"},{"v":795.8047840907952,"d":"795.80"},{"v":370.6786654213661,"d":"370.68"},{"v":25.994419166530093,"d":"25.99"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":11813.244663331147,"d":"11,813.24"},{"v":0.6936947811365355,"d":"0.69"},{"v":0.6936947811365355,"d":"0.69"},null,1192.4778686786915,366,{"v":1.2417056945830824,"d":"1.24"},960.35,{"v":25.994419166530093,"d":"25.99"},{"v":25.994419166530093,"d":"25.99"}]
[null,13,null,"2024-10-07",1,"2024-10-07",30,396,{"$f":"IF(B48>D$18,\"\",P47)","v":{"v":11813.244663331147,"d":"11,813.24"}},{"$f":"IF(B48>D$18,\"\",O48-N48-M48-L48-K48)","v":{"v":832.9871806952557,"d":"832.99"}},{"$f":"IF(B48>D$18,\"\",((1+D$23)^(G48/360)-1)*I48)","v":{"v":335.92326488009064,"d":"335.92"}},{"v":23.56742310334527,"d":"23.57"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"$f":"IF(B48>D$18,\"\",I48-J48)","v":{"v":10980.25748263589,"d":"10,980.26"}},{"v":0.6732082752753561,"d":"0.67"},{"v":0.6732082752753561,"d":"0.67"},null,{"$f":"IFERROR(J48+K48+L48+M48+N48,\"\")","v":1192.4778686786915},396,{"v":1.2639361095435195,"d":"1.26"},943.46,{"v":23.56742310334527,"d":"23.57"},{"$f":"IF(O48=\"\",0,L48/((1+$Q$28)^B48))","v":{"v":23.56742310334527,"d":"23.57"}}]
[null,14,null,"2024-11-07",4,"2024-11-07",31,427,{"v":10980.25748263589,"d":"10,980.26"},{"v":847.0455961375562,"d":"847.05"},{"v":322.79571958365403,"d":"322.80"},{"v":22.636552957481204,"d":"22.64"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":10133.211886498335,"d":"10,133.21"},{"v":0.6526742794614532,"d":"0.65"},{"v":0.6526742794614532,"d":"0.65"},null,1192.4778686786915,427,{"v":1.2873257359027137,"d":"1.29"},926.32,{"v":22.636552957481204,"d":"22.64"},{"v":22.636552957481204,"d":"22.64"}]
[null,15,null,"2024-12-07",6,"2024-12-07",30,457,{"v":10133.211886498335,"d":"10,133.21"},{"v":884.112519752446,"d":"884.11"},{"v":288.1495912126817,"d":"288.15"},{"v":20.215757713563864,"d":"20.22"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":9249.09936674589,"d":"9,249.10"},{"v":0.6333992094807891,"d":"0.63"},{"v":0.6333992094807891,"d":"0.63"},null,1192.4778686786915,457,{"v":1.3103728922644926,"d":"1.31"},910.03,{"v":20.215757713563864,"d":"20.22"},{"v":20.215757713563864,"d":"20.22"}]
[null,16,null,"2025-01-07",2,"2025-01-07",31,488,{"v":9249.09936674589,"d":"9,249.10"},{"v":901.5067855081684,"d":"901.51"},{"v":271.90343125476056,"d":"271.90"},{"v":19.067651915762628,"d":"19.07"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":8347.59258123772,"d":"8,347.59"},{"v":0.6140794577877664,"d":"0.61"},{"v":0.6140794577877664,"d":"0.61"},null,1192.4778686786915,488,{"v":1.3346218492409274,"d":"1.33"},893.49,{"v":19.067651915762628,"d":"19.07"},{"v":19.067651915762628,"d":"19.07"}]
[null,17,null,"2025-02-07",5,"2025-02-07",31,519,{"v":8347.59258123772,"d":"8,347.59"},{"v":929.8676448160489,"d":"929.87"},{"v":245.4010899391907,"d":"245.40"},{"v":17.20913392345181,"d":"17.21"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":7417.724936421672,"d":"7,417.72"},{"v":0.5953489913352259,"d":"0.60"},{"v":0.5953489913352259,"d":"0.60"},null,1192.4778686786915,519,{"v":1.3593195425411337,"d":"1.36"},877.26,{"v":17.20913392345181,"d":"17.21"},{"v":17.20913392345181,"d":"17.21"}]
[null,18,null,"2025-03-07",5,"2025-03-07",28,547,{"v":7417.724936421672,"d":"7,417.72"},{"v":981.9822542482307,"d":"981.98"},{"v":196.68472843295746,"d":"196.68"},{"v":13.810885997503362,"d":"13.81"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":6435.742682173442,"d":"6,435.74"},{"v":0.5789226919483434,"d":"0.58"},{"v":0.5789226919483434,"d":"0.58"},null,1192.4778686786915,547,{"v":1.382019739109327,"d":"1.38"},862.85,{"v":13.810885997503362,"d":"13.81"},{"v":13.810885997503362,"d":"13.81"}]
[null,19,null,"2025-04-07",1,"2025-04-07",31,578,{"v":6435.742682173442,"d":"6,435.74"},{"v":990.013288616815,"d":"990.01"},{"v":189.19685566869873,"d":"189.20"},{"v":13.267724393177796,"d":"13.27"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":5445.729393556627,"d":"5,445.73"},{"v":0.5612645665663011,"d":"0.56"},{"v":0.5612645665663011,"d":"0.56"},null,1192.4778686786915,578,{"v":1.4075945486861121,"d":"1.41"},847.17,{"v":13.267724393177796,"d":"13.27"},{"v":13.267724393177796,"d":"13.27"}]
[null,20,null,"2025-05-07",3,"2025-05-07",30,608,{"v":5445.729393556627,"d":"5,445.73"},{"v":1026.758029459747,"d":"1,026.76"},{"v":154.85560907879915,"d":"154.86"},{"v":10.864230140145303,"d":"10.86"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":4418.97136409688,"d":"4,418.97"},{"v":0.5446890492850637,"d":"0.54"},{"v":0.5446890492850637,"d":"0.54"},null,1192.4778686786915,608,{"v":1.4327948928979892,"d":"1.43"},832.27,{"v":10.864230140145303,"d":"10.86"},{"v":10.864230140145303,"d":"10.86"}]
[null,21,null,"2025-06-07",6,"2025-06-07",31,639,{"v":4418.97136409688,"d":"4,418.97"},{"v":1053.4596969274269,"d":"1,053.46"},{"v":129.90815958086168,"d":"129.91"},{"v":9.110012170403037,"d":"9.11"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":3365.511667169453,"d":"3,365.51"},{"v":0.5280751081487586,"d":"0.53"},{"v":0.5280751081487586,"d":"0.53"},null,1192.4778686786915,639,{"v":1.4593093163258861,"d":"1.46"},817.15,{"v":9.110012170403037,"d":"9.11"},{"v":9.110012170403037,"d":"9.11"}]
[null,22,null,"2025-07-07",1,"2025-07-07",30,669,{"v":3365.511667169453,"d":"3,365.51"},{"v":1090.0614590361722,"d":"1,090.06"},{"v":95.7022138665163,"d":"95.70"},{"v":6.7141957760029545,"d":"6.71"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":2275.450208133281,"d":"2,275.45"},{"v":0.5124797568611102,"d":"0.51"},{"v":0.5124797568611102,"d":"0.51"},null,1192.4778686786915,669,{"v":1.4854355165994935,"d":"1.49"},802.78,{"v":6.7141957760029545,"d":"6.71"},{"v":6.7141957760029545,"d":"6.71"}]
[null,23,null,"2025-08-07",4,"2025-08-07",31,700,{"v":2275.450208133281,"d":"2,275.45"},{"v":1120.8935786296945,"d":"1,120.89"},{"v":66.89329357464526,"d":"66.89"},{"v":4.690996474351865,"d":"4.69"},{"v":0,"d":"0.00"},0,{"v":1192.4778686786915,"d":"1,192.48"},{"v":1154.5566295035867,"d":"1,154.56"},{"v":0.496848253849963,"d":"0.50"},{"v":0.496848253849963,"d":"0.50"},null,1192.4778686786915,700,{"v":1.5129240751204511,"d":"1.51"},788.19,{"v":4.690996474351865,"d":"4.69"},{"v":4.690996474351865,"d":"4.69"}]
[null,24,null,"2025-09-07",7,"2025-09-08",32,732,{"v":1154.5566295035867,"d":"1,154.56"},{"v":1154.5566295035867,"d":"1,154.56"},{"v":35.052800264986374,"d":"35.05"},{"v":2.457059789892371,"d":"2.46"},{"v":0,"d":"0.00"},0,{"v":1192.0664895584655,"d":"1,192.07"},0,{"v":0.48121244937606594,"d":"0.48"},{"v":0.48121244937606594,"d":"0.48"},null,1192.0664895584655,732,{"v":1.5418330319600553,"d":"1.54"},773.15,{"v":2.457059789892371,"d":"2.46"},{"v":2.457059789892371,"d":"2.46"}]
[null,25,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,26,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,27,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,28,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,29,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,30,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,31,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,32,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,33,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,34,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,35,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,36,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,37,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,38,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,39,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,40,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,41,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,42,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,43,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,44,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,45,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,46,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,47,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,48,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,49,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,50,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,51,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,52,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,53,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,54,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,55,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,56,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,57,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,58,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,59,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,60,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,61,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,62,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,63,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,64,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,65,null,"",{"$f":"IF(B100<=$D$18,WEEKDAY(D100,2),\"\")","v":""},"","","","",{"$f":"IF(B100>D$18,\"\",O100-N100-M100-L100-K100)","v":""},{"$f":"IF(B100>D$18,\"\",((1+D$23)^(G100/360)-1)*I100)","v":""},"",{"$f":"IF(B100>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B100>D$18,\"\",D$27)","v":""},{"$f":"IF(B100>D$18,\"\",IF(B100=D$18,I100+K100+L100+M100+N100,IF(AND(D$21=2,MONTH(F100)=7),2*D$28,IF(AND(D$22=2,MONTH(F100)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B100>D$18,\"\",I100-J100)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F100)=7,D$21=2),2/(1+D$24)^(H100/360),IF(AND(MONTH(F100)=12,D$22=2),2/(1+D$24)^(H100/360),1/(1+D$24)^(H100/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H100/360),\"\")","v":""},null,"",{"$f":"H100","v":""},{"$f":"IFERROR((1+D$30)^(U100/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T100/V100,2),\"\")","v":""},0,0]
[null,66,null,{"$f":"IF(B101>$D$18,\"\",EDATE(D100,1))","v":""},"",{"$f":"IF(E101=7,D101+1,D101)","v":""},{"$f":"IF(B101>D$18,\"\",F101-F100)","v":""},{"$f":"IFERROR(G101+H100,\"\")","v":""},{"$f":"IF(B101>D$18,\"\",P100)","v":""},"","",{"$f":"IF(B101>D$18,\"\",((1+D$13)^(G101/30)-1)*I101)","v":""},"","","","","","",null,{"$f":"IFERROR(J101+K101+L101+M101+N101,\"\")","v":""},"","","",{"$f":"IF(O101=\"\",0,L101/((1+$I$9)^B101))","v":0},0]
[null,67,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O102=\"\",0,L102/((1+$Q$28)^B102))","v":0}]
[null,68,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,69,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,70,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,71,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,72,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,73,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,74,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,75,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,76,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,77,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,78,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,79,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,80,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,81,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,82,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,83,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,84,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,85,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,86,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,87,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,88,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,89,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,90,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,91,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,92,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,93,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,94,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,95,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,96,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,97,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,98,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,99,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,100,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,101,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,102,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,103,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,104,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,105,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,106,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,107,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,108,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,109,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,110,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,111,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,112,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,113,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,114,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,115,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,116,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,117,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,118,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,119,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,120,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,121,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,122,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,123,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,124,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,125,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,126,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,127,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,128,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,129,null,"",{"$f":"IF(B164<=$D$18,WEEKDAY(D164,2),\"\")","v":""},"","","","",{"$f":"IF(B164>D$18,\"\",O164-N164-M164-L164-K164)","v":""},{"$f":"IF(B164>D$18,\"\",((1+D$23)^(G164/360)-1)*I164)","v":""},"",{"$f":"IF(B164>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B164>D$18,\"\",D$27)","v":""},{"$f":"IF(B164>D$18,\"\",IF(B164=D$18,I164+K164+L164+M164+N164,IF(AND(D$21=2,MONTH(F164)=7),2*D$28,IF(AND(D$22=2,MONTH(F164)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B164>D$18,\"\",I164-J164)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F164)=7,D$21=2),2/(1+D$24)^(H164/360),IF(AND(MONTH(F164)=12,D$22=2),2/(1+D$24)^(H164/360),1/(1+D$24)^(H164/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H164/360),\"\")","v":""},null,"",{"$f":"H164","v":""},{"$f":"IFERROR((1+D$30)^(U164/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T164/V164,2),\"\")","v":""},0,0]
[null,130,null,{"$f":"IF(B165>$D$18,\"\",EDATE(D164,1))","v":""},"",{"$f":"IF(E165=7,D165+1,D165)","v":""},{"$f":"IF(B165>D$18,\"\",F165-F164)","v":""},{"$f":"IFERROR(G165+H164,\"\")","v":""},{"$f":"IF(B165>D$18,\"\",P164)","v":""},"","",{"$f":"IF(B165>D$18,\"\",((1+D$13)^(G165/30)-1)*I165)","v":""},"","","","","","",null,{"$f":"IFERROR(J165+K165+L165+M165+N165,\"\")","v":""},"","","",{"$f":"IF(O165=\"\",0,L165/((1+$I$9)^B165))","v":0},0]
[null,131,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O166=\"\",0,L166/((1+$Q$28)^B166))","v":0}]
[null,132,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,133,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,134,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,135,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,136,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,137,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,138,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,139,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,140,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,141,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,142,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,143,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,144,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,145,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,146,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,147,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,148,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,149,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,150,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,151,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,152,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,153,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,154,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,155,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,156,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,157,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,158,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,159,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,160,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,161,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,162,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,163,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,164,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,165,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,166,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,167,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,168,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,169,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,170,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,171,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,172,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,173,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,174,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,175,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,176,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,177,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,178,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,179,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,180,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,181,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,182,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,183,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,184,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,185,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,186,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,187,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,188,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,189,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,190,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,191,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,192,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,193,null,"",{"$f":"IF(B228<=$D$18,WEEKDAY(D228,2),\"\")","v":""},"","","","",{"$f":"IF(B228>D$18,\"\",O228-N228-M228-L228-K228)","v":""},{"$f":"IF(B228>D$18,\"\",((1+D$23)^(G228/360)-1)*I228)","v":""},"",{"$f":"IF(B228>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B228>D$18,\"\",D$27)","v":""},{"$f":"IF(B228>D$18,\"\",IF(B228=D$18,I228+K228+L228+M228+N228,IF(AND(D$21=2,MONTH(F228)=7),2*D$28,IF(AND(D$22=2,MONTH(F228)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B228>D$18,\"\",I228-J228)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F228)=7,D$21=2),2/(1+D$24)^(H228/360),IF(AND(MONTH(F228)=12,D$22=2),2/(1+D$24)^(H228/360),1/(1+D$24)^(H228/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H228/360),\"\")","v":""},null,"",{"$f":"H228","v":""},{"$f":"IFERROR((1+D$30)^(U228/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T228/V228,2),\"\")","v":""},0,0]
[null,194,null,{"$f":"IF(B229>$D$18,\"\",EDATE(D228,1))","v":""},"",{"$f":"IF(E229=7,D229+1,D229)","v":""},{"$f":"IF(B229>D$18,\"\",F229-F228)","v":""},{"$f":"IFERROR(G229+H228,\"\")","v":""},{"$f":"IF(B229>D$18,\"\",P228)","v":""},"","",{"$f":"IF(B229>D$18,\"\",((1+D$13)^(G229/30)-1)*I229)","v":""},"","","","","","",null,{"$f":"IFERROR(J229+K229+L229+M229+N229,\"\")","v":""},"","","",{"$f":"IF(O229=\"\",0,L229/((1+$I$9)^B229))","v":0},0]
[null,195,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O230=\"\",0,L230/((1+$Q$28)^B230))","v":0}]
[null,196,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,197,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,198,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,199,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,200,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,201,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,202,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,203,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,204,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,205,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,206,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,207,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,208,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,209,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,210,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,211,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,212,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,213,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,214,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,215,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,216,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,217,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,218,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,219,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,220,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,221,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,222,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,223,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,224,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,225,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,226,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,227,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,228,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,229,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,230,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,231,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,232,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,233,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,234,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,235,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,236,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,237,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,238,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,239,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,240,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,241,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,242,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,243,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,244,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,245,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,246,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,247,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,248,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,249,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,250,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,251,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,252,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,253,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,254,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,255,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,256,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,257,null,"",{"$f":"IF(B292<=$D$18,WEEKDAY(D292,2),\"\")","v":""},"","","","",{"$f":"IF(B292>D$18,\"\",O292-N292-M292-L292-K292)","v":""},{"$f":"IF(B292>D$18,\"\",((1+D$23)^(G292/360)-1)*I292)","v":""},"",{"$f":"IF(B292>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B292>D$18,\"\",D$27)","v":""},{"$f":"IF(B292>D$18,\"\",IF(B292=D$18,I292+K292+L292+M292+N292,IF(AND(D$21=2,MONTH(F292)=7),2*D$28,IF(AND(D$22=2,MONTH(F292)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B292>D$18,\"\",I292-J292)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F292)=7,D$21=2),2/(1+D$24)^(H292/360),IF(AND(MONTH(F292)=12,D$22=2),2/(1+D$24)^(H292/360),1/(1+D$24)^(H292/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H292/360),\"\")","v":""},null,"",{"$f":"H292","v":""},{"$f":"IFERROR((1+D$30)^(U292/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T292/V292,2),\"\")","v":""},0,0]
[null,258,null,{"$f":"IF(B293>$D$18,\"\",EDATE(D292,1))","v":""},"",{"$f":"IF(E293=7,D293+1,D293)","v":""},{"$f":"IF(B293>D$18,\"\",F293-F292)","v":""},{"$f":"IFERROR(G293+H292,\"\")","v":""},{"$f":"IF(B293>D$18,\"\",P292)","v":""},"","",{"$f":"IF(B293>D$18,\"\",((1+D$13)^(G293/30)-1)*I293)","v":""},"","","","","","",null,{"$f":"IFERROR(J293+K293+L293+M293+N293,\"\")","v":""},"","","",{"$f":"IF(O293=\"\",0,L293/((1+$I$9)^B293))","v":0},0]
[null,259,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O294=\"\",0,L294/((1+$Q$28)^B294))","v":0}]
[null,260,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,261,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,262,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,263,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,264,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,265,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,266,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,267,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,268,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,269,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,270,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,271,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,272,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,273,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,274,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,275,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,276,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,277,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,278,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,279,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,280,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,281,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,282,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,283,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,284,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,285,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,286,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,287,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,288,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,289,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,290,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,291,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,292,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,293,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,294,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,295,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,296,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,297,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,298,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,299,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,300,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,301,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,302,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,303,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,304,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,305,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,306,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,307,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,308,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,309,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,310,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,311,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,312,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,313,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,314,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,315,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,316,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,317,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,318,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,319,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,320,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,321,null,"",{"$f":"IF(B356<=$D$18,WEEKDAY(D356,2),\"\")","v":""},"","","","",{"$f":"IF(B356>D$18,\"\",O356-N356-M356-L356-K356)","v":""},{"$f":"IF(B356>D$18,\"\",((1+D$23)^(G356/360)-1)*I356)","v":""},"",{"$f":"IF(B356>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B356>D$18,\"\",D$27)","v":""},{"$f":"IF(B356>D$18,\"\",IF(B356=D$18,I356+K356+L356+M356+N356,IF(AND(D$21=2,MONTH(F356)=7),2*D$28,IF(AND(D$22=2,MONTH(F356)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B356>D$18,\"\",I356-J356)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F356)=7,D$21=2),2/(1+D$24)^(H356/360),IF(AND(MONTH(F356)=12,D$22=2),2/(1+D$24)^(H356/360),1/(1+D$24)^(H356/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H356/360),\"\")","v":""},null,"",{"$f":"H356","v":""},{"$f":"IFERROR((1+D$30)^(U356/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T356/V356,2),\"\")","v":""},0,0]
[null,322,null,{"$f":"IF(B357>$D$18,\"\",EDATE(D356,1))","v":""},"",{"$f":"IF(E357=7,D357+1,D357)","v":""},{"$f":"IF(B357>D$18,\"\",F357-F356)","v":""},{"$f":"IFERROR(G357+H356,\"\")","v":""},{"$f":"IF(B357>D$18,\"\",P356)","v":""},"","",{"$f":"IF(B357>D$18,\"\",((1+D$13)^(G357/30)-1)*I357)","v":""},"","","","","","",null,{"$f":"IFERROR(J357+K357+L357+M357+N357,\"\")","v":""},"","","",{"$f":"IF(O357=\"\",0,L357/((1+$I$9)^B357))","v":0},0]
[null,323,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O358=\"\",0,L358/((1+$Q$28)^B358))","v":0}]
[null,324,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,325,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,326,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,327,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,328,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,329,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,330,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,331,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,332,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,333,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,334,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,335,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,336,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,337,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,338,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,339,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,340,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,341,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,342,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,343,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,344,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,345,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,346,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,347,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,348,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,349,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,350,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,351,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,352,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,353,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,354,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,355,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,356,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,357,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,358,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,359,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,360,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]

{"sheet":"TarifarioBD","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"hidden":true}
["TARIFA","PRODUCTO","TIPO_SEGURO","Valor","<","Columna2",null,"TARIFA","PRODUCTO","TIPO_SEGURO"]
["TARIFA TITULAR","Préstamos Personales (DXP)","Seguro de Vida",{"v":0.042,"d":"4.2000%"},"Préstamos Personales (DXP)Seguro de VidaTARIFA TITULAR",{"v":0.042,"d":"4.2000%"},null,"TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Vida"]
["TARIFA TITULAR","Préstamos Personales (DXP)","Seguro de Desgravamen",{"v":0.001832,"d":"0.1832%"},"Préstamos Personales (DXP)Seguro de DesgravamenTARIFA TITULAR",{"v":0.001832,"d":"0.1832%"},null,"TARIFA TITULAR + CONYUGE",null,"Seguro de Desgravamen"]
["TARIFA TITULAR","Préstamos Personales (DXP)","Seguro de Desgravamen con Devolución",{"v":0.002342,"d":"0.2342%"},"Préstamos Personales (DXP)Seguro de Desgravamen con DevoluciónTARIFA TITULAR",{"v":0.002342,"d":"0.2342%"},{"$nulls":3},"Seguro de Desgravamen con Devolución"]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Seguro de Vida",{"v":0.084,"d":"8.4000%"},"Préstamos Personales (DXP)Seguro de VidaTARIFA TITULAR + CONYUGE",{"v":0.084,"d":"8.4000%"}]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Seguro de Desgravamen",{"v":0.003664,"d":"0.3664%"},"Préstamos Personales (DXP)Seguro de DesgravamenTARIFA TITULAR + CONYUGE",{"v":0.003664,"d":"0.3664%"}]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Seguro de Desgravamen con Devolución",{"v":0.004684,"d":"0.4684%"},"Préstamos Personales (DXP)Seguro de Desgravamen con DevoluciónTARIFA TITULAR + CONYUGE",{"v":0.004684,"d":"0.4684%"}]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Vida",{"v":0.037,"d":"3.7000%"},"Préstamos Personales (LD Y PA) (Clientes)Seguro de VidaTARIFA TITULAR",{"v":0.037,"d":"3.7000%"}]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen",{"v":0.001995,"d":"0.1995%"},"Préstamos Personales (LD Y PA) (Clientes)Seguro de DesgravamenTARIFA TITULAR",{"v":0.001995,"d":"0.1995%"}]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen con Devolución",{"v":2.594E-3,"d":"0.2594%"},"Préstamos Personales (LD Y PA) (Clientes)Seguro de Desgravamen con DevoluciónTARIFA TITULAR",{"v":2.594E-3,"d":"0.2594%"}]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Vida",{"v":0.074,"d":"7.4000%"},"Préstamos Personales (LD Y PA) (Clientes)Seguro de VidaTARIFA TITULAR + CONYUGE",{"v":0.074,"d":"7.4000%"}]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen",{"v":0.00399,"d":"0.3990%"},"Préstamos Personales (LD Y PA) (Clientes)Seguro de DesgravamenTARIFA TITULAR + CONYUGE",{"v":0.00399,"d":"0.3990%"}]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen con Devolución",{"v":0.005188,"d":"0.5188%"},"Préstamos Personales (LD Y PA) (Clientes)Seguro de Desgravamen con DevoluciónTARIFA TITULAR + CONYUGE",{"v":0.005188,"d":"0.5188%"}]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Vida",{"v":0.015866,"d":"1.5866%"},"Préstamos Personales (LD Y PA) (Empleados)Seguro de VidaTARIFA TITULAR",{"v":0.015866,"d":"1.5866%"}]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen",{"v":0.000855,"d":"0.0855%"},"Préstamos Personales (LD Y PA) (Empleados)Seguro de DesgravamenTARIFA TITULAR",{"v":0.000855,"d":"0.0855%"}]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen con Devolución",{"v":0.001112,"d":"0.1112%"},"Préstamos Personales (LD Y PA) (Empleados)Seguro de Desgravamen con DevoluciónTARIFA TITULAR",{"v":0.001112,"d":"0.1112%"}]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Vida",{"v":0.031732,"d":"3.1732%"},"Préstamos Personales (LD Y PA) (Empleados)Seguro de VidaTARIFA TITULAR + CONYUGE",{"v":0.031732,"d":"3.1732%"}]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen",{"v":0.00171,"d":"0.1710%"},"Préstamos Personales (LD Y PA) (Empleados)Seguro de DesgravamenTARIFA TITULAR + CONYUGE",{"v":0.00171,"d":"0.1710%"}]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen con Devolución",{"v":0.002224,"d":"0.2224%"},"Préstamos Personales (LD Y PA) (Empleados)Seguro de Desgravamen con DevoluciónTARIFA TITULAR + CONYUGE",{"v":0.002224,"d":"0.2224%"}]

{"sheet":"CostoCapBD","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"hidden":true}
["TARIFA","CostoCapital"]
["TARIFA TITULAR",{"v":0.002871,"d":"0.2871%"}]
["TARIFA TITULAR + CONYUGE",{"v":0.002871,"d":"0.2871%"}]