Hi,
Basically I have a huge amount of data, which I am writing a script for.
Essentially, i am trying to create 3 graphs per pH value at different wavelengths.
I have this so far:
Direc=dir("c:/Users/Documents")
FileName=xlsread("Exp1FApHluorinTEST.xlsx")
T=(0:8:1072);
Dat=[];
Ave=[]
j=1;
[rows,cols]=size(FileName);
I have a data set which looks like this, I know it's a lot, sorry 
Essentially, I want to create a graph, I know how to do this, but I do not know how to create a for/if loop to take all the information from 395nm for the entire dataset at each timepoint, and for each condition.
There are 135 readings for each wavelength, and essentially the conditions are tested in triplicate, so I have a rough code of what I used previously which is:
for i=1:cols;
if mod(i,2)==0;
Dat(:,j)=FileName(:,i);
j=j+1;
end
end
for j=1:(cols/2)
for i=1:(rows/3)
Ave(i,j)=mean([Dat((3*i-2),j) Dat((3*i-1),j) Dat((3*i),j) ]);
end
end
Though this is for a different data set where I required only the use of every other column, and then averaging of the 3 rows across that column, now I need every column.
If this makes sense, could someone please help me.
Thank you
