Pages

Search

how do I import/copy tasks from one project file to another? Microsoft Project

how do I import/copy tasks from one project file to another? Microsoft Project

how do I import/copy tasks from one project file to another?

Posted: 24 Nov 2005 04:22 AM PST

what I should have mentioned is I'm replacing existing info. I'm able to copy
everything but the predecessors, once they go in the dates get messed up. I'm
doing something wrong?

"Jan De Messemaeker" wrote:
 

Booking Type - Propose resource

Posted: 23 Nov 2005 07:40 PM PST

Dale Howard ，
Sorry, next time i wll post Project Server questions to the
microsoft.public.project.server newsgroup.

I think my question have some problem.
I see the below information in microsoft project 2003
"Note that a resource's booking type applies to all their assignments in the
project"

So may i know have any way can set the resource booking type like this.
example:
if i have a project has 3 task. and today date is 15/oct/2005
task 1 - 01/oct/2005 - 9/oct/2005 - resourceA (committed)
task 2 - 10/oct/2005 - 19/oct/2005 - resourceA (committed)
task 3 - 20/oct/2005 - 30/oct/2005 - resourceA (Propose)

I will post my question to microsoft.public.project.server newsgroup.

Thanks,
Ng


"Dale Howard [MVP]" wrote:
 

Changing Project Default Settings in an Existing Project

Posted: 23 Nov 2005 11:49 AM PST

Hi Bob,

If you want to change the week in Tools, Options, just do it. It will only
influence the display of the tasks where you explicitly used the week as the
unit to be displayed.

In the macro add within the loop
Job.effortdriven=false
But if you have already done the multiplication don't do it again :-))

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"bob1122" <microsoft.com> schreef in bericht
news:com... 
30h 
what 
in 
were 
work 
there a 

Cost per task

Posted: 23 Nov 2005 09:03 AM PST

Hi,

Yes. Insert the Cost line in the Resource Usage View.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"David M C" <microsoft.com> schreef in bericht
news:com... 
throughout 
use 
the 
that 
was 
or 
he 
You'll 
the 
I 
more 
amount 
Project 
but 

Project specific calendar format change

Posted: 23 Nov 2005 08:25 AM PST

You're welcome mikejw. Thanks for the feedback.
Julie
"mikejw" <microsoft.com> wrote in message
news:com... 

Equipment Resource definitions

Posted: 23 Nov 2005 08:19 AM PST

As Gerarrd said - but note, the Server is a Work resource, not a material
resource. I meantion that because some people think "material" means
"inanimate." But that's not true. Material resources are used up and
incorporated into the delieverable. Your server isn't - it is performing
work that contributes to the task's deliverable, just like a person, but it
isn't used up in the process.

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

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

Project diagram view

Posted: 23 Nov 2005 07:48 AM PST

You're welcome, Jimmy :-)

Mike Glen
MS Project MVP


jimmyharris80 wrote: 

constraining tasks by hour

Posted: 23 Nov 2005 07:08 AM PST

I don't know - whenever I see Project being used simply to draw pictures of
a pre-existing schedule I have to wonder why you've spent $1500 for a
product and then only use it to do what could be done just as well by
spending $10 for a wall calendar and box of Magic Markers. At the very
least I'd suggest using it as a reality check, using it to independently
generate a proper schedule in order to confirm whether your pre-existing
master schedule is truly workable, to identify where the potential
bottlenecks may lie in it, and where you might change it to be more
efficient. I think of Project's role as telling ME the best schedule I can
expect to HAVE, given what needs to be done and the assets I'm able to
deploy to achieve it, rather than me telling IT the schedule we're expecting
to work. When you doing the work, building a proper schedule where Project
is calculating the task dates rather than merely parotting the dates you've
input will let you dynamically monitor the downstream effects of actual work
as it's being done so you can keep your "troops" deployed most effectively.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


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

using a definite time frame for a task

Posted: 23 Nov 2005 04:30 AM PST

Mark the task non-effort driven, fixed duration.

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

"jake" <jake @discussions.microsoft.com> wrote in message
news:com... 

Modified Resource Usage View

Posted: 23 Nov 2005 01:58 AM PST

