{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Egzamin","Wykład 13","Rodzina","Sortowanie","ListBox"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":1},"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":"Egzamin","index":0,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Terminy Egzaminów w sesji letniej"]
[]
[null,"Termin zerowy","2014-06-18","od 14:30"]
[null,"Termin pierwszy","2014-06-24","od 12:00-15:00",null,"Sale 121A i 121"]
[null,"Termin drugi","2014-06-27","od 9:00:12:00"]

{"sheet":"Wykład 13","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Wykład 13. Tworzenie aplikacji w Excelu"]
[]
[null,null,"Aplikacja arkusza kalkulacyjnego to plik lub zestaw plików opracowany w taki spsób,"]
[null,null,"aby inny użytkownik bez konieczności obszernego szkolenia mógł wykonać za jego pomocą"]
[null,null,"przydatną operację."]
[]
[]
[null,null,"Programowanie obiektowe i zdarzeniowe"]
[null,null,"- formularze, elementy sterujące (formanty), właściwości i metody"]
[null,null,"- zdarzenia i procedury obsługi zdarzeń"]
[]
[null,null,56765]

{"sheet":"Rodzina","index":2,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[11,8,12,12]]}
[]
[]
[null,"WYDATKI RODZINY POSZEPSZYŃSKICH W LUTYM 1995 R."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(data,dzień)","v":7},{"$f":"SUMIF(data,dzień,kwota)","v":255}]
[null,"kto","szczegóły wydatków","rodzaj wydatków","data","kwota [zł]",null,1,"Zliczyć i zsumować wydatki dla określonej daty",null,null,null,null,null,"1995-02-02",{"$f":"zlicz_sumuj_wydatki(dzień,data,kwota)","v":7},255]
[null,"tata","benzyna","samochód","1995-02-02",53,null,2,"Podać dzień, w którym zanotowano największy pojedynczy wydatek",null,null,null,null,null,null,121,"1995-02-02",null,{"$f":"lista_zakupów(\"tata\",kto,szczegóły)","v":"benzyna"}]
[null,"tata","benzyna","samochód","1995-02-14",72,null,3,"Wypisać listę zakupów określonej osoby",null,null,null,null,null,null,1.2,"1995-02-09",null,"benzyna"]
[null,"Jola","bułki, kiełbasa","jedzenie","1995-02-02",5,null,4,"Zaznaczyć na żółto zakupy jajek",null,null,null,null,null,null,null,null,null,"kwiaty, prezent dla cioci Marty"]
[null,"Adam","bułki, masło, ser","jedzenie","1995-02-02",25,null,5,"Wypisać bez powtórzeń listę wszystkich rodzajów wydatków.",null,null,null,null,null,null,null,null,null,"mandat"]
[null,"Adam","bułki, pączki","jedzenie","1995-02-08",4.5,null,6,"Wykonać bilans wydatków poszczególnych osób w zależności od ich rodzajów",null,null,null,null,null,null,null,null,null,"naprawa pralki, pasek, wąż"]
[null,"mama","buty dla Adama","odzież","1995-02-05",57,null,null,null,null,null,null,null,null,null,null,null,null,"obiady swoje i Adama"]
[null,"Jola","ciastka","jedzenie","1995-02-27",4.0999999999999996,null,null,"Zestawienie wydatków poszczególnych osób w zależności od ich rodzajów",null,null,null,null,null,null,null,null,null,"papierosy"]
[null,"mama","dentysta Adama","czystość","1995-02-21",50,null,null,null,null,null,null,null,null,null,null,null,null,"perfumy dla mamy"]
[null,"Jola","gazety","rozrywka","1995-02-02",2,null,null,null,null,null,null,null,null,null,null,null,null,"płyn do chłodnicy"]
[null,"mama","jajka, mąka","jedzenie","1995-02-07",4.3,null,null,null,"Adam","Jola","mama","tata",null,"Adam",null,null,null,"reflektor"]
[null,"mama","jajka, mąka, sól itp","jedzenie","1995-02-14",4.5,null,null,"czystość",{"$f":"bilans_rodzaj_osoba(kto,rodzaj,kwota,I16:I22,J15:M15)","v":0},78,65.400000000000006,0,null,"Jola",null,null,null,"swiatło, gaz, mieszkanie"]
[null,"Adam","kasety","rozrywka","1995-02-04",24,null,null,"dom",0,11,0,12.3,null,"mama",null,null,null,"wino, piwo"]
[null,"Jola","kasety","rozrywka","1995-02-13",11,null,null,"jedzenie",45.599999999999994,48.83,104.9,39.5,null,"tata",null,null,null,"wino"]
[null,"mama","kiełbasa, szynka, ciasto","jedzenie","1995-02-08",12.4,null,null,"odzież",15,0,109,0,null,null,null,null,null,""]
[null,"Adam","kino dla rodziny","rozrywka","1995-02-02",12,null,null,"rozrywka",37.200000000000003,51.7,0,119.39999999999999,null,null,null,null,null,""]
[null,"Jola","ksiazki: Potop, Trędowata","rozrywka","1995-02-05",34,null,null,"samochód",0,0,0,157.25,null,null,null,null,null,""]
[null,"tata","kwiaty, prezent dla cioci Marty","rozrywka","1995-02-22",21,null,null,"stałe",0,0,0,121,null,null,null,null,null,""]
[null,"Adam","lody","jedzenie","1995-02-03",2.5,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Adam","lody, woda mineralna","rozrywka","1995-02-09",1.2,null,7,"Napisać funkcję tablicową sortującą wg określonej kolumny.",null,null,null,null,null,null,null,null,null,""]
[null,"tata","mandat","samochód","1995-02-20",20,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"mama","mięso","jedzenie","1995-02-02",37,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"mama","mięso, wędliny","jedzenie","1995-02-23",13,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Jola","mięso, wędliny, jajka","jedzenie","1995-02-15",9.75,null,null,"rodzaj wydatków",null,null,null,null,null,null,null,null,null,""]
[null,"Jola","mydło, pasta, proszek","czystość","1995-02-07",78,null,null,"samochód","samochód",{"$f":"rodzaje_zakupów(rodzaj)","v":"samochód"},null,null,null,null,null,null,null,""]
[null,"tata","naprawa pralki, pasek, wąż","dom","1995-02-15",12.3,null,null,"jedzenie","jedzenie","jedzenie",null,null,null,null,null,null,null,""]
[null,"Jola","obiady","jedzenie","1995-02-04",20,null,null,"odzież","odzież","odzież",null,null,null,null,null,null,null,""]
[null,"mama","obiady","jedzenie","1995-02-05",24.5,null,null,"czystość","czystość","czystość",null,null,null,null,null,null,null,""]
[null,"tata","obiady swoje i Adama","jedzenie","1995-02-04",39.5,null,null,"rozrywka","rozrywka","rozrywka",null,null,null,null,null,null,null,""]
[null,"tata","papierosy","rozrywka","1995-02-08",3.6,null,null,"dom","dom","dom",null,null,null,null,null,null,null,""]
[null,"tata","perfumy dla mamy","rozrywka","1995-02-25",12,null,null,"stałe","stałe","stałe",null,null,null,null,null,null,null,""]
[null,"tata","płyn do chłodnicy","samochód","1995-02-18",11,null,null,null,null,"",null,null,null,null,null,null,null,""]
[null,"mama","pomarańcze","jedzenie","1995-02-04",4.5,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Jola","prezent dla Beaty","rozrywka","1995-02-10",4.7,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"mama","proszek do piecz., keczup itp.","jedzenie","1995-02-09",4.7,null,null," ",null,null,null,null,null,null,null,null,null,""]
[null,"mama","proszki do prania, mydło, pasta","czystość","1995-02-26",8.6,null,null,null,"Adam","Jola","mama","tata",null,null,null,null,null,""]
[null,"tata","reflektor","samochód","1995-02-04",1.25,null,null,"czystość",null,78,65.400000000000006,null,null,null,null,null,null,""]
[null,"Adam","rękawiczki, szalik","odzież","1995-02-16",15,null,null,"dom",null,11,null,12.3,null,null,null,null,null,""]
[null,"mama","sweter dla Adama","odzież","1995-02-11",52,null,null,"jedzenie",45.599999999999994,48.83,104.9,39.5,null,null,null,null,null,""]
[null,"tata","swiatło, gaz, mieszkanie","stałe","1995-02-02",121,null,null,"odzież",15,null,109,null,null,null,null,null,null,""]
[null,"Jola","szklanki, spodki","dom","1995-02-08",11,null,null,"rozrywka",37.200000000000003,51.7,null,119.39999999999999,null,null,null,null,null,""]
[null,"Jola","rogaliki","jedzenie","1995-02-04",5.68,null,null,"samochód",null,null,null,157.25,null,null,null,null,null,""]
[null,"Adam","bułki","jedzenie","1995-02-11",6.5,null,null,"stałe",null,null,null,121,null,null,null,null,null,""]
[null,"Jola","bagietki","jedzenie","1995-02-18",4.3,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Adam","cukier","jedzenie","1995-02-27",4.3,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Adam","płatki: mleko, bułki, masło","jedzenie","1995-02-06",2.8,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"mama","środki higieny","czystość","1995-02-19",6.8,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"tata","wino, piwo","rozrywka","1995-02-09",74,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"tata","wino","rozrywka","1995-02-28",8.8000000000000007,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Sortowanie","index":3,"n_rows":17,"n_cols":29,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Sortowanie bąbelkowe"]
[null,null,null,null,null,null,null,null,{"$f":"sort1(AC5:AC13)","v":"adam"},"adam","adam","adam","adam","adam","adam","adam","adam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max.k",null,"F. tabl. Sort1",null,"Sortowanie w Excelu"]
[null,null,null,null,"max",null,null,null,null,null,null,null,null,"wzorzec",null,"(działa tylko na liczbach)"]
[null,null,null,null,20,null,null,null,null,null,null,null,null,"ala",null,{"$f":"LARGE(tablica,{1;2;3;4;5;6;7;8;9})","v":{"$error":"#NUM!"}},null," =sort1(tablica)",null,20,null,null,null,null,null,null,20,null,"ala"]
[null,null,null,null,4,2.1,null,null,null,null,null,null,null,"jola",null,{"$error":"#NUM!"},null," =sort1(tablica)",null,19,null,null,null,null,null,null,4,null,"jola"]
[null,null,null,null,17,3.2,3.2,null,null,null,null,null,null,"adam",null,{"$error":"#NUM!"},null," =sort1(tablica)",null,17,null,null,null,null,null,null,17,null,"adam"]
["Jeśli górny jest mniejszy od dolny to zamień",null,null,null,7,4.3,4.3,4.3,null,null,null,null,null,"jan",null,{"$error":"#NUM!"},null," =sort1(tablica)",null,9,null,null,null,null,null,null,7,null,"jan"]
[null,null,null,null,-3,5.4,5.4,5.4,5.4,null,null,null,null,"zenon",null,{"$error":"#NUM!"},null," =sort1(tablica)",null,8,null,null,null,null,null,null,-3,null,"zenon"]
[null,null,null,null,19,6.5,6.5,6.5,6.5,6.5,null,null,null,"ewa",null,{"$error":"#NUM!"},null," =sort1(tablica)",null,7,null,null,null,null,null,null,19,null,"ewa"]
[null,null,null,null,5,7.6,7.6,7.6,7.6,7.6,7.6,null,null,"leon",null,{"$error":"#NUM!"},null," =sort1(tablica)",null,5,null,null,null,null,null,null,5,null,"leon"]
[null,null,null,"i",8,8.6999999999999993,8.6999999999999993,8.6999999999999993,8.6999999999999993,8.6999999999999993,8.6999999999999993,8.6999999999999993,null,"marian",null,{"$error":"#NUM!"},null," =sort1(tablica)",null,4,null,null,null,null,null,null,8,null,"marian"]
[null,null,null,null,9,9.8000000000000007,9.8000000000000007,9.8000000000000007,9.8000000000000007,9.8000000000000007,9.8000000000000007,9.8000000000000007,9.8000000000000007,"karol",null,{"$error":"#NUM!"},null," =sort1(tablica)",null,-3,null,null,null,null,null,null,9,null,"karol"]
[null,null,null,null,8,"krok1","krok2","krok3","krok4","krok5","krok6","krok7","krok8"]
[]
[]
[null,null,null,null,"k",2,3,4]

{"sheet":"ListBox","index":4,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["LISTA","WYBRANO"]
["Styczeń","Styczeń"]
["Luty"]
["Marzec"]
["Kwiecień"]
["Maj"]
["Czerwiec"]
["Lipiec"]
["Sierpień"]
["Wrzesień"]
["Październik"]
["Listopad"]
["Grudzień"]
[]
["LISTA","WYBRANO"]
[{"$f":"YEAR(NOW())","v":2014},2017]
[{"$f":"A16+1","v":2015}]
[2016]
[2017]
[2018]
[2019]
[2020]