Forum Discussion
Solved
Number of assigned resources on tasks
Someone know how to set up a new column to show me the number of assigned resources on tasks? In column Tekst 1 i have drawn numbers in red just for an example. And also i would like to have a colu...
- Polestar2021,
You're welcome and thanks for the feedback.
What exactly do you mean by, "place out resources"? And I'm confused about you desire to show a list of resources not assigned to a task yet. At the top of the Resource Usage view you can see a list of unassigned resources but, those resources may or may not be appropriate for assignment to any given task.
With respect to removing decimals in the days column, if you simply want a whole number of days then replace the t.Text1 line with this:
t.Text1 = Format(t.Duration / 60 / ActiveProject.HoursPerDay, "##") & " days"
John
Hi John!
Thank you for that Macro!! It did exactly what i wanted.
Im new to this resource planning so trying it out to see if MS project can replace Excel.
I have not yet found a easy way to place out resources. I do want to stand in the Ghant view and click on a task, get a list of resources that is not assigned to a task yet. So nice if you have a suggestion there. Also, is there an easy way to remove all the decimals in the days column you gave me Macro for?
Thank you for that Macro!! It did exactly what i wanted.
Im new to this resource planning so trying it out to see if MS project can replace Excel.
I have not yet found a easy way to place out resources. I do want to stand in the Ghant view and click on a task, get a list of resources that is not assigned to a task yet. So nice if you have a suggestion there. Also, is there an easy way to remove all the decimals in the days column you gave me Macro for?
Polestar2021,
You're welcome and thanks for the feedback.
What exactly do you mean by, "place out resources"? And I'm confused about you desire to show a list of resources not assigned to a task yet. At the top of the Resource Usage view you can see a list of unassigned resources but, those resources may or may not be appropriate for assignment to any given task.
With respect to removing decimals in the days column, if you simply want a whole number of days then replace the t.Text1 line with this:
t.Text1 = Format(t.Duration / 60 / ActiveProject.HoursPerDay, "##") & " days"
John
You're welcome and thanks for the feedback.
What exactly do you mean by, "place out resources"? And I'm confused about you desire to show a list of resources not assigned to a task yet. At the top of the Resource Usage view you can see a list of unassigned resources but, those resources may or may not be appropriate for assignment to any given task.
With respect to removing decimals in the days column, if you simply want a whole number of days then replace the t.Text1 line with this:
t.Text1 = Format(t.Duration / 60 / ActiveProject.HoursPerDay, "##") & " days"
John
- This is applicable to project server, where resources are managed at organization level ( program or portfolio) . Where resources are allocated to different tasks and possibly to a different project , then project server will show you availability of all the resources and you can choose which one to assign, of course after approval and it reduces the availability of that resource automatically. In stand alone projects not all resource times dedicated to project related tasks hence best bet will be to update resources sheet and the individual availability then assign them to tasks, look for any over allocation and resolve that by resource levelling.
Apply the Resource Sheet view.
Add a number field (Number1 for example)
Customize the field and under Calculation for task and group summary rows: select Count all
Then apply a group by on the Group field.
- Polestar2021,
Using the Assign Resources sub-window as shown in the image you posted is the best way to assign resources while in the Gantt Chart view. Unfortunately, the list of resources is ordered by whether assigned or not. That is, assigned resources start at the beginning of the list and unassigned resources fall to the bottom of the list.
You could also click on the selection arrow in the Resource Names field. You will see all available resources listed with a check in the box next to each that is assigned. This presentation is not sorted so it is a bit easier to see which resources are not assigned. However, checking a resource's box will automatically assign that resource at 100%.
John Thanks again!
If you see the pic i posted here. Im standing in the Ganth view where i have my tasks.
I was hoping i could add recources form here, and i can, but these lists i have found dont show recources
that is free(not added to any tasks. I have 60 recources, so the list is painfully long.
I know i can go to another view and sort columns so the free recources will be in top. I was just hoping
i could stand in Ganth view, find tasks and from there easy get available recources so i can add.
I can see im terrible to explain
