{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Stammdaten Meldebogen","Angaben Personal","Zusammenfassung","Gruppe 1","Gruppe 2","Gruppe 3","Gruppe 4","Gruppe 5","Dropdownfelder"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Stammdaten Meldebogen","index":0,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[5,0,5,9],[7,5,7,9],[7,0,7,4],[9,1,9,4],[9,6,9,9],[10,1,10,4],[11,1,11,4],[12,1,12,4],[14,1,14,4],[15,1,15,4],[10,6,10,9],[11,6,11,9],[12,6,12,9],[13,6,13,9],[14,6,14,9],[15,6,15,9],[13,1,13,4],[29,0,29,4],[32,0,32,4],[33,0,33,9],[17,0,17,9],[24,0,24,9],[28,0,28,4],[26,0,26,4],[27,0,27,4],[20,5,20,7],[20,0,20,2],[19,0,19,2],[19,5,19,7],[21,0,21,2],[22,0,22,2],[21,5,21,7],[40,0,43,1],[37,0,37,5],[49,0,49,1],[59,8,59,9],[40,2,40,9],[42,2,42,9],[49,2,49,9],[50,2,50,5],[50,7,50,9],[41,2,41,9],[3,3,3,4],[0,0,1,10],[3,5,3,6],[60,3,60,6],[47,0,47,9],[39,0,39,1],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[19,8,19,9],[20,8,20,9],[21,8,21,9],[36,0,36,9],[60,8,60,9],[43,2,43,9]]}
["Jährliche Meldung für Tageseinrichtungen für Kinder nach § 47  Achtes Buch Sozialgesetzbuch (SGB VIII) i.V.m.     § 18 sowie § 15 Abs. 3 Satz 1 und Abs. 4 Hessisches Kinder- und Jugendhilfegesetzbuch (HKJGB)"]
[]
[]
[null,null,null,"Stichtag:",null,{"$f":"CONCATENATE(\"01.03.\",YEAR(TODAY()))","v":"01.03.2017"}]
[]
["1. Angaben zur Tageseinrichtung und zum Träger"]
[]
["Angaben zur Tageseinrichtung:",null,null,null,null,"Angaben zum Träger:"]
[]
["Einr.-Nr.:",null,null,null,null,"Träger-Nr.:"]
["Name:",null,null,null,null,"Name:"]
["Straße/Hausnr.:",null,null,null,null,"Straße/Hausnr.:"]
["PLZ/Ort:",null,null,null,null,"PLZ/Ort:"]
["Telefon:",null,null,null,null,"Telefon:"]
["Fax:",null,null,null,null,"Fax:"]
["E-Mail:",null,null,null,null,"E-Mail:"]
[]
["2. Angaben zur Betriebserlaubnis"]
[]
["Datum der Betriebserlaubnis:",null,null,null,null,"Gütigkeit der Betriebserlaubnis ab:"]
["Gesamtzahl der Plätze nach BE:",null,null,null,null,"Altersspanne von bis:"]
["vorgesehene Plätze für 0 bis u3-Jährige:",null,null,null,null,"vorgesehene Plätze für Schulkinder:"]
["vorgesehene Plätze für 3 bis 6-Jährige:"]
[]
["3. Angaben zu den tatsächlich belegten Plätzen*"]
[]
["Kinder bis zum vollendeten 1. Lebensjahr:"]
["Kinder vom vollendeten 1. bis zum vollendeten 2. Lebensjahr: "]
["Kinder vom vollendeten 2. bis zum vollendeten 3. Lebensjahr:"]
["Kinder vom vollendeten 3. Lebensjahr bis zum Schuleintritt:"]
["Kinder ab Schuleintritt:"]
["Integrationskinder: "]
["Flüchtlingskinder:"]
["* Hier bitte die Anzahl aller zum Stichtag 01.03. vertraglich oder satzungsgemäß aufgenommenen Kinder angeben. Nur teilweise belegte Plätze (Platzsharing) bitte auf ganze Plätze summieren."]
[]
[]
["4. Angaben zur Öffnungszeiten der Tageseinrichtung insgesamt"]
[]
["Montag bis Donnerstag",null,"von",null,"bis"]
["Freitag",null,"von",null,"bis"]
["Sonstige Regelungen:                                                                "]
[]
[]
[]
[]
[]
[]
["5. Ansprechpartner/in bei Rückfragen"]
[]
["Name:"]
["E-Mail:",null,null,null,null,null,"Telefon:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ort, Datum",null,null,"Rechtsverbindliche Unterschrift des Trägers ",null,null,null,null,"Stempel"]
[]
["Anlage"]

