| Nom | Formule | Msg Erreur | Expression littérale du contrôle | Noms des cellules portant le contrôle |
| Q23_CTRA1 | si (CELLULE(-1,0)+0>0) alors CELLULE()+0>0 | Si l'effectif est supérieur à 0, l'ETP doit être supérieur à 0 | Q23_H1, Q23_H4, Q23_H5, Q23_H6, Q23_H7, Q23_H8, Q23_H9, Q23_H10, Q23_H11, Q23_H12, Q23_H13, Q23_H14, Q23_H15, Q23_H16, Q23_H17, Q23_H18, Q23_H19, Q23_H20, Q23_H21, Q23_H22, Q23_H23, Q23_H24, Q23_H25, Q23_H26, Q23_H27, Q23_H28, Q23_H29, Q23_H30, Q23_H31, Q23_H32, Q23_H33, Q23_H34, Q23_H35, Q23_H36, Q23_H37, Q23_H38, Q23_H39, Q23_H40, Q23_H41, Q23_H42, Q23_H43, Q23_H44, Q23_H45, Q23_H46, Q23_H47, Q23_H48, Q23_H49, Q23_H50, Q23_H51, Q23_H52, Q23_H53, Q23_H54 | |
| Q23_CTRA2 | 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) | Q23_H54, Q23_H53, Q23_H52, Q23_H51, Q23_H50, Q23_H49, Q23_H48, Q23_H47, Q23_H46, Q23_H45, Q23_H44, Q23_H43, Q23_H42, Q23_H41, Q23_H40, Q23_H39, Q23_H38, Q23_H37, Q23_H36, Q23_H35, Q23_H34, Q23_H33, Q23_H32, Q23_H31, Q23_H30, Q23_H29, Q23_H28, Q23_H27, Q23_H26, Q23_H25, Q23_H24, Q23_H23, Q23_H22, Q23_H21, Q23_H20, Q23_H19, Q23_H18, Q23_H17, Q23_H16, Q23_H15, Q23_H14, Q23_H13, Q23_H12, Q23_H11, Q23_H10, Q23_H9, Q23_H8, Q23_H7, Q23_H6, Q23_H5, Q23_H4, Q23_H1 | |
| Q23_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 ? | Q23_H1, Q23_G51, Q23_G52, Q23_G47, Q23_G48, Q23_G49, Q23_G50, Q23_H4, Q23_H5, Q23_H6, Q23_H7, Q23_G31, Q23_G32, Q23_G33, Q23_G34, Q23_G35, Q23_G36, Q23_G37, Q23_G38, Q23_G39, Q23_G40, Q23_G41, Q23_G42, Q23_G43, Q23_G44, Q23_G45, Q23_G46, Q23_H8, Q23_H9, Q23_H10, Q23_H11, Q23_H12, Q23_H13, Q23_H14, Q23_H15, Q23_H16, Q23_H17, Q23_H18, Q23_H19, Q23_H20, Q23_H21, Q23_H22, Q23_H23, Q23_A6, Q23_A30, Q23_A35, Q23_A45, Q23_A51, Q23_A52, Q23_B6, Q23_B30, Q23_B35, Q23_B45, Q23_B51, Q23_B52, Q23_C6, Q23_C30, Q23_C35, Q23_C45, Q23_C51, Q23_C52, Q23_D6, Q23_D30, Q23_D35, Q23_D45, Q23_D51, Q23_D52, Q23_E6, Q23_E30, Q23_E35, Q23_E45, Q23_E51, Q23_E52, Q23_F6, Q23_F30, Q23_F35, Q23_F45, Q23_F51, Q23_F52, Q23_G1, Q23_G4, Q23_G5, Q23_G6, Q23_G7, Q23_G8, Q23_G9, Q23_G10, Q23_G11, Q23_G12, Q23_G13, Q23_G14, Q23_G15, Q23_G16, Q23_G17, Q23_G18, Q23_G19, Q23_G20, Q23_G21, Q23_G22, Q23_G23, Q23_G24, Q23_G25, Q23_G26, Q23_G27, Q23_G28, Q23_G29, Q23_G30, Q23_H24, Q23_H25, Q23_H26, Q23_H27, Q23_H28, Q23_H29, Q23_H30, Q23_H31, Q23_H32, Q23_H33, Q23_H34, Q23_H35, Q23_H36, Q23_H37, Q23_H38, Q23_H39, Q23_H40, Q23_H41, Q23_H42, Q23_H43, Q23_H44, Q23_H45, Q23_H46, Q23_H47, Q23_H48, Q23_H49, Q23_H50, Q23_H51, Q23_H52, Q23_H53, Q23_G53 | |
| Q23_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 ? | Q23_G53, Q23_H53, Q23_H52, Q23_H51, Q23_H50, Q23_H49, Q23_H48, Q23_H47, Q23_H46, Q23_H45, Q23_H44, Q23_H43, Q23_H42, Q23_H41, Q23_H40, Q23_H39, Q23_H38, Q23_H37, Q23_H36, Q23_H35, Q23_H34, Q23_H33, Q23_H32, Q23_H31, Q23_H30, Q23_H29, Q23_H28, Q23_H27, Q23_H26, Q23_H25, Q23_H24, Q23_G30, Q23_G29, Q23_G28, Q23_G27, Q23_G26, Q23_G25, Q23_G24, Q23_G23, Q23_G22, Q23_G21, Q23_G20, Q23_G19, Q23_G18, Q23_G17, Q23_G16, Q23_G15, Q23_G14, Q23_G13, Q23_G12, Q23_G11, Q23_G10, Q23_G9, Q23_G8, Q23_G7, Q23_G6, Q23_G5, Q23_G4, Q23_G1, Q23_F52, Q23_F51, Q23_F45, Q23_F35, Q23_F30, Q23_F6, Q23_E52, Q23_E51, Q23_E45, Q23_E35, Q23_E30, Q23_E6, Q23_D52, Q23_D51, Q23_D45, Q23_D35, Q23_D30, Q23_D6, Q23_C52, Q23_C51, Q23_C45, Q23_C35, Q23_C30, Q23_C6, Q23_B52, Q23_B51, Q23_B45, Q23_B35, Q23_B30, Q23_B6, Q23_A52, Q23_A51, Q23_A45, Q23_A35, Q23_A30, Q23_A6, Q23_H23, Q23_H22, Q23_H21, Q23_H20, Q23_H19, Q23_H18, Q23_H17, Q23_H16, Q23_H15, Q23_H14, Q23_H13, Q23_H12, Q23_H11, Q23_H10, Q23_H9, Q23_H8, Q23_G46, Q23_G45, Q23_G44, Q23_G43, Q23_G42, Q23_G41, Q23_G40, Q23_G39, Q23_G38, Q23_G37, Q23_G36, Q23_G35, Q23_G34, Q23_G33, Q23_G32, Q23_G31, Q23_H7, Q23_H6, Q23_H5, Q23_H4, Q23_G50, Q23_G49, Q23_G48, Q23_G47, Q23_G52, Q23_G51, Q23_H1 |