{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Tabelle1","index":0,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,7,24,7],[8,7,9,7],[11,7,12,7],[14,7,15,7],[17,7,18,7],[20,7,21,7]]}
[]
[]
[null,"Die Funktion für die Renditeberechnung ist in Modul 1 abgelegt, zu erreichen über Tastenkombi Alt F11"]
[]
[]
[]
[]
[null,"Anlagedauer in Jahren, taggenau berechnet, Basis 365 Tage/Jahr","Datum","Kapital",null,"Rendite p. a. mit Funktion berechnet"]
[null,{"$f":"(C10-C9)/365","v":0.49589041095890413},"2016-01-01",1000,null,null,null,"Zinsen 50,00€, Haltedauer halbes Jahr"]
[null,null,"2016-06-30",1050,null,{"$f":"[1]!renditepa(D9,D10,C9,C10)","v":10.339192671308673}]
[]
[null,{"$f":"(C13-C12)/365","v":1},"2016-01-01",1000,null,null,null,"Zinsen 50,00€, Haltedauer ein Jahr"]
[null,null,"2016-12-31",1050,null,{"$f":"[1]!renditepa(D12,D13,C12,C13)","v":5.0000000000000044}]
[]
[null,2,"2016-01-01",1000,null,null,null,"Zinsen 50,00€, Haltedauer zwei Jahre"]
[null,null,"2017-12-31",1050,null,{"$f":"[1]!renditepa(D15,D16,C15,C16)","v":2.4695076595959931}]
[]
[null,2,"2016-01-01",1000,null,null,null,"Zinsen 102,50€, Haltedauer zwei Jahre"]
[null,null,"2017-12-31",1102.5,null,{"$f":"[1]!renditepa(D18,D19,C18,C19)","v":5.0000000000000044}]
[]
[null,3,"2016-01-01",1000,null,null,null,"Zinsen 157,625€, Haltedauer drei Jahre"]
[null,null,"2018-12-31",1157.625,null,{"$f":"[1]!renditepa(D21,D22,C21,C22)","v":5.0000000000000044}]
[]
[null,{"$f":"(C25-C24)/365","v":2.0547945205479454},"2016-01-01",1000,null,null,null,"Zinsen 200,00€, Haltedauer taggenau bis heute()"]
[null,null,{"$f":"TODAY()","v":"2018-01-20"},1200,null,{"$f":"[1]!renditepa(D24,D25,C24,C25)","v":9.2785372392903742}]