Macro to delete resource assignment hours prior to status date

[VSAT Ryan]

Hello Everyone,

We are trying to develop a macro that will delete hours for all resource
assignments prior to the status date set by the user. Can anyone provide
some guidance or assistance in this?

Regards,
Ryan

 

[Jan De Messemaeker]

Hi,

Does this have to include started but incomplete tasks?
Would it ve a solution, for all work before the statuis date, to replace the
true resources by a dummy resource?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[VSAT Ryan]

Hi Jan,

This would be for all tasks - whether in progress, or completed. Those that
aren't started would be re-scheduled after the status date.

The work values for existing resources would be changed to zero hours prior
to the status date. There should not be a dummy resource involved.

Ryan

 

[Jan De Messemaeker]

Hi,

Now you puzzle me a bit:

"Thoise that aren't started would be moved"
How about, then, tasks started last week but still haveng undone work
planned for the remainder of last week plus yesterday? Would that work be
moved as well (logically it would)?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[VSAT Ryan]

Hi Jan,

"Those that started would be moved" - if I am statusing as of 28AUG09, then
there should be no tasks scheduled to start that haven't started. So, the
new scheduled start would have to be some day after 28AUG09.

"How about, then, tasks started last week but still haveng undone work
planned for the remainder of last week plus yesterday? Would that work be
moved as well (logically it would)?"

How about this as an example:
The task started 15AUG09, and is scheduled to finish on 15SEP09. We are
statusing as of 28AUG09. The hours between 15AUG and 28SEP are zeroed out,
and the hours from 29AUG - 15SEP will remain.

Regards,
Ryan

 

[Rod Gill]

You shouldn't zero out hours not done unless the Task is no longer going to
be done. Why not use Project's reschedule incomplete work feature? This
should be used anyway after each update. Tools, Tracking, Update Project

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi Jan,

"Those that started would be moved" - if I am statusing as of 28AUG09,
then
there should be no tasks scheduled to start that haven't started. So, the
new scheduled start would have to be some day after 28AUG09.

"How about, then, tasks started last week but still haveng undone work
planned for the remainder of last week plus yesterday? Would that work be
moved as well (logically it would)?"

How about this as an example:
The task started 15AUG09, and is scheduled to finish on 15SEP09. We are
statusing as of 28AUG09. The hours between 15AUG and 28SEP are zeroed
out,
and the hours from 29AUG - 15SEP will remain.

Regards,
Ryan



__________ Information from ESET Smart Security, version of virus
signature database 4468 (20090929) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4468 (20090929) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Jan De Messemaeker]

Hi,

I was afraid for that. That makes it much harder, since it is not logical in
my view, and Project's feature to Reschedule all incomplete work till after
the status date can not be used. I heave to try some, but it's now past 22
hrs here and the rest will be for tomorrow, sorry.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availabliy check:
http://users.online.be/prom-ade/Calendar.pdf

 

[VSAT Ryan]

Hi Rod,

Unfortunately, the Tools -> Tracking -> Update Project; Reschedule
uncompleted work to start after function won't work - it just pushes out the
finish date - we don't want this.

Ryan

 

[Rod Gill]

Realistically if work is not done this week, then unless you remove scope or
immediately increase available Resource, Task finish dates do move out,
which is exactly what Project is telling you! If your bosses insist on
glasses that go black whenever there is danger/bad news about, you will need
to re-schedule using the Usage Views, or in VBA using the timescaledata
methods. However to finish on time you will still need to either increase
Resource on the Task or remove scope (work).

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi Rod,

Unfortunately, the Tools -> Tracking -> Update Project; Reschedule
uncompleted work to start after function won't work - it just pushes out
the
finish date - we don't want this.

Ryan



__________ Information from ESET Smart Security, version of virus
signature database 4468 (20090929) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4468 (20090929) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[VSAT Ryan]

Rod,

I see what you are saying - it makes functional sense. I am not trying to
go against this - I just need an imperfect solution to integrate it with a
cost system.

So, when you do tools - tracking - update project, for existing tasks, the %
complete will be modified, and the remaining work, and work fields may be
changed. If you change the value in the remaining work field after setting
the status date, you will see in task or resource usage that only periods
AFTER the status date are modified. I basically want the remaining work
values, and the values before that to be zeroed out.

Ryan

 

[Rod Gill]

No. If you use the Reschedule incomplete work option and provide your status
date, all work that should have been done is moved forward. So if no work
was done last week, all work is zeroed out for last week, but the finish
date will push out. To maintain the same finish date as before you will now
have to assign more resource to get the original remaining work done in a
shorter time.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Rod,

I see what you are saying - it makes functional sense. I am not trying to
go against this - I just need an imperfect solution to integrate it with a
cost system.

So, when you do tools - tracking - update project, for existing tasks, the
%
complete will be modified, and the remaining work, and work fields may be
changed. If you change the value in the remaining work field after
setting
the status date, you will see in task or resource usage that only periods
AFTER the status date are modified. I basically want the remaining work
values, and the values before that to be zeroed out.

Ryan



__________ Information from ESET Smart Security, version of virus
signature database 4471 (20090930) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4471 (20090930) __________

The message was checked by ESET Smart Security.

http://www.eset.com