How do I make this code shorter

Question

Anthony Puliafico 2013 年 12 月 6 日

0
リンク

この質問への直接リンク

https://jp.mathworks.com/matlabcentral/answers/108848-how-do-i-make-this-code-shorter

回答済み: Walter Roberson 2013 年 12 月 6 日

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);