calculated field

[Ben]

I want a field to return yes or no if during the next two
weeks there are any overallocation. Basically, if the
sum of work for a resource for the next two weeks is
greater than 80 hours, yes, no. How can I build this in
Project 2003?

 

[JackD]

Since the calculated fields can't access the timescaled data necessary to
calculate this, you will have to use some VBA code.

The simple way is to look at the resource usage view for the next two weeks.

The VBA route involves looking at each resource, then getting all the
timescaled assignment data, compare the sum of it to the max you set (80hrs
for example) then setting one of the resource.flag fields to yes if it is
over the allowed max.

Sorry I don't have an example using timescaled data on my website, but
reading the project visual basic help will give you a start.

-Jack