PK ¤„¸µ µ xl/_rels/workbook.xml.rels
PK 0ˆkÞ Þ xl/theme/theme1.xml
PK )ï„)2 2
xl/styles.xml
PK ¾õO¥( ( # xl/worksheets/_rels/sheet1.xml.rels
PK ÷y€Ž Ž xl/worksheets/sheet1.xml
Eventplanung · Gantt
Bearbeite Startdaten und Dauern im Blatt Aufgaben: Das Gantt-Diagramm aktualisiert sich von selbst.
Start46342Online-Version, kostenlos und ohne Anmeldung: https://ganttmint.com/de/vorlagen/eventplanung/
MIN($B$8:$B$23)-WEEKDAY(MIN($B$8:$B$23),3)46342H5+146343I5+146344J5+146345K5+146346L5+146347M5+146348N5+146349O5+146350P5+146351Q5+146352R5+146353S5+146354T5+146355U5+146356V5+146357W5+146358X5+146359Y5+146360Z5+146361AA5+146362AB5+146363AC5+146364AD5+146365AE5+146366AF5+146367AG5+146368AH5+146369AI5+146370AJ5+146371AK5+146372AL5+146373AM5+146374AN5+146375AO5+146376AP5+146377AQ5+146378AR5+146379AS5+146380AT5+146381AU5+146382AV5+146383AW5+146384AX5+146385AY5+146386AZ5+146387BA5+146388BB5+146389BC5+146390BD5+146391BE5+146392BF5+146393BG5+146394BH5+146395BI5+146396BJ5+146397BK5+146398BL5+146399BM5+146400BN5+146401BO5+146402BP5+146403BQ5+146404
IF(OR(DAY(H5)=1,COLUMN()=8),CHOOSE(MONTH(H5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(H5),"")Nov 2026IF(OR(DAY(I5)=1,COLUMN()=8),CHOOSE(MONTH(I5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(I5),"")IF(OR(DAY(J5)=1,COLUMN()=8),CHOOSE(MONTH(J5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(J5),"")IF(OR(DAY(K5)=1,COLUMN()=8),CHOOSE(MONTH(K5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(K5),"")IF(OR(DAY(L5)=1,COLUMN()=8),CHOOSE(MONTH(L5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(L5),"")IF(OR(DAY(M5)=1,COLUMN()=8),CHOOSE(MONTH(M5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(M5),"")IF(OR(DAY(N5)=1,COLUMN()=8),CHOOSE(MONTH(N5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(N5),"")IF(OR(DAY(O5)=1,COLUMN()=8),CHOOSE(MONTH(O5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(O5),"")IF(OR(DAY(P5)=1,COLUMN()=8),CHOOSE(MONTH(P5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(P5),"")IF(OR(DAY(Q5)=1,COLUMN()=8),CHOOSE(MONTH(Q5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(Q5),"")IF(OR(DAY(R5)=1,COLUMN()=8),CHOOSE(MONTH(R5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(R5),"")IF(OR(DAY(S5)=1,COLUMN()=8),CHOOSE(MONTH(S5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(S5),"")IF(OR(DAY(T5)=1,COLUMN()=8),CHOOSE(MONTH(T5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(T5),"")IF(OR(DAY(U5)=1,COLUMN()=8),CHOOSE(MONTH(U5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(U5),"")IF(OR(DAY(V5)=1,COLUMN()=8),CHOOSE(MONTH(V5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(V5),"")IF(OR(DAY(W5)=1,COLUMN()=8),CHOOSE(MONTH(W5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(W5),"")Dez 2026IF(OR(DAY(X5)=1,COLUMN()=8),CHOOSE(MONTH(X5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(X5),"")IF(OR(DAY(Y5)=1,COLUMN()=8),CHOOSE(MONTH(Y5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(Y5),"")IF(OR(DAY(Z5)=1,COLUMN()=8),CHOOSE(MONTH(Z5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(Z5),"")IF(OR(DAY(AA5)=1,COLUMN()=8),CHOOSE(MONTH(AA5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AA5),"")IF(OR(DAY(AB5)=1,COLUMN()=8),CHOOSE(MONTH(AB5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AB5),"")IF(OR(DAY(AC5)=1,COLUMN()=8),CHOOSE(MONTH(AC5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AC5),"")IF(OR(DAY(AD5)=1,COLUMN()=8),CHOOSE(MONTH(AD5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AD5),"")IF(OR(DAY(AE5)=1,COLUMN()=8),CHOOSE(MONTH(AE5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AE5),"")IF(OR(DAY(AF5)=1,COLUMN()=8),CHOOSE(MONTH(AF5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AF5),"")IF(OR(DAY(AG5)=1,COLUMN()=8),CHOOSE(MONTH(AG5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AG5),"")IF(OR(DAY(AH5)=1,COLUMN()=8),CHOOSE(MONTH(AH5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AH5),"")IF(OR(DAY(AI5)=1,COLUMN()=8),CHOOSE(MONTH(AI5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AI5),"")IF(OR(DAY(AJ5)=1,COLUMN()=8),CHOOSE(MONTH(AJ5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AJ5),"")IF(OR(DAY(AK5)=1,COLUMN()=8),CHOOSE(MONTH(AK5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AK5),"")IF(OR(DAY(AL5)=1,COLUMN()=8),CHOOSE(MONTH(AL5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AL5),"")IF(OR(DAY(AM5)=1,COLUMN()=8),CHOOSE(MONTH(AM5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AM5),"")IF(OR(DAY(AN5)=1,COLUMN()=8),CHOOSE(MONTH(AN5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AN5),"")IF(OR(DAY(AO5)=1,COLUMN()=8),CHOOSE(MONTH(AO5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AO5),"")IF(OR(DAY(AP5)=1,COLUMN()=8),CHOOSE(MONTH(AP5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AP5),"")IF(OR(DAY(AQ5)=1,COLUMN()=8),CHOOSE(MONTH(AQ5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AQ5),"")IF(OR(DAY(AR5)=1,COLUMN()=8),CHOOSE(MONTH(AR5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AR5),"")IF(OR(DAY(AS5)=1,COLUMN()=8),CHOOSE(MONTH(AS5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AS5),"")IF(OR(DAY(AT5)=1,COLUMN()=8),CHOOSE(MONTH(AT5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AT5),"")IF(OR(DAY(AU5)=1,COLUMN()=8),CHOOSE(MONTH(AU5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AU5),"")IF(OR(DAY(AV5)=1,COLUMN()=8),CHOOSE(MONTH(AV5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AV5),"")IF(OR(DAY(AW5)=1,COLUMN()=8),CHOOSE(MONTH(AW5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AW5),"")IF(OR(DAY(AX5)=1,COLUMN()=8),CHOOSE(MONTH(AX5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AX5),"")IF(OR(DAY(AY5)=1,COLUMN()=8),CHOOSE(MONTH(AY5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AY5),"")IF(OR(DAY(AZ5)=1,COLUMN()=8),CHOOSE(MONTH(AZ5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(AZ5),"")IF(OR(DAY(BA5)=1,COLUMN()=8),CHOOSE(MONTH(BA5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BA5),"")IF(OR(DAY(BB5)=1,COLUMN()=8),CHOOSE(MONTH(BB5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BB5),"")Jan 2027IF(OR(DAY(BC5)=1,COLUMN()=8),CHOOSE(MONTH(BC5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BC5),"")IF(OR(DAY(BD5)=1,COLUMN()=8),CHOOSE(MONTH(BD5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BD5),"")IF(OR(DAY(BE5)=1,COLUMN()=8),CHOOSE(MONTH(BE5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BE5),"")IF(OR(DAY(BF5)=1,COLUMN()=8),CHOOSE(MONTH(BF5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BF5),"")IF(OR(DAY(BG5)=1,COLUMN()=8),CHOOSE(MONTH(BG5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BG5),"")IF(OR(DAY(BH5)=1,COLUMN()=8),CHOOSE(MONTH(BH5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BH5),"")IF(OR(DAY(BI5)=1,COLUMN()=8),CHOOSE(MONTH(BI5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BI5),"")IF(OR(DAY(BJ5)=1,COLUMN()=8),CHOOSE(MONTH(BJ5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BJ5),"")IF(OR(DAY(BK5)=1,COLUMN()=8),CHOOSE(MONTH(BK5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BK5),"")IF(OR(DAY(BL5)=1,COLUMN()=8),CHOOSE(MONTH(BL5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BL5),"")IF(OR(DAY(BM5)=1,COLUMN()=8),CHOOSE(MONTH(BM5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BM5),"")IF(OR(DAY(BN5)=1,COLUMN()=8),CHOOSE(MONTH(BN5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BN5),"")IF(OR(DAY(BO5)=1,COLUMN()=8),CHOOSE(MONTH(BO5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BO5),"")IF(OR(DAY(BP5)=1,COLUMN()=8),CHOOSE(MONTH(BP5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BP5),"")IF(OR(DAY(BQ5)=1,COLUMN()=8),CHOOSE(MONTH(BQ5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BQ5),"")IF(OR(DAY(BR5)=1,COLUMN()=8),CHOOSE(MONTH(BR5),"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez")&" "&YEAR(BR5),"")
AufgabeStartDauer (Tage)EndeFortschrittAbhängig vonDAY(H5)16DAY(I5)17DAY(J5)18DAY(K5)19DAY(L5)20DAY(M5)21DAY(N5)22DAY(O5)23DAY(P5)24DAY(Q5)25DAY(R5)26DAY(S5)27DAY(T5)28DAY(U5)29DAY(V5)30DAY(W5)1DAY(X5)2DAY(Y5)3DAY(Z5)4DAY(AA5)5DAY(AB5)6DAY(AC5)7DAY(AD5)8DAY(AE5)9DAY(AF5)10DAY(AG5)11DAY(AH5)12DAY(AI5)13DAY(AJ5)14DAY(AK5)15DAY(AL5)16DAY(AM5)17DAY(AN5)18DAY(AO5)19DAY(AP5)20DAY(AQ5)21DAY(AR5)22DAY(AS5)23DAY(AT5)24DAY(AU5)25DAY(AV5)26DAY(AW5)27DAY(AX5)28DAY(AY5)29DAY(AZ5)30DAY(BA5)31DAY(BB5)1DAY(BC5)2DAY(BD5)3DAY(BE5)4DAY(BF5)5DAY(BG5)6DAY(BH5)7DAY(BI5)8DAY(BJ5)9DAY(BK5)10DAY(BL5)11DAY(BM5)12DAY(BN5)13DAY(BO5)14DAY(BP5)15DAY(BQ5)16DAY(BR5)17
GrundlagenMIN(B9:B11)46342D8-B8+113MAX(D9:D11)46354IF(AND(H$5>=$B8,H$5<=$D8),"▬","")▬IF(AND(I$5>=$B8,I$5<=$D8),"▬","")▬IF(AND(J$5>=$B8,J$5<=$D8),"▬","")▬IF(AND(K$5>=$B8,K$5<=$D8),"▬","")▬IF(AND(L$5>=$B8,L$5<=$D8),"▬","")▬IF(AND(M$5>=$B8,M$5<=$D8),"▬","")▬IF(AND(N$5>=$B8,N$5<=$D8),"▬","")▬IF(AND(O$5>=$B8,O$5<=$D8),"▬","")▬IF(AND(P$5>=$B8,P$5<=$D8),"▬","")▬IF(AND(Q$5>=$B8,Q$5<=$D8),"▬","")▬IF(AND(R$5>=$B8,R$5<=$D8),"▬","")▬IF(AND(S$5>=$B8,S$5<=$D8),"▬","")▬IF(AND(T$5>=$B8,T$5<=$D8),"▬","")▬IF(AND(U$5>=$B8,U$5<=$D8),"▬","")IF(AND(V$5>=$B8,V$5<=$D8),"▬","")IF(AND(W$5>=$B8,W$5<=$D8),"▬","")IF(AND(X$5>=$B8,X$5<=$D8),"▬","")IF(AND(Y$5>=$B8,Y$5<=$D8),"▬","")IF(AND(Z$5>=$B8,Z$5<=$D8),"▬","")IF(AND(AA$5>=$B8,AA$5<=$D8),"▬","")IF(AND(AB$5>=$B8,AB$5<=$D8),"▬","")IF(AND(AC$5>=$B8,AC$5<=$D8),"▬","")IF(AND(AD$5>=$B8,AD$5<=$D8),"▬","")IF(AND(AE$5>=$B8,AE$5<=$D8),"▬","")IF(AND(AF$5>=$B8,AF$5<=$D8),"▬","")IF(AND(AG$5>=$B8,AG$5<=$D8),"▬","")IF(AND(AH$5>=$B8,AH$5<=$D8),"▬","")IF(AND(AI$5>=$B8,AI$5<=$D8),"▬","")IF(AND(AJ$5>=$B8,AJ$5<=$D8),"▬","")IF(AND(AK$5>=$B8,AK$5<=$D8),"▬","")IF(AND(AL$5>=$B8,AL$5<=$D8),"▬","")IF(AND(AM$5>=$B8,AM$5<=$D8),"▬","")IF(AND(AN$5>=$B8,AN$5<=$D8),"▬","")IF(AND(AO$5>=$B8,AO$5<=$D8),"▬","")IF(AND(AP$5>=$B8,AP$5<=$D8),"▬","")IF(AND(AQ$5>=$B8,AQ$5<=$D8),"▬","")IF(AND(AR$5>=$B8,AR$5<=$D8),"▬","")IF(AND(AS$5>=$B8,AS$5<=$D8),"▬","")IF(AND(AT$5>=$B8,AT$5<=$D8),"▬","")IF(AND(AU$5>=$B8,AU$5<=$D8),"▬","")IF(AND(AV$5>=$B8,AV$5<=$D8),"▬","")IF(AND(AW$5>=$B8,AW$5<=$D8),"▬","")IF(AND(AX$5>=$B8,AX$5<=$D8),"▬","")IF(AND(AY$5>=$B8,AY$5<=$D8),"▬","")IF(AND(AZ$5>=$B8,AZ$5<=$D8),"▬","")IF(AND(BA$5>=$B8,BA$5<=$D8),"▬","")IF(AND(BB$5>=$B8,BB$5<=$D8),"▬","")IF(AND(BC$5>=$B8,BC$5<=$D8),"▬","")IF(AND(BD$5>=$B8,BD$5<=$D8),"▬","")IF(AND(BE$5>=$B8,BE$5<=$D8),"▬","")IF(AND(BF$5>=$B8,BF$5<=$D8),"▬","")IF(AND(BG$5>=$B8,BG$5<=$D8),"▬","")IF(AND(BH$5>=$B8,BH$5<=$D8),"▬","")IF(AND(BI$5>=$B8,BI$5<=$D8),"▬","")IF(AND(BJ$5>=$B8,BJ$5<=$D8),"▬","")IF(AND(BK$5>=$B8,BK$5<=$D8),"▬","")IF(AND(BL$5>=$B8,BL$5<=$D8),"▬","")IF(AND(BM$5>=$B8,BM$5<=$D8),"▬","")IF(AND(BN$5>=$B8,BN$5<=$D8),"▬","")IF(AND(BO$5>=$B8,BO$5<=$D8),"▬","")IF(AND(BP$5>=$B8,BP$5<=$D8),"▬","")IF(AND(BQ$5>=$B8,BQ$5<=$D8),"▬","")IF(AND(BR$5>=$B8,BR$5<=$D8),"▬","")
Ziele und Budget$B$3+0463424B9+C9-1463450IF(AND(H$5>=$B9,H$5<=$D9),"█","")█IF(AND(I$5>=$B9,I$5<=$D9),"█","")█IF(AND(J$5>=$B9,J$5<=$D9),"█","")█IF(AND(K$5>=$B9,K$5<=$D9),"█","")█IF(AND(L$5>=$B9,L$5<=$D9),"█","")IF(AND(M$5>=$B9,M$5<=$D9),"█","")IF(AND(N$5>=$B9,N$5<=$D9),"█","")IF(AND(O$5>=$B9,O$5<=$D9),"█","")IF(AND(P$5>=$B9,P$5<=$D9),"█","")IF(AND(Q$5>=$B9,Q$5<=$D9),"█","")IF(AND(R$5>=$B9,R$5<=$D9),"█","")IF(AND(S$5>=$B9,S$5<=$D9),"█","")IF(AND(T$5>=$B9,T$5<=$D9),"█","")IF(AND(U$5>=$B9,U$5<=$D9),"█","")IF(AND(V$5>=$B9,V$5<=$D9),"█","")IF(AND(W$5>=$B9,W$5<=$D9),"█","")IF(AND(X$5>=$B9,X$5<=$D9),"█","")IF(AND(Y$5>=$B9,Y$5<=$D9),"█","")IF(AND(Z$5>=$B9,Z$5<=$D9),"█","")IF(AND(AA$5>=$B9,AA$5<=$D9),"█","")IF(AND(AB$5>=$B9,AB$5<=$D9),"█","")IF(AND(AC$5>=$B9,AC$5<=$D9),"█","")IF(AND(AD$5>=$B9,AD$5<=$D9),"█","")IF(AND(AE$5>=$B9,AE$5<=$D9),"█","")IF(AND(AF$5>=$B9,AF$5<=$D9),"█","")IF(AND(AG$5>=$B9,AG$5<=$D9),"█","")IF(AND(AH$5>=$B9,AH$5<=$D9),"█","")IF(AND(AI$5>=$B9,AI$5<=$D9),"█","")IF(AND(AJ$5>=$B9,AJ$5<=$D9),"█","")IF(AND(AK$5>=$B9,AK$5<=$D9),"█","")IF(AND(AL$5>=$B9,AL$5<=$D9),"█","")IF(AND(AM$5>=$B9,AM$5<=$D9),"█","")IF(AND(AN$5>=$B9,AN$5<=$D9),"█","")IF(AND(AO$5>=$B9,AO$5<=$D9),"█","")IF(AND(AP$5>=$B9,AP$5<=$D9),"█","")IF(AND(AQ$5>=$B9,AQ$5<=$D9),"█","")IF(AND(AR$5>=$B9,AR$5<=$D9),"█","")IF(AND(AS$5>=$B9,AS$5<=$D9),"█","")IF(AND(AT$5>=$B9,AT$5<=$D9),"█","")IF(AND(AU$5>=$B9,AU$5<=$D9),"█","")IF(AND(AV$5>=$B9,AV$5<=$D9),"█","")IF(AND(AW$5>=$B9,AW$5<=$D9),"█","")IF(AND(AX$5>=$B9,AX$5<=$D9),"█","")IF(AND(AY$5>=$B9,AY$5<=$D9),"█","")IF(AND(AZ$5>=$B9,AZ$5<=$D9),"█","")IF(AND(BA$5>=$B9,BA$5<=$D9),"█","")IF(AND(BB$5>=$B9,BB$5<=$D9),"█","")IF(AND(BC$5>=$B9,BC$5<=$D9),"█","")IF(AND(BD$5>=$B9,BD$5<=$D9),"█","")IF(AND(BE$5>=$B9,BE$5<=$D9),"█","")IF(AND(BF$5>=$B9,BF$5<=$D9),"█","")IF(AND(BG$5>=$B9,BG$5<=$D9),"█","")IF(AND(BH$5>=$B9,BH$5<=$D9),"█","")IF(AND(BI$5>=$B9,BI$5<=$D9),"█","")IF(AND(BJ$5>=$B9,BJ$5<=$D9),"█","")IF(AND(BK$5>=$B9,BK$5<=$D9),"█","")IF(AND(BL$5>=$B9,BL$5<=$D9),"█","")IF(AND(BM$5>=$B9,BM$5<=$D9),"█","")IF(AND(BN$5>=$B9,BN$5<=$D9),"█","")IF(AND(BO$5>=$B9,BO$5<=$D9),"█","")IF(AND(BP$5>=$B9,BP$5<=$D9),"█","")IF(AND(BQ$5>=$B9,BQ$5<=$D9),"█","")IF(AND(BR$5>=$B9,BR$5<=$D9),"█","")
Location-AuswahlD9+1463468B10+C10-1463530Ziele und BudgetIF(AND(H$5>=$B10,H$5<=$D10),"█","")IF(AND(I$5>=$B10,I$5<=$D10),"█","")IF(AND(J$5>=$B10,J$5<=$D10),"█","")IF(AND(K$5>=$B10,K$5<=$D10),"█","")IF(AND(L$5>=$B10,L$5<=$D10),"█","")█IF(AND(M$5>=$B10,M$5<=$D10),"█","")█IF(AND(N$5>=$B10,N$5<=$D10),"█","")█IF(AND(O$5>=$B10,O$5<=$D10),"█","")█IF(AND(P$5>=$B10,P$5<=$D10),"█","")█IF(AND(Q$5>=$B10,Q$5<=$D10),"█","")█IF(AND(R$5>=$B10,R$5<=$D10),"█","")█IF(AND(S$5>=$B10,S$5<=$D10),"█","")█IF(AND(T$5>=$B10,T$5<=$D10),"█","")IF(AND(U$5>=$B10,U$5<=$D10),"█","")IF(AND(V$5>=$B10,V$5<=$D10),"█","")IF(AND(W$5>=$B10,W$5<=$D10),"█","")IF(AND(X$5>=$B10,X$5<=$D10),"█","")IF(AND(Y$5>=$B10,Y$5<=$D10),"█","")IF(AND(Z$5>=$B10,Z$5<=$D10),"█","")IF(AND(AA$5>=$B10,AA$5<=$D10),"█","")IF(AND(AB$5>=$B10,AB$5<=$D10),"█","")IF(AND(AC$5>=$B10,AC$5<=$D10),"█","")IF(AND(AD$5>=$B10,AD$5<=$D10),"█","")IF(AND(AE$5>=$B10,AE$5<=$D10),"█","")IF(AND(AF$5>=$B10,AF$5<=$D10),"█","")IF(AND(AG$5>=$B10,AG$5<=$D10),"█","")IF(AND(AH$5>=$B10,AH$5<=$D10),"█","")IF(AND(AI$5>=$B10,AI$5<=$D10),"█","")IF(AND(AJ$5>=$B10,AJ$5<=$D10),"█","")IF(AND(AK$5>=$B10,AK$5<=$D10),"█","")IF(AND(AL$5>=$B10,AL$5<=$D10),"█","")IF(AND(AM$5>=$B10,AM$5<=$D10),"█","")IF(AND(AN$5>=$B10,AN$5<=$D10),"█","")IF(AND(AO$5>=$B10,AO$5<=$D10),"█","")IF(AND(AP$5>=$B10,AP$5<=$D10),"█","")IF(AND(AQ$5>=$B10,AQ$5<=$D10),"█","")IF(AND(AR$5>=$B10,AR$5<=$D10),"█","")IF(AND(AS$5>=$B10,AS$5<=$D10),"█","")IF(AND(AT$5>=$B10,AT$5<=$D10),"█","")IF(AND(AU$5>=$B10,AU$5<=$D10),"█","")IF(AND(AV$5>=$B10,AV$5<=$D10),"█","")IF(AND(AW$5>=$B10,AW$5<=$D10),"█","")IF(AND(AX$5>=$B10,AX$5<=$D10),"█","")IF(AND(AY$5>=$B10,AY$5<=$D10),"█","")IF(AND(AZ$5>=$B10,AZ$5<=$D10),"█","")IF(AND(BA$5>=$B10,BA$5<=$D10),"█","")IF(AND(BB$5>=$B10,BB$5<=$D10),"█","")IF(AND(BC$5>=$B10,BC$5<=$D10),"█","")IF(AND(BD$5>=$B10,BD$5<=$D10),"█","")IF(AND(BE$5>=$B10,BE$5<=$D10),"█","")IF(AND(BF$5>=$B10,BF$5<=$D10),"█","")IF(AND(BG$5>=$B10,BG$5<=$D10),"█","")IF(AND(BH$5>=$B10,BH$5<=$D10),"█","")IF(AND(BI$5>=$B10,BI$5<=$D10),"█","")IF(AND(BJ$5>=$B10,BJ$5<=$D10),"█","")IF(AND(BK$5>=$B10,BK$5<=$D10),"█","")IF(AND(BL$5>=$B10,BL$5<=$D10),"█","")IF(AND(BM$5>=$B10,BM$5<=$D10),"█","")IF(AND(BN$5>=$B10,BN$5<=$D10),"█","")IF(AND(BO$5>=$B10,BO$5<=$D10),"█","")IF(AND(BP$5>=$B10,BP$5<=$D10),"█","")IF(AND(BQ$5>=$B10,BQ$5<=$D10),"█","")IF(AND(BR$5>=$B10,BR$5<=$D10),"█","")
Location gebuchtD10+1463540B11463540Location-AuswahlIF(H$5=$B11,"◆","")IF(I$5=$B11,"◆","")IF(J$5=$B11,"◆","")IF(K$5=$B11,"◆","")IF(L$5=$B11,"◆","")IF(M$5=$B11,"◆","")IF(N$5=$B11,"◆","")IF(O$5=$B11,"◆","")IF(P$5=$B11,"◆","")IF(Q$5=$B11,"◆","")IF(R$5=$B11,"◆","")IF(S$5=$B11,"◆","")IF(T$5=$B11,"◆","")◆IF(U$5=$B11,"◆","")IF(V$5=$B11,"◆","")IF(W$5=$B11,"◆","")IF(X$5=$B11,"◆","")IF(Y$5=$B11,"◆","")IF(Z$5=$B11,"◆","")IF(AA$5=$B11,"◆","")IF(AB$5=$B11,"◆","")IF(AC$5=$B11,"◆","")IF(AD$5=$B11,"◆","")IF(AE$5=$B11,"◆","")IF(AF$5=$B11,"◆","")IF(AG$5=$B11,"◆","")IF(AH$5=$B11,"◆","")IF(AI$5=$B11,"◆","")IF(AJ$5=$B11,"◆","")IF(AK$5=$B11,"◆","")IF(AL$5=$B11,"◆","")IF(AM$5=$B11,"◆","")IF(AN$5=$B11,"◆","")IF(AO$5=$B11,"◆","")IF(AP$5=$B11,"◆","")IF(AQ$5=$B11,"◆","")IF(AR$5=$B11,"◆","")IF(AS$5=$B11,"◆","")IF(AT$5=$B11,"◆","")IF(AU$5=$B11,"◆","")IF(AV$5=$B11,"◆","")IF(AW$5=$B11,"◆","")IF(AX$5=$B11,"◆","")IF(AY$5=$B11,"◆","")IF(AZ$5=$B11,"◆","")IF(BA$5=$B11,"◆","")IF(BB$5=$B11,"◆","")IF(BC$5=$B11,"◆","")IF(BD$5=$B11,"◆","")IF(BE$5=$B11,"◆","")IF(BF$5=$B11,"◆","")IF(BG$5=$B11,"◆","")IF(BH$5=$B11,"◆","")IF(BI$5=$B11,"◆","")IF(BJ$5=$B11,"◆","")IF(BK$5=$B11,"◆","")IF(BL$5=$B11,"◆","")IF(BM$5=$B11,"◆","")IF(BN$5=$B11,"◆","")IF(BO$5=$B11,"◆","")IF(BP$5=$B11,"◆","")IF(BQ$5=$B11,"◆","")IF(BR$5=$B11,"◆","")
ProgrammMIN(B13:B14)46354D12-B12+111MAX(D13:D14)46364IF(AND(H$5>=$B12,H$5<=$D12),"▬","")IF(AND(I$5>=$B12,I$5<=$D12),"▬","")IF(AND(J$5>=$B12,J$5<=$D12),"▬","")IF(AND(K$5>=$B12,K$5<=$D12),"▬","")IF(AND(L$5>=$B12,L$5<=$D12),"▬","")IF(AND(M$5>=$B12,M$5<=$D12),"▬","")IF(AND(N$5>=$B12,N$5<=$D12),"▬","")IF(AND(O$5>=$B12,O$5<=$D12),"▬","")IF(AND(P$5>=$B12,P$5<=$D12),"▬","")IF(AND(Q$5>=$B12,Q$5<=$D12),"▬","")IF(AND(R$5>=$B12,R$5<=$D12),"▬","")IF(AND(S$5>=$B12,S$5<=$D12),"▬","")IF(AND(T$5>=$B12,T$5<=$D12),"▬","")▬IF(AND(U$5>=$B12,U$5<=$D12),"▬","")▬IF(AND(V$5>=$B12,V$5<=$D12),"▬","")▬IF(AND(W$5>=$B12,W$5<=$D12),"▬","")▬IF(AND(X$5>=$B12,X$5<=$D12),"▬","")▬IF(AND(Y$5>=$B12,Y$5<=$D12),"▬","")▬IF(AND(Z$5>=$B12,Z$5<=$D12),"▬","")▬IF(AND(AA$5>=$B12,AA$5<=$D12),"▬","")▬IF(AND(AB$5>=$B12,AB$5<=$D12),"▬","")▬IF(AND(AC$5>=$B12,AC$5<=$D12),"▬","")▬IF(AND(AD$5>=$B12,AD$5<=$D12),"▬","")▬IF(AND(AE$5>=$B12,AE$5<=$D12),"▬","")IF(AND(AF$5>=$B12,AF$5<=$D12),"▬","")IF(AND(AG$5>=$B12,AG$5<=$D12),"▬","")IF(AND(AH$5>=$B12,AH$5<=$D12),"▬","")IF(AND(AI$5>=$B12,AI$5<=$D12),"▬","")IF(AND(AJ$5>=$B12,AJ$5<=$D12),"▬","")IF(AND(AK$5>=$B12,AK$5<=$D12),"▬","")IF(AND(AL$5>=$B12,AL$5<=$D12),"▬","")IF(AND(AM$5>=$B12,AM$5<=$D12),"▬","")IF(AND(AN$5>=$B12,AN$5<=$D12),"▬","")IF(AND(AO$5>=$B12,AO$5<=$D12),"▬","")IF(AND(AP$5>=$B12,AP$5<=$D12),"▬","")IF(AND(AQ$5>=$B12,AQ$5<=$D12),"▬","")IF(AND(AR$5>=$B12,AR$5<=$D12),"▬","")IF(AND(AS$5>=$B12,AS$5<=$D12),"▬","")IF(AND(AT$5>=$B12,AT$5<=$D12),"▬","")IF(AND(AU$5>=$B12,AU$5<=$D12),"▬","")IF(AND(AV$5>=$B12,AV$5<=$D12),"▬","")IF(AND(AW$5>=$B12,AW$5<=$D12),"▬","")IF(AND(AX$5>=$B12,AX$5<=$D12),"▬","")IF(AND(AY$5>=$B12,AY$5<=$D12),"▬","")IF(AND(AZ$5>=$B12,AZ$5<=$D12),"▬","")IF(AND(BA$5>=$B12,BA$5<=$D12),"▬","")IF(AND(BB$5>=$B12,BB$5<=$D12),"▬","")IF(AND(BC$5>=$B12,BC$5<=$D12),"▬","")IF(AND(BD$5>=$B12,BD$5<=$D12),"▬","")IF(AND(BE$5>=$B12,BE$5<=$D12),"▬","")IF(AND(BF$5>=$B12,BF$5<=$D12),"▬","")IF(AND(BG$5>=$B12,BG$5<=$D12),"▬","")IF(AND(BH$5>=$B12,BH$5<=$D12),"▬","")IF(AND(BI$5>=$B12,BI$5<=$D12),"▬","")IF(AND(BJ$5>=$B12,BJ$5<=$D12),"▬","")IF(AND(BK$5>=$B12,BK$5<=$D12),"▬","")IF(AND(BL$5>=$B12,BL$5<=$D12),"▬","")IF(AND(BM$5>=$B12,BM$5<=$D12),"▬","")IF(AND(BN$5>=$B12,BN$5<=$D12),"▬","")IF(AND(BO$5>=$B12,BO$5<=$D12),"▬","")IF(AND(BP$5>=$B12,BP$5<=$D12),"▬","")IF(AND(BQ$5>=$B12,BQ$5<=$D12),"▬","")IF(AND(BR$5>=$B12,BR$5<=$D12),"▬","")
SpeakerD114635410B13+C13-1463630Location gebuchtIF(AND(H$5>=$B13,H$5<=$D13),"█","")IF(AND(I$5>=$B13,I$5<=$D13),"█","")IF(AND(J$5>=$B13,J$5<=$D13),"█","")IF(AND(K$5>=$B13,K$5<=$D13),"█","")IF(AND(L$5>=$B13,L$5<=$D13),"█","")IF(AND(M$5>=$B13,M$5<=$D13),"█","")IF(AND(N$5>=$B13,N$5<=$D13),"█","")IF(AND(O$5>=$B13,O$5<=$D13),"█","")IF(AND(P$5>=$B13,P$5<=$D13),"█","")IF(AND(Q$5>=$B13,Q$5<=$D13),"█","")IF(AND(R$5>=$B13,R$5<=$D13),"█","")IF(AND(S$5>=$B13,S$5<=$D13),"█","")IF(AND(T$5>=$B13,T$5<=$D13),"█","")█IF(AND(U$5>=$B13,U$5<=$D13),"█","")█IF(AND(V$5>=$B13,V$5<=$D13),"█","")█IF(AND(W$5>=$B13,W$5<=$D13),"█","")█IF(AND(X$5>=$B13,X$5<=$D13),"█","")█IF(AND(Y$5>=$B13,Y$5<=$D13),"█","")█IF(AND(Z$5>=$B13,Z$5<=$D13),"█","")█IF(AND(AA$5>=$B13,AA$5<=$D13),"█","")█IF(AND(AB$5>=$B13,AB$5<=$D13),"█","")█IF(AND(AC$5>=$B13,AC$5<=$D13),"█","")█IF(AND(AD$5>=$B13,AD$5<=$D13),"█","")IF(AND(AE$5>=$B13,AE$5<=$D13),"█","")IF(AND(AF$5>=$B13,AF$5<=$D13),"█","")IF(AND(AG$5>=$B13,AG$5<=$D13),"█","")IF(AND(AH$5>=$B13,AH$5<=$D13),"█","")IF(AND(AI$5>=$B13,AI$5<=$D13),"█","")IF(AND(AJ$5>=$B13,AJ$5<=$D13),"█","")IF(AND(AK$5>=$B13,AK$5<=$D13),"█","")IF(AND(AL$5>=$B13,AL$5<=$D13),"█","")IF(AND(AM$5>=$B13,AM$5<=$D13),"█","")IF(AND(AN$5>=$B13,AN$5<=$D13),"█","")IF(AND(AO$5>=$B13,AO$5<=$D13),"█","")IF(AND(AP$5>=$B13,AP$5<=$D13),"█","")IF(AND(AQ$5>=$B13,AQ$5<=$D13),"█","")IF(AND(AR$5>=$B13,AR$5<=$D13),"█","")IF(AND(AS$5>=$B13,AS$5<=$D13),"█","")IF(AND(AT$5>=$B13,AT$5<=$D13),"█","")IF(AND(AU$5>=$B13,AU$5<=$D13),"█","")IF(AND(AV$5>=$B13,AV$5<=$D13),"█","")IF(AND(AW$5>=$B13,AW$5<=$D13),"█","")IF(AND(AX$5>=$B13,AX$5<=$D13),"█","")IF(AND(AY$5>=$B13,AY$5<=$D13),"█","")IF(AND(AZ$5>=$B13,AZ$5<=$D13),"█","")IF(AND(BA$5>=$B13,BA$5<=$D13),"█","")IF(AND(BB$5>=$B13,BB$5<=$D13),"█","")IF(AND(BC$5>=$B13,BC$5<=$D13),"█","")IF(AND(BD$5>=$B13,BD$5<=$D13),"█","")IF(AND(BE$5>=$B13,BE$5<=$D13),"█","")IF(AND(BF$5>=$B13,BF$5<=$D13),"█","")IF(AND(BG$5>=$B13,BG$5<=$D13),"█","")IF(AND(BH$5>=$B13,BH$5<=$D13),"█","")IF(AND(BI$5>=$B13,BI$5<=$D13),"█","")IF(AND(BJ$5>=$B13,BJ$5<=$D13),"█","")IF(AND(BK$5>=$B13,BK$5<=$D13),"█","")IF(AND(BL$5>=$B13,BL$5<=$D13),"█","")IF(AND(BM$5>=$B13,BM$5<=$D13),"█","")IF(AND(BN$5>=$B13,BN$5<=$D13),"█","")IF(AND(BO$5>=$B13,BO$5<=$D13),"█","")IF(AND(BP$5>=$B13,BP$5<=$D13),"█","")IF(AND(BQ$5>=$B13,BQ$5<=$D13),"█","")IF(AND(BR$5>=$B13,BR$5<=$D13),"█","")
Programm veröffentlichtD13+1463640B14463640SpeakerIF(H$5=$B14,"◆","")IF(I$5=$B14,"◆","")IF(J$5=$B14,"◆","")IF(K$5=$B14,"◆","")IF(L$5=$B14,"◆","")IF(M$5=$B14,"◆","")IF(N$5=$B14,"◆","")IF(O$5=$B14,"◆","")IF(P$5=$B14,"◆","")IF(Q$5=$B14,"◆","")IF(R$5=$B14,"◆","")IF(S$5=$B14,"◆","")IF(T$5=$B14,"◆","")IF(U$5=$B14,"◆","")IF(V$5=$B14,"◆","")IF(W$5=$B14,"◆","")IF(X$5=$B14,"◆","")IF(Y$5=$B14,"◆","")IF(Z$5=$B14,"◆","")IF(AA$5=$B14,"◆","")IF(AB$5=$B14,"◆","")IF(AC$5=$B14,"◆","")IF(AD$5=$B14,"◆","")◆IF(AE$5=$B14,"◆","")IF(AF$5=$B14,"◆","")IF(AG$5=$B14,"◆","")IF(AH$5=$B14,"◆","")IF(AI$5=$B14,"◆","")IF(AJ$5=$B14,"◆","")IF(AK$5=$B14,"◆","")IF(AL$5=$B14,"◆","")IF(AM$5=$B14,"◆","")IF(AN$5=$B14,"◆","")IF(AO$5=$B14,"◆","")IF(AP$5=$B14,"◆","")IF(AQ$5=$B14,"◆","")IF(AR$5=$B14,"◆","")IF(AS$5=$B14,"◆","")IF(AT$5=$B14,"◆","")IF(AU$5=$B14,"◆","")IF(AV$5=$B14,"◆","")IF(AW$5=$B14,"◆","")IF(AX$5=$B14,"◆","")IF(AY$5=$B14,"◆","")IF(AZ$5=$B14,"◆","")IF(BA$5=$B14,"◆","")IF(BB$5=$B14,"◆","")IF(BC$5=$B14,"◆","")IF(BD$5=$B14,"◆","")IF(BE$5=$B14,"◆","")IF(BF$5=$B14,"◆","")IF(BG$5=$B14,"◆","")IF(BH$5=$B14,"◆","")IF(BI$5=$B14,"◆","")IF(BJ$5=$B14,"◆","")IF(BK$5=$B14,"◆","")IF(BL$5=$B14,"◆","")IF(BM$5=$B14,"◆","")IF(BN$5=$B14,"◆","")IF(BO$5=$B14,"◆","")IF(BP$5=$B14,"◆","")IF(BQ$5=$B14,"◆","")IF(BR$5=$B14,"◆","")
KommunikationMIN(B16:B17)46364D15-B15+130MAX(D16:D17)46393IF(AND(H$5>=$B15,H$5<=$D15),"▬","")IF(AND(I$5>=$B15,I$5<=$D15),"▬","")IF(AND(J$5>=$B15,J$5<=$D15),"▬","")IF(AND(K$5>=$B15,K$5<=$D15),"▬","")IF(AND(L$5>=$B15,L$5<=$D15),"▬","")IF(AND(M$5>=$B15,M$5<=$D15),"▬","")IF(AND(N$5>=$B15,N$5<=$D15),"▬","")IF(AND(O$5>=$B15,O$5<=$D15),"▬","")IF(AND(P$5>=$B15,P$5<=$D15),"▬","")IF(AND(Q$5>=$B15,Q$5<=$D15),"▬","")IF(AND(R$5>=$B15,R$5<=$D15),"▬","")IF(AND(S$5>=$B15,S$5<=$D15),"▬","")IF(AND(T$5>=$B15,T$5<=$D15),"▬","")IF(AND(U$5>=$B15,U$5<=$D15),"▬","")IF(AND(V$5>=$B15,V$5<=$D15),"▬","")IF(AND(W$5>=$B15,W$5<=$D15),"▬","")IF(AND(X$5>=$B15,X$5<=$D15),"▬","")IF(AND(Y$5>=$B15,Y$5<=$D15),"▬","")IF(AND(Z$5>=$B15,Z$5<=$D15),"▬","")IF(AND(AA$5>=$B15,AA$5<=$D15),"▬","")IF(AND(AB$5>=$B15,AB$5<=$D15),"▬","")IF(AND(AC$5>=$B15,AC$5<=$D15),"▬","")IF(AND(AD$5>=$B15,AD$5<=$D15),"▬","")▬IF(AND(AE$5>=$B15,AE$5<=$D15),"▬","")▬IF(AND(AF$5>=$B15,AF$5<=$D15),"▬","")▬IF(AND(AG$5>=$B15,AG$5<=$D15),"▬","")▬IF(AND(AH$5>=$B15,AH$5<=$D15),"▬","")▬IF(AND(AI$5>=$B15,AI$5<=$D15),"▬","")▬IF(AND(AJ$5>=$B15,AJ$5<=$D15),"▬","")▬IF(AND(AK$5>=$B15,AK$5<=$D15),"▬","")▬IF(AND(AL$5>=$B15,AL$5<=$D15),"▬","")▬IF(AND(AM$5>=$B15,AM$5<=$D15),"▬","")▬IF(AND(AN$5>=$B15,AN$5<=$D15),"▬","")▬IF(AND(AO$5>=$B15,AO$5<=$D15),"▬","")▬IF(AND(AP$5>=$B15,AP$5<=$D15),"▬","")▬IF(AND(AQ$5>=$B15,AQ$5<=$D15),"▬","")▬IF(AND(AR$5>=$B15,AR$5<=$D15),"▬","")▬IF(AND(AS$5>=$B15,AS$5<=$D15),"▬","")▬IF(AND(AT$5>=$B15,AT$5<=$D15),"▬","")▬IF(AND(AU$5>=$B15,AU$5<=$D15),"▬","")▬IF(AND(AV$5>=$B15,AV$5<=$D15),"▬","")▬IF(AND(AW$5>=$B15,AW$5<=$D15),"▬","")▬IF(AND(AX$5>=$B15,AX$5<=$D15),"▬","")▬IF(AND(AY$5>=$B15,AY$5<=$D15),"▬","")▬IF(AND(AZ$5>=$B15,AZ$5<=$D15),"▬","")▬IF(AND(BA$5>=$B15,BA$5<=$D15),"▬","")▬IF(AND(BB$5>=$B15,BB$5<=$D15),"▬","")▬IF(AND(BC$5>=$B15,BC$5<=$D15),"▬","")▬IF(AND(BD$5>=$B15,BD$5<=$D15),"▬","")▬IF(AND(BE$5>=$B15,BE$5<=$D15),"▬","")▬IF(AND(BF$5>=$B15,BF$5<=$D15),"▬","")▬IF(AND(BG$5>=$B15,BG$5<=$D15),"▬","")▬IF(AND(BH$5>=$B15,BH$5<=$D15),"▬","")IF(AND(BI$5>=$B15,BI$5<=$D15),"▬","")IF(AND(BJ$5>=$B15,BJ$5<=$D15),"▬","")IF(AND(BK$5>=$B15,BK$5<=$D15),"▬","")IF(AND(BL$5>=$B15,BL$5<=$D15),"▬","")IF(AND(BM$5>=$B15,BM$5<=$D15),"▬","")IF(AND(BN$5>=$B15,BN$5<=$D15),"▬","")IF(AND(BO$5>=$B15,BO$5<=$D15),"▬","")IF(AND(BP$5>=$B15,BP$5<=$D15),"▬","")IF(AND(BQ$5>=$B15,BQ$5<=$D15),"▬","")IF(AND(BR$5>=$B15,BR$5<=$D15),"▬","")
Anmeldung öffnetD14463642B16+C16-1463650Programm veröffentlichtIF(AND(H$5>=$B16,H$5<=$D16),"█","")IF(AND(I$5>=$B16,I$5<=$D16),"█","")IF(AND(J$5>=$B16,J$5<=$D16),"█","")IF(AND(K$5>=$B16,K$5<=$D16),"█","")IF(AND(L$5>=$B16,L$5<=$D16),"█","")IF(AND(M$5>=$B16,M$5<=$D16),"█","")IF(AND(N$5>=$B16,N$5<=$D16),"█","")IF(AND(O$5>=$B16,O$5<=$D16),"█","")IF(AND(P$5>=$B16,P$5<=$D16),"█","")IF(AND(Q$5>=$B16,Q$5<=$D16),"█","")IF(AND(R$5>=$B16,R$5<=$D16),"█","")IF(AND(S$5>=$B16,S$5<=$D16),"█","")IF(AND(T$5>=$B16,T$5<=$D16),"█","")IF(AND(U$5>=$B16,U$5<=$D16),"█","")IF(AND(V$5>=$B16,V$5<=$D16),"█","")IF(AND(W$5>=$B16,W$5<=$D16),"█","")IF(AND(X$5>=$B16,X$5<=$D16),"█","")IF(AND(Y$5>=$B16,Y$5<=$D16),"█","")IF(AND(Z$5>=$B16,Z$5<=$D16),"█","")IF(AND(AA$5>=$B16,AA$5<=$D16),"█","")IF(AND(AB$5>=$B16,AB$5<=$D16),"█","")IF(AND(AC$5>=$B16,AC$5<=$D16),"█","")IF(AND(AD$5>=$B16,AD$5<=$D16),"█","")█IF(AND(AE$5>=$B16,AE$5<=$D16),"█","")█IF(AND(AF$5>=$B16,AF$5<=$D16),"█","")IF(AND(AG$5>=$B16,AG$5<=$D16),"█","")IF(AND(AH$5>=$B16,AH$5<=$D16),"█","")IF(AND(AI$5>=$B16,AI$5<=$D16),"█","")IF(AND(AJ$5>=$B16,AJ$5<=$D16),"█","")IF(AND(AK$5>=$B16,AK$5<=$D16),"█","")IF(AND(AL$5>=$B16,AL$5<=$D16),"█","")IF(AND(AM$5>=$B16,AM$5<=$D16),"█","")IF(AND(AN$5>=$B16,AN$5<=$D16),"█","")IF(AND(AO$5>=$B16,AO$5<=$D16),"█","")IF(AND(AP$5>=$B16,AP$5<=$D16),"█","")IF(AND(AQ$5>=$B16,AQ$5<=$D16),"█","")IF(AND(AR$5>=$B16,AR$5<=$D16),"█","")IF(AND(AS$5>=$B16,AS$5<=$D16),"█","")IF(AND(AT$5>=$B16,AT$5<=$D16),"█","")IF(AND(AU$5>=$B16,AU$5<=$D16),"█","")IF(AND(AV$5>=$B16,AV$5<=$D16),"█","")IF(AND(AW$5>=$B16,AW$5<=$D16),"█","")IF(AND(AX$5>=$B16,AX$5<=$D16),"█","")IF(AND(AY$5>=$B16,AY$5<=$D16),"█","")IF(AND(AZ$5>=$B16,AZ$5<=$D16),"█","")IF(AND(BA$5>=$B16,BA$5<=$D16),"█","")IF(AND(BB$5>=$B16,BB$5<=$D16),"█","")IF(AND(BC$5>=$B16,BC$5<=$D16),"█","")IF(AND(BD$5>=$B16,BD$5<=$D16),"█","")IF(AND(BE$5>=$B16,BE$5<=$D16),"█","")IF(AND(BF$5>=$B16,BF$5<=$D16),"█","")IF(AND(BG$5>=$B16,BG$5<=$D16),"█","")IF(AND(BH$5>=$B16,BH$5<=$D16),"█","")IF(AND(BI$5>=$B16,BI$5<=$D16),"█","")IF(AND(BJ$5>=$B16,BJ$5<=$D16),"█","")IF(AND(BK$5>=$B16,BK$5<=$D16),"█","")IF(AND(BL$5>=$B16,BL$5<=$D16),"█","")IF(AND(BM$5>=$B16,BM$5<=$D16),"█","")IF(AND(BN$5>=$B16,BN$5<=$D16),"█","")IF(AND(BO$5>=$B16,BO$5<=$D16),"█","")IF(AND(BP$5>=$B16,BP$5<=$D16),"█","")IF(AND(BQ$5>=$B16,BQ$5<=$D16),"█","")IF(AND(BR$5>=$B16,BR$5<=$D16),"█","")
E-Mail und Social MediaD16+14636628B17+C17-1463930Anmeldung öffnetIF(AND(H$5>=$B17,H$5<=$D17),"█","")IF(AND(I$5>=$B17,I$5<=$D17),"█","")IF(AND(J$5>=$B17,J$5<=$D17),"█","")IF(AND(K$5>=$B17,K$5<=$D17),"█","")IF(AND(L$5>=$B17,L$5<=$D17),"█","")IF(AND(M$5>=$B17,M$5<=$D17),"█","")IF(AND(N$5>=$B17,N$5<=$D17),"█","")IF(AND(O$5>=$B17,O$5<=$D17),"█","")IF(AND(P$5>=$B17,P$5<=$D17),"█","")IF(AND(Q$5>=$B17,Q$5<=$D17),"█","")IF(AND(R$5>=$B17,R$5<=$D17),"█","")IF(AND(S$5>=$B17,S$5<=$D17),"█","")IF(AND(T$5>=$B17,T$5<=$D17),"█","")IF(AND(U$5>=$B17,U$5<=$D17),"█","")IF(AND(V$5>=$B17,V$5<=$D17),"█","")IF(AND(W$5>=$B17,W$5<=$D17),"█","")IF(AND(X$5>=$B17,X$5<=$D17),"█","")IF(AND(Y$5>=$B17,Y$5<=$D17),"█","")IF(AND(Z$5>=$B17,Z$5<=$D17),"█","")IF(AND(AA$5>=$B17,AA$5<=$D17),"█","")IF(AND(AB$5>=$B17,AB$5<=$D17),"█","")IF(AND(AC$5>=$B17,AC$5<=$D17),"█","")IF(AND(AD$5>=$B17,AD$5<=$D17),"█","")IF(AND(AE$5>=$B17,AE$5<=$D17),"█","")IF(AND(AF$5>=$B17,AF$5<=$D17),"█","")█IF(AND(AG$5>=$B17,AG$5<=$D17),"█","")█IF(AND(AH$5>=$B17,AH$5<=$D17),"█","")█IF(AND(AI$5>=$B17,AI$5<=$D17),"█","")█IF(AND(AJ$5>=$B17,AJ$5<=$D17),"█","")█IF(AND(AK$5>=$B17,AK$5<=$D17),"█","")█IF(AND(AL$5>=$B17,AL$5<=$D17),"█","")█IF(AND(AM$5>=$B17,AM$5<=$D17),"█","")█IF(AND(AN$5>=$B17,AN$5<=$D17),"█","")█IF(AND(AO$5>=$B17,AO$5<=$D17),"█","")█IF(AND(AP$5>=$B17,AP$5<=$D17),"█","")█IF(AND(AQ$5>=$B17,AQ$5<=$D17),"█","")█IF(AND(AR$5>=$B17,AR$5<=$D17),"█","")█IF(AND(AS$5>=$B17,AS$5<=$D17),"█","")█IF(AND(AT$5>=$B17,AT$5<=$D17),"█","")█IF(AND(AU$5>=$B17,AU$5<=$D17),"█","")█IF(AND(AV$5>=$B17,AV$5<=$D17),"█","")█IF(AND(AW$5>=$B17,AW$5<=$D17),"█","")█IF(AND(AX$5>=$B17,AX$5<=$D17),"█","")█IF(AND(AY$5>=$B17,AY$5<=$D17),"█","")█IF(AND(AZ$5>=$B17,AZ$5<=$D17),"█","")█IF(AND(BA$5>=$B17,BA$5<=$D17),"█","")█IF(AND(BB$5>=$B17,BB$5<=$D17),"█","")█IF(AND(BC$5>=$B17,BC$5<=$D17),"█","")█IF(AND(BD$5>=$B17,BD$5<=$D17),"█","")█IF(AND(BE$5>=$B17,BE$5<=$D17),"█","")█IF(AND(BF$5>=$B17,BF$5<=$D17),"█","")█IF(AND(BG$5>=$B17,BG$5<=$D17),"█","")█IF(AND(BH$5>=$B17,BH$5<=$D17),"█","")IF(AND(BI$5>=$B17,BI$5<=$D17),"█","")IF(AND(BJ$5>=$B17,BJ$5<=$D17),"█","")IF(AND(BK$5>=$B17,BK$5<=$D17),"█","")IF(AND(BL$5>=$B17,BL$5<=$D17),"█","")IF(AND(BM$5>=$B17,BM$5<=$D17),"█","")IF(AND(BN$5>=$B17,BN$5<=$D17),"█","")IF(AND(BO$5>=$B17,BO$5<=$D17),"█","")IF(AND(BP$5>=$B17,BP$5<=$D17),"█","")IF(AND(BQ$5>=$B17,BQ$5<=$D17),"█","")IF(AND(BR$5>=$B17,BR$5<=$D17),"█","")
LogistikMIN(B19:B21)46372D18-B18+119MAX(D19:D21)46390IF(AND(H$5>=$B18,H$5<=$D18),"▬","")IF(AND(I$5>=$B18,I$5<=$D18),"▬","")IF(AND(J$5>=$B18,J$5<=$D18),"▬","")IF(AND(K$5>=$B18,K$5<=$D18),"▬","")IF(AND(L$5>=$B18,L$5<=$D18),"▬","")IF(AND(M$5>=$B18,M$5<=$D18),"▬","")IF(AND(N$5>=$B18,N$5<=$D18),"▬","")IF(AND(O$5>=$B18,O$5<=$D18),"▬","")IF(AND(P$5>=$B18,P$5<=$D18),"▬","")IF(AND(Q$5>=$B18,Q$5<=$D18),"▬","")IF(AND(R$5>=$B18,R$5<=$D18),"▬","")IF(AND(S$5>=$B18,S$5<=$D18),"▬","")IF(AND(T$5>=$B18,T$5<=$D18),"▬","")IF(AND(U$5>=$B18,U$5<=$D18),"▬","")IF(AND(V$5>=$B18,V$5<=$D18),"▬","")IF(AND(W$5>=$B18,W$5<=$D18),"▬","")IF(AND(X$5>=$B18,X$5<=$D18),"▬","")IF(AND(Y$5>=$B18,Y$5<=$D18),"▬","")IF(AND(Z$5>=$B18,Z$5<=$D18),"▬","")IF(AND(AA$5>=$B18,AA$5<=$D18),"▬","")IF(AND(AB$5>=$B18,AB$5<=$D18),"▬","")IF(AND(AC$5>=$B18,AC$5<=$D18),"▬","")IF(AND(AD$5>=$B18,AD$5<=$D18),"▬","")IF(AND(AE$5>=$B18,AE$5<=$D18),"▬","")IF(AND(AF$5>=$B18,AF$5<=$D18),"▬","")IF(AND(AG$5>=$B18,AG$5<=$D18),"▬","")IF(AND(AH$5>=$B18,AH$5<=$D18),"▬","")IF(AND(AI$5>=$B18,AI$5<=$D18),"▬","")IF(AND(AJ$5>=$B18,AJ$5<=$D18),"▬","")IF(AND(AK$5>=$B18,AK$5<=$D18),"▬","")IF(AND(AL$5>=$B18,AL$5<=$D18),"▬","")▬IF(AND(AM$5>=$B18,AM$5<=$D18),"▬","")▬IF(AND(AN$5>=$B18,AN$5<=$D18),"▬","")▬IF(AND(AO$5>=$B18,AO$5<=$D18),"▬","")▬IF(AND(AP$5>=$B18,AP$5<=$D18),"▬","")▬IF(AND(AQ$5>=$B18,AQ$5<=$D18),"▬","")▬IF(AND(AR$5>=$B18,AR$5<=$D18),"▬","")▬IF(AND(AS$5>=$B18,AS$5<=$D18),"▬","")▬IF(AND(AT$5>=$B18,AT$5<=$D18),"▬","")▬IF(AND(AU$5>=$B18,AU$5<=$D18),"▬","")▬IF(AND(AV$5>=$B18,AV$5<=$D18),"▬","")▬IF(AND(AW$5>=$B18,AW$5<=$D18),"▬","")▬IF(AND(AX$5>=$B18,AX$5<=$D18),"▬","")▬IF(AND(AY$5>=$B18,AY$5<=$D18),"▬","")▬IF(AND(AZ$5>=$B18,AZ$5<=$D18),"▬","")▬IF(AND(BA$5>=$B18,BA$5<=$D18),"▬","")▬IF(AND(BB$5>=$B18,BB$5<=$D18),"▬","")▬IF(AND(BC$5>=$B18,BC$5<=$D18),"▬","")▬IF(AND(BD$5>=$B18,BD$5<=$D18),"▬","")▬IF(AND(BE$5>=$B18,BE$5<=$D18),"▬","")IF(AND(BF$5>=$B18,BF$5<=$D18),"▬","")IF(AND(BG$5>=$B18,BG$5<=$D18),"▬","")IF(AND(BH$5>=$B18,BH$5<=$D18),"▬","")IF(AND(BI$5>=$B18,BI$5<=$D18),"▬","")IF(AND(BJ$5>=$B18,BJ$5<=$D18),"▬","")IF(AND(BK$5>=$B18,BK$5<=$D18),"▬","")IF(AND(BL$5>=$B18,BL$5<=$D18),"▬","")IF(AND(BM$5>=$B18,BM$5<=$D18),"▬","")IF(AND(BN$5>=$B18,BN$5<=$D18),"▬","")IF(AND(BO$5>=$B18,BO$5<=$D18),"▬","")IF(AND(BP$5>=$B18,BP$5<=$D18),"▬","")IF(AND(BQ$5>=$B18,BQ$5<=$D18),"▬","")IF(AND(BR$5>=$B18,BR$5<=$D18),"▬","")
CateringD11+18463725B19+C19-1463760Location gebuchtIF(AND(H$5>=$B19,H$5<=$D19),"█","")IF(AND(I$5>=$B19,I$5<=$D19),"█","")IF(AND(J$5>=$B19,J$5<=$D19),"█","")IF(AND(K$5>=$B19,K$5<=$D19),"█","")IF(AND(L$5>=$B19,L$5<=$D19),"█","")IF(AND(M$5>=$B19,M$5<=$D19),"█","")IF(AND(N$5>=$B19,N$5<=$D19),"█","")IF(AND(O$5>=$B19,O$5<=$D19),"█","")IF(AND(P$5>=$B19,P$5<=$D19),"█","")IF(AND(Q$5>=$B19,Q$5<=$D19),"█","")IF(AND(R$5>=$B19,R$5<=$D19),"█","")IF(AND(S$5>=$B19,S$5<=$D19),"█","")IF(AND(T$5>=$B19,T$5<=$D19),"█","")IF(AND(U$5>=$B19,U$5<=$D19),"█","")IF(AND(V$5>=$B19,V$5<=$D19),"█","")IF(AND(W$5>=$B19,W$5<=$D19),"█","")IF(AND(X$5>=$B19,X$5<=$D19),"█","")IF(AND(Y$5>=$B19,Y$5<=$D19),"█","")IF(AND(Z$5>=$B19,Z$5<=$D19),"█","")IF(AND(AA$5>=$B19,AA$5<=$D19),"█","")IF(AND(AB$5>=$B19,AB$5<=$D19),"█","")IF(AND(AC$5>=$B19,AC$5<=$D19),"█","")IF(AND(AD$5>=$B19,AD$5<=$D19),"█","")IF(AND(AE$5>=$B19,AE$5<=$D19),"█","")IF(AND(AF$5>=$B19,AF$5<=$D19),"█","")IF(AND(AG$5>=$B19,AG$5<=$D19),"█","")IF(AND(AH$5>=$B19,AH$5<=$D19),"█","")IF(AND(AI$5>=$B19,AI$5<=$D19),"█","")IF(AND(AJ$5>=$B19,AJ$5<=$D19),"█","")IF(AND(AK$5>=$B19,AK$5<=$D19),"█","")IF(AND(AL$5>=$B19,AL$5<=$D19),"█","")█IF(AND(AM$5>=$B19,AM$5<=$D19),"█","")█IF(AND(AN$5>=$B19,AN$5<=$D19),"█","")█IF(AND(AO$5>=$B19,AO$5<=$D19),"█","")█IF(AND(AP$5>=$B19,AP$5<=$D19),"█","")█IF(AND(AQ$5>=$B19,AQ$5<=$D19),"█","")IF(AND(AR$5>=$B19,AR$5<=$D19),"█","")IF(AND(AS$5>=$B19,AS$5<=$D19),"█","")IF(AND(AT$5>=$B19,AT$5<=$D19),"█","")IF(AND(AU$5>=$B19,AU$5<=$D19),"█","")IF(AND(AV$5>=$B19,AV$5<=$D19),"█","")IF(AND(AW$5>=$B19,AW$5<=$D19),"█","")IF(AND(AX$5>=$B19,AX$5<=$D19),"█","")IF(AND(AY$5>=$B19,AY$5<=$D19),"█","")IF(AND(AZ$5>=$B19,AZ$5<=$D19),"█","")IF(AND(BA$5>=$B19,BA$5<=$D19),"█","")IF(AND(BB$5>=$B19,BB$5<=$D19),"█","")IF(AND(BC$5>=$B19,BC$5<=$D19),"█","")IF(AND(BD$5>=$B19,BD$5<=$D19),"█","")IF(AND(BE$5>=$B19,BE$5<=$D19),"█","")IF(AND(BF$5>=$B19,BF$5<=$D19),"█","")IF(AND(BG$5>=$B19,BG$5<=$D19),"█","")IF(AND(BH$5>=$B19,BH$5<=$D19),"█","")IF(AND(BI$5>=$B19,BI$5<=$D19),"█","")IF(AND(BJ$5>=$B19,BJ$5<=$D19),"█","")IF(AND(BK$5>=$B19,BK$5<=$D19),"█","")IF(AND(BL$5>=$B19,BL$5<=$D19),"█","")IF(AND(BM$5>=$B19,BM$5<=$D19),"█","")IF(AND(BN$5>=$B19,BN$5<=$D19),"█","")IF(AND(BO$5>=$B19,BO$5<=$D19),"█","")IF(AND(BP$5>=$B19,BP$5<=$D19),"█","")IF(AND(BQ$5>=$B19,BQ$5<=$D19),"█","")IF(AND(BR$5>=$B19,BR$5<=$D19),"█","")
Technik und TonD14+13463775B20+C20-1463810Programm veröffentlichtIF(AND(H$5>=$B20,H$5<=$D20),"█","")IF(AND(I$5>=$B20,I$5<=$D20),"█","")IF(AND(J$5>=$B20,J$5<=$D20),"█","")IF(AND(K$5>=$B20,K$5<=$D20),"█","")IF(AND(L$5>=$B20,L$5<=$D20),"█","")IF(AND(M$5>=$B20,M$5<=$D20),"█","")IF(AND(N$5>=$B20,N$5<=$D20),"█","")IF(AND(O$5>=$B20,O$5<=$D20),"█","")IF(AND(P$5>=$B20,P$5<=$D20),"█","")IF(AND(Q$5>=$B20,Q$5<=$D20),"█","")IF(AND(R$5>=$B20,R$5<=$D20),"█","")IF(AND(S$5>=$B20,S$5<=$D20),"█","")IF(AND(T$5>=$B20,T$5<=$D20),"█","")IF(AND(U$5>=$B20,U$5<=$D20),"█","")IF(AND(V$5>=$B20,V$5<=$D20),"█","")IF(AND(W$5>=$B20,W$5<=$D20),"█","")IF(AND(X$5>=$B20,X$5<=$D20),"█","")IF(AND(Y$5>=$B20,Y$5<=$D20),"█","")IF(AND(Z$5>=$B20,Z$5<=$D20),"█","")IF(AND(AA$5>=$B20,AA$5<=$D20),"█","")IF(AND(AB$5>=$B20,AB$5<=$D20),"█","")IF(AND(AC$5>=$B20,AC$5<=$D20),"█","")IF(AND(AD$5>=$B20,AD$5<=$D20),"█","")IF(AND(AE$5>=$B20,AE$5<=$D20),"█","")IF(AND(AF$5>=$B20,AF$5<=$D20),"█","")IF(AND(AG$5>=$B20,AG$5<=$D20),"█","")IF(AND(AH$5>=$B20,AH$5<=$D20),"█","")IF(AND(AI$5>=$B20,AI$5<=$D20),"█","")IF(AND(AJ$5>=$B20,AJ$5<=$D20),"█","")IF(AND(AK$5>=$B20,AK$5<=$D20),"█","")IF(AND(AL$5>=$B20,AL$5<=$D20),"█","")IF(AND(AM$5>=$B20,AM$5<=$D20),"█","")IF(AND(AN$5>=$B20,AN$5<=$D20),"█","")IF(AND(AO$5>=$B20,AO$5<=$D20),"█","")IF(AND(AP$5>=$B20,AP$5<=$D20),"█","")IF(AND(AQ$5>=$B20,AQ$5<=$D20),"█","")█IF(AND(AR$5>=$B20,AR$5<=$D20),"█","")█IF(AND(AS$5>=$B20,AS$5<=$D20),"█","")█IF(AND(AT$5>=$B20,AT$5<=$D20),"█","")█IF(AND(AU$5>=$B20,AU$5<=$D20),"█","")█IF(AND(AV$5>=$B20,AV$5<=$D20),"█","")IF(AND(AW$5>=$B20,AW$5<=$D20),"█","")IF(AND(AX$5>=$B20,AX$5<=$D20),"█","")IF(AND(AY$5>=$B20,AY$5<=$D20),"█","")IF(AND(AZ$5>=$B20,AZ$5<=$D20),"█","")IF(AND(BA$5>=$B20,BA$5<=$D20),"█","")IF(AND(BB$5>=$B20,BB$5<=$D20),"█","")IF(AND(BC$5>=$B20,BC$5<=$D20),"█","")IF(AND(BD$5>=$B20,BD$5<=$D20),"█","")IF(AND(BE$5>=$B20,BE$5<=$D20),"█","")IF(AND(BF$5>=$B20,BF$5<=$D20),"█","")IF(AND(BG$5>=$B20,BG$5<=$D20),"█","")IF(AND(BH$5>=$B20,BH$5<=$D20),"█","")IF(AND(BI$5>=$B20,BI$5<=$D20),"█","")IF(AND(BJ$5>=$B20,BJ$5<=$D20),"█","")IF(AND(BK$5>=$B20,BK$5<=$D20),"█","")IF(AND(BL$5>=$B20,BL$5<=$D20),"█","")IF(AND(BM$5>=$B20,BM$5<=$D20),"█","")IF(AND(BN$5>=$B20,BN$5<=$D20),"█","")IF(AND(BO$5>=$B20,BO$5<=$D20),"█","")IF(AND(BP$5>=$B20,BP$5<=$D20),"█","")IF(AND(BQ$5>=$B20,BQ$5<=$D20),"█","")IF(AND(BR$5>=$B20,BR$5<=$D20),"█","")
Badges und BeschilderungD16+1+20463865B21+C21-1463900Anmeldung öffnetIF(AND(H$5>=$B21,H$5<=$D21),"█","")IF(AND(I$5>=$B21,I$5<=$D21),"█","")IF(AND(J$5>=$B21,J$5<=$D21),"█","")IF(AND(K$5>=$B21,K$5<=$D21),"█","")IF(AND(L$5>=$B21,L$5<=$D21),"█","")IF(AND(M$5>=$B21,M$5<=$D21),"█","")IF(AND(N$5>=$B21,N$5<=$D21),"█","")IF(AND(O$5>=$B21,O$5<=$D21),"█","")IF(AND(P$5>=$B21,P$5<=$D21),"█","")IF(AND(Q$5>=$B21,Q$5<=$D21),"█","")IF(AND(R$5>=$B21,R$5<=$D21),"█","")IF(AND(S$5>=$B21,S$5<=$D21),"█","")IF(AND(T$5>=$B21,T$5<=$D21),"█","")IF(AND(U$5>=$B21,U$5<=$D21),"█","")IF(AND(V$5>=$B21,V$5<=$D21),"█","")IF(AND(W$5>=$B21,W$5<=$D21),"█","")IF(AND(X$5>=$B21,X$5<=$D21),"█","")IF(AND(Y$5>=$B21,Y$5<=$D21),"█","")IF(AND(Z$5>=$B21,Z$5<=$D21),"█","")IF(AND(AA$5>=$B21,AA$5<=$D21),"█","")IF(AND(AB$5>=$B21,AB$5<=$D21),"█","")IF(AND(AC$5>=$B21,AC$5<=$D21),"█","")IF(AND(AD$5>=$B21,AD$5<=$D21),"█","")IF(AND(AE$5>=$B21,AE$5<=$D21),"█","")IF(AND(AF$5>=$B21,AF$5<=$D21),"█","")IF(AND(AG$5>=$B21,AG$5<=$D21),"█","")IF(AND(AH$5>=$B21,AH$5<=$D21),"█","")IF(AND(AI$5>=$B21,AI$5<=$D21),"█","")IF(AND(AJ$5>=$B21,AJ$5<=$D21),"█","")IF(AND(AK$5>=$B21,AK$5<=$D21),"█","")IF(AND(AL$5>=$B21,AL$5<=$D21),"█","")IF(AND(AM$5>=$B21,AM$5<=$D21),"█","")IF(AND(AN$5>=$B21,AN$5<=$D21),"█","")IF(AND(AO$5>=$B21,AO$5<=$D21),"█","")IF(AND(AP$5>=$B21,AP$5<=$D21),"█","")IF(AND(AQ$5>=$B21,AQ$5<=$D21),"█","")IF(AND(AR$5>=$B21,AR$5<=$D21),"█","")IF(AND(AS$5>=$B21,AS$5<=$D21),"█","")IF(AND(AT$5>=$B21,AT$5<=$D21),"█","")IF(AND(AU$5>=$B21,AU$5<=$D21),"█","")IF(AND(AV$5>=$B21,AV$5<=$D21),"█","")IF(AND(AW$5>=$B21,AW$5<=$D21),"█","")IF(AND(AX$5>=$B21,AX$5<=$D21),"█","")IF(AND(AY$5>=$B21,AY$5<=$D21),"█","")IF(AND(AZ$5>=$B21,AZ$5<=$D21),"█","")█IF(AND(BA$5>=$B21,BA$5<=$D21),"█","")█IF(AND(BB$5>=$B21,BB$5<=$D21),"█","")█IF(AND(BC$5>=$B21,BC$5<=$D21),"█","")█IF(AND(BD$5>=$B21,BD$5<=$D21),"█","")█IF(AND(BE$5>=$B21,BE$5<=$D21),"█","")IF(AND(BF$5>=$B21,BF$5<=$D21),"█","")IF(AND(BG$5>=$B21,BG$5<=$D21),"█","")IF(AND(BH$5>=$B21,BH$5<=$D21),"█","")IF(AND(BI$5>=$B21,BI$5<=$D21),"█","")IF(AND(BJ$5>=$B21,BJ$5<=$D21),"█","")IF(AND(BK$5>=$B21,BK$5<=$D21),"█","")IF(AND(BL$5>=$B21,BL$5<=$D21),"█","")IF(AND(BM$5>=$B21,BM$5<=$D21),"█","")IF(AND(BN$5>=$B21,BN$5<=$D21),"█","")IF(AND(BO$5>=$B21,BO$5<=$D21),"█","")IF(AND(BP$5>=$B21,BP$5<=$D21),"█","")IF(AND(BQ$5>=$B21,BQ$5<=$D21),"█","")IF(AND(BR$5>=$B21,BR$5<=$D21),"█","")
Event-TagMAX(D17+1,D20+1,D21+1)463940B22463940E-Mail und Social Media, Technik und Ton, Badges und BeschilderungIF(H$5=$B22,"◆","")IF(I$5=$B22,"◆","")IF(J$5=$B22,"◆","")IF(K$5=$B22,"◆","")IF(L$5=$B22,"◆","")IF(M$5=$B22,"◆","")IF(N$5=$B22,"◆","")IF(O$5=$B22,"◆","")IF(P$5=$B22,"◆","")IF(Q$5=$B22,"◆","")IF(R$5=$B22,"◆","")IF(S$5=$B22,"◆","")IF(T$5=$B22,"◆","")IF(U$5=$B22,"◆","")IF(V$5=$B22,"◆","")IF(W$5=$B22,"◆","")IF(X$5=$B22,"◆","")IF(Y$5=$B22,"◆","")IF(Z$5=$B22,"◆","")IF(AA$5=$B22,"◆","")IF(AB$5=$B22,"◆","")IF(AC$5=$B22,"◆","")IF(AD$5=$B22,"◆","")IF(AE$5=$B22,"◆","")IF(AF$5=$B22,"◆","")IF(AG$5=$B22,"◆","")IF(AH$5=$B22,"◆","")IF(AI$5=$B22,"◆","")IF(AJ$5=$B22,"◆","")IF(AK$5=$B22,"◆","")IF(AL$5=$B22,"◆","")IF(AM$5=$B22,"◆","")IF(AN$5=$B22,"◆","")IF(AO$5=$B22,"◆","")IF(AP$5=$B22,"◆","")IF(AQ$5=$B22,"◆","")IF(AR$5=$B22,"◆","")IF(AS$5=$B22,"◆","")IF(AT$5=$B22,"◆","")IF(AU$5=$B22,"◆","")IF(AV$5=$B22,"◆","")IF(AW$5=$B22,"◆","")IF(AX$5=$B22,"◆","")IF(AY$5=$B22,"◆","")IF(AZ$5=$B22,"◆","")IF(BA$5=$B22,"◆","")IF(BB$5=$B22,"◆","")IF(BC$5=$B22,"◆","")IF(BD$5=$B22,"◆","")IF(BE$5=$B22,"◆","")IF(BF$5=$B22,"◆","")IF(BG$5=$B22,"◆","")IF(BH$5=$B22,"◆","")◆IF(BI$5=$B22,"◆","")IF(BJ$5=$B22,"◆","")IF(BK$5=$B22,"◆","")IF(BL$5=$B22,"◆","")IF(BM$5=$B22,"◆","")IF(BN$5=$B22,"◆","")IF(BO$5=$B22,"◆","")IF(BP$5=$B22,"◆","")IF(BQ$5=$B22,"◆","")IF(BR$5=$B22,"◆","")
Nachbereitung und DankD22+1463953B23+C23-1463970Event-TagIF(AND(H$5>=$B23,H$5<=$D23),"█","")IF(AND(I$5>=$B23,I$5<=$D23),"█","")IF(AND(J$5>=$B23,J$5<=$D23),"█","")IF(AND(K$5>=$B23,K$5<=$D23),"█","")IF(AND(L$5>=$B23,L$5<=$D23),"█","")IF(AND(M$5>=$B23,M$5<=$D23),"█","")IF(AND(N$5>=$B23,N$5<=$D23),"█","")IF(AND(O$5>=$B23,O$5<=$D23),"█","")IF(AND(P$5>=$B23,P$5<=$D23),"█","")IF(AND(Q$5>=$B23,Q$5<=$D23),"█","")IF(AND(R$5>=$B23,R$5<=$D23),"█","")IF(AND(S$5>=$B23,S$5<=$D23),"█","")IF(AND(T$5>=$B23,T$5<=$D23),"█","")IF(AND(U$5>=$B23,U$5<=$D23),"█","")IF(AND(V$5>=$B23,V$5<=$D23),"█","")IF(AND(W$5>=$B23,W$5<=$D23),"█","")IF(AND(X$5>=$B23,X$5<=$D23),"█","")IF(AND(Y$5>=$B23,Y$5<=$D23),"█","")IF(AND(Z$5>=$B23,Z$5<=$D23),"█","")IF(AND(AA$5>=$B23,AA$5<=$D23),"█","")IF(AND(AB$5>=$B23,AB$5<=$D23),"█","")IF(AND(AC$5>=$B23,AC$5<=$D23),"█","")IF(AND(AD$5>=$B23,AD$5<=$D23),"█","")IF(AND(AE$5>=$B23,AE$5<=$D23),"█","")IF(AND(AF$5>=$B23,AF$5<=$D23),"█","")IF(AND(AG$5>=$B23,AG$5<=$D23),"█","")IF(AND(AH$5>=$B23,AH$5<=$D23),"█","")IF(AND(AI$5>=$B23,AI$5<=$D23),"█","")IF(AND(AJ$5>=$B23,AJ$5<=$D23),"█","")IF(AND(AK$5>=$B23,AK$5<=$D23),"█","")IF(AND(AL$5>=$B23,AL$5<=$D23),"█","")IF(AND(AM$5>=$B23,AM$5<=$D23),"█","")IF(AND(AN$5>=$B23,AN$5<=$D23),"█","")IF(AND(AO$5>=$B23,AO$5<=$D23),"█","")IF(AND(AP$5>=$B23,AP$5<=$D23),"█","")IF(AND(AQ$5>=$B23,AQ$5<=$D23),"█","")IF(AND(AR$5>=$B23,AR$5<=$D23),"█","")IF(AND(AS$5>=$B23,AS$5<=$D23),"█","")IF(AND(AT$5>=$B23,AT$5<=$D23),"█","")IF(AND(AU$5>=$B23,AU$5<=$D23),"█","")IF(AND(AV$5>=$B23,AV$5<=$D23),"█","")IF(AND(AW$5>=$B23,AW$5<=$D23),"█","")IF(AND(AX$5>=$B23,AX$5<=$D23),"█","")IF(AND(AY$5>=$B23,AY$5<=$D23),"█","")IF(AND(AZ$5>=$B23,AZ$5<=$D23),"█","")IF(AND(BA$5>=$B23,BA$5<=$D23),"█","")IF(AND(BB$5>=$B23,BB$5<=$D23),"█","")IF(AND(BC$5>=$B23,BC$5<=$D23),"█","")IF(AND(BD$5>=$B23,BD$5<=$D23),"█","")IF(AND(BE$5>=$B23,BE$5<=$D23),"█","")IF(AND(BF$5>=$B23,BF$5<=$D23),"█","")IF(AND(BG$5>=$B23,BG$5<=$D23),"█","")IF(AND(BH$5>=$B23,BH$5<=$D23),"█","")IF(AND(BI$5>=$B23,BI$5<=$D23),"█","")█IF(AND(BJ$5>=$B23,BJ$5<=$D23),"█","")█IF(AND(BK$5>=$B23,BK$5<=$D23),"█","")█IF(AND(BL$5>=$B23,BL$5<=$D23),"█","")IF(AND(BM$5>=$B23,BM$5<=$D23),"█","")IF(AND(BN$5>=$B23,BN$5<=$D23),"█","")IF(AND(BO$5>=$B23,BO$5<=$D23),"█","")IF(AND(BP$5>=$B23,BP$5<=$D23),"█","")IF(AND(BQ$5>=$B23,BQ$5<=$D23),"█","")IF(AND(BR$5>=$B23,BR$5<=$D23),"█","")
Made with Ganttmint · https://ganttmint.com/de/
PK `€ �ˆ ˆ xl/metadata.xml
PK ‡ėËA A xl/workbook.xml
PK JjùL L _rels/.rels
PK ”81 1 docProps/app.xml
SheetJSWorksheets1GanttPK ֒|Z Z docProps/core.xml
PK ¨×j€ [Content_Types].xml
PK ¤„¸µ µ xl/_rels/workbook.xml.relsPK 0ˆkÞ Þ í xl/theme/theme1.xmlPK )ï„)2 2
ü xl/styles.xmlPK ¾õO¥( ( # Y&