{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["vollstationär","Tabelle2","Tabelle3"],"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":"vollstationär","index":0,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,13],[2,0,2,13],[3,0,3,13],[25,0,25,13]]}
["Heimentgelte"]
[]
["Seniorenbetreuung Herbstblatt Rötz"]
["Stand 01.03.2024"]
[]
[]
["Doppelzimmer"]
["Leistungsart","Tagessatz",null,"Unterkunft","Ver-\npflegung","Ausbildungs-\numlage","Investitions-\nkosten","Tagessatz\nGesamt",null,"monatliche\nTage",null,"monatliche\nGesamtkosten","Zuzahlung\nPflegekasse","monatlicher\nEigenanteil"]
["Pflegegrad 1",58.07,null,11.64,12.91,6.63,18,{"$f":"SUM(B9:G9)","v":107.25},"x",30.42,"=",{"$f":"H9*J9","v":3262.5450000000001},-125,{"$f":"SUM(L9:M9)","v":3137.5450000000001}]
["Pflegegrad 2",72.08,null,11.64,12.91,6.63,18,{"$f":"SUM(B10:G10)","v":121.25999999999999},"x",30.42,"=",{"$f":"H10*J10","v":3688.7291999999998},-770,{"$f":"SUM(L10:M10)","v":2918.7291999999998}]
["Pflegegrad 3",88.26,null,11.64,12.91,6.63,18,{"$f":"SUM(B11:G11)","v":137.44},"x",30.42,"=",{"$f":"H11*J11","v":4180.9247999999998},-1262,2918.9247999999998]
["Pflegegrad 4",105.12,null,11.64,12.91,6.63,18,{"$f":"SUM(B12:G12)","v":154.30000000000001},"x",30.42,"=",4693.8060000000005,-1775,2918.8060000000005]
["Pflegegrad 5",112.68,null,11.64,12.91,6.63,18,{"$f":"SUM(B13:G13)","v":161.86000000000001},"x",30.42,"=",4923.7812000000004,-2005,2918.7812000000004]
[]
[]
[]
["Einzelzimmer"]
["Leistungsart","Tagessatz","EZ-Zuschlag","Unterkunft","Ver-\npflegung","Ausbildungs-\numlage","Investitions-\nkosten","Tagessatz\nGesamt",null,"monatliche\nTage",null,"monatliche\nGesamtkosten","Zuzahlung\nPflegekasse","monatlicher\nEigenanteil"]
["Pflegegrad 1",58.07,7,11.64,12.91,6.63,18,{"$f":"SUM(B19:G19)","v":114.24999999999999},"x",30.42,"=",{"$f":"H19*J19","v":3475.4849999999997},-125,{"$f":"SUM(L19:M19)","v":3350.4849999999997}]
["Pflegegrad 2",72.08,7,11.64,12.91,6.63,18,{"$f":"SUM(B20:G20)","v":128.26},"x",30.42,"=",{"$f":"H20*J20","v":3901.6691999999998},-770,{"$f":"SUM(L20:M20)","v":3131.6691999999998}]
["Pflegegrad 3",88.26,7,11.64,12.91,6.63,18,{"$f":"SUM(B21:G21)","v":144.44},"x",30.42,"=",4393.8648000000003,-1262,3131.8648000000003]
["Pflegegrad 4",105.12,7,11.64,12.91,6.63,18,{"$f":"SUM(B22:G22)","v":161.30000000000001},"x",30.42,"=",4906.746000000001,-1775,3131.746000000001]
["Pflegegrad 5",112.68,7,11.64,12.91,6.63,18,{"$f":"SUM(B23:G23)","v":168.85999999999999},"x",30.42,"=",5136.7212,-2005,3131.7212]
[]
[]
[]
["Dieses Informationsblatt für Heimentgelte enthält die Gesamtkosten für 30,42 Tage."]
[]
[]
["Berechnung einheitlicher EEE (einrichtungseinheitlicher Eigenanteil)"]
[]
["Leistungsart","Tagessatz",null,"monatliche\nTage",null,null,"Gesamt","Zuzahlung\nPflegekasse",null,"monatlicher\nEigenanteil",null,null,null,"täglicher EEE"]
["PG 1",58.07,"x",30.42,"=",null,{"$f":"B33*D33","v":1766.4894000000002},-125,"=",{"$f":"G33+H33","v":1641.4894000000002}]
["PG 2",72.08,"x",30.42,"=",null,{"$f":"B34*D34","v":2192.6736000000001},-770,"=",{"$f":"G34+H34","v":1422.6736000000001},null,"./. 30,42","=",{"$f":"J34/30.42","v":46.767705456936227}]
["PG 3",88.26,"x",30.42,"=",null,{"$f":"B35*D35","v":2684.8692000000001},-1262,"=",{"$f":"G35+H35","v":1422.8692000000001},null,"./. 30,42","=",{"$f":"J35/30.42","v":46.774135437212358}]
["PG 4",105.12,"x",30.42,"=",null,{"$f":"B36*D36","v":3197.7504000000004},-1775,"=",{"$f":"G36+H36","v":1422.7504000000004},null,"./. 30,42","=",46.770230111768583]
["PG 5",112.68,"x",30.42,"=",null,{"$f":"B37*D37","v":3427.7256000000002},-2005,"=",{"$f":"G37+H37","v":1422.7256000000002},null,"./. 30,42","=",46.769414858645632]
[]
["Der einheitliche EEE wurde eingeführt, damit alle Bewohner der Pflegegrade 2-5 den gleichen monatlichen Eigenanteil an den Pflegekosten haben."]
[]
["Zusätzliche Betreuung nach §43b"]
["Pflegegrad","Tagessatz",null,"monatlich",null,null,"Gesamt","Zuzahlung\nPflegekasse",null,"monatlicher\nEigenanteil"]
["PG 1",5.0199999999999996,"x",30.42,"=",null,{"$f":"B43*D43","v":152.70839999999998},-152.71,"=",{"$f":"G43+H43","v":-1.6000000000246928E-3}]
["PG 2",5.0199999999999996,"x",30.42,"=",null,{"$f":"B44*D44","v":152.70839999999998},-152.71,"=",{"$f":"G44+H44","v":-1.6000000000246928E-3}]
["PG 3",5.0199999999999996,"x",30.42,"=",null,{"$f":"B45*D45","v":152.70839999999998},-152.71,"=",{"$f":"G45+H45","v":-1.6000000000246928E-3}]
["PG 4",5.0199999999999996,"x",30.42,"=",null,{"$f":"B46*D46","v":152.70839999999998},-152.71,"=",{"$f":"G46+H46","v":-1.6000000000246928E-3}]
["PG 5",5.0199999999999996,"x",30.42,"=",null,{"$f":"B47*D47","v":152.70839999999998},-152.71,"=",{"$f":"G47+H47","v":-1.6000000000246928E-3}]
[]
[]
[]
["Bei Bewohnern mit Beihilfe trägt einen Teil die Pflegekasse und den anderen Teil die Beihilfe, je nachdem welche Sätze vereinbart sind. In der Regel 50% : 50%"]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}