Thanks for the quick response. However this does not quite satisfy what I am
looking for. You see the excel generated by your suggestion provided me with
the following report format.
14-Nov-05 15-Nov-05 16-Nov-05 17-Nov-05 18-Nov-05
Resource A
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs
Resource B
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs
Resource C
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs
Resource D
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs
Resource E
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs
Resource F
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs

The format that I need would look like this:
14-Nov-05 15-Nov-05 16-Nov-05 17-Nov-05 18-Nov-05
Resource A
Task 1 0 0 2 hrs 3 hrs 0
Task 2 8 hrs 8 hrs 6 hrs 5 hrs 8 hrs
Resource B
Task 2 0 1 hrs 1 hrs 0 2 hrs
Task 3 2 hrs 0 0 1 hrs 0
Task 4 6 hrs 7 hrs 7 hrs 7 hrs 6 hrs
Resource C
Task 4 2 hrs 3 hrs 0 0 8 hrs
Task 5 3 hrs 3 hrs 3 hrs 0
Task 6 3 hrs 5 hrs 5 hrs 5 hrs 0
Resource D
Task 2 4 hrs 4 hrs 4 hrs 4 hrs 0
Task 3 4 hrs 4 hrs 4 hrs 4 hrs 8 hrs
Resource E
Task 4 3 hrs 2 hrs 6 hrs 0 0
Task 6 5 hrs 6 hrs 2 hrs 8 hrs 8 hrs
Resource F
Task 1 2 hrs 0 8 hrs 8 hrs 8 hrs
Task 3 1 hrs 0 0 0 0
Task 4 2 hrs 0 0 0 0
Task 5 3 hrs 8 hrs 0 0 0

or the following format may do as well
Name Task Name Date Actual Work
Resource A Task 1 11/16/2005 2
Resource A Task 1 11/17/2005 3
Resource A Task 1 11/18/2005 1
Resource A Task 2 11/14/2005 8
Resource A Task 2 11/15/2005 8
Resource A Task 2 11/16/2005 6
Resource A Task 2 11/17/2005 5
Resource A Task 2 11/18/2005 7
Resource B Task 2 11/15/2005 1
Resource B Task 2 11/16/2005 1
Resource B Task 2 11/18/2005 2
Resource B Task 3 11/14/2005 2
Resource B Task 3 11/17/2005 1
Resource B Task 4 11/14/2005 6
Resource B Task 4 11/15/2005 7
Resource B Task 4 11/16/2005 7
Resource B Task 4 11/17/2005 7
Resource B Task 4 11/18/2005 6
Resource C Task 4 11/14/2005 2
Resource C Task 4 11/15/2005 3
Resource C Task 4 11/18/2005 8

Any suggestions?

Thanks

--
Albert


"Gérard Ducouret" wrote:
 

Converting Finish Variance to total Calendar days

Posted: 22 Nov 2005 07:30 PM PST

Dear Harris and Manmeet

Thank you very much for your helpful response.

Dan

"Haris Rashid" wrote:
 

Rolling up Red, Green, Yellow

Posted: 22 Nov 2005 07:24 PM PST

Hi Glenn,

When you will introduce conditions between fields of several taks you will need VBA.
Formulas are restricted to comparing fields within the task
HTH

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

I was actually using a text field, initially, and wondered how to utilize the rollup feature. I didn't think about trying a number field, but since you mentioned it, it makes perfect sense!

I'm going to take another step... not only will I show red, green, yellow based on completion and date. I will use a number or text field, where I can use it to override the automated settings for tasks that have plenty of time to finish, but have issues that won't allow it to complete on time. This will then show a yellow flag until I discontinue the override.

An example of this would be where if a task is "Install router". Eventhough the date may be a 2 months out and the router can be shipped in 3 weeks and the indicator shows green, If I know the rack can't be installed in time to install the router, I want the ability to force a yellow flag indicator for the task "Install router". Now I need to figure-out how to automagically change the flag to yellow on the "Install router" task, if I force a yellow flag on the predecessor task "Install rack".

I love MS Project! It never ceases to amaze me with it's abilities!!

