Pages

Search

Colour Coding! Microsoft Project

Colour Coding! Microsoft Project

Colour Coding!

Posted: 28 Oct 2005 01:55 AM PDT

Hi,

I tried the following and it worked:
Iif (condition1, Yes, No) OR Iif(condition2, Yes,No)
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"NEvans8993" <microsoft.com> schreef in bericht
news:com... 
to 
Be 
trying 
list, 
from 

Converting between mpx and mpd

Posted: 27 Oct 2005 11:56 AM PDT

If this is so others can view the schedule I would use Adobe Writer.


"Rod Gill" wrote:
 

Maximum number of hours allowed per day

Posted: 27 Oct 2005 10:45 AM PDT

ABC --

I suspect that you are referring to the Maximum number of hours field on the
Tracking settings page in PWA. If this is the case, I would recommend that
you set the value to 24 hours. Also, in the future please post your Project
Server questions in the microsoft.public.project.server newsgroup, as this
newsgroup is devoted to the Microsoft Project desktop application only.
Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We wrote the book on Project Server"


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

Resource Assignment and Levelling

Posted: 27 Oct 2005 10:18 AM PDT

Jan has helped me a great deal in the past and knows a lot about how MS
Projects works. I went through some of the same problems you are going
through now. One thing I need to bring up is you can prioritize your task
prior to leveling. If you use priority of 1,000 MS Projects will not level
that task. Priority numbers are from 1 to 999. You can insert a column -
"Priority"
You can also tell MS Projects to not level resource by going to Resource
Sheet and inserting a "Can Level" column.
Good Luck

"Marie-Pier" wrote:
 

How to Automatically Mark a Milestone Complete if All Predecessors are Complete

Posted: 27 Oct 2005 08:14 AM PDT

You're welcome, Joe.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Joe Baker" <com> schreef in bericht
news:com... 
background 
have 
because 
If 

Reports - Can you segment by individual resources?

Posted: 27 Oct 2005 08:11 AM PDT

Hi John,

Thanks so far for the suggestions. We're going down the right path I
believe. I do have 1 resource per task. However, as with any project, I
have a limited # of resources performing mulitple tasks. What I'd like to
attempt to do is when I issue project updates, I'd also like to distribute
some form of the To-do list to each resource. On your second suggestion, are
you recommending a cut/paste scenario into Excel or Word? On your third
suggestion, I'm not familiar with VBA. How do you access it?

Thanks, Howard

"John" wrote:
 

% Availability and Days per month in Tools/Options

Posted: 27 Oct 2005 06:58 AM PDT

Thanks!

"Jan De Messemaeker" wrote:
 

Duration driving Finish based on which calendar?

Posted: 27 Oct 2005 03:49 AM PDT

I think I have a way through. Our default task type is Fixed Work as we tend
to estimate effort for a task, asiign a couple of people, and let MSP tell us
when it will finish.

We have a non-standard 32 hrs working week, this is reflected in
Tools/Options/Calendar and the resource calendars.

We have a couple of tasks (customer acceptance tests) which we know will
take a fixed duration. The immediate reaction is to make the task Fixed
Duration. However this causes the problem above.

If I leave the task as fixed work then enter Work then Duration, the
Resource % assigned to the task varies to satisfy the work & duration just
entered. The Duration is then consistent with our working week (i.e. entering
10 working days results in 10 working days between the Start & Finish dates).

Can you filter unassigned projects?

Posted: 27 Oct 2005 02:11 AM PDT


WSH wrote: 

So there are no project leads/managers, just resources? Are the
resources assigned to tasks, or to the Project Summary task? Or both? I
need to know more about how you're deciding that projects are
"unassigned" and which ones are not, before I can suggest a solution.

Manufacturing Firm

Posted: 26 Oct 2005 05:36 PM PDT

It's hard for me to get the whole picture of what's needed there so here is a
stab at what I see:
1) I would either create a project named the WO number or create a project
with a summary task by WO number with sub task below. Use a text field and
rename it WO#. Put the WO# for all task associated with that WO. This will
allow you to run filters later.
2) Create task just how you described below and make logic ties:
a) mold is made/modified, whatever is needed for particular part 
And Also:
) Gypsum - approximately 20-60 minutes per mold to lay the part, and 60 

FYI - You can cut, paste and modify these task for future WO's.
3. Assign resources as needed. You can have more than one resource per task,
but it's better to have one task per resource.
4) Assign a resource calendar to each resource.
5) Set your resource max units under View>Resource Sheet.
6) You will have to put a Start No Earlier Than constrant date on the first
task of each WO until it starts or you can put logic ties to other WO's task.
7) If there is a mold that will be needed on two WO's you'll need to make a
logic tie between them.
8) Set a time to get updates on a regular basis. Twice a week is not to
often for me.
All of this completed you will be able to know lead times and ship dates by
WO.
Good Luck with your job!


"Andrew Cornwell" wrote:
 

Disabling Resource Pool additions

Posted: 26 Oct 2005 11:56 AM PDT

Hi Tina,
I have created a flag in the resource pool called "shared?". This I have
set to yes for all the resources in the pool. However if a resource is added
from a plan it will default to Shared?="No". Although this wont stop people
adding resources to the pool it does mean you can spot them easily.

