{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Wykład 10","rodzina","Arkusz1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":16,"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 10","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Wykład 10 : Instrukcja pętli For w połączeniu z instrukcją If"]
[null,null,null,"(bardziej zaawansowane algorytmy)"]
[]
[null,null,1,"Przykłady ilustrujące zagadnienia z poprzedniego wykładu"]
[null,null,2,"Tworzenie list bez powtórzeń"]
[null,null,3,"Tworzenie zestawień tabelarycznych"]

{"sheet":"rodzina","index":1,"n_rows":56,"n_cols":22,"rows_kept":56,"cut":false,"hidden":false,"merged":[[34,7,34,8],[34,9,34,10]]}
[]
[null,"WYDATKI RODZINY POSZEPSZYŃSKICH W LUTYM 1995 R.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,"4.",null,"max",null,null,null,7,null,null,null,null,null,"1995-02-01",0,0]
[null,"kto","szczegóły wydatków","rodzaj wydatków","data","kwota",null,"1995-02-01",{"$f":"dzienny_wydatek(H4,data,kwota)","v":0},{"$f":"dzien_max(H4,data,kwota)","v":0},{"$f":"SUMIF(data,H4,kwota)","v":0},null,null,"buty dla Adama",null,null,null,null,null,"1995-02-02",7,255]
[null,"tata","benzyna","samochód","1995-02-02",53,null,"1995-02-02",255,121,255,null,null,"ksiazki: Potop, Trędowata",null,null,null,null,null,"1995-02-03",1,2.5]
[null,"tata","benzyna","samochód","1995-02-14",72,null,"1995-02-03",2.5,2.5,2.5,null,null,"obiady",null,null,null,null,null,"1995-02-04",6,94.93]
[null,"Jola","bułki, kiełbasa","jedzenie","1995-02-02",5,null,"1995-02-04",94.93,39.5,94.93,null,null,"proszki do prania, mydło, pasta",null,null,null,null,null,"1995-02-05",3,115.5]
[null,"Adam","bułki, masło, ser","jedzenie","1995-02-02",25,null,"1995-02-05",115.5,57,115.5,null,null,"środki higieny",null,null,null,null,null,"1995-02-06",1,2.8]
[null,"Adam","bułki, pączki","jedzenie","1995-02-08",4.5,null,"1995-02-06",2.8,2.8,2.8,null,null,null,null,null,null,null,null,"1995-02-07",2,82.3]
[null,"mama","buty dla Adama","odzież","1995-02-05",57,null,"1995-02-07",82.3,78,82.3,null,null,null,null,null,null,null,null,"1995-02-08",4,31.5]
[null,"Jola","ciastka","jedzenie","1995-02-27",4.0999999999999996,null,"1995-02-08",31.5,12.4,31.5,null,null,null,"mama","tata","Jola","Adam",null,"1995-02-09",3,79.900000000000006]
[null,"mama","dentysta Adama","czystość","1995-02-21",50,null,"1995-02-09",79.900000000000006,74,79.900000000000006,null,null,"niedziela",{"$f":"bilans_dz_tyg_osoba(kto,data,kwota,osoba)","v":96.899999999999991},0,34,0,null,"1995-02-10",1,4.7]
[null,"Jola","gazety","rozrywka","1995-02-02",2,null,"1995-02-10",4.7,4.7,4.7,null,null,"poniedziałek",0,20,15.1,7.1,null,"1995-02-11",2,58.5]
[null,"mama","jajka, mąka","jedzenie","1995-02-07",4.3,null,"1995-02-11",58.5,52,58.5,null,null,"wtorek",58.8,80.8,78,0,null,"1995-02-12",0,0]
[null,"mama","jajka, mąka, sól itp","jedzenie","1995-02-14",4.5,null,"1995-02-12",0,0,0,null,null,"środa",12.4,36.9,20.75,4.5,null,"1995-02-13",1,11]
[null,"Adam","kasety","rozrywka","1995-02-04",24,null,"1995-02-13",11,11,11,null,null,"czwartek",54.7,248,7,53.2,null,"1995-02-14",2,76.5]
[null,"Jola","kasety","rozrywka","1995-02-13",11,null,"1995-02-14",76.5,72,76.5,null,null,"piątek",0,0,4.7,2.5,null,"1995-02-15",2,22.05]
[null,"mama","kiełbasa, szynka, ciasto","jedzenie","1995-02-08",12.4,null,"1995-02-15",22.05,12.3,22.05,null,null,"sobota",56.5,63.75,29.98,30.5,null,"1995-02-16",1,15]
[null,"Adam","kino dla rodziny","rozrywka","1995-02-02",12,null,"1995-02-16",15,15,15,null,null,null,null,null,null,null,null,"1995-02-17",0,0]
[null,"Jola","ksiazki: Potop, Trędowata","rozrywka","1995-02-05",34,null,"1995-02-17",0,0,0,null,null,8,null,null,null,null,null,"1995-02-18",2,15.3]
[null,"tata","kwiaty, prezent dla cioci Marty","rozrywka","1995-02-22",21,null,"1995-02-18",15.3,11,15.3,null,null,"mama",{"$f":"wydatek_osoby(N21,kto,kwota)","v":279.3},{"$f":"SUMIF(kto,N21,kwota)","v":279.3},null,null,null,"1995-02-19",1,6.8]
[null,"Adam","lody","jedzenie","1995-02-03",2.5,null,"1995-02-19",6.8,6.8,6.8,null,null,"tata",{"$f":"wydatek_osoby(N22,kto,kwota)","v":449.45},{"$f":"SUMIF(kto,N22,kwota)","v":449.45},null,null,null,"1995-02-20",1,20]
[null,"Adam","lody, woda mineralna","rozrywka","1995-02-09",1.2,null,"1995-02-20",20,20,20,null,null,"Jola",{"$f":"wydatek_osoby(N23,kto,kwota)","v":189.53},{"$f":"SUMIF(kto,N23,kwota)","v":189.53},null,null,null,"1995-02-21",1,50]
[null,"tata","mandat","samochód","1995-02-20",20,null,"1995-02-21",50,50,50,null,null,"Adam",{"$f":"wydatek_osoby(N24,kto,kwota)","v":97.8},{"$f":"SUMIF(kto,N24,kwota)","v":97.8},null,null,null,"1995-02-22",1,21]
[null,"mama","mięso","jedzenie","1995-02-02",37,null,"1995-02-22",21,21,21,null,null,null,null,null,null,null,null,"1995-02-23",1,13]
[null,"mama","mięso, wędliny","jedzenie","1995-02-23",13,null,"1995-02-23",13,13,13,null,null,null,null,null,null,null,null,"1995-02-24",0,0]
[null,"Jola","mięso, wędliny, jajka","jedzenie","1995-02-15",9.75,null,"1995-02-24",0,0,0,null,null,9,null,null,null,null,null,"1995-02-25",1,12]
[null,"Jola","mydło, pasta, proszek","czystość","1995-02-07",78,null,"1995-02-25",12,12,12,null,null,"samochód",{"$f":"wydatek_rodzaj(N28,rodzaj,kwota)","v":157.25},null,null,null,null,"1995-02-26",1,8.6]
[null,"tata","naprawa pralki, pasek, wąż","dom","1995-02-15",12.3,null,"1995-02-26",8.6,8.6,8.6,null,null,"jedzenie",238.83,null,null,null,null,"1995-02-27",2,8.4]
[null,"Jola","obiady","jedzenie","1995-02-04",20,null,"1995-02-27",8.4,4.3,8.3999999999999986,null,null,"odzież",124,null,null,null,null,"1995-02-28",1,8.8000000000000007]
[null,"mama","obiady","jedzenie","1995-02-05",24.5,null,"1995-02-28",8.8000000000000007,8.8000000000000007,8.8000000000000007,null,null,"czystość",143.4]
[null,"tata","obiady swoje i Adama","jedzenie","1995-02-04",39.5,null,null,null,null,null,null,null,"rozrywka",208.3]
[null,"tata","papierosy","rozrywka","1995-02-08",3.6,null,null,null,null,null,null,null,"dom",23.3]
[null,"tata","perfumy dla mamy","rozrywka","1995-02-25",12,null,"Zadanie 3",null,null,null,null,null,"stałe",121]
[null,"tata","płyn do chłodnicy","samochód","1995-02-18",11,null,"rodzice",null,"dzieci"]
[null,"mama","pomarańcze","jedzenie","1995-02-04",4.5,null,"ilość","kwota","ilość","kwota"]
[null,"Jola","prezent dla Beaty","rozrywka","1995-02-10",4.7,null,{"$f":"zlicz_sumuj_wydatki(kto,kwota)","v":26},728.75,22,287.33000000000004]
[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,"Zadanie 5"]
[null,"tata","reflektor","samochód","1995-02-04",1.25,null,"mama"]
[null,"Adam","rękawiczki, szalik","odzież","1995-02-16",15,null,"mama"]
[null,"mama","sweter dla Adama","odzież","1995-02-11",52,null,"Jola"]
[null,"tata","swiatło, gaz, mieszkanie","stałe","1995-02-02",121]
[null,"Jola","szklanki, spodki","dom","1995-02-08",11,null,"Zadanie 6"]
[null,"Jola","rogaliki","jedzenie","1995-02-04",5.68,null,{"$f":"dzien_max_min(data,kwota)","v":"1995-02-02"},255]
[null,"Adam","bułki","jedzenie","1995-02-11",6.5,null,"1995-02-03",2.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,{"$f":"COUNTIFS(kto,\"mama\",kto,\"tata\")","v":0}]
[null,null,{"$f":"COUNTIF(kto,\"mama\")+COUNTIF(kto,\"tata\")","v":26}]

{"sheet":"Arkusz1","index":2,"n_rows":19,"n_cols":22,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,18,1,19],[1,20,1,21]]}
[]
[{"$f":"ile_dzieci(kto)","v":22},null,"1.     Napisać funkcję, która obliczy ile razy robiły zakupy dzieci.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rodzice",null,"dzieci"]
[728.75,null,"2.     Napisać makro, które obliczy ile pieniędzy wydali rodzice.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ilość","suma","ilość","suma"]
[null,null,"3.     Napisać funkcję tablicową, która obliczy ilość oraz kwotę wydatków zarówno rodziców jak i dzieci (wywołanie funkcji w czterech komórkach).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"zlicz_sumuj_wydatki(kto,kwota)","v":26},728.75,22,287.33000000000004]
[null,null,"4.     Napisać funkcję, która obliczy ile pieniędzy wydano w określonym dniu (data jako parametr funkcji) "]
[null,null,"5.     Napisać makro, które wypisze w wybranym obszarze osoby, które kupowały jajka."]
[{"$f":"dzien_max_min(data,kwota)","v":"1995-02-02"},255,"6.     Napisać funkcję tablicową, która wyznaczy daty dwóch dni: pierwszego, w którym wydano najwięcej pieniędzy i drugiego, w którym wydano najmniej pieniędzy, przy czym należy pominąć te dni, w których w ogóle nie wydawano pieniędzy."]
["1995-02-03",2.5,"Wskazówka: należy wykorzystać funkcję napisaną w punkcie 4."]
[null,null,"7.     Napisać makro, które tworzy listę wydatków zrobionych w niedziele w miesiącu lutym. (por. help: funkcja Weekday)"]
[null,null,"8.     Napisać funkcję, która obliczy ile pieniędzy ogółem wydała wskazana osoba."]
[null,null,"9.     Napisać funkcję, która obliczy ile pieniędzy ogółem wydano dla wskazanego rodzaju wydatków."]
[null,null,"10.  Za pomocą makra wykonać zestawienie, które podaje dla każdego dnia w miesiącu lutym 1995 r. liczbę wydatków i łączną kwotę wydatków."]
[null,null,"11.  Wypisać za pomocą makr lub/i funkcji wszystkie daty dni miesiąca lutego 1995 r., w których tata nie robił zakupów (nie wydawał pieniędzy)."]
[null,null,"12.  Za pomocą funkcji tablicowej wykonać zestawienie wydatków każdej z osób w poszczególnych dniach tygodnia."]
[null,null,"   "]
[null,null,"13.  Za pomocą makra, żółtym kolorem zaznaczyć 3 najmniejsze kwoty wydatków. (tło komórki w kolorze żółtym)"]
[null,null,"14.  Napisać makro, które wypisze w wybranym obszarze daty trzech dni, w których wydatki rodziny były największe, a obok kwoty tych wydatków."]
[null,null,"15.  Uogólnić makro z p. 14 na k- maksymalnych wartości. Zastosować procedurę dla k = 5 w zagadnieniu wypisania dat 5 dni, w których zanotowano największą ilość wydatków. (uwaga: jeśli n jest liczbą wszystkich wartości – elementów zbioru, to powinno być k <= n; gdy k = n dostajemy procedurę sortowania)."]
[null,null,"16.  Wypisz bez powtórzeń listę wszystkich rodzajów wydatków."]