{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Úvod","If then - základ","If then - rozsah","Více podmínek","Ošetření problému"],"not_rendered":{"charts":0,"images":9,"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":"Úvod","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,1,29,11],[1,2,1,9],[2,2,2,9],[14,2,15,6],[17,3,18,6],[18,7,18,9]]}
[]
[null,null,"Jak na Excel "]
[null,null,"MUNI"]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"Podmínky"]
[null,null,null,null,"If … Then"]
[null,null,null,null,"rozsahy"]
[null,null,null,null,"Více podmínek"]
[null,null,null,null,"Ošetření"]
[]
[]
[]
[null,null,"Pavel Lasák"]
[]
[]
[null,null,null,"Lektor, expert na Microsoft Excel, držitel prestižního ocenění Microsoftu MVP v České republice"]
[null,null,null,null,null,null,null,5002722]
[]
[]
[]
[]
[null,null,null,"Další informace ke cvičení:"]
[]
[]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2017"]

{"sheet":"If then - základ","index":1,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[7,1,7,3],[10,1,10,3],[33,0,33,4]]}
["IF - THEN - Excel VBA"]
["office.lasakovi.com"]
[]
[]
[]
[]
[]
[null,"V MsgBox mám jen tuto informaci (kó):"]
[null,"i = MsgBox(\"Jsi muž?\", vbYesNo, \"Kdo\")",null,"i = MsgBox(\"Jsi žena?\", vbYesNo, \"Kdo\")"]
[]
[null,"Co odpověděl uživatel"]
[null,"Je muž",null,"Je žena"]
[null,"    If i =6 Then",null,"    If i = vbYes Then"]
[null,"    MsgBox \"Jsi muž.\"",null,"                MsgBox \"Jsi žena.\""]
[null,"    End If",null,"    End If"]
[]
[null,"    If i = 7 Then",null,"    If i = vbNo Then"]
[null,"    MsgBox \"Jsi žena.\"",null,"              MsgBox \"Jsi muž.\""]
[null,"    End If",null,"    End If"]
[]
[]
[null,"Je muž zjednodušení",null,"Je žena"]
[null,"If i =6 Then",null,"    If i = vbYes Then"]
[null,"    MsgBox \"Jsi muž.\"",null,"                MsgBox \"Jsi žena.\""]
[null,"else",null,"else"]
[null,"    MsgBox \"Jsi žena.\"",null,"              MsgBox \"Jsi muž.\""]
[null,"End If",null,"    End If"]
[]
[]
[]
[]
[]
[]
["Pavel Lasák 2017"]

{"sheet":"If then - rozsah","index":2,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,6],[11,0,11,6],[19,0,19,6],[18,0,18,6]]}
["IF - THEN - Excel VBA"]
["office.lasakovi.com"]
[]
["Je věští než 2"]
[]
[null,null,null,null,null,null,null,null,"Číslo"]
[]
[null,null,null,null,null,null,null,null,"If Hodnota > 2 Then"]
[null,"Načítám číslo, není ošetřeno, zda je číslo",null,null,null,null,null,null,"MsgBox \"Je větší než 2\""]
[null,"Hodnota = InputBox(\"Zadej číslo:\", \"číslo then\", 0)",null,null,null,null,null,null,"End If"]
[]
["Je věští než 2?"]
[]
[null,null,null,null,null,null,null,null,"If Hodnota > 2 Then"]
[null,null,null,null,null,null,null,null,"MsgBox \"Je větší než 2\""]
[null,null,null,null,null,null,null,null,"else"]
[null,null,null,null,null,null,null,null,"MsgBox \"není větší než 2\""]
[null,null,null,null,null,null,null,null,"End If"]
["ElseIf"]
["Potřebuji rozhodnout o věku"]
[null,null,null,null,null,null,null,null,"Rozhodnout"]
[null,null,null,null,null,null,null,null,"If Vek < 15 Then"]
[null,null,null,null,null,null,null,null,"      MsgBox \"Jsi dite.\""]
[null,"Chci rozhodnout podle věku",null,null,null,null,null,null,"ElseIf Vek < 30 Then"]
[null,"Vek = InputBox(\"Zadej svůj věk:\", \"Ukázka then více\", 0)",null,null,null,null,null,null,"      MsgBox \"Jsi mlaďoch.\""]
[null,null,null,null,null,null,null,null,"ElseIf Vek < 60 Then"]
[null,null,null,null,null,null,null,null,"      MsgBox \"Jsi v nejlepších letech.\""]
[null,null,null,null,null,null,null,null,"Else"]
[null,null,null,null,null,null,null,null,"      MsgBox \"Jsi téměř v důchodu.\""]
[null,null,null,null,null,null,null,null,"End If"]

{"sheet":"Více podmínek","index":3,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,3]]}
["IF - THEN - Excel VBA - více podmínek"]
["office.lasakovi.com"]
[]
["Zjisti zda je o muže/ženu a v jakém oddělení pracuje"]
[]
[null,"žena","Pohlaví"]
[null,"PR","Oddělení"]
[]
[]
[]
[null,null,"Odpoved1 = Range(\"B6\").Value","Poznámka: Načtení bude probráno později"]
[null,null,"Odpoved2 = Range(\"B7\").Value","V Odpoved1, Odpoved2 jsou nactené hodnoty muž, žena nebo HR, PR"]
[]
[null,null,"If Odpoved1 = \"žena\" And Odpoved2 = \"HR\" Then"]
[null,null,"    MsgBox \"Jsi žena z odděleení HR.\""]
[null,null,"ElseIf Odpoved1 = \"žena\" And Odpoved2 = \"PR\" Then"]
[null,null,"    MsgBox \"Jsi žena z oddělení PR.\""]
[null,null,"ElseIf Odpoved1 = \"muž\" And Odpoved2 = \"HR\" Then"]
[null,null,"    MsgBox \"Jsi muž z HR.\""]
[null,null,"Else"]
[null,null,"    MsgBox \"Jsi muž z PR.\""]
[null,null,"End If"]

{"sheet":"Ošetření problému","index":4,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["IF - THEN - Excel VBA - více podmínek"]
["office.lasakovi.com"]
[]
[]
[]
[]
[null,null,"On Error GoTo nalezen_problem"]
[null,null,"Dim number As Integer"]
[]
[null,null,"number = InputBox(\"Zadej číslo: \")"]
[]
[null,null,"If number Mod 2 = 0 Then"]
[null,null,"    MsgBox \"Číslo sude!\""]
[null,null,"Else"]
[null,null,"    MsgBox \"Číslo liché!\""]
[null,null,"End If"]
[]
[null,null,"Exit Sub"]
[]
[null,null,"nalezen_problem:"]
[null,null,"MsgBox \"Problém, asi nebylo zadáno číslo :)\""]