Regards Simon

"Tina S" wrote:
 

Filter for multiple resources?

Posted: 26 Oct 2005 10:24 AM PDT



"Christa" wrote:
Hi Christa,

Glad to have helped and thanks for the feedback. Please post again if you
have more questions.

Julie 

Linked Workbooks

Posted: 26 Oct 2005 08:20 AM PDT

In article <com>,
"Steph" <microsoft.com> wrote:
 

Stephanie,
You're welcome.

John

Equating resources problem

Posted: 26 Oct 2005 07:19 AM PDT

Hi Milind,

If you use Project's resource leveling you can.
In the leveling dialog box check out "Leveling can adjust individual
assignments"
Or if it's just for this one task, insert the column "Level Assignments" and
put it to "No".
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Milind" <fm> schreef in bericht
news:phx.gbl... 

text separator in Project 2000

Posted: 26 Oct 2005 06:58 AM PDT

Hi Wayne,

You're welcome and thanks for the feedback.

I was afraid changing the list separator would have some pretty far reaching
consequences. Glad to know that you arrived at an answer -- not a perfect
one, but an answer never-the-less.

Julie

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

Sorting issue with customer report

Posted: 26 Oct 2005 06:07 AM PDT

Hi Catfish & Dave,

I don't believe the first option "You can go to Reports>Custom and make a
copy of the report you want and set the sort in this new report." will work.
The Sort option that you see in the Who Does What Report definition dialog
box is the sort option for the *type* of report. The "Who does What" report
is a resource report and as such a "Start" field sort is sorting by the
resource's earliest start on assignments, not the start date of the
individual assignments. That being said, printing the left side of the
Resource Usage view (with the modifications I noted) does display the
assignments in the correct order.

Hope this is of help
Julie

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

Task Dependences Between Summary Task

Posted: 26 Oct 2005 05:18 AM PDT

Jan De Messemaeker wrote: 
In all the years I've worked with Project, with all the MS people whom
I talked with about scheduling (including the head of the original
Project for Windows development team and quite a few others), I've
never met anyone yet who knew anything about scheduling. All of the
ones I've met still think you link tasks by clicking and dragging from
Task 1 to the last task and clicking on the link icon!

How do I set 10 days effort in a 30 day period?

Posted: 26 Oct 2005 04:42 AM PDT

Thanks for the information, I'll give it a try.

"Jan De Messemaeker" wrote:
 

How Microsoft Calculates the % assigned for a resource on a task

Posted: 25 Oct 2005 12:35 PM PDT

Hi Dale,

The first day where you recorded 36 hours of actual work completed in 8
hours duration, project calculated:

36 hrs work/8 hour duration = 4.5 or 450%
The second day, where you recorded 40 hours of actual work completed in 8
hours duration, project calculated:

40 hours work/8 hour duration = 5 or 500%

If you display the task usage view and add the Peak Units field to the time
phased (right side) of the view, you'll see the 450% for day 1 and 500% for
day two. On the Gantt chart it just shows the 500% assignment unit.

Hope this helps. Let us know how you get along.

Julie

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

Resource pool problem

Posted: 25 Oct 2005 12:18 PM PDT

Hi Milind,

You have some choices on the Resource Information dialog box about how to
control resource costs. (Double click on the resource name in the Resource
Sheet to show the Resource Information dialog box.)

If the rate change is based on time (resource's rates increase as of a
specific date) you can set a new Effective Date on the cost rate table
A(default) on the Cost tab of the Resource Information dialog box.

If the rate change is not time based (for example the resource charges $200
for one kind of work but $300 for another) you can use the different cost
rate tables (marked B, C, D). Once you have set the different cost rate
table, go to the Resource usage view, double click on the assignment (task
name indented underneath resource name) and in the Assignment information
pick the correct rate table.

Hope this helps. Let us know how you get along.

Julie

"Milind" <fm> wrote in message
news:phx.gbl... 

A different kind of MSP trial problem...

Posted: 25 Oct 2005 11:18 AM PDT

The only thing u can do is to format your machine and reinstall all over again

"dmcas" wrote:
 

new resource pool

Posted: 25 Oct 2005 09:27 AM PDT

Hi Jan,

Thanks for the advice!

Regards,

Hayley

"Jan De Messemaeker" wrote:
 

How do I change resource leveling from days to weeks in Project?

Posted: 25 Oct 2005 08:26 AM PDT

Did you change the setting in the Resource Leveling dialog to Week by
Week? Admittedly, Project will tell you this resource works this many
hours on this job each day, but there's no reason you have to use those
numbers for actual scheduling. I would think the critical thing would
be to get a rough idea during the initial planning process and let
things sort themselves out as you collect actuals from people each
week. Unless they are extremely retentive, my guess is that they
will work based on "this is what I have to get done this week, as
opposed to "I have to work 2 hours on this task today."

This is the thing I think catches most schedulers up (I know it did me)
when they first start up. The schedule is not sacred, it's a tool to
identify when you are going to miss deadlines before you miss them.

Don't serve the tool, let the tool serve you.

Larry

Larry