{"text_format":"1","workbook":"xlsx","n_sheets":34,"sheets":["Obsah","Tip01","Tip02","Tip03","Led","Uno","Bre","Tip04","Tip05","Tip06","Tip07","Tip08","Tip09","Tip10","Tip11","Tip12","Tip13","Tip14","Tip15","Tip16","Tip17","Tip18","Tip19","Tip20","Tip21","Tip22","Tip23","Tip24","Tip25","Tip26","Tip27","Tip28","Tip29","HiddenTemplate"],"not_rendered":{"charts":12,"images":18,"macros":1,"external_links":3,"defined_names":58,"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":"Obsah","index":0,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Seznam"]
[null,null,"Tip01","Pojmenovávání buňek"]
[null,null,"Tip02","Vytvoření seznamu pro výběr"]
[null,null,"Tip03","3D vzorce"]
[null,null,"Tip04","Default Values"]
[null,null,"Tip05","String to Formula Parser"]
[null,null,"Tip06","Searching"]
[null,null,"Tip07","Goal Seeking"]
[null,null,"Tip08","Zamykání"]
[null,null,"Tip09","Cyklické odkazy"]
[null,null,"Tip10","Small pleasures :-)"]
[null,null,"Tip11","Empty values in charts"]
[null,null,"Tip12","Text in the textbox"]
[null,null,"Tip13","Variable source data for chart"]
[null,null,"Tip14","User function FormulaToText"]
[null,null,"Tip15","Add new sheet"]
[null,null,"Tip16","User function FormulaToText 2"]
[null,null,"Tip17","Table function"]
[null,null,"Tip18","Scrollbar negative value"]
[null,null,"Tip19","Payment of loan"]
[null,null,"Tip20","Magic Charts"]
[null,null,"Tip21","Custom format cells"]
[null,null,"Tip22","User function COUNTIF(…)"]
[null,null,"Tip23","Scenario manager"]
[null,null,"Tip24","Podmíněné formátování"]
[null,null,"Tip25","Funkce POSUN … různě velké oblasti"]
[null,null,"Tip26","SUMIFS chytré sumy"]
[null,null,"Tip27","Paste jako transformace se vzorci"]
[null,null,"Tip28","Nepřímý odkaz"]
[null,null,"Tip29","Porovnání souborů Inquire"]

{"sheet":"Tip01","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["←",null,"Pojmenovávání buňek"]
[]
[]
[null,null,"Pohledávky"]
[null,null,"Dluh Petr",200,"Kč"]
[null,null,"Dluh Jan",300,"Kč"]
[null,null,"Dluh Kateřina",600,"Kč"]
[null,null,"Dluh celkem",{"$f":"DluhPetr+DluhJan+DluhKaterina","v":1100},"Kč","…z názvů buněk"]
[]
[]
[null,null,"Dluh celkem",{"$f":"SUM(DluhCelkemLocal)","v":1100},"Kč","…z názvu oblasti"]
[]
[]
[null,null," - název má přednost před adresou"]
[null,null," - název se definuje vedle řádku vzorců"]
[null,null," - správa názvů na kartě Vzorce\\Správce názvů"]
[null,null," - lze definovat platnost (viditelnost) názvu pro List/Sešit"]
[null,null," - pro Excel 2003 nutno platnost řešit názvem listu jako Tip01!D5"]

{"sheet":"Tip02","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["←",null,"Vytvoření seznamu pro výběr"]
[]
[]
[]
[null,null,null,null,"Index :",6,null,null,null,"---------------------------------------------"]
[null,null,null,null,null,null,null,null,null,"Zastřešení"]
[null,null,null,null,null,null,null,null,null,"Základy"]
[null,null,null,null,null,null,null,null,null,"Svis. nos. kce vnější"]
[null,null,null,null,null,null,null,null,null,"Svis. nos. kce vnitřní"]
[null,null,null,null,null,null,null,null,null,"Vodor. nos. kce"]
[null,null," - z karty Vývojář\\Vložit\\Ovládací prvky formuláře",null,null,null,null,null,null,"Obvodový plášť"]
[null,null," - kartu Vývojář zobrazíte z karty Soubor",null,null,null,null,null,null,"Výplně otvorů OP"]
[null,null,"    příkazem Možnosti\\Přizpůsobit pás karet",null,null,null,null,null,null,"Povrchy podlah"]
[null,null," - pole seznamem (ComboBox)",null,null,null,null,null,null,"Povrchy stěn"]
[null,null," - left click… Formát ovládacího prvku",null,null,null,null,null,null,"Externí prvek (vítr)"]
[null,null," - záložka Ovládací prvek",null,null,null,null,null,null,"Externí prvek (sníh)"]
[null,null," - Vstupní oblast",null,null,null,null,null,null,"Externí prvek (déšť)"]
[null,null," - Propojení s buňkou",null,null,null,null,null,null,"Interní prvky (uživatelské vlivy)"]
[null,null," - Počet řádků seznamu"]

{"sheet":"Tip03","index":3,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["←",null,"3D vzorce"]
[]
[]
[null,null,"Pohledávky","Celkem",null,"Min.",null,"Max.",null,"Průměr"]
[null,null,"Dluh Petr",{"$f":"SUM(Dluh_Petr_Rok)","v":480},"Kč",{"$f":"MIN(Dluh_Petr_Rok)","v":120},"Kč",{"$f":"MAX(Dluh_Petr_Rok)","v":200},"Kč",{"$f":"AVERAGE(Dluh_Petr_Rok)","v":160},"Kč"]
[null,null,"Dluh Jan",{"$f":"SUM(Dluh_Jan_Rok)","v":970},"Kč",{"$f":"MIN(Dluh_Jan_Rok)","v":220},"Kč",{"$f":"MAX(Dluh_Jan_Rok)","v":450},"Kč",{"$f":"AVERAGE(Dluh_Jan_Rok)","v":323.33333333333331},"Kč"]
[null,null,"Dluh Kateřina",{"$f":"SUM(Dluh_Kateřina_Rok)","v":1930},"Kč",{"$f":"MIN(Dluh_Kateřina_Rok)","v":530},"Kč",{"$f":"MAX(Dluh_Kateřina_Rok)","v":800},"Kč",{"$f":"AVERAGE(Dluh_Kateřina_Rok)","v":643.33333333333337},"Kč"]
[null,null,"Dluh celkem",{"$f":"SUM(D5:D7)","v":3380},"Kč"]
[]
[]
[null,null," - definovaný 3D název"]
[null,null," - Dluh_Petr_Rok  definovaný jako =Led:Bre!D5"]
[null,null," - název lze použít do 3D vzorců"]
[null,null," - tyto vzorce lze použít :"]
[null,null,"SUMA, PRŮMĚR, AVERAGEA, POČET,"]
[null,null,"POČETA, MIN, MINA, MAX, MAXA, SOUČIN, SMODCH.VÝBĚR, STDEVA, SMODCH,"]
[null,null,"STDEVPA, VAR.VÝBĚR, VARA, VAR a VARPA"]

{"sheet":"Led","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["←",null,"Leden - pohledávky"]
[]
[]
[null,null,"Pohledávky"]
[null,null,"Dluh Petr",200,"Kč"]
[null,null,"Dluh Jan",300,"Kč"]
[null,null,"Dluh Kateřina",600,"Kč"]
[null,null,"Dluh celkem",{"$f":"SUM(D5:D7)","v":1100},"Kč"]

{"sheet":"Uno","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["←",null,"Únor - pohledávky"]
[]
[]
[null,null,"Pohledávky"]
[null,null,"Dluh Petr",160,"Kč"]
[null,null,"Dluh Jan",220,"Kč"]
[null,null,"Dluh Kateřina",530,"Kč"]
[null,null,"Dluh celkem",{"$f":"SUM(D5:D7)","v":910},"Kč"]

{"sheet":"Bre","index":6,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["←",null,"Březen - pohledávky"]
[]
[]
[null,null,"Pohledávky"]
[null,null,"Dluh Petr",120,"Kč"]
[null,null,"Dluh Jan",450,"Kč"]
[null,null,"Dluh Kateřina",800,"Kč"]
[null,null,"Dluh celkem",{"$f":"SUM(D5:D7)","v":1370},"Kč"]

{"sheet":"Tip04","index":7,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["←",null,"Default Values"]
[]
[]
[null,null,"Vstupy výpočtu:"]
[null,null,"Cyklus údržby :",null,2,"let"]
[null,null,"Cyklus obnovy :",null,12,"let"]
[null,null,"Náklady na údržbu :",null,0.03]
[null,null,"Náklady na obnovu :",null,0.25]
[]
[]
[null,null," - při ladění výpočtu dojde ke změně původních hodnot"]
[null,null," - původní hodnoty jsou zapsané do procedury"]
[null,null," - nemůže dojít k jejich přepsání"]

{"sheet":"Tip05","index":8,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["←",null,"String to Formula Parser"]
[]
[]
[]
[]
[null,null,null,"8*9+6=",null,null,{"$f":"8*9+6","v":78}]
[null,null,null,"3*4+12=",null,null,{"$f":"3*4+12","v":24}]
[null,null,null,"6-5+7=",null,null,{"$f":"6-5+7","v":8}]

{"sheet":"Tip06","index":9,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["←",null,"Searching"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"E9","v":"Sk. 1"}]
[null,null,null,null,{"$f":"F9","v":"Sk. 2"}]
[null,null,null,null,{"$f":"G9","v":"Sk. 3"}]
[null,null,null,"Hodnoceni","Sk. 1","Sk. 2","Sk. 3"]
[null,null,1,"Nejhorsi","Calda","Domkář","Novy"]
[null,null,2,"Horsi","Duben","Enická","Pospisil"]
[null,null,3,"Podprumerny","Mráz","Gebrt","Smolova"]
[null,null,4,"Prumerny","Rejmon","Kozina","Vild"]
[null,null,5,"Nadprumerny","Svoboda","Kroupa","Vlcek"]
[null,null,6,"Lepsi","Šilar","Lemberková","Janecek"]
[null,null,7,"Nejlepsi","Švejková","Mandelíček","Mrazek"]
[]
[null,null,"Hodnoceni :",null,null,"Skupina :"]
[null,null,null,4,null,null,2]
[null,null,"Hledat 1. sk.",{"$f":"VLOOKUP($D$19,$C$9:$G$16,3)","v":"Rejmon"}]
[null,null,"Hledat 2. sk.",{"$f":"VLOOKUP($D$19,$C$9:$G$16,4)","v":"Kozina"}]
[null,null,"Hledat 3. sk.",{"$f":"VLOOKUP($D$19,$C$9:$G$16,5)","v":"Vild"},null,"Hledat :",{"$f":"VLOOKUP($D$19,$C$9:$G$16,G19+2)","v":"Kozina"}]
[]
[]
[null,null,null,null,null,"Hodnoceni :",{"$f":"VLOOKUP(D19,C10:D16,2)","v":"Prumerny"},"…pomoci =SVYHLEDAT(…;…;…)"]
[null,null,null,null,null,"Hodnoceni :",{"$f":"INDEX(D10:D16,D19)","v":"Prumerny"},"...pomoci =INDEX(…;…)"]
[]
[null,null,null,null,null,"Hodnoc/Sk :",{"$f":"INDEX(E10:G16,D19,G19)","v":"Kozina"},"...pomoci =INDEX(…;…;...)"]
[null,null,null,null,null,"Radek :",{"$f":"D19","v":4}]
[null,null,null,null,null,"Sloupec :",{"$f":"G19","v":2}]

{"sheet":"Tip07","index":10,"n_rows":263,"n_cols":53,"rows_kept":263,"cut":false,"hidden":false,"merged":[]}
["←",null,"Goal Seeking"]
[]
[null,null,"Dostupné z:"]
[null,null,"Karta: Data"]
[null,null,"Záložka: Citlivostní analýza"]
[null,null,"Příkaz: Hledání řešení"]
[]
[]
[]
[]
[null,null,"Životnost",10]
[null,null,"Náklady",2000000]
[null,null,"Tempo",{"$f":"E13/1000","v":0.5},500]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[null,null,{"$f":"D12","v":2000000},{"$f":"$D$12*$D$13^(D15/$D$11)","v":1866065.9830736148},{"$f":"$D$12*$D$13^(E15/$D$11)","v":1741101.1265922482},1624504.792712471,1515716.5665103982,1414213.5623730952,1319507.9107728943,1231144.4133449164,1148698.3549970351,1071773.4625362931,1000000,933032.99153680739,870550.56329612411,812252.39635623549,757858.28325519909,707106.7811865476,659753.95538644725,615572.20667245821,574349.17749851756,535886.73126814654,500000,466516.49576840369,435275.28164806205,406126.19817811786,378929.14162759949,353553.3905932738,329876.97769322357,307786.10333622911,287174.58874925884,267943.36563407333,250000,233258.24788420188,217637.64082403106,203063.09908905893,189464.57081379977,176776.6952966369,164938.48884661181,153893.05166811455,143587.29437462939,133971.68281703666,125000,116629.12394210098,108818.82041201553,101531.54954452945,94732.285406899886,88388.34764831845,82469.244423305936,76946.525834057276,71793.647187314695,66985.841408518318,62500]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"…slouží pro dohledání číselné hodnoty pro vytvořenou závislost"]
[null,null,"…odkaz na hledanou nesmí bý vzorec"]
[null,null,"…je třeba definovat funkční závislost"]
[null,null,"…pro hledání se nastavuje cílová hodnota sledované funkce"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,230]

{"sheet":"Tip08","index":11,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["←",null,"Zamykání"]
[]
[null,null,"Dostupné z…"]
[null,null,"Karta",null,"Příkaz"]
[]
[null,null,"Revize",null,"Zamknout sešit"]
[null,null,null,null,"…nejde skrýt listy (Struktura)"]
[null,null,null,null,"…nejde přejmenovat (Struktura)"]
[null,null,null,null,"…nejde měnit velikost (Okna)"]
[null,null,null,null,"…nejde měnit polohu (Okna)"]
[]
[]
[]
[null,null,"Revize",null,"Zamknout list"]
[null,null,"Domů",null,"Formát\\Zamknout list"]
[null,null,null,null,"…zákaz editace buněk"]
[null,null,null,null,"…povolení odemčených buněk"]
[]
[null,null,"Uzamčený list"]
[null,null,"Odemčená buňka",null,123]
[null,null,"Domů\\Formát\\Uzamknout buňku"]
[null,null,"Heslo zamknutí listu",null,"aaa"]
[null,null,"Nejsou vidět vzorce",null,{"$f":"1+1","v":2}]
[null,null,"Formát buňky\\Zámek\\Skrýt vzorce"]
[null,null,"Odemčená buňka",null,123]
[null,null,"TAB skáče mezi odemk. buňkami"]

{"sheet":"Tip09","index":12,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["←",null,"Cyklické odkazy"]
[]
[null,null,null,null,null,null,{"$f":"I3+H6","v":0}]
[]
[null,null,null,{"$f":"F6+G3+H6","v":0}]
[null,null,null,null,null,0,null,{"$f":"J7+G9","v":0}]
[]
[]
[null,null,"Dostupné z…"]
[null,null,"Karta",null,"Příkaz"]
[]
[null,null,"Vzorce",null,"Kontrola chyb\\Cyklické odkazy"]
[null,null,"Vzorce",null,"Předchůdci"]
[null,null,null,null,"Následníci"]
[null,null,null,null,"Odebrat šipky"]
[null,null,null,null,"Vyhodnocení vzorce"]
[null,null,"Soubor",null,"Možnosti\\Vzorce\\Povolit iterativní výpočet"]
[null,null,"…přepočítá všechny buňky kromě cyklických"]
[null,null,"…info ve StatusBar: \"Přepočet\""]
[null,null,"…info ve StatusBar"]

{"sheet":"Tip10","index":13,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["←",null,"Small pleasures"]
[]
[]
[null,"1.","Zadávání zvláštních znaků"]
[null,null,"Hodnota (100) převedena na -100"]
[null,null,null,"(100)",-100]
[]
[null,"2.","Číselný záznam ukončený % je převeden na procenta"]
[null,null,null,0.65,"formát buňky procenta"]
[]
[null,"3.","Použití lomítka (/) pro formát zlomek "]
[null,null,null,3.75,"zobrazí v řádku vzorců hodnotu 3,75"]
[null,null,null,null,"formát buňky zlomky"]
[]
[null,"4.","Zadání zlomku, aby Excel nepřevedl na datum"]
[null,null,null,"2011-03-02","zadaná hodnota byla 2/3"]
[null,null,null,0.66666666666666663,"zadaná hodnota byla 0 2/3"]
[]
[null,"5.","Divné počty"]
[null,null,null,null,2.38,null,"zadáno 2,38"]
[null,null,null,null,3.68,null,"zadáno 3,68"]
[null,null,null,"Suma",{"$f":"E20+E21","v":6.0600000000000005}]
[null,null,null,"Pozor na rozdíl mezi zobrazovanými a zadanými hodnotami"]
[]
[null,"6.","Přesnosti zadání"]
[null,null,null,null,0.123456789012345,"zadáno bylo 0,1234567890123456789"]
[null,null,null,null,"Hodnoty za 15. desetinným místem jsou ignorovány"]
[]
[null,null,null,null,1.2345678901234501E+18,"zadáno bylo 1234567890123456789"]
[null,null,null,null,"Hodnoty za 15. číslicí jsou převedeny na nulu"]
[]
[null,"7.","Zadání textu"]
[null,null,null,"12345","Zadáno do buňky '12345"]
[null,null,null,{"$f":"\"12345\"","v":"12345"},"Zadáno do buňky =\"12345\""]
[null,null,null,"Excel 2003","Nástroje/Možnosti… Převod/Převod navigačních kláves"]
[null,null,null,"Excel2007","Možnosti/Upřesnit … Kompatibilita s Lotus/Převod navigačních kláves"]
[null,null,null,"ABC ","Zadáno do buňky ^ABC … zarovnáno na střed"]
[null,null,null,"ABC","Zadáno do buňky \"ABC … zarovnáno vpravo"]
[null,null,null,"ABC","Zadáno do buňky \\ABC … opakuje znaky v celé buňce"]
[]
[null,"8.","Zadání stejné hodnoty do oblasti"]
[null,null,null,"1. vybrat oblast"]
[null,null,null,"2. zadat hodnotu"]
[null,null,null,"3. stisknout CTRL+ENTER"]
[null,null,null,"…hodnota se zadá do celé oblasti"]
[]
[null,"9.","Zadávání relativních a absolutních odkazů"]
[null,null,null,"=$B6","Stiskem F4 se přepíná záznam odkazů"]
[null,null,null,"B6","relativní odkaz"]
[null,null,null,"B$6"]
[null,null,null,"$B$6","absolutní odkaz"]
[]
[null,"10.","String Magic",null,"řetězení … nejen čísla jdou sčítat"]
[null,null,null,"AB&CD=ABCD",{"$f":"\"AB\"&\"CD\"","v":"ABCD"}]
[]
[null,null,"Malina","Luboš",{"$f":"D56 &\" \" &C56","v":"Luboš Malina"}]
[null,null,"Křesťan","Robert",{"$f":"D57 &\" \" &C57","v":"Robert Křesťan"}]
[null,null,"McCoy","Charlie",{"$f":"D58 &\" \" &C58","v":"Charlie McCoy"}]

{"sheet":"Tip11","index":14,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["←",null,"Empty values in charts"]
[]
[null,null,"Roky","Výroba aut [tis.]"]
[null,null,2013,30]
[null,null,2014,30]
[null,null,2015,40]
[null,null,2016]
[null,null,2017,40]
[null,null,2018,50]
[null,null,2019]
[null,null,2020]
[null,null,2021,40]
[null,null,2022,30]
[null,null,2023,30]
[null,null,2024]
[null,null,2025,40]
[null,null,2026,30]
[null,null,2027,30]

{"sheet":"Tip12","index":15,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["←",null,"Text in the textbox"]
[]
[null,null,"Minimum",{"$f":"RAND()","v":0.14509059140367608}]
[null,null,"Maximum",{"$f":"D3+RAND()","v":1.0950714986782148}]
[]
[{"$f":"\"Minimální hodnota \" & D3 & \" a maximální hodnota \" & D4","v":"Minimální hodnota 0,145090591403676 a maximální hodnota 1,09507149867821"}]
[]
[{"$f":"\"Minimální hodnota \" & TEXT(D3,\"0,000\") & \" a maximální hodnota \" & TEXT(D4,\"0,000\")","v":"Minimální hodnota 0,145 a maximální hodnota 1,095"}]

{"sheet":"Tip13","index":16,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["←",null,"Variable source data for chart"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Počet hodnot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[]
[]
[]
[]
[]
[null,"Počet roků k zobrazení"]
[null,null,8]
[]
[null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,30,{"$f":"B25-$B$25/$C$22","v":26.25},22.5,18.75,15,11.25,7.5,3.75,0,-3.75,-7.5,-11.25]
[]
[null,"Definované názvy napojené, z kterých se vybírají data pro graf"]
[null,"DataRoky"," =POSUN('Tip13'!$B$24;0;0;1;'Tip13'!$C$22)"]
[null,"DataGraf"," =POSUN('Tip13'!$B$25;0;0;1;'Tip13'!$C$22)"]
[]
[null,"Funkce =POSUN(…;…;…;…;…) viz Help"]

{"sheet":"Tip14","index":17,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["←",null,"Formula to text User function"]
[]
[]
[null,null,"Rand 1",{"$f":"RAND()","v":0.4614984837781464}]
[null,null,"Rand 2",{"$f":"RAND()","v":0.15050269745943845}]
[]
[]
[null,null,"Formula",{"$f":"2*D4+D5/4","v":0.96062264192115243}]
[]
[]
[null,null,"To string",{"$f":"FormulaToString(D8)","v":{"$error":"#NAME?"}}]
[]
[]
[null,null,"User function: =FormulaToString(D8)"]
[]
[null,null,"User function zapsaná do modulu VBA"]

{"sheet":"Tip15","index":18,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["←",null,"Add new sheet"]
[]
[]
[null,null,"New name of the sheet:","New1"]

{"sheet":"Tip16","index":19,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["←",null,"Formula to text modif User function"]
[]
[]
[null,null,"Rand 1",45,"m2"]
[null,null,"Rand 2",50,"m2"]
[]
[]
[null,null,"Formula",{"$f":"2*D4+D5/4+3*4*4+D4","v":195.5},"m2"]
[]
[]
[null,null,"To string",{"$f":"FormulaToTextModif(D8)","v":{"$error":"#NAME?"}}]
[]
[]
[null,null,"User function: =FormulaToTextModif(D8)"]
[]
[null,null,"User function zapsaná do modulu VBA"]

{"sheet":"Tip17","index":20,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[10,5,10,7]]}
["←",null,"Table function"]
[]
[]
[]
[]
[null,null,"Použití funkce TABELOVAT(…)"]
[]
[null,null,null,"Výnos:",100000]
[null,null,null,"Znehodnocení:",0.01]
[null,null,null,"Limit:",3500]
[null,null,null,null,null,"Znehodnocení"]
[null,null,null,null,{"$f":"E8*E9","v":1000},0,{"$f":"F12+0.01","v":0.01},0.02,0.03,0.04,0.05,6.0000000000000005E-2]
[null,null,null,null,50000,0,500,1000,1500,2000,2500,3000.0000000000005]
[null,null,null,null,{"$f":"E13+10000","v":60000},0,600,1200,1800,2400,3000,3600.0000000000005]
[null,null,null,null,{"$f":"E14+10000","v":70000},0,700,1400,2100,2800,3500,4200]
[null,null,null,null,80000,0,800,1600,2400,3200,4000,4800]
[null,null,null,null,90000,0,900,1800,2700,3600,4500,5400]
[null,null,null,null,100000,0,1000,2000,3000,4000,5000,6000.0000000000009]
[null,null,null,null,110000,0,1100,2200,3300,4400,5500,6600.0000000000009]
[null,null,null,null,120000,0,1200,2400,3600,4800,6000,7200.0000000000009]
[null,null,null,null,130000,0,1300,2600,3900,5200,6500,7800.0000000000009]
[null,null,null,null,140000,0,1400,2800,4200,5600,7000,8400]
[null,null,null,null,150000,0,1500,3000,4500,6000,7500,9000]
[null,null,null,null,160000,0,1600,3200,4800,6400,8000,9600]

{"sheet":"Tip18","index":21,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["←",null,"Scrollbar control"]
[]
[]
[]
[]
[null,null,"Přepočet propojené buňky"]
[]
[null,null,"Min.",0]
[null,null,"Max.",200]
[]
[null,null,"Výsledek propojené buňky:",null,null,70]
[null,null,"Desetinné číslo:",null,null,{"$f":"F11/D9","v":0.35}]
[null,null,"Celé číslo:",null,null,{"$f":"F11","v":70}]
[null,null,"Záporné číslo:",null,null,{"$f":"-D9/2+F11","v":-30}]
[null,null,"Záporné desetinné číslo:",null,null,{"$f":"-0.5+F11/D9","v":-0.15000000000000002}]

{"sheet":"Tip19","index":22,"n_rows":205,"n_cols":38,"rows_kept":205,"cut":false,"hidden":false,"merged":[[5,20,24,20],[3,23,3,36]]}
["←",null,"Payment of loan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barevně označené varianty splátek/velikostí půjček jsou nedostupné"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximální splátka"]
[null,null,null,null,"Č. splátky","Jistina na zač.","Úrok","Splátka","Úmor","Jistina na kon.",null,null,"Splaceno","Půjčka",null,null,null,null,null,null,null,null,10000,"Velikosti půjček"]
["Půjčka",1000000,"Kč",null,0,{"$f":"B5","v":1000000},0,0,0,{"$f":"F5","v":1000000},null,null,{"$f":"H5","v":0},{"$f":"$B$5","v":1000000},null,null,null,null,null,null,null,{"$f":"B10","v":6263.7470386394025},3000000,{"$f":"W5-200000","v":2800000},{"$f":"X5-200000","v":2600000},2400000,2200000,2000000,1800000,1600000,1400000,1200000,1000000,800000,600000,400000,200000,0]
["Počet splátek",204,"-",null,{"$f":"E5+1","v":1},{"$f":"J5","v":1000000},{"$f":"F6*$B$8","v":2500},{"$f":"$B$10","v":6263.7470386394025},{"$f":"H6-G6","v":3763.7470386394025},{"$f":"F6-I6","v":996236.25296136062},null,null,{"$f":"M5+H6","v":6263.7470386394025},{"$f":"$B$5","v":1000000},null,null,null,null,null,null,"Doby splácení",240,16637.927935617361,15528.732739909537,14419.537544201712,13310.34234849389,12201.147152786065,11091.951957078241,9982.7567613704159,8873.5615656625923,7764.3663699547687,6655.1711742469452,5545.9759785391207,4436.7807828312962,3327.5855871234726,2218.3903914156481,1109.195195707824,0]
["Úrok za rok",0.03,"p. a.",null,{"$f":"E6+1","v":2},{"$f":"J6","v":996236.25296136062},{"$f":"F7*$B$8","v":2490.5906324034017},6263.7470386394025,{"$f":"H7-G7","v":3773.1564062360007},{"$f":"F7-I7","v":992463.09655512462},null,null,12527.494077278805,1000000,null,null,null,null,null,null,null,{"$f":"V6-12","v":228},17278.233519208876,16126.35128459495,14974.469049981028,13822.586815367102,12670.704580753176,11518.82234613925,10366.940111525326,9215.0578769114018,8063.175642297475,6911.2934076835509,5759.411173069625,4607.5289384557009,3455.6467038417754,2303.7644692278504,1151.8822346139252,0]
["Úrok za měsíc",{"$f":"B7/12","v":2.5000000000000001E-3},"p. m.",null,3,992463.09655512462,2481.1577413878117,6263.7470386394025,3782.5892972515908,988680.50725787308,null,null,18791.241115918208,1000000,null,null,null,null,null,null,null,{"$f":"V7-12","v":216},17991.698720531836,16792.252139163047,15592.805557794258,14393.358976425468,13193.912395056679,11994.465813687892,10795.019232319102,9595.5726509503129,8396.1260695815236,7196.6794882127342,5997.2329068439458,4797.7863254751564,3598.3397441063671,2398.8931627375782,1199.4465813687891,0]
[null,null,null,null,4,988680.50725787308,2471.7012681446827,6263.7470386394025,3792.0457704947198,984888.46148737834,null,null,25054.98815455761,1000000,null,null,null,null,null,null,null,204,18791.241115918205,17538.491708190326,16285.742300462443,15032.992892734565,13780.243485006684,12527.494077278805,11274.744669550922,10021.995261823044,8769.2458540951629,7516.4964463672823,6263.7470386394025,5010.9976309115218,3758.2482231836411,2505.4988154557609,1252.7494077278805,0]
["Splátka",{"$f":"-PMT(B8,B6,B5)","v":6263.7470386394025},"Kč",null,5,984888.46148737834,2462.2211537184457,6263.7470386394025,3801.5258849209567,981086.93560245738,null,null,31318.735193197012,1000000,null,null,null,null,null,null,null,192,19693.007297733882,18380.140144551624,17067.272991369366,15754.405838187104,14441.538685004847,13128.671531822589,11815.804378640329,10502.93722545807,9190.070072275812,7877.2029190935518,6564.3357659112944,5251.4686127290352,3938.6014595467759,2625.7343063645176,1312.8671531822588,0]
[null,null,null,null,6,981086.93560245738,2452.7173390061434,6263.7470386394025,3811.029699633259,977275.90590282413,null,null,37582.482231836417,1000000,null,null,null,null,null,null,null,180,20717.449208339702,19336.285927783723,17955.122647227741,16573.959366671763,15192.796086115781,13811.632805559801,12430.46952500382,11049.306244447842,9668.1429638918617,8286.9796833358814,6905.8164027799003,5524.6531222239209,4143.4898416679407,2762.3265611119605,1381.1632805559802,0]
[null,null,null,null,7,977275.90590282413,2443.1897647570604,6263.7470386394025,3820.5572738823421,973455.34862894181,null,null,43846.229270475822,1000000,null,null,null,null,null,null,null,168,21890.861760290518,20431.470976271146,18972.080192251782,17512.689408232411,16053.298624213045,14593.907840193679,13134.517056174309,11675.126272154941,10215.735488135573,8756.3447041162053,7296.9539200968393,5837.5631360774705,4378.1723520581027,2918.7815680387353,1459.3907840193676,0]
[null,null,null,null,8,973455.34862894181,2433.6383715723546,6263.7470386394025,3830.1086670670479,969625.23996187479,null,null,50109.976309115227,1000000,null,null,null,null,null,null,null,156,23247.630127675842,21697.788119164117,20147.946110652396,18598.104102140671,17048.26209362895,15498.420085117226,13948.578076605503,12398.736068093782,10848.894059582059,9299.0520510703354,7749.2100425586132,6199.3680340468909,4649.5260255351677,3099.6840170234454,1549.8420085117227,0]
[null,null,null,null,9,969625.23996187479,2424.0630999046871,6263.7470386394025,3839.6839387347154,965785.55602314009,null,null,56373.723347754632,1000000,null,null,null,null,null,null,null,144,24833.600683441186,23178.027304545107,21522.453925649024,19866.880546752949,18211.307167856867,16555.733788960792,14900.160410064711,13244.58703116863,11589.013652272553,9933.4402733764746,8277.8668944803958,6622.2935155843152,4966.7201366882373,3311.1467577921576,1655.5733788960788,0]
[null,null,null,null,10,965785.55602314009,2414.4638900578502,6263.7470386394025,3849.2831485815523,961936.27287455858,null,null,62637.470386394038,1000000,null,null,null,null,null,null,null,132,26711.290630139014,24930.537921463081,23149.785212787148,21369.032504111212,19588.279795435275,17807.527086759343,16026.77437808341,14246.021669407475,12465.268960731541,10684.516252055606,8903.7635433796713,7123.0108347037376,5342.258126027803,3561.5054173518688,1780.7527086759344,0]
[null,null,null,null,11,961936.27287455858,2404.8406821863964,6263.7470386394025,3858.9063564530061,958077.36651810561,null,null,68901.217425033436,1000000,null,null,null,null,null,null,null,120,28968.223409516857,27037.008515549067,25105.793621581277,23174.578727613487,21243.363833645693,19312.148939677907,17380.934045710113,15449.719151742323,13518.504257774533,11587.289363806743,9656.0744698389535,7724.8595758711617,5793.6446819033717,3862.4297879355809,1931.2148939677904,0]
[null,null,null,null,12,958077.36651810561,2395.1934162952639,6263.7470386394025,3868.5536223441386,954208.81289576145,null,null,75164.964463672834,1000000,null,null,null,null,null,null,null,108,31730.821052267518,29615.432982116352,27500.044911965182,25384.656841814016,23269.268771662846,21153.88070151168,19038.49263136051,16923.104561209344,14807.716491058176,12692.328420907008,10576.94035075584,8461.552280604672,6346.164210453504,4230.776140302336,2115.388070151168,0]
[null,null,null,null,13,954208.81289576145,2385.5220322394039,6263.7470386394025,3878.2250063999986,950330.58788936143,null,null,81428.711502312231,1000000,null,null,null,null,null,null,null,96,35188.715790590722,32842.801404551341,30496.887018511956,28150.972632472578,25805.058246433196,23459.143860393815,21113.229474354433,18767.315088315052,16421.40070227567,14075.486316236289,11729.571930196907,9383.657544157526,7037.7431581181445,4691.828772078763,2345.9143860393815,0]
[null,null,null,null,14,950330.58788936143,2375.8264697234035,6263.7470386394025,3887.920568915999,946442.66732044541,null,null,87692.458540951629,1000000,null,null,null,null,null,null,null,84,39639.900196385322,36997.240183292968,34354.580170200614,31711.920157108256,29069.260144015905,26426.600130923551,23783.940117831193,21141.280104738838,18498.620091646484,15855.960078554128,13213.300065461775,10570.640052369419,7927.980039277064,5285.3200261847096,2642.6600130923548,0]
[null,null,null,null,15,946442.66732044541,2366.1066683011136,6263.7470386394025,3897.6403703382889,942545.02695010707,null,null,93956.205579591027,1000000,null,null,null,null,null,null,null,72,45581.027458316217,42542.292294428473,39503.557130540728,36464.821966652977,33426.086802765232,30387.351638877481,27348.616474989733,24309.881311101984,21271.146147214236,18232.410983326488,15193.67581943874,12154.940655550992,9116.2054916632442,6077.4703277754961,3038.7351638877481,0]
[null,null,null,null,16,942545.02695010707,2356.3625673752676,6263.7470386394025,3907.3844712641348,938637.64247884299,null,null,100219.95261823043,1000000,null,null,null,null,null,null,null,60,53906.07199218942,50312.333859376784,46718.595726564163,43124.857593751534,39531.119460938906,35937.381328126277,32343.643195313649,28749.90506250102,25156.166929688392,21562.428796875767,17968.690664063139,14374.95253125051,10781.214398437884,7187.4762656252551,3593.7381328126276,0]
[null,null,null,null,17,938637.64247884299,2346.5941061971075,6263.7470386394025,3917.152932442295,934720.48954640073,null,null,106483.69965686982,1000000,null,null,null,null,null,null,null,48,66402.980967934534,61976.115570072237,57549.250172209933,53122.384774347629,48695.519376485332,44268.653978623021,39841.788580760724,35414.923182898419,30988.057785036119,26561.192387173814,22134.32698931151,17707.46159144921,13280.596193586907,8853.7307957246048,4426.8653978623024,0]
[null,null,null,null,18,934720.48954640073,2336.8012238660017,6263.7470386394025,3926.9458147734008,930793.54373162729,null,null,112747.44669550922,1000000,null,null,null,null,null,null,null,36,87243.628891956992,81427.386965826532,75611.145039696057,69794.903113565597,63978.661187435129,58162.419261304662,52346.177335174194,46529.935409043734,40713.693482913266,34897.451556782798,29081.209630652331,23264.967704521867,17448.725778391399,11632.483852260933,5816.2419261304667,0]
[null,null,null,null,19,930793.54373162729,2326.9838593290683,6263.7470386394025,3936.7631793103342,926856.78055231692,null,null,119011.19373414862,1000000,null,null,null,null,null,null,null,24,128943.6359386683,120347.3935427571,111751.15114684588,103154.90875093466,94558.666355023423,85962.423959112202,77366.181563200997,68769.939167289762,60173.696771378549,51577.454375467329,42981.211979556101,34384.969583644881,25788.727187733664,17192.48479182244,8596.2423959112202,0]
[null,null,null,null,20,926856.78055231692,2317.1419513807923,6263.7470386394025,3946.6050872586102,922910.1754650583,null,null,125274.94077278802,1000000,null,null,null,null,null,null,null,12,254081.09627546684,237142.35652376901,220203.61677207123,203264.87702037347,186326.13726867569,169387.39751697786,152448.65776528008,135509.9180135823,118571.1782618845,101632.43851018674,84693.698758488928,67754.959006791149,50816.219255093369,33877.479503395574,16938.739751697787,0]
[null,null,null,null,21,{"$f":"J25","v":922910.1754650583},2307.2754386626457,6263.7470386394025,{"$f":"H26-G26","v":3956.4715999767568},{"$f":"F26-I26","v":918953.70386508154},null,null,131538.68781142743,1000000]
[null,null,null,null,{"$f":"E26+1","v":22},{"$f":"J26","v":918953.70386508154},2297.3842596627037,6263.7470386394025,{"$f":"H27-G27","v":3966.3627789766988},{"$f":"F27-I27","v":914987.34108610486},null,null,137802.43485006684,1000000]
[null,null,null,null,23,914987.34108610486,2287.4683527152624,6263.7470386394025,3976.2786859241401,911011.06240018073,null,null,144066.18188870625,1000000]
[null,null,null,null,24,911011.06240018073,2277.5276560004518,6263.7470386394025,3986.2193826389507,907024.8430175418,null,null,150329.92892734567,1000000]
[null,null,null,null,25,907024.8430175418,2267.5621075438544,6263.7470386394025,3996.1849310955481,903028.65808644623,null,null,156593.67596598508,1000000]
[null,null,null,null,26,903028.65808644623,2257.5716452161155,6263.7470386394025,4006.175393423287,899022.48269302293,null,null,162857.42300462449,1000000]
[null,null,null,null,27,899022.48269302293,2247.5562067325573,6263.7470386394025,4016.1908319068452,895006.29186111607,null,null,169121.1700432639,1000000]
[null,null,null,null,28,895006.29186111607,2237.51572965279,6263.7470386394025,4026.2313089866125,890980.06055212941,null,null,175384.91708190332,1000000]
[null,null,null,null,29,890980.06055212941,2227.4501513803234,6263.7470386394025,4036.2968872590791,886943.76366487029,null,null,181648.66412054273,1000000]
[null,null,null,null,30,886943.76366487029,2217.3594091621758,6263.7470386394025,4046.3876294772267,882897.3760353931,null,null,187912.41115918214,1000000]
[null,null,null,null,31,882897.3760353931,2207.2434400884827,6263.7470386394025,4056.5035985509198,878840.87243684218,null,null,194176.15819782155,1000000]
[null,null,null,null,32,878840.87243684218,2197.1021810921056,6263.7470386394025,4066.6448575472969,874774.22757929494,null,null,200439.90523646097,1000000]
[null,null,null,null,33,874774.22757929494,2186.9355689482372,6263.7470386394025,4076.8114696911653,870697.41610960383,null,null,{"$f":"M37+H38","v":206703.65227510038},1000000]
[null,null,null,null,34,870697.41610960383,2176.7435402740098,6263.7470386394025,4087.0034983653927,866610.41261123843,null,null,212967.39931373979,1000000]
[null,null,null,null,35,866610.41261123843,2166.5260315280962,6263.7470386394025,4097.2210071113059,862513.19160412718,null,null,219231.1463523792,1000000]
[null,null,null,null,36,862513.19160412718,2156.2829790103178,6263.7470386394025,4107.4640596290847,858405.72754449805,null,null,225494.89339101862,1000000]
[null,null,null,null,37,858405.72754449805,2146.0143188612451,6263.7470386394025,4117.7327197781578,854287.99482471985,null,null,231758.64042965803,1000000]
[null,null,null,null,38,854287.99482471985,2135.7199870617997,6263.7470386394025,4128.0270515776028,850159.96777314227,null,null,238022.38746829744,1000000]
[null,null,null,null,39,850159.96777314227,2125.3999194328558,6263.7470386394025,4138.3471192065463,846021.62065393571,null,null,244286.13450693685,1000000]
[null,null,null,null,40,846021.62065393571,2115.0540516348392,6263.7470386394025,4148.6929870045633,841872.92766693118,null,null,250549.88154557627,1000000]
[null,null,null,null,41,841872.92766693118,2104.6823191673279,6263.7470386394025,4159.064719472075,837713.8629474591,null,null,256813.62858421568,1000000]
[null,null,null,null,42,837713.8629474591,2094.2846573686479,6263.7470386394025,4169.4623812707541,833544.40056618839,null,null,263077.37562285509,1000000]
[null,null,null,null,43,833544.40056618839,2083.861001415471,6263.7470386394025,4179.8860372239315,829364.51452896441,null,null,269341.12266149448,1000000]
[null,null,null,null,44,829364.51452896441,2073.4112863224109,6263.7470386394025,4190.3357523169916,825174.17877664743,null,null,275604.86970013386,1000000]
[null,null,null,null,45,825174.17877664743,2062.9354469416185,6263.7470386394025,4200.811591697784,820973.36718494969,null,null,281868.61673877324,1000000]
[null,null,null,null,46,820973.36718494969,2052.4334179623743,6263.7470386394025,4211.3136206770287,816762.0535642727,null,null,288132.36377741263,1000000]
[null,null,null,null,47,816762.0535642727,2041.9051339106818,6263.7470386394025,4221.8419047287207,812540.21165954403,null,null,294396.11081605201,1000000]
[null,null,null,null,48,812540.21165954403,2031.3505291488602,6263.7470386394025,4232.3965094905425,808307.81515005347,null,null,300659.85785469139,1000000]
[null,null,null,null,49,808307.81515005347,2020.7695378751337,6263.7470386394025,4242.9775007642693,804064.83764928917,null,null,306923.60489333078,1000000]
[null,null,null,null,50,804064.83764928917,2010.1620941232229,6263.7470386394025,4253.5849445161793,799811.25270477298,null,null,313187.35193197016,1000000]
[null,null,null,null,51,799811.25270477298,1999.5281317619324,6263.7470386394025,4264.2189068774696,795547.03379789554,null,null,319451.09897060954,1000000]
[null,null,null,null,52,795547.03379789554,1988.8675844947388,6263.7470386394025,4274.8794541446641,791272.15434375091,null,null,325714.84600924893,1000000]
[null,null,null,null,53,791272.15434375091,1978.1803858593773,6263.7470386394025,4285.5666527800249,786986.58769097086,null,null,331978.59304788831,1000000]
[null,null,null,null,54,786986.58769097086,1967.4664692274273,6263.7470386394025,4296.2805694119752,782690.30712155893,null,null,338242.34008652769,1000000]
[null,null,null,null,55,782690.30712155893,1956.7257678038973,6263.7470386394025,4307.0212708355048,778383.28585072339,null,null,344506.08712516708,1000000]
[null,null,null,null,56,778383.28585072339,1945.9582146268085,6263.7470386394025,4317.788824012594,774065.49702671077,null,null,350769.83416380646,1000000]
[null,null,null,null,57,774065.49702671077,1935.163742566777,6263.7470386394025,4328.5832960726257,769736.9137306381,null,null,357033.58120244584,1000000]
[null,null,null,null,58,769736.9137306381,1924.3422843265953,6263.7470386394025,4339.4047543128072,765397.50897632528,null,null,363297.32824108523,1000000]
[null,null,null,null,59,765397.50897632528,1913.4937724408132,6263.7470386394025,4350.2532661985897,761047.25571012672,null,null,369561.07527972461,1000000]
[null,null,null,null,60,761047.25571012672,1902.6181392753169,6263.7470386394025,4361.1288993640856,756686.12681076268,null,null,375824.82231836399,1000000]
[null,null,null,null,61,756686.12681076268,1891.7153170269066,6263.7470386394025,4372.0317216124959,752314.09508915024,null,null,382088.56935700338,1000000]
[null,null,null,null,62,752314.09508915024,1880.7852377228755,6263.7470386394025,4382.961800916527,747931.13328823377,null,null,388352.31639564276,1000000]
[null,null,null,null,63,747931.13328823377,1869.8278332205846,6263.7470386394025,4393.9192054188179,743537.21408281499,null,null,394616.06343428214,1000000]
[null,null,null,null,64,743537.21408281499,1858.8430352070375,6263.7470386394025,4404.9040034323652,739132.31007938262,null,null,400879.81047292153,1000000]
[null,null,null,null,65,739132.31007938262,1847.8307751984566,{"$f":"$B$10","v":6263.7470386394025},4415.9162634409458,734716.39381594164,null,null,{"$f":"M69+H70","v":407143.55751156091},{"$f":"$B$5","v":1000000}]
[null,null,null,null,66,734716.39381594164,{"$f":"F71*$B$8","v":1836.7909845398542},6263.7470386394025,4426.9560540995481,730289.43776184204,null,null,413407.30455020029,1000000]
[null,null,null,null,67,730289.43776184204,1825.7235944046051,6263.7470386394025,4438.0234442347974,725851.4143176073,null,null,419671.05158883968,1000000]
[null,null,null,null,68,725851.4143176073,1814.6285357940183,6263.7470386394025,4449.1185028453838,721402.29581476189,null,null,425934.79862747906,1000000]
[null,null,null,null,69,721402.29581476189,1803.5057395369047,6263.7470386394025,4460.2412991024976,716942.05451565934,null,null,432198.54566611844,1000000]
[null,null,null,null,70,716942.05451565934,1792.3551362891485,6263.7470386394025,4471.391902350254,712470.6626133091,null,null,438462.29270475783,1000000]
[null,null,null,null,71,712470.6626133091,1781.1766565332728,6263.7470386394025,4482.5703821061297,707988.09223120299,null,null,444726.03974339721,1000000]
[null,null,null,null,72,707988.09223120299,1769.9702305780074,6263.7470386394025,4493.7768080613951,703494.31542314158,null,null,450989.78678203659,1000000]
[null,null,null,null,73,703494.31542314158,1758.735788557854,6263.7470386394025,4505.0112500815485,698989.30417305999,null,null,457253.53382067598,1000000]
[null,null,null,null,74,698989.30417305999,1747.47326043265,6263.7470386394025,4516.2737782067525,694473.03039485321,null,null,463517.28085931536,1000000]
[null,null,null,null,75,694473.03039485321,1736.1825759871331,6263.7470386394025,4527.5644626522699,689945.4659322009,null,null,469781.02789795474,1000000]
[null,null,null,null,76,689945.4659322009,1724.8636648305023,6263.7470386394025,4538.8833738088997,685406.58255839196,null,null,476044.77493659413,1000000]
[null,null,null,null,77,685406.58255839196,1713.51645639598,6263.7470386394025,4550.2305822434228,680856.35197614855,null,null,482308.52197523351,1000000]
[null,null,null,null,78,680856.35197614855,1702.1408799403714,6263.7470386394025,4561.6061586990309,676294.74581744953,null,null,488572.26901387289,1000000]
[null,null,null,null,79,676294.74581744953,1690.7368645436238,6263.7470386394025,4573.0101740957789,671721.73564335378,null,null,494836.01605251228,1000000]
[null,null,null,null,80,671721.73564335378,1679.3043391083845,6263.7470386394025,4584.4426995310178,667137.2929438228,null,null,501099.76309115166,1000000]
[null,null,null,null,81,667137.2929438228,1667.8432323595571,6263.7470386394025,4595.9038062798454,662541.38913754292,null,null,507363.51012979104,1000000]
[null,null,null,null,82,662541.38913754292,1656.3534728438574,6263.7470386394025,4607.3935657955453,657933.99557174742,null,null,513627.25716843043,1000000]
[null,null,null,null,83,657933.99557174742,1644.8349889293686,6263.7470386394025,4618.9120497100339,653315.08352203737,null,null,519891.00420706981,1000000]
[null,null,null,null,84,653315.08352203737,1633.2877088050934,6263.7470386394025,4630.4593298343088,648684.62419220305,null,null,526154.75124570925,1000000]
[null,null,null,null,85,648684.62419220305,1621.7115604805076,6263.7470386394025,4642.0354781588949,644042.58871404419,null,null,532418.49828434864,1000000]
[null,null,null,null,{"$f":"E90+1","v":86},{"$f":"J90","v":644042.58871404419},1610.1064717851104,6263.7470386394025,{"$f":"H91-G91","v":4653.640566854292},{"$f":"F91-I91","v":639388.94814718992},null,null,538682.24532298802,1000000]
[null,null,null,null,87,639388.94814718992,1598.4723703679749,6263.7470386394025,4665.2746682714278,634723.6734789185,null,null,544945.9923616274,1000000]
[null,null,null,null,88,634723.6734789185,1586.8091836972962,6263.7470386394025,4676.9378549421062,630046.73562397645,null,null,551209.73940026679,1000000]
[null,null,null,null,89,630046.73562397645,1575.1168390599412,6263.7470386394025,4688.6301995794611,625358.10542439704,null,null,557473.48643890617,1000000]
[null,null,null,null,90,625358.10542439704,1563.3952635609926,6263.7470386394025,4700.3517750784104,620657.75364931859,null,null,563737.23347754555,1000000]
[null,null,null,null,91,620657.75364931859,1551.6443841232965,6263.7470386394025,4712.1026545161058,615945.65099480248,null,null,570000.98051618494,1000000]
[null,null,null,null,92,615945.65099480248,1539.8641274870063,6263.7470386394025,4723.8829111523964,611221.76808365004,null,null,576264.72755482432,1000000]
[null,null,null,null,93,611221.76808365004,1528.0544202091251,6263.7470386394025,4735.6926184302774,606486.07546521979,null,null,582528.4745934637,1000000]
[null,null,null,null,94,606486.07546521979,1516.2151886630495,6263.7470386394025,4747.5318499763525,601738.5436152434,null,null,588792.22163210309,1000000]
[null,null,null,null,95,601738.5436152434,1504.3463590381086,6263.7470386394025,4759.4006796012936,596979.14293564216,null,null,595055.96867074247,1000000]
[null,null,null,null,96,596979.14293564216,1492.4478573391054,6263.7470386394025,4771.2991813002973,592207.84375434183,null,null,601319.71570938185,1000000]
[null,null,null,null,97,592207.84375434183,1480.5196093858547,6263.7470386394025,4783.2274292535476,587424.61632508831,null,null,{"$f":"M101+H102","v":607583.46274802124},1000000]
[null,null,null,null,98,587424.61632508831,1468.5615408127208,6263.7470386394025,4795.185497826682,582629.43082726165,null,null,613847.20978666062,1000000]
[null,null,null,null,99,582629.43082726165,1456.5735770681542,6263.7470386394025,4807.1734615712485,577822.25736569043,null,null,620110.9568253,1000000]
[null,null,null,null,100,577822.25736569043,1444.5556434142261,6263.7470386394025,4819.1913952251762,573003.06597046531,null,null,626374.70386393939,1000000]
[null,null,null,null,101,573003.06597046531,1432.5076649261632,6263.7470386394025,4831.2393737132388,568171.82659675204,null,null,632638.45090257877,1000000]
[null,null,null,null,102,568171.82659675204,1420.4295664918802,6263.7470386394025,4843.3174721475225,563328.50912460452,null,null,638902.19794121815,1000000]
[null,null,null,null,103,563328.50912460452,1408.3212728115113,6263.7470386394025,4855.4257658278912,558473.08335877664,null,null,645165.94497985754,1000000]
[null,null,null,null,104,558473.08335877664,1396.1827083969417,6263.7470386394025,4867.5643302424605,553605.51902853418,null,null,651429.69201849692,1000000]
[null,null,null,null,105,553605.51902853418,1384.0137975713355,6263.7470386394025,4879.7332410680665,548725.7857874661,null,null,657693.4390571363,1000000]
[null,null,null,null,106,548725.7857874661,1371.8144644686652,6263.7470386394025,4891.9325741707371,543833.85321329534,null,null,663957.18609577569,1000000]
[null,null,null,null,107,543833.85321329534,1359.5846330332383,6263.7470386394025,4904.1624056061646,538929.69080768921,null,null,670220.93313441507,1000000]
[null,null,null,null,108,538929.69080768921,1347.3242270192231,6263.7470386394025,4916.4228116201793,534013.26799606904,null,null,676484.68017305445,1000000]
[null,null,null,null,109,534013.26799606904,1335.0331699901726,6263.7470386394025,4928.7138686492299,529084.55412741983,null,null,682748.42721169384,1000000]
[null,null,null,null,110,529084.55412741983,1322.7113853185497,6263.7470386394025,4941.0356533208524,524143.51847409899,null,null,689012.17425033322,1000000]
[null,null,null,null,111,524143.51847409899,1310.3587961852475,6263.7470386394025,4953.3882424541553,519190.13023164484,null,null,695275.9212889726,1000000]
[null,null,null,null,112,519190.13023164484,1297.9753255791122,6263.7470386394025,4965.7717130602905,514224.35851858457,null,null,701539.66832761199,1000000]
[null,null,null,null,113,514224.35851858457,1285.5608962964614,6263.7470386394025,4978.1861423429409,509246.17237624165,null,null,707803.41536625137,1000000]
[null,null,null,null,114,509246.17237624165,1273.1154309406043,6263.7470386394025,4990.6316076987987,504255.54076854285,null,null,714067.16240489075,1000000]
[null,null,null,null,115,504255.54076854285,1260.6388519213572,6263.7470386394025,5003.1081867180455,499252.43258182483,null,null,720330.90944353014,1000000]
[null,null,null,null,116,499252.43258182483,1248.131081454562,6263.7470386394025,5015.6159571848402,494236.81662464002,null,null,726594.65648216952,1000000]
[null,null,null,null,117,494236.81662464002,1235.5920415616001,6263.7470386394025,5028.1549970778024,489208.66162756219,null,null,732858.4035208089,1000000]
[null,null,null,null,118,489208.66162756219,1223.0216540689055,6263.7470386394025,5040.7253845704972,484167.93624299171,null,null,739122.15055944829,1000000]
[null,null,null,null,119,484167.93624299171,1210.4198406074793,6263.7470386394025,5053.3271980319232,479114.60904495977,null,null,745385.89759808767,1000000]
[null,null,null,null,120,479114.60904495977,1197.7865226123995,6263.7470386394025,5065.960516027003,474048.64852893277,null,null,751649.64463672705,1000000]
[null,null,null,null,121,474048.64852893277,1185.121621322332,6263.7470386394025,5078.625417317071,468970.02311161568,null,null,757913.39167536644,1000000]
[null,null,null,null,122,468970.02311161568,1172.4250577790392,6263.7470386394025,5091.3219808603635,463878.7011307553,null,null,764177.13871400582,1000000]
[null,null,null,null,123,463878.7011307553,1159.6967528268883,6263.7470386394025,5104.0502858125146,458774.65084494278,null,null,770440.8857526452,1000000]
[null,null,null,null,124,458774.65084494278,1146.936627112357,6263.7470386394025,5116.8104115270453,453657.84043341572,null,null,776704.63279128459,1000000]
[null,null,null,null,125,453657.84043341572,1134.1446010835393,6263.7470386394025,5129.6024375558627,448528.23799585988,null,null,782968.37982992397,1000000]
[null,null,null,null,126,448528.23799585988,1121.3205949896496,6263.7470386394025,5142.4264436497524,443385.81155221013,null,null,789232.12686856335,1000000]
[null,null,null,null,127,443385.81155221013,1108.4645288805254,6263.7470386394025,5155.2825097588775,438230.52904245124,null,null,795495.87390720274,1000000]
[null,null,null,null,128,438230.52904245124,1095.5763226061281,6263.7470386394025,5168.1707160332744,433062.35832641798,null,null,801759.62094584212,1000000]
[null,null,null,null,129,433062.35832641798,1082.6558958160449,{"$f":"$B$10","v":6263.7470386394025},5181.0911428233576,427881.26718359464,null,null,{"$f":"M133+H134","v":808023.36798448151},{"$f":"$B$5","v":1000000}]
[null,null,null,null,130,427881.26718359464,{"$f":"F135*$B$8","v":1069.7031679589866},6263.7470386394025,5194.0438706804161,422687.2233129142,null,null,814287.11502312089,1000000]
[null,null,null,null,131,422687.2233129142,1056.7180582822855,6263.7470386394025,5207.0289803571168,417480.19433255709,null,null,820550.86206176027,1000000]
[null,null,null,null,132,417480.19433255709,1043.7004858313928,6263.7470386394025,5220.0465528080094,412260.14777974907,null,null,826814.60910039966,1000000]
[null,null,null,null,133,412260.14777974907,1030.6503694493726,6263.7470386394025,5233.0966691900303,407027.05111055903,null,null,833078.35613903904,1000000]
[null,null,null,null,134,407027.05111055903,1017.5676277763976,6263.7470386394025,5246.1794108630047,401780.871699696,null,null,839342.10317767842,1000000]
[null,null,null,null,135,401780.871699696,1004.45217924924,6263.7470386394025,5259.2948593901629,396521.57684030582,null,null,845605.85021631781,1000000]
[null,null,null,null,136,396521.57684030582,991.30394210076452,6263.7470386394025,5272.4430965386382,391249.13374376716,null,null,851869.59725495719,1000000]
[null,null,null,null,137,391249.13374376716,978.12283435941788,6263.7470386394025,5285.624204279985,385963.50953948719,null,null,858133.34429359657,1000000]
[null,null,null,null,138,385963.50953948719,964.90877384871794,6263.7470386394025,5298.8382647906847,380664.67127469648,null,null,864397.09133223596,1000000]
[null,null,null,null,139,380664.67127469648,951.66167818674126,6263.7470386394025,5312.085360452661,375352.58591424383,null,null,870660.83837087534,1000000]
[null,null,null,null,{"$f":"E144+1","v":140},{"$f":"J144","v":375352.58591424383},938.38146478560964,6263.7470386394025,{"$f":"H145-G145","v":5325.3655738537927},{"$f":"F145-I145","v":370027.22034039005},null,null,876924.58540951472,1000000]
[null,null,null,null,141,370027.22034039005,925.06805085097517,6263.7470386394025,5338.6789877884275,364688.54135260161,null,null,883188.33244815411,1000000]
[null,null,null,null,142,364688.54135260161,911.72135338150406,6263.7470386394025,5352.0256852578987,359336.51566734369,null,null,889452.07948679349,1000000]
[null,null,null,null,143,359336.51566734369,898.34128916835925,6263.7470386394025,5365.4057494710432,353971.10991787264,null,null,895715.82652543287,1000000]
[null,null,null,null,144,353971.10991787264,884.92777479468168,6263.7470386394025,5378.8192638447208,348592.29065402795,null,null,901979.57356407226,1000000]
[null,null,null,null,145,348592.29065402795,871.48072663506991,6263.7470386394025,5392.2663120043326,343200.02434202359,null,null,908243.32060271164,1000000]
[null,null,null,null,146,343200.02434202359,858.00006085505902,6263.7470386394025,5405.7469777843435,337794.27736423927,null,null,914507.06764135102,1000000]
[null,null,null,null,147,337794.27736423927,844.48569341059817,6263.7470386394025,5419.2613452288042,332375.01601901045,null,null,920770.81467999041,1000000]
[null,null,null,null,148,332375.01601901045,830.93754004752611,6263.7470386394025,5432.809498591876,326942.20652041858,null,null,927034.56171862979,1000000]
[null,null,null,null,149,326942.20652041858,817.35551630104646,6263.7470386394025,5446.3915223383556,321495.8149980802,null,null,933298.30875726917,1000000]
[null,null,null,null,150,321495.8149980802,803.73953749520047,6263.7470386394025,5460.0075011442023,316035.807496936,null,null,939562.05579590856,1000000]
[null,null,null,null,151,316035.807496936,790.08951874234003,6263.7470386394025,5473.6575198970622,310562.14997703896,null,null,945825.80283454794,1000000]
[null,null,null,null,152,310562.14997703896,776.4053749425974,6263.7470386394025,5487.341663696805,305074.80831334216,null,null,952089.54987318732,1000000]
[null,null,null,null,153,305074.80831334216,762.68702078335536,6263.7470386394025,5501.0600178560471,299573.74829548609,null,null,958353.29691182671,1000000]
[null,null,null,null,154,299573.74829548609,748.93437073871519,6263.7470386394025,5514.8126679006873,294058.93562758539,null,null,964617.04395046609,1000000]
[null,null,null,null,155,294058.93562758539,735.14733906896345,6263.7470386394025,5528.599699570439,288530.33592801495,null,null,970880.79098910547,1000000]
[null,null,null,null,156,288530.33592801495,721.32583982003734,6263.7470386394025,5542.4211988193656,282987.91472919559,null,null,977144.53802774486,1000000]
[null,null,null,null,157,282987.91472919559,707.46978682298902,6263.7470386394025,5556.2772518164138,277431.63747737918,null,null,983408.28506638424,1000000]
[null,null,null,null,158,277431.63747737918,693.57909369344793,6263.7470386394025,5570.1679449459543,271861.4695324332,null,null,989672.03210502362,1000000]
[null,null,null,null,159,271861.4695324332,679.65367383108298,6263.7470386394025,5584.0933648083192,266277.3761676249,null,null,995935.77914366301,1000000]
[null,null,null,null,160,266277.3761676249,665.69344041906231,6263.7470386394025,5598.0535982203401,260679.32256940455,null,null,1002199.5261823024,1000000]
[null,null,null,null,161,260679.32256940455,651.69830642351144,6263.7470386394025,5612.0487322158915,255067.27383718867,null,null,{"$f":"M165+H166","v":1008463.2732209418},1000000]
[null,null,null,null,162,255067.27383718867,637.66818459297167,6263.7470386394025,5626.0788540464309,249441.19498314222,null,null,1014727.0202595812,1000000]
[null,null,null,null,163,249441.19498314222,623.60298745785553,6263.7470386394025,5640.1440511815472,243801.05093196066,null,null,1020990.7672982205,1000000]
[null,null,null,null,164,243801.05093196066,609.50262732990166,6263.7470386394025,5654.2444113095007,238146.80652065115,null,null,1027254.5143368599,1000000]
[null,null,null,null,165,238146.80652065115,595.36701630162793,6263.7470386394025,5668.3800223377748,232478.42649831338,null,null,1033518.2613754993,1000000]
[null,null,null,null,166,232478.42649831338,581.19606624578341,6263.7470386394025,5682.5509723936193,226795.87552591975,null,null,1039782.0084141387,1000000]
[null,null,null,null,167,226795.87552591975,566.98968881479936,6263.7470386394025,5696.7573498246029,221099.11817609516,null,null,1046045.7554527781,1000000]
[null,null,null,null,168,221099.11817609516,552.74779544023795,6263.7470386394025,5710.999243199165,215388.118932896,null,null,1052309.5024914176,1000000]
[null,null,null,null,169,215388.118932896,538.47029733223997,6263.7470386394025,5725.2767413071624,209662.84219158883,null,null,1058573.249530057,1000000]
[null,null,null,null,170,209662.84219158883,524.15710547897208,6263.7470386394025,5739.5899331604305,203923.2522584284,null,null,1064836.9965686963,1000000]
[null,null,null,null,171,203923.2522584284,509.80813064607099,6263.7470386394025,5753.9389079933317,198169.31335043506,null,null,1071100.7436073357,1000000]
[null,null,null,null,172,198169.31335043506,495.42328337608762,6263.7470386394025,5768.3237552633145,192400.98959517173,null,null,1077364.4906459751,1000000]
[null,null,null,null,173,192400.98959517173,481.00247398792936,6263.7470386394025,5782.7445646514734,186618.24503052025,null,null,1083628.2376846145,1000000]
[null,null,null,null,174,186618.24503052025,466.54561257630064,6263.7470386394025,5797.2014260631022,180821.04360445714,null,null,1089891.9847232539,1000000]
[null,null,null,null,175,180821.04360445714,452.05260901114286,6263.7470386394025,5811.69442962826,175009.34917482888,null,null,1096155.7317618933,1000000]
[null,null,null,null,176,175009.34917482888,437.52337293707222,6263.7470386394025,5826.2236657023304,169183.12550912655,null,null,1102419.4788005326,1000000]
[null,null,null,null,177,169183.12550912655,422.95781377281639,6263.7470386394025,5840.7892248665858,163342.33628425997,null,null,1108683.225839172,1000000]
[null,null,null,null,178,163342.33628425997,408.35584071064994,6263.7470386394025,5855.3911979287523,157486.94508633122,null,null,1114946.9728778114,1000000]
[null,null,null,null,179,157486.94508633122,393.71736271582807,6263.7470386394025,5870.0296759235744,151616.91541040764,null,null,1121210.7199164508,1000000]
[null,null,null,null,180,151616.91541040764,379.04228852601909,6263.7470386394025,5884.7047501133839,145732.21066029425,null,null,1127474.4669550902,1000000]
[null,null,null,null,181,145732.21066029425,364.33052665073564,6263.7470386394025,5899.4165119886666,139832.79414830558,null,null,1133738.2139937296,1000000]
[null,null,null,null,182,139832.79414830558,349.58198537076396,6263.7470386394025,5914.1650532686381,133918.62909503694,null,null,1140001.9610323689,1000000]
[null,null,null,null,183,133918.62909503694,334.79657273759238,6263.7470386394025,5928.9504659018103,127989.67862913513,null,null,1146265.7080710083,1000000]
[null,null,null,null,184,127989.67862913513,319.97419657283785,6263.7470386394025,5943.7728420665644,122045.90578706856,null,null,1152529.4551096477,1000000]
[null,null,null,null,185,122045.90578706856,305.11476446767142,6263.7470386394025,5958.6322741717313,116087.27351289683,null,null,1158793.2021482871,1000000]
[null,null,null,null,186,116087.27351289683,290.21818378224208,6263.7470386394025,5973.5288548571607,110113.74465803968,null,null,1165056.9491869265,1000000]
[null,null,null,null,187,110113.74465803968,275.28436164509918,6263.7470386394025,5988.4626769943034,104125.28198104538,null,null,1171320.6962255659,1000000]
[null,null,null,null,188,104125.28198104538,260.31320495261343,6263.7470386394025,6003.4338336867895,98121.848147358585,null,null,1177584.4432642052,1000000]
[null,null,null,null,189,98121.848147358585,245.30462036839646,6263.7470386394025,6018.4424182710063,92103.405729087579,null,null,1183848.1903028446,1000000]
[null,null,null,null,190,92103.405729087579,230.25851432271895,6263.7470386394025,6033.4885243166837,86069.9172047709,null,null,1190111.937341484,1000000]
[null,null,null,null,191,86069.9172047709,215.17479301192725,6263.7470386394025,6048.5722456274752,80021.344959143418,null,null,1196375.6843801234,1000000]
[null,null,null,null,192,80021.344959143418,200.05336239785856,6263.7470386394025,6063.6936762415444,73957.651282901876,null,null,1202639.4314187628,1000000]
[null,null,null,null,193,73957.651282901876,184.89412820725468,{"$f":"$B$10","v":6263.7470386394025},6078.8529104321478,67878.798372469726,null,null,{"$f":"M197+H198","v":1208903.1784574022},{"$f":"$B$5","v":1000000}]
[null,null,null,null,194,67878.798372469726,{"$f":"F199*$B$8","v":169.69699593117431},6263.7470386394025,6094.0500427082279,61784.748329761496,null,null,1215166.9254960415,1000000]
[null,null,null,null,195,61784.748329761496,154.46187082440375,6263.7470386394025,6109.2851678149991,55675.4631619465,null,null,1221430.6725346809,1000000]
[null,null,null,null,196,55675.4631619465,139.18865790486626,6263.7470386394025,6124.5583807345365,49550.904781211961,null,null,1227694.4195733203,1000000]
[null,null,null,null,197,49550.904781211961,123.8772619530299,6263.7470386394025,6139.8697766863725,43411.035004525591,null,null,1233958.1666119597,1000000]
[null,null,null,null,198,43411.035004525591,108.52758751131398,6263.7470386394025,6155.2194511280886,37255.8155533975,null,null,1240221.9136505991,1000000]
[null,null,null,null,199,37255.8155533975,93.139538883493756,6263.7470386394025,6170.607499755909,31085.208053641592,null,null,1246485.6606892385,1000000]
[null,null,null,null,200,31085.208053641592,77.713020134103985,6263.7470386394025,6186.0340185052983,24899.174035136293,null,null,1252749.4077278778,1000000]

{"sheet":"Tip20","index":23,"n_rows":81,"n_cols":107,"rows_kept":81,"cut":false,"hidden":false,"merged":[[5,1,6,1],[24,1,25,1],[41,1,42,1],[61,1,62,1]]}
["←",null,"Magic charts"]
[null,null,null,null,null,null,"Perioda",0.8]
[null,null,null,null,null,null,"Min.",-5]
[null,null,null,null,null,null,"Max.",5]
[null,null,null,null,null,null,null,5]
[null,1,"Histogram hodnot s vyznačeným maximem",null,null,null,null,0,10,20,30,40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190,200,210,220,230,240,250,260,270,280,290,300,310,320,330,340,350,360,370,380,390,400,410,420,430,440,450,460,470,480,490,500,510,520,530,540,550,560,570,580,590,600,610,620,630,640,650,660,670,680,690,700,710,720,730,740,750,760,770,780,790,800,810,820,830,840,850,860,870,880,890,900,910,920,930,940,950,960,970,980,990]
[null,null,"Tvořeno jako kombinovaný graf.",null,null,null,"Standard 6 s riziky",{"$f":"(SIN(H6*$H$2*PI()/180)+RANDBETWEEN($H$3,$H$4)/$H$5+2)","v":1},{"$f":"(SIN(I6*$H$2*PI()/180)+RANDBETWEEN($H$3,$H$4)/$H$5+2)","v":2.1391731009600656},2.4756373558169993,2.8067366430758001,1.929919264233205,1.8427876096865392,3.5431448254773943,3.4290375725550417,2.2987940462991672,2.7510565162951535,2.784807753012208,2.7993908270190957,3.7945218953682733,2.1702957262759965,3.3271838545667873,3.0660254037844386,3.7880107536067218,2.2946583704589969,1.9877852522924733,2.269471562785891,1.942020143325669,1.2079116908177592,2.8697564737441255,2.130243526255875,1.7920883091822408,2.0579798566743315,1.9305284372141092,1.2122147477075269,1.3053416295410027,0.6119892463932779,0.53397459621556154,0.47281614543321271,1.0297042737240036,2.0054781046317265,0.40060917298090426,1.4151922469877918,1.8489434837048464,1.7012059537008328,0.77096242744495802,1.6568551745226054,1.7572123903134604,0.87008073576679434,2.5932633569241998,0.92436264418300018,1.460826899039934,1.5999999999999996,1.9391731009600646,2.6756373558169995,2.4067366430757997,2.9299192642332046,3.4427876096865391,3.1431448254773935,1.8290375725550418,2.2987940462991667,3.1510565162951538,3.5848077530122078,2.1993908270190956,3.1945218953682737,2.7702957262759966,2.3271838545667878,2.2660254037844392,3.5880107536067225,1.8946583704589977,1.7877852522924733,2.8694715627858907,{"$f":"(SIN(BU6*$H$2*PI()/180)+RANDBETWEEN($H$3,$H$4)/$H$5+2)","v":1.9420201433256687},1.6079116908177591,2.8697564737441268,1.9302435262558741,0.79208830918224171,1.857979856674332,2.33052843721411,0.41221474770752708,1.9053416295410028,1.011989246393278,0.53397459621556131,1.2728161454332132,2.0297042737240032,1.0054781046317269,1.8006091729809044,1.4151922469877918,0.64894348370484622,1.7012059537008319,1.7709624274449582,0.65685517452260589,0.35721239031346097,1.0700807357667941,2.1932633569241986,0.724362644183,2.0608268990399354,1.5999999999999994,1.1391731009600652,3.2756373558169973,1.8067366430757987,3.5299192642332051,1.8427876096865397,2.9431448254773933,2.629037572555041,3.6987940462991666,2.351056516295154]
[null,null,"V grafu jsou dvě řady překryté přes sebe."]
[null,null,"Součtová čára na vedlejší ose.",null,null,null,"Min. rizik.",{"$f":"MIN(H7:DC7)","v":0.35721239031346097}]
[null,null,"Max. hodnota dohledaná jako:",null,null,null,"Max. rizik.",{"$f":"MAX(H7:DC7)","v":3.7945218953682733}]
[null,null," =SVYHLEDAT(J22;J13:K21;2;NEPRAVDA)",null,null,null,"Počet tříd",{"$f":"ROUNDUP(2.5*100^0.25,0)","v":8}]
[null,null,null,null,null,null,"Krok",{"$f":"(H10-H9)/H11","v":0.42966368813185152},"Souč. čára","Četnosti","Intervaly","Pomocná data"]
[null,null,null,null,null,null,1,{"$f":"H9","v":0.35721239031346097},{"$f":"FREQUENCY($H$7:$DC$7,H13)","v":1},{"$f":"I13","v":1},{"$f":"H13","v":0.35721239031346097},{"$f":"IF(J13<>$J$22,J13,0)","v":1},{"$f":"IF(J13=$J$22,J13,0)","v":0}]
[null,null,null,null,null,null,{"$f":"G13+1","v":2},{"$f":"H13+$H$12","v":0.78687607844531249},{"$f":"FREQUENCY($H$7:$DC$7,H14)","v":11},{"$f":"I14-I13","v":10},{"$f":"H14","v":0.78687607844531249},{"$f":"IF(J14<>$J$22,J14,0)","v":10},{"$f":"IF(J14=$J$22,J14,0)","v":0}]
[null,null,null,null,null,null,{"$f":"G14+1","v":3},{"$f":"H14+$H$12","v":1.216539766577164},22,{"$f":"I15-I14","v":11},1.216539766577164,11,0]
[null,null,null,null,null,null,4,1.6462034547090156,30,8,1.6462034547090156,8,0]
[null,null,null,null,null,null,5,2.0758671428408673,57,27,2.0758671428408673,0,27]
[null,null,null,null,null,null,6,2.5055308309727189,72,15,2.5055308309727189,15,0]
[null,null,null,null,null,null,7,2.9351945191045705,84,12,2.9351945191045705,12,0]
[null,null,null,null,null,null,8,3.3648582072364221,91,7,3.3648582072364221,7,0]
[null,null,null,null,null,null,9,3.7945218953682738,100,9,3.7945218953682738,9,0]
[null,null,null,null,null,null,null,null,"Max",{"$f":"MAX(J13:J21)","v":27}]
[null,null,null,null,null,null,null,null,"Nejčastější hodnota",{"$f":"VLOOKUP(J22,J13:K21,2,FALSE)","v":2.0758671428408673}]
[]
[null,2,"Graf s vyznačenými přesahy přes maximum"]
[null,null,"Maximum",2.5,null,null,null,{"$f":"IF($E$32,IF(H7>$D$26,$D$26,H7),0)","v":1},{"$f":"IF($E$32,IF(I7>$D$26,$D$26,I7),0)","v":2.1391731009600656},2.4756373558169993,2.5,1.929919264233205,1.8427876096865392,2.5,2.5,2.2987940462991672,2.5,2.5,2.5,2.5,2.1702957262759965,2.5,2.5,2.5,2.2946583704589969,1.9877852522924733,2.269471562785891,1.942020143325669,1.2079116908177592,2.5,2.130243526255875,1.7920883091822408,2.0579798566743315,1.9305284372141092,1.2122147477075269,1.3053416295410027,0.6119892463932779,0.53397459621556154,0.47281614543321271,1.0297042737240036,2.0054781046317265,0.40060917298090426,1.4151922469877918,1.8489434837048464,1.7012059537008328,0.77096242744495802,1.6568551745226054,1.7572123903134604,0.87008073576679434,2.5,0.92436264418300018,1.460826899039934,1.5999999999999996,1.9391731009600646,2.5,2.4067366430757997,2.5,2.5,2.5,1.8290375725550418,2.2987940462991667,2.5,2.5,2.1993908270190956,2.5,2.5,2.3271838545667878,2.2660254037844392,2.5,1.8946583704589977,1.7877852522924733,2.5,{"$f":"IF($E$32,IF(BU7>$D$26,$D$26,BU7),0)","v":1.9420201433256687},1.6079116908177591,2.5,1.9302435262558741,0.79208830918224171,1.857979856674332,2.33052843721411,0.41221474770752708,1.9053416295410028,1.011989246393278,0.53397459621556131,1.2728161454332132,2.0297042737240032,1.0054781046317269,1.8006091729809044,1.4151922469877918,0.64894348370484622,1.7012059537008319,1.7709624274449582,0.65685517452260589,0.35721239031346097,1.0700807357667941,2.1932633569241986,0.724362644183,2.0608268990399354,1.5999999999999994,1.1391731009600652,2.5,1.8067366430757987,2.5,1.8427876096865397,2.5,2.5,2.5,2.351056516295154]
[null,null,"Tvořeno jako kombinovaný graf.",null,null,null,null,{"$f":"IF($E$33,IF(H7>$D$26,H7-D26,0),0)","v":0},{"$f":"IF($E$33,IF(I7>$D$26,I7-E26,0),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($E$33,IF(BU7>$D$26,BU7-BQ26,0),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"V grafu jsou dvě řady jako skládané.",null,null,null,null,{"$f":"$D$26","v":2.5},{"$f":"$D$26","v":2.5},2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,{"$f":"$D$26","v":2.5},2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5]
[null,null,"První řada je do maximální hodnoty."]
[null,null,"Druhá řada je přidaná nad maximum."]
[null,null,"Třetí řada je maximum jako spojnice."]
[null,null,null,null,true]
[null,null,null,null,false]
[]
[]
[]
[]
[]
[]
[]
[]
[null,3,"Histogram pomocí nástroje Analýza dat"]
[null,null,"V menu Soubor/Možnosti/Doplňky zavést Analýza dat"]
[]
[null,null,null,null,null,null,null,null,null,null,null,5.4780999999999996E-3,"Četnost"]
[null,null,null,null,null,null,null,null,null,null,null,0.66412028716349836,6]
[null,null,null,null,null,null,null,null,null,null,null,1.0423762381486978,9]
[null,null,null,null,null,null,null,null,null,null,null,1.5457818899969131,17]
[null,null,null,null,null,null,null,null,null,null,null,1.9975655341745888,15]
[null,null,null,null,null,null,null,null,null,null,null,2.4877641290737884,16]
[null,null,null,null,null,null,null,null,null,null,null,3.0330367693182123,15]
[null,null,null,null,null,null,null,null,null,null,null,3.4993575280982863,13]
[null,null,"Zvolit na kartě Data/Analýza dat/Histogram",null,null,null,null,null,null,null,null,3.9945218953682731,8]
[null,null,null,null,null,null,null,null,null,null,null,"Další",0]
[]
[]
[]
[]
[]
[]
[]
[null,4,"Kaskádový (Waterfall) graf"]
[null,null,"Zobrazuje počáteční a koncovou hodnotu.",null,null,null,null,null,"Období","Produkce",null,"Poč./Kon.","Pomocná","Růst","Pokles"]
[null,null,"Zobrazuje přírůstky po obdobích.",null,null,null,null,null,2016,100,{"$f":"J64","v":100},{"$f":"J64","v":100}]
[null,null,"Kladné a záporné přírůstky jsou odlišeny barvou.",null,null,null,null,null,{"$f":"I64+1","v":2017},160,{"$f":"J65-J64","v":60},null,{"$f":"MIN(SUM(K$64:K64),SUM(K$64:K65))","v":100},{"$f":"MAX(K65,0)","v":60},{"$f":"-MIN(K65,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I65+1","v":2018},140,{"$f":"J66-J65","v":-20},null,{"$f":"MIN(SUM(K$64:K65),SUM(K$64:K66))","v":140},{"$f":"MAX(K66,0)","v":0},{"$f":"-MIN(K66,0)","v":20}]
[null,null,null,null,null,null,null,null,2019,120,-20,null,{"$f":"MIN(SUM(K$64:K66),SUM(K$64:K67))","v":120},0,20]
[null,null,null,null,null,null,null,null,2020,150,30,null,{"$f":"MIN(SUM(K$64:K67),SUM(K$64:K68))","v":120},30,0]
[null,null,null,null,null,null,null,null,2021,160,10,null,{"$f":"MIN(SUM(K$64:K68),SUM(K$64:K69))","v":150},10,0]
[null,null,null,null,null,null,null,null,2022,140,-20,null,{"$f":"MIN(SUM(K$64:K69),SUM(K$64:K70))","v":140},0,20]
[null,null,null,null,null,null,null,null,2023,150,10,null,{"$f":"MIN(SUM(K$64:K70),SUM(K$64:K71))","v":140},10,0]
[null,null,null,null,null,null,null,null,2024,170,null,{"$f":"J72","v":170},null,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K64","v":100}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J65-J64","v":60}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J66-J65","v":-20}]
[null,null,null,null,null,null,null,null,null,null,-20]
[null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,-20]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,"Upravená zdroj: ","http://office.lasakovi.com/excel/grafy/typy-seznam-grafu-excel/#16",null,null,null,null,null,null,20]

{"sheet":"Tip21","index":24,"n_rows":28,"n_cols":107,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,1,6,1],[24,1,25,1],[41,1,42,1]]}
["←",null,"Custom format cells"]
[]
[]
[]
[null,null,"Kusy",null,10,"0\" Ks\""]
[null,null,"Kusy",null,10,"0\" ks\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,710,720,730,740,750,760,770,780,790,800,810,820,830,840,850,860,870,880,890,900,910,920,930,940,950,960,970,980,990]
[null,null,"Bezrozměrná",null,10,"0\" [-]\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SIN(BZ6*$H$2*PI()/180)+RANDBETWEEN($H$3,$H$4)/$H$5+2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Doplnění znaků",null,10,"\"XX \"0\"0,--\"*X"]
[null,null,"Podmínka \"0,0000\"",null,0.2,"[<1]0,0000\" W\";[<1000]0,000\" W\";0,00\" A\""]
[null,null,"Náhrada čísel za slova",null,0,"\"kladné\";\"záporné\";\"bez trendu\""]
[null,null,"Trendy",null,0,"\"rostoucí\";\"klesající\""]
[]
[]
[null,null,"Zdroje:"]
[null,null,"http://wall.cz/excel-navod/vlastni-format-bunek"]
[null,null,"https://support.office.com/cs-cz/article/Vytvo%C5%99en%C3%AD-nebo-odstran%C4%9Bn%C3%AD-vlastn%C3%ADho-form%C3%A1tu-%C4%8D%C3%ADsla-78f2a361-936b-4c03-8772-09fab54be7f4#bm1"]
[null,null,"http://www.votruba.in/tab/format.pdf"]
[null,null,"http://www.excel-easy.com/examples/custom-number-format.html"]
[null,null,"http://www.exceltactics.com/definitive-guide-custom-number-formats-excel/"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BZ7>$D$26,$D$26,BZ7)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BZ7>$D$26,BZ7-BV26,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Tip22","index":25,"n_rows":28,"n_cols":107,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,1,6,1],[24,1,25,1],[41,1,42,1]]}
["←",null,"COUNTIF formula modif User function"]
[]
[]
[null,null,"Jak zjistit kolikrát je levý sloupec hodnot větší než pravý?"]
[null,null,"Použití vlastní funkce =PocetVetsich(…)"]
[null,null,null,5,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,710,720,730,740,750,760,770,780,790,800,810,820,830,840,850,860,870,880,890,900,910,920,930,940,950,960,970,980,990]
[null,null,null,4,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SIN(BZ6*$H$2*PI()/180)+RANDBETWEEN($H$3,$H$4)/$H$5+2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,10,9]
[null,null,null,1,2]
[null,null,null,8,4]
[null,null,null,5,9]
[null,null,null,3,7]
[]
[null,null,"Syntaxe"]
[null,null," =PocetVetsich(D6:D12;E6:E12)"]
[null,null,"Výsledek:",{"$f":"PocetVetsich(D6:D12,E6:E12)","v":{"$error":"#NAME?"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BZ7>$D$26,$D$26,BZ7)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BZ7>$D$26,BZ7-BV26,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Tip23","index":26,"n_rows":41,"n_cols":107,"rows_kept":41,"cut":false,"hidden":false,"merged":[[28,7,29,7],[7,1,8,1],[26,1,27,1],[43,1,44,1],[28,4,29,4],[28,5,29,5],[28,6,29,6]]}
["←",null,"Scenario Manager"]
[]
[]
[null,null,"Jak porovnat výsledné hodnoty pro různé vstupy?"]
[null,null,"Správce scénářů umožňuje porovnávat scénáře vstupů."]
[null,null,"Funkce dostupná z karty Data/Citlivostní analýza"]
[]
[null,null,"Výroba :",null,100,"t",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,710,720,730,740,750,760,770,780,790,800,810,820,830,840,850,860,870,880,890,900,910,920,930,940,950,960,970,980,990]
[null,null,"Prodej :",null,100,"t",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SIN(BZ8*$H$2*PI()/180)+RANDBETWEEN($H$3,$H$4)/$H$7+2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Počet zaměstanců :",null,50]
[null,null,"Jednotková cena :",null,5000,"Kč/t"]
[]
[null,null,"Celková cena výroby :",null,{"$f":"E8*E11","v":500000},"Kč/měsíc"]
[null,null,"Efektivita na 1 zaměstnance :",null,{"$f":"E13/E10","v":10000},"Kč/měsíc"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Zpráva s porovnáním vstupních a výstupních hodnot:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BZ9>#REF!,#REF!,BZ9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CA9>#REF!,#REF!,CA9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CB9>#REF!,#REF!,CB9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CC9>#REF!,#REF!,CC9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CD9>#REF!,#REF!,CD9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CE9>#REF!,#REF!,CE9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CF9>#REF!,#REF!,CF9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CG9>#REF!,#REF!,CG9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CH9>#REF!,#REF!,CH9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CI9>#REF!,#REF!,CI9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CJ9>#REF!,#REF!,CJ9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CK9>#REF!,#REF!,CK9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CL9>#REF!,#REF!,CL9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CM9>#REF!,#REF!,CM9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CN9>#REF!,#REF!,CN9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CO9>#REF!,#REF!,CO9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CP9>#REF!,#REF!,CP9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CQ9>#REF!,#REF!,CQ9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CR9>#REF!,#REF!,CR9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CS9>#REF!,#REF!,CS9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CT9>#REF!,#REF!,CT9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CU9>#REF!,#REF!,CU9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CV9>#REF!,#REF!,CV9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CW9>#REF!,#REF!,CW9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CX9>#REF!,#REF!,CX9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CY9>#REF!,#REF!,CY9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CZ9>#REF!,#REF!,CZ9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(DA9>#REF!,#REF!,DA9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(DB9>#REF!,#REF!,DB9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(DC9>#REF!,#REF!,DC9)","v":{"$error":"#DIV/0!"}}]
[null,null,"Zpráva scénáře",null,"Aktuální hodnoty:","Úspěšné nadstandardní prodeje","Úspěšné standardní prodeje","Neúspěšné období",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BZ9>#REF!,BZ9-BV28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CA9>#REF!,CA9-BW28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CB9>#REF!,CB9-BX28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CC9>#REF!,CC9-BY28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CD9>#REF!,CD9-BZ28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CE9>#REF!,CE9-CA28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CF9>#REF!,CF9-CB28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CG9>#REF!,CG9-CC28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CH9>#REF!,CH9-CD28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CI9>#REF!,CI9-CE28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CJ9>#REF!,CJ9-CF28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CK9>#REF!,CK9-CG28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CL9>#REF!,CL9-CH28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CM9>#REF!,CM9-CI28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CN9>#REF!,CN9-CJ28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CO9>#REF!,CO9-CK28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CP9>#REF!,CP9-CL28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CQ9>#REF!,CQ9-CM28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CR9>#REF!,CR9-CN28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CS9>#REF!,CS9-CO28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CT9>#REF!,CT9-CP28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CU9>#REF!,CU9-CQ28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CV9>#REF!,CV9-CR28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CW9>#REF!,CW9-CS28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CX9>#REF!,CX9-CT28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CY9>#REF!,CY9-CU28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CZ9>#REF!,CZ9-CV28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(DA9>#REF!,DA9-CW28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(DB9>#REF!,DB9-CX28,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(DC9>#REF!,DC9-CY28,0)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Výroba pokryla veškěrý odbyt nad standardní hladinou.","Výroba na standardní hladině","Nerealizované prodeje (nadvýroba)."]
[null,null,"Měněné buňky:"]
[null,null,null,"Vyroba",80,100,90,80]
[null,null,null,"$E$9",60,100,90,60]
[null,null,null,"$E$11",5000,5000,5000,5000]
[null,null,"Výsledné buňky:"]
[null,null,null,"$E$13",400000,500000,450000,400000]
[null,null,null,"$E$14",8000,10000,9000,8000]
[null,null,"Poznámka: Sloupec Aktuální hodnoty představuje hodnoty měněných"]
[null,null,"buněk v okamžiku, kdy zpráva scénáře byla vytvořena. Měněné buňky"]
[null,null,"každého scénáře jsou označeny šedě."]

{"sheet":"Tip24","index":27,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["←",null,"Podmíněné formátování"]
[]
[]
[]
[null,null,"Co chci?","Zvýraznit řádek podle hodnoty v jednom sloupci"]
[null,null,"Postup","1. vytvořit tabulku",null,null,null,null,null,null,null,"Řídicí sloupec","Třída 1","Třída 2"]
[null,null,null,"2. první sloupec je jako řídicí",null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(8,18)","v":8},"zelená","zelená"]
[null,null,null,"3. rozhodující je maximální hodnota",null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(8,18)","v":15},"modrá","modrá"]
[null,null,null,"4. definuje se podmíněné pravidlo",null,null,null,null,null,null,null,11,"bílá","bílá"]
[null,null,null,"  =$L7=$L$17",null,null,null,null,null,null,null,18,"žlutá","žlutá"]
[null,null,null,"5. pracuje tak, že porovnává buňky od $L7",null,null,null,null,null,null,null,17,"zelená","zelená"]
[null,null,null,"     s buňkou maxima",null,null,null,null,null,null,null,12,"červená","červená"]
[null,null,null,"6. buňky ostatních sloupců aplikují pravidlo ze sousedního sloupce",null,null,null,null,null,null,null,8,"modrá","modrá"]
[null,null,null,"7. řídicí by mohl být i jiný sloupec",null,null,null,null,null,null,null,18,"bílá","bílá"]
[null,null,null,"  =$N7=$L$17",null,null,null,null,null,null,null,13,"modrá","modrá"]
[null,null,null,null,null,null,null,null,null,null,null,13,"bílá","bílá"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(L7:L16)","v":18}]

{"sheet":"Tip25","index":28,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,8,6,8],[5,9,6,9]]}
["←",null,"Funkce POSUN … různě velké oblasti",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Co chci?","Sčítat například různě velké oblasti hodnot",null,null,null,null,null,null,null,null,4]
[null,null,null,"Říct, jak velkou oblast použít ve vzorci?",null,null,null,null,"Vyrobené zboží [ks]","Vrácené zboží [ks]",null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,"Postup","1. vytvořit zpracovávaná data",null,null,null,null,5,5,null,null,7]
[null,null,null,"2. definovat jak velkou oblast použít",null,null,null,null,2,3]
[null,null,null,"     kolik řádků použít",null,null,2,null,7,4]
[null,null,null,"3. počet hodnot použít ve funkci POSUN",null,null,null,null,1,2]
[null,null,null,"4. funkce vytvoří odkaz na oblast",null,null,null,null,2,1]
[null,null,null,"5. tuto oblast umí zpracovat další funkce",null,null,null,null,4,1]
[null,null,null,"  =POSUN(I8;0;0;G10;1)",null,null,null,null,5,2]
[null,null,null,{"$f":"CONCATENATE(\"Součet prvních \",G10,\" hodnot =\")","v":"Součet prvních 2 hodnot ="},null,{"$f":"SUM(OFFSET(I8,0,0,G10,1))","v":7}]
[null,null,null,{"$f":"CONCATENATE(\"Průměr prvních \",G10,\" hodnot =\")","v":"Průměr prvních 2 hodnot ="},null,{"$f":"AVERAGE(OFFSET(I8,0,0,G10,1))","v":3.5}]
[null,null,null,"6. je možné aplikovat také pro tabulku"]
[null,null,null,"     kolik sloupců použít",null,null,2]
[null,null,null,"  =POSUN($I$8;0;0;$G$10;$G$18)"]
[null,null,null,{"$f":"CONCATENATE(\"Součet \",G10,\" řádků a \",G18,\" sloupců =\")","v":"Součet 2 řádků a 2 sloupců ="},null,{"$f":"SUM(OFFSET($I$8,0,0,$G$10,$G$18))","v":15}]
[null,null,null,{"$f":"CONCATENATE(\"Průměr \",G10,\" řádků a \",G18,\" sloupců =\")","v":"Průměr 2 řádků a 2 sloupců ="},null,{"$f":"AVERAGE(OFFSET($I$8,0,0,$G$10,$G$18))","v":3.75}]
[null,null,null,"7. oblast je také možné odsunout od levého horního bodu"]
[null,null,null,"8. použijí se k tomu parametry [řádky], [sloupce] z funkce POSUN(…)"]
[null,null,null,"     posun shora",null,1,{"$f":"F24-1","v":0}]
[null,null,null,"     posun vpravo",null,1,{"$f":"F25-1","v":0}]
[null,null,null,{"$f":"CONCATENATE(\"Součet oblasti \",G10,\"x\",G18)","v":"Součet oblasti 2x2"},null,{"$f":"SUM(OFFSET($I$8,$G$24,$G$25,$G$10,$G$18))","v":15}]

{"sheet":"Tip26","index":29,"n_rows":47,"n_cols":27,"rows_kept":47,"cut":false,"hidden":false,"merged":[[5,8,6,8],[5,9,6,9]]}
["←",null,"Funkce SUMIFS … chytrý součet"]
[]
[]
[]
[null,null,"Co chci?","Filtrace hodnot podle různých kritérií"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID","Příjmení","Jméno","PSČ","Město","Prodej","Kusy","Oblast","Kraj","Vzdělání","Rok naroz.","Automobil","Bydlení"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Krajíček","Vojtěch",63500,"Brno",346000,4200,"Morava","Jihomoravský","střední škola",1985,"škoda","RD"]
[null,null,"Postup","1. vytvořit zpracovávaná data",null,null,null,null,null,null,null,null,null,null,2,"Novák","Miloslav",27309,"Kladno",288000,4450,"Čechy","Středočeský","základní škola",1990,"toyota","byt"]
[null,null,null,"2. získat unikátní hodnoty pro kritéria (nesmí se opakovat)",null,null,null,null,null,null,null,null,null,null,3,"Bartoňová","Magdaléna",25301,"Hostivice",281000,3920,"Čechy","Středočeský","vysoká škola",1994,"audi","nájem"]
[null,null,null,"3. vložit ovládací prvky: comboboxy",null,null,null,null,null,null,null,null,null,null,4,"Modrá","Anna",27735,"Mšeno",361000,3720,"Čechy","Středočeský","vysoká škola",1982,"toyota","byt"]
[null,null,null,"4. napojit ovládací prvky na data",null,null,null,null,null,"*",2,{"$f":"INDEX(J11:J13,K11)","v":"Morava"},null,null,5,"Zelený","Lukáš",58601,"Jihlava",360000,3710,"Morava","Vysočina","střední škola",2000,"škoda","RD"]
[null,null,null,"5. dohledat hodnoty kritérií podle indexů z ovladacích prvků",null,null,null,null,null,"Morava",null,null,null,null,6,"Čermák","Tomáš",77900,"Olomouc",372000,3250,"Morava","Olomoucký","základní škola",1985,"toyota","RD"]
[null,null,null,"6. napojit =SUMIFS(…) na kritéria",null,null,null,null,null,"Čechy",null,null,null,null,7,"Kovář","Matěj",30100,"Plzeň",362000,3480,"Čechy","Plzeňský","vysoká škola",1982,"audi","nájem"]
[null,null,null,"7. pro filtrování regionů",null,null,null,null,null,null,null,null,null,null,8,"Dvořák","Jan",37007,"České Budějovice",330000,5090,"Čechy","Jihočeský","střední škola",1992,"škoda","nájem"]
[null,null,null,null," =SUMIFS(T7:T47;V7:V47;\"Morava\")",null,null,null,null,"*",17,{"$f":"INDEX(J15:J34,K15)","v":"Ostrava"},null,null,9,"Burešová","Eliška",43004,"Chomutov",207000,5360,"Čechy","Ústecký","vysoká škola",1983,"volkswagen","nájem"]
[null,null,null,null," =SUMIFS(T7:T47;V7:V47;L11)",null,null,null,null,"Brno",null,null,null,null,10,"Bílá","Michaela",51101,"Turnov",211000,4610,"Čechy","Liberecký","střední škola",1998,"škoda","nájem"]
[null,null,null,null,null,null,null,null,null,"Kladno",null,null,null,null,11,"Modrý","Ladislav",25244,"Psáry",273000,3270,"Čechy","Středočeský","základní škola",1987,"toyota","byt"]
[null,null,null,"Prodeje:",null,null,null,null,null,"Hostivice",null,null,null,null,12,"Cvach","Jaroslav",14000,"Praha 4",258000,4070,"Čechy","Praha","vysoká škola",1982,"volkswagen","nájem"]
[null,null,null,"Region",null,{"$f":"SUMIFS(T7:T47,V7:V47,L11)","v":3618000},null,null,null,"Mšeno",null,null,null,null,13,"Štrosmajer","Jakub",77900,"Olomouc",338000,5180,"Morava","Olomoucký","střední škola",1986,"škoda","RD"]
[null,null,null,"Region+Město",null,{"$f":"SUMIFS($T$7:$T$47,$V$7:$V$47,$L$11,$S$7:$S$47,$L$15)","v":214000},null,null,null,"Jihlava",null,null,null,null,14,"Mašek","Hana",25601,"Benešov",267000,3240,"Čechy","Středočeský","základní škola",1989,"audi","byt"]
[null,null,null,"Region+Město+Typ bydlení",null,{"$f":"SUMIFS($T$7:$T$47,$V$7:$V$47,$L$11,$S$7:$S$47,$L$15,$AA$7:$AA$47,$L$36)","v":214000},null,null,null,"Olomouc",null,null,null,null,15,"Čáp","Ondřej",39002,"Tábor",224000,3320,"Čechy","Jihočeský","gymnázium",1982,"mercedes","RD"]
[null,null,null,"Region+Město+Typ bydlení+Auto",null,{"$f":"SUMIFS($T$7:$T$47,$V$7:$V$47,$L$11,$S$7:$S$47,$L$15,$AA$7:$AA$47,$L$36,Z7:Z47,$L$41)","v":214000},null,null,null,"Plzeň",null,null,null,null,16,"Knápková","Helena",30100,"Plzeň",274000,4510,"Čechy","Plzeňský","střední škola",1981,"volkswagen","RD"]
[null,null,null,null,null,null,null,null,null,"České Budějovice",null,null,null,null,17,"Knap","Martin",18000,"Praha 8",233000,5710,"Čechy","Praha","základní škola",1980,"škoda","byt"]
[null,null,null,"8. možné použít i ovládací prvek: seznam",null,null,null,null,null,"Chomutov",null,null,null,null,18,"Kozlová","Aneta",70800,"Ostrava",214000,5310,"Morava","Moravskoslezský","základní škola",1991,"mercedes","RD"]
[null,null,null,"9. prvky jsou napojeny na stejná data",null,null,null,null,null,"Turnov",null,null,null,null,19,"Kajman","Petr",25301,"Hostivice",279000,5700,"Čechy","Středočeský","střední škola",1993,"volkswagen","RD"]
[null,null,null,null,null,null,null,null,null,"Psáry",null,null,null,null,20,"Papoušková","Lucia",25244,"Psáry",313000,4750,"Čechy","Středočeský","gymnázium",1990,"mercedes","RD"]
[null,null,null,null,null,null,null,null,null,"Praha 4",null,null,null,null,21,"Žulová","Veronika",53353,"Pardubice",278000,5380,"Čechy","Pardubický","základní škola",1992,"škoda","RD"]
[null,null,null,null,null,null,null,null,null,"Benešov",null,null,null,null,22,"Syrový","Ondřej",51101,"Turnov",310000,5680,"Čechy","Liberecký","vysoká škola",1989,"volkswagen","nájem"]
[null,null,null,null,null,null,null,null,null,"Tábor",null,null,null,null,23,"Smrž","Dušan",43004,"Chomutov",344000,3390,"Čechy","Ústecký","střední škola",1995,"toyota","nájem"]
[null,null,null,null,null,null,null,null,null,"Praha 8",null,null,null,null,24,"Hřib","Jakub",58601,"Jihlava",287000,5380,"Morava","Vysočina","základní škola",1980,"škoda","RD"]
[null,null,null,null,null,null,null,null,null,"Ostrava",null,null,null,null,25,"Pekař","Lukáš",43004,"Chomutov",307000,4790,"Čechy","Ústecký","vysoká škola",1992,"mercedes","RD"]
[null,null,null,null,null,null,null,null,null,"Pardubice",null,null,null,null,26,"Polej","Jan",53353,"Pardubice",215000,4860,"Čechy","Pardubický","střední škola",1983,"volkswagen","byt"]
[null,null,null,null,null,null,null,null,null,"Znojmo",null,null,null,null,27,"Vysoký","Bohdan",30100,"Plzeň",313000,5970,"Čechy","Plzeňský","gymnázium",1981,"škoda","nájem"]
[null,null,null,null,null,null,null,null,null,"Mikulov",null,null,null,null,28,"Požárník","Matyáš",67128,"Znojmo",297000,5500,"Morava","Vysočina","základní škola",1996,"toyota","RD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"Celníková","Volha",25601,"Benešov",317000,3540,"Čechy","Středočeský","střední škola",1989,"mercedes","RD"]
[null,null,null,null,null,null,null,null,null,"*",2,{"$f":"INDEX(J36:J39,K36)","v":"RD"},null,null,30,"Šimek","David",58601,"Jihlava",221000,4660,"Morava","Vysočina","základní škola",1988,"volkswagen","nájem"]
[null,null,null,null,null,null,null,null,null,"RD",null,null,null,null,31,"Skřehotal","Miroslav",69201,"Mikulov",215000,3740,"Morava","Jihomoravský","gymnázium",1999,"škoda","RD"]
[null,null,null,null,null,null,null,null,null,"byt",null,null,null,null,32,"Jelen","Josef",53353,"Pardubice",215000,3730,"Čechy","Pardubický","gymnázium",1981,"mercedes","RD"]
[null,null,null,null,null,null,null,null,null,"nájem",null,null,null,null,33,"Sytá","Veronika",61200,"Brno",224000,5220,"Čechy","Jihomoravský","základní škola",1984,"volkswagen","nájem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"Sojka","Jan",67128,"Znojmo",341000,5240,"Morava","Vysočina","gymnázium",1991,"škoda","RD"]
[null,null,null,null,null,null,null,null,null,"*",6,{"$f":"INDEX(J41:J46,K41)","v":"mercedes"},null,null,35,"Tranovský","Patrik",25601,"Benešov",245000,4800,"Čechy","Středočeský","střední škola",1998,"volkswagen","byt"]
[null,null,null,null,null,null,null,null,null,"škoda",null,null,null,null,36,"Vančura","David",25244,"Psáry",324000,4930,"Čechy","Středočeský","gymnázium",1996,"audi","nájem"]
[null,null,null,null,null,null,null,null,null,"toyota",null,null,null,null,37,"Dřevitá","Kateřina",51101,"Turnov",201000,4750,"Čechy","Liberecký","základní škola",1984,"toyota","byt"]
[null,null,null,null,null,null,null,null,null,"audi",null,null,null,null,38,"Říhal","Tomáš",69201,"Mikulov",314000,5780,"Morava","Jihomoravský","gymnázium",1994,"volkswagen","nájem"]
[null,null,null,null,null,null,null,null,null,"volkswagen",null,null,null,null,39,"Gott","Matěj",67128,"Znojmo",313000,4750,"Morava","Jihomoravský","gymnázium",1985,"mercedes","nájem"]
[null,null,null,null,null,null,null,null,null,"mercedes",null,null,null,null,40,"Pondělní","Lucie",53353,"Pardubice",330000,4950,"Čechy","Pardubický","základní škola",1989,"volkswagen","byt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"Teplá","Nikol",25601,"Benešov",283000,4370,"Čechy","Středočeský","střední škola",1983,"škoda","RD"]

{"sheet":"Tip27","index":30,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,8,6,8],[5,9,6,9]]}
["←",null,"Paste jako transformace se vzorci"]
[]
[]
[]
[null,null,"Co chci?","Převést vodorovný kopírovaný řádek na svislý"]
[null,null,null,"Včetně zachování odkazů na původní buňky"]
[]
[null,null,"Postup","1. vybrat vodorovný řádek jako oblast ke kopírování"]
[null,null,null,"2. stisknout tlačítko Transformace…"]
[null,null,null,"3. zadat řádek a sloupec pro výsledné umístění nové oblasti"]
[null,null,null,"4. vodorovná oblast se převede na svislou"]
[null,null,null,"5. ve svislé pblasti jsou odkazy na původní buňky"]
[null,null,null,"6. pozor na přepsání dat! Operace nemá Undo!!!"]
[]
[null,null,null,null,null,1.1000000000000001,3.7,0.6,0,1.6,0.3,2.1]
[null,null,null,null,2,{"$f":"RAND()*(F15*(1+$E$16)-F15*(1-$E$16))+F15 *(1-$E$16)","v":1.4244442432997668},5.9061990732883372,0.98042260719356833,0,-1.241661361328577,0.16231230165576854,-0.94049579957834983]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"$H$15","v":0.6}]

{"sheet":"Tip28","index":31,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["¬",null,"Nepřímý odkaz (Indirect)"]
[]
[]
[null,"Co chci?","Použití, když se odkaz mění."]
[null,null,"Použití, když odkaz není dopředu znamý"]
[]
[]
[]
[null,"Postup:","1. Pomocí ověření dat získat název listu",null,null,null,null,null,"Led",null,"Led"]
[null,null,"2. Z názvu sestavit odkaz na list a buňku",null,null,null,null,null,{"$f":"I9&\"!D8\"","v":"Led!D8"},null,"Uno"]
[null,null,"3. Odkaz použít jako argument",null," =NEPŘÍMÝ.ODKAZ(I10)",null,null,null,{"$f":"INDIRECT(I10)","v":1100},null,"Bre"]
[]
[]
[null,"Co chci?","Kopírovat vzorec přes listy"]
[null,"Postup:","1. Tradičním postupem vzorec",null," =Led!D8"]
[null,null,"2. …vznikne toto:",null," =Led!D8"]
[null,null,null,null," =Led!D9"]
[null,null,null,null," =Led!D10"]
[null,null,"3. Pokud potřebuji měnit jména listů použiji"]
[null,null,null,null," =NEPŘÍMÝ.ODKAZ(K9&\"!D8\")",null,null,{"$f":"INDIRECT(K9&\"!D8\")","v":1100}]
[null,null,null,null," =NEPŘÍMÝ.ODKAZ(K10&\"!D8\")",null,null,{"$f":"INDIRECT(K10&\"!D8\")","v":910}]
[null,null,null,null," =NEPŘÍMÝ.ODKAZ(K11&\"!D8\")",null,null,{"$f":"INDIRECT(K11&\"!D8\")","v":1370}]
[]
[]
[null,"Co chci?","Součet proměnné oblasti v tabulce"]
[null,"Postup:","1. Pomocí ověření dat získat název Měsíce a Jména"]
[null,null,null,"Měsíc:","Bre",{"$f":"MATCH(E27,I30:K30,)","v":3}]
[null,null,null,"Jméno:","Beta",{"$f":"MATCH(E28,H31:H34,0)","v":2}]
[null,null,"2. Sestaví se odkaz na oblast jako R1C1"]
[null,null,null,null,{"$f":"\"R31C9:\"&\"R\"&30+F28&\"C\"&8+F27","v":"R31C9:R32C11"},null,null,null,"Led","Uno","Bre"]
[null,null,"3. Odkaz použít jako argument",null,null,null,null,"Alfa",7,5,2]
[null,null,null," =SUMA(NEPŘÍMÝ.ODKAZ(E30;NEPRAVDA))",null,null,null,"Beta",8,4,4]
[null,null,null,{"$f":"\"Suma: Alfa-\"&E28&\";Led-\"&E27","v":"Suma: Alfa-Beta;Led-Bre"},{"$f":"SUM(INDIRECT(E30,FALSE))","v":30},null,null,"Gama",9,3,6]
[null,null,null,null,null,null,null,"Delta",6,4,8]
[]
[null,"Co chci?","Hledání v tabulce"]
[null,"Postup:","1. Pomocí ověření dat získat Prodejce z TabProd1"]
[null,null,"2. V ověření dat je vzorec"]
[null,null,null," =NEPŘÍMÝ.ODKAZ(\"TabProd1[Prodejce]\")",null,null,null,"ID","Prodejce","Jméno","PSČ","Sídlo","Prodaný objem Kč"]
[null,null,"3. Pro hledání se použije =SVYHLEDAT",null,null,null,null,1," Ašenbrener","Vojtěch",63500,"Brno",346000]
[null,null,"4. Prohledávájí se sloupce:",null,"[Prodejce]:[Prodaný objem Kč]",null,null,2," Barták","Miloslav",27309,"Kladno",288000]
[null,null,"5. Hledá se ve sloupečku 3",null,null,null,null,3," Bartáková","Magdaléna",25301,"Hostivice",281000]
[null,null,null,"Jmeno prodejce"," Ašenbrener"]
[null,null,null,"Dohledané PSČ:",{"$f":"VLOOKUP(E43,TabProd1[[Prodejce]:[Prodaný objem Kč]],3,FALSE)","v":63500}]
[null,null,"6. Případně prohledat zvolený sloupec:"]
[null,null,null,null,"Jméno",{"$f":"MATCH(E46,TabProd1[[#Headers],[Prodejce]:[Prodaný objem Kč]],0)","v":2}]
[null,null,null,null,{"$f":"VLOOKUP(E43,TabProd1[[Prodejce]:[Prodaný objem Kč]],F46,FALSE)","v":"Vojtěch"}]
[null,null,"7. Výsledek zformátovat jako:"]
[null,null,null,{"$f":"\"Prodejce\" & E43 & \" má \" & E46 & \" : \" &E47","v":"Prodejce Ašenbrener má Jméno : Vojtěch"}]
[null,null,"8. Přidáním nového Prodejce (řádku) se aktualizuje Ověření dat (bod 2)"]

{"sheet":"Tip29","index":32,"n_rows":116,"n_cols":10,"rows_kept":116,"cut":false,"hidden":false,"merged":[[75,5,75,9]]}
["¬",null,"Porovnání odkazů Inquire + xlCompare"]
[]
[]
[null,"Co chci?","Porovnat rozdíly dvou souborů XLS"]
[null,null,"Funguje pouze v MS Excel Proffesional Plus a Office 365"]
[]
[]
[]
[null,"Postup:","1. Doplně lze zapnout dodatečně"]
[null,null,"2. Příkaz Soubor/Možnost/Doplňky"]
[null,null,"3. Zvolit Doplňky modelu COM"]
[null,null,"4. Stisknout Přejít"]
[null,null,"5. Vybrat Inquire ze seznamu"]
[]
[]
[]
[]
[]
[null,null,"6. Pracovní lišta doplňku"]
[]
[]
[]
[]
[null,null,"7. Musí být otevřeny dva soubory"]
[null,null,"8. Pomocí Compare Files se zobrazí rozdíly"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"9. Dohledává vazby mezi soubory"]
[null,null,null,"Workbook Relationship"]
[null,null,"10. Dohledává vazby v rámci sešitu"]
[null,null,null,"Worksheet Relationship"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"11. Dohledává vazby buňky"]
[null,null,null,"Cell Relationship"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"12. Výsledek porovnání jak report:"]
[null,null,null,null,null,"Differences"]
[null,null,null,null,null,"Sheet","Range","Old Value","New Value","Description"]
[null,null,null,null,null,"List2","","","","Deleted Sheet From Position 2."]
[null,null,null,null,null,"List1","","","","Deleted Rows 6:7."]
[null,null,null,null,null,"List1","","","","Added Row 2."]
[null,null,null,null,null,"List1","C7","='C:\\Users\\dlaskpet\\Documents\\[New.xlsx]List1'!$C$7","='C:\\Users\\dlaskpet\\Documents\\[Old.xlsx]List1'!$E$18","Formula Changed."]
[null,null,null,null,null,"List1","A1","111","222","Entered Value Changed."]
[null,null,null,null,null,"List1","A2","","333","Entered Value Added."]
[null,null,null,null,null,"<Workbook>","","C:\\Users\\dlaskpet\\Documents\\New.xlsx","C:\\Users\\dlaskpet\\Documents\\Old.xlsx","External Link Changed."]
[]
[]
[]
[]
[null,"Co chci:","Porovnání pomocí xlCompare trial version"]
[null,"Postup:","1.  xlCompare možno stáhnout zde:"]
[null,null,null," https://spreadsheettools.com/spreadsheet-compare.html"]
[null,null,"2. Otevřít dva soubory k porovnání"]
[null,null,"3. Stisknout Compare Files"]
[null,null,"4. Aplikace umí předávat změněné řádky"]
[null,null,"5. Je možné"]
[null,null,"   - slučovat dokumenty"]
[null,null,"   - porovnávat VBA projekty"]
[null,null,"   - porovnávat Tabulky"]
[null,null,"   - porovnávat pojmenované oblasti"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"6. Je možné sestavovat reporty"]

{"sheet":"HiddenTemplate","index":33,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Odkaz na jiný list"]
[null,null,null,{"$f":"'Tip15'!D4","v":"New1"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Back to Tip15"]