{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Daten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Daten","index":0,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"endlastyear","startq1","endq1","startq2","endq2","startq3","endq3","startq4","endq4"]
[null,"2012-12-31","2013-01-01","2013-03-31","2013-04-01","2013-06-30","2013-07-01","2013-09-30","2013-10-01","2013-12-31"]
[null,null,null,{"$f":"endq1-Endlastyear","v":90},null,{"$f":"endq2-endq1","v":91},null,{"$f":"endq3-endq2","v":92},null,{"$f":"endq4-endq3","v":92}]
[]
[null,"Name","Sortier-Spalte","Start","Ende","Tage","Color","Description","Q1","Q1e","Q1-Final","Q2","Q2e","Q2-Final","Q3","Q3e","Q3-Final","Q4","Q4e","Q4-Final"]
[null,"Neujahr",1,"2013-01-01","2013-01-01",{"$f":"Tabelle1[[#This Row],[Ende]]-Tabelle1[[#This Row],[Start]]+1","v":1},"red","Neujahr",{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>Endlastyear,Tabelle1[[#This Row],[Start]]<=endq1),Tabelle1[[#This Row],[Start]]-Endlastyear,\"\")","v":1},{"$f":"IF(Tabelle1[[#This Row],[Ende]]<=endq1,Tabelle1[[#This Row],[Ende]]-Endlastyear,IF(Tabelle1[[#This Row],[Start]]<endq1,endq1-Endlastyear,\"\"))","v":1},{"$f":"IF(Tabelle1[[#This Row],[Q1]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q1]]&\"}{\"& Tabelle1[[#This Row],[Q1e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(K7)),\"\")","v":"\\ganttbar[bar/.style={fill=red}]{Neujahr}{1}{1}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq1,Tabelle1[[#This Row],[Start]]<=endq2),Tabelle1[[#This Row],[Start]]-endq1,IF(AND(Tabelle1[[#This Row],[Start]]<=endq1,Tabelle1[[#This Row],[Ende]]>endq1),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq1,Tabelle1[[#This Row],[Ende]]<=endq2),Tabelle1[[#This Row],[Ende]]-endq1,IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Start]]<endq2),endq2-endq1,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q2]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q2]]&\"}{\"& Tabelle1[[#This Row],[Q2e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(N7)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq2,Tabelle1[[#This Row],[Start]]<=endq3),Tabelle1[[#This Row],[Start]]-endq2,IF(AND(Tabelle1[[#This Row],[Start]]<=endq2,Tabelle1[[#This Row],[Ende]]>endq2),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Ende]]<=endq3),Tabelle1[[#This Row],[Ende]]-endq2,IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Start]]<endq3),endq3-endq2,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q3]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q3]]&\"}{\"& Tabelle1[[#This Row],[Q3e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(Q7)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq3,Tabelle1[[#This Row],[Start]]<=endq4),Tabelle1[[#This Row],[Start]]-endq3,IF(AND(Tabelle1[[#This Row],[Start]]<=endq3,Tabelle1[[#This Row],[Ende]]>endq3),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Ende]]<=endq4),Tabelle1[[#This Row],[Ende]]-endq3,IF(AND(Tabelle1[[#This Row],[Ende]]>endq4,Tabelle1[[#This Row],[Start]]<endq4),endq4-endq3,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q4]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q4]]&\"}{\"& Tabelle1[[#This Row],[Q4e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(T7)),\"\")","v":""}]
[null,"Feiertag",1,"2013-02-11","2013-02-11",{"$f":"Tabelle1[[#This Row],[Ende]]-Tabelle1[[#This Row],[Start]]+1","v":1},"yellow","Rosenmontag",{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>Endlastyear,Tabelle1[[#This Row],[Start]]<=endq1),Tabelle1[[#This Row],[Start]]-Endlastyear,\"\")","v":42},{"$f":"IF(Tabelle1[[#This Row],[Ende]]<=endq1,Tabelle1[[#This Row],[Ende]]-Endlastyear,IF(Tabelle1[[#This Row],[Start]]<endq1,endq1-Endlastyear,\"\"))","v":42},{"$f":"IF(Tabelle1[[#This Row],[Q1]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q1]]&\"}{\"& Tabelle1[[#This Row],[Q1e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(K8)),\"\")","v":"\\ganttbar[bar/.style={fill=yellow}]{Feiertag}{42}{42}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq1,Tabelle1[[#This Row],[Start]]<=endq2),Tabelle1[[#This Row],[Start]]-endq1,IF(AND(Tabelle1[[#This Row],[Start]]<=endq1,Tabelle1[[#This Row],[Ende]]>endq1),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq1,Tabelle1[[#This Row],[Ende]]<=endq2),Tabelle1[[#This Row],[Ende]]-endq1,IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Start]]<endq2),endq2-endq1,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q2]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q2]]&\"}{\"& Tabelle1[[#This Row],[Q2e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(N8)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq2,Tabelle1[[#This Row],[Start]]<=endq3),Tabelle1[[#This Row],[Start]]-endq2,IF(AND(Tabelle1[[#This Row],[Start]]<=endq2,Tabelle1[[#This Row],[Ende]]>endq2),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Ende]]<=endq3),Tabelle1[[#This Row],[Ende]]-endq2,IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Start]]<endq3),endq3-endq2,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q3]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q3]]&\"}{\"& Tabelle1[[#This Row],[Q3e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(Q8)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq3,Tabelle1[[#This Row],[Start]]<=endq4),Tabelle1[[#This Row],[Start]]-endq3,IF(AND(Tabelle1[[#This Row],[Start]]<=endq3,Tabelle1[[#This Row],[Ende]]>endq3),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Ende]]<=endq4),Tabelle1[[#This Row],[Ende]]-endq3,IF(AND(Tabelle1[[#This Row],[Ende]]>endq4,Tabelle1[[#This Row],[Start]]<endq4),endq4-endq3,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q4]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q4]]&\"}{\"& Tabelle1[[#This Row],[Q4e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(T8)),\"\")","v":""}]
[null,"Feiertag",2,"2013-03-29","2013-03-29",{"$f":"Tabelle1[[#This Row],[Ende]]-Tabelle1[[#This Row],[Start]]+1","v":1},"red","Karfreitag",{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>Endlastyear,Tabelle1[[#This Row],[Start]]<=endq1),Tabelle1[[#This Row],[Start]]-Endlastyear,\"\")","v":88},{"$f":"IF(Tabelle1[[#This Row],[Ende]]<=endq1,Tabelle1[[#This Row],[Ende]]-Endlastyear,IF(Tabelle1[[#This Row],[Start]]<endq1,endq1-Endlastyear,\"\"))","v":88},{"$f":"IF(Tabelle1[[#This Row],[Q1]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q1]]&\"}{\"& Tabelle1[[#This Row],[Q1e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(K9)),\"\")","v":"\\ganttbar[bar/.style={fill=red}]{Feiertag}{88}{88}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq1,Tabelle1[[#This Row],[Start]]<=endq2),Tabelle1[[#This Row],[Start]]-endq1,IF(AND(Tabelle1[[#This Row],[Start]]<=endq1,Tabelle1[[#This Row],[Ende]]>endq1),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq1,Tabelle1[[#This Row],[Ende]]<=endq2),Tabelle1[[#This Row],[Ende]]-endq1,IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Start]]<endq2),endq2-endq1,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q2]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q2]]&\"}{\"& Tabelle1[[#This Row],[Q2e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(N9)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq2,Tabelle1[[#This Row],[Start]]<=endq3),Tabelle1[[#This Row],[Start]]-endq2,IF(AND(Tabelle1[[#This Row],[Start]]<=endq2,Tabelle1[[#This Row],[Ende]]>endq2),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Ende]]<=endq3),Tabelle1[[#This Row],[Ende]]-endq2,IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Start]]<endq3),endq3-endq2,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q3]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q3]]&\"}{\"& Tabelle1[[#This Row],[Q3e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(Q9)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq3,Tabelle1[[#This Row],[Start]]<=endq4),Tabelle1[[#This Row],[Start]]-endq3,IF(AND(Tabelle1[[#This Row],[Start]]<=endq3,Tabelle1[[#This Row],[Ende]]>endq3),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Ende]]<=endq4),Tabelle1[[#This Row],[Ende]]-endq3,IF(AND(Tabelle1[[#This Row],[Ende]]>endq4,Tabelle1[[#This Row],[Start]]<endq4),endq4-endq3,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q4]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q4]]&\"}{\"& Tabelle1[[#This Row],[Q4e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(T9)),\"\")","v":""}]
[null,"Feiertag",2,"2013-04-01","2013-04-01",{"$f":"Tabelle1[[#This Row],[Ende]]-Tabelle1[[#This Row],[Start]]+1","v":1},"yellow","Ostermontag",{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>Endlastyear,Tabelle1[[#This Row],[Start]]<=endq1),Tabelle1[[#This Row],[Start]]-Endlastyear,\"\")","v":""},{"$f":"IF(Tabelle1[[#This Row],[Ende]]<=endq1,Tabelle1[[#This Row],[Ende]]-Endlastyear,IF(Tabelle1[[#This Row],[Start]]<endq1,endq1-Endlastyear,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q1]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q1]]&\"}{\"& Tabelle1[[#This Row],[Q1e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(K10)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq1,Tabelle1[[#This Row],[Start]]<=endq2),Tabelle1[[#This Row],[Start]]-endq1,IF(AND(Tabelle1[[#This Row],[Start]]<=endq1,Tabelle1[[#This Row],[Ende]]>endq1),1,\"\"))","v":1},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq1,Tabelle1[[#This Row],[Ende]]<=endq2),Tabelle1[[#This Row],[Ende]]-endq1,IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Start]]<endq2),endq2-endq1,\"\"))","v":1},{"$f":"IF(Tabelle1[[#This Row],[Q2]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q2]]&\"}{\"& Tabelle1[[#This Row],[Q2e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(N10)),\"\")","v":"\\ganttbar[bar/.style={fill=yellow}]{Feiertag}{1}{1}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq2,Tabelle1[[#This Row],[Start]]<=endq3),Tabelle1[[#This Row],[Start]]-endq2,IF(AND(Tabelle1[[#This Row],[Start]]<=endq2,Tabelle1[[#This Row],[Ende]]>endq2),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Ende]]<=endq3),Tabelle1[[#This Row],[Ende]]-endq2,IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Start]]<endq3),endq3-endq2,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q3]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q3]]&\"}{\"& Tabelle1[[#This Row],[Q3e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(Q10)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq3,Tabelle1[[#This Row],[Start]]<=endq4),Tabelle1[[#This Row],[Start]]-endq3,IF(AND(Tabelle1[[#This Row],[Start]]<=endq3,Tabelle1[[#This Row],[Ende]]>endq3),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Ende]]<=endq4),Tabelle1[[#This Row],[Ende]]-endq3,IF(AND(Tabelle1[[#This Row],[Ende]]>endq4,Tabelle1[[#This Row],[Start]]<endq4),endq4-endq3,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q4]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q4]]&\"}{\"& Tabelle1[[#This Row],[Q4e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(T10)),\"\")","v":""}]
[null,"Tag der Arbeit",3,"2013-05-01","2013-05-01",{"$f":"Tabelle1[[#This Row],[Ende]]-Tabelle1[[#This Row],[Start]]+1","v":1},"red","Tag der Arbeit",{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>Endlastyear,Tabelle1[[#This Row],[Start]]<=endq1),Tabelle1[[#This Row],[Start]]-Endlastyear,\"\")","v":""},{"$f":"IF(Tabelle1[[#This Row],[Ende]]<=endq1,Tabelle1[[#This Row],[Ende]]-Endlastyear,IF(Tabelle1[[#This Row],[Start]]<endq1,endq1-Endlastyear,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q1]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q1]]&\"}{\"& Tabelle1[[#This Row],[Q1e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(K11)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq1,Tabelle1[[#This Row],[Start]]<=endq2),Tabelle1[[#This Row],[Start]]-endq1,IF(AND(Tabelle1[[#This Row],[Start]]<=endq1,Tabelle1[[#This Row],[Ende]]>endq1),1,\"\"))","v":31},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq1,Tabelle1[[#This Row],[Ende]]<=endq2),Tabelle1[[#This Row],[Ende]]-endq1,IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Start]]<endq2),endq2-endq1,\"\"))","v":31},{"$f":"IF(Tabelle1[[#This Row],[Q2]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q2]]&\"}{\"& Tabelle1[[#This Row],[Q2e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(N11)),\"\")","v":"\\ganttbar[bar/.style={fill=red}]{Tag der Arbeit}{31}{31}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq2,Tabelle1[[#This Row],[Start]]<=endq3),Tabelle1[[#This Row],[Start]]-endq2,IF(AND(Tabelle1[[#This Row],[Start]]<=endq2,Tabelle1[[#This Row],[Ende]]>endq2),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Ende]]<=endq3),Tabelle1[[#This Row],[Ende]]-endq2,IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Start]]<endq3),endq3-endq2,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q3]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q3]]&\"}{\"& Tabelle1[[#This Row],[Q3e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(Q11)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq3,Tabelle1[[#This Row],[Start]]<=endq4),Tabelle1[[#This Row],[Start]]-endq3,IF(AND(Tabelle1[[#This Row],[Start]]<=endq3,Tabelle1[[#This Row],[Ende]]>endq3),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Ende]]<=endq4),Tabelle1[[#This Row],[Ende]]-endq3,IF(AND(Tabelle1[[#This Row],[Ende]]>endq4,Tabelle1[[#This Row],[Start]]<endq4),endq4-endq3,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q4]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q4]]&\"}{\"& Tabelle1[[#This Row],[Q4e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(T11)),\"\")","v":""}]
[null,"Herrentag",3,"2013-05-09","2013-05-09",{"$f":"Tabelle1[[#This Row],[Ende]]-Tabelle1[[#This Row],[Start]]+1","v":1},"yellow","Herrentag",{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>Endlastyear,Tabelle1[[#This Row],[Start]]<=endq1),Tabelle1[[#This Row],[Start]]-Endlastyear,\"\")","v":""},{"$f":"IF(Tabelle1[[#This Row],[Ende]]<=endq1,Tabelle1[[#This Row],[Ende]]-Endlastyear,IF(Tabelle1[[#This Row],[Start]]<endq1,endq1-Endlastyear,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q1]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q1]]&\"}{\"& Tabelle1[[#This Row],[Q1e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(K12)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq1,Tabelle1[[#This Row],[Start]]<=endq2),Tabelle1[[#This Row],[Start]]-endq1,IF(AND(Tabelle1[[#This Row],[Start]]<=endq1,Tabelle1[[#This Row],[Ende]]>endq1),1,\"\"))","v":39},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq1,Tabelle1[[#This Row],[Ende]]<=endq2),Tabelle1[[#This Row],[Ende]]-endq1,IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Start]]<endq2),endq2-endq1,\"\"))","v":39},{"$f":"IF(Tabelle1[[#This Row],[Q2]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q2]]&\"}{\"& Tabelle1[[#This Row],[Q2e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(N12)),\"\")","v":"\\ganttbar[bar/.style={fill=yellow}]{Herrentag}{39}{39}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq2,Tabelle1[[#This Row],[Start]]<=endq3),Tabelle1[[#This Row],[Start]]-endq2,IF(AND(Tabelle1[[#This Row],[Start]]<=endq2,Tabelle1[[#This Row],[Ende]]>endq2),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Ende]]<=endq3),Tabelle1[[#This Row],[Ende]]-endq2,IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Start]]<endq3),endq3-endq2,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q3]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q3]]&\"}{\"& Tabelle1[[#This Row],[Q3e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(Q12)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq3,Tabelle1[[#This Row],[Start]]<=endq4),Tabelle1[[#This Row],[Start]]-endq3,IF(AND(Tabelle1[[#This Row],[Start]]<=endq3,Tabelle1[[#This Row],[Ende]]>endq3),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Ende]]<=endq4),Tabelle1[[#This Row],[Ende]]-endq3,IF(AND(Tabelle1[[#This Row],[Ende]]>endq4,Tabelle1[[#This Row],[Start]]<endq4),endq4-endq3,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q4]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q4]]&\"}{\"& Tabelle1[[#This Row],[Q4e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(T12)),\"\")","v":""}]
[null,"Frühling",4,"2013-03-20","2013-06-20",{"$f":"Tabelle1[[#This Row],[Ende]]-Tabelle1[[#This Row],[Start]]+1","v":93},"green","Frühling",{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>Endlastyear,Tabelle1[[#This Row],[Start]]<=endq1),Tabelle1[[#This Row],[Start]]-Endlastyear,\"\")","v":79},{"$f":"IF(Tabelle1[[#This Row],[Ende]]<=endq1,Tabelle1[[#This Row],[Ende]]-Endlastyear,IF(Tabelle1[[#This Row],[Start]]<endq1,endq1-Endlastyear,\"\"))","v":90},{"$f":"IF(Tabelle1[[#This Row],[Q1]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q1]]&\"}{\"& Tabelle1[[#This Row],[Q1e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(K13)),\"\")","v":"\\ganttbar[bar/.style={fill=green}]{Frühling}{79}{90}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq1,Tabelle1[[#This Row],[Start]]<=endq2),Tabelle1[[#This Row],[Start]]-endq1,IF(AND(Tabelle1[[#This Row],[Start]]<=endq1,Tabelle1[[#This Row],[Ende]]>endq1),1,\"\"))","v":1},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq1,Tabelle1[[#This Row],[Ende]]<=endq2),Tabelle1[[#This Row],[Ende]]-endq1,IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Start]]<endq2),endq2-endq1,\"\"))","v":81},{"$f":"IF(Tabelle1[[#This Row],[Q2]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q2]]&\"}{\"& Tabelle1[[#This Row],[Q2e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(N13)),\"\")","v":"\\ganttbar[bar/.style={fill=green}]{Frühling}{1}{81}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq2,Tabelle1[[#This Row],[Start]]<=endq3),Tabelle1[[#This Row],[Start]]-endq2,IF(AND(Tabelle1[[#This Row],[Start]]<=endq2,Tabelle1[[#This Row],[Ende]]>endq2),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Ende]]<=endq3),Tabelle1[[#This Row],[Ende]]-endq2,IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Start]]<endq3),endq3-endq2,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q3]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q3]]&\"}{\"& Tabelle1[[#This Row],[Q3e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(Q13)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq3,Tabelle1[[#This Row],[Start]]<=endq4),Tabelle1[[#This Row],[Start]]-endq3,IF(AND(Tabelle1[[#This Row],[Start]]<=endq3,Tabelle1[[#This Row],[Ende]]>endq3),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Ende]]<=endq4),Tabelle1[[#This Row],[Ende]]-endq3,IF(AND(Tabelle1[[#This Row],[Ende]]>endq4,Tabelle1[[#This Row],[Start]]<endq4),endq4-endq3,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q4]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q4]]&\"}{\"& Tabelle1[[#This Row],[Q4e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(T13)),\"\")","v":""}]
[null,"Sommer",4,"2013-06-21","2013-09-21",{"$f":"Tabelle1[[#This Row],[Ende]]-Tabelle1[[#This Row],[Start]]+1","v":93},"yellow","Sommer",{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>Endlastyear,Tabelle1[[#This Row],[Start]]<=endq1),Tabelle1[[#This Row],[Start]]-Endlastyear,\"\")","v":""},{"$f":"IF(Tabelle1[[#This Row],[Ende]]<=endq1,Tabelle1[[#This Row],[Ende]]-Endlastyear,IF(Tabelle1[[#This Row],[Start]]<endq1,endq1-Endlastyear,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q1]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q1]]&\"}{\"& Tabelle1[[#This Row],[Q1e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(K14)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq1,Tabelle1[[#This Row],[Start]]<=endq2),Tabelle1[[#This Row],[Start]]-endq1,IF(AND(Tabelle1[[#This Row],[Start]]<=endq1,Tabelle1[[#This Row],[Ende]]>endq1),1,\"\"))","v":82},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq1,Tabelle1[[#This Row],[Ende]]<=endq2),Tabelle1[[#This Row],[Ende]]-endq1,IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Start]]<endq2),endq2-endq1,\"\"))","v":91},{"$f":"IF(Tabelle1[[#This Row],[Q2]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q2]]&\"}{\"& Tabelle1[[#This Row],[Q2e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(N14)),\"\")","v":"\\ganttbar[bar/.style={fill=yellow}]{Sommer}{82}{91}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq2,Tabelle1[[#This Row],[Start]]<=endq3),Tabelle1[[#This Row],[Start]]-endq2,IF(AND(Tabelle1[[#This Row],[Start]]<=endq2,Tabelle1[[#This Row],[Ende]]>endq2),1,\"\"))","v":1},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Ende]]<=endq3),Tabelle1[[#This Row],[Ende]]-endq2,IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Start]]<endq3),endq3-endq2,\"\"))","v":83},{"$f":"IF(Tabelle1[[#This Row],[Q3]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q3]]&\"}{\"& Tabelle1[[#This Row],[Q3e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(Q14)),\"\")","v":"\\ganttbar[bar/.style={fill=yellow}]{Sommer}{1}{83}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq3,Tabelle1[[#This Row],[Start]]<=endq4),Tabelle1[[#This Row],[Start]]-endq3,IF(AND(Tabelle1[[#This Row],[Start]]<=endq3,Tabelle1[[#This Row],[Ende]]>endq3),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Ende]]<=endq4),Tabelle1[[#This Row],[Ende]]-endq3,IF(AND(Tabelle1[[#This Row],[Ende]]>endq4,Tabelle1[[#This Row],[Start]]<endq4),endq4-endq3,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q4]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q4]]&\"}{\"& Tabelle1[[#This Row],[Q4e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(T14)),\"\")","v":""}]
[null,"Herbst",4,"2013-09-22","2013-12-20",{"$f":"Tabelle1[[#This Row],[Ende]]-Tabelle1[[#This Row],[Start]]+1","v":90},"brown","Herbst",{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>Endlastyear,Tabelle1[[#This Row],[Start]]<=endq1),Tabelle1[[#This Row],[Start]]-Endlastyear,\"\")","v":""},{"$f":"IF(Tabelle1[[#This Row],[Ende]]<=endq1,Tabelle1[[#This Row],[Ende]]-Endlastyear,IF(Tabelle1[[#This Row],[Start]]<endq1,endq1-Endlastyear,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q1]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q1]]&\"}{\"& Tabelle1[[#This Row],[Q1e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(K15)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq1,Tabelle1[[#This Row],[Start]]<=endq2),Tabelle1[[#This Row],[Start]]-endq1,IF(AND(Tabelle1[[#This Row],[Start]]<=endq1,Tabelle1[[#This Row],[Ende]]>endq1),1,\"\"))","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq1,Tabelle1[[#This Row],[Ende]]<=endq2),Tabelle1[[#This Row],[Ende]]-endq1,IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Start]]<endq2),endq2-endq1,\"\"))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Q2]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q2]]&\"}{\"& Tabelle1[[#This Row],[Q2e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(N15)),\"\")","v":""},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq2,Tabelle1[[#This Row],[Start]]<=endq3),Tabelle1[[#This Row],[Start]]-endq2,IF(AND(Tabelle1[[#This Row],[Start]]<=endq2,Tabelle1[[#This Row],[Ende]]>endq2),1,\"\"))","v":84},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq2,Tabelle1[[#This Row],[Ende]]<=endq3),Tabelle1[[#This Row],[Ende]]-endq2,IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Start]]<endq3),endq3-endq2,\"\"))","v":92},{"$f":"IF(Tabelle1[[#This Row],[Q3]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q3]]&\"}{\"& Tabelle1[[#This Row],[Q3e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(Q15)),\"\")","v":"\\ganttbar[bar/.style={fill=brown}]{Herbst}{84}{92}\\\\"},{"$f":"IF(AND(Tabelle1[[#This Row],[Start]]>endq3,Tabelle1[[#This Row],[Start]]<=endq4),Tabelle1[[#This Row],[Start]]-endq3,IF(AND(Tabelle1[[#This Row],[Start]]<=endq3,Tabelle1[[#This Row],[Ende]]>endq3),1,\"\"))","v":1},{"$f":"IF(AND(Tabelle1[[#This Row],[Ende]]>endq3,Tabelle1[[#This Row],[Ende]]<=endq4),Tabelle1[[#This Row],[Ende]]-endq3,IF(AND(Tabelle1[[#This Row],[Ende]]>endq4,Tabelle1[[#This Row],[Start]]<endq4),endq4-endq3,\"\"))","v":81},{"$f":"IF(Tabelle1[[#This Row],[Q4]]<>\"\",\"\\ganttbar\"&  IF(Tabelle1[[#This Row],[Color]]<>\"\",\"[bar/.style={fill=\" & Tabelle1[[#This Row],[Color]] &\"}]\",)   &\"{\" &Tabelle1[Name] & \"}{\"& Tabelle1[[#This Row],[Q4]]&\"}{\"& Tabelle1[[#This Row],[Q4e]]&\"}\" & addslashes(ROW(Tabelle1[[#This Row],[Name]]),COLUMN(Tabelle1[[#This Row],[Name]]),COLUMN(T15)),\"\")","v":"\\ganttbar[bar/.style={fill=brown}]{Herbst}{1}{81}\\\\"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"csvRange(Tabelle1[Q1-Final])","v":"\\ganttbar[bar/.style={fill=red}]{Neujahr}{1}{1}\\\\\r\n\\ganttbar[bar/.style={fill=yellow}]{Feiertag}{42}{42}\\\\\r\n\\ganttbar[bar/.style={fill=red}]{Feiertag}{88}{88}\\\\\r\n\\ganttbar[bar/.style={fill=green}]{Frühling}{79}{90}\\\\\r"},null,null,{"$f":"csvRange(Tabelle1[Q2-Final])","v":"\\ganttbar[bar/.style={fill=yellow}]{Feiertag}{1}{1}\\\\\r\n\\ganttbar[bar/.style={fill=red}]{Tag der Arbeit}{31}{31}\\\\\r\n\\ganttbar[bar/.style={fill=yellow}]{Herrentag}{39}{39}\\\\\r\n\\ganttbar[bar/.style={fill=green}]{Frühling}{1}{81}\\\\\r\n\\ganttbar[bar/.style={fill=yellow}]{Sommer}{82}{91}\\\\\r"},null,null,{"$f":"csvRange(Tabelle1[Q3-Final])","v":"\\ganttbar[bar/.style={fill=yellow}]{Sommer}{1}{83}\\\\\r\n\\ganttbar[bar/.style={fill=brown}]{Herbst}{84}{92}\\\\\r"},null,null,{"$f":"csvRange(Tabelle1[Q4-Final])","v":"\\ganttbar[bar/.style={fill=brown}]{Herbst}{1}{81}\\\\\r"}]