{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["SAK bankzeit.de","Selbstauskunft","Immobilien","Verbindlichkeiten","Versicherungen"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":3,"defined_names":19,"comments":0,"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":"SAK bankzeit.de","index":0,"n_rows":38,"n_cols":40,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,0,3,9],[10,0,37,0],[14,3,37,35],[35,39,36,53]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Mithilfe dieses Excel-Tools kann eine institutsneutrale Selbstauskunft über Vermögen, Verbindlichkeiten, Einkünfte und Ausgaben erstellt werden. Zu Immobilien, Verbindlichkeiten und Versicherungen gibt es die Möglichkeit noch detailliertere Angaben zu machen, die Rückfragen und damit Zeitverluste zum Beispiel bei einer Kreditanfrage mindern oder entbehrlich machen und die Bearbeitung erleichtern und beschleunigen können.\nHilfreich kann die Unterlage aber auch zur eigenen Übersicht sein, da viele Detailangaben zu Versicherungen, Verbindlichkeiten und Immobilien dort gesammelt werden könnten.\nDie Anwendung sollte selbsterklärend sein: Einfach die relevanten Daten in die Felder eintragen. Bitte darauf achten, dass die Datei auch rechnet, daher die Zahlen ohne Punkte und Striche eingeben (nicht \"1.502,--Euro\" sondern \"1502\") damit sie auch als Zahl und nicht als Text erkannt werden. Zum Navigieren einfach auf die entsprechend gekennzeichneten Symbole klicken. Die Reset-Buttons löschen jeweils die eingegebenen Werte der Seite, der Button auf dieser Seite löscht alle Angaben im ganzen Tool.\n\nTrotz jahrzehntelanger Erfahrung mit der Excel-Anwendung sowie größtmöglicher Sorgfalt, kann bei diesem kosten- und werbefreien Tool natürlich keinerlei Haftung für Vollständigkeit, Richtigkeit, Fehlerfreiheit und Aktualität übernommen werden. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,"Version 1.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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand: März 2021  | www.bankzeit.de | info@bankzeit.de"]

{"sheet":"Selbstauskunft","index":1,"n_rows":74,"n_cols":18,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,16,1,17],[3,16,3,17],[1,11,1,15],[3,11,3,15],[5,1,6,8],[1,2,1,3],[1,4,1,5],[1,6,1,8],[1,9,1,10],[3,2,3,3],[3,4,3,5],[3,6,3,8],[3,9,3,10],[71,2,71,18],[73,2,73,18],[70,2,70,18],[43,16,43,19],[44,16,44,19],[45,16,45,19],[46,16,46,19],[47,16,47,19],[43,3,43,7],[43,9,43,10],[43,12,43,14],[44,3,44,7],[44,9,44,10],[44,12,44,14],[69,2,69,18],[62,12,62,19],[49,3,49,7],[67,9,67,10],[61,12,61,19],[62,9,62,10],[60,12,60,19],[50,16,50,19],[61,3,61,7],[61,9,61,10],[42,3,42,7],[42,9,42,10],[42,12,42,14],[42,16,42,19],[60,9,60,10],[60,3,60,7],[59,3,59,7],[58,3,58,7],[55,9,55,10],[55,12,55,19],[56,9,56,10],[56,12,56,19],[57,9,57,10],[57,12,57,19],[51,16,51,19],[52,3,52,7],[68,12,68,19],[67,3,67,7],[62,3,62,7],[68,3,68,7],[68,9,68,10],[66,3,66,7],[66,12,66,19],[67,12,67,19],[66,9,66,10],[64,12,64,19],[63,3,63,7],[63,9,63,10],[63,12,63,19],[64,9,64,10],[64,3,64,7],[65,9,65,10],[65,12,65,19],[65,3,65,7],[53,2,54,2],[53,9,53,10],[53,12,53,19],[54,9,54,10],[54,12,54,19],[58,9,58,10],[58,12,58,19],[59,9,59,10],[59,12,59,19],[57,3,57,7],[56,3,56,7],[55,3,55,7],[54,3,54,7],[53,3,53,7],[51,12,51,14],[50,3,50,7],[50,9,50,10],[50,12,50,14],[45,3,45,7],[45,9,45,10],[45,12,45,14],[46,3,46,7],[46,9,46,10],[46,12,46,14],[51,3,51,7],[51,9,51,10],[49,16,49,19],[48,3,48,7],[48,9,48,10],[48,12,48,14],[48,16,48,19],[47,3,47,7],[47,9,47,10],[47,12,47,14],[36,9,36,10],[38,3,38,4],[38,5,38,7],[38,9,38,10],[37,8,37,11],[39,8,39,11],[49,9,49,10],[49,12,49,14],[40,3,41,7],[37,12,37,19],[36,12,36,19],[36,3,36,7],[38,12,38,19],[33,3,33,7],[33,9,33,10],[30,3,30,7],[30,9,30,10],[34,12,34,19],[35,3,35,7],[35,9,35,10],[33,12,33,19],[34,3,34,7],[34,9,34,10],[21,2,21,3],[21,4,21,8],[21,10,21,12],[21,13,21,19],[22,2,22,18],[31,3,31,4],[25,3,25,7],[25,9,25,10],[25,12,25,19],[24,2,24,18],[31,5,31,7],[31,12,31,19],[28,3,28,7],[28,9,28,10],[28,12,28,19],[29,9,29,10],[29,12,29,19],[30,12,30,19],[31,8,32,11],[8,2,8,8],[8,10,8,19],[17,2,17,8],[5,9,7,19],[72,2,72,3],[72,4,72,18],[15,6,15,8],[15,17,15,19],[12,6,12,8],[12,17,12,18],[13,2,13,8],[13,10,13,19],[17,10,17,19],[26,3,26,7],[26,9,26,10],[26,12,26,19],[27,3,27,7],[27,9,27,10],[27,12,27,19],[23,2,23,7],[23,9,23,10],[23,12,23,19],[32,12,32,19],[35,12,35,19],[9,2,9,8],[9,10,9,19],[15,10,15,16],[15,2,15,5],[19,2,19,8],[14,4,14,8],[14,13,14,18],[16,10,16,18],[16,2,16,8],[11,2,11,3],[11,4,11,8],[11,10,11,12],[11,13,11,19],[19,10,19,19]]}
["Wirtschaftliche Situation - Privat (Selbstauskunft Unselbständige)"]
[null,null,"Vermögen:  ","Vermögen",{"$f":"J26+J27+J28+J29+J30+J31","v":0},null,"Einkünfte mtl.:  ",null,null,{"$f":"J43+J44+J45+J46+J47+M43+M44+M45+M46+M47-J48-M48","v":0},null,"nach Veränderung",null,null,null,null,{"$f":"J43+J44+J45+J46+J47+M43+M44+M45+M46+M47-J48-M48+J49+M49+J51+M51-J50-M50-J52-M52","v":0}]
[]
[null,null,"Verbindlichkeiten:  ",null,{"$f":"J34+J35+J36+J37","v":0},null,"Ausgaben mtl.:  ",null,null,{"$f":"J54+J55+J56+J57+J58+J59+J60+J61+J62+J63+J64","v":0},null,"nach Veränderung",null,null,null,null,{"$f":"J54+J55+J56+J57+J58+J59+J60+J61+J62+J63+J64+J65-J66+J67+J68+J69","v":0}]
[null,null,null,null,null,null,","]
[null,"  Wirtschaftliche Situation | Selbstauskunft"]
[]
[]
[null,null,"Vor- und Zuname   |  Geburtsname",null,null,null,null,null,null,null,"Vor- und Zuname   |  Geburtsname"]
[]
[null,null,"Geburtsdatum",null,"Staatsangehörigkeit",null,null,null,null,null,"Geburtsdatum",null,null,"Staatsangehörigkeit"]
[]
[null,null,"Anschrift",null,null,null,null,null,null,null,"Anschrift"]
[]
[null,null,"Beruf",null,"angestellt | selbständig *) seit  ",null,null,null,null,null,"Beruf",null,null,"angestellt | selbständig *) seit"]
[]
[null,null,"bei Arbeitgeber | Info zur Selbständigkeit -  z.B. Funktion, Firmenname *)",null,null,null,null,null,null,null,"bei Arbeitgeber | Info zur Selbständigkeit -  z.B. Funktion, Firmenname *)"]
[]
[null,null,"Anzahl | Geburtsdaten der unterhaltsberechtigten Kinder",null,null,null,null,null,null,null,"Anzahl | Geburtsdaten der unterhaltsberechtigten Kinder"]
[]
[null,null,"Familienstand",null,"Güterstand",null,null,null,null,null,"Familienstand",null,null,"Güterstand"]
[]
[null,null,"                           *) Nichtzutreffendes bitte streichen"]
[null,null,null,null,null,null,null,null,null,"Summe",null,null,"Anmerkungen"]
[]
[null,null,"Vermögen","Kontoguthaben (KK, Spar, Termin)"]
[null,null,null,"Wertpapiere (Kurswert)"]
[null,null,null,"Bausparguthaben"]
[null,null,null,"Lebensversicherungen (Rückkaufswert)"]
[null,null,null,"Immobilien (Verkehrswert)"]
[null,null,null,"Andere wichtige Vermögensgegenstände"]
[null,null,null,"Beschreibung:"]
[]
[null,null,"Fremdkapital","Kurzfristige Bankverbindlichkeiten"]
[null,null,null,"Steuerschulden / erwartete Steuernachzahlungen"]
[null,null,null,"Baufinanzierungskredite"]
[null,null,null,"Weitere Verbindlichkeiten (z. B. Ratenkredite)"]
[]
[null,null,"Bürgschaften","Beschreibung:"]
[]
[null,null,"Einkommens-\nsituation","Netto-Einkünfte aktuell monatlich aus:",null,null,null,null,null,"1. Person",null,null,"2. Person",null,null,null,null,"Bemerkungen"]
[]
[null,null,null,"Selbstständige Tätigkeit "]
[null,null,null,"Unselbständige Tätigkeit"]
[null,null,null,"Renten"]
[null,null,null,"Kindergeld"]
[null,null,null,"Vermietung und Verpachtung (ohne Nebenkosten)"]
[null,null,null," ./. Steuern auf alle Bruttoangaben"]
[null,null,"Änderungen","+  Einkommenserhöhung"]
[null,null,null,"./. Einkommensminderung"]
[null,null,null,"+  Kindergeld"]
[null,null,null,"./. Entfall Kindergeld"]
[]
[null,null,"Ausgaben p.a.\nprivat","Miete (kalt)"]
[null,null,null,"Nebenkosten (z. B. Umlagen / Heizung)"]
[null,null,null,"Lebenshaltungskosten"]
[null,null,null,"KFZ-Kosten (inkl. Versicherung und Leasing)"]
[null,null,null,"Lebensversicherungen und Private Altersvorsorge"]
[null,null,null,"Vertraglich festgelegte Spar- und Bausparbeiträge"]
[null,null,null,"Private Kranken- und Sachversicherungen"]
[null,null,null,"Baufinanzierungsraten (inkl. LV als Tilgungsersatz)"]
[null,null,null,"Ratenverpflichtungen (Zins und Tilgung)"]
[null,null,null,"Verpflichtungen aus sonstigen Verbindlichkeiten"]
[null,null,null,"Sonstiges (z.B. Unterhalt)"]
[null,null,"Änderungen","+ Finanzierungsraten (Zins-/Tilgung)"]
[null,null,null,"./. Entfall Miete (kalt)"]
[null,null,null,"+ Studienkosten Kind/er"]
[]
[]
[]
[null,null,"Wir bestätigen die Richtigkeit und Vollständigkeit der oben gemachten Angaben."]
[]
[null,null,{"$f":"TODAY()","v":"2021-03-04"}]
[null,null,"                  Datum                                                         Unterschrift(en)"]

