how can I reduce the length of long Mfile

Hi all, I have a .m file which has too much variable. I try to plot a graph about huge matrix. But my computer compile function about 3 hours. Can any one shorten it? thanks alot. function Rgrafik

R48=xlsread('Ras.xlsx', '48'); R49=xlsread('Ras.xlsx', '49'); R50=xlsread('Ras.xlsx', '50'); R51=xlsread('Ras.xlsx', '51'); R52=xlsread('Ras.xlsx', '52'); R53=xlsread('Ras.xlsx', '53'); R54=xlsread('Ras.xlsx', '54'); R55=xlsread('Ras.xlsx', '55'); R56=xlsread('Ras.xlsx', '56'); R57=xlsread('Ras.xlsx', '57'); R58=xlsread('Ras.xlsx', '58'); R59=xlsread('Ras.xlsx', '59'); R60=xlsread('Ras.xlsx', '60'); R61=xlsread('Ras.xlsx', '61'); R62=xlsread('Ras.xlsx', '62'); R63=xlsread('Ras.xlsx', '63'); R64=xlsread('Ras.xlsx', '64'); R65=xlsread('Ras.xlsx', '65'); R66=xlsread('Ras.xlsx', '66'); R67=xlsread('Ras.xlsx', '67'); R68=xlsread('Ras.xlsx', '68'); R69=xlsread('Ras.xlsx', '69'); R70=xlsread('Ras.xlsx', '70'); R71=xlsread('Ras.xlsx', '71'); R72=xlsread('Ras.xlsx', '72'); R73=xlsread('Ras.xlsx', '73'); R74=xlsread('Ras.xlsx', '74'); R75=xlsread('Ras.xlsx', '75'); R76=xlsread('Ras.xlsx', '76'); R77=xlsread('Ras.xlsx', '77'); R78=xlsread('Ras.xlsx', '78'); R79=xlsread('Ras.xlsx', '79'); R80=xlsread('Ras.xlsx', '80'); R81=xlsread('Ras.xlsx', '81'); R82=xlsread('Ras.xlsx', '82'); R83=xlsread('Ras.xlsx', '83'); R84=xlsread('Ras.xlsx', '84'); R85=xlsread('Ras.xlsx', '85'); R86=xlsread('Ras.xlsx', '86'); R87=xlsread('Ras.xlsx', '87'); R88=xlsread('Ras.xlsx', '88'); R89=xlsread('Ras.xlsx', '89'); R90=xlsread('Ras.xlsx', '90'); R91=xlsread('Ras.xlsx', '91'); R92=xlsread('Ras.xlsx', '92'); R93=xlsread('Ras.xlsx', '93'); R94=xlsread('Ras.xlsx', '94'); R95=xlsread('Ras.xlsx', '95'); R96=xlsread('Ras.xlsx', '96');

R48no=xlsread('Rnoas.xlsx', '48'); R49no=xlsread('Rnoas.xlsx', '49'); R50no=xlsread('Rnoas.xlsx', '50'); R51no=xlsread('Rnoas.xlsx', '51'); R52no=xlsread('Rnoas.xlsx', '52'); R53no=xlsread('Rnoas.xlsx', '53'); R54no=xlsread('Rnoas.xlsx', '54'); R55no=xlsread('Rnoas.xlsx', '55'); R56no=xlsread('Rnoas.xlsx', '56'); R57no=xlsread('Rnoas.xlsx', '57'); R58no=xlsread('Rnoas.xlsx', '58'); R59no=xlsread('Rnoas.xlsx', '59'); R60no=xlsread('Rnoas.xlsx', '60'); R61no=xlsread('Rnoas.xlsx', '61'); R62no=xlsread('Rnoas.xlsx', '62'); R63no=xlsread('Rnoas.xlsx', '63'); R64no=xlsread('Rnoas.xlsx', '64'); R65no=xlsread('Rnoas.xlsx', '65'); R66no=xlsread('Rnoas.xlsx', '66'); R67no=xlsread('Rnoas.xlsx', '67'); R68no=xlsread('Rnoas.xlsx', '68'); R69no=xlsread('Rnoas.xlsx', '69'); R70no=xlsread('Rnoas.xlsx', '70'); R71no=xlsread('Rnoas.xlsx', '71'); R72no=xlsread('Rnoas.xlsx', '72'); R73no=xlsread('Rnoas.xlsx', '73'); R74no=xlsread('Rnoas.xlsx', '74'); R75no=xlsread('Rnoas.xlsx', '75'); R76no=xlsread('Rnoas.xlsx', '76'); R77no=xlsread('Rnoas.xlsx', '77'); R78no=xlsread('Rnoas.xlsx', '78'); R79no=xlsread('Rnoas.xlsx', '79'); R80no=xlsread('Rnoas.xlsx', '80'); R81no=xlsread('Rnoas.xlsx', '81'); R82no=xlsread('Rnoas.xlsx', '82'); R83no=xlsread('Rnoas.xlsx', '83'); R84no=xlsread('Rnoas.xlsx', '84'); R85no=xlsread('Rnoas.xlsx', '85'); R86no=xlsread('Rnoas.xlsx', '86'); R87no=xlsread('Rnoas.xlsx', '87'); R88no=xlsread('Rnoas.xlsx', '88'); R89no=xlsread('Rnoas.xlsx', '89'); R90no=xlsread('Rnoas.xlsx', '90'); R91no=xlsread('Rnoas.xlsx', '91'); R92no=xlsread('Rnoas.xlsx', '92'); R93no=xlsread('Rnoas.xlsx', '93'); R94no=xlsread('Rnoas.xlsx', '94'); R95no=xlsread('Rnoas.xlsx', '95'); R96no=xlsread('Rnoas.xlsx', '96');

