how do I import/copy tasks from one project file to another? Microsoft Project |
- how do I import/copy tasks from one project file to another?
- Booking Type - Propose resource
- Changing Project Default Settings in an Existing Project
- Cost per task
- Project specific calendar format change
- Equipment Resource definitions
- Project diagram view
- constraining tasks by hour
- using a definite time frame for a task
- Modified Resource Usage View
- Converting Finish Variance to total Calendar days
- Rolling up Red, Green, Yellow
- General Comment on Custom Functions
- Time Sheet Updates using specific hours per day
- smart predesessor pasting
- Custom report showing dependencies' % complete, estimated complete date, and actual complete date
- How do I get my Visual Basic "New Project" dialog box back?
- How do I set a project task effort to be a percentage of other tas
- Is there a way to lock a completed task in MS Project 2003?
- Dealing with Effort and Duration
- Disable field after entry
- Track Actual Hours without changing Start-Finish Date
- large plots for resource useage
- Charts and Graphs
- Deadline vs. Must Start On
| how do I import/copy tasks from one project file to another? Posted: 24 Nov 2005 04:22 AM PST what I should have mentioned is I'm replacing existing info. I'm able to copy everything but the predecessors, once they go in the dates get messed up. I'm doing something wrong? "Jan De Messemaeker" wrote: |
| Booking Type - Propose resource Posted: 23 Nov 2005 07:40 PM PST Dale Howard ， Sorry, next time i wll post Project Server questions to the microsoft.public.project.server newsgroup. I think my question have some problem. I see the below information in microsoft project 2003 "Note that a resource's booking type applies to all their assignments in the project" So may i know have any way can set the resource booking type like this. example: if i have a project has 3 task. and today date is 15/oct/2005 task 1 - 01/oct/2005 - 9/oct/2005 - resourceA (committed) task 2 - 10/oct/2005 - 19/oct/2005 - resourceA (committed) task 3 - 20/oct/2005 - 30/oct/2005 - resourceA (Propose) I will post my question to microsoft.public.project.server newsgroup. Thanks, Ng "Dale Howard [MVP]" wrote: |
| Changing Project Default Settings in an Existing Project Posted: 23 Nov 2005 11:49 AM PST Hi Bob, If you want to change the week in Tools, Options, just do it. It will only influence the display of the tasks where you explicitly used the week as the unit to be displayed. In the macro add within the loop Job.effortdriven=false But if you have already done the multiplication don't do it again :-)) HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "bob1122" <microsoft.com> schreef in bericht news:com... 30h what in were work there a |
| Posted: 23 Nov 2005 09:03 AM PST Hi, Yes. Insert the Cost line in the Resource Usage View. HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "David M C" <microsoft.com> schreef in bericht news:com... throughout use the that was or he You'll the I more amount Project but |
| Project specific calendar format change Posted: 23 Nov 2005 08:25 AM PST You're welcome mikejw. Thanks for the feedback. Julie "mikejw" <microsoft.com> wrote in message news:com... |
| Equipment Resource definitions Posted: 23 Nov 2005 08:19 AM PST As Gerarrd said - but note, the Server is a Work resource, not a material resource. I meantion that because some people think "material" means "inanimate." But that's not true. Material resources are used up and incorporated into the delieverable. Your server isn't - it is performing work that contributes to the task's deliverable, just like a person, but it isn't used up in the process. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "MED" <microsoft.com> wrote in message news:com... |
| Posted: 23 Nov 2005 07:48 AM PST You're welcome, Jimmy :-) Mike Glen MS Project MVP jimmyharris80 wrote: |
| Posted: 23 Nov 2005 07:08 AM PST I don't know - whenever I see Project being used simply to draw pictures of a pre-existing schedule I have to wonder why you've spent $1500 for a product and then only use it to do what could be done just as well by spending $10 for a wall calendar and box of Magic Markers. At the very least I'd suggest using it as a reality check, using it to independently generate a proper schedule in order to confirm whether your pre-existing master schedule is truly workable, to identify where the potential bottlenecks may lie in it, and where you might change it to be more efficient. I think of Project's role as telling ME the best schedule I can expect to HAVE, given what needs to be done and the assets I'm able to deploy to achieve it, rather than me telling IT the schedule we're expecting to work. When you doing the work, building a proper schedule where Project is calculating the task dates rather than merely parotting the dates you've input will let you dynamically monitor the downstream effects of actual work as it's being done so you can keep your "troops" deployed most effectively. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "mikejw" <microsoft.com> wrote in message news:com... |
| using a definite time frame for a task Posted: 23 Nov 2005 04:30 AM PST Mark the task non-effort driven, fixed duration. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "jake" <jake @discussions.microsoft.com> wrote in message news:com... |
| Posted: 23 Nov 2005 01:58 AM PST Thanks for the quick response. However this does not quite satisfy what I am looking for. You see the excel generated by your suggestion provided me with the following report format. 14-Nov-05 15-Nov-05 16-Nov-05 17-Nov-05 18-Nov-05 Resource A Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs Resource B Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs Resource C Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs Resource D Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs Resource E Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs Resource F Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs The format that I need would look like this: 14-Nov-05 15-Nov-05 16-Nov-05 17-Nov-05 18-Nov-05 Resource A Task 1 0 0 2 hrs 3 hrs 0 Task 2 8 hrs 8 hrs 6 hrs 5 hrs 8 hrs Resource B Task 2 0 1 hrs 1 hrs 0 2 hrs Task 3 2 hrs 0 0 1 hrs 0 Task 4 6 hrs 7 hrs 7 hrs 7 hrs 6 hrs Resource C Task 4 2 hrs 3 hrs 0 0 8 hrs Task 5 3 hrs 3 hrs 3 hrs 0 Task 6 3 hrs 5 hrs 5 hrs 5 hrs 0 Resource D Task 2 4 hrs 4 hrs 4 hrs 4 hrs 0 Task 3 4 hrs 4 hrs 4 hrs 4 hrs 8 hrs Resource E Task 4 3 hrs 2 hrs 6 hrs 0 0 Task 6 5 hrs 6 hrs 2 hrs 8 hrs 8 hrs Resource F Task 1 2 hrs 0 8 hrs 8 hrs 8 hrs Task 3 1 hrs 0 0 0 0 Task 4 2 hrs 0 0 0 0 Task 5 3 hrs 8 hrs 0 0 0 or the following format may do as well Name Task Name Date Actual Work Resource A Task 1 11/16/2005 2 Resource A Task 1 11/17/2005 3 Resource A Task 1 11/18/2005 1 Resource A Task 2 11/14/2005 8 Resource A Task 2 11/15/2005 8 Resource A Task 2 11/16/2005 6 Resource A Task 2 11/17/2005 5 Resource A Task 2 11/18/2005 7 Resource B Task 2 11/15/2005 1 Resource B Task 2 11/16/2005 1 Resource B Task 2 11/18/2005 2 Resource B Task 3 11/14/2005 2 Resource B Task 3 11/17/2005 1 Resource B Task 4 11/14/2005 6 Resource B Task 4 11/15/2005 7 Resource B Task 4 11/16/2005 7 Resource B Task 4 11/17/2005 7 Resource B Task 4 11/18/2005 6 Resource C Task 4 11/14/2005 2 Resource C Task 4 11/15/2005 3 Resource C Task 4 11/18/2005 8 Any suggestions? Thanks -- Albert "Gérard Ducouret" wrote: |
| Converting Finish Variance to total Calendar days Posted: 22 Nov 2005 07:30 PM PST Dear Harris and Manmeet Thank you very much for your helpful response. Dan "Haris Rashid" wrote: |
| Posted: 22 Nov 2005 07:24 PM PST Hi Glenn, When you will introduce conditions between fields of several taks you will need VBA. Formulas are restricted to comparing fields within the task HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "Glenn" <com> schreef in bericht news:phx.gbl... Perfect Gerard! I was actually using a text field, initially, and wondered how to utilize the rollup feature. I didn't think about trying a number field, but since you mentioned it, it makes perfect sense! I'm going to take another step... not only will I show red, green, yellow based on completion and date. I will use a number or text field, where I can use it to override the automated settings for tasks that have plenty of time to finish, but have issues that won't allow it to complete on time. This will then show a yellow flag until I discontinue the override. An example of this would be where if a task is "Install router". Eventhough the date may be a 2 months out and the router can be shipped in 3 weeks and the indicator shows green, If I know the rack can't be installed in time to install the router, I want the ability to force a yellow flag indicator for the task "Install router". Now I need to figure-out how to automagically change the flag to yellow on the "Install router" task, if I force a yellow flag on the predecessor task "Install rack". I love MS Project! It never ceases to amaze me with it's abilities!! Glenn "Gérard Ducouret" <fr> wrote in message news:O%phx.gbl... Hello Glenn, You don't say what kind of field you used to these Red, Yellow and Green symbols. If you used a Number(x) field and if the Red color matches the greatest value, in the Customize Field dialog, for Summaries and groups, select Report : Maximum Hope this helps, tell us if that work, Gérard ducouret "Glenn" <com> a écrit dans le message de news:%23Z%phx.gbl... I've created a text field formula that allows me graphical indicators to show whether a task is on track. How do I have the summary row show a specific indicator based on the subtasks below? Although I think I want it to show the worst indicator of the subtasks, I want the flexibility to change as necessary. Example: 1 ysis (summary row - how do I show RED, based on the below?) 2 Interview Client (subtask - done ontime, GREEN) 3 Create ysis doent (subtask - not done, due yesterday, RED) 4 Review with Resources (subtask - due tomorrow, YELLOW) Thanks in advance for any assistance Glenn |
| General Comment on Custom Functions Posted: 22 Nov 2005 04:45 PM PST I would love to know how as well Majid "Haris Rashid" wrote: |
| Time Sheet Updates using specific hours per day Posted: 22 Nov 2005 04:21 PM PST hi, you seem to have set a constraint on your task. A task starting on Oct 3 with 10 days duration should finish on Oct 14. Since you have the finish date of Oct 19 you might have a constraint such as "Finish As Late As Possible", etc. When a task is first created, the percent complete is zero percent. As soon as you enter actual duration, remaining duration, or actual work (which affects actual duration), Project calculates percent complete as follows: Percent Complete = (Actual Duration / Duration) * 100 If the % Complete field is set to a value greater than zero, the Actual Start field is set to the scheduled start date if you have not yet entered an actual start date. If the % Complete field is set to 100, the Actual Finish field is set to the scheduled finish date. If you type a value in the % Complete field, Project automatically calculates actual duration and remaining duration. Likewise, entering a value in the Actual Duration or Remaining Duration field automatically recalculates the other fields. You can control whether changes to total percent complete are distributed through the status date or to the end of the task's actual duration so far. On the Tools menu, click Options. On the Calculation tab, select or clear the Edits to total task % complete will be spread to the status date check box. When you enter percent complete, Project might adjust actual and remaining work around the current status date. If you prefer, you can leave these tracking fields in the project as originally scheduled, even if completed work is shown in the future or remaining work is shown in the past. On the Tools menu, click Options. On the Calculation tab, clear the Move end of completed parts after status date back to status date and Move start of remaining parts before status date forward to status date check boxes. To set the status date to a date other than today's date, click Project Information on the Project menu, and then enter the date in the Status date box. Regards, ----------------- Haris http://www.manage-systems.com ---------------------------------------- "Grant" wrote: |
| Posted: 22 Nov 2005 02:13 PM PST John wrote: I always caution people about having multiple tasks with the same name. It can lead to a great deal of confusion, both in the Network Diagram and in a sorted or filtered Gantt. It can be hard to tell with "Review Drawings" you're looking at if there are several of them. If you ask on here, someone will have a VBA macro that puts the appropriate summary task name, if they're unique, into the task name. So your tasks would be "Preparation Review Drawings" and "Final Review Drawings", etc. Can save a lot of headaches down the road. Hope this helps in your world. |
| Custom report showing dependencies' % complete, estimated complete date, and actual complete date Posted: 22 Nov 2005 02:11 PM PST In article <googlegroups.com>, "com" <com> wrote: anewton, Sure, just write me direct - I receive a fair amount of "off-list" queries. John Project MVP mjensenatattheriverdotdotcom delete obvious redundancies |
| How do I get my Visual Basic "New Project" dialog box back? Posted: 22 Nov 2005 08:29 AM PST "John" wrote: |
| How do I set a project task effort to be a percentage of other tas Posted: 22 Nov 2005 08:20 AM PST Oops, http://www.andythevikingfordham.com/ One hundred ......and forrrrrrtttttyyyyyy! cheer cheer "John" <com> wrote in message news:microsoft.com... |
| Is there a way to lock a completed task in MS Project 2003? Posted: 22 Nov 2005 07:31 AM PST In article <com>, Dan Bridy <microsoft.com> wrote: Dan, Whew! I'm glad you won't have to shoot anybody either - I hate when that happens - it's just so messy. Seriously, you're welcome. John |
| Dealing with Effort and Duration Posted: 22 Nov 2005 06:35 AM PST I like your approach!!!!! <grin> -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "John Sitka" <com> wrote in message news:%phx.gbl... |
| Posted: 22 Nov 2005 05:07 AM PST Hi Trev, Try posting on the server newsgroup. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm Mike Glen Project MVP Trev wrote: |
| Track Actual Hours without changing Start-Finish Date Posted: 21 Nov 2005 04:37 PM PST Are you tracking *duration* hours or *work* hours? They are very different measures. Duration is time and there absolutely positively cannot be more than 24 duration hours in a day, at least on this planet. Work, OTOH, is actually "man-hours" and when two people work together for 24 hours, they do a total of 48 man-hours of work. Do you really have 24 hour workdays? That means that when a task begins it doesn't stop until it's completed AND the resources assigned to it work on it for the entire period of time. If a task lasts 72 hours, that means that the crew that works on it doesn't rest, eat a meal, take a break or a nap, or get any time off whatsoever for the entire continuous 3 days. It does NOT mean that you have people coming and going with some guys working days, others nights, etc. The 24 hour calendar says that if Joe is assigned to that task, he joins the task when it starts and doesn't leave for any reason until it's finished days later. Machines might do that but people don't - they need at least to sleep and eat a little while out of each day. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "Vicky" <microsoft.com> wrote in message news:com... |
| large plots for resource useage Posted: 21 Nov 2005 01:58 PM PST Mike, Thanks but that's not it. I can go boack without any other changes and make the plot size 30" x 50" (without changing the columns) and it works. There must be some undoented plot length for data !? It's really weird, as the backgound plots out fine. The actual data just gives a '#' and stops filling in the data. I think its a limitation by number of columns or plot length. It would seem like it would stop plotting everything instead of just the actual work data..... If you think of anything let me know but this is no show stopper. Thanks -- Best Regards, Eddie A "Mike Glen" wrote: |
| Posted: 21 Nov 2005 12:48 PM PST In article <com>, "motor_mouth" <microsoft.com> wrote: motor_mouth, Oh sure, now the whole story comes out ;-) The Resource Graph view in Project is by resource rather than by task assignment so you are probably not going to get the information directly. There are a couple of options. The option I would chose (and have used on some of my projects) may be a little advanced because it involves using a VBA macro to export the necessary data to Excel and then plotting it in a manpower curve. However, an equivalent process can be used without a custom VBA macro. Starting from the Task Usage view, use the "yze timescale data in Excel" untility/add-in found on the "ysis" toolbar (I would export the Work field). Once the data is in Excel, use Excel's charting capability to develop the graph you want. Just for reference you might want to consider using a rolling average instead of exact monthly values when it comes to reviewing manpower needs, (I used a 3 month rolling average), otherwise you will end up with hiring/layoff spikes that don't reflect reality. Hope this helps. John Project MVP |
| Posted: 21 Nov 2005 11:34 AM PST Tools menu, Customize, Fields - create a flag field with a formula that tests for the condition you're monitoring and choose "graphical indicators" in the dialog box as the results display. I wonder at the logic of looking at start date with respect to a deadline. Deadlines describe the required completion date for the task. Checking to see if a task is started by 90 days before its deadline really only makes sense if the task requires 90 days to do. The duration of a task is your best-guess estimate of how long it will actually take to complete the task once it starts. Comparing a start date with a deadline only gives you useful information if the time frame you're looking at compares the start with the deadline minus the duration and it will only be 90, 60, or 15 days if the task duration also happens to be 90, 60, or 15 days respectively. What counts is not that it starts 90 days ahead of deadline but rather that it has started by whatever you have determined is the latest date it should start so that it can finish by the deadline. Best practice suggests that when a resource is assigned to a task they will be expected to start it on the date you have scheduled it to start and work on it full-time until it has finished. The duration of the task is not how long they are allowed to finish it - it's your best estimate of how long you think it should take them to finish it. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "JenEx" <microsoft.com> wrote in message news:com... |
| 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 | |