{"sheet":"Angaben Personal","index":1,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,0,2,6],[30,3,30,5],[4,0,4,6],[31,0,31,5],[6,0,6,5],[29,4,29,5],[32,0,32,6],[56,0,56,6],[52,0,52,6],[54,0,54,6],[40,0,40,6],[51,0,51,6]]}
["Anlage zur jährlichen Meldung nach § 47 SGB VIII  HessKiföG  "]
[]
["2.  Angaben zum Personal der Tageseinrichtung"]
[]
["Die im folgenden erhobenen personenbezogenen Daten sind verpflichtende Angaben nach § 47 SGB VIII in Verbindung mit den §§ 15 und 18  HKJGB. Sie werden ausschließlich zum Zweck der Aufgabenerfüllung zum Schutz von Kindern in Tageseinrichtungen verwendet und ggf. in einem automatisierten Verfahren gespeichert. Die betroffenen Personen sind hiervon in geeigneter Weise in Kenntnis zu setzen."]
[]
["2.1.  Angaben zum pädagogischen Personal (§ 25c i.V. mit § 25b HKJGB) ohne Integrationskräfte:"]
["Name, Vorname","Geburtsdatum","Einstellungs-datum","Führungszeugnis vom*","Ausbildung","Funktion**","wöchentliche Arbeitszeit***"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Summe Personal:",null,{"$f":"SUM(G9:G29)","v":0}]
[]
["Die Erläuterungen zu \"Führungszeugnis vom*\", \"Funktion**\" und \"wöchentliche Arbeitszeit***\" finden Sie unterhalb Punkt 2.2. auf der nächste Seite."]
[]
[]
[]
[]
["Anlage zur jährlichen Meldung nach § 47 SGB VIII  HessKiföG  "]
[]
[]
[]
["2.2.  Angaben zum weiteren pädagogischen Personal für Integration, Sprachförderung etc.:"]
["Name, Vorname","Geburtsjahr ","Einstellungs-datum","Führungszeugnis vom*","Ausbildung","Funktion**","wöchentliche Arbeitszeit"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Summe:",{"$f":"SUM(G43:G50)","v":0}]
[]
["*Hier bitte nur das Datum des letzten Führungszeugnisses eintragen, keine Führungszeugnisse in der Anlage beifügen! Die Bestimmungen zum Datenschutz nach § 72a Abs. 5 SGB VIII sind zu beachten."]
[]
["** Falls Mitarbeiterinnen oder Mitarbeiter mehrere Funktionen wahrnehmen (z.B. Fachkraft in der Gruppe und Integrationskraft), weisen Sie diese Personen bitte mehrfach - getrennt nach der Funktion - aus und geben jeweils die Stundenzahl/Woche an, die für die betreffende Funktion eingesetzt werden."]
[]
["*** Bei Personen im Anerkennungsjahr ist hier nur ihre jeweils anrechenbare wöchentliche Arbeitszeit anzugeben (§ 25 Abs. 2 Satz 1 Nr.3 HKJGB i.V.m. § 25c Abs. 3 HKJGB)."]

{"sheet":"Zusammenfassung","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,7,4,8]]}
["Mindestpersonalbedarf lt. KiföG für Kindertagesstätte: "]
[]
[null,{"$f":"'Stammdaten Meldebogen'!B11:E11","v":0}]
[]
[null,"Personalbedarf"]
["Gruppe 1",{"$f":"'Gruppe 1'!I23","v":0},"Zur Gruppe 1 wechseln!"]
["Gruppe 2",{"$f":"'Gruppe 2'!I23","v":0},"Zur Gruppe 2 wechseln!"]
["Gruppe 3",{"$f":"'Gruppe 3'!I23","v":0},"Zur Gruppe 3 wechseln!"]
["Gruppe 4",{"$f":"'Gruppe 4'!I23","v":0},"Zur Gruppe 4 wechseln!"]
["Gruppe 5",{"$f":"'Gruppe 5'!I23","v":0},"Zur Gruppe 5 wechseln!"]
[]
["PERSONALBEDARF",{"$f":"SUM(B6:B9)","v":0}]
["Personal Ist-Stand",{"$f":"'Angaben Personal'!G30","v":0},{"$f":"IF(B13=0,\"<<<Eingabe auf Arbeitsblatt 'Angaben Personal' fehlt!!!\",\"\")","v":"<<<Eingabe auf Arbeitsblatt 'Angaben Personal' fehlt!!!"}]
[null,{"$f":"B13-B12","v":0}]

{"sheet":"Gruppe 1","index":3,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[20,1,20,5],[6,8,7,8],[6,2,6,6],[8,0,11,0],[12,0,15,0],[16,0,19,0],[6,0,7,0],[6,1,7,1],[6,7,7,7]]}
["PERSONALBEDARFSBERECHNUNG",null,null,null,null,null,null,null,"Ó Landkreis Fulda"]
[]
["Gruppentyp:",{"$f":"IF(A28=1,\"<<<Auswahl treffen!\",VLOOKUP(A28,A29:C32,2,FALSE))","v":"<<<Auswahl treffen!"},null,{"$f":"IF(A28=1,\"<<<Auswahl treffen!\",VLOOKUP(A28,A29:C32,1,FALSE))","v":"<<<Auswahl treffen!"},null,{"$f":"IF(D3=\"<<<Auswahl treffen!\",0,D3)","v":0},{"$f":"IF(F3=4,IF(G21>12,1,0),IF(G21>25,1,0))","v":1}]
[null,{"$f":"IF(F3=2,IF(SUM(C9:D16)>SUM(C13:D16),\"ACHTUNG GRUPPENTYP FALSCH!!!\",\"\"),\"\")","v":""},null,null,null,null,{"$f":"IF(G21=\"\",\"\",G3)","v":""}]
["Mindestpersonalbedarf nach § 25c Abs. 1 und 2 HKJGB in Verbindung mit Ziff. 4.6. der RV Integrationsplatz"]
[]
["Altersgruppe","Betreuungsmittelwert","Vertraglich aufgenommene Kinder",null,null,null,null,"Fachkraftfaktor","Mindestfachkraftstd. pro Woche"]
[null,null,"Kinder ohne Behinderung","Kinder mit Behinderung","Faktor nach 4.5. RV I-Platz","KmB mit Faktor","Zwischensumme"]
["0 - 3 Jahre",22.5,null,null,2,{"$f":"IF(D9>0,D9*E9,\"\")","v":""},{"$f":"IF(SUM(C9:D9)>0,C9+(D9*E9),\"\")","v":""},0.2,{"$f":"IF(G9=\"\",\"\",B9*G9*H9)","v":""}]
[null,30,null,null,2,"","",0.2,""]
[null,42.5,null,null,2,"","",0.2,""]
[null,50,null,null,2,"","",0.2,""]
["3 Jahre bis Schuleintritt",22.5,null,null,{"$f":"IF($F$3=2,IF(K13+L13+O13=0,N13,K13+L13+O13),3)","v":3},{"$f":"IF(D13>0,IF(E13=N13,7,D13*E13),\"\")","v":""},{"$f":"IF(D13=\"\",IF(C13=\"\",\"\",C13),C13+F13)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=1,6,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=2,D13,0)","v":0},{"$f":"IF(M13=2,\"3/4\",0)","v":0},{"$f":"IF(M13=1,3,0)","v":0}]
[null,30,null,null,{"$f":"IF($F$3=2,IF(K14+L14+O14=0,N14,K14+L14+O14),3)","v":3},{"$f":"IF(D14>0,IF(E14=N14,7,D14*E14),\"\")","v":""},{"$f":"IF(D14=\"\",IF(C14=\"\",\"\",C14),C14+F14)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=1,6,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=2,D14,0)","v":0},{"$f":"IF(M14=2,\"3/4\",0)","v":0},{"$f":"IF(M14=1,IF(SUM(M14:M16)=1,4,3),0)","v":0}]
[null,42.5,null,null,3,"",{"$f":"IF(D15=\"\",IF(C15=\"\",\"\",C15),C15+F15)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},0,0,0,{"$f":"IF(M15=1,IF(SUM(M15:M16)=1,4,3),0)","v":0}]
[null,50,null,null,3,"","",7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},0,0,0,{"$f":"IF(M16=1,IF(M16=1,4,3),0)","v":0}]
["Schulkinder",22.5,null,null,1,"","",0.06,""]
[null,30,null,null,1,"","",0.06,""]
[null,42.5,null,null,1,null,"",0.06,""]
[null,50,null,null,1,"","",0.06,""]
["Zwischensumme",{"$f":"IF(G4=1,\"ACHTUNG GRUPPENGRÖßE >>>\",\"\")","v":""},null,null,null,null,{"$f":"IF(SUM(C9:D20)>0,SUM(G9:G20),\"\")","v":""},null,{"$f":"SUM(I9:I20)","v":0}]
["Ausfallzeiten",null,null,null,null,null,null,null,{"$f":"I21/100*15","v":0}]
["Gesamt",null,null,null,null,null,null,null,{"$f":" I21+I22","v":0}]
[]
[]
[]
[]
[1,"Gruppentyp"]
[1,"BITTE WÄHLEN","<<<Auswahl treffen!"]
[2,"ü3-Gruppe",1]
[3,"altergemischte Gruppe",2]
[4,"Krippengruppe",3]

{"sheet":"Gruppe 2","index":4,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,8,7,8],[8,0,11,0],[12,0,15,0],[16,0,19,0],[20,1,20,5],[6,0,7,0],[6,1,7,1],[6,2,6,6],[6,7,7,7]]}
["PERSONALBEDARFSBERECHNUNG",null,null,null,null,null,null,null,"Ó Landkreis Fulda"]
[]
["Gruppentyp:",{"$f":"IF(Dropdownfelder!A1=1,\"<<<Auswahl treffen!\",VLOOKUP(Dropdownfelder!A1,Dropdownfelder!A2:C4,2,FALSE))","v":"<<<Auswahl treffen!"},null,{"$f":"IF(Dropdownfelder!A1=1,\"<<<Auswahl treffen!\",VLOOKUP(Dropdownfelder!A1,Dropdownfelder!A2:C5,1,FALSE))","v":"<<<Auswahl treffen!"},null,{"$f":"IF(D3=\"<<<Auswahl treffen!\",0,D3)","v":0},{"$f":"IF(F3=4,IF(G21>12,1,0),IF(G21>25,1,0))","v":1}]
[null,{"$f":"IF(F3=2,IF(SUM(C9:D16)>SUM(C13:D16),\"ACHTUNG GRUPPENTYP FALSCH!!!\",\"\"),\"\")","v":""},null,null,null,null,{"$f":"IF(G21=\"\",\"\",G3)","v":""}]
["Mindestpersonalbedarf nach § 25c Abs. 1 und 2 HKJGB in Verbindung mit Ziff. 4.6. der RV Integrationsplatz"]
[]
["Altersgruppe","Betreuungsmittelwert","Vertraglich aufgenommene Kinder",null,null,null,null,"Fachkraftfaktor","Mindestfachkraftstd. pro Woche"]
[null,null,"Kinder ohne Behinderung","Kinder mit Behinderung","Faktor nach 4.5. RV I-Platz","KmB mit Faktor","Zwischensumme"]
["0 - 3 Jahre",22.5,null,null,2,{"$f":"IF(D9>0,D9*E9,\"\")","v":""},{"$f":"IF(SUM(C9:D9)>0,C9+(D9*E9),\"\")","v":""},0.2,{"$f":"IF(G9=\"\",\"\",B9*G9*H9)","v":""}]
[null,30,null,null,2,"","",0.2,""]
[null,42.5,null,null,2,"","",0.2,""]
[null,50,null,null,2,"","",0.2,""]
["3 Jahre bis Schuleintritt",22.5,null,null,{"$f":"IF($F$3=2,IF(K13+L13+O13=0,N13,K13+L13+O13),3)","v":3},{"$f":"IF(D13>0,IF(E13=N13,7,D13*E13),\"\")","v":""},{"$f":"IF(D13=\"\",IF(C13=\"\",\"\",C13),C13+F13)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=1,6,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=2,D13,0)","v":0},{"$f":"IF(M13=2,\"3/4\",0)","v":0},{"$f":"IF(M13=1,3,0)","v":0}]
[null,30,null,null,{"$f":"IF($F$3=2,IF(K14+L14+O14=0,N14,K14+L14+O14),3)","v":3},{"$f":"IF(D14>0,IF(E14=N14,7,D14*E14),\"\")","v":""},{"$f":"IF(D14=\"\",IF(C14=\"\",\"\",C14),C14+F14)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=1,6,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=2,D14,0)","v":0},{"$f":"IF(M14=2,\"3/4\",0)","v":0},{"$f":"IF(M14=1,IF(SUM(M14:M16)=1,4,3),0)","v":0}]
[null,42.5,null,null,3,{"$f":"IF(D15>0,IF(E15=N15,7,D15*E15),\"\")","v":""},{"$f":"IF(D15=\"\",IF(C15=\"\",\"\",C15),C15+F15)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},0,0,0,{"$f":"IF(M15=1,IF(SUM(M15:M16)=1,4,3),0)","v":0}]
[null,50,null,null,3,"","",7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},0,0,0,{"$f":"IF(M16=1,IF(M16=1,4,3),0)","v":0}]
["Schulkinder",22.5,null,null,1,"","",0.06,""]
[null,30,null,null,1,"","",0.06,""]
[null,42.5,null,null,1,null,"",0.06,""]
[null,50,null,null,1,"","",0.06,""]
["Zwischensumme",{"$f":"IF(G4=1,\"ACHTUNG GRUPPENGRÖßE >>>\",\"\")","v":""},null,null,null,null,{"$f":"IF(SUM(C9:D20)>0,SUM(G9:G20),\"\")","v":""},null,{"$f":"SUM(I9:I20)","v":0}]
["Ausfallzeiten",null,null,null,null,null,null,null,{"$f":"I21/100*15","v":0}]
["Gesamt",null,null,null,null,null,null,null,{"$f":" I21+I22","v":0}]

{"sheet":"Gruppe 3","index":5,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,8,7,8],[8,0,11,0],[12,0,15,0],[16,0,19,0],[20,1,20,5],[6,0,7,0],[6,1,7,1],[6,2,6,6],[6,7,7,7]]}
["PERSONALBEDARFSBERECHNUNG",null,null,null,null,null,null,null,"Ó Landkreis Fulda"]
[]
["Gruppentyp:",{"$f":"IF(A28=1,\"<<<Auswahl treffen!\",VLOOKUP(A28,A29:C32,2,FALSE))","v":"<<<Auswahl treffen!"},null,{"$f":"IF(A28=1,\"<<<Auswahl treffen!\",VLOOKUP(A28,A29:C32,1,FALSE))","v":"<<<Auswahl treffen!"},null,{"$f":"IF(D3=\"<<<Auswahl treffen!\",0,D3)","v":0},{"$f":"IF(F3=4,IF(G21>12,1,0),IF(G21>25,1,0))","v":1}]
[null,{"$f":"IF(F3=2,IF(SUM(C9:D16)>SUM(C13:D16),\"ACHTUNG GRUPPENTYP FALSCH!!!\",\"\"),\"\")","v":""},null,null,null,null,{"$f":"IF(G21=\"\",\"\",G3)","v":""}]
["Mindestpersonalbedarf nach § 25c Abs. 1 und 2 HKJGB in Verbindung mit Ziff. 4.6. der RV Integrationsplatz"]
[]
["Altersgruppe","Betreuungsmittelwert","Vertraglich aufgenommene Kinder",null,null,null,null,"Fachkraftfaktor","Mindestfachkraftstd. pro Woche"]
[null,null,"Kinder ohne Behinderung","Kinder mit Behinderung","Faktor nach 4.5. RV I-Platz","KmB mit Faktor","Zwischensumme"]
["0 - 3 Jahre",22.5,null,null,2,{"$f":"IF(D9>0,D9*E9,\"\")","v":""},{"$f":"IF(SUM(C9:D9)>0,C9+(D9*E9),\"\")","v":""},0.2,{"$f":"IF(G9=\"\",\"\",B9*G9*H9)","v":""}]
[null,30,null,null,2,"","",0.2,""]
[null,42.5,null,null,2,"","",0.2,""]
[null,50,null,null,2,"","",0.2,""]
["3 Jahre bis Schuleintritt",22.5,null,null,{"$f":"IF($F$3=2,IF(K13+L13+O13=0,N13,K13+L13+O13),3)","v":3},{"$f":"IF(D13>0,IF(E13=N13,7,D13*E13),\"\")","v":""},{"$f":"IF(D13=\"\",IF(C13=\"\",\"\",C13),C13+F13)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=1,6,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=2,D13,0)","v":0},{"$f":"IF(M13=2,\"3/4\",0)","v":0},{"$f":"IF(M13=1,3,0)","v":0}]
[null,30,null,null,{"$f":"IF($F$3=2,IF(K14+L14+O14=0,N14,K14+L14+O14),3)","v":3},{"$f":"IF(D14>0,IF(E14=N14,7,D14*E14),\"\")","v":""},{"$f":"IF(D14=\"\",IF(C14=\"\",\"\",C14),C14+F14)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=1,6,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=2,D14,0)","v":0},{"$f":"IF(M14=2,\"3/4\",0)","v":0},{"$f":"IF(M14=1,IF(SUM(M14:M16)=1,4,3),0)","v":0}]
[null,42.5,null,null,3,{"$f":"IF(D15>0,IF(E15=N15,7,D15*E15),\"\")","v":""},{"$f":"IF(D15=\"\",IF(C15=\"\",\"\",C15),C15+F15)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},0,0,0,{"$f":"IF(M15=1,IF(SUM(M15:M16)=1,4,3),0)","v":0}]
[null,50,null,null,3,"","",7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},0,0,0,{"$f":"IF(M16=1,IF(M16=1,4,3),0)","v":0}]
["Schulkinder",22.5,null,null,1,"","",0.06,""]
[null,30,null,null,1,"","",0.06,""]
[null,42.5,null,null,1,"","",0.06,""]
[null,50,null,null,1,"","",0.06,""]
["Zwischensumme",{"$f":"IF(G4=1,\"ACHTUNG GRUPPENGRÖßE >>>\",\"\")","v":""},null,null,null,null,{"$f":"IF(SUM(C9:D20)>0,SUM(G9:G20),\"\")","v":""},null,{"$f":"SUM(I9:I20)","v":0}]
["Ausfallzeiten",null,null,null,null,null,null,null,{"$f":"I21/100*15","v":0}]
["Gesamt",null,null,null,null,null,null,null,{"$f":" I21+I22","v":0}]
[]
[]
[]
[]
[1,"Gruppentyp"]
[1,"BITTE WÄHLEN","<<<Auswahl treffen!"]
[2,"ü3-Gruppe",1]
[3,"altergemischte Gruppe",2]
[4,"Krippengruppe",3]

{"sheet":"Gruppe 4","index":6,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,8,7,8],[8,0,11,0],[12,0,15,0],[16,0,19,0],[20,1,20,5],[6,0,7,0],[6,1,7,1],[6,2,6,6],[6,7,7,7]]}
["PERSONALBEDARFSBERECHNUNG",null,null,null,null,null,null,null,"Ó Landkreis Fulda"]
[]
["Gruppentyp:",{"$f":"IF(A28=1,\"<<<Auswahl treffen!\",VLOOKUP(A28,A29:C32,2,FALSE))","v":"<<<Auswahl treffen!"},null,{"$f":"IF(A28=1,\"<<<Auswahl treffen!\",VLOOKUP(A28,A29:C32,1,FALSE))","v":"<<<Auswahl treffen!"},null,{"$f":"IF(D3=\"<<<Auswahl treffen!\",0,D3)","v":0},{"$f":"IF(F3=4,IF(G21>12,1,0),IF(G21>25,1,0))","v":1}]
[null,{"$f":"IF(F3=2,IF(SUM(C9:D16)>SUM(C13:D16),\"ACHTUNG GRUPPENTYP FALSCH!!!\",\"\"),\"\")","v":""},null,null,null,null,{"$f":"IF(G21=\"\",\"\",G3)","v":""}]
["Mindestpersonalbedarf nach § 25c Abs. 1 und 2 HKJGB in Verbindung mit Ziff. 4.6. der RV Integrationsplatz"]
[]
["Altersgruppe","Betreuungsmittelwert","Vertraglich aufgenommene Kinder",null,null,null,null,"Fachkraftfaktor","Mindestfachkraftstd. pro Woche"]
[null,null,"Kinder ohne Behinderung","Kinder mit Behinderung","Faktor nach 4.5. RV I-Platz","KmB mit Faktor","Zwischensumme"]
["0 - 3 Jahre",22.5,null,null,2,{"$f":"IF(D9>0,D9*E9,\"\")","v":""},{"$f":"IF(SUM(C9:D9)>0,C9+(D9*E9),\"\")","v":""},0.2,{"$f":"IF(G9=\"\",\"\",B9*G9*H9)","v":""}]
[null,30,null,null,2,"","",0.2,""]
[null,42.5,null,null,2,"","",0.2,""]
[null,50,null,null,2,"","",0.2,""]
["3 Jahre bis Schuleintritt",22.5,null,null,{"$f":"IF($F$3=2,IF(K13+L13+O13=0,N13,K13+L13+O13),3)","v":3},{"$f":"IF(D13>0,IF(E13=N13,7,D13*E13),\"\")","v":""},{"$f":"IF(D13=\"\",IF(C13=\"\",\"\",C13),C13+F13)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=1,6,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=2,D13,0)","v":0},{"$f":"IF(M13=2,\"3/4\",0)","v":0},{"$f":"IF(M13=1,3,0)","v":0}]
[null,30,null,null,{"$f":"IF($F$3=2,IF(K14+L14+O14=0,N14,K14+L14+O14),3)","v":3},{"$f":"IF(D14>0,IF(E14=N14,7,D14*E14),\"\")","v":""},{"$f":"IF(D14=\"\",IF(C14=\"\",\"\",C14),C14+F14)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=1,6,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=2,D14,0)","v":0},{"$f":"IF(M14=2,\"3/4\",0)","v":0},{"$f":"IF(M14=1,IF(SUM(M14:M16)=1,4,3),0)","v":0}]
[null,42.5,null,null,3,{"$f":"IF(D15>0,IF(E15=N15,7,D15*E15),\"\")","v":""},{"$f":"IF(D15=\"\",IF(C15=\"\",\"\",C15),C15+F15)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},0,0,0,{"$f":"IF(M15=1,IF(SUM(M15:M16)=1,4,3),0)","v":0}]
[null,50,null,null,3,"","",7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},0,0,0,{"$f":"IF(M16=1,IF(M16=1,4,3),0)","v":0}]
["Schulkinder",22.5,null,null,1,"","",0.06,""]
[null,30,null,null,1,"","",0.06,""]
[null,42.5,null,null,1,"","",0.06,""]
[null,50,null,null,1,"","",0.06,""]
["Zwischensumme",{"$f":"IF(G4=1,\"ACHTUNG GRUPPENGRÖßE >>>\",\"\")","v":""},null,null,null,null,{"$f":"IF(SUM(C9:D20)>0,SUM(G9:G20),\"\")","v":""},null,{"$f":"SUM(I9:I20)","v":0}]
["Ausfallzeiten",null,null,null,null,null,null,null,{"$f":"I21/100*15","v":0}]
["Gesamt",null,null,null,null,null,null,null,{"$f":" I21+I22","v":0}]
[]
[]
[]
[]
[1,"Gruppentyp"]
[1,"BITTE WÄHLEN","<<<Auswahl treffen!"]
[2,"ü3-Gruppe",1]
[3,"altergemischte Gruppe",2]
[4,"Krippengruppe",3]

{"sheet":"Gruppe 5","index":7,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,8,7,8],[8,0,11,0],[12,0,15,0],[16,0,19,0],[20,1,20,5],[6,0,7,0],[6,1,7,1],[6,2,6,6],[6,7,7,7]]}
["PERSONALBEDARFSBERECHNUNG",null,null,null,null,null,null,null,"Ó Landkreis Fulda"]
[]
["Gruppentyp:",{"$f":"IF(A28=1,\"<<<Auswahl treffen!\",VLOOKUP(A28,A29:C32,2,FALSE))","v":"<<<Auswahl treffen!"},null,{"$f":"IF(A28=1,\"<<<Auswahl treffen!\",VLOOKUP(A28,A29:C32,1,FALSE))","v":"<<<Auswahl treffen!"},null,{"$f":"IF(D3=\"<<<Auswahl treffen!\",0,D3)","v":0},{"$f":"IF(F3=4,IF(G21>12,1,0),IF(G21>25,1,0))","v":1}]
[null,{"$f":"IF(F3=2,IF(SUM(C9:D16)>SUM(C13:D16),\"ACHTUNG GRUPPENTYP FALSCH!!!\",\"\"),\"\")","v":""},null,null,null,null,{"$f":"IF(G21=\"\",\"\",G3)","v":""}]
["Mindestpersonalbedarf nach § 25c Abs. 1 und 2 HKJGB in Verbindung mit Ziff. 4.6. der RV Integrationsplatz"]
[]
["Altersgruppe","Betreuungsmittelwert","Vertraglich aufgenommene Kinder",null,null,null,null,"Fachkraftfaktor","Mindestfachkraftstd. pro Woche"]
[null,null,"Kinder ohne Behinderung","Kinder mit Behinderung","Faktor nach 4.5. RV I-Platz","KmB mit Faktor","Zwischensumme"]
["0 - 3 Jahre",22.5,null,null,2,{"$f":"IF(D9>0,D9*E9,\"\")","v":""},{"$f":"IF(SUM(C9:D9)>0,C9+(D9*E9),\"\")","v":""},0.2,{"$f":"IF(G9=\"\",\"\",B9*G9*H9)","v":""}]
[null,30,null,null,2,"","",0.2,""]
[null,42.5,null,null,2,"","",0.2,""]
[null,50,null,null,2,"","",0.2,""]
["3 Jahre bis Schuleintritt",22.5,null,null,{"$f":"IF($F$3=2,IF(K13+L13+O13=0,N13,K13+L13+O13),3)","v":3},{"$f":"IF(D13>0,IF(E13=N13,7,D13*E13),\"\")","v":""},{"$f":"IF(D13=\"\",IF(C13=\"\",\"\",C13),C13+F13)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=1,6,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=2,D13,0)","v":0},{"$f":"IF(M13=2,\"3/4\",0)","v":0},{"$f":"IF(M13=1,3,0)","v":0}]
[null,30,null,null,{"$f":"IF($F$3=2,IF(K14+L14+O14=0,N14,K14+L14+O14),3)","v":3},{"$f":"IF(D14>0,IF(E14=N14,7,D14*E14),\"\")","v":""},{"$f":"IF(D14=\"\",IF(C14=\"\",\"\",C14),C14+F14)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=1,6,0)","v":0},{"$f":"IF(SUM($D$13:$D$16)=2,D14,0)","v":0},{"$f":"IF(M14=2,\"3/4\",0)","v":0},{"$f":"IF(M14=1,IF(SUM(M14:M16)=1,4,3),0)","v":0}]
[null,42.5,null,null,3,{"$f":"IF(D15>0,IF(E15=N15,7,D15*E15),\"\")","v":""},{"$f":"IF(D15=\"\",IF(C15=\"\",\"\",C15),C15+F15)","v":""},7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},0,0,0,{"$f":"IF(M15=1,IF(SUM(M15:M16)=1,4,3),0)","v":0}]
[null,50,null,null,3,"","",7.0000000000000007E-2,"",null,{"$f":"IF(SUM($D$13:$D$16)>2,3,0)","v":0},0,0,0,{"$f":"IF(M16=1,IF(M16=1,4,3),0)","v":0}]
["Schulkinder",22.5,null,null,1,"","",0.06,""]
[null,30,null,null,1,"","",0.06,""]
[null,42.5,null,null,1,"","",0.06,""]
[null,50,null,null,1,"","",0.06,""]
["Zwischensumme",{"$f":"IF(G4=1,\"ACHTUNG GRUPPENGRÖßE >>>\",\"\")","v":""},null,null,null,null,{"$f":"IF(SUM(C9:D20)>0,SUM(G9:G20),\"\")","v":""},null,{"$f":"SUM(I9:I20)","v":0}]
["Ausfallzeiten",null,null,null,null,null,null,null,{"$f":"I21/100*15","v":0}]
["Gesamt",null,null,null,null,null,null,null,{"$f":" I21+I22","v":0}]
[]
[]
[]
[]
[1,"Gruppentyp"]
[1,"BITTE WÄHLEN","<<<Auswahl treffen!"]
[2,"ü3-Gruppe",1]
[3,"altergemischte Gruppe",2]
[4,"Krippengruppe",3]

{"sheet":"Dropdownfelder","index":8,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[1,"Gruppentyp"]
[1,"BITTE WÄHLEN","<<<Auswahl treffen!"]
[2,"ü3-Gruppe",1]
[3,"altergemischte Gruppe",2]
[4,"Krippengruppe",3]