Error: Index out of bounds

I am running the following MATLAB code to get the weekly average of data in 52704 columns. The data is getting imported correctly, but the last column in the array of week_speed is not getting filled.

month=xlsread('2004.xlsx','11517-2004','B2: B52705'); % Extracting month
day=xlsread('2004.xlsx','11517-2004','C2: C52705');% Extracting day
seconds=xlsread('2004.xlsx','11517-2004','F2: F52705');%Extracting seconds
wind_speed=xlsread('2004.xlsx','11517-2004','H2: H52705');%Extractng wind speed
index=1;
week_speed=zeros(53,1);
average=zeros(53,1);
week=1;
incr=1;
index_avg=1;
count=zeros(53,1);
while incr<=52704
    while week<55
        while index<=1008
            week_speed(week)=week_speed(week)+wind_speed(incr);
            index=index+1;
            incr=incr+1;
        end
        average(index_avg)=week_speed(week)./1008;
        count(week)=week;
        index_avg=index_avg+1;
        index=1;
        week=week+1;
    end
end
plot(count,average);

Error Displayed:

Attempted to access wind_speed(52705); 
index out of bounds because numel(wind_speed)=52704.

[madhan ravi]

Can you press the code button while selecting the whole code?And also upload the excel file/s.

[ANOSH PHIROZ AMARIA]

ive uploaded the csv file. your solution didnt work

[Adam]

Use the option to stop/pause on errors from the breakpoints menu and debug. It's by far the fastest way to solve these problems.

[madhan ravi]

where is the excel file 2004.xlsx as you mentioned in the code?

[ANOSH PHIROZ AMARIA]

its the same file. just has a different name. I am able to access the data from the file, thats not the problem

[Image Analyst]

ANOSH, but WE can't! You uploaded a csv file but then your code opens an xlsx file. The extensions are different so the file format is different. It's not simply a different name.

If you want us to help you, make it EASY to help you not hard.

Here is what happens when I try your code on the uploaded file:

csvFullFileName =
    'D:\Matlab\work\Tests\11517-2004.csv'
Error using dlmread (line 147)
Mismatch between file and format character vector.
Trouble reading 'Numeric' field from file (row number 1, field number 1) ==> Year,Month,Day,Hour,Minute,Seconds,SCORE-lite
Power Output 100m,Wind Speed\n
Error in csvread (line 48)
    m=dlmread(filename, ',', r, c);
Error in test1 (line 2)
data = csvread(csvFullFileName);

[ANOSH PHIROZ AMARIA]

ohh so sorry I uploaded the wrong format. Just attached the right one

[madhan ravi]

first of all explain what you are doing inside the loop it's all scattered and hard to interpret

Answer 1

[madhan ravi]

[num,txt,raw]=xlsread('11517_2004.xlsx')
month=num(:,2)
day=num(:,3)
seconds=num(:,6)
wind_speed=num(:,8)
week_speed=zeros(numel(wind_speed),1);
for i=1:numel(wind_speed)
    count(i)=i;
    week_speed(i)=week_speed(i)+wind_speed(i);
    average(i)=week_speed(i)./1008;
end
plot(count(1:54-1),average(1:54-1))

[madhan ravi]

If it's not what you are looking for , let know.