% criar matriz com valores para exportar para o SPSS no seguinte formato:
% [Videos Pck Blo Blu Subj Score MOS STD]
% Valores lidos e replicados a partir de Ann (Planilha Excell
% Analysis-Exp3.xlxs

vd = size(videos,1);
subjt  = size(Ann,2);

ratios = [0.0 0.0 0.0;0.0 0.0 0.6;0.0 0.6 0.0;8.1 0.0 0.0;0.7 0.0 0.4; ...
    8.1 0.0 0.4;0.7 0.0 0.6;8.1 0.0 0.6;0.7 0.4 0.0;8.1 0.4 0.0; ...
    0.7 0.4 0.4;8.1 0.4 0.4;0.7 0.4 0.6;8.1 0.4 0.6;0.7 0.6 0.0; ...
    8.1 0.6 0.0;0.7 0.6 0.4;8.1 0.6 0.4;0.7 0.6 0.6;8.1 0.6 0.6];

r = 1;

fid = fopen('Excel_to_SPSS(1).txt','a');
for v = 1 : vd
    videos{v}(8:end-4)
    for s = 1 : subjt
       fprintf(fid, '%d [%f %f %f] %d %d [%f %f]\r\n', v,ratios(r,:),s,Ann(v,s),Mos_Std(v,:));
    end
    if mod(v,20) == 0
        r = 1;
    else
        r = r + 1;
    end
end
fclose all;
    
