
Score_Ratio_LG :=
IF ( [Ratio_LG] < 1,
    0,
    IF ( [Ratio_LG] <= 1.5, 1, 2 )
)


______________________________________________

Score_Ratio_LR = 
IF ( [Ratio_LR] < 0.8,
    0,
    IF ( [Ratio_LR] <= 1.2, 1, 2 )
)


______________________________________________

Score_Ratio_AF :=
IF ( [Ratio_AF] < 20,
    0,
    IF ( [Ratio_AF] <= 35, 1, 2 )
)


______________________________________________

Score_Ratio_EF :=
IF ( [Ratio_EF] > 150,
    0,
    IF ( [Ratio_EF] >= 80, 1, 2 )
)


______________________________________________

Score_FRNG =
IF ( [FRNG] < 0,
    0,
    IF ( [FRNG] = 0, 1, 2 )
)



______________________________________________

Score_BFR :=
IF ( [BFR] > 0,
    0,
    IF ( [BFR] = 0, 1, 2 )
)


______________________________________________

Score_Tresorerie_Nette =
IF ( [Tresorerie_Nette] < 0,
    0,
    IF ( [Tresorerie_Nette] = 0, 1, 2 )
)



______________________________________________

Indice_Santé_Globale = 
DIVIDE(
    ([Indice_Liquidité] * 20) +
    ([Indice_Cycle_Exploitation] * 20) +
    ([Indice_AF] * 30) +
    ([Indice_Santé_Trésorerie] * 30),
    100
)


______________________________________________

Liquidité 20% / Cycle d'exploitation 20% / Autonomie financière 30% / Trésorerie 30%