Filter / Analysis Timescale Data in Excel Microsoft Project |
- Filter / Analysis Timescale Data in Excel
- Non-calendar gantt chart?
- Change duration units to days?
- Default Font Settings
- ANOTHER RUBBISH FROM MICROSOFT -> MS PROJECT 2003 PRO
- Clearly Showing Dependent Tasks
- Combining project calendars
- Product Comparison / Feature Review
- Percentage
- Project - Invalid Critical Path
- Collaboration for the little Guy - Project 2003
- MS link for a converter for MS Project 2003 templates
- do u know any free viewer for MS Project?
- Actual work vs Percent Complete
- Collaboration under MS Project Standard 2002
- Custom Filter: two Resources and Start-Date
| 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 |
| 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 |
| 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... |
| 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: |
| 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 |
| You are subscribed to email updates from TextNData Forums - Microsoft Project To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
