[Sai Prasad]

Matthew – Use Application.ListSeparator to read the list separator from windows environment.

[Sai Prasad]

Ron – It is not possible. By the way, why would you want to do that?

[Sai Prasad]

Hi Dan – I don’t know what you meant by Planned Finish – is it Baseline Finish or Finish column but anyway I would state Planned Finish = Projected Finish = Finish column.

Project does not move the uncompleted work in the past to the future date and hence your Finish is incorrect. To reschedule the uncompleted work to be moved on or after 15th Jan, choose Project tab and click Update Project command. Select the second radio button “Reschedule uncompleted work …”, choose the date as 15 Jan, and set For “Entire Project”. This action will move the remaining work on or after Status Date and there by the Start and Finish date will be recalculated

Hope this helps

[Sai Prasad]

Hi Chan Lee,

If the task start date is not recalculated, it could be either because of Task Mode or constraints.

Do the following checks and changes

A. If you want Project to calculate the dates always.
1. Double click the successor. Set the Task Mode to Auto Scheduled in General tab.
2. Double click the successor. Set the constraint type in Advanced tab to “As Soon As Possible”. This is only for auto-scheduled tasks.

B. If you want Project not to calculate the dates but you want to adjust based on your preference
1. Double click the successor. Set the Task Mode to Manually Scheduled in General tab
2. Before you set the link click File, Options. In Schedule tab, check “Update Manually Scheduled tasks when editing links” to recalculate the date only once.
3. If you have already set links to Manually scheduled successor task and want to dates to be adjusted, select the successor task and click “Respect Links” in Task ribbon.

Hope this helps

[Sai Prasad]

The answer is No. Some columns are editable and some are calculated, but there is no way to prevent a user from editing a value. A better solution is by using VBA macros – https://bsaiprasad.wordpress.com/2014/11/05/protecting-baseline-fields/. In this blog post, I have demonstrated if the Baseline fields (Baseline Start, Baseline Finish, Baseline Work, Baseline Cost, Baseline Duration) is edited, Project will cancel the operation. You might want to change to your needs.

[Sai Prasad]

Hi, This is possible by using VBA Macros as you need to loop through the tasks to find if the predecessor is complete or not. I have written a blog post “What are you starting now?” and this will give you detailed steps.

https://bsaiprasad.wordpress.com/2014/10/23/what-are-you-starting-now/

[Sai Prasad]

Interim Plan is used to backup baseline information or backup the current Start and Finish date. For instance, before updating the baseline if you need to have a backup of the current baseline, you copy Baseline to Baseline 1 (… Baseline 10) by select Interim Plan in Set Baseline dialog and selecting Copy: Baseline and Into: Baseline1. Another instance the interim plan will be useful is when you want to see the effect of the recent update on the current start and finish date. You can copy Start/Finish to Start1/Finish1, update the estimates/actuals, and compare the current Start, Finish with Start1 and Finish1.

[Sai Prasad]

Rebaseline is due to approved change request which includes scope, time, cost and quality impact. The change request are approved if there are no options to meet the original baseline.

When updating the baseline, ask yourself : “Is all the task approved again (or) only selected tasks are approved?”. This help you to decide whether to select either “Entire Project” or “Selected Tasks” in Set Baseline dialog

[Sai Prasad]

The first issue I see here is you have split the same resource as Resource A and Resource B to work for 50% in each project. Project doesn’t know Resource A and Resource B are the same resource and hence it can no way tell us if they are overloaded or not. Desktop Project doesn’t have feature to split the the availability of resource across multiple projects 🙁

The second issue is Project schedules the task based on when its predecessor task completes, and the working time of the resource. When Resource A and Resource B (the same resource) working on two tasks the work is scheduled on the same time. Creating link between these tasks will not be option, as they are independent tasks.

So, I suggest the following process
1. Don’t split the resource. Insert one resource and it will be assigned for all tasks
2. By default, Project checks for workload on day-by-day level. Since, you don’t want the work to be schedule on the same hour (or even minute), click Leveling Options in Resource tab, and change the “Look for overallocations on a” to Hour by Hour basis. This will alert the tasks that have resources who are given more work in the same hour.

3. Select the tasks and click Level Selection.

Hope this helps.

[Sai Prasad]

When the task is delayed/extended, Project will only adjust the start date of its successor; assuming it is FS dependency. But you want the duration of the 40 tasks to expand/reduce when you move the linked milestone is moved which is not possible.

[Sai Prasad]

I copied the list of names from Excel 2010 to Project 2013, and don’t find any issues in pasting except the tasks will not be outlined; this is usual. Can you tell me what are you trying to copy from Excel 2010 to Project 2013 and where are you pasting these values to Project 2013?

[Sai Prasad]

Hi Andrew – Insert the actual duration, actual work, remaining work, remaining duration fields in your view. Actual duration and actual work should be effort spent, and the remaining work and remaining duration should be zero for completed tasks. Also, % complete and % work complete should be zero of completed tasks.

Also, give more information on these tasks that doesn’t 100% complete right
a) Whether the “Updating Task status updates resource status” in Schedule (File > Options) is on/off?
b) If possible take screenshot of the project plan, and share it in this thread

[Sai Prasad]

Hi Prakash – Good thought.

One change, on any day in the WorkWeek “From” time should be greater or equal to 12 AM and greater than “To” time of the previous shift on the same day. “To” time should be less than or equal to 12 AM and less than “From” time of the next shift on the same day

the end time should be greater than its start time and should be less than or equal to 12 am. Also,

So, I would recommend two create three shift base calendars
a) 7am-7pm base calendar: Work Weeks, Monday – Friday, 7 am – 7 pm
b) 7pm-7am base calendar: Work Weeks, Monday – Friday, 12 am – 7 am, 7 pm – 12 am | Saturday, 12 am – 7 am
c) 7am-7am base calendar: Work Weeks, Monday – Friday, 12 am – 7 am, 7:01 am – 12 am | Saturday, 12 am – 7 am

[Sai Prasad]

Yes, you can. I hope this is what you expect https://i.imgur.com/IncQTUz.png

Step 1: Insert a custom field Duration1 to your View. This column will have a formula that subtracts the task finish from the project start date
Step 2: Right the column. Select Custom Fields. Select Formula and enter the formula ProjDateDiff([Project Start],[Finish]).
https://i.imgur.com/wECRYzH.png
Step 3: Default units of Duration is days. Select File backstage, Options, Schedule. Change the “Duration is entered in” to months.

[Sai Prasad]

Hi Drew, I don’t get your first question on remaining duration updated due to allocation for resources. Are you replacing resource for a in-progress task? It would be good if you send a screenshot.

The second problem might be you have configured your resource (which is a role in your plan) is available only 100% to the Project. Go to Resource Sheet view (In Project 2007 or earlier, click View menu otherwise click View tab), and double click the resource and change the units in Resource Availability table to 200% – see this screeshot https://i.imgur.com/sZEZXcO.png; this means you have two individuals on that role working for 100% on that task.

Now, switch your view to Gantt Chart. Assign the resource to the task with assignment units as 200%. This will ensure 16 hours is not flagged as over allocation. https://i.imgur.com/uGUOdft.png

[Author]

Posts