Macro to Automatically Assign Remaining Availability

[Scott K. Mitchell]

Anyone out there have a macro that will automatically assign the remaining
availability for a resource to a task for a given duration?

For example:

Name Start Finish Work Resource
Task 1 1/1/02 1/3/02 2d Bob[67%]
Task 2 1/4/02 1/6/02 1d Bob[33%]
Task 3 1/1/02 1/6/02 ?? Bob[???]

I want a macro that automatically takes Bob's remaining availability for the
period between 1/1/02 and 1/6/02, and puts that as the timephased work for
task 3. If you have one, please share!

Thanks in advance for any help,
Scott

 

[Gérard Ducouret]

Hello Scott,

Have a look at the http://www.pragma-soft.com site to the "Tache bouche
trou" procedure.
You can download ("Téléchargement" in french) it for a try, and tell me if
its works for you.

Gérard Ducouret
PragmaSoft ®

 

[Scott K. Mitchell]

Thanks Gérard. I tried downloading that once before but I couldn't get it
to work. Do you have any good tips or tricks on how to use it?

- Scott

Hello Scott,

Have a look at the http://www.pragma-soft.com site to the "Tache bouche
trou" procedure.
You can download ("Téléchargement" in french) it for a try, and tell me if
its works for you.

Gérard Ducouret
PragmaSoft ®

"Scott K. Mitchell" <[email protected]> a écrit dans le message de news:

[email protected]...
Anyone out there have a macro that will automatically assign the remaining
availability for a resource to a task for a given duration?

For example:

Name Start Finish Work Resource
Task 1 1/1/02 1/3/02 2d Bob[67%]
Task 2 1/4/02 1/6/02 1d Bob[33%]
Task 3 1/1/02 1/6/02 ?? Bob[???]

I want a macro that automatically takes Bob's remaining availability for the
period between 1/1/02 and 1/6/02, and puts that as the timephased work for
task 3. If you have one, please share!

Thanks in advance for any help,
Scott

 

[Gérard Ducouret]

Hello Scott,

The modu operandi is written in french, so I'll try to translate it :
Display the "Repartition Tache Bouche_Trou_3" tool bar which is hidden in
the Organizer :
Tool / Organizer / Toolbars ... copy it toward your Global.mpt file
Before runnig the macro, select a task with a resource (only one resource on
the task) and of course some amount of work to do.
Click on the large button of the new tool bar.

Tell me if it works,

Gérard

Thanks Gérard. I tried downloading that once before but I couldn't get it
to work. Do you have any good tips or tricks on how to use it?

- Scott

Hello Scott,

Have a look at the http://www.pragma-soft.com site to the "Tache bouche
trou" procedure.
You can download ("Téléchargement" in french) it for a try, and tell me if
its works for you.

Gérard Ducouret
PragmaSoft ®

"Scott K. Mitchell" <[email protected]> a écrit dans le message de news:

[email protected]...
Anyone out there have a macro that will automatically assign the remaining
availability for a resource to a task for a given duration?

For example:

Name Start Finish Work Resource
Task 1 1/1/02 1/3/02 2d Bob[67%]
Task 2 1/4/02 1/6/02 1d Bob[33%]
Task 3 1/1/02 1/6/02 ?? Bob[???]

I want a macro that automatically takes Bob's remaining availability

for
the

period between 1/1/02 and 1/6/02, and puts that as the timephased work for
task 3. If you have one, please share!

Thanks in advance for any help,
Scott