Glenn
"Gérard Ducouret" <fr> wrote in message news:O%phx.gbl...
Hello Glenn,
You don't say what kind of field you used to these Red, Yellow and Green symbols.
If you used a Number(x) field and if the Red color matches the greatest value, in the Customize Field dialog, for Summaries and groups, select Report : Maximum
Hope this helps, tell us if that work,

Gérard ducouret
"Glenn" <com> a écrit dans le message de news:%23Z%phx.gbl...
I've created a text field formula that allows me graphical indicators to show whether a task is on track.

How do I have the summary row show a specific indicator based on the subtasks below? Although I think I want it to show the worst indicator of the subtasks, I want the flexibility to change as necessary.

Example:

1 ysis (summary row - how do I show RED, based on the below?)
2 Interview Client (subtask - done ontime, GREEN)
3 Create ysis doent (subtask - not done, due yesterday, RED)
4 Review with Resources (subtask - due tomorrow, YELLOW)

Thanks in advance for any assistance
Glenn

General Comment on Custom Functions

Posted: 22 Nov 2005 04:45 PM PST

I would love to know how as well

Majid


"Haris Rashid" wrote:
 

Time Sheet Updates using specific hours per day

Posted: 22 Nov 2005 04:21 PM PST

hi,

you seem to have set a constraint on your task. A task starting on Oct 3
with 10 days duration should finish on Oct 14. Since you have the finish date
of Oct 19 you might have a constraint such as "Finish As Late As Possible",
etc.

When a task is first created, the percent complete is zero percent. As soon
as you enter actual duration, remaining duration, or actual work (which
affects actual duration), Project calculates percent complete as follows:

Percent Complete = (Actual Duration / Duration) * 100

If the % Complete field is set to a value greater than zero, the Actual
Start field is set to the scheduled start date if you have not yet entered an
actual start date. If the % Complete field is set to 100, the Actual Finish
field is set to the scheduled finish date.

If you type a value in the % Complete field, Project automatically
calculates actual duration and remaining duration. Likewise, entering a value
in the Actual Duration or Remaining Duration field automatically recalculates
the other fields.

You can control whether changes to total percent complete are distributed
through the status date or to the end of the task's actual duration so far.
On the Tools menu, click Options. On the Calculation tab, select or clear the
Edits to total task % complete will be spread to the status date check box.

When you enter percent complete, Project might adjust actual and remaining
work around the current status date. If you prefer, you can leave these
tracking fields in the project as originally scheduled, even if completed
work is shown in the future or remaining work is shown in the past. On the
Tools menu, click Options. On the Calculation tab, clear the Move end of
completed parts after status date back to status date and Move start of
remaining parts before status date forward to status date check boxes.

To set the status date to a date other than today's date, click Project
Information on the Project menu, and then enter the date in the Status date
box.

Regards,
-----------------
Haris
http://www.manage-systems.com
----------------------------------------

"Grant" wrote:
 

smart predesessor pasting

Posted: 22 Nov 2005 02:13 PM PST


John wrote: 

I always caution people about having multiple tasks with the same name.
It can lead to a great deal of confusion, both in the Network Diagram
and in a sorted or filtered Gantt. It can be hard to tell with "Review
Drawings" you're looking at if there are several of them. If you ask on
here, someone will have a VBA macro that puts the appropriate summary
task name, if they're unique, into the task name. So your tasks would
be "Preparation Review Drawings" and "Final Review Drawings", etc. Can
save a lot of headaches down the road.
Hope this helps in your world.

Custom report showing dependencies' % complete, estimated complete date, and actual complete date

Posted: 22 Nov 2005 02:11 PM PST

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

anewton,
Sure, just write me direct - I receive a fair amount of "off-list"
queries.

John
Project MVP
mjensenatattheriverdotdotcom
delete obvious redundancies

How do I get my Visual Basic "New Project" dialog box back?

Posted: 22 Nov 2005 08:29 AM PST



"John" wrote:
 

How do I set a project task effort to be a percentage of other tas

Posted: 22 Nov 2005 08:20 AM PST

Oops,

http://www.andythevikingfordham.com/

One hundred ......and forrrrrrtttttyyyyyy! cheer cheer



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

Is there a way to lock a completed task in MS Project 2003?

Posted: 22 Nov 2005 07:31 AM PST

In article <com>,
Dan Bridy <microsoft.com> wrote:
 

