Pages

Search

% complete vs. % work complete? Microsoft Project

% complete vs. % work complete? Microsoft Project

% complete vs. % work complete?

Posted: 16 Jan 2006 09:23 PM PST

Adding a bit to Mike's explanation - Looking beyond the immediate question
and trying to get to what you boss is actually looking for, comparing
percent complete at some point to what your schedule if followed to the
letter says you'd be at that point doesn't really tell you whether you're
on-schedule or on-budget or not because in itself it's an incomplete
picture. If the goal is to monitor progress, to see if you're on-target or
falling behind, you should look a little deeper into something called Earned
Value which monitors work actually achieved and dollars actually spent by a
selected status date versus what you originally had scheduled to occur by
that date and it gives you some tools to extrapolate those values to come up
with a predicted actual completion date and predicted actual cost. There's
a good discussion under Earned Value in the Project help files to get you
started in the right direction.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs



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

How do I save a Project file with only schedule data?

Posted: 16 Jan 2006 03:52 PM PST

Thanks, you answered my question though I was hoping for something more
transparent and built in by MS. I will check out the Scrub VBA in detail. The
Scrub description looks like it is a little different than what I want but
could be modified for my needs.

However, I have run into a problem sometimes when deleting resource
assignments in that it changes my schedule by the formula. It looks like it
only happens to tasks that were already in progress. So I have to figure out
how to set up tasks so that their schedule is not affected by deleting the
assigned resources.

I'm just a little surprised this isn't built in to MS Project because it
seems like something any company that works with layers of subcontractors
would want so all the subcontractors can provide Project files that get
integrated into a prime contractor's master schedule. Without each
subcontractor divulging their individual pay rates, resource assignments,
etc...

Thx
Ed

"John" wrote:
 

Resource Usage View Precision

Posted: 16 Jan 2006 12:41 PM PST

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

Mike,
Just a followup to Catfish's reply. You might want to take a look at the
"yze timescale data in Excel" utility/add-in found on the "ysis"
toolbar. You will get slightly different results (i.e. format) by
exporting from either the Resource or Task Usage views. Of course with a
custom VBA macro, Project data can be exported and formatted in
virtually any form needed.

John
Project MVP

How can I disable "Work Contour" automatic updates in MS Project?

Posted: 16 Jan 2006 06:56 AM PST

I suggest you change the task type to "Fixed Units" and have 4 columns:
Start, Actual Start, Finish & Actual Finish. I give the task an actual start
then I can either change the duration to project a finish or type in a
projected "Finish" date. Good Luck

"Carine" wrote:
 

Formulas-customize fields

Posted: 16 Jan 2006 04:51 AM PST

Thank you for your answer.

I have two follow up questions for you.

Can you describe what you mean with: "prone to corruption...." It this
method unstable or is it other problem you have experienced.

And the next question: The solution using VBA code. Is it difficult to make?
I have done some VBA-coded macros in Excel before where I teached myself
using record functions and learned the code from these automatic functions.
Can you give me some advice or list some functions I will need. Eg. how to
get access to alter Projects basic fields..... and how to automaticly run
macros when changing values in certain fields.






John skrev:
 

Assigning costs to various resources and material to one task

Posted: 15 Jan 2006 08:48 PM PST

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

Freeman,
You're welcome.
John 

Non-Effort-Driven schedules

Posted: 15 Jan 2006 05:00 PM PST

You're welcome, MJ and thanks for the feedback. :-)

Mike Glen
MS Project MVP


mjkahn wrote: 

Correct Formula

Posted: 15 Jan 2006 03:34 PM PST

David, Thanks so much for your help with this. You have been a life saver.
It6 really would be nice if Microsoft added these features to the Program.
It would be so useful as a presentation tool for my clients that aren't
versed in the program and have only a basic knowledge of a schedule.

Regards,

Charles

"DavidC" wrote:
 

Problem with Gantt View

Posted: 14 Jan 2006 10:16 AM PST

Hi TDK,

Glad you got it sorted. :) SR2 is the Service Release 2 (SR1 corrected an
indenting bug).

Mike Glen
Project MVP



TKD wrote: 

Resource Usage Chart (how to NOT display zero hours worked)

Posted: 13 Jan 2006 08:20 AM PST

I fully understood what you wanted, Kellie, but a sound project file has
nothing at all in the cells unless you put it there. All mine are blank
which leads me to believe there's something wrong with your file. Try a new
project and see if you get zeros all over the place.

Mike

Kellie F. wrote: