{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["START","CHARTS","DivYields","DivBuchungen_IMPORT_PP","Wertpapiere_IMPORT_PP","DIV_MONAT_TAB","Div_Analyse","Chart_Daten","Speicherverbrauch"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":21,"n_cols":8,"rows_kept":21,"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:"]
[]
[]
[]
["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) Button oben drücken und den Anweisungen folgen"]
[]
[]
["Analysen:","Charts"]
[]
["1) Chart mit einem gleitenden Jahres-Durchschnitt der erhaltenen Erträge pro Monat auf Tagesbasis"]
["2) Pivot Tabelle mit dem erwarteten Einkommen pro Monat (auf Basis der aktuellsten Bestände; aber vergangenen Erträge/Share)"]
["3) Charts mit Jahres- und Monatsüberblick"]

{"sheet":"CHARTS","index":1,"n_rows":3,"n_cols":12,"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},null,"Yield (exp.)",{"$f":"E1/B1","v":{"$error":"#DIV/0!"}},null,"Avg (365) monthly Income net",{"$f":"DivBuchungen_IMPORT_PP!L2","v":0}]
["Cost Basis",{"$f":"SUM(DivYields!B:B)","v":0},null,"Gross Income last 12 Month ",{"$f":"DivBuchungen_IMPORT_PP!J2","v":0},null,"YoC  (exp.)",{"$f":"E1/B2","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"}},"Change"]
[null,null,null,null,null,null,null,null,null,"Avg (365) monthly Inc. exp. (gross)",{"$f":"E1/12","v":0},{"$f":"K3/K2-1","v":{"$error":"#N/A"}}]

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

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

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

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

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

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

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