{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Kapitalschulden","__Goal_Metadata"],"not_rendered":{"charts":0,"images":6,"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":"Kapitalschulden","index":0,"n_rows":177,"n_cols":35,"rows_kept":177,"cut":false,"hidden":false,"merged":[[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],[47,7,47,10],[43,7,43,10],[45,7,45,10],[41,7,41,10],[37,7,37,10],[39,7,39,10]]}
["V=7.4C;ID=20000;Typ=KAPSC"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Private Finanz- und Vermögensplanung"]
[null,null,null,"Kredit"]
[]
[]
[null,null,null,"Allgemeine Angaben"]
[]
[null,null,null,null,"Erstellt von:"]
[]
[null,null,null,null,"Anmerkungen, z.B. zu Schuldnern oder Kreditsicherheiten:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"\"Angaben zum \" &D11","v":"Angaben zum Kredit"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Art des Kredits"]
[]
[null,null,null,null,"Bezeichnung"]
[]
[null,null,null,null,"Bank/Bausparkasse; Sitz"]
[]
[null,null,null,null,"Bankleitzahl"]
[]
[null,null,null,null,"Nachname"]
[]
[null,null,null,null,"Vorname"]
[]
[null,null,null,null,"Vertrags-/Kontonummer"]
[]
[null,null,null,null,"Tilgungsweise"]
[]
[null,null,null,null,"Laufzeitbeginn (tt.mm.jjjj)"]
[]
[null,null,null,null,"Fälligkeitsdatum (tt.mm.jjjj)"]
[]
[null,null,null,null,"Zinsfestschreibungsablauf (tt.mm.jjjj)"]
[]
[null,null,null,null,"Disagio",null,null,null,null,null,"€"]
[]
[null,null,null,null,"Kredit-/Dispositionsrahmen",null,null,null,null,null,"€"]
[]
[null,null,null,null,"Kreditbetrag",null,null,null,null,null,"€"]
[]
[null,null,null,null,"Tilgungs-/Gebührensatz jährlich",null,null,null,null,null,"%"]
[]
[null,null,null,null,"Tilgungsbetrag",null,"Zahlungsturnus",null,null,null,"€"]
[]
[null,null,null,null,"Nominalzins jährlich",null,null,null,null,null,"%"]
[]
[null,null,null,null,"Zinsbetrag",null,"Zahlungsturnus",null,null,null,"€"]
[]
[null,null,null,null,"Laufende Nebenkosten",null,"Zahlungsturnus",null,null,null,"€"]
[]
[null,null,null,null,"Restschuld 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,"Arbeitgeberdarlehen","ARBG",null,null,"Steigende Tilgungsraten (Annuitätendarlehen)","STEIGEND",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,"Policendarlehen","POLIC",null,null,"Konstante Tilgungsraten (Tilgungsdarlehen)","KONSTANT",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,"Bauspardarlehen","BAUSP",null,null,"Tilgungsaussetzung","AUSSETZ",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,"Rahmenkredit","RAHM",null,null,"Unregelmäßige Tilgungsraten","UNREGEL",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,"Hypotheken-/Grundschulddarlehen","HYPOS",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,"Raten-/Teilzahlungskredit","RATE"]
[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,"Lombardkredit","LOMB"]
[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,"Sonstiger Kredit","SONK"]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"artkapschuld","ARBG","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,"blz",{"$f":"TEXT(H42,\"standard\")","v":"0"},"0-99999999","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,"nachname",{"$f":"TEXT(H44,\"standard\")","v":"0"},"0-30","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,"vorname",{"$f":"TEXT(H46,\"standard\")","v":"0"},"0-30","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(H48,\"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,"tilgweise","STEIGEND","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,"vom",{"$f":"J52","v":"00:00:00"},"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":"J54","v":"00:00:00"},"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,"laufende",{"$f":"J56","v":"00:00:00"},"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,"vertrsumme",{"$f":"ROUND(J58,2)","v":0},"Dez >=0","Typ Zahl"]
[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(J60,2)","v":0},"Dez >=0","Typ Zahl"]
[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(J52)","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(J52)","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,"_TurnusSparbetrag","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,"sparbetrag",{"$f":"ROUND(J62,2)","v":0},"Dez >=0","Typ Zahl"]
[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,"tilgungssatz",{"$f":"ROUND(J64,2)","v":0},"Dez>=0","Typ Zahl"]
[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,"tilgung",{"$f":"ROUND(J66,2)","v":0},"Dez>=0","Typ Zahl"]
[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,"_TurnusTilgung","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,"nominalzins",{"$f":"ROUND(J68,2)","v":0},"Dez>=0","Typ Zahl"]
[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,"einnahmen",{"$f":"ROUND(J70,2)","v":0},"Dez>=0","Typ Zahl"]
[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,"_TurnusEinnahmen","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,"ausgaben",{"$f":"ROUND(J72,2)","v":0},"Dez>=0","Typ Zahl"]
[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,"_TurnusAusgaben","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,"histdatum",{"$f":"DATE(H74,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(J74,2)","v":0},"Dez>=0","Typ Zahl"]
[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","fccf2c2b-ede3-41ca-b075-b6b05f5aa3a5"]