1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172
| function write_evenement_reflux(repertoire,tableau_final,RR,evenements_Imp1_liquide,evenements_Imp1_melange,evenements_Imp1_gazeux,evenements_Imp2_liquide,evenements_Imp2_melange,evenements_Imp2_gazeux,evenements_Imp3_liquide,evenements_Imp3_melange,evenements_Imp3_gazeux,evenements_Imp4_liquide,evenements_Imp4_melange,evenements_Imp4_gazeux,evenements_Imp5_liquide,evenements_Imp5_melange,evenements_Imp5_gazeux,evenements_Imp6_liquide,evenements_Imp6_melange,evenements_Imp6_gazeux)
T0=strcat(repertoire, '_result'); %ils s'agit de 'repertoire_result'
%Données utiles pour le tableau final
T1='debut';
T2='fin';
T2bis='duree';
T3='pH';
T4='acidité';
T5='type';
T6='IMP1';
T7='IMP2';
T8='IMP3';
T9='IMP4';
T10='IMP5';
T11='IMP6';
T12='seuils';
T13='evenements_Imp1_liquide';
T14='evenements_Imp1_melange';
T15='evenements_Imp1_gazeux';
T16='evenements_Imp2_liquide';
T17='evenements_Imp2_melange';
T18='evenements_Imp2_gazeux';
T19='evenements_Imp3_liquide';
T20='evenements_Imp3_melange';
T21='evenements_Imp3_gazeux';
T22='evenements_Imp4_liquide';
T23='evenements_Imp4_melange';
T24='evenements_Imp4_gazeux';
T25='evenements_Imp5_liquide';
T26='evenements_Imp5_melange';
T27='evenements_Imp5_gazeux';
T28='evenements_Imp6_liquide';
T29='evenements_Imp6_melange';
T30='evenements_Imp6_gazeux';
%ecriture du tableau final dans la feuille result
xlswrite(T0,{T1},'result','A1');
xlswrite(T0,{T2},'result','B1');
xlswrite(T0,{T3},'result','C1');
xlswrite(T0,{T4},'result','D1');
xlswrite(T0,{T5},'result','E1');
xlswrite(T0,{T6},'result','F1');
xlswrite(T0,{T7},'result','G1');
xlswrite(T0,{T8},'result','H1');
xlswrite(T0,{T9},'result','I1');
xlswrite(T0,{T10},'result','J1');
xlswrite(T0,{T11},'result','K1');
xlswrite(T0,tableau_final,'result','A2');
%ecriture des seuils dans la feuille seuils
xlswrite(T0,{T12},'seuils','A1');
xlswrite(T0,RR(1,:),'seuils','A2');
xlswrite(T0,RR(2,:),'seuils','A3');
xlswrite(T0,RR(3,:),'seuils','A4');
xlswrite(T0,RR(4,:),'seuils','A5');
xlswrite(T0,RR(5,:),'seuils','A6');
xlswrite(T0,RR(6,:),'seuils','A7');
%ecriture des différents événements par piste et domaines
%piste 1
xlswrite(T0,{T13},'11','A1');
xlswrite(T0,{T1},'11','A2');
xlswrite(T0,{T2},'11','B2');
xlswrite(T0,{T2bis},'11','C2');
xlswrite(T0,evenements_Imp1_liquide,'11','A3');
xlswrite(T0,{T14},'12','A1');
xlswrite(T0,{T1},'12','A2');
xlswrite(T0,{T2},'12','B2');
xlswrite(T0,{T2bis},'12','C2');
xlswrite(T0,evenements_Imp1_melange,'12','A3');
xlswrite(T0,{T15},'13','A1');
xlswrite(T0,{T1},'13','A2');
xlswrite(T0,{T2},'13','B2');
xlswrite(T0,{T2bis},'13','C2');
xlswrite(T0,evenements_Imp1_gazeux,'13','A3');
%piste 2
xlswrite(T0,{T16},'21','A1');
xlswrite(T0,{T1},'21','A2');
xlswrite(T0,{T2},'21','B2');
xlswrite(T0,{T2bis},'21','C2');
xlswrite(T0,evenements_Imp2_liquide,'21','A3');
xlswrite(T0,{T17},'22','A1');
xlswrite(T0,{T1},'22','A2');
xlswrite(T0,{T2},'22','B2');
xlswrite(T0,{T2bis},'22','C2');
xlswrite(T0,evenements_Imp2_melange,'22','A3');
xlswrite(T0,{T18},'23','A1');
xlswrite(T0,{T1},'23','A2');
xlswrite(T0,{T2},'23','B2');
xlswrite(T0,{T2bis},'23','C2');
xlswrite(T0,evenements_Imp2_gazeux,'23','A3');
%piste 3
xlswrite(T0,{T19},'31','A1');
xlswrite(T0,{T1},'31','A2');
xlswrite(T0,{T2},'31','B2');
xlswrite(T0,{T2bis},'31','C2');
xlswrite(T0,evenements_Imp3_liquide,'31','A3');
xlswrite(T0,{T20},'32','A1');
xlswrite(T0,{T1},'32','A2');
xlswrite(T0,{T2},'32','B2');
xlswrite(T0,{T2bis},'32','C2');
xlswrite(T0,evenements_Imp3_melange,'32','A3');
xlswrite(T0,{T21},'33','A1');
xlswrite(T0,{T1},'33','A2');
xlswrite(T0,{T2},'33','B2');
xlswrite(T0,{T2bis},'33','C2');
xlswrite(T0,evenements_Imp3_gazeux,'33','A3');
%piste 4
xlswrite(T0,{T22},'41','A1');
xlswrite(T0,{T1},'41','A2');
xlswrite(T0,{T2},'41','B2');
xlswrite(T0,{T2bis},'41','C2');
xlswrite(T0,evenements_Imp4_liquide,'41','A3');
xlswrite(T0,{T23},'42','A1');
xlswrite(T0,{T1},'42','A2');
xlswrite(T0,{T2},'42','B2');
xlswrite(T0,{T2bis},'42','C2');
xlswrite(T0,evenements_Imp4_melange,'42','A3');
xlswrite(T0,{T24},'43','A1');
xlswrite(T0,{T1},'43','A2');
xlswrite(T0,{T2},'43','B2');
xlswrite(T0,{T2bis},'43','C2');
xlswrite(T0,evenements_Imp4_gazeux,'43','A3');
%piste 5
xlswrite(T0,{T25},'51','A1');
xlswrite(T0,{T1},'51','A2');
xlswrite(T0,{T2},'51','B2');
xlswrite(T0,{T2bis},'51','C2');
xlswrite(T0,evenements_Imp5_liquide,'51','A3');
xlswrite(T0,{T26},'52','A1');
xlswrite(T0,{T1},'52','A2');
xlswrite(T0,{T2},'52','B2');
xlswrite(T0,{T2bis},'52','C2');
xlswrite(T0,evenements_Imp5_melange,'52','A3');
xlswrite(T0,{T27},'53','A1');
xlswrite(T0,{T1},'53','A2');
xlswrite(T0,{T2},'53','B2');
xlswrite(T0,{T2bis},'53','C2');
xlswrite(T0,evenements_Imp5_gazeux,'53','A3');
%piste 6
xlswrite(T0,{T28},'61','A1');
xlswrite(T0,{T1},'61','A2');
xlswrite(T0,{T2},'61','B2');
xlswrite(T0,{T2bis},'61','C2');
xlswrite(T0,evenements_Imp6_liquide,'61','A3');
xlswrite(T0,{T29},'62','A1');
xlswrite(T0,{T1},'62','A2');
xlswrite(T0,{T2},'62','B2');
xlswrite(T0,{T2bis},'62','C2');
xlswrite(T0,evenements_Imp6_melange,'62','A3');
xlswrite(T0,{T30},'63','A1');
xlswrite(T0,{T1},'63','A2');
xlswrite(T0,{T2},'63','B2');
xlswrite(T0,{T2bis},'63','C2');
xlswrite(T0,evenements_Imp3_gazeux,'63','A3'); |
Partager