Index exceeds the number of array elements (0).

Question

Mohammad Dabbagh 2021-5-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/821670-index-exceeds-the-number-of-array-elements-0

编辑： Mohammad Dabbagh 2021-5-5

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

Hi all,

I was wondering if anyone could assist me with a quick question.

Actually, I'm trying to read two columns of a csv file (xlsread), find the absolute differnce between those two columns per row (called as temp_violation), and then add finally, sum it with another column and store it as Qsystem_total_cool, as follow:

Cooling_column = xlsread('eplusout.csv','eplusout','U290:U313');
zone_air_temp = xlsread('eplusout.csv','eplusout','Z290:Z313');
setpoint_temp = xlsread('eplusout.csv','eplusout','I290:I313');
alpha= 1000;
beta = 2;
temp_violation = sum(abs(zone_air_temp(296:310) - setpoint_temp(296:310)));
Qsystem_total_cool= sum(Cooling_column + alpha *  (temp_violation)^beta);

However, it shows me an error on the line starts with temp_viloation: Index exceeds the number of array elements (0).

Any ideas and help would be greatly appreciated.

Thanks!

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Mohammad Dabbagh 2021-5-4

编辑：Mohammad Dabbagh 2021-5-4

@Walter Roberson special thanks!

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2021-5-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/821670-index-exceeds-the-number-of-array-elements-0#answer_692025

在 MATLAB Online 中打开

data = readtable('eplusout.csv', 'readvariablenames', false);
Cooling_column = data{290:313,21};
zone_air_temp = data{290:313,26};
setpoint_temp = data{290:313,9};
alpha = 1000;
beta = 2;
temp_violation = sum(abs(zone_air_temp - setpoint_temp));
Qsystem_total_cool= sum(Cooling_column + alpha *  (temp_violation).^beta);