{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Arbeit 1","Arbeit 2","Arbeit 3","Arbeit 4","Auswertung"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Arbeit 1","index":0,"n_rows":46,"n_cols":18,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,3],[4,5,4,6],[0,0,0,1],[0,2,0,6],[1,0,1,1],[2,0,2,1],[3,0,3,1],[3,2,3,6]]}
["Settings",null,"Überschrift und Datum eingeben",null,null,null,null,null,null,null,null,null,0,5.7,null,null,{"$f":"IF((A3-(A3*C3/100))>=0,TRUE,FALSE)","v":true}]
["Gesamtpunktzahl",null,"1 bis ...%","2 bis ...%","3 bis ...%","4 bis ...%","5 bis ...%",null,null,null,null,null,{"$f":"IF($Q$43=TRUE,(ROUND(($A$3*$G$3/100),1))-(1*$P$43),\"\")","v":8.6},5.6]
[40,null,98,85,69,50,24,null,null,null,6,null,{"$f":"ROUND(($A$3*$G$3/100),1)","v":9.6},5.5,null,{"$f":"ROUND((((A3*C3/100)-(A3*D3/100))/10),1)","v":0.5},{"$f":"IF(P3>=0,TRUE,FALSE)","v":true},{"$f":"IF(B6<>\"\",VLOOKUP(B6,M1:N45,2,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(9*$P$33),\"\")","v":11},5.4]
["Name","Punkte","Note",null,null,"Notenspiegel",null,1,1,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(8*$P$33),\"\")","v":12},5.3]
[null,null,{"$f":"IF(B6<>\"\",VLOOKUP(D6,$H$5:$I$20,2,1),\"\")","v":""},{"$f":"IF(B6<>\"\",VLOOKUP(B6,$M$1:$N$45,2,1),\"\")","v":""},{"$f":"IF(B6<>\"\",ROUND(VLOOKUP(B6,$M$1:$N$45,2,1),0),\"\")","v":""},"Note","Anzahl",1.4,"1-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(7*$P$33),\"\")","v":13},5.2]
[null,null,{"$f":"IF(B7<>\"\",VLOOKUP(D7,$H$5:$I$20,2,1),\"\")","v":""},{"$f":"IF(B7<>\"\",VLOOKUP(B7,$M$1:$N$45,2,1),\"\")","v":""},{"$f":"IF(B7<>\"\",ROUND(VLOOKUP(B7,$M$1:$N$45,2,1),0),\"\")","v":""},1,{"$f":"COUNTIF($E$6:$E$46,F7)","v":0},1.5,"2+",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(6*$P$33),\"\")","v":14},5.0999999999999996]
[null,null,"","","",2,{"$f":"COUNTIF($E$6:$E$46,F8)","v":0},1.6,2,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(5*$P$33),\"\")","v":15},5]
[null,null,"","","",3,0,2.4,"2-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(4*$P$33),\"\")","v":16},4.9000000000000004]
[null,null,"","","",4,0,2.5,"3+",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(3*$P$33),\"\")","v":17},4.8]
[null,null,"","","",5,0,2.6,3,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(2*$P$33),\"\")","v":18},4.7]
[null,null,"","","",6,0,3.4,"3-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(1*$P$33),\"\")","v":19},4.5999999999999996]
[null,null,"","","","ø",{"$f":"IFERROR(ROUND(SUMPRODUCT(F7:F12,G7:G12)/COUNT(E6:E46),2),\"\")","v":""},3.5,"4+",null,5,null,{"$f":"ROUND(($A$3*$F$3/100),1)","v":20},4.5,null,{"$f":"ROUND((((A3*D3/100)-(A3*E3/100))/10),1)","v":0.6},{"$f":"IF(P13>=0,TRUE,FALSE)","v":true}]
[null,null,"","","",null,null,3.6,4,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(9*$P$23),\"\")","v":20.400000000000002},4.4000000000000004]
[null,null,"","","",null,null,4.4000000000000004,"4-",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(8*$P$23),\"\")","v":21.200000000000003},4.3]
[null,null,"","","",null,null,4.5,"5+",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(7*$P$23),\"\")","v":22},4.2]
[null,null,"","","",null,null,4.5999999999999996,5,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(6*$P$23),\"\")","v":22.8},4.0999999999999996]
[null,null,"","","",null,null,5.4,"5-",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(5*$P$23),\"\")","v":23.6},4]
[null,null,"","","",null,null,5.5,"6+",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(4*$P$23),\"\")","v":24.400000000000002},3.9]
[null,null,"","","",null,null,5.6,6,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(3*$P$23),\"\")","v":25.200000000000003},3.8]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(2*$P$23),\"\")","v":26},3.7]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(1*$P$23),\"\")","v":26.8},3.6]
[null,null,"","","",null,null,null,null,null,4,null,{"$f":"ROUND(($A$3*$E$3/100),1)","v":27.6},3.5,null,{"$f":"ROUND((((A3*E3/100)-(A3*F3/100))/10),1)","v":0.8},{"$f":"IF(P23>=0,TRUE,FALSE)","v":true}]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(9*$P$13),\"\")","v":28.6},3.4]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(8*$P$13),\"\")","v":29.2},3.3]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(7*$P$13),\"\")","v":29.8},3.2]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(6*$P$13),\"\")","v":30.4},3.1]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(5*$P$13),\"\")","v":31},3]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(4*$P$13),\"\")","v":31.6},2.9]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(2*$P$13),\"\")","v":32.799999999999997},2.7]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(2*$P$13),\"\")","v":32.799999999999997},2.8]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(1*$P$13),\"\")","v":33.4},2.6]
[null,null,"","","",null,null,null,null,null,3,null,{"$f":"ROUND(($A$3*$D$3/100),1)","v":34},2.5,null,{"$f":"ROUND((((A3*F3/100)-(A3*G3/100))/10),1)","v":1},{"$f":"IF(P33>=0,TRUE,FALSE)","v":true}]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(9*$P$3),\"\")","v":34.700000000000003},2.4]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(8*$P$3),\"\")","v":35.200000000000003},2.2999999999999998]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(7*$P$3),\"\")","v":35.700000000000003},2.2000000000000002]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(6*$P$3),\"\")","v":36.200000000000003},2.1]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(5*$P$3),\"\")","v":36.700000000000003},2]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(4*$P$3),\"\")","v":37.200000000000003},1.9]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(3*$P$3),\"\")","v":37.700000000000003},1.8]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(2*$P$3),\"\")","v":38.200000000000003},1.7]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(1*$P$3),\"\")","v":38.700000000000003},1.6]
[null,null,"","","",null,null,null,null,null,2,null,{"$f":"ROUND(($A$3*$C$3/100),1)","v":39.200000000000003},1.5,null,{"$f":"ROUND((((A3*G3/100)-(0*G3/100))/10),1)","v":1},{"$f":"IF(P43>=0,TRUE,FALSE)","v":true}]
[null,null,"","","",null,null,null,null,null,null,null,{"$f":"ROUND(($A$3*($C$3+1)/100)/5,1)*5","v":39.5},1.4]
[null,null,"","",{"$f":"IF(B45<>\"\",ROUND(VLOOKUP(B45,$M$1:$N$45,2,1),0),\"\")","v":""},null,null,null,null,null,1,null,{"$f":"$A$3","v":40},1]
[null,null,"","",""]

