{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Prüfungspass","Gesamtnotenberechnung"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Prüfungspass","index":0,"n_rows":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":false,"merged":[[13,4,13,7],[12,4,12,7],[18,2,18,7],[43,2,43,7],[69,2,69,7],[41,1,41,9],[20,2,20,7],[33,2,33,7],[45,2,45,7],[56,2,56,7],[11,4,11,7],[7,4,7,7],[8,4,8,7],[9,4,9,7],[10,4,10,7]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Name:"]
[null,null,"PRÜFUNGSPASS","Vorname:"]
[null,null,null,"geb. am:"]
[null,null,"Master Lehramt","Matr. Nr.:"]
[null,null,"Unterrichtsfach Physik (523)","Telefonnummer:\n(optional)"]
[null,null,null,"Studienkennzahl:","199 XXX YYY 2"]
[null,null,null,"Bearbeitungsdatum:"]
[]
[]
[null,null,"Alternative Pflichtmodulgruppe"]
[]
[null,null,"Vertiefung Fachwissenschaft (22 ECTS)"]
[]
[null,null,"UF MA PHYS 01a Pflichtmodul Fachwissenschaft (16 ECTS npi und/oder pi)"]
[null,null,"Lehrveranstaltung","Typ","ECTS","Datum","Note","Produkt"]
[null,null,null,null,null,null,null,{"$f":"E23*G23","v":0}]
[null,null,null,null,null,null,null,{"$f":"E24*G24","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"E30*G30","v":0}]
[null,null,"Summe ECTS│Modul-Abschlussdatum│Summe Produkt",null,{"$f":"SUM(E23:E30)","v":0},{"$f":"MAX(F23:F30)","v":"00:00:00"},null,{"$f":"SUM(H23:H30)","v":0}]
[null,null,null,null,null,null,null,"Modul-Note:",{"$f":"H31/E31","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"UF MA PHYS 02a Pflichtmodul Fachdidaktik (6 ECTS pi)"]
[null,null,"Lehrveranstaltung","Typ","ECTS","Datum","Note","Produkt"]
[null,null,null,null,null,null,null,{"$f":"E36*G36","v":0}]
[null,null,null,null,null,null,null,{"$f":"E37*G37","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,"Summe ECTS│Modul-Abschlussdatum│Summe Produkt",null,{"$f":"SUM(E36:E38)","v":0},{"$f":"MAX(F36:F38)","v":"00:00:00"},null,{"$f":"SUM(H36:H38)","v":0}]
[null,null,null,null,null,null,null,"Modul-Note:",{"$f":"H39/E39","v":{"$error":"#DIV/0!"}}]
[]
[null,"ODER"]
[]
[null,null,"Vertiefung Fachdidaktik (22 ECTS)"]
[]
[null,null,"UF MA PHYS 01b Pflichtmodul Fachwissenschaft (12 ECTS npi und/oder pi)"]
[null,null,"Lehrveranstaltung","Typ","ECTS","Datum","Note","Produkt"]
[null,null,null,null,null,null,null,{"$f":"E48*G48","v":0}]
[null,null,null,null,null,null,null,{"$f":"E49*G49","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Summe ECTS│Modul-Abschlussdatum│Summe Produkt",null,{"$f":"SUM(E48:E53)","v":0},{"$f":"MAX(F48:F53)","v":"00:00:00"},null,{"$f":"SUM(H48:H53)","v":0}]
[null,null,null,null,null,null,null,"Modul-Note:",{"$f":"H54/E54","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"UF MA PHYS 02b Pflichtmodul Fachdidaktik (10 ECTS pi)"]
[null,null,"Lehrveranstaltung","Typ","ECTS","Datum","Note","Produkt"]
[null,null,null,null,null,null,null,{"$f":"E59*G59","v":0}]
[null,null,null,null,null,null,null,{"$f":"E60*G60","v":0}]
[null,null,null,null,null,null,null,{"$f":"E61*G61","v":0}]
[null,null,null,null,null,null,null,{"$f":"E62*G62","v":0}]
[null,null,null,null,null,null,null,{"$f":"E63*G63","v":0}]
[null,null,"Summe ECTS│Modul-Abschlussdatum│Summe Produkt",null,{"$f":"SUM(E59:E63)","v":0},{"$f":"MAX(F59:F63)","v":"00:00:00"},null,{"$f":"SUM(H59:H63)","v":0}]
[null,null,null,null,null,null,null,"Modul-Note:",{"$f":"H64/E64","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,"Pflichtmodul Praxis"]
[]
[null,null,"UF MA PHYS 03 Fachdidaktische Begleitung der Praxisphase (4 ECTS)"]
[]
[null,null,"Lehrveranstaltung","Typ","ECTS","Datum","Note","Produkt"]
[null,null,"Praxisseminar","SE",4,null,null,{"$f":"E73*G73","v":0}]
[null,null,"Summe ECTS│Modul-Abschlussdatum│Summe Produkt",null,{"$f":"SUM(E73:E73)","v":4},{"$f":"MAX(F73:F73)","v":"00:00:00"},null,{"$f":"SUM(H73:H73)","v":0}]
[null,null,null,null,null,null,null,"Modul-Note:",{"$f":"H74/E74","v":0}]
[]
[]
[null,null,"Abschlussphase"]
[]
[null,null,"Verfassen Sie im UF Physik Ihre Masterarbeit?"]
[null,null,"(bitte Zutreffendes auswählen)"]

{"sheet":"Gesamtnotenberechnung","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[12,3,12,4],[13,3,13,4],[10,3,10,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[11,3,11,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Name:",{"$f":"Prüfungspass!E8","v":0}]
[null,"PRÜFUNGSPASS","Vorname:",{"$f":"Prüfungspass!E9","v":0}]
[null,"Master Lehramt","Matr. Nr.:",{"$f":"Prüfungspass!E11","v":0}]
[null,"Unterrichtsfach Physik (523)","Studienkennzahl:",{"$f":"Prüfungspass!E13","v":"199 XXX YYY 2"}]
[null,null,"Summe Produkte:",{"$f":"SUM(Prüfungspass!H31,Prüfungspass!H39,Prüfungspass!H54,Prüfungspass!H64,Prüfungspass!H74)","v":0}]
[null,null,"Summe ECTS:",{"$f":"SUM(Prüfungspass!E31,Prüfungspass!E39,Prüfungspass!E54,Prüfungspass!E64,Prüfungspass!E74)","v":4}]
[null,null,"Abschlussprädikat:",{"$f":"IF(D15<=1.5,\"Z\",\"B\")","v":"Z"}]
[null,null,"Notendurchschnitt:",{"$f":"D12/D13","v":0}]
[null,null,"abgeschlossen am:",{"$f":"MAX(Prüfungspass!F31,Prüfungspass!F39,Prüfungspass!F54,Prüfungspass!F64,Prüfungspass!F74)","v":"00:00:00"}]
[null,null,"Bestätigung SSC:"]
[null,null,"SPL:"]
[null,null,"Datum:"]
[]
[]
[]
[null,"VOM SSC AUSZUFÜLLEN"]
[null,"Lehrveranstaltung","ECTS","Datum","Note","Produkt"]
[null,"Masterarbeit",26,null,null,{"$f":"C25*E25","v":0}]
[null,"Defensio",4,null,null,{"$f":"C26*E26","v":0}]
[null,"Summe ECTS│Modul-Abschlussdatum│Summe Produkt",{"$f":"SUM(C25:C26)","v":30},{"$f":"MAX(D25:D26)","v":"00:00:00"},null,{"$f":"SUM(F25:F26)","v":0}]
[]
[]
[]
[null,"Summe Produkte:",{"$f":"SUM(D12,F27)","v":0}]
[null,"Summe ECTS:",{"$f":"SUM(D13,C27)","v":34}]
[null,"Notendurchschnitt:",{"$f":"C31/C32","v":0}]