{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Projekti 1 tehtäväluettelo","Asetukset ja laskelmat"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Projekti 1 tehtäväluettelo","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Projektin tehtäväluettelo"]
[]
[null,"Tekijä:",null,null,"Määräaika:",null,"Korosta tehtävät"]
[null,"Juha-Pekka Posti",null,null,{"$f":"TODAY()+95","v":"2013-03-16"},null,"     Tällä viikolla [18  Kesä - 24  Kesä]"]
[]
[null,"Projekti 1"]
[null,"Tehtävä","Määräaika","Budjetti","% valmiina","Edistyminen","Huomautukset"," "]
[null,"Suunnittelu",{"$f":"TODAY()-90","v":"2012-09-12"},{"v":476,"d":"€476.00"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[% valmiina]]","v":{"v":0.25,"d":"25%"}}]
[null,"Valmistelu",{"$f":"TODAY()-2","v":"2012-12-09"},{"v":301,"d":"€301.00"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[% valmiina]]","v":{"v":0.1,"d":"10%"}}]
[null,"Tehtävä A",{"$f":"TODAY()-7","v":"2012-12-04"},{"v":429,"d":"€429.00"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[% valmiina]]","v":{"v":0,"d":"0%"}}]
[null,"Tehtävä B",{"$f":"TODAY()+20","v":"2012-12-31"},{"v":332,"d":"€332.00"},{"v":0.7,"d":"70%"},{"$f":"tblToDoList[[#This Row],[% valmiina]]","v":{"v":0.7,"d":"70%"}}]
[null,"Tehtävä C",{"$f":"TODAY()+40","v":"2013-01-20"},{"v":471,"d":"€471.00"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[% valmiina]]","v":{"v":0.1,"d":"10%"}}]
[null,"Tehtävä D",{"$f":"TODAY()+45","v":"2013-01-25"},{"v":418,"d":"€418.00"},{"v":1,"d":"100%"},{"$f":"tblToDoList[[#This Row],[% valmiina]]","v":{"v":1,"d":"100%"}}]
[null,"Asiakirjat",{"$f":"TODAY()+55","v":"2013-02-04"},{"v":150,"d":"€150.00"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[% valmiina]]","v":{"v":0,"d":"0%"}},"Aloita, kun tehtävä B on valmis"]
[null,"Jaettava materiaali",{"$f":"TODAY()+70","v":"2013-02-19"},{"v":330,"d":"€330.00"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[% valmiina]]","v":{"v":0.25,"d":"25%"}}]
[null,"Seuranta",{"$f":"TODAY()+90","v":"2013-03-11"},{"v":353,"d":"€353.00"},{"v":0.5,"d":"50%"},{"$f":"tblToDoList[[#This Row],[% valmiina]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Asetukset ja laskelmat","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Korostusasetukset"]
[null,"Alla olevat taulukot sisältävät avattavan Korosta tehtävät -luettelon asetukset ja laskelmat. Kaikki muutokset voivat johtaa virheisiin tai aiheuttaa tehtävien menetyksen."]
[null,"Ei korostusta",null,null,{"$f":"B5","v":"Ei korostusta"}]
[null,"Aikaväli:","Aloitus:","Lopetus:","Määräaika:"]
[null,"     Nykyinen viikko",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-12-10"},{"$f":"C7+6","v":"2012-12-16"},{"$f":"B7&\" [\"&TEXT(C7,\"p kkk\")&\" - \"&TEXT(D7,\"p kkk\")&\"]\"","v":"     Nykyinen viikko [p kkk - p kkk]"}]
[null,"     Nykyinen kuukausi",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-12-01"},{"$f":"EDATE(C8,1)-1","v":"2012-12-31"},{"$f":"B8&\" [\"&TEXT(C8,\"p\")&\" - \"&TEXT(D8,\"p, kkk\")&\"]\"","v":"     Nykyinen kuukausi [p - p, kkk]"}]
[null,"     Nykyinen neljännes",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-05-01"},{"$f":"EDATE(C9,4)-1","v":"2012-08-31"},{"$f":"B9&\" [\"&TEXT(C9,\"p kkk\")&\" - \"&TEXT(D9,\"p kkk\")&\"]\"","v":"     Nykyinen neljännes [p kkk - p kkk]"}]
[null,"     Nykyinen vuosi",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"vvvv\")&\"]\"","v":"     Nykyinen vuosi [vvvv]"}]
[null,"Aikaväli:",null,null,{"$f":"B11","v":"Aikaväli:"}]
[null,"     Edellinen viikko",{"$f":"C7-7","v":"2012-12-03"},{"$f":"C12+6","v":"2012-12-09"},{"$f":"B12&\" [\"&TEXT(C12,\"p kkk\")&\" - \"&TEXT(D12,\"p kkk\")&\"]\"","v":"     Edellinen viikko [p kkk - p kkk]"}]
[null,"     Edellinen kuukausi",{"$f":"EDATE(C8,-1)","v":"2012-11-01"},{"$f":"EDATE(C13,1)-1","v":"2012-11-30"},{"$f":"B13&\" [\"&TEXT(C13,\"p\")&\" - \"&TEXT(D13,\"p kkk\")&\"]\"","v":"     Edellinen kuukausi [p - p kkk]"}]
[null,"     Edellinen neljännes ",{"$f":"EDATE(C9,-3)","v":"2012-02-01"},{"$f":"EDATE(C14,3)-1","v":"2012-04-30"},{"$f":"B14&\" [\"&TEXT(C14,\"p kkk\")&\" - \"&TEXT(D14,\"p kkk\")&\"]\"","v":"     Edellinen neljännes  [p kkk - p kkk]"}]
[null,"     Edellinen vuosi",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     Edellinen vuosi"}]
[]
[null,"Valittu korostus:",{"$f":"IFERROR(MATCH(HighlightActivities,lstToDoHighlights,0),\"\")-1","v":{"$error":"#VALUE!"}},{"$f":"HighlightActivities","v":"     Tällä viikolla [18  Kesä - 24  Kesä]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Korosta aloitus",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Korosta lopetus",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]