Website occasionaly down

You might have noticed that the website has been down last Friday. I am currently making changes to the site in preparation for Logframer 4.0 and this means that the site may go down again in the future. I'll do my best to make sure this doesn't happen too often and that interuptions are as brief as possible.

Apologies for any inconveniences.

Logframer training videos by Atiq Rehman

I'm often contacted by people looking for the Logframer manual. You can find it in Logframer itself (press the F1 button) but also on this website in the Help section.

But now you can also watch the training videos that Atiq Rehman posted on YouTube. Atiq is a data wizard and has many useful videos on how to use Excel, MS Project, SPSS, the R language and many other instruments. He has made five video's about Logframer:

1. An overview of the software

2. My organization

3. How to construct the logframe matrix

4. How to create a project plan with Logframer

5. How to create the budget of any project

A big thank you to Atiq for his great work! Check out his other instruction videos on his YouTube page.

Logframer Training at University of Blida (Algeria)

Last week I was invited by the Université Saâd Dahlab de Blida (Algeria) to provide a workshop on project design and management using the logical framework and Logframer 3.1. The group consisted of professors and staff members of the University of Blida 1 and the University of Constantine.

After an introduction on project management, the logical framework and particpatory approaches, we got to a hands-on experience with the Logical Framework Approach to formulate a project in a participatory way. The participants split into three groups and each group developed a problem/solutions tree for their project (respectively waste management on municipal level, improving livestock to increase milk production in Algeria and a public infrastructure project). They then used this information to develop their project in Logframer, including the identification of target groups, risk management, setting up the monitoring and evaluation framework, planning of the activities and determining the budget.

The problem tree carries fruit: a banana

It was a very interesting experience for me, as this was the first time I saw Logframer in action in a university setting (although I know there are various courses given by universities worldwide on project management where Logframer is used). We also discussed the posibilities to use Logframer for research projects, risk management in aviation design/production and students' projects.

At the end of the project the participants expressed their great satisfaction with the training and with Logframer, and I too was very content and grateful for the experience.

If you are interested in organising a similar workshop, feel free to contact me using the contact form

Update of Logframer 3.1

A couple of users contacted me with a complaint about the Logframe window in the current version 3.1 of Logframer. If you move (or copy) items such as objectives or indicators, the programme often comes to a halt and you get an error report. The only thing you can do afterwards is to restart Logframer.

Logframer 3.1 error

This is of course very annoying. It took me a bit of time to get at the bottom of this, but I believe I managed to solve this problem. So I made a new build of Logframer 3.1 which is now available to download.

To install the new build, it's best to remove Logframer 3.1 from your computer first. In Windows 10 you can press the Windows key and the X key simultaneously (or else open the Start menu, click Settings and then click on System) and then select Apps and Features. Then look for Logframer 3.1 in the list and click on the name of the application. Finally click the Remove button.

