{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Arkusz1","TypyExcelVBA","Internet","Lista nazwisk"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Wykład 9"]
[]
[null,null,null,"1. Skojarzenie typów danych Excela i VBA"]
[null,null,null,"2. Funkcje wewnętrzne VBA i excela"]
[null,null,null,null,"a) funkcje daty i czasu: Year, Month, Day, Hour, Minute, Second"]
[null,null,null,null,"b) funkcje tekstowe: Left, Right, Mid, Length, InStr, Replace"]
[null,null,null,null,"c) zmienna WorksheetFunction"]
[null,null,null,"3. Jak radzić sobie z błędami"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"(funkcje tekstowe: Left, Right, Mid, Len, InStr, Replace)"]

{"sheet":"TypyExcelVBA","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SKOJARZENIE TYPÓW DANYCH VBA Z DANYMI W EXCELU"]
[]
[]
[null,10575]
[null,null,null,null,null,"Ewelina",72008]
[null,1234.5678,null,null,null,"Adrian",72439]
[null,null,null,null,null,"Adam",72009]
[null,45000,null,null,null,"Magdalena",72010]
[null,null,null,null,null,"Piotr",72011]
[null,"Tekst",null,null,null,"Andrzej",69334]
[null,null,null,null,null,"Karolina",72012]
[null,"2009-06-04",null,null,null,"Justyna",72435]
[null,"15:10:00",null,null,null,"Paulina",72013]
[]
[null,true]