{"sheet":"Immobilien","index":2,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,2,4,2],[3,6,3,7],[32,1,33,4],[32,5,33,5],[32,8,33,8],[39,6,40,7],[39,8,40,8],[32,12,33,12],[1,4,1,5],[1,8,1,12],[32,9,33,9],[32,10,33,10],[32,11,33,11],[37,6,38,7]]}
[null,"SAK "]
[null,"Angaben zum Immobilien-Eigentum",null,null,"Alle Geldbeträge lauten auf TEUR",null,null,"Name:  ",{"$f":"IF(Selbstauskunft!C10=\"\",\"\",Selbstauskunft!C10&\" und \"&Selbstauskunft!K10)","v":""}]
[]
[null," Anschrift\n incl. Band, Blattbezeichnung im\n Grundbuch, Amtsgericht/Grund-","Art *)\n\nBaujahr\n+ Reno-\nvierung","Wohn-/Nutz-\nfläche\nund","\nEigentümer\nund","\nVerkehrs-\nwert","\nGrundschuld(en)",null,"\n\nGläubiger","\nMiete \n(ohne NK)","\nZins","\nTilgung","\nÜberschuß/\nUnterdeckung"]
[null," buchamt gem. beiliegendem\n Grundbuchauszug",null,"Grundstücks-\ngröße","Miteigentumsanteil(e)\nin %",null,"N\nV"," = nominell\n = valutierend",null,"p.a.","p.a.","p.a.","p.a."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J6=\"\",K6=\"\"),\"\",J6-K6-L6)","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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Summen   ",null,null,null,{"$f":"IF(SUM(F6:F32)=0,\"\",SUM(F6:F32))","v":""},"N",{"$f":"IF(SUM(H6:H32)=0,\"\",SUMIF(G6:G32,\"N\",H6:H32))","v":""},"Summen   ",{"$f":"IF(SUM(J6:J32)=0,\"\",SUM(J6:J32))","v":""},{"$f":"IF(SUM(K6:K32)=0,\"\",SUM(K6:K32))","v":""},{"$f":"IF(SUM(L6:L32)=0,\"\",SUM(L6:L32))","v":""},{"$f":"IF(SUM(M6:M32)=0,\"\",SUM(M6:M32))","v":""}]
[null,null,null,null,null,null,"V",{"$f":"IF(SUM(H6:H32)=0,\"\",SUMIF(G6:G32,\"<>N\",H6:H32))","v":""}]
[]
[null,"*) Bitte folgende Abkürzungen verwenden:"]
[null,"   ETW  = Eigentumswohnung",null,"Gr    = Grundstück"]
[null,"   EFH   = Einfamilienhaus",null,"WG  = Wohn- und Geschäftshaus (gemischt genutzt)",null,null,{"$f":"TODAY()","v":"2021-03-04"}]
[null,"   ZFH   = Zweifamilienhaus",null,"G     = Gewerbliches Objekt"]
[null,"   MFH   = Mehrfamilienhaus",null,"F      = Immobilienfonds  (KG - GbR-Beteiligung)",null,null,"Datum",null," Unterschrift"]

