Pages

Search

Filter / Analysis Timescale Data in Excel Microsoft Project

Filter / Analysis Timescale Data in Excel Microsoft Project

Filter / Analysis Timescale Data in Excel

Posted: 20 Apr 2004 02:41 AM PDT

Hi Gerard

Thanks for responding, hope your well.

At present moment I have two projects but this will be expanding as more similar projects come on board. Moreover, my filter would remove the start and end tasks because there are no cost associated with them

If I have a master plan with 12 embedded projects what would be the best method. I have setup my project plan on an individual level, and am not realising I should have been considerate :-

Cheers - Vers

Non-calendar gantt chart?

Posted: 19 Apr 2004 03:55 PM PDT

The Gantt chart is a work schedule - do you schedule crews by linear feet?

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

"Anne" <microsoft.com> wrote in message
news:147101c42661$65100b50$gbl... 

Change duration units to days?

Posted: 19 Apr 2004 11:21 AM PDT

Hello,
To change the duration unit of all the tasks already entered, use the
Format_Duration VBA procedure:
Tools / Macro / Macros... / Format_Duration / Run

Gérard Ducouret

"Mike Glen" <glenATmvps.org> a écrit dans le message de
news:phx.gbl... 
at 

Default Font Settings

Posted: 19 Apr 2004 09:56 AM PDT

Thanks Rob and Gerard. Both Solutions work perfectly. I
was not familiar with the location and settings as it is
with Word or Excel.

Thanks again for your help 

ANOTHER RUBBISH FROM MICROSOFT -> MS PROJECT 2003 PRO

Posted: 19 Apr 2004 08:20 AM PDT

See embedded...

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


"MacLukas" <com> wrote in message
news:google.com... 

You can hyperlink to open another project file but you are correct, you
can't hyperlink to a specific bookmarked task in the other file. That being
said I'm not sure why you NEED to jump to a specific task in the target
file. If the WBS is done properly, each file is an integrated whole,
complete in itself. You can have external dependencies where a task in
Project A is linked either as a predecessor or successor to a task in
Project B. Won't using inserted projects and/or external dependencies
accomplish what you need? If you have a consolidation file you can always
expend each inserted project to see its detail or collapse it to hid the
detail.
 

From the menu, Insert Project

 

Gee, my wheel mouse has an adjustable scroll rate. And the scroll bar on
the right has a tool tip box that shows the task and ID I've scrolled to. 
that? 

You HAVE a user manual. It's called the online help and is installed with
the product. In my experience, the online help files are far more detailed
and far easier to navigate and find relevant information in than the
old-fashioned paper manuals were back in the 80's which were largely lists
of what button to push. Granted, you may need to disable that silly Office
Assistant but once you do you have the full manual right at your fingertips.
What it doesn't do is teach you Project Management but then a word processor
manual doesn't teach you to be a professional writer nor a spreadsheet's
manual teach you accounting theory and practices either. MS Project rightly
assumes you already know and practice formal project management as via
Critical Path and/or PERT methodolgies and as outlined in the PMBOK which is
the ANSI standard documentation of professional PM practices in North
America.
 


 

Clearly Showing Dependent Tasks

Posted: 19 Apr 2004 08:09 AM PDT

This is a deficiency in both Microsoft's Gantt chart and Network Diagram.
Lines overlap and you can't follow them. There is no fix except to perhaps
move tasks around. This is why I use an add-on to Project called PERT chart
expert from www.criticaltools.com. It's the only way I know to separate the
dependency lines so I can follow them.


"Michael" <microsoft.com> wrote in message
news:0f3701c42620$54715920$gbl... 

Combining project calendars

Posted: 18 Apr 2004 12:49 PM PDT

Tom:

Open all 5 projects, select Window, New Window. Then
select all the files and choose Calendar view in the drop
down box.

Hope this helps!

----------------------
Sean Pales
EPM Solutions Group
Bennett Adelson
www.bennettadelson.com
 
work 
all 
but 

Product Comparison / Feature Review

Posted: 18 Apr 2004 10:02 AM PDT

Hi CSK,

Welcome to this Microsoft Project newsgroup

You could make a start in FAQ Item: 47. Project 2003 Books and References

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

CSK wrote: 

Percentage

Posted: 18 Apr 2004 03:39 AM PDT

