How to access Merlin projects from dynamic-IP driven locations
John Kranz on 9. March 2010
If you are publishing Merlin projects from a computer that has a dynamically generated IP address, this can cause problems for your users already having received the project URLs and use in the meanwhile obsolete IPs to access the projects. This situation easily occurs, as the IP address of your router changes upon re-connecting to your internet provider.
In this case the actual project URLs will fall out of sync with the URL and IP address that Merlin has originally published. Fortunately, there is a solution readily at hand thanks to the free service provided by DynDNS.org that allows you to create a static host name that can be used instead.
Tags: DynDNS, Merlin 101, Merlin Web
Merlin: resources utilization dynamically adjusted
Vicky Stamatopoulou on 8. March 2010
This is a tip of our CEO, Frank Blome, as discussed at the CeBIT 2010 and published on our German MacPM blog:
Supposedly you plan an activity of 5 days work to be accomplished in the duration of 10 days. As an experienced PM and Merlin user you create the activity in your project as follows:
This results to a 50% utilization for the assigned resource
Tags: Actuals, Documenting actual work, Merlin, Merlin 101, Utilization
Merlin import of EXCEL files
Vicky Stamatopoulou on 2. March 2010
Merlin can import seamlessly lots of file formats, here a list of the currently supported formats:
- MS Project (.mpx, .mpp, .xml)
- OmniOutliner (.ooutline, .oo3)
- OmniPlan (.omniplan)
- NovaMind (.nmind)
- MindManager (.mmap)
- Merlin 1 (.merlin)
- Merlin 2 (.xml)
- Text files (.txt, .csv, .tsv)
- OPML files (.opal)
So you look on the list above, have project WBS saved in MS EXCEL and don’t know how to proceed?
Tags: Excel, Import, Integration, Merlin, Merlin 101
Applescript: Shifting activity starting dates at once
Vicky Stamatopoulou on 26. February 2010
From time to time we get asked in support, how to shift all given planned starting dates at once in Merlin projects to a new date while maintaining the slacks.
If the activities are linked together, the user may use the dynamic shifting project setting, and define a new planned starting date for the first activity. The linkages between activities will shift the successor activities as needed.
If the activities are set to specific starting dates, and you want to shift them all by the same amount of time, you may consider writing an AppleScript to read the given planned earliest start dates of the activities, apply the desired time offset, and write the new date back onto the activities of the project.
But why bothering writing a new Applescript from the scratch, when there is already one which we have just written doing so? Spend your time on managing your projects, not on scripting. Be lazy and productive. Just click here to download it 
Tags: Applescript, Merlin, Merlin 101
Merlin: CSV duration units
Vicky Stamatopoulou on 22. February 2010
There is a new feature in Merlin 2.7.6 and its CSV reading & writting possibilities.
You can now define the unit for the durations and choose one of the following: Seconds, Minutes, Hours, Days, Weeks, Calendarweeks, Months and Years.
This is very practical in case you want to import project information in spreadsheets of MS Excel, Numbers, etc and need further calculations referencing duration data.
In this case simply choose the appropriate unit when exporting. Merlin will recalculate project durations if necessary in the output.
Merlin: Fractions vs. time units
Vicky Stamatopoulou on 12. February 2010
Merlin creates new activities having the default work specified in the project settings:
Should you assign a resource to this activity, Merlin will automatically define its work as 100% of the work defined in the activity.
So when to use fractions in work (or duration) and when not to?
The answer is simple: It depends on what you want to do.
Tags: Fraction, Merlin, Merlin 101
Merlin: PM Templates
Vicky Stamatopoulou on 4. February 2010
It’s so easy starting new projects in Merlin. It comes with a number of PM templates for you to use. Simply call File > New Project… and choose the appropriate one. Do you want to hire a consultant, plan product design, engineering projects, software development, etc? You are all setup with Merlin.
In Merlin’s user forum in Google and in support we find occasionally the question, where one could find more project management templates.
(more…)
Tags: Merlin, Merlin 101, Templates
Merlin: Print a date range
Vicky Stamatopoulou on 21. January 2010
What I really want to do is print a date range. Either that’s not possible or the instructions are hidden deep enough that I can’t find them. Seems like it would be a pretty basic function.
The above text was sent to us as feedback to a Merlin documentation file. Unfortunately the user had not entered an email address so we cannot answer directly. Anyhow in order to provide an answer and in case someone else is also wondering about that, here you are. The instructions to it:
- First you limit the visible date range in the views.
- And then call File > Print…
Tags: Feedback, Merlin, Merlin 101
Merlin: Applescript
Vicky Stamatopoulou on 21. January 2010
Is there is a way to print all notes entered in the activity view of a Merlin project at once?
Yes of course. You can enable the display of the ‘notes’ column, disable all other columns, hide the Gantt chart, adjust the column width and the row height accordingly and print.
Should you however happen to have, longer texts than the above setup could show completely, you may consider exporting the file as CSV and import into another application.
If export is much too inconvenient for you, you can use this AppleScript. It writes the project and activity notes into a text file, which you can later on open and edit with your favorite text application to complete your project management reports.
UPDATE: We have updated the script and enabled UTF-8 encoding for the created text file. This solves an issue with non English text (i.e. German texts with special characters) and wrong encoding of these texts, which will be now correctly transferred.
Tags: Applescript, Merlin, Merlin 101
Merlin: How many calendar weeks in a year?
Vicky Stamatopoulou on 15. January 2010
Last year we had 53 weeks and met the problem that my customers in some countries did not had 53 weeks but 52. When we in Europe ‘lived’ in week 53, they already start calculating with week 1. Even though we have the same date, in weeks they are ahead of us.
And now, when I do project management in Merlin I see that this program is also 1 week ahead.
Is there something I can do?
Yes of course, you simply have to make sure that you all use the same ‘calendar’. It all depends on the definition when a week starts. A week starts in Europe on Monday. In the USA and some other countries on Sunday.
This is the Gantt of a project having Sunday as first day of the week:
This is the Gantt of a project having Monday as first day of the week:
Both displays are correct, it is only a question of the desired settings.
Tags: Calendar, Merlin, Merlin 101
PMOT, AGILE Tweets
- RT @AgilistaPM: IT Contracting Growth in Jobs – 4% in 2010 http://bit.ly/c4nhUX #pmp #pmot #agile coolassmike (coolassmike)
- RT @vhernandez: Well-formed teams will exhibit a "team swarm" pattern after they mature; read more - http://bit.ly/bSfdtw #Agile #Scrum #Kanban #pm #pmot asplake (Mike Burrows)
- Green Eggs and Ham are... http://bit.ly/cbvAr4 #pmot #agile #kanban derekhuether (Derek Huether, PMP)
- RT @ninusch01: Skills and attidues of an #agile #developer: http://j.mp/dgYjvU - It's much more than just developing #pmot #scrum niravbpatel (Nirav Patel)
- IT Contracting Growth in Jobs – 4% in 2010 http://bit.ly/c4nhUX #pmp #pmot #agile AgilistaPM (Donna Reed)