{"sheet":"Verbindlichkeiten","index":3,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,14,16,14],[1,7,1,15],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,3,6],[3,7,4,8],[3,9,3,10],[3,11,4,13],[3,14,4,14],[3,15,4,15],[5,14,6,14],[7,14,8,14],[9,14,10,14],[11,14,12,14],[13,14,14,14],[25,1,26,1],[25,2,25,3],[25,11,25,12],[26,2,26,3],[26,11,26,12],[29,2,30,2],[17,14,18,14],[19,14,20,14],[21,14,22,14],[23,14,24,14]]}
[null,"SAK   "]
[null,"Angaben zu Verbindlichkeiten                     (alle Angaben in EURO)",null,null,null,null,"Name:    ",{"$f":"IF(Selbstauskunft!C10=\"\",\"\",Selbstauskunft!C10&\" und \"&Selbstauskunft!K10)","v":""}]
[]
[null,"Verwendungszweck\nggf. Objektbezeichnung","Darlehensgeber\nDarlehens-Nr.","Darlehensbetrag",null,"Z = Zinssatz p.a.",null,"Laufzeit\nvon / bis",null,"Tilgungssatz p.a.",null,"falls zutreffend:\nTilgungsersatz z. B. LV, BSV\nA = Ansparrate (monatlich)\nG = Guthaben/RKW",null,null,"Kapitaldienst\np.a. ohne\nTilgungsersatz","Besicherung"]
[null,null,null,"N\nV"," N = Nominell\n V = Valutierend","Z\nV/F","V = variabel\nF = fest bis",null,null,"A\nE"," A = lfd. Tilgung\n E = endfällig"]
[null,null,null,{"$f":"IF(E6<>\"\",\"N\",\"\")","v":""},null,{"$f":"IF(E6>1,\"Z\",\"\")","v":""},null,{"$f":"IF(E6>1,\"von\",\"\")","v":""},null,{"$f":"IF(E6<>\"\",\"A\",\"\")","v":""},{"$f":"IF(E6=\"\",\"\",IF(J6=\"A\",\"Annuität mtl.:\",\"nur Zinsrate\"))","v":""},{"$f":"IF(OR(J6=\"E\",L7<>\"\"),\"Art:\",\"\")","v":""},{"$f":"IF(L6<>\"\",\"A\",\"\")","v":""},null,{"$f":"IF(OR(E6=\"\",G6=\"\"),\"\",IF(K7<>\"\",(K7*12)/1000,IF(J6=\"E\",(E6*G6/1000),E7/10000)))","v":""}]
[null,null,null,{"$f":"IF(E6<>\"\",\"V\",\"\")","v":""},null,null,null,{"$f":"IF(E6>1,\"bis\",\"\")","v":""},null,{"$f":"IF(K6<>\"\",\"€\",\"\")","v":""},null,null,{"$f":"IF(L6<>\"\",\"G\",\"\")","v":""}]
[null,null,null,{"$f":"IF(E8<>\"\",\"N\",\"\")","v":""},null,{"$f":"IF(E8>1,\"Z\",\"\")","v":""},null,{"$f":"IF(E8>1,\"von\",\"\")","v":""},null,{"$f":"IF(E8<>\"\",\"A\",\"\")","v":""},{"$f":"IF(E8=\"\",\"\",IF(J8=\"A\",\"Annuität mtl.:\",\"nur Zinsrate\"))","v":""},{"$f":"IF(OR(J8=\"E\",L9<>\"\"),\"Art:\",\"\")","v":""},{"$f":"IF(L8<>\"\",\"A\",\"\")","v":""},null,{"$f":"IF(OR(E8=\"\",G8=\"\"),\"\",IF(K9<>\"\",(K9*12)/1000,IF(J8=\"E\",(E8*G8/1000),E9/10000)))","v":""}]
[null,null,null,{"$f":"IF(E8<>\"\",\"V\",\"\")","v":""},null,null,null,{"$f":"IF(E8>1,\"bis\",\"\")","v":""},null,{"$f":"IF(K8<>\"\",\"€\",\"\")","v":""},null,null,{"$f":"IF(L8<>\"\",\"G\",\"\")","v":""}]
[null,null,null,{"$f":"IF(E10<>\"\",\"N\",\"\")","v":""},null,{"$f":"IF(E10>1,\"Z\",\"\")","v":""},null,{"$f":"IF(E10>1,\"von\",\"\")","v":""},null,{"$f":"IF(E10<>\"\",\"A\",\"\")","v":""},{"$f":"IF(E10=\"\",\"\",IF(J10=\"A\",\"Annuität mtl.:\",\"nur Zinsrate\"))","v":""},{"$f":"IF(OR(J10=\"E\",L11<>\"\"),\"Art:\",\"\")","v":""},{"$f":"IF(L10<>\"\",\"A\",\"\")","v":""},null,{"$f":"IF(OR(E10=\"\",G10=\"\"),\"\",IF(K11<>\"\",(K11*12)/1000,IF(J10=\"E\",(E10*G10/1000),E11/10000)))","v":""}]
[null,null,null,{"$f":"IF(E10<>\"\",\"V\",\"\")","v":""},null,null,null,{"$f":"IF(E10>1,\"bis\",\"\")","v":""},null,{"$f":"IF(K10<>\"\",\"€\",\"\")","v":""},null,null,{"$f":"IF(L10<>\"\",\"G\",\"\")","v":""}]
[null,null,null,{"$f":"IF(E12<>\"\",\"N\",\"\")","v":""},null,{"$f":"IF(E12>1,\"Z\",\"\")","v":""},null,{"$f":"IF(E12>1,\"von\",\"\")","v":""},null,{"$f":"IF(E12<>\"\",\"A\",\"\")","v":""},{"$f":"IF(E12=\"\",\"\",IF(J12=\"A\",\"Annuität mtl.:\",\"nur Zinsrate\"))","v":""},{"$f":"IF(OR(J12=\"E\",L13<>\"\"),\"Art:\",\"\")","v":""},{"$f":"IF(L12<>\"\",\"A\",\"\")","v":""},null,{"$f":"IF(OR(E12=\"\",G12=\"\"),\"\",IF(K13<>\"\",(K13*12)/1000,IF(J12=\"E\",(E12*G12/1000),E13/10000)))","v":""}]
[null,null,null,{"$f":"IF(E12<>\"\",\"V\",\"\")","v":""},null,null,null,{"$f":"IF(E12>1,\"bis\",\"\")","v":""},null,{"$f":"IF(K12<>\"\",\"€\",\"\")","v":""},null,null,{"$f":"IF(L12<>\"\",\"G\",\"\")","v":""}]
[null,null,null,{"$f":"IF(E14<>\"\",\"N\",\"\")","v":""},null,{"$f":"IF(E14>1,\"Z\",\"\")","v":""},null,{"$f":"IF(E14>1,\"von\",\"\")","v":""},null,{"$f":"IF(E14<>\"\",\"A\",\"\")","v":""},{"$f":"IF(E14=\"\",\"\",IF(J14=\"A\",\"Annuität mtl.:\",\"nur Zinsrate\"))","v":""},{"$f":"IF(OR(J14=\"E\",L15<>\"\"),\"Art:\",\"\")","v":""},{"$f":"IF(L14<>\"\",\"A\",\"\")","v":""},null,{"$f":"IF(OR(E14=\"\",G14=\"\"),\"\",IF(K15<>\"\",(K15*12)/1000,IF(J14=\"E\",(E14*G14/1000),E15/10000)))","v":""}]
[null,null,null,{"$f":"IF(E14<>\"\",\"V\",\"\")","v":""},null,null,null,{"$f":"IF(E14>1,\"bis\",\"\")","v":""},null,{"$f":"IF(K14<>\"\",\"€\",\"\")","v":""},null,null,{"$f":"IF(L14<>\"\",\"G\",\"\")","v":""}]
[null,null,null,{"$f":"IF(E16<>\"\",\"N\",\"\")","v":""},null,{"$f":"IF(E16>1,\"Z\",\"\")","v":""},null,{"$f":"IF(E16>1,\"von\",\"\")","v":""},null,{"$f":"IF(E16<>\"\",\"A\",\"\")","v":""},{"$f":"IF(E16=\"\",\"\",IF(J16=\"A\",\"Annuität mtl.:\",\"nur Zinsrate\"))","v":""},{"$f":"IF(OR(J16=\"E\",L17<>\"\"),\"Art:\",\"\")","v":""},{"$f":"IF(L16<>\"\",\"A\",\"\")","v":""},null,{"$f":"IF(OR(E16=\"\",G16=\"\"),\"\",IF(K17<>\"\",(K17*12)/1000,IF(J16=\"E\",(E16*G16/1000),E17/10000)))","v":""}]
[null,null,null,{"$f":"IF(E16<>\"\",\"V\",\"\")","v":""},null,null,null,{"$f":"IF(E16>1,\"bis\",\"\")","v":""},null,{"$f":"IF(K16<>\"\",\"€\",\"\")","v":""},null,null,{"$f":"IF(L16<>\"\",\"G\",\"\")","v":""}]
[null,null,null,{"$f":"IF(E18<>\"\",\"N\",\"\")","v":""},null,{"$f":"IF(E18>1,\"Z\",\"\")","v":""},null,{"$f":"IF(E18>1,\"von\",\"\")","v":""},null,{"$f":"IF(E18<>\"\",\"A\",\"\")","v":""},{"$f":"IF(E18=\"\",\"\",IF(J18=\"A\",\"Annuität mtl.:\",\"nur Zinsrate\"))","v":""},{"$f":"IF(OR(J18=\"E\",L19<>\"\"),\"Art:\",\"\")","v":""},{"$f":"IF(L18<>\"\",\"A\",\"\")","v":""},null,{"$f":"IF(OR(E18=\"\",G18=\"\"),\"\",IF(K19<>\"\",(K19*12)/1000,IF(J18=\"E\",(E18*G18/1000),E19/10000)))","v":""}]
[null,null,null,{"$f":"IF(E18<>\"\",\"V\",\"\")","v":""},null,null,null,{"$f":"IF(E18>1,\"bis\",\"\")","v":""},null,{"$f":"IF(K18<>\"\",\"€\",\"\")","v":""},null,null,{"$f":"IF(L18<>\"\",\"G\",\"\")","v":""}]
[null,null,null,{"$f":"IF(E20<>\"\",\"N\",\"\")","v":""},null,{"$f":"IF(E20>1,\"Z\",\"\")","v":""},null,{"$f":"IF(E20>1,\"von\",\"\")","v":""},null,{"$f":"IF(E20<>\"\",\"A\",\"\")","v":""},{"$f":"IF(E20=\"\",\"\",IF(J20=\"A\",\"Annuität mtl.:\",\"nur Zinsrate\"))","v":""},{"$f":"IF(OR(J20=\"E\",L21<>\"\"),\"Art:\",\"\")","v":""},{"$f":"IF(L20<>\"\",\"A\",\"\")","v":""},null,{"$f":"IF(OR(E20=\"\",G20=\"\"),\"\",IF(K21<>\"\",(K21*12)/1000,IF(J20=\"E\",(E20*G20/1000),E21/10000)))","v":""}]
[null,null,null,{"$f":"IF(E20<>\"\",\"V\",\"\")","v":""},null,null,null,{"$f":"IF(E20>1,\"bis\",\"\")","v":""},null,{"$f":"IF(K20<>\"\",\"€\",\"\")","v":""},null,null,{"$f":"IF(L20<>\"\",\"G\",\"\")","v":""}]
[null,null,null,{"$f":"IF(E22<>\"\",\"N\",\"\")","v":""},null,{"$f":"IF(E22>1,\"Z\",\"\")","v":""},null,{"$f":"IF(E22>1,\"von\",\"\")","v":""},null,{"$f":"IF(E22<>\"\",\"A\",\"\")","v":""},{"$f":"IF(E22=\"\",\"\",IF(J22=\"A\",\"Annuität mtl.:\",\"nur Zinsrate\"))","v":""},{"$f":"IF(OR(J22=\"E\",L23<>\"\"),\"Art:\",\"\")","v":""},{"$f":"IF(L22<>\"\",\"A\",\"\")","v":""},null,{"$f":"IF(OR(E22=\"\",G22=\"\"),\"\",IF(K23<>\"\",(K23*12)/1000,IF(J22=\"E\",(E22*G22/1000),E23/10000)))","v":""}]
[null,null,null,{"$f":"IF(E22<>\"\",\"V\",\"\")","v":""},null,null,null,{"$f":"IF(E22>1,\"bis\",\"\")","v":""},null,{"$f":"IF(K22<>\"\",\"€\",\"\")","v":""},null,null,{"$f":"IF(L22<>\"\",\"G\",\"\")","v":""}]
[null,null,null,{"$f":"IF(E24<>\"\",\"N\",\"\")","v":""},null,{"$f":"IF(E24>1,\"Z\",\"\")","v":""},null,{"$f":"IF(E24>1,\"von\",\"\")","v":""},null,{"$f":"IF(E24<>\"\",\"A\",\"\")","v":""},{"$f":"IF(E24=\"\",\"\",IF(J24=\"A\",\"Annuität mtl.:\",\"nur Zinsrate\"))","v":""},{"$f":"IF(OR(J24=\"E\",L25<>\"\"),\"Art:\",\"\")","v":""},{"$f":"IF(L24<>\"\",\"A\",\"\")","v":""},null,{"$f":"IF(OR(E24=\"\",G24=\"\"),\"\",IF(K25<>\"\",(K25*12)/1000,IF(J24=\"E\",(E24*G24/1000),E25/10000)))","v":""}]
[null,null,null,{"$f":"IF(E24<>\"\",\"V\",\"\")","v":""},null,null,null,{"$f":"IF(E24>1,\"bis\",\"\")","v":""},null,{"$f":"IF(K24<>\"\",\"€\",\"\")","v":""},null,null,{"$f":"IF(L24<>\"\",\"G\",\"\")","v":""}]
[null,"Summen   ","Darlehen ursprünglich:",null,{"$f":"IF(E6+E8+E10+E12+E14+E16+E18+E20+E22+E24=0,\"\",E6+E8+E10+E12+E14+E16+E18+E20+E22+E24)","v":""},null,null,null,null,null,null,"Ansparraten p.a.",null,{"$f":"IF(N6+N8+N10+N12+N14+N16+N18+N20+N22+N24=0,\"\",(N6+N8+N10+N12+N14+N16+N18+N20+N22+N24)*12)","v":""},{"$f":"IF(SUM(O6:O25)=0,\"\",SUM(O6:O25))","v":""},"Kapitaldienst p.a."]
[null,null,"Darlehensvaluta:",null,{"$f":"IF(E7+E9+E11+E13+E15+E17+E19+E21+E23+E25=0,\"\",E7+E9+E11+E13+E15+E17+E19+E21+E23+E25)","v":""},null,null,null,null,null,null,"Tilgungsersatz",null,{"$f":"IF(N7+N9+N11+N13+N15+N17+N19+N21+N23+N25=0,\"\",N7+N9+N11+N13+N15+N17+N19+N21+N23+N25)","v":""}]
[]
[]
[null,null,{"$f":"TODAY()","v":"2021-03-04"}]
[]
[null,null,"Datum",null,null,null,"Unterschrift(en)"]

