Assignment Start/Finish different than Task Start/Finish

G

G Lykos

Greetings! Discovered that a schedule I'm maintaining somehow has some
resource assignment start and finish dates that are drastically different
than task start and finish dates. Am going through doing a manual
comparison and setting the assignment dates equal to task dates.

Question 1: Any idea how this situation might have occurred? (No special
resource calendars in use)

Question 2: I would like to be able to filter, or create a VBA comparison
loop, to identify all assignments and/or tasks where the assignment start
and finish dates are different than the task dates. However, I don't see a
way to set up either. Any ideas?

Thanks,
George
 
J

Jan De Messemaeker

Hi,

Resource Leveling can cause this behaviour, as can nonworking time for a
resource.

For each anytask in activeproject.taks
if not anytask is nothing then
For each whodunit in anytask.asignments
if not anytask.start=whodunit.start then
msgbox atask.name,whodunit.resourcename
endif
next
enif
next

HTH
 
G

G Lykos

Thanks - I'll try it! Is there also a way to use menu-accessible standard
operations to do a similar diagnostic comparison?
 
J

Jan De Messemaeker

Hi,

What is "similar"?
Comparisons to baseline is available - what do you have in mind?
 
G

G Lykos

Julie, with guidance from others here I wrote a small VBA macro that reports
resources assigned to other than the entire task duration (current task, not
baseline). The question is whether there is a technique available using
standard tools (i.e. accessible through toolbars or otherwise) to accomplish
the same thing.

Thanks again,
George
 
G

G Lykos

Sorry, Jan - didn't realize that you had stepped in.

With guidance from others here I wrote a small VBA macro that reports
resources assigned to other than the entire task duration (current task, not
baseline). The question is whether there is a technique available using
standard tools (i.e. accessible through toolbars or otherwise, without VBA)
to accomplish the same thing.

Thanks,
George
 

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