{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["intern"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"intern","index":0,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,6],[7,0,7,1],[2,0,2,1],[5,0,5,1],[6,0,6,1],[4,0,4,1],[3,0,3,1],[10,0,10,6],[12,0,12,6],[1,0,1,1],[9,0,9,1],[8,0,8,1],[11,0,11,6]]}
["Qualiberechnung für Schüler der Mittelschule"]
[null,null,"JN","PN","mdl.","Pu","Note"]
["D",null,1,2,null,{"$f":"(C3+D3)*2","v":6},{"$f":"IF(F3/4-INT(F3/4)=0.5,ROUND(F3/4,0)-1,ROUND(F3/4,0))","v":1}]
["M",null,1,1,null,{"$f":"(C4+D4)*2","v":4},{"$f":"IF(F4/4-INT(F4/4)=0.5,ROUND(F4/4,0)-1,ROUND(F4/4,0))","v":1}]
["E / NT / GPG",null,4,1,null,{"$f":"IF(E5=\"\",C5*2+D5*2,C5*2+D5+E5)","v":10},{"$f":"IF(F5/4-INT(F5/4)=0.5,ROUND(F5/4,0)-1,ROUND(F5/4,0))","v":2}]
["WiB",null,1,null,null,{"$f":"C6+D6","v":1}]
["WiK/ES/Te",null,1,null,null,{"$f":"C7+D7","v":1}]
["Projektprüfung",null,null,2,null,{"$f":"D8*2","v":4},{"$f":"IF((F6+F7+F8)/4-INT((F6+F7+F8)/4)<=0.5,INT((F6+F7+F8)/4),ROUND((F6+F7+F8)/4,0))","v":1}]
["Mu/Ku/Rel/Eth/Sport/Info",null,1,1,null,{"$f":"C9+D9","v":2},{"$f":"IF(F9/2-INT(F9/2)=0.5,ROUND(F9/2,0)-1,ROUND(F9/2,0))","v":1}]
[null,null,null,"Summe",null,{"$f":"IF(COUNT($F$3:$F$9)<7,\"\",(SUM($F$3:$F$9)&\" : 18\"))","v":"28 : 18"},{"$f":"IF(COUNT($F$3:$F$9)<7,\"\",(SUM($F$3:$F$9)/ 18))","v":1.5555555555555556}]
["Gib die Jahresnoten (JN) und Prüfungsnoten (PN) ein"]
[]
[{"$f":"\"Mit diesen Noten hättest du die Prüfung \"&IF($G$10<=3.1,\"bestanden\",\"leider nicht bestanden\")","v":"Mit diesen Noten hättest du die Prüfung bestanden"}]