{"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":"SA20____"}]
[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":"SA20____"}]
[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":"2019-12-13"},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":"2020-01-17"},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":"2020-01-18"},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":"2020-02-07"},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":"2020-05-01"},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":"2020-12-02"},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":"2019-10-14"}]
[null,null,"Marktplatz",null,"Woche vom / am",null,null,null,null,{"$f":"A!D59","v":""}]
[null,null,"Präsentation Bes.",null,"Woche vom / am",null,null,null,null,{"$f":"A!D60","v":"2020-03-09"}]
[null,null,"Bibliothek Bes.",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D61","v":""}]
[null,null,"Themenabgabe",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D62","v":"2019-12-13"}]
[null,null,"Zuweisung Bet/Kor",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D63","v":"2020-01-17"}]
[null,null,"Bewilligung SL",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D64","v":"2020-01-18"}]
[null,null,"Erarbeitung",null,"ab",null,null,null,null,{"$f":"A!D65","v":"2020-01-20"}]
[null,null,"Projektvertrag",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D66","v":"2020-02-07"}]
[null,null,"Einführung wiss. Arb.",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D67","v":"2020-02-14"}]
[null,null,"Computerkurs",null,"Woche vom",null,null,null,null,{"$f":"A!D68","v":"2020-02-10"}]
[null,null,"Zeitgefäss",null,"Woche vom",null,null,null,null,{"$f":"A!D69","v":"2020-06-29"}]
[null,null,"Zwischenbericht",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D70","v":"2020-05-01"}]
[null,null,"Abgabe",null,"am",null,null,null,null,{"$f":"A!D71","v":"2020-08-24"}]
[null,null,"Korrektur",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D72","v":"2020-10-16"}]
[null,null,"Nachbesserung",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D73","v":""}]
[null,null,"Präsentation",null,"Woche vom / am",null,null,null,null,{"$f":"A!D74","v":"2020-10-19"}]
[null,null,"Bewertung",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D75","v":"2020-12-02"}]
[null,null,"Gutachten",null,"am",null,null,null,null,{"$f":"A!D76","v":"2020-12-04"}]
[null,null,"Evaluation",null,"Woche vom / am",null,null,null,null,{"$f":"A!D77","v":"2020-12-07"}]
[null,null,"Abrechnung",null,"abgeschl. bis",null,null,null,null,{"$f":"A!D78","v":"00:00:00"}]
[]
[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":78,"n_cols":15,"rows_kept":78,"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":"Birrer Maureen F2a"},1,408657,"F2","Birrer","Maureen","F2a","Eichenweg 24","6212","St. Erhard","2002-07-16","041-920 14 44","079-300 69 34","Maureen_Birrer@sluz.ch","w"]
[{"$f":"CONCATENATE(E32,\" \",F32,\" \",G32)","v":"Blum Kyra F2b"},{"$f":"B31+1","v":2},409801,"F2","Blum","Kyra","F2b","Dorfstrasse 71","6265","Roggliswil","2003-12-10","079-781 32 21",null,"Kyra_Blum@sluz.ch","w"]
[{"$f":"CONCATENATE(E33,\" \",F33,\" \",G33)","v":"Blümli Julia F2b"},{"$f":"B32+1","v":3},409803,"F2","Blümli","Julia","F2b","Grütstrasse 3","6244","Nebikon","2003-05-26","062-756 54 74","079-514 13 48","Julia_Bluemli@sluz.ch","w"]
["Brechbühl Aline F2b",4,409805,"F2","Brechbühl","Aline","F2b","Hubel 6","6212","St. Erhard","2002-12-19","041-921 03 08","076-251 19 12","Aline_Brechbuehl@sluz.ch","w"]
["Brunner Markus F2b",5,409807,"F2","Brunner","Markus","F2b","Spittelhof 43","4806","Wikon","2002-11-14","062-751 54 07","077-40017 67","Markus_Brunner1@sluz.ch","m"]
["Bucher Lena F2b",6,409844,"F2","Bucher","Lena","F2b","Dorfstrasse 17","6214","Schenkon","2002-03-16","041-921 03 82","079-601 16 12","Lena_Bucher@sluz.ch","w"]
["Bühlmann Alina F2b",7,410483,"F2","Bühlmann","Alina","F2b","Mitterain 28","6234","Triengen","2002-10-16","076-489 99 77",null,"Alina_Buehlmann@sluz.ch","w"]
["Bühlmann Tina F2a",8,410082,"F2","Bühlmann","Tina","F2a","Zihl 3","6204","Sempach","2002-02-15","041-460 47 72","079-158 65 00","Tina_Buehlmann@sluz.ch","w"]
["Ciancio Angelo F2b",9,409650,"F2","Ciancio","Angelo","F2b","Heugärtenweg 6","6232","Geuensee","2002-10-16","041-281 52 71","076-563 59 79","Angelo_Ciancio@sluz.ch","m"]
["Dähler Anna F2a",10,408719,"F2","Dähler","Anna","F2a","Buchwaldweg 5","6207","Nottwil","2003-03-04","041-937 28 55","076-476 07 77","Anna_Daehler@sluz.ch","w"]
["Dervisoska Jasmina F2a",11,410103,"F2","Dervisoska","Jasmina","F2a","Rotbachweg 12","6152","Hüswil","2003-05-10","041-988 13 81","079-944 77 29","Jasmina_Dervisoska@sluz.ch","w"]
["Erni Cyril F2b",12,410105,"F2","Erni","Cyril","F2b","Lischenweg 3","4915","St. Urban","2003-04-27","062-530 66 67","079-301 29 22","Cyril_Erni@sluz.ch","m"]
["Erni Salome F2a",13,409810,"F2","Erni","Salome","F2a","Grünenbodenstrasse 29","6144","Zell LU","2003-01-03","041-970 03 02","079-191 00 23","Salome_Erni1@sluz.ch","w"]
["Fajardo Richell F2b",14,410583,"F2","Fajardo","Richell","F2b","Schachenmatt 7","6133","Hergiswil LU","2003-06-22","041-979 01 61","079-120 65 92","Richell_Fajardo1@sluz.ch","w"]
["Gehrlach Marlen F2b",15,409812,"F2","Gehrlach","Marlen","F2b","Längenmoosstrasse 2","6233","Büron","2001-10-13","041-934 00 36","076-471 48 60","Marlen_Gehrlach@sluz.ch","w"]
["Gerber Eliane F2a",16,410615,"F2","Gerber","Eliane","F2a","Feldstrasse 20","6022","Grosswangen","2003-03-16","041-980 30 27","079-873 67 30","Eliane_Gerber@sluz.ch","w"]
["Giger Sabrina F2b",17,409813,"F2","Giger","Sabrina","F2b","Dorfstrasse 12","6263","Richenthal","2003-05-18","062-758 41 38","079-694 61 68","Sabrina_Giger@sluz.ch","w"]
["Graweid Tanisha F2b",18,409815,"F2","Graweid","Tanisha","F2b","Flurweg 2","6262","Langnau b. Reiden","2003-02-27","062-758 43 92","076-802 88 55","Tanisha_Graweid@sluz.ch","w"]
["Greber Elaine F2a",19,409438,"F2","Greber","Elaine","F2a","Bahnhofstrasse 37","6210","Sursee","2002-10-21","041-921 20 10",null,"Elaine_Greber@sluz.ch","w"]
["Hamurtekin Hilal F2b",20,410097,"F2","Hamurtekin","Hilal","F2b","Dörnliacher 5","6232","Geuensee","2002-11-23","041-920 25 82","079-275 06 32","Hilal_Hamurtekin@sluz.ch","w"]
["Hodel Lynne F2a",21,409396,"F2","Hodel","Lynne","F2a","Osterweg 6","6210","Sursee","2002-06-11","041-921 52 74","079-275 17 99","Lynne_Hodel@sluz.ch","w"]
["Kirchhofer Laura F2a",22,409817,"F2","Kirchhofer","Laura","F2a","Wesmeristrasse 5","6221","Rickenbach LU","2003-02-03","041-467 07 22","076-812 37 66","laura_kirchhofer@sluz.ch","w"]
["Kostic Julia F2a",23,410087,"F2","Kostic","Julia","F2a","Haldenstrasse 9","6130","Willisau","2002-07-12","041-970 25 67","079-929 79 82","Julia_Kostic@sluz.ch","w"]
["Krienbühl Lynne F2a",24,409821,"F2","Krienbühl","Lynne","F2a","Hintertannberg 3","6214","Schenkon","2003-10-16","041-921 77 47","077-497 48 22","Lynne_Krienbuehl@sluz.ch","w"]
["Lütolf Lea F2a",25,408514,"F2","Lütolf","Lea","F2a","Föhrenhof","6242","Wauwil","2002-11-22","041-980 39 78","077-463 76 60","Lea_Luetolf@sluz.ch","w"]
["Meier Ilaria F2b",26,409823,"F2","Meier","Ilaria","F2b","Rosenweg 11","6210","Sursee","2002-04-17","041-921 71 94","076-583 04 17","Ilaria_Meier@sluz.ch","w"]
["Meier Kim F2b",27,410111,"F2","Meier","Kim","F2b","Feldheimstrasse 39","6260","Reiden","2004-03-19","062-758 33 18",null,"Kim_Meier@sluz.ch","w"]
["Meier Lisa F2a",28,409825,"F2","Meier","Lisa","F2a","Schwyzermatt 11","6130","Willisau","2003-05-01","041-970 46 61","079-235 65 44","Lisa_Meier@sluz.ch","w"]
["Müller Lisa F2a",29,410092,"F2","Müller","Lisa","F2a","Engelbergstrasse 12","6243","Egolzwil","2003-05-20","041-982 00 07","076-400 20 53","Lisa_Mueller@sluz.ch","w"]
["Panduri Simona F2a",30,408717,"F2","Panduri","Simona","F2a","Burgacher 7","6207","Nottwil","2002-05-29","041-938 05 55","078-625 31 11","Simona_Panduri@sluz.ch","w"]
["Pfister Sina F2b",31,409827,"F2","Pfister","Sina","F2b","Rietelstrasse 8","6252","Dagmersellen","2002-08-13","062-756 00 02","076-805 28 99","Sina_Pfister@sluz.ch","w"]
["Rölli Luana F2b",32,409829,"F2","Rölli","Luana","F2b","Surenweidstrasse 6","6208","Oberkirch LU","2003-06-14","041-921 21 19","079-565 57 27","Luana_Roelli@sluz.ch","w"]
["Rölli Vanessa F2b",33,410084,"F2","Rölli","Vanessa","F2b","Oberdorf 5a","6262","Langnau b. Reiden","2003-08-08","062-758 41 70","079-905 16 39","Vanessa_Roelli@sluz.ch","w"]
["Rudaj Donjeta F2b",34,410113,"F2","Rudaj","Donjeta","F2b","Weinberghalde 21","6234","Triengen","2002-10-12","041-933 30 56","076-327 73 68","Donjeta_Rudaj@sluz.ch","w"]
["Schlecht Chiara F2b",35,410101,"F2","Schlecht","Chiara","F2b","Bethlehem 7","6234","Kulmerau","2003-03-19","041-833 03 25","078-154 10 09","Chiara_Schlecht@sluz.ch","w"]
["Schnider Mirjam F2a",36,410115,"F2","Schnider","Mirjam","F2a","Am Sandhübel 7","6215","Beromünster","2002-10-17","041-930 45 18","077-483 64 07","Mirjam_Schnider@sluz.ch","w"]
["Schütz Noemi F2a",37,409834,"F2","Schütz","Noemi","F2a","Opfersei 6","6133","Hergiswil LU","2003-01-04","041-979 02 38","079-853 28 83","Noemi_Schuetz@sluz.ch","w"]
["Steimann Emma F2a",38,410107,"F2","Steimann","Emma","F2a","Menzbergstrasse 37","6130","Willisau","2002-08-09","079-590 32 62",null,"Emma_Steimann@sluz.ch","w"]
["Steiner Debora F2a",39,410090,"F2","Steiner","Debora","F2a","Mattenhof 1","6248","Alberswil","2001-02-22","041-980 50 06","079-131 94 48","Debora_Steiner@sluz.ch","w"]
["Tahiri Safia F2b",40,409257,"F2","Tahiri","Safia","F2b","Sagimatte 2","6234","Triengen","2000-05-20","041-535 05 73","078-698 60 64","Safia_Tahiri@sluz.ch","w"]
["Tairi Hürmize F2a",41,410117,"F2","Tairi","Hürmize","F2a","Schützefeld 2","6215","Beromünster","2002-04-23","041-525 55 45","076-238 02 12","Huermize_Tairi@sluz.ch","w"]
["Tanner Alessia F2b",42,409837,"F2","Tanner","Alessia","F2b","Feldmatte 6","6252","Dagmersellen","2002-12-23","062-756 01 27","077-430 82 48","Alessia_Tanner@sluz.ch","w"]
["Turan Esma-Nur F2b",43,410109,"F2","Turan","Esma-Nur","F2b","Roman-Burri Strasse 4","6210","Sursee","2003-01-17","041-535 99 95","078-730 85 91","EsmaNur_Turan@sluz.ch","w"]
["Verovic Sara F2a",44,410099,"F2","Verovic","Sara","F2a","Alberswilerstrasse 33","6218","Ettiswil","2003-03-01","041-980 61 50","076-447 15 65","Sara_Verovic@sluz.ch","w"]
["Waldis Yara F2a",45,409839,"F2","Waldis","Yara","F2a","Buechweid 13b","6215","Beromünster","2002-10-31","041-210 13 15","075-412 60 02","Yara_Waldis@sluz.ch","w"]
["Wiget Natalie F2a",46,410141,"F2","Wiget","Natalie","F2a","Pilatusblick 37","6015","Luzern","2003-04-12","041-252 08 20","078-684 22 80","Natalie_Wiget@sluz.ch","w"]
["Wüest Amon F2b",47,410585,"F2","Wüest","Amon","F2b","Geissburghalde 11","6130","Willisau","2002-09-30","041-971 03 20","079-895 72 88","Amon_Wueest@sluz.ch","m"]
["Zettel Fabienne F2a",48,408776,"F2","Zettel","Fabienne","F2a","Bahnhofstrasse 35","6233","Büron","2002-11-14","041-920 30 26",null,"Fabienne_Zettel@sluz.ch","w"]

{"sheet":"L","index":3,"n_rows":152,"n_cols":16,"rows_kept":152,"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":"Amico Flavia"},1,410598,"Amico","Flavia","ami","Unter-Geissenstein 8","6005","Luzern","Fr","M Sc Education","1987-11-14","076-530 06 63",null,null,"w"]
[{"$f":"CONCATENATE(D32,\" \",E32)","v":"Arnet Matthias"},{"$f":"B31+1","v":2},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"]
[{"$f":"CONCATENATE(D33,\" \",E33)","v":"Balmer Evelyne"},{"$f":"B32+1","v":3},173,"Balmer","Evelyne","bae","Rankhof 8","6208","Oberkirch LU","Fr","dipl.Turn- u. Sportlehrerin II","1973-12-16","041-920 27 85","079-583 57 38","evelyne.balmer@edulu.ch","w"]
["Baschung Franziska",4,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"]
["Baumgartner Mirjam",5,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"]
["Bechtold Toni Amadeus",6,408482,"Bechtold","Toni Amadeus","bec","Elfenaustrasse 36","6005","Luzern","Hr","Lehrdiplom Klarinette, Saxofon","1986-04-16","077-436 99 02",null,"Toni.Bechtold@edulu.ch","m"]
["Beltrani Marco",7,409273,"Beltrani","Marco","bel","Müllheimerstrasse 54","4057","Basel","Hr","MA Musikpädagogik","1988-03-12","079-543 81 60",null,"marco.beltrani@edulu.ch","m"]
["Berger Hutchings Monika",8,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"]
["Biland Susanna",9,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"]
["Blättler Benno",10,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"]
["Blum Michael",11,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"]
["Bregnard Thierry",12,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"]
["Brentini Fabrizio",13,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"]
["Broder Barbara",14,410586,"Broder","Barbara","bro","Schauensee 11","6204","Sempach","Fr","dipl. Zeichen- u. Werklehrerin","1982-10-11","041-461 03 49","078-610 65 63",null,"w"]
["Brücker Marcel",15,8,"Brücker","Marcel","xbru","Wilemattstrasse 15","6210","Sursee","Hr","lic.phil.I","1951-02-13","041-921 50 38","079-228 17 60",null,"m"]
["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"]
["Brunner Céline",17,410170,"Brunner","Céline","bru","Kapellenstrasse 31","3011","Bern","Fr",null,"1994-06-22","079-545 76 67",null,null,"w"]
["Büchel Adrian",18,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"]
["Bucher Stefan",19,69,"Bucher","Stefan","bst","Waldstr. 5/21","6015","Luzern","Hr","Lehrdiplom Klavier","1959-08-03","041-260 64 32","077-449 31 21","stefan.bucher@edulu.ch","m"]
["Budmiger Samuel",20,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"]
["Bühlmann Stephan",21,404448,"Bühlmann","Stephan","buh","Alpenstrasse 20","6210","Sursee","Hr","Lehrdiplom Horn","1967-10-04","041-920 47 00","076-490 41 91","stephan.buehlmann@edulu.ch","m"]
["Burkard Nicole",22,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"]
["Callmar Roland",23,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"]
["Casparis Claudine",24,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"]
["Chiantese Stefano",25,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"]
["Clemens Thomas",26,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"]
["Conrardy Richard",27,410587,"Conrardy","Richard","con","Moschtiweg 2","6213","Knutwil","Hr","M Sc Mathematik","1988-05-18","076-472 71 58",null,null,"m"]
["D'Incau Renato",28,410132,"D'Incau","Renato","din","Rebgasse 68","4058","Basel","Hr","M Sc PS","1982-05-29","076-548 15 61",null,"renato.dincau@edulu.ch","m"]
["Deeg Stefan",29,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"]
["Disler Severin",30,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"]
["Dos Santos Laura",31,409692,"Dos Santos","Laura","dos","Tannbergstrasse 1a","6214","Schenkon","Fr","MA Spanisch","1987-03-06","078-716 42 29",null,"laura.dossantos@edulu.ch","w"]
["Egli Peter",32,112,"Egli","Peter","egl","Bifangstrasse 7","6210","Sursee","Hr","Musikpädagoge","1962-02-02","041-530 39 32","079-398 80 44","peter.egli@edulu.ch","m"]
["Erni Xenia",33,409275,"Erni","Xenia","erx","Mariazellweg 4a","6210","Sursee","Fr","lic. phil. I","1981-12-13","081-384 10 80","079-964 74 42","xenia.erni@edulu.ch","w"]
["Fanger Felicitas",34,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"]
["Fischer Raffael",35,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"]
["Fischlin Moritz",36,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"]
["Frank Benno",37,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"]
["Freihofer Christoph",38,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"]
["Fuchs Markus",39,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"]
["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"]
["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"]
["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"]
["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"]
["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"]
["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"]
["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üter David",47,410588,"Grüter","David","gru","Birkenstrasse 3","6003","Luzern","Hr",null,"1979-07-07","079-838 43 36",null,null,"m"]
["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"]
["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"]
["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"]
["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"]
["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"]
["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,"sue.hess@edulu.ch","w"]
["Hunkeler Trudi",54,160,"Hunkeler","Trudi","hun","Müllerweg 4","4800","Zofingen","Fr","Lehrdiplom Querflöte","1958-11-06","062-751 51 23","079-428 99 63","trudi.hunkeler@edulu.ch","w"]
["Hunn Jasmin",55,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"]
["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"]
["Käppeli Wolfgang",57,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"]
["Kaufmann Anna",58,410600,"Kaufmann","Anna","kau","Gibraltarstrasse 1","6003","Luzern","Fr","MA Englisch","1992-02-07","079-790 51 43",null,null,"w"]
["Kneubühler Markus",59,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"]
["Korthus Rahel",60,410592,"Korthus","Rahel","kor","Feldhöflistr. 13","6208","Oberkirch LU","Fr","MA","1994-12-13","079-557 33 93",null,null,"w"]
["Kreder Daniel",61,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","daniel.kreder@edulu.ch","m"]
["Kronenberg Manuela",62,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"]
["Kurmann René",63,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"]
["Küttel Janine",64,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"]
["Lienert David",65,401013,"Lienert","David","lie","Burghöhe 32","6208","Oberkirch LU","Hr","lic. phil. I","1966-09-30","041-920 46 80","079-798 98 58","david.lienert@edulu.ch","m"]
["Louis Gabriele",66,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"]
[{"$f":"CONCATENATE(D97,\" \",E97)","v":"Lusser Niklaus"},{"$f":"B96+1","v":67},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"]
["Lussi Matthias",68,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 Renata",69,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"]
["Mauderli Donatina",70,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"]
["Mez Konstanze",71,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"]
["Mital Adam",72,408054,"Mital","Adam","mit","Lindenplatz 4","5027","Herznach","Hr","Lehrdiplom Cello","1979-09-09","061-321 65 36","076-505 01 52","adam.mital@edulu.ch","m"]
["Morach Oliver",73,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"]
["Mössinger Robert",74,403261,"Mössinger","Robert","mos","Rebhaldenweg 18","5000","Aarau","Hr","Lehrdiplom Oboe","1960-06-13","062-721 46 37","076-571 46 37","robert.moessinger@edulu.ch","m"]
["Motz Roger",75,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"]
["Mundwiler Stefan",76,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"]
["Nellen Michael",77,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"]
["Ockenfels Dieter",78,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"]
["Oswald Markus",79,203,"Oswald","Markus","osw","Friedbergstrasse 1a","6003","Luzern","Hr","Lehrdiplom Gitarre","1963-07-16","077-465 08 66",null,"markus.oswald@edulu.ch","m"]
["Peyer Iso",80,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"]
["Probst Rolf",81,41,"Probst","Rolf","pro","Surengasse 22","6210","Sursee","Hr","dipl. math. ETH","1954-11-09","041-921 36 23","077-420 31 64","rolf.probst@edulu.ch","m"]
["Radici Tiziana",82,408051,"Radici","Tiziana","xrad","Kleinhüningerstrasse 193","4057","Basel","Fr","dipl. Gymnasiallehrperson","1985-01-19","079-624 68 52",null,"tiziana.radici@edulu.ch","w"]
["Regli Robert",83,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"]
["Richter Marianne",84,410154,"Richter","Marianne","ric","Zehntenhof","6213","Knutwil","Fr","Lehrdiplom Violine","1975-05-17","041-922 03 06","076-414 10 16","m.richterbuetler@gmx.ch","w"]
["Ris Daniel",85,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"]
["Roesti Maria",86,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"]
["Rutz Alain",87,408877,"Rutz","Alain","rut","Schützenmatte 6","6214","Schenkon","Hr","M Sc Sportwissenschaft","1986-04-13","079-376 54 16",null,"alain.rutz@edulu.ch","m"]
["Salopek Schallehn Vlasta",88,100,"Salopek Schallehn","Vlasta","sav","Buchenrain 3","6010","Kriens","Fr","Lehrdiplom Klavier","1967-05-14","041-370 67 60","079-137 56 87","vlasta.salopek@edulu.ch","w"]
["Sandel Scott",89,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"]
["Schärer Lothar",90,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"]
["Scheidegger Franziska",91,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"]
["Schmid Maria",92,406833,"Schmid","Maria","smi","Märglenweid 4","6276","Hohenrain","Fr","Musikerin MH","1965-01-15","041-910 56 73","079-672 96 92","maria.schmid@edulu.ch","w"]
["Schmid Natalie",93,410589,"Schmid","Natalie","smn","Birkenstrasse 7","6003","Luzern","Fr",null,"1992-12-14","079-741 80 25",null,null,"w"]
["Schneider Johanna",94,96,"Schneider","Johanna","sne","Reutenstr. 3a","4800","Zofingen","Fr","Lehrdiplom Klavier","1963-07-10","062-751 21 73","079-211 83 94","johanna.schneider@edulu.ch","w"]
["Schweizer Herbert",95,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"]
["Siegenthaler Christian",96,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"]
["Söder Thomas",97,402827,"Söder","Thomas","sot","Maihofstr. 45","6004","Luzern","Hr","Dr. phil. I","1955-06-13","041-558 05 04","076-398 13 14","thomas.soeder@edulu.ch","m"]
["Sperduto Donato",98,408035,"Sperduto","Donato","spe","Mythenstrasse 31","6020","Emmenbrücke","Hr","Dr. phil. I","1969-12-16","078-836 33 67",null,"donato.sperduto@edulu.ch","m"]
["Sperisen Timothy",99,410159,"Sperisen","Timothy","spt","Seestrasse 186","8802","Kilchberg ZH","Hr","M. A. HSG","1981-05-13","079-419 87 07",null,"timothy.sperisen@edulu.ch","m"]
["Sromicki Jerzy",100,402826,"Sromicki","Jerzy","sro","Kirchstr. 9","8107","Buchs ZH","Hr","PD Dr. sc. nat. ETH","1953-10-17","044-844 47 62","079-377 87 64","jerzy.sromicki@edulu.ch","m"]
["Stadler David",101,164,"Stadler","David","sta","Seematte 2","6214","Schenkon","Hr","dipl. Umwelt-Natw. ETH","1968-07-31","041-921 20 13","079-779 61 72","david.stadler@edulu.ch","m"]
["Stalder Marcel",102,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 Stanja",103,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"]
["Staub Raphael",104,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"]
["Steffen Daniel",105,182,"Steffen","Daniel","ste","Lindengartenweg 5","6005","Luzern","Hr","Lehrdiplom Klavier","1969-05-14","041-210 09 69","079-821 47 62","daniel.steffen@edulu.ch","m"]
["Steiger Martin",106,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"]
["Steiner Florian",107,410590,"Steiner","Florian","stf","Sempachstrasse 7","3014","Bern","Hr","dipl. Gymnasiallehrer","1984-06-13","079-539 16 94",null,null,"m"]
["Stucki Christian",108,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"]
["Studer Patrick",109,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"]
["Thévenaz Modestin Clémence",110,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ürig Mario",111,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"]
["Unternährer Gerhard",112,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"]
["Vivot Angela",113,409278,"Vivot","Angela","viv","Oberstockstrasse 17","6416","Steinerberg","Fr","LDM Mathematik u. Biologie","1980-03-23","041-833 00 26","076-597 05 10","angela.vivot@edulu.ch","w"]
["Voney Jürg",114,83,"Voney","Jürg","von","Kaspar-Koppstr. 121","6030","Ebikon","Hr","Lehrdiplom Schlagzeug","1956-05-12","041-420 57 31","079-606 93 35","juerg.voney@edulu.ch","m"]
["Wernli Roger",115,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"]
["Wey Marcel",116,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"]
["Widmer Marina",117,407215,"Widmer","Marina","wid","Lohrenhöhe 25","6020","Emmenbrücke","Fr","MSc Mathematik ETH","1986-11-15",null,"076-469 92 17","marina.widmer@edulu.ch","w"]
[{"$f":"CONCATENATE(D148,\" \",E148)","v":"Wigger Franziska"},118,404456,"Wigger","Franziska","wif","Eichenmoosstr. 87","6233","Büron","Fr","dipl. Gesangspädagogin","1969-12-02","041-486 25 69","079-779 06 51","franziska.wigger@edulu.ch","w"]
["Wirth Rolf",119,405193,"Wirth","Rolf","wir","Allmendgasse 17","4914","Roggwil BE","Hr","lic. phil. hist.","1965-11-29","062-929 01 85","078-666 99 12","rolf.wirth@edulu.ch","m"]
[{"$f":"CONCATENATE(D150,\" \",E150)","v":"Zemp Eliane"},120,410133,"Zemp","Eliane","zem","Grüneggstrasse 19","6005","Luzern","Fr","B Sc SP",34085,"077-408 71 62",null,null,"w"]
["Zihlmann Markus",121,407217,"Zihlmann","Markus","zih","Seematte 5","6214","Schenkon","Hr","lic. phil. I",28457,"078-815 94 22",null,"markus.zihlmann@edulu.ch","m"]
["Züger Markus",122,406063,"Züger","Markus","zug","Schulhausstrasse 10","3052","Zollikofen","Hr","lic. phil. I",27363,"031-534 41 37","076-409 50 42","markus.zueger@edulu.ch","m"]

{"sheet":"A","index":4,"n_rows":91,"n_cols":78,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["Name:","SA20"]
[]
["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, ES, 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","2019-10-14"]
[null,"Marktplatz","Woche vom / am",""]
[null,"Präsentation Bes.","Woche vom / am","2020-03-09"]
[null,"Bibliothek Bes.","abgeschl. bis",""]
[null,"Themenabgabe","abgeschl. bis","2019-12-13"]
[null,"Zuweisung Bet/Kor","abgeschl. bis","2020-01-17"]
[null,"Bewilligung SL","abgeschl. bis","2020-01-18"]
[null,"Erarbeitung","ab","2020-01-20"]
[null,"Projektvertrag","abgeschl. bis","2020-02-07"]
[null,"Einführung wiss. Arb.","abgeschl. bis","2020-02-14"]
[null,"Computerkurs","Woche vom","2020-02-10"]
[null,"Zeitgefäss","Woche vom","2020-06-29"]
[null,"Zwischenbericht","abgeschl. bis","2020-05-01"]
[null,"Abgabe","am","2020-08-24"]
[null,"Korrektur","abgeschl. bis","2020-10-16"]
[null,"Nachbesserung","abgeschl. bis",""]
[null,"Präsentation","Woche vom / am","2020-10-19"]
[null,"Bewertung","abgeschl. bis","2020-12-02"]
[null,"Gutachten","am","2020-12-04"]
[null,"Evaluation","Woche vom","2020-12-07"]
[null,"Abrechnung","abgeschl. bis"]
[]
["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":"SA20"},{"$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}]