{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Wykład 2","Typy danych","ActiveCell","Inst przyp. i if","MakroFunkcja","Przykład1","Podatek 2012"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":6,"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":"Wykład 2","index":0,"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":"Typy danych","index":1,"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":"ActiveCell","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null," Zmienna ActiveCell"]
[]
[null,null,"Zaznaczona (wybrana) ramką komórka, do której można bezpośrednio wpisywać dane."]
[null,null,"Względem komórki ActiveCell możemy wskazywać inne komórki arkusza używając indeksów:  ActiveCell(w,k)"]
[]
[null,null,"Wybieranie komórki z poziomu VBA : … .select,  np.: [C7].select,   ActiveCell(2,1).select"]
[]
[]
[null,null,null,null,"…..(-1,1)"]
[null,null,null,null,"ActiveCell(0,1)"]
[null,null,"…..(1,-1)","ActiveCell(1,0)","ActiveCell\nActivecell(1,1)","ActiveCell(1,2)","…..(1,3)","…..(1,4)","…..(1,5)"]
[null,null,null,null,"ActiveCell(2,1)","ActiveCell(2,2)","…..(2,3)","…..(2,4)","…..(2,5)"]
[null,null,null,null,"…..(3,1)",null,"…..(3,3)","…..(3,4)","…..(3,5)"]
[null,null,null,null,null,null,"…..(4,3)","…..(4,4)","…..(4,5)"]

{"sheet":"Inst przyp. i if","index":3,"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":"MakroFunkcja","index":4,"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 "]

{"sheet":"Przykład1","index":5,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5]]}
[null,null,"Makro",null,"Funkcja VBA"]
[null,-123,"ujemna",null,{"$f":"abc(B2)","v":"ujemna"},{"$f":"podwajaj(B2)","v":-246}]
[null,-0.89202885201973725,"ujemna",null,{"$f":"abc(B3)","v":"ujemna"},{"$f":"podwajaj(B3)","v":-1.7840577040394745}]
[null,-0.89202885201973725,"ujemna",null,"ujemna",-1.7840577040394745]
[null,0.12610880934176283,"dodatnia",null,"dodatnia",0.25221761868352566]
[null,1.0461539548636634,"dodatnia",null,"dodatnia",2.0923079097273267]
[null,-2.0068602521184431,"ujemna",null,"ujemna",-4.0137205042368862]
[null,0,"zero",null,"zero",0]
[null,1.2993737953772344,"dodatnia",null,"dodatnia",2.5987475907544688]
[null,2.0712295282901549,"dodatnia",null,"dodatnia",4.1424590565803099]
[null,-0.59338865452910561,"ujemna",null,"ujemna",-1.1867773090582112]
[null,-1.6880654078634882,"ujemna",null,"ujemna",-3.3761308157269765]
[null,0.85691766065347341,"dodatnia",null,"dodatnia",1.7138353213069468]
[null,-2.2085854755914003,"ujemna",null,"ujemna",-4.4171709511828006]
[null,0,"zero",null,"zero",0]

