Using If statement with data from excel

Hi, I would like to write an if statement where if RTcout<Ta , RTcout=Ta. The difficulty im having is that Ta has not been defined in the script but has been subbed into equations. Below is an example of the code:

Tcout1 = (subs(Tcout,{J,Ta,Vw},{numData1(2:25,6)',numData1(2:25,8)',numData1(2:25,12)'}));
RTcout = real(Tcout1);

Any help would be appreciated.

Answer 1

[Star Strider]

Do the threshold operation before you do the substitution:

numData = randi(500, 1, 10);                                        % Original Data
JData = numData;                                                    % Create New Data Vector
JData(Jdata < 200) = 0;                                             % Threshold Or Substitute Data

syms a b J 
v = a*b + J;
vnew = subs(v, {J,a,b},{numData', randi(9,1,10)',randi(9,1,10)'})   % Substitute Thresholded Data

It would be more illustrative with your code and data, however we do not have enough of that to use.

[Star Strider]

Where is ‘1Day.xlsx’?

Can’t run your code without the file.

[Star Strider]

Thank you.

Try this (only the very last section copied and pasted here):

%%
hours = 0:23;
%%
Ta = numData1(2:25,8)';
RTcout = double(vpa(real(Tcout1)));
Tam = ones(size(RTcout,1),1) * Ta;
RTcout(RTcout < Ta) = Tam(RTcout < Ta);
% if RTcout <Ta;
%    RTcout=Ta
% end
plot(hours,RTcout(2,:));
xlabel('Time of day')

That appears to do the replacements correctly. The only necessary change was to create ‘RTcout’ as a double array so that the replacement with non-symbolic ‘Ta’ would work. (The ‘Tam’ array creates a matrix from ‘Ta’ so the dimensions are the same.) The rest is just ‘logical indexing’.

[rammah nagi]

Thank you very much

[Star Strider]

As always, my pleasure.