R26: A26=DECLARATION ASTREINTES | B26=Date début | C26=Date fin | D26=Type d'astreinte | F26=Repos compensateur (oui/non) | K26=Astreintes à payer (oui/non) | O26=Motif
R27: B27=44754 | C27=44760 | D27=Exploit.- Semaine complète (Filière Technique) | G27==IF($F27="oui",XLOOKUP($D27,ANNEE!$T$10:$T$51,ANNEE!$U$10:$U$51,0),0) | K27=oui | L27==IF($K27="oui",IF(XLOOKUP($D27,ANNEE!$T$10:$T$51,ANNEE!$S$10:$S$51,0)>0,1,0),0)
R28: G28==IF($F28="oui",XLOOKUP($D28,ANNEE!$T$10:$T$51,ANNEE!$U$10:$U$51,0),0) | L28==IF($K28="oui",IF(XLOOKUP($D28,ANNEE!$T$10:$T$51,ANNEE!$S$10:$S$51,0)>0,1,0),0)
R29: G29==IF($F29="oui",XLOOKUP($D29,ANNEE!$T$10:$T$51,ANNEE!$U$10:$U$51,0),0) | L29==IF($K29="oui",IF(XLOOKUP($D29,ANNEE!$T$10:$T$51,ANNEE!$S$10:$S$51,0)>0,1,0),0)
R30: G30==IF($F30="oui",XLOOKUP($D30,ANNEE!$T$10:$T$51,ANNEE!$U$10:$U$51,0),0) | L30==IF($K30="oui",IF(XLOOKUP($D30,ANNEE!$T$10:$T$51,ANNEE!$S$10:$S$51,0)>0,1,0),0)
R31: G31==IF($F31="oui",XLOOKUP($D31,ANNEE!$T$10:$T$51,ANNEE!$U$10:$U$51,0),0) | L31==IF($K31="oui",IF(XLOOKUP($D31,ANNEE!$T$10:$T$51,ANNEE!$S$10:$S$51,0)>0,1,0),0)
R32: F32==F$25*ANNEE!D$24+SUM(J27:J31) | G32==G$25*ANNEE!E$24 | H32==H$25*ANNEE!F$24 | I32==I$25*ANNEE!G$24 | J32==SUM(F32:I32)+$E$2-$E$25
R33: D33=A Reporter :  | E33==J32