Pages

Search

Printing a report of % completed? Microsoft Project

Printing a report of % completed? Microsoft Project

Printing a report of % completed?

Posted: 04 Aug 2004 03:29 PM PDT

Hi

You could try the following option

Use the filter "Incomplete tasks" (Project --> Filtered
for -->Incomplete task). This extracts the tasks that are
not complete (ie., % complete<100%)
To create the report of above tasks , you could use View -
->Reports --> choose "Current activities" -->
click "Select" --> choose "Completed activities" -->click"
EDIT" --> Change the filter option to " Incomplete task"-- 
report of uncompleted task

M Rajkumar

-----Original Message-----

 
merely tells you all the work that has 'not' yet been
completed and what their %'s are? 
boss has given me the oh so fun task of figuring out how
to just print the report based on that column, whats left
to work on and the percent. Please help =) 

assigning more than one parent task to a sub task

Posted: 04 Aug 2004 04:27 AM PDT

John, Jack and Steve,

Many thanks for the tips and clarifications. Indeed I'm quite a beginner in using project, and still need to dig it more to understand its capabilities and methods :)

The "meetings" summary task was in order to facilitate the presentation of the project, however, I took the advice about re-organizing the tasks hierarchy , and changed it.

The new structure should look like :

Initial Plan
- task 1
- task 2
- meet a&b for specs

