{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Zadania do wykonania projektu 1","Ustawienia i obliczenia"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Zadania do wykonania projektu 1","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Lista zadań do wykonania w projekcie"]
[]
[null,"Do wykonania przez:",null,null,"Termin:",null,"Działania dot. wydarzenia"]
[null,"Tomasz Bator",null,null,{"$f":"TODAY()+95","v":"2012-12-02"},null," Ten tydzień [18 czerwiec - 24 czerwiec]"]
[]
[null,"Projekt 1"]
[null,"Działanie","Termin wykonania","Budżet","% wykonania","Postęp","Uwagi"," "]
[null,"Planowanie",{"$f":"TODAY()-90","v":"2012-05-31"},{"v":476,"d":"476.00 zł"},{"v":0.25,"d":"25%"},{"$f":"'Zadania do wykonania projektu 1'!$E10","v":{"v":0.25,"d":"25%"}}]
[null,"Przygotowywanie",{"$f":"TODAY()-2","v":"2012-08-27"},{"v":301,"d":"301.00 zł"},{"v":0.1,"d":"10%"},{"$f":"'Zadania do wykonania projektu 1'!$E11","v":{"v":0.1,"d":"10%"}}]
[null,"Zadanie A",{"$f":"TODAY()-7","v":"2012-08-22"},{"v":429,"d":"429.00 zł"},{"v":0,"d":"0%"},{"$f":"'Zadania do wykonania projektu 1'!$E12","v":{"v":0,"d":"0%"}}]
[null,"Zadanie B",{"$f":"TODAY()+20","v":"2012-09-18"},{"v":332,"d":"332.00 zł"},{"v":0.7,"d":"70%"},{"$f":"'Zadania do wykonania projektu 1'!$E13","v":{"v":0.7,"d":"70%"}}]
[null,"Zadanie C",{"$f":"TODAY()+40","v":"2012-10-08"},{"v":471,"d":"471.00 zł"},{"v":0.1,"d":"10%"},{"$f":"'Zadania do wykonania projektu 1'!$E14","v":{"v":0.1,"d":"10%"}}]
[null,"Zadanie D",{"$f":"TODAY()+45","v":"2012-10-13"},{"v":418,"d":"418.00 zł"},{"v":1,"d":"100%"},{"$f":"'Zadania do wykonania projektu 1'!$E15","v":{"v":1,"d":"100%"}}]
[null,"Dokumentacja",{"$f":"TODAY()+55","v":"2012-10-23"},{"v":150,"d":"150.00 zł"},{"v":0,"d":"0%"},{"$f":"'Zadania do wykonania projektu 1'!$E16","v":{"v":0,"d":"0%"}},"Zacząć po wykonaniu zadania B"]
[null,"Oddanie",{"$f":"TODAY()+70","v":"2012-11-07"},{"v":330,"d":"330.00 zł"},{"v":0.25,"d":"25%"},{"$f":"'Zadania do wykonania projektu 1'!$E17","v":{"v":0.25,"d":"25%"}}]
[null,"Monit",{"$f":"TODAY()+90","v":"2012-11-27"},{"v":353,"d":"353.00 zł"},{"v":0.5,"d":"50%"},{"$f":"'Zadania do wykonania projektu 1'!$E18","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Ustawienia i obliczenia","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Ustawienia wydarzenia"]
[null,"W poniższych tabelach są przechowywane ustawienia i obliczenia dla listy rozwijanej działań dotyczących najważniejszego wydarzenia.\nJakiekolwiek zmiany mogą spowodować błędy lub utratę funkcjonalności."]
[null,"Brak wydarzeń",null,null,{"$f":"B5","v":"Brak wydarzeń"}]
[null,"Interwał:","Rozpoczęcie:","Zakończenie:","Termin:"]
[null," Ten tydzień",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-08-27"},{"$f":"C7+6","v":"2012-09-02"},{"$f":"B7&\" [\"&TEXT(C7,\"d mmm\")&\" - \"&TEXT(D7,\"d mmm\")&\"]\"","v":" Ten tydzień [27 sie - 2 wrz]"}]
[null," Ten miesiąc",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-08-01"},{"$f":"EDATE(C8,1)-1","v":"2012-08-31"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"d, mmm\")&\"]\"","v":" Ten miesiąc [1 - 31, sie]"}]
[null," Ten kwartał",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-03-01"},{"$f":"EDATE(C9,4)-1","v":"2012-06-30"},{"$f":"B9&\" [\"&TEXT(C9,\"d mmm\")&\" - \"&TEXT(D9,\"d mmm\")&\"]\"","v":" Ten kwartał [1 mar - 30 cze]"}]
[null," Ten rok",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"rrrr\")&\"]\"","v":" Ten rok [2012]"}]
[null,"Interwał:",null,null,{"$f":"B11","v":"Interwał:"}]
[null," Poprzedni tydzień",{"$f":"C7-7","v":"2012-08-20"},{"$f":"C12+6","v":"2012-08-26"},{"$f":"B12&\" [\"&TEXT(C12,\"d mmm\")&\" - \"&TEXT(D12,\"d mmm\")&\"]\"","v":" Poprzedni tydzień [20 sie - 26 sie]"}]
[null," Poprzedni miesiąc",{"$f":"EDATE(C8,-1)","v":"2012-07-01"},{"$f":"EDATE(C13,1)-1","v":"2012-07-31"},{"$f":"B13&\" [\"&TEXT(C13,\"d\")&\" - \"&TEXT(D13,\"d, mmm\")&\"]\"","v":" Poprzedni miesiąc [1 - 31, lip]"}]
[null," Poprzedni kwartał",{"$f":"EDATE(C9,-3)","v":"2011-12-01"},{"$f":"EDATE(C14,3)-1","v":"2012-02-29"},{"$f":"B14&\" [\"&TEXT(C14,\"d mmm\")&\" - \"&TEXT(D14,\"d mmm\")&\"]\"","v":" Poprzedni kwartał [1 gru - 29 lut]"}]
[null," Poprzedni rok",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":" Poprzedni rok"}]
[]
[null,"Wybrane wydarzenie:",{"$f":"IFERROR(MATCH(Działania_dot._najważniejszego_wydarzenia,lst_Zadania_do_wykonania_Najważniejsze_wydarzenia,0),\"\")","v":""},{"$f":"Działania_dot._najważniejszego_wydarzenia","v":" Ten tydzień [18 czerwiec - 24 czerwiec]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Rozpoczęcie wydarzenia",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Zakończenie wydarzenia",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]