Pages

Search

Tracking % complete for fixed work task Microsoft Project

Tracking % complete for fixed work task Microsoft Project


Tracking % complete for fixed work task

Posted: 09 Jun 2005 01:55 PM PDT

In addition to Mikes comments, make sure you're clear on the difference
between work and duration. % Complete in Project refers to duration, not
work, even on fixed work tasks. There is a whole different field, % Work
Complete, that refers to the work progress. They may be the same, perhaps
one could even say they usually are the same, but that's by no means
universal. Consider a task that starts Monday at 8am and requires 1 hour of
work on each of Mon, Tue, Wed and Thur, with a full day to finish it off on
Friday. Perhaps it's paint that has to dry overnight between coats. The
duration is 40 hours, the time between when work first happens and when it
ends (8am Mon - 5pm Fri). The work is 12 hours (1+1+1+1+8). It is now 5pm
Thur and everything has gone according to plan. We have passed 32 out of
the 40 required hours of duration so the task is 80% Complete. But we have
done 4 out of the 12 hours of work required, so the task is 33% Work
Complete.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


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

EV Formulas

Posted: 09 Jun 2005 10:50 AM PDT

We don't use these fields for real earned value but here are the calculations:

BCWP: When a task is first created, the BCWP is $0.00. As soon as a
baseline is saved and progress is reported for the task (as actual work,
actual duration, or percentage of work complete), Microsoft Project
calculates BCWP. This calculation is based on the percentage of work
complete, as compared with the task's baseline duration. Microsoft Project
then calculates the cumulative baseline cost and provides the value of what
the task's actual costs should be, given the task's progress to that point in
the task's baseline duration.

BCWS: To calculate BCWS for a task, Microsoft Project adds the timephased
baseline costs of the task up to the status date.

ACWP: When a task is first created, the ACWP field contains $0. As
progress (percentage of completion or actual work) is reported on the task,
Microsoft Project calculates the actual cost of work performed (ACWP). This
is the cost of actual work plus any fixed costs for the task to date. By
default, how and when ACWP is calculated depend on the assigned resources'
Standard Rate, Overtime Rate, Per Use Cost, and Cost accrual settings in the
Resource Information dialog box, as well as the actual work reported, fixed
costs for tasks, and the status date or today's date. Microsoft Project can
calculate ACWP even if you do not have resources assigned. In this case, the
calculations are based on progress (percentage of completion or actual work)
and fixed costs to date for the task. If you prefer, you can have ACWP
calculated based on your entries in the Actual Cost (timephased) field. On
the Tools menu, click Options, and then click the Calculation tab. Clear the
Actual costs are always calculated by Microsoft Project check box.




"bauer172uw" wrote:
 

Alll Gantt bars are grey in MSP2003

Posted: 09 Jun 2005 10:22 AM PDT

That is a good (tres bien) suggestion. I know the Gantt draws in 'layers'. I
am away from my pc, but I will verify first thing!
Merci mille fois.

"Gérard Ducouret" wrote:
 

Gant Chart View

Posted: 09 Jun 2005 09:56 AM PDT


Hi Harry,

Welcome to this Microsoft Project newsgroup :)

Scroll the Gantt chart horizontally until the first task (Project Summary
task?) begins at the left edge of the chart.

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



Harry wrote: 



break in task bar with different resource allotments

Posted: 09 Jun 2005 07:48 AM PDT


Hi redlurered ,

Welcome to this Microsoft Project newsgroup :)

You could use the Resource Usage view and type in the Work hours you want
when the resource is available.

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



wrote: 



Multilevel Resource Grouping Functionality

Posted: 09 Jun 2005 07:27 AM PDT

I see what you mean. Well we're not gonna buy AXTAPA, we are already on JD
Edwards, so I'll just hope for the best and muddle through in the meantime.
Maybe I'll see if I can code something that will work. In my non-existent
spare time

Thanks again,

Kevin

"Jan De Messemaeker" wrote:
 

How do I use initials in Gantt chart?

Posted: 09 Jun 2005 03:53 AM PDT

Hi Boris,

In the hours to come I'll reply to that one. Promise.

--
Jan De Messemaeker
Microsoft Project MVP
+32 495 300 620
http://users.online.be/prom-ade
"BorisS" <microsoft.com> wrote in message
news:com... 


Make a group of Ressources.

Posted: 09 Jun 2005 02:58 AM PDT

Hi Mat,

You have to give them all 3 each tilme.
The good news is that this is very easy through the resource assignment
window:
Select all tasks for the group
select the 3 resoureces
Click Assign
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"MAT" <microsoft.com> schreef in bericht
news:com... 
personen, 
each 


custom report

Posted: 08 Jun 2005 10:04 PM PDT

Hi Boris,

(a) I know next to nothing about Project's reports. I doedcided I don't like
them, I print from views.
(b) Dop you have a column Level1 as well? I honestly do not remember my
macro. is it in Text2?
I'll suppose so.
Try this
Draw the Split bar to the right such that you will only print characters and
figures
View, Table, More Tables, New, give a name, define columns as follows
Text1
Text2
Name
Start
Finish
Resource Names
Notes

OK, Apply
Adjust column witdth as appropriate.

