{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gantt","Teave"],"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]]}
["Sellel töölehel saate luua Gantti diagrammi.\nSisestage lahtrisse B1 selle projekti pealkiri. \nLahtris I1 on legendi pealkiri.\nSelle töölehe kasutamise juhised, sealhulgas juhised ekraanilugerite jaoks ja teave autori kohta, on töölehel Teave.\nEdasiste juhiste kuulamiseks liikuge veerus A allapoole.","PROJEKTI PEALKIRI",{"$nulls":6},"Legend:"]
["Lahtrisse B2 sisestage ettevõtte nimi.\nLegend on lahtrites I2 kuni AC2.","Ettevõtte nimi",{"$nulls":6},"Korras",{"$nulls":4},"Madal risk",{"$nulls":4},"Keskmine risk",{"$nulls":4},"Suur risk",{"$nulls":4},"Määramata"]
["Sisestage lahtrisse B3 projektijuht. Sisestage lahtrisse F3 projekti alguskuupäev või lubage näidisvalemil leida Gantti andmetabelist väikseim kuupäeva väärtus.  \nProjekti alguskuupäev: silt asub lahtris D3.","Projektijuht",null,"Projekti alguskuupäev:",null,{"$f":"IFERROR(IF(MIN(Vaheeesmärgid[Algus])=0,TODAY(),MIN(Vaheeesmärgid[Algus])),TODAY())","v":"2018-07-07"}]
["Lahtris F4 on sammu kerimine. \nReal 5 olevate kuude kuupäevade kuvatakse lahtrites I4 kuni BL4.\nÄrge neid lahtreid muutke. Need värskendatakse lahtris F3 asuva projekti alguskuupäeva alusel automaatselt.",null,null,"Kerimise samm:",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":""}]
["Lahtrid I5 kuni BL5 sisaldavad ülemises lahtriplokis toodud kuu iga kuupäeva lahtri kuupäeva numbreid ja arvutatakse automaatselt.\nÄrge neid lahtreid muutke.\nTänane kuupäev on toodud ära punaselt (kuusnurk nr AD3815) tänasest päevast reas 5 läbi kogu kuupäeva veeru kuni projekti ajakava lõpuni.",{"$nulls":7},{"$f":"IFERROR(Projekti_Algus+Kerimise_Samm,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"]
["Kerimisriba asub lahtrites I6 kuni BL6. Läbi andmete sirvimise samm on määratletud 2 lehekülge korraga ja seda saab käsuriba sätetes konfigureerida. \nAjaskaalal edasi või tagasi liikumiseks sisestage lahtrisse F4 väärtus 0 või suurem.\nVäärtus 0 viib teid diagrammi algusesse."]
["See rida sisaldab projekti ajakava päiseid, mis sellele all järgneb. \nSisu kuulamiseks navigeerige lahtrites B7 kuni BL7. Selle pealkirja kohal oleva kuupäeva nädalapäeva esitäht algab lahtrist I7 ja jätkub kuni lahtrini BL7.\nKogu projekti ajaskaala genereeritakse automaatselt, vastavalt kategooriale, alguskuupäevale ja tabelisse Vaheetapid sisestatud päevade arvule.","Vaheetapi kirjeldus","Kategooria","Vastutav isik","Edenemine","Algus","Päevade arv",null,{"$f":"LEFT(TEXT(I5,\"ddd\"),1)","v":"S"},{"$f":"LEFT(TEXT(J5,\"ddd\"),1)","v":"S"},"M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S",{"$f":"LEFT(TEXT(AS5,\"ddd\"),1)","v":"S"},"M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F"]
["Ärge seda rida kustutage. See rida on peidetud, et säilitada valem, mida kasutatakse projekti ajakava praeguse päeva esiletõstmiseks. "]
["Sisestage projekti teave alates lahtrist B9 kuni lahtrini G9. \nNäidisandmed on lahtrites B9 kuni G33.\nDiagrammi loomiseks sisestage vaheetapi kirjeldus, valige ripploendist kategooria, määrake keegi üksuse eest vastutavaks, sisestage edenemine, alguskuupäev ja ülesandele kuluvate päevade arv.\nJärgmine juhis on lahtris A34.","Pealkiri 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Eesmärk\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Vaheetapp\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Eesmärk\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Vaheetapp\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Eesmärk\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Vaheetapp\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Eesmärk\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Vaheetapp\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Ülesanne 1","Eesmärk","Nimi",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-07-25"},3,null,{"$f":"IF(AND($C10=\"Eesmärk\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Vaheetapp\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 2","Vaheetapp",null,null,{"$f":"TODAY()+5","v":"2019-07-30"},1,null,{"$f":"IF(AND($C11=\"Eesmärk\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Vaheetapp\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 3","Madal risk",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-07-22"},10,null,{"$f":"IF(AND($C12=\"Eesmärk\",I$5>=$F12,I$5<=$F12+$G12-1),2,IF(AND($C12=\"Vaheetapp\",I$5>=$F12,I$5<=$F12+$G12-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C12=\"Eesmärk\",S$5>=$F12,S$5<=$F12+$G12-1),2,IF(AND($C12=\"Vaheetapp\",S$5>=$F12,S$5<=$F12+$G12-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C12=\"Eesmärk\",AC$5>=$F12,AC$5<=$F12+$G12-1),2,IF(AND($C12=\"Vaheetapp\",AC$5>=$F12,AC$5<=$F12+$G12-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C12=\"Eesmärk\",AM$5>=$F12,AM$5<=$F12+$G12-1),2,IF(AND($C12=\"Vaheetapp\",AM$5>=$F12,AM$5<=$F12+$G12-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C12=\"Eesmärk\",AW$5>=$F12,AW$5<=$F12+$G12-1),2,IF(AND($C12=\"Vaheetapp\",AW$5>=$F12,AW$5<=$F12+$G12-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C12=\"Eesmärk\",BG$5>=$F12,BG$5<=$F12+$G12-1),2,IF(AND($C12=\"Vaheetapp\",BG$5>=$F12,BG$5<=$F12+$G12-1),1,\"\"))","v":""},"","","","",""]
[null,"Ülesanne 4","Vaheetapp",null,null,{"$f":"F10+20","v":"2019-08-14"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 5","Keskmine risk",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-07-31"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Pealkiri 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 1","Suur risk",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-07-31"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 2","Korras",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-08-02"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 3","Madal risk",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-08-07"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 4","Vaheetapp",null,null,{"$f":"F18+2","v":"2019-08-09"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 5",{"$nulls":3},{"$f":"F19+1","v":"2019-08-10"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Pealkiri 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 1","Korras",null,null,{"$f":"F10+15","v":"2019-08-09"},4,null,{"$f":"IF(AND($C22=\"Eesmärk\",I$5>=$F22,I$5<=$F22+$G22-1),2,IF(AND($C22=\"Vaheetapp\",I$5>=$F22,I$5<=$F22+$G22-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C22=\"Eesmärk\",S$5>=$F22,S$5<=$F22+$G22-1),2,IF(AND($C22=\"Vaheetapp\",S$5>=$F22,S$5<=$F22+$G22-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C22=\"Eesmärk\",AC$5>=$F22,AC$5<=$F22+$G22-1),2,IF(AND($C22=\"Vaheetapp\",AC$5>=$F22,AC$5<=$F22+$G22-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C22=\"Eesmärk\",AM$5>=$F22,AM$5<=$F22+$G22-1),2,IF(AND($C22=\"Vaheetapp\",AM$5>=$F22,AM$5<=$F22+$G22-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C22=\"Eesmärk\",AW$5>=$F22,AW$5<=$F22+$G22-1),2,IF(AND($C22=\"Vaheetapp\",AW$5>=$F22,AW$5<=$F22+$G22-1),1,\"\"))","v":""},"","","","","","","","","",{"$f":"IF(AND($C22=\"Eesmärk\",BG$5>=$F22,BG$5<=$F22+$G22-1),2,IF(AND($C22=\"Vaheetapp\",BG$5>=$F22,BG$5<=$F22+$G22-1),1,\"\"))","v":""},"","","","",""]
[null,"Ülesanne 2","Keskmine risk",null,null,{"$f":"F22+3","v":"2019-08-12"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 3","Korras",null,null,{"$f":"F23+15","v":"2019-08-27"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 4","Eesmärk",null,null,{"$f":"F19+22","v":"2019-08-31"},3,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 5","Madal risk",null,null,{"$f":"F14","v":"2019-07-31"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Pealkiri 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 1",{"$nulls":3},{"$f":"F25+3","v":"2019-09-03"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 3","Vaheetapp",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ülesanne 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["See on tühi rida",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["See rida märgib Gantti vaheetapi andmete lõppu. ÄRGE sisestage sellele reale midagi. \nTäiendavate üksuste lisamiseks lisage uusi ridu selle rea ette.","Täiendavate andmete lisamiseks lisage uusi ridu selle rea ETTE"]

{"sheet":"Teave","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["Teave selle malli kohta"]
["See mall võimaldab lihtsasti luua Gantti diagrammi, mis aitab projekti visualiseerida ja jälgida. Lihtsalt sisestage ülesande kirjeldus, valige eesmärk kategooria, määrake suvandid Vaheetapp, Korras, Madal risk, Keskmine risk, Suur risk, Progress toimingu lõpuleviimise protsendina, Alguskuupäev ja Toimingu lõpetamiseks kuluvate päevade arv. Gantti diagramm sisestatakse ja on tähistatud värvidega, mis aitab erinevaid kategooriaid eristada. Kerimisriba abil saate sirvida ajaskaalat. Uute tööülesannete lisamiseks lisage uued read.\n"]
["Ekraanilugeri juhised"]
["Selles töövihikus on 2 töölehte. \n\nGantti diagramm\nTeave\n\nIga töölehe juhised leiate vastava töölehe veerust A. Juhised algavad alati lahtrist A1. Need on lisatud peittekstina. Iga juhis annab ülevaate sellel real olevast teabest. Järgmiste toimingute juhised leiate lahtritest A2, A3 jne, kui pole teisiti kirjeldatud. Juhises võib näiteks järgmise toimingu kohta olla tekst „jätkake lahtris A6“. \n\nSeda peitteksti ei prindita.\n\nTöölehelt juhiste eemaldamiseks lihtsalt kustutage veerg A."]
["See on viimane juhis sellel töölehel."]