Actual Hours and percent complete Microsoft Project |
- Actual Hours and percent complete
- resource views/printing limits
- Marking milestone as complete in PWA
- Showing the effect of progress after the Status Date
- Server vs Central
- Pusing global.mpt changes out to projects
- Require multiple resources to work at same time
- Weighting resource loading based on project probability?
- Show link to your notes. You tell what can be done but don't show
- Recurring task groups
- Adding a delay / lag in an activity that has started
- Setup question, hours per week on a task
- How do I distribute a schedule picture (no editing)?
- Time Constraint Symbol on every task ...
- Determine Outline Level in Project using Visual Basic
- Can Project put cashflow report to Excel, months in column?
- Viewing resource availability
- Merging two project files... ??
- How do I apply material cost as a fixed value per week?
- Project 2003 Viewing Multiple Resource Calendars
- Sharing Projects
- Project Compare Tool
- Display hours with start/finish dates in Task Sheet
- Report of Deadlines in Calendar View
- Assigning Multiple Tasks to One Dependant Task
Actual Hours and percent complete Posted: 18 Oct 2005 08:25 AM PDT In article <com>, "% Complete vs Actual Work" <microsoft.com> wrote: complete, Just as an adjunct to Julie's response, consider this. When a plan is created Duration, Work and other fields are entered (or calculated by Project) as estimated values (regardless of whether the "?" is shown on the Duration). When a task is completed, the actual values describe what really happened. Therefore the original estimated values are no longer valid and Project overwrites them to agree with the actual values. That's why the baseline fields exist - to capture the original estimates for later comparison. John Project MVP |
resource views/printing limits Posted: 18 Oct 2005 07:45 AM PDT Hi Mikejw, As you have discovered, the display of the [Resource Names] field is limited to 256 characters. Not knowing how you created the list of resources, I can only offer the suggestion of adding the [Resource Initials] field to the table as an alternative. You may need to edit the resource initials in the resource sheet to make them more meaningful (Project by default only picks up the first letter of the first word you enter). Hope this helps. Let us know how you get along. Julie "mikejw" <microsoft.com> wrote in message news:com... |
Marking milestone as complete in PWA Posted: 18 Oct 2005 12:56 AM PDT Thanks for your prompt reply. I realised to late there is a seperate Project Server group, sorry for that! A pity there is no way to mark a milestone as complete other then to allocate some amount. Thanks for answering my question. "Dale Howard [MVP]" wrote: |
Showing the effect of progress after the Status Date Posted: 17 Oct 2005 06:36 PM PDT That's great, thanks for the help. I had worked out a way using modifed fields and excel but this is obviously far easier. "pratta" wrote: |
Posted: 17 Oct 2005 02:41 PM PDT In article <com>, microsoft.com says... Hi Sarah, Here's the version list: Microsoft Project Central (v.1) Microsoft Project Server 2002 (v.2) Microsoft Office Project Server 2003 (v.3) Project Central and Project Server 2003 are very very different products. In fact you can't buy Project Central anymore. You might want to check out the following webcast: Support WebCast: New features and benefits in Microsoft Office Project Server 2003 http://support.microsoft.com/default.aspx?scid=kb;en-us;835299 Good Luck -- Rolly Perreaux, PMP Project Server Trainer/Consultant IT Summit Series Advanced Microsoft Technology Training http://www.itsummitseries.com |
Pusing global.mpt changes out to projects Posted: 17 Oct 2005 01:07 PM PDT In article <e8n$phx.gbl>, "Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote: Jan, Actually the Auto_Open was doented but you probably won't find it unless you look back to Project 98. It has since been replaced by the Open Event. It was actually the Auto_Open that I was referring to in my post (as I said, it was several years ago). John |
Require multiple resources to work at same time Posted: 17 Oct 2005 11:18 AM PDT Hi Justin, You're welcome for any and all support/assistance I can offer. In a post to this newsgroup titled "10/05/2005" John Sitka and Steve House [Project MVP] posted some very insightful comments about MS Project being a "tool in support of a thought process". MS Project is merely a piece of software, the skills and knowledge that you bring to the table will never, in my opinion, be replaced. Yes, Project does "schedule", but only based upon the information (tasks, resources, priorities) you provide. Hope this helps. Julie "WhyIsEverythingSoConfusing" <com> wrote in message news:com... |
Weighting resource loading based on project probability? Posted: 17 Oct 2005 09:59 AM PDT In article <com>, andylv <microsoft.com> wrote: Andy, Ok, so what about my comment in my second paragraph? In other words, what's the resource allocating algorithm that you want to use? But in my mind, twenty five percent allocation for 25% probability projects and 100% allocation for "sure thing" projects just doesn't fly. Thinking about it for a while, the idea of directly tying resource allocation to project probability seems like a bad idea. But here's something that might work and it does at least make sense. Clearly the sure thing project needs to be fully loaded with resources. What I might do for projects that are iffy is something like the following. If a project is 75% likely, lay out a plan that has all the critical elements covered (i.e. basically leave out the detail). Then load that project with resources to ensure the critical tasks are covered. For the project that is 50% likely, lay out a plan to cover the startup critical items. For a one year project maybe that's the first 3 months worth. Then load that plan. For the 25% project, identify the most critical tasks to get started, maybe equivalent to the first month's effort. When all the projects are loaded, sum up the required resources and then multiply by 1.25 (assumes 80% efficiency for all resources). At least that might be an approach I would take. If you or somebody else has a better one, let's hear it. John Project MVP |
Show link to your notes. You tell what can be done but don't show Posted: 17 Oct 2005 09:14 AM PDT Hi Ian, You're welcome and thanks for the feedback. Yes, the site is an invaluable resource. Julie "ianpooley" <microsoft.com> wrote in message news:com... |
Posted: 17 Oct 2005 09:00 AM PDT Well. That certainly is easier (wow, I must be especially slow today). Changes/additions to the recurring tasks is easier with that implementation too. Thank you! -------------- Justin "Jan De Messemaeker" wrote: |
Adding a delay / lag in an activity that has started Posted: 17 Oct 2005 08:46 AM PDT Thanks dwolf... appreciate the help! "dwolf" wrote: |
Setup question, hours per week on a task Posted: 17 Oct 2005 08:42 AM PDT Duration is the time from when the task starts until it finishes without regard to whether work is continuous or not. Duration also only counts working days and non-working time is ignored. If the task extends for 4 work weeks, say the whole month of November in round numbers, that represents a duration of 20 days. (Each 7 days on the wall calendar gives you 5 days of duration since the weekend days off don't count.) Assuming your resources work 40 hours per week, 5 hours per week represents a 5/40 or 1/8 of their total avaiable work time. This is the equivalent of a 12.5% assignment level. So making the task a 20-day duration task and assigning each resource at 12% results in 5 hours per week for a total of 20 man-hours of work per resource with the task beginning Nov 01 and extending about to Dec 01 (minus a couple of days). That has them each doing 5 hours per week and its up to them how to work it around their other 35 hours of activities - it's not our job to micromanage their workday minute by minute. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "WhyIsEverythingSoConfusing" <com> wrote in message news:com... |
How do I distribute a schedule picture (no editing)? Posted: 17 Oct 2005 08:26 AM PDT Hello, Have a look at the FAQ # 16 : Project viewer http://project.mvps.org/faqs.htm Gérard Ducouret "SGW" <microsoft.com> a écrit dans le message de news:com... |
Time Constraint Symbol on every task ... Posted: 17 Oct 2005 07:36 AM PDT OK :-)) ! -- Jan De Messemaeker Microsoft Project MVP +32 495 300 620 http://users.online.be/prom-ade "Greggy" <com> wrote in message news:GRS4f.3112$cgocable.net... |
Determine Outline Level in Project using Visual Basic Posted: 17 Oct 2005 06:52 AM PDT In article <com>, "Walter L. skinner" <microsoft.com> wrote: Walt, Gerard's suggestion will certainly work if you are using foreground processing. In your previous post we didn't explicitly discuss foreground versus background processing, but background processing is generally always the better approach - faster and more efficient. Background processing simply means that the code is working directly with Project objects regardless of which view is active. Foreground processing operates by selecting objects in the current view. However, some of Project's objects can only be operated on in foreground processing (e.g. font characteristics). A basic (no pun intended) VBA loop to cycle through all tasks in a file is as follows. I have included the syntax for determining the Outline Number. For Each t in ActiveProject.Tasks If Not t is Nothing Then OL = t.OutlineNumber [your code here to p the task name info] End If Next t Hope this helps. John Project MVP |
Can Project put cashflow report to Excel, months in column? Posted: 17 Oct 2005 04:46 AM PDT Hi Phillip, Glad to have helped and thanks for the feedback. Julie "phillipd" <microsoft.com> wrote in message news:com... |
Posted: 17 Oct 2005 04:07 AM PDT Hi WSH, You're welcome and thanks for the feedback. Glad to know the resource graph shows what you were looking for. Julie "WSH" <microsoft.com> wrote in message news:com... |
Merging two project files... ?? Posted: 17 Oct 2005 03:11 AM PDT Hi Jan, Yes, I agree that they should have been in the one file. I am enquiring about this on the behalf of a client... So I hear you confirming what I have suspected (after looking right through most of the features in MS Project)... that there is no simple way to go about this. That a VBA routine might be the only way to automate it. Hmmm... The actual tasks also very between files. For instance... there might be: [PLANNED FILE] 1. Site X 1.1 Site X - Section 1 1.1.1 TASK Z (Summary Line) 1.1.1.1 Task Z 1.1.1.2 Task Z 1.1.1.3 Task Z 1.1.1.4 Task Z 1.1.2 TASK W 1.1.2.1 Task W 1.1.2.2 Task W 1.2 Site X - Section 2 etc [ACTUAL FILE] 1. Site X 1.1 Site X - Section 1 1.1.1 TASK Z (SUMMARY) 1.1.1.1 Task Z 1.1.1.2 Task Z 1.1.2 TASK W (Summary line) 1.1.2.1 Task W 1.1.2.2 Task W 1.1.2.3 Task W 1.1.2.4 Task W 1.1.3 TASK T (Summary Line) 1.1.3.1 Task T 1.1.3.2 Task T 1.2 Site X - Section 2 etc As you can see... at outline level 1 - 3 there is the same structure. But then at outline level 4 (the actual tasks with start/finish dates etc) things start to differ. There might even be a task in Actual under say 1.1 that doesn't exist on the PLANNED (Task T for instance in the above example). My VBA is not adequate to do something like this so I think I will get back to the client and suggest they go about it another way. Thanks for the help... Jonathan "Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message news:phx.gbl... data to Gantt procedure in the could software plan. that instances automated) to baseline, current manually... uncommon before ---------------------------------------- I am using the free version of SPAMfighter for private users. It has removed 266 spam emails to date. Paying users do not have this message in their emails. Try www.SPAMfighter.com for free now! |
How do I apply material cost as a fixed value per week? Posted: 14 Oct 2005 03:16 PM PDT In article <com>, AncientRebel <microsoft.com> wrote: Mike, You have to remember that Project is a scheduling tool not a Project Manager. Most schedules are volatile, some more than others. Those that do change a lot will require the Project Manager to spend a fair amount of time updating and maintaining the plan. Project will do all the calculating but it is only going to respond to the information it is given - it can't do your work for you. However, in some cases, special processing can be used to help automate custom functionality but that processing requires the use of one of Project's advanced features, namely, VBA. It is possible there are other ways to do what you need (other than using VBA), but we would need more details. I find that quite often a user will post a question based on HOW they are trying to do something when a much better approach would be to describe WHAT they are trying to accomplish, with sufficient details for background. That allows us much more freedom to suggest the best method. With regard to setting a rate and letting Project timescale the cost, that is exactly what my second suggestion does. Did I miss something? Lastly, if by "Mac Project" you mean Project for the MacIntosh, the last version of Project released for Mac was several years ago (version 4.x) and it lacks some of the built-in functionality you are seeking. Hope this helps. John Project MVP (and Mac user) |
Project 2003 Viewing Multiple Resource Calendars Posted: 14 Oct 2005 02:19 PM PDT Hi, I wrote a VBA procedure showing absence periods as tasks in a Gantt Chart: it is on my Website ("Abstract in English") It is (too) complex as I wanted to cover a maximum of cases, still it may inspire anybody who wants to write such a macro. The basic principle is that you look for days where the property calendar.period(theday).working is true for the project calendar and false for the resource calendar. Hoiep this helps, -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "Gérard Ducouret" <fr> schreef in bericht news:#iohU#phx.gbl... to |
Posted: 14 Oct 2005 10:41 AM PDT Hi Steph, Julie is right, unless you are looking for a way to have seaparate people updating different parts of the project. If that is tha case then you can do it by inserting (consolidating) several project files into a master file. // Lars "Steph" <microsoft.com> wrote in message news:com... |
Posted: 14 Oct 2005 08:25 AM PDT In article <phx.gbl>, "Jonathan E. \(NZ\)" <comTAKEOUTTHESECAPS> wrote: Jonathan, Thanks for the info. Whenever I run VBA I don't try to do other operations on the PC. At best, it diverts processor time from the running code and at worst, can cause a hang, as you experienced. In the case of the Project Compare utility I'm guessing it hangs because there are parts of the utility's code that appear to run in foreground processing, and that requires the focus to be the active view. John Project MVP |
Display hours with start/finish dates in Task Sheet Posted: 14 Oct 2005 07:07 AM PDT Hello, Not sure if this is what you want, try this: On MS Pro, go to Tools>Options>Date Format (drop down list), choose a date with the time on it. It will show what time the task will start and finish. "lpspass" wrote: |
Report of Deadlines in Calendar View Posted: 14 Oct 2005 06:51 AM PDT Don't apply the dealine on the task itself, but on a milestone which is following it whith a FS link. You could add a "Start No Earlier Than" (Oct 7th) constraint on this milestone. Then apply your filter. Gérard Ducouret "tmcfarla" <microsoft.com> a écrit dans le message de news:com... suppose a Oct is |
Assigning Multiple Tasks to One Dependant Task Posted: 14 Oct 2005 06:42 AM PDT Sorry for my unclear explanation, I wanted to say that you can't do that with a multiple selection and a click on the "Link Tasks" button. If a task has several predecessors, you can list them in the "Predecessors" field (separated by you list separator). If another task has the same list of predecessors, you can copy/paste that list. In the reverse order, if a task has several successors, you can enter them in its "Successors" field. If another task has the same list of successors, you can copy/paste that list. Gérard Ducouret |
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., 1600 Amphitheatre Parkway, Mountain View, CA 94043, United States |