{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Zber","List2","List3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Zber","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"CSŠ VRANOV"]
[]
["Zber papiera v kg"]
["Trieda","Január","Február","Marec","Spolu","Priemer","Max","Min"]
["Príma",1500,1200,1750]
["Sekunda",1200,1300,1000]
["Tercia",1000,1100,950]
["Kvarta",900,700,800]
["Kvinta",1100,1000,1200]
["Sexta",800,500,600]
[]
["1.Bunky A3 až H3 zlúčte a zarovnajte na stred, písmo Arial 15, farba červená, tučné, šikmé, podfarbené na modro"]
["2.Veľkosť písma v bunkách A4 až H4 je Arial 12, farba modrá, šikmé, podfarbené žltou farbou"]
["3.Usporiadajte triedy podľa abecedy - pomocou filtra"]
["4. Pomocou funkcie vypočítajte koľko papiera nazbierali triedy spolu za obdobie január - marec a aký bol ich mesačný priemer"]
["5. Pomocou funkcie vypočítajte, v ktorom mesiaci nazbierali jednotlivé triedy najviac a najmenej kg"]
["6. Pomocou podmieneného formátovania zvýraznite ľubovoľnou farbou priemer väčší ako 1000 kg"]
["7.Orámujte a upravte tabuľku podľa vlastného uváženia "]
["8.Vytvorte stĺpcový graf (trieda a spolu) a vložte ho pod tabuľku"]
["9.Upravte graf - vlož nadpis, označenie osí, upravte mriežku, aby hlavná jednotka bola nastavená na hodnotu 400"]
["10. Nad jednotlivými stĺpcami v grafe zobrazte hodnotu"]
["11. Graf ľubovoľne podfarbite"]

{"sheet":"List2","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Predaj automobilov"]
[]
["Typ","Január","Február","Marec","Spolu","Percentuálny podiel","Priemer","Max","Min"]
["Škoda",1300,1800,1600,4700,0.2585542964022445,1566.6666666666667,1800,1300]
["Audi",25,32,41,98,0.005391132137748928,32.666666666666664,41,25]
["VW",700,900,800,2400,0.1320277258224227,800,900,700]
["Renault",850,950,1100,2900,0.15953350203542743,966.6666666666666,1100,850]
["Dacia",320,430,380,1130,0.062163054241390694,376.6666666666667,430,320]
["Citroen",480,520,560,1560,0.08581802178457476,520,560,480]
["Ford",150,220,240,610,0.03355704697986577,203.33333333333334,240,150]
["Hyundai",280,340,310,930,0.0511607437561888,310,340,280]
["Kia",780,860,920,2560,0.14082957421058423,853.3333333333334,920,780]
["Fiat",150,180,90,420,0.023104852018923976,140,180,90]
["Ostatné",280,340,250,870,0.04786005061062823,290,340,250]
["Spolu",5315,6572,6291,18178,1]

{"sheet":"List3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}