@tomleslie The mw file is not really cleaned up for publishing. Here is the main parts copied out.

Initial excel flat file form AISC,

https://www.aisc.org/globalassets/aisc/manual/v15.0-shapes-database/aisc-shapes-database-v15.0.xlsx

Maple:

Mydatafile := "aisc-shapes-database-v15.xlsx"

Steel_data := Import(Mydatafile, "Database v15.0")

Size(Steel_data)

len_Steel_data := Size(Steel_data)[1]

S_mod__min := 11.66666667

j := 1 (index for sub data collection matrix)

> for i to len_Steel_data do

if S_mod__min < Steel_data[i, 41] and Steel_data[i, 7] <= 10.5 then

location1_row[j] := i;

location1_row[j, 2] := Steel_data[i, 7]; j := j + 1;

end if;

OUTPUT

indices(location1_row);

[1082, 2], [1086, 2], [1087], [1086], [1085], [1084], [1083], [1082], [1085, 2], [1083, 2], [1087, 2], [1084, 2]

entries(location1_row);

[10.1], [9.73], [255], [254], [253], [252], [251], [250], [9.92], [10.0], [10.5], [10.1]

location1_row[1082];

250

numelems(location1_row);

12

for i in entries(location1_row, 'pairs') do

print(i);

location1_row[i];

end do;

(1082, 2) = 10.1

location1_row[(1082, 2) = 10.1]

(1086, 2) = 9.73

location1_row[(1086, 2) = 9.73]

1087 = 255

location1_row[1087 = 255]

1086 = 254

location1_row[1086 = 254]

1085 = 253

location1_row[1085 = 253]

1084 = 252

location1_row[1084 = 252]

1083 = 251

location1_row[1083 = 251]

1082 = 250

location1_row[1082 = 250]

(1085, 2) = 9.92

location1_row[(1085, 2) = 9.92]

(1083, 2) = 10.0

location1_row[(1083, 2) = 10.0]

(1087, 2) = 10.5

location1_row[(1087, 2) = 10.5]

(1084, 2) = 10.1

location1_row[(1084, 2) = 10.1]

end do

CLUMSEY OUTPUT TO INDEX NEXT ACTIONS ON (IMHO as List, with ramdom indices refs)

To use as a data vector to perform extra work on subset.

Establishing the size prior to first query and su set generation vs using "MyData[i] := assign value to matrix or array variable location" doesn't work well. The pre DIM of array constructor seems a Fortran or C model vs dynamic managament of Size(M).

Have not used dataframe or select but have used Matlab with this type indexing. P.S., not a fan of Matlab for many other reasons. Really just wanter better understanding and ease with using and manipulating data in matrices from either equation generation data, or data from a reference source.

FYI, this short vid shows an indexing loop in Matlab to generate matrix elements. Note ease of establisment :-) https://www.youtube.com/watch?v=ESpvG6cgY5c

Thanks again in advance.

Bill