{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["1 projekto užduočių sąrašas","Parametrai ir skaičiavimai"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"1 projekto užduočių sąrašas","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Projekto užduočių sąrašas"]
[]
[null,"Atlikti iki:",null,null,"Terminas:",null,"Paryškintos veiklos"]
[null,"Virginija Aleknienė",null,null,{"$f":"TODAY()+95","v":"2012-12-28"},null,"     Ši savaitė\n     [birželio 18 d. – birželio 24 d.]"]
[]
[null,"1 projektas"]
[null,"Veikla","Terminas","Biudžetas","% atlikta","Vykdoma","Pastabos"," "]
[null,"Planavimas",{"$f":"TODAY()-90","v":"2012-06-26"},{"v":476,"d":"476.00 Lt"},{"v":0.25,"d":"25%"},{"$f":"tblPatarimųSąrašas[[#This Row],[% atlikta]]","v":{"v":0.25,"d":"25%"}}]
[null,"Pasiruošimas",{"$f":"TODAY()-2","v":"2012-09-22"},{"v":301,"d":"301.00 Lt"},{"v":0.1,"d":"10%"},{"$f":"tblPatarimųSąrašas[[#This Row],[% atlikta]]","v":{"v":0.1,"d":"10%"}}]
[null,"A užduotis",{"$f":"TODAY()-7","v":"2012-09-17"},{"v":429,"d":"429.00 Lt"},{"v":0,"d":"0%"},{"$f":"tblPatarimųSąrašas[[#This Row],[% atlikta]]","v":{"v":0,"d":"0%"}}]
[null,"B užduotis",{"$f":"TODAY()+20","v":"2012-10-14"},{"v":332,"d":"332.00 Lt"},{"v":0.7,"d":"70%"},{"$f":"tblPatarimųSąrašas[[#This Row],[% atlikta]]","v":{"v":0.7,"d":"70%"}}]
[null,"C užduotis",{"$f":"TODAY()+40","v":"2012-11-03"},{"v":471,"d":"471.00 Lt"},{"v":0.1,"d":"10%"},{"$f":"tblPatarimųSąrašas[[#This Row],[% atlikta]]","v":{"v":0.1,"d":"10%"}}]
[null,"D užduotis",{"$f":"TODAY()+45","v":"2012-11-08"},{"v":418,"d":"418.00 Lt"},{"v":1,"d":"100%"},{"$f":"tblPatarimųSąrašas[[#This Row],[% atlikta]]","v":{"v":1,"d":"100%"}}]
[null,"Rašto darbas",{"$f":"TODAY()+55","v":"2012-11-18"},{"v":150,"d":"150.00 Lt"},{"v":0,"d":"0%"},{"$f":"tblPatarimųSąrašas[[#This Row],[% atlikta]]","v":{"v":0,"d":"0%"}},"Pradėti, kai bus atlikta B užduotis"]
[null,"Dalinamoji medžiaga",{"$f":"TODAY()+70","v":"2012-12-03"},{"v":330,"d":"330.00 Lt"},{"v":0.25,"d":"25%"},{"$f":"tblPatarimųSąrašas[[#This Row],[% atlikta]]","v":{"v":0.25,"d":"25%"}}]
[null,"Vykdyti",{"$f":"TODAY()+90","v":"2012-12-23"},{"v":353,"d":"353.00 Lt"},{"v":0.5,"d":"50%"},{"$f":"tblPatarimųSąrašas[[#This Row],[% atlikta]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Parametrai ir skaičiavimai","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Paryškinimo parametrai"]
[null,"Toliau pateikiamose lentelėse saugomi paryškintų veiklų išplečiamojo sąrašo parametrai ir skaičiavimai.\nBet kokie pakeitimai gali sukelti klaidas arba dėl jų gali nebeveikti funkcijos."]
[null,"Neparyškinta",null,null,{"$f":"B5","v":"Neparyškinta"}]
[null,"Intervalas:","Pradžia:","Pabaiga:","Terminas:"]
[null,"     Šią savaitę",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-09-24"},{"$f":"C7+6","v":"2012-09-30"},{"$f":"B7&\" [\"&TEXT(C7,\"d mmm\")&\" - \"&TEXT(D7,\"d mmm\")&\"]\"","v":"     Šią savaitę [24 Rgs - 30 Rgs]"}]
[null,"     Šis mėnuo",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-09-01"},{"$f":"EDATE(C8,1)-1","v":"2012-09-30"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"d mmm\")&\"]\"","v":"     Šis mėnuo [1 - 30 Rgs]"}]
[null,"     Šis ketvirtis",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-04-01"},{"$f":"EDATE(C9,4)-1","v":"2012-07-31"},{"$f":"B9&\" [\"&TEXT(C9,\"d mmm\")&\" - \"&TEXT(D9,\"d mmm\")&\"]\"","v":"     Šis ketvirtis [1 Bal - 31 Lie]"}]
[null,"     Šie metai",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"yyyy\")&\"]\"","v":"     Šie metai [2012]"}]
[null,"Intervalas:",null,null,{"$f":"B11","v":"Intervalas:"}]
[null,"     Ši savaitė",{"$f":"C7-7","v":"2012-09-17"},{"$f":"C12+6","v":"2012-09-23"},{"$f":"B12&\" [\"&TEXT(C12,\"d mmm\")&\" - \"&TEXT(D12,\"d mmm\")&\"]\"","v":"     Ši savaitė [17 Rgs - 23 Rgs]"}]
[null,"     Praėjęs mėnuo",{"$f":"EDATE(C8,-1)","v":"2012-08-01"},{"$f":"EDATE(C13,1)-1","v":"2012-08-31"},{"$f":"B13&\" [\"&TEXT(C13,\"d\")&\" - \"&TEXT(D13,\"d mmm\")&\"]\"","v":"     Praėjęs mėnuo [1 - 31 Rgp]"}]
[null,"     Praėjęs ketvirtis",{"$f":"EDATE(C9,-3)","v":"2012-01-01"},{"$f":"EDATE(C14,3)-1","v":"2012-03-31"},{"$f":"B14&\" [\"&TEXT(C14,\"d mmm\")&\" - \"&TEXT(D14,\"d mmm\")&\"]\"","v":"     Praėjęs ketvirtis [1 Sau - 31 Kov]"}]
[null,"     Praėję metai",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     Praėję metai"}]
[]
[null,"Pasirinktas paryškinimas:",{"$f":"IFERROR(MATCH(ParyškintiVeiklas,PatarimųParyškinimai1,0),\"\")","v":""},{"$f":"ParyškintiVeiklas","v":"     Ši savaitė\n     [birželio 18 d. – birželio 24 d.]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Paryškinti pradžią",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Paryškinti pabaigą",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]