Customers
- meet a&b for specs (here it's linked form above)
- research...
- task 3

So now I have 2 parent tasks called "Initial plan" and "Customers" , to which the sub-task "meet a&b" is logically related.
The "meetings" summary was ditched.

Progress-wise, "meet a&b" should be in the "initial plan" summary, as it follows the other tasks there.
Context-wise, I'd like to put a link to it in "Customers", for a full view of all related tasks.

"Customers" and "initial plan" are parallel processes (while moving the initial plan, we are also making some preliminary research for customers).

Again, many thanks for the tip. I'm not sure I fully understood it, but will take the time and tamper with Project a bit to understand values & fields. Will update how it went :)

Thanks again,
Uri


"John" wrote:
 

Preventing task going accross two days

Posted: 03 Aug 2004 09:48 PM PDT

Ron,

Thanks for the feedback.

Regards,

serene
 
tasks in the 
this, but I don't 
group. 
project.server 
and Project VBA 
message 
All 
job 
want 
day. 

entering bills and invoices

Posted: 03 Aug 2004 05:35 PM PDT

Hi Steve

thanks for the response ...

"Costing it in the task that uses it rather than the task that procures it
actually gives you more accurate cash flows IMHO because it allows you to
better predict where in the project the need for the cash arises."

this i would agree is the key issue ... when are you "committed" to the
expenditure? (i must admit i normally discuss this topic in terms of
purchase for "one-off" materials (buy-ins) and not in a renting context.

just going off on a bit of a tangent - have you ever had a problem linking
b/n excel & project ... one of my students emailled me the other day and
said that he can't do it -he's getting an OLE error (the OLE paste operation
can not be completed. the data that you're trying to paste is not valid for
microsoft project) ... i've sent him back to try a few things but was
wondering if you've ever come across this?

Regards
JulieD


"Steve House" <send.hotmail.com> wrote in message
news:e$phx.gbl... 
to 
the 
get 
totalled 
them." 
when 
and 
this 
in 
"Tool 
in 
I 
it 
the 

%Work Complete vs. %Complete (Duration) in E.V. Calculations

Posted: 03 Aug 2004 02:19 PM PDT

Good info but like more clarification on the MS Project
formula used to calculate BCWP. The reference book
states that BCWP = (% Work Complete)*BCWS. This formula
seems to work in most cases. I get confused when trying
to follow how BCWP is calculated at the task level for
certain conditions. The first is when the Status Date is
before the Finish Date (Baseline or Plan) - it seems the
max value MS Project will calculate for BCWP is based on
the maximum number of possible work hours for the time.
For example, I have have a task that is 20 days in
duration with a work effort of 160 hr and my status
period is 15 days into the task. Total baseline budget
for this task is $1,600. The BCWS = $1,200. It appears
the primary input driver for calulating BCWP is %
Complete. In this example if I enter a % Complete
between 0 and 75%, the BCWP will range from 0 to $1,200.
However, if I enter a %COmplete greater than 75%, BCWP
seems to not exceed $1,200. This seems to be related the
maximum possible hours a person can work (if constrained
to 100% or 8 hrs/day), which in this example = 120 hrs.
The calculation also seems hard to follow if I change the
planned work after the task has been baselined and > 0%.

I believe it's my lack of understanding the the business
rules behind the BCWP formula. Any help would be
appreciated.

Thanks




 
bring the project in 
into an Iron Triangle 
interchangeably 
if your project 
away you don't have 
off, the balance the 
and money that 
work and duration - it 
on the other hand 
temptation to interchange 
complete the new 
I'll need 3 
a week each. If 
salary out of my 
work-day, I'll only 
whoever it is that 
balance. That's 
for 10 days or 
I need to get the 
have another resource 
does increase my cost. 
on my project also 
will be completed. 
time can make 10 
the other hand, if 
make that same 100 
his maximum output 
more than that.) OTOH, 
widgets made in 1 day. 
output required. 
road example, work 
km per day we can 
to complete the road. 
work. It deals with two 
budget performance. 
to this date 
Between the start of 
but because of a fire 
Budgeted Cost of 
planned at $500/wk but 
3rd for 2 weeks 
date for the 
did we plan we would 
Unless you've had to 
or blown the 
close to 1. But if I'd 
because my main 
of getting 10 a day 
only do 5 a day each, 
than I'd planned to 
Project Management 
closely with it as far as 
wrote in message 
the 
duration 
ludicrous. I 
a 
projects 
is 
about 
of 
know 
avoiding 
through 
as 
from 
problem 

Project Finish Date

Posted: 03 Aug 2004 01:53 PM PDT

With the deadline field you get a two'fer Jack. When a deadline is placed
on the finish milestone (or any other task, for that matter) slack time for
the whole project is calculated in exactly the same way as if you had placed
a Finish No Later Than constraint on the same task. The difference is in
the start/finish placement of the task in the timeline. The constraint
locks its placement to the desired constraint date *even if it is impossible
that is when it can actually occur* and calculates that it has negative
slack. But to be aware of this one has to scan the whole task list to look
for link arrows hooking from the right hand end of a task bar back to left
or switch the table so as to view slack times. The deadline, OTOH, allows
the milestone event to move in the timeline to the date where it's really
going to occur if we try to do the work as currently planned, sends up a Red
Flag warning in the Indicator column of the Gantt entry table, AND you still
see exactly the same negative slack as you got when you used the constraint
when you display tables that show slack times.

The deadline's effect on slack time calculation is very similar to using
constraints with the setting "Tasks Always Obey Their Constraint Dates"
turned off. The problem with that approach is that it is global in its
effect on tasks and there will often be tasks that you *do* want to obey
their constraint dates even if you don't want some other tasks to do so. IF
I've used a FNLT constraint to indicate a deadline and also have a SNET
constraint on another task, I want SNET task to show its *constrained* start
date in the timeline and yet I also want the deadlined task to show its
*unconstrained* finish date. Unfortunately "obeys constraints" cannot be
set on or off at the individual task level so I can't have it that way.
Using the deadline instead of the FNLT constraint allows me to.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs



"JackD" <momokuri@gmail> wrote in message
news:phx.gbl... 
loathe 
its 
project 
the 
is 
to 
finish 
up 
when 
to 
be 

Forecasted finish date using partially completed task info

Posted: 03 Aug 2004 12:07 PM PDT

Thanks Gérard!
 
status date 
dans le message de 
of 
the 
by 
 

Wrong year shows on 'Print Preview'

Posted: 03 Aug 2004 09:08 AM PDT

Sandy,

When you're in Print Preview, click Print and the Print dialog box
opens. In the Timescale section, select the dates that you want to
appear in the timescale portion of the print out.

Sarah
sarah_kiko@(removethis)cinfin.com

Filter

Posted: 03 Aug 2004 07:41 AM PDT

Hello John,
Of course ! You are right !
Sorry for my poor English, I'm tired... I'm going on holidays tomorrow.
Thanks for the correction

Gérard

"John" <com> a écrit dans le message de
news:microsoft.com... 

Resource entries

Posted: 03 Aug 2004 07:25 AM PDT

Why not? Perhaps you are attempting to enter them as materials, which they
are not. In fact, you're looking at the classic definition of an equipment
resource, which Project treats in the same manner as a human work resource.
Enter 1500W Spotlight in your resource list, set its type to "work", its
maximum availability as the number of units you have or are renting (if you
have 5 units its availability is 500%, for example) and its standard rate as
the rental charge. Any equipment that is in limited supply, whose cost must
be budgeted, and whose availability will affect the schedule is a candidate
for this treatment. You probably should list the cameras, for example, but
not the crew's hammers.

Material resources are consumables used up during the task they're allocated
to - it sounds like you're in the film/video industry and film, video tape,
disposable batteries, electricity, gaffer's tape, and fuel for the
generators would be examples of materials you might track in the project
plan.

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


"Maurice Newsome" <microsoft.com> wrote in message
news:ab6101c47965$c7e30be0$gbl... 

Using Project files over a WAN

Posted: 03 Aug 2004 05:45 AM PDT

If there are links from the file to files that reside elsewhere and
accessible via WAN, I can see how there may be an issue. Project needs
to "communicate" with those files to display them in the links. Another
thing to look at ... does the user have access permissions to those
linked files? Look also at the full path of the linked file to see if
they are specified as a drive letter, e.g. K:\project\abc\def.mpp vs.
\\fileserver\share\abc\def.mpp where there is inconsistent mapping of
drive letters between the users.

Still best to use a terminal server rather than WAN for remote access to
Project files... Possible you can migrate this direction?

Hope this is useful to you. Let us know.

rms




dalbee wrote: 

Baseline Finish - test for null

Posted: 03 Aug 2004 01:58 AM PDT

For some odd reason Project stores a value of 2^32 - 1 (4294967295) in
fields which are blank or NA. Perhaps the value is actually -1 and it rolls
over? Anyway, regardless of why they do this the solution is simple, use an
iif statement and test for a large number.

Here is an example which you could use in a customized text field:

iif([baseline finish] > 500000, "no baseline", "whatever you want it to do
if it is not blank")

-Jack

"com" <microsoft.com> wrote in message
news:a0ab01c47938$00d6e7b0$gbl... 

Importing Resources From Excel to Tasks in Project 2003

Posted: 03 Aug 2004 12:23 AM PDT

Hi KLR

SORRY - (hangs head - feeling very red faced)

and it was as clear as anything in your original post .. will see what i can
come up with.

Hopefully others are still reading this thread and might have an idea - or
my responding might have stuffed up this thread so you might like to post
again.

1000 apologies.

JulieD





--snip -- 
no 
the 
Am 
or 
will 
work 
Hours(Work) 
resources 
success. 
resource 

Find Dates/Days in various MS applications

Posted: 02 Aug 2004 05:04 PM PDT

I'm with Julie. Excel is simple for this sort of date math. Project is less
so.

-Jack


"JulieD" <net.au> wrote in message
news:phx.gbl... 
can 
"ddd" 

Adjusting Hours Globally

Posted: 02 Aug 2004 02:11 PM PDT

use primavera 
development work. I'd like to add an X factor (%) to the
number of hours given me to more accurately reflect the
real world time that this project will take. 

Issues and Risks

Posted: 02 Aug 2004 02:11 PM PDT

What do you mean by "place the names of the plans into project schedule"
???? Are you using the term "plans" to refer to individual tasks in a
single project schedule or are you talking about a number of different
project schedules (ie, project plans) being incorporated into a master
project schedule as inserted projects?

You might post your question in the Server group as that's where most of the
Server/PWA gurus hang out.

As a sidenote, in my experience trying to cut corners by inventing a better
way to do something than the designers of the program came up with usually
ends up costing far more time and money in the long run than doing it the
proper way from the start. At some point you almost always have to scrap
everything you're done and go back and do it all over again "by-the-book."
If you're really really lucky that happens fairly early before you've wasted
too much time and money. Kluging together a short-cut workaround as the
"quickest solution to an immediate need" is usually the most time consuming
and costly approach in the long run.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"Andrea" <microsoft.com> wrote in message
news:9ad601c478d5$37680e70$gbl... 

project 98 converter

Posted: 02 Aug 2004 01:18 PM PDT

Sorry, there is no converter available. At one point, there was a plan to have this converter, but sadly there isn't and probably not a plan to make one. Users will have to save to a P98 format from a newer version, which may not be what you want, but is your only option

"Pat" wrote:
 

Unexpected changes in % complete column for summary

Posted: 02 Aug 2004 12:57 PM PDT


Angela,
No crash with my macro either but I have to agree with Jack, if you (or
your management) is trying to manage a single Project file with 13K+
tasks, you've already lost the war. The most I have worked with is a 10K
file and that was a master file made up of 70+ individual subprojects.
Working with that large a file wasn't easy and I have a ton of
experience.

Nonetheless, I gotta believe that the problem you are seeing can be
replicated with a very small portion of the huge file. Did you try
copying just the Summary line that shows the problem along with its
subtasks and paste it into a new file?

John

pre-release evaluation file issues

Posted: 02 Aug 2004 12:34 PM PDT

Jeb --

You didn't happen to get this file from a CD that accompanied a book on
Microsoft Project, did you? I ran into this error when I created sample
files while writing a couple of chapters in the "Special Edition: Using
Microsoft Project 2002" book from Que. The error indicates that the file
was created using an early beta version of Microsoft Project. If you got
the file from a book, you may want to contact either the publisher or the
author of the book for an updated file. Otherwise, if this is not the
reason for the error, please let us know.

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


"Jeb" <net> wrote in message
news:101d01c478c7$b3bb7b50$gbl... 

Same task across all resources.

Posted: 02 Aug 2004 11:27 AM PDT

This is how you would assign it to all resources, however, it will not show
up as a single task for each resource.
It is either one task or many tasks. It can't be both. You have to decide
which way is best for you.
An assignment view (such as resource usage) WILL show it as individual
assignments, but that is as close as you can get.

-Jack


"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message
news:phx.gbl... 
resources 
This 
simply 
would 
doesn't 
for 
because 

Project, Excel and VBA

Posted: 02 Aug 2004 11:12 AM PDT

That's all. I got things to work in the end. I had to make
the Excel application visible for the dialog box to appear.

Thanks anyway
 
group. 
project.server 
and Project VBA 
message 

Cannot add any activities to schedule

Posted: 02 Aug 2004 11:04 AM PDT

Judy,
My first guess would be a memory issue.
Dave

"Judy" <microsoft.com> wrote in message news:<98be01c478bb$1e2b05d0$gbl>... 

Colouring in Gantt Chart

Posted: 02 Aug 2004 06:09 AM PDT

use primavera 
of 
to 
drawing 
down 

Outlook Connectivity

Posted: 02 Aug 2004 03:35 AM PDT

It doesn't happen automatically as Project out-of-the-box is unaware of
Outplook and vice versa, but you can get them to interact. You need to
install the Workgroup add-in for Outlook, WGSETUP.EXE, on the project
manager's workstation and on all the resources computers as well. You don't
mention which version of Project you're using. If it's 2000 search the
distribution CD for the file and the setup instructions. If it's 2002/2003
it's a little more complicated as MS is withdrawing support from the
Workgroup tools and steering people in the direction of Project Server but
for now it is still available. You'll need to download WGSETUP from the MS
web site and also do some registry tweaks on the PM's machine to make the
workgroup tools available. You can find the details at

http://support.microsoft.com/default.aspx?kbid=818337


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


"Amirali Pourteymour" <microsoft.com> wrote
in message news:com... 
Resource's outlook task view? Any suggestion will be highly appreciated. 

Entering Reserve (buffer) time

Posted: 01 Aug 2004 08:29 PM PDT

Before you go adding a buffer to each individual task, I'd like to
offer an alternative.
First, the reasons I prefer not to buffer each task. In my experience,
both "in the field" and by asking in the classroom for 13 yrs, when
you add buffer to each task, no matter how you determine the amount of
buffer, the resources, normally under pressure to get many things done
in little time, will start on the latest date they can start and still
finish on time. In other words, if I buffer a 10 day task by adding 3
days, most resources will start work on day 4, figuring they'll finish
by day 13. The buffer is thrown away. The only result is that the
planned duration is longer than neccessary. Any unexpected problems
only add to the 13 day duration, because the resource didn't start day
1.
I've tried to keep 2 schedules, one I published and one I kept secret,
the secret one showing the buffer. Always backfires somehow, when
you're sneaky!
What I learned to do years ago is to add a task at the end of the
project containing all the buffer or contingency time. Then, after
explaining why, you entreat your resources to finish on schedule, and
to try not to use up the buffer. This also is a very good team
building tool, if you handle it well. I've had much greater success
finishing projects on time since I started doing this rather than
padding individual tasks.
Hope it helps you, or someone, out.

David G. Bellamy
Bellamy Consulting

"Gérard Ducouret" <wanadoo.fr> wrote in message news:<e5d#phx.gbl>...