{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Arkusz1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Arkusz1","index":0,"n_rows":116,"n_cols":15,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
[]
[null,"1. Za pomocą funkcji VBA obliczyć koszt każdego połączenia,zakładając że:",null,null,null,null,null,null,null,null,null,null,null,"OCENA"]
[null,"   a) w pierwszym półroczu 2001 za każdą sekundę połączenia należy zapłącić 0,12 gr,\n",null,null,null,null,null,null,null,null,null,null,null,"p1+p2","dst"]
[null,"   b) w drugim półroczu 2001 za każdą sekundę pierwszej godziny połączenia należy zapłącić",null,null,null,null,null,null,null,null,null,null,null,"p1+p2+p3","db"]
[null,"   0,14 gr, a za każdą sekundę następnych godzin opłata wynosi 0,12 gr,\n",null,null,null,null,null,null,null,null,null,null,null,"p1+p2+p3+p4","bdb"]
[null,"2. Policzyć to co w p. 1 za pomocą makra używając zmiennej ActiveCell."]
[null,"    Po wybraniu komórki G18 makro po uruchomieniu powinno wpisać do tej komórki wynik "]
[null,"    i  ustawić aktywną komórkę na G19. Kolejne uruchomienia makra powinny wpisać wyniki w kolumnie G."]
[null,"3. Napisać funkcję VBA z wykorzystaniem instrukcji if, która zwraca tekst: "]
[null,"   \"perwszy kwartał\", gdy połączenie miało miejsce w 1 kwartale 2001 r, "]
[null,"   \"drugi kwartał\", gdy połączenie miało miejsce w 2 kwartale 2001 r, "]
[null,"   \"trzeci kwartał\", gdy połączenie miało miejsce w 3 kwartale 2001 r, "]
[null,"   \"czwarty kwartał\", gdy połączenie miało miejsce w 4 kwartale 2001 r, "]
[null,"4. Napisać funkcję VBA wyznaczającą to samo co w p. 3 wykorzystując instrukcję Select Case."]
[]
[null,null,null,null,null,1,2,3,4]
[null,"kto","data","od godz.","czas połączenia [sec]","koszt połączenia (f. VBA)","koszt połączenia (makro)","kwartał (If)","kwartał (Select Case)"]
[null,"tata","2001-11-10","14:27:12",17876,{"$f":"koszt(E18,C18)","v":22.171199999999999},22.17,{"$f":"kwartał(C18)","v":"Czwarty kwartał"},{"$f":"kwartał1(C18)","v":"Czwarty kwartał"}]
[null,"Adam","2001-02-04","18:25:14",2951,{"$f":"koszt(E19,C19)","v":3.5411999999999999},3.54,{"$f":"kwartał(C19)","v":"Pierwszy kwartał"},{"$f":"kwartał1(C19)","v":"Pierwszy kwartał"}]
[null,"Jola","2001-12-06","12:02:34",18663,23.115600000000001,23.12,"Czwarty kwartał","Czwarty kwartał"]
[null,"mama","2001-06-30","03:44:55",18622,22.346399999999999,22.35,"Drugi kwartał","Drugi kwartał"]
[null,"tata","2001-11-17","21:44:18",5197,6.9564000000000004,6.96,"Czwarty kwartał","Czwarty kwartał"]
[null,"Adam","2001-07-22","19:03:35",6139,8.0868000000000002,8.09,"Trzeci kwartał","Trzeci kwartał"]
[null,"tata","2001-02-13","14:45:50",424,0.50880000000000003,0.51,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"mama","2001-05-02","16:46:43",4013,4.8155999999999999,4.82,"Drugi kwartał","Drugi kwartał"]
[null,"tata","2001-10-26","19:30:32",13425,16.829999999999998,16.829999999999998,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-09-11","13:01:12",14827,18.5124,18.510000000000002,"Trzeci kwartał","Trzeci kwartał"]
[null,"tata","2001-06-02","22:02:54",9187,11.0244,11.02,"Drugi kwartał","Drugi kwartał"]
[null,"Adam","2001-03-08","13:47:57",16047,19.256399999999999,19.260000000000002,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Jola","2001-06-06","02:06:47",3386,4.0632000000000001,4.0599999999999996,"Drugi kwartał","Drugi kwartał"]
[null,"tata","2001-01-29","06:11:05",7832,9.3984000000000005,9.4,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Adam","2001-05-11","04:07:38",1392,1.6704000000000001,1.67,"Drugi kwartał","Drugi kwartał"]
[null,"tata","2001-11-04","13:34:31",2495,5.04,5.04,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-05-26","20:29:36",424,0.50880000000000003,0.51,"Drugi kwartał","Drugi kwartał"]
[null,"mama","2001-05-11","16:33:39",12550,15.06,15.06,"Drugi kwartał","Drugi kwartał"]
[null,"Adam","2001-07-04","07:47:24",7969,10.2828,10.28,"Trzeci kwartał","Trzeci kwartał"]
[null,"tata","2001-08-24","04:17:27",10083,12.819599999999999,12.82,"Trzeci kwartał","Trzeci kwartał"]
[null,"Jola","2001-07-07","11:57:28",11291,14.2692,14.27,"Trzeci kwartał","Trzeci kwartał"]
[null,"Jola","2001-12-29","03:47:04",2907,5.04,5.04,"Czwarty kwartał","Czwarty kwartał"]
[null,"Adam","2001-09-09","11:46:40",16960,21.071999999999999,21.07,"Trzeci kwartał","Trzeci kwartał"]
[null,"mama","2001-05-14","14:18:41",10504,12.604799999999999,12.6,"Drugi kwartał","Drugi kwartał"]
[null,"Jola","2001-09-24","11:43:32",7909,10.210800000000001,10.210000000000001,"Trzeci kwartał","Trzeci kwartał"]
[null,"tata","2001-04-04","16:04:51",405,0.48599999999999999,0.49,"Drugi kwartał","Drugi kwartał"]
[null,"tata","2001-08-15","10:41:02",6595,8.6340000000000003,8.6300000000000008,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-03-16","09:45:14",7747,9.2964000000000002,9.3000000000000007,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Jola","2001-06-06","04:18:55",11636,13.963200000000001,13.96,"Drugi kwartał","Drugi kwartał"]
[null,"Adam","2001-09-19","03:17:09",10454,13.264799999999999,13.26,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-09-30","21:45:44",17874,22.168800000000001,22.17,"Trzeci kwartał","Trzeci kwartał"]
[null,"mama","2001-04-21","15:48:10",14066,16.879200000000001,16.88,"Drugi kwartał","Drugi kwartał"]
[null,"tata","2001-06-19","10:37:26",11887,14.2644,14.26,"Drugi kwartał","Drugi kwartał"]
[null,"Jola","2001-07-25","13:02:18",7693,9.9515999999999991,9.9499999999999993,"Trzeci kwartał","Trzeci kwartał"]
[null,"mama","2001-02-17","13:24:08",871,1.0451999999999999,1.05,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"tata","2001-08-27","04:22:04",12863,16.1556,16.16,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-05-13","18:10:14",3093,3.7115999999999998,3.71,"Drugi kwartał","Drugi kwartał"]
[null,"Jola","2001-02-05","19:36:15",20795,24.954000000000001,24.95,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"mama","2001-06-07","04:06:17",11958,14.349600000000001,14.35,"Drugi kwartał","Drugi kwartał"]
[null,"Adam","2001-03-04","02:17:44",7031,8.4372000000000007,8.44,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Jola","2001-03-19","21:28:18",17481,20.9772,20.98,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Jola","2001-12-19","12:47:15",15044,18.7728,18.77,"Czwarty kwartał","Czwarty kwartał"]
[null,"mama","2001-08-11","03:59:32",17739,22.006799999999998,22.01,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-09-04","14:27:49",12670,15.923999999999999,15.92,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-04-08","02:19:58",10473,12.567600000000001,12.57,"Drugi kwartał","Drugi kwartał"]
[null,"mama","2001-08-02","00:36:07",17620,21.864000000000001,21.86,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-10-25","13:52:57",7863,10.1556,10.16,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-11-27","22:37:57",5177,6.9324000000000003,6.93,"Czwarty kwartał","Czwarty kwartał"]
[null,"Adam","2001-12-25","15:58:42",6834,8.9207999999999998,8.92,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-07-13","09:35:47",14481,18.097200000000001,18.100000000000001,"Trzeci kwartał","Trzeci kwartał"]
[null,"Jola","2001-05-10","18:44:53",1191,1.4292,null,"Drugi kwartał","Drugi kwartał"]
[null,"Adam","2001-02-12","08:44:31",10358,12.429600000000001,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Adam","2001-03-01","14:21:16",15973,19.1676,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Jola","2001-11-07","18:44:37",12315,15.497999999999999,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"Jola","2001-05-16","12:20:05",9193,11.031599999999999,null,"Drugi kwartał","Drugi kwartał"]
[null,"Jola","2001-04-04","10:16:51",9711,11.6532,null,"Drugi kwartał","Drugi kwartał"]
[null,"tata","2001-10-23","09:29:38",5450,7.26,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-03-27","03:34:04",15815,18.978000000000002,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Adam","2001-12-26","01:12:06",8726,11.1912,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-09-22","11:52:53",9970,12.683999999999999,null,"Trzeci kwartał","Trzeci kwartał"]
[null,"Jola","2001-09-29","09:07:05",9486,12.103199999999999,null,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-03-10","19:26:58",17674,21.2088,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"tata","2001-10-15","17:26:33",20237,25.0044,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"Adam","2001-05-18","20:24:51",17870,21.443999999999999,null,"Drugi kwartał","Drugi kwartał"]
[null,"Adam","2001-03-23","22:51:50",9755,11.706,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"mama","2001-09-25","02:29:26",20366,{"$f":"koszt(E83,C83)","v":25.159199999999998},null,{"$f":"kwartał(C83)","v":"Trzeci kwartał"},{"$f":"kwartał1(C83)","v":"Trzeci kwartał"}]
[null,"Jola","2001-05-05","05:09:11",10365,12.438000000000001,null,"Drugi kwartał","Drugi kwartał"]
[null,"Jola","2001-10-08","02:47:45",15389,19.186800000000002,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-03-16","23:06:39",20128,24.153600000000001,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"mama","2001-07-04","02:53:28",15366,19.159199999999998,null,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-04-15","15:05:42",18999,22.7988,null,"Drugi kwartał","Drugi kwartał"]
[null,"Adam","2001-05-27","13:45:11",8219,9.8628,null,"Drugi kwartał","Drugi kwartał"]
[null,"mama","2001-03-19","00:35:43",16217,19.4604,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Jola","2001-07-22","06:46:27",21396,26.395199999999999,null,"Trzeci kwartał","Trzeci kwartał"]
[null,"mama","2001-11-20","21:45:46",5250,7.02,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"Jola","2001-12-12","20:53:02",14513,18.1356,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"Jola","2001-09-20","10:14:21",10844,13.732799999999999,null,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-03-24","22:41:05",17148,20.5776,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Jola","2001-08-28","10:43:31",10204,12.9648,null,"Trzeci kwartał","Trzeci kwartał"]
[null,"tata","2001-01-25","05:12:34",21155,25.385999999999999,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"tata","2001-06-25","11:26:06",17179,20.614799999999999,null,"Drugi kwartał","Drugi kwartał"]
[null,"Adam","2001-12-11","12:32:12",18879,23.3748,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-11-21","04:02:14",19812,24.494399999999999,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-12-19","04:10:25",5908,7.8095999999999997,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"Adam","2001-11-15","07:19:50",876,5.04,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-12-12","04:53:18",4871,6.5651999999999999,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"tata","2001-06-17","20:18:49",12185,14.622,null,"Drugi kwartał","Drugi kwartał"]
[null,"tata","2001-11-13","15:28:32",7247,9.4163999999999994,null,"Czwarty kwartał","Czwarty kwartał"]
[null,"mama","2001-05-07","08:46:53",20714,24.8568,null,"Drugi kwartał","Drugi kwartał"]
[null,"Adam","2001-06-13","12:40:52",13797,16.5564,null,"Drugi kwartał","Drugi kwartał"]
[null,"Jola","2001-08-08","14:56:15",8215,10.577999999999999,null,"Trzeci kwartał","Trzeci kwartał"]
[null,"Jola","2001-07-18","09:00:34",10403,13.2036,null,"Trzeci kwartał","Trzeci kwartał"]
[null,"mama","2001-03-24","18:57:36",3954,4.7447999999999997,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Adam","2001-02-08","16:30:46",6545,7.8540000000000001,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"tata","2001-05-13","15:09:57",10217,12.260400000000001,null,"Drugi kwartał","Drugi kwartał"]
[null,"mama","2001-08-04","07:18:18",1482,5.04,null,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-07-18","06:21:04",9445,12.054,null,"Trzeci kwartał","Trzeci kwartał"]
[null,"Adam","2001-02-04","13:41:12",2484,2.9807999999999999,null,"Pierwszy kwartał","Pierwszy kwartał"]
[null,"Adam","2001-08-19","20:15:33",10261,13.033200000000001,null,"Trzeci kwartał","Trzeci kwartał"]