Merlin – Do a bit of magic in reports – PART XIX

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.


Working hours distributed in time per resource and assignment

If you like to report  the distribution in time of expected or actual working hours per resource and assignment, this is a custom report template to use.

You may check contained ‘AssignmentDistribution.py’, “AssignmentDistribution.wbl” to see how we iterate in project’s master resources, ask for their assignments and iterate in time to show the amount of expected or actual work in the selected time interval units.

Feel free to modify this custom report further as you require for your needs.

An output sample:

Showing work hours by resource and week.

resources' work by week

Or resources’ assignments by month Continue reading

Merlin – utilization or work of an assignment

When to enter a work or utilization percentage for the assignments in my Merlin projects?

Short answer on this is, when ever your planning requires it.
For a more detailed answer please check the activities on the screenshot and our explanations hereafter:


Case A
You have a task (activity A) of 6 days of work and need to assign half of it to your resource. Your resource should work for those 3 days by its full day capacity.

To schedule it in Merlin… Continue reading