{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["wykład 13","Dane","Zadania","Zadania (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"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":"wykład 13","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Wykład 13"]
[null,"- Przykłady zadań na 3 kolokwium."]
[null,"- Tablice i funkcje tablicowe."]

{"sheet":"Dane","index":1,"n_rows":178,"n_cols":21,"rows_kept":178,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Lp.","Nazwisko","Imie","Data Urodzenia","Miejsce Urodzenia","Miejscowość Zameldowania","Ulica Zameldowania","Numer Domu","Numer Mieszkania","Dzieci","Język","Data Zatrudnienia","Dział","Stanowisko","Dochód  Roczny","PZU"]
[null,1,"Kowalska","Kamila","1968-03-25","Szczecin","Bydgoszcz","Szafera","2B",2,1,null,"1989-11-24","produkcja","krawcowa",64000,null,null,{"$f":"zlicz(Miejscowość_Zameldowania,\"Bydgoszcz\",Język,\"niemiecki\")","v":7}]
[null,2,"Dziuba","Bożena","1976-04-23","Bolesławiec","Biała Podlaska","Seledynowa",70,4,3,"niemiecki","1997-06-06","kadry","referent",49840,"nie"]
[null,3,"Lipka","Magdalena","1965-02-28","Pyrzyce","Piotrowice","Mazurska",4,5,3,"angielski","1989-06-29","transport","kierowca",38460,"nie",null,"Bożena","Dziuba",49840]
[null,4,"Wiśniewska","Grażyna","1983-04-07","Chełmża","Bydgoszcz","Piastów",16,11,6,"hiszpański","2005-08-07","kadry","referent",34664,null,null,"Mikołaj","Leszczyk",76520]
[null,5,"Skrzypczak","Jadwiga","1967-07-01","Barlinek","Cedynia","Orzeszkowej","29b",4,1,null,"1987-09-02","produkcja","prasowacz",22620,null,null,"Jan","Kruszewski",35100]
[null,6,"Dragon","Józef","1972-11-19","Białogard","Cedynia","Bogusława",25,25,6,null,"1995-03-17","kadry","księgowa",22000,null,null,"Cezary","Gruca",22500]
[null,7,"Leszczyk","Mikołaj","1966-07-15","Szczecin","Chełm","Narutowicza","30 E",5,1,"niemiecki","1991-01-04","zaopatrzenie","zaopatrzeniowiec",76520,null,null,"Janusz","Szymczak",72576]
[null,8,"Paluch","Krystyna","1968-10-19","Choszczno","Biała Podlaska","Leg.Dąbrowskiego",18,13,1,"angielski","1988-07-07","kadry","referent",17840,"nie",null,"Cecylia","Bogucewicz",22800]
[null,9,"Kupś","Piotr","1972-08-27","Szczecin","Chełm","Kard.Stef.Wyszyńskiego",10,35,5,null,"1996-02-17","produkcja","prasowacz",97704,null,null,"Czesław","Filipczyk",52600]
[null,10,"Sadowski","Piotr","1976-05-10","Szczecin","Chełm","Boczna",5,8,6,null,"1998-03-26","produkcja","wykrawacz",24080,"nie",null,"Paulina","Futerska",52600]
[null,11,"Kruszewski","Jan","1975-11-20","Warszawa","Piotrowice","26-go Kwietnia",11,1,2,"niemiecki","2002-06-07","transport","dyspozytor",35100,null,null,"Paweł","Wojciechowski",22800]
[null,12,"Filipek","Teresa","1981-02-28","Szczecin","Bydgoszcz","Krzywoustego",16,9,0,"angielski","2006-12-18","produkcja","krawcowa",56696,"nie",null,"Grażyna","Gajewska ",28800]
[null,13,"Bugalska","Ewa","1989-03-31","Bydgoszcz","Banie","Kaliny",12,28,3,"angielski","2012-01-18","transport","kierowca",38460,"nie",null,"Ryszard","Ligocki",15420]
[null,14,"Szafko","Radosław","1987-12-14","Szczecin","Chełm","Szeli","5b",5,1,null,"2012-12-17","produkcja","wykrawacz",22620,null,null,"Ewa","Jagielska",58600]
[null,15,"Kacprzyk","Dominika","1973-07-27","Brodnica","Biała Podlaska","Sportowa",4,3,1,"angielski","1999-12-24","kadry","referent",12660,null,null,"Agnieszka","Andrzejczak",26790]
[null,16,"Twardowski","Czesław","1989-08-02","Szczecin","Brodnica","Gdańska",15,8,0,"angielski","2012-03-23","kadry","księgowa",27892,null,null,"Feliks","Banasiak",56920]
[null,17,"Kresa","Krystyna","1966-07-26","Białystok","Cedynia","Dunikowskiego",37,2,0,"angielski","1986-12-23","kadry","księgowa",31000,null,null,"Jan","Szymański",36480]
[null,18,"Kupś","Piotr","1968-08-20","Szczecin","Chełm","Wilcza",8,8,2,"hiszpański","1989-03-11","produkcja","wykrawacz",23600,null,null,"Hanna","Kustroń",36480]
[null,19,"Rondzisty","Marcin","1985-05-16","Szczecin","Brodnica","Wodna",45,50,0,"francuski","2007-05-06","kadry","księgowa",13296,null,null,"Grzegorz","Gruca",26790]
[null,20,"Gruca","Cezary","1984-11-10","Chojna","Banie","Krzywoustego","1D",3,5,"niemiecki","2009-03-23","transport","kierowca",22500,null,null,"Jan","Nowak",72576]
[null,21,"Paluch","Edward","1971-08-02","Człuchów","Banie","B.Chrobrego",4,9,3,"angielski","1998-06-03","transport","kierowca",24012,null,null,"Piotr","Engel",56920]
[null,22,"Szymczak","Janusz","1968-01-04","Cedynia","Bydgoszcz","Janickiego",16,1,6,"niemiecki","1992-12-28","kadry","referent",72576,"nie",null,"Lucyna","Krajewska",42160]
[null,23,"Koszel","Anna","1981-09-25","Stargard Szczeciński","Piotrowice","Piaskowa",66,3,3,"angielski","2005-08-30","produkcja","wykrawacz",22480,null,null,"Jolanta","Szkudlarek",52220]
[null,24,"Samborska","Małgorzata","1974-01-28","Chojnice","Biała Podlaska","Pomorska",110,403,0,"angielski","1999-03-17","produkcja","prasowacz",56696,"nie",null,"Aneta","Długosz",28800]
[null,25,"Wierzbicki","Piotr","1968-05-14","Szczecin","Chełm","Kostki Napierskiego",4,7,2,"hiszpański","1995-07-14","produkcja","wykrawacz",65340,null,null,"Justyna","Gad",49840]
[null,26,"Osowska","Maria","1968-09-01","Banie","Banie","Włościańska",35,4,0,"angielski","1990-03-22","transport","dyspozytor",32484,"nie",null,"Kamila","Karczewska",15420]
[null,27,"Bogucewicz","Cecylia","1973-08-02","Bydgoszcz","Bydgoszcz","Bułgarska","14a",3,0,"niemiecki","1997-08-02","produkcja","wykrawacz",22800,"nie",null,"Agata","Tokarczuk",58600]
[null,28,"Filipczyk","Czesław","1979-03-30","Chociwel","Biała Podlaska","Powstańców Wlkp.",5,9,1,"niemiecki","1999-04-29","produkcja","prasowacz",52600,null,null,"Aleksander","Banaszak",35100]
[null,29,"Chojnacka","Edyta","1975-03-04","Chełm","Biała Podlaska","Glazurowa",5,2,6,"angielski","1997-07-15","kadry","referent",28846,"nie",null,"Jan","Kowalski",42160]
[null,30,"Ejsmont","Barbara","1972-05-11","Chojna","Biała Podlaska","Dąbrówki",5,3,1,"francuski","1997-11-09","kadry","referent",26400,"nie",null,"Jan","Kowalski",22500]
[null,31,"Futerska","Paulina","1969-04-01","Szczecin","Chełm","Śląska",24,57,1,"niemiecki","1993-02-04","produkcja","prasowacz",52600,null,null,"Joanna","Radoszewska",76520]
[null,32,"Nitecka","Jolanta","1987-05-13","Chojna","Banie","E.Gierczak",21,15,5,"francuski","2011-04-29","produkcja","krawcowa",15280,null,null,"Wojciech","Góralczyk",52220]
[null,33,"Janowska","Maria","1967-11-29","Szczecin","Chojna","Gdańska",31,11,4,"angielski","1990-10-28","kadry","referent",40280]
[null,34,"Taukin","Katarzyna","1978-07-19","Szczecin","Brodnica","Szczanieckiej",3,3,1,"hiszpański","2004-11-11","magazyn","magazynier",24400,"nie"]
[null,35,"Wojtyła","Joanna","1979-03-01","Piaski","Piaski","Wrońskiego",1,null,2,null,"1999-11-12","produkcja","wykrawacz",9100,"nie"]
[null,36,"Rudnicka ","Halina","1968-11-13","Lubanowo","Świdnik","Armii Krajowej",71,2,3,"hiszpański","1995-08-01","produkcja","krawcowa",36486,"nie"]
[null,37,"Rybak","Piotr","1989-05-06","Cedynia","Banie","Chobolańska",17,1,0,null,"2014-11-20","produkcja","krawcowa",29544]
[null,38,"Runowicz","Wojciech","1989-08-13","Szczecin","Chełm","Narutowicza",58,3,1,"angielski","2014-10-17","kadry","referent",12660]
[null,39,"Lewandowicz","Agnieszka","1980-12-27","Szczecin","Bydgoszcz","Energetyka",26,1,3,null,"2004-05-20","produkcja","krawcowa",28716]
[null,40,"Wójcicki","Kamil","1979-03-19","Szczecin","Chojna","Nehringa",25,4,1,null,"2003-04-11","kadry","referent",8836]
[null,41,"Wojciechowski","Paweł","1966-03-10","Szczecin","Chełm","Narutowicza","22B",5,0,"niemiecki","1987-01-06","produkcja","prasowacz",22800,"nie"]
[null,42,"Długosz","Ludwik","1974-06-25","Cedynia","Cedynia","Motorowa",1,22,2,null,"1999-05-01","produkcja","prasowacz",58012]
[null,43,"Wojtas","Ewelina","1981-11-26","Resko","Świdnik","Armii Krajowej","2A",8,0,"angielski","2002-01-04","transport","kierowca",32484,"nie"]
[null,44,"Dańczura","Paweł","1968-04-10","Szczecin","Chełm","Krzywoustego",37,8,3,"angielski","1989-08-15","produkcja","prasowacz",11330]
[null,45,"Gajewska ","Grażyna","1969-03-27","Szczecin","Brodnica","Piechoty",45,2,5,"niemiecki","1992-03-25","magazyn","magazynier",28800,"nie"]
[null,46,"Bugalski","Leszek","1987-05-09","Barlinek","Bydgoszcz","Strzałowska",48,14,1,"angielski","2007-02-02","zaopatrzenie","zaopatrzeniowiec",26400,"nie"]
[null,47,"Rokita","Stanisław","1987-08-31","Czarnkow","Bydgoszcz","Malczewskiego",2,4,6,null,"2007-07-30","produkcja","wykrawacz",24080,"nie"]
[null,48,"Borkowski ","Stanisław","1977-09-09","Szczecin","Bydgoszcz","Wiosny Ludów",67,9,4,"angielski","2002-03-15","produkcja","krawcowa",15522]
[null,49,"Ligocki","Ryszard","1966-04-28","Choszczno","Bydgoszcz","Rymarska",67,4,3,"niemiecki","1987-12-14","produkcja","wykrawacz",15420]
[null,50,"Ostrowska","Ewa","1975-09-24","Szczecin","Brodnica","Dąbrówki",19,11,1,null,"2000-03-30","magazyn","magazynier",53400]
[null,51,"Jagielska","Ewa","1968-03-16","Szczecin","Chojna","Boh.Getta Warszawy",6,3,4,"niemiecki","1990-04-25","kadry","referent",58600]
[null,52,"Cieślak","Małgorzata","1979-12-30","Szczecin","Chełm","Dunikowskiego",15,2,1,"angielski","2004-03-31","produkcja","prasowacz",26400,"nie"]
[null,53,"Andrzejczak","Agnieszka","1971-07-30","Szczecin","Chojna","Krzywoustego",20,8,0,"niemiecki","1996-11-15","kadry","referent",26790,"nie"]
[null,54,"Biedrzycki","Zbigniew","1970-08-02","Boguszów","Biała Podlaska","Al.Piastów",59,null,2,"francuski","1993-02-13","kadry","referent",20484]
[null,55,"Banasiak","Feliks","1965-10-26","Choszczno","Banie","Chopina",4,50,2,"niemiecki","1991-01-07","produkcja","krawcowa",56920]
[null,56,"Taukin","Karina","1968-06-17","Szczecin","Chełm","Małkowskiego",26,7,0,null,"1994-06-26","produkcja","prasowacz",29544]
[null,57,"Gruca","Helena","1985-09-30","Chełmno","Biała Podlaska","Kościenna",6,1,2,"angielski","2008-08-14","kadry","referent",49120]
[null,58,"Cieślewicz","Magdalena","1972-07-06","Szczecin","Chojna","Krzywoustego",21,16,1,"francuski","1999-03-13","kadry","referent",26400,"nie"]
[null,59,"Bogusławski","Karol","1988-09-14","Szczecin","Bydgoszcz","Krzywoustego",55,2,4,"hiszpański","2010-07-26","produkcja","krawcowa",34860]
[null,60,"Henkelman","Agnieszka","1970-11-07","Świnoujście","Piotrowice","Roweckiego",106,7,2,"angielski","1991-09-11","transport","kierowca",29000]
[null,61,"Grabowski","Jacek","1990-11-11","Bogdaniec","Cedynia","1-go Maja",11,3,1,"angielski","2015-01-14","produkcja","krawcowa",45984]
[null,62,"Rudnicki","Józef","1990-03-10","Szczecin","Świdnik","Fabryczna",7,17,1,"francuski","2010-07-25","produkcja","wykrawacz",22600,"nie"]
[null,63,"Szymański","Jan","1979-02-01","Czerniakrobek","Banie","Ofiar Oświęcimia",16,24,2,"niemiecki","2005-07-18","produkcja","krawcowa",36480]
[null,64,"Kustroń","Hanna","1968-10-23","Szczecin","Bydgoszcz","Śląska",96,2,2,"niemiecki","1994-02-04","produkcja","krawcowa",36480]
[null,65,"Gruca","Grzegorz","1983-12-09","Kleszczele","Świdnik","Garbarska",2,17,0,"niemiecki","2006-11-15","kadry","referent",26790,"nie"]
[null,66,"Ołdakowska","Agnieszka","1965-02-10","Szczecin","Brodnica","Hoża",15,6,0,"angielski","1992-05-12","kadry","księgowa",31000]
[null,67,"Kacprzyk","Cecylia","1991-02-16","Warszawa","Świdnik","Armii Krajowej",10,2,3,"angielski","2013-08-05","produkcja","prasowacz",22480]
[null,68,"Nowak","Jan","1977-03-22","Szczecin","Chełm","Krzywoustego",33,1,6,"niemiecki","1998-05-12","kadry","referent",72576,"nie"]
[null,69,"Lipiński ","Leszek","1988-09-02","Szczecin","Bydgoszcz","Ziemowita",2,5,3,"hiszpański","2010-05-26","produkcja","krawcowa",36486,"nie"]
[null,70,"Andrzejczak","Helena","1973-03-15","Pyrzyce","Świdnik","Armii Krajowej",69,2,4,"angielski","1997-06-05","produkcja","krawcowa",15522]
[null,71,"Cichocki","Marian","1982-05-14","Czarnków","Biała Podlaska","Jarogniewa",10,5,4,"angielski","2007-08-11","kadry","referent",40280]
[null,72,"Wojciechowska","Ewa","1981-10-13","Chojna","Biała Podlaska","Piastów",59,null,4,"hiszpański","2005-04-04","produkcja","prasowacz",34860]
[null,73,"Engel","Piotr","1977-01-31","Szczecin","Chełm","Malczewskiego",59,3,2,"niemiecki","2000-11-14","produkcja","prasowacz",56920]
[null,74,"Niechcic","Tomasz","1969-07-16","Szczecin","Chełm","Warszawska","19b",2,3,"hiszpański","1994-08-06","kadry","referent",56548]
[null,75,"Krajewska","Lucyna","1981-05-02","Bylew","Cedynia","Pl.Lotników",3,3,1,"niemiecki","2006-02-19","produkcja","krawcowa",42160]
[null,76,"Kozłowska","Anna","1983-11-21","Szczecin","Chojna","Kaliny","23c",401,2,"angielski","2008-10-26","kadry","referent",49120]
[null,77,"Nowak","Przemysław","1974-04-25","Police","Piotrowice","Przyjaźni",15,7,3,"angielski","1999-09-29","transport","kierowca",24012]
[null,78,"Kuc","Bożena","1981-10-19","Szczecin","Brodnica","Śląska","14a",6,6,null,"2007-01-29","kadry","księgowa",22000]
[null,79,"Tymicz","Zenon","1964-09-22","Balinek","Cedynia","Czerwona",2,6,5,"angielski","1987-07-25","zaopatrzenie","magazynier",17800]
[null,80,"Rokita","Marta","1971-06-22","Szczecin","Brodnica","Gdańska",11,2,1,null,"1995-08-18","magazyn","magazynier",53400]
[null,81,"Szkudlarek","Jolanta","1984-12-14","Szczecin","Brodnica","Gryfińska",11,23,1,"niemiecki","2005-04-18","produkcja","krawcowa",52220]
[null,82,"Długosz","Aneta","1982-10-24","Bydgoszcz","Cedynia","Pomorska",38,1,5,"niemiecki","2010-01-20","magazyn","magazynier",28800,"nie"]
[null,83,"Banasiak","Agnieszka","1991-02-14","Choszczno","Biała Podlaska","Kruszcowa","22A",1,5,null,"2014-01-11","produkcja","prasowacz",97704]
[null,84,"Gad","Justyna","1990-06-14","Szczecin","Chojna","Al.Piastów",22,10,3,"niemiecki","2011-04-24","kadry","referent",49840,"nie"]
[null,85,"Karczewska","Kamila","1980-08-11","Szczecin","Bydgoszcz","Nehringa",21,61,3,"niemiecki","2002-02-03","produkcja","krawcowa",15420]
[null,86,"Kresa","Kazimierz","1968-10-24","Bratomierz","Banie","Bogusława",19,12,2,"angielski","1994-04-28","transport","kierowca",29000]
[null,87,"Wysocki","Rafał","1990-06-15","Burzenin","Bydgoszcz","Spółdzielcza",19,2,3,null,"2017-04-13","produkcja","wykrawacz",28716]
[null,88,"Łopata","Henryk","1977-10-28","Braniewo","Bydgoszcz","Dąbrówki",15,4,1,null,"2003-12-15","kadry","referent",7960]
[null,89,"Puchalski","Marian","1977-04-05","Charków","Biała Podlaska","Konstytucji 3-podoja",17,43,1,null,"1997-08-28","kadry","referent",8836]
[null,90,"Nowakowski","Marek","1972-04-20","Bierutów","Banie","Krasińskiego",62,9,1,"angielski","1993-02-17","produkcja","krawcowa",53500,"nie"]
[null,91,"Ołldakowska","Agnieszka","1984-09-03","Szczecin","Bydgoszcz","Wilcza",10,7,1,"angielski","2005-12-22","produkcja","krawcowa",45984]
[null,92,"Tokarczuk","Agata","1982-01-20","Brzeg Dolny","Bydgoszcz","Narutowicza",5,8,4,"niemiecki","2006-10-24","kadry","referent",58600]
[null,93,"Fedorowicz","Ewa","1988-08-24","Szczecin","Chełm","Rugiańska",7,3,2,null,"2011-06-17","produkcja","prasowacz",58012]
[null,94,"Kremicz","Anna","1969-02-05","Dobrzany","Świdnik","Armii Krajowej",13,2,5,"angielski","1989-04-02","zaopatrzenie","zaopatrzeniowiec",17800]
[null,95,"Zalewski","Robert","1972-11-16","Cieplice Śląskie-Zdrój","Biała Podlaska","Śląska",28,14,2,"hiszpański","1998-12-19","produkcja","prasowacz",65340]
[null,96,"Adranowicz","Halina","1973-10-30","Szczecin","Chełm","Matejki","14a",6,6,"angielski","1999-12-05","kadry","referent",28846,"nie"]
[null,97,"Szafko","Radosław","1964-08-24","Szczecin","Chojna","Śląska",22,11,1,null,"1990-09-19","kadry","referent",7960]
[null,98,"Szablewska","Monika","1974-04-07","Szczecin","Brodnica","Gryfińska",35,2,0,null,"1994-04-20","produkcja","krawcowa",89560]
[null,99,"Pogorzelski","Jerzy","1976-01-10","Chojna","Banie","Przyjaźni",15,7,1,"angielski","1996-08-12","transport","kierowca",50960]
[null,100,"Banaszak","Aleksander","1975-07-08","Wałcz","Świdnik","Łużycka",155,1,2,"niemiecki","2000-08-04","transport","kierowca",35100]
[null,101,"Falkiewicz","Stefan","1969-08-13","Szczecin","Chojna","Gdańska",2,1,6,"hiszpański","1991-03-17","kadry","referent",34664]
[null,102,"Maciejewski","Zygmunt","1991-04-26","Czaplice","Cedynia","Oś.Hallera","4d",2,3,"angielski","2014-11-03","produkcja","krawcowa",11330]
[null,103,"Kowalski","Jan","1985-06-18","Szczecin","Bydgoszcz","Boh.Warszawy",64,1,1,"niemiecki","2007-05-30","produkcja","krawcowa",42160]
[null,104,"Kowalski","Jan","1979-07-12","Gryfino","Piotrowice","Piękna","14a",2,5,"niemiecki","2004-01-22","transport","kierowca",22500]
[null,105,"Fudaj","Paulina","1981-06-29","Szczecin","Chełm","Szafera",31,2,1,"angielski","2002-07-10","kadry","referent",17840,"nie"]
[null,106,"Śliwińska","Magdalena","1967-01-27","Białogard","Cedynia","Zawadzkiego",142,4,1,"hiszpański","1988-06-08","magazyn","magazynier",24400,"nie"]
[null,107,"Zabawa","Krzysztof","1968-10-18","Szczecin","Chełm","Ks.Bogusława",4,28,3,"hiszpański","1994-12-16","kadry","referent",56548]
[null,108,"Ginalski","Józef","1964-07-28","Cybinka","Banie","Jagiellońska",15,31,0,null,"1984-07-18","produkcja","krawcowa",89560]
[null,109,"Turski","Zbigniew","1972-02-23","Świnoujście","Świdnik","Konstytucji 3-podoja",31,3,2,null,"1998-03-20","produkcja","prasowacz",9100,"nie"]
[null,110,"Maliniak","Piotr","1986-09-14","Szczecin","Chełm","Krzywoustego","82a",null,5,"francuski","2006-06-26","produkcja","wykrawacz",15280]
[null,111,"Żakowski","Robert","1980-01-01",null,"Świdnik","Konstytucji 3-podoja",31,2,0,"francuski","2003-09-08","kadry","księgowa",13296]
[null,112,"Owczarek","Tomasz","1977-07-09","Łódź","Piotrowice","Wróblewskiego","18b",8,1,"angielski","2003-03-31","transport","kierowca",50960]
[null,113,"Trela","Anna","1972-02-18","Biała Podlaska","Banie","Boh.Warszawy",7,1,1,null,"1992-07-27","produkcja","krawcowa",64000]
[null,114,"Rogalska","Maria","1986-06-14","Szczecin","Bydgoszcz","Boh.Warszawy",23,18,1,"francuski","2009-09-17","produkcja","krawcowa",22600,"nie"]
[null,115,"Radoszewska","Joanna","1987-08-06","Szczecin","Chełm","Orzeszkowej",54,19,1,"niemiecki","2012-09-04","produkcja","prasowacz",76520]
[null,116,"Owczarz","Teresa","1974-02-27","Szczecin","Chojna","Śląska",24,31,2,"francuski","1999-01-04","kadry","referent",20484]
[null,117,"Srokowska","Izabella","1979-11-10","Szczecin","Bydgoszcz","Bułgarska",40,111,1,"angielski","2002-08-14","produkcja","krawcowa",53500,"nie"]
[null,118,"Rokita","Maria","1991-01-20","Brzezin","Banie","Kolejowa",46,3,2,"hiszpański","2011-06-29","produkcja","krawcowa",23600]
[null,119,"Sroka","Wanda","1984-02-10","Bielsko Biała","Biała Podlaska","Felczaka",31,3,0,"angielski","2006-03-05","kadry","referent",27892]
[null,120,"Góralczyk","Wojciech","1971-10-03","Białogard","Cedynia","Odzieżowa",2,65,1,"niemiecki","1997-10-14","zaopatrzenie","magazynier",52220]
[]
[]
[null,null,null,null,null,"Miejsce Urodzenia","Miejscowość Zameldowania",null,null,null,null,"Język",null,"Dział","Stanowisko"]
[null,null,null,null,null,"<>\"\"","<>\"\"",null,null,null,null,"<>\"\"",null,"<>\"\"","<>\"\""]
[]
[null,null,null,null,null,"Miejsce Urodzenia","Miejscowość Zameldowania",null,null,null,null,"Język",null,"Dział","Stanowisko"]
[null,null,null,null,null,"Szczecin","Bydgoszcz",null,null,null,null,null,null,"produkcja","krawcowa"]
[null,null,null,null,null,"Bolesławiec","Biała Podlaska",null,null,null,null,"niemiecki",{"$f":"COUNTIF($L$3:$L$122,L130)","v":30},"kadry","referent"]
[null,null,null,null,null,"Pyrzyce","Piotrowice",null,null,null,null,"angielski",{"$f":"COUNTIF($L$3:$L$122,L131)","v":40},"transport","kierowca"]
[null,null,null,null,null,"Chełmża","Cedynia",null,null,null,null,"hiszpański",{"$f":"COUNTIF($L$3:$L$122,L132)","v":14},"zaopatrzenie","prasowacz"]
[null,null,null,null,null,"Barlinek","Chełm",null,null,null,null,"francuski",{"$f":"COUNTIF($L$3:$L$122,L133)","v":10},"magazyn","księgowa"]
[null,null,null,null,null,"Białogard","Banie",null,null,null,null,null,null,null,"zaopatrzeniowiec"]
[null,null,null,null,null,"Choszczno","Brodnica",null,null,null,null,null,null,null,"wykrawacz"]
[null,null,null,null,null,"Warszawa","Chojna",null,null,null,null,null,null,null,"dyspozytor"]
[null,null,null,null,null,"Bydgoszcz","Piaski",null,null,null,null,null,null,null,"magazynier"]
[null,null,null,null,null,"Brodnica","Świdnik"]
[null,null,null,null,null,"Białystok"]
[null,null,null,null,null,"Chojna"]
[null,null,null,null,null,"Człuchów"]
[null,null,null,null,null,"Cedynia"]
[null,null,null,null,null,"Stargard Szczeciński"]
[null,null,null,null,null,"Chojnice"]
[null,null,null,null,null,"Banie"]
[null,null,null,null,null,"Chociwel"]
[null,null,null,null,null,"Chełm"]
[null,null,null,null,null,"Piaski"]
[null,null,null,null,null,"Lubanowo"]
[null,null,null,null,null,"Resko"]
[null,null,null,null,null,"Czarnkow"]
[null,null,null,null,null,"Boguszów"]
[null,null,null,null,null,"Chełmno"]
[null,null,null,null,null,"Świnoujście"]
[null,null,null,null,null,"Bogdaniec"]
[null,null,null,null,null,"Czerniakrobek"]
[null,null,null,null,null,"Kleszczele"]
[null,null,null,null,null,"Czarnków"]
[null,null,null,null,null,"Bylew"]
[null,null,null,null,null,"Police"]
[null,null,null,null,null,"Balinek"]
[null,null,null,null,null,"Bratomierz"]
[null,null,null,null,null,"Burzenin"]
[null,null,null,null,null,"Braniewo"]
[null,null,null,null,null,"Charków"]
[null,null,null,null,null,"Bierutów"]
[null,null,null,null,null,"Brzeg Dolny"]
[null,null,null,null,null,"Dobrzany"]
[null,null,null,null,null,"Cieplice Śląskie-Zdrój"]
[null,null,null,null,null,"Wałcz"]
[null,null,null,null,null,"Czaplice"]
[null,null,null,null,null,"Gryfino"]
[null,null,null,null,null,"Cybinka"]
[]
[null,null,null,null,null,"Łódź"]
[null,null,null,null,null,"Biała Podlaska"]
[null,null,null,null,null,"Brzezin"]
[null,null,null,null,null,"Bielsko Biała"]

{"sheet":"Zadania","index":2,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Z punktów 1a, 1b i 1c oceniony zostanie tylko jeden "]
[null,"zad.1a\n1.5p","Napisać funkcję VBA, która obliczy ile osób z określonej miejscowości zna określony język (miejscowość zameldowaniia i język są argumentami funkcji)."]
[null,"zad.1c\n3p","Napisac makro, która utworzy listę osób znających język niemiecki. Lista powinna zawierać nazwisko, imię i roczny dochód pracowników."]
[null,"zad.1b\n4p","Napisac funkcję tablicową VBA, która utworzy listę osób znających język wskazany przez argument funkcji. Lista powinna zawierać nazwisko, imię i stanowisko pracowników."]
[]
[null,null,"Z punktów 2a i 2b oceniony zostanie tylko jeden"]
[null,"zad.2a\n1.5p","Za pomocą makra należy wyróżnić  na czerwono nazwiska i język pracowników znających język angielski, na zielono nazwiska i język  pracowników  znających język francuski, a na żółto znających niemiecki."]
[null,"zad.2b\n2.5p","Za pomocą makra należy wyróżnić całe wiersze kolorem czerwonym pracowników znających język angielski,  na zielono całe wiersze  pracowników  znających język francuski, a na żółto całe wiersze  znających niemiecki. Do pokolorowania wszystkich komórek w wierszu należy wykorzystać pętlę."]
[]
[null,"zad.3\n6p","Napisać funkcję tablicową, która dla podanego przez argument miejsca urodzenia i  języka wypisze minimalną i maksymalną płacę oraz  liczbę osób znających ten język."]
[]
[null,"zad.3\n6p","Za pomocą makra narysować równoległobok pokazany obok. Makro nie może zawierać więcej niż 10 instrukcji ."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"8p – bdb"]
[null,null,"6p - db"]
[null,null,"4p - dst"]

{"sheet":"Zadania (2)","index":3,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Z punktów 1a, 1b i 1c oceniony zostanie tylko jeden "]
[null,"zad.1a\n1.5p","Napisać funkcję VBA, która obliczy ile osób jest zatrudnionych na zadanym stanowisku i zna określony język (stanowisko i język są argumentami funkcji)."]
[null,"zad.1c\n3p","Napisac makro, która utworzy listę osób znających język niemiecki. Lista powinna zawierać nazwisko, imię i roczny dochód pracowników."]
[null,"zad.1b\n4p","Napisac funkcję tablicową VBA, która utworzy listę osób znających język wskazany przez argument funkcji. Lista powinna zawierać nazwisko, imię i stanowisko pracowników."]
[]
[null,null,"Z punktów 2a i 2b oceniony zostanie tylko jeden"]
[null,"zad.2a\n1.5p","Za pomocą makra należy wyróżnić  na czerwono nazwiska i język pracowników znających język angielski, na zielono nazwiska i język  pracowników  znających język francuski, a na żółto znających niemiecki."]
[null,"zad.2b\n2.5p","Za pomocą makra należy wyróżnić całe wiersze kolorem czerwonym pracowników znających język angielski,  na zielono całe wiersze  pracowników  znających język francuski, a na żółto całe wiersze  znających niemiecki. Do pokolorowania wszystkich komórek w wierszu należy wykorzystać pętlę."]
[]
[null,"zad.3\n6p","Napisać funkcję tablicową, która dla podanego przez argument miejsca urodzenia i  języka wypisze minimalną i maksymalną płacę oraz  liczbę osób znających ten język."]
[]
[null,null,"8p – bdb"]
[null,null,"6p - db"]
[null,null,"4p - dst"]