R48M=mean(mean(R48)); R49M=mean(mean(R49)); R50M=mean(mean(R50)); R51M=mean(mean(R51)); R52M=mean(mean(R52)); R53M=mean(mean(R53)); R54M=mean(mean(R54)); R55M=mean(mean(R55)); R56M=mean(mean(R56)); R57M=mean(mean(R57)); R58M=mean(mean(R58)); R59M=mean(mean(R59)); R60M=mean(mean(R60)); R61M=mean(mean(R61)); R62M=mean(mean(R62)); R63M=mean(mean(R63)); R64M=mean(mean(R64)); R65M=mean(mean(R65)); R66M=mean(mean(R66)); R67M=mean(mean(R67)); R68M=mean(mean(R68)); R69M=mean(mean(R69)); R70M=mean(mean(R70)); R71M=mean(mean(R71)); R72M=mean(mean(R72)); R73M=mean(mean(R73)); R74M=mean(mean(R74)); R75M=mean(mean(R75)); R76M=mean(mean(R76)); R77M=mean(mean(R77)); R78M=mean(mean(R78)); R79M=mean(mean(R79)); R80M=mean(mean(R80)); R81M=mean(mean(R81)); R82M=mean(mean(R82)); R83M=mean(mean(R83)); R84M=mean(mean(R84)); R85M=mean(mean(R85)); R86M=mean(mean(R86)); R87M=mean(mean(R87)); R88M=mean(mean(R88)); R89M=mean(mean(R89)); R90M=mean(mean(R90)); R91M=mean(mean(R91)); R92M=mean(mean(R92)); R93M=mean(mean(R93)); R94M=mean(mean(R94)); R95M=mean(mean(R95)); R96M=mean(mean(R96));

R48noM=mean(mean(R48no)); R49noM=mean(mean(R49no)); R50noM=mean(mean(R50no)); R51noM=mean(mean(R51no)); R52noM=mean(mean(R52no)); R53noM=mean(mean(R53no)); R54noM=mean(mean(R54no)); R55noM=mean(mean(R55no)); R56noM=mean(mean(R56no)); R57noM=mean(mean(R57no)); R58noM=mean(mean(R58no)); R59noM=mean(mean(R59no)); R60noM=mean(mean(R60no)); R61noM=mean(mean(R61no)); R62noM=mean(mean(R62no)); R63noM=mean(mean(R63no)); R64noM=mean(mean(R64no)); R65noM=mean(mean(R65no)); R66noM=mean(mean(R66no)); R67noM=mean(mean(R67no)); R68noM=mean(mean(R68no)); R69noM=mean(mean(R69no)); R70noM=mean(mean(R70no)); R71noM=mean(mean(R71no)); R72noM=mean(mean(R72no)); R73noM=mean(mean(R73no)); R74noM=mean(mean(R74no)); R75noM=mean(mean(R75no)); R76noM=mean(mean(R76no)); R77noM=mean(mean(R77no)); R78noM=mean(mean(R78no)); R79noM=mean(mean(R79no)); R80noM=mean(mean(R80no)); R81noM=mean(mean(R81no)); R82noM=mean(mean(R82no)); R83noM=mean(mean(R83no)); R84noM=mean(mean(R84no)); R85noM=mean(mean(R85no)); R86noM=mean(mean(R86no)); R87noM=mean(mean(R87no)); R88noM=mean(mean(R88no)); R89noM=mean(mean(R89no)); R90noM=mean(mean(R90no)); R91noM=mean(mean(R91no)); R92noM=mean(mean(R92no)); R93noM=mean(mean(R93no)); R94noM=mean(mean(R94no)); R95noM=mean(mean(R95no)); R96noM=mean(mean(R96no));

y=1:1:49; Ras=[R48M R49M R50M R51M R52M R53M R54M R55M R56M R57M R58M R59M R60M R61M R62M R63M R64M R65M R66M R67M R68M R69M R70M R71M R72M R73M R74M R75M R76M R77M R78M R79M R80M R81M R82M R83M R84M R85M R86M R87M R88M R89M R90M R91M R92M R93M R94M R95M R96M]; Rno=[R48noM R49noM R50noM R51noM R52noM R53noM R54noM R55noM R56noM R57noM R58noM R59noM R60noM R61noM R62noM R63noM R64noM R65noM R66noM R67noM R68noM R69noM R70noM R71noM R72noM R73noM R74noM R75noM R76noM R77noM R78noM R79noM R80noM R81noM R82noM R83noM R84noM R85noM R86noM R87noM R88noM R89noM R90noM R91noM R92noM R93noM R94noM R95noM R96noM ]; plot(y,Ras); hold on plot(y,Rno); hold off

[Walter Roberson]

Are those '48' and so on sheet names, or are they ranges? You are taking mean(mean()) which would tend to suggest they are not rows or columns.

Also, are you using MS Windows?

Answer 1

[Walter Roberson]

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

http://matlab.wikia.com/wiki/FAQ#How_can_I_create_variables_A1.2C_A2.2C....2CA10_in_a_loop.3F

Answer 2

[Image Analyst]

I see no reason why that would take 3 hours to compile. It should take about 3-5 minutes. It might take a very very long time to run either the compiled program (stand alone executable) or the m-file (in the development environment) because you are calling xlsread() about 50 times. And it has to launch Excel, read in the stuff, and shut down Excel 50 times. That will take forever. If you need to call xlsread() more than about 2 or 3 times, you need to use ActiveX, unless you are more willing to wait than to learn new programming commands. Demos have been posted here on that. Let me know if you want me to include mine.