{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Kalender","Optionen"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":9,"comments":2,"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":"Kalender","index":0,"n_rows":42,"n_cols":23,"rows_kept":42,"cut":false,"hidden":false,"merged":[[31,20,31,21],[32,20,32,21],[33,20,33,21],[34,20,34,21],[35,20,35,21],[31,17,31,18],[32,17,32,18],[33,17,33,18],[34,17,34,18],[35,17,35,18],[28,17,28,18],[29,17,29,18],[30,17,30,18],[28,20,28,21],[29,20,29,21],[30,20,30,21],[1,17,2,17],[1,16,2,16],[8,17,8,21],[27,17,27,18],[27,20,27,21]]}
[]
[null,null,{"$f":"\"Kalender \" & R2","v":"Kalender 2009"},{"$nulls":13},"Jahr:",2009]
[]
[]
[null,null,{"$f":"DATE($R$2,COLUMN()-2,1)","v":"2009-01-01"},"2009-02-01","2009-03-01","2009-04-01","2009-05-01","2009-06-01","2009-07-01","2009-08-01","2009-09-01","2009-10-01","2009-11-01","2009-12-01",null,null,"Format:","27.02."]
[null,"1.",{"$f":"C5","v":"2009-01-01"},"2009-02-01","2009-03-01","2009-04-01","2009-05-01","2009-06-01","2009-07-01","2009-08-01","2009-09-01","2009-10-01","2009-11-01","2009-12-01"]
[null,"2.",{"$f":"C6+1","v":"2009-01-02"},{"$f":"D6+1","v":"2009-02-02"},"2009-03-02","2009-04-02","2009-05-02","2009-06-02","2009-07-02","2009-08-02","2009-09-02","2009-10-02","2009-11-02","2009-12-02",null,null,"Sa/So:",null,"Feiertage:",null,"Urlaub:"]
[null,"3.",{"$f":"C7+1","v":"2009-01-03"},"2009-02-03","2009-03-03","2009-04-03","2009-05-03","2009-06-03","2009-07-03","2009-08-03","2009-09-03","2009-10-03","2009-11-03","2009-12-03"]
[null,"4.","2009-01-04","2009-02-04","2009-03-04","2009-04-04","2009-05-04","2009-06-04","2009-07-04","2009-08-04","2009-09-04","2009-10-04","2009-11-04","2009-12-04",null,null,"Bundesland:","Bayern"]
[null,"5.","2009-01-05","2009-02-05","2009-03-05","2009-04-05","2009-05-05","2009-06-05","2009-07-05","2009-08-05","2009-09-05","2009-10-05","2009-11-05","2009-12-05"]
[null,"6.","2009-01-06","2009-02-06","2009-03-06","2009-04-06","2009-05-06","2009-06-06","2009-07-06","2009-08-06","2009-09-06","2009-10-06","2009-11-06","2009-12-06",null,null,"Feiertage:",{"$f":"IF(Optionen!T59>1,TEXT(Optionen!T59,\"TT.MM.JJJ\") & \" \" & Optionen!M59,\"\")","v":"01.01.2009 Neujahrstag"}]
[null,"7.","2009-01-07","2009-02-07","2009-03-07","2009-04-07","2009-05-07","2009-06-07","2009-07-07","2009-08-07","2009-09-07","2009-10-07","2009-11-07","2009-12-07",null,null,null,{"$f":"IF(Optionen!T60>1,TEXT(Optionen!T60,\"TT.MM.JJJ\") & \" \" & Optionen!M60,\"\")","v":"06.01.2009 Heilige Drei Könige"}]
[null,"8.","2009-01-08","2009-02-08","2009-03-08","2009-04-08","2009-05-08","2009-06-08","2009-07-08","2009-08-08","2009-09-08","2009-10-08","2009-11-08","2009-12-08",null,null,null,{"$f":"IF(Optionen!T61>1,TEXT(Optionen!T61,\"TT.MM.JJJ\") & \" \" & Optionen!M61,\"\")","v":"10.04.2009 Karfreitag"}]
[null,"9.","2009-01-09","2009-02-09","2009-03-09","2009-04-09","2009-05-09","2009-06-09","2009-07-09","2009-08-09","2009-09-09","2009-10-09","2009-11-09","2009-12-09",null,null,null,{"$f":"IF(Optionen!T62>1,TEXT(Optionen!T62,\"TT.MM.JJJ\") & \" \" & Optionen!M62,\"\")","v":"12.04.2009 Ostersonntag"}]
[null,"10.","2009-01-10","2009-02-10","2009-03-10","2009-04-10","2009-05-10","2009-06-10","2009-07-10","2009-08-10","2009-09-10","2009-10-10","2009-11-10","2009-12-10",null,null,null,{"$f":"IF(Optionen!T63>1,TEXT(Optionen!T63,\"TT.MM.JJJ\") & \" \" & Optionen!M63,\"\")","v":"13.04.2009 Ostermontag"}]
[null,"11.","2009-01-11","2009-02-11","2009-03-11","2009-04-11","2009-05-11","2009-06-11","2009-07-11","2009-08-11","2009-09-11","2009-10-11","2009-11-11","2009-12-11",null,null,null,{"$f":"IF(Optionen!T64>1,TEXT(Optionen!T64,\"TT.MM.JJJ\") & \" \" & Optionen!M64,\"\")","v":"01.05.2009 Tag der Arbeit"}]
[null,"12.","2009-01-12","2009-02-12","2009-03-12","2009-04-12","2009-05-12","2009-06-12","2009-07-12","2009-08-12","2009-09-12","2009-10-12","2009-11-12","2009-12-12",null,null,null,{"$f":"IF(Optionen!T65>1,TEXT(Optionen!T65,\"TT.MM.JJJ\") & \" \" & Optionen!M65,\"\")","v":"21.05.2009 Christi Himmelfahrt"}]
[null,"13.","2009-01-13","2009-02-13","2009-03-13","2009-04-13","2009-05-13","2009-06-13","2009-07-13","2009-08-13","2009-09-13","2009-10-13","2009-11-13","2009-12-13",null,null,null,{"$f":"IF(Optionen!T66>1,TEXT(Optionen!T66,\"TT.MM.JJJ\") & \" \" & Optionen!M66,\"\")","v":"31.05.2009 Pfingstsonntag"}]
[null,"14.","2009-01-14","2009-02-14","2009-03-14","2009-04-14","2009-05-14","2009-06-14","2009-07-14","2009-08-14","2009-09-14","2009-10-14","2009-11-14","2009-12-14",null,null,null,{"$f":"IF(Optionen!T67>1,TEXT(Optionen!T67,\"TT.MM.JJJ\") & \" \" & Optionen!M67,\"\")","v":"01.06.2009 Pfingstmontag"}]
[null,"15.","2009-01-15","2009-02-15","2009-03-15","2009-04-15","2009-05-15","2009-06-15","2009-07-15","2009-08-15","2009-09-15","2009-10-15","2009-11-15","2009-12-15",null,null,null,{"$f":"IF(Optionen!T68>1,TEXT(Optionen!T68,\"TT.MM.JJJ\") & \" \" & Optionen!M68,\"\")","v":"11.06.2009 Fronleichnam"}]
[null,"16.","2009-01-16","2009-02-16","2009-03-16","2009-04-16","2009-05-16","2009-06-16","2009-07-16","2009-08-16","2009-09-16","2009-10-16","2009-11-16","2009-12-16",null,null,null,{"$f":"IF(Optionen!T69>1,TEXT(Optionen!T69,\"TT.MM.JJJ\") & \" \" & Optionen!M69,\"\")","v":"03.10.2009 Tag der Dt. Einheit"}]
[null,"17.","2009-01-17","2009-02-17","2009-03-17","2009-04-17","2009-05-17","2009-06-17","2009-07-17","2009-08-17","2009-09-17","2009-10-17","2009-11-17","2009-12-17",null,null,null,{"$f":"IF(Optionen!T70>1,TEXT(Optionen!T70,\"TT.MM.JJJ\") & \" \" & Optionen!M70,\"\")","v":"01.11.2009 Allerheiligen"}]
[null,"18.","2009-01-18",{"$f":"D22+1","v":"2009-02-18"},{"$f":"E22+1","v":"2009-03-18"},{"$f":"F22+1","v":"2009-04-18"},{"$f":"G22+1","v":"2009-05-18"},{"$f":"H22+1","v":"2009-06-18"},{"$f":"I22+1","v":"2009-07-18"},{"$f":"J22+1","v":"2009-08-18"},{"$f":"K22+1","v":"2009-09-18"},{"$f":"L22+1","v":"2009-10-18"},{"$f":"M22+1","v":"2009-11-18"},{"$f":"N22+1","v":"2009-12-18"},null,null,null,{"$f":"IF(Optionen!T71>1,TEXT(Optionen!T71,\"TT.MM.JJJ\") & \" \" & Optionen!M71,\"\")","v":"25.12.2009 1. Weihnachtstag"}]
[null,"19.","2009-01-19","2009-02-19","2009-03-19","2009-04-19","2009-05-19","2009-06-19","2009-07-19","2009-08-19","2009-09-19","2009-10-19","2009-11-19","2009-12-19",null,null,null,{"$f":"IF(Optionen!T72>1,TEXT(Optionen!T72,\"TT.MM.JJJ\") & \" \" & Optionen!M72,\"\")","v":"26.12.2009 2. Weihnachtstag"}]
[null,"20.","2009-01-20","2009-02-20","2009-03-20","2009-04-20","2009-05-20","2009-06-20","2009-07-20","2009-08-20","2009-09-20","2009-10-20","2009-11-20","2009-12-20",null,null,null,{"$f":"IF(Optionen!T73>1,TEXT(Optionen!T73,\"TT.MM.JJJ\") & \" \" & Optionen!M73,\"\")","v":""}]
[null,"21.","2009-01-21","2009-02-21","2009-03-21","2009-04-21","2009-05-21","2009-06-21","2009-07-21","2009-08-21","2009-09-21","2009-10-21","2009-11-21","2009-12-21",null,null,null,{"$f":"IF(Optionen!T74>1,TEXT(Optionen!T74,\"TT.MM.JJJ\") & \" \" & Optionen!M74,\"\")","v":""}]
[null,"22.","2009-01-22","2009-02-22","2009-03-22","2009-04-22","2009-05-22","2009-06-22","2009-07-22","2009-08-22","2009-09-22","2009-10-22","2009-11-22","2009-12-22"]
[null,"23.","2009-01-23","2009-02-23","2009-03-23","2009-04-23","2009-05-23","2009-06-23","2009-07-23","2009-08-23","2009-09-23","2009-10-23","2009-11-23","2009-12-23",null,null,"Urlaube:","von",null,null,"bis"]
[null,"24.","2009-01-24","2009-02-24","2009-03-24","2009-04-24","2009-05-24","2009-06-24","2009-07-24","2009-08-24","2009-09-24","2009-10-24","2009-11-24","2009-12-24",null,null,1,{"$nulls":5},{"$f":"NETWORKDAYS(R29,U29,Optionen!$T$59:$T$74)","v":0}]
[null,"25.","2009-01-25","2009-02-25","2009-03-25","2009-04-25","2009-05-25","2009-06-25","2009-07-25","2009-08-25","2009-09-25","2009-10-25","2009-11-25","2009-12-25",null,null,2,{"$nulls":5},{"$f":"NETWORKDAYS(R30,U30,Optionen!$T$59:$T$74)","v":0}]
[null,"26.","2009-01-26","2009-02-26","2009-03-26","2009-04-26","2009-05-26","2009-06-26","2009-07-26","2009-08-26","2009-09-26","2009-10-26","2009-11-26","2009-12-26",null,null,3,{"$nulls":5},{"$f":"NETWORKDAYS(R31,U31,Optionen!$T$59:$T$74)","v":0}]
[null,"27.","2009-01-27","2009-02-27","2009-03-27","2009-04-27","2009-05-27","2009-06-27","2009-07-27","2009-08-27","2009-09-27","2009-10-27","2009-11-27","2009-12-27",null,null,4,{"$nulls":5},{"$f":"NETWORKDAYS(R32,U32,Optionen!$T$59:$T$74)","v":0}]
[null,"28.","2009-01-28","2009-02-28","2009-03-28","2009-04-28","2009-05-28","2009-06-28","2009-07-28","2009-08-28","2009-09-28","2009-10-28","2009-11-28","2009-12-28",null,null,5,{"$nulls":5},{"$f":"NETWORKDAYS(R33,U33,Optionen!$T$59:$T$74)","v":0}]
[null,"29.","2009-01-29","2009-03-01","2009-03-29","2009-04-29","2009-05-29","2009-06-29","2009-07-29","2009-08-29","2009-09-29","2009-10-29","2009-11-29","2009-12-29",null,null,6,{"$nulls":5},{"$f":"NETWORKDAYS(R34,U34,Optionen!$T$59:$T$74)","v":0}]
[null,"30.","2009-01-30","2009-03-02","2009-03-30","2009-04-30","2009-05-30","2009-06-30","2009-07-30","2009-08-30","2009-09-30","2009-10-30","2009-11-30","2009-12-30",null,null,7,{"$nulls":5},{"$f":"NETWORKDAYS(R35,U35,Optionen!$T$59:$T$74)","v":0}]
[null,"31.","2009-01-31","2009-03-03","2009-03-31","2009-05-01","2009-05-31","2009-07-01","2009-07-31","2009-08-31","2009-10-01","2009-10-31","2009-12-01","2009-12-31",null,null,8,{"$nulls":5},{"$f":"NETWORKDAYS(R36,U36,Optionen!$T$59:$T$74)","v":0}]
[]
[null,"∑T",{"$f":"C39+C40","v":22},{"$f":"D39+D40","v":20},22,22,21,22,23,21,22,22,21,23,{"$f":"SUM(C38:N38)","v":261},null,"Statistik:",null,null,null,"Anzahl Tage gesamt:",{"$f":"O38","v":261}]
[null,"∑AT",{"$f":"TRANSPOSE(Optionen!$Z42:$AA$53)","v":20},20,22,20,19,20,23,21,22,22,21,22,{"$f":"SUM(C39:N39)","v":252},{"$nulls":5},"Anzahl Arbeitstage:",{"$f":"O39-V41","v":252}]
[null,"∑FT",{"$f":"TRANSPOSE(Optionen!$W$42:$W$53)","v":2},0,0,2,2,2,0,0,0,0,0,1,{"$f":"SUM(C40:N40)","v":9},{"$nulls":5},"Anzahl Feiertage:",{"$f":"O40","v":9}]
[{"$nulls":14},{"$f":"SUM(C41:N41)","v":0},{"$nulls":5},"Anzahl Urlaubstage:",{"$f":"SUM(W29:W36)","v":0}]
[{"$nulls":21},"© Excel-Inside Solutions "]

