{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["START","Anleitung","CHARTS","DIV_AUSWERT","DIV_MONAT_TAB","DivYields","DivBuchungen_IMPORT_PP","Wertpapiere_IMPORT_PP","Div_Analyse","Chart_Daten","Laufzeitanalyse","Speicherverbrauch"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":"START","index":0,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Config"]
[null,null,null,null,null,null,null,"Div-File:"]
[null,null,null,null,null,null,null,"WP-File:"]
[]
[]
[]
[null,null,null,null,null,null,null,"Wechselkurs USD"]

{"sheet":"Anleitung","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Anleitung:"]
[]
["1) aus Portfolio-Performance die beiden Exporte  speichern:"]
[null,"a) Berichte -> Performance -> Wertpapiere (\"Wertpapier_Performance_(Standard).csv\")"]
[null,"b) Berichte -> Dividenden -> Buchungen exportieren (\"Buchungen.csv\")"]
[]
["2) Datenimport Button drücken"]

{"sheet":"CHARTS","index":2,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["NAV",{"$f":"SUM(DivYields!C:C)","v":0},null,"Gross Income 12 Month (exp.)",{"$f":"SUM(DivYields!D:D)","v":0},"Change","Yield (exp.)",{"$f":"E1/B1","v":{"$error":"#DIV/0!"}},null,"Avg (365) monthly Income net",{"$f":"Div_Analyse!P2","v":0},"Change","Income Delay (Days)"]
["SUM Div",{"$f":"SUM(DivBuchungen_IMPORT_PP!F:F)","v":0},{"$f":"B2/B1","v":{"$error":"#DIV/0!"}},"Gross Income last 12 Month ",{"$f":"Div_Analyse!N2","v":0},{"$f":"E1/E2-1","v":{"$error":"#DIV/0!"}},"YoC  (exp.)",{"$f":"E1/B3","v":{"$error":"#DIV/0!"}},null,"Avg (365) monthly Income (gross)",{"$f":"LOOKUP(2,1/(Chart_Daten!G:G<>\"\"),Chart_Daten!G:G)","v":{"$error":"#N/A"}},{"$f":"K3/K2-1","v":{"$error":"#N/A"}},4]
["Cost Basis",{"$f":"SUM(DivYields!B:B)-B2","v":0},{"$f":"B1/B3-1","v":{"$error":"#DIV/0!"}},"Gross Income last Year",{"$f":"VLOOKUP(EOMONTH(\"1.1.\"&YEAR(TODAY())-1,0),Chart_Daten!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"E1/E3-1","v":{"$error":"#N/A"}},null,null,null,"Avg (365) monthly Inc. exp. (gross)",{"$f":"E1/12","v":0}]

{"sheet":"DIV_AUSWERT","index":3,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Spalte1","Spalte2","Spalte3","Spalte4","Spalte5","Spalte6","Spalte7","Spalte8"]

{"sheet":"DIV_MONAT_TAB","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DivYields","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DivBuchungen_IMPORT_PP","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Wertpapiere_IMPORT_PP","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Div_Analyse","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Chart_Daten","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Laufzeitanalyse","index":10,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Start"]
["Clear Tabs",null,{"$f":"B2-B1","v":0}]
["OS Check",null,{"$f":"B3-B2","v":0}]
["Import",null,0]
["Dividenden Aufbereitung + Chart",null,0]
["DIV Analyse - Zwischentabelle",null,0]
["Dublettensuche",null,0]
["Pivot Table vorbereiten",null,0]
["Yield-Statistiken sammeln",null,0]
["Pivot aktualisieren",null,0]
["Charts anpassen",null,0]
["Div Kal 1",null,0]
["Div Kal 2",null,0]
["Div Kal Aufbau",null,0]
["Div Kal Sort",null,0]
["Erwartetes Einkommen",null,0]
["Div Kal Optics",null,0]
["Div Auswertung",null,0,{"$f":"B18-B1","v":0}]

{"sheet":"Speicherverbrauch","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}