{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cal FD yield from FD interest","Cal FD rate from FD yield"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":16,"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":"Cal FD yield from FD interest","index":0,"n_rows":138,"n_cols":22,"rows_kept":138,"cut":false,"hidden":false,"merged":[[15,0,15,1],[16,0,16,1],[10,0,10,1],[14,0,14,1],[0,0,0,1],[1,0,1,1],[3,0,3,1]]}
["Fixed Deposit Annualized Yield Calculator",null,null,"Month","Annualized",null,null,null,null,null,{"$f":"IF(term=\"Quarterly\",4,IF(term=\"Half-yearly\",2,IF(term=\"Yearly\",1,IF(term=\"Monthly\",12))))","v":1},1]
["Investment tenure in months and years",null,null,null,"Yield",null,null,null,null,null,{"$f":"IF(term=\"Quarterly\",3,IF(term=\"Half-yearly\",6,IF(term=\"Yearly\",12,IF(term=\"Monthly\",1))))","v":12},2,null,null,null,null,null,null,null,null,null,{"$f":"100*(1+8.5%)^10","v":226.09834419174334}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L2+1","v":3}]
["Fill only the cells with green background",null,null,{"$f":"IF(D3<rdura,D3+1,\"\")","v":1},{"$f":"IF(D4=\"\",\"\", ((1+raterd/factor1)^(factor1*D4/12)-1)/(D4/12))","v":7.9535601652416688E-2},{"$f":"IF(D4=\"\",\"\",  raterd)","v":8.2500000000000004E-2},null,null,null,null,null,{"$f":"L3+1","v":4}]
["Interest Rate (constant!)",8.2500000000000004E-2,null,2,7.9799181316174472E-2,8.2500000000000004E-2,null,null,null,null,null,5]
["Investment",1212,null,3,8.0063925644775047E-2,8.2500000000000004E-2,null,null,null,null,null,6,"Quarterly",null,null,null,null,null,null,null,null,{"$f":"(V2-100)/100","v":1.2609834419174333}]
["Duration of invest. (months)*",120,null,4,8.0329840427735943E-2,8.2500000000000004E-2,null,null,null,null,null,7,"Half-yearly"]
["* 2 - 120 months (max. allowed duration)",null,null,5,8.0596931485275997E-2,8.2500000000000004E-2,null,null,null,null,null,8,"Yearly"]
["Type of Compounding","Yearly",null,6,8.0865204668481017E-2,8.2500000000000004E-2,null,null,null,null,null,9,"Monthly"]
["Pre-tax Corpus",{"$f":"fdamt*(1+raterd/factor1)^(factor1*rdura/12)","v":2677.8217832178734},null,7,8.1134665859475846E-2,8.2500000000000004E-2,null,null,null,null,null,10]
[null,null,null,8,8.1405320971593365E-2,8.2500000000000004E-2,null,null,null,null,null,11]
["Annualized Yield",{"$f":"((1+raterd/factor1)^(factor1*rdura/12)-1)/(rdura/12)","v":0.12094239135461002},null,9,8.167717594955004E-2,8.2500000000000004E-2,null,null,null,null,null,12]
[null,null,null,10,8.1950236769618004E-2,8.2500000000000004E-2,null,null,null,null,null,13,null,null,null,null,null,null,null,null,null,{"$f":"((1+8.5%)^(1/12)-1)/(1/12)","v":8.1857920391547268E-2}]
["Feedback welcome:  pattu@iitm.ac.in",null,null,11,8.2224509439798948E-2,8.2500000000000004E-2,null,null,null,null,null,14]
[null,null,null,12,8.2500000000000018E-2,8.2500000000000004E-2,null,null,null,null,null,15,null,null,null,null,null,null,null,null,null,{"$f":"((1+raterd)^(3)-1)/3","v":8.949342187500002E-2}]
["Enter only months. ",null,null,13,8.2776714522210873E-2,8.2500000000000004E-2,null,null,null,null,null,16]
["Use this to convert!",null,null,14,8.3054659110679857E-2,8.2500000000000004E-2,null,null,null,null,null,17]
["Years",6,null,15,8.333383990209367E-2,8.2500000000000004E-2,"The maximumvalue of this graph corresponds to the advertised annualized yield"]
["Months",{"$f":"12*B18","v":72},null,16,8.3614263065755923E-2,8.2500000000000004E-2,"The horizontal red line is the constant rate of interest",null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!+#REF!+#REF!)","v":{"$error":"#REF!"}},null,1,null,null,"of interest"]
[null,null,null,17,8.3895934803767933E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J19+#REF!+#REF!)","v":{"$error":"#REF!"}},null,2]
[null,null,null,18,8.4178861351210291E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J20+#REF!+#REF!)","v":{"$error":"#REF!"}},null,3]
[{"$f":"factor1","v":1},null,null,19,8.4463048976325103E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J21+#REF!+#REF!)","v":{"$error":"#REF!"}},null,4]
[null,null,null,20,8.4748503980699885E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J22+#REF!+#REF!)","v":{"$error":"#REF!"}},null,5]
[null,null,null,21,8.5035232699451999E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J23+#REF!+#REF!)","v":{"$error":"#REF!"}},null,6]
[null,null,null,22,8.5323241501414321E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J24+#REF!+#REF!)","v":{"$error":"#REF!"}},null,7]
[null,null,null,23,8.5612536789321986E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J25+#REF!+#REF!)","v":{"$error":"#REF!"}},null,8]
[null,null,null,24,8.5903124999999969E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J26+#REF!+#REF!)","v":{"$error":"#REF!"}},null,9]
[null,null,null,25,8.6195012604552479E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J27+#REF!+#REF!)","v":{"$error":"#REF!"}},null,10]
[null,null,null,26,8.6488206108552096E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J28+#REF!+#REF!)","v":{"$error":"#REF!"}},null,11]
[null,null,null,27,8.678271205223137E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J29+#REF!+#REF!)","v":{"$error":"#REF!"}},null,12]
[null,null,null,28,8.7078537010674764E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J30+#REF!+#REF!)","v":{"$error":"#REF!"}},null,13]
[null,null,null,29,8.7375687594011778E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J31+#REF!+#REF!)","v":{"$error":"#REF!"}},null,14]
[null,null,null,30,8.7674170447611124E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J32+#REF!+#REF!)","v":{"$error":"#REF!"}},null,15]
[null,null,null,31,8.7973992252276326E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J33+#REF!+#REF!)","v":{"$error":"#REF!"}},null,16]
[null,null,null,32,8.8275159724442276E-2,8.2500000000000004E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J34+#REF!+#REF!)","v":{"$error":"#REF!"}},null,17]
[null,null,null,{"$f":"IF(D35<rdura,D35+1,\"\")","v":33},{"$f":"IF(D36=\"\",\"\", ((1+raterd/factor1)^(factor1*D36/12)-1)/(D36/12))","v":8.8577679616372543E-2},{"$f":"IF(D36=\"\",\"\",  raterd)","v":8.2500000000000004E-2},null,null,null,null,null,18]
[null,null,null,34,8.8881558716358319E-2,8.2500000000000004E-2,null,null,null,null,null,19]
[null,null,null,35,8.9186803848918431E-2,8.2500000000000004E-2,null,null,null,null,null,20]
[null,null,null,36,8.949342187500002E-2,8.2500000000000004E-2,null,null,null,null,null,21]
[null,null,null,37,8.9801419692181125E-2,8.2500000000000004E-2,null,null,null,null,null,22]
[null,null,null,38,9.0110804234873637E-2,8.2500000000000004E-2,null,null,null,null,null,23]
[null,null,null,39,9.0421582474528042E-2,8.2500000000000004E-2,null,null,null,null,null,24]
[null,null,null,40,9.0733761419838868E-2,8.2500000000000004E-2,null,null,null,null,null,25]
[null,null,null,41,9.104734811695156E-2,8.2500000000000004E-2,null,null,null,null,null,26]
[null,null,null,42,9.1362349649670715E-2,8.2500000000000004E-2,null,null,null,null,null,27]
[null,null,null,43,9.1678773139668948E-2,8.2500000000000004E-2,null,null,null,null,null,28]
[null,null,null,44,9.1996625746697341E-2,8.2500000000000004E-2,null,null,null,null,null,29]
[null,null,null,45,9.2315914668797086E-2,8.2500000000000004E-2,null,null,null,null,null,30]
[null,null,null,46,9.2636647142512379E-2,8.2500000000000004E-2,null,null,null,null,null,31]
[null,null,null,47,9.2958830443104198E-2,8.2500000000000004E-2,null,null,null,null,null,32]
[null,null,null,48,9.3282471884765572E-2,8.2500000000000004E-2,null,null,null,null,null,33]
[null,null,null,49,9.3607578820838477E-2,8.2500000000000004E-2,null,null,null,null,null,34]
[null,null,null,50,9.3934158644030583E-2,8.2500000000000004E-2,null,null,null,null,null,35]
[null,null,null,51,9.4262218786635071E-2,8.2500000000000004E-2,null,null,null,null,null,36]
[null,null,null,52,9.4591766720750439E-2,8.2500000000000004E-2,null,null,null,null,null,37]
[null,null,null,53,9.4922809958501955E-2,8.2500000000000004E-2,null,null,null,null,null,38]
[null,null,null,54,9.5255356052264428E-2,8.2500000000000004E-2,null,null,null,null,null,39]
[null,null,null,55,9.5589412594886167E-2,8.2500000000000004E-2,null,null,null,null,null,40]
[null,null,null,56,9.5924987219914173E-2,8.2500000000000004E-2,null,null,null,null,null,41]
[null,null,null,57,9.6262087601820687E-2,8.2500000000000004E-2,null,null,null,null,null,42]
[null,null,null,58,9.6600721456231109E-2,8.2500000000000004E-2,null,null,null,null,null,43]
[null,null,null,59,9.6940896540153088E-2,8.2500000000000004E-2,null,null,null,null,null,44]
[null,null,null,60,9.7282620652207011E-2,8.2500000000000004E-2,null,null,null,null,null,45]
[null,null,null,61,9.7625901632857781E-2,8.2500000000000004E-2,null,null,null,null,null,46]
[null,null,null,62,9.7970747364647642E-2,8.2500000000000004E-2,null,null,null,null,null,47]
[null,null,null,63,9.831716577243102E-2,8.2500000000000004E-2,null,null,null,null,null,48]
[null,null,null,64,9.8665164823610027E-2,8.2500000000000004E-2,null,null,null,null,null,49]
[null,null,null,{"$f":"IF(D67<rdura,D67+1,\"\")","v":65},{"$f":"IF(D68=\"\",\"\", ((1+raterd/factor1)^(factor1*D68/12)-1)/(D68/12))","v":9.9014752528371608E-2},{"$f":"IF(D68=\"\",\"\",  raterd)","v":8.2500000000000004E-2},null,null,null,null,null,{"$f":"L67+1","v":50}]
[null,null,null,66,9.9365936939926028E-2,8.2500000000000004E-2,null,null,null,null,null,51]
[null,null,null,67,9.9718726154746806E-2,8.2500000000000004E-2,null,null,null,null,null,52]
[null,null,null,68,0.10007312831281172,8.2500000000000004E-2,null,null,null,null,null,53]
[null,null,null,69,0.10042915159784549,8.2500000000000004E-2,null,null,null,null,null,54]
[null,null,null,70,0.10078680423756387,8.2500000000000004E-2,null,null,null,null,null,55]
[null,null,null,71,0.1011460945039187,8.2500000000000004E-2,null,null,null,null,null,56]
[null,null,null,72,0.10150703071334503,8.2500000000000004E-2,null,null,null,null,null,57]
[null,null,null,73,0.10186962122700934,8.2500000000000004E-2,null,null,null,null,null,58]
[null,null,null,74,0.1022338744510585,8.2500000000000004E-2,null,null,null,null,null,59]
[null,null,null,75,0.10259979883687155,8.2500000000000004E-2,null,null,null,null,null,60]
[null,null,null,76,0.10296740288131186,8.2500000000000004E-2,null,null,null,null,null,61]
[null,null,null,77,0.10333669512698114,8.2500000000000004E-2,null,null,null,null,null,62]
[null,null,null,78,0.10370768416247457,8.2500000000000004E-2,null,null,null,null,null,63]
[null,null,null,79,0.10408037862263798,8.2500000000000004E-2,null,null,null,null,null,64]
[null,null,null,80,0.10445478718882589,8.2500000000000004E-2,null,null,null,null,null,65]
[null,null,null,81,0.10483091858916144,8.2500000000000004E-2,null,null,null,null,null,66]
[null,null,null,82,0.10520878159879758,8.2500000000000004E-2,null,null,null,null,null,67]
[null,null,null,83,0.10558838504017992,8.2500000000000004E-2,null,null,null,null,null,68]
[null,null,null,84,0.10596973778331087,8.2500000000000004E-2,null,null,null,null,null,69]
[null,null,null,85,0.10635284874601585,8.2500000000000004E-2,null,null,null,null,null,70]
[null,null,null,86,0.10673772689420978,8.2500000000000004E-2,null,null,null,null,null,71]
[null,null,null,87,0.10712438124216678,8.2500000000000004E-2,null,null,null,null,null,72]
[null,null,null,88,0.10751282085279013,8.2500000000000004E-2,null,null,null,null,null,73]
[null,null,null,89,0.10790305483788422,8.2500000000000004E-2,null,null,null,null,null,74]
[null,null,null,90,0.10829509235842823,8.2500000000000004E-2,null,null,null,null,null,75]
[null,null,null,91,0.10868894262485103,8.2500000000000004E-2,null,null,null,null,null,76]
[null,null,null,92,0.10908461489730785,8.2500000000000004E-2,null,null,null,null,null,77]
[null,null,null,93,0.10948211848595857,8.2500000000000004E-2,null,null,null,null,null,78]
[null,null,null,94,0.10988146275124754,8.2500000000000004E-2,null,null,null,null,null,79]
[null,null,null,95,0.11028265710418492,8.2500000000000004E-2,null,null,null,null,null,80]
[null,null,null,96,0.11068571100662974,8.2500000000000004E-2,null,null,null,null,null,81]
[null,null,null,{"$f":"IF(D99<rdura,D99+1,\"\")","v":97},{"$f":"IF(D100=\"\",\"\", ((1+raterd/factor1)^(factor1*D100/12)-1)/(D100/12))","v":0.11109063397157509},{"$f":"IF(D100=\"\",\"\",  raterd)","v":8.2500000000000004E-2},null,null,null,null,null,82]
[null,null,null,98,0.11149743556343326,8.2500000000000004E-2,null,null,null,null,null,83]
[null,null,null,99,0.11190612539832487,8.2500000000000004E-2,null,null,null,null,null,84]
[null,null,null,100,0.11231671314436786,8.2500000000000004E-2,null,null,null,null,null,85]
[null,null,null,101,0.11272920852196891,8.2500000000000004E-2,null,null,null,null,null,86]
[null,null,null,102,0.11314362130411641,8.2500000000000004E-2,null,null,null,null,null,87]
[null,null,null,103,0.11355996131667487,8.2500000000000004E-2,null,null,null,null,null,88]
[null,null,null,104,0.11397823843868163,8.2500000000000004E-2,null,null,null,null,null,89]
[null,null,null,105,0.11439846260264441,8.2500000000000004E-2,null,null,null,null,null,90]
[null,null,null,106,0.11482064379484143,8.2500000000000004E-2,null,null,null,null,null,91]
[null,null,null,107,0.11524479205562257,8.2500000000000004E-2,null,null,null,null,null,92]
[null,null,null,108,0.11567091747971261,8.2500000000000004E-2,null,null,null,null,null,93]
[null,null,null,109,0.11609903021651666,8.2500000000000004E-2,null,null,null,null,null,94]
[null,null,null,110,0.11652914047042558,8.2500000000000004E-2,null,null,null,null,null,95]
[null,null,null,111,0.11696125850112596,8.2500000000000004E-2,null,null,null,null,null,96]
[null,null,null,112,0.11739539462390915,8.2500000000000004E-2,null,null,null,null,null,97]
[null,null,null,113,0.1178315592099838,8.2500000000000004E-2,null,null,null,null,null,98]
[null,null,null,114,0.11826976268678957,8.2500000000000004E-2,null,null,null,null,null,99]
[null,null,null,115,0.11871001553831269,8.2500000000000004E-2,null,null,null,null,null,100]
[null,null,null,116,0.11915232830540325,8.2500000000000004E-2,null,null,null,null,null,101]
[null,null,null,117,0.11959671158609467,8.2500000000000004E-2,null,null,null,null,null,102]
[null,null,null,118,0.12004317603592443,8.2500000000000004E-2,null,null,null,null,null,103]
[null,null,null,119,0.12049173236825733,8.2500000000000004E-2,null,null,null,null,null,104]
[null,null,null,120,0.12094239135461002,8.2500000000000004E-2,null,null,null,null,null,105]
[null,null,null,null,null,null,null,null,null,null,null,106]
[null,null,null,null,null,null,null,null,null,null,null,107]
[null,null,null,null,null,null,null,null,null,null,null,108]
[null,null,null,null,null,null,null,null,null,null,null,109]
[null,null,null,null,null,null,null,null,null,null,null,110]
[null,null,null,null,null,null,null,null,null,null,null,111]
[null,null,null,null,null,null,null,null,null,null,null,112]
[null,null,null,null,null,null,null,null,null,null,null,113]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L131+1","v":114}]
[null,null,null,null,null,null,null,null,null,null,null,115]
[null,null,null,null,null,null,null,null,null,null,null,116]
[null,null,null,null,null,null,null,null,null,null,null,117]
[null,null,null,null,null,null,null,null,null,null,null,118]
[null,null,null,null,null,null,null,null,null,null,null,119]
[null,null,null,null,null,null,null,null,null,null,null,120]

{"sheet":"Cal FD rate from FD yield","index":1,"n_rows":138,"n_cols":13,"rows_kept":138,"cut":false,"hidden":false,"merged":[[16,0,16,1],[0,0,0,1],[1,0,1,1],[3,0,3,1],[14,0,14,1],[15,0,15,1]]}
["Calculate interest rate from FD yield",null,null,"Month","Annualized","Annual ",null,null,null,null,{"$f":"IF(term=\"Quarterly\",4,IF(term=\"Half-yearly\",2,IF(term=\"Yearly\",1,IF(term=\"Monthly\",12))))","v":4},1]
["Investment tenure in months and years",null,null,null,"Yield","interest rate",null,null,null,null,{"$f":"IF(term=\"Quarterly\",3,IF(term=\"Half-yearly\",6,IF(term=\"Yearly\",12,IF(term=\"Monthly\",1))))","v":3},2]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L2+1","v":3}]
["Fill only the cells with green background",null,null,{"$f":"IF(D3<rdura,D3+1,\"\")","v":1},{"$f":"IF(D4=\"\",\"\", ((1+raterd/factor1)^(factor1*D4/12)-1)/(D4/12))","v":9.4347916464254666E-2},{"$f":"IF(D4=\"\",\"\",  raterd)","v":9.5091654651819901E-2},null,null,null,null,null,{"$f":"L3+1","v":4}]
["Annualized Yield (as advertised)",0.10381,null,2,9.4718813520136003E-2,9.5091654651819901E-2,null,null,null,null,null,5]
["Investment",100,null,3,9.5091654651819901E-2,9.5091654651819901E-2,null,null,null,null,null,6,"Quarterly"]
["Duration of invest. (months)*",25,null,4,9.5466451323025003E-2,9.5091654651819901E-2,null,null,null,null,null,7,"Half-yearly"]
["* 2 - 120 months (max. allowed duration)",null,null,5,9.5843215069574939E-2,9.5091654651819901E-2,null,null,null,null,null,8,"Yearly"]
["Type of Compounding","Quarterly",null,6,9.6221957499872612E-2,9.5091654651819901E-2,null,null,null,null,null,9,"Monthly"]
["Annual interest rate (constant!)",{"$f":"(((B5*(rdura/12))+1)^(1/(factor1*rdura/12))-1)*factor1","v":9.5091654651819901E-2},null,7,9.6602690295371829E-2,9.5091654651819901E-2,null,null,null,null,null,10]
["Pre-tax Corpus",{"$f":"fdamt*(1+raterd/factor1)^(factor1*rdura/12)","v":121.62708333333335},null,8,9.6985425211060239E-2,9.5091654651819901E-2,null,null,null,null,null,11]
[null,null,null,9,9.7370174075938287E-2,9.5091654651819901E-2,null,null,null,null,null,12]
[null,null,null,10,9.775694879350709E-2,9.5091654651819901E-2,null,null,null,null,null,13]
["Feedback welcome:  pattu@iitm.ac.in",null,null,11,9.8145761342254487E-2,9.5091654651819901E-2,null,null,null,null,null,14]
[null,null,null,12,9.8536623776149357E-2,9.5091654651819901E-2,null,null,null,null,null,15]
["Enter only months. ",null,null,13,9.8929548225134611E-2,9.5091654651819901E-2,null,null,null,null,null,16]
["Use this to convert!",null,null,14,9.9324546895627003E-2,9.5091654651819901E-2,null,null,null,null,null,17]
["Years",6,null,15,9.972163207101907E-2,9.5091654651819901E-2]
["Months",{"$f":"12*B18","v":72},null,16,0.10012081611218343,9.5091654651819901E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!+#REF!+#REF!)","v":{"$error":"#REF!"}},null,1]
[null,null,null,17,0.10052211145798265,9.5091654651819901E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J19+#REF!+#REF!)","v":{"$error":"#REF!"}},null,2]
[null,null,null,18,0.10092553062578036,9.5091654651819901E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J20+#REF!+#REF!)","v":{"$error":"#REF!"}},null,3]
[null,null,null,19,0.10133108621195731,9.5091654651819901E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J21+#REF!+#REF!)","v":{"$error":"#REF!"}},null,4]
[null,null,null,20,0.10173879089243044,9.5091654651819901E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J22+#REF!+#REF!)","v":{"$error":"#REF!"}},null,5]
[null,null,null,21,0.10214865742317551,9.5091654651819901E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J23+#REF!+#REF!)","v":{"$error":"#REF!"}},null,6]
[null,null,null,22,0.10256069864075283,9.5091654651819901E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J24+#REF!+#REF!)","v":{"$error":"#REF!"}},null,7]
[null,null,null,23,0.1029749274628371,9.5091654651819901E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J25+#REF!+#REF!)","v":{"$error":"#REF!"}},null,8]
[null,null,null,24,0.10339135688875056,9.5091654651819901E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J26+#REF!+#REF!)","v":{"$error":"#REF!"}},null,9]
[null,null,null,25,0.10381000000000003,9.5091654651819901E-2,null,null,null,{"$f":"IF(#REF!=\"\",\"\",J27+#REF!+#REF!)","v":{"$error":"#REF!"}},null,10]
[null,null,null,"","","",null,null,null,{"$f":"IF(#REF!=\"\",\"\",J28+#REF!+#REF!)","v":{"$error":"#REF!"}},null,11]
[null,null,null,"","","",null,null,null,{"$f":"IF(#REF!=\"\",\"\",J29+#REF!+#REF!)","v":{"$error":"#REF!"}},null,12]
[null,null,null,"","","",null,null,null,{"$f":"IF(#REF!=\"\",\"\",J30+#REF!+#REF!)","v":{"$error":"#REF!"}},null,13]
[null,null,null,"","","",null,null,null,{"$f":"IF(#REF!=\"\",\"\",J31+#REF!+#REF!)","v":{"$error":"#REF!"}},null,14]
[null,null,null,"","","",null,null,null,{"$f":"IF(#REF!=\"\",\"\",J32+#REF!+#REF!)","v":{"$error":"#REF!"}},null,15]
[null,null,null,"","","",null,null,null,{"$f":"IF(#REF!=\"\",\"\",J33+#REF!+#REF!)","v":{"$error":"#REF!"}},null,16]
[null,null,null,"","","",null,null,null,{"$f":"IF(#REF!=\"\",\"\",J34+#REF!+#REF!)","v":{"$error":"#REF!"}},null,17]
[null,null,null,{"$f":"IF(D35<rdura,D35+1,\"\")","v":""},{"$f":"IF(D36=\"\",\"\", ((1+raterd/factor1)^(factor1*D36/12)-1)/(D36/12))","v":""},{"$f":"IF(D36=\"\",\"\",  raterd)","v":""},null,null,null,null,null,18]
[null,null,null,"","","",null,null,null,null,null,19]
[null,null,null,"","","",null,null,null,null,null,20]
[null,null,null,"","","",null,null,null,null,null,21]
[null,null,null,"","","",null,null,null,null,null,22]
[null,null,null,"","","",null,null,null,null,null,23]
[null,null,null,"","","",null,null,null,null,null,24]
[null,null,null,"","","",null,null,null,null,null,25]
[null,null,null,"","","",null,null,null,null,null,26]
[null,null,null,"","","",null,null,null,null,null,27]
[null,null,null,"","","",null,null,null,null,null,28]
[null,null,null,"","","",null,null,null,null,null,29]
[null,null,null,"","","",null,null,null,null,null,30]
[null,null,null,"","","",null,null,null,null,null,31]
[null,null,null,"","","",null,null,null,null,null,32]
[null,null,null,"","","",null,null,null,null,null,33]
[null,null,null,"","","",null,null,null,null,null,34]
[null,null,null,"","","",null,null,null,null,null,35]
[null,null,null,"","","",null,null,null,null,null,36]
[null,null,null,"","","",null,null,null,null,null,37]
[null,null,null,"","","",null,null,null,null,null,38]
[null,null,null,"","","",null,null,null,null,null,39]
[null,null,null,"","","",null,null,null,null,null,40]
[null,null,null,"","","",null,null,null,null,null,41]
[null,null,null,"","","",null,null,null,null,null,42]
[null,null,null,"","","",null,null,null,null,null,43]
[null,null,null,"","","",null,null,null,null,null,44]
[null,null,null,"","","",null,null,null,null,null,45]
[null,null,null,"","","",null,null,null,null,null,46]
[null,null,null,"","","",null,null,null,null,null,47]
[null,null,null,"","","",null,null,null,null,null,48]
[null,null,null,"","","",null,null,null,null,null,49]
[null,null,null,{"$f":"IF(D67<rdura,D67+1,\"\")","v":""},{"$f":"IF(D68=\"\",\"\", ((1+raterd/factor1)^(factor1*D68/12)-1)/(D68/12))","v":""},{"$f":"IF(D68=\"\",\"\",  raterd)","v":""},null,null,null,null,null,{"$f":"L67+1","v":50}]
[null,null,null,"","","",null,null,null,null,null,51]
[null,null,null,"","","",null,null,null,null,null,52]
[null,null,null,"","","",null,null,null,null,null,53]
[null,null,null,"","","",null,null,null,null,null,54]
[null,null,null,"","","",null,null,null,null,null,55]
[null,null,null,"","","",null,null,null,null,null,56]
[null,null,null,"","","",null,null,null,null,null,57]
[null,null,null,"","","",null,null,null,null,null,58]
[null,null,null,"","","",null,null,null,null,null,59]
[null,null,null,"","","",null,null,null,null,null,60]
[null,null,null,"","","",null,null,null,null,null,61]
[null,null,null,"","","",null,null,null,null,null,62]
[null,null,null,"","","",null,null,null,null,null,63]
[null,null,null,"","","",null,null,null,null,null,64]
[null,null,null,"","","",null,null,null,null,null,65]
[null,null,null,"","","",null,null,null,null,null,66]
[null,null,null,"","","",null,null,null,null,null,67]
[null,null,null,"","","",null,null,null,null,null,68]
[null,null,null,"","","",null,null,null,null,null,69]
[null,null,null,"","","",null,null,null,null,null,70]
[null,null,null,"","","",null,null,null,null,null,71]
[null,null,null,"","","",null,null,null,null,null,72]
[null,null,null,"","","",null,null,null,null,null,73]
[null,null,null,"","","",null,null,null,null,null,74]
[null,null,null,"","","",null,null,null,null,null,75]
[null,null,null,"","","",null,null,null,null,null,76]
[null,null,null,"","","",null,null,null,null,null,77]
[null,null,null,"","","",null,null,null,null,null,78]
[null,null,null,"","","",null,null,null,null,null,79]
[null,null,null,"","","",null,null,null,null,null,80]
[null,null,null,"","","",null,null,null,null,null,81]
[null,null,null,{"$f":"IF(D99<rdura,D99+1,\"\")","v":""},{"$f":"IF(D100=\"\",\"\", ((1+raterd/factor1)^(factor1*D100/12)-1)/(D100/12))","v":""},{"$f":"IF(D100=\"\",\"\",  raterd)","v":""},null,null,null,null,null,82]
[null,null,null,"","","",null,null,null,null,null,83]
[null,null,null,"","","",null,null,null,null,null,84]
[null,null,null,"","","",null,null,null,null,null,85]
[null,null,null,"","","",null,null,null,null,null,86]
[null,null,null,"","","",null,null,null,null,null,87]
[null,null,null,"","","",null,null,null,null,null,88]
[null,null,null,"","","",null,null,null,null,null,89]
[null,null,null,"","","",null,null,null,null,null,90]
[null,null,null,"","","",null,null,null,null,null,91]
[null,null,null,"","","",null,null,null,null,null,92]
[null,null,null,"","","",null,null,null,null,null,93]
[null,null,null,"","","",null,null,null,null,null,94]
[null,null,null,"","","",null,null,null,null,null,95]
[null,null,null,"","","",null,null,null,null,null,96]
[null,null,null,"","","",null,null,null,null,null,97]
[null,null,null,"","","",null,null,null,null,null,98]
[null,null,null,"","","",null,null,null,null,null,99]
[null,null,null,"","","",null,null,null,null,null,100]
[null,null,null,"","","",null,null,null,null,null,101]
[null,null,null,"","","",null,null,null,null,null,102]
[null,null,null,"","","",null,null,null,null,null,103]
[null,null,null,"","","",null,null,null,null,null,104]
[null,null,null,"","","",null,null,null,null,null,105]
[null,null,null,null,null,null,null,null,null,null,null,106]
[null,null,null,null,null,null,null,null,null,null,null,107]
[null,null,null,null,null,null,null,null,null,null,null,108]
[null,null,null,null,null,null,null,null,null,null,null,109]
[null,null,null,null,null,null,null,null,null,null,null,110]
[null,null,null,null,null,null,null,null,null,null,null,111]
[null,null,null,null,null,null,null,null,null,null,null,112]
[null,null,null,null,null,null,null,null,null,null,null,113]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L131+1","v":114}]
[null,null,null,null,null,null,null,null,null,null,null,115]
[null,null,null,null,null,null,null,null,null,null,null,116]
[null,null,null,null,null,null,null,null,null,null,null,117]
[null,null,null,null,null,null,null,null,null,null,null,118]
[null,null,null,null,null,null,null,null,null,null,null,119]
[null,null,null,null,null,null,null,null,null,null,null,120]