{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Projektien yleiskuvaus","Tehtävän tiedot"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Projektien yleiskuvaus","index":0,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Projektien yleiskuvaus"]
[]
[null,"Projekti","  ","Eteneminen"," Alkaa"," Päättyy","Huomautukset"]
[null,"Lomasuunnitelma",{"$f":"IFERROR((SUMIFS(Tasks[Valmis],Tasks[Projekti],Projects[[#This Row],[Projekti]])/COUNTIFS(Tasks[Projekti],Projects[[#This Row],[Projekti]]))+0.0001,0.0001)","v":0.50009999999999999},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"2011-10-01"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"2011-12-31"},"Lähdemme Belizeen!"]
[null,"Suunnitele Saran yllätysjuhlat",{"$f":"IFERROR((SUMIFS(Tasks[Valmis],Tasks[Projekti],Projects[[#This Row],[Projekti]])/COUNTIFS(Tasks[Projekti],Projects[[#This Row],[Projekti]]))+0.0001,0.0001)","v":1.0001},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"2011-09-10"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"2011-10-03"}]
[null,"Harjoittele maratonia varten",{"$f":"IFERROR((SUMIFS(Tasks[Valmis],Tasks[Projekti],Projects[[#This Row],[Projekti]])/COUNTIFS(Tasks[Projekti],Projects[[#This Row],[Projekti]]))+0.0001,0.0001)","v":0.28581428571428569},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"2011-09-01"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"2012-04-18"},"Ennätyksen rikkominen 18.4. päivä"]
[null,"Ilmoita Sara uimakouluun",{"$f":"IFERROR((SUMIFS(Tasks[Valmis],Tasks[Projekti],Projects[[#This Row],[Projekti]])/COUNTIFS(Tasks[Projekti],Projects[[#This Row],[Projekti]]))+0.0001,0.0001)","v":1E-4},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"2011-10-01"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"2011-10-15"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,null,{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,null,{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,null,{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,null,{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,null,{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,null,{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,null,{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,null,{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,null,{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]
[null,null,null,null,{"$f":"MIN(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[Alku]))","v":"00:00:00"},{"$f":"MAX(IF((Tasks[Projekti]=Projects[[#This Row],[Projekti]])*(Tasks[Alku]>0),Tasks[[Alku]:[Loppu]]))","v":"00:00:00"}]

{"sheet":"Tehtävän tiedot","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Tehtävän tiedot"]
[]
[null,"Alku","Loppu","Projekti","Tehtävä","Valmis","Huomautukset"]
[null,"2011-10-01","2011-10-15","Lomasuunnitelma","Valitse trooppisen ja lauhkean välillä",1,"Valitsin trooppisen. Belize, täältä tullaan!"]
[null,"2011-10-15","2011-12-31","Lomasuunnitelma","Seuraa kevään lentolippujen hintoja verkossa"]
[null,"2011-10-15",null,"Lomasuunnitelma","Tutustu Belizen historiaan ja kulttuuriin"]
[null,"2011-10-15","2011-10-20","Lomasuunnitelma","Lue arvosteluja kohteesta",1]
[null,"2011-10-20",null,"Lomasuunnitelma","Tee hotellivaraus",1,"19.4.­ - 30.4."]
[null,"2011-10-20","2011-11-15","Lomasuunnitelma","Hanki passit koko perheelle",null,"Harkitse pikapassia..."]
[null,"2011-09-01","2011-09-30","Harjoittele maratonia varten","16 kilometriä päivässä",1,"Kisa alkaa 18. huhtikuuta"]
[null,"2011-10-01","2011-10-31","Harjoittele maratonia varten","20 kilometriä päivässä",1]
[null,"2011-11-01","2011-11-30","Harjoittele maratonia varten","22,5 kilometriä päivässä"]
[null,"2011-12-01","2012-04-15","Harjoittele maratonia varten","24 kilometriä päivässä"]
[null,"2012-04-16",null,"Harjoittele maratonia varten","Matkusta kisapaikkaan"]
[null,"2012-04-16","2012-04-17","Harjoittele maratonia varten","Tarkasta kurssi",null,"16 kilometrin hölkkä joka päivä"]
[null,"2012-04-18",null,"Harjoittele maratonia varten","Saavu maaliin alle kolmessa tunnissa!",null,"Matkusta Belizeen!"]
[null,"2011-09-10",null,"Suunnitele Saran yllätysjuhlat","Lähetä juhlakutsuja",1,"Yllätyssyntymäpäiväjuhlat 3.10."]
[null,"2011-09-20",null,"Suunnitele Saran yllätysjuhlat","Tilaa pitopalvelu",1]
[null,"2011-09-22",null,"Suunnitele Saran yllätysjuhlat","Varaa viihdykettä",1]
[null,"2011-10-03",null,"Suunnitele Saran yllätysjuhlat","Juhlapäivä!",1,"Se oli mahtavaa! Hän ei aavistanut mitään!"]
[null,"2011-10-01","2011-10-15","Ilmoita Sara uimakouluun","Compare local area community center prices"]