Making effort calculations work in Project for the Web (P4W)
Dear all, we are having a hard time with "efforts" in P4W since the system is directly calculating the hours based on the number of assigned resources and the duration of the task. This does not reflect the reality in most organizations so a manual entry of the correct effort is needed. Since this feature seems to be missing for now I'm wondering how all of you are working around this lack of flexibility right now. I came up with the following scenarios but none seems to be a great fit: Scenario 1 - Split tasks Create one tasks with the correct effort but ignore the due date and create a milestone to indicate when the task needs to be completed. Advantage: Effort would reflect correct # of hours Drawback: First task would instantly appear as running late or late Scenario 2 - Ignore efforts in P4W Create single task and only pay attention to the duration. Outsource any effort and resource management to another system. Advantage: Gantt chart view would look correct. Drawback: Requires a separate system for effort and resource management. Any PowerBI reports are still reporting nonsense. Scenario 3 - Extend P4W to outsource efforts to a custom object Use custom CDS entity to store the actual efforts. Advantage: Effort calculation would be correct and appear in the same system. Drawback: The efforts cannot be entered in the project.microsoft.com user interface Please let me know if I missed a scenario or share you best practice! Thanks, https://www.linkedin.com/in/muellersmartin/
