How do I make this code shorter

2 Ansichten (letzte 30 Tage)
Anthony Puliafico
Anthony Puliafico am 6 Dez. 2013
Beantwortet: Walter Roberson am 6 Dez. 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);

Antworten (1)

Walter Roberson
Walter Roberson am 6 Dez. 2013
You seem to be redoing the same set of calculations over and over?

Kategorien

Mehr zu Simulink Functions finden Sie in Help Center und File Exchange

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by