Project, Sort, Sort by...
Name
Start
And verify "Keep Outline Structure" is on

Tell me what's wrong.

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"BorisS" <microsoft.com> schreef in bericht
news:com... 
of 
4): 
Date 
to 
done 
company, 
assigned 
because 
several 
When 
specifically 
Excel 
field 
been 
Text1 


Breaking up Master Projects

Posted: 08 Jun 2005 06:02 PM PDT

In article <com>,
D Pingger <microsoft.com> wrote:
 

Ping,
Basically, my macro takes a dynamically consolidated master file with
external links between subprojects and converts it to a static master
wherein the external links are converted to standard Predecessors and
Successors. I'll tell you up front, the macro is not freeware but if you
want more information write me direct. Note: I suspect a problem with my
e-mail recently so if you send me a note leave a response to this thread
saying you did.

John
Project MVP

Using Tasks to Force MSP to Consider Vacation Time

Posted: 08 Jun 2005 04:51 PM PDT

2003 - I will look into this further

BTW, I wasn't sure what you meant about "giving everyone a full-time
Calendar". Also, what I was finding is that if someone goes on a long
vacation which initially conflicts with a work task, MS Project forces the
task into the vacation and splits the vacation, which will surely upset the
employee! The only way around this I found was to set the priority of the
vacation to be 1000 so it took precedence. Is this the right approach? How
will levelling resolve it (as your article suggests)?

tx


"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message
news:phx.gbl... 

do 
message 
will 
and 
that 
instance 
as 


Colored Text does not appear in Reports

Posted: 08 Jun 2005 01:57 PM PDT

seth wrote:
 

Reports do not use the same formatting as views.

You might try looking at creating views that group, sort, filter the
data in a way to where it looks like a report. Then the coloring you
did would show.

Sorry

--
Brian K - Project MVP
http://www.projectified.com
--
Senior Trainer - Electronic Arts
--
QuantumPM Associate
http://www.quantumpm.com

How do I sum multiple rows of different colors

Posted: 08 Jun 2005 08:49 AM PDT

JackD wrote:
 

Sure but then dont call it 50% complete. Call it "In Progress". It
seemed as if his request would have made a summary task with 5 complete
tasks and 5 tasks that were either not started or in progress 50%
complete. This is just wrong data even if all the 'yellow' tasks were
99.9% complete the summary would only be close to 50% complete if all
the tasks were the same 'size'. If all the complete tasks were 1 day
and the 'yellow' or 'red' tasks were 20 days then it gets even worse.
The other side of the same bad coin is true if the complete tasks were
really long and the incomplete ones were short. It would say 50%
complete when really it was almost 100% complete.

My fear with this is that someone (an exec or upper manager) will not
get that these numbers are approximations. I am against using what
appears to most people as an exact measure (50%, 75%, etc) for
something that is behind the scenes only a very rough and inaccurate
measure.

--
Brian K - Project MVP
http://www.projectified.com
--
Senior Trainer - Electronic Arts
--
QuantumPM Associate
http://www.quantumpm.com

What is Project Capable of...?

Posted: 08 Jun 2005 06:27 AM PDT

You have all be very helpful and for that I thank you. I just wanted to make
sure I was getting my moneys worth out of project, it will do a great job
scheduling our many tasks. Thank you all

Steve Budzynski

"Rod Gill" wrote:
 

which version to get?

Posted: 08 Jun 2005 02:39 AM PDT

Adding a note to Mike's answer, Project Professional only adds functionality
to what you'd get with Project Standard when it's being used in a network
with Project Server installed. Without Server, the two are essentailly
identical. With Server, the Project Managers who create and maintain the
plans all need to have MS Project. Resources who access the plan, perhaps
update it, but who will not be modifiying it access the plan with Project
Web Access through their browser.

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

"Jay" <com> wrote in message
news:c2zpe.5991$xtra.co.nz... 

S Curves for milestone reporting

Posted: 07 Jun 2005 06:51 PM PDT

Excel is made for calculation and graphing. Project does not offer that sort
of function. That is why they made it easy for Project to export to excel.
In my opinion that is the simplest and best ways. You could certainly cobble
together code which would graph within project but that would be a fairly
serious development effort and would not offer the wide functionality that
excel offers.

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..
"John" <com> wrote in message
news:microsoft.com... 
using an 
from 
appreciated. 


Tutoring agreement or contract.

Posted: 07 Jun 2005 02:09 PM PDT

In article <com>,
arenee <microsoft.com> wrote:
 

arenee,
This is a newsgroup dedicated to Microsoft Project. Unless someone here
has first hand experience with tutoring, I doubt you will get much
response. I suggest you either consult an attorney or perhaps do a
search on the internet for "tutoring", "self-employment contracts" or
similar.

John
Project MVP

License change on same workstation

Posted: 07 Jun 2005 11:49 AM PDT

Thanks Steve,

We came to the same conclusion here. The problem was that my CD drive
wouldn't read the new CD (it had been acting flakey for a while). I
canabalized a DVD burner (and software) off of a newer machine destined for a
temp and installed it in mine. Did the uninstall and re-install in less than
3 minutes.

Best regards,

Kevin

"Steve House [Project MVP]" wrote: