VeeJo – I agree with Larry that resource plan should help you to share resources across project files. To address the second part of your question about budget cost to be tracked and assigned to the respective project, you can create these budget costs resources as budget resources in the resource pool file. Refer to Budget Cost (task field) in this article https://support.office.com/en-us/article/Budget-Cost-fields-debac6b2-48fb-4314-b1a5-8a5f0979f6cb
Hi,
I am tested the below approach in Project 2010 and hope it applies to Project 2013 too
1. Exported task details that includes Unique Id and % Complete to Excel workbook
2. Updated the % complete in Excel workbook
3. Made sure default task mode is Auto Schedule, otherwise during merge Project is unable to calculate and update Actual Start, Actual Finish and other tracking fields
4. Import the Excel workbook using Merge option.
5. Since you have exported and importing the same file, the field mapping will be preset
6. Complete the wizard, and you should see % complete updated in Project file
Regards
Sai
Ulhaas – I will be glad to review the book. Please see my profile https://www.linkedin.com/in/bsaiprasad
Mike – I am not able to reproduce the issue. I followed the same steps in Project Professional 2013 – changed the text style of critical tasks, marked a critical task completed, the color changed to black (the default color). Do you mean to say for some tasks the color changes and for some tasks it works correctly? Also, try clearing the formatting that might have been set on some these tasks by first selecting all the tasks, then click Task ribbon, in the Editing group click Clear .. Clear Formatting. This action will ensure any font color changed on that tasks will be cleared and the text style font color will be applied.
I agree with Larry. You can’t do it with Progress lines. The work around is hide the summary tasks in the Gantt Chart. You can create a filter (View tab > Filter drop down … New Filter) and copy the filter definition of Summary. In the Filter definition dialog, change the condition to “Summary equals No” and clear Show related summary tasks. Apply this new filter. It will display all tasks except summary tasks. Now apply the progress line on this view.
Thanks for this initiative to promote Microsoft Project
Keshava Moorthy – I have limited knowledge about 2003, but I agree with you in Project 2010 and 2013 copy the summary task just copies on its name. So, the option is you need to iterate the complete task list and do the copy
Chantal – Project uses Gregorian Calendar to define the months of the year and this cannot be changed.
You are welcome
Gianluca Coppola – Thank you. Have you selected “Use formula” for “Calculation for task and summary rows” — see the picture in my previous reply?
Great question. First, let me answer your first question on the locations Project searches for Global.MPT
1. The current folder
2. The user’s profile folder
3. The user’s profile language folder
4. The folder where the Winproj.exe file is located
5. The Winproj.exe language folder
Source: More information section from https://support.microsoft.com/kb/163093
On your second question on sharing Global.MPT use the following steps
1. Copy Global.MPT to shared folder (like \\myshare\project)
2. Ask each user, to create a short-cut of Project on their desktop
3. Edit the short cut and set the Start In folder to be shared folder
4. Now, the user launches Project using this short cut, Project checks the Start In folder rather than current folder.
This is very odd. What is the version number do you see in File > Account … About Project
Gianluca Coppola – By solar days, I suppose you meant calendar days between start and finish. Insert a Number1 column and you can use DateDiff(). DateDiff(“d”,[Start],[Finish]) returns the number of calendar days between Start and Finish but this function will return a value one less that what is expected. For example, for Start = 1 Jan, Finish = 1 Jan, this function will return 0 but we expect 1. So, in the formula add 1 to the returned value. Let me know if this helps.
Harold – You can ask Project to respect the Start and Finish date by changing the Task Mode to Manually Scheduled. This will ensure as you increase/decrease work the start and finish won’t change. Now change your view to Task Usage (View ribbon). In Time-phased data (right side) enter the 8 hours for the first two days and make edits for the remaining days left.
Matt – Since you have hinted one of the resource has no allocation for a period of 5 weeks, check if there are exceptions (holidays) set for this resource. What is the Task type and Effort driven? It would be good if you can provide a screenshot of this assignment?