{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Projekt 1 ülesandeloend","Sätted ja arvutused"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Projekt 1 ülesandeloend","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Projekti ülesandeloend"]
[]
[null,"Täidab:",null,null,"Tähtaeg:",null,"Esiletõste tegevused"]
[null,"Kati Aus",null,null,{"$f":"TODAY()+95","v":"2013-10-20"},null,"     Praegune nädal [18. juuni - 24. juuni]"]
[]
[null,"Projekt 1"]
[null,"Tegevus","Tähtaeg","Eelarve","% Valmis","Edenemine","Märkused"," "]
[null,"Kavandamine",{"$f":"TODAY()-90","v":"2013-04-18"},{"v":476,"d":"476.00 €"},{"v":0.25,"d":"25%"},{"$f":"tblÜlesandeloend[[#This Row],[% Valmis]]","v":{"v":0.25,"d":"25%"}}]
[null,"Ettevalmistus",{"$f":"TODAY()-2","v":"2013-07-15"},{"v":301,"d":"301.00 €"},{"v":0.1,"d":"10%"},{"$f":"tblÜlesandeloend[[#This Row],[% Valmis]]","v":{"v":0.1,"d":"10%"}}]
[null,"Ülesanne A",{"$f":"TODAY()-7","v":"2013-07-10"},{"v":429,"d":"429.00 €"},{"v":0,"d":"0%"},{"$f":"tblÜlesandeloend[[#This Row],[% Valmis]]","v":{"v":0,"d":"0%"}}]
[null,"Ülesanne B",{"$f":"TODAY()+20","v":"2013-08-06"},{"v":332,"d":"332.00 €"},{"v":0.7,"d":"70%"},{"$f":"tblÜlesandeloend[[#This Row],[% Valmis]]","v":{"v":0.7,"d":"70%"}}]
[null,"Ülesanne C",{"$f":"TODAY()+40","v":"2013-08-26"},{"v":471,"d":"471.00 €"},{"v":0.1,"d":"10%"},{"$f":"tblÜlesandeloend[[#This Row],[% Valmis]]","v":{"v":0.1,"d":"10%"}}]
[null,"Ülesanne D",{"$f":"TODAY()+45","v":"2013-08-31"},{"v":418,"d":"418.00 €"},{"v":1,"d":"100%"},{"$f":"tblÜlesandeloend[[#This Row],[% Valmis]]","v":{"v":1,"d":"100%"}}]
[null,"Paberimajandus",{"$f":"TODAY()+55","v":"2013-09-10"},{"v":150,"d":"150.00 €"},{"v":0,"d":"0%"},{"$f":"tblÜlesandeloend[[#This Row],[% Valmis]]","v":{"v":0,"d":"0%"}},"Alusta, kui ülesanne B on valmis"]
[null,"Esitamine",{"$f":"TODAY()+70","v":"2013-09-25"},{"v":330,"d":"330.00 €"},{"v":0.25,"d":"25%"},{"$f":"tblÜlesandeloend[[#This Row],[% Valmis]]","v":{"v":0.25,"d":"25%"}}]
[null,"Järeltegevus",{"$f":"TODAY()+90","v":"2013-10-15"},{"v":353,"d":"353.00 €"},{"v":0.5,"d":"50%"},{"$f":"tblÜlesandeloend[[#This Row],[% Valmis]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Sätted ja arvutused","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Esiletõste sätted"]
[null,"Allolevad tabelid talletavad ripploendi Esiletõste tegevused sätted ja arvutused. \nKõik muudatused võivad anda tõrke või eemaldada funktsioone.\n"]
[null,"Esiletõsteta",null,null,{"$f":"B5","v":"Esiletõsteta"}]
[null,"Vahemik:","Algus:","Lõpp:","Tähtaeg:"]
[null,"     Praegune nädal",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2013-07-15"},{"$f":"C7+6","v":"2013-07-21"},{"$f":"B7&\" [\"&TEXT(C7,\"d mmm\")&\" - \"&TEXT(D7,\"d mmm\")&\"]\"","v":"     Praegune nädal [15 juuli - 21 juuli]"}]
[null,"     Praegune kuu",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2013-07-01"},{"$f":"EDATE(C8,1)-1","v":"2013-07-31"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"d mmm\")&\"]\"","v":"     Praegune kuu [1 - 31 juuli]"}]
[null,"     Praegune kvartal",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2013-03-01"},{"$f":"EDATE(C9,4)-1","v":"2013-06-30"},{"$f":"B9&\" [\"&TEXT(C9,\"d mmm\")&\" - \"&TEXT(D9,\"d mmm\")&\"]\"","v":"     Praegune kvartal [1 märts - 30 juuni]"}]
[null,"     Praegune aasta",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2013-01-01"},{"$f":"EDATE(C10,12)-1","v":"2013-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"yyyy\")&\"]\"","v":"     Praegune aasta [2013]"}]
[null,"Vahemik:",null,null,{"$f":"B11","v":"Vahemik:"}]
[null,"     Eelmine nädal",{"$f":"C7-7","v":"2013-07-08"},{"$f":"C12+6","v":"2013-07-14"},{"$f":"B12&\" [\"&TEXT(C12,\"d mmm\")&\" - \"&TEXT(D12,\"d mmm\")&\"]\"","v":"     Eelmine nädal [8 juuli - 14 juuli]"}]
[null,"     Eelmine kuu",{"$f":"EDATE(C8,-1)","v":"2013-06-01"},{"$f":"EDATE(C13,1)-1","v":"2013-06-30"},{"$f":"B13&\"[\"&TEXT(C13,\"d\")&\" - \"&TEXT(D13,\"d mmm\")&\"]\"","v":"     Eelmine kuu[1 - 30 juuni]"}]
[null,"     Eelmine kvartal",{"$f":"EDATE(C9,-3)","v":"2012-12-01"},{"$f":"EDATE(C14,3)-1","v":"2013-02-28"},{"$f":"B14&\" [\"&TEXT(C14,\"d mmm\")&\" - \"&TEXT(D14,\"d mmm\")&\"]\"","v":"     Eelmine kvartal [1 dets - 28 veebr]"}]
[null,"     Eelmine aasta",{"$f":"EDATE(C10,-12)","v":"2012-01-01"},{"$f":"EDATE(C15,12)-1","v":"2012-12-31"},{"$f":"B15","v":"     Eelmine aasta"}]
[]
[null,"Valitud esiletõst:",{"$f":"IFERROR(MATCH(EsiletõstTegevused,lstÜlesandeEsiletõsted,0),\"\")","v":""},{"$f":"EsiletõstTegevused","v":"     Praegune nädal [18. juuni - 24. juuni]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Esiletõste algus",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Esiletõste lõpp",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]