Rozpis týdenní pracovní doby 1. 10. 2014 do 28. 2. 2015 - Podzimní semestr 2014 jméno: Luděk Benada Pondělí Úterý Středa Čtvrtek Pátek Sobota Neděle 8:00-12:00 (12:00-12:30-prestavka)/12:30-16:30 8:00-12:00 (12:00-12:30-prestavka)/12:30-16:30 8:00-12:00 (12:00-12:30-prestavka)/12:30-16:30 10:00-14:00 (14:00-14:30-prestavka)/14:30-18:30 7:00-11:00 12:50-16:15 Počet hodin v rozpisu pracovní doby musí odpovídat úvazku na katedře "a musí v něm být počítáno s 0,5 hod. přestávkou po 6 hodinách pracovní doby. " Dle tohoto rozpisu se musí každý zapisovat do knihy docházky. "Pokud se do knihy docházky zapíše jinak, musí být v knize vysvětlení proč." ##### Sheet/List 2 ##### 120000 0.05 12 8 splatka anuita urok umor dluh 0 120000 1 1519.190401 500 1019.190401 118980.8096 1.004166667 2 1519.190401 495.7533733 1023.437028 117957.3726 120000 0.991506747 3 1519.190401 491.4890524 1027.701349 116929.6712 0.991398302 0.999890626 0.991506747 4.246626673 1.004166667 1019.190401 1.004166667 4 1519.190401 487.2069634 1031.983438 115897.6878 0.991287519 0.999888256 0.991398302 4.264320951 1.004166667 1023.437028 1.004166667 5 1519.190401 482.9070324 1036.283369 114861.4044 0.991174324 0.99988581 0.991287519 4.282088954 1.004166667 1027.701349 1.004166667 6 1519.190401 478.5891851 1040.601216 113820.8032 0.991058636 0.999883283 0.991174324 4.299930992 1.004166667 1031.983438 1.004166667 7 1519.190401 474.2533467 1044.937055 112775.8661 0.990940375 0.999880672 0.991058636 4.317847371 1.004166667 1036.283369 1.004166667 8 1519.190401 469.8994423 1049.290959 111726.5752 0.990819455 0.999877974 0.990940375 4.335838402 1.004166667 1040.601216 1.004166667 9 1519.190401 465.5273966 1053.663005 110672.9122 0.990695785 0.999875184 0.990819455 4.353904395 1.004166667 1044.937055 1.004166667 10 1519.190401 461.1371341 1058.053267 109614.8589 0.990569271 0.999872299 0.990695785 4.372045663 1.004166667 1049.290959 1.004166667 11 1519.190401 456.7285788 1062.461823 108552.3971 0.990439817 0.999869313 0.990569271 4.39026252 1.004166667 1053.663005 1.004166667 12 1519.190401 452.3016545 1066.888747 107485.5083 0.990307319 0.999866223 0.990439817 4.408555281 1.004166667 1058.053267 1.004166667 13 1519.190401 447.8562848 1071.334117 106414.1742 0.99017167 0.999863023 0.990307319 4.426924261 1.004166667 1062.461823 1.004166667 14 1519.190401 443.3923926 1075.798009 105338.3762 0.990032758 0.999859708 0.99017167 4.445369779 1.004166667 1066.888747 1.004166667 15 1519.190401 438.9099009 1080.280501 104258.0957 0.989890463 0.999856273 0.990032758 4.463892153 1.004166667 1071.334117 1.004166667 16 1519.190401 434.4087321 1084.781669 103173.314 0.989744663 0.999852711 0.989890463 4.482491704 1.004166667 1075.798009 17 1519.190401 429.8888085 1089.301593 102084.0125 0.989595228 0.999849017 0.989744663 4.501168752 0 18 1519.190401 425.3500519 1093.84035 100990.1721 19 1519.190401 420.7923838 1098.398018 99891.77409 20 1519.190401 416.2157254 1102.974676 98788.79941 21 1519.190401 411.6199975 1107.570404 97681.22901 22 1519.190401 407.0051209 1112.185281 96569.04373 23 1519.190401 402.3710155 1116.819386 95452.22434 24 1519.190401 397.7176014 1121.4728 94330.75154 25 1519.190401 393.0447981 1126.145603 93204.60594 26 1519.190401 388.3525247 1130.837877 92073.76806 27 1519.190401 383.6407002 1135.549701 90938.21836 28 1519.190401 378.9092432 1140.281158 89797.9372 29 1519.190401 374.1580717 1145.03233 88652.90487 30 1519.190401 369.3871036 1149.803298 87503.10157 31 1519.190401 364.5962566 1154.594145 86348.50743 32 1519.190401 359.7854476 1159.404954 85189.10247 33 1519.190401 354.9545936 1164.235808 84024.86667 34 1519.190401 350.1036111 1169.08679 82855.77988 35 1519.190401 345.2324161 1173.957985 81681.82189 36 1519.190401 340.3409245 1178.849477 80502.97241 37 1519.190401 335.4290517 1183.76135 79319.21106 38 1519.190401 330.4967128 1188.693689 78130.51738 39 1519.190401 325.5438224 1193.646579 76936.8708 40 1519.190401 320.570295 1198.620106 75738.25069 41 1519.190401 315.5760445 1203.614357 74534.63633 42 1519.190401 310.5609847 1208.629417 73326.00692 43 1519.190401 305.5250288 1213.665373 72112.34154 44 1519.190401 300.4680898 1218.722312 70893.61923 45 1519.190401 295.3900801 1223.800321 69669.81891 46 1519.190401 290.2909121 1228.899489 68440.91942 47 1519.190401 285.1704976 1234.019904 67206.89952 48 1519.190401 280.028748 1239.161653 65967.73786 49 1519.190401 274.8655744 1244.324827 64723.41304 50 1519.190401 269.6808877 1249.509514 63473.90352 51 1519.190401 264.474598 1254.715803 62219.18772 52 1519.190401 259.2466155 1259.943786 60959.24393 53 1519.190401 253.9968497 1265.193552 59694.05038 54 1519.190401 248.7252099 1270.465192 58423.58519 55 1519.190401 243.431605 1275.758796 57147.82639 56 1519.190401 238.1159433 1281.074458 55866.75194 96 57 1519.190401 232.7781331 1286.412268 54580.33967 58 1519.190401 227.4180819 1291.77232 53288.56735 59 1519.190401 222.0356973 1297.154704 51991.41264 60 1519.190401 216.630886 1302.559515 50688.85313 61 1519.190401 211.2035547 1307.986847 49380.86628 62 1519.190401 205.7536095 1313.436792 48067.42949 63 1519.190401 200.2809562 1318.909445 46748.52004 64 1519.190401 194.7855002 1324.404901 45424.11514 65 1519.190401 189.2671464 1329.923255 44094.19189 66 1519.190401 183.7257995 1335.464602 42758.72729 67 1519.190401 178.1613637 1341.029038 41417.69825 68 1519.190401 172.5737427 1346.616659 40071.08159 69 1519.190401 166.96284 1352.227561 38718.85403 70 1519.190401 161.3285584 1357.861843 37360.99218 71 1519.190401 155.6708008 1363.519601 35997.47258 72 1519.190401 149.9894691 1369.200932 34628.27165 73 1519.190401 144.2844652 1374.905936 33253.36572 74 1519.190401 138.5556905 1380.634711 31872.731 75 1519.190401 132.8030459 1386.387356 30486.34365 76 1519.190401 127.0264319 1392.16397 29094.17968 77 1519.190401 121.2257487 1397.964653 27696.21503 78 1519.190401 115.4008959 1403.789506 26292.42552 79 1519.190401 109.551773 1409.638628 24882.78689 80 1519.190401 103.6782787 1415.512123 23467.27477 81 1519.190401 97.78031154 1421.41009 22045.86468 82 1519.190401 91.8577695 1427.332632 20618.53205 83 1519.190401 85.9105502 1433.279851 19185.2522 84 1519.190401 79.93855082 1439.251851 17746.00035 85 1519.190401 73.94166811 1445.248733 16300.75161 86 1519.190401 67.91979839 1451.270603 14849.48101 87 1519.190401 61.87283754 1457.317564 13392.16345 88 1519.190401 55.80068102 1463.38972 11928.77373 89 1519.190401 49.70322386 1469.487178 10459.28655 90 1519.190401 43.58036062 1475.610041 8983.676507 91 1519.190401 37.43198545 1481.758416 7501.918091 92 1519.190401 31.25799205 1487.932409 6013.985682 93 1519.190401 25.05827367 1494.132128 4519.853554 94 1519.190401 18.83272314 1500.357678 3019.495875 95 1519.190401 12.58123281 1506.609169 1512.886707 96 1519.190401 6.303694612 1512.886707 5.41604E-10 145842.2785 25842.27854 120000 6202146.85 145842.2785 ##### Sheet/List 3 ##### a= anuita urok umor dluh 2.293E+138 14583.33333 0 2500000 1 49502.99635 14583.33333 34919.66302 2465080.337 0.294594962 2 49502.99635 14379.6353 35123.36105 2429956.976 3 49502.99635 14174.74903 35328.24732 2394628.729 49502.99635 4 49502.99635 13968.66758 35534.32877 2359094.4 5 49502.99635 13761.384 35741.61235 2323352.787 1480703.498 6 49502.99635 13552.89126 35950.10509 2287402.682 1.005833333 1.005833333 7 49502.99635 13343.18231 36159.81404 2251242.868 8 49502.99635 13132.25007 36370.74629 2214872.122 1480703.498 9 49502.99635 12920.08738 36582.90897 2178289.213 10 49502.99635 12706.68708 36796.30927 2141492.904 400410.3637 11 49502.99635 12492.04194 37010.95441 2104481.949 400410.3637 12 49502.99635 12276.1447 37226.85165 2067255.098 13 49502.99635 12058.98807 37444.00828 2029811.089 14 49502.99635 11840.56469 37662.43166 1992148.658 Ir+1 a*v^(n-r) 15 49502.99635 11620.86717 37882.12918 1954266.529 Mr+1 a*v^(n-r) 16 49502.99635 11399.88808 38103.10827 1916163.42 17 49502.99635 11177.61995 38325.3764 1877838.044 18 49502.99635 10954.05526 38548.94109 1839289.103 I40 5691.81318 5691.81318 19 49502.99635 10729.18643 38773.80992 1800515.293 M40 43811.18317 43811.18317 20 49502.99635 10503.00588 38999.99048 1761515.302 21 49502.99635 10275.50593 39227.49042 1722287.812 22 49502.99635 10046.6789 39456.31745 1682831.495 23 49502.99635 9816.517052 39686.4793 1643145.015 24 49502.99635 9585.012589 39917.98376 1603227.032 25 49502.99635 9352.157684 40150.83867 1563076.193 26 49502.99635 9117.944459 40385.05189 1522691.141 27 49502.99635 8882.364989 40620.63136 1482070.51 28 49502.99635 8645.411306 40857.58504 1441212.925 29 49502.99635 8407.075394 41095.92096 1400117.004 30 49502.99635 8167.349188 41335.64716 1358781.356 31 49502.99635 7926.224579 41576.77177 1317204.585 32 49502.99635 7683.693411 41819.30294 1275385.282 33 49502.99635 7439.747477 42063.24887 1233322.033 34 49502.99635 7194.378525 42308.61783 1191013.415 35 49502.99635 6947.578255 42555.4181 1148457.997 36 49502.99635 6699.338316 42803.65804 1105654.339 37 49502.99635 6449.65031 43053.34604 1062600.993 38 49502.99635 6198.505792 43304.49056 1019296.502 39 49502.99635 5945.896264 43557.10009 975739.4023 40 49502.99635 5691.81318 43811.18317 931928.2191 41 49502.99635 5436.247945 44066.74841 887861.4707 42 49502.99635 5179.191912 44323.80444 843537.6662 43 49502.99635 4920.636386 44582.35996 798955.3063 44 49502.99635 4660.57262 44842.42373 754112.8825 45 49502.99635 4398.991815 45104.00454 709008.878 46 49502.99635 4135.885122 45367.11123 663641.7668 47 49502.99635 3871.24364 45631.75271 618010.0141 48 49502.99635 3605.058415 45897.93794 572112.0761 49 49502.99635 3337.320444 46165.67591 525946.4002 50 49502.99635 3068.020668 46434.97568 479511.4245 51 49502.99635 2797.149976 46705.84637 432805.5782 52 49502.99635 2524.699206 46978.29714 385827.281 53 49502.99635 2250.659139 47252.33721 338574.9438 54 49502.99635 1975.020506 47527.97585 291046.968 55 49502.99635 1697.77398 47805.22237 243241.7456 56 49502.99635 1418.910183 48084.08617 195157.6594 57 49502.99635 1138.41968 48364.57667 146793.0828 58 49502.99635 856.2929827 48646.70337 98146.37938 59 49502.99635 572.5205464 48930.4758 49215.90358 60 49502.99635 287.0927709 49215.90358 0.00 470179.7811 ##### Sheet/List 4 ##### 3000000 0.06 8 96 anuita urok umor dluh 0 3000000 1 46250 15000 31250 2968750 2 46093.75 14843.75 31250 2937500 -156.25 -156.25 3 45937.5 14687.5 31250 2906250 -156.25 -156.25 4 45781.25 14531.25 31250 2875000 -156.25 -156.25 5 45625 14375 31250 2843750 -156.25 -156.25 6 45468.75 14218.75 31250 2812500 -156.25 -156.25 7 45312.5 14062.5 31250 2781250 -156.25 -156.25 8 45156.25 13906.25 31250 2750000 -156.25 -156.25 9 45000 13750 31250 2718750 10 44843.75 13593.75 31250 2687500 11 44687.5 13437.5 31250 2656250 a10 44843.75 13593.75 12 44531.25 13281.25 31250 2625000 13 44375 13125 31250 2593750 14 44218.75 12968.75 31250 2562500 15 44062.5 12812.5 31250 2531250 727500 16 43906.25 12656.25 31250 2500000 3727500 727500 17 43750 12500 31250 2468750 3727500 18 43593.75 12343.75 31250 2437500 19 43437.5 12187.5 31250 2406250 20 43281.25 12031.25 31250 2375000 21 43125 11875 31250 2343750 22 42968.75 11718.75 31250 2312500 23 42812.5 11562.5 31250 2281250 24 42656.25 11406.25 31250 2250000 25 42500 11250 31250 2218750 26 42343.75 11093.75 31250 2187500 27 42187.5 10937.5 31250 2156250 28 42031.25 10781.25 31250 2125000 29 41875 10625 31250 2093750 30 41718.75 10468.75 31250 2062500 31 41562.5 10312.5 31250 2031250 32 41406.25 10156.25 31250 2000000 33 41250 10000 31250 1968750 34 41093.75 9843.75 31250 1937500 35 40937.5 9687.5 31250 1906250 36 40781.25 9531.25 31250 1875000 37 40625 9375 31250 1843750 38 40468.75 9218.75 31250 1812500 39 40312.5 9062.5 31250 1781250 40 40156.25 8906.25 31250 1750000 41 40000 8750 31250 1718750 42 39843.75 8593.75 31250 1687500 43 39687.5 8437.5 31250 1656250 44 39531.25 8281.25 31250 1625000 45 39375 8125 31250 1593750 46 39218.75 7968.75 31250 1562500 47 39062.5 7812.5 31250 1531250 48 38906.25 7656.25 31250 1500000 49 38750 7500 31250 1468750 50 38593.75 7343.75 31250 1437500 51 38437.5 7187.5 31250 1406250 52 38281.25 7031.25 31250 1375000 53 38125 6875 31250 1343750 54 37968.75 6718.75 31250 1312500 55 37812.5 6562.5 31250 1281250 56 37656.25 6406.25 31250 1250000 57 37500 6250 31250 1218750 58 37343.75 6093.75 31250 1187500 59 37187.5 5937.5 31250 1156250 60 37031.25 5781.25 31250 1125000 61 36875 5625 31250 1093750 62 36718.75 5468.75 31250 1062500 63 36562.5 5312.5 31250 1031250 64 36406.25 5156.25 31250 1000000 65 36250 5000 31250 968750 66 36093.75 4843.75 31250 937500 67 35937.5 4687.5 31250 906250 68 35781.25 4531.25 31250 875000 69 35625 4375 31250 843750 70 35468.75 4218.75 31250 812500 71 35312.5 4062.5 31250 781250 72 35156.25 3906.25 31250 750000 73 35000 3750 31250 718750 74 34843.75 3593.75 31250 687500 75 34687.5 3437.5 31250 656250 76 34531.25 3281.25 31250 625000 77 34375 3125 31250 593750 78 34218.75 2968.75 31250 562500 79 34062.5 2812.5 31250 531250 80 33906.25 2656.25 31250 500000 81 33750 2500 31250 468750 82 33593.75 2343.75 31250 437500 83 33437.5 2187.5 31250 406250 84 33281.25 2031.25 31250 375000 85 33125 1875 31250 343750 86 32968.75 1718.75 31250 312500 87 32812.5 1562.5 31250 281250 88 32656.25 1406.25 31250 250000 89 32500 1250 31250 218750 90 32343.75 1093.75 31250 187500 91 32187.5 937.5 31250 156250 92 32031.25 781.25 31250 125000 93 31875 625 31250 93750 94 31718.75 468.75 31250 62500 95 31562.5 312.5 31250 31250 96 31406.25 156.25 31250 0 ##### Sheet/List 5 ##### 3000000 0.06 8 df 0.985148759 25.61914517 25.23866908 32 anuita urok umor dluh 0 3000000 M - GŘ 1 118865.2219 45225.375 73639.84686 2926360.153 1.015075125 "tj,(1+0,06/12)^3" 1.015075125 2 118865.2219 44115.2451 74749.97675 2851610.176 1.015075125 3 118865.2219 42988.37986 75876.842 2775733.334 1.015075125 4 118865.2219 41844.52698 77020.69488 2698712.64 1.015075125 5 118865.2219 40683.43038 78181.79148 2620530.848 1.015075125 6 118865.2219 39504.8301 79360.39176 2541170.456 1.015075125 7 118865.2219 38308.46227 80556.75958 2460613.697 1.015075125 8 118865.2219 37094.05905 81771.1628 2378842.534 1.015075125 9 118865.2219 35861.34855 83003.8733 2295838.661 1.015075125 10 118865.2219 34610.05479 84255.16707 2211583.494 1.015075125 11 118865.2219 33339.89761 85525.32425 2126058.169 1.015075125 12 118865.2219 32050.59266 86814.6292 2039243.54 1.015075125 13 118865.2219 30741.85127 88123.37059 1951120.169 1.015075125 14 118865.2219 29413.38045 89451.84141 1861668.328 1.015075125 15 118865.2219 28064.88275 90800.3391 1770867.989 1.015075125 16 118865.2219 26696.05629 92169.16557 1678698.823 1.015075125 17 118865.2219 25306.5946 93558.62726 1585140.196 1.015075125 18 118865.2219 23896.1866 94969.03526 1490171.161 1.015075125 19 118865.2219 22464.51652 96400.70534 1393770.456 1.015075125 20 118865.2219 21011.26384 97853.95802 1295916.498 1.015075125 21 118865.2219 19536.10319 99329.11867 1196587.379 1.015075125 22 118865.2219 18038.70431 100826.5175 1095760.861 1.015075125 23 118865.2219 16518.73195 102346.4899 993414.3714 1.015075125 24 118865.2219 14975.84583 103889.376 889524.9954 1.015075125 25 118865.2219 13409.7005 105455.5214 784069.474 1.015075125 26 118865.2219 11819.94533 107045.2765 677024.1975 1.015075125 27 118865.2219 10206.22441 108658.9975 568365.2 1.015075125 28 118865.2219 8568.176436 110297.0454 458068.1546 1.015075125 29 118865.2219 6905.434689 111959.7872 346108.3674 1.015075125 30 118865.2219 5217.626903 113647.595 232460.7725 1.015075125 31 118865.2219 3504.375203 115360.8467 117099.9258 1.015075125 32 118865.2219 1765.29602 117099.9258 0.00