{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["TN-Liste","Auswertung"],"read":"whole","date_system":"1900"}

{"sheet":"TN-Liste","index":0,"n_rows":40,"n_cols":28,"rows_kept":40}
["Teilnehmerliste Lehrerfortbildung VERANSTALTUNGSTITEL"]
[{"$nulls":9},"Stand:",{"$f":"TODAY()","v":"2024-09-25"},"Konfession / Religion:",null,"Anstellung:",null,"Übernachtung:",null,"Essenswünsche:",null,"TN mit Zugehörigkeit zu SDs:"]
["LFB-Nr:",null,"xxxxx",{"$nulls":6},"V.-DATUM und UHRZEIT",{"$nulls":9},{"$f":"+COUNTIF(N11:N38,U3)","v":0},{"$f":"Auswertung!E7","v":"evSD Biberach"}]
["Referentinnen:",null,"NN",{"$nulls":6},"VERANSTALTUNGSORT ",null,{"$f":"+COUNTIF(Q11:Q38,M4)","v":0},"evangelisch",{"$f":"+COUNTIF(O9:O38,O4)","v":0},"kirchlich",{"$f":"+COUNTIF(V11:V38,Q4)","v":0},"ohne",{"$f":"+COUNTIF(T11:T38,S4)","v":0},"keine",{"$f":"+COUNTIF(N11:N38,U4)","v":0},{"$f":"Auswertung!E12","v":"evSD Heilbronn"}]
["Leitung:",null,"NN",{"$nulls":6},"ADRSSE [Straße]",null,{"$f":"+COUNTIF(Q11:Q38,M5)","v":0},"katholisch",{"$f":"+COUNTIF(O11:O38,O5)","v":0},"staatlich",{"$f":"+COUNTIF(V11:V38,Q5)","v":0},"EZ",{"$f":"+COUNTIF(T11:T38,S5)","v":0},"vegetarisch",{"$f":"+COUNTIF(N11:N38,U5)","v":0},{"$f":"Auswertung!E20","v":"evSD Schwäbisch-Gmünd"}]
["ZSL-Verantwortl.:",null,"NN",{"$nulls":6},"ADRSSE [PLZ-ORT]",null,{"$f":"+COUNTIF(Q11:Q38,M6)","v":0},"muslimisch",{"$f":"+COUNTIF(O11:O38,O6)","v":0},"privat",{"$f":"+COUNTIF(V11:V38,Q6)","v":0},"DZ",{"$f":"+COUNTIF(T11:T38,S6)","v":0},"vegan",{"$f":"+COUNTIF(N11:N38,U6)","v":0},{"$f":"Auswertung!E26","v":"sonstige SD / extern"}]
[{"$nulls":11},{"$f":"+COUNTIF(Q11:Q38,M7)","v":0},"sonstiges",{"$nulls":6},{"$f":"Auswertung!D27","v":0},"Anzahl gesamt (alle TN, Ref. & Leitung)"]
[]
["Nr.","Anmeldedatum","Anrede","Name","Vorname","Straße","PLZ","Wohnort","Telefon / Handy","E-Mail","Schule / Einrichtung","Schulort","Schulart","SD","Anstellung","Dienstbezeichnung","Konf.","Mahlzeiten \nAnreisetag","Mahlzeiten \nAbreisetag","Essens- wünsche","Unverträg-lichkeiten","Über- nachtung","Bemerkung","Unterschrift","Eintrag durch","Antwort Frage 1","Antwort Frage 2","Antwort Frage 3"]
[null,"Teilnehmer*innen"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[]
[null,"Leitung"]
[]
[]
[]
[null,"Referenten*innen"]
[]
[]
[]
[null,"Abgemeldete Teilnehmer*innen"]

{"sheet":"Auswertung","index":1,"n_rows":27,"n_cols":5,"rows_kept":27}
["Auswertung zur "]
[{"$f":"'TN-Liste'!A1:W1","v":"Teilnehmerliste Lehrerfortbildung VERANSTALTUNGSTITEL"}]
[]
["Stand:",{"$f":"TODAY()","v":"2024-09-25"},null,"TN mit Zugehörigkeit zu SDs:"]
[{"$f":"'TN-Liste'!J3","v":"V.-DATUM und UHRZEIT"},null,null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E5)","v":0},"evSD Backnang"]
[{"$f":"'TN-Liste'!J4","v":"VERANSTALTUNGSORT "},null,null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E6)","v":0},"evSD Balingen"]
[{"$f":"'TN-Liste'!J5","v":"ADRSSE [Straße]"},null,null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E7)","v":0},"evSD Biberach"]
[{"$f":"'TN-Liste'!J6","v":"ADRSSE [PLZ-ORT]"},null,null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E8)","v":0},"evSD Calw"]
[{"$f":"'TN-Liste'!A3","v":"LFB-Nr:"},{"$f":"'TN-Liste'!C3","v":"xxxxx"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E9)","v":0},"evSD Esslingen"]
[{"$f":"'TN-Liste'!A4","v":"Referentinnen:"},{"$f":"'TN-Liste'!C4","v":"NN"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E10)","v":0},"evSD Freudenstadt"]
[{"$f":"'TN-Liste'!A5","v":"Leitung:"},{"$f":"'TN-Liste'!C5","v":"NN"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E11)","v":0},"evSD Göppingen"]
[{"$f":"'TN-Liste'!A6","v":"ZSL-Verantwortl.:"},{"$f":"'TN-Liste'!C6","v":"NN"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E12)","v":0},"evSD Heilbronn"]
[{"$nulls":3},{"$f":"+COUNTIF('TN-Liste'!N11:N38,E13)","v":0},"evSD Leonberg"]
["Anstellung:",null,null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E14)","v":0},"evSD Ludwigsburg"]
[{"$f":"+COUNTIF('TN-Liste'!O11:O38,B15)","v":0},{"$f":"'TN-Liste'!O4","v":"kirchlich"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E15)","v":0},"evSD Nürtingen"]
[{"$f":"+COUNTIF('TN-Liste'!O11:O38,B16)","v":0},{"$f":"'TN-Liste'!O5","v":"staatlich"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E16)","v":0},"evSD Öhringen"]
[{"$f":"+COUNTIF('TN-Liste'!O11:O38,B17)","v":0},{"$f":"'TN-Liste'!O6","v":"privat"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E17)","v":0},"evSD Ravensburg"]
[{"$nulls":3},{"$f":"+COUNTIF('TN-Liste'!N11:N38,E18)","v":0},"evSD Reutlingen"]
["Übernachtung:",null,null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E19)","v":0},"evSD Schorndorf"]
[{"$f":"+COUNTIF('TN-Liste'!V11:V38,B20)","v":0},{"$f":"'TN-Liste'!Q4","v":"ohne"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E20)","v":0},"evSD Schwäbisch-Gmünd"]
[{"$f":"+COUNTIF('TN-Liste'!V11:V38,B21)","v":0},{"$f":"'TN-Liste'!Q5","v":"EZ"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E21)","v":0},"evSD Schwäbisch Hall"]
[{"$f":"+COUNTIF('TN-Liste'!V11:V38,B22)","v":0},{"$f":"'TN-Liste'!Q6","v":"DZ"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E22)","v":0},"evSD Stuttgart"]
[{"$nulls":3},{"$f":"+COUNTIF('TN-Liste'!N11:N38,E23)","v":0},"evSD Tübingen"]
["Essenswünsche:",null,null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E24)","v":0},"evSD Ulm"]
[{"$f":"+COUNTIF('TN-Liste'!T11:T38,B25)","v":0},{"$f":"'TN-Liste'!S4","v":"keine"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E25)","v":0},"evSD Vaihingen"]
[{"$f":"+COUNTIF('TN-Liste'!T11:T38,B26)","v":0},{"$f":"'TN-Liste'!S5","v":"vegetarisch"},null,{"$f":"+COUNTIF('TN-Liste'!N11:N38,E26)","v":0},"sonstige SD / extern"]
[{"$f":"+COUNTIF('TN-Liste'!T11:T38,B27)","v":0},{"$f":"'TN-Liste'!S6","v":"vegan"},null,{"$f":"SUM(D5:D26)","v":0},"Anzahl gesamt (alle TN, Ref. & Leitung)"]