How to read from one column of excel (from row 40 to 80) and can match it with the other column as well?

3 views (last 30 days)
Ara
Ara on 13 Dec 2012
Hi Guys, I am trying to show five satellites in one plot.I have one excel file with 32 column and one of the column is related to time so I need to plot it in a specific time for ex, (5-10)ut. The problem is can not match the dimension of the rest matrix.
data=xlsread('1612_2.xls');
data_filterr=find(data(:,25)>60);
data_filtered=data(data_filterr,:);
elev_cutof20=find(data_filtered(:,6)>30);
data_cutoff15=data_filtered(elev_cutof20,:);
r=data_cutoff15(:,2);
time=(r./3600)-24*2;
s4r=data_cutoff15(:,8);
s4cor=data_cutoff15(:,9);
s4=sqrt(s4r.^2-s4cor.^2);
PRN=data_cutoff15(:,3);
I want to plot each PRN different color(satellite)in a certain time in a one figure. Could be for example, 5 PRN at that time.
Could you please help me?
  1 Comment
Ara
Ara on 13 Dec 2012
Thank you, just one more thing. I really do not know from each row start the time for ex, 5ut so all I want to do is choose from time column those data are between 5-10 and then sort the rest of data as well.

Sign in to comment.

Sign in to answer this question.

Accepted Answer

Pedro Villena
Pedro Villena on 13 Dec 2012
Edited: Pedro Villena on 13 Dec 2012
data = xlsread('1612_2.xls','A40:AF80');
  3 Comments
Show 1 older comment
José-Luis
José-Luis on 17 Dec 2012
Read the entire range and select only the data you want afterwards. Alternatively, read twice, specifying a different range every time. Personally, I would go with the first option. Or you could use the activeX server, but for just one file and so little data, it's probably overkill.

Sign in to comment.

More Answers (0)

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!