{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":53,"n_cols":12,"rows_kept":53,"flags":["formulas_cached_only"]}
["Rechenblatt Leistungsbeschreibung / Arbeitszeit / Personalbemessung / Wohngruppe"]
[]
["Berechnung auf das Jahr bezogen, reine Zeitberechnung mit Poolstunden; Dateneingabe in die grau unterlegten Felder"]
[]
[]
[null,"Zu erbringende Zeiten gemäß Leistungsverpflichtung"]
[{"$nulls":8},"Vollarbeit",null,null,"Bereitschaftsdienst    "]
[null,185,"Schul- und Arbeitstage",null,24.25,"Std",4486.25,"Std",12.25,"Std",{"v":8,"d":"8.00"},"Std"]
[null,40,"Schulfreie Arbeitstage",null,{"v":28,"d":"28.00"},"Std",{"v":1120,"d":"1120.00"},"Std",{"v":16,"d":"16.00"},"Std",{"v":8,"d":"8.00"},"Std"]
[null,101,"Schul- und arbeitsfreie Tage",null,{"v":28,"d":"28.00"},"Std",{"v":2828,"d":"2828.00"},"Std",{"v":14.5,"d":"14.50"},"Std",{"v":9.5,"d":"9.50"},"Std"]
[null,39,"Tage X",null,{"v":0,"d":"0.00"},"Std",{"v":0,"d":"0.00"},"Std",{"v":0,"d":"0.00"},"Std",{"v":0,"d":"0.00"},"Std"]
[]
[null,365,"Tage",{"$nulls":3},8434.25,"Std","Poolstunden",null,{"v":4,"d":"4.00"},"Std"]
[]
[{"$nulls":5},"refinanzierte Stunden gemäß Leistungsbeschreibung",8434.25,"Std / Jahr"]
[]
[{"$nulls":4},"davon Vollarbeitszeit",null,5674.75,"Std / Jahr"]
[{"$nulls":4},"davon Bereitschaftsdienst",null,{"v":2759.5,"d":"2759.50"},"Std / Jahr"]
[]
[]
[null,"vorhandene Arbeitszeit"]
[]
[null,38.5,"Std  x",52.1428,"Wochen"," =",{"v":2007.4978,"d":"2007.50"},"Std / Jahr"," tarifliche / vertragliche Arbeitszeit"]
[]
[null,"davon",50,"Tage vergütete Abwesenheit",null," =",{"v":385,"d":"385.00"},"Std  / Jahr"," vergütete Abwesenheitszeiten sind Urlaub, "]
[{"$nulls":8}," unverschuldete Arbeitsversäumnis, Ausgleich "]
[{"$nulls":5},"Anwesenheitszeit (abz. Vergütete Abwesenheit)",{"v":1622.4978,"d":"1622.50"},"Std / Jahr"," für Arbeit an Feiertagen und Vorfesttagen, "]
[]
[]
[{"$nulls":8}," Arbeitszeitverkürzungstag, Fortbildungen,"]
[null,{"v":1622.4978,"d":"1622.50"},"Std / Jahr x",4,"Mitarbeiter"," =",{"v":6489.9912,"d":"6489.99"},"Std / Jahr"," Zeiten anderer Tätigkeiten außerhalb des "]
[{"$nulls":8}," Wohngruppenbereichs"]
[{"$nulls":5},"vorhandene Betreuungszeit (Vollarbeitszeit)",{"v":6489.9912,"d":"6489.99"},"Std / Jahr"]
[{"$nulls":8}," Präsenzzeit des einzelnen Mitarbeiters"]
[null,"vorhandene Bereitschaftsdienstzeiten",{"$nulls":6}," (keine Anrechnung BD auf Vollarbeitszeit)"]
[{"$nulls":8},{"v":2312.3728,"d":"2312.37"},"Std/Jahr"]
[null,{"v":9.5,"d":"9.50"},"Std  x",52.1428,"Wochen"," =",{"v":495.3566,"d":"495.36"},"Std / Jahr",{"v":44.34692421580736,"d":"44.35"},{"v":51.73049395122625,"d":"51.73"}," Ø Std/Woche"]
[null,{"v":495.3566,"d":"495.36"},"Std / Jahr x",4,"Mitarbeiter"," =",{"v":1981.4264,"d":"1981.43"},"Std / Jahr"]
[{"$nulls":8}," Präsenzzeit des einzelnen Mitarbeiters"]
[{"$nulls":5},"vorhandene Betreuungszeit (Bereitschaftsdienst)",{"v":1981.4264,"d":"1981.43"},"Std / Jahr"," (Anrechnung BD auf Vollarbeitszeit)"]
[{"$nulls":8},{"v":2108.5625,"d":"2108.56"},"Std/Jahr"]
[{"$nulls":8},{"v":40.438229247374515,"d":"40.44"}," Ø Std/Woche"]
[{"$nulls":8},{"v":40.438229247374515,"d":"40.44"}," Ø Std/Woche"]
[{"$nulls":5},"vorhandene Betreuungszeit (Vollarbeit+Bereitschaftsdienst)",{"v":8471.4176,"d":"8471.42"},"Std / Jahr",{"v":40.438229247374515,"d":"40.44"},{"v":47.8217989827934,"d":"47.82"}," Ø Std/Woche"]
[]
[]
[{"$nulls":5},"vorhandene Arbeitszeit minus Vorgabezeit",{"v":37.167600000000675,"d":"37.17"},"Std / Jahr","Arbeitszeitüberhang"]
[]
[{"$nulls":5},"davon Vollarbeitszeiten",{"v":815.2412000000004,"d":"815.24"},"Std / Jahr","zu viel","pro MA",{"v":203.8103000000001,"d":"203.81"},"Std"]
[{"$nulls":5},"davon Bereitschaftsdienstzeiten",{"v":-778.0735999999999,"d":"-778.07 "},"Std / Jahr","fehlen","pro MA",{"v":-194.51839999999999,"d":"-194.52 "},"Std"]
[]
[{"$nulls":5},"Umrechnung BD-Zeiten in Vollarbeitszeit",{"v":-194.51839999999999,"d":"-194.52 "},"Std/ Jahr","fehlen","pro MA",{"v":-48.629599999999996,"d":"-48.63 "},"Std"]
[{"$nulls":3},"Verrechnung BD mit Vollarbeitszeit",null,null,{"v":620.7228000000005,"d":"620.72"},"Std / Jahr","zu viel","pro MA",{"v":155.18070000000012,"d":"155.18"},"Std"]