Tuesday, November 15, 2011

This is what we are about.

What is your role in working for the Kingdom of God?  How much will you accomplish?

Bishop Ken Untener wrote the following prayer for Cardinal John Dearden in 1979:

It helps, now and then, to step back
and take a long view.

The kingdom is not only beyond our efforts,
it is even beyond our vision.

We accomplish in our lifetime only a tiny fraction
of the magnificent enterprise that is God's work.
Nothing we do is complete, which is a way of saying
that the kingdom always lies beyond us.
No statement says all that could be said.
No prayer fully expresses our faith.
No confession brings perfection.
No pastoral visit brings wholeness.
No program accomplishes the church's mission.
No set of goals and objectives includes everything.

This is what we are about.
We plant the seeds that one day will grow.
We water seeds already planted,
knowing that they hold future promise.

We lay foundations that will need further development.
We provide yeast that produces far beyond our capabilities.

We cannot do everything, and there is a sense of liberation
in realizing that.  This enables us to do something,
and to do it very well.  It may be incomplete,
but it is a beginning, a step along the way,
an opportunity for the Lord's grace to enter and do the rest.

We may never see the end results, but that is the difference
between the master builder and the worker.

We are workers, not master builders; ministers, not messiahs.

We are prophets of a future not our own.

When I am reminded of this prayer I know that I have been guilty of a pride that knows no bounds.  In working to accomplish something great for God here on earth, I have minimized the work of those who have come before me, those who will come after me, and most importantly, the work of the Lord himself.  If it is true, as Ronald Reagan suggested, that we are only as great as we are able to stand on the shoulders of the generations before us, then surely we owe everything to the great heroes of the faith from the day the foundations of the earth were laid up to the mentors who passed the torches to us.  I am not the master builder.

Indeed we have forgotten what it is all about, when we think that the next big initiative of our church's strategic plan will really get the church to where it needs to be, and change the community around it.  Surely we have lost the plot when we believe that we, as individuals, churches, organizations, or communities can change the world.  Truly, we are off the mark when we put our faith in a program or activity.

May we always remember our roles - as little hands and feet scurrying about trying to obey God.  Jesus said, "If you love me, you will obey what I command."  God alone is the master builder and messiah, who directs a mighty orchestra.  On this side the prophets, on that side the evangelists, now the servants, now the administrators.  Bring up the teachers, let the pastors lead the melody.  And now hear the shouts of the great cloud of witnesses, that awesome chorus of encouragers from ages past.  May we be encouraged today to stand firm in our oh-so-small, but vitally important, individual roles.

Wednesday, November 9, 2011

Merging Tables in Excel

If you're like me, you regularly come across complicated tasks in Excel that are not easily automated. I'm slowly learning more and more about the more powerful functions available in Excel, and usually with a little bit of researching and work, you can figure out most challenges.

My most recent one was merging two tables, where the column identifying the same person in each table wasn't identical. Each had people that weren't listed on the other. Searching online turned up no walkthroughs, only third-party plugins to Excel that cost in excess of $40. Not wanting to cost my employer money to perform this task, I kept working on it. Finally found a similar solution on this page (credit where credit is due) from an "Anne Troy":

http://forums.techguy.org/business-applications/139190-merging-tables-access.html

Here is the walkthrough, in my own words. Hopefully this is useful to somebody out there - I'm hoping Google picks it up in its search results to help others out there with this same challenge.

Make sure both tables are in the same Workbook in different Sheets.

Step One: Add rows from new sheet that don’t already exist in the Master

  1. Sort the Master sheet in ascending order by the identifying column
  2. Sort the new sheet in ascending order by the identifying column
  3. Define a name for the identifying column in the Master sheet – call it “Master”
  4. Add a column to the right of the new sheet
  5. Enter this formula, and copy down:
    =VLOOKUP(A2,Master,1,FALSE)
    Where A is the column that contains the identifying value and the first column in the Master area is the column with the same identifying value
  6. Sort by the new column so that all #N/A values come together
  7. Copy all the #N/A rows with only the identifying value into the Master sheet
  8. Delete the new column with the formula result

Step Two: Merge data into Master

  1. Re-sort the Master sheet in ascending order by the identifying column
  2. Re-sort the new sheet in ascending order by the identifying column
  3. Create a new column in the Master for the new data
  4. Define a name for the table to be merged into the Master – call it “MyData”
  5. Enter this formula in the new column in the Master and copy down:
    =IF(ISNA(VLOOKUP(A2,MyData,2,FALSE)),"",VLOOKUP(A2,MyData,2,FALSE))
    Where A is the column that contains the identifying value in the Master and the second column in the new data sheet contains the data that needs to be merged in
  6. Copy all cells, then paste over them using the Paste Special -> Values