How long?

Whew… it’s past the middle of January and so it has been almost five months!  What?  Yep, five months since I said “yes” to our District Superintendent and became a ‘Lay Supply Pastor’ for West Springfield United Methodist Church (WSUMC).   My wife asked me just before Christmas, “Well, what do you think?  Are you enjoying it?”  My reply, “I come home happy each day I am there.”  What more can anyone ask?

So the specifics might be important.  First, for me this is a voluntary, uncompensated position.  It’s also technically a ‘quarter-time’ posting.  That is supposed to mean I am involved with my church only 12 – 14 hours per week, on average.   To try to make this work, and to keep my sanity and spiritual center, I lead Sunday service (i.e. preach, etc.)  3 out of every 5 Sundays, more or less.  I will tell you my first, early discovery, it takes 5 to 8 hours of preparation for each time I lead a Sunday service.  So, if I were to lead every Sunday, well that’s all I could do.

WSUMC, any church really, needs more than just Sunday service.  Someone is in hospital and needs a pastoral visit, someone cannot come to church and would like to receive communion, are the books OK, is it time to review the other staff… and that’s just a sprinkling of activities that only keep the church in stasis.  I am reading a wonderful book “Can You Just Get Them Through Until Christmas?” by Pastor Margie Briggs.  ( find out more about her book here ) and when I read her inspiring words I wonder “How on earth can she do this as 1/4 time for each church?”

It does lead me to thinking about our Methodist organization and about startups.  Yes, startups.  You see before I came to ministry I had been in Information Technology (IT) and had my own company, had worked to turn around several companies, had worked inside several companies to turn around groups, and in every case there was a requirement not to reduce the level of effort but in many cases to apply a multiplier of effort, double, maybe ten times, to get the organization back on course.  I was mostly successful or rather I was most successful when there was a good reason to invest in the organization and there was a clear goal.

Within our New England Conference there seems to be a retreat mentality, a level of defeat-in-place sometimes.  Before coming to WSUMC I had heard about the troubles the church was having, how awful it was.  When I got there, imagine my surprise when I found a burning passion for the church, a deep love of God, a caring community of faith.  Yes, they are small but Christ built a church with just 12 people and no money.

Right now WSUMC and I are trying to find a mission, a goal if you well that is tangible, that people can see, feel, touch, and build towards.  In reading Margie’s book I saw two tiny churches, churches with no money and only a few people set forth an ambitious goal for themselves and then go.  Notice I did not say ‘grow’ but ‘go’ because ‘growth’ is not a goal.

We’ll see what happens next.

Something New

“So Rick, there’s something I’d like to talk to you about.  How would you like to get your feet wet by becoming a pastor at a church?”

I have to admit, I was a bit shocked with the call.  I had started “answering the call” about exploring becoming a pastor, in Methodist terms a “local pastor,” a process that starts with a slow progression of studies, an appearance in front of a committee and then, a bunch of studying resulting eventually in being appointed.  No, this was going to skip all that, it was in Monopoly parlance the same as drawing a ‘go directly to a church, do not pass go, do not collect $200’ card.

Maybe what was even more shocking was that I said “yes” which explains why I am sitting here in the pastor’s office, correction, my office, waiting for a church council meeting.  Yes, it’s me, Pastor Rick, the pastor at West Springfield United Methodist Church, Massachusetts.

I’ve served for four Sundays so far, including two with communion.  I am still getting used to the whole idea but have come to accept that if this is what God wants, well who am I to argue?  It’s funny, last night I went to a district meeting with my pastor, Rev. Joy from Hope UMC.  As we were walking in we were joking and at one point she said “hey, you were the one that chose to leave.”  I thought about that comment later in the evening and if I had been a little fast, a little more quick on the response I suppose I should have said, “it wasn’t me, I was sent.”  You see, that’s how this kind of works in Methodism.  In fact our bishop talked about the ‘DNA’ of the Methodists includes being sent by your church.  When I decided to ‘answer my call’ I presented myself to the congregation at my church and they ‘sent’ me on my way (of course they, me, and Julie all thought that would take a bit longer than it did!).

SO, the clock is ticking, I need to get things ready, here at my church.

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.