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

{"sheet":"Gantogram","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]]}
["Na tem delovnem listu ustvarite gantogram.\nV celico B1 vnesite naslov tega projekta. \nNaslov legende je v celici I1.\nPodatki o tem, kako uporabljate ta delovni list, vključno z navodili za bralnike zaslona in za avtorja tega delovnega zvezka, so na voljo na delovnem listu »Več informacij«.\nČe želite slišati nadaljnja navodila, se pomikajte navzdol po stolpcu A.","NASLOV PROJEKTA",{"$nulls":6},"Legenda:"]
["V celico B2 vnesite ime podjetja.\nLegenda je v celicah od I2 do AC2.","Ime podjetja",{"$nulls":6},"Skladno z načrtom",{"$nulls":4},"Nizko tveganje",{"$nulls":4},"Srednje tveganje",{"$nulls":4},"Visoko tveganje",{"$nulls":4},"Nedodeljeno"]
["V celico B3 vnesite ime vodje projekta. V celico F3 vnesite datum začetka projekta ali dovolite, da vzorčna formula poišče najmanjšo vrednost datuma iz Ganttove podatkovne tabele.  \nDatum začetka projekta: oznaka je v celici D3.","Vodja projekta",null,"Datum začetka projekta:",null,{"$f":"IFERROR(IF(MIN(Mejniki[Začetek])=0,TODAY(),MIN(Mejniki[Začetek])),TODAY())","v":"2018-07-07"}]
["Povečanje ob drsenju je v celici F4. \nMeseci za datume v vrstici 5 so prikazani z začetkom v celici I4 do celice BL4.\nNe spreminjajte teh celic. Celice se samodejno posodobijo na osnovi datuma začetka projekta v celici F3.",null,null,"Povečanje ob drsenju:",null,0,null,null,{"$f":"TEXT(I5,\"mmmm\")","v":"julij"},{"$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":"avgust"},{"$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":""}]
["Celice od I5 do BL5, ki se izračunajo samodejno, vsebujejo številko dneva v mesecu za mesec, ki je predstavljen v bloku celic nad posamezno celico datuma.\nNe spreminjajte teh celic.\nDanašnji datum je orisan z rdečo (hex #AD3815) od današnjega datuma v vrstici 5 prek celotnega datumskega stolpca do konca načrta projekta.",{"$nulls":7},{"$f":"IFERROR(Začetek_projekta+Povečanje_ob_drsenju,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"]
["Drsni trak je v celicah od I6 do BL6. Prirastek za pomikanje po straneh po podatkih je definiran kot 2 strani naenkrat in ga je mogoče konfigurirati v nastavitvah za nadzorno vrstico. \nČe se želite pomakniti naprej ali nazaj na časovni premici, v celico F4 vnesite vrednost 0 ali višjo.\nVrednost 0 vas pomakne na začetek grafikona."]
["Ta vrstica vsebuje glave za načrt projekt, ki sledi pod njimi. \nPomaknite se od celice B7 do BL7, da slišite vsebino. Prva črka vsakega dneva v tednu za datum, ki je nad tem naslovom, se začne v celici I7 in se nadaljuje do celice BL7.\nVsi grafikoni časovnice projekta se samodejno ustvarijo glede na kategorijo, začetni datum in število dni, ki so bili vneseni v tabelo mejnikov.","Opis mejnika","Kategorija","Dodeljeno osebi","Napredek","Začetek","Št. dni",null,{"$f":"LEFT(TEXT(I5,\"ddd\"),1)","v":"s"},{"$f":"LEFT(TEXT(J5,\"ddd\"),1)","v":"n"},"p","t","s","č","p","s","n","p","t","s","č","p","s","n","p","t","s","č","p","s","n","p","t","s","č","p","s","n","p","t","s","č","p","s",{"$f":"LEFT(TEXT(AS5,\"ddd\"),1)","v":"n"},"p","t","s","č","p","s","n","p","t","s","č","p","s","n","p","t","s","č","p"]
["Ne izbrišite te vrstice. Ta vrstica je skrita, da ohrani formulo, ki se uporablja za označevanje trenutnega dneva v načrtu projekta. "]
["Vnesite informacije o projektu z začetkom v celici B9 do celice G9. \nVzorčni podatki so v celicah od B9 do G33.\nVnesite opis mejnika, na spustnem seznamu izberite kategorijo, nato nekomu dodelite element, vnesite napredek, začetni datum in število dni za opravilo, da ustvarite grafikon.\nNaslednje navodilo je v celici A34.","Naslov 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Cilj\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Mejnik\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Cilj\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Mejnik\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Cilj\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Mejnik\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Cilj\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Mejnik\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Opravilo 1","Cilj","Ime",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-07-26"},3,null,{"$f":"IF(AND($C10=\"Cilj\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Mejnik\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 2","Mejnik",null,null,{"$f":"TODAY()+5","v":"2019-07-31"},1,null,{"$f":"IF(AND($C11=\"Cilj\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Mejnik\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 3","Nizko tveganje",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-07-23"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 4","Mejnik",null,null,{"$f":"F10+20","v":"2019-08-15"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 5","Srednje tveganje",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-08-01"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Naslov 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 1","Visoko tveganje",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-08-01"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 2","Skladno z načrtom",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-08-03"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 3","Nizko tveganje",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-08-08"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 4","Mejnik",null,null,{"$f":"F18+2","v":"2019-08-10"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 5",{"$nulls":3},{"$f":"F19+1","v":"2019-08-11"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Naslov 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 1","Skladno z načrtom",null,null,{"$f":"F10+15","v":"2019-08-10"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 2","Srednje tveganje",null,null,{"$f":"F22+3","v":"2019-08-13"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 3","Skladno z načrtom",null,null,{"$f":"F23+15","v":"2019-08-28"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Cilj\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"Mejnik\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Cilj\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"Mejnik\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Opravilo 4","Cilj",null,null,{"$f":"F19+22","v":"2019-09-01"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"Cilj\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"Mejnik\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 5","Nizko tveganje",null,null,{"$f":"F14","v":"2019-08-01"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Naslov 4",{"$nulls":6},{"$f":"IF(AND($C27=\"Cilj\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"Mejnik\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 1",{"$nulls":3},{"$f":"F25+3","v":"2019-09-04"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 3","Mejnik",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Opravilo 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["To je prazna vrstica.",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Ta vrstica označuje konec podatkov o mejniku v gantogramu. V tej vrstici NE vnašajte ničesar. \nČe želite dodati več elementov, nad to vrstico vstavite nove vrstice.","Če želite dodati več podatkov, NAD to vrstico vstavite nove vrstice."]

{"sheet":"Vizitka","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["O tej predlogi"]
["S to predlogo lahko preprosto ustvarite gantogram, ki pomaga vizualizirati in spremljati projekt. Vnesite opis opravil, izberite kategorijo za Cilj, Mejnik, Skladno z načrtom, Nizko tveganje, Srednje tveganje, Visoko tveganje, Napredek v odstotkih dokončanja opravila, Začetni datum in Število dni za dokončanje opravila. Gantogram se izpolni in označi z barvami, da vam pomaga razlikovati različne kategorije. Drsnik omogoča premikanje po časovni premici. Vstavite nova opravila tako, da vstavite nove vrstice.\n"]
["Navodila za bralnike zaslona"]
["V tem delovnem zvezku sta 2 delovna lista. \n\nGantogram\nVizitka\n\nNavodila za posamezne delovne liste so v stolpcu A, ki se na vsakem listu začne v celici A1. Navodila so zapisana s skritim besedilom. Vsak korak opiše informacije v tisti vrstici. Vsak naslednji korak se nadaljuje v celicah A2, A3 itd., razen če je navedeno drugače. V navodilih je lahko na primer navedeno, da se za naslednji korak »pomaknite v celico A6«. \n\nTega skritega besedila ni mogoče natisniti.\n\nČe želite ta navodila odstraniti iz delovnega lista, preprosto izbrišite stolpec A."]
["To je zadnje navodilo na tem delovnem listu."]