How do I make this code shorter

조회 수: 1 (최근 30일)
Anthony Puliafico
Anthony Puliafico 2013년 12월 6일
답변: 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);

답변 (1개)

Walter Roberson
Walter Roberson 2013년 12월 6일
You seem to be redoing the same set of calculations over and over?

카테고리

Help CenterFile Exchange에서 Simulink Functions에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by