{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["intro","task01","task02"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"intro","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"ustaw uruchamianie makr"]
[null,"enable macros"]
[]
[null,null,"Wpisz imię i nazwisko (enter your Name)"]
[]
[null,null,"wciśnij enter (press enter)",null,null,null,null,"metoda 1 statyczne suma i pochodna z niej  suma warunków"]
[null,null,"zmień język / change language",null,null,null,null,"metoda 2 dynamiczne sumy częściowe z filtrem"]
[null,null,"Polski",null,null,null,null,"metoda 3 BD.suma"]
[null,null,"wciśnij przycisk poniżej (click the button below)",null,null,null,null,"metoda 4 zaznacz blokiem i odczytaj z paska stanu"]
[null,null,null,null,null,null,null,"metoda 5 "]

{"sheet":"task01","index":1,"n_rows":105,"n_cols":255,"rows_kept":105,"cut":false,"hidden":true,"merged":[]}
[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,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,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,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,"aaa 2011-01-23 14:06:58"]
[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,"Name","Annual_Salary","Monthly_Salary","Location","Date Hired","Pension fund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID","Imię","Nazwisko","Roczne zarobki","Miesięczne zarobki","Miejscowość","Data zatrudnienia","PPE","Płeć",null,null,null,"zacznij od warunku"]
[null,"James Millen",27690,{"$f":"C5/12","v":2307.5},"Los Angeles","1994-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()-4","v":1},"Adam","Jantar",{"$f":"AC5*12","v":58272},4856,"Poznań","2013-02-01",false,"M",null,null,null,"metoda 1 statyczne suma i pochodna z niej  suma warunków"]
[null,"Thomas E. Abbott",60000,5000,"Los Angeles","1995-01-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()-4","v":2},"Alina","Kuna",74532,6211,"Kraków","2006-09-13",false,"K",null,null,null,"metoda 2 dynamiczne sumy częściowe z filtrem"]
[null,"Chris Poundsworth",29850,2487.5,"Seattle","1999-03-24",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Cezary","Piórkowski",69480,5790,"Wrocław","1998-07-19",true,"M",null,null,null,"metoda 3 BD.suma"]
[null,"Richard E. Card",43000,3583.3333333333335,"Seattle","1999-04-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Ewa","Nowek",47304,3942,"Poznań","2003-02-06",false,"K",null,null,null,"metoda 4 zaznacz blokiem i odczytaj z paska stanu"]
[null,"Douglas Williams",89687,7473.916666666667,"Portland","1999-10-15",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Iwona","Laskowska",85680,7140,"Wrocław","2006-05-12",true,"K",null,null,null,"metoda 5 "]
[null,"Phillip A. Todd",29500,2458.3333333333335,"Portland","1999-10-15",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Jan","Brzytwa",67284,5607,"Poznań","2011-08-16",true,"M"]
[null,"Anthony Taylor",55500,4625,"Los Angeles","2000-02-11",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Jan","Nowicki",81060,6755,"Wrocław","2009-09-11",true,"M"]
[null,"Rick Fogerty",89873,7489.416666666667,"Portland","2000-04-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Janina","Belkowa",27600,2300,"Wrocław","2006-03-06",false,"K"]
[null,"Stephen C. Carter",44123,3676.9166666666665,"Los Angeles","2000-07-10",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Joanna","Wysocka",57768,4814,"Poznań","2005-12-25",true,"K",null,null,null,"Kraków",{"$f":"SUMIFS($AB$5:$AB$24,$AD$5:$AD$24,AK13)","v":288000}]
[null,"Ivan Silberstein",95000,7916.666666666667,"Los Angeles","2000-09-11",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Joanna","Zimowa",64500,5375,"Wrocław","1996-08-14",false,"K",null,null,null,"Wrocław",{"$f":"SUMIFS($AB$5:$AB$24,$AD$5:$AD$24,AK14)","v":453000}]
[null,"Joe Morrison",24000,2000,"Seattle","2000-12-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Marta","Domerecka",68616,5718,"Poznań","2005-05-28",true,"K",null,null,null,"Poznań",522000]
[null,"Robert H. Miller",149000,12416.666666666666,"Portland","2001-02-09",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Paweł","Gaweł",75600,6300,"Poznań","2010-09-13",false,"M"]
[null,"Michael Hayden",78230,6519.166666666667,"Seattle","2001-03-12",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Paweł","Kitera",27816,2318,"Kraków","2005-05-16",true,"M"]
[null,"John T. Foster",39500,3291.6666666666665,"Seattle","2001-07-21",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Paweł","Pawlak",70308,5859,"Wrocław","2003-09-22",false,"M"]
[null,"Steven H. Katz",32900,2741.6666666666665,"Los Angeles","2001-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Piotr","Konopnicki",53676,4473,"Kraków","2009-04-18",false,"M"]
[null,"Jeffrey P. Jones",42000,3500,"Seattle","2002-01-19",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Radosław","Czerkawski",54372,4531,"Wrocław","2008-02-24",false,"M"]
[null,"Clark Bickerson",120000,10000,"Los Angeles","2002-01-29",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Rafał","Janowski",68232,5686,"Kraków","2004-08-16",true,"M"]
[null,"Charles S. Billings",39000,3250,"Los Angeles","2002-08-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Stefan","Burczymucha",112296,9358,"Poznań","2003-06-09",false,"M"]
[null,"Kurt Kamichoff",48000,4000,"Los Angeles","2002-08-17",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Wojciech","Szczerba",34860,2905,"Poznań","2005-10-01",false,"M",null,"dodaj niesortowalną kolumnę \"=WIERSZ()-4\""]
[null,"Tom Brown",65000,5416.666666666667,"Seattle","2003-03-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Zenon","Kowalski",63744,5312,"Kraków","2006-12-14",true,"M",null,"pole osoba nie jest atomowe"]
[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,"zamień obszar na tabelę "]
[]
[]
[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,"S T A T Y S T Y K A    C A Ł O Ś C I O W A",null,"    bez warunku"]
[null,null,null,null,"METHOD I",null,null,"METHOD II",null,null,null,"METHOD III",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metoda I",null,"Metoda II",null,null,"Metoda III","Tą część zrób na polecenie prowadzącego"]
[null,"Calculate",null,null,null,null,null,"add calculate",null,null,null,"add calculate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POLICZ",null,"a także",null,null,"a także jest możliwe stosowanie funkcji BD.xxx bez warunku"]
[1,"Sum of Annual Salary",null,null,null,"use =sum(",null,null,"=SUBTOTALS(9;…",null,null,null,"=DSUM(employee,\"Annual_Salary\",AH22:AH23)",null,null,null,null,null,null,null,null,null,null,null,null,1,"sumę pensji rocznych",null,"=SUMA(",null,"=SUMY.CZĘŚCIOWE(109;…",null,null,"=BD.SUMA(pracownicy;\"roczne zarobki\";AJ25:AJ26)"]
[2,"Sum of Monthly Sallary",null,null,null,"use =sum(",null,null,"=SUBTOTALS(1;…",null,null,null,"=DSUM(employee,\"monthly_Salary\",AH22:AH23)",null,null,null,null,null,null,null,null,null,null,null,null,2,"średnią pensję roczną",null,"=ŚREDNIA(",null,"=SUMY.CZĘŚCIOWE(101;…",null,null,"=BD.ŚREDNIA(pracownicy;\"miesięczne zarobki\";bez_warunku)"]
[3,"Average of Annual Sallary",null,null,null,"use =AVERAGE(",null,null,"=SUBTOTALS(9;…",null,null,null,"=DAVERAGE(",null,null,null,null,null,null,null,null,null,null,null,null,3,"min pensję roczną",null,"=MIN(",null,"=SUMY.CZĘŚCIOWE(105;…",null,null,"=BD.MAX(pracownicy;\"roczne zarobki\";bez_warunku)"]
[4,"first employment date",null,null,null,"=MIN(",null,null,"=SUBTOTALS(5;…",null,null,null,"=DMIN(",null,null,null,null,null,null,null,null,null,null,null,null,4,"max pensję roczną",null,"=MAX(",null,"=SUMY.CZĘŚCIOWE(104;…",null,null,"=BD.MIN(pracownicy;\"roczne zarobki\";bez_warunku)"]
[5,"last employment date",null,null,null,"=MAX(",null,null,"=SUBTOTALS(4;…",null,null,null,"=DMAX(",null,null,null,null,null,null,null,null,null,null,null,null,5,"sumę pensji miesięcznych",null,"=SUMA(",null,"=SUMY.CZĘŚCIOWE(109;…",null,null,"=BD."]
[6,"Count rows",null,null,null,"use =COUNT(",null,null,"=SUBTOTALS(4;…",null,null,null,"use =DCOUNT(",null,null,null,null,null,null,null,null,null,null,null,null,6,"najpóźniejsza data zatrudnienia",null,"=MAX(",null,"=SUMY.CZĘŚCIOWE(104;…",null,null,"=BD.MIN(pracownicy;\"data zatrudnienia\";bez_warunku)"]
[7,"Count rows",null,null,null,"use =COUNTA(",null,null,"=SUBTOTALS(5;…",null,null,null,"use =DCOUNTA(",null,null,null,null,null,null,null,null,null,null,null,null,7,"najwcześniejsza data zatrudnienia",null,"=MIN(",null,"=SUMY.CZĘŚCIOWE(105;…",null,null,"=BD.MAX(pracownicy;\"data zatrudnienia\";bez_warunku)"]
[]
[]
[]
[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,"podaj liczbę pensji policz wiersze"]
[8,null,null,null,null,"ile.liczb",null,null,"=SUMY.CZĘŚCIOWE(…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,"ile.liczb",null,"=SUMY.CZĘŚCIOWE(…",null,null,"=BD.ILE.REKORDÓW(.."]
[9,null,null,null,null,"ile.niepustych",null,null,"=SUMY.CZĘŚCIOWE(…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,"ile.niepustych",null,"=SUMY.CZĘŚCIOWE(…",null,null,"=BD.ILE.REKORDÓW.A(.."]
["9a",null,null,null,null,"ile.wierszy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9a",null,null,"ile.wierszy"]
[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,"Metoda III","Tą część zrób na polecenie prowadzącego"]
[null,"Conditions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S T O S O W A N I E      W A R U N K O W",null,"    jeden warunek czyli \"kryteria jednokolumnowe, jednowierszowe\""]
[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,"Metoda II działa w połączeniu z autofiltrem"]
[10,"Count persons from Los Angeles",null,null,null,"use =COUNTIFS(",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"liczba pracownikow w Krakowie",null,"=LICZ.WARUNKI($AD$5:$AD$24;\"kraków\")",null,null,null,null,"=BD.ILE.REKORDÓW.A(pracownicy;\"Osoba\";AM48:AM49)",null,null,null,null,"Miejscowość"]
[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,"dawniej          =LICZ.JEŻELI($AD$5:$AD$24;\"kraków\")",null,null,null,null,null,null,null,null,null,"kraków"]
[11,"Sum Annual Salary for Los Angeles",null,null,null,"use =SUMIFS(",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Suma pensji rocznych w Krakowie",null,"=SUMA.WARUNKÓW($AB$5:$AB$24;$AD$5:$AD$24;\"kraków\") najpierw suma potem warunków",null,null,null,null,"=BD.SUMA(pracownicy;\"roczne zarobki\";AM49:AM50)"]
[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,"dawniej      =SUMA.JEŻELI($AD$5:$AD$24;\"kraków\";$AB$5:$AB$24)"]
[12,"Sum budget include only people with Pension Fund set to True",null,null,null,"use SUMIFS(v2007+)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Suma pensji rocznych \npod warunkiem PPE=Prawda",null,"=SUMA.WARUNKÓW(…","dawniej =SUMA.JEŻELI",null,null,null,"=BD.SUMA(…",null,null,null,null,"PPE"]
[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,"LUB FORMUŁA TABLICOWA =SUMA(JEŻELI(…",null,null,null,null,null,null,null,null,null,false]
[]
[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,"S T O S O W A N I E      W A R U N K O W",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,"Metoda II działa w połączeniu z autofiltrem"]
[13,"Sum budget for Los Angeles include only people with Pension Fund set to True",null,null,null,"use SUMIFS(v2007+)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Sumę pensji rocznych w Krakowie pod warunkiem - PPE = fałsz",null,"=SUMA.WARUNKÓW($AB$4:$AB$23;$AD$4:$AD$23;\"Kraków\";$AF$4:$AF$23;FAŁSZ)",null,null,null,null,"=BD.SUMA(pracownicy;\"roczne zarobki\";AL58:AM59)"]
[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,"lub sprowadzenie sprawy do jednego warunku",null,null,null,null,null,null,null,null,"Miejscowość","PPE"]
[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,"kraków",false]
[]
[14,"the average annual salary for employees hired in 2000-2009",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"średnia pensja roczna dla zatrudnionych w latach 2000-2009",null,null,null,null,null,null,"=BD.średnia(…"]
[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,"Data zatrudnienia","Data zatrudnienia"]
[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,">=2000-1-1","<2010-1-1"]
[]
[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,"S T O S O W A N I E      W A R U N K O W",null,"    dwa warunki LUB() czyli inaczej \"kryteria jednokolumnowe, wielowierszowe\""]
[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,"Metoda II działa w połączeniu z autofiltrem"]
[15,"Sum Annual Salary for LA and PORTLAND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Suma pensji rocznych w Krakowie i Poznaniu wziętych razem",null,"=SUMA.WARUNKÓW($AB$5:$AB$24;$AD$5:$AD$24;\"<=poznań\")",null,null,null,null,"=BD.SUMA(pracownicy;\"roczne zarobki\";AM67:AM69)",null,null,null,null,"Miejscowość",null,"Miejscowość"]
[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,"to jest rozwiązanie z trikiem przez sprowadzenie dwóch warunków lub do warunku jednowierszowego jednokolumnowego",null,null,null,null,null,null,null,null,null,"Kraków",null,"<Poznań"]
[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,"OMÓW ZAMIANĘ POTOCZNEGO \"I\" NA LOGICZNE \"LUB\"",null,null,null,null,null,null,"osoba",null,"Poznań"]
[16,"The sum of the annual salary for those with the letter L or P in name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Suma pensji rocznych dla osób z literą ł lub p w polu osoba",null,"< trudne wymaga zastosowania Suma.warunków trzy razy",null,null,null,null,"=BD.SUMA(pracownicy;\"roczne zarobki\";AK67:AK69)",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,"*p*"]
[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,"Miejscowość","PPE"]
[null,"S T O S O W A N I E      W A R U N K O W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S T O S O W A N I E      W A R U N K O W",null,"    wiele warunków czyli inaczej \"kryteria wielokolumnowe, wielowierszowe\"",null,null,null,null,null,null,null,null,null,"Kraków",false]
[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,"Metoda II działa w połączeniu z FILTREM ZAAWANSOWANYM",null,null,null,null,null,null,null,null,"Poznań",true]
[17,"The sum of annual salary (Portland, Pension = False) or (Seattle, Pension = True)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Suma pensji rocznych w (Krakowie, PPE=Fałsz) lub (Poznaniu, PPE=Prawda) ",null,"< da się zrobić !!! Dla chętnych !!!!",null,null,null,null,"=BD.SUMA(pracownicy;\"roczne zarobki\";$AM$72:$AN$74)"]
[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,"Miejscowość","PPE","Roczne zarobki"]
[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,"Kraków"," "]
[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,true,"<52000"]
[18,"The sum of annual salary (Portland for employees after 2000-1-1 with annual earnings below 52,000) or (Portland for women with the letter \"w\" in  \"name\") or (Seattle men)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Suma pensji rocznych w (Krakowie dla zatrudnionych po 2000-1-1 z rocznymi zarobkami poniżej 52000) lub (Poznaniu dla kobiet z literą \"w\" w zbitce \"imię i nazwisko\") lub  (wrocławskich mężczyzn)",null,null,null,null,null,null,"=BD.SUMA(pracownicy;\"roczne zarobki\";$AL$80:$AO$83)"]
[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,"Osoba","Miejscowość","Płeć","Data zatrudnienia","Roczne zarobki"]
[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,"Kraków",null,">2000-1-1","<55000"]
[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,"*w*","Poznań","K"]
[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,"Wrocław","M"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,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,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,"aaa 2011-01-23 14:06:58"]

{"sheet":"task02","index":2,"n_rows":137,"n_cols":255,"rows_kept":137,"cut":false,"hidden":true,"merged":[]}
[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,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,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,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,"jaanx 2011-11-25 08:41:58"]
[]
[]
[null,"1. Apply List to the range below, insert the of row sums to the list. Make a filter that displays the employees in Los Angeles. In the subtotals row display the count of employees.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Ustaw tabelę w zakresie poniżej, wstaw wiersz sumy do listy. Zrób filtr który wyświetli pracownikow w Krakowie. W wierszu podsumowań wyświetl liczbę pracowników.  Metoda II SUMY.CZĘŚCIOWE"]
[]
[null,"Name","Annual_Salary","Monthly_Salary","Location","Date Hired","Pension fund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Osoba","Roczne zarobki","Miesięczne zarobki","Miejscowość","Data zatrudnienia","PPE"]
[null,"James Millen",27690,{"$f":"C7/12","v":2307.5},"Los Angeles","1994-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adam Jantar",{"$f":"AC7*12","v":58272},4856,"Poznań","2013-02-01",false,"M"]
[null,"Thomas E. Abbott",60000,5000,"Los Angeles","1995-01-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alina Kuna",73800,6150,"Kraków","2006-09-13",false,"K"]
[null,"Chris Poundsworth",29850,2487.5,"Seattle","1999-03-24",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cezary Piórkowski",69864,5822,"Wrocław","1998-07-19",true,"M"]
[null,"Richard E. Card",43000,3583.3333333333335,"Seattle","1999-04-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ewa Nowek",47304,3942,"Poznań","2003-02-06",false,"K"]
[null,"Douglas Williams",89687,7473.916666666667,"Portland","1999-10-15",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iwona Laskowska",85680,7140,"Wrocław","2006-05-12",true,"K"]
[null,"Phillip A. Todd",29500,2458.3333333333335,"Portland","1999-10-15",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan Brzytwa",67284,5607,"Poznań","2011-08-16",true,"M"]
[null,"Anthony Taylor",55500,4625,"Los Angeles","2000-02-11",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan Nowicki",82176,6848,"Wrocław","2009-09-11",true,"M"]
[null,"Rick Fogerty",89873,7489.416666666667,"Portland","2000-04-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Janina Belkowa",27600,2300,"Wrocław","2006-03-06",false,"K"]
[null,"Stephen C. Carter",44123,3676.9166666666665,"Los Angeles","2000-07-10",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanna Wysocka",57768,4814,"Poznań","2005-12-25",true,"K"]
[null,"Ivan Silberstein",95000,7916.666666666667,"Los Angeles","2000-09-11",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanna Zimowa",61296,5108,"Wrocław","1996-08-14",false,"K"]
[null,"Joe Morrison",24000,2000,"Seattle","2000-12-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marta Domerecka",68616,5718,"Poznań","2005-05-28",true,"K"]
[null,"Robert H. Miller",149000,12416.666666666666,"Portland","2001-02-09",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Gaweł",75600,6300,"Poznań","2010-09-13",false,"M"]
[null,"Michael Hayden",78230,6519.166666666667,"Seattle","2001-03-12",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Kitera",27816,2318,"Kraków","2005-05-16",true,"M"]
[null,"John T. Foster",39500,3291.6666666666665,"Seattle","2001-07-21",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Pawlak",69600,5800,"Wrocław","2003-09-22",false,"M"]
[null,"Steven H. Katz",32900,2741.6666666666665,"Los Angeles","2001-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piotr Konopnicki",53640,4470,"Kraków","2009-04-18",false,"M"]
[null,"Jeffrey P. Jones",42000,3500,"Seattle","2002-01-19",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radosław Czerkawski",54552,4546,"Wrocław","2008-02-24",false,"M"]
[null,"Clark Bickerson",120000,10000,"Los Angeles","2002-01-29",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rafał Janowski",68232,5686,"Wrocław","2004-08-16",true,"M"]
[null,"Charles S. Billings",39000,3250,"Los Angeles","2002-08-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stefan Burczymucha",112296,9358,"Poznań","2003-06-09",false,"M"]
[null,"Kurt Kamichoff",48000,4000,"Los Angeles","2002-08-17",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wojciech Szczerba",34860,2905,"Poznań","2005-10-01",false,"M"]
[null,"Tom Brown",65000,5416.666666666667,"Seattle","2003-03-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zenon Kowalski",63744,5312,"Kraków","2006-12-14",true,"M"]
[]
[]
[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,"Metoda I = LICZ.WARUNKI"]
[]
[null,"2. Apply List to the range below, insert the of row sums to the list. Make a filter that displays the employees in Seattle. In the subtotals row display the sum of annual_salary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Ustaw tabelę w zakresie poniżej, wstaw wiersz sumy do listy. Zrób filtr który wyświetli pracownikow w Poznaniu. W wierszu podsumowań wyświetl sumę pensji rocznych.  Metoda II SUMY.CZĘŚCIOWE"]
[]
[null,"Name","Annual_Salary","Monthly_Salary","Location","Date Hired","Pension fund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Osoba","Roczne zarobki","Miesięczne zarobki","Miejscowość","Data zatrudnienia","PPE","Płeć"]
[null,"James Millen",27690,{"$f":"C34/12","v":2307.5},"Los Angeles","1994-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adam Jantar",{"$f":"AC34*12","v":58272},4856,"Poznań","2013-02-01",false,"M"]
[null,"Thomas E. Abbott",60000,5000,"Los Angeles","1995-01-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alina Kuna",73800,6150,"Kraków","2006-09-13",false,"K"]
[null,"Chris Poundsworth",29850,2487.5,"Seattle","1999-03-24",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cezary Piórkowski",69864,5822,"Wrocław","1998-07-19",true,"M"]
[null,"Richard E. Card",43000,3583.3333333333335,"Seattle","1999-04-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ewa Nowek",47304,3942,"Poznań","2003-02-06",false,"K"]
[null,"Douglas Williams",89687,7473.916666666667,"Portland","1999-10-15",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iwona Laskowska",85680,7140,"Wrocław","2006-05-12",true,"K"]
[null,"Phillip A. Todd",29500,2458.3333333333335,"Portland","1999-10-15",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan Brzytwa",67284,5607,"Poznań","2011-08-16",true,"M"]
[null,"Anthony Taylor",55500,4625,"Los Angeles","2000-02-11",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan Nowicki",82176,6848,"Wrocław","2009-09-11",true,"M"]
[null,"Rick Fogerty",89873,7489.416666666667,"Portland","2000-04-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Janina Belkowa",27600,2300,"Wrocław","2006-03-06",false,"K"]
[null,"Stephen C. Carter",44123,3676.9166666666665,"Los Angeles","2000-07-10",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanna Wysocka",57768,4814,"Poznań","2005-12-25",true,"K"]
[null,"Ivan Silberstein",95000,7916.666666666667,"Los Angeles","2000-09-11",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanna Zimowa",61296,5108,"Wrocław","1996-08-14",false,"K"]
[null,"Joe Morrison",24000,2000,"Seattle","2000-12-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marta Domerecka",68616,5718,"Poznań","2005-05-28",true,"K"]
[null,"Robert H. Miller",149000,12416.666666666666,"Portland","2001-02-09",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Gaweł",75600,6300,"Poznań","2010-09-13",false,"M"]
[null,"Michael Hayden",78230,6519.166666666667,"Seattle","2001-03-12",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Kitera",27816,2318,"Kraków","2005-05-16",true,"M"]
[null,"John T. Foster",39500,3291.6666666666665,"Seattle","2001-07-21",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Pawlak",69600,5800,"Wrocław","2003-09-22",false,"M"]
[null,"Steven H. Katz",32900,2741.6666666666665,"Los Angeles","2001-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piotr Konopnicki",53640,4470,"Kraków","2009-04-18",false,"M"]
[null,"Jeffrey P. Jones",42000,3500,"Seattle","2002-01-19",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radosław Czerkawski",54552,4546,"Wrocław","2008-02-24",false,"M"]
[null,"Clark Bickerson",120000,10000,"Los Angeles","2002-01-29",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rafał Janowski",68232,5686,"Wrocław","2004-08-16",true,"M"]
[null,"Charles S. Billings",39000,3250,"Los Angeles","2002-08-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stefan Burczymucha",112296,9358,"Poznań","2003-06-09",false,"M"]
[null,"Kurt Kamichoff",48000,4000,"Los Angeles","2002-08-17",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wojciech Szczerba",34860,2905,"Poznań","2005-10-01",false,"M"]
[null,"Tom Brown",65000,5416.666666666667,"Seattle","2003-03-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zenon Kowalski",63744,5312,"Kraków","2006-12-14",true,"M"]
[]
[]
[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,"Metoda I = SUMA.WARUNKÓW"]
[]
[null,"3. Apply List to the range below, insert the of row sums to the list. Make a filter that displays the employees in Portland. In the subtotals row display the average of monthly_salary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Ustaw tabelę w zakresie poniżej, wstaw wiersz sumy do listy. Zrób filtr który wyświetli pracownikow w Poznaniu. W wierszu podsumowań wyświetl średnią pensję miesięczną.  Metoda II"]
[]
[null,"Name","Annual_Salary","Monthly_Salary","Location","Date Hired","Pension fund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Osoba","Roczne zarobki","Miesięczne zarobki","Miejscowość","Data zatrudnienia","PPE","Płeć"]
[null,"James Millen",27690,{"$f":"C61/12","v":2307.5},"Los Angeles","1994-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adam Jantar",{"$f":"AC61*12","v":58272},4856,"Poznań","2013-02-01",false,"M"]
[null,"Thomas E. Abbott",60000,5000,"Los Angeles","1995-01-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alina Kuna",73800,6150,"Kraków","2006-09-13",false,"K"]
[null,"Chris Poundsworth",29850,2487.5,"Seattle","1999-03-24",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cezary Piórkowski",69864,5822,"Wrocław","1998-07-19",true,"M"]
[null,"Richard E. Card",43000,3583.3333333333335,"Seattle","1999-04-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ewa Nowek",47304,3942,"Poznań","2003-02-06",false,"K"]
[null,"Douglas Williams",89687,7473.916666666667,"Portland","1999-10-15",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iwona Laskowska",85680,7140,"Wrocław","2006-05-12",true,"K"]
[null,"Phillip A. Todd",29500,2458.3333333333335,"Portland","1999-10-15",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan Brzytwa",67284,5607,"Poznań","2011-08-16",true,"M"]
[null,"Anthony Taylor",55500,4625,"Los Angeles","2000-02-11",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan Nowicki",82176,6848,"Wrocław","2009-09-11",true,"M"]
[null,"Rick Fogerty",89873,7489.416666666667,"Portland","2000-04-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Janina Belkowa",27600,2300,"Wrocław","2006-03-06",false,"K"]
[null,"Stephen C. Carter",44123,3676.9166666666665,"Los Angeles","2000-07-10",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanna Wysocka",57768,4814,"Poznań","2005-12-25",true,"K"]
[null,"Ivan Silberstein",95000,7916.666666666667,"Los Angeles","2000-09-11",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanna Zimowa",61296,5108,"Wrocław","1996-08-14",false,"K"]
[null,"Joe Morrison",24000,2000,"Seattle","2000-12-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marta Domerecka",68616,5718,"Poznań","2005-05-28",true,"K"]
[null,"Robert H. Miller",149000,12416.666666666666,"Portland","2001-02-09",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Gaweł",75600,6300,"Poznań","2010-09-13",false,"M"]
[null,"Michael Hayden",78230,6519.166666666667,"Seattle","2001-03-12",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Kitera",27816,2318,"Kraków","2005-05-16",true,"M"]
[null,"John T. Foster",39500,3291.6666666666665,"Seattle","2001-07-21",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Pawlak",69600,5800,"Wrocław","2003-09-22",false,"M"]
[null,"Steven H. Katz",32900,2741.6666666666665,"Los Angeles","2001-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piotr Konopnicki",53640,4470,"Kraków","2009-04-18",false,"M"]
[null,"Jeffrey P. Jones",42000,3500,"Seattle","2002-01-19",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radosław Czerkawski",54552,4546,"Wrocław","2008-02-24",false,"M"]
[null,"Clark Bickerson",120000,10000,"Los Angeles","2002-01-29",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rafał Janowski",68232,5686,"Wrocław","2004-08-16",true,"M"]
[null,"Charles S. Billings",39000,3250,"Los Angeles","2002-08-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stefan Burczymucha",112296,9358,"Poznań","2003-06-09",false,"M"]
[null,"Kurt Kamichoff",48000,4000,"Los Angeles","2002-08-17",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wojciech Szczerba",34860,2905,"Poznań","2005-10-01",false,"M",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,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,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,"jaanx 2011-11-25 08:41:58"]
[null,"Tom Brown",65000,5416.666666666667,"Seattle","2003-03-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zenon Kowalski",63744,5312,"Kraków","2006-12-14",true,"M"]
[]
[]
[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,"Metoda I = ŚREDNIA.WARUNKÓW"]
[]
[null,"4. Apply List to the range below, insert the of row sums to the list. Make a filter that displays person with the leter m in the name. In the subtotals row display the minimum of monthly_salary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Ustaw tabelę w zakresie poniżej, wstaw wiersz sumy do listy. Zrób filtr który wyświetli pracownikow z literą cz w imieniu+nazwisku. W wierszu podsumowań wyświetl sumę pensji miesięcznych"]
[]
[null,"Name","Annual_Salary","Monthly_Salary","Location","Date Hired","Pension fund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Osoba","Roczne zarobki","Miesięczne zarobki","Miejscowość","Data zatrudnienia","PPE","Płeć"]
[null,"James Millen",27690,{"$f":"C88/12","v":2307.5},"Los Angeles","1994-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adam Jantar",{"$f":"AC88*12","v":58272},4856,"Poznań","2013-02-01",false,"M"]
[null,"Thomas E. Abbott",60000,5000,"Los Angeles","1995-01-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alina Kuna",73800,6150,"Kraków","2006-09-13",false,"K"]
[null,"Chris Poundsworth",29850,2487.5,"Seattle","1999-03-24",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cezary Piórkowski",69864,5822,"Wrocław","1998-07-19",true,"M"]
[null,"Richard E. Card",43000,3583.3333333333335,"Seattle","1999-04-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ewa Nowek",47304,3942,"Poznań","2003-02-06",false,"K"]
[null,"Douglas Williams",89687,7473.916666666667,"Portland","1999-10-15",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iwona Laskowska",85680,7140,"Wrocław","2006-05-12",true,"K"]
[null,"Phillip A. Todd",29500,2458.3333333333335,"Portland","1999-10-15",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan Brzytwa",67284,5607,"Poznań","2011-08-16",true,"M"]
[null,"Anthony Taylor",55500,4625,"Los Angeles","2000-02-11",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan Nowicki",82176,6848,"Wrocław","2009-09-11",true,"M"]
[null,"Rick Fogerty",89873,7489.416666666667,"Portland","2000-04-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Janina Belkowa",27600,2300,"Wrocław","2006-03-06",false,"K"]
[null,"Stephen C. Carter",44123,3676.9166666666665,"Los Angeles","2000-07-10",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanna Wysocka",57768,4814,"Poznań","2005-12-25",true,"K"]
[null,"Ivan Silberstein",95000,7916.666666666667,"Los Angeles","2000-09-11",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanna Zimowa",61296,5108,"Wrocław","1996-08-14",false,"K"]
[null,"Joe Morrison",24000,2000,"Seattle","2000-12-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marta Domerecka",68616,5718,"Poznań","2005-05-28",true,"K"]
[null,"Robert H. Miller",149000,12416.666666666666,"Portland","2001-02-09",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Gaweł",75600,6300,"Poznań","2010-09-13",false,"M"]
[null,"Michael Hayden",78230,6519.166666666667,"Seattle","2001-03-12",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Kitera",27816,2318,"Kraków","2005-05-16",true,"M"]
[null,"John T. Foster",39500,3291.6666666666665,"Seattle","2001-07-21",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Pawlak",69600,5800,"Wrocław","2003-09-22",false,"M"]
[null,"Steven H. Katz",32900,2741.6666666666665,"Los Angeles","2001-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piotr Konopnicki",53640,4470,"Kraków","2009-04-18",false,"M"]
[null,"Jeffrey P. Jones",42000,3500,"Seattle","2002-01-19",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radosław Czerkawski",54552,4546,"Wrocław","2008-02-24",false,"M"]
[null,"Clark Bickerson",120000,10000,"Los Angeles","2002-01-29",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rafał Janowski",68232,5686,"Wrocław","2004-08-16",true,"M"]
[null,"Charles S. Billings",39000,3250,"Los Angeles","2002-08-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stefan Burczymucha",112296,9358,"Poznań","2003-06-09",false,"M"]
[null,"Kurt Kamichoff",48000,4000,"Los Angeles","2002-08-17",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wojciech Szczerba",34860,2905,"Poznań","2005-10-01",false,"M"]
[null,"Tom Brown",65000,5416.666666666667,"Seattle","2003-03-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zenon Kowalski",63744,5312,"Kraków","2006-12-14",true,"M"]
[]
[]
[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,"Metoda I "]
[]
[null,"5. Apply List to the range below, insert the of row sums to the list. Make a filter that displays person hired before 2002-1-1. In the subtotals row display the maximum of monthly_salary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Ustaw tabelę w zakresie poniżej, wstaw wiersz sumy do listy. Zrób filtr który wyświetli pracownikow zatrudnionych przed 2000-1-1.  W wierszu podsumowań wyświetl sumę pensji miesięcznych."]
[]
[null,"Name","Annual_Salary","Monthly_Salary","Location","Date Hired","Pension fund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Osoba","Roczne zarobki","Miesięczne zarobki","Miejscowość","Data zatrudnienia","PPE","Płeć"]
[null,"James Millen",27690,{"$f":"C115/12","v":2307.5},"Los Angeles","1994-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adam Jantar",{"$f":"AC115*12","v":58272},4856,"Poznań","2013-02-01",false,"M"]
[null,"Thomas E. Abbott",60000,5000,"Los Angeles","1995-01-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alina Kuna",73800,6150,"Kraków","2006-09-13",false,"K"]
[null,"Chris Poundsworth",29850,2487.5,"Seattle","1999-03-24",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cezary Piórkowski",69864,5822,"Wrocław","1998-07-19",true,"M"]
[null,"Richard E. Card",43000,3583.3333333333335,"Seattle","1999-04-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ewa Nowek",47304,3942,"Poznań","2003-02-06",false,"K"]
[null,"Douglas Williams",89687,7473.916666666667,"Portland","1999-10-15",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iwona Laskowska",85680,7140,"Wrocław","2006-05-12",true,"K"]
[null,"Phillip A. Todd",29500,2458.3333333333335,"Portland","1999-10-15",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan Brzytwa",67284,5607,"Poznań","2011-08-16",true,"M"]
[null,"Anthony Taylor",55500,4625,"Los Angeles","2000-02-11",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan Nowicki",82176,6848,"Wrocław","2009-09-11",true,"M"]
[null,"Rick Fogerty",89873,7489.416666666667,"Portland","2000-04-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Janina Belkowa",27600,2300,"Wrocław","2006-03-06",false,"K"]
[null,"Stephen C. Carter",44123,3676.9166666666665,"Los Angeles","2000-07-10",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanna Wysocka",57768,4814,"Poznań","2005-12-25",true,"K"]
[null,"Ivan Silberstein",95000,7916.666666666667,"Los Angeles","2000-09-11",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joanna Zimowa",61296,5108,"Wrocław","1996-08-14",false,"K"]
[null,"Joe Morrison",24000,2000,"Seattle","2000-12-22",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marta Domerecka",68616,5718,"Poznań","2005-05-28",true,"K"]
[null,"Robert H. Miller",149000,12416.666666666666,"Portland","2001-02-09",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Gaweł",75600,6300,"Poznań","2010-09-13",false,"M"]
[null,"Michael Hayden",78230,6519.166666666667,"Seattle","2001-03-12",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Kitera",27816,2318,"Kraków","2005-05-16",true,"M"]
[null,"John T. Foster",39500,3291.6666666666665,"Seattle","2001-07-21",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paweł Pawlak",69600,5800,"Wrocław","2003-09-22",false,"M"]
[null,"Steven H. Katz",32900,2741.6666666666665,"Los Angeles","2001-12-26",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piotr Konopnicki",53640,4470,"Kraków","2009-04-18",false,"M"]
[null,"Jeffrey P. Jones",42000,3500,"Seattle","2002-01-19",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radosław Czerkawski",54552,4546,"Wrocław","2008-02-24",false,"M"]
[null,"Clark Bickerson",120000,10000,"Los Angeles","2002-01-29",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rafał Janowski",68232,5686,"Wrocław","2004-08-16",true,"M"]
[null,"Charles S. Billings",39000,3250,"Los Angeles","2002-08-13",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stefan Burczymucha",112296,9358,"Poznań","2003-06-09",false,"M"]
[null,"Kurt Kamichoff",48000,4000,"Los Angeles","2002-08-17",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wojciech Szczerba",34860,2905,"Poznań","2005-10-01",false,"M"]
[null,"Tom Brown",65000,5416.666666666667,"Seattle","2003-03-08",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zenon Kowalski",63744,5312,"Kraków","2006-12-14",true,"M"]
[]
[]
[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,"Metoda I "]