Then visit the download page on this site (https://www.logframer.eu/content/download) and click the green download and install button.

Meanwhile I'm making good progress on version 4.0 of Logframer, which I hope to release later this year. The focus of this new version will be on collaborative project design. More info and screen shots of the new version will follow in a later blog post.

Logframer 3.1 is out (y disponible en español)

Project managers beware! I have opened the cage and just released Logframer 3.1 out in the wild!

The main feature of version 3.1 is the Spanish interface. After many requests from Spanish speaking users and hours of unpaid slave labour by a crack team of Spanish-speaking volunteers, we were finally able to introduce the Spanish user interface. So now Logframer is fluent in five languages: English, French, German, Dutch and Spanish - unlike its creator who is barely able to order a meal in Spanish.Facilidev Logframer 3.1

This is a minor upgrade from version 3.0, so apart from the Spanish user interface there weren't a lot of new things introduced this time. However if you're using a previous version of Logframer it does merrit to download and install version 3.1 because I got rid of some very pesky bugs. The most annoying one (and the most difficult one to get rid of) was the problem of Logframer freezing completely when you minimised the window. This one proved to be a veritable Sherlock Holmes mystery: every time I thought I had found and eradicated the culprit code, the bug escaped again. Finally I tracked it down to a plug-in I use, which just goes to show that you're always better off coding it yourself. Other problems that were ironed out were related to the import and export to and from Excel and to the IATI format. Many people also found that Logframer 3.0 produced an error when you added or edited an indicator or an assumption. This had to do with the ability to create multi-lingual logframes (same logframe available in different languages) that was introduced in version 3.0

Thanks to the uses who warned me about these problems. I try and test as much as possible but invariably there are always things that escape me. Your feedback on bugs or errors in the translations is always very helpful.

Other great news - although you may have to wait a bit for this one - is that I have invested in a code signing certificate. In the short run this means more security for you as you can now be completely sure that the code you download is the code I published and no-one has tampered with it. On the long run it's even better news because you won't get these annoying Windows SmartScreen messages anymore warning you about unknown code. However, SmartScreen will only know that Logframer is save if enough people pay no attention to its warnings when they install and run Logframer for the first time. So in the coming weeks you'll probably still get this warning, but in time it will disappear (if not I demand a refund!)

Meanwhile I am already working on the next big step in the form of Logframer 4.0. This will again be a major upgrade with spectacular new abilities, so stay tuned!

And now hurry up to the download page!

Installation problem

If you have tried to install Logframer recently you may have experienced a problem. The installation file would download but then the actual installation file would come to a halt.

Thanks to a warning from user Alex this problem has now been solved and the installation process should now run smoothly again.

Sincere apologies to all those who were unable to download Logframer, I hope you'll give it another try.

IATI part II – Does IATI provides us with a better understanding of aid flows?

In the previous article we introduced the International Aid Transparency Initiative and why it was created. We also saw the birth of the IATI standard for information and how it evolved over the past couple of years. But how does this work? Who releases this information and where can you find it?

The central element in the IATI concept is the Registry. This is where you can find all the organisations that publish information in IATI format (the publishers), as well as their activities (projects or programmes; providing funding or credit; etc.). The registry does not contain the actual information about development and humanitarian aid initiatives. Instead, it provides a list of organisations and for each organisation a list of the (XML) documents they have created and the location where you can download them. The actual IATI documents aren’t stored in the IATI Registry but can be found on the websites of the different government agencies, NGOs, volunteer groups, etc. that have joined the IATI initiative. While anyone can produce and share IATI documents, the Registry is what enables people or organisations all over the world to find that information.

The Data section on the IATI website

The Registry is the foundation of IATI and as such it allows you to find information. However, hopping from one website to the other to open IATI documents can be tedious and each file will only tell you what that specific organisation does. To get an overview of what is done by different donor countries or what happens in a specific country or region (activities of different organisations), you can use the Datastore. The Datastore uses internet robots that visit the websites of the registered organisations, read the information from their IATI documents and bring it all together in a database that you can query.

Another instrument to explore IATI data in a more visual way is D-portal. This tool is still in a development phase and tries to explore the different possibilities to learn from the IATI data.

IATI's goal is that any person or organisation would be able to understand what is happening in a certain country or area at a given time, who is doing what and where the funds are coming from. Ideally, you would be able to follow the aid streams from donor countries and organisations via intermediary NGOs or other aid actors to their final destinations. However at the moment we’re still far from this goal.

First of all, there are still many gaps in the overall picture. Although there is a growing number of (donor) organisations that publish their data, for now it’s only a small percentage of the overall aid industry. Also every organisation publishes what they are doing. So if you have donor A that funds NGO B who sends it to partner NGO C who then uses it to build hospitals, you only get a complete picture if all three organisations that are involved participate in IATI and publish their data. If A and C do but B doesn’t, there’s a gap. When I was at a presentation about IATI two years ago I asked how many publishers come from donor countries and how many from receiving countries. The answer was that about 80% of participating organisations come from donor countries where publication was obliged, about 10% for receiving countries and 10% from other countries. So you’ll find quite a lot of information about government agencies and NGOs from rich countries but very little from the receiving countries. One important reason for this situation is that in a number of donor countries (UK, Finland, the Netherlands…) NGOs and other aid actors are obliged by law to publish IATI files.

Also there is no minimum standard as to the content or the quality of the actual IATI documents. So an organisation may publish documents at regular intervals, but that doesn’t mean there is a lot of information to be found in those files. There are many IATI activity files that contain little more than the title, duration and overall budget of the project.

A key element in the financial transparency of IATI are the transactions: in every IATI activity file there are a number of transactions from the organisation that publishes the data to other organisations. Transactions are typically grants or subsidies but can also be credits and repayments or other types of financial flows. As each organisation has its own unique IATI identifier, you can see how money flows from one organisation to another. The identifiers should allow you to trace money from one organisation to the other.

However you must use a lot of caution when you use these figures. For one thing the transferring and the recipient organisation may register these transfers in different ways (taking or not taking into account administrative costs for example). They may group various effective transactions in one reported transaction at the end of the year to make reporting easier. And most importantly: it is not because a transaction is made in a specific year that all this money is also spent during that same year. So it is important to understand that IATI is not a global bookkeeping system for international aid. You can’t simply add up figures of various projects in recipient countries and expect them to correspond with the total transfers that the donor countries have reported in a given year.

So what a researcher, journalist or interested citizen can expect is to get a clearer picture based on indicative figures – if the information is indeed available (no gaps) and sufficiently detailed. From the side of the recipient countries, if a mayor or politician wants to find out what organisation X is actually doing on their territory (because sadly NGOs don’t find it necessary to inform local authorities) it can be quite the task to actually find information. That is because at the moment people are mainly obsessed by getting their data published, so you have a number of tools to create IATI files. But there aren’t so many tools that allow you to analyse and make sense of it all – especially if you don’t have the technical know-how to query a database.

In this IATI shows that it is still a relatively young system – although there is progress in this respect. But we can only expect improvement if better analysis tools are developed and if more and more organisations start contributing to global transparency – on the condition that they also provide quality information. What it takes for an organisation to join this global quest for aid transparency we’ll see in the next article.

IATI part I – What is the International Aid Transparency Initiative?

Recently I released Logframer 3.0 which has as one of its main features the ability to read, create and edit IATI documents. IATI stands for ‘International Aid Transparency Initiative’ and is a global attempt to make aid delivery and the fight against poverty more effective through the sharing of information. IATI isn’t the first attempt in this direction: you may have heard of CEFDA (Common Exchange Format for Development Activities) and IDML (International Development Markup Language) that was used in the AidData database.

The initiative to develop IATI as an information standard to share data about development activities grew out of the Accra High Level Forum on Aid Effectiveness (2008). The idea then was to have a set of standards by which international donors could be evaluated in their pursuit of the Millennium Development Goals. An initial group of fourteen international donors signed an agreement to create the International Aid Transparency Initiative, which had as its first task to develop a common format for sharing information on aid streams. The first version of the standard (1.01) was developed after consultation with aid donors, governments and NGOs from all over the globe and officially released in Paris in 2011. Since then, a growing number of governments, foundations, NGOs, international governmental organisations such as UNDP and World Bank etc. have been publishing data on their activities in the IATI format. Since the official launch of the first version of the standard there have been a number of improvements, each made after consultation with the publishing organisations, which have led to various updates of the standard. Version 1.01 was followed by 1.02, 1.03, 1.04 and 1.05 and then a major upgrade followed to version 2.01. This led to version 2.02 which is currently in use and at the moment the consultation round is going on in preparation of version 2.03.

So after this evolution over the past six years, what is IATI currently trying to achieve?

The main focus of IATI is to provide a good overview of what kind of aid is delivered (or will be delivered) at different places by different actors. These actors can include governments of both the donor and recipient countries, international NGOs, local NGOs, companies, non-profit organisations, faith-based organisations, individual initiatives...

The hope and expectation is that this overview will lead to a common strategy and vision so that different initiatives work complementary to each other and reinforce each other. This is necessary for instance to avoid that everyone starts working on the same spot, hindering each other and pouring too many resources in one location, while people in other locations remain in dire need for assistance. This would lead to a more coordinated effort that will make aid delivery to a country or region more effective.

This aid transparency must also benefit the recipient countries. In order to enable developing countries to coordinate and plan the different efforts that will take place in their territory, it is vital that they know who wants to do what where and when. At the moment this is very difficult, as there are many sources of information and not every organisation informs local authorities about what they want to do - although in some countries there may be very good reasons to avoid government interference.

The second main goal of aid transparency is to offer citizens, civil society organisations, journalists, scientists, etc. information about where the funds - provided by government agencies or by private donations - go to. Who is involved in the transferring and spending of this money? Where does it end up? What did it buy? Who received it? What changes did it bring about? Were the projects successful?

The common information exchange standard developed by IATI makes this exchange of information possible. Since its release it has become THE internationally agreed standard of information exchange about aid delivery. In 2016 a total of 473 organisations (government and private donors, international institutions (UN, EU…), non-profit organisations etc.) have published information about their projects and activities in the IATI format.

When organisations publish information about their activities following the IATI standard, this information is structured in a specific way so that both the software at the sending and the receiving end agree about where to find the title of the project, the financial information, the location of the project, the results of the project and so on.

Technically, a document published in the IATI standard is a XML document (similar to HTML which is used to create web pages) and it lists a number of field names. Each field contains text or a value (we’ll go deeper into the technicalities of the standard in a future article). In essence, these XML documents are text documents that can be created with different instruments: an ordinary word processor, special Excel templates, specialised software (including Logframer) or web services that publish data from an organisation's database directly into the format.

These IATI documents then have to be published on a public location – normally the organisation’s website – and then they must be registered in the IATI Registry. This serves as a big list that allows anyone to see what information is available for which organisation in a specific country or region. If you want to see that information, you can download the IATI file of your choice and go through the information. There are also a number of tools to help you search, get lists of basic information and analyse – but more on that in the next article.



Logframer by the Numbers - 31000 Downloads and Counting

Logframer 3.0 is out and it's the sixth version in total. So how is this project going?

Well of course monitoring is important for any project and I wouldn't be allowed to call myself a M&E expert if I hadn't devised a monitoring system for Logframer as well. So here are some of the main results


Logframer has been downloaded and installed over 31000 times

Since its launch in May 2013 (four years ago), Logframer has been downloaded more than 31000 times. That is pretty huge for specialist software aimed at project managers in international assistance.

Logframer download stats

As you can see in the chart, most people use the logframer.eu site (some 25.000 downloads in total - the blue line). Logframer is also available from a number of download sites such as Softpedia, Download.com, FindMySoft, FileCluster, etc. For my stats I track seven to eight of the more popular ones, but there are many more mirror sites out there that are not included in this list. (Beware for some mirror sites because they lure you in with free software and gain money by including all kinds of unwanted applications in their download files).

You can see the dramatic jump since November 2016, when version 2.0 was released. This was by far the most popular version:

Average monthly download

In defense of version 1.3: it had to keep the fire going for two years while I completely revised the code and developed version 2.0. But still, version 2.0 managed to get more downloads in half a year than its older brother did in two years:

Downloads of each version

With Logframer 2.0's excellent results and the release of version 3.0 a couple of weeks ago, it's clear that 2017 is going to be a record year:

Total download figures per year

The number of downloads for the first six months (well almost; the first five-and-a-half-months) of 2017 are almost as high as the total number of downloads for 2016 - which was a record-breaking year.


People from all over the world use Logframer

When I started working on Logframer my hope was that it would be a useful tool for grassroots organisations as well as larger organisations and that it would be used in developing countries and donor countries alike. And this is the case, as you can see in the map below:

People from all over the world visit the site (the map shows the number of visitors per country, not the number of downloads). People of Greenland and Turkmenistan are not fond of project management and I urgently have to send an e-mail to the five people in North Korea that are allowed to use a computer about what a great application it is.

The top twenty of visitor countries shows a nice mix of people from developing and donor countries:

1 India 11 Belgium
2 United States 12 Indonesia
3 France 13 Bangladesh
4 Kenya 14 Ethiopia
5 United Kingdom 15 Italy
6 Philippines 16 South Africa
7 Canada 17 Germany
8 Pakistan 18 Nepal
9 Australia 19 Nigeria
10 The Netherlands 20 Uganda

So all in all I'm quite happy with these figures so far, which exceed my expectations by some margin. I hope Logframer 3.0 will have a bright future and also that Logframer will attrackt more people from Spanish speaking countries once the interface has been translated.


Logframer 3.0 preview

The official launch of version 3.0 of Logframer isn't too far off now, it's a matter of days now. So it's high time for the traditional preview of the new features of this version.

Originally, version 3.0 was supposed to be version 2.1 - meaning that it was supposed a minor upgrade instead of a major new version. But well, one thing led to another and before I knew it I had made so many changes that I figured it made more sense to release it as a new major update.

The one thing that led to many others was the ability to read and create IATI activity and organisation documents. IATI is the International Aid Transparency Initiative: it aims to clarify where aid money comes from and where and how it is spent. Amongst other things, this will empower local governments who will have a better understanding and overview of the aid that is coming their way or that has already been delivered in their country. But IATI also aims to inform the public at large, journalists, researchers, etc. To enable this exchange of information, IATI has created an information standard, i.e. a way of presenting information in a standardised, digital format. In some countries, NGOs are required by their respective governments to produce IATI activity files about all their projects as well as annual reports about the funding of the organisation as a whole.

IATI is picking up speed, but there aren't a lot of tools to produce IATI compliant files. But now Logframer can create such files, and the best thing is that you don't have to do anything particularly complicated: just develop your project in Logframer, push a button and presto! Your IATI activity file is ready for publication!

Create an IATI activity file or organisation file at the push of a button

The great thing is that unlike most other tools, you don't need to copy-paste all that information from your project from the project's documentation into the tool.

To make sure all the information required by IATI can be developed in Logframer, a number of changes had to be made to the Project Information window. The bulk of the changes can be found here:

The new Project Information window

In the new Description tab you can indicate the phase your project's in. Content-wise you can indicate what type of project this is, what sectors it deals with and provide a short (or long) description of the project and the context you're working in.

Another improvement in this version of Logframer is the inclusion of (dynamic) maps. You can indicate the location of your intervention zones, target groups and (partners') offices on Bing Maps.

Draw a rectangle, circle or polygon around an area

Another new addition is the Funding tab. You can list funding sources, add information about budget lines and calls for proposals, make a list of contractual obligations such as deadlines for reporting, external audits & evaluations, etc.

A key element in aid transparency is to provide information about transactions and show how money moves from the donor to the NGO to its partners to beneficiaries in the field.

Information about a transfer from HQ to a field office

What struck me when I first learned about IATI is how much information the Activity standard shares with the Logframer object model - in fact this was the reason why I started to add this capability of producing IATI files in the first place. But there is of course also information that is specific for aid transparency, which can be found in the IATI specific tab

A main worry was that the novice user of Logframer, or someone who just wants to create a (simple) project, would get lost in all these additional fields aiming for aid transparency. Logframer is not only used by NGO people but also by businesses, non-profits in other fields than international assistance, various government agencies, etc. So an important new addition was the introduction of view modes. Logframer now has four view modes:

  • Basic view mode: this focuses on the main elements: the logframe, planning and budget along with the short description of your project; the identification of your target groups and partners; and the planning of your monitoring. By default the detail panes are hidden but you can show them by pressing <Ctrl><D>.
  • Advanced view mode: in this mode you can include all kinds of detailed information about your project, including the location of intervention zones and the funding sources for your project. Some dialog windows and panes also offer more information. IATI-specific information is not shown.
  • IATI activity: in addition to all the options of the advanced view mode, this mode adds fields and lists to include information that you may need to make a report compliant to International Aid Transparency Initiative (IATI) standards.
  • IATI organisation: this mode allows you to create the (yearly) IATI organisation report. It focuses on the expenses of your organisation during the past (three) years and your budgetary forecast for the next (three) years.

The view mode can be found in the File toolbar. The File toolbar of version 2.0 was split up in a modified File toolbar and a new Reports toolbar:

The new File toolbar in 'Basic' view mode

The new Reports toolbar

You may notice the 'My organisation' button in the File toolbar. You can now create a separate file with information about your organisation that Logframer loads every time you start the application. You can use this information in your various projects - in fact your organisation is automatically added as the lead organisation in the list of partner organisations. You can also add a link to a picture file with your logo, which will consequently appear in the interface (see the Facilidev logo above in the Project Information window).

The My Organisation dialog window allows you to include your own logo

You can then include this information in the headers and/or footers of your reports

As said earlier, most of the changes can be found in the Project Information window. Some minor improvements were made in the logframe, planning and budget windows - mainly removing some bugs found by users since the release of version 2.0. However when you use Logframer to create an IATI organisation file, not only do you need to be able to provide your organisation's budget but also an overview of its expenses over the past couple of years. A new Expenses window was added to the interface, but it is only available when you work in IATI organisation mode:

The expenses window

Last but not least, you can use Logframer in a new language. Logframer 3.0 is also available in German thanks to the efforts of a group of volunteers from Applicatio Training and Management in Hamburg. A big thank you to this team.

Stay tuned for the official release of version 3.0 in a couple of days!