{"sheet":"Internet","index":2,"n_rows":123,"n_cols":16,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"1.","Czy połączenie w 1 połowie roku?"]
[null,"1a.","Oznaczyć liczbą 1  połączenia w 1 półroczu 2001 roku"]
[null,"2.","Czy połaczenie przed południem?"]
[null,"2a.","Oznaczyć liczbą 0-1  połączenia przed 12-tą",null,null,null,null,null,null,null,null,null,"DatePart","HV01204091"]
[null,"3.","Czy połączenie między północą a 6 rano?",null,null,null,null,null,null,null,null,null,"WorksheetFunction.Ceiling",null,null,"HV10068081"]
[null,"4.","Oznaczyć liczbą 0-1  połączenia w weekendy"]
[null,"5.","Wyznaczyć kwartał "]
[null,"6.","Czy połączenie w pierwszym lub w czwartym kwartale roku?"]
[]
[null,"Zabawy rodzinne z Internetem"]
[null,null,null,null,null,null,null,null,"Danych nie należy sortować i filtrować!"]
[null,"kto","data","od godz.","czas połączenia [sec]","do godz.","p1","p1a","p2","p2a","p3","p4","kwartał Formuła Excel","kwartał1","kwartał2","kwartał3"]
[null,"tata","2001-11-10","14:27:12",17876,{"$f":"do_godz(D15,E15)","v":"19:25:08"},null,{"$f":"Pierwsza_połowa_roku(C15)","v":0}]
[null,"Adam","2001-02-04","18:25:14",2951,{"$f":"do_godz(D16,E16)","v":"19:14:25"},null,{"$f":"Pierwsza_połowa_roku(C16)","v":1}]
[null,"Jola","2001-12-06","12:02:34",18663,"17:13:37",null,0]
[null,"mama","2001-06-30","03:44:55",18622,"08:55:17",null,1]
[null,"tata","2001-11-17","21:44:18",5197,"23:10:55",null,0]
[null,"Adam","2001-07-22","19:03:35",6139,"20:45:54",null,0]
[null,"tata","2001-02-13","14:45:50",424,"14:52:54",null,1]
[null,"mama","2001-05-02","16:46:43",4013,"17:53:36",null,1]
[null,"tata","2001-10-26","19:30:32",13425,"23:14:17",null,0]
[null,"tata","2001-09-11","13:01:12",14827,"17:08:19",null,0]
[null,"tata","2001-06-02","22:02:54",9187,1.025011574074074,null,1]
[null,"Adam","2001-03-08","13:47:57",16047,"18:15:24",null,1]
[null,"Jola","2001-06-06","02:06:47",3386,"03:03:13",null,1]
[null,"tata","2001-01-29","06:11:05",7832,"08:21:37",null,1]
[null,"Adam","2001-05-11","04:07:38",1392,"04:30:50",null,1]
[null,"tata","2001-11-04","13:34:31",2495,"14:16:06",null,0]
[null,"tata","2001-05-26","20:29:36",424,"20:36:40",null,1]
[null,"mama","2001-05-11","16:33:39",12550,"20:02:49",null,1]
[null,"Adam","2001-07-04","07:47:24",7969,"10:00:13",null,0]
[null,"tata","2001-08-24","04:17:27",10083,"07:05:30",null,0]
[null,"Jola","2001-07-07","11:57:28",11291,"15:05:39",null,0]
[null,"Jola","2001-12-29","03:47:04",2907,"04:35:31",null,0]
[null,"Adam","2001-09-09","11:46:40",16960,"16:29:20",null,0]
[null,"mama","2001-05-14","14:18:41",10504,"17:13:45",null,1]
[null,"Jola","2001-09-24","11:43:32",7909,"13:55:21",null,0]
[null,"tata","2001-04-04","16:04:51",405,"16:11:36",null,1]
[null,"tata","2001-08-15","10:41:02",6595,"12:30:57",null,0]
[null,"Adam","2001-03-16","09:45:14",7747,"11:54:21",null,1]
[null,"Jola","2001-06-06","04:18:55",11636,"07:32:51",null,1]
[null,"Adam","2001-09-19","03:17:09",10454,"06:11:23",null,0]
[null,"Adam","2001-09-30","21:45:44",17874,1.1136342592592592,null,0]
[null,"mama","2001-04-21","15:48:10",14066,"19:42:36",null,1]
[null,"tata","2001-06-19","10:37:26",11887,"13:55:33",null,1]
[null,"Jola","2001-07-25","13:02:18",7693,"15:10:31",null,0]
[null,"mama","2001-02-17","13:24:08",871,"13:38:39",null,1]
[null,"tata","2001-08-27","04:22:04",12863,"07:56:27",null,0]
[null,"Adam","2001-05-13","18:10:14",3093,"19:01:47",null,1]
[null,"Jola","2001-02-05","19:36:15",20795,1.0575231481481482,null,1]
[null,"mama","2001-06-07","04:06:17",11958,"07:25:35",null,1]
[null,"Adam","2001-03-04","02:17:44",7031,"04:14:55",null,1]
[null,"Jola","2001-03-19","21:28:18",17481,1.0969791666666668,null,1]
[null,"Jola","2001-12-19","12:47:15",15044,"16:57:59",null,0]
[null,"mama","2001-08-11","03:59:32",17739,"08:55:11",null,0]
[null,"Adam","2001-09-04","14:27:49",12670,"17:58:59",null,0]
[null,"Adam","2001-04-08","02:19:58",10473,"05:14:31",null,1]
[null,"mama","2001-08-02","00:36:07",17620,"05:29:47",null,0]
[null,"Adam","2001-10-25","13:52:57",7863,"16:04:00",null,0]
[null,"tata","2001-11-27","22:37:57",5177,1.0029398148148148,null,0]
[null,"Adam","2001-12-25","15:58:42",6834,"17:52:36",null,0]
[null,"tata","2001-07-13","09:35:47",14481,"13:37:08",null,0]
[null,"Jola","2001-05-10","18:44:53",1191,"19:04:44",null,1]
[null,"Adam","2001-02-12","08:44:31",10358,"11:37:09",null,1]
[null,"Adam","2001-03-01","14:21:16",15973,"18:47:29",null,1]
[null,"Jola","2001-11-07","18:44:37",12315,"22:09:52",null,0]
[null,"Jola","2001-05-16","12:20:05",9193,"14:53:18",null,1]
[null,"Jola","2001-04-04","10:16:51",9711,"12:58:42",null,1]
[null,"tata","2001-10-23","09:29:38",5450,"11:00:28",null,0]
[null,"tata","2001-03-27","03:34:04",15815,"07:57:39",null,1]
[null,"Adam","2001-12-26","01:12:06",8726,"03:37:32",null,0]
[null,"tata","2001-09-22","11:52:53",9970,"14:39:03",null,0]
[null,"Jola","2001-09-29","09:07:05",9486,"11:45:11",null,0]
[null,"Adam","2001-03-10","19:26:58",17674,1.0149537037037037,null,1]
[null,"tata","2001-10-15","17:26:33",20237,"23:03:50",null,0]
[null,"Adam","2001-05-18","20:24:51",17870,1.0574189814814814,null,1]
[null,"Adam","2001-03-23","22:51:50",9755,1.0655671296296296,null,1]
[null,"mama","2001-09-25","02:29:26",20366,{"$f":"do_godz(D80,E80)","v":"08:08:52"},null,{"$f":"Pierwsza_połowa_roku(C80)","v":0}]
[null,"Jola","2001-05-05","05:09:11",10365,"08:01:56",null,1]
[null,"Jola","2001-10-08","02:47:45",15389,"07:04:14",null,0]
[null,"tata","2001-03-16","23:06:39",20128,1.1959143518518518,null,1]
[null,"mama","2001-07-04","02:53:28",15366,"07:09:34",null,0]
[null,"Adam","2001-04-15","15:05:42",18999,"20:22:21",null,1]
[null,"Adam","2001-05-27","13:45:11",8219,"16:02:10",null,1]
[null,"mama","2001-03-19","00:35:43",16217,"05:06:00",null,1]
[null,"Jola","2001-07-22","06:46:27",21396,"12:43:03",null,0]
[null,"mama","2001-11-20","21:45:46",5250,"23:13:16",null,0]
[null,"Jola","2001-12-12","20:53:02",14513,1.0381365740740742,null,0]
[null,"Jola","2001-09-20","10:14:21",10844,"13:15:05",null,0]
[null,"Adam","2001-03-24","22:41:05",17148,1.1436689814814816,null,1]
[null,"Jola","2001-08-28","10:43:31",10204,"13:33:35",null,0]
[null,"tata","2001-01-25","05:12:34",21155,"11:05:09",null,1]
[null,"tata","2001-06-25","11:26:06",17179,"16:12:25",null,1]
[null,"Adam","2001-12-11","12:32:12",18879,"17:46:51",null,0]
[null,"tata","2001-11-21","04:02:14",19812,"09:32:26",null,0]
[null,"tata","2001-12-19","04:10:25",5908,"05:48:53",null,0]
[null,"Adam","2001-11-15","07:19:50",876,"07:34:26",null,0]
[null,"tata","2001-12-12","04:53:18",4871,"06:14:29",null,0]
[null,"tata","2001-06-17","20:18:49",12185,"23:41:54",null,1]
[null,"tata","2001-11-13","15:28:32",7247,"17:29:19",null,0]
[null,"mama","2001-05-07","08:46:53",20714,"14:32:07",null,1]
[null,"Adam","2001-06-13","12:40:52",13797,"16:30:49",null,1]
[null,"Jola","2001-08-08","14:56:15",8215,"17:13:10",null,0]
[null,"Jola","2001-07-18","09:00:34",10403,"11:53:57",null,0]
[null,"mama","2001-03-24","18:57:36",3954,"20:03:30",null,1]
[null,"Adam","2001-02-08","16:30:46",6545,"18:19:51",null,1]
[null,"tata","2001-05-13","15:09:57",10217,"18:00:14",null,1]
[null,"mama","2001-08-04","07:18:18",1482,"07:43:00",null,0]
[null,"Adam","2001-07-18","06:21:04",9445,"08:58:29",null,0]
[null,"Adam","2001-02-04","13:41:12",2484,"14:22:36",null,1]
[null,"Adam","2001-08-19","20:15:33",10261,"23:06:34",null,0]
[]
[]
["Obliczyć:"]
["1. czas, do którego trwało każde połączenie (wynik podać w formacie gg:mm:ss)"]
["2. całkowity czas zabawy z Internetem w każdym miesiącu (wynik podać w formacie gg:mm:ss)"]
["3. koszt każdego połączenia, jeżeli za każdą sekundę pierwszej godziny połączenia "]
["    należy zapłącić 0,12 gr, a za każdą sekundę następnych godzin opłata wynosi 0,1 gr"]
["4. ile czasu spędził z komputerem każdy członek rodziny; wyniki należy podać w dwu formatach:"]
["    gg:mm:ss  - godziny, minuty i sekundy"]
["    0,00              - godziny i część ułamkowa godziny (2 miejsca po przecinku)"]

