| Nom | Formule | Msg Erreur | Expression littérale du contrôle | Noms des cellules portant le contrôle |
| Q20_CTRA1 | si CV_NUMERIQUE(ID1_A12)<40 alors CELLULE()=CELLULE(-13,0)+CELLULE(-12,0) | La somme des ETP par statut doit être égale à la somme des ETP par sexe (I1 + J1 = V1) | Q20_V1 | |
| Q20_CTRA2 | si (CELLULE(-1,0))+0>0 alors CELLULE()+0>0 | Si l'effectif est supérieur à 0, l'ETP doit être supérieur à 0 | Q20_T1, Q20_T2, Q20_T3, Q20_T4, Q20_T5, Q20_T6, Q20_T7, Q20_T8, Q20_T9, Q20_T10, Q20_T11, Q20_T12, Q20_T13, Q20_T14, Q20_T15, Q20_T16, Q20_T17, Q20_T18, Q20_T19, Q20_T20, Q20_T21, Q20_T22, Q20_T23, Q20_T24, Q20_T25, Q20_T26, Q20_T27, Q20_T28, Q20_T29, Q20_T30, Q20_T31, Q20_T32, Q20_T33, Q20_T34, Q20_T35, Q20_T37, Q20_T39, Q20_T40, Q20_T41, Q20_T42, Q20_T43, Q20_T44, Q20_T45, Q20_T46, Q20_T49, Q20_T50 | |
| Q20_CTRA3 | CELLULE()+0<=(1.2*(CELLULE(-1,0)+0)) | L'ETP doit être généralement inférieur ou égal à l'effectif correspondant (sauf en cas de partage d'activités) | Q20_T50, Q20_T49, Q20_T46, Q20_T45, Q20_T44, Q20_T43, Q20_T42, Q20_T41, Q20_T40, Q20_T39, Q20_T37, Q20_T35, Q20_T34, Q20_T33, Q20_T32, Q20_T31, Q20_T30, Q20_T29, Q20_T28, Q20_T27, Q20_T26, Q20_T25, Q20_T24, Q20_T23, Q20_T22, Q20_T21, Q20_T20, Q20_T19, Q20_T18, Q20_T17, Q20_T16, Q20_T15, Q20_T14, Q20_T13, Q20_T12, Q20_T11, Q20_T10, Q20_T9, Q20_T8, Q20_T7, Q20_T6, Q20_T5, Q20_T4, Q20_T3, Q20_T2, Q20_T1 | |
| Q20_CTRH1 | si (PROPRIETE_UNITE("Historique") = vrai) alors (si (ABS((CELLULE()+0) - (VALEUR_HISTORIQUE()+0)) > 5) alors VARIATION_HISTORIQUE() <= 20) | L'évolution par rapport à l'année dernière est supérieure à 20%, pouvez-vous apporter un commentaire ? | Q20_T1, Q20_S45, Q20_S46, Q20_S41, Q20_S42, Q20_S43, Q20_S44, Q20_T2, Q20_T3, Q20_T4, Q20_T5, Q20_S23, Q20_S24, Q20_S25, Q20_S26, Q20_S27, Q20_S28, Q20_S29, Q20_S30, Q20_S31, Q20_S32, Q20_S33, Q20_S34, Q20_S35, Q20_S37, Q20_S39, Q20_S40, Q20_I1, Q20_J1, Q20_S1, Q20_S2, Q20_S3, Q20_S4, Q20_S5, Q20_S6, Q20_A1, Q20_B1, Q20_C1, Q20_E1, Q20_F1, Q20_G1, Q20_H1, Q20_S7, Q20_S8, Q20_S9, Q20_S10, Q20_S11, Q20_S12, Q20_S13, Q20_S14, Q20_S15, Q20_S16, Q20_S17, Q20_S18, Q20_S19, Q20_S20, Q20_S21, Q20_S22, Q20_T6, Q20_T7, Q20_T8, Q20_T9, Q20_T10, Q20_T11, Q20_T12, Q20_T13, Q20_T14, Q20_T15, Q20_T16, Q20_T17, Q20_T18, Q20_T19, Q20_T20, Q20_T21, Q20_T22, Q20_T23, Q20_T24, Q20_T25, Q20_T26, Q20_T27, Q20_T28, Q20_T29, Q20_T30, Q20_T31, Q20_T32, Q20_T33, Q20_T34, Q20_T35, Q20_T37, Q20_T39, Q20_T40, Q20_T41, Q20_T42, Q20_T43, Q20_T44, Q20_T45, Q20_T46, Q20_T49, Q20_U1, Q20_S49, Q20_U2, Q20_U3, Q20_U4, Q20_U5, Q20_U6, Q20_U7, Q20_U8, Q20_U9, Q20_U10, Q20_U11, Q20_U12, Q20_U13, Q20_U14, Q20_U15, Q20_U16, Q20_U17, Q20_U18, Q20_U19, Q20_U20, Q20_U21, Q20_U22, Q20_U23, Q20_U24, Q20_U25, Q20_U26, Q20_U27, Q20_U28, Q20_U29, Q20_U30, Q20_U31, Q20_U32, Q20_U33, Q20_U34, Q20_U35, Q20_U37, Q20_U39, Q20_U40, Q20_U41, Q20_U42, Q20_U43, Q20_U44, Q20_U45, Q20_U46, Q20_U49 | |
| Q20_CTRH1 | si (PROPRIETE_UNITE("Historique") = vrai) alors (si (ABS((CELLULE()+0) - (VALEUR_HISTORIQUE()+0)) > 5) alors VARIATION_HISTORIQUE() <=20) | L'évolution par rapport à l'année dernière est supérieure à 20%, pouvez-vous apporter un commentaire ? | Q20_D1 | |
| Q20_CTRH2 | si PROPRIETE_UNITE("Historique")=vrai et VALEUR_HISTORIQUE()+0 >=5 alors CELLULE()<>vide et CELLULE()<>0 | La valeur était renseignée l'année dernière, pouvez-vous apporter un commentaire ? | Q20_D1, Q20_C1, Q20_B1, Q20_A1, Q20_H1, Q20_G1, Q20_F1, Q20_E1, Q20_S6, Q20_S5, Q20_S4, Q20_S3, Q20_S2, Q20_S1, Q20_J1, Q20_I1, Q20_S22, Q20_S21, Q20_S20, Q20_S19, Q20_S18, Q20_S17, Q20_S16, Q20_S15, Q20_S14, Q20_S13, Q20_S12, Q20_S11, Q20_S10, Q20_S9, Q20_S8, Q20_S7, Q20_S40, Q20_S39, Q20_S37, Q20_S35, Q20_S34, Q20_S33, Q20_S32, Q20_S31, Q20_S30, Q20_S29, Q20_S28, Q20_S27, Q20_S26, Q20_S25, Q20_S24, Q20_S23, Q20_T5, Q20_T4, Q20_T3, Q20_T2, Q20_S44, Q20_S43, Q20_S42, Q20_S41, Q20_S46, Q20_S45, Q20_T1, Q20_T39, Q20_T37, Q20_T35, Q20_T34, Q20_T33, Q20_T32, Q20_T31, Q20_T30, Q20_T29, Q20_T28, Q20_T27, Q20_T26, Q20_T25, Q20_T24, Q20_T23, Q20_T22, Q20_T21, Q20_T20, Q20_T19, Q20_T18, Q20_T17, Q20_T16, Q20_T15, Q20_T14, Q20_T13, Q20_T12, Q20_T11, Q20_T10, Q20_T9, Q20_T8, Q20_T7, Q20_T6, Q20_U49, Q20_U46, Q20_U45, Q20_U44, Q20_U43, Q20_U42, Q20_U41, Q20_U40, Q20_U39, Q20_U37, Q20_U35, Q20_U34, Q20_U33, Q20_U32, Q20_U31, Q20_U30, Q20_U29, Q20_U28, Q20_U27, Q20_U26, Q20_U25, Q20_U24, Q20_U23, Q20_U22, Q20_U21, Q20_U20, Q20_U19, Q20_U18, Q20_U17, Q20_U16, Q20_U15, Q20_U14, Q20_U13, Q20_U12, Q20_U11, Q20_U10, Q20_U9, Q20_U8, Q20_U7, Q20_U6, Q20_U5, Q20_U4, Q20_U3, Q20_U2, Q20_S49, Q20_U1, Q20_T49, Q20_T46, Q20_T45, Q20_T44, Q20_T43, Q20_T42, Q20_T41, Q20_T40 |