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:

output

Available options
options

Installation:

  • Extract the zip first
  • place the contained mrept package under the following path of your mac: ~/Library/Application Support/Merlin/Reports
  • (in case you have no “Reports” folder please create it first and pay attention to name it exactly as “Reports”)
  • restart your Merlin and
  • call File > New Report… to find the new report called “Resource Units Utilization by Group or Role with Chart”.

6 thoughts on “Merlin – Do a bit of magic in Merlin reports – PART XXII

  1. Pingback: Merlin – Do a bit of magic in Merlin reports – PART XXIII » MacPM

  2. Pingback: Merlin - Do a little bit of magic in Merlin reports - part XXIV » MacPM

  3. Pingback: Merlin - Do a little bit of magic in Merlin reports - part XXV » MacPM

  4. This report doesn’t seem to work. I always get a continual spinning wheel, never actually generates the report. I have to kill Merlin to get out of it.

    Thanks,
    Cory

  5. Hi Cory,

    it works fine for me.
    Which is your interval unit?
    How long is your project?
    How many your resources?
    Do you report groups or roles?
    Is it a single project or a master project?

    Best regards, Vicky

  6. Pingback: Merlin – Do a little bit of magic in Merlin reports – part XXV »

Comments are closed.