Open Source vs. Free

I am working with a group of developers who have built a Laboratory Information Management System (LIMS) based on the Open Source principle.  I spent a lot of time researching the availability of inexpensive, flexible LIMS that we might deploy as part of the project in Liberia.  There were about 30 variants of Open Source LIMS and about half that many commercial versions including some SAAS.

Recently there’s been a blog that was brought to my attention about the ‘cost’ of an Open Source solution.  The blog was focused on LIMS and so it was worth reading.  The author came to a similar conclusion that I did about open source LIMS in general, in that there have been very few successes.  Of the 30 or so I looked at most had been abandoned after the grad student left the institution where they worked or the organization’s funding stream evaporated or the single author decided to pull the plug and abandon the effort.  There are a few that continue including the one I selected for our project in Liberia, Bika.Lims and Bika.Health.   I’ll cover that selection process in some other posting.

What I wanted to focus on here was the disconnect between ‘free software’ and an ‘open source based solution’ which I think the blog author missed.  The blog author’s point was that the bulk of the cost of a system implementation of something as complex as a LIMS isn’t in the cost of the software but rather in the cost of implementation.  In general, the author got that part correct.  Implementation of any system involves a lot of challenges, a lot of people, and a lot of costs.   The actual cost of the software license for a piece of commercial software may be a fraction of the overall cost of implementation when you factor all the labor for training, physical implementation, support networks, etc., etc.  The point is well taken but may miss one of the really important issues around Open Source, namely flexibility.

Let’s take the work I am doing in Liberia right now.  We have very difficult circumstances for our deployment.  We have a very tight budget, difficult environment (poor power, lack of internet, no air conditioning, low computer literacy rates, etc., etc….), lack of continuation funding, and a challenging model to try to fit the LIMS into.  Liberia is recovering from two civil wars and the horrendous Ebola outbreak.  The outbreak exposed the poor health care system within the country and was a wake-up call to the rest of the world at what a risk that puts everyone in.

The LIMS that was needed had to be able to operate in this environment.  It also had to be tailor-able, it had to be able to be adapted to the specific needs of the health care system of Liberia. Most importantly, it had to be sustainable.  When I evaluated commercial applications for LIMS what I found were very sophisticated systems, a fairly high startup cost, a high annual support cost, and an inflexible system.   Given that both an ‘Open Source’ and a ‘Commercial Licensed’ software package would have the same implementation costs (i.e. the training, etc. I mentioned earlier), the cost associated with licensing and annual updates/support was a significant factor in my decision making.  Why?  Because I knew we had to customize the software to make it fit for Liberia.  Even if the commercial system vendor would agree to do the customization, that cost would be above the cost of licensing.   What if instead, I could take those costs for software (LIMS, database, operating systems, etc.) and instead apply that budget line item to customization?   To go even further, what if instead of paying licensing fees I instead took some of that money to train local Liberian’s on how to customize the LIMS and become contributors to the Open Source project itself?

In fact that is what we are doing.  We selected the Open Source Bika.Health platform not just for its functionality, its zero cost for licensing, and its developer network but also because it is Open Source, meaning it is growing and accepts contributions to the software from developers around the world trying to solve problems.  Additionally being Open Source meant we were allowed, actually encouraged to experiment with the software, with the platform it runs on, with pretty much everything to make it work for Liberia.

Yes, we are incurring some additional costs in developing our own implementation for Liberia.  Yes, we do not have a corporation behind the software development adding new features (which we probably won’t use in Liberia anyway) and yes we have to think about support but we have to think about support anyway as the funding for running the LIMS is based on a grant and that grant will expire.  So focusing on that eventuality it became clear that if we can train Liberian staff to support and grow the system, to adapt and contribute to the project, then they may even become the regional experts on the project in West Africa and support others in implementation.

Yes, implementing a software system is not inexpensive, easy, or free and so you must be careful of what your actual objectives are.  Are they to deploy and run?  Are they to provide a quick win and then leave them in the lurch or are they to provide a tailored system that fits the current needs and the capabilities to grow that system themselves in the future.  If that’s the objective, then an Open Source solution might be exactly what is needed.

Why you should never use a spreadsheet in place of project management software

When you work in IT, especially as a systems engineer or manager you end up at some time in your life needing to run a project. If you have and/or if you ever went to college for business or IT management or to get some kind of project management certificate you probably ended up using MS Project. It is a good program, a really complex program. There are both single user and enterprise versions for teams. Unfortunately it is also expensive, Project Standard lists for $599 per license. Not exactly affordable for an NGO organization.

After searching around I noticed there are a bunch of online, web-based project management software as service systems out there. This might be a very good option for a team where you have reliable Internet capabilities but what about the requirement I have, the ability to work on the software no matter if I am working from my US office, here in Africa, or a 30,000 feet somewhere above the Atlantic Ocean?

