{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Úvod","TEORIE","ZÁKLADY","Pokročilé","výpočty","Další informace"],"not_rendered":{"charts":0,"images":2,"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":"Úvod","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,2,1,9],[13,2,14,6],[16,3,17,6],[17,7,17,9],[28,1,28,11]]}
[]
[null,null,"Jak na Excel "]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"Teorie"]
[]
[null,null,null,null,"Základy"]
[null,null,null,null,"Pokročilé řady"]
[null,null,null,null,"Výpočty"]
[]
[]
[]
[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,null,null,null,"https://office.lasakovi.com/excel/funkce-nove/Nove-funkce-EXCEL-seznam/"]
[null,null,null,null,"https://office.lasakovi.com/excel/funkce-nove/SEQUENCE-rada-cisel-Excel/"]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2020    05/2020, 09/2023"]

{"sheet":"TEORIE","index":1,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,0,21,6],[0,0,0,6],[1,0,1,6],[3,0,3,6],[4,0,4,6],[6,0,6,6],[8,0,8,6],[10,0,10,6],[17,0,17,6]]}
["SEQUENCE (SEQUENCE)"]
["http://office.lasakovi.com"]
[]
["Popis"]
["Aritmetická posloupnost"]
[]
["Syntaxe CZ"]
["=SEQUENCE(řádky; [sloupce]; [začátek]; [krok])"]
["Syntaxe EN"]
["=SEQUENCE (rows, [columns], [start], [step])"]
["Popis argumentů"]
["rows - Number of rows to return."]
["columns - [optional] Number of columns to return."]
["start - [optional] Starting value (defaults to 1)."]
["step - [optional] Increment between each value (defaults to 1)."]
[]
[]
["Příklady"]
[]
[]
[]
["Pavel Lasák - 2019"]

{"sheet":"ZÁKLADY","index":2,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[42,0,42,5],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4]]}
["SEQUENCE (SEQUENCE)"]
["http://office.lasakovi.com"]
[]
[null,"Složka","03 - Funkce"]
[null,"Podsložka","33_Nove-funkce-dynamicke"]
[null,"Soubor","33G - SEQUENCE-sequence.xlsm"]
[null,"Soubor","Základy"]
[]
[]
[]
[null,"Úkol"]
[null,"Vytvořte řadu od 1 do 3 ve sloupci / řádku"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Funkce v B14"]
[null,{"$f":"_xlfn.SEQUENCE(3)","v":1},null,null,null,null,{"$f":"_xlfn.FORMULATEXT(B22)","v":"=SEQUENCE(3)"}]
[null,2]
[null,3]
[]
[]
[null,"Úkol"]
[null,"Vytvořte řadu od 1 do 4 ve řádku"]
[null,{"$f":"_xlfn.SEQUENCE(1,4)","v":1},2,3,4,null,{"$f":"_xlfn.FORMULATEXT(B29)","v":"=SEQUENCE(1;4)"}]
[null,{"$f":"_xlfn.FORMULATEXT(B29)","v":"=SEQUENCE(1;4)"}]
[]
[null,"Tip"]
[null,{"$f":"_xlfn.SEQUENCE(,4)","v":1},2,3,4,null,{"$f":"_xlfn.FORMULATEXT(B33)","v":"=SEQUENCE(;4)"}]
[null,{"$f":"_xlfn.FORMULATEXT(B33)","v":"=SEQUENCE(;4)"}]
[]
[null,"Úkol"]
[null,"Zobrazte čísla 1 - 12 v matici 3x4"]
[null,{"$f":"_xlfn.SEQUENCE(3,4)","v":1},2,3,4,null,{"$f":"_xlfn.FORMULATEXT(B38)","v":"=SEQUENCE(3;4)"}]
[null,5,6,7,8]
[null,9,10,11,12]
[null,{"$f":"_xlfn.FORMULATEXT(B38)","v":"=SEQUENCE(3;4)"}]
[]
["Pavel Lasák - 2019"]

{"sheet":"Pokročilé","index":3,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[26,1,26,4],[32,0,32,5],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4]]}
["SEQUENCE (SEQUENCE)"]
["http://office.lasakovi.com"]
[]
[]
[null,"Složka","03 - Funkce"]
[null,"Podsložka","33_Nove-funkce-dynamicke"]
[null,"Soubor","33G - SEQUENCE-sequence.xlsm"]
[null,"Soubor","Pokročilé"]
[]
[]
[]
[null,"Úkol"]
[null,"Zobrazte čísla 1 - 12 v matici 3x4"]
[null,{"$f":"_xlfn.SEQUENCE(3,4)","v":1},2,3,4]
[null,5,6,7,8]
[null,9,10,11,12]
[null,{"$f":"_xlfn.FORMULATEXT(B14)","v":"=SEQUENCE(3;4)"}]
[]
[null,"Úkol"]
[null,"Zobrazte čísla 10 až  21 v matici 3x4"]
[null,{"$f":"_xlfn.SEQUENCE(3,4,10)","v":10},11,12,13]
[null,14,15,16,17]
[null,18,19,20,21]
[null,{"$f":"_xlfn.FORMULATEXT(B21)","v":"=SEQUENCE(3;4;10)"}]
[]
[null,"Úkol"]
[null,"Zobrazte čísla 10 až 65 Po 5 v matici 3x4"]
[null,{"$f":"_xlfn.SEQUENCE(3,4,10,5)","v":10},15,20,25]
[null,30,35,40,45]
[null,50,55,60,65]
[null,{"$f":"_xlfn.FORMULATEXT(B28)","v":"=SEQUENCE(3;4;10;5)"}]
[]
["Pavel Lasák - 2019"]

{"sheet":"výpočty","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8]]}
["SEQUENCE (SEQUENCE)"]
["http://office.lasakovi.com"]
[]
[]
[null,null,{"$f":"_xlfn.SEQUENCE(,5)","v":1},2,3,4,5]
[null,{"$f":"_xlfn.SEQUENCE(5)","v":1},{"$f":"_xlfn.ANCHORARRAY(C5)*_xlfn.ANCHORARRAY(B6)","v":1},2,3,4,5]
[null,2,2,4,6,8,10]
[null,3,3,6,9,12,15]
[null,4,4,8,12,16,20]
[null,5,5,10,15,20,25]

{"sheet":"Další informace","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Další informace o funkcích"]
["http://office.lasakovi.com"]
[]
[]
[null,"FILTER","https://office.lasakovi.com/excel/funkce-nove/FILTER-vyfiltrovat-data-v-Excel/"]
[null,"RANDARRAY","https://office.lasakovi.com/excel/funkce-nove/RANDARRAY-nahodne-cislo-Excel/"]
[null,"SEQUENCE","https://office.lasakovi.com/excel/funkce-nove/SEQUENCE-rada-cisel-Excel/"]
[null,"SINGLE","funkce již neexistuje, byla pouze v insider verzi"]
[null,"SORT","https://office.lasakovi.com/excel/funkce-nove/SORT-setridit-data-v-Excel/"]
[null,"SORTBY","https://office.lasakovi.com/excel/funkce-nove/SORTBY-setridit-data-v-Excel/"]
[null,"UNIQUE","https://office.lasakovi.com/excel/funkce-nove/UNIQUE-funkce-unikatni-data-v-Excel/"]