{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Zagadnienia","Arkusz2","rodzina","Arkusz3","Arkusz1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":"Zagadnienia","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Wykład 12 : Instrukcja pętli For w połączeniu z instrukcją If"]
[]
[null,"Podstawowe algorytmy z jedną pętlą"]
[null,null,"a. Zliczanie określonych warunkiem elementów w arkuszu  "]
[null,null,"b. Sumowanie określonych warunkiem elementów w arkuszu "]
[null,null,"c. Wyznaczanie elemenu maksymalnego/minimalnego"]
[null,null,"d. Tworzenie listy elementów określonych warunkiem"]

{"sheet":"Arkusz2","index":1,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Algorytm zliczania i sumowania",null,null,null,null,null,null,null,null,"Algorytm wyznaczania elementu maksymalnego"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opis kolejnych kroków"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Krok 1:  Wczytaj liczbę n oraz elementy tablicy z(1), ..., z(n)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Krok 2:  Zmiennej max przypisz wartość z(1). Zmiennej i przypisz wartość 2."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Krok 3:  Jeśli i jest większe od n, wtedy wypisz wartość zmiennej max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," i zakończ działanie algorytmu."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Krok 4:  Jeśli z(i) jest większe od max, wtedy zmiennej max przypisz wartość  z(i)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Krok 5:  Powiększ o 1 wartość zmiennej i, po czym przejdź do kroku 3. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"tak",null,null,null,null,null,null,null,null,null,null,"tak"]
[]
[]
[null,null,null,"nie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nie"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"       nie"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tak"]

{"sheet":"rodzina","index":2,"n_rows":87,"n_cols":18,"rows_kept":87,"cut":false,"hidden":false,"merged":[[14,7,15,11]]}
[]
[]
[null,null,null,null,null,null,null,"kto"]
[null,"WYDATKI RODZINY POSZEPSZYŃSKICH W LUTYM 1995 R.",null,null,null,null,null,"tata"]
[null,null,null,null,null,null,null,"mama"]
[null,"kto","szczegóły wydatków","rodzaj wydatków","data","kwota"]
[null,"tata","benzyna 98","samochód","1995-02-02",53,null,"1)","Zlicza wydatki w  dniu:",null,null,"1995-02-02",{"$f":"zlicz_wydatki(L7,data)","v":7}]
[null,"tata","benzyna","samochód","1995-02-14",72,null,"2)","Oblicza sumę wydatków z grupy rozrywka",null,null,null,208.3,{"$f":"suma_wydatków_rozrywki(kwota,rodzaj)","v":208.3}]
[null,"Jola","bułki, kiełbasa","jedzenie","1995-02-02",5,null,"3)","Zlicza i sumuje wydatki dla daty",null,null,"1995-02-02",{"$f":"zlicz_sumuj_wydatki(L9,data,kwota)","v":7},255]
[null,"Adam","bułki, masło, ser","jedzenie","1995-02-02",25,null,"4)","Podaje dzień, w którym zanotowano największy pojedynczy wydatek",null,null,null,null,null,121,"1995-02-02"]
[null,"Adam","bułki, pączki","jedzenie","1995-02-08",4.5,null,"5)","Wypisuje listę zakupów rodziców"]
[null,"mama","buty dla Adama","odzież","1995-02-05",57,null,"6)","Zaznacza na żółto zakupy jajek",null,null,null,null,null,"benzyna",null,null,{"$f":"lista_zakupow(zakup,kto)","v":"benzyna 98"}]
[null,"Jola","ciastka","jedzenie","1995-02-27",4.0999999999999996,null,"7)","Bilans wydatków poszczególnych osób w zależności od ich rodzajów",null,null,null,null,null,"benzyna",null,null,"benzyna"]
[null,"mama","dentysta Adama","czystość","1995-02-21",50,null,null,null,null,null,null,null,null,"buty dla Adama",null,null,"buty dla Adama"]
[null,"Jola","gazety","rozrywka","1995-02-02",2,null,"Zestawienie wydatków poszczególnych osób w zależności od ich rodzajów",null,null,null,null,null,null,"dentysta Adama",null,null,"dentysta Adama"]
[null,"mama","jajka, mąka","jedzenie","1995-02-07",4.3,null,null,null,null,null,null,null,null,"jajka, mąka",null,null,"jajka, mąka"]
[null,"mama","jajka, mąka, sól itp","jedzenie","1995-02-14",4.5,null,null,null,null,null,null,null,null,"jajka, mąka, sól itp",null,null,"jajka, mąka, sól itp"]
[null,"Adam","kasety","rozrywka","1995-02-04",24,null,null,"mama","tata","Jola","Adam",null,null,"kiełbasa, szynka, ciasto",null,null,"kiełbasa, szynka, ciasto"]
[null,"Jola","kasety","rozrywka","1995-02-13",11,null,"samochód",{"$f":"bilans_rodzaj_osoba(kto,rodzaj,kwota,jaki_rodzaj,osoba)","v":0},157.25,0,0,null,null,"kwiaty, prezent dla cioci Marty",null,null,"kwiaty, prezent dla cioci Marty"]
[null,"mama","kiełbasa, szynka, ciasto","jedzenie","1995-02-08",12.4,null,"jedzenie",104.9,39.5,48.83,45.599999999999994,null,null,"mandat",null,null,"mandat"]
[null,"Adam","kino dla rodziny","rozrywka","1995-02-02",12,null,"odzież",109,0,0,15,null,null,"mięso",null,null,"mięso"]
[null,"Jola","ksiazki: Potop, Trędowata","rozrywka","1995-02-05",34,null,"czystość",65.400000000000006,0,78,0,null,null,"mięso, wędliny",null,null,"mięso, wędliny"]
[null,"tata","kwiaty, prezent dla cioci Marty","rozrywka","1995-02-22",21,null,"rozrywka",0,119.39999999999999,51.7,37.200000000000003,null,null,"naprawa pralki, pasek, wąż",null,null,"naprawa pralki, pasek, wąż"]
[null,"Adam","lody","jedzenie","1995-02-03",2.5,null,"dom",0,12.3,11,0,null,null,"obiady",null,null,"obiady"]
[null,"Adam","lody, woda mineralna","rozrywka","1995-02-09",1.2,null,"stałe",0,121,0,0,null,null,"obiady swoje i Adama",null,null,"obiady swoje i Adama"]
[null,"tata","mandat","samochód","1995-02-20",20,null,null,null,null,null,null,null,null,"papierosy",null,null,"papierosy"]
[null,"mama","mięso","jedzenie","1995-02-02",37,null,null,null,null,null,null,null,null,"perfumy dla mamy",null,null,"perfumy dla mamy"]
[null,"mama","mięso, wędliny","jedzenie","1995-02-23",13,null,null,null,null,null,null,null,null,"płyn do chłodnicy",null,null,"płyn do chłodnicy"]
[null,"Jola","mięso, wędliny, jajka","jedzenie","1995-02-15",9.75,null,"1995-02-01",{"$f":"licz_wydatki(E7,data)","v":7},null,null,null,null,null,"pomarańcze",null,null,"pomarańcze"]
[null,"Jola","mydło, pasta, proszek","czystość","1995-02-07",78,null,"1995-02-02",{"$f":"licz_wydatki(E8,data)","v":2},null,null,null,null,null,"proszek do piecz., keczup itp.",null,null,"proszek do piecz., keczup itp."]
[null,"tata","naprawa pralki, pasek, wąż","dom","1995-02-15",12.3,null,"1995-02-03",{"$f":"licz_wydatki(E9,data)","v":7},null,null,null,null,null,"proszki do prania, mydło, pasta",null,null,"proszki do prania, mydło, pasta"]
[null,"Jola","obiady","jedzenie","1995-02-04",20,null,"1995-02-04",{"$f":"licz_wydatki(E10,data)","v":7},null,null,null,null,null,"reflektor",null,null,"reflektor"]
[null,"mama","obiady","jedzenie","1995-02-05",24.5,null,"1995-02-05",{"$f":"licz_wydatki(E11,data)","v":4},null,null,null,null,null,"sweter dla Adama",null,null,"sweter dla Adama"]
[null,"tata","obiady swoje i Adama","jedzenie","1995-02-04",39.5,null,"1995-02-06",{"$f":"licz_wydatki(E12,data)","v":3},null,null,null,null,null,"swiatło, gaz, mieszkanie",null,null,"swiatło, gaz, mieszkanie"]
[null,"tata","papierosy","rozrywka","1995-02-08",3.6,null,"1995-02-07",{"$f":"licz_wydatki(E13,data)","v":2},null,null,null,null,null,"środki higieny",null,null,"środki higieny"]
[null,"tata","perfumy dla mamy","rozrywka","1995-02-25",12,null,"1995-02-08",{"$f":"licz_wydatki(E14,data)","v":1},null,null,null,null,null,"wino, piwo",null,null,"wino, piwo"]
[null,"tata","płyn do chłodnicy","samochód","1995-02-18",11,null,"1995-02-09",{"$f":"licz_wydatki(E15,data)","v":7},null,null,null,null,null,"wino",null,null,"wino"]
[null,"mama","pomarańcze","jedzenie","1995-02-04",4.5,null,"1995-02-01"]
[null,"Jola","prezent dla Beaty","rozrywka","1995-02-10",4.7]
[null,"mama","proszek do piecz., keczup itp.","jedzenie","1995-02-09",4.7]
[null,"mama","proszki do prania, mydło, pasta","czystość","1995-02-26",8.6]
[null,"tata","reflektor","samochód","1995-02-04",1.25]
[null,"Adam","rękawiczki, szalik","odzież","1995-02-16",15]
[null,"mama","sweter dla Adama","odzież","1995-02-11",52]
[null,"tata","swiatło, gaz, mieszkanie","stałe","1995-02-02",121]
[null,"Jola","szklanki, spodki","dom","1995-02-08",11]
[null,"Jola","rogaliki","jedzenie","1995-02-04",5.68]
[null,"Adam","bułki","jedzenie","1995-02-11",6.5]
[null,"Jola","bagietki","jedzenie","1995-02-18",4.3]
[null,"Adam","cukier","jedzenie","1995-02-27",4.3]
[null,"Adam","płatki: mleko, bułki, masło","jedzenie","1995-02-06",2.8]
[null,"mama","środki higieny","czystość","1995-02-19",6.8]
[null,"tata","wino, piwo","rozrywka","1995-02-09",74]
[null,"tata","wino","rozrywka","1995-02-28",8.8000000000000007]
[]
[null,null,null,"1995-02-02",{"$f":"COUNTIF(data,D56)","v":7}]
[null,null,null,null,{"$f":"SUMIF(rodzaj,\"rozrywka\",kwota)","v":208.3}]
[]
[]
[]
[null,"kto","szczegóły wydatków","rodzaj wydatków","data","kwota"]
[null,"tata","benzyna","samochód","1995-02-02",53]
[null,"tata","benzyna","samochód","1995-02-14",72]
[null,"mama","buty dla Adama","odzież","1995-02-05",57]
[null,"mama","dentysta Adama","czystość","1995-02-21",50]
[null,"mama","jajka, mąka","jedzenie","1995-02-07",4.3]
[null,"mama","jajka, mąka, sól itp","jedzenie","1995-02-14",4.5]
[null,"mama","kiełbasa, szynka, ciasto","jedzenie","1995-02-08",12.4]
[null,"tata","kwiaty, prezent dla cioci Marty","rozrywka","1995-02-22",21]
[null,"tata","mandat","samochód","1995-02-20",20]
[null,"mama","mięso","jedzenie","1995-02-02",37]
[null,"mama","mięso, wędliny","jedzenie","1995-02-23",13]
[null,"tata","naprawa pralki, pasek, wąż","dom","1995-02-15",12.3]
[null,"mama","obiady","jedzenie","1995-02-05",24.5]
[null,"tata","obiady swoje i Adama","jedzenie","1995-02-04",39.5]
[null,"tata","papierosy","rozrywka","1995-02-08",3.6]
[null,"tata","perfumy dla mamy","rozrywka","1995-02-25",12]
[null,"tata","płyn do chłodnicy","samochód","1995-02-18",11]
[null,"mama","pomarańcze","jedzenie","1995-02-04",4.5]
[null,"mama","proszek do piecz., keczup itp.","jedzenie","1995-02-09",4.7]
[null,"mama","proszki do prania, mydło, pasta","czystość","1995-02-26",8.6]
[null,"tata","reflektor","samochód","1995-02-04",1.25]
[null,"mama","sweter dla Adama","odzież","1995-02-11",52]
[null,"tata","swiatło, gaz, mieszkanie","stałe","1995-02-02",121]
[null,"mama","środki higieny","czystość","1995-02-19",6.8]
[null,"tata","wino, piwo","rozrywka","1995-02-09",74]
[null,"tata","wino","rozrywka","1995-02-28",8.8000000000000007]

{"sheet":"Arkusz3","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,1.7,null,1.7,null,"a"]
[null,2,null,2,null,"b"]
[null,-3.2,null,4,null,"c"]
[null,4,null,2.12,null,"d"]
[null,-1,null,6.3,null,"a"]
[null,2.12,null,3,null,"b"]
[null,0,null,null,null,"c"]
[null,6.3,null,null,null,"a"]
[null,3,null,null,null,"c"]
[null,-4.5,null,null,null,"b"]

{"sheet":"Arkusz1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}