{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Zeit","Arbeitszeit"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"Zeit","index":0,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,1,27,2],[15,6,19,10],[20,6,20,10],[23,1,23,10],[24,1,24,2],[21,1,21,8],[21,9,21,10],[5,3,5,10],[0,0,0,10],[1,0,1,10],[2,6,2,10],[2,0,2,5],[4,6,4,7],[4,8,4,10],[3,0,3,5],[4,1,4,5],[3,6,3,10],[32,1,32,10],[28,9,28,10],[29,1,29,8],[30,1,30,8],[31,1,31,10],[28,1,28,8],[11,6,11,10],[6,6,10,10],[25,1,25,2],[26,1,26,2],[12,1,12,8],[12,9,12,10],[14,1,14,2],[14,3,14,10]]}
["Ermittlung des Personalbedarfs im Gruppendienst Einrichtungen der Erziehungshilfe\nnach § 45 Sozialgesetzbuch VIII"]
["Hinweis: Dieses Rechenschema eignet sich nur zur Ermittlung des Personalbedarfs für jeweils eine Gruppe.\nGruppen mit unterschiedlichen Öffnungszeiten müssen daher jeweils getrennt berechnet werden.\nUhrzeiten sind im Format hh:mm einzugeben."]
["  Name der Einrichtung\n",null,null,null,null,null,"  Abteilung / Gruppe"]
[]
[" 1."," Ermittlung der Betreuungszeiten",null,null,null,null,"Datum"]
[" 1.1","Schultage (durchschnittlich 186 Tage)"]
[null,"von\n(Uhrzeit)","bis\n(Uhrzeit)","= Stunden","x Anzahl\nder Betreuer","= Betreuungsstunden"]
[null,null,null,{"$f":"ROUND((C8-B8)*24*60,0)/60/24","v":0},null,{"$f":"ROUND((C8-B8)*E8*24*60,0)/60/24","v":0}]
[null,null,null,{"$f":"ROUND((C9-B9)*24*60,0)/60/24","v":0},null,{"$f":"ROUND((C9-B9)*E9*24*60,0)/60/24","v":0}]
[null,null,null,{"$f":"ROUND((C10-B10)*24*60,0)/60/24","v":0},null,{"$f":"ROUND((C10-B10)*E10*24*60,0)/60/24","v":0}]
[null,null,null,{"$f":"ROUND((C11-B11)*24*60,0)/60/24","v":0},null,{"$f":"ROUND((C11-B11)*E11*24*60,0)/60/24","v":0}]
[1,null,null,{"$f":"A12-B12+C12","v":1},null,{"$f":"ROUND((D12/4*E12)*24*60,0)/60/24","v":0},"Nachtbereitschaft = 1/4 Arbeitszeit"]
[null,null,null,null,null,null,null,null,null," Summe 1.1"]
[null,"Betreuungsstunden an Schultagen",null,null,"Summe",{"$f":"SUM(F8:F12)","v":0},"x",null,"Tage = ",{"$f":"ROUND((F14*H14)*24*60,0)/60/24","v":0},"Std. "]
[" 1.2"," schulfreie Tage"]
[null,"von\n(Uhrzeit)","bis\n(Uhrzeit)","= Stunden","x Anzahl\nder Betreuer","= Betreuungsstunden"]
[null,null,null,{"$f":"ROUND((C17-B17)*24*60,0)/60/24","v":0},null,{"$f":"ROUND((C17-B17)*E17*24*60,0)/60/24","v":0}]
[null,null,null,{"$f":"ROUND((C18-B18)*24*60,0)/60/24","v":0},null,{"$f":"ROUND((C18-B18)*E18*24*60,0)/60/24","v":0}]
[null,null,null,{"$f":"ROUND((C19-B19)*24*60,0)/60/24","v":0},null,{"$f":"ROUND((C19-B19)*E19*24*60,0)/60/24","v":0}]
[null,null,null,{"$f":"ROUND((C20-B20)*24*60,0)/60/24","v":0},null,{"$f":"ROUND((C20-B20)*E20*24*60,0)/60/24","v":0}]
[1,null,null,{"$f":"A21-B21+C21","v":1},null,{"$f":"ROUND((D21/4*E21)*24*60,0)/60/24","v":0},"Nachtbereitschaft = 1/4 Arbeitszeit"]
[null,null,null,null,null,null,null,null,null," Summe 1.2"]
[null,"Betreuungsstunden an schulfreien Tagen.",null,null,"Summe",{"$f":"SUM(F17:F21)","v":0},"x",null,"Tage = ",{"$f":"ROUND((F23*H23)*24*60,0)/60/24","v":0},"Std. "]
["1.3"," Tage mit anderem Betreuungsbedarf"]
[null,"Art des Betreuungsbedarfs",null,"= Summe der\ntäglichen Betreuungsstunden","x Anzahl\nder Betreuer","= Betreuungsstunden"]
[null,null,null,null,null,{"$f":"ROUND((D26*E26)*24*60,0)/60/24","v":0},"x",null,"Tage = ",{"$f":"ROUND((F26*H26)*24*60,0)/60/24","v":0},"Std. "]
[null,null,null,null,null,{"$f":"ROUND((D27*E27)*24*60,0)/60/24","v":0},"x",null,"Tage = ",{"$f":"ROUND((F27*H27)*24*60,0)/60/24","v":0},"Std. "]
[null,null,null,null,null,{"$f":"ROUND((D28*E28)*24*60,0)/60/24","v":0},"x",null,"Tage = ",{"$f":"ROUND((F28*H28)*24*60,0)/60/24","v":0},"Std. "]
[null,null,null,null,null,null,null,null,null," Summe 1.3"]
[null,"Betreuungsstunden an Tagen mit anderem Betreuungsbedarf",null,null,null,null,null,null,null,{"$f":"ROUND((SUM(J26:J28))*24*60,0)/60/24","v":0},"Std. "]
["1.4"," Jährliche Betreuungsstunden pro Gruppe laut Nrn. 1.1 - 1.3:",null,null,null,null,null,null,null,{"$f":"ROUND((J14+J23+J30)*24*60,0)/60/24","v":0},"Std. "]
[null,"Erläuterungen"]

{"sheet":"Arbeitszeit","index":1,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,9,30,10],[30,2,30,8],[25,2,26,8],[25,9,26,9],[25,10,26,10],[27,2,27,8],[28,2,28,8],[29,2,29,8],[24,3,24,8],[3,7,3,8],[3,0,3,6],[5,2,5,10],[18,3,18,8],[14,9,15,9],[4,1,4,10],[23,2,23,8],[14,10,15,10],[19,2,20,8],[19,9,20,9],[19,10,20,10],[22,2,22,8],[16,2,16,8],[17,2,17,8],[21,2,21,8],[0,0,0,10],[2,0,2,6],[11,3,11,8],[12,3,12,8],[6,3,6,8],[7,3,7,8],[1,0,1,6],[10,2,10,8],[13,3,13,8],[14,2,15,8],[2,7,2,10],[1,7,1,10],[3,9,3,10],[8,2,8,8],[9,1,9,8]]}
[{"$f":"Zeit!A1","v":"Ermittlung des Personalbedarfs im Gruppendienst Einrichtungen der Erziehungshilfe\nnach § 45 Sozialgesetzbuch VIII"}]
["  Name der Einrichtung\n",null,null,null,null,null,null,"  Abteilung / Gruppe"]
[{"$f":"Zeit!A4","v":0},null,null,null,null,null,null,{"$f":"Zeit!G4","v":0}]
[null,null,null,null,null,null,null,"Datum",null,{"$f":"Zeit!I5","v":"00:00:00"}]
[" 2."," Berechnung der Jahresarbeitszeit von Fachkräften"]
[" 2.1","a)","Tarifliche Wochenarbeitszeit für Fachkräfte"]
[null,null,1.625,"Tarifliche Wochenarbeitszeit in Stunden:Minuten"]
[null,null,{"$f":"(C7/5)","v":0.32500000000000001},"Arbeitszeit pro Tag in Stunden:Minuten"]
[null,"b)","Bruttoarbeitszeit pro Jahr (Stunden:Minuten)",null,null,null,null,null,null,{"$f":"C7*52+C8","v":84.825000000000003},"Std. "]
["2.2","Von der Bruttoarbeitszeit abzusetzende Zeiten"]
[null,"a)","Feiertage, Urlaubstage und Fortbildung"]
[null,null,11,"Feiertage x Arbeitszeit pro Tag",null,null,null,null,null,{"$f":"ROUND(C12*60,2)/60*C8","v":3.5750000000000002},"Std. "]
[null,null,29,"Urlaubstage+  2  Tage * = 31 Tage x Arbeitszeit pro Tag\n(* = Weihnachten und Silvester)",null,null,null,null,null,{"$f":"ROUND((C13+2)*60,2)/60*C8","v":10.075000000000001},"Std. "]
[null,null,5," Tage für Fortbildung x Arbeitszeit pro Tag",null,null,null,null,null,{"$f":"ROUND(C14*60,2)/60*C8","v":1.625},"Std. "]
[null,null,"Zwischensumme Nr. 2.2 a",null,null,null,null,null,null,{"$f":"J9-J12-J13-J14","v":69.55},"Std. "]
[]
[null,"b)","Krankheitszeiten"]
[null,null,"Nicht vorhersehbare Ausfallzeiten, z. B. wegen Krankheit, Kur, etc."]
[null,null,3,"% aus der Zwischensumme Nr. 2.2.a für Fachkräfte",null,null,null,null,null,{"$f":"J15*C19/100","v":2.0864999999999996},"Std. "]
[null,null,"Zwischensumme Nr. 2.2 b",null,null,null,null,null,null,{"$f":"ROUND((J15-J19)*24*60,0)/60/24","v":67.46319444444444},"Std. "]
[]
[null,"c)","Verfügungszeit"]
[null,null,"Individuelle Arbeitszeiten für die Gruppe, wie z. B. Zeit für Konferenzen, Praxisberatung,"]
[null,null,"Vor- und Nachbereitung, Berichtsführung, Supervision, Kontakte zu Eltern und anderen Stellen"]
[null,null,0.125,"Stunden x (Zwischensumme aus Nr. 2.2. b : Wochenarbeitszeit) für Fachkräfte",null,null,null,null,null,{"$f":"ROUND(C25*60,2)/60*(J20/C7)","v":5.1894764957264954},"Std. "]
[null,null," Jährliche Nettoarbeitsstunden je Fachkraft im Gruppendienst",null,null,null,null,null,null,{"$f":"J20-J25","v":62.273717948717945},"Std. "]
[]
[" 2.3",null," Personalbedarf im Gruppendienst"]
[null,null,"Jährliche Betreuungsstunden pro Gruppe (Ansatz aus Nr. 1.4)",null,null,null,null,null,null,{"$f":"Zeit!J31","v":0},"Std. "]
[null,null,"Jährliche Nettoarbeitsstunden je Fachkraft im Gruppendienst aus Nr. 2.2",null,null,null,null,null,null,{"$f":"J26","v":62.273717948717945},"Std. "]
[null,null,"Erforderliche Planstellen",null,null,null,null,null,null,{"$f":"J29/J30","v":0}]