{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["LohnGehalt","__Goal_Metadata"],"not_rendered":{"charts":0,"images":1,"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":"LohnGehalt","index":0,"n_rows":170,"n_cols":35,"rows_kept":170,"cut":false,"hidden":false,"merged":[[39,7,39,10],[41,7,41,10],[37,7,37,10],[15,6,15,10],[19,4,19,10],[20,4,20,10],[21,4,21,10],[22,4,22,10],[23,4,23,10],[35,7,35,10]]}
["V=7.3;ID=20000;Typ=ALOHN"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Private Finanz- und Vermögensplanung"]
[null,null,null,"Lohn/Gehalt"]
[]
[]
[null,null,null,"Allgemeine Angaben"]
[]
[null,null,null,null,"Erstellt von:"]
[]
[null,null,null,null,"Anmerkungen:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Angaben zum Lohn/Gehalt"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Bezeichnung"]
[]
[null,null,null,null,"Arbeitgeber"]
[]
[null,null,null,null,"Personalnummer"]
[]
[null,null,null,null,"Beschäftigungsbeginn (tt.mm.jjjj)"]
[]
[null,null,null,null,"Angaben zu Zahlungen ab (mm.jjjj)"]
[]
[null,null,null,null,"Nettoentgelt",null,null,"monatlich",null,null,"€"]
[]
[null,null,null,null,"Betrag sozialversichungspflichtiges Bruttoentgelt",null,null,"monatlich",null,null,"€"]
[]
[null,null,null,null,"Beitrag gesetzliche Rentenversicherung",null,null,"monatlich",null,null,"€"]
[]
[null,null,null,null,"Andere gesetzliche Sozialabgaben",null,null,"monatlich",null,null,"€"]
[]
[null,null,null,null,"Zuschuss zur privaten Kranken-/Pflegeversicherung",null,null,"monatlich",null,null,"€"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doppelhaushälfte","DOPPEL",null,null,"Eigennutzung","EIGENNUTZ",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,"Geschäftsgrundstück","GESCHGR",null,null,"Vermietung","VERMIET",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,"Eigentumswohnung","WOHNUNG",null,null,"gemischte Nutzung","MISCHNUTZ",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,"Mehrfamilienhaus","MEHRFAM",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,"Einfamilienhaus","EINFAM",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,"Reihenhaus","REIHEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferienhaus/-wohnung","FERIEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sonstiges bebautes Grundstück","SONBEB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gemischt genutztes Grundstück","MISCHGR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unbebautes Grundstück","UNBEBAU"]
[]
[]
[]
[]
[null,null,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,"bez",{"$f":"TEXT(H36,\"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,"vom",{"$f":"H42","v":"00:00:00"},">=1900"]
[null,null,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(J44)","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(J44)","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,"_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,"einnahmen",{"$f":"ROUND(J46,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,"_TurnusAfastsvlohn","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,"afastsvlohn",{"$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,"_TurnusEinnahmenfrei","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,"einnahmenfrei",{"$f":"ROUND(J50,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,"_TurnusAusgabenst","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,"ausgabenst",{"$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,"_TurnusZuschuss","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,"zuschuss",{"$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,"notiz",{"$f":"AA122","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,"strasse",{"$f":"TEXT(H38,\"standard\")","v":"0"},"0-36","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(H40,\"standard\")","v":"0"},"0-20","Typ Text"]

{"sheet":"__Goal_Metadata","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["_KAW999934","J"]
["_KAW999929","09e4b7f0-f964-4aa3-b162-71a57c8e08e8"]