Merlin – Do a bit of Magic in Reports – Part XVII

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.


Resources Time allocation to various tasks and subtasks

If you would like to report time allocation of your resources onto tasks and subtasks of your project, this is a custom report template to use.

It lists all tasks and subtasks of your project with expected or actual work and also a distribution of work to assigned resources.

You may check contained ‘MERTimeAllocation.py’, “MERTimeAllocation.wbl” to see how we ask for all task rows with hierarchy, iterate in master resources, collect their planned or actual work to cumulate those values for activity groups, how we convert them to working days and finally output them for the report.  Feel free to modify this custom report further as you require for your needs.

An output sample:

And the report 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 “Time Allocation”.

10 thoughts on “Merlin – Do a bit of Magic in Reports – Part XVII

  1. Pingback: MERLIN – DO A BIT OF MAGIC IN REPORTS – PART XVIII » MacPM

  2. Pingback: Merlin – Do a bit of magic in Merlin reports – PART XXII » MacPM

  3. Pingback: Merlin – Do a bit of magic in Merlin reports – PART XXI » MacPM

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

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

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

  7. This template is great, is it possible to have the Totals in Days rather thank in Months or Weeks?

    Thanks
    Cinzia

  8. I am not sure I understand, you need the report in days? It already calculates totals in days.
    Or you need the report totalling time in months (or maybe weeks)?
    For latter, one would need to calculate days in months using the project settings defaults defining the amount of days by month.
    For weeks, one would need to calculate days to hours and then to weeks. So I am expecting some rounding issues here, but yes, this is possible. Is this what you asked for?

    Best regards, Vicky

  9. Pingback: Merlin – Do a little bit of magic in Merlin reports – part XXV | MacPM

  10. Pingback: Merlin – Do a little bit of magic in Merlin reports – part XXIV | MacPM

Comments are closed.