{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gantt","Info"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Gantt","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[1,8,1,11],[1,13,1,16],[1,18,1,21],[1,23,1,26],[1,28,1,31],[4,1,4,7]]}
["Erstellen Sie auf diesem Arbeitsblatt ein Gantt-Diagramm.\nGeben Sie den Titel dieses Projekts in Zelle B1 ein. \nDer Legendentitel befindet sich in Zelle I1.\nInformationen zur Verwendung dieses Arbeitsblatts, einschließlich Anweisungen für die Sprachausgabe und den Verfasser dieser Arbeitsmappe, finden Sie auf dem Arbeitsblatt \"Info\".\nNavigieren Sie weiterhin in Spalte A abwärts, um weitere Anweisungen zu hören.","PROJEKTTITEL",{"$nulls":6},"Legende:"]
["Geben Sie den Firmennamen in Zelle B2 ein.\nEine Legende befindet sich in den Zellen I2 bis AC2.","Firmenname",{"$nulls":6},"Im Plan",{"$nulls":4},"Geringes Risiko",{"$nulls":4},"Mittleres Risiko",{"$nulls":4},"Hohes Risiko",{"$nulls":4},"Nicht zugewiesen"]
["Geben Sie den Namen des Projektleiters in Zelle B3 ein. Geben Sie das Anfangsdatum des Projekts in Zelle F3 ein, oder erlauben Sie es der Beispielformel, den kleinsten Datumswert in der Gantt-Datentabelle zu suchen.  \nAnfangsdatum des Projekts: Die Bezeichnung steht in Zelle D3.","Projektleiter",null,"Projektanfangsdatum:",null,{"$f":"IFERROR(IF(MIN(Meilensteine[Start])=0,TODAY(),MIN(Meilensteine[Start])),TODAY())","v":"2018-07-07"}]
["Die Scrollschrittweite ist in Zelle F4 angegeben. \nDie Monate für die Datumswerte in Zeile 5 werden beginnend mit Zelle I4 bis hin zur Zelle BL4 angezeigt.\nÄndern Sie diese Zellen nicht. Sie werden auf der Grundlage des Projektanfangsdatums in Zelle F3 automatisch aktualisiert.",null,null,"Scrollschrittweite:",null,0,null,null,{"$f":"TEXT(I5,\"MMMM\")","v":"July"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"MMMM\")=I4,\"\",TEXT(P5,\"MMMM\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"MMMM\")=P4,TEXT(W5,\"MMMM\")=I4),\"\",TEXT(W5,\"MMMM\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"MMMM\")=W4,TEXT(AD5,\"MMMM\")=P4,TEXT(AD5,\"MMMM\")=I4),\"\",TEXT(AD5,\"MMMM\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"MMMM\")=AD4,TEXT(AK5,\"MMMM\")=W4,TEXT(AK5,\"MMMM\")=P4,TEXT(AK5,\"MMMM\")=I4),\"\",TEXT(AK5,\"MMMM\"))","v":"August"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"MMMM\")=AK4,TEXT(AR5,\"MMMM\")=AD4,TEXT(AR5,\"MMMM\")=W4,TEXT(AR5,\"MMMM\")=P4),\"\",TEXT(AR5,\"MMMM\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"MMMM\")=AR4,TEXT(AY5,\"MMMM\")=AK4,TEXT(AY5,\"MMMM\")=AD4,TEXT(AY5,\"MMMM\")=W4),\"\",TEXT(AY5,\"MMMM\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"MMMM\")=AY4,TEXT(BF5,\"MMMM\")=AR4,TEXT(BF5,\"MMMM\")=AK4,TEXT(BF5,\"MMMM\")=AD4),\"\",TEXT(BF5,\"MMMM\"))","v":""}]
["Die Zellen I5 bis BL5 enthalten die Tagesnummer des Monats für den im Zellenblock oberhalb der einzelnen Datumszellen angezeigten Monat und werden automatisch berechnet.\nÄndern Sie diese Zellen nicht.\nDas heutige Datum ist rot (Hex #AD3815) hervorgehoben, vom aktuellen Datum in Zeile 5 die gesamte Datumsspalte hindurch bis zum Ende des Projektplans.",{"$nulls":7},{"$f":"IFERROR(Projekt_Start+Scroll_Schrittweite,TODAY())","v":"2018-07-07"},{"$f":"I5+1","v":"2018-07-08"},{"$f":"J5+1","v":"2018-07-09"},"2018-07-10","2018-07-11","2018-07-12","2018-07-13",{"$f":"O5+1","v":"2018-07-14"},{"$f":"P5+1","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20",{"$f":"V5+1","v":"2018-07-21"},{"$f":"W5+1","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27",{"$f":"AC5+1","v":"2018-07-28"},{"$f":"AD5+1","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03",{"$f":"AJ5+1","v":"2018-08-04"},{"$f":"AK5+1","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10",{"$f":"AQ5+1","v":"2018-08-11"},{"$f":"AR5+1","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17",{"$f":"AX5+1","v":"2018-08-18"},{"$f":"AY5+1","v":"2018-08-19"},{"$f":"AZ5+1","v":"2018-08-20"},"2018-08-21","2018-08-22","2018-08-23","2018-08-24",{"$f":"BE5+1","v":"2018-08-25"},{"$f":"BF5+1","v":"2018-08-26"},{"$f":"BG5+1","v":"2018-08-27"},"2018-08-28","2018-08-29","2018-08-30","2018-08-31"]
["Eine Scrollleiste befindet sich in den Zellen I6 bis BL6. Die Schrittweite für das Durchblättern der Daten ist auf zwei Seiten festgelegt und kann in den Einstellungen für die Steuerleiste konfiguriert werden. \nUm auf der Zeitachse vor oder zurück zu springen, geben Sie den Wert 0 oder höher in Zelle F4 ein.\nMit dem Wert 0 gelangen Sie zum Anfang des Diagramms."]
["Diese Zeile enthält Überschriften für den Projektplan, der darunter dargestellt ist. \nNavigieren Sie von B7 bis BL7, um sich die Inhalte vorsprechen zu lassen. Der erste Buchstabe jedes Tags der Woche für das Datum oberhalb der Überschrift, beginnend in Zelle I7 und fortlaufend bis Zelle BL7.\nDie gesamte Diagrammerstellung entlang der Projektzeitachse erfolgt automatisch auf der Grundlage der Kategorie, des Anfangsdatums und der Anzahl der Tage, die in der Meilensteintabelle eingegeben wurden.","Meilensteinbeschreibung","Kategorie","Zugewiesen an","Fortschritt","Start","Anzahl Tage",null,{"$f":"LEFT(TEXT(I5,\"TTT\"),1)","v":"T"},"T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T",{"$f":"LEFT(TEXT(AO5,\"TTT\"),1)","v":"T"},"T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T","T"]
["Löschen Sie diese Zeile nicht. Diese Zeile ist ausgeblendet, um eine Formel zu schützen, die zum Hervorheben des aktuellen Tags im Projektzeitplan verwendet wird. "]
["Geben Sie Projektinformationen ab Zelle B9 durchlaufend bis zu Zelle G9 ein. \nBeispieldaten befinden sich in den Zellen B9 bis G33.\nGeben Sie die Beschreibung des Meilensteins ein, wählen Sie in der Dropdownliste eine Kategorie aus, weisen Sie dem Element eine Person zu, und geben Sie den Status, das Anfangsdatum und die Anzahl der Tage für die Aufgabe ein, um mit der Diagrammerstellung zu beginnen.\nDie nächste Anweisung finden Sie in Zelle A34.","Titel 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Ziel\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Meilenstein\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Ziel\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Meilenstein\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Ziel\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Meilenstein\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Ziel\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Meilenstein\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Aufgabe 1","Ziel","Name",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-09-03"},3,null,{"$f":"IF(AND($C10=\"Ziel\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Meilenstein\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 2","Meilenstein",null,null,{"$f":"TODAY()+5","v":"2019-09-08"},1,null,{"$f":"IF(AND($C11=\"Ziel\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Meilenstein\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 3","Geringes Risiko",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-08-31"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 4","Meilenstein",null,null,{"$f":"F10+20","v":"2019-09-23"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 5","Mittleres Risiko",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-09-09"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Titel 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 1","Hohes Risiko",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-09-09"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 2","Im Plan",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-09-11"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 3","Geringes Risiko",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-09-16"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 4","Meilenstein",null,null,{"$f":"F18+2","v":"2019-09-18"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 5",{"$nulls":3},{"$f":"F19+1","v":"2019-09-19"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Titel 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 1","Im Plan",null,null,{"$f":"F10+15","v":"2019-09-18"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 2","Mittleres Risiko",null,null,{"$f":"F22+3","v":"2019-09-21"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 3","Im Plan",null,null,{"$f":"F23+15","v":"2019-10-06"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Ziel\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"Meilenstein\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Ziel\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"Meilenstein\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Aufgabe 4","Ziel",null,null,{"$f":"F19+22","v":"2019-10-10"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"Ziel\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"Meilenstein\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 5","Geringes Risiko",null,null,{"$f":"F14","v":"2019-09-09"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Titel 4",{"$nulls":6},{"$f":"IF(AND($C27=\"Ziel\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"Meilenstein\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 1",{"$nulls":3},{"$f":"F25+3","v":"2019-10-13"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 3","Meilenstein",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Aufgabe 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Dies ist eine leere Zeile.",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Diese Zeile markiert das Ende der Gantt-Meilensteindaten. Geben Sie in dieser Zeile NICHTS EIN. \nUm weitere Elemente hinzuzufügen, fügen Sie neue Zeilen über dieser ein.","Um weitere Daten hinzuzufügen, fügen Sie neue Zeilen ÜBER dieser ein."]

{"sheet":"Info","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["Über diese Vorlage"]
["Diese Vorlage bietet eine einfache Möglichkeit, ein Gantt-Diagramm zu erstellen, um Ihr Projekt zu visualisieren und seine Nachverfolgung zu erleichtern. Geben Sie einfach die Beschreibung Ihrer Aufgaben ein, wählen Sie eine Kategorie für Ziel, Meilenstein, Im Plan, Geringes Risiko, Mittleres Risiko, Hohes Risiko, Fortschritt als Prozentwert des Aufgabenabschlusses, ein Anfangsdatum und die Anzahl der Tage zum Fertigstellen der Aufgabe aus. Das Gantt-Diagramm wird ausgefüllt und erleichtert dank Farbcodierung die Unterscheidung der verschiedenen Kategorien. Eine Scrollleiste ermöglicht das Scrollen entlang der Zeitachse. Fügen Sie neue Aufgaben ein, indem Sie neue Zeilen einfügen.\n"]
["Leitfaden für die Sprachausgabe"]
["Diese Arbeitsmappe enthält 2 Arbeitsblätter. \n\nGantt-Diagramm\nInfo\n\nDie Anweisungen für jedes Arbeitsblatt befinden sich in Spalte A ab Zelle A1 der einzelnen Arbeitsblätter. Sie sind in verborgenem Text geschrieben. Jeder Schritt führt Sie durch die Informationen in der betreffenden Zeile. Jeder nachfolgende Schritt fährt in den Zellen A2, A3 usw. fort, sofern nicht ausdrücklich anders angegeben. Beispielsweise kann der Anweisungstext etwa für den nächsten Schritt \"Mit Zelle 6 fortfahren\" besagen. \n\nDieser verborgene Text wird nicht gedruckt.\n\nUm diese Anweisungen vom Arbeitsblatt zu entfernen, löschen Sie einfach Spalte A."]
["Dies ist die letzte Anweisung auf diesem Arbeitsblatt."]