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

{"sheet":"Ganta","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[0,1,0,3],[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]]}
["Šajā darblapā izveidojiet Ganta diagrammu.\nŠūnā B1 ievadiet šī projekta virsrakstu. \nApzīmējumu virsraksts ir šūnā I1.\nInformācija par šīs darblapas lietošanu, tostarp norādījumi ekrāna lasītājiem un šīs darbgrāmatas autoram, ir pieejama darblapā Par.\nNaviģējiet uz leju kolonnā A, lai noklausītos nākamos norādījumus.","PROJEKTA VIRSRAKSTS",{"$nulls":6},"Apzīmējumi:"]
["Šūnā B2 ievadiet uzņēmuma nosaukumu.\nApzīmējumi ir šūnās I2–AC2.","Uzņēmuma Nosaukums",{"$nulls":6},"Atbilst Plānotajam",{"$nulls":4},"Zems Risks",{"$nulls":4},"Vidējs Risks",{"$nulls":4},"Augsts Risks",{"$nulls":4},"Nepiešķirts"]
["Šūnā B3 ievadiet projekta vadītāja vārdu. Šūnā F3 ievadiet projekta sākuma datumu vai ļaujiet formulas paraugam atrast mazāko datuma vērtību no Ganta datu tabulas.  \nProjekta sākuma datums: etiķete ir šūnā D3.","Projekta Vadītājs",null,"Projekta Sākuma Datums:",null,{"$f":"IFERROR(IF(MIN(Atskaites_punkti[Sākums])=0,TODAY(),MIN(Atskaites_punkti[Sākums])),TODAY())","v":"2018-07-07"}]
["Ritināšanas palielinājums ir šūnā F4. \nMēneši datumiem rindā 5 tiek rādīti, sākot ar šūnām I4–BL4.\nNemodificējiet šīs šūnas. Tās tiek automātiski atjauninātas, atbilstoši projekta sākuma datumam šūnā F3.",null,null,"Ritināšanas Palielinājums:",null,0,null,null,{"$f":"TEXT(I5,\"mmmm\")","v":"jūlijs"},{"$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":"augusts"},{"$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":""}]
["Šūnās i5–BL5 ir mēneša dienu skaitu mēnesim, kuru norāda šūnu bloks virs katras datuma šūnas, un to vērtības tiek aprēķinātas automātiski.\nNemodificējiet šīs šūnas.\nŠodienas datums ir izcelts sarkanā krāsā (hex #AD3815) no šodienas datuma rindā 5 visā datumu kolonnā līdz projekta grafika beigām.",{"$nulls":7},{"$f":"IFERROR(Projekta_sākums+Ritināšanas_palielinājums,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"]
["Ritjosla ir šūnās I6–BL6. Datu lapošanas pieaugums ir definēts kā 2 lapas vienlaikus, un to var konfigurēt vadības joslas iestatījumos. \nLai laika grafikā pārlēktu uz priekšu vai atpakaļ, šūnā F4 ievadiet vērtību 0 vai lielāku.\nVērtība 0 ļauj pāriet uz diagrammas sākumu."]
["Šajā rindā ir galvenes projekta grafikam, kas atrodas zem tām. \nLai noklausītos saturu, pārvietojieties pa šūnām B7–BL7. Katras nedēļas dienas pirmais burts datumam, kas atrodas virs šī virsraksta, sākas šūnā i7 un turpinās līdz šūnai BL7.\nVisa projekta laika grafiku diagrammu veidošana tiek automātiski ģenerēta atbilstoši kategorijai, sākuma datumam un dienu skaitam, kas ievadīts atskaites punktu tabulā.","Atskaites punkta apraksts","Kategorija","Kam piešķirts","Progress","Sākums","Dienu skaits",null,{"$f":"LEFT(TEXT(I5,\"ddd\"),1)","v":"s"},{"$f":"LEFT(TEXT(J5,\"ddd\"),1)","v":"s"},"p","o","t","c","p","s","s","p","o","t","c","p","s","s","p","o","t","c","p","s","s","p","o","t","c","p","s","s","p","o","t","c","p","s",{"$f":"LEFT(TEXT(AS5,\"ddd\"),1)","v":"s"},"p","o","t","c","p","s","s","p","o","t","c","p","s","s","p","o","t","c","p"]
["Nedzēsiet šo rindu. Šī rinda ir paslēpta, lai saglabātu formulu, kas tiek lietota, lai projekta plānā iezīmētu pašreizējo dienu. "]
["Ievadiet projekta informāciju šūnās B9–G9. \nDatu paraugs ir šūnās B9–G33.\nLai sāktu diagrammas izveidi, ievadiet atskaites punkta aprakstu, nolaižamajā sarakstā atlasiet kategoriju, piešķiriet kādam šo vienumu, ievadiet norises stāvokli, uzdevuma sākuma datumu un dienu skaitu.\nNākamais norādījums ir šūnā A34.","Virsraksts 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Mērķis\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Atskaites punkts\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Mērķis\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Atskaites punkts\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Mērķis\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Atskaites punkts\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Mērķis\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Atskaites punkts\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Uzdevums 1","Mērķis","Vārds",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-07-24"},3,null,{"$f":"IF(AND($C10=\"Mērķis\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Atskaites punkts\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 2","Atskaites punkts",null,null,{"$f":"TODAY()+5","v":"2019-07-29"},1,null,{"$f":"IF(AND($C11=\"Mērķis\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Atskaites punkts\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 3","Zems risks",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-07-21"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 4","Atskaites punkts",null,null,{"$f":"F10+20","v":"2019-08-13"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 5","Vidējs risks",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-07-30"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Virsraksts 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 1","Augsts risks",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-07-30"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 2","Atbilst plānotajam",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-08-01"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 3","Zems risks",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-08-06"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 4","Atskaites punkts",null,null,{"$f":"F18+2","v":"2019-08-08"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 5",{"$nulls":3},{"$f":"F19+1","v":"2019-08-09"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Virsraksts 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 1","Atbilst plānotajam",null,null,{"$f":"F10+15","v":"2019-08-08"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 2","Vidējs risks",null,null,{"$f":"F22+3","v":"2019-08-11"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 3","Atbilst plānotajam",null,null,{"$f":"F23+15","v":"2019-08-26"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Mērķis\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"Atskaites punkts\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Mērķis\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"Atskaites punkts\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Uzdevums 4","Mērķis",null,null,{"$f":"F19+22","v":"2019-08-30"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"Mērķis\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"Atskaites punkts\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 5","Zems risks",null,null,{"$f":"F14","v":"2019-07-30"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Virsraksts 4",{"$nulls":6},{"$f":"IF(AND($C27=\"Mērķis\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"Atskaites punkts\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 1",{"$nulls":3},{"$f":"F25+3","v":"2019-09-02"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 3","Atskaites punkts",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Uzdevums 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Šī ir tukša rinda",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Šī rinda atzīmē Ganta atskaites punktu datu beigas. NEIEVADIET neko šajā rindā. \nLai pievienotu citus vienumus, ievietojiet jaunas rindas virs šīs.","Lai pievienotu citus datus, ievietojiet jaunas rindas VIRS šīs"]

{"sheet":"Par","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["Par šo veidni"]
["Šī veidne sniedz jums vienkāršu veidu, kā izveidot Ganta diagrammu, lai palīdzētu vizualizēt un izsekot jūsu projektu. Vienkārši ievadiet uzdevumu aprakstu, atlasiet mērķa kategoriju, atskaites punktu, Atbilst plānotajam, Zems risks, Vidējs risks, Liels risks, norisi kā procentus atbilstoši uzdevuma izpildes gaitai, sākuma datumu un dienu skaitu uzdevuma pabeigšanai. Ganta diagramma tiek aizpildīta, un tajā ir krāsu kodējums, kas palīdz atšķirt dažādas kategorijas. Ritjosla jums ļauj ritināt pa laika grafiku. Ievietojiet jaunus uzdevumus, ievietojot jaunas rindas.\n"]
["Norādījumi ekrāna lasītājiem"]
["Šajā darbgrāmatā ir 2 darblapas. \n\nGanta diagramma\nPar\n\nNorādījumi katrā darblapā ir sniegti kolonnā A, sākot no šūnas A1. Tie ir rakstīti kā slēpts teksts. Katrā solī ir aprakstīta attiecīgās rindas informācija. Katrs nākamais solis ir aprakstīts šūnā A2, A3 u.t.t., ja vien nav skaidri norādīts citādi. Piemēram, var būt sniegta norāde par nākamo soli “Dodieties uz šūnu A6”. \n\nŠis slēptais teksts netiek drukāts.\n\nLai darblapā noņemtu šos norādījumus, izdzēsiet kolonnu A."]
["Šis ir pēdējais norādījums šajā darblapā."]