A
Armand Paré
Guest
Bonjour, je tente d'intégrer la formule suivante dans un chiffrier Excel pour trouver les degrés-jour pour ma table de bi-énergie.
mdegre= degre-jour de la journée
z_Degre = degree-jour pour hier
mdegre est calculé de la manière suivante:
=SI((((Degre_Max_jour + Degre_Min_jour)/2)-15)<=3;3;(((Degre_Max_jour + Degre_Min_jour)/2)-15))
Voici la formule
If mDegre - z_Degre > 22
Do Case
Case mDegre - z_degre = 23
mDual = ((mdegre-z_degre)-22)*2
Case mDegre-z_degre = 24
mDual = ((mdegre-z_degre)-22)*2.1
Case mDegre-z_degre = 25
mDual = ((mdegre-z_degre)-22)*2.15
Case mdegre-z_degre = 26
mDual = ((mdegre-z_degre)-22)*2.2
Case mdegre-z_degre = 27
mDual = ((mdegre-z_degre)-22)*2.3
Case mdegre-z_degre = 28
mDual = ((mdegre-z_degre)-22)*2.4
Case mdegre-z_degre = 29
mDual = ((mdegre-z_degre)-22)*2.45
Case mdegre-z_degre = 30
mDual = ((mdegre-z_degre)-22)*2.5
Case mdegre-z_degre = 31
mDual = ((mdegre-z_degre)-22)*2.6
Case mdegre-z_degre = 32
mDual = ((mdegre-z_degre)-22)*2.7
Case mdegre-z_degre = 33
mDual = ((mdegre-z_degre)-22)*2.75
Other
mDual = (mdegre-z_degre)
Endcase
Endif
Cordialement
Armand
mdegre= degre-jour de la journée
z_Degre = degree-jour pour hier
mdegre est calculé de la manière suivante:
=SI((((Degre_Max_jour + Degre_Min_jour)/2)-15)<=3;3;(((Degre_Max_jour + Degre_Min_jour)/2)-15))
Voici la formule
If mDegre - z_Degre > 22
Do Case
Case mDegre - z_degre = 23
mDual = ((mdegre-z_degre)-22)*2
Case mDegre-z_degre = 24
mDual = ((mdegre-z_degre)-22)*2.1
Case mDegre-z_degre = 25
mDual = ((mdegre-z_degre)-22)*2.15
Case mdegre-z_degre = 26
mDual = ((mdegre-z_degre)-22)*2.2
Case mdegre-z_degre = 27
mDual = ((mdegre-z_degre)-22)*2.3
Case mdegre-z_degre = 28
mDual = ((mdegre-z_degre)-22)*2.4
Case mdegre-z_degre = 29
mDual = ((mdegre-z_degre)-22)*2.45
Case mdegre-z_degre = 30
mDual = ((mdegre-z_degre)-22)*2.5
Case mdegre-z_degre = 31
mDual = ((mdegre-z_degre)-22)*2.6
Case mdegre-z_degre = 32
mDual = ((mdegre-z_degre)-22)*2.7
Case mdegre-z_degre = 33
mDual = ((mdegre-z_degre)-22)*2.75
Other
mDual = (mdegre-z_degre)
Endcase
Endif
Cordialement
Armand