{"sheet":"Optionen","index":1,"n_rows":74,"n_cols":29,"rows_kept":74,"cut":false,"hidden":true,"merged":[[70,19,70,21],[70,23,70,25],[74,23,74,25],[75,23,75,25],[71,19,71,21],[71,23,71,25],[72,19,72,21],[72,23,72,25],[73,19,73,21],[73,23,73,25],[67,19,67,21],[67,23,67,25],[68,19,68,21],[68,23,68,25],[69,19,69,21],[69,23,69,25],[64,19,64,21],[64,23,64,25],[65,19,65,21],[65,23,65,25],[66,19,66,21],[66,23,66,25],[61,19,61,21],[61,23,61,25],[62,19,62,21],[62,23,62,25],[63,19,63,21],[63,23,63,25],[58,19,58,21],[58,23,58,25],[59,19,59,21],[59,23,59,25],[60,19,60,21],[60,23,60,25],[51,19,51,20],[51,25,51,26],[52,19,52,20],[52,25,52,26],[53,19,53,20],[53,25,53,26],[48,19,48,20],[48,25,48,26],[49,19,49,20],[49,25,49,26],[50,19,50,20],[50,25,50,26],[45,19,45,20],[45,25,45,26],[46,19,46,20],[46,25,46,26],[47,19,47,20],[47,25,47,26],[42,19,42,20],[42,25,42,26],[43,19,43,20],[43,25,43,26],[44,19,44,20],[44,25,44,26],[39,4,39,7],[40,4,40,7],[41,4,41,7],[33,26,33,27],[34,26,34,27],[41,19,41,20],[41,25,41,26]]}
{"$rows_empty":8}
[null,{"$f":"Kalender!R9","v":"Bayern"},{"$f":"Kalender!R2","v":2009},{"$nulls":4},"Bundesland Nr."]
[null,"Bundesland","Auswertungsjahr",null,null,null,"BL#",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Datum","Feiertage","Monat","Wo-Tag","Feiertag",{"$f":"MATCH(B9,Bundesländer)","v":2},"BW","BY1","BY2","BY3","BE","BB","HB","HH","HE","MV","NI","NW","RP","SL","SN1","SN2","SA","SH","TH1","TH2","Alle Feitertage"]
[null,{"$f":"DATE(JahrFeiertage,1,1)","v":"2009-01-01"},{"$f":"IF(G12=\"x\",AB12,\"\")","v":"Neujahrstag"},{"$f":"IF(F12=1,MONTH(B12),\"\")","v":1},{"$f":"IF(G12=\"x\",WEEKDAY(B12,2),\"ohne\")","v":4},{"$f":"IF(G12=\"x\",IF(AND(E12<>6,E12<>7),1,0),\"\")","v":1},{"$f":"INDEX(H12:AA12,$G$11)","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","Neujahrstag"]
[null,{"$f":"DATE(JahrFeiertage,1,6)","v":"2009-01-06"},"Heilige Drei Könige",{"$f":"IF(F13=1,MONTH(B13),\"\")","v":1},{"$f":"IF(G13=\"x\",WEEKDAY(B13,2),\"ohne\")","v":2},{"$f":"IF(G13=\"x\",IF(AND(E13<>6,E13<>7),1,0),\"\")","v":1},"x","x","x","x","x",{"$nulls":12},"x",null,null,null,"Heilige Drei Könige"]
[null,"2019-03-08","","","ohne","",0,{"$nulls":4},"x",{"$nulls":15},"Frauentag"]
[null,{"$f":"B16-2","v":"2009-04-10"},"Karfreitag",4,5,1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","Karfreitag"]
[null,{"$f":"IF((22+MOD(19*MOD(JahrFeiertage,19)+24,30)+MOD(2*MOD(JahrFeiertage,4)+4*MOD(JahrFeiertage,7)+6*MOD(19*MOD(JahrFeiertage,19)+24,30)+5,7))>31,IF((22+MOD(19*MOD(JahrFeiertage,19)+24,30)+MOD(2*MOD(JahrFeiertage,4)+4*MOD(JahrFeiertage,7)+6*MOD(19*MOD(JahrFeiertage,19)+24,30)+5,7))-31=26,DATE(JahrFeiertage,4,19),IF(AND((22+MOD(19*MOD(JahrFeiertage,19)+24,30)+MOD(2*MOD(JahrFeiertage,4)+4*MOD(JahrFeiertage,7)+6*MOD(19*MOD(JahrFeiertage,19)+24,30)+5,7))-31=25,MOD(19*MOD(JahrFeiertage,19)+24,30)=28,MOD(JahrFeiertage,19)>10),DATE(JahrFeiertage,4,18),DATE(JahrFeiertage,4,(22+MOD(19*MOD(JahrFeiertage,19)+24,30)+MOD(2*MOD(JahrFeiertage,4)+4*MOD(JahrFeiertage,7)+6*MOD(19*MOD(JahrFeiertage,19)+24,30)+5,7))-31))),DATE(JahrFeiertage,3,(22+MOD(19*MOD(JahrFeiertage,19)+24,30)+MOD(2*MOD(JahrFeiertage,4)+4*MOD(JahrFeiertage,7)+6*MOD(19*MOD(JahrFeiertage,19)+24,30)+5,7))))","v":"2009-04-12"},"Ostersonntag","",7,0,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","Ostersonntag"]
[null,{"$f":"B16+1","v":"2009-04-13"},"Ostermontag",4,1,1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","Ostermontag"]
[null,{"$f":"DATE(JahrFeiertage,5,1)","v":"2009-05-01"},"Tag der Arbeit",5,5,1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","Tag der Arbeit"]
[null,{"$f":"B17+38","v":"2009-05-21"},"Christi Himmelfahrt",5,4,1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","Christi Himmelfahrt"]
[null,{"$f":"B16+49","v":"2009-05-31"},"Pfingstsonntag","",7,0,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","Pfingstsonntag"]
[null,{"$f":"B16+50","v":"2009-06-01"},"Pfingstmontag",6,1,1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","Pfingstmontag"]
[null,{"$f":"B16+60","v":"2009-06-11"},"Fronleichnam",6,4,1,"x","x","x","x","x",{"$nulls":4},"x",null,null,"x","x","x",null,"x",null,null,null,"x","Fronleichnam"]
[null,{"$f":"DATE(JahrFeiertage,8,8)","v":"2009-08-08"},"","","ohne","",0,null,null,null,"x",{"$nulls":16},"Augsburger Hohes Friedenfest"]
[null,{"$f":"DATE(JahrFeiertage,8,15)","v":"2009-08-15"},"","",null,"",0,null,null,"x","x",{"$nulls":9},"x",{"$nulls":6},"Mariä Himmelfahrt"]
[null,{"$f":"DATE(JahrFeiertage,10,3)","v":"2009-10-03"},"Tag der Dt. Einheit","",6,0,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","Tag der Dt. Einheit"]
[null,{"$f":"DATE(JahrFeiertage,10,31)","v":"2009-10-31"},"","","ohne","",0,{"$nulls":5},"x",null,null,null,"x",{"$nulls":4},"x","x","x",null,"x","x","Reformationstag"]
[null,{"$f":"DATE(JahrFeiertage,11,1)","v":"2009-11-01"},"Allerheiligen","",7,0,"x","x","x","x","x",{"$nulls":7},"x","x","x",{"$nulls":6},"Allerheiligen"]
[null,{"$f":"DATE(JahrFeiertage,12,25)-WEEKDAY(DATE(JahrFeiertage,12,25),2)-32","v":"2009-11-18"},"","","ohne","",0,{"$nulls":14},"x","x",{"$nulls":4},"Buß- und Bettag"]
[null,{"$f":"DATE(JahrFeiertage,12,25)","v":"2009-12-25"},"1. Weihnachtstag",12,5,1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","1. Weihnachtstag"]
[null,{"$f":"DATE(JahrFeiertage,12,26)","v":"2009-12-26"},"2. Weihnachtstag","",6,0,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","2. Weihnachtstag"]
[{"$nulls":4},{"$f":"COUNTIF(E12:E30,\"=6\")+COUNTIF(E12:E30,\"=7\")","v":5},{"$f":"SUM(F12:F30)","v":9},{"$f":"COUNTIF(G12:G30,\"x\")","v":14}]
[{"$nulls":4},"Sa+So"]
[]
[]
[]
[]
[]
[]
[null,"Deutsche Bundesländer",null,null,"Kalenderformat",{"$nulls":7},"Arbeitstage"]
[null,"Baden-Württemberg","BW",null,"Di.",{"$nulls":13},"Mon."]
[null,"Bayern","BY1",null,"Di. 27",{"$nulls":13},"Nr.","Tage",null,null,"Feiertage",null,null,"Arbeitstage"]
[null,"Bayern mit Mariä Himmelfahrt","BY2",null,"27.02.",{"$nulls":7},"Arbeitstage",null,null,"Jan",null,null,1,{"$f":"NETWORKDAYS(DATE($C$9,S42,1),EOMONTH(DATE($C$9,S42,1),0))","v":22},null,null,{"$f":"COUNTIF($D$12:$D$30,S42)","v":2},null,null,{"$f":"T42-W42","v":20}]
[null,"Bayern nur Augsburg","BY3",{"$nulls":9},"Arbeitstage",null,null,"Feb",null,null,2,20,null,null,0,null,null,{"$f":"T43-W43","v":20}]
[null,"Berlin","BE",{"$nulls":9},"Arbeitstage",null,null,"Mrz",null,null,3,22,null,null,0,null,null,22]
[null,"Brandenburg","BB",{"$nulls":9},"Arbeitstage",null,null,"Apr",null,null,4,22,null,null,2,null,null,20]
[null,"Bremen","HB",{"$nulls":9},"Arbeitstage",null,null,"Mai",null,null,5,21,null,null,2,null,null,19]
[null,"Hamburg","HH",{"$nulls":9},"Arbeitstage",null,null,"Jun",null,null,6,22,null,null,2,null,null,20]
[null,"Hessen","HE",{"$nulls":9},"Arbeitstage",null,null,"Jul",null,null,7,23,null,null,0,null,null,23]
[null,"Mecklenburg-Vorpommern","MV",null,"Ansicht",{"$nulls":7},"Arbeitstage",null,null,"Aug",null,null,8,21,null,null,0,null,null,21]
[null,"Niedersachsen","NI",null,"Sa./So",null,true,{"$nulls":5},"Arbeitstage",null,null,"Sep",null,null,9,22,null,null,0,null,null,22]
[null,"Nordrhein-Westfalen","NW",null,"Feiertage",null,true,{"$nulls":5},"Arbeitstage",null,null,"Okt",null,null,10,22,null,null,0,null,null,22]
[null,"Rheinland-Pfalz","RP",null,"Urlaub",null,true,{"$nulls":5},"Arbeitstage",null,null,"Nov",null,null,11,21,null,null,0,null,null,21]
[null,"Saarland","SL",{"$nulls":9},"Arbeitstage",null,null,"Dez",null,null,12,23,null,null,1,null,null,22]
[null,"Sachsen","SN1",{"$nulls":9},"Arbeitstage gesamt",{"$nulls":6},{"$f":"NETWORKDAYS(\"01.01.2011\",\"31.12.2011\")","v":260},null,null,{"$f":"SUM(W42:W53)","v":9},null,null,{"$f":"SUM(Z42:Z53)","v":252}]
[null,"Sachsen (Fronleichnam)","SN2"]
[null,"Sachsen-Anhalt","SA"]
[null,"Schleswig-Holstein","SH"]
[null,"Thüringen","TH1",{"$nulls":9},"Feiertage",{"$nulls":6},"Datum",null,null,null,"Wochentag",null,null,null,{"$f":"IF(ROW(A1)>COUNTA(C$12:C$30),\"\",INDEX(C$12:C$30,SMALL(IF(C$12:C$30<>\"\",ROW($12:$30)),ROW(A1))))","v":""},"Vorhanden"]
[null,"Thüringen (Fronleichnam)","TH2",{"$nulls":9},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A1))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A1)))))","v":"Neujahrstag"},{"$nulls":6},{"$f":"IF(M59<>\"\",INDEX($B$12:$B$30,MATCH(M59,$C$12:$C$30,0)),0)","v":"2009-01-01"},null,null,null,{"$f":"IF(T59>1,T59,\"\")","v":"2009-01-01"},{"$nulls":4},{"$f":"X59<>\"\"","v":true}]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A2))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A2)))))","v":"Heilige Drei Könige"},{"$nulls":6},"2009-01-06",null,null,null,{"$f":"IF(T60>1,T60,\"\")","v":"2009-01-06"},{"$nulls":4},{"$f":"X60<>\"\"","v":true}]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A3))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A3)))))","v":"Karfreitag"},{"$nulls":6},"2009-04-10",null,null,null,"2009-04-10",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A4))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A4)))))","v":"Ostersonntag"},{"$nulls":6},"2009-04-12",null,null,null,"2009-04-12",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A5))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A5)))))","v":"Ostermontag"},{"$nulls":6},"2009-04-13",null,null,null,"2009-04-13",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A6))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A6)))))","v":"Tag der Arbeit"},{"$nulls":6},"2009-05-01",null,null,null,"2009-05-01",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A7))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A7)))))","v":"Christi Himmelfahrt"},{"$nulls":6},"2009-05-21",null,null,null,"2009-05-21",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A8))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A8)))))","v":"Pfingstsonntag"},{"$nulls":6},"2009-05-31",null,null,null,"2009-05-31",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A9))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A9)))))","v":"Pfingstmontag"},{"$nulls":6},"2009-06-01",null,null,null,"2009-06-01",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A10))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A10)))))","v":"Fronleichnam"},{"$nulls":6},"2009-06-11",null,null,null,"2009-06-11",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A11))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A11)))))","v":"Tag der Dt. Einheit"},{"$nulls":6},"2009-10-03",null,null,null,"2009-10-03",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A12))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A12)))))","v":"Allerheiligen"},{"$nulls":6},"2009-11-01",null,null,null,"2009-11-01",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A13))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A13)))))","v":"1. Weihnachtstag"},{"$nulls":6},"2009-12-25",null,null,null,"2009-12-25",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A14))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A14)))))","v":"2. Weihnachtstag"},{"$nulls":6},"2009-12-26",null,null,null,"2009-12-26",{"$nulls":4},true]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A15))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A15)))))","v":""},{"$nulls":6},"00:00:00",null,null,null,"",{"$nulls":4},false]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A16))))),\"\",IF(ROW($A$1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$36<>\"\",ROW($12:$36)),ROW(A16)))))","v":""},{"$nulls":6},"00:00:00",null,null,null,"",{"$nulls":4},false]