Vicky Stamatopoulou on 6. June 2012
Those of you who have checked our new post series about “Merlin report templates” know by now…
Now let’s do some magic with the reports.
What if you want to report resources work cost per phase?
We have used snippets from previous report templates posted in this series and related thread of Merlin’s user forum in Google.
In the WBL we mainly output all resources in the header of the table. This is possible over the following method in the Python script
And related WBL code iterating their titles
To output resource costs per phase, you need to iterate in all assignments of the phase and add costs for each and one resource used in the project separately. This can be done by the following method:
and related WBL code outputing it
While creating the report we noticed it looked fishy when applied to projects with default work rates and lots of unassigned tasks. To solve this, we added a method calculating costs on unassigned tasks per phase
and placed this is an extra tab of the table:
Making it flexible:
To make the report more flexible we have inserted an option to show unassigned costs or not.