Pages

Search

Linking Project and Excel Microsoft Project

Linking Project and Excel Microsoft Project

Linking Project and Excel

Posted: 09 May 2005 09:20 AM PDT

Chris,

I jumped the gun in my earlier reply - my apologies!

Please also see FAQ #10 at
http://www.mvps.org/project/faqs.htm#Hidden%20Column
--
Don L.


"Chris C" wrote:
 

Clearing formatting

Posted: 09 May 2005 08:15 AM PDT

Sorry... this feature applies to bar styles. Not to Text styles.

Gérard Ducouret

"Gérard Ducouret" <fr> a écrit dans le message
de news:phx.gbl... 

Differing task Types

Posted: 09 May 2005 07:23 AM PDT

Hi Steve,

Welcome to this Microsoft Project newsgroup :)

Not that I'm aware of. It is a task-level setting that Project takes into
account when you change the assignment of resources on that task. Should
you do so, then it could result in a recalculation of all the projects in
your integrated plan depending upon how they're linked. Ditto if you level
resources after making the changes.

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

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

Mike Glen
MS Project MVP



Steve Scott wrote: 

Removing all traces of linked projects

Posted: 09 May 2005 03:07 AM PDT

Hi Rod

Thanks for the info. Is there a better way to achieve what it is I am
trying to do? It sounds by your email as though this method could be at
risk of corruption, particularly as a number of people could be updating the
projects.

Thanks again
Alex


"Rod Gill" <rod AT project-systems DOT co DOT nz> wrote in message
news:phx.gbl... 
view. 
clicking 
of 
view 
Resource 

Have Project 2000, how to view WBS

Posted: 09 May 2005 02:16 AM PDT

What sort of WBS view are you talking about? Do you mean seeing the tasks
in an organization chart heirarchy or do you mean seeing the WBS numbers
along with the task names?

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

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

Project 4.1 to Project Standard 2003

Posted: 08 May 2005 03:28 AM PDT

Hi ,

Welcome to this Microsoft Project newsgroup :-)

Please see FAQ Item: 27. Project 4 to Project 2000

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

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

Mike Glen
Project MVP


Tired and Confused wrote: 

Unable to find a hot fix file in microsoft website.

Posted: 07 May 2005 01:13 AM PDT

Dears,
Thank you so much i called Microsoft and downloaded the required hotfix.

--
PMO Specialist


"Brian K - Project MVP" wrote:
 

A method to have only durations?

Posted: 07 May 2005 12:07 AM PDT

Thank you for the explanation and being patient with me.

Yes, "Elapsed time" is more accurate than "duration" and I will remember
that.
The frustration with this entire process is this:

We simply want to enter a task ID 800 and the "elapsed time", in calendar
days, that the vendor will have site access, because that is written in
their contract--X days. [weekends, holidays, nights do not matter, it's X
days]

Then, as we negotiate with other vendors for their start dates and "elapsed
times", we can easily determine the CP and sequencing. Now we see that task
ID 750 is the previous event and task ID 850 follows this one.

So, we click to link 750 to as the previous event to ID 800, then task ID
850 to follow.

But no matter how we mess around, we can't get ID 800 to simply reflect 10
elapsed days.

But we will try again Monday, using calendar and options.

Thanks again.

[actually, I do type on a cheese sandwich] <g>


"Steve House [Project MVP]" <send.hotmail.com> wrote
in message news:%235Bnm$phx.gbl... 
dealing 
like 
your 
my 
confusing 
default 
Monday 
enter 
at 
as 
A 
Month" 
all 
starting 
task 
continuing 
"Joes" 
based 
counts. 
work 
of 
there 
duration 
5 
one 
Now 
month, 
is 
days 
shipments, 

Using PERT on a task with multiple resources

Posted: 06 May 2005 05:58 PM PDT

Interesting concept. Let's say I did this...


"Rod Gill" <rod AT project-systems DOT co DOT nz> wrote in message
news:%23BeA%phx.gbl... 

Why do I get extra copies when trying to delete files?

Posted: 06 May 2005 04:36 PM PDT

Take your finger off the Ctrl key before pressing delete. If that doesn't
fix it post in a Windows Explorer group.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


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

Can a Project schedule be converted to a pdf file?

Posted: 06 May 2005 03:21 PM PDT

Hi ,

Welcome to this Microsoft Project newsgroup :-)

Please see FAQ Item: 16. Project Viewer.

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

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

Mike Glen
Project MVP



convert project to pdf wrote: 

Dur. Estimates, Assignments & Leveling question

Posted: 06 May 2005 01:45 PM PDT

