{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Řetězový zlomek po řádcích"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Řetězový zlomek po řádcích","index":0,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Aproximace čísla řetězovými zlomky"]
["Návod: Do oranžového políčka zadejte číslo, ve sloupcích B a G jsou koeficienty jeho vyjádření řetězovými zlomky, ve sloupcích D a I jsou postupné aproximace racionálním číslem."]
["Autor: Martin Žáček, zacekm@fel.cvut.cz, http://fyzika.feld.cvut.cz/~zacek/"]
["Řetězový zlomek se zaokrouhlováním dolů",null,null,null,null,"Řetězový zlomek se zaokrouhlováním na nejbližší celé číslo"]
["číslo/jmenovatel","celá část","necelá část","aproximace koneč-ným zlomkem","Relativní chyba","číslo/jmenovatel","celá část","necelá část","aproximace koneč-ným zlomkem","Relativní chyba"]
[{"$f":"EXP(1)","v":2.7182818284590451},{"$f":"INT(A6)","v":2},{"$f":"A6-B6","v":0.71828182845904509},{"$f":"B6","v":2},{"$f":"ABS(D6-$A$6)/$A$6","v":0.26424111765711533},{"$f":"A6","v":2.7182818284590451},{"$f":"ROUND(F6,0)","v":3},{"$f":"F6-G6","v":-0.28171817154095491},{"$f":"G6","v":3},{"$f":"ABS(I6-$A$6)/$A$6","v":0.10363832351432703}]
[{"$f":"IF(C6<>0,1/C6,1E+307)","v":1.3922111911773332},{"$f":"INT(A7)","v":1},{"$f":"A7-B7","v":0.39221119117733316},{"$f":"B6+1/B7","v":3},{"$f":"ABS(D7-$A$6)/$A$6","v":0.10363832351432703},{"$f":"IF(H6<>0,1/H6,1E+307)","v":-3.5496467783038432},{"$f":"ROUND(F7,0)","v":-4},{"$f":"F7-G7","v":0.45035322169615677},{"$f":"G6+1/G7","v":2.75},{"$f":"ABS(I7-$A$6)/$A$6","v":1.1668463221466438E-2}]
[{"$f":"IF(C7<>0,1/C7,1E+307)","v":2.5496467783038428},{"$f":"INT(A8)","v":2},{"$f":"A8-B8","v":0.54964677830384279},{"$f":"B6+1/(B7+1/B8)","v":2.6666666666666665},1.8988156876153812E-2,{"$f":"IF(H7<>0,1/H7,1E+307)","v":2.2204792856454296},2,{"$f":"F8-G8","v":0.22047928564542962},{"$f":"G6+1/(G7+1/G8)","v":2.7142857142857144},1.4700882489421701E-3]
[{"$f":"IF(C8<>0,1/C8,1E+307)","v":1.8193502435980868},1,0.81935024359808684,{"$f":"B6+1/(B7+1/(B8+1/B9))","v":2.75},1.1668463221466438E-2,{"$f":"IF(H8<>0,1/H8,1E+307)","v":4.5355734760869097},5,-0.46442652391309025,{"$f":"G6+1/(G7+1/(G8+1/G9))","v":2.7179487179487181},1.225445083874411E-4]
[1.2204792856454274,1,0.2204792856454274,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/B10)))","v":2.7142857142857144},1.4700882489421701E-3,-2.1531931285370201,-2,-0.15319312853702005,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/G10)))","v":2.7183098591549295},1.0311916737606293E-5]
[4.5355734760869559,4,0.53557347608695594,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/(B10+1/B11))))","v":2.71875},1.7223068485886504E-4,-6.5277079301787611,-7,0.47229206982123895,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/(G10+1/G11))))","v":2.7182835820895521},6.4512461094691231E-7]
[1.867157438987213,1,0.86715743898721298,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/(B10+1/(B11+1/B12)))))","v":2.7179487179487181},1.225445083874411E-4,2.117333878543624,2,0.11733387854362398,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/(G10+1/(G11+1/G12)))))","v":2.7182817182817183},4.0531973419387688E-8]
[1.1531931285372343,1,0.15319312853723432,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/(B10+1/(B11+1/(B12+1/B13))))))","v":2.7183098591549295},1.0311916737606293E-5,8.5226876705367438,9,-0.47731232946325619,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/(G10+1/(G11+1/(G12+1/G13))))))","v":2.7182818229439496},2.0288902473848644E-9]
[6.5277079301696306,6,0.52770793016963058,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/(B10+1/(B11+1/(B12+1/(B13+1/B14)))))))","v":2.7182795698924731},8.3088020835172212E-7,-2.0950642551482228,-2,-9.5064255148222809E-2,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/(G10+1/(G11+1/(G12+1/(G13+1/G14)))))))","v":2.7182818287356958},1.0177410577895965E-10]
[1.8949876301433488,1,0.89498763014334881,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/(B10+1/(B11+1/(B12+1/(B13+1/(B14+1/B15))))))))","v":2.7182835820895521},6.4512461094691231E-7,-10.519200917745733,-11,0.48079908225426671,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/(G10+1/(G11+1/(G12+1/(G13+1/(G14+1/G15))))))))","v":2.7182818284705839},4.2448762371616708E-12]
[1.1173338785026912,1,0.11733387850269117,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/(B10+1/(B11+1/(B12+1/(B13+1/(B14+1/(B15+1/B16)))))))))","v":2.7182817182817183},4.0531973419387688E-8,2.0798708585536736,2,7.9870858553673596E-2,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/(G10+1/(G11+1/(G12+1/(G13+1/(G14+1/(G15+1/G16)))))))))","v":2.7182818284585633},1.7725785002965063E-13]
[8.5226876735099495,8,0.52268767350994949,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/(B10+1/(B11+1/(B12+1/(B13+1/(B14+1/(B15+1/(B16+1/B17))))))))))","v":2.7182818352059925},2.48206325574583E-9,12.520210976923394,13,-0.47978902307660576,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/(G10+1/(G11+1/(G12+1/(G13+1/(G14+1/(G15+1/(G16+1/G17))))))))))","v":2.7182818284590278},6.3714803236464282E-15]
[1.9131884118957796,1,0.91318841189577959,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/(B10+1/(B11+1/(B12+1/(B13+1/(B14+1/(B15+1/(B16+1/(B17+1/B18)))))))))))","v":2.7182818229439496},2.0288902473848644E-9,-2.0842494344443026,-2,-8.4249434444302551E-2,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/(G10+1/(G11+1/(G12+1/(G13+1/(G14+1/(G15+1/(G16+1/(G17+1/G18)))))))))))","v":2.718281828459046},3.2674258069981684E-16]
[1.0950642681984974,1,9.5064268198497448E-2,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/(B10+1/(B11+1/(B12+1/(B13+1/(B14+1/(B15+1/(B16+1/(B17+1/(B18+1/B19))))))))))))","v":2.7182818287356958},1.0177410577895965E-10,-11.869515879790288,-12,0.13048412020971156,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/(G10+1/(G11+1/(G12+1/(G13+1/(G14+1/(G15+1/(G16+1/(G17+1/(G18+1/G19))))))))))))","v":2.7182818284590451},0]
[10.51919947368622,10,0.51919947368621955,{"$f":"B6+1/(B7+1/(B8+1/(B9+1/(B10+1/(B11+1/(B12+1/(B13+1/(B14+1/(B15+1/(B16+1/(B17+1/(B18+1/(B19+1/B20)))))))))))))","v":2.7182818284454013},5.0192561534202363E-12,7.6637678086254422,8,-0.33623219137455784,{"$f":"G6+1/(G7+1/(G8+1/(G9+1/(G10+1/(G11+1/(G12+1/(G13+1/(G14+1/(G15+1/(G16+1/(G17+1/(G18+1/(G19+1/G20)))))))))))))","v":2.7182818284590451},0]
[1.9260420140648185,1,{"$f":"A21-B21","v":0.92604201406481845},null,null,-2.9741352126691947,-3,{"$f":"F21-G21","v":2.5864787330805328E-2}]
[1.0798646117691209,1,7.9864611769120852E-2,null,null,38.662602835670171,39,-0.33739716432982902]
[12.521190272493676,12,0.52119027249367633,null,null,-2.9638660478557872,-3,3.6133952144212778E-2]
[1.9186850806240501,1,0.91868508062405008,null,null,27.674802800671785,28,-0.32519719932821545]
[1.0885122890215153,1,8.8512289021515311E-2,null,null,-3.0750572331673705,-3,-7.5057233167370452E-2]