| 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>...
|