FYI, the assignment percentages don't mean quite what you may think they
mean. If a resource is assigned X percentage to a task of Y duration, it
does NOT mean he's only working on the task for that portion of the
duration. If you assign the SME to a 6 hour task at 33.3%, it means he's
physically working on the task over the course of all 6 of those hours but
he's also doing other things at the same time and so is only producing what
he'd get done in 2 hours if he was giving it his full attention. A similar
reasoning applies for the DEV. If you assign both the SME at 33.3% and
the DEV at 66.7% to a 6 hour hour task and then look at the resource usage
view with the timescale expanded to show the hours though the day, you will
not see the SME working 2 hours and the DEV working 4. You'll see them both
working side by side for all 6hours but the SME will be generating 20
minutes of work for each hour on the task (.33 hr) and the DEV generating 40
minutes.

If you really want to show the SME puts in 2 hours and then goes away while
the DEV comes on-board at that point and continues on for 4 more hours, you
need to show it in one of two ways. You can show it with the lesson is a
summary task with one 2-hour subtask under it with the SME assigned at 100%
and a second 4-hour subtask with DEV assigned 100% to it and the two tasks
linked FS. Or you can show the lesson as a single 6-hour task and then use
the split screen to enter the assignments in the bottom Task Form window,
Resource Work formatting, entering the SME assigned 100% and 2 hours of work
and the DEV assigned 100% with 4 hours work AND a 2-hour delay for his work
entered manually as well. This means the SME starts at the beginning of the
task and devotes full attention to it for 2 hours, then the DEV comes on and
devotes full attention to it for the remaining 4. Either of these two
methods will distribute the work correctly, but in choosing which one to use
I'd personally prefer the former. The work itself of the SME and the DEV is
quite different and the SME's work is producing a unique deliverable that is
then handed off the the DEV as input for his work. The DEV's output is
quite different from the SME's output. This quality of the difference in
the nature of the work itself and the uniquness of the deliverables produced
by each resource indicates they are two separate and clearly distinct tasks
and theoretically they could even be done at separate times (the SME writing
up a set of notes and then sending them to the DEV who writes the lesson
later).

As I write the above it occurs to be that I'd expect the DEV to actually
devote all 6 hours of the task's duration to it, an assignment of 100% to a
6-hour task producing 6 man-hours of labour. Whenever I have been
personally been involved in or observed similar work activities, the writer
and the subject matter expert work together at the start of the task to
determine the lesson content, then the SME goes away and the DEV then writes
up the lesson document itself based on the notes he kept during the
conversation with the SME. IF that's the case for you, the most accurate
model of all is to show the lesson as a summary task, with the SME's work a
2-hour subtask and the DEV's work a 6 hour-subtask, both resources assigned
100% to their respective tasks and the two tasks linked SS so they start at
the same time. The summary task's duration will be 6 hours since the two
subtasks occur in parallel and the lesson will require a total of 8
man-hours of work.

As an aside, I'm curious how you can determine in advance the amount of work
each lesson will require and say they are all equal? Have you actually
determined experientially that it requires 6 to 8 man-hours of effort to
write a lesson or is it based on "managment by objective" logic like "We can
only afford for them to take 6 hours to write a lesson and so that's what
they'll have to do it in"? Basing it on historical duration - "In past
projects Joe Writer has produced on average a lesson a day" - seems more
reliable. I'm always leery of precise advance work estimates as opposed to
duration estimates when the output is an intangible (and in your case, while
the typed up lesson is a tangible output, the content of the lesson - the
substance of the work effort itself - is not). And estimates of either work
OR duration for creative endeavors such as writing are never very tidy -
some modules may fly out requiring only a couple of hours to knock off while
others may fester for days before the creative "Ah HAH, that's the way to do
it!" moment occurs.

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


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

Highlighting Text in Project

Posted: 06 May 2005 12:55 PM PDT

You're welcome, Rick :-)

Mike Glen
MS Project MVP





Rick Wilson wrote: 

Urgent: Resources and Linked Projects Problems

Posted: 06 May 2005 11:02 AM PDT

There is a much simpler solution. Create a Resource Pool, a file with
only resources in it. All your resources. Then, link your separate
projects to it. Open each file while the Resource Pool is open. Go into
the schedules and do a "Tools, Resource Sharing, Share Resources".
Leave the default settings and click OK. Do the same for every file you
want to share the Resource Pool.
When you want to create the Master Project, open the Resource Pool. A
dialog box with 3 options will appear - select option 3, "Create Master
Project" (or something like that. I don't have Project on this
computer). Project will then make a composite which will have all the
projects in it, and without the problems you've described.
Best of luck!

Save Baseline Greyed Out

Posted: 06 May 2005 04:10 AM PDT