Dan,
Whew! I'm glad you won't have to shoot anybody either - I hate when that
happens - it's just so messy.

Seriously, you're welcome.

John

Dealing with Effort and Duration

Posted: 22 Nov 2005 06:35 AM PST

I like your approach!!!!! <grin>
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"John Sitka" <com> wrote in message
news:%phx.gbl... 

Disable field after entry

Posted: 22 Nov 2005 05:07 AM PST

Hi Trev,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP


Trev wrote: 

Track Actual Hours without changing Start-Finish Date

Posted: 21 Nov 2005 04:37 PM PST

Are you tracking *duration* hours or *work* hours? They are very different
measures. Duration is time and there absolutely positively cannot be more
than 24 duration hours in a day, at least on this planet. Work, OTOH, is
actually "man-hours" and when two people work together for 24 hours, they do
a total of 48 man-hours of work.

Do you really have 24 hour workdays? That means that when a task begins it
doesn't stop until it's completed AND the resources assigned to it work on
it for the entire period of time. If a task lasts 72 hours, that means that
the crew that works on it doesn't rest, eat a meal, take a break or a nap,
or get any time off whatsoever for the entire continuous 3 days. It does
NOT mean that you have people coming and going with some guys working days,
others nights, etc. The 24 hour calendar says that if Joe is assigned
to that task, he joins the task when it starts and doesn't leave for any
reason until it's finished days later. Machines might do that but people
don't - they need at least to sleep and eat a little while out of each day.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


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

large plots for resource useage

Posted: 21 Nov 2005 01:58 PM PST

Mike,
Thanks but that's not it. I can go boack without any other changes and
make the plot size 30" x 50" (without changing the columns) and it works.
There must be some undoented plot length for data !?
It's really weird, as the backgound plots out fine. The actual data just
gives a '#' and stops filling in the data. I think its a limitation by
number of columns or plot length. It would seem like it would stop plotting
everything instead of just the actual work data.....
If you think of anything let me know but this is no show stopper.

Thanks

--
Best Regards,
Eddie A


"Mike Glen" wrote:
 

Charts and Graphs

Posted: 21 Nov 2005 12:48 PM PST

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

motor_mouth,
Oh sure, now the whole story comes out ;-)

The Resource Graph view in Project is by resource rather than by task
assignment so you are probably not going to get the information
directly. There are a couple of options. The option I would chose (and
have used on some of my projects) may be a little advanced because it
involves using a VBA macro to export the necessary data to Excel and
then plotting it in a manpower curve. However, an equivalent process can
be used without a custom VBA macro. Starting from the Task Usage view,
use the "yze timescale data in Excel" untility/add-in found on the
"ysis" toolbar (I would export the Work field). Once the data is in
Excel, use Excel's charting capability to develop the graph you want.

Just for reference you might want to consider using a rolling average
instead of exact monthly values when it comes to reviewing manpower
needs, (I used a 3 month rolling average), otherwise you will end up
with hiring/layoff spikes that don't reflect reality.

Hope this helps.
John
Project MVP

Deadline vs. Must Start On

Posted: 21 Nov 2005 11:34 AM PST

Tools menu, Customize, Fields - create a flag field with a formula that
tests for the condition you're monitoring and choose "graphical indicators"
in the dialog box as the results display.

I wonder at the logic of looking at start date with respect to a deadline.
Deadlines describe the required completion date for the task. Checking to
see if a task is started by 90 days before its deadline really only makes
sense if the task requires 90 days to do. The duration of a task is your
best-guess estimate of how long it will actually take to complete the task
once it starts. Comparing a start date with a deadline only gives you useful
information if the time frame you're looking at compares the start with the
deadline minus the duration and it will only be 90, 60, or 15 days if the
task duration also happens to be 90, 60, or 15 days respectively. What
counts is not that it starts 90 days ahead of deadline but rather that it
has started by whatever you have determined is the latest date it should
start so that it can finish by the deadline. Best practice suggests that
when a resource is assigned to a task they will be expected to start it on
the date you have scheduled it to start and work on it full-time until it
has finished. The duration of the task is not how long they are allowed to
finish it - it's your best estimate of how long you think it should take
them to finish it.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

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