{"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]]}
["Opprett et Gantt-diagram i dette regnearket.\nSkriv inn tittelen på prosjektet i celle B1. \nForklaringstittelen er i celle I1.\nInformasjon om hvordan du bruker dette regnearket, inkludert instruksjoner for skjermlesere og forfatteren av dette dokumentet, finner du i Om regnearket.\nFortsett å naviger ned i kolonne A for nærmere instruksjoner.","PROSJEKTTITTEL",{"$nulls":6},"Forklaring:"]
["Skriv inn firmanavnet i celle B2.\nI cellene I2 til AC2 er det en forklaring.","Firmanavn",{"$nulls":6},"Går etter planen",{"$nulls":4},"Lav risiko",{"$nulls":4},"Medium risiko",{"$nulls":4},"Høy risiko",{"$nulls":4},"Ikke tilordnet"]
["Skriv inn navnet på prosjektansvarlig i celle B3. Skriv inn startdatoen for prosjektet i celle F3, eller la eksempelformelen finne den minste datoverdien fra tabellen med Gantt-data.  \nProsjektets startdato: etikett er i celle D3.","Prosjektansvarlig",null,"Prosjektstartdato:",null,{"$f":"IFERROR(IF(MIN(Milepæler[Start])=0,TODAY(),MIN(Milepæler[Start])),TODAY())","v":"2018-07-07"}]
["I celle F4 er det en rullende økning. \nMånedene for datoene i rad 5 vises fra og med celle I4 til og med celle BL4.\nDu må ikke endre disse cellene. De oppdateres automatisk basert på startdatoen for prosjektet i celle F3.",null,null,"Rullende økning:",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":""}]
["Cellene I5 til BL5 inneholder nummeret for månedens dag for måneden som er representert i celleblokken over hver datocelle og beregnes automatisk.\nDu må ikke endre disse cellene.\nDagens dato er omrisset i rødt (heksadesimal #AD3815) fra dagens dato i rad 5, gjennom hele datokolonnen, og til slutten av prosjekttidsplanen.",{"$nulls":7},{"$f":"IFERROR(Project_Start+Rullende_økning,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"]
["I cellene I6 til BL6 er det et rullefelt. Intervallet for å bla gjennom dataene er definert som to sider om gangen, og kan konfigureres i innstillingene for kontrolllinjen. \nHvis du vil gå fremover eller bakover i tidslinjen, skriver du inn en verdi på 0 eller høyere i celle F4.\nEn verdi på 0 flytter deg til begynnelsen av diagrammet."]
["Denne raden inneholder overskrifter for prosjekttidsplanen som følger nedenfor. \nNaviger fra B7 gjennom BL7 for å høre innholdet. Den første bokstaven i hver ukedag for datoen ovenfor, starter i celle i7 og fortsetter gjennom celle BL7.\nAlle diagram for prosjekttidslinjer genereres automatisk basert på kategorien, startdato og antall dager som er angitt i Milepæler-tabellen.","Beskrivelse av milepæler","Kategori","Tilordnet til","Fremdrift","Start","Nummer dager",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"]
["Ikke slett denne raden. Denne raden er skjult for å bevare en formel som brukes til å utheve den gjeldende dagen i prosjekttidsplanen. "]
["Skriv inn prosjektinformasjon i tabellen som starter i celle B9 til celle G9. \nEksempeldata er i cellene B9 til G33.\nSkriv inn en beskrivelse av milepælen, velg en kategori fra rullegardinlisten, tilordne noen til elementet, skriv inn fremdriften, startdatoen og antall dager for å starte diagrammet for oppgaven.\nNeste instruksjon finnes i celle A34.","Tittel 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,"Oppgave 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,"Oppgave 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,"Oppgave 3","Lav risiko",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-07-27"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 4","Milepæl",null,null,{"$f":"F10+20","v":"2019-08-19"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 5","Medium risiko",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-08-05"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tittel 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 1","Høy risiko",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-08-05"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 2","Går etter planen",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-08-07"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 3","Lav risiko",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-08-12"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 4","Milepæl",null,null,{"$f":"F18+2","v":"2019-08-14"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 5",{"$nulls":3},{"$f":"F19+1","v":"2019-08-15"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tittel 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 1","Går etter planen",null,null,{"$f":"F10+15","v":"2019-08-14"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 2","Medium risiko",null,null,{"$f":"F22+3","v":"2019-08-17"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 3","Går etter planen",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,"Oppgave 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,"Oppgave 5","Lav risiko",null,null,{"$f":"F14","v":"2019-08-05"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tittel 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,"Oppgave 1",{"$nulls":3},{"$f":"F25+3","v":"2019-09-08"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 3","Milepæl",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Oppgave 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Dette er en tom rad",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Denne raden markerer slutten på Gantt-milepældataene. IKKE skriv inn noe i denne raden. \nSett inn ny rad ovenfor denne for å legge til flere elementer.","Sett inn ny rad OVENFOR denne for å legge til mer data."]

{"sheet":"Om","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["Om denne malen"]
["Denne malen er en enkel måte å opprette et Gantt-diagram på for å visualisere og følge opp prosjektet. Skriv inn oppgavens beskrivelse, velg en kategori med mål, milepæl, i rute, lav risiko, middels risiko, høy risiko, fremdrift som en prosentdel av fullføring av oppgaver, en startdato og antall dager for å fullføre oppgaven. Gantt-diagrammet blir fylt ut og fargekodet slik at det er enklere å skille de forskjellige kategoriene fra hverandre. Et rullefelt lar deg rulle gjennom tidslinjen. Sett inn nye aktiviteter ved å sette inn nye rader.\n"]
["Veiledning for skjermlesere"]
["Det finnes to regneark i denne arbeidsboken. \n\nGantt-diagram\nOm\n\nInstruksjonene for hvert regneark finner du i kolonne A, celle A1 i hvert regneark. De er skrevet med skjult tekst. Hvert trinn veileder deg gjennom informasjonen i den raden. Hvert etterfølgende trinn fortsetter i celle A2 og A3 og så videre, med mindre annet er uttrykkelig angitt. Instruksjonsteksten kan for eksempel si «fortsett til celle A6» for det neste trinnet. \n\nSkjult tekst skrives ikke ut.\n\nHvis du vil fjerne instruksjonene fra regnearket, sletter du helt enkelt kolonne A."]
["Dette er den siste instruksjonen i dette regnearket."]