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 – DO A BIT OF MAGIC IN REPORTS – PART XVIII

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.


Calendar View

If you like to report  working days of your project’s scheduling and/or assigned resources, this is a custom report template to use.

You may check contained ‘CalendarView.py’, “CalendarView.wbl” to see how we iterate in project’s duration, convert dates to the desired formats and color the table on working days.

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

Some output samples:

Showing project scheduling grouped by month.

Or resource’s working days grouped by week… Continue reading

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: Continue reading

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

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.


Output Project’s WBS
We have posted here in the past ways to display the WBS of a Merlin project.

If you prefer using a report template instead of AppleScripts, feel free to use following custom report template we present hereafter. It lists per default up to 3 levels of the WBS, ignores assignments and milestones, shows the project objective if existing and  resources. Optional you may enable the view of milestones and limit the shown levels.

You may check contained ‘ProjectWBS.py’, “ProjectWBS.wbl” or “Info.plist” to see how we ask for items on the various levels, or how we iterate in their properties for the output.
Feel free to modify this custom report further as you require for your needs.

Credits for the CSS and other resources used: SlickMap CSS was created by Matt Everson of Astuteo and is licensed for free.
An output sample:

And the report options: Continue reading

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

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.


Report Events
To report events recorded in your Merlin project, you may customize the Elements area, click an Event row and call File > Print > PDF…

Should you like a report template, here is one outputting non private Events defined in your Merlin project.

Feel free to check the contained python file ‘MEREventsReport.py’, “MEREventsReport.wbl” or “Info.plist” to see how we ask for elements of kind ‘Event’, or how we iterate in their properties for the output. Feel free to modify this custom report further as you require for your needs.

An output sample: Continue reading