displaying ressource shortcuts in gantt diagram

[eryakaas]

Hallo,

I use MS Project 2002, German Version - that's why I try to guess
correct menu names etc. I hope you will understand my question!
In the gantt diagram are shown the ressource names and the
percentages, if I use one ressource <100% - it's default. But I
changed it and want to show the ressource shortcuts [?? right name??
abbrevation?? in German Version: "Ressourcenkuerzel"] instead of full
ressource names. I can do this - but now there are no percentages if
using one ressource <100% :-(

It's possible to do this, and how?

Thanks a lot for your answers!

Ute (eryakaas)

[for German speakers: Ich möchte anstatt des Ressourcennamens das
Ressourcenkürzel neben den Balken eintragen. Das funktioniert auch,
aber die Prozentangaben beim einsatz <100% werden nicht angezeigt.
Kann ich das ändern?]

 

[John]

Hallo,

I use MS Project 2002, German Version - that's why I try to guess
correct menu names etc. I hope you will understand my question!
In the gantt diagram are shown the ressource names and the
percentages, if I use one ressource <100% - it's default. But I
changed it and want to show the ressource shortcuts [?? right name??
abbrevation?? in German Version: "Ressourcenkuerzel"] instead of full
ressource names. I can do this - but now there are no percentages if
using one ressource <100% :-(

It's possible to do this, and how?

Thanks a lot for your answers!

Ute (eryakaas)

[for German speakers: Ich möchte anstatt des Ressourcennamens das
Ressourcenkürzel neben den Balken eintragen. Das funktioniert auch,
aber die Prozentangaben beim einsatz <100% werden nicht angezeigt.
Kann ich das ändern?]

Ute,
I don't speak German but I think I understand your question. I assume
you are talking about the Resource Initials field when you refer to
resource shortcuts.

Certain fields in Project are specially formatted for various built-in
views. For example the Cost fields are formatted with the currency
symbol and appropriately placed decimal. For whatever reason, Microsoft
developers decided to include a resource's assignment level along with
the name in the Resource Names column. However MS did not include that
information in the Resource Initials column. I assume it was done that
way because the Resource Initials column is intended as a abbreviated
column for resource information and including the assignment level
information would only serve to lengthen the abbreviation.

There is a solution however. A spare field (e.g. Text1) and a little VBA
code can be used to show whatever resource information you want. The
following code will show the resource initial and assignment level in
the spare field, "Text1".
Sub Custom_Init()
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
i = 1
For Each a In t.Assignments
asslev = a.Units
assinit = Mid(a.ResourceName, 1, 1)
If i = 1 Then
If asslev <> 1 Then
t.Text1 = assinit & "[" & asslev * 100 & "%]"
Else
t.Text1 = assinit
End If
Else
If asslev <> 1 Then
t.Text1 = t.Text1 & "," & assinit & _
"[" & asslev * 100 & "%]"
Else
t.Text1 = t.Text1 & "," & assinit
End If
End If
i = i + 1
Next a
End If
Next t

Hope this helps.
John
Project MVP