{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Glossar","Allgemeine Informationen","Planung","Budget","Risikoregister","Ergebnisse","Änderung","Sitzungen","Verantwortungsmatrix"],"not_rendered":{"charts":10,"images":1,"macros":1,"external_links":1,"defined_names":54,"comments":0,"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":"Glossar","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,2,1]]}
[]
[]
["KURZES GLOSSAR DES PROJEKTMANAGEMENTS"]
[]
["BUDGET","Allgemeine Liste der geplanten Ausgaben."]
["PROJEKTLEITER/IN","Person, die mit der Planung und Ausführung eines Projekts und mit der Leitung eines Projektteams beauftragt ist. "]
["ÄNDERUNG DES UMFANGS","Dies bezieht sich auf die Art, wie sich der Umfang eines Projekts mit der Zeit ändern und über die ursprünglichen Parameter (Ziele, Lieferprodukte, Ressourcen) hinauswachsen kann. In diesem Fall besteht ein Risiko, dass zu viel ausgegeben oder die Fristen nicht eingehalten werden. \nJede grössere Neubeurteilung des Projektumfangs muss durch den/die Auftraggeber/in / den Steuerungsausschuss genehmigt werden. \nNach der Genehmigung sind das Budget, die Planung und die Ressourcen zu aktualisieren, damit diese mit dem neuen Projektumfang übereinstimmen."]
["PROJEKTTEAM","Die Projektorganisation ist eine temporäre Organisation, die in enger Beziehung zur Stammorganisation steht. Sie wird mit dem Projektinitialisierungsauftrag in Kraft gesetzt und mit dem Entscheid zum Projektabschluss aufgelöst.\nDie Projektorganisation besteht aus verschiedenen Rollen (Auftraggeber/in, Projektleiter/in, Fachspezialist/in). Sie regeln die Aufgaben, Kompetenzen und Verantwortung der Projektbeteiligten."]
["INDIKATOREN","Messbare Indikatoren des Projektfortschritts, die vor Projektbeginn festgelegt werden.\nBsp. Haben wir heute 10 000 Klicks erreicht? Diese Woche 50 Verkaufsanrufe getätigt? Die Zeit für die Problemlösung der Kundschaft verkürzt? \nMit den Indikatoren kann der Projektverlauf verfolgt werden und wenn notwendig wieder auf Kurs gebracht werden."]
["MEILENSTEIN","Am Anfang und am Ende einer Projektphase befindet sich jeweils ein Meilenstein. Diese Meilensteine sind das Ergebnis aus Entscheidungsaufgaben. Die Entscheide sind den Hierarchieebenen Steuerung, Führung und Ausführung zugeordnet. "]
["AUFTRAGGEBER/IN","Verantwortlich für den Erfolg des Projekts und die Erreichung der Ziele innerhalb des gesetzten Kosten- und Terminrahmens. Immer eine einzelne natürliche Person aus der Stammorganisation."]
["PROJEKTZIEL/E","Wird in Abstimmung mit den Strategien und Zielen der Dienststelle und/oder des Staats Freiburg festgelegt."]
["STAKEHOLDER","Personen, die ein Interesse an der Durchführung des Projekts haben: Dienstchef/in, Kundschaft, Team, externe Dienstleister usw. \nAlle vom Projekt betroffenen Personen."]
["PROJEKTUMFANG","Der Umfang definiert den Rahmen des Projekts, seine Ziele, seine Ergebnisse und die notwendigen Ressourcen genau, um sicherzustellen, dass die gesamte für das Projekt erforderliche Arbeit, und nur die erforderliche Arbeit, geleistet wird. Der Projektumfang bezieht sich hauptsächlich auf die Definition und die Beherrschung dessen, was zum Projekt gehört und dessen, was nicht zum Projekt gehört (ausser Projekt)."]
["PROJEKTMANAGEMENTPLAN","Der Projektmanagementplan beinhaltet die Gesamtplanung des Projekts und die wesentlichen Regelungen zu Zielen, Umfang, Budget, Rollen, die projektspezifisch festgelegt werden. Er dient als einheitliche Handlungsgrundlage für alle Projektbeteiligten. Er wird im Projektverlauf nach dem Prinzip der rollenden Planung kontinuierlich konkretisiert und nachgeführt. Bei Phasenabschluss wird er zur Abwicklung der nächsten Phase den veränderten Bedingungen angepasst."]
["RISIKOREGISTER","Dokument zur Analyse verschiedener Projektrisiken und Planung von angemessenen Reaktionen für den Fall, dass Risiken eintreten."]
["RESSOURCEN","Alles, was für die Erledigung einer Aufgabe notwendig ist. Es kann sich um Personen, Hilfsmittel, Geld, Zeit und Einrichtungen handeln."]
["ERGEBNISSE (LIEFERPRODUKTE)","Arbeitsprodukt, das an einem Datum und in einem Zustand geliefert wird, die im Projektmanagementplan festgelegt wurden. Ein Ergebnis kann ein physisches Produkt, eine Datei, ein Organigramm, ein Prozess usw. sein."]

{"sheet":"Allgemeine Informationen","index":1,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,0,6,1],[6,2,6,3],[2,0,2,1],[4,0,4,1],[4,2,4,3],[5,2,5,3],[5,0,5,1],[7,0,12,1],[13,0,13,1],[13,2,13,3],[14,0,17,1],[14,2,22,3],[18,0,18,1]]}
[]
[]
["ALLGEMEINE INFORMATIONEN"]
[]
["Projektname",null,"Budget (ohne interne HR-Kosten)"]
["Projektname",null,"«Genehmigtes Projektbudget in CHF»"]
["Hauptziel",null,"Makroplanung (nur Startdaten angeben)"]
[null,null,"Freigabe","TT/MM/JJJJ"]
[null,null,"Initialisierung","TT/MM/JJJJ"]
[null,null,"Konzept","TT/MM/JJJJ"]
[null,null,"Realisierung","TT/MM/JJJJ"]
[null,null,"Einführung","TT/MM/JJJJ"]
[null,null,"Ende","TT/MM/JJJJ"]
["Umfang",null,"Hauptrisiken"]
[]
[]
[]
[]
["Organisation"]
["Name Auftraggeber/in","Vorname, Name"]
["Name Projektleiter/in","Vorname, Name"]
[]
["…"]
[]
["ANWEISUNG"]
["Die leeren Felder mit den entsprechenden Informationen füllen."]