Saving a baseline before starting to post in the progress will give you what
you need. Project compares schedule against baseline and can give you
variance information although not the % complete you should be at directly.
What your boss seems to really want is one of the aspects of Earned Value
analysis which Project can readily give you by simply displaying the
appropriate table. Unfortunately, it presumes resources are assigned
because it uses work and not duration as its measure and work doesn't exist
without a resource to perform it. What you can do is create some generic
resources with a cost of $1 and assign them to the tasks. The earned value
is the budgeted cost of work that actually was performed by a designated
status date compared to the budgeted cost of the work that should have been
performed to that date and uses the dollar value of the work in its
calculation. BCWP/BCWS =SPI, schedule performance index - if it's 1 you're
on track, <1 if you're running late, > 1 if you're ahead of schedule. BCWP
comes from the % complete progress you've posted and BCWS comes from the
work and cost data saved in the baseline.

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



"David Moss" <microsoft.com> wrote in message
news:083801c42531$774803d0$gbl... 

Project - Invalid Critical Path

Posted: 17 Apr 2004 06:14 PM PDT

Thanks very much. I think my problem is just that tasks
that form the longest path through the project do have
some slack around them. As such they are not
really 'critical path'.

Thanks again,

Alison 
deadlines, etc, they 
you shouldn't use 
course. It's 
the middle of the 
week long. A 
around the 15th of 
facility that 
start no ealier than" 
constraint. Even 
May 1. So that means 
they start to push 
delay will delay 
period of time 
critical and the 
so that they finish 
chart 
Earlier 
98. 
but 

Collaboration for the little Guy - Project 2003

Posted: 17 Apr 2004 11:04 AM PDT

Per this
http://www.microsoft.com/downloads/details.aspx?FamilyID=6382c615-1090-452c-8eba-4025b8976c18&displaylang=en,
you have the ability to add the "Workgroup Message Handler" into 2003,
but it's pretty clear this last version that Microsoft plans to support
this.

If the resources know how to use Project (and sometimes Resources
don't), then by organising the mpp files into logical groups of
individual files, one resource file, collecting them into master
projects ... each Resource updates the relevant project file and the PM
works with the conslidations. I'm suggesting breaking them up simply to
enable people to work on different files at the same time. This
requires shared files on a file server, of course.

Hope this is useful to you. Let us know.

rms




microsoft.com wrote: 

MS link for a converter for MS Project 2003 templates

Posted: 17 Apr 2004 04:57 AM PDT

You don't really need a converter if you have access to Project 2000 or
later. Just open the template in Project 2000 or later and save it as a
Project 98 file, then open in 98 and save it as a template. Round about,
but it works. Of course Rob's advice is the best - there always comes a
time when you must put aside favourite things and move on. Proj 98 is 7
year old technology now, well into its dotage. Time to upgrade.


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


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

do u know any free viewer for MS Project?

Posted: 16 Apr 2004 07:13 PM PDT

Hi,
 

a customer of me tested some viewers, all of them had their
(in)capabilities.
Now he installed ProjectCentral to use it as viewer and is happy. Within a
local network not that bad.

regards
Sascha


**************************************
Sascha Wald
Software-Development and Project-Management
www.adminsoft.info
**************************************

Actual work vs Percent Complete

Posted: 16 Apr 2004 09:30 AM PDT

JD --

Adjust the Remaining Work value for the task to 0 hours. This will mark the
task as 100% complete automatically. Hope this helps.

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


"JD" <com> wrote in message
news:%phx.gbl... 
20 - 
hours 

Collaboration under MS Project Standard 2002

Posted: 15 Apr 2004 11:03 PM PDT

I coincidently ran into this link when cleaning bookmarks today:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6382c615-1090-452c-8eba-4025b8976c18&displaylang=en

Hope this is useful to you. Let us know.

rms




Steve House wrote: 

Custom Filter: two Resources and Start-Date

Posted: 14 Apr 2004 11:26 PM PDT

Salut Gérard,

"Gérard Ducouret" <fr> schrieb im Newsbeitrag
news:phx.gbl... 
it 

Unfortunately I still don't understand th Or-And-priority, but that is
something I will do researches on.
I tested your filter and it worked, thank you. AND: there is automatically a
drop-down-list for Resources and a calendar for the date-field!!!

Thank You

Sascha