{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["1. projekta uzdevumu saraksts","Iestatījumi un aprēķini"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"1. projekta uzdevumu saraksts","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Projekta uzdevumu saraksts"]
[]
[null,"Jāaizpilda:",null,null,"Termiņš:",null,"Aktivitāšu izcelšana"]
[null,"Laura Vanaga",null,null,{"$f":"TODAY()+95","v":"2014-07-18"},null,"     Šonedēļ [ 18. jūnijs – 24. jūnijs]"]
[]
[null,"Projekts 1"]
[null,"Aktivitāte","Izpildes datums","Budžets","Izpildes %","Norise","Piezīmes"," "]
[null,"Plānošana",{"$f":"TODAY()-90","v":"2014-01-14"},{"v":476,"d":"476.00 €"},{"v":0.25,"d":"25%"},{"$f":"tblDarbusaraksts[[#This Row],[Izpildes %]]","v":{"v":0.25,"d":"25%"}}]
[null,"Sagatavošana",{"$f":"TODAY()-2","v":"2014-04-12"},{"v":301,"d":"301.00 €"},{"v":0.1,"d":"10%"},{"$f":"tblDarbusaraksts[[#This Row],[Izpildes %]]","v":{"v":0.1,"d":"10%"}}]
[null,"Uzdevums A",{"$f":"TODAY()-7","v":"2014-04-07"},{"v":429,"d":"429.00 €"},{"v":0,"d":"0%"},{"$f":"tblDarbusaraksts[[#This Row],[Izpildes %]]","v":{"v":0,"d":"0%"}}]
[null,"Uzdevums B",{"$f":"TODAY()+20","v":"2014-05-04"},{"v":332,"d":"332.00 €"},{"v":0.7,"d":"70%"},{"$f":"tblDarbusaraksts[[#This Row],[Izpildes %]]","v":{"v":0.7,"d":"70%"}}]
[null,"Uzdevums C",{"$f":"TODAY()+40","v":"2014-05-24"},{"v":471,"d":"471.00 €"},{"v":0.1,"d":"10%"},{"$f":"tblDarbusaraksts[[#This Row],[Izpildes %]]","v":{"v":0.1,"d":"10%"}}]
[null,"Uzdevums D",{"$f":"TODAY()+45","v":"2014-05-29"},{"v":418,"d":"418.00 €"},{"v":1,"d":"100%"},{"$f":"tblDarbusaraksts[[#This Row],[Izpildes %]]","v":{"v":1,"d":"100%"}}]
[null,"Darbs ar dokumentiem",{"$f":"TODAY()+55","v":"2014-06-08"},{"v":150,"d":"150.00 €"},{"v":0,"d":"0%"},{"$f":"tblDarbusaraksts[[#This Row],[Izpildes %]]","v":{"v":0,"d":"0%"}},"Sākt pēc uzdevuma B izpildes"]
[null,"Nodošana",{"$f":"TODAY()+70","v":"2014-06-23"},{"v":330,"d":"330.00 €"},{"v":0.25,"d":"25%"},{"$f":"tblDarbusaraksts[[#This Row],[Izpildes %]]","v":{"v":0.25,"d":"25%"}}]
[null,"Sekošana",{"$f":"TODAY()+90","v":"2014-07-13"},{"v":353,"d":"353.00 €"},{"v":0.5,"d":"50%"},{"$f":"tblDarbusaraksts[[#This Row],[Izpildes %]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Iestatījumi un aprēķini","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Izcelšanas iestatījumi"]
[null,"Tabulās tiek glabāti iestatījumi un aprēķini, kas paredzēti nolaižamajam sarakstam Aktivitāšu izcelšana.\nJebkādas izmaiņas var radīt kļūdas vai funkcionalitātes zudumu."]
[null,"Bez izcelšanas",null,null,{"$f":"B5","v":"Bez izcelšanas"}]
[null,"Intervāls:","Sākums:","Beigas:","Termiņš:"]
[null,"     Šonedēļ",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2014-04-14"},{"$f":"C7+6","v":"2014-04-20"},{"$f":"B7&\" [\"&TEXT(C7,\"d. mmm\")&\" - \"&TEXT(D7,\"d. mmm\")&\"]\"","v":"     Šonedēļ [14. apr - 20. apr]"}]
[null,"     Šajā mēnesī",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2014-04-01"},{"$f":"EDATE(C8,1)-1","v":"2014-04-30"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"d. mmm\")&\"]\"","v":"     Šajā mēnesī [1 - 30. apr]"}]
[null,"     Šajā ceturksnī",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2014-02-01"},{"$f":"EDATE(C9,4)-1","v":"2014-05-31"},{"$f":"B9&\" [\"&TEXT(C9,\"d. mmm\")&\" - \"&TEXT(D9,\"d. mmm\")&\"]\"","v":"     Šajā ceturksnī [1. feb - 31. mai]"}]
[null,"     Šogad",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2014-01-01"},{"$f":"EDATE(C10,12)-1","v":"2014-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"yyyy\")&\"]\"","v":"     Šogad [2014]"}]
[null,"Intervāls:",null,null,{"$f":"B11","v":"Intervāls:"}]
[null,"     Pagājušajā nedēļā",{"$f":"C7-7","v":"2014-04-07"},{"$f":"C12+6","v":"2014-04-13"},{"$f":"B12&\" [\"&TEXT(C12,\"d. mmm\")&\" - \"&TEXT(D12,\"d. mmm\")&\"]\"","v":"     Pagājušajā nedēļā [7. apr - 13. apr]"}]
[null,"     Pagājušajā mēnesī",{"$f":"EDATE(C8,-1)","v":"2014-03-01"},{"$f":"EDATE(C13,1)-1","v":"2014-03-31"},{"$f":"B13&\" [\"&TEXT(C13,\"d\")&\" - \"&TEXT(D13,\"d. mmm\")&\"]\"","v":"     Pagājušajā mēnesī [1 - 31. mar]"}]
[null,"     Pēdējā ceturksnī",{"$f":"EDATE(C9,-3)","v":"2013-11-01"},{"$f":"EDATE(C14,3)-1","v":"2014-01-31"},{"$f":"B14&\" [\"&TEXT(C14,\"d. mmm\")&\" - \"&TEXT(D14,\"d. mmm\")&\"]\"","v":"     Pēdējā ceturksnī [1. nov - 31. jan]"}]
[null,"     Pagājušajā gadā",{"$f":"EDATE(C10,-12)","v":"2013-01-01"},{"$f":"EDATE(C15,12)-1","v":"2013-12-31"},{"$f":"B15","v":"     Pagājušajā gadā"}]
[]
[null,"Atlasītais izcēlums:",{"$f":"IFERROR(MATCH(Izceltdarbības,lstIzcelt,0),\"\")","v":""},{"$f":"Izceltdarbības","v":"     Šonedēļ [ 18. jūnijs – 24. jūnijs]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Sākuma izcelšana",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Beigu izcelšana",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]