Index exceeds the number of array elements (0).

1 次查看（过去 30 天）
Mohammad Dabbagh
Mohammad Dabbagh 2021-5-4
编辑： Mohammad Dabbagh 2021-5-5
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!

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

采纳的回答

Walter Roberson
Walter Roberson 2021-5-4
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);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by