{"sheet":"Podatek 2012","index":6,"n_rows":69,"n_cols":12,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,"PODATEK DOCHODOWY 2012"]
[]
[null,"Grupa","Od kwoty","Do kwoty","Kwota pod.","%pod.","Sposób obliczenia podatku"]
[null,0,0,3091,0,0,0]
[null,1,3091,85528,0,0.18,"18% dochodu -556,38 zł"]
[null,2,85528,null,14839.02,0.32,"32% nadwyżki dochodu powyżej 85528 zł plus kwota 14 839,02 zł"]
[]
[null,"Nazwisko","Imię","Dochód","Grupa ","Podatek","Podatek VBA","Podatek1","Podatek2",{"$f":"18%*D5","v":15395.039999999999}]
[null,"Kresa","Krystyna",46500,{"$f":"grupa(D9)","v":1},{"$f":"IF(Dochód<próg1,0,IF(Dochód<próg2,18%*Dochód-podatek0,40%*(Dochód-próg2)+14839.02))","v":7813.62},{"$f":"podatek(D9)","v":7813.62},{"$f":"podatek1(D9)","v":7813.62},7813.62,{"$f":"18%*D4","v":556.38}]
[null,"Kresa","Kazimierz",43500,{"$f":"grupa(D10)","v":1},7273.62,{"$f":"podatek(D10)","v":7273.62},{"$f":"podatek1(D10)","v":7273.62},7273.62,{"$f":"J8-J9","v":14838.66}]
[null,"Tymicz","Zenon",26700,1,4249.62,4249.62,4249.62,4249.62]
[null,"Dragon","Józef",33000,1,5383.62,5383.62,5383.62,5383.62]
[null,"Szymański","Jan",54720,1,9293.2200000000012,9293.2199999999993,9293.2199999999993,9293.2199999999993]
[null,"Nowakowski","Marek",80250,1,13888.62,13888.62,13888.62,13888.62,null,1,{"$f":"ile_dni_ma_miesiąc(K14)","v":31}]
[null,"Krajewska","Lucyna",63240,1,10826.82,10826.82,10826.82,10826.82,null,2,{"$f":"ile_dni_ma_miesiąc(K15)","v":28}]
[null,"Ligocki","Ryszard",23130,1,3607.0199999999995,3607.02,3607.02,3607.02,null,3,31]
[null,"Trela","Anna",96000,{"$f":"grupa(D17)","v":2},19027.82,18190.060000000001,18190.060000000001,18190.060000000001,null,4,30]
[null,"Wojciechowska","Ewa",52290,{"$f":"grupa1(D18)","v":1},8855.82,8855.82,8855.82,8855.82,null,5,31]
[null,"Żakowski","Robert",19944,1,3033.54,3033.54,3033.54,3033.54,null,6,30]
[null,"Paluch","Krystyna",26760,1,4260.42,4260.42,4260.42,4260.42,null,7,31]
[null,"Paluch","Edward",36018,1,5926.86,5926.86,5926.86,5926.86,null,8,31]
[null,"Sroka","Wanda",41838,1,6974.46,6974.46,6974.46,6974.46,null,9,30]
[null,"Długosz","Ludwik",87018,2,15435.02,15315.82,15315.82,15315.82,null,10,31]
[null,"Długosz","Aneta",43200,1,7219.62,7219.62,7219.62,7219.62,null,11,30]
[null,"Chojnacka","Edyta",43269,1,7232.04,7232.04,7232.04,7232.04,null,12,31]
[null,"Banaszak","Aleksander",52650,1,8920.6200000000008,8920.6200000000008,8920.6200000000008,8920.6200000000008]
[null,"Góralczyk","Wojciech",78330,1,13543.02,13543.02,13543.02,13543.02]
[null,"Puchalski","Marian",13254,1,1829.3399999999997,1829.34,1829.34,1829.34]
[null,"Rudnicka ","Halina",54729,1,9294.84,9294.84,9294.84,9294.84]
[null,"Rudnicki","Józef",33900,1,5545.62,5545.62,5545.62,5545.62]
[null,"Andrzejczak","Helena",23283,1,3634.5599999999995,3634.56,3634.56,3634.56]
[null,"Samborska","Małgorzata",85044,1,14751.54,14751.54,14751.54,14751.54]
[null,"Grabowski","Jacek",68976,1,11859.300000000001,11859.3,11859.3,11859.3]
[null,"Wysocki","Rafał",43074,1,7196.94,7196.94,7196.94,7196.94]
[null,"Gruca","Grzegorz",40185,1,6676.92,6676.92,6676.92,6676.92]
[null,"Gruca","Helena",73680,1,12706.02,12706.02,12706.02,12706.02]
[null,"Gruca","Cezary",33750,1,5518.62,5518.62,5518.62,5518.62]
[null,"Szymczak","Janusz",108864,2,24173.42,22306.54,22306.54,22306.54]
[null,"Turski","Zbigniew",13650,1,1900.62,1900.62,1900.62,1900.62]
[null,"Śliwińska","Magdalena",36600,1,6031.62,6031.62,6031.62,6031.62]
[null,"Ejsmont","Barbara",39600,1,{"$f":"IF(Dochód<próg1,0,IF(Dochód<próg2,18%*Dochód-podatek0,40%*(Dochód-próg2)+14839.02))","v":6571.62},6571.62,{"$f":"podatek1(D41)","v":6571.62},6571.62]
[null,"Bugalska","Ewa",57690,1,9827.82,9827.82,9827.82,9827.82]
[null,"Bugalski","Leszek",39600,1,6571.62,6571.62,6571.62,6571.62]
[null,"Cichocki","Marian",60420,1,10319.220000000001,10319.219999999999,10319.219999999999,10319.219999999999]
[null,"Ginalski","Józef",134340,2,34363.82,30458.86,30458.86,30458.86]
[null,"Filipczyk","Czesław",78900,1,13645.62,13645.62,13645.62,13645.62]
[null,"Maciejewski","Zygmunt",16995,1,2502.7199999999998,2502.7199999999998,2502.7199999999998,2502.7199999999998]
[null,"Bogucewicz","Cecylia",34200,1,5599.62,5599.62,5599.62,5599.62]
[null,"Banasiak","Feliks",85380,1,14812.02,14812.02,14812.02,14812.02]
[null,"Banasiak","Agnieszka",146556,2,39250.22,34367.980000000003,34367.980000000003,34367.980000000003]
[null,"Wiśniewska","Grażyna",51996,1,8802.9,8802.9,8802.9,8802.9]
[null,"Biedrzycki","Zbigniew",30726,1,4974.2999999999993,4974.3,4974.3,4974.3]
[null,"Pogorzelski","Jerzy",76440,1,13202.82,13202.82,13202.82,13202.82]
[null,"Kacprzyk","Dominika",18990,1,2861.8199999999997,2861.82,2861.82,2861.82]
[null,"Kacprzyk","Cecylia",33720,1,5513.2199999999993,5513.22,5513.22,5513.22]
[null,"Rokita","Marta",80100,1,13861.62,13861.62,13861.62,13861.62]
[null,"Tokarczuk","Agata",87900,2,15787.82,15598.06,15598.06,15598.06]
[null,"Osowska","Maria",48726,1,8214.3000000000011,8214.2999999999993,8214.2999999999993,8214.2999999999993]
[null,"Leszczyk","Mikołaj",114780,2,26539.82,24199.66,24199.66,24199.66]
[null,"Dziuba","Bożena",74760,1,12900.42,12900.42,12900.42,12900.42]
[null,"Rybak","Piotr",44316,1,7420.5,7420.5,7420.5,7420.5]
[null,"Zalewski","Robert",98010,2,19831.82,18833.259999999998,18833.259999999998,18833.259999999998]
[null,"Nitecka","Jolanta",22920,1,3569.2199999999993,3569.22,3569.22,3569.22]
[null,"Rokita","Stanisław",36120,1,5945.2199999999993,5945.22,5945.22,5945.22]
[null,"Rokita","Maria",35400,1,5815.62,5815.62,5815.62,5815.62]
[null,"Skrzypczak","Jadwiga",33930,1,5551.0199999999995,5551.02,5551.02,5551.02]
[null,"Łopata","Henryk",11940,1,1592.8199999999997,1592.82,1592.82,1592.82]
[null,"Zabawa","Krzysztof",84822,1,14711.58,14711.58,14711.58,14711.58]
[null,"Bezrobotny","Kazimierz",3000,0,0,0,0,0]