Hi

if you ever come across the solution i would be interested in knowing it ...

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Java Hound" <microsoft.com> wrote in message
news:com... 

gantt chart lost in Project 2003

Posted: 05 May 2005 10:46 PM PDT

Hi,

If it's the table side someone may have defined a table with all zero width
columns.
That is sometimes done to print only the right part without the two first
colums.
You might have had a look at View, Table, More Tables, Edit.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Irvine" <microsoft.com> schreef in bericht
news:com... 
the 
just 
<microsoft.com> 
chart 

Printing Project Plans in MS Project 2000

Posted: 05 May 2005 12:50 PM PDT

Hi JLS,

SR-1 was the service release for Microsoft Project 2000. See the following
link for download details:

http://support.microsoft.com/default.aspx?scid=kb;en-us;288953

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

Julie

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

Earned value calculations

Posted: 05 May 2005 11:00 AM PDT

If Project is applying work in the future you';re taking the shortcut of
simply marking a task with X percentage complete without entering actual
work on the dates it occured. Updating the task with % complete using the
toolbar or the "Update Project" tools in the Tools Tracking menu the
percentage assumes the work on the task has been done exactly according to
plan. If it's antythhing else you need to post it the long way by entering
the ACtual Start date for the point in time where the work was first done on
the task and entering the Actual Duration and Remaining Duration fields or
using the Usage View and entering actual work hours on the days where the
work was done.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

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

MS Project: Listing Resource Names by Task Bars

Posted: 05 May 2005 09:24 AM PDT

Hi John,

You are very welcome and thanks for the feedback. Let us know if we can
assist again in the future.

Julie

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

Who does what Report.

Posted: 05 May 2005 08:56 AM PDT

You're welcome and thanks for the feedback.

Julie

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

how to enter smaller task durations such as 20 seconds

Posted: 04 May 2005 11:46 PM PDT

Any time I want to schedule and track tasks of very short duration, such as
"verify equipment has been delivered", I set it up as a 'milestone' (0 in
duration column) which can still be scheduled and marked as 'complete' and
have dependencies, etc.
--
Mark Byington, PMP


"Wasantha K Weerakoone" wrote:
 

Overwriting a Plan on Project Server

Posted: 04 May 2005 09:31 PM PDT

Greg --

Your PM screwed up big-time by saving an .mpp copy of his project and then
making revisions to it while team members were submitted progress on that
project. What he should have done is to save the project as an Offline
project (File - Save Offline) and then he would not be facing these
problems. To solve this problem, somebody is going to lose something in the
process. Therefore, I would recommend the following process:

1. The PM should accept all tasks updates into the old version of the
project and ask team members to cease submitting actuals
2. The PM should save and publish the old version of the project
3. You (the PS admin) should delete the project and its accompanying WSS
subweb from the Project Server database
4. The PM should import the new version of the project using Tools -
Enterprise Options - Import Project to Enterprise
5. The PM should publish the project using Collaborate - Publish - All
Information
6. The PM should republish all assignments using Collaborate - Publish -
Republish Assignments with the "Overwrite actual work entered by resources"
option selected
7. The PM should ask his team members to RESUBMIT actuals for all
in-progress tasks, even if they submitted those same actuals in the old
version of the project
8. The PM should promise NEVER to do this again!

Hope this helps.

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


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

Leveling Splits Tasks Into Small Pieces

Posted: 04 May 2005 02:52 PM PDT

Leveling doesn't assign resources or change their assignments. All it can
do is delay when some or all of their work on the task will take place in
order to resolve double bookings. It can split the task up when necessary
to resolve overallocation conflicts with a higher priority task in a time
frame shorter than the task duration or you can set it so it will move the
entire task as a block to resolve an overallocation during any part of it.
Joe is booked to task A for 5 days starting Monday. He's also booked to
higher priority 1-day task B on Wednesday, higher priority meaning it's more
important for B to start and finish Wed than it is for A to finish Fri.
Leveling will either split A to free him up on Wednesday, moving the
remainder of A to resume Thursday and finish Monday or it can move the
entire task A to start on Thurs and finish the following Wed. (Using days
for illustration but the principle applies equally to hours as well.)
Anything more sophisticated than that you'll have to resolve by hand.

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



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

Need Weekly Task List for Each Resource in Shared Resource Pool

Posted: 04 May 2005 01:02 PM PDT

Hi,

For starters, you can change the timescale in the view to reflect the week
as minor scale.
Filter for incomplete taks and Sort on Start date may help as well.
HTH

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

Cost in Project

Posted: 04 May 2005 09:36 AM PDT

Thanks Mike, I'll read the information and practice.

"Mike Glen" wrote: