Merlin: plan by work or duration

Now and then we get asked in support, when to plan Merlin activities by work and when by duration.

Some pose their question a bit differently, they define the activity’s work, assign two or more resources on it and email us to ask why the activity’s duration got shorter.

When using Merlin to plan your projects, there are various planing scenarios. You will find some basic configuration examples with details and screenshots here.

When it comes to the point where you assign activities to resources, it helps to know, that there is a project setting called ‘resources share their work’ which is enabled by default. You will find it under File > Project Settings > Misc > Resources >

ResourcesShareTheirWork

As long as this setting is enabled on your project, whenever you assign two resources to the same task, their work would be 50% of the work defined on the activity each so the activity itself would take half the time to be accomplished.

There are cases where you need this, for example: two painters paint the same wall on half of the time.

There are cases however where you don’t need this. You have a training planned for 1 day and have two trainers. The training won’t stop at midday, both of the trainers will be there for the complete day.

To plan this activity, you simply define it by duration and blank work entries on the activity and assignments.

ScheduledByDurationOnly

 

 

Merlin – Do a little bit of magic in Merlin reports – part XXIV

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.


Resources Groups’ or Roles’ Work as distribution in time

We’ve  been asked in Merlin support, how to output work of some specific resources and their distribution in time  as a group. For example for res A and res B 8 hours on day 1, 16 hours on day 2, 0 hours or day 3, etc.

We think this is similar to another custom report template we’ve posted outputting groups’ and roles’ utilization units distribution. Please see more about that template here. So we’ve modified that template (by entering options) to cumulate either utilization units or utilization work.

So one could create a group, group res A and res B into it, use this template and output expected work for their assignments as a time distribution.

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

Merlin – Expected work for material resources

We run a building company and want to be able to create a project file in Merlin that says it takes 2 hours to build 1 square Meter of brick work.
Now when scheduling a task of 10 square Meter of brick work, Merlin will know that this task will take 20 man hours. Is this possible?

Yes, this is possible when scheduling your projects with Merlin on Mac OS X. You can create a material resource by a default utilization of 4m^2/day (1m^2/ 2 hours => 4m^2/ 8 hours  )…

MaterialResource

…and a task with no work or duration entries on which you assign this ‘brick’ resource. As soon as you enter those 10m^2 as work onto the assignment, Merlin will calculate an expected duration of 20 hours.

UsingAMaterialResource

That means, you just check the value of expected duration and see how long it would take to build those 10 square Meters.

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.py’, “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.

sample

And the report options: Continue reading

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