Index exceeds the number of array elements (0).

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!

[Mohammad Dabbagh]

@Walter Roberson special thanks!

Answer 1

[Walter Roberson]

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);

[Mohammad Dabbagh]

Thank you so much Walter! You’re absolutely wonderful!