мой тр попов (Типовой расчёт)
Описание файла
Excel-файл из архива "Типовой расчёт", который расположен в категории "". Всё это находится в предмете "физика и технология некристаллических полупроводников" из 8 семестр, которые можно найти в файловом архиве НИУ «МЭИ» . Не смотря на прямую связь этого архива с НИУ «МЭИ» , его также можно найти и в других разделах. Архив можно найти в разделе "курсовые/домашние работы", в предмете "физика и технология некристаллических полупроводников" в общих файлах.
Просмотр Excel-файла онлайн
Текст из табличного файла "мой тр попов"
S, 1/Ǻ 2'' 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8 2 2.2 2.4 2.6 2.8 3 3.2 3.4 3.6 3.8 4 4.2 4.4 4.6 4.8 5 5.2 5.4 5.6 5.8 6 6.2 6.4 6.6 6.8 7 0 22 15.33 11.7 10.3 9.7 9.5 10 10.4 10.6 10.2 9 8.3 7.7 7.8 7.9 7.8 7.7 7.4 6.8 6.3 5.9 5.4 5.1 4.9 4.7 4.5 4.4 4.3 3.9 3.4 3.1 3.1 3.1 3 3 lg t 0.30103 D, отн.
ед. 4'' 8'' 24 28 16.5 21.2 13.4 17.5 11.7 15.9 11 15.3 11.3 15.4 11.9 16.1 12.3 16.4 12.5 16.5 12.4 16.2 11.7 15.3 10.9 14.3 10.9 13.8 11 13.9 11.1 14.1 11 14.2 10.8 14 10.4 14.05 10 13.6 9.6 13 9.2 12.7 8.9 12.35 8.5 12.1 8.2 11.9 7.9 11.7 7.7 11.6 7.5 11.3 7.3 11.1 7.2 10.9 7 10.5 6.7 10.1 6.5 9.8 6.2 9.3 6 8.9 5.9 8.6 0.60206 0.90309 t=2'' 16'' 35 26.3 22.4 20.9 20.3 20.7 20.9 21.1 21.15 19.7 19.2 18.7 18.4 18.3 18.3 18.1 17.9 17.6 17.05 16.6 16 15.5 15.5 15.6 15.6 15.6 15.6 15.6 15.5 15.4 15.3 15.1 15.1 15 14.9 1.20412 32'' t 42 29.376497 36 8.0352612 27.2 4 24.5 2.7925438 22.6 2.3988329 22.1 2.2908677 22.7 2.5703958 23.3 2.8840315 23.5 3.0199517 23.45 2.7542287 22.3 2 21.2 1.3803843 20.7 20.5 20.45 20.3 20.1 20.1 19.7 19 18.5 18 17.7 17.5 17.3 17.1 17 17 16.8 16.7 16.5 16.3 16.1 15.9 15.8 I / Io 14.688248 4.0176306 2 1.3962719 1.1994165 1.1454338 1.2851979 1.4420158 1.5099759 1.3771144 1 0.6901921 t=4'' t 9.8855309 5.6234133 4 3.3884416 3.6307805 4.1686938 4.5185594 4.7315126 4.5919801 4 3.3113112 3.3113112 3.3884416 3.4673685 3.3884416 3.2359366 2.8840315 2.630268 2.3442288 2.0892961 1.9275249 1.5848932 1.50515 45 D, отн.
ед. 40 35 30 25 Col um n B 45 D, отн. ед. 40 35 30 Col um n B 25 Col um n C 20 15 10 5 0 0 1 2 3 4 5 6 7 8 S, 1/Ǻ Для характерестической кривой произведем преобразование S, 1/Ǻ 2.4 lg t D, отн. ед. 2'' 4'' 8'' 16'' 32'' 8.2 9 11.7 15.3 19.2 22.3 0 0.30103 0.60206 0.90309 1.20412 1.50515 23.016 1.6 16 0.2 0.18 f(x) = 0.00403 14 0.16 12 10 0.12 Iэ / f^2 Iэ ср, отн.ед. 0.14 8 6 0.1 0.08 0.06 4 0.03898898 0.04 2 0.02 0 0 0 1 2 3 4 S, 1/Ǻ 0.2 0.0260429 0.4 0.0275705 0.6 0.0291877 0.8 0.0308997 1 0.0327121 5 6 7 0 1 1.2 0.0346309 1.4 0.0366622 1.6 0.0388127 1.8 0.0410892 2 0.0434994 2.2 0.0460509 2.4 0.048752 2.6 0.0516116 2.8 0.0546389 3 0.0578438 3.2 0.0612367 3.4 0.0648286 3.6 0.0686311 3.8 0.0726568 4 0.0769185 4.2 0.0814302 4.4 0.0862066 4.6 0.0912631 4.8 0.0966162 5 0.1022833 5.2 0.1082828 5.4 0.1146342 5.6 0.1213582 5.8 0.1284766 6 0.1360125 6.2 0.1439904 6.4 0.1524362 6.6 0.1613775 6.8 0.1708432 7 0.1808642 0.02 0.015 0.01 0.005 0 I1 0 1 2 3 -0.005 -0.01 -0.015 -0.02 -0.025 -0.01 -0.015 -0.02 -0.025 Jmax Jmin Jср 0.0396 0.019507 0.0295535 0.6 0.4 0.2 0 i(S) 0 1 2 3 4 -0.2 -0.4 -0.6 -0.8 S, 1/Ǻ 5 6 7 8 t=4'' t=8'' I / Io t t=16'' I / Io t t=32'' I / Io 2.4713827 24.831331 3.1039164 1.4058533 11.748976 1.4686219 33.113112 2.0695695 1 8.8104887 1.1013111 23.120648 1.4450405 0.8471104 8.3176377 1.0397047 20.137242 1.2585777 0.9076951 1.023293 0.1279116 21.877616 1.367351 1.0421735 9.2257143 1.1532143 22.908677 1.4317923 1.1296399 9.7723722 1.2215465 23.988329 1.4992706 1.1828781 10 1.25 24.21029 1.5131432 1.147995 9.4406088 1.1800761 17.70109 1.1063181 1 8 1 16 1 0.8278278 6.6069345 0.8258668 14.454398 0.9033999 0.8278278 6.095369 0.7619211 13.803843 0.8627402 0.8471104 6.16595 0.7707438 13.551894 0.8469934 0.8668421 6.3826349 0.7978294 13.551894 0.8469934 0.8471104 6.4565423 0.8070678 13.42765 0.8392281 0.8089841 6.3095734 0.7886967 12.589254 0.7868284 0.7210079 6.3679552 0.7959944 12.022644 0.7514153 0.657567 5.8076442 0.7259555 11.803206 0.7377004 0.5860572 1 0.125 10.964782 0.6852989 0.522324 4.9203954 0.6150494 9.1201084 0.5700068 0.4818812 4.6131757 0.576647 8.3176377 0.5198524 0.3962233 4.3651583 0.5456448 8.3176377 0.5198524 4.1686938 0.5210867 8.3945999 0.5246625 4 0.5 8.3945999 0.5246625 3.944573 0.4930716 8.3945999 0.5246625 3.6643757 0.458047 8.3945999 0.5246625 3.4673685 0.4334211 8.3945999 0.5246625 3.3113112 0.4139139 8.3176377 0.5198524 3.0199517 0.377494 8.1283052 0.5080191 2.6791683 0.334896 8.3176377 0.5198524 2.4660393 0.3082549 7.7268059 0.4829254 2.1478305 0.2684788 7.7268059 0.4829254 1.9275249 0.2409406 7.5857758 0.474111 1.6595869 0.2074484 7.3790423 0.4611901 45 Col um n B ед.
40 35 t I / Io 34.673685 1.0835527 30.760968 0.9612803 36.307805 1.1346189 32 1 24.547089 0.7670965 21.877616 0.6836755 20.892961 0.652905 20.796967 0.6499052 20.137242 0.6292888 19.054607 0.5954565 19.054607 0.5954565 17.70109 0.553159 15.488166 0.4840052 14.125375 0.441418 13.031668 0.4072396 12.133889 0.379184 11.748976 0.3671555 11.376273 0.3555085 10.964782 0.3426494 10.764652 0.3363954 10.764652 0.3363954 10.471285 0.3272277 10.185914 0.3183098 10 0.3125 9.5499259 0.2984352 9.2257143 0.2883036 8.8104887 0.2753278 8.7096359 0.2721761 Iэ ср,отн.ед. f^2 14.68824826 3.197643243 1.736011191 1.235655876 1.085672376 0.901934371 1.209399368 1.323118178 1.36399929 1.202875895 1 0.802876628 0.62723292 0.623550513 0.632314016 0.624539021 0.595993136 0.572774805 0.534876393 0.376072254 0.429759642 0.397124034 0.368180892 0.470968236 0.460057006 0.453461185 0.439701613 0.431492978 0.42033131 0.401274282 0.389082799 0.363205155 0.346569249 0.330126457 0.313604876 45.646 44.89 42.695 40.205 37.295 34.172 31.019 27.947 25.025 22.31 19.826 17.577 15.563 13.776 12.201 10.822 9.62 8.571 7.654 6.851 6.149 5.536 5.001 4.534 4.122 3.758 3.435 3.148 2.892 2.664 2.459 2.276 2.111 1.961 1.826 Row 71 Row 72 Row 73 Row 74 Row 75 Row 76 Row 77 45 Col um n B Col um n C D, отн.
ед. 40 35 30 25 20.1 20 17.6 8 15 14.05 10.4 10 7.4 5 0 0.2 0.4 0.30103 22 15.33 11.7 10.3 9.7 9.5 10 10.4 10.6 10.2 9 8.3 7.7 7.8 7.9 7.8 7.7 7.4 6.8 6.3 5.9 5.4 0.6 0.60206 24 16.5 13.4 11.7 11 11.3 11.9 12.3 12.5 12.4 11.7 10.9 10.9 11 11.1 11 10.8 10.4 10 9.6 9.2 8.9 0.8 lg t 0.90309 28 21.2 17.5 15.9 15.3 15.4 16.1 16.4 16.5 16.2 15.3 14.3 13.8 13.9 14.1 14.2 14 14.05 13.6 13 12.7 12.35 1 1.20412 35 26.3 22.4 20.9 20.3 20.7 20.9 21.1 21.15 19.7 19.2 18.7 18.4 18.3 18.3 18.1 17.9 17.6 17.05 16.6 16 15.5 1.2 1.50515 42 36 27.2 24.5 22.6 22.1 22.7 23.3 23.5 23.45 22.3 21.2 20.7 20.5 20.45 20.3 20.1 20.1 19.7 19 18.5 18 1.4 1.6 Row 71 Row 72 Row 73 Row 74 Row 75 Row 76 Row 77 Row 78 Row 79 Row 80 Row 81 Row 82 Row 83 Row 84 Row 85 Row 86 Row 87 Polyn omial (Row 87) Row 88 Polyn omial (Row 88) 5.1 4.9 4.7 4.5 4.4 4.3 3.9 3.4 3.1 3.1 3.1 3 3 8.5 8.2 7.9 7.7 7.5 7.3 7.2 7 6.7 6.5 6.2 6 5.9 12.1 11.9 11.7 11.6 11.3 11.1 10.9 10.5 10.1 9.8 9.3 8.9 8.6 15.5 15.6 15.6 15.6 15.6 15.6 15.5 15.4 15.3 15.1 15.1 15 14.9 17.7 17.5 17.3 17.1 17 17 16.8 16.7 16.5 16.3 16.1 15.9 15.8 0.2 0.18 f(x) = 0.004034735308333 x² − 0.007256368679642 x + 0.03955704523553 0.16 0.14 Iэ / f^2 0.12 0.1 0.08 0.06 0.038988986351205 0.04 0.02 0 0 1 2 3 4 S, 1/Ǻ 5 6 7 8 2 3 4 -0.019506954610141 5 6 7 8 -0.019506954610141 S, 1/Ǻ 60 50 40 8 Iн(S) 7 30 20 10 0 0 1 2 3 4 S, 1/Ǻ 5 6 7 8 Iэ / f^2 0.3217861 0.0712329 0.0406608 0.0307339 0.0291104 0.026394 0.038989 0.0473438 0.0545055 0.0539164 0.0504388 0.0456777 0.0403028 0.0452635 0.0518248 0.0577101 0.0619535 0.0668271 0.0698819 0.054893 0.069891 0.0717348 0.0736215 0.1038748 0.1116101 0.1206656 0.1280063 0.1370689 0.1453428 0.1506285 0.1582281 0.1595805 0.164173 0.168346 0.1717442 Row 71 Row 72 Row 73 Row 74 Row 75 Row 76 Row 77 Ic / f^2 I1 0.0383 0.2834861 0.03732 0.0339129 0.03666 0.0040008 0.03632 -0.005586 0.0363 -0.00719 0.0366 -0.010206 0.03722 0.001769 0.03816 0.0091838 0.03942 0.0150855 0.041 0.0129164 0.0429 0.0075388 0.04512 0.0005577 0.04766 -0.007357 0.05052 -0.005256 0.0537 -0.001875 0.0572 0.0005101 0.06102 0.0009335 0.06516 0.0016671 0.06962 0.0002619 0.0744 -0.019507 0.0795 -0.009609 0.08492 -0.013185 0.09066 -0.017039 0.09672 0.0071548 0.1031 0.0085101 0.1098 0.0108656 0.11682 0.0111863 0.12416 0.0129089 0.13182 0.0135228 0.1398 0.0108285 0.1481 0.0101281 0.15672 0.0028605 0.16566 -0.001487 0.17492 -0.006574 0.1845 -0.012756 i(S) Iн(S) 9.5923094 1.1475084 0.1353736 -0.189017 -0.243274 -0.345341 0.0598571 0.3107531 0.5104464 0.4370533 0.2550907 0.0188703 -0.248944 -0.177863 -0.063452 0.0172612 0.0315884 0.0564085 0.0088634 -0.660056 -0.32514 -0.446146 -0.576533 0.2420959 0.2879574 0.3676577 0.3785102 0.4367989 0.4575697 0.366403 0.3427028 0.0967897 -0.050315 -0.222445 -0.431618 483.49655 96.401652 48.474776 32.605565 28.222087 22.370992 32.875708 36.631618 37.798921 32.060659 24.883429 17.908683 11.688679 11.325764 11.426821 11.008801 9.9238809 9.0544776 7.7218402 2.3289553 4.1497139 3.0661355 2.11776 5.6316629 5.3089604 5.1396575 4.7351825 4.5230429 4.2152917 3.6400977 3.3017062 2.4962934 2.0047854 1.5247852 1.0378652 1.468 0.905 0.60206 0.446 0.38 0.36 0.41 0.46 0.48 0.44 0.30103 0.14 0.995 0.75 0.60206 0.53 0.56 0.62 0.655 0.675 0.662 0.60206 0.52 0.52 0.53 0.54 0.53 0.51 0.46 0.42 0.37 0.32 0.285 0.2 6 Row 71 Row 72 Row 73 Row 74 Row 75 Row 76 Row 77 Row 78 Row 79 Row 80 Row 81 Row 82 Row 83 Row 84 Row 85 Row 86 Row 87 Polyn omial (Row 87) Row 88 Polyn omial (Row 88) 6 7 8 1.395 1.07 0.945 0.92 0.01 0.965 0.99 1 0.975 0.90309 0.82 0.785 0.79 0.805 0.81 0.8 0.804 0.764 0.692 0.664 0.64 0.62 0.60206 0.596 0.564 0.54 0.52 0.48 0.428 0.392 0.332 0.285 0.22 1.52 1.364 1.304 1.34 1.36 1.38 1.384 1.248 1.20412 1.16 1.14 1.132 1.132 1.128 1.1 1.08 1.072 1.04 0.96 0.92 0.92 0.924 0.924 0.924 0.924 0.924 0.92 0.91 0.92 0.888 0.888 0.88 0.868 1.54 1.488 1.56 1.50515 1.39 1.34 1.32 1.318 1.304 1.28 1.28 1.248 1.19 1.15 1.115 1.084 1.07 1.056 1.04 1.032 1.032 1.02 1.008 1 0.98 0.965 0.945 0.94 24 23 f(x) = − 5.19323957887337 x³ + 14.9369399122183 x² − 1.34458994316859 x + 8.19999999999998 24 23 f(x) = − 5.19323957887337 x³ + 14.9369399122183 x² − 1.34458994316859 x + 8.19999999999998 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 5 99 99 99 99 999 99 99 999 99 99 999 99 999 99 99 0.
99 99 99 99 99 99 99 99 99 9 99 9 9 9 99 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 999 99 999 99 99 999 99 999 99 99 99 99 99 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 27 29 31 33 35 37 39 41 43 45 47 51 53 55 57 . . . . . . . . .
. . . . . . 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 0. 62 0. 64 0. 0 1 0 5 99 99 99 99 999 99 99 999 99 99 999 99 999 99 99 0. 99 99 99 99 99 99 99 99 99 9 99 9 9 9 99 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 999 99 999 99 99 999 99 999 99 99 99 99 99 9 9 9 9 9 9 9 9 9 9 9 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 79 99 19 39 59 79 99 19 39 59 79 19 39 59 79 2 2 3 3 3 3 3 4 4 4 4 5 5 5 5 0.
0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 6 0. 62 0. 64 0. 0 859 x + 8.19999999999998 859 x + 8.19999999999998 99 99 99 99 99 99 9 9 9 9 99 99 99 99 9 9 9 9 99 99 57 . 0 6 0. 62 0. 64 0. 66 0. 68 0. 7 0. 72 0. 74 0. 76 0. 78 0. 8 0. 82 0. 84 0. 86 0. 88 0.