Sub RecapParPhase_v3()
Dim DicTit As Dictionary, L As Long, C As Long, TRés(1 To 500, 1 To 12), _
Dpt As SsGr, Serv As SsGr, Site As SsGr, Eqp As SsGr, Phase As SsGr, EqpX As SsGr, Détail
Dim ColDep As Long
'Recherche les entetes des colonnes pour identifier le numero de la colonne.
Dim nC_PHASE&, nC_LibEQP&, nc_ETAT&, nC_BUD&, nC_NOT&, nC_DPT&, nC_SERV&, nC_SITE&, nC_EQP&, nC_EQPx&
Dim LOt As ListObject
Set LOt = FDonn.ListObjects(1)
nC_PHASE = NColTab(LOt, "PHASE")
nC_LibEQP = NColTab(LOt, "Lib EQP")
nc_ETAT = NColTab(LOt, "ETAT")
nC_BUD = NColTab(LOt, "BUD")
nC_NOT = NColTab(LOt, "NOT")
nC_DPT = NColTab(LOt, "DPT")
'nC_SERV = NColTab(LOt, "SERV")
nC_SITE = NColTab(LOt, "SITE")
nC_EQP = NColTab(LOt, "EQP_Principal")
nC_EQPx = NColTab(LOt, "EQP_EXT")
Set DicTit = GigIdx.DicInvent(LOt, nC_PHASE, 9)
ColDep = 10
L = 1
For C = 1 To 7: TRés(L, C) = Choose(C, "DPT", "EQP_Principal", "EQP_Avec_Ext", "Nbr EQP", "Nbr ??", "Nbr EQP ok", "BUD"): Next C
VerserTitres TRés, DicTit
'Stop
'For Each Dpt In GigIdx.Gigogne(Null, "DPT", "SERV", "SITE", "EQP")
For Each Dpt In GigIdx.Gigogne(Null, nC_DPT, nC_EQP)
L = L + 1
TRés(L, 1) = Dpt.ID
TRés(L, 2) = Dpt.Count 'nbr d'Eqp Principal
For Each Eqp In Dpt.Co
TRés(L, 3) = TRés(L, 3) + Eqp.Count 'nbr d'Eqp Principal avec ext
TRés(L, 4) = TRés(L, 4) + Eqp.Co(1)(nC_BUD)
TRés(L, 5) = TRés(L, 5) + Eqp.somme(nC_BUD)
For Each Détail In Eqp.Co
If Right$(Détail(nC_EQPx), 1) = "0" Then
TRés(L, DicTit(Détail(nC_PHASE))) = TRés(L, DicTit(Détail(nC_PHASE))) + 1
End If
Next Détail, Eqp, Dpt
FDonn.[A32].Resize(500, 12).Value = TRés
End Sub