Contents
Statistici ale Redobandirii Cetateniei la Bucuresti
months = {'Dec2010','Jan2011','Feb2011','March2011','April2011',...
'May2011','June2011','July2011','Sep2011','Oct2011'};
figure_title = {'DEC 2010','JAN 2011', 'FEB 2011','MARCH 2011',...
'APRIL 2011','MAY 2011','JUNE 2011','JULY 2011',...
'SEPTEMBER 2011','OCTOBER 2011'};
len = zeros(1,10);
lenn = cell(1,length(months));
Years={'2001','2002','2003','2004','2005','2006',...
'2007','2008','2009','2010','2011'};
for k=1:length(months)
[data,textdata] = xlsread('ANC_Bucuresti',months{k});
dosar = cell(1,11);
indexx = 1;
for i=1:length(textdata)
position = strfind(textdata{i},'/');
switch textdata{i}(position+1:end)
case '2001'
dosar{1}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
case '2002'
dosar{2}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
case '2003'
dosar{3}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
case '2004'
dosar{4}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
case '2005'
dosar{5}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
case '2006'
dosar{6}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
case '2007'
dosar{7}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
case '2008'
dosar{8}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
case '2009'
dosar{9}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
case '2010'
dosar{10}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
case '2011'
dosar{11}(indexx) = str2double(textdata{i}(1:position-1));
indexx = indexx+1;
end
end
for i=1:length(dosar)
dosar{i} = nonzeros(dosar{i});
len(i) = length(dosar{i});
figure
bar(sort(dosar{i}))
title(['BUCHAREST ',figure_title{k},' : ','Dosare ',Years{i},' : ',...
num2str(length(dosar{i}))],'FontSize',12)
ylabel('Numar de Dosar','FontSize',12)
end
lenn{k} = len;
fprintf(['Dosare solutionate pentru ',figure_title{k},...
' in numar de : ',num2str(length(textdata)),'\n']);
Dosare solutionate pentru DEC 2010 in numar de : 472
Dosare solutionate pentru JAN 2011 in numar de : 946
Dosare solutionate pentru FEB 2011 in numar de : 960
Dosare solutionate pentru MARCH 2011 in numar de : 974
Dosare solutionate pentru APRIL 2011 in numar de : 529
Dosare solutionate pentru MAY 2011 in numar de : 730
Dosare solutionate pentru JUNE 2011 in numar de : 384
Dosare solutionate pentru JULY 2011 in numar de : 183
Dosare solutionate pentru SEPTEMBER 2011 in numar de : 552
Dosare solutionate pentru OCTOBER 2011 in numar de : 731
close all
switch months{k}
case 'Dec2010'
pie(100*[len(3),len(9),len(10),len(5),len(6),...
length(textdata)-len(3)-len(9)-len(10)-...
len(5)-len(6)]/length(textdata),...
{'2003','2009','2010','2005','2006','Alti Ani'})
legend(['2003 ',num2str(100*len(3)/length(textdata)),' %'],...
['2009 ',num2str(100*len(9)/length(textdata)),' %'],...
['2010 ',num2str(100*len(10)/length(textdata)),' %'],...
['2005 ',num2str(100*len(5)/length(textdata)),' %'],...
['2006 ',num2str(100*len(6)/length(textdata)),' %'],...
['Alti Ani ',num2str( 100*(length(textdata)-len(3)-len(9)-...
len(5)-len(6)-len(10))/length(textdata) ),' %'],...
'Location','BestOutside')
title(['BUCHAREST ',figure_title{k}],'FontSize',15)
case 'Jan2011'
pie(100*[len(3),len(9),len(10),...
length(textdata)-len(3)-len(9)-len(10)]/length(textdata),...
{'2003','2009','2010','Alti Ani'})
legend(['2003 ',num2str(100*len(3)/length(textdata)),' %'],...
['2009 ',num2str(100*len(9)/length(textdata)),' %'],...
['2010 ',num2str(100*len(10)/length(textdata)),' %'],...
['Alti Ani ',num2str( 100*(length(textdata)-len(3)-len(9)-...
len(10))/length(textdata) ),' %'],...
'Location','BestOutside')
title(['BUCHAREST ',figure_title{k}],'FontSize',15)
case 'Feb2011'
pie(100*[len(6),len(10),len(3)+len(4),length(textdata)-...
len(10)-len(6)-len(3)-len(4)]/length(textdata),...
{'2006','2010','2003+2004','Alti Ani'})
legend(['2006 ',num2str(100*len(6)/length(textdata)),' %'],...
['2010 ',num2str(100*len(10)/length(textdata)),' %'],...
['2003+2004 ',num2str(100*(len(3)+len(4))/length(textdata)),' %'],...
['Alti Ani ',num2str( 100*(length(textdata)-len(10)-...
len(6)-len(3)-len(4))/length(textdata) ),' %'],...
'Location','BestOutside')
title(['BUCHAREST ',figure_title{k}],'FontSize',15)
case 'March2011'
pie(100*[len(3),len(10),len(5)+len(6),length(textdata)-...
len(10)-len(3)-len(5)-len(6)]/length(textdata),...
{'2003','2010','05+06','Alti Ani'})
legend(['2003 ',num2str(100*len(3)/length(textdata)),' %'],...
['2010 ',num2str(100*len(10)/length(textdata)),' %'],...
['2005+2006 ',num2str(100*(len(5)+len(6))/length(textdata)),' %'],...
['Alti Ani ',num2str( 100*(length(textdata)-len(10)-...
len(5)-len(6))/length(textdata) ),' %'],...
'Location','BestOutside')
title(['BUCHAREST ',figure_title{k}],'FontSize',15)
case 'April2011'
pie(100*[length(textdata)-len(10),len(10)]/length(textdata),...
{'Alti Ani','2010'})
legend(['Alti Ani ',num2str( 100*(length(textdata)-len(10))/length(textdata) ),' %'],...
['2010 ',num2str(100*len(10)/length(textdata)),' %'],...
'Location','BestOutside')
title(['BUCHAREST ',figure_title{k}],'FontSize',15)
case 'May2011'
pie(100*[length(textdata)-len(10),len(10)]/length(textdata),...
{'Alti Ani','2010 '})
legend(['Alti Ani ',num2str( 100*(length(textdata)-len(10))/length(textdata) ),' %'],...
['2010 ',num2str(100*len(10)/length(textdata)),' %'],...
'Location','BestOutside');
title(['BUCHAREST ',figure_title{k}],'FontSize',15)
case 'June2011'
pie(100*[length(textdata)-len(10)-len(3)-len(9),len(3),len(9),len(10)]/length(textdata),...
{'Alti Ani','03','09','2010'})
legend(['Alti Ani ',num2str( 100*(length(textdata)-len(10)-len(3)-...
len(9))/length(textdata) ),' %'],...
['2003 ',num2str(100*(len(3))/length(textdata)),' %'],...
['2009 ',num2str(100*(len(9))/length(textdata)),' %'],...
['2010 ',num2str(100*len(10)/length(textdata)),' %'],...
'Location','BestOutside');
title(['BUCHAREST ',figure_title{k}],'FontSize',15)
case 'July2011'
pie(100*[len(9),len(10),length(textdata)-len(10)-len(9)]/length(textdata),...
{'2009','2010','Alti Ani'})
legend(['2009 ',num2str(100*len(9)/length(textdata)),' %'],...
['2010 ',num2str(100*len(10)/length(textdata)),' %'],...
['Alti Ani ',num2str( 100*(length(textdata)-len(10)-len(9))/length(textdata) ),' %'],...
'Location','BestOutside')
title(['BUCHAREST ',figure_title{k}],'FontSize',15)
case 'Sep2011'
pie(100*[len(9),len(10),length(textdata)-len(10)-len(9)]/length(textdata),...
{'2009','2010','Alti Ani'})
legend(['2009 ',num2str(100*len(9)/length(textdata)),' %'],...
['2010 ',num2str(100*len(10)/length(textdata)),' %'],...
['Alti Ani ',num2str( 100*(length(textdata)-len(10)-len(9))/length(textdata) ),' %'],...
'Location','BestOutside')
title(['BUCHAREST ',figure_title{k}],'FontSize',15)
case 'Oct2011'
pie(100*[len(10),length(textdata)-len(10)]/length(textdata),...
{'2010','Alti Ani'})
legend(['2010 ',num2str(100*len(10)/length(textdata)),' %'],...
['Alti Ani ',num2str( 100*(length(textdata)-len(10)-len(9))/length(textdata) ),' %'],...
'Location','BestOutside')
title(['BUCHAREST ',figure_title{k}],'FontSize',15)
end
end
Evolutia dosarelor pe ani
for k=1:length(Years)
dosare = 100*[lenn{1}(k)/sum(lenn{1}),lenn{2}(k)/sum(lenn{2}),...
lenn{3}(k)/sum(lenn{3}),lenn{4}(k)/sum(lenn{4}),...
lenn{5}(k)/sum(lenn{5}),lenn{6}(k)/sum(lenn{6}),...
lenn{7}(k)/sum(lenn{7}),lenn{8}(k)/sum(lenn{8}),...
lenn{9}(k)/sum(lenn{9}),lenn{10}(k)/sum(lenn{10})];
figure
plot([1,2,3,4,5,6,7,8,9,10],dosare,'LineWidth',3)
ylabel('% / months','FontSize',12)
xlabel('Months : From DECEMBER 2010 To OCTOBER 2011','FontSize',12)
title(['Evolutia Dosarelor din ', num2str(Years{k})],'FontSize',12)
end
Evolutia totala a numarului de dosare
close all
plot([1,2,3,4,5,6,7,8,9,10],[sum(lenn{1}),sum(lenn{2}),sum(lenn{3}),...
sum(lenn{4}),sum(lenn{5}),sum(lenn{6}),...
sum(lenn{7}),sum(lenn{8}),sum(lenn{9}),...
sum(lenn{10})],'LineWidth',4)
ylabel('Numar de Dosare','FontSize',12)
xlabel('Months : From DECEMBER 2010 To OCTOBER 2011','FontSize',12)
title('Evolutia totala a numarului de dosare','FontSize',12)
close all