From: CarliC on
I am brand new to having to load a schedule with resources.

I work in construction and have built a very large schedule in projects, the
client has now asked that I "resource load" this.

I have over 100 tasks to complete and I need to find out how I can load each
task by quantity if possible.

I.e.: Task 10 - Topsoil Stripping... I will need 1 foreman, 10 operators
and 6 laboures working 3 days to complete this task plus all relevant
equipment.

Can anyone tell me the best way to enter this without having to enter
"operator" 10 times over for each task so that projects accounts for it?

Please help, stressed and under a tight deadline.

Thanks,

Carli
From: Andrew Lavinsky on
Here's how I'd do it. First, navigate to the Resource Sheet and add the
resource roles that you need (operator, etc.)...then:

1) Set the Task Type to Fixed Duration for all tasks
2) Turn off Effort Driven on all Tasks
3) Go to Tools > Options > Schedule and Show Assignment Units as a Decimal
(this means you can enter 10 operators and not 1000% operators)
4) On the Gantt Chart, click on the Assign Resources Button (or Alt-F10)
to show the Assign Resources box
5) Click on each task in turn, assign operator (or whatever) at a units of
10. This will assign 10 operators to the task. Note that you don't have
to click the dialog box closed, but can select new tasks while the box is
open.

Note that I am assuming you're tracking schedule but not man-hours - and
you're just resource loading to get a feel for which team is working on what...

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

> I am brand new to having to load a schedule with resources.
>
> I work in construction and have built a very large schedule in
> projects, the client has now asked that I "resource load" this.
>
> I have over 100 tasks to complete and I need to find out how I can
> load each task by quantity if possible.
>
> I.e.: Task 10 - Topsoil Stripping... I will need 1 foreman, 10
> operators and 6 laboures working 3 days to complete this task plus all
> relevant equipment.
>
> Can anyone tell me the best way to enter this without having to enter
> "operator" 10 times over for each task so that projects accounts for
> it?
>
> Please help, stressed and under a tight deadline.
>
> Thanks,
>
> Carli
>


From: Trevor Rabey on
Trying to cut corners will ultimately take longer and be more effort and
produce a worse result than if you just bite the bullet and do it properly.
Having a single resource with max units = 1000%, instead of 10 resources at
max units = 100% is just avoiding the typing at the expense of an accurate
model.
What you don't model you can't manage.
Model what you've got.
If you have 10 Operators, make 10 resources.
It is easy, especially if you have a command of copy, paste and fill down
(CTRL-C, CTRL-V, CTRL-D).
--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au

"CarliC" <CarliC(a)discussions.microsoft.com> wrote in message
news:97394794-C093-4A4D-8C89-380D55707F82(a)microsoft.com...
>I am brand new to having to load a schedule with resources.
>
> I work in construction and have built a very large schedule in projects,
> the
> client has now asked that I "resource load" this.
>
> I have over 100 tasks to complete and I need to find out how I can load
> each
> task by quantity if possible.
>
> I.e.: Task 10 - Topsoil Stripping... I will need 1 foreman, 10 operators
> and 6 laboures working 3 days to complete this task plus all relevant
> equipment.
>
> Can anyone tell me the best way to enter this without having to enter
> "operator" 10 times over for each task so that projects accounts for it?
>
> Please help, stressed and under a tight deadline.
>
> Thanks,
>
> Carli


From: Prasad on
On Mar 10, 1:24 pm, CarliC <Car...(a)discussions.microsoft.com> wrote:
> I am brand new to having to load a schedule with resources.
>
> I work in construction and have built a very large schedule in projects, the
> client has now asked that I "resource load" this.
>
> I have over 100 tasks to complete and I need to find out how I can load each
> task by quantity if possible.
>
> I.e.:  Task 10 - Topsoil Stripping... I will need 1 foreman, 10 operators
> and 6 laboures working 3 days to complete this task plus all relevant
> equipment.
>
> Can anyone tell me the best way to enter this without having to enter
> "operator" 10 times over for each task so that projects accounts for it?
>
> Please help, stressed and under a tight deadline.
>
> Thanks,
>
> Carli


Hi Carli,

You said you were under stress to complete resource-leveled project
scheduling. You got some good advice from experts here. Could you
resolve the resource loading issue easily and satisfactorily when
tasks require a combination of various resources? How easily can you
repeat the process of resource-leveled scheduling when actual progress
significantly deviates from the schedule? I am just curious.

Prasad