{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gantt","Noin"],"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]]}
["Luo Gantt-kaavio tähän laskentataulukkoon.\nKirjoita tämän projektin otsikko soluun B1. \nSelitteen otsikko on solussa I1.\nTietoja-laskentataulukossa on lisätietoja tämän laskentataulukon käytöstä, kuten ohjeet näytönlukuohjelmia varten ja tieto tämän laskentataulukon tekijästä.\nSaat lisää ohjeita siirtymällä alas sarakkeessa A.","PROJEKTIN NIMI",{"$nulls":6},"Selite:"]
["Kirjoita yrityksen nimi soluun B2.\nSelite on soluissa I2–AC2.","Yrityksen nimi",{"$nulls":6},"Seurataan",{"$nulls":4},"Matala riski",{"$nulls":4},"Keskisuuri riski",{"$nulls":4},"Korkea riski",{"$nulls":4},"Määrittämätön"]
["Kirjoita projektin vetäjän nimi soluun B3. Kirjoita projektin alkamispäivä soluun F3 tai salli esimerkkikaavan löytää pienin mahdollinen päiväysarvo Gantt-arvotaulukosta.  \nProjektin alkamispäivä: selite on solussa D3.","Projektin vetäjä",null,"Projektin aloituspäivä:",null,{"$f":"IFERROR(IF(MIN(Välitavoitteet[Aloitus])=0,TODAY(),MIN(Välitavoitteet[Aloitus])),TODAY())","v":"2018-07-07"}]
["Vieritysaskel on solussa F4. \nRivillä 5 olevien päivämäärien kuukaudet näytetään soluissa I4–BL4.\nÄlä muokkaa näitä soluja. Ne päivitetään automaattisesti solussa F3 olevan projektin alkamispäivän mukaan.",null,null,"Vieritysaskel:",null,0,null,null,{"$f":"TEXT(I5,\"kkkk\")","v":"kkkk"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"kkkk\")=I4,\"\",TEXT(P5,\"kkkk\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"kkkk\")=P4,TEXT(W5,\"kkkk\")=I4),\"\",TEXT(W5,\"kkkk\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"kkkk\")=W4,TEXT(AD5,\"kkkk\")=P4,TEXT(AD5,\"kkkk\")=I4),\"\",TEXT(AD5,\"kkkk\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"kkkk\")=AD4,TEXT(AK5,\"kkkk\")=W4,TEXT(AK5,\"kkkk\")=P4,TEXT(AK5,\"kkkk\")=I4),\"\",TEXT(AK5,\"kkkk\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"kkkk\")=AK4,TEXT(AR5,\"kkkk\")=AD4,TEXT(AR5,\"kkkk\")=W4,TEXT(AR5,\"kkkk\")=P4),\"\",TEXT(AR5,\"kkkk\"))","v":"kkkk"},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"kkkk\")=AR4,TEXT(AY5,\"kkkk\")=AK4,TEXT(AY5,\"kkkk\")=AD4,TEXT(AY5,\"kkkk\")=W4),\"\",TEXT(AY5,\"kkkk\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"kkkk\")=AY4,TEXT(BF5,\"kkkk\")=AR4,TEXT(BF5,\"kkkk\")=AK4,TEXT(BF5,\"kkkk\")=AD4),\"\",TEXT(BF5,\"kkkk\"))","v":""}]
["Solut I5–BL5 sisältävät kunkin edustettavan kuukauden päivämäärän päivämääräsolujen yläpuolella ja ne lasketaan automaattisesti.\nÄlä muokkaa näitä soluja.\nNykyinen päivämäärä on kuvattu punaisella (hex #AD3815) rivin 5 nykyisestä päivämäärästä koko päivämääräsarakkeen läpi projektiaikataulun loppuun saakka.",{"$nulls":7},{"$f":"IFERROR(Projektin_aloitus+Vieritysaskel,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"]
["Vierityspalkki on soluissa I6–BL6. Tietojen sivuttain läpikäymisen vieritysasetus on määritetty kahteen sivuun kerrallaan. Tätä voi muokata ohjauspalkin asetuksissa. \nSiirry eteenpäin tai taaksepäin aikajanalla kirjoittamalla 0 tai suurempi arvo soluun F4.\nJos arvo on 0, siirryt kaavion alkuun."]
["Tämä rivi sisältää niitä seuraavan projektiaikataulun otsikot. \nKuuntele sisältö siirtymällä soluihin B7–BL7. Kunkin otsikon yllä olevan päivämäärän jokaisen viikonpäivän ensimmäiset kirjaimet ovat soluissa I7–BL7.\nKaikki projektin aikajanan kaaviot on luotu automaattisesti Välitavoitteet-taulukkoon kirjatun kategorian, aloituspäivämäärän ja keston mukaan.","Välitavoitteen kuvaus","Luokka","Vastuuhenkilö","Edistyminen","Aloitus","Päivien määrä",null,{"$f":"LEFT(TEXT(I5,\"ppp\"),1)","v":"p"},"p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p",{"$f":"LEFT(TEXT(AO5,\"ppp\"),1)","v":"p"},"p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p","p"]
["Älä poista tätä riviä. Tämä rivi on piilotettu, koska se sisältää projektiaikataulun nykyisen päivän korostavan kaavan. "]
["Kirjoita projektin tiedot soluihin B9–G9. \nMallitiedot ovat soluissa B9–G33.\nKirjoita välitavoitteen kuvaus, valitse luokka avattavasta luettelosta, määritä kohteeseen henkilö ja kirjoita tehtävän edistymistiedot, alkamispäivä ja kesto aloittaaksesi kaavioinnin.\nSeuraava ohje on solussa A34.","Otsikko 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Tavoite\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Välitavoite\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Tavoite\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Välitavoite\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Tavoite\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Välitavoite\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Tavoite\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Välitavoite\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Tehtävä 1","Tavoite","Nimi",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-07-29"},3,null,{"$f":"IF(AND($C10=\"Tavoite\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Välitavoite\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 2","Välitavoite",null,null,{"$f":"TODAY()+5","v":"2019-08-03"},1,null,{"$f":"IF(AND($C11=\"Tavoite\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Välitavoite\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 3","Matala riski",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-07-26"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 4","Välitavoite",null,null,{"$f":"F10+20","v":"2019-08-18"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 5","Keskisuuri riski",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-08-04"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Otsikko 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 1","Korkea riski",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-08-04"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 2","Seurataan",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-08-06"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 3","Matala riski",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-08-11"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 4","Välitavoite",null,null,{"$f":"F18+2","v":"2019-08-13"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 5",{"$nulls":3},{"$f":"F19+1","v":"2019-08-14"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Otsikko 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 1","Seurataan",null,null,{"$f":"F10+15","v":"2019-08-13"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 2","Keskisuuri riski",null,null,{"$f":"F22+3","v":"2019-08-16"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 3","Seurataan",null,null,{"$f":"F23+15","v":"2019-08-31"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Tavoite\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"Välitavoite\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Tavoite\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"Välitavoite\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Tehtävä 4","Tavoite",null,null,{"$f":"F19+22","v":"2019-09-04"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"Tavoite\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"Välitavoite\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 5","Matala riski",null,null,{"$f":"F14","v":"2019-08-04"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Otsikko 4",{"$nulls":6},{"$f":"IF(AND($C27=\"Tavoite\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"Välitavoite\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 1",{"$nulls":3},{"$f":"F25+3","v":"2019-09-07"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 3","Välitavoite",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tehtävä 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tämä on tyhjä rivi",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tämä rivi merkitsee Gantt-välitavoitetietojen loppua. ÄLÄ kirjoita mitään tälle riville. \nJos haluat lisätä kohteen, lisää uusi rivi tämän rivin yläpuolelle.","Jos haluat lisätä tietoa, lisää uusi rivi tämän rivin YLÄPUOLELLE"]

{"sheet":"Noin","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["Tietoja tästä mallista"]
["Tämän mallin avulla voit helposti luoda Gantt-kaavion, jonka avulla voit visualisoida ja seurata projektia. Kirjoita vain tehtävän kuvaus, valitse tavoiteluokka, välitavoite, seuranta, matala riski, keskisuuri riski, korkea riski, valmiusprosentti, aloituspäivämäärä ja tieto siitä, kuinka monta päivää tehtävän suorittaminen kestää. Gantt-kaavio täyttyy ja on värikoodattu, mikä auttaa erottamaan eri luokat toisistaan. Vierityspalkin avulla voit vierittää aikajanaa. Voit lisätä uusia tehtäviä lisäämällä uusia rivejä.\n"]
["Ohjeet näytönlukuohjelmia varten"]
["Tässä työkirjassa on kaksi laskentataulukkoa. \n\nGantt-kaavio\nTietoja\n\nJokaisen laskentataulukon ohjeet ovat sarakkeessa A alkaen solusta A1. Ne on kirjoitettu piilotekstinä. Jokainen vaihe opastaa sinua kyseisen rivin tiedoissa. Jokainen seuraava vaihe jatkuu solussa A2, A3 jne., ellei nimenomaisesti muuta ole mainittu. Ohjetekstissä voi lukea esimerkiksi ”jatka soluun A6” seuraavaa vaihetta varten. \n\nTätä piilotekstiä ei tulosteta.\n\nVoit poistaa nämä ohjeet laskentataulukosta poistamalla sarakkeen A."]
["Tämä on tämän laskentataulukon viimeinen ohje."]