{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Feiertage","Einzelberechnung","Copyright"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"Feiertage","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,2,8,4],[17,1,17,2],[11,1,11,3]]}
[]
[null,"Excel-Inside Solutions"]
[null,"Arbeitstage und gesetzliche Feiertage in Deutschland, Österreich und Schweiz (DACH)"]
[]
[]
[]
[null,"Kalenderjahr:",2017]
[]
[null,"Bundesland:","Nordrhein-Westfalen"]
[]
[]
[null,"Anzahl Arbeitstage……………………………………",null,null,{"$f":"Einzelberechnung!Z59","v":250}]
[null,"Anzahl Feiertage………………………………………",null,null,{"$f":"Einzelberechnung!G36","v":13}]
[null,"Anzahl zusätzliche Feiertage (ohne Sa+So)……….",null,null,{"$f":"Einzelberechnung!W59","v":10}]
[]
[{"$nulls":7},"= Wochenende"]
[]
[null,{"$f":"\"Arbeitstage \" &C7","v":"Arbeitstage 2017"},null,null,"Nr.","Feiertage","Datum","Wochentag"]
[null,"Januar",{"$f":"Einzelberechnung!Z47","v":22},null,{"$f":"IF(F19<>\"\",1,\"\")","v":1},{"$f":"Einzelberechnung!M64","v":"Neujahrstag"},{"$f":"Einzelberechnung!T64","v":"2017-01-01"},{"$f":"Einzelberechnung!X64","v":"2017-01-01"}]
[null,"Februar",{"$f":"Einzelberechnung!Z48","v":20},null,{"$f":"IF(F20<>\"\",E19+1,\"\")","v":2},{"$f":"Einzelberechnung!M65","v":"Karfreitag"},{"$f":"Einzelberechnung!T65","v":"2017-04-14"},{"$f":"Einzelberechnung!X65","v":"2017-04-14"}]
[null,"März",{"$f":"Einzelberechnung!Z49","v":23},null,{"$f":"IF(F21<>\"\",E20+1,\"\")","v":3},{"$f":"Einzelberechnung!M66","v":"Ostersonntag"},{"$f":"Einzelberechnung!T66","v":"2017-04-16"},{"$f":"Einzelberechnung!X66","v":"2017-04-16"}]
[null,"April",{"$f":"Einzelberechnung!Z50","v":18},null,4,{"$f":"Einzelberechnung!M67","v":"Ostermontag"},{"$f":"Einzelberechnung!T67","v":"2017-04-17"},{"$f":"Einzelberechnung!X67","v":"2017-04-17"}]
[null,"Mai",{"$f":"Einzelberechnung!Z51","v":21},null,5,{"$f":"Einzelberechnung!M68","v":"Tag der Arbeit"},{"$f":"Einzelberechnung!T68","v":"2017-05-01"},{"$f":"Einzelberechnung!X68","v":"2017-05-01"}]
[null,"Juni",{"$f":"Einzelberechnung!Z52","v":20},null,6,{"$f":"Einzelberechnung!M69","v":"Christi Himmelfahrt"},{"$f":"Einzelberechnung!T69","v":"2017-05-25"},{"$f":"Einzelberechnung!X69","v":"2017-05-25"}]
[null,"Juli",{"$f":"Einzelberechnung!Z53","v":21},null,7,{"$f":"Einzelberechnung!M70","v":"Pfingstsonntag"},{"$f":"Einzelberechnung!T70","v":"2017-06-04"},{"$f":"Einzelberechnung!X70","v":"2017-06-04"}]
[null,"August",{"$f":"Einzelberechnung!Z54","v":23},null,8,{"$f":"Einzelberechnung!M71","v":"Pfingstmontag"},{"$f":"Einzelberechnung!T71","v":"2017-06-05"},{"$f":"Einzelberechnung!X71","v":"2017-06-05"}]
[null,"September",{"$f":"Einzelberechnung!Z55","v":21},null,9,{"$f":"Einzelberechnung!M72","v":"Fronleichnam"},{"$f":"Einzelberechnung!T72","v":"2017-06-15"},{"$f":"Einzelberechnung!X72","v":"2017-06-15"}]
[null,"Oktober",{"$f":"Einzelberechnung!Z56","v":21},null,10,{"$f":"Einzelberechnung!M73","v":"Tag der Dt. Einheit"},{"$f":"Einzelberechnung!T73","v":"2017-10-03"},{"$f":"Einzelberechnung!X73","v":"2017-10-03"}]
[null,"November",{"$f":"Einzelberechnung!Z57","v":21},null,11,{"$f":"Einzelberechnung!M74","v":"Allerheiligen"},{"$f":"Einzelberechnung!T74","v":"2017-11-01"},{"$f":"Einzelberechnung!X74","v":"2017-11-01"}]
[null,"Dezember",{"$f":"Einzelberechnung!Z58","v":19},null,12,{"$f":"Einzelberechnung!M75","v":"1. Weihnachtstag"},{"$f":"Einzelberechnung!T75","v":"2017-12-25"},{"$f":"Einzelberechnung!X75","v":"2017-12-25"}]
[null,"Gesamt",{"$f":"SUM(C19:C30)","v":250},null,13,{"$f":"Einzelberechnung!M76","v":"2. Weihnachtstag"},{"$f":"Einzelberechnung!T76","v":"2017-12-26"},{"$f":"Einzelberechnung!X76","v":"2017-12-26"}]
[{"$nulls":4},"",{"$f":"Einzelberechnung!M77","v":""},{"$f":"Einzelberechnung!T77","v":""},{"$f":"Einzelberechnung!X77","v":""}]
[{"$nulls":4},"",{"$f":"Einzelberechnung!M78","v":""},{"$f":"Einzelberechnung!T78","v":""},{"$f":"Einzelberechnung!X78","v":""}]
[{"$nulls":4},"",{"$f":"Einzelberechnung!M79","v":""},{"$f":"Einzelberechnung!T79","v":""},{"$f":"Einzelberechnung!X79","v":""}]

