мой тр попов new (Типовой расчёт)
Описание файла
Excel-файл из архива "Типовой расчёт", который расположен в категории "". Всё это находится в предмете "физика и технология некристаллических полупроводников" из 8 семестр, которые можно найти в файловом архиве НИУ «МЭИ» . Не смотря на прямую связь этого архива с НИУ «МЭИ» , его также можно найти и в других разделах. Архив можно найти в разделе "курсовые/домашние работы", в предмете "физика и технология некристаллических полупроводников" в общих файлах.
Просмотр Excel-файла онлайн
Текст из табличного файла "мой тр попов new"
S, 1/Ǻ 2'' 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 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 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 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 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 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 6 5.9 0.30103 0.60206 lg t t=2'' 16'' 32'' 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 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 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 8.9 8.6 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 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 0.90309 1.20412 1.50515 t=4'' t 29.512092 8.0352612 4 2.7925438 2.3988329 2.2908677 2.5703958 2.8840315 3.0199517 2.7542287 2 1.3803843 1.2589254 1.2618275 I / Io t 14.756046 1 4.0176306 9.8855309 2 5.6234133 1.3962719 4 1.1994165 3.3884416 1.1454338 3.6307805 1.2851979 4.1686938 1.4420158 4.5185594 1.5099759 4.7315126 1.3771144 4.5919801 1 4 0.6901921 3.3113112 0.6294627 3.3113112 0.6309138 3.3884416 1.2735031 1.2618275 1.2589254 1.2022644 0.6367515 3.4673685 0.6309138 3.3884416 0.6294627 3.2359366 0.6011322 2.8840315 2.630268 2.3442288 2.0892961 1.9275249 1.7782794 1.5848932 1.3803843 1.2589254 1.2302688 1.1220185 1.0592537 1 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 2 D, отн. ед. 2'' 4'' 8'' 16'' 32'' 7 9 11.7 15.3 19.2 22.3 0 0.30103 0.60206 0.90309 1.20412 1.50515 19.4372 23.164 1.6 24.617 1.8 8 0.2 7 0.18 6 0.14 5 Iэ / f^2 Iэ ср, отн.ед. f(x) = + 0.0 0.16 4 3 0.12 0.1 0.08 0.06 2 0.04 1 0.02 0 0 0 1 2 3 S, 1/Ǻ 0.2 0.4 0.6 0.8 1 0.0260429 0.0275705 0.0291877 0.0308997 0.0327121 4 5 6 7 0 1 0.0346309 0.0366622 0.0388127 0.0410892 0.0434994 0.0460509 0.048752 0.0516116 0.0546389 0.0578438 0.0612367 0.0648286 0.0686311 0.0726568 0.0769185 0.0814302 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.0862066 0.0912631 0.0966162 0.1022833 0.1082828 0.1146342 0.1213582 0.1284766 0.1360125 0.1439904 0.1524362 0.1613775 0.1708432 0.1808642 0.06 0.05 0.04 0.0 0.03 I1 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 0.02 0.01 0 0 -0.01 1 2 3 0.02 0.01 0 0 1 2 3 -0.01 Jmax Jmin Jср 0.0303 0.0039 0.0171 3 2.5 i(S) 2 1.5 1 0.5 0 0 1 2 3 4 -0.5 S, 1/Ǻ 5 6 7 8 t=4'' I / Io 0.25 2.4713827 1.4058533 1 0.8471104 0.9076951 1.0421735 1.1296399 1.1828781 1.147995 1 0.8278278 0.8278278 0.8471104 0.8668421 0.8471104 0.8089841 0.7210079 0.657567 0.5860572 0.522324 0.4818812 0.4445699 0.3962233 0.3450961 0.3147314 0.3075672 0.2805046 0.2648134 0.25 t=8'' t I / Io t t=32'' I / Io 24.831331 11.748976 8.8104887 8.3176377 1.023293 9.2257143 9.7723722 10 9.4406088 8 6.6069345 6.095369 6.16595 3.1039164 1.4686219 1.1013111 1.0397047 0.1279116 1.1532143 1.2215465 1.25 1.1800761 1 0.8258668 0.7619211 0.7707438 33.113112 2.0695695 23.120648 1.4450405 20.137242 1.2585777 21.877616 1.367351 22.908677 1.4317923 23.988329 1.4992706 24.21029 1.5131432 17.70109 1.1063181 16 1 14.454398 0.9033999 13.803843 0.8627402 13.551894 0.8469934 6.3826349 6.4565423 6.3095734 6.3679552 5.8076442 5.3088444 4.9203954 4.6131757 4.3651583 4.1686938 4 3.944573 3.6643757 3.4673685 3.3113112 3.0199517 2.6791683 2.4660393 2.1478305 1.9275249 1.8197009 0.7978294 0.8070678 0.7886967 0.7959944 0.7259555 0.6636056 0.6150494 0.576647 0.5456448 0.5210867 0.5 0.4930716 0.458047 0.4334211 0.4139139 0.377494 0.334896 0.3082549 0.2684788 0.2409406 0.2274626 13.551894 0.8469934 13.42765 0.8392281 12.589254 0.7868284 12.022644 0.7514153 11.803206 0.7377004 10.964782 0.6852989 9.1201084 0.5700068 8.3176377 0.5198524 8.3176377 0.5198524 8.3945999 0.5246625 8.3945999 0.5246625 8.3945999 0.5246625 8.3945999 0.5246625 8.3945999 0.5246625 8.3176377 0.5198524 8.1283052 0.5080191 8.3176377 0.5198524 7.7268059 0.4829254 7.7268059 0.4829254 7.5857758 0.474111 7.3790423 0.4611901 45 ед.
40 Col um n B t=16'' 35 Iэ ср,отн.ед. f^2 32 1 24.547089 0.7670965 21.877616 0.6836755 20.892961 0.652905 7.503023067 3.197643243 1.736011191 1.235655876 1.085672376 0.901934371 1.209399368 1.323118178 1.36399929 1.202875895 1 0.802876628 0.753125461 0.749733267 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 20.796967 20.137242 19.054607 19.054607 17.70109 15.488166 14.125375 13.031668 12.133889 11.748976 11.376273 10.964782 10.764652 10.764652 10.471285 10.185914 10 9.5499259 9.2257143 8.8104887 8.7096359 0.759664324 0.750721775 0.721885677 0.693001248 0.668595492 0.604741706 0.537199552 0.496405043 0.472312754 0.452282001 0.431316771 0.418778727 0.406668008 0.393745887 0.38145184 0.363455712 0.389082799 0.363205155 0.346569249 0.330126457 0.320276291 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 t I / Io 34.673685 1.0835527 30.760968 0.9612803 36.307805 1.1346189 0.6499052 0.6292888 0.5954565 0.5954565 0.553159 0.4840052 0.441418 0.4072396 0.379184 0.3671555 0.3555085 0.3426494 0.3363954 0.3363954 0.3272277 0.3183098 0.3125 0.2984352 0.2883036 0.2753278 0.2721761 Row 71 Row 72 Row 73 Row 74 Row 75 Row 76 Row 77 45 40 D, отн.
ед. Col um n B Col um n C 35 30 25 20.1 20 17.6 8 15 14.05 10.4 10 7.4 5 0 0.2 25.438 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.00255371298211 x² + 0.00308047548662 x + 0.030295386034299 0.16 Iэ / f^2 0.14 0.12 0.1 0.08 0.06 0.04 0.02 0 0 1 2 3 4 S, 1/Ǻ 5 6 7 8 1 0.028770574555479 2 3 4 5 6 7 8 1 2 3 4 5 6 7 8 S, 1/Ǻ 80 70 60 Iн(S) 50 40 30 20 7 8 10 0 0 1 2 3 4 S, 1/Ǻ 5 6 7 8 Iэ / f^2 Ic / f^2 I1 i(S) Iн(S) t2 t4 0.1643742 0.0712329 0.0406608 0.0307339 0.0291104 0.026394 0.038989 0.0473438 0.0545055 0.0539164 0.0504388 0.0456777 0.048392 0.0544231 0.029784 0.029476 0.029376 0.029484 0.0298 0.030324 0.031056 0.031996 0.033144 0.0345 0.036064 0.037836 0.039816 0.042004 0.1345902 0.0417569 0.0112848 0.0012499 -0.00069 -0.00393 0.007933 0.0153478 0.0213615 0.0194164 0.0143748 0.0078417 0.008576 0.0124191 7.8707698 2.4419218 0.6599275 0.0730927 -0.040327 -0.229827 0.4639173 0.8975343 1.2492085 1.1354646 0.8406326 0.4585779 0.5015233 0.7262659 404.91516 154.50787 70.870607 43.143693 35.790987 26.318353 45.409252 53.03039 56.286444 47.642216 36.492382 25.637424 23.368208 23.781039 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 1.47 0.905 0.60206 0.446 0.38 0.36 0.41 0.46 0.48 0.44 0.30103 0.14 0.1 0.101 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 0.0622625 0.06937 0.0750401 0.0808542 0.0873524 0.0882706 0.0873637 0.0896685 0.0944437 0.0997534 0.1046377 0.1114366 0.1183895 0.1250781 0.131899 0.1364323 0.1582281 0.1595805 0.164173 0.168346 0.1753977 0.0444 0.047004 0.049816 0.052836 0.056064 0.0595 0.063144 0.066996 0.071056 0.075324 0.0798 0.084484 0.089376 0.094476 0.099784 0.1053 0.111024 0.116956 0.123096 0.129444 0.136 0.0178625 0.022366 0.0252241 0.0280182 0.0312884 0.0287706 0.0242197 0.0226725 0.0233877 0.0244294 0.0248377 0.0269526 0.0290135 0.0306021 0.032115 0.0311323 0.0472041 0.0426245 0.041077 0.038902 0.0393977 1.0445885 1.3079512 1.4750931 1.6384905 1.8297327 1.6824897 1.4163583 1.3258796 1.3676995 1.428621 1.4524995 1.5761752 1.6966972 1.789597 1.8780688 1.8206038 2.7604713 2.4926592 2.402165 2.2749693 2.303962 24.946025 24.976648 23.810395 22.614502 21.658774 18.377737 14.858187 12.876069 11.840865 11.011368 10.109203 9.6812664 9.2631549 8.7816514 8.323375 7.5140884 9.246999 7.9492924 7.1819703 6.4222148 6.0330346 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 0.105 0.101 0.1 0.08 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 6 5.9 Row 71 Row 72 Row 73 Row 74 Row 75 Row 76 Row 77 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.25 0.2 0.14 0.1 0.09 0.05 0.025 0 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 t8 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 8.9 8.6 t16 t32 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 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 1.52 1.364 1.304 1.34 1.36 1.38 1.384 1.248 1.20412 1.16 1.14 1.132 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 0.805 0.81 0.8 0.804 0.764 0.725 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.26 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.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 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 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 35 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 99 99 99 99 99 99 99 99 99 99 99 0.