{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Zagadnienia","Arkusz3","Arkusz1","Arkusz2","Arkusz4","Arkusz5"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Zagadnienia","index":0,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"1.Zagnieżdżanie pętli"]
[null,"2.Tablice (statyczne i dynamiczne)"]
[null,"3.Funkcje tablicowe VBA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUKCJE PĘTLI"]
[null,"ZAGADNIENIA Z JEDNĄ PĘTLĄ"]
[null,"1. Zliczanie określonych warunkiem elementów w arkuszu  "]
[null,"2. Sumowanie określonych warunkiem elementów w arkuszu "]
[null,"3. Tworzenie listy elementów określonych warunkiem"]
[null,"4. Wyznaczanie elemenu maksymalnego/minimalnego"]
[null,"5. Wyznaczanie elementu początkowego/końcowego"]

{"sheet":"Arkusz3","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,1.7]
[null,2]
[null,-3.2]
[null,4]
[null,-1]
[null,2.12]
[null,0]
[null,6.3]
[null,3]
[null,-4.5]

{"sheet":"Arkusz1","index":2,"n_rows":113,"n_cols":5,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zabawy rodzinne z Internetem"]
[]
[null,"kto","data","od godz.","czas połączenia [sec]"]
[null,"tata","2001-11-10","14:27:12",17876]
[null,"Adam","2001-02-04","18:25:14",2951]
[null,"Jola","2001-12-06","12:02:34",18663]
[null,"mama","2001-06-30","03:44:55",18622]
[null,"tata","2001-11-17","21:44:18",5197]
[null,"Adam","2001-07-22","19:03:35",6139]
[null,"tata","2001-02-13","14:45:50",424]
[null,"mama","2001-05-02","16:46:43",4013]
[null,"tata","2001-10-26","19:30:32",13425]
[null,"tata","2001-09-11","13:01:12",14827]
[null,"tata","2001-06-02","22:02:54",9187]
[null,"Adam","2001-03-08","13:47:57",16047]
[null,"Jola","2001-06-06","02:06:47",3386]
[null,"tata","2001-01-29","06:11:05",7832]
[null,"Adam","2001-05-11","04:07:38",1392]
[null,"tata","2001-11-04","13:34:31",2495]
[null,"tata","2001-05-26","20:29:36",424]
[null,"mama","2001-05-11","16:33:39",12550]
[null,"Adam","2001-07-04","07:47:24",7969]
[null,"tata","2001-08-24","04:17:27",10083]
[null,"Jola","2001-07-07","11:57:28",11291]
[null,"Jola","2001-12-29","03:47:04",2907]
[null,"Adam","2001-09-09","11:46:40",16960]
[null,"mama","2001-05-14","14:18:41",10504]
[null,"Jola","2001-09-24","11:43:32",7909]
[null,"tata","2001-04-04","16:04:51",405]
[null,"tata","2001-08-15","10:41:02",6595]
[null,"Adam","2001-03-16","09:45:14",7747]
[null,"Jola","2001-06-06","04:18:55",11636]
[null,"Adam","2001-09-19","03:17:09",10454]
[null,"Adam","2001-09-30","21:45:44",17874]
[null,"mama","2001-04-21","15:48:10",14066]
[null,"tata","2001-06-19","10:37:26",11887]
[null,"Jola","2001-07-25","13:02:18",7693]
[null,"mama","2001-02-17","13:24:08",871]
[null,"tata","2001-08-27","04:22:04",12863]
[null,"Adam","2001-05-13","18:10:14",3093]
[null,"Jola","2001-02-05","19:36:15",20795]
[null,"mama","2001-06-07","04:06:17",11958]
[null,"Adam","2001-03-04","02:17:44",7031]
[null,"Jola","2001-03-19","21:28:18",17481]
[null,"Jola","2001-12-19","12:47:15",15044]
[null,"mama","2001-08-11","03:59:32",17739]
[null,"Adam","2001-09-04","14:27:49",12670]
[null,"Adam","2001-04-08","02:19:58",10473]
[null,"mama","2001-08-02","00:36:07",17620]
[null,"Adam","2001-10-25","13:52:57",7863]
[null,"tata","2001-11-27","22:37:57",5177]
[null,"Adam","2001-12-25","15:58:42",6834]
[null,"tata","2001-07-13","09:35:47",14481]
[null,"Jola","2001-05-10","18:44:53",1191]
[null,"Adam","2001-02-12","08:44:31",10358]
[null,"Adam","2001-03-01","14:21:16",15973]
[null,"Jola","2001-11-07","18:44:37",12315]
[null,"Jola","2001-05-16","12:20:05",9193]
[null,"Jola","2001-04-04","10:16:51",9711]
[null,"tata","2001-10-23","09:29:38",5450]
[null,"tata","2001-03-27","03:34:04",15815]
[null,"Adam","2001-12-26","01:12:06",8726]
[null,"tata","2001-09-22","11:52:53",9970]
[null,"Jola","2001-09-29","09:07:05",9486]
[null,"Adam","2001-03-10","19:26:58",17674]
[null,"tata","2001-10-15","17:26:33",20237]
[null,"Adam","2001-05-18","20:24:51",17870]
[null,"Adam","2001-03-23","22:51:50",9755]
[null,"mama","2001-09-25","02:29:26",20366]
[null,"Jola","2001-05-05","05:09:11",10365]
[null,"Jola","2001-10-08","02:47:45",15389]
[null,"tata","2001-03-16","23:06:39",20128]
[null,"mama","2001-07-04","02:53:28",15366]
[null,"Adam","2001-04-15","15:05:42",18999]
[null,"Adam","2001-05-27","13:45:11",8219]
[null,"mama","2001-03-19","00:35:43",16217]
[null,"Jola","2001-07-22","06:46:27",21396]
[null,"mama","2001-11-20","21:45:46",5250]
[null,"Jola","2001-12-12","20:53:02",14513]
[null,"Jola","2001-09-20","10:14:21",10844]
[null,"Adam","2001-03-24","22:41:05",17148]
[null,"Jola","2001-08-28","10:43:31",10204]
[null,"tata","2001-01-25","05:12:34",21155]
[null,"tata","2001-06-25","11:26:06",17179]
[null,"Adam","2001-12-11","12:32:12",18879]
[null,"tata","2001-11-21","04:02:14",19812]
[null,"tata","2001-12-19","04:10:25",5908]
[null,"Adam","2001-11-15","07:19:50",876]
[null,"tata","2001-12-12","04:53:18",4871]
[null,"tata","2001-06-17","20:18:49",12185]
[null,"tata","2001-11-13","15:28:32",7247]
[null,"mama","2001-05-07","08:46:53",20714]
[null,"Adam","2001-06-13","12:40:52",13797]
[null,"Jola","2001-08-08","14:56:15",8215]
[null,"Jola","2001-07-18","09:00:34",10403]
[null,"mama","2001-03-24","18:57:36",3954]
[null,"Adam","2001-02-08","16:30:46",6545]
[null,"tata","2001-05-13","15:09:57",10217]
[null,"mama","2001-08-04","07:18:18",1482]
[null,"Adam","2001-07-18","06:21:04",9445]
[null,"Adam","2001-02-04","13:41:12",2484]
[null,"Adam","2001-08-19","20:15:33",10261]
[]
[]
["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":"Arkusz2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Arkusz4","index":4,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10]
[2,4,6,8,10,12,14,16,18,20]
[3,6,9,12,15,18,21,24,27,30]
[4,8,12,16,20,24,28,32,36,40]
[5,10,15,20,25,30,35,40,45,50]
[6,12,18,24,30,36,42,48,54,60]
[7,14,21,28,35,42,49,56,63,70]
[8,16,24,32,40,48,56,64,72,80]
[9,18,27,36,45,54,63,72,81,90]
[10,20,30,40,50,60,70,80,90,100]
[]
[]
[null,1,2,3,4,5]
[null,2,4,6,8,10]
[null,3,6,9,12,15,null,null,null,null,1,2,null,4,5,null,{"$f":"MMULT(A,B)","v":16},19]
[null,4,8,12,16,20,null,null,null,null,2,3,null,6,7,null,26,31]
[null,5,10,15,20,25]
[null,6,12,18,24,30,null,null,null,null,{"$f":"MINVERSE(A)","v":-3},2]
[null,7,14,21,28,35,null,null,null,null,2,-1]
[null,8,16,24,32,40]
[null,9,18,27,36,45,null,null,null,null,{"$f":"TRANSPOSE(J22:J31)","v":2},4,"asd",4,5,6,7,8,9,10]
[null,10,20,30,40,50,null,null,null,2]
[null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,4,null,{"$f":"przepisz(B)","v":4},6]
[null,null,null,null,null,null,null,null,null,"asd",null,5,7]
[null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,10]

{"sheet":"Arkusz5","index":5,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10]
[2,4,6,8,10,12,14,16,18,20]
[3,6,9,12,15,18,21,24,27,30,null,1,2,null,{"$f":"MDETERM(L3:M4)","v":-2}]
[4,8,12,16,20,24,28,32,36,40,null,3,4]
[null,null,null,null,25,30,35,40,45,50]
[null,null,null,null,30,36,42,48,54,60]
[null,null,null,null,35,42,49,56,63,70,null,{"$f":"MINVERSE(L3:M4)","v":-1.9999999999999998},0.99999999999999989]
[null,null,null,null,40,48,56,64,72,80,null,1.4999999999999998,-0.49999999999999989]
[null,null,null,null,45,54,63,72,81,90]
[null,null,null,null,50,60,70,80,90,100]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"przepisz(L7:M8)","v":-1.9999999999999998},1.4999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,0.99999999999999989,-0.49999999999999989]
[]
[{"$f":"przepisz2(A1:J10)","v":1},2,3,4,0,0,0,0,0,0]
[2,4,6,8,0,0,0,0,0,0]
[3,6,9,12,0,0,0,0,0,0]
[4,8,12,16,0,0,0,0,0,0]
[5,10,15,20,25,30,35,40,45,50]
[6,12,18,24,30,36,42,48,54,60]
[7,14,21,28,35,42,49,56,63,70]
[8,16,24,32,40,48,56,64,72,80]
[9,18,27,36,45,54,63,72,81,90]
[10,20,30,40,50,60,70,80,90,100]