Making effort calculations work in Project for the Web (P4W)

%3CLINGO-SUB%20id%3D%22lingo-sub-1073694%22%20slang%3D%22en-US%22%3EMaking%20effort%20calculations%20work%20in%20Project%20for%20the%20Web%20(P4W)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1073694%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%26nbsp%3B%3CBR%20%2F%3Ewe%20are%20having%20a%20hard%20time%20with%20%22efforts%22%20in%20P4W%20since%20the%20system%20is%20directly%20calculating%20the%20hours%20based%20on%20the%20number%20of%20assigned%20resources%20and%20the%20duration%20of%20the%20task.%20This%20does%20not%20reflect%20the%20reality%20in%20most%20organizations%20so%20a%20manual%20entry%20of%20the%20correct%20effort%20is%20needed.%20Since%20this%20feature%20seems%20to%20be%20missing%20for%20now%20I'm%20wondering%20how%20all%20of%20you%20are%20working%20around%20this%20lack%20of%20flexibility%20right%20now.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20came%20up%20with%20the%20following%20scenarios%20but%20none%20seems%20to%20be%20a%20great%20fit%3A%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1059480471%22%20id%3D%22toc-hId-1059483289%22%20id%3D%22toc-hId-1059483289%22%3EScenario%201%20-%20Split%20tasks%3C%2FH3%3E%3CP%3ECreate%20one%20tasks%20with%20the%20correct%20effort%20but%20ignore%20the%20due%20date%20and%20create%20a%20milestone%20to%20indicate%20when%20the%20task%20needs%20to%20be%20completed.%26nbsp%3B%3CBR%20%2F%3EAdvantage%3A%20Effort%20would%20reflect%20correct%20%23%20of%20hours%3CBR%20%2F%3EDrawback%3A%20First%20task%20would%20instantly%20appear%20as%20running%20late%20or%20late%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId--747973992%22%20id%3D%22toc-hId--747971174%22%20id%3D%22toc-hId--747971174%22%3EScenario%202%20-%20Ignore%20efforts%20in%20P4W%3C%2FH3%3E%3CP%3ECreate%20single%20task%20and%20only%20pay%20attention%20to%20the%20duration.%20Outsource%20any%20effort%20and%20resource%20management%20to%20another%20system.%3CBR%20%2F%3EAdvantage%3A%20Gantt%20chart%20view%20would%20look%20correct.%3CBR%20%2F%3EDrawback%3A%20Requires%20a%20separate%20system%20for%26nbsp%3Beffort%20and%20resource%20management.%20Any%20PowerBI%20reports%20are%20still%20reporting%20nonsense.%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1739538841%22%20id%3D%22toc-hId-1739541659%22%20id%3D%22toc-hId-1739541659%22%3EScenario%203%20-%20Extend%20P4W%20to%20outsource%20efforts%20to%20a%20custom%20object%3C%2FH3%3E%3CP%3EUse%20custom%20CDS%20entity%20to%20store%20the%20actual%20efforts.%26nbsp%3B%3CBR%20%2F%3EAdvantage%3A%20Effort%20calculation%20would%20be%20correct%20and%20appear%20in%20the%20same%20system.%3CBR%20%2F%3EDrawback%3A%20The%20efforts%20cannot%20be%20entered%20in%20the%20project.microsoft.com%20user%20interface%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20I%20missed%20a%20scenario%20or%20share%20you%20best%20practice!%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fin%2Fmuellersmartin%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMartin%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1073694%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ereporting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1081724%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20effort%20calculations%20work%20in%20Project%20for%20the%20Web%20(P4W)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1081724%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F231340%22%20target%3D%22_blank%22%3E%40Martin%20M%C3%BCller%3C%2FA%3E%26nbsp%3BI%20like%20the%20option%20%233%20better%2C%20however%20may%20need%20a%20slightly%20different%20approach.%20Use%20additional%20Field%20for%20the%20Task%20Entity%20to%20store%20the%20Effort.%20Use%20PowerApp%20to%20manage%20these%20hours.%20You%20can%20use%26nbsp%3B%3CSPAN%3Eproject.microsoft.com%20like%20features%20from%20within%20the%20PowerApp%20itself%20so%20you%20keep%20the%20modern%20look%2Finterface%20and%20add%20feature%20of%20custom%20effort%20column.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ELet%20me%20know%20what%20you%20think.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAlex%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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,
Martin 

1 Reply
Highlighted

@Martin Müller I like the option #3 better, however may need a slightly different approach. Use additional Field for the Task Entity to store the Effort. Use PowerApp to manage these hours. You can use project.microsoft.com like features from within the PowerApp itself so you keep the modern look/interface and add feature of custom effort column.

Let me know what you think.

Alex