{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gantt","Około"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Gantt","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[1,8,1,11],[1,13,1,16],[1,18,1,21],[1,23,1,26],[1,28,1,31],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,1,4,7]]}
["W tym arkuszu utwórz wykres Gantta.\nWprowadź tytuł tego projektu w komórce B1. \nTytuł legendy znajduje się w komórce I1.\nW arkuszu Informacje podano informacje dotyczące sposobu używania tego arkusza, w tym instrukcje dla czytników zawartości ekranu oraz informacje o autorze tego skoroszytu.\nAby zapoznać się z dodatkowymi instrukcjami, przechodź w dół kolumny A.","TYTUŁ PROJEKTU",{"$nulls":6},"Legenda:"]
["W komórce B2 wprowadź nazwę firmy.\nLegenda znajduje się w komórkach od I2 do AC2.","Nazwa firmy",{"$nulls":6},"Zgodnie z planem",{"$nulls":4},"Niskie ryzyko",{"$nulls":4},"Średnie ryzyko",{"$nulls":4},"Wysokie ryzyko",{"$nulls":4},"Nieprzypisane"]
["W komórce B3 wprowadź nazwę kierownika projektu. Wprowadź datę rozpoczęcia projektu w komórce F3 lub za pomocą prostej formuły znajdź najmniejszą wartość daty z tabeli danych wykresu Gantta.  \nData rozpoczęcia projektu: etykieta znajduje się w komórce D3.","Kierownik projektu",null,"Data rozpoczęcia projektu:",null,{"$f":"IFERROR(IF(MIN(Punkty_kontrolne[Start])=0,TODAY(),MIN(Punkty_kontrolne[Start])),TODAY())","v":"2018-07-07"}]
["Przewijanie przyrostu znajduje się w komórce F4. \nMiesiące dla dat w wierszu 5 są wyświetlane w komórkach od I4 do BL4.\nNie modyfikuj tych komórek. Są one automatycznie aktualizowane na podstawie daty rozpoczęcia projektu w komórce F3.",null,null,"Przewijanie przyrostu:",null,0,null,null,{"$f":"TEXT(I5,\"mmmm\")","v":"lipiec"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"mmmm\")=I4,\"\",TEXT(P5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"mmmm\")=P4,TEXT(W5,\"mmmm\")=I4),\"\",TEXT(W5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"mmmm\")=W4,TEXT(AD5,\"mmmm\")=P4,TEXT(AD5,\"mmmm\")=I4),\"\",TEXT(AD5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"mmmm\")=AD4,TEXT(AK5,\"mmmm\")=W4,TEXT(AK5,\"mmmm\")=P4,TEXT(AK5,\"mmmm\")=I4),\"\",TEXT(AK5,\"mmmm\"))","v":"sierpień"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"mmmm\")=AK4,TEXT(AR5,\"mmmm\")=AD4,TEXT(AR5,\"mmmm\")=W4,TEXT(AR5,\"mmmm\")=P4),\"\",TEXT(AR5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"mmmm\")=AR4,TEXT(AY5,\"mmmm\")=AK4,TEXT(AY5,\"mmmm\")=AD4,TEXT(AY5,\"mmmm\")=W4),\"\",TEXT(AY5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"mmmm\")=AY4,TEXT(BF5,\"mmmm\")=AR4,TEXT(BF5,\"mmmm\")=AK4,TEXT(BF5,\"mmmm\")=AD4),\"\",TEXT(BF5,\"mmmm\"))","v":""}]
["Komórki od I5 do BL5 zawierają numer dnia miesiąca w miesiącu przedstawionym w bloku komórki nad każdą komórką daty i są obliczane automatycznie.\nNie modyfikuj tych komórek.\nDzisiejsza data jest wyróżniona czerwonym kolorem (szesnastkowo: #AD3815) od dzisiejszej daty w wierszu 5 przez całą kolumnę Data do końcu harmonogramu projektu.",{"$nulls":7},{"$f":"IFERROR(Projekt_start+Przewijanie_przyrostu,TODAY())","v":"2018-07-07"},{"$f":"I5+1","v":"2018-07-08"},{"$f":"J5+1","v":"2018-07-09"},"2018-07-10","2018-07-11","2018-07-12","2018-07-13",{"$f":"O5+1","v":"2018-07-14"},{"$f":"P5+1","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20",{"$f":"V5+1","v":"2018-07-21"},{"$f":"W5+1","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27",{"$f":"AC5+1","v":"2018-07-28"},{"$f":"AD5+1","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03",{"$f":"AJ5+1","v":"2018-08-04"},{"$f":"AK5+1","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10",{"$f":"AQ5+1","v":"2018-08-11"},{"$f":"AR5+1","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17",{"$f":"AX5+1","v":"2018-08-18"},{"$f":"AY5+1","v":"2018-08-19"},{"$f":"AZ5+1","v":"2018-08-20"},"2018-08-21","2018-08-22","2018-08-23","2018-08-24",{"$f":"BE5+1","v":"2018-08-25"},{"$f":"BF5+1","v":"2018-08-26"},{"$f":"BG5+1","v":"2018-08-27"},"2018-08-28","2018-08-29","2018-08-30","2018-08-31"]
["Pasek przewijania znajduje się w komórkach od I6 do BL6. Przyrost dla stronicowania danych jest zdefiniowany dla 2 stron naraz i można go skonfigurować w ustawieniach paska sterowania. \nAby przejść do przodu lub do tyłu na osi czasu, w komórce F4 wprowadź wartość 0 lub wyższą.\nWartość 0 spowoduje przejście na początek wykresu."]
["Ten wiersz zawiera nagłówki dla harmonogramu projektu, który znajduje się poniżej nich. \nPrzejdź do komórek od B7 do BL7, aby zapoznać się z tą zawartością. Pierwsza litera każdego dnia tygodnia dla daty podanej powyżej tego nagłówka rozpoczyna się od komórki I7 i ciągnie się do BL7.\nWszystkie wykresy osi czasu projektu są generowane automatycznie na podstawie kategorii, daty rozpoczęcia oraz liczby dni wprowadzonych w tabeli Punkty kontrolne.","Opis punktu kontrolnego","Kategoria","Przypisane do","Postęp","Start","Liczba dni",null,{"$f":"LEFT(TEXT(I5,\"ddd\"),1)","v":"s"},{"$f":"LEFT(TEXT(J5,\"ddd\"),1)","v":"n"},"p","w","ś","c","p","s","n","p","w","ś","c","p","s","n","p","w","ś","c","p","s","n","p","w","ś","c","p","s","n","p","w","ś","c","p","s",{"$f":"LEFT(TEXT(AS5,\"ddd\"),1)","v":"n"},"p","w","ś","c","p","s","n","p","w","ś","c","p","s","n","p","w","ś","c","p"]
["Nie usuwaj tego wiersza. Ten wiersz jest ukryty w celu zachowania formuły, która jest używana do wyróżniania bieżącego dnia w harmonogramie projektu. "]
["Wprowadź informacje o projekcie, począwszy od komórki B9 do komórki G9. \nPrzykładowe dane znajdują się w komórkach od B9 do G33.\nAby rozpocząć tworzenie wykresów, wprowadź opis punku kontrolnego, wybierz kategorię na liście rozwijanej, przypisz osobę do danego elementu, wprowadź postęp, datę rozpoczęcia oraz liczbę dni dla tego zadania.\nDalsze instrukcje znajdują się w komórce A34.","Tytuł 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Cel\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Punkt kontrolny\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Cel\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Punkt kontrolny\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Cel\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Punkt kontrolny\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Cel\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Punkt kontrolny\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Zadanie 1","Cel","Imię i nazwisko",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-07-29"},3,null,{"$f":"IF(AND($C10=\"Cel\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Punkt kontrolny\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 2","Punkt kontrolny",null,null,{"$f":"TODAY()+5","v":"2019-08-03"},1,null,{"$f":"IF(AND($C11=\"Cel\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Punkt kontrolny\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 3","Niskie ryzyko",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-07-26"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 4","Punkt kontrolny",null,null,{"$f":"F10+20","v":"2019-08-18"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 5","Średnie ryzyko",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-08-04"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tytuł 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 1","Wysokie ryzyko",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-08-04"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 2","Zgodnie z planem",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-08-06"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 3","Niskie ryzyko",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-08-11"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 4","Punkt kontrolny",null,null,{"$f":"F18+2","v":"2019-08-13"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 5",{"$nulls":3},{"$f":"F19+1","v":"2019-08-14"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tytuł 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 1","Zgodnie z planem",null,null,{"$f":"F10+15","v":"2019-08-13"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 2","Średnie ryzyko",null,null,{"$f":"F22+3","v":"2019-08-16"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 3","Zgodnie z planem",null,null,{"$f":"F23+15","v":"2019-08-31"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Cel\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"Punkt kontrolny\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Cel\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"Punkt kontrolny\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Zadanie 4","Cel",null,null,{"$f":"F19+22","v":"2019-09-04"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"Cel\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"Punkt kontrolny\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 5","Niskie ryzyko",null,null,{"$f":"F14","v":"2019-08-04"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tytuł 4",{"$nulls":6},{"$f":"IF(AND($C27=\"Cel\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"Punkt kontrolny\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 1",{"$nulls":3},{"$f":"F25+3","v":"2019-09-07"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 3","Punkt kontrolny",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zadanie 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["To jest pusty wiersz",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Ten wiersz oznacza koniec danych punktu kontrolnego wykresu Gantta. NIE wprowadzaj niczego w tym wierszu. \nAby dodać więcej elementów, wstaw nowe wiersze powyżej tego.","Aby dodać więcej danych, wstaw nowe wiersze POWYŻEJ tego."]

{"sheet":"Około","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["Informacje o tym szablonie"]
["Ten szablon zapewnia prosty sposób tworzenia wykresu Gantta w celu ułatwienia wizualizacji i śledzenia projektu. Po prostu wprowadź opis zadań, wybierz kategorię Cel, Punkt kontrolny, Niskie ryzyko, Średnie ryzyko, Wysokie ryzyko, Postęp jako wartość procentową wykonania zadania, a także datę rozpoczęcia oraz liczbę dni, aby ukończyć zadanie. Wykres Gantta wypełni się i jest oznaczony kolorami, aby ułatwić odróżnienie poszczególnych kategorii. Pasek przewijania pozwala przewijać oś czasu. Wstaw nowe zadania przez wstawianie nowych wierszy.\n"]
["Przewodnik dotyczący czytników zawartości ekranu"]
["W tym skoroszycie znajdują się 2 arkusze. \n\nWykres Gantta\nOkoło\n\nInstrukcje dotyczące każdego arkusza znajdują się w kolumnie A (zaczynają się od komórki A1). Ich tekst jest ukryty. Każdy krok prowadzi Cię przez informacje w danym wierszu. Kolejne kroki podane są w komórkach A2, A3 i tak dalej, chyba że wyraźnie stwierdzono inaczej. Na przykład tekst instrukcji może brzmieć „aby wykonać następny krok, przejdź do komórki A6”. \n\nTen tekst ukryty nie zostanie wydrukowany.\n\nAby usunąć te instrukcje z arkusza, po prostu usuń kolumnę A."]
["Jest to ostatnia instrukcja w tym arkuszu."]