How do I make this code shorter
Afficher commentaires plus anciens
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);
Réponses (1)
Walter Roberson
le 6 Déc 2013
0 votes
You seem to be redoing the same set of calculations over and over?
Catégories
En savoir plus sur Simulink Functions dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!