You are now following this question
- You will see updates in your followed content feed.
- You may receive emails, depending on your communication preferences.
Extracting Specific Rows From xlsx or txt File
8 views (last 30 days)
Show older comments
I have an excle file with raw data output by another program, but it is formatted rather oddly. I would like to take every 3rd row of data and make it into a row on a matrix. I've tried using readmatrix, but I don't know how to make it take out multiple specific rows and place them into one matrix. I feel like this should be doable by using an array made with [14:3:764] which would tell readmatrix to start pulling data from row 14, and then pull every 3rd row until it reaches row 764. Ideally, these would also be stacked into a matrix so that row 1 data is row 1 in the matrix, row 2 data is row 2 data in the matrix, and so on. Should I be using something with Opts and DataRange? I'm completely new to data importing in Matlab, so any help is much appreciated.
Original Question: The data can also be output to a txt file, but I have no idea how to parse through it and turn the rows of data and text into a useful input for Matlab. Is there a way to extract the data for each timestep and place it in a structure with its respective timestep?
Accepted Answer
Anton Kogios
on 6 Oct 2023
Edited: Anton Kogios
on 6 Oct 2023
I think you edited your question from what you had initially quite a bit (you should have just made a new question). Since I spent time on it, I think I found a solution to your initial question. This code reads the initial file that you sent with text, finds where the time and force data is, and assigns the data to a struct. Hope it helps. It's also pretty fast (<1.5 sec on my computer).
% Read data
unzip CompForceTest1.zip
fid = fopen('CompForceTest1','r');
txtDouble = fread(fid);
txtChar = char(txtDouble');
fclose(fid);
% Find indices
newlinesIdx = find(txtDouble == 10);
timesIdx = strfind(txtChar,'TIME:,');
forceIdx = strfind(txtChar,'Particle Compressive Force:,');
data = struct('Time',0,'Force',0);
% Cycle through and extract times and force data
for i = 1:length(timesIdx)
diffTime = (newlinesIdx-timesIdx(i));
diffForce = (newlinesIdx-forceIdx(i));
data(i).Time = str2double(txtChar((timesIdx(i)+5)+(1:min(diffTime(diffTime>0))-5)));
data(i).Force = str2num(txtChar((forceIdx(i)+27)+(1:min(diffForce(diffForce>0))-27)));
end
data
2 Comments
Joseph Salerno
on 9 Oct 2023
I'm quite glad you caught the original. After doing a bit more searching, I thought it may just end up being far easier to accomplish with an excel file, so i changed it. I can add back the old text file and question for clarity, because this gives me exactly what I need and is far more efficient than going into and then back out of excel.
I do have some questions about how you did it though, mainly with the indices.
What is find(txtDouble == 10) doing?
I follow the timesIdx and forceIdx, but where are the 5 and 27 coming from later on when moving from timestep to timestep in the loop?
Thank you, this is extremely helpful.
Anton Kogios
on 10 Oct 2023
Hey Joseph, I'm glad this works for you!
(txtDouble == 10) finds the newline characters (which is equal to 10 in ASCII/as a double) as an array of logical values. I wanted to get the actual indices where there are new lines, so find(txtDouble == 10) returns the index of all non-zero elements in the array (in our case, all the logical 1s). A simple example:
find([true false false true true])
ans = 1×3
1 4 5
timesIdx and forceIdx are doing a similar thing which I think you understand, but the index they return is the start of the string they're looking for. So that's where the 5 and 27 come from - they are the length of 'TIME:,' and 'Particle Compressive Force:,' which are added to get the data after they occur.
Feel free to ask more questions, happy to help your understanding!
More Answers (1)
Voss
on 6 Oct 2023
Edited: Voss
on 6 Oct 2023
Here's one way. This method reads the file's contents into a cell array using readcell. The data on lines 14:3:end of the file end up in cells (12:2:end,3) of the cell array (that is, rows 12:2:end in column 3) because of blank lines in the file. All the numeric data from the file is stored in the cell array as character vectors, so use str2num to convert to a vector of numbers, one line at a time, storing the vectors as rows in a matrix.
unzip CompForceTest2.zip
ls
CompForceTest2.csv CompForceTest2.zip
filename = 'CompForceTest2.csv';
% read the file into a cell array C:
C = readcell(filename)
C = 510×3 cell array
{'Compressive Forces Test 2'} {[<missing> ]} {[<missing> ]}
{'QUERY DESCRIPTIONS' } {[<missing> ]} {[<missing> ]}
{'Q01' } {'Particle Compressive Force'} {[<missing> ]}
{'GROUP/TYPE' } {',All' } {[<missing> ]}
{'SELECTED OBJECTS' } {',All' } {[<missing> ]}
{'RANGE' } {',None' } {[<missing> ]}
{'UNITS' } {',N' } {[<missing> ]}
{'EXTRACTED DATA' } {[<missing> ]} {[<missing> ]}
{'TIME' } {',0' } {[<missing> ]}
{'Q01' } {'Particle Compressive Force'} {',no data' }
{'TIME' } {',0.0200013' } {[<missing> ]}
{'Q01' } {'Particle Compressive Force'} {',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,…'}
{'TIME' } {',0.0400009' } {[<missing> ]}
{'Q01' } {'Particle Compressive Force'} {',0,0.00028769485652446747,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0…'}
{'TIME' } {',0.0600018' } {[<missing> ]}
{'Q01' } {'Particle Compressive Force'} {',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,…'}
% keep only the relevant stuff:
C = C(12:2:end,3);
% number of rows in C:
nrow_C = size(C,1);
% initialize a matrix M with that same number of rows and zero columns:
nrow_M = nrow_C;
ncol_M = 0;
M = NaN(nrow_M,ncol_M);
% loop over the rows of C
for row = 1:nrow_C
% convert the data in this cell into a numeric vector:
new_data = str2num(C{row});
% number of elements in the vector:
n_data = numel(new_data);
% going to store this vector as a row of M, but if this vector
% is bigger than the number of columns in M, need to add
% columns to M in order to store it:
if n_data > ncol_M
% add columns of NaNs to M:
M = [M NaN(nrow_M,n_data-ncol_M)];
% update the variable storing the number of columns of M:
ncol_M = n_data;
end
% put the new vector in place in the current row of M:
M(row,1:n_data) = new_data;
end
% see the result:
disp(M);
Columns 1 through 19
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.0003 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0.0009 0 0 0 0 0 0 0 0 0
0 0 0.0023 0 0.0018 0 0 0 0 0 0 0 0.0205 0 0 0 0 0 0
0 0.0063 0 0 0 0 0 0 0 0 0.0001 0.0003 0 0 0 0.0001 0 0 0
0.0002 0 0.0129 0.0001 0 0.0070 0.0015 0 0 0.0089 0.0016 0 0 0 0.0016 0 0.0000 0 0
0.0026 0 0.0138 0.0002 0 0 0.0120 0.0002 0 0 0.0015 0 0.0073 0.0001 0 0 0.0026 0.0002 0
0.0006 0 0 0.0001 0.0192 0.0002 0 0.0002 0.0001 0.0066 0 0 0.0047 0 0 0.0036 0 0.0004 0
0.0111 0.0006 0.0106 0.0131 0 0.0177 0.0005 0.0017 0 0.0166 0.0130 0.0103 0.0002 0 0 0.0129 0.0111 0.0012 0.0082
0.4390 0 0.3372 0.0608 0 0 0.0455 0 0.5080 0 0 0.1900 0 0.1567 0.0923 0 0.0350 0 0.1602
0 0.0170 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0701 0 0 0.0840 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0.0001 0 0 0 0 0 0 0 0.1471 0 0.0000 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0.0032 0 0 0 0 0
0 0 0.0166 0 0.3353 0 0.0065 0 0 0.2044 0 0.0203 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0.0057 0 0 0 0.0005 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0.0012 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0.0388 0 0 0.2367 0 0 0 0 0 0 0 0 0 0.0532
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0.9875 0 0 0 0.0276 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0002 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0651 0.0442 0.0294 0 0 0 0.1715 0 0 0 0.0227 0.0090 0 0 0 0.0823 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0.0000 0.0051 0 0 0 0 0.1104 0
0 0.0438 0 0 0 0.0932 0 0 0 0 0.0000 0 0 0 1.9981 0.1148 0 0.0035 0
0.0388 0 0.0001 0 0 0 0.0050 0.0176 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0.0019 0.0001 0 0 0 0 0 0 0 0 0 0 0.0044
0 0 0.0043 0 0 0 0 0.0825 0 0.0008 0 0 0 0 0 0 0.0773 0 0.5316
0 0.0991 0.0041 0 0 0 0 0 0 0 0.0027 0 0 0 0 0.0007 0 0.0154 0.0097
0 0 0 0 0 0 0 0 0 0 0 0 0.0271 0 0.1422 0 0 0 0
0.0031 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0044 0 0
0 0 0 0 0 0.0008 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.8410 0 0 0 0.0295 0 0 0 0 0 0 0 0 0 0 0 0 0.0044
0 0 0.0546 0.0009 0 0 0 0 0.0216 0 0.0188 0 0 0 0 0.0038 0 0 0
0 0.1207 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0103 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0009 0 0
0.0119 0 0 0 0 0.0064 0 0.0002 0 0 0 0 0 0 0 0 0.0000 0 0
0 0 0 0 0.0058 0 0 0.0027 0 0 0 0.0002 0.0049 0 0 0 0 0 0.0584
0.0410 0 0 0 0.0178 0 0 0.0002 0 0 0 0 0.0218 0 0 0 0 0.0118 0
0 0 0 0 0.0686 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0.0082 0.0003 0 0.0016 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.0042 0 0.0184 0.2903 0 0 0 0 0.0109 0.0847 0 0 0 0 0 0 0 0.0836
0 0 0 0 0.0085 0 0 0 0 0 0 0 0 0 0 0 0 0.0063 0
0 0 0 0 0.0295 0 0 0 0 0 0 0 0 0 0 0.3304 0 0 0
0.0003 0 0 0.0262 0 0 0 0 0.0021 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0.0009 0 0 0 0 0 0 0 0
0 0.0001 0 0 0 0 0 0 0 0 0.0014 0 0 0 0.1014 0 0 0 0
0 0 0 0 0 0 0 0 0.0003 0 0 0 0 0 0 0 0.0528 0 0
0.0412 0 0 0 0 0 0 0.0006 0 0 0.0025 0 0 0 0 0 0 0 0.0000
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0073 0 0.0136
0 0 0 0 0 0.0242 0 0 0 0 0.0006 0 0 0 0 0 0 0 0
0.0000 0 0 0 0 0.2918 0.0307 0 0.0069 0.2555 0.0299 0 0.0051 0 0 0.0145 0.0429 0 0.1053
0 0 0 0 0 0 0.0036 0 0 0 0 0 0.0074 0 0 0 0.0036 0.0003 0.0007
0 0 0 0 0 0 0 0 0 0 0.0087 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0.0022 0 0 0 0 0 0.0004 0 0.0285
0 0 0 0 0 0 0 0 0 0 0.0000 0.0121 0 0 0 0 0 0 0
0 0 0 0 0 0.0613 0.0076 0 0.0836 0 0 0.0024 0 0 0 0 0.0384 0.0066 0.0510
0.0008 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.3690 0 0.2154 0 0 0.0061 0 0 0 0.0021 0 0 0 0 0 0 0.0093 0
0 0 0 0 0 0 0.0043 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0.0074 0.1286 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0.0136 0 0 0 0 0.0031 0 0 0 0 0.0024 0.0026
0 0 0 0 0 0 0.0026 0.0281 0.7808 0 0.1174 0 0 0 0 0 0 0.0129 0.5933
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0446 0 0 0
0 0.0282 0 0 0 0 0 0 0 0 0 0 0 0.0032 0.0053 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0044 0 0 0 0 0.0005 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0.0033 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0.0012 0 0 0 0 0 0 0 0.0202 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0016 0
0 0.0356 0 0 0 0 0 0 0.0154 0.0054 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0.0029 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0.0016 0 0 0.0025 0 0 0 0
0 0.0132 0 0 0 0.0007 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0.6738 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0.0756 0 0 0 0 0 0 0 0 0 0 0 0.0098 0 0 0.0432
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0.8093 0 0 0 0.0095 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0.0448 0 0 0.0225 0 0 0 0.1060 0 0 0 0 0 0
0 0 0.0049 0 0 0.0003 0 0 0 0 0 0 0 0 0 0 0 0 0.0032
0 0 0 0 0 0 0.0145 0 0 0 0 0 0.0356 0 0 0 0 0 0.0137
0 0 0 0 0 0.0014 0.0151 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0.0002 0 0.0067 0 0 0 0 0 0.0010 0 0 0 0 0
0 0 0.0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0.0132 0.0347 0 0 0 0.0090 0 0.0005 0.0153
0 0 0.0016 0.0036 0 0 0 0 0 0 0 0.0011 0 0 0 0 0 0 0
0.0011 0 0 0 0 0 0.0053 0 0 0 0 0 0 0 0.0863 0 0 0.0037 0
0 0 0 0.0048 0 0 0 0 0 0 0 0 0 0 0 0.0003 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0.1591 0 0 0.0001 0 0 0
0 0 0 0 0 0 0 0 0 0 0.0137 0 0.3251 0 0.0047 0 0 0 0
0 0 0 0 0 0 0.0241 0 0 0 0.0046 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0.0655 0 0 0 0 0.0002 0 0 0
0 0 0 0 0 0.0083 0 0 0 0 0 0 0 0 0 0.0206 0 0 0
0 0.8583 0 0 0 0 0 0 0 0 0 0 0 0.0052 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0.0063 0 0 0 0.0011 0
0 0 0 0 0 0 0 0 0 0 0.0028 0.0009 0 0 0.0000 0 0 0.0001 0
0 0 0 0 0 0.1909 0 0 0 0 0 0 0 0 0.0179 0.0020 0 0.0305 0.0015
0 0 0 0 0 0 0.0000 0 0 0 0.0017 0 0 0 0 0 0 0 0
0 0 0 0.0017 0.0024 0 0 0 0 0.0021 0 0 0 0.0025 0.0001 0 0 0 0
0 0 0 0 0 0 0.0011 0 0 0 0 0 0 0 0 0.0031 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0.3702 0.0034 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0.0189 0 0 0.0029 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0.0010 0 0 0 0 0 0 0 0.0004 0 0 0.0012 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.4380
0 0 0.0000 0 0 0 0 0 0 0 0 0.0069 0 0.0018 0 0 0 0 0
0 0 0 0 0.0009 0.0072 0 0 0 0.0004 0 0.0036 0 0 0 0 0 0 0.0005
0 0 0 0 0 0 0 0 0 0.0008 0 0.0006 0 0 0 0 0 0 0
0 0 0.0014 0 0 0 0 0 0 0 0 0.0025 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0.0338 0.0000 0 0 0 0.0374 0 0 0
0 0 0 0 0.0080 0 0 0 0 0.0004 0 0.0150 0 0 0 0.0053 0 0 0
0 0 0 0 0 0 0 0 0 0.0059 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0.0068 0 0 0 0 0 0.0012 0 0 0
0 0 0.0029 0 0 0 0 0 0 0.0002 0 0 0 0.0107 0.0011 0 0 0 0
0 0 0.1462 0 0.0018 0 0 0 0 0 0 0 0 0.0001 0.0723 0.0592 0 0.0021 0
0 0 0.0164 0 0 0 0 0 0 0.0014 0 0 0 0.0161 0 0 0 0.0000 0.0064
0 0 0 0 0.0022 0 0 0 0 0 0 0 0 0 0 0 0 0.0020 0
0 0 0 0 0 0 0 0 0.0249 0.0000 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0.0029 0 0 0 0 0.0066 0 0 0 0 0
0 0 0.0129 0 0.0667 0.0021 0 0 0.0000 0.0030 0 0 0 0.0294 0 0.1489 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0008 0 0.0030 0.0042 0
0 0 0 0 0 0.0039 0 0 0 0.0000 0 0 0 0 0.0002 0 0 0 0
0 0 0 0 0.0029 0 0 0 0 0 0 0 0 0 0 0.0208 0 0 0
0 0 0.0029 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0115 0
0 0.0223 0 0 0.0082 0.0086 0 0 0 0 0 0 0 0 0 0.0002 0 0 0
0 0.0008 0 0 0.0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.0001 0 0 0.0015 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0.0006 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0.0001 0.0474 0 0 0 0.0131 0.0525 0 0 0.0176
0 0 0 0 0.0156 0 0.0147 0 0 0 0 0.0021 0 0 0 0 0 0 0
0 0 0 0 0.0002 0 0 0 0 0 0 0.0031 0.0005 0 0 0 0 0 0
0 0 0.0000 0 0 0 0.0028 0 0 0 0 0 0 0 0 0 0 0 0.0014
0 0.0001 0.0039 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0.0019 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0.0012 0 0 0 0.0020 0 0 0.0003 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0.0021 0 0 0 0 0 0 0 0 0 0 0 0
0.0548 0 0 0 0.0014 0 0 0 0 0 0 0.0014 0 0 0 0 0 0 0
0 0 0 0 0 0 0.0008 0 0 0.0003 0.0037 0 0.0047 0 0 0 0 0 0
0 0 0 0 0.0116 0 0 0 0 0 0 0 0.3082 0 0 0 0 0.0108 0.0438
0 0.0171 0 0 0.0072 0 0.0006 0 0 0.0006 0 0 0 0 0 0 0 0.0049 0
0 0 0 0 0 0 0.0018 0 0 0 0.0021 0 0 0 0.0018 0 0 0 0
0 0.0049 0 0.1037 0 0 0 0 0 0 0.0006 0.0008 0.0047 0.0148 0 0 0 0.0062 0
0 0 0 0 0 0 0 0 0 0.0000 0 0.0000 0 0 0 0 0 0 0.0066
0.0025 0 0 0 0.0046 0 0.0246 0 0 0.0571 0.0002 0.0262 0.0007 0 0 0 0 0.0521 0
0 0 0 0 0 0.1060 0.0027 0 0.0035 0.0013 0 0 0 0.0106 0.0002 0 0 0.0000 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0580 0.0005 0.0011
0 0 0 0 0 0 0 0 0 0 0.0003 0 0 0 0 0 0 0 0
0 0.0006 0 0.0022 0 0 0 0 0 0 0.0002 0 0 0.0011 0.0003 0 0 0 0
0.0001 0 0 0 0 0 0.0062 0 0 0 0 0 0 0.0115 0 0 0 0.0038 0.1985
0.0004 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0.0018 0 0 0 0 0.0018 0 0 0.0046 0 0 0 0 0
0.0007 0.0101 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0.0076 0 0 0 0 0 0 0 0.0301 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.3088 0 0 0.0687
0 0.0242 0 0 0 0.0003 0 0 0 0 0 0 0 0.0318 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0.0027 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0000 0
0 0 0.0006 0 0 0 0 0 0 0 0 0 0 0 0.6197 0 0 0 0
0 0 0 0 0 0 0.0024 0 0 0 0 0.0153 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0235 0
0.0024 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0020
0 0 0 0 0.0046 0 0 0.0963 0 0.0093 0 0.0426 0 0 0 0 0 0 0
0.0021 0 0 0 0 0 0 0 0 0.0003 0 0 0 0 0 0 0 0 0
0.0112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0000 0 0 0 0 0 0 0 0 0.0001 0 0 0 0 0 0 0 0 0
0 0 0 0.0034 0 0 0.0004 0 0 0 0 0 0 0 0 0 0 0 0
0.0057 0 0 0 0 0 0.0271 0 0 0 0 0.0490 0 0 0 0 0 0.0130 0
0 0 0 0 0 0 0.0019 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0.0017 0 0 0 0.0225 0 0.0005 0 0 0 0 0 0 0 0 0
0 0.0016 0 0 0 0 0 0 0 0.0013 0 0 0 0 0 0 0 0 0.0027
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0.0004 0 0 0 0 0.0032 0 0 0 0 0 0.0546 0 0
0.0179 0 0 0 0.0037 0.0021 0 0 0 0 0 0 0 0 0 0 0 0.0003 0
0 0 0 0 0 0 0 0 0.0257 0 0 0 0 0 0 0 0.0142 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0012 0
0 0 0 0 0 0 0 0 0.0344 0 0 0 0 0 0 0 0 0 0
0 0 0 0.0059 0.0001 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0.0003 0 0 0 0 0.0064 0.0021 0 0
0 0 0 0 0 0.0006 0.0006 0 0.0042 0.0016 0 0 0.0007 0 0 0 0 0 0
0.0030 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0216 0 0
0.0109 0 0 0.0251 0.0030 0.0703 0 0 0.1169 0 0 0 0 0 0 0.0540 0.0018 0 0
0.0019 0 0 0 0 0 0 0 0 0.0174 0 0 0 0 0 0 0 0 0
0.0060 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0096
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0034 0
0.0003 0 0 0 0 0 0 0 0 0 0 0.0038 0 0 0 0 0 0 0.0052
0 0.0106 0 0 0 0.0692 0 0 0 0 0.0261 0 0 0 0 0 0.3654 0.0233 0
0 0 0 0 0 0.0076 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0.0074 0 0.0140 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0.0018 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0792 0.0020 0 0.0017 0 0 0 0 0.0024 0 0 0 0 0.2797 0 0 0 0 0
0 0.0042 0.0139 0.0206 0 0 0 0.0254 0.0021 0 0 0.0133 0 0 0 0 0 0.0055 0
0.0026 0 0 0.0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0059
0 0 0 0 0 0 0 0 0.0005 0 0 0.0044 0 0 0 0 0 0 0
0 0 0.0116 0 0 0 0 0 0 0 0 0 0 0.1473 0 0.0009 0 0 0
0 0 0.0011 0.0317 0 0 0.0026 0 0 0 0 0 0 0.0030 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0.0001 0 0 0 0 0 0 0 0
0 0.0011 0.0005 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0015 0
0 0 0 0.0028 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.1538 0 0.0005 0 0 0 0.1063 0 0 0 0 0 0 0 0 0 0 0
0 0.0007 0 0 0.0744 0 0 0.0203 0 0 0 0 0 0 0 0 0 0 0
0.0019 0.0002 0 0 0 0 0 0 0 0.0070 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0.0000 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0.0040 0 0 0 0 0 0 0 0 0 0 0.0010 0 0 0 0
0.0048 0.0022 0 0.0024 0 0 0.0020 0 0 0.0019 0 0.0088 0 0 0.0008 0 0 0.0388 0.0119
0 0 0 0 0 0 0 0 0 0.0001 0 0 0 0 0 0 0 0 0
0.0571 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0036 0 0.0042 0 0
0 0.0002 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.0186 0 0 0 0 0 0 0 0 0 0 0.1733 0 0.0031 0 0 0 0
0.0018 0 0 0.0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.0014 0 0 0 0 0.0000 0 0 0 0 0 0 0 0 0 0 0 0
0 0.0011 0 0.0011 0 0 0 0 0 0 0 0 0 0 0 0 0.0591 0 0
0 0 0.0199 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.0714 0 0 0.0562 0 0 0 0.2240 0 0 0 0 0 0 0 0 0 0
0.0022 0 0 0 0 0 0 0 0 0.0064 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0.0109 0 0 0 0 0 0 0 0 0.0006 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0702 0.0055 0
0 0 0 0 0.0013 0 0.0088 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0.1572 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0.0002 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0.0005 0 0 0 0 0 0.0054 0
0 0 0 0.0005 0.0054 0 0 0 0 0 0 0 0 0 0 0 0 0.0026 0
0 0 0 0 0 0 0 0 0 0.0020 0 0 0 0 0 0 0.0169 0 0
0 0 0 0 0 0 0 0 0 0 0 0.0614 0 0 0 0 0 0 0.0027
0 0 0 0 0 0 0 0 0 0 0.0026 0 0 0.0878 0 0 0.0011 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0268
0.0542 0 0 0 0 0 0 0 0 0.0060 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0.0301 0 0 0.0365 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0205 0 0.0021
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0020 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0248 0.0136 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Columns 20 through 38
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0164 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0.0081 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.0861 0 0 0.0008 0 0 0.0003 0 0 0 0 0 0.0004 0 0 0 0 0 0
0 0 0 0 0.0003 0.0220 0 0 0 0 0 0.0001 0 0 0.0104 0 0 0 0
0 0 0 0 0 0 0.0028 0 0 0 0 0.0000 0.0000 0.0002 0.0001 0 0 0 0
0 0 0 0.0144 0.0001 0.0003 0 0.0000 0.0005 0 0 0.0001 0.0002 0.0007 0 0.0082 0 0 0
0.0026 0 0.0003 0 0.0044 0.0024 0.0064 0 0.0001 0 0.0005 0.0037 0 0.0005 0.0027 0 0 0.0000 0.0027
0.0223 0 0.0000 0.0146 0.0110 0.0295 0 0 0.0106 0.0188 0 0.0111 0 0.0092 0.0178 0.0099 0 0.0108 0
0 0 0 0 0.1286 0 0.1824 0 0.2103 0 0 0.4000 0 0.8528 0 0.1726 0.1655 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0762 0 0 0
0 0 0 0 0 0 0 0.5703 0 0 0 0 0 0 0 0 0.0308 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0000 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0.0245 0 0 0 0.2772 0.0001 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0.0034 0 0 0 0 0 0 0.0354 0 0 0 0 0.0082
0 0 0 0 0 0 0 0 0 0 0 0.0026 0 0 0 0 0 0 0.1195
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0.0044 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0.0576 0.0028 0.0004 0.0038 0 0.0115 0 0.0002 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0070 0 0 0
0 0 0 0 0 0.0069 0 0.2768 0 0 0.0022 0 0 0 0.1219 0 0 0 0.0071
0 0 0 0.0008 0 0 0 0 0 0 0 0 0 0 0.0741 0.0059 0 0 0
0 0 0.0034 0 0 0 0 0 0 0 0 0 0.0750 0 0 0.0000 0 0 0
0 0 0 0.0032 0.0367 0 0.0144 0 0 0 0 0 0 0 0 0.0003 0 0 0
0 0 0 0 0 0 0.0044 0 0 0 0 0 0 0 0 0 0 0 0
0 0.0103 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.0645 0 0
0 0 0 0 0 0 0 0 0.0155 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0.0279 0 0.0525 0 0 0 0 0.3958 0 0 0.0129 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0.0498 0 0 0 0 0.0112 0 0.0087 0
0 0 0 0 0 0 0 0 0 0 0.1529 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0020 0
0 0 0 0.0002 0 0 0 0 0 0 0 0 0 0 0 0.0047 0 0 0
0 0.0905 0.0000 0.0004 0 0 0 0 0 0 0 0.0274 0 0 0 0.2750 0 0.0002 0
0 0 0 0 0 0 0 0 0 0 0 0.0018 0.0003 0 0 0.0681 0 0 0
0 0 0 0.2908 0 0 0 0 0 0 0 0 0 0 0 0 0.0065 0 0
0 0 0 0 0 0 0.0001 0 0 0 0 0 0.0006 0 0 0 0 0.0182 0
0 0 0 0 0 0 0 0 0 0 0 0.0013 0.0045 0 0 0 0 0 0
0 0 0.0012 0 0 0 0 0.4303 0 0 0 0 0.0288 0.0728 0 0.1365 0 0.0245 0
0 0.4571 0 0 0 0 0.0001 0 0 0 0 0 0 0 0 0.0107 0 0 0
0 0 0 0 0 0 0 0 0.2210 0.0059 0.0223 0 0 0 0 0 0 0.0031 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0179 0
0 0 0 0 0 0 0 0 0 0 0 0 0.0060 0 0 0 0 0.1610 0
0.0038 0 0 0 0 0 0 0 0.0663 0.0091 0 0 0 0 0 0 0 0 0
0 0 0 0 0.0318 0 0.1294 0 0.0611 0 0 0 0 0.1271 0.1356 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0.0006 0 0 0 0 0 0.0493
0 0 0 0 0 0 0.0085 0.0818 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0.0027 0 0 0 0 0 0 0
0 0 0.0005 0.0013 0 0 0 0 0 0.0000 0 0.0018 0.0000 0 0 0.0001 0 0 0
0 0 0 0 0 0.2482 0 0.1904 0 0 0 0 0 0.0327 0.0073 0 0.0689 0 0
0 0 0 0 0 0 0 0 0 0 0.0306 0 0 0 0 0.0215 0 0.0099 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0.5500 0 0 0 0 0 0 0 0.0000 0.0022 0 0 0 0 0 0 0
0 0.1727 0 0.0283 0 0 0 0 0 0 0.0131 0 0 0 0 0 0 0 0
0.0249 0.2263 0 0 0.1982 0 0.0684 0.1046 0 0 0 0 0.0012 0.0888 0 0.0005 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0086 0 0 0
0 0 0 0 0 0 0 0.0007 0 0 0 0 0.0282 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0.2528 0 0 0 0 0.0938 0 0 0
0 0 0 0 0.0022 0 0 0.0640 0 0 0.0063 0 0.0243 0.0006 0 0 0 0 0
0 0.2154 0 0 0 0.0101 0 0 0 0.0782 0 0 0 0.0407 0 0 0 0.0003 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ...
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
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 (한국어)