{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Erläuterungen","Datenblatt","01.12.","Januar","Februar","01.03.","April","Mai","01.06.","Juli","August","01.09.","Oktober","November","Dezember","Stichtage ","Monatsstatistik ","Personalstunden","Jahresdurchschnitt"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":28,"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":"Erläuterungen","index":0,"n_rows":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Ziel der Datei: "]
[null,null,"Die Datei unterstützt den Träger, das Personalvolumen unabhängig der Stichtage zur Personalbemessung unter Ausschöpfung des Dispositionsspielraums nach § 2 KitaPersV einzusetzen. Mit der Anwendung dieser Excel-Datei lässt sich durch Eingabe der stichtagsrelevanten Daten (Anzahl Kinder, Betreuungsumfänge, Alter) das quartalsbezogene Personalvolumen ermitteln und durch Verteilung der Gesamt-Personalstundenmenge auf die relevanten pädagogischen Fachkräfte der Personaleinsatz den Anforderungen entsprechend steuern. Damit soll ein ressourcenorientierter und bedarfsgerechter Einsatz sowie ein Einsatz der verfügbaren Personalmenge zur Abfederung von Personalengpässen erreicht werden. "]
[null,null,"In Ergänzung dazu lassen sich - sofern für die Kita zutreffend - Sonderprogramme (Bundes- oder Landesprogramme), mit denen ergänzend auch Personalmittel finanziert werden, übersichtlich verwalten sowie bestimmte Daten aus Auswertungen ablesen. "]
[]
[null,null,"Die Ziellerreichung setzt voraus, dass   \na. das Instrument zur Personalsteuerung pro individueller Kindertagesstätte verstanden wird\nb. der Träger sein finanzaniertes Personal in einer Jahresbetrachtung und unter Ausschöpfung des verfügbaren Korridors von 5 bis maximal 10% der Personalmenge einsetzt und im Jahresmittel ausgleicht \nc. die konkrete Dienstplangestaltung in der Kindertagesstätte in Abstimmung mit dem Träger nach der Festlegung über dieses Instrument erfolgt.  \n"]
[null,"Erläuterungen zu Funktionen: "]
[null,null,"1. Reiter Datenblatt:"]
[null,null,"Schalter zum Blattschutz und zum Ein- bzw. Ausblenden der Monatsblätter: "]
[null,null,"Der Blattschutz wird ausschließlich für grundsätzliche Anpassungen (Personalschlüsselanpassungen, neue Vorlage für das kommende Jahr, usw.) durch das MBJS genutzt."]
[]
[null,null,"Sollte sich der Personalschlüssel unterjährig verändern, so kann dieser auf dem entsprechenden Monatsreiter durch Benutzung des Schalters „Zellschutz für Personalschlüssel aufheben“ erfolgen. "]
[]
[null,null,"Das Einblenden weiterer Monatsblätter (es erscheinen weitere Reiter, die zwischen den roten Stichtagen liegen) kann in Landkreisen/kreisfr. Städten von Bedeutung sein, in denen innerhalb des Quartals bei veränderter Einrichtungsbelegung die Finanzierung angepasst wird. \nACHTUNG: Nur einzublenden und bearbeiten, wenn sich das zu finanzierende Personal aufgrund veränderter Kinderzahlen für die Monate ebenfalls anpasst!"]
[]
[]
[null,null,"Die Eingabe relevanter Einrichtungsdaten (Träger, Einrichtung und Namen aller zum Einsatz kommenden pädagogischen Fachkräfte) erfolgt in den gelb hinterlegten Feldern. \nWird ergänzend das Geburtsjahr der Fachkräfte eingetragen, wird automatisch das Durchschnittsalter in der Einrichtung ermittelt (Zelle C-75)."]
[]
[null,null,"2. Reiter mit Stichtags- bzw. Monatsbezeichnung:"]
[null,null,"Die roten Monatsreiter entsprechen den Stichtagen; sie müssen mindestens ausgefüllt werden und berechnen die Personalmenge des finanzierten Personals für das kommenden Quartal. Die Steuerung, also die konkrete \"Verteilung\" der Personalmenge auf die jeweiligen Personen erfolgt im Reiter Personalstunden."]
[null,null,"Das Einblenden weiterer Monatsblätter (es erscheinen weitere Reiter, die zwischen den roten Stichtagen liegen) kann in Landkreisen/kreisfr. Städten von Bedeutung sein, in denen innerhalb des Quartals bei veränderter Einrichtungsbelegung die Finanzierung angepasst wird."]
[null,null,"Wird durch gesetzliche Anpassung unterjährig ein Personalschlüssel (Krippe, Kiga, Hort) verändert, so erfolgt die Anpassung unter Aufhebung des Zellschutzes auf dem dafür vorgesehenen Reiter (siehe Erläuterung Zeile 13). "]
[null,null,"Die Felder I-39 und I-42 geben die Möglichkeit, eine regionalspezifische Mehrausstattung (z.B. für kompensatorische Sprachförderung o.ä.), die über den Kostenträger (Jugendamt, Gemeinde) mit der Personalkostenerstattung ausgezahlt wird, einzutragen und somit in die Regelpersonalausstattung einfließen zu lassen."]
[]
[null,null,"Sonderprogramme, z.B. Bundes- oder Landesprogramme, die gesondert Personalmittel bereitstellen, werden im Reiter Personalstunden verwaltet und hier nicht erfasst. "]
[]
[null,null,"Die Reiter Stichtage, Monatsstatistik und Jahresdurchschnitt bilden ergänzende Berechnungen ab, die für bestimmte Auswertungen hilfreich sein können. Die Erkenntnisse und Informationen können für diverse Fragen, u.a. der Personalentwicklung, eine RElevanz erlangen. "]
[]
[null,null,"3. Reiter Personalstunden: "]
[null,null,"Dieser Reiter ist das \"Herz\" der Datei. Die Schalter oben rechts „leere Eingabezeilen ein- bzw. ausblenden“ erweitern die Eingabefelder und können individuell genutzt werden. Sind im Reiter Datenblatt die pädagogischen Fachkräfte eingetragen, erscheinen sie im oberen Teil in der Reihe der Eintragung."]
[]
[null,null,"Der obere Teil (bis Zeile 67) dient zur Darstellung der Verteilung des notwendigen pädagogischen Personals (inklusive pädagogischer Leitungsanteil) in Wochenarbeitsstunden auf die Summe der vorhandenen Mitarbeiter und verdeutlicht die Abweichungen (gewünschte Ausnutzung des Dispositionsspielraums nach §2 KitaPersV !) in den Zeilen 60, 61 und 62."]
[]
[null,null,"Ziel der Datei ist, Abweichungen je nach Bedarfslage durch z.B. pädagogische Notwendigkeiten (Projekt, Ausflug, u.ä.) in der Einrichtung oder durch personelle Situationen (Personalausfall) bewusst einzugehen, in der Jahresübersicht darzustellen und durch aktive Steuerung über das Jahr auszugleichen. Dabei ist unterjährig ein Korridor von +/- 10% des notwendigen pädagogischen Personals auszuschöpfen, der immer zum Jahresende wieder auszugleichen ist. "]
[]
[null,null,"(Erinnerung: alle gelb hinterlegten Felder können individuell beschrieben werden!)"]
[]
[null,null,"Darstellung der Zahlenwerte: "]
[null,null,"  - sobald ein Wert (Zeilen 60 bis 62) negativ ist, wird dieser rot ausgewiesen. "]
[null,null,"  - Eine Zelle wird rot unterlegt, sobald ein Summenwert (gebildet aus dem notwendigen Personaleinsatz und einem Sonderprogramm) 40 Stunden und damit die übliche tarifliche Wochenarbeitszeit übersteigt."]
[]
[]
[]
[]
[]
[null,null,"Die Spalte E im oberen Teil des Datenblatts (regelhafte Personalausstattung nach §10 KitaG) hat keinen Einfluss auf die Berechnung für das laufende Jahr, sie ist lediglich zur Information über vorangegangene Personalstundenverteilung eingefügt. Die Spalte W weist je nach Bearbeitungsstand im Jahr immer den (anteiligen) Jahresarbeitszeitdurchschnitt in Wochenstunden aus. "]
[]
[null,null,"Die Zeile 64 weist den Quartalswert des Personaleinsatzes (Soll-Ist-Vergleich) aus und stellt den Puffer in Stellenanteilen dar, der für die Folgequartale zum Einsatz gebracht werden muss, um das notwendige pädagogische Personal im Jahresdurchschnitt zu erfüllen. "]
[]
[null,null,"Die Steuerung von Sonderprogrammen erfolgt ab Zeile 68. Sonderprogramme sind Bundes- oder Landesprogramme, für die für einen bestimmten Zweck gesondert Personalmittel bereitgestellt werden. Hier sind Beispiele (Bundesprogramm Sprach-Kitas, Landesprogramm-Sprachberatung, Konsultationskita des Landes Brandenburg (KOKIB) usw.) aufgeführt, die Bezeichnungen können überschrieben werden.  "]
[]
[null,null,"Die Auswahl der Fachkräfte, die in dem jeweiligen Programm tätig sind, erfolgt individuell. Dazu die Zelle anklicken und dann aus dem Button Drop-Down-Menü die entsprechende Fachkraft auswählen. "]
[]
[null,null,"Außerdem können die Landesprogramme Kompensatorische Sprachförderung und Zeit für Anleitung (Gutschein zur Ausbildungsanleitung) verwaltet werden. Hierzu ebenfalls das Personal über die Funktion Drop-Down auswählen. "]
[]
[null,null,"Sollte über die Personalstundeneingabe für Sonderprogramme die Wochenarbeitszeit der jeweiligen Beschäftigten auf mehr als 40 Stunden anwachsen (Summe aus Einsatz oben und Sonderprogramm), wird der Wert des Feld automatisch rot markiert."]
[null,null,"Alle im Dokument verfügbaren Anmerkungsspalten sind von Berechnungen/Verknüpfungen ausgenommen und sind daher optional zu nutzen."]

{"sheet":"Datenblatt","index":1,"n_rows":75,"n_cols":15,"rows_kept":75,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,2,8],[5,4,5,7],[7,4,7,7],[8,14,10,19],[35,12,38,20],[30,1,30,7],[31,1,31,7],[32,1,32,7],[33,1,33,7]]}
[]
[null,"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "]
[null,"für die jeweilige Kindertagesstätte "]
[]
[]
[null,"Träger: ",null,null,"Gute Wahl "]
[]
[null,"Kindertagesstätte:",null,null,"Durchblick"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACHTUNG: Nur einzublenden und bearbeiten, wenn das zu finanzierende Personal aufgrund veränderter Kinderzahlen für die Monate angepasst werden muss!"]
[null,"Durchschnittliche Kapazität:",null,null,{"$f":"SUM(Januar!D9,Februar!D9,'01.03.'!D9,April!D9,Mai!D9,'01.06.'!D9,Juli!D9,August!D9,'01.09.'!D9,Oktober!D9,November!D9,Dezember!D9)/12","v":167},"Kinder","Jahr:",2016]
[]
[null,"Personalschlüssel nack KitaG §10"]
[null,"Betreuungsart",null,null,null,null,"Betreuungszeit","Personalschlüssel"]
[]
[null,"Kinderkrippe (KK)"]
[null,"für Kinder im Alter von 0 bis zum vollendeten 3. Lebensjahr",null,null,null,null,"bis 6 h",0.16]
[null,"für Kinder im Alter von 0 bis zum vollendeten 3. Lebensjahr",null,null,null,null,"ab 6 h",0.2]
[]
[]
[null,"Kindergarten"]
[null,"Kinder im Alter von 3 Jebensjahr bis zum Schuleintritt",null,null,null,null,"bis 6 h",6.7000000000000004E-2]
[null,"Kinder im Alter von 3 Jebensjahr bis zum Schuleintritt",null,null,null,null,"ab 6 h",8.3000000000000004E-2]
[]
[]
[null,"Hort"]
[null,"Grundschulalter",null,null,null,null,"bis 4 h",0.04]
[null,"Grundschulalter",null,null,null,null,"ab 4 h",5.2999999999999999E-2]
[]
[]
[null,"Allgemeine Anmerkungen"]
[]
[]
[]
[]
[]
[null,"Mitarbeiter-Übersicht","Geburts-\njahr","Alter","Anmerkungen","Spalte1","Spalte2","Spalte3",null,null,null,null,"ACHTUNG: Die Berechnung des Durchschnittsalters bezieht sich lediglich auf das Jahr und hat ausschließlich eine Monitoring-Funktion"]
[null,"Mozart",1949,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":67}]
[null,"Beethoven",1952,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":64}]
[null,"Chopin ",1952,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":64}]
[null,"Donizetti",1953,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":63}]
[null,"Bruckner ",1954,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":62}]
[null,"Britten ",1954,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":62}]
[null,"Händel ",1955,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":61}]
[null,"Haydn",1956,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":60}]
[null,"Offenbach ",1956,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":60}]
[null,"Rossini ",1958,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":58}]
[null,"Ravel ",1958,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":58}]
[null,"Salieri",1959,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":57}]
[null,"Verdi ",1959,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":57}]
[null,"Vivaldi ",1962,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":54}]
[null,"Wagner ",1967,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":49}]
[null,"Tschaikowsky",1969,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":47}]
[null,"Puccini ",1972,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":44}]
[null,"Sibelius ",1974,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":42}]
[null,"Smetana ",1979,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":37}]
[null,"Schumann ",1979,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":37}]
[null,"Orff ",1979,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":37}]
[null,"Pompadour ",1982,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":34}]
[null,"Diderot ",1982,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":34}]
[null,"Max",1971,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":45}]
[null,"Peter",1969,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":47}]
[null,"Luise",1993,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":23}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Geburts-\njahr]]>1935,$H$10-Tabelle1[[#This Row],[Geburts-\njahr]],\"\")","v":""}]
[null,"Durchschnittsalter",{"$f":"IF(ISERROR(ROUND(SUM(D37:D74)/COUNT(D37:D74),2)),\"\",ROUND(SUM(D37:D74)/COUNT(D37:D74),2))","v":50.88}]

{"sheet":"01.12.","index":2,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.12.\"&Datenblatt!H10-1","v":"01.12.2015"}]
[null,null,null,null,null,{"$f":"\"Stichtagsmeldung I. Quartal \"&RIGHT(I6,4)+1","v":"Stichtagsmeldung I. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,167,"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",18,0,{"$f":"SUM(D14:E14)","v":18},{"$f":"Datenblatt!H16","v":0.16},null,{"$f":"F14*G14","v":2.88}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",36,3,{"$f":"SUM(D15:E15)","v":39},{"$f":"Datenblatt!H17","v":0.2},null,{"$f":"F15*G15","v":7.8000000000000007}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":54},{"$f":"SUM(E14:E15)","v":3},{"$f":"SUM(F14:F15)","v":57},null,null,{"$f":"SUM(I14:I15)","v":10.68}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom ","bis 6 h",29,0,{"$f":"SUM(D18:E18)","v":29},{"$f":"Datenblatt!H21","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":1.9430000000000001}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",76,2,{"$f":"SUM(D19:E19)","v":78},{"$f":"Datenblatt!H22","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":6.4740000000000002}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":105},{"$f":"SUM(E18:E19)","v":2},{"$f":"SUM(F18:F19)","v":107},null,null,{"$f":"SUM(I18:I19)","v":8.4169999999999998}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",0,4,{"$f":"SUM(D22:E22)","v":4},{"$f":"Datenblatt!H26","v":0.04},null,{"$f":"F22*G22","v":0.16}]
[null,"Grundschulalter","ab 4 h",0,0,{"$f":"SUM(D23:E23)","v":0},{"$f":"Datenblatt!H27","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":4},{"$f":"SUM(F22:F23)","v":4},null,null,{"$f":"SUM(I22:I23)","v":0.16}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":19.257000000000001}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":168}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":1}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":19.257000000000001}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":0.5}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":19.757000000000001}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen - Soll)",null,null,null,null,{"$f":"SUM(I36:I44)","v":19.757000000000001}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vertretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"Januar","index":3,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.01.\"&Datenblatt!H10","v":"01.01.2016"}]
[null,null,null,null,null,{"$f":"'01.12.'!F7:I8","v":"Stichtagsmeldung I. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,167,"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",{"$f":"'01.12.'!D14","v":18},{"$f":"'01.12.'!E14","v":0},{"$f":"SUM(D14:E14)","v":18},{"$f":"Datenblatt!H16","v":0.16},null,{"$f":"F14*G14","v":2.88}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",{"$f":"'01.12.'!D15","v":36},{"$f":"'01.12.'!E15","v":3},{"$f":"SUM(D15:E15)","v":39},{"$f":"Datenblatt!H17","v":0.2},null,{"$f":"F15*G15","v":7.8000000000000007}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":54},{"$f":"SUM(E14:E15)","v":3},{"$f":"SUM(F14:F15)","v":57},null,null,{"$f":"SUM(I14:I15)","v":10.68}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",{"$f":"'01.12.'!D18","v":29},{"$f":"'01.12.'!E18","v":0},{"$f":"SUM(D18:E18)","v":29},{"$f":"Datenblatt!H21","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":1.9430000000000001}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",{"$f":"'01.12.'!D19","v":76},{"$f":"'01.12.'!E19","v":2},{"$f":"SUM(D19:E19)","v":78},{"$f":"Datenblatt!H22","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":6.4740000000000002}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":105},{"$f":"SUM(E18:E19)","v":2},{"$f":"SUM(F18:F19)","v":107},null,null,{"$f":"SUM(I18:I19)","v":8.4169999999999998}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",{"$f":"'01.12.'!D22","v":0},{"$f":"'01.12.'!E22","v":4},{"$f":"SUM(D22:E22)","v":4},{"$f":"Datenblatt!H26","v":0.04},null,{"$f":"F22*G22","v":0.16}]
[null,"Grundschulalter","ab 4 h",{"$f":"'01.12.'!D23","v":0},{"$f":"'01.12.'!E23","v":0},{"$f":"SUM(D23:E23)","v":0},{"$f":"Datenblatt!H27","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":4},{"$f":"SUM(F22:F23)","v":4},null,null,{"$f":"SUM(I22:I23)","v":0.16}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":19.257000000000001}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":168}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":1}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":19.257000000000001}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":0.5}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":19.757000000000001}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":19.757000000000001}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vertretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"Februar","index":4,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.02.\"&Datenblatt!H10","v":"01.02.2016"}]
[null,null,null,null,null,{"$f":"'01.12.'!F7:I8","v":"Stichtagsmeldung I. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"Januar!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",{"$f":"'01.12.'!D14","v":18},{"$f":"'01.12.'!E14","v":0},{"$f":"SUM(D14:E14)","v":18},{"$f":"Januar!G14","v":0.16},null,{"$f":"F14*G14","v":2.88}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",{"$f":"'01.12.'!D15","v":36},{"$f":"'01.12.'!E15","v":3},{"$f":"SUM(D15:E15)","v":39},{"$f":"Januar!G15","v":0.2},null,{"$f":"F15*G15","v":7.8000000000000007}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":54},{"$f":"SUM(E14:E15)","v":3},{"$f":"SUM(F14:F15)","v":57},null,null,{"$f":"SUM(I14:I15)","v":10.68}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",{"$f":"'01.12.'!D18","v":29},{"$f":"'01.12.'!E18","v":0},{"$f":"SUM(D18:E18)","v":29},{"$f":"Januar!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":1.9430000000000001}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",{"$f":"'01.12.'!D19","v":76},{"$f":"'01.12.'!E19","v":2},{"$f":"SUM(D19:E19)","v":78},{"$f":"Januar!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":6.4740000000000002}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":105},{"$f":"SUM(E18:E19)","v":2},{"$f":"SUM(F18:F19)","v":107},null,null,{"$f":"SUM(I18:I19)","v":8.4169999999999998}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",{"$f":"'01.12.'!D22","v":0},{"$f":"'01.12.'!E22","v":4},{"$f":"SUM(D22:E22)","v":4},{"$f":"Januar!G22","v":0.04},null,{"$f":"F22*G22","v":0.16}]
[null,"Grundschulalter","ab 4 h",{"$f":"'01.12.'!D23","v":0},{"$f":"'01.12.'!E23","v":0},{"$f":"SUM(D23:E23)","v":0},{"$f":"Januar!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":4},{"$f":"SUM(F22:F23)","v":4},null,null,{"$f":"SUM(I22:I23)","v":0.16}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":19.257000000000001}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":168}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":1}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":19.257000000000001}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersVO § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":0.5}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":19.757000000000001}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":19.757000000000001}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vertretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"01.03.","index":5,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.03.\"&Datenblatt!H10","v":"01.03.2016"}]
[null,null,null,null,null,{"$f":"\"Stichtagsmeldung II. Quartal \"&RIGHT(I6,4)","v":"Stichtagsmeldung II. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"Februar!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",14,0,{"$f":"SUM(D14:E14)","v":14},{"$f":"Februar!G14","v":0.16},null,{"$f":"F14*G14","v":2.2400000000000002}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",37,2,{"$f":"SUM(D15:E15)","v":39},{"$f":"Februar!G15","v":0.2},null,{"$f":"F15*G15","v":7.8000000000000007}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":51},{"$f":"SUM(E14:E15)","v":2},{"$f":"SUM(F14:F15)","v":53},null,null,{"$f":"SUM(I14:I15)","v":10.040000000000001}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",30,0,{"$f":"SUM(D18:E18)","v":30},{"$f":"Februar!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":2.0100000000000002}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",81,4,{"$f":"SUM(D19:E19)","v":85},{"$f":"Februar!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":7.0550000000000006}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":111},{"$f":"SUM(E18:E19)","v":4},{"$f":"SUM(F18:F19)","v":115},null,null,{"$f":"SUM(I18:I19)","v":9.0650000000000013}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",0,0,{"$f":"SUM(D22:E22)","v":0},{"$f":"Februar!G22","v":0.04},null,{"$f":"F22*G22","v":0}]
[null,"Grundschulalter","ab 4 h",0,0,{"$f":"SUM(D23:E23)","v":0},{"$f":"Februar!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},null,null,{"$f":"SUM(I22:I23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":19.105000000000004}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":168}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":1}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":19.105000000000004}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":0.5}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":19.605000000000004}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":19.605000000000004}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vertretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"April","index":6,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.04.\"&Datenblatt!H10","v":"01.04.2016"}]
[null,null,null,null,null,{"$f":"'01.03.'!F7:I8","v":"Stichtagsmeldung II. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"'01.03.'!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",{"$f":"'01.03.'!D14","v":14},{"$f":"'01.03.'!E14","v":0},{"$f":"SUM(D14:E14)","v":14},{"$f":"'01.03.'!G14","v":0.16},null,{"$f":"F14*G14","v":2.2400000000000002}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",{"$f":"'01.03.'!D15","v":37},{"$f":"'01.03.'!E15","v":2},{"$f":"SUM(D15:E15)","v":39},{"$f":"'01.03.'!G15","v":0.2},null,{"$f":"F15*G15","v":7.8000000000000007}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":51},{"$f":"SUM(E14:E15)","v":2},{"$f":"SUM(F14:F15)","v":53},null,null,{"$f":"SUM(I14:I15)","v":10.040000000000001}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",{"$f":"'01.03.'!D18","v":30},{"$f":"'01.03.'!E18","v":0},{"$f":"SUM(D18:E18)","v":30},{"$f":"'01.03.'!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":2.0100000000000002}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",{"$f":"'01.03.'!D19","v":81},{"$f":"'01.03.'!E19","v":4},{"$f":"SUM(D19:E19)","v":85},{"$f":"'01.03.'!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":7.0550000000000006}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":111},{"$f":"SUM(E18:E19)","v":4},{"$f":"SUM(F18:F19)","v":115},null,null,{"$f":"SUM(I18:I19)","v":9.0650000000000013}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",{"$f":"'01.03.'!D22","v":0},{"$f":"'01.03.'!E22","v":0},{"$f":"SUM(D22:E22)","v":0},{"$f":"'01.03.'!G22","v":0.04},null,{"$f":"F22*G22","v":0}]
[null,"Grundschulalter","ab 4 h",{"$f":"'01.03.'!D23","v":0},{"$f":"'01.03.'!E23","v":0},{"$f":"SUM(D23:E23)","v":0},{"$f":"'01.03.'!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},null,null,{"$f":"SUM(I22:I23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":19.105000000000004}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":168}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":1}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":19.105000000000004}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":0.5}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":19.605000000000004}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":19.605000000000004}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vertretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"Mai","index":7,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.05.\"&Datenblatt!H10","v":"01.05.2016"}]
[null,null,null,null,null,{"$f":"'01.03.'!F7:I8","v":"Stichtagsmeldung II. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"April!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",{"$f":"'01.03.'!D14","v":14},{"$f":"'01.03.'!E14","v":0},{"$f":"SUM(D14:E14)","v":14},{"$f":"April!G14","v":0.16},null,{"$f":"F14*G14","v":2.2400000000000002}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",{"$f":"'01.03.'!D15","v":37},{"$f":"'01.03.'!E15","v":2},{"$f":"SUM(D15:E15)","v":39},{"$f":"April!G15","v":0.2},null,{"$f":"F15*G15","v":7.8000000000000007}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":51},{"$f":"SUM(E14:E15)","v":2},{"$f":"SUM(F14:F15)","v":53},null,null,{"$f":"SUM(I14:I15)","v":10.040000000000001}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",{"$f":"'01.03.'!D18","v":30},{"$f":"'01.03.'!E18","v":0},{"$f":"SUM(D18:E18)","v":30},{"$f":"April!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":2.0100000000000002}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",{"$f":"'01.03.'!D19","v":81},{"$f":"'01.03.'!E19","v":4},{"$f":"SUM(D19:E19)","v":85},{"$f":"April!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":7.0550000000000006}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":111},{"$f":"SUM(E18:E19)","v":4},{"$f":"SUM(F18:F19)","v":115},null,null,{"$f":"SUM(I18:I19)","v":9.0650000000000013}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",{"$f":"'01.03.'!D22","v":0},{"$f":"'01.03.'!E22","v":0},{"$f":"SUM(D22:E22)","v":0},{"$f":"April!G22","v":0.04},null,{"$f":"F22*G22","v":0}]
[null,"Grundschulalter","ab 4 h",{"$f":"'01.03.'!D23","v":0},{"$f":"'01.03.'!E23","v":0},{"$f":"SUM(D23:E23)","v":0},{"$f":"April!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},null,null,{"$f":"SUM(I22:I23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":19.105000000000004}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":168}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":1}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":19.105000000000004}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":0.5}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":19.605000000000004}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":19.605000000000004}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vertretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"01.06.","index":8,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.06.\"&Datenblatt!H10","v":"01.06.2016"}]
[null,null,null,null,null,{"$f":"\"Stichtagsmeldung III. Quartal \"&RIGHT(I6,4)","v":"Stichtagsmeldung III. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"Mai!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",11,0,{"$f":"SUM(D14:E14)","v":11},{"$f":"Mai!G14","v":0.16},null,{"$f":"F14*G14","v":1.76}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",33,2,{"$f":"SUM(D15:E15)","v":35},{"$f":"Mai!G15","v":0.2},null,{"$f":"F15*G15","v":7}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":44},{"$f":"SUM(E14:E15)","v":2},{"$f":"SUM(F14:F15)","v":46},null,null,{"$f":"SUM(I14:I15)","v":8.76}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",30,0,{"$f":"SUM(D18:E18)","v":30},{"$f":"Mai!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":2.0100000000000002}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",90,4,{"$f":"SUM(D19:E19)","v":94},{"$f":"Mai!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":7.8020000000000005}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":120},{"$f":"SUM(E18:E19)","v":4},{"$f":"SUM(F18:F19)","v":124},null,null,{"$f":"SUM(I18:I19)","v":9.8120000000000012}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",0,0,{"$f":"SUM(D22:E22)","v":0},{"$f":"Mai!G22","v":0.04},null,{"$f":"F22*G22","v":0}]
[null,"Grundschulalter","ab 4 h",0,0,{"$f":"SUM(D23:E23)","v":0},{"$f":"Mai!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},null,null,{"$f":"SUM(I22:I23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":18.572000000000003}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":170}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":3}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":18.572000000000003}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":0.5}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":19.072000000000003}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":19.072000000000003}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vertretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"Juli","index":9,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.07.\"&Datenblatt!H10","v":"01.07.2016"}]
[null,null,null,null,null,{"$f":"'01.06.'!F7:I8","v":"Stichtagsmeldung III. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"'01.06.'!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",{"$f":"'01.06.'!D14","v":11},{"$f":"'01.06.'!E14","v":0},{"$f":"SUM(D14:E14)","v":11},{"$f":"'01.06.'!G14","v":0.16},null,{"$f":"F14*G14","v":1.76}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",{"$f":"'01.06.'!D15","v":33},{"$f":"'01.06.'!E15","v":2},{"$f":"SUM(D15:E15)","v":35},{"$f":"'01.06.'!G15","v":0.2},null,{"$f":"F15*G15","v":7}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":44},{"$f":"SUM(E14:E15)","v":2},{"$f":"SUM(F14:F15)","v":46},null,null,{"$f":"SUM(I14:I15)","v":8.76}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",{"$f":"'01.06.'!D18","v":30},{"$f":"'01.06.'!E18","v":0},{"$f":"SUM(D18:E18)","v":30},{"$f":"'01.06.'!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":2.0100000000000002}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",{"$f":"'01.06.'!D19","v":90},{"$f":"'01.06.'!E19","v":4},{"$f":"SUM(D19:E19)","v":94},{"$f":"'01.06.'!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":7.8020000000000005}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":120},{"$f":"SUM(E18:E19)","v":4},{"$f":"SUM(F18:F19)","v":124},null,null,{"$f":"SUM(I18:I19)","v":9.8120000000000012}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",{"$f":"'01.06.'!D22","v":0},{"$f":"'01.06.'!E22","v":0},{"$f":"SUM(D22:E22)","v":0},{"$f":"'01.06.'!G22","v":0.04},null,{"$f":"F22*G22","v":0}]
[null,"Grundschulalter","ab 4 h",{"$f":"'01.06.'!D23","v":0},{"$f":"'01.06.'!E23","v":0},{"$f":"SUM(D23:E23)","v":0},{"$f":"'01.06.'!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},null,null,{"$f":"SUM(I22:I23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":18.572000000000003}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":170}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":3}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":18.572000000000003}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":0.5}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":19.072000000000003}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":19.072000000000003}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vertretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"August","index":10,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.08.\"&Datenblatt!H10","v":"01.08.2016"}]
[null,null,null,null,null,{"$f":"'01.06.'!F7:I8","v":"Stichtagsmeldung III. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"Juli!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",{"$f":"'01.06.'!D14","v":11},{"$f":"'01.06.'!E14","v":0},{"$f":"SUM(D14:E14)","v":11},{"$f":"Juli!G14","v":0.16},null,{"$f":"F14*G14","v":1.76}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",{"$f":"'01.06.'!D15","v":33},{"$f":"'01.06.'!E15","v":2},{"$f":"SUM(D15:E15)","v":35},{"$f":"Juli!G15","v":0.2},null,{"$f":"F15*G15","v":7}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":44},{"$f":"SUM(E14:E15)","v":2},{"$f":"SUM(F14:F15)","v":46},null,null,{"$f":"SUM(I14:I15)","v":8.76}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",{"$f":"'01.06.'!D18","v":30},{"$f":"'01.06.'!E18","v":0},{"$f":"SUM(D18:E18)","v":30},{"$f":"Juli!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":2.0100000000000002}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",{"$f":"'01.06.'!D19","v":90},{"$f":"'01.06.'!E19","v":4},{"$f":"SUM(D19:E19)","v":94},{"$f":"Juli!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":7.8020000000000005}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":120},{"$f":"SUM(E18:E19)","v":4},{"$f":"SUM(F18:F19)","v":124},null,null,{"$f":"SUM(I18:I19)","v":9.8120000000000012}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",{"$f":"'01.06.'!D22","v":0},{"$f":"'01.06.'!E22","v":0},{"$f":"SUM(D22:E22)","v":0},{"$f":"Juli!G22","v":0.04},null,{"$f":"F22*G22","v":0}]
[null,"Grundschulalter","ab 4 h",{"$f":"'01.06.'!D23","v":0},{"$f":"'01.06.'!E23","v":0},{"$f":"SUM(D23:E23)","v":0},{"$f":"Juli!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},null,null,{"$f":"SUM(I22:I23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":18.572000000000003}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":170}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":3}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":18.572000000000003}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":0.5}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":19.072000000000003}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":19.072000000000003}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vertretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"01.09.","index":11,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag: ",null,{"$f":"\"01.09.\"&Datenblatt!H10","v":"01.09.2016"}]
[null,null,null,null,null,{"$f":"\"Stichtagsmeldung IV. Quartal \"&RIGHT(I6,4)","v":"Stichtagsmeldung IV. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"August!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",0,0,{"$f":"SUM(D14:E14)","v":0},{"$f":"August!G14","v":0.16},null,{"$f":"F14*G14","v":0}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",0,0,{"$f":"SUM(D15:E15)","v":0},{"$f":"August!G15","v":0.2},null,{"$f":"F15*G15","v":0}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":0},{"$f":"SUM(E14:E15)","v":0},{"$f":"SUM(F14:F15)","v":0},null,null,{"$f":"SUM(I14:I15)","v":0}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",0,0,{"$f":"SUM(D18:E18)","v":0},{"$f":"August!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":0}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",0,0,{"$f":"SUM(D19:E19)","v":0},{"$f":"August!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":0}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":0},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},null,null,{"$f":"SUM(I18:I19)","v":0}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",0,0,{"$f":"SUM(D22:E22)","v":0},{"$f":"August!G22","v":0.04},null,{"$f":"F22*G22","v":0}]
[null,"Grundschulalter","ab 4 h",0,0,{"$f":"SUM(D23:E23)","v":0},{"$f":"August!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},null,null,{"$f":"SUM(I22:I23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":0}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":0}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":-167}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":0}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":""}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":0}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":0}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vertretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"Oktober","index":12,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.10.\"&Datenblatt!H10","v":"01.10.2016"}]
[null,null,null,null,null,{"$f":"'01.09.'!F7:I8","v":"Stichtagsmeldung IV. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"'01.09.'!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",{"$f":"'01.09.'!D14","v":0},{"$f":"'01.09.'!E14","v":0},{"$f":"SUM(D14:E14)","v":0},{"$f":"'01.09.'!G14","v":0.16},null,{"$f":"F14*G14","v":0}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",{"$f":"'01.09.'!D15","v":0},{"$f":"'01.09.'!E15","v":0},{"$f":"SUM(D15:E15)","v":0},{"$f":"'01.09.'!G15","v":0.2},null,{"$f":"F15*G15","v":0}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":0},{"$f":"SUM(E14:E15)","v":0},{"$f":"SUM(F14:F15)","v":0},null,null,{"$f":"SUM(I14:I15)","v":0}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",{"$f":"'01.09.'!D18","v":0},{"$f":"'01.09.'!E18","v":0},{"$f":"SUM(D18:E18)","v":0},{"$f":"'01.09.'!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":0}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",{"$f":"'01.09.'!D19","v":0},{"$f":"'01.09.'!E19","v":0},{"$f":"SUM(D19:E19)","v":0},{"$f":"'01.09.'!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":0}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":0},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},null,null,{"$f":"SUM(I18:I19)","v":0}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",{"$f":"'01.09.'!D22","v":0},{"$f":"'01.09.'!E22","v":0},{"$f":"SUM(D22:E22)","v":0},{"$f":"'01.09.'!G22","v":0.04},null,{"$f":"F22*G22","v":0}]
[null,"Grundschulalter","ab 4 h",{"$f":"'01.09.'!D23","v":0},{"$f":"'01.09.'!E23","v":0},{"$f":"SUM(D23:E23)","v":0},{"$f":"'01.09.'!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},null,null,{"$f":"SUM(I22:I23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":0}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":0}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":-167}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":0}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":""}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":0}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":0}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vetretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"November","index":13,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.11.\"&Datenblatt!H10","v":"01.11.2016"}]
[null,null,null,null,null,{"$f":"'01.09.'!F7:I8","v":"Stichtagsmeldung IV. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"Oktober!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",{"$f":"'01.09.'!D14","v":0},{"$f":"'01.09.'!E14","v":0},{"$f":"SUM(D14:E14)","v":0},{"$f":"Oktober!G14","v":0.16},null,{"$f":"F14*G14","v":0}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",{"$f":"'01.09.'!D15","v":0},{"$f":"'01.09.'!E15","v":0},{"$f":"SUM(D15:E15)","v":0},{"$f":"Oktober!G15","v":0.2},null,{"$f":"F15*G15","v":0}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":0},{"$f":"SUM(E14:E15)","v":0},{"$f":"SUM(F14:F15)","v":0},null,null,{"$f":"SUM(I14:I15)","v":0}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",{"$f":"'01.09.'!D18","v":0},{"$f":"'01.09.'!E18","v":0},{"$f":"SUM(D18:E18)","v":0},{"$f":"Oktober!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":0}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",{"$f":"'01.09.'!D19","v":0},{"$f":"'01.09.'!E19","v":0},{"$f":"SUM(D19:E19)","v":0},{"$f":"Oktober!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":0}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":0},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},null,null,{"$f":"SUM(I18:I19)","v":0}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",{"$f":"'01.09.'!D22","v":0},{"$f":"'01.09.'!E22","v":0},{"$f":"SUM(D22:E22)","v":0},{"$f":"Oktober!G22","v":0.04},null,{"$f":"F22*G22","v":0}]
[null,"Grundschulalter","ab 4 h",{"$f":"'01.09.'!D23","v":0},{"$f":"'01.09.'!E23","v":0},{"$f":"SUM(D23:E23)","v":0},{"$f":"Oktober!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},null,null,{"$f":"SUM(I22:I23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":0}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":0}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":-167}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":0}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":""}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":0}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":0}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vetretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"Dezember","index":14,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[[38,4,38,6],[41,4,41,6],[1,1,1,8],[10,1,10,8],[7,2,7,4],[5,2,5,4],[6,5,7,8],[2,1,2,8]]}
[]
[null,{"$f":"Datenblatt!B2","v":"Grundlage zur Finanzierung des notwendigen pädagogischen Personals "}]
[null,{"$f":"Datenblatt!B3","v":"für die jeweilige Kindertagesstätte "}]
[]
[]
[null,"Träger: ",{"$f":"Datenblatt!E6","v":"Gute Wahl "},null,null,null,"Stichtag:",null,{"$f":"\"01.12.\"&Datenblatt!H10","v":"01.12.2016"}]
[null,null,null,null,null,{"$f":"'01.09.'!F7:I8","v":"Stichtagsmeldung IV. Quartal 2016"}]
[null,"Kindertagesstätte:",{"$f":"Datenblatt!E8","v":"Durchblick"}]
[null,"Kapazität gemäß Betriebserlaubnis:",null,{"$f":"November!D9","v":167},"Kinder"]
[]
[null,"vertraglich belegte Plätze nach (KitaG § 1)"]
[null,"Betreuungsart","Betreuungs- zeit","Kinder","Kinder\nanderer\nGemeinden","gesamt","Personal- schlüssel nach     (KitaG § 10) ",null,"Personal-\nstellen\nSoll",null,"Anmerkungen"]
[null,"Kinderkrippe"]
[null,"Kinder im Alter von 0","bis 6 h",{"$f":"'01.09.'!D14","v":0},{"$f":"'01.09.'!E14","v":0},{"$f":"SUM(D14:E14)","v":0},{"$f":"November!G14","v":0.16},null,{"$f":"F14*G14","v":0}]
[null,"bis zum vollendeten 3. LJ","ab 6 h",{"$f":"'01.09.'!D15","v":0},{"$f":"'01.09.'!E15","v":0},{"$f":"SUM(D15:E15)","v":0},{"$f":"November!G15","v":0.2},null,{"$f":"F15*G15","v":0}]
[null,"gesamt",null,{"$f":"SUM(D14:D15)","v":0},{"$f":"SUM(E14:E15)","v":0},{"$f":"SUM(F14:F15)","v":0},null,null,{"$f":"SUM(I14:I15)","v":0}]
[null,"Kindergarten"]
[null,"Kinder im Alter vom","bis 6 h",{"$f":"'01.09.'!D18","v":0},{"$f":"'01.09.'!E18","v":0},{"$f":"SUM(D18:E18)","v":0},{"$f":"November!G18","v":6.7000000000000004E-2},null,{"$f":"F18*G18","v":0}]
[null,"3 LJ bis zum Schuleintritt","ab 6 h",{"$f":"'01.09.'!D19","v":0},{"$f":"'01.09.'!E19","v":0},{"$f":"SUM(D19:E19)","v":0},{"$f":"November!G19","v":8.3000000000000004E-2},null,{"$f":"F19*G19","v":0}]
[null,"gesamt",null,{"$f":"SUM(D18:D19)","v":0},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},null,null,{"$f":"SUM(I18:I19)","v":0}]
[null,"Hort"]
[null,"Kinder im ","bis 4 h",{"$f":"'01.09.'!D22","v":0},{"$f":"'01.09.'!E22","v":0},{"$f":"SUM(D22:E22)","v":0},{"$f":"November!G22","v":0.04},null,{"$f":"F22*G22","v":0}]
[null,"Grundschulalter","ab 4 h",{"$f":"'01.09.'!D23","v":0},{"$f":"'01.09.'!E23","v":0},{"$f":"SUM(D23:E23)","v":0},{"$f":"November!G23","v":5.2999999999999999E-2},null,{"$f":"F23*G23","v":0}]
[null,"gesamt",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},null,null,{"$f":"SUM(I22:I23)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I16+I20+I24","v":0}]
[]
[]
[null,"Kinderzahl insgesamt",null,null,null,{"$f":"F16+F20+F24","v":0}]
[null,"Kapazität",null,null,null,{"$f":"D9","v":167}]
[null,"Über- oder Unterbelegung",null,null,null,{"$f":"F28-F29","v":-167}]
[]
[null,null,null,"Finanziertes Personal gem. belegter Plätze",null,null,null,null,{"$f":"I25","v":0}]
[]
[null,null,null,null,"Päd.Leitungsanteil Kita PersV § 5 (2)",null,null,null,{"$f":"IF(I32>=15,0.5,IF(I32>=10,0.375,IF(I32>=4,0.25,\"\")))","v":""}]
[]
[]
[null,null,null,null,"Zwischensumme",null,null,null,{"$f":"SUM(I32:I34)","v":0}]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG  "]
[]
[]
[null,null,null,null,"ggf. Mehrausstattung im Zusammenhang mit Finanzierung nach §16(2) KitaG"]
[]
[]
[null,null,null,"Gesamt fin. Personal gem. bel. Plätze (VZ-Stellen)",null,null,null,null,{"$f":"SUM(I36:I44)","v":0}]
[]
[]
[null,"sachlich und rechnerisch richtig:"]
[]
[]
[null,"Datum",null,null,"Unterschrift einer zur Vetretung"]
[null,null,null,null,"berechtigten Person"]

{"sheet":"Stichtage ","index":15,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[33,1,33,4],[23,1,23,4],[24,1,24,4],[1,1,1,4],[4,1,4,4],[14,1,14,4],[5,1,5,4],[15,1,15,4]]}
[]
[null,{"$f":"\"Statistik \"&Datenblatt!E8&\"Stichtage \"&Datenblatt!H10","v":"Statistik DurchblickStichtage 2016"}]
[]
[]
[null,"Anzahl der Kinder im Alter von 0 bis zur Vollendung des 3. Lebensjahres"]
[null,"Betreuungsumfang gem. § 1 KitaG"]
[]
[null,"zu finanzierendes Quartal ab","bis 6 h","ab 6 h","gesamt"]
[null,{"$f":"\"01. Januar \"&Datenblatt!$H$10","v":"01. Januar 2016"},{"$f":"'01.12.'!F14","v":18},{"$f":"'01.12.'!F15","v":39},{"$f":"SUM(C9:D9)","v":57}]
[null,{"$f":"\"01. April \"&Datenblatt!$H$10","v":"01. April 2016"},{"$f":"'01.03.'!F14","v":14},{"$f":"'01.03.'!F15","v":39},{"$f":"SUM(C10:D10)","v":53}]
[null,{"$f":"\"01. Juli \"&Datenblatt!$H$10","v":"01. Juli 2016"},{"$f":"'01.06.'!F14","v":11},{"$f":"'01.06.'!F15","v":35},{"$f":"SUM(C11:D11)","v":46}]
[null,{"$f":"\"01. Oktober \"&Datenblatt!$H$10","v":"01. Oktober 2016"},{"$f":"'01.09.'!F14","v":0},{"$f":"'01.09.'!F15","v":0},{"$f":"SUM(C12:D12)","v":0}]
[]
[]
[null,"Anzahl der Kinder im Alter vom 3. Lebensjahr bis zum Schuleintritt"]
[null,"Betreuungsumfang gem. § 1 KitaG"]
[]
[null,"zu finanzierendes Quartal ab","bis 6 h","ab 6 h","gesamt"]
[null,{"$f":"\"01. Januar \"&Datenblatt!$H$10","v":"01. Januar 2016"},{"$f":"'01.12.'!F18","v":29},{"$f":"'01.12.'!F19","v":78},{"$f":"SUM(C19:D19)","v":107}]
[null,{"$f":"\"01. April \"&Datenblatt!$H$10","v":"01. April 2016"},{"$f":"'01.03.'!F18","v":30},{"$f":"'01.03.'!F19","v":85},{"$f":"SUM(C20:D20)","v":115}]
[null,{"$f":"\"01. Juli \"&Datenblatt!$H$10","v":"01. Juli 2016"},{"$f":"'01.06.'!F18","v":30},{"$f":"'01.06.'!F19","v":94},{"$f":"SUM(C21:D21)","v":124}]
[null,{"$f":"\"01. Oktober \"&Datenblatt!$H$10","v":"01. Oktober 2016"},{"$f":"'01.09.'!F18","v":0},{"$f":"'01.09.'!F19","v":0},{"$f":"SUM(C22:D22)","v":0}]
[]
[null,"Anzahl der Kinder im Grundschulalter"]
[null,"Betreuungsumfang gem. § 1 KitaG"]
[]
[null,"zu finanzierendes Quartal ab","bis 6 h","ab 6 h","gesamt"]
[null,{"$f":"\"01. Januar \"&Datenblatt!$H$10","v":"01. Januar 2016"},{"$f":"'01.12.'!F22","v":4},{"$f":"'01.12.'!F23","v":0},{"$f":"SUM(C28:D28)","v":4}]
[null,{"$f":"\"01. April \"&Datenblatt!$H$10","v":"01. April 2016"},{"$f":"'01.03.'!F22","v":0},{"$f":"'01.03.'!F23","v":0},{"$f":"SUM(C29:D29)","v":0}]
[null,{"$f":"\"01. Juli \"&Datenblatt!$H$10","v":"01. Juli 2016"},{"$f":"'01.06.'!F22","v":0},{"$f":"'01.06.'!F23","v":0},{"$f":"SUM(C30:D30)","v":0}]
[null,{"$f":"\"01. Oktober \"&Datenblatt!$H$10","v":"01. Oktober 2016"},{"$f":"'01.09.'!F22","v":0},{"$f":"'01.09.'!F23","v":0},{"$f":"SUM(C31:D31)","v":0}]
[]
[]
[null,"Auswertung"]
[]
[null,{"$f":"\"Auslastung \"&Datenblatt!H10","v":"Auslastung 2016"},"Kapazität","Belegung\ngesamt","Auslastung in %"]
[null,{"$f":"\"01. Januar \"&Datenblatt!$H$10","v":"01. Januar 2016"},{"$f":"IF('01.12.'!$D$9=0,\"\",'01.12.'!$D$9)","v":167},{"$f":"IF(SUMIF(B8:B31,B37,E8:E31)=0,\"\",SUMIF(B8:B31,B37,E8:E31))","v":168},{"$f":"IF(OR($C37=\"\",$D37=\"\"),\"\",$D37/$C37)","v":1.0059880239520957}]
[null,{"$f":"\"01. April \"&Datenblatt!$H$10","v":"01. April 2016"},{"$f":"IF('01.03.'!$D$9=0,\"\",'01.03.'!$D$9)","v":167},{"$f":"IF(SUMIF(B9:B31,B38,E9:E31)=0,\"\",SUMIF(B9:B31,B38,E9:E31))","v":168},1.0059880239520957]
[null,{"$f":"\"01. Juli \"&Datenblatt!$H$10","v":"01. Juli 2016"},{"$f":"IF('01.06.'!$D$9=0,\"\",'01.06.'!$D$9)","v":167},{"$f":"IF(SUMIF(B9:B31,B39,E9:E31)=0,\"\",SUMIF(B9:B31,B39,E9:E31))","v":170},1.0179640718562875]
[null,{"$f":"\"01. Oktober \"&Datenblatt!$H$10","v":"01. Oktober 2016"},{"$f":"IF('01.09.'!$D$9=0,\"\",'01.09.'!$D$9)","v":167},{"$f":"IF(SUMIF(B9:B31,B40,E9:E31)=0,\"\",SUMIF(B9:B31,B40,E9:E31))","v":""},{"$f":"IF(OR($C40=\"\",$D40=\"\"),\"\",$D40/$C40)","v":""}]
[null,"Belegung Gesamt",null,{"$f":"SUM(D37:D40)","v":506}]
[null,"Quartalsdurchschnitt",{"$f":"IF(ISERROR(SUM(C37:C40)/COUNT(C37:C40)),\"\",SUM(C37:C40)/COUNT(C37:C40))","v":167},{"$f":"IF(ISERROR(D41/COUNT(D37:D40)),\"\",D41/COUNT(D37:D40))","v":168.66666666666666},{"$f":"IF(ISERROR(D42/C42),\"\",D42/C42)","v":1.0099800399201597}]

{"sheet":"Monatsstatistik ","index":16,"n_rows":96,"n_cols":5,"rows_kept":96,"cut":false,"hidden":false,"merged":[[94,6,94,8],[45,1,45,4],[64,1,64,4],[65,1,65,4],[1,1,1,4],[4,1,4,4],[5,1,5,4],[24,1,24,4],[25,1,25,4],[44,1,44,4],[76,1,76,4]]}
[]
[null,{"$f":"Datenblatt!E8&\" Monatsstatistik \"&Datenblatt!H10","v":"Durchblick Monatsstatistik 2016"}]
[]
[]
[null,"Anzahl der Kinder im Alter von 0 bis zur Vollendung des 3. Lebensjahres"]
[null,"Betreuungsumfang gem. § 1 KitaG"]
[]
[null,"Monate","bis 6 h","ab 6 h","gesamt"]
[null,{"$f":"\"01. Januar \"&Datenblatt!$H$10","v":"01. Januar 2016"},{"$f":"'01.12.'!$F$14","v":18},{"$f":"'01.12.'!$F$15","v":39},{"$f":"SUM(C9:D9)","v":57}]
[null,{"$f":"\"01. Februar \"&Datenblatt!$H$10","v":"01. Februar 2016"},{"$f":"Januar!$F$14","v":18},{"$f":"Januar!$F$15","v":39},{"$f":"SUM(C10:D10)","v":57}]
[null,{"$f":"\"01. März \"&Datenblatt!$H$10","v":"01. März 2016"},{"$f":"Februar!$F$14","v":18},{"$f":"Februar!$F$15","v":39},57]
[null,{"$f":"\"01. April \"&Datenblatt!$H$10","v":"01. April 2016"},{"$f":"'01.03.'!$F$14","v":14},{"$f":"'01.03.'!$F$15","v":39},53]
[null,{"$f":"\"01. Mai \"&Datenblatt!$H$10","v":"01. Mai 2016"},{"$f":"April!$F$14","v":14},{"$f":"April!$F$15","v":39},53]
[null,{"$f":"\"01. Juni \"&Datenblatt!$H$10","v":"01. Juni 2016"},{"$f":"Mai!$F$14","v":14},{"$f":"Mai!$F$15","v":39},53]
[null,{"$f":"\"01. Juli \"&Datenblatt!$H$10","v":"01. Juli 2016"},{"$f":"'01.06.'!$F$14","v":11},{"$f":"'01.06.'!$F$15","v":35},46]
[null,{"$f":"\"01. Agust \"&Datenblatt!$H$10","v":"01. Agust 2016"},{"$f":"Juli!$F$14","v":11},{"$f":"Juli!$F$15","v":35},46]
[null,{"$f":"\"01. September \"&Datenblatt!$H$10","v":"01. September 2016"},{"$f":"August!$F$14","v":11},{"$f":"August!$F$15","v":35},46]
[null,{"$f":"\"01. Oktober \"&Datenblatt!$H$10","v":"01. Oktober 2016"},{"$f":"'01.09.'!$F$14","v":0},{"$f":"'01.09.'!$F$15","v":0},0]
[null,{"$f":"\"01. November \"&Datenblatt!$H$10","v":"01. November 2016"},{"$f":"Oktober!$F$14","v":0},{"$f":"Oktober!$F$15","v":0},0]
[null,{"$f":"\"01. Dezember \"&Datenblatt!$H$10","v":"01. Dezember 2016"},{"$f":"November!$F$14","v":0},{"$f":"November!$F$15","v":0},0]
[]
[null,"vertraglich belegte Plätze",{"$f":"SUM(C9:C21)","v":129},{"$f":"SUM(D9:D21)","v":339},{"$f":"SUM(E9:E21)","v":468}]
[]
[]
[null,"Anzahl der Kinder im Alter vom 3. Lebensjahr bis zum Schuleintritt"]
[null,"Betreuungsumfang gem. § 1 KitaG"]
[]
[null,"Stichtage","bis 6 h","ab 6 h","gesamt"]
[null,{"$f":"\"01. Januar \"&Datenblatt!$H$10","v":"01. Januar 2016"},{"$f":"'01.12.'!$F$18","v":29},{"$f":"'01.12.'!$F$19","v":78},{"$f":"SUM(C29:D29)","v":107}]
[null,{"$f":"\"01. Februar \"&Datenblatt!$H$10","v":"01. Februar 2016"},{"$f":"Januar!$F$18","v":29},{"$f":"Januar!$F$19","v":78},{"$f":"SUM(C30:D30)","v":107}]
[null,{"$f":"\"01. März \"&Datenblatt!$H$10","v":"01. März 2016"},{"$f":"Februar!$F$18","v":29},{"$f":"Februar!$F$19","v":78},107]
[null,{"$f":"\"01. April \"&Datenblatt!$H$10","v":"01. April 2016"},{"$f":"'01.03.'!$F$18","v":30},{"$f":"'01.03.'!$F$19","v":85},115]
[null,{"$f":"\"01. Mai \"&Datenblatt!$H$10","v":"01. Mai 2016"},{"$f":"April!$F$18","v":30},{"$f":"April!$F$19","v":85},115]
[null,{"$f":"\"01. Juni \"&Datenblatt!$H$10","v":"01. Juni 2016"},{"$f":"Mai!$F$18","v":30},{"$f":"Mai!$F$19","v":85},115]
[null,{"$f":"\"01. Juli \"&Datenblatt!$H$10","v":"01. Juli 2016"},{"$f":"'01.06.'!$F$18","v":30},{"$f":"'01.06.'!$F$19","v":94},124]
[null,{"$f":"\"01. Agust \"&Datenblatt!$H$10","v":"01. Agust 2016"},{"$f":"Juli!$F$18","v":30},{"$f":"Juli!$F$19","v":94},124]
[null,{"$f":"\"01. September \"&Datenblatt!$H$10","v":"01. September 2016"},{"$f":"August!$F$18","v":30},{"$f":"August!$F$19","v":94},124]
[null,{"$f":"\"01. Oktober \"&Datenblatt!$H$10","v":"01. Oktober 2016"},{"$f":"'01.09.'!$F$18","v":0},{"$f":"'01.09.'!$F$19","v":0},0]
[null,{"$f":"\"01. November \"&Datenblatt!$H$10","v":"01. November 2016"},{"$f":"Oktober!$F$18","v":0},{"$f":"Oktober!$F$19","v":0},0]
[null,{"$f":"\"01. Dezember \"&Datenblatt!$H$10","v":"01. Dezember 2016"},{"$f":"November!$F$18","v":0},{"$f":"November!$F$19","v":0},0]
[]
[null,"vertraglich belegte Plätze",{"$f":"SUM(C29:C41)","v":267},{"$f":"SUM(D29:D41)","v":771},{"$f":"SUM(E29:E41)","v":1038}]
[]
[]
[null,"Anzahl der Kinder im Grundschulalter"]
[null,"Betreuungsumfang gem. § 1 KitaG"]
[]
[null,"Stichtage","bis 6 h","ab 6 h","gesamt"]
[null,{"$f":"\"01. Januar \"&Datenblatt!$H$10","v":"01. Januar 2016"},{"$f":"'01.12.'!$F$22","v":4},{"$f":"'01.12.'!$F$23","v":0},{"$f":"SUM(C49:D49)","v":4}]
[null,{"$f":"\"01. Februar \"&Datenblatt!$H$10","v":"01. Februar 2016"},{"$f":"Januar!$F$22","v":4},{"$f":"Januar!$F$23","v":0},{"$f":"SUM(C50:D50)","v":4}]
[null,{"$f":"\"01. März \"&Datenblatt!$H$10","v":"01. März 2016"},{"$f":"Februar!$F$22","v":4},{"$f":"Februar!$F$23","v":0},4]
[null,{"$f":"\"01. April \"&Datenblatt!$H$10","v":"01. April 2016"},{"$f":"'01.03.'!$F$22","v":0},{"$f":"'01.03.'!$F$23","v":0},0]
[null,{"$f":"\"01. Mai \"&Datenblatt!$H$10","v":"01. Mai 2016"},{"$f":"April!$F$22","v":0},{"$f":"April!$F$23","v":0},0]
[null,{"$f":"\"01. Juni \"&Datenblatt!$H$10","v":"01. Juni 2016"},{"$f":"Mai!$F$22","v":0},{"$f":"Mai!$F$23","v":0},0]
[null,{"$f":"\"01. Juli \"&Datenblatt!$H$10","v":"01. Juli 2016"},{"$f":"'01.06.'!$F$22","v":0},{"$f":"'01.06.'!$F$23","v":0},0]
[null,{"$f":"\"01. Agust \"&Datenblatt!$H$10","v":"01. Agust 2016"},{"$f":"Juli!$F$22","v":0},{"$f":"Juli!$F$23","v":0},0]
[null,{"$f":"\"01. September \"&Datenblatt!$H$10","v":"01. September 2016"},{"$f":"August!$F$22","v":0},{"$f":"August!$F$23","v":0},0]
[null,{"$f":"\"01. Oktober \"&Datenblatt!$H$10","v":"01. Oktober 2016"},{"$f":"'01.09.'!$F$22","v":0},{"$f":"'01.09.'!$F$23","v":0},0]
[null,{"$f":"\"01. November \"&Datenblatt!$H$10","v":"01. November 2016"},{"$f":"Oktober!$F$22","v":0},{"$f":"Oktober!$F$23","v":0},0]
[null,{"$f":"\"01. Dezember \"&Datenblatt!$H$10","v":"01. Dezember 2016"},{"$f":"November!$F$22","v":0},{"$f":"November!$F$23","v":0},0]
[]
[null,"vertraglich belegte Plätze",{"$f":"SUM(C49:C61)","v":12},{"$f":"SUM(D49:D61)","v":0},{"$f":"SUM(E49:E61)","v":12}]
[]
[]
[null,"Kinder im Grundschulalter"]
[null,"Betreuungszeit gem. § 3 Kita Pers. VO"]
[]
[null,null,"bis 4 Std.","ab 4 h","gesamt"]
[null,"2009-12-01",{"$f":"'01.12.'!#REF!","v":{"$error":"#REF!"}},{"$f":"'01.12.'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C69:D69)","v":{"$error":"#REF!"}}]
[null,"2010-03-01",{"$f":"'01.03.'!#REF!","v":{"$error":"#REF!"}},{"$f":"'01.03.'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C70:D70)","v":{"$error":"#REF!"}}]
[null,"2010-06-01",{"$f":"'01.06.'!#REF!","v":{"$error":"#REF!"}},{"$f":"'01.06.'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C71:D71)","v":{"$error":"#REF!"}}]
[null,"2010-09-01",{"$f":"'01.09.'!#REF!","v":{"$error":"#REF!"}},{"$f":"'01.09.'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C72:D72)","v":{"$error":"#REF!"}}]
[]
[null,"vertraglich belegte Plätze",{"$f":"SUM(C69:C72)","v":{"$error":"#REF!"}},{"$f":"SUM(D69:D72)","v":{"$error":"#REF!"}},{"$f":"SUM(E69:E72)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Auswertung"]
[]
[null,{"$f":"\"Auslastung \"&Datenblatt!H10","v":"Auslastung 2016"},"Kapazität","Belegung \ngesamt","Auslastung in %"]
[null,{"$f":"\"01. Januar \"&Datenblatt!$H$10","v":"01. Januar 2016"},{"$f":"'01.12.'!D9","v":167},{"$f":"IF(SUMIF($B$8:$B$62,B80,$E$8:$E$62)=0,\"\",SUMIF($B$8:$B$62,B80,$E$8:$E$62))","v":168},{"$f":"IF(OR($C80=\"\",$D80=\"\"),\"\",$D80/$C80)","v":1.0059880239520957}]
[null,{"$f":"\"01. Februar \"&Datenblatt!$H$10","v":"01. Februar 2016"},{"$f":"IF(Januar!$D$9=0,\"\",Januar!$D$9)","v":167},{"$f":"IF(SUMIF($B$8:$B$62,B81,$E$8:$E$62)=0,\"\",SUMIF($B$8:$B$62,B81,$E$8:$E$62))","v":168},1.0059880239520957]
[null,{"$f":"\"01. März \"&Datenblatt!$H$10","v":"01. März 2016"},{"$f":"IF(Februar!$D$9=0,\"\",Februar!$D$9)","v":167},168,1.0059880239520957]
[null,{"$f":"\"01. April \"&Datenblatt!$H$10","v":"01. April 2016"},{"$f":"IF('01.03.'!$D$9=0,\"\",'01.03.'!$D$9)","v":167},168,1.0059880239520957]
[null,{"$f":"\"01. Mai \"&Datenblatt!$H$10","v":"01. Mai 2016"},{"$f":"IF(April!$D$9=0,\"\",April!$D$9)","v":167},168,1.0059880239520957]
[null,{"$f":"\"01. Juni \"&Datenblatt!$H$10","v":"01. Juni 2016"},{"$f":"IF(Mai!$D$9=0,\"\",Mai!$D$9)","v":167},168,1.0059880239520957]
[null,{"$f":"\"01. Juli \"&Datenblatt!$H$10","v":"01. Juli 2016"},{"$f":"IF('01.06.'!$D$9=0,\"\",'01.06.'!$D$9)","v":167},170,1.0179640718562875]
[null,{"$f":"\"01. Agust \"&Datenblatt!$H$10","v":"01. Agust 2016"},{"$f":"IF(Juli!$D$9=0,\"\",Juli!$D$9)","v":167},170,1.0179640718562875]
[null,{"$f":"\"01. September \"&Datenblatt!$H$10","v":"01. September 2016"},{"$f":"IF(August!$D$9=0,\"\",August!$D$9)","v":167},170,1.0179640718562875]
[null,{"$f":"\"01. Oktober \"&Datenblatt!$H$10","v":"01. Oktober 2016"},{"$f":"IF('01.09.'!$D$9=0,\"\",'01.09.'!$D$9)","v":167},"",""]
[null,{"$f":"\"01. November \"&Datenblatt!$H$10","v":"01. November 2016"},{"$f":"IF(Oktober!$D$9=0,\"\",Oktober!$D$9)","v":167},"",""]
[null,{"$f":"\"01. Dezember \"&Datenblatt!$H$10","v":"01. Dezember 2016"},{"$f":"IF(November!$D$9=0,\"\",November!$D$9)","v":167},"",""]
[null,"Belegung Gesamt",null,{"$f":"SUM(D80:D91)","v":1518}]
[null,"Monatsdurchschnitt",{"$f":"IF(ISERROR(SUM(C80:C91)/COUNT(C80:C91)),\"\",SUM(C80:C91)/COUNT(C80:C91))","v":167},{"$f":"IF(ISERROR(D92/COUNT(D80:D91)),\"\",D92/COUNT(D80:D91))","v":168.66666666666666},{"$f":"IF(OR($C93=\"\",$D93=\"\"),\"\",$D93/$C93)","v":1.0099800399201597}]
[]
[null,{"$f":"\"Gesamt Elternbeiträge \"&Datenblatt!H10","v":"Gesamt Elternbeiträge 2016"},null,null,75000]
[null,{"$f":"\"Durschnittlicher Elternbeitrag \"&Datenblatt!H10","v":"Durschnittlicher Elternbeitrag 2016"},null,null,{"$f":"IF(OR(D93=\"\",E95=\"\"),\"\",E95/D93)","v":444.66403162055337}]

{"sheet":"Personalstunden","index":17,"n_rows":145,"n_cols":30,"rows_kept":145,"cut":false,"hidden":false,"merged":[[4,26,5,26],[68,6,68,8],[68,10,68,12],[68,14,68,16],[68,18,68,20],[68,26,69,26],[4,24,5,24],[66,1,66,22],[57,1,57,22],[53,1,53,2],[54,1,54,2],[1,1,1,22],[4,6,4,8],[4,10,4,12],[4,14,4,16],[4,18,4,20],[73,1,73,2],[84,1,84,2],[95,1,95,2],[106,1,106,2],[107,28,116,30]]}
[]
[null,{"$f":"\"Personaleinsatz des notwendigen pädagogischen Personals \"&Datenblatt!E8&Datenblatt!H10","v":"Personaleinsatz des notwendigen pädagogischen Personals Durchblick2016"}]
[]
[]
[null,null,null,null,"4. Quartal",null,{"$f":"\"1. Quartal \"&Datenblatt!$H$10","v":"1. Quartal 2016"},null,null,null,{"$f":"\"2. Quartal \"&Datenblatt!$H$10","v":"2. Quartal 2016"},null,null,null,{"$f":"\"3. Quartal \"&Datenblatt!$H$10","v":"3. Quartal 2016"},null,null,null,{"$f":"\"4. Quartal \"&Datenblatt!$H$10","v":"4. Quartal 2016"},null,null,null,"Jahres-Ø",null,"Leere Zeilen\nPrüfung","ldf.","Anmerkungen"]
[null,"lfd.Nr.","Personal",null,{"$f":"'01.12.'!I6","v":"01.12.2015"},null,{"$f":"Januar!$I$6","v":"01.01.2016"},{"$f":"Februar!$I$6","v":"01.02.2016"},{"$f":"'01.03.'!$I$6","v":"01.03.2016"},null,{"$f":"April!I6","v":"01.04.2016"},{"$f":"Mai!I6","v":"01.05.2016"},{"$f":"'01.06.'!I6","v":"01.06.2016"},null,{"$f":"Juli!$I$6","v":"01.07.2016"},{"$f":"August!$I$6","v":"01.08.2016"},{"$f":"'01.09.'!$I$6","v":"01.09.2016"},null,{"$f":"Oktober!$I$6","v":"01.10.2016"},{"$f":"November!$I$6","v":"01.11.2016"},{"$f":"Dezember!$I$6","v":"01.12.2016"},null,{"$f":"Datenblatt!H10","v":2016},null,null,"Nr."]
[null,{"$f":"IF(C7=\"\",\"\",1)","v":1},{"$f":"IF(Datenblatt!B37=\"\",\"\",Datenblatt!B37)","v":"Mozart"},null,35,null,37,37,{"$f":"37+2","v":39},null,40,{"$f":"K7","v":40},40,null,40,35,40,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G7:U7)/COUNT(G7:U7),2)),\"\",ROUND(SUM(G7:U7)/COUNT(G7:U7),2))","v":38.67},null,{"$f":"IF(C7=\"\",\"x\",\"\")","v":""},{"$f":"B7","v":1},null,null,{"$f":"AVERAGE(G7:I7)","v":37.666666666666664},{"$f":"IF(AC7=Jahresdurchschnitt!E7,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C8=\"\",\"\",MAX($B$7:B7)+1)","v":2},{"$f":"IF(Datenblatt!B38=\"\",\"\",Datenblatt!B38)","v":"Beethoven"},null,35,null,37,37,{"$f":"37+2","v":39},null,40,40,40,null,36,35,40,null,null,null,null,null,38.22,null,{"$f":"IF(C8=\"\",\"x\",\"\")","v":""},2,null,null,{"$f":"AVERAGE(G8:I8)","v":37.666666666666664},{"$f":"IF(AC8=Jahresdurchschnitt!E8,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C9=\"\",\"\",MAX($B$7:B8)+1)","v":3},{"$f":"IF(Datenblatt!B39=\"\",\"\",Datenblatt!B39)","v":"Chopin "},null,17.5,null,{"$f":"E9","v":17.5},{"$f":"G9","v":17.5},{"$f":"H9","v":17.5},null,{"$f":"I9","v":17.5},17.5,17.5,null,{"$f":"M9","v":17.5},{"$f":"O9","v":17.5},{"$f":"P9","v":17.5},null,{"$f":"Q9","v":17.5},{"$f":"S9","v":17.5},17.5,null,17.5,null,"",3,"Anrechnung mit 70% von 25 Wochenstunden",null,17.5,{"$f":"IF(AC9=Jahresdurchschnitt!E9,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C10=\"\",\"\",MAX($B$7:B9)+1)","v":4},{"$f":"IF(Datenblatt!B40=\"\",\"\",Datenblatt!B40)","v":"Donizetti"},null,36,null,37,37,{"$f":"37+2","v":39},null,40,40,40,null,36,35,40,null,null,null,null,null,38.22,null,"",4,null,null,37.666666666666664,{"$f":"IF(AC10=Jahresdurchschnitt!E10,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C11=\"\",\"\",MAX($B$7:B10)+1)","v":5},{"$f":"IF(Datenblatt!B41=\"\",\"\",Datenblatt!B41)","v":"Bruckner "},null,35,null,37,37,{"$f":"37+2","v":39},null,40,40,40,null,36,35,40,null,null,null,null,null,38.22,null,"",5,null,null,37.666666666666664,{"$f":"IF(AC11=Jahresdurchschnitt!E11,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C12=\"\",\"\",MAX($B$7:B11)+1)","v":6},{"$f":"IF(Datenblatt!B42=\"\",\"\",Datenblatt!B42)","v":"Britten "},null,35,null,35,37,{"$f":"37+2","v":39},null,40,40,40,null,36,35,40,null,null,null,null,null,38,null,"",6,null,null,37,{"$f":"IF(AC12=Jahresdurchschnitt!E12,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C13=\"\",\"\",MAX($B$7:B12)+1)","v":7},{"$f":"IF(Datenblatt!B43=\"\",\"\",Datenblatt!B43)","v":"Händel "},null,30,null,{"$f":"E13","v":30},{"$f":"G13","v":30},{"$f":"H13-I117","v":30},null,{"$f":"I13","v":30},30,30,null,{"$f":"40-10-O117","v":30},{"$f":"40-10-P117","v":30},{"$f":"40-10-Q117","v":30},null,null,null,null,null,30,null,"",7,null,null,30,{"$f":"IF(AC13=Jahresdurchschnitt!E13,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C14=\"\",\"\",MAX($B$7:B13)+1)","v":8},{"$f":"IF(Datenblatt!B44=\"\",\"\",Datenblatt!B44)","v":"Haydn"},null,3.25,null,20,20,{"$f":"H14","v":20},null,{"$f":"40-K75-K86-K97","v":1},{"$f":"40-L75-L86-L97","v":1},{"$f":"40-M75-M86-M97","v":1},null,{"$f":"40-O75-O86-O97","v":2.5},{"$f":"40-P75-P86-P97","v":2.5},{"$f":"40-Q75-Q86-Q97","v":2.5},null,null,null,null,null,7.83,null,"",8,null,null,20,{"$f":"IF(AC14=Jahresdurchschnitt!E14,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C15=\"\",\"\",MAX($B$7:B14)+1)","v":9},{"$f":"IF(Datenblatt!B45=\"\",\"\",Datenblatt!B45)","v":"Offenbach "},null,34,null,35,35,35,null,{"$f":"I15","v":35},5,5,null,{"$f":"M15","v":5},{"$f":"O15","v":5},5,null,null,null,null,null,18.329999999999998,null,"",9,null,null,35,{"$f":"IF(AC15=Jahresdurchschnitt!E15,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C16=\"\",\"\",MAX($B$7:B15)+1)","v":10},{"$f":"IF(Datenblatt!B46=\"\",\"\",Datenblatt!B46)","v":"Rossini "},null,19,null,{"$f":"E16","v":19},{"$f":"G16","v":19},19,null,{"$f":"I16","v":19},19,19,null,19,19,19,null,24,null,null,null,19.5,null,"",10,"ab 12/2014 Altersteilzeit - 19 h unverändert  Freiphase ab 01/2018",null,19,{"$f":"IF(AC16=Jahresdurchschnitt!E16,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C17=\"\",\"\",MAX($B$7:B16)+1)","v":11},{"$f":"IF(Datenblatt!B47=\"\",\"\",Datenblatt!B47)","v":"Ravel "},null,20,null,{"$f":"E17","v":20},20,{"$f":"H17-I116","v":20},null,{"$f":"I17","v":20},20,21,null,{"$f":"40-10-O52-O116","v":20},{"$f":"40-10-P52-P116","v":20},{"$f":"40-10-Q52-Q116","v":20},null,null,null,null,null,20.11,null,"",11,null,null,20,{"$f":"IF(AC17=Jahresdurchschnitt!E17,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C18=\"\",\"\",MAX($B$7:B17)+1)","v":12},{"$f":"IF(Datenblatt!B48=\"\",\"\",Datenblatt!B48)","v":"Salieri"},null,39,null,38,38,38,null,{"$f":"I18","v":38},38,38,null,{"$f":"40-O138","v":39},{"$f":"36-P138","v":35},{"$f":"40-Q138","v":39},null,{"$f":"Q18","v":39},39,39,null,38.17,null,"",12,null,null,38,{"$f":"IF(AC18=Jahresdurchschnitt!E18,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C19=\"\",\"\",MAX($B$7:B18)+1)","v":13},{"$f":"IF(Datenblatt!B49=\"\",\"\",Datenblatt!B49)","v":"Verdi "},null,0,null,0,38,{"$f":"H19","v":38},null,35,35,35,null,{"$f":"M19","v":35},{"$f":"O19","v":35},35,null,null,null,null,null,31.78,null,"",13,"ab 04/2014 nur noch 35 h",null,25.333333333333332,{"$f":"IF(AC19=Jahresdurchschnitt!E19,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C20=\"\",\"\",MAX($B$7:B19)+1)","v":14},{"$f":"IF(Datenblatt!B50=\"\",\"\",Datenblatt!B50)","v":"Vivaldi "},null,30,null,{"$f":"E20","v":30},{"$f":"G20","v":30},{"$f":"H20","v":30},null,{"$f":"I20","v":30},30,30,null,{"$f":"M20","v":30},30,30,null,null,null,null,null,30,null,"",14,"Stundenreduzierung ab 10/2011 auf 30 Wo-Stunden",null,30,{"$f":"IF(AC20=Jahresdurchschnitt!E20,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C21=\"\",\"\",MAX($B$7:B20)+1)","v":15},{"$f":"IF(Datenblatt!B51=\"\",\"\",Datenblatt!B51)","v":"Wagner "},null,35,null,37,37,38,null,39,39,39,null,{"$f":"37-O145","v":37},{"$f":"36-P145","v":36},{"$f":"40-Q145","v":40},null,null,null,null,null,38,null,"",15,null,null,37.333333333333336,{"$f":"IF(AC21=Jahresdurchschnitt!E21,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C22=\"\",\"\",MAX($B$7:B21)+1)","v":16},{"$f":"IF(Datenblatt!B52=\"\",\"\",Datenblatt!B52)","v":"Tschaikowsky"},null,34,null,38,38,{"$f":"38-I108","v":36},null,{"$f":"I22","v":36},36,36,null,{"$f":"40-O108-O122","v":36},{"$f":"40-P108-P122","v":30},{"$f":"40-Q108-Q122","v":30},null,null,null,null,null,35.11,null,"",16,null,null,37.333333333333336,{"$f":"IF(AC22=Jahresdurchschnitt!E22,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C23=\"\",\"\",MAX($B$7:B22)+1)","v":17},{"$f":"IF(Datenblatt!B53=\"\",\"\",Datenblatt!B53)","v":"Puccini "},null,30,null,{"$f":"E23","v":30},{"$f":"G23","v":30},30,null,{"$f":"I23","v":30},{"$f":"K23","v":30},30,null,{"$f":"M23","v":30},{"$f":"O23","v":30},{"$f":"P23","v":30},null,null,null,null,null,30,null,"",17,null,null,30,{"$f":"IF(AC23=Jahresdurchschnitt!E23,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C24=\"\",\"\",MAX($B$7:B23)+1)","v":18},{"$f":"IF(Datenblatt!B54=\"\",\"\",Datenblatt!B54)","v":"Sibelius "},null,17.5,null,{"$f":"E24","v":17.5},17.5,17.5,null,{"$f":"I24","v":17.5},17.5,17.5,null,36,35,40,null,null,null,null,null,24,null,"",18,"Anrechnung mit 70% von 25 Wochenstunden-Ausbildung beendet zum 30.06.2014 ab 07/2014 Stundenangleich p.P.",null,17.5,{"$f":"IF(AC24=Jahresdurchschnitt!E24,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C25=\"\",\"\",MAX($B$7:B24)+1)","v":19},{"$f":"IF(Datenblatt!B55=\"\",\"\",Datenblatt!B55)","v":"Smetana "},null,35,null,37,37,{"$f":"37+2","v":39},null,40,40,40,null,36,35,40,null,null,null,null,null,38.22,null,"",19,null,null,37.666666666666664,{"$f":"IF(AC25=Jahresdurchschnitt!E25,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C26=\"\",\"\",MAX($B$7:B25)+1)","v":20},{"$f":"IF(Datenblatt!B56=\"\",\"\",Datenblatt!B56)","v":"Schumann "},null,35,null,37,37,{"$f":"37+2","v":39},null,40,40,40,null,36,35,40,null,null,null,null,null,38.22,null,"",20,null,null,37.666666666666664,{"$f":"IF(AC26=Jahresdurchschnitt!E26,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C27=\"\",\"\",MAX($B$7:B26)+1)","v":21},{"$f":"IF(Datenblatt!B57=\"\",\"\",Datenblatt!B57)","v":"Orff "},null,34,null,33,{"$f":"G27","v":33},{"$f":"H27","v":33},null,33,33,33,null,{"$f":"40-O98-O131-O144","v":36},{"$f":"40-P98-P131-P144","v":36},{"$f":"40-Q98-Q131-Q144","v":36},null,null,null,null,null,34,null,"",21,null,null,33,{"$f":"IF(AC27=Jahresdurchschnitt!E27,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C28=\"\",\"\",MAX($B$7:B27)+1)","v":22},{"$f":"IF(Datenblatt!B58=\"\",\"\",Datenblatt!B58)","v":"Pompadour "},null,35,null,38,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,3.17,null,"",22,"Kündigung zum 31.01.",null,12.666666666666666,{"$f":"IF(AC28=Jahresdurchschnitt!E28,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C29=\"\",\"\",MAX($B$7:B28)+1)","v":23},{"$f":"IF(Datenblatt!B59=\"\",\"\",Datenblatt!B59)","v":"Diderot "},null,35,null,37,37,39,null,40,{"$f":"K29","v":40},{"$f":"L29","v":40},null,36,35,40,null,null,null,null,null,38.22,null,"",23,null,null,37.666666666666664,{"$f":"IF(AC29=Jahresdurchschnitt!E29,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C30=\"\",\"\",MAX($B$7:B29)+1)","v":24},{"$f":"IF(Datenblatt!B60=\"\",\"\",Datenblatt!B60)","v":"Max"},null,20,null,35,20,20,20,20,25,25,null,20,20,20,null,null,null,null,null,22.5,null,"",24,null,null,25,{"$f":"IF(AC30=Jahresdurchschnitt!E30,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C31=\"\",\"\",MAX($B$7:B30)+1)","v":25},{"$f":"IF(Datenblatt!B61=\"\",\"\",Datenblatt!B61)","v":"Peter"},null,8,null,35,35,35,null,35,35,35,null,35,35,35,null,0,0,0,null,26.25,null,"",25,null,null,35,{"$f":"IF(AC31=Jahresdurchschnitt!E31,\"OK\",\"Nööööö\")","v":"OK"}]
[null,{"$f":"IF(C32=\"\",\"\",MAX($B$7:B31)+1)","v":26},{"$f":"IF(Datenblatt!B62=\"\",\"\",Datenblatt!B62)","v":"Luise"},null,0,null,0,0,0,null,0,0,30,null,30,40,40,null,null,null,null,null,15.56,null,"",26,null,null,0]
[null,{"$f":"IF(C33=\"\",\"\",MAX($B$7:B32)+1)","v":""},{"$f":"IF(Datenblatt!B63=\"\",\"\",Datenblatt!B63)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G33:U33)/COUNT(G33:U33),2)),\"\",ROUND(SUM(G33:U33)/COUNT(G33:U33),2))","v":""},null,{"$f":"IF(C33=\"\",\"x\",\"\")","v":"x"},{"$f":"B33","v":""},null,null,{"$error":"#DIV/0!"}]
[null,{"$f":"IF(C34=\"\",\"\",MAX($B$7:B33)+1)","v":""},{"$f":"IF(Datenblatt!B64=\"\",\"\",Datenblatt!B64)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G34:U34)/COUNT(G34:U34),2)),\"\",ROUND(SUM(G34:U34)/COUNT(G34:U34),2))","v":""},null,{"$f":"IF(C34=\"\",\"x\",\"\")","v":"x"},{"$f":"B34","v":""},null,null,{"$error":"#DIV/0!"}]
[null,{"$f":"IF(C35=\"\",\"\",MAX($B$7:B34)+1)","v":""},{"$f":"IF(Datenblatt!B65=\"\",\"\",Datenblatt!B65)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x","",null,null,{"$error":"#DIV/0!"}]
[null,{"$f":"IF(C36=\"\",\"\",MAX($B$7:B35)+1)","v":""},{"$f":"IF(Datenblatt!B66=\"\",\"\",Datenblatt!B66)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x",""]
[null,{"$f":"IF(C37=\"\",\"\",MAX($B$7:B36)+1)","v":""},{"$f":"IF(Datenblatt!B67=\"\",\"\",Datenblatt!B67)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x",""]
[null,{"$f":"IF(C38=\"\",\"\",MAX($B$7:B37)+1)","v":""},{"$f":"IF(Datenblatt!B68=\"\",\"\",Datenblatt!B68)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x",""]
[null,{"$f":"IF(C39=\"\",\"\",MAX($B$7:B38)+1)","v":""},{"$f":"IF(Datenblatt!B69=\"\",\"\",Datenblatt!B69)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x",""]
[null,{"$f":"IF(C40=\"\",\"\",MAX($B$7:B39)+1)","v":""},{"$f":"IF(Datenblatt!B70=\"\",\"\",Datenblatt!B70)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x",""]
[null,{"$f":"IF(C41=\"\",\"\",MAX($B$7:B40)+1)","v":""},{"$f":"IF(Datenblatt!B71=\"\",\"\",Datenblatt!B71)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x",""]
[null,{"$f":"IF(C42=\"\",\"\",MAX($B$7:B41)+1)","v":""},{"$f":"IF(Datenblatt!B72=\"\",\"\",Datenblatt!B72)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x",""]
[null,{"$f":"IF(C43=\"\",\"\",MAX($B$7:B42)+1)","v":""},{"$f":"IF(Datenblatt!B73=\"\",\"\",Datenblatt!B73)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x",""]
[null,{"$f":"IF(C44=\"\",\"\",MAX($B$7:B43)+1)","v":""},{"$f":"IF(Datenblatt!B74=\"\",\"\",Datenblatt!B74)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x",""]
[null,null,"Stunden Päd. Personal",null,{"$f":"IF(COUNT(E7:E44)=COUNT($B$7:$B$44),SUM(E7:E44),\"Daten!\")","v":687.25},null,{"$f":"IF(COUNT(G7:G44)=COUNT($B$7:$B$44),SUM(G7:G44),\"Daten!\")","v":767},{"$f":"IF(COUNT(H7:H44)=COUNT($B$7:$B$44),SUM(H7:H44),\"Daten!\")","v":754},{"$f":"IF(COUNT(I7:I44)=COUNT($B$7:$B$44),SUM(I7:I44),\"Daten!\")","v":769},null,{"$f":"IF(COUNT(K7:K44)=COUNT($B$7:$B$44),SUM(K7:K44),\"Daten!\")","v":756},{"$f":"IF(COUNT(L7:L44)=COUNT($B$7:$B$44),SUM(L7:L44),\"Daten!\")","v":731},{"$f":"IF(COUNT(M7:M44)=COUNT($B$7:$B$44),SUM(M7:M44),\"Daten!\")","v":762},null,{"$f":"IF(COUNT(O7:O44)=COUNT($B$7:$B$44),SUM(O7:O44),\"Daten!\")","v":750},{"$f":"IF(COUNT(P7:P44)=COUNT($B$7:$B$44),SUM(P7:P44),\"Daten!\")","v":736},{"$f":"IF(COUNT(Q7:Q44)=COUNT($B$7:$B$44),SUM(Q7:Q44),\"Daten!\")","v":789},null,{"$f":"IF(COUNT(S7:S44)=COUNT($B$7:$B$44),SUM(S7:S44),\"Daten!\")","v":"Daten!"},{"$f":"IF(COUNT(T7:T44)=COUNT($B$7:$B$44),SUM(T7:T44),\"Daten!\")","v":"Daten!"},{"$f":"IF(COUNT(U7:U44)=COUNT($B$7:$B$44),SUM(U7:U44),\"Daten!\")","v":"Daten!"},null,757.11]
[]
[null,"Pädagogisches Personal Ist",null,null,{"$f":"IF(E45=\"Daten!\",\"\",E45)","v":687.25},null,{"$f":"IF(G45=\"Daten!\",\"\",G45)","v":767},754,769,null,756,731,762,null,750,736,789,null,"","","",null,{"$f":"IF(ISERROR(ROUND(SUM(G47:U47)/COUNT(G47:U47),2)),\"\",ROUND(SUM(G47:U47)/COUNT(G47:U47),2))","v":757.11}]
[null,"Pädagogischer Leitungsanteil",null,null,20,null,{"$f":"IF(ISERROR('01.12.'!$I$34*40),\"\",'01.12.'!$I$34*40)","v":20},{"$f":"IF(ISERROR(Januar!$I$34*40),\"\",Januar!$I$34*40)","v":20},{"$f":"IF(ISERROR(Februar!$I$34*40),\"\",Februar!$I$34*40)","v":20},null,{"$f":"IF(ISERROR('01.03.'!$I$34*40),\"\",'01.03.'!$I$34*40)","v":20},{"$f":"IF(ISERROR(April!$I$34*40),\"\",April!$I$34*40)","v":20},{"$f":"IF(ISERROR(Mai!$I$34*40),\"\",Mai!$I$34*40)","v":20},null,{"$f":"IF(ISERROR('01.06.'!$I$34*40),\"\",'01.06.'!$I$34*40)","v":20},{"$f":"IF(ISERROR(Juli!$I$34*40),\"\",Juli!$I$34*40)","v":20},{"$f":"IF(ISERROR(August!$I$34*40),\"\",August!$I$34*40)","v":20},null,{"$f":"IF(ISERROR('01.09.'!$I$34*40),\"\",'01.09.'!$I$34*40)","v":""},{"$f":"IF(ISERROR(Oktober!$I$34*40),\"\",Oktober!$I$34*40)","v":""},{"$f":"IF(ISERROR(November!$I$34*40),\"\",November!$I$34*40)","v":""},null,20]
[null,"Pädagogisches Personal Ist - Gesamt",null,null,{"$f":"IF(E47=\"\",\"\",SUM(E47:E48))","v":707.25},null,{"$f":"IF(G47=\"\",\"\",SUM(G47:G48))","v":787},774,789,null,{"$f":"IF(K47=\"\",\"\",SUM(K47:K48))","v":776},751,782,null,{"$f":"IF(O47=\"\",\"\",SUM(O47:O48))","v":770},756,809,null,{"$f":"IF(S47=\"\",\"\",SUM(S47:S48))","v":""},{"$f":"IF(T47=\"\",\"\",SUM(T47:T48))","v":""},"",null,777.11]
[null,"Resultierende VZ-Stellen (Ist)",null,null,{"$f":"IF(E49=\"\",\"\",E49/40)","v":17.681249999999999},null,{"$f":"IF(G49=\"\",\"\",G49/40)","v":19.675000000000001},19.350000000000001,19.725000000000001,null,{"$f":"IF(K49=\"\",\"\",K49/40)","v":19.399999999999999},18.774999999999999,19.55,null,{"$f":"IF(O49=\"\",\"\",O49/40)","v":19.25},18.899999999999999,20.225000000000001,null,{"$f":"IF(S49=\"\",\"\",S49/40)","v":""},{"$f":"IF(T49=\"\",\"\",T49/40)","v":""},"",null,19.43]
[]
[null,"Organisatorischer Leitungsanteil",null,null,10,null,10,{"$f":"G52","v":10},{"$f":"H52","v":10},null,{"$f":"I52","v":10},{"$f":"K52","v":10},{"$f":"L52","v":10},null,{"$f":"M52","v":10},{"$f":"O52","v":10},{"$f":"P52","v":10},null,{"$f":"Q52","v":10},{"$f":"S52","v":10},{"$f":"T52","v":10},null,{"$f":"IF(ISERROR(ROUND(SUM(G52:U52)/COUNT(G52:U52),2)),\"\",ROUND(SUM(G52:U52)/COUNT(G52:U52),2))","v":10}]
[]
[null,"zu finanzierendes Personal  gemäß Stichtag (VZ-Stellen - Soll)",null,null,17.673000000000002,null,{"$f":"IF('01.12.'!I45=0,\"\",'01.12.'!I45)","v":19.757000000000001},{"$f":"IF(Januar!I45=0,\"\",Januar!I45)","v":19.757000000000001},{"$f":"IF(Februar!I45=0,\"\",Februar!I45)","v":19.757000000000001},null,{"$f":"IF('01.03.'!I45=0,\"\",'01.03.'!I45)","v":19.605000000000004},{"$f":"IF(April!I45=0,\"\",April!I45)","v":19.605000000000004},{"$f":"IF(Mai!I45=0,\"\",Mai!I45)","v":19.605000000000004},null,{"$f":"IF('01.06.'!I45=0,\"\",'01.06.'!I45)","v":19.072000000000003},{"$f":"IF(Juli!I45=0,\"\",Juli!I45)","v":19.072000000000003},{"$f":"IF(August!I45=0,\"\",August!I45)","v":19.072000000000003},null,{"$f":"IF('01.09.'!I45=0,\"\",'01.09.'!I45)","v":""},{"$f":"IF(Oktober!I45=0,\"\",Oktober!I45)","v":""},{"$f":"IF(November!I45=0,\"\",November!I45)","v":""},null,19.48]
[null,"zu finanzierendes Personal gemäß Stichtag in Stunden ",null,null,{"$f":"IF(E54=\"\",\"\",E54*40)","v":706.92000000000007},null,{"$f":"IF(G54=\"\",\"\",G54*40)","v":790.28000000000009},790.28000000000009,790.28000000000009,null,{"$f":"IF(K54=\"\",\"\",K54*40)","v":784.20000000000016},784.20000000000016,784.20000000000016,null,{"$f":"IF(O54=\"\",\"\",O54*40)","v":762.88000000000011},762.88000000000011,762.88000000000011,null,{"$f":"IF(S54=\"\",\"\",S54*40)","v":""},{"$f":"IF(T54=\"\",\"\",T54*40)","v":""},"",null,779.12]
[]
[]
[null,"Auswertung: Differenz zwischen dem tatsächlich eingesetzten Personal (Ist) und dem (finanzierten) Soll"]
[]
[null,"Differenz in Wochenstunden (Ist-Soll)",null,null,{"$f":"IF(E45=\"Daten!\",\"\",IF(ISERROR(E49-E55),\"\",E49-E55))","v":0.32999999999992724},null,{"$f":"IF(G45=\"Daten!\",\"\",IF(ISERROR(G49-G55),\"\",G49-G55))","v":-3.2800000000000864},-16.280000000000086,-1.2800000000000864,null,{"$f":"IF(K45=\"Daten!\",\"\",IF(ISERROR(K49-K55),\"\",K49-K55))","v":-8.2000000000001592},-33.200000000000159,-2.2000000000001592,null,{"$f":"IF(O45=\"Daten!\",\"\",IF(ISERROR(O49-O55),\"\",O49-O55))","v":7.1199999999998909},-6.8800000000001091,46.119999999999891,null,{"$f":"IF(S45=\"Daten!\",\"\",IF(ISERROR(S49-S55),\"\",S49-S55))","v":""},"","",null,-2.0099999999999998]
[null,"Spanne in %",null,null,{"$f":"IF(ISERROR(E60/E55),\"\",ROUND(E60/E55,4))","v":5.0000000000000001E-4},null,{"$f":"IF(ISERROR(G60/G55),\"\",G60/G55)","v":-4.1504276965127372E-3},{"$f":"IF(ISERROR(H60/H55),\"\",H60/H55)","v":-2.0600293566837177E-2},-1.619679101078208E-3,null,{"$f":"IF(ISERROR(K60/K55),\"\",K60/K55)","v":-1.0456516194848454E-2},-4.2336138740117511E-2,-2.8054067839838799E-3,null,{"$f":"IF(ISERROR(O60/O55),\"\",O60/O55)","v":9.3330536912750242E-3},-9.0184563758390675E-3,6.0455117449664281E-2,null,{"$f":"IF(ISERROR(S60/S55),\"\",S60/S55)","v":""},"","",null,{"$f":"IF(ISERROR(ROUND(SUM(G61:U61)/COUNT(G61:U61),4)),\"\",ROUND(SUM(G61:U61)/COUNT(G61:U61),4))","v":-2.3999999999999998E-3}]
[null,"Jahresdurchschnitt",null,null,null,null,{"$f":"G61","v":-4.1504276965127372E-3},{"$f":"SUM(G61:H61)","v":-2.4750721263349915E-2},{"$f":"SUM(G61:I61)","v":-2.6370400364428122E-2},null,{"$f":"SUM(G61:K61)","v":-3.6826916559276578E-2},{"$f":"SUM(G61:L61)","v":-7.9163055299394089E-2},{"$f":"SUM(G61:M61)","v":-8.1968462083377963E-2},null,{"$f":"SUM(G61:O61)","v":-7.2635408392102946E-2},{"$f":"SUM(G61:P61)","v":-8.1653864767942008E-2},{"$f":"SUM(G61:Q61)","v":-2.1198747318277728E-2},null,{"$f":"SUM(G61:S61)","v":-2.1198747318277728E-2},{"$f":"SUM(G61:T61)","v":-2.1198747318277728E-2},{"$f":"SUM(G61:U61)","v":-2.1198747318277728E-2},null,{"$f":"U62","v":-2.1198747318277728E-2}]
[]
[null,"Quartalspuffer für Jahresausgleich",null,null,null,null,null,{"$f":"G5","v":"1. Quartal 2016"},{"$f":"IF(ISERROR(ROUND((SUM(G60:I60)/COUNT(G60:I60))/40,2)),\"\",ROUND((SUM(G60:I60)/COUNT(G60:I60))/40,2))","v":-0.17},null,null,{"$f":"K5","v":"2. Quartal 2016"},{"$f":"IF(ISERROR(ROUND((SUM(K60:M60)/COUNT(K60:M60))/40,2)),\"\",ROUND((SUM(K60:M60)/COUNT(K60:M60))/40,2))","v":-0.36},null,null,{"$f":"O5","v":"3. Quartal 2016"},{"$f":"IF(ISERROR(ROUND((SUM(O60:Q60)/COUNT(O60:Q60))/40,2)),\"\",ROUND((SUM(O60:Q60)/COUNT(O60:Q60))/40,2))","v":0.39},null,null,{"$f":"S5","v":"4. Quartal 2016"},{"$f":"IF(ISERROR(ROUND((SUM(S60:U60)/COUNT(S60:U60))/40,2)),\"\",ROUND((SUM(S60:U60)/COUNT(S60:U60))/40,2))","v":""},null,{"$f":"IF(ISERROR(ROUND(SUM(G64:U64)/COUNT(G64:U64),4)),\"\",ROUND(SUM(G64:U64)/COUNT(G64:U64),4))","v":-4.6699999999999998E-2}]
[]
[]
[null,"Zusatzfinanzierungen aus Sonderprogrammen"]
[]
[null,null,null,null,"4. Quartal",null,{"$f":"\"1. Quartal \"&Datenblatt!$H$10","v":"1. Quartal 2016"},null,null,null,{"$f":"\"2. Quartal \"&Datenblatt!$H$10","v":"2. Quartal 2016"},null,null,null,{"$f":"\"3. Quartal \"&Datenblatt!$H$10","v":"3. Quartal 2016"},null,null,null,{"$f":"\"4. Quartal \"&Datenblatt!$H$10","v":"4. Quartal 2016"},null,null,null,"Jahres-Ø",null,null,null,"Anmerkungen"]
[null,"lfd.Nr.","Personal",null,{"$f":"'01.12.'!I6","v":"01.12.2015"},null,{"$f":"Januar!$I$6","v":"01.01.2016"},{"$f":"Februar!$I$6","v":"01.02.2016"},{"$f":"'01.03.'!$I$6","v":"01.03.2016"},null,{"$f":"April!I6","v":"01.04.2016"},{"$f":"Mai!I6","v":"01.05.2016"},{"$f":"'01.06.'!I6","v":"01.06.2016"},null,{"$f":"Juli!$I$6","v":"01.07.2016"},{"$f":"August!$I$6","v":"01.08.2016"},{"$f":"'01.09.'!$I$6","v":"01.09.2016"},null,{"$f":"Oktober!$I$6","v":"01.10.2016"},{"$f":"November!$I$6","v":"01.11.2016"},{"$f":"Dezember!$I$6","v":"01.12.2016"},null,{"$f":"Datenblatt!H10","v":2016}]
[]
[null,"Ergänzende Bundes- und Landesprojekte"]
[]
[null,"Bundesprogramm Sprach-Kitas ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G74:U74)/COUNT(G74:U74),2)),\"\",ROUND(SUM(G74:U74)/COUNT(G74:U74),2))","v":""},null,{"$f":"IF(AND(B74=\"\",C74=\"\"),\"x\",\"\")","v":""}]
[null,null,"xyz",null,19.25,null,19.25,19.25,19.25,null,19.25,19.25,19.25,null,19.25,19.25,19.25,null,19.25,19.25,19.25,null,19.25,null,{"$f":"IF(AND(B75=\"\",C75=\"\"),\"x\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G76:U76)/COUNT(G76:U76),2)),\"\",ROUND(SUM(G76:U76)/COUNT(G76:U76),2))","v":""},null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G78:U78)/COUNT(G78:U78),2)),\"\",ROUND(SUM(G78:U78)/COUNT(G78:U78),2))","v":""},null,{"$f":"IF(AND(B78=\"\",C78=\"\"),\"x\",\"\")","v":"x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G80:U80)/COUNT(G80:U80),2)),\"\",ROUND(SUM(G80:U80)/COUNT(G80:U80),2))","v":""},null,"x"]
[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(B81=\"\",C81=\"\"),\"x\",\"\")","v":"x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G82:U82)/COUNT(G82:U82),2)),\"\",ROUND(SUM(G82:U82)/COUNT(G82:U82),2))","v":""},null,{"$f":"IF(AND(B82=\"\",C82=\"\"),\"x\",\"\")","v":"x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,"Landesprogramm-Sprachberatung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,"Ravel ",null,9.5,null,11.75,{"$f":"G86","v":11.75},{"$f":"H86","v":11.75},null,15.75,{"$f":"K86","v":15.75},15.75,null,14.25,14.25,14.25,null,15.25,15.25,{"$f":"T86","v":15.25},null,14.25,null,""]
[null,null,"Haydn",null,15,null,3,15,3,null,15,15,15,null,30,15,15,null,15,15,15,null,{"$f":"IF(ISERROR(ROUND(SUM(G87:U87)/COUNT(G87:U87),2)),\"\",ROUND(SUM(G87:U87)/COUNT(G87:U87),2))","v":14.25},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G89:U89)/COUNT(G89:U89),2)),\"\",ROUND(SUM(G89:U89)/COUNT(G89:U89),2))","v":""},null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G90:U90)/COUNT(G90:U90),2)),\"\",ROUND(SUM(G90:U90)/COUNT(G90:U90),2))","v":""},null,{"$f":"IF(AND(B90=\"\",C90=\"\"),\"x\",\"\")","v":"x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G91:U91)/COUNT(G91:U91),2)),\"\",ROUND(SUM(G91:U91)/COUNT(G91:U91),2))","v":""},null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G92:U92)/COUNT(G92:U92),2)),\"\",ROUND(SUM(G92:U92)/COUNT(G92:U92),2))","v":""},null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G95:U95)/COUNT(G95:U95),2)),\"\",ROUND(SUM(G95:U95)/COUNT(G95:U95),2))","v":""},null,"x"]
[null,"Konsultationskita Brandenburg (KOKIB)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,"Mozart",null,null,null,4,{"$f":"G97","v":4},{"$f":"H97","v":4},null,4,4,4,null,4,4,4,null,4,4,4,null,4,null,""]
[null,null,"Offenbach ",null,null,null,4,{"$f":"G98","v":4},{"$f":"H98","v":4},null,4,4,4,null,4,4,4,null,4,4,4,null,4,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G101:U101)/COUNT(G101:U101),2)),\"\",ROUND(SUM(G101:U101)/COUNT(G101:U101),2))","v":""},null,{"$f":"IF(AND(B101=\"\",C101=\"\"),\"x\",\"\")","v":"x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G102:U102)/COUNT(G102:U102),2)),\"\",ROUND(SUM(G102:U102)/COUNT(G102:U102),2))","v":""},null,{"$f":"IF(AND(B102=\"\",C102=\"\"),\"x\",\"\")","v":"x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G106:U106)/COUNT(G106:U106),2)),\"\",ROUND(SUM(G106:U106)/COUNT(G106:U106),2))","v":""},null,"x"]
[null,"Landeskonzept xy ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,"Tschaikowsky",null,null,null,null,null,2,null,2,2,2,null,2,6,6,null,6,6,6,null,4,null,"",null,null,null,"rote zahlen da ungedeckte Planung"]
[null,null,"Max",null,null,null,null,null,4,null,4,4,4,null,4,1,1,null,1,1,1,null,{"$f":"IF(ISERROR(ROUND(SUM(G109:U109)/COUNT(G109:U109),2)),\"\",ROUND(SUM(G109:U109)/COUNT(G109:U109),2))","v":2.5},null,""]
[null,null,"Peter",null,null,null,null,null,4,null,4,4,4,null,4,4,4,null,4,4,4,null,{"$f":"IF(ISERROR(ROUND(SUM(G110:U110)/COUNT(G110:U110),2)),\"\",ROUND(SUM(G110:U110)/COUNT(G110:U110),2))","v":4},null,{"$f":"IF(AND(B110=\"\",C110=\"\"),\"x\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G111:U111)/COUNT(G111:U111),2)),\"\",ROUND(SUM(G111:U111)/COUNT(G111:U111),2))","v":""},null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G112:U112)/COUNT(G112:U112),2)),\"\",ROUND(SUM(G112:U112)/COUNT(G112:U112),2))","v":""},null,"x"]
[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(B113=\"\",C113=\"\"),\"x\",\"\")","v":"x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G115:U115)/COUNT(G115:U115),2)),\"\",ROUND(SUM(G115:U115)/COUNT(G115:U115),2))","v":""},null,{"$f":"IF(AND(B115=\"\",C115=\"\"),\"x\",\"\")","v":"x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x",{"$f":"IF(AND(B117=\"\",C117=\"\"),\"\",\"x\")","v":""}]
[]
[]
[null,"Kompensatorische Srachförderung (sofern als separate Zuwendung finanziert) "]
[]
[null,null,"Pompadour ",null,4,null,2,{"$f":"G122","v":2},{"$f":"H122","v":2},null,2,2,2,null,2,4,4,null,4,4,4,null,{"$f":"IF(ISERROR(ROUND(SUM(G122:U122)/COUNT(G122:U122),2)),\"\",ROUND(SUM(G122:U122)/COUNT(G122:U122),2))","v":2.83},null,{"$f":"IF(AND(B122=\"\",C122=\"\"),\"x\",\"\")","v":""},null,"ab 01/2014 = 2 h komp. Sprachförderung-Anpassung zum 01.08.2014 lt. Zuwendungsbescheid\nJuni 2014"]
[null,null,"Orff ",null,4,null,2,{"$f":"G123","v":2},{"$f":"H123","v":2},null,2,2,2,null,2,4,4,null,4,4,4,null,2.83,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(ISERROR(ROUND(SUM(G124:U124)/COUNT(G124:U124),2)),\"\",ROUND(SUM(G124:U124)/COUNT(G124:U124),2))","v":""},null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[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(B126=\"\",C126=\"\"),\"x\",\"\")","v":"x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G128:U128)/COUNT(G128:U128),2)),\"\",ROUND(SUM(G128:U128)/COUNT(G128:U128),2))","v":""},null,"x"]
[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(B129=\"\",C129=\"\"),\"x\",\"\")","v":"x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SUM(G130:U130)/COUNT(G130:U130),2)),\"\",ROUND(SUM(G130:U130)/COUNT(G130:U130),2))","v":""},null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[]
[]
[null,"Landesprogramm Zeit für Anleitung (Gutschein) "]
[]
[null,"AnleiterIn","Auszubildende/r"]
[null,"Smetana ","Chopin ",null,1,null,1,1,1,null,1,1,1,null,0,0,0,null,0,0,0,null,{"$f":"IF(ISERROR(ROUND(SUM(G137:U137)/COUNT(G137:U137),2)),\"\",ROUND(SUM(G137:U137)/COUNT(G137:U137),2))","v":0.5},null,{"$f":"IF(AND(B137=\"\",C137=\"\"),\"x\",\"\")","v":""}]
[null,"Pompadour ","Sibelius ",null,1,null,1,1,1,null,1,1,1,null,1,1,1,null,1,1,1,null,1,null,""]
[null,"Wagner ","Tina",null,null,null,1,1,1,null,1,1,1,null,1,1,1,null,1,1,1,null,1,null,""]
[null,"Tschaikowsky","Ulli ",null,1,null,1,1,1,null,1,1,1,null,1,1,1,null,1,1,1,null,1,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"x"]

{"sheet":"Jahresdurchschnitt","index":18,"n_rows":73,"n_cols":25,"rows_kept":73,"cut":false,"hidden":false,"merged":[[4,9,5,9],[4,11,5,11],[1,1,1,9],[66,1,66,9],[57,1,57,9],[53,1,53,2],[54,1,54,2]]}
[]
[null,{"$f":"\"Anlage - Pädagogisch notwendiges Personal in der \"&Datenblatt!E8&\" \"&Datenblatt!H10","v":"Anlage - Pädagogisch notwendiges Personal in der Durchblick 2016"}]
[]
[]
[null,null,null,null,"1. Quartal","2. Quartal","3. Quartal","4. Quartal",null,"Jahres-\ndurchschnitt",null,"Anmerkungen"]
[null,"lfd.Nr.","Personal",null,"Mittelwert","Mittelwert","Mittelwert","Mittelwert"]
[null,{"$f":"IF(C7=\"\",\"\",1)","v":1},{"$f":"IF(Personalstunden!C7=\"\",\"\",Personalstunden!C7)","v":"Mozart"},null,{"$f":"IF($C7=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G7:I7)/COUNT(Personalstunden!G7:I7)),\"\",SUM(Personalstunden!G7:I7)/COUNT(Personalstunden!G7:I7)))","v":37.666666666666664},{"$f":"IF($C7=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K7:M7)/COUNT(Personalstunden!K7:M7)),\"\",SUM(Personalstunden!K7:M7)/COUNT(Personalstunden!K7:M7)))","v":40},{"$f":"IF($C7=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O7:Q7)/COUNT(Personalstunden!O7:Q7)),\"\",SUM(Personalstunden!O7:Q7)/COUNT(Personalstunden!O7:Q7)))","v":38.333333333333336},{"$f":"IF($C7=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S7:U7)/COUNT(Personalstunden!S7:U7)),\"\",SUM(Personalstunden!S7:U7)/COUNT(Personalstunden!S7:U7)))","v":""},null,{"$f":"IF(ISERROR(ROUND(SUM(E7:H7)/COUNT(E7:H7),2)),\"\",ROUND(SUM(E7:H7)/COUNT(E7:H7),2))","v":38.67},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7=\"\",\"x\",\"\")","v":""}]
[null,{"$f":"IF(C8=\"\",\"\",MAX($B$7:B7)+1)","v":2},{"$f":"IF(Personalstunden!C8=\"\",\"\",Personalstunden!C8)","v":"Beethoven"},null,{"$f":"IF($C8=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G8:I8)/COUNT(Personalstunden!G8:I8)),\"\",SUM(Personalstunden!G8:I8)/COUNT(Personalstunden!G8:I8)))","v":37.666666666666664},{"$f":"IF($C8=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K8:M8)/COUNT(Personalstunden!K8:M8)),\"\",SUM(Personalstunden!K8:M8)/COUNT(Personalstunden!K8:M8)))","v":40},{"$f":"IF($C8=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O8:Q8)/COUNT(Personalstunden!O8:Q8)),\"\",SUM(Personalstunden!O8:Q8)/COUNT(Personalstunden!O8:Q8)))","v":37},{"$f":"IF($C8=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S8:U8)/COUNT(Personalstunden!S8:U8)),\"\",SUM(Personalstunden!S8:U8)/COUNT(Personalstunden!S8:U8)))","v":""},null,{"$f":"IF(ISERROR(ROUND(SUM(E8:H8)/COUNT(E8:H8),2)),\"\",ROUND(SUM(E8:H8)/COUNT(E8:H8),2))","v":38.22},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C8=\"\",\"x\",\"\")","v":""}]
[null,{"$f":"IF(C9=\"\",\"\",MAX($B$7:B8)+1)","v":3},{"$f":"IF(Personalstunden!C9=\"\",\"\",Personalstunden!C9)","v":"Chopin "},null,{"$f":"IF($C9=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G9:I9)/COUNT(Personalstunden!G9:I9)),\"\",SUM(Personalstunden!G9:I9)/COUNT(Personalstunden!G9:I9)))","v":17.5},{"$f":"IF($C9=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K9:M9)/COUNT(Personalstunden!K9:M9)),\"\",SUM(Personalstunden!K9:M9)/COUNT(Personalstunden!K9:M9)))","v":17.5},{"$f":"IF($C9=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O9:Q9)/COUNT(Personalstunden!O9:Q9)),\"\",SUM(Personalstunden!O9:Q9)/COUNT(Personalstunden!O9:Q9)))","v":17.5},{"$f":"IF($C9=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S9:U9)/COUNT(Personalstunden!S9:U9)),\"\",SUM(Personalstunden!S9:U9)/COUNT(Personalstunden!S9:U9)))","v":17.5},null,17.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C10=\"\",\"\",MAX($B$7:B9)+1)","v":4},{"$f":"IF(Personalstunden!C10=\"\",\"\",Personalstunden!C10)","v":"Donizetti"},null,{"$f":"IF($C10=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G10:I10)/COUNT(Personalstunden!G10:I10)),\"\",SUM(Personalstunden!G10:I10)/COUNT(Personalstunden!G10:I10)))","v":37.666666666666664},{"$f":"IF($C10=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K10:M10)/COUNT(Personalstunden!K10:M10)),\"\",SUM(Personalstunden!K10:M10)/COUNT(Personalstunden!K10:M10)))","v":40},{"$f":"IF($C10=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O10:Q10)/COUNT(Personalstunden!O10:Q10)),\"\",SUM(Personalstunden!O10:Q10)/COUNT(Personalstunden!O10:Q10)))","v":37},{"$f":"IF($C10=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S10:U10)/COUNT(Personalstunden!S10:U10)),\"\",SUM(Personalstunden!S10:U10)/COUNT(Personalstunden!S10:U10)))","v":""},null,38.22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C11=\"\",\"\",MAX($B$7:B10)+1)","v":5},{"$f":"IF(Personalstunden!C11=\"\",\"\",Personalstunden!C11)","v":"Bruckner "},null,{"$f":"IF($C11=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G11:I11)/COUNT(Personalstunden!G11:I11)),\"\",SUM(Personalstunden!G11:I11)/COUNT(Personalstunden!G11:I11)))","v":37.666666666666664},{"$f":"IF($C11=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K11:M11)/COUNT(Personalstunden!K11:M11)),\"\",SUM(Personalstunden!K11:M11)/COUNT(Personalstunden!K11:M11)))","v":40},{"$f":"IF($C11=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O11:Q11)/COUNT(Personalstunden!O11:Q11)),\"\",SUM(Personalstunden!O11:Q11)/COUNT(Personalstunden!O11:Q11)))","v":37},{"$f":"IF($C11=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S11:U11)/COUNT(Personalstunden!S11:U11)),\"\",SUM(Personalstunden!S11:U11)/COUNT(Personalstunden!S11:U11)))","v":""},null,38.22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C12=\"\",\"\",MAX($B$7:B11)+1)","v":6},{"$f":"IF(Personalstunden!C12=\"\",\"\",Personalstunden!C12)","v":"Britten "},null,{"$f":"IF($C12=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G12:I12)/COUNT(Personalstunden!G12:I12)),\"\",SUM(Personalstunden!G12:I12)/COUNT(Personalstunden!G12:I12)))","v":37},{"$f":"IF($C12=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K12:M12)/COUNT(Personalstunden!K12:M12)),\"\",SUM(Personalstunden!K12:M12)/COUNT(Personalstunden!K12:M12)))","v":40},{"$f":"IF($C12=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O12:Q12)/COUNT(Personalstunden!O12:Q12)),\"\",SUM(Personalstunden!O12:Q12)/COUNT(Personalstunden!O12:Q12)))","v":37},{"$f":"IF($C12=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S12:U12)/COUNT(Personalstunden!S12:U12)),\"\",SUM(Personalstunden!S12:U12)/COUNT(Personalstunden!S12:U12)))","v":""},null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C13=\"\",\"\",MAX($B$7:B12)+1)","v":7},{"$f":"IF(Personalstunden!C13=\"\",\"\",Personalstunden!C13)","v":"Händel "},null,{"$f":"IF($C13=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G13:I13)/COUNT(Personalstunden!G13:I13)),\"\",SUM(Personalstunden!G13:I13)/COUNT(Personalstunden!G13:I13)))","v":30},{"$f":"IF($C13=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K13:M13)/COUNT(Personalstunden!K13:M13)),\"\",SUM(Personalstunden!K13:M13)/COUNT(Personalstunden!K13:M13)))","v":30},{"$f":"IF($C13=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O13:Q13)/COUNT(Personalstunden!O13:Q13)),\"\",SUM(Personalstunden!O13:Q13)/COUNT(Personalstunden!O13:Q13)))","v":30},{"$f":"IF($C13=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S13:U13)/COUNT(Personalstunden!S13:U13)),\"\",SUM(Personalstunden!S13:U13)/COUNT(Personalstunden!S13:U13)))","v":""},null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C14=\"\",\"\",MAX($B$7:B13)+1)","v":8},{"$f":"IF(Personalstunden!C14=\"\",\"\",Personalstunden!C14)","v":"Haydn"},null,{"$f":"IF($C14=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G14:I14)/COUNT(Personalstunden!G14:I14)),\"\",SUM(Personalstunden!G14:I14)/COUNT(Personalstunden!G14:I14)))","v":20},{"$f":"IF($C14=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K14:M14)/COUNT(Personalstunden!K14:M14)),\"\",SUM(Personalstunden!K14:M14)/COUNT(Personalstunden!K14:M14)))","v":1},{"$f":"IF($C14=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O14:Q14)/COUNT(Personalstunden!O14:Q14)),\"\",SUM(Personalstunden!O14:Q14)/COUNT(Personalstunden!O14:Q14)))","v":2.5},{"$f":"IF($C14=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S14:U14)/COUNT(Personalstunden!S14:U14)),\"\",SUM(Personalstunden!S14:U14)/COUNT(Personalstunden!S14:U14)))","v":""},null,7.83,null,"19,25 h über Bundessprachprogramm, 19,75 h über LP-Sprachberatung",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C15=\"\",\"\",MAX($B$7:B14)+1)","v":9},{"$f":"IF(Personalstunden!C15=\"\",\"\",Personalstunden!C15)","v":"Offenbach "},null,{"$f":"IF($C15=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G15:I15)/COUNT(Personalstunden!G15:I15)),\"\",SUM(Personalstunden!G15:I15)/COUNT(Personalstunden!G15:I15)))","v":35},{"$f":"IF($C15=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K15:M15)/COUNT(Personalstunden!K15:M15)),\"\",SUM(Personalstunden!K15:M15)/COUNT(Personalstunden!K15:M15)))","v":15},{"$f":"IF($C15=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O15:Q15)/COUNT(Personalstunden!O15:Q15)),\"\",SUM(Personalstunden!O15:Q15)/COUNT(Personalstunden!O15:Q15)))","v":5},{"$f":"IF($C15=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S15:U15)/COUNT(Personalstunden!S15:U15)),\"\",SUM(Personalstunden!S15:U15)/COUNT(Personalstunden!S15:U15)))","v":""},null,{"$f":"IF(ISERROR(ROUND(SUM(E15:H15)/COUNT(E15:H15),2)),\"\",ROUND(SUM(E15:H15)/COUNT(E15:H15),2))","v":18.329999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C16=\"\",\"\",MAX($B$7:B15)+1)","v":10},{"$f":"IF(Personalstunden!C16=\"\",\"\",Personalstunden!C16)","v":"Rossini "},null,{"$f":"IF($C16=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G16:I16)/COUNT(Personalstunden!G16:I16)),\"\",SUM(Personalstunden!G16:I16)/COUNT(Personalstunden!G16:I16)))","v":19},{"$f":"IF($C16=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K16:M16)/COUNT(Personalstunden!K16:M16)),\"\",SUM(Personalstunden!K16:M16)/COUNT(Personalstunden!K16:M16)))","v":19},{"$f":"IF($C16=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O16:Q16)/COUNT(Personalstunden!O16:Q16)),\"\",SUM(Personalstunden!O16:Q16)/COUNT(Personalstunden!O16:Q16)))","v":19},{"$f":"IF($C16=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S16:U16)/COUNT(Personalstunden!S16:U16)),\"\",SUM(Personalstunden!S16:U16)/COUNT(Personalstunden!S16:U16)))","v":24},null,{"$f":"IF(ISERROR(ROUND(SUM(E16:H16)/COUNT(E16:H16),2)),\"\",ROUND(SUM(E16:H16)/COUNT(E16:H16),2))","v":20.25},null,"ab 12/2009 Altersteilzeit - 19 h unverändert",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C17=\"\",\"\",MAX($B$7:B16)+1)","v":11},{"$f":"IF(Personalstunden!C17=\"\",\"\",Personalstunden!C17)","v":"Ravel "},null,{"$f":"IF($C17=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G17:I17)/COUNT(Personalstunden!G17:I17)),\"\",SUM(Personalstunden!G17:I17)/COUNT(Personalstunden!G17:I17)))","v":20},{"$f":"IF($C17=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K17:M17)/COUNT(Personalstunden!K17:M17)),\"\",SUM(Personalstunden!K17:M17)/COUNT(Personalstunden!K17:M17)))","v":20.333333333333332},{"$f":"IF($C17=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O17:Q17)/COUNT(Personalstunden!O17:Q17)),\"\",SUM(Personalstunden!O17:Q17)/COUNT(Personalstunden!O17:Q17)))","v":20},{"$f":"IF($C17=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S17:U17)/COUNT(Personalstunden!S17:U17)),\"\",SUM(Personalstunden!S17:U17)/COUNT(Personalstunden!S17:U17)))","v":""},null,20.11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C18=\"\",\"\",MAX($B$7:B17)+1)","v":12},{"$f":"IF(Personalstunden!C18=\"\",\"\",Personalstunden!C18)","v":"Salieri"},null,{"$f":"IF($C18=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G18:I18)/COUNT(Personalstunden!G18:I18)),\"\",SUM(Personalstunden!G18:I18)/COUNT(Personalstunden!G18:I18)))","v":38},{"$f":"IF($C18=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K18:M18)/COUNT(Personalstunden!K18:M18)),\"\",SUM(Personalstunden!K18:M18)/COUNT(Personalstunden!K18:M18)))","v":38},{"$f":"IF($C18=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O18:Q18)/COUNT(Personalstunden!O18:Q18)),\"\",SUM(Personalstunden!O18:Q18)/COUNT(Personalstunden!O18:Q18)))","v":37.666666666666664},{"$f":"IF($C18=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S18:U18)/COUNT(Personalstunden!S18:U18)),\"\",SUM(Personalstunden!S18:U18)/COUNT(Personalstunden!S18:U18)))","v":39},null,38.17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C19=\"\",\"\",MAX($B$7:B18)+1)","v":13},{"$f":"IF(Personalstunden!C19=\"\",\"\",Personalstunden!C19)","v":"Verdi "},null,{"$f":"IF($C19=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G19:I19)/COUNT(Personalstunden!G19:I19)),\"\",SUM(Personalstunden!G19:I19)/COUNT(Personalstunden!G19:I19)))","v":25.333333333333332},{"$f":"IF($C19=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K19:M19)/COUNT(Personalstunden!K19:M19)),\"\",SUM(Personalstunden!K19:M19)/COUNT(Personalstunden!K19:M19)))","v":35},{"$f":"IF($C19=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O19:Q19)/COUNT(Personalstunden!O19:Q19)),\"\",SUM(Personalstunden!O19:Q19)/COUNT(Personalstunden!O19:Q19)))","v":35},{"$f":"IF($C19=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S19:U19)/COUNT(Personalstunden!S19:U19)),\"\",SUM(Personalstunden!S19:U19)/COUNT(Personalstunden!S19:U19)))","v":""},null,31.78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C20=\"\",\"\",MAX($B$7:B19)+1)","v":14},{"$f":"IF(Personalstunden!C20=\"\",\"\",Personalstunden!C20)","v":"Vivaldi "},null,{"$f":"IF($C20=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G20:I20)/COUNT(Personalstunden!G20:I20)),\"\",SUM(Personalstunden!G20:I20)/COUNT(Personalstunden!G20:I20)))","v":30},{"$f":"IF($C20=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K20:M20)/COUNT(Personalstunden!K20:M20)),\"\",SUM(Personalstunden!K20:M20)/COUNT(Personalstunden!K20:M20)))","v":30},{"$f":"IF($C20=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O20:Q20)/COUNT(Personalstunden!O20:Q20)),\"\",SUM(Personalstunden!O20:Q20)/COUNT(Personalstunden!O20:Q20)))","v":30},{"$f":"IF($C20=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S20:U20)/COUNT(Personalstunden!S20:U20)),\"\",SUM(Personalstunden!S20:U20)/COUNT(Personalstunden!S20:U20)))","v":""},null,30,null,"Stundenreduzierung ab 10/2011 auf 30 Wo-Stunde",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C21=\"\",\"\",MAX($B$7:B20)+1)","v":15},{"$f":"IF(Personalstunden!C21=\"\",\"\",Personalstunden!C21)","v":"Wagner "},null,{"$f":"IF($C21=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G21:I21)/COUNT(Personalstunden!G21:I21)),\"\",SUM(Personalstunden!G21:I21)/COUNT(Personalstunden!G21:I21)))","v":37.333333333333336},{"$f":"IF($C21=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K21:M21)/COUNT(Personalstunden!K21:M21)),\"\",SUM(Personalstunden!K21:M21)/COUNT(Personalstunden!K21:M21)))","v":39},{"$f":"IF($C21=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O21:Q21)/COUNT(Personalstunden!O21:Q21)),\"\",SUM(Personalstunden!O21:Q21)/COUNT(Personalstunden!O21:Q21)))","v":37.666666666666664},{"$f":"IF($C21=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S21:U21)/COUNT(Personalstunden!S21:U21)),\"\",SUM(Personalstunden!S21:U21)/COUNT(Personalstunden!S21:U21)))","v":""},null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C22=\"\",\"\",MAX($B$7:B21)+1)","v":16},{"$f":"IF(Personalstunden!C22=\"\",\"\",Personalstunden!C22)","v":"Tschaikowsky"},null,{"$f":"IF($C22=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G22:I22)/COUNT(Personalstunden!G22:I22)),\"\",SUM(Personalstunden!G22:I22)/COUNT(Personalstunden!G22:I22)))","v":37.333333333333336},{"$f":"IF($C22=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K22:M22)/COUNT(Personalstunden!K22:M22)),\"\",SUM(Personalstunden!K22:M22)/COUNT(Personalstunden!K22:M22)))","v":36},{"$f":"IF($C22=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O22:Q22)/COUNT(Personalstunden!O22:Q22)),\"\",SUM(Personalstunden!O22:Q22)/COUNT(Personalstunden!O22:Q22)))","v":32},{"$f":"IF($C22=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S22:U22)/COUNT(Personalstunden!S22:U22)),\"\",SUM(Personalstunden!S22:U22)/COUNT(Personalstunden!S22:U22)))","v":""},null,35.11,null,"zuzüglich 5,5 h Sprachförderung",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C23=\"\",\"\",MAX($B$7:B22)+1)","v":17},{"$f":"IF(Personalstunden!C23=\"\",\"\",Personalstunden!C23)","v":"Puccini "},null,{"$f":"IF($C23=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G23:I23)/COUNT(Personalstunden!G23:I23)),\"\",SUM(Personalstunden!G23:I23)/COUNT(Personalstunden!G23:I23)))","v":30},{"$f":"IF($C23=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K23:M23)/COUNT(Personalstunden!K23:M23)),\"\",SUM(Personalstunden!K23:M23)/COUNT(Personalstunden!K23:M23)))","v":30},{"$f":"IF($C23=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O23:Q23)/COUNT(Personalstunden!O23:Q23)),\"\",SUM(Personalstunden!O23:Q23)/COUNT(Personalstunden!O23:Q23)))","v":30},{"$f":"IF($C23=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S23:U23)/COUNT(Personalstunden!S23:U23)),\"\",SUM(Personalstunden!S23:U23)/COUNT(Personalstunden!S23:U23)))","v":""},null,30,null,"Ergänzung - Frau Kansy-ATZ - 19 Stunden",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C24=\"\",\"\",MAX($B$7:B23)+1)","v":18},{"$f":"IF(Personalstunden!C24=\"\",\"\",Personalstunden!C24)","v":"Sibelius "},null,{"$f":"IF($C24=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G24:I24)/COUNT(Personalstunden!G24:I24)),\"\",SUM(Personalstunden!G24:I24)/COUNT(Personalstunden!G24:I24)))","v":17.5},{"$f":"IF($C24=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K24:M24)/COUNT(Personalstunden!K24:M24)),\"\",SUM(Personalstunden!K24:M24)/COUNT(Personalstunden!K24:M24)))","v":17.5},{"$f":"IF($C24=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O24:Q24)/COUNT(Personalstunden!O24:Q24)),\"\",SUM(Personalstunden!O24:Q24)/COUNT(Personalstunden!O24:Q24)))","v":37},{"$f":"IF($C24=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S24:U24)/COUNT(Personalstunden!S24:U24)),\"\",SUM(Personalstunden!S24:U24)/COUNT(Personalstunden!S24:U24)))","v":""},null,24,null,"Anrechnung mit 70% von 25 Wochenstunden",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C25=\"\",\"\",MAX($B$7:B24)+1)","v":19},{"$f":"IF(Personalstunden!C25=\"\",\"\",Personalstunden!C25)","v":"Smetana "},null,{"$f":"IF($C25=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G25:I25)/COUNT(Personalstunden!G25:I25)),\"\",SUM(Personalstunden!G25:I25)/COUNT(Personalstunden!G25:I25)))","v":37.666666666666664},{"$f":"IF($C25=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K25:M25)/COUNT(Personalstunden!K25:M25)),\"\",SUM(Personalstunden!K25:M25)/COUNT(Personalstunden!K25:M25)))","v":40},{"$f":"IF($C25=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O25:Q25)/COUNT(Personalstunden!O25:Q25)),\"\",SUM(Personalstunden!O25:Q25)/COUNT(Personalstunden!O25:Q25)))","v":37},{"$f":"IF($C25=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S25:U25)/COUNT(Personalstunden!S25:U25)),\"\",SUM(Personalstunden!S25:U25)/COUNT(Personalstunden!S25:U25)))","v":""},null,38.22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C26=\"\",\"\",MAX($B$7:B25)+1)","v":20},{"$f":"IF(Personalstunden!C26=\"\",\"\",Personalstunden!C26)","v":"Schumann "},null,{"$f":"IF($C26=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G26:I26)/COUNT(Personalstunden!G26:I26)),\"\",SUM(Personalstunden!G26:I26)/COUNT(Personalstunden!G26:I26)))","v":37.666666666666664},{"$f":"IF($C26=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K26:M26)/COUNT(Personalstunden!K26:M26)),\"\",SUM(Personalstunden!K26:M26)/COUNT(Personalstunden!K26:M26)))","v":40},{"$f":"IF($C26=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O26:Q26)/COUNT(Personalstunden!O26:Q26)),\"\",SUM(Personalstunden!O26:Q26)/COUNT(Personalstunden!O26:Q26)))","v":37},{"$f":"IF($C26=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S26:U26)/COUNT(Personalstunden!S26:U26)),\"\",SUM(Personalstunden!S26:U26)/COUNT(Personalstunden!S26:U26)))","v":""},null,38.22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C27=\"\",\"\",MAX($B$7:B26)+1)","v":21},{"$f":"IF(Personalstunden!C27=\"\",\"\",Personalstunden!C27)","v":"Orff "},null,{"$f":"IF($C27=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G27:I27)/COUNT(Personalstunden!G27:I27)),\"\",SUM(Personalstunden!G27:I27)/COUNT(Personalstunden!G27:I27)))","v":33},{"$f":"IF($C27=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K27:M27)/COUNT(Personalstunden!K27:M27)),\"\",SUM(Personalstunden!K27:M27)/COUNT(Personalstunden!K27:M27)))","v":33},{"$f":"IF($C27=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O27:Q27)/COUNT(Personalstunden!O27:Q27)),\"\",SUM(Personalstunden!O27:Q27)/COUNT(Personalstunden!O27:Q27)))","v":36},{"$f":"IF($C27=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S27:U27)/COUNT(Personalstunden!S27:U27)),\"\",SUM(Personalstunden!S27:U27)/COUNT(Personalstunden!S27:U27)))","v":""},null,34,null,"zuzüglich 5,5 h Sprachförderung",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C28=\"\",\"\",MAX($B$7:B27)+1)","v":22},{"$f":"IF(Personalstunden!C28=\"\",\"\",Personalstunden!C28)","v":"Pompadour "},null,{"$f":"IF($C28=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G28:I28)/COUNT(Personalstunden!G28:I28)),\"\",SUM(Personalstunden!G28:I28)/COUNT(Personalstunden!G28:I28)))","v":12.666666666666666},{"$f":"IF($C28=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K28:M28)/COUNT(Personalstunden!K28:M28)),\"\",SUM(Personalstunden!K28:M28)/COUNT(Personalstunden!K28:M28)))","v":0},{"$f":"IF($C28=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O28:Q28)/COUNT(Personalstunden!O28:Q28)),\"\",SUM(Personalstunden!O28:Q28)/COUNT(Personalstunden!O28:Q28)))","v":0},{"$f":"IF($C28=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S28:U28)/COUNT(Personalstunden!S28:U28)),\"\",SUM(Personalstunden!S28:U28)/COUNT(Personalstunden!S28:U28)))","v":0},null,3.17,null,"gekündigt zum 31.01.2014",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C29=\"\",\"\",MAX($B$7:B28)+1)","v":23},{"$f":"IF(Personalstunden!C29=\"\",\"\",Personalstunden!C29)","v":"Diderot "},null,{"$f":"IF($C29=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G29:I29)/COUNT(Personalstunden!G29:I29)),\"\",SUM(Personalstunden!G29:I29)/COUNT(Personalstunden!G29:I29)))","v":37.666666666666664},{"$f":"IF($C29=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K29:M29)/COUNT(Personalstunden!K29:M29)),\"\",SUM(Personalstunden!K29:M29)/COUNT(Personalstunden!K29:M29)))","v":40},{"$f":"IF($C29=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O29:Q29)/COUNT(Personalstunden!O29:Q29)),\"\",SUM(Personalstunden!O29:Q29)/COUNT(Personalstunden!O29:Q29)))","v":37},{"$f":"IF($C29=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S29:U29)/COUNT(Personalstunden!S29:U29)),\"\",SUM(Personalstunden!S29:U29)/COUNT(Personalstunden!S29:U29)))","v":""},null,38.22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C30=\"\",\"\",MAX($B$7:B29)+1)","v":24},{"$f":"IF(Personalstunden!C30=\"\",\"\",Personalstunden!C30)","v":"Max"},null,{"$f":"IF($C30=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G30:I30)/COUNT(Personalstunden!G30:I30)),\"\",SUM(Personalstunden!G30:I30)/COUNT(Personalstunden!G30:I30)))","v":25},{"$f":"IF($C30=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K30:M30)/COUNT(Personalstunden!K30:M30)),\"\",SUM(Personalstunden!K30:M30)/COUNT(Personalstunden!K30:M30)))","v":23.333333333333332},{"$f":"IF($C30=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O30:Q30)/COUNT(Personalstunden!O30:Q30)),\"\",SUM(Personalstunden!O30:Q30)/COUNT(Personalstunden!O30:Q30)))","v":20},{"$f":"IF($C30=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S30:U30)/COUNT(Personalstunden!S30:U30)),\"\",SUM(Personalstunden!S30:U30)/COUNT(Personalstunden!S30:U30)))","v":""},null,22.78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C31=\"\",\"\",MAX($B$7:B30)+1)","v":25},{"$f":"IF(Personalstunden!C31=\"\",\"\",Personalstunden!C31)","v":"Peter"},null,{"$f":"IF($C31=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G31:I31)/COUNT(Personalstunden!G31:I31)),\"\",SUM(Personalstunden!G31:I31)/COUNT(Personalstunden!G31:I31)))","v":35},{"$f":"IF($C31=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K31:M31)/COUNT(Personalstunden!K31:M31)),\"\",SUM(Personalstunden!K31:M31)/COUNT(Personalstunden!K31:M31)))","v":35},{"$f":"IF($C31=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O31:Q31)/COUNT(Personalstunden!O31:Q31)),\"\",SUM(Personalstunden!O31:Q31)/COUNT(Personalstunden!O31:Q31)))","v":35},{"$f":"IF($C31=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S31:U31)/COUNT(Personalstunden!S31:U31)),\"\",SUM(Personalstunden!S31:U31)/COUNT(Personalstunden!S31:U31)))","v":0},null,26.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C32=\"\",\"\",MAX($B$7:B31)+1)","v":26},{"$f":"IF(Personalstunden!C32=\"\",\"\",Personalstunden!C32)","v":"Luise"},null,{"$f":"IF($C32=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G32:I32)/COUNT(Personalstunden!G32:I32)),\"\",SUM(Personalstunden!G32:I32)/COUNT(Personalstunden!G32:I32)))","v":0},{"$f":"IF($C32=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K32:M32)/COUNT(Personalstunden!K32:M32)),\"\",SUM(Personalstunden!K32:M32)/COUNT(Personalstunden!K32:M32)))","v":10},{"$f":"IF($C32=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O32:Q32)/COUNT(Personalstunden!O32:Q32)),\"\",SUM(Personalstunden!O32:Q32)/COUNT(Personalstunden!O32:Q32)))","v":36.666666666666664},{"$f":"IF($C32=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S32:U32)/COUNT(Personalstunden!S32:U32)),\"\",SUM(Personalstunden!S32:U32)/COUNT(Personalstunden!S32:U32)))","v":""},null,{"$f":"IF(ISERROR(ROUND(SUM(E32:H32)/COUNT(E32:H32),2)),\"\",ROUND(SUM(E32:H32)/COUNT(E32:H32),2))","v":15.56},null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"IF(C33=\"\",\"\",MAX($B$7:B32)+1)","v":""},{"$f":"IF(Personalstunden!C33=\"\",\"\",Personalstunden!C33)","v":""},null,{"$f":"IF($C33=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G33:I33)/COUNT(Personalstunden!G33:I33)),\"\",SUM(Personalstunden!G33:I33)/COUNT(Personalstunden!G33:I33)))","v":""},{"$f":"IF($C33=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K33:M33)/COUNT(Personalstunden!K33:M33)),\"\",SUM(Personalstunden!K33:M33)/COUNT(Personalstunden!K33:M33)))","v":""},{"$f":"IF($C33=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O33:Q33)/COUNT(Personalstunden!O33:Q33)),\"\",SUM(Personalstunden!O33:Q33)/COUNT(Personalstunden!O33:Q33)))","v":""},{"$f":"IF($C33=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S33:U33)/COUNT(Personalstunden!S33:U33)),\"\",SUM(Personalstunden!S33:U33)/COUNT(Personalstunden!S33:U33)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C34=\"\",\"\",MAX($B$7:B33)+1)","v":""},{"$f":"IF(Personalstunden!C34=\"\",\"\",Personalstunden!C34)","v":""},null,{"$f":"IF($C34=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G34:I34)/COUNT(Personalstunden!G34:I34)),\"\",SUM(Personalstunden!G34:I34)/COUNT(Personalstunden!G34:I34)))","v":""},{"$f":"IF($C34=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K34:M34)/COUNT(Personalstunden!K34:M34)),\"\",SUM(Personalstunden!K34:M34)/COUNT(Personalstunden!K34:M34)))","v":""},{"$f":"IF($C34=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O34:Q34)/COUNT(Personalstunden!O34:Q34)),\"\",SUM(Personalstunden!O34:Q34)/COUNT(Personalstunden!O34:Q34)))","v":""},{"$f":"IF($C34=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S34:U34)/COUNT(Personalstunden!S34:U34)),\"\",SUM(Personalstunden!S34:U34)/COUNT(Personalstunden!S34:U34)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C35=\"\",\"\",MAX($B$7:B34)+1)","v":""},{"$f":"IF(Personalstunden!C35=\"\",\"\",Personalstunden!C35)","v":""},null,{"$f":"IF($C35=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G35:I35)/COUNT(Personalstunden!G35:I35)),\"\",SUM(Personalstunden!G35:I35)/COUNT(Personalstunden!G35:I35)))","v":""},{"$f":"IF($C35=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K35:M35)/COUNT(Personalstunden!K35:M35)),\"\",SUM(Personalstunden!K35:M35)/COUNT(Personalstunden!K35:M35)))","v":""},{"$f":"IF($C35=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O35:Q35)/COUNT(Personalstunden!O35:Q35)),\"\",SUM(Personalstunden!O35:Q35)/COUNT(Personalstunden!O35:Q35)))","v":""},{"$f":"IF($C35=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S35:U35)/COUNT(Personalstunden!S35:U35)),\"\",SUM(Personalstunden!S35:U35)/COUNT(Personalstunden!S35:U35)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C36=\"\",\"\",MAX($B$7:B35)+1)","v":""},{"$f":"IF(Personalstunden!C36=\"\",\"\",Personalstunden!C36)","v":""},null,{"$f":"IF($C36=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G36:I36)/COUNT(Personalstunden!G36:I36)),\"\",SUM(Personalstunden!G36:I36)/COUNT(Personalstunden!G36:I36)))","v":""},{"$f":"IF($C36=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K36:M36)/COUNT(Personalstunden!K36:M36)),\"\",SUM(Personalstunden!K36:M36)/COUNT(Personalstunden!K36:M36)))","v":""},{"$f":"IF($C36=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O36:Q36)/COUNT(Personalstunden!O36:Q36)),\"\",SUM(Personalstunden!O36:Q36)/COUNT(Personalstunden!O36:Q36)))","v":""},{"$f":"IF($C36=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S36:U36)/COUNT(Personalstunden!S36:U36)),\"\",SUM(Personalstunden!S36:U36)/COUNT(Personalstunden!S36:U36)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C37=\"\",\"\",MAX($B$7:B36)+1)","v":""},{"$f":"IF(Personalstunden!C37=\"\",\"\",Personalstunden!C37)","v":""},null,{"$f":"IF($C37=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G37:I37)/COUNT(Personalstunden!G37:I37)),\"\",SUM(Personalstunden!G37:I37)/COUNT(Personalstunden!G37:I37)))","v":""},{"$f":"IF($C37=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K37:M37)/COUNT(Personalstunden!K37:M37)),\"\",SUM(Personalstunden!K37:M37)/COUNT(Personalstunden!K37:M37)))","v":""},{"$f":"IF($C37=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O37:Q37)/COUNT(Personalstunden!O37:Q37)),\"\",SUM(Personalstunden!O37:Q37)/COUNT(Personalstunden!O37:Q37)))","v":""},{"$f":"IF($C37=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S37:U37)/COUNT(Personalstunden!S37:U37)),\"\",SUM(Personalstunden!S37:U37)/COUNT(Personalstunden!S37:U37)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C38=\"\",\"\",MAX($B$7:B37)+1)","v":""},{"$f":"IF(Personalstunden!C38=\"\",\"\",Personalstunden!C38)","v":""},null,{"$f":"IF($C38=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G38:I38)/COUNT(Personalstunden!G38:I38)),\"\",SUM(Personalstunden!G38:I38)/COUNT(Personalstunden!G38:I38)))","v":""},{"$f":"IF($C38=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K38:M38)/COUNT(Personalstunden!K38:M38)),\"\",SUM(Personalstunden!K38:M38)/COUNT(Personalstunden!K38:M38)))","v":""},{"$f":"IF($C38=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O38:Q38)/COUNT(Personalstunden!O38:Q38)),\"\",SUM(Personalstunden!O38:Q38)/COUNT(Personalstunden!O38:Q38)))","v":""},{"$f":"IF($C38=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S38:U38)/COUNT(Personalstunden!S38:U38)),\"\",SUM(Personalstunden!S38:U38)/COUNT(Personalstunden!S38:U38)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C39=\"\",\"\",MAX($B$7:B38)+1)","v":""},{"$f":"IF(Personalstunden!C39=\"\",\"\",Personalstunden!C39)","v":""},null,{"$f":"IF($C39=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G39:I39)/COUNT(Personalstunden!G39:I39)),\"\",SUM(Personalstunden!G39:I39)/COUNT(Personalstunden!G39:I39)))","v":""},{"$f":"IF($C39=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K39:M39)/COUNT(Personalstunden!K39:M39)),\"\",SUM(Personalstunden!K39:M39)/COUNT(Personalstunden!K39:M39)))","v":""},{"$f":"IF($C39=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O39:Q39)/COUNT(Personalstunden!O39:Q39)),\"\",SUM(Personalstunden!O39:Q39)/COUNT(Personalstunden!O39:Q39)))","v":""},{"$f":"IF($C39=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S39:U39)/COUNT(Personalstunden!S39:U39)),\"\",SUM(Personalstunden!S39:U39)/COUNT(Personalstunden!S39:U39)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C40=\"\",\"\",MAX($B$7:B39)+1)","v":""},{"$f":"IF(Personalstunden!C40=\"\",\"\",Personalstunden!C40)","v":""},null,{"$f":"IF($C40=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G40:I40)/COUNT(Personalstunden!G40:I40)),\"\",SUM(Personalstunden!G40:I40)/COUNT(Personalstunden!G40:I40)))","v":""},{"$f":"IF($C40=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K40:M40)/COUNT(Personalstunden!K40:M40)),\"\",SUM(Personalstunden!K40:M40)/COUNT(Personalstunden!K40:M40)))","v":""},{"$f":"IF($C40=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O40:Q40)/COUNT(Personalstunden!O40:Q40)),\"\",SUM(Personalstunden!O40:Q40)/COUNT(Personalstunden!O40:Q40)))","v":""},{"$f":"IF($C40=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S40:U40)/COUNT(Personalstunden!S40:U40)),\"\",SUM(Personalstunden!S40:U40)/COUNT(Personalstunden!S40:U40)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C41=\"\",\"\",MAX($B$7:B40)+1)","v":""},{"$f":"IF(Personalstunden!C41=\"\",\"\",Personalstunden!C41)","v":""},null,{"$f":"IF($C41=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G41:I41)/COUNT(Personalstunden!G41:I41)),\"\",SUM(Personalstunden!G41:I41)/COUNT(Personalstunden!G41:I41)))","v":""},{"$f":"IF($C41=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K41:M41)/COUNT(Personalstunden!K41:M41)),\"\",SUM(Personalstunden!K41:M41)/COUNT(Personalstunden!K41:M41)))","v":""},{"$f":"IF($C41=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O41:Q41)/COUNT(Personalstunden!O41:Q41)),\"\",SUM(Personalstunden!O41:Q41)/COUNT(Personalstunden!O41:Q41)))","v":""},{"$f":"IF($C41=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S41:U41)/COUNT(Personalstunden!S41:U41)),\"\",SUM(Personalstunden!S41:U41)/COUNT(Personalstunden!S41:U41)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C42=\"\",\"\",MAX($B$7:B41)+1)","v":""},{"$f":"IF(Personalstunden!C42=\"\",\"\",Personalstunden!C42)","v":""},null,{"$f":"IF($C42=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G42:I42)/COUNT(Personalstunden!G42:I42)),\"\",SUM(Personalstunden!G42:I42)/COUNT(Personalstunden!G42:I42)))","v":""},{"$f":"IF($C42=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K42:M42)/COUNT(Personalstunden!K42:M42)),\"\",SUM(Personalstunden!K42:M42)/COUNT(Personalstunden!K42:M42)))","v":""},{"$f":"IF($C42=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O42:Q42)/COUNT(Personalstunden!O42:Q42)),\"\",SUM(Personalstunden!O42:Q42)/COUNT(Personalstunden!O42:Q42)))","v":""},{"$f":"IF($C42=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S42:U42)/COUNT(Personalstunden!S42:U42)),\"\",SUM(Personalstunden!S42:U42)/COUNT(Personalstunden!S42:U42)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C43=\"\",\"\",MAX($B$7:B42)+1)","v":""},{"$f":"IF(Personalstunden!C43=\"\",\"\",Personalstunden!C43)","v":""},null,{"$f":"IF($C43=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G43:I43)/COUNT(Personalstunden!G43:I43)),\"\",SUM(Personalstunden!G43:I43)/COUNT(Personalstunden!G43:I43)))","v":""},{"$f":"IF($C43=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K43:M43)/COUNT(Personalstunden!K43:M43)),\"\",SUM(Personalstunden!K43:M43)/COUNT(Personalstunden!K43:M43)))","v":""},{"$f":"IF($C43=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O43:Q43)/COUNT(Personalstunden!O43:Q43)),\"\",SUM(Personalstunden!O43:Q43)/COUNT(Personalstunden!O43:Q43)))","v":""},{"$f":"IF($C43=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S43:U43)/COUNT(Personalstunden!S43:U43)),\"\",SUM(Personalstunden!S43:U43)/COUNT(Personalstunden!S43:U43)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,{"$f":"IF(C44=\"\",\"\",MAX($B$7:B43)+1)","v":""},{"$f":"IF(Personalstunden!C44=\"\",\"\",Personalstunden!C44)","v":""},null,{"$f":"IF($C44=\"\",\"\",\nIF(ISERROR(SUM(Personalstunden!G44:I44)/COUNT(Personalstunden!G44:I44)),\"\",SUM(Personalstunden!G44:I44)/COUNT(Personalstunden!G44:I44)))","v":""},{"$f":"IF($C44=\"\",\"\",IF(ISERROR(SUM(Personalstunden!K44:M44)/COUNT(Personalstunden!K44:M44)),\"\",SUM(Personalstunden!K44:M44)/COUNT(Personalstunden!K44:M44)))","v":""},{"$f":"IF($C44=\"\",\"\",IF(ISERROR(SUM(Personalstunden!O44:Q44)/COUNT(Personalstunden!O44:Q44)),\"\",SUM(Personalstunden!O44:Q44)/COUNT(Personalstunden!O44:Q44)))","v":""},{"$f":"IF($C44=\"\",\"\",IF(ISERROR(SUM(Personalstunden!S44:U44)/COUNT(Personalstunden!S44:U44)),\"\",SUM(Personalstunden!S44:U44)/COUNT(Personalstunden!S44:U44)))","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,"Ist-Stunden päd. Personal",null,{"$f":"IF(COUNT(E7:E44)=COUNT($B$7:$B$44),SUM(E7:E44),\"Daten!\")","v":763.33333333333303},{"$f":"IF(COUNT(F7:F44)=COUNT($B$7:$B$44),SUM(F7:F44),\"Daten!\")","v":749.66666666666663},{"$f":"IF(COUNT(G7:G44)=COUNT($B$7:$B$44),SUM(G7:G44),\"Daten!\")","v":758.33333333333337},{"$f":"IF(COUNT(H7:H44)=COUNT($B$7:$B$44),SUM(H7:H44),\"Daten!\")","v":"Daten!"},null,{"$f":"IF(ISERROR(ROUND(SUM(E45:H45)/COUNT(E45:H45),2)),\"\",ROUND(SUM(E45:H45)/COUNT(E45:H45),2))","v":757.11},null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,{"$f":"Personalstunden!B47","v":"Pädagogisches Personal Ist"},null,null,{"$f":"IF(ISERROR(SUM(Personalstunden!G47:I47)/COUNT(Personalstunden!G47:I47)),\"\",SUM(Personalstunden!G47:I47)/COUNT(Personalstunden!G47:I47))","v":763.33333333333337},{"$f":"IF(ISERROR(SUM(Personalstunden!K47:M47)/COUNT(Personalstunden!K47:M47)),\"\",SUM(Personalstunden!K47:M47)/COUNT(Personalstunden!K47:M47))","v":749.66666666666663},{"$f":"IF(ISERROR(SUM(Personalstunden!O47:Q47)/COUNT(Personalstunden!O47:Q47)),\"\",SUM(Personalstunden!O47:Q47)/COUNT(Personalstunden!O47:Q47))","v":758.33333333333337},{"$f":"IF(ISERROR(SUM(Personalstunden!S47:U47)/COUNT(Personalstunden!S47:U47)),\"\",SUM(Personalstunden!S47:U47)/COUNT(Personalstunden!S47:U47))","v":""},null,{"$f":"IF(ISERROR(ROUND(SUM(E47:H47)/COUNT(E47:H47),2)),\"\",ROUND(SUM(E47:H47)/COUNT(E47:H47),2))","v":757.11}]
[null,{"$f":"Personalstunden!B48","v":"Pädagogischer Leitungsanteil"},null,null,{"$f":"IF(ISERROR(SUM(Personalstunden!G48:I48)/COUNT(Personalstunden!G48:I48)),\"\",SUM(Personalstunden!G48:I48)/COUNT(Personalstunden!G48:I48))","v":20},{"$f":"IF(ISERROR(SUM(Personalstunden!K48:M48)/COUNT(Personalstunden!K48:M48)),\"\",SUM(Personalstunden!K48:M48)/COUNT(Personalstunden!K48:M48))","v":20},{"$f":"IF(ISERROR(SUM(Personalstunden!O48:Q48)/COUNT(Personalstunden!O48:Q48)),\"\",SUM(Personalstunden!O48:Q48)/COUNT(Personalstunden!O48:Q48))","v":20},{"$f":"IF(ISERROR(SUM(Personalstunden!S48:U48)/COUNT(Personalstunden!S48:U48)),\"\",SUM(Personalstunden!S48:U48)/COUNT(Personalstunden!S48:U48))","v":""},null,20]
[null,{"$f":"Personalstunden!B49","v":"Pädagogisches Personal Ist - Gesamt"},null,null,{"$f":"IF(E47=\"\",\"\",SUM(E47:E48))","v":783.33333333333337},769.66666666666663,778.33333333333337,{"$f":"IF(H47=\"\",\"\",SUM(H47:H48))","v":""},null,777.11]
[null,{"$f":"Personalstunden!B50","v":"Resultierende VZ-Stellen (Ist)"},null,null,{"$f":"IF(E49=\"\",\"\",E49/40)","v":19.583333333333336},19.241666666666667,19.458333333333336,{"$f":"IF(H49=\"\",\"\",H49/40)","v":""},null,19.43]
[]
[null,{"$f":"Personalstunden!B52","v":"Organisatorischer Leitungsanteil"},null,null,{"$f":"IF(ISERROR(SUM(Personalstunden!G52:I52)/COUNT(Personalstunden!G52:I52)),\"\",SUM(Personalstunden!G52:I52)/COUNT(Personalstunden!G52:I52))","v":10},{"$f":"IF(ISERROR(SUM(Personalstunden!K52:M52)/COUNT(Personalstunden!K52:M52)),\"\",SUM(Personalstunden!K52:M52)/COUNT(Personalstunden!K52:M52))","v":10},{"$f":"IF(ISERROR(SUM(Personalstunden!O52:Q52)/COUNT(Personalstunden!O52:Q52)),\"\",SUM(Personalstunden!O52:Q52)/COUNT(Personalstunden!O52:Q52))","v":10},{"$f":"IF(ISERROR(SUM(Personalstunden!S52:U52)/COUNT(Personalstunden!S52:U52)),\"\",SUM(Personalstunden!S52:U52)/COUNT(Personalstunden!S52:U52))","v":10},null,10]
[]
[null,"zu finanzierendes Personal  gemäß Stichtag (VZ-Stellen - Soll)",null,null,{"$f":"IF(ISERROR(SUM(Personalstunden!G54:I54)/COUNT(Personalstunden!G54:I54)),\"\",SUM(Personalstunden!G54:I54)/COUNT(Personalstunden!G54:I54))","v":19.757000000000001},{"$f":"IF(ISERROR(SUM(Personalstunden!K54:M54)/COUNT(Personalstunden!K54:M54)),\"\",SUM(Personalstunden!K54:M54)/COUNT(Personalstunden!K54:M54))","v":19.605000000000004},{"$f":"IF(ISERROR(SUM(Personalstunden!O54:Q54)/COUNT(Personalstunden!O54:Q54)),\"\",SUM(Personalstunden!O54:Q54)/COUNT(Personalstunden!O54:Q54))","v":19.072000000000003},{"$f":"IF(ISERROR(SUM(Personalstunden!S54:U54)/COUNT(Personalstunden!S54:U54)),\"\",SUM(Personalstunden!S54:U54)/COUNT(Personalstunden!S54:U54))","v":""},null,19.48]
[null,"zu finanzierendes Personal gemäß Stichtag in Stunden ",null,null,{"$f":"IF(ISERROR(SUM(Personalstunden!G55:I55)/COUNT(Personalstunden!G55:I55)),\"\",SUM(Personalstunden!G55:I55)/COUNT(Personalstunden!G55:I55))","v":790.28000000000009},{"$f":"IF(ISERROR(SUM(Personalstunden!K55:M55)/COUNT(Personalstunden!K55:M55)),\"\",SUM(Personalstunden!K55:M55)/COUNT(Personalstunden!K55:M55))","v":784.20000000000016},{"$f":"IF(ISERROR(SUM(Personalstunden!O55:Q55)/COUNT(Personalstunden!O55:Q55)),\"\",SUM(Personalstunden!O55:Q55)/COUNT(Personalstunden!O55:Q55))","v":762.88000000000011},{"$f":"IF(ISERROR(SUM(Personalstunden!S55:U55)/COUNT(Personalstunden!S55:U55)),\"\",SUM(Personalstunden!S55:U55)/COUNT(Personalstunden!S55:U55))","v":""},null,779.12]
[]
[]
[null,"Auswertung: Differenz zwischen dem tatsächlich eingesetzten Personal (Ist) und dem (finanzierten) Soll"]
[]
[null,{"$f":"Personalstunden!B60","v":"Differenz in Wochenstunden (Ist-Soll)"},null,null,{"$f":"IF(E45=\"Daten!\",\"\",IF(ISERROR(E49-E55),\"\",E49-E55))","v":-6.9466666666667152},{"$f":"IF(F45=\"Daten!\",\"\",IF(ISERROR(F49-F55),\"\",F49-F55))","v":-14.53333333333353},15.453333333333262,"",null,{"$f":"IF(J45=\"\",\"\",Personalstunden!W60)","v":-2.0099999999999998}]
[null,{"$f":"Personalstunden!B61","v":"Spanne in %"},null,null,{"$f":"IF(ISERROR(E60/E55),\"\",E60/E55)","v":-8.7901334548093259E-3},{"$f":"IF(ISERROR(F60/F55),\"\",F60/F55)","v":-1.8532687239649997E-2},{"$f":"IF(ISERROR(G60/G55),\"\",G60/G55)","v":2.0256571588366794E-2},{"$f":"IF(ISERROR(H60/H55),\"\",H60/H55)","v":""},null,{"$f":"Personalstunden!W61","v":-2.3999999999999998E-3}]
[null,{"$f":"Personalstunden!B62","v":"Jahresdurchschnitt"},null,null,{"$f":"IF(ISERROR(SUM(Personalstunden!$G$61:I$61)),\"\",SUM(Personalstunden!$G$61:I$61))","v":-2.6370400364428122E-2},{"$f":"IF(ISERROR(SUM(Personalstunden!$G$61:M$61)),\"\",SUM(Personalstunden!$G$61:M$61))","v":-8.1968462083377963E-2},{"$f":"IF(ISERROR(SUM(Personalstunden!$G$61:Q$61)),\"\",SUM(Personalstunden!$G$61:Q$61))","v":-2.1198747318277728E-2},{"$f":"IF(ISERROR(SUM(Personalstunden!$G$61:U$61)),\"\",SUM(Personalstunden!$G$61:U$61))","v":-2.1198747318277728E-2},null,{"$f":"Personalstunden!W62","v":-2.1198747318277728E-2}]
[]
[null,{"$f":"Personalstunden!B64","v":"Quartalspuffer für Jahresausgleich"},null,null,{"$f":"IF(ISERROR(ROUND(SUM(E60)/40,2)),\"\",ROUND(SUM(E60)/40,2))","v":-0.17},{"$f":"IF(ISERROR(ROUND(SUM(F60)/40,2)),\"\",ROUND(SUM(F60)/40,2))","v":-0.36},{"$f":"IF(ISERROR(ROUND(SUM(G60)/40,2)),\"\",ROUND(SUM(G60)/40,2))","v":0.39},{"$f":"IF(ISERROR(ROUND(SUM(H60)/40,2)),\"\",ROUND(SUM(H60)/40,2))","v":0},null,{"$f":"IF(ISERROR(ROUND(SUM(E64:H64)/COUNT(E64:H64),2)),\"\",ROUND(SUM(E64:H64)/COUNT(E64:H64),2))","v":-0.04}]
[]
[]
[null,"Zusatzfinanzierungen"]
[]
[null,{"$f":"Personalstunden!B72","v":"Ergänzende Bundes- und Landesprojekte"},null,null,{"$f":"SUM(Personalstunden!G74:G117)","v":42},{"$f":"SUM(Personalstunden!K74:K117)","v":68},{"$f":"SUM(Personalstunden!O74:O117)","v":81.5},{"$f":"SUM(Personalstunden!S74:S117)","v":68.5},null,{"$f":"IF(ISERROR(ROUND(SUM(E69:H69)/COUNT(E69:H69),2)),\"\",ROUND(SUM(E69:H69)/COUNT(E69:H69),2))","v":65}]
[]
[null,{"$f":"Personalstunden!B120","v":"Kompensatorische Srachförderung (sofern als separate Zuwendung finanziert) "},null,null,{"$f":"SUM(Personalstunden!G122:G131)","v":4},{"$f":"SUM(Personalstunden!K122:K131)","v":4},{"$f":"SUM(Personalstunden!O122:O131)","v":4},{"$f":"SUM(Personalstunden!J122:J131)","v":0},null,{"$f":"IF(ISERROR(ROUND(SUM(E71:H71)/COUNT(E71:H71),2)),\"\",ROUND(SUM(E71:H71)/COUNT(E71:H71),2))","v":3}]
[]
[null,{"$f":"Personalstunden!B134","v":"Landesprogramm Zeit für Anleitung (Gutschein) "},null,null,{"$f":"SUM(Personalstunden!G137:G145)","v":4},{"$f":"SUM(Personalstunden!K137:K145)","v":4},{"$f":"SUM(Personalstunden!O137:O145)","v":3},{"$f":"SUM(Personalstunden!J137:J145)","v":0},null,{"$f":"IF(ISERROR(ROUND(SUM(E73:H73)/COUNT(E73:H73),2)),\"\",ROUND(SUM(E73:H73)/COUNT(E73:H73),2))","v":2.75}]