{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Zadanie","Arkusz1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":15,"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":"Zadanie","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Arkusz zawiera spis zamówień długopisów i cienkopisów pewnej hurtowni. W przypadku zamówień "]
[null," -","powyżej 1000 sztuk długopisów i ciekopisów łącznie albo gdy"]
[null," -","koszt zamówienia jest większy niż 1000 zł"]
[null,"kupujący dostaje rabat w wysokości 10% zamówienia."]
[null,"1.","Napisać funkcję, która wyznacza wielkość rabatu dla zamówienia. W przypadku braku rabatu wpisać 0."]
[null,null,"Wywołać funkcję w Excelu dla poszczególnych zamówień w kolumnie H."]
[null,"2.","Napisać makro, które wyznacza to samo co funkcja w p.1."]
[null,null,"Po wybraniu komórki D6 (ActiveCell) makro po uruchomieniu powinno wpisać wynik do komórki I6"]
[null,null,"i  ustawić aktywną komórkę na D7. Kolejne uruchomienia makra powinny wpisać wyniki w kolumnie I."]
[null,"3.","Napisać funkcję określającą koszt zamówienia z uwzględnieniem rabatu."]
[null,null,"Wykorzystać funkcję z punktu 1 wywołując ją z poziomu Visual Basica."]
[null,"4.","Napisać funkcję, która na podstawie ilości sztuk długopisów i cienkopisów łącznie określa wielkość "]
[null,null,"zamówienia przymiotnikami małe, średnie, duże i bardzo duże zgodnie z tabelą:"]
[]
[null,null,null,"ilość sztuk razem","wielkość zamówienia"]
[null,null,null,"do 999","małe"]
[null,null,null,"od 1000 do 1999","średnie"]
[null,null,null,"od 2000 do 2999","duże"]
[null,null,null,"od 3000 wzwyż","bardzo duże"]
[]
[null,null,"Uwaga: zastosować instrukcję SELECT CASE"]
[]
[]
[]
[]
[null,null,null,"OCENA"]
[null,null,null,"p1+p2","dst"]
[null,null,null,"p1+p2+p3","db"]
[null,null,null,"p1+p2+p3+p4","bdb"]

{"sheet":"Arkusz1","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,10,4,10],[3,3,3,4],[3,5,3,6],[3,1,3,2],[3,7,3,8],[3,9,4,9]]}
[]
[]
[]
[null,"Zamówienie",null,"długopisy",null,"cienkopisy",null,"rabat",null,"koszt zamówienia","wielkość zamówienia"]
[null,"Nr","Data i godzina","cena za szt.","ilość","cena za szt.","ilość","funkcja","makro"]
[null,1,"2001-08-06T14:49:08",2.7,200,2.4,500,"?","?","?","?"]
[null,2,"2001-08-28T13:30:36",0.7,600,4,400,"?","?","?","?"]
[null,3,"2001-09-19T19:34:46",1.5,100,4,500,"?","?","?","?"]
[null,4,"2001-09-22T13:29:15",0,0,4,1100,"?","?","?","?"]
[null,5,"2001-10-04T15:13:51",1.6,500,4,700,"?","?","?","?"]
[null,6,"2001-10-24T11:17:21",2.2999999999999998,500,4,500,"?","?","?","?"]
[null,7,"2001-11-01T15:04:23",2.4,100,4,1600,"?","?","?","?"]
[null,8,"2001-12-11T19:50:05",1.9,900,3.3,900,"?","?","?","?"]
[null,9,"2001-12-15T11:47:48",1.8,100,3.9,600,"?","?","?","?"]
[null,10,"2002-01-08T17:50:09",2,300,3.4,400,"?","?","?","?"]
[null,11,"2002-01-21T11:18:26",2.9,400,1.9,1200,"?","?","?","?"]
[null,12,"2002-02-12T13:15:23",3.7,900,2.4,700,"?","?","?","?"]
[null,13,"2002-02-16T14:48:26",2.5,400,3.9,300,"?","?","?","?"]
[null,14,"2002-03-08T18:39:08",2.8,500,0,0,"?","?","?","?"]
[null,15,"2002-03-18T10:40:09",1.4,100,3.9,300,"?","?","?","?"]
[null,16,"2002-03-24T14:35:53",1.9,1800,3.9,2200,"?","?","?","?"]
[null,17,"2002-03-25T16:39:55",0.8,300,3.9,900,"?","?","?","?"]
[null,18,"2002-03-26T10:53:14",1.2,700,0,0,"?","?","?","?"]
[null,19,"2002-04-03T12:57:08",0.8,800,3.9,300,"?","?","?","?"]
[null,20,"2002-04-18T19:51:07",2.4,1000,3.9,1100,"?","?","?","?"]
[null,21,"2002-05-03T10:37:30",0.6,400,3.9,800,"?","?","?","?"]
[null,22,"2002-05-10T15:17:06",1.1000000000000001,800,3.9,400,"?","?","?","?"]
[null,23,"2002-06-17T17:15:37",2.2000000000000002,300,3.9,2500,"?","?","?","?"]
[null,24,"2002-07-08T14:10:36",0.8,700,3.9,100,"?","?","?","?"]
[null,25,"2002-08-01T15:37:27",2.4,200,3.9,400,"?","?","?","?"]
[null,26,"2002-09-06T18:41:23",1.7,700,1.9,1700,"?","?","?","?"]
[null,27,"2002-10-01T12:35:22",0.9,600,3.9,400,"?","?","?","?"]
[null,28,"2002-10-04T16:32:18",1.5,200,3.9,1400,"?","?","?","?"]
[null,29,"2002-11-08T16:29:04",1.5,900,3.9,2200,"?","?","?","?"]
[null,30,"2002-11-10T18:13:16",1.6,500,3.9,400,"?","?","?","?"]
[null,31,"2002-11-19T11:56:31",1.3,300,4,400,"?","?","?","?"]
[null,32,"2002-12-11T17:37:31",1.8,1900,4,400,"?","?","?","?"]
[null,33,"2002-12-14T10:51:53",2.6,8000,4,400,"?","?","?","?"]
[null,34,"2002-12-27T11:36:26",1.3,2000,4,400,"?","?","?","?"]
[null,35,"2003-01-02T17:12:00",1.7,200,3.8,1500,"?","?","?","?"]
[null,36,"2003-01-05T14:33:19",2.9,800,2.9,300,"?","?","?","?"]
[null,37,"2003-01-08T10:44:54",0.9,200,3.7,500,"?","?","?","?"]
[null,38,"2003-02-05T10:41:57",3,200,4,400,"?","?","?","?"]
[null,39,"2003-03-12T14:33:53",1.2,2000,4,500,"?","?","?","?"]
[null,40,"2003-03-17T13:48:40",0.7,500,4,500,"?","?","?","?"]
[null,41,"2003-03-24T11:33:52",1.5,400,4,600,"?","?","?","?"]
[null,42,"2003-03-29T14:21:40",2.2999999999999998,300,2.6,900,"?","?","?","?"]
[null,43,"2003-04-10T17:40:04",0.5,400,2.9,1400,"?","?","?","?"]
[null,44,"2003-05-18T13:45:08",2.4,100,3.2,500,"?","?","?","?"]
[null,45,"2003-05-19T12:33:34",1.8,700,1.9,900,"?","?","?","?"]
[null,46,"2003-05-28T13:56:11",2.1,500,3.8,1300,"?","?","?","?"]