PK¤„¸µµxl/_rels/workbook.xml.rels PK0ˆkÞÞxl/theme/theme1.xml PK)ï„)22 xl/styles.xml PK|‡l''#xl/worksheets/_rels/sheet1.xml.rels PK‡!eúƄƄxl/worksheets/sheet1.xml Projektplan · GanttBearbeite Startdaten und Dauern im Blatt Aufgaben: Das Gantt-Diagramm aktualisiert sich von selbst.Start46342Online-Version, kostenlos und ohne Anmeldung: https://ganttmint.com/de/vorlagen/projektplan/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),"")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)27InitiierungMIN(B9:B11)46342D8-B8+15MAX(D9:D11)46346IF(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),"▬","") Kick-off-Meeting$B$3+0463421B9+C9-1463420IF(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),"█","") Ziele und UmfangD9+1463433B10+C10-1463450Kick-off-MeetingIF(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),"█","") Umfang freigegebenD10+1463460B11463460Ziele und UmfangIF(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,"◆","")PlanungMIN(B13:B16)46346D12-B12+17MAX(D13:D16)46352IF(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),"▬","") ArbeitspaketeD11463463B13+C13-1463480Umfang freigegebenIF(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),"█","") Budget und RessourcenD13+1463493B14+C14-1463510ArbeitspaketeIF(AND(H$5>=$B14,H$5<=$D14),"█","")IF(AND(I$5>=$B14,I$5<=$D14),"█","")IF(AND(J$5>=$B14,J$5<=$D14),"█","")IF(AND(K$5>=$B14,K$5<=$D14),"█","")IF(AND(L$5>=$B14,L$5<=$D14),"█","")IF(AND(M$5>=$B14,M$5<=$D14),"█","")IF(AND(N$5>=$B14,N$5<=$D14),"█","")IF(AND(O$5>=$B14,O$5<=$D14),"█","")█IF(AND(P$5>=$B14,P$5<=$D14),"█","")█IF(AND(Q$5>=$B14,Q$5<=$D14),"█","")█IF(AND(R$5>=$B14,R$5<=$D14),"█","")IF(AND(S$5>=$B14,S$5<=$D14),"█","")IF(AND(T$5>=$B14,T$5<=$D14),"█","")IF(AND(U$5>=$B14,U$5<=$D14),"█","")IF(AND(V$5>=$B14,V$5<=$D14),"█","")IF(AND(W$5>=$B14,W$5<=$D14),"█","")IF(AND(X$5>=$B14,X$5<=$D14),"█","")IF(AND(Y$5>=$B14,Y$5<=$D14),"█","")IF(AND(Z$5>=$B14,Z$5<=$D14),"█","")IF(AND(AA$5>=$B14,AA$5<=$D14),"█","")IF(AND(AB$5>=$B14,AB$5<=$D14),"█","")IF(AND(AC$5>=$B14,AC$5<=$D14),"█","")IF(AND(AD$5>=$B14,AD$5<=$D14),"█","")IF(AND(AE$5>=$B14,AE$5<=$D14),"█","")IF(AND(AF$5>=$B14,AF$5<=$D14),"█","")IF(AND(AG$5>=$B14,AG$5<=$D14),"█","")IF(AND(AH$5>=$B14,AH$5<=$D14),"█","")IF(AND(AI$5>=$B14,AI$5<=$D14),"█","")IF(AND(AJ$5>=$B14,AJ$5<=$D14),"█","")IF(AND(AK$5>=$B14,AK$5<=$D14),"█","")IF(AND(AL$5>=$B14,AL$5<=$D14),"█","")IF(AND(AM$5>=$B14,AM$5<=$D14),"█","")IF(AND(AN$5>=$B14,AN$5<=$D14),"█","")IF(AND(AO$5>=$B14,AO$5<=$D14),"█","")IF(AND(AP$5>=$B14,AP$5<=$D14),"█","")IF(AND(AQ$5>=$B14,AQ$5<=$D14),"█","")IF(AND(AR$5>=$B14,AR$5<=$D14),"█","")IF(AND(AS$5>=$B14,AS$5<=$D14),"█","")IF(AND(AT$5>=$B14,AT$5<=$D14),"█","")IF(AND(AU$5>=$B14,AU$5<=$D14),"█","")IF(AND(AV$5>=$B14,AV$5<=$D14),"█","")IF(AND(AW$5>=$B14,AW$5<=$D14),"█","") RisikoanalyseD13+1463492B15+C15-1463500ArbeitspaketeIF(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),"█","") Plan freigegebenMAX(D14+1,D15+1)463520B16463520Budget und Ressourcen, RisikoanalyseIF(H$5=$B16,"◆","")IF(I$5=$B16,"◆","")IF(J$5=$B16,"◆","")IF(K$5=$B16,"◆","")IF(L$5=$B16,"◆","")IF(M$5=$B16,"◆","")IF(N$5=$B16,"◆","")IF(O$5=$B16,"◆","")IF(P$5=$B16,"◆","")IF(Q$5=$B16,"◆","")IF(R$5=$B16,"◆","")◆IF(S$5=$B16,"◆","")IF(T$5=$B16,"◆","")IF(U$5=$B16,"◆","")IF(V$5=$B16,"◆","")IF(W$5=$B16,"◆","")IF(X$5=$B16,"◆","")IF(Y$5=$B16,"◆","")IF(Z$5=$B16,"◆","")IF(AA$5=$B16,"◆","")IF(AB$5=$B16,"◆","")IF(AC$5=$B16,"◆","")IF(AD$5=$B16,"◆","")IF(AE$5=$B16,"◆","")IF(AF$5=$B16,"◆","")IF(AG$5=$B16,"◆","")IF(AH$5=$B16,"◆","")IF(AI$5=$B16,"◆","")IF(AJ$5=$B16,"◆","")IF(AK$5=$B16,"◆","")IF(AL$5=$B16,"◆","")IF(AM$5=$B16,"◆","")IF(AN$5=$B16,"◆","")IF(AO$5=$B16,"◆","")IF(AP$5=$B16,"◆","")IF(AQ$5=$B16,"◆","")IF(AR$5=$B16,"◆","")IF(AS$5=$B16,"◆","")IF(AT$5=$B16,"◆","")IF(AU$5=$B16,"◆","")IF(AV$5=$B16,"◆","")IF(AW$5=$B16,"◆","")DurchführungMIN(B18:B21)46352D17-B17+119MAX(D18:D21)46370IF(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),"▬","") Arbeitspaket 1D164635210B18+C18-1463610Plan freigegebenIF(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),"█","") Arbeitspaket 2D16+54635710B19+C19-1463660Plan freigegebenIF(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),"█","") StatusmeetingsD164635215B20+C20-1463660Plan freigegebenIF(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),"█","") AbnahmeMAX(D18+1,D19+1)463674B21+C21-1463700Arbeitspaket 1, Arbeitspaket 2IF(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),"█","")AbschlussMIN(B23:B25)46371D22-B22+14MAX(D23:D25)46374IF(AND(H$5>=$B22,H$5<=$D22),"▬","")IF(AND(I$5>=$B22,I$5<=$D22),"▬","")IF(AND(J$5>=$B22,J$5<=$D22),"▬","")IF(AND(K$5>=$B22,K$5<=$D22),"▬","")IF(AND(L$5>=$B22,L$5<=$D22),"▬","")IF(AND(M$5>=$B22,M$5<=$D22),"▬","")IF(AND(N$5>=$B22,N$5<=$D22),"▬","")IF(AND(O$5>=$B22,O$5<=$D22),"▬","")IF(AND(P$5>=$B22,P$5<=$D22),"▬","")IF(AND(Q$5>=$B22,Q$5<=$D22),"▬","")IF(AND(R$5>=$B22,R$5<=$D22),"▬","")IF(AND(S$5>=$B22,S$5<=$D22),"▬","")IF(AND(T$5>=$B22,T$5<=$D22),"▬","")IF(AND(U$5>=$B22,U$5<=$D22),"▬","")IF(AND(V$5>=$B22,V$5<=$D22),"▬","")IF(AND(W$5>=$B22,W$5<=$D22),"▬","")IF(AND(X$5>=$B22,X$5<=$D22),"▬","")IF(AND(Y$5>=$B22,Y$5<=$D22),"▬","")IF(AND(Z$5>=$B22,Z$5<=$D22),"▬","")IF(AND(AA$5>=$B22,AA$5<=$D22),"▬","")IF(AND(AB$5>=$B22,AB$5<=$D22),"▬","")IF(AND(AC$5>=$B22,AC$5<=$D22),"▬","")IF(AND(AD$5>=$B22,AD$5<=$D22),"▬","")IF(AND(AE$5>=$B22,AE$5<=$D22),"▬","")IF(AND(AF$5>=$B22,AF$5<=$D22),"▬","")IF(AND(AG$5>=$B22,AG$5<=$D22),"▬","")IF(AND(AH$5>=$B22,AH$5<=$D22),"▬","")IF(AND(AI$5>=$B22,AI$5<=$D22),"▬","")IF(AND(AJ$5>=$B22,AJ$5<=$D22),"▬","")IF(AND(AK$5>=$B22,AK$5<=$D22),"▬","")▬IF(AND(AL$5>=$B22,AL$5<=$D22),"▬","")▬IF(AND(AM$5>=$B22,AM$5<=$D22),"▬","")▬IF(AND(AN$5>=$B22,AN$5<=$D22),"▬","")▬IF(AND(AO$5>=$B22,AO$5<=$D22),"▬","")IF(AND(AP$5>=$B22,AP$5<=$D22),"▬","")IF(AND(AQ$5>=$B22,AQ$5<=$D22),"▬","")IF(AND(AR$5>=$B22,AR$5<=$D22),"▬","")IF(AND(AS$5>=$B22,AS$5<=$D22),"▬","")IF(AND(AT$5>=$B22,AT$5<=$D22),"▬","")IF(AND(AU$5>=$B22,AU$5<=$D22),"▬","")IF(AND(AV$5>=$B22,AV$5<=$D22),"▬","")IF(AND(AW$5>=$B22,AW$5<=$D22),"▬","") ÜbergabeD21+1463712B23+C23-1463720AbnahmeIF(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),"█","") RetrospektiveD23+1463731B24+C24-1463730ÜbergabeIF(AND(H$5>=$B24,H$5<=$D24),"█","")IF(AND(I$5>=$B24,I$5<=$D24),"█","")IF(AND(J$5>=$B24,J$5<=$D24),"█","")IF(AND(K$5>=$B24,K$5<=$D24),"█","")IF(AND(L$5>=$B24,L$5<=$D24),"█","")IF(AND(M$5>=$B24,M$5<=$D24),"█","")IF(AND(N$5>=$B24,N$5<=$D24),"█","")IF(AND(O$5>=$B24,O$5<=$D24),"█","")IF(AND(P$5>=$B24,P$5<=$D24),"█","")IF(AND(Q$5>=$B24,Q$5<=$D24),"█","")IF(AND(R$5>=$B24,R$5<=$D24),"█","")IF(AND(S$5>=$B24,S$5<=$D24),"█","")IF(AND(T$5>=$B24,T$5<=$D24),"█","")IF(AND(U$5>=$B24,U$5<=$D24),"█","")IF(AND(V$5>=$B24,V$5<=$D24),"█","")IF(AND(W$5>=$B24,W$5<=$D24),"█","")IF(AND(X$5>=$B24,X$5<=$D24),"█","")IF(AND(Y$5>=$B24,Y$5<=$D24),"█","")IF(AND(Z$5>=$B24,Z$5<=$D24),"█","")IF(AND(AA$5>=$B24,AA$5<=$D24),"█","")IF(AND(AB$5>=$B24,AB$5<=$D24),"█","")IF(AND(AC$5>=$B24,AC$5<=$D24),"█","")IF(AND(AD$5>=$B24,AD$5<=$D24),"█","")IF(AND(AE$5>=$B24,AE$5<=$D24),"█","")IF(AND(AF$5>=$B24,AF$5<=$D24),"█","")IF(AND(AG$5>=$B24,AG$5<=$D24),"█","")IF(AND(AH$5>=$B24,AH$5<=$D24),"█","")IF(AND(AI$5>=$B24,AI$5<=$D24),"█","")IF(AND(AJ$5>=$B24,AJ$5<=$D24),"█","")IF(AND(AK$5>=$B24,AK$5<=$D24),"█","")IF(AND(AL$5>=$B24,AL$5<=$D24),"█","")IF(AND(AM$5>=$B24,AM$5<=$D24),"█","")█IF(AND(AN$5>=$B24,AN$5<=$D24),"█","")IF(AND(AO$5>=$B24,AO$5<=$D24),"█","")IF(AND(AP$5>=$B24,AP$5<=$D24),"█","")IF(AND(AQ$5>=$B24,AQ$5<=$D24),"█","")IF(AND(AR$5>=$B24,AR$5<=$D24),"█","")IF(AND(AS$5>=$B24,AS$5<=$D24),"█","")IF(AND(AT$5>=$B24,AT$5<=$D24),"█","")IF(AND(AU$5>=$B24,AU$5<=$D24),"█","")IF(AND(AV$5>=$B24,AV$5<=$D24),"█","")IF(AND(AW$5>=$B24,AW$5<=$D24),"█","") Projekt abgeschlossenD24+1463740B25463740RetrospektiveIF(H$5=$B25,"◆","")IF(I$5=$B25,"◆","")IF(J$5=$B25,"◆","")IF(K$5=$B25,"◆","")IF(L$5=$B25,"◆","")IF(M$5=$B25,"◆","")IF(N$5=$B25,"◆","")IF(O$5=$B25,"◆","")IF(P$5=$B25,"◆","")IF(Q$5=$B25,"◆","")IF(R$5=$B25,"◆","")IF(S$5=$B25,"◆","")IF(T$5=$B25,"◆","")IF(U$5=$B25,"◆","")IF(V$5=$B25,"◆","")IF(W$5=$B25,"◆","")IF(X$5=$B25,"◆","")IF(Y$5=$B25,"◆","")IF(Z$5=$B25,"◆","")IF(AA$5=$B25,"◆","")IF(AB$5=$B25,"◆","")IF(AC$5=$B25,"◆","")IF(AD$5=$B25,"◆","")IF(AE$5=$B25,"◆","")IF(AF$5=$B25,"◆","")IF(AG$5=$B25,"◆","")IF(AH$5=$B25,"◆","")IF(AI$5=$B25,"◆","")IF(AJ$5=$B25,"◆","")IF(AK$5=$B25,"◆","")IF(AL$5=$B25,"◆","")IF(AM$5=$B25,"◆","")IF(AN$5=$B25,"◆","")◆IF(AO$5=$B25,"◆","")IF(AP$5=$B25,"◆","")IF(AQ$5=$B25,"◆","")IF(AR$5=$B25,"◆","")IF(AS$5=$B25,"◆","")IF(AT$5=$B25,"◆","")IF(AU$5=$B25,"◆","")IF(AV$5=$B25,"◆","")IF(AW$5=$B25,"◆","")Made with Ganttmint · https://ganttmint.com/de/PK`€�ˆˆxl/metadata.xml PK‡ėËAAxl/workbook.xml PKJjùLL _rels/.rels PK”811docProps/app.xml SheetJSWorksheets1GanttPK֒|ZZdocProps/core.xml PK¨×j€[Content_Types].xml PK¤„¸µµxl/_rels/workbook.xml.relsPK0ˆkÞÞíxl/theme/theme1.xmlPK)ï„)22 ü xl/styles.xmlPK|‡l''#Y&xl/worksheets/_rels/sheet1.xml.relsPK‡!eúƄƄÁ(xl/worksheets/sheet1.xmlPK`€�ˆˆ½­xl/metadata.xmlPK‡ėËAAr±xl/workbook.xmlPKJjùLL à²_rels/.relsPK”811UµdocProps/app.xmlPK֒|ZZ´·docProps/core.xmlPK¨×j€=¹[Content_Types].xmlPK ̃Á