1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
| Sub Com()
'Dèclaration des variables
Dim periode As Date, prenom As String, nom As String, numerofg As Integer, qualification As String, qualificationm_1 As String
Dim vpn As Integer, vedn As Integer, vein As Integer, vgn As Integer
Dim ce As Integer, cad As Integer, cai As Integer, cdg As Integer
periode = Range("K2")
prenom = Range("K3")
nom = Range("K4")
numerofg = Range("K5")
qualification = Range("K6")
qualificationm_1 = Range("K7")
vpn = Range("H10")
vedn = Range("H19")
vein = Range("H28")
vgn = Range("H30")
ce = Range("G11")
cad = Range("G20")
cai = Range("G29")
cdg = Range("G31")
'Cas Fun Girl/boy
If vpn >= 0 Then
'Qualification
qualification = "FUN GIRL/BOY"
'Commissions d'animation indirecte
Range("G29") = 0.02
'Commissions d'animation directe
Range("G20") = 0.05
'Commissions évolutives
If vpn >= 0 And vpn <= 900 Then
Range("G11") = 0.25
ElseIf vpn > 900 And vpn <= 2400 Then
Range("G11") = 0.27
ElseIf vpn > 2400 And vpn <= 4900 Then
Range("G11") = 0.28
ElseIf vpn > 4900 Then
Range("G11") = 0.31
End If
'Cas Fun Lady/lord
ElseIf vpn >= 300 And vpn < 400 And vgn >= 1500 And vgn < 2000 Then
'Qualification
qualification = "FUN LADY/LORD"
'Commissions d'animation indirecte
Range("G29") = 0.03
'Commissions d'animation directe
If vedn > 0 And vedn <= 2400 Then
Range("G20") = 0.07
ElseIf vedn > 900 And vedn <= 2400 Then
Range("G20") = 0.08
ElseIf vedn > 2400 And vedn <= 4900 Then
Range("G20") = 0.09
End If
'Commissions évolutives
If vpn >= 300 And vpn <= 900 Then
Range("G11") = 0.27
ElseIf vpn > 900 And vpn <= 2400 Then
Range("G11") = 0.28
ElseIf vpn > 2400 And vpn <= 4900 Then
Range("G11") = 0.31
ElseIf vpn > 4900 Then
Range("G11") = 0.34
End If
'Cas Fun Duchess/duke
ElseIf vpn >= 400 And vgn >= 2000 Then
'Qualification
qualification = "FUN DUCHESS/DUKE"
'Commissions d'animation indirecte
Range("G29") = 0.04
'Commissions d'animation directe
If vedn > 0 And vedn <= 2400 Then
Range("G20") = 0.09
ElseIf vedn > 900 And vedn <= 2400 Then
Range("G20") = 0.1
ElseIf vedn > 2400 And vedn <= 4900 Then
Range("G20") = 0.11
End If
'Commissions évolutives
If vpn >= 400 And vpn <= 900 Then
Range("G11") = 0.28
ElseIf vpn > 900 And vpn <= 2400 Then
Range("G11") = 0.3
ElseIf vpn > 2400 And vpn <= 4900 Then
Range("G11") = 0.34
ElseIf vpn > 4900 Then
Range("G11") = 0.4
End If
'Cas Fun Queen/king
Else
'Qualification
qualification = "FUN QUEEN/KING"
End If
End Sub |
Partager