{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["LB","Zeugnis","S","L","A"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":172,"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":"LB","index":0,"n_rows":195,"n_cols":20,"rows_kept":195,"cut":false,"hidden":false,"merged":[[193,14,195,14],[10,14,12,14],[167,14,168,14],[148,14,149,14],[136,14,138,14],[97,14,99,14],[52,14,54,14],[59,14,61,14],[18,14,20,14],[38,14,40,14],[63,14,65,14],[129,4,129,7],[131,4,131,7],[133,4,133,7],[165,10,165,12],[167,10,167,12],[138,3,138,7],[135,3,135,7],[135,10,135,12],[164,10,164,12],[159,4,159,7],[162,2,162,12],[163,10,163,12],[167,3,167,7],[157,2,158,12],[168,10,168,12],[164,3,164,7],[61,10,61,12],[62,10,62,12],[154,4,154,7],[136,10,136,12],[138,10,138,12],[139,10,139,12],[97,10,97,12],[99,10,99,12],[100,10,100,12],[99,3,99,7],[118,2,118,12],[113,3,113,7],[113,10,113,12],[88,2,88,12],[91,2,91,12],[94,2,94,12],[96,10,96,12],[104,3,104,7],[127,2,127,12],[107,3,107,7],[107,10,107,12],[109,3,109,7],[109,10,109,12],[111,3,111,7],[121,2,121,12],[124,2,124,12],[115,3,115,7],[115,10,115,12],[59,2,59,12],[61,3,61,7],[96,3,96,7],[68,10,68,12],[70,10,70,12],[74,10,74,12],[76,10,76,12],[79,2,79,12],[82,2,82,12],[66,3,66,7],[68,3,68,7],[70,3,70,7],[72,3,72,7],[74,3,74,7],[76,3,76,7],[85,2,85,12],[50,3,50,7],[48,10,48,12],[12,3,12,7],[52,3,52,7],[54,3,54,7],[16,10,16,12],[18,3,18,12],[50,10,50,12],[25,2,25,12],[28,2,28,12],[31,2,31,12],[34,2,34,12],[37,2,37,12],[40,2,40,12],[44,3,44,7],[46,3,46,7],[48,3,48,7],[6,10,6,12],[12,10,12,12],[16,3,16,7],[20,3,20,7],[20,10,20,12],[6,3,6,7],[8,3,8,7],[10,3,10,7],[10,10,10,12]]}
[null,null,{"$f":"CONCATENATE(S_Typ,\" \",S_Verfasser)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"Arbeit:",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Dateiname0,\"ö\",\"oe\"),\"ä\",\"ae\"),\"ü\",\"ue\"),\"Ö\",\"Oe\"),\"Ä\",\"Ae\"),\"Ü\",\"Ue\"),\"é\",\"e\"),\"è\",\"e\")","v":"SA21____"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(A_Name,\"_\",UPPER(B_Kuerzel),\"_\",S_Name,\"_\",S_Vorname,\"_\",S_Klasse)","v":"SA21____"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datei:"]
[]
[null,null,"1 Personalien (durch Verfasser auzufüllen)",null,null,null,null,null,null,null,null,"Termin:",{"$f":"T_Themenabgabe","v":"2020-12-18"},null,null,"Vollständig:",{"$f":"AND(Q7:Q13)","v":false}]
[]
[null,null,{"$f":"IF(S_Weiblich,\"Verfasserin:\",\"Verfasser:\")","v":"Verfasser:"},null,null,null,null,null,null,"Nr. EcoOpen:",{"$f":"IF($Q$7,VLOOKUP($S$7,S_Daten,2,FALSE),\"\")","v":""},null,null,null,null,"Auswahl:",{"$f":"NOT(ISERROR(VLOOKUP(D7,S!A:B,2,FALSE)))","v":false},"Nummer:",{"$f":"IF(Q7,VLOOKUP(D7,S!A:B,2,FALSE),\"\")","v":""}]
[]
[null,null,{"$f":"IF(S_Weiblich,\"Verfasserin Name:\",\"Verfasser Name:\")","v":"Verfasser Name:"},{"$f":"IF($Q$7,VLOOKUP($S$7,S_Daten,4,FALSE),\"\")","v":""},null,null,null,null,null,"Vorname:",{"$f":"IF($Q$7,VLOOKUP($S$7,S_Daten,5,FALSE),\"\")","v":""},"Klasse:",{"$f":"IF($Q$7,VLOOKUP($S$7,S_Daten,6,FALSE),\"\")","v":""},null,null,"Ausgefüllt:",{"$f":"AND(S_Name<>\"\",S_Vorname<>\"\",S_Klasse<>\"\")","v":false},"Weiblich:",{"$f":"IF(Q7,IF(VLOOKUP($S$7,S_Daten,14,FALSE)=\"w\",TRUE,FALSE),FALSE)","v":false}]
[]
[null,null,"Adresse:",{"$f":"IF($Q$7,VLOOKUP($S$7,S_Daten,7,FALSE),\"\")","v":""},null,null,null,null,null,"PLZ Ort:",{"$f":"IF($Q$7,CONCATENATE(VLOOKUP($S$7,S_Daten,8,FALSE),\" \",VLOOKUP($S$7,S_Daten,9,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF(Q5,1,0)","v":0},"Ausgefüllt:",{"$f":"AND(S_Adresse<>\"\",S_Ort<>\"\")","v":false}]
[]
[null,null,"Telefon:",{"$f":"IF($Q$7,VLOOKUP($S$7,S_Daten,11,FALSE),\"\")","v":""},null,null,null,null,null,"Mailadresse:",{"$f":"IF($Q$7,VLOOKUP($S$7,S_Daten,13,FALSE),\"\")","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(S_Adresse<>\"\",S_Ort<>\"\")","v":false}]
[]
[null,null,"2 Allgemeine Angaben (durch Verfasser auszufüllen)",null,null,null,null,null,null,null,null,null,null,null,null,"Vollständig:",{"$f":"AND(Q17:Q21,S21)","v":false}]
[]
[null,null,"Typ:",null,null,null,null,null,null,"Fach:",null,null,null,null,null,"Ausgefüllt:",{"$f":"AND(S_Typ<>\"\",S_Richtung<>\"\")","v":false},{"$f":"IF(ISERROR(VLOOKUP(S_Typ,A!B3:D6,2,FALSE)),\"LEER\",VLOOKUP(S_Typ,A!B3:D6,2,FALSE))","v":"LEER"},{"$f":"VLOOKUP(S_Richtung,X_Richtung_Zeile,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Q19,VLOOKUP(S_Fach,A_FachKuerzel,2,FALSE),\"\")","v":""}]
[]
[null,null,"Richtung:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q15,1,0)","v":0},"Ausgefüllt:",{"$f":"S_Fach<>\"\"","v":false}]
[]
[null,null,"Einzel-/Gruppenarb.:",null,null,null,null,null,null,{"$f":"IF(S_Einzel=\"Gruppenarbeit\",\"Grp.arbeit mit:\",\"\")","v":""},null,null,null,null,null,"Ausgefüllt:",{"$f":"S_Einzel<>\"\"","v":false},"Ausgefüllt:",{"$f":"NOT(AND(S_Einzel=\"Gruppenarbeit\",S_GrpMit=\"\"))","v":true}]
[]
[null,null,"3 Themenvorschlag (durch Verfasser auszufüllen)",null,null,null,null,null,null,null,null,null,null,null,null,"Vollständig:",{"$f":"AND(Q26:Q35)","v":false}]
[]
[null,null,"Arbeitstitel:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"S_Arbeitstitel<>\"\"","v":false}]
[]
[null,null,"Mögliche Leitfragen: (Fragen, die ich mit meiner Arbeit beantworten möchte)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"S_Leitfragen<>\"\"","v":false}]
[]
[null,null,"Eigenleistung:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"S_Eigenleistung<>\"\"","v":false}]
[]
[null,null,"Persönliche Motivation: (persönlicher Bezug, Erfahrungshintergrund, vorhandene und angestrebte Kenntnisse)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"S_Motivation<>\"\"","v":false}]
[]
[null,null,"Thema wurde abgesprochen mit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"S_Absprache<>\"\"","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q23,1,0)","v":0}]
[null,null,{"$f":"IF(S_Einzel=\"Gruppenarbeit\",\"Begründung für Gruppenarbeit:\",\"Bemerkungen\")","v":"Bemerkungen"}]
[]
[]
[null,null,"4 Entscheid Fachschaft (durch die Fachschaft auszufüllen)",null,null,null,null,null,null,null,null,"Termin:",{"$f":"T_ZuweisungBetKor","v":"2021-01-08"},null,null,"Vollständig:",{"$f":"AND(Q45:Q53)","v":false}]
[]
[null,null,{"$f":"IF(B_Weiblich,\"Berteuerin:\",\"Betreuer:\")","v":"Betreuer:"},null,null,null,null,null,null,null,null,null,null,null,null,"Auswahl:",{"$f":"NOT(ISERROR(VLOOKUP(D45,L!A:B,2,FALSE)))","v":false},"Nummer:",{"$f":"IF(Q45,VLOOKUP(D45,L!A:B,2,FALSE),\"\")","v":""}]
[]
[null,null,{"$f":"IF(B_Weiblich,\"Betreuerin Name:\",\"Betreuer Name:\")","v":"Betreuer Name:"},{"$f":"IF($Q$45,VLOOKUP($S$45,L_Daten,3,FALSE),\"\")","v":""},null,null,null,null,null,"Vorname:",{"$f":"IF($Q$45,VLOOKUP($S$45,L_Daten,4,FALSE),\"\")","v":""},"Kürzel:",{"$f":"UPPER(IF($Q$45,VLOOKUP($S$45,L_Daten,5,FALSE),\"\"))","v":""},null,null,"Ausgefüllt:",{"$f":"AND(B_Name<>\"\",B_Vorname<>\"\",B_Kuerzel<>\"\")","v":false},"Weiblich:",{"$f":"IF(Q45,IF(VLOOKUP($S$45,L_Daten,15,FALSE)=\"w\",TRUE,FALSE),FALSE)","v":false}]
[]
[null,null,"Adresse:",{"$f":"IF($Q$45,VLOOKUP($S$45,L_Daten,6,FALSE),\"\")","v":""},null,null,null,null,null,"PLZ Ort:",{"$f":"IF($Q$45,CONCATENATE(VLOOKUP($S$45,L_Daten,7,FALSE),\" \",VLOOKUP($S$45,L_Daten,8,FALSE)),\"\")","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(B_Adresse<>\"\",B_Ort<>\"\")","v":false}]
[]
[null,null,"Telefon:",{"$f":"IF($Q$45,VLOOKUP($S$45,L_Daten,12,FALSE),\"\")","v":""},null,null,null,null,null,"Mailadresse:",{"$f":"IF($Q$45,VLOOKUP($S$45,L_Daten,14,FALSE),\"\")","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(B_Telefon<>\"\",B_Mail<>\"\")","v":false}]
[]
[null,null,{"$f":"IF(K_Weiblich,\"Korreferentin:\",\"Korreferent:\")","v":"Korreferent:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q43,1,0)","v":0},"Auswahl:",{"$f":"NOT(ISERROR(VLOOKUP(K_Korreferent,L!A:B,2,FALSE)))","v":false},"Nummer:",{"$f":"IF(Q53,VLOOKUP(D53,L!A:B,2,FALSE),\"\")","v":""}]
[]
[null,null,{"$f":"IF(K_Weiblich,\"Korreferentin Name:\",\"Korreferent Name:\")","v":"Korreferent Name:"},{"$f":"IF($Q$53,VLOOKUP($S$53,L_Daten,3,FALSE),\"\")","v":""},null,null,null,null,null,"Vorname:",{"$f":"IF($Q$53,VLOOKUP($S$53,L_Daten,4,FALSE),\"\")","v":""},"Kürzel:",{"$f":"UPPER(IF($Q$53,VLOOKUP($S$53,L_Daten,5,FALSE),\"\"))","v":""},null,null,"Ausgefüllt:",{"$f":"AND(K_Name<>\"\",K_Vorname<>\"\",K_Kuerzel<>\"\")","v":false},"Weiblich:",{"$f":"IF(Q53,IF(VLOOKUP($S$53,L_Daten,15,FALSE)=\"w\",TRUE,FALSE),FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$53,VLOOKUP($S$53,L_Daten,14,FALSE),\"\")","v":""}]
[null,null,"5 Entscheid Schulleitung (durch die Schulleitung auszufüllen)",null,null,null,null,null,null,null,null,"Termin:",{"$f":"T_BewilligungSL","v":"2021-01-15"},null,null,"Vollständig:",{"$f":"AND(Q60:Q62)","v":false}]
[]
[null,null,"Entscheid:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q57,1,0)","v":0},"Ausgefüllt:",{"$f":"SL_Entscheid<>\"\"","v":false}]
[]
[null,null,"Ort, Datum:",null,null,null,null,null,null,"Unterschrift SL:",{"$f":"IF(SL_Entscheid<>\"\",VLOOKUP(S_Typ_Abkuerzung,A!C3:G6,4,FALSE),\"\")","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"SL_Datum<>\"\"","v":false}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SL_Entscheid<>\"\",VLOOKUP(S_Typ_Abkuerzung,A!C3:G6,5,FALSE),\"\")","v":""}]
[]
[null,null,"6 Projektvertrag (durch Betreuer und Verfasser auszufüllen, fakultativ für Fachmaturitätsarbeit)",null,null,null,null,null,null,null,null,"Termin:",{"$f":"T_Projektvertrag","v":"2021-02-05"},null,null,"Vollständig:",{"$f":"AND(Q67:Q100)","v":false}]
[]
[null,null,{"$f":"IF(S_Weiblich,\"Verfasserin Name:\",\"Verfasser Name:\")","v":"Verfasser Name:"},{"$f":"S_Name","v":""},null,null,null,null,null,"Vorname:",{"$f":"S_Vorname","v":""},"Klasse:",{"$f":"S_Klasse","v":""},null,null,"Ausgefüllt:",{"$f":"AND(D67<>\"\",K67<>\"\",M67<>\"\")","v":false}]
[]
[null,null,"Adresse:",{"$f":"S_Adresse","v":""},null,null,null,null,null,"PLZ Ort:",{"$f":"S_Ort","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(D69<>\"\",K69<>\"\")","v":false}]
[]
[null,null,"Telefon:",{"$f":"S_Telefon","v":""},null,null,null,null,null,"Mailadresse:",{"$f":"S_Mail","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(D71<>\"\",K71<>\"\")","v":false}]
[]
[null,null,{"$f":"IF(B_Weiblich,\"Betreuerin Name:\",\"Betreuer Name:\")","v":"Betreuer Name:"},{"$f":"B_Name","v":""},null,null,null,null,null,"Vorname:",{"$f":"B_Vorname","v":""},"Kürzel:",{"$f":"B_Kuerzel","v":""},null,null,"Ausgefüllt:",{"$f":"AND(D73<>\"\",K73<>\"\",M73<>\"\")","v":false}]
[]
[null,null,"Adresse:",{"$f":"B_Adresse","v":""},null,null,null,null,null,"PLZ Ort:",{"$f":"B_Ort","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(D75<>\"\",K75<>\"\")","v":false}]
[]
[null,null,"Telefon:",{"$f":"B_Telefon","v":""},null,null,null,null,null,"Mailadresse:",{"$f":"B_Mail","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(D77<>\"\",K77<>\"\")","v":false}]
[]
[null,null,"Provisorische Fragestellung: (Was soll als Resultat herauskommen?)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"V_Fragestellung<>\"\"","v":false}]
[]
[null,null,"Zeitplan:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"V_Zeitplan<>\"\"","v":false}]
[]
[null,null,"Meilensteine: (Arbeitsschritte, Materialsuche, Disposition, abgemachte Kontrollen, Zwischenbeurteilungen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"V_Meilensteine<>\"\"","v":false}]
[]
[null,null,"Beurteilungskriterein: (Abmachungen der Fachschaft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"V_Beurteilungskriterien<>\"\"","v":false}]
[]
[null,null,"Abmachungen Zusammenarbeit: (regelmässige Information über den Stand der Arbeit etc.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"V_Zusammenarbeit<>\"\"","v":false}]
[]
[null,null,"Anmerkungen:"]
[]
[]
[null,null,"Ort, Datum:",null,null,null,null,null,null,{"$f":"IF(S_Weiblich,\"Die Verfasserin:\",\"Der Verfasser:\")","v":"Der Verfasser:"},{"$f":"CONCATENATE(S_Name,\" \",S_Vorname)","v":" "},null,null,null,null,"Ausgefüllt:",{"$f":"V_Datum1<>\"\"","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q65,1,0)","v":0}]
[]
[null,null,"Ort, Datum:",{"$f":"IF(V_Datum1=\"\",\"\",V_Datum1)","v":""},null,null,null,null,null,{"$f":"IF(B_Weiblich,\"Die Betreuerin:\",\"Der Betreuer:\")","v":"Der Betreuer:"},{"$f":"CONCATENATE(B_Name,\" \",B_Vorname)","v":" "},null,null,null,null,"Ausgefüllt:",{"$f":"V_Datum2<>\"\"","v":false}]
[]
[]
[null,null,"7 Zwischenbericht (durch Betreuer auzufüllen)",null,null,null,null,null,null,null,null,"Termin:",{"$f":"T_Zwischenbericht","v":"2021-04-30"},null,null,"Vollständig:",{"$f":"AND(Q105:Q139)","v":false}]
[]
[null,null,{"$f":"IF(S_Weiblich,\"Verfasserin Name:\",\"Verfasser Name:\")","v":"Verfasser Name:"},{"$f":"S_Name","v":""},null,null,null,null,null,"Vorname:",{"$f":"S_Vorname","v":""},"Klasse:",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(S_Klasse,5,6),3,4),2,3)","v":""},null,null,"Ausgefüllt:",{"$f":"AND(D105<>\"\",K105<>\"\",M105<>\"\")","v":false}]
[]
[]
[null,null,"Adresse:",{"$f":"S_Adresse","v":""},null,null,null,null,null,"PLZ Ort:",{"$f":"S_Ort","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(D108<>\"\",K108<>\"\")","v":false}]
[]
[null,null,"Telefon:",{"$f":"S_Telefon","v":""},null,null,null,null,null,"Mailadresse:",{"$f":"S_Mail","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(D110<>\"\",K110<>\"\")","v":false}]
[]
[null,null,{"$f":"IF(B_Weiblich,\"Betreuerin Name:\",\"Betreuer Name:\")","v":"Betreuer Name:"},{"$f":"B_Name","v":""},null,null,null,null,null,"Vorname:",{"$f":"B_Vorname","v":""},"Kürzel:",{"$f":"B_Kuerzel","v":""},null,null,"Ausgefüllt:",{"$f":"AND(D112<>\"\",K112<>\"\",M112<>\"\")","v":false}]
[]
[null,null,"Adresse:",{"$f":"B_Adresse","v":""},null,null,null,null,null,"PLZ Ort:",{"$f":"B_Ort","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(D114<>\"\",K114<>\"\")","v":false}]
[]
[null,null,"Telefon:",{"$f":"B_Telefon","v":""},null,null,null,null,null,"Mailadresse:",{"$f":"B_Mail","v":""},null,null,null,null,"Ausgefüllt:",{"$f":"AND(D116<>\"\",K116<>\"\")","v":false}]
[]
[null,null,"Titel (definitiver Titel, max. 140 Zeichen, wird im Zeugnis eingetragen)",null,null,null,null,null,null,null,null,"Länge:",{"$f":"LEN(N_Titel)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"N_Titel<>\"\"","v":false}]
[]
[null,null,"Bemerkungen zum Arbeitsprozess:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"N_Arbeitsprozess<>\"\"","v":false}]
[]
[null,null,"Zwischenbeurteilung der Arbeit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"N_Zwischenbeurteilung<>\"\"","v":false}]
[]
[null,null,"Anmerkungen:"]
[]
[]
[null,null,"Zeitplan gem. Disposition:",null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"N_Zeitplan<>\"\"","v":false}]
[]
[null,null,"Ausrichtung Weiterarbeit:",null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"N_Weiterarbeit<>\"\"","v":false}]
[]
[null,null,"Aktuelle Bewertung:",null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"N_Bewertung<>\"\"","v":false}]
[]
[null,null,"Ort, Datum:",null,null,null,null,null,null,{"$f":"IF(S_Weiblich,\"Die Verfasserin:\",\"Der Verfasser:\")","v":"Der Verfasser:"},{"$f":"CONCATENATE(S_Name,\" \",S_Vorname)","v":" "},null,null,null,null,"Ausgefüllt:",{"$f":"N_Datum1<>\"\"","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q103,1,0)","v":0}]
[]
[null,null,"Ort, Datum:",{"$f":"IF(N_Datum1=\"\",\"\",N_Datum1)","v":""},null,null,null,null,null,{"$f":"IF(B_Weiblich,\"Die Betreuerin:\",\"Der Betreuer:\")","v":"Der Betreuer:"},{"$f":"CONCATENATE(B_Name,\" \",B_Vorname)","v":" "},null,null,null,null,"Ausgefüllt:",{"$f":"N_Datum2<>\"\"","v":false}]
[]
[]
[null,null,"8 Beurteilung und Bewertung (durch Betreuer auszufüllen)",null,null,null,null,null,null,null,null,"Termin:",{"$f":"T_Bewertung","v":"2021-12-01"},null,null,"Vollständig:",{"$f":"AND(Q144:Q151)","v":false}]
[]
[null,null,"Bewertung:"]
[null,null,null,null,"Punkte","von",null,"Note","Gewicht:","Note"]
[null,null,"Produkt",{"$f":"IF(ISERROR(S_Richtung_Zeile),\"\",VLOOKUP(S_Richtung,A!B13:D19,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(ISERROR(R146),\"\",R146)","v":""},{"$f":"MAX(IF(OR(ISBLANK(E146),ISBLANK(F146)),0,ROUND(MIN(5*E146/F146+1,6),1)),H146)","v":0},null,null,null,null,null,{"$f":"I146*J146","v":{"$error":"#VALUE!"}},{"$f":"(OR(ISBLANK(E146),ISBLANK(F146))+ISBLANK(H146))=1","v":false},{"$f":"HLOOKUP(CONCATENATE(S_Typ_Abkuerzung,\"_Gew1\"),X_Gewichte,S_Richtung_Zeile,FALSE)","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"IF(ISERROR(S_Richtung_Zeile),\"\",VLOOKUP(S_Richtung,A!B13:D19,3,FALSE))","v":""},null,null,null,null,{"$f":"IF(ISERROR(R147),\"\",R147)","v":""},{"$f":"MAX(IF(OR(ISBLANK(E147),ISBLANK(F147)),0,ROUND(MIN(5*E147/F147+1,6),1)),H147)","v":0},null,null,null,null,null,{"$f":"I147*J147","v":{"$error":"#VALUE!"}},{"$f":"(OR(ISBLANK(E147),ISBLANK(F147))+ISBLANK(H147))=1","v":false},{"$f":"HLOOKUP(CONCATENATE(S_Typ_Abkuerzung,\"_Gew2\"),X_Gewichte,S_Richtung_Zeile,FALSE)","v":{"$error":"#REF!"}}]
[null,null,null,"Prozess:",null,null,null,null,{"$f":"IF(ISERROR(R148),\"\",R148)","v":""},{"$f":"MAX(IF(OR(ISBLANK(E148),ISBLANK(F148)),0,ROUND(MIN(5*E148/F148+1,6),1)),H148)","v":0},null,null,null,null,null,{"$f":"I148*J148","v":{"$error":"#VALUE!"}},{"$f":"(OR(ISBLANK(E148),ISBLANK(F148))+ISBLANK(H148))=1","v":false},{"$f":"HLOOKUP(CONCATENATE(S_Typ_Abkuerzung,\"_Gew3\"),X_Gewichte,S_Richtung_Zeile,FALSE)","v":{"$error":"#REF!"}}]
[null,null,"Präsentation",null,null,null,null,null,{"$f":"IF(ISERROR(R149),\"\",R149)","v":""},{"$f":"MAX(IF(OR(ISBLANK(E149),ISBLANK(F149)),0,ROUND(MIN(5*E149/F149+1,6),1)),H149)","v":0},null,null,null,null,{"$f":"IF(Q142,1,0)","v":0},{"$f":"I149*J149","v":{"$error":"#VALUE!"}},{"$f":"(OR(ISBLANK(E149),ISBLANK(F149))+ISBLANK(H149))=1","v":false},{"$f":"HLOOKUP(CONCATENATE(S_Typ_Abkuerzung,\"_Gew4\"),X_Gewichte,S_Richtung_Zeile,FALSE)","v":{"$error":"#REF!"}}]
[null,null,"Schlussnote",null,null,null,null,null,{"$f":"SUM(I146:I149)","v":0},{"$f":"IF(AND(Q146,Q147,Q148,Q149),IF(S_Typ=\"Selbständige Arbeit\",ROUND(P150,1),ROUND(2*P150,0)/2),\"\")","v":""},null,null,null,null,null,{"$f":"SUM(P146:P149)","v":{"$error":"#VALUE!"}},{"$f":"ISNUMBER(N_Note5)","v":false}]
[]
[]
[null,null,"9 Auszeichnung (durch Betreuer auszufüllen)",null,null,null,null,null,null,null,null,null,null,null,null,"Vollständig:",{"$f":"AND(Q155:Q169)","v":false}]
[]
[null,null,"Arbeit ist auszeichnungswürdig:",null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"A_Auszeichnungswuerdig<>\"\"","v":false}]
[]
[null,null,{"$f":"IF(A_Auszeichnungswuerdig=\"Ja\",\"Begründung für eine Auszeichnung:\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"NOT(AND(A_Auszeichnungswuerdig=\"ja\",A_AuszeichnungBegruendung=\"\"))","v":true}]
[]
[null,null,"Arbeit wurde schulextern eingereicht:",null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"A_Externeingereicht<>\"\"","v":false}]
[]
[null,null,{"$f":"IF(A_Externeingereicht=\"Ja\",\"Eingereicht bei:\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgefüllt:",{"$f":"NOT(AND(A_Externeingereicht=\"ja\",A_ExterneingereichtBei=\"\"))","v":true}]
[]
[null,null,"Ort, Datum:",null,null,null,null,null,null,{"$f":"IF(B_Weiblich,\"Die Betreuerin:\",\"Der Betreuer:\")","v":"Der Betreuer:"},{"$f":"CONCATENATE(B_Name,\" \",B_Vorname)","v":" "},null,null,null,null,"Ausgefüllt:",{"$f":"A_Datum1<>\"\"","v":false}]
[]
[]
[null,null,"Ort, Datum:",{"$f":"IF(A_Datum1=\"\",\"\",A_Datum1)","v":""},null,null,null,null,null,{"$f":"IF(K_Weiblich,\"Die Korreferentin:\",\"Der Korreferent:\")","v":"Der Korreferent:"},{"$f":"CONCATENATE(K_Name,\" \",K_Vorname)","v":" "},null,null,null,{"$f":"IF(Q153,1,0)","v":0},"Ausgefüllt:",{"$f":"A_Datum2<>\"\"","v":false}]
[]
[]
[null,null,"10 Anhang Termine"]
[]
[null,null,"Orientierung",null,"Woche vom / am",null,null,null,null,{"$f":"A!D58","v":"2020-09-14"}]
[null,null,"Marktplatz",null,"Woche vom / am",null,null,null,null,{"$f":"A!D59","v":"00:00:00"}]
[null,null,"Präsentation Bes.",null,"Woche vom / am",null,null,null,null,{"$f":"A!D60","v":"2020-10-21"}]
[null,null,"Bibliothek Bes.",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D61","v":"00:00:00"}]
[null,null,"Themenabgabe",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D62","v":"2020-12-18"}]
[null,null,"Zuweisung Bet/Kor",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D63","v":"2021-01-08"}]
[null,null,"Bewilligung SL",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D64","v":"2021-01-15"}]
[null,null,"Erarbeitung",null,"ab",null,null,null,null,{"$f":"A!D65","v":"2021-01-18"}]
[null,null,"Projektvertrag",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D66","v":"2021-02-05"}]
[null,null,"Einführung wiss. Arb.",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D67","v":"00:00:00"}]
[null,null,"Computerkurs",null,"Woche vom",null,null,null,null,{"$f":"A!D68","v":"2021-02-23"}]
[null,null,"Zeitgefäss",null,"Woche vom",null,null,null,null,{"$f":"A!D69","v":"2021-07-05"}]
[null,null,"Zwischenbericht",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D70","v":"2021-04-30"}]
[null,null,"Abgabe",null,"am",null,null,null,null,{"$f":"A!D71","v":"2021-08-30"}]
[null,null,"Korrektur",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D72","v":"2021-10-22"}]
[null,null,"Nachbesserung",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D73","v":"00:00:00"}]
[null,null,"Präsentation",null,"Woche vom / am",null,null,null,null,{"$f":"A!D74","v":"2021-10-25"}]
[null,null,"Bewertung",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D75","v":"2021-12-01"}]
[null,null,"Gutachten",null,"am",null,null,null,null,{"$f":"A!D76","v":"2021-12-03"}]
[null,null,"Evaluation",null,"Woche vom / am",null,null,null,null,{"$f":"A!D77","v":"00:00:00"}]
[null,null,"Abrechnung",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D78","v":"2021-06-18"}]
[]
[null,null,"Änderungen vorbehalten"]

{"sheet":"Zeugnis","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[12,1,12,7]]}
[]
[]
[null,{"$f":"S_Typ","v":0}]
[null,{"$f":"CONCATENATE(\"der \",VLOOKUP(S_Typ_Abkuerzung,A!C3:D6,2,FALSE),\" Sursee\")","v":"der Kantonsschule Sursee"}]
[]
[null,{"$f":"CONCATENATE(\"Die \",VLOOKUP(S_Typ_Abkuerzung,A!C3:D6,2,FALSE),\" Sursee bestätigt:\")","v":"Die Kantonsschule Sursee bestätigt:"}]
[]
[null,{"$f":"CONCATENATE(S_Name,\" \",S_Vorname)","v":" "}]
[null,{"$f":"CONCATENATE(\"Klasse \",S_Klasse2)","v":"Klasse "}]
[]
[null,{"$f":"CONCATENATE(\"hat im Fach \",S_Fach,\" zum Thema\")","v":"hat im Fach  zum Thema"}]
[]
[null,{"$f":"N_Titel","v":0}]
[]
[null,{"$f":"CONCATENATE(\"die \",S_Typ,\" verfasst und folgende Bewertung erhalten:\")","v":"die  verfasst und folgende Bewertung erhalten:"}]
[]
[null,"Bewertung",null,null,"Gewicht",null,"Note"]
[]
[null,"Produkt",null,{"$f":"N_Text1","v":""},{"$f":"N_Gewicht1","v":""},null,{"$f":"N_Note1","v":0}]
[null,null,null,{"$f":"N_Text2","v":""},{"$f":"N_Gewicht2","v":""},null,{"$f":"N_Note2","v":0}]
[null,null,null,{"$f":"N_Text3","v":"Prozess:"},{"$f":"N_Gewicht3","v":""},null,{"$f":"N_Note3","v":0}]
[null,"Präsentation",null,null,{"$f":"N_Gewicht4","v":""},null,{"$f":"N_Note4","v":0}]
[null,"Schlussnote",null,null,null,null,{"$f":"N_Note5","v":""}]
[]
[null,{"$f":"A_Datum1","v":"00:00:00"}]
[]
[null,{"$f":"IF(B_Weiblich,\"Referentin\",\"Referent\")","v":"Referent"},null,null,{"$f":"IF(K_Weiblich,\"Korreferentin\",\"Korreferent\")","v":"Korreferent"}]
[]
[]
[]
[null,{"$f":"CONCATENATE(B_Name,\" \",B_Vorname)","v":" "},null,null,{"$f":"CONCATENATE(K_Name,\" \",K_Vorname)","v":" "}]

{"sheet":"S","index":2,"n_rows":73,"n_cols":15,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PARTNER","AGS_PREFIX","PAR_NAME","PAR_VORNAME","Klasse","PAR_ADRESSE","PAR_PLZ","PAR_ORT","PAR_GEBURTSDATUM","Tel_P","Natel","Email","Gesch"]
[{"$f":"CONCATENATE(E31,\" \",F31,\" \",G31)","v":"Aregger Sarina F2a"},1,410271,"F2","Aregger","Sarina","F2a","Im Ostergau 13a","6130","Willisau","2004-06-28","041-970 03 70","079-358 06 69","Sarina_Aregger1@sluz.ch","w"]
[{"$f":"CONCATENATE(E32,\" \",F32,\" \",G32)","v":"Arnold Eliane F2b"},{"$f":"B31+1","v":2},410290,"F2","Arnold","Eliane","F2b","Bahnhöfliweg 16","6234","Triengen","2003-12-17","041-933 28 12","079-534 48 31","Eliane_Arnold2@sluz.ch","w"]
[{"$f":"CONCATENATE(E33,\" \",F33,\" \",G33)","v":"Bättig Aline F2a"},{"$f":"B32+1","v":3},410541,"F2","Bättig","Aline","F2a","Obergeissburg 10","6130","Willisau","2003-07-18","041-970 00 86","079-156 21 15","Aline_Baettig@sluz.ch","w"]
["Bättig Nina F2b",4,410279,"F2","Bättig","Nina","F2b","Bachweg 16","6207","Nottwil","2004-06-27","041-780 81 75","077-457 90 32","Nina_Baettig@sluz.ch","w"]
["Bernet Rahel F2a",5,410543,"F2","Bernet","Rahel","F2a","Schwertschwenden 3","6153","Ufhusen","2003-07-01","041-988 29 88","078-720 98 90","Rahel_Bernet@sluz.ch","w"]
["Class Hannah F2b",6,409704,"F2","Class","Hannah","F2b","Mariazellweg 4c","6210","Sursee","2003-11-09","077-521 46 09",null,"Hannah_Class@sluz.ch","w"]
["Durdek Pascal F2a",7,408641,"F2","Durdek","Pascal","F2a","Jurablick 5","6260","Reiden","2002-07-07","041-920 16 69","079-902 03 02","Pascal_Durdek@sluz.ch","m"]
["Felix Simona F2b",8,410292,"F2","Felix","Simona","F2b","Chrüzmatt 5","6215","Beromünster","2003-12-30","041-930 10 04","079-481 94 12","Simona_Felix@sluz.ch","w"]
["Frank Sheryl F2a",9,410548,"F2","Frank","Sheryl","F2a","Am Bächli 11","6218","Ettiswil","2004-01-18","041-980 58 74","079-624 47 51","Sheryl_Frank@sluz.ch","w"]
[{"$f":"CONCATENATE(E40,\" \",F40,\" \",G40)","v":"Frei Isabella F2b"},10,410127,"F2","Frei","Isabella","F2b","Büntmatt 18","6242","Wauwil","2002-12-11","041-980 26 08","077-918 01 48","Isabella_Frei1@sluz.ch","w"]
["Gaberthüel Zinnia F2b",11,410286,"F2","Gaberthüel","Zinnia","F2b","Bühlstrasse 25","6207","Nottwil","2002-10-10","041-937 13 83","079-463 17 97","Zinnia_Gaberthueel@sluz.ch","w"]
["Gerber Sven F2b",12,410550,"F2","Gerber","Sven","F2b","Rainacher 43","6243","Egolzwil","2002-08-05","079-912 16 36",null,"Sven_Gerber@sluz.ch","m"]
["Grüter Kim F2b",13,410302,"F2","Grüter","Kim","F2b","Badrain 5","6210","Sursee","2003-01-25","079-542 73 60","076-803 78 75","Kim_Grueter@sluz.ch","w"]
["Grüter Sarah F2a",14,410554,"F2","Grüter","Sarah","F2a","Hubelstrasse 17","6204","Sempach","2003-06-17","041-460 27 92","077-411 95 88","Sarah_Grueter1@sluz.ch","w"]
["Haas Mirjam F2a",15,409128,"F2","Haas","Mirjam","F2a","Altkidli","6217","Kottwil","2003-11-12","041-920 11 52",null,"Mirjam_Haas@sluz.ch","w"]
["Halas Maryam F2b",16,410556,"F2","Halas","Maryam","F2b","Luzernerstrasse 23a","4806","Wikon","2003-12-26","079-747 45 31","079-765 58 52","Maryam_Halas@sluz.ch","w"]
["Haxhosaj Rigona F2b",17,410628,"F2","Haxhosaj","Rigona","F2b","St. Karlistrasse 2a","6004","Luzern","2002-11-10","078-801 55 58","078-868 00 30","Rigona_Haxhosaj@sluz.ch","w"]
["Helfenstein Sarina F2a",18,410579,"F2","Helfenstein","Sarina","F2a","Hinterdorf 3","6217","Kottwil","2003-06-25","041-980 09 31","079-866 84 29","Sarina_Helfenstein@sluz.ch","w"]
["Heller Lea F2a",19,410275,"F2","Heller","Lea","F2a","Müligass 9","6130","Willisau","2004-01-02","041-970 06 30","079-357 86 68","Lea_Heller1@sluz.ch","w"]
["Heller Marina F2a",20,410558,"F2","Heller","Marina","F2a","Hinterdorf 1","6217","Kottwil","2003-06-05","041-980 69 32","079-965 86 55","Marina_Heller@sluz.ch","w"]
["Henriques Torcato Ana Filipa F2a",21,410281,"F2","Henriques Torcato","Ana Filipa","F2a","Badmatt 2","6260","Reiden","2003-05-19","076-547 91 00",null,"AnaFilipa_HenriquesTorcato@sluz.ch","w"]
["Hüsler Zoe F2b",22,410288,"F2","Hüsler","Zoe","F2b","Chäsibachweg 1","6025","Neudorf","2004-11-01","041-930 04 23","077-458 96 32","Zoe_Huesler@sluz.ch","w"]
["Knüsel Lea F2b",23,410298,"F2","Knüsel","Lea","F2b","Amlehnstrasse 6","6210","Sursee","2004-06-27","041-920 36 20","079-423 79 27","Lea_Knuesel@sluz.ch","w"]
["Krüger Jérôme F2a",24,410636,"F2","Krüger","Jérôme","F2a","Walke B","6260","Reiden","2003-09-09","079-918 88 05","076-540 09 90","Jerome_Krueger@sluz.ch","m"]
["Muff Ana-Luisa F2b",25,410560,"F2","Muff","Ana-Luisa","F2b","Holzacherstrasse 17","6210","Sursee","2004-01-22","041-921 02 20","079-795 34 96","AnaLuisa_Muff@sluz.ch","w"]
["Plavsic Dajana F2a",26,410563,"F2","Plavsic","Dajana","F2a","Haldenstrasse 21","6130","Willisau","2004-03-08","041-490 02 75","079-299 54 86","Dajana_Plavsic@sluz.ch","w"]
["Portmann Livia F2a",27,410277,"F2","Portmann","Livia","F2a","Oberdorfrain 1b","6130","Willisau","2004-08-31","041-970 07 72","079-357 91 00","Livia_Portmann2@sluz.ch","w"]
["Purtschert Mara F2a",28,410565,"F2","Purtschert","Mara","F2a","Dorfstrasse 43","6263","Richenthal","2004-09-28","062-758 23 14","076-761 44 30","Mara_Purtschert@sluz.ch","w"]
["Rudaj Vlera F2a",29,410567,"F2","Rudaj","Vlera","F2a","Heugärtenhalde 2","6232","Geuensee","2003-03-05","041-921 02 28","079-470 04 85","Vlera_Rudaj@sluz.ch","w"]
["Schumann Cloé F2b",30,410569,"F2","Schumann","Cloé","F2b","Schnäggebergstrasse 3","6235","Winikon","2003-11-15","041-933 01 84","079-714 05 35","Cloe_Schumann@sluz.ch","w"]
["Senn Doris F2b",31,411034,"F2","Senn","Doris","F2b","Brunnenhof 2","6242","Wauwil","2002-12-27","079-537 20 49",null,"Doris_Senn@sluz.ch","w"]
["Sivakumar Arjuna F2b",32,410457,"F2","Sivakumar","Arjuna","F2b","Rosenweg 4","6210","Sursee","2001-10-01","076-546 42 06",null,"Arjuna_Sivakumar@sluz.ch","m"]
["Steinmann Noah F2a",33,410284,"F2","Steinmann","Noah","F2a","Dorfmatt 17","6244","Nebikon","2003-06-08","079-402 84 73",null,"Noah_Steinmann@sluz.ch","m"]
["Suter Fabian F2b",34,410296,"F2","Suter","Fabian","F2b","Weierfeldstrasse 18","6233","Büron","2004-02-25","041-933 37 67","079-343 28 29","Fabian_Suter2@sluz.ch","m"]
["Tischhauser Joana F2b",35,410300,"F2","Tischhauser","Joana","F2b","Im Wiberg 2","6212","St. Erhard","2002-12-27","078-928 32 18","079-933 11 43","Joana_Tischhauser@sluz.ch","w"]
["Tola Daulina F2a",36,410571,"F2","Tola","Daulina","F2a","Weihermatte 1","6204","Sempach","2004-01-26","041-460 31 34","076-322 26 01","Daulina_Tola@sluz.ch","w"]
["Vogel Mara F2b",37,410294,"F2","Vogel","Mara","F2b","Eybachweg 4","6207","Nottwil","2003-10-29","041-937 20 80",null,"Mara_Vogel@sluz.ch","w"]
["Waller Jasmin F2a",38,410283,"F2","Waller","Jasmin","F2a","Reidmattstrasse 15","6260","Reiden","2004-06-22","077-465 15 70",null,"Jasmin_Waller@sluz.ch","w"]
["Wermelinger Enja F2a",39,409012,"F2","Wermelinger","Enja","F2a","Sonnmatt 10","6213","Knutwil","2004-08-27","041-511 21 99",null,"Enja_Wermelinger@sluz.ch","w"]
["Wisler Ramon F2a",40,410273,"F2","Wisler","Ramon","F2a","Grüneck","6130","Willisau","2003-12-26","041-970 47 17","079-831 44 55","Ramon_Wisler@sluz.ch","m"]
["Wüest Levi F2a",41,410574,"F2","Wüest","Levi","F2a","Geissburghalde 11","6130","Willisau","2004-03-31","041-971 03 20","079-298 77 49","Levi_Wueest@sluz.ch","m"]
["Ziegler Céline F2a",42,409000,"F2","Ziegler","Céline","F2a","Gewerbestrasse 16","6243","Egolzwil","2004-04-02","041-980 14 49","079-782 64 53","Celine_Ziegler@sluz.ch","w"]
["Zihler Selina F2b",43,410578,"F2","Zihler","Selina","F2b","Obstgartenstrasse 23","6210","Sursee","2003-11-01","079-414 49 28",null,"Selina_Zihler@sluz.ch","w"]

{"sheet":"L","index":3,"n_rows":154,"n_cols":17,"rows_kept":154,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"partner","par_name","par_vorname","mapa_abkurzung","par_adresse","par_plz","par_ort","anrede","par_beruf","par_geburtsdatum","Tel_P","Natel","Email","Gesch"]
[{"$f":"CONCATENATE(D31,\" \",E31)","v":"Aerne Lucas"},1,410654,"Aerne","Lucas","aer","Eigenmatt 4","6260","Reiden","Hr",null,"1996-01-15","077-412 27 73",null,"lucas.aerne@edulu.ch","m","Aerne Lucas"]
[{"$f":"CONCATENATE(D32,\" \",E32)","v":"Amico Flavia"},{"$f":"B31+1","v":2},410598,"Amico","Flavia","ami","Unter-Geissenstein 8","6005","Luzern","Fr","MSc Education","1987-11-14","076-530 06 63",null,"flavia.amico@edulu.ch","w","Amico Flavia"]
["Arnet Matthias",{"$f":"B32+1","v":3},403661,"Arnet","Matthias","arn","Erlenstr. 29","6020","Emmenbrücke","Hr","lic. phil. I","1966-10-03","041-280 33 52","077-429 50 67","matthias.arnet@edulu.ch","m","Arnet Matthias"]
["Balmer Evelyne",4,173,"Balmer","Evelyne","bae","Rankhof 8","6208","Oberkirch LU","Fr","MSc ETH","1973-12-16","041-920 27 85","079-583 57 38","evelyne.balmer@edulu.ch","w","Balmer Evelyne"]
["Baschung Franziska",5,405656,"Baschung","Franziska","bas","Fläckepark 1","6023","Rothenburg","Fr","dipl.Turn- u. Sportlehrerin II","1978-10-09","041-544 16 88","078-882 44 62","franziska.baschung@edulu.ch","w","Baschung Franziska"]
["Baumgartner Mirjam",6,193,"Baumgartner","Mirjam","bau","Chäppelimatte 6","6262","Langnau b. Reiden","Fr","Hauswirtschaftslehrerin","1959-10-08","062-758 21 71","079-383 69 74","mirjam.baumgartner@edulu.ch","w","Baumgartner Mirjam"]
["Bechtold Toni Amadeus",7,408482,"Bechtold","Toni Amadeus","bec","Elfenaustrasse 36","6005","Luzern","Hr","Lehrdiplom Klarinette, Saxofon","1986-04-16","077-436 99 02",null,null,"m","Bechtold Toni Amadeus"]
["Beltrani Marco",8,409273,"Beltrani","Marco","bel","Nonnenweg 39","4055","Basel","Hr","MA Musikpädagogik","1988-03-12","079-543 81 60",null,"marco.beltrani@edulu.ch","m","Beltrani Marco"]
["Berger Hutchings Monika",9,404791,"Berger Hutchings","Monika","bem","Holzacherstr. 12","6210","Sursee","Fr","lic. phil. I","1960-07-06","041-921 42 32","078-919 35 85","monika.berger@edulu.ch","w","Berger Hutchings Monika"]
["Biland Susanna",10,404792,"Biland","Susanna","bil","Rainacher 21","6243","Egolzwil","Fr","lic. phil. I","1974-04-09","041-980 01 90","079-616 71 20","susanna.biland@edulu.ch","w","Biland Susanna"]
["Blättler Benno",11,140,"Blättler","Benno","bla","Rüti 4","6026","Rain","Hr","dipl. Turnlehrer ETH","1969-06-28","041-448 35 86","079-465 42 01","benno.blaettler@edulu.ch","m","Blättler Benno"]
["Blum Michael",12,405194,"Blum","Michael","blu","Rebgasse 16","4432","Lampenberg","Hr","lic. phil. I","1962-08-25","061-951 20 17","076-375 58 21","michael.blum1@edulu.ch","m","Blum Michael"]
["Bregnard Thierry",13,187,"Bregnard","Thierry","brg","Dornirain 1","6047","Kastanienbaum","Hr","Dr. sc. nat. ETH","1964-12-26","041-361 01 72","076-530 01 72","thierry.bregnard@edulu.ch","m","Bregnard Thierry"]
["Brentini Fabrizio",14,132,"Brentini","Fabrizio","bre","Dreilindenstr. 75d","6006","Luzern","Hr","Dr. phil. I, lic. theol.","1957-03-13","041-422 09 90","078-805 71 71","fabrizio.brentini@edulu.ch","m","Brentini Fabrizio"]
["Broder Barbara",15,410586,"Broder","Barbara","bro","Schauensee 11","6204","Sempach","Fr","dipl. Zeichen- u. Werklehrerin","1982-10-11","078-610 65 63",null,"barbara.broder@edulu.ch","w","Broder Barbara"]
["Bründler Stadler Ursula",16,85,"Bründler Stadler","Ursula","brn","Kaspar Koppstr. 79","6030","Ebikon","Fr","lic. phil. I","1961-10-21","041-422 05 20","078-707 05 21","ursula.bruendler@edulu.ch","w","Bründler Stadler Ursula"]
["Büchel Adrian",17,191,"Büchel","Adrian","bua","Rigiweg 2","6033","Buchrain","Hr","lic. phil. I","1968-03-09","041-420 07 91","079-429 99 71","adrian.buechel@edulu.ch","m","Büchel Adrian"]
["Bucher Stefan",18,69,"Bucher","Stefan","bst","Waldstr. 5/21","6015","Luzern","Hr","Lehrdiplom Klavier","1959-08-03","041-260 64 32","077-449 31 21",null,"m","Bucher Stefan"]
["Budmiger Samuel",19,407214,"Budmiger","Samuel","bud","Surengasse 26","6210","Sursee","Hr","M Sc Geschichte und Deutsch","1984-02-22","076-417 87 58",null,"samuel.budmiger@edulu.ch","m","Budmiger Samuel"]
["Burkard Nicole",20,405652,"Burkard","Nicole","bur","Mayenfelserstrasse 3","4133","Pratteln","Fr","lic. phil. I","1974-11-03","061-321 22 08","076-459 41 55","nicole.burkard@edulu.ch","w","Burkard Nicole"]
["Büttner Caspar",21,411009,"Büttner","Caspar","but","Wilemattstrasse 17","6210","Sursee","Hr","dipl. natw. ETH","1976-09-18","079-533 99 33",null,"caspar.buettner@edulu.ch","m","Büttner Caspar"]
["Callmar Roland",22,403675,"Callmar","Roland","cal","Hohlgasse 14","6233","Büron","Hr","Lehrdiplom Trompete","1963-07-21","041-934 00 25","079-340 64 75","roland.callmar@edulu.ch","m","Callmar Roland"]
["Casparis Claudine",23,407216,"Casparis","Claudine","cas","Neuhusstrasse 4","6045","Meggen","Fr","dipl.Turn- u. Sportlehrerin II","1980-02-02","041-410 06 40","078-775 07 33","claudine.casparis@edulu.ch","w","Casparis Claudine"]
["Chiantese Stefano",24,406058,"Chiantese","Stefano","chi","Birkenstrasse 3","5742","Kölliken","Hr","Dr. rer. nat., dipl. phys.","1969-11-22","062-822 54 01","077-438 72 59","stefano.chiantese@edulu.ch","m","Chiantese Stefano"]
["Clemens Thomas",25,405653,"Clemens","Thomas","cle","Leonhardsgraben 53/55","4051","Basel","Hr","lic. phil.","1970-08-02","076-394 55 37",null,"thomas.clemens@edulu.ch","m","Clemens Thomas"]
["Conrardy Richard",26,410587,"Conrardy","Richard","con","Moschtiweg 2","6212","St. Erhard","Hr","M Sc Mathematik","1988-05-18","076-472 71 58",null,"richard.conrardy@edulu.ch","m","Conrardy Richard"]
["D'Incau Renato",27,410132,"D'Incau","Renato","din","Rebgasse 68","4058","Basel","Hr","MSc PS","1982-05-29","076-548 15 61",null,"renato.dincau@edulu.ch","m","D'Incau Renato"]
["Deeg Stefan",28,172,"Deeg","Stefan","dee","Muracher 7","6235","Winikon","Hr","lic. phil. I","1962-05-01","041-933 01 42","079-872 74 15","stefan.deeg@edulu.ch","m","Deeg Stefan"]
["Disler Severin",29,11,"Disler","Severin","dis","Schützenmatte 2c","6214","Schenkon","Hr","lic. phil. nat.","1961-03-19","041-921 62 70","076-431 02 38","severin.disler@edulu.ch","m","Disler Severin"]
["Dos Santos Laura",30,409692,"Dos Santos","Laura","dos","Murerhüsli 6B","6214","Schenkon","Fr","MA Spanisch","1987-03-06","078-716 42 29",null,"laura.dossantos@edulu.ch","w","Dos Santos Laura"]
["Egli Peter",31,112,"Egli","Peter","egl","Bifangstrasse 7","6210","Sursee","Hr","","1962-02-02","041-530 39 32","079-398 80 44","peter.egli@edulu.ch","m","Egli Peter"]
["Erni Xenia",32,409275,"Erni","Xenia","erx","Mariazellweg 4a","6210","Sursee","Fr","lic. phil. I","1981-12-13","041-921 13 48","079-964 74 42","xenia.erni@edulu.ch","w","Erni Xenia"]
["Fanger Felicitas",33,408042,"Fanger","Felicitas","fan","Centralstrasse 37","6210","Sursee","Fr","Dr. phil. I","1985-10-01","079-720 40 78",null,"felicitas.fanger@edulu.ch","w","Fanger Felicitas"]
["Fischer Raffael",34,409276,"Fischer","Raffael","fir","Göldlinstrasse 12b","6210","Sursee","Hr","LDM Geschichte","1980-02-20","076-508 72 43",null,"raffael.fischer@edulu.ch","m","Fischer Raffael"]
["Fischlin Moritz",35,405650,"Fischlin","Moritz","fis","Augustin Keller-Strasse 3","5000","Aarau","Hr","lic. phil. I","1968-01-16","062-822 43 92","079-77 66 170","moritz.fischlin@edulu.ch","m","Fischlin Moritz"]
["Frank Benno",36,16,"Frank","Benno","fra","Unterhofstr.14","6208","Oberkirch LU","Hr","dipl. Turnlehrer","1955-10-11","041-921 99 91","079-785 23 78","benno.frank@edulu.ch","m","Frank Benno"]
["Freihofer Christoph",37,401904,"Freihofer","Christoph","fre","Buchwald 3","6143","Ohmstal","Hr","Rektor","1963-04-14","041-980 06 44","079-477 77 42","christoph.freihofer@edulu.ch","m","Freihofer Christoph"]
["Fuchs Markus",38,405682,"Fuchs","Markus","fum","Altenbergstrasse 46","3013","Bern","Hr","lic. phil. I","1979-03-22","031-535 53 75","076-529 36 20","markus.fuchs@edulu.ch","m","Fuchs Markus"]
["Galliker Judith",39,410656,"Galliker","Judith","gal","Christoph-Schnyder-Strasse 52","6210","Sursee","Fr","MA Hochschule Luzern/FHZ","1990-06-17","079-369 32 72",null,"judith.galliker@edulu.ch","w","Galliker Judith"]
["Geiser Urs",40,19,"Geiser","Urs","geu","Eybachallee 1","6207","Nottwil","Hr","dipl. Gymnasiallehrer","1957-04-20","041-921 52 63","079-232 17 65","urs.geiser@edulu.ch","m","Geiser Urs"]
["Gerhardt Ulrike",41,405654,"Gerhardt","Ulrike","ger","Seemattstr. 30","6330","Cham","Fr","dipl. Handelslehrerin","1963-09-03","041-780 77 11","076-589 98 56","ulrike.gerhardt@edulu.ch","w","Gerhardt Ulrike"]
["Ghezal Abdelhakim",42,120,"Ghezal","Abdelhakim","ghe","Oberdorfstrasse 22","6207","Nottwil","Hr","Dr. phil. II, dipl. math.","1957-12-17","041-495 05 67","076-58 01 957","hakim.ghezal@edulu.ch","m","Ghezal Abdelhakim"]
["Glanzmann Ruth",43,150,"Glanzmann","Ruth","gla","Schellenrainstr. 3e","6210","Sursee","Fr","Hauswirtschaftslehrerin","1967-01-28","041-933 09 62","079-715 59 02","ruth.glanzmann@edulu.ch","w","Glanzmann Ruth"]
["Graber Martin",44,407218,"Graber","Martin","grm","Ulmenstrasse 4","6003","Luzern","Hr","MSc ETH","1982-01-09","078-803 00 15",null,"martin.graber@edulu.ch","m","Graber Martin"]
["Grabher Karin",45,403276,"Grabher","Karin","grb","Waldegg 3","6210","Sursee","Fr","lic. phil. I","1960-03-18","041-921 13 24","079-733 55 17","karin.grabher@edulu.ch","w","Grabher Karin"]
["Gräff Tobias",46,155,"Gräff","Tobias","gra","Hennebüelweg 2","4632","Trimbach","Hr","dipl. math. ETH","1967-06-10","062-296 26 08","077-411 05 69","tobias.graeff@edulu.ch","m","Gräff Tobias"]
["Grüter David",47,410588,"Grüter","David","gru","Weinberglistrasse 79","6003","Luzern","Hr","lic. phil.","1979-07-07","079-838 43 36",null,"david.grueter@edulu.ch","m","Grüter David"]
["Gühr Marcel",48,22,"Gühr","Marcel","guh","Hinterfeldstrasse 11","6232","Geuensee","Hr","dipl. Math. ETH","1957-11-29","041-240 09 24","078-404 71 98","marcel.guehr@edulu.ch","m","Gühr Marcel"]
["Gut Andreas",49,409685,"Gut","Andreas","gut","Landhausweg 6","3007","Bern","Hr","dipl. Musiklehrer II","1988-08-27","077-421 37 52",null,"andreas.gut@edulu.ch","m","Gut Andreas"]
["Hammer Susanne",50,402823,"Hammer","Susanne","ham","Carl-Beck-Strasse 1d","6210","Sursee","Fr","lic. phil. I","1963-09-07","041-921 09 43","077-423 06 46","susanne.hammer@edulu.ch","w","Hammer Susanne"]
["Hansraj Shabir",51,405658,"Hansraj","Shabir","han","Risirainstrasse 8","8903","Birmensdorf ZH","Hr","dipl. nat. ETH","1965-02-18","043-344 01 73","079-483 79 27","shabir.hansraj@edulu.ch","m","Hansraj Shabir"]
["Häusler Beat",52,122,"Häusler","Beat","hau","Allmendstr. 25","4632","Trimbach","Hr","lic. phil. hist.","1957-05-07","062-293 14 18","079-460 17 10","beat.haeusler@edulu.ch","m","Häusler Beat"]
["Hess Sue",53,72,"Hess","Sue","hes","Bahnhofstrasse 5a","5734","Reinach AG","Fr","B. Mus., Hon. Perf., A. Mus.A.","1963-09-22","079-915 55 51",null,null,"w","Hess Sue"]
["Hunn Jasmin",54,407247,"Hunn","Jasmin","huj","Alte Bernstrasse 27","5603","Staufen","Fr","M of Art Education","1985-06-26","079-288 83 79",null,"jasmin.hunn@edulu.ch","w","Hunn Jasmin"]
["Imstepf Titiana",55,411013,"Imstepf","Titiana","ims","Gutenbergstrasse 35","3011","Bern","Fr","LDM DE und GS","1989-03-23","078-686 42 33",null,"titiana.imstepf@edulu.ch","w","Imstepf Titiana"]
["Isenegger Christoph",56,402279,"Isenegger","Christoph","ise","Dorfstrasse 32b","6005","Luzern","Hr","MSc ETH","1969-04-05","041-310 76 03","078-846 54 40","christoph.isenegger@edulu.ch","m","Isenegger Christoph"]
["Jerfino Luca",57,411014,"Jerfino","Luca","jer","Abendweg 3","6210","Sursee","Hr","lic. phil. I","1976-09-24","076-462 59 33",null,"luca.jerfino@edulu.ch","m","Jerfino Luca"]
["Kaczmarczyk Gian",58,410652,"Kaczmarczyk","Gian","kac","Kanonengasse 9","8004","Zürich","Hr",null,"1991-10-21","079-478 37 99",null,"gian.kaczmarczyk@edulu.ch","m","Kaczmarczyk Gian"]
["Käppeli Wolfgang",59,405657,"Käppeli","Wolfgang","kap","Schläflirain 3","3013","Bern","Hr","dipl. biol. ","1976-10-30","078-629 04 76",null,"wolfgang.kaeppeli@edulu.ch","m","Käppeli Wolfgang"]
["Kaufmann Anna",60,410600,"Kaufmann","Anna","kau","Gibraltarstrasse 19","6003","Luzern","Fr","MA Englisch","1992-02-07","079-790 51 43",null,"anna.kaufmann@edulu.ch","w","Kaufmann Anna"]
["Kneubühler Markus",61,108,"Kneubühler","Markus","kne","Schaalgass 28","6130","Willisau","Hr","lic. phil. hist.","1965-11-22","079-350 99 09",null,"markus.kneubuehler@edulu.ch","m","Kneubühler Markus"]
["Korthus Rahel",62,410592,"Korthus","Rahel","kor","Feldhöflistr. 13","6208","Oberkirch LU","Fr","MA","1994-12-13","079-557 33 93",null,"rahel.korthus@edulu.ch","w","Korthus Rahel"]
["Kreder Daniel",63,98,"Kreder","Daniel","kre","Breitmattstrasse 4","3380","Wangen an der Aare","Hr","Lehrdiplom Klavier","1967-02-17","032-633 30 66","079-313 41 06",null,"m","Kreder Daniel"]
["Kronenberg Manuela",64,405655,"Kronenberg","Manuela","kro","Kantonsstrasse 11","6212","St. Erhard","Fr","dipl.Turn- u. Sportlehrerin II","1977-11-11","078-789 04 89",null,"manuela.kronenberg@edulu.ch","w","Kronenberg Manuela"]
["Kurmann René",65,156,"Kurmann","René","kur","Büelmatt 7","6204","Sempach","Hr","lic. phil. hist.","1965-04-18","079-480 90 31",null,"rene.kurmann@edulu.ch","m","Kurmann René"]
[{"$f":"CONCATENATE(D96,\" \",E96)","v":"Küttel Janine"},66,408397,"Küttel","Janine","kut","Abeschweg 4","6210","Sursee","Fr","MSc of Law","1988-09-01","079-265 11 42",null,"janine.kuettel@edulu.ch","w","Küttel Janine"]
["Lienert David",67,401013,"Lienert","David","lie","Burghöhe 32","6208","Oberkirch LU","Hr","","1966-09-30","041-920 46 80","079-798 98 58","david.lienert@edulu.ch","m","Lienert David"]
["Louis Gabriele",68,406064,"Louis","Gabriele","lou","Schmittegass 47","8957","Spreitenbach","Fr","M. A.","1957-06-26","056-410 12 12","079-489 77 77","gabriela.louis@edulu.ch","w","Louis Gabriele"]
["Lusser Niklaus",69,405195,"Lusser","Niklaus","lun","Bachweg 14","5619","Uezwil","Hr","dipl. phil. II","1978-06-28","056-610 66 28","079-401 85 24","niklaus.lusser@edulu.ch","m","Lusser Niklaus"]
["Lussi Matthias",70,405651,"Lussi","Matthias","lum","Lützelmattweg 4","6006","Luzern","Hr","dipl. Umwelt-Natw. ETH","1976-09-13","079-251 11 28","079-251 11 28","matthias.lussi@edulu.ch","m","Lussi Matthias"]
["Lussi Renata",71,190,"Lussi","Renata","lus","Kapuzinerweg 47","6006","Luzern","Fr","dipl. Zeichen- u. Werklehrerin","1966-07-26","041-420 10 56","079-792 86 43","renata.lussi@edulu.ch","w","Lussi Renata"]
["Mauderli Donatina",72,402842,"Mauderli","Donatina","mau","Rehgasse 13","4713","Matzendorf","Fr","lic. phil. hist.","1966-04-22","061-903 20 42","076-464 23 42","donatina.mauderli@edulu.ch","w","Mauderli Donatina"]
["Mez Konstanze",73,177,"Mez","Konstanze","mez","Dreilindenstr. 75d","6006","Luzern","Fr","Dr. phil. II","1965-07-25","041-422 09 90","078-684 90 73","konstanze.mez@edulu.ch","w","Mez Konstanze"]
["Morach Oliver",74,403262,"Morach","Oliver","mor","Im Käfergrund 20","5000","Aarau","Hr","lic. phil. I","1957-02-28","062-824 91 84","079-525 15 02","oliver.morach@edulu.ch","m","Morach Oliver"]
["Mössinger Robert",75,403261,"Mössinger","Robert","mos","Rebhaldenweg 18","5000","Aarau","Hr","Lehrdiplom Oboe","1960-06-13","062-721 46 37","076-571 46 37",null,"m","Mössinger Robert"]
["Motz Roger",76,406060,"Motz","Roger","mot","Stapferstrasse 4","5000","Aarau","Hr","lic. phil. I","1980-04-17","078-802 06 16",null,"roger.motz@edulu.ch","m","Motz Roger"]
["Mundwiler Stefan",77,405660,"Mundwiler","Stefan","mun","Neulandweg 21","5036","Oberentfelden","Hr","Dr. phil. II","1968-08-20","062-823 83 39","076-575 95 14","stefan.mundwiler@edulu.ch","m","Mundwiler Stefan"]
["Nellen Michael",78,145,"Nellen","Michael","nel","Rebbergstr. 92a","5408","Ennetbaden","Hr","lic. phil. I","1962-09-10","056-221 52 53","079-366 08 52","michael.nellen@edulu.ch","m","Nellen Michael"]
["Ockenfels Dieter",{"$f":"B108+1","v":79},403279,"Ockenfels","Dieter","ock","Ennetweg 5","6015","Luzern","Hr","Theaterpädagoge","1958-03-20","041-360 97 00","076-567 33 66","dieter.ockenfels@edulu.ch","m","Ockenfels Dieter"]
["Oswald Markus",80,203,"Oswald","Markus","osw","Mythenstrasse 8","6003","Luzern","Hr","Lehrdiplom Gitarre","1963-07-16","077-465 08 66",null,null,"m","Oswald Markus"]
["Peter Andrea",81,411015,"Peter","Andrea","pet","Münigenstrasse 5B","6208","Oberkirch LU","Fr","MSc ETH","1985-02-01","079-596 70 88",null,"andrea.peter@edulu.ch","w","Peter Andrea"]
["Peyer Iso",82,178,"Peyer","Iso","pey","Haselwart 26b","6210","Sursee","Hr","Dr. phil. I","1961-05-01","041-920 24 51","076-348 24 51","iso.peyer@edulu.ch","m","Peyer Iso"]
["Probst Rolf",83,41,"Probst","Rolf","xpro","Surengasse 22","6210","Sursee","Hr","dipl. math. ETH","1954-11-09","041-921 36 23","077-420 31 64","rolf.probst@edulu.ch","m","Probst Rolf"]
["Regli Robert",84,403257,"Regli","Robert","rer","Parkweg 13","6210","Sursee","Hr","MTh, MRe","1955-08-28","041-921 01 23","079-733 83 47","robert.regli@edulu.ch","m","Regli Robert"]
["Rey Timothy",85,411040,"Rey","Timothy",null,"Dietzingerstrasse 2","8003","Zürich","Hr",null,"1989-04-05","079-725 57 35",null,null,"m","Rey Timothy"]
["Richter Marianne",86,410154,"Richter","Marianne","ric","Zehntenhof","6213","Knutwil","Fr","Lehrdiplom Violine","1975-05-17","041-922 03 06","076-414 10 16",null,"w","Richter Marianne"]
["Ris Daniel",87,409277,"Ris","Daniel","ris","Rosshalde 2","6023","Rothenburg","Hr","LDM Chemie u. Mathematik","1989-07-22","041-282 48 47","079-308 14 91","daniel.ris@edulu.ch","m","Ris Daniel"]
["Roesti Maria",88,408900,"Roesti","Maria","roe","Hochrütiring 12","6005","Luzern","Fr","Lehrdiplom Querflöte","1982-08-07","041-310 21 71","078-884 68 42",null,"w","Roesti Maria"]
["Roth Janick",89,411012,"Roth","Janick","rot","Gurtenweg 15","3074","Muri b. Bern","Hr","LDM GS und GG","1989-03-01","079-516 67 20",null,null,"m","Roth Janick"]
["Rutz Alain",90,408877,"Rutz","Alain","rut","Vogelsang 10","6205","Eich","Hr","M Sc Sportwissenschaft","1986-04-13","079-376 54 16",null,"alain.rutz@edulu.ch","m","Rutz Alain"]
["Salm Ulrich",91,411010,"Salm","Ulrich","sal","Aspalterweg 9","5106","Veltheim AG","Hr","Rektor, lic. oec.","1967-09-29","056-443 31 06","076-391 51 06","ulrich.salm@edulu.ch","m","Salm Ulrich"]
["Salopek Schallehn Vlasta",92,100,"Salopek Schallehn","Vlasta","sav","Buchenrain 3","6010","Kriens","Fr","Lehrdiplom Klavier","1967-05-14","041-370 67 60","078-815 53 46",null,"w","Salopek Schallehn Vlasta"]
["Sandel Scott",93,404074,"Sandel","Scott","san","Adligenswilerstr. 26","6006","Luzern","Hr","B. Mus., Ed. M. ","1958-02-15","041-930 03 43","076-526 21 02","scott.sandel@edulu.ch","m","Sandel Scott"]
["Schärer Lothar",94,403259,"Schärer","Lothar","sar","Rainacher 21","6243","Egolzwil","Hr","lic. iur.","1965-03-22","041-980 01 90","079-336 14 50","lothar.schaerer@edulu.ch","m","Schärer Lothar"]
["Scheidegger Franziska",95,405196,"Scheidegger","Franziska","sei","Allmendstrasse 25","4632","Trimbach","Fr","lic. phil. I","1971-12-08","062-293 14 18","078-624 99 06","franziska.scheidegger@edulu.ch","w","Scheidegger Franziska"]
["Schmid Maria",96,406833,"Schmid","Maria","smi","Märglenweid 4","6276","Hohenrain","Fr","Musikerin MH","1965-01-15","041-910 56 73","079-672 96 92",null,"w","Schmid Maria"]
["Schmid Natalie",97,410589,"Schmid","Natalie","smn","Habsburgerstrasse 37","6003","Luzern","Fr","MA Fine Arts","1992-12-14","079-741 80 25",null,"natalie.schmid@edulu.ch","w","Schmid Natalie"]
["Schneider Johanna",98,96,"Schneider","Johanna","sne","Reutenstr. 3a","4800","Zofingen","Fr","Lehrdiplom Klavier","1963-07-10","062-751 21 73","079-211 83 94",null,"w","Schneider Johanna"]
["Schweizer Herbert",99,91,"Schweizer","Herbert","swe","Pilatusblick 12","6015","Luzern","Hr","Dr. phil. hist., lic. theol.","1957-10-15","041-361 16 04","079-285 53 78","herbert.schweizer@edulu.ch","m","Schweizer Herbert"]
["Siegenthaler Christian",100,179,"Siegenthaler","Christian","sie","Grossmatte 2A","6014","Luzern","Hr","eidg. dipl. Zeichenlehrer","1969-01-22","041-240 24 57","079-660 35 13","christian.siegenthaler@edulu.ch","m","Siegenthaler Christian"]
["Siegrist Céline",101,411028,"Siegrist","Céline",null,"Zelglistrasse 38","5442","Fislisbach","Fr","STV für PEY","1991-09-24","079-386 40 70",null,null,"w","Siegrist Céline"]
["Sperduto Donato",102,408035,"Sperduto","Donato","spe","Mythenstrasse 31","6020","Emmenbrücke","Hr","Dr. lic. phil. I","1969-12-16","078-836 33 67",null,"donato.sperduto@edulu.ch","m","Sperduto Donato"]
["Stadler David",103,164,"Stadler","David","sta","Seematte 2","6214","Schenkon","Hr","MSc ETH","1968-07-31","041-921 20 13","079-779 61 72","david.stadler@edulu.ch","m","Stadler David"]
["Stäger Anton",104,411006,"Stäger","Anton",null,"Meierhöflistrasse 1","6017","Ruswil","Hr",null,"1993-09-22","041-495 32 63","079-564 79 09",null,"m","Stäger Anton"]
["Stalder Marcel",105,403285,"Stalder","Marcel","stl","Hegarstrasse 19","8032","Zürich","Hr","Lehrdiplom Elektrobass","1971-10-21","044-362 68 58","076-565 68 58","marcel.stalder@edulu.ch","m","Stalder Marcel"]
["Stalder Stanja",106,400272,"Stalder","Stanja","sts","Libellenstr. 42","6004","Luzern","Fr","dipl. Turn- und Sportlehrerin ","1975-03-06","041-420 38 78","079-564 38 08","stanja.stalder@edulu.ch","w","Stalder Stanja"]
["Staub Raphael",107,405220,"Staub","Raphael","stb","Schellenrainstrasse 2","6210","Sursee","Hr","Lehrdiplom Euphonium, Posaune","1974-08-03","041-921 25 15","079-705 63 07","raphael.staub@edulu.ch","m","Staub Raphael"]
["Steffen Daniel",108,182,"Steffen","Daniel","ste","Lindengartenweg 5","6005","Luzern","Hr","Lehrdiplom Klavier","1969-05-14","041-210 09 69","079-821 47 62",null,"m","Steffen Daniel"]
["Steiger Martin",109,401491,"Steiger","Martin","stm","Obere Dattenbergstrasse 14","6005","Luzern","Hr","dipl. phys. ETH","1975-05-28","079-786 65 45",null,"martin.steiger@edulu.ch","m","Steiger Martin"]
["Steiner Florian",110,410590,"Steiner","Florian","stf","Alpenstrasse 16","3084","Wabern","Hr","dipl. Gymnasiallehrer","1984-06-13","079-539 16 94",null,"florian.steiner@edulu.ch","m","Steiner Florian"]
["Steiner Yanick",111,411004,"Steiner","Yanick","sty","Baumgartenstrasse 7","4900","Langenthal","Hr","M. A.","1992-11-03","079-673 39 07",null,null,"m","Steiner Yanick"]
["Stucki Christian",112,402828,"Stucki","Christian","stc","Bergstr. 47","6010","Kriens","Hr","dipl. Zeichenlehrer","1966-05-06","041-310 64 40","077-466 99 67","christian.stucki@edulu.ch","m","Stucki Christian"]
["Studer Patrick",113,402281,"Studer","Patrick","stu","Seestrasse 1","6048","Horw","Hr","dipl. Turn- und Sportlehrer","1975-03-25","078-638 07 85",null,"patrick.studer@edulu.ch","m","Studer Patrick"]
["Thévenaz Modestin Clémence",114,408045,"Thévenaz Modestin","Clémence","the","Waffenplatzstrasse 13","4500","Solothurn","Fr","lic. phil. I","1972-11-15","032-621 05 76","079-292 64 55","clemence.thevenaz@edulu.ch","w","Thévenaz Modestin Clémence"]
["Thürig Mario",115,403266,"Thürig","Mario","thm","Wilgutweg 13","6162","Entlebuch","Hr","Schulmusiker","1974-09-12","041-480 49 01","078-748 20 14","mario.thuerig@edulu.ch","m","Thürig Mario"]
["Unternährer Gerhard",116,404075,"Unternährer","Gerhard","unt","Josef-Müller-Weg 6","6210","Sursee","Hr","dipl. Musiklehrer II","1972-08-24","079-517 12 22",null,"gerhard.unternaehrer@edulu.ch","m","Unternährer Gerhard"]
["Voney Jürg",117,83,"Voney","Jürg","von","Kaspar-Koppstr. 121","6030","Ebikon","Hr","Lehrdiplom Schlagzeug","1956-05-12","041-420 57 31","079-606 93 35",null,"m","Voney Jürg"]
["Wernli Roger",118,405197,"Wernli","Roger","wer","Morgartenring 114","4054","Basel","Hr","lic. phil. nat.","1960-11-13","061-302 32 59","079-772 26 64","roger.wernli@edulu.ch","m","Wernli Roger"]
["Wey Marcel",119,57,"Wey","Marcel","wey","Tannrain 5","6214","Schenkon","Hr","dipl. Turn- und Sportlehrer II","1960-03-08","041-921 41 08","078-642 01 08","marcel.wey@edulu.ch","m","Wey Marcel"]
["Widmer Marina",120,407215,"Widmer","Marina","wid","Lohrenhöhe 25","6020","Emmenbrücke","Fr","MSc Mathematik ETH","1986-11-15","076-469 92 17",null,"marina.widmer@edulu.ch","w","Widmer Marina"]
["Wigger Franziska",121,404456,"Wigger","Franziska","wif","Eichenmoosstr. 87","6233","Büron","Fr","dipl. Gesangspädagogin","1969-12-02","041-486 25 69","079-779 06 51",null,"w","Wigger Franziska"]
["Zemp Eliane",122,410133,"Zemp","Eliane","zem","Grüneggstrasse 19","6005","Luzern","Fr","B Sc SP","1993-04-26","077-408 71 62",null,"eliane.zemp@edulu.ch","w","Zemp Eliane"]
["Zihlmann Markus",123,407217,"Zihlmann","Markus","zih","Seematte 5","6214","Schenkon","Hr","lic. phil. I","1977-11-28","078-815 94 22",null,"markus.zihlmann@edulu.ch","m","Zihlmann Markus"]
["Züger Markus",124,406063,"Züger","Markus","zug","Schulhausstrasse 10","3052","Zollikofen","Hr","lic. phil. I","1974-11-30","031-534 41 37","076-409 50 42","markus.zueger@edulu.ch","m","Züger Markus"]

{"sheet":"A","index":4,"n_rows":91,"n_cols":78,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["Name:","SA21"]
[]
["Typ:","Maturaarbeit","MA","Kantonsschule","6","Prorektor Oberstufe","S. Deeg"]
[null,"Selbständige Arbeit","SA","Fachmittelschule","F3","Prorektor FMS","M. Zihlmann"]
[null,"Fachmaturitätsarbeit","FA","Fachmittelschule","F4","Prorektor FMS","M. Zihlmann"]
[null,"0","LEER","Kantonsschule",null," "," "]
[]
["Einzel/Grp.:","Einzelarbeit"]
[null,"Gruppenarbeit"]
[]
[null,null,null,null,null,"MA",null,null,null,null,"SA",null,null,null,null,"FA",null,null,null,null,"LEER"]
[null,null,null,null,null,"MA_Gew1","MA_Gew2","MA_Gew3","MA_Gew4",null,"SA_Gew1","SA_Gew2","SA_Gew3","SA_Gew4",null,"FA_Gew1","FA_Gew2","FA_Gew3","FA_Gew4",null,"LEER_Gew1","LEER_Gew2","LEER_Gew3","LEER_Gew4"]
["Richtung:","Textzentrierte Arbeit","Inhalt:","Formales:",2,0.5,0.2,0.05,0.25,{"$f":"SUM(F13:I13)","v":1},0.5,0.2,0.05,0.25,{"$f":"SUM(K13:N13)","v":1},0.45,0.15,0.05,0.35,{"$f":"SUM(P13:S13)","v":1}]
[null,"naturwissenschaftliche Arbeit","Inhalt:","Formales:",3,0.5,0.2,0.05,0.25,1,0.5,0.2,0.05,0.25,1,0.45,0.15,0.05,0.35,1]
[null,"mathematische Arbeit","Inhalt:","Formales:",4,0.5,0.2,0.05,0.25,1,0.5,0.2,0.05,0.25,1,0.45,0.15,0.05,0.35,1]
[null,"Fremdsprache","Inhalt:","Sprache und Formales:",5,0.35,0.35,0.05,0.25,1,0.35,0.35,0.05,0.25,1,0.3,0.3,0.05,0.35,1]
[null,"musisch-kreative oder praktische Arbeit mit grossem Werkanteil (nur in DE, BG und MU möglich)","Werk:","Schriftlicher Kommentar:",6,0.5,0.2,0.05,0.25,1,0.5,0.2,0.05,0.25,1,0.45,0.15,0.05,0.35,1]
[null,"musisch-kreative oder praktische Arbeit mit kleinerem Werkanteil (nur in DE, MU und SP möglich)","Werk:","Schriftlicher Kommentar:",7,0.35,0.35,0.05,0.25,1,0.35,0.35,0.05,0.25,1,0.3,0.3,0.05,0.35,1]
[]
["Fach:","Bildnerisches Gestalten","BG"]
[null,"Biologie","BI"]
[null,"Chemie","CH"]
[null,"Deutsch","DE"]
[null,"Englisch","EN"]
[null,"Französich","FR"]
[null,"Geografie","GG"]
[null,"Geschichte","GS"]
[null,"Informatik","IN"]
[null,"Italienisch","IT"]
[null,"Latein","LA"]
[null,"Mathematik","MA"]
[null,"Musik","MU"]
[null,"Philosophie","PH"]
[null,"Pädagogik/Psychologie","PP"]
[null,"Physik","PS"]
[null,"Religion","RE"]
[null,"Spanisch","ES"]
[null,"Sport","SP"]
[null,"Wirtschaft und Recht","WR"]
[null,"Anderes Fach","-"]
[]
["Zeitplan:","eingehalten"]
[null,"wenig im Rückstand"]
[null,"stark im Rückstand"]
[]
["Weiterarbeit:","gemäss Plan"]
[null,"gemäss Abmachung"]
[null,"neue Zielsetzung"]
[]
["Bewertung:","ungenügend"]
[null,"genügend"]
[null,"gut"]
[null,"sehr gut"]
[]
["Auszeichung:","nein"]
[null,"ja"]
[]
["Termine:","Orientierung","Woche vom / am","2020-09-14"]
[null,"Marktplatz","Woche vom / am"]
[null,"Präsentation Bes.","Woche vom / am","2020-10-21"]
[null,"Bibliothek Bes.","abgeschl. bis"]
[null,"Themenabgabe","abgeschl. bis","2020-12-18"]
[null,"Zuweisung Bet/Kor","abgeschl. bis","2021-01-08"]
[null,"Bewilligung SL","abgeschl. bis","2021-01-15"]
[null,"Erarbeitung","ab","2021-01-18"]
[null,"Projektvertrag","abgeschl. bis","2021-02-05"]
[null,"Einführung wiss. Arb.","abgeschl. bis"]
[null,"Computerkurs","Woche vom","2021-02-23"]
[null,"Zeitgefäss","Woche vom","2021-07-05"]
[null,"Zwischenbericht","abgeschl. bis","2021-04-30"]
[null,"Abgabe","am","2021-08-30"]
[null,"Korrektur","abgeschl. bis","2021-10-22"]
[null,"Nachbesserung","abgeschl. bis"]
[null,"Präsentation","Woche vom / am","2021-10-25"]
[null,"Bewertung","abgeschl. bis","2021-12-01"]
[null,"Gutachten","am","2021-12-03"]
[null,"Evaluation","Woche vom"]
[null,"Abrechnung","abgeschl. bis","2021-06-18"]
[]
["Dateiangaben","D:\\KSS MA SA FA\\40 Arbeiten aktuell\\"]
[null,"\\05 Themenabgabe"]
[null,"\\06 Zuweisung Betreuer Korreferent"]
[null,"\\07 Bewilligung Schulleitung"]
[null,"\\09 Projektvertrag"]
[null,"\\13 Zwischenbericht"]
[null,"\\18 Bewertung"]
[null,"\\Uebersicht.xlsm"]
[]
["Angaben"]
["A_Name","S_Verfasser","S_Partner","S_Name","S_Vorname","S_Klasse","S_Klasse2","S_Adresse","S_Ort","S_Telefon","S_Mail","S_Typ","S_Richtung","S_Fach","S_FachKuerzel","S_Einzel","S_GrpMit","S_Arbeitstitel","S_Leitfragen","S_Eigenleistung","S_Motivation","S_Absprache","S_Anmerkung","B_Name","B_Vorname","B_Kuerzel","B_Mail","K_Name","K_Vorname","K_Kuerzel","K_Mail","SL_Entscheid","SL_Datum","SL_Unterschrift1","SL_Unterschrift2","V_Fragestellung","V_Zeitplan","V_Meilensteine","V_Beurteilungkriterien","V_Zusammenarbeit","V_Anmerkungen","V_Datum1","V_Unterschrift11","V_Unterschrift12","V_Unterschrift21","V_Unterschrift22","N_Titel","N_Arbeitsprozess","N_Zwischenbeurteilung","N_Anmerkungen","N_Zeitplan","N_Weiterarbeit","N_Bewertung","N_Datum1","N_Unterschrift11","N_Unterschrift12","N_Datum2","N_Unterschrift21","N_Unterschrift22","N_Gewicht1","N_Note1","N_Gewicht2","N_Note2","N_Gewicht3","N_Note3","N_Gewicht4","N_Note4","N_Note5","A_Auszeichnungswuerdig","A_AuszeichnungBegruendung","A_Externeingereicht","A_ExterneingereichtBei","A_Datum1","A_Datum2","A_Unterschrift11","A_Unterschrift12","A_Unterschrift21","A_Unterschrift22"]
[{"$f":"A_Name","v":"SA21"},{"$f":"S_Verfasser","v":0},{"$f":"S_Partner","v":""},{"$f":"S_Name","v":""},{"$f":"S_Vorname","v":""},{"$f":"S_Klasse","v":""},{"$f":"S_Klasse2","v":""},{"$f":"S_Adresse","v":""},{"$f":"S_Ort","v":""},{"$f":"S_Telefon","v":""},{"$f":"S_Mail","v":""},{"$f":"S_Typ","v":0},{"$f":"S_Richtung","v":0},{"$f":"S_Fach","v":0},{"$f":"S_FachKuerzel","v":""},{"$f":"S_Einzel","v":0},{"$f":"S_GrpMit","v":0},{"$f":"S_Arbeitstitel","v":0},{"$f":"S_Leitfragen","v":0},{"$f":"S_Eigenleistung","v":0},{"$f":"S_Motivation","v":0},{"$f":"S_Absprache","v":0},{"$f":"S_Anmerkung","v":0},{"$f":"B_Name","v":""},{"$f":"B_Vorname","v":""},{"$f":"B_Kuerzel","v":""},{"$f":"B_Mail","v":""},{"$f":"K_Name","v":""},{"$f":"K_Vorname","v":""},{"$f":"K_Kuerzel","v":""},{"$f":"K_Mail","v":""},{"$f":"SL_Entscheid","v":0},{"$f":"SL_Datum","v":0},{"$f":"SL_Unterschrift1","v":""},{"$f":"SL_Unterschrift2","v":""},{"$f":"V_Fragestellung","v":0},{"$f":"V_Zeitplan","v":0},{"$f":"V_Meilensteine","v":0},{"$f":"V_Beurteilungskriterien","v":0},{"$f":"V_Zusammenarbeit","v":0},{"$f":"V_Anmerkungen","v":0},{"$f":"V_Datum1","v":0},{"$f":"V_Unterschrift11","v":" "},{"$f":"V_Unterschrift12","v":0},{"$f":"V_Unterschrift21","v":" "},{"$f":"V_Unterschrift22","v":0},{"$f":"N_Titel","v":0},{"$f":"N_Arbeitsprozess","v":0},{"$f":"N_Zwischenbeurteilung","v":0},{"$f":"N_Anmerkungen","v":0},{"$f":"N_Zeitplan","v":0},{"$f":"N_Weiterarbeit","v":0},{"$f":"N_Bewertung","v":0},{"$f":"N_Datum1","v":0},{"$f":"N_Unterschrift11","v":" "},{"$f":"N_Unterschrift12","v":0},{"$f":"N_Datum2","v":""},{"$f":"N_Unterschrift21","v":" "},{"$f":"N_Unterschrift22","v":0},{"$f":"N_Gewicht1","v":""},{"$f":"N_Note1","v":0},{"$f":"N_Gewicht2","v":""},{"$f":"N_Note2","v":0},{"$f":"N_Gewicht3","v":""},{"$f":"N_Note3","v":0},{"$f":"N_Gewicht4","v":""},{"$f":"N_Note4","v":0},{"$f":"N_Note5","v":""},{"$f":"A_Auszeichnungswuerdig","v":0},{"$f":"A_AuszeichnungBegruendung","v":0},{"$f":"A_Externeingereicht","v":0},{"$f":"A_ExterneingereichtBei","v":0},{"$f":"A_Datum1","v":0},{"$f":"A_Datum2","v":""},{"$f":"A_Unterschrift11","v":" "},{"$f":"A_Unterschrift12","v":0},{"$f":"A_Unterschrift21","v":" "},{"$f":"A_Unterschrift22","v":0}]