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
| Function ApIncremet(V As String, Incr As Double, Optional NbJ As Double = 1) As String
Dim t As String
Dim I As Long
dim
ApIncremet = ""
t = "0"
For I = 1 To Len(V)
If IsNumeric(Mid(V, I, 1)) Then
t = t & Mid(V, I, 1)
Else
ApIncremet = ApIncremet & Mid(V, I, 1)
End If
Next
ApIncremet = ApIncremet & CStr((CLng(t) + Incr) * NbJ)
End Function
Sub test()
For Lig = 6 To DerLig
ValCel = Trim(Cells(Lig, 4).Value)
Select Case ValCel
Case Trim(TabSD(1))
If Trim(Cells(Lig, 3).Value) = "Dev" Then APDev = ApIncremet(APDev, 1)
If Trim(Cells(Lig, 3).Value) = "Conc" Then APConc = ApIncremet(APConc, 1)
APJDev = ApIncremet(APDev, 0, NbJouvrés): APJConc = ApIncremet(APConc, 0, NbJouvrés)
'a toi de treminer!
Case Trim(TabSD(2))
If Trim(Cells(Lig, 3).Value) = "Dev" Then EADev = EADev + 1
If Trim(Cells(Lig, 3).Value) = "Conc" Then EAConc = EAConc + 1
EAJDev = EADev * (NbJouvrés * 1): EAJConc = EAConc * (NbJouvrés * 1)
Case Trim(TabSD(3))
If Trim(Cells(Lig, 3).Value) = "Dev" Then ELDev = ELDev + 1
If Trim(Cells(Lig, 3).Value) = "Conc" Then ELConc = ELConc + 1
ELJDev = ELDev * (NbJouvrés * 1): ELJConc = ELConc * (NbJouvrés * 1)
Case Trim(TabSD(4))
If Trim(Cells(Lig, 3).Value) = "Dev" Then FSDev = FSDev + 1
If Trim(Cells(Lig, 3).Value) = "Conc" Then FSConc = FSConc + 1
FSJDev = FSDev * (NbJouvrés * 1): FSJConc = FSConc * (NbJouvrés * 1)
Case Trim(TabSD(5))
If Trim(Cells(Lig, 3).Value) = "Dev" Then GRTHDev = GRTHDev + 1
If Trim(Cells(Lig, 3).Value) = "Conc" Then GRTHConc = GRTHConc + 1
GRTHJDev = GRTHDev * (NbJouvrés * 1): GRTHJConc = GRTHConc * (NbJouvrés * 1)
Case Trim(TabSD(6))
If Trim(Cells(Lig, 3).Value) = "Dev" Then IAEDev = IAEDev + 1
If Trim(Cells(Lig, 3).Value) = "Conc" Then IAEConc = IAEConc + 1
IAEJDev = IAEDev * (NbJouvrés * 1): IAEConc = IAEConc * (NbJouvrés * 1)
Case Trim(TabSD(7))
If Trim(Cells(Lig, 3).Value) = "Conc" Then MConc = MConc + 1
MJConc = MConc * (NbJouvrés * 0.8)
CompDec = 0.5: CompEnt = 1
If MJConc < 0.5 Then MJConc = MJConc + CompDec Else MJConc = Int(MJConc + CompEnt)
Case Trim(TabSD(8))
If Trim(Cells(Lig, 3).Value) = "Dev" Then ODDev = ODDev + 1
If Trim(Cells(Lig, 3).Value) = "Conc" Then ODConc = ODConc + 1
ODJDev = ODDev * (NbJouvrés * 1): ODJConc = ODConc * (NbJouvrés * 1)
Case Else
If Trim(Cells(Lig, 3).Value) = "Dev" Then AutresDev = AutresDev + 1
If Trim(Cells(Lig, 3).Value) = "Conc" Then AutresConc = AutresConc + 1
AutresJDev = AutresDev * (NbJouvrés * 1): AutresJConc = AutresConc * (NbJouvrés * 1)
End Select
Next Lig
End Sub |
Partager