{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Captura de Datos","Tabla de Datos","Tabla de Amortización"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Captura de Datos","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,4,9,5],[10,4,10,5],[11,4,11,5],[2,4,2,6],[6,4,6,5],[7,4,7,5],[8,4,8,5]]}
[]
[]
[null,null,null,null,"Formulario de Captura de Datos "]
[]
[]
[]
[null,null,null,null,"ID"]
[null,null,null,null,"NOMBRE"]
[null,null,null,null,"SALARIO MENSUAL"]
[null,null,null,null,"VALOR DEL PRESTAMO"]
[null,null,null,null,"TASA DE INTERES EFECTIVA "]
[null,null,null,null,"CANTIDAD DE CUOTAS"]

{"sheet":"Tabla de Datos","index":1,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Datos Empleados"]
[null,"ID","NOMBRE","SALARIO MENSUAL","VALOR DEL PRESTAMO","TASA DE INTERES MENSUAL","CANTIDAD DE CUOTAS",null,"REF1",1]
[null,1,"David Torres",200000,1000000,0.1,40]
[null,4,"Cristian",2340987,98765432,0.38,46]
[null,3,"Laura",345989,23457800,0.28000000000000003,4]
[null,2,"Sofi",2500000,300000000,0.23,12]

{"sheet":"Tabla de Amortización","index":2,"n_rows":134,"n_cols":7,"rows_kept":134,"cut":false,"hidden":false,"merged":[[1,1,1,2],[9,1,10,6],[5,4,6,5],[3,1,3,2]]}
[]
[null,"ELEGIR EMPLEADO"]
[]
[null,"DATOS INICIALES"]
[null,"VALOR DEL CRÉDITO",{"$f":"INDEX('Tabla de Datos'!B4:G25,MATCH('Tabla de Datos'!J3,'Tabla de Datos'!$B$4:$B$23,0),4)","v":1000000}]
[null,"CANTIDAD DE CUOTAS",{"$f":"INDEX('Tabla de Datos'!B4:G25,MATCH('Tabla de Datos'!J3,'Tabla de Datos'!$B$4:$B$23,0),6)","v":40},null,"Mensual"]
[null,"TASA DE INTERES",{"$f":"INDEX('Tabla de Datos'!B4:G25,MATCH('Tabla de Datos'!J3,'Tabla de Datos'!$B$4:$B$23,0),5)","v":0.1}]
[null,"VALOR DE LA CUOTA",{"$f":"PMT(IF(E6=\"Efectiva anual\",NOMINAL(C7,12)/12,C7),C6,-C5)","v":102259.4144143695}]
[]
[null,"TABLA DE AMORTIZACION MENSUAL"]
[]
[]
[null,"PERIODO","CUOTA","CUOTA EXTRA","INTERESES","AMORTIZACION","SALDO"]
[null,0,null,null,null,null,{"$f":"+C5","v":1000000}]
[null,{"$f":"IF(B14>=$C$6,\"\",B14+1)","v":1},{"$f":"IF(B15<=$C$6,$C$8,\"\")","v":102259.4144143695},null,{"$f":"IF(C15=\"\",\"\",G14*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":100000},{"$f":"IF(C15=\"\",\"\",(C15+D15-E15))","v":2259.4144143695012},{"$f":"IF(C15=\"\",\"\",(G14-F15))","v":997740.5855856305}]
[null,{"$f":"IF(B15>=$C$6,\"\",B15+1)","v":2},{"$f":"IF(B16<=$C$6,$C$8,\"\")","v":102259.4144143695},null,{"$f":"IF(C16=\"\",\"\",G15*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":99774.058558563062},{"$f":"IF(C16=\"\",\"\",(C16+D16-E16))","v":2485.3558558064396},{"$f":"IF(C16=\"\",\"\",(G15-F16))","v":995255.229729824}]
[null,3,102259.4144143695,null,{"$f":"IF(C17=\"\",\"\",G16*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":99525.522972982406},2733.8914413870953,992521.33828843688]
[null,4,102259.4144143695,null,{"$f":"IF(C18=\"\",\"\",G17*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":99252.133828843696},3007.2805855258048,989514.05770291109]
[null,5,102259.4144143695,null,{"$f":"IF(C19=\"\",\"\",G18*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":98951.405770291109},3308.0086440783925,986206.04905883269]
[null,6,102259.4144143695,null,{"$f":"IF(C20=\"\",\"\",G19*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":98620.604905883272},3638.8095084862289,982567.23955034651]
[null,7,102259.4144143695,null,{"$f":"IF(C21=\"\",\"\",G20*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":98256.723955034657},4002.6904593348445,978564.54909101164]
[null,8,102259.4144143695,null,{"$f":"IF(C22=\"\",\"\",G21*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":97856.454909101172},4402.9595052683289,974161.58958574326]
[null,9,102259.4144143695,null,{"$f":"IF(C23=\"\",\"\",G22*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":97416.158958574335},4843.2554557951662,969318.33412994805]
[null,10,102259.4144143695,null,{"$f":"IF(C24=\"\",\"\",G23*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":96931.833412994805},5327.5810013746959,963990.7531285733]
[null,{"$f":"IF(B24>=$C$6,\"\",B24+1)","v":11},102259.4144143695,null,{"$f":"IF(C25=\"\",\"\",G24*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":96399.075312857341},5860.3391015121597,958130.41402706108]
[null,12,102259.4144143695,null,{"$f":"IF(C26=\"\",\"\",G25*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":95813.04140270612},6446.3730116633815,951684.04101539776]
[null,13,102259.4144143695,null,{"$f":"IF(C27=\"\",\"\",G26*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":95168.404101539782},7091.0103128297196,944593.03070256801]
[null,14,102259.4144143695,null,{"$f":"IF(C28=\"\",\"\",G27*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":94459.303070256807},7800.1113441126945,936792.91935845534]
[null,15,102259.4144143695,null,{"$f":"IF(C29=\"\",\"\",G28*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":93679.29193584554},8580.122478523961,928212.79687993135]
[null,16,102259.4144143695,null,{"$f":"IF(C30=\"\",\"\",G29*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":92821.279687993141},9438.13472637636,918774.66215355496]
[null,17,102259.4144143695,null,{"$f":"IF(C31=\"\",\"\",G30*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":91877.466215355496},10381.948199014005,908392.7139545409]
[null,18,102259.4144143695,null,{"$f":"IF(C32=\"\",\"\",G31*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":90839.271395454096},11420.143018915405,896972.57093562547]
[null,19,102259.4144143695,null,{"$f":"IF(C33=\"\",\"\",G32*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":89697.257093562555},12562.157320806946,884410.41361481848]
[null,20,102259.4144143695,null,{"$f":"IF(C34=\"\",\"\",G33*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":88441.041361481854},13818.373052887648,870592.04056193086]
[null,21,102259.4144143695,null,{"$f":"IF(C35=\"\",\"\",G34*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":87059.204056193092},15200.210358176409,855391.83020375448]
[null,22,102259.4144143695,null,{"$f":"IF(C36=\"\",\"\",G35*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":85539.183020375451},16720.23139399405,838671.59880976041]
[null,23,102259.4144143695,null,{"$f":"IF(C37=\"\",\"\",G36*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":83867.159880976047},18392.254533393454,820279.34427636699]
[null,24,102259.4144143695,null,{"$f":"IF(C38=\"\",\"\",G37*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":82027.934427636705},20231.479986732797,800047.86428963416]
[null,25,102259.4144143695,null,{"$f":"IF(C39=\"\",\"\",G38*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":80004.786428963416},22254.627985406085,777793.23630422808]
[null,26,102259.4144143695,null,{"$f":"IF(C40=\"\",\"\",G39*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":77779.323630422805},24480.090783946696,753313.1455202814]
[null,27,102259.4144143695,null,{"$f":"IF(C41=\"\",\"\",G40*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":75331.31455202814},26928.099862341362,726385.04565793998]
[null,28,102259.4144143695,null,{"$f":"IF(C42=\"\",\"\",G41*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":72638.504565794006},29620.909848575495,696764.1358093645]
[null,29,102259.4144143695,null,{"$f":"IF(C43=\"\",\"\",G42*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":69676.413580936452},32583.000833433049,664181.13497593149]
[null,30,102259.4144143695,null,{"$f":"IF(C44=\"\",\"\",G43*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":66418.113497593149},35841.300916776352,628339.83405915508]
[null,31,102259.4144143695,null,{"$f":"IF(C45=\"\",\"\",G44*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":62833.983405915511},39425.43100845399,588914.40305070113]
[null,32,102259.4144143695,null,{"$f":"IF(C46=\"\",\"\",G45*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":58891.440305070115},43367.974109299386,545546.42894140177]
[null,33,102259.4144143695,null,{"$f":"IF(C47=\"\",\"\",G46*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":54554.642894140183},47704.771520229318,497841.65742117248]
[null,34,102259.4144143695,null,{"$f":"IF(C48=\"\",\"\",G47*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":49784.165742117249},52475.248672252252,445366.40874892025]
[null,35,102259.4144143695,null,{"$f":"IF(C49=\"\",\"\",G48*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":44536.640874892029},57722.773539477472,387643.63520944276]
[null,36,102259.4144143695,null,{"$f":"IF(C50=\"\",\"\",G49*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":38764.36352094428},63495.050893425221,324148.58431601751]
[null,37,102259.4144143695,null,{"$f":"IF(C51=\"\",\"\",G50*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":32414.858431601751},69844.55598276775,254304.02833324976]
[null,38,102259.4144143695,null,{"$f":"IF(C52=\"\",\"\",G51*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":25430.402833324977},76829.011581044528,177475.01675220524]
[null,39,102259.4144143695,null,{"$f":"IF(C53=\"\",\"\",G52*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":17747.501675220523},84511.912739148975,92963.104013056261]
[null,40,102259.4144143695,null,{"$f":"IF(C54=\"\",\"\",G53*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":9296.3104013056272},92963.104013063872,-7.6106516644358635E-9]
[null,"","",null,{"$f":"IF(C55=\"\",\"\",G54*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C56=\"\",\"\",G55*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C57=\"\",\"\",G56*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C58=\"\",\"\",G57*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C59=\"\",\"\",G58*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C60=\"\",\"\",G59*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C61=\"\",\"\",G60*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C62=\"\",\"\",G61*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C63=\"\",\"\",G62*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C64=\"\",\"\",G63*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C65=\"\",\"\",G64*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C66=\"\",\"\",G65*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C67=\"\",\"\",G66*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C68=\"\",\"\",G67*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C69=\"\",\"\",G68*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C70=\"\",\"\",G69*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C71=\"\",\"\",G70*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C72=\"\",\"\",G71*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C73=\"\",\"\",G72*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C74=\"\",\"\",G73*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C75=\"\",\"\",G74*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C76=\"\",\"\",G75*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C77=\"\",\"\",G76*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C78=\"\",\"\",G77*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C79=\"\",\"\",G78*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,{"$f":"IF(B79>=$C$6,\"\",B79+1)","v":""},{"$f":"IF(B80<=$C$6,$C$8,\"\")","v":""},null,{"$f":"IF(C80=\"\",\"\",G79*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},{"$f":"IF(C80=\"\",\"\",(C80+D80-E80))","v":""},{"$f":"IF(C80=\"\",\"\",(G79-F80))","v":""}]
[null,"","",null,{"$f":"IF(C81=\"\",\"\",G80*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C82=\"\",\"\",G81*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C83=\"\",\"\",G82*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C84=\"\",\"\",G83*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C85=\"\",\"\",G84*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C86=\"\",\"\",G85*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C87=\"\",\"\",G86*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C88=\"\",\"\",G87*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C89=\"\",\"\",G88*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C90=\"\",\"\",G89*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C91=\"\",\"\",G90*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C92=\"\",\"\",G91*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C93=\"\",\"\",G92*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C94=\"\",\"\",G93*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C95=\"\",\"\",G94*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C96=\"\",\"\",G95*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C97=\"\",\"\",G96*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C98=\"\",\"\",G97*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C99=\"\",\"\",G98*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C100=\"\",\"\",G99*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C101=\"\",\"\",G100*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C102=\"\",\"\",G101*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C103=\"\",\"\",G102*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C104=\"\",\"\",G103*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C105=\"\",\"\",G104*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C106=\"\",\"\",G105*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C107=\"\",\"\",G106*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C108=\"\",\"\",G107*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C109=\"\",\"\",G108*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C110=\"\",\"\",G109*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C111=\"\",\"\",G110*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C112=\"\",\"\",G111*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C113=\"\",\"\",G112*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C114=\"\",\"\",G113*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C115=\"\",\"\",G114*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C116=\"\",\"\",G115*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C117=\"\",\"\",G116*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C118=\"\",\"\",G117*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C119=\"\",\"\",G118*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C120=\"\",\"\",G119*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C121=\"\",\"\",G120*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C122=\"\",\"\",G121*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C123=\"\",\"\",G122*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C124=\"\",\"\",G123*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C125=\"\",\"\",G124*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C126=\"\",\"\",G125*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C127=\"\",\"\",G126*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C128=\"\",\"\",G127*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C129=\"\",\"\",G128*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C130=\"\",\"\",G129*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C131=\"\",\"\",G130*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C132=\"\",\"\",G131*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C133=\"\",\"\",G132*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]
[null,"","",null,{"$f":"IF(C134=\"\",\"\",G133*IF($E$6=\"Efectiva Anual\",(NOMINAL($C$7,12)/12),$C$7))","v":""},"",""]