{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Odcinek009","Ściąga"],"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":"Odcinek009","index":0,"n_rows":58,"n_cols":26,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["a",0,0,"A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","Długość",10,"Sekundy","MInuty","Godziny","Dni","Lata"]
["b",1,1,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",1,{"$f":"U$1^T2","v":10},{"$f":"U2/15","v":0.66666666666666663},{"$f":"V2/60","v":1.111111111111111E-2},{"$f":"W2/60","v":1.8518518518518518E-4},{"$f":"X2/24","v":7.7160493827160496E-6},{"$f":"Y2/365","v":2.1139861322509725E-8}]
["c",2,2,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",2,{"$f":"U$1^T3","v":100},{"$f":"U3/15","v":6.666666666666667},{"$f":"V3/60","v":0.11111111111111112},1.8518518518518519E-3,{"$f":"X3/24","v":7.7160493827160492E-5},{"$f":"Y3/365","v":2.1139861322509723E-7}]
["d",3,3,"D",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q3-Q2)*60*60*24","v":0},null,"D",3,{"$f":"U$1^T4","v":1000},66.666666666666671,1.1111111111111112,1.8518518518518521E-2,{"$f":"X4/24","v":7.71604938271605E-4},2.1139861322509726E-6]
["e",4,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA",4,{"$f":"U$1^T5","v":10000},666.66666666666663,11.111111111111111,0.18518518518518517,{"$f":"X5/24","v":7.716049382716049E-3},2.1139861322509723E-5]
["f",5,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BA",5,{"$f":"U$1^T6","v":100000},6666.666666666667,111.11111111111111,1.8518518518518519,{"$f":"X6/24","v":7.716049382716049E-2},2.1139861322509723E-4]
["g",6,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA",6,{"$f":"U$1^T7","v":1000000},66666.666666666672,1111.1111111111111,18.518518518518519,{"$f":"X7/24","v":0.77160493827160492},2.1139861322509723E-3]
["h",7,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DA",7,{"$f":"U$1^T8","v":10000000},666666.66666666663,11111.111111111111,185.18518518518519,{"$f":"X8/24","v":7.7160493827160499},2.1139861322509727E-2]
["i",8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB",8,{"$f":"U$1^T9","v":100000000},6666666.666666667,111111.11111111111,1851.8518518518517,{"$f":"X9/24","v":77.160493827160494},0.21139861322509723]
["j",9,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BB",9,{"$f":"U$1^T10","v":1000000000},66666666.666666664,1111111.111111111,18518.518518518518,{"$f":"X10/24","v":771.60493827160496},2.1139861322509725]
["k","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CB",10,{"$f":"U$1^T11","v":10000000000},666666666.66666663,11111111.11111111,185185.18518518517,{"$f":"X11/24","v":7716.049382716049},21.139861322509724]
["l","!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DB",11,{"$f":"U$1^T12","v":100000000000},6666666666.666667,111111111.11111112,1851851.8518518519,{"$f":"X12/24","v":77160.493827160491},211.39861322509725]
["m","#",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC",12,{"$f":"U$1^T13","v":1000000000000},66666666666.666664,1111111111.1111112,18518518.518518519,{"$f":"X13/24","v":771604.93827160494},2113.9861322509723]
["n","%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BC"]
["o","?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CC"]
["p",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DC"]
["r",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AD"]
["s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BD"]
["t",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD"]
["u",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD"]
["w",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AAA"]
["x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BAA"]
["y",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAA"]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAA"]
["A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABA"]
["B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BBA"]
["C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CBA"]
["D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DBA"]
["E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACA"]
["F",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BCA"]
["G",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DCA"]
["H"]
["I"]
["J"]
["K"]
["L"]
["M"]
["N"]
["O"]
["P"]
["R"]
["S"]
["T"]
["U"]
["W"]
["X"]
["Y"]
["Z"]
[0]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]

{"sheet":"Ściąga","index":1,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Materiały Microsoft"]
["https://learn.microsoft.com/en-us/office/vba/language/reference/statements"]
[]
["\"Cells(W,K) =A\" \nnadaje wartość A komórce o wierszu W i kolumnie K"]
["Cells(1,2)=3 oznacza przypisanie komórce B1 wartości 3"]
[]
["„Cells(W,K).Select” \nzaznacza komórkę o wierszu W i kolumnie K"]
["Cells(4,5).Select oznacza zaznaczenie komórki E4"]
[]
["“Range(Cells(W1,K1),Cells(W2,K2)).Select”   \nzaznacza obszar którego rogami są komórki W1 K1 oraz W2 K2 (gdzie W i K to numery wierszy)"]
["Range(Cells(6,7),Cells(8,9)).Select oznacza zaznaczenie obszaru którego rogami są komórki G6 oraz I8"]
[]
["„For Z=X to Y\nNext” \npowtarza zawarte pomiędzy liniami For oraz Next linie kodu zwiększając za każdym razem zmienną Z o jeden od wartości X aż do Y."]
["Czyli np. For i=1 to 10\n    Cells(i,1)=i\nNext \noznacza że i po kolei przyjmuje wartości 1,2,3,4 …. 10 wpisując te wartości w komórki A1,A2, A3, A4, ….A10"]
[]
["\"If Warunek Then\n    Kod1\nElse\n    Kod2\nEnd If\"\nrealizuje Kod 1 gdy postawiony Warunek jest spełniony a Kod 2 gdy nie"]
["Czyli np.\nIf X>0 Then \n    X=X+1\nElse\n    X=X-2\nEnd If\nSprawdza czy zmienna X jest większa od 0 i dodaje do niej 1 jeżeli jest a odejmuje 2 jeżeli nie jest"]
[]
["„Left(Tekst,Ilość_Znaków)” \nzwraca Ilość_Znaków Tekstu od lewej strony"]
["Czyli np.:\nTekst=Left(„Wesołych Świąt\",8) \nprzypisze zmiennej Tekst wartość „Wesołych”"]
[]
["„Split (Tekst,”znak rozdzielający”)” \ndziali tekst na szereg mniejszych tekstów które w tekście źródłowym były rozdzielone wskazanym znakiem"]
["Czyli np.\nWynik = Split(„Anna;Adam;Andrzej;Waldemar\",”;”) \nspowoduje przypisanie tabeli Wynik poszczególnych imion a w szczególności Wynik(0)=”Anna”,  Wynik(1)=”Adam”, Wynik(3)=”Andrzej”, Wynik(4)=”Waldemar”"]
[]
["\"Dim Tabela() As String\"\t\ndefiniuje tabelę tekstów o nazwie \"Tabela\" "]
[]
["“While Warunek \n          Kod 1\nWend”"]
["Pętla która wykonuje Kod 1 dopóki spełniony jest Warunek "]
["Czyli np.\nX=0\nWhile X<10 \n     X=X+1\nWend"]
["Będzie dodawać do X 1 dopóki X nie osiągnie wartości 10"]
["                          "]
["„Application.ScreenUpdating = False”"]
["„Application.ScreenUpdating = True”"]
[" Wyłączanie i włączanie aktualizacji wyświetlania, ważne gdy chcemy przyśpieszyć nasze makra"]
["                                           "]
["„Application.Calculation = xlManual”"]
["“Application.Calculation = xlAutomatic”                                          "]
["Przełączanie pomiędzy manualnym i automatycznym przeliczaniem komórek arkusza, ważne gdy chcemy przyśpieszyć nasze makra"]
["                                               "]
["„Application.DisplayAlerts = False “         "]
["“Application.DisplayAlerts = True”                                                "]
["Wyłączanie I włączanie wyświetlania alertów, ważne gdy nie chcemy aby makro było przerywane przez wyświetlane komunikaty"]
[]
["Wynik = InputBox(\"Treść zachęty\")"]
["Wyświetla komunikat „Treść zachęty” wraz z polem do wpisania wartości przez użytkownika. Wpisana wartość jest przypisywana do zmiennej Wynik"]