The controls for Microsoft Project Web Access could not be downloaded correctly. Microsoft Project |
- The controls for Microsoft Project Web Access could not be downloaded correctly.
- Project tasks with no apparent dependencies
- How can I print a resource to do list
- Inputting Costs
- how do i get a resources sorted on assignment tab in project 2000
- Easy Way to Display Non-Working Time
- percentage time resources spent on project
- text inside a gannt bar
- Best resource assignment
- Popup warning indicators when in Tracking Gantt mode
- I am having problems outdenting a task in MS Project
- Tracking/Comparing Monthly Progress
- Unable to split a task
- Is is better to categorize by task or job function?
- resources management
| The controls for Microsoft Project Web Access could not be downloaded correctly. Posted: 21 Aug 2005 05:43 AM PDT You're welcome, Asser :-) Mike Glen MS Project MVP Asser Maany wrote: |
| Project tasks with no apparent dependencies Posted: 19 Aug 2005 09:26 PM PDT >For example lets take a testing cash task (summary task) and a At the level of detail you desire These are not tasks, so don't refer to them as such. "Summary Duration of a Task Set" is what they should be called. There is a behaviour of the GUI act of leveling that you should be aware of, It involves splitting the screen so you have a RESOURCE view in one of the windows. When a resource view is the active window the act of levelling resources can become more granular as you can select to level only one or a few resources and not the whole project. I believe this maybe overlooked and if so it would cause frustration as whole plans "Explode" before your eyes. Not that the explosion is incorrect. Just that it can be too much to handle at once. Step through a mocked up course of events that the assignments (resource/task pair) you mention might go through, consider how you will time the recording of progress and task switching for that resource. Keep asking yourself what is really going on and what you can "KNOW" for certain about the contributing effort of that resource within the recording of progress and task switching. Consider the timing of when the you become in the "KNOW" as well. Once you reach the limit of frequency of gathering detail that is theoretically possible, abstract the contribution of that resource to a generalization that fits what you can actually rely upon, enforce or fit into a routine of Project Management. Then once comfortable with your measurement/update frequency pattern, level away. Not sure what you mean, Don't link to summary tasks, create a task called management review assign your manager as a resource and make it a successor to the last task contained IN the Summary task. Or if review is to occur after both cash and inventory are complete then create two links to last task contained IN the Summary tasks. Then "addressing review" tasks are dependent on the managers completion. I think this is an important point. There is a wholesale handoff in responsibility here, lots of waste or efficiencies can happen at these junctions, they need to be specific. Maybe call all the reviewing tasks something like "Review_<some other designation>" custom filter on "Review_%" then you could show give your managers a combined schedule. Showing when they will be called to perform reviews and depending on the known business behavior may be a good estimate. Record actual progress for them too to see the damage any delayed reviews are causing. ;-) . "Mike Glen" <glenATmvps.org> wrote in message news:%phx.gbl... |
| How can I print a resource to do list Posted: 19 Aug 2005 01:03 PM PDT Thank you for the reply. However, I don't want to use a report, I just want to print the Resource Usage view. I don't know if there is a setting that is preventing me from printing it? Seems odd that I'm unable to do it. "PlanetCon" wrote: |
| Posted: 19 Aug 2005 12:46 PM PDT If I understand correctly, you pay resource A NOT by day rate, but fix sum on approval of task completed. So deposite is one activity or milestone, fix sum payable at completion. Resource A is within one ACTIVITY, with fix sum payable "at end" "Treisa" wrote: |
| how do i get a resources sorted on assignment tab in project 2000 Posted: 19 Aug 2005 12:24 PM PDT You are a life saver (time saver in this case :)), Thank you very much. . . Gary (PlanetCon) "Jan De Messemaeker" wrote: |
| Easy Way to Display Non-Working Time Posted: 19 Aug 2005 11:57 AM PDT Tim, I've got a VBA module that I wrote (for Project 2000, so the objects would need updating) that exports out of office time to a calendar-type report in Excel. If you would be interested in this code, let me know (kikos1 AT nationwide DOT com). You would need to do some modifications to it, so hopefully you're familiar with VBA, or someone else there is. Sarah |
| percentage time resources spent on project Posted: 19 Aug 2005 11:55 AM PDT In article <phx.gbl>, "msnews.microsoft.com" <com> wrote: I wondered why half the flowers in the garden were dead ;-) "Average" work is somewhat open to interpretation. First, an average implies the amount of work at a point in time (i.e. over a fixed set of samples). Second, is the intent to look at average work planned or average work accomplished (i.e. estimated Work versus Actual Work)? Assuming you are interested in estimated Work at project completion, then the first formula you presented in the original post should give the answer. At any other point in time, Cumulative Work would need to be substituted into the formula. Although the basic formula is simple enough it becomes a little more complicated because it requires data from two different parts of the Project database. Total (or cumulative) Work for the project is a task based field while total (or cumulative) Work for a resource is a resource based field. To get the end result to appear on a resource based view (e.g. Resource Sheet or Resource Usage view) a translation of data is needed. If the project's total work remains constant (not likely in the real world), a fixed value can be used in a custom field formula on the Resource Sheet. However, in the more realistic case where the total project work is dynamic, VBA will be necessary to "pull" the project work value into the formula for entering the result onto the Resource Sheet. Not a big deal, the following macro will do it. (Note: the result is placed into spare Text1 field of the Resource Sheet) Sub AveResUsage() For Each R In ActiveProject.Resources If Not R Is Nothing Then R.Text1 = Format(R.Work / ActiveProject.ProjectSummaryTask.Work, "##.0%") End If Next R End Sub If the average at a point in time is desired, the macro code needs to be changed to pull timescaled data. Similarly if actual work values are desired, the appropriate data must be used. Hope this helps. John Project MVP |
| Posted: 19 Aug 2005 10:25 AM PDT ooooooops - I missed that one - sorry Pete :( Mike Glen Project MVP Jan De Messemaeker wrote: |
| Posted: 19 Aug 2005 07:13 AM PDT Just a reminder to level "Priority,Standard" as otherwise your priorities might not be taken into account sufficiently. Mike Glen Project MVP Steve House [Project MVP] wrote: |
| Popup warning indicators when in Tracking Gantt mode Posted: 18 Aug 2005 09:36 PM PDT That kind of automatic warning won't pop up but you could probably write some visual basic to do it. The problem is Project doesn't really know much about the current date and what needs to be done by it. If you display the earned value tables you can get inications such as your looking for but it still won't be an automatic popup. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "Andy" <microsoft.com> wrote in message news:com... |
| I am having problems outdenting a task in MS Project Posted: 18 Aug 2005 06:16 PM PDT This is a known bug in Project 2003 as originally released and it has been fixed in the service packs a long time ago. Go to the MS website, download and apply the service packs (free download) and you'll be rockin' & rollin'. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "scott56hannah" <microsoft.com> wrote in message news:com... |
| Tracking/Comparing Monthly Progress Posted: 18 Aug 2005 02:57 PM PDT In article <com>, "Kristi F" <microsoft.com> wrote: Kristi, Ok, it' still "my bad". Although I indeed tested the formula last time, it still isn't right for what you want to see. When I tested it I used % complete values for last month were less then those of the current month so the Gantt bar was shorter and everything looked fine. I neglected to take into account the difference between Duration and the task span line shown on the Gantt graphic. In other words the Duration field in Project is given in working days but the display is in elapsed days because non-working time (e.g. weekends) are included in the timescale display. I should have use the function that adds working days instead of elapsed days. The correct formula is: Start10=projDateAdd([Start],mid([Text2],1,instr(1,[Text2],"%")-1)/100*[Du ration]) In the case of this formula, Duration is in days (I have no idea why) so the conversion factor (480 minutes/day) is not needed. With regard to your follow-on question, I don't understand what you are asking, but let me take a stab at an answer. Project normally works with working time. Therefore Duration values are expressed in working hours, days, months, etc. although elapsed time can be entered (e.g. "xxed" = "xx" elapsed days). Project uses a normal default 5 day work week with 8 hour work days. Task Start and Finish dates are also calculated in terms of working time based on the Project calendar. However, Project stores time in its underlying database in minutes. When using time related data in formulas or in VBA, conversion factors are often necessary to convert the minutes to hours or days depending on what the formula is calculating. Conversion of minutes to hours is straightforward (60 min/hr). Conversion of minutes to days or weeks is also straightforward (480 min/day and 2400 min/wk), assuming the default 8 hour workday and 5 day workweek. Conversion to months becomes a little less straightforward because the days in a month vary. If the default 20 day month (Tools/Options/Calendar tab) is used then the conversion is 48000 min/mon). However when months are the desired dimension of the calculation, many people don't expect the result they get (they think in terms of calendar months) and become confused. That's one reason I recommend Duration always be expressed in days. Again, sorry for my shortcomings regarding the formula I posted. John At this moment I don't feel like an MVP |
| Posted: 18 Aug 2005 09:23 AM PDT You're welcome, LTD :-) Mike Glen MS Project MVP LTD wrote: |
| Is is better to categorize by task or job function? Posted: 18 Aug 2005 08:09 AM PDT John nailed it, just adding a note of clarification - IMHO, one should NEVER use job functions or responsibility matrices as summary tasks. The outline should look like... Foundation Dig Hole Pour Concrete Stucture Erect Walls Add Roof Finish Paint Walls Polish Floors Handover to customer and absolutely not like ... Labourer Dig Hole Sweep Floor Carpenter Build wall framing Build rafters Painter Paint Walls etc -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "Griff" <microsoft.com> wrote in message news:com... |
| Posted: 18 Aug 2005 08:05 AM PDT Hi, You can't have your cake and eat it! You start by saying your test stands are identical so for planning purposes which one does which test is irrelevant. The guy on the floor can just load any available stand with the next test can't he? An dfoir tracking, when teh test is done, you just tell Project. HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "Jsid541" <microsoft.com> schreef in bericht news:com... that project the would one no |
| 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 | |