{"sheet":"Arbeit 2","index":1,"n_rows":46,"n_cols":18,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,3],[4,5,4,6],[0,0,0,1],[0,2,0,6],[1,0,1,1],[2,0,2,1],[3,0,3,1],[3,2,3,6]]}
["Settings",null,"Überschrift und Datum eingeben",null,null,null,null,null,null,null,null,null,0,5.7,null,null,{"$f":"IF((A3-(A3*C3/100))>=0,TRUE,FALSE)","v":true}]
["Gesamtpunktzahl",null,"1 bis ...%","2 bis ...%","3 bis ...%","4 bis ...%","5 bis ...%",null,null,null,null,null,{"$f":"IF($Q$43=TRUE,(ROUND(($A$3*$G$3/100),1))-(1*$P$43),\"\")","v":7.1000000000000005},5.6]
[33,null,98,85,69,50,24,null,null,null,6,null,{"$f":"ROUND(($A$3*$G$3/100),1)","v":7.9},5.5,null,{"$f":"ROUND((((A3*C3/100)-(A3*D3/100))/10),1)","v":0.4},{"$f":"IF(P3>=0,TRUE,FALSE)","v":true},{"$f":"IF(B6<>\"\",VLOOKUP(B6,M1:N45,2,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(9*$P$33),\"\")","v":8.4},5.4]
["Name","Punkte","Note",null,null,"Notenspiegel",null,1,1,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(8*$P$33),\"\")","v":9.3000000000000007},5.3]
[{"$f":"IF('Arbeit 1'!A6<>\"\",'Arbeit 1'!A6,\"\")","v":""},null,{"$f":"IF(B6<>\"\",VLOOKUP(D6,$H$5:$I$20,2,1),\"\")","v":""},{"$f":"IF(B6<>\"\",VLOOKUP(B6,$M$1:$N$45,2,1),\"\")","v":""},{"$f":"IF(B6<>\"\",ROUND(VLOOKUP(B6,$M$1:$N$45,2,1),0),\"\")","v":""},"Note","Anzahl",1.4,"1-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(7*$P$33),\"\")","v":10.199999999999999},5.2]
[{"$f":"IF('Arbeit 1'!A7<>\"\",'Arbeit 1'!A7,\"\")","v":""},null,{"$f":"IF(B7<>\"\",VLOOKUP(D7,$H$5:$I$20,2,1),\"\")","v":""},{"$f":"IF(B7<>\"\",VLOOKUP(B7,$M$1:$N$45,2,1),\"\")","v":""},{"$f":"IF(B7<>\"\",ROUND(VLOOKUP(B7,$M$1:$N$45,2,1),0),\"\")","v":""},1,{"$f":"COUNTIF($E$6:$E$46,F7)","v":0},1.5,"2+",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(6*$P$33),\"\")","v":11.1},5.0999999999999996]
[{"$f":"IF('Arbeit 1'!A8<>\"\",'Arbeit 1'!A8,\"\")","v":""},null,"","","",2,{"$f":"COUNTIF($E$6:$E$46,F8)","v":0},1.6,2,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(5*$P$33),\"\")","v":12},5]
[{"$f":"IF('Arbeit 1'!A9<>\"\",'Arbeit 1'!A9,\"\")","v":""},null,"","","",3,0,2.4,"2-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(4*$P$33),\"\")","v":12.9},4.9000000000000004]
[{"$f":"IF('Arbeit 1'!A10<>\"\",'Arbeit 1'!A10,\"\")","v":""},null,"","","",4,0,2.5,"3+",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(3*$P$33),\"\")","v":13.8},4.8]
[{"$f":"IF('Arbeit 1'!A11<>\"\",'Arbeit 1'!A11,\"\")","v":""},null,"","","",5,0,2.6,3,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(2*$P$33),\"\")","v":14.7},4.7]
[{"$f":"IF('Arbeit 1'!A12<>\"\",'Arbeit 1'!A12,\"\")","v":""},null,"","","",6,0,3.4,"3-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(1*$P$33),\"\")","v":15.6},4.5999999999999996]
[{"$f":"IF('Arbeit 1'!A13<>\"\",'Arbeit 1'!A13,\"\")","v":""},null,"","","","ø",{"$f":"IFERROR(ROUND(SUMPRODUCT(F7:F12,G7:G12)/COUNT(E6:E46),2),\"\")","v":""},3.5,"4+",null,5,null,{"$f":"ROUND(($A$3*$F$3/100),1)","v":16.5},4.5,null,{"$f":"ROUND((((A3*D3/100)-(A3*E3/100))/10),1)","v":0.5},{"$f":"IF(P13>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A14<>\"\",'Arbeit 1'!A14,\"\")","v":""},null,"","","",null,null,3.6,4,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(9*$P$23),\"\")","v":17.400000000000002},4.4000000000000004]
[{"$f":"IF('Arbeit 1'!A15<>\"\",'Arbeit 1'!A15,\"\")","v":""},null,"","","",null,null,4.4000000000000004,"4-",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(8*$P$23),\"\")","v":18},4.3]
[{"$f":"IF('Arbeit 1'!A16<>\"\",'Arbeit 1'!A16,\"\")","v":""},null,"","","",null,null,4.5,"5+",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(7*$P$23),\"\")","v":18.600000000000001},4.2]
[{"$f":"IF('Arbeit 1'!A17<>\"\",'Arbeit 1'!A17,\"\")","v":""},null,"","","",null,null,4.5999999999999996,5,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(6*$P$23),\"\")","v":19.200000000000003},4.0999999999999996]
[{"$f":"IF('Arbeit 1'!A18<>\"\",'Arbeit 1'!A18,\"\")","v":""},null,"","","",null,null,5.4,"5-",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(5*$P$23),\"\")","v":19.8},4]
[{"$f":"IF('Arbeit 1'!A19<>\"\",'Arbeit 1'!A19,\"\")","v":""},null,"","","",null,null,5.5,"6+",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(4*$P$23),\"\")","v":20.400000000000002},3.9]
[{"$f":"IF('Arbeit 1'!A20<>\"\",'Arbeit 1'!A20,\"\")","v":""},null,"","","",null,null,5.6,6,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(3*$P$23),\"\")","v":21},3.8]
[{"$f":"IF('Arbeit 1'!A21<>\"\",'Arbeit 1'!A21,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(2*$P$23),\"\")","v":21.6},3.7]
[{"$f":"IF('Arbeit 1'!A22<>\"\",'Arbeit 1'!A22,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(1*$P$23),\"\")","v":22.2},3.6]
[{"$f":"IF('Arbeit 1'!A23<>\"\",'Arbeit 1'!A23,\"\")","v":""},null,"","","",null,null,null,null,null,4,null,{"$f":"ROUND(($A$3*$E$3/100),1)","v":22.8},3.5,null,{"$f":"ROUND((((A3*E3/100)-(A3*F3/100))/10),1)","v":0.6},{"$f":"IF(P23>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A24<>\"\",'Arbeit 1'!A24,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(9*$P$13),\"\")","v":23.6},3.4]
[{"$f":"IF('Arbeit 1'!A25<>\"\",'Arbeit 1'!A25,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(8*$P$13),\"\")","v":24.1},3.3]
[{"$f":"IF('Arbeit 1'!A26<>\"\",'Arbeit 1'!A26,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(7*$P$13),\"\")","v":24.6},3.2]
[{"$f":"IF('Arbeit 1'!A27<>\"\",'Arbeit 1'!A27,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(6*$P$13),\"\")","v":25.1},3.1]
[{"$f":"IF('Arbeit 1'!A28<>\"\",'Arbeit 1'!A28,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(5*$P$13),\"\")","v":25.6},3]
[{"$f":"IF('Arbeit 1'!A29<>\"\",'Arbeit 1'!A29,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(4*$P$13),\"\")","v":26.1},2.9]
[{"$f":"IF('Arbeit 1'!A30<>\"\",'Arbeit 1'!A30,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(2*$P$13),\"\")","v":27.1},2.7]
[{"$f":"IF('Arbeit 1'!A31<>\"\",'Arbeit 1'!A31,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(2*$P$13),\"\")","v":27.1},2.8]
[{"$f":"IF('Arbeit 1'!A32<>\"\",'Arbeit 1'!A32,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(1*$P$13),\"\")","v":27.6},2.6]
[{"$f":"IF('Arbeit 1'!A33<>\"\",'Arbeit 1'!A33,\"\")","v":""},null,"","","",null,null,null,null,null,3,null,{"$f":"ROUND(($A$3*$D$3/100),1)","v":28.1},2.5,null,{"$f":"ROUND((((A3*F3/100)-(A3*G3/100))/10),1)","v":0.9},{"$f":"IF(P33>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A34<>\"\",'Arbeit 1'!A34,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(9*$P$3),\"\")","v":28.699999999999996},2.4]
[{"$f":"IF('Arbeit 1'!A35<>\"\",'Arbeit 1'!A35,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(8*$P$3),\"\")","v":29.099999999999998},2.2999999999999998]
[{"$f":"IF('Arbeit 1'!A36<>\"\",'Arbeit 1'!A36,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(7*$P$3),\"\")","v":29.499999999999996},2.2000000000000002]
[{"$f":"IF('Arbeit 1'!A37<>\"\",'Arbeit 1'!A37,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(6*$P$3),\"\")","v":29.9},2.1]
[{"$f":"IF('Arbeit 1'!A38<>\"\",'Arbeit 1'!A38,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(5*$P$3),\"\")","v":30.299999999999997},2]
[{"$f":"IF('Arbeit 1'!A39<>\"\",'Arbeit 1'!A39,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(4*$P$3),\"\")","v":30.699999999999996},1.9]
[{"$f":"IF('Arbeit 1'!A40<>\"\",'Arbeit 1'!A40,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(3*$P$3),\"\")","v":31.099999999999998},1.8]
[{"$f":"IF('Arbeit 1'!A41<>\"\",'Arbeit 1'!A41,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(2*$P$3),\"\")","v":31.499999999999996},1.7]
[{"$f":"IF('Arbeit 1'!A42<>\"\",'Arbeit 1'!A42,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(1*$P$3),\"\")","v":31.9},1.6]
[{"$f":"IF('Arbeit 1'!A43<>\"\",'Arbeit 1'!A43,\"\")","v":""},null,"","","",null,null,null,null,null,2,null,{"$f":"ROUND(($A$3*$C$3/100),1)","v":32.299999999999997},1.5,null,{"$f":"ROUND((((A3*G3/100)-(0*G3/100))/10),1)","v":0.8},{"$f":"IF(P43>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A44<>\"\",'Arbeit 1'!A44,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"ROUND(($A$3*($C$3+1)/100)/5,1)*5","v":32.5},1.4]
[{"$f":"IF('Arbeit 1'!A45<>\"\",'Arbeit 1'!A45,\"\")","v":""},null,"","",{"$f":"IF(B45<>\"\",ROUND(VLOOKUP(B45,$M$1:$N$45,2,1),0),\"\")","v":""},null,null,null,null,null,1,null,{"$f":"$A$3","v":33},1]
[{"$f":"IF('Arbeit 1'!A46<>\"\",'Arbeit 1'!A46,\"\")","v":""},null,"","",""]

{"sheet":"Arbeit 3","index":2,"n_rows":46,"n_cols":18,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,3],[4,5,4,6],[0,0,0,1],[0,2,0,6],[1,0,1,1],[2,0,2,1],[3,0,3,1],[3,2,3,6]]}
["Settings",null,"Überschrift und Datum eingeben",null,null,null,null,null,null,null,null,null,0,5.7,null,null,{"$f":"IF((A3-(A3*C3/100))>=0,TRUE,FALSE)","v":true}]
["Gesamtpunktzahl",null,"1 bis ...%","2 bis ...%","3 bis ...%","4 bis ...%","5 bis ...%",null,null,null,null,null,{"$f":"IF($Q$43=TRUE,(ROUND(($A$3*$G$3/100),1))-(1*$P$43),\"\")","v":11.899999999999999},5.6]
[55,null,98,85,69,50,24,null,null,null,6,null,{"$f":"ROUND(($A$3*$G$3/100),1)","v":13.2},5.5,null,{"$f":"ROUND((((A3*C3/100)-(A3*D3/100))/10),1)","v":0.7},{"$f":"IF(P3>=0,TRUE,FALSE)","v":true},{"$f":"IF(B6<>\"\",VLOOKUP(B6,M1:N45,2,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(9*$P$33),\"\")","v":14.9},5.4]
["Name","Punkte","Note",null,null,"Notenspiegel",null,1,1,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(8*$P$33),\"\")","v":16.3},5.3]
[{"$f":"IF('Arbeit 1'!A6<>\"\",'Arbeit 1'!A6,\"\")","v":""},null,{"$f":"IF(B6<>\"\",VLOOKUP(D6,$H$5:$I$20,2,1),\"\")","v":""},{"$f":"IF(B6<>\"\",VLOOKUP(B6,$M$1:$N$45,2,1),\"\")","v":""},{"$f":"IF(B6<>\"\",ROUND(VLOOKUP(B6,$M$1:$N$45,2,1),0),\"\")","v":""},"Note","Anzahl",1.4,"1-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(7*$P$33),\"\")","v":17.700000000000003},5.2]
[{"$f":"IF('Arbeit 1'!A7<>\"\",'Arbeit 1'!A7,\"\")","v":""},null,{"$f":"IF(B7<>\"\",VLOOKUP(D7,$H$5:$I$20,2,1),\"\")","v":""},{"$f":"IF(B7<>\"\",VLOOKUP(B7,$M$1:$N$45,2,1),\"\")","v":""},{"$f":"IF(B7<>\"\",ROUND(VLOOKUP(B7,$M$1:$N$45,2,1),0),\"\")","v":""},1,{"$f":"COUNTIF($E$6:$E$46,F7)","v":0},1.5,"2+",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(6*$P$33),\"\")","v":19.100000000000001},5.0999999999999996]
[{"$f":"IF('Arbeit 1'!A8<>\"\",'Arbeit 1'!A8,\"\")","v":""},null,"","","",2,{"$f":"COUNTIF($E$6:$E$46,F8)","v":0},1.6,2,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(5*$P$33),\"\")","v":20.5},5]
[{"$f":"IF('Arbeit 1'!A9<>\"\",'Arbeit 1'!A9,\"\")","v":""},null,"","","",3,0,2.4,"2-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(4*$P$33),\"\")","v":21.9},4.9000000000000004]
[{"$f":"IF('Arbeit 1'!A10<>\"\",'Arbeit 1'!A10,\"\")","v":""},null,"","","",4,0,2.5,"3+",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(3*$P$33),\"\")","v":23.3},4.8]
[{"$f":"IF('Arbeit 1'!A11<>\"\",'Arbeit 1'!A11,\"\")","v":""},null,"","","",5,0,2.6,3,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(2*$P$33),\"\")","v":24.7},4.7]
[{"$f":"IF('Arbeit 1'!A12<>\"\",'Arbeit 1'!A12,\"\")","v":""},null,"","","",6,0,3.4,"3-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(1*$P$33),\"\")","v":26.1},4.5999999999999996]
[{"$f":"IF('Arbeit 1'!A13<>\"\",'Arbeit 1'!A13,\"\")","v":""},null,"","","","ø",{"$f":"IFERROR(ROUND(SUMPRODUCT(F7:F12,G7:G12)/COUNT(E6:E46),2),\"\")","v":""},3.5,"4+",null,5,null,{"$f":"ROUND(($A$3*$F$3/100),1)","v":27.5},4.5,null,{"$f":"ROUND((((A3*D3/100)-(A3*E3/100))/10),1)","v":0.9},{"$f":"IF(P13>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A14<>\"\",'Arbeit 1'!A14,\"\")","v":""},null,"","","",null,null,3.6,4,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(9*$P$23),\"\")","v":29},4.4000000000000004]
[{"$f":"IF('Arbeit 1'!A15<>\"\",'Arbeit 1'!A15,\"\")","v":""},null,"","","",null,null,4.4000000000000004,"4-",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(8*$P$23),\"\")","v":30},4.3]
[{"$f":"IF('Arbeit 1'!A16<>\"\",'Arbeit 1'!A16,\"\")","v":""},null,"","","",null,null,4.5,"5+",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(7*$P$23),\"\")","v":31},4.2]
[{"$f":"IF('Arbeit 1'!A17<>\"\",'Arbeit 1'!A17,\"\")","v":""},null,"","","",null,null,4.5999999999999996,5,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(6*$P$23),\"\")","v":32},4.0999999999999996]
[{"$f":"IF('Arbeit 1'!A18<>\"\",'Arbeit 1'!A18,\"\")","v":""},null,"","","",null,null,5.4,"5-",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(5*$P$23),\"\")","v":33},4]
[{"$f":"IF('Arbeit 1'!A19<>\"\",'Arbeit 1'!A19,\"\")","v":""},null,"","","",null,null,5.5,"6+",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(4*$P$23),\"\")","v":34},3.9]
[{"$f":"IF('Arbeit 1'!A20<>\"\",'Arbeit 1'!A20,\"\")","v":""},null,"","","",null,null,5.6,6,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(3*$P$23),\"\")","v":35},3.8]
[{"$f":"IF('Arbeit 1'!A21<>\"\",'Arbeit 1'!A21,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(2*$P$23),\"\")","v":36},3.7]
[{"$f":"IF('Arbeit 1'!A22<>\"\",'Arbeit 1'!A22,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(1*$P$23),\"\")","v":37},3.6]
[{"$f":"IF('Arbeit 1'!A23<>\"\",'Arbeit 1'!A23,\"\")","v":""},null,"","","",null,null,null,null,null,4,null,{"$f":"ROUND(($A$3*$E$3/100),1)","v":38},3.5,null,{"$f":"ROUND((((A3*E3/100)-(A3*F3/100))/10),1)","v":1},{"$f":"IF(P23>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A24<>\"\",'Arbeit 1'!A24,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(9*$P$13),\"\")","v":38.699999999999996},3.4]
[{"$f":"IF('Arbeit 1'!A25<>\"\",'Arbeit 1'!A25,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(8*$P$13),\"\")","v":39.599999999999994},3.3]
[{"$f":"IF('Arbeit 1'!A26<>\"\",'Arbeit 1'!A26,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(7*$P$13),\"\")","v":40.5},3.2]
[{"$f":"IF('Arbeit 1'!A27<>\"\",'Arbeit 1'!A27,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(6*$P$13),\"\")","v":41.4},3.1]
[{"$f":"IF('Arbeit 1'!A28<>\"\",'Arbeit 1'!A28,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(5*$P$13),\"\")","v":42.3},3]
[{"$f":"IF('Arbeit 1'!A29<>\"\",'Arbeit 1'!A29,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(4*$P$13),\"\")","v":43.199999999999996},2.9]
[{"$f":"IF('Arbeit 1'!A30<>\"\",'Arbeit 1'!A30,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(2*$P$13),\"\")","v":45},2.7]
[{"$f":"IF('Arbeit 1'!A31<>\"\",'Arbeit 1'!A31,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(2*$P$13),\"\")","v":45},2.8]
[{"$f":"IF('Arbeit 1'!A32<>\"\",'Arbeit 1'!A32,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(1*$P$13),\"\")","v":45.9},2.6]
[{"$f":"IF('Arbeit 1'!A33<>\"\",'Arbeit 1'!A33,\"\")","v":""},null,"","","",null,null,null,null,null,3,null,{"$f":"ROUND(($A$3*$D$3/100),1)","v":46.8},2.5,null,{"$f":"ROUND((((A3*F3/100)-(A3*G3/100))/10),1)","v":1.4},{"$f":"IF(P33>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A34<>\"\",'Arbeit 1'!A34,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(9*$P$3),\"\")","v":47.6},2.4]
[{"$f":"IF('Arbeit 1'!A35<>\"\",'Arbeit 1'!A35,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(8*$P$3),\"\")","v":48.3},2.2999999999999998]
[{"$f":"IF('Arbeit 1'!A36<>\"\",'Arbeit 1'!A36,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(7*$P$3),\"\")","v":49},2.2000000000000002]
[{"$f":"IF('Arbeit 1'!A37<>\"\",'Arbeit 1'!A37,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(6*$P$3),\"\")","v":49.7},2.1]
[{"$f":"IF('Arbeit 1'!A38<>\"\",'Arbeit 1'!A38,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(5*$P$3),\"\")","v":50.4},2]
[{"$f":"IF('Arbeit 1'!A39<>\"\",'Arbeit 1'!A39,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(4*$P$3),\"\")","v":51.1},1.9]
[{"$f":"IF('Arbeit 1'!A40<>\"\",'Arbeit 1'!A40,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(3*$P$3),\"\")","v":51.8},1.8]
[{"$f":"IF('Arbeit 1'!A41<>\"\",'Arbeit 1'!A41,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(2*$P$3),\"\")","v":52.5},1.7]
[{"$f":"IF('Arbeit 1'!A42<>\"\",'Arbeit 1'!A42,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(1*$P$3),\"\")","v":53.199999999999996},1.6]
[{"$f":"IF('Arbeit 1'!A43<>\"\",'Arbeit 1'!A43,\"\")","v":""},null,"","","",null,null,null,null,null,2,null,{"$f":"ROUND(($A$3*$C$3/100),1)","v":53.9},1.5,null,{"$f":"ROUND((((A3*G3/100)-(0*G3/100))/10),1)","v":1.3},{"$f":"IF(P43>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A44<>\"\",'Arbeit 1'!A44,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"ROUND(($A$3*($C$3+1)/100)/5,1)*5","v":54.5},1.4]
[{"$f":"IF('Arbeit 1'!A45<>\"\",'Arbeit 1'!A45,\"\")","v":""},null,"","",{"$f":"IF(B45<>\"\",ROUND(VLOOKUP(B45,$M$1:$N$45,2,1),0),\"\")","v":""},null,null,null,null,null,1,null,{"$f":"$A$3","v":55},1]
[{"$f":"IF('Arbeit 1'!A46<>\"\",'Arbeit 1'!A46,\"\")","v":""},null,"","",""]

{"sheet":"Arbeit 4","index":3,"n_rows":46,"n_cols":18,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,3],[4,5,4,6],[0,0,0,1],[0,2,0,6],[1,0,1,1],[2,0,2,1],[3,0,3,1],[3,2,3,6]]}
["Settings",null,"Überschrift und Datum eingeben",null,null,null,null,null,null,null,null,null,0,5.7,null,null,{"$f":"IF((A3-(A3*C3/100))>=0,TRUE,FALSE)","v":true}]
["Gesamtpunktzahl",null,"1 bis ...%","2 bis ...%","3 bis ...%","4 bis ...%","5 bis ...%",null,null,null,null,null,{"$f":"IF($Q$43=TRUE,(ROUND(($A$3*$G$3/100),1))-(1*$P$43),\"\")","v":7.1000000000000005},5.6]
[33,null,98,85,69,50,24,null,null,null,6,null,{"$f":"ROUND(($A$3*$G$3/100),1)","v":7.9},5.5,null,{"$f":"ROUND((((A3*C3/100)-(A3*D3/100))/10),1)","v":0.4},{"$f":"IF(P3>=0,TRUE,FALSE)","v":true},{"$f":"IF(B6<>\"\",VLOOKUP(B6,M1:N45,2,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(9*$P$33),\"\")","v":8.4},5.4]
["Name","Punkte","Note",null,null,"Notenspiegel",null,1,1,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(8*$P$33),\"\")","v":9.3000000000000007},5.3]
[{"$f":"IF('Arbeit 1'!A6<>\"\",'Arbeit 1'!A6,\"\")","v":""},null,{"$f":"IF(B6<>\"\",VLOOKUP(D6,$H$5:$I$20,2,1),\"\")","v":""},{"$f":"IF(B6<>\"\",VLOOKUP(B6,$M$1:$N$45,2,1),\"\")","v":""},{"$f":"IF(B6<>\"\",ROUND(VLOOKUP(B6,$M$1:$N$45,2,1),0),\"\")","v":""},"Note","Anzahl",1.4,"1-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(7*$P$33),\"\")","v":10.199999999999999},5.2]
[{"$f":"IF('Arbeit 1'!A7<>\"\",'Arbeit 1'!A7,\"\")","v":""},null,{"$f":"IF(B7<>\"\",VLOOKUP(D7,$H$5:$I$20,2,1),\"\")","v":""},{"$f":"IF(B7<>\"\",VLOOKUP(B7,$M$1:$N$45,2,1),\"\")","v":""},{"$f":"IF(B7<>\"\",ROUND(VLOOKUP(B7,$M$1:$N$45,2,1),0),\"\")","v":""},1,{"$f":"COUNTIF($E$6:$E$46,F7)","v":0},1.5,"2+",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(6*$P$33),\"\")","v":11.1},5.0999999999999996]
[{"$f":"IF('Arbeit 1'!A8<>\"\",'Arbeit 1'!A8,\"\")","v":""},null,"","","",2,{"$f":"COUNTIF($E$6:$E$46,F8)","v":0},1.6,2,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(5*$P$33),\"\")","v":12},5]
[{"$f":"IF('Arbeit 1'!A9<>\"\",'Arbeit 1'!A9,\"\")","v":""},null,"","","",3,0,2.4,"2-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(4*$P$33),\"\")","v":12.9},4.9000000000000004]
[{"$f":"IF('Arbeit 1'!A10<>\"\",'Arbeit 1'!A10,\"\")","v":""},null,"","","",4,0,2.5,"3+",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(3*$P$33),\"\")","v":13.8},4.8]
[{"$f":"IF('Arbeit 1'!A11<>\"\",'Arbeit 1'!A11,\"\")","v":""},null,"","","",5,0,2.6,3,null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(2*$P$33),\"\")","v":14.7},4.7]
[{"$f":"IF('Arbeit 1'!A12<>\"\",'Arbeit 1'!A12,\"\")","v":""},null,"","","",6,0,3.4,"3-",null,null,null,{"$f":"IF($Q$33=TRUE,(ROUND(($A$3*$F$3/100),1))-(1*$P$33),\"\")","v":15.6},4.5999999999999996]
[{"$f":"IF('Arbeit 1'!A13<>\"\",'Arbeit 1'!A13,\"\")","v":""},null,"","","","ø",{"$f":"IFERROR(ROUND(SUMPRODUCT(F7:F12,G7:G12)/COUNT(E6:E46),2),\"\")","v":""},3.5,"4+",null,5,null,{"$f":"ROUND(($A$3*$F$3/100),1)","v":16.5},4.5,null,{"$f":"ROUND((((A3*D3/100)-(A3*E3/100))/10),1)","v":0.5},{"$f":"IF(P13>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A14<>\"\",'Arbeit 1'!A14,\"\")","v":""},null,"","","",null,null,3.6,4,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(9*$P$23),\"\")","v":17.400000000000002},4.4000000000000004]
[{"$f":"IF('Arbeit 1'!A15<>\"\",'Arbeit 1'!A15,\"\")","v":""},null,"","","",null,null,4.4000000000000004,"4-",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(8*$P$23),\"\")","v":18},4.3]
[{"$f":"IF('Arbeit 1'!A16<>\"\",'Arbeit 1'!A16,\"\")","v":""},null,"","","",null,null,4.5,"5+",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(7*$P$23),\"\")","v":18.600000000000001},4.2]
[{"$f":"IF('Arbeit 1'!A17<>\"\",'Arbeit 1'!A17,\"\")","v":""},null,"","","",null,null,4.5999999999999996,5,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(6*$P$23),\"\")","v":19.200000000000003},4.0999999999999996]
[{"$f":"IF('Arbeit 1'!A18<>\"\",'Arbeit 1'!A18,\"\")","v":""},null,"","","",null,null,5.4,"5-",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(5*$P$23),\"\")","v":19.8},4]
[{"$f":"IF('Arbeit 1'!A19<>\"\",'Arbeit 1'!A19,\"\")","v":""},null,"","","",null,null,5.5,"6+",null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(4*$P$23),\"\")","v":20.400000000000002},3.9]
[{"$f":"IF('Arbeit 1'!A20<>\"\",'Arbeit 1'!A20,\"\")","v":""},null,"","","",null,null,5.6,6,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(3*$P$23),\"\")","v":21},3.8]
[{"$f":"IF('Arbeit 1'!A21<>\"\",'Arbeit 1'!A21,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(2*$P$23),\"\")","v":21.6},3.7]
[{"$f":"IF('Arbeit 1'!A22<>\"\",'Arbeit 1'!A22,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$23=TRUE,(ROUND(($A$3*$E$3/100),1))-(1*$P$23),\"\")","v":22.2},3.6]
[{"$f":"IF('Arbeit 1'!A23<>\"\",'Arbeit 1'!A23,\"\")","v":""},null,"","","",null,null,null,null,null,4,null,{"$f":"ROUND(($A$3*$E$3/100),1)","v":22.8},3.5,null,{"$f":"ROUND((((A3*E3/100)-(A3*F3/100))/10),1)","v":0.6},{"$f":"IF(P23>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A24<>\"\",'Arbeit 1'!A24,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(9*$P$13),\"\")","v":23.6},3.4]
[{"$f":"IF('Arbeit 1'!A25<>\"\",'Arbeit 1'!A25,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(8*$P$13),\"\")","v":24.1},3.3]
[{"$f":"IF('Arbeit 1'!A26<>\"\",'Arbeit 1'!A26,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(7*$P$13),\"\")","v":24.6},3.2]
[{"$f":"IF('Arbeit 1'!A27<>\"\",'Arbeit 1'!A27,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(6*$P$13),\"\")","v":25.1},3.1]
[{"$f":"IF('Arbeit 1'!A28<>\"\",'Arbeit 1'!A28,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(5*$P$13),\"\")","v":25.6},3]
[{"$f":"IF('Arbeit 1'!A29<>\"\",'Arbeit 1'!A29,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(4*$P$13),\"\")","v":26.1},2.9]
[{"$f":"IF('Arbeit 1'!A30<>\"\",'Arbeit 1'!A30,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(2*$P$13),\"\")","v":27.1},2.7]
[{"$f":"IF('Arbeit 1'!A31<>\"\",'Arbeit 1'!A31,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(2*$P$13),\"\")","v":27.1},2.8]
[{"$f":"IF('Arbeit 1'!A32<>\"\",'Arbeit 1'!A32,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$13=TRUE,(ROUND(($A$3*$D$3/100),1))-(1*$P$13),\"\")","v":27.6},2.6]
[{"$f":"IF('Arbeit 1'!A33<>\"\",'Arbeit 1'!A33,\"\")","v":""},null,"","","",null,null,null,null,null,3,null,{"$f":"ROUND(($A$3*$D$3/100),1)","v":28.1},2.5,null,{"$f":"ROUND((((A3*F3/100)-(A3*G3/100))/10),1)","v":0.9},{"$f":"IF(P33>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A34<>\"\",'Arbeit 1'!A34,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(9*$P$3),\"\")","v":28.699999999999996},2.4]
[{"$f":"IF('Arbeit 1'!A35<>\"\",'Arbeit 1'!A35,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(8*$P$3),\"\")","v":29.099999999999998},2.2999999999999998]
[{"$f":"IF('Arbeit 1'!A36<>\"\",'Arbeit 1'!A36,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(7*$P$3),\"\")","v":29.499999999999996},2.2000000000000002]
[{"$f":"IF('Arbeit 1'!A37<>\"\",'Arbeit 1'!A37,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(6*$P$3),\"\")","v":29.9},2.1]
[{"$f":"IF('Arbeit 1'!A38<>\"\",'Arbeit 1'!A38,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(5*$P$3),\"\")","v":30.299999999999997},2]
[{"$f":"IF('Arbeit 1'!A39<>\"\",'Arbeit 1'!A39,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(4*$P$3),\"\")","v":30.699999999999996},1.9]
[{"$f":"IF('Arbeit 1'!A40<>\"\",'Arbeit 1'!A40,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(3*$P$3),\"\")","v":31.099999999999998},1.8]
[{"$f":"IF('Arbeit 1'!A41<>\"\",'Arbeit 1'!A41,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(2*$P$3),\"\")","v":31.499999999999996},1.7]
[{"$f":"IF('Arbeit 1'!A42<>\"\",'Arbeit 1'!A42,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"IF($Q$3=TRUE,(ROUND(($A$3*$C$3/100),1))-(1*$P$3),\"\")","v":31.9},1.6]
[{"$f":"IF('Arbeit 1'!A43<>\"\",'Arbeit 1'!A43,\"\")","v":""},null,"","","",null,null,null,null,null,2,null,{"$f":"ROUND(($A$3*$C$3/100),1)","v":32.299999999999997},1.5,null,{"$f":"ROUND((((A3*G3/100)-(0*G3/100))/10),1)","v":0.8},{"$f":"IF(P43>=0,TRUE,FALSE)","v":true}]
[{"$f":"IF('Arbeit 1'!A44<>\"\",'Arbeit 1'!A44,\"\")","v":""},null,"","","",null,null,null,null,null,null,null,{"$f":"ROUND(($A$3*($C$3+1)/100)/5,1)*5","v":32.5},1.4]
[{"$f":"IF('Arbeit 1'!A45<>\"\",'Arbeit 1'!A45,\"\")","v":""},null,"","",{"$f":"IF(B45<>\"\",ROUND(VLOOKUP(B45,$M$1:$N$45,2,1),0),\"\")","v":""},null,null,null,null,null,1,null,{"$f":"$A$3","v":33},1]
[{"$f":"IF('Arbeit 1'!A46<>\"\",'Arbeit 1'!A46,\"\")","v":""},null,"","",""]

{"sheet":"Auswertung","index":4,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,6,47,7],[42,6,42,7],[43,6,43,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[41,6,41,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[36,6,36,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[31,6,31,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[7,6,7,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[6,6,6,7]]}
["Auswertung"]
[]
["Name","Arbeit 1","Arbeit 2","Arbeit 3","Arbeit 4","ø","Note"]
[{"$f":"IF('Arbeit 1'!A6<>\"\",'Arbeit 1'!A6,\"\")","v":""},{"$f":"IF('Arbeit 1'!D6<>\"\",('Arbeit 1'!D6)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D6<>\"\",('Arbeit 2'!D6)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D6<>\"\",('Arbeit 3'!D6)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D6<>\"\",('Arbeit 4'!D6)*1,\"\")","v":""},{"$f":"IFERROR(ROUND(AVERAGE(B4:E4),1),\"\")","v":""},{"$f":"IF(F4<>\"\",VLOOKUP(F4,$J$5:$K$20,2,1),\"\")","v":""}]
[{"$f":"IF('Arbeit 1'!A7<>\"\",'Arbeit 1'!A7,\"\")","v":""},{"$f":"IF('Arbeit 1'!D7<>\"\",('Arbeit 1'!D7)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D7<>\"\",('Arbeit 2'!D7)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D7<>\"\",('Arbeit 3'!D7)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D7<>\"\",('Arbeit 4'!D7)*1,\"\")","v":""},"",{"$f":"IF(F5<>\"\",VLOOKUP(F5,$J$5:$K$20,2,1),\"\")","v":""},null,null,1,1]
[{"$f":"IF('Arbeit 1'!A8<>\"\",'Arbeit 1'!A8,\"\")","v":""},{"$f":"IF('Arbeit 1'!D8<>\"\",('Arbeit 1'!D8)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D8<>\"\",('Arbeit 2'!D8)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D8<>\"\",('Arbeit 3'!D8)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D8<>\"\",('Arbeit 4'!D8)*1,\"\")","v":""},"","",null,null,1.4,"1-"]
[{"$f":"IF('Arbeit 1'!A9<>\"\",'Arbeit 1'!A9,\"\")","v":""},{"$f":"IF('Arbeit 1'!D9<>\"\",('Arbeit 1'!D9)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D9<>\"\",('Arbeit 2'!D9)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D9<>\"\",('Arbeit 3'!D9)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D9<>\"\",('Arbeit 4'!D9)*1,\"\")","v":""},"","",null,null,1.5,"2+"]
[{"$f":"IF('Arbeit 1'!A10<>\"\",'Arbeit 1'!A10,\"\")","v":""},{"$f":"IF('Arbeit 1'!D10<>\"\",('Arbeit 1'!D10)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D10<>\"\",('Arbeit 2'!D10)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D10<>\"\",('Arbeit 3'!D10)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D10<>\"\",('Arbeit 4'!D10)*1,\"\")","v":""},"","",null,null,1.6,2]
[{"$f":"IF('Arbeit 1'!A11<>\"\",'Arbeit 1'!A11,\"\")","v":""},{"$f":"IF('Arbeit 1'!D11<>\"\",('Arbeit 1'!D11)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D11<>\"\",('Arbeit 2'!D11)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D11<>\"\",('Arbeit 3'!D11)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D11<>\"\",('Arbeit 4'!D11)*1,\"\")","v":""},"","",null,null,2.4,"2-"]
[{"$f":"IF('Arbeit 1'!A12<>\"\",'Arbeit 1'!A12,\"\")","v":""},{"$f":"IF('Arbeit 1'!D12<>\"\",('Arbeit 1'!D12)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D12<>\"\",('Arbeit 2'!D12)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D12<>\"\",('Arbeit 3'!D12)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D12<>\"\",('Arbeit 4'!D12)*1,\"\")","v":""},"","",null,null,2.5,"3+"]
[{"$f":"IF('Arbeit 1'!A13<>\"\",'Arbeit 1'!A13,\"\")","v":""},{"$f":"IF('Arbeit 1'!D13<>\"\",('Arbeit 1'!D13)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D13<>\"\",('Arbeit 2'!D13)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D13<>\"\",('Arbeit 3'!D13)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D13<>\"\",('Arbeit 4'!D13)*1,\"\")","v":""},"","",null,null,2.6,3]
[{"$f":"IF('Arbeit 1'!A14<>\"\",'Arbeit 1'!A14,\"\")","v":""},{"$f":"IF('Arbeit 1'!D14<>\"\",('Arbeit 1'!D14)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D14<>\"\",('Arbeit 2'!D14)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D14<>\"\",('Arbeit 3'!D14)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D14<>\"\",('Arbeit 4'!D14)*1,\"\")","v":""},"","",null,null,3.4,"3-"]
[{"$f":"IF('Arbeit 1'!A15<>\"\",'Arbeit 1'!A15,\"\")","v":""},{"$f":"IF('Arbeit 1'!D15<>\"\",('Arbeit 1'!D15)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D15<>\"\",('Arbeit 2'!D15)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D15<>\"\",('Arbeit 3'!D15)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D15<>\"\",('Arbeit 4'!D15)*1,\"\")","v":""},"","",null,null,3.5,"4+"]
[{"$f":"IF('Arbeit 1'!A16<>\"\",'Arbeit 1'!A16,\"\")","v":""},{"$f":"IF('Arbeit 1'!D16<>\"\",('Arbeit 1'!D16)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D16<>\"\",('Arbeit 2'!D16)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D16<>\"\",('Arbeit 3'!D16)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D16<>\"\",('Arbeit 4'!D16)*1,\"\")","v":""},"","",null,null,3.6,4]
[{"$f":"IF('Arbeit 1'!A17<>\"\",'Arbeit 1'!A17,\"\")","v":""},{"$f":"IF('Arbeit 1'!D17<>\"\",('Arbeit 1'!D17)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D17<>\"\",('Arbeit 2'!D17)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D17<>\"\",('Arbeit 3'!D17)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D17<>\"\",('Arbeit 4'!D17)*1,\"\")","v":""},"","",null,null,4.4000000000000004,"4-"]
[{"$f":"IF('Arbeit 1'!A18<>\"\",'Arbeit 1'!A18,\"\")","v":""},{"$f":"IF('Arbeit 1'!D18<>\"\",('Arbeit 1'!D18)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D18<>\"\",('Arbeit 2'!D18)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D18<>\"\",('Arbeit 3'!D18)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D18<>\"\",('Arbeit 4'!D18)*1,\"\")","v":""},"","",null,null,4.5,"5+"]
[{"$f":"IF('Arbeit 1'!A19<>\"\",'Arbeit 1'!A19,\"\")","v":""},{"$f":"IF('Arbeit 1'!D19<>\"\",('Arbeit 1'!D19)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D19<>\"\",('Arbeit 2'!D19)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D19<>\"\",('Arbeit 3'!D19)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D19<>\"\",('Arbeit 4'!D19)*1,\"\")","v":""},"","",null,null,4.5999999999999996,5]
[{"$f":"IF('Arbeit 1'!A20<>\"\",'Arbeit 1'!A20,\"\")","v":""},{"$f":"IF('Arbeit 1'!D20<>\"\",('Arbeit 1'!D20)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D20<>\"\",('Arbeit 2'!D20)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D20<>\"\",('Arbeit 3'!D20)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D20<>\"\",('Arbeit 4'!D20)*1,\"\")","v":""},"","",null,null,5.4,"5-"]
[{"$f":"IF('Arbeit 1'!A21<>\"\",'Arbeit 1'!A21,\"\")","v":""},{"$f":"IF('Arbeit 1'!D21<>\"\",('Arbeit 1'!D21)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D21<>\"\",('Arbeit 2'!D21)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D21<>\"\",('Arbeit 3'!D21)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D21<>\"\",('Arbeit 4'!D21)*1,\"\")","v":""},"","",null,null,5.5,"6+"]
[{"$f":"IF('Arbeit 1'!A22<>\"\",'Arbeit 1'!A22,\"\")","v":""},{"$f":"IF('Arbeit 1'!D22<>\"\",('Arbeit 1'!D22)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D22<>\"\",('Arbeit 2'!D22)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D22<>\"\",('Arbeit 3'!D22)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D22<>\"\",('Arbeit 4'!D22)*1,\"\")","v":""},"","",null,null,5.6,6]
[{"$f":"IF('Arbeit 1'!A23<>\"\",'Arbeit 1'!A23,\"\")","v":""},{"$f":"IF('Arbeit 1'!D23<>\"\",('Arbeit 1'!D23)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D23<>\"\",('Arbeit 2'!D23)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D23<>\"\",('Arbeit 3'!D23)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D23<>\"\",('Arbeit 4'!D23)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A24<>\"\",'Arbeit 1'!A24,\"\")","v":""},{"$f":"IF('Arbeit 1'!D24<>\"\",('Arbeit 1'!D24)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D24<>\"\",('Arbeit 2'!D24)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D24<>\"\",('Arbeit 3'!D24)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D24<>\"\",('Arbeit 4'!D24)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A25<>\"\",'Arbeit 1'!A25,\"\")","v":""},{"$f":"IF('Arbeit 1'!D25<>\"\",('Arbeit 1'!D25)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D25<>\"\",('Arbeit 2'!D25)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D25<>\"\",('Arbeit 3'!D25)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D25<>\"\",('Arbeit 4'!D25)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A26<>\"\",'Arbeit 1'!A26,\"\")","v":""},{"$f":"IF('Arbeit 1'!D26<>\"\",('Arbeit 1'!D26)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D26<>\"\",('Arbeit 2'!D26)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D26<>\"\",('Arbeit 3'!D26)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D26<>\"\",('Arbeit 4'!D26)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A27<>\"\",'Arbeit 1'!A27,\"\")","v":""},{"$f":"IF('Arbeit 1'!D27<>\"\",('Arbeit 1'!D27)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D27<>\"\",('Arbeit 2'!D27)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D27<>\"\",('Arbeit 3'!D27)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D27<>\"\",('Arbeit 4'!D27)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A28<>\"\",'Arbeit 1'!A28,\"\")","v":""},{"$f":"IF('Arbeit 1'!D28<>\"\",('Arbeit 1'!D28)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D28<>\"\",('Arbeit 2'!D28)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D28<>\"\",('Arbeit 3'!D28)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D28<>\"\",('Arbeit 4'!D28)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A29<>\"\",'Arbeit 1'!A29,\"\")","v":""},{"$f":"IF('Arbeit 1'!D29<>\"\",('Arbeit 1'!D29)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D29<>\"\",('Arbeit 2'!D29)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D29<>\"\",('Arbeit 3'!D29)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D29<>\"\",('Arbeit 4'!D29)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A30<>\"\",'Arbeit 1'!A30,\"\")","v":""},{"$f":"IF('Arbeit 1'!D30<>\"\",('Arbeit 1'!D30)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D30<>\"\",('Arbeit 2'!D30)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D30<>\"\",('Arbeit 3'!D30)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D30<>\"\",('Arbeit 4'!D30)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A31<>\"\",'Arbeit 1'!A31,\"\")","v":""},{"$f":"IF('Arbeit 1'!D31<>\"\",('Arbeit 1'!D31)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D31<>\"\",('Arbeit 2'!D31)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D31<>\"\",('Arbeit 3'!D31)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D31<>\"\",('Arbeit 4'!D31)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A32<>\"\",'Arbeit 1'!A32,\"\")","v":""},{"$f":"IF('Arbeit 1'!D32<>\"\",('Arbeit 1'!D32)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D32<>\"\",('Arbeit 2'!D32)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D32<>\"\",('Arbeit 3'!D32)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D32<>\"\",('Arbeit 4'!D32)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A33<>\"\",'Arbeit 1'!A33,\"\")","v":""},{"$f":"IF('Arbeit 1'!D33<>\"\",('Arbeit 1'!D33)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D33<>\"\",('Arbeit 2'!D33)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D33<>\"\",('Arbeit 3'!D33)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D33<>\"\",('Arbeit 4'!D33)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A34<>\"\",'Arbeit 1'!A34,\"\")","v":""},{"$f":"IF('Arbeit 1'!D34<>\"\",('Arbeit 1'!D34)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D34<>\"\",('Arbeit 2'!D34)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D34<>\"\",('Arbeit 3'!D34)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D34<>\"\",('Arbeit 4'!D34)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A35<>\"\",'Arbeit 1'!A35,\"\")","v":""},{"$f":"IF('Arbeit 1'!D35<>\"\",('Arbeit 1'!D35)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D35<>\"\",('Arbeit 2'!D35)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D35<>\"\",('Arbeit 3'!D35)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D35<>\"\",('Arbeit 4'!D35)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A36<>\"\",'Arbeit 1'!A36,\"\")","v":""},{"$f":"IF('Arbeit 1'!D36<>\"\",('Arbeit 1'!D36)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D36<>\"\",('Arbeit 2'!D36)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D36<>\"\",('Arbeit 3'!D36)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D36<>\"\",('Arbeit 4'!D36)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A37<>\"\",'Arbeit 1'!A37,\"\")","v":""},{"$f":"IF('Arbeit 1'!D37<>\"\",('Arbeit 1'!D37)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D37<>\"\",('Arbeit 2'!D37)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D37<>\"\",('Arbeit 3'!D37)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D37<>\"\",('Arbeit 4'!D37)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A38<>\"\",'Arbeit 1'!A38,\"\")","v":""},{"$f":"IF('Arbeit 1'!D38<>\"\",('Arbeit 1'!D38)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D38<>\"\",('Arbeit 2'!D38)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D38<>\"\",('Arbeit 3'!D38)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D38<>\"\",('Arbeit 4'!D38)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A39<>\"\",'Arbeit 1'!A39,\"\")","v":""},{"$f":"IF('Arbeit 1'!D39<>\"\",('Arbeit 1'!D39)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D39<>\"\",('Arbeit 2'!D39)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D39<>\"\",('Arbeit 3'!D39)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D39<>\"\",('Arbeit 4'!D39)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A40<>\"\",'Arbeit 1'!A40,\"\")","v":""},{"$f":"IF('Arbeit 1'!D40<>\"\",('Arbeit 1'!D40)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D40<>\"\",('Arbeit 2'!D40)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D40<>\"\",('Arbeit 3'!D40)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D40<>\"\",('Arbeit 4'!D40)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A41<>\"\",'Arbeit 1'!A41,\"\")","v":""},{"$f":"IF('Arbeit 1'!D41<>\"\",('Arbeit 1'!D41)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D41<>\"\",('Arbeit 2'!D41)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D41<>\"\",('Arbeit 3'!D41)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D41<>\"\",('Arbeit 4'!D41)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A42<>\"\",'Arbeit 1'!A42,\"\")","v":""},{"$f":"IF('Arbeit 1'!D42<>\"\",('Arbeit 1'!D42)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D42<>\"\",('Arbeit 2'!D42)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D42<>\"\",('Arbeit 3'!D42)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D42<>\"\",('Arbeit 4'!D42)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A43<>\"\",'Arbeit 1'!A43,\"\")","v":""},{"$f":"IF('Arbeit 1'!D43<>\"\",('Arbeit 1'!D43)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D43<>\"\",('Arbeit 2'!D43)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D43<>\"\",('Arbeit 3'!D43)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D43<>\"\",('Arbeit 4'!D43)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A44<>\"\",'Arbeit 1'!A44,\"\")","v":""},{"$f":"IF('Arbeit 1'!D44<>\"\",('Arbeit 1'!D44)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D44<>\"\",('Arbeit 2'!D44)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D44<>\"\",('Arbeit 3'!D44)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D44<>\"\",('Arbeit 4'!D44)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A45<>\"\",'Arbeit 1'!A45,\"\")","v":""},{"$f":"IF('Arbeit 1'!D45<>\"\",('Arbeit 1'!D45)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D45<>\"\",('Arbeit 2'!D45)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D45<>\"\",('Arbeit 3'!D45)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D45<>\"\",('Arbeit 4'!D45)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A46<>\"\",'Arbeit 1'!A46,\"\")","v":""},{"$f":"IF('Arbeit 1'!D46<>\"\",('Arbeit 1'!D46)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D46<>\"\",('Arbeit 2'!D46)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D46<>\"\",('Arbeit 3'!D46)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D46<>\"\",('Arbeit 4'!D46)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A47<>\"\",'Arbeit 1'!A47,\"\")","v":""},{"$f":"IF('Arbeit 1'!D47<>\"\",('Arbeit 1'!D47)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D47<>\"\",('Arbeit 2'!D47)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D47<>\"\",('Arbeit 3'!D47)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D47<>\"\",('Arbeit 4'!D47)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A48<>\"\",'Arbeit 1'!A48,\"\")","v":""},{"$f":"IF('Arbeit 1'!D48<>\"\",('Arbeit 1'!D48)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D48<>\"\",('Arbeit 2'!D48)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D48<>\"\",('Arbeit 3'!D48)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D48<>\"\",('Arbeit 4'!D48)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A49<>\"\",'Arbeit 1'!A49,\"\")","v":""},{"$f":"IF('Arbeit 1'!D49<>\"\",('Arbeit 1'!D49)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D49<>\"\",('Arbeit 2'!D49)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D49<>\"\",('Arbeit 3'!D49)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D49<>\"\",('Arbeit 4'!D49)*1,\"\")","v":""},"",""]
[{"$f":"IF('Arbeit 1'!A50<>\"\",'Arbeit 1'!A50,\"\")","v":""},{"$f":"IF('Arbeit 1'!D50<>\"\",('Arbeit 1'!D50)*1,\"\")","v":""},{"$f":"IF('Arbeit 2'!D50<>\"\",('Arbeit 2'!D50)*1,\"\")","v":""},{"$f":"IF('Arbeit 3'!D50<>\"\",('Arbeit 3'!D50)*1,\"\")","v":""},{"$f":"IF('Arbeit 4'!D50<>\"\",('Arbeit 4'!D50)*1,\"\")","v":""},"",""]