мой тр попов (Типовой расчёт)
Описание файла
Excel-файл из архива "Типовой расчёт", который расположен в категории "". Всё это находится в предмете "физика и технология некристаллических полупроводников" из 8 семестр, которые можно найти в файловом архиве НИУ «МЭИ» . Не смотря на прямую связь этого архива с НИУ «МЭИ» , его также можно найти и в других разделах. Архив можно найти в разделе "курсовые/домашние работы", в предмете "физика и технология некристаллических полупроводников" в общих файлах.
Просмотр Excel-файла онлайн
Текст из табличного файла "мой тр попов"
35 26.3 22.4 t=2'' t=4'' t=8'' t=16'' t I / Io t I / Io t I / Io t I / Io 42 29.3765 14.68825 36 8.035261 4.017631 9.885531 2.471383 24.83133 3.103916 27.2 4 2 5.623413 1.405853 11.74898 1.468622 33.11311 2.06957 14.68824826 3.197643243 1.736011191 45.646 0.321786 0.026043 0.295743 2.206829 146.37891 44.89 0.071233 0.027571 0.043662 0.325808 59.515502 42.695 0.040661 0.029188 0.011473 0.085612 46.350201 15.9 15.3 15.4 20.9 20.3 20.7 24.5 2.792544 1.396272 4 1 8.810489 1.101311 23.12065 1.44504 1.235655876 22.6 2.398833 1.199416 3.388442 0.84711 8.317638 1.039705 20.13724 1.258578 34.67369 1.083553 1.085672376 22.1 2.290868 1.145434 3.630781 0.907695 1.023293 0.127912 21.87762 1.367351 30.76097 0.96128 0.901934371 40.205 0.030734 0.0309 -0.000166 -0.001237 40.155255 37.295 0.02911 0.032712 -0.003602 -0.026876 36.292654 34.172 0.026394 0.034631 -0.008237 -0.061464 32.071656 11.9 12.3 16.1 16.4 20.9 21.1 22.7 2.570396 1.285198 4.168694 1.042173 9.225714 1.153214 22.90868 1.431792 36.30781 1.134619 1.209399368 23.3 2.884032 1.442016 4.518559 1.12964 9.772372 1.221547 23.98833 1.499271 1.323118178 31.019 0.038989 0.036662 0.002327 0.017362 31.557564 27.947 0.047344 0.038813 0.008531 0.063659 29.726091 10.6 10.2 9 12.5 12.4 11.7 16.5 16.2 15.3 21.15 19.7 19.2 23.5 3.019952 1.509976 4.731513 1.182878 10 1.25 24.21029 1.513143 23.45 2.754229 1.377114 4.59198 1.147995 9.440609 1.180076 17.70109 1.106318 22.3 2 1 4 1 8 1 16 1 2.4 2.6 8.3 7.7 10.9 10.9 14.3 13.8 18.7 18.4 21.2 1.380384 0.690192 3.311311 0.827828 6.606934 0.825867 14.4544 0.9034 20.7 3.311311 0.827828 6.095369 0.761921 13.80384 0.86274 2.8 3 3.2 7.8 7.9 7.8 11 11.1 11 13.9 14.1 14.2 18.3 18.3 18.1 20.5 20.45 20.3 3.4 3.6 7.7 7.4 10.8 10.4 14 14.05 17.9 17.6 3.8 4 4.2 6.8 6.3 5.9 10 9.6 9.2 13.6 13 12.7 4.4 4.6 5.4 5.1 8.9 8.5 4.8 5 5.2 4.9 4.7 4.5 5.4 5.6 S, 1/Ǻ 2'' D, отн.
ед. 8'' 24 28 16.5 21.2 13.4 17.5 4'' 0.2 0.4 0.6 22 15.33 11.7 0.8 1 1.2 10.3 9.7 9.5 11.7 11 11.3 1.4 1.6 10 10.4 1.8 2 2.2 16'' 32'' t=32'' t I / Io Iэ ср,отн.ед. f^2 Iэ / f^2 Ic / f^2 I1 i(S) Iн(S) 1.36399929 1.202875895 1 25.025 0.054505 0.041089 0.013416 0.100112 27.530291 22.31 0.053916 0.043499 0.010417 0.077732 24.044201 19.826 0.050439 0.046051 0.004388 0.032743 20.47516 24.54709 0.767097 0.802876628 21.87762 0.683676 0.62723292 17.577 0.045678 0.048752 -0.003074 -0.022941 17.173774 15.563 0.040303 0.051612 -0.011309 -0.084386 14.249704 3.388442 0.84711 6.16595 0.770744 13.55189 0.846993 3.467369 0.866842 6.382635 0.797829 13.55189 0.846993 3.388442 0.84711 6.456542 0.807068 13.42765 0.839228 20.89296 0.652905 0.623550513 20.79697 0.649905 0.632314016 20.13724 0.629289 0.624539021 13.776 0.045264 0.054639 -0.009375 -0.069959 12.812246 12.201 0.051825 0.057844 -0.006019 -0.044914 11.653005 10.822 0.05771 0.061237 -0.003527 -0.026315 10.537218 20.1 20.1 3.235937 0.808984 6.309573 0.788697 12.58925 0.786828 2.884032 0.721008 6.367955 0.795994 12.02264 0.751415 19.05461 0.595456 0.595993136 19.05461 0.595456 0.572774805 9.62 0.061954 0.064829 -0.002875 -0.021453 9.4136186 8.571 0.066827 0.068631 -0.001804 -0.013462 8.4556174 17.05 16.6 16 19.7 19 18.5 2.630268 0.657567 5.807644 0.725956 11.80321 0.7377 2.344229 0.586057 1 0.125 10.96478 0.685299 2.089296 0.522324 4.920395 0.615049 9.120108 0.570007 17.70109 0.553159 0.534876393 15.48817 0.484005 0.376072254 14.12538 0.441418 0.429759642 7.654 0.069882 0.072657 -0.002775 -0.020706 7.4955191 6.851 0.054893 0.076919 -0.022025 -0.164353 5.7250144 6.149 0.069891 0.08143 -0.011539 -0.086106 5.6195371 12.35 12.1 15.5 15.5 18 17.7 1.927525 0.481881 4.613176 0.576647 8.317638 0.519852 1.584893 0.396223 4.365158 0.545645 8.317638 0.519852 13.03167 0.40724 0.397124034 12.13389 0.379184 0.368180892 5.536 0.071735 0.086207 -0.014472 -0.107988 4.9381795 5.001 0.073621 0.091263 -0.017642 -0.131642 4.3426609 8.2 7.9 7.7 11.9 11.7 11.6 15.6 15.6 15.6 17.5 17.3 17.1 4.168694 0.521087 4 0.5 3.944573 0.493072 8.3946 0.524662 8.3946 0.524662 8.3946 0.524662 11.74898 0.367155 0.470968236 11.37627 0.355509 0.460057006 10.96478 0.342649 0.453461185 4.534 0.103875 0.096616 0.007259 0.054163 4.7795765 4.122 0.11161 0.102283 0.009327 0.069597 4.4088775 3.758 0.120666 0.108283 0.012383 0.0924 4.1052385 4.4 4.3 7.5 7.3 11.3 11.1 15.6 15.6 17 17 3.664376 0.458047 3.467369 0.433421 8.3946 0.524662 8.3946 0.524662 10.76465 0.336395 0.439701613 10.76465 0.336395 0.431492978 3.435 0.128006 0.114634 0.013372 0.099782 3.7777513 3.148 0.137069 0.121358 0.015711 0.117233 3.5170499 5.8 6 6.2 3.9 3.4 3.1 7.2 7 6.7 10.9 10.5 10.1 15.5 15.4 15.3 16.8 16.7 16.5 3.311311 0.413914 8.317638 0.519852 3.019952 0.377494 8.128305 0.508019 2.679168 0.334896 8.317638 0.519852 10.47129 0.327228 0.42033131 10.18591 0.31831 0.401274282 10 0.3125 0.389082799 2.892 0.145343 0.128477 0.016866 0.125855 3.2559737 2.664 0.150628 0.136012 0.014616 0.109065 2.9545478 2.459 0.158228 0.14399 0.014238 0.106241 2.7202474 6.4 6.6 3.1 3.1 6.5 6.2 9.8 9.3 15.1 15.1 16.3 16.1 2.466039 0.308255 7.726806 0.482925 2.14783 0.268479 7.726806 0.482925 9.549926 0.298435 0.363205155 9.225714 0.288304 0.346569249 2.276 0.15958 0.152436 0.007144 2.111 0.164173 0.161378 0.002796 6.8 7 0 3 3 6 5.9 8.9 8.6 15 14.9 15.9 15.8 1.927525 0.240941 7.585776 0.474111 1.659587 0.207448 7.379042 0.46119 8.810489 0.275328 0.330126457 8.709636 0.272176 0.313604876 1.961 0.168346 0.170843 -0.002497 -0.018635 1.9244576 1.826 0.171744 0.180864 -0.00912 -0.068053 1.7017346 0.30103 0.60206 0.90309 1.20412 1.50515 lg t 32 1 45 45 35 30 25 20 40 Col um nB Col um nC Col um nD D, отн.
ед. D, отн. ед. 40 35 30 15 25 10 5 20 20.1 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 0.05331 2.3973337 0.02086 2.1550355 40 Col um nB Col um nC Col um nD 30 25 20 D, отн. ед. D, отн. ед. 35 35 30 15 25 10 5 20.1 20 17.6 0 0 1 2 3 4 S, 1/Ǻ 5 6 7 8 15 14.05 10.4 10 7.4 5 lg t 0 0.2 Для характерестической кривой произведем преобразование S, 1/Ǻ 2.4 lg t 2'' 8.2 0 4'' 9 0.30103 D, отн. ед. 8'' 16'' 32'' 11.7 15.3 19.2 22.3 0.60206 0.90309 1.20412 1.50515 23.016 1.6 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 5.1 4.9 4.7 4.5 4.4 4.3 3.9 3.4 3.1 3.1 3.1 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 8.5 8.2 7.9 7.7 7.5 7.3 7.2 7 6.7 6.5 6.2 0.8 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 12.1 11.9 11.7 11.6 11.3 11.1 10.9 10.5 10.1 9.8 9.3 1 1.2 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 15.5 15.6 15.6 15.6 15.6 15.6 15.5 15.4 15.3 15.1 15.1 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 17.7 17.5 17.3 17.1 17 17 16.8 16.7 16.5 16.3 16.1 1.4 1.6 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 Polyno mial (Row 87) Row 88 Polyno mial (Row 88) 16 0.2 14 0.18 Iэ / f^2 Iэ ср, отн.ед.
3 3 12 10 6 5.9 8.9 8.6 15 14.9 15.9 15.8 f(x) = 0.024551698598098 exp( 0.284983248182909 x ) 0.16 0.14 0.12 8 0.1 6 0.08 0.06 4 0.04 2 0.038988986351205 0.02 0 0 0 1 0.2 0.026043 0.4 0.027571 0.6 0.029188 0.8 0.0309 1 0.032712 1.2 0.034631 1.4 0.036662 1.6 0.038813 1.8 0.041089 2 0.043499 2.2 0.046051 2.4 0.048752 2.6 0.051612 2.8 0.054639 3 3.2 3.4 3.6 0.057844 0.061237 0.064829 0.068631 3.8 0.072657 4 0.076919 2 3 S, 1/Ǻ 4 5 6 7 0 1 2 3 4 S, 1/Ǻ 5 6 7 8 4.2 4.4 4.6 4.8 5 0.08143 0.086207 0.091263 0.096616 0.102283 5.2 0.108283 5.4 0.114634 5.6 0.121358 5.8 0.128477 6 0.136012 6.2 0.14399 6.4 0.152436 6.6 0.161378 6.8 0.170843 7 0.180864 0.02 0.015 0.01 I1 0.005 0 0 1 2 3 4 5 -0.005 -0.01 -0.015 -0.02 -0.02202545639372 -0.025 Jmax Jmin Jср 0.246 0.022025 0.134013 S, 1/Ǻ 6 7 8 0.15 50 0.1 45 40 35 0 0 1 2 3 4 5 6 7 8 Iн(S) i(S) 0.05 30 25 -0.05 20 -0.1 15 -0.15 -0.2 10 5 S, 1/Ǻ S, 1/Ǻ 0 0 1 2 3 4 5 6 7 8 1.468 0.905 0.60206 0.995 0.75 1.395 1.07 1.52 0.446 0.38 0.36 0.60206 0.53 0.56 0.945 0.92 0.01 1.364 1.304 1.34 0.41 0.46 0.62 0.655 0.965 0.99 1.36 1.38 0.48 0.44 0.30103 0.675 0.662 0.60206 1 0.975 0.90309 1.384 1.248 1.20412 1.50515 0.14 0.52 0.52 0.82 0.785 1.16 1.14 1.39 1.34 0.53 0.54 0.53 0.79 0.805 0.81 1.132 1.132 1.128 1.32 1.318 1.304 0.51 0.46 0.8 0.804 1.1 1.08 1.28 1.28 0.42 0.37 0.32 0.764 0.692 1.072 1.04 0.96 1.248 1.19 1.15 0.285 0.2 0.664 0.64 0.92 0.92 1.115 1.084 0.62 0.60206 0.596 0.924 0.924 0.924 1.07 1.056 1.04 0.564 0.54 0.924 0.924 1.032 1.032 0.52 0.48 0.428 0.92 0.91 0.92 1.02 1.008 1 0.392 0.332 0.888 0.888 0.98 0.965 0.285 0.22 0.88 0.868 0.945 0.94 1.54 1.488 1.56 24 23 22 21 20 19 18 f(x) = − 5.1932395788734 x³ + 14.9369399122183 x² − 1.34458994316863 x + 8.19999999999998 24 23 f(x) = − 5.1932395788734 x³ + 14.9369399122183 x² − 1.34458994316863 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 9 9 9 9 9 9 9 9 9 9 9 5 9 9 9 9 0.