{"sheet":"Planung","index":2,"n_rows":44,"n_cols":111,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,6,1],[0,2,0,5],[3,2,3,5],[5,2,5,5],[7,72,7,76],[7,7,7,11],[7,16,7,19],[7,12,7,15],[7,77,7,80],[7,55,7,58],[7,68,7,71],[7,20,7,23],[7,59,7,63],[7,64,7,67],[7,46,7,50],[7,51,7,54],[7,24,7,28],[7,29,7,32],[7,33,7,36],[7,37,7,41],[7,42,7,45],[7,107,7,110],[7,81,7,84],[7,94,7,97],[7,85,7,89],[7,90,7,93],[7,103,7,106],[7,98,7,102]]}
["PROJEKTPLANUNG\n(Beispiel)",null,"Verwendung",null,null,null,"Spalte F «Status» – Erklärung des Drop-down-Menüs"]
[null,null," - Copy&Paste verwenden",null,null,null,"Geplante und bestätigte Daten","Geplant"]
[null,null," - Die Formatierung der Zellen nicht verändern",null,null,null,"Aktivität begonnen",0.25]
[null,null,"STARTMONAT DES PROJEKTS",null,null,null,"Zu 50 % erledigt",0.5]
[null,null,null,"2021-03-07",null,null,"Fast fertig, es bleiben einige Aufgaben abzuschliessen",0.75]
[null,null,"Hier Startdatum des Projekts einfügen",null,null,null,"Beendet","Beendet","=> Automatische Änderung in blau"]
[]
["Aktivität / Vorrangige Aufgabe","Gruppe","Anfang","Ende","Neues","Status","Bemerkungen",{"$f":"H10","v":"2021-03-07"},null,null,null,null,{"$f":"M10","v":"2021-04-11"},null,null,null,{"$f":"Q10","v":"2021-05-09"},null,null,null,{"$f":"U10","v":"2021-06-06"},null,null,null,{"$f":"Y10","v":"2021-07-04"},null,null,null,null,{"$f":"AD10","v":"2021-08-08"},null,null,null,{"$f":"AH10","v":"2021-09-05"},null,null,null,{"$f":"AL10","v":"2021-10-03"},null,null,null,null,{"$f":"AQ10","v":"2021-11-07"},null,null,null,{"$f":"AV10","v":"2021-12-12"},null,null,null,null,{"$f":"AZ10","v":"2022-01-09"},null,null,null,{"$f":"BD10","v":"2022-02-06"},null,null,null,{"$f":"BH10","v":"2022-03-06"},null,null,null,null,{"$f":"BM10","v":"2022-04-10"},null,null,null,{"$f":"BQ10","v":"2022-05-08"},null,null,null,{"$f":"BV10","v":"2022-06-12"},null,null,null,null,{"$f":"BZ10","v":"2022-07-10"},null,null,null,{"$f":"CD10","v":"2022-08-07"},null,null,null,{"$f":"CI10","v":"2022-09-11"},null,null,null,null,{"$f":"CM10","v":"2022-10-09"},null,null,null,{"$f":"CQ10","v":"2022-11-06"},null,null,null,{"$f":"CU10","v":"2022-12-04"},null,null,null,null,{"$f":"CZ10","v":"2023-01-08"},null,null,null,{"$f":"DD10","v":"2023-02-05"}]
[null,null,"Datum","Datum","Enddatum",null,null,{"$f":"WEEKNUM(H10,2)","v":10},11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,{"$f":"WEEKNUM(AN10,2)","v":42},43,44,45,46,47,48,49,50,51,52,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,{"$f":"WEEKNUM(BT10,2)","v":22},23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,1,{"$f":"WEEKNUM(CZ10,2)","v":2},3,4,5,6,7,8,9]
[null,null,null,null,null,null,null,{"$f":"D5","v":"2021-03-07"},{"$f":"H10+7","v":"2021-03-14"},"2021-03-21","2021-03-28","2021-04-04","2021-04-11","2021-04-18","2021-04-25","2021-05-02","2021-05-09","2021-05-16","2021-05-23","2021-05-30","2021-06-06","2021-06-13","2021-06-20","2021-06-27","2021-07-04","2021-07-11","2021-07-18","2021-07-25","2021-08-01","2021-08-08","2021-08-15","2021-08-22","2021-08-29","2021-09-05",{"$f":"AH10+7","v":"2021-09-12"},"2021-09-19","2021-09-26","2021-10-03",{"$f":"AL10+7","v":"2021-10-10"},{"$f":"AM10+7","v":"2021-10-17"},{"$f":"AN10+7","v":"2021-10-24"},{"$f":"AO10+7","v":"2021-10-31"},{"$f":"AP10+7","v":"2021-11-07"},{"$f":"AQ10+7","v":"2021-11-14"},"2021-11-21","2021-11-28","2021-12-05","2021-12-12","2021-12-19","2021-12-26","2022-01-02","2022-01-09","2022-01-16","2022-01-23","2022-01-30","2022-02-06","2022-02-13","2022-02-20","2022-02-27",{"$f":"BG10+7","v":"2022-03-06"},{"$f":"BH10+7","v":"2022-03-13"},{"$f":"BI10+7","v":"2022-03-20"},"2022-03-27","2022-04-03","2022-04-10","2022-04-17","2022-04-24","2022-05-01","2022-05-08","2022-05-15","2022-05-22","2022-05-29","2022-06-05","2022-06-12","2022-06-19","2022-06-26","2022-07-03","2022-07-10","2022-07-17","2022-07-24","2022-07-31","2022-08-07","2022-08-14","2022-08-21","2022-08-28","2022-09-04","2022-09-11","2022-09-18","2022-09-25","2022-10-02","2022-10-09","2022-10-16","2022-10-23","2022-10-30","2022-11-06","2022-11-13","2022-11-20","2022-11-27","2022-12-04","2022-12-11","2022-12-18","2022-12-25","2023-01-01","2023-01-08","2023-01-15","2023-01-22","2023-01-29","2023-02-05","2023-02-12","2023-02-19","2023-02-26"]
[null,null,null,null,null,null,null,{"$f":"IF(OR(AND($C11>=H$10,$C11< I$10),AND($D11>=H$10,$D11<I$10),AND($E11>=H$10,$E11<I$10),IF($C11<>0,AND($C11<=H$10,$D11>=H$10),FALSE),AND($D11<=H$10,$E11>=H$10)),IF(AND(AND($D11>=H$10,$D11<I$10),$E11<>0),IF($F11=\"Done\",\"Z\",\"Y\"),IF($F11=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C11>=AN$10,$C11< AO$10),AND($D11>=AN$10,$D11<AO$10),AND($E11>=AN$10,$E11<AO$10),IF($C11<>0,AND($C11<=AN$10,$D11>=AN$10),FALSE),AND($D11<=AN$10,$E11>=AN$10)),IF(AND(AND($D11>=AN$10,$D11<AO$10),$E11<>0),IF($F11=\"Done\",\"Z\",\"Y\"),IF($F11=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C11>=BT$10,$C11< BU$10),AND($D11>=BT$10,$D11<BU$10),AND($E11>=BT$10,$E11<BU$10),IF($C11<>0,AND($C11<=BT$10,$D11>=BT$10),FALSE),AND($D11<=BT$10,$E11>=BT$10)),IF(AND(AND($D11>=BT$10,$D11<BU$10),$E11<>0),IF($F11=\"Done\",\"Z\",\"Y\"),IF($F11=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C11>=CZ$10,$C11< DA$10),AND($D11>=CZ$10,$D11<DA$10),AND($E11>=CZ$10,$E11<DA$10),IF($C11<>0,AND($C11<=CZ$10,$D11>=CZ$10),FALSE),AND($D11<=CZ$10,$E11>=CZ$10)),IF(AND(AND($D11>=CZ$10,$D11<DA$10),$E11<>0),IF($F11=\"Done\",\"Z\",\"Y\"),IF($F11=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","",{"$f":"IF(OR(AND($C11>=DG$10,$C11< DH$10),AND($D11>=DG$10,$D11<DH$10),AND($E11>=DG$10,$E11<DH$10),IF($C11<>0,AND($C11<=DG$10,$D11>=DG$10),FALSE),AND($D11<=DG$10,$E11>=DG$10)),IF(AND(AND($D11>=DG$10,$D11<DH$10),$E11<>0),IF($F11=\"Done\",\"Z\",\"Y\"),IF($F11=\"Done\",\"Z\",\"X\")),\"\")","v":""}]
["Phasen Hermes 5",null,null,null,null,null,null,{"$f":"IF(OR(AND($C12>=H$10,$C12< I$10),AND($D12>=H$10,$D12<I$10),AND($E12>=H$10,$E12<I$10),IF($C12<>0,AND($C12<=H$10,$D12>=H$10),FALSE),AND($D12<=H$10,$E12>=H$10)),IF(AND(AND($D12>=H$10,$D12<I$10),$E12<>0),IF($F12=\"Done\",\"Z\",\"Y\"),IF($F12=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C12>=AN$10,$C12< AO$10),AND($D12>=AN$10,$D12<AO$10),AND($E12>=AN$10,$E12<AO$10),IF($C12<>0,AND($C12<=AN$10,$D12>=AN$10),FALSE),AND($D12<=AN$10,$E12>=AN$10)),IF(AND(AND($D12>=AN$10,$D12<AO$10),$E12<>0),IF($F12=\"Done\",\"Z\",\"Y\"),IF($F12=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C12>=BT$10,$C12< BU$10),AND($D12>=BT$10,$D12<BU$10),AND($E12>=BT$10,$E12<BU$10),IF($C12<>0,AND($C12<=BT$10,$D12>=BT$10),FALSE),AND($D12<=BT$10,$E12>=BT$10)),IF(AND(AND($D12>=BT$10,$D12<BU$10),$E12<>0),IF($F12=\"Done\",\"Z\",\"Y\"),IF($F12=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C12>=CZ$10,$C12< DA$10),AND($D12>=CZ$10,$D12<DA$10),AND($E12>=CZ$10,$E12<DA$10),IF($C12<>0,AND($C12<=CZ$10,$D12>=CZ$10),FALSE),AND($D12<=CZ$10,$E12>=CZ$10)),IF(AND(AND($D12>=CZ$10,$D12<DA$10),$E12<>0),IF($F12=\"Done\",\"Z\",\"Y\"),IF($F12=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","",{"$f":"IF(OR(AND($C12>=DG$10,$C12< DH$10),AND($D12>=DG$10,$D12<DH$10),AND($E12>=DG$10,$E12<DH$10),IF($C12<>0,AND($C12<=DG$10,$D12>=DG$10),FALSE),AND($D12<=DG$10,$E12>=DG$10)),IF(AND(AND($D12>=DG$10,$D12<DH$10),$E12<>0),IF($F12=\"Done\",\"Z\",\"Y\"),IF($F12=\"Done\",\"Z\",\"X\")),\"\")","v":""}]
["Initialisierung",null,"2021-03-07","2021-09-01",null,0.25,null,{"$f":"IF(OR(AND($C13>=H$10,$C13< I$10),AND($D13>=H$10,$D13<I$10),AND($E13>=H$10,$E13<I$10),IF($C13<>0,AND($C13<=H$10,$D13>=H$10),FALSE),AND($D13<=H$10,$E13>=H$10)),IF(AND(AND($D13>=H$10,$D13<I$10),$E13<>0),IF($F13=\"Beedet\",\"Z\",\"Y\"),IF($F13=\"Beendet\",\"Z\",\"X\")),\"\")","v":"X"},{"$f":"IF(OR(AND($C13>=I$10,$C13< J$10),AND($D13>=I$10,$D13<J$10),AND($E13>=I$10,$E13<J$10),IF($C13<>0,AND($C13<=I$10,$D13>=I$10),FALSE),AND($D13<=I$10,$E13>=I$10)),IF(AND(AND($D13>=I$10,$D13<J$10),$E13<>0),IF($F13=\"Beedet\",\"Z\",\"Y\"),IF($F13=\"Beendet\",\"Z\",\"X\")),\"\")","v":"X"},"X","X","X","X","X","X",{"$f":"IF(OR(AND($C13>=P$10,$C13< Q$10),AND($D13>=P$10,$D13<Q$10),AND($E13>=P$10,$E13<Q$10),IF($C13<>0,AND($C13<=P$10,$D13>=P$10),FALSE),AND($D13<=P$10,$E13>=P$10)),IF(AND(AND($D13>=P$10,$D13<Q$10),$E13<>0),IF($F13=\"Beedet\",\"Z\",\"Y\"),IF($F13=\"Beendet\",\"Z\",\"X\")),\"\")","v":"X"},"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","","","","","","","","","",{"$f":"IF(OR(AND($C13>=AQ$10,$C13< AR$10),AND($D13>=AQ$10,$D13<AR$10),AND($E13>=AQ$10,$E13<AR$10),IF($C13<>0,AND($C13<=AQ$10,$D13>=AQ$10),FALSE),AND($D13<=AQ$10,$E13>=AQ$10)),IF(AND(AND($D13>=AQ$10,$D13<AR$10),$E13<>0),IF($F13=\"Beedet\",\"Z\",\"Y\"),IF($F13=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C13>=AR$10,$C13< AS$10),AND($D13>=AR$10,$D13<AS$10),AND($E13>=AR$10,$E13<AS$10),IF($C13<>0,AND($C13<=AR$10,$D13>=AR$10),FALSE),AND($D13<=AR$10,$E13>=AR$10)),IF(AND(AND($D13>=AR$10,$D13<AS$10),$E13<>0),IF($F13=\"Beedet\",\"Z\",\"Y\"),IF($F13=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C13>=BZ$10,$C13< CA$10),AND($D13>=BZ$10,$D13<CA$10),AND($E13>=BZ$10,$E13<CA$10),IF($C13<>0,AND($C13<=BZ$10,$D13>=BZ$10),FALSE),AND($D13<=BZ$10,$E13>=BZ$10)),IF(AND(AND($D13>=BZ$10,$D13<CA$10),$E13<>0),IF($F13=\"Beedet\",\"Z\",\"Y\"),IF($F13=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C13>=CA$10,$C13< CB$10),AND($D13>=CA$10,$D13<CB$10),AND($E13>=CA$10,$E13<CB$10),IF($C13<>0,AND($C13<=CA$10,$D13>=CA$10),FALSE),AND($D13<=CA$10,$E13>=CA$10)),IF(AND(AND($D13>=CA$10,$D13<CB$10),$E13<>0),IF($F13=\"Beedet\",\"Z\",\"Y\"),IF($F13=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C13>=DG$10,$C13< DH$10),AND($D13>=DG$10,$D13<DH$10),AND($E13>=DG$10,$E13<DH$10),IF($C13<>0,AND($C13<=DG$10,$D13>=DG$10),FALSE),AND($D13<=DG$10,$E13>=DG$10)),IF(AND(AND($D13>=DG$10,$D13<DH$10),$E13<>0),IF($F13=\"Beedet\",\"Z\",\"Y\"),IF($F13=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 1","Fachspezialist/in","2021-03-07","2021-04-01",null,"Beendet",null,{"$f":"IF(OR(AND($C14>=H$10,$C14< I$10),AND($D14>=H$10,$D14<I$10),AND($E14>=H$10,$E14<I$10),IF($C14<>0,AND($C14<=H$10,$D14>=H$10),FALSE),AND($D14<=H$10,$E14>=H$10)),IF(AND(AND($D14>=H$10,$D14<I$10),$E14<>0),IF($F14=\"Beedet\",\"Z\",\"Y\"),IF($F14=\"Beendet\",\"Z\",\"X\")),\"\")","v":"Z"},"Z","Z","Z","","","","",{"$f":"IF(OR(AND($C14>=P$10,$C14< Q$10),AND($D14>=P$10,$D14<Q$10),AND($E14>=P$10,$E14<Q$10),IF($C14<>0,AND($C14<=P$10,$D14>=P$10),FALSE),AND($D14<=P$10,$E14>=P$10)),IF(AND(AND($D14>=P$10,$D14<Q$10),$E14<>0),IF($F14=\"Beedet\",\"Z\",\"Y\"),IF($F14=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C14>=AY$10,$C14< AZ$10),AND($D14>=AY$10,$D14<AZ$10),AND($E14>=AY$10,$E14<AZ$10),IF($C14<>0,AND($C14<=AY$10,$D14>=AY$10),FALSE),AND($D14<=AY$10,$E14>=AY$10)),IF(AND(AND($D14>=AY$10,$D14<AZ$10),$E14<>0),IF($F14=\"Beedet\",\"Z\",\"Y\"),IF($F14=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C14>=DG$10,$C14< DH$10),AND($D14>=DG$10,$D14<DH$10),AND($E14>=DG$10,$E14<DH$10),IF($C14<>0,AND($C14<=DG$10,$D14>=DG$10),FALSE),AND($D14<=DG$10,$E14>=DG$10)),IF(AND(AND($D14>=DG$10,$D14<DH$10),$E14<>0),IF($F14=\"Beedet\",\"Z\",\"Y\"),IF($F14=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 2","Auftraggeber/in",null,"2021-05-01",null,0.5,null,"","","","","","","","X",{"$f":"IF(OR(AND($C15>=P$10,$C15< Q$10),AND($D15>=P$10,$D15<Q$10),AND($E15>=P$10,$E15<Q$10),IF($C15<>0,AND($C15<=P$10,$D15>=P$10),FALSE),AND($D15<=P$10,$E15>=P$10)),IF(AND(AND($D15>=P$10,$D15<Q$10),$E15<>0),IF($F15=\"Beedet\",\"Z\",\"Y\"),IF($F15=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C15>=AY$10,$C15< AZ$10),AND($D15>=AY$10,$D15<AZ$10),AND($E15>=AY$10,$E15<AZ$10),IF($C15<>0,AND($C15<=AY$10,$D15>=AY$10),FALSE),AND($D15<=AY$10,$E15>=AY$10)),IF(AND(AND($D15>=AY$10,$D15<AZ$10),$E15<>0),IF($F15=\"Beedet\",\"Z\",\"Y\"),IF($F15=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C15>=DG$10,$C15< DH$10),AND($D15>=DG$10,$D15<DH$10),AND($E15>=DG$10,$E15<DH$10),IF($C15<>0,AND($C15<=DG$10,$D15>=DG$10),FALSE),AND($D15<=DG$10,$E15>=DG$10)),IF(AND(AND($D15>=DG$10,$D15<DH$10),$E15<>0),IF($F15=\"Beedet\",\"Z\",\"Y\"),IF($F15=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 3","Projektleiter/in","2021-04-01","2021-05-01",null,0.25,null,"","","","X","X","X","X","X",{"$f":"IF(OR(AND($C16>=P$10,$C16< Q$10),AND($D16>=P$10,$D16<Q$10),AND($E16>=P$10,$E16<Q$10),IF($C16<>0,AND($C16<=P$10,$D16>=P$10),FALSE),AND($D16<=P$10,$E16>=P$10)),IF(AND(AND($D16>=P$10,$D16<Q$10),$E16<>0),IF($F16=\"Beedet\",\"Z\",\"Y\"),IF($F16=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C16>=AY$10,$C16< AZ$10),AND($D16>=AY$10,$D16<AZ$10),AND($E16>=AY$10,$E16<AZ$10),IF($C16<>0,AND($C16<=AY$10,$D16>=AY$10),FALSE),AND($D16<=AY$10,$E16>=AY$10)),IF(AND(AND($D16>=AY$10,$D16<AZ$10),$E16<>0),IF($F16=\"Beedet\",\"Z\",\"Y\"),IF($F16=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C16>=DG$10,$C16< DH$10),AND($D16>=DG$10,$D16<DH$10),AND($E16>=DG$10,$E16<DH$10),IF($C16<>0,AND($C16<=DG$10,$D16>=DG$10),FALSE),AND($D16<=DG$10,$E16>=DG$10)),IF(AND(AND($D16>=DG$10,$D16<DH$10),$E16<>0),IF($F16=\"Beedet\",\"Z\",\"Y\"),IF($F16=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 4","Projektleiter/in","2021-05-01","2021-07-01",null,0.25,null,"","","","","","","","X",{"$f":"IF(OR(AND($C17>=P$10,$C17< Q$10),AND($D17>=P$10,$D17<Q$10),AND($E17>=P$10,$E17<Q$10),IF($C17<>0,AND($C17<=P$10,$D17>=P$10),FALSE),AND($D17<=P$10,$E17>=P$10)),IF(AND(AND($D17>=P$10,$D17<Q$10),$E17<>0),IF($F17=\"Beedet\",\"Z\",\"Y\"),IF($F17=\"Beendet\",\"Z\",\"X\")),\"\")","v":"X"},"X","X","X","X","X","X","X","X","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C17>=AY$10,$C17< AZ$10),AND($D17>=AY$10,$D17<AZ$10),AND($E17>=AY$10,$E17<AZ$10),IF($C17<>0,AND($C17<=AY$10,$D17>=AY$10),FALSE),AND($D17<=AY$10,$E17>=AY$10)),IF(AND(AND($D17>=AY$10,$D17<AZ$10),$E17<>0),IF($F17=\"Beedet\",\"Z\",\"Y\"),IF($F17=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C17>=DG$10,$C17< DH$10),AND($D17>=DG$10,$D17<DH$10),AND($E17>=DG$10,$E17<DH$10),IF($C17<>0,AND($C17<=DG$10,$D17>=DG$10),FALSE),AND($D17<=DG$10,$E17>=DG$10)),IF(AND(AND($D17>=DG$10,$D17<DH$10),$E17<>0),IF($F17=\"Beedet\",\"Z\",\"Y\"),IF($F17=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 5","Fachspezialist/in","2021-07-01","2021-08-15",null,"Geplant",null,"","","","","","","","",{"$f":"IF(OR(AND($C18>=P$10,$C18< Q$10),AND($D18>=P$10,$D18<Q$10),AND($E18>=P$10,$E18<Q$10),IF($C18<>0,AND($C18<=P$10,$D18>=P$10),FALSE),AND($D18<=P$10,$E18>=P$10)),IF(AND(AND($D18>=P$10,$D18<Q$10),$E18<>0),IF($F18=\"Beedet\",\"Z\",\"Y\"),IF($F18=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","X","X","X","X","X","X","X","X","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C18>=AY$10,$C18< AZ$10),AND($D18>=AY$10,$D18<AZ$10),AND($E18>=AY$10,$E18<AZ$10),IF($C18<>0,AND($C18<=AY$10,$D18>=AY$10),FALSE),AND($D18<=AY$10,$E18>=AY$10)),IF(AND(AND($D18>=AY$10,$D18<AZ$10),$E18<>0),IF($F18=\"Beedet\",\"Z\",\"Y\"),IF($F18=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C18>=DG$10,$C18< DH$10),AND($D18>=DG$10,$D18<DH$10),AND($E18>=DG$10,$E18<DH$10),IF($C18<>0,AND($C18<=DG$10,$D18>=DG$10),FALSE),AND($D18<=DG$10,$E18>=DG$10)),IF(AND(AND($D18>=DG$10,$D18<DH$10),$E18<>0),IF($F18=\"Beedet\",\"Z\",\"Y\"),IF($F18=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 6","Auftraggeber/in","2021-08-15","2021-08-22",null,"Geplant",null,"","","","","","","","",{"$f":"IF(OR(AND($C19>=P$10,$C19< Q$10),AND($D19>=P$10,$D19<Q$10),AND($E19>=P$10,$E19<Q$10),IF($C19<>0,AND($C19<=P$10,$D19>=P$10),FALSE),AND($D19<=P$10,$E19>=P$10)),IF(AND(AND($D19>=P$10,$D19<Q$10),$E19<>0),IF($F19=\"Beedet\",\"Z\",\"Y\"),IF($F19=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","X","X","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C19>=AY$10,$C19< AZ$10),AND($D19>=AY$10,$D19<AZ$10),AND($E19>=AY$10,$E19<AZ$10),IF($C19<>0,AND($C19<=AY$10,$D19>=AY$10),FALSE),AND($D19<=AY$10,$E19>=AY$10)),IF(AND(AND($D19>=AY$10,$D19<AZ$10),$E19<>0),IF($F19=\"Beedet\",\"Z\",\"Y\"),IF($F19=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C19>=DG$10,$C19< DH$10),AND($D19>=DG$10,$D19<DH$10),AND($E19>=DG$10,$E19<DH$10),IF($C19<>0,AND($C19<=DG$10,$D19>=DG$10),FALSE),AND($D19<=DG$10,$E19>=DG$10)),IF(AND(AND($D19>=DG$10,$D19<DH$10),$E19<>0),IF($F19=\"Beedet\",\"Z\",\"Y\"),IF($F19=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Meilenstein (grünes Licht in der Phase Konzept)","Projektausschuss","2021-08-23","2021-09-01",null,"Geplant",null,"","","","","","","","",{"$f":"IF(OR(AND($C20>=P$10,$C20< Q$10),AND($D20>=P$10,$D20<Q$10),AND($E20>=P$10,$E20<Q$10),IF($C20<>0,AND($C20<=P$10,$D20>=P$10),FALSE),AND($D20<=P$10,$E20>=P$10)),IF(AND(AND($D20>=P$10,$D20<Q$10),$E20<>0),IF($F20=\"Beedet\",\"Z\",\"Y\"),IF($F20=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","X","X","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C20>=AY$10,$C20< AZ$10),AND($D20>=AY$10,$D20<AZ$10),AND($E20>=AY$10,$E20<AZ$10),IF($C20<>0,AND($C20<=AY$10,$D20>=AY$10),FALSE),AND($D20<=AY$10,$E20>=AY$10)),IF(AND(AND($D20>=AY$10,$D20<AZ$10),$E20<>0),IF($F20=\"Beedet\",\"Z\",\"Y\"),IF($F20=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C20>=DG$10,$C20< DH$10),AND($D20>=DG$10,$D20<DH$10),AND($E20>=DG$10,$E20<DH$10),IF($C20<>0,AND($C20<=DG$10,$D20>=DG$10),FALSE),AND($D20<=DG$10,$E20>=DG$10)),IF(AND(AND($D20>=DG$10,$D20<DH$10),$E20<>0),IF($F20=\"Beedet\",\"Z\",\"Y\"),IF($F20=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Konzept",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C21>=P$10,$C21< Q$10),AND($D21>=P$10,$D21<Q$10),AND($E21>=P$10,$E21<Q$10),IF($C21<>0,AND($C21<=P$10,$D21>=P$10),FALSE),AND($D21<=P$10,$E21>=P$10)),IF(AND(AND($D21>=P$10,$D21<Q$10),$E21<>0),IF($F21=\"Beedet\",\"Z\",\"Y\"),IF($F21=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C21>=AY$10,$C21< AZ$10),AND($D21>=AY$10,$D21<AZ$10),AND($E21>=AY$10,$E21<AZ$10),IF($C21<>0,AND($C21<=AY$10,$D21>=AY$10),FALSE),AND($D21<=AY$10,$E21>=AY$10)),IF(AND(AND($D21>=AY$10,$D21<AZ$10),$E21<>0),IF($F21=\"Beedet\",\"Z\",\"Y\"),IF($F21=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C21>=DG$10,$C21< DH$10),AND($D21>=DG$10,$D21<DH$10),AND($E21>=DG$10,$E21<DH$10),IF($C21<>0,AND($C21<=DG$10,$D21>=DG$10),FALSE),AND($D21<=DG$10,$E21>=DG$10)),IF(AND(AND($D21>=DG$10,$D21<DH$10),$E21<>0),IF($F21=\"Beedet\",\"Z\",\"Y\"),IF($F21=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 1",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C22>=P$10,$C22< Q$10),AND($D22>=P$10,$D22<Q$10),AND($E22>=P$10,$E22<Q$10),IF($C22<>0,AND($C22<=P$10,$D22>=P$10),FALSE),AND($D22<=P$10,$E22>=P$10)),IF(AND(AND($D22>=P$10,$D22<Q$10),$E22<>0),IF($F22=\"Beedet\",\"Z\",\"Y\"),IF($F22=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C22>=AY$10,$C22< AZ$10),AND($D22>=AY$10,$D22<AZ$10),AND($E22>=AY$10,$E22<AZ$10),IF($C22<>0,AND($C22<=AY$10,$D22>=AY$10),FALSE),AND($D22<=AY$10,$E22>=AY$10)),IF(AND(AND($D22>=AY$10,$D22<AZ$10),$E22<>0),IF($F22=\"Beedet\",\"Z\",\"Y\"),IF($F22=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C22>=DG$10,$C22< DH$10),AND($D22>=DG$10,$D22<DH$10),AND($E22>=DG$10,$E22<DH$10),IF($C22<>0,AND($C22<=DG$10,$D22>=DG$10),FALSE),AND($D22<=DG$10,$E22>=DG$10)),IF(AND(AND($D22>=DG$10,$D22<DH$10),$E22<>0),IF($F22=\"Beedet\",\"Z\",\"Y\"),IF($F22=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 2","Auftraggeber/in",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C23>=P$10,$C23< Q$10),AND($D23>=P$10,$D23<Q$10),AND($E23>=P$10,$E23<Q$10),IF($C23<>0,AND($C23<=P$10,$D23>=P$10),FALSE),AND($D23<=P$10,$E23>=P$10)),IF(AND(AND($D23>=P$10,$D23<Q$10),$E23<>0),IF($F23=\"Beedet\",\"Z\",\"Y\"),IF($F23=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C23>=AY$10,$C23< AZ$10),AND($D23>=AY$10,$D23<AZ$10),AND($E23>=AY$10,$E23<AZ$10),IF($C23<>0,AND($C23<=AY$10,$D23>=AY$10),FALSE),AND($D23<=AY$10,$E23>=AY$10)),IF(AND(AND($D23>=AY$10,$D23<AZ$10),$E23<>0),IF($F23=\"Beedet\",\"Z\",\"Y\"),IF($F23=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C23>=DG$10,$C23< DH$10),AND($D23>=DG$10,$D23<DH$10),AND($E23>=DG$10,$E23<DH$10),IF($C23<>0,AND($C23<=DG$10,$D23>=DG$10),FALSE),AND($D23<=DG$10,$E23>=DG$10)),IF(AND(AND($D23>=DG$10,$D23<DH$10),$E23<>0),IF($F23=\"Beedet\",\"Z\",\"Y\"),IF($F23=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 3","Proj.Mgmt",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C24>=P$10,$C24< Q$10),AND($D24>=P$10,$D24<Q$10),AND($E24>=P$10,$E24<Q$10),IF($C24<>0,AND($C24<=P$10,$D24>=P$10),FALSE),AND($D24<=P$10,$E24>=P$10)),IF(AND(AND($D24>=P$10,$D24<Q$10),$E24<>0),IF($F24=\"Beedet\",\"Z\",\"Y\"),IF($F24=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C24>=AY$10,$C24< AZ$10),AND($D24>=AY$10,$D24<AZ$10),AND($E24>=AY$10,$E24<AZ$10),IF($C24<>0,AND($C24<=AY$10,$D24>=AY$10),FALSE),AND($D24<=AY$10,$E24>=AY$10)),IF(AND(AND($D24>=AY$10,$D24<AZ$10),$E24<>0),IF($F24=\"Beedet\",\"Z\",\"Y\"),IF($F24=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C24>=DG$10,$C24< DH$10),AND($D24>=DG$10,$D24<DH$10),AND($E24>=DG$10,$E24<DH$10),IF($C24<>0,AND($C24<=DG$10,$D24>=DG$10),FALSE),AND($D24<=DG$10,$E24>=DG$10)),IF(AND(AND($D24>=DG$10,$D24<DH$10),$E24<>0),IF($F24=\"Beedet\",\"Z\",\"Y\"),IF($F24=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 4",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C25>=P$10,$C25< Q$10),AND($D25>=P$10,$D25<Q$10),AND($E25>=P$10,$E25<Q$10),IF($C25<>0,AND($C25<=P$10,$D25>=P$10),FALSE),AND($D25<=P$10,$E25>=P$10)),IF(AND(AND($D25>=P$10,$D25<Q$10),$E25<>0),IF($F25=\"Beedet\",\"Z\",\"Y\"),IF($F25=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C25>=AY$10,$C25< AZ$10),AND($D25>=AY$10,$D25<AZ$10),AND($E25>=AY$10,$E25<AZ$10),IF($C25<>0,AND($C25<=AY$10,$D25>=AY$10),FALSE),AND($D25<=AY$10,$E25>=AY$10)),IF(AND(AND($D25>=AY$10,$D25<AZ$10),$E25<>0),IF($F25=\"Beedet\",\"Z\",\"Y\"),IF($F25=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C25>=DG$10,$C25< DH$10),AND($D25>=DG$10,$D25<DH$10),AND($E25>=DG$10,$E25<DH$10),IF($C25<>0,AND($C25<=DG$10,$D25>=DG$10),FALSE),AND($D25<=DG$10,$E25>=DG$10)),IF(AND(AND($D25>=DG$10,$D25<DH$10),$E25<>0),IF($F25=\"Beedet\",\"Z\",\"Y\"),IF($F25=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 5",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C26>=P$10,$C26< Q$10),AND($D26>=P$10,$D26<Q$10),AND($E26>=P$10,$E26<Q$10),IF($C26<>0,AND($C26<=P$10,$D26>=P$10),FALSE),AND($D26<=P$10,$E26>=P$10)),IF(AND(AND($D26>=P$10,$D26<Q$10),$E26<>0),IF($F26=\"Beedet\",\"Z\",\"Y\"),IF($F26=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C26>=AY$10,$C26< AZ$10),AND($D26>=AY$10,$D26<AZ$10),AND($E26>=AY$10,$E26<AZ$10),IF($C26<>0,AND($C26<=AY$10,$D26>=AY$10),FALSE),AND($D26<=AY$10,$E26>=AY$10)),IF(AND(AND($D26>=AY$10,$D26<AZ$10),$E26<>0),IF($F26=\"Beedet\",\"Z\",\"Y\"),IF($F26=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C26>=DG$10,$C26< DH$10),AND($D26>=DG$10,$D26<DH$10),AND($E26>=DG$10,$E26<DH$10),IF($C26<>0,AND($C26<=DG$10,$D26>=DG$10),FALSE),AND($D26<=DG$10,$E26>=DG$10)),IF(AND(AND($D26>=DG$10,$D26<DH$10),$E26<>0),IF($F26=\"Beedet\",\"Z\",\"Y\"),IF($F26=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 6",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C27>=P$10,$C27< Q$10),AND($D27>=P$10,$D27<Q$10),AND($E27>=P$10,$E27<Q$10),IF($C27<>0,AND($C27<=P$10,$D27>=P$10),FALSE),AND($D27<=P$10,$E27>=P$10)),IF(AND(AND($D27>=P$10,$D27<Q$10),$E27<>0),IF($F27=\"Beedet\",\"Z\",\"Y\"),IF($F27=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C27>=AY$10,$C27< AZ$10),AND($D27>=AY$10,$D27<AZ$10),AND($E27>=AY$10,$E27<AZ$10),IF($C27<>0,AND($C27<=AY$10,$D27>=AY$10),FALSE),AND($D27<=AY$10,$E27>=AY$10)),IF(AND(AND($D27>=AY$10,$D27<AZ$10),$E27<>0),IF($F27=\"Beedet\",\"Z\",\"Y\"),IF($F27=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C27>=DG$10,$C27< DH$10),AND($D27>=DG$10,$D27<DH$10),AND($E27>=DG$10,$E27<DH$10),IF($C27<>0,AND($C27<=DG$10,$D27>=DG$10),FALSE),AND($D27<=DG$10,$E27>=DG$10)),IF(AND(AND($D27>=DG$10,$D27<DH$10),$E27<>0),IF($F27=\"Beedet\",\"Z\",\"Y\"),IF($F27=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Meilenstein (grünes Licht in der Phase Realisierung)","Auftraggeber/in",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C28>=P$10,$C28< Q$10),AND($D28>=P$10,$D28<Q$10),AND($E28>=P$10,$E28<Q$10),IF($C28<>0,AND($C28<=P$10,$D28>=P$10),FALSE),AND($D28<=P$10,$E28>=P$10)),IF(AND(AND($D28>=P$10,$D28<Q$10),$E28<>0),IF($F28=\"Beedet\",\"Z\",\"Y\"),IF($F28=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C28>=AY$10,$C28< AZ$10),AND($D28>=AY$10,$D28<AZ$10),AND($E28>=AY$10,$E28<AZ$10),IF($C28<>0,AND($C28<=AY$10,$D28>=AY$10),FALSE),AND($D28<=AY$10,$E28>=AY$10)),IF(AND(AND($D28>=AY$10,$D28<AZ$10),$E28<>0),IF($F28=\"Beedet\",\"Z\",\"Y\"),IF($F28=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C28>=DG$10,$C28< DH$10),AND($D28>=DG$10,$D28<DH$10),AND($E28>=DG$10,$E28<DH$10),IF($C28<>0,AND($C28<=DG$10,$D28>=DG$10),FALSE),AND($D28<=DG$10,$E28>=DG$10)),IF(AND(AND($D28>=DG$10,$D28<DH$10),$E28<>0),IF($F28=\"Beedet\",\"Z\",\"Y\"),IF($F28=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Umsetzung",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C29>=P$10,$C29< Q$10),AND($D29>=P$10,$D29<Q$10),AND($E29>=P$10,$E29<Q$10),IF($C29<>0,AND($C29<=P$10,$D29>=P$10),FALSE),AND($D29<=P$10,$E29>=P$10)),IF(AND(AND($D29>=P$10,$D29<Q$10),$E29<>0),IF($F29=\"Beedet\",\"Z\",\"Y\"),IF($F29=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C29>=AY$10,$C29< AZ$10),AND($D29>=AY$10,$D29<AZ$10),AND($E29>=AY$10,$E29<AZ$10),IF($C29<>0,AND($C29<=AY$10,$D29>=AY$10),FALSE),AND($D29<=AY$10,$E29>=AY$10)),IF(AND(AND($D29>=AY$10,$D29<AZ$10),$E29<>0),IF($F29=\"Beedet\",\"Z\",\"Y\"),IF($F29=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C29>=DG$10,$C29< DH$10),AND($D29>=DG$10,$D29<DH$10),AND($E29>=DG$10,$E29<DH$10),IF($C29<>0,AND($C29<=DG$10,$D29>=DG$10),FALSE),AND($D29<=DG$10,$E29>=DG$10)),IF(AND(AND($D29>=DG$10,$D29<DH$10),$E29<>0),IF($F29=\"Beedet\",\"Z\",\"Y\"),IF($F29=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 1",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C30>=P$10,$C30< Q$10),AND($D30>=P$10,$D30<Q$10),AND($E30>=P$10,$E30<Q$10),IF($C30<>0,AND($C30<=P$10,$D30>=P$10),FALSE),AND($D30<=P$10,$E30>=P$10)),IF(AND(AND($D30>=P$10,$D30<Q$10),$E30<>0),IF($F30=\"Beedet\",\"Z\",\"Y\"),IF($F30=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C30>=AY$10,$C30< AZ$10),AND($D30>=AY$10,$D30<AZ$10),AND($E30>=AY$10,$E30<AZ$10),IF($C30<>0,AND($C30<=AY$10,$D30>=AY$10),FALSE),AND($D30<=AY$10,$E30>=AY$10)),IF(AND(AND($D30>=AY$10,$D30<AZ$10),$E30<>0),IF($F30=\"Beedet\",\"Z\",\"Y\"),IF($F30=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C30>=DG$10,$C30< DH$10),AND($D30>=DG$10,$D30<DH$10),AND($E30>=DG$10,$E30<DH$10),IF($C30<>0,AND($C30<=DG$10,$D30>=DG$10),FALSE),AND($D30<=DG$10,$E30>=DG$10)),IF(AND(AND($D30>=DG$10,$D30<DH$10),$E30<>0),IF($F30=\"Beedet\",\"Z\",\"Y\"),IF($F30=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 2",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C31>=P$10,$C31< Q$10),AND($D31>=P$10,$D31<Q$10),AND($E31>=P$10,$E31<Q$10),IF($C31<>0,AND($C31<=P$10,$D31>=P$10),FALSE),AND($D31<=P$10,$E31>=P$10)),IF(AND(AND($D31>=P$10,$D31<Q$10),$E31<>0),IF($F31=\"Beedet\",\"Z\",\"Y\"),IF($F31=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C31>=AY$10,$C31< AZ$10),AND($D31>=AY$10,$D31<AZ$10),AND($E31>=AY$10,$E31<AZ$10),IF($C31<>0,AND($C31<=AY$10,$D31>=AY$10),FALSE),AND($D31<=AY$10,$E31>=AY$10)),IF(AND(AND($D31>=AY$10,$D31<AZ$10),$E31<>0),IF($F31=\"Beedet\",\"Z\",\"Y\"),IF($F31=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C31>=DG$10,$C31< DH$10),AND($D31>=DG$10,$D31<DH$10),AND($E31>=DG$10,$E31<DH$10),IF($C31<>0,AND($C31<=DG$10,$D31>=DG$10),FALSE),AND($D31<=DG$10,$E31>=DG$10)),IF(AND(AND($D31>=DG$10,$D31<DH$10),$E31<>0),IF($F31=\"Beedet\",\"Z\",\"Y\"),IF($F31=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 3",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C32>=P$10,$C32< Q$10),AND($D32>=P$10,$D32<Q$10),AND($E32>=P$10,$E32<Q$10),IF($C32<>0,AND($C32<=P$10,$D32>=P$10),FALSE),AND($D32<=P$10,$E32>=P$10)),IF(AND(AND($D32>=P$10,$D32<Q$10),$E32<>0),IF($F32=\"Beedet\",\"Z\",\"Y\"),IF($F32=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C32>=AY$10,$C32< AZ$10),AND($D32>=AY$10,$D32<AZ$10),AND($E32>=AY$10,$E32<AZ$10),IF($C32<>0,AND($C32<=AY$10,$D32>=AY$10),FALSE),AND($D32<=AY$10,$E32>=AY$10)),IF(AND(AND($D32>=AY$10,$D32<AZ$10),$E32<>0),IF($F32=\"Beedet\",\"Z\",\"Y\"),IF($F32=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C32>=DG$10,$C32< DH$10),AND($D32>=DG$10,$D32<DH$10),AND($E32>=DG$10,$E32<DH$10),IF($C32<>0,AND($C32<=DG$10,$D32>=DG$10),FALSE),AND($D32<=DG$10,$E32>=DG$10)),IF(AND(AND($D32>=DG$10,$D32<DH$10),$E32<>0),IF($F32=\"Beedet\",\"Z\",\"Y\"),IF($F32=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 4",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C33>=P$10,$C33< Q$10),AND($D33>=P$10,$D33<Q$10),AND($E33>=P$10,$E33<Q$10),IF($C33<>0,AND($C33<=P$10,$D33>=P$10),FALSE),AND($D33<=P$10,$E33>=P$10)),IF(AND(AND($D33>=P$10,$D33<Q$10),$E33<>0),IF($F33=\"Beedet\",\"Z\",\"Y\"),IF($F33=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C33>=AY$10,$C33< AZ$10),AND($D33>=AY$10,$D33<AZ$10),AND($E33>=AY$10,$E33<AZ$10),IF($C33<>0,AND($C33<=AY$10,$D33>=AY$10),FALSE),AND($D33<=AY$10,$E33>=AY$10)),IF(AND(AND($D33>=AY$10,$D33<AZ$10),$E33<>0),IF($F33=\"Beedet\",\"Z\",\"Y\"),IF($F33=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C33>=DG$10,$C33< DH$10),AND($D33>=DG$10,$D33<DH$10),AND($E33>=DG$10,$E33<DH$10),IF($C33<>0,AND($C33<=DG$10,$D33>=DG$10),FALSE),AND($D33<=DG$10,$E33>=DG$10)),IF(AND(AND($D33>=DG$10,$D33<DH$10),$E33<>0),IF($F33=\"Beedet\",\"Z\",\"Y\"),IF($F33=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 5",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C34>=P$10,$C34< Q$10),AND($D34>=P$10,$D34<Q$10),AND($E34>=P$10,$E34<Q$10),IF($C34<>0,AND($C34<=P$10,$D34>=P$10),FALSE),AND($D34<=P$10,$E34>=P$10)),IF(AND(AND($D34>=P$10,$D34<Q$10),$E34<>0),IF($F34=\"Beedet\",\"Z\",\"Y\"),IF($F34=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C34>=AY$10,$C34< AZ$10),AND($D34>=AY$10,$D34<AZ$10),AND($E34>=AY$10,$E34<AZ$10),IF($C34<>0,AND($C34<=AY$10,$D34>=AY$10),FALSE),AND($D34<=AY$10,$E34>=AY$10)),IF(AND(AND($D34>=AY$10,$D34<AZ$10),$E34<>0),IF($F34=\"Beedet\",\"Z\",\"Y\"),IF($F34=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C34>=DG$10,$C34< DH$10),AND($D34>=DG$10,$D34<DH$10),AND($E34>=DG$10,$E34<DH$10),IF($C34<>0,AND($C34<=DG$10,$D34>=DG$10),FALSE),AND($D34<=DG$10,$E34>=DG$10)),IF(AND(AND($D34>=DG$10,$D34<DH$10),$E34<>0),IF($F34=\"Beedet\",\"Z\",\"Y\"),IF($F34=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 6","Auftraggeber/in",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C35>=P$10,$C35< Q$10),AND($D35>=P$10,$D35<Q$10),AND($E35>=P$10,$E35<Q$10),IF($C35<>0,AND($C35<=P$10,$D35>=P$10),FALSE),AND($D35<=P$10,$E35>=P$10)),IF(AND(AND($D35>=P$10,$D35<Q$10),$E35<>0),IF($F35=\"Beedet\",\"Z\",\"Y\"),IF($F35=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C35>=AY$10,$C35< AZ$10),AND($D35>=AY$10,$D35<AZ$10),AND($E35>=AY$10,$E35<AZ$10),IF($C35<>0,AND($C35<=AY$10,$D35>=AY$10),FALSE),AND($D35<=AY$10,$E35>=AY$10)),IF(AND(AND($D35>=AY$10,$D35<AZ$10),$E35<>0),IF($F35=\"Beedet\",\"Z\",\"Y\"),IF($F35=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C35>=DG$10,$C35< DH$10),AND($D35>=DG$10,$D35<DH$10),AND($E35>=DG$10,$E35<DH$10),IF($C35<>0,AND($C35<=DG$10,$D35>=DG$10),FALSE),AND($D35<=DG$10,$E35>=DG$10)),IF(AND(AND($D35>=DG$10,$D35<DH$10),$E35<>0),IF($F35=\"Beedet\",\"Z\",\"Y\"),IF($F35=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Meilenstein (grünes Licht in der Phase Einführung)","Auftraggeber/in",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C36>=P$10,$C36< Q$10),AND($D36>=P$10,$D36<Q$10),AND($E36>=P$10,$E36<Q$10),IF($C36<>0,AND($C36<=P$10,$D36>=P$10),FALSE),AND($D36<=P$10,$E36>=P$10)),IF(AND(AND($D36>=P$10,$D36<Q$10),$E36<>0),IF($F36=\"Beedet\",\"Z\",\"Y\"),IF($F36=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C36>=AY$10,$C36< AZ$10),AND($D36>=AY$10,$D36<AZ$10),AND($E36>=AY$10,$E36<AZ$10),IF($C36<>0,AND($C36<=AY$10,$D36>=AY$10),FALSE),AND($D36<=AY$10,$E36>=AY$10)),IF(AND(AND($D36>=AY$10,$D36<AZ$10),$E36<>0),IF($F36=\"Beedet\",\"Z\",\"Y\"),IF($F36=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C36>=DG$10,$C36< DH$10),AND($D36>=DG$10,$D36<DH$10),AND($E36>=DG$10,$E36<DH$10),IF($C36<>0,AND($C36<=DG$10,$D36>=DG$10),FALSE),AND($D36<=DG$10,$E36>=DG$10)),IF(AND(AND($D36>=DG$10,$D36<DH$10),$E36<>0),IF($F36=\"Beedet\",\"Z\",\"Y\"),IF($F36=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Implementierung",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C37>=P$10,$C37< Q$10),AND($D37>=P$10,$D37<Q$10),AND($E37>=P$10,$E37<Q$10),IF($C37<>0,AND($C37<=P$10,$D37>=P$10),FALSE),AND($D37<=P$10,$E37>=P$10)),IF(AND(AND($D37>=P$10,$D37<Q$10),$E37<>0),IF($F37=\"Beedet\",\"Z\",\"Y\"),IF($F37=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C37>=AY$10,$C37< AZ$10),AND($D37>=AY$10,$D37<AZ$10),AND($E37>=AY$10,$E37<AZ$10),IF($C37<>0,AND($C37<=AY$10,$D37>=AY$10),FALSE),AND($D37<=AY$10,$E37>=AY$10)),IF(AND(AND($D37>=AY$10,$D37<AZ$10),$E37<>0),IF($F37=\"Beedet\",\"Z\",\"Y\"),IF($F37=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C37>=DG$10,$C37< DH$10),AND($D37>=DG$10,$D37<DH$10),AND($E37>=DG$10,$E37<DH$10),IF($C37<>0,AND($C37<=DG$10,$D37>=DG$10),FALSE),AND($D37<=DG$10,$E37>=DG$10)),IF(AND(AND($D37>=DG$10,$D37<DH$10),$E37<>0),IF($F37=\"Beedet\",\"Z\",\"Y\"),IF($F37=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 1","Proj.Mgmt",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C38>=P$10,$C38< Q$10),AND($D38>=P$10,$D38<Q$10),AND($E38>=P$10,$E38<Q$10),IF($C38<>0,AND($C38<=P$10,$D38>=P$10),FALSE),AND($D38<=P$10,$E38>=P$10)),IF(AND(AND($D38>=P$10,$D38<Q$10),$E38<>0),IF($F38=\"Beedet\",\"Z\",\"Y\"),IF($F38=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C38>=AY$10,$C38< AZ$10),AND($D38>=AY$10,$D38<AZ$10),AND($E38>=AY$10,$E38<AZ$10),IF($C38<>0,AND($C38<=AY$10,$D38>=AY$10),FALSE),AND($D38<=AY$10,$E38>=AY$10)),IF(AND(AND($D38>=AY$10,$D38<AZ$10),$E38<>0),IF($F38=\"Beedet\",\"Z\",\"Y\"),IF($F38=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C38>=DG$10,$C38< DH$10),AND($D38>=DG$10,$D38<DH$10),AND($E38>=DG$10,$E38<DH$10),IF($C38<>0,AND($C38<=DG$10,$D38>=DG$10),FALSE),AND($D38<=DG$10,$E38>=DG$10)),IF(AND(AND($D38>=DG$10,$D38<DH$10),$E38<>0),IF($F38=\"Beedet\",\"Z\",\"Y\"),IF($F38=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 2","Proj.Mgmt",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C39>=P$10,$C39< Q$10),AND($D39>=P$10,$D39<Q$10),AND($E39>=P$10,$E39<Q$10),IF($C39<>0,AND($C39<=P$10,$D39>=P$10),FALSE),AND($D39<=P$10,$E39>=P$10)),IF(AND(AND($D39>=P$10,$D39<Q$10),$E39<>0),IF($F39=\"Beedet\",\"Z\",\"Y\"),IF($F39=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C39>=AY$10,$C39< AZ$10),AND($D39>=AY$10,$D39<AZ$10),AND($E39>=AY$10,$E39<AZ$10),IF($C39<>0,AND($C39<=AY$10,$D39>=AY$10),FALSE),AND($D39<=AY$10,$E39>=AY$10)),IF(AND(AND($D39>=AY$10,$D39<AZ$10),$E39<>0),IF($F39=\"Beedet\",\"Z\",\"Y\"),IF($F39=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C39>=DG$10,$C39< DH$10),AND($D39>=DG$10,$D39<DH$10),AND($E39>=DG$10,$E39<DH$10),IF($C39<>0,AND($C39<=DG$10,$D39>=DG$10),FALSE),AND($D39<=DG$10,$E39>=DG$10)),IF(AND(AND($D39>=DG$10,$D39<DH$10),$E39<>0),IF($F39=\"Beedet\",\"Z\",\"Y\"),IF($F39=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 3","Auftraggeber/in",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C40>=P$10,$C40< Q$10),AND($D40>=P$10,$D40<Q$10),AND($E40>=P$10,$E40<Q$10),IF($C40<>0,AND($C40<=P$10,$D40>=P$10),FALSE),AND($D40<=P$10,$E40>=P$10)),IF(AND(AND($D40>=P$10,$D40<Q$10),$E40<>0),IF($F40=\"Beedet\",\"Z\",\"Y\"),IF($F40=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C40>=AY$10,$C40< AZ$10),AND($D40>=AY$10,$D40<AZ$10),AND($E40>=AY$10,$E40<AZ$10),IF($C40<>0,AND($C40<=AY$10,$D40>=AY$10),FALSE),AND($D40<=AY$10,$E40>=AY$10)),IF(AND(AND($D40>=AY$10,$D40<AZ$10),$E40<>0),IF($F40=\"Beedet\",\"Z\",\"Y\"),IF($F40=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C40>=DG$10,$C40< DH$10),AND($D40>=DG$10,$D40<DH$10),AND($E40>=DG$10,$E40<DH$10),IF($C40<>0,AND($C40<=DG$10,$D40>=DG$10),FALSE),AND($D40<=DG$10,$E40>=DG$10)),IF(AND(AND($D40>=DG$10,$D40<DH$10),$E40<>0),IF($F40=\"Beedet\",\"Z\",\"Y\"),IF($F40=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 4",null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C41>=P$10,$C41< Q$10),AND($D41>=P$10,$D41<Q$10),AND($E41>=P$10,$E41<Q$10),IF($C41<>0,AND($C41<=P$10,$D41>=P$10),FALSE),AND($D41<=P$10,$E41>=P$10)),IF(AND(AND($D41>=P$10,$D41<Q$10),$E41<>0),IF($F41=\"Beedet\",\"Z\",\"Y\"),IF($F41=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C41>=AY$10,$C41< AZ$10),AND($D41>=AY$10,$D41<AZ$10),AND($E41>=AY$10,$E41<AZ$10),IF($C41<>0,AND($C41<=AY$10,$D41>=AY$10),FALSE),AND($D41<=AY$10,$E41>=AY$10)),IF(AND(AND($D41>=AY$10,$D41<AZ$10),$E41<>0),IF($F41=\"Beedet\",\"Z\",\"Y\"),IF($F41=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C41>=DG$10,$C41< DH$10),AND($D41>=DG$10,$D41<DH$10),AND($E41>=DG$10,$E41<DH$10),IF($C41<>0,AND($C41<=DG$10,$D41>=DG$10),FALSE),AND($D41<=DG$10,$E41>=DG$10)),IF(AND(AND($D41>=DG$10,$D41<DH$10),$E41<>0),IF($F41=\"Beedet\",\"Z\",\"Y\"),IF($F41=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 5","Proj.Mgmt",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C42>=P$10,$C42< Q$10),AND($D42>=P$10,$D42<Q$10),AND($E42>=P$10,$E42<Q$10),IF($C42<>0,AND($C42<=P$10,$D42>=P$10),FALSE),AND($D42<=P$10,$E42>=P$10)),IF(AND(AND($D42>=P$10,$D42<Q$10),$E42<>0),IF($F42=\"Beedet\",\"Z\",\"Y\"),IF($F42=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C42>=AY$10,$C42< AZ$10),AND($D42>=AY$10,$D42<AZ$10),AND($E42>=AY$10,$E42<AZ$10),IF($C42<>0,AND($C42<=AY$10,$D42>=AY$10),FALSE),AND($D42<=AY$10,$E42>=AY$10)),IF(AND(AND($D42>=AY$10,$D42<AZ$10),$E42<>0),IF($F42=\"Beedet\",\"Z\",\"Y\"),IF($F42=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C42>=DG$10,$C42< DH$10),AND($D42>=DG$10,$D42<DH$10),AND($E42>=DG$10,$E42<DH$10),IF($C42<>0,AND($C42<=DG$10,$D42>=DG$10),FALSE),AND($D42<=DG$10,$E42>=DG$10)),IF(AND(AND($D42>=DG$10,$D42<DH$10),$E42<>0),IF($F42=\"Beedet\",\"Z\",\"Y\"),IF($F42=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Aufgabe 6","Proj.Mgmt",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C43>=P$10,$C43< Q$10),AND($D43>=P$10,$D43<Q$10),AND($E43>=P$10,$E43<Q$10),IF($C43<>0,AND($C43<=P$10,$D43>=P$10),FALSE),AND($D43<=P$10,$E43>=P$10)),IF(AND(AND($D43>=P$10,$D43<Q$10),$E43<>0),IF($F43=\"Beedet\",\"Z\",\"Y\"),IF($F43=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C43>=AY$10,$C43< AZ$10),AND($D43>=AY$10,$D43<AZ$10),AND($E43>=AY$10,$E43<AZ$10),IF($C43<>0,AND($C43<=AY$10,$D43>=AY$10),FALSE),AND($D43<=AY$10,$E43>=AY$10)),IF(AND(AND($D43>=AY$10,$D43<AZ$10),$E43<>0),IF($F43=\"Beedet\",\"Z\",\"Y\"),IF($F43=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C43>=DG$10,$C43< DH$10),AND($D43>=DG$10,$D43<DH$10),AND($E43>=DG$10,$E43<DH$10),IF($C43<>0,AND($C43<=DG$10,$D43>=DG$10),FALSE),AND($D43<=DG$10,$E43>=DG$10)),IF(AND(AND($D43>=DG$10,$D43<DH$10),$E43<>0),IF($F43=\"Beedet\",\"Z\",\"Y\"),IF($F43=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]
["Meilenstein (Projektabschluss)","Auftraggeber/in",null,null,null,null,null,"","","","","","","","",{"$f":"IF(OR(AND($C44>=P$10,$C44< Q$10),AND($D44>=P$10,$D44<Q$10),AND($E44>=P$10,$E44<Q$10),IF($C44<>0,AND($C44<=P$10,$D44>=P$10),FALSE),AND($D44<=P$10,$E44>=P$10)),IF(AND(AND($D44>=P$10,$D44<Q$10),$E44<>0),IF($F44=\"Beedet\",\"Z\",\"Y\"),IF($F44=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C44>=AY$10,$C44< AZ$10),AND($D44>=AY$10,$D44<AZ$10),AND($E44>=AY$10,$E44<AZ$10),IF($C44<>0,AND($C44<=AY$10,$D44>=AY$10),FALSE),AND($D44<=AY$10,$E44>=AY$10)),IF(AND(AND($D44>=AY$10,$D44<AZ$10),$E44<>0),IF($F44=\"Beedet\",\"Z\",\"Y\"),IF($F44=\"Beendet\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C44>=DG$10,$C44< DH$10),AND($D44>=DG$10,$D44<DH$10),AND($E44>=DG$10,$E44<DH$10),IF($C44<>0,AND($C44<=DG$10,$D44>=DG$10),FALSE),AND($D44<=DG$10,$E44>=DG$10)),IF(AND(AND($D44>=DG$10,$D44<DH$10),$E44<>0),IF($F44=\"Beedet\",\"Z\",\"Y\"),IF($F44=\"Beendet\",\"Z\",\"X\")),\"\")","v":""}]

{"sheet":"Budget","index":3,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,0,30,4],[29,0,29,4],[1,0,1,1],[2,0,2,1],[5,4,5,5],[6,1,6,2]]}
[]
[]
["BUDGET"]
["(Beträge in CHF, inkl. MWST)"]
[]
["Projekt:",{"$f":"'Allgemeine Informationen'!A6","v":"Projektname"},null,"Auftraggeber/in:",{"$f":"'Allgemeine Informationen'!B20","v":"Vorname, Name"}]
["Projektleiter/in:",{"$f":"'Allgemeine Informationen'!B21","v":"Vorname, Name"},null,"Vorläufiges Budget","Tatsächliche Kosten","Differenz"]
[null,null,null,{"$f":"SUBTOTAL(9,D10:D27)","v":12500},{"$f":"SUBTOTAL(9,E10:E27)","v":12600},{"$f":"SUBTOTAL(9,F10:F27)","v":200}]
[null,"Art","Belege / Bemerkungen"]
["Rubrik 1 (z. B. Mobiliar, IT, Studienkosten, Kommunikation usw.)",null,null,{"$f":"SUBTOTAL(9,D11:D12)","v":7000},{"$f":"SUBTOTAL(9,E11:E12)","v":7600},{"$f":"E10-D10","v":600}]
[null,"Kommunikationskampagne","Erstellung von Flyern",4000,4500,{"$f":"E11-D11","v":500}]
[null,null,"Flyerdruck",3000,3100,{"$f":"E12-D12","v":100}]
[]
["Rubrik 2",null,null,{"$f":"SUBTOTAL(9,D15:D18)","v":5500},{"$f":"SUBTOTAL(9,E15:E18)","v":5000},{"$f":"E14-D14","v":-500}]
[null,null,null,1500,1000,{"$f":"E15-D15","v":-500}]
[null,null,null,4000,4000,{"$f":"E16-D16","v":0}]
[null,null,null,0,0,{"$f":"E17-D17","v":0}]
[null,null,null,0,0,0]
[]
["Rubrik 3",null,null,{"$f":"SUBTOTAL(9,D21:D23)","v":0},{"$f":"SUBTOTAL(9,E21:E23)","v":0},{"$f":"E20-D20","v":0}]
[null,null,null,0,0,{"$f":"E21-D21","v":0}]
[null,null,null,0,0,{"$f":"E22-D22","v":0}]
[null,null,null,0,0,{"$f":"E23-D23","v":0}]
[]
["Rubrik 4",null,null,{"$f":"SUBTOTAL(9,D26:D27)","v":0},{"$f":"SUBTOTAL(9,E26:E27)","v":0},{"$f":"E25-D25","v":0}]
[null,null,null,0,0,{"$f":"E26-D26","v":0}]
[null,null,null,0,0,{"$f":"E27-D27","v":0}]
[null,null,"TOTAL",{"$f":"D25+D20+D14+D10","v":12500},{"$f":"E25+E20+E14+E10","v":12600},100]
[]
["ANWEISUNG"]
["- Die grünen Zellen werden automatisch berechnet"]
["- Copy&Paste verwenden, um Budgetzeilen hinzuzufügen / Daran denken, die Formeln in die hinzugefügten Zeilen zu kopieren"]

{"sheet":"Risikoregister","index":4,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,0,22,12],[21,0,21,5],[8,5,9,7],[4,0,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2]]}
[]
[]
["RISIKOREGISTER"]
[]
["Risikobeurteilung \n(Wahrscheinlichkeit eines Zwischenfalls und mögliche Auswirkung)",null,null,"Risikobeurteilung\n (Schwere der Auswirkungen)","Risikotrend \n(rückläufig / stabil / steigend)"]
[1,"Gering",null,"Gering"]
[2,"Mittel",null,"Mittel","↘"]
[3,"Hoch",null,"Gross","→"]
[4,"Sehr hoch",null,"Kritik","↗","Auswirkungen auf:"]
[]
["ID","Staat","Identifiziert am","Beschreibung der Risiken","Konsequenzen","Kosten","Fristen","Liefer-produkte","Wahrschein-lichkeit","Auswirkung","Schwere","Trend","Massnahmen"]
["R1","aktiv",null,"Schlechtes Wetter","- Bau nicht möglich","CHF 2K","6 Wochen Verspätung","keine Auswirkung auf das Liefer-produkt",3,4,{"$f":"I12*J12","v":12},"↘","M1: Verspätung in späteren Phasen aufholen. Gegebenenfalls alle Stakeholder informieren, um die Planung der Umsetzung zu überarbeiten\n"]
["R2","inaktiv",null,null,null,null,null,null,null,null,{"$f":"I13*J13","v":0}]
["R3","inaktiv",null,null,null,null,null,null,null,null,0]
["R4","inaktiv",null,null,null,null,null,null,null,null,0]
["R5","inaktiv",null,null,null,null,null,null,null,null,0]
["R6","inaktiv",null,null,null,null,null,null,null,null,{"$f":"I17*J17","v":0}]
["R7","inaktiv",null,null,null,null,null,null,null,null,0]
["R8","inaktiv",null,null,null,null,null,null,null,null,0]
["R9","inaktiv",null,null,null,null,null,null,null,null,0]
[]
["INFORMATION"]
["Ein Risiko (R) wird als gross betrachtet, wenn es den Schweregrad 9 erreicht. In diesem Fall sind unverzügliche Massnahmen (M) notwendig."]

{"sheet":"Ergebnisse","index":5,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
[]
[]
["ERGEBNISSE"]
[]
["Nr.","Ergebnisse","Verantwortliche Personen für die Genehmigung","Akzeptanzindikatoren","Bemerkungen Qualität/Test","Status"]
[1,"[Produkte, Dienstleistungen, Dokumente ... die während dem Projekt erstellt wurden]","[Name oder Funktion]","[Validierungsindikatoren der Ergebnisse auflisten]","[Genehmigt / Abgelehnt / Mit Kommentaren, Vorschlägen zurückgesendet]"]
[2,"Prozess der Kundenausrichtung","Projektausschuss","1. Steigerung der Problemlösung beim 1. Kontakt\n\n2. Bearbeitungsdauer der Anfragen\n\n3. Steigerung der Kundenzufriedenheit (gestützt auf Feedback)\n","1. Die Kontaktpersonen müssen ihre Kompetenzbereiche in der Lösung von grundlegenden Problemen noch erweitern\n2. Die Anfragen werden mit der Aufhebung von redundanten Prozessbestätigungs-schritten schneller bearbeitet\n3. Die Zufriedenheit ist während der Testphase leicht gestiegen","getestet"]
[3,null,null,null,null,"akzeptiert"]
[4,null,null,null,null,"abgelehnt"]
[5,null,null,null,null,"zurückgesandt"]
[6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"geplant"]
[null,null,null,null,null,"getestet"]
[null,null,null,null,null,"akzeptiert"]
[null,null,null,null,null,"abgelehnt"]
[null,null,null,null,null,"zurückgesandt"]

{"sheet":"Änderung","index":6,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5],[4,0,5,0],[4,1,5,1],[4,7,5,7],[4,8,5,8]]}
[]
[]
["UMFANGÄNDERUNG (Ziele und Lieferprodukte)"]
[]
["Nr.","Datum","Beschreibung","Auswirkung",null,null,null,"Bemerkungen","Status"]
[null,null,null,"Umfang","Frist","Kosten","Andere"]
[1,"TT.MM.JJJJ","Den Projektumfang unter Berücksichtigung des neuen kantonalen Gesundheitsgesetzes überprüfen","Verbindung mit anderen Projekten","2 Monate Verspätung in der Lieferung der Organisation","10 000 CHF","na","Steuerungsausschuss informieren","Sitzung zu bestätigen, Auftraggeber informiert"]
[2]
[3]
[4]
[5]
[6]
[7]
[]
["ANWEISUNG"]
["Bericht erstatten über jede Umfangänderung mit Konsequenzen für die Fristen, Kosten und Ressourcen."]
[]
["Beispiel für einen Status: "]
["Information Steuerungsausschuss",null,"Der Steuerungsausschuss wurde über die Änderung und die Auswirkung auf das Projekt informiert. Feedback im Bemerkungsfeld dokumentieren."]
["Genehmigung Steuerungsausschuss",null,"Der Steuerungsausschuss genehmigte die Änderung und die Auswirkungen auf das Projekt."]
["Erledigt",null,"Nach Genehmigung des Steuerungsausschusses wurde die Änderung umgesetzt."]

{"sheet":"Sitzungen","index":7,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
[]
[]
["SITZUNGEN (Ziele und Lieferprodukte)"]
[]
["Datum","Sitzungsart","Anwesend","Entschuldigt","Programm","Informationen / Entscheide /\nWeitere Punkte "]
["2021-04-22","Sitzungs-organisation","Vorname, Name / Vorname, Name /","Vorname, Name / Vorname, Name /","- Überprüfung der Reorganisationsmassnahmen","Information der Mitglieder des Steuerungsausschusses\nGenehmigung der vom Auftraggeber vorgeschlagenen Massnahmen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["INFORMATION"]
["Wenn sich ein Projekt über einen langen Zeitraum erstreckt, ist es hilfreich, die wichtigsten Sitzungen und namentlich die von den Teilnehmenden getroffenen Entscheide zu erfassen."]

{"sheet":"Verantwortungsmatrix","index":8,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
[]
[]
["VERANTWORTUNGSMATRIX (RACI)"]
[]
["                                  Rollen\n\n\nAufgaben","Auftraggeber/in","Projektleiter/in / Programmleiter/in","Fachspezialist/in","Dienstleister/in","Andere: angeben"]
["Aufgabe 1","R","A","A","I"]
["Aufgabe 2"]
["Aufgabe 3"]
["Aufgabe 4"]
["Aufgabe 5"]
["Aufgabe 6"]
["Aufgabe 7"]
["Aufgabe 8"]
["Aufgabe 9"]
[]
["VERWENDUNG"]
["- Die Stakeholder mit Bezug auf das Projekt hinzufügen"]
["- Die Aufgaben oder Bereiche mit Bezug auf das Projekt hinzufügen"]
[]
["Legende:"]
["R","Entscheiden","Person, die über eine Massnahme/Aufgabe entscheidet"]
["A","Ausführen","Personen, die eine Massnahme/Aufgabe ausführen"]
["C","Konsultieren","Personen, die zu befragen sind"]
["I","Informieren","Personen, die zu informieren sind"]