Matlab code

gistfile1.txt

s = char(65:80) ;

for subj= 1:9
    sheet= strcat('BL0',num2str(subj));
    
    for ns = 1:length(s)
        range = [s(ns),'2',':',s(ns),'20000'];
        
        dat= xlsread('GSR_buttsmoothmed.xlsx',sheet, range);
        
        datarray=[];
        datarray= [datarray, dat];
        M=max(datarray);
        N=min(datarray);
        avg= mean(datarray);
        normalizer= (dat-N)/(M-N);

        
        xlswrite('GSR_dat_min_normalized.xlsx',normalizer,sheet,range);

    end
    
    
end