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

Those of you who do project management with Merlin on your Mac  and have checked our post series explaining how to create custom templates for Merlin reports, know by now…

Now let’s do some magic with the reports.

Resource Groups’ or Roles’ Units Utilization Distribution

The resources of a project you plan with Merlin for Mac OS X may be grouped by role or resource group. If you want to know how many of your resources are scheduled as a time distribution, this custom report is implemented to output it in a table and plot it as a line chart.  The report uses standard techniques explained in previous posts to iterate in project’s date intervals, asks the project resources’ groups or roles, iterates in their assignments and calculates the amount of resources as a function of time.

In the report options you may select whether you want to output groups or roles and select a color for the line chart plotted for the totals.

Please remember: Custom Merlin reports we provide as templates, can be downloaded and used for free. Furthermore, you may modify and distribute as you like and find appropriate.

An output sample:


Available optionsContinue reading

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

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.

Work Chart

If you like to report  expected or actual working hours per resource in a chart and/or table, this is a custom report doing so.

You may check contained ‘’, “WorkChart.wbl” to see how we iterate in project’s master resources, ask for their working units, compare them with total work hours and output this information in the table. In the pie chart, working hours are forwarded and the pie chart calculates respective percentages. There are methods in the Python part gathering the x- and y-Ticks and some javascript functions drawing the graph. You may furthermore disable outputting resources’ work in the table and define the first 8 colours to be used for the pie chart.

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

An output sample:

Showing expected work hours by resource.


And the report options: Continue reading