{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Urlaubskalender"],"not_rendered":{"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Urlaubskalender","index":0,"n_rows":161,"n_cols":40,"rows_kept":161,"merged":[[4,34,4,36],[4,38,4,39]]}
[{"$nulls":32},"Urlaub",{"v":31,"d":"31 Tage"}]
[]
[]
[]
[2016,{"$nulls":6},"Legende",null,null,"U = Urlaub",{"$nulls":3},"K = Krankheit",{"$nulls":18},"Mitarbeiter/in","Urlaub",{"$nulls":3},"Krankheitstage"]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,1,1)","v":"2016-01-01"}]
[null,{"$f":"B11","v":"2016-01-01"},{"$f":"C11","v":"2016-01-02"},"2016-01-03","2016-01-04","2016-01-05","2016-01-06","2016-01-07","2016-01-08","2016-01-09","2016-01-10","2016-01-11","2016-01-12","2016-01-13","2016-01-14","2016-01-15","2016-01-16","2016-01-17","2016-01-18","2016-01-19","2016-01-20","2016-01-21","2016-01-22","2016-01-23","2016-01-24","2016-01-25","2016-01-26","2016-01-27","2016-01-28","2016-01-29","2016-01-30","2016-01-31",null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A9","v":"2016-01-01"},{"$f":"B11+1","v":"2016-01-02"},{"$f":"C11+1","v":"2016-01-03"},"2016-01-04","2016-01-05","2016-01-06","2016-01-07",{"$f":"H11+1","v":"2016-01-08"},"2016-01-09","2016-01-10","2016-01-11","2016-01-12","2016-01-13","2016-01-14","2016-01-15","2016-01-16","2016-01-17","2016-01-18","2016-01-19","2016-01-20","2016-01-21","2016-01-22","2016-01-23","2016-01-24","2016-01-25","2016-01-26","2016-01-27","2016-01-28",{"$f":"IF(DAY(DATE(YEAR($AC11),MONTH($AC11),DAY($AC11))+1)<4,\"\",AC11+1)","v":"2016-01-29"},{"$f":"IF(DAY(DATE(YEAR($AC11),MONTH($AC11),DAY($AC11))+2)<4,\"\",AD11+1)","v":"2016-01-30"},{"$f":"IF(DAY(DATE(YEAR($AC11),MONTH($AC11),DAY($AC11))+3)<4,\"\",AE11+1)","v":"2016-01-31"}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B12:$AF12,\"U\")","v":0},31,{"$f":"AJ12-AI12","v":31},null,{"$f":"COUNTIF($B12:$AF12,\"K\")","v":0},{"$f":"AM12","v":0}]
[{"$nulls":33},"Müller",0,31,{"$f":"AJ13-AI13","v":31},null,{"$f":"COUNTIF($B13:$AF13,\"K\")","v":0},{"$f":"AM13","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,{"$f":"COUNTIF($B14:$AF14,\"K\")","v":0},0]
[{"$nulls":33},"Meyer",0,31,31,null,{"$f":"COUNTIF($B15:$AF15,\"K\")","v":0},0]
[{"$nulls":33},"Meier",0,31,31,null,{"$f":"COUNTIF($B16:$AF16,\"K\")","v":0},0]
[{"$nulls":33},"x",0,31,31,null,{"$f":"COUNTIF($B17:$AF17,\"K\")","v":0},0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,2,1)","v":"2016-02-01"}]
[null,{"$f":"B24","v":"2016-02-01"},{"$f":"C24","v":"2016-02-02"},{"$f":"D24","v":"2016-02-03"},{"$f":"E24","v":"2016-02-04"},{"$f":"F24","v":"2016-02-05"},{"$f":"G24","v":"2016-02-06"},{"$f":"H24","v":"2016-02-07"},{"$f":"I24","v":"2016-02-08"},{"$f":"J24","v":"2016-02-09"},{"$f":"K24","v":"2016-02-10"},{"$f":"L24","v":"2016-02-11"},{"$f":"M24","v":"2016-02-12"},{"$f":"N24","v":"2016-02-13"},{"$f":"O24","v":"2016-02-14"},{"$f":"P24","v":"2016-02-15"},{"$f":"Q24","v":"2016-02-16"},{"$f":"R24","v":"2016-02-17"},{"$f":"S24","v":"2016-02-18"},{"$f":"T24","v":"2016-02-19"},{"$f":"U24","v":"2016-02-20"},{"$f":"V24","v":"2016-02-21"},{"$f":"W24","v":"2016-02-22"},{"$f":"X24","v":"2016-02-23"},{"$f":"Y24","v":"2016-02-24"},{"$f":"Z24","v":"2016-02-25"},{"$f":"AA24","v":"2016-02-26"},{"$f":"AB24","v":"2016-02-27"},{"$f":"AC24","v":"2016-02-28"},{"$f":"AD24","v":"2016-02-29"},{"$f":"AE24","v":""},{"$f":"AF24","v":""},null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A22","v":"2016-02-01"},{"$f":"B24+1","v":"2016-02-02"},{"$f":"C24+1","v":"2016-02-03"},"2016-02-04","2016-02-05","2016-02-06","2016-02-07",{"$f":"H24+1","v":"2016-02-08"},{"$f":"I24+1","v":"2016-02-09"},"2016-02-10","2016-02-11","2016-02-12","2016-02-13","2016-02-14","2016-02-15","2016-02-16","2016-02-17","2016-02-18","2016-02-19","2016-02-20","2016-02-21","2016-02-22","2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27","2016-02-28",{"$f":"IF(DAY(DATE(YEAR($AC24),MONTH($AC24),DAY($AC24))+1)<4,\"\",AC24+1)","v":"2016-02-29"},{"$f":"IF(DAY(DATE(YEAR($AC24),MONTH($AC24),DAY($AC24))+2)<4,\"\",AD24+1)","v":""},{"$f":"IF(DAY(DATE(YEAR($AC24),MONTH($AC24),DAY($AC24))+3)<4,\"\",AE24+1)","v":""}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B25:$AF25,\"U\")","v":0},{"$f":"AK12","v":31},{"$f":"AJ25-AI25","v":31},null,{"$f":"COUNTIF($B25:$AF25,\"K\")","v":0},{"$f":"AM25+AN12","v":0}]
[{"$nulls":33},"Müller",0,{"$f":"AK13","v":31},{"$f":"AJ26-AI26","v":31},null,{"$f":"COUNTIF($B26:$AF26,\"K\")","v":0},{"$f":"AM26+AN13","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,3,1)","v":"2016-03-01"}]
[null,{"$f":"B37","v":"2016-03-01"},{"$f":"C37","v":"2016-03-02"},{"$f":"D37","v":"2016-03-03"},{"$f":"E37","v":"2016-03-04"},{"$f":"F37","v":"2016-03-05"},{"$f":"G37","v":"2016-03-06"},{"$f":"H37","v":"2016-03-07"},{"$f":"I37","v":"2016-03-08"},{"$f":"J37","v":"2016-03-09"},{"$f":"K37","v":"2016-03-10"},{"$f":"L37","v":"2016-03-11"},{"$f":"M37","v":"2016-03-12"},{"$f":"N37","v":"2016-03-13"},{"$f":"O37","v":"2016-03-14"},{"$f":"P37","v":"2016-03-15"},{"$f":"Q37","v":"2016-03-16"},{"$f":"R37","v":"2016-03-17"},{"$f":"S37","v":"2016-03-18"},{"$f":"T37","v":"2016-03-19"},{"$f":"U37","v":"2016-03-20"},{"$f":"V37","v":"2016-03-21"},{"$f":"W37","v":"2016-03-22"},{"$f":"X37","v":"2016-03-23"},{"$f":"Y37","v":"2016-03-24"},{"$f":"Z37","v":"2016-03-25"},{"$f":"AA37","v":"2016-03-26"},{"$f":"AB37","v":"2016-03-27"},{"$f":"AC37","v":"2016-03-28"},{"$f":"AD37","v":"2016-03-29"},{"$f":"AE37","v":"2016-03-30"},{"$f":"AF37","v":"2016-03-31"},null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A35","v":"2016-03-01"},{"$f":"B37+1","v":"2016-03-02"},{"$f":"C37+1","v":"2016-03-03"},"2016-03-04","2016-03-05","2016-03-06","2016-03-07",{"$f":"H37+1","v":"2016-03-08"},{"$f":"I37+1","v":"2016-03-09"},"2016-03-10","2016-03-11","2016-03-12","2016-03-13","2016-03-14","2016-03-15","2016-03-16","2016-03-17","2016-03-18","2016-03-19","2016-03-20","2016-03-21","2016-03-22","2016-03-23","2016-03-24","2016-03-25","2016-03-26","2016-03-27","2016-03-28",{"$f":"IF(DAY(DATE(YEAR($AC$11),MONTH($AC$11),DAY($AC$11))+1)<4,\"\",AC37+1)","v":"2016-03-29"},{"$f":"IF(DAY(DATE(YEAR($AC37),MONTH($AC37),DAY($AC37))+2)<4,\"\",AD37+1)","v":"2016-03-30"},{"$f":"IF(DAY(DATE(YEAR($AC37),MONTH($AC37),DAY($AC37))+3)<4,\"\",AE37+1)","v":"2016-03-31"}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B38:$AF38,\"U\")","v":0},{"$f":"AK25","v":31},{"$f":"AJ38-AI38","v":31},null,{"$f":"COUNTIF($B38:$AF38,\"K\")","v":0},{"$f":"AM38+AN25","v":0}]
[{"$nulls":33},"Müller",0,{"$f":"AK26","v":31},{"$f":"AJ39-AI39","v":31},null,{"$f":"COUNTIF($B39:$AF39,\"K\")","v":0},{"$f":"AM39+AN26","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,4,1)","v":"2016-04-01"}]
[null,{"$f":"B50","v":"2016-04-01"},{"$f":"C50","v":"2016-04-02"},{"$f":"D50","v":"2016-04-03"},{"$f":"E50","v":"2016-04-04"},{"$f":"F50","v":"2016-04-05"},{"$f":"G50","v":"2016-04-06"},{"$f":"H50","v":"2016-04-07"},{"$f":"I50","v":"2016-04-08"},{"$f":"J50","v":"2016-04-09"},{"$f":"K50","v":"2016-04-10"},{"$f":"L50","v":"2016-04-11"},{"$f":"M50","v":"2016-04-12"},{"$f":"N50","v":"2016-04-13"},{"$f":"O50","v":"2016-04-14"},{"$f":"P50","v":"2016-04-15"},{"$f":"Q50","v":"2016-04-16"},{"$f":"R50","v":"2016-04-17"},{"$f":"S50","v":"2016-04-18"},{"$f":"T50","v":"2016-04-19"},{"$f":"U50","v":"2016-04-20"},{"$f":"V50","v":"2016-04-21"},{"$f":"W50","v":"2016-04-22"},{"$f":"X50","v":"2016-04-23"},{"$f":"Y50","v":"2016-04-24"},{"$f":"Z50","v":"2016-04-25"},{"$f":"AA50","v":"2016-04-26"},{"$f":"AB50","v":"2016-04-27"},{"$f":"AC50","v":"2016-04-28"},{"$f":"AD50","v":"2016-04-29"},{"$f":"AE50","v":"2016-04-30"},{"$f":"AF50","v":""},null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A48","v":"2016-04-01"},{"$f":"B50+1","v":"2016-04-02"},{"$f":"C50+1","v":"2016-04-03"},"2016-04-04","2016-04-05","2016-04-06","2016-04-07",{"$f":"H50+1","v":"2016-04-08"},{"$f":"I50+1","v":"2016-04-09"},"2016-04-10","2016-04-11","2016-04-12","2016-04-13","2016-04-14","2016-04-15","2016-04-16","2016-04-17","2016-04-18","2016-04-19","2016-04-20","2016-04-21","2016-04-22","2016-04-23","2016-04-24","2016-04-25","2016-04-26","2016-04-27","2016-04-28",{"$f":"IF(DAY(DATE(YEAR($AC$11),MONTH($AC$11),DAY($AC$11))+1)<4,\"\",AC50+1)","v":"2016-04-29"},{"$f":"IF(DAY(DATE(YEAR($AC50),MONTH($AC50),DAY($AC50))+2)<4,\"\",AD50+1)","v":"2016-04-30"},{"$f":"IF(DAY(DATE(YEAR($AC50),MONTH($AC50),DAY($AC50))+3)<4,\"\",AE50+1)","v":""}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B51:$AF51,\"U\")","v":0},{"$f":"AK38","v":31},{"$f":"AJ51-AI51","v":31},null,{"$f":"COUNTIF($B51:$AF51,\"K\")","v":0},{"$f":"AM51+AN38","v":0}]
[{"$nulls":33},"Müller",0,{"$f":"AK39","v":31},{"$f":"AJ52-AI52","v":31},null,{"$f":"COUNTIF($B52:$AF52,\"K\")","v":0},{"$f":"AM52+AN39","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,5,1)","v":"2016-05-01"}]
[null,{"$f":"B63","v":"2016-05-01"},{"$f":"C63","v":"2016-05-02"},{"$f":"D63","v":"2016-05-03"},{"$f":"E63","v":"2016-05-04"},{"$f":"F63","v":"2016-05-05"},{"$f":"G63","v":"2016-05-06"},{"$f":"H63","v":"2016-05-07"},{"$f":"I63","v":"2016-05-08"},{"$f":"J63","v":"2016-05-09"},{"$f":"K63","v":"2016-05-10"},{"$f":"L63","v":"2016-05-11"},{"$f":"M63","v":"2016-05-12"},{"$f":"N63","v":"2016-05-13"},{"$f":"O63","v":"2016-05-14"},{"$f":"P63","v":"2016-05-15"},{"$f":"Q63","v":"2016-05-16"},{"$f":"R63","v":"2016-05-17"},{"$f":"S63","v":"2016-05-18"},{"$f":"T63","v":"2016-05-19"},{"$f":"U63","v":"2016-05-20"},{"$f":"V63","v":"2016-05-21"},{"$f":"W63","v":"2016-05-22"},{"$f":"X63","v":"2016-05-23"},{"$f":"Y63","v":"2016-05-24"},{"$f":"Z63","v":"2016-05-25"},{"$f":"AA63","v":"2016-05-26"},{"$f":"AB63","v":"2016-05-27"},{"$f":"AC63","v":"2016-05-28"},{"$f":"AD63","v":"2016-05-29"},{"$f":"AE63","v":"2016-05-30"},{"$f":"AF63","v":"2016-05-31"},null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A61","v":"2016-05-01"},{"$f":"B63+1","v":"2016-05-02"},{"$f":"C63+1","v":"2016-05-03"},"2016-05-04","2016-05-05","2016-05-06","2016-05-07",{"$f":"H63+1","v":"2016-05-08"},{"$f":"I63+1","v":"2016-05-09"},"2016-05-10","2016-05-11","2016-05-12","2016-05-13","2016-05-14","2016-05-15","2016-05-16","2016-05-17","2016-05-18","2016-05-19","2016-05-20","2016-05-21","2016-05-22","2016-05-23","2016-05-24","2016-05-25","2016-05-26","2016-05-27","2016-05-28",{"$f":"IF(DAY(DATE(YEAR($AC$11),MONTH($AC$11),DAY($AC$11))+1)<4,\"\",AC63+1)","v":"2016-05-29"},{"$f":"IF(DAY(DATE(YEAR($AC63),MONTH($AC63),DAY($AC63))+2)<4,\"\",AD63+1)","v":"2016-05-30"},{"$f":"IF(DAY(DATE(YEAR($AC63),MONTH($AC63),DAY($AC63))+3)<4,\"\",AE63+1)","v":"2016-05-31"}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B64:$AF64,\"U\")","v":0},{"$f":"AK51","v":31},{"$f":"AJ64-AI64","v":31},null,{"$f":"COUNTIF($B64:$AF64,\"K\")","v":0},{"$f":"AM64+AN51","v":0}]
[{"$nulls":33},"Müller",0,{"$f":"AK52","v":31},{"$f":"AJ65-AI65","v":31},null,{"$f":"COUNTIF($B65:$AF65,\"K\")","v":0},{"$f":"AM65+AN52","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,6,1)","v":"2016-06-01"}]
[null,{"$f":"B76","v":"2016-06-01"},{"$f":"C76","v":"2016-06-02"},{"$f":"D76","v":"2016-06-03"},{"$f":"E76","v":"2016-06-04"},{"$f":"F76","v":"2016-06-05"},{"$f":"G76","v":"2016-06-06"},{"$f":"H76","v":"2016-06-07"},{"$f":"I76","v":"2016-06-08"},{"$f":"J76","v":"2016-06-09"},{"$f":"K76","v":"2016-06-10"},{"$f":"L76","v":"2016-06-11"},{"$f":"M76","v":"2016-06-12"},{"$f":"N76","v":"2016-06-13"},{"$f":"O76","v":"2016-06-14"},{"$f":"P76","v":"2016-06-15"},{"$f":"Q76","v":"2016-06-16"},{"$f":"R76","v":"2016-06-17"},{"$f":"S76","v":"2016-06-18"},{"$f":"T76","v":"2016-06-19"},{"$f":"U76","v":"2016-06-20"},{"$f":"V76","v":"2016-06-21"},{"$f":"W76","v":"2016-06-22"},{"$f":"X76","v":"2016-06-23"},{"$f":"Y76","v":"2016-06-24"},{"$f":"Z76","v":"2016-06-25"},{"$f":"AA76","v":"2016-06-26"},{"$f":"AB76","v":"2016-06-27"},{"$f":"AC76","v":"2016-06-28"},{"$f":"AD76","v":"2016-06-29"},{"$f":"AE76","v":"2016-06-30"},{"$f":"AF76","v":""},null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A74","v":"2016-06-01"},{"$f":"B76+1","v":"2016-06-02"},{"$f":"C76+1","v":"2016-06-03"},"2016-06-04","2016-06-05","2016-06-06","2016-06-07",{"$f":"H76+1","v":"2016-06-08"},{"$f":"I76+1","v":"2016-06-09"},"2016-06-10","2016-06-11","2016-06-12","2016-06-13","2016-06-14","2016-06-15","2016-06-16","2016-06-17","2016-06-18","2016-06-19","2016-06-20","2016-06-21","2016-06-22","2016-06-23","2016-06-24","2016-06-25","2016-06-26","2016-06-27","2016-06-28",{"$f":"IF(DAY(DATE(YEAR($AC$11),MONTH($AC$11),DAY($AC$11))+1)<4,\"\",AC76+1)","v":"2016-06-29"},{"$f":"IF(DAY(DATE(YEAR($AC76),MONTH($AC76),DAY($AC76))+2)<4,\"\",AD76+1)","v":"2016-06-30"},{"$f":"IF(DAY(DATE(YEAR($AC76),MONTH($AC76),DAY($AC76))+3)<4,\"\",AE76+1)","v":""}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B77:$AF77,\"U\")","v":0},{"$f":"AK64","v":31},{"$f":"AJ77-AI77","v":31},null,{"$f":"COUNTIF($B77:$AF77,\"K\")","v":0},{"$f":"AM77+AN64","v":0}]
[{"$nulls":33},"Müller",0,{"$f":"AK65","v":31},{"$f":"AJ78-AI78","v":31},null,{"$f":"COUNTIF($B78:$AF78,\"K\")","v":0},{"$f":"AM78+AN65","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,7,1)","v":"2016-07-01"}]
[null,{"$f":"B89","v":"2016-07-01"},{"$f":"C89","v":"2016-07-02"},{"$f":"D89","v":"2016-07-03"},{"$f":"E89","v":"2016-07-04"},{"$f":"F89","v":"2016-07-05"},{"$f":"G89","v":"2016-07-06"},{"$f":"H89","v":"2016-07-07"},{"$f":"I89","v":"2016-07-08"},{"$f":"J89","v":"2016-07-09"},{"$f":"K89","v":"2016-07-10"},{"$f":"L89","v":"2016-07-11"},{"$f":"M89","v":"2016-07-12"},{"$f":"N89","v":"2016-07-13"},{"$f":"O89","v":"2016-07-14"},{"$f":"P89","v":"2016-07-15"},{"$f":"Q89","v":"2016-07-16"},{"$f":"R89","v":"2016-07-17"},{"$f":"S89","v":"2016-07-18"},{"$f":"T89","v":"2016-07-19"},{"$f":"U89","v":"2016-07-20"},{"$f":"V89","v":"2016-07-21"},{"$f":"W89","v":"2016-07-22"},{"$f":"X89","v":"2016-07-23"},{"$f":"Y89","v":"2016-07-24"},{"$f":"Z89","v":"2016-07-25"},{"$f":"AA89","v":"2016-07-26"},{"$f":"AB89","v":"2016-07-27"},{"$f":"AC89","v":"2016-07-28"},{"$f":"AD89","v":"2016-07-29"},{"$f":"AE89","v":"2016-07-30"},{"$f":"AF89","v":"2016-07-31"},null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A87","v":"2016-07-01"},{"$f":"B89+1","v":"2016-07-02"},{"$f":"C89+1","v":"2016-07-03"},"2016-07-04","2016-07-05","2016-07-06","2016-07-07",{"$f":"H89+1","v":"2016-07-08"},{"$f":"I89+1","v":"2016-07-09"},"2016-07-10","2016-07-11","2016-07-12","2016-07-13","2016-07-14","2016-07-15","2016-07-16","2016-07-17","2016-07-18","2016-07-19","2016-07-20","2016-07-21","2016-07-22","2016-07-23","2016-07-24","2016-07-25","2016-07-26","2016-07-27","2016-07-28",{"$f":"IF(DAY(DATE(YEAR($AC$11),MONTH($AC$11),DAY($AC$11))+1)<4,\"\",AC89+1)","v":"2016-07-29"},{"$f":"IF(DAY(DATE(YEAR($AC89),MONTH($AC89),DAY($AC89))+2)<4,\"\",AD89+1)","v":"2016-07-30"},{"$f":"IF(DAY(DATE(YEAR($AC89),MONTH($AC89),DAY($AC89))+3)<4,\"\",AE89+1)","v":"2016-07-31"}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B90:$AF90,\"U\")","v":0},{"$f":"AK77","v":31},{"$f":"AJ90-AI90","v":31},null,{"$f":"COUNTIF($B90:$AF90,\"K\")","v":0},{"$f":"AM90+AN77","v":0}]
[{"$nulls":33},"Müller",0,{"$f":"AK78","v":31},{"$f":"AJ91-AI91","v":31},null,{"$f":"COUNTIF($B91:$AF91,\"K\")","v":0},{"$f":"AM91+AN78","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,8,1)","v":"2016-08-01"}]
[null,{"$f":"B102","v":"2016-08-01"},{"$f":"C102","v":"2016-08-02"},{"$f":"D102","v":"2016-08-03"},{"$f":"E102","v":"2016-08-04"},{"$f":"F102","v":"2016-08-05"},{"$f":"G102","v":"2016-08-06"},{"$f":"H102","v":"2016-08-07"},{"$f":"I102","v":"2016-08-08"},{"$f":"J102","v":"2016-08-09"},{"$f":"K102","v":"2016-08-10"},{"$f":"L102","v":"2016-08-11"},{"$f":"M102","v":"2016-08-12"},{"$f":"N102","v":"2016-08-13"},{"$f":"O102","v":"2016-08-14"},{"$f":"P102","v":"2016-08-15"},{"$f":"Q102","v":"2016-08-16"},{"$f":"R102","v":"2016-08-17"},{"$f":"S102","v":"2016-08-18"},{"$f":"T102","v":"2016-08-19"},{"$f":"U102","v":"2016-08-20"},{"$f":"V102","v":"2016-08-21"},{"$f":"W102","v":"2016-08-22"},{"$f":"X102","v":"2016-08-23"},{"$f":"Y102","v":"2016-08-24"},{"$f":"Z102","v":"2016-08-25"},{"$f":"AA102","v":"2016-08-26"},{"$f":"AB102","v":"2016-08-27"},{"$f":"AC102","v":"2016-08-28"},{"$f":"AD102","v":"2016-08-29"},{"$f":"AE102","v":"2016-08-30"},{"$f":"AF102","v":"2016-08-31"},null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A100","v":"2016-08-01"},{"$f":"B102+1","v":"2016-08-02"},{"$f":"C102+1","v":"2016-08-03"},"2016-08-04","2016-08-05","2016-08-06","2016-08-07",{"$f":"H102+1","v":"2016-08-08"},{"$f":"I102+1","v":"2016-08-09"},"2016-08-10","2016-08-11","2016-08-12","2016-08-13","2016-08-14","2016-08-15","2016-08-16","2016-08-17","2016-08-18","2016-08-19","2016-08-20","2016-08-21","2016-08-22","2016-08-23","2016-08-24","2016-08-25","2016-08-26","2016-08-27","2016-08-28",{"$f":"IF(DAY(DATE(YEAR($AC$11),MONTH($AC$11),DAY($AC$11))+1)<4,\"\",AC102+1)","v":"2016-08-29"},{"$f":"IF(DAY(DATE(YEAR($AC102),MONTH($AC102),DAY($AC102))+2)<4,\"\",AD102+1)","v":"2016-08-30"},{"$f":"IF(DAY(DATE(YEAR($AC102),MONTH($AC102),DAY($AC102))+3)<4,\"\",AE102+1)","v":"2016-08-31"}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B103:$AF103,\"U\")","v":0},{"$f":"AK90","v":31},{"$f":"AJ103-AI103","v":31},null,{"$f":"COUNTIF($B103:$AF103,\"K\")","v":0},{"$f":"AM103+AN90","v":0}]
[{"$nulls":33},"Müller",0,{"$f":"AK91","v":31},{"$f":"AJ104-AI104","v":31},null,{"$f":"COUNTIF($B104:$AF104,\"K\")","v":0},{"$f":"AM104+AN91","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,9,1)","v":"2016-09-01"}]
[null,{"$f":"B115","v":"2016-09-01"},{"$f":"C115","v":"2016-09-02"},{"$f":"D115","v":"2016-09-03"},{"$f":"E115","v":"2016-09-04"},{"$f":"F115","v":"2016-09-05"},{"$f":"G115","v":"2016-09-06"},{"$f":"H115","v":"2016-09-07"},{"$f":"I115","v":"2016-09-08"},{"$f":"J115","v":"2016-09-09"},{"$f":"K115","v":"2016-09-10"},{"$f":"L115","v":"2016-09-11"},{"$f":"M115","v":"2016-09-12"},{"$f":"N115","v":"2016-09-13"},{"$f":"O115","v":"2016-09-14"},{"$f":"P115","v":"2016-09-15"},{"$f":"Q115","v":"2016-09-16"},{"$f":"R115","v":"2016-09-17"},{"$f":"S115","v":"2016-09-18"},{"$f":"T115","v":"2016-09-19"},{"$f":"U115","v":"2016-09-20"},{"$f":"V115","v":"2016-09-21"},{"$f":"W115","v":"2016-09-22"},{"$f":"X115","v":"2016-09-23"},{"$f":"Y115","v":"2016-09-24"},{"$f":"Z115","v":"2016-09-25"},{"$f":"AA115","v":"2016-09-26"},{"$f":"AB115","v":"2016-09-27"},{"$f":"AC115","v":"2016-09-28"},{"$f":"AD115","v":"2016-09-29"},{"$f":"AE115","v":"2016-09-30"},{"$f":"AF115","v":""},null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A113","v":"2016-09-01"},{"$f":"B115+1","v":"2016-09-02"},{"$f":"C115+1","v":"2016-09-03"},"2016-09-04","2016-09-05","2016-09-06","2016-09-07",{"$f":"H115+1","v":"2016-09-08"},{"$f":"I115+1","v":"2016-09-09"},"2016-09-10","2016-09-11","2016-09-12","2016-09-13","2016-09-14","2016-09-15","2016-09-16","2016-09-17","2016-09-18","2016-09-19","2016-09-20","2016-09-21","2016-09-22","2016-09-23","2016-09-24","2016-09-25","2016-09-26","2016-09-27","2016-09-28",{"$f":"IF(DAY(DATE(YEAR($AC$11),MONTH($AC$11),DAY($AC$11))+1)<4,\"\",AC115+1)","v":"2016-09-29"},{"$f":"IF(DAY(DATE(YEAR($AC115),MONTH($AC115),DAY($AC115))+2)<4,\"\",AD115+1)","v":"2016-09-30"},{"$f":"IF(DAY(DATE(YEAR($AC115),MONTH($AC115),DAY($AC115))+3)<4,\"\",AE115+1)","v":""}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B116:$AF116,\"U\")","v":0},{"$f":"AK103","v":31},{"$f":"AJ116-AI116","v":31},null,{"$f":"COUNTIF($B116:$AF116,\"K\")","v":0},{"$f":"AM116+AN103","v":0}]
[{"$nulls":33},"Müller",0,{"$f":"AK104","v":31},{"$f":"AJ117-AI117","v":31},null,{"$f":"COUNTIF($B117:$AF117,\"K\")","v":0},{"$f":"AM117+AN104","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,10,1)","v":"2016-10-01"}]
[null,{"$f":"B128","v":"2016-10-01"},{"$f":"C128","v":"2016-10-02"},{"$f":"D128","v":"2016-10-03"},{"$f":"E128","v":"2016-10-04"},{"$f":"F128","v":"2016-10-05"},{"$f":"G128","v":"2016-10-06"},{"$f":"H128","v":"2016-10-07"},{"$f":"I128","v":"2016-10-08"},{"$f":"J128","v":"2016-10-09"},{"$f":"K128","v":"2016-10-10"},{"$f":"L128","v":"2016-10-11"},{"$f":"M128","v":"2016-10-12"},{"$f":"N128","v":"2016-10-13"},{"$f":"O128","v":"2016-10-14"},{"$f":"P128","v":"2016-10-15"},{"$f":"Q128","v":"2016-10-16"},{"$f":"R128","v":"2016-10-17"},{"$f":"S128","v":"2016-10-18"},{"$f":"T128","v":"2016-10-19"},{"$f":"U128","v":"2016-10-20"},{"$f":"V128","v":"2016-10-21"},{"$f":"W128","v":"2016-10-22"},{"$f":"X128","v":"2016-10-23"},{"$f":"Y128","v":"2016-10-24"},{"$f":"Z128","v":"2016-10-25"},{"$f":"AA128","v":"2016-10-26"},{"$f":"AB128","v":"2016-10-27"},{"$f":"AC128","v":"2016-10-28"},{"$f":"AD128","v":"2016-10-29"},{"$f":"AE128","v":"2016-10-30"},{"$f":"AF128","v":"2016-10-31"},null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A126","v":"2016-10-01"},{"$f":"B128+1","v":"2016-10-02"},{"$f":"C128+1","v":"2016-10-03"},"2016-10-04","2016-10-05","2016-10-06","2016-10-07",{"$f":"H128+1","v":"2016-10-08"},{"$f":"I128+1","v":"2016-10-09"},"2016-10-10","2016-10-11","2016-10-12","2016-10-13","2016-10-14","2016-10-15","2016-10-16","2016-10-17","2016-10-18","2016-10-19","2016-10-20","2016-10-21","2016-10-22","2016-10-23","2016-10-24","2016-10-25","2016-10-26","2016-10-27","2016-10-28",{"$f":"IF(DAY(DATE(YEAR($AC$11),MONTH($AC$11),DAY($AC$11))+1)<4,\"\",AC128+1)","v":"2016-10-29"},{"$f":"IF(DAY(DATE(YEAR($AC128),MONTH($AC128),DAY($AC128))+2)<4,\"\",AD128+1)","v":"2016-10-30"},{"$f":"IF(DAY(DATE(YEAR($AC128),MONTH($AC128),DAY($AC128))+3)<4,\"\",AE128+1)","v":"2016-10-31"}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B129:$AF129,\"U\")","v":0},{"$f":"AK116","v":31},{"$f":"AJ129-AI129","v":31},null,{"$f":"COUNTIF($B129:$AF129,\"K\")","v":0},{"$f":"AM129+AN116","v":0}]
[{"$nulls":33},"Müller",0,{"$f":"AK117","v":31},{"$f":"AJ130-AI130","v":31},null,{"$f":"COUNTIF($B130:$AF130,\"K\")","v":0},{"$f":"AM130+AN117","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,11,1)","v":"2016-11-01"}]
[null,{"$f":"B141","v":"2016-11-01"},"2016-11-02","2016-11-03","2016-11-04","2016-11-05","2016-11-06","2016-11-07","2016-11-08","2016-11-09","2016-11-10","2016-11-11","2016-11-12","2016-11-13","2016-11-14","2016-11-15","2016-11-16","2016-11-17","2016-11-18","2016-11-19","2016-11-20","2016-11-21","2016-11-22","2016-11-23","2016-11-24","2016-11-25","2016-11-26","2016-11-27","2016-11-28","2016-11-29","2016-11-30","",null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A139","v":"2016-11-01"},{"$f":"B141+1","v":"2016-11-02"},{"$f":"C141+1","v":"2016-11-03"},"2016-11-04","2016-11-05","2016-11-06","2016-11-07",{"$f":"H141+1","v":"2016-11-08"},{"$f":"I141+1","v":"2016-11-09"},"2016-11-10","2016-11-11","2016-11-12","2016-11-13","2016-11-14","2016-11-15","2016-11-16","2016-11-17","2016-11-18","2016-11-19","2016-11-20","2016-11-21","2016-11-22","2016-11-23","2016-11-24","2016-11-25","2016-11-26","2016-11-27","2016-11-28",{"$f":"IF(DAY(DATE(YEAR($AC$11),MONTH($AC$11),DAY($AC$11))+1)<4,\"\",AC141+1)","v":"2016-11-29"},{"$f":"IF(DAY(DATE(YEAR($AC141),MONTH($AC141),DAY($AC141))+2)<4,\"\",AD141+1)","v":"2016-11-30"},{"$f":"IF(DAY(DATE(YEAR($AC141),MONTH($AC141),DAY($AC141))+3)<4,\"\",AE141+1)","v":""}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B142:$AF142,\"U\")","v":0},{"$f":"AK129","v":31},{"$f":"AJ142-AI142","v":31},null,{"$f":"COUNTIF($B142:$AF142,\"K\")","v":0},{"$f":"AM142+AN129","v":0}]
[{"$nulls":33},"Müller",0,{"$f":"AK130","v":31},{"$f":"AJ143-AI143","v":31},null,0,{"$f":"AM143+AN130","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]
[]
[]
[]
[{"$f":"DATE(Kalenderjahr,12,1)","v":"2016-12-01"}]
[null,{"$f":"B154","v":"2016-12-01"},{"$f":"C154","v":"2016-12-02"},{"$f":"D154","v":"2016-12-03"},{"$f":"E154","v":"2016-12-04"},{"$f":"F154","v":"2016-12-05"},{"$f":"G154","v":"2016-12-06"},{"$f":"H154","v":"2016-12-07"},{"$f":"I154","v":"2016-12-08"},{"$f":"J154","v":"2016-12-09"},{"$f":"K154","v":"2016-12-10"},{"$f":"L154","v":"2016-12-11"},{"$f":"M154","v":"2016-12-12"},{"$f":"N154","v":"2016-12-13"},{"$f":"O154","v":"2016-12-14"},{"$f":"P154","v":"2016-12-15"},{"$f":"Q154","v":"2016-12-16"},{"$f":"R154","v":"2016-12-17"},{"$f":"S154","v":"2016-12-18"},{"$f":"T154","v":"2016-12-19"},{"$f":"U154","v":"2016-12-20"},{"$f":"V154","v":"2016-12-21"},{"$f":"W154","v":"2016-12-22"},{"$f":"X154","v":"2016-12-23"},{"$f":"Y154","v":"2016-12-24"},{"$f":"Z154","v":"2016-12-25"},{"$f":"AA154","v":"2016-12-26"},{"$f":"AB154","v":"2016-12-27"},{"$f":"AC154","v":"2016-12-28"},{"$f":"AD154","v":"2016-12-29"},{"$f":"AE154","v":"2016-12-30"},{"$f":"AF154","v":"2016-12-31"},null,null,"Urlaubstage","Urlaub aktuell","Resturlaub",null,"Krankheitstage","Summe"]
[null,{"$f":"A152","v":"2016-12-01"},{"$f":"B154+1","v":"2016-12-02"},{"$f":"C154+1","v":"2016-12-03"},"2016-12-04","2016-12-05","2016-12-06","2016-12-07",{"$f":"H154+1","v":"2016-12-08"},{"$f":"I154+1","v":"2016-12-09"},"2016-12-10","2016-12-11","2016-12-12","2016-12-13","2016-12-14","2016-12-15","2016-12-16","2016-12-17","2016-12-18","2016-12-19","2016-12-20","2016-12-21","2016-12-22","2016-12-23","2016-12-24","2016-12-25","2016-12-26","2016-12-27","2016-12-28",{"$f":"IF(DAY(DATE(YEAR($AC$11),MONTH($AC$11),DAY($AC$11))+1)<4,\"\",AC154+1)","v":"2016-12-29"},{"$f":"IF(DAY(DATE(YEAR($AC154),MONTH($AC154),DAY($AC154))+2)<4,\"\",AD154+1)","v":"2016-12-30"},{"$f":"IF(DAY(DATE(YEAR($AC154),MONTH($AC154),DAY($AC154))+3)<4,\"\",AE154+1)","v":"2016-12-31"}]
[{"$nulls":33},"Lehmann",{"$f":"COUNTIF($B155:$AF155,\"U\")","v":0},{"$f":"AK142","v":31},{"$f":"AJ155-AI155","v":31},null,{"$f":"COUNTIF($B155:$AF155,\"K\")","v":0},{"$f":"AM155+AN142","v":0}]
[{"$nulls":33},"Müller",0,31,{"$f":"AJ156-AI156","v":31},null,0,{"$f":"AM156+AN143","v":0}]
[{"$nulls":33},"Maier",0,31,31,null,0,0]
[{"$nulls":33},"Meyer",0,31,31,null,0,0]
[{"$nulls":33},"Meier",0,31,31,null,0,0]
[{"$nulls":33},"x",0,31,31,null,0,0]
[{"$nulls":33},"y",0,31,31,null,0,0]