Extracting Specific Rows From xlsx or txt File

10 views (last 30 days)
Joseph Salerno
Joseph Salerno on 6 Oct 2023
Commented: Anton Kogios on 10 Oct 2023
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?

Sign in to answer this question.

Accepted Answer

Anton Kogios
Anton Kogios on 6 Oct 2023
Edited: Anton Kogios on 6 Oct 2023
Ran in:
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
data = 1×251 struct array with fields:
Time Force
  2 Comments
Joseph Salerno
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
Anton Kogios on 10 Oct 2023
Ran in:
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!

Sign in to comment.

More Answers (1)

Voss
Voss on 6 Oct 2023
Edited: Voss on 6 Oct 2023
Ran in:
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 ...

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Products


Release

R2023a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!