{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Ertage","Noten"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":29,"comments":1,"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":"Ertage","index":0,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Jahr",887405,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,386577481]
[{"$f":"YEAR(TODAY())","v":2008}]
[]
["Ostern","Relevant"]
[{"$f":"TRUNC(DATE(A2,3,56-MOD(MOD(A2,19)*10.63+5,29))/7)*7+1","v":"2008-03-23"}]
[]
[{"$f":"DATEVALUE(\"1.1.\" & $A$2)","v":"2008-01-01"},true,"Neujahrstag",{"$f":"IF(B7=TRUE,A7,\"\")","v":"2008-01-01"},{"$f":"C7","v":"Neujahrstag"}]
[{"$f":"DATEVALUE(\"6.1.\" & $A$2)","v":"2008-01-06"},true,"Hl. Drei Könige","2008-01-06","Hl. Drei Könige"]
[{"$f":"$A$5-2","v":"2008-03-21"},true,"Karfreitag","2008-03-21","Karfreitag"]
[{"$f":"A5","v":"2008-03-23"},true,"Ostersonntag","2008-03-23","Ostersonntag"]
[{"$f":"$A$5+1","v":"2008-03-24"},true,"Ostermontag","2008-03-24","Ostermontag"]
[{"$f":"DATEVALUE(\"1.5.\" & $A$2)","v":"2008-05-01"},true,"Maifeiertag","2008-05-01","Maifeiertag"]
[{"$f":"$A$15-11","v":"2008-05-01"},true,"Himmelfahrt","2008-05-01","Himmelfahrt"]
[{"$f":"$A$5+49","v":"2008-05-11"},true,"Pfingstsonntag","2008-05-11","Pfingstsonntag"]
[{"$f":"$A$5+50","v":"2008-05-12"},true,"Pfingstmontag","2008-05-12","Pfingstmontag"]
[{"$f":"$A$15+10","v":"2008-05-22"},true,"Fronleichnam","2008-05-22","Fronleichnam"]
[{"$f":"DATEVALUE(\"8.8.\" & $A$2)","v":"2008-08-08"},true,"Friedensfest","2008-08-08","Friedensfest"]
[{"$f":"DATEVALUE(\"15.8.\" & $A$2)","v":"2008-08-15"},true,"Mariä Himmelfahrt","2008-08-15","Mariä Himmelfahrt"]
[{"$f":"DATEVALUE(\"3.10.\" & $A$2)","v":"2008-10-03"},true,"Tag d.dt. Einheit","2008-10-03","Tag d.dt. Einheit"]
[{"$f":"DATEVALUE(\"31.10.\" & $A$2)","v":"2008-10-31"},true,"Reformationstag","2008-10-31","Reformationstag"]
[{"$f":"DATEVALUE(\"1.11.\" & $A$2)","v":"2008-11-01"},true,"Allerheiligen","2008-11-01","Allerheiligen"]
[{"$f":"DATE($A$2,12,25)-WEEKDAY(DATE($A$2,12,25),2)-32","v":"2008-11-19"},true,"Buß- und Bettag","2008-11-19","Buß- und Bettag"]
[{"$f":"DATEVALUE(\"25.12.\" & $A$2)","v":"2008-12-25"},true,"1. Weihnachtstag","2008-12-25","1. Weihnachtstag"]
[{"$f":"DATEVALUE(\"26.12.\" & $A$2)","v":"2008-12-26"},true,"2. Weihnachtstag","2008-12-26","2. Weihnachtstag"]
[]
[{"$f":"A5-52","v":"2008-01-31"},true,"Weiberfastnacht",{"$f":"IF(B26=TRUE,A26,\"\")","v":"2008-01-31"},{"$f":"C26","v":"Weiberfastnacht"}]
[{"$f":"A5-48","v":"2008-02-04"},true,"Rosenmontag",{"$f":"IF(B27=TRUE,A27,\"\")","v":"2008-02-04"},{"$f":"C27","v":"Rosenmontag"}]
[{"$f":"A5-46","v":"2008-02-06"},true,"Aschermittwoch",{"$f":"IF(B28=TRUE,A28,\"\")","v":"2008-02-06"},{"$f":"C28","v":"Aschermittwoch"}]
[{"$f":"DATEVALUE(\"24.12.\" & $A$2)","v":"2008-12-24"},true,"Heiligabend",{"$f":"IF(B29=TRUE,A29,\"\")","v":"2008-12-24"},{"$f":"C29","v":"Heiligabend"}]
[{"$f":"DATEVALUE(\"31.12.\" & $A$2)","v":"2008-12-31"},true,"Silvester",{"$f":"IF(B30=TRUE,A30,\"\")","v":"2008-12-31"},{"$f":"C30","v":"Silvester"}]
[]
["Individuelle Einträge","Namen","Geburtstage"]
[null,{"$f":"COUNTA(B34:B3702)","v":0}]
[null,null,null,{"$f":"IF(AND(A34=\"\",C34<>\"\"),DATE($A$2,MONTH(C34),DAY(C34)),\"\")","v":""},{"$f":"IF(D34=\"\",\"\",CONCATENATE(B34,\" hat den \",YEAR(D34)-YEAR(C34),\"sten Geburtstag\"))","v":""},null,null,null,null,null,{"$f":"IF(K35-TODAY() <=K1,IF(K35-TODAY()>1,CONCATENATE(\"Noch\",K35-TODAY(),\"Tage\"),CONCATENATE(\"Nur noch\",K35-TODAY(),\"Tag!!!\")),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($G$34:$G$500,MATCH(MIN(IF($G$34:$G$500>=TODAY(),$G$34:$G$500)),$G$34:$G$500,0))","v":{"$error":"#N/A"}},{"$f":"INDEX($H$34:$H$500,MATCH(MIN(IF($G$34:$G$500>=TODAY(),$G$34:$G$500)),$G$34:$G$500,0))","v":{"$error":"#N/A"}}]

{"sheet":"Noten","index":1,"n_rows":32,"n_cols":66,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Englisch Klasse 6A",null,null,null,null,null,null,null,null,null,null,"Hier gibt's noch mehr Excel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70]
["Datum",null,null,null,"2003-10-14",null,null,null,null,null,"2004-03-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2003-04-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"5+MATCH(\"Durchschnitt:\",A6:A101,0)","v":32},"Gewicht:",null,null,null,null,null,null,null,null,null,null,null,null,"Gewicht:",null,null,null,null,null,null,null,null,null,"Gewicht:",null,null,null,null,null,null,null,null,null,null,null,"Gewicht:",null,null,null,null,null,null,null,null,null,"Gewicht:",null,null,null,null,null,null,null,"Gewicht:",null,null,null,null,null,null,null,null,null,null,6]
["Namen",2,null,"Arbeiten",null,null,null,null,null,null,null,null,null,null,1,null,null,"Vokabeltest",null,null,null,null,null,null,1,null,"Mündlich",null,null,null,null,null,null,null,null,null,1,null,"Neu",null,null,null,null,null,null,null,1,null,"Neu",null,null,null,null,null,1,null,"Neu",null,null,null,null,null,null,"EndnoteE",null,"EndnoteG"]
["Schröder Gerhard",{"$f":"IF(SUM(C6:L6)=0,\"\",SUM(C6:L6)/M6)","v":5},null,5,null,null,null,null,null,null,null,null,{"$f":"COUNT(C6:L6)","v":1},null,{"$f":"IF(SUM(P6:V6)=0,\"\",SUM(P6:V6)/W6)","v":2.65},null,3.3,2,null,null,null,null,{"$f":"COUNT(P6:V6)","v":2},null,{"$f":"IF(SUM(Z6:AH6)=0,\"\",SUM(Z6:AH6)/AI6)","v":2.7000000000000006},null,2.7,null,2.7,2.7,null,null,null,null,{"$f":"COUNT(Z6:AH6)","v":3},null,{"$f":"IF(SUM(AL6:AR6)=0,\"\",SUM(AL6:AR6)/AS6)","v":""},null,null,null,null,null,null,null,{"$f":"COUNT(AL6:AR6)","v":0},null,{"$f":"IF(SUM(AV6:AZ6)=0,\"\",SUM(AV6:AZ6)/BA6)","v":""},null,null,null,null,null,{"$f":"COUNT(AV6:AZ6)","v":0},null,{"$f":"IF(SUM(BD6:BI6)=0,\"\",SUM(BD6:BI6)/BJ6)","v":""},null,null,null,null,null,null,{"$f":"COUNT(BD6:BI6)","v":0},null,{"$f":"IF(GanzLeer,\"\",SUM(GewNote1*$M6,GewNote2*$W6,GewNote3*$AI6,GewNote4*$AS6,GewNote5*$BA6,GewNote6*$BJ6)/Anz)","v":3.342857142857143},null,{"$f":"IF(GanzLeer,\"\",SUM(GewNote1,GewNote2,GewNote3,GewNote4,GewNote5,GewNote6)/Teiler)","v":3.8375000000000004}]
["Zufall Rainer",5,null,5,null,null,null,null,null,null,null,null,1,null,4.5,null,3,6,null,null,null,null,2,null,3.9,null,4,null,3.7,4,null,null,null,null,3,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,4.3857142857142852,null,4.5999999999999996]
["Lindenberg Udo",5,null,5,null,null,null,null,null,null,null,null,1,null,4.5,null,3.7,5.3,null,null,null,null,2,null,2.8000000000000003,null,3,null,2.7,2.7,null,null,null,null,3,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,3.9142857142857141,null,4.3250000000000002]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,null,null,0,null,"",null,null,null,null,null,0,null,"",null,null,null,null,null,null,0,null,"",null,""]
["Durchschnitt:",null,{"$f":"IF(COUNT(C6:C31)=0,\"\",AVERAGE(C6:C31))","v":""},5,"",null,null,"","","","","",null,null,null,{"$f":"IF(COUNT(P6:P31)=0,\"\",AVERAGE(P6:P31))","v":""},3.3333333333333335,4.4333333333333336,"","","","",null,null,null,{"$f":"IF(COUNT(Z6:Z31)=0,\"\",AVERAGE(Z6:Z31))","v":""},3.2333333333333329,"",3.0333333333333337,3.1333333333333333,"","","","",null,null,null,{"$f":"IF(COUNT(AL6:AL31)=0,\"\",AVERAGE(AL6:AL31))","v":""},"","","","","","",null,null,null,{"$f":"IF(COUNT(AV6:AV31)=0,\"\",AVERAGE(AV6:AV31))","v":""},{"$f":"IF(COUNT(AW6:AW31)=0,\"\",AVERAGE(AW6:AW31))","v":""},{"$f":"IF(COUNT(AX6:AX31)=0,\"\",AVERAGE(AX6:AX31))","v":""},{"$f":"IF(COUNT(AY6:AY31)=0,\"\",AVERAGE(AY6:AY31))","v":""},{"$f":"IF(COUNT(AZ6:AZ31)=0,\"\",AVERAGE(AZ6:AZ31))","v":""},null,null,null,{"$f":"IF(COUNT(BD6:BD31)=0,\"\",AVERAGE(BD6:BD31))","v":""},"","","","","",null,null,{"$f":"IF(COUNT(BL6:BL31)=0,\"\",AVERAGE(BL6:BL31))","v":3.8809523809523809},null,{"$f":"IF(COUNT(BN6:BN31)=0,\"\",AVERAGE(BN6:BN31))","v":4.2541666666666664}]