{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Graf1","Graf2","Graf3","Graf4","List1","1. typ","List3"],"not_rendered":{"charts":4,"images":5,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Graf1","index":0,"reason":"not_a_worksheet"},{"sheet":"Graf2","index":1,"reason":"not_a_worksheet"},{"sheet":"Graf3","index":2,"reason":"not_a_worksheet"},{"sheet":"Graf4","index":3,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"List1","index":4,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[0,0,null,0.2,20,null,-3,0.125,null,0.2,-0.6989700043360187]
[1,320,null,0.4,10,null,-2.5,0.17677669529663687,null,0.4,-0.3979400086720376]
[2,640,null,0.6,6.666666666666667,null,-2,0.25,null,0.6,-0.2218487496163564]
[3,960,null,0.8,5,null,-1.5,0.3535533905932738,null,0.8,-0.09691001300805639]
[4,1280,null,1,4,null,-1,0.5,null,1,0]
[5,1600,null,1.2,3.3333333333333335,null,-0.5,0.7071067811865475,null,1.2,0.07918124604762482]
[6,1920,null,1.4,2.857142857142857,null,0,1,null,1.4,0.146128035678238]
[7,2240,null,1.6,2.5,null,0.5,1.4142135623730951,null,1.6,0.2041199826559248]
[8,2560,null,1.8,2.2222222222222223,null,1,2,null,1.8,0.25527250510330607]
[9,2880,null,2,2,null,1.5,2.82842712474619,null,2,0.3010299956639812]
[10,3200,null,2.2,1.8181818181818181,null,2,4,null,2.2,0.3424226808222063]
[11,3520,null,2.4,1.6666666666666667,null,2.5,5.656854249492381,null,2.4,0.38021124171160603]
[12,3840,null,2.6,1.5384615384615383,null,3,8,null,2.6,0.414973347970818]
[13,4160,null,2.8,1.4285714285714286,null,3.5,11.31370849898476,null,2.8,0.4471580313422192]
[14,4480,null,3,1.3333333333333333,null,4,16,null,3,0.47712125471966244]
[15,4800,null,3.2,1.25,null,4.5,22.62741699796952,null,3.2,0.505149978319906]
[]
[]
[]
[]
["Období","Zkratka","Latinský název"]
["rok","p.a.","per annum"]
["pololetí","p.s.","per semestre"]
["čtvrtletí","p.q.","per quartale"]
["měsíc","p.m.","per mensem"]
["den","p.d.","per diem"]
[]
[]
[]
[null,200000,null,null,10100]
[null,0.09,240,null,10000]
[null,212000,null,null,0.010000000000000009,0.028800000000000023]

{"sheet":"1. typ","index":5,"n_rows":118,"n_cols":9,"rows_kept":118,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Klient uložil do banky vklad ve výši 100 000 Kč dne 3.5. 2009 a vybral jej i s úroky dne 15.12.2009."]
["Jak velký byl úrok při úrokové míře 3% p.a.?"]
[]
["Řešení:"]
["Použijeme základní vzorec"]
{"$rows_empty":9}
["Stanovení hodnoty k pro různé standardy:"]
[]
["Od ","Do","ACT/360","30E/360","ACT/365"]
["2009-05-03","2009-12-15",226,222,226]
[]
["Výpočet úroků:"]
["ACT/360",null,"u =100000.(3/100) . ( 226/360) =",null,null,1883.3333333333333]
[]
["30E/360",null,"u =100000.(3/100) . ( 222/360) =",null,null,1850]
[]
["ACT/365",null,"u =100000.(3/100) . ( 226/365) =",null,null,1857.5342465753424]
{"$rows_empty":14}
["Jak velká úroková míra půjčky musí být nastavena, abychom za půjčení 50 000 Kč na období od"]
["1.6. 2009 do 25.10. 2009 , zaplatili na úrocích nejvýše 2 000 Kč ?"]
[]
["Použijeme opět základní vzorec:"]
{"$rows_empty":9}
["Stanovení hodnoty k pro různé standardy:"]
[]
["Od ","Do","ACT/360","30E/360","ACT/365"]
["2009-06-01","2009-10-25",146,144,146]
[]
[]
["Výpočet úrokové míry ( v procentech ):"]
["ACT/360",null,"2000 =100000.(x/100) . ( 146/360) ",null,null,4.931506849315069]
[]
["30E/360",null,"2000 =100000.(x/100) . ( 144/360) ",null,null,5]
[]
["ACT/365",null,"2000 =100000.(x/100) . ( 146/365) ",null,null,5]
{"$rows_empty":15}
["Na jak velké období bychom museli uložit 250 000 Kč, abych při jednoduchém úročení získali úroky "]
["4 000 Kč při úrokové míře 2,5%. Vklad byl vložen 24.2.2010."]
[]
["Použijeme opět základní vzorec:"]
{"$rows_empty":10}
["Budeme muset nejdříve pro dané standardy zjistit počet dní a poté se dopočítat koncového dne."]
["Základní rovnice bude :"]
[]
[]
[]
[]
[{"$nulls":8},0.64]
[]
["Ta je nezávislá na standardech:"]
{"$rows_empty":9}
["Z této hodnoty odvodíme nyní číslo k:"]
[{"$nulls":5},"Datum vkladu","Datum výběru"]
["ACT/360",null,230.4,null,231,"2010-02-05","2010-09-27"]
[]
["30E/360",null,230.4,null,231,"2010-02-05","2010-09-26"]
[]
["ACT/365",null,233.6,null,234,"2010-02-05","2010-09-27"]

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