{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Input","List0","List1","List2","List3","List4","Data"],"not_rendered":{"charts":0,"images":2,"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":"Input","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Otázka č.1:"]
[null,"Ako spraviť?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Na základne troch podmienok dostanem názov makra (v DATA)"]
[null,null,"tlačítko vyvolá makro ktorého názov (číslo) je v DATA C28 (skrytý hárok)"]
[null,"Neviem, čo určuje rozsahy pri tých kombináciách.  Predpokladajme, že medzi nimi nieje žiadna spojitosť, žiadny vzorec. Potom mrk do makra a obdobne si nastavte rozsahy."]
[null,"Ide o to, aby ste nemusel mať 20 takmer rovnakých makier, ale aby to bolo napr. jedno univerzálne. Najskôr si v makre upravte/dorobte tie rozsahy."]
[null,"Teraz predpokladám, že listov je 5, a CodeName majú List0, List1,... Pričom to číslo je práve prvá číslica Vašeho kódu."]
[]
[null,"Otázka č.2:"]
[null,"Len pre informáciu, takéto niečo sa dá spraviť aj s priamou tlačou? Teda nie export do pdf, ale rovno to pošle na tlačiareň? "]
[null,"Ak sa volá makro s parametrom True, tak je to PDF, ak False tak tlačí."]
[]
[]
[]
[null,"Otázka č.3:"]
[null,"Je možné zakázať na tomto liste horizontálny a vodorovný posun?"]
[null,"Na liste, ktorý nehcete aby sa posúval, zadajte do vlastnosti ScrollArea požadovanú povolenú oblasť pre označenie buniek a scrollovanie."]

{"sheet":"List0","index":1,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["fg","f","fg"]
["hfh"]
[null,null,null,null,null,null,null,null,null,"ydfhgh"]
[]
[]
["g"]
[null,null,"h",null,"f"]
[null,"___"]
[]
[]
[null,null,"l§jghj"]
[]
[]
[null,"jghjgh"]
[]
[]
[]
[]
[]
[]
[null,null,null,"f"]
[null,null,null,null,"h"]
[]
[null,null,null,null,null,null,null,"f"]
[]
[]
[]
[]
[]
[null,null,null,null,"g"]
[null,null,null,null,"gh"]
[]
[]
[null,null,null,null,null,null,null,"g"]
[]
[null,"h","g"]

{"sheet":"List1","index":2,"n_rows":126,"n_cols":11,"rows_kept":126,"cut":false,"hidden":true,"merged":[]}
[]
["gf"]
["skrytý 2",null,null,"r"]
[null,null,null,null,null,"e"]
[null,null,"e",null,"t",null,null,"r"]
[]
[]
[]
[]
[null,"h"]
[null,null,null,null,null,null,null,"h"]
[null,null,null,null,null,null,null,"g"]
[null,"f",null,null,"t"]
[null,null,"g",null,"w"]
[null,null,null,null,null,null,"f"]
[]
[null,"r",null,null,null,null,null,"r"]
[null,null,null,null,null,null,null,"h"]
["t"]
[null,null,null,"t"]
[null,null,null,null,null,null,"r"]
[]
[]
[]
[]
[null,null,"ad",null,"er"]
[]
["sd",null,null,null,"er"]
[]
[null,"f",null,null,null,"g"]
[]
[]
[]
[null,null,null,null,null,null,null,"fg"]
[]
[]
[null,null,"f"]
[]
[null,null,null,null,null,null,"r"]
[]
[]
[null,null,null,"df",null,null,null,"d"]
[]
[]
[null,null,null,null,"df"]
[null,"r"]
[]
[]
[]
[]
[null,"d"]
[null,null,null,null,null,null,null,"t"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"d"]
[]
[]
["r"]
["s"]
[null,null,null,null,"rt"]
[]
[]
[]
[null,null,"d"]
[]
[]
[]
[]
[null,null,"f",null,null,null,null,"d"]
[]
[]
[]
[null,null,null,null,null,"f"]
[]
[null,null,null,null,"e"]
[]
[]
[null,"f"]
[]
[]
[]
[]
[null,null,"e"]
[]
[]
[null,null,null,null,null,null,"f"]
[null,null,null,null,null,null,null,null,null,"t"]
[]
[]
[null,null,null,null,null,null,"d","f"]
[]
[null,null,"e"]
[]
[null,null,null,null,null,null,"f"]
[]
[null,null,null,null,null,null,null,"f"]
[]
[null,null,"e"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"t",null,"r"]
[]
[]
[]
[]
[]
[null,"e"]
[null,null,null,null,null,null,null,"e"]
[null,null,null,null,null,null,null,null,"r"]
[]
[]
[]
[null,"e"]
[null,null,null,null,null,null,"e"]
["et",null,"r","yt","ry"]
["e",null,"y",null,null,null,"e"]
[]
[null,null,null,null,"e"]
[null,null,null,"e","e"]
[null,null,"er",null,null,null,"e"]

{"sheet":"List2","index":3,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"___"]
[]
[]
[null,null,"l§jghj"]
[]
[]
[null,"jghjgh"]
[]
[]
[]
[null,null,null,null,null,"rytryry"]
[]
[]
[null,"yrt"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"ry"]
[null,"ter","try"]
[]
[null,null,null,null,null,"try"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"y"]
[]
[]
[]
[]
[null,null,null,null,null,"ryryry"]
[]
[null,null,null,"tyrtyt"]
[null,null,null,null,"ryrtyr"]
[]
[null,"ty",null,null,"rytrytr"]

{"sheet":"List3","index":4,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
[5464]
[]
[]
[]
[]
[]
[]
[]
[null,null,63]
[null,null,7,null,4]
[]
[]
[]
[]
[null,null,null,687]
[]
[null,null,86]
[]
[]
[null,null,null,null,6]
[]
[]
[]
[null,7]
[]
[]
[]
[null,8]
[null,null,87]
[]
[null,null,null,null,456]

{"sheet":"List4","index":5,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
[]
[]
[8]
[]
[]
[]
[]
[null,null,null,8,null,null,null,8]
[null,null,null,null,null,null,null,null,8]
[]
[]
[null,8]
[null,null,null,null,null,null,8]
[]
[]
[]
[null,null,null,7]
[null,8,null,8]
[null,null,null,null,null,null,null,88]
[]
[null,null,null,null,null,null,null,null,8]
[]
[null,null,6]
[8]
[]
[]
[null,null,null,null,8,null,8]
[]
[]
[]
[]
[]
[8]
[]
[]
[]
[null,null,88]
[null,null,null,null,null,null,null,8]
[]
[null,null,8]
[]
[]
[]
[null,8]
[null,null,null,null,null,8,null,8]
[null,null,null,8]
[]
[]
[]
[null,8]
[]
[null,null,null,null,8]
[]
[]
[null,null,null,null,null,null,8]
[]
[]
[]
[null,null,8]
[null,null,null,null,null,null,null,null,8]
[]
[null,null,null,null,8]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,8]
[null,null,8]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,8]
[]
[]
[]
[]
[]
[]
[]
[null,8]
[]
[]
[null,null,null,null,null,8]

{"sheet":"Data","index":6,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[17,1,17,5],[1,2,1,7],[14,2,14,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[6,2,6,6],[16,2,16,5],[2,2,2,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[19,1,19,5],[18,1,18,5],[22,1,22,5],[23,1,23,5],[24,1,24,5],[21,2,21,5]]}
[]
[null,2,"Device"]
[null,1,"?",null,null,null,null,0]
[null,2,"Single girder overhead crane",null,null,null,null,1]
[null,3,"Single girder overhead crane with runway",null,null,null,null,1]
[null,4,"Single girder overhead crane with column runway",null,null,null,null,1]
[null,5,"Monorail hoist",null,null,null,null,2]
[null,6,"Monorail hoist with support",null,null,null,null,2]
[null,7,"Monorail hoist with columns support",null,null,null,null,2]
[null,8,"Single girder suspension crane",null,null,null,null,3]
[null,9,"Single girder suspension crane with runway",null,null,null,null,3]
[null,10,"Single girder suspension crane with column runway",null,null,null,null,3]
[null,11,"Double girder overhead crane",null,null,null,null,4]
[null,12,"Double girder overhead crane with runway",null,null,null,null,4]
[null,13,"Double girder overhead crane with column runway",null,null,null,null,4]
[]
[null,1,"Bridge type"]
[null,"Rolled bridge"]
[null,"Welded bridge"]
[null,"Atyp bridge"]
[]
[null,3,"Attachment type"]
[null,"A"]
[null,"B"]
[null,"C"]
[]
[]
[null,"Macro:",{"$f":"CONCATENATE(VLOOKUP(B2,B3:H15,7,FALSE),B17,B22)","v":"113"}]