{"sheet":"Einzelberechnung","index":1,"n_rows":79,"n_cols":52,"rows_kept":79,"cut":false,"hidden":true,"merged":[[76,23,76,25],[78,23,78,25],[79,23,79,25],[80,23,80,25],[77,19,77,21],[78,19,78,21],[77,23,77,25],[73,19,73,21],[74,19,74,21],[75,19,75,21],[72,23,72,25],[73,23,73,25],[74,23,74,25],[75,23,75,25],[66,19,66,21],[67,19,67,21],[68,19,68,21],[76,19,76,21],[63,23,63,25],[64,23,64,25],[65,23,65,25],[66,23,66,25],[67,23,67,25],[68,23,68,25],[69,23,69,25],[70,23,70,25],[71,23,71,25],[70,19,70,21],[71,19,71,21],[72,19,72,21],[69,19,69,21],[58,19,58,20],[54,19,54,20],[55,19,55,20],[46,25,46,26],[47,25,47,26],[48,25,48,26],[57,25,57,26],[49,25,49,26],[50,25,50,26],[51,25,51,26],[64,19,64,21],[65,19,65,21],[56,25,56,26],[57,19,57,20],[58,25,58,26],[43,4,43,7],[63,19,63,21],[46,19,46,20],[47,19,47,20],[48,19,48,20],[38,26,38,27],[39,26,39,27],[56,19,56,20],[49,19,49,20],[50,19,50,20],[51,19,51,20],[52,19,52,20],[53,19,53,20],[54,25,54,26],[55,25,55,26],[52,25,52,26],[53,25,53,26]]}
[]
[null,"Excel-Inside Solutions"]
[null,"Arbeitstage und gesetzliche Feiertage in Deutschland, Österreich und Schweiz (DACH)"]
[]
[]
[]
[]
[]
[null,{"$f":"Feiertage!C9","v":"Nordrhein-Westfalen"},{"$f":"Feiertage!C7","v":2017},{"$nulls":4},"Deutsche Bundesländer"]
[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,21,22]
[null,"Datum","Feiertage","Monat","Wo-Tag","Feiertag",{"$f":"MATCH(B9,Bundeslaender,0)","v":12},"BW","BY1","BY2","BY3","BE","BB","HB","HH","HE","MV","NI","NW","RP","SL","SN1","SN2","SA","SH","TH1","TH2","AT","CH",{"$nulls":22},"Alle Feiertage"]
[null,{"$f":"DATE(JahrFeiertage,1,1)","v":"2017-01-01"},{"$f":"IF(G12=\"x\",AZ12,\"\")","v":"Neujahrstag"},{"$f":"IF(F12=1,MONTH(B12),\"\")","v":""},{"$f":"IF(G12=\"x\",WEEKDAY(B12,2),\"ohne\")","v":7},{"$f":"IF(G12=\"x\",IF(AND(E12<>6,E12<>7),1,0),\"\")","v":0},{"$f":"INDEX(H12:AY12,$G$11)","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,"x",{"$nulls":22},"Neujahrstag"]
[null,{"$f":"DATE(JahrFeiertage,1,6)","v":"2017-01-06"},"",{"$f":"IF(F13=1,MONTH(B13),\"\")","v":""},{"$f":"IF(G13=\"x\",WEEKDAY(B13,2),\"ohne\")","v":"ohne"},{"$f":"IF(G13=\"x\",IF(AND(E13<>6,E13<>7),1,0),\"\")","v":""},{"$f":"INDEX(H13:AY13,$G$11)","v":0},"x","x","x","x",{"$nulls":12},"x",{"$nulls":27},"Heilige Drei Könige"]
[null,{"$f":"DATE(JahrFeiertage,3,8)","v":"2017-03-08"},"",{"$f":"IF(F14=1,MONTH(B14),\"\")","v":""},{"$f":"IF(G14=\"x\",WEEKDAY(B14,2),\"ohne\")","v":"ohne"},{"$f":"IF(G14=\"x\",IF(AND(E14<>6,E14<>7),1,0),\"\")","v":""},{"$f":"INDEX(H14:AY14,$G$11)","v":0},{"$nulls":4},"x",{"$nulls":39},"Weltfrauentag"]
[null,{"$f":"B16-2","v":"2017-04-14"},"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",null,"x",{"$nulls":22},"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":"2017-04-16"},"Ostersonntag","",7,0,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$nulls":22},"Ostersonntag"]
[null,{"$f":"B16+1","v":"2017-04-17"},"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","x","x",{"$nulls":22},"Ostermontag"]
[null,{"$f":"DATE(JahrFeiertage,5,1)","v":"2017-05-01"},"Tag der Arbeit",5,1,1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$nulls":24},"Tag der Arbeit"]
[null,{"$f":"B17+38","v":"2017-05-25"},"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","x","x",{"$nulls":22},"Christi Himmelfahrt"]
[null,{"$f":"B16+49","v":"2017-06-04"},"Pfingstsonntag","",7,0,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$nulls":22},"Pfingstsonntag"]
[null,{"$f":"B16+50","v":"2017-06-05"},"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","x","x",{"$nulls":22},"Pfingstmontag"]
[null,{"$f":"B16+60","v":"2017-06-15"},"Fronleichnam",6,4,1,"x","x","x","x","x",{"$nulls":4},"x",null,null,"x","x","x",null,"x",null,null,null,"x","x",{"$nulls":23},"Fronleichnam"]
[null,{"$f":"DATE(JahrFeiertage,8,1)","v":"2017-08-01"},"","","ohne","",0,{"$nulls":21},"x",{"$nulls":22},"Nationalfeiertag CH"]
[null,{"$f":"DATE(JahrFeiertage,8,8)","v":"2017-08-08"},"","","ohne","",0,null,null,null,"x",{"$nulls":40},"Augsburger Hohes Friedenfest"]
[null,{"$f":"DATE(JahrFeiertage,8,15)","v":"2017-08-15"},"","",null,"",0,null,null,"x","x",{"$nulls":9},"x",{"$nulls":6},"x",{"$nulls":23},"Mariä Himmelfahrt"]
[null,{"$f":"DATE(JahrFeiertage,10,3)","v":"2017-10-03"},"Tag der Dt. Einheit",10,2,1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$nulls":24},"Tag der Dt. Einheit"]
[null,{"$f":"DATE(JahrFeiertage,10,26)","v":"2017-10-26"},"",{"$f":"IF(F27=1,MONTH(B27),\"\")","v":""},{"$f":"IF(G27=\"x\",WEEKDAY(B27,2),\"ohne\")","v":"ohne"},{"$f":"IF(G27=\"x\",IF(AND(E27<>6,E27<>7),1,0),\"\")","v":""},{"$f":"INDEX(H27:AY27,$G$11)","v":0},{"$nulls":20},"x",{"$nulls":23},"Nationalfeiertag AT"]
[null,{"$f":"DATE(JahrFeiertage,10,31)","v":"2017-10-31"},"","","ohne","",0,{"$nulls":5},"x",null,null,null,"x",{"$nulls":4},"x","x","x",null,"x","x",{"$nulls":24},"Reformationstag"]
[null,{"$f":"DATE(JahrFeiertage,11,1)","v":"2017-11-01"},"Allerheiligen",11,3,1,"x","x","x","x","x",{"$nulls":7},"x","x","x",{"$nulls":6},"x","x",{"$nulls":22},"Allerheiligen"]
[null,{"$f":"DATE(JahrFeiertage,12,25)-WEEKDAY(DATE(JahrFeiertage,12,25),2)-32","v":"2017-11-22"},"","","ohne","",0,{"$nulls":14},"x","x",{"$nulls":28},"Buß- und Bettag"]
[null,{"$f":"DATE(JahrFeiertage,12,8)","v":"2017-12-08"},"",{"$f":"IF(F31=1,MONTH(B31),\"\")","v":""},{"$f":"IF(G31=\"x\",WEEKDAY(B31,2),\"ohne\")","v":"ohne"},{"$f":"IF(G31=\"x\",IF(AND(E31<>6,E31<>7),1,0),\"\")","v":""},{"$f":"INDEX(H31:AY31,$G$11)","v":0},{"$nulls":20},"x",{"$nulls":23},"Mariä Empfängnis"]
[null,{"$f":"DATE(JahrFeiertage,12,24)","v":"2017-12-24"},"",{"$f":"IF(F32=1,MONTH(B32),\"\")","v":""},{"$f":"IF(G32=\"x\",WEEKDAY(B32,2),\"ohne\")","v":"ohne"},{"$f":"IF(G32=\"x\",IF(AND(E32<>6,E32<>7),1,0),\"\")","v":""},{"$f":"INDEX(H32:AY32,$G$11)","v":0},{"$nulls":20},"x",{"$nulls":23},"Heiliger Abend"]
[null,{"$f":"DATE(JahrFeiertage,12,25)","v":"2017-12-25"},"1. Weihnachtstag",12,1,1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$nulls":22},"1. Weihnachtstag"]
[null,{"$f":"DATE(JahrFeiertage,12,26)","v":"2017-12-26"},"2. Weihnachtstag",12,2,1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$nulls":22},"2. Weihnachtstag"]
[null,{"$f":"DATE(JahrFeiertage,12,31)","v":"2017-12-31"},"",{"$f":"IF(F35=1,MONTH(B35),\"\")","v":""},{"$f":"IF(G35=\"x\",WEEKDAY(B35,2),\"ohne\")","v":"ohne"},{"$f":"IF(G35=\"x\",IF(AND(E35<>6,E35<>7),1,0),\"\")","v":""},{"$f":"INDEX(H35:AY35,$G$11)","v":0},{"$nulls":20},"x",{"$nulls":23},"Silvester"]
[{"$nulls":4},{"$f":"COUNTIF(E12:E34,\"=6\")+COUNTIF(E12:E34,\"=7\")","v":3},{"$f":"SUM(F12:F34)","v":10},{"$f":"COUNTIF(G12:G34,\"x\")","v":13}]
[{"$nulls":4},"Sa+So"]
[]
[]
[]
[]
[]
[]
[null,"Bundesländer / Länder",null,null,"Kalenderjahre",{"$nulls":7},"Arbeitstage"]
[null,"Baden-Württemberg","BW",null,null,null,2000,{"$nulls":11},"Mon."]
[null,"Bayern","BY1",null,null,null,2001,{"$nulls":11},"Nr.","Tage",null,null,"Feiertage",null,null,"Arbeitstage"]
[null,"Bayern mit Mariä Himmelfahrt","BY2",null,null,null,2002,{"$nulls":5},"Arbeitstage",null,null,"Jan",null,null,1,{"$f":"NETWORKDAYS(DATE($C$9,S47,1),EOMONTH(DATE($C$9,S47,1),0))","v":22},null,null,{"$f":"COUNTIF($D$12:$D$35,S47)","v":0},null,null,{"$f":"T47-W47","v":22}]
[null,"Bayern nur Augsburg","BY3",null,null,null,2003,{"$nulls":5},"Arbeitstage",null,null,"Feb",null,null,2,20,null,null,{"$f":"COUNTIF($D$12:$D$34,S48)","v":0},null,null,{"$f":"T48-W48","v":20}]
[null,"Berlin","BE",null,null,null,2004,{"$nulls":5},"Arbeitstage",null,null,"Mrz",null,null,3,23,null,null,0,null,null,23]
[null,"Brandenburg","BB",null,null,null,2005,{"$nulls":5},"Arbeitstage",null,null,"Apr",null,null,4,20,null,null,2,null,null,18]
[null,"Bremen","HB",null,null,null,2006,{"$nulls":5},"Arbeitstage",null,null,"Mai",null,null,5,23,null,null,2,null,null,21]
[null,"Hamburg","HH",null,null,null,2007,{"$nulls":5},"Arbeitstage",null,null,"Jun",null,null,6,22,null,null,2,null,null,20]
[null,"Hessen","HE",null,null,null,2008,{"$nulls":5},"Arbeitstage",null,null,"Jul",null,null,7,21,null,null,0,null,null,21]
[null,"Mecklenburg-Vorpommern","MV",null,null,null,2009,{"$nulls":5},"Arbeitstage",null,null,"Aug",null,null,8,23,null,null,0,null,null,23]
[null,"Niedersachsen","NI",null,null,null,2010,{"$nulls":5},"Arbeitstage",null,null,"Sep",null,null,9,21,null,null,0,null,null,21]
[null,"Nordrhein-Westfalen","NW",null,null,null,2011,{"$nulls":5},"Arbeitstage",null,null,"Okt",null,null,10,22,null,null,1,null,null,21]
[null,"Rheinland-Pfalz","RP",null,null,null,2012,{"$nulls":5},"Arbeitstage",null,null,"Nov",null,null,11,22,null,null,1,null,null,21]
[null,"Saarland","SL",null,null,null,2013,{"$nulls":5},"Arbeitstage",null,null,"Dez",null,null,12,21,null,null,2,null,null,19]
[null,"Sachsen","SN1",null,null,null,2014,{"$nulls":5},"Arbeitstage gesamt",{"$nulls":6},{"$f":"NETWORKDAYS(\"01.01.2011\",\"31.12.2011\")","v":260},null,null,{"$f":"SUM(W47:W58)","v":10},null,null,{"$f":"SUM(Z47:Z58)","v":250}]
[null,"Sachsen (Fronleichnam)","SN2",null,null,null,2015]
[null,"Sachsen-Anhalt","SA",null,null,null,2016]
[null,"Schleswig-Holstein","SH",null,null,null,2017]
[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$34),\"\",INDEX(C$12:C$34,SMALL(IF(C$12:C$34<>\"\",ROW($12:$34)),ROW(A1))))","v":""}]
[null,"Thüringen (Fronleichnam)","TH2",{"$nulls":9},{"$f":"IF(ISERROR(IF(ROW(A1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A1))))),\"\",IF(ROW(A1)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A1)))))","v":"Neujahrstag"},{"$nulls":6},{"$f":"IF(M64<>\"\",INDEX($B$12:$B$35,MATCH(M64,$C$12:$C$35,0)),\"\")","v":"2017-01-01"},null,null,null,{"$f":"T64","v":"2017-01-01"}]
[null,"Österreich","AT",{"$nulls":9},{"$f":"IF(ISERROR(IF(ROW(A2)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A2))))),\"\",IF(ROW(A2)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A2)))))","v":"Karfreitag"},{"$nulls":6},{"$f":"IF(M65<>\"\",INDEX($B$12:$B$35,MATCH(M65,$C$12:$C$35,0)),\"\")","v":"2017-04-14"},null,null,null,{"$f":"T65","v":"2017-04-14"}]
[null,"Schweiz","CH",{"$nulls":9},{"$f":"IF(ISERROR(IF(ROW(A3)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A3))))),\"\",IF(ROW(A3)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A3)))))","v":"Ostersonntag"},{"$nulls":6},"2017-04-16",null,null,null,"2017-04-16"]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A4)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A4))))),\"\",IF(ROW(A4)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A4)))))","v":"Ostermontag"},{"$nulls":6},"2017-04-17",null,null,null,"2017-04-17"]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A5)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A5))))),\"\",IF(ROW(A5)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A5)))))","v":"Tag der Arbeit"},{"$nulls":6},"2017-05-01",null,null,null,"2017-05-01"]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A6)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A6))))),\"\",IF(ROW(A6)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A6)))))","v":"Christi Himmelfahrt"},{"$nulls":6},"2017-05-25",null,null,null,"2017-05-25"]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A7)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A7))))),\"\",IF(ROW(A7)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A7)))))","v":"Pfingstsonntag"},{"$nulls":6},"2017-06-04",null,null,null,"2017-06-04"]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A8)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A8))))),\"\",IF(ROW(A8)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A8)))))","v":"Pfingstmontag"},{"$nulls":6},"2017-06-05",null,null,null,"2017-06-05"]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A9)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A9))))),\"\",IF(ROW(A9)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A9)))))","v":"Fronleichnam"},{"$nulls":6},"2017-06-15",null,null,null,"2017-06-15"]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A10)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A10))))),\"\",IF(ROW(A10)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A10)))))","v":"Tag der Dt. Einheit"},{"$nulls":6},"2017-10-03",null,null,null,"2017-10-03"]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A11)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A11))))),\"\",IF(ROW(A11)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A11)))))","v":"Allerheiligen"},{"$nulls":6},"2017-11-01",null,null,null,"2017-11-01"]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A12)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A12))))),\"\",IF(ROW(A12)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A12)))))","v":"1. Weihnachtstag"},{"$nulls":6},"2017-12-25",null,null,null,{"$f":"T75","v":"2017-12-25"}]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A13)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A13))))),\"\",IF(ROW(A13)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A13)))))","v":"2. Weihnachtstag"},{"$nulls":6},"2017-12-26",null,null,null,{"$f":"T76","v":"2017-12-26"}]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A14)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A14))))),\"\",IF(ROW(A14)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A14)))))","v":""},{"$nulls":6},"",null,null,null,{"$f":"T77","v":""}]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A15)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A15))))),\"\",IF(ROW(A15)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A15)))))","v":""},{"$nulls":6},{"$f":"IF(M78<>\"\",INDEX($B$12:$B$35,MATCH(M78,$C$12:$C$35,0)),\"\")","v":""},null,null,null,{"$f":"T78","v":""}]
[{"$nulls":12},{"$f":"IF(ISERROR(IF(ROW(A16)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A16))))),\"\",IF(ROW(A16)>COUNTA(C:C),\"\",INDEX(C:C,SMALL(IF(C$12:C$41<>\"\",ROW($12:$41)),ROW(A16)))))","v":""},{"$nulls":6},{"$f":"IF(M79<>\"\",INDEX($B$12:$B$35,MATCH(M79,$C$12:$C$35,0)),\"\")","v":""},null,null,null,{"$f":"T79","v":""}]

{"sheet":"Copyright","index":2,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Excel-Inside Solutions"]
[null,"Arbeitstage und gesetzliche Feiertage in DACH"]
[]
[null,"Version",":","2.00 · 190411"]
[]
[null,"Contact",":","Alois Eckl"]
[null,null,null,"Grabbestraße 25"]
[null,null,null,"90427 Nürnberg"]
[null,null,null,"Germany"]
[]
[null,"Mail",":","alois.eckl@excel-inside.de"]
[null,"Web",":","www.excel-inside.de"]
[]
[]
[null,"Copyright",":","© by Excel-Inside Solutions - All rights reserved"]
[]
[]
[]
[null,"Vollversion",":","Die Vollversion können Sie zum Preis von 14,90 €"]
[null,null,null,"per E-Mail an anfrage@excel-inside.de bestellen"]