{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Eine Variable","Zwei Variable","Drei Variable"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",6]
[null,"Thema","Analyse-Methoden"]
[]
[null,"Inhalt","Datentabelle"]
[null,null,"● mit einer Variablen"]
[null,null,"● mit zwei Variablen"]
[null,null,"● mit mehr als zwei Variablen"]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-25"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Eine Variable","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Anzahlung",0,null,"Zinssatz","Zahlung"]
["Zinssatz",9.2999999999999999E-2,null,null,{"$f":"PMT(_xlfn.SINGLE(Zinssatz)/12,_xlfn.SINGLE(Laufzeit),-_xlfn.SINGLE(Darlehen)+_xlfn.SINGLE(Anzahlung))","v":459.55494787597416}]
["Laufzeit",240,null,9.0999999999999998E-2,453.08367585062126]
["Darlehen",50000,null,9.1999999999999998E-2,456.31435550512538]
[null,null,null,9.2999999999999999E-2,459.55494787597416]
[null,null,null,9.4E-2,462.80538378811343]
[null,null,null,9.5000000000000001E-2,466.06559391675904]
[null,null,null,9.6000000000000002E-2,469.33550879999336]
[null,null,null,9.7000000000000003E-2,472.61505885125371]
[null,null,null,9.8000000000000004E-2,475.90417437170913]

{"sheet":"Zwei Variable","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,5,0,8]]}
["Anzahlung",0,null,null,null,"Monate"]
["Zinssatz",9.2999999999999999E-2,null,null,{"$f":"PMT(_xlfn.SINGLE(Zinssatz)/12,_xlfn.SINGLE(Laufzeit),-_xlfn.SINGLE(Darlehen)+_xlfn.SINGLE(Anzahlung))","v":459.55494787597416},180,240,300,360]
["Laufzeit",240,null,null,9.0999999999999998E-2,459.55494787597416,459.55494787597416,459.55494787597416,459.55494787597416]
["Darlehen",50000,null,null,9.1999999999999998E-2,459.55494787597416,459.55494787597416,459.55494787597416,459.55494787597416]
[null,null,null,null,9.2999999999999999E-2,459.55494787597416,459.55494787597416,459.55494787597416,459.55494787597416]
[null,null,null,null,9.4E-2,459.55494787597416,459.55494787597416,459.55494787597416,459.55494787597416]
[null,null,null,null,9.5000000000000001E-2,459.55494787597416,459.55494787597416,459.55494787597416,459.55494787597416]
[null,null,null,null,9.6000000000000002E-2,459.55494787597416,459.55494787597416,459.55494787597416,459.55494787597416]
[null,null,null,null,9.7000000000000003E-2,459.55494787597416,459.55494787597416,459.55494787597416,459.55494787597416]
[null,null,null,null,9.8000000000000004E-2,459.55494787597416,459.55494787597416,459.55494787597416,459.55494787597416]

{"sheet":"Drei Variable","index":3,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Investition\nRückfluss",{"$f":"\"-125.000 €\" & CHAR(10) & \"5.000 €\"","v":"-125.000 €\n5.000 €"}]
["Laufzeit ",12]
[]
["Jahr","Rückfluss","IKV",null,"Investition","Rückfluss",null,"Laufzeit"]
[0,{"$f":"LEFT(Werte,-1+FIND(CHAR(10),Werte))*1","v":{"$error":"#NAME?"}},{"$f":"IRR(B5:B17)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"TEXT(IRR(Rückfluss),\"0,0 %\") & CHAR(10) & TEXT(NPV(6%,Rückfluss),\"#.##0,00 €\")","v":{"$error":"#NAME?"}},10,11,12,13,14,15,16,17,18,19,20]
[1,{"$f":"IF(Jahr<=LZeit,MID(Werte,FIND(CHAR(10),Werte)+1,99)*1,0)","v":{"$error":"#NAME?"}},null,null,-125000,8000,{"$f":"TEXT(Invest,\"#.##0,00 €\") & CHAR(10) & TEXT(Rück,\"#.##0,00 €\")","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[2,{"$error":"#NAME?"},null,null,-125000,10000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[3,{"$error":"#NAME?"},null,null,-125000,12000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[4,{"$error":"#NAME?"},null,null,-120000,8000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[5,{"$error":"#NAME?"},null,null,-120000,10000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[6,{"$error":"#NAME?"},null,null,-120000,12000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[7,{"$error":"#NAME?"},null,null,-115000,8000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[8,{"$error":"#NAME?"},null,null,-115000,10000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[9,{"$error":"#NAME?"},null,null,-115000,12000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[10,{"$error":"#NAME?"},null,null,-110000,8000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[11,{"$error":"#NAME?"},null,null,-110000,10000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[12,{"$error":"#NAME?"},null,null,-110000,12000,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]