There is a way to do this by using a flag, a macro, and a view. I put the below together with limited testing, but it worked fine in my sample project.
First, create a custom flag in MS Project, I've called mine "PredComplete" in Flag2.
Then we will write some VB code that will look at all tasks in the project. If the predecessors have been completed, then ...
First off, try it out in Project. Create a small dummy project and see if it works.
In my limited testing, it doesn't look to produce the results you are expecting. Setting an 80% threshold on the resource and a 50% threshold on the task, still leads to over-allocation on days that overlap. You are telling project that the resource can only work 80% ...
Define Task type as Fixed duration, while changing resource assignment information, MSP will let you choose option like Duration is fixed and amount of work will impact or change duration to accommodate resource assignment.
You can use Resource Leveling option. In case resource is Over allocated it will automatically adjusts resource assignment based on availability. In case we have assigned resource with 50% allocation, while resource leveling it will not increase allocation to 100%. This is MSP feature.
You need to update Task with Actual dates like Actual start and Finish dates. if you update MSP task saying that 100% Complete, simply it will follow Planned dates as System does not understand whether task is finished different dates rather than Planned dates.
if your actual dates are different than planned dates, user has manually inputs actual dates.
Yo have to specify availability of resources while assigning.
i have one task with 2 days duration and 2 Resources are assigned. in this case MS project assumes 2 Resources are working full time ( 8 hrs /day) and total effort for that task is 16x2= 32 Hrs.
In above situation,i have resources working part time ( 4 hrs/day), this needs to be informed in such ...