I spent a lot of time examining the limited offerings that are out there and came up with one, Project Libre ( This product is not associated with the Libre Office group but an independent company that has as its focus an opensource desktop project and a paid web-service product.


So how good is the tool for project management. Well, it is not an exact knock-off of MS Project although it can import MS Project files according to documentation, I have not tried it. To test it I took our Bika.Health Laboratory Information System (LIS) implementation for the Ministry of Health in Liberia and built the project out. I needed to product a gantt chart and figured “well, I might as well build it right.” The interface is similar to Project, there are resources, there are tasks, it is easy to indent the tasks to make subset and milestones. Overall I’d say if you are comfortable with Project, within an hour you will be comfortable with Project Libre. Like MS Project, allocating resources is more art than science and Project Libre seems to follow the strategy of MS Project in much the same way. Interpreting the resource terminology took me a while (hours vs. days, availability, percent utilization) and I am still sure I over allocated half my resources (just like I used to in Project). I miss a simple zoom feature on the Gantt, there is one on the task bar but it is not granular enough. I still haven’t quite got printing a gannt across multiple pages right either but I think that’s more about me than the tool.

If I had to pay for Project Libre I’d give it a B+ as a replacement. If you factor that it costs nothing, then it is of course an ‘A.’ It is light years ahead of using a spreadsheet template simply because of the way it has integrated resources, a critical fail point for way too projects I have seen that mistakenly try to force Excel to be a project management tool.

A year without Windows (almost) – The applications

In our connected world it seems that you can do almost everything you need on a computer with just a browser.  Well, that’s what Google thought when they created their ‘Chrome’ O.S. and hardware vendors followed with a series of ‘Chrome books’ which were basically diskless netbooks.

That works great in a world where no matter where you are there is a connection via WiFi.  In my work in Liberia, well that just doesn’t really work at all.  Whether it is sitting in the cramped economy seat on another 11 hour flight or at the apartment in Monrovia or even our office, there just isn’t always a connection.

Of course Microsoft made their fortune on not only the Windows OS but also on the MS Office suite (which has gone the way of Chrome with connection requirements) and the big three applications that come with MS Office are: Word, Excel, and Power Point (I’ll get to Outlook and Access in another posting).   These application are the defacto norm for business, education, governments, etc.  and so without their equivalent capability Linux is D.O.A.

In 2014 I loaded the Libre Office suite of tools on my little Ubuntu Ace V5.   At first I was a bit confused by the interface, I thought the suite was a clone of MS Office.  No, it was a branch of Open Office and so it inherited the interface.  I am not saying the interface is bad, it was just like the big leap I needed to take from MS Office, which pretty much used the same legacy interface from MS Office 2000, to Office 2013 and now 360.  It was different, not bad.Example of Calc User Interface

Example of Calc User Interface

Word = Writer

I do a lot of writing, a lot of technical writing and when I used Word I used a lot of the features for constructing a document all the way from outlining to footnotes.  I never used the forms feature but I still managed to create my Masters Thesis in MS Word.   When I was at my work at Saint-Gobain I lead a team and we did a lot of collaborative writing and so markups, change tracking and comments were a big deal.  In 2014, when I started using LibreOffice Writer, there were some challenges including an annoying habit of freezing the PC requiring a hard reboot.  Turns out that was mostly a Ubuntu problem in memory management.  Anyway, the good news is that since 2015 I can say there is nothing I have found lacking in the Writer program.  True, some of the Windows fonts don’t quite match  but that’s true even for the Office version on a Mac, if you are careful it all works out.   Writer uses the open document standard as its norm but just as happily read and write in the XML DOCX format Microsoft uses.  No one will know you are using a free software program!

So, unless you are using some esoteric hidden capability or Word, you can probably do all of your work in Writer and never miss a beat.

Excel = Calc

When I came to work at the Medical School one of the big jobs I had to do was create an accounting system to track expenses by our staff and partners in Liberia.  Another big to-do was creating a payroll system that would allow for complete accountability, be run by people on the ground, and handle the complexities of Liberian Tax Law.  My prior experience with Calc in 2014 left me wondering if it was up to the task of some very quirky and complex V-lookups, and other strange calculations.  By the time I was doing this I was over the user interface issues and so I jumped in with both hands on the keyboard and started.

I can honestly say that I was able to create everything needed within Calc (even some very nice picots for reporting) and also able to save them out in Excel’s native format for exchange with others without an issue.  I still kept everything on my workstation in open document format, mostly because I had been burned by an earlier version of Calc, but never had any issues with exchanging spreadsheets between Excel and Calc.   It just works.  There are a few times still when for some reason the cursor gets lost, that may be due to the dual screens I am using.  Closing the workbook and reopening seems to fix it.

OK – long enough posting – I’ll cover PowerPoint on another posting.