{"text_format":"2","workbook":"xls","n_sheets":8,"sheets":["jednoduchuroceni","srovnanislozurocenigraf","smenka","Srovnaniurocenigraf","uroceni","jinepripisovani","splatkyuverugraf","uverslozity"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"srovnanislozurocenigraf","index":1,"reason":"not_a_worksheet"},{"sheet":"Srovnaniurocenigraf","index":3,"reason":"not_a_worksheet"},{"sheet":"splatkyuverugraf","index":6,"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":"jednoduchuroceni","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["2006-06-01","2009-12-31",null,150000]
["2007-01-01","2010-03-04"]
[214,63]
[]
[null,null,"1. období","2. období","3. období","Celkem úroky"]
[null,"Celkem s úroky bez daně",151407.12328767122,158791.56603974136,159230.09178924287]
[null,"Celkem úroky v období",1407.1232876712165,7384.442752070143,438.5257495015103,9230.09178924287]
[]
[null,"Celkem s úroky s daní",151196.05479452058,157449.12982404462,157818.7254800261]
[null,"Celkem úroky s daní",1196.0547945205763,6253.075029524043,369.5956559814804,7818.7254800261]

{"sheet":"smenka","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[null,null,"Úroková míra:",null,0.062]
[null,"Částka","Dní","Vyplaceno","Od","Do","Počet dní"]
["1. směnka",105000,73,103679.91666666667,"2009-10-12","2009-12-24",73]
["2. směnka",150000,24,149380,"2009-11-30","2009-12-24",24]
["3. směnka",85000,29,84575.47222222222,"2009-11-25","2009-12-24",29]
["Celkem",340000,null,337635.3888888889]

{"sheet":"uroceni","index":4,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,2,4,4],[4,5,4,7],[5,2,5,4],[5,5,5,7]],"flags":["formulas_cached_only"]}
["Srovnání úročení"]
[]
[]
[null,"Vloženo:",null,100000]
[null,null,"Jednoduché úročení",null,null,"Složené úročení"]
[null,null,"Úroková míra",null,null,"Úroková míra"]
[null,null,0.02,0.05,0.15,0.02,0.05,0.15]
[null,"1. období",102000,105000,114999.99999999999,102000,105000,114999.99999999999]
[null,"2. období",104000,110000.00000000001,130000,104040,110250,132249.99999999997]
[null,"3. období",106000,114999.99999999999,145000,106120.79999999999,115762.50000000001,152087.49999999994]
[null,"4. období",108000,120000,160000,108243.216,121550.625,174900.62499999994]
[null,"5. období",110000.00000000001,125000,175000,110408.08032000001,127628.15625000001,201135.71874999994]
[null,"6. období",112000.00000000001,130000,190000,112616.2419264,134009.5640625,231306.07656249992]
[null,"7. období",114000.00000000001,135000,204999.99999999997,114868.56676492798,140710.04226562503,266001.9880468748]
[null,"8. období",115999.99999999999,140000,220000.00000000003,117165.93810022656,147745.54437890626,305902.28625390603]
[null,"9. období",118000,145000,234999.99999999997,119509.25686223108,155132.82159785158,351787.62919199193]
[null,"10. období",120000,150000,250000,121899.4419994757,162889.46267774416,404555.77357079065]
[null,"11. období",122000,155000,265000,124337.4308394652,171033.93581163138,465239.13960640924]
[null,"12. období",124000,160000,280000,126824.17945625453,179585.63260221292,535025.0105473705]
[null,"13. období",126000,165000,295000,129360.66304537961,188564.9142323236,615278.7621294762]

{"sheet":"jinepripisovani","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Částka",10000]
["Celkem roků:",5]
["Úroková míra:",0.1]
["Období za rok","Ćástka celkem"]
[1,16105.100000000006,0.6105100000000006]
[2,16288.946267774416,0.6288946267774416]
[4,16386.164402903956,0.6386164402903957]
[6,16419.409670661793,0.6419409670661793]
[12,16453.089347785848,0.6453089347785848]
[52,16479.298210272318,0.6479298210272318]
[365,16486.083690727868,0.6486083690727869]
["∞",16487.212707001283,0.6487212707001283]

{"sheet":"uverslozity","index":7,"n_rows":84,"n_cols":9,"rows_kept":84,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Splátek za rok:",12,null,null,null,"Spoření"]
[null,"Půjčka:",100000,null,null,null,"Počet úložek za rok: ",null,12]
[null,"Úroková míra:",0.085,null,null,null,"Úroková míra:",null,2.0201812002888254e-08]
[null,"Období:",6,null,null,null,"Období:",null,6]
[null,"Splátka:",1777.8384615269842,null,null,null,"Úložka:",null,1777.8384615269842]
[]
["Celkem splaceno:",null,128004.36922994287,null,null,null,"Celkem naspořeno:",null,128004.3692181016]
["Navíc:",null,28004.369229942866]
["V procentech:",null,0.28004369229942866,null,0.042007389885138746]
[]
[]
["Číslo splátky","Splátka","Na úroky","Na dluh","Na splacení"]
[1,1777.8384615269842,708.3333333333334,1069.5051281936508,98930.49487180635]
[2,1777.8384615269842,700.7576720086284,1077.0807895183557,97853.414082288]
[3,1777.8384615269842,693.1283497495401,1084.7101117774441,96768.70397051056]
[4,1777.8384615269842,685.4449864577832,1092.393475069201,95676.31049544136]
[5,1777.8384615269842,677.7071993427097,1100.1312621842744,94576.17923325708]
[6,1777.8384615269842,669.9146029022377,1107.9238586247466,93468.25537463232]
[7,1777.8384615269842,662.0668089036457,1115.7716526233385,92352.48372200898]
[8,1777.8384615269842,654.1634263642303,1123.6750351627538,91228.80868684623]
[9,1777.8384615269842,646.2040615318275,1131.6343999951569,90097.17428685108]
[10,1777.8384615269842,638.1883178651952,1139.6501436617891,88957.5241431893]
[11,1777.8384615269842,630.1157960142575,1147.7226655127267,87809.80147767656]
[12,1777.8384615269842,621.986093800209,1155.8523677267754,86653.94910994978]
[13,1777.8384615269842,613.7988061954777,1164.0396553315065,85489.90945461828]
[14,1777.8384615269842,605.5535253035462,1172.284936223438,84317.62451839483]
[15,1777.8384615269842,597.2498403386302,1180.588621188354,83137.03589720649]
[16,1777.8384615269842,588.8873376052127,1188.9511239217716,81948.08477328472]
[17,1777.8384615269842,580.4656004774334,1197.372861049551,80750.71191223517]
[18,1777.8384615269842,571.9842093783325,1205.8542521486518,79544.85766008652]
[19,1777.8384615269842,563.4427417589462,1214.395719768038,78330.46194031848]
[20,1777.8384615269842,554.8407720772559,1222.9976894497283,77107.46425086875]
[21,1777.8384615269842,546.177871776987,1231.6605897499971,75875.80366111876]
[22,1777.8384615269842,537.4536092662579,1240.3848522607263,74635.41880885803]
[23,1777.8384615269842,528.6675498960777,1249.1709116309066,73386.24789722712]
[24,1777.8384615269842,519.8192559386922,1258.0192055882922,72128.22869163883]
[25,1777.8384615269842,510.9082865657751,1266.930174961209,70861.29851667762]
[26,1777.8384615269842,501.9341978264665,1275.9042637005177,69585.3942529771]
[27,1777.8384615269842,492.89654262525454,1284.9419189017297,68300.45233407537]
[28,1777.8384615269842,483.79487069970054,1294.0435908272837,67006.40874324809]
[29,1777.8384615269842,474.6287285980073,1303.209732928977,65703.1990103191]
[30,1777.8384615269842,465.39765965642704,1312.4408018705572,64390.75820844855]
[31,1777.8384615269842,456.1012039765106,1321.7372575504737,63069.02095089808]
[32,1777.8384615269842,446.73889840219476,1331.0995631247895,61737.92138777329]
[33,1777.8384615269842,437.3102764967275,1340.5281850302567,60397.393202743035]
[34,1777.8384615269842,427.81486851942987,1350.0235930075544,59047.36960973548]
[35,1777.8384615269842,418.252201402293,1359.5862601246913,57687.783349610785]
[36,1777.8384615269842,408.62179872640974,1369.2166628005746,56318.56668681021]
[37,1777.8384615269842,398.92318069823904,1378.9152808287452,54939.651405981465]
[38,1777.8384615269842,389.15586412570207,1388.6825974012822,53550.96880858018]
[39,1777.8384615269842,379.31936239410965,1398.5190991328745,52152.449709447304]
[40,1777.8384615269842,369.4131854419184,1408.425276085066,50744.02443336224]
[41,1777.8384615269842,359.4368397363159,1418.4016217906683,49325.62281157157]
[42,1777.8384615269842,349.389828248632,1428.4486332783522,47897.17417829322]
[43,1777.8384615269842,339.27165042957705,1438.5668110974073,46458.607367195815]
[44,1777.8384615269842,329.08180218430374,1448.7566593426805,45009.85070785313]
[45,1777.8384615269842,318.81977584729304,1459.0186856796913,43550.83202217344]
[46,1777.8384615269842,308.48506015706187,1469.3534013699223,42081.478620803515]
[47,1777.8384615269842,298.07714023069155,1479.7613212962926,40601.717299507225]
[48,1777.8384615269842,287.5954975381762,1490.242963988808,39111.47433551842]
[49,1777.8384615269842,277.0396098765888,1500.7988516503954,37610.67548386802]
[50,1777.8384615269842,266.4089513440652,1511.429510182919,36099.2459736851]
[51,1777.8384615269842,255.70299231360283,1522.1354692133814,34577.11050447172]
[52,1777.8384615269842,244.92119940667467,1532.9172621203095,33044.19324235141]
[53,1777.8384615269842,234.06303546665583,1543.7754260603283,31500.41781629108]
[54,1777.8384615269842,223.12795953206182,1554.7105019949224,29945.707314296156]
[55,1777.8384615269842,212.1154268095978,1565.7230347173863,28379.98427957877]
[56,1777.8384615269842,201.0248886470163,1576.813572879968,26803.170706698802]
[57,1777.8384615269842,189.85579250578317,1587.982669021201,25215.188037677603]
[58,1777.8384615269842,178.60758193354968,1599.2308795934346,23615.95715808417]
[59,1777.8384615269842,167.27969653642955,1610.5587649905547,22005.398393093616]
[60,1777.8384615269842,155.8715719510798,1621.9668895759044,20383.43150351771]
[61,1777.8384615269842,144.3826398165838,1633.4558217104004,18749.975681807307]
[62,1777.8384615269842,132.8123277461351,1645.0261337808492,17104.94954802646]
[63,1777.8384615269842,121.16005929852076,1656.6784022284635,15448.271145797997]
[64,1777.8384615269842,109.42525394940249,1668.4132075775817,13779.857938220415]
[65,1777.8384615269842,97.60732706239462,1680.2311344645896,12099.626803755826]
[66,1777.8384615269842,85.7056898599371,1692.132771667047,10407.494032088778]
[67,1777.8384615269842,73.71974939396218,1704.118712133022,8703.375319955756]
[68,1777.8384615269842,61.64890851635328,1716.189553010631,6987.185766945125]
[69,1777.8384615269842,49.49256584919464,1728.3458956777897,5258.839871267335]
[70,1777.8384615269842,37.250115754810295,1740.5883457721739,3518.2515254951613]
[71,1777.8384615269842,24.920948305590727,1752.9175132213936,1765.3340122737677]
[72,1777.8384615269842,12.504449253605856,1765.3340122733784,3.892637323588133e-10]