calculated field

B

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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top