{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["START","Anleitung","CHARTS","SektorChart","DIV_AUSWERT","DIV_MONAT_TAB","DivYields","DivBuchungen_IMPORT_PP","Wertpapiere_IMPORT_PP","Div_Analyse","Chart_Daten","Laufzeitanalyse","Speicherverbrauch"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":2},"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":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,8,2,13],[3,8,3,13],[7,7,7,8]]}
[]
[null,null,null,null,null,null,null,"Config",{"$f":"IF(ISERROR(IF(AND(H2=H1,G2<>G1,B2=B1,YEAR(A2)=YEAR(A1)),\"x\",\"\")),\"\",IF(AND(H2=H1,B2=B1,YEAR(A2)=YEAR(A1)),\"x\",\"\"))","v":""}]
[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,"SektorData (Ja/Nein)","Ja"]
[]
[null,null,null,null,null,null,null,"Wechselkurs USD"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"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\")"]
[null,"c) Sektordaten (GICS) können in  Berichte -> Performance -> Wertpapiere (\"Wertpapier_Performance_(Standard).csv\") -> Klassifizierung -> Sektor hinzugenommen werden"]
["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:$L,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":"SektorChart","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

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

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

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

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

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

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

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

{"sheet":"Laufzeitanalyse","index":11,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Start",46294.390625]
["Clear Tabs",46297.48046875,{"$f":"B2-B1","v":3.08984375}]
["OS Check",46297.48828125,{"$f":"B3-B2","v":7.8125E-3}]
["Import",46298.8203125,1.33203125]
["Dividenden Aufbereitung + Chart",46299.2109375,0.390625]
["DIV Analyse - Zwischentabelle",46299.48046875,0.26953125]
["Dublettensuche",46299.66015625,0.1796875]
["Pivot Table vorbereiten",46301.46875,1.80859375]
["Yield-Statistiken sammeln",46303.75,2.28125]
["Pivot aktualisieren",46308.12890625,4.37890625]
["Charts anpassen",46311.4296875,3.30078125]
["Div Kal 1",46312.5,1.0703125]
["Div Kal 2",46313.3203125,0.8203125]
["Div Kal Aufbau",46314.109375,0.7890625]
["Div Kal Sort",46316.80859375,2.69921875]
["Erwartetes Einkommen",46318.26953125,1.4609375]
["Div Kal Optics",46318.80078125,0.53125]
["Div Auswertung",46325.171875,6.37109375,{"$f":"B18-B1","v":30.78125}]

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