{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Wykład 13","Arkusz1","Arkusz2","Arkusz3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Wykład 13","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Wykład 12 - zagadnienia, w których VBA poszerza standardowe możliwości EXCELA"]

{"sheet":"Arkusz1","index":1,"n_rows":59,"n_cols":26,"rows_kept":59,"cut":false,"hidden":false,"merged":[[3,1,3,2],[4,1,12,1],[3,23,3,25],[3,19,3,21],[1,19,2,20],[1,21,2,21]]}
[null,"SPRZEDAŻ HERBATY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"podaj ilość kg ->",null,15]
[null,null,"Cena 1 kg",29.1,31.5,35.1,29.1,60.9,32.1,27,33.6,29.4,29.1,30.3,43.2,33.299999999999997,29.4]
[null,"Nazwa herbaty",null,"Assam","Black Lychee","Ceylon","Chunmee","Darjeeling","Dragonwell","Gunpowder","Gyokuru","Jasmine","Keemun","Lapsang Souchong","Oolong","Pi Lo Chun","Russian Blend",null,null,"Wyszukuje dane sprzedaży o podanej ilości kg",null,null,null,"Największe co do trzech maksymalnych wartości zamówienia (wg ilości w kg)"]
[null,"Pracownik","Dąbrowski",55,20,30,50,115,60,35,45,10,115,35,60,15,55,null,null,"Pracownik","Nazwa herbaty","Waga (kg)",null,"Pracownik","Nazwa herbaty","Waga (kg)"]
[null,null,"Górecki",null,10,35,15,110,20,45,15,25,50,65,60,25,90,null,null,{"$f":"WyszukajDanezTabeli(V2,pracownik,herbata,ilość)","v":"Dąbrowski"},"Pi Lo Chun","15",null,{"$f":"maks3(ilość)","v":"Grabowski"},"Keemun","130"]
[null,null,"Grabowski",70,null,15,50,65,35,15,40,15,130,null,50,45,55,null,null,"Górecki","Chunmee","15",null,"Lipiński","Chunmee","120"]
[null,null,"Halski",45,75,null,30,95,45,15,20,60,85,25,60,50,115,null,null,"Górecki","Gyokuru","15",null,"Dąbrowski","Darjeeling","115"]
[null,null,"Kowalski",null,15,null,15,null,35,10,30,10,30,45,40,15,25,null,null,"Grabowski","Ceylon","15",null,"Dąbrowski","Keemun","115"]
[null,null,"Lipiński",50,95,65,120,80,45,70,70,90,90,30,70,95,85,null,null,"Grabowski","Gunpowder","15",null,"Halski","Russian Blend","115"]
[null,null,"Nowak",35,30,10,45,30,null,null,45,35,65,null,null,25,15,null,null,"Grabowski","Jasmine","15",null,"","",""]
[null,null,"Urbaniak",null,20,30,25,40,15,35,15,10,80,20,15,30,10,null,null,"Halski","Gunpowder","15",null,"","",""]
[null,null,"Zieliński",30,20,null,null,25,30,10,40,20,55,20,10,60,40,null,null,"Kowalski","Black Lychee","15",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kowalski","Chunmee","15",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kowalski","Pi Lo Chun","15",null,"","",""]
[null,null,"ZADANIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nowak","Russian Blend","15",null,"","",""]
[null,null,"1. Napisz makro, które na podstawie danych w arkuszu 1 tworzy w arkuszu 2 tabelę danych, złożoną z trzech kolumn: pracownik, nazwa herbaty, ilość(w kg)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urbaniak","Dragonwell","15",null,"","",""]
[null,null,"2. Za pomocą  Tabeli przestawnej przekształć dane zebrane w Arkuszu2  do postaci z Arkusza1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urbaniak","Gyokuru","15",null,"","",""]
[null,null,"3. Napisz funkcję tablicową wyznaczjącą największe - co do trzech maksymalnych wartości - zamówienia ( wg ilości w kg) --------->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urbaniak","Oolong","15",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"maks1(ilość)","v":130},3,10,null,null,"","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"maks5",null,null,null,null,null,null,null,null,null,"maks3a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"maks5(ilość)","v":130},120,115,110,95,null,{"$f":"mini3(pracownik,herbata,ilość)","v":"Górecki"},"Black Lychee","10",null,{"$f":"maks3a(pracownik,herbata,ilość)","v":"Grabowski"},"Keemun","130"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nowak","Ceylon","10",null,"Lipiński","Chunmee","120"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kowalski","Gunpowder","10",null,"Dąbrowski","Darjeeling","115"]
[null,null,"Dąbrowski",null,null,"Górecki",null,null,"Grabowski",null,null,null,null,{"$f":"LARGE(ilość,2)","v":120},{"$f":"maxk(ilość,2)","v":120},null,null,null,null,"Zieliński","Gunpowder","10",null,"Dąbrowski","Keemun","115"]
[null,1,{"$f":"wypisz_herbatę(C28,pracownik,herbata,ilość)","v":"Assam"},55,null,{"$f":"wypisz_herbatę(F28,pracownik,herbata,ilość)","v":"Black Lychee"},10,null,{"$f":"wypisz_herbatę(I28,pracownik,herbata,ilość)","v":"Assam"},70,null,null,null,null,null,null,null,null,null,"Dąbrowski","Jasmine","10",null,"Halski","Russian Blend","115"]
[null,2,"Black Lychee",20,null,"Ceylon",35,null,"Ceylon",15,null,null,null,null,null,null,null,null,null,"Kowalski","Jasmine","10",null,"","",""]
[null,3,"Ceylon",30,null,"Chunmee",15,null,"Chunmee",50,null,null,null,null,null,null,null,null,null,"Urbaniak","Jasmine","10",null,"","",""]
[null,4,"Chunmee",50,null,"Darjeeling",110,null,"Darjeeling",65,null,null,null,null,null,null,null,null,null,"Zieliński","Oolong","10",null,"","",""]
[null,5,"Darjeeling",115,null,"Dragonwell",20,null,"Dragonwell",35,null,null,null,null,null,null,null,null,null,"Urbaniak","Russian Blend","10",null,"","",""]
[null,6,"Dragonwell",60,null,"Gunpowder",45,null,"Gunpowder",15,null,null,null,null,null,null,null,null,null,"Kowalski","Black Lychee","15",null,"","",""]
[null,7,"Gunpowder",35,null,"Gyokuru",15,null,"Gyokuru",40,null,null,null,null,null,null,null,null,null,"Grabowski","Ceylon","15",null,"","",""]
[null,8,"Gyokuru",45,null,"Jasmine",25,null,"Jasmine",15,null,null,null,null,null,null,null,null,null,"Górecki","Chunmee","15",null,"","",""]
[null,9,"Jasmine",10,null,"Keemun",50,null,"Keemun",130,null,null,null,null,null,null,null,null,null,"Kowalski","Chunmee","15",null,"","",""]
[null,10,"Keemun",115,null,"Lapsang Souchong",65,null,"Oolong",50,null,null,null,null,null,null,null,null,null,"Urbaniak","Dragonwell","15",null,"","",""]
[null,11,"Lapsang Souchong",35,null,"Oolong",60,null,"Pi Lo Chun",45,null,null,null,null,null,null,null,null,null,"Grabowski","Gunpowder","15",null,"","",""]
[null,12,"Oolong",60,null,"Pi Lo Chun",25,null,"Russian Blend",55,null,null,null,null,null,null,null,null,null,"Halski","Gunpowder","15",null,"","",""]
[null,13,"Pi Lo Chun",15,null,"Russian Blend",90,null,0,0,null,null,null,null,null,null,null,null,null,"Górecki","Gyokuru","15",null,"","",""]
[null,14,"Russian Blend",55,null,0,0,null,0,0,null,null,null,null,null,null,null,null,null,"Urbaniak","Gyokuru","15",null,"","",""]
[null,null,null,{"$f":"SUM(D29:D42)","v":700},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grabowski","Jasmine","15",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urbaniak","Oolong","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dąbrowski","Pi Lo Chun","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kowalski","Pi Lo Chun","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nowak","Russian Blend","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dąbrowski","Black Lychee","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urbaniak","Black Lychee","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zieliński","Black Lychee","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Górecki","Dragonwell","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Halski","Gyokuru","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zieliński","Jasmine","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urbaniak","Lapsang Souchong","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zieliński","Lapsang Souchong","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]

{"sheet":"Arkusz2","index":2,"n_rows":27,"n_cols":22,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Pracownik","nazwa herbaty","ilość (kg)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Suma z ilość (kg)"]
[null,null,null,null,null,null,null,null,"Assam","Black Lychee","Ceylon","Chunmee","Darjeeling","Dragonwell","Gunpowder","Gyokuru","Jasmine","Keemun","Lapsang Souchong","Oolong","Pi Lo Chun","Russian Blend"]
[null,null,null,null,null,null,null,"Dąbrowski",55,20,30,50,115,60,35,45,10,115,35,60,15,55]
[null,null,null,null,null,null,null,"Górecki",null,10,35,15,110,20,45,15,25,50,65,60,25,90]
[null,null,null,null,null,null,null,"Grabowski",70,null,15,50,65,35,15,40,15,130,null,50,45,55]
[null,null,null,null,null,null,null,"Halski",45,75,null,30,95,45,15,20,60,85,25,60,50,115]
[null,null,null,null,null,null,null,"Kowalski",null,15,null,15,null,35,10,30,10,30,45,40,15,25]
[null,null,null,null,null,null,null,"Lipiński",50,95,65,120,80,45,70,70,90,90,30,70,95,85]
[null,null,null,null,null,null,null,"Nowak",35,30,10,45,30,null,null,45,35,65,null,null,25,15]
[null,null,null,null,null,null,null,"Urbaniak",null,20,30,25,40,15,35,15,10,80,20,15,30,10]
[null,null,null,null,null,null,null,"Zieliński",30,20,null,null,25,30,10,40,20,55,20,10,60,40]

{"sheet":"Arkusz3","index":3,"n_rows":113,"n_cols":3,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
["Pracownik","nazwa herbaty","ilość (kg)"]
["Dąbrowski","Assam",55]
["Grabowski","Assam",70]
["Halski","Assam",45]
["Lipiński","Assam",50]
["Nowak","Assam",35]
["Zieliński","Assam",30]
["Dąbrowski","Black Lychee",20]
["Górecki","Black Lychee",10]
["Halski","Black Lychee",75]
["Kowalski","Black Lychee",15]
["Lipiński","Black Lychee",95]
["Nowak","Black Lychee",30]
["Urbaniak","Black Lychee",20]
["Zieliński","Black Lychee",20]
["Dąbrowski","Ceylon",30]
["Górecki","Ceylon",35]
["Grabowski","Ceylon",15]
["Lipiński","Ceylon",65]
["Nowak","Ceylon",10]
["Urbaniak","Ceylon",30]
["Dąbrowski","Chunmee",50]
["Górecki","Chunmee",15]
["Grabowski","Chunmee",50]
["Halski","Chunmee",30]
["Kowalski","Chunmee",15]
["Lipiński","Chunmee",120]
["Nowak","Chunmee",45]
["Urbaniak","Chunmee",25]
["Dąbrowski","Darjeeling",115]
["Górecki","Darjeeling",110]
["Grabowski","Darjeeling",65]
["Halski","Darjeeling",95]
["Lipiński","Darjeeling",80]
["Nowak","Darjeeling",30]
["Urbaniak","Darjeeling",40]
["Zieliński","Darjeeling",25]
["Dąbrowski","Dragonwell",60]
["Górecki","Dragonwell",20]
["Grabowski","Dragonwell",35]
["Halski","Dragonwell",45]
["Kowalski","Dragonwell",35]
["Lipiński","Dragonwell",45]
["Urbaniak","Dragonwell",15]
["Zieliński","Dragonwell",30]
["Dąbrowski","Gunpowder",35]
["Górecki","Gunpowder",45]
["Grabowski","Gunpowder",15]
["Halski","Gunpowder",15]
["Kowalski","Gunpowder",10]
["Lipiński","Gunpowder",70]
["Urbaniak","Gunpowder",35]
["Zieliński","Gunpowder",10]
["Dąbrowski","Gyokuru",45]
["Górecki","Gyokuru",15]
["Grabowski","Gyokuru",40]
["Halski","Gyokuru",20]
["Kowalski","Gyokuru",30]
["Lipiński","Gyokuru",70]
["Nowak","Gyokuru",45]
["Urbaniak","Gyokuru",15]
["Zieliński","Gyokuru",40]
["Dąbrowski","Jasmine",10]
["Górecki","Jasmine",25]
["Grabowski","Jasmine",15]
["Halski","Jasmine",60]
["Kowalski","Jasmine",10]
["Lipiński","Jasmine",90]
["Nowak","Jasmine",35]
["Urbaniak","Jasmine",10]
["Zieliński","Jasmine",20]
["Dąbrowski","Keemun",115]
["Górecki","Keemun",50]
["Grabowski","Keemun",130]
["Halski","Keemun",85]
["Kowalski","Keemun",30]
["Lipiński","Keemun",90]
["Nowak","Keemun",65]
["Urbaniak","Keemun",80]
["Zieliński","Keemun",55]
["Dąbrowski","Lapsang Souchong",35]
["Górecki","Lapsang Souchong",65]
["Halski","Lapsang Souchong",25]
["Kowalski","Lapsang Souchong",45]
["Lipiński","Lapsang Souchong",30]
["Urbaniak","Lapsang Souchong",20]
["Zieliński","Lapsang Souchong",20]
["Dąbrowski","Oolong",60]
["Górecki","Oolong",60]
["Grabowski","Oolong",50]
["Halski","Oolong",60]
["Kowalski","Oolong",40]
["Lipiński","Oolong",70]
["Urbaniak","Oolong",15]
["Zieliński","Oolong",10]
["Dąbrowski","Pi Lo Chun",15]
["Górecki","Pi Lo Chun",25]
["Grabowski","Pi Lo Chun",45]
["Halski","Pi Lo Chun",50]
["Kowalski","Pi Lo Chun",15]
["Lipiński","Pi Lo Chun",95]
["Nowak","Pi Lo Chun",25]
["Urbaniak","Pi Lo Chun",30]
["Zieliński","Pi Lo Chun",60]
["Dąbrowski","Russian Blend",55]
["Górecki","Russian Blend",90]
["Grabowski","Russian Blend",55]
["Halski","Russian Blend",115]
["Kowalski","Russian Blend",25]
["Lipiński","Russian Blend",85]
["Nowak","Russian Blend",15]
["Urbaniak","Russian Blend",10]
["Zieliński","Russian Blend",40]