How do I make this code shorter

1 view (last 30 days)
Anthony Puliafico
Anthony Puliafico on 6 Dec 2013
Answered: Walter Roberson on 6 Dec 2013
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);

Answers (1)

Walter Roberson
Walter Roberson on 6 Dec 2013
You seem to be redoing the same set of calculations over and over?

Categories

Find more on Simulink Functions in Help Center and File Exchange

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!