Pages

Search

bulk assignments Microsoft Project

bulk assignments Microsoft Project

bulk assignments

Posted: 07 Mar 2006 04:26 PM PST

Thanks Rod, let's say I have a spreadsheet with several resources on them
that are already in the enterpise resource pool. I'm trying to get all of
these resources assigned to the same project all at once. Is there a quick
way of doing this and still keep them in the enterprise pool rather than
making them local resources? In short I'm trying to assign several resources
to the same project, but not one at a time and not as local resources. Thanks
again

"Rod Gill" wrote:
 

Problem w/ duration cal. incorrectly when applying multiple resour

Posted: 07 Mar 2006 11:39 AM PST

This is a case where I would use the split screen to assign the resources.
Enter Task X, duration 15 days. Assign resource R1 at 100%. Total Work is
calculated at 120 man-hours. Now with the task selected split the screen.
In the bottom window you'll see R1 already assigned. With the task set to
effort driven and the task type as Fixed Units, use the pulldowns under the
existing resource to add R2, entering 75% in the units column, and R3 with
units set to 50%. Click the "OK" button. You'll see the work gets
distributed between all three resources in a 4:3:2 ratio with R1 getting
53.33 hours, R2 getting 40 hours, and R3 getting 26.67 hours while the
duration goes to 6.67 days.

Now the question remains, why don't you have R2 and R3 devote their full
attention to their work and assign them 100%? Have 'em all give it their
full efforts and just git 'er done ASAP.

--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"com" <microsoft.com> wrote in
message news:com... 

Bloat

Posted: 07 Mar 2006 11:36 AM PST

In article <googlegroups.com>,
"textron.com" <textron.com> wrote:
 

Bruce,
Wow I thought, what was it that I said in my last comment that was so
offensive.... and then I read my response again. OK, you're not
translating back and forth - that's good.

Well, I tell you what, unless the .csv file has a lot of complex data
(which I doubt), the code to implement my "fix" should be very simple.
That means it is no cost to you, despite your large employer who hasn't
been able to figure it out for you yet. I understand, its called
"corporate bloat". It's part of their mentality division. I know, I
worked for a large corporation too.

If you want to contact me, send me a note and we'll go from there.

John
jensenj6atatcomcastdotdotnet
remove obvious redundancies

Managing multiple, concurrent project

Posted: 07 Mar 2006 11:09 AM PST

Hi,

One more original situation (in case you prefer one file) could be to attach
to each task a task calendarshowing work for A 8-12, for B 13-15 and for C
15-17. Then you can assign all resources @100% and durations will be planned
correctly as soon as you give in work.

Hope this helps,
--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"KK" <microsoft.com> schreef in bericht
news:com... 
projects, 
these 
We're 
work 
down 
times 
would 
all. 
only 
tackle 
change 
the 
priority 
for 
% 
Any 
hesitant 
any 

Duration, work, and calendar changes

Posted: 07 Mar 2006 11:03 AM PST

Thanks both for your comments -- got me going in the right direction.
I mistakenly assumed that decreasing the work days for a specific resource
in a resource calendar (and not changing the base calendar) would somehow
manifest as a difference between effort and duration.


"bam" <com> wrote in message
news:phx.gbl... 

Problem with duration dates miscalculation

Posted: 07 Mar 2006 05:20 AM PST

Thanks for the reply . I checked the calendar for weekends, extended
hours etc, 5 days week, no weekend working, 8 hours days, 40 hours weeks but
nothing helped.

I could email project to you if you could spare the time to take a look? Let
me know your email (com is mine)

" D" wrote:
 

enumerate projects sharing resources

Posted: 07 Mar 2006 03:43 AM PST

Hi John,

Problem.
The way I handle this is to show the window I talked about, break ALL links
with the Sendkeys method and re-connect the right ones.
Hope this helps,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"John the PM" <microsoft.com> schreef in bericht
news:com... 
list 
so 
resource 

Holiday dates

Posted: 07 Mar 2006 01:07 AM PST

Hi Peter,

Welcome to this Microsoft Project newsgroup :)

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm.

Look for Housatonic in the Companion Products, who have an Outlook/MS
Project Tool which, I think, does this. There's a free trial on offer:
http://www.projectviewercentral.com/

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP

Peterl wrote: 

Automatic calculation w/ add duration to "planned start/finish" da

Posted: 06 Mar 2006 11:50 PM PST

Sounds like what you're describing is the baseline start and finish dates.
Before you begin to post actuals, save a baseline. Your original plan is
preserved there. Then when you enter an actual start date, the planned
duration is added to it to come up with a projected finish. When you record
the task as finished, project either transforms that projected finish into
an actual or, if the actual duration differs from the planned, it records
the new finish date as you've inout it. But the baseline you saved records
all of the original start, duration, and finish info for comparison
purposes.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"jrunner" <microsoft.com> wrote in message
news:com... 

MySQL or ODBC

Posted: 06 Mar 2006 11:19 AM PST

Seems to work except for when it wants to use the type "longchar" for
at least one of the fields. MySQL does not support this field type.

Is there a work around?

Task % of total work

Posted: 06 Mar 2006 06:06 AM PST

In article <googlegroups.com>,
"Eanna" <ie> wrote:
 

Eanna,
You're welcome. The "60" converts minutes to hours. Project stores all
time based data in minutes so unless the user is working in minutes,
formulas using time based data (e.g. Work) must be converted. I think
most users enter work in hours so I made that assumption. If your value
from step 3 is in weeks, then the factor should probably be "2400" (i.e.
60 x 40, assuming 40 hours per week).

John
Project MVP 

How to print a few tasks of a project

Posted: 05 Mar 2006 11:17 PM PST

Feel free to wonder, but there isn't.
Tables decide which columns show and filters determine which "rows" show.

"Sultan A. Ameen" <microsoft.com> wrote in message
news:com...