" but I have no headers, so readtable is no option"
READTABLE does not require headers to be present in the file.
Please upload sample files by clicking on the paperclip button.
You are now following this question
- You will see updates in your followed content feed.
- You may receive emails, depending on your communication preferences.
Using xlsread with multiple delimiters
8 views (last 30 days)
Show older comments
Hi,
I want to write a script, which can import xlsx, txt and csv files. Therefore I use xlsread. I know it's not recommded, but I have no headers, so readtable is no option. But I struggle to add multiple delimiters into the code of xlsread. I tried this code:
directory_name=uigetdir('','Waehl den Ordner mit den Messungen');
[nur_file_name,pfad]=uigetfile({'*.csv;*.txt;*.xlsx','csv&xlsx&txt-files (*.csv,*.txt,*xlsx)';'*.*','all Files'},...
'Die Intensitäts-Files der Proben oeffnen (probe_001.txt=',...
[directory_name '/'], 'Multiselect', 'on');
[num,txt,raw] = xlsread(filename{xy}, [',' ';' '\t'], 'B1:KR1');
But it is sadly not working in the last line. The delimiters are not accepted in this form. I am grateful for every hint.
9 Comments
Tatjana Mü
on 31 Mar 2022
I added two sample files. I can read in SMP_3.8.1 without delimiters. But Matlab struggles with SMP_Std.csv. If I open this file in Excel, every row is just in one cell, so I have to tell Matlab that the delimiter is a simple ',', while the other files, xlsx and txt have ';' or '\t'.
The problem with readtable is, that I exclude later several columns and change the input to a char array. And I have to start completely new with the script if I use readtable. I just struggle with the type of files like "SMP_Std.csv".
Stephen23
on 31 Mar 2022
Edited: Stephen23
on 31 Mar 2022
"But Matlab struggles with SMP_Std.csv."
Both of them seem to be imported correctly when I try them here, even though they use different delimiters:
T1 = readtable('SMP_Std.csv', 'VariableNamingRule','preserve')
T1 = 260×305 table
t_elapsed_Buf '[23Na]+' '[24Mg]+' '[25Mg]+' '[26Mg]+' 'C2H2+' '[27Al]+' 'C2H3+' '[28Si]+' 'N2+' '[29Si]+' 'HN2+' '[30Si]+' 'NO+' '[31P]+' '[15N]O+' 'NOH+' '[32S]+' 'O2+' '[33S]+' 'O2H+' '[34S]+' 'O[18O]+' '[35Cl]+' '[36S]+' '[36Ar]+' 'HCl+' '[37Cl]+' '[36Ar]H+' '[38Ar]+' '[39K]+' '[38Ar]H+' '[40Ar]+' '[40Ca]+' '[41K]+' 'ArH+' '[42Ca]+' 'ArH2+' '[43Ca]+' '[87Sr]++' '[88Sr]++' '[44Ca]+' 'CO2+' '[45Sc]+' 'CHO2+' '[46Ti]+' '[46Ca]+' 'NO2+' '[47Ti]+' '[48Ti]+' '[48Ca]+' '[49Ti]+' '[50Ti]+' '[50Cr]+' '[50V]+' '[51V]+' 'ClO+' '[52Cr]+' '[36Ar]O+' '[53Cr]+' '[37Cl]O+' '[54Cr]+' '[54Fe]+' 'ArN+' '[55Mn]+' '[56Fe]+' 'ArO+' '[57Fe]+' 'ArOH+' '[58Fe]+' '[58Ni]+' '[59Co]+' '[60Ni]+' '[61Ni]+' '[62Ni]+' '[63Cu]+' '[64Ni]+' '[64Zn]+' '[65Cu]+' '[66Zn]+' '[67Zn]+' '[68Zn]+' '[137Ba]++' '[69Ga]+' '[138Ba]++' '[70Ge]+' '[70Zn]+' '[71Ga]+' '[72Ge]+' '[73Ge]+' '[74Ge]+' '[74Se]+' '[75As]+' 'ArCl+' '[76Se]+' '[76Ge]+' 'Ar[36Ar]+' '[77Se]+' 'Ar[37Cl]+' '[78Se]+' '[78Kr]+' 'Ar[38Ar]+' '[79Br]+' '[80Kr]+' '[80Se]+' 'Ar2+' '[81Br]+' '[82Kr]+' '[82Se]+' '[83Kr]+' '[84Kr]+' '[84Sr]+' '[85Rb]+' '[86Sr]+' '[86Kr]+' '[87Sr]+' '[87Rb]+' '[88Sr]+' '[89Y]+' '[90Zr]+' '[91Zr]+' '[92Zr]+' '[92Mo]+' '[93Nb]+' '[94Mo]+' '[94Zr]+' '[95Mo]+' '[96Mo]+' '[96Ru]+' '[96Zr]+' '[97Mo]+' '[98Ru]+' '[98Mo]+' '[99Ru]+' '[100Ru]+' '[100Mo]+' '[101Ru]+' '[102Ru]+' '[102Pd]+' '[103Rh]+' '[104Pd]+' '[104Ru]+' '[105Pd]+' '[106Pd]+' '[106Cd]+' '[107Ag]+' '[108Pd]+' '[108Cd]+' '[109Ag]+' '[110Cd]+' '[110Pd]+' '[111Cd]+' '[112Cd]+' '[112Sn]+' '[113In]+' '[113Cd]+' '[114Sn]+' '[114Cd]+' '[115Sn]+' '[115In]+' '[116Sn]+' '[116Cd]+' '[117Sn]+' '[118Sn]+' '[119Sn]+' '[102Sn]+' '[120Te]+' '[121Sb]+' '[122Te]+' '[122Sn]+' '[123Sb]+' '[123Te]+' '[124Te]+' '[124Sn]+' '[124Xe]+' '[125Te]+' '[126Te]+' '[126Xe]+' '[127I]+' '[128Xe]+' '[128Te]+' '[129Xe]+' '[130Xe]+' '[130Te]+' '[130Ba]+' '[131Xe]+' '[132Xe]+' '[132Ba]+' '[133Cs]+' '[134Ba]+' '[134Xe]+' '[135Ba]+' '[136Ba]+' '[136Ce]+' '[136Xe]+' '[137Ba]+' '[138Ba]+' '[138Ce]+' '[138La]+' '[139La]+' '[140Ce]+' '[141Pr]+' '[142Nd]+' '[142Ce]+' '[143Nd]+' '[144Nd]+' '[144Sm]+' '[145Nd]+' '[146Nd]+' '[147Sm]+' '[148Sm]+' '[148Nd]+' '[149Sm]+' '[150Sm]+' '[150Nd]+' '[151Eu]+' '[152Sm]+' '[152Gd]+' '[153Eu]+' '[154Gd]+' '[154Sm]+' '[155Gd]+' 'CeO+' '[156Gd]+' '[156Dy]+' '[157Gd]+' '[158Gd]+' '[158Dy]+' '[159Tb]+' '[160Dy]+' '[160Gd]+' '[161Dy]+' '[162Dy]+' '[162Er]+' '[163Dy]+' '[164Dy]+' '[164Er]+' '[165Ho]+' '[166Er]+' '[167Er]+' '[168Er]+' '[168Yb]+' '[169Tm]+' '[170Yb]+' '[170Er]+' '[171Yb]+' '[172Yb]+' '[173Yb]+' '[174]Yb+' '[174Hf]+' '[175Lu]+' '[176Hf]+' '[176Yb]+' '[176Lu]+' '[177Hf]+' '[178Hf]+' '[179Hf]+' '[180Hf]+' '[180W]+' '[180Ta]+' '[181Ta]+' '[182W]+' '[183W]+' '[184W]+' '[184Os]+' '[185Re]+' '[186Os]+' '[186W]+' '[187Os]+' '[187Re]+' '[188Os]+' '[189Os]+' '[190Os]+' '[190Pt]+' '[191Ir]+' '[192Pt]+' '[192Os]+' '[193Ir]+' '[194Pt]+' '[195Pt]+' '[196Pt]+' '[196Hg]+' '[197Au]+' '[198Hg]+' '[198Pt]+' '[199Hg]+' '[200Hg]+' '[201Hg]+' '[202Hg]+' '[203Tl]+' '[204Pb]+' '[204Hg]+' '[205Tl]+' '[206Pb]+' '[207Pb]+' '[208Pb]+' '[209Bi]+' '[220Bkg]+' '[232Th]+' '[234U]+' '[235U]+' '[238U]+' 'ThO+' 'UO+' TotalIonCurrent
_____________ _________ _________ _________ _________ _______ _________ _______ _________ ______ _________ ______ _________ __________ ________ _________ ______ ________ __________ ________ ______ ________ _________ _________ ________ _________ ______ _________ __________ _________ ________ __________ _________ _________ __________ __________ _________ _______ _________ __________ __________ _________ ______ _________ _______ _________ _________ ______ _________ _________ _________ _________ _________ _________ ________ ________ ______ _________ __________ _________ __________ _________ _________ ______ _________ _________ ______ _________ _______ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ ___________ _________ ___________ _________ _________ _________ _________ _________ _________ _________ _________ _______ ___________ ___________ ___________ _________ ___________ _________ _________ ___________ _________ _________ _________ ______ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ ________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ ___________ __________ __________ _________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ ______ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ ___________ ___________ __________ _________ __________ __________ _________ _________ _________ __________ __________ __________ _________ __________ __________ ___________ ___________ ___________ ___________ __________ ___________ ___________ ___________ ___________ ___________ __________ ___________ ___________ ___________ ___________ ___________ __________ __________ __________ ___________ ___________ ___________ __________ __________ __________ __________ __________ ___________ __________ ___________ _________ _________ ______ ______ _______________
0 2444 2975.1 603.26 1012.6 21.156 2359.1 254.74 25407 1045 465.52 6079.1 24522 1.34e+05 43.042 78.678 117.06 66606 1.323e+05 7208.5 36428 1773.8 8751.7 58.311 2840.9 2838.2 2562 25703 27410 345.09 5255.2 5344 45067 45118 4.8023e+05 5.3436e+05 52.096 9.2963 2062.7 10.614 27897 27996 2539 1501.1 12596 142.92 148.38 321.66 61.44 4392 4445.2 8.6567 31.692 32.017 32.139 156.63 113.96 130.15 76.783 32.617 28.934 656.36 671.25 614.16 494.79 7082.5 3217.5 561.63 717.37 472.6 472.35 71.863 251.3 24.146 59.132 59.171 77330 77147 63.608 47251 7042.8 34458 46.128 151.04 188.68 1252.6 1249.3 17.327 22.438 28.535 -0.077364 -0.11249 18.379 22.453 7.9087 8.7742 10.621 16.915 16.631 -0.17386 -0.17388 -0.17392 793.15 2615.2 2616.3 2620.8 1166 14.486 14.486 13.406 42.91 42.504 105.9 138.78 138.19 191.64 191.76 1550.6 481.59 26.048 0.76624 50.979 50.812 4.3177 9.7799 9.9197 34.479 28.845 28.528 28.428 34.486 69.306 69.316 1.8182 19.867 20.272 2.4881 5.3444 5.3263 11471 1.2004 1.0071 25.938 6.7628 6.7628 5.9972 0.19573 0.23924 2.7861 10.093 10.093 8.322 8.2036 7.6795 13.9 13.882 7.3061 7.3061 4.4967 4.4967 29.25 28.985 5.4002 58.822 28.504 33.94 34.059 25.774 8.62 8.6522 12.148 12.141 10.395 10.395 10.395 1.0399 1.8962 1.8962 410.99 61.353 60.586 763.61 115.24 115.72 115.73 531.61 633.41 633.75 15.883 431.68 431.06 166.16 459.16 459.01 458.99 377.11 2136.4 2136.8 2136.7 283.34 404.28 312.07 189.55 191.28 51.672 110.77 110.69 47.72 93.762 54.858 89.45 91.007 38.011 45.921 47.022 110.6 71.27 71.269 145.86 73.256 72.843 96.134 54.775 55.039 54.731 35.649 65.459 65.534 253.23 66.438 66.078 53.319 72.884 72.221 131.23 94.792 94.794 278.15 95.428 75.402 75.449 74.996 243.52 47.092 46.945 61.52 37.819 55.875 72.919 72.945 329.25 44.063 43.901 43.885 -0.22703 3.4639 -0.22812 -0.20284 -0.20283 -0.2028 -0.20529 -0.2298 -0.23039 -0.23093 -0.23093 79.161 -0.23205 -0.23205 130.22 130.22 -0.23317 -0.23373 -0.23429 -0.23429 0.97913 -0.2354 -0.2354 -0.23595 -0.2365 12.464 1.0954 1.0954 5.1709 2.2606 2.2606 14.09 13.635 -0.24038 7.1381 11.153 -0.24206 -0.24203 2.1895 26.581 26.583 73.68 30.311 -0.24471 225.1 -0.068852 -0.079061 275.91 21.109 19.213 1.4572e+06
0.25047 2589.7 3254.8 533.86 818.23 49.617 2012.5 229.2 25969 1013.6 512.09 5986.1 24143 1.3445e+05 37.98 52.085 112.97 66808 1.3364e+05 7423 37301 1759.6 8790.6 31.758 2763.2 2760.3 2486.9 25830 27915 493.51 5698.7 5827.5 46284 46344 4.8752e+05 5.4308e+05 36.393 33.014 2264 34.894 27869 28023 2610.1 1608.3 12820 181.48 185.04 450.1 43.834 4437.5 4440.2 10.459 23.713 24.326 24.787 123.9 69.881 258.46 117.32 32.438 29.256 697.28 712.71 749.09 482.9 6872.6 3246.8 478.62 700.7 498.38 494.31 64.025 179.27 16.853 35.157 81.26 78726 78568 50.486 48032 7050.5 34389 50.352 121.05 134.4 1213.9 1213.6 14.565 17.93 48.351 12.927 13.181 18.694 20.501 11.671 11.425 12.319 3.6646 4.9867 11.239 11.458 11.51 852.4 2743 2744.2 2763.7 1060.1 8.8298 8.8931 27.167 35.392 36.244 106.19 212.01 210.35 130.09 130.09 1531.8 550.94 2.1992 -0.12317 44.07 44.07 3.9368 20.288 20.272 50.623 17.239 15.533 15.105 15.38 92.035 92.069 -0.18357 27.644 27.559 2.0142 1.4413 1.5126 10916 5.8275 5.8487 36.095 26.923 27.234 27.138 -0.18883 -0.18881 4.6256 4.666 4.666 3.0418 15.169 14.861 -0.16638 -0.16087 20.088 20.088 1.606 1.6535 24.061 24.18 19.872 49.124 14.801 42.662 42.914 54.828 4.3025 4.3025 28.664 28.662 22.109 22.278 22.31 1.4445 -0.19846 -0.19846 415.88 32.424 32.418 660.94 152.82 152.54 152.53 552.65 718.93 719.76 5.1558 230.17 230.27 205.37 414.22 414.6 414.6 320.4 2328.1 2331.6 2335.8 444.35 384.69 347.64 208.33 209.31 76.66 121.33 121.73 49.558 70.727 26.997 58.033 57.655 45.63 50.131 50.28 134.18 107.62 107.62 137.07 58.012 58.118 56.352 79.362 86.583 87.039 79.317 70.813 70.772 259.37 117.33 117.08 31.536 89.671 90.201 57.418 100.24 100.25 261.23 80.421 57.692 64.929 65.086 280.93 59.299 59.101 45.796 66.554 50.81 159.52 159.72 378.03 43.83 44.164 44.202 -0.22703 2.0575 0.91849 -0.22871 -0.22871 -0.22871 -0.22926 -0.2298 1.613 1.578 1.4947 78.993 1.3337 1.2739 115.32 115.32 -0.23317 -0.085407 -0.0096707 -0.0097344 -0.050759 -0.17394 -0.174 1.4029 -0.2365 -0.23705 0.89854 1.0226 -0.054096 7.1767 7.2128 5.3306 6.6585 -0.24038 15.414 1.6972 -0.24206 -0.24203 20.469 19.862 7.8717 45.77 28.423 -0.25075 287.46 0.86922 -0.25882 323.53 18.062 12.299 1.4753e+06
0.49977 2543.9 3153.4 559.91 795.22 42.433 2383.1 195.04 26424 1048.7 522.06 5838.1 21478 1.2338e+05 22.964 54.042 94.097 62555 1.2687e+05 6800.1 35496 1746.1 8713.4 21.489 2824.7 2820 2444.5 25086 27035 401.05 5385.6 5493.9 45474 45535 4.7592e+05 5.3056e+05 22.084 54.109 2036.4 30.699 27713 27809 2595.2 1701.5 12481 121.53 126.92 298.95 68.504 4085.8 4072 23.491 15.66 15.648 15.647 160.34 115.54 246.12 127.26 31.189 32.578 684.59 700.63 708 428.88 6892.2 3296.9 513.74 703.45 456.49 454.39 37.072 189.93 28.054 26.649 45.863 76809 76618 55.842 47517 7238.2 34722 32.13 115.88 199.3 1189.5 1188 19.425 37.629 14.912 7.1116 7.2462 28.319 28.362 9.0569 9.3743 9.8599 10.648 10.582 1.0823 1.4437 2.7037 911.26 2642.6 2644 2664.5 1057.9 9.8813 10.471 22.696 57.559 56.271 116.42 188.74 187.29 135.39 135.51 1617.3 577.97 15.459 14.922 33.118 33.767 -0.18113 39.646 39.744 19.79 30.963 31.05 31.065 25.031 56.307 56.285 6.2427 12.649 12.669 6.3131 0.61129 0.45585 11508 12.437 12.352 40.427 8.3149 8.4655 16.158 1.4772 1.4772 6.2376 2.3095 2.3095 9.0929 22.798 23.511 6.5631 6.5655 9.377 9.377 -0.19253 -0.19253 34.908 34.923 25.323 44.299 14.509 74.923 74.716 22.74 16.597 16.597 31.665 31.679 10.062 10.062 10.062 -0.19792 1.682 1.682 475.86 84.764 84.763 652.71 99.623 99.39 99.378 500.41 750.52 751.64 26.407 367.87 367.88 226.95 507.7 510.21 510.24 290.6 2351.5 2353.6 2356.2 470.94 346.08 303.44 152.11 151.97 43.808 118.6 118.39 57.485 76.615 9.228 31.277 31.697 31.876 49.989 49.989 127.36 55.941 55.932 211.31 92.665 92.664 27.285 54.199 53.703 53.426 21.053 62.424 62.27 264.43 48.965 49.645 72.393 87.986 87.144 94.021 91.78 91.781 229.85 81.619 43.072 69.301 69.065 224.72 40.77 40.765 29.126 73.015 49.094 89.952 89.88 259.91 66.822 67.035 67.059 0.86792 3.5572 -0.22812 6.8611 6.8821 6.9844 -0.22926 6.6018 -0.23039 17.669 17.651 52.55 10.616 10.6 150.21 150.21 5.551 3.5748 -0.027635 0.070792 10.262 0.57609 0.55617 4.8104 0.39139 -0.23466 -0.23763 -0.23763 -0.23818 1.737 1.737 2.2839 4.8303 -0.24038 9.6374 3.0188 1.7336 1.7336 17.678 29.356 31.823 55.346 10.243 -0.055216 242.46 -0.25826 -0.25882 345.2 25.799 14.251 1.4327e+06
0.75061 2963.8 3144.3 505.12 879.76 31.98 2175.4 188.37 25785 1004.7 661.22 6330.8 22514 1.2488e+05 38.737 84.016 65.674 63349 1.2784e+05 7046.6 37333 1586.9 8652.3 40.2 2753.8 2750.7 2413 27057 29263 439.66 5401.2 5452.1 46002 46074 4.963e+05 5.5404e+05 118.49 68.129 2312.4 29.057 28325 28415 2708.1 1776.7 12949 192.8 195.79 322.67 41.564 4017.5 4002.6 9.3852 26.744 27.165 27.406 186.32 134.06 205.31 128.53 24.797 11.579 649.85 667.13 736.29 525.18 6869.3 3036.8 467.03 663.53 502.35 497.97 65.094 252.66 8.029 41.631 73.776 77814 77642 27.625 48473 7033.8 34174 41.461 85.241 114.01 1245.6 1246.1 8.8917 22.15 39.55 -0.17182 -0.17184 38.104 38.101 24.274 24.383 24.464 27.24 27.928 2.9445 2.9445 2.9445 913.48 2544 2545.3 2558.5 1083 19.407 20.789 8.3042 39.129 38.751 135.15 187.69 187.45 140.74 140.63 1570.2 517.79 37.588 2.7508 62.706 62.743 0.047358 51.466 51.49 43.341 84.913 85.177 85.064 30.426 54.734 54.733 1.7915 39.288 39.365 0.7423 -0.18569 -0.18569 11174 1.9081 2.0653 37.808 12.595 12.595 9.4267 13.48 13.475 1.3341 12.093 12.093 12.02 15.848 16.99 20.374 20.303 13.257 13.257 4.1328 4.1241 23.477 23.134 22.865 41.999 15.498 57.238 57.484 40.619 5.707 5.5976 45.426 45.427 5.5154 5.5154 5.5154 -0.19792 2.7845 3.0019 447.43 34.522 34.621 608.71 109.61 108.99 108.97 541.97 656.4 656.51 19.021 334.11 334.6 150.52 442.5 437.84 437.77 358.08 1984.7 1984.2 1982.7 372.23 343.1 368.06 201.12 202.91 67.469 135.83 135.51 26.431 80.011 55.223 61.735 62.924 68.87 92.377 92.928 133.75 110.64 110.64 173.61 51.399 51.35 26.27 56.656 53.906 53.602 39.054 72.894 72.99 301.64 64.916 65.472 84.411 91.751 91.964 67.187 84.26 84.252 270.78 108.79 97.089 81.091 81.166 265.99 79.951 79.851 45.036 64.777 44.828 76.955 76.993 323.6 101.88 102.1 102.13 5.2575 -0.17795 2.2802 2.1516 2.1516 2.1516 2.2463 4.5491 0.75629 1.6971 1.6971 83.893 2.5529 2.5529 207.09 207.09 0.6763 -0.23373 0.93207 0.93208 -0.23484 -0.2354 -0.2354 -0.23595 -0.2365 -0.23705 -0.23763 -0.23763 -0.23818 0.97525 0.97525 4.1405 6.1871 16.857 -0.24095 10.373 -0.24206 -0.24203 14.202 9.0839 13.641 38.994 29.441 -0.2499 216.32 -0.018434 -0.25882 261.66 25.459 20.012 1.4745e+06
1.0004 2700.2 3021.7 545.69 816.62 33.631 2399.7 211.82 25325 1026.8 602.18 6426.7 23203 1.313e+05 24.805 79.807 54.861 63155 1.2809e+05 6694.7 37317 1815 8579.5 47.702 2974.1 2969.1 2569.4 26716 28824 374.28 5458.5 5494.2 45812 45879 4.9651e+05 5.5435e+05 34.128 40.858 2103.7 6.0931 26415 26604 2751.1 1477.6 12819 101.27 104.47 357.28 54.889 4386.1 4373.5 20.97 24.318 24.857 25.258 199.69 119.32 182.63 85.843 89.204 61.982 694.69 710.82 678.57 518.32 6456.6 3077.9 505.56 675.62 510.75 503.86 64.333 312.99 27.78 36.865 68.145 76939 76752 36.823 46603 6747.1 34401 45.837 131.89 144.46 1157.9 1154.9 11.835 48.881 45.236 7.8296 7.9526 71 69.029 7.8963 7.874 7.8665 6.7565 6.0718 10.911 10.911 10.763 798.08 2564.1 2565.6 2591.8 1303.5 19.932 21.271 11.859 40.68 41.605 82.775 159.38 158.97 122.17 122.15 1664.9 550.59 5.613 4.2163 55.077 55.077 0.097244 34.43 34.283 20.03 36.324 35.837 35.7 13.174 59.457 59.471 -0.36833 41.112 41.186 -0.37037 1.1359 1.1599 11193 7.5793 7.7386 33.293 -0.37556 -0.37556 15.088 -0.37766 -0.37762 4.3178 -0.37976 -0.37975 4.237 33.46 34.315 4.0683 4.0683 24.415 24.501 -0.24024 -0.2082 36.973 36.84 15.417 31.909 17.568 70.476 71.166 51.258 6.3662 6.287 18.751 18.751 8.4839 8.4677 8.4584 -0.39584 5.1557 5.1329 316.29 46.367 46.551 624.17 107.97 109.88 109.92 506.78 630.05 629.26 25.267 360.75 360.9 169.1 481.19 485.21 485.27 415.18 2125.2 2126.1 2126.7 400.05 320.6 292.66 199.39 199.34 43.936 99.599 99.354 24.398 115.65 62.865 37.631 38.327 39.22 44.332 44.351 161.45 62.742 62.752 116.82 80.26 80.081 47.89 68.5 65.87 65.631 57.916 105.43 105.43 238.3 69.582 69.403 120.98 91.104 90.807 100.47 59.007 59.007 266.13 100.78 64.989 83.779 83.812 298.99 57.078 57.12 25.629 59.189 82.846 58.208 58.433 385.15 31.131 30.66 30.615 0.29152 -0.301 -0.083552 -0.25089 -0.25095 -0.25121 9.6146 -0.33567 -0.17229 -0.36428 -0.36465 83.528 0.82127 0.82127 135.84 135.84 -0.41779 -0.31639 -0.38919 -0.3894 4.2228 -0.34874 -0.34865 -0.22785 -0.2549 -0.27194 -0.46483 -0.46499 -0.47635 1.0283 1.1486 -0.42498 2.7143 9.3443 16.652 6.9764 -0.48411 -0.48406 20.201 15.557 13.654 28.024 31.58 -0.5015 245.55 -0.2784 2.3475 298.81 4.2553 10.126 1.4711e+06
1.2497 2763.4 3272.1 598.66 858.62 49.651 2290.1 150.87 25976 1032.2 508.99 6057.2 21458 1.2134e+05 31.028 49.336 72.631 60253 1.2274e+05 6553.6 36071 1726.6 8418.4 34.956 2789 2786.8 2513.4 25639 27509 448.02 5538.3 5575.7 44649 44717 4.8023e+05 5.3591e+05 65.251 78.685 1963.1 42.775 25948 26070 2425.6 1729.4 12185 111.15 113.75 270.57 28.165 4146.8 4137.9 17.637 8.9024 8.8502 8.7553 128.48 87.823 210.85 88.204 13.8 15.963 687.3 700.76 690.65 351.71 6815.9 3280.8 568.41 624.99 526.76 524.3 59.877 198.71 22.995 3.4177 58.082 76998 76821 46.56 46521 6873.5 33391 31.236 151.66 190.27 1279 1277.6 27.479 9.7442 61.43 -0.1114 0.16583 29.918 30.842 8.9741 10.583 15.448 13.371 13.679 7.03 7.03 7.03 876.02 2664.1 2665.4 2688.4 1148 21.568 21.766 31.514 69.409 68.461 67.561 161.05 160.06 141.65 141.57 1448.4 591.28 11.193 5.4276 41.661 42.213 -0.25056 15.144 15.19 34.567 44.028 44.026 44.024 43.602 46.025 46.016 -0.36833 22.004 21.536 3.0565 3.6038 3.6038 11163 3.9111 3.9111 37.534 -0.37556 -0.37556 12.949 -0.37766 -0.37762 11.617 5.5473 5.5473 9.7567 9.0178 9.0204 14.149 14.041 9.2088 9.2088 -0.38505 -0.38505 34.217 34.185 17.679 61.966 10.753 36.018 36.863 29.342 9.8191 9.819 46.641 46.642 7.5819 7.6461 7.6584 -0.39584 1.1979 1.197 417.13 36.264 36.344 583.96 107.93 108.08 108.08 537.65 711.18 713.58 14.092 304.04 303.99 227.81 437.84 438.13 438.13 282.99 2059.6 2060.7 2061.3 381.11 325.13 317.13 190.79 192.26 60.162 99.599 99.897 30.581 66.212 27.536 56.683 57.355 47.113 35.795 36.605 198.21 80.428 80.428 205.39 56.538 56.444 53.162 71.978 86.305 86.806 60.029 85.338 85.321 246.83 82.192 82.353 53.146 104.59 104.84 76.698 69.195 69.192 228.37 95.63 87.163 65.931 65.512 275 45.336 45.466 29.41 79.707 45.542 94.722 94.663 355.29 74.382 74.212 74.195 4.4256 -0.45516 -0.45624 0.89941 0.89941 0.89941 -0.45852 3.6108 2.3263 -0.46186 -0.46186 70.407 2.2971 2.2971 145.71 145.71 -0.46635 -0.46746 -0.46858 -0.46858 -0.46969 -0.45452 -0.45448 -0.37313 -0.4108 6.3597 -0.46826 -0.4683 -0.47635 -0.4248 -0.42473 2.5233 4.5804 13.444 18.918 -0.48298 0.61084 0.61089 8.3742 23.817 11.347 18.107 25.156 -0.1748 310.56 -0.43345 -0.40216 197.63 9.0992 8.4942 1.4254e+06
1.5009 2530.9 3277.2 535.16 874.34 46.659 2165.3 213.91 25646 1054.7 563.13 5912.4 22072 1.265e+05 56.057 69.615 89.237 61660 1.2532e+05 7194 37124 1754.9 8499.8 40.328 2916.4 2912.4 2533.2 26085 27991 333.59 5632.6 5731.9 46385 46453 4.9314e+05 5.504e+05 92.657 85.498 2183.3 49.066 27167 27303 2766.4 1497.9 12083 106.7 113.7 313.3 56.049 4302.2 4278.9 16.016 40.34 40.127 40.009 162.87 120.13 199.4 81.536 22.239 9.0054 591.97 607.5 714.9 420.46 7017.2 3320.8 478.29 707.43 479.61 479.25 75.2 242.03 28.318 37.357 71.183 76649 76460 22.673 47457 6836.8 34243 2.5048 144.1 203.19 1137.6 1133.9 18.213 33.27 41.765 -0.17182 -0.17184 36.434 38.069 5.3802 5.1124 4.4155 1.6217 2.103 7.3007 7.2546 7.233 825.28 2652.8 2654.1 2679.1 1197.9 10.53 10.674 27.581 64.697 65.156 124.83 173.44 173.76 122.45 122.15 1629.8 518.81 14.211 20.324 29.618 29.611 10.876 24.943 24.867 17.662 35.537 35.675 35.699 25.38 44.886 44.811 -0.18417 15.369 16.005 -0.18519 5.0574 5.1868 11864 1.8393 1.8449 33.144 14.504 15.255 2.1206 5.6179 5.5947 1.2151 14.349 14.259 2.6694 12.581 12.409 7.9017 7.9017 8.3113 8.4327 -0.19253 -0.19253 27.182 29.525 7.9027 26.84 17.093 24.797 25.181 60.949 8.8252 8.8252 35.89 35.89 24.939 24.939 24.939 1.5476 3.3244 3.3244 318.6 49.188 49.521 569.74 146.45 147.14 147.15 646.35 703.9 705.96 8.521 350.36 351.63 159.86 435.81 437.15 437.18 309.68 2270.4 2272.4 2274.8 340.26 317.45 347.15 109.08 109.43 72.236 135.28 136.59 27.819 93.057 54.197 55.652 55.738 47.407 56.087 56.497 151.81 90.107 90.104 131.23 74.551 74.478 51.404 50.011 56.374 56.319 60.614 91.558 91.576 193.19 57.777 57.423 91.36 35.618 35.418 91.251 81.034 81.033 229.14 121.33 64.406 85.288 84.296 312.39 43.304 43.499 38.397 54.749 62.853 97.104 96.917 289.2 50.93 50.96 50.963 5.4396 2.0575 5.8497 -0.22869 -0.22869 -0.22869 9.1304 0.67473 -0.056425 6.315 6.315 87.951 -0.23205 -0.23205 158.49 158.49 -0.23317 -0.23373 -0.23429 -0.23429 -0.23484 -0.2354 -0.2354 3.3158 2.12 -0.23705 -0.23763 -0.23763 -0.23818 -0.23872 -0.23872 6.4018 1.8787 2.9017 13.863 8.3765 4.7328 4.7329 25.761 16.234 15.014 57.329 22.072 -0.20508 239.91 -0.25826 -0.25882 294.28 37.888 4.1646 1.4637e+06
1.7505 2609.8 3382.4 632.49 887.21 48.192 2309.9 184.4 26558 1165.7 584.58 6565.1 20275 1.1737e+05 30.334 72.185 46.695 60324 1.2209e+05 7041.6 37735 1869.4 8603.1 25.443 3027.2 3026.4 2686.4 27043 29183 434.53 5440.8 5550.6 46450 46508 5.0762e+05 5.6661e+05 35.892 51.557 2162.3 33.213 27143 27287 2625.7 1528.3 13295 116.74 121.63 326.16 44.222 4225.3 4220.5 7.4196 23.493 23.512 23.522 144.83 96.585 206.94 102.71 45.325 24.087 743.79 765.33 759.07 551.82 6779.9 3114.6 481.62 657.13 464.89 465.11 64.512 165.42 27.947 19.032 49.501 76654 76480 10.59 47962 7427.9 33780 9.0017 116.66 138.01 1121.2 1121.4 17.829 22.979 63.413 3.0618 3.0636 43.05 44.22 17.266 17.865 19.285 6.6272 6.9895 6.6824 5.9778 5.2981 912.29 2725.9 2727 2739.8 1175.7 14.609 14.671 16.061 42.465 41.431 105.43 148.24 148.09 202.21 202.09 1613.1 472.58 26.589 9.2919 49.245 49.603 5.365 9.3764 9.4855 63.988 53.866 53.159 52.994 27.416 58.505 58.497 8.1846 32.182 32.519 -0.12879 -0.18569 -0.18569 11093 4.3625 4.1883 39.205 11.555 10.914 11.019 7.4996 7.4997 18.127 0.099485 -0.026813 19.697 28.731 28.729 15.646 15.671 14.161 14.187 3.8778 3.8778 18.583 19.807 27.394 14.635 24.448 73.034 73.103 37.205 17.226 17.241 38.442 38.441 11.774 11.249 11.113 -0.19792 3.9165 4.0612 428.03 57.452 57.452 648.81 105.16 105.43 105.45 523.37 653.44 654.21 5.9389 330.68 329.74 201.92 429.44 432.16 432.2 304.95 2175.7 2179.3 2183.9 404.14 290.31 277.86 158.6 158.78 46.999 100.14 98.919 19.876 78.703 25.29 45.012 44.851 51.719 62.893 63.397 113.26 58.416 58.41 127.37 50.23 50.254 58.589 59.96 61.308 60.734 35.085 74.966 75.023 198.37 51.627 51.837 76.579 88.262 88.148 70.165 93.865 93.862 247.06 130.25 58.247 84.977 85.667 259.33 23.129 23.113 38.472 65.281 31.422 61.855 61.676 309.72 43.881 43.483 43.445 -0.22703 -0.22758 0.45912 10.711 10.707 10.683 3.0189 9.5249 5.4824 5.7913 5.7913 67.947 -0.23205 -0.23205 173.98 173.98 -0.23256 -0.22985 -0.23238 -0.23238 1.0012 -0.2354 -0.2354 -0.23595 -0.2365 -0.23705 1.5714 1.5714 -0.23818 5.855 5.8549 1.546 9.678 -0.15546 24.063 2.0436 3.9473 3.9474 11.935 18.933 17.299 59.336 41.395 -0.25075 231.95 -0.25826 3.7877 254.48 11.678 7.7054 1.4723e+06
2.0006 2753.9 3177.3 564.67 924.26 16.453 2262.1 69.213 26048 1112.5 521.65 6365.3 21380 1.2286e+05 16.94 93.082 113.64 61549 1.2722e+05 6590.8 36233 1742.2 9174.2 26.075 2959.5 2954.5 2618.8 24616 26796 394.21 5494.3 5634.6 46319 46389 4.8135e+05 5.3886e+05 34.752 68.017 1976.5 42.812 27576 27678 2718.4 1604.4 12370 130.7 136.42 470.56 26.608 4115.2 4088 15.383 45.787 45.88 46.036 164.5 88.133 171 76.539 18.538 12.566 796.66 813.1 732.09 428.59 7319.9 3567.5 494.46 646.14 575.53 570.32 37.357 187.28 15.637 14.562 71.35 77812 77650 41.8 47919 7199.8 34361 39.199 108.29 143.04 1159 1155.1 43.426 18.009 27.719 0.94693 0.94691 16.892 17.237 5.7382 5.8755 5.9781 9.9186 13.691 2.2066 2.2066 2.2065 962.88 2468.5 2469.4 2489.3 1196.4 20.587 21.314 23.446 51.189 49.574 116.63 217.66 217.33 218.36 218.16 1418.4 537.53 23.249 9.8303 58.791 58.595 1.6279 19.265 19.496 56.372 53.827 53.817 53.807 20.05 35.305 35.29 -0.041357 19.953 21.964 -0.18519 -0.033381 0.078599 11239 2.2824 2.2819 31.288 -0.14311 -0.016988 20.092 8.1678 8.1713 -0.18934 9.3163 9.4518 7.3348 14.945 15.07 8.0896 8.0937 12.59 12.59 2.9019 2.9019 52.143 52.12 21.585 39.387 31.426 44.365 45.303 65.573 8.2113 8.2895 34.69 34.689 9.562 9.562 9.562 0.066434 13.466 14.072 368.14 46.887 46.811 708.89 135 135.98 136.01 467.05 600.28 600.54 7.3167 314.15 314.23 229.49 547.13 545.92 545.89 283.42 2005.2 2007.5 2010.1 437.63 241.95 375.27 190.37 191.96 50.474 138.96 138.79 29.727 84.694 41.921 68.616 69.044 34.999 33.189 33.617 103.78 115.32 115.32 155.55 67.337 67.01 53.39 63.745 62.254 62.145 38.961 53.496 53.484 294.43 47.472 47.404 51.494 88.908 89.469 41.911 103.88 103.89 285.61 103.22 65.957 62.706 62.988 259.14 53.706 53.605 26.881 68.707 35.943 93.334 93.189 355.42 55.331 55.276 55.272 0.98694 -0.21699 -0.2151 1.1519 1.1519 1.1519 1.5484 3.6025 -0.23039 9.8119 9.8235 98.13 -0.23205 -0.23205 188.76 188.76 1.3616 -0.23373 6.0628 5.8643 -0.16478 -0.069587 -0.069615 -0.17649 5.2743 -0.23705 -0.23703 -0.23763 -0.23818 1.5245 1.5245 -0.23815 8.9294 7.1622 7.9236 19.491 -0.24206 -0.24203 25.23 23.14 23.45 69.446 24.962 -0.069977 309.57 -0.25826 -0.25882 346.97 30.708 24.13 1.447e+06
2.2502 2627.5 3144.1 555.18 825.01 51.206 2418 177.55 25082 1024.1 536.31 6392.6 22755 1.257e+05 45.703 39.046 142.73 61313 1.2591e+05 6944.3 37247 1793.8 9207.1 36.894 2789 2786.3 2484.5 26384 28595 477.87 5300.3 5318.9 46480 46550 4.9145e+05 5.4997e+05 48.12 55.568 2072 12.26 27182 27309 2582.1 1602.9 12170 159.38 162.9 383.59 38.139 4295 4289.8 18.506 7.2483 7.1535 7.2034 190.1 118.47 252.43 126.6 39.544 40.704 740.62 756.59 736.77 469.65 7334.2 3418.7 519.46 640.66 467.73 464.08 15.097 239.58 19.475 26.09 67.03 78594 78432 28.433 47304 7354.2 33926 48.733 100.61 158.72 1148.9 1149 31.938 16.723 30.713 12.386 12.625 61.447 63.39 13.042 13.652 14.837 14.282 19.089 2.5749 3.6916 6.3793 894.55 2677.3 2678.5 2701.7 1211.6 6.4148 6.4526 14.756 42.431 42.837 171.55 156.94 155.97 177.86 177.72 1627.2 550.02 12.888 6.6752 27.555 26.975 -0.18113 23.425 23.134 37.02 43.439 43.61 43.636 24.867 80.997 80.997 -0.18417 25.598 25.602 -0.18519 -0.18569 -0.18569 11465 5.043 5.1845 34.144 12.343 11.776 11.48 -0.18883 -0.18881 3.2145 6.0841 5.9737 8.6049 16.567 16.567 8.29 8.2999 28.763 28.489 1.0691 1.0691 48.437 48.418 30.632 65.781 12.597 26.416 26.803 70.482 9.8725 9.8725 11.761 11.761 11.897 12.769 12.955 -0.19792 4.9536 5.2478 363.42 69.935 69.491 514.54 84.483 86.486 86.553 562.32 645.78 647.58 19.214 306.19 306.19 205.98 477.77 476.33 476.29 372.92 2278.8 2280.3 2281.6 399.07 339.29 298.14 224.4 225.27 50.237 114.46 113.81 26.062 71.872 42.449 62.53 62.435 42.523 48.237 50.752 117.16 78.213 78.221 161.02 67.569 68.215 30.402 68.933 69.649 69.592 42.361 66.682 66.782 273.89 60.202 60.079 18.815 58.815 58.274 98.486 94.235 94.234 333.02 90.13 72.165 65.136 65.045 254.92 63.002 63.005 42.362 86.061 45.266 101.88 101.55 292.09 51.012 51.036 51.04 -0.22703 -0.22758 -0.22812 3.9369 3.9369 3.9369 2.7462 -0.2298 -0.23039 3.5538 3.5538 83.504 5.2189 5.2189 173.61 173.61 3.1528 -0.17036 -0.23429 -0.23429 3.3859 -0.21862 -0.2186 -0.21509 4.5546 -0.19276 -0.17082 -0.17091 0.82232 3.2262 3.4149 2.0655 7.7372 -0.24038 13.851 5.1143 -0.24206 -0.24203 21.68 38.342 7.2746 59.917 51.873 -0.25075 266.74 -0.25826 -0.25882 247.71 3.043 13.331 1.4658e+06
T2 = readtable('SMP_3.8.1.csv', 'VariableNamingRule','preserve')
T2 = 260×305 table
t_elapsed_Buf '[23Na]+' '[24Mg]+' '[25Mg]+' '[26Mg]+' 'C2H2+' '[27Al]+' 'C2H3+' '[28Si]+' 'N2+' '[29Si]+' 'HN2+' '[30Si]+' 'NO+' '[31P]+' '[15N]O+' 'NOH+' '[32S]+' 'O2+' '[33S]+' 'O2H+' '[34S]+' 'O[18O]+' '[35Cl]+' '[36S]+' '[36Ar]+' 'HCl+' '[37Cl]+' '[36Ar]H+' '[38Ar]+' '[39K]+' '[38Ar]H+' '[40Ar]+' '[40Ca]+' '[41K]+' 'ArH+' '[42Ca]+' 'ArH2+' '[43Ca]+' '[87Sr]++' '[88Sr]++' '[44Ca]+' 'CO2+' '[45Sc]+' 'CHO2+' '[46Ti]+' '[46Ca]+' 'NO2+' '[47Ti]+' '[48Ti]+' '[48Ca]+' '[49Ti]+' '[50Ti]+' '[50Cr]+' '[50V]+' '[51V]+' 'ClO+' '[52Cr]+' '[36Ar]O+' '[53Cr]+' '[37Cl]O+' '[54Cr]+' '[54Fe]+' 'ArN+' '[55Mn]+' '[56Fe]+' 'ArO+' '[57Fe]+' 'ArOH+' '[58Fe]+' '[58Ni]+' '[59Co]+' '[60Ni]+' '[61Ni]+' '[62Ni]+' '[63Cu]+' '[64Ni]+' '[64Zn]+' '[65Cu]+' '[66Zn]+' '[67Zn]+' '[68Zn]+' '[137Ba]++' '[69Ga]+' '[138Ba]++' '[70Ge]+' '[70Zn]+' '[71Ga]+' '[72Ge]+' '[73Ge]+' '[74Ge]+' '[74Se]+' '[75As]+' 'ArCl+' '[76Se]+' '[76Ge]+' 'Ar[36Ar]+' '[77Se]+' 'Ar[37Cl]+' '[78Se]+' '[78Kr]+' 'Ar[38Ar]+' '[79Br]+' '[80Kr]+' '[80Se]+' 'Ar2+' '[81Br]+' '[82Kr]+' '[82Se]+' '[83Kr]+' '[84Kr]+' '[84Sr]+' '[85Rb]+' '[86Sr]+' '[86Kr]+' '[87Sr]+' '[87Rb]+' '[88Sr]+' '[89Y]+' '[90Zr]+' '[91Zr]+' '[92Zr]+' '[92Mo]+' '[93Nb]+' '[94Mo]+' '[94Zr]+' '[95Mo]+' '[96Mo]+' '[96Ru]+' '[96Zr]+' '[97Mo]+' '[98Ru]+' '[98Mo]+' '[99Ru]+' '[100Ru]+' '[100Mo]+' '[101Ru]+' '[102Ru]+' '[102Pd]+' '[103Rh]+' '[104Pd]+' '[104Ru]+' '[105Pd]+' '[106Pd]+' '[106Cd]+' '[107Ag]+' '[108Pd]+' '[108Cd]+' '[109Ag]+' '[110Cd]+' '[110Pd]+' '[111Cd]+' '[112Cd]+' '[112Sn]+' '[113In]+' '[113Cd]+' '[114Sn]+' '[114Cd]+' '[115Sn]+' '[115In]+' '[116Sn]+' '[116Cd]+' '[117Sn]+' '[118Sn]+' '[119Sn]+' '[102Sn]+' '[120Te]+' '[121Sb]+' '[122Te]+' '[122Sn]+' '[123Sb]+' '[123Te]+' '[124Te]+' '[124Sn]+' '[124Xe]+' '[125Te]+' '[126Te]+' '[126Xe]+' '[127I]+' '[128Xe]+' '[128Te]+' '[129Xe]+' '[130Xe]+' '[130Te]+' '[130Ba]+' '[131Xe]+' '[132Xe]+' '[132Ba]+' '[133Cs]+' '[134Ba]+' '[134Xe]+' '[135Ba]+' '[136Ba]+' '[136Ce]+' '[136Xe]+' '[137Ba]+' '[138Ba]+' '[138Ce]+' '[138La]+' '[139La]+' '[140Ce]+' '[141Pr]+' '[142Nd]+' '[142Ce]+' '[143Nd]+' '[144Nd]+' '[144Sm]+' '[145Nd]+' '[146Nd]+' '[147Sm]+' '[148Sm]+' '[148Nd]+' '[149Sm]+' '[150Sm]+' '[150Nd]+' '[151Eu]+' '[152Sm]+' '[152Gd]+' '[153Eu]+' '[154Gd]+' '[154Sm]+' '[155Gd]+' 'CeO+' '[156Gd]+' '[156Dy]+' '[157Gd]+' '[158Gd]+' '[158Dy]+' '[159Tb]+' '[160Dy]+' '[160Gd]+' '[161Dy]+' '[162Dy]+' '[162Er]+' '[163Dy]+' '[164Dy]+' '[164Er]+' '[165Ho]+' '[166Er]+' '[167Er]+' '[168Er]+' '[168Yb]+' '[169Tm]+' '[170Yb]+' '[170Er]+' '[171Yb]+' '[172Yb]+' '[173Yb]+' '[174]Yb+' '[174Hf]+' '[175Lu]+' '[176Hf]+' '[176Yb]+' '[176Lu]+' '[177Hf]+' '[178Hf]+' '[179Hf]+' '[180Hf]+' '[180W]+' '[180Ta]+' '[181Ta]+' '[182W]+' '[183W]+' '[184W]+' '[184Os]+' '[185Re]+' '[186Os]+' '[186W]+' '[187Os]+' '[187Re]+' '[188Os]+' '[189Os]+' '[190Os]+' '[190Pt]+' '[191Ir]+' '[192Pt]+' '[192Os]+' '[193Ir]+' '[194Pt]+' '[195Pt]+' '[196Pt]+' '[196Hg]+' '[197Au]+' '[198Hg]+' '[198Pt]+' '[199Hg]+' '[200Hg]+' '[201Hg]+' '[202Hg]+' '[203Tl]+' '[204Pb]+' '[204Hg]+' '[205Tl]+' '[206Pb]+' '[207Pb]+' '[208Pb]+' '[209Bi]+' '[220Bkg]+' '[232Th]+' '[234U]+' '[235U]+' '[238U]+' 'ThO+' 'UO+' TotalIonCurrent
_____________ _________ _________ _________ _________ ________ _________ _______ _________ ______ _________ ______ _________ _____ ________ _________ ______ ________ _____ ________ ______ ________ _________ _________ ________ _________ ______ _________ __________ _________ ________ __________ _________ _________ ________ ______ _________ _______ _________ __________ __________ _________ ______ _________ _______ _________ _________ ______ _________ _________ _________ _________ _________ _________ ________ ________ ______ _________ __________ _________ __________ _________ _________ ______ _________ __________ __________ _________ _______ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ ___________ _________ ___________ _________ _________ _________ _________ _________ _________ _________ _________ _______ _________ _________ ___________ _________ ___________ _________ _________ ___________ _________ _________ _________ ______ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ ________ _________ _________ _________ _________ _________ _________ _________ _________ __________ __________ _________ _________ _________ _________ _________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ _________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ ______ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ _________ __________ __________ _________ _________ _________ __________ __________ __________ _________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ ___________ __________ _________ _________ _________ ______ ______ _______________
0 6642.9 428.69 75.116 77.048 55.084 4846.4 106.22 23445 1127.5 1673.8 18646 14272 61682 39.826 112.25 120.23 25200 56562 1341.2 6017.3 1066.8 5599.2 14.082 861.23 862.26 809.15 8118.8 9105.6 207.07 9554.5 9974.5 52433 52510 557.82 631.23 6.9076 4.4274 154.41 0 5878.8 5910.2 713.3 726.06 6066.3 17.138 20.219 168.49 38.758 938.38 945.4 10.239 13.667 13.304 13.042 24.818 22.584 400.57 220.47 74.116 42.504 2857.9 2859.6 1251.5 948.78 55237 31283 1439.2 528.58 641.89 641.19 33.482 187 2.2264 25.254 377.8 2920.3 2913.6 218.6 1676.4 339.64 1232.2 9.3806 73.534 97.685 50.024 50.136 14.088 28.81 22.652 26.852 27.187 8.5967 7.7123 0 0 0 0 0 1.0502 0.593 0.17236 282.23 382.44 382.73 394.04 488.59 19.394 19.397 4.6878 22.928 22.157 182.68 86.834 85.777 161.57 161.61 815.57 40.413 134.37 53.61 54.896 54.848 0 40.37 40.207 4.3846 43.962 45.102 45.265 16.73 10.372 10.378 0 7.2505 7.2841 0 0 0 10668 0 0 14.085 0 0 14.049 2.1294 2.0879 23.707 5.6093 5.6093 0 0 0 0 0 4.5564 4.5637 0 0 12.427 12.313 1.7881 40.573 11.867 23.116 22.606 20.402 13.304 13.253 7.484 7.4857 17.543 17.562 17.563 0 0 0 171.4 33.19 32.997 649.49 122.07 122.09 122.09 624.42 936.73 938.19 118.17 452.98 452.3 232.21 503.88 502.63 502.59 318.2 1976.1 1977.9 1979.7 55.026 162.14 16.62 49.705 49.533 23.329 35.306 35.41 24.951 34.72 12.626 24.979 24.441 7.1787 23.703 23.284 13.439 38.778 38.791 3.6987 19.547 19.547 18.886 30.839 32.615 32.519 21.629 14.696 14.654 4.0117 10.554 11.686 0 12.181 12.237 14.304 15.267 15.267 2.8904 4.8255 3.6987 1.3962 1.3962 0 11.709 11.709 0 5.5304 0 0 0 1.2247 5.7808 5.7808 5.7808 6.6626 6.6133 0 14.42 14.408 14.338 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.13981 0.12767 1.7331 0 0 0 0 0 0 0 12.076 1.0533 0 8.9308 0 7.8629 7.8629 0 101.77 67.678 193.04 12.954 0 35.752 0 0 12.356 9.7245 0 4.4568e+05
0.2501 6836 1089.5 228.91 257.78 13.927 10878 127.03 28625 1330.1 1914.8 17527 13752 59012 112.12 170.25 60.93 23844 55128 1478.1 6516.5 1244.4 5096.5 17.422 837.06 836.18 741.21 7804.9 8735.5 190.7 10303 10702 50520 50602 575.52 712.64 1.3437 1.5176 152.44 0 5731.9 5737.4 557.16 851.89 6005.2 81.796 86.5 236.83 45.27 1372.7 1371 61.23 29.743 29.734 29.728 99.824 56.624 328.08 204.29 71.954 46.949 6899.2 6903.5 3018.8 1371.5 1.3282e+05 75172 3662.8 1172.4 667.56 664.77 45.497 99.138 2.3681 19.928 475.19 2924.4 2926.9 215.93 1530.4 238.75 1177.1 0 195.14 246.34 74.265 74.585 30.624 41.07 47.837 3.4293 3.4293 21.163 19.16 0 0 0 0 0 0 0 0 452.74 506.88 507.31 513.81 482.66 18.092 18.545 14.954 53.023 53.262 326.87 130.12 130.11 226.6 226.54 1004.4 55.15 28.219 2.1161 0 0 0 15.699 15.661 0 2.5965 2.5965 2.5965 4.5316 6.742 6.7232 4.9344 0 0 0 0 0 10529 1.8457 1.9041 0 0 0 8.636 3.0374 3.0374 41.457 0 0 0 12.027 12.027 3.6919 3.6611 11.766 11.771 0 0 20.28 20.208 7.1525 12.93 1.9583 45.947 45.449 51.388 0 0 19.409 19.407 7.1017 7.3227 7.3591 1.3717 0 0 158.01 52.779 52.942 751.64 131.71 132.68 132.71 620.04 895.44 895.98 217.62 486.2 486.63 318.34 695.8 697.32 697.34 570.94 4140.2 4141.6 4141.8 50.033 197.94 40.01 133.41 132.84 25.671 49.426 49.453 22.253 43.631 15.954 26.468 26.144 4.8255 14.659 14.824 14.099 11.488 11.488 8.3605 28.229 28.273 14.942 24.372 24.372 24.372 32.497 17.685 17.785 11.482 3.3803 3.3803 1.1023 9.7526 9.7804 18.861 15.309 15.309 13.399 13.013 3.2317 0 0 0 3.7967 3.7967 0 0 4.0662 0 0 3.4046 0 0 0 0 0 0 1.4777 1.4707 1.4326 2.7434 4.3356 3.0062 2.3616 2.2328 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.6107 9.8959 9.8959 2.7924 8.4752 0 5.6962 13.742 12.449 12.484 12.707 486.51 328.63 733.5 8.8427 0 2.6644 0 0 0 0 0 5.566e+05
0.49998 6955.1 1346.4 193.51 317.94 20.993 12894 99.105 25944 1308.6 1584.4 17867 13232 56886 56.622 166.48 107.17 23435 54086 1338.8 5977 1160.5 5100.6 22.018 853.98 853.03 749.84 8089.4 9132.5 172.51 11202 11670 52201 52296 612.75 795.97 3.3068 2.6851 147.12 2.3839 5845.9 5869.2 587.18 785.4 6108.6 79.941 82.308 187.24 77.996 1176.3 1171.8 33.68 18.877 19.315 19.562 51.552 32.444 317.91 206.26 27.656 14.401 9763.7 9771.2 4293.8 1394.3 1.7292e+05 1.0474e+05 4843.8 1672.3 1017 1010.4 34.933 113.02 6.058 8.0039 518.81 2660.6 2666.4 285.05 1740.2 257.43 1171 7.5934 225.39 310.94 84.444 84.762 9.7722 17.668 55.228 7.6186 7.7465 37.247 36.027 0 0 0 0 0 1.1513 1.1513 1.1513 358.45 356.44 356.67 364.45 477.61 6.2006 6.2217 12.762 28.016 28.937 338.5 267.68 267.62 414.04 413.85 2823.3 66.697 23.815 17.93 5.0215 5.0215 0 12.395 12.196 14.638 6.8253 6.6033 6.5049 0 21.141 21.156 0 0 0 1.6657 0 0 9656 0 0 0.11949 1.2845 1.7812 20.012 3.3803 3.3803 9.7003 10.116 10.116 0 0.90129 1.3415 0 0 3.2333 3.2333 0 0 13.717 13.717 5.4869 28.63 2.946 11.448 11.68 10.435 0 0 0 0 9.5274 10.275 10.489 0 9.0579 9.0618 133.27 75.462 75.259 809.19 143.52 143.7 143.7 551.93 809.4 811.46 204.41 382.64 382.9 352.61 743.79 743.92 743.92 751.96 4481.2 4483.2 4483.8 90.589 216.52 60.069 62.755 63.271 56.951 55.828 55.942 35.851 24.543 10.655 29.656 30.021 2.0331 13.792 13.496 15.923 22.192 22.192 25.313 31.206 31.206 10.233 1.3227 1.3227 1.3227 7.5934 7.7806 7.8654 31.157 9.8991 9.9053 0 8.0321 7.7549 13.05 11.703 11.702 14.109 5.2419 1.6986 1.1023 1.1023 1.9596 2.1554 2.1549 1.2737 3.4471 0 5.7688 5.7474 5.1929 0 0 0 0 2.4985 0 0 0 0 0 0 0 0.90631 0.90631 0 3.079 3.0619 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4.1886 4.1886 0 13.343 13.438 0 246.11 210.54 518.77 18.273 0 36.56 0 0 7.7894 0 1.2247 6.1337e+05
0.75037 6975.8 914.77 186.19 177.04 10.617 18273 102.44 31719 1634.8 1973.1 17060 14364 61540 77.132 99.988 156.8 23596 53974 1226.8 5777.5 1160.5 5218 23.693 1038.6 1040.3 968.43 7738.1 8902.3 143.62 11245 11812 51212 51297 649.87 837.97 5.6828 4.2081 179.77 6.6729 6064.7 6110.7 771.24 831.75 5684.9 306.01 307.91 131.1 277.92 3167.6 3177 240.58 196.39 194.31 192.36 142.8 110.5 515.56 301.34 63.669 22.093 9248.7 9251 4133.9 1781.2 1.6922e+05 1.0147e+05 4791.3 1671.5 910.6 901.1 42.556 102.17 15.04 44.627 732.52 3068.5 3066.4 341.32 1779.1 257.73 1273.6 27.064 177.85 211.07 42.738 42.976 41.602 18.377 52.48 0 0 32.777 30.891 1.6657 1.6657 1.6657 0 0 0 0 0 408.28 460.07 460.47 467.61 401.46 21.286 21.281 9.7582 26.947 26.88 395.19 138.53 138.25 318.01 317.99 1217.8 64.122 11.488 2.9664 2.229 2.229 5.3399 7.8384 7.837 10.557 1.8371 1.8371 1.8371 4.0172 2.327 2.327 0 0 0 0 4.2621 4.2621 10067 0.087707 0.1468 2.1447 2.1066 2.1066 20.746 0 0 8.8427 2.4005 2.4005 2.572 3.3068 3.3068 2.2534 2.2535 0 0 5.9377 5.9288 5.1575 5.0075 6.8813 42.381 5.2665 37.505 37.335 10.304 7.6555 7.6533 40.802 40.812 16.167 16.167 16.167 0 0 0 171.71 37.473 37.518 803.69 110.69 110.37 110.36 600.38 746.55 747.33 280.58 388.03 389.63 363.2 697.63 700.31 700.34 671.37 4014.3 4015.9 4016.8 84.798 297.26 71.821 103.92 104.1 39.783 46.759 46.622 33.75 53.622 18.771 22.094 21.748 14.869 13.89 14.667 10.194 37.261 37.271 6.2462 23.261 23.393 18.99 11.395 12.118 12.098 0.24667 26.864 26.859 10.908 26.528 26.528 6.9251 11.243 11.243 9.3768 17.582 17.579 1.6657 5.7073 0 0 0 0 0 0 0 1.0133 0.54563 8.0577 8.1798 5.1193 0 0 0 0 0 0 1.3472 1.3472 1.3472 0 17.164 0 0 0 0 -0.011359 0.0021058 0 0 0 0 1.0778 1.0778 1.6154 0 0 1.3962 2.0938 1.5922 2.523 2.523 0 0 0 1.3471 1.5159 2.278 7.4147 5.5603 24.061 24.039 5.7073 478.15 354.97 989.58 30.951 0 31.552 0 0 2.9884 6.3932 0 6.2979e+05
1.0003 6740 929.34 215.91 308.23 21.241 9097.8 101.62 26946 1392.9 1624.9 18123 13473 57804 48.885 259.37 82.058 23735 54422 1183.2 6571.6 1084 5206.8 22.388 1008.2 1005.3 881.23 8325.9 9424.4 210.29 10094 10492 52522 52614 603.11 793.39 2.9818 7.3843 156 12.063 5852.5 5904 638.32 888.25 5975 85.781 86.939 161.91 55.341 1103.3 1104.2 8.1813 29.193 28.774 28.185 45.705 31.58 322.76 168.88 54.736 27.679 4734.4 4740.6 2269.7 754.02 90055 51231 2237.7 722.32 472.57 470.35 32.384 139.43 8.731 14.198 365.21 2692.4 2687.7 207.98 1622.4 254.13 1252.5 1.0785 166.05 217.25 53.293 53.937 27.683 10.086 61.119 0 0 17.242 16.775 7.9608 7.9608 7.9608 -0.038203 1.0455 0 0 0 394.51 408.54 409.16 428.78 444.64 13.308 13.125 16.111 21.059 20.507 297.68 111.46 112.1 223.81 223.57 1025.1 44.026 6.6381 -0.010026 18.739 18.739 6.9565 6.1511 5.7305 9.9467 4.4336 4.4336 4.4336 0 10.439 10.438 0 0 0 0 0 0 10138 30.091 28.975 7.6919 1.9347 1.9778 32.201 0 0 36.754 2.8904 2.8904 3.0511 2.8169 2.8169 0 0 0 0 5.5358 5.5358 19.027 19.088 3.6252 11.199 7.3487 23.663 23.786 8.8021 6.8844 6.8599 7.419 7.4143 12.125 12.125 12.125 0 1.2865 1.0909 140.39 52.773 53.026 692.3 150.12 150.98 151.01 604.95 777.41 778.75 181.29 343.23 343.71 231.1 563.19 562.96 562.95 563.33 2949.9 2952.3 2954.7 73.364 146.14 33.992 63.851 64.545 60.298 41.662 41.376 23.67 34.784 15.113 28.242 29.698 7.6179 36.998 37.469 16.216 2.2201 2.2103 13.647 30.117 30.053 11.127 8.4607 8.5732 8.5731 7.5934 9.4967 9.4993 11.095 26.364 26.247 5.9387 5.8744 6.1599 12.236 19.522 19.522 2.4495 0 2.6699 0 0 0 3.1873 3.0995 0 3.9437 5.3644 2.7189 2.7189 0 2.229 2.229 2.229 0 0 0 0 0 0 0 1.5922 5.156 0 0 0 0.62126 0.56665 0 0 0 0 0 0 0.26637 0 0 0 3.3313 4.7765 0 0 0 0 0 0 1.6412 1.9727 5.4624 0 16.467 16.492 7.8629 645.94 576.59 1484 251.65 0 7.373 0 0 3.9135 2.8659 0 4.9737e+05
1.25 6561.4 588.98 109.94 106.25 12.122 6747.4 115 24600 1277.5 1512 17690 15105 64312 60.657 132.47 117.41 24030 55782 1275.1 5989 1008.9 5204.1 33.883 804.8 807.73 768.79 7628.4 8567.7 120.8 8918.9 9307.8 49717 49798 693.75 838.97 7.7317 9.1289 181.6 1.4438 5782.1 5842.8 728.57 777.68 5785.9 67.354 68.405 160.83 42.51 1183.1 1183.7 29.422 55.803 56.592 57.075 76.444 63.149 339.42 218.3 46.316 42.348 5019.3 5009.9 2064.5 848.85 93665 53450 2412 848.47 633.99 635.96 49.203 115.98 3.234 21.083 428.51 2744 2745.7 232.14 1605.8 192.25 1123.4 17.816 108.62 125.07 50.175 50.019 9.1841 14.048 29.934 0 0 61.164 60.889 0 0 0 4.85 4.85 4.3148 4.3823 4.3846 327.23 331.64 331.98 344.28 447.6 0 0 13.093 25.646 25.646 187.39 130 130.46 117.35 117.32 809.06 45.023 23.293 3.3359 8.4262 8.4262 0 0.065479 0.044565 4.3846 2.327 2.327 2.327 6.2608 8.5604 8.527 0 7.5934 7.5934 0.23611 0 0 10462 2.7434 2.7434 0 0 0 2.9394 0 0 6.4201 0.44344 0.71194 0 7.9853 7.9853 0 0 0 0 11.697 12.095 10.876 10.876 0 37.159 11.954 18.998 18.586 6.5097 8.1323 8.1323 5.8709 5.8696 5.019 5.8148 5.9951 0 0 0 208.33 37.263 37.212 625.14 150.05 150.31 150.31 592.92 751.54 752.2 201.07 357.82 358.26 218.15 527.48 528.62 528.64 267.29 2142.6 2142.4 2141.4 52.861 117.01 54.133 103.78 104.09 25.871 44.744 44.779 23.681 80.692 7.5444 34.758 35.645 10.387 19.217 18.034 16.216 12.802 12.805 17.971 14.33 14.33 10.945 10.332 9.2275 9.1696 5.3889 8.9413 8.9434 3.9382 12.394 12.394 12.144 6.2707 6.2707 17.563 19.655 19.657 3.4377 7.8629 11.005 0 0 0 1.7559 1.7606 10.459 0 3.3541 1.7277 1.8343 4.6321 0 0 0 0 0 0 2.8414 2.8414 2.8414 0 1.8581 0 4.8255 4.8255 0 7.7894 7.7894 4.1886 4.1886 0 0 0 0 0 0 0 0 0 0 0 0 5.5848 4.7275 4.7275 0 0 0 0.85235 0.9798 3.3685 3.3588 7.7168 212.03 125.65 358.36 8.5591 0 12.749 0 0 16.828 0 0 4.9312e+05
1.5003 6482.5 1624.7 294.15 366.73 20.256 7546 112.97 27291 1304.9 1925.9 17780 14608 63527 82.656 127.3 121.6 24721 55913 1198.5 6701.6 1206.6 5296.9 15.894 971.5 971.98 890.99 8432.6 9588.5 172.36 9679.9 10113 51416 51511 727.68 884.69 5.864 4.3846 167 2.2204 5537.8 5610 761.55 736.76 6059.4 231.01 235.28 214.9 155.48 2224.6 2220.3 130.05 171.29 169.03 166.74 144.49 111.07 457.09 280.45 19.14 25.018 4614.1 4619.9 2119.9 1016.1 88191 51399 2330.6 789.62 751.71 748.35 26.831 122.94 14.418 25.034 398.58 2654.7 2650 182.95 1646.2 261.98 1188.4 10.963 60.755 94.636 48.395 50.118 28.574 15.46 13.216 3.7722 3.7722 7.7403 11.753 0 0 0 0 0 0 0 0.026223 340.44 401.09 401.28 409.88 466.51 5.9768 5.9768 18.056 29.981 30.002 304.46 129.81 128.19 204.62 204.67 926.85 55.103 52.12 2.0331 24.342 24.421 4.8745 11.243 11.241 1.2259 9.6755 9.6755 9.6755 0 8.4951 8.4964 0 1.0512 1.7481 0 0.08644 0.053959 10118 9.5285 9.5285 19.152 1.4675 0.86951 6.9202 0 0 9.709 0 0 0 0.94172 0.95259 0 0 0 0 5.1439 5.1442 26.679 27.466 8.9896 26.085 0.7473 50.032 50.315 12.528 0 0 2.376 2.376 16.044 16.044 16.044 0 0 0 174.51 46.042 45.946 770.46 129.01 131.87 131.94 628.45 769.25 768.34 163.59 373.35 372.92 193.46 628.63 633.35 633.42 365.87 2213.9 2215.3 2216.6 39.317 140.27 30.524 121.8 121.82 36.825 33.255 33.297 45.169 46.065 11.957 28.427 28.22 8.0748 13.252 13.252 14.069 11.17 11.17 4.2376 36.239 35.363 0 12.346 12.324 12.075 2.9179 20.964 20.965 10.866 10.41 10.41 15.26 18.585 18.463 2.8904 7.5452 7.5451 20.635 0 0 1.5677 1.5677 1.4207 8.3191 8.3303 0 6.2214 0 3.5516 3.6662 0 0 0 0 0 0 0 0 0 0 0 5.6338 5.6305 0 0 0 3.9291 3.9753 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8.0956 3.4783 8.5732 15.794 2.3025 25.205 25.205 8.7934 816.74 715.73 1595.4 24.901 0 11.327 0 0 0 0 0 5.0379e+05
1.7501 6839 738.95 115.62 182.72 31.355 10603 108.74 25972 1440.6 1655.3 18817 14108 61442 81.08 157.29 102.63 24266 56586 1234.7 6262.6 1235 5036.1 18.307 879.37 878.78 836.16 8297.4 9340 170.44 9986.2 10497 53487 53571 657.28 822.93 0.56892 5.4593 142.08 0 5573 5617.8 668.96 890.63 5745.1 84.139 86.021 164.49 32.072 1231.7 1226.7 41.238 64.381 64.182 64.022 107.78 82.87 399.92 235.14 46.96 25.349 4987.5 4985.1 2243.4 1035 93491 53480 2562.4 953.78 656.26 657.06 70.683 117.83 0 22.148 527.65 2983.8 2987.1 234.6 1607.6 218.9 1100.1 12.627 96.047 118.99 30.71 30.975 32.945 6.679 58.518 4.9486 4.98 65.192 65.097 5.7073 5.7073 5.7073 11.88 11.88 0 0 0 398.63 297.78 297.96 302.21 457.14 21.574 21.681 4.997 29.444 29.314 257.53 104.58 105.47 146.43 146.45 961.75 79.291 0 1.5857 1.2492 1.2492 1.0533 13.791 13.789 0 11.856 11.856 11.856 1.268 2.8846 2.8842 0 7.8384 7.8384 0 0 0 10284 6.9638 6.9722 0 0 0 3.6393 0 0 9.3081 1.7146 1.7146 7.2909 0 0 0 0 0 0 6.3 6.1587 29.026 29.026 0 34.368 0 30.522 30.751 36.269 7.3485 7.3485 21.555 21.538 8.8198 8.5957 8.5362 0 3.6054 3.5971 160.37 71.326 70.747 774.88 108.45 108.47 108.46 729.68 778.44 779.17 228.32 375.92 375.55 251.26 609.27 614.09 614.16 405.67 2741.7 2742.3 2741.7 61.141 142.68 38.095 119.9 119.55 36.608 60.743 60.069 7.2021 20.227 4.2032 41.787 41.785 17.93 16.536 16.051 8.7202 36.484 36.482 4.7098 9.6325 9.572 9.2591 16.627 16.403 16.249 16.657 19.979 19.904 6.6434 15.53 15.53 12.342 15.741 15.788 3.1942 12.701 12.699 7.447 19.228 10.128 7.5311 7.433 5.2212 6.4911 6.4911 0 10.631 1.9596 4.4826 4.4826 1.5187 0 0 0 0 0 0 0 0 0 0 5.2644 0 5.2174 5.2174 0 0 0 2.4985 2.4985 0 0 0 0 0 0 0 1.6662 0 0 0 0 1.7146 0 0 0 2.229 3.8999 4.3111 10.288 34.514 34.59 10.678 237.66 206.08 426.63 16.852 0 19.598 0 0 10.798 0 0 5.0733e+05
1.9998 6626.1 267.22 65.721 76.456 24.125 4944.8 71.533 22652 1181.6 1756.1 17961 14898 66748 86.447 140.61 136.81 25519 58920 1359.4 6425.8 1137.6 5722.3 9.6451 918.86 918.32 824.14 8051.4 9095.3 149.84 9131.9 9492.7 51323 51410 555.75 710.2 7.7739 5.0303 181.64 7.6669 5661 5708.3 655.45 732.53 5759.4 69.174 72.429 113.16 38.941 996.69 1001.7 11.252 48.495 48.267 48.06 45.255 39.779 423.15 259.41 64.642 49.156 2313.9 2316.5 1187.9 732.35 40816 23050 1191 487.03 493.18 489.12 46.743 91.192 14.594 19.283 323.29 2776.4 2771.6 129.24 1632.7 262.45 1235.7 9.2101 123.28 204.55 50.778 50.853 12.169 12.505 58.552 5.6744 5.6259 14.927 15.089 7.2292 7.9419 10.088 5.5358 5.5358 0 0 0 403.01 287.97 288.37 302.72 445.44 1.7133 1.3583 17.232 35.062 36.584 211.8 101.84 102.43 145.7 145.8 681.13 41.968 12.051 5.4379 25.15 24.772 0 0 0 0.035861 0 0 0 5.0892 5.5113 5.5113 0 5.9768 5.9768 0 3.2066 3.1991 10463 0 0 3.3313 0 0 15.361 4.605 4.605 14.987 2.0821 2.0821 12.572 14.452 14.452 0 0 2.4005 2.4005 3.3068 3.3068 20.037 20.037 18.293 22.961 8.1613 28.227 27.883 6.092 2.001 1.9995 7.079 7.079 11.88 11.88 11.88 1.7146 2.6699 2.6699 192.77 48.608 48.877 668.2 167.88 167.64 167.63 537.44 774.34 774.96 156.87 354.79 354.7 170.75 406.34 406.69 406.69 298.77 1970.4 1970.6 1969.8 74.115 177.8 22.192 84.082 83.537 14.565 62.668 62.641 6.0747 41.018 24.25 34.262 34.245 12.842 12.689 12.694 11.096 45.481 45.463 21.811 11.466 11.859 27.042 6.5857 9.1804 9.2526 15.871 24.271 24.272 9.9373 8.3773 8.3773 11.366 20.234 20.093 10.589 17.212 17.221 2.9932 3.0374 4.2376 0 0 0 3.3424 3.355 0 2.229 3.2088 1.6901 1.6901 1.0269 0 0 0 0 0 0 0 0 0 0 0 0 1.1023 1.1023 5.8452 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.5432 1.5432 4.9235 0 8.3705 4.9725 1.2551 6.5646 6.5646 12.405 98.228 78.483 216.55 14.469 0 6.7002 0 0 3.6252 1.6167 0 4.3073e+05
2.2498 6904 595.83 103.1 124.11 26.716 7071.9 121.42 24652 1294.3 1829.7 17841 13586 58511 91.972 211.7 173.28 24286 55204 1321.2 7117.9 986.73 5264.7 30.229 956.14 957.49 885.46 8427.6 9490.8 149.92 9863 10335 52695 52786 598.05 730.28 0.79006 1.947 178.35 8.9161 5993.2 6052.8 708.06 955.79 6072.8 66.657 68.154 180.37 55.101 861.77 860.78 13.717 73.956 73.889 73.759 95.453 84.395 357.69 209.43 43.252 33.394 8612 8610.9 3879.6 1062.2 1.3199e+05 85487 4205.6 1550.2 929.01 922.53 19.267 139.75 5.3033 17.808 538.8 3003.3 3004.3 223.87 1619.7 290.1 1122.6 3.7967 86.389 135.45 53.283 53.527 19.354 16.544 45.468 2.3515 2.3515 65.031 65.494 0 0 0 5.2174 5.2174 0 0 0 392.71 316.46 316.67 327.02 475.07 21.773 21.43 18.829 27.341 27.701 257.89 145.51 145.31 188.73 188.89 1055.8 50.382 23.123 7.2834 18.861 18.861 1.1758 0 0 0 10.484 10.484 10.484 3.7967 21.353 21.293 0.92575 0 0 0 0 0 10643 0 0 0.99912 3.8457 3.8457 26.645 0 0 16.764 5.1929 5.1929 0 2.5952 2.153 3.8387 3.8349 1.5187 1.5187 0 0 31.925 31.385 11.894 27.557 1.2247 43.977 43.451 30.202 0 0 22.861 22.868 21.256 21.416 21.44 0 0 0 163.2 76.979 77.02 719.24 104.26 104.69 104.71 599.61 739.75 739.69 168.92 458.57 458.08 187.78 561.37 567.82 567.92 385.51 2643.3 2644.1 2644.3 84.337 232.72 31.248 100.35 100.37 12.489 72.944 72.66 11.819 57.005 0 28.733 28.733 6.9741 31.688 33.037 2.0086 16.262 16.288 24.588 17.231 17.189 5.6093 38.062 39.973 39.906 3.3767 20.308 20.3 8.8671 23.711 23.745 16.038 7.4506 7.4578 0 14.208 14.208 9.3205 0 2.523 2.425 2.425 4.5805 13.668 13.668 0 6.8492 1.4452 4.654 4.654 3.9091 2.8414 2.8414 2.8414 0.94093 0 0 0 0 0 0 7.7649 1.7263 11.765 12.253 0.7282 0 0 6.3442 6.3442 0 0 0 0 0 0 0 0 0 0 0 0 0 2.425 2.425 0 5.5358 6.0992 5.8543 0 7.1726 7.1782 5.8298 257.51 264.04 683.22 144.91 0 11.235 0 0 7.8874 1.9596 0 5.6708e+05
"If I open this file in Excel, every row is just in one cell, so I have to tell Matlab that the delimiter is a simple ',',"
This tells us that your OS uses another delimiter (e.g. semicolon), so you have to tell Excel to use the comma.
But MATLAB is not Excel.
"while the other files, xlsx and txt have ';' or '\t'. "
XLSX files are zipped XML, they do not use delimiter characters.
Tatjana Mü
on 31 Mar 2022
@Stephen Thank you. But how do I import just the range I wanted? I just want to have the first row as a 183x7 char? (7 because I delete afterwards the [ ] of the element names.
Stephen23
on 31 Mar 2022
Edited: Stephen23
on 31 Mar 2022
"I just want to have the first row as a 183x7 char? (7 because I delete afterwards the [ ] of the element names."
Tells us what you are actaully trying to achieve, not how you think it can be achieved. For example: "I need the first line of the file in an array, without the single-quotes and square brackets. Each header should be separate, e.g. in a string array or cell arrar of char vectors".
So far we have two sample files. Now tell us: what specific information do you require from those files?
Tatjana Mü
on 31 Mar 2022
Edited: Tatjana Mü
on 31 Mar 2022
val =
''[23Na]+' '
''[24Mg]+' '
''[25Mg]+' '
''[26Mg]+' '
''[27Al]+' '
''[39K]+' '
''[40Ca]+' '
''[41K]+' '
''[42Ca]+' '
''[43Ca]+' '
''[87Sr]++' '
''[88Sr]++' '
''[44Ca]+' '
''[45Sc]+' '...
I want to read in the first row from B1:KR1 from my files. It should be a char like above and no table. The problem is that I can just read the csv of Smp 3.8.1, the other one is not accepted by my code:
[num,txt,raw] = xlsread(filename{xy},'B1:KR1');
element_cim=cellstr(txt);
element_cim(:,[5 7:29 31:32])=[]; %delete columns which I may not need- CHANGE!!!
element_cim=regexprep(element_cim,'\[',''); %delete parts of elementname
element_cim=regexprep(element_cim,'\]','');
element_cim=regexprep(element_cim,'\''','');
element_cim = convertStringsToChars(element_cim); %convert to cell???
element_cim=char(element_cim); %convert to char
Because the delimiter is a ','. And thats the only problem I have. To get my first line from both files into this formate (char). I am totally sorry, I am new in this field and maybe I cant define my goal precisely.
Stephen23
on 31 Mar 2022
Edited: Stephen23
on 31 Mar 2022
" It should be a char like above"
If it should be "a char like above" (with square brackets) then why did you write code that removes the square brackets? I am guessing that actually you don't want "a char like above" (with square brackets) but in fact you want the field text without the single quotes and square brackets.
Explaining your actual goal, i.e. what you want to achieve (with examples) would be very very helpful.
How important is it for you that you use exactly the same code to process all of those filetypes?
Do the XLS/X files have the data arranged in the same way?
Stephen23
on 31 Mar 2022
Tatjana Mü's incorrectly posted "Answer" moved here:
I realised I did a huge mistake. xlsread is really the wrong option - I am sorry. So most important is to read in the file "SMP_Std.csv". Most of my files will be like this.
The probleme is the seperation with a ','. 
I just added a picture, how excel is opening the file. Everything is in one cell.
So I want to read in this file.
[num,txt,raw] = xlsread(filename{xy}, 'B1:KR1');
element_cim=string(txt);
element_cim(:,[5 7:29 31:32)=[];
element_cim=regexprep(element_cim,'\[','');
element_cim=regexprep(element_cim,'\]','');
element_cim=regexprep(element_cim,'\''','');
element_cim = convertStringsToChars(element_cim);
element_cim=char(element_cim);
end
xlsread is not working. I want to read in the range from 'B1:KR1'. Then I delete some columns, delete some columns and parts of the element name and want to receive a char like this:
val =
'23Na+ '
'24Mg+ '
'25Mg+ '
'26Mg+ '
'27Al+ '
'39K+ '
'40Ca+ '
'41K+ '
'42Ca+ '
'43Ca+ '
'87Sr++ '
'88Sr++ '
'44Ca+ '
'45Sc+ '
'46Ca+ '
'48Ca+ '
'50Cr+ '
'50V+ '
'51V+ '
'52Cr+ '
'53Cr+ '
Do you know how I receive this?
Stephen23
on 31 Mar 2022
Edited: Stephen23
on 31 Mar 2022
"The probleme is the seperation with a ','.... I just added a picture, how excel is opening the file. Everything is in one cell."
Sure. Those a problems that Excel has due to your OS's delimiter settings (i.e. locale settings).
But that has nothing to do with MATLAB.
Accepted Answer
Stephen23
on 31 Mar 2022
Edited: Stephen23
on 31 Mar 2022
Without a sample XLSX file I had to create my own (attached).
It is easy to read the first line using READCELL, it will correctly indentify the delimiter character:
firstrow('SMP_3.8.1.csv')
ans = 277×7 char array
'23Na+ '
'24Mg+ '
'25Mg+ '
'26Mg+ '
'27Al+ '
'39K+ '
'40Ca+ '
'41K+ '
'ArH+ '
'42Ca+ '
'ArH2+ '
'43Ca+ '
'87Sr++ '
'88Sr++ '
'44Ca+ '
'CO2+ '
'45Sc+ '
'CHO2+ '
'46Ti+ '
'46Ca+ '
'NO2+ '
'47Ti+ '
'48Ti+ '
'48Ca+ '
'49Ti+ '
'50Ti+ '
'50Cr+ '
'50V+ '
'51V+ '
'ClO+ '
'52Cr+ '
'36ArO+ '
'53Cr+ '
'37ClO+ '
'54Cr+ '
'54Fe+ '
'ArN+ '
'55Mn+ '
'56Fe+ '
'ArO+ '
'57Fe+ '
'ArOH+ '
'58Fe+ '
'58Ni+ '
'59Co+ '
'60Ni+ '
'61Ni+ '
'62Ni+ '
'63Cu+ '
'64Ni+ '
'64Zn+ '
'65Cu+ '
'66Zn+ '
'67Zn+ '
'68Zn+ '
'137Ba++'
'69Ga+ '
'138Ba++'
'70Ge+ '
'70Zn+ '
'71Ga+ '
'72Ge+ '
'73Ge+ '
'74Ge+ '
'74Se+ '
'75As+ '
'ArCl+ '
'76Se+ '
'76Ge+ '
'Ar36Ar+'
'77Se+ '
'Ar37Cl+'
'78Se+ '
'78Kr+ '
'Ar38Ar+'
'79Br+ '
'80Kr+ '
'80Se+ '
'Ar2+ '
'81Br+ '
'82Kr+ '
'82Se+ '
'83Kr+ '
'84Kr+ '
'84Sr+ '
'85Rb+ '
'86Sr+ '
'86Kr+ '
'87Sr+ '
'87Rb+ '
'88Sr+ '
'89Y+ '
'90Zr+ '
'91Zr+ '
'92Zr+ '
'92Mo+ '
'93Nb+ '
'94Mo+ '
'94Zr+ '
'95Mo+ '
'96Mo+ '
'96Ru+ '
'96Zr+ '
'97Mo+ '
'98Ru+ '
'98Mo+ '
'99Ru+ '
'100Ru+ '
'100Mo+ '
'101Ru+ '
'102Ru+ '
'102Pd+ '
'103Rh+ '
'104Pd+ '
'104Ru+ '
'105Pd+ '
'106Pd+ '
'106Cd+ '
'107Ag+ '
'108Pd+ '
'108Cd+ '
'109Ag+ '
'110Cd+ '
'110Pd+ '
'111Cd+ '
'112Cd+ '
'112Sn+ '
'113In+ '
'113Cd+ '
'114Sn+ '
'114Cd+ '
'115Sn+ '
'115In+ '
'116Sn+ '
'116Cd+ '
'117Sn+ '
'118Sn+ '
'119Sn+ '
'102Sn+ '
'120Te+ '
'121Sb+ '
'122Te+ '
'122Sn+ '
'123Sb+ '
'123Te+ '
'124Te+ '
'124Sn+ '
'124Xe+ '
'125Te+ '
'126Te+ '
'126Xe+ '
'127I+ '
'128Xe+ '
'128Te+ '
'129Xe+ '
'130Xe+ '
'130Te+ '
'130Ba+ '
'131Xe+ '
'132Xe+ '
'132Ba+ '
'133Cs+ '
'134Ba+ '
'134Xe+ '
'135Ba+ '
'136Ba+ '
'136Ce+ '
'136Xe+ '
'137Ba+ '
'138Ba+ '
'138Ce+ '
'138La+ '
'139La+ '
'140Ce+ '
'141Pr+ '
'142Nd+ '
'142Ce+ '
'143Nd+ '
'144Nd+ '
'144Sm+ '
'145Nd+ '
'146Nd+ '
'147Sm+ '
'148Sm+ '
'148Nd+ '
'149Sm+ '
'150Sm+ '
'150Nd+ '
'151Eu+ '
'152Sm+ '
'152Gd+ '
'153Eu+ '
'154Gd+ '
'154Sm+ '
'155Gd+ '
'CeO+ '
'156Gd+ '
'156Dy+ '
'157Gd+ '
'158Gd+ '
'158Dy+ '
'159Tb+ '
'160Dy+ '
'160Gd+ '
'161Dy+ '
'162Dy+ '
'162Er+ '
'163Dy+ '
'164Dy+ '
'164Er+ '
'165Ho+ '
'166Er+ '
'167Er+ '
'168Er+ '
'168Yb+ '
'169Tm+ '
'170Yb+ '
'170Er+ '
'171Yb+ '
'172Yb+ '
'173Yb+ '
'174Yb+ '
'174Hf+ '
'175Lu+ '
'176Hf+ '
'176Yb+ '
'176Lu+ '
'177Hf+ '
'178Hf+ '
'179Hf+ '
'180Hf+ '
'180W+ '
'180Ta+ '
'181Ta+ '
'182W+ '
'183W+ '
'184W+ '
'184Os+ '
'185Re+ '
'186Os+ '
'186W+ '
'187Os+ '
'187Re+ '
'188Os+ '
'189Os+ '
'190Os+ '
'190Pt+ '
'191Ir+ '
'192Pt+ '
'192Os+ '
'193Ir+ '
'194Pt+ '
'195Pt+ '
'196Pt+ '
'196Hg+ '
'197Au+ '
'198Hg+ '
'198Pt+ '
'199Hg+ '
'200Hg+ '
'201Hg+ '
'202Hg+ '
'203Tl+ '
'204Pb+ '
'204Hg+ '
'205Tl+ '
'206Pb+ '
'207Pb+ '
'208Pb+ '
'209Bi+ '
'220Bkg+'
'232Th+ '
'234U+ '
'235U+ '
'238U+ '
'ThO+ '
'UO+ '
firstrow('SMP_Std.csv')
ans = 277×7 char array
'23Na+ '
'24Mg+ '
'25Mg+ '
'26Mg+ '
'27Al+ '
'39K+ '
'40Ca+ '
'41K+ '
'ArH+ '
'42Ca+ '
'ArH2+ '
'43Ca+ '
'87Sr++ '
'88Sr++ '
'44Ca+ '
'CO2+ '
'45Sc+ '
'CHO2+ '
'46Ti+ '
'46Ca+ '
'NO2+ '
'47Ti+ '
'48Ti+ '
'48Ca+ '
'49Ti+ '
'50Ti+ '
'50Cr+ '
'50V+ '
'51V+ '
'ClO+ '
'52Cr+ '
'36ArO+ '
'53Cr+ '
'37ClO+ '
'54Cr+ '
'54Fe+ '
'ArN+ '
'55Mn+ '
'56Fe+ '
'ArO+ '
'57Fe+ '
'ArOH+ '
'58Fe+ '
'58Ni+ '
'59Co+ '
'60Ni+ '
'61Ni+ '
'62Ni+ '
'63Cu+ '
'64Ni+ '
'64Zn+ '
'65Cu+ '
'66Zn+ '
'67Zn+ '
'68Zn+ '
'137Ba++'
'69Ga+ '
'138Ba++'
'70Ge+ '
'70Zn+ '
'71Ga+ '
'72Ge+ '
'73Ge+ '
'74Ge+ '
'74Se+ '
'75As+ '
'ArCl+ '
'76Se+ '
'76Ge+ '
'Ar36Ar+'
'77Se+ '
'Ar37Cl+'
'78Se+ '
'78Kr+ '
'Ar38Ar+'
'79Br+ '
'80Kr+ '
'80Se+ '
'Ar2+ '
'81Br+ '
'82Kr+ '
'82Se+ '
'83Kr+ '
'84Kr+ '
'84Sr+ '
'85Rb+ '
'86Sr+ '
'86Kr+ '
'87Sr+ '
'87Rb+ '
'88Sr+ '
'89Y+ '
'90Zr+ '
'91Zr+ '
'92Zr+ '
'92Mo+ '
'93Nb+ '
'94Mo+ '
'94Zr+ '
'95Mo+ '
'96Mo+ '
'96Ru+ '
'96Zr+ '
'97Mo+ '
'98Ru+ '
'98Mo+ '
'99Ru+ '
'100Ru+ '
'100Mo+ '
'101Ru+ '
'102Ru+ '
'102Pd+ '
'103Rh+ '
'104Pd+ '
'104Ru+ '
'105Pd+ '
'106Pd+ '
'106Cd+ '
'107Ag+ '
'108Pd+ '
'108Cd+ '
'109Ag+ '
'110Cd+ '
'110Pd+ '
'111Cd+ '
'112Cd+ '
'112Sn+ '
'113In+ '
'113Cd+ '
'114Sn+ '
'114Cd+ '
'115Sn+ '
'115In+ '
'116Sn+ '
'116Cd+ '
'117Sn+ '
'118Sn+ '
'119Sn+ '
'102Sn+ '
'120Te+ '
'121Sb+ '
'122Te+ '
'122Sn+ '
'123Sb+ '
'123Te+ '
'124Te+ '
'124Sn+ '
'124Xe+ '
'125Te+ '
'126Te+ '
'126Xe+ '
'127I+ '
'128Xe+ '
'128Te+ '
'129Xe+ '
'130Xe+ '
'130Te+ '
'130Ba+ '
'131Xe+ '
'132Xe+ '
'132Ba+ '
'133Cs+ '
'134Ba+ '
'134Xe+ '
'135Ba+ '
'136Ba+ '
'136Ce+ '
'136Xe+ '
'137Ba+ '
'138Ba+ '
'138Ce+ '
'138La+ '
'139La+ '
'140Ce+ '
'141Pr+ '
'142Nd+ '
'142Ce+ '
'143Nd+ '
'144Nd+ '
'144Sm+ '
'145Nd+ '
'146Nd+ '
'147Sm+ '
'148Sm+ '
'148Nd+ '
'149Sm+ '
'150Sm+ '
'150Nd+ '
'151Eu+ '
'152Sm+ '
'152Gd+ '
'153Eu+ '
'154Gd+ '
'154Sm+ '
'155Gd+ '
'CeO+ '
'156Gd+ '
'156Dy+ '
'157Gd+ '
'158Gd+ '
'158Dy+ '
'159Tb+ '
'160Dy+ '
'160Gd+ '
'161Dy+ '
'162Dy+ '
'162Er+ '
'163Dy+ '
'164Dy+ '
'164Er+ '
'165Ho+ '
'166Er+ '
'167Er+ '
'168Er+ '
'168Yb+ '
'169Tm+ '
'170Yb+ '
'170Er+ '
'171Yb+ '
'172Yb+ '
'173Yb+ '
'174Yb+ '
'174Hf+ '
'175Lu+ '
'176Hf+ '
'176Yb+ '
'176Lu+ '
'177Hf+ '
'178Hf+ '
'179Hf+ '
'180Hf+ '
'180W+ '
'180Ta+ '
'181Ta+ '
'182W+ '
'183W+ '
'184W+ '
'184Os+ '
'185Re+ '
'186Os+ '
'186W+ '
'187Os+ '
'187Re+ '
'188Os+ '
'189Os+ '
'190Os+ '
'190Pt+ '
'191Ir+ '
'192Pt+ '
'192Os+ '
'193Ir+ '
'194Pt+ '
'195Pt+ '
'196Pt+ '
'196Hg+ '
'197Au+ '
'198Hg+ '
'198Pt+ '
'199Hg+ '
'200Hg+ '
'201Hg+ '
'202Hg+ '
'203Tl+ '
'204Pb+ '
'204Hg+ '
'205Tl+ '
'206Pb+ '
'207Pb+ '
'208Pb+ '
'209Bi+ '
'220Bkg+'
'232Th+ '
'234U+ '
'235U+ '
'238U+ '
'ThO+ '
'UO+ '
firstrow('SMP_Std.xlsx')
ans = 277×7 char array
'23Na+ '
'24Mg+ '
'25Mg+ '
'26Mg+ '
'27Al+ '
'39K+ '
'40Ca+ '
'41K+ '
'ArH+ '
'42Ca+ '
'ArH2+ '
'43Ca+ '
'87Sr++ '
'88Sr++ '
'44Ca+ '
'CO2+ '
'45Sc+ '
'CHO2+ '
'46Ti+ '
'46Ca+ '
'NO2+ '
'47Ti+ '
'48Ti+ '
'48Ca+ '
'49Ti+ '
'50Ti+ '
'50Cr+ '
'50V+ '
'51V+ '
'ClO+ '
'52Cr+ '
'36ArO+ '
'53Cr+ '
'37ClO+ '
'54Cr+ '
'54Fe+ '
'ArN+ '
'55Mn+ '
'56Fe+ '
'ArO+ '
'57Fe+ '
'ArOH+ '
'58Fe+ '
'58Ni+ '
'59Co+ '
'60Ni+ '
'61Ni+ '
'62Ni+ '
'63Cu+ '
'64Ni+ '
'64Zn+ '
'65Cu+ '
'66Zn+ '
'67Zn+ '
'68Zn+ '
'137Ba++'
'69Ga+ '
'138Ba++'
'70Ge+ '
'70Zn+ '
'71Ga+ '
'72Ge+ '
'73Ge+ '
'74Ge+ '
'74Se+ '
'75As+ '
'ArCl+ '
'76Se+ '
'76Ge+ '
'Ar36Ar+'
'77Se+ '
'Ar37Cl+'
'78Se+ '
'78Kr+ '
'Ar38Ar+'
'79Br+ '
'80Kr+ '
'80Se+ '
'Ar2+ '
'81Br+ '
'82Kr+ '
'82Se+ '
'83Kr+ '
'84Kr+ '
'84Sr+ '
'85Rb+ '
'86Sr+ '
'86Kr+ '
'87Sr+ '
'87Rb+ '
'88Sr+ '
'89Y+ '
'90Zr+ '
'91Zr+ '
'92Zr+ '
'92Mo+ '
'93Nb+ '
'94Mo+ '
'94Zr+ '
'95Mo+ '
'96Mo+ '
'96Ru+ '
'96Zr+ '
'97Mo+ '
'98Ru+ '
'98Mo+ '
'99Ru+ '
'100Ru+ '
'100Mo+ '
'101Ru+ '
'102Ru+ '
'102Pd+ '
'103Rh+ '
'104Pd+ '
'104Ru+ '
'105Pd+ '
'106Pd+ '
'106Cd+ '
'107Ag+ '
'108Pd+ '
'108Cd+ '
'109Ag+ '
'110Cd+ '
'110Pd+ '
'111Cd+ '
'112Cd+ '
'112Sn+ '
'113In+ '
'113Cd+ '
'114Sn+ '
'114Cd+ '
'115Sn+ '
'115In+ '
'116Sn+ '
'116Cd+ '
'117Sn+ '
'118Sn+ '
'119Sn+ '
'102Sn+ '
'120Te+ '
'121Sb+ '
'122Te+ '
'122Sn+ '
'123Sb+ '
'123Te+ '
'124Te+ '
'124Sn+ '
'124Xe+ '
'125Te+ '
'126Te+ '
'126Xe+ '
'127I+ '
'128Xe+ '
'128Te+ '
'129Xe+ '
'130Xe+ '
'130Te+ '
'130Ba+ '
'131Xe+ '
'132Xe+ '
'132Ba+ '
'133Cs+ '
'134Ba+ '
'134Xe+ '
'135Ba+ '
'136Ba+ '
'136Ce+ '
'136Xe+ '
'137Ba+ '
'138Ba+ '
'138Ce+ '
'138La+ '
'139La+ '
'140Ce+ '
'141Pr+ '
'142Nd+ '
'142Ce+ '
'143Nd+ '
'144Nd+ '
'144Sm+ '
'145Nd+ '
'146Nd+ '
'147Sm+ '
'148Sm+ '
'148Nd+ '
'149Sm+ '
'150Sm+ '
'150Nd+ '
'151Eu+ '
'152Sm+ '
'152Gd+ '
'153Eu+ '
'154Gd+ '
'154Sm+ '
'155Gd+ '
'CeO+ '
'156Gd+ '
'156Dy+ '
'157Gd+ '
'158Gd+ '
'158Dy+ '
'159Tb+ '
'160Dy+ '
'160Gd+ '
'161Dy+ '
'162Dy+ '
'162Er+ '
'163Dy+ '
'164Dy+ '
'164Er+ '
'165Ho+ '
'166Er+ '
'167Er+ '
'168Er+ '
'168Yb+ '
'169Tm+ '
'170Yb+ '
'170Er+ '
'171Yb+ '
'172Yb+ '
'173Yb+ '
'174Yb+ '
'174Hf+ '
'175Lu+ '
'176Hf+ '
'176Yb+ '
'176Lu+ '
'177Hf+ '
'178Hf+ '
'179Hf+ '
'180Hf+ '
'180W+ '
'180Ta+ '
'181Ta+ '
'182W+ '
'183W+ '
'184W+ '
'184Os+ '
'185Re+ '
'186Os+ '
'186W+ '
'187Os+ '
'187Re+ '
'188Os+ '
'189Os+ '
'190Os+ '
'190Pt+ '
'191Ir+ '
'192Pt+ '
'192Os+ '
'193Ir+ '
'194Pt+ '
'195Pt+ '
'196Pt+ '
'196Hg+ '
'197Au+ '
'198Hg+ '
'198Pt+ '
'199Hg+ '
'200Hg+ '
'201Hg+ '
'202Hg+ '
'203Tl+ '
'204Pb+ '
'204Hg+ '
'205Tl+ '
'206Pb+ '
'207Pb+ '
'208Pb+ '
'209Bi+ '
'220Bkg+'
'232Th+ '
'234U+ '
'235U+ '
'238U+ '
'ThO+ '
'UO+ '
function tmp = firstrow(fnm)
tmp = readcell(fnm, 'Range','B1:KR1');
tmp([5,7:29,31:32]) = [];
tmp = regexprep(tmp,'\[|\]|''','');
tmp = char(tmp);
end
3 Comments
Stephen23
on 31 Mar 2022
Tatjana Mü's incorrectly posted "Answer" moved here:
Oh wow- thank you so much! That's amazing. I am quite new, so do I have to change the "fnm" to my filename, like this?
function tmp = firstrow(filename{xy})
tmp = readcell(filename{xy}, 'Range','B1:KR1');
tmp([5,7:29,31:32]) = [];
tmp = regexprep(tmp,'\[|\]|''','');
tmp = char(tmp);
end
and then add it to my script like this?
element_cim = firstrow(filename{xy})
If I change it like this I get an error for using {xy}.
Stephen23
on 31 Mar 2022
Edited: Stephen23
on 31 Mar 2022
No, do not change the function like that (it is invalid sytnax to put any indexing into the function signature line).
I doubt that you need to change the function much, most likely you can just call it like this:
[fnm,pfad] = uigetfile(.. whatever you want here..);
out = firstrow(fullfile(pfad,fnm))
If you do not use FULLFILE then you will have problems with the file not being found.
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!An Error Occurred
Unable to complete the action because of changes made to the page. Reload the page to see its updated state.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom(English)
Asia Pacific
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)