Jesse Finnell asked . 2023-07-11

How do you access table data to be used with basic operators?

%% Test Sheet

%% Open data location

% find open Excel File (if multiple, chooses 'current')
DB = actxGetRunningServer('Excel.Application');

% choose correct tab
DBsheet = DB.ActiveWorkbook.Sheets;
DBsheet = DBsheet.get('Item',15);
DBsheet.Activate;

%% Import data

% Specify range and import data
range = 'L5:O14';
data = DBsheet.Range(range).Value;

% Setup transposition of data to fit table
[rows, columns] = size(data);
dataTranspose = cell(columns, rows);

% Loop to transpose one row at a time
for row = 1:rows;
    % Loop columns
    for col = 1:columns;
        % Transpose
        dataTranspose{col, row} = data{row, col};
    end
end

% Conver to table and assign variable names
data = array2table(dataTranspose, 'VariableNames',{'ATAD','TDS','Depth','Standard','SF','Design',...
    'Alt 1','Alt 2','Alt 3','Alt 4'});

%% find modifiers

% Determine TDS factor - This works fine
TDS = data{:,"TDS"};
for row = 1:numel(TDS);
    if TDS{row} > 1000
        ktds(row) = exp(9.65*10^(-5)*(2000-1000));
    else
        ktds = 1;
    end
end
% Find standard factor - this breaks as I need to access a Depth value that
% corresponds to the row of the loop
STD = data{:,"Standard"};
for row = 1:numel(STD);
    if STD{row} == 'DWA'
        standard(row) = 1-2.29*10^(-4)*(data(row,"Depth")/3.2808)^2+9.19*10^(-3)*(data(row,"Depth")/3.2808);
    else
        standard = 1;
    end
end

>> for row = 1:numel(STD);
    if STD{row} == 'DWA'
        standard(row) = 1-2.29*10^(-4)*(data(row,"Depth")/3.2808)^2+9.19*10^(-3)*(data(row,"Depth")/3.2808);
    else
        standard = 1;
    end
end
Error using  / 
Arguments must be numeric, char, or
logical.

Is there a way to access these numerical values within the formula? I've tried dot indexing Value like in my previous code, but that receives an error as well. Do I need to use another nested loop? I'm still fairly inexperienced and have trouble diagnosing these problems.

indexing , loops , Data Types , Tables