Preparing the electronic version of the SEC Calendar and Lectionary

SEC calendar in Excel
SEC calendar readings being compiled in Microsoft Excel 2010

Update

Calendar and Lectionary 2010-2011 now available to download.

Original post

The Calendar and Lectionary of the Scottish Episcopal Church is a document that offers two things:

  1. A list of all saints days throughout the year.
  2. Readings for Sundays, weekdays, festivals (saints’ days) and special occasions (both Eucharists and daily prayer).

Each year the Church produces a guide to the calendar and lectionary which keeps mortals like you and me correct.  The Sunday readings are on a 3 year cycle (next year is Year A), while the daily prayer readings and daily Eucharists are on a 2 year cycle (next year is Year 1).

Once you add in saints’ days, and start translating saints days to adjacent days because they clash with feast days of a higher order, it all begins to get a bit complicated.

Outlook

Since 2005 I’ve provided these dates and readings (in various degrees of completeness) in a digital format that allows users to import them directly into Microsoft Outlook.  Outlook requires a simple Comma Separated Values (CSV) file which can be prepared in Microsoft Excel (other spreadsheet applications are available) with the appropriate information in them:

  • Subject (The name of the day)
  • Start and end date
  • Start and end time
  • Whether it’s an all day event or not
  • Description (Readings)
  • Priority
  • Sensitivity
  • Show time as

For the last few weeks I’ve been preparing the files, sitting for hours in front of my computer typing in line after line of readings.

Getting prepared

Most years I do it in a bit of a last-minute panic and end up creating a bespoke file specifically for that year, but this year I wanted to be organised and produce something that can be used year after year.

So this year I’m creating a master Excel file that contains all the readings for each combination of three year and two year cycles:

  • A1 and A2
  • B1 and B2
  • C1 and C2

plus a comprehensive master list of saints’ days, which should in future enable me to compile the files in just a few days rather than 4-8 weeks as it does at the moment.

Progress

I’ve just finished entering all the readings for the entire church year—from the first Sunday of Advent to the Week of Proper 34 (Christ the King)—and tomorrow morning will start on the readings for festivals, common saints’ days and special occasions.

Then I’ll be ready to compile everything for this year.  For once I may even be done by the start of the church year (which is this coming Sunday, the first Sunday of Advent).

2 thoughts on “Preparing the electronic version of the SEC Calendar and Lectionary”

Leave a Reply

Your email address will not be published. Required fields are marked *