{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Eingabe Daten","Berechnung"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Eingabe Daten","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Vereinfachte Berechnung des Anspruchs auf EL"]
["Eingabe Daten"]
[null,null,"Bitte diese Felder gemäss Angabe ausfüllen"]
["Name:"]
["Vorname:"]
[]
["Monatliches Einkommen aller Familienangehörigen"]
["Anzahl Familienangehöriger"]
[]
["Bitte Ihre weiteren Daten bei der richtigen Anzahl Personen eintragen:"]
[null,"1 Person","2 Personen","3 Personen","4 Personen"]
["Krankenkassenprämien (Summe aller Personen)"]
["Effektiver Mietzins"]
[]
["Wie hoch ihr wahrscheinlicher Anspruch auf EL ist: 1)",{"$f":"Berechnung!B16","v":1675},{"$f":"Berechnung!C16","v":2512.5},{"$f":"Berechnung!D16","v":3127.5},{"$f":"Berechnung!E16","v":3742.5}]

{"sheet":"Berechnung","index":1,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Vereinfachte Berechnung des Anspruchs auf EL"]
["Berechnungen"]
[{"$nulls":7},"Übernommene Daten aus der Dateneingabe."]
[null,"1PHH","2PHH","3PHH","4PHH"]
["Lebensbedarf",{"$f":"20100/12","v":1675},{"$f":"30150/12","v":2512.5},{"$f":"37530/12","v":3127.5},{"$f":"44910/12","v":3742.5},null,"renten-und-beitraege-01012024.pdf"]
["Miete1",{"$f":"1465","v":1465},{"$f":"1735","v":1735},{"$f":"1925","v":1925},{"$f":"2100","v":2100},null,"Anrechnung der Mietkosten in den Ergänzungsleistungen (admin.ch)"]
["Miete2",{"$f":"1295","v":1295},{"$f":"1565","v":1565},{"$f":"1725","v":1725},{"$f":"1865","v":1865}]
["KK Prämine",{"$f":"'Eingabe Daten'!B12","v":0},{"$f":"'Eingabe Daten'!C12","v":0},{"$f":"'Eingabe Daten'!D12","v":0},{"$f":"'Eingabe Daten'!E12","v":0}]
["EL Anspruch/Jahr 1",{"$f":"B5+B6+B8","v":3140},{"$f":"C5+C6+C8","v":4247.5},5052.5,5842.5]
["EL Anspruch/Jahr 2",{"$f":"B5+B7+B8","v":2970},{"$f":"C5+C7+C8","v":4077.5},4852.5,5607.5]
[]
["Effektiver Mietzins",{"$f":"'Eingabe Daten'!B13","v":0},{"$f":"'Eingabe Daten'!C13","v":0},{"$f":"'Eingabe Daten'!D13","v":0},{"$f":"'Eingabe Daten'!E13","v":0}]
[]
["Anspruch EL",{"$f":"B5+B8+B12","v":1675},{"$f":"C5+C8+C12","v":2512.5},{"$f":"D5+D8+D12","v":3127.5},{"$f":"E5+E8+E12","v":3742.5}]
[]
["Anspruchprüfung",{"$f":"B14-'Eingabe Daten'!B7","v":1675},{"$f":"C14-'Eingabe Daten'!B7","v":2512.5},{"$f":"D14-'Eingabe Daten'!B7","v":3127.5},{"$f":"E14-'Eingabe Daten'!B7","v":3742.5}]
{"$rows_empty":16}
["Lebensbedarf:","Ergänzungsleistungen EL (admin.ch)"]
["Miete:","Anrechnung der Mietkosten in den Ergänzungsleistungen (admin.ch)"]