{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Zadání","PAHy"],"not_rendered":{"charts":0,"images":1,"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":"Zadání","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1. Na listu PAHy najdete měsíční koncentrace polyaromatických uhlovodíků v letech 2003-2012."]
[null,null,"2. Aktivujte buňku B3 na listu PAHy a zahajte záznam makra, které pojmenujete Graf."]
[null,null,"3. V režimu záznamu makra vytvořte sloupcový graf o čtyřech sloupcích udávajících koncentrace PAHů dne 15.10.2003, bez legendy s popisy osy x z řádku 2 a názvem grafu odpovídajícím kalendářnímu datu."]
[null,null,"4. Přiřaďte makru klávesovou zkratku Ctrl+Shift+Q."]
[null,null,"5. Přemístěte kurzor do buňky B4 a pomocí klávesové zkratky spusťte makro Graf za účelem vytvoření grafu obsahujícího údaje z řádku 4."]
[null,null,"6. Pokud makro neproběhlo, otevřete okno ditoru Visual Basic a pomocí funkce Debug vyhledejte a pokuste se opravit chybu."]
[null,null,"7. Proběhlo-li makro, komentujte, co bylo vykonáno v rozporu s naším požadavkem."]
[null,null,"8. Využijte funkce ActiveCell.Offset() pro relativizaci příslušných vybraných oblastí tak, aby makro kreslilo vždy graf z vybraného řádku."]
[null,null,"9. Vytvořte pomocí Visual Basic IDE vlastní funkci Prvocislo s jedním argumentem, která vrátí hodnotu 0 pokud není argument prvočíslo a hodnotu 1, pokud je prvočíslo."]
[null,null,"10. Využijte cyklus zadaný příkazem For, funkci Sqr pro odmocninu a funkci Mod pro dělení se zbytkem."]
[null,null,"11. Vytvořte vlastní formulář se čtveřicí tlačítek nazvaných Žlutá, Červená, Modrá a Zelená, po jejichž stisknutí se níže vyznačená buňka zbarví příslušnou barvou."]
[]
[null,null,null,"Tato buňka bude obarvena."]

{"sheet":"PAHy","index":1,"n_rows":120,"n_cols":6,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[]
[null,"middle date","fluorene","phenantrene","fluoranthene","pyrene"]
[null,"2003-10-15",434.4,1091.8,297.39999999999998,156.19999999999999]
[null,"2003-11-12",479,1425.8,327.2,158.19999999999999]
[null,"2003-12-10",705.8,2222.1999999999998,635.6,335.4]
[null,"2004-01-07",1069.4000000000001,3792.4,1030.4000000000001,483.6]
[null,"2004-02-04",630.79999999999995,2142,674.2,266]
[null,"2004-03-03",745,2181.8000000000002,639.20000000000005,243.2]
[null,"2004-03-31",246.8,786,266,126.4]
[null,"2004-04-28",126.8,464.4,142.4,72]
[null,"2004-05-26",89.6,269.39999999999998,68,36]
[null,"2004-06-26",55.857140000000001,163.19999999999999,44.928570000000001,21.857140000000001]
[null,"2004-07-27",5.6,55.8,27.2,13]
[null,"2004-08-24",37.4,108.8,32.6,15.8]
[null,"2004-09-21",143.44640000000001,408.58929999999998,130.5,73.432140000000004]
[null,"2004-10-20",442.7679,1328.614,405.4821,205.9]
[null,"2004-12-01",1853.5,5524.357,1273.643,691.42859999999996]
[null,"2005-01-12",898.2,2967,823.2,501.8]
[null,"2005-02-09",688,1893.1,460.8,241.2]
[null,"2005-03-09",569.79999999999995,1817.6,494.6,204.4]
[null,"2005-04-06",216.6,700.4,306.60000000000002,348.6]
[null,"2005-05-04",64.7,193.8,84.8,106.4]
[null,"2005-06-01",140,363.6,103.4,42.6]
[null,"2005-06-29",138.19999999999999,296,60,23.2]
[null,"2005-07-27",94.4,293.2,82.4,52.6]
[null,"2005-08-24",97.4,272.60000000000002,111.6,193.2]
[null,"2005-09-21",58,137.80000000000001,61,38]
[null,"2005-10-19",417.6,1066.8,414.65,275.75]
[null,"2005-11-16",1354.44,3156.52,741.52,506.96]
[null,"2005-12-14",1261.3800000000001,3246.14,1107.68,541.28]
[null,"2006-01-11",1003.46,2293.98,418.36,181.86]
[null,"2006-02-08",1392.1,3389.92,614.41999999999996,241.46]
[null,"2006-03-08",612.78,2507.7399999999998,499.36,148.04]
[null,"2006-04-05",387.66,1367.14,296.56,125.48]
[null,"2006-05-03",125.82,445.32,113.7,50.56]
[null,"2006-05-31",99.02,299.24,77.92,32.96]
[null,"2006-06-28",82.24,221.26,58.48,24.84]
[null,"2006-07-26",84.34,214.3,86.8,138.36000000000001]
[null,"2006-08-23",53.8,148.12,43.16,23.18]
[null,"2006-09-20",75.02,171.46,56.1,29.92]
[null,"2006-10-18",210.02,571.12,164.94,93.08]
[null,"2006-11-15",390.46,1202.3599999999999,335.4,179.3]
[null,"2006-12-13",663.28,1860.88,471.92,258.39999999999998]
[null,"2007-01-10",218.5,880.88,342,169.54]
[null,"2007-02-07",390.56,1066.46,372.42,204.44]
[null,"2007-03-07",256.72000000000003,843.62,272.12,30.8]
[null,"2007-04-04",176.7,501.2,171.88,76.38]
[null,"2007-05-02",102.68,317.36,109.42,51.34]
[null,"2007-05-30",51.4,146.41999999999999,38.1,18.64]
[null,"2007-06-27",33.700000000000003,80.08,1.68,3.74]
[null,"2007-07-26",37.371429999999997,90.385710000000003,29.292860000000001,12.49286]
[null,"2007-08-23",62.520710000000001,157.77359999999999,44.237139999999997,23.520710000000001]
[null,"2007-09-19",122.84,316.76,121.74,51.6]
[null,"2007-10-17",342.74,842.74,262.22000000000003,150.16]
[null,"2007-11-14",441,1279.46,365.48,195.86]
[null,"2007-12-12",849.75,2461.21,671.87,322.11]
[null,"2008-01-24",1239.1866669999999,4255.4586669999999,1081.509333,494.536]
[null,"2008-02-21",826.17230770000003,2899.6153850000001,784.02153850000002,370.91384620000002]
[null,"2008-03-19",355.26,1239.3399999999999,352.12,161.86000000000001]
[null,"2008-04-16",216.18,675.02,201.28,97.66]
[null,"2008-05-14",95.54,317.94,101.84,53.78]
[null,"2008-06-11",42.4,119.78,42.74,28.34]
[null,"2008-07-09",72.84,222.62,56.12,23.6]
[null,"2008-08-06",48.66,138.97999999999999,46.1,20.6]
[null,"2008-09-03",87.6,183.1,52.64,28.6]
[null,"2008-10-01",213.96,632.76,185.58,98.6]
[null,"2008-10-29",264.94,841.78,224.68,108.92]
[null,"2008-11-26",445.9,1351.58,377.06,179.62]
[null,"2008-12-24",1119.28,2743.32,674.6,307.32]
[null,"2009-01-21",1295.32,3065.78,707.46,282.98]
[null,"2009-02-18",534.74,1619.68,442.78,174.32]
[null,"2009-03-18",209.2,672.92,202.78,86.78]
[null,"2009-04-15",55.1,174.22,59.56,26.44]
[null,"2009-05-13",33.86,113.64,38.700000000000003,18.14]
[null,"2009-06-10",22,67.28,17.52,8.98]
[null,"2009-07-08",18.100000000000001,61.18,18.32,9.14]
[null,"2009-08-05",14.46,38.58,12.42,5.98]
[null,"2009-09-02",32.76,73.88,22.9,12.22]
[null,"2009-09-30",892.38,2980.52,941.66,571.79999999999995]
[null,"2009-10-28",460.58,1177.08,322.8,166.56]
[null,"2009-11-25",233.56,813.18,251.38,137.94]
[null,"2009-12-23",701.78,1846.8,446.48,188.56]
[null,"2010-01-20",723.06,1738.92,412.08,147.18]
[null,"2010-02-17",680.8,1673.4,407.86,136.6]
[null,"2010-03-17",263.60000000000002,935.38,308.33999999999997,113.88]
[null,"2010-04-14",114.54,351.1,145.84,68.88]
[null,"2010-05-12",106.82,366.72,131.46,60.66]
[null,"2010-06-09",130.66,390.4,149.66,74.760000000000005]
[null,"2010-07-07",72.98,186.02,76.72,31.64]
[null,"2010-08-04",49.84,143.77000000000001,41.07,20.69]
[null,"2010-09-01",82.84,271.67,93.84,54.88]
[null,"2010-09-29",298.48,737.94,242.38,128.54]
[null,"2010-10-27",154.96,439.28,139.63999999999999,70.959999999999994]
[null,"2010-11-24",655.94,1517.62,358.42,186.5]
[null,"2010-12-22",664.88,1762.74,444.56,193.7]
[null,"2011-01-19",729.64,1852.7,469.72,198.7]
[null,"2011-02-16",759.36,1624.26,392.5,155.88]
[null,"2011-03-16",332.7,966.56,291.5,124.04]
[null,"2011-04-13",174.68,561.17999999999995,152.63999999999999,65.900000000000006]
[null,"2011-05-11",90.36,275.95999999999998,98.66,48.26]
[null,"2011-06-08",153.44,474.48,180.44,84.36]
[null,"2011-07-06",166.52,487.88,208.24,88.16]
[null,"2011-08-03",24.3,69.5,22.08,11.1]
[null,"2011-08-31",43.88,108.08,45.46,24.02]
[null,"2011-09-28",147.12,404.78,130.4,76.040000000000006]
[null,"2011-10-26",619.29999999999995,1704.62,683.82,343.44]
[null,"2011-11-23",827.76,2544.88,803.26,435.34]
[null,"2011-12-21",412.06,1650.82,601.74,318.38]
[null,"2012-01-18",941.72,2271.6,749.66,363.66]
[null,"2012-02-15",1006.72,3190.76,968.4,416.74]
[null,"2012-03-14",272.56,957.26,368.26,184.08]
[null,"2012-04-11",155.52000000000001,540.64,226.58,109.46]
[null,"2012-05-09",49.94,173.58,94.66,39.880000000000003]
[null,"2012-06-06",34.159999999999997,92.12,35.28,12.7]
[null,"2012-07-04",38.06,103.9,38.22,19.2]
[null,"2012-08-01",32.36,78.34,28.94,13.2]
[null,"2012-08-29",53.76,132.04,43.5,25.84]
[null,"2012-09-26",64.88,205.48,73.48,45.1]
[null,"2012-10-24",272,857.42,292.27999999999997,146.46]
[null,"2012-11-21",453.8,1301.5999999999999,445.2,220.62]