How do I make this code shorter
1 view (last 30 days)
Show older comments
I need to make this code code bellow shorter.
clear all
DATA='MASTER_DATA.xlsx';
SH1='Mobile_Cellular_Subscriptions';
YR=xlsread(DATA,SH1,'B:B','functionHandle');
VAL=xlsread(DATA,SH1,'C:C','functionHandle');
LOCVALS90=find(YR==2012);
LOCVALS91=find(YR==2010);
LOCVALS92=find(YR==2011);
LOCVALS93=find(YR==2012);
LOCVALS94=find(YR==2010);
LOCVALS95=find(YR==2011);
LOCVALS96=find(YR==2012);
LOCVALS97=find(YR==2010);
LOCVALS98=find(YR==2011);
LOCVALS99=find(YR==2012);
LOCVALS00=find(YR==2012);
LOCVALS01=find(YR==2010);
LOCVALS02=find(YR==2011);
LOCVALS03=find(YR==2012);
LOCVALS04=find(YR==2010);
LOCVALS05=find(YR==2011);
LOCVALS06=find(YR==2012);
LOCVALS07=find(YR==2010);
LOCVALS08=find(YR==2011);
LOCVALS09=find(YR==2012);
LOCVALS10=find(YR==2010);
LOCVALS11=find(YR==2011);
LOCVALS12=find(YR==2012);
ALLVALS90=[VAL(LOCVALS90)];
ALLVALS91=[VAL(LOCVALS91)];
ALLVALS92=[VAL(LOCVALS92)];
ALLVALS93=[VAL(LOCVALS93)];
ALLVALS94=[VAL(LOCVALS94)];
ALLVALS95=[VAL(LOCVALS95)];
ALLVALS96=[VAL(LOCVALS96)];
ALLVALS97=[VAL(LOCVALS97)];
ALLVALS98=[VAL(LOCVALS98)];
ALLVALS99=[VAL(LOCVALS99)];
ALLVALS00=[VAL(LOCVALS00)];
ALLVALS01=[VAL(LOCVALS01)];
ALLVALS02=[VAL(LOCVALS02)];
ALLVALS03=[VAL(LOCVALS03)];
ALLVALS04=[VAL(LOCVALS04)];
ALLVALS05=[VAL(LOCVALS05)];
ALLVALS06=[VAL(LOCVALS06)];
ALLVALS07=[VAL(LOCVALS07)];
ALLVALS08=[VAL(LOCVALS08)];
ALLVALS09=[VAL(LOCVALS09)];
ALLVALS10=[VAL(LOCVALS10)];
ALLVALS11=[VAL(LOCVALS11)];
ALLVALS12=[VAL(LOCVALS12)];
TOL90=sum(ALLVALS90);
TOL91=sum(ALLVALS91);
TOL92=sum(ALLVALS92);
TOL93=sum(ALLVALS93);
TOL94=sum(ALLVALS94);
TOL95=sum(ALLVALS95);
TOL96=sum(ALLVALS96);
TOL97=sum(ALLVALS97);
TOL98=sum(ALLVALS98);
TOL99=sum(ALLVALS99);
TOL00=sum(ALLVALS00);
TOL01=sum(ALLVALS01);
TOL02=sum(ALLVALS02);
TOL03=sum(ALLVALS03);
TOL94=sum(ALLVALS04);
TOL95=sum(ALLVALS05);
TOL96=sum(ALLVALS06);
TOL97=sum(ALLVALS07);
TOL98=sum(ALLVALS08);
TOL99=sum(ALLVALS09);
TOL10=sum(ALLVALS10);
TOL11=sum(ALLVALS11);
TOL12=sum(ALLVALS12);
0 Comments
Answers (1)
Walter Roberson
on 6 Dec 2013
You seem to be redoing the same set of calculations over and over?
0 Comments
See Also
Categories
Find more on Simulink Functions in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!