{"sheet":"Versicherungen","index":4,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,7,1,12],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[5,6,6,6],[5,7,6,7],[7,11,8,11],[5,11,6,11],[5,12,6,12],[7,12,8,12],[9,6,10,6],[9,7,10,7],[9,11,10,11],[9,12,10,12],[7,6,8,6],[7,7,8,7],[11,6,12,6],[11,7,12,7],[11,11,12,11],[11,12,12,12],[13,6,14,6],[13,7,14,7],[13,11,14,11],[13,12,14,12],[15,6,16,6],[15,7,16,7],[15,11,16,11],[15,12,16,12],[17,6,18,6],[17,7,18,7],[17,11,18,11],[17,12,18,12],[29,3,30,3],[19,6,20,6],[19,7,20,7],[19,11,20,11],[19,12,20,12],[21,6,22,6],[21,7,22,7],[21,11,22,11],[21,12,22,12],[23,6,24,6],[23,7,24,7],[23,11,24,11],[23,12,24,12],[25,1,26,3]]}
[null,"SAK   "]
[null,"Angaben zu Lebensversicherungen              (alle Angaben in EURO)",null,null,null,null,"Name:    ",{"$f":"IF(Selbstauskunft!C10=\"\",\"\",Selbstauskunft!C10&\" und \"&Selbstauskunft!K10)","v":""}]
[]
[null,"Versicherungsgesellschaft ","Versicherungsnehmer",null,"Versicherungsummen",null,"Berufsunfähigkeit",null,"Abschlußdaten",null," - falls zutreffend -","Beitrag","Rückkaufswert"]
[null,"Versicherungsnummer","VN\nVP","  VN = Versicherungsnehmer\n  VP = Versicherte Person","T\nE","  T = Todesfall \n  E = Erlebensfall","R","R = Rente\n(monatlich)","A\nF"," A = Abschluß\n F = Fälligkeit","abgetreten an","pro Jahr","Nachweis anbei"]
[null,null,{"$f":"IF(D6<>\"\",\"VN\",\"\")","v":""},null,{"$f":"IF(F6<>\"\",\"T\",\"\")","v":""},null,{"$f":"IF(H6<>\"\",\"R\",\"\")","v":""},null,{"$f":"IF(J6<>\"\",\"A\",\"\")","v":""}]
[null,null,{"$f":"IF(D7<>\"\",\"VP\",\"\")","v":""},null,{"$f":"IF(F7<>\"\",\"E\",\"\")","v":""},null,null,null,{"$f":"IF(J7<>\"\",\"F\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F7=\"\",0,F7)","v":0}]
[null,null,{"$f":"IF(D8<>\"\",\"VN\",\"\")","v":""},null,{"$f":"IF(F8<>\"\",\"T\",\"\")","v":""},null,{"$f":"IF(H8<>\"\",\"R\",\"\")","v":""},null,{"$f":"IF(J8<>\"\",\"A\",\"\")","v":""}]
[null,null,{"$f":"IF(D9<>\"\",\"VP\",\"\")","v":""},null,{"$f":"IF(F9<>\"\",\"E\",\"\")","v":""},null,null,null,{"$f":"IF(J9<>\"\",\"F\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F9=\"\",0,F9)","v":0}]
[null,null,{"$f":"IF(D10<>\"\",\"VN\",\"\")","v":""},null,{"$f":"IF(F10<>\"\",\"T\",\"\")","v":""},null,{"$f":"IF(H10<>\"\",\"R\",\"\")","v":""},null,{"$f":"IF(J10<>\"\",\"A\",\"\")","v":""}]
[null,null,{"$f":"IF(D11<>\"\",\"VP\",\"\")","v":""},null,{"$f":"IF(F11<>\"\",\"E\",\"\")","v":""},null,null,null,{"$f":"IF(J11<>\"\",\"F\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F11=\"\",0,F11)","v":0}]
[null,null,{"$f":"IF(D12<>\"\",\"VN\",\"\")","v":""},null,{"$f":"IF(F12<>\"\",\"T\",\"\")","v":""},null,{"$f":"IF(H12<>\"\",\"R\",\"\")","v":""},null,{"$f":"IF(J12<>\"\",\"A\",\"\")","v":""}]
[null,null,{"$f":"IF(D13<>\"\",\"VP\",\"\")","v":""},null,{"$f":"IF(F13<>\"\",\"E\",\"\")","v":""},null,null,null,{"$f":"IF(J13<>\"\",\"F\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F13=\"\",0,F13)","v":0}]
[null,null,{"$f":"IF(D14<>\"\",\"VN\",\"\")","v":""},null,{"$f":"IF(F14<>\"\",\"T\",\"\")","v":""},null,{"$f":"IF(H14<>\"\",\"R\",\"\")","v":""},null,{"$f":"IF(J14<>\"\",\"A\",\"\")","v":""}]
[null,null,{"$f":"IF(D15<>\"\",\"VP\",\"\")","v":""},null,{"$f":"IF(F15<>\"\",\"E\",\"\")","v":""},null,null,null,{"$f":"IF(J15<>\"\",\"F\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F15=\"\",0,F15)","v":0}]
[null,null,{"$f":"IF(D16<>\"\",\"VN\",\"\")","v":""},null,{"$f":"IF(F16<>\"\",\"T\",\"\")","v":""},null,{"$f":"IF(H16<>\"\",\"R\",\"\")","v":""},null,{"$f":"IF(J16<>\"\",\"A\",\"\")","v":""}]
[null,null,{"$f":"IF(D17<>\"\",\"VP\",\"\")","v":""},null,{"$f":"IF(F17<>\"\",\"E\",\"\")","v":""},null,null,null,{"$f":"IF(J17<>\"\",\"F\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F17=\"\",0,F17)","v":0}]
[null,null,{"$f":"IF(D18<>\"\",\"VN\",\"\")","v":""},null,{"$f":"IF(F18<>\"\",\"T\",\"\")","v":""},null,{"$f":"IF(H18<>\"\",\"R\",\"\")","v":""},null,{"$f":"IF(J18<>\"\",\"A\",\"\")","v":""}]
[null,null,{"$f":"IF(D19<>\"\",\"VP\",\"\")","v":""},null,{"$f":"IF(F19<>\"\",\"E\",\"\")","v":""},null,null,null,{"$f":"IF(J19<>\"\",\"F\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F19=\"\",0,F19)","v":0}]
[null,null,{"$f":"IF(D20<>\"\",\"VN\",\"\")","v":""},null,{"$f":"IF(F20<>\"\",\"T\",\"\")","v":""},null,{"$f":"IF(H20<>\"\",\"R\",\"\")","v":""},null,{"$f":"IF(J20<>\"\",\"A\",\"\")","v":""}]
[null,null,{"$f":"IF(D21<>\"\",\"VP\",\"\")","v":""},null,{"$f":"IF(F21<>\"\",\"E\",\"\")","v":""},null,null,null,{"$f":"IF(J21<>\"\",\"F\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F21=\"\",0,F21)","v":0}]
[null,null,{"$f":"IF(D22<>\"\",\"VN\",\"\")","v":""},null,{"$f":"IF(F22<>\"\",\"T\",\"\")","v":""},null,{"$f":"IF(H22<>\"\",\"R\",\"\")","v":""},null,{"$f":"IF(J22<>\"\",\"A\",\"\")","v":""}]
[null,null,{"$f":"IF(D23<>\"\",\"VP\",\"\")","v":""},null,{"$f":"IF(F23<>\"\",\"E\",\"\")","v":""},null,null,null,{"$f":"IF(J23<>\"\",\"F\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F23=\"\",0,F23)","v":0}]
[null,null,{"$f":"IF(D24<>\"\",\"VN\",\"\")","v":""},null,{"$f":"IF(F24<>\"\",\"T\",\"\")","v":""},null,{"$f":"IF(H24<>\"\",\"R\",\"\")","v":""},null,{"$f":"IF(J24<>\"\",\"A\",\"\")","v":""}]
[null,null,{"$f":"IF(D25<>\"\",\"VP\",\"\")","v":""},null,{"$f":"IF(F25<>\"\",\"E\",\"\")","v":""},null,null,null,{"$f":"IF(J25<>\"\",\"F\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F25=\"\",0,F25)","v":0}]
[null,"Summen   ",null,null,"T",{"$f":"IF(F6+F8+F10+F12+F14+F16+F18+F20+F22+F24=0,\"\",F6+F8+F10+F12+F14+F16+F18+F20+F22+F24)","v":""},"R",{"$f":"IF(H6+H8+H10+H12+H14+H16+H18+H20+H22+H24=0,\"\",H6+H8+H10+H12+H14+H16+H18+H20+H22+H24)","v":""},null,null,"",{"$f":"IF(SUM(L6:L25)=0,\"\",SUM(L6:L25))","v":""},{"$f":"IF(SUM(M6:M25)=0,\"\",SUM(M6:M25))","v":""}]
[null,null,null,null,"E",{"$f":"IF(SUM(O7:O25)=0,\"\",SUM(O7:O25))","v":""}]
[]
[]
[null,null,null,{"$f":"TODAY()","v":"2021-03-04"}]
[]
[null,null,null,"       Datum",null,null,null,"Unterschrift(en)"]