{"sheet":"Lista nazwisk","index":3,"n_rows":62,"n_cols":2,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nazwisko Imię"]
[null,"Kresa Krystyna"]
[null,"Kresa Kazimierz"]
[null,"Tymicz Zenon"]
[null,"Dragon Józef"]
[null,"Szymański Jan"]
[null,"Nowakowski Marek"]
[null,"Krajewska Lucyna"]
[null,"Ligocki Ryszard"]
[null,"Trela Anna"]
[null,"Wojciechowska Ewa"]
[null,"Żakowski Robert"]
[null,"Paluch Krystyna"]
[null,"Paluch Edward"]
[null,"Sroka Wanda"]
[null,"Długosz Ludwik"]
[null,"Długosz Aneta"]
[null,"Chojnacka Edyta"]
[null,"Banaszak Aleksander"]
[null,"Góralczyk Wojciech"]
[null,"Puchalski Marian"]
[null,"Rudnicka  Halina"]
[null,"Rudnicki Józef"]
[null,"Andrzejczak Helena"]
[null,"Samborska Małgorzata"]
[null,"Grabowski Jacek"]
[null,"Wysocki Rafał"]
[null,"Gruca Grzegorz"]
[null,"Gruca Helena"]
[null,"Gruca Cezary"]
[null,"Szymczak Janusz"]
[null,"Turski Zbigniew"]
[null,"Śliwińska Magdalena"]
[null,"Ejsmont Barbara"]
[null,"Bugalska Ewa"]
[null,"Bugalski Leszek"]
[null,"Cichocki Marian"]
[null,"Ginalski Józef"]
[null,"Filipczyk Czesław"]
[null,"Maciejewski Zygmunt"]
[null,"Bogucewicz Cecylia"]
[null,"Banasiak Feliks"]
[null,"Banasiak Agnieszka"]
[null,"Wiśniewska Grażyna"]
[null,"Biedrzycki Zbigniew"]
[null,"Pogorzelski Jerzy"]
[null,"Kacprzyk Dominika"]
[null,"Kacprzyk Cecylia"]
[null,"Rokita Marta"]
[null,"Tokarczuk Agata"]
[null,"Osowska Maria"]
[null,"Leszczyk Mikołaj"]
[null,"Dziuba Bożena"]
[null,"Rybak Piotr"]
[null,"Zalewski Robert"]
[null,"Nitecka Jolanta"]
[null,"Rokita Stanisław"]
[null,"Rokita Maria"]
[null,"Skrzypczak Jadwiga"]
[null,"Łopata Henryk"]
[null,"Zabawa Krzysztof"]