{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lebensversicherung","__Goal_Metadata"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":3,"comments":1,"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":"Lebensversicherung","index":0,"n_rows":167,"n_cols":35,"rows_kept":167,"cut":false,"hidden":false,"merged":[[37,7,37,10],[39,7,39,10],[41,7,41,10],[45,7,45,10],[43,7,43,10],[15,6,15,10],[35,8,35,10],[19,4,19,10],[20,4,20,10],[21,4,21,10],[22,4,22,10],[23,4,23,10]]}
["V=7.3;ID=20000;Typ=LEBEN"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Private Finanz- und Vermögensplanung"]
[null,null,null,"Lebensversicherung"]
[]
[]
[null,null,null,"Allgemeine Angaben"]
[]
[null,null,null,null,"Erstellt von:"]
[]
[null,null,null,null,"Anmerkungen, z.B. wer im welchem Umfang bezugsberechtigt oder wer versichert ist:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"\"Angaben zur \" &D11","v":"Angaben zur Lebensversicherung"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Art der Lebensversicherung"]
[]
[null,null,null,null,"Bezeichnung"]
[]
[null,null,null,null,"Versicherungsunternehmen"]
[]
[null,null,null,null,"Versicherungsnummer"]
[]
[null,null,null,null,"Versicherungsbeginn (tt.mm.jjjj)"]
[]
[null,null,null,null,"Ablaufdatum (tt.mm.jjjj)"]
[]
[null,null,null,null,"Versicherungsbeitrag",null,"Zahlungsturnus",null,null,null,"€"]
[]
[]
[]
[null,null,null,null,"Versicherungssumme bei Versicherungsablauf",null,null,null,null,null,"€"]
[]
[null,null,null,null,"Vorausichtliche einmalige Leistung bei Versicherungsablauf",null,null,null,null,null,"€"]
[]
[null,null,null,null,"Voraussichtliche Monatsrente bei Versicherungsablauf",null,null,null,null,null,"€"]
[]
[null,null,null,null,"Rückkaufswert zum 31.12. (jjjj)",null,"Jahr",null,null,null,"€"]
[]
[null,null,null,null,"Todesfallleistung zum 31.12. (jjjj)",null,"Jahr",null,null,null,"€"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kapitallebensversicherung","KAPLV",null,null,null,null,null,"monatlich","MONAT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fondsgebundene Lebensversicherung","FONLV",null,null,null,null,null,"vierteljährlich","VJAHR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Private Leibrentenversicherung","RENTV",null,null,null,null,null,"halbjährlich","HJAHR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sonstige kapitalbildende Lebensversicherung","SONLV",null,null,null,null,null,"jährlich","JAHR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"einmalig","EINM"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notiz erstellen:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beschriftung","Wert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G16=\"\",\"\",E16)","v":""},{"$f":"IF(G16=\"\",\"\",G16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E20=\"\",E21=\"\",E22=\"\",E23=\"\",E24=\"\"),\"\",\"Anmerkungen:\")","v":""},{"$f":"TRIM(E20&\" \"&E21&\" \"&E22&\" \"&E23&\" \"&E24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AA118=\"\",AA119=\"\"),\"\",\"; \")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notiz:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA118&\" \"&AB118&AA120&AA119&\" \"&AB119","v":"  "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DB-Infofeld","Wert","Gültigkeit"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"artlebensv","KAPLV","Listeneintrag","Typ Text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bez",{"$f":"TEXT(H38,\"standard\")","v":"0"},"0-50","Typ Text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"betriebsname",{"$f":"TEXT(H40,\"standard\")","v":"0"},"0-50","Typ Text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rechtnr",{"$f":"TEXT(H42,\"standard\")","v":"0"},"0-20","Typ Text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vom",{"$f":"H44","v":"00:00:00"},">=1.1.1900","Datum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bis",{"$f":"H46","v":"00:00:00"},">=1.1.1900","Datum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"monat",{"$f":"MONTH(H44)","v":1},"mm.jjjj"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jahr",{"$f":"YEAR(H44)","v":1900},"mm.jjjj"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sparbetrag",{"$f":"ROUND(J48,2)","v":0},"Dez >=0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"_TurnusSparbetrag","MONAT","Listeneintrag","Typ Text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zusbetrag1",{"$f":"ROUND(J52,2)","v":0},"Dez >=0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ausgangbetrag",{"$f":"ROUND(J54,2)","v":0},"Dez >=0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zusbetrag2",{"$f":"ROUND(J56,2)","v":0},"Dez >=0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"histdatum",{"$f":"DATE(H58,12,31)","v":"1900-12-31"},4,"Typ Datum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"verkwert",{"$f":"ROUND(J58,2)","v":0},"Dez >=0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"histdatum",{"$f":"DATE(H60,12,31)","v":"1900-12-31"},4,"Typ Datum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"buchwert",{"$f":"ROUND(J60,2)","v":0},"Dez >=0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"notiz",{"$f":"AA122","v":"  "}]

{"sheet":"__Goal_Metadata","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["_KAW999934","J"]
["_KAW999929","786e88bf-4cca-467f-b4d1-e2b1f72bb8a5"]