{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gantt","Om"],"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],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,1,4,7]]}
["Opret et Gantt-diagram i dette regneark.\nAngiv titlen på projektet i celle B1. \nForklaringstitlen vises i celle I1.\nOplysninger om, hvordan du bruger dette regneark, herunder en vejledning for skærmlæsere og forfatteren af denne projektmappe, er i regnearket Om.\nDu kan fortsætte med at navigere i kolonne A for at få flere instruktioner.","PROJEKTTITEL",{"$nulls":6},"Forklaring:"]
["Angiv firmanavn i celle B2.\nEn forklaring er i cellerne I2 til AC2.","Firmanavn",{"$nulls":6},"På rette spor",{"$nulls":4},"Lav risiko",{"$nulls":4},"Mellem risiko",{"$nulls":4},"Høj risiko",{"$nulls":4},"Ikke tildelt"]
["Angiv navnet på projekt Bly i celle B3. Angiv projektets startdato i celle F3, eller tillad, at formlen finder den mindste datoværdi fra Gantt-datatabellen.  \nProjektets startdato: mærkaten er i celle D3.","Projektleder",null,"Projektets startdato:",null,{"$f":"IFERROR(IF(MIN(Milepæle[Start])=0,TODAY(),MIN(Milepæle[Start])),TODAY())","v":"2018-07-07"}]
["Et rullende trin er i celle F4. \nMåneder for datoerne i række 5 vises startende i cellerne I4 via celle BL4.\nDisse celler må ikke ændres. De opdateres automatisk baseret på projektets startdato i celle F3.",null,null,"Rulleinterval:",null,0,null,null,{"$f":"TEXT(I5,\"mmmm\")","v":"juli"},{"$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":""}]
["Cellerne I5 til BL5 indeholder dagsnummeret for den måned, der er repræsenteret i celleblokken over hver datocelle, og de beregnes automatisk.\nDisse celler må ikke ændres.\nDags dato er fremhævet med rød (Hex #AD3815) fra dags dato i række 5 til hele datokolonnen til slutningen af projektplanen.",{"$nulls":7},{"$f":"IFERROR(Projekt_Start+Rulleinterval,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"]
["Et rullepanel er i cellerne I6 via BL6. Intervallerne til at bladre gennem data er defineret som 2 sider ad gangen og kan konfigureres i indstillingerne for kontrollinjen. \nHvis du vil springe frem eller tilbage på tidslinjen, skal du angive værdien 0 eller højere i celle F4.\nEn værdi på 0 fører dig til starten af diagrammet."]
["Denne række indeholder overskrifter til projektplanen, der følger under dem. \nNaviger fra B7 til BL7 for at høre indholdet. Det første bogstav i hver dag i ugen for den nævnte dato, starter i celle I7, og fortsætter via celle BL7.\nAlle tidslinjediagrammer for projektet oprettes automatisk på basis af kategori, startdato og antallet af dage, der er angivet i tabellen Milepæle.","Beskrivelse af milepæle","Kategori","Tildelt til","Gang","Start","Antal dage",null,{"$f":"LEFT(TEXT(I5,\"ddd\"),1)","v":"l"},{"$f":"LEFT(TEXT(J5,\"ddd\"),1)","v":"s"},"m","t","o","t","f","l","s","m","t","o","t","f","l","s","m","t","o","t","f","l","s","m","t","o","t","f","l","s","m","t","o","t","f","l",{"$f":"LEFT(TEXT(AS5,\"ddd\"),1)","v":"s"},"m","t","o","t","f","l","s","m","t","o","t","f","l","s","m","t","o","t","f"]
["Slet ikke denne række. Denne række er skjult for at bevare en formel, der bruges til at fremhæve den aktuelle dag i projektplanen. "]
["Angiv projektoplysninger i cellerne B9 til G9. \nEksempeldata vises i cellerne B9 til G33.\nAngiv en beskrivelse af milepælen, vælg en kategori på rullelisten, tildel en person til elementet, angiv status, startdato og antal dage for opgaven for at begynde oprettelse af diagrammet.\nDen næste vejledning er i celle A34.","Titel 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Mål\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Milepæl\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Mål\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Milepæl\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Mål\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Milepæl\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Mål\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Milepæl\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Opgave 1","Mål","Navn",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-07-30"},3,null,{"$f":"IF(AND($C10=\"Mål\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Milepæl\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 2","Milepæl",null,null,{"$f":"TODAY()+5","v":"2019-08-04"},1,null,{"$f":"IF(AND($C11=\"Mål\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Milepæl\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 3","Lav risiko",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-07-27"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 4","Milepæl",null,null,{"$f":"F10+20","v":"2019-08-19"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 5","Mellem risiko",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-08-05"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Titel 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 1","Høj risiko",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-08-05"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 2","På rette spor",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-08-07"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 3","Lav risiko",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-08-12"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 4","Milepæl",null,null,{"$f":"F18+2","v":"2019-08-14"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 5",{"$nulls":3},{"$f":"F19+1","v":"2019-08-15"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Titel 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 1","På rette spor",null,null,{"$f":"F10+15","v":"2019-08-14"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 2","Mellem risiko",null,null,{"$f":"F22+3","v":"2019-08-17"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 3","På rette spor",null,null,{"$f":"F23+15","v":"2019-09-01"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Mål\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"Milepæl\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Mål\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"Milepæl\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Opgave 4","Mål",null,null,{"$f":"F19+22","v":"2019-09-05"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"Mål\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"Milepæl\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 5","Lav risiko",null,null,{"$f":"F14","v":"2019-08-05"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Titel 4",{"$nulls":6},{"$f":"IF(AND($C27=\"Mål\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"Milepæl\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 1",{"$nulls":3},{"$f":"F25+3","v":"2019-09-08"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 3","Milepæl",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opgave 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Dette er en tom række",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Denne række markerer slutningen af Gantt-milepælsdataene. SKRIV IKKE noget i denne række. \nHvis du vil tilføje flere elementer, skal du indsætte nye rækker over denne.","Hvis du vil tilføje flere data, skal du indsætte nye rækker OVER denne."]

{"sheet":"Om","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["Om denne skabelon"]
["Med denne skabelon kan du nemt oprette et Gantt-diagram, som kan hjælpe dig med at visualisere og holde styr på dit projekt. Du skal blot angive dine opgavebeskrivelser, vælge en kategori af mål, milepæl, på rette spor, lav risiko, mellem risiko, høj risiko, status som en procentdel af opgavefuldførelse, en startdato og antallet af dage til at udføre opgaven. Gantt-diagrammet udfyldes og er farvekodet med henblik på at skelne mellem de forskellige kategorier. Du kan bruge rullepanelet til at rulle gennem tidslinjen. Du kan indsætte nye opgaver ved at indsætte nye rækker.\n"]
["Vejledning til skærmlæsere"]
["Der er to regneark i denne projektmappe. \n\nGantt-diagram\nOm\n\nInstruktionerne til hvert regneark vises i kolonne A fra celle A1 i hvert regneark. Instruktionerne er skrevet med skjult tekst. Hvert trin hjælper dig gennem oplysningerne i den pågældende række. Hvert efterfølgende trin fortsætter i celle A2, A3 osv., medmindre andet direkte angives. Vejledningsteksten kan f.eks. være \"fortsæt til celle A6\" for at få det næste trin. \n\nDenne skjulte tekst udskrives ikke.\n\nSlet blot kolonne A for at fjerne disse instruktioner fra regnearket."]
["Dette er den sidste instruktion i dette regneark."]