{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Transport","ZIP","Wykład 1","Programowanie","Makro","Typy danych","Arkusz8","Arkusz1","Wykład 2","Arkusz2","Arkusz3"],"not_rendered":{"charts":0,"images":4,"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":"Transport","index":0,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Informatyka"]

{"sheet":"ZIP","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Podstawy informatyki"]
[null,"i algorytmizacji"]

{"sheet":"Wykład 1","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"WYKŁAD 1"]
[]
[null,"Makropolecenia (Makra) w programie EXCEL."]

{"sheet":"Programowanie","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Makro","index":4,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Makropolecenie (makro) jest ciągiem instrukcji pozwalających "]
[null,"na automatyczne wykonywanie pewnych czynności w programie EXCEL."]
[]
[]
[null,"Makra w EXCELu można tworzyć dwoma sposobami:"]
[null,"- poprzez nagrywanie"]
[null,null,"Karta Deweloper -> Zarejestruj makro"]
[null,"- poprzez wypisanie instrukcji w języku skryptowym o nazwie VBA"]
[null,"    (z ang. Visual Basic for Aplications)"]
[]
[null,null,"Sub <nazwa makra>"]
[null,null,"<instrukcja 1>"]
[null,null,"<instrukcja 2>"]
[null,null,"<instrukcja 3>"]
[null,null,":"]
[null,null,":"]
[null,null,":"]
[null,null,":",null," "]
[null,null,"<instrukcja n>"]
[null,null,"End Sub"]
[]
[]
[null,"Wstążka Deweloper -> Edytor Visual Basic"]
[]
[null,"Insert -> Module",null,null,"Pierwsze makro"]

{"sheet":"Typy danych","index":5,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dane na których operują makra mogą być zapisane:"]
[null,"1) w komórkach arkusza kalkulacyjnego,"]
[null,"2) w wewnętrznej pamięci VBA jako stałe i zmienne"]
[]
[null,"Ad.1"]
[]
[null,"Range[„A1”]  lub krócej [A1] oznacza komórkę A1 arkusza"]
[null,"Range[„B1:D3”]  lub krócej [A1:D3] oznacza zakres A1:D3 arkusza kalkulacyjnego"]
[null,"ActiveCell oznacza wybraną (aktywną) komórkę arkusza"]
[null,"Selection oznacza wybrany (zaznaczony) zakres arkusza"]
[]
[null,"Ad. 2"]

{"sheet":"Arkusz8","index":6,"n_rows":81,"n_cols":3,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Select Case wyrażenie_testowane "]
[null,"[Case lista_wyrażeń-n"]
[null,"[instrukcje-n]] "]
[null,null,"..."]
[null,"[Case Else"]
[null,"[instrukcje]] "]
[null,"End Select "]
[null,"lista_wyrażeń-n    może być następującej postaci:"]
[null,"Case 1 To 4, 7 To 9, 11, 13, Is > MaxNumber "]

{"sheet":"Arkusz1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Wykład 2","index":8,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"WYKŁAD 2"]
[]
[null,"- Zmienna ActiveCell"]
[null,"- Funkcje definiowane przez użytkownika "]
[null,null,"(funkcje VBA)"]

{"sheet":"Arkusz2","index":9,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5]]}
[null,null,"Makro",null,"Funkcja VBA"]
[null,-123,"W. dodatnia",null,{"$f":"wartosc(B2)","v":{"$error":"#NAME?"}}]
[null,-0.89202885201973725,"W. ujemna",null,{"$f":"wartosc(B3)","v":{"$error":"#NAME?"}}]
[null,-0.89202885201973725,"W. ujemna",null,{"$error":"#NAME?"}]
[null,0.12610880934176283,"W. dodatnia",null,{"$error":"#NAME?"}]
[null,1.0461539548636634,"W. dodatnia",null,{"$error":"#NAME?"}]
[null,-2.0068602521184431,"W. ujemna",null,{"$error":"#NAME?"}]
[null,0,"Zero",null,{"$error":"#NAME?"}]
[null,1.2993737953772344,"W. dodatnia",null,{"$error":"#NAME?"}]
[null,2.0712295282901549,"W. dodatnia",null,{"$error":"#NAME?"}]
[null,-0.59338865452910561,"W. ujemna",null,{"$error":"#NAME?"}]
[null,-1.6880654078634882,"W. ujemna",null,{"$error":"#NAME?"}]
[null,0.85691766065347341,"W. dodatnia",null,{"$error":"#NAME?"}]
[null,-2.2085854755914003,"W. ujemna",null,{"$error":"#NAME?"}]
[null,0,"Zero",null,{"$error":"#NAME?"}]

{"sheet":"Arkusz3","index":10,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Struktury programowania arkusza kalkulacyjnego"]
[]
["Moduł  -  Edytor VBA  -  Insert  - Module"]
["Makro"]
[null,null,null,null,"Sub nazwa ()"]
[null,null,null,null,null,null,"instrukcje "]
[null,null,null,null,"End Sub "]
[]
["Funkcja VBA"]
[]
[null,null,null,null,"Function nazwa (lista_argumentów) As typ"]
[null,null,null,null,null,null,"instrukcje"]
[null,null,null,null,null,null,"nazwa = wyrażenie "]
[null,null,null,null,"End Function "]